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.POS_WCAPPROVE_PVT dependencies on WF_ENGINE

Line 152: wf_engine.CreateProcess(

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

Line 169: wf_engine.SetItemAttrNumber ( itemtype => p_itemtype,

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:

Line 193: wf_engine.SetItemAttrText ( itemtype => p_itemtype,

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:

Line 209: wf_engine.SetItemAttrNumber ( itemtype => p_itemtype,

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:

Line 222: wf_engine.SetItemAttrNumber ( itemtype => p_itemtype,

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:

Line 235: wf_engine.SetItemAttrNumber ( itemtype => p_itemtype,

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: --

Line 240: wf_engine.SetItemAttrNumber ( itemtype => p_itemtype,

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: --

Line 245: wf_engine.SetItemAttrNumber ( itemtype => p_itemtype,

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:

Line 262: wf_engine.StartProcess(itemtype => p_itemtype,

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:

Line 322: if (p_funcmode <> wf_engine.eng_run) then

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:

Line 323: x_resultout := wf_engine.eng_null;

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:

Line 329: wf_engine.GetItemAttrNumber (itemtype => p_itemtype,

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

Line 360: x_resultout := wf_engine.eng_completed ;

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

Line 406: if (p_funcmode <> wf_engine.eng_run) 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:

Line 407: x_resultout := wf_engine.eng_null;

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 :=

Line 412: wf_engine.GetItemAttrNumber (itemtype => p_itemtype,

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:

Line 441: wf_engine.SetItemAttrNumber ( itemtype => p_itemtype,

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:

Line 463: wf_engine.SetItemAttrText ( itemtype => p_itemType,

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:

Line 468: wf_engine.SetItemAttrText ( itemtype => p_itemType,

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:

Line 475: wf_engine.GetItemAttrNumber (itemtype => p_itemtype,

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

Line 489: wf_engine.SetItemAttrText ( itemtype => p_itemtype,

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:

Line 509: wf_engine.SetItemAttrNumber ( itemtype => p_itemtype,

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:

Line 525: wf_engine.SetItemAttrText ( itemtype => p_itemType,

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:

Line 530: wf_engine.SetItemAttrText ( itemtype => p_itemType,

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:

Line 535: wf_engine.SetItemAttrText ( itemtype => p_itemType,

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:

Line 540: wf_engine.SetItemAttrText ( itemtype => p_itemType,

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:

Line 557: wf_engine.GetItemAttrText (itemtype => p_itemtype,

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:

Line 572: wf_engine.SetItemAttrText ( itemtype => p_itemType,

568: 'WcNum=' || (wfa_html.encode_url(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:

Line 587: wf_engine.SetItemAttrText ( itemtype => p_itemType,

583: 'WcHeaderId=' || to_char(l_work_confirmation_id) || '&' ||
584: 'WcNum=' || (wfa_html.encode_url(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:

Line 592: x_resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

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,

Line 627: if (p_funcmode <> wf_engine.eng_run) then

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:

Line 628: x_resultout := wf_engine.eng_null;

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:

Line 633: l_shipment_header_id := wf_engine.GetItemAttrNumber

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:

Line 646: x_resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

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,

Line 693: if (p_funcmode <> wf_engine.eng_run) then

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:

Line 694: x_resultout := wf_engine.eng_null;

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:

Line 699: l_shipment_header_id := wf_engine.GetItemAttrNumber

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:

Line 749: x_resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

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,

Line 808: if (p_funcmode <> wf_engine.eng_run) then

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:

Line 809: x_resultout := wf_engine.eng_null;

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

Line 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:

Line 824: l_wc_preparer_id := wf_engine.GetItemAttrNumber

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:

Line 955: x_resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

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,

Line 1009: if (p_funcmode <> wf_engine.eng_run) then

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);

Line 1016: x_resultout := wf_engine.eng_null;

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

Line 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:

Line 1030: l_po_header_id := wf_engine.GetItemAttrNumber

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:

Line 1041: wf_engine.GetItemAttrText (itemtype => p_itemtype,

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

Line 1050: l_transaction_type := wf_engine.GetItemAttrText (itemtype => p_itemtype,

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

Line 1072: wf_engine.GetItemAttrText (itemtype => p_itemtype,

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

Line 1083: wf_engine.GetItemAttrText (itemtype => p_itemtype,

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

Line 1093: wf_engine.SetItemAttrText( itemtype => p_itemType,

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:

Line 1099: wf_engine.SetItemAttrText( itemtype => p_itemType,

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:

Line 1116: wf_engine.SetItemAttrText ( itemtype => p_itemType,

1112: 'WcHeaderId='||to_char(l_shipment_header_id)||'&' ||
1113: 'WcNum=' || (wfa_html.encode_url(l_work_confirmation_number)) || '&' ||
1114: 'addBreadCrumb=Y';
1115:
1116: wf_engine.SetItemAttrText ( itemtype => p_itemType,
1117: itemkey => p_itemkey,
1118: aname => 'RESPOND_TO_WC_URL' ,
1119: avalue => l_respond_to_wc_url);
1120:

Line 1143: wf_engine.GetItemAttrText (itemtype => p_itemtype,

1139: debug_log(FND_LOG.LEVEL_STATEMENT,
1140: l_api_name,'no rule is setup ');
1141: End if;
1142: l_default_approver :=
1143: wf_engine.GetItemAttrText (itemtype => p_itemtype,
1144: itemkey => p_itemkey,
1145: aname => 'DEFAULT_APPROVER');
1146:
1147: IF (g_asn_debug = 'Y') THEN

Line 1168: wf_engine.SetItemAttrText ( itemtype => p_itemType,

1164: debug_log(FND_LOG.LEVEL_STATEMENT,
1165: l_api_name,'Send buyer as default approver ');
1166: End if;
1167:
1168: wf_engine.SetItemAttrText ( itemtype => p_itemType,
1169: itemkey => p_itemkey,
1170: aname => 'DEFAULT_APPROVER' ,
1171: avalue => 'BUYER');
1172:

Line 1173: l_po_preparer_id := wf_engine.GetItemAttrNumber

1169: itemkey => p_itemkey,
1170: aname => 'DEFAULT_APPROVER' ,
1171: avalue => 'BUYER');
1172:
1173: l_po_preparer_id := wf_engine.GetItemAttrNumber
1174: (itemtype => p_itemtype,
1175: itemkey => p_itemkey,
1176: aname => 'PO_PREPARER_ID');
1177:

Line 1277: wf_engine.SetItemAttrText( itemtype => p_itemType,

1273: l_api_name,'l_authority_type '
1274: || l_authority_type);
1275: END IF;
1276:
1277: wf_engine.SetItemAttrText( itemtype => p_itemType,
1278: itemkey => p_itemkey,
1279: aname => 'AME_APPROVER_TYPE' ,
1280: avalue => l_next_approver(1).orig_system);
1281: wf_engine.SetItemAttrNumber ( itemtype => p_itemType,

Line 1281: wf_engine.SetItemAttrNumber ( itemtype => p_itemType,

1277: wf_engine.SetItemAttrText( itemtype => p_itemType,
1278: itemkey => p_itemkey,
1279: aname => 'AME_APPROVER_TYPE' ,
1280: avalue => l_next_approver(1).orig_system);
1281: wf_engine.SetItemAttrNumber ( itemtype => p_itemType,
1282: itemkey => p_itemkey,
1283: aname => 'APPROVER_EMPID',
1284: avalue => l_next_approver_id);
1285:

Line 1287: wf_engine.SetItemAttrNumber ( itemtype => p_itemType,

1283: aname => 'APPROVER_EMPID',
1284: avalue => l_next_approver_id);
1285:
1286:
1287: wf_engine.SetItemAttrNumber ( itemtype => p_itemType,
1288: itemkey => p_itemkey,
1289: aname => 'FORWARD_TO_ID',
1290: avalue => l_next_approver_id);
1291:

Line 1292: wf_engine.SetItemAttrText( itemtype => p_itemType,

1288: itemkey => p_itemkey,
1289: aname => 'FORWARD_TO_ID',
1290: avalue => l_next_approver_id);
1291:
1292: wf_engine.SetItemAttrText( itemtype => p_itemType,
1293: itemkey => p_itemkey,
1294: aname => 'AME_INSERTION_TYPE' ,
1295: avalue => l_insertion_type);
1296:

Line 1297: wf_engine.SetItemAttrText( itemtype => p_itemType,

1293: itemkey => p_itemkey,
1294: aname => 'AME_INSERTION_TYPE' ,
1295: avalue => l_insertion_type);
1296:
1297: wf_engine.SetItemAttrText( itemtype => p_itemType,
1298: itemkey => p_itemkey,
1299: aname => 'AME_AUTHORITY_TYPE' ,
1300: avalue => l_authority_type);
1301:

Line 1318: wf_engine.SetItemAttrText( itemtype => p_itemType,

1314: debug_log(FND_LOG.LEVEL_STATEMENT,
1315: l_api_name,'l_next_approver_disp_name '
1316: || l_next_approver_disp_name);
1317: end if;
1318: wf_engine.SetItemAttrText( itemtype => p_itemType,
1319: itemkey => p_itemkey,
1320: aname => 'APPROVER_USER_NAME' ,
1321: avalue => l_next_approver_user_name);
1322:

Line 1323: wf_engine.SetItemAttrText( itemtype => p_itemType,

1319: itemkey => p_itemkey,
1320: aname => 'APPROVER_USER_NAME' ,
1321: avalue => l_next_approver_user_name);
1322:
1323: wf_engine.SetItemAttrText( itemtype => p_itemType,
1324: itemkey => p_itemkey,
1325: aname => 'APPROVER_DISPLAY_NAME' ,
1326: avalue => l_next_approver_disp_name);
1327:

Line 1328: wf_engine.SetItemAttrText( itemtype => p_itemType,

1324: itemkey => p_itemkey,
1325: aname => 'APPROVER_DISPLAY_NAME' ,
1326: avalue => l_next_approver_disp_name);
1327:
1328: wf_engine.SetItemAttrText( itemtype => p_itemType,
1329: itemkey => p_itemkey,
1330: aname => 'FORWARD_TO_USERNAME' ,
1331: avalue => l_next_approver_user_name);
1332:

Line 1333: wf_engine.SetItemAttrText( itemtype => p_itemType,

1329: itemkey => p_itemkey,
1330: aname => 'FORWARD_TO_USERNAME' ,
1331: avalue => l_next_approver_user_name);
1332:
1333: wf_engine.SetItemAttrText( itemtype => p_itemType,
1334: itemkey => p_itemkey,
1335: aname => 'FORWARD_TO_DISPLAY_NAME' ,
1336: avalue => l_next_approver_disp_name);
1337:

Line 1409: if (p_funcmode <> wf_engine.eng_run) then

1405:
1406: BEGIN
1407:
1408:
1409: if (p_funcmode <> wf_engine.eng_run) then
1410: x_resultout := wf_engine.eng_null;
1411: return;
1412: end if;
1413:

Line 1410: x_resultout := wf_engine.eng_null;

1406: BEGIN
1407:
1408:
1409: if (p_funcmode <> wf_engine.eng_run) then
1410: x_resultout := wf_engine.eng_null;
1411: return;
1412: end if;
1413:
1414:

Line 1426: l_approver_id := wf_engine.GetItemAttrNumber(itemtype=>p_itemtype,

1422: END IF;
1423:
1424:
1425:
1426: l_approver_id := wf_engine.GetItemAttrNumber(itemtype=>p_itemtype,
1427: itemkey=>p_itemkey,
1428: aname=>'APPROVER_EMPID');
1429: IF (g_asn_debug = 'Y') THEN
1430: debug_log(FND_LOG.LEVEL_STATEMENT,

Line 1435: l_shipment_header_id:= wf_engine.GetItemAttrNumber(itemtype=>p_itemtype,

1431: l_api_name,'l_approver_id '
1432: || l_approver_id);
1433: END IF;
1434:
1435: l_shipment_header_id:= wf_engine.GetItemAttrNumber(itemtype=>p_itemtype,
1436: itemkey=>p_itemkey,
1437: aname=>'WORK_CONFIRMATION_ID');
1438: IF (g_asn_debug = 'Y') THEN
1439: debug_log(FND_LOG.LEVEL_STATEMENT,

Line 1633: if (p_funcmode <> wf_engine.eng_run) then

1629: l_api_name,'Enter in Approve_shipment_lines '
1630: || l_progress);
1631: END IF;
1632:
1633: if (p_funcmode <> wf_engine.eng_run) then
1634: x_resultout := wf_engine.eng_null;
1635: return;
1636: end if;
1637:

Line 1634: x_resultout := wf_engine.eng_null;

1630: || l_progress);
1631: END IF;
1632:
1633: if (p_funcmode <> wf_engine.eng_run) then
1634: x_resultout := wf_engine.eng_null;
1635: return;
1636: end if;
1637:
1638: l_shipment_header_id := wf_engine.GetItemAttrNumber

Line 1638: l_shipment_header_id := wf_engine.GetItemAttrNumber

1634: x_resultout := wf_engine.eng_null;
1635: return;
1636: end if;
1637:
1638: l_shipment_header_id := wf_engine.GetItemAttrNumber
1639: (itemtype => p_itemtype,
1640: itemkey => p_itemkey,
1641: aname => 'WORK_CONFIRMATION_ID');
1642:

Line 1729: if (p_funcmode <> wf_engine.eng_run) then

1725: l_api_name,'Enter in Reject_shipment_lines '
1726: || l_progress);
1727: END IF;
1728:
1729: if (p_funcmode <> wf_engine.eng_run) then
1730: x_resultout := wf_engine.eng_null;
1731: return;
1732: end if;
1733:

Line 1730: x_resultout := wf_engine.eng_null;

1726: || l_progress);
1727: END IF;
1728:
1729: if (p_funcmode <> wf_engine.eng_run) then
1730: x_resultout := wf_engine.eng_null;
1731: return;
1732: end if;
1733:
1734: l_shipment_header_id := wf_engine.GetItemAttrNumber

Line 1734: l_shipment_header_id := wf_engine.GetItemAttrNumber

1730: x_resultout := wf_engine.eng_null;
1731: return;
1732: end if;
1733:
1734: l_shipment_header_id := wf_engine.GetItemAttrNumber
1735: (itemtype => p_itemtype,
1736: itemkey => p_itemkey,
1737: aname => 'WORK_CONFIRMATION_ID');
1738:

Line 1813: if (p_funcmode <> wf_engine.eng_run) then

1809: l_api_name,'Enter in Approve_OR_Reject '
1810: || l_progress);
1811: END IF;
1812:
1813: if (p_funcmode <> wf_engine.eng_run) then
1814: x_resultout := wf_engine.eng_null;
1815: return;
1816: end if;
1817:

Line 1814: x_resultout := wf_engine.eng_null;

1810: || l_progress);
1811: END IF;
1812:
1813: if (p_funcmode <> wf_engine.eng_run) then
1814: x_resultout := wf_engine.eng_null;
1815: return;
1816: end if;
1817:
1818: l_shipment_header_id := wf_engine.GetItemAttrNumber

Line 1818: l_shipment_header_id := wf_engine.GetItemAttrNumber

1814: x_resultout := wf_engine.eng_null;
1815: return;
1816: end if;
1817:
1818: l_shipment_header_id := wf_engine.GetItemAttrNumber
1819: (itemtype => p_itemtype,
1820: itemkey => p_itemkey,
1821: aname => 'WORK_CONFIRMATION_ID');
1822:

Line 1840: x_resultout := wf_engine.eng_completed || ':' ||

1836: l_api_name,'l_reject_lines ' || l_reject_lines);
1837: END IF;
1838:
1839: If (l_reject_lines > 0) then
1840: x_resultout := wf_engine.eng_completed || ':' ||
1841: 'REJECT';
1842: else
1843: x_resultout := wf_engine.eng_completed || ':' ||
1844: 'APPROVE';

Line 1843: x_resultout := wf_engine.eng_completed || ':' ||

1839: If (l_reject_lines > 0) then
1840: x_resultout := wf_engine.eng_completed || ':' ||
1841: 'REJECT';
1842: else
1843: x_resultout := wf_engine.eng_completed || ':' ||
1844: 'APPROVE';
1845:
1846: end if;
1847:

Line 1941: if (p_funcmode <> wf_engine.eng_run) then

1937: 'Enter in Update_Approval_List_Response '
1938: || l_progress);
1939: END IF;
1940:
1941: if (p_funcmode <> wf_engine.eng_run) then
1942: x_resultout := wf_engine.eng_null;
1943: return;
1944: end if;
1945:

Line 1942: x_resultout := wf_engine.eng_null;

1938: || l_progress);
1939: END IF;
1940:
1941: if (p_funcmode <> wf_engine.eng_run) then
1942: x_resultout := wf_engine.eng_null;
1943: return;
1944: end if;
1945:
1946:

Line 1947: wf_engine.SetItemAttrNumber ( itemtype => p_itemType,

1943: return;
1944: end if;
1945:
1946:
1947: wf_engine.SetItemAttrNumber ( itemtype => p_itemType,
1948: itemkey => p_itemkey,
1949: aname => 'RESPONDER_USER_ID',
1950: avalue => fnd_global.USER_ID);
1951:

Line 1952: wf_engine.SetItemAttrNumber ( itemtype => p_itemType,

1948: itemkey => p_itemkey,
1949: aname => 'RESPONDER_USER_ID',
1950: avalue => fnd_global.USER_ID);
1951:
1952: wf_engine.SetItemAttrNumber ( itemtype => p_itemType,
1953: itemkey => p_itemkey,
1954: aname => 'RESPONDER_RESP_ID',
1955: avalue => fnd_global.RESP_ID);
1956:

Line 1957: wf_engine.SetItemAttrNumber ( itemtype => p_itemType,

1953: itemkey => p_itemkey,
1954: aname => 'RESPONDER_RESP_ID',
1955: avalue => fnd_global.RESP_ID);
1956:
1957: wf_engine.SetItemAttrNumber ( itemtype => p_itemType,
1958: itemkey => p_itemkey,
1959: aname => 'RESPONDER_APPL_ID',
1960: avalue => fnd_global.RESP_APPL_ID);
1961:

Line 2042: wf_engine.SetItemAttrNumber(itemtype => p_itemType,

2038: END IF;
2039:
2040: l_progress := 'POS_WCAPPROVE_PVT.Update_Approval_List_Response'
2041: || ':02.';
2042: wf_engine.SetItemAttrNumber(itemtype => p_itemType,
2043: itemkey => p_itemkey,
2044: aname => 'RESPONDER_ID',
2045: avalue => l_responder_id);
2046:

Line 2067: wf_engine.SetItemAttrText( itemtype => p_itemType,

2063: end if;
2064:
2065: l_progress := 'POS_WCAPPROVE_PVT.Update_Approval_List_Response'
2066: || ': 03.';
2067: wf_engine.SetItemAttrText( itemtype => p_itemType,
2068: itemkey => p_itemkey,
2069: aname => 'RESPONDER_USER_NAME' ,
2070: avalue => l_responder_user_name);
2071:

Line 2072: wf_engine.SetItemAttrText( itemtype => p_itemType,

2068: itemkey => p_itemkey,
2069: aname => 'RESPONDER_USER_NAME' ,
2070: avalue => l_responder_user_name);
2071:
2072: wf_engine.SetItemAttrText( itemtype => p_itemType,
2073: itemkey => p_itemkey,
2074: aname => 'RESPONDER_DISPLAY_NAME' ,
2075: avalue => l_responder_disp_name);
2076:

Line 2083: wf_engine.GetItemAttrNumber (itemtype => p_itemtype,

2079:
2080: /* We cannot have response as forward. Need to remove it later
2081: IF (INSTR(l_response, 'FORWARD') > 0) THEN
2082: l_forward_to_id :=
2083: wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
2084: itemkey => p_itemkey,
2085: aname => 'FORWARD_TO_ID');
2086: END IF;
2087: IF (g_asn_debug = 'Y') THEN

Line 2101: l_shipment_header_id := wf_engine.GetItemAttrNumber

2097:
2098: END IF; -- }c_group_id
2099:
2100:
2101: l_shipment_header_id := wf_engine.GetItemAttrNumber
2102: (itemtype => p_itemtype,
2103: itemkey => p_itemkey,
2104: aname => 'WORK_CONFIRMATION_ID');
2105:

Line 2113: l_approver_id := wf_engine.GetItemAttrNumber(itemtype=>p_itemtype,

2109: ' l_shipment_header_id '
2110: || l_shipment_header_id);
2111: END IF;
2112:
2113: l_approver_id := wf_engine.GetItemAttrNumber(itemtype=>p_itemtype,
2114: itemkey=>p_itemkey,
2115: aname=>'APPROVER_EMPID');
2116:
2117: IF (g_asn_debug = 'Y') THEN

Line 2124: l_insertion_type := wf_engine.GetItemAttrText(itemtype => p_itemtype,

2120: ' l_approver_id '
2121: || l_approver_id);
2122: END IF;
2123:
2124: l_insertion_type := wf_engine.GetItemAttrText(itemtype => p_itemtype,
2125: itemkey => p_itemkey,
2126: aname => 'AME_INSERTION_TYPE');
2127:
2128: IF (g_asn_debug = 'Y') THEN

Line 2135: l_authority_type := wf_engine.GetItemAttrText(itemtype => p_itemtype,

2131: ' l_insertion_type '
2132: || l_insertion_type);
2133: END IF;
2134:
2135: l_authority_type := wf_engine.GetItemAttrText(itemtype => p_itemtype,
2136: itemkey => p_itemkey,
2137: aname => 'AME_AUTHORITY_TYPE');
2138:
2139: IF (g_asn_debug = 'Y') THEN

Line 2146: l_transaction_type := wf_engine.GetItemAttrText (itemtype => p_itemtype,

2142: ' l_authority_type '
2143: || l_authority_type);
2144: END IF;
2145:
2146: l_transaction_type := wf_engine.GetItemAttrText (itemtype => p_itemtype,
2147: itemkey => p_itemkey,
2148: aname => 'AME_TRANSACTION_TYPE');
2149:
2150: IF (g_asn_debug = 'Y') THEN

Line 2169: wf_engine.GetItemAttrText (itemtype => p_itemtype,

2165: || l_approver_type);
2166: END IF;
2167:
2168: l_default_approver :=
2169: wf_engine.GetItemAttrText (itemtype => p_itemtype,
2170: itemkey => p_itemkey,
2171: aname => 'DEFAULT_APPROVER');
2172:
2173: IF (g_asn_debug = 'Y') THEN

Line 2290: if (p_funcmode <> wf_engine.eng_run) then

2286: 'Enter in Update_Action_History_Approve '
2287: || l_progress);
2288: END IF;
2289:
2290: if (p_funcmode <> wf_engine.eng_run) then
2291: x_resultout := wf_engine.eng_null;
2292: return;
2293: end if;
2294:

Line 2291: x_resultout := wf_engine.eng_null;

2287: || l_progress);
2288: END IF;
2289:
2290: if (p_funcmode <> wf_engine.eng_run) then
2291: x_resultout := wf_engine.eng_null;
2292: return;
2293: end if;
2294:
2295: Update_Action_History(p_itemtype => p_itemtype,

Line 2338: if (p_funcmode <> wf_engine.eng_run) then

2334: 'Enter in Update_Action_History_Reject '
2335: || l_progress);
2336: END IF;
2337:
2338: if (p_funcmode <> wf_engine.eng_run) then
2339: x_resultout := wf_engine.eng_null;
2340: return;
2341: end if;
2342:

Line 2339: x_resultout := wf_engine.eng_null;

2335: || l_progress);
2336: END IF;
2337:
2338: if (p_funcmode <> wf_engine.eng_run) then
2339: x_resultout := wf_engine.eng_null;
2340: return;
2341: end if;
2342:
2343: Update_Action_History(p_itemtype => p_itemtype,

Line 2420: l_shipment_header_id := wf_engine.GetItemAttrNumber

2416: || l_progress);
2417: END IF;
2418:
2419:
2420: l_shipment_header_id := wf_engine.GetItemAttrNumber
2421: (itemtype => p_itemtype,
2422: itemkey => p_itemkey,
2423: aname => 'WORK_CONFIRMATION_ID');
2424:

Line 3168: l_shipment_header_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,

3164: elsif (p_funcmode = 'ANSWER') then
3165: l_action := 'ANSWER';
3166: end if;
3167:
3168: l_shipment_header_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
3169: itemkey => p_itemkey,
3170: aname => 'WORK_CONFIRMATION_ID');
3171: IF (g_asn_debug = 'Y') THEN
3172: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,'l_shipment_header_id ' ||l_shipment_header_id);

Line 3175: Wf_Directory.GetRoleOrigSysInfo(WF_ENGINE.CONTEXT_NEW_ROLE, l_origsys, l_new_recipient_id);

3171: IF (g_asn_debug = 'Y') THEN
3172: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,'l_shipment_header_id ' ||l_shipment_header_id);
3173: END IF;
3174:
3175: Wf_Directory.GetRoleOrigSysInfo(WF_ENGINE.CONTEXT_NEW_ROLE, l_origsys, l_new_recipient_id);
3176:
3177: l_progress := 'POS_WCAPPROVE_PVT.post_approval_notif: 02.';
3178:
3179: select max(sequence_num)

Line 3200: p_note => wf_engine.context_user_comment,

3196: UpdatePOActionHistory( p_object_id => Recinfo.object_id,
3197: p_object_type_code => Recinfo.object_type_code,
3198: p_employee_id => Recinfo.employee_id,
3199: p_action_code => l_action,
3200: p_note => wf_engine.context_user_comment,
3201: p_user_id => fnd_global.user_id,
3202: p_login_id => fnd_global.login_id);
3203:
3204:

Line 3223: x_resultout := wf_engine.eng_completed || ':' || wf_engine.eng_null;

3219: p_program_date => Recinfo.program_date ,
3220: p_user_id => fnd_global.user_id ,
3221: p_login_id => fnd_global.login_id);
3222:
3223: x_resultout := wf_engine.eng_completed || ':' || wf_engine.eng_null;
3224: return;
3225: end if;
3226:
3227: if (p_funcmode = 'RESPOND') then

Line 3228: l_notification_id := WF_ENGINE.context_nid;

3224: return;
3225: end if;
3226:
3227: if (p_funcmode = 'RESPOND') then
3228: l_notification_id := WF_ENGINE.context_nid;
3229: IF (g_asn_debug = 'Y') THEN
3230: debug_log(FND_LOG.LEVEL_STATEMENT, l_api_name, 'l_notification_id '||l_notification_id );
3231: END IF;
3232:

Line 3242: l_forward_to_username_response := wf_engine.GetItemAttrText (itemtype => p_itemtype,

3238:
3239: if (l_result = 'FORWARD') THEN
3240:
3241: l_forwardTo := wf_notification.GetAttrText(l_notification_id, 'FORWARD_TO_USERNAME_RESPONSE');
3242: l_forward_to_username_response := wf_engine.GetItemAttrText (itemtype => p_itemtype,
3243: itemkey => p_itemkey,
3244: aname => 'FORWARD_TO_USERNAME_RESPONSE');
3245:
3246: if(l_forwardTo is null) then

Line 3256: if (wf_engine.preserved_context = TRUE) then

3252:
3253: /* Bug 8479430 - START
3254: Set the user context properly before launching the concurrent request*/
3255:
3256: if (wf_engine.preserved_context = TRUE) then
3257: l_preserved_ctx := 'TRUE';
3258: else
3259: l_preserved_ctx := 'FALSE';
3260: end if;

Line 3320: l_preparer_resp_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,

3316: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,'l_session_appl_id ' ||l_session_appl_id);
3317: END IF;
3318: --
3319:
3320: l_preparer_resp_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
3321: itemkey => p_itemkey,
3322: aname => 'RESPONSIBILITY_ID');
3323: l_preparer_appl_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
3324: itemkey => p_itemkey,

Line 3323: l_preparer_appl_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,

3319:
3320: l_preparer_resp_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
3321: itemkey => p_itemkey,
3322: aname => 'RESPONSIBILITY_ID');
3323: l_preparer_appl_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
3324: itemkey => p_itemkey,
3325: aname => 'APPLICATION_ID');
3326:
3327: l_progress := 'POS_WCAPPROVE_PVT.post_approval_notif: 05.' ;

Line 3352: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

3348: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,'l_progress ' ||l_progress || 'When the response is made from email using guest user feature');
3349: END IF;
3350: --
3351:
3352: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
3353: itemkey => p_itemkey,
3354: aname => 'RESPONDER_USER_ID',
3355: avalue => l_responder_id);
3356: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

Line 3356: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

3352: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
3353: itemkey => p_itemkey,
3354: aname => 'RESPONDER_USER_ID',
3355: avalue => l_responder_id);
3356: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
3357: itemkey => p_itemkey,
3358: aname => 'RESPONDER_RESP_ID',
3359: avalue => l_preparer_resp_id);
3360: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

Line 3360: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

3356: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
3357: itemkey => p_itemkey,
3358: aname => 'RESPONDER_RESP_ID',
3359: avalue => l_preparer_resp_id);
3360: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
3361: itemkey => p_itemkey,
3362: aname => 'RESPONDER_APPL_ID',
3363: avalue => l_preparer_appl_id);
3364: ELSE

Line 3384: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

3380: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,'l_progress ' ||l_progress || 'When the response is made from the default worklist');
3381: END IF;
3382: --
3383:
3384: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
3385: itemkey => p_itemkey,
3386: aname => 'RESPONDER_USER_ID',
3387: avalue => l_responder_id);
3388: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

Line 3388: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

3384: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
3385: itemkey => p_itemkey,
3386: aname => 'RESPONDER_USER_ID',
3387: avalue => l_responder_id);
3388: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
3389: itemkey => p_itemkey,
3390: aname => 'RESPONDER_RESP_ID',
3391: avalue => l_preparer_resp_id);
3392: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

Line 3392: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

3388: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
3389: itemkey => p_itemkey,
3390: aname => 'RESPONDER_RESP_ID',
3391: avalue => l_preparer_resp_id);
3392: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
3393: itemkey => p_itemkey,
3394: aname => 'RESPONDER_APPL_ID',
3395: avalue => l_preparer_appl_id);
3396: else

Line 3414: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

3410: --
3411:
3412:
3413: if ( l_preserved_ctx = 'TRUE') then
3414: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
3415: itemkey => p_itemkey,
3416: aname => 'RESPONDER_USER_ID',
3417: avalue => l_responder_id);
3418: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

Line 3418: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

3414: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
3415: itemkey => p_itemkey,
3416: aname => 'RESPONDER_USER_ID',
3417: avalue => l_responder_id);
3418: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
3419: itemkey => p_itemkey,
3420: aname => 'RESPONDER_RESP_ID',
3421: avalue => l_session_resp_id);
3422: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

Line 3422: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

3418: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
3419: itemkey => p_itemkey,
3420: aname => 'RESPONDER_RESP_ID',
3421: avalue => l_session_resp_id);
3422: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
3423: itemkey => p_itemkey,
3424: aname => 'RESPONDER_APPL_ID',
3425: avalue => l_session_appl_id);
3426: else

Line 3427: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

3423: itemkey => p_itemkey,
3424: aname => 'RESPONDER_APPL_ID',
3425: avalue => l_session_appl_id);
3426: else
3427: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
3428: itemkey => p_itemkey,
3429: aname => 'RESPONDER_USER_ID',
3430: avalue => l_responder_id);
3431: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

Line 3431: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

3427: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
3428: itemkey => p_itemkey,
3429: aname => 'RESPONDER_USER_ID',
3430: avalue => l_responder_id);
3431: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
3432: itemkey => p_itemkey,
3433: aname => 'RESPONDER_RESP_ID',
3434: avalue => l_preparer_resp_id);
3435: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

Line 3435: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

3431: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
3432: itemkey => p_itemkey,
3433: aname => 'RESPONDER_RESP_ID',
3434: avalue => l_preparer_resp_id);
3435: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
3436: itemkey => p_itemkey,
3437: aname => 'RESPONDER_APPL_ID',
3438: avalue => l_preparer_appl_id);
3439: end if;

Line 3446: x_resultout := wf_engine.eng_completed || ':' || wf_engine.eng_null;

3442: end if;
3443:
3444: -- Bug 8479430 - END
3445:
3446: x_resultout := wf_engine.eng_completed || ':' || wf_engine.eng_null;
3447: return;
3448: end if;
3449:
3450:

Line 3490: if (p_funcmode <> wf_engine.eng_run) then

3486: 'Enter in reject_doc '
3487: || l_progress);
3488: END IF;
3489:
3490: if (p_funcmode <> wf_engine.eng_run) then
3491: x_resultout := wf_engine.eng_null;
3492: return;
3493: end if;
3494:

Line 3491: x_resultout := wf_engine.eng_null;

3487: || l_progress);
3488: END IF;
3489:
3490: if (p_funcmode <> wf_engine.eng_run) then
3491: x_resultout := wf_engine.eng_null;
3492: return;
3493: end if;
3494:
3495: l_progress := 'POS_WCAPPROVE_PVT.reject_doc: 02.';

Line 3496: l_shipment_header_id := wf_engine.GetItemAttrNumber

3492: return;
3493: end if;
3494:
3495: l_progress := 'POS_WCAPPROVE_PVT.reject_doc: 02.';
3496: l_shipment_header_id := wf_engine.GetItemAttrNumber
3497: (itemtype => p_itemtype,
3498: itemkey => p_itemkey,
3499: aname => 'WORK_CONFIRMATION_ID');
3500:

Line 3519: x_resultout := wf_engine.eng_completed || ':' || 'N';

3515: l_api_name,
3516: 'Could not Reject the document '
3517: || l_progress);
3518: END IF;
3519: x_resultout := wf_engine.eng_completed || ':' || 'N';
3520: END IF;
3521:
3522: IF (l_result = 'Y') THEN
3523:

Line 3530: wf_engine.SetItemAttrText ( itemtype => p_itemtype,

3526: l_api_name,
3527: 'Rejected the document '
3528: || l_progress);
3529: END IF;
3530: wf_engine.SetItemAttrText ( itemtype => p_itemtype,
3531: itemkey => p_itemkey,
3532: aname => 'DOC_STATUS',
3533: avalue => 'REJECTED');
3534:

Line 3536: l_po_header_id := wf_engine.GetItemAttrNumber

3532: aname => 'DOC_STATUS',
3533: avalue => 'REJECTED');
3534:
3535:
3536: l_po_header_id := wf_engine.GetItemAttrNumber
3537: (itemtype => p_itemtype,
3538: itemkey => p_itemkey,
3539: aname => 'PO_DOCUMENT_ID');
3540:

Line 3547: wf_engine.GetItemAttrText (itemtype => p_itemtype,

3543: 'l_po_header_id ' || l_po_header_id);
3544: END IF;
3545:
3546: l_work_confirmation_number :=
3547: wf_engine.GetItemAttrText (itemtype => p_itemtype,
3548: itemkey => p_itemkey,
3549: aname => 'WORK_CONFIRMATION_NUMBER');
3550:
3551: IF (g_asn_debug = 'Y') THEN

Line 3566: wf_engine.SetItemAttrText ( itemtype => p_itemType,

3562: 'WcNum=' || (wfa_html.encode_url(l_work_confirmation_number)) || '&' ||
3563: -- 'ReadOnly=Y' || '&' ||
3564: 'addBreadCrumb=Y';
3565:
3566: wf_engine.SetItemAttrText ( itemtype => p_itemType,
3567: itemkey => p_itemkey,
3568: aname => 'VIEW_WC_LINES_DETAIL_URL' ,
3569: avalue => l_view_wc_lines_detail_url);
3570: x_resultout := wf_engine.eng_completed || ':' || 'Y';

Line 3570: x_resultout := wf_engine.eng_completed || ':' || 'Y';

3566: wf_engine.SetItemAttrText ( itemtype => p_itemType,
3567: itemkey => p_itemkey,
3568: aname => 'VIEW_WC_LINES_DETAIL_URL' ,
3569: avalue => l_view_wc_lines_detail_url);
3570: x_resultout := wf_engine.eng_completed || ':' || 'Y';
3571: END IF;
3572: EXCEPTION
3573: when others then
3574: IF (g_asn_debug = 'Y') THEN

Line 3608: if (p_funcmode <> wf_engine.eng_run) then

3604: 'Enter in Approve_doc '
3605: || l_progress);
3606: END IF;
3607:
3608: if (p_funcmode <> wf_engine.eng_run) then
3609: x_resultout := wf_engine.eng_null;
3610: return;
3611: end if;
3612:

Line 3609: x_resultout := wf_engine.eng_null;

3605: || l_progress);
3606: END IF;
3607:
3608: if (p_funcmode <> wf_engine.eng_run) then
3609: x_resultout := wf_engine.eng_null;
3610: return;
3611: end if;
3612:
3613: l_progress := 'POS_WCAPPROVE_PVT.Approve_doc: 02.';

Line 3614: l_shipment_header_id := wf_engine.GetItemAttrNumber

3610: return;
3611: end if;
3612:
3613: l_progress := 'POS_WCAPPROVE_PVT.Approve_doc: 02.';
3614: l_shipment_header_id := wf_engine.GetItemAttrNumber
3615: (itemtype => p_itemtype,
3616: itemkey => p_itemkey,
3617: aname => 'WORK_CONFIRMATION_ID');
3618:

Line 3635: x_resultout := wf_engine.eng_completed || ':' || 'N';

3631: l_api_name,
3632: 'Could not Reject the document '
3633: || l_progress);
3634: END IF;
3635: x_resultout := wf_engine.eng_completed || ':' || 'N';
3636: END IF;
3637:
3638: IF (l_result = 'Y') THEN
3639:

Line 3646: wf_engine.SetItemAttrText ( itemtype => p_itemtype,

3642: l_api_name,
3643: 'Approved the document '
3644: || l_progress);
3645: END IF;
3646: wf_engine.SetItemAttrText ( itemtype => p_itemtype,
3647: itemkey => p_itemkey,
3648: aname => 'DOC_STATUS',
3649: avalue => 'APPROVED');
3650:

Line 3651: l_po_header_id := wf_engine.GetItemAttrNumber

3647: itemkey => p_itemkey,
3648: aname => 'DOC_STATUS',
3649: avalue => 'APPROVED');
3650:
3651: l_po_header_id := wf_engine.GetItemAttrNumber
3652: (itemtype => p_itemtype,
3653: itemkey => p_itemkey,
3654: aname => 'PO_DOCUMENT_ID');
3655:

Line 3662: wf_engine.GetItemAttrText (itemtype => p_itemtype,

3658: 'l_po_header_id ' || l_po_header_id);
3659: END IF;
3660:
3661: l_work_confirmation_number :=
3662: wf_engine.GetItemAttrText (itemtype => p_itemtype,
3663: itemkey => p_itemkey,
3664: aname => 'WORK_CONFIRMATION_NUMBER');
3665:
3666: IF (g_asn_debug = 'Y') THEN

Line 3681: wf_engine.SetItemAttrText ( itemtype => p_itemType,

3677: 'WcNum=' || (wfa_html.encode_url(l_work_confirmation_number)) || '&' ||
3678: --'ReadOnly=Y' || '&' ||
3679: 'addBreadCrumb=Y';
3680:
3681: wf_engine.SetItemAttrText ( itemtype => p_itemType,
3682: itemkey => p_itemkey,
3683: aname => 'VIEW_WC_LINES_DETAIL_URL' ,
3684: avalue => l_view_wc_lines_detail_url);
3685:

Line 3686: x_resultout := wf_engine.eng_completed || ':' || 'Y';

3682: itemkey => p_itemkey,
3683: aname => 'VIEW_WC_LINES_DETAIL_URL' ,
3684: avalue => l_view_wc_lines_detail_url);
3685:
3686: x_resultout := wf_engine.eng_completed || ':' || 'Y';
3687: END IF;
3688: EXCEPTION
3689: when others then
3690: IF (g_asn_debug = 'Y') THEN

Line 4021: if (p_funcmode <> wf_engine.eng_run) then

4017: 'Enter in insert_into_rti '
4018: || l_progress);
4019: END IF;
4020:
4021: if (p_funcmode <> wf_engine.eng_run) then
4022: x_resultout := wf_engine.eng_null;
4023: return;
4024: end if;
4025:

Line 4022: x_resultout := wf_engine.eng_null;

4018: || l_progress);
4019: END IF;
4020:
4021: if (p_funcmode <> wf_engine.eng_run) then
4022: x_resultout := wf_engine.eng_null;
4023: return;
4024: end if;
4025:
4026: l_shipment_header_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,

Line 4026: l_shipment_header_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,

4022: x_resultout := wf_engine.eng_null;
4023: return;
4024: end if;
4025:
4026: l_shipment_header_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
4027: itemkey => p_itemkey,
4028: aname => 'WORK_CONFIRMATION_ID');
4029:
4030:

Line 4046: wf_engine.SetItemAttrNumber (itemtype => p_itemtype,

4042: l_header_interface_id ||
4043: ' l_group_id ' || l_group_id);
4044: END IF;
4045:
4046: wf_engine.SetItemAttrNumber (itemtype => p_itemtype,
4047: itemkey => p_itemkey,
4048: aname => 'INTERFACE_GROUP_ID',
4049: avalue => l_group_id);
4050:

Line 4831: x_resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

4827: debug_log(FND_LOG.LEVEL_STATEMENT,
4828: l_api_name,'Leave insert_into_rti ' );
4829: END IF;
4830:
4831: x_resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
4832:
4833: return;
4834:
4835: exception

Line 4869: if (p_funcmode <> wf_engine.eng_run) then

4865: 'Enter in Launch_RTP_Immediate '
4866: || l_progress);
4867: END IF;
4868:
4869: if (p_funcmode <> wf_engine.eng_run) then
4870: x_resultout := wf_engine.eng_null;
4871: return;
4872: end if;
4873:

Line 4870: x_resultout := wf_engine.eng_null;

4866: || l_progress);
4867: END IF;
4868:
4869: if (p_funcmode <> wf_engine.eng_run) then
4870: x_resultout := wf_engine.eng_null;
4871: return;
4872: end if;
4873:
4874: l_group_id := wf_engine.GetItemAttrNumber

Line 4874: l_group_id := wf_engine.GetItemAttrNumber

4870: x_resultout := wf_engine.eng_null;
4871: return;
4872: end if;
4873:
4874: l_group_id := wf_engine.GetItemAttrNumber
4875: (itemtype => p_itemtype,
4876: itemkey => p_itemkey,
4877: aname => 'INTERFACE_GROUP_ID');
4878:

Line 4937: x_resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

4933: IF (g_asn_debug = 'Y') THEN
4934: debug_log(FND_LOG.LEVEL_STATEMENT,
4935: l_api_name, 'Leave RTP launch ' );
4936: END IF;
4937: x_resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
4938: return;
4939:
4940: exception
4941: when others then

Line 5560: l_org_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,

5556: END IF;
5557: --
5558:
5559:
5560: l_org_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
5561: itemkey => p_itemkey,
5562: aname => 'ORG_ID');
5563: l_session_user_id := fnd_global.user_id;
5564: l_session_resp_id := fnd_global.resp_id;

