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

Line 23: | arp_util.debug |

19: | |
20: | SCOPE - PRIVATE |
21: | |
22: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
23: | arp_util.debug |
24: | |
25: | ARGUMENTS : IN: |
26: | p_customer_trx_id |
27: | OUT: |

Line 50: arp_util.debug('arp_process_line.make_incomplete()+');

46:
47: BEGIN
48:
49: IF PG_DEBUG in ('Y', 'C') THEN
50: arp_util.debug('arp_process_line.make_incomplete()+');
51: END IF;
52:
53: arp_ct_pkg.set_to_dummy( l_trx_rec );
54:

Line 61: arp_util.debug('arp_process_line.make_incomplete()-');

57: arp_ct_pkg.update_p( l_trx_rec,
58: p_customer_trx_id );
59:
60: IF PG_DEBUG in ('Y', 'C') THEN
61: arp_util.debug('arp_process_line.make_incomplete()-');
62: END IF;
63:
64: EXCEPTION
65: WHEN OTHERS THEN

Line 67: arp_util.debug('EXCEPTION: arp_process_line.make_incomplete()');

63:
64: EXCEPTION
65: WHEN OTHERS THEN
66: IF PG_DEBUG in ('Y', 'C') THEN
67: arp_util.debug('EXCEPTION: arp_process_line.make_incomplete()');
68: arp_util.debug('make_incomplete: ' || '');
69: arp_util.debug('---------- parameters for make_incomplete() ---------');
70: arp_util.debug('make_incomplete: ' || 'p_customer_trx_id = ' || p_customer_trx_id );
71: END IF;

Line 68: arp_util.debug('make_incomplete: ' || '');

64: EXCEPTION
65: WHEN OTHERS THEN
66: IF PG_DEBUG in ('Y', 'C') THEN
67: arp_util.debug('EXCEPTION: arp_process_line.make_incomplete()');
68: arp_util.debug('make_incomplete: ' || '');
69: arp_util.debug('---------- parameters for make_incomplete() ---------');
70: arp_util.debug('make_incomplete: ' || 'p_customer_trx_id = ' || p_customer_trx_id );
71: END IF;
72:

Line 69: arp_util.debug('---------- parameters for make_incomplete() ---------');

65: WHEN OTHERS THEN
66: IF PG_DEBUG in ('Y', 'C') THEN
67: arp_util.debug('EXCEPTION: arp_process_line.make_incomplete()');
68: arp_util.debug('make_incomplete: ' || '');
69: arp_util.debug('---------- parameters for make_incomplete() ---------');
70: arp_util.debug('make_incomplete: ' || 'p_customer_trx_id = ' || p_customer_trx_id );
71: END IF;
72:
73: RAISE;

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

66: IF PG_DEBUG in ('Y', 'C') THEN
67: arp_util.debug('EXCEPTION: arp_process_line.make_incomplete()');
68: arp_util.debug('make_incomplete: ' || '');
69: arp_util.debug('---------- parameters for make_incomplete() ---------');
70: arp_util.debug('make_incomplete: ' || 'p_customer_trx_id = ' || p_customer_trx_id );
71: END IF;
72:
73: RAISE;
74:

Line 87: | arp_util.debug |

83: | |
84: | SCOPE - PRIVATE |
85: | |
86: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
87: | arp_util.debug |
88: | |
89: | ARGUMENTS : IN: |
90: | p_customer_trx_id |
91: | OUT: |

Line 110: arp_util.debug('arp_process_line.get_commitment_line_id()+');

106: IS
107: BEGIN
108:
109: IF PG_DEBUG in ('Y', 'C') THEN
110: arp_util.debug('arp_process_line.get_commitment_line_id()+');
111: END IF;
112:
113: BEGIN
114:

Line 129: arp_util.debug('arp_process_line.get_commitment_line_id()-');

125: RAISE;
126: END;
127:
128: IF PG_DEBUG in ('Y', 'C') THEN
129: arp_util.debug('arp_process_line.get_commitment_line_id()-');
130: END IF;
131:
132: EXCEPTION
133: WHEN OTHERS THEN

Line 135: arp_util.debug('EXCEPTION: arp_process_line.get_commitment_line_id()');

131:
132: EXCEPTION
133: WHEN OTHERS THEN
134: IF PG_DEBUG in ('Y', 'C') THEN
135: arp_util.debug('EXCEPTION: arp_process_line.get_commitment_line_id()');
136: arp_util.debug('------ parameters for get_commitment_line_id() -----');
137: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );
138: END IF;
139:

Line 136: arp_util.debug('------ parameters for get_commitment_line_id() -----');

132: EXCEPTION
133: WHEN OTHERS THEN
134: IF PG_DEBUG in ('Y', 'C') THEN
135: arp_util.debug('EXCEPTION: arp_process_line.get_commitment_line_id()');
136: arp_util.debug('------ parameters for get_commitment_line_id() -----');
137: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );
138: END IF;
139:
140: RAISE;

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

133: WHEN OTHERS THEN
134: IF PG_DEBUG in ('Y', 'C') THEN
135: arp_util.debug('EXCEPTION: arp_process_line.get_commitment_line_id()');
136: arp_util.debug('------ parameters for get_commitment_line_id() -----');
137: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );
138: END IF;
139:
140: RAISE;
141:

Line 155: | arp_util.debug |

151: | |
152: | SCOPE - PRIVATE |
153: | |
154: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
155: | arp_util.debug |
156: | |
157: | ARGUMENTS : IN: |
158: | p_line_rec |
159: | p_customer_trx_line_id |

Line 200: arp_util.debug('arp_process_line.set_flags()+');

196: l_last_period_changed_flag boolean;
197:
198: BEGIN
199:
200: arp_util.debug('arp_process_line.set_flags()+');
201:
202:
203: /*--------------------------------+
204: | Set the flags appropriately |

Line 268: arp_util.debug('l_derive_gl_date_flag = ' ||

264: /*------------------------+
265: | Print out NOCOPY the results |
266: +------------------------*/
267:
268: arp_util.debug('l_derive_gl_date_flag = ' ||
269: arp_trx_util.boolean_to_varchar2( l_derive_gl_date_flag ));
270: arp_util.debug('l_amount_changed_flag = ' ||
271: arp_trx_util.boolean_to_varchar2( l_amount_changed_flag ));
272: arp_util.debug('l_last_period_changed_flag = ' ||

Line 270: arp_util.debug('l_amount_changed_flag = ' ||

266: +------------------------*/
267:
268: arp_util.debug('l_derive_gl_date_flag = ' ||
269: arp_trx_util.boolean_to_varchar2( l_derive_gl_date_flag ));
270: arp_util.debug('l_amount_changed_flag = ' ||
271: arp_trx_util.boolean_to_varchar2( l_amount_changed_flag ));
272: arp_util.debug('l_last_period_changed_flag = ' ||
273: arp_trx_util.boolean_to_varchar2(
274: l_last_period_changed_flag ));

Line 272: arp_util.debug('l_last_period_changed_flag = ' ||

268: arp_util.debug('l_derive_gl_date_flag = ' ||
269: arp_trx_util.boolean_to_varchar2( l_derive_gl_date_flag ));
270: arp_util.debug('l_amount_changed_flag = ' ||
271: arp_trx_util.boolean_to_varchar2( l_amount_changed_flag ));
272: arp_util.debug('l_last_period_changed_flag = ' ||
273: arp_trx_util.boolean_to_varchar2(
274: l_last_period_changed_flag ));
275:
276: arp_util.debug('arp_process_line.set_flags()-');

Line 276: arp_util.debug('arp_process_line.set_flags()-');

272: arp_util.debug('l_last_period_changed_flag = ' ||
273: arp_trx_util.boolean_to_varchar2(
274: l_last_period_changed_flag ));
275:
276: arp_util.debug('arp_process_line.set_flags()-');
277:
278:
279: EXCEPTION
280: WHEN OTHERS THEN

Line 286: arp_util.debug('EXCEPTION: arp_process_line.set_flags()');

282: /*---------------------------------------------+
283: | Display parameters and raise the exception |
284: +---------------------------------------------*/
285:
286: arp_util.debug('EXCEPTION: arp_process_line.set_flags()');
287:
288: arp_util.debug('');
289: arp_util.debug('---------- parameters for set_flags() ---------');
290:

Line 288: arp_util.debug('');

284: +---------------------------------------------*/
285:
286: arp_util.debug('EXCEPTION: arp_process_line.set_flags()');
287:
288: arp_util.debug('');
289: arp_util.debug('---------- parameters for set_flags() ---------');
290:
291: arp_util.debug('p_customer_trx_line_id = ' ||
292: p_customer_trx_line_id);

Line 289: arp_util.debug('---------- parameters for set_flags() ---------');

285:
286: arp_util.debug('EXCEPTION: arp_process_line.set_flags()');
287:
288: arp_util.debug('');
289: arp_util.debug('---------- parameters for set_flags() ---------');
290:
291: arp_util.debug('p_customer_trx_line_id = ' ||
292: p_customer_trx_line_id);
293:

Line 291: arp_util.debug('p_customer_trx_line_id = ' ||

287:
288: arp_util.debug('');
289: arp_util.debug('---------- parameters for set_flags() ---------');
290:
291: arp_util.debug('p_customer_trx_line_id = ' ||
292: p_customer_trx_line_id);
293:
294: arp_util.debug('');
295:

Line 294: arp_util.debug('');

290:
291: arp_util.debug('p_customer_trx_line_id = ' ||
292: p_customer_trx_line_id);
293:
294: arp_util.debug('');
295:
296: arp_util.debug('---------- old line record ----------');
297: arp_ctl_pkg.display_line_rec( p_old_line_rec );
298: arp_util.debug('');

Line 296: arp_util.debug('---------- old line record ----------');

292: p_customer_trx_line_id);
293:
294: arp_util.debug('');
295:
296: arp_util.debug('---------- old line record ----------');
297: arp_ctl_pkg.display_line_rec( p_old_line_rec );
298: arp_util.debug('');
299:
300: arp_util.debug('---------- new line record ----------');

Line 298: arp_util.debug('');

294: arp_util.debug('');
295:
296: arp_util.debug('---------- old line record ----------');
297: arp_ctl_pkg.display_line_rec( p_old_line_rec );
298: arp_util.debug('');
299:
300: arp_util.debug('---------- new line record ----------');
301: arp_ctl_pkg.display_line_rec( p_line_rec );
302: arp_util.debug('');

Line 300: arp_util.debug('---------- new line record ----------');

296: arp_util.debug('---------- old line record ----------');
297: arp_ctl_pkg.display_line_rec( p_old_line_rec );
298: arp_util.debug('');
299:
300: arp_util.debug('---------- new line record ----------');
301: arp_ctl_pkg.display_line_rec( p_line_rec );
302: arp_util.debug('');
303:
304: RAISE;

Line 302: arp_util.debug('');

298: arp_util.debug('');
299:
300: arp_util.debug('---------- new line record ----------');
301: arp_ctl_pkg.display_line_rec( p_line_rec );
302: arp_util.debug('');
303:
304: RAISE;
305:
306: END;

Line 318: | arp_util.debug |

314: | |
315: | SCOPE - PRIVATE |
316: | |
317: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
318: | arp_util.debug |
319: | |
320: | ARGUMENTS : IN: |
321: | p_customer_trx_id |
322: | p_customer_trx_line_id |

Line 350: arp_util.debug('arp_process_line.line_rerun_aa()+');

346: l_num_failed_dist_rows binary_integer;
347:
348: BEGIN
349:
350: arp_util.debug('arp_process_line.line_rerun_aa()+');
351:
352: BEGIN
353: arp_auto_accounting.do_autoaccounting
354: (

Line 380: arp_util.debug('arp_process_line.line_rerun_aa()-');

376: WHEN OTHERS THEN
377: RAISE;
378: END;
379:
380: arp_util.debug('arp_process_line.line_rerun_aa()-');
381:
382: EXCEPTION
383: WHEN OTHERS THEN
384:

Line 385: arp_util.debug('EXCEPTION: arp_process_line.line_rerun_aa()');

381:
382: EXCEPTION
383: WHEN OTHERS THEN
384:
385: arp_util.debug('EXCEPTION: arp_process_line.line_rerun_aa()');
386:
387:
388: /*---------------------------------------------+
389: | Display parameters and raise the exception |

Line 392: arp_util.debug('');

388: /*---------------------------------------------+
389: | Display parameters and raise the exception |
390: +---------------------------------------------*/
391:
392: arp_util.debug('');
393: arp_util.debug('---------- parameters for line_rerun_aa() ---------');
394:
395: arp_util.debug('p_customer_trx_id = ' ||
396: p_customer_trx_id);

Line 393: arp_util.debug('---------- parameters for line_rerun_aa() ---------');

389: | Display parameters and raise the exception |
390: +---------------------------------------------*/
391:
392: arp_util.debug('');
393: arp_util.debug('---------- parameters for line_rerun_aa() ---------');
394:
395: arp_util.debug('p_customer_trx_id = ' ||
396: p_customer_trx_id);
397:

Line 395: arp_util.debug('p_customer_trx_id = ' ||

391:
392: arp_util.debug('');
393: arp_util.debug('---------- parameters for line_rerun_aa() ---------');
394:
395: arp_util.debug('p_customer_trx_id = ' ||
396: p_customer_trx_id);
397:
398: arp_util.debug('p_customer_trx_line_id = ' ||
399: p_customer_trx_line_id);

Line 398: arp_util.debug('p_customer_trx_line_id = ' ||

394:
395: arp_util.debug('p_customer_trx_id = ' ||
396: p_customer_trx_id);
397:
398: arp_util.debug('p_customer_trx_line_id = ' ||
399: p_customer_trx_line_id);
400:
401: arp_util.debug('');
402:

Line 401: arp_util.debug('');

397:
398: arp_util.debug('p_customer_trx_line_id = ' ||
399: p_customer_trx_line_id);
400:
401: arp_util.debug('');
402:
403: RAISE;
404:
405: END;

Line 421: | arp_util.debug |

417: | |
418: | SCOPE - PRIVATE |
419: | |
420: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
421: | arp_util.debug |
422: | |
423: | ARGUMENTS : IN: |
424: | p_customer_trx_id |
425: | p_trx_amount |

Line 457: arp_util.debug('arp_process_line.header_freight_only_rules_case()+');

453: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
454:
455: BEGIN
456:
457: arp_util.debug('arp_process_line.header_freight_only_rules_case()+');
458:
459: IF (arp_trx_util.detect_freight_only_rules_case( p_customer_trx_id ) = TRUE)
460: THEN
461:

Line 509: arp_util.debug('arp_process_line.header_freight_only_rules_case()-');

505: null);
506:
507: END IF;
508:
509: arp_util.debug('arp_process_line.header_freight_only_rules_case()-');
510:
511: EXCEPTION
512: WHEN OTHERS THEN
513: arp_util.debug(

Line 513: arp_util.debug(

509: arp_util.debug('arp_process_line.header_freight_only_rules_case()-');
510:
511: EXCEPTION
512: WHEN OTHERS THEN
513: arp_util.debug(
514: 'EXCEPTION: arp_process_line.header_freight_only_rules_case()');
515:
516: arp_util.debug('');
517: arp_util.debug('-- parameters for header_freight_only_rules_case() --');

Line 516: arp_util.debug('');

512: WHEN OTHERS THEN
513: arp_util.debug(
514: 'EXCEPTION: arp_process_line.header_freight_only_rules_case()');
515:
516: arp_util.debug('');
517: arp_util.debug('-- parameters for header_freight_only_rules_case() --');
518:
519: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
520: arp_util.debug('p_trx_amount = ' || p_trx_amount);

Line 517: arp_util.debug('-- parameters for header_freight_only_rules_case() --');

513: arp_util.debug(
514: 'EXCEPTION: arp_process_line.header_freight_only_rules_case()');
515:
516: arp_util.debug('');
517: arp_util.debug('-- parameters for header_freight_only_rules_case() --');
518:
519: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
520: arp_util.debug('p_trx_amount = ' || p_trx_amount);
521: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);

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

515:
516: arp_util.debug('');
517: arp_util.debug('-- parameters for header_freight_only_rules_case() --');
518:
519: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
520: arp_util.debug('p_trx_amount = ' || p_trx_amount);
521: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);
522: arp_util.debug('p_gl_date = ' || p_gl_date);
523:

Line 520: arp_util.debug('p_trx_amount = ' || p_trx_amount);

516: arp_util.debug('');
517: arp_util.debug('-- parameters for header_freight_only_rules_case() --');
518:
519: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
520: arp_util.debug('p_trx_amount = ' || p_trx_amount);
521: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);
522: arp_util.debug('p_gl_date = ' || p_gl_date);
523:
524: RAISE;

Line 521: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);

517: arp_util.debug('-- parameters for header_freight_only_rules_case() --');
518:
519: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
520: arp_util.debug('p_trx_amount = ' || p_trx_amount);
521: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);
522: arp_util.debug('p_gl_date = ' || p_gl_date);
523:
524: RAISE;
525:

Line 522: arp_util.debug('p_gl_date = ' || p_gl_date);

518:
519: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
520: arp_util.debug('p_trx_amount = ' || p_trx_amount);
521: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);
522: arp_util.debug('p_gl_date = ' || p_gl_date);
523:
524: RAISE;
525:
526: END;

Line 538: | arp_util.debug |

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

Line 567: arp_util.debug('arp_process_line.val_insert_line()+');

563:
564:
565: BEGIN
566:
567: arp_util.debug('arp_process_line.val_insert_line()+');
568:
569: arp_trx_validate.check_dup_line_number(p_line_rec.line_number,
570: p_line_rec.customer_trx_id,
571: null);

Line 588: arp_util.debug('arp_process_line.val_insert_line()-');

584: p_line_rec.rule_start_date,
585: arp_global.set_of_books_id );
586: END IF;
587:
588: arp_util.debug('arp_process_line.val_insert_line()-');
589:
590: EXCEPTION
591: WHEN OTHERS THEN
592: arp_util.debug('EXCEPTION: arp_process_line.val_insert_line()');

Line 592: arp_util.debug('EXCEPTION: arp_process_line.val_insert_line()');

588: arp_util.debug('arp_process_line.val_insert_line()-');
589:
590: EXCEPTION
591: WHEN OTHERS THEN
592: arp_util.debug('EXCEPTION: arp_process_line.val_insert_line()');
593:
594: arp_util.debug('');
595: arp_util.debug('------ parameters for val_insert_line() -------');
596:

Line 594: arp_util.debug('');

590: EXCEPTION
591: WHEN OTHERS THEN
592: arp_util.debug('EXCEPTION: arp_process_line.val_insert_line()');
593:
594: arp_util.debug('');
595: arp_util.debug('------ parameters for val_insert_line() -------');
596:
597: arp_ctl_pkg.display_line_rec(p_line_rec);
598:

Line 595: arp_util.debug('------ parameters for val_insert_line() -------');

591: WHEN OTHERS THEN
592: arp_util.debug('EXCEPTION: arp_process_line.val_insert_line()');
593:
594: arp_util.debug('');
595: arp_util.debug('------ parameters for val_insert_line() -------');
596:
597: arp_ctl_pkg.display_line_rec(p_line_rec);
598:
599: RAISE;

Line 613: | arp_util.debug |

609: | |
610: | SCOPE - PRIVATE |
611: | |
612: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
613: | arp_util.debug |
614: | |
615: | ARGUMENTS : IN: |
616: | p_line_rec - The line rec with the changed colums |
617: | p_db_line_rec - The old line record |

Line 648: arp_util.debug('arp_process_line.val_update_line()+');

644: l_line_rec ra_customer_trx_lines%rowtype;
645:
646: BEGIN
647:
648: arp_util.debug('arp_process_line.val_update_line()+');
649:
650:
651: arp_ctl_pkg.merge_line_recs( p_db_line_rec,
652: p_line_rec,

Line 663: arp_util.debug('EXCEPTION: arp_process_line.val_update_line()');

659: +------------------------------------------*/
660:
661: IF (l_line_rec.line_type not in ('LINE', 'CHARGES', 'CB') )
662: THEN
663: arp_util.debug('EXCEPTION: arp_process_line.val_update_line()');
664: arp_util.debug(
665: 'The specified line is not of type LINE, CHARGES or CB');
666: fnd_message.set_name('AR', 'C-1647');
667: app_exception.raise_exception;

Line 664: arp_util.debug(

660:
661: IF (l_line_rec.line_type not in ('LINE', 'CHARGES', 'CB') )
662: THEN
663: arp_util.debug('EXCEPTION: arp_process_line.val_update_line()');
664: arp_util.debug(
665: 'The specified line is not of type LINE, CHARGES or CB');
666: fnd_message.set_name('AR', 'C-1647');
667: app_exception.raise_exception;
668: END IF;

Line 689: arp_util.debug('arp_process_line.val_update_line()-');

685: l_line_rec.rule_start_date,
686: arp_global.set_of_books_id );
687: END IF;
688:
689: arp_util.debug('arp_process_line.val_update_line()-');
690:
691:
692: EXCEPTION
693: WHEN OTHERS THEN

Line 694: arp_util.debug('EXCEPTION: arp_process_line.val_update_line()');

690:
691:
692: EXCEPTION
693: WHEN OTHERS THEN
694: arp_util.debug('EXCEPTION: arp_process_line.val_update_line()');
695:
696: arp_util.debug('');
697: arp_util.debug('------ parameters for val_update_line() -------');
698:

Line 696: arp_util.debug('');

692: EXCEPTION
693: WHEN OTHERS THEN
694: arp_util.debug('EXCEPTION: arp_process_line.val_update_line()');
695:
696: arp_util.debug('');
697: arp_util.debug('------ parameters for val_update_line() -------');
698:
699: arp_util.debug('');
700: arp_util.debug('------ new line record -------');

Line 697: arp_util.debug('------ parameters for val_update_line() -------');

693: WHEN OTHERS THEN
694: arp_util.debug('EXCEPTION: arp_process_line.val_update_line()');
695:
696: arp_util.debug('');
697: arp_util.debug('------ parameters for val_update_line() -------');
698:
699: arp_util.debug('');
700: arp_util.debug('------ new line record -------');
701: arp_ctl_pkg.display_line_rec(p_line_rec);

Line 699: arp_util.debug('');

695:
696: arp_util.debug('');
697: arp_util.debug('------ parameters for val_update_line() -------');
698:
699: arp_util.debug('');
700: arp_util.debug('------ new line record -------');
701: arp_ctl_pkg.display_line_rec(p_line_rec);
702:
703: arp_util.debug('');

Line 700: arp_util.debug('------ new line record -------');

696: arp_util.debug('');
697: arp_util.debug('------ parameters for val_update_line() -------');
698:
699: arp_util.debug('');
700: arp_util.debug('------ new line record -------');
701: arp_ctl_pkg.display_line_rec(p_line_rec);
702:
703: arp_util.debug('');
704: arp_util.debug('------ old line record -------');

Line 703: arp_util.debug('');

699: arp_util.debug('');
700: arp_util.debug('------ new line record -------');
701: arp_ctl_pkg.display_line_rec(p_line_rec);
702:
703: arp_util.debug('');
704: arp_util.debug('------ old line record -------');
705: arp_ctl_pkg.display_line_rec(p_db_line_rec);
706:
707: arp_util.debug('');

Line 704: arp_util.debug('------ old line record -------');

700: arp_util.debug('------ new line record -------');
701: arp_ctl_pkg.display_line_rec(p_line_rec);
702:
703: arp_util.debug('');
704: arp_util.debug('------ old line record -------');
705: arp_ctl_pkg.display_line_rec(p_db_line_rec);
706:
707: arp_util.debug('');
708: arp_util.debug('------ merged line record -------');

Line 707: arp_util.debug('');

703: arp_util.debug('');
704: arp_util.debug('------ old line record -------');
705: arp_ctl_pkg.display_line_rec(p_db_line_rec);
706:
707: arp_util.debug('');
708: arp_util.debug('------ merged line record -------');
709: arp_ctl_pkg.display_line_rec(l_line_rec);
710:
711: RAISE;

Line 708: arp_util.debug('------ merged line record -------');

704: arp_util.debug('------ old line record -------');
705: arp_ctl_pkg.display_line_rec(p_db_line_rec);
706:
707: arp_util.debug('');
708: arp_util.debug('------ merged line record -------');
709: arp_ctl_pkg.display_line_rec(l_line_rec);
710:
711: RAISE;
712:

Line 725: | arp_util.debug |

721: | |
722: | SCOPE - PRIVATE |
723: | |
724: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
725: | arp_util.debug |
726: | |
727: | ARGUMENTS : IN: |
728: | p_line_rec |
729: | p_complete_flag |

Line 750: arp_util.debug('arp_process_line.val_delete_line()+');

746:
747:
748: BEGIN
749:
750: arp_util.debug('arp_process_line.val_delete_line()+');
751:
752: IF ( p_complete_flag = 'Y' )
753: THEN arp_trx_validate.check_has_one_line( p_line_rec.customer_trx_id );
754: END IF;

Line 757: arp_util.debug('arp_process_line.val_delete_line()-');

753: THEN arp_trx_validate.check_has_one_line( p_line_rec.customer_trx_id );
754: END IF;
755:
756:
757: arp_util.debug('arp_process_line.val_delete_line()-');
758:
759: EXCEPTION
760: WHEN OTHERS THEN
761: arp_util.debug('EXCEPTION: arp_process_line.val_delete_line()');

Line 761: arp_util.debug('EXCEPTION: arp_process_line.val_delete_line()');

757: arp_util.debug('arp_process_line.val_delete_line()-');
758:
759: EXCEPTION
760: WHEN OTHERS THEN
761: arp_util.debug('EXCEPTION: arp_process_line.val_delete_line()');
762:
763: arp_util.debug('');
764: arp_util.debug('------ parameters for val_delete_line() -------');
765:

Line 763: arp_util.debug('');

759: EXCEPTION
760: WHEN OTHERS THEN
761: arp_util.debug('EXCEPTION: arp_process_line.val_delete_line()');
762:
763: arp_util.debug('');
764: arp_util.debug('------ parameters for val_delete_line() -------');
765:
766: arp_util.debug('p_complete_flag = ' || p_complete_flag);
767:

Line 764: arp_util.debug('------ parameters for val_delete_line() -------');

760: WHEN OTHERS THEN
761: arp_util.debug('EXCEPTION: arp_process_line.val_delete_line()');
762:
763: arp_util.debug('');
764: arp_util.debug('------ parameters for val_delete_line() -------');
765:
766: arp_util.debug('p_complete_flag = ' || p_complete_flag);
767:
768: arp_ctl_pkg.display_line_rec(p_line_rec);

Line 766: arp_util.debug('p_complete_flag = ' || p_complete_flag);

762:
763: arp_util.debug('');
764: arp_util.debug('------ parameters for val_delete_line() -------');
765:
766: arp_util.debug('p_complete_flag = ' || p_complete_flag);
767:
768: arp_ctl_pkg.display_line_rec(p_line_rec);
769:
770: RAISE;

Line 784: | arp_util.debug |

780: | |
781: | SCOPE - PUBLIC |
782: | |
783: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
784: | arp_util.debug |
785: | |
786: | ARGUMENTS : IN: |
787: | p_form_name |
788: | p_form_version |

Line 913: arp_util.debug('arp_process_line.insert_line()+');

909: l_mode VARCHAR2(50);
910: l_called_from VARCHAR2(20) := NULL;
911: BEGIN
912:
913: arp_util.debug('arp_process_line.insert_line()+');
914:
915: arp_util.debug('ARTECTLB: p_line_rec.amount_includes_tax_flag = ' || p_line_rec.amount_includes_tax_flag);
916:
917: p_rule_start_date := p_line_rec.rule_start_date;

Line 915: arp_util.debug('ARTECTLB: p_line_rec.amount_includes_tax_flag = ' || p_line_rec.amount_includes_tax_flag);

911: BEGIN
912:
913: arp_util.debug('arp_process_line.insert_line()+');
914:
915: arp_util.debug('ARTECTLB: p_line_rec.amount_includes_tax_flag = ' || p_line_rec.amount_includes_tax_flag);
916:
917: p_rule_start_date := p_line_rec.rule_start_date;
918: p_accounting_rule_duration := p_line_rec.accounting_rule_duration;
919:

Line 952: arp_util.debug('ARTECTLB: l_line_rec.amount_includes_tax_flag = ' || l_line_rec.amount_includes_tax_flag);

948: /*----------------------------------------------+
949: | Call the table handler to insert the line |
950: +----------------------------------------------*/
951:
952: arp_util.debug('ARTECTLB: l_line_rec.amount_includes_tax_flag = ' || l_line_rec.amount_includes_tax_flag);
953:
954: arp_ctl_pkg.insert_p( l_line_rec,
955: l_customer_trx_line_id);
956:

Line 1011: arp_util.debug(

1007: +-----------------------------------------------------------------*/
1008:
1009: BEGIN
1010:
1011: arp_util.debug(
1012: 'arp_process_line.insert_line before create_tax_f_ctl_id');
1013:
1014: -- Rel. 11: call to new tax engine procedure
1015: -- to handle tax-inclusive case:

Line 1020: arp_util.debug(' Before calling Calculate TAX ');

1016:
1017: l_extended_amount := p_line_rec.extended_amount;
1018: l_unit_selling_price := p_line_rec.unit_selling_price;
1019:
1020: arp_util.debug('**** Before calling Calculate TAX ****');
1021: arp_util.debug(' Parameters:');
1022: arp_util.debug(' l_customer_trx_line_id = ' || l_customer_trx_line_id);
1023: arp_util.debug(' l_extended_amount = ' || l_extended_amount);
1024: arp_util.debug(' l_unit_selling_price = ' || l_unit_selling_price);

Line 1021: arp_util.debug(' Parameters:');

1017: l_extended_amount := p_line_rec.extended_amount;
1018: l_unit_selling_price := p_line_rec.unit_selling_price;
1019:
1020: arp_util.debug('**** Before calling Calculate TAX ****');
1021: arp_util.debug(' Parameters:');
1022: arp_util.debug(' l_customer_trx_line_id = ' || l_customer_trx_line_id);
1023: arp_util.debug(' l_extended_amount = ' || l_extended_amount);
1024: arp_util.debug(' l_unit_selling_price = ' || l_unit_selling_price);
1025: arp_util.debug(' p_header_currency_code = ' || p_header_currency_code);

Line 1022: arp_util.debug(' l_customer_trx_line_id = ' || l_customer_trx_line_id);

1018: l_unit_selling_price := p_line_rec.unit_selling_price;
1019:
1020: arp_util.debug('**** Before calling Calculate TAX ****');
1021: arp_util.debug(' Parameters:');
1022: arp_util.debug(' l_customer_trx_line_id = ' || l_customer_trx_line_id);
1023: arp_util.debug(' l_extended_amount = ' || l_extended_amount);
1024: arp_util.debug(' l_unit_selling_price = ' || l_unit_selling_price);
1025: arp_util.debug(' p_header_currency_code = ' || p_header_currency_code);
1026: arp_util.debug(' p_header_exchange_rate = ' || p_header_exchange_rate);

Line 1023: arp_util.debug(' l_extended_amount = ' || l_extended_amount);

1019:
1020: arp_util.debug('**** Before calling Calculate TAX ****');
1021: arp_util.debug(' Parameters:');
1022: arp_util.debug(' l_customer_trx_line_id = ' || l_customer_trx_line_id);
1023: arp_util.debug(' l_extended_amount = ' || l_extended_amount);
1024: arp_util.debug(' l_unit_selling_price = ' || l_unit_selling_price);
1025: arp_util.debug(' p_header_currency_code = ' || p_header_currency_code);
1026: arp_util.debug(' p_header_exchange_rate = ' || p_header_exchange_rate);
1027:

Line 1024: arp_util.debug(' l_unit_selling_price = ' || l_unit_selling_price);

1020: arp_util.debug('**** Before calling Calculate TAX ****');
1021: arp_util.debug(' Parameters:');
1022: arp_util.debug(' l_customer_trx_line_id = ' || l_customer_trx_line_id);
1023: arp_util.debug(' l_extended_amount = ' || l_extended_amount);
1024: arp_util.debug(' l_unit_selling_price = ' || l_unit_selling_price);
1025: arp_util.debug(' p_header_currency_code = ' || p_header_currency_code);
1026: arp_util.debug(' p_header_exchange_rate = ' || p_header_exchange_rate);
1027:
1028:

Line 1025: arp_util.debug(' p_header_currency_code = ' || p_header_currency_code);

1021: arp_util.debug(' Parameters:');
1022: arp_util.debug(' l_customer_trx_line_id = ' || l_customer_trx_line_id);
1023: arp_util.debug(' l_extended_amount = ' || l_extended_amount);
1024: arp_util.debug(' l_unit_selling_price = ' || l_unit_selling_price);
1025: arp_util.debug(' p_header_currency_code = ' || p_header_currency_code);
1026: arp_util.debug(' p_header_exchange_rate = ' || p_header_exchange_rate);
1027:
1028:
1029: /* 5197390 - Handle tax-type memo lines */

Line 1026: arp_util.debug(' p_header_exchange_rate = ' || p_header_exchange_rate);

1022: arp_util.debug(' l_customer_trx_line_id = ' || l_customer_trx_line_id);
1023: arp_util.debug(' l_extended_amount = ' || l_extended_amount);
1024: arp_util.debug(' l_unit_selling_price = ' || l_unit_selling_price);
1025: arp_util.debug(' p_header_currency_code = ' || p_header_currency_code);
1026: arp_util.debug(' p_header_exchange_rate = ' || p_header_exchange_rate);
1027:
1028:
1029: /* 5197390 - Handle tax-type memo lines */
1030: IF p_memo_line_type = 'TAX'

Line 1033: arp_util.debug('Overridding mode to INSERT_NO_TAX');

1029: /* 5197390 - Handle tax-type memo lines */
1030: IF p_memo_line_type = 'TAX'
1031: THEN
1032: l_mode := 'INSERT_NO_TAX';
1033: arp_util.debug('Overridding mode to INSERT_NO_TAX');
1034: ELSE
1035: l_mode := 'INSERT';
1036: END IF;
1037:

Line 1072: arp_util.debug(

1068: l_line_rec.gross_unit_selling_price := l_gross_unit_selling_price;
1069:
1070: ****************************************************************************/
1071:
1072: arp_util.debug(
1073: 'arp_process_line.insert_line after create_tax_f_ctl_id');
1074:
1075: EXCEPTION
1076: WHEN OTHERS THEN

Line 1114: arp_util.debug(

1110: BEGIN
1111:
1112: -- arp_global.msg_level := 99;
1113:
1114: arp_util.debug(
1115: 'arp_process_line.insert_line before credit_transactions');
1116:
1117: arp_credit_memo_module.credit_transactions(
1118: p_line_rec.customer_trx_id,

Line 1129: arp_util.debug(

1125: l_accounting_rule_duration,
1126: p_run_autoaccounting_flag =>
1127: (p_run_autoacc_flag = 'Y'));
1128:
1129: arp_util.debug(
1130: 'arp_process_line.insert_line after credit_transactions');
1131:
1132: p_rule_start_date := l_rule_start_date;
1133: p_accounting_rule_duration := l_accounting_rule_duration;

Line 1184: arp_util.debug('l_status1 = ' || l_status1);

1180: END IF;
1181:
1182: END IF;
1183:
1184: arp_util.debug('l_status1 = ' || l_status1);
1185: arp_util.debug('l_status2 = ' || l_status2);
1186: arp_util.debug('l_status3 = ' || l_status3);
1187: arp_util.debug('l_status4 = ' || l_status4);
1188:

Line 1185: arp_util.debug('l_status2 = ' || l_status2);

1181:
1182: END IF;
1183:
1184: arp_util.debug('l_status1 = ' || l_status1);
1185: arp_util.debug('l_status2 = ' || l_status2);
1186: arp_util.debug('l_status3 = ' || l_status3);
1187: arp_util.debug('l_status4 = ' || l_status4);
1188:
1189: IF ( NVL(l_status1, 'OK') <> 'OK' )

Line 1186: arp_util.debug('l_status3 = ' || l_status3);

1182: END IF;
1183:
1184: arp_util.debug('l_status1 = ' || l_status1);
1185: arp_util.debug('l_status2 = ' || l_status2);
1186: arp_util.debug('l_status3 = ' || l_status3);
1187: arp_util.debug('l_status4 = ' || l_status4);
1188:
1189: IF ( NVL(l_status1, 'OK') <> 'OK' )
1190: THEN p_status := l_status1;

Line 1187: arp_util.debug('l_status4 = ' || l_status4);

1183:
1184: arp_util.debug('l_status1 = ' || l_status1);
1185: arp_util.debug('l_status2 = ' || l_status2);
1186: arp_util.debug('l_status3 = ' || l_status3);
1187: arp_util.debug('l_status4 = ' || l_status4);
1188:
1189: IF ( NVL(l_status1, 'OK') <> 'OK' )
1190: THEN p_status := l_status1;
1191: ELSIF ( NVL(l_status2, 'OK') <> 'OK' )

Line 1220: arp_util.debug('Stamping distributions with the transaction code when entered at line level');

1216:
1217: IF ( p_line_rec.previous_customer_trx_id IS NOT NULL AND l_dist_line IS NOT NULL)
1218:
1219: THEN
1220: arp_util.debug('Stamping distributions with the transaction code when entered at line level');
1221: ARP_CTLGD_PKG.set_to_dummy(l_dist_rec);
1222: l_dist_rec.ussgl_transaction_code := p_line_rec.DEFAULT_USSGL_TRANSACTION_CODE;
1223: ARP_CTLGD_PKG.update_f_ctl_id(l_dist_rec,p_customer_trx_line_id,'N','');
1224:

Line 1245: arp_util.debug('Completed stamping distributions with the transaction code when entered at line level');

1241: EXCEPTION
1242: when NO_DATA_FOUND then
1243: null;
1244: END;
1245: arp_util.debug('Completed stamping distributions with the transaction code when entered at line level');
1246: END IF;
1247:
1248:
1249: --Bug#2750340

Line 1261: arp_util.debug('arp_process_line.insert_line()-');

1257: l_ev_rec.xla_call := 'B';
1258: l_ev_rec.xla_fetch_size := 999;
1259: arp_xla_events.create_events(p_xla_ev_rec => l_ev_rec );
1260:
1261: arp_util.debug('arp_process_line.insert_line()-');
1262:
1263: EXCEPTION
1264: WHEN OTHERS THEN
1265:

Line 1267: THEN arp_util.debug('AutoAccounting error: ' || l_errorbuf);

1263: EXCEPTION
1264: WHEN OTHERS THEN
1265:
1266: IF (l_errorbuf is not null)
1267: THEN arp_util.debug('AutoAccounting error: ' || l_errorbuf);
1268: END IF;
1269:
1270: /*---------------------------------------------+
1271: | Display parameters and raise the exception |

Line 1274: arp_util.debug('EXCEPTION: arp_process_line.insert_line()');

1270: /*---------------------------------------------+
1271: | Display parameters and raise the exception |
1272: +---------------------------------------------*/
1273:
1274: arp_util.debug('EXCEPTION: arp_process_line.insert_line()');
1275:
1276: arp_util.debug('');
1277: arp_util.debug('---------- parameters for insert_line() ---------');
1278:

Line 1276: arp_util.debug('');

1272: +---------------------------------------------*/
1273:
1274: arp_util.debug('EXCEPTION: arp_process_line.insert_line()');
1275:
1276: arp_util.debug('');
1277: arp_util.debug('---------- parameters for insert_line() ---------');
1278:
1279: arp_util.debug('p_form_name = ' || p_form_name );
1280: arp_util.debug('p_form_version = ' || p_form_version);

Line 1277: arp_util.debug('---------- parameters for insert_line() ---------');

1273:
1274: arp_util.debug('EXCEPTION: arp_process_line.insert_line()');
1275:
1276: arp_util.debug('');
1277: arp_util.debug('---------- parameters for insert_line() ---------');
1278:
1279: arp_util.debug('p_form_name = ' || p_form_name );
1280: arp_util.debug('p_form_version = ' || p_form_version);
1281: arp_util.debug('p_memo_line_type = ' || p_memo_line_type);

Line 1279: arp_util.debug('p_form_name = ' || p_form_name );

1275:
1276: arp_util.debug('');
1277: arp_util.debug('---------- parameters for insert_line() ---------');
1278:
1279: arp_util.debug('p_form_name = ' || p_form_name );
1280: arp_util.debug('p_form_version = ' || p_form_version);
1281: arp_util.debug('p_memo_line_type = ' || p_memo_line_type);
1282: arp_util.debug('');
1283:

Line 1280: arp_util.debug('p_form_version = ' || p_form_version);

1276: arp_util.debug('');
1277: arp_util.debug('---------- parameters for insert_line() ---------');
1278:
1279: arp_util.debug('p_form_name = ' || p_form_name );
1280: arp_util.debug('p_form_version = ' || p_form_version);
1281: arp_util.debug('p_memo_line_type = ' || p_memo_line_type);
1282: arp_util.debug('');
1283:
1284: arp_ctl_pkg.display_line_rec(p_line_rec);

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

1277: arp_util.debug('---------- parameters for insert_line() ---------');
1278:
1279: arp_util.debug('p_form_name = ' || p_form_name );
1280: arp_util.debug('p_form_version = ' || p_form_version);
1281: arp_util.debug('p_memo_line_type = ' || p_memo_line_type);
1282: arp_util.debug('');
1283:
1284: arp_ctl_pkg.display_line_rec(p_line_rec);
1285:

Line 1282: arp_util.debug('');

1278:
1279: arp_util.debug('p_form_name = ' || p_form_name );
1280: arp_util.debug('p_form_version = ' || p_form_version);
1281: arp_util.debug('p_memo_line_type = ' || p_memo_line_type);
1282: arp_util.debug('');
1283:
1284: arp_ctl_pkg.display_line_rec(p_line_rec);
1285:
1286: RAISE;

Line 1301: | arp_util.debug |

1297: | |
1298: | SCOPE - PUBLIC |
1299: | |
1300: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1301: | arp_util.debug |
1302: | |
1303: | ARGUMENTS : IN: |
1304: | p_form_name |
1305: | p_form_version |

Line 1418: arp_util.debug('arp_process_line.update_line()+');

1414: l_test VARCHAR2(1);
1415: --}
1416: BEGIN
1417:
1418: arp_util.debug('arp_process_line.update_line()+');
1419:
1420: p_rule_start_date := p_line_rec.rule_start_date;
1421: p_accounting_rule_duration := p_line_rec.accounting_rule_duration;
1422:

Line 1490: arp_util.debug(

1486:
1487: EXCEPTION
1488: WHEN OTHERS THEN
1489:
1490: arp_util.debug(
1491: 'arp_etax_services_pkg.before_update_line raised exception');
1492: RAISE;
1493: END;
1494:

Line 1582: arp_util.debug('ERROR COMPUTING TAX ');

1578: p_action => 'UPDATE',
1579: p_line_level_action => 'UPDATE');
1580:
1581: IF (NOT l_tax_computed) THEN
1582: arp_util.debug('ERROR COMPUTING TAX ');
1583: app_exception.raise_exception;
1584: END IF;
1585: *****************************************************************/
1586:

Line 1692: arp_util.debug('l_status1 = ' || l_status1);

1688: pg_base_precision,
1689: pg_base_min_acct_unit );
1690: END IF;
1691:
1692: arp_util.debug('l_status1 = ' || l_status1);
1693: arp_util.debug('l_status2 = ' || l_status2);
1694: arp_util.debug('l_status3 = ' || l_status3);
1695: arp_util.debug('l_status4 = ' || l_status4);
1696:

Line 1693: arp_util.debug('l_status2 = ' || l_status2);

1689: pg_base_min_acct_unit );
1690: END IF;
1691:
1692: arp_util.debug('l_status1 = ' || l_status1);
1693: arp_util.debug('l_status2 = ' || l_status2);
1694: arp_util.debug('l_status3 = ' || l_status3);
1695: arp_util.debug('l_status4 = ' || l_status4);
1696:
1697: IF ( NVL(l_status1, 'OK') <> 'OK' )

Line 1694: arp_util.debug('l_status3 = ' || l_status3);

1690: END IF;
1691:
1692: arp_util.debug('l_status1 = ' || l_status1);
1693: arp_util.debug('l_status2 = ' || l_status2);
1694: arp_util.debug('l_status3 = ' || l_status3);
1695: arp_util.debug('l_status4 = ' || l_status4);
1696:
1697: IF ( NVL(l_status1, 'OK') <> 'OK' )
1698: THEN p_status := l_status1;

Line 1695: arp_util.debug('l_status4 = ' || l_status4);

1691:
1692: arp_util.debug('l_status1 = ' || l_status1);
1693: arp_util.debug('l_status2 = ' || l_status2);
1694: arp_util.debug('l_status3 = ' || l_status3);
1695: arp_util.debug('l_status4 = ' || l_status4);
1696:
1697: IF ( NVL(l_status1, 'OK') <> 'OK' )
1698: THEN p_status := l_status1;
1699: ELSIF ( NVL(l_status2, 'OK') <> 'OK' )

Line 1730: arp_util.debug('Updating distributions with the transaction code when changed at line level');

1726: THEN
1727: IF nvl(l_db_line_rec.DEFAULT_USSGL_TRANSACTION_CODE,0) <> nvl(p_line_rec.DEFAULT_USSGL_TRANSACTION_CODE,0)
1728: THEN
1729:
1730: arp_util.debug('Updating distributions with the transaction code when changed at line level');
1731: ARP_CTLGD_PKG.set_to_dummy(l_dist_rec);
1732: l_dist_rec.ussgl_transaction_code := p_line_rec.DEFAULT_USSGL_TRANSACTION_CODE;
1733: ARP_CTLGD_PKG.update_f_ctl_id(l_dist_rec,p_customer_trx_line_id,'N','');
1734:

Line 1756: arp_util.debug('Completed updating distributions with the transaction code when changed at line level');

1752: EXCEPTION
1753: when NO_DATA_FOUND then
1754: null;
1755: END;
1756: arp_util.debug('Completed updating distributions with the transaction code when changed at line level');
1757: END IF;
1758: END IF;
1759:
1760: OPEN cpost;

Line 1777: arp_util.debug('arp_process_line.update_line()-');

1773: arp_xla_events.create_events(p_xla_ev_rec => l_ev_rec );
1774: END IF;
1775: CLOSE cpost;
1776:
1777: arp_util.debug('arp_process_line.update_line()-');
1778:
1779: EXCEPTION
1780: WHEN OTHERS THEN
1781:

Line 1782: arp_util.debug('EXCEPTION: arp_process_line.update_line()');

1778:
1779: EXCEPTION
1780: WHEN OTHERS THEN
1781:
1782: arp_util.debug('EXCEPTION: arp_process_line.update_line()');
1783:
1784: arp_util.debug('');
1785: arp_util.debug('---------- parameters for update_line() ---------');
1786:

Line 1784: arp_util.debug('');

1780: WHEN OTHERS THEN
1781:
1782: arp_util.debug('EXCEPTION: arp_process_line.update_line()');
1783:
1784: arp_util.debug('');
1785: arp_util.debug('---------- parameters for update_line() ---------');
1786:
1787: arp_util.debug('p_form_name = ' || p_form_name );
1788: arp_util.debug('p_form_version = ' || p_form_version);

Line 1785: arp_util.debug('---------- parameters for update_line() ---------');

1781:
1782: arp_util.debug('EXCEPTION: arp_process_line.update_line()');
1783:
1784: arp_util.debug('');
1785: arp_util.debug('---------- parameters for update_line() ---------');
1786:
1787: arp_util.debug('p_form_name = ' || p_form_name );
1788: arp_util.debug('p_form_version = ' || p_form_version);
1789: arp_util.debug('p_customer_trx_line_id = ' ||

Line 1787: arp_util.debug('p_form_name = ' || p_form_name );

1783:
1784: arp_util.debug('');
1785: arp_util.debug('---------- parameters for update_line() ---------');
1786:
1787: arp_util.debug('p_form_name = ' || p_form_name );
1788: arp_util.debug('p_form_version = ' || p_form_version);
1789: arp_util.debug('p_customer_trx_line_id = ' ||
1790: p_customer_trx_line_id);
1791: arp_util.debug('p_foreign_currency_code = ' ||p_foreign_currency_code);

Line 1788: arp_util.debug('p_form_version = ' || p_form_version);

1784: arp_util.debug('');
1785: arp_util.debug('---------- parameters for update_line() ---------');
1786:
1787: arp_util.debug('p_form_name = ' || p_form_name );
1788: arp_util.debug('p_form_version = ' || p_form_version);
1789: arp_util.debug('p_customer_trx_line_id = ' ||
1790: p_customer_trx_line_id);
1791: arp_util.debug('p_foreign_currency_code = ' ||p_foreign_currency_code);
1792: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);

Line 1789: arp_util.debug('p_customer_trx_line_id = ' ||

1785: arp_util.debug('---------- parameters for update_line() ---------');
1786:
1787: arp_util.debug('p_form_name = ' || p_form_name );
1788: arp_util.debug('p_form_version = ' || p_form_version);
1789: arp_util.debug('p_customer_trx_line_id = ' ||
1790: p_customer_trx_line_id);
1791: arp_util.debug('p_foreign_currency_code = ' ||p_foreign_currency_code);
1792: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);
1793: arp_util.debug('p_recalculate_tax_flag = ' ||

Line 1791: arp_util.debug('p_foreign_currency_code = ' ||p_foreign_currency_code);

1787: arp_util.debug('p_form_name = ' || p_form_name );
1788: arp_util.debug('p_form_version = ' || p_form_version);
1789: arp_util.debug('p_customer_trx_line_id = ' ||
1790: p_customer_trx_line_id);
1791: arp_util.debug('p_foreign_currency_code = ' ||p_foreign_currency_code);
1792: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);
1793: arp_util.debug('p_recalculate_tax_flag = ' ||
1794: arp_trx_util.boolean_to_varchar2(p_recalculate_tax_flag));
1795: arp_util.debug('p_rerun_autoacc_flag = ' ||

Line 1792: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);

1788: arp_util.debug('p_form_version = ' || p_form_version);
1789: arp_util.debug('p_customer_trx_line_id = ' ||
1790: p_customer_trx_line_id);
1791: arp_util.debug('p_foreign_currency_code = ' ||p_foreign_currency_code);
1792: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);
1793: arp_util.debug('p_recalculate_tax_flag = ' ||
1794: arp_trx_util.boolean_to_varchar2(p_recalculate_tax_flag));
1795: arp_util.debug('p_rerun_autoacc_flag = ' ||
1796: arp_trx_util.boolean_to_varchar2(p_rerun_autoacc_flag));

Line 1793: arp_util.debug('p_recalculate_tax_flag = ' ||

1789: arp_util.debug('p_customer_trx_line_id = ' ||
1790: p_customer_trx_line_id);
1791: arp_util.debug('p_foreign_currency_code = ' ||p_foreign_currency_code);
1792: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);
1793: arp_util.debug('p_recalculate_tax_flag = ' ||
1794: arp_trx_util.boolean_to_varchar2(p_recalculate_tax_flag));
1795: arp_util.debug('p_rerun_autoacc_flag = ' ||
1796: arp_trx_util.boolean_to_varchar2(p_rerun_autoacc_flag));
1797:

Line 1795: arp_util.debug('p_rerun_autoacc_flag = ' ||

1791: arp_util.debug('p_foreign_currency_code = ' ||p_foreign_currency_code);
1792: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);
1793: arp_util.debug('p_recalculate_tax_flag = ' ||
1794: arp_trx_util.boolean_to_varchar2(p_recalculate_tax_flag));
1795: arp_util.debug('p_rerun_autoacc_flag = ' ||
1796: arp_trx_util.boolean_to_varchar2(p_rerun_autoacc_flag));
1797:
1798: arp_util.debug('');
1799:

Line 1798: arp_util.debug('');

1794: arp_trx_util.boolean_to_varchar2(p_recalculate_tax_flag));
1795: arp_util.debug('p_rerun_autoacc_flag = ' ||
1796: arp_trx_util.boolean_to_varchar2(p_rerun_autoacc_flag));
1797:
1798: arp_util.debug('');
1799:
1800: arp_ctl_pkg.display_line_rec(p_line_rec);
1801:
1802: RAISE;

Line 1816: | arp_util.debug |

1812: | |
1813: | SCOPE - PUBLIC |
1814: | |
1815: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1816: | arp_util.debug |
1817: | |
1818: | ARGUMENTS : IN: |
1819: | p_form_name |
1820: | p_form_version |

Line 1891: arp_util.debug('arp_process_line.delete_line()+');

1887: where customer_trx_line_id = p_customer_trx_line_id
1888: FOR UPDATE OF customer_trx_line_id NOWAIT;
1889: BEGIN
1890:
1891: arp_util.debug('arp_process_line.delete_line()+');
1892:
1893: p_status := 'OK';
1894:
1895: /*----------------------------------------------+

Line 2039: arp_util.debug('arp_process_line.delete_line()-');

2035: -- (the tax may not be valid for the new trx_date)
2036: null;
2037: END IF;
2038:
2039: arp_util.debug('arp_process_line.delete_line()-');
2040:
2041: EXCEPTION
2042: WHEN OTHERS THEN
2043:

Line 2048: arp_util.debug('EXCEPTION: arp_process_line.delete_line()');

2044: /*---------------------------------------------+
2045: | Display parameters and raise the exception |
2046: +---------------------------------------------*/
2047:
2048: arp_util.debug('EXCEPTION: arp_process_line.delete_line()');
2049:
2050: arp_util.debug('');
2051: arp_util.debug('---------- parameters for delete_line() ---------');
2052:

Line 2050: arp_util.debug('');

2046: +---------------------------------------------*/
2047:
2048: arp_util.debug('EXCEPTION: arp_process_line.delete_line()');
2049:
2050: arp_util.debug('');
2051: arp_util.debug('---------- parameters for delete_line() ---------');
2052:
2053: arp_util.debug('p_form_name = ' || p_form_name );
2054: arp_util.debug('p_form_version = ' || p_form_version);

Line 2051: arp_util.debug('---------- parameters for delete_line() ---------');

2047:
2048: arp_util.debug('EXCEPTION: arp_process_line.delete_line()');
2049:
2050: arp_util.debug('');
2051: arp_util.debug('---------- parameters for delete_line() ---------');
2052:
2053: arp_util.debug('p_form_name = ' || p_form_name );
2054: arp_util.debug('p_form_version = ' || p_form_version);
2055: arp_util.debug('p_customer_trx_line_id = ' ||

Line 2053: arp_util.debug('p_form_name = ' || p_form_name );

2049:
2050: arp_util.debug('');
2051: arp_util.debug('---------- parameters for delete_line() ---------');
2052:
2053: arp_util.debug('p_form_name = ' || p_form_name );
2054: arp_util.debug('p_form_version = ' || p_form_version);
2055: arp_util.debug('p_customer_trx_line_id = ' ||
2056: p_customer_trx_line_id);
2057: arp_util.debug('p_complete_flag = ' || p_complete_flag);

Line 2054: arp_util.debug('p_form_version = ' || p_form_version);

2050: arp_util.debug('');
2051: arp_util.debug('---------- parameters for delete_line() ---------');
2052:
2053: arp_util.debug('p_form_name = ' || p_form_name );
2054: arp_util.debug('p_form_version = ' || p_form_version);
2055: arp_util.debug('p_customer_trx_line_id = ' ||
2056: p_customer_trx_line_id);
2057: arp_util.debug('p_complete_flag = ' || p_complete_flag);
2058: arp_util.debug('p_recalculate_tax_flag = ' ||

Line 2055: arp_util.debug('p_customer_trx_line_id = ' ||

2051: arp_util.debug('---------- parameters for delete_line() ---------');
2052:
2053: arp_util.debug('p_form_name = ' || p_form_name );
2054: arp_util.debug('p_form_version = ' || p_form_version);
2055: arp_util.debug('p_customer_trx_line_id = ' ||
2056: p_customer_trx_line_id);
2057: arp_util.debug('p_complete_flag = ' || p_complete_flag);
2058: arp_util.debug('p_recalculate_tax_flag = ' ||
2059: arp_trx_util.boolean_to_varchar2(p_recalculate_tax_flag));

Line 2057: arp_util.debug('p_complete_flag = ' || p_complete_flag);

2053: arp_util.debug('p_form_name = ' || p_form_name );
2054: arp_util.debug('p_form_version = ' || p_form_version);
2055: arp_util.debug('p_customer_trx_line_id = ' ||
2056: p_customer_trx_line_id);
2057: arp_util.debug('p_complete_flag = ' || p_complete_flag);
2058: arp_util.debug('p_recalculate_tax_flag = ' ||
2059: arp_trx_util.boolean_to_varchar2(p_recalculate_tax_flag));
2060: arp_util.debug('p_trx_amount = ' || p_trx_amount);
2061: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);

Line 2058: arp_util.debug('p_recalculate_tax_flag = ' ||

2054: arp_util.debug('p_form_version = ' || p_form_version);
2055: arp_util.debug('p_customer_trx_line_id = ' ||
2056: p_customer_trx_line_id);
2057: arp_util.debug('p_complete_flag = ' || p_complete_flag);
2058: arp_util.debug('p_recalculate_tax_flag = ' ||
2059: arp_trx_util.boolean_to_varchar2(p_recalculate_tax_flag));
2060: arp_util.debug('p_trx_amount = ' || p_trx_amount);
2061: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);
2062: arp_util.debug('p_gl_date = ' || p_gl_date);

Line 2060: arp_util.debug('p_trx_amount = ' || p_trx_amount);

2056: p_customer_trx_line_id);
2057: arp_util.debug('p_complete_flag = ' || p_complete_flag);
2058: arp_util.debug('p_recalculate_tax_flag = ' ||
2059: arp_trx_util.boolean_to_varchar2(p_recalculate_tax_flag));
2060: arp_util.debug('p_trx_amount = ' || p_trx_amount);
2061: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);
2062: arp_util.debug('p_gl_date = ' || p_gl_date);
2063: arp_util.debug('p_trx_date = ' || p_trx_date);
2064: arp_util.debug('');

Line 2061: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);

2057: arp_util.debug('p_complete_flag = ' || p_complete_flag);
2058: arp_util.debug('p_recalculate_tax_flag = ' ||
2059: arp_trx_util.boolean_to_varchar2(p_recalculate_tax_flag));
2060: arp_util.debug('p_trx_amount = ' || p_trx_amount);
2061: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);
2062: arp_util.debug('p_gl_date = ' || p_gl_date);
2063: arp_util.debug('p_trx_date = ' || p_trx_date);
2064: arp_util.debug('');
2065:

Line 2062: arp_util.debug('p_gl_date = ' || p_gl_date);

2058: arp_util.debug('p_recalculate_tax_flag = ' ||
2059: arp_trx_util.boolean_to_varchar2(p_recalculate_tax_flag));
2060: arp_util.debug('p_trx_amount = ' || p_trx_amount);
2061: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);
2062: arp_util.debug('p_gl_date = ' || p_gl_date);
2063: arp_util.debug('p_trx_date = ' || p_trx_date);
2064: arp_util.debug('');
2065:
2066: arp_ctl_pkg.display_line_rec(p_line_rec);

Line 2063: arp_util.debug('p_trx_date = ' || p_trx_date);

2059: arp_trx_util.boolean_to_varchar2(p_recalculate_tax_flag));
2060: arp_util.debug('p_trx_amount = ' || p_trx_amount);
2061: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);
2062: arp_util.debug('p_gl_date = ' || p_gl_date);
2063: arp_util.debug('p_trx_date = ' || p_trx_date);
2064: arp_util.debug('');
2065:
2066: arp_ctl_pkg.display_line_rec(p_line_rec);
2067:

Line 2064: arp_util.debug('');

2060: arp_util.debug('p_trx_amount = ' || p_trx_amount);
2061: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);
2062: arp_util.debug('p_gl_date = ' || p_gl_date);
2063: arp_util.debug('p_trx_date = ' || p_trx_date);
2064: arp_util.debug('');
2065:
2066: arp_ctl_pkg.display_line_rec(p_line_rec);
2067:
2068: RAISE;

Line 2086: arp_util.debug('EXCEPTION: arp_process_line.initialization');

2082: pg_earliest_date := to_date('01/01/1901', 'DD/MM/YYYY');
2083:
2084: EXCEPTION
2085: WHEN OTHERS THEN
2086: arp_util.debug('EXCEPTION: arp_process_line.initialization');
2087: RAISE;
2088:
2089:
2090: END ARP_PROCESS_LINE;