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.ARP_RW_ICR_PKG dependencies on ARP_UTIL

Line 81: | arp_util.debug - debug procedure |

77: | |
78: | SCOPE - PUBLIC |
79: | |
80: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
81: | arp_util.debug - debug procedure |
82: | |
83: | ARGUMENTS : IN: |
84: | p_row_id - Row ID |
85: | p_cr_id - Cash receipt Id |

Line 202: arp_util.debug( 'arp_rw_icr_pkg.update_row()+' );

198: --
199: l_icr_rec ar_interim_cash_receipts%ROWTYPE;
200: BEGIN
201: IF PG_DEBUG in ('Y', 'C') THEN
202: arp_util.debug( 'arp_rw_icr_pkg.update_row()+' );
203: arp_util.debug( 'Special Type : '||p_special_type );
204: arp_util.debug( 'Receipt Id : '||p_cr_id );
205: arp_util.debug( 'Row Id : '||p_row_id );
206: arp_util.debug( 'Receipt Number : '||p_receipt_number );

Line 203: arp_util.debug( 'Special Type : '||p_special_type );

199: l_icr_rec ar_interim_cash_receipts%ROWTYPE;
200: BEGIN
201: IF PG_DEBUG in ('Y', 'C') THEN
202: arp_util.debug( 'arp_rw_icr_pkg.update_row()+' );
203: arp_util.debug( 'Special Type : '||p_special_type );
204: arp_util.debug( 'Receipt Id : '||p_cr_id );
205: arp_util.debug( 'Row Id : '||p_row_id );
206: arp_util.debug( 'Receipt Number : '||p_receipt_number );
207: arp_util.debug( 'Received Amount : '||TO_CHAR( p_receipt_amount ) );

Line 204: arp_util.debug( 'Receipt Id : '||p_cr_id );

200: BEGIN
201: IF PG_DEBUG in ('Y', 'C') THEN
202: arp_util.debug( 'arp_rw_icr_pkg.update_row()+' );
203: arp_util.debug( 'Special Type : '||p_special_type );
204: arp_util.debug( 'Receipt Id : '||p_cr_id );
205: arp_util.debug( 'Row Id : '||p_row_id );
206: arp_util.debug( 'Receipt Number : '||p_receipt_number );
207: arp_util.debug( 'Received Amount : '||TO_CHAR( p_receipt_amount ) );
208: arp_util.debug( 'Amount Applied : '||TO_CHAR( p_amount_applied ) );

Line 205: arp_util.debug( 'Row Id : '||p_row_id );

201: IF PG_DEBUG in ('Y', 'C') THEN
202: arp_util.debug( 'arp_rw_icr_pkg.update_row()+' );
203: arp_util.debug( 'Special Type : '||p_special_type );
204: arp_util.debug( 'Receipt Id : '||p_cr_id );
205: arp_util.debug( 'Row Id : '||p_row_id );
206: arp_util.debug( 'Receipt Number : '||p_receipt_number );
207: arp_util.debug( 'Received Amount : '||TO_CHAR( p_receipt_amount ) );
208: arp_util.debug( 'Amount Applied : '||TO_CHAR( p_amount_applied ) );
209: arp_util.debug( 'Cross Currency Rate: '||TO_CHAR( p_trans_to_receipt_rate) );

Line 206: arp_util.debug( 'Receipt Number : '||p_receipt_number );

202: arp_util.debug( 'arp_rw_icr_pkg.update_row()+' );
203: arp_util.debug( 'Special Type : '||p_special_type );
204: arp_util.debug( 'Receipt Id : '||p_cr_id );
205: arp_util.debug( 'Row Id : '||p_row_id );
206: arp_util.debug( 'Receipt Number : '||p_receipt_number );
207: arp_util.debug( 'Received Amount : '||TO_CHAR( p_receipt_amount ) );
208: arp_util.debug( 'Amount Applied : '||TO_CHAR( p_amount_applied ) );
209: arp_util.debug( 'Cross Currency Rate: '||TO_CHAR( p_trans_to_receipt_rate) );
210: arp_util.debug( 'Bank Charges : '||TO_CHAR( p_factor_discount_amount ) );

Line 207: arp_util.debug( 'Received Amount : '||TO_CHAR( p_receipt_amount ) );

203: arp_util.debug( 'Special Type : '||p_special_type );
204: arp_util.debug( 'Receipt Id : '||p_cr_id );
205: arp_util.debug( 'Row Id : '||p_row_id );
206: arp_util.debug( 'Receipt Number : '||p_receipt_number );
207: arp_util.debug( 'Received Amount : '||TO_CHAR( p_receipt_amount ) );
208: arp_util.debug( 'Amount Applied : '||TO_CHAR( p_amount_applied ) );
209: arp_util.debug( 'Cross Currency Rate: '||TO_CHAR( p_trans_to_receipt_rate) );
210: arp_util.debug( 'Bank Charges : '||TO_CHAR( p_factor_discount_amount ) );
211: END IF;

Line 208: arp_util.debug( 'Amount Applied : '||TO_CHAR( p_amount_applied ) );

