APPS.AMS_THLDCHK_PVT dependencies on JTF_PLSQL_API

Line 756: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

752:
753: AMS_Utility_PVT.debug_message(l_full_name ||': validate');
754: END IF;
755:
756: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
757: Check_thldchk_Items(
758: p_thldchk_rec => p_thldchk_rec,
759: p_validation_mode => JTF_PLSQL_API.g_update,
760: x_return_status => l_return_status

Line 759: p_validation_mode => JTF_PLSQL_API.g_update,

755:
756: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
757: Check_thldchk_Items(
758: p_thldchk_rec => p_thldchk_rec,
759: p_validation_mode => JTF_PLSQL_API.g_update,
760: x_return_status => l_return_status
761: );
762:
763: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 773: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

769:
770: -- replace g_miss_char/num/date with current column values
771: Complete_Thldchk_Rec(p_thldchk_rec, l_thldchk_rec);
772:
773: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
774: Check_Thldchk_Record(
775: p_thldchk_rec => p_thldchk_rec,
776: p_complete_rec => l_thldchk_rec,
777: x_return_status => l_return_status

Line 964: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

960:
961: --
962: -- API body
963: --
964: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
965: Check_Thldchk_Items(
966: p_thldchk_rec => p_thldchk_rec,
967: p_validation_mode => JTF_PLSQL_API.g_create,
968: x_return_status => l_return_status

Line 967: p_validation_mode => JTF_PLSQL_API.g_create,

963: --
964: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
965: Check_Thldchk_Items(
966: p_thldchk_rec => p_thldchk_rec,
967: p_validation_mode => JTF_PLSQL_API.g_create,
968: x_return_status => l_return_status
969: );
970:
971: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 986: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

982:
983: AMS_Utility_PVT.debug_message(l_full_name||': check record');
984: END IF;
985:
986: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
987: Check_Thldchk_Record(
988: p_thldchk_rec => p_thldchk_rec,
989: p_complete_rec => NULL,
990: x_return_status => l_return_status

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

1163: -- 10/26/1999 ptendulk Modified according to new standards
1164: -- End of Comments
1165: PROCEDURE Check_Thldchk_Uk_Items(
1166: p_thldchk_rec IN thldchk_rec_type,
1167: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1168: x_return_status OUT NOCOPY VARCHAR2
1169: )
1170: IS
1171: l_valid_flag VARCHAR2(1);

Line 1179: IF p_validation_mode = JTF_PLSQL_API.g_create

1175: x_return_status := FND_API.g_ret_sts_success;
1176:
1177: -- For create_thldchk, when trigger_check_id is passed in, we need to
1178: -- check if this trigger_check_id is unique.
1179: IF p_validation_mode = JTF_PLSQL_API.g_create
1180: AND p_thldchk_rec.trigger_check_id IS NOT NULL
1181: THEN
1182: IF AMS_Utility_PVT.check_uniqueness(
1183: 'ams_trigger_checks',

Line 1200: IF p_validation_mode <> JTF_PLSQL_API.g_create THEN

1196: -- Unique TRIGGER_NAME and TRIGGER_CREATED_FOR
1197: l_where_clause := ' trigger_id = '|| p_thldchk_rec.trigger_id ;
1198:
1199: -- For Updates, must also check that uniqueness is not checked against the same record.
1200: IF p_validation_mode <> JTF_PLSQL_API.g_create THEN
1201: l_where_clause := l_where_clause || ' AND trigger_check_id <> ' || p_thldchk_rec.trigger_check_id;
1202: END IF;
1203:
1204: IF AMS_Utility_PVT.Check_Uniqueness(

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

1356: -- 10/26/1999 ptendulk Modified according to new standards
1357: -- End of Comments
1358: PROCEDURE Check_Thldchk_Items(
1359: p_thldchk_rec IN thldchk_rec_type,
1360: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1361: x_return_status OUT NOCOPY VARCHAR2
1362: )
1363: IS
1364: BEGIN