DBA Data[Home] [Help]

APPS.IGR_I_PKGITM_ASSIGN_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 131: igs_ge_msg_stack.add;

127: new_references.package_item_id
128: )
129: ) THEN
130: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
131: igs_ge_msg_stack.add;
132: app_exception.raise_exception;
133: END IF;
134:
135: END check_uniqueness;

Line 226: igs_ge_msg_stack.add;

222: ELSIF NOT igr_i_pkg_item_pkg.get_pk_for_validation (
223: new_references.package_item_id
224: ) THEN
225: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
226: igs_ge_msg_stack.add;
227: app_exception.raise_exception;
228: END IF;
229:
230: IF (((old_references.product_category_id = new_references.product_category_id)) OR

Line 237: igs_ge_msg_stack.add;

233: ELSIF NOT check_parent_mtl_cat (
234: new_references.product_category_id
235: ) THEN
236: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
237: igs_ge_msg_stack.add;
238: app_exception.raise_exception;
239: END IF;
240:
241:

Line 249: igs_ge_msg_stack.add;

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

Line 317: igs_ge_msg_stack.add;

313: FETCH cur_rowid INTO lv_rowid;
314: IF (cur_rowid%FOUND) THEN
315: CLOSE cur_rowid;
316: fnd_message.set_name ('IGS', ' IGR_PITM_PASITM_FK');
317: igs_ge_msg_stack.add;
318: app_exception.raise_exception;
319: RETURN;
320: END IF;
321: CLOSE cur_rowid;

Line 374: igs_ge_msg_stack.add;

370: new_references.pkg_item_assign_id
371: )
372: ) THEN
373: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
374: igs_ge_msg_stack.add;
375: app_exception.raise_exception;
376: END IF;
377: check_parent_existance;
378: check_uniqueness;

Line 390: igs_ge_msg_stack.add;

386: new_references.pkg_item_assign_id
387: )
388: ) THEN
389: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
390: igs_ge_msg_stack.add;
391: app_exception.raise_exception;
392: END IF;
393: check_uniqueness;
394: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 443: igs_ge_msg_stack.add;

439: END IF;
440: ELSE
441: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
442: fnd_message.set_token ('ROUTINE', 'IGR_I_PKGITM_ASSIGN_PKG.INSERT_ROW');
443: igs_ge_msg_stack.add;
444: app_exception.raise_exception;
445: END IF;
446:
447: x_pkg_item_assign_id := NULL;

Line 526: igs_ge_msg_stack.add;

522: OPEN c1;
523: FETCH c1 INTO tlinfo;
524: IF (c1%notfound) THEN
525: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
526: igs_ge_msg_stack.add;
527: CLOSE c1;
528: app_exception.raise_exception;
529: RETURN;
530: END IF;

Line 542: igs_ge_msg_stack.add;

538: ) THEN
539: NULL;
540: ELSE
541: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
542: igs_ge_msg_stack.add;
543: app_exception.raise_exception;
544: END IF;
545:
546: RETURN;

Line 591: igs_ge_msg_stack.add;

587: END IF;
588: ELSE
589: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
590: fnd_message.set_token ('ROUTINE', 'IGR_I_PKGITM_ASSIGN_PKG.UPDATE_ROW');
591: igs_ge_msg_stack.add;
592: app_exception.raise_exception;
593: END IF;
594:
595: before_dml(