851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
852: END IF;
853:
854: -- Debug Message
855: -- Invoke table handler(OZF_supp_trd_prfls_PKG.Insert_Row)
856: BEGIN
857: OZF_supp_trd_prfls_PKG.Insert_Row(
858: px_supp_trade_profile_id => l_supp_trade_profile_id,
859: px_object_version_number => l_object_version_number,
853:
854: -- Debug Message
855: -- Invoke table handler(OZF_supp_trd_prfls_PKG.Insert_Row)
856: BEGIN
857: OZF_supp_trd_prfls_PKG.Insert_Row(
858: px_supp_trade_profile_id => l_supp_trade_profile_id,
859: px_object_version_number => l_object_version_number,
860: p_last_update_date => SYSDATE,
861: p_last_updated_by => FND_GLOBAL.USER_ID,
1218: END IF;
1219: END IF;
1220:
1221: -- Debug Message
1222: OZF_supp_trd_prfls_PKG.Update_Row(
1223: p_supp_trade_profile_id => l_supp_trade_profile_rec.supp_trade_profile_id,
1224: p_object_version_number => l_supp_trade_profile_rec.object_version_number,
1225: p_last_update_date => SYSDATE,
1226: p_last_updated_by => FND_GLOBAL.USER_ID,
1422: -- Debug Message
1423: IF g_debug THEN
1424: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1425: END IF;
1426: -- Invoke table handler(OZF_supp_trd_prfls_PKG.Delete_Row)
1427: OZF_supp_trd_prfls_PKG.Delete_Row(
1428: p_SUPP_TRADE_PROFILE_ID => p_SUPP_TRADE_PROFILE_ID);
1429: -- End of API body
1430: -- Standard check for p_commit
1423: IF g_debug THEN
1424: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1425: END IF;
1426: -- Invoke table handler(OZF_supp_trd_prfls_PKG.Delete_Row)
1427: OZF_supp_trd_prfls_PKG.Delete_Row(
1428: p_SUPP_TRADE_PROFILE_ID => p_SUPP_TRADE_PROFILE_ID);
1429: -- End of API body
1430: -- Standard check for p_commit
1431: IF FND_API.to_Boolean( p_commit )