APPS.AMS_IMPORT_LIST_PVT dependencies on JTF_PLSQL_API

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

1697:
1698:
1699: PROCEDURE check_ams_import_uk_items(
1700: p_ams_import_rec IN ams_import_rec_type,
1701: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1702: x_return_status OUT NOCOPY VARCHAR2)
1703: IS
1704: l_valid_flag VARCHAR2(1);
1705:

Line 1709: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

1705:
1706:
1707: BEGIN
1708: x_return_status := FND_API.g_ret_sts_success;
1709: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1710: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1711: 'AMS_IMP_LIST_HEADERS_ALL',
1712: 'IMPORT_LIST_HEADER_ID = ''' || p_ams_import_rec.IMPORT_LIST_HEADER_ID ||''''
1713: );

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

1731: END check_ams_import_uk_items;
1732:
1733: PROCEDURE check_ams_import_req_items(
1734: p_ams_import_rec IN ams_import_rec_type,
1735: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1736: x_return_status OUT NOCOPY VARCHAR2
1737: )
1738: IS
1739: BEGIN

Line 1742: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

1738: IS
1739: BEGIN
1740: x_return_status := FND_API.g_ret_sts_success;
1741:
1742: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1743:
1744:
1745: 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
1746: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ams_import_NO_import_list_header_id');

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

1951: END check_ams_import_Lookup_items;
1952:
1953: PROCEDURE check_ams_import_Business(
1954: p_ams_import_rec IN ams_import_rec_type,
1955: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1956: x_return_status OUT NOCOPY VARCHAR2
1957: )
1958: IS
1959: CURSOR c_get_import_list(import_list_header_id NUMBER) IS

Line 1991: IF p_validation_mode = JTF_PLSQL_API.g_update

1987: RETURN;
1988: end if;
1989: END IF;
1990:
1991: IF p_validation_mode = JTF_PLSQL_API.g_update
1992: THEN
1993: --Exp date and Usage validation only applied to Rented lists
1994: IF (p_ams_import_rec.rented_list_flag = 'R') and
1995: (p_ams_import_rec.expiry_date <> FND_API.g_miss_date) and

Line 2555: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

2551: IF FND_API.to_Boolean( p_init_msg_list )
2552: THEN
2553: FND_MSG_PUB.initialize;
2554: END IF;
2555: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
2556: Check_ams_import_Items(
2557: p_ams_import_rec => p_ams_import_rec,
2558: p_validation_mode => JTF_PLSQL_API.g_update,
2559: x_return_status => x_return_status

Line 2558: p_validation_mode => JTF_PLSQL_API.g_update,

2554: END IF;
2555: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
2556: Check_ams_import_Items(
2557: p_ams_import_rec => p_ams_import_rec,
2558: p_validation_mode => JTF_PLSQL_API.g_update,
2559: x_return_status => x_return_status
2560: );
2561:
2562: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 2582: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

2578:
2579: AMS_UTILITY_PVT.debug_message('Private API: ' || 'after Complete_ams_import_Rec');
2580: END IF;
2581:
2582: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
2583: Validate_ams_import_Rec(
2584: p_api_version_number => 1.0,
2585: p_init_msg_list => FND_API.G_FALSE,
2586: x_return_status => x_return_status,