APPS.INV_GENEALOGY_PUB dependencies on MTL_LOT_NUMBERS

Line 1157: -- or MTL_LOT_NUMBERS depending on the object type.

1153: RAISE lg_exc_error;
1154: END IF;
1155:
1156: -- Validate the existence of object number in MTL_SERIAL_NUMBERS
1157: -- or MTL_LOT_NUMBERS depending on the object type.
1158: -- If object number is not found return an error.
1159: IF p_object_type = 1 THEN
1160: IF p_object_id IS NOT NULL THEN
1161: SELECT COUNT(*)

Line 1163: FROM mtl_lot_numbers

1159: IF p_object_type = 1 THEN
1160: IF p_object_id IS NOT NULL THEN
1161: SELECT COUNT(*)
1162: INTO l_dummy
1163: FROM mtl_lot_numbers
1164: WHERE gen_object_id = p_object_id;
1165:
1166: IF l_dummy = 0 THEN
1167: fnd_message.set_name('INV', 'INV_FIELD_INVALID');

Line 1178: FROM mtl_lot_numbers

1174: ELSE
1175: BEGIN
1176: SELECT gen_object_id
1177: INTO l_object_id
1178: FROM mtl_lot_numbers
1179: WHERE lot_number = p_object_number
1180: AND inventory_item_id = p_inventory_item_id
1181: AND organization_id = p_org_id;
1182: EXCEPTION

Line 2111: -- or MTL_LOT_NUMBERS depending on the object type.

2107: RAISE lg_exc_unexpected_error;
2108: END IF;
2109:
2110: -- Validate the existence of object number in MTL_SERIAL_NUMBERS
2111: -- or MTL_LOT_NUMBERS depending on the object type.
2112: -- If object number is not found return an error.
2113:
2114: IF (p_debug = 1) THEN mydebug('Before deriving Object ID');
2115: mydebug('LTRIM(RTRIM(p_object_number)) : ' ||

Line 2133: FROM mtl_lot_numbers

2129: mydebug('{{- Only if p_validation_level is FULL that parameters- object id will be validated }}');
2130: END IF;
2131: SELECT COUNT(*)
2132: INTO l_dummy
2133: FROM mtl_lot_numbers
2134: WHERE gen_object_id = p_object_id;
2135:
2136: IF l_dummy = 0 THEN
2137: x_return_status := lg_ret_sts_error; -- R12

Line 2154: FROM mtl_lot_numbers

2150: ELSE
2151: BEGIN
2152: SELECT gen_object_id
2153: INTO l_object_id
2154: FROM mtl_lot_numbers
2155: WHERE lot_number = LTRIM(RTRIM(p_object_number))
2156: AND inventory_item_id = p_inventory_item_id
2157: AND organization_id = p_org_id;
2158: IF (p_debug = 1) THEN mydebug('1: l_object_id: ' || l_object_id); END IF;

Line 2257: -- or MTL_LOT_NUMBERS depending on the object type.

2253: IF (p_debug = 1) THEN mydebug(' After deriving Object Id');
2254: mydebug('x_return_status: ' || x_return_status); END IF;
2255:
2256: -- Validate the existence of parent object number in MTL_SERIAL_NUMBERS
2257: -- or MTL_LOT_NUMBERS depending on the object type.
2258: -- If parent object number is not found return an error.
2259: l_invalid_field_msg := 'Parent Object ID';
2260: l_invalid_comb_msg := 'Parent Org, Item and Object Number Combination';
2261: IF p_parent_object_type = 1 THEN

Line 2269: FROM mtl_lot_numbers

2265: mydebug('{{- Only if p_validation_level is FULL that parameters- parent object_id will be validated }}');
2266: END IF;
2267: SELECT COUNT(*)
2268: INTO l_dummy
2269: FROM mtl_lot_numbers
2270: WHERE gen_object_id = p_parent_object_id;
2271:
2272: IF l_dummy = 0 THEN
2273: x_return_status := lg_ret_sts_error; -- R12

Line 2290: FROM mtl_lot_numbers

2286: ELSE
2287: BEGIN
2288: SELECT gen_object_id
2289: INTO l_parent_object_id
2290: FROM mtl_lot_numbers
2291: WHERE lot_number = LTRIM(RTRIM(p_parent_object_number))
2292: AND inventory_item_id = p_parent_inventory_item_id
2293: AND organization_id = p_parent_org_id;
2294: IF (p_debug = 1) THEN mydebug('1: l_parent_object_id: ' || l_parent_object_id); END IF;

Line 2410: FROM mtl_lot_numbers

2406: mydebug('{{- Only if p_validation_level is FULL that parameters- object id2 will be validated }}');
2407: END IF;
2408: SELECT COUNT(*)
2409: INTO l_dummy
2410: FROM mtl_lot_numbers
2411: WHERE gen_object_id = p_object_id2;
2412:
2413: IF l_dummy = 0 THEN
2414: x_return_status := lg_ret_sts_error; -- R12

Line 2429: FROM mtl_lot_numbers

2425: IF LTRIM(RTRIM(p_object_number2)) IS NOT NULL THEN
2426: BEGIN
2427: SELECT gen_object_id
2428: INTO l_object_id2
2429: FROM mtl_lot_numbers
2430: WHERE lot_number = LTRIM(RTRIM(p_object_number2))
2431: AND inventory_item_id = p_inventory_item_id
2432: AND organization_id = p_org_id;
2433: EXCEPTION

Line 2463: FROM mtl_lot_numbers

2459: mydebug('{{- Only if p_validation_level is FULL that parameters- parent object_id2 will be validated }}');
2460: END IF;
2461: SELECT COUNT(*)
2462: INTO l_dummy
2463: FROM mtl_lot_numbers
2464: WHERE gen_object_id = p_parent_object_id2;
2465:
2466: IF l_dummy = 0 THEN
2467: x_return_status := lg_ret_sts_error; -- R12

Line 2482: FROM mtl_lot_numbers

2478: IF LTRIM(RTRIM(p_parent_object_number2)) IS NOT NULL THEN
2479: BEGIN
2480: SELECT gen_object_id
2481: INTO l_parent_object_id2
2482: FROM mtl_lot_numbers
2483: WHERE lot_number = LTRIM(RTRIM(p_parent_object_number2))
2484: AND inventory_item_id = p_parent_inventory_item_id
2485: AND organization_id = p_parent_org_id;
2486: EXCEPTION