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

Line 1: PACKAGE BODY ARP_DET_DIST_PKG AS

1: PACKAGE BODY ARP_DET_DIST_PKG AS
2: /* $Header: ARPDDB.pls 120.142.12020000.7 2013/01/31 10:41:34 kkikkise ship $ */
3:
4: --{HYU possible_adj
5: TYPE g_amt_rem_type IS RECORD (

Line 409: localdebug('arp_det_dist_pkg.get_gt_sequence()+');

405: FROM DUAL;
406: no_sequence EXCEPTION;
407: BEGIN
408: IF PG_DEBUG = 'Y' THEN
409: localdebug('arp_det_dist_pkg.get_gt_sequence()+');
410: END IF;
411: OPEN c_gt;
412: FETCH c_gt INTO x_gt_id;
413: IF c_gt%NOTFOUND THEN

Line 418: localdebug('arp_det_dist_pkg.get_gt_sequence()-');

414: RAISE no_sequence;
415: END IF;
416: CLOSE c_gt;
417: IF PG_DEBUG = 'Y' THEN
418: localdebug('arp_det_dist_pkg.get_gt_sequence()-');
419: END IF;
420: EXCEPTION
421: WHEN no_sequence THEN
422: IF c_gt%ISOPEN THEN

Line 457: localdebug('arp_det_dist_pkg.set_mode_process()+');

453: WHERE customer_trx_id = p_customer_trx.customer_trx_id;
454: l_mark VARCHAR2(30);
455: BEGIN
456: IF PG_DEBUG = 'Y' THEN
457: localdebug('arp_det_dist_pkg.set_mode_process()+');
458: localdebug(' p_customer_trx.customer_trx_id :'||p_customer_trx.customer_trx_id);
459: localdebug(' p_customer_trx.upgrade_method :'||p_customer_trx.upgrade_method);
460: END IF;
461:

Line 492: localdebug('arp_det_dist_pkg.set_mode_process()-');

488: g_mode_process := 'R12_NLB';
489: END IF;
490: IF PG_DEBUG = 'Y' THEN
491: localdebug(' g_mode_process :'||g_mode_process);
492: localdebug('arp_det_dist_pkg.set_mode_process()-');
493: END IF;
494:
495: END;
496: --}

Line 977: localdebug('arp_det_dist_pkg.return_existing_group()+');

973: IS
974: i NUMBER(15);
975: BEGIN
976: IF PG_DEBUG = 'Y' THEN
977: localdebug('arp_det_dist_pkg.return_existing_group()+');
978: localdebug(' p_groupe '||p_groupe);
979: END IF;
980: x_exist := FALSE;
981: -- ADJ and APP

Line 1197: localdebug('arp_det_dist_pkg.return_existing_group()-');

1193: END IF;
1194: END IF;
1195: END IF;
1196: IF PG_DEBUG = 'Y' THEN
1197: localdebug('arp_det_dist_pkg.return_existing_group()-');
1198: END IF;
1199: END return_existing_group;
1200:
1201: /*------------------------------------------+

Line 1267: localdebug('arp_det_dist_pkg.store_group()+');

1263: l_cnt NUMBER;
1264: i NUMBER(15);
1265: BEGIN
1266: IF PG_DEBUG = 'Y' THEN
1267: localdebug('arp_det_dist_pkg.store_group()+');
1268: localdebug(' p_groupe :'||p_groupe);
1269: -- ADJ and APP
1270: localdebug(' p_run_amt :'||p_run_amt);
1271: localdebug(' p_run_alloc :'||p_run_alloc);

Line 1501: localdebug('arp_det_dist_pkg.store_group()-');

1497: x_group_tbl.run_uned_tax_acctd_alloc(l_cnt+1) := p_run_uned_tax_acctd_alloc;
1498: END IF;
1499: END IF;
1500: IF PG_DEBUG = 'Y' THEN
1501: localdebug('arp_det_dist_pkg.store_group()-');
1502: END IF;
1503: END;
1504:
1505:

Line 1595: localdebug('arp_det_dist_pkg.plsql_proration()+');

1591: l_exist BOOLEAN;
1592: tbl_pro_res_tbl_empty EXCEPTION;
1593: BEGIN
1594: IF PG_DEBUG = 'Y' THEN
1595: localdebug('arp_det_dist_pkg.plsql_proration()+');
1596: END IF;
1597: IF x_tab.ROWID_ID.COUNT = 0 THEN
1598: RAISE tbl_pro_res_tbl_empty;
1599: END IF;

Line 2892: localdebug('arp_det_dist_pkg.plsql_proration()-');

2888: END IF;
2889:
2890: END LOOP;
2891: IF PG_DEBUG = 'Y' THEN
2892: localdebug('arp_det_dist_pkg.plsql_proration()-');
2893: END IF;
2894: EXCEPTION
2895: WHEN tbl_pro_res_tbl_empty THEN
2896: IF PG_DEBUG = 'Y' THEN

Line 3123: localdebug('arp_det_dist_pkg.update_line()+');

3119: l_last_fetch BOOLEAN;
3120:
3121: BEGIN
3122: IF PG_DEBUG = 'Y' THEN
3123: localdebug('arp_det_dist_pkg.update_line()+');
3124: END IF;
3125:
3126: OPEN c_read_for_line;
3127: LOOP

Line 3330: localdebug('arp_det_dist_pkg.update_line()-');

3326:
3327: END LOOP;
3328: CLOSE c_read_for_line;
3329: IF PG_DEBUG = 'Y' THEN
3330: localdebug('arp_det_dist_pkg.update_line()-');
3331: END IF;
3332: END update_line;
3333:
3334:

Line 3346: localdebug('arp_det_dist_pkg.get_invoice_line_info()+');

3342: l_rows NUMBER;
3343:
3344: BEGIN
3345: IF PG_DEBUG = 'Y' THEN
3346: localdebug('arp_det_dist_pkg.get_invoice_line_info()+');
3347: localdebug(' p_mode :'||p_mode);
3348: localdebug(' p_customer_trx_id :'||p_customer_trx_id);
3349: localdebug(' sob_type :'||p_ae_sys_rec.sob_type);
3350: localdebug(' set_of_books_id :'||p_ae_sys_rec.set_of_books_id);

Line 3930: localdebug('arp_det_dist_pkg.get_invoice_line_info()-');

3926: display_ra_ar_gt(p_gt_id => p_gt_id);
3927: END IF;
3928:
3929: IF PG_DEBUG = 'Y' THEN
3930: localdebug('arp_det_dist_pkg.get_invoice_line_info()-');
3931: END IF;
3932: EXCEPTION
3933: WHEN OTHERS THEN
3934: IF PG_DEBUG = 'Y' THEN

Line 3950: localdebug('arp_det_dist_pkg.get_invoice_line_info_cm()+');

3946:
3947: l_rows NUMBER;
3948:
3949: BEGIN
3950: localdebug('arp_det_dist_pkg.get_invoice_line_info_cm()+');
3951: localdebug(' p_mode :'||p_mode);
3952: localdebug(' p_customer_trx_id :'||p_customer_trx_id);
3953: localdebug(' sob_type :'||p_ae_sys_rec.sob_type);
3954: localdebug(' set_of_books_id :'||p_ae_sys_rec.set_of_books_id);

Line 4147: localdebug('arp_det_dist_pkg.get_invoice_line_info_cm()-');

4143: IF PG_DEBUG = 'Y' THEN
4144: display_ra_ar_gt(p_gt_id => p_gt_id);
4145: END IF;
4146:
4147: localdebug('arp_det_dist_pkg.get_invoice_line_info_cm()-');
4148: EXCEPTION
4149: WHEN OTHERS THEN
4150: localdebug('EXCEPTION get_invoice_line_info_cm OTHERS :'||SQLERRM);
4151: END get_invoice_line_info_cm;

Line 4166: localdebug('arp_det_dist_pkg.prepare_group_for_proration()+');

4162: IS
4163: l_rows NUMBER;
4164: BEGIN
4165: IF PG_DEBUG = 'Y' THEN
4166: localdebug('arp_det_dist_pkg.prepare_group_for_proration()+');
4167: END IF;
4168:
4169: IF p_pay_adj = 'APP' THEN
4170: IF(p_app_rec.LINE_EDISCOUNTED IS NOT NULL AND p_app_rec.LINE_EDISCOUNTED <> 0) OR

Line 4706: arp_det_dist_pkg.the_concern_bucket(p_pay_adj,

4702: ---------
4703: -- Bucket
4704: ---------
4705: -- Buc Rev
4706: arp_det_dist_pkg.the_concern_bucket(p_pay_adj,
4707: a.line_type,
4708: 'N',
4709: 'N',
4710: 'N'),

Line 4711: arp_det_dist_pkg.the_concern_bucket(p_pay_adj,

4707: a.line_type,
4708: 'N',
4709: 'N',
4710: 'N'),
4711: arp_det_dist_pkg.the_concern_bucket(p_pay_adj,
4712: a.line_type,
4713: 'Y',
4714: 'N',
4715: 'N'),

Line 4717: arp_det_dist_pkg.the_concern_bucket(p_pay_adj,

4713: 'Y',
4714: 'N',
4715: 'N'),
4716: --Buc Freight
4717: arp_det_dist_pkg.the_concern_bucket(p_pay_adj,
4718: a.line_type,
4719: 'N',
4720: 'N',
4721: 'Y'),

Line 4722: arp_det_dist_pkg.the_concern_bucket(p_pay_adj,

4718: a.line_type,
4719: 'N',
4720: 'N',
4721: 'Y'),
4722: arp_det_dist_pkg.the_concern_bucket(p_pay_adj,
4723: a.line_type,
4724: 'Y',
4725: 'N',
4726: 'Y'),

Line 4728: arp_det_dist_pkg.the_concern_bucket(p_pay_adj,

4724: 'Y',
4725: 'N',
4726: 'Y'),
4727: -- Buc Tax
4728: arp_det_dist_pkg.the_concern_bucket(p_pay_adj,
4729: a.line_type,
4730: 'N',
4731: 'N',
4732: 'N'),

Line 4733: arp_det_dist_pkg.the_concern_bucket(p_pay_adj,

4729: a.line_type,
4730: 'N',
4731: 'N',
4732: 'N'),
4733: arp_det_dist_pkg.the_concern_bucket(p_pay_adj,
4734: a.line_type,
4735: 'Y',
4736: 'N',
4737: 'N'),

Line 4739: arp_det_dist_pkg.the_concern_bucket(p_pay_adj,

4735: 'Y',
4736: 'N',
4737: 'N'),
4738: -- Buc Chrg
4739: arp_det_dist_pkg.the_concern_bucket(p_pay_adj,
4740: a.line_type,
4741: 'N',
4742: 'Y',
4743: 'N'),

Line 4744: arp_det_dist_pkg.the_concern_bucket(p_pay_adj,

4740: a.line_type,
4741: 'N',
4742: 'Y',
4743: 'N'),
4744: arp_det_dist_pkg.the_concern_bucket(p_pay_adj,
4745: a.line_type,
4746: 'Y',
4747: 'Y',
4748: 'N'),

Line 4772: arp_det_dist_pkg.the_concern_bucket('ED',

4768: a.SUM_GP_LINE_CHRG_REM_ACCTD_AMT,
4769:
4770: CASE
4771: when g_ed_req = 'Y' then
4772: arp_det_dist_pkg.the_concern_bucket('ED',
4773: a.line_type,
4774: 'N',
4775: 'N',
4776: 'N')

Line 4780: arp_det_dist_pkg.the_concern_bucket('ED',

4776: 'N')
4777: else 0 end,
4778: CASE
4779: when g_ed_req = 'Y' then
4780: arp_det_dist_pkg.the_concern_bucket('ED',
4781: a.line_type,
4782: 'Y',
4783: 'N',
4784: 'N')

Line 4788: arp_det_dist_pkg.the_concern_bucket('ED',

4784: 'N')
4785: else 0 end,
4786: CASE
4787: when g_ed_req = 'Y' then
4788: arp_det_dist_pkg.the_concern_bucket('ED',
4789: a.line_type,
4790: 'N',
4791: 'N',
4792: 'Y')

Line 4796: arp_det_dist_pkg.the_concern_bucket('ED',

4792: 'Y')
4793: else 0 end,
4794: CASE
4795: when g_ed_req = 'Y' then
4796: arp_det_dist_pkg.the_concern_bucket('ED',
4797: a.line_type,
4798: 'Y',
4799: 'N',
4800: 'Y')

Line 4804: arp_det_dist_pkg.the_concern_bucket('ED',

4800: 'Y')
4801: else 0 end,
4802: CASE
4803: when g_ed_req = 'Y' then
4804: arp_det_dist_pkg.the_concern_bucket('ED',
4805: a.line_type,
4806: 'N',
4807: 'N',
4808: 'N')

Line 4812: arp_det_dist_pkg.the_concern_bucket('ED',

4808: 'N')
4809: else 0 end,
4810: CASE
4811: when g_ed_req = 'Y' then
4812: arp_det_dist_pkg.the_concern_bucket('ED',
4813: a.line_type,
4814: 'Y',
4815: 'N',
4816: 'N')

Line 4820: arp_det_dist_pkg.the_concern_bucket('ED',

4816: 'N')
4817: else 0 end,
4818: CASE
4819: when g_ed_req = 'Y' then
4820: arp_det_dist_pkg.the_concern_bucket('ED',
4821: a.line_type,
4822: 'N',
4823: 'Y',
4824: 'N')

Line 4828: arp_det_dist_pkg.the_concern_bucket('ED',

4824: 'N')
4825: else 0 end,
4826: CASE
4827: when g_ed_req = 'Y' then
4828: arp_det_dist_pkg.the_concern_bucket('ED',
4829: a.line_type,
4830: 'Y',
4831: 'Y',
4832: 'N')

Line 4857: arp_det_dist_pkg.the_concern_bucket('UNED',

4853: a.SUM_GP_LINE_CHRG_REM_ACCTD_AMT,
4854: --
4855: CASE
4856: when g_uned_req = 'Y' then
4857: arp_det_dist_pkg.the_concern_bucket('UNED',
4858: a.line_type,
4859: 'N',
4860: 'N',
4861: 'N')

Line 4865: arp_det_dist_pkg.the_concern_bucket('UNED',

4861: 'N')
4862: else 0 end,
4863: CASE
4864: when g_uned_req = 'Y' then
4865: arp_det_dist_pkg.the_concern_bucket('UNED',
4866: a.line_type,
4867: 'Y',
4868: 'N',
4869: 'N')

Line 4873: arp_det_dist_pkg.the_concern_bucket('UNED',

4869: 'N')
4870: else 0 end,
4871: CASE
4872: when g_uned_req = 'Y' then
4873: arp_det_dist_pkg.the_concern_bucket('UNED',
4874: a.line_type,
4875: 'N',
4876: 'N',
4877: 'Y')

Line 4881: arp_det_dist_pkg.the_concern_bucket('UNED',

4877: 'Y')
4878: else 0 end,
4879: CASE
4880: when g_uned_req = 'Y' then
4881: arp_det_dist_pkg.the_concern_bucket('UNED',
4882: a.line_type,
4883: 'Y',
4884: 'N',
4885: 'Y')

Line 4889: arp_det_dist_pkg.the_concern_bucket('UNED',

4885: 'Y')
4886: else 0 end,
4887: CASE
4888: when g_uned_req = 'Y' then
4889: arp_det_dist_pkg.the_concern_bucket('UNED',
4890: a.line_type,
4891: 'N',
4892: 'N',
4893: 'N')

Line 4897: arp_det_dist_pkg.the_concern_bucket('UNED',

4893: 'N')
4894: else 0 end,
4895: CASE
4896: when g_uned_req = 'Y' then
4897: arp_det_dist_pkg.the_concern_bucket('UNED',
4898: a.line_type,
4899: 'Y',
4900: 'N',
4901: 'N')

Line 4905: arp_det_dist_pkg.the_concern_bucket('UNED',

4901: 'N')
4902: else 0 end,
4903: CASE
4904: when g_uned_req = 'Y' then
4905: arp_det_dist_pkg.the_concern_bucket('UNED',
4906: a.line_type,
4907: 'N',
4908: 'Y',
4909: 'N')

Line 4913: arp_det_dist_pkg.the_concern_bucket('UNED',

4909: 'N')
4910: else 0 end,
4911: CASE
4912: when g_uned_req = 'Y' then
4913: arp_det_dist_pkg.the_concern_bucket('UNED',
4914: a.line_type,
4915: 'Y',
4916: 'Y',
4917: 'N')

Line 4932: localdebug('arp_det_dist_pkg.prepare_group_for_proration()-');

4928: display_ra_ar_gt(p_code => 'GPL',p_gt_id => p_gt_id);
4929: END IF;
4930:
4931: IF PG_DEBUG = 'Y' THEN
4932: localdebug('arp_det_dist_pkg.prepare_group_for_proration()-');
4933: END IF;
4934: END prepare_group_for_proration;
4935:
4936: PROCEDURE dump_g_amt

Line 4989: localdebug('arp_det_dist_pkg.conv_acctd_amt()+');

4985: IS
4986: l_acctd_amt NUMBER;
4987: BEGIN
4988: IF PG_DEBUG = 'Y' THEN
4989: localdebug('arp_det_dist_pkg.conv_acctd_amt()+');
4990: localdebug(' p_pay_adj :'||p_pay_adj);
4991: localdebug(' p_app_rec.AMOUNT_APPLIED :'||p_app_rec.AMOUNT_APPLIED);
4992: localdebug(' p_app_rec.LINE_APPLIED :'||p_app_rec.LINE_APPLIED);
4993: localdebug(' p_app_rec.TAX_APPLIED :'||p_app_rec.TAX_APPLIED);

Line 5149: localdebug('arp_det_dist_pkg.conv_acctd_amt()-');

5145:
5146: END IF;
5147: dump_g_amt;
5148: IF PG_DEBUG = 'Y' THEN
5149: localdebug('arp_det_dist_pkg.conv_acctd_amt()-');
5150: END IF;
5151: END conv_acctd_amt;
5152:
5153: --

Line 5312: localdebug('arp_det_dist_pkg.the_concern_bucket()+');

5308: RETURN NUMBER IS
5309: l_res NUMBER;
5310: BEGIN
5311: IF PG_DEBUG = 'Y' THEN
5312: localdebug('arp_det_dist_pkg.the_concern_bucket()+');
5313: localdebug(' p_pay_adj :' ||p_pay_adj);
5314: localdebug(' p_line_type :' ||p_line_type);
5315: localdebug(' p_acctd :' ||p_acctd);
5316: localdebug(' p_chrg_bucket :' ||p_chrg_bucket);

Line 5482: localdebug('arp_det_dist_pkg.the_concern_bucket()-');

5478: END IF;
5479:
5480: IF PG_DEBUG = 'Y' THEN
5481: localdebug(' l_res : '|| l_res);
5482: localdebug('arp_det_dist_pkg.the_concern_bucket()-');
5483: END IF;
5484: RETURN l_res;
5485: END the_concern_bucket;
5486:

Line 5499: localdebug('arp_det_dist_pkg.prepare_trx_line_proration()+');

5495: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)
5496: IS
5497: BEGIN
5498: IF PG_DEBUG = 'Y' THEN
5499: localdebug('arp_det_dist_pkg.prepare_trx_line_proration()+');
5500: END IF;
5501:
5502:
5503: -- To executed independently

Line 5686: arp_det_dist_pkg.the_concern_bucket(p_pay_adj,

5682: 'LINE' , b.chrg_adj_rem_acctd_amt,
5683: 'CB' , b.chrg_adj_rem_acctd_amt,0))
5684: --Bucket
5685: ,CASE WHEN g_line_flag = 'NORMAL' THEN c.TL_ALLOC_AMT ELSE
5686: arp_det_dist_pkg.the_concern_bucket(p_pay_adj,
5687: b.line_type,
5688: 'N',
5689: 'N',
5690: 'N') END

Line 5692: arp_det_dist_pkg.the_concern_bucket(p_pay_adj,

5688: 'N',
5689: 'N',
5690: 'N') END
5691: ,CASE WHEN g_line_flag = 'NORMAL' THEN c.TL_ALLOC_ACCTD_AMT ELSE
5692: arp_det_dist_pkg.the_concern_bucket(p_pay_adj,
5693: b.line_type,
5694: 'Y',
5695: 'N',
5696: 'N') END

Line 5700: arp_det_dist_pkg.the_concern_bucket(p_pay_adj,

5696: 'N') END
5697: ,c.tl_frt_alloc_amt
5698: ,c.tl_frt_alloc_acctd_amt
5699: ,CASE WHEN g_tax_flag = 'NORMAL' THEN c.TL_TAX_ALLOC_AMT ELSE
5700: arp_det_dist_pkg.the_concern_bucket(p_pay_adj,
5701: b.line_type,
5702: 'N',
5703: 'N',
5704: 'N') END

Line 5706: arp_det_dist_pkg.the_concern_bucket(p_pay_adj,

5702: 'N',
5703: 'N',
5704: 'N') END
5705: ,CASE WHEN g_tax_flag = 'NORMAL' THEN c.TL_TAX_ALLOC_ACCTD_AMT ELSE
5706: arp_det_dist_pkg.the_concern_bucket(p_pay_adj,
5707: b.line_type,
5708: 'Y',
5709: 'N',
5710: 'N') END

Line 5754: arp_det_dist_pkg.the_concern_bucket('ED',

5750: 'CB' , b.chrg_adj_rem_acctd_amt,0)
5751: --Bucket
5752: ,CASE WHEN g_ed_line_flag = 'NORMAL' THEN c.TL_ED_ALLOC_AMT ELSE
5753: CASE when g_ed_req = 'Y' then
5754: arp_det_dist_pkg.the_concern_bucket('ED',
5755: b.line_type,
5756: 'N',
5757: 'N',
5758: 'N')

Line 5764: arp_det_dist_pkg.the_concern_bucket('ED',

5760: END
5761: ,CASE WHEN g_ed_line_flag = 'NORMAL' THEN c.TL_ED_ALLOC_ACCTD_AMT ELSE
5762: CASE
5763: when g_ed_req = 'Y' then
5764: arp_det_dist_pkg.the_concern_bucket('ED',
5765: b.line_type,
5766: 'Y',
5767: 'N',
5768: 'N')

Line 5776: arp_det_dist_pkg.the_concern_bucket('ED',

5772: ,c.TL_ED_FRT_ALLOC_ACCTD_AMT
5773: ,CASE WHEN g_ed_tax_flag = 'NORMAL' THEN c.TL_ED_TAX_ALLOC_AMT ELSE
5774: CASE
5775: when g_ed_req = 'Y' then
5776: arp_det_dist_pkg.the_concern_bucket('ED',
5777: b.line_type,
5778: 'N',
5779: 'N',
5780: 'N')

Line 5786: arp_det_dist_pkg.the_concern_bucket('ED',

5782: END
5783: ,CASE WHEN g_ed_tax_flag = 'NORMAL' THEN c.TL_ED_TAX_ALLOC_ACCTD_AMT ELSE
5784: CASE
5785: when g_ed_req = 'Y' then
5786: arp_det_dist_pkg.the_concern_bucket('ED',
5787: b.line_type,
5788: 'Y',
5789: 'N',
5790: 'N')

Line 5847: arp_det_dist_pkg.the_concern_bucket('UNED',

5843: --Bucket
5844: ,CASE WHEN g_uned_line_flag = 'NORMAL' THEN c.TL_UNED_ALLOC_AMT ELSE
5845: CASE
5846: when g_uned_req = 'Y' then
5847: arp_det_dist_pkg.the_concern_bucket('UNED',
5848: b.line_type,
5849: 'N',
5850: 'N',
5851: 'N')

Line 5857: arp_det_dist_pkg.the_concern_bucket('UNED',

5853: END
5854: ,CASE WHEN g_uned_line_flag = 'NORMAL' THEN c.TL_UNED_ALLOC_ACCTD_AMT ELSE
5855: CASE
5856: when g_uned_req = 'Y' then
5857: arp_det_dist_pkg.the_concern_bucket('UNED',
5858: b.line_type,
5859: 'Y',
5860: 'N',
5861: 'N')

Line 5869: arp_det_dist_pkg.the_concern_bucket('UNED',

5865: ,c.TL_UNED_FRT_ALLOC_ACCTD_AMT
5866: ,CASE WHEN g_uned_tax_flag = 'NORMAL' THEN c.TL_UNED_TAX_ALLOC_AMT ELSE
5867: CASE
5868: when g_uned_req = 'Y' then
5869: arp_det_dist_pkg.the_concern_bucket('UNED',
5870: b.line_type,
5871: 'N',
5872: 'N',
5873: 'N')

Line 5879: arp_det_dist_pkg.the_concern_bucket('UNED',

5875: END
5876: ,CASE WHEN g_uned_tax_flag = 'NORMAL' THEN c.TL_UNED_TAX_ALLOC_ACCTD_AMT ELSE
5877: CASE
5878: when g_uned_req = 'Y' then
5879: arp_det_dist_pkg.the_concern_bucket('UNED',
5880: b.line_type,
5881: 'Y',
5882: 'N',
5883: 'N')

Line 5926: localdebug('arp_det_dist_pkg.prepare_trx_line_proration()-');

5922: display_ra_ar_gt(p_code => 'L', p_gt_id => p_gt_id);
5923: END IF;
5924:
5925: IF PG_DEBUG = 'Y' THEN
5926: localdebug('arp_det_dist_pkg.prepare_trx_line_proration()-');
5927: END IF;
5928: EXCEPTION
5929: WHEN OTHERS THEN
5930: IF PG_DEBUG = 'Y' THEN

Line 5954: localdebug('arp_det_dist_pkg.update_ctl_rem_orig()+');

5950: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)
5951: IS
5952: BEGIN
5953: IF PG_DEBUG = 'Y' THEN
5954: localdebug('arp_det_dist_pkg.update_ctl_rem_orig()+');
5955: localdebug(' p_customer_trx_line_id:'||p_customer_trx_line_id);
5956: localdebug(' p_source_data_key1 :'||p_source_data_key1);
5957: localdebug(' p_source_data_key2 :'||p_source_data_key2);
5958: localdebug(' p_source_data_key3 :'||p_source_data_key3);

Line 6662: localdebug('arp_det_dist_pkg.update_ctl_rem_orig()-');

6658:
6659: END IF; -- End of p_customer_trx_line_id check
6660:
6661: IF PG_DEBUG = 'Y' THEN
6662: localdebug('arp_det_dist_pkg.update_ctl_rem_orig()-');
6663: END IF;
6664: EXCEPTION
6665: WHEN OTHERS THEN
6666: IF PG_DEBUG = 'Y' THEN

Line 6685: localdebug('arp_det_dist_pkg.get_inv_dist()+');

6681:
6682: l_rows NUMBER;
6683: BEGIN
6684: IF PG_DEBUG = 'Y' THEN
6685: localdebug('arp_det_dist_pkg.get_inv_dist()+');
6686: localdebug(' p_ae_sys_rec.set_of_books_id :'||p_ae_sys_rec.set_of_books_id);
6687: localdebug(' p_ae_sys_rec.sob_type :'||p_ae_sys_rec.sob_type);
6688: END IF;
6689:

Line 8556: localdebug('arp_det_dist_pkg.get_inv_dist()-');

8552: l_rows := sql%rowcount;
8553: IF PG_DEBUG = 'Y' THEN
8554: localdebug(' rows inserted(ar_base_dist_amts_gt) = ' || l_rows);
8555:
8556: localdebug('arp_det_dist_pkg.get_inv_dist()-');
8557: END IF;
8558: END get_inv_dist;
8559:
8560:

Line 8783: localdebug('arp_det_dist_pkg.update_dist()+');

8779: l_last_fetch BOOLEAN;
8780:
8781: BEGIN
8782: IF PG_DEBUG = 'Y' THEN
8783: localdebug('arp_det_dist_pkg.update_dist()+');
8784: localdebug(' p_ae_sys_rec.set_of_books_id :'|| p_ae_sys_rec.set_of_books_id);
8785: localdebug(' p_ae_sys_rec.sob_type :'|| p_ae_sys_rec.sob_type);
8786: END IF;
8787: OPEN c_read_for_line;

Line 8990: localdebug('arp_det_dist_pkg.update_dist()-');

8986: END LOOP;
8987: CLOSE c_read_for_line;
8988:
8989: IF PG_DEBUG = 'Y' THEN
8990: localdebug('arp_det_dist_pkg.update_dist()-');
8991: END IF;
8992: EXCEPTION
8993: WHEN OTHERS THEN
8994: IF PG_DEBUG = 'Y' THEN

Line 9012: localdebug('arp_det_dist_pkg.create_split_distribution()+');

9008: l_org_id NUMBER;
9009: l_rows NUMBER;
9010: BEGIN
9011: IF PG_DEBUG = 'Y' THEN
9012: localdebug('arp_det_dist_pkg.create_split_distribution()+');
9013: localdebug(' p_pay_adj :'||p_pay_adj);
9014: localdebug(' p_customer_trx_id:'||p_customer_trx_id);
9015: localdebug(' p_app_level :'||p_app_level);
9016: localdebug(' p_ae_sys_rec.set_of_books_id :'||p_ae_sys_rec.set_of_books_id);

Line 9465: localdebug('arp_det_dist_pkg.create_split_distribution()-');

9461: 'FREIGHT',tax_inc_flag,
9462: 'TAX','Y','N') = 'Y';
9463:
9464: IF PG_DEBUG = 'Y' THEN
9465: localdebug('arp_det_dist_pkg.create_split_distribution()-');
9466: END IF;
9467: EXCEPTION
9468: WHEN OTHERS THEN
9469: IF PG_DEBUG = 'Y' THEN

Line 9501: localdebug('arp_det_dist_pkg.set_original_rem_amt_r12()+');

9497: no_a_valid_trx EXCEPTION;
9498:
9499: BEGIN
9500: IF PG_DEBUG = 'Y' THEN
9501: localdebug('arp_det_dist_pkg.set_original_rem_amt_r12()+');
9502: localdebug(' p_customer_trx.customer_trx_id:'||p_customer_trx.customer_trx_id);
9503: END IF;
9504: OPEN c(p_customer_trx.customer_trx_id);
9505: LOOP

Line 9556: localdebug('arp_det_dist_pkg.set_original_rem_amt_r12()-');

9552: UPDATE ra_customer_trx SET upgrade_method = 'R12'
9553: WHERE customer_trx_id = p_customer_trx.customer_trx_id;
9554:
9555: IF PG_DEBUG = 'Y' THEN
9556: localdebug('arp_det_dist_pkg.set_original_rem_amt_r12()-');
9557: END IF;
9558:
9559: EXCEPTION
9560: WHEN no_a_valid_trx THEN

Line 9600: localdebug('arp_det_dist_pkg.set_original_rem_amt_mfar()+');

9596: l_last_fetch BOOLEAN := FALSE;
9597: l_found VARCHAR2(1);
9598: BEGIN
9599: IF PG_DEBUG = 'Y' THEN
9600: localdebug('arp_det_dist_pkg.set_original_rem_amt_mfar()+');
9601: localdebug(' p_customer_trx.customer_trx_id:'||p_customer_trx.customer_trx_id);
9602: END IF;
9603:
9604: OPEN cmfar(p_customer_trx.customer_trx_id);

Line 9646: localdebug('arp_det_dist_pkg.set_original_rem_amt_mfar()-');

9642: END LOOP;
9643: CLOSE cmfar;
9644:
9645: IF PG_DEBUG = 'Y' THEN
9646: localdebug('arp_det_dist_pkg.set_original_rem_amt_mfar()-');
9647: END IF;
9648: EXCEPTION
9649: WHEN OTHERS THEN
9650: IF cmfar%ISOPEN THEN CLOSE cmfar; END IF;

Line 9747: localdebug('arp_det_dist_pkg.re_calcul_rem_amt()+');

9743: l_last_fetch BOOLEAN := FALSE;
9744:
9745: BEGIN
9746: IF PG_DEBUG = 'Y' THEN
9747: localdebug('arp_det_dist_pkg.re_calcul_rem_amt()+');
9748: localdebug('p_customer_trx_id = ' || p_customer_trx.customer_trx_id);
9749: END IF;
9750: OPEN cu_rem_amt(p_customer_trx.customer_trx_id);
9751: LOOP

Line 9798: localdebug('arp_det_dist_pkg.re_calcul_rem_amt()-');

9794: AND customer_trx_id = p_customer_trx.customer_trx_id;
9795: END LOOP;
9796: CLOSE cu_rem_amt;
9797: IF PG_DEBUG = 'Y' THEN
9798: localdebug('arp_det_dist_pkg.re_calcul_rem_amt()-');
9799: END IF;
9800: EXCEPTION
9801: WHEN OTHERS THEN
9802: IF PG_DEBUG = 'Y' THEN

Line 9869: localdebug('arp_det_dist_pkg.set_original_rem_amt_r12() OVERLOAD +');

9865:
9866: BEGIN
9867:
9868: IF PG_DEBUG = 'Y' THEN
9869: localdebug('arp_det_dist_pkg.set_original_rem_amt_r12() OVERLOAD +');
9870: END IF;
9871:
9872:
9873: OPEN c01;

Line 10026: localdebug('arp_det_dist_pkg.set_original_rem_amt_r12() OVERLOAD -');

10022: -- Setting the Original and Remaining amounts R12 END
10023: --
10024:
10025: IF PG_DEBUG = 'Y' THEN
10026: localdebug('arp_det_dist_pkg.set_original_rem_amt_r12() OVERLOAD -');
10027: END IF;
10028: EXCEPTION
10029:
10030: WHEN OTHERS THEN

Line 10075: localdebug('arp_det_dist_pkg.set_original_rem_amt()+');

10071: no_llca_allowed EXCEPTION;
10072: excep_set_org_rem_amt_r12 EXCEPTION; --LLCA
10073: BEGIN
10074: IF PG_DEBUG = 'Y' THEN
10075: localdebug('arp_det_dist_pkg.set_original_rem_amt()+');
10076: localdebug(' p_adj_id :'||p_adj_id );
10077: localdebug(' p_app_id :'||p_app_id );
10078: END IF;
10079:

Line 10289: localdebug('arp_det_dist_pkg.set_original_rem_amt()-');

10285: END IF; --1
10286: CLOSE c_verif;
10287:
10288: IF PG_DEBUG = 'Y' THEN
10289: localdebug('arp_det_dist_pkg.set_original_rem_amt()-');
10290: END IF;
10291: EXCEPTION
10292: WHEN no_need_to_set_orig_rem_amt THEN
10293: IF c_verif%ISOPEN THEN CLOSE c_verif; END IF;

Line 10296: localdebug('arp_det_dist_pkg.set_original_rem_amt()-');

10292: WHEN no_need_to_set_orig_rem_amt THEN
10293: IF c_verif%ISOPEN THEN CLOSE c_verif; END IF;
10294: IF PG_DEBUG = 'Y' THEN
10295: localdebug(' No need to set orig rem amount');
10296: localdebug('arp_det_dist_pkg.set_original_rem_amt()-');
10297: END IF;
10298:
10299: WHEN no_a_valid_trx THEN
10300: IF c_verif%ISOPEN THEN CLOSE c_verif; END IF;

Line 11215: localdebug('arp_det_dist_pkg.adjustment_detemination()+');

11211: END freight_boundary;
11212: */
11213: BEGIN
11214: IF PG_DEBUG = 'Y' THEN
11215: localdebug('arp_det_dist_pkg.adjustment_detemination()+');
11216: END IF;
11217:
11218: IF p_pay_adj <> 'ADJ' THEN
11219: RAISE not_an_adjustment;

Line 11359: localdebug('arp_det_dist_pkg.adjustment_detemination()-');

11355: l_tax_boundary_done := 'Y';
11356: END IF;
11357:
11358: IF PG_DEBUG = 'Y' THEN
11359: localdebug('arp_det_dist_pkg.adjustment_detemination()-');
11360: END IF;
11361: EXCEPTION
11362: WHEN not_an_adjustment THEN
11363: IF PG_DEBUG = 'Y' THEN

Line 11592: localdebug('arp_det_dist_pkg.update_group_line()+');

11588: l_last_fetch BOOLEAN;
11589:
11590: BEGIN
11591: IF PG_DEBUG = 'Y' THEN
11592: localdebug('arp_det_dist_pkg.update_group_line()+');
11593: END IF;
11594:
11595: OPEN c_read_for_gline;
11596: LOOP

Line 11795: localdebug('arp_det_dist_pkg.update_group_line()-');

11791: END LOOP;
11792: CLOSE c_read_for_gline;
11793:
11794: IF PG_DEBUG = 'Y' THEN
11795: localdebug('arp_det_dist_pkg.update_group_line()-');
11796: END IF;
11797: END update_group_line;
11798:
11799:

Line 11816: localdebug('arp_det_dist_pkg.get_invoice_line_info_per_grp()+');

11812: IS
11813: l_rows NUMBER;
11814: BEGIN
11815: IF PG_DEBUG = 'Y' THEN
11816: localdebug('arp_det_dist_pkg.get_invoice_line_info_per_grp()+');
11817: localdebug(' p_customer_trx_id :'||p_customer_trx_id);
11818: localdebug(' p_source_data_key1 :'||p_source_data_key1);
11819: localdebug(' p_source_data_key2 :'||p_source_data_key2);
11820: localdebug(' p_source_data_key3 :'||p_source_data_key3);

Line 12152: localdebug('arp_det_dist_pkg.get_invoice_line_info_per_grp()-');

12148: l_rows := sql%rowcount;
12149: g_appln_count := g_appln_count + l_rows;
12150: IF PG_DEBUG = 'Y' THEN
12151: localdebug(' rows inserted = ' || l_rows);
12152: localdebug('arp_det_dist_pkg.get_invoice_line_info_per_grp()-');
12153: END IF;
12154: END get_invoice_line_info_per_grp;
12155:
12156:

Line 12167: localdebug('arp_det_dist_pkg.get_invoice_line_info_per_line()+');

12163: IS
12164: l_rows NUMBER;
12165: BEGIN
12166: IF PG_DEBUG = 'Y' THEN
12167: localdebug('arp_det_dist_pkg.get_invoice_line_info_per_line()+');
12168: localdebug(' p_customer_trx_id :'||p_customer_trx_id);
12169: localdebug(' p_customer_trx_line_id :'||p_customer_trx_line_id);
12170: localdebug(' p_gt_id :'||p_gt_id);
12171: END IF;

Line 12410: localdebug('arp_det_dist_pkg.get_invoice_line_info_per_line()-');

12406: l_rows := sql%rowcount;
12407: g_appln_count := g_appln_count + l_rows;
12408: IF PG_DEBUG = 'Y' THEN
12409: localdebug(' rows inserted = ' || l_rows);
12410: localdebug('arp_det_dist_pkg.get_invoice_line_info_per_line()-');
12411: END IF;
12412: END get_invoice_line_info_per_line;
12413:
12414: PROCEDURE proration_app_dist_trx

Line 12424: localdebug('arp_det_dist_pkg.proration_app_dist_trx()+');

12420: IS
12421: l_adj_rec ar_adjustments%ROWTYPE;
12422: BEGIN
12423: IF PG_DEBUG = 'Y' THEN
12424: localdebug('arp_det_dist_pkg.proration_app_dist_trx()+');
12425: localdebug(' p_gt_id :'||p_gt_id );
12426: localdebug(' application type :'||p_app_rec.application_type );
12427: localdebug(' receivable_application_id:'||p_app_rec.receivable_application_id );
12428: localdebug(' set of books id :'||p_ae_sys_rec.set_of_books_id );

Line 12453: localdebug('arp_det_dist_pkg.proration_app_dist_trx()-');

12449: p_app_level => p_app_level,
12450: p_ae_sys_rec => p_ae_sys_rec);
12451:
12452: IF PG_DEBUG = 'Y' THEN
12453: localdebug('arp_det_dist_pkg.proration_app_dist_trx()-');
12454: END IF;
12455:
12456: END proration_app_dist_trx;
12457:

Line 12469: localdebug('arp_det_dist_pkg.proration_adj_dist_trx()+');

12465: IS
12466: l_app_rec ar_receivable_applications%ROWTYPE;
12467: BEGIN
12468: IF PG_DEBUG = 'Y' THEN
12469: localdebug('arp_det_dist_pkg.proration_adj_dist_trx()+');
12470: localdebug(' p_gt_id :'||p_gt_id );
12471: localdebug(' adj type :'||p_adj_rec.adjustment_type );
12472: localdebug(' adjustments_id :'||p_adj_rec.adjustment_id );
12473: localdebug(' set of books id :'||p_ae_sys_rec.set_of_books_id );

Line 12512: localdebug('arp_det_dist_pkg.proration_adj_dist_trx()-');

12508: p_app_level => p_app_level,
12509: p_ae_sys_rec => p_ae_sys_rec);
12510:
12511: IF PG_DEBUG = 'Y' THEN
12512: localdebug('arp_det_dist_pkg.proration_adj_dist_trx()-');
12513: END IF;
12514:
12515: END proration_adj_dist_trx;
12516:

Line 12550: localdebug('arp_det_dist_pkg.trx_level_cash_apply()+');

12546: excep_get_gt_sequence EXCEPTION;
12547: summrize_act_no_llca EXCEPTION;
12548: BEGIN
12549: IF PG_DEBUG = 'Y' THEN
12550: localdebug('arp_det_dist_pkg.trx_level_cash_apply()+');
12551: localdebug(' p_customer_trx_id :'||p_customer_trx.customer_trx_id);
12552: END IF;
12553: g_cust_inv_rec := p_customer_trx;
12554:

