DBA Data[Home] [Help]

APPS.IGS_DA_RQST_PKG dependencies on IGS_GE_MSG_STACK

Line 75: igs_ge_msg_stack.add;

71: FETCH cur_old_ref_values INTO old_references;
72: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
73: CLOSE cur_old_ref_values;
74: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
75: igs_ge_msg_stack.add;
76: app_exception.raise_exception;
77: RETURN;
78: END IF;
79: CLOSE cur_old_ref_values;

Line 149: igs_ge_msg_stack.add;

145: ELSIF NOT igs_da_cnfg_req_typ_pkg.get_pk_for_validation (
146: new_references.request_type_id
147: ) THEN
148: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
149: igs_ge_msg_stack.add;
150: app_exception.raise_exception;
151: END IF;
152:
153: IF (((old_references.person_id_group_id = new_references.person_id_group_id)) OR

Line 160: igs_ge_msg_stack.add;

156: ELSIF NOT igs_pe_persid_group_pkg.get_pk_for_validation (
157: new_references.person_id_group_id
158: ) THEN
159: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
160: igs_ge_msg_stack.add;
161: app_exception.raise_exception;
162: END IF;
163:
164: END check_parent_existance;

Line 251: igs_ge_msg_stack.add;

247: FETCH cur_rowid INTO lv_rowid;
248: IF (cur_rowid%FOUND) THEN
249: CLOSE cur_rowid;
250: fnd_message.set_name ('IGS', 'IGS_DA_CNFG_RQST_FK');
251: igs_ge_msg_stack.add;
252: app_exception.raise_exception;
253: RETURN;
254: END IF;
255: CLOSE cur_rowid;

Line 286: igs_ge_msg_stack.add;

282: FETCH cur_rowid INTO lv_rowid;
283: IF (cur_rowid%FOUND) THEN
284: CLOSE cur_rowid;
285: fnd_message.set_name ('IGS', 'IGS_DA_PERSON_RQST_FK');
286: igs_ge_msg_stack.add;
287: app_exception.raise_exception;
288: RETURN;
289: END IF;
290: CLOSE cur_rowid;

Line 395: igs_ge_msg_stack.add;

391: new_references.batch_id
392: )
393: ) THEN
394: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
395: igs_ge_msg_stack.add;
396: app_exception.raise_exception;
397: END IF;
398: check_parent_existance;
399: ELSIF (p_action = 'UPDATE') THEN

Line 412: igs_ge_msg_stack.add;

408: new_references.batch_id
409: )
410: ) THEN
411: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
412: igs_ge_msg_stack.add;
413: app_exception.raise_exception;
414: END IF;
415: ELSIF (p_action = 'VALIDATE_DELETE') THEN
416: check_child_existance;

Line 492: igs_ge_msg_stack.add;

488: END IF;
489: ELSE
490: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
491: fnd_message.set_token ('ROUTINE', 'IGS_DA_RQST_PKG.INSERT_ROW');
492: igs_ge_msg_stack.add;
493: app_exception.raise_exception;
494: END IF;
495: -- x_batch_id := NULL;
496:

Line 747: igs_ge_msg_stack.add;

743: OPEN c1;
744: FETCH c1 INTO tlinfo;
745: IF (c1%notfound) THEN
746: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
747: igs_ge_msg_stack.add;
748: CLOSE c1;
749: app_exception.raise_exception;
750: RETURN;
751: END IF;

Line 790: igs_ge_msg_stack.add;

786: ) THEN
787: NULL;
788: ELSE
789: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
790: igs_ge_msg_stack.add;
791: RAISE FND_API.G_EXC_ERROR;
792: END IF;
793:
794: -- Initialize API return status to success.

Line 902: igs_ge_msg_stack.add;

898: END IF;
899: ELSE
900: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
901: fnd_message.set_token ('ROUTINE', 'IGS_DA_RQST_PKG.UPDATE_ROW');
902: igs_ge_msg_stack.add;
903: app_exception.raise_exception;
904: END IF;
905:
906: -- x_batch_id := NULL;