204: arp_util.debug( 'Receipt Id : '||p_cr_id );
205: arp_util.debug( 'Row Id : '||p_row_id );
206: arp_util.debug( 'Receipt Number : '||p_receipt_number );
207: arp_util.debug( 'Received Amount : '||TO_CHAR( p_receipt_amount ) );
208: arp_util.debug( 'Amount Applied : '||TO_CHAR( p_amount_applied ) );
209: arp_util.debug( 'Cross Currency Rate: '||TO_CHAR( p_trans_to_receipt_rate) );
210: arp_util.debug( 'Bank Charges : '||TO_CHAR( p_factor_discount_amount ) );
211: END IF;
212: arp_util.debug( 'Receipt Amount : ' ||TO_CHAR( p_receipt_amount +

Line 209: arp_util.debug( 'Cross Currency Rate: '||TO_CHAR( p_trans_to_receipt_rate) );

205: arp_util.debug( 'Row Id : '||p_row_id );
206: arp_util.debug( 'Receipt Number : '||p_receipt_number );
207: arp_util.debug( 'Received Amount : '||TO_CHAR( p_receipt_amount ) );
208: arp_util.debug( 'Amount Applied : '||TO_CHAR( p_amount_applied ) );
209: arp_util.debug( 'Cross Currency Rate: '||TO_CHAR( p_trans_to_receipt_rate) );
210: arp_util.debug( 'Bank Charges : '||TO_CHAR( p_factor_discount_amount ) );
211: END IF;
212: arp_util.debug( 'Receipt Amount : ' ||TO_CHAR( p_receipt_amount +
213: p_factor_discount_amount) );

Line 210: arp_util.debug( 'Bank Charges : '||TO_CHAR( p_factor_discount_amount ) );

206: arp_util.debug( 'Receipt Number : '||p_receipt_number );
207: arp_util.debug( 'Received Amount : '||TO_CHAR( p_receipt_amount ) );
208: arp_util.debug( 'Amount Applied : '||TO_CHAR( p_amount_applied ) );
209: arp_util.debug( 'Cross Currency Rate: '||TO_CHAR( p_trans_to_receipt_rate) );
210: arp_util.debug( 'Bank Charges : '||TO_CHAR( p_factor_discount_amount ) );
211: END IF;
212: arp_util.debug( 'Receipt Amount : ' ||TO_CHAR( p_receipt_amount +
213: p_factor_discount_amount) );
214: IF PG_DEBUG in ('Y', 'C') THEN

Line 212: arp_util.debug( 'Receipt Amount : ' ||TO_CHAR( p_receipt_amount +

208: arp_util.debug( 'Amount Applied : '||TO_CHAR( p_amount_applied ) );
209: arp_util.debug( 'Cross Currency Rate: '||TO_CHAR( p_trans_to_receipt_rate) );
210: arp_util.debug( 'Bank Charges : '||TO_CHAR( p_factor_discount_amount ) );
211: END IF;
212: arp_util.debug( 'Receipt Amount : ' ||TO_CHAR( p_receipt_amount +
213: p_factor_discount_amount) );
214: IF PG_DEBUG in ('Y', 'C') THEN
215: arp_util.debug( 'Method Id : '||p_receipt_method_id );
216: arp_util.debug( 'Bank Account Use Id : '||p_remittance_bank_account_id );

Line 215: arp_util.debug( 'Method Id : '||p_receipt_method_id );

211: END IF;
212: arp_util.debug( 'Receipt Amount : ' ||TO_CHAR( p_receipt_amount +
213: p_factor_discount_amount) );
214: IF PG_DEBUG in ('Y', 'C') THEN
215: arp_util.debug( 'Method Id : '||p_receipt_method_id );
216: arp_util.debug( 'Bank Account Use Id : '||p_remittance_bank_account_id );
217: arp_util.debug( 'Receipt Amount : '||p_receipt_amount );
218: arp_util.debug( 'Batch Id : '||p_batch_id );
219: arp_util.debug( 'Pay From Customer : '||p_pay_from_customer );

Line 216: arp_util.debug( 'Bank Account Use Id : '||p_remittance_bank_account_id );

212: arp_util.debug( 'Receipt Amount : ' ||TO_CHAR( p_receipt_amount +
213: p_factor_discount_amount) );
214: IF PG_DEBUG in ('Y', 'C') THEN
215: arp_util.debug( 'Method Id : '||p_receipt_method_id );
216: arp_util.debug( 'Bank Account Use Id : '||p_remittance_bank_account_id );
217: arp_util.debug( 'Receipt Amount : '||p_receipt_amount );
218: arp_util.debug( 'Batch Id : '||p_batch_id );
219: arp_util.debug( 'Pay From Customer : '||p_pay_from_customer );
220: arp_util.debug( 'Cust. Bank Acct. ID: ' || p_customer_bank_account_id );

Line 217: arp_util.debug( 'Receipt Amount : '||p_receipt_amount );

213: p_factor_discount_amount) );
214: IF PG_DEBUG in ('Y', 'C') THEN
215: arp_util.debug( 'Method Id : '||p_receipt_method_id );
216: arp_util.debug( 'Bank Account Use Id : '||p_remittance_bank_account_id );
217: arp_util.debug( 'Receipt Amount : '||p_receipt_amount );
218: arp_util.debug( 'Batch Id : '||p_batch_id );
219: arp_util.debug( 'Pay From Customer : '||p_pay_from_customer );
220: arp_util.debug( 'Cust. Bank Acct. ID: ' || p_customer_bank_account_id );
221: arp_util.debug( 'Cust. Bank Branch ID: ' || p_customer_bank_branch_id);

Line 218: arp_util.debug( 'Batch Id : '||p_batch_id );

214: IF PG_DEBUG in ('Y', 'C') THEN
215: arp_util.debug( 'Method Id : '||p_receipt_method_id );
216: arp_util.debug( 'Bank Account Use Id : '||p_remittance_bank_account_id );
217: arp_util.debug( 'Receipt Amount : '||p_receipt_amount );
218: arp_util.debug( 'Batch Id : '||p_batch_id );
219: arp_util.debug( 'Pay From Customer : '||p_pay_from_customer );
220: arp_util.debug( 'Cust. Bank Acct. ID: ' || p_customer_bank_account_id );
221: arp_util.debug( 'Cust. Bank Branch ID: ' || p_customer_bank_branch_id);
222: arp_util.debug( 'Site Use ID : '||p_site_use_id );

Line 219: arp_util.debug( 'Pay From Customer : '||p_pay_from_customer );

215: arp_util.debug( 'Method Id : '||p_receipt_method_id );
216: arp_util.debug( 'Bank Account Use Id : '||p_remittance_bank_account_id );
217: arp_util.debug( 'Receipt Amount : '||p_receipt_amount );
218: arp_util.debug( 'Batch Id : '||p_batch_id );
219: arp_util.debug( 'Pay From Customer : '||p_pay_from_customer );
220: arp_util.debug( 'Cust. Bank Acct. ID: ' || p_customer_bank_account_id );
221: arp_util.debug( 'Cust. Bank Branch ID: ' || p_customer_bank_branch_id);
222: arp_util.debug( 'Site Use ID : '||p_site_use_id );
223: arp_util.debug( 'Anticipated Clearing Date: ' || p_anticipated_clearing_date);

Line 220: arp_util.debug( 'Cust. Bank Acct. ID: ' || p_customer_bank_account_id );

216: arp_util.debug( 'Bank Account Use Id : '||p_remittance_bank_account_id );
217: arp_util.debug( 'Receipt Amount : '||p_receipt_amount );
218: arp_util.debug( 'Batch Id : '||p_batch_id );
219: arp_util.debug( 'Pay From Customer : '||p_pay_from_customer );
220: arp_util.debug( 'Cust. Bank Acct. ID: ' || p_customer_bank_account_id );
221: arp_util.debug( 'Cust. Bank Branch ID: ' || p_customer_bank_branch_id);
222: arp_util.debug( 'Site Use ID : '||p_site_use_id );
223: arp_util.debug( 'Anticipated Clearing Date: ' || p_anticipated_clearing_date);
224: END IF;

Line 221: arp_util.debug( 'Cust. Bank Branch ID: ' || p_customer_bank_branch_id);

217: arp_util.debug( 'Receipt Amount : '||p_receipt_amount );
218: arp_util.debug( 'Batch Id : '||p_batch_id );
219: arp_util.debug( 'Pay From Customer : '||p_pay_from_customer );
220: arp_util.debug( 'Cust. Bank Acct. ID: ' || p_customer_bank_account_id );
221: arp_util.debug( 'Cust. Bank Branch ID: ' || p_customer_bank_branch_id);
222: arp_util.debug( 'Site Use ID : '||p_site_use_id );
223: arp_util.debug( 'Anticipated Clearing Date: ' || p_anticipated_clearing_date);
224: END IF;
225: --

Line 222: arp_util.debug( 'Site Use ID : '||p_site_use_id );

218: arp_util.debug( 'Batch Id : '||p_batch_id );
219: arp_util.debug( 'Pay From Customer : '||p_pay_from_customer );
220: arp_util.debug( 'Cust. Bank Acct. ID: ' || p_customer_bank_account_id );
221: arp_util.debug( 'Cust. Bank Branch ID: ' || p_customer_bank_branch_id);
222: arp_util.debug( 'Site Use ID : '||p_site_use_id );
223: arp_util.debug( 'Anticipated Clearing Date: ' || p_anticipated_clearing_date);
224: END IF;
225: --
226: arp_cr_icr_pkg.set_to_dummy( l_icr_rec );

Line 223: arp_util.debug( 'Anticipated Clearing Date: ' || p_anticipated_clearing_date);

219: arp_util.debug( 'Pay From Customer : '||p_pay_from_customer );
220: arp_util.debug( 'Cust. Bank Acct. ID: ' || p_customer_bank_account_id );
221: arp_util.debug( 'Cust. Bank Branch ID: ' || p_customer_bank_branch_id);
222: arp_util.debug( 'Site Use ID : '||p_site_use_id );
223: arp_util.debug( 'Anticipated Clearing Date: ' || p_anticipated_clearing_date);
224: END IF;
225: --
226: arp_cr_icr_pkg.set_to_dummy( l_icr_rec );
227: --

Line 320: arp_util.debug( 'arp_rw_icr_pkg.update_row()-' );

316: arp_rw_batches_check_pkg.update_batch_status( p_batch_id );
317: END IF;
318:
319: IF PG_DEBUG in ('Y', 'C') THEN
320: arp_util.debug( 'arp_rw_icr_pkg.update_row()-' );
321: END IF;
322: --
323: EXCEPTION
324: WHEN OTHERS THEN

Line 326: arp_util.debug( 'EXCEPTION: arp_rw_icr_pkg.update_row' );

322: --
323: EXCEPTION
324: WHEN OTHERS THEN
325: IF PG_DEBUG in ('Y', 'C') THEN
326: arp_util.debug( 'EXCEPTION: arp_rw_icr_pkg.update_row' );
327: END IF;
328: RAISE;
329: END update_row;
330: --

Line 341: | arp_util.debug - debug procedure |

337: | |
338: | SCOPE - PRIVATE |
339: | |
340: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
341: | arp_util.debug - debug procedure |
342: | |
343: | ARGUMENTS : IN: |
344: | p_receipt_number - Receipt Number |
345: | p_gl_date - GL Date |

Line 377: arp_util.debug( 'arp_rw_icr_pkg.validate_args_update_row()+' );

373: p_remittance_bank_account_id IN
374: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE ) IS
375: BEGIN
376: IF PG_DEBUG in ('Y', 'C') THEN
377: arp_util.debug( 'arp_rw_icr_pkg.validate_args_update_row()+' );
378: END IF;
379: --
380: IF ( p_row_id IS NULL OR p_cr_id IS NULL OR
381: p_receipt_number IS NULL OR p_receipt_amount IS NULL OR

Line 393: arp_util.debug( 'arp_rw_icr_pkg.validate_args_update_row()-' );

389: p_site_use_id, p_customer_trx_id,
390: p_payment_schedule_id );
391: --
392: IF PG_DEBUG in ('Y', 'C') THEN
393: arp_util.debug( 'arp_rw_icr_pkg.validate_args_update_row()-' );
394: END IF;
395: --
396: EXCEPTION
397: WHEN OTHERS THEN

Line 399: arp_util.debug(

395: --
396: EXCEPTION
397: WHEN OTHERS THEN
398: IF PG_DEBUG in ('Y', 'C') THEN
399: arp_util.debug(
400: 'EXCEPTION: arp_rw_icr_pkg.validate_args_update_row' );
401: END IF;
402: RAISE;
403: END validate_args_update_row;

Line 417: | arp_util.debug - debug procedure |

413: | |
414: | SCOPE - PUBLIC |
415: | |
416: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
417: | arp_util.debug - debug procedure |
418: | |
419: | ARGUMENTS : IN: |
420: | p_receipt_number - Receipt Number |
421: | p_gl_date - GL Date |

Line 525: arp_util.debug( 'arp_rw_icr_pkg.insert_row()+' );

521: l_icr_rec ar_interim_cash_receipts%ROWTYPE;
522: --
523: BEGIN
524: IF PG_DEBUG in ('Y', 'C') THEN
525: arp_util.debug( 'arp_rw_icr_pkg.insert_row()+' );
526: arp_util.debug( 'Special Type : '||p_special_type );
527: arp_util.debug( 'Receipt Number : '||p_receipt_number );
528: arp_util.debug( 'Receipt Date : '||TO_CHAR( p_receipt_date ) );
529: arp_util.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );

Line 526: arp_util.debug( 'Special Type : '||p_special_type );

522: --
523: BEGIN
524: IF PG_DEBUG in ('Y', 'C') THEN
525: arp_util.debug( 'arp_rw_icr_pkg.insert_row()+' );
526: arp_util.debug( 'Special Type : '||p_special_type );
527: arp_util.debug( 'Receipt Number : '||p_receipt_number );
528: arp_util.debug( 'Receipt Date : '||TO_CHAR( p_receipt_date ) );
529: arp_util.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );
530: arp_util.debug( 'Received Amount : '||TO_CHAR( p_receipt_amount ) );

Line 527: arp_util.debug( 'Receipt Number : '||p_receipt_number );

523: BEGIN
524: IF PG_DEBUG in ('Y', 'C') THEN
525: arp_util.debug( 'arp_rw_icr_pkg.insert_row()+' );
526: arp_util.debug( 'Special Type : '||p_special_type );
527: arp_util.debug( 'Receipt Number : '||p_receipt_number );
528: arp_util.debug( 'Receipt Date : '||TO_CHAR( p_receipt_date ) );
529: arp_util.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );
530: arp_util.debug( 'Received Amount : '||TO_CHAR( p_receipt_amount ) );
531: arp_util.debug( 'Amount Applied : '||TO_CHAR( p_amount_applied ) );

Line 528: arp_util.debug( 'Receipt Date : '||TO_CHAR( p_receipt_date ) );

524: IF PG_DEBUG in ('Y', 'C') THEN
525: arp_util.debug( 'arp_rw_icr_pkg.insert_row()+' );
526: arp_util.debug( 'Special Type : '||p_special_type );
527: arp_util.debug( 'Receipt Number : '||p_receipt_number );
528: arp_util.debug( 'Receipt Date : '||TO_CHAR( p_receipt_date ) );
529: arp_util.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );
530: arp_util.debug( 'Received Amount : '||TO_CHAR( p_receipt_amount ) );
531: arp_util.debug( 'Amount Applied : '||TO_CHAR( p_amount_applied ) );
532: arp_util.debug( 'Cross Currency Rate: '||TO_CHAR( p_trans_to_receipt_rate) );

Line 529: arp_util.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );

525: arp_util.debug( 'arp_rw_icr_pkg.insert_row()+' );
526: arp_util.debug( 'Special Type : '||p_special_type );
527: arp_util.debug( 'Receipt Number : '||p_receipt_number );
528: arp_util.debug( 'Receipt Date : '||TO_CHAR( p_receipt_date ) );
529: arp_util.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );
530: arp_util.debug( 'Received Amount : '||TO_CHAR( p_receipt_amount ) );
531: arp_util.debug( 'Amount Applied : '||TO_CHAR( p_amount_applied ) );
532: arp_util.debug( 'Cross Currency Rate: '||TO_CHAR( p_trans_to_receipt_rate) );
533: arp_util.debug( 'Bank Charges : '||TO_CHAR( p_factor_discount_amount ));

Line 530: arp_util.debug( 'Received Amount : '||TO_CHAR( p_receipt_amount ) );

526: arp_util.debug( 'Special Type : '||p_special_type );
527: arp_util.debug( 'Receipt Number : '||p_receipt_number );
528: arp_util.debug( 'Receipt Date : '||TO_CHAR( p_receipt_date ) );
529: arp_util.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );
530: arp_util.debug( 'Received Amount : '||TO_CHAR( p_receipt_amount ) );
531: arp_util.debug( 'Amount Applied : '||TO_CHAR( p_amount_applied ) );
532: arp_util.debug( 'Cross Currency Rate: '||TO_CHAR( p_trans_to_receipt_rate) );
533: arp_util.debug( 'Bank Charges : '||TO_CHAR( p_factor_discount_amount ));
534: arp_util.debug( 'currency_code : '||p_currency_code );

Line 531: arp_util.debug( 'Amount Applied : '||TO_CHAR( p_amount_applied ) );

527: arp_util.debug( 'Receipt Number : '||p_receipt_number );
528: arp_util.debug( 'Receipt Date : '||TO_CHAR( p_receipt_date ) );
529: arp_util.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );
530: arp_util.debug( 'Received Amount : '||TO_CHAR( p_receipt_amount ) );
531: arp_util.debug( 'Amount Applied : '||TO_CHAR( p_amount_applied ) );
532: arp_util.debug( 'Cross Currency Rate: '||TO_CHAR( p_trans_to_receipt_rate) );
533: arp_util.debug( 'Bank Charges : '||TO_CHAR( p_factor_discount_amount ));
534: arp_util.debug( 'currency_code : '||p_currency_code );
535: arp_util.debug( 'Method Id : '||p_receipt_method_id );

Line 532: arp_util.debug( 'Cross Currency Rate: '||TO_CHAR( p_trans_to_receipt_rate) );

528: arp_util.debug( 'Receipt Date : '||TO_CHAR( p_receipt_date ) );
529: arp_util.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );
530: arp_util.debug( 'Received Amount : '||TO_CHAR( p_receipt_amount ) );
531: arp_util.debug( 'Amount Applied : '||TO_CHAR( p_amount_applied ) );
532: arp_util.debug( 'Cross Currency Rate: '||TO_CHAR( p_trans_to_receipt_rate) );
533: arp_util.debug( 'Bank Charges : '||TO_CHAR( p_factor_discount_amount ));
534: arp_util.debug( 'currency_code : '||p_currency_code );
535: arp_util.debug( 'Method Id : '||p_receipt_method_id );
536: arp_util.debug( 'Bank Account Id : '||p_remittance_bank_account_id );

Line 533: arp_util.debug( 'Bank Charges : '||TO_CHAR( p_factor_discount_amount ));

529: arp_util.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );
530: arp_util.debug( 'Received Amount : '||TO_CHAR( p_receipt_amount ) );
531: arp_util.debug( 'Amount Applied : '||TO_CHAR( p_amount_applied ) );
532: arp_util.debug( 'Cross Currency Rate: '||TO_CHAR( p_trans_to_receipt_rate) );
533: arp_util.debug( 'Bank Charges : '||TO_CHAR( p_factor_discount_amount ));
534: arp_util.debug( 'currency_code : '||p_currency_code );
535: arp_util.debug( 'Method Id : '||p_receipt_method_id );
536: arp_util.debug( 'Bank Account Id : '||p_remittance_bank_account_id );
537: arp_util.debug( 'Receipt Amount : '||p_receipt_amount );

Line 534: arp_util.debug( 'currency_code : '||p_currency_code );

530: arp_util.debug( 'Received Amount : '||TO_CHAR( p_receipt_amount ) );
531: arp_util.debug( 'Amount Applied : '||TO_CHAR( p_amount_applied ) );
532: arp_util.debug( 'Cross Currency Rate: '||TO_CHAR( p_trans_to_receipt_rate) );
533: arp_util.debug( 'Bank Charges : '||TO_CHAR( p_factor_discount_amount ));
534: arp_util.debug( 'currency_code : '||p_currency_code );
535: arp_util.debug( 'Method Id : '||p_receipt_method_id );
536: arp_util.debug( 'Bank Account Id : '||p_remittance_bank_account_id );
537: arp_util.debug( 'Receipt Amount : '||p_receipt_amount );
538: arp_util.debug( 'Batch Id : '||p_batch_id );

Line 535: arp_util.debug( 'Method Id : '||p_receipt_method_id );

531: arp_util.debug( 'Amount Applied : '||TO_CHAR( p_amount_applied ) );
532: arp_util.debug( 'Cross Currency Rate: '||TO_CHAR( p_trans_to_receipt_rate) );
533: arp_util.debug( 'Bank Charges : '||TO_CHAR( p_factor_discount_amount ));
534: arp_util.debug( 'currency_code : '||p_currency_code );
535: arp_util.debug( 'Method Id : '||p_receipt_method_id );
536: arp_util.debug( 'Bank Account Id : '||p_remittance_bank_account_id );
537: arp_util.debug( 'Receipt Amount : '||p_receipt_amount );
538: arp_util.debug( 'Batch Id : '||p_batch_id );
539: arp_util.debug( 'Pay From Customer : '||p_pay_from_customer );

Line 536: arp_util.debug( 'Bank Account Id : '||p_remittance_bank_account_id );

532: arp_util.debug( 'Cross Currency Rate: '||TO_CHAR( p_trans_to_receipt_rate) );
533: arp_util.debug( 'Bank Charges : '||TO_CHAR( p_factor_discount_amount ));
534: arp_util.debug( 'currency_code : '||p_currency_code );
535: arp_util.debug( 'Method Id : '||p_receipt_method_id );
536: arp_util.debug( 'Bank Account Id : '||p_remittance_bank_account_id );
537: arp_util.debug( 'Receipt Amount : '||p_receipt_amount );
538: arp_util.debug( 'Batch Id : '||p_batch_id );
539: arp_util.debug( 'Pay From Customer : '||p_pay_from_customer );
540: arp_util.debug( 'Cust Bank Acct ID : '||p_customer_bank_account_id );

