DBA Data[Home] [Help]

APPS.IGS_FI_FTCI_ACCTS_PKG dependencies on IGS_GE_MSG_STACK

Line 65: igs_ge_msg_stack.add;

61: FETCH cur_old_ref_values INTO old_references;
62: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
63: CLOSE cur_old_ref_values;
64: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
65: igs_ge_msg_stack.add;
66: app_exception.raise_exception;
67: RETURN;
68: END IF;
69: CLOSE cur_old_ref_values;

Line 130: igs_ge_msg_stack.add;

126: new_references.order_sequence
127: )
128: ) THEN
129: fnd_message.set_name ('IGS','IGS_FI_ACCT_DUP_SEQ');
130: igs_ge_msg_stack.add;
131: app_exception.raise_exception;
132: END IF;
133:
134: IF ( get_uk2_for_validation (

Line 155: igs_ge_msg_stack.add;

151: new_references.unit_class
152: )
153: ) THEN
154: fnd_message.set_name ('IGS', 'IGS_FI_ACCT_ATTR_COMB_EXISTS');
155: igs_ge_msg_stack.add;
156: app_exception.raise_exception;
157: END IF;
158:
159:

Line 190: igs_ge_msg_stack.add;

186: new_references.fee_cal_type,
187: new_references.fee_ci_sequence_number
188: ) THEN
189: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
190: igs_ge_msg_stack.add;
191: app_exception.raise_exception;
192: END IF;
193:
194: IF (((old_references.rev_account_cd = new_references.rev_account_cd)) OR

Line 201: igs_ge_msg_stack.add;

197: ELSIF NOT igs_fi_acc_pkg.get_pk_for_validation (
198: new_references.rev_account_cd
199: ) THEN
200: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
201: igs_ge_msg_stack.add;
202: app_exception.raise_exception;
203: END IF;
204:
205: IF (((old_references.location_cd = new_references.location_cd)) OR

Line 213: igs_ge_msg_stack.add;

209: new_references.location_cd,
210: 'N'
211: ) THEN
212: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
213: igs_ge_msg_stack.add;
214: app_exception.raise_exception;
215: END IF;
216:
217: IF (((old_references.attendance_type = new_references.attendance_type)) OR

Line 224: igs_ge_msg_stack.add;

220: ELSIF NOT igs_en_atd_type_pkg.get_pk_for_validation (
221: new_references.attendance_type
222: ) THEN
223: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
224: igs_ge_msg_stack.add;
225: app_exception.raise_exception;
226: END IF;
227:
228: IF (((old_references.attendance_mode = new_references.attendance_mode)) OR

Line 235: igs_ge_msg_stack.add;

231: ELSIF NOT igs_en_atd_mode_pkg.get_pk_for_validation (
232: new_references.attendance_mode
233: ) THEN
234: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
235: igs_ge_msg_stack.add;
236: app_exception.raise_exception;
237: END IF;
238:
239: IF (((old_references.course_cd = new_references.course_cd) AND

Line 249: igs_ge_msg_stack.add;

245: new_references.course_cd,
246: new_references.crs_version_number
247: ) THEN
248: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
249: igs_ge_msg_stack.add;
250: app_exception.raise_exception;
251: END IF;
252:
253: IF (((old_references.unit_cd = new_references.unit_cd) AND

Line 263: igs_ge_msg_stack.add;

259: new_references.unit_cd,
260: new_references.unit_version_number
261: ) THEN
262: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
263: igs_ge_msg_stack.add;
264: app_exception.raise_exception;
265: END IF;
266:
267: IF (((old_references.uoo_id = new_references.uoo_id)) OR

Line 274: igs_ge_msg_stack.add;

270: ELSIF NOT igs_ps_unit_ofr_opt_pkg.get_uk_for_validation (
271: new_references.uoo_id
272: ) THEN
273: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
274: igs_ge_msg_stack.add;
275: app_exception.raise_exception;
276: END IF;
277:
278: IF (((old_references.unit_level = new_references.unit_level)) OR

Line 285: igs_ge_msg_stack.add;

281: ELSIF NOT igs_ps_unit_level_pkg.get_pk_for_validation (
282: new_references.unit_level
283: ) THEN
284: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
285: igs_ge_msg_stack.add;
286: app_exception.raise_exception;
287: END IF;
288:
289: IF (((old_references.unit_type_id = new_references.unit_type_id)) OR

Line 296: igs_ge_msg_stack.add;

292: ELSIF NOT igs_ps_unit_type_lvl_pkg.get_pk_for_validation (
293: new_references.unit_type_id
294: ) THEN
295: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
296: igs_ge_msg_stack.add;
297: app_exception.raise_exception;
298: END IF;
299:
300: IF (((old_references.unit_mode = new_references.unit_mode)) OR

Line 307: igs_ge_msg_stack.add;

303: ELSIF NOT igs_as_unit_mode_pkg.get_pk_for_validation (
304: new_references.unit_mode
305: ) THEN
306: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
307: igs_ge_msg_stack.add;
308: app_exception.raise_exception;
309: END IF;
310:
311: IF (((old_references.unit_class = new_references.unit_class)) OR

Line 318: igs_ge_msg_stack.add;

314: ELSIF NOT igs_as_unit_class_pkg.get_pk_for_validation (
315: new_references.unit_class
316: ) THEN
317: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
318: igs_ge_msg_stack.add;
319: app_exception.raise_exception;
320: END IF;
321:
322: END check_parent_existance;

Line 496: igs_ge_msg_stack.add;

492: FETCH cur_rowid INTO lv_rowid;
493: IF (cur_rowid%FOUND) THEN
494: CLOSE cur_rowid;
495: fnd_message.set_name ('IGS', 'IGS_FI_FICA_FTCI_FK');
496: igs_ge_msg_stack.add;
497: app_exception.raise_exception;
498: RETURN;
499: END IF;
500: CLOSE cur_rowid;

Line 531: igs_ge_msg_stack.add;

527: FETCH cur_rowid INTO lv_rowid;
528: IF (cur_rowid%FOUND) THEN
529: CLOSE cur_rowid;
530: fnd_message.set_name ('IGS', 'IGS_FI_FICA_ACC_FK');
531: igs_ge_msg_stack.add;
532: app_exception.raise_exception;
533: RETURN;
534: END IF;
535: CLOSE cur_rowid;

Line 566: igs_ge_msg_stack.add;

562: FETCH cur_rowid INTO lv_rowid;
563: IF (cur_rowid%FOUND) THEN
564: CLOSE cur_rowid;
565: fnd_message.set_name ('IGS', 'IGS_FI_FICA_LOC_FK');
566: igs_ge_msg_stack.add;
567: app_exception.raise_exception;
568: RETURN;
569: END IF;
570: CLOSE cur_rowid;

Line 601: igs_ge_msg_stack.add;

597: FETCH cur_rowid INTO lv_rowid;
598: IF (cur_rowid%FOUND) THEN
599: CLOSE cur_rowid;
600: fnd_message.set_name ('IGS', 'IGS_FI_FICA_ATT_FK');
601: igs_ge_msg_stack.add;
602: app_exception.raise_exception;
603: RETURN;
604: END IF;
605: CLOSE cur_rowid;

Line 636: igs_ge_msg_stack.add;

632: FETCH cur_rowid INTO lv_rowid;
633: IF (cur_rowid%FOUND) THEN
634: CLOSE cur_rowid;
635: fnd_message.set_name ('IGS', 'IGS_FI_FICA_AM_FK');
636: igs_ge_msg_stack.add;
637: app_exception.raise_exception;
638: RETURN;
639: END IF;
640: CLOSE cur_rowid;

Line 673: igs_ge_msg_stack.add;

669: FETCH cur_rowid INTO lv_rowid;
670: IF (cur_rowid%FOUND) THEN
671: CLOSE cur_rowid;
672: fnd_message.set_name ('IGS', 'IGS_FI_FICA_SCA_FK');
673: igs_ge_msg_stack.add;
674: app_exception.raise_exception;
675: RETURN;
676: END IF;
677: CLOSE cur_rowid;

Line 709: igs_ge_msg_stack.add;

705: FETCH cur_rowid INTO lv_rowid;
706: IF (cur_rowid%FOUND) THEN
707: CLOSE cur_rowid;
708: fnd_message.set_name ('IGS', 'IGS_FI_FICA_UN_FK');
709: igs_ge_msg_stack.add;
710: app_exception.raise_exception;
711: RETURN;
712: END IF;
713: CLOSE cur_rowid;

Line 746: igs_ge_msg_stack.add;

742: FETCH cur_rowid INTO lv_rowid;
743: IF (cur_rowid%FOUND) THEN
744: CLOSE cur_rowid;
745: fnd_message.set_name ('IGS', 'IGS_FI_FICA_UOO_FK');
746: igs_ge_msg_stack.add;
747: app_exception.raise_exception;
748: RETURN;
749: END IF;
750: CLOSE cur_rowid;

Line 780: igs_ge_msg_stack.add;

776: FETCH cur_rowid INTO lv_rowid;
777: IF (cur_rowid%FOUND) THEN
778: CLOSE cur_rowid;
779: fnd_message.set_name ('IGS', 'IGS_FI_ACCTS_UM_FK');
780: igs_ge_msg_stack.add;
781: app_exception.raise_exception;
782: RETURN;
783: END IF;
784: CLOSE cur_rowid;

Line 871: igs_ge_msg_stack.add;

867: new_references.acct_id
868: )
869: ) THEN
870: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
871: igs_ge_msg_stack.add;
872: app_exception.raise_exception;
873: END IF;
874: check_uniqueness;
875: check_parent_existance;

Line 887: igs_ge_msg_stack.add;

883: new_references.acct_id
884: )
885: ) THEN
886: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
887: igs_ge_msg_stack.add;
888: app_exception.raise_exception;
889: END IF;
890: check_uniqueness;
891: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 974: igs_ge_msg_stack.add;

970: END IF;
971: ELSE
972: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
973: fnd_message.set_token ('ROUTINE', 'IGS_FI_FTCI_ACCTS_PKG.INSERT_ROW');
974: igs_ge_msg_stack.add;
975: app_exception.raise_exception;
976: END IF;
977:
978: SELECT igs_fi_ftci_accts_s.NEXTVAL INTO x_acct_id FROM dual;

Line 1146: igs_ge_msg_stack.add;

1142: OPEN c1;
1143: FETCH c1 INTO tlinfo;
1144: IF (c1%notfound) THEN
1145: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1146: igs_ge_msg_stack.add;
1147: CLOSE c1;
1148: app_exception.raise_exception;
1149: RETURN;
1150: END IF;

Line 1178: igs_ge_msg_stack.add;

1174: ) THEN
1175: NULL;
1176: ELSE
1177: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1178: igs_ge_msg_stack.add;
1179: app_exception.raise_exception;
1180: END IF;
1181:
1182: RETURN;

Line 1248: igs_ge_msg_stack.add;

1244: END IF;
1245: ELSE
1246: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1247: fnd_message.set_token ('ROUTINE', 'IGS_FI_FTCI_ACCTS_PKG.UPDATE_ROW');
1248: igs_ge_msg_stack.add;
1249: app_exception.raise_exception;
1250: END IF;
1251:
1252: before_dml(