APPS.AMS_ACT_LIST_PVT dependencies on JTF_PLSQL_API

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

1352:
1353:
1354: PROCEDURE check_act_list_uk_items(
1355: p_act_list_rec IN act_list_rec_type,
1356: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1357: x_return_status OUT NOCOPY VARCHAR2)
1358: IS
1359: l_valid_flag VARCHAR2(1);
1360:

Line 1378: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

1374:
1375: l_count NUMBER;
1376: BEGIN
1377: x_return_status := FND_API.g_ret_sts_success;
1378: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1379: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1380: 'AMS_ACT_LISTS',
1381: 'ACT_LIST_HEADER_ID = ' || p_act_list_rec.ACT_LIST_HEADER_ID
1382: ||' AND LIST_ACT_TYPE = ' ||''''|| p_act_list_rec.LIST_ACT_TYPE||''''

Line 1400: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

1396: x_return_status := FND_API.g_ret_sts_error;
1397: RETURN;
1398: END IF;
1399:
1400: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1401: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1402: 'ams_act_lists',
1403: 'list_used_by_id = ' || p_act_list_rec.list_used_by_id||
1404: ' and list_used_by = '||''''||p_act_list_rec.list_used_by||''''

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

1441: END check_act_list_uk_items;
1442:
1443: PROCEDURE check_act_list_req_items(
1444: p_act_list_rec IN act_list_rec_type,
1445: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1446: x_return_status OUT NOCOPY VARCHAR2
1447: )
1448: IS
1449: BEGIN

Line 1452: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

1448: IS
1449: BEGIN
1450: x_return_status := FND_API.g_ret_sts_success;
1451:
1452: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1453:
1454: IF p_act_list_rec.list_header_id = FND_API.g_miss_num OR
1455: p_act_list_rec.list_header_id IS NULL THEN
1456: AMS_Utility_PVT.Error_Message(p_message_name =>

Line 1786: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1782: THEN
1783: FND_MSG_PUB.initialize;
1784: END IF;
1785:
1786: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1787: IF (AMS_DEBUG_HIGH_ON) THEN
1788:
1789: AMS_Utility_PVT.debug_message('act_list val->' || p_validation_level );
1790: END IF;

Line 1793: p_validation_mode => JTF_PLSQL_API.g_update,

1789: AMS_Utility_PVT.debug_message('act_list val->' || p_validation_level );
1790: END IF;
1791: Check_act_list_Items(
1792: p_act_list_rec => p_act_list_rec,
1793: p_validation_mode => JTF_PLSQL_API.g_update,
1794: x_return_status => x_return_status
1795: );
1796:
1797: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1805: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1801: END IF;
1802:
1803: END IF;
1804:
1805: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1806: Validate_act_list_Rec(
1807: p_api_version_number => 1.0,
1808: p_init_msg_list => FND_API.G_FALSE,
1809: x_return_status => x_return_status,