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_003_PKG dependencies on FND_MESSAGE

Line 33: b) In the WHEN OTHERS block, replaced FND_MESSAGE.GET with

29: Added the validation for contact party id in process_institution_contacts
30: ssawhney V2API OVN changes...igs_or_contacts + igs_or_phones.
31: ssaleem 22-SEP-2003 The following changes were done for IGS.L
32: a) passed values for create method as 'CREATE_IMPORT'
33: b) In the WHEN OTHERS block, replaced FND_MESSAGE.GET with
34: FND_MESSAGE.PARSE_ENCODED
35: c) Removed the check for 'IGS_AD_EVAL_XST_NO_PROSPCT'
36: d) Error code 'E162' is replaced with 'E049'
37: c) FND_FILE.PUT_LINE method calls replaced with

Line 34: FND_MESSAGE.PARSE_ENCODED

30: ssawhney V2API OVN changes...igs_or_contacts + igs_or_phones.
31: ssaleem 22-SEP-2003 The following changes were done for IGS.L
32: a) passed values for create method as 'CREATE_IMPORT'
33: b) In the WHEN OTHERS block, replaced FND_MESSAGE.GET with
34: FND_MESSAGE.PARSE_ENCODED
35: c) Removed the check for 'IGS_AD_EVAL_XST_NO_PROSPCT'
36: d) Error code 'E162' is replaced with 'E049'
37: c) FND_FILE.PUT_LINE method calls replaced with
38: logging mechanism using FND_LOG package

Line 119: FND_MESSAGE.SET_NAME('IGS','IGS_OR_INST_IMP_FAIL');

115:
116: --put this information about the failed record in the log file too
117: IF p_int_notes_rec.status = '3' THEN
118: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
119: FND_MESSAGE.SET_NAME('IGS','IGS_OR_INST_IMP_FAIL');
120: FND_MESSAGE.SET_TOKEN('INT_ID', p_int_notes_rec.interface_inst_notes_id);
121: FND_MESSAGE.SET_TOKEN('ERROR_CODE', p_err_cd);
122: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
123: 'igs.plsql.igs_or_inst_imp_003.process_institution_notes.' || p_err_cd,

Line 120: FND_MESSAGE.SET_TOKEN('INT_ID', p_int_notes_rec.interface_inst_notes_id);

116: --put this information about the failed record in the log file too
117: IF p_int_notes_rec.status = '3' THEN
118: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
119: FND_MESSAGE.SET_NAME('IGS','IGS_OR_INST_IMP_FAIL');
120: FND_MESSAGE.SET_TOKEN('INT_ID', p_int_notes_rec.interface_inst_notes_id);
121: FND_MESSAGE.SET_TOKEN('ERROR_CODE', p_err_cd);
122: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
123: 'igs.plsql.igs_or_inst_imp_003.process_institution_notes.' || p_err_cd,
124: FND_MESSAGE.GET,NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);

Line 121: FND_MESSAGE.SET_TOKEN('ERROR_CODE', p_err_cd);

117: IF p_int_notes_rec.status = '3' THEN
118: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
119: FND_MESSAGE.SET_NAME('IGS','IGS_OR_INST_IMP_FAIL');
120: FND_MESSAGE.SET_TOKEN('INT_ID', p_int_notes_rec.interface_inst_notes_id);
121: FND_MESSAGE.SET_TOKEN('ERROR_CODE', p_err_cd);
122: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
123: 'igs.plsql.igs_or_inst_imp_003.process_institution_notes.' || p_err_cd,
124: FND_MESSAGE.GET,NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
125: END IF;

Line 124: FND_MESSAGE.GET,NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);

120: FND_MESSAGE.SET_TOKEN('INT_ID', p_int_notes_rec.interface_inst_notes_id);
121: FND_MESSAGE.SET_TOKEN('ERROR_CODE', p_err_cd);
122: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
123: 'igs.plsql.igs_or_inst_imp_003.process_institution_notes.' || p_err_cd,
124: FND_MESSAGE.GET,NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
125: END IF;
126: END IF;
127: END update_int_notes;
128:

Line 266: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

262: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
263: END IF;
264: WHEN OTHERS THEN
265: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
266: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
267: FND_MESSAGE.SET_TOKEN('NAME','igs_or_inst_imp_003.process_institution_notes');
268:
269: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
270: 'igs.plsql.igs_or_inst_imp_003.process_institution_notes.others',

Line 267: FND_MESSAGE.SET_TOKEN('NAME','igs_or_inst_imp_003.process_institution_notes');

263: END IF;
264: WHEN OTHERS THEN
265: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
266: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
267: FND_MESSAGE.SET_TOKEN('NAME','igs_or_inst_imp_003.process_institution_notes');
268:
269: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
270: 'igs.plsql.igs_or_inst_imp_003.process_institution_notes.others',
271: FND_MESSAGE.Get || '-' || SQLERRM,

Line 271: FND_MESSAGE.Get || '-' || SQLERRM,

267: FND_MESSAGE.SET_TOKEN('NAME','igs_or_inst_imp_003.process_institution_notes');
268:
269: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
270: 'igs.plsql.igs_or_inst_imp_003.process_institution_notes.others',
271: FND_MESSAGE.Get || '-' || SQLERRM,
272: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
273: END IF;
274: APP_EXCEPTION.RAISE_EXCEPTION;
275: END process_institution_notes;

Line 424: FND_MESSAGE.SET_NAME('IGS','IGS_OR_INST_IMP_FAIL');

420:
421: --put this information about the failed record in the log file too
422: IF p_status ='3' THEN
423: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
424: FND_MESSAGE.SET_NAME('IGS','IGS_OR_INST_IMP_FAIL');
425: FND_MESSAGE.SET_TOKEN('INT_ID', p_interface_contacts_id);
426: FND_MESSAGE.SET_TOKEN('ERROR_CODE', p_err_code);
427: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
428: 'igs.plsql.igs_or_inst_imp_003.update_int_contact.' || p_err_code,

Line 425: FND_MESSAGE.SET_TOKEN('INT_ID', p_interface_contacts_id);

421: --put this information about the failed record in the log file too
422: IF p_status ='3' THEN
423: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
424: FND_MESSAGE.SET_NAME('IGS','IGS_OR_INST_IMP_FAIL');
425: FND_MESSAGE.SET_TOKEN('INT_ID', p_interface_contacts_id);
426: FND_MESSAGE.SET_TOKEN('ERROR_CODE', p_err_code);
427: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
428: 'igs.plsql.igs_or_inst_imp_003.update_int_contact.' || p_err_code,
429: FND_MESSAGE.GET,

Line 426: FND_MESSAGE.SET_TOKEN('ERROR_CODE', p_err_code);

422: IF p_status ='3' THEN
423: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
424: FND_MESSAGE.SET_NAME('IGS','IGS_OR_INST_IMP_FAIL');
425: FND_MESSAGE.SET_TOKEN('INT_ID', p_interface_contacts_id);
426: FND_MESSAGE.SET_TOKEN('ERROR_CODE', p_err_code);
427: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
428: 'igs.plsql.igs_or_inst_imp_003.update_int_contact.' || p_err_code,
429: FND_MESSAGE.GET,
430: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);

Line 429: FND_MESSAGE.GET,

425: FND_MESSAGE.SET_TOKEN('INT_ID', p_interface_contacts_id);
426: FND_MESSAGE.SET_TOKEN('ERROR_CODE', p_err_code);
427: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
428: 'igs.plsql.igs_or_inst_imp_003.update_int_contact.' || p_err_code,
429: FND_MESSAGE.GET,
430: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
431: END IF;
432: END IF;
433:

Line 501: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);

497: p_status := '3';
498:
499: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
500:
501: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);
502: -- The following code checks what message is returned from the API in case of an exception.
503: -- It notes the message name and puts the same in the log file
504: -- Added as per enhancement during Evaluate Applicant Qualifications and Make decisions build
505:

Line 509: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PROSPCT_XST_NO_EVAL');

505:
506: IF l_message_name = 'IGS_AD_PROSPCT_XST_NO_EVAL' THEN
507: p_error_code := 'E049';
508: -- write in log message that the evaluator already exists
509: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PROSPCT_XST_NO_EVAL');
510: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
511: 'igs.plsql.igs_or_inst_imp_003.associate_persontype.evalexst',
512: FND_MESSAGE.Get || '-' || SQLERRM,
513: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);

Line 512: FND_MESSAGE.Get || '-' || SQLERRM,

508: -- write in log message that the evaluator already exists
509: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PROSPCT_XST_NO_EVAL');
510: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
511: 'igs.plsql.igs_or_inst_imp_003.associate_persontype.evalexst',
512: FND_MESSAGE.Get || '-' || SQLERRM,
513: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
514:
515: ELSE
516: p_error_code := 'E049';

Line 518: FND_MESSAGE.SET_NAME('IGS','IGS_OR_ERROR_PERSONTYPE');

514:
515: ELSE
516: p_error_code := 'E049';
517: -- Write the warning to log file --
518: FND_MESSAGE.SET_NAME('IGS','IGS_OR_ERROR_PERSONTYPE');
519: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
520: 'igs.plsql.igs_or_inst_imp_003.associate_persontype.perstype',
521: FND_MESSAGE.Get || '-' || SQLERRM,
522: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);

Line 521: FND_MESSAGE.Get || '-' || SQLERRM,

517: -- Write the warning to log file --
518: FND_MESSAGE.SET_NAME('IGS','IGS_OR_ERROR_PERSONTYPE');
519: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
520: 'igs.plsql.igs_or_inst_imp_003.associate_persontype.perstype',
521: FND_MESSAGE.Get || '-' || SQLERRM,
522: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
523: END IF;
524:
525: END IF;

Line 610: FND_MESSAGE.SET_NAME('IGS','IGS_OR_INST_IMP_FAIL');

606:
607: --put this information about the failed record in the log file too
608: IF p_int_phones_rec.status='3' THEN
609: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
610: FND_MESSAGE.SET_NAME('IGS','IGS_OR_INST_IMP_FAIL');
611: FND_MESSAGE.SET_TOKEN('INT_ID', p_int_phones_rec.interface_inst_cont_phone_id);
612: FND_MESSAGE.SET_TOKEN('ERROR_CODE', p_err_cd);
613: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
614: 'igs.plsql.igs_or_inst_imp_003.update_int_phones.' || p_err_cd,

Line 611: FND_MESSAGE.SET_TOKEN('INT_ID', p_int_phones_rec.interface_inst_cont_phone_id);

607: --put this information about the failed record in the log file too
608: IF p_int_phones_rec.status='3' THEN
609: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
610: FND_MESSAGE.SET_NAME('IGS','IGS_OR_INST_IMP_FAIL');
611: FND_MESSAGE.SET_TOKEN('INT_ID', p_int_phones_rec.interface_inst_cont_phone_id);
612: FND_MESSAGE.SET_TOKEN('ERROR_CODE', p_err_cd);
613: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
614: 'igs.plsql.igs_or_inst_imp_003.update_int_phones.' || p_err_cd,
615: FND_MESSAGE.GET,

Line 612: FND_MESSAGE.SET_TOKEN('ERROR_CODE', p_err_cd);

608: IF p_int_phones_rec.status='3' THEN
609: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
610: FND_MESSAGE.SET_NAME('IGS','IGS_OR_INST_IMP_FAIL');
611: FND_MESSAGE.SET_TOKEN('INT_ID', p_int_phones_rec.interface_inst_cont_phone_id);
612: FND_MESSAGE.SET_TOKEN('ERROR_CODE', p_err_cd);
613: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
614: 'igs.plsql.igs_or_inst_imp_003.update_int_phones.' || p_err_cd,
615: FND_MESSAGE.GET,
616: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);

Line 615: FND_MESSAGE.GET,

611: FND_MESSAGE.SET_TOKEN('INT_ID', p_int_phones_rec.interface_inst_cont_phone_id);
612: FND_MESSAGE.SET_TOKEN('ERROR_CODE', p_err_cd);
613: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
614: 'igs.plsql.igs_or_inst_imp_003.update_int_phones.' || p_err_cd,
615: FND_MESSAGE.GET,
616: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
617: END IF;
618: END IF;
619: END update_int_phones;

Line 711: FND_MESSAGE.SET_NAME('IGS','IGS_OR_PHONEINSERT_ERROR');

707: int_phones_rec.status:='3';
708: update_int_phones(int_phones_rec,l_val_fail_err_cd,NULL);
709:
710: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
711: FND_MESSAGE.SET_NAME('IGS','IGS_OR_PHONEINSERT_ERROR');
712: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
713: 'igs.plsql.igs_or_inst_imp_003.process_contact_phones.' || l_val_fail_err_cd,
714: 'contact phone id: ' || l_phone_id || '-' || FND_MESSAGE.GET || '-' || l_msg_dt,
715: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);

Line 714: 'contact phone id: ' || l_phone_id || '-' || FND_MESSAGE.GET || '-' || l_msg_dt,

710: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
711: FND_MESSAGE.SET_NAME('IGS','IGS_OR_PHONEINSERT_ERROR');
712: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
713: 'igs.plsql.igs_or_inst_imp_003.process_contact_phones.' || l_val_fail_err_cd,
714: 'contact phone id: ' || l_phone_id || '-' || FND_MESSAGE.GET || '-' || l_msg_dt,
715: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
716: END IF;
717:
718: RAISE SKIP_PHONE;

Line 917: FND_MESSAGE.SET_NAME('IGS','IGS_OR_CONTUPDATE_ERROR');

913: int_cont_rec.status:='3';
914: Update_int_contact(int_cont_rec.status,int_cont_rec.interface_contacts_id,int_cont_rec.contact_party_id,l_val_fail_err_cd,NULL);
915:
916: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
917: FND_MESSAGE.SET_NAME('IGS','IGS_OR_CONTUPDATE_ERROR');
918: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
919: 'igs.plsql.igs_or_inst_imp_003.process_institution_contacts.' || l_val_fail_err_cd,
920: FND_MESSAGE.GET || '-' || l_msg_data,
921: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);

Line 920: FND_MESSAGE.GET || '-' || l_msg_data,

916: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
917: FND_MESSAGE.SET_NAME('IGS','IGS_OR_CONTUPDATE_ERROR');
918: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
919: 'igs.plsql.igs_or_inst_imp_003.process_institution_contacts.' || l_val_fail_err_cd,
920: FND_MESSAGE.GET || '-' || l_msg_data,
921: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
922: END IF;
923:
924: RAISE SKIP_CONTACT;

Line 1024: FND_MESSAGE.SET_NAME('IGS','IGS_OR_CONTINSERT_ERROR');

1020: int_cont_rec.status:='3';
1021: Update_int_contact(int_cont_rec.status,int_cont_rec.interface_contacts_id,int_cont_rec.contact_party_id,l_val_fail_err_cd,NULL);
1022:
1023: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
1024: FND_MESSAGE.SET_NAME('IGS','IGS_OR_CONTINSERT_ERROR');
1025: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1026: 'igs.plsql.igs_or_inst_imp_003.process_institution_contacts.' || l_val_fail_err_cd ,
1027: FND_MESSAGE.GET || '-' || l_msg_data,
1028: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);

Line 1027: FND_MESSAGE.GET || '-' || l_msg_data,

1023: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
1024: FND_MESSAGE.SET_NAME('IGS','IGS_OR_CONTINSERT_ERROR');
1025: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1026: 'igs.plsql.igs_or_inst_imp_003.process_institution_contacts.' || l_val_fail_err_cd ,
1027: FND_MESSAGE.GET || '-' || l_msg_data,
1028: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
1029: END IF;
1030:
1031: RAISE SKIP_CONTACT;

Line 1195: FND_MESSAGE.SET_NAME('IGS','IGS_OR_INST_IMP_FAIL');

1191:
1192: --put this information about the failed record in the log file too
1193: IF p_int_stat_rec.status='3' THEN
1194: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
1195: FND_MESSAGE.SET_NAME('IGS','IGS_OR_INST_IMP_FAIL');
1196: FND_MESSAGE.SET_TOKEN('INT_ID', p_int_stat_rec.interface_inst_stat_id);
1197: FND_MESSAGE.SET_TOKEN('ERROR_CODE', p_int_stat_rec.error_code);
1198: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1199: 'igs.plsql.igs_or_inst_imp_003.update_int_stat.' || p_int_stat_rec.error_code,

Line 1196: FND_MESSAGE.SET_TOKEN('INT_ID', p_int_stat_rec.interface_inst_stat_id);

1192: --put this information about the failed record in the log file too
1193: IF p_int_stat_rec.status='3' THEN
1194: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
1195: FND_MESSAGE.SET_NAME('IGS','IGS_OR_INST_IMP_FAIL');
1196: FND_MESSAGE.SET_TOKEN('INT_ID', p_int_stat_rec.interface_inst_stat_id);
1197: FND_MESSAGE.SET_TOKEN('ERROR_CODE', p_int_stat_rec.error_code);
1198: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1199: 'igs.plsql.igs_or_inst_imp_003.update_int_stat.' || p_int_stat_rec.error_code,
1200: FND_MESSAGE.GET,

Line 1197: FND_MESSAGE.SET_TOKEN('ERROR_CODE', p_int_stat_rec.error_code);

1193: IF p_int_stat_rec.status='3' THEN
1194: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
1195: FND_MESSAGE.SET_NAME('IGS','IGS_OR_INST_IMP_FAIL');
1196: FND_MESSAGE.SET_TOKEN('INT_ID', p_int_stat_rec.interface_inst_stat_id);
1197: FND_MESSAGE.SET_TOKEN('ERROR_CODE', p_int_stat_rec.error_code);
1198: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1199: 'igs.plsql.igs_or_inst_imp_003.update_int_stat.' || p_int_stat_rec.error_code,
1200: FND_MESSAGE.GET,
1201: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);

Line 1200: FND_MESSAGE.GET,

1196: FND_MESSAGE.SET_TOKEN('INT_ID', p_int_stat_rec.interface_inst_stat_id);
1197: FND_MESSAGE.SET_TOKEN('ERROR_CODE', p_int_stat_rec.error_code);
1198: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1199: 'igs.plsql.igs_or_inst_imp_003.update_int_stat.' || p_int_stat_rec.error_code,
1200: FND_MESSAGE.GET,
1201: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
1202: END IF;
1203: END IF;
1204:

Line 1222: FND_MESSAGE.SET_NAME('IGS','IGS_OR_INST_IMP_FAIL');

1218:
1219: --put this information about the failed record in the log file too
1220: IF p_int_stat_det_rec.status='3' THEN
1221: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
1222: FND_MESSAGE.SET_NAME('IGS','IGS_OR_INST_IMP_FAIL');
1223: FND_MESSAGE.SET_TOKEN('INT_ID', p_int_stat_det_rec.interface_inst_stat_dtl_id);
1224: FND_MESSAGE.SET_TOKEN('ERROR_CODE', p_int_stat_det_rec.error_code);
1225: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1226: 'igs.plsql.igs_or_inst_imp_003.update_int_stat_det.' || p_int_stat_det_rec.error_code,

Line 1223: FND_MESSAGE.SET_TOKEN('INT_ID', p_int_stat_det_rec.interface_inst_stat_dtl_id);

1219: --put this information about the failed record in the log file too
1220: IF p_int_stat_det_rec.status='3' THEN
1221: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
1222: FND_MESSAGE.SET_NAME('IGS','IGS_OR_INST_IMP_FAIL');
1223: FND_MESSAGE.SET_TOKEN('INT_ID', p_int_stat_det_rec.interface_inst_stat_dtl_id);
1224: FND_MESSAGE.SET_TOKEN('ERROR_CODE', p_int_stat_det_rec.error_code);
1225: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1226: 'igs.plsql.igs_or_inst_imp_003.update_int_stat_det.' || p_int_stat_det_rec.error_code,
1227: FND_MESSAGE.GET,

Line 1224: FND_MESSAGE.SET_TOKEN('ERROR_CODE', p_int_stat_det_rec.error_code);

1220: IF p_int_stat_det_rec.status='3' THEN
1221: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
1222: FND_MESSAGE.SET_NAME('IGS','IGS_OR_INST_IMP_FAIL');
1223: FND_MESSAGE.SET_TOKEN('INT_ID', p_int_stat_det_rec.interface_inst_stat_dtl_id);
1224: FND_MESSAGE.SET_TOKEN('ERROR_CODE', p_int_stat_det_rec.error_code);
1225: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1226: 'igs.plsql.igs_or_inst_imp_003.update_int_stat_det.' || p_int_stat_det_rec.error_code,
1227: FND_MESSAGE.GET,
1228: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);

Line 1227: FND_MESSAGE.GET,

1223: FND_MESSAGE.SET_TOKEN('INT_ID', p_int_stat_det_rec.interface_inst_stat_dtl_id);
1224: FND_MESSAGE.SET_TOKEN('ERROR_CODE', p_int_stat_det_rec.error_code);
1225: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1226: 'igs.plsql.igs_or_inst_imp_003.update_int_stat_det.' || p_int_stat_det_rec.error_code,
1227: FND_MESSAGE.GET,
1228: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
1229: END IF;
1230: END IF;
1231:

Line 1351: FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_LOCKED');

1347: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
1348: CLOSE cur_get_oss_stat_det;
1349:
1350: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
1351: FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_LOCKED');
1352: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1353: 'igs.plsql.igs_or_inst_imp_003.process_institution_statistics.recordlock1',
1354: FND_MESSAGE.GET || '-' || SQLERRM,
1355: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);

Line 1354: FND_MESSAGE.GET || '-' || SQLERRM,

1350: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
1351: FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_LOCKED');
1352: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1353: 'igs.plsql.igs_or_inst_imp_003.process_institution_statistics.recordlock1',
1354: FND_MESSAGE.GET || '-' || SQLERRM,
1355: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
1356: END IF;
1357:
1358: ROLLBACK TO stat_mast;

Line 1417: FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_LOCKED');

1413: EXCEPTION
1414: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
1415: CLOSE cur_get_oss_stat_det;
1416: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
1417: FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_LOCKED');
1418: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1419: 'igs.plsql.igs_or_inst_imp_003.process_institution_statistics.recordlock2',
1420: FND_MESSAGE.GET || '-' || SQLERRM,
1421: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);

Line 1420: FND_MESSAGE.GET || '-' || SQLERRM,

1416: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
1417: FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_LOCKED');
1418: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1419: 'igs.plsql.igs_or_inst_imp_003.process_institution_statistics.recordlock2',
1420: FND_MESSAGE.GET || '-' || SQLERRM,
1421: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
1422: END IF;
1423:
1424: --Rollback changes

Line 1482: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

1478: END IF;
1479:
1480: WHEN OTHERS THEN
1481: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
1482: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1483: FND_MESSAGE.SET_TOKEN('NAME','igs_or_inst_imp_003.process_institution_statistics');
1484: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1485: 'igs.plsql.igs_or_inst_imp_003.process_institution_statistics.others',
1486: FND_MESSAGE.GET || '-' || SQLERRM,

Line 1483: FND_MESSAGE.SET_TOKEN('NAME','igs_or_inst_imp_003.process_institution_statistics');

1479:
1480: WHEN OTHERS THEN
1481: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
1482: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1483: FND_MESSAGE.SET_TOKEN('NAME','igs_or_inst_imp_003.process_institution_statistics');
1484: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1485: 'igs.plsql.igs_or_inst_imp_003.process_institution_statistics.others',
1486: FND_MESSAGE.GET || '-' || SQLERRM,
1487: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);

Line 1486: FND_MESSAGE.GET || '-' || SQLERRM,

1482: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1483: FND_MESSAGE.SET_TOKEN('NAME','igs_or_inst_imp_003.process_institution_statistics');
1484: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1485: 'igs.plsql.igs_or_inst_imp_003.process_institution_statistics.others',
1486: FND_MESSAGE.GET || '-' || SQLERRM,
1487: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
1488: END IF;
1489:
1490: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1615: FND_MESSAGE.SET_NAME('IGS','IGS_OR_INST_IMP_FAIL');

1611:
1612: --put this information about the failed record in the log file too
1613: IF p_status='3' THEN
1614: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
1615: FND_MESSAGE.SET_NAME('IGS','IGS_OR_INST_IMP_FAIL');
1616: FND_MESSAGE.SET_TOKEN('INT_ID', p_addr_id);
1617: FND_MESSAGE.SET_TOKEN('ERROR_CODE', p_err_cd);
1618: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1619: 'igs.plsql.igs_or_inst_imp_003.update_address_int.' || p_err_cd,

Line 1616: FND_MESSAGE.SET_TOKEN('INT_ID', p_addr_id);

1612: --put this information about the failed record in the log file too
1613: IF p_status='3' THEN
1614: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
1615: FND_MESSAGE.SET_NAME('IGS','IGS_OR_INST_IMP_FAIL');
1616: FND_MESSAGE.SET_TOKEN('INT_ID', p_addr_id);
1617: FND_MESSAGE.SET_TOKEN('ERROR_CODE', p_err_cd);
1618: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1619: 'igs.plsql.igs_or_inst_imp_003.update_address_int.' || p_err_cd,
1620: FND_MESSAGE.GET,

Line 1617: FND_MESSAGE.SET_TOKEN('ERROR_CODE', p_err_cd);

1613: IF p_status='3' THEN
1614: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
1615: FND_MESSAGE.SET_NAME('IGS','IGS_OR_INST_IMP_FAIL');
1616: FND_MESSAGE.SET_TOKEN('INT_ID', p_addr_id);
1617: FND_MESSAGE.SET_TOKEN('ERROR_CODE', p_err_cd);
1618: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1619: 'igs.plsql.igs_or_inst_imp_003.update_address_int.' || p_err_cd,
1620: FND_MESSAGE.GET,
1621: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);

Line 1620: FND_MESSAGE.GET,

1616: FND_MESSAGE.SET_TOKEN('INT_ID', p_addr_id);
1617: FND_MESSAGE.SET_TOKEN('ERROR_CODE', p_err_cd);
1618: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1619: 'igs.plsql.igs_or_inst_imp_003.update_address_int.' || p_err_cd,
1620: FND_MESSAGE.GET,
1621: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
1622: END IF;
1623: END IF;
1624: END IF;

Line 1635: FND_MESSAGE.SET_NAME('IGS','IGS_OR_INST_IMP_FAIL');

1631:
1632: --put this information about the failed record in the log file too
1633: IF p_status='3' THEN
1634: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
1635: FND_MESSAGE.SET_NAME('IGS','IGS_OR_INST_IMP_FAIL');
1636: FND_MESSAGE.SET_TOKEN('INT_ID', p_addr_id);
1637: FND_MESSAGE.SET_TOKEN('ERROR_CODE', p_err_cd);
1638: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1639: 'igs.plsql.igs_or_inst_imp_003.update_address_int.' || p_err_cd,

Line 1636: FND_MESSAGE.SET_TOKEN('INT_ID', p_addr_id);

1632: --put this information about the failed record in the log file too
1633: IF p_status='3' THEN
1634: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
1635: FND_MESSAGE.SET_NAME('IGS','IGS_OR_INST_IMP_FAIL');
1636: FND_MESSAGE.SET_TOKEN('INT_ID', p_addr_id);
1637: FND_MESSAGE.SET_TOKEN('ERROR_CODE', p_err_cd);
1638: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1639: 'igs.plsql.igs_or_inst_imp_003.update_address_int.' || p_err_cd,
1640: FND_MESSAGE.GET,

Line 1637: FND_MESSAGE.SET_TOKEN('ERROR_CODE', p_err_cd);

1633: IF p_status='3' THEN
1634: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
1635: FND_MESSAGE.SET_NAME('IGS','IGS_OR_INST_IMP_FAIL');
1636: FND_MESSAGE.SET_TOKEN('INT_ID', p_addr_id);
1637: FND_MESSAGE.SET_TOKEN('ERROR_CODE', p_err_cd);
1638: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1639: 'igs.plsql.igs_or_inst_imp_003.update_address_int.' || p_err_cd,
1640: FND_MESSAGE.GET,
1641: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);

Line 1640: FND_MESSAGE.GET,

1636: FND_MESSAGE.SET_TOKEN('INT_ID', p_addr_id);
1637: FND_MESSAGE.SET_TOKEN('ERROR_CODE', p_err_cd);
1638: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1639: 'igs.plsql.igs_or_inst_imp_003.update_address_int.' || p_err_cd,
1640: FND_MESSAGE.GET,
1641: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
1642: END IF;
1643: END IF;
1644:

Line 1699: FND_MESSAGE.SET_NAME('IGS','IGS_OR_USG_INSERT');

1695: IF l_return_status IN ('E','U') THEN
1696: --Error while associating the Address Usage with the Address
1697:
1698: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
1699: FND_MESSAGE.SET_NAME('IGS','IGS_OR_USG_INSERT');
1700: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1701: 'igs.plsql.igs_or_inst_imp_003.insert_addr_usage.fail',
1702: FND_MESSAGE.GET || '-' || l_msg_data,
1703: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);

Line 1702: FND_MESSAGE.GET || '-' || l_msg_data,

1698: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
1699: FND_MESSAGE.SET_NAME('IGS','IGS_OR_USG_INSERT');
1700: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1701: 'igs.plsql.igs_or_inst_imp_003.insert_addr_usage.fail',
1702: FND_MESSAGE.GET || '-' || l_msg_data,
1703: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
1704: END IF;
1705:
1706: --Error in Address Record Status

Line 1830: FND_MESSAGE.SET_NAME('IGS','IGS_OR_ADDR_NO_INSERT');

1826: );
1827:
1828: IF l_return_status IN ('E','U') THEN
1829: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
1830: FND_MESSAGE.SET_NAME('IGS','IGS_OR_ADDR_NO_INSERT');
1831: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1832: 'igs.plsql.igs_or_inst_imp_003.process_institution_address.addrins',
1833: FND_MESSAGE.GET || '-' || l_msg_data,
1834: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);

Line 1833: FND_MESSAGE.GET || '-' || l_msg_data,

1829: IF (igs_or_inst_imp_001.gb_write_exception_log3) THEN
1830: FND_MESSAGE.SET_NAME('IGS','IGS_OR_ADDR_NO_INSERT');
1831: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1832: 'igs.plsql.igs_or_inst_imp_003.process_institution_address.addrins',
1833: FND_MESSAGE.GET || '-' || l_msg_data,
1834: NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
1835: END IF;
1836:
1837: ROLLBACK TO address;