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 FND_MESSAGE

Line 737: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');

733: RAISE;
734: END;
735:
736: ELSE /* l_status = 0 ie Validation failed*/
737: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
738: fnd_message.set_token('TABLE_NAME','igs_ad_interface_all');
739: fnd_message.set_token('COL_NAMES',l_tokenstr);
740: fnd_message.set_token('ID',inq_rec.inq_person_id);
741: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 738: fnd_message.set_token('TABLE_NAME','igs_ad_interface_all');

734: END;
735:
736: ELSE /* l_status = 0 ie Validation failed*/
737: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
738: fnd_message.set_token('TABLE_NAME','igs_ad_interface_all');
739: fnd_message.set_token('COL_NAMES',l_tokenstr);
740: fnd_message.set_token('ID',inq_rec.inq_person_id);
741: fnd_file.put_line(fnd_file.log,fnd_message.get);
742: RAISE null_validation_fails;

Line 739: fnd_message.set_token('COL_NAMES',l_tokenstr);

735:
736: ELSE /* l_status = 0 ie Validation failed*/
737: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
738: fnd_message.set_token('TABLE_NAME','igs_ad_interface_all');
739: fnd_message.set_token('COL_NAMES',l_tokenstr);
740: fnd_message.set_token('ID',inq_rec.inq_person_id);
741: fnd_file.put_line(fnd_file.log,fnd_message.get);
742: RAISE null_validation_fails;
743: END IF;

Line 740: fnd_message.set_token('ID',inq_rec.inq_person_id);

736: ELSE /* l_status = 0 ie Validation failed*/
737: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
738: fnd_message.set_token('TABLE_NAME','igs_ad_interface_all');
739: fnd_message.set_token('COL_NAMES',l_tokenstr);
740: fnd_message.set_token('ID',inq_rec.inq_person_id);
741: fnd_file.put_line(fnd_file.log,fnd_message.get);
742: RAISE null_validation_fails;
743: END IF;
744:

Line 741: fnd_file.put_line(fnd_file.log,fnd_message.get);

737: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
738: fnd_message.set_token('TABLE_NAME','igs_ad_interface_all');
739: fnd_message.set_token('COL_NAMES',l_tokenstr);
740: fnd_message.set_token('ID',inq_rec.inq_person_id);
741: fnd_file.put_line(fnd_file.log,fnd_message.get);
742: RAISE null_validation_fails;
743: END IF;
744:
745: /* If atleast one of citizenship1_id and citizenship2_id is not null then Insert */

Line 991: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');

987: fnd_file.put_line(fnd_file.log,'Insert on IGR_I_APPL_INT failed '||SQLERRM);
988: RAISE;
989: END;
990: ELSE /* l_status = 0 i.e Validation failed*/
991: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
992: fnd_message.set_token('TABLE_NAME','igr_i_appl_int');
993: fnd_message.set_token('COL_NAMES',l_tokenstr);
994: fnd_message.set_token('ID',inq_rec.inq_person_id);
995: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 992: fnd_message.set_token('TABLE_NAME','igr_i_appl_int');

988: RAISE;
989: END;
990: ELSE /* l_status = 0 i.e Validation failed*/
991: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
992: fnd_message.set_token('TABLE_NAME','igr_i_appl_int');
993: fnd_message.set_token('COL_NAMES',l_tokenstr);
994: fnd_message.set_token('ID',inq_rec.inq_person_id);
995: fnd_file.put_line(fnd_file.log,fnd_message.get);
996: RAISE null_validation_fails;

Line 993: fnd_message.set_token('COL_NAMES',l_tokenstr);

989: END;
990: ELSE /* l_status = 0 i.e Validation failed*/
991: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
992: fnd_message.set_token('TABLE_NAME','igr_i_appl_int');
993: fnd_message.set_token('COL_NAMES',l_tokenstr);
994: fnd_message.set_token('ID',inq_rec.inq_person_id);
995: fnd_file.put_line(fnd_file.log,fnd_message.get);
996: RAISE null_validation_fails;
997: END IF;

Line 994: fnd_message.set_token('ID',inq_rec.inq_person_id);

990: ELSE /* l_status = 0 i.e Validation failed*/
991: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
992: fnd_message.set_token('TABLE_NAME','igr_i_appl_int');
993: fnd_message.set_token('COL_NAMES',l_tokenstr);
994: fnd_message.set_token('ID',inq_rec.inq_person_id);
995: fnd_file.put_line(fnd_file.log,fnd_message.get);
996: RAISE null_validation_fails;
997: END IF;
998:

Line 995: fnd_file.put_line(fnd_file.log,fnd_message.get);

991: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
992: fnd_message.set_token('TABLE_NAME','igr_i_appl_int');
993: fnd_message.set_token('COL_NAMES',l_tokenstr);
994: fnd_message.set_token('ID',inq_rec.inq_person_id);
995: fnd_file.put_line(fnd_file.log,fnd_message.get);
996: RAISE null_validation_fails;
997: END IF;
998:
999: /* if all the validations are successful so far update the Status of

Line 1230: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');

1226: RAISE;
1227: END;
1228:
1229: ELSE /* l_status = 0 i.e Validation failed*/
1230: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
1231: fnd_message.set_token('TABLE_NAME','igs_ad_addr_int');
1232: fnd_message.set_token('COL_NAMES',l_tokenstr);
1233: fnd_message.set_token('ID',inq_rec.inq_person_id);
1234: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 1231: fnd_message.set_token('TABLE_NAME','igs_ad_addr_int');

1227: END;
1228:
1229: ELSE /* l_status = 0 i.e Validation failed*/
1230: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
1231: fnd_message.set_token('TABLE_NAME','igs_ad_addr_int');
1232: fnd_message.set_token('COL_NAMES',l_tokenstr);
1233: fnd_message.set_token('ID',inq_rec.inq_person_id);
1234: fnd_file.put_line(fnd_file.log,fnd_message.get);
1235: RAISE null_validation_fails;

Line 1232: fnd_message.set_token('COL_NAMES',l_tokenstr);

1228:
1229: ELSE /* l_status = 0 i.e Validation failed*/
1230: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
1231: fnd_message.set_token('TABLE_NAME','igs_ad_addr_int');
1232: fnd_message.set_token('COL_NAMES',l_tokenstr);
1233: fnd_message.set_token('ID',inq_rec.inq_person_id);
1234: fnd_file.put_line(fnd_file.log,fnd_message.get);
1235: RAISE null_validation_fails;
1236: END IF;

Line 1233: fnd_message.set_token('ID',inq_rec.inq_person_id);

1229: ELSE /* l_status = 0 i.e Validation failed*/
1230: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
1231: fnd_message.set_token('TABLE_NAME','igs_ad_addr_int');
1232: fnd_message.set_token('COL_NAMES',l_tokenstr);
1233: fnd_message.set_token('ID',inq_rec.inq_person_id);
1234: fnd_file.put_line(fnd_file.log,fnd_message.get);
1235: RAISE null_validation_fails;
1236: END IF;
1237:

Line 1234: fnd_file.put_line(fnd_file.log,fnd_message.get);

1230: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
1231: fnd_message.set_token('TABLE_NAME','igs_ad_addr_int');
1232: fnd_message.set_token('COL_NAMES',l_tokenstr);
1233: fnd_message.set_token('ID',inq_rec.inq_person_id);
1234: fnd_file.put_line(fnd_file.log,fnd_message.get);
1235: RAISE null_validation_fails;
1236: END IF;
1237:
1238: validate_addrusage_int(inq_per_addr_rec, l_status,l_tokenstr);

Line 1289: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');

1285: END;
1286:
1287: UPDATE igr_is_address SET status = 'T' WHERE inq_person_id = inq_rec.inq_person_id;
1288: ELSE /* l_status = 0 i.e Validation failed*/
1289: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
1290: fnd_message.set_token('TABLE_NAME','igs_ad_addrusage_int');
1291: fnd_message.set_token('COL_NAMES',l_tokenstr);
1292: fnd_message.set_token('ID',inq_rec.inq_person_id);
1293: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 1290: fnd_message.set_token('TABLE_NAME','igs_ad_addrusage_int');

1286:
1287: UPDATE igr_is_address SET status = 'T' WHERE inq_person_id = inq_rec.inq_person_id;
1288: ELSE /* l_status = 0 i.e Validation failed*/
1289: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
1290: fnd_message.set_token('TABLE_NAME','igs_ad_addrusage_int');
1291: fnd_message.set_token('COL_NAMES',l_tokenstr);
1292: fnd_message.set_token('ID',inq_rec.inq_person_id);
1293: fnd_file.put_line(fnd_file.log,fnd_message.get);
1294: RAISE null_validation_fails;

Line 1291: fnd_message.set_token('COL_NAMES',l_tokenstr);

1287: UPDATE igr_is_address SET status = 'T' WHERE inq_person_id = inq_rec.inq_person_id;
1288: ELSE /* l_status = 0 i.e Validation failed*/
1289: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
1290: fnd_message.set_token('TABLE_NAME','igs_ad_addrusage_int');
1291: fnd_message.set_token('COL_NAMES',l_tokenstr);
1292: fnd_message.set_token('ID',inq_rec.inq_person_id);
1293: fnd_file.put_line(fnd_file.log,fnd_message.get);
1294: RAISE null_validation_fails;
1295: END IF;

Line 1292: fnd_message.set_token('ID',inq_rec.inq_person_id);

1288: ELSE /* l_status = 0 i.e Validation failed*/
1289: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
1290: fnd_message.set_token('TABLE_NAME','igs_ad_addrusage_int');
1291: fnd_message.set_token('COL_NAMES',l_tokenstr);
1292: fnd_message.set_token('ID',inq_rec.inq_person_id);
1293: fnd_file.put_line(fnd_file.log,fnd_message.get);
1294: RAISE null_validation_fails;
1295: END IF;
1296: END LOOP;

Line 1293: fnd_file.put_line(fnd_file.log,fnd_message.get);

1289: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
1290: fnd_message.set_token('TABLE_NAME','igs_ad_addrusage_int');
1291: fnd_message.set_token('COL_NAMES',l_tokenstr);
1292: fnd_message.set_token('ID',inq_rec.inq_person_id);
1293: fnd_file.put_line(fnd_file.log,fnd_message.get);
1294: RAISE null_validation_fails;
1295: END IF;
1296: END LOOP;
1297:

Line 1429: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');

1425: END;
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);

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;

Line 1431: fnd_message.set_token('COL_NAMES',l_tokenstr);

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;
1435: END IF;

Line 1432: fnd_message.set_token('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;
1435: END IF;
1436: END LOOP;

Line 1433: fnd_file.put_line(fnd_file.log,fnd_message.get);

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;
1435: END IF;
1436: END LOOP;
1437:

Line 1524: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');

1520: END;
1521:
1522: UPDATE igr_is_extracurr SET status = 'T' WHERE inq_person_id = inq_rec.inq_person_id;
1523: ELSE /* l_status = 0 i.e Validation failed*/
1524: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
1525: fnd_message.set_token('TABLE_NAME','igs_ad_excurr_int');
1526: fnd_message.set_token('COL_NAMES',l_tokenstr);
1527: fnd_message.set_token('ID',inq_rec.inq_person_id);
1528: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 1525: fnd_message.set_token('TABLE_NAME','igs_ad_excurr_int');

1521:
1522: UPDATE igr_is_extracurr SET status = 'T' WHERE inq_person_id = inq_rec.inq_person_id;
1523: ELSE /* l_status = 0 i.e Validation failed*/
1524: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
1525: fnd_message.set_token('TABLE_NAME','igs_ad_excurr_int');
1526: fnd_message.set_token('COL_NAMES',l_tokenstr);
1527: fnd_message.set_token('ID',inq_rec.inq_person_id);
1528: fnd_file.put_line(fnd_file.log,fnd_message.get);
1529: RAISE null_validation_fails;

Line 1526: fnd_message.set_token('COL_NAMES',l_tokenstr);

1522: UPDATE igr_is_extracurr SET status = 'T' WHERE inq_person_id = inq_rec.inq_person_id;
1523: ELSE /* l_status = 0 i.e Validation failed*/
1524: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
1525: fnd_message.set_token('TABLE_NAME','igs_ad_excurr_int');
1526: fnd_message.set_token('COL_NAMES',l_tokenstr);
1527: fnd_message.set_token('ID',inq_rec.inq_person_id);
1528: fnd_file.put_line(fnd_file.log,fnd_message.get);
1529: RAISE null_validation_fails;
1530: END IF;

Line 1527: fnd_message.set_token('ID',inq_rec.inq_person_id);

1523: ELSE /* l_status = 0 i.e Validation failed*/
1524: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
1525: fnd_message.set_token('TABLE_NAME','igs_ad_excurr_int');
1526: fnd_message.set_token('COL_NAMES',l_tokenstr);
1527: fnd_message.set_token('ID',inq_rec.inq_person_id);
1528: fnd_file.put_line(fnd_file.log,fnd_message.get);
1529: RAISE null_validation_fails;
1530: END IF;
1531: END LOOP;

Line 1528: fnd_file.put_line(fnd_file.log,fnd_message.get);

1524: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
1525: fnd_message.set_token('TABLE_NAME','igs_ad_excurr_int');
1526: fnd_message.set_token('COL_NAMES',l_tokenstr);
1527: fnd_message.set_token('ID',inq_rec.inq_person_id);
1528: fnd_file.put_line(fnd_file.log,fnd_message.get);
1529: RAISE null_validation_fails;
1530: END IF;
1531: END LOOP;
1532:

Line 1597: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');

1593: END;
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);

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 1599: fnd_message.set_token('COL_NAMES',l_tokenstr);

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;
1603: END IF;

Line 1600: fnd_message.set_token('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;
1603: END IF;
1604: /*For each of the record from main cursor process the records in this cursor */

Line 1601: fnd_file.put_line(fnd_file.log,fnd_message.get);

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;
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

Line 1674: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');

1670:
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);

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;

Line 1676: fnd_message.set_token('COL_NAMES',l_tokenstr);

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;
1680: END IF;

Line 1677: fnd_message.set_token('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;
1680: END IF;
1681: END LOOP; /* inner FOR LOOP is closed here */

Line 1678: fnd_file.put_line(fnd_file.log,fnd_message.get);

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;
1680: END IF;
1681: END LOOP; /* inner FOR LOOP is closed here */
1682: END LOOP; /* Outer FOR LOOP is closed here */

Line 1732: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');

1728: END;
1729:
1730: UPDATE igr_is_info_req SET status = 'T' WHERE inq_inq_id = inq_rec.inq_inq_id;
1731: ELSE /* l_status = 0 i.e Validation failed*/
1732: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
1733: fnd_message.set_token('TABLE_NAME','igs_ad_inq_pkg_int');
1734: fnd_message.set_token('COL_NAMES',l_tokenstr);
1735: fnd_message.set_token('ID',inq_rec.inq_person_id);
1736: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 1733: fnd_message.set_token('TABLE_NAME','igs_ad_inq_pkg_int');

1729:
1730: UPDATE igr_is_info_req SET status = 'T' WHERE inq_inq_id = inq_rec.inq_inq_id;
1731: ELSE /* l_status = 0 i.e Validation failed*/
1732: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
1733: fnd_message.set_token('TABLE_NAME','igs_ad_inq_pkg_int');
1734: fnd_message.set_token('COL_NAMES',l_tokenstr);
1735: fnd_message.set_token('ID',inq_rec.inq_person_id);
1736: fnd_file.put_line(fnd_file.log,fnd_message.get);
1737: RAISE null_validation_fails;

Line 1734: fnd_message.set_token('COL_NAMES',l_tokenstr);

1730: UPDATE igr_is_info_req SET status = 'T' WHERE inq_inq_id = inq_rec.inq_inq_id;
1731: ELSE /* l_status = 0 i.e Validation failed*/
1732: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
1733: fnd_message.set_token('TABLE_NAME','igs_ad_inq_pkg_int');
1734: fnd_message.set_token('COL_NAMES',l_tokenstr);
1735: fnd_message.set_token('ID',inq_rec.inq_person_id);
1736: fnd_file.put_line(fnd_file.log,fnd_message.get);
1737: RAISE null_validation_fails;
1738: END IF;

Line 1735: fnd_message.set_token('ID',inq_rec.inq_person_id);

1731: ELSE /* l_status = 0 i.e Validation failed*/
1732: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
1733: fnd_message.set_token('TABLE_NAME','igs_ad_inq_pkg_int');
1734: fnd_message.set_token('COL_NAMES',l_tokenstr);
1735: fnd_message.set_token('ID',inq_rec.inq_person_id);
1736: fnd_file.put_line(fnd_file.log,fnd_message.get);
1737: RAISE null_validation_fails;
1738: END IF;
1739: END LOOP;

Line 1736: fnd_file.put_line(fnd_file.log,fnd_message.get);

1732: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
1733: fnd_message.set_token('TABLE_NAME','igs_ad_inq_pkg_int');
1734: fnd_message.set_token('COL_NAMES',l_tokenstr);
1735: fnd_message.set_token('ID',inq_rec.inq_person_id);
1736: fnd_file.put_line(fnd_file.log,fnd_message.get);
1737: RAISE null_validation_fails;
1738: END IF;
1739: END LOOP;
1740:

Line 1845: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');

1841: END;
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);

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 1847: fnd_message.set_token('COL_NAMES',l_tokenstr);

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;
1851: ELSE /* l_status = 0 i.e Validation failed due to null check */

Line 1848: fnd_message.set_token('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;
1851: ELSE /* l_status = 0 i.e Validation failed due to null check */
1852:

Line 1849: fnd_file.put_line(fnd_file.log,fnd_message.get);

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;
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');

Line 1853: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');

1849: fnd_file.put_line(fnd_file.log,fnd_message.get);
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);

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:

Line 1855: fnd_message.set_token('COL_NAMES',l_tokenstr);

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:
1859: RAISE null_validation_fails;

Line 1856: fnd_message.set_token('ID',inq_rec.inq_person_id);

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:
1859: RAISE null_validation_fails;
1860: END IF;

Line 1857: fnd_file.put_line(fnd_file.log,fnd_message.get);

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:
1859: RAISE null_validation_fails;
1860: END IF;
1861: END LOOP;

Line 1895: fnd_message.set_name('IGS','IGS_AD_STDATE_GT_ENDDATE_FAIL');

1891:
1892: EXCEPTION -- main block
1893: WHEN date_validation_fails THEN
1894: retcode:=2;
1895: fnd_message.set_name('IGS','IGS_AD_STDATE_GT_ENDDATE_FAIL');
1896: igs_ge_msg_stack.add;
1897: fnd_file.put_line(fnd_file.log,fnd_message.get);
1898:
1899: WHEN OTHERS THEN

Line 1897: fnd_file.put_line(fnd_file.log,fnd_message.get);

1893: WHEN date_validation_fails THEN
1894: retcode:=2;
1895: fnd_message.set_name('IGS','IGS_AD_STDATE_GT_ENDDATE_FAIL');
1896: igs_ge_msg_stack.add;
1897: fnd_file.put_line(fnd_file.log,fnd_message.get);
1898:
1899: WHEN OTHERS THEN
1900: ROLLBACK;
1901: retcode:=2;

Line 1902: ERRBUF := FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');

1898:
1899: WHEN OTHERS THEN
1900: ROLLBACK;
1901: retcode:=2;
1902: ERRBUF := FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
1903: Igs_Ge_Msg_Stack.CONC_EXCEPTION_HNDL;
1904:
1905: END trn_ss_inq_int_data;
1906: END IGR_IMP_001; --End of Package