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.21.12010000.2 2008/09/01 09:49:30 naneja ship $ */
3:
4:
5: /*=======================================================================+

Line 120: pkg_name => 'AR_AME_CMWF_API',

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

Line 169: pkg_name => 'AR_AME_CMWF_API',

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

Line 271: pkg_name => 'AR_AME_CMWF_API',

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

Line 317: pkg_name => 'AR_AME_CMWF_API',

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

Line 355: pkg_name => 'AR_AME_CMWF_API',

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

Line 420: pkg_name => 'AR_AME_CMWF_API',

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

Line 433: pkg_name => 'AR_AME_CMWF_API',

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

Line 500: pkg_name => 'AR_AME_CMWF_API',

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

Line 656: pkg_name => 'AR_AME_CMWF_API',

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

Line 764: pkg_name => 'AR_AME_CMWF_API',

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

Line 849: pkg_name => 'AR_AME_CMWF_API',

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

Line 937: pkg_name => 'AR_AME_CMWF_API',

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

Line 1217: pkg_name => 'AR_AME_CMWF_API',

1213: EXCEPTION
1214: WHEN OTHERS THEN
1215:
1216: wf_core.context(
1217: pkg_name => 'AR_AME_CMWF_API',
1218: proc_name => 'FINDTRX',
1219: arg1 => p_item_type,
1220: arg2 => p_item_key,
1221: arg3 => p_funcmode,

Line 1354: pkg_name => 'AR_AME_CMWF_API',

1350: p_tax_ex_cert_num := NULL;
1351: p_internal_comment := NULL;
1352:
1353: wf_core.context(
1354: pkg_name => 'AR_AME_CMWF_API',
1355: proc_name => 'GETCUSTOMERTRXINFO',
1356: arg1 => p_item_type,
1357: arg2 => p_item_key,
1358: arg3 => NULL,

Line 1414: pkg_name => 'AR_AME_CMWF_API',

1410: p_original_total := NULL;
1411: p_currency_code := NULL;
1412:
1413: wf_core.context(
1414: pkg_name => 'AR_AME_CMWF_API',
1415: proc_name => 'GETTRXAMOUNT',
1416: arg1 => p_item_type,
1417: arg2 => p_item_key,
1418: arg3 => NULL,

Line 1612: pkg_name => 'AR_AME_CMWF_API',

1608: EXCEPTION
1609: WHEN OTHERS THEN
1610:
1611: wf_core.context(
1612: pkg_name => 'AR_AME_CMWF_API',
1613: proc_name => 'FINDCUSTOMER',
1614: arg1 => p_item_type,
1615: arg2 => p_item_key,
1616: arg3 => p_funcmode,

Line 1697: pkg_name => 'AR_AME_CMWF_API',

1693:
1694: WHEN OTHERS THEN
1695:
1696: wf_core.context(
1697: pkg_name => 'AR_AME_CMWF_API',
1698: proc_name => 'FINDCUSTOMERINFO',
1699: arg1 => c_item_type,
1700: arg2 => NULL,
1701: arg3 => NULL,

Line 1902: pkg_name => 'AR_AME_CMWF_API',

1898: EXCEPTION
1899: WHEN OTHERS THEN
1900:
1901: wf_core.context(
1902: pkg_name => 'AR_AME_CMWF_API',
1903: proc_name => 'FINDCOLLECTOR',
1904: arg1 => p_item_type,
1905: arg2 => p_item_key,
1906: arg3 => p_funcmode,

Line 2029: pkg_name => 'AR_AME_CMWF_API',

2025: EXCEPTION
2026: WHEN OTHERS THEN
2027:
2028: wf_core.context(
2029: pkg_name => 'AR_AME_CMWF_API',
2030: proc_name => 'AMECHECKRULE',
2031: arg1 => p_item_type,
2032: arg2 => p_item_key,
2033: arg3 => p_funcmode,

Line 2117: pkg_name => 'AR_AME_CMWF_API',

2113: RETURN;
2114: WHEN OTHERS THEN
2115:
2116: wf_core.context(
2117: pkg_name => 'AR_AME_CMWF_API',
2118: proc_name => 'AMECHECKPRIMARYAPPROVER',
2119: arg1 => p_item_type,
2120: arg2 => p_item_key,
2121: arg3 => p_funcmode,

Line 2321: pkg_name => 'AR_AME_CMWF_API',

2317: EXCEPTION
2318: WHEN OTHERS THEN
2319:
2320: wf_core.context(
2321: pkg_name => 'AR_AME_CMWF_API',
2322: proc_name => 'AMEFINDPRIMARYAPPROVER',
2323: arg1 => p_item_type,
2324: arg2 => p_item_key,
2325: arg3 => p_funcmode,

Line 2431: pkg_name => 'AR_AME_CMWF_API',

2427: EXCEPTION
2428: WHEN OTHERS THEN
2429:
2430: wf_core.context(
2431: pkg_name => 'AR_AME_CMWF_API',
2432: proc_name => 'AMESETNONPRIMARYAPPROVER',
2433: arg1 => p_item_type,
2434: arg2 => p_item_key,
2435: arg3 => p_funcmode,

Line 2534: pkg_name => 'AR_AME_CMWF_API',

2530: EXCEPTION
2531: WHEN OTHERS THEN
2532:
2533: wf_core.context(
2534: pkg_name => 'AR_AME_CMWF_API',
2535: proc_name => 'AMEFINDNONPRIMARYAPPROVER',
2536: arg1 => p_item_type,
2537: arg2 => p_item_key,
2538: arg3 => p_funcmode,

Line 2743: pkg_name => 'AR_AME_CMWF_API',

2739: EXCEPTION
2740: WHEN OTHERS THEN
2741:
2742: wf_core.context(
2743: pkg_name => 'AR_AME_CMWF_API',
2744: proc_name => 'AMEFINDNEXTNONPRIMARYAPPROVER',
2745: arg1 => p_item_type,
2746: arg2 => p_item_key,
2747: arg3 => p_funcmode,

Line 2968: pkg_name => 'AR_AME_CMWF_API',

2964: EXCEPTION
2965: WHEN OTHERS THEN
2966:
2967: wf_core.context(
2968: pkg_name => 'AR_AME_CMWF_API',
2969: proc_name => 'AMEFINDMANAGER',
2970: arg1 => p_item_type,
2971: arg2 => p_item_key,
2972: arg3 => p_funcmode,

Line 3116: pkg_name => 'AR_AME_CMWF_API',

3112: EXCEPTION
3113: WHEN OTHERS THEN
3114:
3115: wf_core.context(
3116: pkg_name => 'AR_AME_CMWF_API',
3117: proc_name => 'RECORDCOLLECTORASFORWARDFROM',
3118: arg1 => p_item_type,
3119: arg2 => p_item_key,
3120: arg3 => p_funcmode,

Line 3225: pkg_name => 'AR_AME_CMWF_API',

3221: WHEN OTHERS THEN
3222:
3223:
3224: wf_core.context(
3225: pkg_name => 'AR_AME_CMWF_API',
3226: proc_name => 'RECORDFORWARDTOUSERINFO',
3227: arg1 => p_item_type,
3228: arg2 => p_item_key,
3229: arg3 => p_funcmode,

Line 3301: pkg_name => 'AR_AME_CMWF_API',

3297: EXCEPTION
3298: WHEN OTHERS THEN
3299:
3300: wf_core.context(
3301: pkg_name => 'AR_AME_CMWF_API',
3302: proc_name => 'CHECKFORWARDFROMUSER',
3303: arg1 => p_item_type,
3304: arg2 => p_item_key,
3305: arg3 => p_funcmode,

Line 3438: pkg_name => 'AR_AME_CMWF_API',

3434: EXCEPTION
3435: WHEN OTHERS THEN
3436:
3437: wf_core.context(
3438: pkg_name => 'AR_AME_CMWF_API',
3439: proc_name => 'RECORDAPPROVERASFORWARDFROM',
3440: arg1 => p_item_type,
3441: arg2 => p_item_key,
3442: arg3 => p_funcmode,

Line 3495: pkg_name => 'AR_AME_CMWF_API',

3491:
3492: WHEN OTHERS THEN
3493:
3494: wf_core.context(
3495: pkg_name => 'AR_AME_CMWF_API',
3496: proc_name => 'CHECKFINALAPPROVER',
3497: arg1 => c_item_type,
3498: arg2 => NULL,
3499: arg3 => NULL,

Line 3673: pkg_name => 'AR_AME_CMWF_API',

3669: EXCEPTION
3670: WHEN OTHERS THEN
3671:
3672: wf_core.context(
3673: pkg_name => 'AR_AME_CMWF_API',
3674: proc_name => 'REMOVEFROMDISPUTE',
3675: arg1 => p_item_type,
3676: arg2 => p_item_key,
3677: arg3 => p_funcmode,

Line 3782: pkg_name => 'AR_AME_CMWF_API',

3778: EXCEPTION
3779: WHEN OTHERS THEN
3780:
3781: wf_core.context(
3782: pkg_name => 'AR_AME_CMWF_API',
3783: proc_name => 'AMEFINDRECEIVABLEAPPROVER',
3784: arg1 => p_item_type,
3785: arg2 => p_item_key,
3786: arg3 => p_funcmode,

Line 3883: pkg_name => 'AR_AME_CMWF_API',

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

Line 4061: pkg_name => 'AR_AME_CMWF_API',

4057: EXCEPTION
4058: WHEN OTHERS THEN
4059:
4060: wf_core.context(
4061: pkg_name => 'AR_AME_CMWF_API',
4062: proc_name => 'INSERTSUBMISSIONNOTES',
4063: arg1 => p_item_type,
4064: arg2 => p_item_key,
4065: arg3 => p_funcmode,

Line 4166: pkg_name => 'AR_AME_CMWF_API',

4162: EXCEPTION
4163: WHEN OTHERS THEN
4164:
4165: wf_core.context(
4166: pkg_name => 'AR_AME_CMWF_API',
4167: proc_name => 'INSERTAPPROVALREMINDERNOTES',
4168: arg1 => p_item_type,
4169: arg2 => p_item_key,
4170: arg3 => p_funcmode,

Line 4272: pkg_name => 'AR_AME_CMWF_API',

4268: EXCEPTION
4269: WHEN OTHERS THEN
4270:
4271: wf_core.context(
4272: pkg_name => 'AR_AME_CMWF_API',
4273: proc_name => 'INSERTESCALATIONNOTES',
4274: arg1 => p_item_type,
4275: arg2 => p_item_key,
4276: arg3 => p_funcmode,

Line 4380: pkg_name => 'AR_AME_CMWF_API',

4376: EXCEPTION
4377: WHEN OTHERS THEN
4378:
4379: wf_core.context(
4380: pkg_name => 'AR_AME_CMWF_API',
4381: proc_name => 'INSERTREQUESTMANUALNOTES',
4382: arg1 => p_item_type,
4383: arg2 => p_item_key,
4384: arg3 => p_funcmode,

Line 4512: pkg_name => 'AR_AME_CMWF_API',

4508: EXCEPTION
4509: WHEN OTHERS THEN
4510:
4511: wf_core.context(
4512: pkg_name => 'AR_AME_CMWF_API',
4513: proc_name => 'INSERTCOMPLETEDMANUALNOTES',
4514: arg1 => p_item_type,
4515: arg2 => p_item_key,
4516: arg3 => p_funcmode,

Line 4617: pkg_name => 'AR_AME_CMWF_API',

4613: EXCEPTION
4614: WHEN OTHERS THEN
4615:
4616: wf_core.context(
4617: pkg_name => 'AR_AME_CMWF_API',
4618: proc_name => 'INSERTREQUESTAPPROVALNOTES',
4619: arg1 => p_item_type,
4620: arg2 => p_item_key,
4621: arg3 => p_funcmode,

Line 4762: pkg_name => 'AR_AME_CMWF_API',

4758: EXCEPTION
4759: WHEN OTHERS THEN
4760:
4761: wf_core.context(
4762: pkg_name => 'AR_AME_CMWF_API',
4763: proc_name => 'INSERTAPPROVEDRESPONSENOTES',
4764: arg1 => p_item_type,
4765: arg2 => p_item_key,
4766: arg3 => p_funcmode,

Line 4927: pkg_name => 'AR_AME_CMWF_API',

4923: EXCEPTION
4924: WHEN OTHERS THEN
4925:
4926: wf_core.context(
4927: pkg_name => 'AR_AME_CMWF_API',
4928: proc_name => 'INSERTREJECTEDRESPONSENOTES',
4929: arg1 => p_item_type,
4930: arg2 => p_item_key,
4931: arg3 => p_funcmode,

Line 5034: pkg_name => 'AR_AME_CMWF_API',

5030: EXCEPTION
5031: WHEN OTHERS THEN
5032:
5033: wf_core.context(
5034: pkg_name => 'AR_AME_CMWF_API',
5035: proc_name => 'INSERTSUCCESSFULAPINOTES',
5036: arg1 => p_item_type,
5037: arg2 => p_item_key,
5038: arg3 => p_funcmode,

Line 5157: pkg_name => 'AR_AME_CMWF_API',

5153: EXCEPTION
5154: WHEN OTHERS THEN
5155:
5156: wf_core.context(
5157: pkg_name => 'AR_AME_CMWF_API',
5158: proc_name => 'INSERTNOTES',
5159: arg1 => p_item_type,
5160: arg2 => p_item_key,
5161: arg3 => p_funcmode,

Line 5233: pkg_name => 'AR_AME_CMWF_API',

5229: EXCEPTION
5230: WHEN OTHERS THEN
5231: x_note_id := -1;
5232: wf_core.context(
5233: pkg_name => 'AR_AME_CMWF_API',
5234: proc_name => 'INSERTTRXNOTES',
5235: arg1 => c_item_type,
5236: arg2 => NULL,
5237: arg3 => NULL,

Line 5499: pkg_name => 'AR_AME_CMWF_API',

5495: EXCEPTION
5496: WHEN OTHERS THEN
5497:
5498: wf_core.context(
5499: pkg_name => 'AR_AME_CMWF_API',
5500: proc_name => 'CALLTRXAPI',
5501: arg1 => p_item_type,
5502: arg2 => p_item_key,
5503: arg3 => p_funcmode,

Line 5676: pkg_name => 'AR_AME_CMWF_API',

5672: EXCEPTION
5673: WHEN OTHERS THEN
5674:
5675: wf_core.context(
5676: pkg_name => 'AR_AME_CMWF_API',
5677: proc_name => 'CHECKCREDITMETHODS',
5678: arg1 => p_item_type,
5679: arg2 => p_item_key,
5680: arg3 => p_funcmode,

Line 5774: pkg_name => 'AR_AME_CMWF_API',

5770: EXCEPTION
5771: WHEN OTHERS THEN
5772:
5773: wf_core.context(
5774: pkg_name => 'AR_AME_CMWF_API',
5775: proc_name => 'FIND_PRIMARY_SALESREP',
5776: arg1 => p_item_type,
5777: arg2 => p_item_key,
5778: arg3 => p_funcmode,

Line 5845: pkg_name => 'AR_AME_CMWF_API',

5841: EXCEPTION
5842: WHEN OTHERS THEN
5843:
5844: wf_core.context(
5845: pkg_name => 'AR_AME_CMWF_API',
5846: proc_name => 'CHECK_FIRST_APPROVER',
5847: arg1 => p_item_type,
5848: arg2 => p_item_key,
5849: arg3 => p_funcmode,

Line 5918: pkg_name => 'AR_AME_CMWF_API',

5914: EXCEPTION
5915: WHEN OTHERS THEN
5916:
5917: wf_core.context(
5918: pkg_name => 'AR_AME_CMWF_API',
5919: proc_name => 'ON_ACCOUNT_CREDIT_MEMO',
5920: arg1 => p_item_type,
5921: arg2 => p_item_key,
5922: arg3 => p_funcmode,

Line 5983: pkg_name => 'AR_AME_CMWF_API',

5979: EXCEPTION
5980: WHEN OTHERS THEN
5981:
5982: wf_core.context(
5983: pkg_name => 'AR_AME_CMWF_API',
5984: proc_name => 'INFORM_COLLECTOR',
5985: arg1 => p_item_type,
5986: arg2 => p_item_key,
5987: arg3 => p_funcmode,

Line 6061: ar_ame_cmwf_api.amefindmanager(

6057:
6058: -- profile option is set to look for manager, so continue
6059: -- with our original logic.
6060:
6061: ar_ame_cmwf_api.amefindmanager(
6062: p_item_type => p_item_type,
6063: p_item_key => p_item_key,
6064: p_actid => p_actid,
6065: p_funcmode => p_funcmode,

Line 6077: END ar_ame_cmwf_api;

6073: END IF;
6074:
6075: END AMEHandleTimeout;
6076:
6077: END ar_ame_cmwf_api;