285: Raise E_Loader2_Failure;
286: End If;
287: Exception
288: When E_Request1_Submit_Error Then
289: fnd_message.retrieve(l_message);
290: fnd_file.put_line(fnd_file.log, l_message);
291: Raise;
292: When E_Request2_Submit_Error Then
293: fnd_message.retrieve(l_message);
289: fnd_message.retrieve(l_message);
290: fnd_file.put_line(fnd_file.log, l_message);
291: Raise;
292: When E_Request2_Submit_Error Then
293: fnd_message.retrieve(l_message);
294: fnd_file.put_line(fnd_file.log, l_message);
295: Raise;
296: When E_Request1_Wait_Error Then
297: fnd_message.retrieve(l_message);
293: fnd_message.retrieve(l_message);
294: fnd_file.put_line(fnd_file.log, l_message);
295: Raise;
296: When E_Request1_Wait_Error Then
297: fnd_message.retrieve(l_message);
298: fnd_file.put_line(fnd_file.log, l_message);
299: Raise;
300: When E_Request2_Wait_Error Then
301: fnd_message.retrieve(l_message);
297: fnd_message.retrieve(l_message);
298: fnd_file.put_line(fnd_file.log, l_message);
299: Raise;
300: When E_Request2_Wait_Error Then
301: fnd_message.retrieve(l_message);
302: fnd_file.put_line(fnd_file.log, l_message);
303: Raise;
304: When E_Loader1_Failure Then
305: fnd_message.set_name('IGI', 'IGIPCDUP_NOT_NORM_COMPLETE');
301: fnd_message.retrieve(l_message);
302: fnd_file.put_line(fnd_file.log, l_message);
303: Raise;
304: When E_Loader1_Failure Then
305: fnd_message.set_name('IGI', 'IGIPCDUP_NOT_NORM_COMPLETE');
306: fnd_message.set_token('FILE_NAME', l_data_file_name);
307: l_message := fnd_message.get;
308: fnd_file.put_line(fnd_file.log, l_message);
309: Raise;
302: fnd_file.put_line(fnd_file.log, l_message);
303: Raise;
304: When E_Loader1_Failure Then
305: fnd_message.set_name('IGI', 'IGIPCDUP_NOT_NORM_COMPLETE');
306: fnd_message.set_token('FILE_NAME', l_data_file_name);
307: l_message := fnd_message.get;
308: fnd_file.put_line(fnd_file.log, l_message);
309: Raise;
310: When E_Loader2_Failure Then
303: Raise;
304: When E_Loader1_Failure Then
305: fnd_message.set_name('IGI', 'IGIPCDUP_NOT_NORM_COMPLETE');
306: fnd_message.set_token('FILE_NAME', l_data_file_name);
307: l_message := fnd_message.get;
308: fnd_file.put_line(fnd_file.log, l_message);
309: Raise;
310: When E_Loader2_Failure Then
311: fnd_message.set_name('IGI', 'IGIPSDUP_NOT_NORM_COMPLETE');
307: l_message := fnd_message.get;
308: fnd_file.put_line(fnd_file.log, l_message);
309: Raise;
310: When E_Loader2_Failure Then
311: fnd_message.set_name('IGI', 'IGIPSDUP_NOT_NORM_COMPLETE');
312: fnd_message.set_token('FILE_NAME', l_data_file_name);
313: l_message := fnd_message.get;
314: fnd_file.put_line(fnd_file.log, l_message);
315: Raise;
308: fnd_file.put_line(fnd_file.log, l_message);
309: Raise;
310: When E_Loader2_Failure Then
311: fnd_message.set_name('IGI', 'IGIPSDUP_NOT_NORM_COMPLETE');
312: fnd_message.set_token('FILE_NAME', l_data_file_name);
313: l_message := fnd_message.get;
314: fnd_file.put_line(fnd_file.log, l_message);
315: Raise;
316: When Others Then
309: Raise;
310: When E_Loader2_Failure Then
311: fnd_message.set_name('IGI', 'IGIPSDUP_NOT_NORM_COMPLETE');
312: fnd_message.set_token('FILE_NAME', l_data_file_name);
313: l_message := fnd_message.get;
314: fnd_file.put_line(fnd_file.log, l_message);
315: Raise;
316: When Others Then
317: fnd_message.retrieve(l_message);
313: l_message := fnd_message.get;
314: fnd_file.put_line(fnd_file.log, l_message);
315: Raise;
316: When Others Then
317: fnd_message.retrieve(l_message);
318: fnd_file.put_line(fnd_file.log, l_message);
319: Raise;
320: END Spawn_Loader;
321:
431: End If;
432: End LooP;
433: Exception
434: When Others Then
435: fnd_message.retrieve(l_message);
436: fnd_file.put_line(fnd_file.log, l_message);
437: Raise;
438: End Match_And_Update;
439:
595: C_Vendor_Not_Found_Rec.company_registration_number);
596: End Loop;
597: Exception
598: When Others Then
599: fnd_message.retrieve(l_message);
600: fnd_file.put_line(fnd_file.log, l_message);
601: Raise;
602: End Generate_Report;
603:
755: Match_And_Update(p_upl_option);
756: Generate_Report(p_upl_option);
757: Exception
758: When E_No_Csv_File_Error Then
759: fnd_message.set_name('IGI', 'IGI_CDROM_NO_FILES_TO_IMPORT');
760: fnd_message.set_token('FILE_NAME', l_csv_file_name);
761: l_message := fnd_message.get;
762: fnd_file.put_line(fnd_file.log, l_message);
763: retcode := 2;
756: Generate_Report(p_upl_option);
757: Exception
758: When E_No_Csv_File_Error Then
759: fnd_message.set_name('IGI', 'IGI_CDROM_NO_FILES_TO_IMPORT');
760: fnd_message.set_token('FILE_NAME', l_csv_file_name);
761: l_message := fnd_message.get;
762: fnd_file.put_line(fnd_file.log, l_message);
763: retcode := 2;
764: errbuf := l_message;
757: Exception
758: When E_No_Csv_File_Error Then
759: fnd_message.set_name('IGI', 'IGI_CDROM_NO_FILES_TO_IMPORT');
760: fnd_message.set_token('FILE_NAME', l_csv_file_name);
761: l_message := fnd_message.get;
762: fnd_file.put_line(fnd_file.log, l_message);
763: retcode := 2;
764: errbuf := l_message;
765: WHEN Others Then
762: fnd_file.put_line(fnd_file.log, l_message);
763: retcode := 2;
764: errbuf := l_message;
765: WHEN Others Then
766: fnd_message.retrieve(l_message);
767: fnd_file.put_line(fnd_file.log, l_message);
768: retcode := 2;
769: errbuf := l_message;
770: End Import_Cdrom_Data_Process;