APPS.IGS_PS_NSUS_RTN_PKG dependencies on APP_EXCEPTION

Line 51: app_exception.raise_exception;

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;
55:

Line 109: App_Exception.Raise_Exception;

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:
113: IF l_c_column_value ='FORMULA_METHOD' OR Column_Name IS NULL THEN

Line 117: App_Exception.Raise_Exception;

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:
121: IF l_c_column_value ='ROUND_METHOD' OR Column_Name IS NULL THEN

Line 125: App_Exception.Raise_Exception;

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:
129: END check_constraints ;

Line 150: app_exception.raise_exception;

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;
154:

Line 176: app_exception.raise_exception;

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
180: ((new_references.fee_type IS NULL))) THEN

Line 187: app_exception.raise_exception;

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;
191:

Line 315: app_exception.raise_exception;

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;
319:

Line 376: app_exception.raise_exception;

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;
380: check_parent_existance;

Line 397: app_exception.raise_exception;

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;
401: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 455: app_exception.raise_exception;

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;
459:

Line 549: app_exception.raise_exception;

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;
552: CLOSE c1;
553:

Line 566: app_exception.raise_exception;

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;
570:

Line 617: app_exception.raise_exception;

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(
621: p_action => 'UPDATE',