DBA Data[Home] [Help]

APPS.IGS_UC_CRSE_KEYWRDS_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.keyword
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.system_code = new_references.system_code) AND
116: (old_references.institute = new_references.institute) AND

Line 131: app_exception.raise_exception;

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

Line 160: app_exception.raise_exception;

156: new_references.keyword )
157: ) THEN
158: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
159: igs_ge_msg_stack.add;
160: app_exception.raise_exception;
161: END IF;
162:
163: END check_uniqueness;
164:

Line 280: app_exception.raise_exception;

276: IF (cur_rowid%FOUND) THEN
277: CLOSE cur_rowid;
278: fnd_message.set_name ('IGS', 'IGS_UC_UCCSKW_UCREKW_FK');
279: igs_ge_msg_stack.add;
280: app_exception.raise_exception;
281: RETURN;
282: END IF;
283: CLOSE cur_rowid;
284:

Line 321: app_exception.raise_exception;

317: IF (cur_rowid%FOUND) THEN
318: CLOSE cur_rowid;
319: fnd_message.set_name ('IGS', 'IGS_UC_UCCSKW_UCCSDE_FK');
320: igs_ge_msg_stack.add;
321: app_exception.raise_exception;
322: RETURN;
323: END IF;
324: CLOSE cur_rowid;
325:

Line 393: app_exception.raise_exception;

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

Line 409: app_exception.raise_exception;

405: )
406: ) THEN
407: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
408: igs_ge_msg_stack.add;
409: app_exception.raise_exception;
410: END IF;
411: END IF;
412:
413: END before_dml;

Line 475: app_exception.raise_exception;

471: END IF;
472: ELSE
473: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
474: igs_ge_msg_stack.add;
475: app_exception.raise_exception;
476: END IF;
477:
478: OPEN c_keyword;
479: FETCH c_keyword INTO x_crse_keyword_id;

Line 608: app_exception.raise_exception;

604: IF (c1%notfound) THEN
605: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
606: igs_ge_msg_stack.add;
607: CLOSE c1;
608: app_exception.raise_exception;
609: RETURN;
610: END IF;
611: CLOSE c1;
612:

Line 630: app_exception.raise_exception;

626: NULL;
627: ELSE
628: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
629: igs_ge_msg_stack.add;
630: app_exception.raise_exception;
631: END IF;
632:
633: RETURN;
634:

Line 686: app_exception.raise_exception;

682: END IF;
683: ELSE
684: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
685: igs_ge_msg_stack.add;
686: app_exception.raise_exception;
687: END IF;
688:
689: before_dml(
690: p_action => 'UPDATE',