eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_FI_FEE_AS_PKG dependencies on APP_EXCEPTION

Line 60: App_Exception.Raise_Exception;

56: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
57: Close cur_old_ref_values;
58: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
59: IGS_GE_MSG_STACK.ADD;
60: App_Exception.Raise_Exception;
61: Return;
62: END IF;
63: Close cur_old_ref_values;
64: -- Populate New Values.

Line 141: App_Exception.Raise_Exception;

137: new_references.fee_cat,
138: v_message_name) = FALSE THEN
139: Fnd_Message.Set_Name('IGS',v_message_name);
140: IGS_GE_MSG_STACK.ADD;
141: App_Exception.Raise_Exception;
142: END IF;
143: END IF; */
144: -- Validate that appropriate fields are set depending on the fee type.
145: IF p_inserting OR

Line 156: App_Exception.Raise_Exception;

152: new_references.course_cd,
153: v_message_name) = FALSE THEN
154: Fnd_Message.Set_Name('IGS',v_message_name);
155: IGS_GE_MSG_STACK.ADD;
156: App_Exception.Raise_Exception;
157: END IF;
158: -- Validate that course code can be specified.
159: -- Enh # 2122257 (SFCR015 : Change In Fee Category)
160: -- Changed the call to this function.

Line 173: App_Exception.Raise_Exception;

169: new_references.fee_ci_sequence_number,
170: v_message_name) = FALSE THEN
171: Fnd_Message.Set_Name('IGS',v_message_name);
172: IGS_GE_MSG_STACK.ADD;
173: App_Exception.Raise_Exception;
174: END IF;
175: END IF;
176: -- Validate effective date.
177: -- Only for fee types other than 'EXTERNAL' SYSTEM FEE TYPE

Line 195: App_Exception.Raise_Exception;

191: new_references.s_transaction_type,
192: v_message_name) = FALSE THEN
193: Fnd_Message.Set_Name('IGS',v_message_name);
194: IGS_GE_MSG_STACK.ADD;
195: App_Exception.Raise_Exception;
196: END IF;
197: END IF;
198: END IF; -- For External System Fee Type NOT FOUND
199: IF p_inserting OR p_updating THEN

Line 207: App_Exception.Raise_Exception;

203: new_references.comments,
204: v_message_name) = FALSE THEN
205: Fnd_Message.Set_Name('IGS',v_message_name);
206: IGS_GE_MSG_STACK.ADD;
207: App_Exception.Raise_Exception;
208: END IF;
209: END IF;
210: IF p_updating THEN
211: -- Validate the columns being changed are allowed to be

Line 248: App_Exception.Raise_Exception;

244: old_references.logical_delete_dt,
245: v_message_name) = FALSE THEN
246: Fnd_Message.Set_Name('IGS',v_message_name);
247: IGS_GE_MSG_STACK.ADD;
248: App_Exception.Raise_Exception;
249: END IF;
250: END IF;
251: END BeforeRowInsertUpdateDelete1;
252:

Line 260: App_Exception.Raise_Exception;

256: new_references.transaction_id
257: ) THEN
258: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
259: IGS_GE_MSG_STACK.ADD;
260: App_Exception.Raise_Exception;
261: END IF;
262: End Check_Uniqueness;
263:
264: PROCEDURE Check_Constraints (

Line 309: App_Exception.Raise_Exception;

305: IF new_references.COURSE_CD <>
306: UPPER(new_references.COURSE_CD) Then
307: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
308: IGS_GE_MSG_STACK.ADD;
309: App_Exception.Raise_Exception;
310: END IF;
311: END IF;
312: IF upper(column_name) = 'CURRENCY_CD' OR
313: column_name is null Then

Line 318: App_Exception.Raise_Exception;

314: IF new_references.CURRENCY_CD <>
315: UPPER(new_references.CURRENCY_CD) Then
316: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
317: IGS_GE_MSG_STACK.ADD;
318: App_Exception.Raise_Exception;
319: END IF;
320: END IF;
321: IF upper(column_name) = 'FEE_CAL_TYPE' OR
322: column_name is null Then

Line 327: App_Exception.Raise_Exception;

323: IF new_references.FEE_CAL_TYPE <>
324: UPPER(new_references.FEE_CAL_TYPE) Then
325: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
326: IGS_GE_MSG_STACK.ADD;
327: App_Exception.Raise_Exception;
328: END IF;
329: END IF;
330: IF upper(column_name) = 'S_TRANSACTION_TYPE' OR
331: column_name is null Then

Line 336: App_Exception.Raise_Exception;

332: IF new_references.S_TRANSACTION_TYPE <>
333: UPPER(new_references.S_TRANSACTION_TYPE) Then
334: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
335: IGS_GE_MSG_STACK.ADD;
336: App_Exception.Raise_Exception;
337: END IF;
338: END IF;
339:
340: IF upper(column_name) = 'TRANSACTION_ID' OR

Line 346: App_Exception.Raise_Exception;

342: IF new_references.transaction_id < 1 OR
343: new_references.transaction_id > 999999 Then
344: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
345: IGS_GE_MSG_STACK.ADD;
346: App_Exception.Raise_Exception;
347: END IF;
348: END IF;
349: IF upper(column_name) = 'CHG_ELEMENTS' OR
350: column_name is null Then

Line 355: App_Exception.Raise_Exception;

351: IF new_references.chg_elements < 0 OR
352: new_references.chg_elements > 9999.999 Then
353: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
354: IGS_GE_MSG_STACK.ADD;
355: App_Exception.Raise_Exception;
356: END IF;
357: END IF;
358: IF upper(column_name) = 'EXCHANGE_RATE' OR
359: column_name is null Then

Line 364: App_Exception.Raise_Exception;

360: IF new_references.exchange_rate < 0.0001 OR
361: new_references.exchange_rate > 9999.9999 Then
362: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
363: IGS_GE_MSG_STACK.ADD;
364: App_Exception.Raise_Exception;
365: END IF;
366: END IF;
367: IF upper(column_name) = 'TRANSACTION_AMOUNT' OR
368: column_name is null Then

Line 373: App_Exception.Raise_Exception;

369: IF new_references.transaction_amount < -999990.00 OR
370: new_references.transaction_amount > 999990.00 Then
371: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
372: IGS_GE_MSG_STACK.ADD;
373: App_Exception.Raise_Exception;
374: END IF;
375: END IF;
376: IF upper(column_name) = 'FEE_CI_SEQUENCE_NUMBER' OR
377: column_name is null Then

Line 382: App_Exception.Raise_Exception;

378: IF new_references.fee_ci_sequence_number < 1 OR
379: new_references.fee_ci_sequence_number > 999999 Then
380: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
381: IGS_GE_MSG_STACK.ADD;
382: App_Exception.Raise_Exception;
383: END IF;
384: END IF;
385: END Check_CONSTRAINTS;
386:

Line 414: App_Exception.Raise_Exception;

410: new_references.course_cd
411: ) THEN
412: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
413: IGS_GE_MSG_STACK.ADD;
414: App_Exception.Raise_Exception;
415: END IF;
416: END IF;
417:
418: IF (((old_references.fee_cat = new_references.fee_cat) AND

Line 436: App_Exception.Raise_Exception;

432: new_references.fee_type
433: ) THEN
434: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
435: IGS_GE_MSG_STACK.ADD;
436: App_Exception.Raise_Exception;
437: END IF;
438: END IF;
439: IF (((old_references.fee_type = new_references.fee_type) AND
440: (old_references.fee_cal_type = new_references.fee_cal_type) AND

Line 454: App_Exception.Raise_Exception;

450: new_references.fee_ci_sequence_number
451: ) THEN
452: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
453: IGS_GE_MSG_STACK.ADD;
454: App_Exception.Raise_Exception;
455: END IF;
456: END IF;
457: IF (((old_references.person_id = new_references.person_id)) OR
458: ((new_references.person_id IS NULL))) THEN

Line 466: App_Exception.Raise_Exception;

462: new_references.person_id
463: ) THEN
464: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
465: IGS_GE_MSG_STACK.ADD;
466: App_Exception.Raise_Exception;
467: END IF;
468: END IF;
469: IF (((old_references.s_transaction_type = new_references.s_transaction_type)) OR
470: ((new_references.s_transaction_type IS NULL))) THEN

Line 479: App_Exception.Raise_Exception;

475: new_references.s_transaction_type
476: ) THEN
477: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
478: IGS_GE_MSG_STACK.ADD;
479: App_Exception.Raise_Exception;
480: END IF;
481: END IF;
482: END check_parent_existance;
483:

Line 547: App_Exception.Raise_Exception;

543: IF (cur_rowid%FOUND) THEN
544: Close cur_rowid;
545: Fnd_Message.Set_Name ('IGS', 'IGS_FI_FAS_CRS_FK');
546: IGS_GE_MSG_STACK.ADD;
547: App_Exception.Raise_Exception;
548: Return;
549: END IF;
550: Close cur_rowid;
551: END GET_FK_IGS_PS_COURSE;

Line 569: App_Exception.Raise_Exception;

565: IF (cur_rowid%FOUND) THEN
566: Close cur_rowid;
567: Fnd_Message.Set_Name ('IGS', 'IGS_FI_FAS_PE_FK');
568: IGS_GE_MSG_STACK.ADD;
569: App_Exception.Raise_Exception;
570: Return;
571: END IF;
572: Close cur_rowid;
573: END GET_FK_IGS_PE_PERSON;

Line 590: App_Exception.Raise_Exception;

586: IF (cur_rowid%FOUND) THEN
587: Close cur_rowid;
588: Fnd_Message.Set_Name ('IGS', 'IGS_FI_FAS_STRTY_FK');
589: IGS_GE_MSG_STACK.ADD;
590: App_Exception.Raise_Exception;
591: Return;
592: END IF;
593: Close cur_rowid;
594: END GET_FK_IGS_LOOKUPS_VIEW;

Line 674: App_Exception.Raise_Exception;

670: new_references.transaction_id
671: ) THEN
672: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
673: IGS_GE_MSG_STACK.ADD;
674: App_Exception.Raise_Exception;
675: END IF;
676: Check_Constraints;
677: Check_Uniqueness;
678: Check_Parent_Existance;

Line 697: App_Exception.Raise_Exception;

693: new_references.transaction_id
694: ) THEN
695: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
696: IGS_GE_MSG_STACK.ADD;
697: App_Exception.Raise_Exception;
698: END IF;
699: Check_Constraints;
700: Check_Uniqueness;
701: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 819: app_exception.raise_exception;

815: end if;
816: else
817: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
818: IGS_GE_MSG_STACK.ADD;
819: app_exception.raise_exception;
820: end if;
821: ---added by syam on 23-aug-2000
822: SELECT igs_fi_fee_as_trn_id_s.nextval
823: INTO x_transaction_id

Line 971: app_exception.raise_exception;

967: if (c1%notfound) then
968: close c1;
969: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
970: IGS_GE_MSG_STACK.ADD;
971: app_exception.raise_exception;
972: return;
973: end if;
974: close c1;
975: if (

Line 1035: app_exception.raise_exception;

1031: null;
1032: else
1033: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1034: IGS_GE_MSG_STACK.ADD;
1035: app_exception.raise_exception;
1036: end if;
1037: return;
1038: end LOCK_ROW;
1039: procedure UPDATE_ROW (

Line 1133: app_exception.raise_exception;

1129: end if;
1130: else
1131: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
1132: IGS_GE_MSG_STACK.ADD;
1133: app_exception.raise_exception;
1134: end if;
1135: update IGS_FI_FEE_AS_ALL set
1136: FEE_TYPE = NEW_REFERENCES.FEE_TYPE,
1137: FEE_CAL_TYPE = NEW_REFERENCES.FEE_CAL_TYPE,