DBA Data[Home] [Help]

APPS.IGS_SS_ADMAPPL_SETUP_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: -- Populate New Values.

Line 123: app_exception.raise_exception;

119: 'N'
120: ) THEN
121: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
122: igs_ge_msg_stack.add;
123: app_exception.raise_exception;
124: END IF;
125: IF (((old_references.alias_type = new_references.alias_type)) OR
126: ((new_references.alias_type IS NULL))) THEN
127: NULL;

Line 134: app_exception.raise_exception;

130: new_references.alias_type
131: ) THEN
132: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
133: igs_ge_msg_stack.add;
134: app_exception.raise_exception;
135: */
136: END IF;
137: /*
138: Removed Reference due to DLD1.7, Column Obsoleted

Line 153: app_exception.raise_exception;

149: 'N'
150: ) THEN
151: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
152: igs_ge_msg_stack.add;
153: app_exception.raise_exception;
154: END IF;
155: /*
156: Removed Reference due to DLD1.7, Column Obsoleted
157: IF (((old_references.mailing_addr_type = new_references.mailing_addr_type)) OR

Line 170: app_exception.raise_exception;

166: new_references.person_id_type
167: ) THEN
168: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
169: igs_ge_msg_stack.add;
170: app_exception.raise_exception;
171: END IF;
172: IF (((old_references.ps_note_type_id = new_references.ps_note_type_id)) OR
173: ((new_references.ps_note_type_id IS NULL))) THEN
174: NULL;

Line 181: app_exception.raise_exception;

177: 'N'
178: ) THEN
179: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
180: igs_ge_msg_stack.add;
181: app_exception.raise_exception;
182: END IF;
183: END check_parent_existance;
184:
185: FUNCTION get_pk_for_validation (

Line 239: app_exception.raise_exception;

235: IF (cur_rowid%FOUND) THEN
236: CLOSE cur_rowid;
237: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
238: igs_ge_msg_stack.add;
239: app_exception.raise_exception;
240: RETURN;
241: END IF;
242: CLOSE cur_rowid;
243: END get_fk_igs_ad_note_types_we;

Line 270: app_exception.raise_exception;

266: IF (cur_rowid%FOUND) THEN
267: CLOSE cur_rowid;
268: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
269: igs_ge_msg_stack.add;
270: app_exception.raise_exception;
271: RETURN;
272: END IF;
273: CLOSE cur_rowid;
274: END get_fk_igs_pe_alias_types;

Line 302: app_exception.raise_exception;

298: IF (cur_rowid%FOUND) THEN
299: CLOSE cur_rowid;
300: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
301: igs_ge_msg_stack.add;
302: app_exception.raise_exception;
303: RETURN;
304: END IF;
305: CLOSE cur_rowid;
306: END get_fk_igs_co_addr_type_pat;

Line 332: app_exception.raise_exception;

328: IF (cur_rowid%FOUND) THEN
329: CLOSE cur_rowid;
330: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
331: igs_ge_msg_stack.add;
332: app_exception.raise_exception;
333: RETURN;
334: END IF;
335: CLOSE cur_rowid;
336: END get_fk_igs_ad_note_types_act;

Line 363: app_exception.raise_exception;

359: IF (cur_rowid%FOUND) THEN
360: CLOSE cur_rowid;
361: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
362: igs_ge_msg_stack.add;
363: app_exception.raise_exception;
364: RETURN;
365: END IF;
366: CLOSE cur_rowid;
367: END get_fk_igs_co_addr_type_mat;

Line 393: app_exception.raise_exception;

389: IF (cur_rowid%FOUND) THEN
390: CLOSE cur_rowid;
391: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
392: igs_ge_msg_stack.add;
393: app_exception.raise_exception;
394: RETURN;
395: END IF;
396: CLOSE cur_rowid;
397: END get_fk_igs_pe_person_id_typ;

Line 422: app_exception.raise_exception;

418: IF (cur_rowid%FOUND) THEN
419: CLOSE cur_rowid;
420: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
421: igs_ge_msg_stack.add;
422: app_exception.raise_exception;
423: RETURN;
424: END IF;
425: CLOSE cur_rowid;
426: END get_fk_igs_ad_note_types_psnt;

Line 483: app_exception.raise_exception;

479: IF (get_pk_for_validation(
480: new_references.admappl_setup_id)) THEN
481: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
482: igs_ge_msg_stack.add;
483: app_exception.raise_exception;
484: END IF;
485: check_constraints;
486: check_parent_existance;
487: ELSIF (p_action = 'UPDATE') THEN

Line 501: app_exception.raise_exception;

497: IF (get_pk_for_validation (
498: new_references.admappl_setup_id)) THEN
499: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
500: igs_ge_msg_stack.add;
501: app_exception.raise_exception;
502: END IF;
503: check_constraints;
504: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
505: check_constraints;

Line 580: app_exception.raise_exception;

576: IF (c1%notfound) THEN
577: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
578: igs_ge_msg_stack.add;
579: CLOSE c1;
580: app_exception.raise_exception;
581: RETURN;
582: END IF;
583: CLOSE c1;
584: IF (( (tlinfo.ALIAS_TYPE = x_ALIAS_TYPE)

Line 619: app_exception.raise_exception;

615: NULL;
616: ELSE
617: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
618: igs_ge_msg_stack.add;
619: app_exception.raise_exception;
620: END IF;
621: RETURN;
622: END lock_row;
623:

Line 667: app_exception.raise_exception;

663: END IF;
664: ELSE
665: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
666: igs_ge_msg_stack.add;
667: app_exception.raise_exception;
668: END IF;
669: before_dml(
670: p_action=>'UPDATE',
671: x_rowid=>X_ROWID,