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

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

890: l_msg_data :='Status returned from XGM checked for further processing';
891:
892: -- Do nothing in cancel or timeout mode
893: --
894: IF (p_funcmode <> wf_engine.eng_run) THEN
895: x_resultout := wf_engine.eng_null;
896: IF (l_Debug_Level <= 1) THEN
897: cln_debug_pub.Add('Not in Running Mode...........Return Here',1);
898: END IF;

Line 895: x_resultout := wf_engine.eng_null;

891:
892: -- Do nothing in cancel or timeout mode
893: --
894: IF (p_funcmode <> wf_engine.eng_run) THEN
895: x_resultout := wf_engine.eng_null;
896: IF (l_Debug_Level <= 1) THEN
897: cln_debug_pub.Add('Not in Running Mode...........Return Here',1);
898: END IF;
899:

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

900: RETURN;
901: END IF;
902:
903: -- Should be S for success
904: l_return_status_tp := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER7', TRUE);
905: IF (l_Debug_Level <= 1) THEN
906: cln_debug_pub.Add('Return Status as obtained from workflow : '||l_return_status_tp,1);
907: END IF;
908:

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

905: IF (l_Debug_Level <= 1) THEN
906: cln_debug_pub.Add('Return Status as obtained from workflow : '||l_return_status_tp,1);
907: END IF;
908:
909: l_sender_header_id := TO_NUMBER(wf_engine.GetItemAttrText(p_itemtype, p_itemkey,'PARAMETER9', TRUE));
910: IF (l_Debug_Level <= 1) THEN
911: cln_debug_pub.Add('Trading Partner Header ID : '||l_sender_header_id, 1);
912: END IF;
913:

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

910: IF (l_Debug_Level <= 1) THEN
911: cln_debug_pub.Add('Trading Partner Header ID : '||l_sender_header_id, 1);
912: END IF;
913:
914: l_notification_code := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', TRUE);
915: IF (l_Debug_Level <= 1) THEN
916: cln_debug_pub.Add('Notification Code : '||l_notification_code, 1);
917: END IF;
918:

Line 919: l_notification_status := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER5', TRUE);

915: IF (l_Debug_Level <= 1) THEN
916: cln_debug_pub.Add('Notification Code : '||l_notification_code, 1);
917: END IF;
918:
919: l_notification_status := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER5', TRUE);
920: IF (l_Debug_Level <= 1) THEN
921: cln_debug_pub.Add('Notification Status : '||l_notification_status, 1);
922: END IF;
923:

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

920: IF (l_Debug_Level <= 1) THEN
921: cln_debug_pub.Add('Notification Status : '||l_notification_status, 1);
922: END IF;
923:
924: l_internal_control_number := TO_NUMBER(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'EVENT_KEY', TRUE));
925: IF (l_Debug_Level <= 1) THEN
926: cln_debug_pub.Add('Internal Control Number : '||l_internal_control_number, 1);
927: END IF;
928:

Line 938: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'CLN_ORG_ITEM_IMPORT','2' );

934: cln_debug_pub.Add('Organization Choice : '||l_org_item_import, 1);
935: END IF;
936:
937: IF (l_org_item_import IS NULL) OR (l_org_item_import = 'MASTER_ORG' ) THEN
938: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'CLN_ORG_ITEM_IMPORT','2' );
939: ELSE
940: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'CLN_ORG_ITEM_IMPORT','1' );
941: END IF;
942:

Line 940: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'CLN_ORG_ITEM_IMPORT','1' );

936:
937: IF (l_org_item_import IS NULL) OR (l_org_item_import = 'MASTER_ORG' ) THEN
938: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'CLN_ORG_ITEM_IMPORT','2' );
939: ELSE
940: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'CLN_ORG_ITEM_IMPORT','1' );
941: END IF;
942:
943:
944: IF (l_sender_header_id IS NOT NULL) THEN

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

968: IF (l_Debug_Level <= 1) THEN
969: cln_debug_pub.Add('Supplier Name : '||l_supplier_name,1);
970: END IF;
971:
972: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARTY_ID', l_party_id);
973: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARTY_SITE_ID', l_party_site_id);
974: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARTY_TYPE', l_party_type);
975: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'SUPPLIER_NAME', l_supplier_name);
976: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'XMLG_DOCUMENT_ID',l_event_key );

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

969: cln_debug_pub.Add('Supplier Name : '||l_supplier_name,1);
970: END IF;
971:
972: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARTY_ID', l_party_id);
973: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARTY_SITE_ID', l_party_site_id);
974: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARTY_TYPE', l_party_type);
975: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'SUPPLIER_NAME', l_supplier_name);
976: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'XMLG_DOCUMENT_ID',l_event_key );
977:

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

970: END IF;
971:
972: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARTY_ID', l_party_id);
973: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARTY_SITE_ID', l_party_site_id);
974: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARTY_TYPE', l_party_type);
975: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'SUPPLIER_NAME', l_supplier_name);
976: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'XMLG_DOCUMENT_ID',l_event_key );
977:
978: END IF;

Line 975: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'SUPPLIER_NAME', l_supplier_name);

971:
972: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARTY_ID', l_party_id);
973: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARTY_SITE_ID', l_party_site_id);
974: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARTY_TYPE', l_party_type);
975: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'SUPPLIER_NAME', l_supplier_name);
976: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'XMLG_DOCUMENT_ID',l_event_key );
977:
978: END IF;
979:

Line 976: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'XMLG_DOCUMENT_ID',l_event_key );

972: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARTY_ID', l_party_id);
973: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARTY_SITE_ID', l_party_site_id);
974: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARTY_TYPE', l_party_type);
975: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'SUPPLIER_NAME', l_supplier_name);
976: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'XMLG_DOCUMENT_ID',l_event_key );
977:
978: END IF;
979:
980: -- send notification code to the buyer and seller.

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

1011: IF (l_Debug_Level <= 1) THEN
1012: cln_debug_pub.Add('Return Status is Success',1);
1013: END IF;
1014:
1015: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', '00');
1016: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', 'SUCCESS');
1017: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS', 'SUCCESS');
1018:
1019: x_resultout := 'COMPLETE:'||'TRUE';

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

1012: cln_debug_pub.Add('Return Status is Success',1);
1013: END IF;
1014:
1015: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', '00');
1016: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', 'SUCCESS');
1017: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS', 'SUCCESS');
1018:
1019: x_resultout := 'COMPLETE:'||'TRUE';
1020:

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

1013: END IF;
1014:
1015: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', '00');
1016: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', 'SUCCESS');
1017: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS', 'SUCCESS');
1018:
1019: x_resultout := 'COMPLETE:'||'TRUE';
1020:
1021: ELSIF(l_return_status_tp = '99') THEN

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

1023: IF (l_Debug_Level <= 1) THEN
1024: cln_debug_pub.Add('Return Status is Error',1);
1025: END IF;
1026:
1027: l_return_desc_tp := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER8', TRUE);
1028:
1029: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', '99');
1030: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
1031: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS', 'ERROR');

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

1025: END IF;
1026:
1027: l_return_desc_tp := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER8', TRUE);
1028:
1029: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', '99');
1030: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
1031: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS', 'ERROR');
1032: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', 'SYN_ITM05');
1033:

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

1026:
1027: l_return_desc_tp := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER8', TRUE);
1028:
1029: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', '99');
1030: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
1031: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS', 'ERROR');
1032: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', 'SYN_ITM05');
1033:
1034: IF (l_Debug_Level <= 1) THEN

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

1027: l_return_desc_tp := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER8', TRUE);
1028:
1029: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', '99');
1030: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
1031: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS', 'ERROR');
1032: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', 'SYN_ITM05');
1033:
1034: IF (l_Debug_Level <= 1) THEN
1035: cln_debug_pub.Add('Message for the trading partner : '||l_return_desc_tp, 1);

Line 1032: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', 'SYN_ITM05');

1028:
1029: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', '99');
1030: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
1031: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS', 'ERROR');
1032: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', 'SYN_ITM05');
1033:
1034: IF (l_Debug_Level <= 1) THEN
1035: cln_debug_pub.Add('Message for the trading partner : '||l_return_desc_tp, 1);
1036: END IF;

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

1062: -- negative confirm bod is sent out with error occured here
1063: l_return_status_tp := '99';
1064: l_return_desc_tp := FND_MESSAGE.GET;
1065:
1066: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
1067: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
1068: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS', 'ERROR');
1069: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', 'SYN_ITM05');
1070:

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

1063: l_return_status_tp := '99';
1064: l_return_desc_tp := FND_MESSAGE.GET;
1065:
1066: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
1067: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
1068: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS', 'ERROR');
1069: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', 'SYN_ITM05');
1070:
1071: x_resultout := 'COMPLETE:'||'FALSE';

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

1064: l_return_desc_tp := FND_MESSAGE.GET;
1065:
1066: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
1067: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
1068: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS', 'ERROR');
1069: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', 'SYN_ITM05');
1070:
1071: x_resultout := 'COMPLETE:'||'FALSE';
1072:

Line 1069: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', 'SYN_ITM05');

1065:
1066: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
1067: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
1068: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS', 'ERROR');
1069: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', 'SYN_ITM05');
1070:
1071: x_resultout := 'COMPLETE:'||'FALSE';
1072:
1073: CLN_NP_PROCESSOR_PKG.NOTIFY_ADMINISTRATOR(l_return_desc_tp);

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

1139: x_resultout := 'COMPLETE:'||'TRUE';
1140:
1141: -- Do nothing in cancel or timeout mode
1142: --
1143: IF (p_funcmode <> wf_engine.eng_run) THEN
1144: x_resultout := wf_engine.eng_null;
1145: IF (l_Debug_Level <= 1) THEN
1146: cln_debug_pub.Add('Not in Running Mode...........Return Here',1);
1147: END IF;

Line 1144: x_resultout := wf_engine.eng_null;

1140:
1141: -- Do nothing in cancel or timeout mode
1142: --
1143: IF (p_funcmode <> wf_engine.eng_run) THEN
1144: x_resultout := wf_engine.eng_null;
1145: IF (l_Debug_Level <= 1) THEN
1146: cln_debug_pub.Add('Not in Running Mode...........Return Here',1);
1147: END IF;
1148: RETURN;

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

1148: RETURN;
1149: END IF;
1150:
1151: -- Getting the values from the workflow.
1152: l_internal_control_number := TO_NUMBER(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'EVENT_KEY', TRUE));
1153: IF (l_Debug_Level <= 1) THEN
1154: cln_debug_pub.Add('Internal Control Number : '||l_internal_control_number, 1);
1155: END IF;
1156:

Line 1157: l_supplier_name := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'SUPPLIER_NAME', TRUE);

1153: IF (l_Debug_Level <= 1) THEN
1154: cln_debug_pub.Add('Internal Control Number : '||l_internal_control_number, 1);
1155: END IF;
1156:
1157: l_supplier_name := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'SUPPLIER_NAME', TRUE);
1158: IF (l_Debug_Level <= 1) THEN
1159: cln_debug_pub.Add('Supplier Name : '||l_supplier_name, 1);
1160: END IF;
1161:

Line 1162: l_master_organization_id := TO_NUMBER(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER3', TRUE));

1158: IF (l_Debug_Level <= 1) THEN
1159: cln_debug_pub.Add('Supplier Name : '||l_supplier_name, 1);
1160: END IF;
1161:
1162: l_master_organization_id := TO_NUMBER(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER3', TRUE));
1163: IF (l_Debug_Level <= 1) THEN
1164: cln_debug_pub.Add('Master Organization ID : '||l_master_organization_id, 1);
1165: END IF;
1166:

Line 1167: l_set_process_id := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER6', TRUE);

1163: IF (l_Debug_Level <= 1) THEN
1164: cln_debug_pub.Add('Master Organization ID : '||l_master_organization_id, 1);
1165: END IF;
1166:
1167: l_set_process_id := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER6', TRUE);
1168: IF (l_Debug_Level <= 1) THEN
1169: cln_debug_pub.Add('Set Process ID : '||l_set_process_id, 1);
1170: END IF;
1171:

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

1168: IF (l_Debug_Level <= 1) THEN
1169: cln_debug_pub.Add('Set Process ID : '||l_set_process_id, 1);
1170: END IF;
1171:
1172: l_request_id := TO_NUMBER(wf_engine.GetItemAttrText(p_itemtype, p_itemkey,'REQIDNAME', TRUE));
1173: IF (l_Debug_Level <= 1) THEN
1174: cln_debug_pub.Add('Concurrent Program Request ID : '||l_request_id, 1);
1175: END IF;
1176:

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

1173: IF (l_Debug_Level <= 1) THEN
1174: cln_debug_pub.Add('Concurrent Program Request ID : '||l_request_id, 1);
1175: END IF;
1176:
1177: l_notification_code := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', TRUE);
1178: IF (l_Debug_Level <= 1) THEN
1179: cln_debug_pub.Add('Notification Code : '||l_notification_code, 1);
1180: END IF;
1181:

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

1411: END LOOP;
1412: CLOSE c_cursor_error;
1413: END IF;
1414:
1415: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
1416: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
1417: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS',l_doc_status );
1418: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', l_notification_code);
1419:

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

1412: CLOSE c_cursor_error;
1413: END IF;
1414:
1415: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
1416: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
1417: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS',l_doc_status );
1418: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', l_notification_code);
1419:
1420:

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

1413: END IF;
1414:
1415: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
1416: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
1417: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS',l_doc_status );
1418: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', l_notification_code);
1419:
1420:
1421:

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

1414:
1415: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
1416: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
1417: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS',l_doc_status );
1418: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', l_notification_code);
1419:
1420:
1421:
1422: IF (l_Debug_Level <= 1) THEN

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

1453: -- negative confirm bod is sent out with error occured here
1454: l_return_status_tp := '99';
1455: l_return_desc_tp := FND_MESSAGE.GET;
1456:
1457: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
1458: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
1459: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS','ERROR' );
1460: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', 'SYN_ITM05');
1461:

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

1454: l_return_status_tp := '99';
1455: l_return_desc_tp := FND_MESSAGE.GET;
1456:
1457: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
1458: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
1459: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS','ERROR' );
1460: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', 'SYN_ITM05');
1461:
1462:

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

1455: l_return_desc_tp := FND_MESSAGE.GET;
1456:
1457: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
1458: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
1459: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS','ERROR' );
1460: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', 'SYN_ITM05');
1461:
1462:
1463: x_resultout := 'COMPLETE:'||'FALSE';

Line 1460: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', 'SYN_ITM05');

1456:
1457: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
1458: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
1459: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS','ERROR' );
1460: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', 'SYN_ITM05');
1461:
1462:
1463: x_resultout := 'COMPLETE:'||'FALSE';
1464:

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

1533: l_msg_data :='Costing interface tables populated with correct values of inventory_item_id';
1534:
1535: -- Do nothing in cancel or timeout mode
1536: --
1537: IF (p_funcmode <> wf_engine.eng_run) THEN
1538: x_resultout := wf_engine.eng_null;
1539: IF (l_Debug_Level <= 1) THEN
1540: cln_debug_pub.Add('Not in Running Mode...........Return Here',1);
1541: END IF;

Line 1538: x_resultout := wf_engine.eng_null;

1534:
1535: -- Do nothing in cancel or timeout mode
1536: --
1537: IF (p_funcmode <> wf_engine.eng_run) THEN
1538: x_resultout := wf_engine.eng_null;
1539: IF (l_Debug_Level <= 1) THEN
1540: cln_debug_pub.Add('Not in Running Mode...........Return Here',1);
1541: END IF;
1542: RETURN;

Line 1546: l_master_organization_id := TO_NUMBER(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER3', TRUE));

1542: RETURN;
1543: END IF;
1544:
1545: -- Getting the values from the workflow.
1546: l_master_organization_id := TO_NUMBER(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER3', TRUE));
1547: IF (l_Debug_Level <= 1) THEN
1548: cln_debug_pub.Add('Master Organization ID : '||l_master_organization_id, 1);
1549: END IF;
1550:

Line 1551: l_set_process_id := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER6', TRUE);

1547: IF (l_Debug_Level <= 1) THEN
1548: cln_debug_pub.Add('Master Organization ID : '||l_master_organization_id, 1);
1549: END IF;
1550:
1551: l_set_process_id := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER6', TRUE);
1552: IF (l_Debug_Level <= 1) THEN
1553: cln_debug_pub.Add('Set Process ID : '||l_set_process_id, 1);
1554: END IF;
1555:

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

1552: IF (l_Debug_Level <= 1) THEN
1553: cln_debug_pub.Add('Set Process ID : '||l_set_process_id, 1);
1554: END IF;
1555:
1556: l_internal_control_number := TO_NUMBER(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'EVENT_KEY', TRUE));
1557: IF (l_Debug_Level <= 1) THEN
1558: cln_debug_pub.Add('Internal Control Number : '||l_internal_control_number, 1);
1559: END IF;
1560:

Line 1561: l_cst_group_id := TO_NUMBER(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER10', TRUE));

1557: IF (l_Debug_Level <= 1) THEN
1558: cln_debug_pub.Add('Internal Control Number : '||l_internal_control_number, 1);
1559: END IF;
1560:
1561: l_cst_group_id := TO_NUMBER(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER10', TRUE));
1562: IF (l_Debug_Level <= 1) THEN
1563: cln_debug_pub.Add('Costing Group ID : '||l_cst_group_id, 1);
1564: END IF;
1565:

Line 1566: l_supplier_name := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'SUPPLIER_NAME', TRUE);

1562: IF (l_Debug_Level <= 1) THEN
1563: cln_debug_pub.Add('Costing Group ID : '||l_cst_group_id, 1);
1564: END IF;
1565:
1566: l_supplier_name := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'SUPPLIER_NAME', TRUE);
1567: IF (l_Debug_Level <= 1) THEN
1568: cln_debug_pub.Add('Supplier Name : '||l_supplier_name, 1);
1569: END IF;
1570:

Line 1593: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'COST_TYPE',l_cost_type );

1589: IF (l_Debug_Level <= 1) THEN
1590: cln_debug_pub.Add('Cost Type not defined', 1);
1591: END IF;
1592: ELSE
1593: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'COST_TYPE',l_cost_type );
1594: END IF;
1595:
1596:
1597: -- get the relevant resource id

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

1617:
1618: IF (l_check = 'ERROR') THEN
1619:
1620: l_return_status_tp := '99';
1621: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
1622: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
1623: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS','ERROR' );
1624: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', 'SYN_ITM05');
1625:

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

1618: IF (l_check = 'ERROR') THEN
1619:
1620: l_return_status_tp := '99';
1621: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
1622: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
1623: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS','ERROR' );
1624: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', 'SYN_ITM05');
1625:
1626: -- generate an event key which is also passed as event key for update collaboration .

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

1619:
1620: l_return_status_tp := '99';
1621: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
1622: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
1623: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS','ERROR' );
1624: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', 'SYN_ITM05');
1625:
1626: -- generate an event key which is also passed as event key for update collaboration .
1627: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;

Line 1624: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', 'SYN_ITM05');

1620: l_return_status_tp := '99';
1621: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
1622: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
1623: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS','ERROR' );
1624: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', 'SYN_ITM05');
1625:
1626: -- generate an event key which is also passed as event key for update collaboration .
1627: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;
1628:

Line 1817: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'REQIDNAME',null);

1813: IF (l_Debug_Level <= 1) THEN
1814: cln_debug_pub.Add('Insertion of the rows in the interface table successful', 1);
1815: END IF;
1816:
1817: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'REQIDNAME',null);
1818:
1819:
1820: x_resultout := 'COMPLETE:'||'TRUE';
1821:

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

1852: -- negative confirm bod is sent out with error occured here
1853: l_return_status_tp := '99';
1854: l_return_desc_tp := FND_MESSAGE.GET;
1855:
1856: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
1857: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
1858: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS','ERROR' );
1859: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', 'SYN_ITM05');
1860:

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

1853: l_return_status_tp := '99';
1854: l_return_desc_tp := FND_MESSAGE.GET;
1855:
1856: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
1857: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
1858: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS','ERROR' );
1859: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', 'SYN_ITM05');
1860:
1861: x_resultout := 'COMPLETE:'||'FALSE';

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

1854: l_return_desc_tp := FND_MESSAGE.GET;
1855:
1856: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
1857: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
1858: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS','ERROR' );
1859: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', 'SYN_ITM05');
1860:
1861: x_resultout := 'COMPLETE:'||'FALSE';
1862:

Line 1859: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', 'SYN_ITM05');

1855:
1856: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
1857: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
1858: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS','ERROR' );
1859: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', 'SYN_ITM05');
1860:
1861: x_resultout := 'COMPLETE:'||'FALSE';
1862:
1863: CLN_NP_PROCESSOR_PKG.NOTIFY_ADMINISTRATOR(l_return_desc_tp);

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

1932: l_msg_data :='Updating the collaboration history with the new status after running the Cost Import Process';
1933:
1934: -- Do nothing in cancel or timeout mode
1935: --
1936: IF (p_funcmode <> wf_engine.eng_run) THEN
1937: x_resultout := wf_engine.eng_null;
1938: IF (l_Debug_Level <= 1) THEN
1939: cln_debug_pub.Add('Not in Running Mode...........Return Here',1);
1940: END IF;

Line 1937: x_resultout := wf_engine.eng_null;

1933:
1934: -- Do nothing in cancel or timeout mode
1935: --
1936: IF (p_funcmode <> wf_engine.eng_run) THEN
1937: x_resultout := wf_engine.eng_null;
1938: IF (l_Debug_Level <= 1) THEN
1939: cln_debug_pub.Add('Not in Running Mode...........Return Here',1);
1940: END IF;
1941: RETURN;

Line 1946: l_return_status_tp := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', TRUE);

1942: END IF;
1943:
1944: -- Getting the values from the workflow.
1945:
1946: l_return_status_tp := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', TRUE);
1947: IF (l_Debug_Level <= 1) THEN
1948: cln_debug_pub.Add('Return Status for the trading partner : '||l_return_status_tp, 1);
1949: END IF;
1950:

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

1947: IF (l_Debug_Level <= 1) THEN
1948: cln_debug_pub.Add('Return Status for the trading partner : '||l_return_status_tp, 1);
1949: END IF;
1950:
1951: l_notification_code := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', TRUE);
1952: IF (l_Debug_Level <= 1) THEN
1953: cln_debug_pub.Add('Notification Code : '||l_notification_code, 1);
1954: END IF;
1955:

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

1952: IF (l_Debug_Level <= 1) THEN
1953: cln_debug_pub.Add('Notification Code : '||l_notification_code, 1);
1954: END IF;
1955:
1956: l_internal_control_number := TO_NUMBER(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'EVENT_KEY', TRUE));
1957: IF (l_Debug_Level <= 1) THEN
1958: cln_debug_pub.Add('Internal Control Number : '||l_internal_control_number, 1);
1959: END IF;
1960:

Line 1961: l_master_organization_id := TO_NUMBER(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER3', TRUE));

1957: IF (l_Debug_Level <= 1) THEN
1958: cln_debug_pub.Add('Internal Control Number : '||l_internal_control_number, 1);
1959: END IF;
1960:
1961: l_master_organization_id := TO_NUMBER(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER3', TRUE));
1962: IF (l_Debug_Level <= 1) THEN
1963: cln_debug_pub.Add('Master Organization ID : '||l_master_organization_id, 1);
1964: END IF;
1965:

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

1962: IF (l_Debug_Level <= 1) THEN
1963: cln_debug_pub.Add('Master Organization ID : '||l_master_organization_id, 1);
1964: END IF;
1965:
1966: l_request_id := TO_NUMBER(wf_engine.GetItemAttrText(p_itemtype, p_itemkey,'REQIDNAME', TRUE));
1967: IF (l_Debug_Level <= 1) THEN
1968: cln_debug_pub.Add('Concurrent Program Request ID : '||l_request_id, 1);
1969: END IF;
1970:

Line 1971: l_cst_group_id := TO_NUMBER(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER10', TRUE));

1967: IF (l_Debug_Level <= 1) THEN
1968: cln_debug_pub.Add('Concurrent Program Request ID : '||l_request_id, 1);
1969: END IF;
1970:
1971: l_cst_group_id := TO_NUMBER(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER10', TRUE));
1972: IF (l_Debug_Level <= 1) THEN
1973: cln_debug_pub.Add('Costing Group ID : '||l_cst_group_id, 1);
1974: END IF;
1975:

Line 1976: l_supplier_name := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'SUPPLIER_NAME', TRUE);

1972: IF (l_Debug_Level <= 1) THEN
1973: cln_debug_pub.Add('Costing Group ID : '||l_cst_group_id, 1);
1974: END IF;
1975:
1976: l_supplier_name := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'SUPPLIER_NAME', TRUE);
1977: IF (l_Debug_Level <= 1) THEN
1978: cln_debug_pub.Add('Supplier Name : '||l_supplier_name, 1);
1979: END IF;
1980:

Line 1981: l_return_msg_tp := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', TRUE);

1977: IF (l_Debug_Level <= 1) THEN
1978: cln_debug_pub.Add('Supplier Name : '||l_supplier_name, 1);
1979: END IF;
1980:
1981: l_return_msg_tp := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', TRUE);
1982: IF (l_Debug_Level <= 1) THEN
1983: cln_debug_pub.Add('Message To Trading Partner : '||l_return_msg_tp, 1);
1984: END IF;
1985:

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

1982: IF (l_Debug_Level <= 1) THEN
1983: cln_debug_pub.Add('Message To Trading Partner : '||l_return_msg_tp, 1);
1984: END IF;
1985:
1986: l_sender_header_id := TO_NUMBER(wf_engine.GetItemAttrText(p_itemtype, p_itemkey,'PARAMETER9', TRUE));
1987: IF (l_Debug_Level <= 1) THEN
1988: cln_debug_pub.Add('Trading Partner Header ID : '||l_sender_header_id, 1);
1989: END IF;
1990:

Line 2013: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'COLLABORATION_STANDARD', l_message_standard);

2009: IF (l_Debug_Level <= 1) THEN
2010: cln_debug_pub.Add('Collaboration Standard - '||l_message_standard, 1);
2011: END IF;
2012:
2013: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'COLLABORATION_STANDARD', l_message_standard);
2014: END IF;
2015:
2016:
2017: -- sending out the notification incase of an error

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

2154: IF (l_Debug_Level <= 1) THEN
2155: cln_debug_pub.Add('Message for the trading partner : '||l_update_coll_msg, 1);
2156: END IF;
2157:
2158: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', '99');
2159: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_update_coll_msg);
2160: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS','ERROR' );
2161: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', 'SYN_ITM05');
2162:

Line 2159: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_update_coll_msg);

2155: cln_debug_pub.Add('Message for the trading partner : '||l_update_coll_msg, 1);
2156: END IF;
2157:
2158: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', '99');
2159: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_update_coll_msg);
2160: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS','ERROR' );
2161: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', 'SYN_ITM05');
2162:
2163:

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

2156: END IF;
2157:
2158: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', '99');
2159: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_update_coll_msg);
2160: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS','ERROR' );
2161: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', 'SYN_ITM05');
2162:
2163:
2164: -- SENDING OUT THE NOTIFICATION INCASE OF AN ERROR

Line 2161: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', 'SYN_ITM05');

2157:
2158: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', '99');
2159: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_update_coll_msg);
2160: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS','ERROR' );
2161: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', 'SYN_ITM05');
2162:
2163:
2164: -- SENDING OUT THE NOTIFICATION INCASE OF AN ERROR
2165: IF (l_Debug_Level <= 1) THEN

Line 2270: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'MANUFACTURER_ID', l_manufacture_id);

2266: IF (l_Debug_Level <= 1) THEN
2267: cln_debug_pub.Add('Manufacturer ID : ',l_manufacture_id);
2268: END IF;
2269:
2270: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'MANUFACTURER_ID', l_manufacture_id);
2271:
2272: EXCEPTION
2273: WHEN NO_DATA_FOUND THEN
2274: cln_debug_pub.Add('ERROR : Could not find details for the manufacturer',1);

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

2302: END IF;
2303:
2304: WF_EVENT.Raise('oracle.apps.cln.ch.collaboration.update',l_event_key, NULL, l_cln_ch_parameters, NULL);
2305:
2306: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', '99');
2307: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
2308: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS','ERROR' );
2309: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', 'SYN_ITM05');
2310:

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

2303:
2304: WF_EVENT.Raise('oracle.apps.cln.ch.collaboration.update',l_event_key, NULL, l_cln_ch_parameters, NULL);
2305:
2306: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', '99');
2307: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
2308: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS','ERROR' );
2309: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', 'SYN_ITM05');
2310:
2311:

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

2304: WF_EVENT.Raise('oracle.apps.cln.ch.collaboration.update',l_event_key, NULL, l_cln_ch_parameters, NULL);
2305:
2306: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', '99');
2307: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
2308: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS','ERROR' );
2309: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', 'SYN_ITM05');
2310:
2311:
2312: -- SENDING OUT THE NOTIFICATION INCASE OF AN ERROR

Line 2309: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', 'SYN_ITM05');

2305:
2306: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', '99');
2307: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
2308: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS','ERROR' );
2309: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', 'SYN_ITM05');
2310:
2311:
2312: -- SENDING OUT THE NOTIFICATION INCASE OF AN ERROR
2313: IF (l_Debug_Level <= 1) THEN

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

2360:
2361: RAISE FND_API.G_EXC_ERROR;
2362: END IF;
2363:
2364: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
2365: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', 'SUCCESS');
2366:
2367: IF (l_Debug_Level <= 1) THEN
2368: cln_debug_pub.Add(l_msg_data,1);

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

2361: RAISE FND_API.G_EXC_ERROR;
2362: END IF;
2363:
2364: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
2365: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', 'SUCCESS');
2366:
2367: IF (l_Debug_Level <= 1) THEN
2368: cln_debug_pub.Add(l_msg_data,1);
2369: END IF;

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

2393: -- negative confirm bod is sent out with error occured here
2394: l_return_status_tp := '99';
2395: l_return_desc_tp := FND_MESSAGE.GET;
2396:
2397: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
2398: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
2399: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS','ERROR' );
2400:
2401: CLN_NP_PROCESSOR_PKG.NOTIFY_ADMINISTRATOR(FND_MESSAGE.GET);

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

2394: l_return_status_tp := '99';
2395: l_return_desc_tp := FND_MESSAGE.GET;
2396:
2397: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
2398: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
2399: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS','ERROR' );
2400:
2401: CLN_NP_PROCESSOR_PKG.NOTIFY_ADMINISTRATOR(FND_MESSAGE.GET);
2402:

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

2395: l_return_desc_tp := FND_MESSAGE.GET;
2396:
2397: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
2398: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
2399: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS','ERROR' );
2400:
2401: CLN_NP_PROCESSOR_PKG.NOTIFY_ADMINISTRATOR(FND_MESSAGE.GET);
2402:
2403: IF (l_Debug_Level <= 6) THEN

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

2464: l_msg_data :='Concurrent Program for the Manufacturing Part Number completed Normally.';
2465:
2466: -- Do nothing in cancel or timeout mode
2467: --
2468: IF (p_funcmode <> wf_engine.eng_run) THEN
2469: x_resultout := wf_engine.eng_null;
2470: IF (l_Debug_Level <= 1) THEN
2471: cln_debug_pub.Add('Not in Running Mode...........Return Here',1);
2472: END IF;

Line 2469: x_resultout := wf_engine.eng_null;

2465:
2466: -- Do nothing in cancel or timeout mode
2467: --
2468: IF (p_funcmode <> wf_engine.eng_run) THEN
2469: x_resultout := wf_engine.eng_null;
2470: IF (l_Debug_Level <= 1) THEN
2471: cln_debug_pub.Add('Not in Running Mode...........Return Here',1);
2472: END IF;
2473: RETURN;

Line 2478: l_return_status_tp := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', TRUE);

2474: END IF;
2475:
2476: -- Getting the values from the workflow.
2477:
2478: l_return_status_tp := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', TRUE);
2479: IF (l_Debug_Level <= 1) THEN
2480: cln_debug_pub.Add('Return Status for the trading partner : '||l_return_status_tp, 1);
2481: END IF;
2482:

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

2479: IF (l_Debug_Level <= 1) THEN
2480: cln_debug_pub.Add('Return Status for the trading partner : '||l_return_status_tp, 1);
2481: END IF;
2482:
2483: l_notification_code := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', TRUE);
2484: IF (l_Debug_Level <= 1) THEN
2485: cln_debug_pub.Add('Notification Code : '||l_notification_code, 1);
2486: END IF;
2487:

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

2484: IF (l_Debug_Level <= 1) THEN
2485: cln_debug_pub.Add('Notification Code : '||l_notification_code, 1);
2486: END IF;
2487:
2488: l_internal_control_number := TO_NUMBER(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'EVENT_KEY', TRUE));
2489: IF (l_Debug_Level <= 1) THEN
2490: cln_debug_pub.Add('Internal Control Number : '||l_internal_control_number, 1);
2491: END IF;
2492:

Line 2493: l_master_organization_id := TO_NUMBER(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER3', TRUE));

2489: IF (l_Debug_Level <= 1) THEN
2490: cln_debug_pub.Add('Internal Control Number : '||l_internal_control_number, 1);
2491: END IF;
2492:
2493: l_master_organization_id := TO_NUMBER(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER3', TRUE));
2494: IF (l_Debug_Level <= 1) THEN
2495: cln_debug_pub.Add('Master Organization ID : '||l_master_organization_id, 1);
2496: END IF;
2497:

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

2494: IF (l_Debug_Level <= 1) THEN
2495: cln_debug_pub.Add('Master Organization ID : '||l_master_organization_id, 1);
2496: END IF;
2497:
2498: l_request_id := TO_NUMBER(wf_engine.GetItemAttrText(p_itemtype, p_itemkey,'REQIDNAME', TRUE));
2499: IF (l_Debug_Level <= 1) THEN
2500: cln_debug_pub.Add('Concurrent Program Request ID : '||l_request_id, 1);
2501: END IF;
2502:

Line 2503: l_return_msg_tp := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', TRUE);

2499: IF (l_Debug_Level <= 1) THEN
2500: cln_debug_pub.Add('Concurrent Program Request ID : '||l_request_id, 1);
2501: END IF;
2502:
2503: l_return_msg_tp := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', TRUE);
2504: IF (l_Debug_Level <= 1) THEN
2505: cln_debug_pub.Add('Message To Trading Partner : '||l_return_msg_tp, 1);
2506: END IF;
2507:

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

2504: IF (l_Debug_Level <= 1) THEN
2505: cln_debug_pub.Add('Message To Trading Partner : '||l_return_msg_tp, 1);
2506: END IF;
2507:
2508: l_sender_header_id := TO_NUMBER(wf_engine.GetItemAttrText(p_itemtype, p_itemkey,'PARAMETER9', TRUE));
2509: IF (l_Debug_Level <= 1) THEN
2510: cln_debug_pub.Add('Trading Partner Header ID : '||l_sender_header_id, 1);
2511: END IF;
2512:

Line 2513: l_cst_group_id := TO_NUMBER(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER10', TRUE));

2509: IF (l_Debug_Level <= 1) THEN
2510: cln_debug_pub.Add('Trading Partner Header ID : '||l_sender_header_id, 1);
2511: END IF;
2512:
2513: l_cst_group_id := TO_NUMBER(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER10', TRUE));
2514: IF (l_Debug_Level <= 1) THEN
2515: cln_debug_pub.Add('Costing Group ID : '||l_cst_group_id, 1);
2516: END IF;
2517:

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

2577: IF (l_Debug_Level <= 1) THEN
2578: cln_debug_pub.Add('Message for the trading partner : '||l_update_coll_msg, 1);
2579: END IF;
2580:
2581: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', '99');
2582: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_update_coll_msg);
2583: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS','ERROR' );
2584: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', 'SYN_ITM05');
2585:

Line 2582: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_update_coll_msg);

2578: cln_debug_pub.Add('Message for the trading partner : '||l_update_coll_msg, 1);
2579: END IF;
2580:
2581: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', '99');
2582: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_update_coll_msg);
2583: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS','ERROR' );
2584: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', 'SYN_ITM05');
2585:
2586:

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

2579: END IF;
2580:
2581: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', '99');
2582: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_update_coll_msg);
2583: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS','ERROR' );
2584: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', 'SYN_ITM05');
2585:
2586:
2587: -- SENDING OUT THE NOTIFICATION INCASE OF AN ERROR

