APPS.IGR_IMP_001 dependencies on IGS_AD_TEST_INT

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

1530: END IF;
1531: END LOOP;
1532:
1533: FOR inq_per_test_rec IN inq_per_test_cur(inq_rec.inq_person_id) LOOP
1534: /* Validate the data in Self Service table for not null before inseting into igs_ad_test_int */
1535: validate_test_int(inq_per_test_rec , l_status,l_tokenstr);
1536: IF l_status = 1 THEN /*Validation Successfull*/
1537: BEGIN
1538: INSERT INTO igs_ad_test_int

Line 1538: INSERT INTO igs_ad_test_int

1534: /* Validate the data in Self Service table for not null before inseting into igs_ad_test_int */
1535: validate_test_int(inq_per_test_rec , l_status,l_tokenstr);
1536: IF l_status = 1 THEN /*Validation Successfull*/
1537: BEGIN
1538: INSERT INTO igs_ad_test_int
1539: (
1540: interface_test_id ,
1541: interface_id ,
1542: admission_test_type ,

Line 1565: igs_ad_test_int_s.nextval,

1561: program_id ,
1562: program_update_date
1563: ) VALUES
1564: (
1565: igs_ad_test_int_s.nextval,
1566: l_interface_id ,
1567: inq_per_test_rec.admission_test_type,
1568: null ,
1569: inq_per_test_rec.test_date ,

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

1587: sysdate
1588: );
1589: EXCEPTION WHEN OTHERS THEN
1590: l_status:=0;
1591: fnd_file.put_line(fnd_file.log,'Insert on IGS_AD_TEST_INT failed '||SQLERRM);
1592: RAISE;
1593: END;
1594:
1595: UPDATE igr_is_test SET status = 'T' WHERE inq_person_id = inq_rec.inq_person_id;

Line 1598: fnd_message.set_token('TABLE_NAME','igs_ad_test_int');

1594:
1595: UPDATE igr_is_test SET status = 'T' WHERE inq_person_id = inq_rec.inq_person_id;
1596: ELSE /* l_status = 0 i.e Validation failed*/
1597: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
1598: fnd_message.set_token('TABLE_NAME','igs_ad_test_int');
1599: fnd_message.set_token('COL_NAMES',l_tokenstr);
1600: fnd_message.set_token('ID',inq_rec.inq_person_id);
1601: fnd_file.put_line(fnd_file.log,fnd_message.get);
1602: RAISE null_validation_fails;

Line 1660: igs_ad_test_int_s.currval ,

1656: fnd_global.prog_appl_id ,
1657: fnd_global.conc_program_id ,
1658: sysdate ,
1659: igs_ad_test_segs_int_s.nextval ,
1660: igs_ad_test_int_s.currval ,
1661: inq_per_test_rec.admission_test_type,
1662: inq_per_testseg_rec.test_segment_id ,
1663: inq_per_testseg_rec.test_score
1664: );