DBA Data[Home] [Help]

APPS.IGS_CO_OU_CO_REF_PKG dependencies on IGS_GE_MSG_STACK

Line 57: igs_ge_msg_stack.add;

53: FETCH cur_old_ref_values INTO old_references;
54: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
55: CLOSE cur_old_ref_values;
56: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
57: igs_ge_msg_stack.add;
58: app_exception.raise_exception;
59: RETURN;
60: END IF;
61: CLOSE cur_old_ref_values;

Line 123: igs_ge_msg_stack.add;

119: IF (UPPER(column_name) = 'REFERENCE_NUMBER' OR column_name IS NULL) THEN
120: IF NOT (new_references.reference_number BETWEEN 1
121: AND 999999) THEN
122: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
123: igs_ge_msg_stack.add;
124: app_exception.raise_exception;
125: END IF;
126: END IF;
127:

Line 132: igs_ge_msg_stack.add;

128: IF (UPPER(column_name) = 'SEQUENCE_NUMBER' OR column_name IS NULL) THEN
129: IF NOT (new_references.sequence_number BETWEEN 1
130: AND 999999) THEN
131: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
132: igs_ge_msg_stack.add;
133: app_exception.raise_exception;
134: END IF;
135: END IF;
136:

Line 141: igs_ge_msg_stack.add;

137: IF (UPPER(column_name) = 'CI_SEQUENCE_NUMBER' OR column_name IS NULL) THEN
138: IF NOT (new_references.ci_sequence_number BETWEEN 1
139: AND 999999) THEN
140: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
141: igs_ge_msg_stack.add;
142: app_exception.raise_exception;
143: END IF;
144: END IF;
145:

Line 171: igs_ge_msg_stack.add;

167: new_references.cal_type,
168: new_references.ci_sequence_number
169: ) THEN
170: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
171: igs_ge_msg_stack.add;
172: app_exception.raise_exception;
173: END IF;
174:
175: IF (((old_references.unit_cd = new_references.unit_cd) AND

Line 185: igs_ge_msg_stack.add;

181: new_references.unit_cd,
182: new_references.uv_version_number
183: ) THEN
184: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
185: igs_ge_msg_stack.add;
186: app_exception.raise_exception;
187: END IF;
188:
189: IF (((old_references.course_cd = new_references.course_cd) AND

Line 199: igs_ge_msg_stack.add;

195: new_references.course_cd,
196: new_references.cv_version_number
197: ) THEN
198: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
199: igs_ge_msg_stack.add;
200: app_exception.raise_exception;
201: END IF;
202:
203: IF (((old_references.person_id = new_references.person_id) AND

Line 219: igs_ge_msg_stack.add;

215: new_references.reference_number,
216: new_references.issue_dt
217: ) THEN
218: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
219: igs_ge_msg_stack.add;
220: app_exception.raise_exception;
221: END IF;
222:
223: END check_parent_existance;

Line 297: igs_ge_msg_stack.add;

293: FETCH cur_rowid INTO lv_rowid;
294: IF (cur_rowid%FOUND) THEN
295: CLOSE cur_rowid;
296: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
297: igs_ge_msg_stack.add;
298: app_exception.raise_exception;
299: RETURN;
300: END IF;
301: CLOSE cur_rowid;

Line 334: igs_ge_msg_stack.add;

330: FETCH cur_rowid INTO lv_rowid;
331: IF (cur_rowid%FOUND) THEN
332: CLOSE cur_rowid;
333: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
334: igs_ge_msg_stack.add;
335: app_exception.raise_exception;
336: RETURN;
337: END IF;
338: CLOSE cur_rowid;

Line 371: igs_ge_msg_stack.add;

367: FETCH cur_rowid INTO lv_rowid;
368: IF (cur_rowid%FOUND) THEN
369: CLOSE cur_rowid;
370: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
371: igs_ge_msg_stack.add;
372: app_exception.raise_exception;
373: RETURN;
374: END IF;
375: CLOSE cur_rowid;

Line 412: igs_ge_msg_stack.add;

408: FETCH cur_rowid INTO lv_rowid;
409: IF (cur_rowid%FOUND) THEN
410: CLOSE cur_rowid;
411: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
412: igs_ge_msg_stack.add;
413: app_exception.raise_exception;
414: RETURN;
415: END IF;
416: CLOSE cur_rowid;

Line 491: igs_ge_msg_stack.add;

487: new_references.sequence_number
488: )
489: ) THEN
490: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
491: igs_ge_msg_stack.add;
492: app_exception.raise_exception;
493: END IF;
494: check_constraints;
495: check_parent_existance;

Line 511: igs_ge_msg_stack.add;

507: new_references.sequence_number
508: )
509: ) THEN
510: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
511: igs_ge_msg_stack.add;
512: app_exception.raise_exception;
513: END IF;
514: check_constraints;
515: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 595: igs_ge_msg_stack.add;

591: x_program_update_date := SYSDATE;
592: END IF;
593: ELSE
594: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
595: igs_ge_msg_stack.add;
596: app_exception.raise_exception;
597: END IF;
598:
599: before_dml(

Line 731: igs_ge_msg_stack.add;

727: OPEN c1;
728: FETCH c1 INTO tlinfo;
729: IF (c1%notfound) THEN
730: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
731: igs_ge_msg_stack.add;
732: CLOSE c1;
733: app_exception.raise_exception;
734: RETURN;
735: END IF;

Line 751: igs_ge_msg_stack.add;

747: ) THEN
748: NULL;
749: ELSE
750: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
751: igs_ge_msg_stack.add;
752: app_exception.raise_exception;
753: END IF;
754:
755: RETURN;

Line 811: igs_ge_msg_stack.add;

807: x_last_update_login := -1;
808: END IF;
809: ELSE
810: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
811: igs_ge_msg_stack.add;
812: app_exception.raise_exception;
813: END IF;
814:
815: before_dml(