DBA Data[Home] [Help]

APPS.IGS_PS_RSV_OGPRI_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 94: app_exception.raise_exception;

90: )
91: ) THEN
92: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
93: igs_ge_msg_stack.add;
94: app_exception.raise_exception;
95: END IF;
96:
97: END check_uniqueness;
98:

Line 135: app_exception.raise_exception;

131: FETCH c_check_hz_exists into cur_rec_hz_exists;
132: IF c_check_hz_exists%NotFound THEN
133: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
134: igs_ge_msg_stack.add;
135: app_exception.raise_exception;
136: END IF;
137: END IF;
138:
139: END check_parent_existance;

Line 263: app_exception.raise_exception;

259: IF (cur_rowid%FOUND) THEN
260: CLOSE cur_rowid;
261: fnd_message.set_name ('IGS', 'IGS_PS_ROPF_HZ_PARTIES_FK');
262: igs_ge_msg_stack.add;
263: app_exception.raise_exception;
264: RETURN;
265: END IF;
266: CLOSE cur_rowid;
267:

Line 318: app_exception.raise_exception;

314: )
315: ) THEN
316: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
317: igs_ge_msg_stack.add;
318: app_exception.raise_exception;
319: END IF;
320: check_uniqueness;
321: check_parent_existance;
322: ELSIF (p_action = 'UPDATE') THEN

Line 337: app_exception.raise_exception;

333: )
334: ) THEN
335: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
336: igs_ge_msg_stack.add;
337: app_exception.raise_exception;
338: END IF;
339: check_uniqueness;
340: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
341: check_uniqueness;

Line 395: app_exception.raise_exception;

391: END IF;
392: ELSE
393: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
394: igs_ge_msg_stack.add;
395: app_exception.raise_exception;
396: END IF;
397:
398: SELECT igs_ps_rsv_ogpri_all_s.NEXTVAL
399: INTO x_rsv_org_unit_pri_id

Line 488: app_exception.raise_exception;

484: IF (c1%notfound) THEN
485: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
486: igs_ge_msg_stack.add;
487: CLOSE c1;
488: app_exception.raise_exception;
489: RETURN;
490: END IF;
491: CLOSE c1;
492:

Line 502: app_exception.raise_exception;

498: NULL;
499: ELSE
500: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
501: igs_ge_msg_stack.add;
502: app_exception.raise_exception;
503: END IF;
504:
505: RETURN;
506:

Line 549: app_exception.raise_exception;

545: END IF;
546: ELSE
547: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
548: igs_ge_msg_stack.add;
549: app_exception.raise_exception;
550: END IF;
551:
552: before_dml(
553: p_action => 'UPDATE',