APPS.AMS_CNT_POINT_PVT dependencies on JTF_PLSQL_API

Line 155: p_validation_mode => JTF_PLSQL_API.g_create,

151: Validate_cnt_point(
152: p_api_version_number => 1.0,
153: p_init_msg_list => FND_API.G_FALSE,
154: p_validation_level => p_validation_level,
155: p_validation_mode => JTF_PLSQL_API.g_create,
156: p_cnt_point_rec => p_cnt_point_rec,
157: x_return_status => x_return_status,
158: x_msg_count => x_msg_count,
159: x_msg_data => x_msg_data);

Line 395: p_validation_mode => JTF_PLSQL_API.g_update,

391: Validate_cnt_point(
392: p_api_version_number => 1.0,
393: p_init_msg_list => FND_API.G_FALSE,
394: p_validation_level => p_validation_level,
395: p_validation_mode => JTF_PLSQL_API.g_update,
396: p_cnt_point_rec => p_cnt_point_rec,
397: x_return_status => x_return_status,
398: x_msg_count => x_msg_count,
399: x_msg_data => x_msg_data);

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

792:
793:
794: PROCEDURE check_cnt_point_uk_items(
795: p_cnt_point_rec IN cnt_point_rec_type,
796: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
797: x_return_status OUT NOCOPY VARCHAR2)
798: IS
799: l_valid_flag VARCHAR2(1);
800:

Line 811: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

807: IF (AMS_DEBUG_HIGH_ON) THEN
808:
809: AMS_UTILITY_PVT.debug_message(p_cnt_point_rec.arc_contact_used_by);
810: END IF;
811: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
812: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
813: 'AMS_ACT_CONTACT_POINTS',
814: 'CONTACT_POINT_ID = ' || p_cnt_point_rec.CONTACT_POINT_ID
815: );

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

870:
871:
872: PROCEDURE check_cnt_point_req_items(
873: p_cnt_point_rec IN cnt_point_rec_type,
874: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
875: x_return_status OUT NOCOPY VARCHAR2
876: )
877: IS
878: BEGIN

Line 890: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

886: END IF;
887:
888: x_return_status := FND_API.g_ret_sts_success;
889:
890: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
891:
892: /*
893: IF p_cnt_point_rec.contact_point_id = FND_API.g_miss_num OR p_cnt_point_rec.contact_point_id IS NULL THEN
894: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CNT_POINT_NO_ID');

Line 1349: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1345: THEN
1346: FND_MSG_PUB.initialize;
1347: END IF;
1348:
1349: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1350: IF (AMS_DEBUG_HIGH_ON) THEN
1351:
1352: AMS_UTILITY_PVT.debug_message('Calling Check_cnt_point');
1353: END IF;

Line 1401: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1397: END IF;
1398:
1399:
1400:
1401: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1402: IF (AMS_DEBUG_HIGH_ON) THEN
1403:
1404: AMS_UTILITY_PVT.debug_message('Calling Validate rec'||p_cnt_point_rec.arc_contact_used_by|| x_return_status);
1405: END IF;

Line 1524: IF(p_validation_mode = JTF_PLSQL_API.g_create)

1520:
1521: -- Initialize API return status to SUCCESS
1522: x_return_status := FND_API.G_RET_STS_SUCCESS;
1523:
1524: IF(p_validation_mode = JTF_PLSQL_API.g_create)
1525: THEN
1526: OPEN c_check_cnt_point_uk_rec_cr ;
1527: FETCH c_check_cnt_point_uk_rec_cr INTO l_contact_point_id;
1528: IF c_check_cnt_point_uk_rec_cr%FOUND THEN

Line 1537: IF(p_validation_mode = JTF_PLSQL_API.g_update) THEN

1533: END IF;
1534: CLOSE c_check_cnt_point_uk_rec_cr ;
1535: END IF;
1536:
1537: IF(p_validation_mode = JTF_PLSQL_API.g_update) THEN
1538: OPEN c_check_cnt_point_uk_rec_up ;
1539: FETCH c_check_cnt_point_uk_rec_up INTO l_contact_point_id;
1540:
1541: IF c_check_cnt_point_uk_rec_up%FOUND THEN