APPS.CSD_MASS_RCV_PVT dependencies on FND_LOOKUPS

Line 2501: -- Validate the Action Type if it exists in fnd_lookups

2497: 'Validate action type'
2498: );
2499: END IF;
2500:
2501: -- Validate the Action Type if it exists in fnd_lookups
2502: IF NOT (csd_process_util.validate_action_type
2503: (p_action_type => p_product_txn_rec.action_type)
2504: )
2505: THEN

Line 2518: -- Validate the repair line ID if it exists in fnd_lookups

2514: 'Validate action code'
2515: );
2516: END IF;
2517:
2518: -- Validate the repair line ID if it exists in fnd_lookups
2519: IF NOT (csd_process_util.validate_action_code
2520: (p_action_code => p_product_txn_rec.action_code)
2521: )
2522: THEN

Line 2581: -- Validate the PROD_TXN_STATUS if it exists in fnd_lookups

2577: || p_product_txn_rec.prod_txn_status
2578: );
2579: END IF;
2580:
2581: -- Validate the PROD_TXN_STATUS if it exists in fnd_lookups
2582: IF (p_product_txn_rec.prod_txn_status IS NOT NULL)
2583: AND (p_product_txn_rec.prod_txn_status <> fnd_api.g_miss_char)
2584: THEN
2585: BEGIN

Line 2588: FROM fnd_lookups

2584: THEN
2585: BEGIN
2586: SELECT 'X'
2587: INTO l_check
2588: FROM fnd_lookups
2589: WHERE lookup_type = 'CSD_PRODUCT_TXN_STATUS'
2590: AND lookup_code = p_product_txn_rec.prod_txn_status;
2591: EXCEPTION
2592: WHEN OTHERS