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.POR_IFT_ADMIN_PKG dependencies on APP_EXCEPTION

Line 73: RAISE app_exception.application_exception;

69:
70: EXCEPTION
71: WHEN OTHERS THEN
72: po_message_s.sql_error('por_ift_admin_pkg.insert_template', l_progress, SQLCODE);
73: RAISE app_exception.application_exception;
74: END insert_template;
75:
76:
77: PROCEDURE lock_template(p_row_id IN VARCHAR2,

Line 110: app_exception.raise_exception;

106: IF (c_rec%NOTFOUND) THEN
107: l_progress := '003';
108: CLOSE c_rec;
109: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
110: app_exception.raise_exception;
111: END IF;
112: CLOSE c_rec;
113:
114: -- Note the use of NULL statements to handle possible

Line 121: app_exception.raise_exception;

117: IF (l_rec.template_code = p_template_code) THEN
118: NULL;
119: ELSE
120: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
121: app_exception.raise_exception;
122: END IF;
123:
124: l_progress := '005';
125: for tlinfo in c_tl_rec(p_template_code) loop

Line 132: app_exception.raise_exception;

128: then
129: null;
130: else
131: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
132: app_exception.raise_exception;
133: end if;
134: end if;
135: end loop;
136: EXCEPTION

Line 137: WHEN app_exception.application_exception THEN

133: end if;
134: end if;
135: end loop;
136: EXCEPTION
137: WHEN app_exception.application_exception THEN
138: RAISE;
139: WHEN OTHERS THEN
140: po_message_s.sql_error('por_ift_admin_pkg.lock_template', l_progress, SQLCODE);
141: RAISE app_exception.application_exception;

Line 141: RAISE app_exception.application_exception;

137: WHEN app_exception.application_exception THEN
138: RAISE;
139: WHEN OTHERS THEN
140: po_message_s.sql_error('por_ift_admin_pkg.lock_template', l_progress, SQLCODE);
141: RAISE app_exception.application_exception;
142: END lock_template;
143:
144: PROCEDURE update_template(p_row_id IN VARCHAR2,
145: p_template_code IN VARCHAR2,

Line 178: RAISE app_exception.application_exception;

174:
175: EXCEPTION
176: WHEN OTHERS THEN
177: po_message_s.sql_error('por_ift_admin_pkg.update_template', l_progress, SQLCODE);
178: RAISE app_exception.application_exception;
179: END update_template;
180:
181:
182: PROCEDURE delete_template(p_row_id IN VARCHAR2) IS

Line 221: RAISE app_exception.application_exception;

217:
218: EXCEPTION
219: WHEN OTHERS THEN
220: po_message_s.sql_error('por_ift_admin_pkg.delete_template', l_progress, SQLCODE);
221: RAISE app_exception.application_exception;
222: END delete_template;
223:
224:
225: PROCEDURE insert_template_attribute(p_template_code IN VARCHAR2,

Line 308: RAISE app_exception.application_exception;

304:
305: EXCEPTION
306: WHEN OTHERS THEN
307: po_message_s.sql_error('por_ift_admin_pkg.insert_template_attribute', l_progress, SQLCODE);
308: RAISE app_exception.application_exception;
309: END insert_template_attribute;
310:
311:
312: PROCEDURE lock_template_attribute(p_row_id IN VARCHAR2,

Line 356: app_exception.raise_exception;

352: IF (c_rec%NOTFOUND) THEN
353: l_progress := '003';
354: CLOSE c_rec;
355: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
356: app_exception.raise_exception;
357: END IF;
358: CLOSE c_rec;
359:
360: -- Note the use of NULL statements to handle possible

Line 367: app_exception.raise_exception;

363: IF (l_rec.template_code = p_template_code) THEN
364: NULL;
365: ELSE
366: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
367: app_exception.raise_exception;
368: END IF;
369: l_progress := '005';
370: IF (l_rec.sequence = p_display_sequence) THEN
371: NULL;

Line 374: app_exception.raise_exception;

370: IF (l_rec.sequence = p_display_sequence) THEN
371: NULL;
372: ELSE
373: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
374: app_exception.raise_exception;
375: END IF;
376: l_progress := '006';
377: IF (l_rec.attribute_code = p_attribute_code) THEN
378: NULL;

Line 381: app_exception.raise_exception;

377: IF (l_rec.attribute_code = p_attribute_code) THEN
378: NULL;
379: ELSE
380: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
381: app_exception.raise_exception;
382: END IF;
383:
384: l_progress := '007';
385: IF (l_rec.flex_value_set_id = p_flex_value_set_id) OR

Line 390: app_exception.raise_exception;

386: (l_rec.flex_value_set_id IS NULL AND p_flex_value_set_id IS NULL) THEN
387: NULL;
388: ELSE
389: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED4');
390: app_exception.raise_exception;
391: END IF;
392:
393: l_progress := '011';
394: IF (l_rec.required_flag = p_required_flag) OR

Line 399: app_exception.raise_exception;

395: (l_rec.required_flag IS NULL AND p_required_flag IS NULL) THEN
396: NULL;
397: ELSE
398: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED8');
399: app_exception.raise_exception;
400: END IF;
401:
402: l_progress := '012';
403: IF (l_rec.node_display_flag = p_node_display_flag) OR

Line 408: app_exception.raise_exception;

404: (l_rec.node_display_flag IS NULL AND p_node_display_flag IS NULL) THEN
405: NULL;
406: ELSE
407: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED9');
408: app_exception.raise_exception;
409: END IF;
410:
411: for tlinfo in c_tl_rec(p_attribute_code) loop
412: if (tlinfo.BASELANG = 'Y') then

Line 422: app_exception.raise_exception;

418: ) then
419: null;
420: else
421: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
422: app_exception.raise_exception;
423: end if;
424: end if;
425: end loop;
426: EXCEPTION

Line 427: WHEN app_exception.application_exception THEN

423: end if;
424: end if;
425: end loop;
426: EXCEPTION
427: WHEN app_exception.application_exception THEN
428: RAISE;
429: WHEN OTHERS THEN
430: po_message_s.sql_error('por_ift_admin_pkg.lock_template_attribute', l_progress, SQLCODE);
431: RAISE app_exception.application_exception;

Line 431: RAISE app_exception.application_exception;

427: WHEN app_exception.application_exception THEN
428: RAISE;
429: WHEN OTHERS THEN
430: po_message_s.sql_error('por_ift_admin_pkg.lock_template_attribute', l_progress, SQLCODE);
431: RAISE app_exception.application_exception;
432: END lock_template_attribute;
433:
434:
435: PROCEDURE update_template_attribute(p_row_id IN VARCHAR2,

Line 477: RAISE app_exception.application_exception;

473:
474: EXCEPTION
475: WHEN OTHERS THEN
476: po_message_s.sql_error('por_ift_admin_pkg.update_template_attribute', l_progress, SQLCODE);
477: RAISE app_exception.application_exception;
478: END update_template_attribute;
479:
480: PROCEDURE delete_template_attribute(p_row_id IN VARCHAR2) IS
481: l_progress VARCHAR2(10) := '000';

Line 502: RAISE app_exception.application_exception;

498:
499: EXCEPTION
500: WHEN OTHERS THEN
501: po_message_s.sql_error('por_ift_admin_pkg.delete_template_attribute', l_progress, SQLCODE);
502: RAISE app_exception.application_exception;
503: END delete_template_attribute;
504:
505: PROCEDURE insert_template_assoc(p_region_code IN VARCHAR2,
506: p_item_or_category_flag IN VARCHAR2,

Line 554: RAISE app_exception.application_exception;

550:
551: EXCEPTION
552: WHEN OTHERS THEN
553: po_message_s.sql_error('por_ift_admin_pkg.insert_template_assoc', l_progress, SQLCODE);
554: RAISE app_exception.application_exception;
555: END insert_template_assoc;
556:
557: PROCEDURE lock_template_assoc(p_row_id IN VARCHAR2,
558: p_template_assoc_id IN NUMBER,

Line 587: app_exception.raise_exception;

583: IF (c_rec%NOTFOUND) THEN
584: l_progress := '003';
585: CLOSE c_rec;
586: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
587: app_exception.raise_exception;
588: END IF;
589: CLOSE c_rec;
590:
591: -- Note the use of NULL statements to handle possible

Line 598: app_exception.raise_exception;

594: IF (l_rec.region_code = p_region_code) THEN
595: NULL;
596: ELSE
597: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
598: app_exception.raise_exception;
599: END IF;
600: l_progress := '005';
601: IF (l_rec.item_or_category_flag = p_item_or_category_flag) THEN
602: NULL;

Line 605: app_exception.raise_exception;

601: IF (l_rec.item_or_category_flag = p_item_or_category_flag) THEN
602: NULL;
603: ELSE
604: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
605: app_exception.raise_exception;
606: END IF;
607: l_progress := '006';
608: IF (l_rec.item_or_category_id = p_item_or_category_id) THEN
609: NULL;

Line 612: app_exception.raise_exception;

608: IF (l_rec.item_or_category_id = p_item_or_category_id) THEN
609: NULL;
610: ELSE
611: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
612: app_exception.raise_exception;
613: END IF;
614:
615: EXCEPTION
616: WHEN app_exception.application_exception THEN

Line 616: WHEN app_exception.application_exception THEN

612: app_exception.raise_exception;
613: END IF;
614:
615: EXCEPTION
616: WHEN app_exception.application_exception THEN
617: RAISE;
618: WHEN OTHERS THEN
619: po_message_s.sql_error('por_ift_admin_pkg.lock_template_assoc', l_progress, SQLCODE);
620: RAISE app_exception.application_exception;

Line 620: RAISE app_exception.application_exception;

616: WHEN app_exception.application_exception THEN
617: RAISE;
618: WHEN OTHERS THEN
619: po_message_s.sql_error('por_ift_admin_pkg.lock_template_assoc', l_progress, SQLCODE);
620: RAISE app_exception.application_exception;
621: END lock_template_assoc;
622:
623: PROCEDURE update_template_assoc(p_row_id IN VARCHAR2,
624: p_template_assoc_id IN NUMBER,

Line 647: RAISE app_exception.application_exception;

643:
644: EXCEPTION
645: WHEN OTHERS THEN
646: po_message_s.sql_error('por_ift_admin_pkg.update_template_assoc', l_progress, SQLCODE);
647: RAISE app_exception.application_exception;
648: END update_template_assoc;
649:
650:
651: PROCEDURE delete_template_assoc(p_row_id IN VARCHAR2) IS

Line 662: RAISE app_exception.application_exception;

658:
659: EXCEPTION
660: WHEN OTHERS THEN
661: po_message_s.sql_error('por_ift_admin_pkg.delete_template_assoc', l_progress, SQLCODE);
662: RAISE app_exception.application_exception;
663: END delete_template_assoc;
664:
665: PROCEDURE delete_all_template_assoc(p_region_code IN VARCHAR2) IS
666: l_progress VARCHAR2(10) := '000';

Line 676: RAISE app_exception.application_exception;

672:
673: EXCEPTION
674: WHEN OTHERS THEN
675: po_message_s.sql_error('por_ift_admin_pkg.delete_all_template_assoc', l_progress, SQLCODE);
676: RAISE app_exception.application_exception;
677: END delete_all_template_assoc;
678:
679: PROCEDURE add_language IS
680: BEGIN