332: ELSIF lv_return_status = 'U' THEN
333: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
334: l_label := 'igs.plsql.igr_imp_003.process_person_inquiry.exception '||'E322';
335:
336: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
337: fnd_message.set_token('CONTEXT',p_inquiry_dtls_rec.interface_inq_appl_id);
338: fnd_message.set_token('ERROR', l_error_text);
339:
340: l_debug_str := fnd_message.get;
333: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
334: l_label := 'igs.plsql.igr_imp_003.process_person_inquiry.exception '||'E322';
335:
336: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
337: fnd_message.set_token('CONTEXT',p_inquiry_dtls_rec.interface_inq_appl_id);
338: fnd_message.set_token('ERROR', l_error_text);
339:
340: l_debug_str := fnd_message.get;
341:
334: l_label := 'igs.plsql.igr_imp_003.process_person_inquiry.exception '||'E322';
335:
336: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
337: fnd_message.set_token('CONTEXT',p_inquiry_dtls_rec.interface_inq_appl_id);
338: fnd_message.set_token('ERROR', l_error_text);
339:
340: l_debug_str := fnd_message.get;
341:
342: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
336: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
337: fnd_message.set_token('CONTEXT',p_inquiry_dtls_rec.interface_inq_appl_id);
338: fnd_message.set_token('ERROR', l_error_text);
339:
340: l_debug_str := fnd_message.get;
341:
342: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
343: END IF;
344: END IF;
1238: ELSIF lv_return_status = 'U' THEN
1239:
1240: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1241: l_label := 'igs.plsql.igr_imp_003.process_inquiry_lines.exception '||'E322';
1242: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
1243: fnd_message.set_token('CONTEXT',v_inquiry_lines_rec.interface_lines_id);
1244: fnd_message.set_token('ERROR', l_error_text);
1245: l_debug_str := fnd_message.get;
1246: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1239:
1240: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1241: l_label := 'igs.plsql.igr_imp_003.process_inquiry_lines.exception '||'E322';
1242: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
1243: fnd_message.set_token('CONTEXT',v_inquiry_lines_rec.interface_lines_id);
1244: fnd_message.set_token('ERROR', l_error_text);
1245: l_debug_str := fnd_message.get;
1246: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1247: END IF;
1240: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1241: l_label := 'igs.plsql.igr_imp_003.process_inquiry_lines.exception '||'E322';
1242: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
1243: fnd_message.set_token('CONTEXT',v_inquiry_lines_rec.interface_lines_id);
1244: fnd_message.set_token('ERROR', l_error_text);
1245: l_debug_str := fnd_message.get;
1246: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1247: END IF;
1248:
1241: l_label := 'igs.plsql.igr_imp_003.process_inquiry_lines.exception '||'E322';
1242: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
1243: fnd_message.set_token('CONTEXT',v_inquiry_lines_rec.interface_lines_id);
1244: fnd_message.set_token('ERROR', l_error_text);
1245: l_debug_str := fnd_message.get;
1246: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1247: END IF;
1248:
1249: END IF;