[Home] [Help]
55: OPEN cur_old_ref_values;
56: FETCH cur_old_ref_values INTO old_references;
57: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
58: CLOSE cur_old_ref_values;
59: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
60: igs_ge_msg_stack.add;
61: app_exception.raise_exception;
62: RETURN;
63: END IF;
115:
116: IF (UPPER(column_name) = 'REFERENCE_NUMBER' OR column_name IS NULL) THEN
117: IF NOT (new_references.reference_number BETWEEN 1
118: AND 999999) THEN
119: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
120: igs_ge_msg_stack.add;
121: app_exception.raise_exception;
122: END IF;
123: END IF;
150: OPEN cur_rowid;
151: FETCH cur_rowid INTO lv_rowid;
152: IF (cur_rowid%FOUND) THEN
153: CLOSE cur_rowid;
154: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
155: igs_ge_msg_stack.add;
156: app_exception.raise_exception;
157: RETURN;
158: END IF;
206: new_references.issue_dt,
207: new_references.dt_sent,
208: new_references.unknown_return_dt,
209: v_message_name) = FALSE THEN
210: Fnd_Message.Set_Name('IGS',v_message_name);
211: IGS_GE_MSG_STACK.ADD;
212: App_Exception.Raise_Exception;
213: END IF;
214: END IF;
323: new_references.reference_number,
324: new_references.issue_dt
325: )
326: ) THEN
327: fnd_message.set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
328: igs_ge_msg_stack.add;
329: app_exception.raise_exception;
330: END IF;
331: check_constraints;
344: new_references.reference_number,
345: new_references.issue_dt
346: )
347: ) THEN
348: fnd_message.set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
349: igs_ge_msg_stack.add;
350: app_exception.raise_exception;
351: END IF;
352: check_constraints;
427: ELSE
428: x_program_update_date := SYSDATE;
429: END IF;
430: ELSE
431: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
432: igs_ge_msg_stack.add;
433: app_exception.raise_exception;
434: END IF;
435:
555:
556: OPEN c1;
557: FETCH c1 INTO tlinfo;
558: IF (c1%notfound) THEN
559: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
560: igs_ge_msg_stack.add;
561: CLOSE c1;
562: app_exception.raise_exception;
563: RETURN;
575:
576: ) THEN
577: NULL;
578: ELSE
579: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
580: igs_ge_msg_stack.add;
581: app_exception.raise_exception;
582: END IF;
583:
633: IF (x_last_update_login IS NULL) THEN
634: x_last_update_login := -1;
635: END IF;
636: ELSE
637: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
638: igs_ge_msg_stack.add;
639: app_exception.raise_exception;
640: END IF;
641:
794: Open cur_rowid;
795: Fetch cur_rowid INTO lv_rowid;
796: IF (cur_rowid%FOUND) THEN
797: Close cur_rowid;
798: Fnd_Message.Set_Name ('IGS', 'IGS_CO_OC_ADT_FK');
799: IGS_GE_MSG_STACK.ADD;
800: App_Exception.Raise_Exception;
801: Return;
802: END IF;
822: Open cur_rowid;
823: Fetch cur_rowid INTO lv_rowid;
824: IF (cur_rowid%FOUND) THEN
825: Close cur_rowid;
826: Fnd_Message.Set_Name ('IGS', 'IGS_CO_OC_CORI_FK');
827: IGS_GE_MSG_STACK.ADD;
828: App_Exception.Raise_Exception;
829: Return;
830: END IF;
848: Open cur_rowid;
849: Fetch cur_rowid INTO lv_rowid;
850: IF (cur_rowid%FOUND) THEN
851: Close cur_rowid;
852: Fnd_Message.Set_Name ('IGS', 'IGS_CO_OC_PE_FK');
853: IGS_GE_MSG_STACK.ADD;
854: App_Exception.Raise_Exception;
855: Return;
856: END IF;
874: Open cur_rowid;
875: Fetch cur_rowid INTO lv_rowid;
876: IF (cur_rowid%FOUND) THEN
877: Close cur_rowid;
878: Fnd_Message.Set_Name ('IGS', 'IGS_CO_OC_TRI_FK');
879: IGS_GE_MSG_STACK.ADD;
880: App_Exception.Raise_Exception;
881: Return;
882: END IF;