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_PROCESS_CREDIT dependencies on ARP_UTIL

Line 35: | arp_util.debug |

31: | |
32: | SCOPE - PRIVATE |
33: | |
34: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
35: | arp_util.debug |
36: | arp_ctls_pkg.insert_f_cm_ct_ctl_id |
37: | |
38: | ARGUMENTS : IN: |
39: | p_customer_trx_id |

Line 66: arp_util.debug('arp_process_credit.create_salescredits()+');

62: p_currency_code IN fnd_currencies.currency_code%type)
63: IS
64: BEGIN
65:
66: arp_util.debug('arp_process_credit.create_salescredits()+');
67:
68: IF (p_customer_trx_line_id IS NULL)
69: THEN
70:

Line 104: arp_util.debug('arp_process_credit.create_salescredits()-');

100: p_currency_code);
101: END IF;
102: END IF;
103:
104: arp_util.debug('arp_process_credit.create_salescredits()-');
105:
106: EXCEPTION
107: WHEN OTHERS THEN
108: arp_util.debug('EXCEPTION: arp_process_credit.create_salescredits()');

Line 108: arp_util.debug('EXCEPTION: arp_process_credit.create_salescredits()');

104: arp_util.debug('arp_process_credit.create_salescredits()-');
105:
106: EXCEPTION
107: WHEN OTHERS THEN
108: arp_util.debug('EXCEPTION: arp_process_credit.create_salescredits()');
109: arp_util.debug('');
110: arp_util.debug('p_customer_trx_id = '||p_customer_trx_id);
111: arp_util.debug('p_customer_trx_line_id = '||p_customer_trx_line_id);
112: arp_util.debug('p_memo_line_type = '||p_memo_line_type);

Line 109: arp_util.debug('');

105:
106: EXCEPTION
107: WHEN OTHERS THEN
108: arp_util.debug('EXCEPTION: arp_process_credit.create_salescredits()');
109: arp_util.debug('');
110: arp_util.debug('p_customer_trx_id = '||p_customer_trx_id);
111: arp_util.debug('p_customer_trx_line_id = '||p_customer_trx_line_id);
112: arp_util.debug('p_memo_line_type = '||p_memo_line_type);
113: arp_util.debug('p_primary_salesrep_id = '||p_primary_salesrep_id);

Line 110: arp_util.debug('p_customer_trx_id = '||p_customer_trx_id);

106: EXCEPTION
107: WHEN OTHERS THEN
108: arp_util.debug('EXCEPTION: arp_process_credit.create_salescredits()');
109: arp_util.debug('');
110: arp_util.debug('p_customer_trx_id = '||p_customer_trx_id);
111: arp_util.debug('p_customer_trx_line_id = '||p_customer_trx_line_id);
112: arp_util.debug('p_memo_line_type = '||p_memo_line_type);
113: arp_util.debug('p_primary_salesrep_id = '||p_primary_salesrep_id);
114: arp_util.debug('p_currency_code = '||p_currency_code);

Line 111: arp_util.debug('p_customer_trx_line_id = '||p_customer_trx_line_id);

107: WHEN OTHERS THEN
108: arp_util.debug('EXCEPTION: arp_process_credit.create_salescredits()');
109: arp_util.debug('');
110: arp_util.debug('p_customer_trx_id = '||p_customer_trx_id);
111: arp_util.debug('p_customer_trx_line_id = '||p_customer_trx_line_id);
112: arp_util.debug('p_memo_line_type = '||p_memo_line_type);
113: arp_util.debug('p_primary_salesrep_id = '||p_primary_salesrep_id);
114: arp_util.debug('p_currency_code = '||p_currency_code);
115:

Line 112: arp_util.debug('p_memo_line_type = '||p_memo_line_type);

108: arp_util.debug('EXCEPTION: arp_process_credit.create_salescredits()');
109: arp_util.debug('');
110: arp_util.debug('p_customer_trx_id = '||p_customer_trx_id);
111: arp_util.debug('p_customer_trx_line_id = '||p_customer_trx_line_id);
112: arp_util.debug('p_memo_line_type = '||p_memo_line_type);
113: arp_util.debug('p_primary_salesrep_id = '||p_primary_salesrep_id);
114: arp_util.debug('p_currency_code = '||p_currency_code);
115:
116: RAISE;

Line 113: arp_util.debug('p_primary_salesrep_id = '||p_primary_salesrep_id);

109: arp_util.debug('');
110: arp_util.debug('p_customer_trx_id = '||p_customer_trx_id);
111: arp_util.debug('p_customer_trx_line_id = '||p_customer_trx_line_id);
112: arp_util.debug('p_memo_line_type = '||p_memo_line_type);
113: arp_util.debug('p_primary_salesrep_id = '||p_primary_salesrep_id);
114: arp_util.debug('p_currency_code = '||p_currency_code);
115:
116: RAISE;
117: END;

Line 114: arp_util.debug('p_currency_code = '||p_currency_code);

110: arp_util.debug('p_customer_trx_id = '||p_customer_trx_id);
111: arp_util.debug('p_customer_trx_line_id = '||p_customer_trx_line_id);
112: arp_util.debug('p_memo_line_type = '||p_memo_line_type);
113: arp_util.debug('p_primary_salesrep_id = '||p_primary_salesrep_id);
114: arp_util.debug('p_currency_code = '||p_currency_code);
115:
116: RAISE;
117: END;
118:

Line 129: | arp_util.debug |

125: | |
126: | SCOPE - PRIVATE |
127: | |
128: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
129: | arp_util.debug |
130: | |
131: | ARGUMENTS : IN: |
132: | p_form_name |
133: | p_form_version |

Line 173: arp_util.debug('arp_process_credit.credit_freight()+');

169: l_sob_id ra_customer_trx_lines.set_of_books_id%type;
170: l_frt_rec ra_customer_trx_lines%rowtype;
171: BEGIN
172:
173: arp_util.debug('arp_process_credit.credit_freight()+');
174:
175: IF ( p_prev_ct_id IS NULL)
176: OR
177: ( p_prev_ct_id IS NOT NULL

Line 298: arp_util.debug('arp_process_credit.credit_freight()-');

294: 'FREIGHT');
295: END IF;
296: END IF;
297:
298: arp_util.debug('arp_process_credit.credit_freight()-');
299:
300: EXCEPTION
301: WHEN OTHERS THEN
302: arp_util.debug('EXCEPTION: arp_process_credit.credit_freight');

Line 302: arp_util.debug('EXCEPTION: arp_process_credit.credit_freight');

298: arp_util.debug('arp_process_credit.credit_freight()-');
299:
300: EXCEPTION
301: WHEN OTHERS THEN
302: arp_util.debug('EXCEPTION: arp_process_credit.credit_freight');
303: arp_util.debug('');
304: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);
305: arp_util.debug('p_customer_trx_line_id : '||p_customer_trx_line_id);
306: arp_util.debug('p_prev_ct_id : '||p_prev_ct_id);

Line 303: arp_util.debug('');

299:
300: EXCEPTION
301: WHEN OTHERS THEN
302: arp_util.debug('EXCEPTION: arp_process_credit.credit_freight');
303: arp_util.debug('');
304: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);
305: arp_util.debug('p_customer_trx_line_id : '||p_customer_trx_line_id);
306: arp_util.debug('p_prev_ct_id : '||p_prev_ct_id);
307: arp_util.debug('p_prev_ctl_id : '||p_prev_ctl_id);

Line 304: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);

300: EXCEPTION
301: WHEN OTHERS THEN
302: arp_util.debug('EXCEPTION: arp_process_credit.credit_freight');
303: arp_util.debug('');
304: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);
305: arp_util.debug('p_customer_trx_line_id : '||p_customer_trx_line_id);
306: arp_util.debug('p_prev_ct_id : '||p_prev_ct_id);
307: arp_util.debug('p_prev_ctl_id : '||p_prev_ctl_id);
308: arp_util.debug('p_credit_freight_amount : '||p_credit_freight_amount);

Line 305: arp_util.debug('p_customer_trx_line_id : '||p_customer_trx_line_id);

301: WHEN OTHERS THEN
302: arp_util.debug('EXCEPTION: arp_process_credit.credit_freight');
303: arp_util.debug('');
304: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);
305: arp_util.debug('p_customer_trx_line_id : '||p_customer_trx_line_id);
306: arp_util.debug('p_prev_ct_id : '||p_prev_ct_id);
307: arp_util.debug('p_prev_ctl_id : '||p_prev_ctl_id);
308: arp_util.debug('p_credit_freight_amount : '||p_credit_freight_amount);
309: arp_util.debug('p_uncr_freight_amount : '||p_uncr_freight_amount);

Line 306: arp_util.debug('p_prev_ct_id : '||p_prev_ct_id);

302: arp_util.debug('EXCEPTION: arp_process_credit.credit_freight');
303: arp_util.debug('');
304: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);
305: arp_util.debug('p_customer_trx_line_id : '||p_customer_trx_line_id);
306: arp_util.debug('p_prev_ct_id : '||p_prev_ct_id);
307: arp_util.debug('p_prev_ctl_id : '||p_prev_ctl_id);
308: arp_util.debug('p_credit_freight_amount : '||p_credit_freight_amount);
309: arp_util.debug('p_uncr_freight_amount : '||p_uncr_freight_amount);
310: arp_util.debug('p_freight_type : '||p_freight_type);

Line 307: arp_util.debug('p_prev_ctl_id : '||p_prev_ctl_id);

303: arp_util.debug('');
304: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);
305: arp_util.debug('p_customer_trx_line_id : '||p_customer_trx_line_id);
306: arp_util.debug('p_prev_ct_id : '||p_prev_ct_id);
307: arp_util.debug('p_prev_ctl_id : '||p_prev_ctl_id);
308: arp_util.debug('p_credit_freight_amount : '||p_credit_freight_amount);
309: arp_util.debug('p_uncr_freight_amount : '||p_uncr_freight_amount);
310: arp_util.debug('p_freight_type : '||p_freight_type);
311: arp_util.debug('p_freight_ctlid : '||p_freight_ctlid);

Line 308: arp_util.debug('p_credit_freight_amount : '||p_credit_freight_amount);

304: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);
305: arp_util.debug('p_customer_trx_line_id : '||p_customer_trx_line_id);
306: arp_util.debug('p_prev_ct_id : '||p_prev_ct_id);
307: arp_util.debug('p_prev_ctl_id : '||p_prev_ctl_id);
308: arp_util.debug('p_credit_freight_amount : '||p_credit_freight_amount);
309: arp_util.debug('p_uncr_freight_amount : '||p_uncr_freight_amount);
310: arp_util.debug('p_freight_type : '||p_freight_type);
311: arp_util.debug('p_freight_ctlid : '||p_freight_ctlid);
312: arp_util.debug('p_mode : '||p_mode);

Line 309: arp_util.debug('p_uncr_freight_amount : '||p_uncr_freight_amount);

305: arp_util.debug('p_customer_trx_line_id : '||p_customer_trx_line_id);
306: arp_util.debug('p_prev_ct_id : '||p_prev_ct_id);
307: arp_util.debug('p_prev_ctl_id : '||p_prev_ctl_id);
308: arp_util.debug('p_credit_freight_amount : '||p_credit_freight_amount);
309: arp_util.debug('p_uncr_freight_amount : '||p_uncr_freight_amount);
310: arp_util.debug('p_freight_type : '||p_freight_type);
311: arp_util.debug('p_freight_ctlid : '||p_freight_ctlid);
312: arp_util.debug('p_mode : '||p_mode);
313: arp_util.debug('p_gl_date : '||p_gl_date);

Line 310: arp_util.debug('p_freight_type : '||p_freight_type);

306: arp_util.debug('p_prev_ct_id : '||p_prev_ct_id);
307: arp_util.debug('p_prev_ctl_id : '||p_prev_ctl_id);
308: arp_util.debug('p_credit_freight_amount : '||p_credit_freight_amount);
309: arp_util.debug('p_uncr_freight_amount : '||p_uncr_freight_amount);
310: arp_util.debug('p_freight_type : '||p_freight_type);
311: arp_util.debug('p_freight_ctlid : '||p_freight_ctlid);
312: arp_util.debug('p_mode : '||p_mode);
313: arp_util.debug('p_gl_date : '||p_gl_date);
314: arp_util.debug('p_currency_code : '||p_currency_code);

Line 311: arp_util.debug('p_freight_ctlid : '||p_freight_ctlid);

307: arp_util.debug('p_prev_ctl_id : '||p_prev_ctl_id);
308: arp_util.debug('p_credit_freight_amount : '||p_credit_freight_amount);
309: arp_util.debug('p_uncr_freight_amount : '||p_uncr_freight_amount);
310: arp_util.debug('p_freight_type : '||p_freight_type);
311: arp_util.debug('p_freight_ctlid : '||p_freight_ctlid);
312: arp_util.debug('p_mode : '||p_mode);
313: arp_util.debug('p_gl_date : '||p_gl_date);
314: arp_util.debug('p_currency_code : '||p_currency_code);
315:

Line 312: arp_util.debug('p_mode : '||p_mode);

308: arp_util.debug('p_credit_freight_amount : '||p_credit_freight_amount);
309: arp_util.debug('p_uncr_freight_amount : '||p_uncr_freight_amount);
310: arp_util.debug('p_freight_type : '||p_freight_type);
311: arp_util.debug('p_freight_ctlid : '||p_freight_ctlid);
312: arp_util.debug('p_mode : '||p_mode);
313: arp_util.debug('p_gl_date : '||p_gl_date);
314: arp_util.debug('p_currency_code : '||p_currency_code);
315:
316: RAISE;

Line 313: arp_util.debug('p_gl_date : '||p_gl_date);

309: arp_util.debug('p_uncr_freight_amount : '||p_uncr_freight_amount);
310: arp_util.debug('p_freight_type : '||p_freight_type);
311: arp_util.debug('p_freight_ctlid : '||p_freight_ctlid);
312: arp_util.debug('p_mode : '||p_mode);
313: arp_util.debug('p_gl_date : '||p_gl_date);
314: arp_util.debug('p_currency_code : '||p_currency_code);
315:
316: RAISE;
317: END;

Line 314: arp_util.debug('p_currency_code : '||p_currency_code);

310: arp_util.debug('p_freight_type : '||p_freight_type);
311: arp_util.debug('p_freight_ctlid : '||p_freight_ctlid);
312: arp_util.debug('p_mode : '||p_mode);
313: arp_util.debug('p_gl_date : '||p_gl_date);
314: arp_util.debug('p_currency_code : '||p_currency_code);
315:
316: RAISE;
317: END;
318:

Line 328: | arp_util.debug |

324: | |
325: | SCOPE - PRIVATE |
326: | |
327: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
328: | arp_util.debug |
329: | |
330: | ARGUMENTS : IN: |
331: | OUT: |
332: | IN/ OUT: |

Line 352: arp_util.debug('arp_process_credit.default_credit_header()+');

348: IS
349: l_cr_txn_rec ra_customer_trx%rowtype;
350: BEGIN
351:
352: arp_util.debug('arp_process_credit.default_credit_header()+');
353:
354: p_new_cm_rec := p_cm_rec;
355: p_new_cm_rec.previous_customer_trx_id := p_prev_customer_trx_id;
356: p_new_cm_rec.complete_flag := 'N';

Line 401: arp_util.debug('arp_process_credit.default_credit_header()-');

397: WHERE ctt.cust_trx_type_id = p_new_cm_rec.cust_trx_type_id;
398:
399: END IF;
400:
401: arp_util.debug('arp_process_credit.default_credit_header()-');
402:
403: EXCEPTION
404: WHEN OTHERS THEN
405: arp_util.debug('EXCEPTION: arp_process_credit.default_credit_header');

Line 405: arp_util.debug('EXCEPTION: arp_process_credit.default_credit_header');

401: arp_util.debug('arp_process_credit.default_credit_header()-');
402:
403: EXCEPTION
404: WHEN OTHERS THEN
405: arp_util.debug('EXCEPTION: arp_process_credit.default_credit_header');
406: RAISE;
407: END;
408:
409: /*===========================================================================+

Line 418: | arp_util.debug |

414: | |
415: | SCOPE - PRIVATE |
416: | |
417: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
418: | arp_util.debug |
419: | |
420: | ARGUMENTS : IN: |
421: | OUT: |
422: | IN/ OUT: |

Line 435: arp_util.debug('arp_process_credit.validate_insert_header()+');

431: +===========================================================================*/
432: PROCEDURE validate_insert_header
433: IS
434: BEGIN
435: arp_util.debug('arp_process_credit.validate_insert_header()+');
436:
437: arp_util.debug('arp_process_credit.validate_insert_header()-');
438:
439: EXCEPTION

Line 437: arp_util.debug('arp_process_credit.validate_insert_header()-');

433: IS
434: BEGIN
435: arp_util.debug('arp_process_credit.validate_insert_header()+');
436:
437: arp_util.debug('arp_process_credit.validate_insert_header()-');
438:
439: EXCEPTION
440: WHEN OTHERS THEN
441: arp_util.debug('EXCEPTION: arp_process_credit.validate_insert_header');

Line 441: arp_util.debug('EXCEPTION: arp_process_credit.validate_insert_header');

437: arp_util.debug('arp_process_credit.validate_insert_header()-');
438:
439: EXCEPTION
440: WHEN OTHERS THEN
441: arp_util.debug('EXCEPTION: arp_process_credit.validate_insert_header');
442: RAISE;
443:
444: END;
445:

Line 456: | arp_util.debug |

452: | |
453: | SCOPE - PRIVATE |
454: | |
455: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
456: | arp_util.debug |
457: | |
458: | ARGUMENTS : IN: |
459: | OUT: |
460: | IN/ OUT: |

Line 473: arp_util.debug('arp_process_credit.validate_update_header()+');

469: +===========================================================================*/
470: PROCEDURE validate_update_header
471: IS
472: BEGIN
473: arp_util.debug('arp_process_credit.validate_update_header()+');
474:
475: arp_util.debug('arp_process_credit.validate_update_header()-');
476:
477: EXCEPTION

Line 475: arp_util.debug('arp_process_credit.validate_update_header()-');

471: IS
472: BEGIN
473: arp_util.debug('arp_process_credit.validate_update_header()+');
474:
475: arp_util.debug('arp_process_credit.validate_update_header()-');
476:
477: EXCEPTION
478: WHEN OTHERS THEN
479: arp_util.debug('EXCEPTION: arp_process_credit.validate_update_header');

Line 479: arp_util.debug('EXCEPTION: arp_process_credit.validate_update_header');

475: arp_util.debug('arp_process_credit.validate_update_header()-');
476:
477: EXCEPTION
478: WHEN OTHERS THEN
479: arp_util.debug('EXCEPTION: arp_process_credit.validate_update_header');
480: RAISE;
481:
482: END;
483:

Line 493: | arp_util.debug |

489: | |
490: | SCOPE - PRIVATE |
491: | |
492: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
493: | arp_util.debug |
494: | |
495: | ARGUMENTS : IN: |
496: | OUT: |
497: | IN/ OUT: |

Line 514: arp_util.debug('arp_process_credit.validate_insert_line()+');

510: PROCEDURE validate_insert_line(
511: p_line_rec IN ra_customer_trx_lines%rowtype)
512: IS
513: BEGIN
514: arp_util.debug('arp_process_credit.validate_insert_line()+');
515:
516: arp_trx_validate.check_dup_line_number(p_line_rec.line_number,
517: p_line_rec.customer_trx_id,
518: p_line_rec.customer_trx_line_id);

Line 520: arp_util.debug('arp_process_credit.validate_insert_line()-');

516: arp_trx_validate.check_dup_line_number(p_line_rec.line_number,
517: p_line_rec.customer_trx_id,
518: p_line_rec.customer_trx_line_id);
519:
520: arp_util.debug('arp_process_credit.validate_insert_line()-');
521:
522: EXCEPTION
523: WHEN OTHERS THEN
524: arp_util.debug('EXCEPTION: arp_process_credit.validate_insert_line');

Line 524: arp_util.debug('EXCEPTION: arp_process_credit.validate_insert_line');

520: arp_util.debug('arp_process_credit.validate_insert_line()-');
521:
522: EXCEPTION
523: WHEN OTHERS THEN
524: arp_util.debug('EXCEPTION: arp_process_credit.validate_insert_line');
525: RAISE;
526:
527: END;
528:

Line 538: | arp_util.debug |

534: | |
535: | SCOPE - PRIVATE |
536: | |
537: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
538: | arp_util.debug |
539: | |
540: | ARGUMENTS : IN: |
541: | OUT: |
542: | IN/ OUT: |

Line 555: arp_util.debug('arp_process_credit.validate_update_line()+');

551: +===========================================================================*/
552: PROCEDURE validate_update_line
553: IS
554: BEGIN
555: arp_util.debug('arp_process_credit.validate_update_line()+');
556:
557: arp_util.debug('arp_process_credit.validate_update_line()-');
558:
559: EXCEPTION

Line 557: arp_util.debug('arp_process_credit.validate_update_line()-');

553: IS
554: BEGIN
555: arp_util.debug('arp_process_credit.validate_update_line()+');
556:
557: arp_util.debug('arp_process_credit.validate_update_line()-');
558:
559: EXCEPTION
560: WHEN OTHERS THEN
561: arp_util.debug('EXCEPTION: arp_process_credit.validate_update_line');

Line 561: arp_util.debug('EXCEPTION: arp_process_credit.validate_update_line');

557: arp_util.debug('arp_process_credit.validate_update_line()-');
558:
559: EXCEPTION
560: WHEN OTHERS THEN
561: arp_util.debug('EXCEPTION: arp_process_credit.validate_update_line');
562: RAISE;
563:
564: END;
565:

Line 576: | arp_util.debug |

572: | |
573: | SCOPE - PRIVATE |
574: | |
575: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
576: | arp_util.debug |
577: | |
578: | ARGUMENTS : IN: |
579: | OUT: |
580: | IN/ OUT: |

Line 609: arp_util.debug('arp_process_credit.default_credit_line()+');

605: l_trx_rec ra_customer_trx%rowtype;
606: l_calc_unit_price VARCHAR2(1); --2880106
607: BEGIN
608:
609: arp_util.debug('arp_process_credit.default_credit_line()+');
610:
611: p_new_cm_line := p_cm_line;
612: p_new_cm_line.customer_trx_id := p_customer_trx_id;
613: p_new_cm_line.extended_amount := p_line_amount;

Line 766: arp_util.debug('arp_process_credit.default_credit_line()-');

762: p_new_cm_line.ship_to_contact_id := l_cr_txn_line.ship_to_contact_id;
763:
764: END IF;
765:
766: arp_util.debug('arp_process_credit.default_credit_line()-');
767:
768: EXCEPTION
769: WHEN OTHERS THEN
770: arp_util.debug('EXCEPTION: arp_process_credit.default_credit_line');

Line 770: arp_util.debug('EXCEPTION: arp_process_credit.default_credit_line');

766: arp_util.debug('arp_process_credit.default_credit_line()-');
767:
768: EXCEPTION
769: WHEN OTHERS THEN
770: arp_util.debug('EXCEPTION: arp_process_credit.default_credit_line');
771: RAISE;
772:
773: END;
774:

Line 798: arp_util.debug('arp_process_credit.get_cm_amounts()+');

794: l_freight_line_count number;
795:
796: BEGIN
797:
798: arp_util.debug('arp_process_credit.get_cm_amounts()+');
799:
800: IF (p_customer_trx_id IS NOT NULL)
801: THEN
802:

Line 865: arp_util.debug('arp_process_credit.get_cm_amounts()-');

861: END IF;
862:
863: END IF;
864:
865: arp_util.debug('arp_process_credit.get_cm_amounts()-');
866:
867: EXCEPTION
868: WHEN OTHERS THEN
869: arp_util.debug('EXCEPTION: arp_process_credit.get_cm_amounts');

Line 869: arp_util.debug('EXCEPTION: arp_process_credit.get_cm_amounts');

865: arp_util.debug('arp_process_credit.get_cm_amounts()-');
866:
867: EXCEPTION
868: WHEN OTHERS THEN
869: arp_util.debug('EXCEPTION: arp_process_credit.get_cm_amounts');
870:
871: RAISE;
872:
873: END;

Line 885: | arp_util.debug |

881: | |
882: | SCOPE - PRIVATE |
883: | |
884: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
885: | arp_util.debug |
886: | |
887: | ARGUMENTS : IN: |
888: | OUT: |
889: | IN/ OUT: |

Line 925: arp_util.debug('arp_process_credit.get_uncredit_amounts()+');

921: l_freight_ctl_id ra_customer_trx_lines.customer_trx_line_id%type;
922:
923: BEGIN
924:
925: arp_util.debug('arp_process_credit.get_uncredit_amounts()+');
926:
927: SELECT sum(nra.net_amount),
928: count(nra.customer_trx_line_id),
929: max(decode(p_prev_ctl_id,

Line 996: arp_util.debug('arp_process_credit.get_uncredit_amounts()-');

992: p_freight_type := l_freight_type;
993: p_freight_ctl_id := l_freight_ctl_id;
994: END IF;
995:
996: arp_util.debug('arp_process_credit.get_uncredit_amounts()-');
997:
998: EXCEPTION
999: WHEN OTHERS THEN
1000: arp_util.debug('EXCEPTION: arp_process_credit.get_uncredit_amounts');

Line 1000: arp_util.debug('EXCEPTION: arp_process_credit.get_uncredit_amounts');

996: arp_util.debug('arp_process_credit.get_uncredit_amounts()-');
997:
998: EXCEPTION
999: WHEN OTHERS THEN
1000: arp_util.debug('EXCEPTION: arp_process_credit.get_uncredit_amounts');
1001: RAISE;
1002: END;
1003:
1004:

Line 1014: | arp_util.debug |

1010: | |
1011: | SCOPE - PRIVATE |
1012: | |
1013: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1014: | arp_util.debug |
1015: | |
1016: | ARGUMENTS : IN: |
1017: | OUT: |
1018: | IN/ OUT: |

Line 1051: arp_util.debug('arp_process_credit.get_credited_txn_balances()+');

1047: l_tax_balance_due ra_customer_trx_lines.extended_amount%type;
1048: l_freight_balance_due ra_customer_trx_lines.extended_amount%type;
1049: BEGIN
1050:
1051: arp_util.debug('arp_process_credit.get_credited_txn_balances()+');
1052:
1053: SELECT sum(decode(
1054: decode(nra.line_type,
1055: 'CB', 'LINE',

Line 1133: arp_util.debug('arp_process_credit.get_credited_txn_balances()-');

1129: l_freight_balance_due;
1130: END IF;
1131: END IF;
1132:
1133: arp_util.debug('arp_process_credit.get_credited_txn_balances()-');
1134:
1135: EXCEPTION
1136: WHEN OTHERS THEN
1137: arp_util.debug('EXCEPTION : arp_process_credit.get_credited_txn_balances');

Line 1137: arp_util.debug('EXCEPTION : arp_process_credit.get_credited_txn_balances');

1133: arp_util.debug('arp_process_credit.get_credited_txn_balances()-');
1134:
1135: EXCEPTION
1136: WHEN OTHERS THEN
1137: arp_util.debug('EXCEPTION : arp_process_credit.get_credited_txn_balances');
1138: arp_util.debug('');
1139:
1140: RAISE;
1141:

Line 1138: arp_util.debug('');

1134:
1135: EXCEPTION
1136: WHEN OTHERS THEN
1137: arp_util.debug('EXCEPTION : arp_process_credit.get_credited_txn_balances');
1138: arp_util.debug('');
1139:
1140: RAISE;
1141:
1142: END;

Line 1153: | arp_util.debug |

1149: | |
1150: | SCOPE - PRIVATE |
1151: | |
1152: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1153: | arp_util.debug |
1154: | |
1155: | ARGUMENTS : IN: |
1156: | OUT: |
1157: | IN/ OUT: |

Line 1228: arp_util.debug('arp_process_credit.derive_credit_information()+');

1224: l_tax_status varchar2(30) := 'OK';
1225: l_frt_status varchar2(30) := 'OK';
1226: BEGIN
1227:
1228: arp_util.debug('arp_process_credit.derive_credit_information()+');
1229:
1230: IF (nvl(pg_num_credit_lines, 0) > 0)
1231: THEN
1232:

Line 1291: arp_util.debug('derive_credit_information() : get_uncredit_amounts');

1287: END LOOP;
1288:
1289: ELSE
1290:
1291: arp_util.debug('derive_credit_information() : get_uncredit_amounts');
1292:
1293: get_uncredit_amounts(p_customer_trx_id,
1294: null,
1295: p_prev_customer_trx_id,

Line 1305: arp_util.debug('Freight type : '||l_freight_type);

1301: l_memo_line_type,
1302: l_freight_type,
1303: l_freight_ctl_id);
1304:
1305: arp_util.debug('Freight type : '||l_freight_type);
1306: arp_util.debug('Freight ctlid : '||l_freight_ctl_id);
1307:
1308: l_credit_line_amount := p_credit_line_amount;
1309: l_credit_tax_amount := p_credit_tax_amount;

Line 1306: arp_util.debug('Freight ctlid : '||l_freight_ctl_id);

1302: l_freight_type,
1303: l_freight_ctl_id);
1304:
1305: arp_util.debug('Freight type : '||l_freight_type);
1306: arp_util.debug('Freight ctlid : '||l_freight_ctl_id);
1307:
1308: l_credit_line_amount := p_credit_line_amount;
1309: l_credit_tax_amount := p_credit_tax_amount;
1310: l_credit_freight_amount := p_credit_freight_amount;

Line 1363: arp_util.debug('derive_credit_information() : credit_freight');

1359: THEN
1360: /*------------------------------------+
1361: | create credit memo FREIGHT lines |
1362: +------------------------------------*/
1363: arp_util.debug('derive_credit_information() : credit_freight');
1364: credit_freight(
1365: p_form_name,
1366: p_form_version,
1367: p_customer_trx_id,

Line 1391: arp_util.debug('derive_credit_information() : '||

1387: IF (l_credit_line_amount IS NOT NULL AND
1388: p_submit_cm_dist = 'N')
1389: THEN
1390: BEGIN
1391: arp_util.debug('derive_credit_information() : '||
1392: 'credit_transactions');
1393:
1394: arp_credit_memo_module.credit_transactions(
1395: p_customer_trx_id,

Line 1403: arp_util.debug('credit memo module exception : no_ccid');

1399: null,
1400: l_failure_count);
1401: EXCEPTION
1402: WHEN arp_credit_memo_module.no_ccid THEN
1403: arp_util.debug('credit memo module exception : no_ccid');
1404: l_cmm_status := 'ARP_CREDIT_MEMO_MODULE.NO_CCID';
1405: WHEN NO_DATA_FOUND THEN
1406: arp_util.debug('credit memo module exception : no_data_found');
1407: null;

Line 1406: arp_util.debug('credit memo module exception : no_data_found');

1402: WHEN arp_credit_memo_module.no_ccid THEN
1403: arp_util.debug('credit memo module exception : no_ccid');
1404: l_cmm_status := 'ARP_CREDIT_MEMO_MODULE.NO_CCID';
1405: WHEN NO_DATA_FOUND THEN
1406: arp_util.debug('credit memo module exception : no_data_found');
1407: null;
1408: WHEN app_exception.application_exception THEN
1409: arp_util.debug('credit memo module exception : app_exception ');
1410: RAISE;

Line 1409: arp_util.debug('credit memo module exception : app_exception ');

1405: WHEN NO_DATA_FOUND THEN
1406: arp_util.debug('credit memo module exception : no_data_found');
1407: null;
1408: WHEN app_exception.application_exception THEN
1409: arp_util.debug('credit memo module exception : app_exception ');
1410: RAISE;
1411: WHEN OTHERS THEN
1412: RAISE;
1413: END;

Line 1423: arp_util.debug('l_all_line_status : '||l_all_line_status);

1419: PREVIOUS_CUSTOMER_TRX_ID = ":INVOICE.CUSTOMER_TRX_ID" */
1420:
1421: END IF;
1422:
1423: arp_util.debug('l_all_line_status : '||l_all_line_status);
1424: arp_util.debug('l_tax_status : '||l_tax_status);
1425: arp_util.debug('l_frt_status : '||l_frt_status);
1426: arp_util.debug('l_cmm_status : '||l_cmm_status);
1427:

Line 1424: arp_util.debug('l_tax_status : '||l_tax_status);

1420:
1421: END IF;
1422:
1423: arp_util.debug('l_all_line_status : '||l_all_line_status);
1424: arp_util.debug('l_tax_status : '||l_tax_status);
1425: arp_util.debug('l_frt_status : '||l_frt_status);
1426: arp_util.debug('l_cmm_status : '||l_cmm_status);
1427:
1428: IF (NVL(l_all_line_status, 'OK') <> 'OK') THEN

Line 1425: arp_util.debug('l_frt_status : '||l_frt_status);

1421: END IF;
1422:
1423: arp_util.debug('l_all_line_status : '||l_all_line_status);
1424: arp_util.debug('l_tax_status : '||l_tax_status);
1425: arp_util.debug('l_frt_status : '||l_frt_status);
1426: arp_util.debug('l_cmm_status : '||l_cmm_status);
1427:
1428: IF (NVL(l_all_line_status, 'OK') <> 'OK') THEN
1429: p_status := l_all_line_status;

Line 1426: arp_util.debug('l_cmm_status : '||l_cmm_status);

1422:
1423: arp_util.debug('l_all_line_status : '||l_all_line_status);
1424: arp_util.debug('l_tax_status : '||l_tax_status);
1425: arp_util.debug('l_frt_status : '||l_frt_status);
1426: arp_util.debug('l_cmm_status : '||l_cmm_status);
1427:
1428: IF (NVL(l_all_line_status, 'OK') <> 'OK') THEN
1429: p_status := l_all_line_status;
1430: ELSIF (NVL(l_tax_status, 'OK') <> 'OK') THEN

Line 1438: arp_util.debug('arp_process_credit.derive_credit_information()-');

1434: ELSIF (NVL(l_cmm_status, 'OK') <> 'OK') THEN
1435: p_status := l_cmm_status;
1436: END IF;
1437:
1438: arp_util.debug('arp_process_credit.derive_credit_information()-');
1439:
1440: EXCEPTION
1441: WHEN OTHERS THEN
1442: arp_util.debug('EXCEPTION: derive_credit_information');

Line 1442: arp_util.debug('EXCEPTION: derive_credit_information');

1438: arp_util.debug('arp_process_credit.derive_credit_information()-');
1439:
1440: EXCEPTION
1441: WHEN OTHERS THEN
1442: arp_util.debug('EXCEPTION: derive_credit_information');
1443: RAISE;
1444: END;
1445:
1446:

Line 1457: | arp_util.debug |

1453: | |
1454: | SCOPE - PRIVATE |
1455: | |
1456: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1457: | arp_util.debug |
1458: | |
1459: | ARGUMENTS : IN: |
1460: | p_form_name |
1461: | p_form_version |

Line 1526: arp_util.debug('arp_process_credit.insert_header()+');

1522: l_ev_rec arp_xla_events.xla_events_type;
1523:
1524: BEGIN
1525:
1526: arp_util.debug('arp_process_credit.insert_header()+');
1527:
1528: /*--------------------------------------------------------------+
1529: | check form version to determine IF it is compatible with the |
1530: | entity handler. |

Line 1636: arp_util.debug('l_rec_aa_status : '||l_rec_aa_status);

1632: l_derive_status,
1633: p_submit_cm_dist);
1634: END IF;
1635:
1636: arp_util.debug('l_rec_aa_status : '||l_rec_aa_status);
1637: arp_util.debug('l_derive_status : '||l_derive_status);
1638:
1639: IF (NVL(l_rec_aa_status, 'OK') <> 'OK') THEN
1640: p_status := l_rec_aa_status;

Line 1637: arp_util.debug('l_derive_status : '||l_derive_status);

1633: p_submit_cm_dist);
1634: END IF;
1635:
1636: arp_util.debug('l_rec_aa_status : '||l_rec_aa_status);
1637: arp_util.debug('l_derive_status : '||l_derive_status);
1638:
1639: IF (NVL(l_rec_aa_status, 'OK') <> 'OK') THEN
1640: p_status := l_rec_aa_status;
1641: ELSIF (NVL(l_derive_status, 'OK') <> 'OK') THEN

Line 1649: arp_util.debug('arp_process_credit.insert_header()-');

1645: IF l_df_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1646: p_status := 'eTAX_ERROR';
1647: END IF;
1648:
1649: arp_util.debug('arp_process_credit.insert_header()-');
1650:
1651: EXCEPTION
1652: WHEN OTHERS THEN
1653: arp_util.debug('EXCEPTION: arp_process_credit.insert_header');

Line 1653: arp_util.debug('EXCEPTION: arp_process_credit.insert_header');

1649: arp_util.debug('arp_process_credit.insert_header()-');
1650:
1651: EXCEPTION
1652: WHEN OTHERS THEN
1653: arp_util.debug('EXCEPTION: arp_process_credit.insert_header');
1654: RAISE;
1655: END;
1656:
1657: /*===========================================================================+

Line 1667: | arp_util.debug |

1663: | |
1664: | SCOPE - PRIVATE |
1665: | |
1666: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1667: | arp_util.debug |
1668: | |
1669: | ARGUMENTS : IN: |
1670: | p_customer_trx_id |
1671: | p_trx_number_change_flag |

Line 1692: arp_util.debug('arp_process_credit.delete_cm_records()+');

1688: p_trx_number_change_flag IN boolean)
1689: IS
1690: BEGIN
1691:
1692: arp_util.debug('arp_process_credit.delete_cm_records()+');
1693:
1694: /*-----------------------+
1695: | delete sales credits |
1696: +-----------------------*/

Line 1725: arp_util.debug('arp_process_credit.delete_cm_records()-');

1721: | delete line records |
1722: +---------------------*/
1723: arp_ctl_pkg.delete_f_ct_id(p_customer_trx_id);
1724:
1725: arp_util.debug('arp_process_credit.delete_cm_records()-');
1726:
1727: EXCEPTION
1728:
1729: WHEN OTHERS THEN

Line 1730: arp_util.debug('EXCEPTION: arp_process_credit.delete_cm_records');

1726:
1727: EXCEPTION
1728:
1729: WHEN OTHERS THEN
1730: arp_util.debug('EXCEPTION: arp_process_credit.delete_cm_records');
1731: arp_util.debug('');
1732: arp_util.debug('p_customer_trx_id = '||p_customer_trx_id);
1733:
1734: RAISE;

Line 1731: arp_util.debug('');

1727: EXCEPTION
1728:
1729: WHEN OTHERS THEN
1730: arp_util.debug('EXCEPTION: arp_process_credit.delete_cm_records');
1731: arp_util.debug('');
1732: arp_util.debug('p_customer_trx_id = '||p_customer_trx_id);
1733:
1734: RAISE;
1735: END;

Line 1732: arp_util.debug('p_customer_trx_id = '||p_customer_trx_id);

1728:
1729: WHEN OTHERS THEN
1730: arp_util.debug('EXCEPTION: arp_process_credit.delete_cm_records');
1731: arp_util.debug('');
1732: arp_util.debug('p_customer_trx_id = '||p_customer_trx_id);
1733:
1734: RAISE;
1735: END;
1736:

Line 1754: arp_util.debug('arp_process_credit.line_rerun_aa()+');

1750:
1751: l_rec_aa_status varchar2(30) := 'OK';
1752: l_other_aa_status varchar2(30) := 'OK';
1753: BEGIN
1754: arp_util.debug('arp_process_credit.line_rerun_aa()+');
1755:
1756: IF p_customer_trx_line_id IS NULL
1757: THEN
1758: BEGIN

Line 1818: arp_util.debug('l_rec_aa_status : '||l_rec_aa_status);

1814: WHEN OTHERS THEN
1815: RAISE;
1816: END;
1817:
1818: arp_util.debug('l_rec_aa_status : '||l_rec_aa_status);
1819: arp_util.debug('l_other_aa_status : '||l_other_aa_status);
1820:
1821: IF (NVL(l_rec_aa_status, 'OK') <> 'OK') THEN
1822: p_status := l_rec_aa_status;

Line 1819: arp_util.debug('l_other_aa_status : '||l_other_aa_status);

1815: RAISE;
1816: END;
1817:
1818: arp_util.debug('l_rec_aa_status : '||l_rec_aa_status);
1819: arp_util.debug('l_other_aa_status : '||l_other_aa_status);
1820:
1821: IF (NVL(l_rec_aa_status, 'OK') <> 'OK') THEN
1822: p_status := l_rec_aa_status;
1823: ELSIF (NVL(l_other_aa_status, 'OK') <> 'OK') THEN

Line 1827: arp_util.debug('arp_process_credit.line_rerun_aa()-');

1823: ELSIF (NVL(l_other_aa_status, 'OK') <> 'OK') THEN
1824: p_status := l_other_aa_status;
1825: END IF;
1826:
1827: arp_util.debug('arp_process_credit.line_rerun_aa()-');
1828:
1829: EXCEPTION
1830: WHEN OTHERS THEN
1831: arp_util.debug('EXCEPTION: arp_process_credit.line_rerun_aa');

Line 1831: arp_util.debug('EXCEPTION: arp_process_credit.line_rerun_aa');

1827: arp_util.debug('arp_process_credit.line_rerun_aa()-');
1828:
1829: EXCEPTION
1830: WHEN OTHERS THEN
1831: arp_util.debug('EXCEPTION: arp_process_credit.line_rerun_aa');
1832: RAISE;
1833: END;
1834:
1835: /* Bug 3619804 */

Line 1847: | arp_util.debug |

1843: | |
1844: | SCOPE - PRIVATE |
1845: | |
1846: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1847: | arp_util.debug |
1848: | ARGUMENTS : |
1849: | IN : p_customer_trx_id |
1850: | OUT: |
1851: | IN/ OUT: |

Line 1870: arp_util.debug('arp_process_credit.reverse_revrec_effect_cm()+');

1866: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
1867:
1868: BEGIN
1869:
1870: arp_util.debug('arp_process_credit.reverse_revrec_effect_cm()+');
1871:
1872: arp_ctl_pkg.set_to_dummy( l_line_rec );
1873: l_line_rec.autorule_complete_flag := 'N';
1874: l_line_rec.autorule_duration_processed := NULL;

Line 1882: arp_util.debug('arp_process_credit..reverse_revrec_effect_cm: '||

1878: p_customer_trx_id,
1879: 'LINE');
1880: EXCEPTION
1881: WHEN NO_DATA_FOUND THEN
1882: arp_util.debug('arp_process_credit..reverse_revrec_effect_cm: '||
1883: 'no child lines to update.');
1884: WHEN OTHERS THEN
1885: arp_util.debug('EXCEPTION: '||
1886: 'arp_process_credit.reverse_revrec_effect_cm()');

Line 1885: arp_util.debug('EXCEPTION: '||

1881: WHEN NO_DATA_FOUND THEN
1882: arp_util.debug('arp_process_credit..reverse_revrec_effect_cm: '||
1883: 'no child lines to update.');
1884: WHEN OTHERS THEN
1885: arp_util.debug('EXCEPTION: '||
1886: 'arp_process_credit.reverse_revrec_effect_cm()');
1887: RAISE;
1888: END;
1889:

Line 1901: arp_util.debug('arp_process_credit.reverse_revrec_effect_cm: '||

1897: 'N',
1898: NULL);
1899: EXCEPTION
1900: WHEN NO_DATA_FOUND THEN
1901: arp_util.debug('arp_process_credit.reverse_revrec_effect_cm: '||
1902: 'no dists to delete.');
1903: WHEN OTHERS THEN
1904: arp_util.debug('EXCEPTION: '||
1905: 'arp_process_credit.reverse_revrec_effect_cm()');

Line 1904: arp_util.debug('EXCEPTION: '||

1900: WHEN NO_DATA_FOUND THEN
1901: arp_util.debug('arp_process_credit.reverse_revrec_effect_cm: '||
1902: 'no dists to delete.');
1903: WHEN OTHERS THEN
1904: arp_util.debug('EXCEPTION: '||
1905: 'arp_process_credit.reverse_revrec_effect_cm()');
1906: RAISE;
1907: END;
1908:

Line 1918: arp_util.debug('arp_process_credit.reverse_revrec_effect_cm: '||

1914: 'Y',
1915: 'REC');
1916: EXCEPTION
1917: WHEN NO_DATA_FOUND THEN
1918: arp_util.debug('arp_process_credit.reverse_revrec_effect_cm: '||
1919: 'no dists to update.');
1920: WHEN OTHERS THEN
1921: arp_util.debug('EXCEPTION: '||
1922: 'arp_process_credit.reverse_revrec_effect_cm()');

Line 1921: arp_util.debug('EXCEPTION: '||

1917: WHEN NO_DATA_FOUND THEN
1918: arp_util.debug('arp_process_credit.reverse_revrec_effect_cm: '||
1919: 'no dists to update.');
1920: WHEN OTHERS THEN
1921: arp_util.debug('EXCEPTION: '||
1922: 'arp_process_credit.reverse_revrec_effect_cm()');
1923: RAISE;
1924: END;
1925: EXCEPTION

Line 1927: arp_util.debug('EXCEPTION: '||

1923: RAISE;
1924: END;
1925: EXCEPTION
1926: WHEN OTHERS THEN
1927: arp_util.debug('EXCEPTION: '||
1928: 'arp_process_credit.reverse_revrec_effect_cm()');
1929: RAISE;
1930: END ;
1931:

Line 1945: | arp_util.debug |

1941: | |
1942: | SCOPE - PRIVATE |
1943: | |
1944: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1945: | arp_util.debug |
1946: | |
1947: | ARGUMENTS : IN: |
1948: | p_customer_trx_id |
1949: | p_new_trx_rec |

Line 1975: arp_util.debug('arp_process_credit.set_header_flags()+');

1971: IS
1972: l_old_trx_rec ra_customer_trx%rowtype;
1973: l_old_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
1974: BEGIN
1975: arp_util.debug('arp_process_credit.set_header_flags()+');
1976:
1977: arp_ct_pkg.fetch_p(l_old_trx_rec, p_customer_trx_id);
1978:
1979: p_old_trx_rec := l_old_trx_rec;

Line 2014: arp_util.debug('arp_process_credit.set_header_flags()-');

2010: ELSE
2011: p_complete_changed_flag := FALSE;
2012: END IF;
2013:
2014: arp_util.debug('arp_process_credit.set_header_flags()-');
2015:
2016: EXCEPTION
2017: WHEN OTHERS THEN
2018: arp_util.debug('EXCEPTION: arp_process_credit.set_header_flags');

Line 2018: arp_util.debug('EXCEPTION: arp_process_credit.set_header_flags');

2014: arp_util.debug('arp_process_credit.set_header_flags()-');
2015:
2016: EXCEPTION
2017: WHEN OTHERS THEN
2018: arp_util.debug('EXCEPTION: arp_process_credit.set_header_flags');
2019: arp_util.debug('');
2020: RAISE;
2021: END;
2022:

Line 2019: arp_util.debug('');

2015:
2016: EXCEPTION
2017: WHEN OTHERS THEN
2018: arp_util.debug('EXCEPTION: arp_process_credit.set_header_flags');
2019: arp_util.debug('');
2020: RAISE;
2021: END;
2022:
2023: /*===========================================================================+

Line 2033: | arp_util.debug |

2029: | |
2030: | SCOPE - PRIVATE |
2031: | |
2032: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2033: | arp_util.debug |
2034: | |
2035: | ARGUMENTS : IN: |
2036: | p_form_name |
2037: | p_form_version |

Line 2142: arp_util.debug('arp_process_credit.update_header()+');

2138: trx.customer_trx_id,
2139: trx.org_id;
2140:
2141: BEGIN
2142: arp_util.debug('arp_process_credit.update_header()+');
2143:
2144: /*--------------------------------------------------------------+
2145: | check form version to determine IF it is compatible with the |
2146: | entity handler. |

Line 2165: arp_util.debug( 'p_compute_tax : ' || p_compute_tax);

2161: | If Yes, this is identified as Tax Event for Vendors and Vendor data |
2162: | is synchronized with the new transaction number. |
2163: | This is not a Tax Event for GTE. |
2164: +----------------------------------------------------------------------*/
2165: arp_util.debug( 'p_compute_tax : ' || p_compute_tax);
2166: arp_util.debug( 'p_rederive_credit_info : ' || p_rederive_credit_info);
2167: arp_util.debug( 'p_trx_rec.trx_number : ' || p_trx_rec.trx_number);
2168: arp_util.debug( 'p_trx_rec.old_trx_number : ' || p_trx_rec.old_trx_number);
2169: l_trx_number_change_flag := FALSE;

Line 2166: arp_util.debug( 'p_rederive_credit_info : ' || p_rederive_credit_info);

2162: | is synchronized with the new transaction number. |
2163: | This is not a Tax Event for GTE. |
2164: +----------------------------------------------------------------------*/
2165: arp_util.debug( 'p_compute_tax : ' || p_compute_tax);
2166: arp_util.debug( 'p_rederive_credit_info : ' || p_rederive_credit_info);
2167: arp_util.debug( 'p_trx_rec.trx_number : ' || p_trx_rec.trx_number);
2168: arp_util.debug( 'p_trx_rec.old_trx_number : ' || p_trx_rec.old_trx_number);
2169: l_trx_number_change_flag := FALSE;
2170:

Line 2167: arp_util.debug( 'p_trx_rec.trx_number : ' || p_trx_rec.trx_number);

2163: | This is not a Tax Event for GTE. |
2164: +----------------------------------------------------------------------*/
2165: arp_util.debug( 'p_compute_tax : ' || p_compute_tax);
2166: arp_util.debug( 'p_rederive_credit_info : ' || p_rederive_credit_info);
2167: arp_util.debug( 'p_trx_rec.trx_number : ' || p_trx_rec.trx_number);
2168: arp_util.debug( 'p_trx_rec.old_trx_number : ' || p_trx_rec.old_trx_number);
2169: l_trx_number_change_flag := FALSE;
2170:
2171:

Line 2168: arp_util.debug( 'p_trx_rec.old_trx_number : ' || p_trx_rec.old_trx_number);

2164: +----------------------------------------------------------------------*/
2165: arp_util.debug( 'p_compute_tax : ' || p_compute_tax);
2166: arp_util.debug( 'p_rederive_credit_info : ' || p_rederive_credit_info);
2167: arp_util.debug( 'p_trx_rec.trx_number : ' || p_trx_rec.trx_number);
2168: arp_util.debug( 'p_trx_rec.old_trx_number : ' || p_trx_rec.old_trx_number);
2169: l_trx_number_change_flag := FALSE;
2170:
2171:
2172: IF ( p_trx_rec.old_trx_number is not null )

Line 2181: arp_util.debug( 'orig_trx_number : ' || orig_trx_number);

2177: INTO orig_trx_number
2178: FROM ra_customer_trx
2179: WHERE customer_trx_id = p_customer_trx_id;
2180:
2181: arp_util.debug( 'orig_trx_number : ' || orig_trx_number);
2182:
2183: IF p_trx_rec.trx_number <> orig_trx_number
2184: THEN
2185: l_trx_number_change_flag := TRUE;

Line 2199: arp_util.debug('l_trx_number_change_flag : '||arp_trx_util.boolean_to_varchar2(l_trx_number_change_flag));

2195:
2196: END IF;
2197:
2198: --Bug2109490
2199: arp_util.debug('l_trx_number_change_flag : '||arp_trx_util.boolean_to_varchar2(l_trx_number_change_flag));
2200: --
2201: -- call Tax engine, checking if tax needs to be recalculated
2202: --
2203: l_action := arp_etax_services_pkg.Get_tax_Action(p_customer_trx_id);

Line 2284: arp_util.debug('EXCEPTION: error calling eBusiness Tax, status = ' ||

2280: arp_etax_util.synchronize_for_doc_seq(p_customer_trx_id,l_ret_status);
2281:
2282: IF l_ret_status > 0
2283: THEN
2284: arp_util.debug('EXCEPTION: error calling eBusiness Tax, status = ' ||
2285: l_ret_status);
2286: arp_util.debug('Please review the plsql debug log for additional details.');
2287: p_status := 'SYNCH_DOC_SEQ_ERROR';
2288: END IF;

Line 2286: arp_util.debug('Please review the plsql debug log for additional details.');

2282: IF l_ret_status > 0
2283: THEN
2284: arp_util.debug('EXCEPTION: error calling eBusiness Tax, status = ' ||
2285: l_ret_status);
2286: arp_util.debug('Please review the plsql debug log for additional details.');
2287: p_status := 'SYNCH_DOC_SEQ_ERROR';
2288: END IF;
2289: END IF;
2290:

Line 2352: arp_util.debug( 'p_prev_customer_trx_id : ' || to_char( p_prev_customer_trx_id ));

2348: null);
2349: END IF;
2350:
2351: --Bug2109490
2352: arp_util.debug( 'p_prev_customer_trx_id : ' || to_char( p_prev_customer_trx_id ));
2353: arp_util.debug( 'p_rederive_credit_info : ' || p_rederive_credit_info);
2354: arp_util.debug(' l_recalc_tax_flag : '||arp_trx_util.boolean_to_varchar2(l_recalc_tax_flag));
2355: arp_util.debug( 'p_compute_tax : ' || p_compute_tax);
2356: arp_util.debug('l_trx_number_change_flag : '||arp_trx_util.boolean_to_varchar2(l_trx_number_change_flag));

Line 2353: arp_util.debug( 'p_rederive_credit_info : ' || p_rederive_credit_info);

2349: END IF;
2350:
2351: --Bug2109490
2352: arp_util.debug( 'p_prev_customer_trx_id : ' || to_char( p_prev_customer_trx_id ));
2353: arp_util.debug( 'p_rederive_credit_info : ' || p_rederive_credit_info);
2354: arp_util.debug(' l_recalc_tax_flag : '||arp_trx_util.boolean_to_varchar2(l_recalc_tax_flag));
2355: arp_util.debug( 'p_compute_tax : ' || p_compute_tax);
2356: arp_util.debug('l_trx_number_change_flag : '||arp_trx_util.boolean_to_varchar2(l_trx_number_change_flag));
2357:

Line 2354: arp_util.debug(' l_recalc_tax_flag : '||arp_trx_util.boolean_to_varchar2(l_recalc_tax_flag));

2350:
2351: --Bug2109490
2352: arp_util.debug( 'p_prev_customer_trx_id : ' || to_char( p_prev_customer_trx_id ));
2353: arp_util.debug( 'p_rederive_credit_info : ' || p_rederive_credit_info);
2354: arp_util.debug(' l_recalc_tax_flag : '||arp_trx_util.boolean_to_varchar2(l_recalc_tax_flag));
2355: arp_util.debug( 'p_compute_tax : ' || p_compute_tax);
2356: arp_util.debug('l_trx_number_change_flag : '||arp_trx_util.boolean_to_varchar2(l_trx_number_change_flag));
2357:
2358: IF (( p_prev_customer_trx_id IS NOT NULL)

Line 2355: arp_util.debug( 'p_compute_tax : ' || p_compute_tax);

2351: --Bug2109490
2352: arp_util.debug( 'p_prev_customer_trx_id : ' || to_char( p_prev_customer_trx_id ));
2353: arp_util.debug( 'p_rederive_credit_info : ' || p_rederive_credit_info);
2354: arp_util.debug(' l_recalc_tax_flag : '||arp_trx_util.boolean_to_varchar2(l_recalc_tax_flag));
2355: arp_util.debug( 'p_compute_tax : ' || p_compute_tax);
2356: arp_util.debug('l_trx_number_change_flag : '||arp_trx_util.boolean_to_varchar2(l_trx_number_change_flag));
2357:
2358: IF (( p_prev_customer_trx_id IS NOT NULL)
2359: AND

Line 2356: arp_util.debug('l_trx_number_change_flag : '||arp_trx_util.boolean_to_varchar2(l_trx_number_change_flag));

2352: arp_util.debug( 'p_prev_customer_trx_id : ' || to_char( p_prev_customer_trx_id ));
2353: arp_util.debug( 'p_rederive_credit_info : ' || p_rederive_credit_info);
2354: arp_util.debug(' l_recalc_tax_flag : '||arp_trx_util.boolean_to_varchar2(l_recalc_tax_flag));
2355: arp_util.debug( 'p_compute_tax : ' || p_compute_tax);
2356: arp_util.debug('l_trx_number_change_flag : '||arp_trx_util.boolean_to_varchar2(l_trx_number_change_flag));
2357:
2358: IF (( p_prev_customer_trx_id IS NOT NULL)
2359: AND
2360: nvl(p_rederive_credit_info, 'N') = 'Y' )

Line 2367: arp_util.debug( 'p_prev_customer_trx_id : ' || to_char( p_prev_customer_trx_id ));

2363: -- if rederive credit memo info is set, then delete all records
2364: -- and rederive info if any of the amounts are not null
2365: --
2366:
2367: arp_util.debug( 'p_prev_customer_trx_id : ' || to_char( p_prev_customer_trx_id ));
2368: arp_util.debug( 'p_customer_trx_id : ' || to_char( p_customer_trx_id ));
2369: delete_cm_records(p_customer_trx_id, l_trx_number_change_flag);
2370:
2371: IF ( p_compute_tax = 'Y' )

Line 2368: arp_util.debug( 'p_customer_trx_id : ' || to_char( p_customer_trx_id ));

2364: -- and rederive info if any of the amounts are not null
2365: --
2366:
2367: arp_util.debug( 'p_prev_customer_trx_id : ' || to_char( p_prev_customer_trx_id ));
2368: arp_util.debug( 'p_customer_trx_id : ' || to_char( p_customer_trx_id ));
2369: delete_cm_records(p_customer_trx_id, l_trx_number_change_flag);
2370:
2371: IF ( p_compute_tax = 'Y' )
2372: THEN

Line 2442: arp_util.debug('arp_process_credit.update_header: '||

2438: null);
2439: END IF;
2440: EXCEPTION
2441: WHEN NO_DATA_FOUND THEN
2442: arp_util.debug('arp_process_credit.update_header: '||
2443: 'no distributions to update');
2444: WHEN OTHERS THEN
2445: arp_util.debug('EXCEPTION : arp_process_credit.update_header');
2446: arp_util.debug(' update gl_date');

Line 2445: arp_util.debug('EXCEPTION : arp_process_credit.update_header');

2441: WHEN NO_DATA_FOUND THEN
2442: arp_util.debug('arp_process_credit.update_header: '||
2443: 'no distributions to update');
2444: WHEN OTHERS THEN
2445: arp_util.debug('EXCEPTION : arp_process_credit.update_header');
2446: arp_util.debug(' update gl_date');
2447: RAISE;
2448: END;
2449: END IF;

Line 2446: arp_util.debug(' update gl_date');

2442: arp_util.debug('arp_process_credit.update_header: '||
2443: 'no distributions to update');
2444: WHEN OTHERS THEN
2445: arp_util.debug('EXCEPTION : arp_process_credit.update_header');
2446: arp_util.debug(' update gl_date');
2447: RAISE;
2448: END;
2449: END IF;
2450:

Line 2456: arp_util.debug('update_header() : credit_transactions');

2452: AND
2453: nvl(p_rederive_credit_info, 'N') = 'N')
2454: THEN
2455: BEGIN
2456: arp_util.debug('update_header() : credit_transactions');
2457:
2458: arp_credit_memo_module.credit_transactions(
2459: p_customer_trx_id,
2460: null,

Line 2468: arp_util.debug('credit memo module exception : no_ccid');

2464: l_failure_count,
2465: 'U');
2466: EXCEPTION
2467: WHEN arp_credit_memo_module.no_ccid THEN
2468: arp_util.debug('credit memo module exception : no_ccid');
2469: l_cmm_status := 'ARP_CREDIT_MEMO_MODULE.NO_CCID';
2470: WHEN NO_DATA_FOUND THEN
2471: arp_util.debug('credit memo module exception : no_data_found');
2472: null;

Line 2471: arp_util.debug('credit memo module exception : no_data_found');

2467: WHEN arp_credit_memo_module.no_ccid THEN
2468: arp_util.debug('credit memo module exception : no_ccid');
2469: l_cmm_status := 'ARP_CREDIT_MEMO_MODULE.NO_CCID';
2470: WHEN NO_DATA_FOUND THEN
2471: arp_util.debug('credit memo module exception : no_data_found');
2472: null;
2473: WHEN app_exception.application_exception THEN
2474: arp_util.debug('credit memo module exception : app_exception ');
2475: RAISE;

Line 2474: arp_util.debug('credit memo module exception : app_exception ');

2470: WHEN NO_DATA_FOUND THEN
2471: arp_util.debug('credit memo module exception : no_data_found');
2472: null;
2473: WHEN app_exception.application_exception THEN
2474: arp_util.debug('credit memo module exception : app_exception ');
2475: RAISE;
2476: WHEN OTHERS THEN
2477: RAISE;
2478: END;

Line 2482: arp_util.debug('Complete_changed_flag : '||arp_trx_util.boolean_to_varchar2(l_complete_changed_flag));

2478: END;
2479:
2480: END IF;
2481: /* Bug 3619804 Added the call to the procedure reverse_revrec_effect_cm */
2482: arp_util.debug('Complete_changed_flag : '||arp_trx_util.boolean_to_varchar2(l_complete_changed_flag));
2483: arp_util.debug('Complete Flag : '|| p_trx_rec.complete_flag);
2484: arp_util.debug('Customer_trx_id : '|| p_customer_trx_id );
2485: arp_util.debug('CM invoicing_rule_id : '|| p_cr_txn_invoicing_rule_id );
2486: arp_util.debug('CM Rev Recog Run Flag : ' ||arpt_sql_func_util.get_revenue_recog_run_flag(p_customer_trx_id,p_cr_txn_invoicing_rule_id));

Line 2483: arp_util.debug('Complete Flag : '|| p_trx_rec.complete_flag);

2479:
2480: END IF;
2481: /* Bug 3619804 Added the call to the procedure reverse_revrec_effect_cm */
2482: arp_util.debug('Complete_changed_flag : '||arp_trx_util.boolean_to_varchar2(l_complete_changed_flag));
2483: arp_util.debug('Complete Flag : '|| p_trx_rec.complete_flag);
2484: arp_util.debug('Customer_trx_id : '|| p_customer_trx_id );
2485: arp_util.debug('CM invoicing_rule_id : '|| p_cr_txn_invoicing_rule_id );
2486: arp_util.debug('CM Rev Recog Run Flag : ' ||arpt_sql_func_util.get_revenue_recog_run_flag(p_customer_trx_id,p_cr_txn_invoicing_rule_id));
2487:

Line 2484: arp_util.debug('Customer_trx_id : '|| p_customer_trx_id );

2480: END IF;
2481: /* Bug 3619804 Added the call to the procedure reverse_revrec_effect_cm */
2482: arp_util.debug('Complete_changed_flag : '||arp_trx_util.boolean_to_varchar2(l_complete_changed_flag));
2483: arp_util.debug('Complete Flag : '|| p_trx_rec.complete_flag);
2484: arp_util.debug('Customer_trx_id : '|| p_customer_trx_id );
2485: arp_util.debug('CM invoicing_rule_id : '|| p_cr_txn_invoicing_rule_id );
2486: arp_util.debug('CM Rev Recog Run Flag : ' ||arpt_sql_func_util.get_revenue_recog_run_flag(p_customer_trx_id,p_cr_txn_invoicing_rule_id));
2487:
2488: IF l_complete_changed_flag AND p_trx_rec.complete_flag = 'N'

Line 2485: arp_util.debug('CM invoicing_rule_id : '|| p_cr_txn_invoicing_rule_id );

2481: /* Bug 3619804 Added the call to the procedure reverse_revrec_effect_cm */
2482: arp_util.debug('Complete_changed_flag : '||arp_trx_util.boolean_to_varchar2(l_complete_changed_flag));
2483: arp_util.debug('Complete Flag : '|| p_trx_rec.complete_flag);
2484: arp_util.debug('Customer_trx_id : '|| p_customer_trx_id );
2485: arp_util.debug('CM invoicing_rule_id : '|| p_cr_txn_invoicing_rule_id );
2486: arp_util.debug('CM Rev Recog Run Flag : ' ||arpt_sql_func_util.get_revenue_recog_run_flag(p_customer_trx_id,p_cr_txn_invoicing_rule_id));
2487:
2488: IF l_complete_changed_flag AND p_trx_rec.complete_flag = 'N'
2489: THEN

Line 2486: arp_util.debug('CM Rev Recog Run Flag : ' ||arpt_sql_func_util.get_revenue_recog_run_flag(p_customer_trx_id,p_cr_txn_invoicing_rule_id));

2482: arp_util.debug('Complete_changed_flag : '||arp_trx_util.boolean_to_varchar2(l_complete_changed_flag));
2483: arp_util.debug('Complete Flag : '|| p_trx_rec.complete_flag);
2484: arp_util.debug('Customer_trx_id : '|| p_customer_trx_id );
2485: arp_util.debug('CM invoicing_rule_id : '|| p_cr_txn_invoicing_rule_id );
2486: arp_util.debug('CM Rev Recog Run Flag : ' ||arpt_sql_func_util.get_revenue_recog_run_flag(p_customer_trx_id,p_cr_txn_invoicing_rule_id));
2487:
2488: IF l_complete_changed_flag AND p_trx_rec.complete_flag = 'N'
2489: THEN
2490: IF p_cr_txn_invoicing_rule_id IS NOT NULL

Line 2501: arp_util.debug('l_tax_status : '|| l_tax_status);

2497: END IF;
2498: END IF; /* IF l_complete_flag_changed */
2499:
2500:
2501: arp_util.debug('l_tax_status : '|| l_tax_status);
2502: arp_util.debug('l_derive_status : '|| l_derive_status);
2503: arp_util.debug('l_cmm_status : '|| l_cmm_status);
2504:
2505: IF (NVL(l_tax_status, 'OK') <> 'OK') THEN

Line 2502: arp_util.debug('l_derive_status : '|| l_derive_status);

2498: END IF; /* IF l_complete_flag_changed */
2499:
2500:
2501: arp_util.debug('l_tax_status : '|| l_tax_status);
2502: arp_util.debug('l_derive_status : '|| l_derive_status);
2503: arp_util.debug('l_cmm_status : '|| l_cmm_status);
2504:
2505: IF (NVL(l_tax_status, 'OK') <> 'OK') THEN
2506: p_status := l_tax_status;

Line 2503: arp_util.debug('l_cmm_status : '|| l_cmm_status);

2499:
2500:
2501: arp_util.debug('l_tax_status : '|| l_tax_status);
2502: arp_util.debug('l_derive_status : '|| l_derive_status);
2503: arp_util.debug('l_cmm_status : '|| l_cmm_status);
2504:
2505: IF (NVL(l_tax_status, 'OK') <> 'OK') THEN
2506: p_status := l_tax_status;
2507: ELSIF (NVL(l_derive_status, 'OK') <> 'OK' ) THEN

Line 2553: arp_util.debug('arp_process_credit.update_header()-');

2549: arp_xla_events.create_events(p_xla_ev_rec => l_ev_rec );
2550:
2551: END IF;
2552: END IF; --bug 7193337
2553: arp_util.debug('arp_process_credit.update_header()-');
2554:
2555: EXCEPTION
2556:
2557: WHEN OTHERS THEN

Line 2558: arp_util.debug('EXCEPTION : arp_process_credit.update_header');

2554:
2555: EXCEPTION
2556:
2557: WHEN OTHERS THEN
2558: arp_util.debug('EXCEPTION : arp_process_credit.update_header');
2559:
2560: RAISE;
2561: END;
2562:

Line 2573: | arp_util.debug |

2569: | |
2570: | SCOPE - PRIVATE |
2571: | |
2572: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2573: | arp_util.debug |
2574: | |
2575: | ARGUMENTS : IN: |
2576: | p_form_name |
2577: | p_form_version |

Line 2658: arp_util.debug('arp_process_credit.insert_line()+');

2654: l_mode varchar2(30);
2655:
2656: BEGIN
2657:
2658: arp_util.debug('arp_process_credit.insert_line()+');
2659:
2660: /*--------------------------------------------------------------+
2661: | check form version to determine IF it is compatible with the |
2662: | entity handler. |

Line 2907: arp_util.debug('l_tax_status : '||l_tax_status);

2903: END;
2904:
2905: END IF;
2906:
2907: arp_util.debug('l_tax_status : '||l_tax_status);
2908: arp_util.debug('l_frt_status : '||l_frt_status);
2909: arp_util.debug('l_aa_status : '||l_aa_status);
2910: arp_util.debug('l_cmm_status : '||l_cmm_status);
2911:

Line 2908: arp_util.debug('l_frt_status : '||l_frt_status);

2904:
2905: END IF;
2906:
2907: arp_util.debug('l_tax_status : '||l_tax_status);
2908: arp_util.debug('l_frt_status : '||l_frt_status);
2909: arp_util.debug('l_aa_status : '||l_aa_status);
2910: arp_util.debug('l_cmm_status : '||l_cmm_status);
2911:
2912: IF (NVL(l_tax_status, 'OK') <> 'OK') THEN

Line 2909: arp_util.debug('l_aa_status : '||l_aa_status);

2905: END IF;
2906:
2907: arp_util.debug('l_tax_status : '||l_tax_status);
2908: arp_util.debug('l_frt_status : '||l_frt_status);
2909: arp_util.debug('l_aa_status : '||l_aa_status);
2910: arp_util.debug('l_cmm_status : '||l_cmm_status);
2911:
2912: IF (NVL(l_tax_status, 'OK') <> 'OK') THEN
2913: p_status := l_tax_status;

Line 2910: arp_util.debug('l_cmm_status : '||l_cmm_status);

2906:
2907: arp_util.debug('l_tax_status : '||l_tax_status);
2908: arp_util.debug('l_frt_status : '||l_frt_status);
2909: arp_util.debug('l_aa_status : '||l_aa_status);
2910: arp_util.debug('l_cmm_status : '||l_cmm_status);
2911:
2912: IF (NVL(l_tax_status, 'OK') <> 'OK') THEN
2913: p_status := l_tax_status;
2914: ELSIF (NVL(l_frt_status, 'OK') <> 'OK') THEN

Line 2922: arp_util.debug('arp_process_credit.insert_line()-');

2918: ELSIF (NVL(l_cmm_status, 'OK') <> 'OK') THEN
2919: p_status := l_cmm_status;
2920: END IF;
2921:
2922: arp_util.debug('arp_process_credit.insert_line()-');
2923:
2924: EXCEPTION
2925: when OTHERS THEN
2926: arp_util.debug('EXCEPTION: arp_process_credit.insert_line()');

Line 2926: arp_util.debug('EXCEPTION: arp_process_credit.insert_line()');

2922: arp_util.debug('arp_process_credit.insert_line()-');
2923:
2924: EXCEPTION
2925: when OTHERS THEN
2926: arp_util.debug('EXCEPTION: arp_process_credit.insert_line()');
2927: arp_ctl_pkg.display_line_rec(l_credit_rec);
2928: RAISE;
2929: END;
2930:

Line 2942: | arp_util.debug |

2938: | |
2939: | SCOPE - PRIVATE |
2940: | |
2941: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2942: | arp_util.debug |
2943: | |
2944: | ARGUMENTS : IN: |
2945: | p_customer_trx_line_id |
2946: | p_new_trx_rec |

Line 3001: arp_util.debug('arp_process_credit.set_line_flags()+');

2997:
2998:
2999: BEGIN
3000:
3001: arp_util.debug('arp_process_credit.set_line_flags()+');
3002:
3003: arp_ctl_pkg.fetch_p(l_old_line_rec, p_customer_trx_line_id);
3004:
3005: arp_process_credit.get_cm_amounts(

Line 3076: arp_util.debug('p_cr_line_amount : '||l_credited_line_amount);

3072: p_frt_mode := l_frt_mode;
3073: p_frt_ctlid := l_frt_ctlid;
3074: p_cm_complete_flag := l_cm_complete_flag;
3075:
3076: arp_util.debug('p_cr_line_amount : '||l_credited_line_amount);
3077: arp_util.debug('p_cr_tax_amount : '||l_credited_tax_amount);
3078: arp_util.debug('p_cr_frt_amount : '||l_credited_frt_amount );
3079: arp_util.debug('p_line_amt_chng_flag : '||
3080: arp_trx_util.boolean_to_varchar2(l_line_amt_chng_flag));

Line 3077: arp_util.debug('p_cr_tax_amount : '||l_credited_tax_amount);

3073: p_frt_ctlid := l_frt_ctlid;
3074: p_cm_complete_flag := l_cm_complete_flag;
3075:
3076: arp_util.debug('p_cr_line_amount : '||l_credited_line_amount);
3077: arp_util.debug('p_cr_tax_amount : '||l_credited_tax_amount);
3078: arp_util.debug('p_cr_frt_amount : '||l_credited_frt_amount );
3079: arp_util.debug('p_line_amt_chng_flag : '||
3080: arp_trx_util.boolean_to_varchar2(l_line_amt_chng_flag));
3081: arp_util.debug('p_tax_amt_chng_flag : '||

Line 3078: arp_util.debug('p_cr_frt_amount : '||l_credited_frt_amount );

3074: p_cm_complete_flag := l_cm_complete_flag;
3075:
3076: arp_util.debug('p_cr_line_amount : '||l_credited_line_amount);
3077: arp_util.debug('p_cr_tax_amount : '||l_credited_tax_amount);
3078: arp_util.debug('p_cr_frt_amount : '||l_credited_frt_amount );
3079: arp_util.debug('p_line_amt_chng_flag : '||
3080: arp_trx_util.boolean_to_varchar2(l_line_amt_chng_flag));
3081: arp_util.debug('p_tax_amt_chng_flag : '||
3082: arp_trx_util.boolean_to_varchar2(l_tax_amt_chng_flag));

Line 3079: arp_util.debug('p_line_amt_chng_flag : '||

3075:
3076: arp_util.debug('p_cr_line_amount : '||l_credited_line_amount);
3077: arp_util.debug('p_cr_tax_amount : '||l_credited_tax_amount);
3078: arp_util.debug('p_cr_frt_amount : '||l_credited_frt_amount );
3079: arp_util.debug('p_line_amt_chng_flag : '||
3080: arp_trx_util.boolean_to_varchar2(l_line_amt_chng_flag));
3081: arp_util.debug('p_tax_amt_chng_flag : '||
3082: arp_trx_util.boolean_to_varchar2(l_tax_amt_chng_flag));
3083: arp_util.debug('p_frt_amt_chng_flag : '||

Line 3081: arp_util.debug('p_tax_amt_chng_flag : '||

3077: arp_util.debug('p_cr_tax_amount : '||l_credited_tax_amount);
3078: arp_util.debug('p_cr_frt_amount : '||l_credited_frt_amount );
3079: arp_util.debug('p_line_amt_chng_flag : '||
3080: arp_trx_util.boolean_to_varchar2(l_line_amt_chng_flag));
3081: arp_util.debug('p_tax_amt_chng_flag : '||
3082: arp_trx_util.boolean_to_varchar2(l_tax_amt_chng_flag));
3083: arp_util.debug('p_frt_amt_chng_flag : '||
3084: arp_trx_util.boolean_to_varchar2(l_frt_amt_chng_flag));
3085: arp_util.debug('p_tax_mode : '||l_tax_mode);

Line 3083: arp_util.debug('p_frt_amt_chng_flag : '||

3079: arp_util.debug('p_line_amt_chng_flag : '||
3080: arp_trx_util.boolean_to_varchar2(l_line_amt_chng_flag));
3081: arp_util.debug('p_tax_amt_chng_flag : '||
3082: arp_trx_util.boolean_to_varchar2(l_tax_amt_chng_flag));
3083: arp_util.debug('p_frt_amt_chng_flag : '||
3084: arp_trx_util.boolean_to_varchar2(l_frt_amt_chng_flag));
3085: arp_util.debug('p_tax_mode : '||l_tax_mode);
3086: arp_util.debug('p_frt_mode : '||l_frt_mode);
3087: arp_util.debug('p_frt_ctlid : '||l_frt_ctlid);

Line 3085: arp_util.debug('p_tax_mode : '||l_tax_mode);

3081: arp_util.debug('p_tax_amt_chng_flag : '||
3082: arp_trx_util.boolean_to_varchar2(l_tax_amt_chng_flag));
3083: arp_util.debug('p_frt_amt_chng_flag : '||
3084: arp_trx_util.boolean_to_varchar2(l_frt_amt_chng_flag));
3085: arp_util.debug('p_tax_mode : '||l_tax_mode);
3086: arp_util.debug('p_frt_mode : '||l_frt_mode);
3087: arp_util.debug('p_frt_ctlid : '||l_frt_ctlid);
3088: arp_util.debug('p_cm_complete_flag : '||l_cm_complete_flag);
3089:

Line 3086: arp_util.debug('p_frt_mode : '||l_frt_mode);

3082: arp_trx_util.boolean_to_varchar2(l_tax_amt_chng_flag));
3083: arp_util.debug('p_frt_amt_chng_flag : '||
3084: arp_trx_util.boolean_to_varchar2(l_frt_amt_chng_flag));
3085: arp_util.debug('p_tax_mode : '||l_tax_mode);
3086: arp_util.debug('p_frt_mode : '||l_frt_mode);
3087: arp_util.debug('p_frt_ctlid : '||l_frt_ctlid);
3088: arp_util.debug('p_cm_complete_flag : '||l_cm_complete_flag);
3089:
3090: arp_util.debug('arp_process_credit.set_line_flags()-');

Line 3087: arp_util.debug('p_frt_ctlid : '||l_frt_ctlid);

3083: arp_util.debug('p_frt_amt_chng_flag : '||
3084: arp_trx_util.boolean_to_varchar2(l_frt_amt_chng_flag));
3085: arp_util.debug('p_tax_mode : '||l_tax_mode);
3086: arp_util.debug('p_frt_mode : '||l_frt_mode);
3087: arp_util.debug('p_frt_ctlid : '||l_frt_ctlid);
3088: arp_util.debug('p_cm_complete_flag : '||l_cm_complete_flag);
3089:
3090: arp_util.debug('arp_process_credit.set_line_flags()-');
3091:

Line 3088: arp_util.debug('p_cm_complete_flag : '||l_cm_complete_flag);

3084: arp_trx_util.boolean_to_varchar2(l_frt_amt_chng_flag));
3085: arp_util.debug('p_tax_mode : '||l_tax_mode);
3086: arp_util.debug('p_frt_mode : '||l_frt_mode);
3087: arp_util.debug('p_frt_ctlid : '||l_frt_ctlid);
3088: arp_util.debug('p_cm_complete_flag : '||l_cm_complete_flag);
3089:
3090: arp_util.debug('arp_process_credit.set_line_flags()-');
3091:
3092: EXCEPTION

Line 3090: arp_util.debug('arp_process_credit.set_line_flags()-');

3086: arp_util.debug('p_frt_mode : '||l_frt_mode);
3087: arp_util.debug('p_frt_ctlid : '||l_frt_ctlid);
3088: arp_util.debug('p_cm_complete_flag : '||l_cm_complete_flag);
3089:
3090: arp_util.debug('arp_process_credit.set_line_flags()-');
3091:
3092: EXCEPTION
3093: WHEN OTHERS THEN
3094: arp_util.debug('EXCEPTION: arp_process_credit.set_line_flags');

Line 3094: arp_util.debug('EXCEPTION: arp_process_credit.set_line_flags');

3090: arp_util.debug('arp_process_credit.set_line_flags()-');
3091:
3092: EXCEPTION
3093: WHEN OTHERS THEN
3094: arp_util.debug('EXCEPTION: arp_process_credit.set_line_flags');
3095: RAISE;
3096: END;
3097:
3098: /*===========================================================================+

Line 3108: | arp_util.debug |

3104: | |
3105: | SCOPE - PRIVATE |
3106: | |
3107: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3108: | arp_util.debug |
3109: | |
3110: | ARGUMENTS : IN: |
3111: | p_form_name |
3112: | p_form_version |

Line 3192: arp_util.debug('arp_process_credit.update_line()+');

3188: l_frt_status varchar2(30) := 'OK';
3189: l_recalculate_tax_flag BOOLEAN;
3190:
3191: BEGIN
3192: arp_util.debug('arp_process_credit.update_line()+');
3193:
3194: /*--------------------------------------------------------------+
3195: | check form version to determine IF it is compatible with the |
3196: | entity handler. |

Line 3231: arp_util.debug(

3227:
3228: EXCEPTION
3229: WHEN OTHERS THEN
3230:
3231: arp_util.debug(
3232: 'arp_etax_services_pkg.before_update_line raised exception');
3233: RAISE;
3234: END;
3235:

Line 3359: arp_util.debug('arp_process_credit.update_line '||

3355: pg_base_precision,
3356: pg_base_min_acc_unit);
3357: EXCEPTION
3358: WHEN NO_DATA_FOUND THEN
3359: arp_util.debug('arp_process_credit.update_line '||
3360: 'no distributions updated');
3361: WHEN OTHERS THEN
3362: RAISE;
3363: END;

Line 3367: arp_util.debug('l_tax_status : '||l_tax_status);

3363: END;
3364: END IF;
3365: END IF;
3366:
3367: arp_util.debug('l_tax_status : '||l_tax_status);
3368: arp_util.debug('l_frt_status : '||l_frt_status);
3369: arp_util.debug('l_rerun_aa_status : '||l_rerun_aa_status);
3370:
3371: IF (NVL(l_tax_status, 'OK') <> 'OK') THEN

Line 3368: arp_util.debug('l_frt_status : '||l_frt_status);

3364: END IF;
3365: END IF;
3366:
3367: arp_util.debug('l_tax_status : '||l_tax_status);
3368: arp_util.debug('l_frt_status : '||l_frt_status);
3369: arp_util.debug('l_rerun_aa_status : '||l_rerun_aa_status);
3370:
3371: IF (NVL(l_tax_status, 'OK') <> 'OK') THEN
3372: p_status := l_tax_status;

Line 3369: arp_util.debug('l_rerun_aa_status : '||l_rerun_aa_status);

3365: END IF;
3366:
3367: arp_util.debug('l_tax_status : '||l_tax_status);
3368: arp_util.debug('l_frt_status : '||l_frt_status);
3369: arp_util.debug('l_rerun_aa_status : '||l_rerun_aa_status);
3370:
3371: IF (NVL(l_tax_status, 'OK') <> 'OK') THEN
3372: p_status := l_tax_status;
3373: ELSIF (NVL(l_frt_status, 'OK') <> 'OK') THEN

Line 3379: arp_util.debug('arp_process_credit.update_line()-');

3375: ELSIF (NVL(l_rerun_aa_status, 'OK') <> 'OK') THEN
3376: p_status := l_rerun_aa_status;
3377: END IF;
3378:
3379: arp_util.debug('arp_process_credit.update_line()-');
3380:
3381: EXCEPTION
3382: WHEN OTHERS THEN
3383: arp_util.debug('EXCEPTION: arp_process_credit.update_line');

Line 3383: arp_util.debug('EXCEPTION: arp_process_credit.update_line');

3379: arp_util.debug('arp_process_credit.update_line()-');
3380:
3381: EXCEPTION
3382: WHEN OTHERS THEN
3383: arp_util.debug('EXCEPTION: arp_process_credit.update_line');
3384: RAISE;
3385: END;
3386: /*===========================================================================+
3387: | PROCEDURE |

Line 3396: | arp_util.debug |

3392: | |
3393: | SCOPE - PRIVATE |
3394: | |
3395: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3396: | arp_util.debug |
3397: | |
3398: | ARGUMENTS : IN: |
3399: | OUT: |
3400: | IN/ OUT: |

Line 3425: arp_util.debug('arp_process_credit.freight_post_update()+');

3421: l_rows_processed number;
3422: l_errorbuf varchar2(200);
3423: l_result number;
3424: BEGIN
3425: arp_util.debug('arp_process_credit.freight_post_update()+');
3426:
3427: -- replace this with the call to the CREDIT MEMO procedure
3428: -- update the distribution record
3429:

Line 3458: arp_util.debug('arp_process_credit.freight_post_update()-');

3454: RAISE;
3455: END;
3456:
3457:
3458: arp_util.debug('arp_process_credit.freight_post_update()-');
3459:
3460: EXCEPTION
3461:
3462: WHEN OTHERS THEN

Line 3463: arp_util.debug('EXCEPTION: arp_process_credit.freight_post_update()');

3459:
3460: EXCEPTION
3461:
3462: WHEN OTHERS THEN
3463: arp_util.debug('EXCEPTION: arp_process_credit.freight_post_update()');
3464:
3465: arp_util.debug('p_customer_trx_line_id : '||p_frt_rec.customer_trx_line_id);
3466: arp_util.debug('p_frt_ccid : '||p_frt_ccid);
3467: arp_util.debug('p_gl_date : '||p_gl_date);

Line 3465: arp_util.debug('p_customer_trx_line_id : '||p_frt_rec.customer_trx_line_id);

3461:
3462: WHEN OTHERS THEN
3463: arp_util.debug('EXCEPTION: arp_process_credit.freight_post_update()');
3464:
3465: arp_util.debug('p_customer_trx_line_id : '||p_frt_rec.customer_trx_line_id);
3466: arp_util.debug('p_frt_ccid : '||p_frt_ccid);
3467: arp_util.debug('p_gl_date : '||p_gl_date);
3468:
3469: END;

Line 3466: arp_util.debug('p_frt_ccid : '||p_frt_ccid);

3462: WHEN OTHERS THEN
3463: arp_util.debug('EXCEPTION: arp_process_credit.freight_post_update()');
3464:
3465: arp_util.debug('p_customer_trx_line_id : '||p_frt_rec.customer_trx_line_id);
3466: arp_util.debug('p_frt_ccid : '||p_frt_ccid);
3467: arp_util.debug('p_gl_date : '||p_gl_date);
3468:
3469: END;
3470:

Line 3467: arp_util.debug('p_gl_date : '||p_gl_date);

3463: arp_util.debug('EXCEPTION: arp_process_credit.freight_post_update()');
3464:
3465: arp_util.debug('p_customer_trx_line_id : '||p_frt_rec.customer_trx_line_id);
3466: arp_util.debug('p_frt_ccid : '||p_frt_ccid);
3467: arp_util.debug('p_gl_date : '||p_gl_date);
3468:
3469: END;
3470:
3471:

Line 3490: arp_util.debug('EXCEPTION: arp_process_credit.initialization');

3486: arp_trx_global.system_info.system_parameters.salesrep_required_flag;
3487:
3488: EXCEPTION
3489: WHEN OTHERS THEN
3490: arp_util.debug('EXCEPTION: arp_process_credit.initialization');
3491: RAISE;
3492: END init;
3493:
3494: BEGIN