DBA Data[Home] [Help]

APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_PE_PERSON_PKG

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;