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.IGR_IMP_001 dependencies on IGS_PE_RACE_INT

Line 1797: /* Validate the data in Self Service table igr_is_race for not null before inserting into igs_pe_race_int */

1793:
1794:
1795: --2775931 start
1796: FOR inq_per_race_rec IN inq_per_race_cur(inq_rec.inq_person_id) LOOP
1797: /* Validate the data in Self Service table igr_is_race for not null before inserting into igs_pe_race_int */
1798: /* Validate the data in Self Service table igr_is_race, race_cd column for value from lookup before inserting into igs_pe_race_int */
1799: validate_race_int(inq_per_race_rec,l_status,l_tokenstr);
1800: IF l_status = 1 THEN
1801: BEGIN

Line 1798: /* Validate the data in Self Service table igr_is_race, race_cd column for value from lookup before inserting into igs_pe_race_int */

1794:
1795: --2775931 start
1796: FOR inq_per_race_rec IN inq_per_race_cur(inq_rec.inq_person_id) LOOP
1797: /* Validate the data in Self Service table igr_is_race for not null before inserting into igs_pe_race_int */
1798: /* Validate the data in Self Service table igr_is_race, race_cd column for value from lookup before inserting into igs_pe_race_int */
1799: validate_race_int(inq_per_race_rec,l_status,l_tokenstr);
1800: IF l_status = 1 THEN
1801: BEGIN
1802: INSERT INTO igs_pe_race_int

Line 1802: INSERT INTO igs_pe_race_int

1798: /* Validate the data in Self Service table igr_is_race, race_cd column for value from lookup before inserting into igs_pe_race_int */
1799: validate_race_int(inq_per_race_rec,l_status,l_tokenstr);
1800: IF l_status = 1 THEN
1801: BEGIN
1802: INSERT INTO igs_pe_race_int
1803: (
1804: interface_race_id,
1805: interface_id,
1806: race_cd,

Line 1821: igs_pe_race_int_s.nextval ,

1817: last_update_date,
1818: last_update_login
1819: ) VALUES
1820: (
1821: igs_pe_race_int_s.nextval ,
1822: l_interface_id,
1823: inq_per_race_rec.race_cd,
1824: '2',
1825: null,

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

1835: null
1836: );
1837: EXCEPTION WHEN OTHERS THEN
1838: l_status:=0;
1839: fnd_file.put_line(fnd_file.log,'Insert on IGS_PE_RACE_INT failed '||SQLERRM);
1840: RAISE;
1841: END;
1842:
1843: UPDATE igr_is_race SET status = 'T' WHERE person_id = inq_rec.inq_person_id;

Line 1846: fnd_message.set_token('TABLE_NAME','igs_pe_race_int');

1842:
1843: UPDATE igr_is_race SET status = 'T' WHERE person_id = inq_rec.inq_person_id;
1844: ELSIF l_status = 2 THEN /* l_status = 0 i.e Validation failed due to lookup_code check */
1845: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
1846: fnd_message.set_token('TABLE_NAME','igs_pe_race_int');
1847: fnd_message.set_token('COL_NAMES',l_tokenstr);
1848: fnd_message.set_token('ID',inq_rec.inq_person_id);
1849: fnd_file.put_line(fnd_file.log,fnd_message.get);
1850: RAISE null_validation_fails;

Line 1854: fnd_message.set_token('TABLE_NAME','igs_pe_race_int');

1850: RAISE null_validation_fails;
1851: ELSE /* l_status = 0 i.e Validation failed due to null check */
1852:
1853: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
1854: fnd_message.set_token('TABLE_NAME','igs_pe_race_int');
1855: fnd_message.set_token('COL_NAMES',l_tokenstr);
1856: fnd_message.set_token('ID',inq_rec.inq_person_id);
1857: fnd_file.put_line(fnd_file.log,fnd_message.get);
1858: