DBA Data[Home] [Help]

APPS.IGS_PS_NSUS_RTN_PKG dependencies on IGS_GE_MSG_STACK

Line 50: igs_ge_msg_stack.add;

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

Line 108: IGS_GE_MSG_STACK.ADD;

104:
105: IF l_c_column_value ='INCL_WKEND_DURATION_FLAG' OR Column_Name IS NULL THEN
106: IF New_References.incl_wkend_duration_flag NOT IN ( 'Y' , 'N' ) THEN
107: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
108: IGS_GE_MSG_STACK.ADD;
109: App_Exception.Raise_Exception;
110: END IF;
111: END IF;
112:

Line 116: IGS_GE_MSG_STACK.ADD;

112:
113: IF l_c_column_value ='FORMULA_METHOD' OR Column_Name IS NULL THEN
114: IF New_References.formula_method NOT IN ( 'D' , 'M' ,'P','N') THEN
115: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
116: IGS_GE_MSG_STACK.ADD;
117: App_Exception.Raise_Exception;
118: END IF;
119: END IF;
120:

Line 124: IGS_GE_MSG_STACK.ADD;

120:
121: IF l_c_column_value ='ROUND_METHOD' OR Column_Name IS NULL THEN
122: IF New_References.round_method NOT IN ( 'S' , 'A' ) THEN
123: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
124: IGS_GE_MSG_STACK.ADD;
125: App_Exception.Raise_Exception;
126: END IF;
127: END IF;
128:

Line 149: igs_ge_msg_stack.add;

145: new_references.fee_type
146: )
147: ) THEN
148: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
149: igs_ge_msg_stack.add;
150: app_exception.raise_exception;
151: END IF;
152:
153: END check_uniqueness;

Line 175: igs_ge_msg_stack.add;

171: ELSIF NOT igs_ps_unit_ofr_opt_pkg.get_uk_for_validation (
172: new_references.uoo_id
173: ) THEN
174: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
175: igs_ge_msg_stack.add;
176: app_exception.raise_exception;
177: END IF;
178:
179: IF (((old_references.fee_type = new_references.fee_type)) OR

Line 186: igs_ge_msg_stack.add;

182: ELSIF NOT igs_fi_fee_type_pkg.get_pk_for_validation (
183: new_references.fee_type
184: ) THEN
185: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
186: igs_ge_msg_stack.add;
187: app_exception.raise_exception;
188: END IF;
189:
190: END check_parent_existance;

Line 314: igs_ge_msg_stack.add;

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

Line 375: igs_ge_msg_stack.add;

371: new_references.non_std_usec_rtn_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: check_constraints;

Line 396: igs_ge_msg_stack.add;

392: new_references.non_std_usec_rtn_id
393: )
394: ) THEN
395: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
396: igs_ge_msg_stack.add;
397: app_exception.raise_exception;
398: END IF;
399: check_uniqueness;
400: check_constraints;

Line 454: igs_ge_msg_stack.add;

450: END IF;
451: ELSE
452: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
453: fnd_message.set_token ('ROUTINE', 'IGS_PS_NSUS_RTN_PKG.INSERT_ROW');
454: igs_ge_msg_stack.add;
455: app_exception.raise_exception;
456: END IF;
457:
458: x_non_std_usec_rtn_id := NULL;

Line 547: igs_ge_msg_stack.add;

543: OPEN c1;
544: FETCH c1 INTO tlinfo;
545: IF (c1%notfound) THEN
546: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
547: igs_ge_msg_stack.add;
548: CLOSE c1;
549: app_exception.raise_exception;
550: RETURN;
551: END IF;

Line 565: igs_ge_msg_stack.add;

561: ) THEN
562: NULL;
563: ELSE
564: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
565: igs_ge_msg_stack.add;
566: app_exception.raise_exception;
567: END IF;
568:
569: RETURN;

Line 616: igs_ge_msg_stack.add;

612: END IF;
613: ELSE
614: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
615: fnd_message.set_token ('ROUTINE', 'IGS_PS_NSUS_RTN_PKG.UPDATE_ROW');
616: igs_ge_msg_stack.add;
617: app_exception.raise_exception;
618: END IF;
619:
620: before_dml(