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 147: po_message_s.sql_error('update_reqs_header_status', X_progress, sqlcode);

143:
144: EXCEPTION
145: WHEN NO_DATA_FOUND THEN
146: X_req_control_error_rc := 'Y';
147: po_message_s.sql_error('update_reqs_header_status', X_progress, sqlcode);
148: RAISE;
149: WHEN OTHERS THEN
150: po_message_s.sql_error('update_reqs_header_status', X_progress, sqlcode);
151: RAISE;

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

146: X_req_control_error_rc := 'Y';
147: po_message_s.sql_error('update_reqs_header_status', X_progress, sqlcode);
148: RAISE;
149: WHEN OTHERS THEN
150: po_message_s.sql_error('update_reqs_header_status', X_progress, sqlcode);
151: RAISE;
152:
153: END update_reqs_header_status;
154:

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

202:
203:
204: exception
205: when others then
206: po_message_s.sql_error('get_req_encumbered', X_progress, sqlcode);
207: raise;
208:
209: END get_req_encumbered;
210:

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

234: /* If the REQ is encumbered, it has to be cancelled */
235:
236: if X_encumbered then
237: X_allow_delete := FALSE;
238: po_message_s.app_error('PO_RQ_USE_LINE_DEL');
239: else
240: X_allow_delete := TRUE;
241: end if;
242:

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

245:
246: EXCEPTION
247: when others then
248: X_allow_delete := FALSE;
249: po_message_s.sql_error('val_req_delete', x_progress, sqlcode);
250: raise;
251:
252: END val_req_delete;
253:

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

294:
295: EXCEPTION
296: WHEN OTHERS THEN
297: -- dbms_output.put_line('In exception');
298: po_message_s.sql_error('delete_children', x_progress, sqlcode);
299: raise;
300: END delete_children;
301:
302: /*===========================================================================

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

417:
418: EXCEPTION
419: WHEN OTHERS THEN
420: -- dbms_output.put_line('In exception');
421: po_message_s.sql_error('delete_req', x_progress, sqlcode);
422: raise;
423: END delete_req;
424:
425: /*===========================================================================

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

581:
582: EXCEPTION
583: WHEN OTHERS THEN
584: -- dbms_output.put_line('In exception');
585: po_message_s.sql_error('insert_req', x_progress, sqlcode);
586: raise;
587: END insert_req;
588:
589:

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

610:
611: EXCEPTION
612: WHEN OTHERS THEN
613: -- dbms_output.put_line('In exception');
614: po_message_s.sql_error('update_oe_flag', x_progress, sqlcode);
615: raise;
616: END update_oe_flag;
617:
618:

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

646:
647: EXCEPTION
648: WHEN OTHERS THEN
649: -- dbms_output.put_line('In exception');
650: po_message_s.sql_error('get_req_startup_values', x_progress, sqlcode);
651: raise;
652: END get_req_startup_values;
653:
654: