APPS.IGS_PS_NSUS_RTN_DTL_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 110: App_Exception.Raise_Exception;

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

Line 118: App_Exception.Raise_Exception;

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

Line 126: App_Exception.Raise_Exception;

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

Line 151: app_exception.raise_exception;

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

Line 176: app_exception.raise_exception;

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

Line 279: app_exception.raise_exception;

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

Line 340: app_exception.raise_exception;

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

Line 358: app_exception.raise_exception;

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

Line 415: app_exception.raise_exception;

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

Line 509: app_exception.raise_exception;

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;
512: CLOSE c1;
513:

Line 526: app_exception.raise_exception;

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

Line 577: app_exception.raise_exception;

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