APPS.IGS_DA_CNFG_REQ_TYP_PKG dependencies on APP_EXCEPTION

Line 86: app_exception.raise_exception;

82: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
83: CLOSE cur_old_ref_values;
84: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
85: igs_ge_msg_stack.add;
86: app_exception.raise_exception;
87: RETURN;
88: END IF;
89: CLOSE cur_old_ref_values;
90:

Line 210: app_exception.raise_exception;

206: )
207: ) THEN
208: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
209: igs_ge_msg_stack.add;
210: app_exception.raise_exception;
211: END IF;
212:
213: END check_uniqueness;
214:

Line 235: app_exception.raise_exception;

231: new_references.wif_program_code
232: ) THEN
233: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
234: igs_ge_msg_stack.add;
235: app_exception.raise_exception;
236: END IF;
237:
238: IF (((old_references.wif_catalog_cal_type = new_references.wif_catalog_cal_type) AND
239: (old_references.wif_catalog_ci_seq_num = new_references.wif_catalog_ci_seq_num)) OR

Line 249: app_exception.raise_exception;

245: new_references.wif_catalog_ci_seq_num
246: ) THEN
247: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
248: igs_ge_msg_stack.add;
249: app_exception.raise_exception;
250: END IF;
251:
252: END check_parent_existance;
253:

Line 348: app_exception.raise_exception;

344: IF (cur_rowid%FOUND) THEN
345: CLOSE cur_rowid;
346: fnd_message.set_name ('IGS', 'IGS_DA_CNFG_PSC_FK');
347: igs_ge_msg_stack.add;
348: app_exception.raise_exception;
349: RETURN;
350: END IF;
351: CLOSE cur_rowid;
352:

Line 385: app_exception.raise_exception;

381: IF (cur_rowid%FOUND) THEN
382: CLOSE cur_rowid;
383: fnd_message.set_name ('IGS', 'IGS_DA_CNFG_CAI_FK');
384: igs_ge_msg_stack.add;
385: app_exception.raise_exception;
386: RETURN;
387: END IF;
388: CLOSE cur_rowid;
389:

Line 516: app_exception.raise_exception;

512: )
513: ) THEN
514: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
515: igs_ge_msg_stack.add;
516: app_exception.raise_exception;
517: END IF;
518: check_uniqueness;
519: check_parent_existance;
520: ELSIF (p_action = 'UPDATE') THEN

Line 535: app_exception.raise_exception;

531: )
532: ) THEN
533: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
534: igs_ge_msg_stack.add;
535: app_exception.raise_exception;
536: END IF;
537: check_uniqueness;
538: ELSIF (p_action = 'VALIDATE_DELETE') THEN
539: check_child_existance;

Line 624: app_exception.raise_exception;

620: ELSE
621: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
622: fnd_message.set_token ('ROUTINE', 'IGS_DA_CNFG_REQ_TYP_PKG.INSERT_ROW');
623: igs_ge_msg_stack.add;
624: app_exception.raise_exception;
625: END IF;
626:
627: -- x_request_type_id := NULL; -- Commented by Deep. Need to be verified
628:

Line 893: app_exception.raise_exception;

889: IF (c1%notfound) THEN
890: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
891: igs_ge_msg_stack.add;
892: CLOSE c1;
893: app_exception.raise_exception;
894: RETURN;
895: END IF;
896: CLOSE c1;
897:

Line 945: app_exception.raise_exception;

941: NULL;
942: ELSE
943: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
944: igs_ge_msg_stack.add;
945: app_exception.raise_exception;
946: END IF;
947:
948: RETURN;
949:

Line 1031: app_exception.raise_exception;

1027: ELSE
1028: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1029: fnd_message.set_token ('ROUTINE', 'IGS_DA_CNFG_REQ_TYP_PKG.UPDATE_ROW');
1030: igs_ge_msg_stack.add;
1031: app_exception.raise_exception;
1032: END IF;
1033:
1034: -- x_request_type_id := NULL; -- Commented by Deep. Need to be verified
1035: