APPS.INV_GENEALOGY_PUB dependencies on MFG_LOOKUPS

Line 1246: FROM mfg_lookups

1242:
1243: IF p_genealogy_origin IS NOT NULL THEN
1244: SELECT COUNT(*)
1245: INTO l_dummy
1246: FROM mfg_lookups
1247: WHERE lookup_type = 'INV_GENEALOGY_ORIGIN'
1248: AND lookup_code = p_genealogy_origin;
1249:
1250: IF l_dummy = 0 THEN

Line 2536: FROM mfg_lookups

2532: IF p_validation_level = lg_fnd_valid_level_full THEN
2533: -- {{- only if p_validation_level is FULL that the input parameters p_genealogy_origin will be validated }}
2534: SELECT COUNT(*)
2535: INTO l_dummy
2536: FROM mfg_lookups
2537: WHERE lookup_type = 'INV_GENEALOGY_ORIGIN'
2538: AND lookup_code = p_genealogy_origin;
2539:
2540: IF l_dummy = 0 THEN

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

2541: x_return_status := lg_ret_sts_error; -- R12
2542: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
2543: fnd_message.set_token('ENTITY1', 'p_genealogy_origin:' || TO_CHAR(p_genealogy_origin));
2544: fnd_msg_pub.ADD;
2545: IF (p_debug = 1) THEN mydebug('Gene. Origin not found in mfg_lookups,'); END IF;
2546: --RAISE lg_exc_error;
2547: END IF;
2548: END IF;
2549: END IF;