APPS.IGS_PS_VALIDATE_LGCY_PKG dependencies on FND_PROFILE

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

885: CLOSE c_teach_to_load;
886:
887: IF p_insert_update = 'I' THEN---this validation needs to be done only while insert operation
888: -- Validate Call Number
889: IF (fnd_profile.value('IGS_PS_CALL_NUMBER') = 'AUTO' AND p_usec_rec.call_number IS NOT NULL) THEN
890:
891: -- Profile is AUTO and values is passed to call_number so raise error
892: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'CALL_NUMBER', 'LEGACY_TOKENS', FALSE);
893: p_usec_rec.status := 'E';

Line 894: ELSIF ( fnd_profile.value('IGS_PS_CALL_NUMBER') = 'USER_DEFINED' ) THEN

890:
891: -- Profile is AUTO and values is passed to call_number so raise error
892: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'CALL_NUMBER', 'LEGACY_TOKENS', FALSE);
893: p_usec_rec.status := 'E';
894: ELSIF ( fnd_profile.value('IGS_PS_CALL_NUMBER') = 'USER_DEFINED' ) THEN
895:
896: IF p_usec_rec.call_number IS NOT NULL THEN
897: IF NOT igs_ps_unit_ofr_opt_pkg.check_call_number ( p_teach_cal_type => p_c_cal_type,
898: p_teach_sequence_num => p_n_seq_num,

Line 909: IF ( fnd_profile.value('IGS_PS_CALL_NUMBER') = 'NONE' ) THEN

905: END IF;
906: END IF;
907: END IF;
908:
909: IF ( fnd_profile.value('IGS_PS_CALL_NUMBER') = 'NONE' ) THEN
910:
911: IF p_usec_rec.call_number IS NOT NULL THEN
912: -- Profile is NONE and values is passed to call_number so raise error
913: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'CALL_NUMBER', 'LEGACY_TOKENS', FALSE);

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

1097: FETCH c_usec INTO c_usec_rec;
1098: CLOSE c_usec;
1099:
1100:
1101: IF ( fnd_profile.value('IGS_PS_CALL_NUMBER') = 'USER_DEFINED' ) THEN
1102: IF p_usec_rec.call_number IS NOT NULL THEN
1103: IF NOT igs_ps_unit_ofr_opt_pkg.check_call_number ( p_teach_cal_type => p_c_cal_type,
1104: p_teach_sequence_num => p_n_seq_num,
1105: p_call_number => p_usec_rec.call_number,

Line 1206: IF (NVL(fnd_profile.value('IGS_PS_SCH_SOFT_NOT_INSTLD'),'N')) = 'N' THEN

1202:
1203: --clearing Building code and room code when status is cancelled
1204: IF p_usec_rec.unit_section_status <> c_usec_rec.unit_section_status THEN
1205: IF p_usec_rec.unit_section_status = 'CANCELLED' THEN
1206: IF (NVL(fnd_profile.value('IGS_PS_SCH_SOFT_NOT_INSTLD'),'N')) = 'N' THEN
1207: IF p_usec_rec.status <> 'E' THEN
1208: FOR rec_uso IN c_uso(c_usec_rec.uoo_id) LOOP
1209: igs_ps_usec_occurs_pkg.update_row (
1210: X_Mode => 'R',