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 204: arp_util.debug( 'arp_rw_icr_pkg.update_row()+' );

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

219: arp_util.debug( 'Receipt Amount : '||p_receipt_amount );
220: arp_util.debug( 'Batch Id : '||p_batch_id );
221: arp_util.debug( 'Pay From Customer : '||p_pay_from_customer );
222: arp_util.debug( 'Cust. Bank Acct. ID: ' || p_customer_bank_account_id );
223: arp_util.debug( 'Cust. Bank Branch ID: ' || p_customer_bank_branch_id);
224: arp_util.debug( 'Site Use ID : '||p_site_use_id );
225: arp_util.debug( 'Anticipated Clearing Date: ' || p_anticipated_clearing_date);
226: arp_util.debug( 'Automatch set id : '|| p_automatch_set_id );
227: arp_util.debug( 'Autoapply flag: ' || p_autoapply_flag);

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

220: arp_util.debug( 'Batch Id : '||p_batch_id );
221: arp_util.debug( 'Pay From Customer : '||p_pay_from_customer );
222: arp_util.debug( 'Cust. Bank Acct. ID: ' || p_customer_bank_account_id );
223: arp_util.debug( 'Cust. Bank Branch ID: ' || p_customer_bank_branch_id);
224: arp_util.debug( 'Site Use ID : '||p_site_use_id );
225: arp_util.debug( 'Anticipated Clearing Date: ' || p_anticipated_clearing_date);
226: arp_util.debug( 'Automatch set id : '|| p_automatch_set_id );
227: arp_util.debug( 'Autoapply flag: ' || p_autoapply_flag);
228: END IF;

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

221: arp_util.debug( 'Pay From Customer : '||p_pay_from_customer );
222: arp_util.debug( 'Cust. Bank Acct. ID: ' || p_customer_bank_account_id );
223: arp_util.debug( 'Cust. Bank Branch ID: ' || p_customer_bank_branch_id);
224: arp_util.debug( 'Site Use ID : '||p_site_use_id );
225: arp_util.debug( 'Anticipated Clearing Date: ' || p_anticipated_clearing_date);
226: arp_util.debug( 'Automatch set id : '|| p_automatch_set_id );
227: arp_util.debug( 'Autoapply flag: ' || p_autoapply_flag);
228: END IF;
229: --

Line 226: arp_util.debug( 'Automatch set id : '|| p_automatch_set_id );

222: arp_util.debug( 'Cust. Bank Acct. ID: ' || p_customer_bank_account_id );
223: arp_util.debug( 'Cust. Bank Branch ID: ' || p_customer_bank_branch_id);
224: arp_util.debug( 'Site Use ID : '||p_site_use_id );
225: arp_util.debug( 'Anticipated Clearing Date: ' || p_anticipated_clearing_date);
226: arp_util.debug( 'Automatch set id : '|| p_automatch_set_id );
227: arp_util.debug( 'Autoapply flag: ' || p_autoapply_flag);
228: END IF;
229: --
230: arp_cr_icr_pkg.set_to_dummy( l_icr_rec );

Line 227: arp_util.debug( 'Autoapply flag: ' || p_autoapply_flag);

223: arp_util.debug( 'Cust. Bank Branch ID: ' || p_customer_bank_branch_id);
224: arp_util.debug( 'Site Use ID : '||p_site_use_id );
225: arp_util.debug( 'Anticipated Clearing Date: ' || p_anticipated_clearing_date);
226: arp_util.debug( 'Automatch set id : '|| p_automatch_set_id );
227: arp_util.debug( 'Autoapply flag: ' || p_autoapply_flag);
228: END IF;
229: --
230: arp_cr_icr_pkg.set_to_dummy( l_icr_rec );
231: --

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

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

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

328: --
329: EXCEPTION
330: WHEN OTHERS THEN
331: IF PG_DEBUG in ('Y', 'C') THEN
332: arp_util.debug( 'EXCEPTION: arp_rw_icr_pkg.update_row' );
333: END IF;
334: RAISE;
335: END update_row;
336: --

Line 347: | arp_util.debug - debug procedure |

343: | |
344: | SCOPE - PRIVATE |
345: | |
346: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
347: | arp_util.debug - debug procedure |
348: | |
349: | ARGUMENTS : IN: |
350: | p_receipt_number - Receipt Number |
351: | p_gl_date - GL Date |

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

