APPS.CSD_PROCESS_PVT dependencies on FND_LOOKUPS

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

2556: END IF;
2557:
2558: Debug('Validate action type', l_mod_name, 1);
2559:
2560: -- Validate the Action Type if it exists in fnd_lookups
2561: IF NOT
2562: (Csd_Process_Util.Validate_action_type(p_action_type => x_product_txn_rec.action_type))
2563: THEN
2564: RAISE Fnd_Api.G_EXC_ERROR;

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

2565: END IF;
2566:
2567: Debug('Validate action code', l_mod_name, 1);
2568:
2569: -- Validate the repair line ID if it exists in fnd_lookups
2570: IF NOT
2571: (Csd_Process_Util.Validate_action_code(p_action_code => x_product_txn_rec.action_code))
2572: THEN
2573: RAISE Fnd_Api.G_EXC_ERROR;

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

2619: x_product_txn_rec.PROD_TXN_STATUS,
2620: l_mod_name,
2621: 1);
2622:
2623: -- Validate the PROD_TXN_STATUS if it exists in fnd_lookups
2624: IF (x_product_txn_rec.PROD_TXN_STATUS IS NOT NULL) AND
2625: (x_product_txn_rec.PROD_TXN_STATUS <> Fnd_Api.G_MISS_CHAR)
2626: THEN
2627: BEGIN

Line 2630: FROM fnd_lookups

2626: THEN
2627: BEGIN
2628: SELECT 'X'
2629: INTO l_check
2630: FROM fnd_lookups
2631: WHERE lookup_type = 'CSD_PRODUCT_TXN_STATUS'
2632: AND lookup_code = x_product_txn_rec.PROD_TXN_STATUS;
2633: EXCEPTION
2634: WHEN OTHERS THEN

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

4265: THEN
4266: Csd_Gen_Utility_Pvt.ADD('Validate action type');
4267: END IF;
4268:
4269: -- Validate the Action Type if it exists in fnd_lookups
4270: IF NOT
4271: (Csd_Process_Util.Validate_action_type(p_action_type => x_product_txn_rec.action_type))
4272: THEN
4273: RAISE Fnd_Api.G_EXC_ERROR;

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

4277: THEN
4278: Csd_Gen_Utility_Pvt.ADD('Validate action code');
4279: END IF;
4280:
4281: -- Validate the repair line ID if it exists in fnd_lookups
4282: IF NOT
4283: (Csd_Process_Util.Validate_action_code(p_action_code => x_product_txn_rec.action_code))
4284: THEN
4285: RAISE Fnd_Api.G_EXC_ERROR;

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

4320: Csd_Gen_Utility_Pvt.ADD('x_product_txn_rec.PROD_TXN_STATUS =' ||
4321: x_product_txn_rec.PROD_TXN_STATUS);
4322: END IF;
4323:
4324: -- Validate the PROD_TXN_STATUS if it exists in fnd_lookups
4325: IF (x_product_txn_rec.PROD_TXN_STATUS IS NOT NULL) AND
4326: (x_product_txn_rec.PROD_TXN_STATUS <> Fnd_Api.G_MISS_CHAR)
4327: THEN
4328: BEGIN

Line 4331: FROM fnd_lookups

4327: THEN
4328: BEGIN
4329: SELECT 'X'
4330: INTO l_check
4331: FROM fnd_lookups
4332: WHERE lookup_type = 'CSD_PRODUCT_TXN_STATUS'
4333: AND lookup_code = x_product_txn_rec.PROD_TXN_STATUS;
4334: EXCEPTION
4335: WHEN OTHERS THEN

Line 8479: FROM fnd_lookups

8475: THEN
8476: BEGIN
8477: SELECT 'x'
8478: INTO l_check
8479: FROM fnd_lookups
8480: WHERE lookup_type = 'CSD_PRODUCT_TXN_STATUS'
8481: AND lookup_code = x_product_txn_rec.prod_txn_status;
8482: IF l_statement_level >= l_debug_level
8483: THEN

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

9217: l_Inventory_Item_id,
9218: l_RO_Repair_Type_Ref,
9219: l_RO_Number,
9220: l_RO_Status_Meaning
9221: FROM csd_repairs dra, fnd_lookups fndl2, csd_repair_types_vl drtvl
9222: WHERE repair_line_id = p_Repair_line_id
9223: and dra.repair_type_id = drtvl.repair_type_id
9224: and dra.status = fndl2.lookup_code
9225: and fndl2.lookup_type = 'CSD_REPAIR_STATUS';