DBA Data[Home] [Help]

APPS.IGS_OR_INST_IMP_002 dependencies on FND_MESSAGE

Line 130: FND_MESSAGE.Set_Name('IGS','IGS_OR_INST_IMP_FAIL');

126: IF l_return_status IN ('E','U') THEN
127: --Log a message to the Log File that the Create of Organisation failed
128:
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',

Line 131: FND_MESSAGE.Set_Token('INT_ID',p_inst_rec.interface_id);

127: --Log a message to the Log File that the Create of Organisation failed
128:
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);

Line 132: FND_MESSAGE.Set_Token('ERROR_CODE',' ');

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

Line 135: FND_MESSAGE.Get || '-' || l_msg_data ,NULL,NULL,NULL,NULL,NULL,IGS_OR_INST_IMP_001.g_request_id);

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

Line 202: FND_MESSAGE.Get||'-'||SQLERRM,NULL,NULL,NULL,NULL,NULL,IGS_OR_INST_IMP_001.g_request_id);

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

Line 210: FND_MESSAGE.Set_Name('IGS','IGS_OR_INST_IMP_FAIL');

206:
207: ELSE -- l_success = N
208: --Log a message to the Log File that the Create of Institution failed
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',

Line 211: FND_MESSAGE.Set_Token('INT_ID',p_inst_rec.interface_id);

207: ELSE -- l_success = N
208: --Log a message to the Log File that the Create of Institution failed
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);

Line 212: FND_MESSAGE.Set_Token('ERROR_CODE',' ');

208: --Log a message to the Log File that the Create of Institution failed
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;

Line 215: FND_MESSAGE.Get || '-' || l_msg_data ,NULL,NULL,NULL,NULL,NULL,IGS_OR_INST_IMP_001.g_request_id);

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;
219: p_errind := 'Y';

Line 225: FND_MESSAGE.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

221:
222: 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);

Line 226: FND_MESSAGE.Set_Token('NAME','IMP_OR_INSTITUTION.create_institution');

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

Line 229: FND_MESSAGE.Get||'-'||SQLERRM,NULL,NULL,NULL,NULL,NULL,IGS_OR_INST_IMP_001.g_request_id);

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

Line 274: FND_MESSAGE.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

270: p_errind := 'N';
271: 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);

Line 275: FND_MESSAGE.Set_Token('NAME','IMP_OR_INSTITUTION.create_crosswalk_master');

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

Line 278: FND_MESSAGE.Get||'-'||SQLERRM,NULL,NULL,NULL,NULL,NULL,IGS_OR_INST_IMP_001.g_request_id);

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:
282: END create_crosswalk_master;

Line 331: FND_MESSAGE.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

327: p_errind := 'N';
328: 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);

Line 332: FND_MESSAGE.Set_Token('NAME','IMP_OR_INSTITUTION.create_crosswalk_detail');

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

Line 335: FND_MESSAGE.Get||'-'||SQLERRM,NULL,NULL,NULL,NULL,NULL,IGS_OR_INST_IMP_001.g_request_id);

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

Line 425: FND_MESSAGE.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

421: WHEN OTHERS THEN
422: p_error_code := 'E005';
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,

Line 426: FND_MESSAGE.Set_Token('NAME','IMP_OR_INSTITUTION.create_alternate_id');

422: p_error_code := 'E005';
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);

Line 429: FND_MESSAGE.Get ||'-' || p_instcd || '-' || p_altidtype || '-' || p_altidval || SQLERRM,

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:
433: END create_alternate_id;

Line 535: FND_MESSAGE.Set_Name('IGS','IGS_OR_INST_IMP_FAIL');

531: );
532:
533: IF l_return_status IN ('E','U') THEN
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',

Line 536: FND_MESSAGE.Set_Token('INT_ID',p_instrec.interface_id);

532:
533: IF l_return_status IN ('E','U') THEN
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);

Line 537: FND_MESSAGE.Set_Token('ERROR_CODE',' ');

533: IF l_return_status IN ('E','U') THEN
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;

Line 540: FND_MESSAGE.Get || '-' || l_msg_data ,NULL,NULL,NULL,NULL,NULL,IGS_OR_INST_IMP_001.g_request_id);

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';
544: p_error_text:= l_msg_data;

Line 609: FND_MESSAGE.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

605: END IF;
606: 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);

Line 610: FND_MESSAGE.Set_Token('NAME','IMP_OR_INSTITUTION.Update Institution');

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

Line 613: FND_MESSAGE.Get||'-'||SQLERRM,NULL,NULL,NULL,NULL,NULL,IGS_OR_INST_IMP_001.g_request_id);

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

Line 662: FND_MESSAGE.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

658:
659: 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);

Line 663: FND_MESSAGE.Set_Token('NAME','IMP_OR_INSTITUTION.Update Crosswalk Master');

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

Line 666: FND_MESSAGE.Get||'-'||SQLERRM,NULL,NULL,NULL,NULL,NULL,IGS_OR_INST_IMP_001.g_request_id);

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

Line 702: FND_MESSAGE.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

698: EXCEPTION
699: WHEN OTHERS THEN
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);

Line 703: FND_MESSAGE.Set_Token('NAME','IMP_OR_INSTITUTION.Auto Generate Logic');

699: WHEN OTHERS THEN
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;

Line 706: FND_MESSAGE.Get||'-'||SQLERRM,NULL,NULL,NULL,NULL,NULL,IGS_OR_INST_IMP_001.g_request_id);

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:
710: END autoGenerateLogic;