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 STANDARD

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 219: arp_standard.debug('Check_Entry: ' || 'Calling point ' || l_calling_point);

215: l_calling_point := 'BILL';
216: END IF;
217:
218: IF PG_DEBUG in ('Y', 'C') THEN
219: arp_standard.debug('Check_Entry: ' || 'Calling point ' || l_calling_point);
220: END IF;
221:
222: /*--------------------------------------------------------------------------+
223: | If the Transaction is not deferred then do not do any process as there is|

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 459: arp_standard.debug('Reverse_Reconcile_entry: ' || 'p_customer_trx_id ' || p_customer_trx_id);

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:
463: IF p_calling_point IN ('TRAN', 'BLTR') THEN

Line 460: arp_standard.debug('Reverse_Reconcile_entry: ' || 'p_calling_point ' || p_calling_point);

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:
463: IF p_calling_point IN ('TRAN', 'BLTR') THEN
464:

Line 466: arp_standard.debug('Reverse_Reconcile_entry: ' || 'Calling get_recon_acct for 1 -' || p_calling_point);

462:
463: IF p_calling_point IN ('TRAN', 'BLTR') THEN
464:
465: IF PG_DEBUG in ('Y', 'C') THEN
466: arp_standard.debug('Reverse_Reconcile_entry: ' || 'Calling get_recon_acct for 1 -' || p_calling_point);
467: END IF;
468:
469: --get reconciliation entries customer trx line id, tax code, account
470: get_recon_acct( p_mode => p_mode ,

Line 486: arp_standard.debug('Reverse_Reconcile_entry: ' || 'Calling get_recon_acct for 2 -' || p_calling_point);

482:
483: ELSE
484:
485: IF PG_DEBUG in ('Y', 'C') THEN
486: arp_standard.debug('Reverse_Reconcile_entry: ' || 'Calling get_recon_acct for 2 -' || p_calling_point);
487: END IF;
488:
489: --Loop assignment times
490: FOR l_assign_rec IN get_assignments(p_customer_trx_id) LOOP

Line 493: arp_standard.debug('Reverse_Reconcile_entry: ' || 'l_assign_rec.drawee_site_use_id ' || l_assign_rec.drawee_site_use_id);

489: --Loop assignment times
490: FOR l_assign_rec IN get_assignments(p_customer_trx_id) LOOP
491:
492: IF PG_DEBUG in ('Y', 'C') THEN
493: arp_standard.debug('Reverse_Reconcile_entry: ' || 'l_assign_rec.drawee_site_use_id ' || l_assign_rec.drawee_site_use_id);
494: END IF;
495:
496: --If assignment is a bill then Recursive call
497: IF l_assign_rec.drawee_site_use_id IS NOT NULL THEN

Line 500: arp_standard.debug('Reverse_Reconcile_entry: ' || 'Recursive call for l_assign_rec.br_ref_customer_trx_id ' || l_assign_rec.br_ref_customer_trx_id);

496: --If assignment is a bill then Recursive call
497: IF l_assign_rec.drawee_site_use_id IS NOT NULL THEN
498:
499: IF PG_DEBUG in ('Y', 'C') THEN
500: arp_standard.debug('Reverse_Reconcile_entry: ' || 'Recursive call for l_assign_rec.br_ref_customer_trx_id ' || l_assign_rec.br_ref_customer_trx_id);
501: END IF;
502: Reverse_Reconcile_entry(
503: p_mode => p_mode ,
504: p_ae_doc_rec => p_ae_doc_rec ,

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 554: arp_standard.debug('Reverse_Reconcile_entry: ' || SQLERRM);

550: END IF;
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:

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 863: arp_standard.debug('get_recon_acct: ' || 'p_customer_trx_id ' || p_customer_trx_id);

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;
867:

Line 864: arp_standard.debug('get_recon_acct: ' || 'p_customer_trx_line_id ' || p_customer_trx_line_id);

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;
867:
868: sob_id := p_ae_sys_rec.set_of_books_id;

Line 865: arp_standard.debug('get_recon_acct: ' || 'p_calling_point ' || p_calling_point);

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;
867:
868: sob_id := p_ae_sys_rec.set_of_books_id;
869: IF PG_DEBUG in ('Y', 'C') THEN

Line 870: arp_standard.debug('get_recon_acct: ' || 'set of books id = ' || to_char(sob_id));

866: END IF;
867:
868: sob_id := p_ae_sys_rec.set_of_books_id;
869: IF PG_DEBUG in ('Y', 'C') THEN
870: arp_standard.debug('get_recon_acct: ' || 'set of books id = ' || to_char(sob_id));
871: END IF;
872:
873: -- Construct Select Cursor based on reporting type:
874: IF PG_DEBUG in ('Y', 'C') THEN

Line 875: arp_standard.debug('get_recon_acct: ' || 'selecting cursor based on reporting type');

871: END IF;
872:
873: -- Construct Select Cursor based on reporting type:
874: IF PG_DEBUG in ('Y', 'C') THEN
875: arp_standard.debug('get_recon_acct: ' || 'selecting cursor based on reporting type');
876: END IF;
877:
878: sql_stmt := select1_stmt ||
879: select2_stmt; /* common between primary and reporting */

Line 902: arp_standard.debug ('get_recon_acct: ' || 'select_stmt = ' || sql_stmt);

898: group2;
899: END IF;
900:
901: IF PG_DEBUG in ('Y', 'C') THEN
902: arp_standard.debug ('get_recon_acct: ' || 'select_stmt = ' || sql_stmt);
903: END IF;
904:
905: IF ( p_ae_sys_rec.sob_type = 'P') THEN
906: OPEN get_recon_accounting FOR sql_stmt

Line 927: arp_standard.debug('get_recon_acct: ' || 'before fetch..');

923:
924: --{BUG4301323
925: LOOP
926: IF PG_DEBUG in ('Y', 'C') THEN
927: arp_standard.debug('get_recon_acct: ' || 'before fetch..');
928: END IF;
929: --get reconciliation entries customer trx line id, tax code, account
930: FETCH get_recon_accounting into l_recon_rec;
931: EXIT WHEN get_recon_accounting%NOTFOUND;

Line 934: arp_standard.debug('get_recon_acct: ' || 'In the reverse reconciliation entries Loop ');

930: FETCH get_recon_accounting into l_recon_rec;
931: EXIT WHEN get_recon_accounting%NOTFOUND;
932:
933: IF PG_DEBUG in ('Y', 'C') THEN
934: arp_standard.debug('get_recon_acct: ' || 'In the reverse reconciliation entries Loop ');
935: arp_standard.debug('get_recon_acct: ' || 'tax_group_code_id ' || l_recon_rec.tax_group_code_id);
936: arp_standard.debug('get_recon_acct: ' || 'tax_code_id ' || l_recon_rec.tax_code_id);
937: arp_standard.debug('get_recon_acct: ' || 'location segment id ' || l_recon_rec.location_segment_id);
938: END IF;

Line 935: arp_standard.debug('get_recon_acct: ' || 'tax_group_code_id ' || l_recon_rec.tax_group_code_id);

931: EXIT WHEN get_recon_accounting%NOTFOUND;
932:
933: IF PG_DEBUG in ('Y', 'C') THEN
934: arp_standard.debug('get_recon_acct: ' || 'In the reverse reconciliation entries Loop ');
935: arp_standard.debug('get_recon_acct: ' || 'tax_group_code_id ' || l_recon_rec.tax_group_code_id);
936: arp_standard.debug('get_recon_acct: ' || 'tax_code_id ' || l_recon_rec.tax_code_id);
937: arp_standard.debug('get_recon_acct: ' || 'location segment id ' || l_recon_rec.location_segment_id);
938: END IF;
939:

Line 936: arp_standard.debug('get_recon_acct: ' || 'tax_code_id ' || l_recon_rec.tax_code_id);

932:
933: IF PG_DEBUG in ('Y', 'C') THEN
934: arp_standard.debug('get_recon_acct: ' || 'In the reverse reconciliation entries Loop ');
935: arp_standard.debug('get_recon_acct: ' || 'tax_group_code_id ' || l_recon_rec.tax_group_code_id);
936: arp_standard.debug('get_recon_acct: ' || 'tax_code_id ' || l_recon_rec.tax_code_id);
937: arp_standard.debug('get_recon_acct: ' || 'location segment id ' || l_recon_rec.location_segment_id);
938: END IF;
939:
940: l_ae_line_rec := l_ae_empty_line_rec;

Line 937: arp_standard.debug('get_recon_acct: ' || 'location segment id ' || l_recon_rec.location_segment_id);

933: IF PG_DEBUG in ('Y', 'C') THEN
934: arp_standard.debug('get_recon_acct: ' || 'In the reverse reconciliation entries Loop ');
935: arp_standard.debug('get_recon_acct: ' || 'tax_group_code_id ' || l_recon_rec.tax_group_code_id);
936: arp_standard.debug('get_recon_acct: ' || 'tax_code_id ' || l_recon_rec.tax_code_id);
937: arp_standard.debug('get_recon_acct: ' || 'location segment id ' || l_recon_rec.location_segment_id);
938: END IF;
939:
940: l_ae_line_rec := l_ae_empty_line_rec;
941:

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 1192: arp_standard.debug('Reconcile_trx_tax: ' || 'Input Parameters ');

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);
1196: END IF;

Line 1193: arp_standard.debug('Reconcile_trx_tax: ' || 'p_customer_trx_id ' || p_customer_trx_id);

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);
1196: END IF;
1197:

Line 1194: arp_standard.debug('Reconcile_trx_tax: ' || 'p_br_cust_trx_line_id ' || p_br_cust_trx_line_id);

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);
1196: END IF;
1197:
1198: /*-----------------------------------------------------------------------------+

Line 1195: arp_standard.debug('Reconcile_trx_tax: ' || 'p_calling_point ' || p_calling_point);

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);
1196: END IF;
1197:
1198: /*-----------------------------------------------------------------------------+
1199: | All chained Bills containing the current transaction assignment must be |

Line 1238: arp_standard.debug('Reconcile_trx_tax: ' || 'Check CM applications for deferred tax reconciliation ()+ ');

1234: +-----------------------------------------------------------------------------------------*/
1235: BEGIN
1236:
1237: IF PG_DEBUG in ('Y', 'C') THEN
1238: arp_standard.debug('Reconcile_trx_tax: ' || 'Check CM applications for deferred tax reconciliation ()+ ');
1239: END IF;
1240:
1241: l_cm_amt := 0; l_cm_acctd_amt := 0; l_cm_line_amt := 0;
1242: l_cm_tax_amt := 0; l_cm_frt_amt := 0; l_cm_chrg_amt := 0;

Line 1265: arp_standard.debug('Reconcile_trx_tax: ' || 'Sum of CM applications to Transaction is not zero - simulate activity');

1261:
1262: IF ((l_cm_amt <> 0) OR (l_cm_acctd_amt <> 0) OR (l_cm_line_amt <> 0)
1263: OR (l_cm_tax_amt <> 0) OR (l_cm_frt_amt <> 0) OR (l_cm_chrg_amt <> 0)) THEN
1264: IF PG_DEBUG in ('Y', 'C') THEN
1265: arp_standard.debug('Reconcile_trx_tax: ' || 'Sum of CM applications to Transaction is not zero - simulate activity');
1266: END IF;
1267: l_simul_activity := 'Y';
1268: ELSE
1269: IF PG_DEBUG in ('Y', 'C') THEN

Line 1270: arp_standard.debug('Reconcile_trx_tax: ' || 'Sum of CM applications is zero or no applications - do not simulate activity ');

1266: END IF;
1267: l_simul_activity := 'Y';
1268: ELSE
1269: IF PG_DEBUG in ('Y', 'C') THEN
1270: arp_standard.debug('Reconcile_trx_tax: ' || 'Sum of CM applications is zero or no applications - do not simulate activity ');
1271: END IF;
1272: l_simul_activity := 'N';
1273: END IF;
1274:

Line 1276: arp_standard.debug('Reconcile_trx_tax: ' || 'Check CM applications for deferred tax reconciliation ()- ');

1272: l_simul_activity := 'N';
1273: END IF;
1274:
1275: IF PG_DEBUG in ('Y', 'C') THEN
1276: arp_standard.debug('Reconcile_trx_tax: ' || 'Check CM applications for deferred tax reconciliation ()- ');
1277: END IF;
1278:
1279: EXCEPTION
1280: WHEN NO_DATA_FOUND THEN

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 1286: arp_standard.debug('Reconcile_trx_tax: ' || 'set l_simul_activity ' || l_simul_activity);

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);
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');

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 1309: arp_standard.debug('Reconcile_trx_tax: ' || 'Check applications from CM to Transactions ()+ ');

1305: IF (l_simul_activity = 'N') AND (p_pay_class = 'CM') THEN
1306: BEGIN
1307:
1308: IF PG_DEBUG in ('Y', 'C') THEN
1309: arp_standard.debug('Reconcile_trx_tax: ' || 'Check applications from CM to Transactions ()+ ');
1310: END IF;
1311:
1312: l_cm_amt := 0; l_cm_acctd_amt := 0; l_cm_line_amt := 0;
1313: l_cm_tax_amt := 0; l_cm_frt_amt := 0; l_cm_chrg_amt := 0;

Line 1336: arp_standard.debug('Reconcile_trx_tax: ' || 'Applications from CM to Transaction are not zero - simulate activity');

1332:
1333: IF ((l_cm_amt <> 0) OR (l_cm_acctd_amt <> 0) OR (l_cm_line_amt <> 0)
1334: OR (l_cm_tax_amt <> 0) OR (l_cm_frt_amt <> 0) OR (l_cm_chrg_amt <> 0)) THEN
1335: IF PG_DEBUG in ('Y', 'C') THEN
1336: arp_standard.debug('Reconcile_trx_tax: ' || 'Applications from CM to Transaction are not zero - simulate activity');
1337: END IF;
1338: l_simul_activity := 'Y';
1339: ELSE
1340: IF PG_DEBUG in ('Y', 'C') THEN

Line 1341: arp_standard.debug('Reconcile_trx_tax: ' || 'Applications from CM to Transaction are zero - do not simulate activity ');

1337: END IF;
1338: l_simul_activity := 'Y';
1339: ELSE
1340: IF PG_DEBUG in ('Y', 'C') THEN
1341: arp_standard.debug('Reconcile_trx_tax: ' || 'Applications from CM to Transaction are zero - do not simulate activity ');
1342: END IF;
1343: l_simul_activity := 'N';
1344: END IF;
1345:

Line 1347: arp_standard.debug('Reconcile_trx_tax: ' || 'Check applications from CM to Transactions ()- ');

1343: l_simul_activity := 'N';
1344: END IF;
1345:
1346: IF PG_DEBUG in ('Y', 'C') THEN
1347: arp_standard.debug('Reconcile_trx_tax: ' || 'Check applications from CM to Transactions ()- ');
1348: END IF;
1349:
1350: EXCEPTION
1351: WHEN NO_DATA_FOUND THEN

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 1358: arp_standard.debug('Reconcile_trx_tax: ' || 'set l_simul_activity ' || l_simul_activity);

1354: 'to Transaction do not exist ');
1355: END IF;
1356: l_simul_activity := 'N';
1357: IF PG_DEBUG in ('Y', 'C') THEN
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 ' ||

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 1374: arp_standard.debug('Reconcile_trx_tax: ' || 'Processing Non CM activity ');

1370: /*--------------------------------------------------------------------+
1371: |Cache the payment schedule details into the table if already cached |
1372: +--------------------------------------------------------------------*/
1373: IF PG_DEBUG in ('Y', 'C') THEN
1374: arp_standard.debug('Reconcile_trx_tax: ' || 'Processing Non CM activity ');
1375: END IF;
1376:
1377: IF (l_simul_activity = 'Y') THEN
1378:

Line 1380: arp_standard.debug('Reconcile_trx_tax: ' || 'l_simul_activity ' || l_simul_activity);

1376:
1377: IF (l_simul_activity = 'Y') THEN
1378:
1379: IF PG_DEBUG in ('Y', 'C') THEN
1380: arp_standard.debug('Reconcile_trx_tax: ' || 'l_simul_activity ' || l_simul_activity);
1381: END IF;
1382:
1383: FOR l_activity IN get_single_activity LOOP
1384:

Line 1386: arp_standard.debug('Reconcile_trx_tax: ' || 'In loop get single activity');

1382:
1383: FOR l_activity IN get_single_activity LOOP
1384:
1385: IF PG_DEBUG in ('Y', 'C') THEN
1386: arp_standard.debug('Reconcile_trx_tax: ' || 'In loop get single activity');
1387: END IF;
1388:
1389: l_cached := FALSE;
1390:

Line 1398: arp_standard.debug('Reconcile_trx_tax: ' || '5) Hit found in cache');

1394:
1395: IF (l_pay_tbl(l_ctr).applied_payment_schedule_id = l_activity.payment_schedule_id)
1396: THEN
1397: IF PG_DEBUG in ('Y', 'C') THEN
1398: arp_standard.debug('Reconcile_trx_tax: ' || '5) Hit found in cache');
1399: END IF;
1400:
1401: --Set the application record buckets
1402: l_pay_tbl(l_ctr).applied_customer_trx_id := p_customer_trx_id;

Line 1427: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').applied_customer_trx_id = '||l_pay_tbl(l_ctr).applied_customer_trx_id);

1423:
1424: l_cached := TRUE;
1425:
1426: IF PG_DEBUG in ('Y', 'C') THEN
1427: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').applied_customer_trx_id = '||l_pay_tbl(l_ctr).applied_customer_trx_id);
1428: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').applied_payment_schedule_id = '||l_pay_tbl(l_ctr).applied_payment_schedule_id);
1429: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').amount_applied = '||l_pay_tbl(l_ctr).amount_applied);
1430: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').acctd_amount_applied_to = '||l_pay_tbl(l_ctr).acctd_amount_applied_to);
1431: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').line_applied = '||l_pay_tbl(l_ctr).line_applied);

Line 1428: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').applied_payment_schedule_id = '||l_pay_tbl(l_ctr).applied_payment_schedule_id);

1424: l_cached := TRUE;
1425:
1426: IF PG_DEBUG in ('Y', 'C') THEN
1427: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').applied_customer_trx_id = '||l_pay_tbl(l_ctr).applied_customer_trx_id);
1428: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').applied_payment_schedule_id = '||l_pay_tbl(l_ctr).applied_payment_schedule_id);
1429: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').amount_applied = '||l_pay_tbl(l_ctr).amount_applied);
1430: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').acctd_amount_applied_to = '||l_pay_tbl(l_ctr).acctd_amount_applied_to);
1431: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').line_applied = '||l_pay_tbl(l_ctr).line_applied);
1432: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').tax_applied= '||l_pay_tbl(l_ctr).tax_applied);

Line 1429: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').amount_applied = '||l_pay_tbl(l_ctr).amount_applied);

1425:
1426: IF PG_DEBUG in ('Y', 'C') THEN
1427: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').applied_customer_trx_id = '||l_pay_tbl(l_ctr).applied_customer_trx_id);
1428: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').applied_payment_schedule_id = '||l_pay_tbl(l_ctr).applied_payment_schedule_id);
1429: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').amount_applied = '||l_pay_tbl(l_ctr).amount_applied);
1430: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').acctd_amount_applied_to = '||l_pay_tbl(l_ctr).acctd_amount_applied_to);
1431: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').line_applied = '||l_pay_tbl(l_ctr).line_applied);
1432: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').tax_applied= '||l_pay_tbl(l_ctr).tax_applied);
1433: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').freight_applied= '||l_pay_tbl(l_ctr).freight_applied);

Line 1430: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').acctd_amount_applied_to = '||l_pay_tbl(l_ctr).acctd_amount_applied_to);

1426: IF PG_DEBUG in ('Y', 'C') THEN
1427: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').applied_customer_trx_id = '||l_pay_tbl(l_ctr).applied_customer_trx_id);
1428: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').applied_payment_schedule_id = '||l_pay_tbl(l_ctr).applied_payment_schedule_id);
1429: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').amount_applied = '||l_pay_tbl(l_ctr).amount_applied);
1430: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').acctd_amount_applied_to = '||l_pay_tbl(l_ctr).acctd_amount_applied_to);
1431: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').line_applied = '||l_pay_tbl(l_ctr).line_applied);
1432: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').tax_applied= '||l_pay_tbl(l_ctr).tax_applied);
1433: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').freight_applied= '||l_pay_tbl(l_ctr).freight_applied);
1434: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').receivables_charges_applied= '||l_pay_tbl(l_ctr).receivables_charges_applied);

Line 1431: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').line_applied = '||l_pay_tbl(l_ctr).line_applied);

1427: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').applied_customer_trx_id = '||l_pay_tbl(l_ctr).applied_customer_trx_id);
1428: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').applied_payment_schedule_id = '||l_pay_tbl(l_ctr).applied_payment_schedule_id);
1429: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').amount_applied = '||l_pay_tbl(l_ctr).amount_applied);
1430: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').acctd_amount_applied_to = '||l_pay_tbl(l_ctr).acctd_amount_applied_to);
1431: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').line_applied = '||l_pay_tbl(l_ctr).line_applied);
1432: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').tax_applied= '||l_pay_tbl(l_ctr).tax_applied);
1433: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').freight_applied= '||l_pay_tbl(l_ctr).freight_applied);
1434: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').receivables_charges_applied= '||l_pay_tbl(l_ctr).receivables_charges_applied);
1435: END IF;

Line 1432: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').tax_applied= '||l_pay_tbl(l_ctr).tax_applied);

1428: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').applied_payment_schedule_id = '||l_pay_tbl(l_ctr).applied_payment_schedule_id);
1429: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').amount_applied = '||l_pay_tbl(l_ctr).amount_applied);
1430: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').acctd_amount_applied_to = '||l_pay_tbl(l_ctr).acctd_amount_applied_to);
1431: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').line_applied = '||l_pay_tbl(l_ctr).line_applied);
1432: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').tax_applied= '||l_pay_tbl(l_ctr).tax_applied);
1433: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').freight_applied= '||l_pay_tbl(l_ctr).freight_applied);
1434: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').receivables_charges_applied= '||l_pay_tbl(l_ctr).receivables_charges_applied);
1435: END IF;
1436: END IF; --add to cache

Line 1433: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').freight_applied= '||l_pay_tbl(l_ctr).freight_applied);

1429: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').amount_applied = '||l_pay_tbl(l_ctr).amount_applied);
1430: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').acctd_amount_applied_to = '||l_pay_tbl(l_ctr).acctd_amount_applied_to);
1431: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').line_applied = '||l_pay_tbl(l_ctr).line_applied);
1432: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').tax_applied= '||l_pay_tbl(l_ctr).tax_applied);
1433: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').freight_applied= '||l_pay_tbl(l_ctr).freight_applied);
1434: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').receivables_charges_applied= '||l_pay_tbl(l_ctr).receivables_charges_applied);
1435: END IF;
1436: END IF; --add to cache
1437:

Line 1434: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').receivables_charges_applied= '||l_pay_tbl(l_ctr).receivables_charges_applied);

1430: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').acctd_amount_applied_to = '||l_pay_tbl(l_ctr).acctd_amount_applied_to);
1431: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').line_applied = '||l_pay_tbl(l_ctr).line_applied);
1432: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').tax_applied= '||l_pay_tbl(l_ctr).tax_applied);
1433: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').freight_applied= '||l_pay_tbl(l_ctr).freight_applied);
1434: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_ctr||').receivables_charges_applied= '||l_pay_tbl(l_ctr).receivables_charges_applied);
1435: END IF;
1436: END IF; --add to cache
1437:
1438: END LOOP; --process cached lines in payment table

Line 1448: arp_standard.debug('Reconcile_trx_tax: ' || '5) Now caching');

1444: +------------------------------------------------------------------------*/
1445: IF (NOT l_cached) THEN
1446:
1447: IF PG_DEBUG in ('Y', 'C') THEN
1448: arp_standard.debug('Reconcile_trx_tax: ' || '5) Now caching');
1449: END IF;
1450:
1451: l_pay_ctr := l_pay_ctr + 1;
1452:

Line 1466: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').applied_customer_trx_id = '||l_pay_tbl(l_pay_ctr).applied_customer_trx_id);

1462:
1463: l_cached := TRUE;
1464:
1465: IF PG_DEBUG in ('Y', 'C') THEN
1466: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').applied_customer_trx_id = '||l_pay_tbl(l_pay_ctr).applied_customer_trx_id);
1467: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').applied_payment_schedule_id = '||l_pay_tbl(l_pay_ctr).applied_payment_schedule_id);
1468: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').amount_applied = '||l_pay_tbl(l_pay_ctr).amount_applied);
1469: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').acctd_amount_applied_to = '||l_pay_tbl(l_pay_ctr).acctd_amount_applied_to);
1470: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').line_applied = '||l_pay_tbl(l_pay_ctr).line_applied);

Line 1467: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').applied_payment_schedule_id = '||l_pay_tbl(l_pay_ctr).applied_payment_schedule_id);

1463: l_cached := TRUE;
1464:
1465: IF PG_DEBUG in ('Y', 'C') THEN
1466: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').applied_customer_trx_id = '||l_pay_tbl(l_pay_ctr).applied_customer_trx_id);
1467: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').applied_payment_schedule_id = '||l_pay_tbl(l_pay_ctr).applied_payment_schedule_id);
1468: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').amount_applied = '||l_pay_tbl(l_pay_ctr).amount_applied);
1469: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').acctd_amount_applied_to = '||l_pay_tbl(l_pay_ctr).acctd_amount_applied_to);
1470: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').line_applied = '||l_pay_tbl(l_pay_ctr).line_applied);
1471: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').tax_applied= '||l_pay_tbl(l_pay_ctr).tax_applied);

Line 1468: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').amount_applied = '||l_pay_tbl(l_pay_ctr).amount_applied);

1464:
1465: IF PG_DEBUG in ('Y', 'C') THEN
1466: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').applied_customer_trx_id = '||l_pay_tbl(l_pay_ctr).applied_customer_trx_id);
1467: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').applied_payment_schedule_id = '||l_pay_tbl(l_pay_ctr).applied_payment_schedule_id);
1468: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').amount_applied = '||l_pay_tbl(l_pay_ctr).amount_applied);
1469: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').acctd_amount_applied_to = '||l_pay_tbl(l_pay_ctr).acctd_amount_applied_to);
1470: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').line_applied = '||l_pay_tbl(l_pay_ctr).line_applied);
1471: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').tax_applied= '||l_pay_tbl(l_pay_ctr).tax_applied);
1472: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').freight_applied= '||l_pay_tbl(l_pay_ctr).freight_applied);

Line 1469: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').acctd_amount_applied_to = '||l_pay_tbl(l_pay_ctr).acctd_amount_applied_to);

1465: IF PG_DEBUG in ('Y', 'C') THEN
1466: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').applied_customer_trx_id = '||l_pay_tbl(l_pay_ctr).applied_customer_trx_id);
1467: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').applied_payment_schedule_id = '||l_pay_tbl(l_pay_ctr).applied_payment_schedule_id);
1468: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').amount_applied = '||l_pay_tbl(l_pay_ctr).amount_applied);
1469: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').acctd_amount_applied_to = '||l_pay_tbl(l_pay_ctr).acctd_amount_applied_to);
1470: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').line_applied = '||l_pay_tbl(l_pay_ctr).line_applied);
1471: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').tax_applied= '||l_pay_tbl(l_pay_ctr).tax_applied);
1472: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').freight_applied= '||l_pay_tbl(l_pay_ctr).freight_applied);
1473: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').receivables_charges_applied= '||l_pay_tbl(l_pay_ctr).receivables_charges_applied);

Line 1470: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').line_applied = '||l_pay_tbl(l_pay_ctr).line_applied);

1466: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').applied_customer_trx_id = '||l_pay_tbl(l_pay_ctr).applied_customer_trx_id);
1467: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').applied_payment_schedule_id = '||l_pay_tbl(l_pay_ctr).applied_payment_schedule_id);
1468: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').amount_applied = '||l_pay_tbl(l_pay_ctr).amount_applied);
1469: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').acctd_amount_applied_to = '||l_pay_tbl(l_pay_ctr).acctd_amount_applied_to);
1470: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').line_applied = '||l_pay_tbl(l_pay_ctr).line_applied);
1471: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').tax_applied= '||l_pay_tbl(l_pay_ctr).tax_applied);
1472: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').freight_applied= '||l_pay_tbl(l_pay_ctr).freight_applied);
1473: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').receivables_charges_applied= '||l_pay_tbl(l_pay_ctr).receivables_charges_applied);
1474: END IF;

Line 1471: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').tax_applied= '||l_pay_tbl(l_pay_ctr).tax_applied);

1467: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').applied_payment_schedule_id = '||l_pay_tbl(l_pay_ctr).applied_payment_schedule_id);
1468: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').amount_applied = '||l_pay_tbl(l_pay_ctr).amount_applied);
1469: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').acctd_amount_applied_to = '||l_pay_tbl(l_pay_ctr).acctd_amount_applied_to);
1470: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').line_applied = '||l_pay_tbl(l_pay_ctr).line_applied);
1471: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').tax_applied= '||l_pay_tbl(l_pay_ctr).tax_applied);
1472: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').freight_applied= '||l_pay_tbl(l_pay_ctr).freight_applied);
1473: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').receivables_charges_applied= '||l_pay_tbl(l_pay_ctr).receivables_charges_applied);
1474: END IF;
1475:

Line 1472: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').freight_applied= '||l_pay_tbl(l_pay_ctr).freight_applied);

1468: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').amount_applied = '||l_pay_tbl(l_pay_ctr).amount_applied);
1469: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').acctd_amount_applied_to = '||l_pay_tbl(l_pay_ctr).acctd_amount_applied_to);
1470: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').line_applied = '||l_pay_tbl(l_pay_ctr).line_applied);
1471: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').tax_applied= '||l_pay_tbl(l_pay_ctr).tax_applied);
1472: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').freight_applied= '||l_pay_tbl(l_pay_ctr).freight_applied);
1473: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').receivables_charges_applied= '||l_pay_tbl(l_pay_ctr).receivables_charges_applied);
1474: END IF;
1475:
1476: END IF; --not cached

Line 1473: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').receivables_charges_applied= '||l_pay_tbl(l_pay_ctr).receivables_charges_applied);

1469: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').acctd_amount_applied_to = '||l_pay_tbl(l_pay_ctr).acctd_amount_applied_to);
1470: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').line_applied = '||l_pay_tbl(l_pay_ctr).line_applied);
1471: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').tax_applied= '||l_pay_tbl(l_pay_ctr).tax_applied);
1472: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').freight_applied= '||l_pay_tbl(l_pay_ctr).freight_applied);
1473: arp_standard.debug('Reconcile_trx_tax: ' || 'l_pay_tbl('||l_pay_ctr||').receivables_charges_applied= '||l_pay_tbl(l_pay_ctr).receivables_charges_applied);
1474: END IF;
1475:
1476: END IF; --not cached
1477:

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 1693: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP applied_customer_trx_id ' || l_pay_tbl(l_pay_ctr).applied_customer_trx_id);

1689: l_pay_tbl(l_pay_ctr).freight_applied := l_br_tbl(l_assn_ctr).br_adj_frt_amt * -1;
1690: l_pay_tbl(l_pay_ctr).receivables_charges_applied := l_br_tbl(l_assn_ctr).br_adj_chrg_amt * -1;
1691:
1692: IF PG_DEBUG in ('Y', 'C') THEN
1693: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP applied_customer_trx_id ' || l_pay_tbl(l_pay_ctr).applied_customer_trx_id);
1694: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP applied_payment_schedule_id ' || l_pay_tbl(l_pay_ctr).applied_payment_schedule_id);
1695: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP amount_applied ' || l_pay_tbl(l_pay_ctr).amount_applied);
1696: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP acctd_amount_applied_to ' || l_pay_tbl(l_pay_ctr).acctd_amount_applied_to);
1697: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP line_applied ' || l_pay_tbl(l_pay_ctr).line_applied);

Line 1694: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP applied_payment_schedule_id ' || l_pay_tbl(l_pay_ctr).applied_payment_schedule_id);

1690: l_pay_tbl(l_pay_ctr).receivables_charges_applied := l_br_tbl(l_assn_ctr).br_adj_chrg_amt * -1;
1691:
1692: IF PG_DEBUG in ('Y', 'C') THEN
1693: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP applied_customer_trx_id ' || l_pay_tbl(l_pay_ctr).applied_customer_trx_id);
1694: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP applied_payment_schedule_id ' || l_pay_tbl(l_pay_ctr).applied_payment_schedule_id);
1695: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP amount_applied ' || l_pay_tbl(l_pay_ctr).amount_applied);
1696: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP acctd_amount_applied_to ' || l_pay_tbl(l_pay_ctr).acctd_amount_applied_to);
1697: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP line_applied ' || l_pay_tbl(l_pay_ctr).line_applied);
1698: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP tax_applied ' || l_pay_tbl(l_pay_ctr).tax_applied);

Line 1695: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP amount_applied ' || l_pay_tbl(l_pay_ctr).amount_applied);

1691:
1692: IF PG_DEBUG in ('Y', 'C') THEN
1693: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP applied_customer_trx_id ' || l_pay_tbl(l_pay_ctr).applied_customer_trx_id);
1694: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP applied_payment_schedule_id ' || l_pay_tbl(l_pay_ctr).applied_payment_schedule_id);
1695: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP amount_applied ' || l_pay_tbl(l_pay_ctr).amount_applied);
1696: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP acctd_amount_applied_to ' || l_pay_tbl(l_pay_ctr).acctd_amount_applied_to);
1697: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP line_applied ' || l_pay_tbl(l_pay_ctr).line_applied);
1698: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP tax_applied ' || l_pay_tbl(l_pay_ctr).tax_applied);
1699: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP freight_applied ' || l_pay_tbl(l_pay_ctr).freight_applied);

Line 1696: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP acctd_amount_applied_to ' || l_pay_tbl(l_pay_ctr).acctd_amount_applied_to);

1692: IF PG_DEBUG in ('Y', 'C') THEN
1693: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP applied_customer_trx_id ' || l_pay_tbl(l_pay_ctr).applied_customer_trx_id);
1694: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP applied_payment_schedule_id ' || l_pay_tbl(l_pay_ctr).applied_payment_schedule_id);
1695: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP amount_applied ' || l_pay_tbl(l_pay_ctr).amount_applied);
1696: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP acctd_amount_applied_to ' || l_pay_tbl(l_pay_ctr).acctd_amount_applied_to);
1697: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP line_applied ' || l_pay_tbl(l_pay_ctr).line_applied);
1698: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP tax_applied ' || l_pay_tbl(l_pay_ctr).tax_applied);
1699: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP freight_applied ' || l_pay_tbl(l_pay_ctr).freight_applied);
1700: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP receivables_charges_applied ' || l_pay_tbl(l_pay_ctr).receivables_charges_applied);

Line 1697: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP line_applied ' || l_pay_tbl(l_pay_ctr).line_applied);

1693: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP applied_customer_trx_id ' || l_pay_tbl(l_pay_ctr).applied_customer_trx_id);
1694: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP applied_payment_schedule_id ' || l_pay_tbl(l_pay_ctr).applied_payment_schedule_id);
1695: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP amount_applied ' || l_pay_tbl(l_pay_ctr).amount_applied);
1696: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP acctd_amount_applied_to ' || l_pay_tbl(l_pay_ctr).acctd_amount_applied_to);
1697: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP line_applied ' || l_pay_tbl(l_pay_ctr).line_applied);
1698: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP tax_applied ' || l_pay_tbl(l_pay_ctr).tax_applied);
1699: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP freight_applied ' || l_pay_tbl(l_pay_ctr).freight_applied);
1700: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP receivables_charges_applied ' || l_pay_tbl(l_pay_ctr).receivables_charges_applied);
1701: arp_standard.debug('Reconcile_br_tax: ' || 'Drawee Site Id ' || l_br_tbl(l_assn_ctr).drawee_site_use_id);

Line 1698: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP tax_applied ' || l_pay_tbl(l_pay_ctr).tax_applied);

1694: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP applied_payment_schedule_id ' || l_pay_tbl(l_pay_ctr).applied_payment_schedule_id);
1695: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP amount_applied ' || l_pay_tbl(l_pay_ctr).amount_applied);
1696: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP acctd_amount_applied_to ' || l_pay_tbl(l_pay_ctr).acctd_amount_applied_to);
1697: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP line_applied ' || l_pay_tbl(l_pay_ctr).line_applied);
1698: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP tax_applied ' || l_pay_tbl(l_pay_ctr).tax_applied);
1699: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP freight_applied ' || l_pay_tbl(l_pay_ctr).freight_applied);
1700: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP receivables_charges_applied ' || l_pay_tbl(l_pay_ctr).receivables_charges_applied);
1701: arp_standard.debug('Reconcile_br_tax: ' || 'Drawee Site Id ' || l_br_tbl(l_assn_ctr).drawee_site_use_id);
1702: END IF;

Line 1699: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP freight_applied ' || l_pay_tbl(l_pay_ctr).freight_applied);

1695: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP amount_applied ' || l_pay_tbl(l_pay_ctr).amount_applied);
1696: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP acctd_amount_applied_to ' || l_pay_tbl(l_pay_ctr).acctd_amount_applied_to);
1697: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP line_applied ' || l_pay_tbl(l_pay_ctr).line_applied);
1698: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP tax_applied ' || l_pay_tbl(l_pay_ctr).tax_applied);
1699: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP freight_applied ' || l_pay_tbl(l_pay_ctr).freight_applied);
1700: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP receivables_charges_applied ' || l_pay_tbl(l_pay_ctr).receivables_charges_applied);
1701: arp_standard.debug('Reconcile_br_tax: ' || 'Drawee Site Id ' || l_br_tbl(l_assn_ctr).drawee_site_use_id);
1702: END IF;
1703:

Line 1700: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP receivables_charges_applied ' || l_pay_tbl(l_pay_ctr).receivables_charges_applied);

