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_PS_UNIT_LGCY_PKG dependencies on FND_MESSAGE

Line 1775: fnd_message.set_name('IGS','IGS_PS_ORGUNIT_STATUS_INACTIV');

1771: IF p_tab_teach_resp(I).status = 'S' THEN
1772: OPEN c_org (p_tab_teach_resp(I).org_unit_cd);
1773: FETCH c_org INTO c_org_rec;
1774: IF c_org%NOTFOUND THEN
1775: fnd_message.set_name('IGS','IGS_PS_ORGUNIT_STATUS_INACTIV');
1776: fnd_msg_pub.add;
1777: p_tab_teach_resp(I).status := 'E';
1778: END IF;
1779: CLOSE c_org;

Line 1791: fnd_message.set_name('IGS','IGS_PS_LGCY_TR_100_EXISTS');

1787: p_unit_cd => p_tab_teach_resp(I).unit_cd,
1788: p_version_number => p_tab_teach_resp(I).version_number,
1789: p_message_name => l_c_message_name ,
1790: p_b_lgcy_validator => TRUE) THEN
1791: fnd_message.set_name('IGS','IGS_PS_LGCY_TR_100_EXISTS');
1792: fnd_msg_pub.add;
1793: p_tab_teach_resp(I).status := 'W' ;
1794: END IF;
1795:

Line 2006: fnd_message.set_name('IGS','IGS_PS_LGCY_UD_100_EXISTS');

2002: /* Proceed with business validations only if the status is Success, 'S' */
2003: IF p_tab_unit_dscp(I).status = 'S' THEN
2004: /* Validation# 1: Check if the Unit Discipline Percentage adds upto 100 */
2005: IF igs_ps_val_ud.crsp_val_ud_perc ( p_tab_unit_dscp(I).unit_cd, p_tab_unit_dscp(I).version_number, l_c_message_name ,TRUE) THEN
2006: fnd_message.set_name('IGS','IGS_PS_LGCY_UD_100_EXISTS');
2007: fnd_msg_pub.add;
2008: p_tab_unit_dscp(I).status := 'W';
2009: END IF;
2010:

Line 2315: fnd_message.set_name('IGS','IGS_PS_LGCY_ACT_UNT_WITHOUT_TR');

2311: p_rec_status := p_unit_ver_rec.status;
2312:
2313: IF NOT igs_ps_val_tr.crsp_val_tr_perc ( p_unit_ver_rec.unit_cd, p_unit_ver_rec.version_number, l_c_message ,TRUE) THEN
2314: -- Adding more meaningful message rather then the message returned in the variable l_c_message
2315: fnd_message.set_name('IGS','IGS_PS_LGCY_ACT_UNT_WITHOUT_TR');
2316: fnd_msg_pub.add;
2317: p_unit_ver_rec.status := 'E';
2318: END IF;
2319:

Line 2322: fnd_message.set_name('IGS','IGS_PS_LGCY_ACT_UNT_WITHOUT_UD');

2318: END IF;
2319:
2320: IF NOT igs_ps_val_ud.crsp_val_ud_perc ( p_unit_ver_rec.unit_cd, p_unit_ver_rec.version_number, l_c_message ,TRUE) THEN
2321: -- Adding more meaningful message rather then the message returned in the variable l_c_message
2322: fnd_message.set_name('IGS','IGS_PS_LGCY_ACT_UNT_WITHOUT_UD');
2323: fnd_msg_pub.add;
2324: p_unit_ver_rec.status := 'E';
2325: END IF;
2326:

Line 2634: fnd_message.set_name ( 'IGS', 'IGS_PS_CALTYPE_TEACHING_CAL' );

2630: /* Business validations */
2631: -- Check if the calendar category is 'TEACHING'
2632: IF ( p_usec_rec.status = 'S' ) THEN
2633: IF NOT igs_ps_validate_lgcy_pkg.validate_cal_cat ( l_c_cal_type, 'TEACHING' ) THEN
2634: fnd_message.set_name ( 'IGS', 'IGS_PS_CALTYPE_TEACHING_CAL' );
2635: fnd_msg_pub.add;
2636: p_usec_rec.status := 'E';
2637: END IF;
2638: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 2815: fnd_message.set_name ( 'IGS', 'IGS_EN_WAIT_NOT_ALW' );

2811:
2812: -- Check if waitlist_allowed is 'Y' then check if waitlisting is allowed at organization level.
2813: IF p_usec_rec.waitlist_allowed = 'Y' THEN
2814: IF NOT igs_ps_validate_lgcy_pkg.validate_waitlist_allowed ( l_c_cal_type, l_n_seq_num ) THEN
2815: fnd_message.set_name ( 'IGS', 'IGS_EN_WAIT_NOT_ALW' );
2816: fnd_msg_pub.add;
2817: p_usec_rec.status := 'E';
2818: END IF;
2819: ELSE

Line 2826: fnd_message.set_name ( 'IGS', 'IGS_PS_LGCY_MAX_STD_GT_0' );

2822: END IF;
2823:
2824: -- If Waitlist allowed is Yes and Max Students per waitlist is Zero then log a warning.
2825: IF ( p_usec_rec.waitlist_allowed = 'Y' AND p_usec_rec.max_students_per_waitlist = 0 ) THEN
2826: fnd_message.set_name ( 'IGS', 'IGS_PS_LGCY_MAX_STD_GT_0' );
2827: fnd_msg_pub.add;
2828: p_usec_rec.status := 'W';
2829: END IF;
2830:

Line 2958: fnd_message.set_name ( 'IGS', 'IGS_PS_NO_SUFF_VAL_SUP');

2954: (p_usec_rec.sup_unit_cd IS NULL OR p_usec_rec.sup_version_number IS NULL OR
2955: p_usec_rec.sup_teach_cal_alternate_code IS NULL OR p_usec_rec.sup_location_cd IS NULL OR
2956: p_usec_rec.sup_unit_class IS NULL) THEN
2957:
2958: fnd_message.set_name ( 'IGS', 'IGS_PS_NO_SUFF_VAL_SUP');
2959: fnd_msg_pub.add;
2960: p_usec_rec.status := 'E';
2961: ELSIF p_usec_rec.sup_unit_cd IS NOT NULL THEN
2962:

Line 3716: fnd_message.set_name ( 'IGS', 'IGS_PS_REC_ABORTED_CANCELLED' );

3712: p_alternate_code =>p_usec_rec.teach_cal_alternate_code,
3713: p_location_cd => p_usec_rec.location_cd,
3714: p_unit_class => p_usec_rec.unit_class,
3715: p_uso_id =>NULL) = FALSE THEN
3716: fnd_message.set_name ( 'IGS', 'IGS_PS_REC_ABORTED_CANCELLED' );
3717: fnd_msg_pub.add;
3718: p_usec_rec.status := 'A';
3719: END IF;
3720:

Line 4064: fnd_message.set_name ( 'IGS', l_c_message );

4060: p_unit_class => p_usec_rec.unit_class,
4061: p_uoo_id => l_n_uoo_id,
4062: p_message => l_c_message );
4063: IF l_c_message IS NOT NULL THEN
4064: fnd_message.set_name ( 'IGS', l_c_message );
4065: fnd_msg_pub.add;
4066: p_usec_rec.status := 'E';
4067: END IF;
4068:

Line 5236: fnd_message.set_name('IGS','IGS_PS_USEC_ENR_LMTS');

5232: BEGIN
5233: IF p_insert_update = 'I' THEN
5234: IF igs_ps_usec_lim_wlst_pkg.get_uk_for_validation(l_n_uoo_id) THEN
5235: p_usec_rec.status :='W';
5236: fnd_message.set_name('IGS','IGS_PS_USEC_ENR_LMTS');
5237: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS', fnd_message.get, NULL, FALSE);
5238: END IF;
5239: END IF;
5240:

Line 5237: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS', fnd_message.get, NULL, FALSE);

5233: IF p_insert_update = 'I' THEN
5234: IF igs_ps_usec_lim_wlst_pkg.get_uk_for_validation(l_n_uoo_id) THEN
5235: p_usec_rec.status :='W';
5236: fnd_message.set_name('IGS','IGS_PS_USEC_ENR_LMTS');
5237: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS', fnd_message.get, NULL, FALSE);
5238: END IF;
5239: END IF;
5240:
5241: IF p_usec_rec.enrollment_expected IS NOT NULL THEN

Line 5626: fnd_message.set_name ('IGS', l_message_name);

5622: p_usec_status=>p_usec_tbl(I).unit_section_status,
5623: p_request_id=>l_request_id,
5624: p_message_name=>l_message_name) THEN
5625:
5626: fnd_message.set_name ('IGS', l_message_name);
5627: fnd_msg_pub.add;
5628: p_usec_tbl(I).status := 'E';
5629: END IF;
5630: END IF;

Line 5883: fnd_message.set_name ( 'IGS', 'IGS_PS_REC_ABORTED_CANCELLED' );

5879:
5880: -- Find out whether record can go for import in context of cancelled/aborted
5881: IF p_tab_usec_gs(I).status = 'S' AND p_calling_context = 'S' THEN
5882: IF igs_ps_validate_lgcy_pkg.check_import_allowed( l_n_uoo_id,NULL) = FALSE THEN
5883: fnd_message.set_name ( 'IGS', 'IGS_PS_REC_ABORTED_CANCELLED' );
5884: fnd_msg_pub.add;
5885: p_tab_usec_gs(I).status := 'A';
5886: END IF;
5887:

Line 6934: fnd_message.set_name ( 'IGS', 'IGS_PS_REC_ABORTED_CANCELLED' );

6930:
6931: -- Find out whether record can go for import in context of cancelled/aborted
6932: IF p_tab_usec_occur(I).status = 'S' AND p_calling_context ='S' THEN
6933: IF igs_ps_validate_lgcy_pkg.check_import_allowed( l_n_uoo_id,l_n_uso_id) = FALSE THEN
6934: fnd_message.set_name ( 'IGS', 'IGS_PS_REC_ABORTED_CANCELLED' );
6935: fnd_msg_pub.add;
6936: p_tab_usec_occur(I).status := 'A';
6937: END IF;
6938:

Line 7421: fnd_message.set_name ( 'IGS', 'IGS_PS_UNIT_REF_N_ALLW_GEN_SCH' );

7417: p_ref_cd_rec.status := 'E';
7418: END IF;
7419:
7420: IF p_calling_context IN ('G','S') AND p_ref_cd_rec.data_type = 'UNIT' THEN
7421: fnd_message.set_name ( 'IGS', 'IGS_PS_UNIT_REF_N_ALLW_GEN_SCH' );
7422: fnd_msg_pub.add;
7423: p_ref_cd_rec.status := 'E';
7424: END IF;
7425:

Line 7539: fnd_message.set_name('IGS',l_c_msg);

7535: p_message => l_c_msg
7536: );
7537:
7538: IF l_c_msg IS NOT NULL THEN
7539: fnd_message.set_name('IGS',l_c_msg);
7540: fnd_msg_pub.add;
7541: p_ref_cd_rec.status := 'E';
7542: END IF;
7543: ELSE

Line 7582: fnd_message.set_name('IGS','IGS_PS_LGCY_GEN_FLAG');

7578: IF p_ref_cd_rec.gen_ref_flag IS NULL THEN
7579: p_ref_cd_rec.gen_ref_flag := 'Y' ;-- Defauling to 'Y' that is generic reference codes
7580: ELSE
7581: IF p_ref_cd_rec.gen_ref_flag NOT IN ('Y','N') THEN
7582: fnd_message.set_name('IGS','IGS_PS_LGCY_GEN_FLAG');
7583: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N',fnd_message.get,NULL,FALSE);
7584: p_ref_cd_rec.status:='E';
7585: END IF;
7586: END IF;

Line 7583: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N',fnd_message.get,NULL,FALSE);

7579: p_ref_cd_rec.gen_ref_flag := 'Y' ;-- Defauling to 'Y' that is generic reference codes
7580: ELSE
7581: IF p_ref_cd_rec.gen_ref_flag NOT IN ('Y','N') THEN
7582: fnd_message.set_name('IGS','IGS_PS_LGCY_GEN_FLAG');
7583: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N',fnd_message.get,NULL,FALSE);
7584: p_ref_cd_rec.status:='E';
7585: END IF;
7586: END IF;
7587:

Line 7617: fnd_message.set_name('IGS','IGS_PS_LGCY_UNIT_REQ_REF');

7613: p_ref_cd_rec.version_number,
7614: p_ref_cd_rec.reference_cd_type,
7615: p_ref_cd_rec.reference_cd
7616: ) THEN
7617: fnd_message.set_name('IGS','IGS_PS_LGCY_UNIT_REQ_REF');
7618: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS', fnd_message.get,NULL, FALSE);
7619: p_ref_cd_rec.status := 'W';
7620: RETURN;
7621: END IF;

Line 7618: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS', fnd_message.get,NULL, FALSE);

7614: p_ref_cd_rec.reference_cd_type,
7615: p_ref_cd_rec.reference_cd
7616: ) THEN
7617: fnd_message.set_name('IGS','IGS_PS_LGCY_UNIT_REQ_REF');
7618: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS', fnd_message.get,NULL, FALSE);
7619: p_ref_cd_rec.status := 'W';
7620: RETURN;
7621: END IF;
7622: END IF;

Line 7695: fnd_message.set_name('IGS','IGS_PS_LGCY_USEC_REQ_REF');

7691: RETURN;
7692: END IF;
7693: ELSE -- else Unit Section requirement reference code
7694: IF igs_ps_us_req_ref_cd_pkg.get_uk_for_validation(l_n_usec_ref_id,p_ref_cd_rec.reference_cd_type,p_ref_cd_rec.reference_cd) THEN
7695: fnd_message.set_name('IGS','IGS_PS_LGCY_USEC_REQ_REF');
7696: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS',fnd_message.get,NULL, FALSE);
7697: p_ref_cd_rec.status := 'W';
7698: RETURN;
7699: END IF;

Line 7696: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS',fnd_message.get,NULL, FALSE);

7692: END IF;
7693: ELSE -- else Unit Section requirement reference code
7694: IF igs_ps_us_req_ref_cd_pkg.get_uk_for_validation(l_n_usec_ref_id,p_ref_cd_rec.reference_cd_type,p_ref_cd_rec.reference_cd) THEN
7695: fnd_message.set_name('IGS','IGS_PS_LGCY_USEC_REQ_REF');
7696: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS',fnd_message.get,NULL, FALSE);
7697: p_ref_cd_rec.status := 'W';
7698: RETURN;
7699: END IF;
7700: END IF;

Line 7959: fnd_message.set_name ( 'IGS', 'IGS_PS_REC_ABORTED_CANCELLED' );

7955:
7956: -- Find out whether record can go for import in context of cancelled/aborted
7957: IF p_tab_ref_cd(i).status = 'S' AND p_calling_context ='S' THEN
7958: IF igs_ps_validate_lgcy_pkg.check_import_allowed( l_n_uoo_id,l_n_uso_id) = FALSE THEN
7959: fnd_message.set_name ( 'IGS', 'IGS_PS_REC_ABORTED_CANCELLED' );
7960: fnd_msg_pub.add;
7961: p_tab_ref_cd(i).status := 'A';
7962: END IF;
7963:

Line 8361: fnd_message.set_name('IGS','IGS_PS_INS_PERSON_NUMBER');

8357: p_uso_ins_rec.status:='S';
8358:
8359: -- Checking for the mandatory existence of Unit Code, verison number, instructor person number parameter in the record.
8360: IF p_uso_ins_rec.instructor_person_number IS NULL OR p_uso_ins_rec.instructor_person_number = FND_API.G_MISS_CHAR THEN
8361: fnd_message.set_name('IGS','IGS_PS_INS_PERSON_NUMBER');
8362: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY',fnd_message.get,NULL,FALSE);
8363: p_uso_ins_rec.status := 'E';
8364: END IF;
8365:

Line 8362: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY',fnd_message.get,NULL,FALSE);

8358:
8359: -- Checking for the mandatory existence of Unit Code, verison number, instructor person number parameter in the record.
8360: IF p_uso_ins_rec.instructor_person_number IS NULL OR p_uso_ins_rec.instructor_person_number = FND_API.G_MISS_CHAR THEN
8361: fnd_message.set_name('IGS','IGS_PS_INS_PERSON_NUMBER');
8362: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY',fnd_message.get,NULL,FALSE);
8363: p_uso_ins_rec.status := 'E';
8364: END IF;
8365:
8366: IF p_uso_ins_rec.unit_cd IS NULL OR p_uso_ins_rec.unit_cd = FND_API.G_MISS_CHAR THEN

Line 8397: fnd_message.set_name('IGS','IGS_PS_PRODUCTION_USO_ID');

8393: IF (p_uso_ins_rec.teach_cal_alternate_code IS NULL OR p_uso_ins_rec.teach_cal_alternate_code = FND_API.G_MISS_CHAR ) AND
8394: (p_uso_ins_rec.location_cd IS NULL OR p_uso_ins_rec.location_cd = FND_API.G_MISS_CHAR ) AND
8395: (p_uso_ins_rec.unit_class IS NULL OR p_uso_ins_rec.unit_class = FND_API.G_MISS_CHAR) THEN
8396: IF p_uso_ins_rec.production_uso_id IS NULL OR p_uso_ins_rec.production_uso_id = FND_API.G_MISS_NUM THEN
8397: fnd_message.set_name('IGS','IGS_PS_PRODUCTION_USO_ID');
8398: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY',fnd_message.get,NULL,FALSE);
8399: p_uso_ins_rec.status := 'E';
8400: END IF;
8401: END IF;

Line 8398: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY',fnd_message.get,NULL,FALSE);

8394: (p_uso_ins_rec.location_cd IS NULL OR p_uso_ins_rec.location_cd = FND_API.G_MISS_CHAR ) AND
8395: (p_uso_ins_rec.unit_class IS NULL OR p_uso_ins_rec.unit_class = FND_API.G_MISS_CHAR) THEN
8396: IF p_uso_ins_rec.production_uso_id IS NULL OR p_uso_ins_rec.production_uso_id = FND_API.G_MISS_NUM THEN
8397: fnd_message.set_name('IGS','IGS_PS_PRODUCTION_USO_ID');
8398: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY',fnd_message.get,NULL,FALSE);
8399: p_uso_ins_rec.status := 'E';
8400: END IF;
8401: END IF;
8402:

Line 8451: fnd_message.set_name('IGS','IGS_PS_INS_PERSON_NUMBER');

8447:
8448: -- Derive the Instructor identifier
8449: igs_ps_validate_lgcy_pkg.get_party_id(p_uso_ins_rec.instructor_person_number, l_n_ins_id);
8450: IF l_n_ins_id IS NULL THEN
8451: fnd_message.set_name('IGS','IGS_PS_INS_PERSON_NUMBER');
8452: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', fnd_message.get,NULL, FALSE);
8453: p_uso_ins_rec.status := 'E';
8454: END IF;
8455:

Line 8452: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', fnd_message.get,NULL, FALSE);

8448: -- Derive the Instructor identifier
8449: igs_ps_validate_lgcy_pkg.get_party_id(p_uso_ins_rec.instructor_person_number, l_n_ins_id);
8450: IF l_n_ins_id IS NULL THEN
8451: fnd_message.set_name('IGS','IGS_PS_INS_PERSON_NUMBER');
8452: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', fnd_message.get,NULL, FALSE);
8453: p_uso_ins_rec.status := 'E';
8454: END IF;
8455:
8456: -- if the production unit section occurrence identifier is provided then validate it

Line 8466: fnd_message.set_name('IGS','IGS_PS_PRODUCTION_USO_ID');

8462: OPEN c_uoo_id(l_n_uso_id);
8463: FETCH c_uoo_id INTO l_n_uoo_id;
8464: CLOSE c_uoo_id;
8465: ELSE
8466: fnd_message.set_name('IGS','IGS_PS_PRODUCTION_USO_ID');
8467: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', fnd_message.get,NULL, FALSE);
8468: p_uso_ins_rec.status := 'E';
8469: END IF;
8470: ELSE

Line 8467: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', fnd_message.get,NULL, FALSE);

8463: FETCH c_uoo_id INTO l_n_uoo_id;
8464: CLOSE c_uoo_id;
8465: ELSE
8466: fnd_message.set_name('IGS','IGS_PS_PRODUCTION_USO_ID');
8467: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', fnd_message.get,NULL, FALSE);
8468: p_uso_ins_rec.status := 'E';
8469: END IF;
8470: ELSE
8471: -- Deriving the value of Unit section Occurrence identifier

Line 8496: fnd_message.set_name('IGS',l_c_msg);

8492: p_uso_id => l_n_uso_id,
8493: p_message => l_c_msg
8494: );
8495: IF l_c_msg IS NOT NULL THEN
8496: fnd_message.set_name('IGS',l_c_msg);
8497: fnd_msg_pub.add;
8498: p_uso_ins_rec.status := 'E';
8499: END IF;
8500:

