APPS.IGS_PS_UNIT_LGCY_PKG dependencies on FND_PROFILE

Line 279: FND_PROFILE.VALUE('IGS_PS_CURRICULUM_ID')= 'Y' THEN

275: END IF;
276:
277: IF p_unit_ver_rec.curriculum_id IS NULL AND
278: p_unit_ver_rec.curriculum_description IS NOT NULL AND
279: FND_PROFILE.VALUE('IGS_PS_CURRICULUM_ID')= 'Y' THEN
280: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY','CURRICULUM_ID','LEGACY_TOKENS',FALSE);
281: p_unit_ver_rec.status:='E';
282: END IF;
283:

Line 499: IF FND_PROFILE.VALUE('IGS_PS_CURRICULUM_ID')= 'N' AND

495: p_unit_ver_rec.status:='E';
496: END IF;
497:
498:
499: IF FND_PROFILE.VALUE('IGS_PS_CURRICULUM_ID')= 'N' AND
500: p_unit_ver_rec.curriculum_description IS NOT NULL THEN
501:
502: OPEN c_curriculum_seq_num;
503: FETCH c_curriculum_seq_num INTO p_unit_ver_rec.curriculum_id;

Line 568: IF FND_PROFILE.VALUE('IGS_PS_CURRICULUM_ID')= 'Y' AND p_unit_ver_rec.curriculum_description IS NOT NULL THEN

564: p_unit_ver_rec.status:='W';
565: RETURN;
566: END IF;
567:
568: IF FND_PROFILE.VALUE('IGS_PS_CURRICULUM_ID')= 'Y' AND p_unit_ver_rec.curriculum_description IS NOT NULL THEN
569: IF igs_ps_unt_crclm_pkg.get_pk_for_validation(p_unit_ver_rec.curriculum_id) THEN
570: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS','CURRICULUM_ID','LEGACY_TOKENS',FALSE);
571: p_unit_ver_rec.status:='W';
572: RETURN;

Line 3486: IF fnd_profile.value('IGS_PS_CALL_NUMBER') = 'USER_DEFINED' THEN

3482:
3483: IF p_usec_rec.call_number IS NULL THEN
3484: p_usec_rec.call_number := c_usec_rec.call_number;
3485: ELSIF p_usec_rec.call_number = FND_API.G_MISS_NUM THEN
3486: IF fnd_profile.value('IGS_PS_CALL_NUMBER') = 'USER_DEFINED' THEN
3487: p_usec_rec.call_number :=NULL;
3488: ELSE
3489: p_usec_rec.call_number := c_usec_rec.call_number;
3490: END IF;

Line 3492: IF (fnd_profile.value('IGS_PS_CALL_NUMBER') = 'AUTO' AND p_usec_rec.call_number IS NOT NULL) THEN

3488: ELSE
3489: p_usec_rec.call_number := c_usec_rec.call_number;
3490: END IF;
3491: ELSE
3492: IF (fnd_profile.value('IGS_PS_CALL_NUMBER') = 'AUTO' AND p_usec_rec.call_number IS NOT NULL) THEN
3493:
3494: -- Profile is AUTO and values is passed to call_number so raise error
3495: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'CALL_NUMBER', 'LEGACY_TOKENS', FALSE);
3496: p_usec_rec.status := 'E';

Line 3853: IF FND_PROFILE.VALUE('IGS_PS_CALL_NUMBER') = 'AUTO' THEN

3849: --should not perform while update...
3850: --Set the value of the call_number if the profile option is AUTO
3851:
3852: IF l_insert_update = 'I' THEN
3853: IF FND_PROFILE.VALUE('IGS_PS_CALL_NUMBER') = 'AUTO' THEN
3854: p_usec_rec.call_number := igs_ps_unit_ofr_opt_pkg.get_call_number( l_c_cal_type, l_n_seq_num);
3855: END IF;
3856:
3857: INSERT INTO igs_ps_unit_ofr_opt_all