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 STANDARD

Line 231: | Use for file debug or standard output debug |

227: FUNCTION get_credit_card_type( p_credit_card_number IN VARCHAR2 )
228: RETURN VARCHAR2 IS
229:
230: /*-----------------------------------------------------------------------+
231: | Use for file debug or standard output debug |
232: +-----------------------------------------------------------------------*/
233:
234: -- arp_standard.debug('AR_IREC_PAYMENTS.get_credit_card_type()+');
235:

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 236: -- arp_standard.debug(' p_credit_card_number :' || p_credit_card_number);

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;
239: l_issuer_range iby_cc_issuer_ranges.cc_issuer_range_id%TYPE;
240: l_card_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;

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

257: FETCH c_range INTO l_issuer_range, l_card_issuer,
258: l_card_prefix, l_digit_check;
259: CLOSE c_range;
260:
261: -- arp_standard.debug(' l_card_issuer :' || l_card_issuer);
262:
263: IF (l_card_issuer IS NULL) THEN
264: l_card_issuer := 'UNKNOWN';
265: l_digit_check := 'N';

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

330: --------------------------------------------------------------------------------
331: l_debug_info := 'Transaction currency is base currency; no exchange rate needed';
332: --------------------------------------------------------------------------------
333: IF (PG_DEBUG = 'Y') THEN
334: arp_standard.debug('Trx currency is functional --> no exchange rate');
335: END IF;
336:
337: p_exchange_rate := NULL;
338: p_exchange_rate_type := NULL;

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

355: --------------------------------------------------------------------------
356: l_debug_info := 'Exchange rate is fixed';
357: --------------------------------------------------------------------------
358: IF (PG_DEBUG = 'Y') THEN
359: arp_standard.debug('Fixed Rate');
360: END IF;
361:
362: p_exchange_rate_type := 'EMU FIXED';
363:

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

371:
372: */
373:
374: IF (PG_DEBUG = 'Y') THEN
375: arp_standard.debug('Rate = ' || to_char(p_exchange_rate));
376: END IF;
377:
378: else -- exchange rate is not fixed --> check profile for default type
379:

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

380: -------------------------------------------------------------------------------------
381: l_debug_info := 'Exchange rate is not fixed - check profile option for default type';
382: -------------------------------------------------------------------------------------
383: IF (PG_DEBUG = 'Y') THEN
384: arp_standard.debug('No Fixed Rate');
385: END IF;
386: p_exchange_rate_type := fnd_profile.value('AR_DEFAULT_EXCHANGE_RATE_TYPE');
387:
388: IF (PG_DEBUG = 'Y') THEN

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

385: END IF;
386: p_exchange_rate_type := fnd_profile.value('AR_DEFAULT_EXCHANGE_RATE_TYPE');
387:
388: IF (PG_DEBUG = 'Y') THEN
389: arp_standard.debug('Profile option default exch rate type: '|| p_exchange_rate_type);
390: END IF;
391:
392: if (p_exchange_rate_type IS NOT NULL) then
393:

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

401: p_exchange_rate_date,
402: p_exchange_rate_type);
403:
404: IF (PG_DEBUG = 'Y') THEN
405: arp_standard.debug('Rate = ' || to_char(p_exchange_rate));
406: END IF;
407:
408: if p_exchange_rate = -1 then -- no rate found in GL
409:

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

410: -------------------------------------------------------------------------------------------
411: l_debug_info := 'Exchange rate not found in GL- use invoice exchange rate';
412: -------------------------------------------------------------------------------------------
413: IF (PG_DEBUG = 'Y') THEN
414: arp_standard.debug('no conversion rate found... using trx rate');
415: END IF;
416:
417: p_exchange_rate_type := 'User';
418: p_exchange_rate := p_trx_exchange_rate;

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

437:
438: end if; -- fixed/non-fixed rate case
439:
440: IF (PG_DEBUG = 'Y') THEN
441: arp_standard.debug('Leaving get_exchange_rate: ');
442: arp_standard.debug('p_exchange_rate_type = ' || p_exchange_rate_type);
443: arp_standard.debug('p_exchange_rate = ' || to_char(p_exchange_rate));
444: END IF;
445:

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

438: end if; -- fixed/non-fixed rate case
439:
440: IF (PG_DEBUG = 'Y') THEN
441: arp_standard.debug('Leaving get_exchange_rate: ');
442: arp_standard.debug('p_exchange_rate_type = ' || p_exchange_rate_type);
443: arp_standard.debug('p_exchange_rate = ' || to_char(p_exchange_rate));
444: END IF;
445:
446: EXCEPTION

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

439:
440: IF (PG_DEBUG = 'Y') THEN
441: arp_standard.debug('Leaving get_exchange_rate: ');
442: arp_standard.debug('p_exchange_rate_type = ' || p_exchange_rate_type);
443: arp_standard.debug('p_exchange_rate = ' || to_char(p_exchange_rate));
444: END IF;
445:
446: EXCEPTION
447: WHEN OTHERS THEN

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

715: and customer_site_use_id = nvl(decode(p_site_use_id, -1, null, p_site_use_id), customer_site_use_id);
716: EXCEPTION
717: when others then
718: IF (PG_DEBUG = 'Y') THEN
719: arp_standard.debug('There may be invoices with different sites');
720: END IF;
721: END;
722: if ( l_customer_id is null ) then
723: --Code should not come here ideally

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

727: group by currency_code;
728: EXCEPTION
729: when others then
730: IF (PG_DEBUG = 'Y') THEN
731: arp_standard.debug('There may be invoices with different currencies');
732: END IF;
733: END;
734: end if;
735: end if;

Line 2082: | Writes standard messages to standard debugging and to the log |

2078: /*===========================================================================+
2079: | PROCEDURE write_debug_and_log |
2080: | |
2081: | DESCRIPTION |
2082: | Writes standard messages to standard debugging and to the log |
2083: | |
2084: | SCOPE - PUBLIC |
2085: | |
2086: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 2102: | Write the message to log and to the standard |

2098:
2099: BEGIN
2100:
2101: /*------------------------------------------------+
2102: | Write the message to log and to the standard |
2103: | debugging channel |
2104: +------------------------------------------------*/
2105: IF FND_GLOBAL.CONC_REQUEST_ID is not null THEN
2106:

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

2112:
2113: END IF;
2114:
2115: IF (PG_DEBUG = 'Y') THEN
2116: arp_standard.debug('OIR'|| p_message);
2117: END IF;
2118: EXCEPTION
2119: WHEN others THEN
2120: /*-------------------------------------------------------+

Line 2381: arp_standard.debug(l_debug_info);

2377: ----------------------------------------------------------------------------------------
2378: l_debug_info := 'Clear the transaction list for the active customer, site, currency';
2379: -----------------------------------------------------------------------------------------
2380: IF (PG_DEBUG = 'Y') THEN
2381: arp_standard.debug(l_debug_info);
2382: END IF;
2383:
2384: --Bug # 3467287 - The Global Temp table must be striped by Customer and Customer Site.
2385: --DELETE FROM AR_IREC_PAYMENT_LIST_GT

Line 2402: arp_standard.debug(l_debug_info);

2398: ----------------------------------------------------------------------------------------
2399: l_debug_info := 'Fetch all the rows into the global temporary table';
2400: -----------------------------------------------------------------------------------------
2401: IF (PG_DEBUG = 'Y') THEN
2402: arp_standard.debug(l_debug_info);
2403: END IF;
2404:
2405: Open open_invoice_list(p_customer_id,
2406: p_customer_site_use_id,

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

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
2418: arp_standard.debug('Inserting: '||l_open_invoice_list_rec(trx).trx_number);
2419: END IF;
2420:
2421: ----------------------------------------------------------------------------------------
2422: l_debug_info := 'Calculate discount';

Line 2425: arp_standard.debug(l_debug_info);

2421: ----------------------------------------------------------------------------------------
2422: l_debug_info := 'Calculate discount';
2423: -----------------------------------------------------------------------------------------
2424: IF (PG_DEBUG = 'Y') THEN
2425: arp_standard.debug(l_debug_info);
2426: END IF;
2427:
2428:
2429: arp_discounts_api.get_discount(p_ps_id => l_open_invoice_list_rec(trx).payment_schedule_id,

Line 2486: arp_standard.debug(l_debug_info);

2482: ----------------------------------------------------------------------------------------
2483: l_debug_info := 'Compute service charge';
2484: -----------------------------------------------------------------------------------------
2485: IF (PG_DEBUG = 'Y') THEN
2486: arp_standard.debug(l_debug_info);
2487: END IF;
2488: l_total_service_charge := get_service_charge(p_customer_id, p_customer_site_use_id, p_payment_type, p_lookup_code);
2489:
2490: COMMIT;

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

2491:
2492: EXCEPTION
2493: WHEN OTHERS THEN
2494: IF (PG_DEBUG = 'Y') THEN
2495: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2496: arp_standard.debug('- Customer Id: '||p_customer_id);
2497: arp_standard.debug('- Customer Site Use Id: '|| p_customer_site_use_id);
2498: arp_standard.debug('- Currency Code: '||p_currency_code);
2499: arp_standard.debug('- Payment Schedule Id: '||p_payment_schedule_id);

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

2492: EXCEPTION
2493: WHEN OTHERS THEN
2494: IF (PG_DEBUG = 'Y') THEN
2495: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2496: arp_standard.debug('- Customer Id: '||p_customer_id);
2497: arp_standard.debug('- Customer Site Use Id: '|| p_customer_site_use_id);
2498: arp_standard.debug('- Currency Code: '||p_currency_code);
2499: arp_standard.debug('- Payment Schedule Id: '||p_payment_schedule_id);
2500: arp_standard.debug('ERROR =>'|| SQLERRM);

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

2493: WHEN OTHERS THEN
2494: IF (PG_DEBUG = 'Y') THEN
2495: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2496: arp_standard.debug('- Customer Id: '||p_customer_id);
2497: arp_standard.debug('- Customer Site Use Id: '|| p_customer_site_use_id);
2498: arp_standard.debug('- Currency Code: '||p_currency_code);
2499: arp_standard.debug('- Payment Schedule Id: '||p_payment_schedule_id);
2500: arp_standard.debug('ERROR =>'|| SQLERRM);
2501: END IF;

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

2494: IF (PG_DEBUG = 'Y') THEN
2495: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2496: arp_standard.debug('- Customer Id: '||p_customer_id);
2497: arp_standard.debug('- Customer Site Use Id: '|| p_customer_site_use_id);
2498: arp_standard.debug('- Currency Code: '||p_currency_code);
2499: arp_standard.debug('- Payment Schedule Id: '||p_payment_schedule_id);
2500: arp_standard.debug('ERROR =>'|| SQLERRM);
2501: END IF;
2502:

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

2495: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2496: arp_standard.debug('- Customer Id: '||p_customer_id);
2497: arp_standard.debug('- Customer Site Use Id: '|| p_customer_site_use_id);
2498: arp_standard.debug('- Currency Code: '||p_currency_code);
2499: arp_standard.debug('- Payment Schedule Id: '||p_payment_schedule_id);
2500: arp_standard.debug('ERROR =>'|| SQLERRM);
2501: END IF;
2502:
2503: ROLLBACK TO create_invoice_pay_list_sp;

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

2496: arp_standard.debug('- Customer Id: '||p_customer_id);
2497: arp_standard.debug('- Customer Site Use Id: '|| p_customer_site_use_id);
2498: arp_standard.debug('- Currency Code: '||p_currency_code);
2499: arp_standard.debug('- Payment Schedule Id: '||p_payment_schedule_id);
2500: arp_standard.debug('ERROR =>'|| SQLERRM);
2501: END IF;
2502:
2503: ROLLBACK TO create_invoice_pay_list_sp;
2504:

Line 2652: arp_standard.debug(l_debug_info);

2648: ---------------------------------------------------------------------------
2649: l_debug_info := 'Fetch all open credit transactions into Payment List GT';
2650: ---------------------------------------------------------------------------
2651: IF (PG_DEBUG = 'Y') THEN
2652: arp_standard.debug(l_debug_info);
2653: END IF;
2654:
2655: Open credit_transactions_list(p_customer_id,
2656: p_customer_site_use_id,

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

2672:
2673: EXCEPTION
2674: WHEN OTHERS THEN
2675: IF (PG_DEBUG = 'Y') THEN
2676: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2677: arp_standard.debug('- Customer Id: '||p_customer_id);
2678: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
2679: arp_standard.debug('- Currency Code: '||p_currency_code);
2680: arp_standard.debug('ERROR =>'|| SQLERRM);

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

2673: EXCEPTION
2674: WHEN OTHERS THEN
2675: IF (PG_DEBUG = 'Y') THEN
2676: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2677: arp_standard.debug('- Customer Id: '||p_customer_id);
2678: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
2679: arp_standard.debug('- Currency Code: '||p_currency_code);
2680: arp_standard.debug('ERROR =>'|| SQLERRM);
2681: END IF;

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

2674: WHEN OTHERS THEN
2675: IF (PG_DEBUG = 'Y') THEN
2676: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2677: arp_standard.debug('- Customer Id: '||p_customer_id);
2678: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
2679: arp_standard.debug('- Currency Code: '||p_currency_code);
2680: arp_standard.debug('ERROR =>'|| SQLERRM);
2681: END IF;
2682:

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

2675: IF (PG_DEBUG = 'Y') THEN
2676: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2677: arp_standard.debug('- Customer Id: '||p_customer_id);
2678: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
2679: arp_standard.debug('- Currency Code: '||p_currency_code);
2680: arp_standard.debug('ERROR =>'|| SQLERRM);
2681: END IF;
2682:
2683: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');

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

2676: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2677: arp_standard.debug('- Customer Id: '||p_customer_id);
2678: arp_standard.debug('- Customer Site Use Id: '||p_customer_site_use_id);
2679: arp_standard.debug('- Currency Code: '||p_currency_code);
2680: arp_standard.debug('ERROR =>'|| SQLERRM);
2681: END IF;
2682:
2683: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
2684: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);

Line 2792: arp_standard.debug(l_debug_info);

2788: ---------------------------------------------------------------------------
2789: l_debug_info := 'Calculate discount';
2790: ---------------------------------------------------------------------------
2791: IF (PG_DEBUG = 'Y') THEN
2792: arp_standard.debug(l_debug_info);
2793: END IF;
2794: l_prev_disc_amt := invoice_rec.discount_amount;
2795: l_payment_amount := invoice_rec.payment_amount;
2796: l_amt_due_remaining := invoice_rec.amount_due_remaining;

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

2811: p_out_rem_amt_rcpt => l_rem_amt_rcpt,
2812: p_out_rem_amt_inv => l_rem_amt_inv);
2813:
2814: IF (PG_DEBUG = 'Y') THEN
2815: arp_standard.debug('Trx: '||invoice_rec.payment_schedule_id||
2816: ' Discount: '||l_discount_amount||
2817: ' Rcpt: '||l_rem_amt_rcpt||
2818: ' Inv: '||l_rem_amt_inv||
2819: 'l_receipt_date: '||l_receipt_date);

Line 2833: arp_standard.debug(l_debug_info);

2829: -----------------------------------------------------------------------------------------
2830: l_debug_info := 'Update transaction list with discount and receipt date';
2831: -----------------------------------------------------------------------------------------
2832: IF (PG_DEBUG = 'Y') THEN
2833: arp_standard.debug(l_debug_info);
2834: END IF;
2835: UPDATE AR_IREC_PAYMENT_LIST_GT
2836: SET discount_amount = l_discount_amount,
2837: receipt_date = trunc(l_receipt_date),

Line 2847: arp_standard.debug(l_debug_info);

2843: -----------------------------------------------------------------------------------------
2844: l_debug_info := 'Compute service charge';
2845: -----------------------------------------------------------------------------------------
2846: IF (PG_DEBUG = 'Y') THEN
2847: arp_standard.debug(l_debug_info);
2848: END IF;
2849: -- Bug # 3467287 - The service charge calculator API is striped by
2850: -- Customer and Customer Site.
2851: -- Bug 3886652 - Customer Id and Customer Site Use Id added as params to ARI_CONFIG.is_service_charge_enabled

Line 3412: arp_standard.debug(l_debug_info);

3408: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Payment Instrument - Credit Card Number - '||p_account_number);
3409: end if;
3410:
3411: IF (PG_DEBUG = 'Y') THEN
3412: arp_standard.debug(l_debug_info);
3413: END IF;
3414:
3415:
3416: EXCEPTION

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

3633: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Cash - Message Data - '||x_msg_data);
3634: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Cash - CR Id - '||l_cash_receipt_id);
3635: end if;
3636:
3637: arp_standard.debug('X_RETURN_STATUS=>'||X_RETURN_STATUS);
3638: arp_standard.debug('X_MSG_COUNT=>'||to_char(X_MSG_COUNT));
3639:
3640: EXCEPTION
3641: WHEN OTHERS THEN

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

3634: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Create Cash - CR Id - '||l_cash_receipt_id);
3635: end if;
3636:
3637: arp_standard.debug('X_RETURN_STATUS=>'||X_RETURN_STATUS);
3638: arp_standard.debug('X_MSG_COUNT=>'||to_char(X_MSG_COUNT));
3639:
3640: EXCEPTION
3641: WHEN OTHERS THEN
3642: p_status := FND_API.G_RET_STS_ERROR;

Line 4050: arp_standard.debug(l_debug_info);

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

Line 4060: arp_standard.debug(l_debug_info);

4056: ----------------------------------------------------------------------------------------
4057: l_debug_info := 'Create the invoice list table';
4058: -----------------------------------------------------------------------------------------
4059: IF (PG_DEBUG = 'Y') THEN
4060: arp_standard.debug(l_debug_info);
4061: END IF;
4062:
4063: IF (PG_DEBUG = 'Y') THEN
4064: arp_standard.debug('In getServiceCharge begin for Loop..');

Line 4064: arp_standard.debug('In getServiceCharge begin for Loop..');

4060: arp_standard.debug(l_debug_info);
4061: END IF;
4062:
4063: IF (PG_DEBUG = 'Y') THEN
4064: arp_standard.debug('In getServiceCharge begin for Loop..');
4065: END IF;
4066:
4067: FOR invoice_rec in invoice_list
4068: LOOP

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

4070: --Bug 4071551 - Changed the indexing field to Payment Schedule Id from Customer Trx Id to keep uniqueness
4071: l_count := invoice_rec.payment_schedule_id;
4072:
4073: IF (PG_DEBUG = 'Y') THEN
4074: arp_standard.debug('Index: '||l_count);
4075: END IF;
4076:
4077: l_invoice_list(l_count).payment_schedule_id := invoice_rec.payment_schedule_id;
4078: l_invoice_list(l_count).payment_amount := invoice_rec.payment_amount;

Line 4090: arp_standard.debug('invoice_rec.payment_schedule_id: '||invoice_rec.payment_schedule_id);

4086:
4087: l_currency_code := invoice_rec.currency_code;
4088:
4089: IF (PG_DEBUG = 'Y') THEN
4090: arp_standard.debug('invoice_rec.payment_schedule_id: '||invoice_rec.payment_schedule_id);
4091: arp_standard.debug('invoice_rec.payment_amount: '||invoice_rec.payment_amount);
4092: arp_standard.debug('invoice_rec.customer_id: '||invoice_rec.customer_id);
4093: arp_standard.debug('invoice_rec.customer_site_use_id: '||invoice_rec.customer_site_use_id);
4094: arp_standard.debug('invoice_rec.account_number: '||invoice_rec.account_number);

Line 4091: arp_standard.debug('invoice_rec.payment_amount: '||invoice_rec.payment_amount);

4087: l_currency_code := invoice_rec.currency_code;
4088:
4089: IF (PG_DEBUG = 'Y') THEN
4090: arp_standard.debug('invoice_rec.payment_schedule_id: '||invoice_rec.payment_schedule_id);
4091: arp_standard.debug('invoice_rec.payment_amount: '||invoice_rec.payment_amount);
4092: arp_standard.debug('invoice_rec.customer_id: '||invoice_rec.customer_id);
4093: arp_standard.debug('invoice_rec.customer_site_use_id: '||invoice_rec.customer_site_use_id);
4094: arp_standard.debug('invoice_rec.account_number: '||invoice_rec.account_number);
4095: arp_standard.debug('invoice_rec.customer_trx_id '||invoice_rec.customer_trx_id);

Line 4092: arp_standard.debug('invoice_rec.customer_id: '||invoice_rec.customer_id);

4088:
4089: IF (PG_DEBUG = 'Y') THEN
4090: arp_standard.debug('invoice_rec.payment_schedule_id: '||invoice_rec.payment_schedule_id);
4091: arp_standard.debug('invoice_rec.payment_amount: '||invoice_rec.payment_amount);
4092: arp_standard.debug('invoice_rec.customer_id: '||invoice_rec.customer_id);
4093: arp_standard.debug('invoice_rec.customer_site_use_id: '||invoice_rec.customer_site_use_id);
4094: arp_standard.debug('invoice_rec.account_number: '||invoice_rec.account_number);
4095: arp_standard.debug('invoice_rec.customer_trx_id '||invoice_rec.customer_trx_id);
4096: arp_standard.debug('invoice_rec.currency_code: '||invoice_rec.currency_code);

Line 4093: arp_standard.debug('invoice_rec.customer_site_use_id: '||invoice_rec.customer_site_use_id);

4089: IF (PG_DEBUG = 'Y') THEN
4090: arp_standard.debug('invoice_rec.payment_schedule_id: '||invoice_rec.payment_schedule_id);
4091: arp_standard.debug('invoice_rec.payment_amount: '||invoice_rec.payment_amount);
4092: arp_standard.debug('invoice_rec.customer_id: '||invoice_rec.customer_id);
4093: arp_standard.debug('invoice_rec.customer_site_use_id: '||invoice_rec.customer_site_use_id);
4094: arp_standard.debug('invoice_rec.account_number: '||invoice_rec.account_number);
4095: arp_standard.debug('invoice_rec.customer_trx_id '||invoice_rec.customer_trx_id);
4096: arp_standard.debug('invoice_rec.currency_code: '||invoice_rec.currency_code);
4097: arp_standard.debug('invoice_rec.service_charge: '||invoice_rec.service_charge);

Line 4094: arp_standard.debug('invoice_rec.account_number: '||invoice_rec.account_number);

4090: arp_standard.debug('invoice_rec.payment_schedule_id: '||invoice_rec.payment_schedule_id);
4091: arp_standard.debug('invoice_rec.payment_amount: '||invoice_rec.payment_amount);
4092: arp_standard.debug('invoice_rec.customer_id: '||invoice_rec.customer_id);
4093: arp_standard.debug('invoice_rec.customer_site_use_id: '||invoice_rec.customer_site_use_id);
4094: arp_standard.debug('invoice_rec.account_number: '||invoice_rec.account_number);
4095: arp_standard.debug('invoice_rec.customer_trx_id '||invoice_rec.customer_trx_id);
4096: arp_standard.debug('invoice_rec.currency_code: '||invoice_rec.currency_code);
4097: arp_standard.debug('invoice_rec.service_charge: '||invoice_rec.service_charge);
4098:

Line 4095: arp_standard.debug('invoice_rec.customer_trx_id '||invoice_rec.customer_trx_id);

4091: arp_standard.debug('invoice_rec.payment_amount: '||invoice_rec.payment_amount);
4092: arp_standard.debug('invoice_rec.customer_id: '||invoice_rec.customer_id);
4093: arp_standard.debug('invoice_rec.customer_site_use_id: '||invoice_rec.customer_site_use_id);
4094: arp_standard.debug('invoice_rec.account_number: '||invoice_rec.account_number);
4095: arp_standard.debug('invoice_rec.customer_trx_id '||invoice_rec.customer_trx_id);
4096: arp_standard.debug('invoice_rec.currency_code: '||invoice_rec.currency_code);
4097: arp_standard.debug('invoice_rec.service_charge: '||invoice_rec.service_charge);
4098:
4099: END IF;

Line 4096: arp_standard.debug('invoice_rec.currency_code: '||invoice_rec.currency_code);

4092: arp_standard.debug('invoice_rec.customer_id: '||invoice_rec.customer_id);
4093: arp_standard.debug('invoice_rec.customer_site_use_id: '||invoice_rec.customer_site_use_id);
4094: arp_standard.debug('invoice_rec.account_number: '||invoice_rec.account_number);
4095: arp_standard.debug('invoice_rec.customer_trx_id '||invoice_rec.customer_trx_id);
4096: arp_standard.debug('invoice_rec.currency_code: '||invoice_rec.currency_code);
4097: arp_standard.debug('invoice_rec.service_charge: '||invoice_rec.service_charge);
4098:
4099: END IF;
4100:

Line 4097: arp_standard.debug('invoice_rec.service_charge: '||invoice_rec.service_charge);

4093: arp_standard.debug('invoice_rec.customer_site_use_id: '||invoice_rec.customer_site_use_id);
4094: arp_standard.debug('invoice_rec.account_number: '||invoice_rec.account_number);
4095: arp_standard.debug('invoice_rec.customer_trx_id '||invoice_rec.customer_trx_id);
4096: arp_standard.debug('invoice_rec.currency_code: '||invoice_rec.currency_code);
4097: arp_standard.debug('invoice_rec.service_charge: '||invoice_rec.service_charge);
4098:
4099: END IF;
4100:
4101:

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

4101:
4102: END LOOP;
4103:
4104: IF (PG_DEBUG = 'Y') THEN
4105: arp_standard.debug('End first Loop. Total records: '||l_invoice_list.COUNT);
4106: END IF;
4107:
4108: ----------------------------------------------------------------------------------------
4109: l_debug_info := 'Call the service charge package to compute';

Line 4112: arp_standard.debug(l_debug_info);

4108: ----------------------------------------------------------------------------------------
4109: l_debug_info := 'Call the service charge package to compute';
4110: -----------------------------------------------------------------------------------------
4111: IF (PG_DEBUG = 'Y') THEN
4112: arp_standard.debug(l_debug_info);
4113: END IF;
4114: ARI_SERVICE_CHARGE_PKG.compute_service_charge(l_invoice_list, p_payment_type, p_lookup_code);
4115:
4116: l_count := l_invoice_list.FIRST;

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

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);
4125: END IF;
4126:
4127: ----------------------------------------------------------------------------------------

Line 4131: arp_standard.debug(l_debug_info);

4127: ----------------------------------------------------------------------------------------
4128: l_debug_info := 'Update service charge in the Payment GT';
4129: -----------------------------------------------------------------------------------------
4130: IF (PG_DEBUG = 'Y') THEN
4131: arp_standard.debug(l_debug_info);
4132: END IF;
4133: UPDATE ar_irec_payment_list_gt
4134: SET service_charge = l_service_charge
4135: WHERE payment_schedule_id = l_invoice_list(l_count).payment_schedule_id;

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

4138:
4139: -- Error handling required
4140: IF SQL%ROWCOUNT < 1 THEN
4141: IF (PG_DEBUG = 'Y') THEN
4142: arp_standard.debug('Error - Cannot update '||l_count);
4143: END IF;
4144: END IF;
4145:
4146: l_count := l_invoice_list.NEXT(l_count);

Line 4240: arp_standard.debug('In Apply_Service_Charge begin for Loop..');

4236: l_debug_info := 'Create the invoice list table';
4237: ----------------------------------------------------------------------------------
4238:
4239: IF (PG_DEBUG = 'Y') THEN
4240: arp_standard.debug('In Apply_Service_Charge begin for Loop..');
4241: END IF;
4242:
4243: FOR invoice_rec in invoice_list
4244: LOOP

Line 4265: arp_standard.debug('invoice_rec.payment_schedule_id: '||invoice_rec.payment_schedule_id);

4261: l_invoice_list(l_count).gl_date := invoice_rec.receipt_date;
4262:
4263:
4264: IF (PG_DEBUG = 'Y') THEN
4265: arp_standard.debug('invoice_rec.payment_schedule_id: '||invoice_rec.payment_schedule_id);
4266: arp_standard.debug('invoice_rec.payment_amount: '||invoice_rec.payment_amount);
4267: arp_standard.debug('invoice_rec.customer_id: '||invoice_rec.customer_id);
4268: arp_standard.debug('invoice_rec.customer_site_use_id: '||invoice_rec.customer_site_use_id);
4269: arp_standard.debug('invoice_rec.account_number: '||invoice_rec.account_number);

Line 4266: arp_standard.debug('invoice_rec.payment_amount: '||invoice_rec.payment_amount);

4262:
4263:
4264: IF (PG_DEBUG = 'Y') THEN
4265: arp_standard.debug('invoice_rec.payment_schedule_id: '||invoice_rec.payment_schedule_id);
4266: arp_standard.debug('invoice_rec.payment_amount: '||invoice_rec.payment_amount);
4267: arp_standard.debug('invoice_rec.customer_id: '||invoice_rec.customer_id);
4268: arp_standard.debug('invoice_rec.customer_site_use_id: '||invoice_rec.customer_site_use_id);
4269: arp_standard.debug('invoice_rec.account_number: '||invoice_rec.account_number);
4270: arp_standard.debug('invoice_rec.customer_trx_id '||invoice_rec.customer_trx_id);

Line 4267: arp_standard.debug('invoice_rec.customer_id: '||invoice_rec.customer_id);

4263:
4264: IF (PG_DEBUG = 'Y') THEN
4265: arp_standard.debug('invoice_rec.payment_schedule_id: '||invoice_rec.payment_schedule_id);
4266: arp_standard.debug('invoice_rec.payment_amount: '||invoice_rec.payment_amount);
4267: arp_standard.debug('invoice_rec.customer_id: '||invoice_rec.customer_id);
4268: arp_standard.debug('invoice_rec.customer_site_use_id: '||invoice_rec.customer_site_use_id);
4269: arp_standard.debug('invoice_rec.account_number: '||invoice_rec.account_number);
4270: arp_standard.debug('invoice_rec.customer_trx_id '||invoice_rec.customer_trx_id);
4271: arp_standard.debug('invoice_rec.currency_code: '||invoice_rec.currency_code);

Line 4268: arp_standard.debug('invoice_rec.customer_site_use_id: '||invoice_rec.customer_site_use_id);

4264: IF (PG_DEBUG = 'Y') THEN
4265: arp_standard.debug('invoice_rec.payment_schedule_id: '||invoice_rec.payment_schedule_id);
4266: arp_standard.debug('invoice_rec.payment_amount: '||invoice_rec.payment_amount);
4267: arp_standard.debug('invoice_rec.customer_id: '||invoice_rec.customer_id);
4268: arp_standard.debug('invoice_rec.customer_site_use_id: '||invoice_rec.customer_site_use_id);
4269: arp_standard.debug('invoice_rec.account_number: '||invoice_rec.account_number);
4270: arp_standard.debug('invoice_rec.customer_trx_id '||invoice_rec.customer_trx_id);
4271: arp_standard.debug('invoice_rec.currency_code: '||invoice_rec.currency_code);
4272: arp_standard.debug('invoice_rec.service_charge: '||invoice_rec.service_charge);

Line 4269: arp_standard.debug('invoice_rec.account_number: '||invoice_rec.account_number);

4265: arp_standard.debug('invoice_rec.payment_schedule_id: '||invoice_rec.payment_schedule_id);
4266: arp_standard.debug('invoice_rec.payment_amount: '||invoice_rec.payment_amount);
4267: arp_standard.debug('invoice_rec.customer_id: '||invoice_rec.customer_id);
4268: arp_standard.debug('invoice_rec.customer_site_use_id: '||invoice_rec.customer_site_use_id);
4269: arp_standard.debug('invoice_rec.account_number: '||invoice_rec.account_number);
4270: arp_standard.debug('invoice_rec.customer_trx_id '||invoice_rec.customer_trx_id);
4271: arp_standard.debug('invoice_rec.currency_code: '||invoice_rec.currency_code);
4272: arp_standard.debug('invoice_rec.service_charge: '||invoice_rec.service_charge);
4273:

Line 4270: arp_standard.debug('invoice_rec.customer_trx_id '||invoice_rec.customer_trx_id);

4266: arp_standard.debug('invoice_rec.payment_amount: '||invoice_rec.payment_amount);
4267: arp_standard.debug('invoice_rec.customer_id: '||invoice_rec.customer_id);
4268: arp_standard.debug('invoice_rec.customer_site_use_id: '||invoice_rec.customer_site_use_id);
4269: arp_standard.debug('invoice_rec.account_number: '||invoice_rec.account_number);
4270: arp_standard.debug('invoice_rec.customer_trx_id '||invoice_rec.customer_trx_id);
4271: arp_standard.debug('invoice_rec.currency_code: '||invoice_rec.currency_code);
4272: arp_standard.debug('invoice_rec.service_charge: '||invoice_rec.service_charge);
4273:
4274: END IF;

Line 4271: arp_standard.debug('invoice_rec.currency_code: '||invoice_rec.currency_code);

4267: arp_standard.debug('invoice_rec.customer_id: '||invoice_rec.customer_id);
4268: arp_standard.debug('invoice_rec.customer_site_use_id: '||invoice_rec.customer_site_use_id);
4269: arp_standard.debug('invoice_rec.account_number: '||invoice_rec.account_number);
4270: arp_standard.debug('invoice_rec.customer_trx_id '||invoice_rec.customer_trx_id);
4271: arp_standard.debug('invoice_rec.currency_code: '||invoice_rec.currency_code);
4272: arp_standard.debug('invoice_rec.service_charge: '||invoice_rec.service_charge);
4273:
4274: END IF;
4275:

Line 4272: arp_standard.debug('invoice_rec.service_charge: '||invoice_rec.service_charge);

4268: arp_standard.debug('invoice_rec.customer_site_use_id: '||invoice_rec.customer_site_use_id);
4269: arp_standard.debug('invoice_rec.account_number: '||invoice_rec.account_number);
4270: arp_standard.debug('invoice_rec.customer_trx_id '||invoice_rec.customer_trx_id);
4271: arp_standard.debug('invoice_rec.currency_code: '||invoice_rec.currency_code);
4272: arp_standard.debug('invoice_rec.service_charge: '||invoice_rec.service_charge);
4273:
4274: END IF;
4275:
4276: l_count := l_count + 1;

Line 4512: arp_standard.debug('No primary bill to site exists ');

4508: EXCEPTION
4509: when others then
4510: l_site_use_id := NULL;
4511: IF (PG_DEBUG = 'Y') THEN
4512: arp_standard.debug('No primary bill to site exists ');
4513: END IF;
4514: END;
4515:
4516: ELSE

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

4559: and customer_site_use_id = nvl(l_site_use_id, customer_site_use_id);
4560: EXCEPTION
4561: when others then
4562: IF (PG_DEBUG = 'Y') THEN
4563: arp_standard.debug('There may be multiple invoices for payment');
4564: END IF;
4565: END;
4566:
4567: ---------------------------------------------------------------------------

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

4640: --group by currency_code;
4641: EXCEPTION
4642: when others then
4643: IF (PG_DEBUG = 'Y') THEN
4644: arp_standard.debug('Error getting currency code');
4645: END IF;
4646: END;
4647: END IF;
4648:

Line 4876: | Standard start of API savepoint |

4872: ---------------------------------------------------------------------------
4873: l_debug_info := 'Create a cash receipt: Call create_receipt';
4874: ---------------------------------------------------------------------------
4875: /*------------------------------------+
4876: | Standard start of API savepoint |
4877: +------------------------------------*/
4878: SAVEPOINT ARI_Create_Receipt_PVT; -- added for bug 11654712
4879:
4880: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

