APPS.OZF_VOL_OFFR_PKG dependencies on OZF_UTILITY_PVT

Line 113: OZF_UTILITY_PVT.debug_message('before inserting');

109: px_object_version_number IN OUT NOCOPY NUMBER
110: )
111: IS
112: BEGIN
113: OZF_UTILITY_PVT.debug_message('before inserting');
114: OZF_UTILITY_PVT.debug_message('id: ' || p_volume_offer_tiers_id);
115: OZF_UTILITY_PVT.debug_message('ver: ' || px_object_version_number);
116:
117: Update ozf_volume_offer_tiers

Line 114: OZF_UTILITY_PVT.debug_message('id: ' || p_volume_offer_tiers_id);

110: )
111: IS
112: BEGIN
113: OZF_UTILITY_PVT.debug_message('before inserting');
114: OZF_UTILITY_PVT.debug_message('id: ' || p_volume_offer_tiers_id);
115: OZF_UTILITY_PVT.debug_message('ver: ' || px_object_version_number);
116:
117: Update ozf_volume_offer_tiers
118: SET

Line 115: OZF_UTILITY_PVT.debug_message('ver: ' || px_object_version_number);

111: IS
112: BEGIN
113: OZF_UTILITY_PVT.debug_message('before inserting');
114: OZF_UTILITY_PVT.debug_message('id: ' || p_volume_offer_tiers_id);
115: OZF_UTILITY_PVT.debug_message('ver: ' || px_object_version_number);
116:
117: Update ozf_volume_offer_tiers
118: SET
119: volume_offer_tiers_id = DECODE( p_volume_offer_tiers_id, null, volume_offer_tiers_id, FND_API.G_MISS_NUM, null, p_volume_offer_tiers_id),

Line 134: OZF_UTILITY_PVT.debug_message('no data found');

130: WHERE volume_offer_tiers_id = p_volume_offer_tiers_id
131: AND object_version_number = px_object_version_number;
132:
133: IF (SQL%NOTFOUND) THEN
134: OZF_UTILITY_PVT.debug_message('no data found');
135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
136: END IF;
137: OZF_UTILITY_PVT.debug_message('after inserting');
138:

Line 137: OZF_UTILITY_PVT.debug_message('after inserting');

133: IF (SQL%NOTFOUND) THEN
134: OZF_UTILITY_PVT.debug_message('no data found');
135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
136: END IF;
137: OZF_UTILITY_PVT.debug_message('after inserting');
138:
139: px_object_version_number := nvl(px_object_version_number,0) + 1;
140: OZF_UTILITY_PVT.debug_message('table handler end');
141: END Update_Row;

Line 140: OZF_UTILITY_PVT.debug_message('table handler end');

136: END IF;
137: OZF_UTILITY_PVT.debug_message('after inserting');
138:
139: px_object_version_number := nvl(px_object_version_number,0) + 1;
140: OZF_UTILITY_PVT.debug_message('table handler end');
141: END Update_Row;
142:
143:
144:

Line 204: OZF_Utility_PVT.error_message ('OZF_API_RECORD_NOT_FOUND');

200: OPEN c;
201: FETCH c INTO Recinfo;
202: IF (c%NOTFOUND) THEN
203: CLOSE c;
204: OZF_Utility_PVT.error_message ('OZF_API_RECORD_NOT_FOUND');
205: RAISE FND_API.g_exc_error;
206: END IF;
207: CLOSE c;
208: END Lock_Row;