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

Line 110: | arp_util.debug |

106: | |
107: | SCOPE - PUBLIC |
108: | |
109: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
110: | arp_util.debug |
111: | |
112: | ARGUMENTS : IN: |
113: | p_customer_trx_line_id |
114: | p_last_date_to_credit |

Line 149: arp_util.debug('arp_trx_line_util.derive_last_pd_to_cr()+');

145:
146: BEGIN
147:
148: IF PG_DEBUG in ('Y', 'C') THEN
149: arp_util.debug('arp_trx_line_util.derive_last_pd_to_cr()+');
150: END IF;
151:
152: /*-------------------------------------------------+
153: | Validate that the Last GL Date is between the |

Line 224: arp_util.debug('arp_trx_line_util.derive_last_pd_to_cr()-');

220: ( gl_dates_rec.gl_date - l_prior_date );
221: END IF;
222:
223: IF PG_DEBUG in ('Y', 'C') THEN
224: arp_util.debug('arp_trx_line_util.derive_last_pd_to_cr()-');
225: END IF;
226: RETURN( l_period_count + l_period_fraction );
227:
228: ELSE /* p_last_date_to_credit = gl_dates_rec.gl_date */

Line 231: arp_util.debug('arp_trx_line_util.derive_last_pd_to_cr()-');

227:
228: ELSE /* p_last_date_to_credit = gl_dates_rec.gl_date */
229:
230: IF PG_DEBUG in ('Y', 'C') THEN
231: arp_util.debug('arp_trx_line_util.derive_last_pd_to_cr()-');
232: END IF;
233: RETURN( l_period_count );
234:
235: END IF; /* IF ( p_last_date_to_credit < gl_dates_rec.gl_date ) */

Line 248: arp_util.debug('EXCEPTION: arp_trx_line_util.derive_last_pd_to_cr()');

244:
245: EXCEPTION
246: WHEN OTHERS THEN
247: IF PG_DEBUG in ('Y', 'C') THEN
248: arp_util.debug('EXCEPTION: arp_trx_line_util.derive_last_pd_to_cr()');
249: arp_util.debug('derive_last_pd_to_cr: ' || '----- Parameters for ' ||
250: 'arp_trx_line_util.derive_last_pd_to_cr() ' || '-----' );
251: arp_util.debug('derive_last_pd_to_cr: ' || 'p_customer_trx_line_id = ' || p_customer_trx_line_id );
252: arp_util.debug('derive_last_pd_to_cr: ' || 'p_last_date_to_credit = ' || p_last_date_to_credit );

Line 249: arp_util.debug('derive_last_pd_to_cr: ' || '----- Parameters for ' ||

245: EXCEPTION
246: WHEN OTHERS THEN
247: IF PG_DEBUG in ('Y', 'C') THEN
248: arp_util.debug('EXCEPTION: arp_trx_line_util.derive_last_pd_to_cr()');
249: arp_util.debug('derive_last_pd_to_cr: ' || '----- Parameters for ' ||
250: 'arp_trx_line_util.derive_last_pd_to_cr() ' || '-----' );
251: arp_util.debug('derive_last_pd_to_cr: ' || 'p_customer_trx_line_id = ' || p_customer_trx_line_id );
252: arp_util.debug('derive_last_pd_to_cr: ' || 'p_last_date_to_credit = ' || p_last_date_to_credit );
253: END IF;

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

247: IF PG_DEBUG in ('Y', 'C') THEN
248: arp_util.debug('EXCEPTION: arp_trx_line_util.derive_last_pd_to_cr()');
249: arp_util.debug('derive_last_pd_to_cr: ' || '----- Parameters for ' ||
250: 'arp_trx_line_util.derive_last_pd_to_cr() ' || '-----' );
251: arp_util.debug('derive_last_pd_to_cr: ' || 'p_customer_trx_line_id = ' || p_customer_trx_line_id );
252: arp_util.debug('derive_last_pd_to_cr: ' || 'p_last_date_to_credit = ' || p_last_date_to_credit );
253: END IF;
254: RAISE;
255:

Line 252: arp_util.debug('derive_last_pd_to_cr: ' || 'p_last_date_to_credit = ' || p_last_date_to_credit );

248: arp_util.debug('EXCEPTION: arp_trx_line_util.derive_last_pd_to_cr()');
249: arp_util.debug('derive_last_pd_to_cr: ' || '----- Parameters for ' ||
250: 'arp_trx_line_util.derive_last_pd_to_cr() ' || '-----' );
251: arp_util.debug('derive_last_pd_to_cr: ' || 'p_customer_trx_line_id = ' || p_customer_trx_line_id );
252: arp_util.debug('derive_last_pd_to_cr: ' || 'p_last_date_to_credit = ' || p_last_date_to_credit );
253: END IF;
254: RAISE;
255:
256: END derive_last_pd_to_cr;

Line 268: | arp_util.debug |

264: | |
265: | SCOPE - PUBLIC |
266: | |
267: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
268: | arp_util.debug |
269: | |
270: | ARGUMENTS : IN: |
271: | p_customer_trx_id |
272: | OUT: |

Line 289: arp_util.debug('arp_trx_line_util.get_default_line_num()+');

285:
286: BEGIN
287:
288: IF PG_DEBUG in ('Y', 'C') THEN
289: arp_util.debug('arp_trx_line_util.get_default_line_num()+');
290: END IF;
291:
292: SELECT nvl( max(line_number), 0 ) + 1
293: INTO p_line_number

Line 299: arp_util.debug('arp_trx_line_util.get_default_line_num()-');

295: WHERE customer_trx_id = p_customer_trx_id
296: AND line_type in ('LINE', 'CB', 'CHARGES');
297:
298: IF PG_DEBUG in ('Y', 'C') THEN
299: arp_util.debug('arp_trx_line_util.get_default_line_num()-');
300: END IF;
301:
302: EXCEPTION
303: WHEN OTHERS THEN

Line 305: arp_util.debug('EXCEPTION: arp_trx_line_util.get_default_line_num()');

301:
302: EXCEPTION
303: WHEN OTHERS THEN
304: IF PG_DEBUG in ('Y', 'C') THEN
305: arp_util.debug('EXCEPTION: arp_trx_line_util.get_default_line_num()');
306: arp_util.debug('get_default_line_num: ' ||
307: '---------- ' ||
308: 'Parameters for arp_trx_line_util.get_default_line_num() ' ||
309: '---------- ');

Line 306: arp_util.debug('get_default_line_num: ' ||

302: EXCEPTION
303: WHEN OTHERS THEN
304: IF PG_DEBUG in ('Y', 'C') THEN
305: arp_util.debug('EXCEPTION: arp_trx_line_util.get_default_line_num()');
306: arp_util.debug('get_default_line_num: ' ||
307: '---------- ' ||
308: 'Parameters for arp_trx_line_util.get_default_line_num() ' ||
309: '---------- ');
310: arp_util.debug('get_default_line_num: ' || 'p_customer_trx_id = ' || p_customer_trx_id);

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

306: arp_util.debug('get_default_line_num: ' ||
307: '---------- ' ||
308: 'Parameters for arp_trx_line_util.get_default_line_num() ' ||
309: '---------- ');
310: arp_util.debug('get_default_line_num: ' || 'p_customer_trx_id = ' || p_customer_trx_id);
311: END IF;
312:
313: RAISE;
314:

Line 327: | arp_util.debug |

323: | |
324: | SCOPE - PUBLIC |
325: | |
326: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
327: | arp_util.debug |
328: | |
329: | ARGUMENTS : IN: |
330: | p_inventory_item_id |
331: | p_organization_id |

Line 374: arp_util.debug('arp_trx_line_util.get_item_flex_defaults()+');

370:
371: BEGIN
372:
373: IF PG_DEBUG in ('Y', 'C') THEN
374: arp_util.debug('arp_trx_line_util.get_item_flex_defaults()+');
375: END IF;
376:
377: SELECT msi.description,
378: muom.uom_code,

Line 437: arp_util.debug('arp_trx_line_util.get_item_flex_defaults()-');

433: rr.occurrences,
434: rr.frequency;
435:
436: IF PG_DEBUG in ('Y', 'C') THEN
437: arp_util.debug('arp_trx_line_util.get_item_flex_defaults()-');
438: END IF;
439:
440: EXCEPTION
441: WHEN OTHERS THEN

Line 443: arp_util.debug('EXCEPTION: arp_trx_line_util.get_item_flex_defaults()');

439:
440: EXCEPTION
441: WHEN OTHERS THEN
442: IF PG_DEBUG in ('Y', 'C') THEN
443: arp_util.debug('EXCEPTION: arp_trx_line_util.get_item_flex_defaults()');
444: arp_util.debug('get_item_flex_defaults: ' ||
445: '---------- ' ||
446: 'Parameters for arp_trx_line_util.get_item_flex_defaults() ' ||
447: '---------- ');

Line 444: arp_util.debug('get_item_flex_defaults: ' ||

440: EXCEPTION
441: WHEN OTHERS THEN
442: IF PG_DEBUG in ('Y', 'C') THEN
443: arp_util.debug('EXCEPTION: arp_trx_line_util.get_item_flex_defaults()');
444: arp_util.debug('get_item_flex_defaults: ' ||
445: '---------- ' ||
446: 'Parameters for arp_trx_line_util.get_item_flex_defaults() ' ||
447: '---------- ');
448: arp_util.debug('get_item_flex_defaults: ' || 'p_inventory_item_id = ' || p_inventory_item_id);

Line 448: arp_util.debug('get_item_flex_defaults: ' || 'p_inventory_item_id = ' || p_inventory_item_id);

444: arp_util.debug('get_item_flex_defaults: ' ||
445: '---------- ' ||
446: 'Parameters for arp_trx_line_util.get_item_flex_defaults() ' ||
447: '---------- ');
448: arp_util.debug('get_item_flex_defaults: ' || 'p_inventory_item_id = ' || p_inventory_item_id);
449: arp_util.debug('get_item_flex_defaults: ' || 'p_organization_id = ' || p_organization_id );
450: arp_util.debug('get_item_flex_defaults: ' || 'p_trx_date = ' || p_trx_date );
451: arp_util.debug('get_item_flex_defaults: ' || 'p_invoicing_rule_id = ' || p_invoicing_rule_id );
452: END IF;

Line 449: arp_util.debug('get_item_flex_defaults: ' || 'p_organization_id = ' || p_organization_id );

445: '---------- ' ||
446: 'Parameters for arp_trx_line_util.get_item_flex_defaults() ' ||
447: '---------- ');
448: arp_util.debug('get_item_flex_defaults: ' || 'p_inventory_item_id = ' || p_inventory_item_id);
449: arp_util.debug('get_item_flex_defaults: ' || 'p_organization_id = ' || p_organization_id );
450: arp_util.debug('get_item_flex_defaults: ' || 'p_trx_date = ' || p_trx_date );
451: arp_util.debug('get_item_flex_defaults: ' || 'p_invoicing_rule_id = ' || p_invoicing_rule_id );
452: END IF;
453:

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

446: 'Parameters for arp_trx_line_util.get_item_flex_defaults() ' ||
447: '---------- ');
448: arp_util.debug('get_item_flex_defaults: ' || 'p_inventory_item_id = ' || p_inventory_item_id);
449: arp_util.debug('get_item_flex_defaults: ' || 'p_organization_id = ' || p_organization_id );
450: arp_util.debug('get_item_flex_defaults: ' || 'p_trx_date = ' || p_trx_date );
451: arp_util.debug('get_item_flex_defaults: ' || 'p_invoicing_rule_id = ' || p_invoicing_rule_id );
452: END IF;
453:
454: RAISE;

Line 451: arp_util.debug('get_item_flex_defaults: ' || 'p_invoicing_rule_id = ' || p_invoicing_rule_id );

447: '---------- ');
448: arp_util.debug('get_item_flex_defaults: ' || 'p_inventory_item_id = ' || p_inventory_item_id);
449: arp_util.debug('get_item_flex_defaults: ' || 'p_organization_id = ' || p_organization_id );
450: arp_util.debug('get_item_flex_defaults: ' || 'p_trx_date = ' || p_trx_date );
451: arp_util.debug('get_item_flex_defaults: ' || 'p_invoicing_rule_id = ' || p_invoicing_rule_id );
452: END IF;
453:
454: RAISE;
455:

Line 463: arp_util.debug('arp_trx_util_line.get_max_line_number(+)');

459: l_line_number NUMBER;
460:
461: BEGIN
462: IF PG_DEBUG in ('Y', 'C') THEN
463: arp_util.debug('arp_trx_util_line.get_max_line_number(+)');
464: END IF;
465:
466: ---
467: --- Get Maximum Line Number

Line 478: arp_util.debug('arp_trx_util_line.get_max_line_number(-)');

474: WHERE customer_trx_id = p_customer_trx_id
475: AND line_type IN ('LINE','CB','CHARGES');
476: p_line_number := l_line_number+1;
477: IF PG_DEBUG in ('Y', 'C') THEN
478: arp_util.debug('arp_trx_util_line.get_max_line_number(-)');
479: END IF;
480:
481: EXCEPTION
482: WHEN OTHERS

Line 485: arp_util.debug('EXCEPTION:arp_trx_util_line.get_max_line_number');

481: EXCEPTION
482: WHEN OTHERS
483: THEN
484: IF PG_DEBUG in ('Y', 'C') THEN
485: arp_util.debug('EXCEPTION:arp_trx_util_line.get_max_line_number');
486: END IF;
487: RAISE;
488: End get_max_line_number;
489:

Line 500: | arp_util.debug |

496: | |
497: | SCOPE - PUBLIC |
498: | |
499: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
500: | arp_util.debug |
501: | |
502: | ARGUMENTS : IN: |
503: | p_oe_line_id |
504: | p_interface_context |

Line 526: arp_util.debug('arp_trx_util_line.get_oe_header_id(+)');

522: l_oe_header_id NUMBER := null;
523:
524: BEGIN
525: IF PG_DEBUG in ('Y', 'C') THEN
526: arp_util.debug('arp_trx_util_line.get_oe_header_id(+)');
527: END IF;
528:
529: ---
530: --- Get OE Header Id

Line 543: arp_util.debug('arp_trx_util_line.get_oe_header_id(-)');

539: and rownum < 2;
540: END IF;
541:
542: IF PG_DEBUG in ('Y', 'C') THEN
543: arp_util.debug('arp_trx_util_line.get_oe_header_id(-)');
544: END IF;
545:
546: RETURN l_oe_header_id;
547:

Line 560: arp_util.debug('EXCEPTION:arp_trx_util_line.get_oe_header_id ');

556: RETURN l_oe_header_id;
557: WHEN OTHERS
558: THEN
559: IF PG_DEBUG in ('Y', 'C') THEN
560: arp_util.debug('EXCEPTION:arp_trx_util_line.get_oe_header_id ');
561: arp_util.debug('get_oe_header_id: ' || SQLERRM(SQLCODE));
562: END IF;
563: RAISE;
564: End get_oe_header_id;

Line 561: arp_util.debug('get_oe_header_id: ' || SQLERRM(SQLCODE));

557: WHEN OTHERS
558: THEN
559: IF PG_DEBUG in ('Y', 'C') THEN
560: arp_util.debug('EXCEPTION:arp_trx_util_line.get_oe_header_id ');
561: arp_util.debug('get_oe_header_id: ' || SQLERRM(SQLCODE));
562: END IF;
563: RAISE;
564: End get_oe_header_id;
565: