302:
303: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
304: l_label := 'igs.plsql.igr_imp_004.create_inq_info.exception '||'E322';
305:
306: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
307: fnd_message.set_token('CONTEXT',p_inq_info_rec.interface_inq_info_id);
308: fnd_message.set_token('ERROR', l_error_text);
309:
310: l_debug_str := fnd_message.get;
303: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
304: l_label := 'igs.plsql.igr_imp_004.create_inq_info.exception '||'E322';
305:
306: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
307: fnd_message.set_token('CONTEXT',p_inq_info_rec.interface_inq_info_id);
308: fnd_message.set_token('ERROR', l_error_text);
309:
310: l_debug_str := fnd_message.get;
311:
304: l_label := 'igs.plsql.igr_imp_004.create_inq_info.exception '||'E322';
305:
306: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
307: fnd_message.set_token('CONTEXT',p_inq_info_rec.interface_inq_info_id);
308: fnd_message.set_token('ERROR', l_error_text);
309:
310: l_debug_str := fnd_message.get;
311:
312: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,
306: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
307: fnd_message.set_token('CONTEXT',p_inq_info_rec.interface_inq_info_id);
308: fnd_message.set_token('ERROR', l_error_text);
309:
310: l_debug_str := fnd_message.get;
311:
312: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,
313: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
314: END IF;
563:
564: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
565: l_label := 'igs.plsql.igr_imp_004.create_inq_char.exception '||'E322';
566:
567: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
568: fnd_message.set_token('CONTEXT',p_inq_char_rec.interface_inq_char_id);
569: fnd_message.set_token('ERROR', l_error_text);
570:
571: l_debug_str := fnd_message.get;
564: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
565: l_label := 'igs.plsql.igr_imp_004.create_inq_char.exception '||'E322';
566:
567: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
568: fnd_message.set_token('CONTEXT',p_inq_char_rec.interface_inq_char_id);
569: fnd_message.set_token('ERROR', l_error_text);
570:
571: l_debug_str := fnd_message.get;
572:
565: l_label := 'igs.plsql.igr_imp_004.create_inq_char.exception '||'E322';
566:
567: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
568: fnd_message.set_token('CONTEXT',p_inq_char_rec.interface_inq_char_id);
569: fnd_message.set_token('ERROR', l_error_text);
570:
571: l_debug_str := fnd_message.get;
572:
573: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,
567: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
568: fnd_message.set_token('CONTEXT',p_inq_char_rec.interface_inq_char_id);
569: fnd_message.set_token('ERROR', l_error_text);
570:
571: l_debug_str := fnd_message.get;
572:
573: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,
574: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
575: END IF;
808: ELSIF lv_return_status = 'U' THEN
809: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
810: l_label := 'igs.plsql.igr_imp_004.create_inq_pkg.exception '||'E322';
811:
812: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
813: fnd_message.set_token('CONTEXT',p_inq_pkg_rec.interface_inq_pkg_id);
814: fnd_message.set_token('ERROR', l_error_text);
815:
816: l_debug_str := fnd_message.get;
809: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
810: l_label := 'igs.plsql.igr_imp_004.create_inq_pkg.exception '||'E322';
811:
812: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
813: fnd_message.set_token('CONTEXT',p_inq_pkg_rec.interface_inq_pkg_id);
814: fnd_message.set_token('ERROR', l_error_text);
815:
816: l_debug_str := fnd_message.get;
817:
810: l_label := 'igs.plsql.igr_imp_004.create_inq_pkg.exception '||'E322';
811:
812: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
813: fnd_message.set_token('CONTEXT',p_inq_pkg_rec.interface_inq_pkg_id);
814: fnd_message.set_token('ERROR', l_error_text);
815:
816: l_debug_str := fnd_message.get;
817:
818: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
812: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
813: fnd_message.set_token('CONTEXT',p_inq_pkg_rec.interface_inq_pkg_id);
814: fnd_message.set_token('ERROR', l_error_text);
815:
816: l_debug_str := fnd_message.get;
817:
818: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
819: END IF;
820: END IF;