APPS.AMS_IMPORT_LIST_PVT dependencies on JTF_PLSQL_API

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

1704:
1705:
1706: PROCEDURE check_ams_import_uk_items(
1707: p_ams_import_rec IN ams_import_rec_type,
1708: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1709: x_return_status OUT NOCOPY VARCHAR2)
1710: IS
1711: l_valid_flag VARCHAR2(1);
1712:

Line 1716: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

1712:
1713:
1714: BEGIN
1715: x_return_status := FND_API.g_ret_sts_success;
1716: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1717: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1718: 'AMS_IMP_LIST_HEADERS_ALL',
1719: 'IMPORT_LIST_HEADER_ID = ''' || p_ams_import_rec.IMPORT_LIST_HEADER_ID ||''''
1720: );

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

1738: END check_ams_import_uk_items;
1739:
1740: PROCEDURE check_ams_import_req_items(
1741: p_ams_import_rec IN ams_import_rec_type,
1742: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1743: x_return_status OUT NOCOPY VARCHAR2
1744: )
1745: IS
1746: BEGIN

Line 1749: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

1745: IS
1746: BEGIN
1747: x_return_status := FND_API.g_ret_sts_success;
1748:
1749: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1750:
1751:
1752: IF p_ams_import_rec.import_list_header_id = FND_API.g_miss_num OR p_ams_import_rec.import_list_header_id IS NULL THEN
1753: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ams_import_NO_import_list_header_id');

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

1958: END check_ams_import_Lookup_items;
1959:
1960: PROCEDURE check_ams_import_Business(
1961: p_ams_import_rec IN ams_import_rec_type,
1962: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1963: x_return_status OUT NOCOPY VARCHAR2
1964: )
1965: IS
1966: CURSOR c_get_import_list(import_list_header_id NUMBER) IS

Line 1998: IF p_validation_mode = JTF_PLSQL_API.g_update

1994: RETURN;
1995: end if;
1996: END IF;
1997:
1998: IF p_validation_mode = JTF_PLSQL_API.g_update
1999: THEN
2000: --Exp date and Usage validation only applied to Rented lists
2001: IF (p_ams_import_rec.rented_list_flag = 'R') and
2002: (p_ams_import_rec.expiry_date <> FND_API.g_miss_date) and

Line 2562: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

2558: IF FND_API.to_Boolean( p_init_msg_list )
2559: THEN
2560: FND_MSG_PUB.initialize;
2561: END IF;
2562: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
2563: Check_ams_import_Items(
2564: p_ams_import_rec => p_ams_import_rec,
2565: p_validation_mode => JTF_PLSQL_API.g_update,
2566: x_return_status => x_return_status

Line 2565: p_validation_mode => JTF_PLSQL_API.g_update,

2561: END IF;
2562: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
2563: Check_ams_import_Items(
2564: p_ams_import_rec => p_ams_import_rec,
2565: p_validation_mode => JTF_PLSQL_API.g_update,
2566: x_return_status => x_return_status
2567: );
2568:
2569: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 2589: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

2585:
2586: AMS_UTILITY_PVT.debug_message('Private API: ' || 'after Complete_ams_import_Rec');
2587: END IF;
2588:
2589: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
2590: Validate_ams_import_Rec(
2591: p_api_version_number => 1.0,
2592: p_init_msg_list => FND_API.G_FALSE,
2593: x_return_status => x_return_status,