DBA Data[Home] [Help]

APPS.AMS_SCORERESULT_PVT dependencies on JTF_PLSQL_API

Line 192: p_validation_mode => JTF_PLSQL_API.g_create,

188: Validate_scoreresult(
189: p_api_version => 1.0,
190: p_init_msg_list => FND_API.G_FALSE,
191: p_validation_level => p_validation_level,
192: p_validation_mode => JTF_PLSQL_API.g_create,
193: p_scoreresult_rec => p_scoreresult_rec,
194: x_return_status => x_return_status,
195: x_msg_count => x_msg_count,
196: x_msg_data => x_msg_data);

Line 390: p_validation_mode => JTF_PLSQL_API.g_update,

386: Validate_scoreresult(
387: p_api_version => 1.0,
388: p_init_msg_list => FND_API.G_FALSE,
389: p_validation_level => p_validation_level,
390: p_validation_mode => JTF_PLSQL_API.g_update,
391: p_scoreresult_rec => p_scoreresult_rec,
392: x_return_status => x_return_status,
393: x_msg_count => x_msg_count,
394: x_msg_data => x_msg_data);

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

731:
732:
733: PROCEDURE check_scoreresult_uk_items(
734: p_scoreresult_rec IN scoreresult_rec_type,
735: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
736: x_return_status OUT NOCOPY VARCHAR2)
737: IS
738: l_valid_flag VARCHAR2(1);
739:

Line 742: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

738: l_valid_flag VARCHAR2(1);
739:
740: BEGIN
741: x_return_status := FND_API.g_ret_sts_success;
742: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
743: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
744: 'AMS_DM_SCORE_RESULTS',
745: 'SCORE_RESULT_ID = ''' || p_scoreresult_rec.SCORE_RESULT_ID ||''''
746: );

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

760: END check_scoreresult_uk_items;
761:
762: PROCEDURE check_scoreresult_req_items(
763: p_scoreresult_rec IN scoreresult_rec_type,
764: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
765: x_return_status OUT NOCOPY VARCHAR2
766: )
767: IS
768: BEGIN

Line 771: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

767: IS
768: BEGIN
769: x_return_status := FND_API.g_ret_sts_success;
770:
771: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
772: IF p_scoreresult_rec.score_id = FND_API.g_miss_num OR p_scoreresult_rec.score_id IS NULL THEN
773: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORRES_NO_SCORE_ID');
774: x_return_status := FND_API.g_ret_sts_error;
775: END IF;

Line 965: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

961: IF FND_API.to_Boolean( p_init_msg_list )
962: THEN
963: FND_MSG_PUB.initialize;
964: END IF;
965: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
966: Check_scoreresult_Items(
967: p_scoreresult_rec => p_scoreresult_rec,
968: p_validation_mode => JTF_PLSQL_API.g_update,
969: x_return_status => x_return_status

Line 968: p_validation_mode => JTF_PLSQL_API.g_update,

964: END IF;
965: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
966: Check_scoreresult_Items(
967: p_scoreresult_rec => p_scoreresult_rec,
968: p_validation_mode => JTF_PLSQL_API.g_update,
969: x_return_status => x_return_status
970: );
971:
972: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 984: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

980: p_scoreresult_rec => p_scoreresult_rec,
981: x_complete_rec => l_scoreresult_rec
982: );
983:
984: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
985: Validate_scoreresult_Rec(
986: p_api_version => 1.0,
987: p_init_msg_list => FND_API.G_FALSE,
988: x_return_status => x_return_status,