DBA Data[Home] [Help]

APPS.ARP_CMREQ_WF dependencies on ARP_CMREQ_WF

Line 1: package body ARP_CMREQ_WF as

1: package body ARP_CMREQ_WF as
2: /* $Header: ARWCMWFB.pls 120.26 2011/09/22 02:32:36 chuansha ship $ */
3: --
4: --
5: -- IN

Line 112: pkg_name => 'ARP_CMREQ_WF',

108: EXCEPTION
109: WHEN OTHERS THEN
110:
111: wf_core.context(
112: pkg_name => 'ARP_CMREQ_WF',
113: proc_name => 'CALLBACK_ROUTINE',
114: arg1 => p_item_type,
115: arg2 => p_item_key,
116: arg3 => to_char(p_activity_id),

Line 406: wf_core.context('ARP_CMREQ_WF', 'FindTrx',

402: exception
403: when others then
404: -- The line below records this function call in the error system
405: -- in the case of an exception.
406: wf_core.context('ARP_CMREQ_WF', 'FindTrx',
407: p_item_type, p_item_key, to_char(p_actid), p_funcmode, l_debug_mesg);
408: raise;
409:
410: end FindTrx;

Line 539: wf_core.Context('ARP_CMREQ_WF', 'GetCustomerTrxInfo',

535: p_requestor_id := -1;
536: p_orig_trx_number := NULL;
537: p_tax_ex_cert_num := NULL;
538:
539: wf_core.Context('ARP_CMREQ_WF', 'GetCustomerTrxInfo',
540: null, null, null, l_debug_mesg);
541: raise;
542:
543: END GetCustomerTrxInfo;

Line 578: wf_core.Context('ARP_CMREQ_WF', 'GetTrxAmount',

574: p_original_freight_amount := NULL;
575: p_original_total := NULL;
576: p_currency_code := NULL;
577:
578: wf_core.Context('ARP_CMREQ_WF', 'GetTrxAmount',
579: null, null, null, l_debug_mesg);
580: raise;
581:
582: END GetTrxAmount;

Line 791: wf_core.context('ARP_CMREQ_WF', 'FindCustomer',

787: exception
788: when others then
789: -- The line below records this function call in the error system
790: -- in the case of an exception.
791: wf_core.context('ARP_CMREQ_WF', 'FindCustomer',
792: p_item_type, p_item_key, to_char(p_actid), p_funcmode);
793: raise;
794:
795: end FindCustomer;

Line 837: wf_core.Context('ARP_CMREQ_WF', 'FindCustomerInfo',

833: p_bill_to_customer_name := NULL;
834: p_bill_to_customer_number := NULL;
835:
836: WHEN OTHERS THEN
837: wf_core.Context('ARP_CMREQ_WF', 'FindCustomerInfo',
838: null, null, null, l_debug_mesg);
839: raise;
840: END;
841:

Line 863: wf_core.Context('ARP_CMREQ_WF', 'FindCustomerInfo',

859: p_ship_to_customer_name := NULL;
860: p_ship_to_customer_number := NULL;
861:
862: WHEN OTHERS THEN
863: wf_core.Context('ARP_CMREQ_WF', 'FindCustomerInfo',
864: null, null, null, l_debug_mesg);
865: raise;
866: END;
867:

Line 872: wf_core.Context('ARP_CMREQ_WF', 'FindCustomerInfo',

868:
869: EXCEPTION
870:
871: WHEN OTHERS THEN
872: wf_core.Context('ARP_CMREQ_WF', 'FindCustomerInfo',
873: null, null, null, l_debug_mesg);
874: raise;
875:
876:

Line 1023: wf_core.context('ARP_CMREQ_WF', 'FindCollector',

1019: exception
1020: when others then
1021: -- The line below records this function call in the error system
1022: -- in the case of an exception.
1023: wf_core.context('ARP_CMREQ_WF', 'FindCollector',
1024: p_item_type, p_item_key, to_char(p_actid), p_funcmode);
1025: raise;
1026:
1027: end FindCollector;

Line 1081: wf_core.Context('ARP_CMREQ_WF', 'FindCollectorInfo',

1077: p_collector_name := NULL ;
1078: END;
1079:
1080: WHEN OTHERS THEN
1081: wf_core.Context('ARP_CMREQ_WF', 'FindCollectorInfo',
1082: null, null, null, l_debug_mesg);
1083: raise;
1084:
1085: END FindCollectorInfo;

Line 1275: wf_core.context('ARP_CMREQ_WF', 'DefaultSendTo',

1271: exception
1272: when others then
1273: -- The line below records this function call in the error system
1274: -- in the case of an exception.
1275: wf_core.context('ARP_CMREQ_WF', 'DefaultSendTo',
1276: p_item_type, p_item_key, to_char(p_actid), p_funcmode);
1277: raise;
1278:
1279: end DefaultSendTo;

Line 1380: wf_core.context('ARP_CMREQ_WF', 'CheckPrimaryApprover',

1376: return;
1377: when others then
1378: -- The line below records this function call in the error system
1379: -- in the case of an exception.
1380: wf_core.context('ARP_CMREQ_WF', 'CheckPrimaryApprover',
1381: p_item_type, p_item_key, to_char(p_actid), p_funcmode);
1382: raise;
1383:
1384: end CheckPrimaryApprover;

Line 1527: wf_core.context('ARP_CMREQ_WF', 'FindPrimaryApprover',

1523: exception
1524: when others then
1525: -- The line below records this function call in the error system
1526: -- in the case of an exception.
1527: wf_core.context('ARP_CMREQ_WF', 'FindPrimaryApprover',
1528: p_item_type, p_item_key, to_char(p_actid), p_funcmode);
1529: raise;
1530:
1531: end FindPrimaryApprover;

Line 1616: wf_core.context('ARP_CMREQ_WF', 'FindNonPrimaryApprover',

1612: exception
1613: when others then
1614: -- The line below records this function call in the error system
1615: -- in the case of an exception.
1616: wf_core.context('ARP_CMREQ_WF', 'FindNonPrimaryApprover',
1617: p_item_type, p_item_key, to_char(p_actid), p_funcmode);
1618: raise;
1619:
1620: end FindNonPrimaryApprover;

Line 1736: wf_core.context('ARP_CMREQ_WF', 'FindNextNonPrimaryApprover',

1732: exception
1733: when others then
1734: -- The line below records this function call in the error system
1735: -- in the case of an exception.
1736: wf_core.context('ARP_CMREQ_WF', 'FindNextNonPrimaryApprover',
1737: p_item_type, p_item_key, to_char(p_actid), p_funcmode);
1738: raise;
1739:
1740: end FindNextNonPrimaryApprover;

Line 1770: wf_core.context('ARP_CMREQ_WF', 'CheckUserInHR',

1766: exception
1767: when others then
1768: -- The line below records this function call in the error system
1769: -- in the case of an exception.
1770: wf_core.context('ARP_CMREQ_WF', 'CheckUserInHR',
1771: null, null, null, l_debug_mesg);
1772: raise;
1773:
1774: end CheckUserInHR;

Line 1824: wf_core.context('ARP_CMREQ_WF', 'CheckUserInTable',

1820: exception
1821: when others then
1822: -- The line below records this function call in the error system
1823: -- in the case of an exception.
1824: wf_core.context('ARP_CMREQ_WF', 'CheckUserInTable',
1825: p_item_type, p_item_key, null, l_debug_mesg);
1826: raise;
1827:
1828: end CheckUserInTable;

Line 2037: Wf_Core.Context('ARP_CMREQ_WF', 'GetEmployeeInfo',

2033: end if;
2034:
2035: EXCEPTION
2036: WHEN OTHERS THEN
2037: Wf_Core.Context('ARP_CMREQ_WF', 'GetEmployeeInfo',
2038: p_item_type, p_item_key, null, l_debug_mesg);
2039: raise;
2040: END GetEmployeeInfo;
2041:

Line 2088: wf_core.Context('ARP_CMREQ_WF', 'GetUserInfoFromTable',

2084: p_user_name := NULL ;
2085: p_display_name := NULL ;
2086:
2087: WHEN OTHERS THEN
2088: wf_core.Context('ARP_CMREQ_WF', 'GetUserInfoFromTable',
2089: null, null, null, l_debug_mesg);
2090: raise;
2091:
2092: END GetUserInfoFromTable;

Line 2231: Wf_Core.Context('ARP_CMREQ_WF', 'FindManager',

2227: l_manager_id := NULL;
2228: p_result := 'COMPLETE:F';
2229: return;
2230: WHEN OTHERS THEN
2231: Wf_Core.Context('ARP_CMREQ_WF', 'FindManager',
2232: null, null, null, l_debug_info);
2233: raise;
2234: END FindManager;
2235:

Line 2328: wf_core.context('ARP_CMREQ_WF', 'RecordCollectorAsApprover',

2324: exception
2325: when others then
2326: -- The line below records this function call in the error system
2327: -- in the case of an exception.
2328: wf_core.context('ARP_CMREQ_WF', 'RecordCollectorAsApprover',
2329: p_item_type, p_item_key, to_char(p_actid), p_funcmode);
2330: raise;
2331:
2332: end RecordCollectorAsApprover;

Line 2455: wf_core.context('ARP_CMREQ_WF', 'RecordCollectorAsForwardFrom',

2451: exception
2452: when others then
2453: -- The line below records this function call in the error system
2454: -- in the case of an exception.
2455: wf_core.context('ARP_CMREQ_WF', 'RecordCollectorAsForwardFrom',
2456: p_item_type, p_item_key, to_char(p_actid), p_funcmode);
2457: raise;
2458:
2459: end RecordCollectorAsForwardFrom;

Line 2549: wf_core.context('ARP_CMREQ_WF', 'RecordForwardToUserInfo',

2545: exception
2546: when others then
2547: -- The line below records this function call in the error system
2548: -- in the case of an exception.
2549: wf_core.context('ARP_CMREQ_WF', 'RecordForwardToUserInfo',
2550: p_item_type, p_item_key, to_char(p_actid), p_funcmode);
2551: raise;
2552:
2553: end RecordForwardToUserInfo;

Line 2615: wf_core.context('ARP_CMREQ_WF', 'CheckForwardFromUser',

2611: exception
2612: when others then
2613: -- The line below records this function call in the error system
2614: -- in the case of an exception.
2615: wf_core.context('ARP_CMREQ_WF', 'CheckForwardFromUser',
2616: p_item_type, p_item_key, to_char(p_actid), p_funcmode);
2617: raise;
2618:
2619: end CheckForwardFromUser;

Line 2740: wf_core.context('ARP_CMREQ_WF', 'RecordApproverAsForwardFrom',

2736: exception
2737: when others then
2738: -- The line below records this function call in the error system
2739: -- in the case of an exception.
2740: wf_core.context('ARP_CMREQ_WF', 'RecordApproverAsForwardFrom',
2741: p_item_type, p_item_key, to_char(p_actid), p_funcmode);
2742: raise;
2743:
2744: end RecordApproverAsForwardFrom;

Line 2840: wf_core.context('ARP_CMREQ_WF', 'FinalApprover',

2836: exception
2837: when others then
2838: -- The line below records this function call in the error system
2839: -- in the case of an exception.
2840: wf_core.context('ARP_CMREQ_WF', 'FinalApprover',
2841: p_item_type, p_item_key, to_char(p_actid), p_funcmode);
2842: raise;
2843:
2844: end FinalApprover;

Line 2886: wf_core.Context('ARP_CMREQ_WF', 'CheckFinalApprover',

2882: WHEN NO_DATA_FOUND THEN
2883: p_result_flag := 'N';
2884: return;
2885: WHEN OTHERS THEN
2886: wf_core.Context('ARP_CMREQ_WF', 'CheckFinalApprover',
2887: null, null, null, l_debug_mesg);
2888: raise;
2889:
2890: END CheckFinalApprover;

Line 3117: wf_core.context('ARP_CMREQ_WF', 'RemoveFromDispute',

3113: exception
3114: when others then
3115: -- The line below records this function call in the error system
3116: -- in the case of an exception.
3117: wf_core.context('ARP_CMREQ_WF', 'RemoveFromDispute',
3118: p_item_type, p_item_key, to_char(p_actid), p_funcmode);
3119: raise;
3120:
3121: end RemoveFromDispute;

Line 3209: wf_core.context('ARP_CMREQ_WF', 'FindReceivableApprover',

3205: exception
3206: when others then
3207: -- The line below records this function call in the error system
3208: -- in the case of an exception.
3209: wf_core.context('ARP_CMREQ_WF', 'FindReceivableApprover',
3210: p_item_type, p_item_key, to_char(p_actid), p_funcmode);
3211: raise;
3212:
3213: end FindReceivableApprover;

Line 3297: wf_core.context('ARP_CMREQ_WF', 'FindResponder',

3293: exception
3294: when others then
3295: -- The line below records this function call in the error system
3296: -- in the case of an exception.
3297: wf_core.context('ARP_CMREQ_WF', 'FindResponder',
3298: p_item_type, p_item_key, to_char(p_actid), p_funcmode);
3299: raise;
3300:
3301: end FindResponder;

Line 3459: wf_core.context('ARP_CMREQ_WF', 'InsertSubmissionNotes',

3455: exception
3456: when others then
3457: -- The line below records this function call in the error system
3458: -- in the case of an exception.
3459: wf_core.context('ARP_CMREQ_WF', 'InsertSubmissionNotes',
3460: p_item_type, p_item_key, to_char(p_actid), p_funcmode);
3461: raise;
3462:
3463: end InsertSubmissionNotes;

Line 3564: wf_core.context('ARP_CMREQ_WF', 'InsertApprovalReminderNotes',

3560: exception
3561: when others then
3562: -- The line below records this function call in the error system
3563: -- in the case of an exception.
3564: wf_core.context('ARP_CMREQ_WF', 'InsertApprovalReminderNotes',
3565: p_item_type, p_item_key, to_char(p_actid), p_funcmode);
3566: raise;
3567:
3568: end InsertApprovalReminderNotes;

Line 3663: wf_core.context('ARP_CMREQ_WF', 'InsertEscalationNotes',

3659: exception
3660: when others then
3661: -- The line below records this function call in the error system
3662: -- in the case of an exception.
3663: wf_core.context('ARP_CMREQ_WF', 'InsertEscalationNotes',
3664: p_item_type, p_item_key, to_char(p_actid), p_funcmode);
3665: raise;
3666:
3667: end InsertEscalationNotes;

Line 3765: wf_core.context('ARP_CMREQ_WF', 'InsertRequestManualNotes',

3761: exception
3762: when others then
3763: -- The line below records this function call in the error system
3764: -- in the case of an exception.
3765: wf_core.context('ARP_CMREQ_WF', 'InsertRequestManualNotes',
3766: p_item_type, p_item_key, to_char(p_actid), p_funcmode);
3767: raise;
3768:
3769: end InsertRequestManualNotes;

Line 3891: wf_core.context('ARP_CMREQ_WF', 'InsertCompletedManualNotes',

3887: exception
3888: when others then
3889: -- The line below records this function call in the error system
3890: -- in the case of an exception.
3891: wf_core.context('ARP_CMREQ_WF', 'InsertCompletedManualNotes',
3892: p_item_type, p_item_key, to_char(p_actid), p_funcmode);
3893: raise;
3894:
3895: end InsertCompletedManualNotes;

Line 3990: wf_core.context('ARP_CMREQ_WF', 'InsertRequestApprovalNotes',

3986: exception
3987: when others then
3988: -- The line below records this function call in the error system
3989: -- in the case of an exception.
3990: wf_core.context('ARP_CMREQ_WF', 'InsertRequestApprovalNotes',
3991: p_item_type, p_item_key, to_char(p_actid), p_funcmode);
3992: raise;
3993:
3994: end InsertRequestApprovalNotes;

Line 4089: wf_core.context('ARP_CMREQ_WF', 'InsertApprovedResponseNotes',

4085: exception
4086: when others then
4087: -- The line below records this function call in the error system
4088: -- in the case of an exception.
4089: wf_core.context('ARP_CMREQ_WF', 'InsertApprovedResponseNotes',
4090: p_item_type, p_item_key, to_char(p_actid), p_funcmode);
4091: raise;
4092:
4093: end InsertApprovedResponseNotes;

Line 4212: wf_core.context('ARP_CMREQ_WF', 'InsertRejectedResponseNotes',

4208: exception
4209: when others then
4210: -- The line below records this function call in the error system
4211: -- in the case of an exception.
4212: wf_core.context('ARP_CMREQ_WF', 'InsertRejectedResponseNotes',
4213: p_item_type, p_item_key, to_char(p_actid), p_funcmode);
4214: raise;
4215:
4216:

Line 4313: wf_core.context('ARP_CMREQ_WF', 'InsertSuccessfulAPINotes',

4309: exception
4310: when others then
4311: -- The line below records this function call in the error system
4312: -- in the case of an exception.
4313: wf_core.context('ARP_CMREQ_WF', 'InsertSuccessfulAPINotes',
4314: p_item_type, p_item_key, to_char(p_actid), p_funcmode);
4315: raise;
4316:
4317: end InsertSuccessfulAPINotes;

Line 4432: wf_core.context('ARP_CMREQ_WF', 'InsertNotes',

4428: exception
4429: when others then
4430: -- The line below records this function call in the error system
4431: -- in the case of an exception.
4432: wf_core.context('ARP_CMREQ_WF', 'InsertNotes',
4433: p_item_type, p_item_key, to_char(p_actid), p_funcmode);
4434: raise;
4435:
4436: end InsertNotes;

Line 4492: wf_core.Context('ARP_CMREQ_WF', 'InsertTrxNotes',

4488:
4489: EXCEPTION
4490: WHEN OTHERS THEN
4491: x_note_id := -1;
4492: wf_core.Context('ARP_CMREQ_WF', 'InsertTrxNotes',
4493: null, null, null, l_debug_mesg);
4494: RAISE;
4495:
4496: END InsertTrxNotes;

Line 4752: wf_core.context('ARP_CMREQ_WF', 'CallTrxApi',

4748: exception
4749: when others then
4750: -- The line below records this function call in the error system
4751: -- in the case of an exception.
4752: wf_core.context('ARP_CMREQ_WF', 'CallTrxApi',
4753: p_item_type, p_item_key, to_char(p_actid), p_funcmode);
4754: raise;
4755:
4756: end CallTrxApi;

Line 4890: wf_core.context('ARP_CMREQ_WF', 'CheckCreditMethods',

4886: exception
4887: when others then
4888: -- The line below records this function call in the error system
4889: -- in the case of an exception.
4890: wf_core.context('ARP_CMREQ_WF', 'CheckCreditMethods',
4891: p_item_type, p_item_key, to_char(p_actid), p_funcmode);
4892: raise;
4893:
4894: end CheckCreditMethods;

Line 4924: wf_core.Context('ARP_CMREQ_WF', 'SetContext',

4920: mo_global.set_policy_context('S', l_org_id);
4921:
4922: exception
4923: when others then
4924: wf_core.Context('ARP_CMREQ_WF', 'SetContext',
4925: null, null, null, l_debug_mesg);
4926: raise;
4927:
4928: END SetOrgContext;

Line 4930: end ARP_CMREQ_WF;

4926: raise;
4927:
4928: END SetOrgContext;
4929:
4930: end ARP_CMREQ_WF;