DBA Data[Home] [Help]

APPS.IGS_CO_ITM_PKG dependencies on IGS_GE_MSG_STACK

Line 61: igs_ge_msg_stack.add;

57: FETCH cur_old_ref_values INTO old_references;
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;

Line 131: igs_ge_msg_stack.add;

127: IF (UPPER(column_name) = 'REFERENCE_NUMBER' OR column_name IS NULL) THEN
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:

Line 140: igs_ge_msg_stack.add;

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:

Line 149: igs_ge_msg_stack.add;

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:

Line 176: IGS_GE_MSG_STACK.ADD;

172: Fetch cur_rowid INTO lv_rowid;
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;

Line 202: IGS_GE_MSG_STACK.ADD;

198: Fetch cur_rowid INTO lv_rowid;
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;

Line 230: IGS_GE_MSG_STACK.ADD;

226: Fetch cur_rowid INTO lv_rowid;
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;

Line 256: IGS_GE_MSG_STACK.ADD;

252: Fetch cur_rowid INTO lv_rowid;
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;

Line 284: IGS_GE_MSG_STACK.ADD;

280: Fetch cur_rowid INTO lv_rowid;
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;

Line 310: igs_ge_msg_stack.add;

306: new_references.reference_number
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;

Line 484: igs_ge_msg_stack.add;

480: new_references.reference_number
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;

Line 504: igs_ge_msg_stack.add;

500: new_references.reference_number
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;

Line 593: igs_ge_msg_stack.add;

589: x_program_update_date := SYSDATE;
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(

Line 752: igs_ge_msg_stack.add;

748: OPEN c1;
749: FETCH c1 INTO tlinfo;
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;

Line 779: igs_ge_msg_stack.add;

775: ) THEN
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;

Line 843: igs_ge_msg_stack.add;

839: x_last_update_login := -1;
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(