APPS.INV_GENEALOGY_PUB dependencies on MFG_LOOKUPS

Line 1226: FROM mfg_lookups

1222:
1223: IF p_genealogy_origin IS NOT NULL THEN
1224: SELECT COUNT(*)
1225: INTO l_dummy
1226: FROM mfg_lookups
1227: WHERE lookup_type = 'INV_GENEALOGY_ORIGIN'
1228: AND lookup_code = p_genealogy_origin;
1229:
1230: IF l_dummy = 0 THEN

Line 2513: FROM mfg_lookups

2509: IF p_validation_level = lg_fnd_valid_level_full THEN
2510: -- {{- only if p_validation_level is FULL that the input parameters p_genealogy_origin will be validated }}
2511: SELECT COUNT(*)
2512: INTO l_dummy
2513: FROM mfg_lookups
2514: WHERE lookup_type = 'INV_GENEALOGY_ORIGIN'
2515: AND lookup_code = p_genealogy_origin;
2516:
2517: IF l_dummy = 0 THEN

Line 2522: IF (p_debug = 1) THEN mydebug('Gene. Origin not found in mfg_lookups,'); END IF;

2518: x_return_status := lg_ret_sts_error; -- R12
2519: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
2520: fnd_message.set_token('ENTITY1', 'p_genealogy_origin:' || TO_CHAR(p_genealogy_origin));
2521: fnd_msg_pub.ADD;
2522: IF (p_debug = 1) THEN mydebug('Gene. Origin not found in mfg_lookups,'); END IF;
2523: --RAISE lg_exc_error;
2524: END IF;
2525: END IF;
2526: END IF;