APPS.OZF_QP_PRODUCTS_PVT dependencies on JTF_PLSQL_API

Line 27: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

23: )
24: IS
25: BEGIN
26: x_return_status := FND_API.G_RET_STS_SUCCESS;
27: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
28: IF p_qp_product_rec.off_discount_product_id IS NULL OR p_qp_product_rec.off_discount_product_id = FND_API.G_MISS_NUM THEN
29: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','off_discount_product_id');
30: x_return_status := FND_API.g_ret_sts_error;
31: return;

Line 38: ELSIF p_validation_mode = JTF_PLSQL_API.g_update THEN

34: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','PRICING_ATTRIBUTE_ID');
35: x_return_status := FND_API.g_ret_sts_error;
36: return;
37: END IF;
38: ELSIF p_validation_mode = JTF_PLSQL_API.g_update THEN
39: IF p_qp_product_rec.qp_product_id = FND_API.G_MISS_NUM THEN
40: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','QP_PRODUCT_ID');
41: x_return_status := FND_API.g_ret_sts_error;
42: return;

Line 71: IF p_validation_mode = JTF_PLSQL_API.G_CREATE THEN

67: )
68: IS
69: BEGIN
70: x_return_status := FND_API.G_RET_STS_SUCCESS;
71: IF p_validation_mode = JTF_PLSQL_API.G_CREATE THEN
72: IF p_qp_product_rec.qp_product_id IS NOT NULL AND p_qp_product_rec.qp_product_id <> FND_API.G_MISS_NUM THEN
73: IF OZF_Utility_PVT.check_uniqueness('ozf_qp_products','qp_product_id = ''' || p_qp_product_rec.qp_product_id ||'''') = FND_API.g_false THEN
74: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_QP_PROD_ID_DUP');
75: x_return_status := FND_API.g_ret_sts_error;

Line 255: IF p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_ITEM THEN

251: -- Initialize API return status to SUCCESS
252: x_return_status := FND_API.G_RET_STS_SUCCESS;
253:
254: -- check items
255: IF p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_ITEM THEN
256: check_ozf_qp_prod_items(
257: p_qp_product_rec => p_qp_product_rec
258: , p_validation_mode => p_validation_mode
259: , x_return_status => x_return_status

Line 420: , p_validation_mode => JTF_PLSQL_API.G_CREATE

416: (
417: p_api_version_number => p_api_version_number
418: , p_init_msg_list => p_init_msg_list
419: , p_validation_level => p_validation_level
420: , p_validation_mode => JTF_PLSQL_API.G_CREATE
421: , x_return_status => x_return_status
422: , x_msg_count => x_msg_count
423: , x_msg_data => x_msg_data
424: , p_qp_product_rec => l_qp_product_rec

Line 612: , p_validation_mode => JTF_PLSQL_API.G_UPDATE

608: (
609: p_api_version_number => p_api_version_number
610: , p_init_msg_list => p_init_msg_list
611: , p_validation_level => p_validation_level
612: , p_validation_mode => JTF_PLSQL_API.G_UPDATE
613: , x_return_status => x_return_status
614: , x_msg_count => x_msg_count
615: , x_msg_data => x_msg_data
616: , p_qp_product_rec => l_tar_qp_prod_rec