DBA Data[Home] [Help]

APPS.PO_EMPLOYEES_SV dependencies on PO_MESSAGE_S

Line 72: -- po_message_s.app_error('PO_ALL_SQL_ERROR');

68:
69: FND_PROFILE.GET('USER_ID', X_user_id);
70: if X_user_id is null then
71: -- dbms_output.put_line('Xuserid is Null');
72: -- po_message_s.app_error('PO_ALL_SQL_ERROR');
73: return False;
74: end if;
75:
76:

Line 160: po_message_s.sql_error('poxpoeri',X_progress,sqlcode);

156: -- Go ahead and complete the procedure.
157: -- return(TRUE) ;
158:
159: WHEN OTHERS THEN
160: po_message_s.sql_error('poxpoeri',X_progress,sqlcode);
161: raise;
162: END ;
163:
164:

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

187: EXCEPTION
188: WHEN NO_DATA_FOUND THEN
189: X_location_id := 0 ;
190: WHEN OTHERS THEN
191: po_message_s.sql_error('poxpoeri',X_progress,sqlcode);
192: raise;
193: END ;
194: END IF ;
195:

Line 222: po_message_s.sql_error('get_employee',X_progress,sqlcode);

218: WHEN NO_DATA_FOUND THEN
219: /* user is not a buyer */
220: is_buyer := FALSE ;
221: WHEN OTHERS THEN
222: po_message_s.sql_error('get_employee',X_progress,sqlcode);
223: raise;
224: END ;
225: END IF;
226:

Line 263: po_message_s.sql_error('get_employee','000', sqlcode);

259:
260:
261: exception
262: when others then
263: po_message_s.sql_error('get_employee','000', sqlcode);
264: raise;
265:
266: END get_employee ;
267:

Line 335: PO_MESSAGE_S.SQL_ERROR('PO_EMPLOYEES_SV.ONLINE_USER', x_progress, sqlcode);

331:
332: EXCEPTION
333: WHEN OTHERS THEN
334: --dbms_output.put_line('In Exception');
335: PO_MESSAGE_S.SQL_ERROR('PO_EMPLOYEES_SV.ONLINE_USER', x_progress, sqlcode);
336: RAISE;
337: END;
338:
339: /*===========================================================================

Line 389: PO_MESSAGE_S.SQL_ERROR('GET_EMPLOYEE_NAME', x_progress, sqlcode);

385:
386: EXCEPTION
387: WHEN OTHERS THEN
388: --dbms_output.put_line('In Exception');
389: PO_MESSAGE_S.SQL_ERROR('GET_EMPLOYEE_NAME', x_progress, sqlcode);
390: RAISE;
391: END get_employee_name;
392:
393: /*===========================================================================