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

Line 64: wf_engine.createprocess (

60: l_itemtype := P_itemtype_name; --'ASOAPPRV';
61: l_itemkey := TO_CHAR (
62: P_Object_approval_id
63: ) || 'HED';
64: wf_engine.createprocess (
65: itemtype => l_itemtype,
66: itemkey => l_itemkey,
67: process => 'PARALLELAPR'
68: );

Line 69: wf_engine.setitemowner (

65: itemtype => l_itemtype,
66: itemkey => l_itemkey,
67: process => 'PARALLELAPR'
68: );
69: wf_engine.setitemowner (
70: l_itemtype,
71: l_itemkey,
72: P_sender_name
73: );

Line 74: wf_engine.setitemuserkey (

70: l_itemtype,
71: l_itemkey,
72: P_sender_name
73: );
74: wf_engine.setitemuserkey (
75: itemtype => l_itemtype,
76: itemkey => l_itemkey,
77: userkey => l_itemkey
78: );

Line 79: wf_engine.setitemattrtext (

75: itemtype => l_itemtype,
76: itemkey => l_itemkey,
77: userkey => l_itemkey
78: );
79: wf_engine.setitemattrtext (
80: itemtype => l_itemtype,
81: itemkey => l_itemkey,
82: aname => 'REQUESTOR_USERNAME',
83: avalue => P_sender_name

Line 85: wf_engine.setitemattrnumber (

81: itemkey => l_itemkey,
82: aname => 'REQUESTOR_USERNAME',
83: avalue => P_sender_name
84: );
85: wf_engine.setitemattrnumber (
86: itemtype => l_itemtype,
87: itemkey => l_itemkey,
88: aname => 'APPROVALID',
89: avalue => P_Object_approval_id

Line 92: wf_engine.setitemattrtext (

88: aname => 'APPROVALID',
89: avalue => P_Object_approval_id
90: );
91:
92: wf_engine.setitemattrtext (
93: itemtype => l_itemtype,
94: itemkey => l_itemkey,
95: aname => 'NEWPROCESSFLAG',
96: avalue =>'Y'

Line 103: wf_engine.setitemattrtext (

99:
100: l_requestor_display_name := wf_directory.getroledisplayname (
101: P_sender_name
102: );
103: wf_engine.setitemattrtext (
104: itemtype => l_itemtype,
105: itemkey => l_itemkey,
106: aname => 'REQUESTOR_DISPLAYNAME',
107: avalue => l_requestor_display_name

Line 117: wf_engine.startprocess (

113: 'N'
114: );
115: END IF;
116:
117: wf_engine.startprocess (
118: itemtype => l_itemtype,
119: itemkey => l_itemkey
120: );
121:

Line 304: /* l_ame_exception := wf_engine.GetItemAttrText(itemtype => itemtype,

300:
301: END IF;
302:
303: IF (funcmode = 'RUN') THEN
304: /* l_ame_exception := wf_engine.GetItemAttrText(itemtype => itemtype,
305: itemkey => itemkey,
306: aname => 'AME_EXCEPTION',
307: ignore_notfound => TRUE);
308:

Line 314: l_approval_id := wf_engine.getitemattrnumber (

310: resultout:='COMPLETE:'||'INVALID_APPROVER';
311: RETURN;
312: END IF;
313: */
314: l_approval_id := wf_engine.getitemattrnumber (
315: itemtype,
316: itemkey,
317: 'APPROVALID'
318: );

Line 354: resultout:=wf_engine.eng_completed || ':' ||'INVALID_APPROVER';

350: EXCEPTION
351: WHEN OTHERS THEN
352: if SQLCODE= -20212 then
353: -- pp_debug('SQLCODE 20212');
354: resultout:=wf_engine.eng_completed || ':' ||'INVALID_APPROVER';
355: wf_core.context
356: (itemtype,
357: 'Get_Next_Approvers: Unable to get the surrogate approver from AME.',
358: itemtype,

Line 377: resultout:=wf_engine.eng_completed || ':' ||'INVALID_APPROVER';

373:
374:
375: else
376:
377: resultout:=wf_engine.eng_completed || ':' ||'INVALID_APPROVER';
378: wf_core.context
379: (itemtype,
380: 'Get_Next_Approvers: Unable to get the next approvers from AME.',
381: itemtype,

Line 392: resultout:=wf_engine.eng_completed || ':' ||'VALID APPROVER';

388: --pp_debug('In Get next approvers g_next_approvers'||g_next_approvers.count);
389: --pp_debug('In Get next approvers l_completeYNO::'||l_completeYNO);
390: -- Check the number of next approvers. If the count is zero, then verify the approval process is completed or not.
391: if ( g_next_approvers.count > 0 ) then
392: resultout:=wf_engine.eng_completed || ':' ||'VALID APPROVER';
393: --pp_debug('In Get next approvers resultout'||resultout);
394: return;
395:
396: else

Line 401: resultout:=wf_engine.eng_completed || ':' ||'NO_NEXT_APPROVER';

397:
398: -- 'X' is the code when there is no rule needed and applied.
399:
400: if (l_completeYNO in ('X','Y')) then
401: resultout:=wf_engine.eng_completed || ':' ||'NO_NEXT_APPROVER';
402: --pp_debug('In Get next approvers resultout'||resultout);
403: return;
404: else
405: resultout:=wf_engine.eng_completed || ':' ||'';

Line 405: resultout:=wf_engine.eng_completed || ':' ||'';

401: resultout:=wf_engine.eng_completed || ':' ||'NO_NEXT_APPROVER';
402: --pp_debug('In Get next approvers resultout'||resultout);
403: return;
404: else
405: resultout:=wf_engine.eng_completed || ':' ||'';
406: --pp_debug('In Get next approvers resultout'||resultout);
407: return;
408: end if;
409:

Line 420: resultout:=wf_engine.eng_completed || ':' ||'INVALID_APPROVER';

416: itemtype,
417: 'GET_NEXT_APPROVERS Exception Block',
418: itemtype,
419: itemkey);
420: resultout:=wf_engine.eng_completed || ':' ||'INVALID_APPROVER';
421: return;
422:
423:
424: end Get_Next_Approvers;

Line 480: l_approval_id := wf_engine.getitemattrnumber (

476: END IF;
477:
478: IF funcmode = 'RUN'
479: THEN
480: l_approval_id := wf_engine.getitemattrnumber (
481: itemtype,
482: itemkey,
483: 'APPROVALID'
484: );

Line 504: wf_engine.setitemattrtext (

500: 1,
501: 'N'
502: );
503: END IF;
504: wf_engine.setitemattrtext (
505: itemtype => itemtype,
506: itemkey => itemkey,
507: aname => 'APPROVAL_OBJECT',
508: avalue => l_approval_object

Line 511: wf_engine.setitemattrnumber (

507: aname => 'APPROVAL_OBJECT',
508: avalue => l_approval_object
509: );
510:
511: wf_engine.setitemattrnumber (
512: itemtype => itemtype,
513: itemkey => itemkey,
514: aname => 'ORGID',
515: avalue => l_org_id

Line 518: wf_engine.setitemattrnumber (

514: aname => 'ORGID',
515: avalue => l_org_id
516: );
517:
518: wf_engine.setitemattrnumber (
519: itemtype => itemtype,
520: itemkey => itemkey,
521: aname => 'QTEHDRID',
522: avalue => i.quote_header_id

Line 525: wf_engine.setitemattrnumber (

521: aname => 'QTEHDRID',
522: avalue => i.quote_header_id
523: );
524:
525: wf_engine.setitemattrnumber (
526: itemtype => itemtype,
527: itemkey => itemkey,
528: aname => 'QTENUMBER',
529: avalue => i.quote_number

Line 551: wf_engine.setitemattrtext (

547: aso_debug_pub.ADD ('l_url: '||substr(l_url,1,240),1,'N');
548: END IF;
549:
550:
551: wf_engine.setitemattrtext (
552: itemtype => itemtype,
553: itemkey => itemkey,
554: aname => 'OAQTEDETAILLNK',
555: avalue => l_url

Line 559: resultout := wf_engine.eng_completed;

555: avalue => l_url
556: );
557:
558: END LOOP;
559: resultout := wf_engine.eng_completed;
560: --pp_debug('End set attributes');
561: END IF;
562: EXCEPTION
563: WHEN OTHERS

Line 655: l_approval_id := wf_engine.getitemattrnumber (

651:
652: --pp_debug ('Begin Lauch Approval Process Launch_Parallel_Approval');
653:
654:
655: l_approval_id := wf_engine.getitemattrnumber (
656: itemtype,
657: itemkey,
658: 'APPROVALID'
659: );

Line 660: l_requestor_name := wf_engine.getitemattrtext (

656: itemtype,
657: itemkey,
658: 'APPROVALID'
659: );
660: l_requestor_name := wf_engine.getitemattrtext (
661: itemtype,
662: itemkey,
663: 'REQUESTOR_USERNAME'
664: );

Line 666: wf_engine.getitemattrtext (

662: itemkey,
663: 'REQUESTOR_USERNAME'
664: );
665: l_requestor_displayname :=
666: wf_engine.getitemattrtext (
667: itemtype,
668: itemkey,
669: 'REQUESTOR_DISPLAYNAME'
670: );

Line 695: l_orgid := wf_engine.getitemattrnumber (

691: 'N'
692: );
693: END IF;
694:
695: l_orgid := wf_engine.getitemattrnumber (
696: itemtype,
697: itemkey,
698: 'ORGID'
699: );

Line 758: wf_engine.CreateProcess( itemtype => itemtype,

754: l_forward_displayname := l_next_approver_disp_name;
755: END IF;
756:
757: -- Create a child process for the retrieved approver.
758: wf_engine.CreateProcess( itemtype => itemtype,
759: itemkey => l_item_key,
760: process => 'PARALLELSUBPROCESS');
761:
762:

Line 764: wf_engine.SetItemParent( itemtype => itemtype,

760: process => 'PARALLELSUBPROCESS');
761:
762:
763: /* Need to set the parent child relationship between processes */
764: wf_engine.SetItemParent( itemtype => itemtype,
765: itemkey => l_item_key,
766: parent_itemtype => itemtype,
767: parent_itemkey => itemkey,
768: parent_context => NULL);

Line 770: wf_engine.setitemuserkey (

766: parent_itemtype => itemtype,
767: parent_itemkey => itemkey,
768: parent_context => NULL);
769:
770: wf_engine.setitemuserkey (
771: itemtype => itemtype,
772: itemkey => l_item_key,
773: userkey => l_item_key
774: );

Line 775: wf_engine.setitemattrnumber (

771: itemtype => itemtype,
772: itemkey => l_item_key,
773: userkey => l_item_key
774: );
775: wf_engine.setitemattrnumber (
776: itemtype => itemtype,
777: itemkey => l_item_key,
778: aname => 'APPROVAL_DET_ID',
779: avalue => l_approval_detail_id

Line 781: wf_engine.setitemattrtext (

777: itemkey => l_item_key,
778: aname => 'APPROVAL_DET_ID',
779: avalue => l_approval_detail_id
780: );
781: wf_engine.setitemattrtext (
782: itemtype => itemtype, --'ASOAPPRV',
783: itemkey => l_item_key,
784: aname => 'REQUESTOR_DISPLAYNAME',
785: avalue => l_requestor_displayname

Line 787: wf_engine.setitemattrtext (

783: itemkey => l_item_key,
784: aname => 'REQUESTOR_DISPLAYNAME',
785: avalue => l_requestor_displayname
786: );
787: wf_engine.setitemattrtext (
788: itemtype => itemtype,
789: itemkey => l_item_key,
790: aname => 'RECEIVER_USERNAME',
791: avalue => l_forward_user_name

Line 794: wf_engine.setitemattrtext (

790: aname => 'RECEIVER_USERNAME',
791: avalue => l_forward_user_name
792: );
793:
794: wf_engine.setitemattrtext (
795: itemtype => itemtype,
796: itemkey => itemkey,
797: aname => 'NEWPROCESSFLAG',
798: avalue =>'Y'

Line 805: wf_engine.setitemattrtext (

801: l_forward_displayname :=
802: wf_directory.getroledisplayname (
803: l_forward_user_name
804: );
805: wf_engine.setitemattrtext (
806: itemtype => itemtype,
807: itemkey => l_item_key,
808: aname => 'RECEIVER_DISPLAYNAME',
809: avalue => l_forward_displayname

Line 811: wf_engine.setitemattrtext (

807: itemkey => l_item_key,
808: aname => 'RECEIVER_DISPLAYNAME',
809: avalue => l_forward_displayname
810: );
811: wf_engine.setitemattrtext (
812: itemtype => itemtype, --'ASOAPPRV',
813: itemkey => l_item_key,
814: aname => 'REQUESTOR_USERNAME',
815: avalue => l_requestor_name

Line 817: wf_engine.setitemattrnumber (

813: itemkey => l_item_key,
814: aname => 'REQUESTOR_USERNAME',
815: avalue => l_requestor_name
816: );
817: wf_engine.setitemattrnumber (
818: itemtype => itemtype, --'ASOAPPRV',
819: itemkey => l_item_key,
820: aname => 'APPROVALID',
821: avalue => l_approval_id

Line 829: wf_engine.setitemattrtext (

825:
826: if (g_next_approvers(l_approver_index).approver_category = ame_util.fyiApproverCategory) then
827: l_has_fyi_app := 'Y';
828: l_start_block_activity := 'N';
829: wf_engine.setitemattrtext (
830: itemtype => itemtype,
831: itemkey => l_item_key,
832: aname => 'IS_FYI_APPROVER',
833: avalue => 'Y'

Line 836: wf_engine.setitemattrtext (

832: aname => 'IS_FYI_APPROVER',
833: avalue => 'Y'
834: );
835: else
836: wf_engine.setitemattrtext (
837: itemtype => itemtype,
838: itemkey => l_item_key,
839: aname => 'IS_FYI_APPROVER',
840: avalue => 'N'

Line 869: wf_engine.StartProcess( itemtype => itemtype,

865: L_AUTHORITY => g_next_approvers(l_approver_index).authority ,
866: l_APPROVER_CATEGORY => g_next_approvers(l_approver_index).approver_category);
867:
868:
869: wf_engine.StartProcess( itemtype => itemtype,
870: itemkey => l_item_key );
871:
872: l_approver_index := g_next_approvers.next(l_approver_index);
873:

Line 879: resultout:=wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

875:
876: end loop; -- end of for loop.
877:
878: if l_start_block_activity = 'Y' then
879: resultout:=wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
880: else
881: resultout:=wf_engine.eng_completed || ':' || '';
882: end if;
883: -- After routing is done, delete approver list

Line 881: resultout:=wf_engine.eng_completed || ':' || '';

877:
878: if l_start_block_activity = 'Y' then
879: resultout:=wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
880: else
881: resultout:=wf_engine.eng_completed || ':' || '';
882: end if;
883: -- After routing is done, delete approver list
884: g_next_approvers.delete;
885:

Line 959: IF (funcmode <> wf_engine.eng_run) THEN

955: IS
956: l_is_fyi_approver VARCHAR2(1);
957: BEGIN
958:
959: IF (funcmode <> wf_engine.eng_run) THEN
960: resultout := wf_engine.eng_null;
961: RETURN;
962: END IF;
963:

Line 960: resultout := wf_engine.eng_null;

956: l_is_fyi_approver VARCHAR2(1);
957: BEGIN
958:
959: IF (funcmode <> wf_engine.eng_run) THEN
960: resultout := wf_engine.eng_null;
961: RETURN;
962: END IF;
963:
964:

Line 967: l_is_fyi_approver := wf_engine.getitemattrtext (

963:
964:
965: --Logic is check first for workflow attribute 'IS_FYI_APPROVER', then attribute 'APPROVER_CATEGORY'
966: --Fetch 'IS_FYI_APPROVER' value which is set in launch_parralel_approval
967: l_is_fyi_approver := wf_engine.getitemattrtext (
968: itemtype,
969: itemkey,
970: 'IS_FYI_APPROVER'
971: );

Line 974: resultout := wf_engine.eng_completed || ':' || 'Y';

970: 'IS_FYI_APPROVER'
971: );
972:
973: IF l_is_fyi_approver = 'Y' THEN
974: resultout := wf_engine.eng_completed || ':' || 'Y';
975: ELSE
976: resultout := wf_engine.eng_completed || ':' || 'N';
977: END IF;
978:

Line 976: resultout := wf_engine.eng_completed || ':' || 'N';

972:
973: IF l_is_fyi_approver = 'Y' THEN
974: resultout := wf_engine.eng_completed || ':' || 'Y';
975: ELSE
976: resultout := wf_engine.eng_completed || ':' || 'N';
977: END IF;
978:
979: END is_fyi_approver;
980:

Line 1020: IF (funcmode <> wf_engine.eng_run) THEN

1016: 'N'
1017: );
1018: END IF;
1019:
1020: IF (funcmode <> wf_engine.eng_run) THEN
1021: resultout := wf_engine.eng_null;
1022: RETURN;
1023: END IF;
1024:

Line 1021: resultout := wf_engine.eng_null;

1017: );
1018: END IF;
1019:
1020: IF (funcmode <> wf_engine.eng_run) THEN
1021: resultout := wf_engine.eng_null;
1022: RETURN;
1023: END IF;
1024:
1025: IF funcmode = 'RUN'

Line 1028: l_approval_det_id := wf_engine.getitemattrnumber (

1024:
1025: IF funcmode = 'RUN'
1026: THEN
1027:
1028: l_approval_det_id := wf_engine.getitemattrnumber (
1029: itemtype,
1030: itemkey,
1031: 'APPROVAL_DET_ID'
1032: );

Line 1042: l_note := wf_engine.getitemattrtext (

1038: );
1039: END IF;
1040:
1041: --pp_debug('update_Action_history_approve l_approval_det_id'||l_approval_det_id);
1042: l_note := wf_engine.getitemattrtext (
1043: itemtype,
1044: itemkey,
1045: 'NOTE'
1046: );

Line 1072: wf_engine.setitemattrtext (

1068: p_approval_det_id =>l_approval_det_id,
1069: p_status => 'APPR',
1070: note => l_note);
1071:
1072: wf_engine.setitemattrtext (
1073: itemtype => itemtype,
1074: itemkey => itemkey,
1075: aname => 'APPROVER_RESPONSE',
1076: avalue => 'APPROVED'

Line 1079: resultout := wf_engine.eng_completed|| ':' ||'ACTIVITY_PERFORMED';

1075: aname => 'APPROVER_RESPONSE',
1076: avalue => 'APPROVED'
1077: );
1078:
1079: resultout := wf_engine.eng_completed|| ':' ||'ACTIVITY_PERFORMED';
1080: --pp_debug('update_Action_history_approve resultout'||resultout);
1081: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1082: aso_debug_pub.ADD (
1083: 'End of APPROVED Procedure',

Line 1134: IF (funcmode <> wf_engine.eng_run) THEN

1130: 'N'
1131: );
1132: END IF;
1133:
1134: IF (funcmode <> wf_engine.eng_run) THEN
1135: resultout := wf_engine.eng_null;
1136: RETURN;
1137: END IF;
1138:

Line 1135: resultout := wf_engine.eng_null;

1131: );
1132: END IF;
1133:
1134: IF (funcmode <> wf_engine.eng_run) THEN
1135: resultout := wf_engine.eng_null;
1136: RETURN;
1137: END IF;
1138:
1139: IF funcmode = 'RUN'

Line 1148: wf_engine.setitemattrtext (

1144: 1,
1145: 'N'
1146: );
1147: END IF;
1148: wf_engine.setitemattrtext (
1149: itemtype => itemtype,
1150: itemkey => itemkey,
1151: aname => 'MESSAGE',
1152: avalue => 'OA_REQUEST_REJECTED_FYI'

Line 1155: l_approval_det_id := wf_engine.getitemattrnumber (

1151: aname => 'MESSAGE',
1152: avalue => 'OA_REQUEST_REJECTED_FYI'
1153: );
1154: */
1155: l_approval_det_id := wf_engine.getitemattrnumber (
1156: itemtype,
1157: itemkey,
1158: 'APPROVAL_DET_ID'
1159: );

Line 1167: l_note := wf_engine.getitemattrtext (

1163: 1,
1164: 'N'
1165: );
1166: END IF;
1167: l_note := wf_engine.getitemattrtext (
1168: itemtype,
1169: itemkey,
1170: 'NOTE'
1171: );

Line 1196: wf_engine.setitemattrtext (

1192: p_status => 'REJ',
1193: note => l_note);
1194:
1195:
1196: wf_engine.setitemattrtext (
1197: itemtype => itemtype,
1198: itemkey => itemkey,
1199: aname => 'APPROVER_RESPONSE',
1200: avalue => 'REJECTED'

Line 1206: resultout := wf_engine.eng_completed|| ':' || 'ACTIVITY_PERFORMED';

1202:
1203:
1204:
1205:
1206: resultout := wf_engine.eng_completed|| ':' || 'ACTIVITY_PERFORMED';
1207: RETURN;
1208: END IF;
1209:
1210:

Line 1260: IF (funcmode <> wf_engine.eng_run) THEN

1256: 1,
1257: 'N'
1258: );
1259: END IF;
1260: IF (funcmode <> wf_engine.eng_run) THEN
1261: resultout := wf_engine.eng_null;
1262: RETURN;
1263: END IF;
1264:

Line 1261: resultout := wf_engine.eng_null;

1257: 'N'
1258: );
1259: END IF;
1260: IF (funcmode <> wf_engine.eng_run) THEN
1261: resultout := wf_engine.eng_null;
1262: RETURN;
1263: END IF;
1264:
1265: IF funcmode = 'RUN'

Line 1267: /* l_notification_id := wf_engine.getitemattrnumber ( -- bug 16764591

1263: END IF;
1264:
1265: IF funcmode = 'RUN'
1266: THEN
1267: /* l_notification_id := wf_engine.getitemattrnumber ( -- bug 16764591
1268: itemtype,
1269: itemkey,
1270: 'NOTIFICATION_ID'
1271: );

Line 1290: wf_engine.setitemattrtext (

1286: 1,
1287: 'N'
1288: );
1289: END IF;
1290: wf_engine.setitemattrtext (
1291: itemtype => itemtype,
1292: itemkey => itemkey,
1293: aname => 'MESSAGE',
1294: avalue => 'OA_REQUEST_TIMEDOUT_FYI'

Line 1296: l_approval_det_id := wf_engine.getitemattrnumber (

1292: itemkey => itemkey,
1293: aname => 'MESSAGE',
1294: avalue => 'OA_REQUEST_TIMEDOUT_FYI'
1295: );*/
1296: l_approval_det_id := wf_engine.getitemattrnumber (
1297: itemtype,
1298: itemkey,
1299: 'APPROVAL_DET_ID'
1300: );

Line 1301: l_note := wf_engine.getitemattrtext (

1297: itemtype,
1298: itemkey,
1299: 'APPROVAL_DET_ID'
1300: );
1301: l_note := wf_engine.getitemattrtext (
1302: itemtype,
1303: itemkey,
1304: 'NOTE'
1305: );

Line 1329: resultout := wf_engine.eng_completed|| ':' ||'ACTIVITY_PERFORMED'; -- bug 16764591

1325: p_approval_det_id =>l_approval_det_id,
1326: p_status => 'TOUT',
1327: note => l_note);
1328:
1329: resultout := wf_engine.eng_completed|| ':' ||'ACTIVITY_PERFORMED'; -- bug 16764591
1330: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1331: aso_debug_pub.ADD (
1332: 'End of TIMEDOUT Procedure',
1333: 1,

Line 1426: l_approval_det_id := wf_engine.getitemattrnumber (

1422: elsif( p_response = 'TIMEOUT') then
1423: l_current_approver.approval_status := ame_util.noResponseStatus;
1424: end if;
1425:
1426: l_approval_det_id := wf_engine.getitemattrnumber (
1427: itemtype,
1428: itemkey,
1429: 'APPROVAL_DET_ID'
1430: );

Line 1432: l_obj_approval_id := wf_engine.getitemattrnumber (

1428: itemkey,
1429: 'APPROVAL_DET_ID'
1430: );
1431:
1432: l_obj_approval_id := wf_engine.getitemattrnumber (
1433: itemtype => itemtype,
1434: itemkey => itemkey,
1435: aname => 'APPROVALID'
1436: );

Line 1469: /* wf_engine.setitemattrtext (itemtype,

1465: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1466: aso_debug_pub.ADD (' Exception in AME when updating approval status'||itemtype||' ,key'||itemkey, 1, 'N' );
1467: end if;
1468: null;
1469: /* wf_engine.setitemattrtext (itemtype,
1470: itemkey,
1471: 'AME_EXCEPTION',
1472: 'Y'
1473: );*/

Line 1552: IF (funcmode <> wf_engine.eng_run) THEN

1548: l_fnd_usr_id number;
1549:
1550: BEGIN
1551:
1552: IF (funcmode <> wf_engine.eng_run) THEN
1553: --pp_debug('Entered Beat not run');
1554: resultout := wf_engine.eng_null;
1555: RETURN;
1556: END IF;

Line 1554: resultout := wf_engine.eng_null;

1550: BEGIN
1551:
1552: IF (funcmode <> wf_engine.eng_run) THEN
1553: --pp_debug('Entered Beat not run');
1554: resultout := wf_engine.eng_null;
1555: RETURN;
1556: END IF;
1557:
1558: IF funcmode = 'RUN' THEN

Line 1569: l_current_username:=wf_engine.getitemattrtext (

1565: --pp_debug('In Beat by First Responder parent_item_type'||l_parent_item_type);
1566: --pp_debug('In Beat by First Responder l_parent_item_key'||l_parent_item_key);
1567:
1568:
1569: l_current_username:=wf_engine.getitemattrtext (
1570: itemtype,
1571: itemkey,
1572: 'RECEIVER_USERNAME');
1573: --pp_debug('In beat by first resp l_current_username'||l_current_username);

Line 1581: l_header_id :=wf_engine.getitemattrnumber (itemtype => l_parent_item_type,

1577: --pp_debug('In beat by first resp tempOrigSystem'||tempOrigSystem);
1578: --pp_debug('In beat by first resp l_current_person_id'||l_current_person_id);
1579:
1580:
1581: l_header_id :=wf_engine.getitemattrnumber (itemtype => l_parent_item_type,
1582: itemkey => l_parent_item_key,
1583: aname => 'QTEHDRID'
1584: );
1585:

Line 1590: wf_engine.getitemattrtext (itemtype => itemtype,

1586: --pp_debug('In beat by first resp l_header_id'||l_header_id);
1587:
1588:
1589: l_approver_response :=
1590: wf_engine.getitemattrtext (itemtype => itemtype,
1591: itemkey => itemkey,
1592: aname => 'APPROVER_RESPONSE'
1593: );
1594: --pp_debug('In beat by first resp l_approver_response'||l_approver_response);

Line 1668: l_approval_det_id:=wf_engine.getitemattrnumber (

1664: BEGIN
1665:
1666: -- pp_debug ('before aborting the flow for l_child_username:'|| l_child_wf_cur.item_type);
1667:
1668: l_approval_det_id:=wf_engine.getitemattrnumber (
1669: itemtype=> l_child_wf_cur.item_type,
1670: itemkey=> l_child_wf_cur.item_key,
1671: aname=> 'APPROVAL_DET_ID');
1672:

Line 1691: wf_engine.abortprocess (l_child_wf_cur.item_type,

1687:
1688: --pp_debug ('before aborting the flow for11:'|| l_child_wf_cur.item_key||l_abort);
1689: l_note := null;--fnd_message.get_string('ICX', 'ICX_POR_REQ_ALREADY_APPROVED');
1690:
1691: wf_engine.abortprocess (l_child_wf_cur.item_type,
1692: l_child_wf_cur.item_key
1693: );
1694: -- updating ASO action history
1695: aso_pa_apr_wf_pvt.update_approval_status (

Line 1724: l_approval_det_id:=wf_engine.getitemattrnumber (

1720: INTO l_child_wf_cur;
1721:
1722: EXIT WHEN l_child_wf%NOTFOUND;
1723: l_note := null; --fnd_message.get_string('ICX', 'ICX_POR_REQ_ALREADY_REJECTED');
1724: l_approval_det_id:=wf_engine.getitemattrnumber (
1725: itemtype=> l_child_wf_cur.item_type,
1726: itemkey=> l_child_wf_cur.item_key,
1727: aname=> 'APPROVAL_DET_ID');
1728:

Line 1729: wf_engine.abortprocess (l_child_wf_cur.item_type,

1725: itemtype=> l_child_wf_cur.item_type,
1726: itemkey=> l_child_wf_cur.item_key,
1727: aname=> 'APPROVAL_DET_ID');
1728:
1729: wf_engine.abortprocess (l_child_wf_cur.item_type,
1730: l_child_wf_cur.item_key
1731: );
1732: -- updating ASO action history
1733: aso_pa_apr_wf_pvt.update_approval_status (

Line 1748: wf_engine.CompleteActivity( itemtype => l_parent_item_type,

1744:
1745:
1746:
1747:
1748: wf_engine.CompleteActivity( itemtype => l_parent_item_type,
1749: itemkey => l_parent_item_key,
1750: activity => 'BLOCK',
1751: result => null);
1752:

Line 1754: resultout := wf_engine.eng_completed|| ':' || 'ACTIVITY_PERFORMED';

1750: activity => 'BLOCK',
1751: result => null);
1752:
1753: --pp_debug('END beat by first resultout');
1754: resultout := wf_engine.eng_completed|| ':' || 'ACTIVITY_PERFORMED';
1755:
1756: RETURN;
1757: end if;
1758: EXCEPTION

Line 1811: IF (funcmode <> wf_engine.eng_run) THEN

1807:
1808:
1809: BEGIN
1810:
1811: IF (funcmode <> wf_engine.eng_run) THEN
1812: resultout := wf_engine.eng_null;
1813: RETURN;
1814: END IF;
1815: --pp_debug('Process response approve AME itemkey'||itemkey);

Line 1812: resultout := wf_engine.eng_null;

1808:
1809: BEGIN
1810:
1811: IF (funcmode <> wf_engine.eng_run) THEN
1812: resultout := wf_engine.eng_null;
1813: RETURN;
1814: END IF;
1815: --pp_debug('Process response approve AME itemkey'||itemkey);
1816: process_response_ame(itemtype, itemkey, 'APPROVE');

Line 1833: l_child_approver_user_name := wf_engine.getitemattrtext (

1829: AND item_key = itemkey;
1830:
1831: --pp_debug('Process response approve AME itemkey'||l_parent_item_key);
1832:
1833: l_child_approver_user_name := wf_engine.getitemattrtext (
1834: itemtype,
1835: itemkey,
1836: 'RECEIVER_USERNAME');
1837:

Line 1838: l_child_approver_display_name := wf_engine.getitemattrtext (

1834: itemtype,
1835: itemkey,
1836: 'RECEIVER_USERNAME');
1837:
1838: l_child_approver_display_name := wf_engine.getitemattrtext (
1839: itemtype,
1840: itemkey,
1841: 'RECEIVER_DISPLAYNAME');
1842:

Line 1843: wf_engine.setitemattrtext (

1839: itemtype,
1840: itemkey,
1841: 'RECEIVER_DISPLAYNAME');
1842:
1843: wf_engine.setitemattrtext (
1844: itemtype => l_parent_item_type,
1845: itemkey => l_parent_item_key,
1846: aname => 'AME_SUB_APPROVAL_RESPONSE',
1847: avalue => 'APPROVE'

Line 1850: wf_engine.setitemattrtext (

1846: aname => 'AME_SUB_APPROVAL_RESPONSE',
1847: avalue => 'APPROVE'
1848: );
1849:
1850: wf_engine.setitemattrtext (
1851: itemtype => l_parent_item_type,
1852: itemkey => l_parent_item_key,
1853: aname => 'RECEIVER_USERNAME',
1854: avalue =>l_child_approver_user_name

Line 1857: wf_engine.setitemattrtext (

1853: aname => 'RECEIVER_USERNAME',
1854: avalue =>l_child_approver_user_name
1855: );
1856:
1857: wf_engine.setitemattrtext (
1858: itemtype => l_parent_item_type,
1859: itemkey => l_parent_item_key,
1860: aname => 'RECEIVER_DISPLAYNAME',
1861: avalue => l_child_approver_display_name

Line 1865: resultout := wf_engine.eng_completed||':'||'ACTIVITY_PERFORMED';

1861: avalue => l_child_approver_display_name
1862: );
1863:
1864:
1865: resultout := wf_engine.eng_completed||':'||'ACTIVITY_PERFORMED';
1866: --pp_debug('process response Approve'||resultout);
1867: RETURN;
1868: exception
1869: WHEN OTHERS

Line 1931: IF (funcmode <> wf_engine.eng_run) THEN

1927:
1928:
1929: BEGIN
1930:
1931: IF (funcmode <> wf_engine.eng_run) THEN
1932: resultout := wf_engine.eng_null;
1933: RETURN;
1934: END IF;
1935:

Line 1932: resultout := wf_engine.eng_null;

1928:
1929: BEGIN
1930:
1931: IF (funcmode <> wf_engine.eng_run) THEN
1932: resultout := wf_engine.eng_null;
1933: RETURN;
1934: END IF;
1935:
1936:

Line 1953: l_child_approver_user_name := wf_engine.getitemattrtext (

1949: AND item_key = itemkey;
1950:
1951: process_response_ame(itemtype, itemkey, 'REJECT');
1952:
1953: l_child_approver_user_name := wf_engine.getitemattrtext (
1954: itemtype,
1955: itemkey,
1956: 'RECEIVER_USERNAME');
1957:

Line 1958: l_child_approver_display_name := wf_engine.getitemattrtext (

1954: itemtype,
1955: itemkey,
1956: 'RECEIVER_USERNAME');
1957:
1958: l_child_approver_display_name := wf_engine.getitemattrtext (
1959: itemtype,
1960: itemkey,
1961: 'RECEIVER_DISPLAYNAME');
1962:

Line 1963: wf_engine.setitemattrtext (

1959: itemtype,
1960: itemkey,
1961: 'RECEIVER_DISPLAYNAME');
1962:
1963: wf_engine.setitemattrtext (
1964: itemtype => l_parent_item_type,
1965: itemkey => l_parent_item_key,
1966: aname => 'AME_SUB_APPROVAL_RESPONSE',
1967: avalue => 'REJECT'

Line 1970: wf_engine.setitemattrtext (

1966: aname => 'AME_SUB_APPROVAL_RESPONSE',
1967: avalue => 'REJECT'
1968: );
1969:
1970: wf_engine.setitemattrtext (
1971: itemtype => l_parent_item_type,
1972: itemkey => l_parent_item_key,
1973: aname => 'RECEIVER_USERNAME',
1974: avalue =>l_child_approver_user_name

Line 1977: wf_engine.setitemattrtext (

1973: aname => 'RECEIVER_USERNAME',
1974: avalue =>l_child_approver_user_name
1975: );
1976:
1977: wf_engine.setitemattrtext (
1978: itemtype => l_parent_item_type,
1979: itemkey => l_parent_item_key,
1980: aname => 'RECEIVER_DISPLAYNAME',
1981: avalue => l_child_approver_display_name

Line 1985: resultout := wf_engine.eng_completed||':'||'ACTIVITY_PERFORMED';

1981: avalue => l_child_approver_display_name
1982: );
1983:
1984:
1985: resultout := wf_engine.eng_completed||':'||'ACTIVITY_PERFORMED';
1986: RETURN;
1987: exception
1988: WHEN OTHERS
1989: THEN

Line 2049: IF (funcmode <> wf_engine.eng_run) THEN

2045:
2046:
2047: BEGIN
2048:
2049: IF (funcmode <> wf_engine.eng_run) THEN
2050: resultout := wf_engine.eng_null;
2051: RETURN;
2052: END IF;
2053:

Line 2050: resultout := wf_engine.eng_null;

2046:
2047: BEGIN
2048:
2049: IF (funcmode <> wf_engine.eng_run) THEN
2050: resultout := wf_engine.eng_null;
2051: RETURN;
2052: END IF;
2053:
2054:

Line 2070: l_child_approver_user_name := wf_engine.getitemattrtext (

2066: AND item_key = itemkey;
2067:
2068: process_response_ame(itemtype, itemkey, 'TIMEOUT');
2069:
2070: l_child_approver_user_name := wf_engine.getitemattrtext (
2071: itemtype,
2072: itemkey,
2073: 'RECEIVER_USERNAME');
2074:

Line 2075: l_child_approver_display_name := wf_engine.getitemattrtext (

2071: itemtype,
2072: itemkey,
2073: 'RECEIVER_USERNAME');
2074:
2075: l_child_approver_display_name := wf_engine.getitemattrtext (
2076: itemtype,
2077: itemkey,
2078: 'RECEIVER_DISPLAYNAME');
2079:

Line 2080: wf_engine.setitemattrtext (

2076: itemtype,
2077: itemkey,
2078: 'RECEIVER_DISPLAYNAME');
2079:
2080: wf_engine.setitemattrtext (
2081: itemtype => l_parent_item_type,
2082: itemkey => l_parent_item_key,
2083: aname => 'AME_SUB_APPROVAL_RESPONSE',
2084: avalue => 'TIMEOUT'

Line 2087: wf_engine.setitemattrtext (

2083: aname => 'AME_SUB_APPROVAL_RESPONSE',
2084: avalue => 'TIMEOUT'
2085: );
2086:
2087: wf_engine.setitemattrtext (
2088: itemtype => l_parent_item_type,
2089: itemkey => l_parent_item_key,
2090: aname => 'RECEIVER_USERNAME',
2091: avalue =>l_child_approver_user_name

Line 2094: wf_engine.setitemattrtext (

2090: aname => 'RECEIVER_USERNAME',
2091: avalue =>l_child_approver_user_name
2092: );
2093:
2094: wf_engine.setitemattrtext (
2095: itemtype => l_parent_item_type,
2096: itemkey => l_parent_item_key,
2097: aname => 'RECEIVER_DISPLAYNAME',
2098: avalue => l_child_approver_display_name

Line 2101: wf_engine.CompleteActivity (itemtype => l_parent_item_type,

2097: aname => 'RECEIVER_DISPLAYNAME',
2098: avalue => l_child_approver_display_name
2099: );
2100:
2101: wf_engine.CompleteActivity (itemtype => l_parent_item_type,
2102: itemkey => l_parent_item_key,
2103: activity => 'BLOCK',
2104: result => null);
2105:

Line 2107: resultout := wf_engine.eng_completed||':'||'ACTIVITY_PERFORMED';

2103: activity => 'BLOCK',
2104: result => null);
2105:
2106:
2107: resultout := wf_engine.eng_completed||':'||'ACTIVITY_PERFORMED';
2108: RETURN;
2109: exception
2110: WHEN OTHERS
2111: THEN

Line 2168: IF (funcmode <> wf_engine.eng_run) THEN

2164:
2165:
2166: BEGIN
2167:
2168: IF (funcmode <> wf_engine.eng_run) THEN
2169: resultout := wf_engine.eng_null;
2170: RETURN;
2171: END IF;
2172:

Line 2169: resultout := wf_engine.eng_null;

2165:
2166: BEGIN
2167:
2168: IF (funcmode <> wf_engine.eng_run) THEN
2169: resultout := wf_engine.eng_null;
2170: RETURN;
2171: END IF;
2172:
2173: --pp_debug('updating data for the l_approval_det_id'||l_approval_det_id);

Line 2175: l_approval_det_id := wf_engine.getitemattrnumber (

2171: END IF;
2172:
2173: --pp_debug('updating data for the l_approval_det_id'||l_approval_det_id);
2174:
2175: l_approval_det_id := wf_engine.getitemattrnumber (
2176: itemtype,
2177: itemkey,
2178: 'APPROVAL_DET_ID'
2179: );

Line 2207: resultout := wf_engine.eng_completed;

2203: p_status => 'NR',
2204: note => null);
2205: end if;
2206:
2207: resultout := wf_engine.eng_completed;
2208: RETURN;
2209: exception
2210: WHEN OTHERS
2211: THEN

Line 2269: IF (funcmode <> wf_engine.eng_run) THEN

2265:
2266:
2267: BEGIN
2268:
2269: IF (funcmode <> wf_engine.eng_run) THEN
2270: resultout := wf_engine.eng_null;
2271: RETURN;
2272: END IF;
2273:

Line 2270: resultout := wf_engine.eng_null;

2266:
2267: BEGIN
2268:
2269: IF (funcmode <> wf_engine.eng_run) THEN
2270: resultout := wf_engine.eng_null;
2271: RETURN;
2272: END IF;
2273:
2274: --pp_debug('updating data for the l_approval_det_id'||l_approval_det_id);

Line 2276: l_approval_det_id := wf_engine.getitemattrnumber (

2272: END IF;
2273:
2274: --pp_debug('updating data for the l_approval_det_id'||l_approval_det_id);
2275:
2276: l_approval_det_id := wf_engine.getitemattrnumber (
2277: itemtype,
2278: itemkey,
2279: 'APPROVAL_DET_ID'
2280: );

Line 2294: resultout := wf_engine.eng_completed;

2290: p_status => 'NR',
2291: note => null);
2292:
2293:
2294: resultout := wf_engine.eng_completed;
2295: RETURN;
2296: exception
2297: WHEN OTHERS
2298: THEN

Line 2850: wf_engine.abortprocess (

2846: --pp_debug('In CancelApproval Procedure updating l_parent_item_type::'||l_parent_item_type);
2847: --pp_debug('In CancelApproval Procedure updating l_parent_item_key::'||l_parent_item_key);
2848:
2849: -- Aborting the parent process
2850: wf_engine.abortprocess (
2851: itemtype => l_parent_item_type, --'ASOAPPRV',
2852: itemkey => l_parent_item_key
2853:
2854: );

Line 2938: l_approval_det_id:=wf_engine.getitemattrnumber (

2934: BEGIN
2935: l_count:=l_count+1;
2936: --pp_debug('In CancelApproval Procedure l_child_wf_cur.item_type::'||l_child_wf_cur.item_type);
2937: --pp_debug('In CancelApproval Procedure l_child_wf_cur.item_key::'||l_child_wf_cur.item_key);
2938: l_approval_det_id:=wf_engine.getitemattrnumber (
2939: itemtype=> l_child_wf_cur.item_type,
2940: itemkey=> l_child_wf_cur.item_key,
2941: aname=> 'APPROVAL_DET_ID');
2942:

Line 2943: l_forward_user_name:= wf_engine.getitemattrtext (

2939: itemtype=> l_child_wf_cur.item_type,
2940: itemkey=> l_child_wf_cur.item_key,
2941: aname=> 'APPROVAL_DET_ID');
2942:
2943: l_forward_user_name:= wf_engine.getitemattrtext (
2944: itemtype => l_child_wf_cur.item_type,
2945: itemkey => l_child_wf_cur.item_key,
2946: aname => 'RECEIVER_USERNAME'
2947: );

Line 2969: wf_engine.abortprocess (

2965: 1,
2966: 'N'
2967: );
2968: END IF;
2969: wf_engine.abortprocess (
2970: itemtype => p_itemtype, --'ASOAPPRV',
2971: itemkey => to_char(l_approval_det_id)||'DET'
2972: -- process => '',
2973: -- result => 'CANCELLED'

Line 3002: wf_engine.createprocess (

2998: 1,
2999: 'N'
3000: );
3001: END IF;
3002: wf_engine.createprocess (
3003: itemtype => l_itemtype,
3004: itemkey => l_itemkey,
3005: process => 'PA_CANCEL_REQUISTION'
3006: );

Line 3007: wf_engine.setitemuserkey (

3003: itemtype => l_itemtype,
3004: itemkey => l_itemkey,
3005: process => 'PA_CANCEL_REQUISTION'
3006: );
3007: wf_engine.setitemuserkey (
3008: itemtype => l_itemtype,
3009: itemkey => l_itemkey,
3010: userkey => l_itemkey
3011: );

Line 3012: wf_engine.setitemattrnumber (

3008: itemtype => l_itemtype,
3009: itemkey => l_itemkey,
3010: userkey => l_itemkey
3011: );
3012: wf_engine.setitemattrnumber (
3013: itemtype => l_itemtype,
3014: itemkey => l_itemkey,
3015: aname => 'APPROVAL_DET_ID',
3016: avalue => l_approval_det_id

Line 3018: wf_engine.setitemattrtext (

3014: itemkey => l_itemkey,
3015: aname => 'APPROVAL_DET_ID',
3016: avalue => l_approval_det_id
3017: );
3018: wf_engine.setitemattrtext (
3019: itemtype => l_itemtype, --'ASOAPPRV',
3020: itemkey => l_itemkey,
3021: aname => 'REQUESTOR_DISPLAYNAME',
3022: avalue => l_requestor_displayname

Line 3024: wf_engine.setitemattrtext (

3020: itemkey => l_itemkey,
3021: aname => 'REQUESTOR_DISPLAYNAME',
3022: avalue => l_requestor_displayname
3023: );
3024: wf_engine.setitemattrtext (
3025: itemtype => l_itemtype, --'ASOAPPRV',
3026: itemkey => l_itemkey,
3027: aname => 'REQUESTOR_USERNAME',
3028: avalue => l_requestor_name

Line 3030: wf_engine.setitemattrtext (

3026: itemkey => l_itemkey,
3027: aname => 'REQUESTOR_USERNAME',
3028: avalue => l_requestor_name
3029: );
3030: wf_engine.setitemattrtext (
3031: itemtype => l_itemtype,
3032: itemkey => l_itemkey,
3033: aname => 'RECEIVER_USERNAME',
3034: avalue => l_forward_user_name

Line 3047: wf_engine.setitemattrtext (

3043: l_forward_displayname :=
3044: wf_directory.getroledisplayname (
3045: l_forward_user_name
3046: );
3047: wf_engine.setitemattrtext (
3048: itemtype => l_itemtype,
3049: itemkey => l_itemkey,
3050: aname => 'RECEIVER_DISPLAYNAME',
3051: avalue => l_forward_displayname

Line 3060: wf_engine.setitemattrtext (

3056: 1,
3057: 'N'
3058: );
3059: END IF;
3060: wf_engine.setitemattrtext (
3061: itemtype => l_itemtype,
3062: itemkey => l_itemkey,
3063: aname => 'REQUEST_CANCELLOR_USERNAME',
3064: avalue => l_cancellor_username

Line 3073: wf_engine.setitemattrtext (

3069: 1,
3070: 'N'
3071: );
3072: END IF;
3073: wf_engine.setitemattrtext (
3074: itemtype => l_itemtype,
3075: itemkey => l_itemkey,
3076: aname => 'REQUEST_CANCELLOR_DISPLAYNAME',
3077: avalue => l_cancellor_displayname

Line 3086: wf_engine.setitemattrnumber (

3082: 1,
3083: 'N'
3084: );
3085: END IF;
3086: wf_engine.setitemattrnumber (
3087: itemtype => l_itemtype, --'ASOAPPRV',
3088: itemkey => l_itemkey,
3089: aname => 'APPROVALID',
3090: avalue => l_approval_id

Line 3095: wf_engine.startprocess (

3091: );
3092:
3093: --pp_debug('Before starting the process'||l_itemtype);
3094: --pp_debug('Before starting the process'||l_itemkey);
3095: wf_engine.startprocess (
3096: itemtype => l_itemtype,
3097: itemkey => l_itemkey
3098: );
3099:

Line 3230: IF (funcmode <> wf_engine.eng_run) THEN

3226: 'N'
3227: );
3228: END IF;
3229:
3230: IF (funcmode <> wf_engine.eng_run) THEN
3231: resultout := wf_engine.eng_null;
3232: RETURN;
3233: END IF;
3234:

Line 3231: resultout := wf_engine.eng_null;

3227: );
3228: END IF;
3229:
3230: IF (funcmode <> wf_engine.eng_run) THEN
3231: resultout := wf_engine.eng_null;
3232: RETURN;
3233: END IF;
3234:
3235: IF funcmode = 'RUN'

Line 3238: l_approval_id := wf_engine.getitemattrnumber (

3234:
3235: IF funcmode = 'RUN'
3236: THEN
3237:
3238: l_approval_id := wf_engine.getitemattrnumber (
3239: itemtype,
3240: itemkey,
3241: 'APPROVALID'
3242: );

Line 3267: resultout := wf_engine.eng_completed;

3263: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3264: aso_debug_pub.ADD ('End of UPDATE_ENTITY_REJECT Procedure',1,'N');
3265: END IF;
3266:
3267: resultout := wf_engine.eng_completed;
3268: RETURN;
3269: END IF;
3270:
3271:

Line 3316: IF (funcmode <> wf_engine.eng_run) THEN

3312: 'N'
3313: );
3314: END IF;
3315:
3316: IF (funcmode <> wf_engine.eng_run) THEN
3317: resultout := wf_engine.eng_null;
3318: RETURN;
3319: END IF;
3320:

Line 3317: resultout := wf_engine.eng_null;

3313: );
3314: END IF;
3315:
3316: IF (funcmode <> wf_engine.eng_run) THEN
3317: resultout := wf_engine.eng_null;
3318: RETURN;
3319: END IF;
3320:
3321: IF funcmode = 'RUN'

Line 3324: l_approval_id := wf_engine.getitemattrnumber (

3320:
3321: IF funcmode = 'RUN'
3322: THEN
3323:
3324: l_approval_id := wf_engine.getitemattrnumber (
3325: itemtype,
3326: itemkey,
3327: 'APPROVALID'
3328: );

Line 3361: resultout := wf_engine.eng_completed;

3357: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3358: aso_debug_pub.ADD ('End of UPDATE_ENTITY_approve Procedure',1,'N');
3359: END IF;
3360:
3361: resultout := wf_engine.eng_completed;
3362: RETURN;
3363: END IF;
3364:
3365:

Line 3404: IF (funcmode <> wf_engine.eng_run) THEN

3400: l_api_name VARCHAR2(500) := 'is_ame_exception';
3401:
3402: BEGIN
3403:
3404: IF (funcmode <> wf_engine.eng_run) THEN
3405: resultout := wf_engine.eng_null;
3406: RETURN;
3407: END IF;
3408:

Line 3405: resultout := wf_engine.eng_null;

3401:
3402: BEGIN
3403:
3404: IF (funcmode <> wf_engine.eng_run) THEN
3405: resultout := wf_engine.eng_null;
3406: RETURN;
3407: END IF;
3408:
3409: IF l_ame_exception IS NOT NULL THEN

Line 3410: resultout := wf_engine.eng_completed || ':' ||'Y';

3406: RETURN;
3407: END IF;
3408:
3409: IF l_ame_exception IS NOT NULL THEN
3410: resultout := wf_engine.eng_completed || ':' ||'Y';
3411: ELSE
3412: resultout := wf_engine.eng_completed || ':' ||'N';
3413: END IF;
3414: EXCEPTION

Line 3412: resultout := wf_engine.eng_completed || ':' ||'N';

3408:
3409: IF l_ame_exception IS NOT NULL THEN
3410: resultout := wf_engine.eng_completed || ':' ||'Y';
3411: ELSE
3412: resultout := wf_engine.eng_completed || ':' ||'N';
3413: END IF;
3414: EXCEPTION
3415: WHEN OTHERS THEN
3416: wf_core.context(g_pkg_name, l_api_name, 'Unexpected Exception:', 'IS AME Exceptioon exception block', SQLERRM);