DBA Data[Home] [Help]

APPS.PO_REQ_DIST_SV dependencies on PO_MESSAGE_S

Line 33: po_message_s.sql_error('check_unique', x_progress, sqlcode);

29: WHEN NO_DATA_FOUND THEN
30: RETURN(TRUE);
31: WHEN OTHERS THEN
32: -- dbms_output.put_line('In Exception');
33: po_message_s.sql_error('check_unique', x_progress, sqlcode);
34: RAISE;
35: END check_unique;
36:
37:

Line 67: po_message_s.app_error('PO_RQ_LINE_NUM_ALREADY_EXISTS');

63:
64:
65: EXCEPTION
66: WHEN NO_DATA_FOUND THEN
67: po_message_s.app_error('PO_RQ_LINE_NUM_ALREADY_EXISTS');
68: RAISE;
69: WHEN OTHERS THEN
70: -- dbms_output.put_line('In Exception');
71: po_message_s.sql_error('check_unique_insert', x_progress, sqlcode);

Line 71: po_message_s.sql_error('check_unique_insert', x_progress, sqlcode);

67: po_message_s.app_error('PO_RQ_LINE_NUM_ALREADY_EXISTS');
68: RAISE;
69: WHEN OTHERS THEN
70: -- dbms_output.put_line('In Exception');
71: po_message_s.sql_error('check_unique_insert', x_progress, sqlcode);
72: RAISE;
73: END check_unique_insert;
74:
75:

Line 102: po_message_s.sql_error('get_max_dist_num', x_progress, sqlcode);

98:
99: EXCEPTION
100: WHEN OTHERS THEN
101: -- dbms_output.put_line('In Exception');
102: po_message_s.sql_error('get_max_dist_num', x_progress, sqlcode);
103: RAISE;
104: END get_max_dist_num;
105:
106:

Line 128: po_message_s.sql_error('select_summary', x_progress, sqlcode);

124:
125: EXCEPTION
126: WHEN OTHERS THEN
127: -- dbms_output.put_line('In Exception');
128: po_message_s.sql_error('select_summary', x_progress, sqlcode);
129: RAISE;
130: END select_summary;
131:
132:

Line 191: po_message_s.sql_error('update_reqs_distributions', X_progress, sqlcode);

187: ELSE
188: /* DEBUG - show error message */
189: X_req_control_error_rc := 'Y';
190: X_progress := '015';
191: po_message_s.sql_error('update_reqs_distributions', X_progress, sqlcode);
192: END IF;
193:
194:
195: -- dbms_output.put_line('Exit update_reqs_distributions');

Line 201: po_message_s.sql_error('update_reqs_distributions', X_progress, sqlcode);

197: EXCEPTION
198:
199: WHEN NO_DATA_FOUND THEN
200: X_req_control_error_rc := 'Y';
201: po_message_s.sql_error('update_reqs_distributions', X_progress, sqlcode);
202: RAISE;
203: WHEN OTHERS THEN
204: po_message_s.sql_error('update_reqs_distributions', X_progress, sqlcode);
205: RAISE;

Line 204: po_message_s.sql_error('update_reqs_distributions', X_progress, sqlcode);

200: X_req_control_error_rc := 'Y';
201: po_message_s.sql_error('update_reqs_distributions', X_progress, sqlcode);
202: RAISE;
203: WHEN OTHERS THEN
204: po_message_s.sql_error('update_reqs_distributions', X_progress, sqlcode);
205: RAISE;
206:
207: END update_reqs_distributions;
208:

Line 226: po_message.set_name('val_create_dist', x_progress, sqlcode);

222:
223:
224: EXCEPTION
225: WHEN OTHERS THEN
226: po_message.set_name('val_create_dist', x_progress, sqlcode);
227: RAISE;
228:
229: END val_create_dist;
230: */

Line 439: po_message_s.sql_error('create_dist_for_modify', x_progress, sqlcode);

435:
436:
437: EXCEPTION
438: WHEN OTHERS THEN
439: po_message_s.sql_error('create_dist_for_modify', x_progress, sqlcode);
440: raise;
441:
442: END create_dist_for_modify;
443: