APPS.OZF_PRICE_LIST_PVT dependencies on JTF_PLSQL_API

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

23: END;
24:
25: PROCEDURE Check_Uk_Items
26: (
27: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
28: p_ozf_price_list_rec IN OZF_PRICE_LIST_Rec_Type,
29: x_return_status OUT NOCOPY VARCHAR2
30: )
31: IS

Line 39: IF p_validation_mode = JTF_PLSQL_API.g_create

35: BEGIN
36:
37: x_return_status := FND_API.g_ret_sts_success;
38:
39: IF p_validation_mode = JTF_PLSQL_API.g_create
40: 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
41: THEN
42: l_uk_flag := OZF_Utility_PVT.check_uniqueness
43: (

Line 59: IF p_validation_mode = JTF_PLSQL_API.g_create

55: x_return_status := FND_API.g_ret_sts_error;
56: RETURN;
57: END IF;
58:
59: IF p_validation_mode = JTF_PLSQL_API.g_create
60: AND p_ozf_price_list_rec.qp_list_header_id IS NOT NULL
61: THEN
62: l_uk_flag := OZF_Utility_PVT.check_uniqueness
63: (

Line 156: AND p_validation_mode = JTF_PLSQL_API.g_update

152:
153: x_return_status := FND_API.g_ret_sts_success;
154: /*
155: 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)
156: AND p_validation_mode = JTF_PLSQL_API.g_update
157: THEN
158: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
159: FND_MESSAGE.set_name('OZF', 'OZF_API_NO_PRICE_LIST_ATTR_ID');
160: FND_MSG_PUB.add;

Line 168: AND p_validation_mode = JTF_PLSQL_API.g_update

164: RETURN;
165: END IF;
166: */
167: 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)
168: AND p_validation_mode = JTF_PLSQL_API.g_update
169: THEN
170: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
171: FND_MESSAGE.set_name('OZF', 'OZF_API_NO_OBJ_VER_NUM');
172: FND_MSG_PUB.add;

Line 180: AND p_validation_mode = JTF_PLSQL_API.g_create

176: RETURN;
177: END IF;
178:
179: 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 )
180: AND p_validation_mode = JTF_PLSQL_API.g_create
181: THEN
182: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
183: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_NO_LIST_HEAD_ID');
184: FND_MSG_PUB.add;

Line 192: AND p_validation_mode = JTF_PLSQL_API.g_create

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

Line 204: AND p_validation_mode = JTF_PLSQL_API.g_create

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

Line 216: AND p_validation_mode = JTF_PLSQL_API.g_create

212: RETURN;
213: END IF;
214:
215: 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 )
216: AND p_validation_mode = JTF_PLSQL_API.g_create
217: THEN
218: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
219: FND_MESSAGE.set_name('OZF', 'OZF_CAMP_NO_USER_STATUS_ID');
220: FND_MSG_PUB.add;

Line 228: AND p_validation_mode = JTF_PLSQL_API.g_create

224: RETURN;
225: END IF;
226:
227: 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 )
228: AND p_validation_mode = JTF_PLSQL_API.g_create
229: THEN
230: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
231: FND_MESSAGE.set_name('OZF', 'OZF_PRIC_NO_CUSTOM_SETUP_ID');
232: FND_MSG_PUB.add;

Line 456: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

452: x_complete_rec => l_OZF_PRICE_LIST_rec
453: );
454: END IF;
455: ozf_utility_pvt.debug_message(l_OZF_PRICE_LIST_rec.status_code);
456: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
457: Check_OZF_PRICE_LIST_Items(
458: p_OZF_PRICE_LIST_rec => l_OZF_PRICE_LIST_rec,
459: p_validation_mode => p_validation_mode,
460: x_return_status => x_return_status

Line 470: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
467: END IF;
468: END IF;
469:
470: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
471:
472: Validate_OZF_PRICE_LIST_Rec(
473: p_api_version_number => 1.0,
474: p_init_msg_list => FND_API.G_FALSE,