DBA Data[Home] [Help]

APPS.PO_SUBINVENTORIES_S dependencies on PO_MESSAGE_S

Line 70: po_message_s.sql_error('val_subinventory', x_progress, sqlcode);

66:
67: EXCEPTION
68: WHEN NO_DATA_FOUND THEN x_status := 'bad_sub';
69: WHEN OTHERS THEN
70: po_message_s.sql_error('val_subinventory', x_progress, sqlcode);
71: RAISE;
72: END;
73:
74:

Line 111: po_message_s.sql_error('val_subinventory', x_progress, sqlcode);

107:
108: EXCEPTION
109: WHEN NO_DATA_FOUND THEN x_status := 'bad_sub';
110: WHEN OTHERS THEN
111: po_message_s.sql_error('val_subinventory', x_progress, sqlcode);
112: RAISE;
113: END;
114:
115: IF x_status <> 'sub_ok' THEN

Line 125: po_message_s.sql_error('val_subinventory', x_progress, sqlcode);

121: RETURN 0;
122:
123: EXCEPTION
124: WHEN OTHERS THEN
125: po_message_s.sql_error('val_subinventory', x_progress, sqlcode);
126: RAISE;
127: END val_subinventory;
128:
129: /*===========================================================================

Line 216: po_message_s.sql_error('val_locator', x_progress, sqlcode);

212: RETURN 1;
213:
214: EXCEPTION
215: WHEN OTHERS THEN
216: po_message_s.sql_error('val_locator', x_progress, sqlcode);
217: RAISE;
218: END val_locator;
219:
220: /*===========================================================================

Line 323: po_message_s.sql_error('get_locator_control', x_progress, sqlcode);

319: RETURN;
320:
321: EXCEPTION
322: WHEN OTHERS THEN
323: po_message_s.sql_error('get_locator_control', x_progress, sqlcode);
324: RAISE;
325:
326: RETURN;
327: END get_locator_control;

Line 395: po_message_s.sql_error('get_locator_control', x_progress, sqlcode);

391: RETURN;
392:
393: EXCEPTION
394: WHEN OTHERS THEN
395: po_message_s.sql_error('get_locator_control', x_progress, sqlcode);
396: RAISE;
397:
398: RETURN;
399: END get_locator_control;

Line 453: po_message_s.sql_error('get_default_subinventory', x_progress, sqlcode);

449: WHEN NO_DATA_FOUND THEN
450: X_subinventory := NULL;
451: RETURN;
452: WHEN OTHERS THEN
453: po_message_s.sql_error('get_default_subinventory', x_progress, sqlcode);
454: RAISE;
455:
456: END get_default_subinventory;
457:

Line 496: po_message_s.sql_error('get_default_locator', x_progress, sqlcode);

492: WHEN NO_DATA_FOUND THEN
493: X_locator_id := NULL;
494: RETURN;
495: WHEN OTHERS THEN
496: po_message_s.sql_error('get_default_locator', x_progress, sqlcode);
497: RAISE;
498:
499: END get_default_locator;
500:

Line 625: po_message_s.sql_error('po_subinventories_s.check_sub_transfer',

621:
622: EXCEPTION
623: WHEN OTHERS THEN
624: -- dbms_output.put_line('In exception');
625: po_message_s.sql_error('po_subinventories_s.check_sub_transfer',
626: x_progress, sqlcode);
627: raise;
628:
629: END check_sub_transfer;

Line 762: po_message_s.app_error('PO_RQ_SOURCE_SUB_EQS_DEST_SUB');

758: */
759:
760: IF ((x_src_org_id = x_dest_org_id) AND
761: (x_src_sub = x_dest_sub)) THEN
762: po_message_s.app_error('PO_RQ_SOURCE_SUB_EQS_DEST_SUB');
763: return (FALSE);
764:
765: END IF;
766:

Line 834: po_message_s.sql_error('val_src_subinventory', x_progress, sqlcode);

830: EXCEPTION
831: when no_data_found then
832: return (FALSE);
833: when others then
834: po_message_s.sql_error('val_src_subinventory', x_progress, sqlcode);
835: raise;
836:
837: END val_src_subinventory;
838:

Line 886: po_message_s.sql_error('val_locator_control', X_progress, sqlcode);

882: RETURN TRUE;
883:
884: EXCEPTION
885: WHEN OTHERS THEN
886: po_message_s.sql_error('val_locator_control', X_progress, sqlcode);
887: RAISE;
888:
889: END val_locator_control;
890:

Line 924: po_message_s.sql_error('po_subinventories_s.get_subinventory_details',

920:
921: EXCEPTION
922: WHEN OTHERS THEN
923: -- dbms_output.put_line('In exception');
924: po_message_s.sql_error('po_subinventories_s.get_subinventory_details',
925: x_progress, sqlcode);
926: raise;
927:
928: END get_subinventory_details;