DBA Data[Home] [Help]

APPS.IGF_AW_DP_TERMS_PKG dependencies on APP_EXCEPTION

Line 49: app_exception.raise_exception;

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

Line 96: app_exception.raise_exception;

92: new_references.adplans_id
93: ) THEN
94: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
95: igs_ge_msg_stack.add;
96: app_exception.raise_exception;
97: END IF;
98: IF (((old_references.ld_cal_type = new_references.ld_cal_type) AND
99: (old_references.ld_sequence_number = new_references.ld_sequence_number)) OR
100: ((new_references.ld_cal_type IS NULL) OR

Line 109: app_exception.raise_exception;

105: new_references.ld_sequence_number
106: ) THEN
107: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
108: igs_ge_msg_stack.add;
109: app_exception.raise_exception;
110:
111: END IF;
112:
113: END check_parent_existance;

Line 157: app_exception.raise_exception;

153: )
154: ) THEN
155: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
156: igs_ge_msg_stack.add;
157: app_exception.raise_exception;
158: END IF;
159: END check_uniqueness;
160:
161:

Line 265: app_exception.raise_exception;

261: IF (cur_rowid%FOUND) THEN
262: CLOSE cur_rowid;
263: fnd_message.set_name ('IGF', 'IGF_AW_ADTERMS_ADPLANS_FK');
264: igs_ge_msg_stack.add;
265: app_exception.raise_exception;
266: RETURN;
267: END IF;
268: CLOSE cur_rowid;
269:

Line 301: app_exception.raise_exception;

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

Line 357: app_exception.raise_exception;

353: )
354: ) THEN
355: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
356: igs_ge_msg_stack.add;
357: app_exception.raise_exception;
358: END IF;
359: check_parent_existance;
360: check_uniqueness;
361: ELSIF (p_action = 'UPDATE') THEN

Line 376: app_exception.raise_exception;

372: )
373: ) THEN
374: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
375: igs_ge_msg_stack.add;
376: app_exception.raise_exception;
377: END IF;
378: check_uniqueness;
379: ELSIF (p_action = 'VALIDATE_DELETE') THEN
380: check_child_existance;

Line 428: app_exception.raise_exception;

424: ELSE
425: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
426: fnd_message.set_token ('ROUTINE', 'IGF_AW_DP_TERMS_PKG.INSERT_ROW');
427: igs_ge_msg_stack.add;
428: app_exception.raise_exception;
429: END IF;
430:
431: x_adterms_id := NULL;
432:

Line 512: app_exception.raise_exception;

508: IF (c1%notfound) THEN
509: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
510: igs_ge_msg_stack.add;
511: CLOSE c1;
512: app_exception.raise_exception;
513: RETURN;
514: END IF;
515: CLOSE c1;
516:

Line 527: app_exception.raise_exception;

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

Line 576: app_exception.raise_exception;

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