APPS.IGS_DA_REQ_WIF_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 112: igs_ge_msg_stack.add;

108: ELSIF NOT igs_da_rqst_pkg.get_pk_for_validation (
109: new_references.batch_id
110: ) THEN
111: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
112: igs_ge_msg_stack.add;
113: app_exception.raise_exception;
114: END IF;
115: IF (((old_references.program_code = new_references.program_code)) OR
116: ((new_references.program_code IS NULL))) THEN

Line 122: igs_ge_msg_stack.add;

118: ELSIF NOT igs_ps_course_pkg.get_pk_for_validation (
119: new_references.program_code
120: ) THEN
121: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
122: igs_ge_msg_stack.add;
123: app_exception.raise_exception;
124: END IF;
125: IF (((old_references.catalog_cal_type = new_references.catalog_cal_type) AND
126: (old_references.catalog_ci_seq_num = new_references.catalog_ci_seq_num)) OR

Line 135: igs_ge_msg_stack.add;

131: new_references.catalog_cal_type,
132: new_references.catalog_ci_seq_num
133: ) THEN
134: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
135: igs_ge_msg_stack.add;
136: app_exception.raise_exception;
137: END IF;
138:
139: END check_parent_existance;

Line 225: igs_ge_msg_stack.add;

221: FETCH cur_rowid INTO lv_rowid;
222: IF (cur_rowid%FOUND) THEN
223: CLOSE cur_rowid;
224: fnd_message.set_name ('IGS', 'IGS_DA_RQST_WIF_FK');
225: igs_ge_msg_stack.add;
226: app_exception.raise_exception;
227: RETURN;
228: END IF;
229: CLOSE cur_rowid;

Line 260: igs_ge_msg_stack.add;

256: FETCH cur_rowid INTO lv_rowid;
257: IF (cur_rowid%FOUND) THEN
258: CLOSE cur_rowid;
259: fnd_message.set_name ('IGS', 'IGS_DA_PS_WIF_FK');
260: igs_ge_msg_stack.add;
261: app_exception.raise_exception;
262: RETURN;
263: END IF;
264: CLOSE cur_rowid;

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_DA_CA_WIF_FK');
297: igs_ge_msg_stack.add;
298: app_exception.raise_exception;
299: RETURN;
300: END IF;
301: CLOSE cur_rowid;

Line 371: igs_ge_msg_stack.add;

367: new_references.wif_id
368: )
369: ) THEN
370: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
371: igs_ge_msg_stack.add;
372: app_exception.raise_exception;
373: END IF;
374: check_parent_existance;
375: ELSIF (p_action = 'UPDATE') THEN

Line 389: igs_ge_msg_stack.add;

385: new_references.wif_id
386: )
387: ) THEN
388: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
389: igs_ge_msg_stack.add;
390: app_exception.raise_exception;
391: END IF;
392: ELSIF (p_action = 'VALIDATE_DELETE') THEN
393: check_child_existance;

Line 452: igs_ge_msg_stack.add;

448: END IF;
449: ELSE
450: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
451: fnd_message.set_token ('ROUTINE', 'IGS_DA_REQ_WIF_PKG.INSERT_ROW');
452: igs_ge_msg_stack.add;
453: app_exception.raise_exception;
454: END IF;
455: before_dml(
456: p_action => 'INSERT',

Line 612: igs_ge_msg_stack.add;

608: OPEN c1;
609: FETCH c1 INTO tlinfo;
610: IF (c1%notfound) THEN
611: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
612: igs_ge_msg_stack.add;
613: CLOSE c1;
614: app_exception.raise_exception;
615: RETURN;
616: END IF;

Line 636: igs_ge_msg_stack.add;

632: ) THEN
633: NULL;
634: ELSE
635: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
636: igs_ge_msg_stack.add;
637: RAISE FND_API.G_EXC_ERROR;
638: END IF;
639:
640: -- Initialize API return status to success.

Line 731: igs_ge_msg_stack.add;

727: END IF;
728: ELSE
729: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
730: fnd_message.set_token ('ROUTINE', 'IGS_DA_REQ_WIF_PKG.UPDATE_ROW');
731: igs_ge_msg_stack.add;
732: app_exception.raise_exception;
733: END IF;
734:
735: before_dml(