APPS.OZF_MO_PRESET_TIERS_PVT dependencies on JTF_PLSQL_API

Line 31: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

27: )
28: IS
29: BEGIN
30: x_return_status := FND_API.G_RET_STS_SUCCESS;
31: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
32: IF p_preset_tier_rec.offer_market_option_id IS NULL OR p_preset_tier_rec.offer_market_option_id = FND_API.G_MISS_NUM THEN
33: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','offer_market_option_id');
34: x_return_status := FND_API.g_ret_sts_error;
35: return;

Line 86: IF p_validation_mode = JTF_PLSQL_API.G_CREATE THEN

82: )
83: IS
84: BEGIN
85: x_return_status := FND_API.G_RET_STS_SUCCESS;
86: IF p_validation_mode = JTF_PLSQL_API.G_CREATE THEN
87: IF p_preset_tier_rec.market_preset_tier_id IS NOT NULL AND p_preset_tier_rec.market_preset_tier_id <> FND_API.G_MISS_NUM THEN
88: IF ozf_utility_pvt.check_uniqueness('ozf_market_preset_tiers','market_preset_tier_id = '||p_preset_tier_rec.market_preset_tier_id) = FND_API.g_false THEN
89: OZF_Utility_PVT.Error_Message('OZF_MO_PRESET_ID_DUP');
90: x_return_status := FND_API.g_ret_sts_error;

Line 96: IF p_validation_mode = JTF_PLSQL_API.G_UPDATE THEN

92: END IF;
93: END IF;
94: END IF;
95:
96: IF p_validation_mode = JTF_PLSQL_API.G_UPDATE THEN
97: IF
98: (
99: p_preset_tier_rec.offer_market_option_id IS NOT NULL AND p_preset_tier_rec.offer_market_option_id <> FND_API.G_MISS_NUM
100: )

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

311: p_api_version_number IN NUMBER,
312: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
313: p_commit IN VARCHAR2 := FND_API.G_FALSE,
314: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
315: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_CREATE,
316: x_return_status OUT NOCOPY VARCHAR2,
317: x_msg_count OUT NOCOPY NUMBER,
318: x_msg_data OUT NOCOPY VARCHAR2,
319:

Line 329: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

325: x_return_status := FND_API.G_RET_STS_SUCCESS;
326:
327: ozf_utility_pvt.debug_message('Private API: '|| l_api_name||' Start');
328:
329: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
330: check_preset_tier_items
331: (
332: p_preset_tier_rec => p_preset_tier_rec
333: , p_validation_mode => p_validation_mode

Line 424: , p_validation_mode => JTF_PLSQL_API.g_create

420: p_api_version_number => p_api_version_number
421: , p_init_msg_list => p_init_msg_list
422: , p_commit => p_commit
423: , p_validation_level => p_validation_level
424: , p_validation_mode => JTF_PLSQL_API.g_create
425: , x_return_status => x_return_status
426: , x_msg_count => x_msg_count
427: , x_msg_data => x_msg_data
428: , p_preset_tier_rec => l_preset_tier_rec

Line 574: , p_validation_mode => JTF_PLSQL_API.g_update

570: p_api_version_number => p_api_version_number
571: , p_init_msg_list => p_init_msg_list
572: , p_commit => p_commit
573: , p_validation_level => p_validation_level
574: , p_validation_mode => JTF_PLSQL_API.g_update
575: , x_return_status => x_return_status
576: , x_msg_count => x_msg_count
577: , x_msg_data => x_msg_data
578: , p_preset_tier_rec => p_preset_tier_rec