[Home] [Help]
52:
53:
54: ELSIF NVL(l_change_id,0) <= 0 AND NVL(l_change_line_id,0) <= 0 THEN
55: -- Unexpected Exception
56: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
57:
58: END IF ;
59:
60: end if ; -- funcmode : RUN
86: return;
87:
88: EXCEPTION
89:
90: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
91: -- The line below records this function call in the error system
92: -- in the case of an exception.
93: wf_core.context('Eng_Workflow_Pub', 'CHECK_HEADER_OR_LINE',
94: itemtype, itemkey, to_char(actid), funcmode);
185: , p_adhoc_party_list => l_adhoc_party_list
186: ) ;
187:
188:
189: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
190:
191: -- set result
192: result := 'COMPLETE';
193: return;
200: return;
201: ELSE
202:
203: -- Unexpected Exception
204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
205:
206: END IF ;
207:
208: end if ; -- funcmode : RUN
235: return;
236:
237: EXCEPTION
238:
239: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
240: -- The line below records this function call in the error system
241: -- in the case of an exception.
242: wf_core.context('Eng_Workflow_Pub', 'SELECT_ADHOC_PARTY',
243: itemtype, itemkey, to_char(actid), funcmode);
298: , p_item_key => itemkey
299: ) ;
300:
301:
302: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
303:
304:
305: IF l_debug_flag THEN
306: Eng_Workflow_Util.Close_Debug_Session ;
323: return;
324: ELSE
325:
326: -- Unexpected Exception
327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
328:
329: END IF ;
330:
331: end if ; -- funcmode : RUN
358: return;
359:
360: EXCEPTION
361:
362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
363:
364: IF l_debug_flag THEN
365: Eng_Workflow_Util.Close_Debug_Session ;
366: END IF ;
418: , p_reviewer_type => 'STD'
419: ) ;
420:
421:
422: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
423:
424: -- set result
425: result := 'COMPLETE';
426: return;
433: return;
434: ELSE
435:
436: -- Unexpected Exception
437: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
438:
439: END IF ;
440:
441: end if ; -- funcmode : RUN
468: return;
469:
470: EXCEPTION
471:
472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
473: -- The line below records this function call in the error system
474: -- in the case of an exception.
475: wf_core.context('Eng_Workflow_Pub', 'SELECT_STD_REVIEWERS',
476: itemtype, itemkey, to_char(actid), funcmode);
518: , p_reviewer_type => 'NO_ASSIGNEE'
519: ) ;
520:
521:
522: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
523:
524: -- set result
525: result := 'COMPLETE';
526: return;
533: return;
534: ELSE
535:
536: -- Unexpected Exception
537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
538:
539: END IF ;
540:
541: end if ; -- funcmode : RUN
567: return;
568:
569: EXCEPTION
570:
571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
572: -- The line below records this function call in the error system
573: -- in the case of an exception.
574: wf_core.context('Eng_Workflow_Pub', 'SELECT_REVIEWERS',
575: itemtype, itemkey, to_char(actid), funcmode);
628: , p_item_key => itemkey
629: ) ;
630:
631:
632: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
633:
634: IF l_debug_flag THEN
635: Eng_Workflow_Util.Close_Debug_Session ;
636: END IF ;
652: return;
653: ELSE
654:
655: -- Unexpected Exception
656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
657:
658: END IF ;
659:
660: end if ; -- funcmode : RUN
686: return;
687:
688: EXCEPTION
689:
690: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
691:
692: IF l_debug_flag THEN
693: Eng_Workflow_Util.Close_Debug_Session ;
694: END IF ;
760: ) ;
761:
762:
763:
764: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
765:
766: IF l_debug_flag THEN
767: Eng_Workflow_Util.Close_Debug_Session ;
768: END IF ;
785: return;
786: ELSE
787:
788: -- Unexpected Exception
789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
790:
791: END IF ;
792:
793: end if ; -- funcmode : RUN
820: return;
821:
822: EXCEPTION
823:
824: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
825: IF l_debug_flag THEN
826: Eng_Workflow_Util.Close_Debug_Session ;
827: END IF ;
828:
878: , p_reviewer_type => 'NO_ASSIGNEE'
879: ) ;
880:
881:
882: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
883:
884: -- set result
885: result := 'COMPLETE';
886: return;
893: return;
894: ELSE
895:
896: -- Unexpected Exception
897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
898:
899: END IF ;
900:
901: end if ; -- funcmode : RUN
927: return;
928:
929: EXCEPTION
930:
931: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
932: -- The line below records this function call in the error system
933: -- in the case of an exception.
934: wf_core.context('Eng_Workflow_Pub', 'SELECT_LINE_REVIEWERS',
935: itemtype, itemkey, to_char(actid), funcmode);
1007: , p_line_item_type => Eng_Workflow_Util.G_CHANGE_LINE_ACTION_ITEM_TYPE
1008: , p_line_process_name => Eng_Workflow_Util.G_CL_INITIATE_CHANGE_PROC
1009: ) ;
1010:
1011: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1012:
1013: result := 'COMPLETE';
1014: return;
1015:
1015:
1016: ELSE
1017:
1018: -- Unexpected Exception
1019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1020:
1021: END IF ;
1022:
1023: end if ; -- funcmode : RUN
1049: return;
1050:
1051: EXCEPTION
1052:
1053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1054: -- The line below records this function call in the error system
1055: -- in the case of an exception.
1056: wf_core.context('Eng_Workflow_Pub', 'INITIATE_LINES',
1057: itemtype, itemkey, to_char(actid), funcmode);
1097: , p_item_key => itemkey
1098: ) ;
1099:
1100:
1101: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1102:
1103: -- set result
1104: result := 'COMPLETE';
1105: return;
1112: return;
1113: ELSE
1114:
1115: -- Unexpected Exception
1116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1117:
1118: END IF ;
1119:
1120: end if ; -- funcmode : RUN
1147: return;
1148:
1149: EXCEPTION
1150:
1151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1152: -- The line below records this function call in the error system
1153: -- in the case of an exception.
1154: wf_core.context('Eng_Workflow_Pub', 'SELECT_ROUTE_PEOPLE',
1155: itemtype, itemkey, to_char(actid), funcmode);
1196: , p_item_key => itemkey
1197: ) ;
1198:
1199:
1200: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1201:
1202: -- set result
1203: result := 'COMPLETE';
1204: return;
1211: return;
1212: ELSE
1213:
1214: -- Unexpected Exception
1215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1216:
1217: END IF ;
1218:
1219: end if ; -- funcmode : RUN
1246: return;
1247:
1248: EXCEPTION
1249:
1250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1251: -- The line below records this function call in the error system
1252: -- in the case of an exception.
1253: wf_core.context('Eng_Workflow_Pub', 'SELECT_STEP_PEOPLE',
1254: itemtype, itemkey, to_char(actid), funcmode);
1295: , p_item_key => itemkey
1296: ) ;
1297:
1298:
1299: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1300:
1301: -- set result
1302: result := 'COMPLETE';
1303: return;
1304:
1305: ELSE
1306:
1307: -- Unexpected Exception
1308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1309:
1310: END IF ;
1311:
1312: end if ; -- funcmode : RUN
1339: return;
1340:
1341: EXCEPTION
1342:
1343: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1344: -- The line below records this function call in the error system
1345: -- in the case of an exception.
1346: wf_core.context('Eng_Workflow_Pub', 'DELETE_ADHOC_ROLES_AND_USERS',
1347: itemtype, itemkey, to_char(actid), funcmode);
1450: return;
1451:
1452: EXCEPTION
1453:
1454: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1455: -- The line below records this function call in the error system
1456: -- in the case of an exception.
1457: wf_core.context('Eng_Workflow_Pub', 'SET_REQUEST_OPTIONS',
1458: itemtype, itemkey, to_char(actid), funcmode);
1590: return;
1591:
1592: EXCEPTION
1593:
1594: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1595: -- The line below records this function call in the error system
1596: -- in the case of an exception.
1597: wf_core.context('Eng_Workflow_Pub', 'SET_STEP_ACT_OPTIONS',
1598: itemtype, itemkey, to_char(actid), funcmode);
1729: , p_item_key => itemkey
1730: , p_notification_id => WF_ENGINE.context_nid
1731: , p_action_type => Eng_Workflow_Util.G_ACT_REPLIED
1732: , x_action_id => l_created_action_id
1733: , p_raise_event_flag => FND_API.G_TRUE -- R12
1734: ) ;
1735:
1736:
1737: IF l_debug_flag THEN
1738: Eng_Workflow_Util.Write_Debug('After call Eng_Workflow_Util.CreateAction: Return: ' || l_return_status ) ;
1739: END IF ;
1740:
1741:
1742: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1743:
1744: -- Unexpected Exception
1745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1746:
1741:
1742: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1743:
1744: -- Unexpected Exception
1745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1746:
1747: END IF ;
1748:
1749:
1761: , x_return_status => l_return_status
1762: ) ;
1763:
1764:
1765: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1766:
1767: -- set result
1768: result := 'COMPLETE';
1769:
1775:
1776: ELSE
1777:
1778: -- Unexpected Exception
1779: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1780:
1781: END IF ;
1782:
1783:
1835: return;
1836:
1837: EXCEPTION
1838:
1839: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1840:
1841: IF l_debug_flag THEN
1842: Eng_Workflow_Util.Close_Debug_Session ;
1843: END IF ;
1979: Eng_Workflow_Util.Write_Debug('After call Eng_Workflow_Util.SetRouteResponse: Return: ' || l_return_status ) ;
1980: END IF ;
1981:
1982:
1983: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1984:
1985: -- set result
1986: result := 'COMPLETE';
1987:
1993:
1994: ELSE
1995:
1996: -- Unexpected Exception
1997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1998:
1999: END IF ;
2000:
2001:
2050: return;
2051:
2052: EXCEPTION
2053:
2054: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2055:
2056: IF l_debug_flag THEN
2057: Eng_Workflow_Util.Close_Debug_Session ;
2058: END IF ;
2188: Eng_Workflow_Util.Write_Debug('After call Eng_Workflow_Util.SetRouteResponse: Return: ' || l_return_status ) ;
2189: END IF ;
2190:
2191:
2192: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2193:
2194: -- set result
2195: result := 'COMPLETE';
2196:
2203:
2204: ELSE
2205:
2206: -- Unexpected Exception
2207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2208:
2209: END IF ;
2210:
2211:
2223: , x_return_status => l_return_status
2224: ) ;
2225:
2226:
2227: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2228:
2229: -- set result
2230: result := 'COMPLETE';
2231:
2237:
2238: ELSE
2239:
2240: -- Unexpected Exception
2241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2242:
2243: END IF ;
2244: */
2245:
2293: return;
2294:
2295: EXCEPTION
2296:
2297: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2298:
2299: IF l_debug_flag THEN
2300: Eng_Workflow_Util.Close_Debug_Session ;
2301: END IF ;
2442: IF l_debug_flag THEN
2443: Eng_Workflow_Util.Write_Debug('After call Eng_Workflow_Util.SetRouteResponse: Return: ' || l_return_status ) ;
2444: END IF ;
2445:
2446: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2447: -- Unexpected Exception
2448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2449:
2450: END IF ;
2444: END IF ;
2445:
2446: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2447: -- Unexpected Exception
2448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2449:
2450: END IF ;
2451:
2452:
2502: -- , p_orig_response => l_response_code
2503: -- ) ;
2504: --
2505:
2506: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2507:
2508: -- set result
2509: result := 'COMPLETE';
2510:
2516:
2517: ELSE
2518:
2519: -- Unexpected Exception
2520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2521:
2522: END IF ;
2523:
2524:
2574:
2575:
2576: EXCEPTION
2577:
2578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2579:
2580: IF l_debug_flag THEN
2581: Eng_Workflow_Util.Close_Debug_Session ;
2582: END IF ;
2723: IF l_debug_flag THEN
2724: Eng_Workflow_Util.Write_Debug('After call Eng_Workflow_Util.SetRouteResponse: Return: ' || l_return_status ) ;
2725: END IF ;
2726:
2727: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2728: -- Unexpected Exception
2729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2730:
2731: END IF ;
2725: END IF ;
2726:
2727: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2728: -- Unexpected Exception
2729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2730:
2731: END IF ;
2732:
2733:
2792:
2793:
2794: END IF ;
2795:
2796: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2797:
2798: -- set result
2799: result := 'COMPLETE';
2800:
2806:
2807: ELSE
2808:
2809: -- Unexpected Exception
2810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2811:
2812: END IF ;
2813:
2814: end if;
2861: return;
2862:
2863: EXCEPTION
2864:
2865: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2866:
2867: IF l_debug_flag THEN
2868: Eng_Workflow_Util.Close_Debug_Session ;
2869: END IF ;
2976: , aname => 'RESULT'
2977: );
2978:
2979:
2980: l_return_status := FND_API.G_RET_STS_SUCCESS ;
2981:
2982: --
2983: -- Put business logic here in future
2984: --
2983: -- Put business logic here in future
2984: --
2985:
2986:
2987: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2988:
2989: -- set result
2990: result := 'COMPLETE';
2991:
2997: return;
2998:
2999: ELSE
3000: -- Unexpected Exception
3001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3002:
3003: END IF ;
3004:
3005:
3032: return;
3033:
3034: EXCEPTION
3035:
3036: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3037:
3038: IF l_debug_flag THEN
3039: Eng_Workflow_Util.Close_Debug_Session ;
3040: END IF ;
3171: Eng_Workflow_Util.Write_Debug('After call Eng_Workflow_Util.SetRouteResponse: Return: ' || l_return_status ) ;
3172: END IF ;
3173:
3174:
3175: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3176:
3177: -- set result
3178: result := 'COMPLETE';
3179:
3186:
3187: ELSE
3188:
3189: -- Unexpected Exception
3190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3191:
3192: END IF ;
3193:
3194:
3206: , x_return_status => l_return_status
3207: ) ;
3208:
3209:
3210: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3211:
3212: -- set result
3213: result := 'COMPLETE';
3214:
3220:
3221: ELSE
3222:
3223: -- Unexpected Exception
3224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3225:
3226: END IF ;
3227: */
3228:
3276: return;
3277:
3278: EXCEPTION
3279:
3280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3281:
3282: IF l_debug_flag THEN
3283: Eng_Workflow_Util.Close_Debug_Session ;
3284: END IF ;
3419: Eng_Workflow_Util.Write_Debug('after calling Eng_Workflow_Util.StartNextRouteStep. . . ' ) ;
3420: END IF ;
3421:
3422:
3423: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3424:
3425:
3426: IF l_debug_flag THEN
3427: Eng_Workflow_Util.Write_Debug('Set route step id. ' || to_char(l_route_step_id) ) ;
3444: return;
3445: ELSE
3446:
3447: -- Unexpected Exception
3448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3449:
3450: END IF ;
3451:
3452: end if ; -- funcmode : RUN
3477: return;
3478:
3479: EXCEPTION
3480:
3481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3482: -- The line below records this function call in the error system
3483: -- in the case of an exception.
3484: wf_core.context('Eng_Workflow_Pub', 'START_ROUTE_STEP',
3485: itemtype, itemkey, to_char(actid), funcmode);
3612: , x_line_approval_status => l_line_approval_status
3613: ) ;
3614:
3615:
3616: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3617:
3618: -- set result
3619: result := 'COMPLETE:' || l_line_approval_status ;
3620: return;
3621:
3622: ELSE
3623:
3624: -- Unexpected Exception
3625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3626:
3627: END IF ;
3628:
3629: end if ; -- funcmode : RUN
3653: result := '';
3654: return;
3655:
3656: EXCEPTION
3657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3658: -- The line below records this function call in the error system
3659: -- in the case of an exception.
3660: wf_core.context('Eng_Workflow_Pub', 'CHECK_LINE_APPROVALS',
3661: itemtype, itemkey, to_char(actid), funcmode);
3718:
3719:
3720:
3721: IF l_route_step_id IS NOT NULL AND
3722: l_return_status = FND_API.G_RET_STS_SUCCESS
3723: THEN
3724:
3725: -- set result
3726: result := 'COMPLETE:' || FND_API.G_TRUE;
3722: l_return_status = FND_API.G_RET_STS_SUCCESS
3723: THEN
3724:
3725: -- set result
3726: result := 'COMPLETE:' || FND_API.G_TRUE;
3727: return;
3728:
3729: ELSIF l_route_step_id IS NULL AND
3730: l_return_status = FND_API.G_RET_STS_SUCCESS
3726: result := 'COMPLETE:' || FND_API.G_TRUE;
3727: return;
3728:
3729: ELSIF l_route_step_id IS NULL AND
3730: l_return_status = FND_API.G_RET_STS_SUCCESS
3731: THEN
3732:
3733: -- set result
3734: result := 'COMPLETE:' || FND_API.G_FALSE;
3730: l_return_status = FND_API.G_RET_STS_SUCCESS
3731: THEN
3732:
3733: -- set result
3734: result := 'COMPLETE:' || FND_API.G_FALSE;
3735: return;
3736:
3737: ELSE
3738:
3736:
3737: ELSE
3738:
3739: -- Unexpected Exception
3740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3741:
3742: END IF ;
3743:
3744:
3769: result := '';
3770: return;
3771:
3772: EXCEPTION
3773: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3774: -- The line below records this function call in the error system
3775: -- in the case of an exception.
3776: wf_core.context('Eng_Workflow_Pub', 'FIND_WAITING_STEP',
3777: itemtype, itemkey, to_char(actid), funcmode);
3904: -- , p_sync_lines => 1 -- Set sync mode: True
3905: -- , p_new_appr_status_type => Eng_Workflow_Util.G_APPROVED
3906: -- ) ;
3907:
3908: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3909:
3910: -- Unexpected Exception
3911: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3912:
3907:
3908: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3909:
3910: -- Unexpected Exception
3911: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3912:
3913: -- END IF ;
3914: **************************************************/
3915:
3932: , x_action_id => l_action_id
3933: ) ;
3934:
3935:
3936: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3937:
3938: -- set result
3939: result := 'COMPLETE';
3940: return;
3941:
3942: ELSE
3943:
3944: -- Unexpected Exception
3945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3946:
3947: END IF ;
3948:
3949: END IF ;
3976: return;
3977:
3978: EXCEPTION
3979:
3980: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3981: -- The line below records this function call in the error system
3982: -- in the case of an exception.
3983: wf_core.context('Eng_Workflow_Pub', 'ROUTE_APPROVE_CHANGE',
3984: itemtype, itemkey, to_char(actid), funcmode);
4085: -- , p_new_appr_status_type => Eng_Workflow_Util.G_REJECTED
4086: -- ) ;
4087:
4088:
4089: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4090:
4091: -- Unexpected Exception
4092: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4093:
4088:
4089: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4090:
4091: -- Unexpected Exception
4092: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4093:
4094: -- END IF ;
4095: *************************************************/
4096:
4120: , p_comment => NULL
4121: , x_action_id => l_action_id
4122: ) ;
4123:
4124: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4125:
4126: -- set result
4127: result := 'COMPLETE';
4128: return;
4129:
4130: ELSE
4131:
4132: -- Unexpected Exception
4133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4134:
4135: END IF ;
4136:
4137: END IF ;
4164: return;
4165:
4166: EXCEPTION
4167:
4168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4169: -- The line below records this function call in the error system
4170: -- in the case of an exception.
4171: wf_core.context('Eng_Workflow_Pub', 'ROUTE_REJECT_CHANGE',
4172: itemtype, itemkey, to_char(actid), funcmode);
4272: -- , p_wf_user_id => l_wf_user_id
4273: -- , p_new_appr_status_type => Eng_Workflow_Util.G_TIME_OUT
4274: -- ) ;
4275:
4276: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4277:
4278: -- Unexpected Exception
4279: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4280:
4275:
4276: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4277:
4278: -- Unexpected Exception
4279: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4280:
4281: -- END IF ;
4282: *************************************************/
4283:
4308: , p_comment => NULL
4309: , x_action_id => l_action_id
4310: ) ;
4311:
4312: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4313:
4314: -- set result
4315: result := 'COMPLETE';
4316: return;
4317:
4318: ELSE
4319:
4320: -- Unexpected Exception
4321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4322:
4323: END IF ;
4324:
4325: END IF ;
4352: return;
4353:
4354: EXCEPTION
4355:
4356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4357: -- The line below records this function call in the error system
4358: -- in the case of an exception.
4359: wf_core.context('Eng_Workflow_Pub', 'ROUTE_SET_TIMEOUT',
4360: itemtype, itemkey, to_char(actid), funcmode);
4800: , p_step_id => l_route_step_id
4801: ) ;
4802:
4803:
4804: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4805:
4806: result := 'COMPLETE';
4807: return;
4808:
4808:
4809: ELSE
4810:
4811: -- Unexpected Exception
4812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4813:
4814: END IF ;
4815:
4816: end if ; -- funcmode : RUN
4841: return;
4842:
4843: EXCEPTION
4844:
4845: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4846: -- The line below records this function call in the error system
4847: -- in the case of an exception.
4848: wf_core.context('Eng_Workflow_Pub', 'GRANT_ROLE_TO_STEP_PEOPLE',
4849: itemtype, itemkey, to_char(actid), funcmode);
4896: -- Check Definitions
4897: --
4898:
4899: -- By default alyways set result
4900: result := 'COMPLETE:' || FND_API.G_TRUE;
4901: return;
4902:
4903: -- Based on your result, you can launch another workflow
4904: -- and make this activity DEFFERED
4910: -- using wf_engine.CompleteActivity api
4911: --
4912: -- Or just return False
4913: -- set result
4914: -- result := 'COMPLETE:' || FND_API.G_FALSE;
4915: -- return;
4916: -- In this case you need to modify transition in workflow definition
4917: --
4918: --
4918: --
4919:
4920: -- For unexpeced exception
4921: -- Unexpected Exception
4922: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4923:
4924:
4925: end if ; -- funcmode : RUN
4926:
4949: result := '';
4950: return;
4951:
4952: EXCEPTION
4953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4954: -- The line below records this function call in the error system
4955: -- in the case of an exception.
4956: wf_core.context('Eng_Workflow_Pub', 'CHECK_DEFINITIONS',
4957: itemtype, itemkey, to_char(actid), funcmode);
5025: result := '';
5026: return;
5027:
5028: EXCEPTION
5029: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5030: -- The line below records this function call in the error system
5031: -- in the case of an exception.
5032: wf_core.context('Eng_Workflow_Pub', 'CHECK_ROUTE_OBJECT',
5033: itemtype, itemkey, to_char(actid), funcmode);
5084: , p_route_id => l_route_id
5085: , p_api_caller => Eng_Workflow_Util.G_WF_CALL
5086: ) ;
5087:
5088: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
5089:
5090: -- set result
5091: result := 'COMPLETE';
5092: return;
5093:
5094: ELSE
5095:
5096: -- Unexpected Exception
5097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5098:
5099: END IF ;
5100:
5101:
5126: result := '';
5127: return;
5128:
5129: EXCEPTION
5130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5131: -- The line below records this function call in the error system
5132: -- in the case of an exception.
5133: wf_core.context('Eng_Workflow_Pub', 'SYNC_CHANGE_LC_PHASE',
5134: itemtype, itemkey, to_char(actid), funcmode);
5232: result := '';
5233: return;
5234:
5235: EXCEPTION
5236: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5237: -- The line below records this function call in the error system
5238: -- in the case of an exception.
5239: wf_core.context('Eng_Workflow_Pub', 'CHECK_CHANGE_APPR_STATUS',
5240: itemtype, itemkey, to_char(actid), funcmode);
5329: result := '';
5330: return;
5331:
5332: EXCEPTION
5333: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5334: -- The line below records this function call in the error system
5335: -- in the case of an exception.
5336: wf_core.context('Eng_Workflow_Pub', 'CHECK_BASE_CM_TYPE_CODE',
5337: itemtype, itemkey, to_char(actid), funcmode);
5402: , p_wf_user_id => l_wf_user_id
5403: , p_api_caller => Eng_Workflow_Util.G_WF_CALL
5404: ) ;
5405:
5406: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
5407:
5408: -- set result
5409: result := 'COMPLETE';
5410: return;
5411:
5412: ELSE
5413:
5414: -- Unexpected Exception
5415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5416:
5417: END IF ;
5418:
5419:
5444: result := '';
5445: return;
5446:
5447: EXCEPTION
5448: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5449: -- The line below records this function call in the error system
5450: -- in the case of an exception.
5451: wf_core.context('Eng_Workflow_Pub', 'SET_CO_MRP_FLAG_ACTIVE',
5452: itemtype, itemkey, to_char(actid), funcmode);
5516: , p_wf_user_id => l_wf_user_id
5517: , p_api_caller => Eng_Workflow_Util.G_WF_CALL
5518: ) ;
5519:
5520: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
5521:
5522: -- set result
5523: result := 'COMPLETE';
5524: return;
5525:
5526: ELSE
5527:
5528: -- Unexpected Exception
5529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5530:
5531: END IF ;
5532:
5533:
5558: result := '';
5559: return;
5560:
5561: EXCEPTION
5562: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5563: -- The line below records this function call in the error system
5564: -- in the case of an exception.
5565: wf_core.context('Eng_Workflow_Pub', 'SET_CO_MRP_FLAG_INACTIVE',
5566: itemtype, itemkey, to_char(actid), funcmode);
5609:
5610: -- Get WF Admin Statuss Monigor URL
5611: Eng_Workflow_Util.GetWorkflowMonitorURL
5612: ( p_api_version => 1.0
5613: , p_init_msg_list => FND_API.G_FALSE
5614: , p_commit => FND_API.G_FALSE
5615: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
5616: , x_return_status => l_return_status
5617: , x_msg_count => l_msg_count
5610: -- Get WF Admin Statuss Monigor URL
5611: Eng_Workflow_Util.GetWorkflowMonitorURL
5612: ( p_api_version => 1.0
5613: , p_init_msg_list => FND_API.G_FALSE
5614: , p_commit => FND_API.G_FALSE
5615: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
5616: , x_return_status => l_return_status
5617: , x_msg_count => l_msg_count
5618: , x_msg_data => l_msg_data
5611: Eng_Workflow_Util.GetWorkflowMonitorURL
5612: ( p_api_version => 1.0
5613: , p_init_msg_list => FND_API.G_FALSE
5614: , p_commit => FND_API.G_FALSE
5615: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
5616: , x_return_status => l_return_status
5617: , x_msg_count => l_msg_count
5618: , x_msg_data => l_msg_data
5619: , p_item_type => itemtype
5618: , x_msg_data => l_msg_data
5619: , p_item_type => itemtype
5620: , p_item_key => itemkey
5621: , p_url_type => Eng_Workflow_Util.G_MONITOR_ADVANCED_ENVELOPE
5622: , p_admin_mode => FND_API.G_TRUE
5623: -- , p_admin_mode => FND_API.G_FALSE
5624: , p_option => 'ALL'
5625: , x_url => l_url
5626: ) ;
5619: , p_item_type => itemtype
5620: , p_item_key => itemkey
5621: , p_url_type => Eng_Workflow_Util.G_MONITOR_ADVANCED_ENVELOPE
5622: , p_admin_mode => FND_API.G_TRUE
5623: -- , p_admin_mode => FND_API.G_FALSE
5624: , p_option => 'ALL'
5625: , x_url => l_url
5626: ) ;
5627:
5625: , x_url => l_url
5626: ) ;
5627:
5628:
5629: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
5630:
5631: -- for Notification
5632: WF_ENGINE.SetItemAttrText( itemtype
5633: , itemkey
5641:
5642: ELSE
5643:
5644: -- Unexpected Exception
5645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5646:
5647: END IF ;
5648:
5649:
5674: result := '';
5675: return;
5676:
5677: EXCEPTION
5678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5679: -- The line below records this function call in the error system
5680: -- in the case of an exception.
5681: wf_core.context('Eng_Workflow_Pub', 'SET_ADMIN_STATUS_MONITOR_URL',
5682: itemtype, itemkey, to_char(actid), funcmode);
5971: result := '';
5972: return;
5973:
5974: EXCEPTION
5975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5976: -- The line below records this function call in the error system
5977: -- in the case of an exception.
5978: wf_core.context('Eng_Workflow_Pub', 'SET_EVENT_CHANGE_OBJECT_INFO',
5979: itemtype, itemkey, to_char(actid), funcmode);
6084: Eng_Workflow_Util.Write_Debug('Result : ' || result ) ;
6085: END IF ;
6086:
6087:
6088: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6089:
6090: IF l_debug_flag THEN
6091: Eng_Workflow_Util.Close_Debug_Session ;
6092: END IF ;
6091: Eng_Workflow_Util.Close_Debug_Session ;
6092: END IF ;
6093:
6094: -- Unexpected Exception
6095: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
6096:
6097: END IF ;
6098:
6099: IF l_debug_flag THEN
6204: , p_continuation_flow_type => NVL(l_continuation_flow_type, 'APPROVAL')
6205: , x_resultout => result
6206: ) ;
6207:
6208: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6209:
6210: -- Unexpected Exception
6211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
6212:
6207:
6208: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6209:
6210: -- Unexpected Exception
6211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
6212:
6213: END IF ;
6214:
6215: -- result is set by WaitForLineRoute util api
6242: return;
6243:
6244: EXCEPTION
6245:
6246: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6247: -- The line below records this function call in the error system
6248: -- in the case of an exception.
6249: wf_core.context('Eng_Workflow_Pub', 'WAIT_FOR_LINE_ROUTE',
6250: itemtype, itemkey, to_char(actid), funcmode);