Line 537: arp_util.debug( 'Receipt Amount : '||p_receipt_amount );

533: arp_util.debug( 'Bank Charges : '||TO_CHAR( p_factor_discount_amount ));
534: arp_util.debug( 'currency_code : '||p_currency_code );
535: arp_util.debug( 'Method Id : '||p_receipt_method_id );
536: arp_util.debug( 'Bank Account Id : '||p_remittance_bank_account_id );
537: arp_util.debug( 'Receipt Amount : '||p_receipt_amount );
538: arp_util.debug( 'Batch Id : '||p_batch_id );
539: arp_util.debug( 'Pay From Customer : '||p_pay_from_customer );
540: arp_util.debug( 'Cust Bank Acct ID : '||p_customer_bank_account_id );
541: arp_util.debug( 'Cust Bank Branch ID : '||p_customer_bank_branch_id );

Line 538: arp_util.debug( 'Batch Id : '||p_batch_id );

534: arp_util.debug( 'currency_code : '||p_currency_code );
535: arp_util.debug( 'Method Id : '||p_receipt_method_id );
536: arp_util.debug( 'Bank Account Id : '||p_remittance_bank_account_id );
537: arp_util.debug( 'Receipt Amount : '||p_receipt_amount );
538: arp_util.debug( 'Batch Id : '||p_batch_id );
539: arp_util.debug( 'Pay From Customer : '||p_pay_from_customer );
540: arp_util.debug( 'Cust Bank Acct ID : '||p_customer_bank_account_id );
541: arp_util.debug( 'Cust Bank Branch ID : '||p_customer_bank_branch_id );
542: arp_util.debug( 'Site Use ID : '||p_site_use_id );

Line 539: arp_util.debug( 'Pay From Customer : '||p_pay_from_customer );

535: arp_util.debug( 'Method Id : '||p_receipt_method_id );
536: arp_util.debug( 'Bank Account Id : '||p_remittance_bank_account_id );
537: arp_util.debug( 'Receipt Amount : '||p_receipt_amount );
538: arp_util.debug( 'Batch Id : '||p_batch_id );
539: arp_util.debug( 'Pay From Customer : '||p_pay_from_customer );
540: arp_util.debug( 'Cust Bank Acct ID : '||p_customer_bank_account_id );
541: arp_util.debug( 'Cust Bank Branch ID : '||p_customer_bank_branch_id );
542: arp_util.debug( 'Site Use ID : '||p_site_use_id );
543: END IF;

Line 540: arp_util.debug( 'Cust Bank Acct ID : '||p_customer_bank_account_id );

536: arp_util.debug( 'Bank Account Id : '||p_remittance_bank_account_id );
537: arp_util.debug( 'Receipt Amount : '||p_receipt_amount );
538: arp_util.debug( 'Batch Id : '||p_batch_id );
539: arp_util.debug( 'Pay From Customer : '||p_pay_from_customer );
540: arp_util.debug( 'Cust Bank Acct ID : '||p_customer_bank_account_id );
541: arp_util.debug( 'Cust Bank Branch ID : '||p_customer_bank_branch_id );
542: arp_util.debug( 'Site Use ID : '||p_site_use_id );
543: END IF;
544: --

Line 541: arp_util.debug( 'Cust Bank Branch ID : '||p_customer_bank_branch_id );

537: arp_util.debug( 'Receipt Amount : '||p_receipt_amount );
538: arp_util.debug( 'Batch Id : '||p_batch_id );
539: arp_util.debug( 'Pay From Customer : '||p_pay_from_customer );
540: arp_util.debug( 'Cust Bank Acct ID : '||p_customer_bank_account_id );
541: arp_util.debug( 'Cust Bank Branch ID : '||p_customer_bank_branch_id );
542: arp_util.debug( 'Site Use ID : '||p_site_use_id );
543: END IF;
544: --
545: l_icr_rec.amount := p_receipt_amount;

Line 542: arp_util.debug( 'Site Use ID : '||p_site_use_id );

538: arp_util.debug( 'Batch Id : '||p_batch_id );
539: arp_util.debug( 'Pay From Customer : '||p_pay_from_customer );
540: arp_util.debug( 'Cust Bank Acct ID : '||p_customer_bank_account_id );
541: arp_util.debug( 'Cust Bank Branch ID : '||p_customer_bank_branch_id );
542: arp_util.debug( 'Site Use ID : '||p_site_use_id );
543: END IF;
544: --
545: l_icr_rec.amount := p_receipt_amount;
546: l_icr_rec.amount_applied := p_amount_applied;

Line 637: arp_util.validate_gl_date( l_icr_rec.gl_date, NULL,

633: NULL, NULL );
634: --
635: -- Check for valid GL date
636: --
637: arp_util.validate_gl_date( l_icr_rec.gl_date, NULL,
638: NULL );
639:
640:
641: -- Do the actual Insertion

Line 653: arp_util.debug( 'Batch ID is : '|| l_icr_rec.batch_id );

649: -- Update batch table to set status
650: --
651:
652: IF PG_DEBUG in ('Y', 'C') THEN
653: arp_util.debug( 'Batch ID is : '|| l_icr_rec.batch_id );
654: END IF;
655:
656: arp_rw_batches_check_pkg.update_batch_status( l_icr_rec.batch_id );
657:

Line 661: arp_util.debug( 'arp_rw_icr_pkg.insert_row()-' );

657:
658:
659: --
660: IF PG_DEBUG in ('Y', 'C') THEN
661: arp_util.debug( 'arp_rw_icr_pkg.insert_row()-' );
662: END IF;
663: --
664: EXCEPTION
665: WHEN OTHERS THEN

Line 667: arp_util.debug( 'EXCEPTION: arp_rw_icr_pkg.insert_row' );

663: --
664: EXCEPTION
665: WHEN OTHERS THEN
666: IF PG_DEBUG in ('Y', 'C') THEN
667: arp_util.debug( 'EXCEPTION: arp_rw_icr_pkg.insert_row' );
668: END IF;
669: RAISE;
670: END insert_row;
671: --

Line 682: | arp_util.debug - debug procedure |

678: | |
679: | SCOPE - PRIVATE |
680: | |
681: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
682: | arp_util.debug - debug procedure |
683: | |
684: | ARGUMENTS : IN: |
685: | p_receipt_number - Receipt Number |
686: | p_gl_date - GL Date |

Line 721: arp_util.debug( 'arp_rw_icr_pkg.validate_args_insert_row()+' );

