APPS.PO_REQS_SV dependencies on PO_MESSAGE_S

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

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

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

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

Line 153: po_message_s.sql_error('update_reqs_header_status', X_progress, sqlcode);

149:
150: EXCEPTION
151: WHEN NO_DATA_FOUND THEN
152: X_req_control_error_rc := 'Y';
153: po_message_s.sql_error('update_reqs_header_status', X_progress, sqlcode);
154: RAISE;
155: WHEN OTHERS THEN
156: po_message_s.sql_error('update_reqs_header_status', X_progress, sqlcode);
157: RAISE;

Line 156: po_message_s.sql_error('update_reqs_header_status', X_progress, sqlcode);

152: X_req_control_error_rc := 'Y';
153: po_message_s.sql_error('update_reqs_header_status', X_progress, sqlcode);
154: RAISE;
155: WHEN OTHERS THEN
156: po_message_s.sql_error('update_reqs_header_status', X_progress, sqlcode);
157: RAISE;
158:
159: END update_reqs_header_status;
160:

Line 212: po_message_s.sql_error('get_req_encumbered', X_progress, sqlcode);

208:
209:
210: exception
211: when others then
212: po_message_s.sql_error('get_req_encumbered', X_progress, sqlcode);
213: raise;
214:
215: END get_req_encumbered;
216:

Line 244: po_message_s.app_error('PO_RQ_USE_LINE_DEL');

240: /* If the REQ is encumbered, it has to be cancelled */
241:
242: if X_encumbered then
243: X_allow_delete := FALSE;
244: po_message_s.app_error('PO_RQ_USE_LINE_DEL');
245: else
246: X_allow_delete := TRUE;
247: end if;
248:

Line 255: po_message_s.sql_error('val_req_delete', x_progress, sqlcode);

251:
252: EXCEPTION
253: when others then
254: X_allow_delete := FALSE;
255: po_message_s.sql_error('val_req_delete', x_progress, sqlcode);
256: raise;
257:
258: END val_req_delete;
259:

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

300:
301: EXCEPTION
302: WHEN OTHERS THEN
303: -- dbms_output.put_line('In exception');
304: po_message_s.sql_error('delete_children', x_progress, sqlcode);
305: raise;
306: END delete_children;
307:
308: /*===========================================================================

Line 429: po_message_s.sql_error('delete_req', x_progress, sqlcode);

425:
426: EXCEPTION
427: WHEN OTHERS THEN
428: -- dbms_output.put_line('In exception');
429: po_message_s.sql_error('delete_req', x_progress, sqlcode);
430: raise;
431: END delete_req;
432:
433: /*===========================================================================

Line 593: po_message_s.sql_error('insert_req', x_progress, sqlcode);

589:
590: EXCEPTION
591: WHEN OTHERS THEN
592: -- dbms_output.put_line('In exception');
593: po_message_s.sql_error('insert_req', x_progress, sqlcode);
594: raise;
595: END insert_req;
596:
597:

Line 622: po_message_s.sql_error('update_oe_flag', x_progress, sqlcode);

618:
619: EXCEPTION
620: WHEN OTHERS THEN
621: -- dbms_output.put_line('In exception');
622: po_message_s.sql_error('update_oe_flag', x_progress, sqlcode);
623: raise;
624: END update_oe_flag;
625:
626:

Line 658: po_message_s.sql_error('get_req_startup_values', x_progress, sqlcode);

654:
655: EXCEPTION
656: WHEN OTHERS THEN
657: -- dbms_output.put_line('In exception');
658: po_message_s.sql_error('get_req_startup_values', x_progress, sqlcode);
659: raise;
660: END get_req_startup_values;
661:
662: