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

Line 386: arp_standard.debug('arp_process_receipts.update_cash_receipt()+');

382: --}
383: BEGIN
384:
385: IF PG_DEBUG in ('Y', 'C') THEN
386: arp_standard.debug('arp_process_receipts.update_cash_receipt()+');
387: END IF;
388:
389: -- --------------------------------------------------------------
390: -- First fetch and lock existing records from database for update

Line 470: arp_standard.debug('update_cash_receipt: ' || 'l_cr_amount_changed_flag = TRUE');

466: IF (p_amount <> l_cr_rec.amount)
467: THEN
468: l_cr_amount_changed_flag := TRUE;
469: IF PG_DEBUG in ('Y', 'C') THEN
470: arp_standard.debug('update_cash_receipt: ' || 'l_cr_amount_changed_flag = TRUE');
471: END IF;
472: END IF;
473:
474: -- check if the gl date of the receipt is still valid

Line 477: arp_standard.debug('update_cash_receipt: ' || 'P_GL_DATE is:' || to_char(p_gl_date, 'DD-MM-YYYY:HH:SS'));

473:
474: -- check if the gl date of the receipt is still valid
475:
476: IF PG_DEBUG in ('Y', 'C') THEN
477: arp_standard.debug('update_cash_receipt: ' || 'P_GL_DATE is:' || to_char(p_gl_date, 'DD-MM-YYYY:HH:SS'));
478: arp_standard.debug('update_cash_receipt: ' || 'l_valid_gl_date is:' || to_char(l_valid_gl_date, 'DD-MM-YYYY:HH:SS'));
479: END IF;
480:
481: IF (p_gl_date <> l_valid_gl_date)

Line 478: arp_standard.debug('update_cash_receipt: ' || 'l_valid_gl_date is:' || to_char(l_valid_gl_date, 'DD-MM-YYYY:HH:SS'));

474: -- check if the gl date of the receipt is still valid
475:
476: IF PG_DEBUG in ('Y', 'C') THEN
477: arp_standard.debug('update_cash_receipt: ' || 'P_GL_DATE is:' || to_char(p_gl_date, 'DD-MM-YYYY:HH:SS'));
478: arp_standard.debug('update_cash_receipt: ' || 'l_valid_gl_date is:' || to_char(l_valid_gl_date, 'DD-MM-YYYY:HH:SS'));
479: END IF;
480:
481: IF (p_gl_date <> l_valid_gl_date)
482: THEN

Line 485: arp_standard.debug('update_cash_receipt: ' || 'l_crh_rec_gl_date_changed = TRUE');

481: IF (p_gl_date <> l_valid_gl_date)
482: THEN
483: l_crh_rec_gl_date_changed := TRUE;
484: IF PG_DEBUG in ('Y', 'C') THEN
485: arp_standard.debug('update_cash_receipt: ' || 'l_crh_rec_gl_date_changed = TRUE');
486: END IF;
487: END IF;
488:
489:

Line 497: arp_standard.debug('update_cash_receipt: ' || 'l_crh_fda_changed_flag = TRUE');

493: NVL(l_crh_rec.factor_discount_amount,0))
494: THEN
495: l_crh_fda_changed_flag := TRUE;
496: IF PG_DEBUG in ('Y', 'C') THEN
497: arp_standard.debug('update_cash_receipt: ' || 'l_crh_fda_changed_flag = TRUE');
498: END IF;
499:
500: END IF;
501:

Line 508: arp_standard.debug('update_cash_receipt: ' || 'l_crh_rec_posted_flag = TRUE');

504: IF (l_crh_rec.posting_control_id <> -3)
505: THEN
506: l_crh_rec_posted_flag := TRUE;
507: IF PG_DEBUG in ('Y', 'C') THEN
508: arp_standard.debug('update_cash_receipt: ' || 'l_crh_rec_posted_flag = TRUE');
509: END IF;
510: END IF;
511:
512: -- check if receipt was identified (UNID -> UNAPP)

Line 519: arp_standard.debug('update_cash_receipt: ' || 'l_rct_identified_flag = TRUE');

515: p_pay_from_customer IS NOT NULL)
516: THEN
517: l_rct_identified_flag := TRUE;
518: IF PG_DEBUG in ('Y', 'C') THEN
519: arp_standard.debug('update_cash_receipt: ' || 'l_rct_identified_flag = TRUE');
520: END IF;
521: END IF;
522:
523: -- check if receipt was "un-identified" (UNAPP -> UNID)

Line 530: arp_standard.debug('update_cash_receipt: ' || 'l_rct_unidentified_flag = TRUE');

526: p_pay_from_customer IS NULL)
527: THEN
528: l_rct_unidentified_flag := TRUE;
529: IF PG_DEBUG in ('Y', 'C') THEN
530: arp_standard.debug('update_cash_receipt: ' || 'l_rct_unidentified_flag = TRUE');
531: END IF;
532: END IF;
533:
534: -- -------------------------------------------------------------

Line 661: arp_standard.debug('update_cash_receipt: ' || 'p_amount = '|| to_char(p_amount));

657: l_crh_acctd_fda_delta := nvl(l_crh_acctd_fda_new,0) -
658: nvl(l_crh_rec.acctd_factor_discount_amount,0);
659:
660: IF PG_DEBUG in ('Y', 'C') THEN
661: arp_standard.debug('update_cash_receipt: ' || 'p_amount = '|| to_char(p_amount));
662: arp_standard.debug('update_cash_receipt: ' || 'l_crh_amount_new = '|| to_char(l_crh_amount_new));
663: arp_standard.debug('update_cash_receipt: ' || 'l_crh_acctd_amount_new = '|| to_char(l_crh_acctd_amount_new));
664: END IF;
665:

Line 662: arp_standard.debug('update_cash_receipt: ' || 'l_crh_amount_new = '|| to_char(l_crh_amount_new));

658: nvl(l_crh_rec.acctd_factor_discount_amount,0);
659:
660: IF PG_DEBUG in ('Y', 'C') THEN
661: arp_standard.debug('update_cash_receipt: ' || 'p_amount = '|| to_char(p_amount));
662: arp_standard.debug('update_cash_receipt: ' || 'l_crh_amount_new = '|| to_char(l_crh_amount_new));
663: arp_standard.debug('update_cash_receipt: ' || 'l_crh_acctd_amount_new = '|| to_char(l_crh_acctd_amount_new));
664: END IF;
665:
666: -- -------------------------------------------------------------

Line 663: arp_standard.debug('update_cash_receipt: ' || 'l_crh_acctd_amount_new = '|| to_char(l_crh_acctd_amount_new));

659:
660: IF PG_DEBUG in ('Y', 'C') THEN
661: arp_standard.debug('update_cash_receipt: ' || 'p_amount = '|| to_char(p_amount));
662: arp_standard.debug('update_cash_receipt: ' || 'l_crh_amount_new = '|| to_char(l_crh_amount_new));
663: arp_standard.debug('update_cash_receipt: ' || 'l_crh_acctd_amount_new = '|| to_char(l_crh_acctd_amount_new));
664: END IF;
665:
666: -- -------------------------------------------------------------
667: -- handle changes in rct identification status

Line 886: arp_standard.debug('update_cash_receipt: ' || 'l_ps_rec.amount_due_remaining: ' || to_char(l_ps_rec.amount_due_remaining));

882: -- and subtract (since adr is negative) the difference between
883: -- the new receipt amount and the old receipt amount.
884:
885: IF PG_DEBUG in ('Y', 'C') THEN
886: arp_standard.debug('update_cash_receipt: ' || 'l_ps_rec.amount_due_remaining: ' || to_char(l_ps_rec.amount_due_remaining));
887: arp_standard.debug('update_cash_receipt: ' || 'p_amount: ' || to_char(p_amount));
888: arp_standard.debug('update_cash_receipt: ' || 'l_cr_rec.amount: ' || to_char(l_cr_rec.amount));
889: arp_standard.debug('update_cash_receipt: ' || 'l_cr_acctd_amount_delta: ' || to_char(l_cr_acctd_amount_delta));
890: END IF;

Line 887: arp_standard.debug('update_cash_receipt: ' || 'p_amount: ' || to_char(p_amount));

883: -- the new receipt amount and the old receipt amount.
884:
885: IF PG_DEBUG in ('Y', 'C') THEN
886: arp_standard.debug('update_cash_receipt: ' || 'l_ps_rec.amount_due_remaining: ' || to_char(l_ps_rec.amount_due_remaining));
887: arp_standard.debug('update_cash_receipt: ' || 'p_amount: ' || to_char(p_amount));
888: arp_standard.debug('update_cash_receipt: ' || 'l_cr_rec.amount: ' || to_char(l_cr_rec.amount));
889: arp_standard.debug('update_cash_receipt: ' || 'l_cr_acctd_amount_delta: ' || to_char(l_cr_acctd_amount_delta));
890: END IF;
891:

Line 888: arp_standard.debug('update_cash_receipt: ' || 'l_cr_rec.amount: ' || to_char(l_cr_rec.amount));

884:
885: IF PG_DEBUG in ('Y', 'C') THEN
886: arp_standard.debug('update_cash_receipt: ' || 'l_ps_rec.amount_due_remaining: ' || to_char(l_ps_rec.amount_due_remaining));
887: arp_standard.debug('update_cash_receipt: ' || 'p_amount: ' || to_char(p_amount));
888: arp_standard.debug('update_cash_receipt: ' || 'l_cr_rec.amount: ' || to_char(l_cr_rec.amount));
889: arp_standard.debug('update_cash_receipt: ' || 'l_cr_acctd_amount_delta: ' || to_char(l_cr_acctd_amount_delta));
890: END IF;
891:
892: l_ps_rec.amount_due_remaining :=

