DBA Data[Home] [Help]

APPS.IGS_PS_USEC_RU_PKG dependencies on IGS_GE_MSG_STACK

Line 47: igs_ge_msg_stack.add;

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

Line 90: igs_ge_msg_stack.add;

86: new_references.uoo_id,
87: new_references.s_rule_call_cd)
88: ) THEN
89: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
90: igs_ge_msg_stack.add;
91: app_exception.raise_exception;
92: END IF;
93:
94: END check_uniqueness;

Line 116: igs_ge_msg_stack.add;

112: ELSIF NOT igs_ps_unit_ofr_opt_pkg.get_uk_For_validation (
113: new_references.uoo_id
114: ) THEN
115: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
116: igs_ge_msg_stack.add;
117: app_exception.raise_exception;
118: END IF;
119:
120: IF (((old_references.s_rule_call_cd = new_references.s_rule_call_cd)) OR

Line 127: igs_ge_msg_stack.add;

123: ELSIF NOT igs_ru_call_pkg.get_pk_for_validation (
124: new_references.s_rule_call_cd
125: ) THEN
126: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
127: igs_ge_msg_stack.add;
128: app_exception.raise_exception;
129: END IF;
130:
131: IF (((old_references.rul_sequence_number = new_references.rul_sequence_number)) OR

Line 138: igs_ge_msg_stack.add;

134: ELSIF NOT igs_ru_rule_pkg.get_pk_for_validation (
135: new_references.rul_sequence_number
136: ) THEN
137: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
138: igs_ge_msg_stack.add;
139: app_exception.raise_exception;
140: END IF;
141:
142: END check_parent_existance;

Line 242: igs_ge_msg_stack.add;

238: FETCH cur_rowid INTO lv_rowid;
239: IF (cur_rowid%FOUND) THEN
240: CLOSE cur_rowid;
241: fnd_message.set_name ('IGS', 'IGS_PS_PURU_UOO_FK');
242: igs_ge_msg_stack.add;
243: app_exception.raise_exception;
244: RETURN;
245: END IF;
246: CLOSE cur_rowid;

Line 277: igs_ge_msg_stack.add;

273: FETCH cur_rowid INTO lv_rowid;
274: IF (cur_rowid%FOUND) THEN
275: CLOSE cur_rowid;
276: fnd_message.set_name ('IGS', 'IGS_PS_PURU_SRC_FK');
277: igs_ge_msg_stack.add;
278: app_exception.raise_exception;
279: RETURN;
280: END IF;
281: CLOSE cur_rowid;

Line 312: igs_ge_msg_stack.add;

308: FETCH cur_rowid INTO lv_rowid;
309: IF (cur_rowid%FOUND) THEN
310: CLOSE cur_rowid;
311: fnd_message.set_name ('IGS', 'IGS_PS_PURU_RUL_FK');
312: igs_ge_msg_stack.add;
313: app_exception.raise_exception;
314: RETURN;
315: END IF;
316: CLOSE cur_rowid;

Line 367: igs_ge_msg_stack.add;

363: new_references.usecru_id
364: )
365: ) THEN
366: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
367: igs_ge_msg_stack.add;
368: app_exception.raise_exception;
369: END IF;
370: check_uniqueness;
371: check_parent_existance;

Line 383: igs_ge_msg_stack.add;

379: new_references.usecru_id
380: )
381: ) THEN
382: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
383: igs_ge_msg_stack.add;
384: app_exception.raise_exception;
385: END IF;
386: check_uniqueness;
387: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 437: igs_ge_msg_stack.add;

433: x_last_update_login := -1;
434: END IF;
435: ELSE
436: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
437: igs_ge_msg_stack.add;
438: app_exception.raise_exception;
439: END IF;
440:
441: SELECT igs_ps_usec_ru_s.NEXTVAL

Line 525: igs_ge_msg_stack.add;

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

Line 540: igs_ge_msg_stack.add;

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

Line 587: igs_ge_msg_stack.add;

583: x_last_update_login := -1;
584: END IF;
585: ELSE
586: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
587: igs_ge_msg_stack.add;
588: app_exception.raise_exception;
589: END IF;
590:
591: before_dml(