APPS.IGS_PS_USEC_RU_PKG dependencies on APP_EXCEPTION

Line 48: app_exception.raise_exception;

44: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
45: CLOSE cur_old_ref_values;
46: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
47: igs_ge_msg_stack.add;
48: app_exception.raise_exception;
49: RETURN;
50: END IF;
51: CLOSE cur_old_ref_values;
52:

Line 91: app_exception.raise_exception;

87: new_references.s_rule_call_cd)
88: ) THEN
89: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
90: igs_ge_msg_stack.add;
91: app_exception.raise_exception;
92: END IF;
93:
94: END check_uniqueness;
95:

Line 117: app_exception.raise_exception;

113: new_references.uoo_id
114: ) THEN
115: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
116: igs_ge_msg_stack.add;
117: app_exception.raise_exception;
118: END IF;
119:
120: IF (((old_references.s_rule_call_cd = new_references.s_rule_call_cd)) OR
121: ((new_references.s_rule_call_cd IS NULL))) THEN

Line 128: app_exception.raise_exception;

124: new_references.s_rule_call_cd
125: ) THEN
126: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
127: igs_ge_msg_stack.add;
128: app_exception.raise_exception;
129: END IF;
130:
131: IF (((old_references.rul_sequence_number = new_references.rul_sequence_number)) OR
132: ((new_references.rul_sequence_number IS NULL))) THEN

Line 139: app_exception.raise_exception;

135: new_references.rul_sequence_number
136: ) THEN
137: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
138: igs_ge_msg_stack.add;
139: app_exception.raise_exception;
140: END IF;
141:
142: END check_parent_existance;
143:

Line 243: app_exception.raise_exception;

239: IF (cur_rowid%FOUND) THEN
240: CLOSE cur_rowid;
241: fnd_message.set_name ('IGS', 'IGS_PS_PURU_UOO_FK');
242: igs_ge_msg_stack.add;
243: app_exception.raise_exception;
244: RETURN;
245: END IF;
246: CLOSE cur_rowid;
247:

Line 278: app_exception.raise_exception;

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

Line 313: app_exception.raise_exception;

309: IF (cur_rowid%FOUND) THEN
310: CLOSE cur_rowid;
311: fnd_message.set_name ('IGS', 'IGS_PS_PURU_RUL_FK');
312: igs_ge_msg_stack.add;
313: app_exception.raise_exception;
314: RETURN;
315: END IF;
316: CLOSE cur_rowid;
317:

Line 368: app_exception.raise_exception;

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

Line 384: app_exception.raise_exception;

380: )
381: ) THEN
382: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
383: igs_ge_msg_stack.add;
384: app_exception.raise_exception;
385: END IF;
386: check_uniqueness;
387: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
388: check_uniqueness;

Line 438: app_exception.raise_exception;

434: END IF;
435: ELSE
436: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
437: igs_ge_msg_stack.add;
438: app_exception.raise_exception;
439: END IF;
440:
441: SELECT igs_ps_usec_ru_s.NEXTVAL
442: INTO x_usecru_id

Line 527: app_exception.raise_exception;

523: IF (c1%notfound) THEN
524: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
525: igs_ge_msg_stack.add;
526: CLOSE c1;
527: app_exception.raise_exception;
528: RETURN;
529: END IF;
530: CLOSE c1;
531:

Line 541: app_exception.raise_exception;

537: NULL;
538: ELSE
539: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
540: igs_ge_msg_stack.add;
541: app_exception.raise_exception;
542: END IF;
543:
544: RETURN;
545:

Line 588: app_exception.raise_exception;

584: END IF;
585: ELSE
586: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
587: igs_ge_msg_stack.add;
588: app_exception.raise_exception;
589: END IF;
590:
591: before_dml(
592: p_action => 'UPDATE',