41: END IF;
42:
43: EXCEPTION
44: WHEN others THEN
45: po_message_s.sql_error
46: ('val_shipment_num', x_progress, sqlcode);
47: raise;
48: END val_shipment_num;
49:
79: RETURN TRUE;
80: END IF;
81: EXCEPTION
82: WHEN others THEN
83: po_message_s.sql_error('val_shipment_type', x_progress,sqlcode);
84: raise;
85: END val_shipment_type;
86:
87: /*================================================================
122: EXCEPTION
123: When no_data_found then
124: RETURN NULL;
125: When others then
126: po_message_s.sql_error('derive_line_location_id',X_progress, sqlcode);
127: raise;
128: END derive_line_location_id;
129:
130: /*===============================================================
163: EXCEPTION
164: WHEN NO_DATA_FOUND then
165: RETURN NULL;
166: WHEN OTHERS THEN
167: po_message_s.sql_error('derive_location_id',X_progress, sqlcode);
168: RAISE;
169:
170: END derive_location_id;
171: /*==================================================================
205: END IF;
206:
207: EXCEPTION
208: WHEN others THEN
209: po_message_s.sql_error('val_location_id', x_progress,sqlcode);
210: raise;
211: END val_location_id;
212:
213: