[Home] [Help]
148: l_api_name,'l_wf_created ' || l_wf_created);
149: END IF;
150:
151: if l_wf_created = 0 then
152: wf_engine.CreateProcess(
153: ItemType => p_itemtype,
154: ItemKey => l_itemkey,
155: process => p_workflow_process );
156: IF (g_asn_debug = 'Y') THEN
165: debug_log(FND_LOG.LEVEL_STATEMENT,
166: l_api_name,'Initialize workflow attributes ' );
167: END IF;
168:
169: wf_engine.SetItemAttrNumber ( itemtype => p_itemtype,
170: itemkey => l_itemkey,
171: aname => 'WORK_CONFIRMATION_ID',
172: avalue => p_work_confirmation_id);
173:
189: ||l_work_confirmation_number );
190:
191: END IF;
192:
193: wf_engine.SetItemAttrText ( itemtype => p_itemtype,
194: itemkey => l_itemkey,
195: aname => 'WORK_CONFIRMATION_NUMBER',
196: avalue => l_work_confirmation_number);
197:
205: IF (g_asn_debug = 'Y') THEN
206: debug_log(FND_LOG.LEVEL_STATEMENT,
207: l_api_name,'l_po_header_id ' || l_po_header_id); END IF;
208:
209: wf_engine.SetItemAttrNumber ( itemtype => p_itemtype,
210: itemkey => l_itemkey,
211: aname => 'PO_DOCUMENT_ID',
212: avalue => l_po_header_id);
213:
218:
219: /* Set the Org_id item attribute. We will use it to get
220: * the context for every activity
221: */
222: wf_engine.SetItemAttrNumber ( itemtype => p_itemtype,
223: itemkey => l_itemkey,
224: aname => 'ORG_ID',
225: avalue => l_orgid);
226:
231: FND_PROFILE.GET('RESP_ID', l_responsibility_id);
232: FND_PROFILE.GET('RESP_APPL_ID', l_application_id);
233: /* l_application_id := 201; */
234: --
235: wf_engine.SetItemAttrNumber ( itemtype => p_itemtype,
236: itemkey => l_itemkey,
237: aname => 'USER_ID',
238: avalue => l_user_id);
239: --
236: itemkey => l_itemkey,
237: aname => 'USER_ID',
238: avalue => l_user_id);
239: --
240: wf_engine.SetItemAttrNumber ( itemtype => p_itemtype,
241: itemkey => l_itemkey,
242: aname => 'APPLICATION_ID',
243: avalue => l_application_id);
244: --
241: itemkey => l_itemkey,
242: aname => 'APPLICATION_ID',
243: avalue => l_application_id);
244: --
245: wf_engine.SetItemAttrNumber ( itemtype => p_itemtype,
246: itemkey => l_itemkey,
247: aname => 'RESPONSIBILITY_ID',
248: avalue => l_responsibility_id);
249:
258: l_api_name,'itemtype '||p_itemtype );
259: debug_log(FND_LOG.LEVEL_STATEMENT,
260: l_api_name,'l_itemkey '||l_itemkey );
261: END IF;
262: wf_engine.StartProcess(itemtype => p_itemtype,
263: itemkey => l_itemkey );
264:
265: end if; --} itemtype, itemkey and work_confirmation_id not null
266:
318: debug_log(FND_LOG.LEVEL_STATEMENT,
319: l_api_name,'p_itemkey ' || p_itemkey);
320: END IF;
321:
322: if (p_funcmode <> wf_engine.eng_run) then
323: x_resultout := wf_engine.eng_null;
324: return;
325: end if;
326:
319: l_api_name,'p_itemkey ' || p_itemkey);
320: END IF;
321:
322: if (p_funcmode <> wf_engine.eng_run) then
323: x_resultout := wf_engine.eng_null;
324: return;
325: end if;
326:
327:
325: end if;
326:
327:
328: l_work_confirmation_id :=
329: wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
330: itemkey => p_itemkey,
331: aname => 'WORK_CONFIRMATION_ID');
332:
333: IF (g_asn_debug = 'Y') THEN
356: CloseOldNotif(p_itemtype,l_wf_itemkey);
357:
358: end if;
359:
360: x_resultout := wf_engine.eng_completed ;
361:
362: l_progress := 'POS_WCAPPROVE_PVT.close_old_notif: 02.';
363:
364: IF (g_asn_debug = 'Y') THEN
402: debug_log(FND_LOG.LEVEL_STATEMENT,
403: l_api_name,'Enter in set_startup_values ' || l_progress);
404: END IF;
405:
406: if (p_funcmode <> wf_engine.eng_run) then
407: x_resultout := wf_engine.eng_null;
408: return;
409: end if;
410:
403: l_api_name,'Enter in set_startup_values ' || l_progress);
404: END IF;
405:
406: if (p_funcmode <> wf_engine.eng_run) then
407: x_resultout := wf_engine.eng_null;
408: return;
409: end if;
410:
411: l_work_confirmation_id :=
408: return;
409: end if;
410:
411: l_work_confirmation_id :=
412: wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
413: itemkey => p_itemkey,
414: aname => 'WORK_CONFIRMATION_ID');
415:
416:
437: l_api_name,'l_wc_preparer_id ' ||
438: l_wc_preparer_id);
439: END IF;
440:
441: wf_engine.SetItemAttrNumber ( itemtype => p_itemtype,
442: itemkey => p_itemkey,
443: aname => 'WC_PREPARER_ID',
444: avalue => l_wc_preparer_id);
445:
459: debug_log(FND_LOG.LEVEL_STATEMENT,
460: l_api_name,'l_wc_preparer_display_name ' ||
461: l_wc_preparer_display_name);
462: END IF;
463: wf_engine.SetItemAttrText ( itemtype => p_itemType,
464: itemkey => p_itemkey,
465: aname => 'WC_PREPARER_NAME' ,
466: avalue => l_wc_preparer_name);
467:
464: itemkey => p_itemkey,
465: aname => 'WC_PREPARER_NAME' ,
466: avalue => l_wc_preparer_name);
467:
468: wf_engine.SetItemAttrText ( itemtype => p_itemType,
469: itemkey => p_itemkey,
470: aname => 'WC_PREPARER_DISPLAY_NAME' ,
471: avalue => l_wc_preparer_display_name);
472:
471: avalue => l_wc_preparer_display_name);
472:
473: l_progress := 'POS_WCAPPROVE_PVT.set_startup_values: 04.';
474: l_po_header_id :=
475: wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
476: itemkey => p_itemkey,
477: aname => 'PO_DOCUMENT_ID');
478:
479: IF (g_asn_debug = 'Y') THEN
485: * This is to show the status of the lines in the
486: * notification screen. So set the default to NOTREJECTED.
487: * We set it to REJECTED in reject_doc.
488: */
489: wf_engine.SetItemAttrText ( itemtype => p_itemtype,
490: itemkey => p_itemkey,
491: aname => 'DOC_STATUS',
492: avalue => 'NOTREJECTED');
493:
505: debug_log(FND_LOG.LEVEL_STATEMENT,
506: l_api_name,'l_preparer_id ' || l_po_preparer_id);
507: END IF;
508:
509: wf_engine.SetItemAttrNumber ( itemtype => p_itemtype,
510: itemkey => p_itemkey,
511: aname => 'PO_PREPARER_ID',
512: avalue => l_po_preparer_id);
513:
521: debug_log(FND_LOG.LEVEL_STATEMENT,
522: l_api_name,'l_po_preparer_display_name ' ||
523: l_po_preparer_display_name);
524: END IF;
525: wf_engine.SetItemAttrText ( itemtype => p_itemType,
526: itemkey => p_itemkey,
527: aname => 'PO_PREPARER_NAME' ,
528: avalue => l_po_preparer_name);
529:
526: itemkey => p_itemkey,
527: aname => 'PO_PREPARER_NAME' ,
528: avalue => l_po_preparer_name);
529:
530: wf_engine.SetItemAttrText ( itemtype => p_itemType,
531: itemkey => p_itemkey,
532: aname => 'PO_PREPARER_DISPLAY_NAME' ,
533: avalue => l_po_preparer_display_name);
534:
531: itemkey => p_itemkey,
532: aname => 'PO_PREPARER_DISPLAY_NAME' ,
533: avalue => l_po_preparer_display_name);
534:
535: wf_engine.SetItemAttrText ( itemtype => p_itemType,
536: itemkey => p_itemkey,
537: aname => 'AME_TRANSACTION_TYPE' ,
538: avalue => 'WCAPPROVE');
539:
536: itemkey => p_itemkey,
537: aname => 'AME_TRANSACTION_TYPE' ,
538: avalue => 'WCAPPROVE');
539:
540: wf_engine.SetItemAttrText ( itemtype => p_itemType,
541: itemkey => p_itemkey,
542: aname => 'DEFAULT_APPROVER' ,
543: avalue => 'NONE');
544:
553: transactionTypeIn => 'WCAPPROVE'
554: );
555:
556: l_work_confirmation_number :=
557: wf_engine.GetItemAttrText (itemtype => p_itemtype,
558: itemkey => p_itemkey,
559: aname => 'WORK_CONFIRMATION_NUMBER');
560:
561:
568: 'WcNum=' || (l_work_confirmation_number) || '&' ||
569: --'ReadOnly=Y' || '&' ||
570: 'addBreadCrumb=Y';
571:
572: wf_engine.SetItemAttrText ( itemtype => p_itemType,
573: itemkey => p_itemkey,
574: aname => 'VIEW_WC_LINES_DETAIL_URL' ,
575: avalue => l_view_wc_lines_detail_url);
576:
583: 'WcHeaderId=' || to_char(l_work_confirmation_id) || '&' ||
584: 'WcNum=' || (l_work_confirmation_number) || '&' ||
585: 'addBreadCrumb=Y';
586:
587: wf_engine.SetItemAttrText ( itemtype => p_itemType,
588: itemkey => p_itemkey,
589: aname => 'RESPOND_TO_WC_URL' ,
590: avalue => l_respond_to_wc_url);
591:
588: itemkey => p_itemkey,
589: aname => 'RESPOND_TO_WC_URL' ,
590: avalue => l_respond_to_wc_url);
591:
592: x_resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
593:
594: l_progress := 'POS_WCAPPROVE_PVT.set_startup_values: 06.';
595: IF (g_asn_debug = 'Y') THEN
596: debug_log(FND_LOG.LEVEL_STATEMENT,
623: debug_log(FND_LOG.LEVEL_STATEMENT,
624: l_api_name,'Enter in update_workflow_info ' || l_progress);
625: END IF;
626:
627: if (p_funcmode <> wf_engine.eng_run) then
628: x_resultout := wf_engine.eng_null;
629: return;
630: end if;
631:
624: l_api_name,'Enter in update_workflow_info ' || l_progress);
625: END IF;
626:
627: if (p_funcmode <> wf_engine.eng_run) then
628: x_resultout := wf_engine.eng_null;
629: return;
630: end if;
631:
632:
629: return;
630: end if;
631:
632:
633: l_shipment_header_id := wf_engine.GetItemAttrNumber
634: (itemtype => p_itemtype,
635: itemkey => p_itemkey,
636: aname => 'WORK_CONFIRMATION_ID');
637:
642: END IF;
643:
644: UpdateWorkflowInfo(p_itemtype,p_itemkey,l_shipment_header_id);
645:
646: x_resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
647:
648: l_progress := 'POS_WCAPPROVE_PVT.update_workflow_info: 02.';
649: IF (g_asn_debug = 'Y') THEN
650: debug_log(FND_LOG.LEVEL_STATEMENT,
689: l_api_name,'Enter in get_wc_attributes '
690: || l_progress);
691: end if;
692:
693: if (p_funcmode <> wf_engine.eng_run) then
694: x_resultout := wf_engine.eng_null;
695: return;
696: end if;
697:
690: || l_progress);
691: end if;
692:
693: if (p_funcmode <> wf_engine.eng_run) then
694: x_resultout := wf_engine.eng_null;
695: return;
696: end if;
697:
698:
695: return;
696: end if;
697:
698:
699: l_shipment_header_id := wf_engine.GetItemAttrNumber
700: (itemtype => p_itemtype,
701: itemkey => p_itemkey,
702: aname => 'WORK_CONFIRMATION_ID');
703:
745: close get_attachments;
746: end if;
747: end if;--}
748: */
749: x_resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
750: exception
751: when others then
752: IF (g_asn_debug = 'Y') THEN
753: debug_log(FND_LOG.LEVEL_UNEXPECTED,
804: l_api_name,'Enter in Ins_Actionhist_submit '
805: || l_progress);
806: END IF;
807:
808: if (p_funcmode <> wf_engine.eng_run) then
809: x_resultout := wf_engine.eng_null;
810: return;
811: end if;
812:
805: || l_progress);
806: END IF;
807:
808: if (p_funcmode <> wf_engine.eng_run) then
809: x_resultout := wf_engine.eng_null;
810: return;
811: end if;
812:
813: l_shipment_header_id := wf_engine.GetItemAttrNumber
809: x_resultout := wf_engine.eng_null;
810: return;
811: end if;
812:
813: l_shipment_header_id := wf_engine.GetItemAttrNumber
814: (itemtype => p_itemtype,
815: itemkey => p_itemkey,
816: aname => 'WORK_CONFIRMATION_ID');
817:
820: l_api_name,'l_shipment_header_id ' || l_shipment_header_id);
821: END IF;
822:
823: l_progress := 'POS_WCAPPROVE_PVT.Ins_Actionhist_submit: 02.';
824: l_wc_preparer_id := wf_engine.GetItemAttrNumber
825: (itemtype => p_itemtype,
826: itemkey => p_itemkey,
827: aname => 'WC_PREPARER_ID');
828:
951:
952:
953:
954:
955: x_resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
956:
957: l_progress := 'POS_WCAPPROVE_PVT.Ins_Actionhist_submit: 07.';
958: IF (g_asn_debug = 'Y') THEN
959: debug_log(FND_LOG.LEVEL_STATEMENT,
1005: l_api_name,'Enter in get_next_approver '
1006: || l_progress);
1007: END IF;
1008:
1009: if (p_funcmode <> wf_engine.eng_run) then
1010: IF (g_asn_debug = 'Y') THEN
1011: debug_log(FND_LOG.LEVEL_STATEMENT,
1012: l_api_name,'funcmode in get_next_approver '
1013: || l_progress);
1012: l_api_name,'funcmode in get_next_approver '
1013: || l_progress);
1014: END IF;
1015:
1016: x_resultout := wf_engine.eng_null;
1017: return;
1018: end if;
1019:
1020: l_shipment_header_id := wf_engine.GetItemAttrNumber
1016: x_resultout := wf_engine.eng_null;
1017: return;
1018: end if;
1019:
1020: l_shipment_header_id := wf_engine.GetItemAttrNumber
1021: (itemtype => p_itemtype,
1022: itemkey => p_itemkey,
1023: aname => 'WORK_CONFIRMATION_ID');
1024:
1026: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
1027: 'l_shipment_header_id ' || l_shipment_header_id);
1028: END IF;
1029:
1030: l_po_header_id := wf_engine.GetItemAttrNumber
1031: (itemtype => p_itemtype,
1032: itemkey => p_itemkey,
1033: aname => 'PO_DOCUMENT_ID');
1034:
1037: 'l_po_header_id ' || l_po_header_id);
1038: END IF;
1039:
1040: l_work_confirmation_number :=
1041: wf_engine.GetItemAttrText (itemtype => p_itemtype,
1042: itemkey => p_itemkey,
1043: aname => 'WORK_CONFIRMATION_NUMBER');
1044:
1045: IF (g_asn_debug = 'Y') THEN
1046: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
1047: 'l_work_confirmation_number ' || l_work_confirmation_number);
1048: END IF;
1049:
1050: l_transaction_type := wf_engine.GetItemAttrText (itemtype => p_itemtype,
1051: itemkey => p_itemkey,
1052: aname => 'AME_TRANSACTION_TYPE');
1053:
1054: IF (g_asn_debug = 'Y') THEN
1068: * is used to set the #FROM_ROLE in the notifications
1069: * message.
1070: */
1071: l_forward_from_user_name :=
1072: wf_engine.GetItemAttrText (itemtype => p_itemtype,
1073: itemkey => p_itemkey,
1074: aname => 'APPROVER_USER_NAME');
1075:
1076: IF (g_asn_debug = 'Y') THEN
1079: || nvl(l_forward_from_user_name,'NONAME'));
1080: End if;
1081: If (l_forward_from_user_name is null) then
1082: l_wc_preparer_name :=
1083: wf_engine.GetItemAttrText (itemtype => p_itemtype,
1084: itemkey => p_itemkey,
1085: aname => 'WC_PREPARER_NAME');
1086:
1087: IF (g_asn_debug = 'Y') THEN
1089: l_api_name,'l_wc_preparer_name '
1090: || nvl(l_wc_preparer_name ,'NONAME'));
1091: End if;
1092:
1093: wf_engine.SetItemAttrText( itemtype => p_itemType,
1094: itemkey => p_itemkey,
1095: aname => 'FORWARD_FROM_USER_NAME' ,
1096: avalue => l_wc_preparer_name);
1097:
1095: aname => 'FORWARD_FROM_USER_NAME' ,
1096: avalue => l_wc_preparer_name);
1097:
1098: else
1099: wf_engine.SetItemAttrText( itemtype => p_itemType,
1100: itemkey => p_itemkey,
1101: aname => 'FORWARD_FROM_USER_NAME' ,
1102: avalue => l_forward_from_user_name);
1103:
1111: 'WcHeaderId='||to_char(l_shipment_header_id)||'&' ||
1112: 'WcNum=' || (l_work_confirmation_number) || '&' ||
1113: 'addBreadCrumb=Y';
1114:
1115: wf_engine.SetItemAttrText ( itemtype => p_itemType,
1116: itemkey => p_itemkey,
1117: aname => 'RESPOND_TO_WC_URL' ,
1118: avalue => l_respond_to_wc_url);
1119:
1138: debug_log(FND_LOG.LEVEL_STATEMENT,
1139: l_api_name,'no rule is setup ');
1140: End if;
1141: l_default_approver :=
1142: wf_engine.GetItemAttrText (itemtype => p_itemtype,
1143: itemkey => p_itemkey,
1144: aname => 'DEFAULT_APPROVER');
1145:
1146: IF (g_asn_debug = 'Y') THEN
1163: debug_log(FND_LOG.LEVEL_STATEMENT,
1164: l_api_name,'Send buyer as default approver ');
1165: End if;
1166:
1167: wf_engine.SetItemAttrText ( itemtype => p_itemType,
1168: itemkey => p_itemkey,
1169: aname => 'DEFAULT_APPROVER' ,
1170: avalue => 'BUYER');
1171:
1168: itemkey => p_itemkey,
1169: aname => 'DEFAULT_APPROVER' ,
1170: avalue => 'BUYER');
1171:
1172: l_po_preparer_id := wf_engine.GetItemAttrNumber
1173: (itemtype => p_itemtype,
1174: itemkey => p_itemkey,
1175: aname => 'PO_PREPARER_ID');
1176:
1272: l_api_name,'l_authority_type '
1273: || l_authority_type);
1274: END IF;
1275:
1276: wf_engine.SetItemAttrText( itemtype => p_itemType,
1277: itemkey => p_itemkey,
1278: aname => 'AME_APPROVER_TYPE' ,
1279: avalue => l_next_approver(1).orig_system);
1280: wf_engine.SetItemAttrNumber ( itemtype => p_itemType,
1276: wf_engine.SetItemAttrText( itemtype => p_itemType,
1277: itemkey => p_itemkey,
1278: aname => 'AME_APPROVER_TYPE' ,
1279: avalue => l_next_approver(1).orig_system);
1280: wf_engine.SetItemAttrNumber ( itemtype => p_itemType,
1281: itemkey => p_itemkey,
1282: aname => 'APPROVER_EMPID',
1283: avalue => l_next_approver_id);
1284:
1282: aname => 'APPROVER_EMPID',
1283: avalue => l_next_approver_id);
1284:
1285:
1286: wf_engine.SetItemAttrNumber ( itemtype => p_itemType,
1287: itemkey => p_itemkey,
1288: aname => 'FORWARD_TO_ID',
1289: avalue => l_next_approver_id);
1290:
1287: itemkey => p_itemkey,
1288: aname => 'FORWARD_TO_ID',
1289: avalue => l_next_approver_id);
1290:
1291: wf_engine.SetItemAttrText( itemtype => p_itemType,
1292: itemkey => p_itemkey,
1293: aname => 'AME_INSERTION_TYPE' ,
1294: avalue => l_insertion_type);
1295:
1292: itemkey => p_itemkey,
1293: aname => 'AME_INSERTION_TYPE' ,
1294: avalue => l_insertion_type);
1295:
1296: wf_engine.SetItemAttrText( itemtype => p_itemType,
1297: itemkey => p_itemkey,
1298: aname => 'AME_AUTHORITY_TYPE' ,
1299: avalue => l_authority_type);
1300:
1313: debug_log(FND_LOG.LEVEL_STATEMENT,
1314: l_api_name,'l_next_approver_disp_name '
1315: || l_next_approver_disp_name);
1316: end if;
1317: wf_engine.SetItemAttrText( itemtype => p_itemType,
1318: itemkey => p_itemkey,
1319: aname => 'APPROVER_USER_NAME' ,
1320: avalue => l_next_approver_user_name);
1321:
1318: itemkey => p_itemkey,
1319: aname => 'APPROVER_USER_NAME' ,
1320: avalue => l_next_approver_user_name);
1321:
1322: wf_engine.SetItemAttrText( itemtype => p_itemType,
1323: itemkey => p_itemkey,
1324: aname => 'APPROVER_DISPLAY_NAME' ,
1325: avalue => l_next_approver_disp_name);
1326:
1323: itemkey => p_itemkey,
1324: aname => 'APPROVER_DISPLAY_NAME' ,
1325: avalue => l_next_approver_disp_name);
1326:
1327: wf_engine.SetItemAttrText( itemtype => p_itemType,
1328: itemkey => p_itemkey,
1329: aname => 'FORWARD_TO_USERNAME' ,
1330: avalue => l_next_approver_user_name);
1331:
1328: itemkey => p_itemkey,
1329: aname => 'FORWARD_TO_USERNAME' ,
1330: avalue => l_next_approver_user_name);
1331:
1332: wf_engine.SetItemAttrText( itemtype => p_itemType,
1333: itemkey => p_itemkey,
1334: aname => 'FORWARD_TO_DISPLAY_NAME' ,
1335: avalue => l_next_approver_disp_name);
1336:
1404:
1405: BEGIN
1406:
1407:
1408: if (p_funcmode <> wf_engine.eng_run) then
1409: x_resultout := wf_engine.eng_null;
1410: return;
1411: end if;
1412:
1405: BEGIN
1406:
1407:
1408: if (p_funcmode <> wf_engine.eng_run) then
1409: x_resultout := wf_engine.eng_null;
1410: return;
1411: end if;
1412:
1413:
1421: END IF;
1422:
1423:
1424:
1425: l_approver_id := wf_engine.GetItemAttrNumber(itemtype=>p_itemtype,
1426: itemkey=>p_itemkey,
1427: aname=>'APPROVER_EMPID');
1428: IF (g_asn_debug = 'Y') THEN
1429: debug_log(FND_LOG.LEVEL_STATEMENT,
1430: l_api_name,'l_approver_id '
1431: || l_approver_id);
1432: END IF;
1433:
1434: l_shipment_header_id:= wf_engine.GetItemAttrNumber(itemtype=>p_itemtype,
1435: itemkey=>p_itemkey,
1436: aname=>'WORK_CONFIRMATION_ID');
1437: IF (g_asn_debug = 'Y') THEN
1438: debug_log(FND_LOG.LEVEL_STATEMENT,
1628: l_api_name,'Enter in Approve_shipment_lines '
1629: || l_progress);
1630: END IF;
1631:
1632: if (p_funcmode <> wf_engine.eng_run) then
1633: x_resultout := wf_engine.eng_null;
1634: return;
1635: end if;
1636:
1629: || l_progress);
1630: END IF;
1631:
1632: if (p_funcmode <> wf_engine.eng_run) then
1633: x_resultout := wf_engine.eng_null;
1634: return;
1635: end if;
1636:
1637: l_shipment_header_id := wf_engine.GetItemAttrNumber
1633: x_resultout := wf_engine.eng_null;
1634: return;
1635: end if;
1636:
1637: l_shipment_header_id := wf_engine.GetItemAttrNumber
1638: (itemtype => p_itemtype,
1639: itemkey => p_itemkey,
1640: aname => 'WORK_CONFIRMATION_ID');
1641:
1724: l_api_name,'Enter in Reject_shipment_lines '
1725: || l_progress);
1726: END IF;
1727:
1728: if (p_funcmode <> wf_engine.eng_run) then
1729: x_resultout := wf_engine.eng_null;
1730: return;
1731: end if;
1732:
1725: || l_progress);
1726: END IF;
1727:
1728: if (p_funcmode <> wf_engine.eng_run) then
1729: x_resultout := wf_engine.eng_null;
1730: return;
1731: end if;
1732:
1733: l_shipment_header_id := wf_engine.GetItemAttrNumber
1729: x_resultout := wf_engine.eng_null;
1730: return;
1731: end if;
1732:
1733: l_shipment_header_id := wf_engine.GetItemAttrNumber
1734: (itemtype => p_itemtype,
1735: itemkey => p_itemkey,
1736: aname => 'WORK_CONFIRMATION_ID');
1737:
1808: l_api_name,'Enter in Approve_OR_Reject '
1809: || l_progress);
1810: END IF;
1811:
1812: if (p_funcmode <> wf_engine.eng_run) then
1813: x_resultout := wf_engine.eng_null;
1814: return;
1815: end if;
1816:
1809: || l_progress);
1810: END IF;
1811:
1812: if (p_funcmode <> wf_engine.eng_run) then
1813: x_resultout := wf_engine.eng_null;
1814: return;
1815: end if;
1816:
1817: l_shipment_header_id := wf_engine.GetItemAttrNumber
1813: x_resultout := wf_engine.eng_null;
1814: return;
1815: end if;
1816:
1817: l_shipment_header_id := wf_engine.GetItemAttrNumber
1818: (itemtype => p_itemtype,
1819: itemkey => p_itemkey,
1820: aname => 'WORK_CONFIRMATION_ID');
1821:
1835: l_api_name,'l_reject_lines ' || l_reject_lines);
1836: END IF;
1837:
1838: If (l_reject_lines > 0) then
1839: x_resultout := wf_engine.eng_completed || ':' ||
1840: 'REJECT';
1841: else
1842: x_resultout := wf_engine.eng_completed || ':' ||
1843: 'APPROVE';
1838: If (l_reject_lines > 0) then
1839: x_resultout := wf_engine.eng_completed || ':' ||
1840: 'REJECT';
1841: else
1842: x_resultout := wf_engine.eng_completed || ':' ||
1843: 'APPROVE';
1844:
1845: end if;
1846:
1936: 'Enter in Update_Approval_List_Response '
1937: || l_progress);
1938: END IF;
1939:
1940: if (p_funcmode <> wf_engine.eng_run) then
1941: x_resultout := wf_engine.eng_null;
1942: return;
1943: end if;
1944:
1937: || l_progress);
1938: END IF;
1939:
1940: if (p_funcmode <> wf_engine.eng_run) then
1941: x_resultout := wf_engine.eng_null;
1942: return;
1943: end if;
1944:
1945:
1942: return;
1943: end if;
1944:
1945:
1946: wf_engine.SetItemAttrNumber ( itemtype => p_itemType,
1947: itemkey => p_itemkey,
1948: aname => 'RESPONDER_USER_ID',
1949: avalue => fnd_global.USER_ID);
1950:
1947: itemkey => p_itemkey,
1948: aname => 'RESPONDER_USER_ID',
1949: avalue => fnd_global.USER_ID);
1950:
1951: wf_engine.SetItemAttrNumber ( itemtype => p_itemType,
1952: itemkey => p_itemkey,
1953: aname => 'RESPONDER_RESP_ID',
1954: avalue => fnd_global.RESP_ID);
1955:
1952: itemkey => p_itemkey,
1953: aname => 'RESPONDER_RESP_ID',
1954: avalue => fnd_global.RESP_ID);
1955:
1956: wf_engine.SetItemAttrNumber ( itemtype => p_itemType,
1957: itemkey => p_itemkey,
1958: aname => 'RESPONDER_APPL_ID',
1959: avalue => fnd_global.RESP_APPL_ID);
1960:
2037: END IF;
2038:
2039: l_progress := 'POS_WCAPPROVE_PVT.Update_Approval_List_Response'
2040: || ':02.';
2041: wf_engine.SetItemAttrNumber(itemtype => p_itemType,
2042: itemkey => p_itemkey,
2043: aname => 'RESPONDER_ID',
2044: avalue => l_responder_id);
2045:
2062: end if;
2063:
2064: l_progress := 'POS_WCAPPROVE_PVT.Update_Approval_List_Response'
2065: || ': 03.';
2066: wf_engine.SetItemAttrText( itemtype => p_itemType,
2067: itemkey => p_itemkey,
2068: aname => 'RESPONDER_USER_NAME' ,
2069: avalue => l_responder_user_name);
2070:
2067: itemkey => p_itemkey,
2068: aname => 'RESPONDER_USER_NAME' ,
2069: avalue => l_responder_user_name);
2070:
2071: wf_engine.SetItemAttrText( itemtype => p_itemType,
2072: itemkey => p_itemkey,
2073: aname => 'RESPONDER_DISPLAY_NAME' ,
2074: avalue => l_responder_disp_name);
2075:
2078:
2079: /* We cannot have response as forward. Need to remove it later
2080: IF (INSTR(l_response, 'FORWARD') > 0) THEN
2081: l_forward_to_id :=
2082: wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
2083: itemkey => p_itemkey,
2084: aname => 'FORWARD_TO_ID');
2085: END IF;
2086: IF (g_asn_debug = 'Y') THEN
2096:
2097: END IF; -- }c_group_id
2098:
2099:
2100: l_shipment_header_id := wf_engine.GetItemAttrNumber
2101: (itemtype => p_itemtype,
2102: itemkey => p_itemkey,
2103: aname => 'WORK_CONFIRMATION_ID');
2104:
2108: ' l_shipment_header_id '
2109: || l_shipment_header_id);
2110: END IF;
2111:
2112: l_approver_id := wf_engine.GetItemAttrNumber(itemtype=>p_itemtype,
2113: itemkey=>p_itemkey,
2114: aname=>'APPROVER_EMPID');
2115:
2116: IF (g_asn_debug = 'Y') THEN
2119: ' l_approver_id '
2120: || l_approver_id);
2121: END IF;
2122:
2123: l_insertion_type := wf_engine.GetItemAttrText(itemtype => p_itemtype,
2124: itemkey => p_itemkey,
2125: aname => 'AME_INSERTION_TYPE');
2126:
2127: IF (g_asn_debug = 'Y') THEN
2130: ' l_insertion_type '
2131: || l_insertion_type);
2132: END IF;
2133:
2134: l_authority_type := wf_engine.GetItemAttrText(itemtype => p_itemtype,
2135: itemkey => p_itemkey,
2136: aname => 'AME_AUTHORITY_TYPE');
2137:
2138: IF (g_asn_debug = 'Y') THEN
2141: ' l_authority_type '
2142: || l_authority_type);
2143: END IF;
2144:
2145: l_transaction_type := wf_engine.GetItemAttrText (itemtype => p_itemtype,
2146: itemkey => p_itemkey,
2147: aname => 'AME_TRANSACTION_TYPE');
2148:
2149: IF (g_asn_debug = 'Y') THEN
2164: || l_approver_type);
2165: END IF;
2166:
2167: l_default_approver :=
2168: wf_engine.GetItemAttrText (itemtype => p_itemtype,
2169: itemkey => p_itemkey,
2170: aname => 'DEFAULT_APPROVER');
2171:
2172: IF (g_asn_debug = 'Y') THEN
2285: 'Enter in Update_Action_History_Approve '
2286: || l_progress);
2287: END IF;
2288:
2289: if (p_funcmode <> wf_engine.eng_run) then
2290: x_resultout := wf_engine.eng_null;
2291: return;
2292: end if;
2293:
2286: || l_progress);
2287: END IF;
2288:
2289: if (p_funcmode <> wf_engine.eng_run) then
2290: x_resultout := wf_engine.eng_null;
2291: return;
2292: end if;
2293:
2294: Update_Action_History(p_itemtype => p_itemtype,
2333: 'Enter in Update_Action_History_Reject '
2334: || l_progress);
2335: END IF;
2336:
2337: if (p_funcmode <> wf_engine.eng_run) then
2338: x_resultout := wf_engine.eng_null;
2339: return;
2340: end if;
2341:
2334: || l_progress);
2335: END IF;
2336:
2337: if (p_funcmode <> wf_engine.eng_run) then
2338: x_resultout := wf_engine.eng_null;
2339: return;
2340: end if;
2341:
2342: Update_Action_History(p_itemtype => p_itemtype,
2415: || l_progress);
2416: END IF;
2417:
2418:
2419: l_shipment_header_id := wf_engine.GetItemAttrNumber
2420: (itemtype => p_itemtype,
2421: itemkey => p_itemkey,
2422: aname => 'WORK_CONFIRMATION_ID');
2423:
3154: elsif (p_funcmode = 'ANSWER') then
3155: l_action := 'ANSWER';
3156: end if;
3157:
3158: l_shipment_header_id := wf_engine.GetItemAttrNumber
3159: (itemtype => p_itemtype,
3160: itemkey => p_itemkey,
3161: aname => 'WORK_CONFIRMATION_ID');
3162: IF (g_asn_debug = 'Y') THEN
3164: l_api_name,'l_shipment_header_id ' ||
3165: l_shipment_header_id);
3166: END IF;
3167:
3168: Wf_Directory.GetRoleOrigSysInfo(WF_ENGINE.CONTEXT_NEW_ROLE,
3169: l_origsys, l_new_recipient_id);
3170:
3171:
3172:
3202: p_object_id => Recinfo.object_id,
3203: p_object_type_code => Recinfo.object_type_code,
3204: p_employee_id => Recinfo.employee_id,
3205: p_action_code => l_action,
3206: p_note => wf_engine.context_user_comment,
3207: p_user_id => fnd_global.user_id,
3208: p_login_id => fnd_global.login_id);
3209:
3210:
3227: p_login_id => fnd_global.login_id);
3228:
3229: -- end loop; --}
3230:
3231: x_resultout := wf_engine.eng_completed || ':' || wf_engine.eng_null;
3232:
3233: return;
3234: end if; --}
3235:
3234: end if; --}
3235:
3236:
3237: if (p_funcmode = 'RESPOND') then --{
3238: l_notification_id := WF_ENGINE.context_nid;
3239: IF (g_asn_debug = 'Y') THEN
3240: debug_log(FND_LOG.LEVEL_STATEMENT,
3241: l_api_name,
3242: 'l_notification_id '||l_notification_id );
3261: 'FORWARD_TO_USERNAME_RESPONSE');
3262:
3263:
3264: l_forward_to_username_response :=
3265: wf_engine.GetItemAttrText
3266: (itemtype => p_itemtype,
3267: itemkey => p_itemkey,
3268: aname => 'FORWARD_TO_USERNAME_RESPONSE');
3269:
3273: end if;
3274: end if;--}
3275:
3276:
3277: x_resultout := wf_engine.eng_completed || ':' || wf_engine.eng_null;
3278: return;
3279: end if; --}
3280:
3281:
3323: 'Enter in reject_doc '
3324: || l_progress);
3325: END IF;
3326:
3327: if (p_funcmode <> wf_engine.eng_run) then
3328: x_resultout := wf_engine.eng_null;
3329: return;
3330: end if;
3331:
3324: || l_progress);
3325: END IF;
3326:
3327: if (p_funcmode <> wf_engine.eng_run) then
3328: x_resultout := wf_engine.eng_null;
3329: return;
3330: end if;
3331:
3332: l_progress := 'POS_WCAPPROVE_PVT.reject_doc: 02.';
3329: return;
3330: end if;
3331:
3332: l_progress := 'POS_WCAPPROVE_PVT.reject_doc: 02.';
3333: l_shipment_header_id := wf_engine.GetItemAttrNumber
3334: (itemtype => p_itemtype,
3335: itemkey => p_itemkey,
3336: aname => 'WORK_CONFIRMATION_ID');
3337:
3352: l_api_name,
3353: 'Could not Reject the document '
3354: || l_progress);
3355: END IF;
3356: x_resultout := wf_engine.eng_completed || ':' || 'N';
3357: END IF;
3358:
3359: IF (l_result = 'Y') THEN
3360:
3363: l_api_name,
3364: 'Rejected the document '
3365: || l_progress);
3366: END IF;
3367: wf_engine.SetItemAttrText ( itemtype => p_itemtype,
3368: itemkey => p_itemkey,
3369: aname => 'DOC_STATUS',
3370: avalue => 'REJECTED');
3371:
3369: aname => 'DOC_STATUS',
3370: avalue => 'REJECTED');
3371:
3372:
3373: l_po_header_id := wf_engine.GetItemAttrNumber
3374: (itemtype => p_itemtype,
3375: itemkey => p_itemkey,
3376: aname => 'PO_DOCUMENT_ID');
3377:
3380: 'l_po_header_id ' || l_po_header_id);
3381: END IF;
3382:
3383: l_work_confirmation_number :=
3384: wf_engine.GetItemAttrText (itemtype => p_itemtype,
3385: itemkey => p_itemkey,
3386: aname => 'WORK_CONFIRMATION_NUMBER');
3387:
3388: IF (g_asn_debug = 'Y') THEN
3398: 'WcNum=' || (l_work_confirmation_number) || '&' ||
3399: -- 'ReadOnly=Y' || '&' ||
3400: 'addBreadCrumb=Y';
3401:
3402: wf_engine.SetItemAttrText ( itemtype => p_itemType,
3403: itemkey => p_itemkey,
3404: aname => 'VIEW_WC_LINES_DETAIL_URL' ,
3405: avalue => l_view_wc_lines_detail_url);
3406: x_resultout := wf_engine.eng_completed || ':' || 'Y';
3402: wf_engine.SetItemAttrText ( itemtype => p_itemType,
3403: itemkey => p_itemkey,
3404: aname => 'VIEW_WC_LINES_DETAIL_URL' ,
3405: avalue => l_view_wc_lines_detail_url);
3406: x_resultout := wf_engine.eng_completed || ':' || 'Y';
3407: END IF;
3408: EXCEPTION
3409: when others then
3410: IF (g_asn_debug = 'Y') THEN
3440: 'Enter in Approve_doc '
3441: || l_progress);
3442: END IF;
3443:
3444: if (p_funcmode <> wf_engine.eng_run) then
3445: x_resultout := wf_engine.eng_null;
3446: return;
3447: end if;
3448:
3441: || l_progress);
3442: END IF;
3443:
3444: if (p_funcmode <> wf_engine.eng_run) then
3445: x_resultout := wf_engine.eng_null;
3446: return;
3447: end if;
3448:
3449: l_progress := 'POS_WCAPPROVE_PVT.Approve_doc: 02.';
3446: return;
3447: end if;
3448:
3449: l_progress := 'POS_WCAPPROVE_PVT.Approve_doc: 02.';
3450: l_shipment_header_id := wf_engine.GetItemAttrNumber
3451: (itemtype => p_itemtype,
3452: itemkey => p_itemkey,
3453: aname => 'WORK_CONFIRMATION_ID');
3454:
3467: l_api_name,
3468: 'Could not Reject the document '
3469: || l_progress);
3470: END IF;
3471: x_resultout := wf_engine.eng_completed || ':' || 'N';
3472: END IF;
3473:
3474: IF (l_result = 'Y') THEN
3475:
3478: l_api_name,
3479: 'Approved the document '
3480: || l_progress);
3481: END IF;
3482: wf_engine.SetItemAttrText ( itemtype => p_itemtype,
3483: itemkey => p_itemkey,
3484: aname => 'DOC_STATUS',
3485: avalue => 'APPROVED');
3486:
3483: itemkey => p_itemkey,
3484: aname => 'DOC_STATUS',
3485: avalue => 'APPROVED');
3486:
3487: l_po_header_id := wf_engine.GetItemAttrNumber
3488: (itemtype => p_itemtype,
3489: itemkey => p_itemkey,
3490: aname => 'PO_DOCUMENT_ID');
3491:
3494: 'l_po_header_id ' || l_po_header_id);
3495: END IF;
3496:
3497: l_work_confirmation_number :=
3498: wf_engine.GetItemAttrText (itemtype => p_itemtype,
3499: itemkey => p_itemkey,
3500: aname => 'WORK_CONFIRMATION_NUMBER');
3501:
3502: IF (g_asn_debug = 'Y') THEN
3512: 'WcNum=' || (l_work_confirmation_number) || '&' ||
3513: --'ReadOnly=Y' || '&' ||
3514: 'addBreadCrumb=Y';
3515:
3516: wf_engine.SetItemAttrText ( itemtype => p_itemType,
3517: itemkey => p_itemkey,
3518: aname => 'VIEW_WC_LINES_DETAIL_URL' ,
3519: avalue => l_view_wc_lines_detail_url);
3520:
3517: itemkey => p_itemkey,
3518: aname => 'VIEW_WC_LINES_DETAIL_URL' ,
3519: avalue => l_view_wc_lines_detail_url);
3520:
3521: x_resultout := wf_engine.eng_completed || ':' || 'Y';
3522: END IF;
3523: EXCEPTION
3524: when others then
3525: IF (g_asn_debug = 'Y') THEN
3817: 'Enter in insert_into_rti '
3818: || l_progress);
3819: END IF;
3820:
3821: if (p_funcmode <> wf_engine.eng_run) then
3822: x_resultout := wf_engine.eng_null;
3823: return;
3824: end if;
3825:
3818: || l_progress);
3819: END IF;
3820:
3821: if (p_funcmode <> wf_engine.eng_run) then
3822: x_resultout := wf_engine.eng_null;
3823: return;
3824: end if;
3825:
3826: l_shipment_header_id := wf_engine.GetItemAttrNumber
3822: x_resultout := wf_engine.eng_null;
3823: return;
3824: end if;
3825:
3826: l_shipment_header_id := wf_engine.GetItemAttrNumber
3827: (itemtype => p_itemtype,
3828: itemkey => p_itemkey,
3829: aname => 'WORK_CONFIRMATION_ID');
3830:
3843: l_header_interface_id ||
3844: ' l_group_id ' || l_group_id);
3845: END IF;
3846:
3847: wf_engine.SetItemAttrNumber ( itemtype => p_itemtype,
3848: itemkey => p_itemkey,
3849: aname => 'INTERFACE_GROUP_ID',
3850: avalue => l_group_id);
3851:
4503: debug_log(FND_LOG.LEVEL_STATEMENT,
4504: l_api_name,'Leave insert_into_rti ' );
4505: END IF;
4506:
4507: x_resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
4508:
4509: return;
4510:
4511: exception
4538: 'Enter in Launch_RTP_Immediate '
4539: || l_progress);
4540: END IF;
4541:
4542: if (p_funcmode <> wf_engine.eng_run) then
4543: x_resultout := wf_engine.eng_null;
4544: return;
4545: end if;
4546:
4539: || l_progress);
4540: END IF;
4541:
4542: if (p_funcmode <> wf_engine.eng_run) then
4543: x_resultout := wf_engine.eng_null;
4544: return;
4545: end if;
4546:
4547: l_group_id := wf_engine.GetItemAttrNumber
4543: x_resultout := wf_engine.eng_null;
4544: return;
4545: end if;
4546:
4547: l_group_id := wf_engine.GetItemAttrNumber
4548: (itemtype => p_itemtype,
4549: itemkey => p_itemkey,
4550: aname => 'INTERFACE_GROUP_ID');
4551:
4606: IF (g_asn_debug = 'Y') THEN
4607: debug_log(FND_LOG.LEVEL_STATEMENT,
4608: l_api_name, 'Leave RTP launch ' );
4609: END IF;
4610: x_resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
4611: return;
4612:
4613: exception
4614: when others then