DBA Data[Home] [Help]

APPS.AR_AME_CMWF_API dependencies on AR_AME_CMWF_API

Line 1: PACKAGE BODY ar_ame_cmwf_api AS

1: PACKAGE BODY ar_ame_cmwf_api AS
2: /* $Header: ARAMECMB.pls 120.28 2011/10/20 15:49:55 naneja ship $ */
3:
4:
5: /*=======================================================================+

Line 122: pkg_name => 'AR_AME_CMWF_API',

118: EXCEPTION
119: WHEN OTHERS THEN
120:
121: wf_core.context(
122: pkg_name => 'AR_AME_CMWF_API',
123: proc_name => 'RESTORE_CONTEXT',
124: arg1 => c_item_type,
125: arg2 => NULL,
126: arg3 => NULL,

Line 171: pkg_name => 'AR_AME_CMWF_API',

167: EXCEPTION
168: WHEN OTHERS THEN
169:
170: wf_core.context(
171: pkg_name => 'AR_AME_CMWF_API',
172: proc_name => 'SAVE_CONTEXT',
173: arg1 => c_item_type,
174: arg2 => NULL,
175: arg3 => NULL,

Line 273: pkg_name => 'AR_AME_CMWF_API',

269: EXCEPTION
270: WHEN OTHERS THEN
271:
272: wf_core.context(
273: pkg_name => 'AR_AME_CMWF_API',
274: proc_name => 'VALIDATE_FIRST_APPROVER',
275: arg1 => c_item_type,
276: arg2 => NULL,
277: arg3 => NULL,

Line 319: pkg_name => 'AR_AME_CMWF_API',

315: EXCEPTION
316: WHEN OTHERS THEN
317:
318: wf_core.context(
319: pkg_name => 'AR_AME_CMWF_API',
320: proc_name => 'GET_EMPLOYEE_ID',
321: arg1 => c_item_type,
322: arg2 => NULL,
323: arg3 => NULL,

Line 357: pkg_name => 'AR_AME_CMWF_API',

353: EXCEPTION
354: WHEN OTHERS THEN
355:
356: wf_core.context(
357: pkg_name => 'AR_AME_CMWF_API',
358: proc_name => 'GET_USER_ID',
359: arg1 => c_item_type,
360: arg2 => NULL,
361: arg3 => NULL,

Line 422: pkg_name => 'AR_AME_CMWF_API',

418: p_user_name := NULL ;
419: p_display_name := NULL ;
420:
421: wf_core.context(
422: pkg_name => 'AR_AME_CMWF_API',
423: proc_name => 'GETUSERINFOFROMTABLE',
424: arg1 => c_item_type,
425: arg2 => p_user_id,
426: arg3 => l_employee_id,

Line 435: pkg_name => 'AR_AME_CMWF_API',

431:
432: WHEN OTHERS THEN
433:
434: wf_core.context(
435: pkg_name => 'AR_AME_CMWF_API',
436: proc_name => 'GETUSERINFOFROMTABLE',
437: arg1 => c_item_type,
438: arg2 => p_user_id,
439: arg3 => NULL,

Line 502: pkg_name => 'AR_AME_CMWF_API',

498: EXCEPTION
499: WHEN OTHERS THEN
500:
501: wf_core.context(
502: pkg_name => 'AR_AME_CMWF_API',
503: proc_name => 'GETEMPLOYEEINFO',
504: arg1 => p_item_type,
505: arg2 => p_item_key,
506: arg3 => p_user_id,

Line 658: pkg_name => 'AR_AME_CMWF_API',

654: EXCEPTION
655: WHEN OTHERS THEN
656:
657: wf_core.context(
658: pkg_name => 'AR_AME_CMWF_API',
659: proc_name => 'CHECKUSERINTABLE',
660: arg1 => c_item_type,
661: arg2 => NULL,
662: arg3 => NULL,

Line 766: pkg_name => 'AR_AME_CMWF_API',

762: EXCEPTION
763: WHEN OTHERS THEN
764:
765: wf_core.context(
766: pkg_name => 'AR_AME_CMWF_API',
767: proc_name => 'FINDNEXTAPPROVER',
768: arg1 => p_item_type,
769: arg2 => p_item_key,
770: arg3 => NULL,

Line 851: pkg_name => 'AR_AME_CMWF_API',

847: EXCEPTION
848: WHEN OTHERS THEN
849:
850: wf_core.context(
851: pkg_name => 'AR_AME_CMWF_API',
852: proc_name => 'RECORDRESPONSEWITHAME',
853: arg1 => p_item_type,
854: arg2 => p_item_key,
855: arg3 => null,

Line 939: pkg_name => 'AR_AME_CMWF_API',

935: EXCEPTION
936: WHEN OTHERS THEN
937:
938: wf_core.context(
939: pkg_name => 'AR_AME_CMWF_API',
940: proc_name => 'SKIPIFDUPLICATE',
941: arg1 => p_item_type,
942: arg2 => p_item_key,
943: arg3 => NULL,

Line 1256: pkg_name => 'AR_AME_CMWF_API',

1252: EXCEPTION
1253: WHEN OTHERS THEN
1254:
1255: wf_core.context(
1256: pkg_name => 'AR_AME_CMWF_API',
1257: proc_name => 'FINDTRX',
1258: arg1 => p_item_type,
1259: arg2 => p_item_key,
1260: arg3 => p_funcmode,

Line 1395: pkg_name => 'AR_AME_CMWF_API',

1391: p_tax_ex_cert_num := NULL;
1392: p_internal_comment := NULL;
1393:
1394: wf_core.context(
1395: pkg_name => 'AR_AME_CMWF_API',
1396: proc_name => 'GETCUSTOMERTRXINFO',
1397: arg1 => p_item_type,
1398: arg2 => p_item_key,
1399: arg3 => NULL,

Line 1455: pkg_name => 'AR_AME_CMWF_API',

1451: p_original_total := NULL;
1452: p_currency_code := NULL;
1453:
1454: wf_core.context(
1455: pkg_name => 'AR_AME_CMWF_API',
1456: proc_name => 'GETTRXAMOUNT',
1457: arg1 => p_item_type,
1458: arg2 => p_item_key,
1459: arg3 => NULL,

Line 1653: pkg_name => 'AR_AME_CMWF_API',

1649: EXCEPTION
1650: WHEN OTHERS THEN
1651:
1652: wf_core.context(
1653: pkg_name => 'AR_AME_CMWF_API',
1654: proc_name => 'FINDCUSTOMER',
1655: arg1 => p_item_type,
1656: arg2 => p_item_key,
1657: arg3 => p_funcmode,

Line 1738: pkg_name => 'AR_AME_CMWF_API',

1734:
1735: WHEN OTHERS THEN
1736:
1737: wf_core.context(
1738: pkg_name => 'AR_AME_CMWF_API',
1739: proc_name => 'FINDCUSTOMERINFO',
1740: arg1 => c_item_type,
1741: arg2 => NULL,
1742: arg3 => NULL,

Line 1943: pkg_name => 'AR_AME_CMWF_API',

1939: EXCEPTION
1940: WHEN OTHERS THEN
1941:
1942: wf_core.context(
1943: pkg_name => 'AR_AME_CMWF_API',
1944: proc_name => 'FINDCOLLECTOR',
1945: arg1 => p_item_type,
1946: arg2 => p_item_key,
1947: arg3 => p_funcmode,

Line 2070: pkg_name => 'AR_AME_CMWF_API',

2066: EXCEPTION
2067: WHEN OTHERS THEN
2068:
2069: wf_core.context(
2070: pkg_name => 'AR_AME_CMWF_API',
2071: proc_name => 'AMECHECKRULE',
2072: arg1 => p_item_type,
2073: arg2 => p_item_key,
2074: arg3 => p_funcmode,

Line 2158: pkg_name => 'AR_AME_CMWF_API',

2154: RETURN;
2155: WHEN OTHERS THEN
2156:
2157: wf_core.context(
2158: pkg_name => 'AR_AME_CMWF_API',
2159: proc_name => 'AMECHECKPRIMARYAPPROVER',
2160: arg1 => p_item_type,
2161: arg2 => p_item_key,
2162: arg3 => p_funcmode,

Line 2362: pkg_name => 'AR_AME_CMWF_API',

2358: EXCEPTION
2359: WHEN OTHERS THEN
2360:
2361: wf_core.context(
2362: pkg_name => 'AR_AME_CMWF_API',
2363: proc_name => 'AMEFINDPRIMARYAPPROVER',
2364: arg1 => p_item_type,
2365: arg2 => p_item_key,
2366: arg3 => p_funcmode,

Line 2472: pkg_name => 'AR_AME_CMWF_API',

2468: EXCEPTION
2469: WHEN OTHERS THEN
2470:
2471: wf_core.context(
2472: pkg_name => 'AR_AME_CMWF_API',
2473: proc_name => 'AMESETNONPRIMARYAPPROVER',
2474: arg1 => p_item_type,
2475: arg2 => p_item_key,
2476: arg3 => p_funcmode,

Line 2575: pkg_name => 'AR_AME_CMWF_API',

2571: EXCEPTION
2572: WHEN OTHERS THEN
2573:
2574: wf_core.context(
2575: pkg_name => 'AR_AME_CMWF_API',
2576: proc_name => 'AMEFINDNONPRIMARYAPPROVER',
2577: arg1 => p_item_type,
2578: arg2 => p_item_key,
2579: arg3 => p_funcmode,

Line 2784: pkg_name => 'AR_AME_CMWF_API',

2780: EXCEPTION
2781: WHEN OTHERS THEN
2782:
2783: wf_core.context(
2784: pkg_name => 'AR_AME_CMWF_API',
2785: proc_name => 'AMEFINDNEXTNONPRIMARYAPPROVER',
2786: arg1 => p_item_type,
2787: arg2 => p_item_key,
2788: arg3 => p_funcmode,

Line 3009: pkg_name => 'AR_AME_CMWF_API',

3005: EXCEPTION
3006: WHEN OTHERS THEN
3007:
3008: wf_core.context(
3009: pkg_name => 'AR_AME_CMWF_API',
3010: proc_name => 'AMEFINDMANAGER',
3011: arg1 => p_item_type,
3012: arg2 => p_item_key,
3013: arg3 => p_funcmode,

Line 3157: pkg_name => 'AR_AME_CMWF_API',

3153: EXCEPTION
3154: WHEN OTHERS THEN
3155:
3156: wf_core.context(
3157: pkg_name => 'AR_AME_CMWF_API',
3158: proc_name => 'RECORDCOLLECTORASFORWARDFROM',
3159: arg1 => p_item_type,
3160: arg2 => p_item_key,
3161: arg3 => p_funcmode,

Line 3266: pkg_name => 'AR_AME_CMWF_API',

3262: WHEN OTHERS THEN
3263:
3264:
3265: wf_core.context(
3266: pkg_name => 'AR_AME_CMWF_API',
3267: proc_name => 'RECORDFORWARDTOUSERINFO',
3268: arg1 => p_item_type,
3269: arg2 => p_item_key,
3270: arg3 => p_funcmode,

Line 3342: pkg_name => 'AR_AME_CMWF_API',

3338: EXCEPTION
3339: WHEN OTHERS THEN
3340:
3341: wf_core.context(
3342: pkg_name => 'AR_AME_CMWF_API',
3343: proc_name => 'CHECKFORWARDFROMUSER',
3344: arg1 => p_item_type,
3345: arg2 => p_item_key,
3346: arg3 => p_funcmode,

Line 3479: pkg_name => 'AR_AME_CMWF_API',

3475: EXCEPTION
3476: WHEN OTHERS THEN
3477:
3478: wf_core.context(
3479: pkg_name => 'AR_AME_CMWF_API',
3480: proc_name => 'RECORDAPPROVERASFORWARDFROM',
3481: arg1 => p_item_type,
3482: arg2 => p_item_key,
3483: arg3 => p_funcmode,

Line 3536: pkg_name => 'AR_AME_CMWF_API',

3532:
3533: WHEN OTHERS THEN
3534:
3535: wf_core.context(
3536: pkg_name => 'AR_AME_CMWF_API',
3537: proc_name => 'CHECKFINALAPPROVER',
3538: arg1 => c_item_type,
3539: arg2 => NULL,
3540: arg3 => NULL,

Line 3773: pkg_name => 'AR_AME_CMWF_API',

3769: EXCEPTION
3770: WHEN OTHERS THEN
3771:
3772: wf_core.context(
3773: pkg_name => 'AR_AME_CMWF_API',
3774: proc_name => 'REMOVEFROMDISPUTE',
3775: arg1 => p_item_type,
3776: arg2 => p_item_key,
3777: arg3 => p_funcmode,

Line 3882: pkg_name => 'AR_AME_CMWF_API',

3878: EXCEPTION
3879: WHEN OTHERS THEN
3880:
3881: wf_core.context(
3882: pkg_name => 'AR_AME_CMWF_API',
3883: proc_name => 'AMEFINDRECEIVABLEAPPROVER',
3884: arg1 => p_item_type,
3885: arg2 => p_item_key,
3886: arg3 => p_funcmode,

Line 3983: pkg_name => 'AR_AME_CMWF_API',

3979: EXCEPTION
3980: WHEN OTHERS THEN
3981:
3982: wf_core.context(
3983: pkg_name => 'AR_AME_CMWF_API',
3984: proc_name => 'FINDRESPONDER',
3985: arg1 => p_item_type,
3986: arg2 => p_item_key,
3987: arg3 => p_funcmode,

Line 4161: pkg_name => 'AR_AME_CMWF_API',

4157: EXCEPTION
4158: WHEN OTHERS THEN
4159:
4160: wf_core.context(
4161: pkg_name => 'AR_AME_CMWF_API',
4162: proc_name => 'INSERTSUBMISSIONNOTES',
4163: arg1 => p_item_type,
4164: arg2 => p_item_key,
4165: arg3 => p_funcmode,

Line 4266: pkg_name => 'AR_AME_CMWF_API',

4262: EXCEPTION
4263: WHEN OTHERS THEN
4264:
4265: wf_core.context(
4266: pkg_name => 'AR_AME_CMWF_API',
4267: proc_name => 'INSERTAPPROVALREMINDERNOTES',
4268: arg1 => p_item_type,
4269: arg2 => p_item_key,
4270: arg3 => p_funcmode,

Line 4372: pkg_name => 'AR_AME_CMWF_API',

4368: EXCEPTION
4369: WHEN OTHERS THEN
4370:
4371: wf_core.context(
4372: pkg_name => 'AR_AME_CMWF_API',
4373: proc_name => 'INSERTESCALATIONNOTES',
4374: arg1 => p_item_type,
4375: arg2 => p_item_key,
4376: arg3 => p_funcmode,

Line 4480: pkg_name => 'AR_AME_CMWF_API',

4476: EXCEPTION
4477: WHEN OTHERS THEN
4478:
4479: wf_core.context(
4480: pkg_name => 'AR_AME_CMWF_API',
4481: proc_name => 'INSERTREQUESTMANUALNOTES',
4482: arg1 => p_item_type,
4483: arg2 => p_item_key,
4484: arg3 => p_funcmode,

Line 4612: pkg_name => 'AR_AME_CMWF_API',

4608: EXCEPTION
4609: WHEN OTHERS THEN
4610:
4611: wf_core.context(
4612: pkg_name => 'AR_AME_CMWF_API',
4613: proc_name => 'INSERTCOMPLETEDMANUALNOTES',
4614: arg1 => p_item_type,
4615: arg2 => p_item_key,
4616: arg3 => p_funcmode,

Line 4717: pkg_name => 'AR_AME_CMWF_API',

4713: EXCEPTION
4714: WHEN OTHERS THEN
4715:
4716: wf_core.context(
4717: pkg_name => 'AR_AME_CMWF_API',
4718: proc_name => 'INSERTREQUESTAPPROVALNOTES',
4719: arg1 => p_item_type,
4720: arg2 => p_item_key,
4721: arg3 => p_funcmode,

Line 4862: pkg_name => 'AR_AME_CMWF_API',

4858: EXCEPTION
4859: WHEN OTHERS THEN
4860:
4861: wf_core.context(
4862: pkg_name => 'AR_AME_CMWF_API',
4863: proc_name => 'INSERTAPPROVEDRESPONSENOTES',
4864: arg1 => p_item_type,
4865: arg2 => p_item_key,
4866: arg3 => p_funcmode,

Line 5027: pkg_name => 'AR_AME_CMWF_API',

5023: EXCEPTION
5024: WHEN OTHERS THEN
5025:
5026: wf_core.context(
5027: pkg_name => 'AR_AME_CMWF_API',
5028: proc_name => 'INSERTREJECTEDRESPONSENOTES',
5029: arg1 => p_item_type,
5030: arg2 => p_item_key,
5031: arg3 => p_funcmode,

Line 5134: pkg_name => 'AR_AME_CMWF_API',

5130: EXCEPTION
5131: WHEN OTHERS THEN
5132:
5133: wf_core.context(
5134: pkg_name => 'AR_AME_CMWF_API',
5135: proc_name => 'INSERTSUCCESSFULAPINOTES',
5136: arg1 => p_item_type,
5137: arg2 => p_item_key,
5138: arg3 => p_funcmode,

Line 5257: pkg_name => 'AR_AME_CMWF_API',

5253: EXCEPTION
5254: WHEN OTHERS THEN
5255:
5256: wf_core.context(
5257: pkg_name => 'AR_AME_CMWF_API',
5258: proc_name => 'INSERTNOTES',
5259: arg1 => p_item_type,
5260: arg2 => p_item_key,
5261: arg3 => p_funcmode,

Line 5333: pkg_name => 'AR_AME_CMWF_API',

5329: EXCEPTION
5330: WHEN OTHERS THEN
5331: x_note_id := -1;
5332: wf_core.context(
5333: pkg_name => 'AR_AME_CMWF_API',
5334: proc_name => 'INSERTTRXNOTES',
5335: arg1 => c_item_type,
5336: arg2 => NULL,
5337: arg3 => NULL,

Line 5628: pkg_name => 'AR_AME_CMWF_API',

5624: EXCEPTION
5625: WHEN OTHERS THEN
5626:
5627: wf_core.context(
5628: pkg_name => 'AR_AME_CMWF_API',
5629: proc_name => 'CALLTRXAPI',
5630: arg1 => p_item_type,
5631: arg2 => p_item_key,
5632: arg3 => p_funcmode,

Line 5805: pkg_name => 'AR_AME_CMWF_API',

5801: EXCEPTION
5802: WHEN OTHERS THEN
5803:
5804: wf_core.context(
5805: pkg_name => 'AR_AME_CMWF_API',
5806: proc_name => 'CHECKCREDITMETHODS',
5807: arg1 => p_item_type,
5808: arg2 => p_item_key,
5809: arg3 => p_funcmode,

Line 5903: pkg_name => 'AR_AME_CMWF_API',

5899: EXCEPTION
5900: WHEN OTHERS THEN
5901:
5902: wf_core.context(
5903: pkg_name => 'AR_AME_CMWF_API',
5904: proc_name => 'FIND_PRIMARY_SALESREP',
5905: arg1 => p_item_type,
5906: arg2 => p_item_key,
5907: arg3 => p_funcmode,

Line 5974: pkg_name => 'AR_AME_CMWF_API',

5970: EXCEPTION
5971: WHEN OTHERS THEN
5972:
5973: wf_core.context(
5974: pkg_name => 'AR_AME_CMWF_API',
5975: proc_name => 'CHECK_FIRST_APPROVER',
5976: arg1 => p_item_type,
5977: arg2 => p_item_key,
5978: arg3 => p_funcmode,

Line 6047: pkg_name => 'AR_AME_CMWF_API',

6043: EXCEPTION
6044: WHEN OTHERS THEN
6045:
6046: wf_core.context(
6047: pkg_name => 'AR_AME_CMWF_API',
6048: proc_name => 'ON_ACCOUNT_CREDIT_MEMO',
6049: arg1 => p_item_type,
6050: arg2 => p_item_key,
6051: arg3 => p_funcmode,

Line 6112: pkg_name => 'AR_AME_CMWF_API',

6108: EXCEPTION
6109: WHEN OTHERS THEN
6110:
6111: wf_core.context(
6112: pkg_name => 'AR_AME_CMWF_API',
6113: proc_name => 'INFORM_COLLECTOR',
6114: arg1 => p_item_type,
6115: arg2 => p_item_key,
6116: arg3 => p_funcmode,

Line 6190: ar_ame_cmwf_api.amefindmanager(

6186:
6187: -- profile option is set to look for manager, so continue
6188: -- with our original logic.
6189:
6190: ar_ame_cmwf_api.amefindmanager(
6191: p_item_type => p_item_type,
6192: p_item_key => p_item_key,
6193: p_actid => p_actid,
6194: p_funcmode => p_funcmode,

Line 6206: END ar_ame_cmwf_api;

6202: END IF;
6203:
6204: END AMEHandleTimeout;
6205:
6206: END ar_ame_cmwf_api;