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_FREIGHT dependencies on ARP_PROCESS_FREIGHT

Line 1: PACKAGE BODY ARP_PROCESS_FREIGHT AS

1: PACKAGE BODY ARP_PROCESS_FREIGHT AS
2: /* $Header: ARTEFRTB.pls 120.6.12010000.1 2008/07/24 16:55:59 appldev ship $ */
3:
4: pg_number_dummy number;
5: pg_date_dummy date;

Line 48: arp_util.debug('arp_process_freight.check_frt_line_count()+');

44: l_frt_count number;
45:
46: BEGIN
47:
48: arp_util.debug('arp_process_freight.check_frt_line_count()+');
49:
50: SELECT count(*)
51: INTO l_frt_count
52: FROM ra_customer_trx_lines ctl

Line 79: arp_util.debug('arp_process_freight.check_frt_line_count()-');

75: fnd_message.set_name('AR', 'AR_RAXTRX-1699');
76: app_exception.raise_exception;
77: END IF;
78:
79: arp_util.debug('arp_process_freight.check_frt_line_count()-');
80:
81: EXCEPTION
82: WHEN OTHERS THEN
83: arp_util.debug('EXCEPTION: arp_process_freight.check_frt_line_count()');

Line 83: arp_util.debug('EXCEPTION: arp_process_freight.check_frt_line_count()');

79: arp_util.debug('arp_process_freight.check_frt_line_count()-');
80:
81: EXCEPTION
82: WHEN OTHERS THEN
83: arp_util.debug('EXCEPTION: arp_process_freight.check_frt_line_count()');
84:
85: arp_ctl_pkg.display_line_rec(p_frt_rec);
86:
87: RAISE;

Line 123: arp_util.debug('arp_process_freight.validate_insert_freight()+');

119: IS
120:
121: BEGIN
122:
123: arp_util.debug('arp_process_freight.validate_insert_freight()+');
124:
125: -- check if freight is not defined at both header and line level
126: -- if multiple freight lines are being defined at header
127: -- or for each line

Line 128: arp_process_freight.check_frt_line_count(p_frt_rec);

124:
125: -- check if freight is not defined at both header and line level
126: -- if multiple freight lines are being defined at header
127: -- or for each line
128: arp_process_freight.check_frt_line_count(p_frt_rec);
129:
130: -- other possible checks
131: -- over-application for CMs
132: -- freight allowed flag on transaction type

Line 134: arp_util.debug('arp_process_freight.validate_insert_freight()-');

130: -- other possible checks
131: -- over-application for CMs
132: -- freight allowed flag on transaction type
133:
134: arp_util.debug('arp_process_freight.validate_insert_freight()-');
135:
136: EXCEPTION
137: WHEN OTHERS THEN
138: arp_util.debug('EXCEPTION: arp_process_freight.validate_insert_freight()');

Line 138: arp_util.debug('EXCEPTION: arp_process_freight.validate_insert_freight()');

134: arp_util.debug('arp_process_freight.validate_insert_freight()-');
135:
136: EXCEPTION
137: WHEN OTHERS THEN
138: arp_util.debug('EXCEPTION: arp_process_freight.validate_insert_freight()');
139: RAISE;
140: END;
141:
142: /*===========================================================================+

Line 174: arp_util.debug('arp_process_freight.validate_update_freight()+');

170: IS
171:
172: BEGIN
173:
174: arp_util.debug('arp_process_freight.validate_update_freight()+');
175:
176: arp_util.debug('arp_process_freight.validate_update_freight()-');
177:
178: EXCEPTION

Line 176: arp_util.debug('arp_process_freight.validate_update_freight()-');

172: BEGIN
173:
174: arp_util.debug('arp_process_freight.validate_update_freight()+');
175:
176: arp_util.debug('arp_process_freight.validate_update_freight()-');
177:
178: EXCEPTION
179: WHEN OTHERS THEN
180: arp_util.debug('EXCEPTION: arp_process_freight.validate_update_freight()');

Line 180: arp_util.debug('EXCEPTION: arp_process_freight.validate_update_freight()');

176: arp_util.debug('arp_process_freight.validate_update_freight()-');
177:
178: EXCEPTION
179: WHEN OTHERS THEN
180: arp_util.debug('EXCEPTION: arp_process_freight.validate_update_freight()');
181: RAISE;
182:
183: END;
184:

Line 223: arp_util.debug('arp_process_freight.validate_delete_freight()+');

219: IS
220:
221: BEGIN
222:
223: arp_util.debug('arp_process_freight.validate_delete_freight()+');
224:
225: IF (p_complete_flag = 'Y')
226: THEN
227: -- ensure that this is not the last line to be deleted

Line 231: arp_util.debug('arp_process_freight.validate_delete_freight()-');

227: -- ensure that this is not the last line to be deleted
228: arp_trx_validate.check_has_one_line(p_customer_trx_id);
229: END IF;
230:
231: arp_util.debug('arp_process_freight.validate_delete_freight()-');
232:
233: EXCEPTION
234: WHEN OTHERS THEN
235: arp_util.debug('EXCEPTION: arp_process_freight.validate_delete_freight()');

Line 235: arp_util.debug('EXCEPTION: arp_process_freight.validate_delete_freight()');

231: arp_util.debug('arp_process_freight.validate_delete_freight()-');
232:
233: EXCEPTION
234: WHEN OTHERS THEN
235: arp_util.debug('EXCEPTION: arp_process_freight.validate_delete_freight()');
236: RAISE;
237:
238: END;
239:

Line 286: arp_util.debug('arp_process_freight.set_flags()+');

282: l_old_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
283: l_old_ccid ra_cust_trx_line_gl_dist.code_combination_id%type;
284:
285: BEGIN
286: arp_util.debug('arp_process_freight.set_flags()+');
287:
288: arp_ctl_pkg.fetch_p(l_old_frt_rec, p_customer_trx_line_id);
289:
290: IF ((p_new_frt_rec.extended_amount <> l_old_frt_rec.extended_amount)

Line 322: arp_util.debug('arp_process_freight.set_flags()-');

318: ELSE
319: p_gl_date_changed_flag := FALSE;
320: END IF;
321:
322: arp_util.debug('arp_process_freight.set_flags()-');
323:
324: EXCEPTION
325: WHEN OTHERS THEN
326: arp_util.debug('arp_process_freight.set_flags()');

Line 326: arp_util.debug('arp_process_freight.set_flags()');

322: arp_util.debug('arp_process_freight.set_flags()-');
323:
324: EXCEPTION
325: WHEN OTHERS THEN
326: arp_util.debug('arp_process_freight.set_flags()');
327: arp_util.debug('customer_trx_line_id : '||
328: p_new_frt_rec.customer_trx_line_id);
329: arp_util.debug('p_new_ccid : '||p_new_ccid);
330: arp_util.debug('p_new_gl_date : '||p_new_gl_date);

Line 399: arp_util.debug('arp_process_freight.insert_freight()+');

395: l_dist_count NUMBER;
396:
397: BEGIN
398:
399: arp_util.debug('arp_process_freight.insert_freight()+');
400:
401: p_status := 'OK';
402:
403: -- check form version to determine IF it is compatible with the

Line 416: arp_process_freight.validate_insert_freight(p_frt_rec);

412: --
413:
414: -- do validation
415:
416: arp_process_freight.validate_insert_freight(p_frt_rec);
417:
418: /*--------------------+
419: | pre-insert logic |
420: +--------------------*/

Line 494: arp_util.debug('arp_process_freight.insert_freight()-');

490:
491: --
492: -- The payment schedule record will be updated in the post-commit logic
493: --
494: arp_util.debug('arp_process_freight.insert_freight()-');
495:
496: EXCEPTION
497: when OTHERS THEN
498: -- display all relevent information

Line 499: arp_util.debug('EXCEPTION: arp_process_freight.insert_freight()');

495:
496: EXCEPTION
497: when OTHERS THEN
498: -- display all relevent information
499: arp_util.debug('EXCEPTION: arp_process_freight.insert_freight()');
500: arp_util.debug(' p_form_name : '||p_form_name );
501: arp_util.debug(' p_form_version : '||p_form_version);
502: arp_util.debug(' p_trx_class : '||p_trx_class);
503: arp_util.debug(' p_gl_date : '||p_gl_date);

Line 570: arp_util.debug('arp_process_freight.update_freight()+');

566: l_dist_count NUMBER;
567:
568:
569: BEGIN
570: arp_util.debug('arp_process_freight.update_freight()+');
571:
572: -- check form version to determine IF it is compatible with the
573: -- entity handler.
574: arp_trx_validate.ar_entity_version_check(p_form_name, p_form_version);

Line 594: arp_process_freight.validate_update_freight(p_frt_rec);

590:
591:
592: -- do validation
593:
594: arp_process_freight.validate_update_freight(p_frt_rec);
595:
596: /*--------------------+
597: | pre-update logic |
598: +--------------------*/

Line 600: arp_process_freight.set_flags(p_customer_trx_line_id,

596: /*--------------------+
597: | pre-update logic |
598: +--------------------*/
599: -- none
600: arp_process_freight.set_flags(p_customer_trx_line_id,
601: p_frt_rec,
602: p_frt_ccid,
603: p_gl_date,
604: l_amount_changed_flag,

Line 661: arp_util.debug('arp_process_freight.update_freight()-');

657: APP_EXCEPTION.raise_exception;
658: END IF;
659:
660:
661: arp_util.debug('arp_process_freight.update_freight()-');
662:
663:
664: EXCEPTION
665: WHEN OTHERS THEN

Line 667: arp_util.debug('EXCEPTION: arp_process_freight.update_freight()');

663:
664: EXCEPTION
665: WHEN OTHERS THEN
666: -- display all relevent information
667: arp_util.debug('EXCEPTION: arp_process_freight.update_freight()');
668: arp_util.debug('p_form_name : '||p_form_name );
669: arp_util.debug('p_form_version : '||p_form_version);
670: arp_util.debug('p_frt_ccid : '||p_frt_ccid);
671: arp_util.debug('p_gl_date : '||p_gl_date);

Line 732: arp_util.debug('arp_process_freight.delete_freight()+');

728: l_dist_count NUMBER;
729:
730: BEGIN
731:
732: arp_util.debug('arp_process_freight.delete_freight()+');
733:
734: --
735: -- check form version to determine IF it is compatible with the
736: -- entity handler.

Line 744: arp_process_freight.validate_delete_freight(p_customer_trx_id,

740: -- Lock rows in other tables that reference this customer_trx_id
741: arp_trx_util.lock_transaction(p_customer_trx_id);
742:
743: -- do validation
744: arp_process_freight.validate_delete_freight(p_customer_trx_id,
745: p_customer_trx_line_id,
746: p_complete_flag);
747:
748: /*--------------------+

Line 783: arp_util.debug('arp_process_freight.delete_freight()-');

779: fnd_message.set_name('AR', 'AR_PLCRE_FHLR_CCID');
780: APP_EXCEPTION.raise_exception;
781: END IF;
782:
783: arp_util.debug('arp_process_freight.delete_freight()-');
784:
785: EXCEPTION
786:
787: WHEN OTHERS THEN

Line 789: arp_util.debug('EXCEPTION: ARP_PROCESS_FREIGHT.delete_freight()');

785: EXCEPTION
786:
787: WHEN OTHERS THEN
788: -- display all relevent information
789: arp_util.debug('EXCEPTION: ARP_PROCESS_FREIGHT.delete_freight()');
790: arp_util.debug('p_form_name : '||p_form_name );
791: arp_util.debug('p_form_version : '||p_form_version);
792: arp_util.debug('p_customer_trx_id : '||p_customer_trx_id);
793: arp_util.debug('p_customer_trx_line_id : '||p_customer_trx_line_id);

Line 814: END ARP_PROCESS_FREIGHT;

810: END init;
811:
812: BEGIN
813: init;
814: END ARP_PROCESS_FREIGHT;