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.IGS_AV_UNT_LGCY_PUB dependencies on IGS_AV_STND_UNIT_PKG

Line 810: IF igs_av_stnd_unit_pkg.get_pk_for_validation(x_av_stnd_unit_id => l_av_stnd_unit_lvl_id) THEN

806: CLOSE c_igs_av_stnd_unit_seq;
807:
808: mydebug('***** Got l_av_stnd_unit_lvl_id=' ||l_av_stnd_unit_lvl_id);
809: -- Primary key validation
810: IF igs_av_stnd_unit_pkg.get_pk_for_validation(x_av_stnd_unit_id => l_av_stnd_unit_lvl_id) THEN
811: FND_MESSAGE.SET_NAME('IGS','IGS_AV_STDUNT_ALREADY_EXISTS');
812: FND_MSG_PUB.ADD;
813: x_return_status := FALSE;
814: mydebug('validate_std_unt_db_cons IGS_AV_STND_UNIT_PKG.GET_PK_FOR_VALIDATION ');

Line 814: mydebug('validate_std_unt_db_cons IGS_AV_STND_UNIT_PKG.GET_PK_FOR_VALIDATION ');

810: IF igs_av_stnd_unit_pkg.get_pk_for_validation(x_av_stnd_unit_id => l_av_stnd_unit_lvl_id) THEN
811: FND_MESSAGE.SET_NAME('IGS','IGS_AV_STDUNT_ALREADY_EXISTS');
812: FND_MSG_PUB.ADD;
813: x_return_status := FALSE;
814: mydebug('validate_std_unt_db_cons IGS_AV_STND_UNIT_PKG.GET_PK_FOR_VALIDATION ');
815: RETURN x_return_status;
816: ELSE
817: p_av_stnd_unit_lvl_id :=l_av_stnd_unit_lvl_id;
818: END IF;

Line 1461: IF NOT IGS_AV_STND_UNIT_PKG.GET_PK_FOR_VALIDATION( x_av_stnd_unit_id => p_av_stnd_unit_id) THEN

1457: mydebug('validate_unt_bss_db_cons IGS_AV_UNT_BAS_PK_EXISTS ');
1458: END IF;
1459:
1460: -- Check Foreign key Validation with the table IGS_AV_STND_UNIT_ALL
1461: IF NOT IGS_AV_STND_UNIT_PKG.GET_PK_FOR_VALIDATION( x_av_stnd_unit_id => p_av_stnd_unit_id) THEN
1462: FND_MESSAGE.SET_NAME('IGS','IGS_AV_UNT_ALT_ID_FK_EXISTS');
1463: FND_MSG_PUB.ADD;
1464: x_return_status := FALSE;
1465: mydebug('validate_unt_bss_db_cons IGS_AV_UNT_ALT_ID_FK_EXISTS ');

Line 1714: mydebug('Before IGS_AV_STND_UNIT_PKG.GET_UK_FOR_VALIDATION');

1710: p_lgcy_adstunt_rec.exemption_institution_cd ,
1711: igs_ge_gen_003.get_org_id()
1712: );
1713: END IF; --IGS_AV_ADV_STANDING_PKG.GET_PK_FOR_VALIDATION
1714: mydebug('Before IGS_AV_STND_UNIT_PKG.GET_UK_FOR_VALIDATION');
1715: IF NOT IGS_AV_STND_UNIT_PKG.GET_UK_FOR_VALIDATION(
1716: x_person_id => l_person_id,
1717: x_exemption_institution_cd => p_lgcy_adstunt_rec.exemption_institution_cd,
1718: x_unit_details_id => l_unit_details_id,

Line 1715: IF NOT IGS_AV_STND_UNIT_PKG.GET_UK_FOR_VALIDATION(

1711: igs_ge_gen_003.get_org_id()
1712: );
1713: END IF; --IGS_AV_ADV_STANDING_PKG.GET_PK_FOR_VALIDATION
1714: mydebug('Before IGS_AV_STND_UNIT_PKG.GET_UK_FOR_VALIDATION');
1715: IF NOT IGS_AV_STND_UNIT_PKG.GET_UK_FOR_VALIDATION(
1716: x_person_id => l_person_id,
1717: x_exemption_institution_cd => p_lgcy_adstunt_rec.exemption_institution_cd,
1718: x_unit_details_id => l_unit_details_id,
1719: x_tst_rslt_dtls_id => l_tst_rslt_dtls_id,

Line 1959: mydebug('****IGS_AV_STND_UNIT_PKG.GET_UK_FOR_VALIDATION and s_adv_stnd_recognition_type <> PRECLUSION ');

1955: mydebug('Error 4');
1956: END IF; --validate_std_unt_db_cons
1957: ELSE
1958: IF p_lgcy_adstunt_rec.s_adv_stnd_recognition_type <> 'PRECLUSION' THEN
1959: mydebug('****IGS_AV_STND_UNIT_PKG.GET_UK_FOR_VALIDATION and s_adv_stnd_recognition_type <> PRECLUSION ');
1960: FND_MESSAGE.SET_NAME('IGS','IGS_AV_STDUNT_ALREADY_EXISTS');
1961: FND_MSG_PUB.ADD;
1962: RAISE duplicate_record_exists;
1963: END IF;

Line 1964: END IF; --IGS_AV_STND_UNIT_PKG.GET_UK_FOR_VALIDATION

1960: FND_MESSAGE.SET_NAME('IGS','IGS_AV_STDUNT_ALREADY_EXISTS');
1961: FND_MSG_PUB.ADD;
1962: RAISE duplicate_record_exists;
1963: END IF;
1964: END IF; --IGS_AV_STND_UNIT_PKG.GET_UK_FOR_VALIDATION
1965: mydebug('***** Preclusion *****');
1966: IF p_lgcy_adstunt_rec.s_adv_stnd_recognition_type = 'PRECLUSION' AND
1967: p_lgcy_adstunt_rec.alt_unit_cd IS NOT NULL AND
1968: p_lgcy_adstunt_rec.alt_version_number IS NOT NULL