eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_OR_INST_IMP_002 dependencies on FND_LOG

Line 26: | in FND_LOG package

22: | ssawhney 30-APR-2003 V2API - OVN implementation , create/update_institution procs modified
23: | vrathi 28-MAY-2003 Bug No: 2961982 Replaced update_row with add_row
24: | ssaleem 25-SEP-2003 IGS.L patch the following changes are made
25: | 1. Logging mechanism introduced, FND_FILE.PUT_LINE replaced with methods
26: | in FND_LOG package
27: | 2. Cursors that used variables in the SELECT statements were replaced with
28: | cursor parameters. Respective changes have been made in the places where
29: | the cursors are opened
30: | 3. In the import process, it is made sure that NULL values does not replace

Line 133: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,

129: IF IGS_OR_INST_IMP_001.gb_write_exception_log2 THEN
130: FND_MESSAGE.Set_Name('IGS','IGS_OR_INST_IMP_FAIL');
131: FND_MESSAGE.Set_Token('INT_ID',p_inst_rec.interface_id);
132: FND_MESSAGE.Set_Token('ERROR_CODE',' ');
133: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
134: 'igs.plsql.igs_or_inst_imp_002.create_institution.retstatfail',
135: FND_MESSAGE.Get || '-' || l_msg_data ,NULL,NULL,NULL,NULL,NULL,IGS_OR_INST_IMP_001.g_request_id);
136: END IF;
137:

Line 200: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,

196: p_error_text:= NULL;
197: p_errind := 'Y';
198:
199: IF IGS_OR_INST_IMP_001.gb_write_exception_log2 THEN
200: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
201: 'igs.plsql.igs_or_inst_imp_002.create_institution.exc1',
202: FND_MESSAGE.Get||'-'||SQLERRM,NULL,NULL,NULL,NULL,NULL,IGS_OR_INST_IMP_001.g_request_id);
203: END IF;
204: END;

Line 213: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,

209: IF IGS_OR_INST_IMP_001.gb_write_exception_log2 THEN
210: FND_MESSAGE.Set_Name('IGS','IGS_OR_INST_IMP_FAIL');
211: FND_MESSAGE.Set_Token('INT_ID',p_inst_rec.interface_id);
212: FND_MESSAGE.Set_Token('ERROR_CODE',' ');
213: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
214: 'igs.plsql.igs_or_inst_imp_002.create_institution.autogenfail',
215: FND_MESSAGE.Get || '-' || l_msg_data ,NULL,NULL,NULL,NULL,NULL,IGS_OR_INST_IMP_001.g_request_id);
216: END IF;
217: p_error_code:=l_err_cd;

Line 227: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,

223: WHEN OTHERS THEN
224: IF IGS_OR_INST_IMP_001.gb_write_exception_log2 THEN
225: FND_MESSAGE.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
226: FND_MESSAGE.Set_Token('NAME','IMP_OR_INSTITUTION.create_institution');
227: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
228: 'igs.plsql.igs_or_inst_imp_002.create_institution.exc2',
229: FND_MESSAGE.Get||'-'||SQLERRM,NULL,NULL,NULL,NULL,NULL,IGS_OR_INST_IMP_001.g_request_id);
230: END IF;
231:

Line 276: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,

272: WHEN OTHERS THEN
273: IF IGS_OR_INST_IMP_001.gb_write_exception_log2 THEN
274: FND_MESSAGE.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
275: FND_MESSAGE.Set_Token('NAME','IMP_OR_INSTITUTION.create_crosswalk_master');
276: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
277: 'igs.plsql.igs_or_inst_imp_002.create_crosswalk_master.others',
278: FND_MESSAGE.Get||'-'||SQLERRM,NULL,NULL,NULL,NULL,NULL,IGS_OR_INST_IMP_001.g_request_id);
279: END IF;
280: p_errind := 'Y';

Line 333: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,

329: WHEN OTHERS THEN
330: IF IGS_OR_INST_IMP_001.gb_write_exception_log2 THEN
331: FND_MESSAGE.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
332: FND_MESSAGE.Set_Token('NAME','IMP_OR_INSTITUTION.create_crosswalk_detail');
333: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
334: 'igs.plsql.igs_or_inst_imp_002.create_crosswalk_detail.others',
335: FND_MESSAGE.Get||'-'||SQLERRM,NULL,NULL,NULL,NULL,NULL,IGS_OR_INST_IMP_001.g_request_id);
336: END IF;
337: p_errind := 'Y';

Line 427: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,

423: p_errind := 'Y';
424: IF IGS_OR_INST_IMP_001.gb_write_exception_log2 THEN
425: FND_MESSAGE.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
426: FND_MESSAGE.Set_Token('NAME','IMP_OR_INSTITUTION.create_alternate_id');
427: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
428: 'igs.plsql.igs_or_inst_imp_002.create_alternate_id.others',
429: FND_MESSAGE.Get ||'-' || p_instcd || '-' || p_altidtype || '-' || p_altidval || SQLERRM,
430: NULL,NULL,NULL,NULL,NULL,IGS_OR_INST_IMP_001.g_request_id);
431: END IF;

Line 538: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,

534: IF IGS_OR_INST_IMP_001.gb_write_exception_log2 THEN
535: FND_MESSAGE.Set_Name('IGS','IGS_OR_INST_IMP_FAIL');
536: FND_MESSAGE.Set_Token('INT_ID',p_instrec.interface_id);
537: FND_MESSAGE.Set_Token('ERROR_CODE',' ');
538: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
539: 'igs.plsql.igs_or_inst_imp_002.update_institution.updatefail',
540: FND_MESSAGE.Get || '-' || l_msg_data ,NULL,NULL,NULL,NULL,NULL,IGS_OR_INST_IMP_001.g_request_id);
541: END IF;
542:

Line 611: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,

607: WHEN OTHERS THEN
608: IF IGS_OR_INST_IMP_001.gb_write_exception_log2 THEN
609: FND_MESSAGE.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
610: FND_MESSAGE.Set_Token('NAME','IMP_OR_INSTITUTION.Update Institution');
611: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
612: 'igs.plsql.igs_or_inst_imp_002.update_institution.addrowfail',
613: FND_MESSAGE.Get||'-'||SQLERRM,NULL,NULL,NULL,NULL,NULL,IGS_OR_INST_IMP_001.g_request_id);
614: END IF;
615:

Line 664: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,

660: WHEN OTHERS THEN
661: IF IGS_OR_INST_IMP_001.gb_write_exception_log2 THEN
662: FND_MESSAGE.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
663: FND_MESSAGE.Set_Token('NAME','IMP_OR_INSTITUTION.Update Crosswalk Master');
664: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
665: 'igs.plsql.igs_or_inst_imp_002.update_crosswalk_master.others',
666: FND_MESSAGE.Get||'-'||SQLERRM,NULL,NULL,NULL,NULL,NULL,IGS_OR_INST_IMP_001.g_request_id);
667: END IF;
668: p_errind := 'Y';

Line 704: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,

700:
701: IF IGS_OR_INST_IMP_001.gb_write_exception_log2 THEN
702: FND_MESSAGE.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
703: FND_MESSAGE.Set_Token('NAME','IMP_OR_INSTITUTION.Auto Generate Logic');
704: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
705: 'igs.plsql.igs_or_inst_imp_002.autoGenerateLogic.others',
706: FND_MESSAGE.Get||'-'||SQLERRM,NULL,NULL,NULL,NULL,NULL,IGS_OR_INST_IMP_001.g_request_id);
707: END IF;
708: p_success := 'N';