Line 12662: localdebug('arp_det_dist_pkg.trx_level_cash_apply()-');

12658: -- p_app_level => 'TRANSACTION');
12659: -- END IF;
12660:
12661: IF PG_DEBUG = 'Y' THEN
12662: localdebug('arp_det_dist_pkg.trx_level_cash_apply()-');
12663: END IF;
12664: EXCEPTION
12665: WHEN excep_get_gt_sequence THEN
12666: IF PG_DEBUG = 'Y' THEN

Line 12734: localdebug('arp_det_dist_pkg.trx_gp_level_cash_apply()+');

12730: excep_get_gt_sequence EXCEPTION;
12731: summrize_act_no_llca EXCEPTION;
12732: BEGIN
12733: IF PG_DEBUG = 'Y' THEN
12734: localdebug('arp_det_dist_pkg.trx_gp_level_cash_apply()+');
12735: localdebug(' p_customer_trx_id :'||p_customer_trx.customer_trx_id);
12736: localdebug(' p_source_data_key1 :'||p_source_data_key1);
12737: localdebug(' p_source_data_key2 :'||p_source_data_key2);
12738: localdebug(' p_source_data_key3 :'||p_source_data_key3);

Line 12874: localdebug('arp_det_dist_pkg.trx_gp_level_cash_apply()-');

