APPS.IGR_IMP_001 dependencies on IGS_AD_TEST_SEGS_INT

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

1602: RAISE null_validation_fails;
1603: END IF;
1604: /*For each of the record from main cursor process the records in this cursor */
1605: FOR inq_per_testseg_rec IN INQ_PER_TESTSEG_CUR(inq_per_test_rec.inq_test_id) LOOP
1606: /* Validate the data in Self Service table for not null before inseting into igs_ad_test_segs_int */
1607: validate_test_segs_int(inq_per_testseg_rec, l_status,l_tokenstr);
1608: IF l_status = 1 THEN
1609: BEGIN
1610: INSERT INTO igs_ad_test_segs_int

Line 1610: INSERT INTO igs_ad_test_segs_int

1606: /* Validate the data in Self Service table for not null before inseting into igs_ad_test_segs_int */
1607: validate_test_segs_int(inq_per_testseg_rec, l_status,l_tokenstr);
1608: IF l_status = 1 THEN
1609: BEGIN
1610: INSERT INTO igs_ad_test_segs_int
1611: (
1612: percentile ,
1613: national_percentile ,
1614: state_percentile ,

Line 1659: igs_ad_test_segs_int_s.nextval ,

1655: fnd_global.conc_request_id ,
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

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

1663: inq_per_testseg_rec.test_score
1664: );
1665: EXCEPTION WHEN OTHERS THEN
1666: l_status:=0;
1667: fnd_file.put_line(fnd_file.log,'Insert on IGS_AD_TEST_SEGS_INT failed '||SQLERRM);
1668: RAISE;
1669: END;
1670:
1671: /* After Successful Insertion Update the corresponding Self Service table with STATUS as 'T' */

Line 1675: fnd_message.set_token('TABLE_NAME','igs_ad_test_segs_int');

1671: /* After Successful Insertion Update the corresponding Self Service table with STATUS as 'T' */
1672: UPDATE igr_is_testseg SET status = 'T' WHERE inq_test_id = inq_per_test_rec.inq_test_id;
1673: ELSE /* l_status = 0 i.e Validation failed*/
1674: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
1675: fnd_message.set_token('TABLE_NAME','igs_ad_test_segs_int');
1676: fnd_message.set_token('COL_NAMES',l_tokenstr);
1677: fnd_message.set_token('ID',inq_per_test_rec.inq_test_id);
1678: fnd_file.put_line(fnd_file.log,fnd_message.get);
1679: RAISE null_validation_fails;