APPS.AMS_LIST_QUERY_PVT dependencies on JTF_PLSQL_API

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

1485:
1486:
1487: PROCEDURE check_list_query_uk_items(
1488: p_list_query_rec IN list_query_rec_type,
1489: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1490: x_return_status OUT NOCOPY VARCHAR2)
1491: IS
1492: l_valid_flag VARCHAR2(1);
1493:

Line 1506: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

1502: BEGIN
1503: x_return_status := FND_API.g_ret_sts_success;
1504:
1505: -- check for uniqueness of id
1506: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1507: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1508: 'AMS_LIST_QUERIES_ALL',
1509: 'LIST_QUERY_ID = ''' || p_list_query_rec.LIST_QUERY_ID ||''''
1510: );

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

1544: END check_list_query_uk_items;
1545:
1546: PROCEDURE check_list_query_req_items(
1547: p_list_query_rec IN list_query_rec_type,
1548: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1549: x_return_status OUT NOCOPY VARCHAR2
1550: )
1551: IS
1552: BEGIN

Line 1555: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

1551: IS
1552: BEGIN
1553: x_return_status := FND_API.g_ret_sts_success;
1554:
1555: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1556:
1557: IF p_list_query_rec.name = FND_API.g_miss_char OR p_list_query_rec.name IS NULL THEN
1558: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_query_NO_name');
1559: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 1918: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1914: IF FND_API.to_Boolean( p_init_msg_list )
1915: THEN
1916: FND_MSG_PUB.initialize;
1917: END IF;
1918: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1919: Check_list_query_Items(
1920: p_list_query_rec => p_list_query_rec,
1921: p_validation_mode => JTF_PLSQL_API.g_update,
1922: x_return_status => x_return_status

Line 1921: p_validation_mode => JTF_PLSQL_API.g_update,

1917: END IF;
1918: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1919: Check_list_query_Items(
1920: p_list_query_rec => p_list_query_rec,
1921: p_validation_mode => JTF_PLSQL_API.g_update,
1922: x_return_status => x_return_status
1923: );
1924:
1925: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1933: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1929: END IF;
1930: END IF;
1931:
1932:
1933: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1934: Validate_list_query_Rec(
1935: p_api_version_number => 1.0,
1936: p_init_msg_list => FND_API.G_FALSE,
1937: x_return_status => x_return_status,