APPS.OZF_VOL_OFFR_PVT dependencies on JTF_PLSQL_API

Line 184: p_validation_mode => JTF_PLSQL_API.g_create,

180: Validate_vol_offr(
181: p_api_version_number => 1.0,
182: p_init_msg_list => FND_API.G_FALSE,
183: p_validation_level => p_validation_level,
184: p_validation_mode => JTF_PLSQL_API.g_create,
185: p_vol_offr_tier_rec => p_vol_offr_tier_rec,
186: x_return_status => x_return_status,
187: x_msg_count => x_msg_count,
188: x_msg_data => x_msg_data);

Line 420: p_validation_mode => JTF_PLSQL_API.g_update,

416: Validate_vol_offr(
417: p_api_version_number => 1.0,
418: p_init_msg_list => FND_API.G_FALSE,
419: p_validation_level => p_validation_level,
420: p_validation_mode => JTF_PLSQL_API.g_update,
421: p_vol_offr_tier_rec => p_vol_offr_tier_rec,
422: x_return_status => x_return_status,
423: x_msg_count => x_msg_count,
424: x_msg_data => x_msg_data);

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

798:
799:
800: PROCEDURE check_Vol_Offr_Tier_Uk_Items(
801: p_vol_offr_tier_rec IN vol_offr_tier_rec_type,
802: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
803: x_return_status OUT NOCOPY VARCHAR2)
804: IS
805: l_valid_flag VARCHAR2(1);
806:

Line 809: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

805: l_valid_flag VARCHAR2(1);
806:
807: BEGIN
808: x_return_status := FND_API.g_ret_sts_success;
809: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
810: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
811: 'ozf_volume_offer_tiers',
812: 'volume_offer_tiers_id = ''' || p_vol_offr_tier_rec.volume_offer_tiers_id ||''''
813: );

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

829:
830:
831: PROCEDURE check_Vol_Offr_Tier_Req_Items(
832: p_vol_offr_tier_rec IN vol_offr_tier_rec_type,
833: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
834: x_return_status OUT NOCOPY VARCHAR2
835: )
836: IS
837: BEGIN

Line 840: IF p_validation_mode = JTF_PLSQL_API.g_update THEN

836: IS
837: BEGIN
838: x_return_status := FND_API.g_ret_sts_success;
839: -- check qp_list_header_id
840: IF p_validation_mode = JTF_PLSQL_API.g_update THEN
841: IF p_vol_offr_tier_rec.qp_list_header_id = FND_API.g_miss_num
842: OR p_vol_offr_tier_rec.qp_list_header_id IS NULL
843: THEN
844: Fnd_Message.SET_NAME('OZF', 'OZF_VOL_OFF_NO_LST_HDR_ID');

Line 1195: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1191: FND_MSG_PUB.initialize;
1192: END IF;
1193:
1194:
1195: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1196: Check_vol_offr_tier_Items(
1197: p_vol_offr_tier_rec => p_vol_offr_tier_rec,
1198: p_validation_mode => p_validation_mode,
1199: x_return_status => x_return_status

Line 1209: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

1205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1206: END IF;
1207: END IF;
1208:
1209: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1210: Default_Vol_Offr_Tier_Items (p_vol_offr_tier_rec => p_vol_offr_tier_rec ,
1211: x_vol_offr_tier_rec => l_vol_offr_tier_rec) ;
1212: END IF ;
1213:

Line 1220: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1216: p_vol_offr_tier_rec => l_vol_offr_tier_rec,
1217: x_complete_rec => l_vol_offr_tier_rec
1218: );
1219:
1220: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1221: Validate_vol_offr_tier_Rec(
1222: p_api_version_number => 1.0,
1223: p_init_msg_list => FND_API.G_FALSE,
1224: x_return_status => x_return_status,