717: p_remittance_bank_account_id IN
718: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE ) IS
719: BEGIN
720: IF PG_DEBUG in ('Y', 'C') THEN
721: arp_util.debug( 'arp_rw_icr_pkg.validate_args_insert_row()+' );
722: END IF;
723: --
724: IF ( p_row_id IS NOT NULL OR p_cr_id IS NOT NULL ) THEN
725: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );

Line 743: arp_util.debug( 'arp_rw_icr_pkg.validate_args_insert_row()-' );

739: p_site_use_id, p_customer_trx_id,
740: p_payment_schedule_id );
741: --
742: IF PG_DEBUG in ('Y', 'C') THEN
743: arp_util.debug( 'arp_rw_icr_pkg.validate_args_insert_row()-' );
744: END IF;
745: --
746: EXCEPTION
747: WHEN OTHERS THEN

Line 749: arp_util.debug(

745: --
746: EXCEPTION
747: WHEN OTHERS THEN
748: IF PG_DEBUG in ('Y', 'C') THEN
749: arp_util.debug(
750: 'EXCEPTION: arp_rw_icr_pkg.validate_args_insert_row' );
751: END IF;
752: RAISE;
753: END validate_args_insert_row;

Line 765: | arp_util.debug - debug procedure |

761: | |
762: | SCOPE - PRIVATE |
763: | |
764: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
765: | arp_util.debug - debug procedure |
766: | |
767: | ARGUMENTS : IN: |
768: | p_special_type - Type of the receipt |
769: | pay_from_custmer - Customer Id |

Line 832: | arp_util.debug - debug procedure |

828: | |
829: | SCOPE - PUBLIC |
830: | |
831: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
832: | arp_util.debug - debug procedure |
833: | |
834: | ARGUMENTS : IN: |
835: | p_cr_id - Interim Cash reveipt ID |
836: | p_module_name - Module that called this procedure |

Line 861: arp_util.debug( 'arp_rw_icr_pkg.get_applied_amount_total()+' );

857: p_module_name IN VARCHAR2,
858: p_module_version IN VARCHAR2 ) IS
859: BEGIN
860: IF PG_DEBUG in ('Y', 'C') THEN
861: arp_util.debug( 'arp_rw_icr_pkg.get_applied_amount_total()+' );
862: arp_util.debug('get_applied_amount_total: ' || 'Icr Id : '||p_cr_id );
863: END IF;
864: --
865: -- Validate args.

Line 862: arp_util.debug('get_applied_amount_total: ' || 'Icr Id : '||p_cr_id );

858: p_module_version IN VARCHAR2 ) IS
859: BEGIN
860: IF PG_DEBUG in ('Y', 'C') THEN
861: arp_util.debug( 'arp_rw_icr_pkg.get_applied_amount_total()+' );
862: arp_util.debug('get_applied_amount_total: ' || 'Icr Id : '||p_cr_id );
863: END IF;
864: --
865: -- Validate args.
866: --

Line 878: arp_util.debug( 'arp_rw_icr_pkg.get_applied_amount_total()-' );

874: FROM ar_interim_cash_receipt_lines
875: WHERE cash_receipt_id = p_cr_id;
876: --
877: IF PG_DEBUG in ('Y', 'C') THEN
878: arp_util.debug( 'arp_rw_icr_pkg.get_applied_amount_total()-' );
879: END IF;
880: --
881: EXCEPTION
882: WHEN OTHERS THEN

Line 884: arp_util.debug('get_applied_amount_total: ' ||

880: --
881: EXCEPTION
882: WHEN OTHERS THEN
883: IF PG_DEBUG in ('Y', 'C') THEN
884: arp_util.debug('get_applied_amount_total: ' ||
885: 'EXCEPTION: arp_rw_icr_pkg.get_applied_amount_total' );
886: END IF;
887: RAISE;
888: END get_applied_amount_total;

Line 900: | arp_util.debug - debug procedure |

896: | |
897: | SCOPE - PRIVATE |
898: | |
899: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
900: | arp_util.debug - debug procedure |
901: | |
902: | ARGUMENTS : IN: |
903: | p_cr_id - ICR_ID |
904: | OUT: |

Line 917: arp_util.debug( 'arp_rw_icr_pkg.val_args_applied_amount_total()+' );

913: PROCEDURE val_args_applied_amount_total(
914: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE ) IS
915: BEGIN
916: IF PG_DEBUG in ('Y', 'C') THEN
917: arp_util.debug( 'arp_rw_icr_pkg.val_args_applied_amount_total()+' );
918: END IF;
919: --
920: IF ( p_cr_id is NULL ) THEN
921: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );

Line 926: arp_util.debug( 'arp_rw_icr_pkg.val_args_applied_amount_total()-' );

922: APP_EXCEPTION.raise_exception;
923: END IF;
924: --
925: IF PG_DEBUG in ('Y', 'C') THEN
926: arp_util.debug( 'arp_rw_icr_pkg.val_args_applied_amount_total()-' );
927: END IF;
928: --
929: EXCEPTION
930: WHEN OTHERS THEN

Line 932: arp_util.debug('val_args_applied_amount_total: ' ||

928: --
929: EXCEPTION
930: WHEN OTHERS THEN
931: IF PG_DEBUG in ('Y', 'C') THEN
932: arp_util.debug('val_args_applied_amount_total: ' ||
933: 'EXCEPTION: arp_rw_icr_pkg.val_args_applied_amount_total' );
934: END IF;
935: RAISE;
936: END val_args_applied_amount_total;

Line 948: | arp_util.debug - debug procedure |

944: | |
945: | SCOPE - PUBLIC |
946: | |
947: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
948: | arp_util.debug - debug procedure |
949: | |
950: | ARGUMENTS : IN: |
951: | p_cr_id - Cash receipt Id |
952: | p_receipt_number - Receipt Number |

Line 980: arp_util.debug( 'arp_rw_icr_pkg.check_unique_receipt()+' );

976: p_module_version IN VARCHAR2 ) IS
977: l_count NUMBER := 0;
978: BEGIN
979: IF PG_DEBUG in ('Y', 'C') THEN
980: arp_util.debug( 'arp_rw_icr_pkg.check_unique_receipt()+' );
981: arp_util.debug( 'Row Id : '||p_row_id );
982: arp_util.debug( 'Icr Id : '||p_cr_id );
983: arp_util.debug( 'Receipt Number : '||p_receipt_number );
984: arp_util.debug( 'Customer ID : '||p_customer_id );

Line 981: arp_util.debug( 'Row Id : '||p_row_id );

977: l_count NUMBER := 0;
978: BEGIN
979: IF PG_DEBUG in ('Y', 'C') THEN
980: arp_util.debug( 'arp_rw_icr_pkg.check_unique_receipt()+' );
981: arp_util.debug( 'Row Id : '||p_row_id );
982: arp_util.debug( 'Icr Id : '||p_cr_id );
983: arp_util.debug( 'Receipt Number : '||p_receipt_number );
984: arp_util.debug( 'Customer ID : '||p_customer_id );
985: arp_util.debug( 'Receipt Amount : '||p_receipt_amount );

Line 982: arp_util.debug( 'Icr Id : '||p_cr_id );

978: BEGIN
979: IF PG_DEBUG in ('Y', 'C') THEN
980: arp_util.debug( 'arp_rw_icr_pkg.check_unique_receipt()+' );
981: arp_util.debug( 'Row Id : '||p_row_id );
982: arp_util.debug( 'Icr Id : '||p_cr_id );
983: arp_util.debug( 'Receipt Number : '||p_receipt_number );
984: arp_util.debug( 'Customer ID : '||p_customer_id );
985: arp_util.debug( 'Receipt Amount : '||p_receipt_amount );
986: END IF;

Line 983: arp_util.debug( 'Receipt Number : '||p_receipt_number );

979: IF PG_DEBUG in ('Y', 'C') THEN
980: arp_util.debug( 'arp_rw_icr_pkg.check_unique_receipt()+' );
981: arp_util.debug( 'Row Id : '||p_row_id );
982: arp_util.debug( 'Icr Id : '||p_cr_id );
983: arp_util.debug( 'Receipt Number : '||p_receipt_number );
984: arp_util.debug( 'Customer ID : '||p_customer_id );
985: arp_util.debug( 'Receipt Amount : '||p_receipt_amount );
986: END IF;
987: --

Line 984: arp_util.debug( 'Customer ID : '||p_customer_id );

980: arp_util.debug( 'arp_rw_icr_pkg.check_unique_receipt()+' );
981: arp_util.debug( 'Row Id : '||p_row_id );
982: arp_util.debug( 'Icr Id : '||p_cr_id );
983: arp_util.debug( 'Receipt Number : '||p_receipt_number );
984: arp_util.debug( 'Customer ID : '||p_customer_id );
985: arp_util.debug( 'Receipt Amount : '||p_receipt_amount );
986: END IF;
987: --
988: -- Validate args. Note: Cash Receipt Id can be null

Line 985: arp_util.debug( 'Receipt Amount : '||p_receipt_amount );

981: arp_util.debug( 'Row Id : '||p_row_id );
982: arp_util.debug( 'Icr Id : '||p_cr_id );
983: arp_util.debug( 'Receipt Number : '||p_receipt_number );
984: arp_util.debug( 'Customer ID : '||p_customer_id );
985: arp_util.debug( 'Receipt Amount : '||p_receipt_amount );
986: END IF;
987: --
988: -- Validate args. Note: Cash Receipt Id can be null
989: --

Line 1033: arp_util.debug( 'arp_rw_icr_pkg.check_unique_receipt()-' );

1029: APP_EXCEPTION.raise_exception;
1030: END IF;
1031: --
1032: IF PG_DEBUG in ('Y', 'C') THEN
1033: arp_util.debug( 'arp_rw_icr_pkg.check_unique_receipt()-' );
1034: END IF;
1035: --
1036: EXCEPTION
1037: WHEN OTHERS THEN

Line 1039: arp_util.debug(

1035: --
1036: EXCEPTION
1037: WHEN OTHERS THEN
1038: IF PG_DEBUG in ('Y', 'C') THEN
1039: arp_util.debug(
1040: 'EXCEPTION: arp_rw_icr_pkg.check_unique_receipt' );
1041: END IF;
1042: RAISE;
1043: END check_unique_receipt;

Line 1055: | arp_util.debug - debug procedure |

1051: | |
1052: | SCOPE - PRIVATE |
1053: | |
1054: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
1055: | arp_util.debug - debug procedure |
1056: | |
1057: | ARGUMENTS : IN: |
1058: | p_receipt_number - Receipt Number |
1059: | p_customer_id - Customer ID |

Line 1077: arp_util.debug( 'arp_rw_icr_pkg.val_args_check_unique_receipt()+' );

1073: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
1074: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE ) IS
1075: BEGIN
1076: IF PG_DEBUG in ('Y', 'C') THEN
1077: arp_util.debug( 'arp_rw_icr_pkg.val_args_check_unique_receipt()+' );
1078: END IF;
1079: --
1080: --
1081: -- Note: Special type can be NULL

Line 1094: arp_util.debug( 'arp_rw_icr_pkg.val_args_check_unique_receipt()-' );

1090: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
1091: APP_EXCEPTION.raise_exception;
1092: END IF;
1093: IF PG_DEBUG in ('Y', 'C') THEN
1094: arp_util.debug( 'arp_rw_icr_pkg.val_args_check_unique_receipt()-' );
1095: END IF;
1096: --
1097: EXCEPTION
1098: WHEN OTHERS THEN

