APPS.OZF_PRICE_LIST_PVT dependencies on JTF_PLSQL_API

Line 40: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,

36: END;
37:
38: PROCEDURE Check_Uk_Items
39: (
40: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
41: p_ozf_price_list_rec IN OZF_PRICE_LIST_Rec_Type,
42: x_return_status OUT NOCOPY VARCHAR2
43: )
44: IS

Line 52: IF p_validation_mode = JTF_PLSQL_API.g_create

48: BEGIN
49:
50: x_return_status := FND_API.g_ret_sts_success;
51:
52: IF p_validation_mode = JTF_PLSQL_API.g_create
53: AND p_ozf_price_list_rec.price_list_attribute_id IS NOT NULL AND p_ozf_price_list_rec.price_list_attribute_id <> FND_API.G_MISS_NUM
54: THEN
55: l_uk_flag := OZF_Utility_PVT.check_uniqueness
56: (

Line 72: IF p_validation_mode = JTF_PLSQL_API.g_create

68: x_return_status := FND_API.g_ret_sts_error;
69: RETURN;
70: END IF;
71:
72: IF p_validation_mode = JTF_PLSQL_API.g_create
73: AND p_ozf_price_list_rec.qp_list_header_id IS NOT NULL
74: THEN
75: l_uk_flag := OZF_Utility_PVT.check_uniqueness
76: (

Line 169: AND p_validation_mode = JTF_PLSQL_API.g_update

165:
166: x_return_status := FND_API.g_ret_sts_success;
167: /*
168: IF (p_ozf_price_list_rec.price_list_attribute_id IS NULL OR p_ozf_price_list_rec.price_list_attribute_id = FND_API.g_miss_num)
169: AND p_validation_mode = JTF_PLSQL_API.g_update
170: THEN
171: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
172: FND_MESSAGE.set_name('OZF', 'OZF_API_NO_PRICE_LIST_ATTR_ID');
173: FND_MSG_PUB.add;

Line 181: AND p_validation_mode = JTF_PLSQL_API.g_update

177: RETURN;
178: END IF;
179: */
180: IF (p_ozf_price_list_rec.object_version_number IS NULL OR p_ozf_price_list_rec.object_version_number = FND_API.g_miss_num)
181: AND p_validation_mode = JTF_PLSQL_API.g_update
182: THEN
183: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
184: FND_MESSAGE.set_name('OZF', 'OZF_API_NO_OBJ_VER_NUM');
185: FND_MSG_PUB.add;

Line 193: AND p_validation_mode = JTF_PLSQL_API.g_create

189: RETURN;
190: END IF;
191:
192: IF ( p_ozf_price_list_rec.qp_list_header_id IS NULL OR p_ozf_price_list_rec.qp_list_header_id = FND_API.g_miss_num )
193: AND p_validation_mode = JTF_PLSQL_API.g_create
194: THEN
195: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
196: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_NO_LIST_HEAD_ID');
197: FND_MSG_PUB.add;

Line 205: AND p_validation_mode = JTF_PLSQL_API.g_create

201: RETURN;
202: END IF;
203:
204: IF ( p_ozf_price_list_rec.status_code IS NULL OR p_ozf_price_list_rec.status_code = FND_API.g_miss_char )
205: AND p_validation_mode = JTF_PLSQL_API.g_create
206: THEN
207: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
208: FND_MESSAGE.set_name('OZF', 'OZF_CAMP_NO_STATUS_CODE');
209: FND_MSG_PUB.add;

Line 217: AND p_validation_mode = JTF_PLSQL_API.g_create

213: RETURN;
214: END IF;
215:
216: IF ( p_ozf_price_list_rec.owner_id IS NULL OR p_ozf_price_list_rec.owner_id = FND_API.g_miss_num )
217: AND p_validation_mode = JTF_PLSQL_API.g_create
218: THEN
219: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
220: FND_MESSAGE.set_name('OZF', 'OZF_PRIC_NO_OWNER_ID');
221: FND_MSG_PUB.add;

Line 229: AND p_validation_mode = JTF_PLSQL_API.g_create

225: RETURN;
226: END IF;
227:
228: IF ( p_ozf_price_list_rec.user_status_id IS NULL OR p_ozf_price_list_rec.user_status_id = FND_API.g_miss_num )
229: AND p_validation_mode = JTF_PLSQL_API.g_create
230: THEN
231: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
232: FND_MESSAGE.set_name('OZF', 'OZF_CAMP_NO_USER_STATUS_ID');
233: FND_MSG_PUB.add;

Line 241: AND p_validation_mode = JTF_PLSQL_API.g_create

237: RETURN;
238: END IF;
239:
240: IF ( p_ozf_price_list_rec.custom_setup_id IS NULL OR p_ozf_price_list_rec.custom_setup_id = FND_API.g_miss_num )
241: AND p_validation_mode = JTF_PLSQL_API.g_create
242: THEN
243: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
244: FND_MESSAGE.set_name('OZF', 'OZF_PRIC_NO_CUSTOM_SETUP_ID');
245: FND_MSG_PUB.add;

Line 469: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

465: x_complete_rec => l_OZF_PRICE_LIST_rec
466: );
467: END IF;
468: ozf_utility_pvt.debug_message(l_OZF_PRICE_LIST_rec.status_code);
469: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
470: Check_OZF_PRICE_LIST_Items(
471: p_OZF_PRICE_LIST_rec => l_OZF_PRICE_LIST_rec,
472: p_validation_mode => p_validation_mode,
473: x_return_status => x_return_status

Line 483: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
480: END IF;
481: END IF;
482:
483: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
484:
485: Validate_OZF_PRICE_LIST_Rec(
486: p_api_version_number => 1.0,
487: p_init_msg_list => FND_API.G_FALSE,