[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);
1728: , p_item_key => itemkey
1729: , p_notification_id => WF_ENGINE.context_nid
1730: , p_action_type => Eng_Workflow_Util.G_ACT_REPLIED
1731: , x_action_id => l_created_action_id
1732: , p_raise_event_flag => FND_API.G_TRUE -- R12
1733: ) ;
1734:
1735:
1736: IF l_debug_flag THEN
1737: Eng_Workflow_Util.Write_Debug('After call Eng_Workflow_Util.CreateAction: Return: ' || l_return_status ) ;
1738: END IF ;
1739:
1740:
1741: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1742:
1743: -- Unexpected Exception
1744: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1745:
1740:
1741: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1742:
1743: -- Unexpected Exception
1744: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1745:
1746: END IF ;
1747:
1748:
1760: , x_return_status => l_return_status
1761: ) ;
1762:
1763:
1764: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1765:
1766: -- set result
1767: result := 'COMPLETE';
1768:
1774:
1775: ELSE
1776:
1777: -- Unexpected Exception
1778: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1779:
1780: END IF ;
1781:
1782:
1822: return;
1823:
1824: EXCEPTION
1825:
1826: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1827:
1828: IF l_debug_flag THEN
1829: Eng_Workflow_Util.Close_Debug_Session ;
1830: END IF ;
1966: Eng_Workflow_Util.Write_Debug('After call Eng_Workflow_Util.SetRouteResponse: Return: ' || l_return_status ) ;
1967: END IF ;
1968:
1969:
1970: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1971:
1972: -- set result
1973: result := 'COMPLETE';
1974:
1980:
1981: ELSE
1982:
1983: -- Unexpected Exception
1984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1985:
1986: END IF ;
1987:
1988:
2037: return;
2038:
2039: EXCEPTION
2040:
2041: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2042:
2043: IF l_debug_flag THEN
2044: Eng_Workflow_Util.Close_Debug_Session ;
2045: END IF ;
2175: Eng_Workflow_Util.Write_Debug('After call Eng_Workflow_Util.SetRouteResponse: Return: ' || l_return_status ) ;
2176: END IF ;
2177:
2178:
2179: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2180:
2181: -- set result
2182: result := 'COMPLETE';
2183:
2190:
2191: ELSE
2192:
2193: -- Unexpected Exception
2194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2195:
2196: END IF ;
2197:
2198:
2210: , x_return_status => l_return_status
2211: ) ;
2212:
2213:
2214: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2215:
2216: -- set result
2217: result := 'COMPLETE';
2218:
2224:
2225: ELSE
2226:
2227: -- Unexpected Exception
2228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2229:
2230: END IF ;
2231: */
2232:
2280: return;
2281:
2282: EXCEPTION
2283:
2284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2285:
2286: IF l_debug_flag THEN
2287: Eng_Workflow_Util.Close_Debug_Session ;
2288: END IF ;
2429: IF l_debug_flag THEN
2430: Eng_Workflow_Util.Write_Debug('After call Eng_Workflow_Util.SetRouteResponse: Return: ' || l_return_status ) ;
2431: END IF ;
2432:
2433: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2434: -- Unexpected Exception
2435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2436:
2437: END IF ;
2431: END IF ;
2432:
2433: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2434: -- Unexpected Exception
2435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2436:
2437: END IF ;
2438:
2439:
2489: -- , p_orig_response => l_response_code
2490: -- ) ;
2491: --
2492:
2493: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2494:
2495: -- set result
2496: result := 'COMPLETE';
2497:
2503:
2504: ELSE
2505:
2506: -- Unexpected Exception
2507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2508:
2509: END IF ;
2510:
2511:
2561:
2562:
2563: EXCEPTION
2564:
2565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2566:
2567: IF l_debug_flag THEN
2568: Eng_Workflow_Util.Close_Debug_Session ;
2569: END IF ;
2710: IF l_debug_flag THEN
2711: Eng_Workflow_Util.Write_Debug('After call Eng_Workflow_Util.SetRouteResponse: Return: ' || l_return_status ) ;
2712: END IF ;
2713:
2714: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2715: -- Unexpected Exception
2716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2717:
2718: END IF ;
2712: END IF ;
2713:
2714: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2715: -- Unexpected Exception
2716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2717:
2718: END IF ;
2719:
2720:
2779:
2780:
2781: END IF ;
2782:
2783: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2784:
2785: -- set result
2786: result := 'COMPLETE';
2787:
2793:
2794: ELSE
2795:
2796: -- Unexpected Exception
2797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2798:
2799: END IF ;
2800:
2801: end if;
2848: return;
2849:
2850: EXCEPTION
2851:
2852: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2853:
2854: IF l_debug_flag THEN
2855: Eng_Workflow_Util.Close_Debug_Session ;
2856: END IF ;
2963: , aname => 'RESULT'
2964: );
2965:
2966:
2967: l_return_status := FND_API.G_RET_STS_SUCCESS ;
2968:
2969: --
2970: -- Put business logic here in future
2971: --
2970: -- Put business logic here in future
2971: --
2972:
2973:
2974: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2975:
2976: -- set result
2977: result := 'COMPLETE';
2978:
2984: return;
2985:
2986: ELSE
2987: -- Unexpected Exception
2988: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2989:
2990: END IF ;
2991:
2992:
3019: return;
3020:
3021: EXCEPTION
3022:
3023: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3024:
3025: IF l_debug_flag THEN
3026: Eng_Workflow_Util.Close_Debug_Session ;
3027: END IF ;
3158: Eng_Workflow_Util.Write_Debug('After call Eng_Workflow_Util.SetRouteResponse: Return: ' || l_return_status ) ;
3159: END IF ;
3160:
3161:
3162: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3163:
3164: -- set result
3165: result := 'COMPLETE';
3166:
3173:
3174: ELSE
3175:
3176: -- Unexpected Exception
3177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3178:
3179: END IF ;
3180:
3181:
3193: , x_return_status => l_return_status
3194: ) ;
3195:
3196:
3197: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3198:
3199: -- set result
3200: result := 'COMPLETE';
3201:
3207:
3208: ELSE
3209:
3210: -- Unexpected Exception
3211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3212:
3213: END IF ;
3214: */
3215:
3263: return;
3264:
3265: EXCEPTION
3266:
3267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3268:
3269: IF l_debug_flag THEN
3270: Eng_Workflow_Util.Close_Debug_Session ;
3271: END IF ;
3406: Eng_Workflow_Util.Write_Debug('after calling Eng_Workflow_Util.StartNextRouteStep. . . ' ) ;
3407: END IF ;
3408:
3409:
3410: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3411:
3412:
3413: IF l_debug_flag THEN
3414: Eng_Workflow_Util.Write_Debug('Set route step id. ' || to_char(l_route_step_id) ) ;
3431: return;
3432: ELSE
3433:
3434: -- Unexpected Exception
3435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3436:
3437: END IF ;
3438:
3439: end if ; -- funcmode : RUN
3464: return;
3465:
3466: EXCEPTION
3467:
3468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3469: -- The line below records this function call in the error system
3470: -- in the case of an exception.
3471: wf_core.context('Eng_Workflow_Pub', 'START_ROUTE_STEP',
3472: itemtype, itemkey, to_char(actid), funcmode);
3599: , x_line_approval_status => l_line_approval_status
3600: ) ;
3601:
3602:
3603: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3604:
3605: -- set result
3606: result := 'COMPLETE:' || l_line_approval_status ;
3607: return;
3608:
3609: ELSE
3610:
3611: -- Unexpected Exception
3612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3613:
3614: END IF ;
3615:
3616: end if ; -- funcmode : RUN
3640: result := '';
3641: return;
3642:
3643: EXCEPTION
3644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3645: -- The line below records this function call in the error system
3646: -- in the case of an exception.
3647: wf_core.context('Eng_Workflow_Pub', 'CHECK_LINE_APPROVALS',
3648: itemtype, itemkey, to_char(actid), funcmode);
3705:
3706:
3707:
3708: IF l_route_step_id IS NOT NULL AND
3709: l_return_status = FND_API.G_RET_STS_SUCCESS
3710: THEN
3711:
3712: -- set result
3713: result := 'COMPLETE:' || FND_API.G_TRUE;
3709: l_return_status = FND_API.G_RET_STS_SUCCESS
3710: THEN
3711:
3712: -- set result
3713: result := 'COMPLETE:' || FND_API.G_TRUE;
3714: return;
3715:
3716: ELSIF l_route_step_id IS NULL AND
3717: l_return_status = FND_API.G_RET_STS_SUCCESS
3713: result := 'COMPLETE:' || FND_API.G_TRUE;
3714: return;
3715:
3716: ELSIF l_route_step_id IS NULL AND
3717: l_return_status = FND_API.G_RET_STS_SUCCESS
3718: THEN
3719:
3720: -- set result
3721: result := 'COMPLETE:' || FND_API.G_FALSE;
3717: l_return_status = FND_API.G_RET_STS_SUCCESS
3718: THEN
3719:
3720: -- set result
3721: result := 'COMPLETE:' || FND_API.G_FALSE;
3722: return;
3723:
3724: ELSE
3725:
3723:
3724: ELSE
3725:
3726: -- Unexpected Exception
3727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3728:
3729: END IF ;
3730:
3731:
3756: result := '';
3757: return;
3758:
3759: EXCEPTION
3760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3761: -- The line below records this function call in the error system
3762: -- in the case of an exception.
3763: wf_core.context('Eng_Workflow_Pub', 'FIND_WAITING_STEP',
3764: itemtype, itemkey, to_char(actid), funcmode);
3891: -- , p_sync_lines => 1 -- Set sync mode: True
3892: -- , p_new_appr_status_type => Eng_Workflow_Util.G_APPROVED
3893: -- ) ;
3894:
3895: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3896:
3897: -- Unexpected Exception
3898: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3899:
3894:
3895: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3896:
3897: -- Unexpected Exception
3898: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3899:
3900: -- END IF ;
3901: **************************************************/
3902:
3919: , x_action_id => l_action_id
3920: ) ;
3921:
3922:
3923: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3924:
3925: -- set result
3926: result := 'COMPLETE';
3927: return;
3928:
3929: ELSE
3930:
3931: -- Unexpected Exception
3932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3933:
3934: END IF ;
3935:
3936: END IF ;
3963: return;
3964:
3965: EXCEPTION
3966:
3967: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3968: -- The line below records this function call in the error system
3969: -- in the case of an exception.
3970: wf_core.context('Eng_Workflow_Pub', 'ROUTE_APPROVE_CHANGE',
3971: itemtype, itemkey, to_char(actid), funcmode);
4072: -- , p_new_appr_status_type => Eng_Workflow_Util.G_REJECTED
4073: -- ) ;
4074:
4075:
4076: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4077:
4078: -- Unexpected Exception
4079: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4080:
4075:
4076: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4077:
4078: -- Unexpected Exception
4079: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4080:
4081: -- END IF ;
4082: *************************************************/
4083:
4107: , p_comment => NULL
4108: , x_action_id => l_action_id
4109: ) ;
4110:
4111: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4112:
4113: -- set result
4114: result := 'COMPLETE';
4115: return;
4116:
4117: ELSE
4118:
4119: -- Unexpected Exception
4120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4121:
4122: END IF ;
4123:
4124: END IF ;
4151: return;
4152:
4153: EXCEPTION
4154:
4155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4156: -- The line below records this function call in the error system
4157: -- in the case of an exception.
4158: wf_core.context('Eng_Workflow_Pub', 'ROUTE_REJECT_CHANGE',
4159: itemtype, itemkey, to_char(actid), funcmode);
4259: -- , p_wf_user_id => l_wf_user_id
4260: -- , p_new_appr_status_type => Eng_Workflow_Util.G_TIME_OUT
4261: -- ) ;
4262:
4263: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4264:
4265: -- Unexpected Exception
4266: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4267:
4262:
4263: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4264:
4265: -- Unexpected Exception
4266: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4267:
4268: -- END IF ;
4269: *************************************************/
4270:
4295: , p_comment => NULL
4296: , x_action_id => l_action_id
4297: ) ;
4298:
4299: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4300:
4301: -- set result
4302: result := 'COMPLETE';
4303: return;
4304:
4305: ELSE
4306:
4307: -- Unexpected Exception
4308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4309:
4310: END IF ;
4311:
4312: END IF ;
4339: return;
4340:
4341: EXCEPTION
4342:
4343: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4344: -- The line below records this function call in the error system
4345: -- in the case of an exception.
4346: wf_core.context('Eng_Workflow_Pub', 'ROUTE_SET_TIMEOUT',
4347: itemtype, itemkey, to_char(actid), funcmode);
4787: , p_step_id => l_route_step_id
4788: ) ;
4789:
4790:
4791: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4792:
4793: result := 'COMPLETE';
4794: return;
4795:
4795:
4796: ELSE
4797:
4798: -- Unexpected Exception
4799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4800:
4801: END IF ;
4802:
4803: end if ; -- funcmode : RUN
4828: return;
4829:
4830: EXCEPTION
4831:
4832: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4833: -- The line below records this function call in the error system
4834: -- in the case of an exception.
4835: wf_core.context('Eng_Workflow_Pub', 'GRANT_ROLE_TO_STEP_PEOPLE',
4836: itemtype, itemkey, to_char(actid), funcmode);
4883: -- Check Definitions
4884: --
4885:
4886: -- By default alyways set result
4887: result := 'COMPLETE:' || FND_API.G_TRUE;
4888: return;
4889:
4890: -- Based on your result, you can launch another workflow
4891: -- and make this activity DEFFERED
4897: -- using wf_engine.CompleteActivity api
4898: --
4899: -- Or just return False
4900: -- set result
4901: -- result := 'COMPLETE:' || FND_API.G_FALSE;
4902: -- return;
4903: -- In this case you need to modify transition in workflow definition
4904: --
4905: --
4905: --
4906:
4907: -- For unexpeced exception
4908: -- Unexpected Exception
4909: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4910:
4911:
4912: end if ; -- funcmode : RUN
4913:
4936: result := '';
4937: return;
4938:
4939: EXCEPTION
4940: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4941: -- The line below records this function call in the error system
4942: -- in the case of an exception.
4943: wf_core.context('Eng_Workflow_Pub', 'CHECK_DEFINITIONS',
4944: itemtype, itemkey, to_char(actid), funcmode);
5012: result := '';
5013: return;
5014:
5015: EXCEPTION
5016: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5017: -- The line below records this function call in the error system
5018: -- in the case of an exception.
5019: wf_core.context('Eng_Workflow_Pub', 'CHECK_ROUTE_OBJECT',
5020: itemtype, itemkey, to_char(actid), funcmode);
5071: , p_route_id => l_route_id
5072: , p_api_caller => Eng_Workflow_Util.G_WF_CALL
5073: ) ;
5074:
5075: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
5076:
5077: -- set result
5078: result := 'COMPLETE';
5079: return;
5080:
5081: ELSE
5082:
5083: -- Unexpected Exception
5084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5085:
5086: END IF ;
5087:
5088:
5113: result := '';
5114: return;
5115:
5116: EXCEPTION
5117: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5118: -- The line below records this function call in the error system
5119: -- in the case of an exception.
5120: wf_core.context('Eng_Workflow_Pub', 'SYNC_CHANGE_LC_PHASE',
5121: itemtype, itemkey, to_char(actid), funcmode);
5219: result := '';
5220: return;
5221:
5222: EXCEPTION
5223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5224: -- The line below records this function call in the error system
5225: -- in the case of an exception.
5226: wf_core.context('Eng_Workflow_Pub', 'CHECK_CHANGE_APPR_STATUS',
5227: itemtype, itemkey, to_char(actid), funcmode);
5316: result := '';
5317: return;
5318:
5319: EXCEPTION
5320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5321: -- The line below records this function call in the error system
5322: -- in the case of an exception.
5323: wf_core.context('Eng_Workflow_Pub', 'CHECK_BASE_CM_TYPE_CODE',
5324: itemtype, itemkey, to_char(actid), funcmode);
5389: , p_wf_user_id => l_wf_user_id
5390: , p_api_caller => Eng_Workflow_Util.G_WF_CALL
5391: ) ;
5392:
5393: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
5394:
5395: -- set result
5396: result := 'COMPLETE';
5397: return;
5398:
5399: ELSE
5400:
5401: -- Unexpected Exception
5402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5403:
5404: END IF ;
5405:
5406:
5431: result := '';
5432: return;
5433:
5434: EXCEPTION
5435: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5436: -- The line below records this function call in the error system
5437: -- in the case of an exception.
5438: wf_core.context('Eng_Workflow_Pub', 'SET_CO_MRP_FLAG_ACTIVE',
5439: itemtype, itemkey, to_char(actid), funcmode);
5503: , p_wf_user_id => l_wf_user_id
5504: , p_api_caller => Eng_Workflow_Util.G_WF_CALL
5505: ) ;
5506:
5507: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
5508:
5509: -- set result
5510: result := 'COMPLETE';
5511: return;
5512:
5513: ELSE
5514:
5515: -- Unexpected Exception
5516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5517:
5518: END IF ;
5519:
5520:
5545: result := '';
5546: return;
5547:
5548: EXCEPTION
5549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5550: -- The line below records this function call in the error system
5551: -- in the case of an exception.
5552: wf_core.context('Eng_Workflow_Pub', 'SET_CO_MRP_FLAG_INACTIVE',
5553: itemtype, itemkey, to_char(actid), funcmode);
5596:
5597: -- Get WF Admin Statuss Monigor URL
5598: Eng_Workflow_Util.GetWorkflowMonitorURL
5599: ( p_api_version => 1.0
5600: , p_init_msg_list => FND_API.G_FALSE
5601: , p_commit => FND_API.G_FALSE
5602: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
5603: , x_return_status => l_return_status
5604: , x_msg_count => l_msg_count
5597: -- Get WF Admin Statuss Monigor URL
5598: Eng_Workflow_Util.GetWorkflowMonitorURL
5599: ( p_api_version => 1.0
5600: , p_init_msg_list => FND_API.G_FALSE
5601: , p_commit => FND_API.G_FALSE
5602: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
5603: , x_return_status => l_return_status
5604: , x_msg_count => l_msg_count
5605: , x_msg_data => l_msg_data
5598: Eng_Workflow_Util.GetWorkflowMonitorURL
5599: ( p_api_version => 1.0
5600: , p_init_msg_list => FND_API.G_FALSE
5601: , p_commit => FND_API.G_FALSE
5602: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
5603: , x_return_status => l_return_status
5604: , x_msg_count => l_msg_count
5605: , x_msg_data => l_msg_data
5606: , p_item_type => itemtype
5605: , x_msg_data => l_msg_data
5606: , p_item_type => itemtype
5607: , p_item_key => itemkey
5608: , p_url_type => Eng_Workflow_Util.G_MONITOR_ADVANCED_ENVELOPE
5609: , p_admin_mode => FND_API.G_TRUE
5610: -- , p_admin_mode => FND_API.G_FALSE
5611: , p_option => 'ALL'
5612: , x_url => l_url
5613: ) ;
5606: , p_item_type => itemtype
5607: , p_item_key => itemkey
5608: , p_url_type => Eng_Workflow_Util.G_MONITOR_ADVANCED_ENVELOPE
5609: , p_admin_mode => FND_API.G_TRUE
5610: -- , p_admin_mode => FND_API.G_FALSE
5611: , p_option => 'ALL'
5612: , x_url => l_url
5613: ) ;
5614:
5612: , x_url => l_url
5613: ) ;
5614:
5615:
5616: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
5617:
5618: -- for Notification
5619: WF_ENGINE.SetItemAttrText( itemtype
5620: , itemkey
5628:
5629: ELSE
5630:
5631: -- Unexpected Exception
5632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5633:
5634: END IF ;
5635:
5636:
5661: result := '';
5662: return;
5663:
5664: EXCEPTION
5665: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5666: -- The line below records this function call in the error system
5667: -- in the case of an exception.
5668: wf_core.context('Eng_Workflow_Pub', 'SET_ADMIN_STATUS_MONITOR_URL',
5669: itemtype, itemkey, to_char(actid), funcmode);
5958: result := '';
5959: return;
5960:
5961: EXCEPTION
5962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5963: -- The line below records this function call in the error system
5964: -- in the case of an exception.
5965: wf_core.context('Eng_Workflow_Pub', 'SET_EVENT_CHANGE_OBJECT_INFO',
5966: itemtype, itemkey, to_char(actid), funcmode);
6071: Eng_Workflow_Util.Write_Debug('Result : ' || result ) ;
6072: END IF ;
6073:
6074:
6075: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6076:
6077: IF l_debug_flag THEN
6078: Eng_Workflow_Util.Close_Debug_Session ;
6079: END IF ;
6078: Eng_Workflow_Util.Close_Debug_Session ;
6079: END IF ;
6080:
6081: -- Unexpected Exception
6082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
6083:
6084: END IF ;
6085:
6086: IF l_debug_flag THEN
6191: , p_continuation_flow_type => NVL(l_continuation_flow_type, 'APPROVAL')
6192: , x_resultout => result
6193: ) ;
6194:
6195: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6196:
6197: -- Unexpected Exception
6198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
6199:
6194:
6195: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6196:
6197: -- Unexpected Exception
6198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
6199:
6200: END IF ;
6201:
6202: -- result is set by WaitForLineRoute util api
6229: return;
6230:
6231: EXCEPTION
6232:
6233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6234: -- The line below records this function call in the error system
6235: -- in the case of an exception.
6236: wf_core.context('Eng_Workflow_Pub', 'WAIT_FOR_LINE_ROUTE',
6237: itemtype, itemkey, to_char(actid), funcmode);