APPS.OZF_FUNDTHRESHOLD_PVT dependencies on JTF_PLSQL_API

Line 545: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

541: IF l_threshold_rec.source_lang IS NULL THEN
542: l_threshold_rec.source_lang := USERENV('LANG');
543: END IF;
544:
545: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
546: Check_threshold_Items(
547: p_threshold_rec => l_threshold_rec,
548: p_validation_mode => JTF_PLSQL_API.g_update,
549: x_return_status => x_return_status

Line 548: p_validation_mode => JTF_PLSQL_API.g_update,

544:
545: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
546: Check_threshold_Items(
547: p_threshold_rec => l_threshold_rec,
548: p_validation_mode => JTF_PLSQL_API.g_update,
549: x_return_status => x_return_status
550: );
551:
552: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 559: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
556: END IF;
557: END IF;
558:
559: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
560: Validate_threshold_Rec(
561: p_api_version_number => 1.0,
562: p_init_msg_list => FND_API.G_FALSE,
563: x_return_status => x_return_status,

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

929:
930:
931: PROCEDURE check_threshold_uk_items(
932: p_threshold_rec IN threshold_rec_type,
933: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
934: x_return_status OUT NOCOPY VARCHAR2)
935: IS
936: l_valid_flag VARCHAR2(1);
937:

Line 940: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

936: l_valid_flag VARCHAR2(1);
937:
938: BEGIN
939: x_return_status := FND_API.g_ret_sts_success;
940: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
941: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
942: 'OZF_THRESHOLDS_ALL_B',
943: 'THRESHOLD_ID = ''' || p_threshold_rec.THRESHOLD_ID ||''''
944: );

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

959: END check_threshold_uk_items;
960:
961: PROCEDURE check_threshold_req_items(
962: p_threshold_rec IN threshold_rec_type,
963: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
964: x_return_status OUT NOCOPY VARCHAR2
965: )
966: IS
967: BEGIN

Line 970: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

966: IS
967: BEGIN
968: x_return_status := FND_API.g_ret_sts_success;
969: /*
970: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
971:
972:
973: IF p_threshold_rec.threshold_id = FND_API.g_miss_num OR p_threshold_rec.threshold_id IS NULL THEN
974: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_NO_threshold_id');

Line 1493: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1489: IF FND_API.to_Boolean( p_init_msg_list )
1490: THEN
1491: FND_MSG_PUB.initialize;
1492: END IF;
1493: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1494: Check_threshold_Items(
1495: p_threshold_rec => p_threshold_rec,
1496: p_validation_mode => JTF_PLSQL_API.g_create,
1497: x_return_status => x_return_status

Line 1496: p_validation_mode => JTF_PLSQL_API.g_create,

1492: END IF;
1493: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1494: Check_threshold_Items(
1495: p_threshold_rec => p_threshold_rec,
1496: p_validation_mode => JTF_PLSQL_API.g_create,
1497: x_return_status => x_return_status
1498: );
1499:
1500: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1507: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1504: END IF;
1505: END IF;
1506:
1507: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1508: Validate_threshold_Rec(
1509: p_api_version_number => 1.0,
1510: p_init_msg_list => FND_API.G_FALSE,
1511: x_return_status => x_return_status,