DBA Data[Home] [Help]

APPS.IGS_PS_USEC_X_GRP_PKG dependencies on APP_EXCEPTION

Line 52: app_exception.raise_exception;

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

Line 101: app_exception.raise_exception;

97: )
98: ) THEN
99: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
100: igs_ge_msg_stack.add;
101: app_exception.raise_exception;
102: END IF;
103:
104: END check_uniqueness;
105:

Line 130: app_exception.raise_exception;

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

Line 258: app_exception.raise_exception;

254: IF (cur_rowid%FOUND) THEN
255: CLOSE cur_rowid;
256: fnd_message.set_name ('IGS', 'IGS_PS_CI_USXG_FK1');
257: igs_ge_msg_stack.add;
258: app_exception.raise_exception;
259: RETURN;
260: END IF;
261: CLOSE cur_rowid;
262:

Line 320: app_exception.raise_exception;

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

Line 339: app_exception.raise_exception;

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

Line 399: app_exception.raise_exception;

395: END IF;
396: ELSE
397: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
398: igs_ge_msg_stack.add;
399: app_exception.raise_exception;
400: END IF;
401:
402: SELECT igs_ps_usec_x_grp_s.NEXTVAL
403: INTO x_usec_x_listed_group_id

Line 504: app_exception.raise_exception;

500: IF (c1%notfound) THEN
501: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
502: igs_ge_msg_stack.add;
503: CLOSE c1;
504: app_exception.raise_exception;
505: RETURN;
506: END IF;
507: CLOSE c1;
508:

Line 523: app_exception.raise_exception;

519: NULL;
520: ELSE
521: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
522: igs_ge_msg_stack.add;
523: app_exception.raise_exception;
524: END IF;
525:
526: RETURN;
527:

Line 574: app_exception.raise_exception;

570: END IF;
571: ELSE
572: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
573: igs_ge_msg_stack.add;
574: app_exception.raise_exception;
575: END IF;
576:
577: before_dml(
578: p_action => 'UPDATE',