APPS.IGS_PS_NSUS_RTN_DTL_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 109: IGS_GE_MSG_STACK.ADD;

105:
106: IF l_c_column_value ='OFFSET_VALUE' OR Column_Name IS NULL THEN
107: IF New_References.offset_value < 0 OR New_References.offset_value > 999 THEN
108: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
109: IGS_GE_MSG_STACK.ADD;
110: App_Exception.Raise_Exception;
111: END IF;
112: END IF;
113:

Line 117: IGS_GE_MSG_STACK.ADD;

113:
114: IF l_c_column_value ='RETENTION_PERCENT' OR Column_Name IS NULL THEN
115: IF New_References.retention_percent < 0 OR New_References.retention_percent > 100 THEN
116: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
117: IGS_GE_MSG_STACK.ADD;
118: App_Exception.Raise_Exception;
119: END IF;
120: END IF;
121:

Line 125: IGS_GE_MSG_STACK.ADD;

121:
122: IF l_c_column_value ='RETENTION_AMOUNT' OR Column_Name IS NULL THEN
123: IF New_References.retention_amount < 0 OR New_References.retention_amount > 999999.99 THEN
124: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
125: IGS_GE_MSG_STACK.ADD;
126: App_Exception.Raise_Exception;
127: END IF;
128: END IF;
129:

Line 150: igs_ge_msg_stack.add;

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

Line 175: igs_ge_msg_stack.add;

171: ELSIF NOT igs_ps_nsus_rtn_pkg.get_pk_for_validation (
172: new_references.non_std_usec_rtn_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: END check_parent_existance;

Line 278: igs_ge_msg_stack.add;

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

Line 339: igs_ge_msg_stack.add;

335: new_references.non_std_usec_rtn_dtl_id
336: )
337: ) THEN
338: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
339: igs_ge_msg_stack.add;
340: app_exception.raise_exception;
341: END IF;
342: check_uniqueness;
343: check_constraints;

Line 357: igs_ge_msg_stack.add;

353: new_references.non_std_usec_rtn_dtl_id
354: )
355: ) THEN
356: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
357: igs_ge_msg_stack.add;
358: app_exception.raise_exception;
359: END IF;
360: check_uniqueness;
361: check_constraints;

Line 414: igs_ge_msg_stack.add;

410: END IF;
411: ELSE
412: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
413: fnd_message.set_token ('ROUTINE', 'IGS_PS_NSUS_RTN_DTL_PKG.INSERT_ROW');
414: igs_ge_msg_stack.add;
415: app_exception.raise_exception;
416: END IF;
417:
418: x_non_std_usec_rtn_dtl_id := NULL;

Line 507: igs_ge_msg_stack.add;

503: OPEN c1;
504: FETCH c1 INTO tlinfo;
505: IF (c1%notfound) THEN
506: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
507: igs_ge_msg_stack.add;
508: CLOSE c1;
509: app_exception.raise_exception;
510: RETURN;
511: END IF;

Line 525: igs_ge_msg_stack.add;

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

Line 576: igs_ge_msg_stack.add;

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