Line 889: arp_standard.debug('update_cash_receipt: ' || 'l_cr_acctd_amount_delta: ' || to_char(l_cr_acctd_amount_delta));

885: IF PG_DEBUG in ('Y', 'C') THEN
886: arp_standard.debug('update_cash_receipt: ' || 'l_ps_rec.amount_due_remaining: ' || to_char(l_ps_rec.amount_due_remaining));
887: arp_standard.debug('update_cash_receipt: ' || 'p_amount: ' || to_char(p_amount));
888: arp_standard.debug('update_cash_receipt: ' || 'l_cr_rec.amount: ' || to_char(l_cr_rec.amount));
889: arp_standard.debug('update_cash_receipt: ' || 'l_cr_acctd_amount_delta: ' || to_char(l_cr_acctd_amount_delta));
890: END IF;
891:
892: l_ps_rec.amount_due_remaining :=
893: l_ps_rec.amount_due_remaining -

Line 901: arp_standard.debug('update_cash_receipt: ' || 'l_ps_rec.amount_due_remaining: ' || to_char(l_ps_rec.amount_due_remaining));

897: l_ps_rec.acctd_amount_due_remaining -
898: l_cr_acctd_amount_delta;
899:
900: IF PG_DEBUG in ('Y', 'C') THEN
901: arp_standard.debug('update_cash_receipt: ' || 'l_ps_rec.amount_due_remaining: ' || to_char(l_ps_rec.amount_due_remaining));
902: arp_standard.debug('update_cash_receipt: ' || 'l_ps_rec.acctd_amount_due_remaining: ' || to_char(l_ps_rec.acctd_amount_due_remaining));
903: END IF;
904:
905: l_ps_rec.amount_due_original := -p_amount;

Line 902: arp_standard.debug('update_cash_receipt: ' || 'l_ps_rec.acctd_amount_due_remaining: ' || to_char(l_ps_rec.acctd_amount_due_remaining));

898: l_cr_acctd_amount_delta;
899:
900: IF PG_DEBUG in ('Y', 'C') THEN
901: arp_standard.debug('update_cash_receipt: ' || 'l_ps_rec.amount_due_remaining: ' || to_char(l_ps_rec.amount_due_remaining));
902: arp_standard.debug('update_cash_receipt: ' || 'l_ps_rec.acctd_amount_due_remaining: ' || to_char(l_ps_rec.acctd_amount_due_remaining));
903: END IF;
904:
905: l_ps_rec.amount_due_original := -p_amount;
906:

Line 954: arp_standard.debug('update_cash_receipt: '||'l_dist_row_on_current_crh : '||l_dist_row_on_current_crh);

950: WHEN no_data_found THEN
951: l_dist_row_on_current_crh := 'N';
952: END;
953: IF PG_DEBUG in ('Y', 'C') THEN
954: arp_standard.debug('update_cash_receipt: '||'l_dist_row_on_current_crh : '||l_dist_row_on_current_crh);
955: END IF;
956: IF l_dist_row_on_current_crh = 'Y' THEN
957: arp_proc_rct_util.update_dist_rec(
958: l_crh_rec.cash_receipt_history_id,

Line 964: arp_standard.debug('update_cash_receipt: ' || 'l_crh_amount_delta : ' || to_char(l_crh_amount_delta));

960: l_crh_amount_new - l_crh_rec.amount,
961: l_crh_acctd_amount_new - l_crh_rec.acctd_amount);
962: ELSE
963: IF PG_DEBUG in ('Y', 'C') THEN
964: arp_standard.debug('update_cash_receipt: ' || 'l_crh_amount_delta : ' || to_char(l_crh_amount_delta));
965: arp_standard.debug('update_cash_receipt: ' || 'l_crh_acctd_amount_delta : ' || to_char(l_crh_acctd_amount_delta));
966: arp_standard.debug('update_cash_receipt: ' || 'cash_receipt_history_id : ' || to_char(l_crh_rec.cash_receipt_history_id));
967: arp_standard.debug('update_cash_receipt: ' || 'l_source_type : ' || l_source_type);
968: arp_standard.debug('update_cash_receipt: ' || 'l_crh_ccid : ' || l_crh_ccid);

Line 965: arp_standard.debug('update_cash_receipt: ' || 'l_crh_acctd_amount_delta : ' || to_char(l_crh_acctd_amount_delta));

961: l_crh_acctd_amount_new - l_crh_rec.acctd_amount);
962: ELSE
963: IF PG_DEBUG in ('Y', 'C') THEN
964: arp_standard.debug('update_cash_receipt: ' || 'l_crh_amount_delta : ' || to_char(l_crh_amount_delta));
965: arp_standard.debug('update_cash_receipt: ' || 'l_crh_acctd_amount_delta : ' || to_char(l_crh_acctd_amount_delta));
966: arp_standard.debug('update_cash_receipt: ' || 'cash_receipt_history_id : ' || to_char(l_crh_rec.cash_receipt_history_id));
967: arp_standard.debug('update_cash_receipt: ' || 'l_source_type : ' || l_source_type);
968: arp_standard.debug('update_cash_receipt: ' || 'l_crh_ccid : ' || l_crh_ccid);
969: END IF;

Line 966: arp_standard.debug('update_cash_receipt: ' || 'cash_receipt_history_id : ' || to_char(l_crh_rec.cash_receipt_history_id));

962: ELSE
963: IF PG_DEBUG in ('Y', 'C') THEN
964: arp_standard.debug('update_cash_receipt: ' || 'l_crh_amount_delta : ' || to_char(l_crh_amount_delta));
965: arp_standard.debug('update_cash_receipt: ' || 'l_crh_acctd_amount_delta : ' || to_char(l_crh_acctd_amount_delta));
966: arp_standard.debug('update_cash_receipt: ' || 'cash_receipt_history_id : ' || to_char(l_crh_rec.cash_receipt_history_id));
967: arp_standard.debug('update_cash_receipt: ' || 'l_source_type : ' || l_source_type);
968: arp_standard.debug('update_cash_receipt: ' || 'l_crh_ccid : ' || l_crh_ccid);
969: END IF;
970:

Line 967: arp_standard.debug('update_cash_receipt: ' || 'l_source_type : ' || l_source_type);

963: IF PG_DEBUG in ('Y', 'C') THEN
964: arp_standard.debug('update_cash_receipt: ' || 'l_crh_amount_delta : ' || to_char(l_crh_amount_delta));
965: arp_standard.debug('update_cash_receipt: ' || 'l_crh_acctd_amount_delta : ' || to_char(l_crh_acctd_amount_delta));
966: arp_standard.debug('update_cash_receipt: ' || 'cash_receipt_history_id : ' || to_char(l_crh_rec.cash_receipt_history_id));
967: arp_standard.debug('update_cash_receipt: ' || 'l_source_type : ' || l_source_type);
968: arp_standard.debug('update_cash_receipt: ' || 'l_crh_ccid : ' || l_crh_ccid);
969: END IF;
970:
971: arp_proc_rct_util.insert_dist_rec(l_crh_amount_delta,

Line 968: arp_standard.debug('update_cash_receipt: ' || 'l_crh_ccid : ' || l_crh_ccid);

964: arp_standard.debug('update_cash_receipt: ' || 'l_crh_amount_delta : ' || to_char(l_crh_amount_delta));
965: arp_standard.debug('update_cash_receipt: ' || 'l_crh_acctd_amount_delta : ' || to_char(l_crh_acctd_amount_delta));
966: arp_standard.debug('update_cash_receipt: ' || 'cash_receipt_history_id : ' || to_char(l_crh_rec.cash_receipt_history_id));
967: arp_standard.debug('update_cash_receipt: ' || 'l_source_type : ' || l_source_type);
968: arp_standard.debug('update_cash_receipt: ' || 'l_crh_ccid : ' || l_crh_ccid);
969: END IF;
970:
971: arp_proc_rct_util.insert_dist_rec(l_crh_amount_delta,
972: l_crh_acctd_amount_delta,

Line 1074: arp_standard.debug('update_cash_receipt: ' || 'p_factor_discount_amount: ' || to_char(p_factor_discount_amount));

1070: and dis.source_table = 'CRH'
1071: and dis.source_type = 'BANK_CHARGES';
1072:
1073: IF PG_DEBUG in ('Y', 'C') THEN
1074: arp_standard.debug('update_cash_receipt: ' || 'p_factor_discount_amount: ' || to_char(p_factor_discount_amount));
1075: arp_standard.debug('update_cash_receipt: ' || 'l_sum_fda_debits : ' || to_char(l_sum_fda_debits));
1076: arp_standard.debug('update_cash_receipt: ' || 'l_sum_fda_credits: ' || to_char(l_sum_fda_credits));
1077: arp_standard.debug('update_cash_receipt: ' || 'l_sum_acctd_fda_debits: ' || to_char(l_sum_acctd_fda_debits));
1078: arp_standard.debug('update_cash_receipt: ' || 'l_sum_acctd_fda_credits: ' || to_char(l_sum_acctd_fda_credits));

Line 1075: arp_standard.debug('update_cash_receipt: ' || 'l_sum_fda_debits : ' || to_char(l_sum_fda_debits));

1071: and dis.source_type = 'BANK_CHARGES';
1072:
1073: IF PG_DEBUG in ('Y', 'C') THEN
1074: arp_standard.debug('update_cash_receipt: ' || 'p_factor_discount_amount: ' || to_char(p_factor_discount_amount));
1075: arp_standard.debug('update_cash_receipt: ' || 'l_sum_fda_debits : ' || to_char(l_sum_fda_debits));
1076: arp_standard.debug('update_cash_receipt: ' || 'l_sum_fda_credits: ' || to_char(l_sum_fda_credits));
1077: arp_standard.debug('update_cash_receipt: ' || 'l_sum_acctd_fda_debits: ' || to_char(l_sum_acctd_fda_debits));
1078: arp_standard.debug('update_cash_receipt: ' || 'l_sum_acctd_fda_credits: ' || to_char(l_sum_acctd_fda_credits));
1079: END IF;

Line 1076: arp_standard.debug('update_cash_receipt: ' || 'l_sum_fda_credits: ' || to_char(l_sum_fda_credits));

1072:
1073: IF PG_DEBUG in ('Y', 'C') THEN
1074: arp_standard.debug('update_cash_receipt: ' || 'p_factor_discount_amount: ' || to_char(p_factor_discount_amount));
1075: arp_standard.debug('update_cash_receipt: ' || 'l_sum_fda_debits : ' || to_char(l_sum_fda_debits));
1076: arp_standard.debug('update_cash_receipt: ' || 'l_sum_fda_credits: ' || to_char(l_sum_fda_credits));
1077: arp_standard.debug('update_cash_receipt: ' || 'l_sum_acctd_fda_debits: ' || to_char(l_sum_acctd_fda_debits));
1078: arp_standard.debug('update_cash_receipt: ' || 'l_sum_acctd_fda_credits: ' || to_char(l_sum_acctd_fda_credits));
1079: END IF;
1080:

Line 1077: arp_standard.debug('update_cash_receipt: ' || 'l_sum_acctd_fda_debits: ' || to_char(l_sum_acctd_fda_debits));

1073: IF PG_DEBUG in ('Y', 'C') THEN
1074: arp_standard.debug('update_cash_receipt: ' || 'p_factor_discount_amount: ' || to_char(p_factor_discount_amount));
1075: arp_standard.debug('update_cash_receipt: ' || 'l_sum_fda_debits : ' || to_char(l_sum_fda_debits));
1076: arp_standard.debug('update_cash_receipt: ' || 'l_sum_fda_credits: ' || to_char(l_sum_fda_credits));
1077: arp_standard.debug('update_cash_receipt: ' || 'l_sum_acctd_fda_debits: ' || to_char(l_sum_acctd_fda_debits));
1078: arp_standard.debug('update_cash_receipt: ' || 'l_sum_acctd_fda_credits: ' || to_char(l_sum_acctd_fda_credits));
1079: END IF;
1080:
1081: -- Positive result will create a DR entry, negative a CR entry.

Line 1078: arp_standard.debug('update_cash_receipt: ' || 'l_sum_acctd_fda_credits: ' || to_char(l_sum_acctd_fda_credits));

1074: arp_standard.debug('update_cash_receipt: ' || 'p_factor_discount_amount: ' || to_char(p_factor_discount_amount));
1075: arp_standard.debug('update_cash_receipt: ' || 'l_sum_fda_debits : ' || to_char(l_sum_fda_debits));
1076: arp_standard.debug('update_cash_receipt: ' || 'l_sum_fda_credits: ' || to_char(l_sum_fda_credits));
1077: arp_standard.debug('update_cash_receipt: ' || 'l_sum_acctd_fda_debits: ' || to_char(l_sum_acctd_fda_debits));
1078: arp_standard.debug('update_cash_receipt: ' || 'l_sum_acctd_fda_credits: ' || to_char(l_sum_acctd_fda_credits));
1079: END IF;
1080:
1081: -- Positive result will create a DR entry, negative a CR entry.
1082:

Line 1183: arp_standard.debug('update_cash_receipt: ' || 'l_crh_amount_delta : ' || to_char(l_crh_amount_delta));

1179:
1180: IF (l_crh_amount_delta <> 0) THEN
1181:
1182: IF PG_DEBUG in ('Y', 'C') THEN
1183: arp_standard.debug('update_cash_receipt: ' || 'l_crh_amount_delta : ' || to_char(l_crh_amount_delta));
1184: arp_standard.debug('update_cash_receipt: ' || 'l_crh_acctd_amount_delta : ' || to_char(l_crh_acctd_amount_delta));
1185: arp_standard.debug('update_cash_receipt: ' || 'cash_receipt_history_id : ' || to_char(l_crh_rec.cash_receipt_history_id));
1186: arp_standard.debug('update_cash_receipt: ' || 'l_source_type : ' || l_source_type);
1187: arp_standard.debug('update_cash_receipt: ' || 'l_crh_ccid : ' || l_crh_ccid);

Line 1184: arp_standard.debug('update_cash_receipt: ' || 'l_crh_acctd_amount_delta : ' || to_char(l_crh_acctd_amount_delta));

1180: IF (l_crh_amount_delta <> 0) THEN
1181:
1182: IF PG_DEBUG in ('Y', 'C') THEN
1183: arp_standard.debug('update_cash_receipt: ' || 'l_crh_amount_delta : ' || to_char(l_crh_amount_delta));
1184: arp_standard.debug('update_cash_receipt: ' || 'l_crh_acctd_amount_delta : ' || to_char(l_crh_acctd_amount_delta));
1185: arp_standard.debug('update_cash_receipt: ' || 'cash_receipt_history_id : ' || to_char(l_crh_rec.cash_receipt_history_id));
1186: arp_standard.debug('update_cash_receipt: ' || 'l_source_type : ' || l_source_type);
1187: arp_standard.debug('update_cash_receipt: ' || 'l_crh_ccid : ' || l_crh_ccid);
1188: END IF;

Line 1185: arp_standard.debug('update_cash_receipt: ' || 'cash_receipt_history_id : ' || to_char(l_crh_rec.cash_receipt_history_id));

1181:
1182: IF PG_DEBUG in ('Y', 'C') THEN
1183: arp_standard.debug('update_cash_receipt: ' || 'l_crh_amount_delta : ' || to_char(l_crh_amount_delta));
1184: arp_standard.debug('update_cash_receipt: ' || 'l_crh_acctd_amount_delta : ' || to_char(l_crh_acctd_amount_delta));
1185: arp_standard.debug('update_cash_receipt: ' || 'cash_receipt_history_id : ' || to_char(l_crh_rec.cash_receipt_history_id));
1186: arp_standard.debug('update_cash_receipt: ' || 'l_source_type : ' || l_source_type);
1187: arp_standard.debug('update_cash_receipt: ' || 'l_crh_ccid : ' || l_crh_ccid);
1188: END IF;
1189:

Line 1186: arp_standard.debug('update_cash_receipt: ' || 'l_source_type : ' || l_source_type);

1182: IF PG_DEBUG in ('Y', 'C') THEN
1183: arp_standard.debug('update_cash_receipt: ' || 'l_crh_amount_delta : ' || to_char(l_crh_amount_delta));
1184: arp_standard.debug('update_cash_receipt: ' || 'l_crh_acctd_amount_delta : ' || to_char(l_crh_acctd_amount_delta));
1185: arp_standard.debug('update_cash_receipt: ' || 'cash_receipt_history_id : ' || to_char(l_crh_rec.cash_receipt_history_id));
1186: arp_standard.debug('update_cash_receipt: ' || 'l_source_type : ' || l_source_type);
1187: arp_standard.debug('update_cash_receipt: ' || 'l_crh_ccid : ' || l_crh_ccid);
1188: END IF;
1189:
1190: arp_proc_rct_util.insert_dist_rec(l_crh_amount_delta,

Line 1187: arp_standard.debug('update_cash_receipt: ' || 'l_crh_ccid : ' || l_crh_ccid);

1183: arp_standard.debug('update_cash_receipt: ' || 'l_crh_amount_delta : ' || to_char(l_crh_amount_delta));
1184: arp_standard.debug('update_cash_receipt: ' || 'l_crh_acctd_amount_delta : ' || to_char(l_crh_acctd_amount_delta));
1185: arp_standard.debug('update_cash_receipt: ' || 'cash_receipt_history_id : ' || to_char(l_crh_rec.cash_receipt_history_id));
1186: arp_standard.debug('update_cash_receipt: ' || 'l_source_type : ' || l_source_type);
1187: arp_standard.debug('update_cash_receipt: ' || 'l_crh_ccid : ' || l_crh_ccid);
1188: END IF;
1189:
1190: arp_proc_rct_util.insert_dist_rec(l_crh_amount_delta,
1191: l_crh_acctd_amount_delta,

Line 1205: arp_standard.debug('update_cash_receipt: ' || 'l_crh_fda_delta : ' || to_char(l_crh_fda_delta));

1201: IF (l_crh_fda_delta <> 0 OR
1202: l_crh_acctd_fda_delta <> 0) THEN
1203:
1204: IF PG_DEBUG in ('Y', 'C') THEN
1205: arp_standard.debug('update_cash_receipt: ' || 'l_crh_fda_delta : ' || to_char(l_crh_fda_delta));
1206: arp_standard.debug('update_cash_receipt: ' || 'l_crh_acctd_fda_delta : ' || to_char(l_crh_acctd_fda_delta));
1207: arp_standard.debug('update_cash_receipt: ' || 'cash_receipt_history_id : ' || to_char(l_crh_rec.cash_receipt_history_id));
1208: arp_standard.debug('update_cash_receipt: ' || 'l_crh_ccid : ' || l_bank_charges_ccid);
1209: END IF;

Line 1206: arp_standard.debug('update_cash_receipt: ' || 'l_crh_acctd_fda_delta : ' || to_char(l_crh_acctd_fda_delta));

1202: l_crh_acctd_fda_delta <> 0) THEN
1203:
1204: IF PG_DEBUG in ('Y', 'C') THEN
1205: arp_standard.debug('update_cash_receipt: ' || 'l_crh_fda_delta : ' || to_char(l_crh_fda_delta));
1206: arp_standard.debug('update_cash_receipt: ' || 'l_crh_acctd_fda_delta : ' || to_char(l_crh_acctd_fda_delta));
1207: arp_standard.debug('update_cash_receipt: ' || 'cash_receipt_history_id : ' || to_char(l_crh_rec.cash_receipt_history_id));
1208: arp_standard.debug('update_cash_receipt: ' || 'l_crh_ccid : ' || l_bank_charges_ccid);
1209: END IF;
1210:

Line 1207: arp_standard.debug('update_cash_receipt: ' || 'cash_receipt_history_id : ' || to_char(l_crh_rec.cash_receipt_history_id));

1203:
1204: IF PG_DEBUG in ('Y', 'C') THEN
1205: arp_standard.debug('update_cash_receipt: ' || 'l_crh_fda_delta : ' || to_char(l_crh_fda_delta));
1206: arp_standard.debug('update_cash_receipt: ' || 'l_crh_acctd_fda_delta : ' || to_char(l_crh_acctd_fda_delta));
1207: arp_standard.debug('update_cash_receipt: ' || 'cash_receipt_history_id : ' || to_char(l_crh_rec.cash_receipt_history_id));
1208: arp_standard.debug('update_cash_receipt: ' || 'l_crh_ccid : ' || l_bank_charges_ccid);
1209: END IF;
1210:
1211: arp_proc_rct_util.insert_dist_rec(

Line 1208: arp_standard.debug('update_cash_receipt: ' || 'l_crh_ccid : ' || l_bank_charges_ccid);

1204: IF PG_DEBUG in ('Y', 'C') THEN
1205: arp_standard.debug('update_cash_receipt: ' || 'l_crh_fda_delta : ' || to_char(l_crh_fda_delta));
1206: arp_standard.debug('update_cash_receipt: ' || 'l_crh_acctd_fda_delta : ' || to_char(l_crh_acctd_fda_delta));
1207: arp_standard.debug('update_cash_receipt: ' || 'cash_receipt_history_id : ' || to_char(l_crh_rec.cash_receipt_history_id));
1208: arp_standard.debug('update_cash_receipt: ' || 'l_crh_ccid : ' || l_bank_charges_ccid);
1209: END IF;
1210:
1211: arp_proc_rct_util.insert_dist_rec(
1212: l_crh_fda_delta,

Line 1406: arp_standard.debug('Before Inserting CR/CRH record in update_cash_receipt.');

1402:
1403: l_ps_rec.due_date := NVL(p_maturity_date, p_deposit_date);
1404:
1405: IF PG_DEBUG in ('Y', 'C') THEN
1406: arp_standard.debug('Before Inserting CR/CRH record in update_cash_receipt.');
1407: END IF;
1408:
1409: --{BUG#4353362
1410: OPEN cu_current_customer;

Line 1505: arp_standard.debug('update_cash_receipt: ' || 'Receipt needs to be reversed.');

1501:
1502: IF (p_reversal_date IS NOT NULL AND
1503: l_cr_rec.reversal_date IS NULL) THEN
1504: IF PG_DEBUG in ('Y', 'C') THEN
1505: arp_standard.debug('update_cash_receipt: ' || 'Receipt needs to be reversed.');
1506: END IF;
1507: IF (p_dm_reversal_flag = 'Y') THEN
1508: IF PG_DEBUG in ('Y', 'C') THEN
1509: arp_standard.debug('update_cash_receipt: ' || 'Debit memo reversal required');

Line 1509: arp_standard.debug('update_cash_receipt: ' || 'Debit memo reversal required');

1505: arp_standard.debug('update_cash_receipt: ' || 'Receipt needs to be reversed.');
1506: END IF;
1507: IF (p_dm_reversal_flag = 'Y') THEN
1508: IF PG_DEBUG in ('Y', 'C') THEN
1509: arp_standard.debug('update_cash_receipt: ' || 'Debit memo reversal required');
1510: END IF;
1511:
1512: arp_reverse_receipt.debit_memo_reversal(
1513: l_cr_rec,

Line 1549: arp_standard.debug('update_cash_receipt: ' || 'Regular reversal required');

1545: l_ps_rec.payment_schedule_id,
1546: l_history_id);
1547: ELSE
1548: IF PG_DEBUG in ('Y', 'C') THEN
1549: arp_standard.debug('update_cash_receipt: ' || 'Regular reversal required');
1550: END IF;
1551:
1552: -- Bug 2946734 - update all claims on this receipt
1553: arp_reverse_receipt.cancel_claims(

Line 1595: arp_standard.debug('update_cash_receipt: ' || 'before creating the history rec for BusinessEvent');

1591: --apandit
1592: --Bug 2641517 Insert the history record and raising
1593: --the business event
1594: IF PG_DEBUG in ('Y', 'C') THEN
1595: arp_standard.debug('update_cash_receipt: ' || 'before creating the history rec for BusinessEvent');
1596: END IF;
1597: AR_BUS_EVENT_COVER.p_insert_trx_sum_hist(l_trx_sum_hist_rec,
1598: l_history_id,
1599: 'PMT',

Line 1604: arp_standard.debug('update_cash_receipt: ' || 'before raising the new business event');

1600: 'REVERSE_PMT');
1601:
1602: --Raise the business event
1603: IF PG_DEBUG in ('Y', 'C') THEN
1604: arp_standard.debug('update_cash_receipt: ' || 'before raising the new business event');
1605: END IF;
1606: AR_BUS_EVENT_COVER.Raise_Rcpt_Reverse_Event(l_ps_rec.cash_receipt_id,
1607: l_ps_rec.payment_schedule_id,
1608: l_history_id);

Line 1644: arp_standard.debug('arp_process_receipts.update_cash_receipt()+');

1640: p_exchange_rate_attr14,
1641: p_exchange_rate_attr15);
1642: END IF;
1643: IF PG_DEBUG in ('Y', 'C') THEN
1644: arp_standard.debug('arp_process_receipts.update_cash_receipt()+');
1645: END IF;
1646:
1647: -- determine receipt's new state and status and return it to form:
1648:

Line 1678: arp_standard.debug('Exception in arp_process_receipts.update_cash_receipts');

1674:
1675: EXCEPTION
1676: WHEN OTHERS THEN
1677: IF PG_DEBUG in ('Y', 'C') THEN
1678: arp_standard.debug('Exception in arp_process_receipts.update_cash_receipts');
1679: arp_standard.debug('update_cash_receipt: ' || 'p_cash_receipt_id = '|| to_char(p_cash_receipt_id));
1680: arp_standard.debug('update_cash_receipt: ' || 'p_amount = '|| to_char(p_amount));
1681: arp_standard.debug('update_cash_receipt: ' || 'p_factor_discount_amount = '|| to_char(p_factor_discount_amount));
1682: END IF;

Line 1679: arp_standard.debug('update_cash_receipt: ' || 'p_cash_receipt_id = '|| to_char(p_cash_receipt_id));

1675: EXCEPTION
1676: WHEN OTHERS THEN
1677: IF PG_DEBUG in ('Y', 'C') THEN
1678: arp_standard.debug('Exception in arp_process_receipts.update_cash_receipts');
1679: arp_standard.debug('update_cash_receipt: ' || 'p_cash_receipt_id = '|| to_char(p_cash_receipt_id));
1680: arp_standard.debug('update_cash_receipt: ' || 'p_amount = '|| to_char(p_amount));
1681: arp_standard.debug('update_cash_receipt: ' || 'p_factor_discount_amount = '|| to_char(p_factor_discount_amount));
1682: END IF;
1683: RAISE;

Line 1680: arp_standard.debug('update_cash_receipt: ' || 'p_amount = '|| to_char(p_amount));

1676: WHEN OTHERS THEN
1677: IF PG_DEBUG in ('Y', 'C') THEN
1678: arp_standard.debug('Exception in arp_process_receipts.update_cash_receipts');
1679: arp_standard.debug('update_cash_receipt: ' || 'p_cash_receipt_id = '|| to_char(p_cash_receipt_id));
1680: arp_standard.debug('update_cash_receipt: ' || 'p_amount = '|| to_char(p_amount));
1681: arp_standard.debug('update_cash_receipt: ' || 'p_factor_discount_amount = '|| to_char(p_factor_discount_amount));
1682: END IF;
1683: RAISE;
1684:

Line 1681: arp_standard.debug('update_cash_receipt: ' || 'p_factor_discount_amount = '|| to_char(p_factor_discount_amount));

1677: IF PG_DEBUG in ('Y', 'C') THEN
1678: arp_standard.debug('Exception in arp_process_receipts.update_cash_receipts');
1679: arp_standard.debug('update_cash_receipt: ' || 'p_cash_receipt_id = '|| to_char(p_cash_receipt_id));
1680: arp_standard.debug('update_cash_receipt: ' || 'p_amount = '|| to_char(p_amount));
1681: arp_standard.debug('update_cash_receipt: ' || 'p_factor_discount_amount = '|| to_char(p_factor_discount_amount));
1682: END IF;
1683: RAISE;
1684:
1685: IF PG_DEBUG in ('Y', 'C') THEN

Line 1686: arp_standard.debug('arp_process_rct_util.update_cash_receipts()-');

1682: END IF;
1683: RAISE;
1684:
1685: IF PG_DEBUG in ('Y', 'C') THEN
1686: arp_standard.debug('arp_process_rct_util.update_cash_receipts()-');
1687: END IF;
1688:
1689: END update_cash_receipt;
1690: