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

Line 20: | arp_util.debug |

16: | SCOPE - PRIVATE |
17: | |
18: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
19: | dbms_sql.bind_variable |
20: | arp_util.debug |
21: | |
22: | ARGUMENTS : IN: |
23: | p_form_name |
24: | p_form_version |

Line 51: arp_util.debug('arp_process_header.delete_transaction()+');

47:
48:
49: BEGIN
50:
51: arp_util.debug('arp_process_header.delete_transaction()+');
52:
53: -- check form version to determine if it is compatible with the
54: -- entity handler.
55: -- arp_trx_validate.ar_entity_version_check(p_form_name, p_form_version);

Line 76: arp_util.debug('arp_process_header.delete_transaction()-');

72: -- Bugfix 2217253. Uncommented the line below
73: arp_app_pkg.delete_f_ct_id(p_customer_trx_id);
74:
75:
76: arp_util.debug('arp_process_header.delete_transaction()-');
77:
78: EXCEPTION
79: WHEN OTHERS THEN
80: arp_util.debug('EXCEPTION: arp_process_header.delete_transaction()');

Line 80: arp_util.debug('EXCEPTION: arp_process_header.delete_transaction()');

76: arp_util.debug('arp_process_header.delete_transaction()-');
77:
78: EXCEPTION
79: WHEN OTHERS THEN
80: arp_util.debug('EXCEPTION: arp_process_header.delete_transaction()');
81: rollback to savepoint ar_delete_transaction_1;
82: RAISE;
83:
84: END;

Line 98: | arp_util.debug |

94: | SCOPE - PRIVATE |
95: | |
96: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
97: | dbms_sql.bind_variable |
98: | arp_util.debug |
99: | |
100: | ARGUMENTS : IN: |
101: | p_form_name |
102: | p_form_version |

Line 122: arp_util.debug('arp_trx_util.lock_transaction()+');

118:
119:
120: BEGIN
121:
122: arp_util.debug('arp_trx_util.lock_transaction()+');
123:
124: -- check form version to determine if it is compatible with the
125: -- entity handler.
126: -- arp_trx_validate.ar_entity_version_check(p_form_name, p_form_version);

Line 139: arp_util.debug('arp_trx_util.lock_transaction()-');

135: arp_ps_pkg.lock_f_ct_id(p_customer_trx_id);
136: arp_adjustments_pkg.lock_f_ct_id(p_customer_trx_id);
137:
138:
139: arp_util.debug('arp_trx_util.lock_transaction()-');
140:
141: EXCEPTION
142: WHEN OTHERS THEN
143: arp_util.debug('EXCEPTION: arp_trx_util.delete_lock()');

Line 143: arp_util.debug('EXCEPTION: arp_trx_util.delete_lock()');

139: arp_util.debug('arp_trx_util.lock_transaction()-');
140:
141: EXCEPTION
142: WHEN OTHERS THEN
143: arp_util.debug('EXCEPTION: arp_trx_util.delete_lock()');
144: rollback to savepoint ar_lock_transaction_1;
145: RAISE;
146:
147: END;

Line 161: | arp_util.debug |

157: | SCOPE - PRIVATE |
158: | |
159: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
160: | dbms_sql.bind_variable |
161: | arp_util.debug |
162: | |
163: | ARGUMENTS : IN: |
164: | p_form_name |
165: | p_form_version |

Line 191: arp_util.debug('arp_trx_util.set_term_in_use_flag()+');

187:
188:
189: BEGIN
190:
191: arp_util.debug('arp_trx_util.set_term_in_use_flag()+');
192:
193: -- check form version to determine if it is compatible with the
194: -- entity handler.
195: -- arp_trx_validate.ar_entity_version_check(p_form_name, p_form_version);

Line 202: arp_util.debug('setting the in_use flag for term ' || p_term_id ||

198:
199:
200: IF (NVL(p_term_in_use_flag, 'N') = 'N')
201: THEN
202: arp_util.debug('setting the in_use flag for term ' || p_term_id ||
203: ' to Y.');
204:
205: UPDATE ra_terms_b
206: SET in_use = 'Y'

Line 211: arp_util.debug('arp_trx_util.set_term_in_use_flag()-');

207: WHERE term_id = p_term_id
208: AND in_use = 'N';
209: END IF;
210:
211: arp_util.debug('arp_trx_util.set_term_in_use_flag()-');
212:
213: EXCEPTION
214: WHEN NO_DATA_FOUND THEN
215: null;

Line 217: arp_util.debug('EXCEPTION: arp_trx_util.set_term_in_use_flag()');

213: EXCEPTION
214: WHEN NO_DATA_FOUND THEN
215: null;
216: WHEN OTHERS THEN
217: arp_util.debug('EXCEPTION: arp_trx_util.set_term_in_use_flag()');
218: RAISE;
219:
220: END;
221:

Line 233: | arp_util.debug |

229: | |
230: | SCOPE - PRIVATE |
231: | |
232: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
233: | arp_util.debug |
234: | |
235: | ARGUMENTS : IN: |
236: | p_customer_trx_id |
237: | OUT: |

Line 257: arp_util.debug('arp_trx_util.set_posted_flag()+');

253: l_posted_flag varchar2(2);
254:
255: BEGIN
256:
257: arp_util.debug('arp_trx_util.set_posted_flag()+');
258:
259: SELECT decode(max(dummy),
260: NULL, 'N',
261: 'Y')

Line 278: arp_util.debug('arp_trx_util.set_posted_flag()-');

274: THEN p_posted_flag := TRUE;
275: ELSE p_posted_flag := FALSE;
276: END IF;
277:
278: arp_util.debug('arp_trx_util.set_posted_flag()-');
279:
280: EXCEPTION
281: WHEN OTHERS THEN
282: arp_util.debug('EXCEPTION: arp_trx_util.set_posted_flag()');

Line 282: arp_util.debug('EXCEPTION: arp_trx_util.set_posted_flag()');

278: arp_util.debug('arp_trx_util.set_posted_flag()-');
279:
280: EXCEPTION
281: WHEN OTHERS THEN
282: arp_util.debug('EXCEPTION: arp_trx_util.set_posted_flag()');
283: RAISE;
284:
285: END;
286:

Line 297: | arp_util.debug |

293: | |
294: | SCOPE - PRIVATE |
295: | |
296: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
297: | arp_util.debug |
298: | |
299: | ARGUMENTS : IN: |
300: | p_boolean |
301: | OUT: |

Line 329: arp_util.debug('EXCEPTION: arp_trx_util.boolean_to_varchar2()');

325: return(l_result);
326:
327: EXCEPTION
328: WHEN OTHERS THEN
329: arp_util.debug('EXCEPTION: arp_trx_util.boolean_to_varchar2()');
330: RAISE;
331:
332: END;
333:

Line 348: | arp_util.debug |

344: | |
345: | SCOPE - PUBLIC |
346: | |
347: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
348: | arp_util.debug |
349: | |
350: | ARGUMENTS : IN: |
351: | p_customer_trx_id |
352: | OUT: |

Line 374: arp_util.debug('arp_trx_util.detect_freight_only_rules_case()+');

370:
371: l_result varchar2(2);
372:
373: BEGIN
374: arp_util.debug('arp_trx_util.detect_freight_only_rules_case()+');
375:
376:
377: SELECT DECODE( MAX(t.customer_trx_id),
378: NULL, 'N',

Line 399: arp_util.debug('arp_trx_util.detect_freight_only_rules_case()-');

395: RETURN(TRUE);
396: ELSE RETURN FALSE;
397: END IF;
398:
399: arp_util.debug('arp_trx_util.detect_freight_only_rules_case()-');
400:
401: EXCEPTION
402: WHEN OTHERS THEN
403: arp_util.debug('EXCEPTION: arp_trx_util.detect_freight_only_rules_case()');

Line 403: arp_util.debug('EXCEPTION: arp_trx_util.detect_freight_only_rules_case()');

399: arp_util.debug('arp_trx_util.detect_freight_only_rules_case()-');
400:
401: EXCEPTION
402: WHEN OTHERS THEN
403: arp_util.debug('EXCEPTION: arp_trx_util.detect_freight_only_rules_case()');
404: RAISE;
405:
406: END;
407:

Line 419: | arp_util.debug |

415: | |
416: | SCOPE - PUBLIC |
417: | |
418: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
419: | arp_util.debug |
420: | |
421: | ARGUMENTS : IN: |
422: | p_customer_trx_id - identifies the transaction |
423: | p_open_receivables_flag |

Line 531: arp_util.debug('arp_trx_util.transaction_balances()+');

527: ) IS
528:
529:
530: BEGIN
531: arp_util.debug('arp_trx_util.transaction_balances()+');
532:
533: arp_bal_util.transaction_balances(
534: p_customer_trx_id,
535: p_open_receivables_flag,

Line 610: arp_util.debug('arp_trx_util.transaction_balances()-');

606: );
607:
608:
609:
610: arp_util.debug('arp_trx_util.transaction_balances()-');
611:
612: EXCEPTION
613: WHEN OTHERS THEN
614: arp_util.debug('EXCEPTION: arp_trx_util.transaction_balances()');

Line 614: arp_util.debug('EXCEPTION: arp_trx_util.transaction_balances()');

610: arp_util.debug('arp_trx_util.transaction_balances()-');
611:
612: EXCEPTION
613: WHEN OTHERS THEN
614: arp_util.debug('EXCEPTION: arp_trx_util.transaction_balances()');
615: RAISE;
616:
617: END;
618:

Line 632: | arp_util.debug |

628: | |
629: | SCOPE - PUBLIC |
630: | |
631: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
632: | arp_util.debug |
633: | |
634: | ARGUMENTS : IN: |
635: | p_customer_trx_id |
636: | p_open_receivables_flag |

Line 678: arp_util.debug('arp_trx_util.get_summary_trx_balances()+');

674: l_dummy NUMBER;
675:
676:
677: BEGIN
678: arp_util.debug('arp_trx_util.get_summary_trx_balances()+');
679:
680: arp_bal_util.get_summary_trx_balances( p_customer_trx_id,
681: p_open_receivables_flag,
682: p_line_original,

Line 693: arp_util.debug('arp_trx_util.get_summary_trx_balances()-');

689: p_charges_remaining,
690: p_total_original,
691: p_total_remaining );
692:
693: arp_util.debug('arp_trx_util.get_summary_trx_balances()-');
694:
695: EXCEPTION
696: WHEN OTHERS THEN
697: arp_util.debug('EXCEPTION: arp_trx_util.get_summary_trx_balances()');

Line 697: arp_util.debug('EXCEPTION: arp_trx_util.get_summary_trx_balances()');

693: arp_util.debug('arp_trx_util.get_summary_trx_balances()-');
694:
695: EXCEPTION
696: WHEN OTHERS THEN
697: arp_util.debug('EXCEPTION: arp_trx_util.get_summary_trx_balances()');
698: RAISE;
699:
700: END;
701: