DBA Data[Home] [Help]

APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_PE_PERSON

Line 6433: IF NOT igs_pe_person_pkg.get_pk_for_validation(l_n_ins_id ) THEN

6429: p_uso_ins_rec.status :='E';
6430: END;
6431:
6432: -- Foreign Key Checking
6433: IF NOT igs_pe_person_pkg.get_pk_for_validation(l_n_ins_id ) THEN
6434: fnd_message.set_name('IGS','IGS_PS_INS_PERSON_NUMBER');
6435: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', fnd_message.get, NULL, FALSE);
6436: p_uso_ins_rec.status := 'E';
6437: END IF;

Line 6960: IF NOT igs_pe_person_pkg.get_pk_for_validation(l_n_ins_id ) THEN

6956: END;
6957: END IF;
6958:
6959: -- Foreign Key Checking
6960: IF NOT igs_pe_person_pkg.get_pk_for_validation(l_n_ins_id ) THEN
6961: fnd_message.set_name('IGS','IGS_PS_INS_PERSON_NUMBER');
6962: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', fnd_message.get, NULL, FALSE);
6963: p_usec_teach_resp_rec.status := 'E';
6964: END IF;

Line 8260: IF NOT igs_pe_person_pkg.get_pk_for_validation(l_n_ins_id ) THEN

8256: END IF;
8257:
8258: -- Check for existence of instructor number
8259: IF l_n_ins_id IS NOT NULL THEN
8260: IF NOT igs_pe_person_pkg.get_pk_for_validation(l_n_ins_id ) THEN
8261: fnd_message.set_name('IGS','IGS_PS_INS_PERSON_NUMBER');
8262: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', fnd_message.get, NULL, FALSE);
8263: p_usec_plus_hr_rec.status := 'E';
8264: END IF;

Line 8336: l_preferred_name igs_pe_person.preferred_name%TYPE;

8332:
8333: PROCEDURE Business_validation(p_usec_plus_hr_rec IN OUT NOCOPY igs_ps_generic_pub.usec_plus_hr_rec_type) AS
8334:
8335: l_message_name VARCHAR2(30);
8336: l_preferred_name igs_pe_person.preferred_name%TYPE;
8337: BEGIN
8338: --Check if the unit is INACTIVE, then do not allow to import
8339: IF igs_ps_val_unit.crsp_val_iud_uv_dtl(p_usec_plus_hr_rec.unit_cd, p_usec_plus_hr_rec.version_number,l_message_name)=FALSE THEN
8340: fnd_message.set_name ( 'IGS', 'IGS_PS_NOCHG_UNITVER_DETAILS' );