APPS.OZF_TRADE_PROFILE_PVT dependencies on JTF_PLSQL_API

Line 879: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

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

Line 882: p_validation_mode => JTF_PLSQL_API.g_update,

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

Line 892: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

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

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

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

Line 1277: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

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

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

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

Line 1647: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1643: IF FND_API.to_Boolean( p_init_msg_list )
1644: THEN
1645: FND_MSG_PUB.initialize;
1646: END IF;
1647: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1648: Check_trade_profile_Items(
1649: p_trade_profile_rec => p_trade_profile_rec,
1650: p_validation_mode => JTF_PLSQL_API.g_create,
1651: x_return_status => x_return_status

Line 1650: p_validation_mode => JTF_PLSQL_API.g_create,

1646: END IF;
1647: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1648: Check_trade_profile_Items(
1649: p_trade_profile_rec => p_trade_profile_rec,
1650: p_validation_mode => JTF_PLSQL_API.g_create,
1651: x_return_status => x_return_status
1652: );
1653: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1654: RAISE FND_API.G_EXC_ERROR;

Line 1660: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1657: END IF;
1658: END IF;
1659:
1660: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1661: Validate_trade_profile_Rec(
1662: p_api_version_number => 1.0,
1663: p_init_msg_list => FND_API.G_FALSE,
1664: x_return_status => x_return_status,