148:
149: BEGIN
150:
151:
152: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
153: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_loader_launch_pkg.main_process.exception','Before Calling method igf_aw_gen.set_org_id' );
154: END IF;
155:
156: igf_aw_gen.set_org_id(p_org_id);
149: BEGIN
150:
151:
152: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
153: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_loader_launch_pkg.main_process.exception','Before Calling method igf_aw_gen.set_org_id' );
154: END IF;
155:
156: igf_aw_gen.set_org_id(p_org_id);
157:
154: END IF;
155:
156: igf_aw_gen.set_org_id(p_org_id);
157:
158: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
159: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_loader_launch_pkg.main_process.exception','After Calling method igf_aw_gen.set_org_id' );
160: END IF;
161:
162: errbuf := NULL;
155:
156: igf_aw_gen.set_org_id(p_org_id);
157:
158: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
159: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_loader_launch_pkg.main_process.exception','After Calling method igf_aw_gen.set_org_id' );
160: END IF;
161:
162: errbuf := NULL;
163: retcode := 0;
186: l_file_name := trim(substr(l_file_list, 1, INSTR(l_file_list, ',')-1));
187: END IF;
188:
189: -- call function to get the message class from the file name
190: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
191: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_loader_launch_pkg.main_process.exception','Before Calling method igf_ap_matching_process_pkg.get_msg_class_from_filename' );
192: END IF;
193:
194: l_msg_class := igf_ap_matching_process_pkg.get_msg_class_from_filename(l_file_name);
187: END IF;
188:
189: -- call function to get the message class from the file name
190: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
191: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_loader_launch_pkg.main_process.exception','Before Calling method igf_ap_matching_process_pkg.get_msg_class_from_filename' );
192: END IF;
193:
194: l_msg_class := igf_ap_matching_process_pkg.get_msg_class_from_filename(l_file_name);
195:
192: END IF;
193:
194: l_msg_class := igf_ap_matching_process_pkg.get_msg_class_from_filename(l_file_name);
195:
196: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
197: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_loader_launch_pkg.main_process.exception','After Calling method igf_ap_matching_process_pkg.get_msg_class_from_filename' );
198: END IF;
199:
200: -- validate that the filename derived is a valid message class
193:
194: l_msg_class := igf_ap_matching_process_pkg.get_msg_class_from_filename(l_file_name);
195:
196: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
197: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_loader_launch_pkg.main_process.exception','After Calling method igf_ap_matching_process_pkg.get_msg_class_from_filename' );
198: END IF;
199:
200: -- validate that the filename derived is a valid message class
201: -- It is assumed that the file name would be the same as the message class.
212: -- End of parameter Validation
213: ------------------------------------------------
214:
215: -- since the filename validation is successful, launch the ISIR Loader process
216: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
217: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_loader_launch_pkg.main_process.exception','Before Calling method fnd_request.submit_request' );
218: END IF;
219: l_req_id := FND_REQUEST.SUBMIT_REQUEST
220: ('IGF',
213: ------------------------------------------------
214:
215: -- since the filename validation is successful, launch the ISIR Loader process
216: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
217: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_loader_launch_pkg.main_process.exception','Before Calling method fnd_request.submit_request' );
218: END IF;
219: l_req_id := FND_REQUEST.SUBMIT_REQUEST
220: ('IGF',
221: 'IGFAPX06',
237: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
238: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
239: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
240:
241: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
242: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_loader_launch_pkg.main_process.exception','After Calling method fnd_request.submit_request' );
243: END IF;
244:
245: IF l_req_id > 0 THEN
238: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
239: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
240:
241: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
242: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_loader_launch_pkg.main_process.exception','After Calling method fnd_request.submit_request' );
243: END IF;
244:
245: IF l_req_id > 0 THEN
246: fnd_message.set_name('IGF','IGF_AP_INT_LDR_PROC_SBMIT');