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_NTFYINVC_PKG dependencies on WF_ENGINE

Line 284: IF (p_funcmode <> wf_engine.eng_run) THEN

280: l_party_type := 'C';
281: l_result := FALSE;
282:
283: -- Do nothing in cancel or timeout mode
284: IF (p_funcmode <> wf_engine.eng_run) THEN
285: x_resultout := wf_engine.eng_null;
286: return; -- do not raise the exception as it would end the workflow
287: END IF;
288:

Line 285: x_resultout := wf_engine.eng_null;

281: l_result := FALSE;
282:
283: -- Do nothing in cancel or timeout mode
284: IF (p_funcmode <> wf_engine.eng_run) THEN
285: x_resultout := wf_engine.eng_null;
286: return; -- do not raise the exception as it would end the workflow
287: END IF;
288:
289: -- Retrieve Activity Attributes

Line 290: l_party_site_id := Wf_Engine.GetActivityAttrText(p_itemtype, p_itemkey, p_actid, 'ECX_PARTY_SITE_ID');

286: return; -- do not raise the exception as it would end the workflow
287: END IF;
288:
289: -- Retrieve Activity Attributes
290: l_party_site_id := Wf_Engine.GetActivityAttrText(p_itemtype, p_itemkey, p_actid, 'ECX_PARTY_SITE_ID');
291: l_doc_transfer_id := Wf_Engine.GetActivityAttrText(p_itemtype, p_itemkey, p_actid, 'ECX_DOCUMENT_ID');
292:
293:
294: -- Get party id, party site id, org_id

Line 291: l_doc_transfer_id := Wf_Engine.GetActivityAttrText(p_itemtype, p_itemkey, p_actid, 'ECX_DOCUMENT_ID');

287: END IF;
288:
289: -- Retrieve Activity Attributes
290: l_party_site_id := Wf_Engine.GetActivityAttrText(p_itemtype, p_itemkey, p_actid, 'ECX_PARTY_SITE_ID');
291: l_doc_transfer_id := Wf_Engine.GetActivityAttrText(p_itemtype, p_itemkey, p_actid, 'ECX_DOCUMENT_ID');
292:
293:
294: -- Get party id, party site id, org_id
295: BEGIN

Line 364: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_NO', l_trx_number);

360: cln_debug_pub.Add('EVENT_KEY'|| p_itemkey, 1);
361:
362: END IF;
363:
364: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_NO', l_trx_number);
365: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ORG_ID', l_organization_id);
366: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_TRANSACTION_TYPE', l_transaction_type);
367: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_TRANSACTION_SUBTYPE', l_transaction_subtype);
368: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_ID', l_party_id);

Line 365: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ORG_ID', l_organization_id);

361:
362: END IF;
363:
364: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_NO', l_trx_number);
365: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ORG_ID', l_organization_id);
366: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_TRANSACTION_TYPE', l_transaction_type);
367: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_TRANSACTION_SUBTYPE', l_transaction_subtype);
368: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_ID', l_party_id);
369: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_SITE_ID', l_party_site_id);

Line 366: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_TRANSACTION_TYPE', l_transaction_type);

362: END IF;
363:
364: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_NO', l_trx_number);
365: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ORG_ID', l_organization_id);
366: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_TRANSACTION_TYPE', l_transaction_type);
367: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_TRANSACTION_SUBTYPE', l_transaction_subtype);
368: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_ID', l_party_id);
369: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_SITE_ID', l_party_site_id);
370: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_TYPE', l_party_type);

Line 367: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_TRANSACTION_SUBTYPE', l_transaction_subtype);

363:
364: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_NO', l_trx_number);
365: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ORG_ID', l_organization_id);
366: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_TRANSACTION_TYPE', l_transaction_type);
367: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_TRANSACTION_SUBTYPE', l_transaction_subtype);
368: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_ID', l_party_id);
369: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_SITE_ID', l_party_site_id);
370: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_TYPE', l_party_type);
371: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_DOCUMENT_ID', l_doc_transfer_id);

Line 368: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_ID', l_party_id);

364: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_NO', l_trx_number);
365: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ORG_ID', l_organization_id);
366: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_TRANSACTION_TYPE', l_transaction_type);
367: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_TRANSACTION_SUBTYPE', l_transaction_subtype);
368: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_ID', l_party_id);
369: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_SITE_ID', l_party_site_id);
370: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_TYPE', l_party_type);
371: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_DOCUMENT_ID', l_doc_transfer_id);
372: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_CREATION_DATE', l_canonical_date);

Line 369: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_SITE_ID', l_party_site_id);

365: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ORG_ID', l_organization_id);
366: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_TRANSACTION_TYPE', l_transaction_type);
367: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_TRANSACTION_SUBTYPE', l_transaction_subtype);
368: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_ID', l_party_id);
369: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_SITE_ID', l_party_site_id);
370: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_TYPE', l_party_type);
371: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_DOCUMENT_ID', l_doc_transfer_id);
372: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_CREATION_DATE', l_canonical_date);
373: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PROPRIETARY_DOCUMENT_ID', l_trx_number);

Line 370: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_TYPE', l_party_type);

366: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_TRANSACTION_TYPE', l_transaction_type);
367: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_TRANSACTION_SUBTYPE', l_transaction_subtype);
368: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_ID', l_party_id);
369: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_SITE_ID', l_party_site_id);
370: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_TYPE', l_party_type);
371: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_DOCUMENT_ID', l_doc_transfer_id);
372: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_CREATION_DATE', l_canonical_date);
373: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PROPRIETARY_DOCUMENT_ID', l_trx_number);
374: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'REFERENCE_ID', p_itemkey);

Line 371: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_DOCUMENT_ID', l_doc_transfer_id);

367: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_TRANSACTION_SUBTYPE', l_transaction_subtype);
368: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_ID', l_party_id);
369: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_SITE_ID', l_party_site_id);
370: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_TYPE', l_party_type);
371: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_DOCUMENT_ID', l_doc_transfer_id);
372: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_CREATION_DATE', l_canonical_date);
373: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PROPRIETARY_DOCUMENT_ID', l_trx_number);
374: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'REFERENCE_ID', p_itemkey);
375: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'EVENT_KEY', p_itemkey);

Line 372: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_CREATION_DATE', l_canonical_date);

368: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_ID', l_party_id);
369: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_SITE_ID', l_party_site_id);
370: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_TYPE', l_party_type);
371: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_DOCUMENT_ID', l_doc_transfer_id);
372: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_CREATION_DATE', l_canonical_date);
373: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PROPRIETARY_DOCUMENT_ID', l_trx_number);
374: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'REFERENCE_ID', p_itemkey);
375: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'EVENT_KEY', p_itemkey);
376:

Line 373: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PROPRIETARY_DOCUMENT_ID', l_trx_number);

369: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_SITE_ID', l_party_site_id);
370: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_TYPE', l_party_type);
371: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_DOCUMENT_ID', l_doc_transfer_id);
372: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_CREATION_DATE', l_canonical_date);
373: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PROPRIETARY_DOCUMENT_ID', l_trx_number);
374: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'REFERENCE_ID', p_itemkey);
375: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'EVENT_KEY', p_itemkey);
376:
377: -- Reached Here. Successful execution.

Line 374: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'REFERENCE_ID', p_itemkey);

370: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_TYPE', l_party_type);
371: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_DOCUMENT_ID', l_doc_transfer_id);
372: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_CREATION_DATE', l_canonical_date);
373: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PROPRIETARY_DOCUMENT_ID', l_trx_number);
374: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'REFERENCE_ID', p_itemkey);
375: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'EVENT_KEY', p_itemkey);
376:
377: -- Reached Here. Successful execution.
378: x_resultout := 'SUCCESS';

Line 375: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'EVENT_KEY', p_itemkey);

371: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_DOCUMENT_ID', l_doc_transfer_id);
372: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_CREATION_DATE', l_canonical_date);
373: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PROPRIETARY_DOCUMENT_ID', l_trx_number);
374: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'REFERENCE_ID', p_itemkey);
375: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'EVENT_KEY', p_itemkey);
376:
377: -- Reached Here. Successful execution.
378: x_resultout := 'SUCCESS';
379: IF (l_debug_level <= 1) THEN

Line 751: l_doc_id := Wf_Engine.GetActivityAttrText(p_itemtype, p_itemkey, p_actid, 'ECX_DOCUMENT_ID');

747: IF (l_debug_level <= 2) THEN
748: cln_debug_pub.Add('Entering CLN_UPDATE_DOC_STATUS',2);
749: END IF;
750:
751: l_doc_id := Wf_Engine.GetActivityAttrText(p_itemtype, p_itemkey, p_actid, 'ECX_DOCUMENT_ID');
752: IF (l_debug_level <= 1) THEN
753: cln_debug_pub.Add('Document Transfer ID : '|| l_doc_id, 1);
754: END IF;
755:

