[Home] [Help]
58: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
59: CLOSE cur_old_ref_values;
60: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
61: igs_ge_msg_stack.add;
62: app_exception.raise_exception;
63: RETURN;
64: END IF;
65: CLOSE cur_old_ref_values;
66:
128: IF NOT (new_references.reference_number BETWEEN 1
129: AND 999999) THEN
130: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
131: igs_ge_msg_stack.add;
132: app_exception.raise_exception;
133: END IF;
134: END IF;
135:
136: IF (UPPER(column_name) = 'CI_SEQUENCE_NUMBER' OR column_name IS NULL) THEN
137: IF NOT (new_references.ci_sequence_number BETWEEN 1
138: AND 999999) THEN
139: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
140: igs_ge_msg_stack.add;
141: app_exception.raise_exception;
142: END IF;
143: END IF;
144:
145: IF (UPPER(column_name) = 'REQUEST_NUM' OR column_name IS NULL) THEN
146: IF NOT (new_references.request_num BETWEEN 1
147: AND 999999) THEN
148: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
149: igs_ge_msg_stack.add;
150: app_exception.raise_exception;
151: END IF;
152: END IF;
153:
154: END check_constraints;
173: IF (cur_rowid%FOUND) THEN
174: Close cur_rowid;
175: Fnd_Message.Set_Name ('IGS', 'IGS_CO_CORI_CI_FK');
176: IGS_GE_MSG_STACK.ADD;
177: App_Exception.Raise_Exception;
178: Return;
179: END IF;
180: Close cur_rowid;
181:
199: IF (cur_rowid%FOUND) THEN
200: Close cur_rowid;
201: Fnd_Message.Set_Name ('IGS', 'IGS_CO_CORI_CORT_FK');
202: IGS_GE_MSG_STACK.ADD;
203: App_Exception.Raise_Exception;
204: Return;
205: END IF;
206: Close cur_rowid;
207:
227: IF (cur_rowid%FOUND) THEN
228: Close cur_rowid;
229: Fnd_Message.Set_Name ('IGS', 'IGS_CO_CORI_CRV_FK');
230: IGS_GE_MSG_STACK.ADD;
231: App_Exception.Raise_Exception;
232: Return;
233: END IF;
234: Close cur_rowid;
235:
253: IF (cur_rowid%FOUND) THEN
254: Close cur_rowid;
255: Fnd_Message.Set_Name ('IGS', 'IGS_CO_CORI_PE_FK');
256: IGS_GE_MSG_STACK.ADD;
257: App_Exception.Raise_Exception;
258: Return;
259: END IF;
260: Close cur_rowid;
261:
281: IF (cur_rowid%FOUND) THEN
282: Close cur_rowid;
283: Fnd_Message.Set_Name ('IGS', 'IGS_CO_CORI_UV_FK');
284: IGS_GE_MSG_STACK.ADD;
285: App_Exception.Raise_Exception;
286: Return;
287: END IF;
288: Close cur_rowid;
289:
307: )
308: ) THEN
309: fnd_message.set_name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
310: igs_ge_msg_stack.add;
311: app_exception.raise_exception;
312: END IF;
313:
314: END check_uniqueness;
315:
481: )
482: ) THEN
483: fnd_message.set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
484: igs_ge_msg_stack.add;
485: app_exception.raise_exception;
486: END IF;
487: check_uniqueness;
488: check_constraints;
489: ELSIF (p_action = 'UPDATE') THEN
501: )
502: ) THEN
503: fnd_message.set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
504: igs_ge_msg_stack.add;
505: app_exception.raise_exception;
506: END IF;
507: check_uniqueness;
508: check_constraints;
509: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
590: END IF;
591: ELSE
592: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
593: igs_ge_msg_stack.add;
594: app_exception.raise_exception;
595: END IF;
596:
597: before_dml(
598: p_action => 'INSERT',
750: IF (c1%notfound) THEN
751: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
752: igs_ge_msg_stack.add;
753: CLOSE c1;
754: app_exception.raise_exception;
755: RETURN;
756: END IF;
757: CLOSE c1;
758:
776: NULL;
777: ELSE
778: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
779: igs_ge_msg_stack.add;
780: app_exception.raise_exception;
781: END IF;
782:
783: RETURN;
784:
840: END IF;
841: ELSE
842: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
843: igs_ge_msg_stack.add;
844: app_exception.raise_exception;
845: END IF;
846:
847: before_dml(
848: p_action => 'UPDATE',