DBA Data[Home] [Help]

APPS.IGF_AP_LOADER_LAUNCH_PKG dependencies on FND_LOG

Line 152: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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);

Line 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' );

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:

Line 158: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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;

Line 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' );

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;

Line 190: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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);

Line 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' );

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:

Line 196: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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

Line 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' );

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.

Line 216: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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',

Line 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' );

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',

Line 241: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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

Line 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' );

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');