APPS.CSD_PROCESS_PVT dependencies on FND_LOOKUPS

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

2473: END IF;
2474:
2475: Debug('Validate action type', l_mod_name, 1);
2476:
2477: -- Validate the Action Type if it exists in fnd_lookups
2478: IF NOT
2479: (Csd_Process_Util.Validate_action_type(p_action_type => x_product_txn_rec.action_type))
2480: THEN
2481: RAISE Fnd_Api.G_EXC_ERROR;

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

2482: END IF;
2483:
2484: Debug('Validate action code', l_mod_name, 1);
2485:
2486: -- Validate the repair line ID if it exists in fnd_lookups
2487: IF NOT
2488: (Csd_Process_Util.Validate_action_code(p_action_code => x_product_txn_rec.action_code))
2489: THEN
2490: RAISE Fnd_Api.G_EXC_ERROR;

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

2537: x_product_txn_rec.PROD_TXN_STATUS,
2538: l_mod_name,
2539: 1);
2540:
2541: -- Validate the PROD_TXN_STATUS if it exists in fnd_lookups
2542: IF (x_product_txn_rec.PROD_TXN_STATUS IS NOT NULL) AND
2543: (x_product_txn_rec.PROD_TXN_STATUS <> Fnd_Api.G_MISS_CHAR)
2544: THEN
2545: BEGIN

Line 2548: FROM fnd_lookups

2544: THEN
2545: BEGIN
2546: SELECT 'X'
2547: INTO l_check
2548: FROM fnd_lookups
2549: WHERE lookup_type = 'CSD_PRODUCT_TXN_STATUS'
2550: AND lookup_code = x_product_txn_rec.PROD_TXN_STATUS;
2551: EXCEPTION
2552: WHEN OTHERS THEN

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

4169: THEN
4170: Csd_Gen_Utility_Pvt.ADD('Validate action type');
4171: END IF;
4172:
4173: -- Validate the Action Type if it exists in fnd_lookups
4174: IF NOT
4175: (Csd_Process_Util.Validate_action_type(p_action_type => x_product_txn_rec.action_type))
4176: THEN
4177: RAISE Fnd_Api.G_EXC_ERROR;

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

4181: THEN
4182: Csd_Gen_Utility_Pvt.ADD('Validate action code');
4183: END IF;
4184:
4185: -- Validate the repair line ID if it exists in fnd_lookups
4186: IF NOT
4187: (Csd_Process_Util.Validate_action_code(p_action_code => x_product_txn_rec.action_code))
4188: THEN
4189: RAISE Fnd_Api.G_EXC_ERROR;

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

4224: Csd_Gen_Utility_Pvt.ADD('x_product_txn_rec.PROD_TXN_STATUS =' ||
4225: x_product_txn_rec.PROD_TXN_STATUS);
4226: END IF;
4227:
4228: -- Validate the PROD_TXN_STATUS if it exists in fnd_lookups
4229: IF (x_product_txn_rec.PROD_TXN_STATUS IS NOT NULL) AND
4230: (x_product_txn_rec.PROD_TXN_STATUS <> Fnd_Api.G_MISS_CHAR)
4231: THEN
4232: BEGIN

Line 4235: FROM fnd_lookups

4231: THEN
4232: BEGIN
4233: SELECT 'X'
4234: INTO l_check
4235: FROM fnd_lookups
4236: WHERE lookup_type = 'CSD_PRODUCT_TXN_STATUS'
4237: AND lookup_code = x_product_txn_rec.PROD_TXN_STATUS;
4238: EXCEPTION
4239: WHEN OTHERS THEN

Line 8324: FROM fnd_lookups

8320: THEN
8321: BEGIN
8322: SELECT 'x'
8323: INTO l_check
8324: FROM fnd_lookups
8325: WHERE lookup_type = 'CSD_PRODUCT_TXN_STATUS'
8326: AND lookup_code = x_product_txn_rec.prod_txn_status;
8327: IF l_statement_level >= l_debug_level
8328: THEN

Line 9066: FROM csd_repairs dra, fnd_lookups fndl2, csd_repair_types_vl drtvl

9062: l_Inventory_Item_id,
9063: l_RO_Repair_Type_Ref,
9064: l_RO_Number,
9065: l_RO_Status_Meaning
9066: FROM csd_repairs dra, fnd_lookups fndl2, csd_repair_types_vl drtvl
9067: WHERE repair_line_id = p_Repair_line_id
9068: and dra.repair_type_id = drtvl.repair_type_id
9069: and dra.status = fndl2.lookup_code
9070: and fndl2.lookup_type = 'CSD_REPAIR_STATUS';