107: ROLLBACK;
108: END IF;
109:
110: IF(p_write_conc_log = FND_API.G_TRUE) THEN
111: AMS_Utility_PVT.Write_Conc_Log();
112: END IF;
113:
114: g_error_row_count := g_error_row_count+1;
115:
177: ROLLBACK;
178: END IF;
179:
180: IF(p_write_conc_log = FND_API.G_TRUE) THEN
181: AMS_Utility_PVT.Write_Conc_Log();
182: END IF;
183: END handle_fatal_error;
184:
185:
215: COMMIT; --commits the current row processed
216: END IF;
217:
218: IF (AMS_DEBUG_HIGH_ON) THEN
219: AMS_UTILITY_PVT.debug_message('Error records count '||p_error_records.COUNT);
220: END IF;
221:
222: l_count := p_error_records.COUNT;
223:
224: IF(p_use_object_id_as_pk = FND_API.G_TRUE) THEN
225: -- use object id as primary key
226:
227: IF (AMS_DEBUG_HIGH_ON) THEN
228: AMS_UTILITY_PVT.debug_message('Using Id primary key');
229: END IF;
230:
231: FOR i IN 1 .. l_count
232: LOOP
235: l_error_messages.EXTEND;
236: l_error_messages(i) := p_error_records(i).error_message;
237:
238: IF (AMS_DEBUG_HIGH_ON) THEN
239: AMS_UTILITY_PVT.debug_message('object id : '||p_error_records(i).object_id);
240: AMS_UTILITY_PVT.debug_message('error message : '||p_error_records(i).error_message);
241: END IF;
242:
243: END LOOP;
236: l_error_messages(i) := p_error_records(i).error_message;
237:
238: IF (AMS_DEBUG_HIGH_ON) THEN
239: AMS_UTILITY_PVT.debug_message('object id : '||p_error_records(i).object_id);
240: AMS_UTILITY_PVT.debug_message('error message : '||p_error_records(i).error_message);
241: END IF;
242:
243: END LOOP;
244:
256:
257: ELSE
258:
259: IF (AMS_DEBUG_HIGH_ON) THEN
260: AMS_UTILITY_PVT.debug_message('Using name and parent id primary key');
261: END IF;
262:
263: -- use object name and parent id as identifier
264: FOR i IN 1 .. l_count
270: l_error_messages.EXTEND;
271: l_error_messages(i) := p_error_records(i).error_message;
272:
273: IF (AMS_DEBUG_HIGH_ON) THEN
274: AMS_UTILITY_PVT.debug_message('object name : '||p_error_records(i).object_name);
275: AMS_UTILITY_PVT.debug_message('parent object id : '||p_error_records(i).parent_object_id);
276: AMS_UTILITY_PVT.debug_message('error message : '||p_error_records(i).error_message);
277: END IF;
278:
271: l_error_messages(i) := p_error_records(i).error_message;
272:
273: IF (AMS_DEBUG_HIGH_ON) THEN
274: AMS_UTILITY_PVT.debug_message('object name : '||p_error_records(i).object_name);
275: AMS_UTILITY_PVT.debug_message('parent object id : '||p_error_records(i).parent_object_id);
276: AMS_UTILITY_PVT.debug_message('error message : '||p_error_records(i).error_message);
277: END IF;
278:
279: END LOOP;
272:
273: IF (AMS_DEBUG_HIGH_ON) THEN
274: AMS_UTILITY_PVT.debug_message('object name : '||p_error_records(i).object_name);
275: AMS_UTILITY_PVT.debug_message('parent object id : '||p_error_records(i).parent_object_id);
276: AMS_UTILITY_PVT.debug_message('error message : '||p_error_records(i).error_message);
277: END IF;
278:
279: END LOOP;
280:
311: COMMIT; -- commits all
312: END IF;
313:
314: IF(p_write_conc_out = FND_API.G_TRUE) THEN
315: AMS_Utility_PVT.Write_Conc_Log();
316: END IF;
317: END complete_all;
318:
319: