DBA Data[Home] [Help]

APPS.AMS_DM_TARGET_VALUE_PVT dependencies on JTF_PLSQL_API

Line 153: p_validation_mode => JTF_PLSQL_API.g_create,

149: Validate_dm_target_value(
150: p_api_version_number => 1.0,
151: p_init_msg_list => FND_API.G_FALSE,
152: p_validation_level => p_validation_level,
153: p_validation_mode => JTF_PLSQL_API.g_create,
154: p_dm_target_value_rec => l_dm_target_value_rec,
155: x_return_status => x_return_status,
156: x_msg_count => x_msg_count,
157: x_msg_data => x_msg_data);

Line 411: p_validation_mode => JTF_PLSQL_API.g_update,

407: Validate_dm_target_value(
408: p_api_version_number => 1.0,
409: p_init_msg_list => FND_API.G_FALSE,
410: p_validation_level => p_validation_level,
411: p_validation_mode => JTF_PLSQL_API.g_update,
412: p_dm_target_value_rec => l_tar_dm_target_value_rec,
413: x_return_status => x_return_status,
414: x_msg_count => x_msg_count,
415: x_msg_data => x_msg_data);

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

887:
888:
889: PROCEDURE check_uk_items(
890: p_dm_target_value_rec IN dm_target_value_rec_type,
891: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
892: x_return_status OUT NOCOPY VARCHAR2)
893: IS
894: l_valid_flag VARCHAR2(1);
895:

Line 919: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

915: BEGIN
916: x_return_status := FND_API.g_ret_sts_success;
917:
918: -- validate uniqueness of primary key
919: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
920: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
921: 'AMS_DM_TARGET_VALUES_B',
922: 'TARGET_VALUE_ID = ''' || p_dm_target_value_rec.TARGET_VALUE_ID ||''''
923: );

Line 940: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

936: END IF;
937:
938: -- validate uniqueness of target_id, target_operator and target_value
939: l_valid_flag := FND_API.g_true;
940: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
941: OPEN c_op_value;
942: FETCH c_op_value INTO l_valid_flag;
943: CLOSE c_op_value;
944: ELSE

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

956: END check_uk_items;
957:
958: PROCEDURE check_req_items(
959: p_dm_target_value_rec IN dm_target_value_rec_type,
960: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
961: x_return_status OUT NOCOPY VARCHAR2
962: )
963: IS
964: BEGIN

Line 967: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

963: IS
964: BEGIN
965: x_return_status := FND_API.g_ret_sts_success;
966:
967: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
968:
969: IF (AMS_DEBUG_HIGH_ON) THEN
970:
971:

Line 1266: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1262: IF FND_API.to_Boolean( p_init_msg_list )
1263: THEN
1264: FND_MSG_PUB.initialize;
1265: END IF;
1266: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1267: Check_dm_target_value_Items(
1268: p_dm_target_value_rec => p_dm_target_value_rec,
1269: p_validation_mode => p_validation_mode,
1270: x_return_status => x_return_status

Line 1280: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

1276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1277: END IF;
1278: END IF;
1279:
1280: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
1281: Validate_dm_target_value_Rec(
1282: p_api_version_number => 1.0,
1283: p_init_msg_list => FND_API.G_FALSE,
1284: x_return_status => x_return_status,