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 223: arp_util.debug('arp_trx_line_util.derive_last_pd_to_cr()-');

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

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

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

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

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

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

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

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

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

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

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

Line 267: | arp_util.debug |

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

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

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

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

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

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

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

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

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

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

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

Line 326: | arp_util.debug |

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 499: | arp_util.debug |

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

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

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

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

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

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

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

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

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