APPS.IGS_PS_USEC_SP_FEES_PKG dependencies on APP_EXCEPTION

Line 49: app_exception.raise_exception;

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

Line 103: app_exception.raise_exception;

99: IF l_c_column_name='CLOSED_FLAG' OR column_name IS NULL THEN
100: IF new_references.closed_flag NOT IN ( 'Y' , 'N' ) Then
101: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
102: igs_ge_msg_stack.ADD;
103: app_exception.raise_exception;
104: END IF;
105: END IF;
106:
107: IF l_c_column_name ='SP_FEE_AMT' OR column_name IS NULL Then

Line 111: app_exception.raise_exception;

107: IF l_c_column_name ='SP_FEE_AMT' OR column_name IS NULL Then
108: IF new_references.sp_fee_amt <= 0 Then
109: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
110: igs_ge_msg_stack.ADD;
111: app_exception.raise_exception;
112: END IF;
113: END IF;
114:
115: END check_constraints;

Line 137: app_exception.raise_exception;

133: )
134: ) THEN
135: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
136: igs_ge_msg_stack.add;
137: app_exception.raise_exception;
138: END IF;
139:
140: END check_uniqueness;
141:

Line 163: app_exception.raise_exception;

159: new_references.uoo_id
160: ) THEN
161: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
162: igs_ge_msg_stack.add;
163: app_exception.raise_exception;
164: END IF;
165:
166: IF (((old_references.fee_type = new_references.fee_type)) OR
167: ((new_references.fee_type IS NULL))) THEN

Line 174: app_exception.raise_exception;

170: new_references.fee_type
171: ) THEN
172: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
173: igs_ge_msg_stack.add;
174: app_exception.raise_exception;
175: END IF;
176:
177: END check_parent_existance;
178:

Line 279: app_exception.raise_exception;

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

Line 315: app_exception.raise_exception;

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

Line 390: app_exception.raise_exception;

386: )
387: ) THEN
388: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
389: igs_ge_msg_stack.add;
390: app_exception.raise_exception;
391: END IF;
392: check_uniqueness;
393: check_constraints;
394: check_parent_existance;

Line 410: app_exception.raise_exception;

406: )
407: ) THEN
408: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
409: igs_ge_msg_stack.add;
410: app_exception.raise_exception;
411: END IF;
412: check_constraints;
413: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
414: check_constraints;

Line 467: app_exception.raise_exception;

463: ELSE
464: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
465: fnd_message.set_token ('ROUTINE', 'IGS_PS_USEC_SP_FEES_PKG.INSERT_ROW');
466: igs_ge_msg_stack.add;
467: app_exception.raise_exception;
468: END IF;
469:
470: x_usec_sp_fees_id := NULL;
471:

Line 551: app_exception.raise_exception;

547: IF (c1%notfound) THEN
548: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
549: igs_ge_msg_stack.add;
550: CLOSE c1;
551: app_exception.raise_exception;
552: RETURN;
553: END IF;
554: CLOSE c1;
555:

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 615: app_exception.raise_exception;

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