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_ADV_STANDING_PKG

Line 837: -- Foreign Key with Table IGS_AV_ADV_STANDING_PKG

833: FND_MSG_PUB.ADD;
834: x_return_status := FALSE;
835: mydebug('validate_std_unt_db_cons p_tst_rslt_dtls_id ');
836: END IF;
837: -- Foreign Key with Table IGS_AV_ADV_STANDING_PKG
838: IF NOT igs_av_adv_standing_pkg.get_pk_for_validation(
839: x_person_id => p_person_id ,
840: x_course_cd => p_lgcy_adstunt_rec.program_cd,
841: x_version_number => p_as_version_number ,

Line 838: IF NOT igs_av_adv_standing_pkg.get_pk_for_validation(

834: x_return_status := FALSE;
835: mydebug('validate_std_unt_db_cons p_tst_rslt_dtls_id ');
836: END IF;
837: -- Foreign Key with Table IGS_AV_ADV_STANDING_PKG
838: IF NOT igs_av_adv_standing_pkg.get_pk_for_validation(
839: x_person_id => p_person_id ,
840: x_course_cd => p_lgcy_adstunt_rec.program_cd,
841: x_version_number => p_as_version_number ,
842: x_exemption_institution_cd => p_lgcy_adstunt_rec.exemption_institution_cd

Line 847: mydebug('validate_std_unt_db_cons IGS_AV_ADV_STANDING_PKG.GET_PK_FOR_VALIDATION ');

843: ) THEN
844: FND_MESSAGE.SET_NAME('IGS','IGS_AV_NO_ADV_STND_DET_EXIST');
845: FND_MSG_PUB.ADD;
846: x_return_status := FALSE;
847: mydebug('validate_std_unt_db_cons IGS_AV_ADV_STANDING_PKG.GET_PK_FOR_VALIDATION ');
848: END IF;
849: -- Foreign Key with AUTHORIZING_PERSON_ID exists in table IGS_PE_PERSON
850: IF p_auth_pers_id IS NULL THEN
851: FND_MESSAGE.SET_NAME('IGS','IGS_AV_INVALID_PERS_AUTH_NUM');

Line 1676: mydebug('Before IGS_AV_ADV_STANDING_PKG.GET_PK_FOR_VALIDATION');

1672: p_person_id => l_person_id ,
1673: p_version_number => l_as_version_number,
1674: p_lgcy_adstunt_rec => p_lgcy_adstunt_rec
1675: ) THEN
1676: mydebug('Before IGS_AV_ADV_STANDING_PKG.GET_PK_FOR_VALIDATION');
1677: -- Validate that the current record is already present in the tables IGS_AV_ADV_STANDING_ALL and IGS_AV_STND_UNIT_ALL
1678: IF NOT igs_av_adv_standing_pkg.get_pk_for_validation(
1679: x_person_id => l_person_id,
1680: x_course_cd => p_lgcy_adstunt_rec.program_cd ,

Line 1678: IF NOT igs_av_adv_standing_pkg.get_pk_for_validation(

1674: p_lgcy_adstunt_rec => p_lgcy_adstunt_rec
1675: ) THEN
1676: mydebug('Before IGS_AV_ADV_STANDING_PKG.GET_PK_FOR_VALIDATION');
1677: -- Validate that the current record is already present in the tables IGS_AV_ADV_STANDING_ALL and IGS_AV_STND_UNIT_ALL
1678: IF NOT igs_av_adv_standing_pkg.get_pk_for_validation(
1679: x_person_id => l_person_id,
1680: x_course_cd => p_lgcy_adstunt_rec.program_cd ,
1681: x_version_number => l_as_version_number,
1682: x_exemption_institution_cd => p_lgcy_adstunt_rec.exemption_institution_cd

Line 1713: END IF; --IGS_AV_ADV_STANDING_PKG.GET_PK_FOR_VALIDATION

1709: p_lgcy_adstunt_rec.total_exmptn_perc_grntd,
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,