DBA Data[Home] [Help]

APPS.AMS_PS_CNDCLSES_PVT dependencies on JTF_PLSQL_API

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

731:
732:
733: PROCEDURE check_ps_cndclses_uk_items(
734: p_ps_cndclses_rec IN ps_cndclses_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_IBA_PS_CNDCLSES_B',
745: 'CND_CLAUSE_ID = ''' || p_ps_cndclses_rec.CND_CLAUSE_ID ||''''
746: );

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

761: END check_ps_cndclses_uk_items;
762:
763: PROCEDURE check_ps_cndclses_req_items(
764: p_ps_cndclses_rec IN ps_cndclses_rec_type,
765: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
766: x_return_status OUT NOCOPY VARCHAR2
767: )
768: IS
769: BEGIN

Line 772: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

768: IS
769: BEGIN
770: x_return_status := FND_API.g_ret_sts_success;
771: /*
772: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
773:
774:
775: IF p_ps_cndclses_rec.created_by = FND_API.g_miss_num OR p_ps_cndclses_rec.created_by IS NULL THEN
776: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_cndclses_NO_created_by');

Line 1034: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1030: IF FND_API.to_Boolean( p_init_msg_list )
1031: THEN
1032: FND_MSG_PUB.initialize;
1033: END IF;
1034: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1035: Check_ps_cndclses_Items(
1036: p_ps_cndclses_rec => p_ps_cndclses_rec,
1037: p_validation_mode => JTF_PLSQL_API.g_update,
1038: x_return_status => x_return_status

Line 1037: p_validation_mode => JTF_PLSQL_API.g_update,

1033: END IF;
1034: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1035: Check_ps_cndclses_Items(
1036: p_ps_cndclses_rec => p_ps_cndclses_rec,
1037: p_validation_mode => JTF_PLSQL_API.g_update,
1038: x_return_status => x_return_status
1039: );
1040:
1041: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1053: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1049: p_ps_cndclses_rec => p_ps_cndclses_rec,
1050: x_complete_rec => l_ps_cndclses_rec
1051: );
1052:
1053: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1054: Validate_ps_cndclses_Rec(
1055: p_api_version_number => 1.0,
1056: p_init_msg_list => FND_API.G_FALSE,
1057: x_return_status => x_return_status,