[Home] [Help]
47: OPEN cur_old_ref_values;
48: FETCH cur_old_ref_values INTO old_references;
49: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
50: CLOSE cur_old_ref_values;
51: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
52: igs_ge_msg_stack.ADD;
53: app_exception.raise_exception;
54: RETURN;
55: END IF;
138: new_references.ci_cal_type,
139: new_references.ci_sequence_number
140: )
141: ) THEN
142: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
143: igs_ge_msg_stack.add;
144: app_exception.raise_exception;
145: END IF;
146:
152: new_references.ci_cal_type,
153: new_references.ci_sequence_number
154: )
155: ) THEN
156: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
157: igs_ge_msg_stack.add;
158: app_exception.raise_exception;
159: END IF;
160:
209: IF (x_last_update_login IS NULL) THEN
210: x_last_update_login := -1;
211: END IF;
212: ELSE
213: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
214: igs_ge_msg_stack.ADD;
215: app_exception.raise_exception;
216: END IF;
217:
319:
320: OPEN c1;
321: FETCH c1 INTO tlinfo;
322: IF (c1%NOTFOUND) THEN
323: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
324: igs_ge_msg_stack.ADD;
325: CLOSE c1;
326: app_exception.raise_exception;
327: RETURN;
340: AND ((tlinfo.fund_code = X_term_amount_text) OR ((tlinfo.term_amount_text IS NULL) AND (X_term_amount_text IS NULL)))
341: ) THEN
342: NULL;
343: ELSE
344: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
345: igs_ge_msg_stack.ADD;
346: app_exception.raise_exception;
347: END IF;
348:
431: IF (x_last_update_login IS NULL) THEN
432: x_last_update_login := -1;
433: END IF;
434: ELSE
435: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
436: igs_ge_msg_stack.ADD;
437: app_exception.raise_exception;
438: END IF;
439: