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 ARP_STANDARD

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

224: /*-----------------------------------------------------------------------+
225: | Use for file debug or standard output debug |
226: +-----------------------------------------------------------------------*/
227:
228: -- arp_standard.debug('AR_IREC_PAYMENTS.get_credit_card_type()+');
229:
230: -- arp_standard.debug(' p_credit_card_number :' || p_credit_card_number);
231:
232: l_card_issuer iby_creditcard_issuers_b.card_issuer_code%TYPE;

Line 230: -- arp_standard.debug(' p_credit_card_number :' || p_credit_card_number);

226: +-----------------------------------------------------------------------*/
227:
228: -- arp_standard.debug('AR_IREC_PAYMENTS.get_credit_card_type()+');
229:
230: -- arp_standard.debug(' p_credit_card_number :' || p_credit_card_number);
231:
232: l_card_issuer iby_creditcard_issuers_b.card_issuer_code%TYPE;
233: l_issuer_range iby_cc_issuer_ranges.cc_issuer_range_id%TYPE;
234: l_card_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;

Line 255: -- arp_standard.debug(' l_card_issuer :' || l_card_issuer);

251: FETCH c_range INTO l_issuer_range, l_card_issuer,
252: l_card_prefix, l_digit_check;
253: CLOSE c_range;
254:
255: -- arp_standard.debug(' l_card_issuer :' || l_card_issuer);
256:
257: IF (l_card_issuer IS NULL) THEN
258: l_card_issuer := 'UNKNOWN';
259: l_digit_check := 'N';

Line 328: arp_standard.debug('Trx currency is functional --> no exchange rate');

324: --------------------------------------------------------------------------------
325: l_debug_info := 'Transaction currency is base currency; no exchange rate needed';
326: --------------------------------------------------------------------------------
327: IF (PG_DEBUG = 'Y') THEN
328: arp_standard.debug('Trx currency is functional --> no exchange rate');
329: END IF;
330:
331: p_exchange_rate := NULL;
332: p_exchange_rate_type := NULL;

Line 353: arp_standard.debug('Fixed Rate');

349: --------------------------------------------------------------------------
350: l_debug_info := 'Exchange rate is fixed';
351: --------------------------------------------------------------------------
352: IF (PG_DEBUG = 'Y') THEN
353: arp_standard.debug('Fixed Rate');
354: END IF;
355:
356: p_exchange_rate_type := 'EMU FIXED';
357:

Line 369: arp_standard.debug('Rate = ' || to_char(p_exchange_rate));

365:
366: */
367:
368: IF (PG_DEBUG = 'Y') THEN
369: arp_standard.debug('Rate = ' || to_char(p_exchange_rate));
370: END IF;
371:
372: else -- exchange rate is not fixed --> check profile for default type
373:

Line 378: arp_standard.debug('No Fixed Rate');

374: -------------------------------------------------------------------------------------
375: l_debug_info := 'Exchange rate is not fixed - check profile option for default type';
376: -------------------------------------------------------------------------------------
377: IF (PG_DEBUG = 'Y') THEN
378: arp_standard.debug('No Fixed Rate');
379: END IF;
380: p_exchange_rate_type := fnd_profile.value('AR_DEFAULT_EXCHANGE_RATE_TYPE');
381:
382: IF (PG_DEBUG = 'Y') THEN

Line 383: arp_standard.debug('Profile option default exch rate type: '|| p_exchange_rate_type);

379: END IF;
380: p_exchange_rate_type := fnd_profile.value('AR_DEFAULT_EXCHANGE_RATE_TYPE');
381:
382: IF (PG_DEBUG = 'Y') THEN
383: arp_standard.debug('Profile option default exch rate type: '|| p_exchange_rate_type);
384: END IF;
385:
386: if (p_exchange_rate_type IS NOT NULL) then
387:

Line 399: arp_standard.debug('Rate = ' || to_char(p_exchange_rate));

395: p_exchange_rate_date,
396: p_exchange_rate_type);
397:
398: IF (PG_DEBUG = 'Y') THEN
399: arp_standard.debug('Rate = ' || to_char(p_exchange_rate));
400: END IF;
401:
402: if p_exchange_rate = -1 then -- no rate found in GL
403:

Line 408: arp_standard.debug('no conversion rate found... using trx rate');

404: -------------------------------------------------------------------------------------------
405: l_debug_info := 'Exchange rate not found in GL- use invoice exchange rate';
406: -------------------------------------------------------------------------------------------
407: IF (PG_DEBUG = 'Y') THEN
408: arp_standard.debug('no conversion rate found... using trx rate');
409: END IF;
410:
411: p_exchange_rate_type := 'User';
412: p_exchange_rate := p_trx_exchange_rate;

Line 435: arp_standard.debug('Leaving get_exchange_rate: ');

431:
432: end if; -- fixed/non-fixed rate case
433:
434: IF (PG_DEBUG = 'Y') THEN
435: arp_standard.debug('Leaving get_exchange_rate: ');
436: arp_standard.debug('p_exchange_rate_type = ' || p_exchange_rate_type);
437: arp_standard.debug('p_exchange_rate = ' || to_char(p_exchange_rate));
438: END IF;
439:

Line 436: arp_standard.debug('p_exchange_rate_type = ' || p_exchange_rate_type);

432: end if; -- fixed/non-fixed rate case
433:
434: IF (PG_DEBUG = 'Y') THEN
435: arp_standard.debug('Leaving get_exchange_rate: ');
436: arp_standard.debug('p_exchange_rate_type = ' || p_exchange_rate_type);
437: arp_standard.debug('p_exchange_rate = ' || to_char(p_exchange_rate));
438: END IF;
439:
440: EXCEPTION

Line 437: arp_standard.debug('p_exchange_rate = ' || to_char(p_exchange_rate));

433:
434: IF (PG_DEBUG = 'Y') THEN
435: arp_standard.debug('Leaving get_exchange_rate: ');
436: arp_standard.debug('p_exchange_rate_type = ' || p_exchange_rate_type);
437: arp_standard.debug('p_exchange_rate = ' || to_char(p_exchange_rate));
438: END IF;
439:
440: EXCEPTION
441: WHEN OTHERS THEN

Line 710: arp_standard.debug('There may be invoices with different sites');

706: and customer_site_use_id = nvl(decode(p_site_use_id, -1, null, p_site_use_id), customer_site_use_id);
707: EXCEPTION
708: when others then
709: IF (PG_DEBUG = 'Y') THEN
710: arp_standard.debug('There may be invoices with different sites');
711: END IF;
712: END;
713: if ( l_customer_id is null ) then
714: --Code should not come here ideally

Line 722: arp_standard.debug('There may be invoices with different currencies');

718: group by currency_code;
719: EXCEPTION
720: when others then
721: IF (PG_DEBUG = 'Y') THEN
722: arp_standard.debug('There may be invoices with different currencies');
723: END IF;
724: END;
725: end if;
726: end if;

Line 2017: arp_standard.debug('OIR'|| p_message);

2013:
2014: END IF;
2015:
2016: IF (PG_DEBUG = 'Y') THEN
2017: arp_standard.debug('OIR'|| p_message);
2018: END IF;
2019: EXCEPTION
2020: WHEN others THEN
2021: /*-------------------------------------------------------+

Line 2277: arp_standard.debug(l_debug_info);

2273: ----------------------------------------------------------------------------------------
2274: l_debug_info := 'Clear the transaction list for the active customer, site, currency';
2275: -----------------------------------------------------------------------------------------
2276: IF (PG_DEBUG = 'Y') THEN
2277: arp_standard.debug(l_debug_info);
2278: END IF;
2279:
2280: --Bug # 3467287 - The Global Temp table must be striped by Customer and Customer Site.
2281: DELETE FROM AR_IREC_PAYMENT_LIST_GT

Line 2290: arp_standard.debug(l_debug_info);

2286: ----------------------------------------------------------------------------------------
2287: l_debug_info := 'Fetch all the rows into the global temporary table';
2288: -----------------------------------------------------------------------------------------
2289: IF (PG_DEBUG = 'Y') THEN
2290: arp_standard.debug(l_debug_info);
2291: END IF;
2292:
2293: Open open_invoice_list(p_customer_id,
2294: p_customer_site_use_id,

Line 2306: arp_standard.debug('Inserting: '||l_open_invoice_list_rec(trx).trx_number);

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
2306: arp_standard.debug('Inserting: '||l_open_invoice_list_rec(trx).trx_number);
2307: END IF;
2308:
2309: ----------------------------------------------------------------------------------------
2310: l_debug_info := 'Calculate discount';

Line 2313: arp_standard.debug(l_debug_info);

2309: ----------------------------------------------------------------------------------------
2310: l_debug_info := 'Calculate discount';
2311: -----------------------------------------------------------------------------------------
2312: IF (PG_DEBUG = 'Y') THEN
2313: arp_standard.debug(l_debug_info);
2314: END IF;
2315:
2316:
2317: arp_discounts_api.get_discount(p_ps_id => l_open_invoice_list_rec(trx).payment_schedule_id,

Line 2360: arp_standard.debug(l_debug_info);

2356: ----------------------------------------------------------------------------------------
2357: l_debug_info := 'Compute service charge';
2358: -----------------------------------------------------------------------------------------
2359: IF (PG_DEBUG = 'Y') THEN
2360: arp_standard.debug(l_debug_info);
2361: END IF;
2362: l_total_service_charge := get_service_charge(p_customer_id, p_customer_site_use_id);
2363:
2364: COMMIT;

Line 2369: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);

2365:
2366: EXCEPTION
2367: WHEN OTHERS THEN
2368: IF (PG_DEBUG = 'Y') THEN
2369: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2370: arp_standard.debug('- Customer Id: '||p_customer_id);
2371: arp_standard.debug('- Customer Site Use Id: '|| p_customer_site_use_id);
2372: arp_standard.debug('- Currency Code: '||p_currency_code);
2373: arp_standard.debug('- Payment Schedule Id: '||p_payment_schedule_id);

Line 2370: arp_standard.debug('- Customer Id: '||p_customer_id);

2366: EXCEPTION
2367: WHEN OTHERS THEN
2368: IF (PG_DEBUG = 'Y') THEN
2369: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2370: arp_standard.debug('- Customer Id: '||p_customer_id);
2371: arp_standard.debug('- Customer Site Use Id: '|| p_customer_site_use_id);
2372: arp_standard.debug('- Currency Code: '||p_currency_code);
2373: arp_standard.debug('- Payment Schedule Id: '||p_payment_schedule_id);
2374: arp_standard.debug('ERROR =>'|| SQLERRM);

Line 2371: arp_standard.debug('- Customer Site Use Id: '|| p_customer_site_use_id);

2367: WHEN OTHERS THEN
2368: IF (PG_DEBUG = 'Y') THEN
2369: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2370: arp_standard.debug('- Customer Id: '||p_customer_id);
2371: arp_standard.debug('- Customer Site Use Id: '|| p_customer_site_use_id);
2372: arp_standard.debug('- Currency Code: '||p_currency_code);
2373: arp_standard.debug('- Payment Schedule Id: '||p_payment_schedule_id);
2374: arp_standard.debug('ERROR =>'|| SQLERRM);
2375: END IF;

Line 2372: arp_standard.debug('- Currency Code: '||p_currency_code);

2368: IF (PG_DEBUG = 'Y') THEN
2369: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2370: arp_standard.debug('- Customer Id: '||p_customer_id);
2371: arp_standard.debug('- Customer Site Use Id: '|| p_customer_site_use_id);
2372: arp_standard.debug('- Currency Code: '||p_currency_code);
2373: arp_standard.debug('- Payment Schedule Id: '||p_payment_schedule_id);
2374: arp_standard.debug('ERROR =>'|| SQLERRM);
2375: END IF;
2376:

Line 2373: arp_standard.debug('- Payment Schedule Id: '||p_payment_schedule_id);

2369: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2370: arp_standard.debug('- Customer Id: '||p_customer_id);
2371: arp_standard.debug('- Customer Site Use Id: '|| p_customer_site_use_id);
2372: arp_standard.debug('- Currency Code: '||p_currency_code);
2373: arp_standard.debug('- Payment Schedule Id: '||p_payment_schedule_id);
2374: arp_standard.debug('ERROR =>'|| SQLERRM);
2375: END IF;
2376:
2377: ROLLBACK TO create_invoice_pay_list_sp;

Line 2374: arp_standard.debug('ERROR =>'|| SQLERRM);

2370: arp_standard.debug('- Customer Id: '||p_customer_id);
2371: arp_standard.debug('- Customer Site Use Id: '|| p_customer_site_use_id);
2372: arp_standard.debug('- Currency Code: '||p_currency_code);
2373: arp_standard.debug('- Payment Schedule Id: '||p_payment_schedule_id);
2374: arp_standard.debug('ERROR =>'|| SQLERRM);
2375: END IF;
2376:
2377: ROLLBACK TO create_invoice_pay_list_sp;
2378:

Line 2526: arp_standard.debug(l_debug_info);

2522: ---------------------------------------------------------------------------
2523: l_debug_info := 'Fetch all open credit transactions into Payment List GT';
2524: ---------------------------------------------------------------------------
2525: IF (PG_DEBUG = 'Y') THEN
2526: arp_standard.debug(l_debug_info);
2527: END IF;
2528:
2529: Open credit_transactions_list(p_customer_id,
2530: p_customer_site_use_id,

Line 2550: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);

2546:
2547: EXCEPTION
2548: WHEN OTHERS THEN
2549: IF (PG_DEBUG = 'Y') THEN
2550: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2551: arp_standard.debug('- Customer Id: '||p_customer_id);
2552: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
2553: arp_standard.debug('- Currency Code: '||p_currency_code);
2554: arp_standard.debug('ERROR =>'|| SQLERRM);

Line 2551: arp_standard.debug('- Customer Id: '||p_customer_id);

2547: EXCEPTION
2548: WHEN OTHERS THEN
2549: IF (PG_DEBUG = 'Y') THEN
2550: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2551: arp_standard.debug('- Customer Id: '||p_customer_id);
2552: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
2553: arp_standard.debug('- Currency Code: '||p_currency_code);
2554: arp_standard.debug('ERROR =>'|| SQLERRM);
2555: END IF;

Line 2552: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);

2548: WHEN OTHERS THEN
2549: IF (PG_DEBUG = 'Y') THEN
2550: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2551: arp_standard.debug('- Customer Id: '||p_customer_id);
2552: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
2553: arp_standard.debug('- Currency Code: '||p_currency_code);
2554: arp_standard.debug('ERROR =>'|| SQLERRM);
2555: END IF;
2556:

Line 2553: arp_standard.debug('- Currency Code: '||p_currency_code);

2549: IF (PG_DEBUG = 'Y') THEN
2550: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2551: arp_standard.debug('- Customer Id: '||p_customer_id);
2552: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
2553: arp_standard.debug('- Currency Code: '||p_currency_code);
2554: arp_standard.debug('ERROR =>'|| SQLERRM);
2555: END IF;
2556:
2557: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');

Line 2554: arp_standard.debug('ERROR =>'|| SQLERRM);

2550: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2551: arp_standard.debug('- Customer Id: '||p_customer_id);
2552: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
2553: arp_standard.debug('- Currency Code: '||p_currency_code);
2554: arp_standard.debug('ERROR =>'|| SQLERRM);
2555: END IF;
2556:
2557: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
2558: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);

Line 2657: arp_standard.debug(l_debug_info);

2653: ---------------------------------------------------------------------------
2654: l_debug_info := 'Calculate discount';
2655: ---------------------------------------------------------------------------
2656: IF (PG_DEBUG = 'Y') THEN
2657: arp_standard.debug(l_debug_info);
2658: END IF;
2659: l_prev_disc_amt := invoice_rec.discount_amount;
2660: l_payment_amount := invoice_rec.payment_amount;
2661: l_amt_due_remaining := invoice_rec.amount_due_remaining;

Line 2671: arp_standard.debug('Trx: '||invoice_rec.payment_schedule_id||

2667: p_out_rem_amt_rcpt => l_rem_amt_rcpt,
2668: p_out_rem_amt_inv => l_rem_amt_inv);
2669:
2670: IF (PG_DEBUG = 'Y') THEN
2671: arp_standard.debug('Trx: '||invoice_rec.payment_schedule_id||
2672: ' Discount: '||l_discount_amount||
2673: ' Rcpt: '||l_rem_amt_rcpt||
2674: ' Inv: '||l_rem_amt_inv);
2675: END IF;

Line 2688: arp_standard.debug(l_debug_info);

2684: -----------------------------------------------------------------------------------------
2685: l_debug_info := 'Update transaction list with discount and receipt date';
2686: -----------------------------------------------------------------------------------------
2687: IF (PG_DEBUG = 'Y') THEN
2688: arp_standard.debug(l_debug_info);
2689: END IF;
2690: UPDATE AR_IREC_PAYMENT_LIST_GT
2691: SET discount_amount = l_discount_amount,
2692: receipt_date = trunc(p_receipt_date),

Line 2702: arp_standard.debug(l_debug_info);

2698: -----------------------------------------------------------------------------------------
2699: l_debug_info := 'Compute service charge';
2700: -----------------------------------------------------------------------------------------
2701: IF (PG_DEBUG = 'Y') THEN
2702: arp_standard.debug(l_debug_info);
2703: END IF;
2704: -- Bug # 3467287 - The service charge calculator API is striped by
2705: -- Customer and Customer Site.
2706: -- Bug 3886652 - Customer Id and Customer Site Use Id added as params to ARI_CONFIG.is_service_charge_enabled

Line 2943: arp_standard.debug(l_debug_info);

2939: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Payment Instrument - Credit Card Number - '||p_account_number);
2940: end if;
2941:
2942: IF (PG_DEBUG = 'Y') THEN
2943: arp_standard.debug(l_debug_info);
2944: END IF;
2945:
2946:
2947: EXCEPTION

Line 3168: arp_standard.debug('X_RETURN_STATUS=>'||X_RETURN_STATUS);

3164: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Cash - Message Data - '||x_msg_data);
3165: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Cash - CR Id - '||l_cash_receipt_id);
3166: end if;
3167:
3168: arp_standard.debug('X_RETURN_STATUS=>'||X_RETURN_STATUS);
3169: arp_standard.debug('X_MSG_COUNT=>'||to_char(X_MSG_COUNT));
3170:
3171: EXCEPTION
3172: WHEN OTHERS THEN

Line 3169: arp_standard.debug('X_MSG_COUNT=>'||to_char(X_MSG_COUNT));

3165: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Cash - CR Id - '||l_cash_receipt_id);
3166: end if;
3167:
3168: arp_standard.debug('X_RETURN_STATUS=>'||X_RETURN_STATUS);
3169: arp_standard.debug('X_MSG_COUNT=>'||to_char(X_MSG_COUNT));
3170:
3171: EXCEPTION
3172: WHEN OTHERS THEN
3173: p_status := FND_API.G_RET_STS_ERROR;

Line 3575: arp_standard.debug(l_debug_info);

3571: ----------------------------------------------------------------------------------------
3572: l_debug_info := 'Check if service charge is enabled; else return zero';
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;

Line 3585: arp_standard.debug(l_debug_info);

3581: ----------------------------------------------------------------------------------------
3582: l_debug_info := 'Create the invoice list table';
3583: -----------------------------------------------------------------------------------------
3584: IF (PG_DEBUG = 'Y') THEN
3585: arp_standard.debug(l_debug_info);
3586: END IF;
3587:
3588: FOR invoice_rec in invoice_list
3589: LOOP

Line 3595: arp_standard.debug('Index: '||l_count);

3591: --Bug 4071551 - Changed the indexing field to Payment Schedule Id from Customer Trx Id to keep uniqueness
3592: l_count := invoice_rec.payment_schedule_id;
3593:
3594: IF (PG_DEBUG = 'Y') THEN
3595: arp_standard.debug('Index: '||l_count);
3596: END IF;
3597:
3598: l_invoice_list(l_count).payment_schedule_id := invoice_rec.payment_schedule_id;
3599: l_invoice_list(l_count).payment_amount := invoice_rec.payment_amount;

Line 3613: arp_standard.debug('End first Loop. Total records: '||l_invoice_list.COUNT);

3609:
3610: END LOOP;
3611:
3612: IF (PG_DEBUG = 'Y') THEN
3613: arp_standard.debug('End first Loop. Total records: '||l_invoice_list.COUNT);
3614: END IF;
3615:
3616: ----------------------------------------------------------------------------------------
3617: l_debug_info := 'Call the service charge package to compute';

Line 3620: arp_standard.debug(l_debug_info);

3616: ----------------------------------------------------------------------------------------
3617: l_debug_info := 'Call the service charge package to compute';
3618: -----------------------------------------------------------------------------------------
3619: IF (PG_DEBUG = 'Y') THEN
3620: arp_standard.debug(l_debug_info);
3621: END IF;
3622: ARI_SERVICE_CHARGE_PKG.compute_service_charge(l_invoice_list);
3623:
3624: l_count := l_invoice_list.FIRST;

Line 3631: arp_standard.debug('Index: '|| l_count||' PaymentScheduleId: '||l_invoice_list(l_count).payment_schedule_id ||

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);
3633: END IF;
3634:
3635: ----------------------------------------------------------------------------------------

Line 3639: arp_standard.debug(l_debug_info);

3635: ----------------------------------------------------------------------------------------
3636: l_debug_info := 'Update service charge in the Payment GT';
3637: -----------------------------------------------------------------------------------------
3638: IF (PG_DEBUG = 'Y') THEN
3639: arp_standard.debug(l_debug_info);
3640: END IF;
3641: UPDATE ar_irec_payment_list_gt
3642: SET service_charge = l_service_charge
3643: WHERE payment_schedule_id = l_invoice_list(l_count).payment_schedule_id;

Line 3650: arp_standard.debug('Error - Cannot update '||l_count);

3646:
3647: -- Error handling required
3648: IF SQL%ROWCOUNT < 1 THEN
3649: IF (PG_DEBUG = 'Y') THEN
3650: arp_standard.debug('Error - Cannot update '||l_count);
3651: END IF;
3652: END IF;
3653:
3654: l_count := l_invoice_list.NEXT(l_count);

Line 3989: arp_standard.debug('There may be multiple invoices for payment');

3985: and customer_site_use_id = nvl(l_site_use_id, customer_site_use_id);
3986: EXCEPTION
3987: when others then
3988: IF (PG_DEBUG = 'Y') THEN
3989: arp_standard.debug('There may be multiple invoices for payment');
3990: END IF;
3991: END;
3992:
3993: ---------------------------------------------------------------------------

Line 4070: arp_standard.debug('Error getting currency code');

4066: --group by currency_code;
4067: EXCEPTION
4068: when others then
4069: IF (PG_DEBUG = 'Y') THEN
4070: arp_standard.debug('Error getting currency code');
4071: END IF;
4072: END;
4073: END IF;
4074:

Line 4325: arp_standard.debug('create receipt --> ' || x_return_status || 'receipt id --> ' || p_cash_receipt_id);

4321: x_msg_count => l_msg_count,
4322: x_msg_data => l_msg_data
4323: );
4324:
4325: arp_standard.debug('create receipt --> ' || x_return_status || 'receipt id --> ' || p_cash_receipt_id);
4326: arp_standard.debug('X_RETURN_STATUS=>'||X_RETURN_STATUS);
4327:
4328: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4329: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Done with receipt creation ....');

Line 4326: arp_standard.debug('X_RETURN_STATUS=>'||X_RETURN_STATUS);

4322: x_msg_data => l_msg_data
4323: );
4324:
4325: arp_standard.debug('create receipt --> ' || x_return_status || 'receipt id --> ' || p_cash_receipt_id);
4326: arp_standard.debug('X_RETURN_STATUS=>'||X_RETURN_STATUS);
4327:
4328: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4329: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Done with receipt creation ....');
4330: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Return Status: '||x_return_status);

Line 4653: arp_standard.debug('Entering credit card processing...'||p_cash_receipt_id);

4649: --Assign default values
4650: l_return_status := FND_API.G_RET_STS_SUCCESS;
4651: l_procedure_name := '.process_payment';
4652:
4653: arp_standard.debug('Entering credit card processing...'||p_cash_receipt_id);
4654: ---------------------------------------------------------------------------------
4655: l_debug_info := 'Entering credit card processing';
4656: ---------------------------------------------------------------------------------
4657: OPEN rct_info_cur;

Line 4680: arp_standard.debug('ERROR: Creation status is ' || rct_info.creation_status);

4676: l_action := 'AUTHANDCAPTURE';
4677: elsif rct_info.creation_status = 'CONFIRMED' THEN
4678: l_action := 'AUTHONLY';
4679: else
4680: arp_standard.debug('ERROR: Creation status is ' || rct_info.creation_status);
4681: FND_MESSAGE.set_name('AR', 'AR_PAY_PROCESS_INVALID_STATUS');
4682: FND_MSG_PUB.Add;
4683:
4684: x_return_status := FND_API.G_RET_STS_ERROR; -- should never happen

Line 4737: arp_standard.debug('l_return_status: ' || l_return_status);

4733: p_amount => l_amount_rec,
4734: x_auth_result => x_auth_result,
4735: x_response => x_response);
4736:
4737: arp_standard.debug('l_return_status: ' || l_return_status);
4738:
4739: x_msg_count := l_msg_count;
4740: x_msg_data := l_msg_data;
4741: p_response_error_code := x_response.Result_Code ;

Line 4817: arp_standard.debug('-------------------------------------');

4813: x_msg_count := l_msg_count;
4814: x_msg_data := l_msg_data;
4815: p_response_error_code := x_response.Result_Code;
4816:
4817: arp_standard.debug('-------------------------------------');
4818: arp_standard.debug('x_response.Result_Code: ' ||x_response.Result_Code);
4819: arp_standard.debug('x_response.Result_Category: ' || x_response.Result_Category);
4820: arp_standard.debug('x_response.Result_Message: ' || x_response.Result_Message);
4821:

Line 4818: arp_standard.debug('x_response.Result_Code: ' ||x_response.Result_Code);

4814: x_msg_data := l_msg_data;
4815: p_response_error_code := x_response.Result_Code;
4816:
4817: arp_standard.debug('-------------------------------------');
4818: arp_standard.debug('x_response.Result_Code: ' ||x_response.Result_Code);
4819: arp_standard.debug('x_response.Result_Category: ' || x_response.Result_Category);
4820: arp_standard.debug('x_response.Result_Message: ' || x_response.Result_Message);
4821:
4822: arp_standard.debug('-------------------------------------');

Line 4819: arp_standard.debug('x_response.Result_Category: ' || x_response.Result_Category);

4815: p_response_error_code := x_response.Result_Code;
4816:
4817: arp_standard.debug('-------------------------------------');
4818: arp_standard.debug('x_response.Result_Code: ' ||x_response.Result_Code);
4819: arp_standard.debug('x_response.Result_Category: ' || x_response.Result_Category);
4820: arp_standard.debug('x_response.Result_Message: ' || x_response.Result_Message);
4821:
4822: arp_standard.debug('-------------------------------------');
4823:

Line 4820: arp_standard.debug('x_response.Result_Message: ' || x_response.Result_Message);

4816:
4817: arp_standard.debug('-------------------------------------');
4818: arp_standard.debug('x_response.Result_Code: ' ||x_response.Result_Code);
4819: arp_standard.debug('x_response.Result_Category: ' || x_response.Result_Category);
4820: arp_standard.debug('x_response.Result_Message: ' || x_response.Result_Message);
4821:
4822: arp_standard.debug('-------------------------------------');
4823:
4824: --Add message to message stack only it it is called from iReceivables

Line 4822: arp_standard.debug('-------------------------------------');

4818: arp_standard.debug('x_response.Result_Code: ' ||x_response.Result_Code);
4819: arp_standard.debug('x_response.Result_Category: ' || x_response.Result_Category);
4820: arp_standard.debug('x_response.Result_Message: ' || x_response.Result_Message);
4821:
4822: arp_standard.debug('-------------------------------------');
4823:
4824: --Add message to message stack only it it is called from iReceivables
4825: --if not pass the message stack received from iPayment
4826:

Line 4989: arp_standard.debug(l_debug_info);

4985: ----------------------------------------------------------------------------------------
4986: l_debug_info := 'If the transaction is a Payment, then set the Remaining Amount';
4987: -----------------------------------------------------------------------------------------
4988: IF (PG_DEBUG = 'Y') THEN
4989: arp_standard.debug(l_debug_info);
4990: END IF;
4991: -- Bug 4000279 - Modified to check for 'UNAPP' status only
4992: IF (l_trx_class = 'PMT') THEN
4993:

Line 5004: arp_standard.debug(l_debug_info);

5000: ----------------------------------------------------------------------------------------
5001: l_debug_info := 'If the transaction is a debit, then calculate discount';
5002: -----------------------------------------------------------------------------------------
5003: IF (PG_DEBUG = 'Y') THEN
5004: arp_standard.debug(l_debug_info);
5005: END IF;
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

Line 5032: arp_standard.debug(l_debug_info);

5028: ----------------------------------------------------------------------------------------
5029: l_debug_info := 'Populate the Payment GT with the transaction';
5030: -----------------------------------------------------------------------------------------
5031: IF (PG_DEBUG = 'Y') THEN
5032: arp_standard.debug(l_debug_info);
5033: END IF;
5034:
5035: INSERT INTO AR_IREC_PAYMENT_LIST_GT
5036: ( CUSTOMER_ID,

Line 5184: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);

5180:
5181: EXCEPTION
5182: WHEN OTHERS THEN
5183: IF (PG_DEBUG = 'Y') THEN
5184: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
5185: arp_standard.debug('- Payment Schedule Id: '||p_payment_schedule_id);
5186: arp_standard.debug('ERROR =>'|| SQLERRM);
5187: END IF;
5188:

Line 5185: arp_standard.debug('- Payment Schedule Id: '||p_payment_schedule_id);

5181: EXCEPTION
5182: WHEN OTHERS THEN
5183: IF (PG_DEBUG = 'Y') THEN
5184: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
5185: arp_standard.debug('- Payment Schedule Id: '||p_payment_schedule_id);
5186: arp_standard.debug('ERROR =>'|| SQLERRM);
5187: END IF;
5188:
5189: ROLLBACK to create_trx_list_record_sp;

Line 5186: arp_standard.debug('ERROR =>'|| SQLERRM);

5182: WHEN OTHERS THEN
5183: IF (PG_DEBUG = 'Y') THEN
5184: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
5185: arp_standard.debug('- Payment Schedule Id: '||p_payment_schedule_id);
5186: arp_standard.debug('ERROR =>'|| SQLERRM);
5187: END IF;
5188:
5189: ROLLBACK to create_trx_list_record_sp;
5190:

Line 5259: arp_standard.debug(l_debug_info);

5255: --------------------------------------------------------------------
5256: l_debug_info := 'Checking if valid CC payment method is set in the profile OIR_CC_PMT_METHOD';
5257: --------------------------------------------------------------------
5258: IF (PG_DEBUG = 'Y') THEN
5259: arp_standard.debug(l_debug_info);
5260: END IF;
5261:
5262: profile_cc_payment_method := FND_PROFILE.value('OIR_CC_PMT_METHOD');
5263:

Line 5444: arp_standard.debug(l_debug_info);

5440: --------------------------------------------------------------------
5441: l_debug_info := 'Checking if valid Bank Account payment method is set in the profile OIR_BA_PMT_METHOD';
5442: --------------------------------------------------------------------
5443: IF (PG_DEBUG = 'Y') THEN
5444: arp_standard.debug(l_debug_info);
5445: END IF;
5446:
5447: profile_ba_payment_method := FND_PROFILE.value('OIR_BA_PMT_METHOD');
5448:

Line 5771: arp_standard.debug(l_debug_info);

5767: -----------------------------------------------------------------------------------------
5768: l_debug_info := 'Update transaction list with original discount and payment amount';
5769: -----------------------------------------------------------------------------------------
5770: IF (PG_DEBUG = 'Y') THEN
5771: arp_standard.debug(l_debug_info);
5772: END IF;
5773: --Striping by currency code is not required because
5774: --it is not possible to navigate to Payment page with multiple currencies
5775: --in the Transaction List for a cusomer context

Line 5786: arp_standard.debug(l_debug_info);

5782: -----------------------------------------------------------------------------------------
5783: l_debug_info := 'Compute service charge';
5784: -----------------------------------------------------------------------------------------
5785: IF (PG_DEBUG = 'Y') THEN
5786: arp_standard.debug(l_debug_info);
5787: END IF;
5788: l_total_service_charge := get_service_charge(p_customer_id, p_site_use_id);
5789:
5790: COMMIT;