Line 8524: fnd_message.set_name('IGS','IGS_PS_USO_INS');

8520: BEGIN
8521: -- Check uniqueness validation
8522: IF igs_ps_uso_instrctrs_pkg.get_uk_for_validation(l_n_uso_id, l_n_ins_id) THEN
8523: p_uso_ins_rec.status :='W';
8524: fnd_message.set_name('IGS','IGS_PS_USO_INS');
8525: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS', fnd_message.get, NULL, FALSE);
8526: RETURN;
8527: END IF;
8528:

Line 8525: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS', fnd_message.get, NULL, FALSE);

8521: -- Check uniqueness validation
8522: IF igs_ps_uso_instrctrs_pkg.get_uk_for_validation(l_n_uso_id, l_n_ins_id) THEN
8523: p_uso_ins_rec.status :='W';
8524: fnd_message.set_name('IGS','IGS_PS_USO_INS');
8525: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS', fnd_message.get, NULL, FALSE);
8526: RETURN;
8527: END IF;
8528:
8529: -- Check Constraints

Line 8548: fnd_message.set_name('IGS','IGS_PS_INS_PERSON_NUMBER');

8544: END;
8545:
8546: -- Foreign Key Checking
8547: IF NOT igs_pe_person_pkg.get_pk_for_validation(l_n_ins_id ) THEN
8548: fnd_message.set_name('IGS','IGS_PS_INS_PERSON_NUMBER');
8549: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', fnd_message.get, NULL, FALSE);
8550: p_uso_ins_rec.status := 'E';
8551: END IF;
8552: IF NOT igs_ps_unit_ofr_opt_pkg.get_uk_for_validation (l_n_uoo_id ) THEN

Line 8549: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', fnd_message.get, NULL, FALSE);

8545:
8546: -- Foreign Key Checking
8547: IF NOT igs_pe_person_pkg.get_pk_for_validation(l_n_ins_id ) THEN
8548: fnd_message.set_name('IGS','IGS_PS_INS_PERSON_NUMBER');
8549: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', fnd_message.get, NULL, FALSE);
8550: p_uso_ins_rec.status := 'E';
8551: END IF;
8552: IF NOT igs_ps_unit_ofr_opt_pkg.get_uk_for_validation (l_n_uoo_id ) THEN
8553: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'UNIT_SECTION', 'LEGACY_TOKENS', FALSE);

Line 8565: fnd_message.set_name('IGS','IGS_PS_LGCY_UNIT_VER_NOT_USO');

8561: FETCH c_unit_ver INTO rec_unit_ver;
8562: IF c_unit_ver%FOUND THEN
8563: IF p_uso_ins_rec.unit_cd <> rec_unit_ver.unit_cd OR
8564: p_uso_ins_rec.version_number <> rec_unit_ver.version_number THEN
8565: fnd_message.set_name('IGS','IGS_PS_LGCY_UNIT_VER_NOT_USO');
8566: fnd_msg_pub.add;
8567: p_uso_ins_rec.status :='E';
8568: END IF;
8569: ELSE

Line 8570: fnd_message.set_name('IGS','IGS_PS_LGCY_UNIT_VER_NOT_USO');

8566: fnd_msg_pub.add;
8567: p_uso_ins_rec.status :='E';
8568: END IF;
8569: ELSE
8570: fnd_message.set_name('IGS','IGS_PS_LGCY_UNIT_VER_NOT_USO');
8571: fnd_msg_pub.add;
8572: p_uso_ins_rec.status :='E';
8573: END IF;
8574: CLOSE c_unit_ver;

Line 8584: fnd_message.set_name ( 'IGS', 'IGS_PS_SCHEDULING_IN_PROGRESS' );

8580: --Note this validation cannot be pushed in the post validation as that is also called from the instructor override
8581: OPEN c_occur_status (l_n_uso_id);
8582: FETCH c_occur_status INTO l_c_var;
8583: IF c_occur_status%FOUND THEN
8584: fnd_message.set_name ( 'IGS', 'IGS_PS_SCHEDULING_IN_PROGRESS' );
8585: fnd_msg_pub.add;
8586: p_uso_ins_rec.status := 'E';
8587: END IF;
8588: CLOSE c_occur_status;