379: p_remittance_bank_account_id IN
380: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE ) IS
381: BEGIN
382: IF PG_DEBUG in ('Y', 'C') THEN
383: arp_util.debug( 'arp_rw_icr_pkg.validate_args_update_row()+' );
384: END IF;
385: --
386: IF ( p_row_id IS NULL OR p_cr_id IS NULL OR
387: p_receipt_number IS NULL OR p_receipt_amount IS NULL OR

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

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

Line 405: arp_util.debug(

401: --
402: EXCEPTION
403: WHEN OTHERS THEN
404: IF PG_DEBUG in ('Y', 'C') THEN
405: arp_util.debug(
406: 'EXCEPTION: arp_rw_icr_pkg.validate_args_update_row' );
407: END IF;
408: RAISE;
409: END validate_args_update_row;

Line 423: | arp_util.debug - debug procedure |

419: | |
420: | SCOPE - PUBLIC |
421: | |
422: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
423: | arp_util.debug - debug procedure |
424: | |
425: | ARGUMENTS : IN: |
426: | p_receipt_number - Receipt Number |
427: | p_gl_date - GL Date |

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

529: l_icr_rec ar_interim_cash_receipts%ROWTYPE;
530: --
531: BEGIN
532: IF PG_DEBUG in ('Y', 'C') THEN
533: arp_util.debug( 'arp_rw_icr_pkg.insert_row()+' );
534: arp_util.debug( 'Special Type : '||p_special_type );
535: arp_util.debug( 'Receipt Number : '||p_receipt_number );
536: arp_util.debug( 'Receipt Date : '||TO_CHAR( p_receipt_date ) );
537: arp_util.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );

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

530: --
531: BEGIN
532: IF PG_DEBUG in ('Y', 'C') THEN
533: arp_util.debug( 'arp_rw_icr_pkg.insert_row()+' );
534: arp_util.debug( 'Special Type : '||p_special_type );
535: arp_util.debug( 'Receipt Number : '||p_receipt_number );
536: arp_util.debug( 'Receipt Date : '||TO_CHAR( p_receipt_date ) );
537: arp_util.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );
538: arp_util.debug( 'Received Amount : '||TO_CHAR( p_receipt_amount ) );

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

531: BEGIN
532: IF PG_DEBUG in ('Y', 'C') THEN
533: arp_util.debug( 'arp_rw_icr_pkg.insert_row()+' );
534: arp_util.debug( 'Special Type : '||p_special_type );
535: arp_util.debug( 'Receipt Number : '||p_receipt_number );
536: arp_util.debug( 'Receipt Date : '||TO_CHAR( p_receipt_date ) );
537: arp_util.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );
538: arp_util.debug( 'Received Amount : '||TO_CHAR( p_receipt_amount ) );
539: arp_util.debug( 'Amount Applied : '||TO_CHAR( p_amount_applied ) );

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

532: IF PG_DEBUG in ('Y', 'C') THEN
533: arp_util.debug( 'arp_rw_icr_pkg.insert_row()+' );
534: arp_util.debug( 'Special Type : '||p_special_type );
535: arp_util.debug( 'Receipt Number : '||p_receipt_number );
536: arp_util.debug( 'Receipt Date : '||TO_CHAR( p_receipt_date ) );
537: arp_util.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );
538: arp_util.debug( 'Received Amount : '||TO_CHAR( p_receipt_amount ) );
539: arp_util.debug( 'Amount Applied : '||TO_CHAR( p_amount_applied ) );
540: arp_util.debug( 'Cross Currency Rate: '||TO_CHAR( p_trans_to_receipt_rate) );

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

533: arp_util.debug( 'arp_rw_icr_pkg.insert_row()+' );
534: arp_util.debug( 'Special Type : '||p_special_type );
535: arp_util.debug( 'Receipt Number : '||p_receipt_number );
536: arp_util.debug( 'Receipt Date : '||TO_CHAR( p_receipt_date ) );
537: arp_util.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );
538: arp_util.debug( 'Received Amount : '||TO_CHAR( p_receipt_amount ) );
539: arp_util.debug( 'Amount Applied : '||TO_CHAR( p_amount_applied ) );
540: arp_util.debug( 'Cross Currency Rate: '||TO_CHAR( p_trans_to_receipt_rate) );
541: arp_util.debug( 'Bank Charges : '||TO_CHAR( p_factor_discount_amount ));

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

534: arp_util.debug( 'Special Type : '||p_special_type );
535: arp_util.debug( 'Receipt Number : '||p_receipt_number );
536: arp_util.debug( 'Receipt Date : '||TO_CHAR( p_receipt_date ) );
537: arp_util.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );
538: arp_util.debug( 'Received Amount : '||TO_CHAR( p_receipt_amount ) );
539: arp_util.debug( 'Amount Applied : '||TO_CHAR( p_amount_applied ) );
540: arp_util.debug( 'Cross Currency Rate: '||TO_CHAR( p_trans_to_receipt_rate) );
541: arp_util.debug( 'Bank Charges : '||TO_CHAR( p_factor_discount_amount ));
542: arp_util.debug( 'currency_code : '||p_currency_code );

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

535: arp_util.debug( 'Receipt Number : '||p_receipt_number );
536: arp_util.debug( 'Receipt Date : '||TO_CHAR( p_receipt_date ) );
537: arp_util.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );
538: arp_util.debug( 'Received Amount : '||TO_CHAR( p_receipt_amount ) );
539: arp_util.debug( 'Amount Applied : '||TO_CHAR( p_amount_applied ) );
540: arp_util.debug( 'Cross Currency Rate: '||TO_CHAR( p_trans_to_receipt_rate) );
541: arp_util.debug( 'Bank Charges : '||TO_CHAR( p_factor_discount_amount ));
542: arp_util.debug( 'currency_code : '||p_currency_code );
543: arp_util.debug( 'Method Id : '||p_receipt_method_id );

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

536: arp_util.debug( 'Receipt Date : '||TO_CHAR( p_receipt_date ) );
537: arp_util.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );
538: arp_util.debug( 'Received Amount : '||TO_CHAR( p_receipt_amount ) );
539: arp_util.debug( 'Amount Applied : '||TO_CHAR( p_amount_applied ) );
540: arp_util.debug( 'Cross Currency Rate: '||TO_CHAR( p_trans_to_receipt_rate) );
541: arp_util.debug( 'Bank Charges : '||TO_CHAR( p_factor_discount_amount ));
542: arp_util.debug( 'currency_code : '||p_currency_code );
543: arp_util.debug( 'Method Id : '||p_receipt_method_id );
544: arp_util.debug( 'Bank Account Id : '||p_remittance_bank_account_id );

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

537: arp_util.debug( 'GL Date : '||TO_CHAR( p_gl_date ) );
538: arp_util.debug( 'Received Amount : '||TO_CHAR( p_receipt_amount ) );
539: arp_util.debug( 'Amount Applied : '||TO_CHAR( p_amount_applied ) );
540: arp_util.debug( 'Cross Currency Rate: '||TO_CHAR( p_trans_to_receipt_rate) );
541: arp_util.debug( 'Bank Charges : '||TO_CHAR( p_factor_discount_amount ));
542: arp_util.debug( 'currency_code : '||p_currency_code );
543: arp_util.debug( 'Method Id : '||p_receipt_method_id );
544: arp_util.debug( 'Bank Account Id : '||p_remittance_bank_account_id );
545: arp_util.debug( 'Receipt Amount : '||p_receipt_amount );

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

538: arp_util.debug( 'Received Amount : '||TO_CHAR( p_receipt_amount ) );
539: arp_util.debug( 'Amount Applied : '||TO_CHAR( p_amount_applied ) );
540: arp_util.debug( 'Cross Currency Rate: '||TO_CHAR( p_trans_to_receipt_rate) );
541: arp_util.debug( 'Bank Charges : '||TO_CHAR( p_factor_discount_amount ));
542: arp_util.debug( 'currency_code : '||p_currency_code );
543: arp_util.debug( 'Method Id : '||p_receipt_method_id );
544: arp_util.debug( 'Bank Account Id : '||p_remittance_bank_account_id );
545: arp_util.debug( 'Receipt Amount : '||p_receipt_amount );
546: arp_util.debug( 'Batch Id : '||p_batch_id );

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

539: arp_util.debug( 'Amount Applied : '||TO_CHAR( p_amount_applied ) );
540: arp_util.debug( 'Cross Currency Rate: '||TO_CHAR( p_trans_to_receipt_rate) );
541: arp_util.debug( 'Bank Charges : '||TO_CHAR( p_factor_discount_amount ));
542: arp_util.debug( 'currency_code : '||p_currency_code );
543: arp_util.debug( 'Method Id : '||p_receipt_method_id );
544: arp_util.debug( 'Bank Account Id : '||p_remittance_bank_account_id );
545: arp_util.debug( 'Receipt Amount : '||p_receipt_amount );
546: arp_util.debug( 'Batch Id : '||p_batch_id );
547: arp_util.debug( 'Pay From Customer : '||p_pay_from_customer );

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

540: arp_util.debug( 'Cross Currency Rate: '||TO_CHAR( p_trans_to_receipt_rate) );
541: arp_util.debug( 'Bank Charges : '||TO_CHAR( p_factor_discount_amount ));
542: arp_util.debug( 'currency_code : '||p_currency_code );
543: arp_util.debug( 'Method Id : '||p_receipt_method_id );
544: arp_util.debug( 'Bank Account Id : '||p_remittance_bank_account_id );
545: arp_util.debug( 'Receipt Amount : '||p_receipt_amount );
546: arp_util.debug( 'Batch Id : '||p_batch_id );
547: arp_util.debug( 'Pay From Customer : '||p_pay_from_customer );
548: arp_util.debug( 'Cust Bank Acct ID : '||p_customer_bank_account_id );

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

541: arp_util.debug( 'Bank Charges : '||TO_CHAR( p_factor_discount_amount ));
542: arp_util.debug( 'currency_code : '||p_currency_code );
543: arp_util.debug( 'Method Id : '||p_receipt_method_id );
544: arp_util.debug( 'Bank Account Id : '||p_remittance_bank_account_id );
545: arp_util.debug( 'Receipt Amount : '||p_receipt_amount );
546: arp_util.debug( 'Batch Id : '||p_batch_id );
547: arp_util.debug( 'Pay From Customer : '||p_pay_from_customer );
548: arp_util.debug( 'Cust Bank Acct ID : '||p_customer_bank_account_id );
549: arp_util.debug( 'Cust Bank Branch ID : '||p_customer_bank_branch_id );

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

542: arp_util.debug( 'currency_code : '||p_currency_code );
543: arp_util.debug( 'Method Id : '||p_receipt_method_id );
544: arp_util.debug( 'Bank Account Id : '||p_remittance_bank_account_id );
545: arp_util.debug( 'Receipt Amount : '||p_receipt_amount );
546: arp_util.debug( 'Batch Id : '||p_batch_id );
547: arp_util.debug( 'Pay From Customer : '||p_pay_from_customer );
548: arp_util.debug( 'Cust Bank Acct ID : '||p_customer_bank_account_id );
549: arp_util.debug( 'Cust Bank Branch ID : '||p_customer_bank_branch_id );
550: arp_util.debug( 'Site Use ID : '||p_site_use_id );

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

543: arp_util.debug( 'Method Id : '||p_receipt_method_id );
544: arp_util.debug( 'Bank Account Id : '||p_remittance_bank_account_id );
545: arp_util.debug( 'Receipt Amount : '||p_receipt_amount );
546: arp_util.debug( 'Batch Id : '||p_batch_id );
547: arp_util.debug( 'Pay From Customer : '||p_pay_from_customer );
548: arp_util.debug( 'Cust Bank Acct ID : '||p_customer_bank_account_id );
549: arp_util.debug( 'Cust Bank Branch ID : '||p_customer_bank_branch_id );
550: arp_util.debug( 'Site Use ID : '||p_site_use_id );
551: arp_util.debug( 'Automatch set id : '|| p_automatch_set_id );

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

544: arp_util.debug( 'Bank Account Id : '||p_remittance_bank_account_id );
545: arp_util.debug( 'Receipt Amount : '||p_receipt_amount );
546: arp_util.debug( 'Batch Id : '||p_batch_id );
547: arp_util.debug( 'Pay From Customer : '||p_pay_from_customer );
548: arp_util.debug( 'Cust Bank Acct ID : '||p_customer_bank_account_id );
549: arp_util.debug( 'Cust Bank Branch ID : '||p_customer_bank_branch_id );
550: arp_util.debug( 'Site Use ID : '||p_site_use_id );
551: arp_util.debug( 'Automatch set id : '|| p_automatch_set_id );
552: arp_util.debug( 'Autoapply flag: ' || p_autoapply_flag);

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

545: arp_util.debug( 'Receipt Amount : '||p_receipt_amount );
546: arp_util.debug( 'Batch Id : '||p_batch_id );
547: arp_util.debug( 'Pay From Customer : '||p_pay_from_customer );
548: arp_util.debug( 'Cust Bank Acct ID : '||p_customer_bank_account_id );
549: arp_util.debug( 'Cust Bank Branch ID : '||p_customer_bank_branch_id );
550: arp_util.debug( 'Site Use ID : '||p_site_use_id );
551: arp_util.debug( 'Automatch set id : '|| p_automatch_set_id );
552: arp_util.debug( 'Autoapply flag: ' || p_autoapply_flag);
553: END IF;

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

546: arp_util.debug( 'Batch Id : '||p_batch_id );
547: arp_util.debug( 'Pay From Customer : '||p_pay_from_customer );
548: arp_util.debug( 'Cust Bank Acct ID : '||p_customer_bank_account_id );
549: arp_util.debug( 'Cust Bank Branch ID : '||p_customer_bank_branch_id );
550: arp_util.debug( 'Site Use ID : '||p_site_use_id );
551: arp_util.debug( 'Automatch set id : '|| p_automatch_set_id );
552: arp_util.debug( 'Autoapply flag: ' || p_autoapply_flag);
553: END IF;
554: --

Line 551: arp_util.debug( 'Automatch set id : '|| p_automatch_set_id );

547: arp_util.debug( 'Pay From Customer : '||p_pay_from_customer );
548: arp_util.debug( 'Cust Bank Acct ID : '||p_customer_bank_account_id );
549: arp_util.debug( 'Cust Bank Branch ID : '||p_customer_bank_branch_id );
550: arp_util.debug( 'Site Use ID : '||p_site_use_id );
551: arp_util.debug( 'Automatch set id : '|| p_automatch_set_id );
552: arp_util.debug( 'Autoapply flag: ' || p_autoapply_flag);
553: END IF;
554: --
555: l_icr_rec.amount := p_receipt_amount;

Line 552: arp_util.debug( 'Autoapply flag: ' || p_autoapply_flag);

548: arp_util.debug( 'Cust Bank Acct ID : '||p_customer_bank_account_id );
549: arp_util.debug( 'Cust Bank Branch ID : '||p_customer_bank_branch_id );
550: arp_util.debug( 'Site Use ID : '||p_site_use_id );
551: arp_util.debug( 'Automatch set id : '|| p_automatch_set_id );
552: arp_util.debug( 'Autoapply flag: ' || p_autoapply_flag);
553: END IF;
554: --
555: l_icr_rec.amount := p_receipt_amount;
556: l_icr_rec.amount_applied := p_amount_applied;

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

645: NULL, NULL );
646: --
647: -- Check for valid GL date
648: --
649: arp_util.validate_gl_date( l_icr_rec.gl_date, NULL,
650: NULL );
651:
652:
653: -- Do the actual Insertion

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

661: -- Update batch table to set status
662: --
663:
664: IF PG_DEBUG in ('Y', 'C') THEN
665: arp_util.debug( 'Batch ID is : '|| l_icr_rec.batch_id );
666: END IF;
667:
668: arp_rw_batches_check_pkg.update_batch_status( l_icr_rec.batch_id );
669:

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

669:
670:
671: --
672: IF PG_DEBUG in ('Y', 'C') THEN
673: arp_util.debug( 'arp_rw_icr_pkg.insert_row()-' );
674: END IF;
675: --
676: EXCEPTION
677: WHEN OTHERS THEN

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

675: --
676: EXCEPTION
677: WHEN OTHERS THEN
678: IF PG_DEBUG in ('Y', 'C') THEN
679: arp_util.debug( 'EXCEPTION: arp_rw_icr_pkg.insert_row' );
680: END IF;
681: RAISE;
682: END insert_row;
683: --

Line 694: | arp_util.debug - debug procedure |

690: | |
691: | SCOPE - PRIVATE |
692: | |
693: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
694: | arp_util.debug - debug procedure |
695: | |
696: | ARGUMENTS : IN: |
697: | p_receipt_number - Receipt Number |
698: | p_gl_date - GL Date |

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

729: p_remittance_bank_account_id IN
730: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE ) IS
731: BEGIN
732: IF PG_DEBUG in ('Y', 'C') THEN
733: arp_util.debug( 'arp_rw_icr_pkg.validate_args_insert_row()+' );
734: END IF;
735: --
736: IF ( p_row_id IS NOT NULL OR p_cr_id IS NOT NULL ) THEN
737: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );

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

751: p_site_use_id, p_customer_trx_id,
752: p_payment_schedule_id );
753: --
754: IF PG_DEBUG in ('Y', 'C') THEN
755: arp_util.debug( 'arp_rw_icr_pkg.validate_args_insert_row()-' );
756: END IF;
757: --
758: EXCEPTION
759: WHEN OTHERS THEN

Line 761: arp_util.debug(

757: --
758: EXCEPTION
759: WHEN OTHERS THEN
760: IF PG_DEBUG in ('Y', 'C') THEN
761: arp_util.debug(
762: 'EXCEPTION: arp_rw_icr_pkg.validate_args_insert_row' );
763: END IF;
764: RAISE;
765: END validate_args_insert_row;

Line 777: | arp_util.debug - debug procedure |

773: | |
774: | SCOPE - PRIVATE |
775: | |
776: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
777: | arp_util.debug - debug procedure |
778: | |
779: | ARGUMENTS : IN: |
780: | p_special_type - Type of the receipt |
781: | pay_from_custmer - Customer Id |

Line 844: | arp_util.debug - debug procedure |

840: | |
841: | SCOPE - PUBLIC |
842: | |
843: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
844: | arp_util.debug - debug procedure |
845: | |
846: | ARGUMENTS : IN: |
847: | p_cr_id - Interim Cash reveipt ID |
848: | p_module_name - Module that called this procedure |

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

869: p_module_name IN VARCHAR2,
870: p_module_version IN VARCHAR2 ) IS
871: BEGIN
872: IF PG_DEBUG in ('Y', 'C') THEN
873: arp_util.debug( 'arp_rw_icr_pkg.get_applied_amount_total()+' );
874: arp_util.debug('get_applied_amount_total: ' || 'Icr Id : '||p_cr_id );
875: END IF;
876: --
877: -- Validate args.

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

870: p_module_version IN VARCHAR2 ) IS
871: BEGIN
872: IF PG_DEBUG in ('Y', 'C') THEN
873: arp_util.debug( 'arp_rw_icr_pkg.get_applied_amount_total()+' );
874: arp_util.debug('get_applied_amount_total: ' || 'Icr Id : '||p_cr_id );
875: END IF;
876: --
877: -- Validate args.
878: --

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

886: FROM ar_interim_cash_receipt_lines
887: WHERE cash_receipt_id = p_cr_id;
888: --
889: IF PG_DEBUG in ('Y', 'C') THEN
890: arp_util.debug( 'arp_rw_icr_pkg.get_applied_amount_total()-' );
891: END IF;
892: --
893: EXCEPTION
894: WHEN OTHERS THEN

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

