DBA Data[Home] [Help]

APPS.IGS_FI_CONTROL_PKG dependencies on APP_EXCEPTION

Line 90: app_exception.raise_exception;

86: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
87: CLOSE cur_old_ref_values;
88: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
89: igs_ge_msg_stack.add;
90: app_exception.raise_exception;
91: RETURN;
92: END IF;
93: Close cur_old_ref_values;
94: -- Populate New Values.

Line 173: app_exception.raise_exception;

169: new_references.accounting_method <> 'N' THEN
170: fnd_message.set_name('IGS',
171: 'IGS_FI_ACCNT_MTHD_NULL_NA');
172: igs_ge_msg_stack.add;
173: app_exception.raise_exception;
174: END IF;
175: END IF;
176:
177: -- Added the check for refund_dt_alias as a one time initialisation field as Per Enh Bug # 2144600

Line 182: app_exception.raise_exception;

178: IF ((NOT old_references.refund_dt_alias IS NULL) AND
179: (old_references.refund_dt_alias <> new_references.refund_dt_alias )) THEN
180: fnd_message.set_name('IGS','IGS_FI_REFUND_DT_ONE_TIME_SET');
181: igs_ge_msg_stack.add;
182: app_exception.raise_exception;
183: END IF;
184:
185: -- Added the check for planned_credits_ind not null
186: IF (( new_references.planned_credits_ind IS NOT NULL) AND ( new_references.planned_credits_ind NOT IN ('Y','N'))) THEN

Line 189: app_exception.raise_exception;

185: -- Added the check for planned_credits_ind not null
186: IF (( new_references.planned_credits_ind IS NOT NULL) AND ( new_references.planned_credits_ind NOT IN ('Y','N'))) THEN
187: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
188: igs_ge_msg_stack.add;
189: app_exception.raise_exception;
190: END IF;
191:
192:
193: IF (new_references.currency_cd IS NULL)

Line 198: app_exception.raise_exception;

194: THEN
195: fnd_message.set_name('IGS','IGS_PE_DATA_MANDATORY');
196: fnd_message.set_token('DATA_ELEMENT','CURRENCY_CD');
197: igs_ge_msg_stack.add;
198: app_exception.raise_exception;
199: END IF;
200:
201: IF ((new_references.manage_accounts IS NOT NULL) AND (new_references.manage_accounts NOT IN ('STUDENT_FINANCE','OTHER'))
202: ) THEN

Line 205: app_exception.raise_exception;

201: IF ((new_references.manage_accounts IS NOT NULL) AND (new_references.manage_accounts NOT IN ('STUDENT_FINANCE','OTHER'))
202: ) THEN
203: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
204: igs_ge_msg_stack.add;
205: app_exception.raise_exception;
206: END IF;
207:
208: END check_constraints;
209:

Line 247: app_exception.raise_exception;

243: new_references.accounting_method
244: )THEN
245: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
246: igs_ge_msg_stack.add;
247: app_exception.raise_exception;
248: END IF;
249:
250: --Added by sarakshi,bug: 2162747
251: IF (((old_references.fee_calc_mthd_code = new_references.fee_calc_mthd_code) OR

Line 260: app_exception.raise_exception;

256: new_references.fee_calc_mthd_code
257: ) THEN
258: fnd_message.set_name ('FND','FORM_RECORD_DELETED');
259: igs_ge_msg_stack.add;
260: app_exception.raise_exception;
261: END IF;
262:
263: -- Added for Refunds Build as per the Enhancement Bug # 2144600
264: IF (((old_references.refund_dr_account_cd = new_references.refund_dr_account_cd) OR

Line 271: app_exception.raise_exception;

267: ELSE
268: IF NOT(igs_fi_acc_pkg.get_pk_for_validation(new_references.refund_dr_account_cd)) THEN
269: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
270: igs_ge_msg_stack.add;
271: app_exception.raise_exception;
272: END IF;
273: END IF;
274:
275: IF (((old_references.refund_cr_account_cd= new_references.refund_cr_account_cd) OR

Line 282: app_exception.raise_exception;

278: ELSE
279: IF NOT(igs_fi_acc_pkg.get_pk_for_validation(new_references.refund_cr_account_cd)) THEN
280: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
281: igs_ge_msg_stack.add;
282: app_exception.raise_exception;
283: END IF;
284: END IF;
285:
286: IF ((old_references.refund_dt_alias = new_references.refund_dt_alias) OR

Line 294: app_exception.raise_exception;

290: IF NOT igs_ca_da_pkg.get_pk_for_validation (
291: new_references.refund_dt_alias) THEN
292: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
293: igs_ge_msg_stack.add;
294: app_exception.raise_exception;
295: END IF;
296: END IF;
297:
298: -- Added as a part of Subaccount Removal build. Enh Bug # 2564643

Line 306: app_exception.raise_exception;

302: ELSE
303: IF NOT(igs_fi_acc_pkg.get_pk_for_validation(new_references.rec_account_cd)) THEN
304: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
305: igs_ge_msg_stack.add;
306: app_exception.raise_exception;
307: END IF;
308: END IF;
309:
310: IF ((old_references.rev_account_cd = new_references.rev_account_cd) OR

Line 317: app_exception.raise_exception;

313: ELSE
314: IF NOT(igs_fi_acc_pkg.get_pk_for_validation(new_references.rev_account_cd)) THEN
315: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
316: igs_ge_msg_stack.add;
317: app_exception.raise_exception;
318: END IF;
319: END IF;
320:
321: IF ((old_references.cash_account_cd = new_references.cash_account_cd) OR

Line 328: app_exception.raise_exception;

324: ELSE
325: IF NOT(igs_fi_acc_pkg.get_pk_for_validation(new_references.cash_account_cd)) THEN
326: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
327: igs_ge_msg_stack.add;
328: app_exception.raise_exception;
329: END IF;
330: END IF;
331:
332: IF ((old_references.unapp_account_cd = new_references.unapp_account_cd) OR

Line 339: app_exception.raise_exception;

335: ELSE
336: IF NOT(igs_fi_acc_pkg.get_pk_for_validation(new_references.unapp_account_cd)) THEN
337: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
338: igs_ge_msg_stack.add;
339: app_exception.raise_exception;
340: END IF;
341: END IF;
342:
343: IF (((old_references.currency_cd = new_references.currency_cd)) OR

Line 353: app_exception.raise_exception;

349: IF (cur_rowid4%NOTFOUND) THEN
350: CLOSE cur_rowid4;
351: fnd_message.set_name ('FND','FORM_RECORD_DELETED');
352: igs_ge_msg_stack.add;
353: app_exception.raise_exception;
354: END IF;
355: CLOSE cur_rowid4;
356: END IF;
357:

Line 367: app_exception.raise_exception;

363: new_references.rfnd_destination
364: )THEN
365: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
366: igs_ge_msg_stack.add;
367: app_exception.raise_exception;
368: END IF;
369:
370: END check_parent_existance;
371:

Line 514: app_exception.raise_exception;

510: IF get_pk_for_validation(
511: new_references.rec_installed) THEN
512: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
513: igs_ge_msg_stack.add;
514: app_exception.raise_exception;
515: END IF;
516: check_constraints;
517: check_parent_existance;
518:

Line 532: app_exception.raise_exception;

528: IF get_pk_for_validation (
529: new_references.rec_installed) THEN
530: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
531: igs_ge_msg_stack.add;
532: app_exception.raise_exception;
533: END IF;
534: check_constraints;
535: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
536: check_constraints;

Line 667: app_exception.raise_exception;

663: END IF;
664: ELSE
665: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
666: igs_ge_msg_stack.add;
667: app_exception.raise_exception;
668: END IF;
669:
670: --msrinivi : since this table has now been made a multi org, the following is added
671: new_references.org_id := igs_ge_gen_003.get_org_id;

Line 895: app_exception.raise_exception;

891: IF (c1%NOTFOUND) THEN
892: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
893: igs_ge_msg_stack.add;
894: CLOSE c1;
895: app_exception.raise_exception;
896: RETURN;
897: END IF;
898: CLOSE c1;
899:

Line 955: app_exception.raise_exception;

951: NULL;
952: ELSE
953: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
954: igs_ge_msg_stack.add;
955: app_exception.raise_exception;
956: END IF;
957: RETURN;
958: END lock_row;
959:

Line 1046: app_exception.raise_exception;

1042: END IF;
1043: ELSE
1044: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1045: igs_ge_msg_stack.add;
1046: app_exception.raise_exception;
1047: END IF;
1048:
1049: before_dml(
1050: p_action =>'UPDATE',

Line 1192: app_exception.raise_exception;

1188: IF (cur_rowid%FOUND) THEN
1189: CLOSE cur_rowid;
1190: fnd_message.set_name ('IGS', 'IGS_FI_CTRL_DA_FK');
1191: igs_ge_msg_stack.add;
1192: app_exception.raise_exception;
1193: RETURN;
1194: END IF;
1195: CLOSE cur_rowid;
1196: