DBA Data[Home] [Help]

APPS.IGF_AW_AWARD_LEVEL_HIST_PKG dependencies on IGS_GE_MSG_STACK

Line 85: igs_ge_msg_stack.add;

81: FETCH cur_old_ref_values INTO old_references;
82: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
83: CLOSE cur_old_ref_values;
84: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
85: igs_ge_msg_stack.add;
86: app_exception.raise_exception;
87: RETURN;
88: END IF;
89: CLOSE cur_old_ref_values;

Line 143: igs_ge_msg_stack.add;

139: ELSIF NOT igf_aw_awd_dist_plans_pkg.get_pk_for_validation (
140: new_references.old_adplans_id
141: ) THEN
142: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
143: igs_ge_msg_stack.add;
144: app_exception.raise_exception;
145: END IF;
146:
147: IF (((old_references.new_adplans_id = new_references.new_adplans_id)) OR

Line 154: igs_ge_msg_stack.add;

150: ELSIF NOT igf_aw_awd_dist_plans_pkg.get_pk_for_validation (
151: new_references.new_adplans_id
152: ) THEN
153: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
154: igs_ge_msg_stack.add;
155: app_exception.raise_exception;
156: END IF;
157:
158: IF (((old_references.award_id = new_references.award_id)) OR

Line 165: igs_ge_msg_stack.add;

161: ELSIF NOT igf_aw_award_pkg.get_pk_for_validation (
162: new_references.award_id
163: ) THEN
164: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
165: igs_ge_msg_stack.add;
166: app_exception.raise_exception;
167: END IF;
168:
169: END check_parent_existance;

Line 238: igs_ge_msg_stack.add;

234: FETCH cur_rowid INTO lv_rowid;
235: IF (cur_rowid%FOUND) THEN
236: CLOSE cur_rowid;
237: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');
238: igs_ge_msg_stack.add;
239: app_exception.raise_exception;
240: RETURN;
241: END IF;
242: CLOSE cur_rowid;

Line 273: igs_ge_msg_stack.add;

269: FETCH cur_rowid INTO lv_rowid;
270: IF (cur_rowid%FOUND) THEN
271: CLOSE cur_rowid;
272: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');
273: igs_ge_msg_stack.add;
274: app_exception.raise_exception;
275: RETURN;
276: END IF;
277: CLOSE cur_rowid;

Line 354: igs_ge_msg_stack.add;

350: new_references.award_attrib_code
351: )
352: ) THEN
353: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
354: igs_ge_msg_stack.add;
355: app_exception.raise_exception;
356: END IF;
357: check_parent_existance;
358: ELSIF (p_action = 'UPDATE') THEN

Line 370: igs_ge_msg_stack.add;

366: new_references.award_attrib_code
367: )
368: ) THEN
369: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
370: igs_ge_msg_stack.add;
371: app_exception.raise_exception;
372: END IF;
373: END IF;
374:

Line 446: igs_ge_msg_stack.add;

442: END IF;
443: ELSE
444: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
445: fnd_message.set_token ('ROUTINE', 'IGF_AW_AWARD_LEVEL_HIST_PKG.INSERT_ROW');
446: igs_ge_msg_stack.add;
447: app_exception.raise_exception;
448: END IF;
449:
450: --new_references.org_id := igs_ge_gen_003.get_org_id;

Line 590: igs_ge_msg_stack.add;

586: OPEN c1;
587: FETCH c1 INTO tlinfo;
588: IF (c1%notfound) THEN
589: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
590: igs_ge_msg_stack.add;
591: CLOSE c1;
592: app_exception.raise_exception;
593: RETURN;
594: END IF;

Line 615: igs_ge_msg_stack.add;

611: ) THEN
612: NULL;
613: ELSE
614: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
615: igs_ge_msg_stack.add;
616: app_exception.raise_exception;
617: END IF;
618:
619: RETURN;

Line 679: igs_ge_msg_stack.add;

675: END IF;
676: ELSE
677: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
678: fnd_message.set_token ('ROUTINE', 'IGF_AW_AWARD_LEVEL_HIST_PKG.UPDATE_ROW');
679: igs_ge_msg_stack.add;
680: app_exception.raise_exception;
681: END IF;
682:
683: before_dml(