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.AR_IREC_PAYMENTS dependencies on AR_IREC_PAYMENTS

Line 1: PACKAGE BODY AR_IREC_PAYMENTS AS

1: PACKAGE BODY AR_IREC_PAYMENTS AS
2: /* $Header: ARIRPMTB.pls 120.99.12020000.19 2013/03/29 09:26:04 melapaku ship $ */
3:
4: /*=======================================================================+
5: | Package Global Constants

Line 7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AR_IREC_PAYMENTS';

3:
4: /*=======================================================================+
5: | Package Global Constants
6: +=======================================================================*/
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AR_IREC_PAYMENTS';
8: G_CREATION_FAILED CONSTANT VARCHAR2(30) := 'CREATION_FAILED';
9: G_APP_FAILED CONSTANT VARCHAR2(30) := 'APP_FAILED';
10: G_SVC_FAILED CONSTANT VARCHAR2(30) := 'SVC_FAILED';
11: G_CC_AUTH_FAILED CONSTANT VARCHAR2(30) := 'CC_AUTH_FAILED';

Line 141: arp_util.debug('ar_irec_payments_pkg.is_credit_card_number_valid()+0');

137: l_actual_cc_check_digit number := 0; /* First digit of credit card, numbered from right to left */
138: l_mod10_check_digit number := 0; /* Check digit after mod10 algorithm is applied */
139: j number := 0; /* Product table index */
140: BEGIN
141: arp_util.debug('ar_irec_payments_pkg.is_credit_card_number_valid()+0');
142:
143: SELECT lengthb(p_credit_card_number)
144: INTO l_len_credit_card_num
145: FROM dual;

Line 187: arp_util.debug('ar_irec_payments_pkg.is_credit_card_number_valid()-');

183: -- If actual check digit and check_digit after mod10 don't match, the credit card is an invalid one.
184: IF ( l_mod10_check_digit <> l_actual_cc_check_digit)
185: THEN
186: arp_util.debug('Card is Valid');
187: arp_util.debug('ar_irec_payments_pkg.is_credit_card_number_valid()-');
188: return(0);
189: ELSE
190: arp_util.debug('Card is not Valid');
191: arp_util.debug('ar_irec_payments_pkg.is_credit_card_number_valid()-');

Line 191: arp_util.debug('ar_irec_payments_pkg.is_credit_card_number_valid()-');

187: arp_util.debug('ar_irec_payments_pkg.is_credit_card_number_valid()-');
188: return(0);
189: ELSE
190: arp_util.debug('Card is not Valid');
191: arp_util.debug('ar_irec_payments_pkg.is_credit_card_number_valid()-');
192: return(1);
193: END IF;
194:
195: END is_credit_card_number_valid;

Line 234: -- arp_standard.debug('AR_IREC_PAYMENTS.get_credit_card_type()+');

230: /*-----------------------------------------------------------------------+
231: | Use for file debug or standard output debug |
232: +-----------------------------------------------------------------------*/
233:
234: -- arp_standard.debug('AR_IREC_PAYMENTS.get_credit_card_type()+');
235:
236: -- arp_standard.debug(' p_credit_card_number :' || p_credit_card_number);
237:
238: l_card_issuer iby_creditcard_issuers_b.card_issuer_code%TYPE;

Line 1504: if(ar_irec_payments.is_credit_card_payment_enabled(p_customer_id , p_customer_site_use_id , p_currency_code) = 1) then

1500:
1501: -- bank_branch_id will be always 1 for CC , -- bug 7712779
1502:
1503: if(last_used_instr_rec.bank_branch_id = 1) then
1504: if(ar_irec_payments.is_credit_card_payment_enabled(p_customer_id , p_customer_site_use_id , p_currency_code) = 1) then
1505: p_bank_account_num_masked := last_used_instr_rec.bank_account_num_masked;
1506: p_credit_card_expired := last_used_instr_rec.credit_card_expired;
1507: p_account_type := last_used_instr_rec.account_type;
1508: p_expiry_month := last_used_instr_rec.expiry_month;

Line 1526: if(ar_irec_payments.is_bank_acc_payment_enabled(p_customer_id , p_customer_site_use_id , p_currency_code)=1) then

1522:
1523: else
1524: -- bug 7712779
1525:
1526: if(ar_irec_payments.is_bank_acc_payment_enabled(p_customer_id , p_customer_site_use_id , p_currency_code)=1) then
1527: p_bank_account_num_masked := last_used_instr_rec.bank_account_num_masked;
1528: p_credit_card_expired := last_used_instr_rec.credit_card_expired;
1529: p_account_type := last_used_instr_rec.account_type;
1530: p_expiry_month := last_used_instr_rec.expiry_month;

Line 1586: if(ar_irec_payments.is_bank_acc_payment_enabled(p_customer_id , p_customer_site_use_id , p_currency_code) = 0) then

1582: FOR bank_account_rec IN bank_account_cur LOOP
1583:
1584: -- bug 7712779
1585:
1586: if(ar_irec_payments.is_bank_acc_payment_enabled(p_customer_id , p_customer_site_use_id , p_currency_code) = 0) then
1587: EXIT;
1588: end if;
1589:
1590: --If there are any BA, in the first iteration read those values.

Line 1625: if(ar_irec_payments.is_credit_card_payment_enabled(p_customer_id , p_customer_site_use_id , p_currency_code)=0) then

1621: FOR credit_card_rec IN credit_card_cur LOOP
1622:
1623: -- bug 7712779
1624:
1625: if(ar_irec_payments.is_credit_card_payment_enabled(p_customer_id , p_customer_site_use_id , p_currency_code)=0) then
1626: EXIT;
1627: end if;
1628:
1629: IF(l_ba_count <>1 AND l_cc_count = 0) THEN

Line 2567: DECODE (ps.class, 'PMT', ar_irec_payments.get_pymt_amnt_due_remaining(ps.cash_receipt_id),ps.AMOUNT_DUE_REMAINING) as AMOUNT_DUE_REMAINING,

2563: ps.freight_original freight_amount,
2564: ps.receivables_charges_charged finance_charge,
2565: ps.INVOICE_CURRENCY_CODE,
2566: ps.AMOUNT_DUE_ORIGINAL,
2567: DECODE (ps.class, 'PMT', ar_irec_payments.get_pymt_amnt_due_remaining(ps.cash_receipt_id),ps.AMOUNT_DUE_REMAINING) as AMOUNT_DUE_REMAINING,
2568: 0 payment_amt,
2569: 0 service_charge,
2570: 0 discount_amount,
2571: case WHEN ((trunc(ps.trx_date) - trunc(sysdate)) <= 0) then TRUNC(SYSDATE) else ps.trx_date end as receipt_date,

Line 6903: END AR_IREC_PAYMENTS;

6899: return l_discount_amount;
6900: end;
6901: END;
6902:
6903: END AR_IREC_PAYMENTS;