DBA Data[Home] [Help]

APPS.IGS_EN_NSD_DLSTP_PKG dependencies on APP_EXCEPTION

Line 53: app_exception.raise_exception;

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

Line 104: app_exception.raise_exception;

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

Line 136: app_exception.raise_exception;

132: new_references.org_unit_code
133: ) THEN
134: fnd_message.set_name ('FND','FORM_RECORD_DELETED');
135: igs_ge_msg_stack.add;
136: app_exception.raise_exception;
137: END IF;
138:
139: IF (((old_references.administrative_unit_status = new_references.administrative_unit_status)) OR
140: ((new_references.administrative_unit_status IS NULL))) THEN

Line 148: app_exception.raise_exception;

144: 'N'
145: ) THEN
146: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
147: igs_ge_msg_stack.add;
148: app_exception.raise_exception;
149: END IF;
150:
151: END check_parent_existance;
152:

Line 307: app_exception.raise_exception;

303: )
304: ) THEN
305: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
306: igs_ge_msg_stack.add;
307: app_exception.raise_exception;
308: END IF;
309: check_uniqueness;
310: check_parent_existance;
311: ELSIF (p_action = 'UPDATE') THEN

Line 326: app_exception.raise_exception;

322: )
323: ) THEN
324: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
325: igs_ge_msg_stack.add;
326: app_exception.raise_exception;
327: END IF;
328: check_uniqueness;
329: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
330: check_uniqueness;

Line 387: app_exception.raise_exception;

383: END IF;
384: ELSE
385: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
386: igs_ge_msg_stack.add;
387: app_exception.raise_exception;
388: END IF;
389:
390: SELECT igs_en_nsd_dlstp_all_s.NEXTVAL
391: INTO x_non_std_disc_dl_stp_id

Line 506: app_exception.raise_exception;

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

Line 525: app_exception.raise_exception;

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

Line 577: app_exception.raise_exception;

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