DBA Data[Home] [Help]

APPS.AR_IREC_PAYMENTS dependencies on ARI_UTILITIES

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

1153: -- Bug 3338276
1154: -- If one-time payment is enabled, bank account payment is not enabled;
1155: -- Hence, the check for valid bank account payment methods can be defaulted to 0.
1156: -- Bug 3886652 - Customer Id and Customer Site Use Id added as params to ARI_CONFIG.save_payment_instrument_info
1157: IF NOT ARI_UTILITIES.save_payment_instrument_info(p_customer_id , p_customer_site_id) THEN
1158: l_bank_account_method := 0;
1159: ELSE
1160: l_bank_account_method := is_bank_acc_payment_enabled(p_customer_id , p_customer_site_id , l_currency_code);
1161: END IF;

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

2409: FETCH open_invoice_list BULK COLLECT INTO l_open_invoice_list_rec;
2410: close open_invoice_list;
2411:
2412: --l_grace_days_flag := is_grace_days_enabled_wrapper();
2413: l_grace_days_flag := ARI_UTILITIES.is_discount_grace_days_enabled(p_customer_id,p_customer_site_use_id);
2414:
2415: FOR trx IN l_open_invoice_list_rec.first .. l_open_invoice_list_rec.last loop
2416:
2417: IF (PG_DEBUG = 'Y') THEN

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

2450:
2451:
2452:
2453: BEGIN
2454: l_open_invoice_list_rec(trx).payment_amt := ARI_UTILITIES.curr_round_amt(l_open_invoice_list_rec(trx).AMOUNT_DUE_REMAINING
2455: - l_open_invoice_list_rec(trx).discount_amount - l_open_invoice_list_rec(trx).dispute_amt,
2456: l_open_invoice_list_rec(trx).INVOICE_CURRENCY_CODE);
2457:
2458: EXCEPTION

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

2779: SAVEPOINT cal_disc_and_service_charge_sp;
2780:
2781: -- Check if grace days have to be considered for discount.
2782: --l_grace_days_flag := is_grace_days_enabled_wrapper();
2783: l_grace_days_flag := ARI_UTILITIES.is_discount_grace_days_enabled(p_customer_id,p_site_use_id);
2784:
2785: -- Create the invoice list table
2786: FOR invoice_rec in invoice_list
2787: LOOP

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

4048: -----------------------------------------------------------------------------------------
4049: IF (PG_DEBUG = 'Y') THEN
4050: arp_standard.debug(l_debug_info);
4051: END IF;
4052: IF NOT (ARI_UTILITIES.is_service_charge_enabled(p_customer_id, p_site_use_id)) THEN
4053: RETURN l_total_service_charge;
4054: END IF;
4055:
4056: ----------------------------------------------------------------------------------------

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

4116: l_count := l_invoice_list.FIRST;
4117:
4118: WHILE l_count IS NOT NULL
4119: LOOP
4120: l_service_charge := ARI_UTILITIES.curr_round_amt(l_invoice_list(l_count).service_charge, l_currency_code);
4121:
4122: IF (PG_DEBUG = 'Y') THEN
4123: arp_standard.debug('Index: '|| l_count||' PaymentScheduleId: '||l_invoice_list(l_count).payment_schedule_id ||
4124: 'Service Charge: '||l_invoice_list(l_count).service_charge);

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

4735: ROLLBACK TO ARI_Create_Cash_PVT;
4736: RETURN;
4737: ELSE
4738: -- When payment instrument is created successfully
4739: IF ( ARI_UTILITIES.save_payment_instrument_info(p_customer_id, l_site_use_id) ) THEN
4740: -- If iRec set up is not to save CC then, if update of CC fails we should roll back even create.
4741: -- So here the commit flag is controlled by that profile
4742: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4743: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'ARI_UTILITIES.save_payment_instrument_info is true');

Line 4743: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'ARI_UTILITIES.save_payment_instrument_info is true');

4739: IF ( ARI_UTILITIES.save_payment_instrument_info(p_customer_id, l_site_use_id) ) THEN
4740: -- If iRec set up is not to save CC then, if update of CC fails we should roll back even create.
4741: -- So here the commit flag is controlled by that profile
4742: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4743: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'ARI_UTILITIES.save_payment_instrument_info is true');
4744: end if;
4745: commit;
4746: END IF;
4747: END IF;

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

4927:
4928: -- If service charge has been enabled, adjust the invoice
4929: -- with the service charge
4930: -- Bug 3886652 - Customer Id and Customer Site Use Id added as params to ARI_CONFIG.is_service_charge_enabled
4931: IF ( ARI_UTILITIES.is_service_charge_enabled(p_customer_id, p_site_use_id_srvc_chrg) ) THEN
4932: ---------------------------------------------------------------------------------
4933: l_debug_info := 'Service charge enabled: adjust the invoice with service charge';
4934: ---------------------------------------------------------------------------------
4935: apply_service_charge(p_customer_id, null, x_return_status); -- Bug 9596552

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

5058: -- erase the CC info if setup says not to store this
5059: -- info
5060: -- Bug 3886652 - Customer and Customer Site added to ARI_CONFIG APIs
5061: -- to add flexibility in configuration.
5062: IF NOT ( ARI_UTILITIES.save_payment_instrument_info(p_customer_id, p_site_use_id) ) THEN
5063:
5064: ---------------------------------------------------------------------------------------------------------
5065: l_debug_info := 'Payment instrument information not to be stored, erase the CC information after payment';
5066: ---------------------------------------------------------------------------------------------------------

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

5519: -- Bug 3338276
5520: -- If one-time payment is enabled, bank account payment is not enabled;
5521: -- Hence, the check for valid bank account payment methods can be defaulted to 0.
5522: -- Bug 3886652 - Customer Id and Customer Site Use Id added as params to ARI_CONFIG.save_payment_instrument_info
5523: IF NOT ARI_UTILITIES.save_payment_instrument_info(p_customer_id , p_customer_site_id) THEN
5524: l_bamethodcount := 0;
5525: ELSE
5526: l_bamethodcount := is_bank_acc_payment_enabled(p_customer_id , p_customer_site_id , p_currency_code);
5527: END IF;

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

5651: ELSIF (l_trx_class = 'INV' OR l_trx_class = 'DEP' OR l_trx_class = 'DM' OR l_trx_class = 'CB') THEN
5652: --Bug 6819964 - If AR API errors out then payments are failing as l_discount_amount is not set to any value
5653: begin
5654: --l_grace_days_flag := is_grace_days_enabled_wrapper();
5655: l_grace_days_flag := ARI_UTILITIES.is_discount_grace_days_enabled(p_customer_id,p_customer_site_id);
5656: arp_discounts_api.get_discount(p_ps_id => p_payment_schedule_id,
5657: p_apply_date => trunc(sysdate),
5658: p_in_applied_amount => (l_amount_due_remaining - l_dispute_amount),
5659: p_grace_days_flag => l_grace_days_flag,

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

5761: l_amount_due_remaining,
5762: l_discount_amount,
5763: 0,
5764: DECODE(ps.class, 'PMT', l_amount_due_remaining, 'CM', l_amount_due_remaining,
5765: ARI_UTILITIES.curr_round_amt(l_amount_due_remaining-l_discount_amount -l_dispute_amount,ps.INVOICE_CURRENCY_CODE)),
5766: trm.name term_desc,
5767: ARPT_SQL_FUNC_UTIL.Get_Number_Of_Due_Dates(ps.term_id) number_of_installments,
5768: ps.terms_sequence_number,
5769: ps.amount_line_items_original line_amount,

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

6229: RETURN VARCHAR2 IS
6230: l_save_payment_inst_flag VARCHAR2(6);
6231: BEGIN
6232: -- Bug 3886652 - Customer Id and Customer Site Use Id added as params to ARI_CONFIG.save_payment_instrument_info
6233: if (ARI_UTILITIES.save_payment_instrument_info(p_customer_id, nvl(p_customer_site_use_id,-1))) then
6234: l_save_payment_inst_flag := 'true';
6235: else
6236: l_save_payment_inst_flag := 'false';
6237: end if;

Line 6269: if (ARI_UTILITIES.is_discount_grace_days_enabled) then

6265: +============================================================*/
6266: FUNCTION is_grace_days_enabled_wrapper RETURN VARCHAR2 IS
6267: l_grace_days_flag VARCHAR2(2);
6268: BEGIN
6269: if (ARI_UTILITIES.is_discount_grace_days_enabled) then
6270: l_grace_days_flag := 'Y';
6271: else
6272: l_grace_days_flag := 'N';
6273: end if;

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

6314: WHERE PAYMENT_SCHEDULE_ID = p_ps_id;
6315:
6316: -- Check if grace days have to be considered for discount.
6317: --l_grace_days_flag := is_grace_days_enabled_wrapper();
6318: l_grace_days_flag := ARI_UTILITIES.is_discount_grace_days_enabled(l_customer_id,l_customer_site_use_id);
6319:
6320: arp_discounts_api.get_discount(p_ps_id => p_ps_id,
6321: p_apply_date => trunc(sysdate),
6322: p_in_applied_amount => p_in_applied_amount,