DBA Data[Home] [Help]

APPS.AMS_PS_STRATS_PVT dependencies on JTF_PLSQL_API

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

732:
733:
734: PROCEDURE check_ps_strats_uk_items(
735: p_ps_strats_rec IN ps_strats_rec_type,
736: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
737: x_return_status OUT NOCOPY VARCHAR2)
738: IS
739: l_valid_flag VARCHAR2(1);
740:

Line 743: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

739: l_valid_flag VARCHAR2(1);
740:
741: BEGIN
742: x_return_status := FND_API.g_ret_sts_success;
743: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
744: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
745: 'AMS_IBA_PS_STRATS_B',
746: 'STRATEGY_ID = ''' || p_ps_strats_rec.STRATEGY_ID ||''''
747: );

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

762: END check_ps_strats_uk_items;
763:
764: PROCEDURE check_ps_strats_req_items(
765: p_ps_strats_rec IN ps_strats_rec_type,
766: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
767: x_return_status OUT NOCOPY VARCHAR2
768: )
769: IS
770: BEGIN

Line 773: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

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

Line 1054: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1050: IF FND_API.to_Boolean( p_init_msg_list )
1051: THEN
1052: FND_MSG_PUB.initialize;
1053: END IF;
1054: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1055: Check_ps_strats_Items(
1056: p_ps_strats_rec => p_ps_strats_rec,
1057: p_validation_mode => JTF_PLSQL_API.g_update,
1058: x_return_status => x_return_status

Line 1057: p_validation_mode => JTF_PLSQL_API.g_update,

1053: END IF;
1054: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1055: Check_ps_strats_Items(
1056: p_ps_strats_rec => p_ps_strats_rec,
1057: p_validation_mode => JTF_PLSQL_API.g_update,
1058: x_return_status => x_return_status
1059: );
1060:
1061: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1079: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1075:
1076: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'Inside Comment');
1077: END IF;
1078:
1079: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1080: Validate_ps_strats_Rec(
1081: p_api_version_number => 1.0,
1082: p_init_msg_list => FND_API.G_FALSE,
1083: x_return_status => x_return_status,