Index: branches/APG_ES_Site/BW/APG_ES_Site/Processes/NSight/Site-Write/Feed/ReceivePaidDeliveryCutoff.process
===================================================================
diff -u -r230342 -r255408
--- branches/APG_ES_Site/BW/APG_ES_Site/Processes/NSight/Site-Write/Feed/ReceivePaidDeliveryCutoff.process	(.../ReceivePaidDeliveryCutoff.process)	(revision 230342)
+++ branches/APG_ES_Site/BW/APG_ES_Site/Processes/NSight/Site-Write/Feed/ReceivePaidDeliveryCutoff.process	(.../ReceivePaidDeliveryCutoff.process)	(revision 255408)
@@ -1,5 +1,5 @@
 <?xml version="1.0" encoding="UTF-8"?>
-<pd:ProcessDefinition xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:pfx="http://www.tibco.com/ns/no_namespace_schema_location/SharedResources/Schemas/NSight/jdecutoff.xsd" xmlns:pd="http://xmlns.tibco.com/bw/process/2003" xmlns:pfx2="http://www.genpt.com/schemas/GPC/NSight/Site.xsd" xmlns:ns="http://www.tibco.com/namespaces/tnt/plugins/jms" xmlns:BW="java://com.tibco.pe.core.JavaCustomXPATHFunctions" xmlns:ns12="http://www.tibco.com/CommonLE/Client/Schema/ClientInterface.xsd" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:ns2="http://www.tibco.com/namespaces/tnt/plugins/json" xmlns:tib="http://www.tibco.com/bw/xslt/custom-functions" xmlns:ns1="http://www.tibco.com/pe/DeployedVarsType" xmlns:ns3="http://www.tibco.com/pe/EngineTypes">
+<pd:ProcessDefinition xmlns:pfx="http://www.tibco.com/ns/no_namespace_schema_location/SharedResources/Schemas/NSight/jdecutoff.xsd" xmlns:pfx2="http://www.genpt.com/schemas/GPC/NSight/Site.xsd" xmlns:ns="http://www.tibco.com/namespaces/tnt/plugins/jms" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:ns2="http://www.tibco.com/namespaces/tnt/plugins/json" xmlns:tib="http://www.tibco.com/bw/xslt/custom-functions" xmlns:ns1="http://www.tibco.com/pe/DeployedVarsType" xmlns:ns4="http://www.tibco.com/pe/GenerateErrorActivity/InputSchema" xmlns:ns3="http://www.tibco.com/pe/EngineTypes" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:pd="http://xmlns.tibco.com/bw/process/2003" xmlns:BW="java://com.tibco.pe.core.JavaCustomXPATHFunctions" xmlns:ns12="http://www.tibco.com/CommonLE/Client/Schema/ClientInterface.xsd">
     <xsd:import namespace="http://www.tibco.com/ns/no_namespace_schema_location/SharedResources/Schemas/NSight/jdecutoff.xsd" schemaLocation="/SharedResources/Schemas/NSight/jdecutoff.xsd"/>
     <pd:name>Processes/NSight/Site-Write/Feed/ReceivePaidDeliveryCutoff.process</pd:name>
     <pd:startName>JMS Queue Receiver</pd:startName>
@@ -345,8 +345,8 @@
     <pd:activity name="Catch">
         <pd:type>com.tibco.pe.core.CatchActivity</pd:type>
         <pd:resourceType>ae.activities.catch</pd:resourceType>
-        <pd:x>426</pd:x>
-        <pd:y>387</pd:y>
+        <pd:x>882</pd:x>
+        <pd:y>398</pd:y>
         <pd:handler>true</pd:handler>
         <config>
             <catchAll>true</catchAll>
@@ -356,8 +356,8 @@
     <pd:activity name="SendException">
         <pd:type>com.tibco.pe.core.CallProcessActivity</pd:type>
         <pd:resourceType>ae.process.subprocess</pd:resourceType>
-        <pd:x>716</pd:x>
-        <pd:y>392</pd:y>
+        <pd:x>1021</pd:x>
+        <pd:y>395</pd:y>
         <config>
             <processName>/UtilityServices/Interface/SendException.process</processName>
         </config>
@@ -396,6 +396,39 @@
                         </ns12:StackTrace>
                     </ns12:ExceptionRequest>
                 </xsl:when>
+                <xsl:when test="exists($_error_SendToGCP/ActivityErrors)">
+                    <ns12:ExceptionRequest>
+                        <ns12:Header>
+                            <ns12:ApplicationID>
+                                <xsl:value-of select="$_globalVariables/ns1:GlobalVariables/Application_ID"/>
+                            </ns12:ApplicationID>
+                            <ns12:ComponentName>
+                                <xsl:value-of select="tib:substring-before-last(tib:substring-after-last(BW:getCurrentProcessName($_processContext/ns3:ProcessContext/ProcessId),'/'),'.process')"/>
+                            </ns12:ComponentName>
+                            <ns12:Hostname>
+                                <xsl:value-of select="BW:getHostName()"/>
+                            </ns12:Hostname>
+                            <ns12:TransactionType>
+                                <xsl:value-of select="&quot;SITEFEED&quot;"/>
+                            </ns12:TransactionType>
+                            <ns12:InterfaceID>
+                                <xsl:value-of select="&quot;SITEFEED&quot;"/>
+                            </ns12:InterfaceID>
+                            <ns12:Message>
+                                <xsl:value-of select="&quot;JMS Exception when sending to GCP&quot;"/>
+                            </ns12:Message>
+                            <ns12:Transaction>
+                                <xsl:value-of select="$JMS-Queue-Receiver/ns:ActivityOutput/Body"/>
+                            </ns12:Transaction>
+                        </ns12:Header>
+                        <ns12:ExceptionCode>
+                            <xsl:value-of select="$_globalVariables/ns1:GlobalVariables/CommonLE/ExceptionCodes/Technical/JMSException"/>
+                        </ns12:ExceptionCode>
+                        <ns12:StackTrace>
+                            <xsl:value-of select="$_error/ns3:ErrorReport/StackTrace"/>
+                        </ns12:StackTrace>
+                    </ns12:ExceptionRequest>
+                </xsl:when>
                 <xsl:otherwise>
                     <ns12:ExceptionRequest>
                         <ns12:Header>
@@ -456,8 +489,8 @@
     <pd:activity name="LogJDE">
         <pd:type>com.tibco.pe.core.CallProcessActivity</pd:type>
         <pd:resourceType>ae.process.subprocess</pd:resourceType>
-        <pd:x>810</pd:x>
-        <pd:y>122</pd:y>
+        <pd:x>809</pd:x>
+        <pd:y>125</pd:y>
         <config>
             <processName>/UtilityServices/Interface/SendLog.process</processName>
             <spawn>true</spawn>
@@ -502,6 +535,34 @@
             </ns12:LogRequest>
         </pd:inputBindings>
     </pd:activity>
+    <pd:activity name="SendToGCP">
+        <pd:type>com.tibco.plugin.jms.JMSQueueSendActivity</pd:type>
+        <pd:resourceType>ae.activities.JMSQueueSendActivity</pd:resourceType>
+        <pd:x>584</pd:x>
+        <pd:y>371</pd:y>
+        <config>
+            <PermittedMessageType>Text</PermittedMessageType>
+            <SessionAttributes>
+                <transacted>false</transacted>
+                <acknowledgeMode>1</acknowledgeMode>
+                <maxSessions>1</maxSessions>
+            </SessionAttributes>
+            <ConfigurableHeaders>
+                <JMSDeliveryMode>PERSISTENT</JMSDeliveryMode>
+                <JMSExpiration>0</JMSExpiration>
+                <JMSPriority>4</JMSPriority>
+            </ConfigurableHeaders>
+            <DeliveryDelay>0</DeliveryDelay>
+            <ConnectionReference>/SharedResources/Connections/JMS/JMS-APP.sharedjmscon</ConnectionReference>
+        </config>
+        <pd:inputBindings>
+            <ns:ActivityInput>
+                <Body>
+                    <xsl:value-of select="$JMS-Queue-Receiver/ns:ActivityOutput/Body"/>
+                </Body>
+            </ns:ActivityInput>
+        </pd:inputBindings>
+    </pd:activity>
     <pd:transition>
         <pd:from>JMS Queue Receiver</pd:from>
         <pd:to>LogUpdateStart</pd:to>
@@ -521,7 +582,7 @@
         <pd:to>lookupsite</pd:to>
         <pd:lineType>Default</pd:lineType>
         <pd:lineColor>-16777216</pd:lineColor>
-        <pd:conditionType>always</pd:conditionType>
+        <pd:conditionType>otherwise</pd:conditionType>
     </pd:transition>
     <pd:transition>
         <pd:from>SendJDE</pd:from>
@@ -580,4 +641,19 @@
         <pd:lineColor>-16777216</pd:lineColor>
         <pd:conditionType>always</pd:conditionType>
     </pd:transition>
+    <pd:transition>
+        <pd:from>SiteDeliveryFeed</pd:from>
+        <pd:to>SendToGCP</pd:to>
+        <pd:lineType>Default</pd:lineType>
+        <pd:lineColor>-16777216</pd:lineColor>
+        <pd:conditionType>xpath</pd:conditionType>
+        <pd:xpath>$_globalVariables/ns1:GlobalVariables/InterfaceSpecific/GCP/SendUPSToGCP="true"</pd:xpath>
+    </pd:transition>
+    <pd:transition>
+        <pd:from>SendToGCP</pd:from>
+        <pd:to>lookupsite</pd:to>
+        <pd:lineType>Default</pd:lineType>
+        <pd:lineColor>-16777216</pd:lineColor>
+        <pd:conditionType>always</pd:conditionType>
+    </pd:transition>
 </pd:ProcessDefinition>
\ No newline at end of file
Index: branches/APG_ES_Site/BW/APG_ES_Site/defaultVars/InterfaceSpecific/GCP/defaultVars.substvar
===================================================================
diff -u -r255358 -r255408
--- branches/APG_ES_Site/BW/APG_ES_Site/defaultVars/InterfaceSpecific/GCP/defaultVars.substvar	(.../defaultVars.substvar)	(revision 255358)
+++ branches/APG_ES_Site/BW/APG_ES_Site/defaultVars/InterfaceSpecific/GCP/defaultVars.substvar	(.../defaultVars.substvar)	(revision 255408)
@@ -2,6 +2,14 @@
 <repository xmlns:xsi = "http://www.w3.org/2001/XMLSchema-instance" xmlns = "http://www.tibco.com/xmlns/repo/types/2002">
 	<globalVariables>
 		<globalVariable>
+			<name>Delivery_URI</name>
+			<value>no value</value>
+			<deploymentSettable>true</deploymentSettable>
+			<serviceSettable>false</serviceSettable>
+			<type>String</type>
+			<modTime>1713336216346</modTime>
+		</globalVariable>
+		<globalVariable>
 			<name>Host</name>
 			<value>no value</value>
 			<deploymentSettable>true</deploymentSettable>
@@ -42,6 +50,14 @@
 			<modTime>1713094231676</modTime>
 		</globalVariable>
 		<globalVariable>
+			<name>SendUPSToGCP</name>
+			<value>false</value>
+			<deploymentSettable>true</deploymentSettable>
+			<serviceSettable>false</serviceSettable>
+			<type>String</type>
+			<modTime>1713417881350</modTime>
+		</globalVariable>
+		<globalVariable>
 			<name>URI</name>
 			<value>no value</value>
 			<deploymentSettable>true</deploymentSettable>
Index: branches/APG_ES_Site/BW/APG_ES_Site/defaultVars/Destinations/Queues/defaultVars.substvar
===================================================================
diff -u -r255342 -r255408
--- branches/APG_ES_Site/BW/APG_ES_Site/defaultVars/Destinations/Queues/defaultVars.substvar	(.../defaultVars.substvar)	(revision 255342)
+++ branches/APG_ES_Site/BW/APG_ES_Site/defaultVars/Destinations/Queues/defaultVars.substvar	(.../defaultVars.substvar)	(revision 255408)
@@ -10,6 +10,22 @@
 			<modTime>1594229810614</modTime>
 		</globalVariable>
 		<globalVariable>
+			<name>GCPDeliveryFeedQueue</name>
+			<value>APG.NAM.GCP.DELIVERYFEED.Q.V10</value>
+			<deploymentSettable>true</deploymentSettable>
+			<serviceSettable>false</serviceSettable>
+			<type>String</type>
+			<modTime>1713339434538</modTime>
+		</globalVariable>
+		<globalVariable>
+			<name>GCPPaidDeliveryQueue</name>
+			<value>APG.NAM.GCP.PAIDCUTOFF.Q.V.10</value>
+			<deploymentSettable>true</deploymentSettable>
+			<serviceSettable>false</serviceSettable>
+			<type>String</type>
+			<modTime>1713418271644</modTime>
+		</globalVariable>
+		<globalVariable>
 			<name>GCPSiteFeedQueue</name>
 			<value>APG.NAM.SITEFEED.GCP.Q.V10</value>
 			<deploymentSettable>true</deploymentSettable>
@@ -159,7 +175,8 @@
 			<deploymentSettable>true</deploymentSettable>
 			<serviceSettable>false</serviceSettable>
 			<type>String</type>
-			<modTime>1527007786624</modTime>
+			<constraint></constraint>
+			<modTime>1713339434080</modTime>
 		</globalVariable>
 		<globalVariable>
 			<name>SiteSDGSyncDelete</name>
Index: branches/APG_ES_Site/BW/APG_ES_Site/Processes/NSight/Site-Write/Feed/Extract_PaidDelivery.process
===================================================================
diff -u
--- branches/APG_ES_Site/BW/APG_ES_Site/Processes/NSight/Site-Write/Feed/Extract_PaidDelivery.process	(revision 0)
+++ branches/APG_ES_Site/BW/APG_ES_Site/Processes/NSight/Site-Write/Feed/Extract_PaidDelivery.process	(revision 255408)
@@ -0,0 +1,634 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<pd:ProcessDefinition xmlns:pfx="xmlns.tibco.com/bw/plugin/cassandra/QueryActivity/Output" xmlns:pfx2="http://www.tibco.com/ns/no_namespace_schema_location/SharedResources/Schemas/NSight/jdecutoff.xsd" xmlns:ns="http://www.tibco.com/pe/DeployedVarsType" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:ns0="xmlns.tibco.com/bw/plugin/cassandra/QueryActivity/Input" xmlns:tib="http://www.tibco.com/bw/xslt/custom-functions" xmlns:ns2="http://schemas.tibco.com/bw/plugins/xml/5.0/RESTJSONExceptions" xmlns:ns1="http://www.tibco.com/pe/EngineTypes" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:pd="http://xmlns.tibco.com/bw/process/2003" xmlns:ns02="http://www.tibco.com/namespaces/tnt/plugins/json" xmlns:BW="java://com.tibco.pe.core.JavaCustomXPATHFunctions" xmlns:ns12="http://www.tibco.com/CommonLE/Client/Schema/ClientInterface.xsd">
+    <xsd:import namespace="http://www.tibco.com/ns/no_namespace_schema_location/SharedResources/Schemas/NSight/jdecutoff.xsd" schemaLocation="/SharedResources/Schemas/NSight/jdecutoff.xsd"/>
+    <pd:name>Processes/NSight/Site-Write/Feed/Extract_PaidDelivery.process</pd:name>
+    <pd:startName>JMS Queue Receiver</pd:startName>
+    <pd:startX>0</pd:startX>
+    <pd:startY>0</pd:startY>
+    <pd:returnBindings/>
+    <pd:starter name="JMS Queue Receiver">
+        <pd:type>com.tibco.plugin.jms.JMSQueueEventSource</pd:type>
+        <pd:resourceType>ae.activities.JMSQueueEventSource</pd:resourceType>
+        <pd:x>81</pd:x>
+        <pd:y>64</pd:y>
+        <config>
+            <PermittedMessageType>Text</PermittedMessageType>
+            <SessionAttributes>
+                <transacted>false</transacted>
+                <acknowledgeMode>1</acknowledgeMode>
+                <maxSessions>1</maxSessions>
+            </SessionAttributes>
+            <ConfigurableHeaders>
+                <JMSDeliveryMode>PERSISTENT</JMSDeliveryMode>
+                <JMSExpiration>0</JMSExpiration>
+                <JMSPriority>4</JMSPriority>
+            </ConfigurableHeaders>
+            <ConnectionReference>/SharedResources/Connections/JMS/JMS-APP.sharedjmscon</ConnectionReference>
+        </config>
+        <pd:inputBindings/>
+    </pd:starter>
+    <pd:endName>End</pd:endName>
+    <pd:endX>912</pd:endX>
+    <pd:endY>73</pd:endY>
+    <pd:errorSchemas/>
+    <pd:processVariables/>
+    <pd:targetNamespace>http://xmlns.example.com/1713259237963</pd:targetNamespace>
+    <pd:activity name="Query_deliverysource">
+        <pd:type>com.tibco.plugin.cassandra.inbound.QueryActivity</pd:type>
+        <pd:resourceType>ae.activities.CassandraQuery</pd:resourceType>
+        <pd:x>223</pd:x>
+        <pd:y>68</pd:y>
+        <config>
+            <RetryPolicy>EMPTY</RetryPolicy>
+            <ConsistencyLevel>EMPTY</ConsistencyLevel>
+            <Batch>false</Batch>
+            <ConnectionReference>/SharedResources/Connections/Cassandra/Cassandra-NSight.cassandraconn</ConnectionReference>
+            <Statement>select * from site_delivery_source allow filtering;</Statement>
+            <QueryOutput>
+                <row>
+                    <ParameterName>ship_from_site_identifier</ParameterName>
+                    <ParameterType>UUID</ParameterType>
+                    <ParameterCardinality>REQUIRED</ParameterCardinality>
+                </row>
+                <row>
+                    <ParameterName>delivery_service_type</ParameterName>
+                    <ParameterType>TEXT</ParameterType>
+                    <ParameterCardinality>REQUIRED</ParameterCardinality>
+                </row>
+                <row>
+                    <ParameterName>data_as_of_ts</ParameterName>
+                    <ParameterType>TIMESTAMP</ParameterType>
+                    <ParameterCardinality>REQUIRED</ParameterCardinality>
+                </row>
+                <row>
+                    <ParameterName>friday_cutoff_time</ParameterName>
+                    <ParameterType>TIME</ParameterType>
+                    <ParameterCardinality>OPTIONAL</ParameterCardinality>
+                </row>
+                <row>
+                    <ParameterName>monday_cutoff_time</ParameterName>
+                    <ParameterType>TIME</ParameterType>
+                    <ParameterCardinality>OPTIONAL</ParameterCardinality>
+                </row>
+                <row>
+                    <ParameterName>saturday_cutoff_time</ParameterName>
+                    <ParameterType>TIME</ParameterType>
+                    <ParameterCardinality>OPTIONAL</ParameterCardinality>
+                </row>
+                <row>
+                    <ParameterName>service_duration_designator</ParameterName>
+                    <ParameterType>TEXT</ParameterType>
+                    <ParameterCardinality>OPTIONAL</ParameterCardinality>
+                </row>
+                <row>
+                    <ParameterName>service_duration_max_value</ParameterName>
+                    <ParameterType>INT</ParameterType>
+                    <ParameterCardinality>OPTIONAL</ParameterCardinality>
+                </row>
+                <row>
+                    <ParameterName>service_duration_min_value</ParameterName>
+                    <ParameterType>INT</ParameterType>
+                    <ParameterCardinality>OPTIONAL</ParameterCardinality>
+                </row>
+                <row>
+                    <ParameterName>solr_query</ParameterName>
+                    <ParameterType>TEXT</ParameterType>
+                    <ParameterCardinality>OPTIONAL</ParameterCardinality>
+                </row>
+                <row>
+                    <ParameterName>sunday_cutoff_time</ParameterName>
+                    <ParameterType>TIME</ParameterType>
+                    <ParameterCardinality>OPTIONAL</ParameterCardinality>
+                </row>
+                <row>
+                    <ParameterName>thursday_cutoff_time</ParameterName>
+                    <ParameterType>TIME</ParameterType>
+                    <ParameterCardinality>OPTIONAL</ParameterCardinality>
+                </row>
+                <row>
+                    <ParameterName>tuesday_cutoff_time</ParameterName>
+                    <ParameterType>TIME</ParameterType>
+                    <ParameterCardinality>OPTIONAL</ParameterCardinality>
+                </row>
+                <row>
+                    <ParameterName>wednesday_cutoff_time</ParameterName>
+                    <ParameterType>TIME</ParameterType>
+                    <ParameterCardinality>OPTIONAL</ParameterCardinality>
+                </row>
+            </QueryOutput>
+        </config>
+        <pd:inputBindings/>
+    </pd:activity>
+    <pd:group name="Group">
+        <pd:type>com.tibco.pe.core.LoopGroup</pd:type>
+        <pd:resourceType>ae.process.group</pd:resourceType>
+        <pd:x>307</pd:x>
+        <pd:y>6</pd:y>
+        <pd:width>545</pd:width>
+        <pd:height>141</pd:height>
+        <pd:collapsedWidth>57</pd:collapsedWidth>
+        <pd:collapsedHeight>70</pd:collapsedHeight>
+        <pd:groupVariables/>
+        <pd:joinToggle>inherit</pd:joinToggle>
+        <config>
+            <pd:groupType>inputLoop</pd:groupType>
+            <pd:serializable>false</pd:serializable>
+            <pd:over>$Query_deliverysource/pfx:QueryActivityResult/Rows/Row</pd:over>
+            <pd:iterationElementSlot>iterdelivery</pd:iterationElementSlot>
+            <pd:indexSlot>index</pd:indexSlot>
+            <pd:activityOutputName/>
+            <pd:accumulateOutput>false</pd:accumulateOutput>
+        </config>
+        <pd:inputBindings/>
+        <pd:expanded>true</pd:expanded>
+        <pd:transition>
+            <pd:from>start</pd:from>
+            <pd:to>Query_Site</pd:to>
+            <pd:lineType>Default</pd:lineType>
+            <pd:lineColor>-16777216</pd:lineColor>
+            <pd:conditionType>always</pd:conditionType>
+        </pd:transition>
+        <pd:transition>
+            <pd:from>Send HTTP Request</pd:from>
+            <pd:to>end</pd:to>
+            <pd:lineType>Default</pd:lineType>
+            <pd:lineColor>-16777216</pd:lineColor>
+            <pd:conditionType>always</pd:conditionType>
+        </pd:transition>
+        <pd:transition>
+            <pd:from>Render JSON</pd:from>
+            <pd:to>Send HTTP Request</pd:to>
+            <pd:lineType>Default</pd:lineType>
+            <pd:lineColor>-16777216</pd:lineColor>
+            <pd:conditionType>always</pd:conditionType>
+        </pd:transition>
+        <pd:transition>
+            <pd:from>Query_Site</pd:from>
+            <pd:to>Render JSON</pd:to>
+            <pd:lineType>Default</pd:lineType>
+            <pd:lineColor>-16777216</pd:lineColor>
+            <pd:conditionType>always</pd:conditionType>
+        </pd:transition>
+        <pd:activity name="Render JSON">
+            <pd:type>com.tibco.plugin.json.activities.JSONRenderActivity</pd:type>
+            <pd:resourceType>ae.activities.JSONRenderActivity</pd:resourceType>
+            <pd:x>562</pd:x>
+            <pd:y>76</pd:y>
+            <config>
+                <SchemaType>xsdType</SchemaType>
+                <BadgerfishCheck>false</BadgerfishCheck>
+                <ActivityInputEditor ref="pfx2:JSON"/>
+            </config>
+            <pd:inputBindings>
+                <ns02:ActivityInputClass>
+                    <JSON>
+                        <Header>
+                            <Requestor>
+                                <requestorApplication>
+                                    <xsl:value-of select="&quot;Store Console&quot;"/>
+                                </requestorApplication>
+                            </Requestor>
+                            <Responder>
+                                <responderApplication>
+                                    <xsl:value-of select="&quot;NSight&quot;"/>
+                                </responderApplication>
+                            </Responder>
+                            <timestamp>
+                                <xsl:value-of select="tib:timestamp()"/>
+                            </timestamp>
+                            <xsl:choose>
+                                <xsl:when test="$Query_deliverysource/pfx:QueryActivityResult/Rows/Row/delivery_service_type=&quot;UPSGROUND&quot;">
+                                    <countryCode>
+                                        <xsl:value-of select="&quot;US&quot;"/>
+                                    </countryCode>
+                                </xsl:when>
+                                <xsl:otherwise>
+                                    <countryCode>
+                                        <xsl:value-of select="&quot;CA&quot;"/>
+                                    </countryCode>
+                                </xsl:otherwise>
+                            </xsl:choose>
+                            <languageCode>
+                                <xsl:value-of select="&quot;EN&quot;"/>
+                            </languageCode>
+                            <correlationId>
+                                <xsl:value-of select="tib:timestamp()"/>
+                            </correlationId>
+                        </Header>
+                        <Detail>
+                            <SiteDeliveryMatrix>
+                                <xsl:choose>
+                                    <xsl:when test="string-length($Query_Site/pfx:QueryActivityResult/Rows/Row[alias_name=&quot;DC Abbreviation Code&quot;]/alias_value)!=0">
+                                        <SourceSiteIdentifier>
+                                            <name>
+                                                <xsl:value-of select="&quot;DC Abbreviation Code&quot;"/>
+                                            </name>
+                                            <xsl:if test="$Query_Site/pfx:QueryActivityResult/Rows/Row[alias_name=&quot;DC Abbreviation Code&quot;]/alias_value">
+                                                <value>
+                                                    <xsl:value-of select="$Query_Site/pfx:QueryActivityResult/Rows/Row[alias_name=&quot;DC Abbreviation Code&quot;]/alias_value"/>
+                                                </value>
+                                            </xsl:if>
+                                        </SourceSiteIdentifier>
+                                    </xsl:when>
+                                    <xsl:when test="string-length($Query_Site/pfx:QueryActivityResult/Rows/Row[alias_name=&quot;9 Digit Store Number&quot;]/alias_value)!=0">
+                                        <SourceSiteIdentifier>
+                                            <name>
+                                                <xsl:value-of select="&quot;9 Digit Store Number&quot;"/>
+                                            </name>
+                                            <xsl:if test="$Query_Site/pfx:QueryActivityResult/Rows/Row[alias_name=&quot;9 Digit Store Number&quot;]/alias_value">
+                                                <value>
+                                                    <xsl:value-of select="$Query_Site/pfx:QueryActivityResult/Rows/Row[alias_name=&quot;9 Digit Store Number&quot;]/alias_value"/>
+                                                </value>
+                                            </xsl:if>
+                                        </SourceSiteIdentifier>
+                                    </xsl:when>
+                                    <xsl:otherwise>
+                                        <SourceSiteIdentifier>
+                                            <name>
+                                                <xsl:value-of select="&quot;Supplier Abbreviation Location&quot;"/>
+                                            </name>
+                                            <xsl:if test="$Query_Site/pfx:QueryActivityResult/Rows/Row[alias_name=&quot;Supplier Abbreviation Location&quot;]/alias_value">
+                                                <value>
+                                                    <xsl:value-of select="$Query_Site/pfx:QueryActivityResult/Rows/Row[alias_name=&quot;Supplier Abbreviation Location&quot;]/alias_value"/>
+                                                </value>
+                                            </xsl:if>
+                                        </SourceSiteIdentifier>
+                                    </xsl:otherwise>
+                                </xsl:choose>
+                                <deliveryServiceProvider>
+                                    <xsl:value-of select="&quot;&quot;"/>
+                                </deliveryServiceProvider>
+                                <deliveryServiceType>
+                                    <xsl:value-of select="$iterdelivery/Row/delivery_service_type"/>
+                                </deliveryServiceType>
+                                <mondayCutoffTime>
+                                    <xsl:value-of select="$iterdelivery/Row/monday_cutoff_time"/>
+                                </mondayCutoffTime>
+                                <tuesdayCutoffTime>
+                                    <xsl:value-of select="$iterdelivery/Row/tuesday_cutoff_time"/>
+                                </tuesdayCutoffTime>
+                                <wednesdayCutoffTime>
+                                    <xsl:value-of select="$iterdelivery/Row/wednesday_cutoff_time"/>
+                                </wednesdayCutoffTime>
+                                <thursdayCutoffTime>
+                                    <xsl:value-of select="$iterdelivery/Row/thursday_cutoff_time"/>
+                                </thursdayCutoffTime>
+                                <fridayCutoffTime>
+                                    <xsl:value-of select="$iterdelivery/Row/friday_cutoff_time"/>
+                                </fridayCutoffTime>
+                                <saturdayCutoffTime>
+                                    <xsl:value-of select="$iterdelivery/Row/saturday_cutoff_time"/>
+                                </saturdayCutoffTime>
+                                <sundayCutoffTime>
+                                    <xsl:value-of select="$iterdelivery/Row/sunday_cutoff_time"/>
+                                </sundayCutoffTime>
+                                <dataAsOfTimestamp>
+                                    <xsl:value-of select="tib:timestamp()"/>
+                                </dataAsOfTimestamp>
+                            </SiteDeliveryMatrix>
+                        </Detail>
+                    </JSON>
+                </ns02:ActivityInputClass>
+            </pd:inputBindings>
+        </pd:activity>
+        <pd:activity name="Send HTTP Request">
+            <pd:type>com.tibco.plugin.http.client.HttpRequestActivity</pd:type>
+            <pd:resourceType>httppalette.httpRequest</pd:resourceType>
+            <pd:x>739</pd:x>
+            <pd:y>73</pd:y>
+            <config>
+                <inputOutputVersion>5.3.0</inputOutputVersion>
+                <newMimeSupport>true</newMimeSupport>
+                <authScheme>NONE</authScheme>
+                <useSsl>true</useSsl>
+                <ns1:ssl xmlns:ns1="http://www.tibco.com/xmlns/aemeta/services/2002">
+                    <ns1:strongCipherSuitesOnly>false</ns1:strongCipherSuitesOnly>
+                    <ns1:cert isRef="true">%%BW_GLOBAL_TRUSTED_CA_STORE%%</ns1:cert>
+                </ns1:ssl>
+                <InputHeaders>
+                    <xsd:element name="root">
+                        <xsd:complexType>
+                            <xsd:sequence>
+                                <xsd:element name="Accept" type="xsd:string" minOccurs="0"/>
+                                <xsd:element name="Accept-Charset" type="xsd:string" minOccurs="0"/>
+                                <xsd:element name="Accept-Encoding" type="xsd:string" minOccurs="0"/>
+                                <xsd:element name="Content-Type" type="xsd:string" minOccurs="0"/>
+                                <xsd:element name="Cookie" type="xsd:string" minOccurs="0"/>
+                                <xsd:element name="Pragma" type="xsd:string" minOccurs="0"/>
+                            </xsd:sequence>
+                        </xsd:complexType>
+                    </xsd:element>
+                </InputHeaders>
+                <OutputHeaders>
+                    <xsd:element name="root">
+                        <xsd:complexType>
+                            <xsd:sequence>
+                                <xsd:element name="Allow" type="xsd:string" minOccurs="0"/>
+                                <xsd:element name="Content-Type" type="xsd:string" minOccurs="0"/>
+                                <xsd:element name="Content-Length" type="xsd:string" minOccurs="0"/>
+                                <xsd:element name="Content-Encoding" type="xsd:string" minOccurs="0"/>
+                                <xsd:element name="Date" type="xsd:string" minOccurs="0"/>
+                                <xsd:element name="Location" type="xsd:string" minOccurs="0"/>
+                                <xsd:element name="Set-Cookie" type="xsd:string" minOccurs="0"/>
+                                <xsd:element name="Pragma" type="xsd:string" minOccurs="0"/>
+                            </xsd:sequence>
+                        </xsd:complexType>
+                    </xsd:element>
+                </OutputHeaders>
+            </config>
+            <pd:inputBindings>
+                <RequestActivityInput>
+                    <Host>
+                        <xsl:value-of select="$_globalVariables/ns:GlobalVariables/InterfaceSpecific/GCP/Host"/>
+                    </Host>
+                    <Port>
+                        <xsl:value-of select="$_globalVariables/ns:GlobalVariables/InterfaceSpecific/GCP/Port"/>
+                    </Port>
+                    <Method>
+                        <xsl:value-of select="&quot;POST&quot;"/>
+                    </Method>
+                    <RequestURI>
+                        <xsl:value-of select="$_globalVariables/ns:GlobalVariables/InterfaceSpecific/GCP/Delivery_URI"/>
+                    </RequestURI>
+                    <PostData>
+                        <xsl:value-of select="$Render-JSON/ns02:ActivityOutputClass/jsonString"/>
+                    </PostData>
+                    <Timeout>
+                        <xsl:value-of select="$_globalVariables/ns:GlobalVariables/InterfaceSpecific/GCP/timeOut"/>
+                    </Timeout>
+                    <Headers>
+                        <Content-Type>
+                            <xsl:value-of select="&quot;application/json&quot;"/>
+                        </Content-Type>
+                    </Headers>
+                </RequestActivityInput>
+            </pd:inputBindings>
+        </pd:activity>
+        <pd:activity name="Query_Site">
+            <pd:type>com.tibco.plugin.cassandra.inbound.QueryActivity</pd:type>
+            <pd:resourceType>ae.activities.CassandraQuery</pd:resourceType>
+            <pd:x>403</pd:x>
+            <pd:y>77</pd:y>
+            <config>
+                <RetryPolicy>EMPTY</RetryPolicy>
+                <ConsistencyLevel>EMPTY</ConsistencyLevel>
+                <Batch>false</Batch>
+                <ConnectionReference>/SharedResources/Connections/Cassandra/Cassandra-NSight.cassandraconn</ConnectionReference>
+                <Statement>select alias_name,alias_value from site where site_identifier=? allow filtering;</Statement>
+                <InputParameters>
+                    <row>
+                        <ParameterName>site_identifier</ParameterName>
+                        <ParameterType>UUID</ParameterType>
+                        <ParameterCardinality>REQUIRED</ParameterCardinality>
+                    </row>
+                </InputParameters>
+                <QueryOutput>
+                    <row>
+                        <ParameterName>alias_name</ParameterName>
+                        <ParameterType>TEXT</ParameterType>
+                        <ParameterCardinality>REQUIRED</ParameterCardinality>
+                    </row>
+                    <row>
+                        <ParameterName>alias_value</ParameterName>
+                        <ParameterType>TEXT</ParameterType>
+                        <ParameterCardinality>REQUIRED</ParameterCardinality>
+                    </row>
+                </QueryOutput>
+            </config>
+            <pd:inputBindings>
+                <ns0:QueryActivityParameters>
+                    <InputParameters>
+                        <site_identifier>
+                            <xsl:value-of select="$iterdelivery/Row/ship_from_site_identifier"/>
+                        </site_identifier>
+                    </InputParameters>
+                </ns0:QueryActivityParameters>
+            </pd:inputBindings>
+        </pd:activity>
+    </pd:group>
+    <pd:activity name="SendException">
+        <pd:type>com.tibco.pe.core.CallProcessActivity</pd:type>
+        <pd:resourceType>ae.process.subprocess</pd:resourceType>
+        <pd:x>899</pd:x>
+        <pd:y>218</pd:y>
+        <config>
+            <processName>/UtilityServices/Interface/SendException.process</processName>
+            <spawn>true</spawn>
+        </config>
+        <pd:inputBindings>
+            <xsl:choose xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
+                <xsl:when test="exists($_error_Query_deliverysource/ActivityErrors)">
+                    <ns12:ExceptionRequest>
+                        <ns12:Header>
+                            <ns12:ApplicationID>
+                                <xsl:value-of select="$_globalVariables/ns:GlobalVariables/Application_ID"/>
+                            </ns12:ApplicationID>
+                            <ns12:ComponentName>
+                                <xsl:value-of select="tib:substring-before-last(tib:substring-after-last(BW:getCurrentProcessName($_processContext/ns1:ProcessContext/ProcessId),'/'),'.process')"/>
+                            </ns12:ComponentName>
+                            <ns12:Hostname>
+                                <xsl:value-of select="BW:getHostName()"/>
+                            </ns12:Hostname>
+                            <ns12:TransactionDomain>
+                                <xsl:value-of select="'APG::NAM'"/>
+                            </ns12:TransactionDomain>
+                            <ns12:TransactionType>
+                                <xsl:value-of select="'SITEFEED'"/>
+                            </ns12:TransactionType>
+                            <ns12:InterfaceID>
+                                <xsl:value-of select="'SITEFEED'"/>
+                            </ns12:InterfaceID>
+                            <ns12:Message>
+                                <xsl:value-of select="&quot;Exception while querying Cassandra while getting the delivery source table &quot;"/>
+                            </ns12:Message>
+                        </ns12:Header>
+                        <ns12:ExceptionCode>
+                            <xsl:value-of select="$_globalVariables/ns:GlobalVariables/CommonLE/ExceptionCodes/Technical/HTTPException"/>
+                        </ns12:ExceptionCode>
+                        <ns12:StackTrace>
+                            <xsl:value-of select="$_error/ns1:ErrorReport/StackTrace"/>
+                        </ns12:StackTrace>
+                    </ns12:ExceptionRequest>
+                </xsl:when>
+                <xsl:when test="exists($_error_Render-JSON/ns2:JSONRenderException)">
+                    <ns12:ExceptionRequest>
+                        <ns12:Header>
+                            <ns12:ApplicationID>
+                                <xsl:value-of select="$_globalVariables/ns:GlobalVariables/Application_ID"/>
+                            </ns12:ApplicationID>
+                            <ns12:ComponentName>
+                                <xsl:value-of select="tib:substring-before-last(tib:substring-after-last(BW:getCurrentProcessName($_processContext/ns1:ProcessContext/ProcessId),'/'),'.process')"/>
+                            </ns12:ComponentName>
+                            <ns12:Hostname>
+                                <xsl:value-of select="BW:getHostName()"/>
+                            </ns12:Hostname>
+                            <ns12:TransactionDomain>
+                                <xsl:value-of select="'APG::NAM'"/>
+                            </ns12:TransactionDomain>
+                            <ns12:TransactionType>
+                                <xsl:value-of select="'SITEFEED'"/>
+                            </ns12:TransactionType>
+                            <ns12:InterfaceID>
+                                <xsl:value-of select="'SITEFEED'"/>
+                            </ns12:InterfaceID>
+                            <ns12:Message>
+                                <xsl:value-of select="&quot;Error while rendering the message to GCP&quot;"/>
+                            </ns12:Message>
+                        </ns12:Header>
+                        <ns12:ExceptionCode>
+                            <xsl:value-of select="$_globalVariables/ns:GlobalVariables/CommonLE/ExceptionCodes/Technical/DataException"/>
+                        </ns12:ExceptionCode>
+                        <ns12:StackTrace>
+                            <xsl:value-of select="$_error/ns1:ErrorReport/StackTrace"/>
+                        </ns12:StackTrace>
+                    </ns12:ExceptionRequest>
+                </xsl:when>
+                <xsl:when test="exists($_error_Send-HTTP-Request/ActivityErrors)">
+                    <ns12:ExceptionRequest>
+                        <ns12:Header>
+                            <ns12:ApplicationID>
+                                <xsl:value-of select="$_globalVariables/ns:GlobalVariables/Application_ID"/>
+                            </ns12:ApplicationID>
+                            <ns12:ComponentName>
+                                <xsl:value-of select="tib:substring-before-last(tib:substring-after-last(BW:getCurrentProcessName($_processContext/ns1:ProcessContext/ProcessId),'/'),'.process')"/>
+                            </ns12:ComponentName>
+                            <ns12:Hostname>
+                                <xsl:value-of select="BW:getHostName()"/>
+                            </ns12:Hostname>
+                            <ns12:TransactionDomain>
+                                <xsl:value-of select="'APG::NAM'"/>
+                            </ns12:TransactionDomain>
+                            <ns12:TransactionType>
+                                <xsl:value-of select="'SITEFEED'"/>
+                            </ns12:TransactionType>
+                            <ns12:InterfaceID>
+                                <xsl:value-of select="'SITEFEED'"/>
+                            </ns12:InterfaceID>
+                            <ns12:Message>
+                                <xsl:value-of select="&quot;HTTP exception  while sending request to GCP&quot;"/>
+                            </ns12:Message>
+                        </ns12:Header>
+                        <ns12:ExceptionCode>
+                            <xsl:value-of select="$_globalVariables/ns:GlobalVariables/CommonLE/ExceptionCodes/Technical/DataException"/>
+                        </ns12:ExceptionCode>
+                        <ns12:StackTrace>
+                            <xsl:value-of select="$_error/ns1:ErrorReport/StackTrace"/>
+                        </ns12:StackTrace>
+                    </ns12:ExceptionRequest>
+                </xsl:when>
+                <xsl:when test="exists($_error_Query_Site/ActivityErrors)">
+                    <ns12:ExceptionRequest>
+                        <ns12:Header>
+                            <ns12:ApplicationID>
+                                <xsl:value-of select="$_globalVariables/ns:GlobalVariables/Application_ID"/>
+                            </ns12:ApplicationID>
+                            <ns12:ComponentName>
+                                <xsl:value-of select="tib:substring-before-last(tib:substring-after-last(BW:getCurrentProcessName($_processContext/ns1:ProcessContext/ProcessId),'/'),'.process')"/>
+                            </ns12:ComponentName>
+                            <ns12:Hostname>
+                                <xsl:value-of select="BW:getHostName()"/>
+                            </ns12:Hostname>
+                            <ns12:TransactionDomain>
+                                <xsl:value-of select="'APG::NAM'"/>
+                            </ns12:TransactionDomain>
+                            <ns12:TransactionType>
+                                <xsl:value-of select="'SITEFEED'"/>
+                            </ns12:TransactionType>
+                            <ns12:InterfaceID>
+                                <xsl:value-of select="'SITEFEED'"/>
+                            </ns12:InterfaceID>
+                            <ns12:Message>
+                                <xsl:value-of select="&quot;Error while quering the data inside the loop from Cassandra&quot;"/>
+                            </ns12:Message>
+                        </ns12:Header>
+                        <ns12:ExceptionCode>
+                            <xsl:value-of select="$_globalVariables/ns:GlobalVariables/CommonLE/ExceptionCodes/Technical/DataException"/>
+                        </ns12:ExceptionCode>
+                        <ns12:StackTrace>
+                            <xsl:value-of select="$_error/ns1:ErrorReport/StackTrace"/>
+                        </ns12:StackTrace>
+                    </ns12:ExceptionRequest>
+                </xsl:when>
+                <xsl:otherwise>
+                    <ns12:ExceptionRequest>
+                        <ns12:Header>
+                            <ns12:ApplicationID>
+                                <xsl:value-of select="$_globalVariables/ns:GlobalVariables/Application_ID"/>
+                            </ns12:ApplicationID>
+                            <ns12:ComponentName>
+                                <xsl:value-of select="tib:substring-before-last(tib:substring-after-last(BW:getCurrentProcessName($_processContext/ns1:ProcessContext/ProcessId),'/'),'.process')"/>
+                            </ns12:ComponentName>
+                            <ns12:Hostname>
+                                <xsl:value-of select="BW:getHostName()"/>
+                            </ns12:Hostname>
+                            <ns12:TransactionDomain>
+                                <xsl:value-of select="'APG::NAM'"/>
+                            </ns12:TransactionDomain>
+                            <ns12:TransactionType>
+                                <xsl:value-of select="'SITEFEED'"/>
+                            </ns12:TransactionType>
+                            <ns12:InterfaceID>
+                                <xsl:value-of select="'SITEFEED'"/>
+                            </ns12:InterfaceID>
+                            <ns12:Message>
+                                <xsl:value-of select="&quot;Generic exception occured while sending the SiteFeed data to GCP&quot;"/>
+                            </ns12:Message>
+                        </ns12:Header>
+                        <ns12:ExceptionCode>
+                            <xsl:value-of select="$_globalVariables/ns:GlobalVariables/CommonLE/ExceptionCodes/Technical/GenericException"/>
+                        </ns12:ExceptionCode>
+                        <ns12:StackTrace>
+                            <xsl:value-of select="$_error/ns1:ErrorReport/StackTrace"/>
+                        </ns12:StackTrace>
+                    </ns12:ExceptionRequest>
+                </xsl:otherwise>
+            </xsl:choose>
+        </pd:inputBindings>
+    </pd:activity>
+    <pd:activity name="Catch">
+        <pd:type>com.tibco.pe.core.CatchActivity</pd:type>
+        <pd:resourceType>ae.activities.catch</pd:resourceType>
+        <pd:x>750</pd:x>
+        <pd:y>218</pd:y>
+        <pd:handler>true</pd:handler>
+        <config>
+            <catchAll>true</catchAll>
+        </config>
+        <pd:inputBindings/>
+    </pd:activity>
+    <pd:transition>
+        <pd:from>JMS Queue Receiver</pd:from>
+        <pd:to>Query_deliverysource</pd:to>
+        <pd:lineType>Default</pd:lineType>
+        <pd:lineColor>-16777216</pd:lineColor>
+        <pd:conditionType>always</pd:conditionType>
+    </pd:transition>
+    <pd:transition>
+        <pd:from>Query_deliverysource</pd:from>
+        <pd:to>Group</pd:to>
+        <pd:lineType>Default</pd:lineType>
+        <pd:lineColor>-16777216</pd:lineColor>
+        <pd:conditionType>always</pd:conditionType>
+    </pd:transition>
+    <pd:transition>
+        <pd:from>Group</pd:from>
+        <pd:to>End</pd:to>
+        <pd:lineType>Default</pd:lineType>
+        <pd:lineColor>-16777216</pd:lineColor>
+        <pd:conditionType>always</pd:conditionType>
+    </pd:transition>
+    <pd:transition>
+        <pd:from>Catch</pd:from>
+        <pd:to>SendException</pd:to>
+        <pd:lineType>Default</pd:lineType>
+        <pd:lineColor>-16777216</pd:lineColor>
+        <pd:conditionType>always</pd:conditionType>
+    </pd:transition>
+    <pd:transition>
+        <pd:from>SendException</pd:from>
+        <pd:to>End</pd:to>
+        <pd:lineType>Default</pd:lineType>
+        <pd:lineColor>-16777216</pd:lineColor>
+        <pd:conditionType>always</pd:conditionType>
+    </pd:transition>
+</pd:ProcessDefinition>
\ No newline at end of file