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

267: -- Go ahead and complete the procedure.
268: -- return(TRUE) ;
269:
270: WHEN OTHERS THEN
271: po_message_s.sql_error('poxpoeri',X_progress,sqlcode);
272: raise;
273: END ;
274:
275:

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

298: EXCEPTION
299: WHEN NO_DATA_FOUND THEN
300: X_location_id := 0 ;
301: WHEN OTHERS THEN
302: po_message_s.sql_error('poxpoeri',X_progress,sqlcode);
303: raise;
304: END ;
305: END IF ;
306:

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

329: WHEN NO_DATA_FOUND THEN
330: /* user is not a buyer */
331: is_buyer := FALSE ;
332: WHEN OTHERS THEN
333: po_message_s.sql_error('get_employee',X_progress,sqlcode);
334: raise;
335: END ;
336: END IF;
337:

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

370:
371:
372: exception
373: when others then
374: po_message_s.sql_error('get_employee','000', sqlcode);
375: raise;
376:
377: END get_employee ;
378:

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

442:
443: EXCEPTION
444: WHEN OTHERS THEN
445: --dbms_output.put_line('In Exception');
446: PO_MESSAGE_S.SQL_ERROR('PO_EMPLOYEES_SV.ONLINE_USER', x_progress, sqlcode);
447: RAISE;
448: END;
449:
450: /*===========================================================================

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

496:
497: EXCEPTION
498: WHEN OTHERS THEN
499: --dbms_output.put_line('In Exception');
500: PO_MESSAGE_S.SQL_ERROR('GET_EMPLOYEE_NAME', x_progress, sqlcode);
501: RAISE;
502: END get_employee_name;
503:
504: /*===========================================================================