Line 1100: arp_util.debug('val_args_check_unique_receipt: ' ||

1096: --
1097: EXCEPTION
1098: WHEN OTHERS THEN
1099: IF PG_DEBUG in ('Y', 'C') THEN
1100: arp_util.debug('val_args_check_unique_receipt: ' ||
1101: 'EXCEPTION: arp_rw_icr_pkg.val_args_check_unique_receipt' );
1102: END IF;
1103: RAISE;
1104: END val_args_check_unique_receipt;

Line 1117: | arp_util.debug - debug procedure |

1113: | |
1114: | SCOPE - PUBLIC |
1115: | |
1116: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1117: | arp_util.debug - debug procedure |
1118: | |
1119: | ARGUMENTS : IN: |
1120: | p_cr_id - Cash receipt Id |
1121: | p_module_name - Module that called this procedure |

Line 1140: arp_util.debug( 'arp_rw_icr_pkg.lines_exists()+' );

1136: l_count NUMBER;
1137: BEGIN
1138: --
1139: IF PG_DEBUG in ('Y', 'C') THEN
1140: arp_util.debug( 'arp_rw_icr_pkg.lines_exists()+' );
1141: END IF;
1142: --
1143: -- Do argument validation, Note: No separate procedure used
1144: --

Line 1164: arp_util.debug( 'arp_rw_icr_pkg.lines_exists()-' );

1160: RETURN TRUE;
1161: END IF;
1162: --
1163: IF PG_DEBUG in ('Y', 'C') THEN
1164: arp_util.debug( 'arp_rw_icr_pkg.lines_exists()-' );
1165: END IF;
1166: --
1167: EXCEPTION
1168: WHEN OTHERS THEN

Line 1170: arp_util.debug('lines_exists: ' ||

1166: --
1167: EXCEPTION
1168: WHEN OTHERS THEN
1169: IF PG_DEBUG in ('Y', 'C') THEN
1170: arp_util.debug('lines_exists: ' ||
1171: 'EXCEPTION: arp_rw_icr_pkg.lines_exists' );
1172: END IF;
1173: RAISE;
1174: END lines_exists;

Line 1187: | arp_util.debug - debug procedure |

1183: | |
1184: | SCOPE - PUBLIC |
1185: | |
1186: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1187: | arp_util.debug - debug procedure |
1188: | |
1189: | ARGUMENTS : IN: |
1190: | p_cr_id - Cash receipt Id |
1191: | p_module_name - Module that called this procedure |

Line 1208: arp_util.debug( 'arp_rw_icr_pkg.check_no_lines_exists()-' );

1204: p_module_name IN VARCHAR2,
1205: p_module_version IN VARCHAR2 ) IS
1206: BEGIN
1207: IF PG_DEBUG in ('Y', 'C') THEN
1208: arp_util.debug( 'arp_rw_icr_pkg.check_no_lines_exists()-' );
1209: END IF;
1210: --
1211: -- Do argument validation, Note: No separate procedure used
1212: --

Line 1226: arp_util.debug( 'arp_rw_icr_pkg.check_no_lines_exists()-' );

1222: APP_EXCEPTION.raise_exception;
1223: END IF;
1224: --
1225: IF PG_DEBUG in ('Y', 'C') THEN
1226: arp_util.debug( 'arp_rw_icr_pkg.check_no_lines_exists()-' );
1227: END IF;
1228: --
1229: EXCEPTION
1230: WHEN OTHERS THEN

Line 1232: arp_util.debug('check_no_lines_exists: ' ||

1228: --
1229: EXCEPTION
1230: WHEN OTHERS THEN
1231: IF PG_DEBUG in ('Y', 'C') THEN
1232: arp_util.debug('check_no_lines_exists: ' ||
1233: 'EXCEPTION: arp_rw_icr_pkg.check_no_lines_exists' );
1234: END IF;
1235: RAISE;
1236: END check_no_lines_exists;

Line 1248: | arp_util.debug - debug procedure |

1244: | |
1245: | SCOPE - PRIVATE |
1246: | |
1247: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1248: | arp_util.debug - debug procedure |
1249: | |
1250: | ARGUMENTS : IN: |
1251: | p_customer_id - customer id |
1252: | p_bank_account_id - bank_account Id |

Line 1266: arp_util.debug( 'arp_rw_icr_pkg.update_bank_account_uses()+' );

1262: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
1263: p_bank_account_id IN ar_batches.remit_bank_acct_use_id%TYPE ) IS
1264: BEGIN
1265: IF PG_DEBUG in ('Y', 'C') THEN
1266: arp_util.debug( 'arp_rw_icr_pkg.update_bank_account_uses()+' );
1267: arp_util.debug('update_bank_account_uses: ' || 'Customer ID : '||p_customer_id );
1268: arp_util.debug('update_bank_account_uses: ' || 'Bank Account Id : '||p_bank_account_id );
1269: END IF;
1270: --

Line 1267: arp_util.debug('update_bank_account_uses: ' || 'Customer ID : '||p_customer_id );

1263: p_bank_account_id IN ar_batches.remit_bank_acct_use_id%TYPE ) IS
1264: BEGIN
1265: IF PG_DEBUG in ('Y', 'C') THEN
1266: arp_util.debug( 'arp_rw_icr_pkg.update_bank_account_uses()+' );
1267: arp_util.debug('update_bank_account_uses: ' || 'Customer ID : '||p_customer_id );
1268: arp_util.debug('update_bank_account_uses: ' || 'Bank Account Id : '||p_bank_account_id );
1269: END IF;
1270: --
1271: IF PG_DEBUG in ('Y', 'C') THEN

Line 1268: arp_util.debug('update_bank_account_uses: ' || 'Bank Account Id : '||p_bank_account_id );

1264: BEGIN
1265: IF PG_DEBUG in ('Y', 'C') THEN
1266: arp_util.debug( 'arp_rw_icr_pkg.update_bank_account_uses()+' );
1267: arp_util.debug('update_bank_account_uses: ' || 'Customer ID : '||p_customer_id );
1268: arp_util.debug('update_bank_account_uses: ' || 'Bank Account Id : '||p_bank_account_id );
1269: END IF;
1270: --
1271: IF PG_DEBUG in ('Y', 'C') THEN
1272: arp_util.debug( 'arp_rw_icr_pkg.update_bank_account_uses()-' );

Line 1272: arp_util.debug( 'arp_rw_icr_pkg.update_bank_account_uses()-' );

1268: arp_util.debug('update_bank_account_uses: ' || 'Bank Account Id : '||p_bank_account_id );
1269: END IF;
1270: --
1271: IF PG_DEBUG in ('Y', 'C') THEN
1272: arp_util.debug( 'arp_rw_icr_pkg.update_bank_account_uses()-' );
1273: END IF;
1274: --
1275: END update_bank_account_uses;
1276: --

Line 1289: | arp_util.debug - debug procedure |

1285: | |
1286: | SCOPE - PUBLIC |
1287: | |
1288: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1289: | arp_util.debug - debug procedure |
1290: | |
1291: | ARGUMENTS : IN: |
1292: | p_cr_id - Cash Receipt ID |
1293: | p_row_id - Row Id |

Line 1313: arp_util.debug( 'arp_rw_icr_pkg.delete_row()+' );

1309: p_module_name IN VARCHAR2,
1310: p_module_version IN VARCHAR2 ) IS
1311: BEGIN
1312: IF PG_DEBUG in ('Y', 'C') THEN
1313: arp_util.debug( 'arp_rw_icr_pkg.delete_row()+' );
1314: END IF;
1315: --
1316: IF ( p_module_name IS NOT NULL AND p_module_version IS NOT NULL ) THEN
1317: IF ( p_cr_id is NULL OR p_row_id IS NULL ) THEN

Line 1329: arp_util.debug( 'arp_rw_icr_pkg.delete_row()-' );

1325: arp_cr_icr_lines_pkg.delete_fk( p_cr_id );
1326: arp_cr_icr_pkg.delete_p( p_cr_id );
1327: --
1328: IF PG_DEBUG in ('Y', 'C') THEN
1329: arp_util.debug( 'arp_rw_icr_pkg.delete_row()-' );
1330: END IF;
1331: --
1332: EXCEPTION
1333: WHEN OTHERS THEN

Line 1335: arp_util.debug('delete_row: ' ||

1331: --
1332: EXCEPTION
1333: WHEN OTHERS THEN
1334: IF PG_DEBUG in ('Y', 'C') THEN
1335: arp_util.debug('delete_row: ' ||
1336: 'EXCEPTION: arp_rw_icr_pkg.delete_row' );
1337: END IF;
1338: RAISE;
1339: END delete_row;

Line 1433: arp_util.debug('lock_row: ' || 'Made it to lock row' );

1429: --
1430: BEGIN
1431:
1432: IF PG_DEBUG in ('Y', 'C') THEN
1433: arp_util.debug('lock_row: ' || 'Made it to lock row' );
1434: END IF;
1435:
1436: OPEN C;
1437: FETCH C INTO Recinfo;