[Home] [Help]
129: --
130:
131: EXCEPTION
132: when others then
133: po_message_s.sql_error('DISTRIBUTION_DETAIL',x_progress,sqlcode);
134: raise;
135: end DISTRIBUTION_DETAIL;
136:
137: FUNCTION GET_RECEIVING_DISPLAY_VALUE RETURN VARCHAR2 IS
149: RETURN(x_receiving);
150:
151: EXCEPTION
152: when others then
153: po_message_s.sql_error('GET_RECEIVING_DISPLAY_VALUE ',x_progress,sqlcode);
154: raise;
155: end GET_RECEIVING_DISPLAY_VALUE;
156:
157: FUNCTION GET_LOCATION (x_location_id IN NUMBER, x_line_location_id IN NUMBER) RETURN VARCHAR2 IS
205: end if;
206: END;
207: /*End Bug 3284237*/
208: WHEN OTHERS THEN
209: po_message_s.sql_error('GET_LOCATION',x_progress,sqlcode);
210:
211: END GET_LOCATION;
212:
213: FUNCTION GET_DELIVER_PERSON (x_employee_id IN NUMBER) RETURN VARCHAR2 IS
225: RETURN(x_name);
226:
227: EXCEPTION
228: when others then
229: po_message_s.sql_error('GET_DELIVER_PERSON',x_progress,sqlcode);
230: raise;
231: end GET_DELIVER_PERSON;
232:
233: PROCEDURE HAZARD_CLASS_INFO (x_hazard_id IN NUMBER,
240: from po_hazard_classes
241: where hazard_class_id = x_hazard_id;
242: EXCEPTION
243: when others then
244: po_message_s.sql_error('HAZARD_CLASS_INFO',x_progress,sqlcode);
245: raise;
246: end HAZARD_CLASS_INFO;
247:
248: PROCEDURE UN_NUMBER_INFO (x_un_number_id IN NUMBER,
255: from po_un_numbers
256: where un_number_id = x_un_number_id;
257: EXCEPTION
258: when others then
259: po_message_s.sql_error('UN_NUMBER_INFO',x_progress,sqlcode);
260: raise;
261: end UN_NUMBER_INFO;
262:
263: PROCEDURE DEFAULT_SUBINV_LOCATOR (x_subinventory IN OUT NOCOPY VARCHAR2 ,
314: EXCEPTION
315: when no_data_found then
316: null;
317: when others then
318: po_message_s.sql_error('DEFAULT_SUBINV_LOCATOR',x_progress,sqlcode);
319: raise;
320: end DEFAULT_SUBINV_LOCATOR;
321:
322: PROCEDURE VALIDATE_ID ( x_deliver_to_location_id IN OUT NOCOPY NUMBER,
369: EXCEPTION
370: when no_data_found then
371: x_deliver_to_location_id := null;--Bug#6497729
372: when others then
373: po_message_s.sql_error('VALIDATE_ID',x_progress,sqlcode);
374: raise;
375: END;
376:
377: x_progress := 20;
404: EXCEPTION
405: when no_data_found then
406: x_location_id := null;--Bug#6497729
407: when others then
408: po_message_s.sql_error('VALIDATE_ID',x_progress,sqlcode);
409: raise;
410: END;
411:
412: x_progress := 30;
424: EXCEPTION
425: when no_data_found then
426: x_deliver_to_person_id := null;--Bug#6497729
427: when others then
428: po_message_s.sql_error('VALIDATE_ID',x_progress,sqlcode);
429: raise;
430: END;
431:
432: BEGIN
443: EXCEPTION
444: when no_data_found then
445: x_subinventory := '';
446: when others then
447: po_message_s.sql_error('VALIDATE_ID',x_progress,sqlcode);
448: raise;
449: END;
450:
451:
466: EXCEPTION
467: when no_data_found then
468: RETURN(NULL);
469: when others then
470: po_message_s.sql_error('LOCATOR_TYPE',x_progress,sqlcode);
471: raise;
472: end LOCATOR_TYPE;
473:
474: --Bug#2109106. This function has been overloaded.
825: where line_id = x_oe_order_line_id);
826:
827: end if;
828: elsif x_destination_type_code = 'RECEIVING' then
829: po_message_s.app_error(x_destination_type_code);
830: l_subinventory := '';
831: x_locator_id := NULL;
832:
833: end if;
992: END IF;
993:
994: EXCEPTION
995: WHEN OTHERS THEN
996: po_message_s.sql_error('POST_QUERY',x_progress,sqlcode);
997: raise;
998: END POST_QUERY;
999:
1000: -- Bug#2109106. This function has been overloaded.This has been done because
1376: END IF;
1377:
1378: EXCEPTION
1379: WHEN OTHERS THEN
1380: po_message_s.sql_error('POST_QUERY',x_progress,sqlcode);
1381: raise;
1382: END POST_QUERY;
1383: End rcv_transaction_sv;
1384: