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_VAL_AS

Line 524: IF NOT igs_av_val_asuleb.advp_val_basis_year(

520: l_message_name VARCHAR2(30);
521: l_return_type VARCHAR2(100);
522: BEGIN
523: -- Validate that the value in the BASIS_YEAR is not more than the current year
524: IF NOT igs_av_val_asuleb.advp_val_basis_year(
525: p_basis_year => p_lgcy_adstunt_rec.basis_year,
526: p_course_cd => p_lgcy_adstunt_rec.program_cd,
527: p_version_number => p_version_number,
528: p_message_name => l_message_name,

Line 658: IF NOT igs_av_val_as.advp_val_as_crs

654: */
655: DECLARE
656: l_message_name VARCHAR2(2000);
657: BEGIN
658: IF NOT igs_av_val_as.advp_val_as_crs
659: (
660: p_person_id => p_person_id,
661: p_course_cd => p_lgcy_adstunt_rec.program_cd,
662: p_version_number => p_version_number,

Line 1015: IF NOT igs_av_val_asu.advp_val_as_totals(

1011: mydebug('validate_unit IGS_AV_STUNT_EXPDT_TOBE_SET');
1012: END IF;
1013:
1014:
1015: IF NOT igs_av_val_asu.advp_val_as_totals(
1016: p_person_id => p_person_id,
1017: p_course_cd => p_lgcy_adstunt_rec.program_cd ,
1018: p_version_number => p_as_version_number ,
1019: p_include_approved => TRUE ,

Line 1036: mydebug('validate_unit IGS_AV_VAL_ASU.ADVP_VAL_AS_TOTALS ');

1032: ) THEN
1033: FND_MESSAGE.SET_NAME('IGS',l_message_name);
1034: FND_MSG_PUB.ADD;
1035: x_return_status := FALSE;
1036: mydebug('validate_unit IGS_AV_VAL_ASU.ADVP_VAL_AS_TOTALS ');
1037: END IF;
1038:
1039: -- Check for person hold
1040: IF NOT igs_en_val_encmb.enrp_val_excld_prsn(

Line 1085: IF NOT igs_av_val_asu.advp_val_approved_dt(

1081: x_return_status := FALSE;
1082: mydebug('validate_unit IGS_AV_STUNT_REVDT_NOT_NULL');
1083: END IF;
1084:
1085: IF NOT igs_av_val_asu.advp_val_approved_dt(
1086: p_approved_dt => p_lgcy_adstunt_rec.approved_dt ,
1087: p_expiry_dt => p_lgcy_adstunt_rec.expiry_dt ,
1088: p_message_name => l_message_name
1089: ) THEN

Line 1093: mydebug('validate_unit IGS_AV_VAL_ASU.ADVP_VAL_APPROVED_DT ');

1089: ) THEN
1090: FND_MESSAGE.SET_NAME('IGS',l_message_name);
1091: FND_MSG_PUB.ADD;
1092: x_return_status := FALSE;
1093: mydebug('validate_unit IGS_AV_VAL_ASU.ADVP_VAL_APPROVED_DT ');
1094: END IF;
1095: -- Validate whether the Granted Date, Cancelled Date Or Revoked Dates are greater than or equal to the Approved date
1096: IF NOT (
1097: igs_av_val_asu.advp_val_as_aprvd_dt(

Line 1097: igs_av_val_asu.advp_val_as_aprvd_dt(

1093: mydebug('validate_unit IGS_AV_VAL_ASU.ADVP_VAL_APPROVED_DT ');
1094: END IF;
1095: -- Validate whether the Granted Date, Cancelled Date Or Revoked Dates are greater than or equal to the Approved date
1096: IF NOT (
1097: igs_av_val_asu.advp_val_as_aprvd_dt(
1098: p_approved_dt => p_lgcy_adstunt_rec.approved_dt ,
1099: p_related_dt => p_lgcy_adstunt_rec.granted_dt ,
1100: p_message_name => l_message_name
1101: ) AND

Line 1102: igs_av_val_asu.advp_val_as_aprvd_dt(

1098: p_approved_dt => p_lgcy_adstunt_rec.approved_dt ,
1099: p_related_dt => p_lgcy_adstunt_rec.granted_dt ,
1100: p_message_name => l_message_name
1101: ) AND
1102: igs_av_val_asu.advp_val_as_aprvd_dt(
1103: p_approved_dt => p_lgcy_adstunt_rec.approved_dt ,
1104: p_related_dt => p_lgcy_adstunt_rec.cancelled_dt ,
1105: p_message_name => l_message_name
1106: ) AND

Line 1107: igs_av_val_asu.advp_val_as_aprvd_dt(

1103: p_approved_dt => p_lgcy_adstunt_rec.approved_dt ,
1104: p_related_dt => p_lgcy_adstunt_rec.cancelled_dt ,
1105: p_message_name => l_message_name
1106: ) AND
1107: igs_av_val_asu.advp_val_as_aprvd_dt(
1108: p_approved_dt => p_lgcy_adstunt_rec.approved_dt ,
1109: p_related_dt => p_lgcy_adstunt_rec.revoked_dt ,
1110: p_message_name => l_message_name
1111: )

Line 1117: mydebug('validate_unit IGS_AV_VAL_ASU.ADVP_VAL_APRVD_DT ');

1113:
1114: FND_MESSAGE.SET_NAME('IGS','IGS_AV_DTASSO_LE_APPRVDT' );
1115: FND_MSG_PUB.ADD;
1116: x_return_status := FALSE;
1117: mydebug('validate_unit IGS_AV_VAL_ASU.ADVP_VAL_APRVD_DT ');
1118: END IF;
1119:
1120: IF NOT igs_ad_val_acai.genp_val_staff_prsn(
1121: p_person_id => p_auth_pers_id ,

Line 1205: IF NOT igs_av_val_asu.advp_val_as_totals(

1201: Validate whether the advanced standing approved / granted has not
1202: exceeded the advanced standing internal or external limits of
1203: the Program version
1204: */
1205: IF NOT igs_av_val_asu.advp_val_as_totals(
1206: p_person_id => p_person_id,
1207: p_course_cd => p_lgcy_adstunt_rec.program_cd,
1208: p_version_number => p_course_version,
1209: p_include_approved => TRUE,

Line 1404: IF NOT igs_av_val_asau.advp_val_prclde_unit(

1400: x_return_status BOOLEAN :=TRUE;
1401: l_message_name VARCHAR2(30);
1402: BEGIN
1403: -- Validate that the advanced standing unit code is not same as the Alternate Unit Code
1404: IF NOT igs_av_val_asau.advp_val_prclde_unit(
1405: p_precluded_unit_cd => p_lgcy_adstunt_rec.unit_cd ,
1406: p_alternate_unit_cd => p_lgcy_adstunt_rec.alt_unit_cd ,
1407: p_message_name => l_message_name
1408: ) THEN

Line 1530: IF igs_av_val_asuleb.advp_val_basis_year(

1526: l_message_name VARCHAR2(30);
1527: l_return_type VARCHAR2(300);
1528: BEGIN
1529: -- Validate that the value in the BASIS_YEAR is not more than the current year
1530: IF igs_av_val_asuleb.advp_val_basis_year(
1531: p_basis_year => p_lgcy_adstunt_rec.basis_year ,
1532: p_course_cd => p_lgcy_adstunt_rec.program_cd ,
1533: p_version_number => p_lgcy_adstunt_rec.version_number ,
1534: p_message_name => l_message_name,