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_RECEIPTS_MAIN dependencies on STANDARD

Line 176: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Delete_Acct()+');

172: p_ae_event_rec IN ae_event_rec_type,
173: p_ae_deleted OUT NOCOPY BOOLEAN ) IS
174: BEGIN
175: IF PG_DEBUG in ('Y', 'C') THEN
176: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Delete_Acct()+');
177: END IF;
178:
179: /*----------------------------------------------------+
180: | Copy Document/Event Data to Global |

Line 203: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Delete_Acct()-');

199:
200: END IF;
201:
202: IF PG_DEBUG in ('Y', 'C') THEN
203: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Delete_Acct()-');
204: END IF;
205:
206: EXCEPTION
207: WHEN OTHERS THEN

Line 209: arp_standard.debug( 'EXCEPTION: ARP_RECEIPTS_MAIN.Delete_Acct');

205:
206: EXCEPTION
207: WHEN OTHERS THEN
208: IF PG_DEBUG in ('Y', 'C') THEN
209: arp_standard.debug( 'EXCEPTION: ARP_RECEIPTS_MAIN.Delete_Acct');
210: END IF;
211: RAISE;
212:
213: END Delete_Acct;

Line 253: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Execute()+');

249:
250:
251: BEGIN
252: IF PG_DEBUG in ('Y', 'C') THEN
253: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Execute()+');
254: END IF;
255: /*------------------------------------------------------+
256: | Initialize Accounting Entry Header and Lines |
257: +------------------------------------------------------*/

Line 306: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Execute()-');

302:
303: END IF;
304:
305: IF PG_DEBUG in ('Y', 'C') THEN
306: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Execute()-');
307: END IF;
308:
309: EXCEPTION
310: WHEN NO_DATA_FOUND THEN

Line 312: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Execute - NO_DATA_FOUND' );

308:
309: EXCEPTION
310: WHEN NO_DATA_FOUND THEN
311: IF PG_DEBUG in ('Y', 'C') THEN
312: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Execute - NO_DATA_FOUND' );
313: END IF;
314: RAISE;
315:
316: WHEN OTHERS THEN

Line 318: arp_standard.debug( 'EXCEPTION: ARP_RECEIPTS_MAIN.Execute');

314: RAISE;
315:
316: WHEN OTHERS THEN
317: IF PG_DEBUG in ('Y', 'C') THEN
318: arp_standard.debug( 'EXCEPTION: ARP_RECEIPTS_MAIN.Execute');
319: END IF;
320: RAISE;
321:
322: END Execute;

Line 340: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Init_Ae_Lines()+');

336:
337: BEGIN
338:
339: IF PG_DEBUG in ('Y', 'C') THEN
340: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Init_Ae_Lines()+');
341: END IF;
342:
343: g_ae_line_tbl := g_empty_ae_line_tbl;
344:

Line 346: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Init_Ae_Lines()-');

342:
343: g_ae_line_tbl := g_empty_ae_line_tbl;
344:
345: IF PG_DEBUG in ('Y', 'C') THEN
346: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Init_Ae_Lines()-');
347: END IF;
348: EXCEPTION
349:
350: WHEN OTHERS THEN

Line 352: arp_standard.debug( 'EXCEPTION: ARP_RECEIPTS_MAIN.Init_Ae_Lines');

348: EXCEPTION
349:
350: WHEN OTHERS THEN
351: IF PG_DEBUG in ('Y', 'C') THEN
352: arp_standard.debug( 'EXCEPTION: ARP_RECEIPTS_MAIN.Init_Ae_Lines');
353: END IF;
354: RAISE;
355:
356: END Init_Ae_Lines;

Line 379: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Derive_Accounting_Entry()+');

375: IS
376:
377: BEGIN
378: IF PG_DEBUG in ('Y', 'C') THEN
379: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Derive_Accounting_Entry()+');
380: arp_standard.debug( ' p_from_llca_call : '||p_from_llca_call);
381: arp_standard.debug( ' p_gt_id : '||p_gt_id);
382: END IF;
383: /*------------------------------------------------------------+

Line 380: arp_standard.debug( ' p_from_llca_call : '||p_from_llca_call);

376:
377: BEGIN
378: IF PG_DEBUG in ('Y', 'C') THEN
379: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Derive_Accounting_Entry()+');
380: arp_standard.debug( ' p_from_llca_call : '||p_from_llca_call);
381: arp_standard.debug( ' p_gt_id : '||p_gt_id);
382: END IF;
383: /*------------------------------------------------------------+
384: | Create Accounting Entries at the Document Entity level. |

Line 381: arp_standard.debug( ' p_gt_id : '||p_gt_id);

377: BEGIN
378: IF PG_DEBUG in ('Y', 'C') THEN
379: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Derive_Accounting_Entry()+');
380: arp_standard.debug( ' p_from_llca_call : '||p_from_llca_call);
381: arp_standard.debug( ' p_gt_id : '||p_gt_id);
382: END IF;
383: /*------------------------------------------------------------+
384: | Create Accounting Entries at the Document Entity level. |
385: +------------------------------------------------------------*/

Line 435: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Derive_Accounting_Entry()-');

431:
432: END IF; -- accounting_entity_level = ALL?
433:
434: IF PG_DEBUG in ('Y', 'C') THEN
435: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Derive_Accounting_Entry()-');
436: END IF;
437:
438: EXCEPTION
439: WHEN OTHERS THEN

Line 441: arp_standard.debug( 'EXCEPTION: ARP_RECEIPTS_MAIN.Derive_Accounting_Entry');

437:
438: EXCEPTION
439: WHEN OTHERS THEN
440: IF PG_DEBUG in ('Y', 'C') THEN
441: arp_standard.debug( 'EXCEPTION: ARP_RECEIPTS_MAIN.Derive_Accounting_Entry');
442: END IF;
443: RAISE;
444: END Derive_Accounting_Entry;
445:

Line 468: arp_standard.debug('ARP_RECEIPTS_MAIN.Delete_RA()+');

464: l_ar_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
465:
466: BEGIN
467: IF PG_DEBUG in ('Y', 'C') THEN
468: arp_standard.debug('ARP_RECEIPTS_MAIN.Delete_RA()+');
469: END IF;
470:
471: /*-------------------------------------------------------------------+
472: | Verify that the source id is a valid candidate for deletion |

Line 514: arp_standard.debug('ARP_RECEIPTS_MAIN.Delete_RA()-');

510: WHERE source_id = g_ae_doc_rec.source_id
511: AND source_table = 'RA';
512:
513: IF PG_DEBUG in ('Y', 'C') THEN
514: arp_standard.debug('ARP_RECEIPTS_MAIN.Delete_RA()-');
515: END IF;
516:
517: EXCEPTION
518: WHEN NO_DATA_FOUND THEN

Line 520: arp_standard.debug('ARP_RECEIPTS_MAIN.Delete_RA - NO_DATA_FOUND' );

516:
517: EXCEPTION
518: WHEN NO_DATA_FOUND THEN
519: IF PG_DEBUG in ('Y', 'C') THEN
520: arp_standard.debug('ARP_RECEIPTS_MAIN.Delete_RA - NO_DATA_FOUND' );
521: END IF;
522: p_ae_deleted := FALSE;
523: RAISE;
524:

Line 527: arp_standard.debug('EXCEPTION: ARP_RECEIPTS_MAIN.Delete_RA - OTHERS');

523: RAISE;
524:
525: WHEN OTHERS THEN
526: IF PG_DEBUG in ('Y', 'C') THEN
527: arp_standard.debug('EXCEPTION: ARP_RECEIPTS_MAIN.Delete_RA - OTHERS');
528: END IF;
529: p_ae_deleted := FALSE;
530: RAISE ;
531:

Line 566: arp_standard.debug('ARP_RECEIPTS_MAIN.Delete_MCD()+');

562: l_ar_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
563:
564: BEGIN
565: IF PG_DEBUG in ('Y', 'C') THEN
566: arp_standard.debug('ARP_RECEIPTS_MAIN.Delete_MCD()+');
567: END IF;
568:
569: p_ae_deleted := FALSE;
570: l_dummy := 'N';

Line 592: arp_standard.debug('ARP_RECEIPTS_MAIN.Delete_MCD()-');

588: FROM dual
589: WHERE l_dummy = 'Y';
590:
591: IF PG_DEBUG in ('Y', 'C') THEN
592: arp_standard.debug('ARP_RECEIPTS_MAIN.Delete_MCD()-');
593: END IF;
594:
595: EXCEPTION
596: WHEN NO_DATA_FOUND THEN

Line 598: arp_standard.debug('ARP_RECEIPTS_MAIN.Delete_MCD - NO_DATA_FOUND' );

594:
595: EXCEPTION
596: WHEN NO_DATA_FOUND THEN
597: IF PG_DEBUG in ('Y', 'C') THEN
598: arp_standard.debug('ARP_RECEIPTS_MAIN.Delete_MCD - NO_DATA_FOUND' );
599: END IF;
600: p_ae_deleted := FALSE;
601: RAISE;
602:

Line 605: arp_standard.debug('EXCEPTION: ARP_RECEIPTS_MAIN.Delete_MCD');

601: RAISE;
602:
603: WHEN OTHERS THEN
604: IF PG_DEBUG in ('Y', 'C') THEN
605: arp_standard.debug('EXCEPTION: ARP_RECEIPTS_MAIN.Delete_MCD');
606: END IF;
607: p_ae_deleted := FALSE;
608: RAISE ;
609:

Line 782: and ard.source_table = 'TH' --for Bills Receivable Standard/Factored

778: and app.receivable_application_id = g_ae_doc_rec.source_id_old
779: and ard.source_id = app.link_to_trx_hist_id
780: and nvl(ard.source_type_secondary,'X') NOT IN
781: ('ASSIGNMENT_RECONCILE','RECONCILE')
782: and ard.source_table = 'TH' --for Bills Receivable Standard/Factored
783: and nvl(g_ae_doc_rec.event,'NONE') <> 'RISK_UNELIMINATED'
784: and ard.ref_line_id = adjsrctp.line_id(+) --3377004
785: and ard.ref_customer_trx_line_id = line_trx_type.customer_trx_line_id(+)
786: order by 1;

Line 868: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Reverse_Receipt_CM()+');

864: l_trx_upg_method ra_customer_trx.upgrade_method%type;
865:
866: --}
867: BEGIN
868: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Reverse_Receipt_CM()+');
869:
870: -- Check for upgrade_method
871: OPEN verif_trx_mark(g_ae_doc_rec.source_id_old);
872: FETCH verif_trx_mark INTO l_record_mark;

Line 1034: arp_standard.debug(' l_ard_rec.WHICH_BUCKET:'||l_ard_rec.WHICH_BUCKET);

1030: -- Assign AEL for Reversal
1031: Assign_Ael_Elements( p_ae_line_rec => l_ael_line_rec );
1032:
1033: --{3377004
1034: arp_standard.debug(' l_ard_rec.WHICH_BUCKET:'||l_ard_rec.WHICH_BUCKET);
1035: arp_standard.debug(' l_ard_rec.ref_customer_trx_line_id:'||l_ard_rec.ref_customer_trx_line_id);
1036: arp_standard.debug(' l_ard_rec.ref_prev_cust_trx_line_id:'||l_ard_rec.ref_prev_cust_trx_line_id);
1037: arp_standard.debug(' l_ard_rec.ref_line_id:'||l_ard_rec.ref_line_id);
1038: arp_standard.debug(' trx_upgrade_method :'||l_record_mark.trx_upgrade_method);

Line 1035: arp_standard.debug(' l_ard_rec.ref_customer_trx_line_id:'||l_ard_rec.ref_customer_trx_line_id);

1031: Assign_Ael_Elements( p_ae_line_rec => l_ael_line_rec );
1032:
1033: --{3377004
1034: arp_standard.debug(' l_ard_rec.WHICH_BUCKET:'||l_ard_rec.WHICH_BUCKET);
1035: arp_standard.debug(' l_ard_rec.ref_customer_trx_line_id:'||l_ard_rec.ref_customer_trx_line_id);
1036: arp_standard.debug(' l_ard_rec.ref_prev_cust_trx_line_id:'||l_ard_rec.ref_prev_cust_trx_line_id);
1037: arp_standard.debug(' l_ard_rec.ref_line_id:'||l_ard_rec.ref_line_id);
1038: arp_standard.debug(' trx_upgrade_method :'||l_record_mark.trx_upgrade_method);
1039: arp_standard.debug(' cm_upgrade_method :'||l_record_mark.cm_upgrade_method);

Line 1036: arp_standard.debug(' l_ard_rec.ref_prev_cust_trx_line_id:'||l_ard_rec.ref_prev_cust_trx_line_id);

1032:
1033: --{3377004
1034: arp_standard.debug(' l_ard_rec.WHICH_BUCKET:'||l_ard_rec.WHICH_BUCKET);
1035: arp_standard.debug(' l_ard_rec.ref_customer_trx_line_id:'||l_ard_rec.ref_customer_trx_line_id);
1036: arp_standard.debug(' l_ard_rec.ref_prev_cust_trx_line_id:'||l_ard_rec.ref_prev_cust_trx_line_id);
1037: arp_standard.debug(' l_ard_rec.ref_line_id:'||l_ard_rec.ref_line_id);
1038: arp_standard.debug(' trx_upgrade_method :'||l_record_mark.trx_upgrade_method);
1039: arp_standard.debug(' cm_upgrade_method :'||l_record_mark.cm_upgrade_method);
1040: arp_standard.debug(' ard.ref_mf_dist_flag :'||NVL(l_ard_rec.ref_mf_dist_flag,'Y') );

Line 1037: arp_standard.debug(' l_ard_rec.ref_line_id:'||l_ard_rec.ref_line_id);

1033: --{3377004
1034: arp_standard.debug(' l_ard_rec.WHICH_BUCKET:'||l_ard_rec.WHICH_BUCKET);
1035: arp_standard.debug(' l_ard_rec.ref_customer_trx_line_id:'||l_ard_rec.ref_customer_trx_line_id);
1036: arp_standard.debug(' l_ard_rec.ref_prev_cust_trx_line_id:'||l_ard_rec.ref_prev_cust_trx_line_id);
1037: arp_standard.debug(' l_ard_rec.ref_line_id:'||l_ard_rec.ref_line_id);
1038: arp_standard.debug(' trx_upgrade_method :'||l_record_mark.trx_upgrade_method);
1039: arp_standard.debug(' cm_upgrade_method :'||l_record_mark.cm_upgrade_method);
1040: arp_standard.debug(' ard.ref_mf_dist_flag :'||NVL(l_ard_rec.ref_mf_dist_flag,'Y') );
1041:

Line 1038: arp_standard.debug(' trx_upgrade_method :'||l_record_mark.trx_upgrade_method);

1034: arp_standard.debug(' l_ard_rec.WHICH_BUCKET:'||l_ard_rec.WHICH_BUCKET);
1035: arp_standard.debug(' l_ard_rec.ref_customer_trx_line_id:'||l_ard_rec.ref_customer_trx_line_id);
1036: arp_standard.debug(' l_ard_rec.ref_prev_cust_trx_line_id:'||l_ard_rec.ref_prev_cust_trx_line_id);
1037: arp_standard.debug(' l_ard_rec.ref_line_id:'||l_ard_rec.ref_line_id);
1038: arp_standard.debug(' trx_upgrade_method :'||l_record_mark.trx_upgrade_method);
1039: arp_standard.debug(' cm_upgrade_method :'||l_record_mark.cm_upgrade_method);
1040: arp_standard.debug(' ard.ref_mf_dist_flag :'||NVL(l_ard_rec.ref_mf_dist_flag,'Y') );
1041:
1042: IF l_ard_rec.WHICH_BUCKET = 'N' OR NVL(l_ard_rec.ref_mf_dist_flag,'Y') = 'N' THEN

Line 1039: arp_standard.debug(' cm_upgrade_method :'||l_record_mark.cm_upgrade_method);

1035: arp_standard.debug(' l_ard_rec.ref_customer_trx_line_id:'||l_ard_rec.ref_customer_trx_line_id);
1036: arp_standard.debug(' l_ard_rec.ref_prev_cust_trx_line_id:'||l_ard_rec.ref_prev_cust_trx_line_id);
1037: arp_standard.debug(' l_ard_rec.ref_line_id:'||l_ard_rec.ref_line_id);
1038: arp_standard.debug(' trx_upgrade_method :'||l_record_mark.trx_upgrade_method);
1039: arp_standard.debug(' cm_upgrade_method :'||l_record_mark.cm_upgrade_method);
1040: arp_standard.debug(' ard.ref_mf_dist_flag :'||NVL(l_ard_rec.ref_mf_dist_flag,'Y') );
1041:
1042: IF l_ard_rec.WHICH_BUCKET = 'N' OR NVL(l_ard_rec.ref_mf_dist_flag,'Y') = 'N' THEN
1043:

Line 1040: arp_standard.debug(' ard.ref_mf_dist_flag :'||NVL(l_ard_rec.ref_mf_dist_flag,'Y') );

1036: arp_standard.debug(' l_ard_rec.ref_prev_cust_trx_line_id:'||l_ard_rec.ref_prev_cust_trx_line_id);
1037: arp_standard.debug(' l_ard_rec.ref_line_id:'||l_ard_rec.ref_line_id);
1038: arp_standard.debug(' trx_upgrade_method :'||l_record_mark.trx_upgrade_method);
1039: arp_standard.debug(' cm_upgrade_method :'||l_record_mark.cm_upgrade_method);
1040: arp_standard.debug(' ard.ref_mf_dist_flag :'||NVL(l_ard_rec.ref_mf_dist_flag,'Y') );
1041:
1042: IF l_ard_rec.WHICH_BUCKET = 'N' OR NVL(l_ard_rec.ref_mf_dist_flag,'Y') = 'N' THEN
1043:
1044: NULL;

Line 1081: arp_standard.debug('l_ctl_rem_amt.customer_trx_line_id('||l_index||'):'||

1077: l_ctl_rem_amt.acctd_amount_due_remaining(l_index) :=
1078: NVL(l_ctl_rem_amt.acctd_amount_due_remaining(l_index),0)
1079: + (NVL(l_ard_rec.acctd_amount_cr,0) - NVL(l_ard_rec.acctd_amount_dr,0));
1080: END IF;
1081: arp_standard.debug('l_ctl_rem_amt.customer_trx_line_id('||l_index||'):'||
1082: l_ctl_rem_amt.customer_trx_line_id(l_index));
1083: arp_standard.debug('l_ctl_rem_amt.amount_due_remaining('||l_index||'):'||
1084: l_ctl_rem_amt.amount_due_remaining(l_index));
1085: arp_standard.debug('l_ctl_rem_amt.acctd_amount_due_remaining('||l_index||'):'||

Line 1083: arp_standard.debug('l_ctl_rem_amt.amount_due_remaining('||l_index||'):'||

1079: + (NVL(l_ard_rec.acctd_amount_cr,0) - NVL(l_ard_rec.acctd_amount_dr,0));
1080: END IF;
1081: arp_standard.debug('l_ctl_rem_amt.customer_trx_line_id('||l_index||'):'||
1082: l_ctl_rem_amt.customer_trx_line_id(l_index));
1083: arp_standard.debug('l_ctl_rem_amt.amount_due_remaining('||l_index||'):'||
1084: l_ctl_rem_amt.amount_due_remaining(l_index));
1085: arp_standard.debug('l_ctl_rem_amt.acctd_amount_due_remaining('||l_index||'):'||
1086: l_ctl_rem_amt.acctd_amount_due_remaining(l_index));
1087:

Line 1085: arp_standard.debug('l_ctl_rem_amt.acctd_amount_due_remaining('||l_index||'):'||

1081: arp_standard.debug('l_ctl_rem_amt.customer_trx_line_id('||l_index||'):'||
1082: l_ctl_rem_amt.customer_trx_line_id(l_index));
1083: arp_standard.debug('l_ctl_rem_amt.amount_due_remaining('||l_index||'):'||
1084: l_ctl_rem_amt.amount_due_remaining(l_index));
1085: arp_standard.debug('l_ctl_rem_amt.acctd_amount_due_remaining('||l_index||'):'||
1086: l_ctl_rem_amt.acctd_amount_due_remaining(l_index));
1087:
1088: END IF; --1
1089:

Line 1125: arp_standard.debug('l_ctl_rem_amt.customer_trx_line_id('||l_index||'):'||

1121: l_ctl_rem_amt.chrg_acctd_amount_remaining(l_index) :=
1122: NVL(l_ctl_rem_amt.chrg_acctd_amount_remaining(l_index),0)
1123: + (NVL(l_ard_rec.acctd_amount_cr,0) - NVL(l_ard_rec.acctd_amount_dr,0));
1124: END IF;
1125: arp_standard.debug('l_ctl_rem_amt.customer_trx_line_id('||l_index||'):'||
1126: l_ctl_rem_amt.customer_trx_line_id(l_index));
1127: arp_standard.debug('l_ctl_rem_amt.chrg_amount_remaining('||l_index||'):'||
1128: l_ctl_rem_amt.chrg_amount_remaining(l_index));
1129: arp_standard.debug('l_ctl_rem_amt.chrg_acctd_amount_remaining('||l_index||'):'||

Line 1127: arp_standard.debug('l_ctl_rem_amt.chrg_amount_remaining('||l_index||'):'||

1123: + (NVL(l_ard_rec.acctd_amount_cr,0) - NVL(l_ard_rec.acctd_amount_dr,0));
1124: END IF;
1125: arp_standard.debug('l_ctl_rem_amt.customer_trx_line_id('||l_index||'):'||
1126: l_ctl_rem_amt.customer_trx_line_id(l_index));
1127: arp_standard.debug('l_ctl_rem_amt.chrg_amount_remaining('||l_index||'):'||
1128: l_ctl_rem_amt.chrg_amount_remaining(l_index));
1129: arp_standard.debug('l_ctl_rem_amt.chrg_acctd_amount_remaining('||l_index||'):'||
1130: l_ctl_rem_amt.chrg_acctd_amount_remaining(l_index));
1131:

Line 1129: arp_standard.debug('l_ctl_rem_amt.chrg_acctd_amount_remaining('||l_index||'):'||

1125: arp_standard.debug('l_ctl_rem_amt.customer_trx_line_id('||l_index||'):'||
1126: l_ctl_rem_amt.customer_trx_line_id(l_index));
1127: arp_standard.debug('l_ctl_rem_amt.chrg_amount_remaining('||l_index||'):'||
1128: l_ctl_rem_amt.chrg_amount_remaining(l_index));
1129: arp_standard.debug('l_ctl_rem_amt.chrg_acctd_amount_remaining('||l_index||'):'||
1130: l_ctl_rem_amt.chrg_acctd_amount_remaining(l_index));
1131:
1132: END IF;
1133: END IF;

Line 1239: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Reverse_Receipt_CM()-');

1235: END IF; --application type is CM
1236:
1237: END LOOP; -- reconciliation routine called for applications
1238:
1239: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Reverse_Receipt_CM()-');
1240:
1241: EXCEPTION
1242: WHEN NO_DATA_FOUND THEN
1243: arp_standard.debug('ARP_RECEIPTS_MAIN.Reverse_Receipt_CM - NO_DATA_FOUND' );

Line 1243: arp_standard.debug('ARP_RECEIPTS_MAIN.Reverse_Receipt_CM - NO_DATA_FOUND' );

1239: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Reverse_Receipt_CM()-');
1240:
1241: EXCEPTION
1242: WHEN NO_DATA_FOUND THEN
1243: arp_standard.debug('ARP_RECEIPTS_MAIN.Reverse_Receipt_CM - NO_DATA_FOUND' );
1244: RAISE;
1245:
1246: WHEN OTHERS THEN
1247: arp_standard.debug('EXCEPTION: ARP_RECEIPTS_MAIN.Reverse_Receipt_CM:'||SQLERRM);

Line 1247: arp_standard.debug('EXCEPTION: ARP_RECEIPTS_MAIN.Reverse_Receipt_CM:'||SQLERRM);

1243: arp_standard.debug('ARP_RECEIPTS_MAIN.Reverse_Receipt_CM - NO_DATA_FOUND' );
1244: RAISE;
1245:
1246: WHEN OTHERS THEN
1247: arp_standard.debug('EXCEPTION: ARP_RECEIPTS_MAIN.Reverse_Receipt_CM:'||SQLERRM);
1248: RAISE ;
1249:
1250: END Reverse_Receipt_CM;
1251:

Line 1310: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Get_Doc_Entitity_Data()+');

1306: l_return_status VARCHAR2(10);
1307: BEGIN
1308:
1309: IF PG_DEBUG in ('Y', 'C') THEN
1310: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Get_Doc_Entitity_Data()+');
1311: END IF;
1312:
1313: IF p_level = 'RA' then
1314:

Line 1677: p_internal_org_id => arp_standard.sysparm.org_id,

1673: p_validation_level => NULL,
1674: x_return_status => l_return_status,
1675: x_msg_count => l_msg_count,
1676: x_msg_data => l_msg_data,
1677: p_internal_org_id => arp_standard.sysparm.org_id,
1678: p_legal_entity_id => l_le_id,
1679: p_transaction_date => p_app_rec.apply_date,
1680: p_related_doc_date => NULL,
1681: p_adjusted_doc_date=> NULL,

Line 1763: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Get_Doc_Entitity_Data()-');

1759: p_vat_rec.tax_account_id := g_ae_doc_rec.gl_tax_acct; /* Bug fix 2300268 */
1760: END IF;
1761:
1762: IF PG_DEBUG in ('Y', 'C') THEN
1763: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Get_Doc_Entitity_Data()-');
1764: END IF;
1765:
1766: EXCEPTION
1767: WHEN ARP_ALLOCATION_PKG.flex_subs_ccid_error THEN

Line 1769: arp_standard.debug('ARP_RECEIPTS_MAIN.Get_Doc_Entitity_Data - flex_subs_ccid_error');

1765:
1766: EXCEPTION
1767: WHEN ARP_ALLOCATION_PKG.flex_subs_ccid_error THEN
1768: IF PG_DEBUG in ('Y', 'C') THEN
1769: arp_standard.debug('ARP_RECEIPTS_MAIN.Get_Doc_Entitity_Data - flex_subs_ccid_error');
1770: END IF;
1771: RAISE;
1772:
1773: WHEN NO_DATA_FOUND THEN

Line 1775: arp_standard.debug('ARP_RECEIPTS_MAIN.Get_Doc_Entitity_Data - NO_DATA_FOUND' );

1771: RAISE;
1772:
1773: WHEN NO_DATA_FOUND THEN
1774: IF PG_DEBUG in ('Y', 'C') THEN
1775: arp_standard.debug('ARP_RECEIPTS_MAIN.Get_Doc_Entitity_Data - NO_DATA_FOUND' );
1776: END IF;
1777: RAISE;
1778:
1779: WHEN OTHERS THEN

Line 1781: arp_standard.debug('EXCEPTION: ARP_RECEIPTS_MAIN.Get_Doc_Entitity_Data');

1777: RAISE;
1778:
1779: WHEN OTHERS THEN
1780: IF PG_DEBUG in ('Y', 'C') THEN
1781: arp_standard.debug('EXCEPTION: ARP_RECEIPTS_MAIN.Get_Doc_Entitity_Data');
1782: END IF;
1783: RAISE ;
1784:
1785: END Get_Doc_Entitity_Data;

Line 1812: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Act_Tax_Non_Rec_Ccid()+');

1808:
1809: BEGIN
1810:
1811: IF PG_DEBUG in ('Y', 'C') THEN
1812: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Act_Tax_Non_Rec_Ccid()+');
1813: END IF;
1814:
1815: /*--------------------------------------------------------+
1816: | Get non recoverable tax account for asset or liability |

Line 1856: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Act_Tax_Non_Rec_Ccid()+');

1852: p_act_tax_non_rec_ccid := NULL;
1853: END IF;
1854:
1855: IF PG_DEBUG in ('Y', 'C') THEN
1856: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Act_Tax_Non_Rec_Ccid()+');
1857: END IF;
1858:
1859: EXCEPTION
1860: /*-------------------------------------------------------------------+

Line 1866: arp_standard.debug('EXCEPTION: ARP_RECEIPTS_MAIN.Act_Tax_Non_Rec_Ccid - NO_DATA_FOUND');

1862: | null exception for no data found for non recoverable account. |
1863: +-------------------------------------------------------------------*/
1864: WHEN NO_DATA_FOUND THEN
1865: IF PG_DEBUG in ('Y', 'C') THEN
1866: arp_standard.debug('EXCEPTION: ARP_RECEIPTS_MAIN.Act_Tax_Non_Rec_Ccid - NO_DATA_FOUND');
1867: END IF;
1868: null;
1869:
1870: WHEN OTHERS THEN

Line 1872: arp_standard.debug('EXCEPTION: ARP_RECEIPTS_MAIN.Act_Tax_Non_Rec_Ccid');

1868: null;
1869:
1870: WHEN OTHERS THEN
1871: IF PG_DEBUG in ('Y', 'C') THEN
1872: arp_standard.debug('EXCEPTION: ARP_RECEIPTS_MAIN.Act_Tax_Non_Rec_Ccid');
1873: END IF;
1874: RAISE ;
1875:
1876: END Act_Tax_Non_Rec_Ccid;

Line 1913: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Create_Ae_Lines_Common()+');

1909: l_tmp_upg_method ra_customer_trx.upgrade_method%TYPE;
1910: BEGIN
1911:
1912: IF PG_DEBUG in ('Y', 'C') THEN
1913: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Create_Ae_Lines_Common()+');
1914: END IF;
1915:
1916: /*-------------------------------------------------------------+
1917: | Get Document Entitity specific data |

Line 2012: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Create_Ae_Lines_Common()-');

2008:
2009: END IF;
2010:
2011: IF PG_DEBUG in ('Y', 'C') THEN
2012: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Create_Ae_Lines_Common()-');
2013: END IF;
2014:
2015: EXCEPTION
2016: WHEN OTHERS THEN

Line 2018: arp_standard.debug('EXCEPTION: ARP_RECEIPTS_MAIN.Create_Ae_Lines_Common');

2014:
2015: EXCEPTION
2016: WHEN OTHERS THEN
2017: IF PG_DEBUG in ('Y', 'C') THEN
2018: arp_standard.debug('EXCEPTION: ARP_RECEIPTS_MAIN.Create_Ae_Lines_Common');
2019: END IF;
2020: RAISE;
2021:
2022: END Create_Ae_Lines_Common;

Line 2086: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Create_Ae_Lines_RA()+');

2082: --}
2083:
2084: BEGIN
2085: IF PG_DEBUG in ('Y', 'C') THEN
2086: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Create_Ae_Lines_RA()+');
2087: END IF;
2088:
2089:
2090: /*-------------------------------------------------------------------+

Line 2462: arp_standard.debug( 'Calling Assign_elements..inside R12_MERGE');

2458: OR ( p_cust_inv_rec.upgrade_method = 'R12_MERGE' AND
2459: nvl(l_def_tax_flag,'N') = 'N' ) THEN /* Added check from 0 amount applied */
2460: /*Bug fix 6721786 */
2461: IF PG_DEBUG in ('Y', 'C') THEN
2462: arp_standard.debug( 'Calling Assign_elements..inside R12_MERGE');
2463: END IF;
2464:
2465: /** will be stamping the ref_mf_dist_flag as D on all REC offset rows for discounts
2466: inorder to differentiate them from other REC rows in ARD.

Line 2477: arp_standard.debug('amount_applied is zero');

2473: -- Need to create detailed distributions even when amount_applied is zero
2474: IF nvl(p_cust_inv_rec.upgrade_method,'R12_NLB') in ('R12_NLB','R12','R12_11IMFAR')
2475: AND p_app_rec.amount_applied = 0 AND p_cust_inv_rec.drawee_site_use_id IS NULL THEN
2476: -- Invoice
2477: arp_standard.debug('amount_applied is zero');
2478: arp_standard.debug('Creating detailed distributions for invoice');
2479:
2480: l_ael_line_rec.ae_line_type := 'REC';
2481: l_ael_line_rec.ae_line_type_secondary := '';

Line 2478: arp_standard.debug('Creating detailed distributions for invoice');

2474: IF nvl(p_cust_inv_rec.upgrade_method,'R12_NLB') in ('R12_NLB','R12','R12_11IMFAR')
2475: AND p_app_rec.amount_applied = 0 AND p_cust_inv_rec.drawee_site_use_id IS NULL THEN
2476: -- Invoice
2477: arp_standard.debug('amount_applied is zero');
2478: arp_standard.debug('Creating detailed distributions for invoice');
2479:
2480: l_ael_line_rec.ae_line_type := 'REC';
2481: l_ael_line_rec.ae_line_type_secondary := '';
2482: l_ael_line_rec.entered_dr := 0;

Line 2531: arp_standard.debug('Creating detailed distributions for CM');

2527: End Loop;
2528:
2529: -- CM
2530: IF p_app_rec.application_type = 'CM' THEN
2531: arp_standard.debug('Creating detailed distributions for CM');
2532:
2533: l_ael_line_rec.ae_line_type := 'REC';
2534: l_ael_line_rec.ae_line_type_secondary := '';
2535: l_ael_line_rec.entered_dr := NULL;

Line 2786: | event is seperate from the creation of the application, for standard |

2782: ELSE
2783: /*-----------------------------------------------------------------------+
2784: | do not call the Tax accounting to move deferred tax this happens when |
2785: | the Bills Receivable Housekeeper determines that the maturity date |
2786: | event is seperate from the creation of the application, for standard |
2787: | Remittance and Factored (with Recourse) we need to update the link id |
2788: | so the last Transaction History Record must be Standard Remitted or |
2789: | pending risk elimination |
2790: +-----------------------------------------------------------------------*/

Line 2788: | so the last Transaction History Record must be Standard Remitted or |

2784: | do not call the Tax accounting to move deferred tax this happens when |
2785: | the Bills Receivable Housekeeper determines that the maturity date |
2786: | event is seperate from the creation of the application, for standard |
2787: | Remittance and Factored (with Recourse) we need to update the link id |
2788: | so the last Transaction History Record must be Standard Remitted or |
2789: | pending risk elimination |
2790: +-----------------------------------------------------------------------*/
2791: update ar_receivable_applications
2792: set link_to_trx_hist_id = (select max(th.transaction_history_id)

Line 2809: --because of standards and that the User Hook could override accounting

2805:
2806: FOR l_ctr IN l_ae_line_tbl.FIRST .. l_ae_line_tbl.LAST LOOP
2807:
2808: --It is necessary to populate the record and then call assign elements
2809: --because of standards and that the User Hook could override accounting
2810: --so need to populate this record (rather than direct table assignments)
2811:
2812: l_ael_line_rec := l_empty_ael_line_rec;
2813: l_ael_line_rec := l_ae_line_tbl(l_ctr);

Line 2827: arp_standard.debug( 'p_cust_cm_rec.upgrade_method '||p_cust_cm_rec.upgrade_method);

2823:
2824: END IF; --receipt aplication and discounts or payment is non zero move deferred tax
2825:
2826: IF PG_DEBUG in ('Y', 'C') THEN
2827: arp_standard.debug( 'p_cust_cm_rec.upgrade_method '||p_cust_cm_rec.upgrade_method);
2828: END IF;
2829:
2830: --deferred tax check
2831: IF p_cust_cm_rec.upgrade_method = 'R12_MERGE' THEN

Line 2940: --because of standards and that the User Hook could override accounting

2936:
2937: FOR l_ctr IN l_ae_line_tbl.FIRST .. l_ae_line_tbl.LAST LOOP
2938:
2939: --It is necessary to populate the record and then call assign elements
2940: --because of standards and that the User Hook could override accounting
2941: --so need to populate this record (rather than direct table assignments)
2942:
2943: l_ael_line_rec := l_empty_ael_line_rec;
2944: l_ael_line_rec := l_ae_line_tbl(l_ctr);

Line 2994: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Create_Ae_Lines_RA()-');

2990:
2991: END IF; -- reconciliation routine called for applications only
2992:
2993: IF PG_DEBUG in ('Y', 'C') THEN
2994: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Create_Ae_Lines_RA()-');
2995: END IF;
2996:
2997: EXCEPTION
2998: WHEN ARP_ALLOCATION_PKG.invalid_allocation_base THEN

Line 3000: arp_standard.debug('ARP_RECEIPTS_MAIN.Create_Ae_Lines_RA - invalid_rule_error');

2996:
2997: EXCEPTION
2998: WHEN ARP_ALLOCATION_PKG.invalid_allocation_base THEN
2999: IF PG_DEBUG in ('Y', 'C') THEN
3000: arp_standard.debug('ARP_RECEIPTS_MAIN.Create_Ae_Lines_RA - invalid_rule_error');
3001: END IF;
3002: fnd_message.set_name('AR','AR_INVALID_ACTIVITY');
3003: RAISE;
3004:

Line 3007: arp_standard.debug('ARP_RECEIPTS_MAIN.Create_Ae_Lines_RA - NO_DATA_FOUND' );

3003: RAISE;
3004:
3005: WHEN NO_DATA_FOUND THEN
3006: IF PG_DEBUG in ('Y', 'C') THEN
3007: arp_standard.debug('ARP_RECEIPTS_MAIN.Create_Ae_Lines_RA - NO_DATA_FOUND' );
3008: END IF;
3009: RAISE;
3010:
3011: WHEN OTHERS THEN

Line 3013: arp_standard.debug('EXCEPTION: ARP_RECEIPTS_MAIN.Create_Ae_Lines_RA');

3009: RAISE;
3010:
3011: WHEN OTHERS THEN
3012: IF PG_DEBUG in ('Y', 'C') THEN
3013: arp_standard.debug('EXCEPTION: ARP_RECEIPTS_MAIN.Create_Ae_Lines_RA');
3014: END IF;
3015: RAISE;
3016:
3017: END Create_Ae_Lines_RA;

Line 3105: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Create_Ae_Lines_MCD()+');

3101: l_min_acct_unit NUMBER := 0;
3102: /* end of bug 2494858 */
3103: BEGIN
3104: IF PG_DEBUG in ('Y', 'C') THEN
3105: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Create_Ae_Lines_MCD()+');
3106: END IF;
3107:
3108: /* Added the next two statements for bug 2494858 */
3109: l_rounding_rule := arp_standard.sysparm.tax_rounding_rule;

Line 3109: l_rounding_rule := arp_standard.sysparm.tax_rounding_rule;

3105: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Create_Ae_Lines_MCD()+');
3106: END IF;
3107:
3108: /* Added the next two statements for bug 2494858 */
3109: l_rounding_rule := arp_standard.sysparm.tax_rounding_rule;
3110: fnd_currency.get_info(p_cr_rec.currency_code,l_precision,l_extended_precision,l_min_acct_unit);
3111:
3112:
3113: /*-------------------------------------------------------------+

Line 3352: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Create_Ae_Lines_MCD()-');

3348:
3349: END IF;
3350:
3351: IF PG_DEBUG in ('Y', 'C') THEN
3352: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Create_Ae_Lines_MCD()-');
3353: END IF;
3354:
3355: EXCEPTION
3356:

Line 3359: arp_standard.debug('ARP_RECEIPTS_MAIN.Create_Ae_Lines_MCD - NO_DATA_FOUND' );

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

Line 3365: arp_standard.debug('EXCEPTION: ARP_RECEIPTS_MAIN.Create_Ae_Lines_MCD');

3361: RAISE;
3362:
3363: WHEN OTHERS THEN
3364: IF PG_DEBUG in ('Y', 'C') THEN
3365: arp_standard.debug('EXCEPTION: ARP_RECEIPTS_MAIN.Create_Ae_Lines_MCD');
3366: END IF;
3367: RAISE;
3368:
3369: END Create_Ae_Lines_MCD;

Line 3401: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Assign_Ael_Elements()+');

3397:
3398: BEGIN
3399: arp_global.init_global; --bug6024475
3400: IF PG_DEBUG in ('Y', 'C') THEN
3401: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Assign_Ael_Elements()+');
3402: END IF;
3403:
3404: /*------------------------------------------------------+
3405: | Call Hook to Override Account |

Line 3513: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Assign_Ael_Elements()-');

3509: g_ae_line_tbl(g_ae_line_ctr).from_acctd_amount_dr := p_ae_line_rec.from_acctd_amount_dr;
3510: g_ae_line_tbl(g_ae_line_ctr).from_acctd_amount_cr := p_ae_line_rec.from_acctd_amount_cr;
3511: --}
3512: IF PG_DEBUG in ('Y', 'C') THEN
3513: arp_standard.debug( 'ARP_RECEIPTS_MAIN.Assign_Ael_Elements()-');
3514: END IF;
3515:
3516: EXCEPTION
3517: /*bug 6024475 adds a new exception.*/

Line 3520: arp_standard.debug('Invalid Account ccid - ARP_RECEIPTS_MAIN.Assign_Ael_Elements' );

3516: EXCEPTION
3517: /*bug 6024475 adds a new exception.*/
3518: WHEN invalid_ccid_error THEN
3519: IF PG_DEBUG in ('Y', 'C') THEN
3520: arp_standard.debug('Invalid Account ccid - ARP_RECEIPTS_MAIN.Assign_Ael_Elements' );
3521: END IF;
3522: fnd_message.set_name('AR','AR_INVALID_ACCOUNT');
3523: RAISE;
3524: /* bug6024475 end*/

Line 3527: arp_standard.debug('EXCEPTION: ARP_RECEIPTS_MAIN.Assign_Ael_Elements');

3523: RAISE;
3524: /* bug6024475 end*/
3525: WHEN OTHERS THEN
3526: IF PG_DEBUG in ('Y', 'C') THEN
3527: arp_standard.debug('EXCEPTION: ARP_RECEIPTS_MAIN.Assign_Ael_Elements');
3528: END IF;
3529: RAISE;
3530:
3531: END Assign_Ael_Elements;

Line 3541: arp_standard.debug('ctl_id_index+');

3537: IS
3538: result NUMBER;
3539: cnt NUMBER := 0;
3540: BEGIN
3541: arp_standard.debug('ctl_id_index+');
3542: result := -1;
3543: cnt := p_ctl_id_tab.COUNT;
3544: IF cnt > 0 THEN
3545: FOR i IN p_ctl_id_tab.FIRST .. p_ctl_id_tab.LAST LOOP

Line 3557: arp_standard.debug(' result index:'||result);

3553: END IF;
3554: IF result = -1 THEN
3555: result := cnt + 1;
3556: END IF;
3557: arp_standard.debug(' result index:'||result);
3558: arp_standard.debug('ctl_id_index-');
3559: RETURN result;
3560: END;
3561:

Line 3558: arp_standard.debug('ctl_id_index-');

3554: IF result = -1 THEN
3555: result := cnt + 1;
3556: END IF;
3557: arp_standard.debug(' result index:'||result);
3558: arp_standard.debug('ctl_id_index-');
3559: RETURN result;
3560: END;
3561:
3562: PROCEDURE init_rem_amt(x_rem_amt IN OUT NOCOPY ctl_rem_amt_type,