DBA Data[Home] [Help]

APPS.IGF_AW_DP_TERMS_PKG dependencies on IGS_GE_MSG_STACK

Line 48: igs_ge_msg_stack.add;

44: FETCH cur_old_ref_values INTO old_references;
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;

Line 95: igs_ge_msg_stack.add;

91: ELSIF NOT igf_aw_awd_dist_plans_pkg.get_pk_for_validation (
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

Line 108: igs_ge_msg_stack.add;

104: new_references.ld_cal_type,
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:

Line 156: igs_ge_msg_stack.add;

152: new_references.ld_sequence_number
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:

Line 264: igs_ge_msg_stack.add;

260: FETCH cur_rowid INTO lv_rowid;
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;

Line 300: igs_ge_msg_stack.add;

296: FETCH cur_rowid INTO lv_rowid;
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;

Line 356: igs_ge_msg_stack.add;

352: new_references.adterms_id
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;

Line 375: igs_ge_msg_stack.add;

371: new_references.adterms_id
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

Line 427: igs_ge_msg_stack.add;

423: END IF;
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;

Line 510: igs_ge_msg_stack.add;

506: OPEN c1;
507: FETCH c1 INTO tlinfo;
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;

Line 526: igs_ge_msg_stack.add;

522: ) THEN
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;

Line 575: igs_ge_msg_stack.add;

571: END IF;
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(