578: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
579: END IF;
580:
581: -- Debug Message
582: -- Invoke table handler(OZF_cust_trd_prfls_PKG.Insert_Row)
583: BEGIN
584: OZF_cust_trd_prfls_PKG.Insert_Row(
585: px_trade_profile_id => l_trade_profile_id,
586: px_object_version_number => l_object_version_number,
580:
581: -- Debug Message
582: -- Invoke table handler(OZF_cust_trd_prfls_PKG.Insert_Row)
583: BEGIN
584: OZF_cust_trd_prfls_PKG.Insert_Row(
585: px_trade_profile_id => l_trade_profile_id,
586: px_object_version_number => l_object_version_number,
587: p_last_update_date => SYSDATE,
588: p_last_updated_by => FND_GLOBAL.USER_ID,
906: OZF_UTILITY_PVT.debug_message('cust_account_id'||l_trade_profile_rec.cust_account_id);
907: END IF;
908:
909: -- Debug Message
910: OZF_cust_trd_prfls_PKG.Update_Row(
911: p_trade_profile_id => l_trade_profile_rec.trade_profile_id,
912: p_object_version_number => l_trade_profile_rec.object_version_number,
913: p_last_update_date => SYSDATE,
914: p_last_updated_by => FND_GLOBAL.USER_ID,
1067: -- Debug Message
1068: IF g_debug THEN
1069: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1070: END IF;
1071: -- Invoke table handler(OZF_cust_trd_prfls_PKG.Delete_Row)
1072: OZF_cust_trd_prfls_PKG.Delete_Row(
1073: p_TRADE_PROFILE_ID => p_TRADE_PROFILE_ID);
1074: -- End of API body
1075: -- Standard check for p_commit
1068: IF g_debug THEN
1069: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1070: END IF;
1071: -- Invoke table handler(OZF_cust_trd_prfls_PKG.Delete_Row)
1072: OZF_cust_trd_prfls_PKG.Delete_Row(
1073: p_TRADE_PROFILE_ID => p_TRADE_PROFILE_ID);
1074: -- End of API body
1075: -- Standard check for p_commit
1076: IF FND_API.to_Boolean( p_commit )