Line 756: l_transaction_type := Wf_Engine.GetActivityAttrText(p_itemtype, p_itemkey, p_actid, 'ECX_TRANSACTION_TYPE');

752: IF (l_debug_level <= 1) THEN
753: cln_debug_pub.Add('Document Transfer ID : '|| l_doc_id, 1);
754: END IF;
755:
756: l_transaction_type := Wf_Engine.GetActivityAttrText(p_itemtype, p_itemkey, p_actid, 'ECX_TRANSACTION_TYPE');
757: IF (l_debug_level <= 1) THEN
758: cln_debug_pub.Add('l_transaction_type: '|| l_transaction_type, 1);
759: END IF;
760:

Line 761: l_transaction_subtype := Wf_Engine.GetActivityAttrText(p_itemtype, p_itemkey, p_actid, 'ECX_TRANSACTION_SUBTYPE');

757: IF (l_debug_level <= 1) THEN
758: cln_debug_pub.Add('l_transaction_type: '|| l_transaction_type, 1);
759: END IF;
760:
761: l_transaction_subtype := Wf_Engine.GetActivityAttrText(p_itemtype, p_itemkey, p_actid, 'ECX_TRANSACTION_SUBTYPE');
762: IF (l_debug_level <= 1) THEN
763: cln_debug_pub.Add('l_transaction_subtype : '|| l_transaction_subtype, 1);
764: END IF;
765:

Line 1123: IF (p_funcmode <> wf_engine.eng_run) THEN

1119:
1120: l_msg_data :='Status returned from XGM checked for further processing';
1121:
1122: -- Do nothing in cancel or timeout mode
1123: IF (p_funcmode <> wf_engine.eng_run) THEN
1124: x_resultout := wf_engine.eng_null;
1125:
1126: IF (l_Debug_Level <= 1) THEN
1127: cln_debug_pub.Add('Not in Running Mode...........Return Here',1);

Line 1124: x_resultout := wf_engine.eng_null;

1120: l_msg_data :='Status returned from XGM checked for further processing';
1121:
1122: -- Do nothing in cancel or timeout mode
1123: IF (p_funcmode <> wf_engine.eng_run) THEN
1124: x_resultout := wf_engine.eng_null;
1125:
1126: IF (l_Debug_Level <= 1) THEN
1127: cln_debug_pub.Add('Not in Running Mode...........Return Here',1);
1128: END IF;

Line 1134: l_return_status_tp := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER7', TRUE);

1130: RETURN;
1131: END IF;
1132:
1133: -- Should be 00 for success
1134: l_return_status_tp := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER7', TRUE);
1135: IF (l_Debug_Level <= 1) THEN
1136: cln_debug_pub.Add('Return Status as obtained from workflow : '||l_return_status_tp,1);
1137: END IF;
1138:

Line 1139: l_sender_header_id := TO_NUMBER(wf_engine.GetItemAttrText(p_itemtype, p_itemkey,'PARAMETER9', TRUE));

1135: IF (l_Debug_Level <= 1) THEN
1136: cln_debug_pub.Add('Return Status as obtained from workflow : '||l_return_status_tp,1);
1137: END IF;
1138:
1139: l_sender_header_id := TO_NUMBER(wf_engine.GetItemAttrText(p_itemtype, p_itemkey,'PARAMETER9', TRUE));
1140: IF (l_Debug_Level <= 1) THEN
1141: cln_debug_pub.Add('Trading Partner Header ID : '||l_sender_header_id, 1);
1142: END IF;
1143:

Line 1173: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARTY_ID', l_party_id);

1169: cln_debug_pub.Add('Party Site ID : '||l_party_site_id,1);
1170: cln_debug_pub.Add('Party Type : '||l_party_type,1);
1171: END IF;
1172:
1173: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARTY_ID', l_party_id);
1174: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARTY_SITE_ID', l_party_site_id);
1175: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARTY_TYPE', l_party_type);
1176: END IF;
1177:

Line 1174: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARTY_SITE_ID', l_party_site_id);

1170: cln_debug_pub.Add('Party Type : '||l_party_type,1);
1171: END IF;
1172:
1173: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARTY_ID', l_party_id);
1174: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARTY_SITE_ID', l_party_site_id);
1175: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARTY_TYPE', l_party_type);
1176: END IF;
1177:
1178: IF (l_return_status_tp = '00') THEN

Line 1175: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARTY_TYPE', l_party_type);

1171: END IF;
1172:
1173: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARTY_ID', l_party_id);
1174: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARTY_SITE_ID', l_party_site_id);
1175: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARTY_TYPE', l_party_type);
1176: END IF;
1177:
1178: IF (l_return_status_tp = '00') THEN
1179:

Line 1184: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', '00');

1180: IF (l_Debug_Level <= 1) THEN
1181: cln_debug_pub.Add('Return Status is Success',1);
1182: END IF;
1183:
1184: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', '00');
1185: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', 'SUCCESS');
1186: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS', 'SUCCESS');
1187: x_resultout := 'COMPLETE:'||'TRUE';
1188:

Line 1185: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', 'SUCCESS');

1181: cln_debug_pub.Add('Return Status is Success',1);
1182: END IF;
1183:
1184: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', '00');
1185: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', 'SUCCESS');
1186: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS', 'SUCCESS');
1187: x_resultout := 'COMPLETE:'||'TRUE';
1188:
1189: ELSIF(l_return_status_tp = '99') THEN

Line 1186: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS', 'SUCCESS');

1182: END IF;
1183:
1184: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', '00');
1185: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', 'SUCCESS');
1186: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS', 'SUCCESS');
1187: x_resultout := 'COMPLETE:'||'TRUE';
1188:
1189: ELSIF(l_return_status_tp = '99') THEN
1190:

Line 1195: l_return_desc_tp := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER8', TRUE);

1191: IF (l_Debug_Level <= 1) THEN
1192: cln_debug_pub.Add('Return Status is Error',1);
1193: END IF;
1194:
1195: l_return_desc_tp := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER8', TRUE);
1196:
1197: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', '99');
1198: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
1199: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS', 'ERROR');

Line 1197: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', '99');

1193: END IF;
1194:
1195: l_return_desc_tp := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER8', TRUE);
1196:
1197: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', '99');
1198: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
1199: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS', 'ERROR');
1200: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', '3C3_IN02');
1201:

Line 1198: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);

1194:
1195: l_return_desc_tp := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER8', TRUE);
1196:
1197: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', '99');
1198: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
1199: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS', 'ERROR');
1200: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', '3C3_IN02');
1201:
1202: IF (l_Debug_Level <= 1) THEN

Line 1199: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS', 'ERROR');

1195: l_return_desc_tp := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER8', TRUE);
1196:
1197: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', '99');
1198: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
1199: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS', 'ERROR');
1200: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', '3C3_IN02');
1201:
1202: IF (l_Debug_Level <= 1) THEN
1203: cln_debug_pub.Add('Message for the trading partner : '||l_return_desc_tp, 1);

Line 1200: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', '3C3_IN02');

1196:
1197: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', '99');
1198: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
1199: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS', 'ERROR');
1200: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', '3C3_IN02');
1201:
1202: IF (l_Debug_Level <= 1) THEN
1203: cln_debug_pub.Add('Message for the trading partner : '||l_return_desc_tp, 1);
1204: END IF;

Line 1228: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);

1224:
1225: l_return_status_tp := '99';
1226: l_return_desc_tp := FND_MESSAGE.GET;
1227:
1228: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
1229: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
1230: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS', 'ERROR');
1231: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', '3C3_IN02');
1232:

Line 1229: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);

1225: l_return_status_tp := '99';
1226: l_return_desc_tp := FND_MESSAGE.GET;
1227:
1228: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
1229: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
1230: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS', 'ERROR');
1231: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', '3C3_IN02');
1232:
1233: x_resultout := 'ERROR';

Line 1230: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS', 'ERROR');

1226: l_return_desc_tp := FND_MESSAGE.GET;
1227:
1228: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
1229: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
1230: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS', 'ERROR');
1231: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', '3C3_IN02');
1232:
1233: x_resultout := 'ERROR';
1234: CLN_NP_PROCESSOR_PKG.NOTIFY_ADMINISTRATOR(l_return_desc_tp);

Line 1231: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', '3C3_IN02');

1227:
1228: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
1229: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
1230: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS', 'ERROR');
1231: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', '3C3_IN02');
1232:
1233: x_resultout := 'ERROR';
1234: CLN_NP_PROCESSOR_PKG.NOTIFY_ADMINISTRATOR(l_return_desc_tp);
1235:

Line 1299: IF (p_funcmode <> wf_engine.eng_run) THEN

1295: x_resultout := 'COMPLETE:'||'TRUE';
1296:
1297: -- Do nothing in cancel or timeout mode
1298:
1299: IF (p_funcmode <> wf_engine.eng_run) THEN
1300: x_resultout := wf_engine.eng_null;
1301:
1302: IF (l_Debug_Level <= 1) THEN
1303: cln_debug_pub.Add('Not in Running Mode...........Return Here',1);

Line 1300: x_resultout := wf_engine.eng_null;

1296:
1297: -- Do nothing in cancel or timeout mode
1298:
1299: IF (p_funcmode <> wf_engine.eng_run) THEN
1300: x_resultout := wf_engine.eng_null;
1301:
1302: IF (l_Debug_Level <= 1) THEN
1303: cln_debug_pub.Add('Not in Running Mode...........Return Here',1);
1304: END IF;

Line 1310: l_internal_control_number := TO_NUMBER(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'EVENT_KEY', TRUE));

1306: RETURN;
1307: END IF;
1308:
1309: -- Getting the values from the workflow.
1310: l_internal_control_number := TO_NUMBER(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'EVENT_KEY', TRUE));
1311:
1312: IF (l_Debug_Level <= 1) THEN
1313: cln_debug_pub.Add('Internal Control Number : '||l_internal_control_number, 1);
1314: END IF;

Line 1316: l_request_id := TO_NUMBER(wf_engine.GetItemAttrText(p_itemtype, p_itemkey,'REQIDNAME', TRUE));

1312: IF (l_Debug_Level <= 1) THEN
1313: cln_debug_pub.Add('Internal Control Number : '||l_internal_control_number, 1);
1314: END IF;
1315:
1316: l_request_id := TO_NUMBER(wf_engine.GetItemAttrText(p_itemtype, p_itemkey,'REQIDNAME', TRUE));
1317: IF (l_Debug_Level <= 1) THEN
1318: cln_debug_pub.Add('Concurrent Program Request ID : '||l_request_id, 1);
1319: END IF;
1320:

Line 1321: l_notification_code := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', TRUE);

1317: IF (l_Debug_Level <= 1) THEN
1318: cln_debug_pub.Add('Concurrent Program Request ID : '||l_request_id, 1);
1319: END IF;
1320:
1321: l_notification_code := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', TRUE);
1322: IF (l_Debug_Level <= 1) THEN
1323: cln_debug_pub.Add('Notification Code : '||l_notification_code, 1);
1324: END IF;
1325:

Line 1326: l_invoice_id := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER6', TRUE);

1322: IF (l_Debug_Level <= 1) THEN
1323: cln_debug_pub.Add('Notification Code : '||l_notification_code, 1);
1324: END IF;
1325:
1326: l_invoice_id := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER6', TRUE);
1327: IF (l_Debug_Level <= 1) THEN
1328: cln_debug_pub.Add('Invoice ID : '||l_invoice_id, 1);
1329: END IF;
1330:

Line 1331: l_reference_id := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER10', TRUE);

1327: IF (l_Debug_Level <= 1) THEN
1328: cln_debug_pub.Add('Invoice ID : '||l_invoice_id, 1);
1329: END IF;
1330:
1331: l_reference_id := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER10', TRUE);
1332: IF (l_Debug_Level <= 1) THEN
1333: cln_debug_pub.Add('Reference ID : '||l_reference_id, 1);
1334: END IF;
1335:

Line 1336: l_tp_header_id := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER9', TRUE);

1332: IF (l_Debug_Level <= 1) THEN
1333: cln_debug_pub.Add('Reference ID : '||l_reference_id, 1);
1334: END IF;
1335:
1336: l_tp_header_id := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER9', TRUE);
1337: IF (l_Debug_Level <= 1) THEN
1338: cln_debug_pub.Add('Trading Partner HeaderID : '||l_tp_header_id, 1);
1339: END IF;
1340:

Line 1480: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);

1476: cln_debug_pub.Add('PARAMETER4: '||l_notification_code, 1);
1477: END IF;
1478:
1479:
1480: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
1481: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
1482: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS',l_doc_status );
1483: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', l_notification_code);
1484: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'COLL_UPDATE_MSG', l_return_desc_tp);

Line 1481: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);

1477: END IF;
1478:
1479:
1480: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
1481: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
1482: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS',l_doc_status );
1483: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', l_notification_code);
1484: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'COLL_UPDATE_MSG', l_return_desc_tp);
1485:

Line 1482: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS',l_doc_status );

1478:
1479:
1480: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
1481: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
1482: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS',l_doc_status );
1483: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', l_notification_code);
1484: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'COLL_UPDATE_MSG', l_return_desc_tp);
1485:
1486: IF (l_Debug_Level <= 2) THEN

Line 1483: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', l_notification_code);

1479:
1480: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
1481: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
1482: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS',l_doc_status );
1483: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', l_notification_code);
1484: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'COLL_UPDATE_MSG', l_return_desc_tp);
1485:
1486: IF (l_Debug_Level <= 2) THEN
1487: cln_debug_pub.Add('------- Exiting INVOICE_IMPORT_STATUS_HANDLER API --------- ',2);

Line 1484: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'COLL_UPDATE_MSG', l_return_desc_tp);

1480: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
1481: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
1482: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS',l_doc_status );
1483: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', l_notification_code);
1484: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'COLL_UPDATE_MSG', l_return_desc_tp);
1485:
1486: IF (l_Debug_Level <= 2) THEN
1487: cln_debug_pub.Add('------- Exiting INVOICE_IMPORT_STATUS_HANDLER API --------- ',2);
1488: END IF;

Line 1650: l_notif_code:=wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'NOTIF_CODE');

1646: cln_debug_pub.Add('Entering the procedure NOTIFY_INVOICE_TO_SYSADMIN', 2);
1647: END IF;
1648:
1649: -- get the workflow activity attributes.
1650: l_notif_code:=wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'NOTIF_CODE');
1651:
1652: IF (l_debug_level <= 1) THEN
1653: cln_debug_pub.Add('Notification_code:'|| l_notif_code , 1);
1654: END IF;

Line 1656: l_notif_desc:=wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'NOTIF_DESC');

1652: IF (l_debug_level <= 1) THEN
1653: cln_debug_pub.Add('Notification_code:'|| l_notif_code , 1);
1654: END IF;
1655:
1656: l_notif_desc:=wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'NOTIF_DESC');
1657:
1658: IF (l_debug_level <= 1) THEN
1659: cln_debug_pub.Add('Notification_description:'|| l_notif_desc , 1);
1660: END IF;

Line 1662: l_status:=wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'STATUS');

1658: IF (l_debug_level <= 1) THEN
1659: cln_debug_pub.Add('Notification_description:'|| l_notif_desc , 1);
1660: END IF;
1661:
1662: l_status:=wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'STATUS');
1663:
1664: IF (l_debug_level <= 1) THEN
1665: cln_debug_pub.Add('Status:'|| l_status , 1);
1666: END IF;

Line 1668: l_tp_id:=wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'TPID');

1664: IF (l_debug_level <= 1) THEN
1665: cln_debug_pub.Add('Status:'|| l_status , 1);
1666: END IF;
1667:
1668: l_tp_id:=wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'TPID');
1669:
1670: IF (l_debug_level <= 1) THEN
1671: cln_debug_pub.Add('Trading Partner ID:'|| l_tp_id , 1);
1672: END IF;

Line 1676: l_coll_pt:=wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'COLL_POINT');

1672: END IF;
1673:
1674: l_app_ref_id := '';
1675:
1676: l_coll_pt:=wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'COLL_POINT');
1677:
1678: IF (l_debug_level <= 1) THEN
1679: cln_debug_pub.Add('Collaboration Point:'|| l_coll_pt, 1);
1680: END IF;

Line 1682: l_intrl_cntrl_num:=wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'XMLG_INTERNAL_CONTROL_NUMBER');

1678: IF (l_debug_level <= 1) THEN
1679: cln_debug_pub.Add('Collaboration Point:'|| l_coll_pt, 1);
1680: END IF;
1681:
1682: l_intrl_cntrl_num:=wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'XMLG_INTERNAL_CONTROL_NUMBER');
1683:
1684: IF (l_debug_level <= 1) THEN
1685: cln_debug_pub.Add('Internal Control Number:'|| l_intrl_cntrl_num, 1);
1686: END IF;