DBA Data[Home] [Help]

APPS.AR_IREC_PAYMENTS dependencies on ARI_UTILITIES

Line 1089: IF NOT ARI_UTILITIES.save_payment_instrument_info(p_customer_id , p_customer_site_id) THEN

1085: -- Bug 3338276
1086: -- If one-time payment is enabled, bank account payment is not enabled;
1087: -- Hence, the check for valid bank account payment methods can be defaulted to 0.
1088: -- Bug 3886652 - Customer Id and Customer Site Use Id added as params to ARI_CONFIG.save_payment_instrument_info
1089: IF NOT ARI_UTILITIES.save_payment_instrument_info(p_customer_id , p_customer_site_id) THEN
1090: l_bank_account_method := 0;
1091: ELSE
1092: l_bank_account_method := is_bank_acc_payment_enabled(p_customer_id , p_customer_site_id , l_currency_code);
1093: END IF;

Line 2301: l_grace_days_flag := ARI_UTILITIES.is_discount_grace_days_enabled(p_customer_id,p_customer_site_use_id);

2297: FETCH open_invoice_list BULK COLLECT INTO l_open_invoice_list_rec;
2298: close open_invoice_list;
2299:
2300: --l_grace_days_flag := is_grace_days_enabled_wrapper();
2301: l_grace_days_flag := ARI_UTILITIES.is_discount_grace_days_enabled(p_customer_id,p_customer_site_use_id);
2302:
2303: FOR trx IN l_open_invoice_list_rec.first .. l_open_invoice_list_rec.last loop
2304:
2305: IF (PG_DEBUG = 'Y') THEN

Line 2342: l_open_invoice_list_rec(trx).payment_amt := ARI_UTILITIES.curr_round_amt(l_open_invoice_list_rec(trx).AMOUNT_DUE_REMAINING

2338:
2339:
2340:
2341: BEGIN
2342: l_open_invoice_list_rec(trx).payment_amt := ARI_UTILITIES.curr_round_amt(l_open_invoice_list_rec(trx).AMOUNT_DUE_REMAINING
2343: - l_open_invoice_list_rec(trx).discount_amount - l_open_invoice_list_rec(trx).dispute_amt,
2344: l_open_invoice_list_rec(trx).INVOICE_CURRENCY_CODE);
2345:
2346: EXCEPTION

Line 2648: l_grace_days_flag := ARI_UTILITIES.is_discount_grace_days_enabled(p_customer_id,p_site_use_id);

2644: SAVEPOINT cal_disc_and_service_charge_sp;
2645:
2646: -- Check if grace days have to be considered for discount.
2647: --l_grace_days_flag := is_grace_days_enabled_wrapper();
2648: l_grace_days_flag := ARI_UTILITIES.is_discount_grace_days_enabled(p_customer_id,p_site_use_id);
2649:
2650: -- Create the invoice list table
2651: FOR invoice_rec in invoice_list
2652: LOOP

Line 3577: IF NOT (ARI_UTILITIES.is_service_charge_enabled(p_customer_id, p_site_use_id)) THEN

3573: -----------------------------------------------------------------------------------------
3574: IF (PG_DEBUG = 'Y') THEN
3575: arp_standard.debug(l_debug_info);
3576: END IF;
3577: IF NOT (ARI_UTILITIES.is_service_charge_enabled(p_customer_id, p_site_use_id)) THEN
3578: RETURN l_total_service_charge;
3579: END IF;
3580:
3581: ----------------------------------------------------------------------------------------

Line 3628: l_service_charge := ARI_UTILITIES.curr_round_amt(l_invoice_list(l_count).service_charge, l_currency_code);

3624: l_count := l_invoice_list.FIRST;
3625:
3626: WHILE l_count IS NOT NULL
3627: LOOP
3628: l_service_charge := ARI_UTILITIES.curr_round_amt(l_invoice_list(l_count).service_charge, l_currency_code);
3629:
3630: IF (PG_DEBUG = 'Y') THEN
3631: arp_standard.debug('Index: '|| l_count||' PaymentScheduleId: '||l_invoice_list(l_count).payment_schedule_id ||
3632: 'Service Charge: '||l_invoice_list(l_count).service_charge);

Line 4168: IF ( ARI_UTILITIES.save_payment_instrument_info(p_customer_id, l_site_use_id) ) THEN

4164: ROLLBACK TO ARI_Create_Cash_PVT;
4165: RETURN;
4166: ELSE
4167: -- When payment instrument is created successfully
4168: IF ( ARI_UTILITIES.save_payment_instrument_info(p_customer_id, l_site_use_id) ) THEN
4169: -- If iRec set up is not to save CC then, if update of CC fails we should roll back even create.
4170: -- So here the commit flag is controlled by that profile
4171: commit;
4172: END IF;

Line 4191: IF ( ARI_UTILITIES.save_payment_instrument_info(p_customer_id, p_site_use_id) ) THEN

4187:
4188: /*------------------------------------+
4189: | Standard start of API savepoint |
4190: +------------------------------------*/
4191: IF ( ARI_UTILITIES.save_payment_instrument_info(p_customer_id, p_site_use_id) ) THEN
4192: SAVEPOINT ARI_Create_Cash_PVT;
4193: END IF;
4194: -----------------------------------------------------------------------------------------
4195: l_debug_info := 'Call public IBY API - create TRANSACTION EXTENSION';

Line 4353: IF ( ARI_UTILITIES.is_service_charge_enabled(p_customer_id, p_site_use_id_srvc_chrg) ) THEN

4349:
4350: -- If service charge has been enabled, adjust the invoice
4351: -- with the service charge
4352: -- Bug 3886652 - Customer Id and Customer Site Use Id added as params to ARI_CONFIG.is_service_charge_enabled
4353: IF ( ARI_UTILITIES.is_service_charge_enabled(p_customer_id, p_site_use_id_srvc_chrg) ) THEN
4354: ---------------------------------------------------------------------------------
4355: l_debug_info := 'Service charge enabled: adjust the invoice with service charge';
4356: ---------------------------------------------------------------------------------
4357: apply_service_charge(p_customer_id, l_site_use_id, x_return_status);

Line 4452: IF NOT ( ARI_UTILITIES.save_payment_instrument_info(p_customer_id, p_site_use_id) ) THEN

4448: -- erase the CC info if setup says not to store this
4449: -- info
4450: -- Bug 3886652 - Customer and Customer Site added to ARI_CONFIG APIs
4451: -- to add flexibility in configuration.
4452: IF NOT ( ARI_UTILITIES.save_payment_instrument_info(p_customer_id, p_site_use_id) ) THEN
4453:
4454: ---------------------------------------------------------------------------------------------------------
4455: l_debug_info := 'Payment instrument information not to be stored, erase the CC information after payment';
4456: ---------------------------------------------------------------------------------------------------------

Line 4889: IF NOT ARI_UTILITIES.save_payment_instrument_info(p_customer_id , p_customer_site_id) THEN

4885: -- Bug 3338276
4886: -- If one-time payment is enabled, bank account payment is not enabled;
4887: -- Hence, the check for valid bank account payment methods can be defaulted to 0.
4888: -- Bug 3886652 - Customer Id and Customer Site Use Id added as params to ARI_CONFIG.save_payment_instrument_info
4889: IF NOT ARI_UTILITIES.save_payment_instrument_info(p_customer_id , p_customer_site_id) THEN
4890: l_bamethodcount := 0;
4891: ELSE
4892: l_bamethodcount := is_bank_acc_payment_enabled(p_customer_id , p_customer_site_id , p_currency_code);
4893: END IF;

Line 5010: l_grace_days_flag := ARI_UTILITIES.is_discount_grace_days_enabled(p_customer_id,p_customer_site_id);

5006: ELSIF (l_trx_class = 'INV' OR l_trx_class = 'DEP' OR l_trx_class = 'DM' OR l_trx_class = 'CB') THEN
5007: --Bug 6819964 - If AR API errors out then payments are failing as l_discount_amount is not set to any value
5008: begin
5009: --l_grace_days_flag := is_grace_days_enabled_wrapper();
5010: l_grace_days_flag := ARI_UTILITIES.is_discount_grace_days_enabled(p_customer_id,p_customer_site_id);
5011: arp_discounts_api.get_discount(p_ps_id => p_payment_schedule_id,
5012: p_apply_date => trunc(sysdate),
5013: p_in_applied_amount => (l_amount_due_remaining - l_dispute_amount),
5014: p_grace_days_flag => l_grace_days_flag,

Line 5120: ARI_UTILITIES.curr_round_amt(l_amount_due_remaining-l_discount_amount -l_dispute_amount,ps.INVOICE_CURRENCY_CODE)),

5116: l_amount_due_remaining,
5117: l_discount_amount,
5118: 0,
5119: DECODE(ps.class, 'PMT', l_amount_due_remaining, 'CM', l_amount_due_remaining,
5120: ARI_UTILITIES.curr_round_amt(l_amount_due_remaining-l_discount_amount -l_dispute_amount,ps.INVOICE_CURRENCY_CODE)),
5121: trm.name term_desc,
5122: ARPT_SQL_FUNC_UTIL.Get_Number_Of_Due_Dates(ps.term_id) number_of_installments,
5123: ps.terms_sequence_number,
5124: ps.amount_line_items_original line_amount,

Line 5586: if (ARI_UTILITIES.save_payment_instrument_info(p_customer_id, nvl(p_customer_site_use_id,-1))) then

5582: RETURN VARCHAR2 IS
5583: l_save_payment_inst_flag VARCHAR2(6);
5584: BEGIN
5585: -- Bug 3886652 - Customer Id and Customer Site Use Id added as params to ARI_CONFIG.save_payment_instrument_info
5586: if (ARI_UTILITIES.save_payment_instrument_info(p_customer_id, nvl(p_customer_site_use_id,-1))) then
5587: l_save_payment_inst_flag := 'true';
5588: else
5589: l_save_payment_inst_flag := 'false';
5590: end if;

Line 5622: if (ARI_UTILITIES.is_discount_grace_days_enabled) then

5618: +============================================================*/
5619: FUNCTION is_grace_days_enabled_wrapper RETURN VARCHAR2 IS
5620: l_grace_days_flag VARCHAR2(2);
5621: BEGIN
5622: if (ARI_UTILITIES.is_discount_grace_days_enabled) then
5623: l_grace_days_flag := 'Y';
5624: else
5625: l_grace_days_flag := 'N';
5626: end if;

Line 5671: l_grace_days_flag := ARI_UTILITIES.is_discount_grace_days_enabled(l_customer_id,l_customer_site_use_id);

5667: WHERE PAYMENT_SCHEDULE_ID = p_ps_id;
5668:
5669: -- Check if grace days have to be considered for discount.
5670: --l_grace_days_flag := is_grace_days_enabled_wrapper();
5671: l_grace_days_flag := ARI_UTILITIES.is_discount_grace_days_enabled(l_customer_id,l_customer_site_use_id);
5672:
5673: arp_discounts_api.get_discount(p_ps_id => p_ps_id,
5674: p_apply_date => trunc(sysdate),
5675: p_in_applied_amount => p_in_applied_amount,