eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CLN_UPDTDLVY_PKG dependencies on WF_ENGINE

Line 84: if (funcmode <> wf_engine.eng_run) then

80: cln_debug_pub.Add('Failure point ' || x_progress, 1);
81: end if;
82:
83: -- Do nothing in cancel or timeout mode
84: if (funcmode <> wf_engine.eng_run) then
85: resultout := wf_engine.eng_null;
86: return; -- do not raise the exception as it would end the workflow
87: end if;
88:

Line 85: resultout := wf_engine.eng_null;

81: end if;
82:
83: -- Do nothing in cancel or timeout mode
84: if (funcmode <> wf_engine.eng_run) then
85: resultout := wf_engine.eng_null;
86: return; -- do not raise the exception as it would end the workflow
87: end if;
88:
89: -- Retrieve Activity Attributes

Line 90: p_shipment_header_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'SHIPMENT_HEADER_ID');

86: return; -- do not raise the exception as it would end the workflow
87: end if;
88:
89: -- Retrieve Activity Attributes
90: p_shipment_header_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'SHIPMENT_HEADER_ID');
91:
92: if (p_shipment_header_id is null) then
93: wf_core.token('SHIPMENT_HEADER_ID', 'NULL');
94: wf_core.raise('WFSQL_ARGS');

Line 168: wf_engine.SetItemAttrText(itemtype, itemkey, 'XMLG_INTERNAL_TXN_TYPE', transaction_type);

164: cln_debug_pub.Add('Failure point ' || x_progress, 1);
165: end if;
166:
167: -- pass parameters back to main itemtype attributes
168: wf_engine.SetItemAttrText(itemtype, itemkey, 'XMLG_INTERNAL_TXN_TYPE', transaction_type);
169: wf_engine.SetItemAttrText(itemtype, itemkey, 'XMLG_INTERNAL_TXN_SUBTYPE', transaction_subtype);
170: wf_engine.SetItemAttrText(itemtype, itemkey, 'DOCUMENT_DIRECTION', document_direction);
171: wf_engine.SetItemAttrText(itemtype, itemkey, 'XMLG_DOCUMENT_ID', l_document_id);
172: wf_engine.SetItemAttrText(itemtype, itemkey, 'TRADING_PARTNER_ID', party_id);

Line 169: wf_engine.SetItemAttrText(itemtype, itemkey, 'XMLG_INTERNAL_TXN_SUBTYPE', transaction_subtype);

165: end if;
166:
167: -- pass parameters back to main itemtype attributes
168: wf_engine.SetItemAttrText(itemtype, itemkey, 'XMLG_INTERNAL_TXN_TYPE', transaction_type);
169: wf_engine.SetItemAttrText(itemtype, itemkey, 'XMLG_INTERNAL_TXN_SUBTYPE', transaction_subtype);
170: wf_engine.SetItemAttrText(itemtype, itemkey, 'DOCUMENT_DIRECTION', document_direction);
171: wf_engine.SetItemAttrText(itemtype, itemkey, 'XMLG_DOCUMENT_ID', l_document_id);
172: wf_engine.SetItemAttrText(itemtype, itemkey, 'TRADING_PARTNER_ID', party_id);
173: wf_engine.SetItemAttrText(itemtype, itemkey, 'TRADING_PARTNER_SITE', party_site_id);

Line 170: wf_engine.SetItemAttrText(itemtype, itemkey, 'DOCUMENT_DIRECTION', document_direction);

166:
167: -- pass parameters back to main itemtype attributes
168: wf_engine.SetItemAttrText(itemtype, itemkey, 'XMLG_INTERNAL_TXN_TYPE', transaction_type);
169: wf_engine.SetItemAttrText(itemtype, itemkey, 'XMLG_INTERNAL_TXN_SUBTYPE', transaction_subtype);
170: wf_engine.SetItemAttrText(itemtype, itemkey, 'DOCUMENT_DIRECTION', document_direction);
171: wf_engine.SetItemAttrText(itemtype, itemkey, 'XMLG_DOCUMENT_ID', l_document_id);
172: wf_engine.SetItemAttrText(itemtype, itemkey, 'TRADING_PARTNER_ID', party_id);
173: wf_engine.SetItemAttrText(itemtype, itemkey, 'TRADING_PARTNER_SITE', party_site_id);
174: wf_engine.SetItemAttrText(itemtype, itemkey, 'TRADING_PARTNER_TYPE', party_type);

Line 171: wf_engine.SetItemAttrText(itemtype, itemkey, 'XMLG_DOCUMENT_ID', l_document_id);

167: -- pass parameters back to main itemtype attributes
168: wf_engine.SetItemAttrText(itemtype, itemkey, 'XMLG_INTERNAL_TXN_TYPE', transaction_type);
169: wf_engine.SetItemAttrText(itemtype, itemkey, 'XMLG_INTERNAL_TXN_SUBTYPE', transaction_subtype);
170: wf_engine.SetItemAttrText(itemtype, itemkey, 'DOCUMENT_DIRECTION', document_direction);
171: wf_engine.SetItemAttrText(itemtype, itemkey, 'XMLG_DOCUMENT_ID', l_document_id);
172: wf_engine.SetItemAttrText(itemtype, itemkey, 'TRADING_PARTNER_ID', party_id);
173: wf_engine.SetItemAttrText(itemtype, itemkey, 'TRADING_PARTNER_SITE', party_site_id);
174: wf_engine.SetItemAttrText(itemtype, itemkey, 'TRADING_PARTNER_TYPE', party_type);
175: wf_engine.SetItemAttrText(itemtype, itemkey, 'DOCUMENT_NO', l_document_id);

Line 172: wf_engine.SetItemAttrText(itemtype, itemkey, 'TRADING_PARTNER_ID', party_id);

168: wf_engine.SetItemAttrText(itemtype, itemkey, 'XMLG_INTERNAL_TXN_TYPE', transaction_type);
169: wf_engine.SetItemAttrText(itemtype, itemkey, 'XMLG_INTERNAL_TXN_SUBTYPE', transaction_subtype);
170: wf_engine.SetItemAttrText(itemtype, itemkey, 'DOCUMENT_DIRECTION', document_direction);
171: wf_engine.SetItemAttrText(itemtype, itemkey, 'XMLG_DOCUMENT_ID', l_document_id);
172: wf_engine.SetItemAttrText(itemtype, itemkey, 'TRADING_PARTNER_ID', party_id);
173: wf_engine.SetItemAttrText(itemtype, itemkey, 'TRADING_PARTNER_SITE', party_site_id);
174: wf_engine.SetItemAttrText(itemtype, itemkey, 'TRADING_PARTNER_TYPE', party_type);
175: wf_engine.SetItemAttrText(itemtype, itemkey, 'DOCUMENT_NO', l_document_id);
176: wf_engine.SetItemAttrText(itemtype, itemkey, 'ORG_ID', l_organization_id);

Line 173: wf_engine.SetItemAttrText(itemtype, itemkey, 'TRADING_PARTNER_SITE', party_site_id);

169: wf_engine.SetItemAttrText(itemtype, itemkey, 'XMLG_INTERNAL_TXN_SUBTYPE', transaction_subtype);
170: wf_engine.SetItemAttrText(itemtype, itemkey, 'DOCUMENT_DIRECTION', document_direction);
171: wf_engine.SetItemAttrText(itemtype, itemkey, 'XMLG_DOCUMENT_ID', l_document_id);
172: wf_engine.SetItemAttrText(itemtype, itemkey, 'TRADING_PARTNER_ID', party_id);
173: wf_engine.SetItemAttrText(itemtype, itemkey, 'TRADING_PARTNER_SITE', party_site_id);
174: wf_engine.SetItemAttrText(itemtype, itemkey, 'TRADING_PARTNER_TYPE', party_type);
175: wf_engine.SetItemAttrText(itemtype, itemkey, 'DOCUMENT_NO', l_document_id);
176: wf_engine.SetItemAttrText(itemtype, itemkey, 'ORG_ID', l_organization_id);
177: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_TRANSACTION_TYPE', transaction_type);

Line 174: wf_engine.SetItemAttrText(itemtype, itemkey, 'TRADING_PARTNER_TYPE', party_type);

170: wf_engine.SetItemAttrText(itemtype, itemkey, 'DOCUMENT_DIRECTION', document_direction);
171: wf_engine.SetItemAttrText(itemtype, itemkey, 'XMLG_DOCUMENT_ID', l_document_id);
172: wf_engine.SetItemAttrText(itemtype, itemkey, 'TRADING_PARTNER_ID', party_id);
173: wf_engine.SetItemAttrText(itemtype, itemkey, 'TRADING_PARTNER_SITE', party_site_id);
174: wf_engine.SetItemAttrText(itemtype, itemkey, 'TRADING_PARTNER_TYPE', party_type);
175: wf_engine.SetItemAttrText(itemtype, itemkey, 'DOCUMENT_NO', l_document_id);
176: wf_engine.SetItemAttrText(itemtype, itemkey, 'ORG_ID', l_organization_id);
177: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_TRANSACTION_TYPE', transaction_type);
178: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_TRANSACTION_SUBTYPE', transaction_subtype);

Line 175: wf_engine.SetItemAttrText(itemtype, itemkey, 'DOCUMENT_NO', l_document_id);

171: wf_engine.SetItemAttrText(itemtype, itemkey, 'XMLG_DOCUMENT_ID', l_document_id);
172: wf_engine.SetItemAttrText(itemtype, itemkey, 'TRADING_PARTNER_ID', party_id);
173: wf_engine.SetItemAttrText(itemtype, itemkey, 'TRADING_PARTNER_SITE', party_site_id);
174: wf_engine.SetItemAttrText(itemtype, itemkey, 'TRADING_PARTNER_TYPE', party_type);
175: wf_engine.SetItemAttrText(itemtype, itemkey, 'DOCUMENT_NO', l_document_id);
176: wf_engine.SetItemAttrText(itemtype, itemkey, 'ORG_ID', l_organization_id);
177: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_TRANSACTION_TYPE', transaction_type);
178: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_TRANSACTION_SUBTYPE', transaction_subtype);
179: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_PARTY_ID', party_id);

Line 176: wf_engine.SetItemAttrText(itemtype, itemkey, 'ORG_ID', l_organization_id);

172: wf_engine.SetItemAttrText(itemtype, itemkey, 'TRADING_PARTNER_ID', party_id);
173: wf_engine.SetItemAttrText(itemtype, itemkey, 'TRADING_PARTNER_SITE', party_site_id);
174: wf_engine.SetItemAttrText(itemtype, itemkey, 'TRADING_PARTNER_TYPE', party_type);
175: wf_engine.SetItemAttrText(itemtype, itemkey, 'DOCUMENT_NO', l_document_id);
176: wf_engine.SetItemAttrText(itemtype, itemkey, 'ORG_ID', l_organization_id);
177: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_TRANSACTION_TYPE', transaction_type);
178: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_TRANSACTION_SUBTYPE', transaction_subtype);
179: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_PARTY_ID', party_id);
180: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_PARTY_SITE_ID', party_site_id);

Line 177: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_TRANSACTION_TYPE', transaction_type);

173: wf_engine.SetItemAttrText(itemtype, itemkey, 'TRADING_PARTNER_SITE', party_site_id);
174: wf_engine.SetItemAttrText(itemtype, itemkey, 'TRADING_PARTNER_TYPE', party_type);
175: wf_engine.SetItemAttrText(itemtype, itemkey, 'DOCUMENT_NO', l_document_id);
176: wf_engine.SetItemAttrText(itemtype, itemkey, 'ORG_ID', l_organization_id);
177: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_TRANSACTION_TYPE', transaction_type);
178: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_TRANSACTION_SUBTYPE', transaction_subtype);
179: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_PARTY_ID', party_id);
180: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_PARTY_SITE_ID', party_site_id);
181: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_PARTY_TYPE', party_type);

Line 178: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_TRANSACTION_SUBTYPE', transaction_subtype);

174: wf_engine.SetItemAttrText(itemtype, itemkey, 'TRADING_PARTNER_TYPE', party_type);
175: wf_engine.SetItemAttrText(itemtype, itemkey, 'DOCUMENT_NO', l_document_id);
176: wf_engine.SetItemAttrText(itemtype, itemkey, 'ORG_ID', l_organization_id);
177: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_TRANSACTION_TYPE', transaction_type);
178: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_TRANSACTION_SUBTYPE', transaction_subtype);
179: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_PARTY_ID', party_id);
180: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_PARTY_SITE_ID', party_site_id);
181: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_PARTY_TYPE', party_type);
182: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_DOCUMENT_ID', l_document_id);

Line 179: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_PARTY_ID', party_id);

175: wf_engine.SetItemAttrText(itemtype, itemkey, 'DOCUMENT_NO', l_document_id);
176: wf_engine.SetItemAttrText(itemtype, itemkey, 'ORG_ID', l_organization_id);
177: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_TRANSACTION_TYPE', transaction_type);
178: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_TRANSACTION_SUBTYPE', transaction_subtype);
179: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_PARTY_ID', party_id);
180: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_PARTY_SITE_ID', party_site_id);
181: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_PARTY_TYPE', party_type);
182: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_DOCUMENT_ID', l_document_id);
183: wf_engine.SetItemAttrText(itemtype, itemkey, 'MESSAGE_TEXT', message_text);

Line 180: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_PARTY_SITE_ID', party_site_id);

176: wf_engine.SetItemAttrText(itemtype, itemkey, 'ORG_ID', l_organization_id);
177: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_TRANSACTION_TYPE', transaction_type);
178: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_TRANSACTION_SUBTYPE', transaction_subtype);
179: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_PARTY_ID', party_id);
180: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_PARTY_SITE_ID', party_site_id);
181: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_PARTY_TYPE', party_type);
182: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_DOCUMENT_ID', l_document_id);
183: wf_engine.SetItemAttrText(itemtype, itemkey, 'MESSAGE_TEXT', message_text);
184: wf_engine.SetItemAttrText(itemtype, itemkey, 'REFERENCE_ID', l_ref_num);

Line 181: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_PARTY_TYPE', party_type);

177: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_TRANSACTION_TYPE', transaction_type);
178: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_TRANSACTION_SUBTYPE', transaction_subtype);
179: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_PARTY_ID', party_id);
180: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_PARTY_SITE_ID', party_site_id);
181: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_PARTY_TYPE', party_type);
182: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_DOCUMENT_ID', l_document_id);
183: wf_engine.SetItemAttrText(itemtype, itemkey, 'MESSAGE_TEXT', message_text);
184: wf_engine.SetItemAttrText(itemtype, itemkey, 'REFERENCE_ID', l_ref_num);
185: wf_engine.SetItemAttrText(itemtype, itemkey, 'DOCUMENT_CREATION_DATE', l_canonical_date);

Line 182: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_DOCUMENT_ID', l_document_id);

178: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_TRANSACTION_SUBTYPE', transaction_subtype);
179: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_PARTY_ID', party_id);
180: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_PARTY_SITE_ID', party_site_id);
181: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_PARTY_TYPE', party_type);
182: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_DOCUMENT_ID', l_document_id);
183: wf_engine.SetItemAttrText(itemtype, itemkey, 'MESSAGE_TEXT', message_text);
184: wf_engine.SetItemAttrText(itemtype, itemkey, 'REFERENCE_ID', l_ref_num);
185: wf_engine.SetItemAttrText(itemtype, itemkey, 'DOCUMENT_CREATION_DATE', l_canonical_date);
186:

Line 183: wf_engine.SetItemAttrText(itemtype, itemkey, 'MESSAGE_TEXT', message_text);

179: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_PARTY_ID', party_id);
180: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_PARTY_SITE_ID', party_site_id);
181: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_PARTY_TYPE', party_type);
182: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_DOCUMENT_ID', l_document_id);
183: wf_engine.SetItemAttrText(itemtype, itemkey, 'MESSAGE_TEXT', message_text);
184: wf_engine.SetItemAttrText(itemtype, itemkey, 'REFERENCE_ID', l_ref_num);
185: wf_engine.SetItemAttrText(itemtype, itemkey, 'DOCUMENT_CREATION_DATE', l_canonical_date);
186:
187: -- Reached Here. Successful execution.

Line 184: wf_engine.SetItemAttrText(itemtype, itemkey, 'REFERENCE_ID', l_ref_num);

180: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_PARTY_SITE_ID', party_site_id);
181: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_PARTY_TYPE', party_type);
182: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_DOCUMENT_ID', l_document_id);
183: wf_engine.SetItemAttrText(itemtype, itemkey, 'MESSAGE_TEXT', message_text);
184: wf_engine.SetItemAttrText(itemtype, itemkey, 'REFERENCE_ID', l_ref_num);
185: wf_engine.SetItemAttrText(itemtype, itemkey, 'DOCUMENT_CREATION_DATE', l_canonical_date);
186:
187: -- Reached Here. Successful execution.
188: if (l_debug_level <= 1) then

Line 185: wf_engine.SetItemAttrText(itemtype, itemkey, 'DOCUMENT_CREATION_DATE', l_canonical_date);

181: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_PARTY_TYPE', party_type);
182: wf_engine.SetItemAttrText(itemtype, itemkey, 'ECX_DOCUMENT_ID', l_document_id);
183: wf_engine.SetItemAttrText(itemtype, itemkey, 'MESSAGE_TEXT', message_text);
184: wf_engine.SetItemAttrText(itemtype, itemkey, 'REFERENCE_ID', l_ref_num);
185: wf_engine.SetItemAttrText(itemtype, itemkey, 'DOCUMENT_CREATION_DATE', l_canonical_date);
186:
187: -- Reached Here. Successful execution.
188: if (l_debug_level <= 1) then
189: cln_debug_pub.Add('EXITING CLN_UPDTDLVY_PKG.Raise_UpdateDelivery_Event Successfully', 1);