APPS.OZF_SUPP_TRADE_PROFILE_PVT dependencies on JTF_PLSQL_API

Line 1192: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1188: END IF;
1189: l_supp_trade_profile_rec := l_x_supp_trade_profile_rec;
1190:
1191:
1192: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1193: Check_supp_trd_prfl_items(
1194: p_supp_trade_profile_rec => l_supp_trade_profile_rec,
1195: p_validation_mode => JTF_PLSQL_API.g_update,
1196: x_return_status => x_return_status

Line 1195: p_validation_mode => JTF_PLSQL_API.g_update,

1191:
1192: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1193: Check_supp_trd_prfl_items(
1194: p_supp_trade_profile_rec => l_supp_trade_profile_rec,
1195: p_validation_mode => JTF_PLSQL_API.g_update,
1196: x_return_status => x_return_status
1197: );
1198: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1199: RAISE FND_API.G_EXC_ERROR;

Line 1205: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

1201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1202: END IF;
1203: END IF;
1204:
1205: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
1206: Validate_supp_trd_prfl_rec(
1207: p_api_version_number => 1.0,
1208: p_init_msg_list => FND_API.G_FALSE,
1209: x_return_status => x_return_status,

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

1590: End Lock_Supp_Trade_Profile;
1591: -------------------------------------------------------------------------------
1592: PROCEDURE check_supp_trd_prfl_uk_items(
1593: p_supp_trade_profile_rec IN supp_trade_profile_rec_type,
1594: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1595: x_return_status OUT NOCOPY VARCHAR2)
1596: IS
1597: l_valid_flag VARCHAR2(1);
1598: l_supp_id NUMBER;

Line 1625: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

1621: l_supp_site_id := p_supp_trade_profile_rec.supplier_site_id;
1622: OPEN c_dupl_profile_exists(l_supp_id,l_supp_site_id);
1623: FETCH c_dupl_profile_exists into l_dummy;
1624: CLOSE c_dupl_profile_exists;
1625: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1626:
1627: -- if there is another record then throw duplicate exception
1628: IF l_dummy IS NOT NULL
1629: THEN

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

1649: END check_supp_trd_prfl_uk_items;
1650: -------------------------------------------------------------------------------
1651: PROCEDURE check_supp_trd_prfl_req_items(
1652: p_supp_trade_profile_rec IN supp_trade_profile_rec_type,
1653: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1654: x_return_status OUT NOCOPY VARCHAR2
1655: )
1656: IS
1657: l_check1 NUMBER;

Line 1811: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1807: IF FND_API.to_Boolean( p_init_msg_list )
1808: THEN
1809: FND_MSG_PUB.initialize;
1810: END IF;
1811: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1812: Check_supp_trd_prfl_Items(
1813: p_supp_trade_profile_rec => p_supp_trade_profile_rec,
1814: p_validation_mode => JTF_PLSQL_API.g_create,
1815: x_return_status => x_return_status

Line 1814: p_validation_mode => JTF_PLSQL_API.g_create,

1810: END IF;
1811: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1812: Check_supp_trd_prfl_Items(
1813: p_supp_trade_profile_rec => p_supp_trade_profile_rec,
1814: p_validation_mode => JTF_PLSQL_API.g_create,
1815: x_return_status => x_return_status
1816: );
1817: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1818: RAISE FND_API.G_EXC_ERROR;

Line 1824: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1821: END IF;
1822: END IF;
1823:
1824: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1825: Validate_supp_trd_prfl_rec(
1826: p_api_version_number => 1.0,
1827: p_init_msg_list => FND_API.G_FALSE,
1828: x_return_status => x_return_status,