1696: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP acctd_amount_applied_to ' || l_pay_tbl(l_pay_ctr).acctd_amount_applied_to);
1697: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP line_applied ' || l_pay_tbl(l_pay_ctr).line_applied);
1698: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP tax_applied ' || l_pay_tbl(l_pay_ctr).tax_applied);
1699: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP freight_applied ' || l_pay_tbl(l_pay_ctr).freight_applied);
1700: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP receivables_charges_applied ' || l_pay_tbl(l_pay_ctr).receivables_charges_applied);
1701: arp_standard.debug('Reconcile_br_tax: ' || 'Drawee Site Id ' || l_br_tbl(l_assn_ctr).drawee_site_use_id);
1702: END IF;
1703:
1704: /*--------------------------------------------------------------------------+

Line 1701: arp_standard.debug('Reconcile_br_tax: ' || 'Drawee Site Id ' || l_br_tbl(l_assn_ctr).drawee_site_use_id);

1697: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP line_applied ' || l_pay_tbl(l_pay_ctr).line_applied);
1698: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP tax_applied ' || l_pay_tbl(l_pay_ctr).tax_applied);
1699: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP freight_applied ' || l_pay_tbl(l_pay_ctr).freight_applied);
1700: arp_standard.debug('Reconcile_br_tax: ' || 'l_pay_tbl APP receivables_charges_applied ' || l_pay_tbl(l_pay_ctr).receivables_charges_applied);
1701: arp_standard.debug('Reconcile_br_tax: ' || 'Drawee Site Id ' || l_br_tbl(l_assn_ctr).drawee_site_use_id);
1702: END IF;
1703:
1704: /*--------------------------------------------------------------------------+
1705: | Recursive call required because current assignment is a bill of exchange.|

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 1877: arp_standard.debug('Detect_Closure: ' || 'p_customer_trx_id ' || p_customer_trx_id);

1873: from ar_payment_schedules pay
1874: where pay.customer_trx_id = p_customer_trx_id;
1875: END IF;
1876: IF PG_DEBUG in ('Y', 'C') THEN
1877: arp_standard.debug('Detect_Closure: ' || 'p_customer_trx_id ' || p_customer_trx_id);
1878: arp_standard.debug('Detect_Closure: ' || 'pay_class ' || p_pay_class);
1879: arp_standard.debug('Detect_Closure: ' || 'p_pay_sched_upd_yn ' || p_pay_sched_upd_yn);
1880: arp_standard.debug('Detect_Closure: ' || 'p_pay_sched_upd_cm_yn ' || p_pay_sched_upd_cm_yn);
1881: arp_standard.debug('Detect_Closure: ' || 'g_call_num ' || g_call_num);

Line 1878: arp_standard.debug('Detect_Closure: ' || 'pay_class ' || p_pay_class);

1874: where pay.customer_trx_id = p_customer_trx_id;
1875: END IF;
1876: IF PG_DEBUG in ('Y', 'C') THEN
1877: arp_standard.debug('Detect_Closure: ' || 'p_customer_trx_id ' || p_customer_trx_id);
1878: arp_standard.debug('Detect_Closure: ' || 'pay_class ' || p_pay_class);
1879: arp_standard.debug('Detect_Closure: ' || 'p_pay_sched_upd_yn ' || p_pay_sched_upd_yn);
1880: arp_standard.debug('Detect_Closure: ' || 'p_pay_sched_upd_cm_yn ' || p_pay_sched_upd_cm_yn);
1881: arp_standard.debug('Detect_Closure: ' || 'g_call_num ' || g_call_num);
1882: arp_standard.debug('Detect_Closure: ' || 'Parameter p_activity_amt ' || p_activity_amt);

Line 1879: arp_standard.debug('Detect_Closure: ' || 'p_pay_sched_upd_yn ' || p_pay_sched_upd_yn);

1875: END IF;
1876: IF PG_DEBUG in ('Y', 'C') THEN
1877: arp_standard.debug('Detect_Closure: ' || 'p_customer_trx_id ' || p_customer_trx_id);
1878: arp_standard.debug('Detect_Closure: ' || 'pay_class ' || p_pay_class);
1879: arp_standard.debug('Detect_Closure: ' || 'p_pay_sched_upd_yn ' || p_pay_sched_upd_yn);
1880: arp_standard.debug('Detect_Closure: ' || 'p_pay_sched_upd_cm_yn ' || p_pay_sched_upd_cm_yn);
1881: arp_standard.debug('Detect_Closure: ' || 'g_call_num ' || g_call_num);
1882: arp_standard.debug('Detect_Closure: ' || 'Parameter p_activity_amt ' || p_activity_amt);
1883: arp_standard.debug('Detect_Closure: ' || 'Parameter p_activity_acctd_amt ' || p_activity_acctd_amt);

Line 1880: arp_standard.debug('Detect_Closure: ' || 'p_pay_sched_upd_cm_yn ' || p_pay_sched_upd_cm_yn);

1876: IF PG_DEBUG in ('Y', 'C') THEN
1877: arp_standard.debug('Detect_Closure: ' || 'p_customer_trx_id ' || p_customer_trx_id);
1878: arp_standard.debug('Detect_Closure: ' || 'pay_class ' || p_pay_class);
1879: arp_standard.debug('Detect_Closure: ' || 'p_pay_sched_upd_yn ' || p_pay_sched_upd_yn);
1880: arp_standard.debug('Detect_Closure: ' || 'p_pay_sched_upd_cm_yn ' || p_pay_sched_upd_cm_yn);
1881: arp_standard.debug('Detect_Closure: ' || 'g_call_num ' || g_call_num);
1882: arp_standard.debug('Detect_Closure: ' || 'Parameter p_activity_amt ' || p_activity_amt);
1883: arp_standard.debug('Detect_Closure: ' || 'Parameter p_activity_acctd_amt ' || p_activity_acctd_amt);
1884: arp_standard.debug('Detect_Closure: ' || 'Selected pay l_amount_due_remaining ' || l_amount_due_remaining);

Line 1881: arp_standard.debug('Detect_Closure: ' || 'g_call_num ' || g_call_num);

1877: arp_standard.debug('Detect_Closure: ' || 'p_customer_trx_id ' || p_customer_trx_id);
1878: arp_standard.debug('Detect_Closure: ' || 'pay_class ' || p_pay_class);
1879: arp_standard.debug('Detect_Closure: ' || 'p_pay_sched_upd_yn ' || p_pay_sched_upd_yn);
1880: arp_standard.debug('Detect_Closure: ' || 'p_pay_sched_upd_cm_yn ' || p_pay_sched_upd_cm_yn);
1881: arp_standard.debug('Detect_Closure: ' || 'g_call_num ' || g_call_num);
1882: arp_standard.debug('Detect_Closure: ' || 'Parameter p_activity_amt ' || p_activity_amt);
1883: arp_standard.debug('Detect_Closure: ' || 'Parameter p_activity_acctd_amt ' || p_activity_acctd_amt);
1884: arp_standard.debug('Detect_Closure: ' || 'Selected pay l_amount_due_remaining ' || l_amount_due_remaining);
1885: arp_standard.debug('Detect_Closure: ' || 'Selected pay l_acctd_amount_due_remaining ' || l_acctd_amount_due_remaining);

Line 1882: arp_standard.debug('Detect_Closure: ' || 'Parameter p_activity_amt ' || p_activity_amt);

1878: arp_standard.debug('Detect_Closure: ' || 'pay_class ' || p_pay_class);
1879: arp_standard.debug('Detect_Closure: ' || 'p_pay_sched_upd_yn ' || p_pay_sched_upd_yn);
1880: arp_standard.debug('Detect_Closure: ' || 'p_pay_sched_upd_cm_yn ' || p_pay_sched_upd_cm_yn);
1881: arp_standard.debug('Detect_Closure: ' || 'g_call_num ' || g_call_num);
1882: arp_standard.debug('Detect_Closure: ' || 'Parameter p_activity_amt ' || p_activity_amt);
1883: arp_standard.debug('Detect_Closure: ' || 'Parameter p_activity_acctd_amt ' || p_activity_acctd_amt);
1884: arp_standard.debug('Detect_Closure: ' || 'Selected pay l_amount_due_remaining ' || l_amount_due_remaining);
1885: arp_standard.debug('Detect_Closure: ' || 'Selected pay l_acctd_amount_due_remaining ' || l_acctd_amount_due_remaining);
1886: END IF;

Line 1883: arp_standard.debug('Detect_Closure: ' || 'Parameter p_activity_acctd_amt ' || p_activity_acctd_amt);

1879: arp_standard.debug('Detect_Closure: ' || 'p_pay_sched_upd_yn ' || p_pay_sched_upd_yn);
1880: arp_standard.debug('Detect_Closure: ' || 'p_pay_sched_upd_cm_yn ' || p_pay_sched_upd_cm_yn);
1881: arp_standard.debug('Detect_Closure: ' || 'g_call_num ' || g_call_num);
1882: arp_standard.debug('Detect_Closure: ' || 'Parameter p_activity_amt ' || p_activity_amt);
1883: arp_standard.debug('Detect_Closure: ' || 'Parameter p_activity_acctd_amt ' || p_activity_acctd_amt);
1884: arp_standard.debug('Detect_Closure: ' || 'Selected pay l_amount_due_remaining ' || l_amount_due_remaining);
1885: arp_standard.debug('Detect_Closure: ' || 'Selected pay l_acctd_amount_due_remaining ' || l_acctd_amount_due_remaining);
1886: END IF;
1887:

Line 1884: arp_standard.debug('Detect_Closure: ' || 'Selected pay l_amount_due_remaining ' || l_amount_due_remaining);

1880: arp_standard.debug('Detect_Closure: ' || 'p_pay_sched_upd_cm_yn ' || p_pay_sched_upd_cm_yn);
1881: arp_standard.debug('Detect_Closure: ' || 'g_call_num ' || g_call_num);
1882: arp_standard.debug('Detect_Closure: ' || 'Parameter p_activity_amt ' || p_activity_amt);
1883: arp_standard.debug('Detect_Closure: ' || 'Parameter p_activity_acctd_amt ' || p_activity_acctd_amt);
1884: arp_standard.debug('Detect_Closure: ' || 'Selected pay l_amount_due_remaining ' || l_amount_due_remaining);
1885: arp_standard.debug('Detect_Closure: ' || 'Selected pay l_acctd_amount_due_remaining ' || l_acctd_amount_due_remaining);
1886: END IF;
1887:
1888: --Set the payment schedule updated flag

Line 1885: arp_standard.debug('Detect_Closure: ' || 'Selected pay l_acctd_amount_due_remaining ' || l_acctd_amount_due_remaining);

1881: arp_standard.debug('Detect_Closure: ' || 'g_call_num ' || g_call_num);
1882: arp_standard.debug('Detect_Closure: ' || 'Parameter p_activity_amt ' || p_activity_amt);
1883: arp_standard.debug('Detect_Closure: ' || 'Parameter p_activity_acctd_amt ' || p_activity_acctd_amt);
1884: arp_standard.debug('Detect_Closure: ' || 'Selected pay l_amount_due_remaining ' || l_amount_due_remaining);
1885: arp_standard.debug('Detect_Closure: ' || 'Selected pay l_acctd_amount_due_remaining ' || l_acctd_amount_due_remaining);
1886: END IF;
1887:
1888: --Set the payment schedule updated flag
1889: IF (p_pay_class = 'CM') AND (g_call_num = 2) AND (p_pay_sched_upd_cm_yn IS NOT NULL) THEN

Line 1905: arp_standard.debug('Detect_Closure: ' || 'Payment schedule not updated hence calculating remaining amounts ');

1901: l_acctd_amount_due_remaining := l_acctd_amount_due_remaining +
1902: p_activity_acctd_amt;
1903:
1904: IF PG_DEBUG in ('Y', 'C') THEN
1905: arp_standard.debug('Detect_Closure: ' || 'Payment schedule not updated hence calculating remaining amounts ');
1906: arp_standard.debug('Detect_Closure: ' || 'l_amount_due_remaining + p_activity_amt ' || l_amount_due_remaining);
1907: arp_standard.debug('Detect_Closure: ' || 'l_acctd_amount_due_remaining + p_activity_acctd_amt ' || l_acctd_amount_due_remaining);
1908: END IF;
1909: END IF;

Line 1906: arp_standard.debug('Detect_Closure: ' || 'l_amount_due_remaining + p_activity_amt ' || l_amount_due_remaining);

1902: p_activity_acctd_amt;
1903:
1904: IF PG_DEBUG in ('Y', 'C') THEN
1905: arp_standard.debug('Detect_Closure: ' || 'Payment schedule not updated hence calculating remaining amounts ');
1906: arp_standard.debug('Detect_Closure: ' || 'l_amount_due_remaining + p_activity_amt ' || l_amount_due_remaining);
1907: arp_standard.debug('Detect_Closure: ' || 'l_acctd_amount_due_remaining + p_activity_acctd_amt ' || l_acctd_amount_due_remaining);
1908: END IF;
1909: END IF;
1910:

Line 1907: arp_standard.debug('Detect_Closure: ' || 'l_acctd_amount_due_remaining + p_activity_acctd_amt ' || l_acctd_amount_due_remaining);

1903:
1904: IF PG_DEBUG in ('Y', 'C') THEN
1905: arp_standard.debug('Detect_Closure: ' || 'Payment schedule not updated hence calculating remaining amounts ');
1906: arp_standard.debug('Detect_Closure: ' || 'l_amount_due_remaining + p_activity_amt ' || l_amount_due_remaining);
1907: arp_standard.debug('Detect_Closure: ' || 'l_acctd_amount_due_remaining + p_activity_acctd_amt ' || l_acctd_amount_due_remaining);
1908: END IF;
1909: END IF;
1910:
1911: /*---------------------------------------------------------------------+

Line 1919: arp_standard.debug('Detect_Closure: ' || 'Transaction ' || p_customer_trx_id || ' payment schedule is not closed - do not reconcile ');

1915:
1916: IF ((l_amount_due_remaining + l_acctd_amount_due_remaining) <> 0) THEN
1917: p_closed_pymt_yn := 'N'; --paymentschedule is not closed so do not call reconciliation routine
1918: IF PG_DEBUG in ('Y', 'C') THEN
1919: arp_standard.debug('Detect_Closure: ' || 'Transaction ' || p_customer_trx_id || ' payment schedule is not closed - do not reconcile ');
1920: END IF;
1921: ELSE
1922: p_closed_pymt_yn := 'Y';
1923: IF PG_DEBUG in ('Y', 'C') THEN

Line 1924: arp_standard.debug('Detect_Closure: ' || 'Transaction ' || p_customer_trx_id || ' payment schedule is closed - reconcile ');

1920: END IF;
1921: ELSE
1922: p_closed_pymt_yn := 'Y';
1923: IF PG_DEBUG in ('Y', 'C') THEN
1924: arp_standard.debug('Detect_Closure: ' || 'Transaction ' || p_customer_trx_id || ' payment schedule is closed - reconcile ');
1925: END IF;
1926: END IF;
1927:
1928: <>

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 2146: arp_standard.debug('Dump_Line_Amts: ' || 'ae_line_type = ' || p_ae_line_rec.ae_line_type);

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);
2150: arp_standard.debug('Dump_Line_Amts: ' || 'account = ' || p_ae_line_rec.account);

Line 2147: arp_standard.debug('Dump_Line_Amts: ' || 'ae_line_type_secondary = ' || p_ae_line_rec.ae_line_type_secondary);

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);
2150: arp_standard.debug('Dump_Line_Amts: ' || 'account = ' || p_ae_line_rec.account);
2151: arp_standard.debug('Dump_Line_Amts: ' || 'entered_dr = ' || p_ae_line_rec.entered_dr);

Line 2148: arp_standard.debug('Dump_Line_Amts: ' || 'source_id = ' || p_ae_line_rec.source_id);

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);
2150: arp_standard.debug('Dump_Line_Amts: ' || 'account = ' || p_ae_line_rec.account);
2151: arp_standard.debug('Dump_Line_Amts: ' || 'entered_dr = ' || p_ae_line_rec.entered_dr);
2152: arp_standard.debug('Dump_Line_Amts: ' || 'entered_cr = ' || p_ae_line_rec.entered_cr);

Line 2149: arp_standard.debug('Dump_Line_Amts: ' || 'source_table = ' || p_ae_line_rec.source_table);

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);
2150: arp_standard.debug('Dump_Line_Amts: ' || 'account = ' || p_ae_line_rec.account);
2151: arp_standard.debug('Dump_Line_Amts: ' || 'entered_dr = ' || p_ae_line_rec.entered_dr);
2152: arp_standard.debug('Dump_Line_Amts: ' || 'entered_cr = ' || p_ae_line_rec.entered_cr);
2153: arp_standard.debug('Dump_Line_Amts: ' || 'accounted_dr = ' || p_ae_line_rec.accounted_dr);

Line 2150: arp_standard.debug('Dump_Line_Amts: ' || 'account = ' || p_ae_line_rec.account);

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);
2150: arp_standard.debug('Dump_Line_Amts: ' || 'account = ' || p_ae_line_rec.account);
2151: arp_standard.debug('Dump_Line_Amts: ' || 'entered_dr = ' || p_ae_line_rec.entered_dr);
2152: arp_standard.debug('Dump_Line_Amts: ' || 'entered_cr = ' || p_ae_line_rec.entered_cr);
2153: arp_standard.debug('Dump_Line_Amts: ' || 'accounted_dr = ' || p_ae_line_rec.accounted_dr);
2154: arp_standard.debug('Dump_Line_Amts: ' || 'accounted_cr = ' || p_ae_line_rec.accounted_cr);

Line 2151: arp_standard.debug('Dump_Line_Amts: ' || 'entered_dr = ' || p_ae_line_rec.entered_dr);

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);
2150: arp_standard.debug('Dump_Line_Amts: ' || 'account = ' || p_ae_line_rec.account);
2151: arp_standard.debug('Dump_Line_Amts: ' || 'entered_dr = ' || p_ae_line_rec.entered_dr);
2152: arp_standard.debug('Dump_Line_Amts: ' || 'entered_cr = ' || p_ae_line_rec.entered_cr);
2153: arp_standard.debug('Dump_Line_Amts: ' || 'accounted_dr = ' || p_ae_line_rec.accounted_dr);
2154: arp_standard.debug('Dump_Line_Amts: ' || 'accounted_cr = ' || p_ae_line_rec.accounted_cr);
2155: arp_standard.debug('Dump_Line_Amts: ' || 'source_id_secondary = ' || p_ae_line_rec.source_id_secondary);

Line 2152: arp_standard.debug('Dump_Line_Amts: ' || 'entered_cr = ' || p_ae_line_rec.entered_cr);

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);
2150: arp_standard.debug('Dump_Line_Amts: ' || 'account = ' || p_ae_line_rec.account);
2151: arp_standard.debug('Dump_Line_Amts: ' || 'entered_dr = ' || p_ae_line_rec.entered_dr);
2152: arp_standard.debug('Dump_Line_Amts: ' || 'entered_cr = ' || p_ae_line_rec.entered_cr);
2153: arp_standard.debug('Dump_Line_Amts: ' || 'accounted_dr = ' || p_ae_line_rec.accounted_dr);
2154: arp_standard.debug('Dump_Line_Amts: ' || 'accounted_cr = ' || p_ae_line_rec.accounted_cr);
2155: arp_standard.debug('Dump_Line_Amts: ' || 'source_id_secondary = ' || p_ae_line_rec.source_id_secondary);
2156: arp_standard.debug('Dump_Line_Amts: ' || 'source_table_secondary = ' || p_ae_line_rec.source_table_secondary);

Line 2153: arp_standard.debug('Dump_Line_Amts: ' || 'accounted_dr = ' || p_ae_line_rec.accounted_dr);

2149: arp_standard.debug('Dump_Line_Amts: ' || 'source_table = ' || p_ae_line_rec.source_table);
2150: arp_standard.debug('Dump_Line_Amts: ' || 'account = ' || p_ae_line_rec.account);
2151: arp_standard.debug('Dump_Line_Amts: ' || 'entered_dr = ' || p_ae_line_rec.entered_dr);
2152: arp_standard.debug('Dump_Line_Amts: ' || 'entered_cr = ' || p_ae_line_rec.entered_cr);
2153: arp_standard.debug('Dump_Line_Amts: ' || 'accounted_dr = ' || p_ae_line_rec.accounted_dr);
2154: arp_standard.debug('Dump_Line_Amts: ' || 'accounted_cr = ' || p_ae_line_rec.accounted_cr);
2155: arp_standard.debug('Dump_Line_Amts: ' || 'source_id_secondary = ' || p_ae_line_rec.source_id_secondary);
2156: arp_standard.debug('Dump_Line_Amts: ' || 'source_table_secondary = ' || p_ae_line_rec.source_table_secondary);
2157: arp_standard.debug('Dump_Line_Amts: ' || 'currency_code = ' || p_ae_line_rec.currency_code);

Line 2154: arp_standard.debug('Dump_Line_Amts: ' || 'accounted_cr = ' || p_ae_line_rec.accounted_cr);

2150: arp_standard.debug('Dump_Line_Amts: ' || 'account = ' || p_ae_line_rec.account);
2151: arp_standard.debug('Dump_Line_Amts: ' || 'entered_dr = ' || p_ae_line_rec.entered_dr);
2152: arp_standard.debug('Dump_Line_Amts: ' || 'entered_cr = ' || p_ae_line_rec.entered_cr);
2153: arp_standard.debug('Dump_Line_Amts: ' || 'accounted_dr = ' || p_ae_line_rec.accounted_dr);
2154: arp_standard.debug('Dump_Line_Amts: ' || 'accounted_cr = ' || p_ae_line_rec.accounted_cr);
2155: arp_standard.debug('Dump_Line_Amts: ' || 'source_id_secondary = ' || p_ae_line_rec.source_id_secondary);
2156: arp_standard.debug('Dump_Line_Amts: ' || 'source_table_secondary = ' || p_ae_line_rec.source_table_secondary);
2157: arp_standard.debug('Dump_Line_Amts: ' || 'currency_code = ' || p_ae_line_rec.currency_code);
2158: arp_standard.debug('Dump_Line_Amts: ' || 'currency_conversion_rate = ' || p_ae_line_rec.currency_conversion_rate);

Line 2155: arp_standard.debug('Dump_Line_Amts: ' || 'source_id_secondary = ' || p_ae_line_rec.source_id_secondary);

2151: arp_standard.debug('Dump_Line_Amts: ' || 'entered_dr = ' || p_ae_line_rec.entered_dr);
2152: arp_standard.debug('Dump_Line_Amts: ' || 'entered_cr = ' || p_ae_line_rec.entered_cr);
2153: arp_standard.debug('Dump_Line_Amts: ' || 'accounted_dr = ' || p_ae_line_rec.accounted_dr);
2154: arp_standard.debug('Dump_Line_Amts: ' || 'accounted_cr = ' || p_ae_line_rec.accounted_cr);
2155: arp_standard.debug('Dump_Line_Amts: ' || 'source_id_secondary = ' || p_ae_line_rec.source_id_secondary);
2156: arp_standard.debug('Dump_Line_Amts: ' || 'source_table_secondary = ' || p_ae_line_rec.source_table_secondary);
2157: arp_standard.debug('Dump_Line_Amts: ' || 'currency_code = ' || p_ae_line_rec.currency_code);
2158: arp_standard.debug('Dump_Line_Amts: ' || 'currency_conversion_rate = ' || p_ae_line_rec.currency_conversion_rate);
2159: arp_standard.debug('Dump_Line_Amts: ' || 'currency_conversion_type = ' || p_ae_line_rec.currency_conversion_type);

Line 2156: arp_standard.debug('Dump_Line_Amts: ' || 'source_table_secondary = ' || p_ae_line_rec.source_table_secondary);

2152: arp_standard.debug('Dump_Line_Amts: ' || 'entered_cr = ' || p_ae_line_rec.entered_cr);
2153: arp_standard.debug('Dump_Line_Amts: ' || 'accounted_dr = ' || p_ae_line_rec.accounted_dr);
2154: arp_standard.debug('Dump_Line_Amts: ' || 'accounted_cr = ' || p_ae_line_rec.accounted_cr);
2155: arp_standard.debug('Dump_Line_Amts: ' || 'source_id_secondary = ' || p_ae_line_rec.source_id_secondary);
2156: arp_standard.debug('Dump_Line_Amts: ' || 'source_table_secondary = ' || p_ae_line_rec.source_table_secondary);
2157: arp_standard.debug('Dump_Line_Amts: ' || 'currency_code = ' || p_ae_line_rec.currency_code);
2158: arp_standard.debug('Dump_Line_Amts: ' || 'currency_conversion_rate = ' || p_ae_line_rec.currency_conversion_rate);
2159: arp_standard.debug('Dump_Line_Amts: ' || 'currency_conversion_type = ' || p_ae_line_rec.currency_conversion_type);
2160: arp_standard.debug('Dump_Line_Amts: ' || 'currency_conversion_date = ' || p_ae_line_rec.currency_conversion_date);

Line 2157: arp_standard.debug('Dump_Line_Amts: ' || 'currency_code = ' || p_ae_line_rec.currency_code);

2153: arp_standard.debug('Dump_Line_Amts: ' || 'accounted_dr = ' || p_ae_line_rec.accounted_dr);
2154: arp_standard.debug('Dump_Line_Amts: ' || 'accounted_cr = ' || p_ae_line_rec.accounted_cr);
2155: arp_standard.debug('Dump_Line_Amts: ' || 'source_id_secondary = ' || p_ae_line_rec.source_id_secondary);
2156: arp_standard.debug('Dump_Line_Amts: ' || 'source_table_secondary = ' || p_ae_line_rec.source_table_secondary);
2157: arp_standard.debug('Dump_Line_Amts: ' || 'currency_code = ' || p_ae_line_rec.currency_code);
2158: arp_standard.debug('Dump_Line_Amts: ' || 'currency_conversion_rate = ' || p_ae_line_rec.currency_conversion_rate);
2159: arp_standard.debug('Dump_Line_Amts: ' || 'currency_conversion_type = ' || p_ae_line_rec.currency_conversion_type);
2160: arp_standard.debug('Dump_Line_Amts: ' || 'currency_conversion_date = ' || p_ae_line_rec.currency_conversion_date);
2161: arp_standard.debug('Dump_Line_Amts: ' || 'third_party_id = ' || p_ae_line_rec.third_party_id);

Line 2158: arp_standard.debug('Dump_Line_Amts: ' || 'currency_conversion_rate = ' || p_ae_line_rec.currency_conversion_rate);

2154: arp_standard.debug('Dump_Line_Amts: ' || 'accounted_cr = ' || p_ae_line_rec.accounted_cr);
2155: arp_standard.debug('Dump_Line_Amts: ' || 'source_id_secondary = ' || p_ae_line_rec.source_id_secondary);
2156: arp_standard.debug('Dump_Line_Amts: ' || 'source_table_secondary = ' || p_ae_line_rec.source_table_secondary);
2157: arp_standard.debug('Dump_Line_Amts: ' || 'currency_code = ' || p_ae_line_rec.currency_code);
2158: arp_standard.debug('Dump_Line_Amts: ' || 'currency_conversion_rate = ' || p_ae_line_rec.currency_conversion_rate);
2159: arp_standard.debug('Dump_Line_Amts: ' || 'currency_conversion_type = ' || p_ae_line_rec.currency_conversion_type);
2160: arp_standard.debug('Dump_Line_Amts: ' || 'currency_conversion_date = ' || p_ae_line_rec.currency_conversion_date);
2161: arp_standard.debug('Dump_Line_Amts: ' || 'third_party_id = ' || p_ae_line_rec.third_party_id);
2162: arp_standard.debug('Dump_Line_Amts: ' || 'third_party_sub_id = ' || p_ae_line_rec.third_party_sub_id);

Line 2159: arp_standard.debug('Dump_Line_Amts: ' || 'currency_conversion_type = ' || p_ae_line_rec.currency_conversion_type);

2155: arp_standard.debug('Dump_Line_Amts: ' || 'source_id_secondary = ' || p_ae_line_rec.source_id_secondary);
2156: arp_standard.debug('Dump_Line_Amts: ' || 'source_table_secondary = ' || p_ae_line_rec.source_table_secondary);
2157: arp_standard.debug('Dump_Line_Amts: ' || 'currency_code = ' || p_ae_line_rec.currency_code);
2158: arp_standard.debug('Dump_Line_Amts: ' || 'currency_conversion_rate = ' || p_ae_line_rec.currency_conversion_rate);
2159: arp_standard.debug('Dump_Line_Amts: ' || 'currency_conversion_type = ' || p_ae_line_rec.currency_conversion_type);
2160: arp_standard.debug('Dump_Line_Amts: ' || 'currency_conversion_date = ' || p_ae_line_rec.currency_conversion_date);
2161: arp_standard.debug('Dump_Line_Amts: ' || 'third_party_id = ' || p_ae_line_rec.third_party_id);
2162: arp_standard.debug('Dump_Line_Amts: ' || 'third_party_sub_id = ' || p_ae_line_rec.third_party_sub_id);
2163: arp_standard.debug('Dump_Line_Amts: ' || 'tax_group_code_id = ' || p_ae_line_rec.tax_group_code_id);

Line 2160: arp_standard.debug('Dump_Line_Amts: ' || 'currency_conversion_date = ' || p_ae_line_rec.currency_conversion_date);

2156: arp_standard.debug('Dump_Line_Amts: ' || 'source_table_secondary = ' || p_ae_line_rec.source_table_secondary);
2157: arp_standard.debug('Dump_Line_Amts: ' || 'currency_code = ' || p_ae_line_rec.currency_code);
2158: arp_standard.debug('Dump_Line_Amts: ' || 'currency_conversion_rate = ' || p_ae_line_rec.currency_conversion_rate);
2159: arp_standard.debug('Dump_Line_Amts: ' || 'currency_conversion_type = ' || p_ae_line_rec.currency_conversion_type);
2160: arp_standard.debug('Dump_Line_Amts: ' || 'currency_conversion_date = ' || p_ae_line_rec.currency_conversion_date);
2161: arp_standard.debug('Dump_Line_Amts: ' || 'third_party_id = ' || p_ae_line_rec.third_party_id);
2162: arp_standard.debug('Dump_Line_Amts: ' || 'third_party_sub_id = ' || p_ae_line_rec.third_party_sub_id);
2163: arp_standard.debug('Dump_Line_Amts: ' || 'tax_group_code_id = ' || p_ae_line_rec.tax_group_code_id);
2164: arp_standard.debug('Dump_Line_Amts: ' || 'tax_code_id = ' || p_ae_line_rec.tax_code_id);

Line 2161: arp_standard.debug('Dump_Line_Amts: ' || 'third_party_id = ' || p_ae_line_rec.third_party_id);

2157: arp_standard.debug('Dump_Line_Amts: ' || 'currency_code = ' || p_ae_line_rec.currency_code);
2158: arp_standard.debug('Dump_Line_Amts: ' || 'currency_conversion_rate = ' || p_ae_line_rec.currency_conversion_rate);
2159: arp_standard.debug('Dump_Line_Amts: ' || 'currency_conversion_type = ' || p_ae_line_rec.currency_conversion_type);
2160: arp_standard.debug('Dump_Line_Amts: ' || 'currency_conversion_date = ' || p_ae_line_rec.currency_conversion_date);
2161: arp_standard.debug('Dump_Line_Amts: ' || 'third_party_id = ' || p_ae_line_rec.third_party_id);
2162: arp_standard.debug('Dump_Line_Amts: ' || 'third_party_sub_id = ' || p_ae_line_rec.third_party_sub_id);
2163: arp_standard.debug('Dump_Line_Amts: ' || 'tax_group_code_id = ' || p_ae_line_rec.tax_group_code_id);
2164: arp_standard.debug('Dump_Line_Amts: ' || 'tax_code_id = ' || p_ae_line_rec.tax_code_id);
2165: arp_standard.debug('Dump_Line_Amts: ' || 'location_segment_id = ' || p_ae_line_rec.location_segment_id);

Line 2162: arp_standard.debug('Dump_Line_Amts: ' || 'third_party_sub_id = ' || p_ae_line_rec.third_party_sub_id);

2158: arp_standard.debug('Dump_Line_Amts: ' || 'currency_conversion_rate = ' || p_ae_line_rec.currency_conversion_rate);
2159: arp_standard.debug('Dump_Line_Amts: ' || 'currency_conversion_type = ' || p_ae_line_rec.currency_conversion_type);
2160: arp_standard.debug('Dump_Line_Amts: ' || 'currency_conversion_date = ' || p_ae_line_rec.currency_conversion_date);
2161: arp_standard.debug('Dump_Line_Amts: ' || 'third_party_id = ' || p_ae_line_rec.third_party_id);
2162: arp_standard.debug('Dump_Line_Amts: ' || 'third_party_sub_id = ' || p_ae_line_rec.third_party_sub_id);
2163: arp_standard.debug('Dump_Line_Amts: ' || 'tax_group_code_id = ' || p_ae_line_rec.tax_group_code_id);
2164: arp_standard.debug('Dump_Line_Amts: ' || 'tax_code_id = ' || p_ae_line_rec.tax_code_id);
2165: arp_standard.debug('Dump_Line_Amts: ' || 'location_segment_id = ' || p_ae_line_rec.location_segment_id);
2166: arp_standard.debug('Dump_Line_Amts: ' || 'taxable_entered_dr = ' || p_ae_line_rec.taxable_entered_dr);

Line 2163: arp_standard.debug('Dump_Line_Amts: ' || 'tax_group_code_id = ' || p_ae_line_rec.tax_group_code_id);

2159: arp_standard.debug('Dump_Line_Amts: ' || 'currency_conversion_type = ' || p_ae_line_rec.currency_conversion_type);
2160: arp_standard.debug('Dump_Line_Amts: ' || 'currency_conversion_date = ' || p_ae_line_rec.currency_conversion_date);
2161: arp_standard.debug('Dump_Line_Amts: ' || 'third_party_id = ' || p_ae_line_rec.third_party_id);
2162: arp_standard.debug('Dump_Line_Amts: ' || 'third_party_sub_id = ' || p_ae_line_rec.third_party_sub_id);
2163: arp_standard.debug('Dump_Line_Amts: ' || 'tax_group_code_id = ' || p_ae_line_rec.tax_group_code_id);
2164: arp_standard.debug('Dump_Line_Amts: ' || 'tax_code_id = ' || p_ae_line_rec.tax_code_id);
2165: arp_standard.debug('Dump_Line_Amts: ' || 'location_segment_id = ' || p_ae_line_rec.location_segment_id);
2166: arp_standard.debug('Dump_Line_Amts: ' || 'taxable_entered_dr = ' || p_ae_line_rec.taxable_entered_dr);
2167: arp_standard.debug('Dump_Line_Amts: ' || 'taxable_entered_cr = ' || p_ae_line_rec.taxable_entered_cr);

Line 2164: arp_standard.debug('Dump_Line_Amts: ' || 'tax_code_id = ' || p_ae_line_rec.tax_code_id);

2160: arp_standard.debug('Dump_Line_Amts: ' || 'currency_conversion_date = ' || p_ae_line_rec.currency_conversion_date);
2161: arp_standard.debug('Dump_Line_Amts: ' || 'third_party_id = ' || p_ae_line_rec.third_party_id);
2162: arp_standard.debug('Dump_Line_Amts: ' || 'third_party_sub_id = ' || p_ae_line_rec.third_party_sub_id);
2163: arp_standard.debug('Dump_Line_Amts: ' || 'tax_group_code_id = ' || p_ae_line_rec.tax_group_code_id);
2164: arp_standard.debug('Dump_Line_Amts: ' || 'tax_code_id = ' || p_ae_line_rec.tax_code_id);
2165: arp_standard.debug('Dump_Line_Amts: ' || 'location_segment_id = ' || p_ae_line_rec.location_segment_id);
2166: arp_standard.debug('Dump_Line_Amts: ' || 'taxable_entered_dr = ' || p_ae_line_rec.taxable_entered_dr);
2167: arp_standard.debug('Dump_Line_Amts: ' || 'taxable_entered_cr = ' || p_ae_line_rec.taxable_entered_cr);
2168: arp_standard.debug('Dump_Line_Amts: ' || 'taxable_accounted_dr = ' || p_ae_line_rec.taxable_accounted_dr);

Line 2165: arp_standard.debug('Dump_Line_Amts: ' || 'location_segment_id = ' || p_ae_line_rec.location_segment_id);

2161: arp_standard.debug('Dump_Line_Amts: ' || 'third_party_id = ' || p_ae_line_rec.third_party_id);
2162: arp_standard.debug('Dump_Line_Amts: ' || 'third_party_sub_id = ' || p_ae_line_rec.third_party_sub_id);
2163: arp_standard.debug('Dump_Line_Amts: ' || 'tax_group_code_id = ' || p_ae_line_rec.tax_group_code_id);
2164: arp_standard.debug('Dump_Line_Amts: ' || 'tax_code_id = ' || p_ae_line_rec.tax_code_id);
2165: arp_standard.debug('Dump_Line_Amts: ' || 'location_segment_id = ' || p_ae_line_rec.location_segment_id);
2166: arp_standard.debug('Dump_Line_Amts: ' || 'taxable_entered_dr = ' || p_ae_line_rec.taxable_entered_dr);
2167: arp_standard.debug('Dump_Line_Amts: ' || 'taxable_entered_cr = ' || p_ae_line_rec.taxable_entered_cr);
2168: arp_standard.debug('Dump_Line_Amts: ' || 'taxable_accounted_dr = ' || p_ae_line_rec.taxable_accounted_dr);
2169: arp_standard.debug('Dump_Line_Amts: ' || 'taxable_accounted_cr = ' || p_ae_line_rec.taxable_accounted_cr);

Line 2166: arp_standard.debug('Dump_Line_Amts: ' || 'taxable_entered_dr = ' || p_ae_line_rec.taxable_entered_dr);

2162: arp_standard.debug('Dump_Line_Amts: ' || 'third_party_sub_id = ' || p_ae_line_rec.third_party_sub_id);
2163: arp_standard.debug('Dump_Line_Amts: ' || 'tax_group_code_id = ' || p_ae_line_rec.tax_group_code_id);
2164: arp_standard.debug('Dump_Line_Amts: ' || 'tax_code_id = ' || p_ae_line_rec.tax_code_id);
2165: arp_standard.debug('Dump_Line_Amts: ' || 'location_segment_id = ' || p_ae_line_rec.location_segment_id);
2166: arp_standard.debug('Dump_Line_Amts: ' || 'taxable_entered_dr = ' || p_ae_line_rec.taxable_entered_dr);
2167: arp_standard.debug('Dump_Line_Amts: ' || 'taxable_entered_cr = ' || p_ae_line_rec.taxable_entered_cr);
2168: arp_standard.debug('Dump_Line_Amts: ' || 'taxable_accounted_dr = ' || p_ae_line_rec.taxable_accounted_dr);
2169: arp_standard.debug('Dump_Line_Amts: ' || 'taxable_accounted_cr = ' || p_ae_line_rec.taxable_accounted_cr);
2170: arp_standard.debug('Dump_Line_Amts: ' || 'applied_from_doc_table = ' || p_ae_line_rec.applied_from_doc_table);

Line 2167: arp_standard.debug('Dump_Line_Amts: ' || 'taxable_entered_cr = ' || p_ae_line_rec.taxable_entered_cr);

2163: arp_standard.debug('Dump_Line_Amts: ' || 'tax_group_code_id = ' || p_ae_line_rec.tax_group_code_id);
2164: arp_standard.debug('Dump_Line_Amts: ' || 'tax_code_id = ' || p_ae_line_rec.tax_code_id);
2165: arp_standard.debug('Dump_Line_Amts: ' || 'location_segment_id = ' || p_ae_line_rec.location_segment_id);
2166: arp_standard.debug('Dump_Line_Amts: ' || 'taxable_entered_dr = ' || p_ae_line_rec.taxable_entered_dr);
2167: arp_standard.debug('Dump_Line_Amts: ' || 'taxable_entered_cr = ' || p_ae_line_rec.taxable_entered_cr);
2168: arp_standard.debug('Dump_Line_Amts: ' || 'taxable_accounted_dr = ' || p_ae_line_rec.taxable_accounted_dr);
2169: arp_standard.debug('Dump_Line_Amts: ' || 'taxable_accounted_cr = ' || p_ae_line_rec.taxable_accounted_cr);
2170: arp_standard.debug('Dump_Line_Amts: ' || 'applied_from_doc_table = ' || p_ae_line_rec.applied_from_doc_table);
2171: arp_standard.debug('Dump_Line_Amts: ' || 'applied_from_doc_id = ' || p_ae_line_rec.applied_from_doc_id);

Line 2168: arp_standard.debug('Dump_Line_Amts: ' || 'taxable_accounted_dr = ' || p_ae_line_rec.taxable_accounted_dr);

2164: arp_standard.debug('Dump_Line_Amts: ' || 'tax_code_id = ' || p_ae_line_rec.tax_code_id);
2165: arp_standard.debug('Dump_Line_Amts: ' || 'location_segment_id = ' || p_ae_line_rec.location_segment_id);
2166: arp_standard.debug('Dump_Line_Amts: ' || 'taxable_entered_dr = ' || p_ae_line_rec.taxable_entered_dr);
2167: arp_standard.debug('Dump_Line_Amts: ' || 'taxable_entered_cr = ' || p_ae_line_rec.taxable_entered_cr);
2168: arp_standard.debug('Dump_Line_Amts: ' || 'taxable_accounted_dr = ' || p_ae_line_rec.taxable_accounted_dr);
2169: arp_standard.debug('Dump_Line_Amts: ' || 'taxable_accounted_cr = ' || p_ae_line_rec.taxable_accounted_cr);
2170: arp_standard.debug('Dump_Line_Amts: ' || 'applied_from_doc_table = ' || p_ae_line_rec.applied_from_doc_table);
2171: arp_standard.debug('Dump_Line_Amts: ' || 'applied_from_doc_id = ' || p_ae_line_rec.applied_from_doc_id);
2172: arp_standard.debug('Dump_Line_Amts: ' || 'applied_to_doc_table = ' || p_ae_line_rec.applied_to_doc_table);

Line 2169: arp_standard.debug('Dump_Line_Amts: ' || 'taxable_accounted_cr = ' || p_ae_line_rec.taxable_accounted_cr);

2165: arp_standard.debug('Dump_Line_Amts: ' || 'location_segment_id = ' || p_ae_line_rec.location_segment_id);
2166: arp_standard.debug('Dump_Line_Amts: ' || 'taxable_entered_dr = ' || p_ae_line_rec.taxable_entered_dr);
2167: arp_standard.debug('Dump_Line_Amts: ' || 'taxable_entered_cr = ' || p_ae_line_rec.taxable_entered_cr);
2168: arp_standard.debug('Dump_Line_Amts: ' || 'taxable_accounted_dr = ' || p_ae_line_rec.taxable_accounted_dr);
2169: arp_standard.debug('Dump_Line_Amts: ' || 'taxable_accounted_cr = ' || p_ae_line_rec.taxable_accounted_cr);
2170: arp_standard.debug('Dump_Line_Amts: ' || 'applied_from_doc_table = ' || p_ae_line_rec.applied_from_doc_table);
2171: arp_standard.debug('Dump_Line_Amts: ' || 'applied_from_doc_id = ' || p_ae_line_rec.applied_from_doc_id);
2172: arp_standard.debug('Dump_Line_Amts: ' || 'applied_to_doc_table = ' || p_ae_line_rec.applied_to_doc_table);
2173: arp_standard.debug('Dump_Line_Amts: ' || 'applied_to_doc_id = ' || p_ae_line_rec.applied_to_doc_id);

Line 2170: arp_standard.debug('Dump_Line_Amts: ' || 'applied_from_doc_table = ' || p_ae_line_rec.applied_from_doc_table);

2166: arp_standard.debug('Dump_Line_Amts: ' || 'taxable_entered_dr = ' || p_ae_line_rec.taxable_entered_dr);
2167: arp_standard.debug('Dump_Line_Amts: ' || 'taxable_entered_cr = ' || p_ae_line_rec.taxable_entered_cr);
2168: arp_standard.debug('Dump_Line_Amts: ' || 'taxable_accounted_dr = ' || p_ae_line_rec.taxable_accounted_dr);
2169: arp_standard.debug('Dump_Line_Amts: ' || 'taxable_accounted_cr = ' || p_ae_line_rec.taxable_accounted_cr);
2170: arp_standard.debug('Dump_Line_Amts: ' || 'applied_from_doc_table = ' || p_ae_line_rec.applied_from_doc_table);
2171: arp_standard.debug('Dump_Line_Amts: ' || 'applied_from_doc_id = ' || p_ae_line_rec.applied_from_doc_id);
2172: arp_standard.debug('Dump_Line_Amts: ' || 'applied_to_doc_table = ' || p_ae_line_rec.applied_to_doc_table);
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);

Line 2171: arp_standard.debug('Dump_Line_Amts: ' || 'applied_from_doc_id = ' || p_ae_line_rec.applied_from_doc_id);

2167: arp_standard.debug('Dump_Line_Amts: ' || 'taxable_entered_cr = ' || p_ae_line_rec.taxable_entered_cr);
2168: arp_standard.debug('Dump_Line_Amts: ' || 'taxable_accounted_dr = ' || p_ae_line_rec.taxable_accounted_dr);
2169: arp_standard.debug('Dump_Line_Amts: ' || 'taxable_accounted_cr = ' || p_ae_line_rec.taxable_accounted_cr);
2170: arp_standard.debug('Dump_Line_Amts: ' || 'applied_from_doc_table = ' || p_ae_line_rec.applied_from_doc_table);
2171: arp_standard.debug('Dump_Line_Amts: ' || 'applied_from_doc_id = ' || p_ae_line_rec.applied_from_doc_id);
2172: arp_standard.debug('Dump_Line_Amts: ' || 'applied_to_doc_table = ' || p_ae_line_rec.applied_to_doc_table);
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);

Line 2172: arp_standard.debug('Dump_Line_Amts: ' || 'applied_to_doc_table = ' || p_ae_line_rec.applied_to_doc_table);

2168: arp_standard.debug('Dump_Line_Amts: ' || 'taxable_accounted_dr = ' || p_ae_line_rec.taxable_accounted_dr);
2169: arp_standard.debug('Dump_Line_Amts: ' || 'taxable_accounted_cr = ' || p_ae_line_rec.taxable_accounted_cr);
2170: arp_standard.debug('Dump_Line_Amts: ' || 'applied_from_doc_table = ' || p_ae_line_rec.applied_from_doc_table);
2171: arp_standard.debug('Dump_Line_Amts: ' || 'applied_from_doc_id = ' || p_ae_line_rec.applied_from_doc_id);
2172: arp_standard.debug('Dump_Line_Amts: ' || 'applied_to_doc_table = ' || p_ae_line_rec.applied_to_doc_table);
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);

Line 2173: arp_standard.debug('Dump_Line_Amts: ' || 'applied_to_doc_id = ' || p_ae_line_rec.applied_to_doc_id);

2169: arp_standard.debug('Dump_Line_Amts: ' || 'taxable_accounted_cr = ' || p_ae_line_rec.taxable_accounted_cr);
2170: arp_standard.debug('Dump_Line_Amts: ' || 'applied_from_doc_table = ' || p_ae_line_rec.applied_from_doc_table);
2171: arp_standard.debug('Dump_Line_Amts: ' || 'applied_from_doc_id = ' || p_ae_line_rec.applied_from_doc_id);
2172: arp_standard.debug('Dump_Line_Amts: ' || 'applied_to_doc_table = ' || p_ae_line_rec.applied_to_doc_table);
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()-');

Line 2174: arp_standard.debug('Dump_Line_Amts: ' || 'tax_link_id = ' || p_ae_line_rec.tax_link_id);

2170: arp_standard.debug('Dump_Line_Amts: ' || 'applied_from_doc_table = ' || p_ae_line_rec.applied_from_doc_table);
2171: arp_standard.debug('Dump_Line_Amts: ' || 'applied_from_doc_id = ' || p_ae_line_rec.applied_from_doc_id);
2172: arp_standard.debug('Dump_Line_Amts: ' || 'applied_to_doc_table = ' || p_ae_line_rec.applied_to_doc_table);
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;

Line 2175: arp_standard.debug('Dump_Line_Amts: ' || 'reversed_source_id = ' || p_ae_line_rec.reversed_source_id);

2171: arp_standard.debug('Dump_Line_Amts: ' || 'applied_from_doc_id = ' || p_ae_line_rec.applied_from_doc_id);
2172: arp_standard.debug('Dump_Line_Amts: ' || 'applied_to_doc_table = ' || p_ae_line_rec.applied_to_doc_table);
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:

Line 2176: arp_standard.debug('Dump_Line_Amts: ' || 'summarize_flag = ' || p_ae_line_rec.summarize_flag);

2172: arp_standard.debug('Dump_Line_Amts: ' || 'applied_to_doc_table = ' || p_ae_line_rec.applied_to_doc_table);
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

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 2454: arp_standard.debug('Process_Recon: ' || 'list Input of parameters ');

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);
2458: arp_standard.debug('Process_Recon: ' || 'p_calling_point ' || p_calling_point);

Line 2455: arp_standard.debug('Process_Recon: ' || 'p_br_cust_trx_line_id ' || p_br_cust_trx_line_id);

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);
2458: arp_standard.debug('Process_Recon: ' || 'p_calling_point ' || p_calling_point);
2459: arp_standard.debug('Process_Recon: ' || 'p_pay_ctr ' || p_pay_ctr);

Line 2456: arp_standard.debug('Process_Recon: ' || 'p_customer_trx_id ' || p_customer_trx_id);

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);
2458: arp_standard.debug('Process_Recon: ' || 'p_calling_point ' || p_calling_point);
2459: arp_standard.debug('Process_Recon: ' || 'p_pay_ctr ' || p_pay_ctr);
2460: END IF;

Line 2457: arp_standard.debug('Process_Recon: ' || 'p_simul_app ' || p_simul_app);

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);
2458: arp_standard.debug('Process_Recon: ' || 'p_calling_point ' || p_calling_point);
2459: arp_standard.debug('Process_Recon: ' || 'p_pay_ctr ' || p_pay_ctr);
2460: END IF;
2461:

Line 2458: arp_standard.debug('Process_Recon: ' || 'p_calling_point ' || p_calling_point);

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);
2458: arp_standard.debug('Process_Recon: ' || 'p_calling_point ' || p_calling_point);
2459: arp_standard.debug('Process_Recon: ' || 'p_pay_ctr ' || p_pay_ctr);
2460: END IF;
2461:
2462: /*-------------------------------------------------------------------------------+

Line 2459: arp_standard.debug('Process_Recon: ' || 'p_pay_ctr ' || p_pay_ctr);

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);
2458: arp_standard.debug('Process_Recon: ' || 'p_calling_point ' || p_calling_point);
2459: arp_standard.debug('Process_Recon: ' || 'p_pay_ctr ' || p_pay_ctr);
2460: END IF;
2461:
2462: /*-------------------------------------------------------------------------------+
2463: | For an assignment on a Bill simulate an activity such as an application which |

Line 2477: arp_standard.debug('Process_Recon: ' || 'p_pay_tbl simulate application ');

2473:
2474: IF p_pay_tbl.EXISTS(p_pay_ctr) THEN --atleast one activity exists
2475:
2476: IF PG_DEBUG in ('Y', 'C') THEN
2477: arp_standard.debug('Process_Recon: ' || 'p_pay_tbl simulate application ');
2478: END IF;
2479:
2480: FOR l_ctr3 IN p_pay_tbl.FIRST .. p_pay_tbl.LAST LOOP
2481:

Line 2510: arp_standard.debug('Process_Recon: ' || 'Caching Tax for simulated application ');

2506:
2507: IF l_ae_line_tbl.EXISTS(l_ae_ctr) THEN --Atleast one Tax line exists
2508:
2509: IF PG_DEBUG in ('Y', 'C') THEN
2510: arp_standard.debug('Process_Recon: ' || 'Caching Tax for simulated application ');
2511: END IF;
2512:
2513: FOR l_ctr1 IN l_ae_line_tbl.FIRST .. l_ae_line_tbl.LAST LOOP
2514:

Line 2540: arp_standard.debug('Process_Recon: ' || '1) Hit found in cache ae_tax_tbl');

2536: AND (l_ae_line_tbl(l_ctr1).ae_line_type = 'DEFERRED_TAX'))
2537: THEN
2538:
2539: IF PG_DEBUG in ('Y', 'C') THEN
2540: arp_standard.debug('Process_Recon: ' || '1) Hit found in cache ae_tax_tbl');
2541: END IF;
2542:
2543: ae_tax_tbl(l_ctr).ae_amount := ae_tax_tbl(l_ctr).ae_amount
2544: + nvl(l_ae_line_tbl(l_ctr1).entered_dr,0)

Line 2573: arp_standard.debug('Process_Recon: ' || '1) Now caching in cache ae_tax_tbl');

2569: +-----------------------------------------------------------------------------*/
2570: IF (NOT l_cached) AND (l_ae_line_tbl(l_ctr1).ae_line_type = 'DEFERRED_TAX')
2571: THEN
2572: IF PG_DEBUG in ('Y', 'C') THEN
2573: arp_standard.debug('Process_Recon: ' || '1) Now caching in cache ae_tax_tbl');
2574: END IF;
2575:
2576: l_tax_ctr := l_tax_ctr + 1;
2577:

Line 2605: arp_standard.debug('Process_Recon: ' || ' ');

2601:
2602: l_cached := TRUE;
2603:
2604: IF PG_DEBUG in ('Y', 'C') THEN
2605: arp_standard.debug('Process_Recon: ' || ' ');
2606: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_location_segment_id = ' || ae_tax_tbl(l_tax_ctr).ae_location_segment_id);
2607: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_tax_group_code_id = ' || ae_tax_tbl(l_tax_ctr).ae_tax_group_code_id);
2608: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_tax_code_id = ' || ae_tax_tbl(l_tax_ctr).ae_tax_code_id);
2609: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_code_combination_id = ' || ae_tax_tbl(l_tax_ctr).ae_code_combination_id);

Line 2606: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_location_segment_id = ' || ae_tax_tbl(l_tax_ctr).ae_location_segment_id);

2602: l_cached := TRUE;
2603:
2604: IF PG_DEBUG in ('Y', 'C') THEN
2605: arp_standard.debug('Process_Recon: ' || ' ');
2606: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_location_segment_id = ' || ae_tax_tbl(l_tax_ctr).ae_location_segment_id);
2607: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_tax_group_code_id = ' || ae_tax_tbl(l_tax_ctr).ae_tax_group_code_id);
2608: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_tax_code_id = ' || ae_tax_tbl(l_tax_ctr).ae_tax_code_id);
2609: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_code_combination_id = ' || ae_tax_tbl(l_tax_ctr).ae_code_combination_id);
2610: arp_standard.debug('Process_Recon: ' || ' ');

Line 2607: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_tax_group_code_id = ' || ae_tax_tbl(l_tax_ctr).ae_tax_group_code_id);

2603:
2604: IF PG_DEBUG in ('Y', 'C') THEN
2605: arp_standard.debug('Process_Recon: ' || ' ');
2606: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_location_segment_id = ' || ae_tax_tbl(l_tax_ctr).ae_location_segment_id);
2607: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_tax_group_code_id = ' || ae_tax_tbl(l_tax_ctr).ae_tax_group_code_id);
2608: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_tax_code_id = ' || ae_tax_tbl(l_tax_ctr).ae_tax_code_id);
2609: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_code_combination_id = ' || ae_tax_tbl(l_tax_ctr).ae_code_combination_id);
2610: arp_standard.debug('Process_Recon: ' || ' ');
2611: END IF;

Line 2608: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_tax_code_id = ' || ae_tax_tbl(l_tax_ctr).ae_tax_code_id);

2604: IF PG_DEBUG in ('Y', 'C') THEN
2605: arp_standard.debug('Process_Recon: ' || ' ');
2606: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_location_segment_id = ' || ae_tax_tbl(l_tax_ctr).ae_location_segment_id);
2607: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_tax_group_code_id = ' || ae_tax_tbl(l_tax_ctr).ae_tax_group_code_id);
2608: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_tax_code_id = ' || ae_tax_tbl(l_tax_ctr).ae_tax_code_id);
2609: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_code_combination_id = ' || ae_tax_tbl(l_tax_ctr).ae_code_combination_id);
2610: arp_standard.debug('Process_Recon: ' || ' ');
2611: END IF;
2612:

Line 2609: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_code_combination_id = ' || ae_tax_tbl(l_tax_ctr).ae_code_combination_id);

2605: arp_standard.debug('Process_Recon: ' || ' ');
2606: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_location_segment_id = ' || ae_tax_tbl(l_tax_ctr).ae_location_segment_id);
2607: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_tax_group_code_id = ' || ae_tax_tbl(l_tax_ctr).ae_tax_group_code_id);
2608: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_tax_code_id = ' || ae_tax_tbl(l_tax_ctr).ae_tax_code_id);
2609: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_code_combination_id = ' || ae_tax_tbl(l_tax_ctr).ae_code_combination_id);
2610: arp_standard.debug('Process_Recon: ' || ' ');
2611: END IF;
2612:
2613: END IF; --not cached

Line 2610: arp_standard.debug('Process_Recon: ' || ' ');

2606: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_location_segment_id = ' || ae_tax_tbl(l_tax_ctr).ae_location_segment_id);
2607: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_tax_group_code_id = ' || ae_tax_tbl(l_tax_ctr).ae_tax_group_code_id);
2608: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_tax_code_id = ' || ae_tax_tbl(l_tax_ctr).ae_tax_code_id);
2609: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_code_combination_id = ' || ae_tax_tbl(l_tax_ctr).ae_code_combination_id);
2610: arp_standard.debug('Process_Recon: ' || ' ');
2611: END IF;
2612:
2613: END IF; --not cached
2614:

Line 2629: arp_standard.debug('Process_Recon: ' || 'Caching deferred tax from Original Transaction accounting ');

2625: |Cache the deferred tax from the original transaction accounting table for use in |
2626: |the reconciliation process |
2627: +---------------------------------------------------------------------------------*/
2628: IF PG_DEBUG in ('Y', 'C') THEN
2629: arp_standard.debug('Process_Recon: ' || 'Caching deferred tax from Original Transaction accounting ');
2630: END IF;
2631:
2632: FOR l_init_def_tax IN get_init_def_tax_acct LOOP
2633:

Line 2635: arp_standard.debug('Process_Recon: ' || 'Processing Original Transaction accounting ');

2631:
2632: FOR l_init_def_tax IN get_init_def_tax_acct LOOP
2633:
2634: IF PG_DEBUG in ('Y', 'C') THEN
2635: arp_standard.debug('Process_Recon: ' || 'Processing Original Transaction accounting ');
2636: END IF;
2637:
2638: l_cached := FALSE;
2639:

Line 2653: arp_standard.debug('Process_Recon: ' || '2) Hit found in cache ae_tax_tbl');

2649: AND (ae_tax_tbl(l_ctr).ae_code_combination_id = l_init_def_tax.account))
2650: THEN
2651:
2652: IF PG_DEBUG in ('Y', 'C') THEN
2653: arp_standard.debug('Process_Recon: ' || '2) Hit found in cache ae_tax_tbl');
2654: END IF;
2655:
2656: ae_tax_tbl(l_ctr).ae_amount := ae_tax_tbl(l_ctr).ae_amount
2657: + l_init_def_tax.amount;

Line 2682: arp_standard.debug('Process_Recon: ' || '2) Now caching in cache ae_tax_tbl');

2678: +---------------------------------------------------------------------------------*/
2679: IF (NOT l_cached) THEN
2680:
2681: IF PG_DEBUG in ('Y', 'C') THEN
2682: arp_standard.debug('Process_Recon: ' || '2) Now caching in cache ae_tax_tbl');
2683: END IF;
2684:
2685: l_tax_ctr := l_tax_ctr + 1;
2686:

Line 2704: arp_standard.debug('Process_Recon: ' || ' ');

2700:
2701: ae_tax_tbl(l_tax_ctr).ae_taxable_acctd_amount := l_init_def_tax.taxable_acctd_amount;
2702:
2703: IF PG_DEBUG in ('Y', 'C') THEN
2704: arp_standard.debug('Process_Recon: ' || ' ');
2705: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_location_segment_id = ' || ae_tax_tbl(l_tax_ctr).ae_location_segment_id);
2706: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_tax_group_code_id = ' || ae_tax_tbl(l_tax_ctr).ae_tax_group_code_id);
2707: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_tax_code_id = ' || ae_tax_tbl(l_tax_ctr).ae_tax_code_id);
2708: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_code_combination_id = ' || ae_tax_tbl(l_tax_ctr).ae_code_combination_id);

Line 2705: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_location_segment_id = ' || ae_tax_tbl(l_tax_ctr).ae_location_segment_id);

2701: ae_tax_tbl(l_tax_ctr).ae_taxable_acctd_amount := l_init_def_tax.taxable_acctd_amount;
2702:
2703: IF PG_DEBUG in ('Y', 'C') THEN
2704: arp_standard.debug('Process_Recon: ' || ' ');
2705: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_location_segment_id = ' || ae_tax_tbl(l_tax_ctr).ae_location_segment_id);
2706: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_tax_group_code_id = ' || ae_tax_tbl(l_tax_ctr).ae_tax_group_code_id);
2707: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_tax_code_id = ' || ae_tax_tbl(l_tax_ctr).ae_tax_code_id);
2708: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_code_combination_id = ' || ae_tax_tbl(l_tax_ctr).ae_code_combination_id);
2709: arp_standard.debug('Process_Recon: ' || ' ');

Line 2706: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_tax_group_code_id = ' || ae_tax_tbl(l_tax_ctr).ae_tax_group_code_id);

2702:
2703: IF PG_DEBUG in ('Y', 'C') THEN
2704: arp_standard.debug('Process_Recon: ' || ' ');
2705: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_location_segment_id = ' || ae_tax_tbl(l_tax_ctr).ae_location_segment_id);
2706: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_tax_group_code_id = ' || ae_tax_tbl(l_tax_ctr).ae_tax_group_code_id);
2707: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_tax_code_id = ' || ae_tax_tbl(l_tax_ctr).ae_tax_code_id);
2708: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_code_combination_id = ' || ae_tax_tbl(l_tax_ctr).ae_code_combination_id);
2709: arp_standard.debug('Process_Recon: ' || ' ');
2710: END IF;

Line 2707: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_tax_code_id = ' || ae_tax_tbl(l_tax_ctr).ae_tax_code_id);

2703: IF PG_DEBUG in ('Y', 'C') THEN
2704: arp_standard.debug('Process_Recon: ' || ' ');
2705: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_location_segment_id = ' || ae_tax_tbl(l_tax_ctr).ae_location_segment_id);
2706: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_tax_group_code_id = ' || ae_tax_tbl(l_tax_ctr).ae_tax_group_code_id);
2707: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_tax_code_id = ' || ae_tax_tbl(l_tax_ctr).ae_tax_code_id);
2708: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_code_combination_id = ' || ae_tax_tbl(l_tax_ctr).ae_code_combination_id);
2709: arp_standard.debug('Process_Recon: ' || ' ');
2710: END IF;
2711:

Line 2708: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_code_combination_id = ' || ae_tax_tbl(l_tax_ctr).ae_code_combination_id);

2704: arp_standard.debug('Process_Recon: ' || ' ');
2705: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_location_segment_id = ' || ae_tax_tbl(l_tax_ctr).ae_location_segment_id);
2706: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_tax_group_code_id = ' || ae_tax_tbl(l_tax_ctr).ae_tax_group_code_id);
2707: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_tax_code_id = ' || ae_tax_tbl(l_tax_ctr).ae_tax_code_id);
2708: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_code_combination_id = ' || ae_tax_tbl(l_tax_ctr).ae_code_combination_id);
2709: arp_standard.debug('Process_Recon: ' || ' ');
2710: END IF;
2711:
2712: l_cached := TRUE;

Line 2709: arp_standard.debug('Process_Recon: ' || ' ');

2705: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_location_segment_id = ' || ae_tax_tbl(l_tax_ctr).ae_location_segment_id);
2706: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_tax_group_code_id = ' || ae_tax_tbl(l_tax_ctr).ae_tax_group_code_id);
2707: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_tax_code_id = ' || ae_tax_tbl(l_tax_ctr).ae_tax_code_id);
2708: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_tax_ctr||').ae_code_combination_id = ' || ae_tax_tbl(l_tax_ctr).ae_code_combination_id);
2709: arp_standard.debug('Process_Recon: ' || ' ');
2710: END IF;
2711:
2712: l_cached := TRUE;
2713:

Line 2721: arp_standard.debug('Process_Recon: ' || 'Start caching physically created tax accounting entries due to past activity');

2717:
2718: END IF; --Simulating an application to reconcile against single activity
2719:
2720: IF PG_DEBUG in ('Y', 'C') THEN
2721: arp_standard.debug('Process_Recon: ' || 'Start caching physically created tax accounting entries due to past activity');
2722: END IF;
2723:
2724: /*---------------------------------------------------------------------------------+
2725: |Cache the deferred tax accounting entries physically created in ar_distributions |

Line 2748: arp_standard.debug('Process_Recon: ' || '3) Hit found in cache ae_tax_activity_tbl');

2744: AND (ae_tax_activity_tbl(l_ctr).ae_code_combination_id = l_inv_nr.account))
2745: THEN
2746:
2747: IF PG_DEBUG in ('Y', 'C') THEN
2748: arp_standard.debug('Process_Recon: ' || '3) Hit found in cache ae_tax_activity_tbl');
2749: END IF;
2750:
2751: ae_tax_activity_tbl(l_ctr).ae_amount :=
2752: ae_tax_activity_tbl(l_ctr).ae_amount + l_inv_nr.amount;

Line 2777: arp_standard.debug('Process_Recon: ' || '3) Now caching in cache ae_tax_activity_tbl');

2773: +---------------------------------------------------------------------------------*/
2774: IF (NOT l_cached) THEN
2775:
2776: IF PG_DEBUG in ('Y', 'C') THEN
2777: arp_standard.debug('Process_Recon: ' || '3) Now caching in cache ae_tax_activity_tbl');
2778: END IF;
2779:
2780: l_tax_ctr1 := l_tax_ctr1 + 1;
2781: ae_tax_activity_tbl(l_tax_ctr1).ae_location_segment_id := l_inv_nr.location_segment_id;

Line 2800: arp_standard.debug('Process_Recon: ' || ' ');

2796:
2797: l_cached := TRUE;
2798:
2799: IF PG_DEBUG in ('Y', 'C') THEN
2800: arp_standard.debug('Process_Recon: ' || ' ');
2801: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_location_segment_id = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_location_segment_id);
2802: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_tax_group_code_id = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_tax_group_code_id);
2803: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_tax_code_id = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_tax_code_id);
2804: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_amount = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_amount);

Line 2801: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_location_segment_id = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_location_segment_id);

2797: l_cached := TRUE;
2798:
2799: IF PG_DEBUG in ('Y', 'C') THEN
2800: arp_standard.debug('Process_Recon: ' || ' ');
2801: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_location_segment_id = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_location_segment_id);
2802: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_tax_group_code_id = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_tax_group_code_id);
2803: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_tax_code_id = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_tax_code_id);
2804: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_amount = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_amount);
2805: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_acctd_amount = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_acctd_amount);

Line 2802: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_tax_group_code_id = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_tax_group_code_id);

2798:
2799: IF PG_DEBUG in ('Y', 'C') THEN
2800: arp_standard.debug('Process_Recon: ' || ' ');
2801: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_location_segment_id = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_location_segment_id);
2802: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_tax_group_code_id = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_tax_group_code_id);
2803: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_tax_code_id = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_tax_code_id);
2804: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_amount = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_amount);
2805: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_acctd_amount = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_acctd_amount);
2806: arp_standard.debug('Process_Recon: ' || ' ');

Line 2803: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_tax_code_id = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_tax_code_id);

2799: IF PG_DEBUG in ('Y', 'C') THEN
2800: arp_standard.debug('Process_Recon: ' || ' ');
2801: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_location_segment_id = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_location_segment_id);
2802: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_tax_group_code_id = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_tax_group_code_id);
2803: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_tax_code_id = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_tax_code_id);
2804: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_amount = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_amount);
2805: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_acctd_amount = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_acctd_amount);
2806: arp_standard.debug('Process_Recon: ' || ' ');
2807: END IF;

Line 2804: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_amount = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_amount);

2800: arp_standard.debug('Process_Recon: ' || ' ');
2801: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_location_segment_id = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_location_segment_id);
2802: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_tax_group_code_id = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_tax_group_code_id);
2803: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_tax_code_id = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_tax_code_id);
2804: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_amount = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_amount);
2805: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_acctd_amount = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_acctd_amount);
2806: arp_standard.debug('Process_Recon: ' || ' ');
2807: END IF;
2808:

Line 2805: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_acctd_amount = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_acctd_amount);

2801: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_location_segment_id = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_location_segment_id);
2802: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_tax_group_code_id = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_tax_group_code_id);
2803: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_tax_code_id = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_tax_code_id);
2804: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_amount = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_amount);
2805: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_acctd_amount = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_acctd_amount);
2806: arp_standard.debug('Process_Recon: ' || ' ');
2807: END IF;
2808:
2809: END IF; --not cached then cache

Line 2806: arp_standard.debug('Process_Recon: ' || ' ');

2802: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_tax_group_code_id = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_tax_group_code_id);
2803: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_tax_code_id = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_tax_code_id);
2804: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_amount = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_amount);
2805: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_acctd_amount = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_acctd_amount);
2806: arp_standard.debug('Process_Recon: ' || ' ');
2807: END IF;
2808:
2809: END IF; --not cached then cache
2810:

Line 2823: arp_standard.debug('Process_Recon: ' || '4) Cache table p_g_ae_line_tbl Exists');

2819: +---------------------------------------------------------------------------------*/
2820: IF p_g_ae_line_tbl.EXISTS(p_g_ae_ctr) AND (g_call_num = 1) THEN
2821:
2822: IF PG_DEBUG in ('Y', 'C') THEN
2823: arp_standard.debug('Process_Recon: ' || '4) Cache table p_g_ae_line_tbl Exists');
2824: END IF;
2825:
2826: FOR l_ctr1 IN p_g_ae_line_tbl.FIRST .. p_g_ae_line_tbl.LAST LOOP
2827:

Line 2831: arp_standard.debug('Process_Recon: ' || ' ');

2827:
2828: l_cached := FALSE;
2829:
2830: IF PG_DEBUG in ('Y', 'C') THEN
2831: arp_standard.debug('Process_Recon: ' || ' ');
2832: arp_standard.debug('Process_Recon: ' || 'Checking whether global table accounting matches tax activity table');
2833: arp_standard.debug('Process_Recon: ' || 'p_br_cust_trx_line_id ' || p_br_cust_trx_line_id);
2834: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').source_id_secondary ' || p_g_ae_line_tbl(l_ctr1).source_id_secondary);
2835: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').source_table_secondary ' || p_g_ae_line_tbl(l_ctr1).source_table_secondary);

Line 2832: arp_standard.debug('Process_Recon: ' || 'Checking whether global table accounting matches tax activity table');

2828: l_cached := FALSE;
2829:
2830: IF PG_DEBUG in ('Y', 'C') THEN
2831: arp_standard.debug('Process_Recon: ' || ' ');
2832: arp_standard.debug('Process_Recon: ' || 'Checking whether global table accounting matches tax activity table');
2833: arp_standard.debug('Process_Recon: ' || 'p_br_cust_trx_line_id ' || p_br_cust_trx_line_id);
2834: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').source_id_secondary ' || p_g_ae_line_tbl(l_ctr1).source_id_secondary);
2835: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').source_table_secondary ' || p_g_ae_line_tbl(l_ctr1).source_table_secondary);
2836: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').ae_line_type ' || p_g_ae_line_tbl(l_ctr1).ae_line_type);

Line 2833: arp_standard.debug('Process_Recon: ' || 'p_br_cust_trx_line_id ' || p_br_cust_trx_line_id);

2829:
2830: IF PG_DEBUG in ('Y', 'C') THEN
2831: arp_standard.debug('Process_Recon: ' || ' ');
2832: arp_standard.debug('Process_Recon: ' || 'Checking whether global table accounting matches tax activity table');
2833: arp_standard.debug('Process_Recon: ' || 'p_br_cust_trx_line_id ' || p_br_cust_trx_line_id);
2834: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').source_id_secondary ' || p_g_ae_line_tbl(l_ctr1).source_id_secondary);
2835: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').source_table_secondary ' || p_g_ae_line_tbl(l_ctr1).source_table_secondary);
2836: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').ae_line_type ' || p_g_ae_line_tbl(l_ctr1).ae_line_type);
2837: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').location_segment_id ' || p_g_ae_line_tbl(l_ctr1).location_segment_id);

Line 2834: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').source_id_secondary ' || p_g_ae_line_tbl(l_ctr1).source_id_secondary);

2830: IF PG_DEBUG in ('Y', 'C') THEN
2831: arp_standard.debug('Process_Recon: ' || ' ');
2832: arp_standard.debug('Process_Recon: ' || 'Checking whether global table accounting matches tax activity table');
2833: arp_standard.debug('Process_Recon: ' || 'p_br_cust_trx_line_id ' || p_br_cust_trx_line_id);
2834: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').source_id_secondary ' || p_g_ae_line_tbl(l_ctr1).source_id_secondary);
2835: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').source_table_secondary ' || p_g_ae_line_tbl(l_ctr1).source_table_secondary);
2836: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').ae_line_type ' || p_g_ae_line_tbl(l_ctr1).ae_line_type);
2837: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').location_segment_id ' || p_g_ae_line_tbl(l_ctr1).location_segment_id);
2838: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').tax_group_code_id ' || p_g_ae_line_tbl(l_ctr1).tax_group_code_id);

Line 2835: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').source_table_secondary ' || p_g_ae_line_tbl(l_ctr1).source_table_secondary);

2831: arp_standard.debug('Process_Recon: ' || ' ');
2832: arp_standard.debug('Process_Recon: ' || 'Checking whether global table accounting matches tax activity table');
2833: arp_standard.debug('Process_Recon: ' || 'p_br_cust_trx_line_id ' || p_br_cust_trx_line_id);
2834: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').source_id_secondary ' || p_g_ae_line_tbl(l_ctr1).source_id_secondary);
2835: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').source_table_secondary ' || p_g_ae_line_tbl(l_ctr1).source_table_secondary);
2836: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').ae_line_type ' || p_g_ae_line_tbl(l_ctr1).ae_line_type);
2837: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').location_segment_id ' || p_g_ae_line_tbl(l_ctr1).location_segment_id);
2838: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').tax_group_code_id ' || p_g_ae_line_tbl(l_ctr1).tax_group_code_id);
2839: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').tax_code_id ' || p_g_ae_line_tbl(l_ctr1).tax_code_id);

Line 2836: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').ae_line_type ' || p_g_ae_line_tbl(l_ctr1).ae_line_type);

2832: arp_standard.debug('Process_Recon: ' || 'Checking whether global table accounting matches tax activity table');
2833: arp_standard.debug('Process_Recon: ' || 'p_br_cust_trx_line_id ' || p_br_cust_trx_line_id);
2834: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').source_id_secondary ' || p_g_ae_line_tbl(l_ctr1).source_id_secondary);
2835: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').source_table_secondary ' || p_g_ae_line_tbl(l_ctr1).source_table_secondary);
2836: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').ae_line_type ' || p_g_ae_line_tbl(l_ctr1).ae_line_type);
2837: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').location_segment_id ' || p_g_ae_line_tbl(l_ctr1).location_segment_id);
2838: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').tax_group_code_id ' || p_g_ae_line_tbl(l_ctr1).tax_group_code_id);
2839: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').tax_code_id ' || p_g_ae_line_tbl(l_ctr1).tax_code_id);
2840: arp_standard.debug('Process_Recon: ' || ' ');

Line 2837: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').location_segment_id ' || p_g_ae_line_tbl(l_ctr1).location_segment_id);

2833: arp_standard.debug('Process_Recon: ' || 'p_br_cust_trx_line_id ' || p_br_cust_trx_line_id);
2834: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').source_id_secondary ' || p_g_ae_line_tbl(l_ctr1).source_id_secondary);
2835: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').source_table_secondary ' || p_g_ae_line_tbl(l_ctr1).source_table_secondary);
2836: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').ae_line_type ' || p_g_ae_line_tbl(l_ctr1).ae_line_type);
2837: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').location_segment_id ' || p_g_ae_line_tbl(l_ctr1).location_segment_id);
2838: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').tax_group_code_id ' || p_g_ae_line_tbl(l_ctr1).tax_group_code_id);
2839: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').tax_code_id ' || p_g_ae_line_tbl(l_ctr1).tax_code_id);
2840: arp_standard.debug('Process_Recon: ' || ' ');
2841: END IF;

Line 2838: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').tax_group_code_id ' || p_g_ae_line_tbl(l_ctr1).tax_group_code_id);

2834: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').source_id_secondary ' || p_g_ae_line_tbl(l_ctr1).source_id_secondary);
2835: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').source_table_secondary ' || p_g_ae_line_tbl(l_ctr1).source_table_secondary);
2836: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').ae_line_type ' || p_g_ae_line_tbl(l_ctr1).ae_line_type);
2837: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').location_segment_id ' || p_g_ae_line_tbl(l_ctr1).location_segment_id);
2838: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').tax_group_code_id ' || p_g_ae_line_tbl(l_ctr1).tax_group_code_id);
2839: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').tax_code_id ' || p_g_ae_line_tbl(l_ctr1).tax_code_id);
2840: arp_standard.debug('Process_Recon: ' || ' ');
2841: END IF;
2842:

Line 2839: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').tax_code_id ' || p_g_ae_line_tbl(l_ctr1).tax_code_id);

2835: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').source_table_secondary ' || p_g_ae_line_tbl(l_ctr1).source_table_secondary);
2836: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').ae_line_type ' || p_g_ae_line_tbl(l_ctr1).ae_line_type);
2837: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').location_segment_id ' || p_g_ae_line_tbl(l_ctr1).location_segment_id);
2838: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').tax_group_code_id ' || p_g_ae_line_tbl(l_ctr1).tax_group_code_id);
2839: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').tax_code_id ' || p_g_ae_line_tbl(l_ctr1).tax_code_id);
2840: arp_standard.debug('Process_Recon: ' || ' ');
2841: END IF;
2842:
2843: IF ae_tax_activity_tbl.EXISTS(l_tax_ctr1) THEN

Line 2840: arp_standard.debug('Process_Recon: ' || ' ');

2836: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').ae_line_type ' || p_g_ae_line_tbl(l_ctr1).ae_line_type);
2837: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').location_segment_id ' || p_g_ae_line_tbl(l_ctr1).location_segment_id);
2838: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').tax_group_code_id ' || p_g_ae_line_tbl(l_ctr1).tax_group_code_id);
2839: arp_standard.debug('Process_Recon: ' || 'p_g_ae_line_tbl('|| l_ctr1 || ').tax_code_id ' || p_g_ae_line_tbl(l_ctr1).tax_code_id);
2840: arp_standard.debug('Process_Recon: ' || ' ');
2841: END IF;
2842:
2843: IF ae_tax_activity_tbl.EXISTS(l_tax_ctr1) THEN
2844:

Line 2846: arp_standard.debug('Process_Recon: ' || '4) Cache table ae_tax_activity_tbl Exists');

2842:
2843: IF ae_tax_activity_tbl.EXISTS(l_tax_ctr1) THEN
2844:
2845: IF PG_DEBUG in ('Y', 'C') THEN
2846: arp_standard.debug('Process_Recon: ' || '4) Cache table ae_tax_activity_tbl Exists');
2847: END IF;
2848:
2849: FOR l_ctr IN ae_tax_activity_tbl.FIRST .. ae_tax_activity_tbl.LAST LOOP
2850:

Line 2875: arp_standard.debug('Process_Recon: ' || '4) Hit found in cache ae_tax_activity_tbl');

2871: AND (p_g_ae_line_tbl(l_ctr1).ae_line_type = 'DEFERRED_TAX'))
2872: THEN
2873:
2874: IF PG_DEBUG in ('Y', 'C') THEN
2875: arp_standard.debug('Process_Recon: ' || '4) Hit found in cache ae_tax_activity_tbl');
2876: END IF;
2877:
2878: ae_tax_activity_tbl(l_ctr).ae_amount :=
2879: ae_tax_activity_tbl(l_ctr).ae_amount + nvl(p_g_ae_line_tbl(l_ctr1).entered_dr,0) * -1

Line 2913: arp_standard.debug('Process_Recon: ' || '4) Now caching in cache ae_tax_activity_tbl');

2909: AND (p_g_ae_line_tbl(l_ctr1).ae_line_type = 'DEFERRED_TAX'))
2910: THEN
2911:
2912: IF PG_DEBUG in ('Y', 'C') THEN
2913: arp_standard.debug('Process_Recon: ' || '4) Now caching in cache ae_tax_activity_tbl');
2914: END IF;
2915:
2916: l_tax_ctr1 := l_tax_ctr1 + 1;
2917:

Line 2943: arp_standard.debug('Process_Recon: ' || ' ');

2939:
2940: l_cached := TRUE;
2941:
2942: IF PG_DEBUG in ('Y', 'C') THEN
2943: arp_standard.debug('Process_Recon: ' || ' ');
2944: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_location_segment_id = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_location_segment_id);
2945: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_tax_group_code_id = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_tax_group_code_id);
2946: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_tax_code_id = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_tax_code_id);
2947: arp_standard.debug('Process_Recon: ' || ' ');

Line 2944: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_location_segment_id = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_location_segment_id);

2940: l_cached := TRUE;
2941:
2942: IF PG_DEBUG in ('Y', 'C') THEN
2943: arp_standard.debug('Process_Recon: ' || ' ');
2944: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_location_segment_id = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_location_segment_id);
2945: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_tax_group_code_id = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_tax_group_code_id);
2946: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_tax_code_id = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_tax_code_id);
2947: arp_standard.debug('Process_Recon: ' || ' ');
2948: END IF;

Line 2945: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_tax_group_code_id = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_tax_group_code_id);

2941:
2942: IF PG_DEBUG in ('Y', 'C') THEN
2943: arp_standard.debug('Process_Recon: ' || ' ');
2944: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_location_segment_id = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_location_segment_id);
2945: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_tax_group_code_id = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_tax_group_code_id);
2946: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_tax_code_id = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_tax_code_id);
2947: arp_standard.debug('Process_Recon: ' || ' ');
2948: END IF;
2949:

Line 2946: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_tax_code_id = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_tax_code_id);

2942: IF PG_DEBUG in ('Y', 'C') THEN
2943: arp_standard.debug('Process_Recon: ' || ' ');
2944: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_location_segment_id = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_location_segment_id);
2945: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_tax_group_code_id = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_tax_group_code_id);
2946: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_tax_code_id = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_tax_code_id);
2947: arp_standard.debug('Process_Recon: ' || ' ');
2948: END IF;
2949:
2950: END IF; --not cached then cache

Line 2947: arp_standard.debug('Process_Recon: ' || ' ');

2943: arp_standard.debug('Process_Recon: ' || ' ');
2944: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_location_segment_id = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_location_segment_id);
2945: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_tax_group_code_id = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_tax_group_code_id);
2946: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_tax_ctr1||').ae_tax_code_id = ' || ae_tax_activity_tbl(l_tax_ctr1).ae_tax_code_id);
2947: arp_standard.debug('Process_Recon: ' || ' ');
2948: END IF;
2949:
2950: END IF; --not cached then cache
2951:

Line 2962: arp_standard.debug('Process_Recon: ' || 'Reconciling original accounting with the activity accounting ');

2958: |accounting with that of the physically stored accounting entries in ar_distributions, due |
2959: |to activity on the Bill |
2960: +------------------------------------------------------------------------------------------*/
2961: IF PG_DEBUG in ('Y', 'C') THEN
2962: arp_standard.debug('Process_Recon: ' || 'Reconciling original accounting with the activity accounting ');
2963: END IF;
2964:
2965: IF ae_tax_tbl.EXISTS(l_tax_ctr) THEN
2966:

Line 2968: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl Exists , ae_tax_activity_tbl Exists ');

2964:
2965: IF ae_tax_tbl.EXISTS(l_tax_ctr) THEN
2966:
2967: IF PG_DEBUG in ('Y', 'C') THEN
2968: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl Exists , ae_tax_activity_tbl Exists ');
2969: END IF;
2970:
2971: FOR l_ctr IN ae_tax_tbl.FIRST .. ae_tax_tbl.LAST LOOP
2972:

Line 2974: arp_standard.debug('Process_Recon: ' || 'Looping through table ae_tax_tbl to Reconcile l_ctr ' || l_ctr);

2970:
2971: FOR l_ctr IN ae_tax_tbl.FIRST .. ae_tax_tbl.LAST LOOP
2972:
2973: IF PG_DEBUG in ('Y', 'C') THEN
2974: arp_standard.debug('Process_Recon: ' || 'Looping through table ae_tax_tbl to Reconcile l_ctr ' || l_ctr);
2975: arp_standard.debug('Process_Recon: ' || ' ');
2976: arp_standard.debug('Process_Recon: ' || '******** ');
2977: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_ctr||').ae_location_segment_id = '|| ae_tax_tbl(l_ctr).ae_location_segment_id);
2978: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_ctr||').ae_tax_group_code_id = '|| ae_tax_tbl(l_ctr).ae_tax_group_code_id);

Line 2975: arp_standard.debug('Process_Recon: ' || ' ');

2971: FOR l_ctr IN ae_tax_tbl.FIRST .. ae_tax_tbl.LAST LOOP
2972:
2973: IF PG_DEBUG in ('Y', 'C') THEN
2974: arp_standard.debug('Process_Recon: ' || 'Looping through table ae_tax_tbl to Reconcile l_ctr ' || l_ctr);
2975: arp_standard.debug('Process_Recon: ' || ' ');
2976: arp_standard.debug('Process_Recon: ' || '******** ');
2977: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_ctr||').ae_location_segment_id = '|| ae_tax_tbl(l_ctr).ae_location_segment_id);
2978: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_ctr||').ae_tax_group_code_id = '|| ae_tax_tbl(l_ctr).ae_tax_group_code_id);
2979: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_ctr||').ae_tax_code_id = '|| ae_tax_tbl(l_ctr).ae_tax_code_id);

Line 2976: arp_standard.debug('Process_Recon: ' || '******** ');

2972:
2973: IF PG_DEBUG in ('Y', 'C') THEN
2974: arp_standard.debug('Process_Recon: ' || 'Looping through table ae_tax_tbl to Reconcile l_ctr ' || l_ctr);
2975: arp_standard.debug('Process_Recon: ' || ' ');
2976: arp_standard.debug('Process_Recon: ' || '******** ');
2977: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_ctr||').ae_location_segment_id = '|| ae_tax_tbl(l_ctr).ae_location_segment_id);
2978: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_ctr||').ae_tax_group_code_id = '|| ae_tax_tbl(l_ctr).ae_tax_group_code_id);
2979: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_ctr||').ae_tax_code_id = '|| ae_tax_tbl(l_ctr).ae_tax_code_id);
2980: arp_standard.debug('Process_Recon: ' || '******** ');

Line 2977: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_ctr||').ae_location_segment_id = '|| ae_tax_tbl(l_ctr).ae_location_segment_id);

2973: IF PG_DEBUG in ('Y', 'C') THEN
2974: arp_standard.debug('Process_Recon: ' || 'Looping through table ae_tax_tbl to Reconcile l_ctr ' || l_ctr);
2975: arp_standard.debug('Process_Recon: ' || ' ');
2976: arp_standard.debug('Process_Recon: ' || '******** ');
2977: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_ctr||').ae_location_segment_id = '|| ae_tax_tbl(l_ctr).ae_location_segment_id);
2978: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_ctr||').ae_tax_group_code_id = '|| ae_tax_tbl(l_ctr).ae_tax_group_code_id);
2979: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_ctr||').ae_tax_code_id = '|| ae_tax_tbl(l_ctr).ae_tax_code_id);
2980: arp_standard.debug('Process_Recon: ' || '******** ');
2981: END IF;

Line 2978: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_ctr||').ae_tax_group_code_id = '|| ae_tax_tbl(l_ctr).ae_tax_group_code_id);

2974: arp_standard.debug('Process_Recon: ' || 'Looping through table ae_tax_tbl to Reconcile l_ctr ' || l_ctr);
2975: arp_standard.debug('Process_Recon: ' || ' ');
2976: arp_standard.debug('Process_Recon: ' || '******** ');
2977: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_ctr||').ae_location_segment_id = '|| ae_tax_tbl(l_ctr).ae_location_segment_id);
2978: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_ctr||').ae_tax_group_code_id = '|| ae_tax_tbl(l_ctr).ae_tax_group_code_id);
2979: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_ctr||').ae_tax_code_id = '|| ae_tax_tbl(l_ctr).ae_tax_code_id);
2980: arp_standard.debug('Process_Recon: ' || '******** ');
2981: END IF;
2982:

Line 2979: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_ctr||').ae_tax_code_id = '|| ae_tax_tbl(l_ctr).ae_tax_code_id);

2975: arp_standard.debug('Process_Recon: ' || ' ');
2976: arp_standard.debug('Process_Recon: ' || '******** ');
2977: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_ctr||').ae_location_segment_id = '|| ae_tax_tbl(l_ctr).ae_location_segment_id);
2978: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_ctr||').ae_tax_group_code_id = '|| ae_tax_tbl(l_ctr).ae_tax_group_code_id);
2979: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_ctr||').ae_tax_code_id = '|| ae_tax_tbl(l_ctr).ae_tax_code_id);
2980: arp_standard.debug('Process_Recon: ' || '******** ');
2981: END IF;
2982:
2983: l_match_cond := FALSE;

Line 2980: arp_standard.debug('Process_Recon: ' || '******** ');

2976: arp_standard.debug('Process_Recon: ' || '******** ');
2977: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_ctr||').ae_location_segment_id = '|| ae_tax_tbl(l_ctr).ae_location_segment_id);
2978: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_ctr||').ae_tax_group_code_id = '|| ae_tax_tbl(l_ctr).ae_tax_group_code_id);
2979: arp_standard.debug('Process_Recon: ' || 'ae_tax_tbl('||l_ctr||').ae_tax_code_id = '|| ae_tax_tbl(l_ctr).ae_tax_code_id);
2980: arp_standard.debug('Process_Recon: ' || '******** ');
2981: END IF;
2982:
2983: l_match_cond := FALSE;
2984:

Line 2990: arp_standard.debug('Process_Recon: ' || 'Looping through table ae_tax_activity_tbl l_ctr1 ' || l_ctr1);

2986:
2987: FOR l_ctr1 IN ae_tax_activity_tbl.FIRST .. ae_tax_activity_tbl.LAST LOOP
2988:
2989: IF PG_DEBUG in ('Y', 'C') THEN
2990: arp_standard.debug('Process_Recon: ' || 'Looping through table ae_tax_activity_tbl l_ctr1 ' || l_ctr1);
2991: arp_standard.debug('Process_Recon: ' || ' ');
2992: arp_standard.debug('Process_Recon: ' || '>>>>>>>> COMPARE');
2993: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_ctr1||').ae_location_segment_id = '|| ae_tax_activity_tbl(l_ctr1).ae_location_segment_id);
2994: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_ctr1||').ae_tax_group_code_id = '|| ae_tax_activity_tbl(l_ctr1).ae_tax_group_code_id);

Line 2991: arp_standard.debug('Process_Recon: ' || ' ');

2987: FOR l_ctr1 IN ae_tax_activity_tbl.FIRST .. ae_tax_activity_tbl.LAST LOOP
2988:
2989: IF PG_DEBUG in ('Y', 'C') THEN
2990: arp_standard.debug('Process_Recon: ' || 'Looping through table ae_tax_activity_tbl l_ctr1 ' || l_ctr1);
2991: arp_standard.debug('Process_Recon: ' || ' ');
2992: arp_standard.debug('Process_Recon: ' || '>>>>>>>> COMPARE');
2993: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_ctr1||').ae_location_segment_id = '|| ae_tax_activity_tbl(l_ctr1).ae_location_segment_id);
2994: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_ctr1||').ae_tax_group_code_id = '|| ae_tax_activity_tbl(l_ctr1).ae_tax_group_code_id);
2995: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_ctr1||').ae_tax_code_id = '|| ae_tax_activity_tbl(l_ctr1).ae_tax_code_id);

Line 2992: arp_standard.debug('Process_Recon: ' || '>>>>>>>> COMPARE');

2988:
2989: IF PG_DEBUG in ('Y', 'C') THEN
2990: arp_standard.debug('Process_Recon: ' || 'Looping through table ae_tax_activity_tbl l_ctr1 ' || l_ctr1);
2991: arp_standard.debug('Process_Recon: ' || ' ');
2992: arp_standard.debug('Process_Recon: ' || '>>>>>>>> COMPARE');
2993: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_ctr1||').ae_location_segment_id = '|| ae_tax_activity_tbl(l_ctr1).ae_location_segment_id);
2994: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_ctr1||').ae_tax_group_code_id = '|| ae_tax_activity_tbl(l_ctr1).ae_tax_group_code_id);
2995: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_ctr1||').ae_tax_code_id = '|| ae_tax_activity_tbl(l_ctr1).ae_tax_code_id);
2996: arp_standard.debug('Process_Recon: ' || 'Amount ' || ae_tax_tbl(l_ctr).ae_amount || ' VS ' || ae_tax_activity_tbl(l_ctr1).ae_amount);

Line 2993: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_ctr1||').ae_location_segment_id = '|| ae_tax_activity_tbl(l_ctr1).ae_location_segment_id);

2989: IF PG_DEBUG in ('Y', 'C') THEN
2990: arp_standard.debug('Process_Recon: ' || 'Looping through table ae_tax_activity_tbl l_ctr1 ' || l_ctr1);
2991: arp_standard.debug('Process_Recon: ' || ' ');
2992: arp_standard.debug('Process_Recon: ' || '>>>>>>>> COMPARE');
2993: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_ctr1||').ae_location_segment_id = '|| ae_tax_activity_tbl(l_ctr1).ae_location_segment_id);
2994: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_ctr1||').ae_tax_group_code_id = '|| ae_tax_activity_tbl(l_ctr1).ae_tax_group_code_id);
2995: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_ctr1||').ae_tax_code_id = '|| ae_tax_activity_tbl(l_ctr1).ae_tax_code_id);
2996: arp_standard.debug('Process_Recon: ' || 'Amount ' || ae_tax_tbl(l_ctr).ae_amount || ' VS ' || ae_tax_activity_tbl(l_ctr1).ae_amount);
2997: arp_standard.debug('Process_Recon: ' || 'Accounted Amount ' || ae_tax_tbl(l_ctr).ae_acctd_amount || ' VS ' || ae_tax_activity_tbl(l_ctr1).ae_acctd_amount);

Line 2994: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_ctr1||').ae_tax_group_code_id = '|| ae_tax_activity_tbl(l_ctr1).ae_tax_group_code_id);

2990: arp_standard.debug('Process_Recon: ' || 'Looping through table ae_tax_activity_tbl l_ctr1 ' || l_ctr1);
2991: arp_standard.debug('Process_Recon: ' || ' ');
2992: arp_standard.debug('Process_Recon: ' || '>>>>>>>> COMPARE');
2993: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_ctr1||').ae_location_segment_id = '|| ae_tax_activity_tbl(l_ctr1).ae_location_segment_id);
2994: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_ctr1||').ae_tax_group_code_id = '|| ae_tax_activity_tbl(l_ctr1).ae_tax_group_code_id);
2995: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_ctr1||').ae_tax_code_id = '|| ae_tax_activity_tbl(l_ctr1).ae_tax_code_id);
2996: arp_standard.debug('Process_Recon: ' || 'Amount ' || ae_tax_tbl(l_ctr).ae_amount || ' VS ' || ae_tax_activity_tbl(l_ctr1).ae_amount);
2997: arp_standard.debug('Process_Recon: ' || 'Accounted Amount ' || ae_tax_tbl(l_ctr).ae_acctd_amount || ' VS ' || ae_tax_activity_tbl(l_ctr1).ae_acctd_amount);
2998: arp_standard.debug('Process_Recon: ' || 'Taxable Amount ' || ae_tax_tbl(l_ctr).ae_taxable_amount || ' VS ' || ae_tax_activity_tbl(l_ctr1).ae_taxable_amount);

Line 2995: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_ctr1||').ae_tax_code_id = '|| ae_tax_activity_tbl(l_ctr1).ae_tax_code_id);

2991: arp_standard.debug('Process_Recon: ' || ' ');
2992: arp_standard.debug('Process_Recon: ' || '>>>>>>>> COMPARE');
2993: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_ctr1||').ae_location_segment_id = '|| ae_tax_activity_tbl(l_ctr1).ae_location_segment_id);
2994: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_ctr1||').ae_tax_group_code_id = '|| ae_tax_activity_tbl(l_ctr1).ae_tax_group_code_id);
2995: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_ctr1||').ae_tax_code_id = '|| ae_tax_activity_tbl(l_ctr1).ae_tax_code_id);
2996: arp_standard.debug('Process_Recon: ' || 'Amount ' || ae_tax_tbl(l_ctr).ae_amount || ' VS ' || ae_tax_activity_tbl(l_ctr1).ae_amount);
2997: arp_standard.debug('Process_Recon: ' || 'Accounted Amount ' || ae_tax_tbl(l_ctr).ae_acctd_amount || ' VS ' || ae_tax_activity_tbl(l_ctr1).ae_acctd_amount);
2998: arp_standard.debug('Process_Recon: ' || 'Taxable Amount ' || ae_tax_tbl(l_ctr).ae_taxable_amount || ' VS ' || ae_tax_activity_tbl(l_ctr1).ae_taxable_amount);
2999: arp_standard.debug('Process_Recon: ' || 'Taxable Accounted Amount ' || ae_tax_tbl(l_ctr).ae_taxable_acctd_amount || ' VS ' || ae_tax_activity_tbl(l_ctr1).ae_taxable_acctd_amount);

Line 2996: arp_standard.debug('Process_Recon: ' || 'Amount ' || ae_tax_tbl(l_ctr).ae_amount || ' VS ' || ae_tax_activity_tbl(l_ctr1).ae_amount);

2992: arp_standard.debug('Process_Recon: ' || '>>>>>>>> COMPARE');
2993: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_ctr1||').ae_location_segment_id = '|| ae_tax_activity_tbl(l_ctr1).ae_location_segment_id);
2994: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_ctr1||').ae_tax_group_code_id = '|| ae_tax_activity_tbl(l_ctr1).ae_tax_group_code_id);
2995: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_ctr1||').ae_tax_code_id = '|| ae_tax_activity_tbl(l_ctr1).ae_tax_code_id);
2996: arp_standard.debug('Process_Recon: ' || 'Amount ' || ae_tax_tbl(l_ctr).ae_amount || ' VS ' || ae_tax_activity_tbl(l_ctr1).ae_amount);
2997: arp_standard.debug('Process_Recon: ' || 'Accounted Amount ' || ae_tax_tbl(l_ctr).ae_acctd_amount || ' VS ' || ae_tax_activity_tbl(l_ctr1).ae_acctd_amount);
2998: arp_standard.debug('Process_Recon: ' || 'Taxable Amount ' || ae_tax_tbl(l_ctr).ae_taxable_amount || ' VS ' || ae_tax_activity_tbl(l_ctr1).ae_taxable_amount);
2999: arp_standard.debug('Process_Recon: ' || 'Taxable Accounted Amount ' || ae_tax_tbl(l_ctr).ae_taxable_acctd_amount || ' VS ' || ae_tax_activity_tbl(l_ctr1).ae_taxable_acctd_amount);
3000: arp_standard.debug('Process_Recon: ' || '>>>>>>>> COMPARE');

Line 2997: arp_standard.debug('Process_Recon: ' || 'Accounted Amount ' || ae_tax_tbl(l_ctr).ae_acctd_amount || ' VS ' || ae_tax_activity_tbl(l_ctr1).ae_acctd_amount);

2993: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_ctr1||').ae_location_segment_id = '|| ae_tax_activity_tbl(l_ctr1).ae_location_segment_id);
2994: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_ctr1||').ae_tax_group_code_id = '|| ae_tax_activity_tbl(l_ctr1).ae_tax_group_code_id);
2995: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_ctr1||').ae_tax_code_id = '|| ae_tax_activity_tbl(l_ctr1).ae_tax_code_id);
2996: arp_standard.debug('Process_Recon: ' || 'Amount ' || ae_tax_tbl(l_ctr).ae_amount || ' VS ' || ae_tax_activity_tbl(l_ctr1).ae_amount);
2997: arp_standard.debug('Process_Recon: ' || 'Accounted Amount ' || ae_tax_tbl(l_ctr).ae_acctd_amount || ' VS ' || ae_tax_activity_tbl(l_ctr1).ae_acctd_amount);
2998: arp_standard.debug('Process_Recon: ' || 'Taxable Amount ' || ae_tax_tbl(l_ctr).ae_taxable_amount || ' VS ' || ae_tax_activity_tbl(l_ctr1).ae_taxable_amount);
2999: arp_standard.debug('Process_Recon: ' || 'Taxable Accounted Amount ' || ae_tax_tbl(l_ctr).ae_taxable_acctd_amount || ' VS ' || ae_tax_activity_tbl(l_ctr1).ae_taxable_acctd_amount);
3000: arp_standard.debug('Process_Recon: ' || '>>>>>>>> COMPARE');
3001: END IF;

Line 2998: arp_standard.debug('Process_Recon: ' || 'Taxable Amount ' || ae_tax_tbl(l_ctr).ae_taxable_amount || ' VS ' || ae_tax_activity_tbl(l_ctr1).ae_taxable_amount);

2994: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_ctr1||').ae_tax_group_code_id = '|| ae_tax_activity_tbl(l_ctr1).ae_tax_group_code_id);
2995: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_ctr1||').ae_tax_code_id = '|| ae_tax_activity_tbl(l_ctr1).ae_tax_code_id);
2996: arp_standard.debug('Process_Recon: ' || 'Amount ' || ae_tax_tbl(l_ctr).ae_amount || ' VS ' || ae_tax_activity_tbl(l_ctr1).ae_amount);
2997: arp_standard.debug('Process_Recon: ' || 'Accounted Amount ' || ae_tax_tbl(l_ctr).ae_acctd_amount || ' VS ' || ae_tax_activity_tbl(l_ctr1).ae_acctd_amount);
2998: arp_standard.debug('Process_Recon: ' || 'Taxable Amount ' || ae_tax_tbl(l_ctr).ae_taxable_amount || ' VS ' || ae_tax_activity_tbl(l_ctr1).ae_taxable_amount);
2999: arp_standard.debug('Process_Recon: ' || 'Taxable Accounted Amount ' || ae_tax_tbl(l_ctr).ae_taxable_acctd_amount || ' VS ' || ae_tax_activity_tbl(l_ctr1).ae_taxable_acctd_amount);
3000: arp_standard.debug('Process_Recon: ' || '>>>>>>>> COMPARE');
3001: END IF;
3002:

Line 2999: arp_standard.debug('Process_Recon: ' || 'Taxable Accounted Amount ' || ae_tax_tbl(l_ctr).ae_taxable_acctd_amount || ' VS ' || ae_tax_activity_tbl(l_ctr1).ae_taxable_acctd_amount);

2995: arp_standard.debug('Process_Recon: ' || 'ae_tax_activity_tbl('||l_ctr1||').ae_tax_code_id = '|| ae_tax_activity_tbl(l_ctr1).ae_tax_code_id);
2996: arp_standard.debug('Process_Recon: ' || 'Amount ' || ae_tax_tbl(l_ctr).ae_amount || ' VS ' || ae_tax_activity_tbl(l_ctr1).ae_amount);
2997: arp_standard.debug('Process_Recon: ' || 'Accounted Amount ' || ae_tax_tbl(l_ctr).ae_acctd_amount || ' VS ' || ae_tax_activity_tbl(l_ctr1).ae_acctd_amount);
2998: arp_standard.debug('Process_Recon: ' || 'Taxable Amount ' || ae_tax_tbl(l_ctr).ae_taxable_amount || ' VS ' || ae_tax_activity_tbl(l_ctr1).ae_taxable_amount);
2999: arp_standard.debug('Process_Recon: ' || 'Taxable Accounted Amount ' || ae_tax_tbl(l_ctr).ae_taxable_acctd_amount || ' VS ' || ae_tax_activity_tbl(l_ctr1).ae_taxable_acctd_amount);
3000: arp_standard.debug('Process_Recon: ' || '>>>>>>>> COMPARE');
3001: END IF;
3002:
3003: IF (((ae_tax_tbl(l_ctr).ae_location_segment_id IS NOT NULL)

Line 3000: arp_standard.debug('Process_Recon: ' || '>>>>>>>> COMPARE');

2996: arp_standard.debug('Process_Recon: ' || 'Amount ' || ae_tax_tbl(l_ctr).ae_amount || ' VS ' || ae_tax_activity_tbl(l_ctr1).ae_amount);
2997: arp_standard.debug('Process_Recon: ' || 'Accounted Amount ' || ae_tax_tbl(l_ctr).ae_acctd_amount || ' VS ' || ae_tax_activity_tbl(l_ctr1).ae_acctd_amount);
2998: arp_standard.debug('Process_Recon: ' || 'Taxable Amount ' || ae_tax_tbl(l_ctr).ae_taxable_amount || ' VS ' || ae_tax_activity_tbl(l_ctr1).ae_taxable_amount);
2999: arp_standard.debug('Process_Recon: ' || 'Taxable Accounted Amount ' || ae_tax_tbl(l_ctr).ae_taxable_acctd_amount || ' VS ' || ae_tax_activity_tbl(l_ctr1).ae_taxable_acctd_amount);
3000: arp_standard.debug('Process_Recon: ' || '>>>>>>>> COMPARE');
3001: END IF;
3002:
3003: IF (((ae_tax_tbl(l_ctr).ae_location_segment_id IS NOT NULL)
3004: AND (ae_tax_activity_tbl(l_ctr1).ae_location_segment_id IS NOT NULL)

Line 3017: arp_standard.debug('Process_Recon: ' || 'Matching condition found in ae_tax_tbl, construct reconcile entry ');

3013: AND (ae_tax_tbl(l_ctr).ae_code_combination_id = ae_tax_activity_tbl(l_ctr1).ae_code_combination_id))
3014: THEN
3015:
3016: IF PG_DEBUG in ('Y', 'C') THEN
3017: arp_standard.debug('Process_Recon: ' || 'Matching condition found in ae_tax_tbl, construct reconcile entry ');
3018: END IF;
3019:
3020: ae_tax_activity_tbl(l_ctr1).ae_match_flag := 'Y';
3021:

Line 3130: arp_standard.debug('Process_Recon: ' || 'Matching condition not found in ae_tax_tbl, construct reconcile entry ');

3126: +---------------------------------------------------------------------------------*/
3127: IF (NOT l_match_cond) THEN
3128:
3129: IF PG_DEBUG in ('Y', 'C') THEN
3130: arp_standard.debug('Process_Recon: ' || 'Matching condition not found in ae_tax_tbl, construct reconcile entry ');
3131: END IF;
3132:
3133: --set amount
3134: IF ae_tax_tbl(l_ctr).ae_amount > 0 THEN

Line 3188: arp_standard.debug('Process_Recon: ' || 'Assemble the l_ae_line_rec record for reconciliation entry ');

3184: +---------------------------------------------------------------------------------*/
3185: IF (l_cre_rec) THEN --set other attributes of accounting lines reconciliation entry
3186:
3187: IF PG_DEBUG in ('Y', 'C') THEN
3188: arp_standard.debug('Process_Recon: ' || 'Assemble the l_ae_line_rec record for reconciliation entry ');
3189: END IF;
3190:
3191: --Build the Deferred Tax accounting entry
3192: Build_Deferred_Tax(

Line 3227: arp_standard.debug('Process_Recon: ' || 'REVERSE SWEEP ');

3223:
3224: END LOOP; --tax table
3225:
3226: IF PG_DEBUG in ('Y', 'C') THEN
3227: arp_standard.debug('Process_Recon: ' || 'REVERSE SWEEP ');
3228: END IF;
3229:
3230: /*----------------------------------------------------------------------------+
3231: | Sweep through the tax activity table and if the matching flag is not Y then|

Line 3252: arp_standard.debug('Process_Recon: ' || 'REVERSE SWEEP ae_tax_activity_tbl(l_ctr).ae_amount' || ae_tax_activity_tbl(l_ctr).ae_amount);

3248: | to activity as there is no match for on Original Transaction by |
3249: | tax group, tax code, location and account |
3250: +------------------------------------------------------------------*/
3251: IF PG_DEBUG in ('Y', 'C') THEN
3252: arp_standard.debug('Process_Recon: ' || 'REVERSE SWEEP ae_tax_activity_tbl(l_ctr).ae_amount' || ae_tax_activity_tbl(l_ctr).ae_amount);
3253: END IF;
3254: IF ae_tax_activity_tbl(l_ctr).ae_amount > 0 THEN
3255:
3256: l_ae_line_rec.entered_dr := abs(ae_tax_activity_tbl(l_ctr).ae_amount);

Line 3266: arp_standard.debug('Process_Recon: ' || 'REVERSE SWEEP ae_tax_activity_tbl(l_ctr).ae_acctd_amount' || ae_tax_activity_tbl(l_ctr).ae_acctd_amount);

3262: l_cre_rec := TRUE;
3263: END IF;
3264:
3265: IF PG_DEBUG in ('Y', 'C') THEN
3266: arp_standard.debug('Process_Recon: ' || 'REVERSE SWEEP ae_tax_activity_tbl(l_ctr).ae_acctd_amount' || ae_tax_activity_tbl(l_ctr).ae_acctd_amount);
3267: END IF;
3268: --set accounted amount
3269: IF ae_tax_activity_tbl(l_ctr).ae_acctd_amount > 0 THEN
3270:

Line 3281: arp_standard.debug('Process_Recon: ' || 'REVERSE SWEEP ae_tax_activity_tbl(l_ctr).ae_taxable_amount' || ae_tax_activity_tbl(l_ctr).ae_taxable_amount);

3277: l_cre_rec := TRUE;
3278: END IF;
3279:
3280: IF PG_DEBUG in ('Y', 'C') THEN
3281: arp_standard.debug('Process_Recon: ' || 'REVERSE SWEEP ae_tax_activity_tbl(l_ctr).ae_taxable_amount' || ae_tax_activity_tbl(l_ctr).ae_taxable_amount);
3282: END IF;
3283: --set taxable amount
3284: IF ae_tax_activity_tbl(l_ctr).ae_taxable_amount > 0 THEN
3285: l_ae_line_rec.taxable_entered_dr := abs(ae_tax_activity_tbl(l_ctr).ae_taxable_amount);

Line 3295: arp_standard.debug('Process_Recon: ' || 'REVERSE SWEEP ae_tax_activity_tbl(l_ctr).ae_taxable_acctd_amount' || ae_tax_activity_tbl(l_ctr).ae_taxable_acctd_amount);

3291: l_cre_rec := TRUE;
3292: END IF;
3293:
3294: IF PG_DEBUG in ('Y', 'C') THEN
3295: arp_standard.debug('Process_Recon: ' || 'REVERSE SWEEP ae_tax_activity_tbl(l_ctr).ae_taxable_acctd_amount' || ae_tax_activity_tbl(l_ctr).ae_taxable_acctd_amount);
3296: END IF;
3297: --set taxable accounted amount
3298: IF ae_tax_activity_tbl(l_ctr).ae_taxable_acctd_amount > 0 THEN
3299: l_ae_line_rec.taxable_accounted_dr := abs(ae_tax_activity_tbl(l_ctr).ae_taxable_acctd_amount);

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 3428: arp_standard.debug('Build_Deferred_Tax: ' || 'Setting source type secondary to ASSIGNMENT_RECONCILE');

3424: | Bill line id, however for transactions only the source type secondary is used|
3425: +------------------------------------------------------------------------------*/
3426: IF (p_calling_point IN ('BILL', 'BLTR')) THEN
3427: IF PG_DEBUG in ('Y', 'C') THEN
3428: arp_standard.debug('Build_Deferred_Tax: ' || 'Setting source type secondary to ASSIGNMENT_RECONCILE');
3429: END IF;
3430:
3431: --set transaction reconciliation entries line type secondary when bill is closed
3432: IF (p_calling_point = 'BLTR') THEN

Line 3442: arp_standard.debug('Build_Deferred_Tax: ' || 'Setting source type secondary to RECONCILE');

3438: p_ae_line_rec.source_id_secondary := p_br_cust_trx_line_id ;
3439: p_ae_line_rec.source_table_secondary := 'CTL' ;
3440: ELSE --for transactions we only populate source type secondary for deferred tax
3441: IF PG_DEBUG in ('Y', 'C') THEN
3442: arp_standard.debug('Build_Deferred_Tax: ' || 'Setting source type secondary to RECONCILE');
3443: END IF;
3444: p_ae_line_rec.ae_line_type_secondary := 'RECONCILE';
3445: p_ae_line_rec.source_id_secondary := p_customer_trx_id;
3446: p_ae_line_rec.source_table_secondary := 'CT';

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 3519: arp_standard.debug('Build_Tax: ' || 'Fetching offsetting collected tax accounting entry');

3515: | manually. Ideally the combination of deferred and collected tax accounts |
3516: | will not change. |
3517: +-----------------------------------------------------------------------------*/
3518: IF PG_DEBUG in ('Y', 'C') THEN
3519: arp_standard.debug('Build_Tax: ' || 'Fetching offsetting collected tax accounting entry');
3520: arp_standard.debug('Build_Tax: ' || 'Using parameter p_customer_trx_id ' || p_customer_trx_id);
3521: arp_standard.debug('Build_Tax: ' || 'Using parameter location_segment_id ' || p_location_segment_id);
3522: arp_standard.debug('Build_Tax: ' || 'Using parameter tax_group_code_id ' || p_tax_group_code_id);
3523: arp_standard.debug('Build_Tax: ' || 'Using parameter tax_code_id ' || p_tax_code_id);

Line 3520: arp_standard.debug('Build_Tax: ' || 'Using parameter p_customer_trx_id ' || p_customer_trx_id);

3516: | will not change. |
3517: +-----------------------------------------------------------------------------*/
3518: IF PG_DEBUG in ('Y', 'C') THEN
3519: arp_standard.debug('Build_Tax: ' || 'Fetching offsetting collected tax accounting entry');
3520: arp_standard.debug('Build_Tax: ' || 'Using parameter p_customer_trx_id ' || p_customer_trx_id);
3521: arp_standard.debug('Build_Tax: ' || 'Using parameter location_segment_id ' || p_location_segment_id);
3522: arp_standard.debug('Build_Tax: ' || 'Using parameter tax_group_code_id ' || p_tax_group_code_id);
3523: arp_standard.debug('Build_Tax: ' || 'Using parameter tax_code_id ' || p_tax_code_id);
3524: arp_standard.debug('Build_Tax: ' || 'Using parameter code_combination_id ' || p_code_combination_id);

Line 3521: arp_standard.debug('Build_Tax: ' || 'Using parameter location_segment_id ' || p_location_segment_id);

3517: +-----------------------------------------------------------------------------*/
3518: IF PG_DEBUG in ('Y', 'C') THEN
3519: arp_standard.debug('Build_Tax: ' || 'Fetching offsetting collected tax accounting entry');
3520: arp_standard.debug('Build_Tax: ' || 'Using parameter p_customer_trx_id ' || p_customer_trx_id);
3521: arp_standard.debug('Build_Tax: ' || 'Using parameter location_segment_id ' || p_location_segment_id);
3522: arp_standard.debug('Build_Tax: ' || 'Using parameter tax_group_code_id ' || p_tax_group_code_id);
3523: arp_standard.debug('Build_Tax: ' || 'Using parameter tax_code_id ' || p_tax_code_id);
3524: arp_standard.debug('Build_Tax: ' || 'Using parameter code_combination_id ' || p_code_combination_id);
3525: END IF;

Line 3522: arp_standard.debug('Build_Tax: ' || 'Using parameter tax_group_code_id ' || p_tax_group_code_id);

3518: IF PG_DEBUG in ('Y', 'C') THEN
3519: arp_standard.debug('Build_Tax: ' || 'Fetching offsetting collected tax accounting entry');
3520: arp_standard.debug('Build_Tax: ' || 'Using parameter p_customer_trx_id ' || p_customer_trx_id);
3521: arp_standard.debug('Build_Tax: ' || 'Using parameter location_segment_id ' || p_location_segment_id);
3522: arp_standard.debug('Build_Tax: ' || 'Using parameter tax_group_code_id ' || p_tax_group_code_id);
3523: arp_standard.debug('Build_Tax: ' || 'Using parameter tax_code_id ' || p_tax_code_id);
3524: arp_standard.debug('Build_Tax: ' || 'Using parameter code_combination_id ' || p_code_combination_id);
3525: END IF;
3526:

Line 3523: arp_standard.debug('Build_Tax: ' || 'Using parameter tax_code_id ' || p_tax_code_id);

3519: arp_standard.debug('Build_Tax: ' || 'Fetching offsetting collected tax accounting entry');
3520: arp_standard.debug('Build_Tax: ' || 'Using parameter p_customer_trx_id ' || p_customer_trx_id);
3521: arp_standard.debug('Build_Tax: ' || 'Using parameter location_segment_id ' || p_location_segment_id);
3522: arp_standard.debug('Build_Tax: ' || 'Using parameter tax_group_code_id ' || p_tax_group_code_id);
3523: arp_standard.debug('Build_Tax: ' || 'Using parameter tax_code_id ' || p_tax_code_id);
3524: arp_standard.debug('Build_Tax: ' || 'Using parameter code_combination_id ' || p_code_combination_id);
3525: END IF;
3526:
3527: --In R12 the vat tax id also called the tax rate id is the unique key

Line 3524: arp_standard.debug('Build_Tax: ' || 'Using parameter code_combination_id ' || p_code_combination_id);

3520: arp_standard.debug('Build_Tax: ' || 'Using parameter p_customer_trx_id ' || p_customer_trx_id);
3521: arp_standard.debug('Build_Tax: ' || 'Using parameter location_segment_id ' || p_location_segment_id);
3522: arp_standard.debug('Build_Tax: ' || 'Using parameter tax_group_code_id ' || p_tax_group_code_id);
3523: arp_standard.debug('Build_Tax: ' || 'Using parameter tax_code_id ' || p_tax_code_id);
3524: arp_standard.debug('Build_Tax: ' || 'Using parameter code_combination_id ' || p_code_combination_id);
3525: END IF;
3526:
3527: --In R12 the vat tax id also called the tax rate id is the unique key
3528: --there is no concept of tax group id and location segment id is no longer

Line 3554: arp_standard.debug('Build_Tax: ' || 'Completed fetching offsetting collected tax accounting entry');

3550: where ctl1.customer_trx_id = p_customer_trx_id
3551: and ctl1.autorule_complete_flag = 'N');
3552:
3553: IF PG_DEBUG in ('Y', 'C') THEN
3554: arp_standard.debug('Build_Tax: ' || 'Completed fetching offsetting collected tax accounting entry');
3555: END IF;
3556:
3557: p_ae_line_rec.ae_line_type := 'TAX';
3558: p_ae_line_rec.account := l_collected_ccid;

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;