APPS.IGS_EN_SPL_PERM_H_PKG dependencies on APP_EXCEPTION

Line 57: app_exception.raise_exception;

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

Line 112: app_exception.raise_exception;

108: new_references.spl_perm_request_id
109: ) THEN
110: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
111: igs_ge_msg_stack.add;
112: app_exception.raise_exception;
113: END IF;
114:
115: IF (((old_references.transaction_type =
116: new_references.transaction_type)) OR

Line 124: App_Exception.Raise_Exception;

120: IF NOT IGS_LOOKUPS_VIEW_Pkg.Get_PK_For_Validation ('SPL_PERM_TRANSCTION_TYPE',
121: new_references.transaction_type) THEN
122: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
123: Igs_Ge_Msg_Stack.Add;
124: App_Exception.Raise_Exception;
125: END IF;
126: END IF;
127:
128:

Line 194: app_exception.raise_exception;

190: IF (cur_rowid%FOUND) THEN
191: CLOSE cur_rowid;
192: fnd_message.set_name ('IGS', 'IGS_EN_SPH_SPLP_FK');
193: igs_ge_msg_stack.add;
194: app_exception.raise_exception;
195: RETURN;
196: END IF;
197: CLOSE cur_rowid;
198:

Line 267: app_exception.raise_exception;

263: )
264: ) THEN
265: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
266: igs_ge_msg_stack.add;
267: app_exception.raise_exception;
268: END IF;
269: check_parent_existance;
270: ELSIF (p_action = 'UPDATE') THEN
271: -- Call all the procedures related to Before Update.

Line 281: app_exception.raise_exception;

277: )
278: ) THEN
279: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
280: igs_ge_msg_stack.add;
281: app_exception.raise_exception;
282: END IF;
283: END IF;
284:
285: END before_dml;

Line 341: app_exception.raise_exception;

337: END IF;
338: ELSE
339: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
340: igs_ge_msg_stack.add;
341: app_exception.raise_exception;
342: END IF;
343:
344: SELECT igs_en_spl_perm_h_s.NEXTVAL
345: INTO x_spl_perm_request_h_id

Line 475: app_exception.raise_exception;

471: IF (c1%notfound) THEN
472: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
473: igs_ge_msg_stack.add;
474: CLOSE c1;
475: app_exception.raise_exception;
476: RETURN;
477: END IF;
478: CLOSE c1;
479:

Line 498: app_exception.raise_exception;

494: NULL;
495: ELSE
496: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
497: igs_ge_msg_stack.add;
498: app_exception.raise_exception;
499: END IF;
500:
501: RETURN;
502:

Line 554: app_exception.raise_exception;

550: END IF;
551: ELSE
552: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
553: igs_ge_msg_stack.add;
554: app_exception.raise_exception;
555: END IF;
556:
557: before_dml(
558: p_action => 'UPDATE',