DBA Data[Home] [Help]

APPS.PO_NOTIFICATIONS_SV2 dependencies on PO_MESSAGE_S

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

35:
36: EXCEPTION
37: WHEN OTHERS THEN
38: -- dbms_output.put_line('Exception occurred in insert_into_po_notif');
39: PO_MESSAGE_S.SQL_ERROR('insert_into_po_notif', x_progress, sqlcode);
40: RAISE;
41: END;
42:
43: /*===========================================================================

Line 68: PO_MESSAGE_S.SQL_ERROR('UPDATE_FND_NOTIF', x_progress, sqlcode);

64:
65: EXCEPTION
66: WHEN OTHERS THEN
67: -- dbms_output.put_line('Exception occurred in update_fnd_notif');
68: PO_MESSAGE_S.SQL_ERROR('UPDATE_FND_NOTIF', x_progress, sqlcode);
69: RAISE;
70: END;
71:
72: /*===========================================================================

Line 93: PO_MESSAGE_S.SQL_ERROR('UPDATE_PO_NOTIF', x_progress, sqlcode);

89:
90: EXCEPTION
91: WHEN OTHERS THEN
92: -- dbms_output.put_line('Exception occurred in update_po_notif');
93: PO_MESSAGE_S.SQL_ERROR('UPDATE_PO_NOTIF', x_progress, sqlcode);
94: RAISE;
95: END;
96:
97: /*===========================================================================

Line 115: po_message_s.sql_error('delete_from_po_notif', x_progress, sqlcode);

111:
112: EXCEPTION
113: WHEN OTHERS THEN
114: -- dbms_output.put_line('Exception occurred in delete_from_po_notif');
115: po_message_s.sql_error('delete_from_po_notif', x_progress, sqlcode);
116: RAISE;
117: END;
118:
119: /*===========================================================================

Line 162: PO_MESSAGE_S.SQL_ERROR('GET_DOC_TYPE_SUBTYPE', x_progress, sqlcode);

158: x_type := 'RFQ';
159:
160: ELSE
161: x_progress := '030';
162: PO_MESSAGE_S.SQL_ERROR('GET_DOC_TYPE_SUBTYPE', x_progress, sqlcode);
163:
164: END IF;
165:
166: EXCEPTION

Line 169: PO_MESSAGE_S.SQL_ERROR('GET_DOC_TYPE_SUBTYPE', x_progress, sqlcode);

165:
166: EXCEPTION
167: WHEN OTHERS THEN
168: -- dbms_output.put_line('Exception occurred in get_doc_type_subtype');
169: PO_MESSAGE_S.SQL_ERROR('GET_DOC_TYPE_SUBTYPE', x_progress, sqlcode);
170: END;
171:
172: /*===========================================================================
173:

Line 237: PO_MESSAGE_S.SQL_ERROR('GET_FND_DOC_TYPE', x_progress, sqlcode);

233:
234: EXCEPTION
235: WHEN OTHERS THEN
236: -- dbms_output.put_line('cannot get fnd doc type');
237: PO_MESSAGE_S.SQL_ERROR('GET_FND_DOC_TYPE', x_progress, sqlcode);
238: RAISE;
239: END;
240:
241:

Line 279: PO_MESSAGE_S.SQL_ERROR('GET_FND_MESSAGE_NAME', x_progress, sqlcode);

275: x_new_message_name := x_old_message_name;
276:
277: ELSE
278: x_progress := '020';
279: PO_MESSAGE_S.SQL_ERROR('GET_FND_MESSAGE_NAME', x_progress, sqlcode);
280: END IF;
281:
282: EXCEPTION
283: WHEN OTHERS THEN

Line 285: PO_MESSAGE_S.SQL_ERROR('GET_FND_MESSAGE_NAME', x_progress, sqlcode);

281:
282: EXCEPTION
283: WHEN OTHERS THEN
284: -- dbms_output.put_line('In Exception');
285: PO_MESSAGE_S.SQL_ERROR('GET_FND_MESSAGE_NAME', x_progress, sqlcode);
286: END;
287:
288: /*===========================================================================
289:

Line 326: PO_MESSAGE_S.SQL_ERROR('INSERT_INTO_FND_NOTIF', x_progress, sqlcode);

322:
323: EXCEPTION
324: WHEN OTHERS THEN
325: -- dbms_output.put_line('Exception occurred in insert_into_fnd_notif');
326: PO_MESSAGE_S.SQL_ERROR('INSERT_INTO_FND_NOTIF', x_progress, sqlcode);
327: RAISE;
328: END;
329:
330: /*===========================================================================

Line 375: PO_MESSAGE_S.SQL_ERROR('INSTALL_FND_NOTIF', x_progress, sqlcode);

371:
372: EXCEPTION
373: WHEN OTHERS THEN
374: -- dbms_output.put_line('Exception in install_fnd_notif');
375: PO_MESSAGE_S.SQL_ERROR('INSTALL_FND_NOTIF', x_progress, sqlcode);
376: END;
377:
378: END po_notifications_sv2;