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_RECONCILE dependencies on ARP_RECONCILE

Line 1: PACKAGE BODY ARP_RECONCILE AS

1: PACKAGE BODY ARP_RECONCILE AS
2: /* $Header: ARTRECBB.pls 120.18 2011/05/30 12:12:35 kyennawa ship $ */
3:
4: /*=======================================================================+
5: | Global Constants

Line 190: arp_standard.debug('Check_Entry: ' || 'ARP_RECONCILE.Reconcile_trx_br ()+ ');

186:
187: BEGIN
188:
189: IF PG_DEBUG in ('Y', 'C') THEN
190: arp_standard.debug('Check_Entry: ' || 'ARP_RECONCILE.Reconcile_trx_br ()+ ');
191: END IF;
192:
193: --Set global variable for document being reconciled
194: g_orig_cust_trx_id := p_activity_cust_trx_id;

Line 301: arp_standard.debug('Check_Entry: ' || 'ARP_RECONCILE.Reconcile_trx_br ()- ');

297: END IF; --payment schedule is closed
298:
299: <>
300: IF PG_DEBUG in ('Y', 'C') THEN
301: arp_standard.debug('Check_Entry: ' || 'ARP_RECONCILE.Reconcile_trx_br ()- ');
302: END IF;
303:
304: EXCEPTION
305: WHEN OTHERS THEN

Line 307: arp_standard.debug('Check_Entry: ' || 'EXCEPTION OTHERS: ARP_RECONCILE.Reconcile_trx_br ');

303:
304: EXCEPTION
305: WHEN OTHERS THEN
306: IF PG_DEBUG in ('Y', 'C') THEN
307: arp_standard.debug('Check_Entry: ' || 'EXCEPTION OTHERS: ARP_RECONCILE.Reconcile_trx_br ');
308: END IF;
309: RAISE;
310:
311: END Reconcile_trx_br;

Line 337: arp_standard.debug('ARP_RECONCILE.Check_Entry - Checking for deferred tax');

333:
334: BEGIN
335:
336: IF PG_DEBUG in ('Y', 'C') THEN
337: arp_standard.debug('ARP_RECONCILE.Check_Entry - Checking for deferred tax');
338: END IF;
339:
340: IF (p_type = 'TRAN') THEN
341:

Line 358: arp_standard.debug('ARP_RECONCILE.Check_Entry - NO DEFERRED TAX');

354:
355: EXCEPTION
356: WHEN NO_DATA_FOUND THEN
357: IF PG_DEBUG in ('Y', 'C') THEN
358: arp_standard.debug('ARP_RECONCILE.Check_Entry - NO DEFERRED TAX');
359: END IF;
360: p_required := FALSE; --Tax is not deferred processing not required
361: WHEN OTHERS THEN
362: IF PG_DEBUG in ('Y', 'C') THEN

Line 363: arp_standard.debug('EXCEPTION OTHERS: ARP_RECONCILE.Check_Entry - Transaction check ');

359: END IF;
360: p_required := FALSE; --Tax is not deferred processing not required
361: WHEN OTHERS THEN
362: IF PG_DEBUG in ('Y', 'C') THEN
363: arp_standard.debug('EXCEPTION OTHERS: ARP_RECONCILE.Check_Entry - Transaction check ');
364: END IF;
365: RAISE;
366: END; --deferred tax processing required for Transactions
367:

Line 378: arp_standard.debug('ARP_RECONCILE.Check_Entry - DEFERRED TAX');

374: p_required := TRUE; --Enable processing this should never happen
375: END IF;
376:
377: IF PG_DEBUG in ('Y', 'C') THEN
378: arp_standard.debug('ARP_RECONCILE.Check_Entry - DEFERRED TAX');
379: END IF;
380:
381: EXCEPTION
382: WHEN NO_DATA_FOUND THEN

Line 384: arp_standard.debug('EXCEPTION NO_DATA_FOUND: ARP_RECONCILE.Check_Entry ');

380:
381: EXCEPTION
382: WHEN NO_DATA_FOUND THEN
383: IF PG_DEBUG in ('Y', 'C') THEN
384: arp_standard.debug('EXCEPTION NO_DATA_FOUND: ARP_RECONCILE.Check_Entry ');
385: END IF;
386: RAISE;
387: WHEN OTHERS THEN
388: IF PG_DEBUG in ('Y', 'C') THEN

Line 389: arp_standard.debug('EXCEPTION OTHERS: ARP_RECONCILE.Check_Entry ');

385: END IF;
386: RAISE;
387: WHEN OTHERS THEN
388: IF PG_DEBUG in ('Y', 'C') THEN
389: arp_standard.debug('EXCEPTION OTHERS: ARP_RECONCILE.Check_Entry ');
390: END IF;
391: RAISE;
392: END Check_Entry;
393:

Line 458: arp_standard.debug('ARP_RECONCILE.Reverse_Reconcile_Entry()+ ');

454:
455: BEGIN
456:
457: IF PG_DEBUG in ('Y', 'C') THEN
458: arp_standard.debug('ARP_RECONCILE.Reverse_Reconcile_Entry()+ ');
459: arp_standard.debug('Reverse_Reconcile_entry: ' || 'p_customer_trx_id ' || p_customer_trx_id);
460: arp_standard.debug('Reverse_Reconcile_entry: ' || 'p_calling_point ' || p_calling_point);
461: END IF;
462:

Line 543: arp_standard.debug('ARP_RECONCILE.Reverse_Reconcile_Entry()- ');

539:
540: END IF; --drawee site is null
541:
542: IF PG_DEBUG in ('Y', 'C') THEN
543: arp_standard.debug('ARP_RECONCILE.Reverse_Reconcile_Entry()- ');
544: END IF;
545:
546: EXCEPTION
547: WHEN NO_DATA_FOUND THEN

Line 549: arp_standard.debug('EXCEPTION NO_DATA_FOUND: ARP_RECONCILE.Reverse_Reconcile_entry ');

545:
546: EXCEPTION
547: WHEN NO_DATA_FOUND THEN
548: IF PG_DEBUG in ('Y', 'C') THEN
549: arp_standard.debug('EXCEPTION NO_DATA_FOUND: ARP_RECONCILE.Reverse_Reconcile_entry ');
550: END IF;
551: RAISE;
552: WHEN OTHERS THEN
553: IF PG_DEBUG in ('Y', 'C') THEN

Line 555: arp_standard.debug('EXCEPTION OTHERS: ARP_RECONCILE.Reverse_Reconcile_entry ');

551: RAISE;
552: WHEN OTHERS THEN
553: IF PG_DEBUG in ('Y', 'C') THEN
554: arp_standard.debug('Reverse_Reconcile_entry: ' || SQLERRM);
555: arp_standard.debug('EXCEPTION OTHERS: ARP_RECONCILE.Reverse_Reconcile_entry ');
556: END IF;
557: RAISE;
558:
559: END Reverse_Reconcile_entry;

Line 862: arp_standard.debug('ARP_RECONCILE.Get_Recon_Acct()+ ');

858:
859: BEGIN
860:
861: IF PG_DEBUG in ('Y', 'C') THEN
862: arp_standard.debug('ARP_RECONCILE.Get_Recon_Acct()+ ');
863: arp_standard.debug('get_recon_acct: ' || 'p_customer_trx_id ' || p_customer_trx_id);
864: arp_standard.debug('get_recon_acct: ' || 'p_customer_trx_line_id ' || p_customer_trx_line_id);
865: arp_standard.debug('get_recon_acct: ' || 'p_calling_point ' || p_calling_point);
866: END IF;

Line 1013: arp_standard.debug('ARP_RECONCILE.Get_Recon_Acct()- ');

1009:
1010: END IF;
1011:
1012: IF PG_DEBUG in ('Y', 'C') THEN
1013: arp_standard.debug('ARP_RECONCILE.Get_Recon_Acct()- ');
1014: END IF;
1015:
1016: EXCEPTION
1017: WHEN OTHERS THEN

Line 1019: arp_standard.debug('EXCEPTION OTHERS : ARP_RECONCILE.Get_Recon_Acct ');

1015:
1016: EXCEPTION
1017: WHEN OTHERS THEN
1018: IF PG_DEBUG in ('Y', 'C') THEN
1019: arp_standard.debug('EXCEPTION OTHERS : ARP_RECONCILE.Get_Recon_Acct ');
1020: END IF;
1021: RAISE;
1022: END get_recon_acct;
1023:

Line 1047: arp_standard.debug('ARP_RECONCILE.Check_all_bills_closed ()+ ');

1043:
1044: BEGIN
1045:
1046: IF PG_DEBUG in ('Y', 'C') THEN
1047: arp_standard.debug('ARP_RECONCILE.Check_all_bills_closed ()+ ');
1048: END IF;
1049:
1050: select 'N'
1051: into p_all_br_closed

Line 1065: arp_standard.debug('ARP_RECONCILE.Check_all_bills_closed, -set p_all_br_closed to N ');

1061: and ps.customer_trx_id <> g_orig_cust_trx_id
1062: );
1063:
1064: IF PG_DEBUG in ('Y', 'C') THEN
1065: arp_standard.debug('ARP_RECONCILE.Check_all_bills_closed, -set p_all_br_closed to N ');
1066: arp_standard.debug('ARP_RECONCILE.Check_all_bills_closed ()- ');
1067: END IF;
1068:
1069: EXCEPTION

Line 1066: arp_standard.debug('ARP_RECONCILE.Check_all_bills_closed ()- ');

1062: );
1063:
1064: IF PG_DEBUG in ('Y', 'C') THEN
1065: arp_standard.debug('ARP_RECONCILE.Check_all_bills_closed, -set p_all_br_closed to N ');
1066: arp_standard.debug('ARP_RECONCILE.Check_all_bills_closed ()- ');
1067: END IF;
1068:
1069: EXCEPTION
1070: WHEN NO_DATA_FOUND then

Line 1072: arp_standard.debug('NO_DATA_FOUND : ARP_RECONCILE.Check_all_bills_closed, -set p_all_br_closed to Y ');

1068:
1069: EXCEPTION
1070: WHEN NO_DATA_FOUND then
1071: IF PG_DEBUG in ('Y', 'C') THEN
1072: arp_standard.debug('NO_DATA_FOUND : ARP_RECONCILE.Check_all_bills_closed, -set p_all_br_closed to Y ');
1073: END IF;
1074: p_all_br_closed := 'Y';
1075: WHEN OTHERS then
1076: IF PG_DEBUG in ('Y', 'C') THEN

Line 1077: arp_standard.debug('EXCEPTION OTHERS : ARP_RECONCILE.Check_all_bills_closed ');

1073: END IF;
1074: p_all_br_closed := 'Y';
1075: WHEN OTHERS then
1076: IF PG_DEBUG in ('Y', 'C') THEN
1077: arp_standard.debug('EXCEPTION OTHERS : ARP_RECONCILE.Check_all_bills_closed ');
1078: END IF;
1079: RAISE;
1080:
1081: END Check_all_bills_closed;

Line 1190: arp_standard.debug('ARP_RECONCILE.Reconcile_Trx_Tax ()+ ');

1186:
1187: BEGIN
1188:
1189: IF PG_DEBUG in ('Y', 'C') THEN
1190: arp_standard.debug('ARP_RECONCILE.Reconcile_Trx_Tax ()+ ');
1191: arp_standard.debug('Reconcile_trx_tax: ' || 'Input Parameters ');
1192: arp_standard.debug('Reconcile_trx_tax: ' || 'p_customer_trx_id ' || p_customer_trx_id);
1193: arp_standard.debug('Reconcile_trx_tax: ' || 'p_br_cust_trx_line_id ' || p_br_cust_trx_line_id);
1194: arp_standard.debug('Reconcile_trx_tax: ' || 'p_calling_point ' || p_calling_point);

Line 1281: arp_standard.debug('NO_DATA_FOUND : ARP_RECONCILE.Reconcile_trx_tax, CM applications do not exist ');

1277:
1278: EXCEPTION
1279: WHEN NO_DATA_FOUND THEN
1280: IF PG_DEBUG in ('Y', 'C') THEN
1281: arp_standard.debug('NO_DATA_FOUND : ARP_RECONCILE.Reconcile_trx_tax, CM applications do not exist ');
1282: END IF;
1283: l_simul_activity := 'N';
1284: IF PG_DEBUG in ('Y', 'C') THEN
1285: arp_standard.debug('Reconcile_trx_tax: ' || 'set l_simul_activity ' || l_simul_activity);

Line 1289: arp_standard.debug('EXCEPTION OTHERS : ARP_RECONCILE.Reconcile_trx_tax, in CM check applications sum');

1285: arp_standard.debug('Reconcile_trx_tax: ' || 'set l_simul_activity ' || l_simul_activity);
1286: END IF;
1287: WHEN OTHERS THEN
1288: IF PG_DEBUG in ('Y', 'C') THEN
1289: arp_standard.debug('EXCEPTION OTHERS : ARP_RECONCILE.Reconcile_trx_tax, in CM check applications sum');
1290: END IF;
1291: RAISE;
1292:
1293: END; --block to determine CM activity on transaction

Line 1352: arp_standard.debug('NO_DATA_FOUND : ARP_RECONCILE.Reconcile_trx_tax, Applications from CM ' ||

1348:
1349: EXCEPTION
1350: WHEN NO_DATA_FOUND THEN
1351: IF PG_DEBUG in ('Y', 'C') THEN
1352: arp_standard.debug('NO_DATA_FOUND : ARP_RECONCILE.Reconcile_trx_tax, Applications from CM ' ||
1353: 'to Transaction do not exist ');
1354: END IF;
1355: l_simul_activity := 'N';
1356: IF PG_DEBUG in ('Y', 'C') THEN

Line 1361: arp_standard.debug('EXCEPTION OTHERS : ARP_RECONCILE.Reconcile_trx_tax, in CM applications ' ||

1357: arp_standard.debug('Reconcile_trx_tax: ' || 'set l_simul_activity ' || l_simul_activity);
1358: END IF;
1359: WHEN OTHERS THEN
1360: IF PG_DEBUG in ('Y', 'C') THEN
1361: arp_standard.debug('EXCEPTION OTHERS : ARP_RECONCILE.Reconcile_trx_tax, in CM applications ' ||
1362: 'from CM to Transaction');
1363: END IF;
1364: RAISE;
1365:

Line 1502: arp_standard.debug('ARP_RECONCILE.Reconcile_trx_tax ()- ');

1498: p_g_ae_line_tbl => p_g_ae_line_tbl );
1499:
1500: <>
1501: IF PG_DEBUG in ('Y', 'C') THEN
1502: arp_standard.debug('ARP_RECONCILE.Reconcile_trx_tax ()- ');
1503: END IF;
1504:
1505: EXCEPTION
1506: WHEN NO_DATA_FOUND THEN

Line 1508: arp_standard.debug('EXCEPTION NO_DATA_FOUND: ARP_RECONCILE.Reconcile_trx_tax ');

1504:
1505: EXCEPTION
1506: WHEN NO_DATA_FOUND THEN
1507: IF PG_DEBUG in ('Y', 'C') THEN
1508: arp_standard.debug('EXCEPTION NO_DATA_FOUND: ARP_RECONCILE.Reconcile_trx_tax ');
1509: END IF;
1510: RAISE;
1511:
1512: WHEN OTHERS THEN

Line 1514: arp_standard.debug('EXCEPTION OTHERS : ARP_RECONCILE.Reconcile_trx_tax ');

1510: RAISE;
1511:
1512: WHEN OTHERS THEN
1513: IF PG_DEBUG in ('Y', 'C') THEN
1514: arp_standard.debug('EXCEPTION OTHERS : ARP_RECONCILE.Reconcile_trx_tax ');
1515: END IF;
1516: RAISE;
1517:
1518: END Reconcile_trx_tax;

Line 1623: arp_standard.debug('ARP_RECONCILE.Reconcile_br_tax ()+');

1619: l_required BOOLEAN;
1620:
1621: BEGIN
1622: IF PG_DEBUG in ('Y', 'C') THEN
1623: arp_standard.debug('ARP_RECONCILE.Reconcile_br_tax ()+');
1624: END IF;
1625:
1626: /*----------------------------------------------------------------------------------------+
1627: | All chained Bills starting from the current Bill must be closed for the Reconciliation |

Line 1798: arp_standard.debug('ARP_RECONCILE.Reconcile_br_tax ()-');

1794:
1795: END IF; --All chained bills are closed
1796:
1797: IF PG_DEBUG in ('Y', 'C') THEN
1798: arp_standard.debug('ARP_RECONCILE.Reconcile_br_tax ()-');
1799: END IF;
1800:
1801: EXCEPTION
1802: WHEN NO_DATA_FOUND THEN

Line 1804: arp_standard.debug('EXCEPTION NO_DATA_FOUND : ARP_RECONCILE.Reconcile_br_tax ');

1800:
1801: EXCEPTION
1802: WHEN NO_DATA_FOUND THEN
1803: IF PG_DEBUG in ('Y', 'C') THEN
1804: arp_standard.debug('EXCEPTION NO_DATA_FOUND : ARP_RECONCILE.Reconcile_br_tax ');
1805: END IF;
1806: RAISE;
1807:
1808: WHEN OTHERS THEN

Line 1810: arp_standard.debug('EXCEPTION OTHERS : ARP_RECONCILE.Reconcile_br_tax ');

1806: RAISE;
1807:
1808: WHEN OTHERS THEN
1809: IF PG_DEBUG in ('Y', 'C') THEN
1810: arp_standard.debug('EXCEPTION OTHERS : ARP_RECONCILE.Reconcile_br_tax ');
1811: END IF;
1812: RAISE;
1813:
1814: END Reconcile_br_tax;

Line 1857: arp_standard.debug('ARP_RECONCILE.Detect_Closure()+');

1853: l_pay_sched_upd_yn VARCHAR2(1);
1854:
1855: BEGIN
1856: IF PG_DEBUG in ('Y', 'C') THEN
1857: arp_standard.debug('ARP_RECONCILE.Detect_Closure()+');
1858: END IF;
1859:
1860: /*---------------------------------------------------------------------------+
1861: | Retrieve amount and accounted amount remaining for all installments on the|

Line 1930: arp_standard.debug('ARP_RECONCILE.Detect_Closure()-');

1926:
1927: <>
1928:
1929: IF PG_DEBUG in ('Y', 'C') THEN
1930: arp_standard.debug('ARP_RECONCILE.Detect_Closure()-');
1931: END IF;
1932:
1933: EXCEPTION
1934: WHEN NO_DATA_FOUND THEN

Line 1936: arp_standard.debug('EXCEPTION NO_DATA_FOUND : ARP_RECONCILE.Detect_Closure ');

1932:
1933: EXCEPTION
1934: WHEN NO_DATA_FOUND THEN
1935: IF PG_DEBUG in ('Y', 'C') THEN
1936: arp_standard.debug('EXCEPTION NO_DATA_FOUND : ARP_RECONCILE.Detect_Closure ');
1937: END IF;
1938: RAISE;
1939:
1940: WHEN OTHERS THEN

Line 1942: arp_standard.debug('EXCEPTION OTHERS : ARP_RECONCILE.Detect_Closure ');

1938: RAISE;
1939:
1940: WHEN OTHERS THEN
1941: IF PG_DEBUG in ('Y', 'C') THEN
1942: arp_standard.debug('EXCEPTION OTHERS : ARP_RECONCILE.Detect_Closure ');
1943: END IF;
1944: RAISE;
1945:
1946: END Detect_Closure;

Line 1966: arp_standard.debug('ARP_RECONCILE.Assign_Elements()+');

1962: p_g_ae_line_tbl IN OUT NOCOPY ae_line_tbl_type ) IS
1963:
1964: BEGIN
1965: IF PG_DEBUG in ('Y', 'C') THEN
1966: arp_standard.debug('ARP_RECONCILE.Assign_Elements()+');
1967: END IF;
1968:
1969: /*--------------------------------------------------------------------------------+
1970: | Do not create 0 amount Reconciliation entries if tax and taxable amounts are 0 |

Line 2116: arp_standard.debug( 'ARP_RECONCILE.Assign_Elements()-');

2112: Dump_Line_Amts(p_ae_line_rec);
2113:
2114: <>
2115: IF PG_DEBUG in ('Y', 'C') THEN
2116: arp_standard.debug( 'ARP_RECONCILE.Assign_Elements()-');
2117: END IF;
2118:
2119: EXCEPTION
2120: WHEN OTHERS THEN

Line 2122: arp_standard.debug('EXCEPTION OTHERS : ARP_RECONCILE.Assign_Elements');

2118:
2119: EXCEPTION
2120: WHEN OTHERS THEN
2121: IF PG_DEBUG in ('Y', 'C') THEN
2122: arp_standard.debug('EXCEPTION OTHERS : ARP_RECONCILE.Assign_Elements');
2123: END IF;
2124: RAISE;
2125:
2126: END Assign_Elements;

Line 2144: arp_standard.debug('ARP_RECONCILE.Dump_Line_Amts()+');

2140:
2141: BEGIN
2142:
2143: IF PG_DEBUG in ('Y', 'C') THEN
2144: arp_standard.debug('ARP_RECONCILE.Dump_Line_Amts()+');
2145: arp_standard.debug('Dump_Line_Amts: ' || 'ae_line_type = ' || p_ae_line_rec.ae_line_type);
2146: arp_standard.debug('Dump_Line_Amts: ' || 'ae_line_type_secondary = ' || p_ae_line_rec.ae_line_type_secondary);
2147: arp_standard.debug('Dump_Line_Amts: ' || 'source_id = ' || p_ae_line_rec.source_id);
2148: arp_standard.debug('Dump_Line_Amts: ' || 'source_table = ' || p_ae_line_rec.source_table);

Line 2176: arp_standard.debug('ARP_RECONCILE.Dump_Line_Amts()-');

2172: arp_standard.debug('Dump_Line_Amts: ' || 'applied_to_doc_id = ' || p_ae_line_rec.applied_to_doc_id);
2173: arp_standard.debug('Dump_Line_Amts: ' || 'tax_link_id = ' || p_ae_line_rec.tax_link_id);
2174: arp_standard.debug('Dump_Line_Amts: ' || 'reversed_source_id = ' || p_ae_line_rec.reversed_source_id);
2175: arp_standard.debug('Dump_Line_Amts: ' || 'summarize_flag = ' || p_ae_line_rec.summarize_flag);
2176: arp_standard.debug('ARP_RECONCILE.Dump_Line_Amts()-');
2177: END IF;
2178:
2179: EXCEPTION
2180: WHEN OTHERS THEN

Line 2182: arp_standard.debug('EXCEPTION OTHERS : ARP_RECONCILE.Dump_Line_Amts');

2178:
2179: EXCEPTION
2180: WHEN OTHERS THEN
2181: IF PG_DEBUG in ('Y', 'C') THEN
2182: arp_standard.debug('EXCEPTION OTHERS : ARP_RECONCILE.Dump_Line_Amts');
2183: END IF;
2184: RAISE;
2185:
2186: END Dump_Line_Amts;

Line 2452: arp_standard.debug('ARP_RECONCILE.Process_Recon()+');

2448:
2449: BEGIN
2450:
2451: IF PG_DEBUG in ('Y', 'C') THEN
2452: arp_standard.debug('ARP_RECONCILE.Process_Recon()+');
2453: arp_standard.debug('Process_Recon: ' || 'list Input of parameters ');
2454: arp_standard.debug('Process_Recon: ' || 'p_br_cust_trx_line_id ' || p_br_cust_trx_line_id);
2455: arp_standard.debug('Process_Recon: ' || 'p_customer_trx_id ' || p_customer_trx_id);
2456: arp_standard.debug('Process_Recon: ' || 'p_simul_app ' || p_simul_app);

Line 3347: arp_standard.debug('ARP_RECONCILE.Process_Recon ()-');

3343:
3344: END IF; --lines exist in tax and activity table
3345:
3346: IF PG_DEBUG in ('Y', 'C') THEN
3347: arp_standard.debug('ARP_RECONCILE.Process_Recon ()-');
3348: END IF;
3349:
3350: EXCEPTION
3351: WHEN NO_DATA_FOUND THEN

Line 3353: arp_standard.debug('EXCEPTION NO_DATA_FOUND : ARP_RECONCILE.Process_Recon ');

3349:
3350: EXCEPTION
3351: WHEN NO_DATA_FOUND THEN
3352: IF PG_DEBUG in ('Y', 'C') THEN
3353: arp_standard.debug('EXCEPTION NO_DATA_FOUND : ARP_RECONCILE.Process_Recon ');
3354: END IF;
3355: RAISE;
3356:
3357: WHEN OTHERS THEN

Line 3359: arp_standard.debug('EXCEPTION OTHERS : ARP_RECONCILE.Process_Recon ');

3355: RAISE;
3356:
3357: WHEN OTHERS THEN
3358: IF PG_DEBUG in ('Y', 'C') THEN
3359: arp_standard.debug('EXCEPTION OTHERS : ARP_RECONCILE.Process_Recon ');
3360: END IF;
3361: RAISE;
3362:
3363: END Process_Recon;

Line 3398: arp_standard.debug('ARP_RECONCILE.Build_Deferred_Tax ()+');

3394:
3395: BEGIN
3396:
3397: IF PG_DEBUG in ('Y', 'C') THEN
3398: arp_standard.debug('ARP_RECONCILE.Build_Deferred_Tax ()+');
3399: END IF;
3400:
3401: /*-----------------------------------------------------------------------------+
3402: | Create the Dr or Cr to the deferred tax account, set details such as rates, |

Line 3458: arp_standard.debug('ARP_RECONCILE.Build_Deferred_Tax ()-');

3454: p_ae_line_rec.tax_link_id := '' ;
3455: p_ae_line_rec.reversed_source_id := '' ;
3456:
3457: IF PG_DEBUG in ('Y', 'C') THEN
3458: arp_standard.debug('ARP_RECONCILE.Build_Deferred_Tax ()-');
3459: END IF;
3460:
3461: EXCEPTION
3462: WHEN NO_DATA_FOUND THEN

Line 3464: arp_standard.debug('EXCEPTION NO_DATA_FOUND : ARP_RECONCILE.Build_Deferred_Tax ');

3460:
3461: EXCEPTION
3462: WHEN NO_DATA_FOUND THEN
3463: IF PG_DEBUG in ('Y', 'C') THEN
3464: arp_standard.debug('EXCEPTION NO_DATA_FOUND : ARP_RECONCILE.Build_Deferred_Tax ');
3465: END IF;
3466: RAISE;
3467:
3468: WHEN OTHERS THEN

Line 3470: arp_standard.debug('EXCEPTION OTHERS : ARP_RECONCILE.Build_Deferred_Tax ');

3466: RAISE;
3467:
3468: WHEN OTHERS THEN
3469: IF PG_DEBUG in ('Y', 'C') THEN
3470: arp_standard.debug('EXCEPTION OTHERS : ARP_RECONCILE.Build_Deferred_Tax ');
3471: END IF;
3472: RAISE;
3473:
3474: END Build_Deferred_Tax;

Line 3503: arp_standard.debug('ARP_RECONCILE.Build_Tax ()+');

3499: l_swap_amt NUMBER;
3500:
3501: BEGIN
3502: IF PG_DEBUG in ('Y', 'C') THEN
3503: arp_standard.debug('ARP_RECONCILE.Build_Tax ()+');
3504: END IF;
3505:
3506: /*-----------------------------------------------------------------------------+
3507: | Create the Offsetting Dr or Cr to the Collected tax account. To do this, the|

Line 3648: arp_standard.debug('ARP_RECONCILE.Build_Tax ()-');

3644: p_ae_line_rec.taxable_accounted_dr := p_ae_line_rec.taxable_accounted_cr;
3645: p_ae_line_rec.taxable_accounted_cr := l_swap_amt;
3646:
3647: IF PG_DEBUG in ('Y', 'C') THEN
3648: arp_standard.debug('ARP_RECONCILE.Build_Tax ()-');
3649: END IF;
3650:
3651: EXCEPTION
3652: WHEN NO_DATA_FOUND THEN

Line 3654: arp_standard.debug('EXCEPTION NO_DATA_FOUND : ARP_RECONCILE.Build_Tax ');

3650:
3651: EXCEPTION
3652: WHEN NO_DATA_FOUND THEN
3653: IF PG_DEBUG in ('Y', 'C') THEN
3654: arp_standard.debug('EXCEPTION NO_DATA_FOUND : ARP_RECONCILE.Build_Tax ');
3655: END IF;
3656: RAISE;
3657:
3658: WHEN OTHERS THEN

Line 3660: arp_standard.debug('EXCEPTION OTHERS : ARP_RECONCILE.Build_Tax ');

3656: RAISE;
3657:
3658: WHEN OTHERS THEN
3659: IF PG_DEBUG in ('Y', 'C') THEN
3660: arp_standard.debug('EXCEPTION OTHERS : ARP_RECONCILE.Build_Tax ');
3661: END IF;
3662: RAISE;
3663:
3664: END Build_Tax;

Line 3666: END ARP_RECONCILE;

3662: RAISE;
3663:
3664: END Build_Tax;
3665:
3666: END ARP_RECONCILE;