4897: x_msg_count => l_msg_count,
4898: x_msg_data => l_msg_data
4899: );
4900:
4901: arp_standard.debug('create receipt --> ' || x_return_status || 'receipt id --> ' || p_cash_receipt_id);
4902: arp_standard.debug('X_RETURN_STATUS=>'||X_RETURN_STATUS);
4903:
4904: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4905: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Done with receipt creation ....');

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

4898: x_msg_data => l_msg_data
4899: );
4900:
4901: arp_standard.debug('create receipt --> ' || x_return_status || 'receipt id --> ' || p_cash_receipt_id);
4902: arp_standard.debug('X_RETURN_STATUS=>'||X_RETURN_STATUS);
4903:
4904: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4905: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Done with receipt creation ....');
4906: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Return Status: '||x_return_status);

Line 5011: arp_standard.debug('Error getting Home Country Code..');

5007: AND bank.party_id = pr.party_id;
5008: EXCEPTION
5009: when others then
5010: IF (PG_DEBUG = 'Y') THEN
5011: arp_standard.debug('Error getting Home Country Code..');
5012: l_home_country := null;
5013: END IF;
5014: END;
5015:

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

5277: --Assign default values
5278: l_return_status := FND_API.G_RET_STS_SUCCESS;
5279: l_procedure_name := '.process_payment';
5280:
5281: arp_standard.debug('Entering credit card processing...'||p_cash_receipt_id);
5282: ---------------------------------------------------------------------------------
5283: l_debug_info := 'Entering credit card processing';
5284: ---------------------------------------------------------------------------------
5285: OPEN rct_info_cur;

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

5304: l_action := 'AUTHANDCAPTURE';
5305: elsif rct_info.creation_status = 'CONFIRMED' THEN
5306: l_action := 'AUTHONLY';
5307: else
5308: arp_standard.debug('ERROR: Creation status is ' || rct_info.creation_status);
5309: FND_MESSAGE.set_name('AR', 'AR_PAY_PROCESS_INVALID_STATUS');
5310: FND_MSG_PUB.Add;
5311:
5312: x_return_status := FND_API.G_RET_STS_ERROR; -- should never happen

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

5366: p_amount => l_amount_rec,
5367: x_auth_result => x_auth_result,
5368: x_response => x_response);
5369:
5370: arp_standard.debug('l_return_status: ' || l_return_status);
5371:
5372: x_msg_count := l_msg_count;
5373: x_msg_data := l_msg_data;
5374: p_response_error_code := x_response.Result_Code ;

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

5447: x_msg_count := l_msg_count;
5448: x_msg_data := l_msg_data;
5449: p_response_error_code := x_response.Result_Code;
5450:
5451: arp_standard.debug('-------------------------------------');
5452: arp_standard.debug('x_response.Result_Code: ' ||x_response.Result_Code);
5453: arp_standard.debug('x_response.Result_Category: ' || x_response.Result_Category);
5454: arp_standard.debug('x_response.Result_Message: ' || x_response.Result_Message);
5455:

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

5448: x_msg_data := l_msg_data;
5449: p_response_error_code := x_response.Result_Code;
5450:
5451: arp_standard.debug('-------------------------------------');
5452: arp_standard.debug('x_response.Result_Code: ' ||x_response.Result_Code);
5453: arp_standard.debug('x_response.Result_Category: ' || x_response.Result_Category);
5454: arp_standard.debug('x_response.Result_Message: ' || x_response.Result_Message);
5455:
5456: arp_standard.debug('-------------------------------------');

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

5449: p_response_error_code := x_response.Result_Code;
5450:
5451: arp_standard.debug('-------------------------------------');
5452: arp_standard.debug('x_response.Result_Code: ' ||x_response.Result_Code);
5453: arp_standard.debug('x_response.Result_Category: ' || x_response.Result_Category);
5454: arp_standard.debug('x_response.Result_Message: ' || x_response.Result_Message);
5455:
5456: arp_standard.debug('-------------------------------------');
5457:

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

5450:
5451: arp_standard.debug('-------------------------------------');
5452: arp_standard.debug('x_response.Result_Code: ' ||x_response.Result_Code);
5453: arp_standard.debug('x_response.Result_Category: ' || x_response.Result_Category);
5454: arp_standard.debug('x_response.Result_Message: ' || x_response.Result_Message);
5455:
5456: arp_standard.debug('-------------------------------------');
5457:
5458: --Add message to message stack only it it is called from iReceivables

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

5452: arp_standard.debug('x_response.Result_Code: ' ||x_response.Result_Code);
5453: arp_standard.debug('x_response.Result_Category: ' || x_response.Result_Category);
5454: arp_standard.debug('x_response.Result_Message: ' || x_response.Result_Message);
5455:
5456: arp_standard.debug('-------------------------------------');
5457:
5458: --Add message to message stack only it it is called from iReceivables
5459: --if not pass the message stack received from iPayment
5460:

Line 5634: arp_standard.debug(l_debug_info);

5630: ----------------------------------------------------------------------------------------
5631: l_debug_info := 'If the transaction is a Payment, then set the Remaining Amount';
5632: -----------------------------------------------------------------------------------------
5633: IF (PG_DEBUG = 'Y') THEN
5634: arp_standard.debug(l_debug_info);
5635: END IF;
5636: -- Bug 4000279 - Modified to check for 'UNAPP' status only
5637: IF (l_trx_class = 'PMT') THEN
5638:

Line 5649: arp_standard.debug(l_debug_info);

5645: ----------------------------------------------------------------------------------------
5646: l_debug_info := 'If the transaction is a debit, then calculate discount';
5647: -----------------------------------------------------------------------------------------
5648: IF (PG_DEBUG = 'Y') THEN
5649: arp_standard.debug(l_debug_info);
5650: END IF;
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

Line 5677: arp_standard.debug(l_debug_info);

5673: ----------------------------------------------------------------------------------------
5674: l_debug_info := 'Populate the Payment GT with the transaction';
5675: -----------------------------------------------------------------------------------------
5676: IF (PG_DEBUG = 'Y') THEN
5677: arp_standard.debug(l_debug_info);
5678: END IF;
5679:
5680: INSERT INTO AR_IREC_PAYMENT_LIST_GT
5681: ( CUSTOMER_ID,

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

5825:
5826: EXCEPTION
5827: WHEN OTHERS THEN
5828: IF (PG_DEBUG = 'Y') THEN
5829: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
5830: arp_standard.debug('- Payment Schedule Id: '||p_payment_schedule_id);
5831: arp_standard.debug('ERROR =>'|| SQLERRM);
5832: END IF;
5833:

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

5826: EXCEPTION
5827: WHEN OTHERS THEN
5828: IF (PG_DEBUG = 'Y') THEN
5829: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
5830: arp_standard.debug('- Payment Schedule Id: '||p_payment_schedule_id);
5831: arp_standard.debug('ERROR =>'|| SQLERRM);
5832: END IF;
5833:
5834: ROLLBACK to create_trx_list_record_sp;

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

5827: WHEN OTHERS THEN
5828: IF (PG_DEBUG = 'Y') THEN
5829: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
5830: arp_standard.debug('- Payment Schedule Id: '||p_payment_schedule_id);
5831: arp_standard.debug('ERROR =>'|| SQLERRM);
5832: END IF;
5833:
5834: ROLLBACK to create_trx_list_record_sp;
5835:

Line 5904: arp_standard.debug(l_debug_info);

5900: --------------------------------------------------------------------
5901: l_debug_info := 'Checking if valid CC payment method is set in the profile OIR_CC_PMT_METHOD';
5902: --------------------------------------------------------------------
5903: IF (PG_DEBUG = 'Y') THEN
5904: arp_standard.debug(l_debug_info);
5905: END IF;
5906:
5907: profile_cc_payment_method := FND_PROFILE.value('OIR_CC_PMT_METHOD');
5908:

Line 6091: arp_standard.debug(l_debug_info);

6087: --------------------------------------------------------------------
6088: l_debug_info := 'Checking if valid Bank Account payment method is set in the profile OIR_BA_PMT_METHOD';
6089: --------------------------------------------------------------------
6090: IF (PG_DEBUG = 'Y') THEN
6091: arp_standard.debug(l_debug_info);
6092: END IF;
6093:
6094: profile_ba_payment_method := FND_PROFILE.value('OIR_BA_PMT_METHOD');
6095:

Line 6419: arp_standard.debug(l_debug_info);

6415: -----------------------------------------------------------------------------------------
6416: l_debug_info := 'Update transaction list with original discount and payment amount';
6417: -----------------------------------------------------------------------------------------
6418: IF (PG_DEBUG = 'Y') THEN
6419: arp_standard.debug(l_debug_info);
6420: END IF;
6421: --Striping by currency code is not required because
6422: --it is not possible to navigate to Payment page with multiple currencies
6423: --in the Transaction List for a cusomer context

Line 6434: arp_standard.debug(l_debug_info);

6430: -----------------------------------------------------------------------------------------
6431: l_debug_info := 'Compute service charge';
6432: -----------------------------------------------------------------------------------------
6433: IF (PG_DEBUG = 'Y') THEN
6434: arp_standard.debug(l_debug_info);
6435: END IF;
6436: l_total_service_charge := get_service_charge(p_customer_id, p_site_use_id, p_payment_type,p_lookup_code);
6437:
6438: COMMIT;