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.OE_APPROVALS_WF dependencies on OE_APPROVALS_WF

Line 1: PACKAGE BODY OE_APPROVALS_WF AS

1: PACKAGE BODY OE_APPROVALS_WF AS
2: /* $Header: OEXWAPRB.pls 120.6.12020000.8 2013/03/25 08:54:53 spothula ship $ */
3:
4: -- Start of Comments
5: -- API name OE_APPROVALS_WF

Line 5: -- API name OE_APPROVALS_WF

1: PACKAGE BODY OE_APPROVALS_WF AS
2: /* $Header: OEXWAPRB.pls 120.6.12020000.8 2013/03/25 08:54:53 spothula ship $ */
3:
4: -- Start of Comments
5: -- API name OE_APPROVALS_WF
6: -- Type Public
7: -- Version Current version = 1.0
8: -- Initial version = 1.0
9:

Line 279: wf_core.context('OE_APPROVALS_WF', 'Initiate_Approval',

275: exception
276: when others then
277: -- The line below records this function call in the error system
278: -- in the case of an exception.
279: wf_core.context('OE_APPROVALS_WF', 'Initiate_Approval',
280: itemtype, itemkey, to_char(actid), funcmode);
281: -- start data fix project
282: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
283: p_itemtype => itemtype,

Line 499: wf_core.context('OE_APPROVALS_WF', 'Get_Next_Approver',

495: exception
496: when others then
497: -- The line below records this function call in the error system
498: -- in the case of an exception.
499: wf_core.context('OE_APPROVALS_WF', 'Get_Next_Approver',
500: itemtype, itemkey, to_char(actid), funcmode);
501: -- start data fix project
502: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
503: p_itemtype => itemtype,

Line 567: l_user_id := OE_APPROVALS_WF.get_user_id;

563: oe_debug_pub.add('Get_Next_Approver_internal', 1 ) ;
564: END IF;
565:
566: -- Get the User ID
567: l_user_id := OE_APPROVALS_WF.get_user_id;
568:
569: -- First get the transaction_type_id and the transaction_phase
570: -- We need to hit different table to find that out
571:

Line 850: wf_core.context('OE_APPROVALS_WF', 'Approve_Approval',

846: -- in the case of an exception.
847: IF l_debug_level > 0 THEN
848: oe_debug_pub.add('Exception in Reject_Approval.. ' ,1) ;
849: END IF;
850: wf_core.context('OE_APPROVALS_WF', 'Approve_Approval',
851: itemtype, itemkey, to_char(actid), funcmode);
852: -- start data fix project
853: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
854: p_itemtype => itemtype,

Line 982: wf_core.context('OE_APPROVALS_WF', 'Approval_Timeout',

978: -- in the case of an exception.
979: IF l_debug_level > 0 THEN
980: oe_debug_pub.add('Exception in Approval_Timeout.. ' ,1) ;
981: END IF;
982: wf_core.context('OE_APPROVALS_WF', 'Approval_Timeout',
983: itemtype, itemkey, to_char(actid), funcmode);
984: -- start data fix project
985: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
986: p_itemtype => itemtype,

Line 1124: wf_core.context('OE_APPROVALS_WF', 'Reject_Approval',

1120: -- in the case of an exception.
1121: IF l_debug_level > 0 THEN
1122: oe_debug_pub.add('Exception in Reject_Approval.. ' ,1) ;
1123: END IF;
1124: wf_core.context('OE_APPROVALS_WF', 'Reject_Approval',
1125: itemtype, itemkey, to_char(actid), funcmode);
1126: -- start data fix project
1127: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1128: p_itemtype => itemtype,

Line 2037: wf_core.CONTEXT ('OE_APPROVALS_WF',

2033: WHEN OTHERS
2034: THEN
2035: -- The line below records this function call in the error system
2036: -- in the case of an exception.
2037: wf_core.CONTEXT ('OE_APPROVALS_WF',
2038: 'get_ame_approvers_launch',
2039: itemtype,
2040: itemkey,
2041: TO_CHAR (actid),

Line 2096: wf_core.CONTEXT ('OE_Approvals_WF',

2092: END IF ;
2093: EXCEPTION
2094: WHEN OTHERS
2095: THEN
2096: wf_core.CONTEXT ('OE_Approvals_WF',
2097: 'is_ame_exception',
2098: itemtype,
2099: itemkey,
2100: TO_CHAR (actid),

Line 2151: wf_core.CONTEXT ('OE_Approvals_WF',

2147: THEN
2148: IF l_debug_level > 0 THEN
2149: oe_debug_pub.ADD ('error in check parallel wf status:' || SQLERRM);
2150: END IF ;
2151: wf_core.CONTEXT ('OE_Approvals_WF',
2152: 'check_parallel_wf_status',
2153: itemtype,
2154: itemkey,
2155: TO_CHAR (actid),

Line 2217: wf_core.CONTEXT ('OE_Approvals_WF',

2213: THEN
2214: IF l_debug_level > 0 THEN
2215: oe_debug_pub.ADD ('error in treat ame exceptions as:' || SQLERRM);
2216: END IF ;
2217: wf_core.CONTEXT ('OE_Approvals_WF',
2218: 'treat_ame_exception_as',
2219: itemtype,
2220: itemkey,
2221: TO_CHAR (actid),

Line 2248: oe_approvals_wf.g_ame_used := 'Y';

2244: THEN
2245: oe_debug_pub.ADD ('Entering get notification attributes');
2246: END IF;
2247:
2248: oe_approvals_wf.g_ame_used := 'Y';
2249:
2250: -- can add code in future if required. Leaving blank for now as we are already setting the attributes
2251: --from parent itself
2252: IF l_debug_level > 0

Line 2261: wf_core.CONTEXT ('OE_Approvals_WF',

2257: resultout := 'COMPLETE:NULL';
2258: EXCEPTION
2259: WHEN OTHERS
2260: THEN
2261: wf_core.CONTEXT ('OE_Approvals_WF',
2262: 'get_notification_attributes',
2263: itemtype,
2264: itemkey,
2265: TO_CHAR (actid),

Line 2586: wf_core.CONTEXT ('OE_Approvals_WF',

2582: IF l_debug_level > 0 THEN
2583: oe_debug_pub.ADD ('error in PROCESS_RESPONSE_APPROVE:' || SQLERRM);
2584: oe_debug_pub.ADD ('error in PROCESS_RESPONSE_APPROVE:' || SQLERRM);
2585: END IF ;
2586: wf_core.CONTEXT ('OE_Approvals_WF',
2587: 'process_response_approve',
2588: itemtype,
2589: itemkey,
2590: TO_CHAR (actid),

Line 2912: wf_core.CONTEXT ('OE_Approvals_WF',

2908: IF l_debug_level > 0 THEN
2909: oe_debug_pub.ADD ('error in PROCESS_RESPONSE_APPROVE:' || SQLERRM);
2910: oe_debug_pub.ADD ('error in PROCESS_RESPONSE_APPROVE:' || SQLERRM);
2911: END IF ;
2912: wf_core.CONTEXT ('OE_Approvals_WF',
2913: 'process_response_reject',
2914: itemtype,
2915: itemkey,
2916: TO_CHAR (actid),

Line 3275: wf_core.CONTEXT ('OE_Approvals_WF',

3271: THEN
3272: IF l_debug_level > 0 THEN
3273: oe_debug_pub.ADD ('error in Process_Beat_By_First:' || SQLERRM);
3274: END IF ;
3275: wf_core.CONTEXT ('OE_Approvals_WF',
3276: 'process_beat_by_first',
3277: itemtype,
3278: itemkey,
3279: TO_CHAR (actid),

Line 3366: oe_approvals_wf.g_ame_used := 'Y';

3362: resultout := 'COMPLETE:N';
3363: RETURN;
3364: ELSE
3365: resultout := 'COMPLETE:Y';
3366: oe_approvals_wf.g_ame_used := 'Y';
3367: IF l_debug_level > 0 THEN
3368: oe_debug_pub.ADD
3369: ('AME approval is used.check if the transaction is rejected in the past'
3370: );

Line 3425: wf_core.CONTEXT ('OE_Approvals_WF',

3421: END IF;
3422: EXCEPTION
3423: WHEN OTHERS
3424: THEN
3425: wf_core.CONTEXT ('OE_Approvals_WF',
3426: 'use_ame_approval',
3427: itemtype,
3428: itemkey,
3429: TO_CHAR (actid),

Line 3488: wf_core.CONTEXT ('OE_Approvals_WF',

3484: THEN
3485: IF l_debug_level > 0 THEN
3486: oe_debug_pub.ADD (SQLERRM);
3487: END IF ;
3488: wf_core.CONTEXT ('OE_Approvals_WF',
3489: 'push_block_activity',
3490: itemtype,
3491: itemkey,
3492: TO_CHAR (actid),

Line 3571: wf_core.CONTEXT ('OE_APPROVALS_WF',

3567: THEN
3568: oe_debug_pub.ADD ('Exception in Approval_Timeout.. ', 1);
3569: END IF;
3570:
3571: wf_core.CONTEXT ('OE_APPROVALS_WF',
3572: 'Approval_Timeout_AME',
3573: itemtype,
3574: itemkey,
3575: TO_CHAR (actid),

Line 3600: oe_debug_pub.ADD ('Entering oe_approvals_Wf.get_order_total');

3596: l_order_total NUMBER;
3597: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3598: BEGIN
3599: IF l_debug_level > 0 THEN
3600: oe_debug_pub.ADD ('Entering oe_approvals_Wf.get_order_total');
3601: END IF ;
3602: oe_oe_totals_summary.order_totals (p_header_id => p_header_id,
3603: p_subtotal => l_subtotal,
3604: p_discount => l_discount,

Line 3633: oe_debug_pub.ADD ('Entering oe_approvals_Wf.get_customer_category');

3629: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3630: BEGIN
3631: IF l_debug_level > 0
3632: THEN
3633: oe_debug_pub.ADD ('Entering oe_approvals_Wf.get_customer_category');
3634: END IF;
3635:
3636: if p_ame_type='OEBSA' THEN
3637: BEGIN

Line 3698: END OE_APPROVALS_WF;

3694: END get_customer_category;
3695:
3696:
3697:
3698: END OE_APPROVALS_WF;