DBA Data[Home] [Help]

APPS.IGS_PS_FAC_WL_PKG dependencies on APP_EXCEPTION

Line 70: app_exception.raise_exception;

66: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
67: CLOSE cur_old_ref_values;
68: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
69: igs_ge_msg_stack.add;
70: app_exception.raise_exception;
71: RETURN;
72: END IF;
73: CLOSE cur_old_ref_values;
74:

Line 138: app_exception.raise_exception;

134: )
135: ) THEN
136: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
137: igs_ge_msg_stack.add;
138: app_exception.raise_exception;
139: END IF;
140:
141: END check_uniqueness;
142:

Line 168: app_exception.raise_exception;

164: FETCH cur_hz INTO rec_hz;
165: IF cur_hz%NOTFOUND THEN
166: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
167: igs_ge_msg_stack.add;
168: app_exception.raise_exception;
169: END IF;
170: CLOSE cur_hz;
171: END IF;
172:

Line 184: app_exception.raise_exception;

180: new_references.ci_sequence_number
181: ) THEN
182: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
183: igs_ge_msg_stack.add;
184: app_exception.raise_exception;
185: END IF;
186:
187: END check_parent_existance;
188:

Line 315: app_exception.raise_exception;

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

Line 414: app_exception.raise_exception;

410: )
411: ) THEN
412: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
413: igs_ge_msg_stack.add;
414: app_exception.raise_exception;
415: END IF;
416: check_uniqueness;
417: check_parent_existance;
418: ELSIF (p_action = 'UPDATE') THEN

Line 433: app_exception.raise_exception;

429: )
430: ) THEN
431: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
432: igs_ge_msg_stack.add;
433: app_exception.raise_exception;
434: END IF;
435: check_uniqueness;
436: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
437: check_uniqueness;

Line 511: app_exception.raise_exception;

507: END IF;
508: ELSE
509: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
510: igs_ge_msg_stack.add;
511: app_exception.raise_exception;
512: END IF;
513:
514: SELECT igs_ps_fac_wl_s.NEXTVAL
515: INTO x_fac_wl_id

Line 711: app_exception.raise_exception;

707: IF (c1%notfound) THEN
708: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
709: igs_ge_msg_stack.add;
710: CLOSE c1;
711: app_exception.raise_exception;
712: RETURN;
713: END IF;
714: CLOSE c1;
715:

Line 747: app_exception.raise_exception;

743: NULL;
744: ELSE
745: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
746: igs_ge_msg_stack.add;
747: app_exception.raise_exception;
748: END IF;
749:
750: RETURN;
751:

Line 816: app_exception.raise_exception;

812: END IF;
813: ELSE
814: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
815: igs_ge_msg_stack.add;
816: app_exception.raise_exception;
817: END IF;
818:
819: before_dml(
820: p_action => 'UPDATE',