892: --
893: EXCEPTION
894: WHEN OTHERS THEN
895: IF PG_DEBUG in ('Y', 'C') THEN
896: arp_util.debug('get_applied_amount_total: ' ||
897: 'EXCEPTION: arp_rw_icr_pkg.get_applied_amount_total' );
898: END IF;
899: RAISE;
900: END get_applied_amount_total;

Line 912: | arp_util.debug - debug procedure |

908: | |
909: | SCOPE - PRIVATE |
910: | |
911: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
912: | arp_util.debug - debug procedure |
913: | |
914: | ARGUMENTS : IN: |
915: | p_cr_id - ICR_ID |
916: | OUT: |

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

925: PROCEDURE val_args_applied_amount_total(
926: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE ) IS
927: BEGIN
928: IF PG_DEBUG in ('Y', 'C') THEN
929: arp_util.debug( 'arp_rw_icr_pkg.val_args_applied_amount_total()+' );
930: END IF;
931: --
932: IF ( p_cr_id is NULL ) THEN
933: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );

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

934: APP_EXCEPTION.raise_exception;
935: END IF;
936: --
937: IF PG_DEBUG in ('Y', 'C') THEN
938: arp_util.debug( 'arp_rw_icr_pkg.val_args_applied_amount_total()-' );
939: END IF;
940: --
941: EXCEPTION
942: WHEN OTHERS THEN

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

940: --
941: EXCEPTION
942: WHEN OTHERS THEN
943: IF PG_DEBUG in ('Y', 'C') THEN
944: arp_util.debug('val_args_applied_amount_total: ' ||
945: 'EXCEPTION: arp_rw_icr_pkg.val_args_applied_amount_total' );
946: END IF;
947: RAISE;
948: END val_args_applied_amount_total;

Line 960: | arp_util.debug - debug procedure |

956: | |
957: | SCOPE - PUBLIC |
958: | |
959: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
960: | arp_util.debug - debug procedure |
961: | |
962: | ARGUMENTS : IN: |
963: | p_cr_id - Cash receipt Id |
964: | p_receipt_number - Receipt Number |

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

988: p_module_version IN VARCHAR2 ) IS
989: l_count NUMBER := 0;
990: BEGIN
991: IF PG_DEBUG in ('Y', 'C') THEN
992: arp_util.debug( 'arp_rw_icr_pkg.check_unique_receipt()+' );
993: arp_util.debug( 'Row Id : '||p_row_id );
994: arp_util.debug( 'Icr Id : '||p_cr_id );
995: arp_util.debug( 'Receipt Number : '||p_receipt_number );
996: arp_util.debug( 'Customer ID : '||p_customer_id );

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

989: l_count NUMBER := 0;
990: BEGIN
991: IF PG_DEBUG in ('Y', 'C') THEN
992: arp_util.debug( 'arp_rw_icr_pkg.check_unique_receipt()+' );
993: arp_util.debug( 'Row Id : '||p_row_id );
994: arp_util.debug( 'Icr Id : '||p_cr_id );
995: arp_util.debug( 'Receipt Number : '||p_receipt_number );
996: arp_util.debug( 'Customer ID : '||p_customer_id );
997: arp_util.debug( 'Receipt Amount : '||p_receipt_amount );

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

990: BEGIN
991: IF PG_DEBUG in ('Y', 'C') THEN
992: arp_util.debug( 'arp_rw_icr_pkg.check_unique_receipt()+' );
993: arp_util.debug( 'Row Id : '||p_row_id );
994: arp_util.debug( 'Icr Id : '||p_cr_id );
995: arp_util.debug( 'Receipt Number : '||p_receipt_number );
996: arp_util.debug( 'Customer ID : '||p_customer_id );
997: arp_util.debug( 'Receipt Amount : '||p_receipt_amount );
998: END IF;

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

991: IF PG_DEBUG in ('Y', 'C') THEN
992: arp_util.debug( 'arp_rw_icr_pkg.check_unique_receipt()+' );
993: arp_util.debug( 'Row Id : '||p_row_id );
994: arp_util.debug( 'Icr Id : '||p_cr_id );
995: arp_util.debug( 'Receipt Number : '||p_receipt_number );
996: arp_util.debug( 'Customer ID : '||p_customer_id );
997: arp_util.debug( 'Receipt Amount : '||p_receipt_amount );
998: END IF;
999: --

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

992: arp_util.debug( 'arp_rw_icr_pkg.check_unique_receipt()+' );
993: arp_util.debug( 'Row Id : '||p_row_id );
994: arp_util.debug( 'Icr Id : '||p_cr_id );
995: arp_util.debug( 'Receipt Number : '||p_receipt_number );
996: arp_util.debug( 'Customer ID : '||p_customer_id );
997: arp_util.debug( 'Receipt Amount : '||p_receipt_amount );
998: END IF;
999: --
1000: -- Validate args. Note: Cash Receipt Id can be null

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

993: arp_util.debug( 'Row Id : '||p_row_id );
994: arp_util.debug( 'Icr Id : '||p_cr_id );
995: arp_util.debug( 'Receipt Number : '||p_receipt_number );
996: arp_util.debug( 'Customer ID : '||p_customer_id );
997: arp_util.debug( 'Receipt Amount : '||p_receipt_amount );
998: END IF;
999: --
1000: -- Validate args. Note: Cash Receipt Id can be null
1001: --

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

1041: APP_EXCEPTION.raise_exception;
1042: END IF;
1043: --
1044: IF PG_DEBUG in ('Y', 'C') THEN
1045: arp_util.debug( 'arp_rw_icr_pkg.check_unique_receipt()-' );
1046: END IF;
1047: --
1048: EXCEPTION
1049: WHEN OTHERS THEN

Line 1051: arp_util.debug(

1047: --
1048: EXCEPTION
1049: WHEN OTHERS THEN
1050: IF PG_DEBUG in ('Y', 'C') THEN
1051: arp_util.debug(
1052: 'EXCEPTION: arp_rw_icr_pkg.check_unique_receipt' );
1053: END IF;
1054: RAISE;
1055: END check_unique_receipt;

Line 1067: | arp_util.debug - debug procedure |

1063: | |
1064: | SCOPE - PRIVATE |
1065: | |
1066: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
1067: | arp_util.debug - debug procedure |
1068: | |
1069: | ARGUMENTS : IN: |
1070: | p_receipt_number - Receipt Number |
1071: | p_customer_id - Customer ID |

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

1085: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
1086: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE ) IS
1087: BEGIN
1088: IF PG_DEBUG in ('Y', 'C') THEN
1089: arp_util.debug( 'arp_rw_icr_pkg.val_args_check_unique_receipt()+' );
1090: END IF;
1091: --
1092: --
1093: -- Note: Special type can be NULL

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

1102: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
1103: APP_EXCEPTION.raise_exception;
1104: END IF;
1105: IF PG_DEBUG in ('Y', 'C') THEN
1106: arp_util.debug( 'arp_rw_icr_pkg.val_args_check_unique_receipt()-' );
1107: END IF;
1108: --
1109: EXCEPTION
1110: WHEN OTHERS THEN

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

1108: --
1109: EXCEPTION
1110: WHEN OTHERS THEN
1111: IF PG_DEBUG in ('Y', 'C') THEN
1112: arp_util.debug('val_args_check_unique_receipt: ' ||
1113: 'EXCEPTION: arp_rw_icr_pkg.val_args_check_unique_receipt' );
1114: END IF;
1115: RAISE;
1116: END val_args_check_unique_receipt;

Line 1129: | arp_util.debug - debug procedure |

1125: | |
1126: | SCOPE - PUBLIC |
1127: | |
1128: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1129: | arp_util.debug - debug procedure |
1130: | |
1131: | ARGUMENTS : IN: |
1132: | p_cr_id - Cash receipt Id |
1133: | p_module_name - Module that called this procedure |

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

1148: l_count NUMBER;
1149: BEGIN
1150: --
1151: IF PG_DEBUG in ('Y', 'C') THEN
1152: arp_util.debug( 'arp_rw_icr_pkg.lines_exists()+' );
1153: END IF;
1154: --
1155: -- Do argument validation, Note: No separate procedure used
1156: --

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

1172: RETURN TRUE;
1173: END IF;
1174: --
1175: IF PG_DEBUG in ('Y', 'C') THEN
1176: arp_util.debug( 'arp_rw_icr_pkg.lines_exists()-' );
1177: END IF;
1178: --
1179: EXCEPTION
1180: WHEN OTHERS THEN

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

1178: --
1179: EXCEPTION
1180: WHEN OTHERS THEN
1181: IF PG_DEBUG in ('Y', 'C') THEN
1182: arp_util.debug('lines_exists: ' ||
1183: 'EXCEPTION: arp_rw_icr_pkg.lines_exists' );
1184: END IF;
1185: RAISE;
1186: END lines_exists;

Line 1199: | arp_util.debug - debug procedure |

1195: | |
1196: | SCOPE - PUBLIC |
1197: | |
1198: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1199: | arp_util.debug - debug procedure |
1200: | |
1201: | ARGUMENTS : IN: |
1202: | p_cr_id - Cash receipt Id |
1203: | p_module_name - Module that called this procedure |

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

1216: p_module_name IN VARCHAR2,
1217: p_module_version IN VARCHAR2 ) IS
1218: BEGIN
1219: IF PG_DEBUG in ('Y', 'C') THEN
1220: arp_util.debug( 'arp_rw_icr_pkg.check_no_lines_exists()-' );
1221: END IF;
1222: --
1223: -- Do argument validation, Note: No separate procedure used
1224: --

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

1234: APP_EXCEPTION.raise_exception;
1235: END IF;
1236: --
1237: IF PG_DEBUG in ('Y', 'C') THEN
1238: arp_util.debug( 'arp_rw_icr_pkg.check_no_lines_exists()-' );
1239: END IF;
1240: --
1241: EXCEPTION
1242: WHEN OTHERS THEN

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

1240: --
1241: EXCEPTION
1242: WHEN OTHERS THEN
1243: IF PG_DEBUG in ('Y', 'C') THEN
1244: arp_util.debug('check_no_lines_exists: ' ||
1245: 'EXCEPTION: arp_rw_icr_pkg.check_no_lines_exists' );
1246: END IF;
1247: RAISE;
1248: END check_no_lines_exists;

Line 1260: | arp_util.debug - debug procedure |

1256: | |
1257: | SCOPE - PRIVATE |
1258: | |
1259: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1260: | arp_util.debug - debug procedure |
1261: | |
1262: | ARGUMENTS : IN: |
1263: | p_customer_id - customer id |
1264: | p_bank_account_id - bank_account Id |

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

1274: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
1275: p_bank_account_id IN ar_batches.remit_bank_acct_use_id%TYPE ) IS
1276: BEGIN
1277: IF PG_DEBUG in ('Y', 'C') THEN
1278: arp_util.debug( 'arp_rw_icr_pkg.update_bank_account_uses()+' );
1279: arp_util.debug('update_bank_account_uses: ' || 'Customer ID : '||p_customer_id );
1280: arp_util.debug('update_bank_account_uses: ' || 'Bank Account Id : '||p_bank_account_id );
1281: END IF;
1282: --

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

1275: p_bank_account_id IN ar_batches.remit_bank_acct_use_id%TYPE ) IS
1276: BEGIN
1277: IF PG_DEBUG in ('Y', 'C') THEN
1278: arp_util.debug( 'arp_rw_icr_pkg.update_bank_account_uses()+' );
1279: arp_util.debug('update_bank_account_uses: ' || 'Customer ID : '||p_customer_id );
1280: arp_util.debug('update_bank_account_uses: ' || 'Bank Account Id : '||p_bank_account_id );
1281: END IF;
1282: --
1283: IF PG_DEBUG in ('Y', 'C') THEN

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

1276: BEGIN
1277: IF PG_DEBUG in ('Y', 'C') THEN
1278: arp_util.debug( 'arp_rw_icr_pkg.update_bank_account_uses()+' );
1279: arp_util.debug('update_bank_account_uses: ' || 'Customer ID : '||p_customer_id );
1280: arp_util.debug('update_bank_account_uses: ' || 'Bank Account Id : '||p_bank_account_id );
1281: END IF;
1282: --
1283: IF PG_DEBUG in ('Y', 'C') THEN
1284: arp_util.debug( 'arp_rw_icr_pkg.update_bank_account_uses()-' );

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

1280: arp_util.debug('update_bank_account_uses: ' || 'Bank Account Id : '||p_bank_account_id );
1281: END IF;
1282: --
1283: IF PG_DEBUG in ('Y', 'C') THEN
1284: arp_util.debug( 'arp_rw_icr_pkg.update_bank_account_uses()-' );
1285: END IF;
1286: --
1287: END update_bank_account_uses;
1288: --

Line 1301: | arp_util.debug - debug procedure |

1297: | |
1298: | SCOPE - PUBLIC |
1299: | |
1300: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1301: | arp_util.debug - debug procedure |
1302: | |
1303: | ARGUMENTS : IN: |
1304: | p_cr_id - Cash Receipt ID |
1305: | p_row_id - Row Id |

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

1321: p_module_name IN VARCHAR2,
1322: p_module_version IN VARCHAR2 ) IS
1323: BEGIN
1324: IF PG_DEBUG in ('Y', 'C') THEN
1325: arp_util.debug( 'arp_rw_icr_pkg.delete_row()+' );
1326: END IF;
1327: --
1328: IF ( p_module_name IS NOT NULL AND p_module_version IS NOT NULL ) THEN
1329: IF ( p_cr_id is NULL OR p_row_id IS NULL ) THEN

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

1337: arp_cr_icr_lines_pkg.delete_fk( p_cr_id );
1338: arp_cr_icr_pkg.delete_p( p_cr_id );
1339: --
1340: IF PG_DEBUG in ('Y', 'C') THEN
1341: arp_util.debug( 'arp_rw_icr_pkg.delete_row()-' );
1342: END IF;
1343: --
1344: EXCEPTION
1345: WHEN OTHERS THEN

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

1343: --
1344: EXCEPTION
1345: WHEN OTHERS THEN
1346: IF PG_DEBUG in ('Y', 'C') THEN
1347: arp_util.debug('delete_row: ' ||
1348: 'EXCEPTION: arp_rw_icr_pkg.delete_row' );
1349: END IF;
1350: RAISE;
1351: END delete_row;

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

1441: --
1442: BEGIN
1443:
1444: IF PG_DEBUG in ('Y', 'C') THEN
1445: arp_util.debug('lock_row: ' || 'Made it to lock row' );
1446: END IF;
1447:
1448: OPEN C;
1449: FETCH C INTO Recinfo;