APPS.INV_GENEALOGY_PUB dependencies on MTL_LOT_NUMBERS

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

1173: RAISE lg_exc_error;
1174: END IF;
1175:
1176: -- Validate the existence of object number in MTL_SERIAL_NUMBERS
1177: -- or MTL_LOT_NUMBERS depending on the object type.
1178: -- If object number is not found return an error.
1179: IF p_object_type = 1 THEN
1180: IF p_object_id IS NOT NULL THEN
1181: SELECT COUNT(*)

Line 1183: FROM mtl_lot_numbers

1179: IF p_object_type = 1 THEN
1180: IF p_object_id IS NOT NULL THEN
1181: SELECT COUNT(*)
1182: INTO l_dummy
1183: FROM mtl_lot_numbers
1184: WHERE gen_object_id = p_object_id;
1185:
1186: IF l_dummy = 0 THEN
1187: fnd_message.set_name('INV', 'INV_FIELD_INVALID');

Line 1198: FROM mtl_lot_numbers

1194: ELSE
1195: BEGIN
1196: SELECT gen_object_id
1197: INTO l_object_id
1198: FROM mtl_lot_numbers
1199: WHERE lot_number = p_object_number
1200: AND inventory_item_id = p_inventory_item_id
1201: AND organization_id = p_org_id;
1202: EXCEPTION

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

2130: RAISE lg_exc_unexpected_error;
2131: END IF;
2132:
2133: -- Validate the existence of object number in MTL_SERIAL_NUMBERS
2134: -- or MTL_LOT_NUMBERS depending on the object type.
2135: -- If object number is not found return an error.
2136:
2137: IF (p_debug = 1) THEN mydebug('Before deriving Object ID');
2138: mydebug('LTRIM(RTRIM(p_object_number)) : ' ||

Line 2156: FROM mtl_lot_numbers

2152: mydebug('{{- Only if p_validation_level is FULL that parameters- object id will be validated }}');
2153: END IF;
2154: SELECT COUNT(*)
2155: INTO l_dummy
2156: FROM mtl_lot_numbers
2157: WHERE gen_object_id = p_object_id;
2158:
2159: IF l_dummy = 0 THEN
2160: x_return_status := lg_ret_sts_error; -- R12

Line 2177: FROM mtl_lot_numbers

2173: ELSE
2174: BEGIN
2175: SELECT gen_object_id
2176: INTO l_object_id
2177: FROM mtl_lot_numbers
2178: WHERE lot_number = LTRIM(RTRIM(p_object_number))
2179: AND inventory_item_id = p_inventory_item_id
2180: AND organization_id = p_org_id;
2181: IF (p_debug = 1) THEN mydebug('1: l_object_id: ' || l_object_id); END IF;

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

2276: IF (p_debug = 1) THEN mydebug(' After deriving Object Id');
2277: mydebug('x_return_status: ' || x_return_status); END IF;
2278:
2279: -- Validate the existence of parent object number in MTL_SERIAL_NUMBERS
2280: -- or MTL_LOT_NUMBERS depending on the object type.
2281: -- If parent object number is not found return an error.
2282: l_invalid_field_msg := 'Parent Object ID';
2283: l_invalid_comb_msg := 'Parent Org, Item and Object Number Combination';
2284: IF p_parent_object_type = 1 THEN

Line 2292: FROM mtl_lot_numbers

2288: mydebug('{{- Only if p_validation_level is FULL that parameters- parent object_id will be validated }}');
2289: END IF;
2290: SELECT COUNT(*)
2291: INTO l_dummy
2292: FROM mtl_lot_numbers
2293: WHERE gen_object_id = p_parent_object_id;
2294:
2295: IF l_dummy = 0 THEN
2296: x_return_status := lg_ret_sts_error; -- R12

Line 2313: FROM mtl_lot_numbers

2309: ELSE
2310: BEGIN
2311: SELECT gen_object_id
2312: INTO l_parent_object_id
2313: FROM mtl_lot_numbers
2314: WHERE lot_number = LTRIM(RTRIM(p_parent_object_number))
2315: AND inventory_item_id = p_parent_inventory_item_id
2316: AND organization_id = p_parent_org_id;
2317: IF (p_debug = 1) THEN mydebug('1: l_parent_object_id: ' || l_parent_object_id); END IF;

Line 2433: FROM mtl_lot_numbers

2429: mydebug('{{- Only if p_validation_level is FULL that parameters- object id2 will be validated }}');
2430: END IF;
2431: SELECT COUNT(*)
2432: INTO l_dummy
2433: FROM mtl_lot_numbers
2434: WHERE gen_object_id = p_object_id2;
2435:
2436: IF l_dummy = 0 THEN
2437: x_return_status := lg_ret_sts_error; -- R12

Line 2452: FROM mtl_lot_numbers

2448: IF LTRIM(RTRIM(p_object_number2)) IS NOT NULL THEN
2449: BEGIN
2450: SELECT gen_object_id
2451: INTO l_object_id2
2452: FROM mtl_lot_numbers
2453: WHERE lot_number = LTRIM(RTRIM(p_object_number2))
2454: AND inventory_item_id = p_inventory_item_id
2455: AND organization_id = p_org_id;
2456: EXCEPTION

Line 2486: FROM mtl_lot_numbers

2482: mydebug('{{- Only if p_validation_level is FULL that parameters- parent object_id2 will be validated }}');
2483: END IF;
2484: SELECT COUNT(*)
2485: INTO l_dummy
2486: FROM mtl_lot_numbers
2487: WHERE gen_object_id = p_parent_object_id2;
2488:
2489: IF l_dummy = 0 THEN
2490: x_return_status := lg_ret_sts_error; -- R12

Line 2505: FROM mtl_lot_numbers

2501: IF LTRIM(RTRIM(p_parent_object_number2)) IS NOT NULL THEN
2502: BEGIN
2503: SELECT gen_object_id
2504: INTO l_parent_object_id2
2505: FROM mtl_lot_numbers
2506: WHERE lot_number = LTRIM(RTRIM(p_parent_object_number2))
2507: AND inventory_item_id = p_parent_inventory_item_id
2508: AND organization_id = p_parent_org_id;
2509: EXCEPTION