APPS.OZF_SUPP_TRADE_PROFILE_PVT dependencies on JTF_PLSQL_API

Line 1311: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1307: END IF;
1308: l_supp_trade_profile_rec := l_x_supp_trade_profile_rec;
1309:
1310:
1311: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1312: Check_supp_trd_prfl_items(
1313: p_supp_trade_profile_rec => l_supp_trade_profile_rec,
1314: p_validation_mode => JTF_PLSQL_API.g_update,
1315: x_return_status => x_return_status

Line 1314: p_validation_mode => JTF_PLSQL_API.g_update,

1310:
1311: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1312: Check_supp_trd_prfl_items(
1313: p_supp_trade_profile_rec => l_supp_trade_profile_rec,
1314: p_validation_mode => JTF_PLSQL_API.g_update,
1315: x_return_status => x_return_status
1316: );
1317: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1318: RAISE FND_API.G_EXC_ERROR;

Line 1324: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

1320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1321: END IF;
1322: END IF;
1323:
1324: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
1325: Validate_supp_trd_prfl_rec(
1326: p_api_version_number => 1.0,
1327: p_init_msg_list => FND_API.G_FALSE,
1328: x_return_status => x_return_status,

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

1721: End Lock_Supp_Trade_Profile;
1722: -------------------------------------------------------------------------------
1723: PROCEDURE check_supp_trd_prfl_uk_items(
1724: p_supp_trade_profile_rec IN supp_trade_profile_rec_type,
1725: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1726: x_return_status OUT NOCOPY VARCHAR2)
1727: IS
1728: l_valid_flag VARCHAR2(1);
1729: l_supp_id NUMBER;

Line 1756: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

1752: l_supp_site_id := p_supp_trade_profile_rec.supplier_site_id;
1753: OPEN c_dupl_profile_exists(l_supp_id,l_supp_site_id);
1754: FETCH c_dupl_profile_exists into l_dummy;
1755: CLOSE c_dupl_profile_exists;
1756: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1757:
1758: -- if there is another record then throw duplicate exception
1759: IF l_dummy IS NOT NULL
1760: THEN

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

1780: END check_supp_trd_prfl_uk_items;
1781: -------------------------------------------------------------------------------
1782: PROCEDURE check_supp_trd_prfl_req_items(
1783: p_supp_trade_profile_rec IN supp_trade_profile_rec_type,
1784: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1785: x_return_status OUT NOCOPY VARCHAR2
1786: )
1787: IS
1788: l_check1 NUMBER;

Line 1942: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1938: IF FND_API.to_Boolean( p_init_msg_list )
1939: THEN
1940: FND_MSG_PUB.initialize;
1941: END IF;
1942: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1943: Check_supp_trd_prfl_Items(
1944: p_supp_trade_profile_rec => p_supp_trade_profile_rec,
1945: p_validation_mode => JTF_PLSQL_API.g_create,
1946: x_return_status => x_return_status

Line 1945: p_validation_mode => JTF_PLSQL_API.g_create,

1941: END IF;
1942: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1943: Check_supp_trd_prfl_Items(
1944: p_supp_trade_profile_rec => p_supp_trade_profile_rec,
1945: p_validation_mode => JTF_PLSQL_API.g_create,
1946: x_return_status => x_return_status
1947: );
1948: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1949: RAISE FND_API.G_EXC_ERROR;

Line 1955: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1951: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1952: END IF;
1953: END IF;
1954:
1955: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1956: Validate_supp_trd_prfl_rec(
1957: p_api_version_number => 1.0,
1958: p_init_msg_list => FND_API.G_FALSE,
1959: x_return_status => x_return_status,