DBA Data[Home] [Help]

APPS.PO_HEADERS_SV1 dependencies on PO_MESSAGE_S

Line 39: po_message_s.app_error ('PO_ALL_CANNOT_RESERVE_RECORD');

35: CLOSE C;
36:
37: EXCEPTION
38: WHEN app_exception.record_lock_exception THEN
39: po_message_s.app_error ('PO_ALL_CANNOT_RESERVE_RECORD');
40:
41: WHEN OTHERS THEN
42: --dbms_output.put_line('In Exception');
43: PO_MESSAGE_S.SQL_ERROR('LOCK_ROW_FOR_STATUS_UPDATE', x_progress, sqlcode);

Line 43: PO_MESSAGE_S.SQL_ERROR('LOCK_ROW_FOR_STATUS_UPDATE', x_progress, sqlcode);

39: po_message_s.app_error ('PO_ALL_CANNOT_RESERVE_RECORD');
40:
41: WHEN OTHERS THEN
42: --dbms_output.put_line('In Exception');
43: PO_MESSAGE_S.SQL_ERROR('LOCK_ROW_FOR_STATUS_UPDATE', x_progress, sqlcode);
44: RAISE;
45: END;
46:
47: /*===========================================================================

Line 62: po_message.set_name('val_po_encumbered', x_progress, sqlcode);

58:
59:
60: EXCEPTION
61: WHEN OTHERS THEN
62: po_message.set_name('val_po_encumbered', x_progress, sqlcode);
63: RAISE;
64:
65: END val_po_encumbered; */
66:

Line 82: po_message_s.sql_error('get_doc_num', x_progress, sqlcode);

78:
79:
80: EXCEPTION
81: WHEN OTHERS THEN
82: po_message_s.sql_error('get_doc_num', x_progress, sqlcode);
83: RAISE;
84:
85: END get_doc_num; */
86:

Line 117: po_message_s.app_error('PO_PO_USE_CANCEL_ON_ENCUMB_PO');

113: /* If the PO is encumbered, it has to be cancelled */
114:
115: if X_encumbered then
116: X_allow_delete := FALSE;
117: po_message_s.app_error('PO_PO_USE_CANCEL_ON_ENCUMB_PO');
118: else
119: X_allow_delete := TRUE;
120: end if;
121:

Line 141: po_message_s.sql_error('val_delete', x_progress, sqlcode);

137:
138: EXCEPTION
139: when others then
140: X_allow_delete := FALSE;
141: po_message_s.sql_error('val_delete', x_progress, sqlcode);
142: raise;
143:
144: END val_delete;
145:

Line 197: po_message_s.sql_error('get_po_encumbered', X_progress, sqlcode);

193:
194:
195: exception
196: when others then
197: po_message_s.sql_error('get_po_encumbered', X_progress, sqlcode);
198: raise;
199:
200: END get_po_encumbered;
201:

Line 334: po_message_s.sql_error('delete_children', x_progress, sqlcode);

330:
331: EXCEPTION
332:
333: when others then
334: po_message_s.sql_error('delete_children', x_progress, sqlcode);
335: raise;
336:
337: END delete_children;
338:

Line 462: po_message_s.app_error('PO_ALL_RECORDS_NOT_FOUND');

458: end if;
459:
460: EXCEPTION
461: WHEN NO_DATA_FOUND THEN
462: po_message_s.app_error('PO_ALL_RECORDS_NOT_FOUND');
463: RETURN (FALSE);
464: RAISE;
465: when others then
466: po_message_s.sql_error('delete_po', x_progress, sqlcode);

Line 466: po_message_s.sql_error('delete_po', x_progress, sqlcode);

462: po_message_s.app_error('PO_ALL_RECORDS_NOT_FOUND');
463: RETURN (FALSE);
464: RAISE;
465: when others then
466: po_message_s.sql_error('delete_po', x_progress, sqlcode);
467: raise;
468:
469: END delete_po;
470:

Line 519: po_message_s.sql_error('delete_po', x_progress, sqlcode);

515: null;
516:
517: when others then
518:
519: po_message_s.sql_error('delete_po', x_progress, sqlcode);
520: raise;
521:
522: END delete_this_release;
523:

Line 544: po_message_s.sql_error('insert_children', x_progress, sqlcode);

540:
541:
542: EXCEPTION
543: WHEN OTHERS THEN
544: po_message_s.sql_error('insert_children', x_progress, sqlcode);
545: RAISE;
546:
547: END insert_children; */
548: