DBA Data[Home] [Help]

APPS.IGS_DA_REQ_STDNTS_PKG dependencies on IGS_GE_MSG_STACK

Line 54: igs_ge_msg_stack.add;

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

Line 107: igs_ge_msg_stack.add;

103: ELSIF NOT igs_ps_course_pkg.get_pk_for_validation (
104: new_references.program_code
105: ) THEN
106: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
107: igs_ge_msg_stack.add;
108: app_exception.raise_exception;
109: END IF;
110:
111: IF (((old_references.wif_program_code = new_references.wif_program_code)) OR

Line 118: igs_ge_msg_stack.add;

114: ELSIF NOT igs_ps_course_pkg.get_pk_for_validation (
115: new_references.wif_program_code
116: ) THEN
117: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
118: igs_ge_msg_stack.add;
119: app_exception.raise_exception;
120: END IF;
121:
122: IF (((old_references.batch_id = new_references.batch_id) AND

Line 132: igs_ge_msg_stack.add;

128: new_references.batch_id,
129: new_references.wif_id
130: ) THEN
131: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
132: igs_ge_msg_stack.add;
133: app_exception.raise_exception;
134: END IF;
135:
136: END check_parent_existance;

Line 201: igs_ge_msg_stack.add;

197: FETCH cur_rowid INTO lv_rowid;
198: IF (cur_rowid%FOUND) THEN
199: CLOSE cur_rowid;
200: fnd_message.set_name ('IGS', 'IGS_DA_REQS_PSC_FK');
201: igs_ge_msg_stack.add;
202: app_exception.raise_exception;
203: RETURN;
204: END IF;
205: CLOSE cur_rowid;

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_DA_REQS_WIF_FK');
238: igs_ge_msg_stack.add;
239: app_exception.raise_exception;
240: RETURN;
241: END IF;
242: CLOSE cur_rowid;

Line 368: igs_ge_msg_stack.add;

364: new_references.igs_da_req_stdnts_id
365: )
366: ) THEN
367: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
368: igs_ge_msg_stack.add;
369: app_exception.raise_exception;
370: END IF;
371: check_parent_existance;
372: ELSIF (p_action = 'UPDATE') THEN

Line 382: igs_ge_msg_stack.add;

378: new_references.igs_da_req_stdnts_id
379: )
380: ) THEN
381: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
382: igs_ge_msg_stack.add;
383: app_exception.raise_exception;
384: END IF;
385: END IF;
386:

Line 437: igs_ge_msg_stack.add;

433: END IF;
434: ELSE
435: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
436: fnd_message.set_token ('ROUTINE', 'IGS_DA_REQ_STDNTS_PKG.INSERT_ROW');
437: igs_ge_msg_stack.add;
438: app_exception.raise_exception;
439: END IF;
440:
441: -- x_igs_da_req_stdnts_id := NULL;

Line 556: igs_ge_msg_stack.add;

552: OPEN c1;
553: FETCH c1 INTO tlinfo;
554: IF (c1%notfound) THEN
555: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
556: igs_ge_msg_stack.add;
557: CLOSE c1;
558: app_exception.raise_exception;
559: RETURN;
560: END IF;

Line 577: igs_ge_msg_stack.add;

573: ) THEN
574: NULL;
575: ELSE
576: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
577: igs_ge_msg_stack.add;
578: app_exception.raise_exception;
579: END IF;
580:
581: RETURN;

Line 632: igs_ge_msg_stack.add;

628: END IF;
629: ELSE
630: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
631: fnd_message.set_token ('ROUTINE', 'IGS_DA_REQ_STDNTS_PKG.UPDATE_ROW');
632: igs_ge_msg_stack.add;
633: app_exception.raise_exception;
634: END IF;
635:
636: -- x_igs_da_req_stdnts_id := NULL;