48: Open cur_old_ref_values;
49: Fetch cur_old_ref_values INTO old_references;
50: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
51: Close cur_old_ref_values;
52: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
53: IGS_GE_MSG_STACK.ADD;
54: App_Exception.Raise_Exception;
55: Return;
56: END IF;
132: END IF;
133:
134: IF upper(column_name)= 'PERCENTAGE_ALLOCATION' OR column_name is null THEN
135: IF new_references.percentage_allocation not between 0.00 and 999.99 THEN
136: Fnd_Message.Set_Name ('IGS', 'IGS_PS_LGCY_PTS_RANGE_0_999');
137: fnd_message.set_token('PARAM', igs_ps_validate_lgcy_pkg.get_lkup_meaning('PERCENTAGE','LEGACY_TOKENS'));
138: IGS_GE_MSG_STACK.ADD;
139: App_Exception.Raise_Exception;
140: END IF;
133:
134: IF upper(column_name)= 'PERCENTAGE_ALLOCATION' OR column_name is null THEN
135: IF new_references.percentage_allocation not between 0.00 and 999.99 THEN
136: Fnd_Message.Set_Name ('IGS', 'IGS_PS_LGCY_PTS_RANGE_0_999');
137: fnd_message.set_token('PARAM', igs_ps_validate_lgcy_pkg.get_lkup_meaning('PERCENTAGE','LEGACY_TOKENS'));
138: IGS_GE_MSG_STACK.ADD;
139: App_Exception.Raise_Exception;
140: END IF;
141: END IF;
141: END IF;
142:
143: IF upper(column_name)= 'INSTRUCTIONAL_LOAD_LECTURE' OR column_name is null THEN
144: IF new_references.instructional_load_lecture not between 0 and 9999.99 THEN
145: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
146: igs_ge_msg_stack.add;
147: app_exception.raise_exception;
148: END IF;
149: END IF;
149: END IF;
150:
151: IF upper(column_name)= 'INSTRUCTIONAL_LOAD_LAB' OR column_name is null THEN
152: IF new_references.instructional_load_lab not between 0 and 9999.99 THEN
153: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
154: igs_ge_msg_stack.add;
155: app_exception.raise_exception;
156: END IF;
157: END IF;
157: END IF;
158:
159: IF upper(column_name)= 'INSTRUCTIONAL_LOAD' OR column_name is null THEN
160: IF new_references.instructional_load not between 0 and 9999.99 THEN
161: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
162: igs_ge_msg_stack.add;
163: app_exception.raise_exception;
164: END IF;
165: END IF;
165: END IF;
166:
167: IF upper(column_name)= 'CONFIRMED_FLAG' OR column_name is null THEN
168: IF new_references.confirmed_flag NOT IN ('Y','N') THEN
169: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
170: igs_ge_msg_stack.add;
171: app_exception.raise_exception;
172: END IF;
173: END IF;
173: END IF;
174:
175: IF upper(column_name)= 'LEAD_INSTRUCTOR_FLAG' OR column_name is null THEN
176: IF new_references.lead_instructor_flag NOT IN ('Y','N') THEN
177: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
178: igs_ge_msg_stack.add;
179: app_exception.raise_exception;
180: END IF;
181: END IF;
199: new_references.uoo_id,
200: new_references.instructor_id
201:
202: ) THEN
203: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
204: IGS_GE_MSG_STACK.ADD;
205: app_exception.raise_exception;
206: END IF;
207: END Check_Uniqueness ;
224: NULL;
225: ELSIF NOT Igs_Ps_Unit_Ofr_Opt_Pkg.Get_UK_For_Validation (
226: new_references.uoo_id
227: ) THEN
228: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
229: IGS_GE_MSG_STACK.ADD;
230: App_Exception.Raise_Exception;
231: END IF;
232:
331: Open cur_rowid;
332: Fetch cur_rowid INTO lv_rowid;
333: IF (cur_rowid%FOUND) THEN
334: Close cur_rowid;
335: Fnd_Message.Set_Name ('IGS', 'IGS_PS_USTR_UOO_UFK');
336: IGS_GE_MSG_STACK.ADD;
337: App_Exception.Raise_Exception;
338: Return;
339: END IF;
395: -- Call all the procedures related to Before Insert.
396: Null;
397: IF Get_Pk_For_Validation(
398: new_references.unit_section_teach_resp_id) THEN
399: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
400: IGS_GE_MSG_STACK.ADD;
401: App_Exception.Raise_Exception;
402: END IF;
403: Check_Uniqueness;
415: ELSIF (p_action = 'VALIDATE_INSERT') THEN
416: -- Call all the procedures related to Before Insert.
417: IF Get_PK_For_Validation (
418: new_references.unit_section_teach_resp_id) THEN
419: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
420: IGS_GE_MSG_STACK.ADD;
421: App_Exception.Raise_Exception;
422: END IF;
423: Check_Uniqueness;
508: if X_LAST_UPDATE_LOGIN is NULL then
509: X_LAST_UPDATE_LOGIN := -1;
510: end if;
511: else
512: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
513: IGS_GE_MSG_STACK.ADD;
514: app_exception.raise_exception;
515: end if;
516:
617: begin
618: open c1;
619: fetch c1 into tlinfo;
620: if (c1%notfound) then
621: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
622: IGS_GE_MSG_STACK.ADD;
623: close c1;
624: app_exception.raise_exception;
625: return;
643: AND (X_INSTRUCTIONAL_LOAD_LECTURE IS NULL)))
644: ) then
645: null;
646: else
647: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
648: IGS_GE_MSG_STACK.ADD;
649: app_exception.raise_exception;
650: end if;
651: return;
691: if X_LAST_UPDATE_LOGIN is NULL then
692: X_LAST_UPDATE_LOGIN := -1;
693: end if;
694: else
695: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
696: IGS_GE_MSG_STACK.ADD;
697: app_exception.raise_exception;
698: end if;
699: Before_DML(