APPS.IGS_PS_USEC_SP_FEES_PKG dependencies on IGS_GE_MSG_STACK

Line 48: igs_ge_msg_stack.add;

44: FETCH cur_old_ref_values INTO old_references;
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;

Line 102: igs_ge_msg_stack.ADD;

98:
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:

Line 110: igs_ge_msg_stack.ADD;

106:
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:

Line 136: igs_ge_msg_stack.add;

132: new_references.fee_type
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;

Line 162: igs_ge_msg_stack.add;

158: ELSIF NOT igs_ps_unit_ofr_opt_pkg.get_uk_for_validation (
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

Line 173: igs_ge_msg_stack.add;

169: ELSIF NOT igs_fi_fee_type_pkg.get_pk_for_validation (
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;

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_USSF_UOO_FK');
278: igs_ge_msg_stack.add;
279: app_exception.raise_exception;
280: RETURN;
281: END IF;
282: CLOSE cur_rowid;

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_USSF_FT_FK');
314: igs_ge_msg_stack.add;
315: app_exception.raise_exception;
316: RETURN;
317: END IF;
318: CLOSE cur_rowid;

Line 389: igs_ge_msg_stack.add;

385: new_references.usec_sp_fees_id
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;

Line 409: igs_ge_msg_stack.add;

405: new_references.usec_sp_fees_id
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

Line 466: igs_ge_msg_stack.add;

462: END IF;
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;

Line 549: igs_ge_msg_stack.add;

545: OPEN c1;
546: FETCH c1 INTO tlinfo;
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;

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 614: igs_ge_msg_stack.add;

610: END IF;
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(