APPS.PO_LINE_LOCATIONS_SV7 dependencies on PO_LINE_LOCATIONS

Line 1: PACKAGE BODY PO_LINE_LOCATIONS_SV7 AS

1: PACKAGE BODY PO_LINE_LOCATIONS_SV7 AS
2: /* $Header: POXPISVB.pls 120.1.12000000.1 2007/01/16 23:04:46 appldev ship $ */
3:
4: /*================================================================
5:

Line 219: PROCEDURE NAME: validate_po_line_locations()

215: END validate_po_line_coordination;
216:
217: /*================================================================
218:
219: PROCEDURE NAME: validate_po_line_locations()
220:
221: ==================================================================*/
222: PROCEDURE validate_po_line_locations(
223: x_interface_header_id IN NUMBER,

Line 222: PROCEDURE validate_po_line_locations(

218:
219: PROCEDURE NAME: validate_po_line_locations()
220:
221: ==================================================================*/
222: PROCEDURE validate_po_line_locations(
223: x_interface_header_id IN NUMBER,
224: x_interface_line_id IN NUMBER,
225: x_line_location_id IN NUMBER,
226: x_last_update_date IN DATE,

Line 460: FROM PO_LINE_LOCATIONS

456:
457: --check if there is already a shipment
458: SELECT COUNT(*)
459: INTO x_temp_count
460: FROM PO_LINE_LOCATIONS
461: WHERE po_line_id = x_po_line_id;
462:
463: IF x_temp_count >= 1 THEN
464: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(

Line 1176: X_valid := po_line_locations_sv1.val_shipment_type(X_shipment_type,

1172: IF (X_hd_type_lookup_code is not null) AND
1173: (X_shipment_type is not null) THEN
1174:
1175: X_progress := '380';
1176: X_valid := po_line_locations_sv1.val_shipment_type(X_shipment_type,
1177: X_hd_type_lookup_code);
1178: IF (X_valid = FALSE) THEN
1179: X_progress := '390';
1180: po_interface_errors_sv1.handle_interface_errors(

Line 1204: x_valid := po_line_locations_sv1.val_shipment_num(x_shipment_num,

1200: IF (x_shipment_num is not null) AND (x_po_header_id is not null) AND
1201: (x_po_line_id is not null) AND (x_shipment_type is not null) THEN
1202:
1203: X_progress := '410';
1204: x_valid := po_line_locations_sv1.val_shipment_num(x_shipment_num,
1205: x_shipment_type,
1206: x_po_header_id,
1207: x_po_line_id,
1208: null);

Line 1250: X_valid := po_line_locations_sv7.val_line_location_id_unique(

1246: END IF;
1247:
1248: X_progress := '420';
1249: /*** validate uniqueness of po_line_location_id ***/
1250: X_valid := po_line_locations_sv7.val_line_location_id_unique(
1251: X_line_location_id);
1252:
1253: IF (X_valid = FALSE) THEN
1254: po_interface_errors_sv1.handle_interface_errors(

Line 1541: po_message_s.sql_error('validate_po_line_locations',

1537: END IF; -- x_shipment_type = 'STANDARD'
1538:
1539: EXCEPTION
1540: WHEN others THEN
1541: po_message_s.sql_error('validate_po_line_locations',
1542: x_progress, sqlcode);
1543: raise;
1544: END validate_po_line_locations;
1545:

Line 1544: END validate_po_line_locations;

1540: WHEN others THEN
1541: po_message_s.sql_error('validate_po_line_locations',
1542: x_progress, sqlcode);
1543: raise;
1544: END validate_po_line_locations;
1545:
1546:
1547: /*================================================================
1548:

Line 1561: FROM po_line_locations

1557: BEGIN
1558: X_progress := '010';
1559: SELECT COUNT(*)
1560: INTO X_temp
1561: FROM po_line_locations
1562: WHERE line_location_id = X_line_location_id;
1563:
1564: X_progress := '020';
1565: IF (X_temp = 0) THEN

Line 1578: END PO_LINE_LOCATIONS_SV7;

1574: x_progress, sqlcode);
1575: raise;
1576: END val_line_location_id_unique;
1577:
1578: END PO_LINE_LOCATIONS_SV7;