[Home] [Help]
141: --
142:
143: EXCEPTION
144: when others then
145: po_message_s.sql_error('DISTRIBUTION_DETAIL',x_progress,sqlcode);
146: raise;
147: end DISTRIBUTION_DETAIL;
148:
149: FUNCTION GET_RECEIVING_DISPLAY_VALUE RETURN VARCHAR2 IS
161: RETURN(x_receiving);
162:
163: EXCEPTION
164: when others then
165: po_message_s.sql_error('GET_RECEIVING_DISPLAY_VALUE ',x_progress,sqlcode);
166: raise;
167: end GET_RECEIVING_DISPLAY_VALUE;
168:
169: FUNCTION GET_LOCATION (x_location_id IN NUMBER, x_line_location_id IN NUMBER) RETURN VARCHAR2 IS
217: end if;
218: END;
219: /*End Bug 3284237*/
220: WHEN OTHERS THEN
221: po_message_s.sql_error('GET_LOCATION',x_progress,sqlcode);
222:
223: END GET_LOCATION;
224:
225: FUNCTION GET_DELIVER_PERSON (x_employee_id IN NUMBER) RETURN VARCHAR2 IS
248: RETURN(x_name);
249:
250: EXCEPTION
251: when others then
252: po_message_s.sql_error('GET_DELIVER_PERSON',x_progress,sqlcode);
253: raise;
254: end GET_DELIVER_PERSON;
255:
256: PROCEDURE HAZARD_CLASS_INFO (x_hazard_id IN NUMBER,
263: from po_hazard_classes
264: where hazard_class_id = x_hazard_id;
265: EXCEPTION
266: when others then
267: po_message_s.sql_error('HAZARD_CLASS_INFO',x_progress,sqlcode);
268: raise;
269: end HAZARD_CLASS_INFO;
270:
271: PROCEDURE UN_NUMBER_INFO (x_un_number_id IN NUMBER,
278: from po_un_numbers
279: where un_number_id = x_un_number_id;
280: EXCEPTION
281: when others then
282: po_message_s.sql_error('UN_NUMBER_INFO',x_progress,sqlcode);
283: raise;
284: end UN_NUMBER_INFO;
285:
286: PROCEDURE DEFAULT_SUBINV_LOCATOR (x_subinventory IN OUT NOCOPY VARCHAR2 ,
337: EXCEPTION
338: when no_data_found then
339: null;
340: when others then
341: po_message_s.sql_error('DEFAULT_SUBINV_LOCATOR',x_progress,sqlcode);
342: raise;
343: end DEFAULT_SUBINV_LOCATOR;
344:
345: PROCEDURE VALIDATE_ID ( x_deliver_to_location_id IN OUT NOCOPY NUMBER,
392: EXCEPTION
393: when no_data_found then
394: x_deliver_to_location_id := null;--Bug#6497729
395: when others then
396: po_message_s.sql_error('VALIDATE_ID',x_progress,sqlcode);
397: raise;
398: END;
399:
400: x_progress := 20;
427: EXCEPTION
428: when no_data_found then
429: x_location_id := null;--Bug#6497729
430: when others then
431: po_message_s.sql_error('VALIDATE_ID',x_progress,sqlcode);
432: raise;
433: END;
434:
435: x_progress := 30;
451: EXCEPTION
452: when no_data_found then
453: x_deliver_to_person_id := null;--Bug#6497729
454: when others then
455: po_message_s.sql_error('VALIDATE_ID',x_progress,sqlcode);
456: raise;
457: END;
458:
459: BEGIN
470: EXCEPTION
471: when no_data_found then
472: x_subinventory := '';
473: when others then
474: po_message_s.sql_error('VALIDATE_ID',x_progress,sqlcode);
475: raise;
476: END;
477:
478:
493: EXCEPTION
494: when no_data_found then
495: RETURN(NULL);
496: when others then
497: po_message_s.sql_error('LOCATOR_TYPE',x_progress,sqlcode);
498: raise;
499: end LOCATOR_TYPE;
500:
501: --Bug#2109106. This function has been overloaded.
852: where line_id = x_oe_order_line_id);
853:
854: end if;
855: elsif x_destination_type_code = 'RECEIVING' then
856: po_message_s.app_error(x_destination_type_code);
857: l_subinventory := '';
858: x_locator_id := NULL;
859:
860: end if;
1019: END IF;
1020:
1021: EXCEPTION
1022: WHEN OTHERS THEN
1023: po_message_s.sql_error('POST_QUERY',x_progress,sqlcode);
1024: raise;
1025: END POST_QUERY;
1026:
1027: -- Bug#2109106. This function has been overloaded.This has been done because
1403: END IF;
1404:
1405: EXCEPTION
1406: WHEN OTHERS THEN
1407: po_message_s.sql_error('POST_QUERY',x_progress,sqlcode);
1408: raise;
1409: END POST_QUERY;
1410: End rcv_transaction_sv;
1411: