APPS.OZF_OFFER_ADJ_PRODUCTS_PVT dependencies on JTF_PLSQL_API

Line 22: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

18: )
19: IS
20: BEGIN
21: x_return_status := FND_API.G_RET_STS_SUCCESS;
22: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
23: IF p_adj_prod.offer_adjustment_id IS NULL OR p_adj_prod.offer_adjustment_id = FND_API.G_MISS_NUM THEN
24: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','offer_adjustment_id');
25: x_return_status := FND_API.g_ret_sts_error;
26: return;

Line 117: IF p_validation_mode = JTF_PLSQL_API.G_CREATE THEN

113: l_offerType VARCHAR2(30);
114: l_offerId NUMBER;
115: BEGIN
116: x_return_status := FND_API.G_RET_STS_SUCCESS;
117: IF p_validation_mode = JTF_PLSQL_API.G_CREATE THEN
118: IF p_adj_prod.offer_adjustment_product_id IS NOT NULL AND p_adj_prod.offer_adjustment_product_id <> FND_API.G_MISS_NUM THEN
119: IF OZF_UTILITY_PVT.CHECK_UNIQUENESS('ozf_offer_adjustment_products','offer_adjustment_product_id = '|| p_adj_prod.offer_adjustment_product_id) = FND_API.G_FALSE THEN
120: OZF_Utility_PVT.Error_Message('OZF_OFFR_ADJ_PROD_ID_DUP');
121: x_return_status := FND_API.g_ret_sts_error;

Line 266: IF p_validation_mode = JTF_PLSQL_API.G_CREATE THEN

262: END IF;
263: END IF;
264: -- if new product is added then product_context, product_attribute, product_attr_value, apply_discount_flag , include_volume_flag are required
265: IF p_adj_prod.off_discount_product_id IS NULL OR p_adj_prod.off_discount_product_id = FND_API.G_MISS_NUM THEN -- if this is a new product
266: IF p_validation_mode = JTF_PLSQL_API.G_CREATE THEN
267: IF p_adj_prod.product_context IS NULL OR p_adj_prod.product_context = FND_API.G_MISS_CHAR THEN
268: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','PRODUCT_CONTEXT');
269: x_return_status := FND_API.g_ret_sts_error;
270: return;

Line 411: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_CREATE

407:
408: PROCEDURE check_adj_products
409: (
410: p_adj_prod IN offer_adj_prod_rec
411: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_CREATE
412: , x_return_status OUT NOCOPY VARCHAR2
413: )
414: IS
415: BEGIN

Line 503: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_CREATE,

499: p_api_version_number IN NUMBER,
500: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
501: p_commit IN VARCHAR2 := FND_API.G_FALSE,
502: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
503: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_CREATE,
504: x_return_status OUT NOCOPY VARCHAR2,
505: x_msg_count OUT NOCOPY NUMBER,
506: x_msg_data OUT NOCOPY VARCHAR2,
507: p_adj_prod IN offer_adj_prod_rec

Line 514: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

510: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_ADJ_PRODUCTS';
511: BEGIN
512: x_return_status := FND_API.G_RET_STS_SUCCESS;
513: OZF_Offer_Adj_Line_PVT.debug_message('Private API: '|| l_api_name || ' Start');
514: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
515: check_adj_products(
516: p_adj_prod => p_adj_prod
517: , p_validation_mode => p_validation_mode
518: , x_return_status => x_return_status

Line 615: , p_validation_mode => jtf_plsql_api.g_create

611: p_api_version_number => p_api_version_number
612: , p_init_msg_list => p_init_msg_list
613: , p_commit => p_commit
614: , p_validation_level => p_validation_level
615: , p_validation_mode => jtf_plsql_api.g_create
616: , x_return_status => x_return_status
617: , x_msg_count => x_msg_count
618: , x_msg_data => x_msg_data
619: , p_adj_prod => p_adj_prod

Line 773: , p_validation_mode => jtf_plsql_api.g_update

769: p_api_version_number => p_api_version_number
770: , p_init_msg_list => p_init_msg_list
771: , p_commit => p_commit
772: , p_validation_level => p_validation_level
773: , p_validation_mode => jtf_plsql_api.g_update
774: , x_return_status => x_return_status
775: , x_msg_count => x_msg_count
776: , x_msg_data => x_msg_data
777: , p_adj_prod => l_tar_rec