12870: -- p_app_level => 'GROUP');
12871: -- END IF;
12872:
12873: IF PG_DEBUG = 'Y' THEN
12874: localdebug('arp_det_dist_pkg.trx_gp_level_cash_apply()-');
12875: END IF;
12876: EXCEPTION
12877: WHEN excep_get_gt_sequence THEN
12878: IF PG_DEBUG = 'Y' THEN

Line 12941: localdebug('arp_det_dist_pkg.trx_line_level_cash_apply()+');

12937: excep_get_gt_sequence EXCEPTION;
12938: summrize_act_no_llca EXCEPTION;
12939: BEGIN
12940: IF PG_DEBUG = 'Y' THEN
12941: localdebug('arp_det_dist_pkg.trx_line_level_cash_apply()+');
12942: localdebug(' p_customer_trx_id :'||p_customer_trx.customer_trx_id);
12943: localdebug(' p_customer_trx_line_id :'||p_customer_trx_line_id);
12944: END IF;
12945:

Line 13062: localdebug('arp_det_dist_pkg.trx_line_level_cash_apply()-');

13058: -- p_app_level => 'LINE');
13059: -- END IF;
13060:
13061: IF PG_DEBUG = 'Y' THEN
13062: localdebug('arp_det_dist_pkg.trx_line_level_cash_apply()-');
13063: END IF;
13064: EXCEPTION
13065: WHEN excep_get_gt_sequence THEN
13066: IF PG_DEBUG = 'Y' THEN

Line 13128: localdebug('arp_det_dist_pkg.copy_trx_lines()+');

13124: l_rows NUMBER;
13125:
13126: BEGIN
13127: IF PG_DEBUG = 'Y' THEN
13128: localdebug('arp_det_dist_pkg.copy_trx_lines()+');
13129: localdebug(' p_customer_trx_id :'||p_customer_trx_id);
13130: END IF;
13131: OPEN cu_line_loaded(p_customer_trx_id, p_customer_trx_line_id);
13132: FETCH cu_line_loaded INTO l_exist;

Line 13447: localdebug('arp_det_dist_pkg.copy_trx_lines()-');

13443: IF (PG_DEBUG = 'Y') THEN
13444: display_cust_trx_gt(p_customer_trx_id => p_customer_trx_id);
13445: END IF;
13446: IF PG_DEBUG = 'Y' THEN
13447: localdebug('arp_det_dist_pkg.copy_trx_lines()-');
13448: END IF;
13449: EXCEPTION
13450: WHEN OTHERS THEN
13451: IF PG_DEBUG = 'Y' THEN

Line 13503: localdebug('arp_det_dist_pkg.final_update_inv_ctl_rem_orig()+');

13499: l_amt_due_orig_ps number;
13500:
13501: BEGIN
13502: IF PG_DEBUG = 'Y' THEN
13503: localdebug('arp_det_dist_pkg.final_update_inv_ctl_rem_orig()+');
13504: END IF;
13505:
13506: l_boundary_flag := 'N';
13507:

Line 13589: localdebug('arp_det_dist_pkg.final_update_inv_ctl_rem_orig()-');

13585:
13586: END LOOP;
13587: CLOSE c;
13588: IF PG_DEBUG = 'Y' THEN
13589: localdebug('arp_det_dist_pkg.final_update_inv_ctl_rem_orig()-');
13590: END IF;
13591: END final_update_inv_ctl_rem_orig;
13592:
13593:

Line 13602: localdebug('arp_det_dist_pkg.create_final_split()+');

13598: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type)
13599: IS
13600: BEGIN
13601: IF PG_DEBUG = 'Y' THEN
13602: localdebug('arp_det_dist_pkg.create_final_split()+');
13603: -- From distributions
13604: localdebug(' p_app_rec.ACCTD_AMOUNT_APPLIED_FROM :'||p_app_rec.ACCTD_AMOUNT_APPLIED_FROM);
13605: localdebug(' p_app_rec.AMOUNT_APPLIED_FROM :'||p_app_rec.AMOUNT_APPLIED_FROM );
13606: END IF;

Line 13640: localdebug('arp_det_dist_pkg.create_final_split()-');

13636: diag_data;
13637: END IF;
13638: -- END IF;
13639: IF PG_DEBUG = 'Y' THEN
13640: localdebug('arp_det_dist_pkg.create_final_split()-');
13641: END IF;
13642: END create_final_split;
13643:
13644: /*-------------------------------------------------------------------------+

Line 13674: localdebug('arp_det_dist_pkg.trx_level_direct_adjust()+');

13670: l_msg_data VARCHAR2(2000);
13671: excep_get_gt_sequence EXCEPTION;
13672: BEGIN
13673: IF PG_DEBUG = 'Y' THEN
13674: localdebug('arp_det_dist_pkg.trx_level_direct_adjust()+');
13675: localdebug(' p_customer_trx_id :'||p_customer_trx.customer_trx_id);
13676: END IF;
13677:
13678: IF p_gt_id IS NULL THEN

Line 13787: localdebug('arp_det_dist_pkg.trx_level_direct_adjust()-');

13783: WHERE adjustment_id = p_adj_rec.adjustment_id;
13784: END IF;
13785:
13786: IF PG_DEBUG = 'Y' THEN
13787: localdebug('arp_det_dist_pkg.trx_level_direct_adjust()-');
13788: END IF;
13789: EXCEPTION
13790: WHEN excep_get_gt_sequence THEN
13791: IF PG_DEBUG = 'Y' THEN

Line 13839: localdebug('arp_det_dist_pkg.trx_level_direct_cash_apply()+');

13835: l_adj_exists VARCHAR2(1) := 'Y';
13836: excep_get_gt_sequence EXCEPTION;
13837: BEGIN
13838: IF PG_DEBUG = 'Y' THEN
13839: localdebug('arp_det_dist_pkg.trx_level_direct_cash_apply()+');
13840: localdebug(' p_customer_trx_id :'||p_customer_trx.customer_trx_id);
13841: localdebug(' p_inv_cm :'||p_inv_cm);
13842: END IF;
13843:

Line 14062: localdebug('arp_det_dist_pkg.trx_level_direct_cash_apply()-');

14058: p_ae_sys_rec => p_ae_sys_rec);
14059:
14060:
14061: IF PG_DEBUG = 'Y' THEN
14062: localdebug('arp_det_dist_pkg.trx_level_direct_cash_apply()-');
14063: END IF;
14064: EXCEPTION
14065: WHEN excep_get_gt_sequence THEN
14066: IF PG_DEBUG = 'Y' THEN

Line 14321: localdebug( 'arp_det_dist_pkg.display_ra_ar_row()-');

14317: localdebug( ' tl_uned_tax_alloc_acctd_amt :'|| p_ra_ar_rec.TL_UNED_TAX_ALLOC_ACCTD_AMT);
14318: -- localdebug( ' buc_uned_alloc_amt :'|| p_ra_ar_rec.BUC_UNED_ALLOC_AMT);
14319: -- localdebug( ' buc_uned_alloc_acctd_amt :'|| p_ra_ar_rec.BUC_UNED_ALLOC_ACCTD_AMT);
14320: localdebug( ' tl_frt_alloc_amt :'|| p_ra_ar_rec.TL_FRT_ALLOC_AMT);
14321: localdebug( 'arp_det_dist_pkg.display_ra_ar_row()-');
14322: END IF;
14323: END;
14324:
14325:

Line 14343: localdebug('arp_det_dist_pkg.display_ra_ar_gt()+');

14339: l_record c1%ROWTYPE;
14340: l_record2 c2%ROWTYPE;
14341: BEGIN
14342: IF (PG_DEBUG = 'Y') THEN
14343: localdebug('arp_det_dist_pkg.display_ra_ar_gt()+');
14344: localdebug(' p_code : '||p_code);
14345: IF p_code IS NULL THEN
14346: OPEN c1;
14347: LOOP

Line 14362: localdebug('arp_det_dist_pkg.display_ra_ar_gt()-');

14358: display_ra_ar_row(l_record2);
14359: END LOOP;
14360: CLOSE c2;
14361: END IF;
14362: localdebug('arp_det_dist_pkg.display_ra_ar_gt()-');
14363: END IF;
14364: END;
14365:
14366:

Line 14372: localdebug('arp_det_dist_pkg.display_cust_trx_row()+');

14368: (p_record IN ra_customer_trx_lines_gt%ROWTYPE)
14369: IS
14370: BEGIN
14371: IF PG_DEBUG = 'Y' THEN
14372: localdebug('arp_det_dist_pkg.display_cust_trx_row()+');
14373: localdebug(' CUSTOMER_TRX_LINE_ID :'|| p_record.CUSTOMER_TRX_LINE_ID);
14374: localdebug(' LINK_TO_CUST_TRX_LINE_ID :'|| p_record.LINK_TO_CUST_TRX_LINE_ID);
14375: localdebug(' CUSTOMER_TRX_ID :'|| p_record.CUSTOMER_TRX_ID);
14376: localdebug(' SET_OF_BOOKS_ID :'|| p_record.SET_OF_BOOKS_ID);

Line 14399: localdebug('arp_det_dist_pkg.display_cust_trx_row()-');

14395: localdebug(' CM_AMT_DUE_REM :'|| p_record.CM_AMT_DUE_REM);
14396: localdebug(' CM_ACCTD_AMT_DUE_REM :'|| p_record.CM_ACCTD_AMT_DUE_REM);
14397: localdebug(' CM_AMT_DUE_ORIG :'|| p_record.CM_AMT_DUE_ORIG);
14398: localdebug(' CM_ACCTD_AMT_DUE_ORIG :'|| p_record.CM_ACCTD_AMT_DUE_ORIG);
14399: localdebug('arp_det_dist_pkg.display_cust_trx_row()-');
14400: END IF;
14401: END;
14402:
14403: PROCEDURE display_cust_trx_gt(p_customer_trx_id IN NUMBER)

Line 14412: localdebug('arp_det_dist_pkg.display_cust_trx_gt()+');

14408: WHERE customer_trx_id = p_customer_trx_id;
14409: l_record c%ROWTYPE;
14410: BEGIN
14411: IF PG_DEBUG = 'Y' THEN
14412: localdebug('arp_det_dist_pkg.display_cust_trx_gt()+');
14413: END IF;
14414: OPEN c;
14415: LOOP
14416: FETCH c INTO l_record;

Line 14422: localdebug('arp_det_dist_pkg.display_cust_trx_gt()-');

14418: display_cust_trx_row(l_record);
14419: END LOOP;
14420: CLOSE c;
14421: IF PG_DEBUG = 'Y' THEN
14422: localdebug('arp_det_dist_pkg.display_cust_trx_gt()-');
14423: END IF;
14424: END;
14425:
14426:

Line 14455: localdebug('arp_det_dist_pkg.get_orig_amt()+');

14451: l_type VARCHAR2(30);
14452: l_id NUMBER;
14453: BEGIN
14454: IF PG_DEBUG = 'Y' THEN
14455: localdebug('arp_det_dist_pkg.get_orig_amt()+');
14456: localdebug(' p_customer_trx_id :'||p_customer_trx_id);
14457: END IF;
14458: x_amt_rem.sum_line_amt_orig := 0;
14459: x_amt_rem.sum_tax_amt_orig := 0;

Line 14494: localdebug('arp_det_dist_pkg.get_orig_amt()-');

14490: END IF;
14491: CLOSE tl_for_rl;
14492: IF PG_DEBUG = 'Y' THEN
14493: localdebug(' x_amt_rem.tl_for_rl :'||x_amt_rem.tl_for_rl);
14494: localdebug('arp_det_dist_pkg.get_orig_amt()-');
14495: END IF;
14496: END;
14497:
14498:

Line 14522: localdebug('arp_det_dist_pkg.ed_uned_type()+');

14518: IS
14519: l_res VARCHAR2(1) := 'N';
14520: BEGIN
14521: IF PG_DEBUG = 'Y' THEN
14522: localdebug('arp_det_dist_pkg.ed_uned_type()+');
14523: localdebug(' p_source_exec :'||p_source_exec);
14524: localdebug(' p_bucket :'||p_bucket);
14525: END IF;
14526: IF p_source_exec = 'ED' THEN

Line 14549: localdebug('arp_det_dist_pkg.ed_uned_type()-');

14545: END IF;
14546: END IF;
14547: IF PG_DEBUG = 'Y' THEN
14548: localdebug(' l_res :'||l_res);
14549: localdebug('arp_det_dist_pkg.ed_uned_type()-');
14550: END IF;
14551: RETURN l_res;
14552: END;
14553:

Line 14587: localdebug('arp_det_dist_pkg.tax_adj_type()+');

14583: l_amt NUMBER;
14584: l_res VARCHAR2(30);
14585: BEGIN
14586: IF PG_DEBUG = 'Y' THEN
14587: localdebug('arp_det_dist_pkg.tax_adj_type()+');
14588: localdebug(' p_source_exec:'||p_source_exec);
14589: END IF;
14590: IF p_source_exec = 'ADJ' THEN
14591: IF p_adj_rec.type = 'TAX' AND (nvl(p_adj_rec.amount,0) <> 0) THEN

Line 14662: localdebug('arp_det_dist_pkg.tax_adj_type()-');

14658: END IF;
14659: END IF;
14660: IF PG_DEBUG = 'Y' THEN
14661: localdebug(' l_res:'||l_res);
14662: localdebug('arp_det_dist_pkg.tax_adj_type()-');
14663: END IF;
14664: RETURN l_res;
14665: END;
14666:

Line 14700: localdebug('arp_det_dist_pkg.line_adj_type()+');

14696: IS
14697: l_res VARCHAR2(30);
14698: BEGIN
14699: IF PG_DEBUG = 'Y' THEN
14700: localdebug('arp_det_dist_pkg.line_adj_type()+');
14701: localdebug(' p_source_exec:'||p_source_exec);
14702: END IF;
14703: IF p_source_exec = 'ADJ' THEN
14704: IF p_adj_rec.type = 'LINE' AND (nvl(p_adj_rec.amount,0) <> 0) THEN

Line 14746: localdebug('arp_det_dist_pkg.chrg_adj_type()-');

14742:
14743: END IF;
14744: IF PG_DEBUG = 'Y' THEN
14745: localdebug(' l_res:'||l_res);
14746: localdebug('arp_det_dist_pkg.chrg_adj_type()-');
14747: END IF;
14748: RETURN l_res;
14749: END;
14750:

Line 14784: localdebug('arp_det_dist_pkg.frt_adj_type()+');

14780: IS
14781: l_res VARCHAR2(30);
14782: BEGIN
14783: IF PG_DEBUG = 'Y' THEN
14784: localdebug('arp_det_dist_pkg.frt_adj_type()+');
14785: localdebug(' p_source_exec:'||p_source_exec);
14786: END IF;
14787: IF p_source_exec = 'ADJ' THEN
14788: IF p_adj_rec.type = 'FREIGHT' AND (nvl(p_adj_rec.amount,0) <> 0) THEN

Line 14846: localdebug('arp_det_dist_pkg.frt_adj_type()-');

14842: END IF;
14843: END IF;
14844: IF PG_DEBUG = 'Y' THEN
14845: localdebug(' l_res:'||l_res);
14846: localdebug('arp_det_dist_pkg.frt_adj_type()-');
14847: END IF;
14848: RETURN l_res;
14849: END;
14850:

Line 14883: localdebug('arp_det_dist_pkg.chrg_adj_type()+');

14879: l_tot_frt_rev NUMBER;
14880: l_tot_frt NUMBER;
14881: BEGIN
14882: IF PG_DEBUG = 'Y' THEN
14883: localdebug('arp_det_dist_pkg.chrg_adj_type()+');
14884: localdebug(' p_source_exec:'||p_source_exec);
14885: END IF;
14886: IF p_source_exec = 'ADJ' THEN
14887: IF p_adj_rec.type = 'CHARGES' AND (nvl(p_adj_rec.amount,0) <> 0) THEN

Line 14922: localdebug('arp_det_dist_pkg.chrg_adj_type()-');

14918: END IF;
14919: END IF;
14920: IF PG_DEBUG = 'Y' THEN
14921: localdebug(' l_res:'||l_res);
14922: localdebug('arp_det_dist_pkg.chrg_adj_type()-');
14923: END IF;
14924: RETURN l_res;
14925: END;
14926:

Line 14968: localdebug('arp_det_dist_pkg.possible_adjust()+');

14964: l_line_adj VARCHAR2(100);
14965: l_chrg_adj VARCHAR2(100);
14966: BEGIN
14967: IF PG_DEBUG = 'Y' THEN
14968: localdebug('arp_det_dist_pkg.possible_adjust()+');
14969: END IF;
14970:
14971: x_return_status := FND_API.G_RET_STS_SUCCESS;
14972:

Line 15067: localdebug('arp_det_dist_pkg.possible_adjust()-');

15063: END IF;
15064:
15065: IF PG_DEBUG = 'Y' THEN
15066: localdebug(' x_return_status :'||x_return_status);
15067: localdebug('arp_det_dist_pkg.possible_adjust()-');
15068: END IF;
15069: END;
15070:
15071:

Line 15152: localdebug('arp_det_dist_pkg.Accting_Proration_Fct()+');

15148: l_run_total NUMBER;
15149: l_currency VARCHAR2(30);
15150: BEGIN
15151: IF PG_DEBUG = 'Y' THEN
15152: localdebug('arp_det_dist_pkg.Accting_Proration_Fct()+');
15153: localdebug(' p_temp_amt : '||p_temp_amt );
15154: localdebug(' p_base_proration : '||p_base_proration);
15155: localdebug(' p_alloc_amount : '||p_alloc_amount );
15156: localdebug(' p_base_currency : '||p_base_currency );

Line 15217: localdebug('arp_det_dist_pkg.Accting_Proration_Fct()-');

15213: END IF;
15214:
15215: IF PG_DEBUG = 'Y' THEN
15216: localdebug(' l_result : '|| l_result);
15217: localdebug('arp_det_dist_pkg.Accting_Proration_Fct()-');
15218: END IF;
15219: RETURN l_result;
15220: EXCEPTION
15221: WHEN OTHERS THEN

Line 15285: localdebug('arp_det_dist_pkg.update_from_gt()+');

15281: l_trx_exch_rate NUMBER;
15282: l_app_exch_rate NUMBER;
15283: BEGIN
15284: IF PG_DEBUG = 'Y' THEN
15285: localdebug('arp_det_dist_pkg.update_from_gt()+');
15286: END IF;
15287:
15288: --{LLCA CROSS CURRENCY
15289: IF p_gt_id IS NULL THEN

Line 15503: localdebug('arp_det_dist_pkg.update_from_gt()-');

15499: AND a.gt_id = l_gt_id;
15500:
15501: END IF;
15502: IF PG_DEBUG = 'Y' THEN
15503: localdebug('arp_det_dist_pkg.update_from_gt()-');
15504: END IF;
15505: EXCEPTION
15506: WHEN no_from_amount_required THEN
15507: IF PG_DEBUG = 'Y' THEN

Line 15556: localdebug('arp_det_dist_pkg.exec_adj_api_if_required()+');

15552: ram_api_error EXCEPTION;
15553:
15554: BEGIN
15555: IF PG_DEBUG = 'Y' THEN
15556: localdebug('arp_det_dist_pkg.exec_adj_api_if_required()+');
15557: localdebug(' p_adj_rec.adjustment_id :' || p_adj_rec.adjustment_id);
15558: localdebug(' p_app_rec.receivable_application_id:' || p_app_rec.receivable_application_id);
15559: localdebug(' p_cust_inv_rec.customer_trx_id :' || p_cust_inv_rec.customer_trx_id);
15560: END IF;

Line 15657: localdebug('arp_det_dist_pkg.exec_adj_api_if_required()-');

15653: END IF;
15654:
15655: END IF;
15656: IF PG_DEBUG = 'Y' THEN
15657: localdebug('arp_det_dist_pkg.exec_adj_api_if_required()-');
15658: END IF;
15659: EXCEPTION
15660: WHEN ram_api_error THEN
15661: IF PG_DEBUG = 'Y' THEN

Line 15689: localdebug('arp_det_dist_pkg.exec_revrec_if_required()+');

15685: l_rev_rec_req BOOLEAN;
15686: l_sum_dist NUMBER;
15687: BEGIN
15688: IF PG_DEBUG = 'Y' THEN
15689: localdebug('arp_det_dist_pkg.exec_revrec_if_required()+');
15690: localdebug(' p_customer_trx_id :' || p_customer_trx_id);
15691: localdebug(' p_app_rec.receivable_application_id :' || p_app_rec.receivable_application_id);
15692: localdebug(' p_adj_rec.adjustment_id :' || p_adj_rec.adjustment_id);
15693:

Line 15724: localdebug( 'arp_det_dist_pkg.exec_revrec_if_required()-');

15720: localdebug(' Completed running revenue recognition for Transaction');
15721: END IF;
15722: END IF;
15723: IF PG_DEBUG = 'Y' THEN
15724: localdebug( 'arp_det_dist_pkg.exec_revrec_if_required()-');
15725: END IF;
15726: EXCEPTION
15727: WHEN OTHERS THEN
15728: IF PG_DEBUG = 'Y' THEN

Line 15764: localdebug('arp_det_dist_pkg.exec_revrec_if_required()+');

15760: l_rev_rec_req BOOLEAN;
15761: wrong_parameter EXCEPTION;
15762: BEGIN
15763: IF PG_DEBUG = 'Y' THEN
15764: localdebug('arp_det_dist_pkg.exec_revrec_if_required()+');
15765: localdebug(' p_mode :' || p_mode);
15766: localdebug(' p_customer_trx_id :' || p_customer_trx_id);
15767: localdebug(' p_request_id :' || p_request_id);
15768: END IF;

Line 15840: localdebug( 'arp_det_dist_pkg.exec_revrec_if_required()-');

15836: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
15837: RAISE fnd_api.G_EXC_ERROR;
15838: END IF;
15839: IF PG_DEBUG = 'Y' THEN
15840: localdebug( 'arp_det_dist_pkg.exec_revrec_if_required()-');
15841: END IF;
15842: EXCEPTION
15843: WHEN fnd_api.G_EXC_ERROR THEN
15844: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 16205: localdebug('arp_det_dist_pkg.update_tax()+');

16201: l_last_fetch BOOLEAN;
16202:
16203: BEGIN
16204: IF PG_DEBUG = 'Y' THEN
16205: localdebug('arp_det_dist_pkg.update_tax()+');
16206: localdebug(' p_ae_sys_rec.set_of_books_id');
16207: localdebug(' p_ae_sys_rec.sob_type');
16208: END IF;
16209: OPEN c_read_for_taxable;

Line 16384: localdebug('arp_det_dist_pkg.update_taxable()-');

16380: END LOOP;
16381: CLOSE c_read_for_taxable;
16382:
16383: IF PG_DEBUG = 'Y' THEN
16384: localdebug('arp_det_dist_pkg.update_taxable()-');
16385: END IF;
16386: EXCEPTION
16387: WHEN OTHERS THEN
16388: IF PG_DEBUG = 'Y' THEN

Line 16707: localdebug('arp_det_dist_pkg.update_mrc_for_dist()+');

16703: l_from_curr_code VARCHAR2(30);
16704:
16705: BEGIN
16706: IF PG_DEBUG = 'Y' THEN
16707: localdebug('arp_det_dist_pkg.update_mrc_for_dist()+');
16708: END IF;
16709:
16710: IF p_app_rec.receivable_application_id IS NOT NULL THEN
16711: l_acctd_adj_app_to:= NVL(p_app_rec.acctd_amount_applied_to,0) * -1;

Line 16946: localdebug('arp_det_dist_pkg.update_for_mrc_dist()-');

16942:
16943: END LOOP;
16944: CLOSE c_mrc;
16945: IF PG_DEBUG = 'Y' THEN
16946: localdebug('arp_det_dist_pkg.update_for_mrc_dist()-');
16947: END IF;
16948: END update_for_mrc_dist;
16949:
16950:

Line 17534: localdebug('arp_det_dist_pkg.check_legacy_status()+');

17530: l_record c%ROWTYPE;
17531:
17532: BEGIN
17533: IF PG_DEBUG = 'Y' THEN
17534: localdebug('arp_det_dist_pkg.check_legacy_status()+');
17535: END IF;
17536:
17537: OPEN c;
17538: FETCH c INTO l_record;

Line 17580: localdebug('arp_det_dist_pkg.check_legacy_status()-');

17576: localdebug(' 11i adj existence :'||x_11i_adj);
17577: localdebug(' 11i mfar adj existence:'||x_mfar_adj);
17578: localdebug(' 11i app existence :'||x_11i_app);
17579: localdebug(' 11i mfar app existence:'||x_mfar_app);
17580: localdebug('arp_det_dist_pkg.check_legacy_status()-');
17581: END IF;
17582: EXCEPTION
17583: WHEN OTHERS THEN
17584: IF PG_DEBUG = 'Y' THEN

Line 17606: localdebug('arp_det_dist_pkg.check_lazy_apply_req()+');

17602: AND adj.upgrade_method IN ('11I','11IMFAR') ;
17603:
17604: BEGIN
17605: IF PG_DEBUG = 'Y' THEN
17606: localdebug('arp_det_dist_pkg.check_lazy_apply_req()+');
17607: END IF;
17608: OPEN c11I;
17609: FETCH c11I INTO x_out_res;
17610: IF c11I%NOTFOUND THEN

Line 17616: localdebug('arp_det_dist_pkg.check_lazy_apply_req()-');

17612: END IF;
17613: CLOSE c11I;
17614: IF PG_DEBUG = 'Y' THEN
17615: localdebug(' x_out_res : '|| x_out_res);
17616: localdebug('arp_det_dist_pkg.check_lazy_apply_req()-');
17617: END IF;
17618: END;
17619:
17620:

Line 17656: localdebug('arp_det_dist_pkg.Online_lazy_apply()+');

17652: l_adj_rec ar_adjustments%ROWTYPE;
17653: l_app_rec ar_receivable_applications%ROWTYPE;
17654: BEGIN
17655: IF PG_DEBUG = 'Y' THEN
17656: localdebug('arp_det_dist_pkg.Online_lazy_apply()+');
17657: localdebug(' p_app_rec.applied_customer_trx_id : '||p_app_rec.applied_customer_trx_id);
17658: localdebug(' p_gt_id : '||p_gt_id);
17659: END IF;
17660:

Line 17844: localdebug('arp_det_dist_pkg.Online_lazy_apply()-');

17840: WHERE receivable_application_id = l_app_rec.receivable_application_id;
17841: END IF;
17842:
17843: IF PG_DEBUG = 'Y' THEN
17844: localdebug('arp_det_dist_pkg.Online_lazy_apply()-');
17845: END IF;
17846: EXCEPTION
17847: WHEN OTHERS THEN
17848: localdebug('OTHERS : Online_lazy_apply '||SQLERRM);

Line 17930: localdebug('arp_det_dist_pkg.get_latest_amount_remaining()+');

17926: AND source_data_key4 = p_source_data_key4
17927: AND source_data_key5 = p_source_data_key5;
17928: BEGIN
17929: IF PG_DEBUG = 'Y' THEN
17930: localdebug('arp_det_dist_pkg.get_latest_amount_remaining()+');
17931: localdebug(' p_customer_trx_id :'||p_customer_trx_id);
17932: localdebug(' p_app_level :'||p_app_level);
17933: localdebug(' p_source_data_key1:'||p_source_data_key1);
17934: localdebug(' p_source_data_key2:'||p_source_data_key2);

Line 17960: localdebug('arp_det_dist_pkg.get_latest_amount_remaining()-');

17956: localdebug(' x_line_rem :'||x_line_rem);
17957: localdebug(' x_tax_rem :'||x_tax_rem);
17958: localdebug(' x_freight_rem :'||x_freight_rem);
17959: localdebug(' x_charges_rem :'||x_charges_rem);
17960: localdebug('arp_det_dist_pkg.get_latest_amount_remaining()-');
17961: END IF;
17962: EXCEPTION
17963: WHEN NO_DATA_FOUND THEN
17964: IF PG_DEBUG = 'Y' THEN

Line 18101: localdebug('arp_det_dist_pkg.convert_ra_inv_to_cm()+');

18097: no_rem_for_trx_upg EXCEPTION;
18098:
18099: BEGIN
18100: IF PG_DEBUG = 'Y' THEN
18101: localdebug('arp_det_dist_pkg.convert_ra_inv_to_cm()+');
18102: localdebug(' p_cm_trx_id :' || p_cm_trx_id);
18103: localdebug(' p_mode :' || p_mode);
18104: localdebug(' p_inv_ra_rec.amount_applied :' || p_inv_ra_rec.amount_applied);
18105: localdebug(' p_inv_ra_rec.amount_applied_from :' || p_inv_ra_rec.amount_applied_from);

Line 18123: arp_det_dist_pkg.set_original_rem_amt

18119:
18120:
18121: IF p_mode = 'OLTP' THEN
18122:
18123: arp_det_dist_pkg.set_original_rem_amt
18124: (p_customer_trx => l_inv_rec,
18125: p_app_id => p_inv_ra_rec.receivable_application_id,
18126: --{HYUNLB
18127: p_from_llca => p_from_llca);

Line 18356: localdebug('arp_det_dist_pkg.convert_ra_inv_to_cm()-');

18352: localdebug(' x_cm_ra_rec.tax_applied :'||x_cm_ra_rec.tax_applied);
18353: localdebug(' x_cm_ra_rec.freight_applied :'||x_cm_ra_rec.freight_applied);
18354: localdebug(' x_cm_ra_rec.receivables_charges_applied :'||x_cm_ra_rec.receivables_charges_applied);
18355:
18356: localdebug('arp_det_dist_pkg.convert_ra_inv_to_cm()-');
18357: END IF;
18358: EXCEPTION
18359: WHEN no_rem_for_trx_upg THEN
18360: IF PG_DEBUG = 'Y' THEN

Line 18425: localdebug('arp_det_dist_pkg.adjustment_with_interface()+');

18421: IS
18422: l_app_rec ar_receivable_applications%ROWTYPE;
18423: BEGIN
18424: IF PG_DEBUG = 'Y' THEN
18425: localdebug('arp_det_dist_pkg.adjustment_with_interface()+');
18426: localdebug(' p_gt_id :'||p_gt_id);
18427: localdebug(' p_adj_rec.amount :'|| p_adj_rec.amount);
18428: localdebug(' p_adj_rec.acctd_amount :'|| p_adj_rec.acctd_amount);
18429: localdebug(' p_customer_trx.invoice_currency_code :'|| p_customer_trx.invoice_currency_code);

Line 18538: localdebug('arp_det_dist_pkg.adjustment_with_interface()-');

18534: WHERE adjustment_id = p_adj_rec.adjustment_id;
18535: END IF;
18536:
18537: IF PG_DEBUG = 'Y' THEN
18538: localdebug('arp_det_dist_pkg.adjustment_with_interface()-');
18539: END IF;
18540: EXCEPTION
18541: WHEN fnd_api.G_EXC_ERROR THEN
18542: FND_MSG_PUB.Count_And_Get(

Line 18578: localdebug('arp_det_dist_pkg.application_with_interface()+');

18574: IS
18575: l_adj_rec ar_adjustments%ROWTYPE;
18576: BEGIN
18577: IF PG_DEBUG = 'Y' THEN
18578: localdebug('arp_det_dist_pkg.application_with_interface()+');
18579: localdebug(' p_customer_trx_id :'||p_customer_trx.customer_trx_id);
18580: localdebug(' p_gt_id :'||p_gt_id);
18581: END IF;
18582:

Line 18705: localdebug('arp_det_dist_pkg.application_with_interface()-');

18701: p_ae_sys_rec => p_ae_sys_rec);
18702:
18703:
18704: IF PG_DEBUG = 'Y' THEN
18705: localdebug('arp_det_dist_pkg.application_with_interface()-');
18706: END IF;
18707: EXCEPTION
18708: WHEN fnd_api.G_EXC_ERROR THEN
18709: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 18803: localdebug('arp_det_dist_pkg.reconciliation()+');

18799: l_customer_trx_id NUMBER;
18800:
18801: BEGIN
18802: IF PG_DEBUG = 'Y' THEN
18803: localdebug('arp_det_dist_pkg.reconciliation()+');
18804: END IF;
18805:
18806: IF p_activity_type = 'RA' AND p_app_rec.application_type = 'CM' THEN
18807: n :=2;

Line 19004: localdebug('arp_det_dist_pkg.reconciliation()-');

19000: END IF;
19001: END IF;
19002:
19003: IF PG_DEBUG = 'Y' THEN
19004: localdebug('arp_det_dist_pkg.reconciliation()-');
19005: END IF;
19006: EXCEPTION
19007: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
19008: IF l_check_valid = 1 THEN

Line 19038: localdebug('arp_det_dist_pkg.verify_stamp_merge_dist_method()+');

19034: PROCEDURE verify_stamp_merge_dist_method(p_customer_trx_id IN NUMBER,
19035: x_upg_method IN OUT NOCOPY VARCHAR2) IS
19036: BEGIN
19037: IF PG_DEBUG = 'Y' THEN
19038: localdebug('arp_det_dist_pkg.verify_stamp_merge_dist_method()+');
19039: localdebug('p_customer_trx_id :'||p_customer_trx_id);
19040: localdebug('x_upg_method :'||x_upg_method);
19041: END IF;
19042:

Line 19046: localdebug('arp_det_dist_pkg.verify_stamp_merge_dist_method()-');

19042:
19043: IF p_customer_trx_id IS NULL THEN
19044: IF PG_DEBUG = 'Y' THEN
19045: localdebug('p_customer_trx_id is null,returning....');
19046: localdebug('arp_det_dist_pkg.verify_stamp_merge_dist_method()-');
19047: END IF;
19048: RETURN;
19049: END IF;
19050:

Line 19074: localdebug('arp_det_dist_pkg.verify_stamp_merge_dist_method()-');

19070: END IF;
19071:
19072: IF PG_DEBUG = 'Y' THEN
19073: localdebug('x_upg_method '||x_upg_method);
19074: localdebug('arp_det_dist_pkg.verify_stamp_merge_dist_method()-');
19075: END IF;
19076:
19077: EXCEPTION
19078: WHEN OTHERS THEN

Line 19804: END ARP_DET_DIST_PKG;

19800: END IF;
19801: END IF;
19802: END;
19803:
19804: END ARP_DET_DIST_PKG;