DBA Data[Home] [Help]

APPS.POR_IFT_ADMIN_PKG dependencies on PO_MESSAGE_S

Line 72: po_message_s.sql_error('por_ift_admin_pkg.insert_template', l_progress, SQLCODE);

68: WHERE template_code = l_template_code;
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:

Line 140: po_message_s.sql_error('por_ift_admin_pkg.lock_template', l_progress, SQLCODE);

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;
142: END lock_template;
143:
144: PROCEDURE update_template(p_row_id IN VARCHAR2,

Line 177: po_message_s.sql_error('por_ift_admin_pkg.update_template', l_progress, SQLCODE);

173: AND USERENV('LANG') in (LANGUAGE, SOURCE_LANG);
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:

Line 220: po_message_s.sql_error('por_ift_admin_pkg.delete_template', l_progress, SQLCODE);

216: WHERE region_code = l_template_code;
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:

Line 307: po_message_s.sql_error('por_ift_admin_pkg.insert_template_attribute', l_progress, SQLCODE);

303: AND attribute_code = l_attribute_code;
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:

Line 430: po_message_s.sql_error('por_ift_admin_pkg.lock_template_attribute', l_progress, SQLCODE);

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;
432: END lock_template_attribute;
433:
434:

Line 476: po_message_s.sql_error('por_ift_admin_pkg.update_template_attribute', l_progress, SQLCODE);

472: AND USERENV('LANG') in (LANGUAGE, SOURCE_LANG);
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

Line 501: po_message_s.sql_error('por_ift_admin_pkg.delete_template_attribute', l_progress, SQLCODE);

497: WHERE attribute_code = l_attribute_code_old;
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,

Line 553: po_message_s.sql_error('por_ift_admin_pkg.insert_template_assoc', l_progress, SQLCODE);

549: WHERE template_assoc_id = l_template_assoc_id;
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,

Line 619: po_message_s.sql_error('por_ift_admin_pkg.lock_template_assoc', l_progress, SQLCODE);

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;
621: END lock_template_assoc;
622:
623: PROCEDURE update_template_assoc(p_row_id IN VARCHAR2,

Line 646: po_message_s.sql_error('por_ift_admin_pkg.update_template_assoc', l_progress, SQLCODE);

642: WHERE rowid = p_row_id;
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:

Line 661: po_message_s.sql_error('por_ift_admin_pkg.delete_template_assoc', l_progress, SQLCODE);

657: WHERE rowid = p_row_id;
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

Line 675: po_message_s.sql_error('por_ift_admin_pkg.delete_all_template_assoc', l_progress, SQLCODE);

671: WHERE region_code = p_region_code;
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