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.

APPS.IGS_OR_INST_IMP_002 dependencies on IGS_OR_INST_IMP_002

Line 1: PACKAGE BODY IGS_OR_INST_IMP_002 AS

1: PACKAGE BODY IGS_OR_INST_IMP_002 AS
2: /* $Header: IGSOR15B.pls 120.2 2005/09/28 00:21:48 appldev ship $ */
3: /* Change History
4: | who when what
5:

Line 134: 'igs.plsql.igs_or_inst_imp_002.create_institution.retstatfail',

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:
138:

Line 201: 'igs.plsql.igs_or_inst_imp_002.create_institution.exc1',

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;
205: END IF;

Line 214: 'igs.plsql.igs_or_inst_imp_002.create_institution.autogenfail',

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;
218: p_error_text:=NULL;

Line 228: 'igs.plsql.igs_or_inst_imp_002.create_institution.exc2',

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:
232: p_error_code:= 'E003';

Line 277: 'igs.plsql.igs_or_inst_imp_002.create_crosswalk_master.others',

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';
281:

Line 334: 'igs.plsql.igs_or_inst_imp_002.create_crosswalk_detail.others',

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';
338: END create_crosswalk_detail;

Line 428: 'igs.plsql.igs_or_inst_imp_002.create_alternate_id.others',

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;
432:

Line 539: 'igs.plsql.igs_or_inst_imp_002.update_institution.updatefail',

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:
543: p_error_code:= 'E002';

Line 612: 'igs.plsql.igs_or_inst_imp_002.update_institution.addrowfail',

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:
616: p_error_code:= 'E002';

Line 665: 'igs.plsql.igs_or_inst_imp_002.update_crosswalk_master.others',

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';
669: END update_crosswalk_master;

Line 705: 'igs.plsql.igs_or_inst_imp_002.autoGenerateLogic.others',

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';
709:

Line 712: END IGS_OR_INST_IMP_002;

708: p_success := 'N';
709:
710: END autoGenerateLogic;
711:
712: END IGS_OR_INST_IMP_002;