DBA Data[Home] [Help]

APPS.IGF_AP_PERSON_MATCH_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 105: app_exception.raise_exception;

101: new_references.ci_sequence_number
102: ) THEN
103: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
104: igs_ge_msg_stack.add;
105: app_exception.raise_exception;
106: END IF;
107:
108: END check_parent_existance;
109:

Line 194: app_exception.raise_exception;

190: IF (cur_rowid%FOUND) THEN
191: CLOSE cur_rowid;
192: fnd_message.set_name ('IGF', 'IGF_AP_APM_CA_FK');
193: igs_ge_msg_stack.add;
194: app_exception.raise_exception;
195: RETURN;
196: END IF;
197: CLOSE cur_rowid;
198:

Line 257: app_exception.raise_exception;

253: )
254: ) THEN
255: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
256: igs_ge_msg_stack.add;
257: app_exception.raise_exception;
258: END IF;
259: check_parent_existance;
260: ELSIF (p_action = 'UPDATE') THEN
261: -- Call all the procedures related to Before Update.

Line 274: app_exception.raise_exception;

270: )
271: ) THEN
272: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
273: igs_ge_msg_stack.add;
274: app_exception.raise_exception;
275: END IF;
276: ELSIF (p_action = 'VALIDATE_DELETE') THEN
277: check_child_existance;
278: END IF;

Line 331: app_exception.raise_exception;

327: END IF;
328: ELSE
329: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
330: igs_ge_msg_stack.add;
331: app_exception.raise_exception;
332: END IF;
333:
334: SELECT igf_ap_person_match_all_s.NEXTVAL
335: INTO x_apm_id

Line 444: app_exception.raise_exception;

440: IF (c1%notfound) THEN
441: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
442: igs_ge_msg_stack.add;
443: CLOSE c1;
444: app_exception.raise_exception;
445: RETURN;
446: END IF;
447: CLOSE c1;
448:

Line 462: app_exception.raise_exception;

458: NULL;
459: ELSE
460: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
461: igs_ge_msg_stack.add;
462: app_exception.raise_exception;
463: END IF;
464:
465: RETURN;
466:

Line 513: app_exception.raise_exception;

509: END IF;
510: ELSE
511: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
512: igs_ge_msg_stack.add;
513: app_exception.raise_exception;
514: END IF;
515:
516: before_dml(
517: p_action => 'UPDATE',