APPS.OZF_THRESHOLD_RULE_PVT dependencies on JTF_PLSQL_API

Line 528: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

524:
525: END IF;
526:
527:
528: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
529: Check_threshold_rule_Items(
530: p_threshold_rule_rec => l_threshold_rule_rec,
531: p_validation_mode => JTF_PLSQL_API.g_update,
532: x_return_status => x_return_status

Line 531: p_validation_mode => JTF_PLSQL_API.g_update,

527:
528: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
529: Check_threshold_rule_Items(
530: p_threshold_rule_rec => l_threshold_rule_rec,
531: p_validation_mode => JTF_PLSQL_API.g_update,
532: x_return_status => x_return_status
533: );
534:
535: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 542: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
539: END IF;
540: END IF;
541:
542: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
543: Validate_threshold_rule_Rec(
544: p_api_version_number => 1.0,
545: p_init_msg_list => FND_API.G_FALSE,
546: x_return_status => x_return_status,

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

917:
918:
919: PROCEDURE check_threshold_rule_uk_items(
920: p_threshold_rule_rec IN threshold_rule_rec_type,
921: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
922: x_return_status OUT NOCOPY VARCHAR2)
923: IS
924: l_valid_flag VARCHAR2(1);
925:

Line 928: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

924: l_valid_flag VARCHAR2(1);
925:
926: BEGIN
927: x_return_status := FND_API.g_ret_sts_success;
928: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
929: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
930: 'OZF_THRESHOLD_RULES_ALL',
931: 'THRESHOLD_RULE_ID = ''' || p_threshold_rule_rec.THRESHOLD_RULE_ID ||''''
932: );

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

947: END check_threshold_rule_uk_items;
948:
949: PROCEDURE check_threshold_rule_req_items(
950: p_threshold_rule_rec IN threshold_rule_rec_type,
951: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
952: x_return_status OUT NOCOPY VARCHAR2
953: )
954: IS
955: CURSOR c_threshold_type (p_thres_id NUMBER) IS

Line 1110: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

1106: END IF;
1107: END IF;
1108:
1109: /*
1110: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1111:
1112:
1113: IF p_threshold_rule_rec.threshold_rule_id = FND_API.g_miss_num OR p_threshold_rule_rec.threshold_rule_id IS NULL THEN
1114: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_rule_NO_threshold_rule_id');

Line 1715: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1711: THEN
1712: FND_MSG_PUB.initialize;
1713: END IF;
1714:
1715: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1716: Check_threshold_rule_Items(
1717: p_threshold_rule_rec => p_threshold_rule_rec,
1718: p_validation_mode => JTF_PLSQL_API.g_create,
1719: x_return_status => x_return_status

Line 1718: p_validation_mode => JTF_PLSQL_API.g_create,

1714:
1715: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1716: Check_threshold_rule_Items(
1717: p_threshold_rule_rec => p_threshold_rule_rec,
1718: p_validation_mode => JTF_PLSQL_API.g_create,
1719: x_return_status => x_return_status
1720: );
1721:
1722: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1729: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1726: END IF;
1727: END IF;
1728:
1729: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1730: Validate_threshold_rule_Rec(
1731: p_api_version_number => 1.0,
1732: p_init_msg_list => FND_API.G_FALSE,
1733: x_return_status => x_return_status,