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.11 2008/02/19 10:34:33 dgaurab 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 1066: arp_standard.debug('ARP_RECONCILE.Check_all_bills_closed, -set p_all_br_closed to N ');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3577: p_ae_line_rec.taxable_accounted_dr := p_ae_line_rec.taxable_accounted_cr;
3578: p_ae_line_rec.taxable_accounted_cr := l_swap_amt;
3579:
3580: IF PG_DEBUG in ('Y', 'C') THEN
3581: arp_standard.debug('ARP_RECONCILE.Build_Tax ()-');
3582: END IF;
3583:
3584: EXCEPTION
3585: WHEN NO_DATA_FOUND THEN

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

3583:
3584: EXCEPTION
3585: WHEN NO_DATA_FOUND THEN
3586: IF PG_DEBUG in ('Y', 'C') THEN
3587: arp_standard.debug('EXCEPTION NO_DATA_FOUND : ARP_RECONCILE.Build_Tax ');
3588: END IF;
3589: RAISE;
3590:
3591: WHEN OTHERS THEN

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

3589: RAISE;
3590:
3591: WHEN OTHERS THEN
3592: IF PG_DEBUG in ('Y', 'C') THEN
3593: arp_standard.debug('EXCEPTION OTHERS : ARP_RECONCILE.Build_Tax ');
3594: END IF;
3595: RAISE;
3596:
3597: END Build_Tax;

Line 3599: END ARP_RECONCILE;

3595: RAISE;
3596:
3597: END Build_Tax;
3598:
3599: END ARP_RECONCILE;