APPS.OZF_TRADE_PROFILE_PVT dependencies on JTF_PLSQL_API

Line 877: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

873: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
874: END IF;
875: l_trade_profile_rec := l_x_trade_profile_rec;
876:
877: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
878: Check_trade_profile_Items(
879: p_trade_profile_rec => l_trade_profile_rec,
880: p_validation_mode => JTF_PLSQL_API.g_update,
881: x_return_status => x_return_status

Line 880: p_validation_mode => JTF_PLSQL_API.g_update,

876:
877: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
878: Check_trade_profile_Items(
879: p_trade_profile_rec => l_trade_profile_rec,
880: p_validation_mode => JTF_PLSQL_API.g_update,
881: x_return_status => x_return_status
882: );
883: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
884: RAISE FND_API.G_EXC_ERROR;

Line 890: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

886: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
887: END IF;
888: END IF;
889:
890: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
891: Validate_trade_profile_Rec(
892: p_api_version_number => 1.0,
893: p_init_msg_list => FND_API.G_FALSE,
894: x_return_status => x_return_status,

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

1234: End Lock_Trade_Profile;
1235: -------------------------------------------------------------------------------
1236: PROCEDURE check_trade_profile_uk_items(
1237: p_trade_profile_rec IN trade_profile_rec_type,
1238: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1239: x_return_status OUT NOCOPY VARCHAR2)
1240: IS
1241: l_valid_flag VARCHAR2(1);
1242: l_CUST_ACCOUNT_ID NUMBER;

Line 1275: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

1271: WHERE site_use_id = l_id;
1272:
1273: BEGIN
1274: x_return_status := FND_API.g_ret_sts_success;
1275: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1276: -- check if customer account id is unique
1277: IF p_trade_profile_rec.site_use_id = FND_API.g_miss_num OR
1278: p_trade_profile_rec.site_use_id is null
1279: THEN

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

1326: END check_trade_profile_uk_items;
1327: -------------------------------------------------------------------------------
1328: PROCEDURE check_trade_profile_req_items(
1329: p_trade_profile_rec IN trade_profile_rec_type,
1330: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1331: x_return_status OUT NOCOPY VARCHAR2
1332: )
1333: IS
1334: l_check1 NUMBER;

Line 1643: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1639: IF FND_API.to_Boolean( p_init_msg_list )
1640: THEN
1641: FND_MSG_PUB.initialize;
1642: END IF;
1643: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1644: Check_trade_profile_Items(
1645: p_trade_profile_rec => p_trade_profile_rec,
1646: p_validation_mode => JTF_PLSQL_API.g_create,
1647: x_return_status => x_return_status

Line 1646: p_validation_mode => JTF_PLSQL_API.g_create,

1642: END IF;
1643: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1644: Check_trade_profile_Items(
1645: p_trade_profile_rec => p_trade_profile_rec,
1646: p_validation_mode => JTF_PLSQL_API.g_create,
1647: x_return_status => x_return_status
1648: );
1649: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1650: RAISE FND_API.G_EXC_ERROR;

Line 1656: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1653: END IF;
1654: END IF;
1655:
1656: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1657: Validate_trade_profile_Rec(
1658: p_api_version_number => 1.0,
1659: p_init_msg_list => FND_API.G_FALSE,
1660: x_return_status => x_return_status,