Line 2584: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', 'SYN_ITM05');

2580:
2581: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', '99');
2582: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_update_coll_msg);
2583: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS','ERROR' );
2584: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', 'SYN_ITM05');
2585:
2586:
2587: -- SENDING OUT THE NOTIFICATION INCASE OF AN ERROR
2588: IF (l_Debug_Level <= 1) THEN

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

2651: -- negative confirm bod is sent out with error occured here
2652: l_return_status_tp := '99';
2653: l_return_desc_tp := FND_MESSAGE.GET;
2654:
2655: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
2656: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
2657: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS','ERROR' );
2658:
2659: CLN_NP_PROCESSOR_PKG.NOTIFY_ADMINISTRATOR(FND_MESSAGE.GET);

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

2652: l_return_status_tp := '99';
2653: l_return_desc_tp := FND_MESSAGE.GET;
2654:
2655: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
2656: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
2657: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS','ERROR' );
2658:
2659: CLN_NP_PROCESSOR_PKG.NOTIFY_ADMINISTRATOR(FND_MESSAGE.GET);
2660:

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

2653: l_return_desc_tp := FND_MESSAGE.GET;
2654:
2655: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
2656: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', l_return_desc_tp);
2657: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS','ERROR' );
2658:
2659: CLN_NP_PROCESSOR_PKG.NOTIFY_ADMINISTRATOR(FND_MESSAGE.GET);
2660:
2661: IF (l_Debug_Level <= 6) THEN

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

2709:
2710: l_msg_data := 'Collaboration updated with appropriate status';
2711:
2712: --
2713: IF (p_funcmode <> wf_engine.eng_run) THEN
2714: x_resultout := wf_engine.eng_null;
2715: IF (l_Debug_Level <= 1) THEN
2716: cln_debug_pub.Add('Not in Running Mode...........Return Here',1);
2717: END IF;

Line 2714: x_resultout := wf_engine.eng_null;

2710: l_msg_data := 'Collaboration updated with appropriate status';
2711:
2712: --
2713: IF (p_funcmode <> wf_engine.eng_run) THEN
2714: x_resultout := wf_engine.eng_null;
2715: IF (l_Debug_Level <= 1) THEN
2716: cln_debug_pub.Add('Not in Running Mode...........Return Here',1);
2717: END IF;
2718: RETURN;

Line 2722: l_doc_status := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS', TRUE);

2718: RETURN;
2719: END IF;
2720:
2721: -- Getting the values from the workflow.
2722: l_doc_status := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'DOCUMENT_STATUS', TRUE);
2723: IF (l_Debug_Level <= 1) THEN
2724: cln_debug_pub.Add('Document Status : '||l_doc_status, 1);
2725: END IF;
2726:

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

2723: IF (l_Debug_Level <= 1) THEN
2724: cln_debug_pub.Add('Document Status : '||l_doc_status, 1);
2725: END IF;
2726:
2727: l_internal_control_number := TO_NUMBER(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'EVENT_KEY', TRUE));
2728: IF (l_Debug_Level <= 1) THEN
2729: cln_debug_pub.Add('Internal Control Number : '||l_internal_control_number, 1);
2730: END IF;
2731:

Line 2732: l_master_organization_id := TO_NUMBER(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER3', TRUE));

2728: IF (l_Debug_Level <= 1) THEN
2729: cln_debug_pub.Add('Internal Control Number : '||l_internal_control_number, 1);
2730: END IF;
2731:
2732: l_master_organization_id := TO_NUMBER(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER3', TRUE));
2733: IF (l_Debug_Level <= 1) THEN
2734: cln_debug_pub.Add('Master Organization ID : '||l_master_organization_id, 1);
2735: END IF;
2736: