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 ARP_STANDARD

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

397: --}
398: BEGIN
399:
400: IF PG_DEBUG in ('Y', 'C') THEN
401: arp_standard.debug('arp_process_receipts.update_cash_receipt()+');
402: END IF;
403:
404: -- --------------------------------------------------------------
405: -- First fetch and lock existing records from database for update

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

481: IF (p_amount <> l_cr_rec.amount)
482: THEN
483: l_cr_amount_changed_flag := TRUE;
484: IF PG_DEBUG in ('Y', 'C') THEN
485: arp_standard.debug('update_cash_receipt: ' || 'l_cr_amount_changed_flag = TRUE');
486: END IF;
487: END IF;
488:
489: -- check if the gl date of the receipt is still valid

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

488:
489: -- check if the gl date of the receipt is still valid
490:
491: IF PG_DEBUG in ('Y', 'C') THEN
492: arp_standard.debug('update_cash_receipt: ' || 'P_GL_DATE is:' || to_char(p_gl_date, 'DD-MM-YYYY:HH:SS'));
493: arp_standard.debug('update_cash_receipt: ' || 'l_valid_gl_date is:' || to_char(l_valid_gl_date, 'DD-MM-YYYY:HH:SS'));
494: END IF;
495:
496: IF (p_gl_date <> l_valid_gl_date)

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

489: -- check if the gl date of the receipt is still valid
490:
491: IF PG_DEBUG in ('Y', 'C') THEN
492: arp_standard.debug('update_cash_receipt: ' || 'P_GL_DATE is:' || to_char(p_gl_date, 'DD-MM-YYYY:HH:SS'));
493: arp_standard.debug('update_cash_receipt: ' || 'l_valid_gl_date is:' || to_char(l_valid_gl_date, 'DD-MM-YYYY:HH:SS'));
494: END IF;
495:
496: IF (p_gl_date <> l_valid_gl_date)
497: THEN

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

496: IF (p_gl_date <> l_valid_gl_date)
497: THEN
498: l_crh_rec_gl_date_changed := TRUE;
499: IF PG_DEBUG in ('Y', 'C') THEN
500: arp_standard.debug('update_cash_receipt: ' || 'l_crh_rec_gl_date_changed = TRUE');
501: END IF;
502: END IF;
503:
504:

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

508: NVL(l_crh_rec.factor_discount_amount,0))
509: THEN
510: l_crh_fda_changed_flag := TRUE;
511: IF PG_DEBUG in ('Y', 'C') THEN
512: arp_standard.debug('update_cash_receipt: ' || 'l_crh_fda_changed_flag = TRUE');
513: END IF;
514:
515: END IF;
516:

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

519: IF (l_crh_rec.posting_control_id <> -3)
520: THEN
521: l_crh_rec_posted_flag := TRUE;
522: IF PG_DEBUG in ('Y', 'C') THEN
523: arp_standard.debug('update_cash_receipt: ' || 'l_crh_rec_posted_flag = TRUE');
524: END IF;
525: END IF;
526:
527: -- check if receipt was identified (UNID -> UNAPP)

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

530: p_pay_from_customer IS NOT NULL)
531: THEN
532: l_rct_identified_flag := TRUE;
533: IF PG_DEBUG in ('Y', 'C') THEN
534: arp_standard.debug('update_cash_receipt: ' || 'l_rct_identified_flag = TRUE');
535: END IF;
536: END IF;
537:
538: -- check if receipt was "un-identified" (UNAPP -> UNID)

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

541: p_pay_from_customer IS NULL)
542: THEN
543: l_rct_unidentified_flag := TRUE;
544: IF PG_DEBUG in ('Y', 'C') THEN
545: arp_standard.debug('update_cash_receipt: ' || 'l_rct_unidentified_flag = TRUE');
546: END IF;
547: END IF;
548:
549: -- -------------------------------------------------------------

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

672: l_crh_acctd_fda_delta := nvl(l_crh_acctd_fda_new,0) -
673: nvl(l_crh_rec.acctd_factor_discount_amount,0);
674:
675: IF PG_DEBUG in ('Y', 'C') THEN
676: arp_standard.debug('update_cash_receipt: ' || 'p_amount = '|| to_char(p_amount));
677: arp_standard.debug('update_cash_receipt: ' || 'l_crh_amount_new = '|| to_char(l_crh_amount_new));
678: arp_standard.debug('update_cash_receipt: ' || 'l_crh_acctd_amount_new = '|| to_char(l_crh_acctd_amount_new));
679: END IF;
680:

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

673: nvl(l_crh_rec.acctd_factor_discount_amount,0);
674:
675: IF PG_DEBUG in ('Y', 'C') THEN
676: arp_standard.debug('update_cash_receipt: ' || 'p_amount = '|| to_char(p_amount));
677: arp_standard.debug('update_cash_receipt: ' || 'l_crh_amount_new = '|| to_char(l_crh_amount_new));
678: arp_standard.debug('update_cash_receipt: ' || 'l_crh_acctd_amount_new = '|| to_char(l_crh_acctd_amount_new));
679: END IF;
680:
681: -- -------------------------------------------------------------

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

674:
675: IF PG_DEBUG in ('Y', 'C') THEN
676: arp_standard.debug('update_cash_receipt: ' || 'p_amount = '|| to_char(p_amount));
677: arp_standard.debug('update_cash_receipt: ' || 'l_crh_amount_new = '|| to_char(l_crh_amount_new));
678: arp_standard.debug('update_cash_receipt: ' || 'l_crh_acctd_amount_new = '|| to_char(l_crh_acctd_amount_new));
679: END IF;
680:
681: -- -------------------------------------------------------------
682: -- handle changes in rct identification status

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

912: -- and subtract (since adr is negative) the difference between
913: -- the new receipt amount and the old receipt amount.
914:
915: IF PG_DEBUG in ('Y', 'C') THEN
916: arp_standard.debug('update_cash_receipt: ' || 'l_ps_rec.amount_due_remaining: ' || to_char(l_ps_rec.amount_due_remaining));
917: arp_standard.debug('update_cash_receipt: ' || 'p_amount: ' || to_char(p_amount));
918: arp_standard.debug('update_cash_receipt: ' || 'l_cr_rec.amount: ' || to_char(l_cr_rec.amount));
919: arp_standard.debug('update_cash_receipt: ' || 'l_cr_acctd_amount_delta: ' || to_char(l_cr_acctd_amount_delta));
920: END IF;

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

913: -- the new receipt amount and the old receipt amount.
914:
915: IF PG_DEBUG in ('Y', 'C') THEN
916: arp_standard.debug('update_cash_receipt: ' || 'l_ps_rec.amount_due_remaining: ' || to_char(l_ps_rec.amount_due_remaining));
917: arp_standard.debug('update_cash_receipt: ' || 'p_amount: ' || to_char(p_amount));
918: arp_standard.debug('update_cash_receipt: ' || 'l_cr_rec.amount: ' || to_char(l_cr_rec.amount));
919: arp_standard.debug('update_cash_receipt: ' || 'l_cr_acctd_amount_delta: ' || to_char(l_cr_acctd_amount_delta));
920: END IF;
921:

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

914:
915: IF PG_DEBUG in ('Y', 'C') THEN
916: arp_standard.debug('update_cash_receipt: ' || 'l_ps_rec.amount_due_remaining: ' || to_char(l_ps_rec.amount_due_remaining));
917: arp_standard.debug('update_cash_receipt: ' || 'p_amount: ' || to_char(p_amount));
918: arp_standard.debug('update_cash_receipt: ' || 'l_cr_rec.amount: ' || to_char(l_cr_rec.amount));
919: arp_standard.debug('update_cash_receipt: ' || 'l_cr_acctd_amount_delta: ' || to_char(l_cr_acctd_amount_delta));
920: END IF;
921:
922: l_ps_rec.amount_due_remaining :=

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

915: IF PG_DEBUG in ('Y', 'C') THEN
916: arp_standard.debug('update_cash_receipt: ' || 'l_ps_rec.amount_due_remaining: ' || to_char(l_ps_rec.amount_due_remaining));
917: arp_standard.debug('update_cash_receipt: ' || 'p_amount: ' || to_char(p_amount));
918: arp_standard.debug('update_cash_receipt: ' || 'l_cr_rec.amount: ' || to_char(l_cr_rec.amount));
919: arp_standard.debug('update_cash_receipt: ' || 'l_cr_acctd_amount_delta: ' || to_char(l_cr_acctd_amount_delta));
920: END IF;
921:
922: l_ps_rec.amount_due_remaining :=
923: l_ps_rec.amount_due_remaining -

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

927: l_ps_rec.acctd_amount_due_remaining -
928: l_cr_acctd_amount_delta;
929:
930: IF PG_DEBUG in ('Y', 'C') THEN
931: arp_standard.debug('update_cash_receipt: ' || 'l_ps_rec.amount_due_remaining: ' || to_char(l_ps_rec.amount_due_remaining));
932: arp_standard.debug('update_cash_receipt: ' || 'l_ps_rec.acctd_amount_due_remaining: ' || to_char(l_ps_rec.acctd_amount_due_remaining));
933: END IF;
934:
935: l_ps_rec.amount_due_original := -p_amount;

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

928: l_cr_acctd_amount_delta;
929:
930: IF PG_DEBUG in ('Y', 'C') THEN
931: arp_standard.debug('update_cash_receipt: ' || 'l_ps_rec.amount_due_remaining: ' || to_char(l_ps_rec.amount_due_remaining));
932: arp_standard.debug('update_cash_receipt: ' || 'l_ps_rec.acctd_amount_due_remaining: ' || to_char(l_ps_rec.acctd_amount_due_remaining));
933: END IF;
934:
935: l_ps_rec.amount_due_original := -p_amount;
936:

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

980: WHEN no_data_found THEN
981: l_dist_row_on_current_crh := 'N';
982: END;
983: IF PG_DEBUG in ('Y', 'C') THEN
984: arp_standard.debug('update_cash_receipt: '||'l_dist_row_on_current_crh : '||l_dist_row_on_current_crh);
985: END IF;
986: IF l_dist_row_on_current_crh = 'Y' THEN
987: arp_proc_rct_util.update_dist_rec(
988: l_crh_rec.cash_receipt_history_id,

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

990: l_crh_amount_new - l_crh_rec.amount,
991: l_crh_acctd_amount_new - l_crh_rec.acctd_amount);
992: ELSE
993: IF PG_DEBUG in ('Y', 'C') THEN
994: arp_standard.debug('update_cash_receipt: ' || 'l_crh_amount_delta : ' || to_char(l_crh_amount_delta));
995: arp_standard.debug('update_cash_receipt: ' || 'l_crh_acctd_amount_delta : ' || to_char(l_crh_acctd_amount_delta));
996: arp_standard.debug('update_cash_receipt: ' || 'cash_receipt_history_id : ' || to_char(l_crh_rec.cash_receipt_history_id));
997: arp_standard.debug('update_cash_receipt: ' || 'l_source_type : ' || l_source_type);
998: arp_standard.debug('update_cash_receipt: ' || 'l_crh_ccid : ' || l_crh_ccid);

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

991: l_crh_acctd_amount_new - l_crh_rec.acctd_amount);
992: ELSE
993: IF PG_DEBUG in ('Y', 'C') THEN
994: arp_standard.debug('update_cash_receipt: ' || 'l_crh_amount_delta : ' || to_char(l_crh_amount_delta));
995: arp_standard.debug('update_cash_receipt: ' || 'l_crh_acctd_amount_delta : ' || to_char(l_crh_acctd_amount_delta));
996: arp_standard.debug('update_cash_receipt: ' || 'cash_receipt_history_id : ' || to_char(l_crh_rec.cash_receipt_history_id));
997: arp_standard.debug('update_cash_receipt: ' || 'l_source_type : ' || l_source_type);
998: arp_standard.debug('update_cash_receipt: ' || 'l_crh_ccid : ' || l_crh_ccid);
999: END IF;

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

992: ELSE
993: IF PG_DEBUG in ('Y', 'C') THEN
994: arp_standard.debug('update_cash_receipt: ' || 'l_crh_amount_delta : ' || to_char(l_crh_amount_delta));
995: arp_standard.debug('update_cash_receipt: ' || 'l_crh_acctd_amount_delta : ' || to_char(l_crh_acctd_amount_delta));
996: arp_standard.debug('update_cash_receipt: ' || 'cash_receipt_history_id : ' || to_char(l_crh_rec.cash_receipt_history_id));
997: arp_standard.debug('update_cash_receipt: ' || 'l_source_type : ' || l_source_type);
998: arp_standard.debug('update_cash_receipt: ' || 'l_crh_ccid : ' || l_crh_ccid);
999: END IF;
1000:

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

993: IF PG_DEBUG in ('Y', 'C') THEN
994: arp_standard.debug('update_cash_receipt: ' || 'l_crh_amount_delta : ' || to_char(l_crh_amount_delta));
995: arp_standard.debug('update_cash_receipt: ' || 'l_crh_acctd_amount_delta : ' || to_char(l_crh_acctd_amount_delta));
996: arp_standard.debug('update_cash_receipt: ' || 'cash_receipt_history_id : ' || to_char(l_crh_rec.cash_receipt_history_id));
997: arp_standard.debug('update_cash_receipt: ' || 'l_source_type : ' || l_source_type);
998: arp_standard.debug('update_cash_receipt: ' || 'l_crh_ccid : ' || l_crh_ccid);
999: END IF;
1000:
1001: arp_proc_rct_util.insert_dist_rec(l_crh_amount_delta,

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

994: arp_standard.debug('update_cash_receipt: ' || 'l_crh_amount_delta : ' || to_char(l_crh_amount_delta));
995: arp_standard.debug('update_cash_receipt: ' || 'l_crh_acctd_amount_delta : ' || to_char(l_crh_acctd_amount_delta));
996: arp_standard.debug('update_cash_receipt: ' || 'cash_receipt_history_id : ' || to_char(l_crh_rec.cash_receipt_history_id));
997: arp_standard.debug('update_cash_receipt: ' || 'l_source_type : ' || l_source_type);
998: arp_standard.debug('update_cash_receipt: ' || 'l_crh_ccid : ' || l_crh_ccid);
999: END IF;
1000:
1001: arp_proc_rct_util.insert_dist_rec(l_crh_amount_delta,
1002: l_crh_acctd_amount_delta,

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

1100: and dis.source_table = 'CRH'
1101: and dis.source_type = 'BANK_CHARGES';
1102:
1103: IF PG_DEBUG in ('Y', 'C') THEN
1104: arp_standard.debug('update_cash_receipt: ' || 'p_factor_discount_amount: ' || to_char(p_factor_discount_amount));
1105: arp_standard.debug('update_cash_receipt: ' || 'l_sum_fda_debits : ' || to_char(l_sum_fda_debits));
1106: arp_standard.debug('update_cash_receipt: ' || 'l_sum_fda_credits: ' || to_char(l_sum_fda_credits));
1107: arp_standard.debug('update_cash_receipt: ' || 'l_sum_acctd_fda_debits: ' || to_char(l_sum_acctd_fda_debits));
1108: arp_standard.debug('update_cash_receipt: ' || 'l_sum_acctd_fda_credits: ' || to_char(l_sum_acctd_fda_credits));

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

1101: and dis.source_type = 'BANK_CHARGES';
1102:
1103: IF PG_DEBUG in ('Y', 'C') THEN
1104: arp_standard.debug('update_cash_receipt: ' || 'p_factor_discount_amount: ' || to_char(p_factor_discount_amount));
1105: arp_standard.debug('update_cash_receipt: ' || 'l_sum_fda_debits : ' || to_char(l_sum_fda_debits));
1106: arp_standard.debug('update_cash_receipt: ' || 'l_sum_fda_credits: ' || to_char(l_sum_fda_credits));
1107: arp_standard.debug('update_cash_receipt: ' || 'l_sum_acctd_fda_debits: ' || to_char(l_sum_acctd_fda_debits));
1108: arp_standard.debug('update_cash_receipt: ' || 'l_sum_acctd_fda_credits: ' || to_char(l_sum_acctd_fda_credits));
1109: END IF;

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

1102:
1103: IF PG_DEBUG in ('Y', 'C') THEN
1104: arp_standard.debug('update_cash_receipt: ' || 'p_factor_discount_amount: ' || to_char(p_factor_discount_amount));
1105: arp_standard.debug('update_cash_receipt: ' || 'l_sum_fda_debits : ' || to_char(l_sum_fda_debits));
1106: arp_standard.debug('update_cash_receipt: ' || 'l_sum_fda_credits: ' || to_char(l_sum_fda_credits));
1107: arp_standard.debug('update_cash_receipt: ' || 'l_sum_acctd_fda_debits: ' || to_char(l_sum_acctd_fda_debits));
1108: arp_standard.debug('update_cash_receipt: ' || 'l_sum_acctd_fda_credits: ' || to_char(l_sum_acctd_fda_credits));
1109: END IF;
1110:

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

1103: IF PG_DEBUG in ('Y', 'C') THEN
1104: arp_standard.debug('update_cash_receipt: ' || 'p_factor_discount_amount: ' || to_char(p_factor_discount_amount));
1105: arp_standard.debug('update_cash_receipt: ' || 'l_sum_fda_debits : ' || to_char(l_sum_fda_debits));
1106: arp_standard.debug('update_cash_receipt: ' || 'l_sum_fda_credits: ' || to_char(l_sum_fda_credits));
1107: arp_standard.debug('update_cash_receipt: ' || 'l_sum_acctd_fda_debits: ' || to_char(l_sum_acctd_fda_debits));
1108: arp_standard.debug('update_cash_receipt: ' || 'l_sum_acctd_fda_credits: ' || to_char(l_sum_acctd_fda_credits));
1109: END IF;
1110:
1111: -- Positive result will create a DR entry, negative a CR entry.

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

1104: arp_standard.debug('update_cash_receipt: ' || 'p_factor_discount_amount: ' || to_char(p_factor_discount_amount));
1105: arp_standard.debug('update_cash_receipt: ' || 'l_sum_fda_debits : ' || to_char(l_sum_fda_debits));
1106: arp_standard.debug('update_cash_receipt: ' || 'l_sum_fda_credits: ' || to_char(l_sum_fda_credits));
1107: arp_standard.debug('update_cash_receipt: ' || 'l_sum_acctd_fda_debits: ' || to_char(l_sum_acctd_fda_debits));
1108: arp_standard.debug('update_cash_receipt: ' || 'l_sum_acctd_fda_credits: ' || to_char(l_sum_acctd_fda_credits));
1109: END IF;
1110:
1111: -- Positive result will create a DR entry, negative a CR entry.
1112:

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

1209:
1210: IF (l_crh_amount_delta <> 0) THEN
1211:
1212: IF PG_DEBUG in ('Y', 'C') THEN
1213: arp_standard.debug('update_cash_receipt: ' || 'l_crh_amount_delta : ' || to_char(l_crh_amount_delta));
1214: arp_standard.debug('update_cash_receipt: ' || 'l_crh_acctd_amount_delta : ' || to_char(l_crh_acctd_amount_delta));
1215: arp_standard.debug('update_cash_receipt: ' || 'cash_receipt_history_id : ' || to_char(l_crh_rec.cash_receipt_history_id));
1216: arp_standard.debug('update_cash_receipt: ' || 'l_source_type : ' || l_source_type);
1217: arp_standard.debug('update_cash_receipt: ' || 'l_crh_ccid : ' || l_crh_ccid);

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

1210: IF (l_crh_amount_delta <> 0) THEN
1211:
1212: IF PG_DEBUG in ('Y', 'C') THEN
1213: arp_standard.debug('update_cash_receipt: ' || 'l_crh_amount_delta : ' || to_char(l_crh_amount_delta));
1214: arp_standard.debug('update_cash_receipt: ' || 'l_crh_acctd_amount_delta : ' || to_char(l_crh_acctd_amount_delta));
1215: arp_standard.debug('update_cash_receipt: ' || 'cash_receipt_history_id : ' || to_char(l_crh_rec.cash_receipt_history_id));
1216: arp_standard.debug('update_cash_receipt: ' || 'l_source_type : ' || l_source_type);
1217: arp_standard.debug('update_cash_receipt: ' || 'l_crh_ccid : ' || l_crh_ccid);
1218: END IF;

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

1211:
1212: IF PG_DEBUG in ('Y', 'C') THEN
1213: arp_standard.debug('update_cash_receipt: ' || 'l_crh_amount_delta : ' || to_char(l_crh_amount_delta));
1214: arp_standard.debug('update_cash_receipt: ' || 'l_crh_acctd_amount_delta : ' || to_char(l_crh_acctd_amount_delta));
1215: arp_standard.debug('update_cash_receipt: ' || 'cash_receipt_history_id : ' || to_char(l_crh_rec.cash_receipt_history_id));
1216: arp_standard.debug('update_cash_receipt: ' || 'l_source_type : ' || l_source_type);
1217: arp_standard.debug('update_cash_receipt: ' || 'l_crh_ccid : ' || l_crh_ccid);
1218: END IF;
1219:

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

1212: IF PG_DEBUG in ('Y', 'C') THEN
1213: arp_standard.debug('update_cash_receipt: ' || 'l_crh_amount_delta : ' || to_char(l_crh_amount_delta));
1214: arp_standard.debug('update_cash_receipt: ' || 'l_crh_acctd_amount_delta : ' || to_char(l_crh_acctd_amount_delta));
1215: arp_standard.debug('update_cash_receipt: ' || 'cash_receipt_history_id : ' || to_char(l_crh_rec.cash_receipt_history_id));
1216: arp_standard.debug('update_cash_receipt: ' || 'l_source_type : ' || l_source_type);
1217: arp_standard.debug('update_cash_receipt: ' || 'l_crh_ccid : ' || l_crh_ccid);
1218: END IF;
1219:
1220: arp_proc_rct_util.insert_dist_rec(l_crh_amount_delta,

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

1213: arp_standard.debug('update_cash_receipt: ' || 'l_crh_amount_delta : ' || to_char(l_crh_amount_delta));
1214: arp_standard.debug('update_cash_receipt: ' || 'l_crh_acctd_amount_delta : ' || to_char(l_crh_acctd_amount_delta));
1215: arp_standard.debug('update_cash_receipt: ' || 'cash_receipt_history_id : ' || to_char(l_crh_rec.cash_receipt_history_id));
1216: arp_standard.debug('update_cash_receipt: ' || 'l_source_type : ' || l_source_type);
1217: arp_standard.debug('update_cash_receipt: ' || 'l_crh_ccid : ' || l_crh_ccid);
1218: END IF;
1219:
1220: arp_proc_rct_util.insert_dist_rec(l_crh_amount_delta,
1221: l_crh_acctd_amount_delta,

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

1231: IF (l_crh_fda_delta <> 0 OR
1232: l_crh_acctd_fda_delta <> 0) THEN
1233:
1234: IF PG_DEBUG in ('Y', 'C') THEN
1235: arp_standard.debug('update_cash_receipt: ' || 'l_crh_fda_delta : ' || to_char(l_crh_fda_delta));
1236: arp_standard.debug('update_cash_receipt: ' || 'l_crh_acctd_fda_delta : ' || to_char(l_crh_acctd_fda_delta));
1237: arp_standard.debug('update_cash_receipt: ' || 'cash_receipt_history_id : ' || to_char(l_crh_rec.cash_receipt_history_id));
1238: arp_standard.debug('update_cash_receipt: ' || 'l_crh_ccid : ' || l_bank_charges_ccid);
1239: END IF;

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

1232: l_crh_acctd_fda_delta <> 0) THEN
1233:
1234: IF PG_DEBUG in ('Y', 'C') THEN
1235: arp_standard.debug('update_cash_receipt: ' || 'l_crh_fda_delta : ' || to_char(l_crh_fda_delta));
1236: arp_standard.debug('update_cash_receipt: ' || 'l_crh_acctd_fda_delta : ' || to_char(l_crh_acctd_fda_delta));
1237: arp_standard.debug('update_cash_receipt: ' || 'cash_receipt_history_id : ' || to_char(l_crh_rec.cash_receipt_history_id));
1238: arp_standard.debug('update_cash_receipt: ' || 'l_crh_ccid : ' || l_bank_charges_ccid);
1239: END IF;
1240:

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

1233:
1234: IF PG_DEBUG in ('Y', 'C') THEN
1235: arp_standard.debug('update_cash_receipt: ' || 'l_crh_fda_delta : ' || to_char(l_crh_fda_delta));
1236: arp_standard.debug('update_cash_receipt: ' || 'l_crh_acctd_fda_delta : ' || to_char(l_crh_acctd_fda_delta));
1237: arp_standard.debug('update_cash_receipt: ' || 'cash_receipt_history_id : ' || to_char(l_crh_rec.cash_receipt_history_id));
1238: arp_standard.debug('update_cash_receipt: ' || 'l_crh_ccid : ' || l_bank_charges_ccid);
1239: END IF;
1240:
1241: arp_proc_rct_util.insert_dist_rec(

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

1234: IF PG_DEBUG in ('Y', 'C') THEN
1235: arp_standard.debug('update_cash_receipt: ' || 'l_crh_fda_delta : ' || to_char(l_crh_fda_delta));
1236: arp_standard.debug('update_cash_receipt: ' || 'l_crh_acctd_fda_delta : ' || to_char(l_crh_acctd_fda_delta));
1237: arp_standard.debug('update_cash_receipt: ' || 'cash_receipt_history_id : ' || to_char(l_crh_rec.cash_receipt_history_id));
1238: arp_standard.debug('update_cash_receipt: ' || 'l_crh_ccid : ' || l_bank_charges_ccid);
1239: END IF;
1240:
1241: arp_proc_rct_util.insert_dist_rec(
1242: l_crh_fda_delta,

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

1442:
1443: l_ps_rec.due_date := NVL(p_maturity_date, p_deposit_date);
1444:
1445: IF PG_DEBUG in ('Y', 'C') THEN
1446: arp_standard.debug('Before Inserting CR/CRH record in update_cash_receipt.');
1447: END IF;
1448:
1449: --{BUG#4353362
1450: OPEN cu_current_customer;

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

1541:
1542: IF (p_reversal_date IS NOT NULL AND
1543: l_cr_rec.reversal_date IS NULL) THEN
1544: IF PG_DEBUG in ('Y', 'C') THEN
1545: arp_standard.debug('update_cash_receipt: ' || 'Receipt needs to be reversed.');
1546: END IF;
1547: IF (p_dm_reversal_flag = 'Y') THEN
1548: IF PG_DEBUG in ('Y', 'C') THEN
1549: arp_standard.debug('update_cash_receipt: ' || 'Debit memo reversal required');

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

1545: arp_standard.debug('update_cash_receipt: ' || 'Receipt needs to be reversed.');
1546: END IF;
1547: IF (p_dm_reversal_flag = 'Y') THEN
1548: IF PG_DEBUG in ('Y', 'C') THEN
1549: arp_standard.debug('update_cash_receipt: ' || 'Debit memo reversal required');
1550: END IF;
1551:
1552: arp_reverse_receipt.debit_memo_reversal(
1553: l_cr_rec,

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

1585: l_ps_rec.payment_schedule_id,
1586: l_history_id);
1587: ELSE
1588: IF PG_DEBUG in ('Y', 'C') THEN
1589: arp_standard.debug('update_cash_receipt: ' || 'Regular reversal required');
1590: END IF;
1591:
1592: -- Bug 2946734 - update all claims on this receipt
1593: arp_reverse_receipt.cancel_claims(

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

1631: --apandit
1632: --Bug 2641517 Insert the history record and raising
1633: --the business event
1634: IF PG_DEBUG in ('Y', 'C') THEN
1635: arp_standard.debug('update_cash_receipt: ' || 'before creating the history rec for BusinessEvent');
1636: END IF;
1637: AR_BUS_EVENT_COVER.p_insert_trx_sum_hist(l_trx_sum_hist_rec,
1638: l_history_id,
1639: 'PMT',

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

1640: 'REVERSE_PMT');
1641:
1642: --Raise the business event
1643: IF PG_DEBUG in ('Y', 'C') THEN
1644: arp_standard.debug('update_cash_receipt: ' || 'before raising the new business event');
1645: END IF;
1646: AR_BUS_EVENT_COVER.Raise_Rcpt_Reverse_Event(l_ps_rec.cash_receipt_id,
1647: l_ps_rec.payment_schedule_id,
1648: l_history_id);

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

1680: p_exchange_rate_attr14,
1681: p_exchange_rate_attr15);
1682: END IF;
1683: IF PG_DEBUG in ('Y', 'C') THEN
1684: arp_standard.debug('arp_process_receipts.update_cash_receipt()+');
1685: END IF;
1686:
1687:
1688: /* Bug8422361 - Code Changes - Start.

Line 1709: ARP_STANDARD.DEBUG('p_pay_from_customer :- ' || p_pay_from_customer );

1705: WHERE CUST_ACCOUNT_ID = p_pay_from_customer
1706: AND INSTRUMENT_ID = p_customer_bank_account_id;
1707:
1708: IF PG_DEBUG in ('Y', 'C') THEN
1709: ARP_STANDARD.DEBUG('p_pay_from_customer :- ' || p_pay_from_customer );
1710: ARP_STANDARD.DEBUG('p_customer_bank_account_id :- ' || p_customer_bank_account_id );
1711: ARP_STANDARD.DEBUG('l_no_of_accounts :- ' || l_no_of_accounts );
1712: ARP_STANDARD.DEBUG('l_party_id :- ' || l_party_id );
1713: END IF;

Line 1710: ARP_STANDARD.DEBUG('p_customer_bank_account_id :- ' || p_customer_bank_account_id );

1706: AND INSTRUMENT_ID = p_customer_bank_account_id;
1707:
1708: IF PG_DEBUG in ('Y', 'C') THEN
1709: ARP_STANDARD.DEBUG('p_pay_from_customer :- ' || p_pay_from_customer );
1710: ARP_STANDARD.DEBUG('p_customer_bank_account_id :- ' || p_customer_bank_account_id );
1711: ARP_STANDARD.DEBUG('l_no_of_accounts :- ' || l_no_of_accounts );
1712: ARP_STANDARD.DEBUG('l_party_id :- ' || l_party_id );
1713: END IF;
1714:

Line 1711: ARP_STANDARD.DEBUG('l_no_of_accounts :- ' || l_no_of_accounts );

1707:
1708: IF PG_DEBUG in ('Y', 'C') THEN
1709: ARP_STANDARD.DEBUG('p_pay_from_customer :- ' || p_pay_from_customer );
1710: ARP_STANDARD.DEBUG('p_customer_bank_account_id :- ' || p_customer_bank_account_id );
1711: ARP_STANDARD.DEBUG('l_no_of_accounts :- ' || l_no_of_accounts );
1712: ARP_STANDARD.DEBUG('l_party_id :- ' || l_party_id );
1713: END IF;
1714:
1715: IF l_no_of_accounts = 0 THEN

Line 1712: ARP_STANDARD.DEBUG('l_party_id :- ' || l_party_id );

1708: IF PG_DEBUG in ('Y', 'C') THEN
1709: ARP_STANDARD.DEBUG('p_pay_from_customer :- ' || p_pay_from_customer );
1710: ARP_STANDARD.DEBUG('p_customer_bank_account_id :- ' || p_customer_bank_account_id );
1711: ARP_STANDARD.DEBUG('l_no_of_accounts :- ' || l_no_of_accounts );
1712: ARP_STANDARD.DEBUG('l_party_id :- ' || l_party_id );
1713: END IF;
1714:
1715: IF l_no_of_accounts = 0 THEN
1716: SELECT COUNT(*) INTO l_no_of_other_accounts

Line 1722: ARP_STANDARD.DEBUG('l_no_of_other_accounts :- ' || l_no_of_other_accounts );

1718: WHERE NVL(CUST_ACCOUNT_ID, -99) <> p_pay_from_customer
1719: AND INSTRUMENT_ID = p_customer_bank_account_id;
1720:
1721: IF PG_DEBUG in ('Y', 'C') THEN
1722: ARP_STANDARD.DEBUG('l_no_of_other_accounts :- ' || l_no_of_other_accounts );
1723: END IF;
1724:
1725: IF l_no_of_other_accounts = 0 THEN
1726: l_bank_assign_flag := TRUE;

Line 1734: ARP_STANDARD.DEBUG('l_no_of_other_party_accounts :- ' || l_no_of_other_party_accounts );

1730: WHERE PARTY_ID <> l_party_id
1731: AND INSTRUMENT_ID = p_customer_bank_account_id;
1732:
1733: IF PG_DEBUG in ('Y', 'C') THEN
1734: ARP_STANDARD.DEBUG('l_no_of_other_party_accounts :- ' || l_no_of_other_party_accounts );
1735: END IF;
1736:
1737: IF l_no_of_other_party_accounts = 0 THEN
1738: l_bank_assign_flag := TRUE;

Line 1767: ARP_STANDARD.DEBUG('IBY_EXT_BANKACCT_PUB.ADD_JOINT_ACCOUNT_OWNER: Return Status :- ' || l_iby_return_status);

1763: x_msg_data => l_msg_data,
1764: x_response => l_response_rec );
1765:
1766: IF PG_DEBUG in ('Y', 'C') THEN
1767: ARP_STANDARD.DEBUG('IBY_EXT_BANKACCT_PUB.ADD_JOINT_ACCOUNT_OWNER: Return Status :- ' || l_iby_return_status);
1768: END IF;
1769:
1770: IF l_iby_return_status = fnd_api.g_ret_sts_error OR
1771: l_iby_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1773: ARP_STANDARD.DEBUG('Errors Reported By IBY Add Joint Account Owner API :-');

1769:
1770: IF l_iby_return_status = fnd_api.g_ret_sts_error OR
1771: l_iby_return_status = fnd_api.g_ret_sts_unexp_error THEN
1772:
1773: ARP_STANDARD.DEBUG('Errors Reported By IBY Add Joint Account Owner API :-');
1774:
1775: FOR i in 1..l_msg_count LOOP
1776: FND_MSG_PUB.GET(fnd_msg_pub.g_first, fnd_api.g_false, l_msg_data, l_msg_count);
1777: ARP_STANDARD.DEBUG(l_msg_data);

Line 1777: ARP_STANDARD.DEBUG(l_msg_data);

1773: ARP_STANDARD.DEBUG('Errors Reported By IBY Add Joint Account Owner API :-');
1774:
1775: FOR i in 1..l_msg_count LOOP
1776: FND_MSG_PUB.GET(fnd_msg_pub.g_first, fnd_api.g_false, l_msg_data, l_msg_count);
1777: ARP_STANDARD.DEBUG(l_msg_data);
1778: END LOOP;
1779:
1780: ELSE
1781: IF PG_DEBUG in ('Y', 'C') THEN

Line 1782: ARP_STANDARD.DEBUG('Joint Account Owner Id :- ' || l_joint_acct_owner_id );

1778: END LOOP;
1779:
1780: ELSE
1781: IF PG_DEBUG in ('Y', 'C') THEN
1782: ARP_STANDARD.DEBUG('Joint Account Owner Id :- ' || l_joint_acct_owner_id );
1783: END IF;
1784: END IF;
1785:
1786: ARP_EXT_BANK_PKG.INSERT_ACCT_INSTR_ASSIGNMENT(

Line 1795: ARP_STANDARD.DEBUG('Instrument Assignment: l_instr_assign_id :- '||l_instr_assign_id);

1791: x_instr_assign_id => l_instr_assign_id,
1792: x_return_status => l_iby_return_status );
1793:
1794: IF PG_DEBUG in ('Y', 'C') THEN
1795: ARP_STANDARD.DEBUG('Instrument Assignment: l_instr_assign_id :- '||l_instr_assign_id);
1796: ARP_STANDARD.DEBUG('Instrument Assignment: l_iby_return_status :- '||l_iby_return_status);
1797: END IF;
1798:
1799: END IF;

Line 1796: ARP_STANDARD.DEBUG('Instrument Assignment: l_iby_return_status :- '||l_iby_return_status);

1792: x_return_status => l_iby_return_status );
1793:
1794: IF PG_DEBUG in ('Y', 'C') THEN
1795: ARP_STANDARD.DEBUG('Instrument Assignment: l_instr_assign_id :- '||l_instr_assign_id);
1796: ARP_STANDARD.DEBUG('Instrument Assignment: l_iby_return_status :- '||l_iby_return_status);
1797: END IF;
1798:
1799: END IF;
1800: END IF;

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

1831:
1832: EXCEPTION
1833: WHEN OTHERS THEN
1834: IF PG_DEBUG in ('Y', 'C') THEN
1835: arp_standard.debug('Exception in arp_process_receipts.update_cash_receipts');
1836: arp_standard.debug('update_cash_receipt: ' || 'p_cash_receipt_id = '|| to_char(p_cash_receipt_id));
1837: arp_standard.debug('update_cash_receipt: ' || 'p_amount = '|| to_char(p_amount));
1838: arp_standard.debug('update_cash_receipt: ' || 'p_factor_discount_amount = '|| to_char(p_factor_discount_amount));
1839: END IF;

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

1832: EXCEPTION
1833: WHEN OTHERS THEN
1834: IF PG_DEBUG in ('Y', 'C') THEN
1835: arp_standard.debug('Exception in arp_process_receipts.update_cash_receipts');
1836: arp_standard.debug('update_cash_receipt: ' || 'p_cash_receipt_id = '|| to_char(p_cash_receipt_id));
1837: arp_standard.debug('update_cash_receipt: ' || 'p_amount = '|| to_char(p_amount));
1838: arp_standard.debug('update_cash_receipt: ' || 'p_factor_discount_amount = '|| to_char(p_factor_discount_amount));
1839: END IF;
1840: RAISE;

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

1833: WHEN OTHERS THEN
1834: IF PG_DEBUG in ('Y', 'C') THEN
1835: arp_standard.debug('Exception in arp_process_receipts.update_cash_receipts');
1836: arp_standard.debug('update_cash_receipt: ' || 'p_cash_receipt_id = '|| to_char(p_cash_receipt_id));
1837: arp_standard.debug('update_cash_receipt: ' || 'p_amount = '|| to_char(p_amount));
1838: arp_standard.debug('update_cash_receipt: ' || 'p_factor_discount_amount = '|| to_char(p_factor_discount_amount));
1839: END IF;
1840: RAISE;
1841:

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

1834: IF PG_DEBUG in ('Y', 'C') THEN
1835: arp_standard.debug('Exception in arp_process_receipts.update_cash_receipts');
1836: arp_standard.debug('update_cash_receipt: ' || 'p_cash_receipt_id = '|| to_char(p_cash_receipt_id));
1837: arp_standard.debug('update_cash_receipt: ' || 'p_amount = '|| to_char(p_amount));
1838: arp_standard.debug('update_cash_receipt: ' || 'p_factor_discount_amount = '|| to_char(p_factor_discount_amount));
1839: END IF;
1840: RAISE;
1841:
1842: IF PG_DEBUG in ('Y', 'C') THEN

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

1839: END IF;
1840: RAISE;
1841:
1842: IF PG_DEBUG in ('Y', 'C') THEN
1843: arp_standard.debug('arp_process_rct_util.update_cash_receipts()-');
1844: END IF;
1845:
1846: END update_cash_receipt;
1847: