APPS.IGR_IMP_001 dependencies on IGS_AD_ACADHIS_INT

Line 1300: /* Validate the data in Self Service table for not null before inseting into igs_ad_acadhis_int */

1296: END LOOP;
1297:
1298:
1299: FOR inq_per_acad_rec IN inq_per_acad_cur(inq_rec.inq_person_id) LOOP
1300: /* Validate the data in Self Service table for not null before inseting into igs_ad_acadhis_int */
1301: validate_acadhis_int(inq_per_acad_rec,l_status,l_tokenstr);
1302: IF l_status = 1 THEN
1303: BEGIN
1304: INSERT INTO igs_ad_acadhis_int

Line 1304: INSERT INTO igs_ad_acadhis_int

1300: /* Validate the data in Self Service table for not null before inseting into igs_ad_acadhis_int */
1301: validate_acadhis_int(inq_per_acad_rec,l_status,l_tokenstr);
1302: IF l_status = 1 THEN
1303: BEGIN
1304: INSERT INTO igs_ad_acadhis_int
1305: (
1306: org_id ,
1307: attribute9 ,
1308: attribute10 ,

Line 1394: igs_ad_acadhis_int_s.nextval ,

1390: fnd_global.prog_appl_id ,
1391: fnd_global.conc_program_id ,
1392: sysdate ,
1393: null ,
1394: igs_ad_acadhis_int_s.nextval ,
1395: l_interface_id ,
1396: inq_per_acad_rec.institution_cd ,
1397: inq_per_acad_rec.current_inst ,
1398: null ,

Line 1423: fnd_file.put_line(fnd_file.log,'Insert on IGS_AD_ACADHIS_INT failed '||SQLERRM);

1419: inq_per_acad_rec.selfrep_classsize
1420: );
1421: EXCEPTION WHEN OTHERS THEN
1422: l_status:=0;
1423: fnd_file.put_line(fnd_file.log,'Insert on IGS_AD_ACADHIS_INT failed '||SQLERRM);
1424: RAISE;
1425: END;
1426:
1427: UPDATE igr_is_acad SET status = 'T' WHERE inq_person_id = inq_rec.inq_person_id;

Line 1430: fnd_message.set_token('TABLE_NAME','igs_ad_acadhis_int');

1426:
1427: UPDATE igr_is_acad SET status = 'T' WHERE inq_person_id = inq_rec.inq_person_id;
1428: ELSE /* l_status = 0 i.e Validation failed*/
1429: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
1430: fnd_message.set_token('TABLE_NAME','igs_ad_acadhis_int');
1431: fnd_message.set_token('COL_NAMES',l_tokenstr);
1432: fnd_message.set_token('ID',inq_rec.inq_person_id);
1433: fnd_file.put_line(fnd_file.log,fnd_message.get);
1434: RAISE null_validation_fails;