52: DELETE FROM igi_imp_iac_intermediate;
53: COMMIT;
54:
55: -- Write file name to log file
56: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_FILE_LOG');
57: FND_MESSAGE.Set_Token('FILE_NAME',l_full_file_name);
58: igi_iac_debug_pkg.debug_other_msg(p_level => g_state_level,
59: p_full_path => l_path_name,
60: p_remove_from_stack => FALSE);
53: COMMIT;
54:
55: -- Write file name to log file
56: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_FILE_LOG');
57: FND_MESSAGE.Set_Token('FILE_NAME',l_full_file_name);
58: igi_iac_debug_pkg.debug_other_msg(p_level => g_state_level,
59: p_full_path => l_path_name,
60: p_remove_from_stack => FALSE);
61: l_message := FND_MESSAGE.Get;
57: FND_MESSAGE.Set_Token('FILE_NAME',l_full_file_name);
58: igi_iac_debug_pkg.debug_other_msg(p_level => g_state_level,
59: p_full_path => l_path_name,
60: p_remove_from_stack => FALSE);
61: l_message := FND_MESSAGE.Get;
62: FND_FILE.Put_Line(FND_FILE.Log,l_message);
63:
64: -- Invoking SQL*Loader to upload the file to the intermediate table.
65: igi_imp_iac_import_pkg.spawn_loader( l_full_file_name
75:
76: EXCEPTION
77:
78: WHEN e_iac_not_enabled THEN
79: FND_MESSAGE.Set_Name('IGI','IGI_IAC_NOT_INSTALLED');
80: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
81: p_full_path => l_path_name,
82: p_remove_from_stack => FALSE);
83: retcode := 2;
80: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
81: p_full_path => l_path_name,
82: p_remove_from_stack => FALSE);
83: retcode := 2;
84: errbuf := FND_MESSAGE.Get;
85: fnd_file.put_line(fnd_file.log, errbuf);
86: WHEN e_web_adi_enabled THEN
87: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_WEB_ADI_ENABLED');
88: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
83: retcode := 2;
84: errbuf := FND_MESSAGE.Get;
85: fnd_file.put_line(fnd_file.log, errbuf);
86: WHEN e_web_adi_enabled THEN
87: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_WEB_ADI_ENABLED');
88: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
89: p_full_path => l_path_name,
90: p_remove_from_stack => FALSE);
91: retcode := 2;
88: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
89: p_full_path => l_path_name,
90: p_remove_from_stack => FALSE);
91: retcode := 2;
92: errbuf := FND_MESSAGE.Get;
93: fnd_file.put_line(fnd_file.log, errbuf);
94: WHEN OTHERS THEN
95: FND_MESSAGE.Retrieve(l_message);
96: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
91: retcode := 2;
92: errbuf := FND_MESSAGE.Get;
93: fnd_file.put_line(fnd_file.log, errbuf);
94: WHEN OTHERS THEN
95: FND_MESSAGE.Retrieve(l_message);
96: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
97: p_full_path => l_path_name,
98: p_remove_from_stack => FALSE);
99: retcode := 2;