Line 5574: l_responder_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,

5570: IF (l_session_resp_id = -1) THEN
5571: l_session_resp_id := NULL;
5572: END IF;
5573:
5574: l_responder_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
5575: itemkey => p_itemkey,
5576: aname => 'RESPONDER_USER_ID');
5577:
5578: --

Line 5607: if (wf_engine.preserved_context = TRUE) then

5603: -- context. This is required since the mailer/bckgrnd ps carries the
5604: -- context from the last wf processed and hence even if the context values
5605: -- are present, they might not be correct.
5606:
5607: if (wf_engine.preserved_context = TRUE) then
5608: p_x_result := 'TRUE';
5609: else
5610: p_x_result:= 'NOTSET';
5611: end if;

Line 5633: l_resp_id_to_set := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,

5629: if l_responder_id is not null then
5630:
5631: l_user_id_to_set := l_responder_id;
5632:
5633: l_resp_id_to_set := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
5634: itemkey => p_itemkey,
5635: aname => 'RESPONDER_RESP_ID');
5636: l_appl_id_to_set := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
5637: itemkey => p_itemkey,

Line 5636: l_appl_id_to_set := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,

5632:
5633: l_resp_id_to_set := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
5634: itemkey => p_itemkey,
5635: aname => 'RESPONDER_RESP_ID');
5636: l_appl_id_to_set := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
5637: itemkey => p_itemkey,
5638: aname => 'RESPONDER_APPL_ID');
5639: --
5640: l_progress := '020 selection fn responder id not null';

Line 5655: l_user_id_to_set := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,

5651: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_WCAPPROVE_PVT.POWC_SELECTOR.invoked','l_progress3 : '||l_progress);
5652: END IF;
5653: --
5654: else
5655: l_user_id_to_set := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
5656: itemkey => p_itemkey,
5657: aname => 'USER_ID');
5658: l_resp_id_to_set := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
5659: itemkey => p_itemkey,

Line 5658: l_resp_id_to_set := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,

5654: else
5655: l_user_id_to_set := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
5656: itemkey => p_itemkey,
5657: aname => 'USER_ID');
5658: l_resp_id_to_set := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
5659: itemkey => p_itemkey,
5660: aname => 'RESPONSIBILITY_ID');
5661: l_appl_id_to_set := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
5662: itemkey => p_itemkey,

Line 5661: l_appl_id_to_set := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,

5657: aname => 'USER_ID');
5658: l_resp_id_to_set := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
5659: itemkey => p_itemkey,
5660: aname => 'RESPONSIBILITY_ID');
5661: l_appl_id_to_set := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
5662: itemkey => p_itemkey,
5663: aname => 'APPLICATION_ID');
5664: --
5665: l_progress := '040 selector fn responder id null';