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_UNIT_FEE_TRG_PKG dependencies on APP_EXCEPTION

Line 43: App_Exception.Raise_Exception;

39: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
40: Close cur_old_ref_values;
41: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
42: IGS_GE_MSG_STACK.ADD;
43: App_Exception.Raise_Exception;
44: Return;
45: END IF;
46: Close cur_old_ref_values;
47: -- Populate New Values.

Line 94: App_Exception.Raise_Exception;

90: new_references.fee_type,
91: v_message_name) = FALSE THEN
92: Fnd_Message.Set_Name('IGS',v_message_name);
93: IGS_GE_MSG_STACK.ADD;
94: App_Exception.Raise_Exception;
95: END IF;
96: END IF;
97:
98: -- Bug# 5070980. Not able to delete Unit Fee Trigger When Unit Version Is Inactive.

Line 111: App_Exception.Raise_Exception;

107: new_references.version_number,
108: v_message_name) = FALSE THEN
109: Fnd_Message.Set_Name('IGS',v_message_name);
110: IGS_GE_MSG_STACK.ADD;
111: App_Exception.Raise_Exception;
112: END IF;
113: END IF;
114: END IF;
115: -- Validate fee trigger group can be defined.

Line 123: App_Exception.Raise_Exception;

119: new_references.fee_trigger_group_number,
120: v_message_name) = FALSE THEN
121: Fnd_Message.Set_Name('IGS',v_message_name);
122: IGS_GE_MSG_STACK.ADD;
123: App_Exception.Raise_Exception;
124: END IF;
125: END IF;
126: -- Validate calendar type is not closed and is of type teaching.
127: IF (new_references.cal_type IS NOT NULL) THEN

Line 135: App_Exception.Raise_Exception;

131: new_references.cal_type,
132: v_message_name) = FALSE THEN
133: Fnd_Message.Set_Name('IGS',v_message_name);
134: IGS_GE_MSG_STACK.ADD;
135: App_Exception.Raise_Exception;
136: END IF;
137: END IF;
138: -- Validate calendar instance is not inactive.
139: IF (new_references.cal_type IS NOT NULL AND

Line 148: App_Exception.Raise_Exception;

144: new_references.ci_sequence_number,
145: v_message_name) = FALSE THEN
146: Fnd_Message.Set_Name('IGS',v_message_name);
147: IGS_GE_MSG_STACK.ADD;
148: App_Exception.Raise_Exception;
149: END IF;
150: END IF;
151: -- Validate location code is not closed and is of type campus.
152: IF (new_references.location_cd IS NOT NULL) THEN

Line 159: App_Exception.Raise_Exception;

155: new_references.location_cd,
156: v_message_name) = FALSE THEN
157: Fnd_Message.Set_Name('IGS',v_message_name);
158: IGS_GE_MSG_STACK.ADD;
159: App_Exception.Raise_Exception;
160: END IF;
161: END IF;
162: -- Validate unit class is not closed.
163: IF (new_references.unit_class IS NOT NULL) THEN

Line 170: App_Exception.Raise_Exception;

166: new_references.unit_class,
167: v_message_name) = FALSE THEN
168: Fnd_Message.Set_Name('IGS',v_message_name);
169: IGS_GE_MSG_STACK.ADD;
170: App_Exception.Raise_Exception;
171: END IF;
172: END IF;
173: END BeforeRowInsertUpdate1;
174: -- Trigger description :-

Line 241: App_Exception.Raise_Exception;

237: new_references.fee_trigger_group_number,
238: v_message_name) = FALSE THEN
239: Fnd_Message.Set_Name('IGS',v_message_name);
240: IGS_GE_MSG_STACK.ADD;
241: App_Exception.Raise_Exception;
242: END IF;
243: END IF;
244: END IF;
245: END AfterStmtInsertUpdate4;

Line 288: App_Exception.Raise_Exception;

284: IF ((UPPER (column_name) = 'SEQUENCE_NUMBER') OR (column_name IS NULL)) THEN
285: IF ((new_references.sequence_number < 1) OR (new_references.sequence_number > 999999)) THEN
286: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
287: IGS_GE_MSG_STACK.ADD;
288: App_Exception.Raise_Exception;
289: END IF;
290: END IF;
291: IF ((UPPER (column_name) = 'CI_SEQUENCE_NUMBER') OR (column_name IS NULL)) THEN
292: IF ((new_references.ci_sequence_number < 1) OR (new_references.ci_sequence_number > 999999)) THEN

Line 295: App_Exception.Raise_Exception;

291: IF ((UPPER (column_name) = 'CI_SEQUENCE_NUMBER') OR (column_name IS NULL)) THEN
292: IF ((new_references.ci_sequence_number < 1) OR (new_references.ci_sequence_number > 999999)) THEN
293: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
294: IGS_GE_MSG_STACK.ADD;
295: App_Exception.Raise_Exception;
296: END IF;
297: END IF;
298: IF ((UPPER (column_name) = 'VERSION_NUMBER') OR (column_name IS NULL)) THEN
299: IF ((new_references.version_number < 1) OR (new_references.version_number > 999)) THEN

Line 302: App_Exception.Raise_Exception;

298: IF ((UPPER (column_name) = 'VERSION_NUMBER') OR (column_name IS NULL)) THEN
299: IF ((new_references.version_number < 1) OR (new_references.version_number > 999)) THEN
300: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
301: IGS_GE_MSG_STACK.ADD;
302: App_Exception.Raise_Exception;
303: END IF;
304: END IF;
305: IF ((UPPER (column_name) = 'FEE_TRIGGER_GROUP_NUMBER') OR (column_name IS NULL)) THEN
306: IF ((new_references.fee_trigger_group_number < 1) OR (new_references.fee_trigger_group_number > 999999)) THEN

Line 309: App_Exception.Raise_Exception;

305: IF ((UPPER (column_name) = 'FEE_TRIGGER_GROUP_NUMBER') OR (column_name IS NULL)) THEN
306: IF ((new_references.fee_trigger_group_number < 1) OR (new_references.fee_trigger_group_number > 999999)) 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) = 'FEE_CI_SEQUENCE_NUMBER') OR (column_name IS NULL)) THEN
313: IF ((new_references.fee_ci_sequence_number < 1) OR (new_references.fee_ci_sequence_number > 999999)) THEN

Line 316: App_Exception.Raise_Exception;

312: IF ((UPPER (column_name) = 'FEE_CI_SEQUENCE_NUMBER') OR (column_name IS NULL)) THEN
313: IF ((new_references.fee_ci_sequence_number < 1) OR (new_references.fee_ci_sequence_number > 999999)) THEN
314: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
315: IGS_GE_MSG_STACK.ADD;
316: App_Exception.Raise_Exception;
317: END IF;
318: END IF;
319: IF ((UPPER (column_name) = 'CAL_TYPE') OR (column_name IS NULL)) THEN
320: IF (new_references.cal_type <> UPPER (new_references.cal_type)) THEN

Line 323: App_Exception.Raise_Exception;

319: IF ((UPPER (column_name) = 'CAL_TYPE') OR (column_name IS NULL)) THEN
320: IF (new_references.cal_type <> UPPER (new_references.cal_type)) THEN
321: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
322: IGS_GE_MSG_STACK.ADD;
323: App_Exception.Raise_Exception;
324: END IF;
325: END IF;
326: IF ((UPPER (column_name) = 'FEE_CAL_TYPE') OR (column_name IS NULL)) THEN
327: IF (new_references.fee_cal_type <> UPPER (new_references.fee_cal_type)) THEN

Line 330: App_Exception.Raise_Exception;

326: IF ((UPPER (column_name) = 'FEE_CAL_TYPE') OR (column_name IS NULL)) THEN
327: IF (new_references.fee_cal_type <> UPPER (new_references.fee_cal_type)) THEN
328: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
329: IGS_GE_MSG_STACK.ADD;
330: App_Exception.Raise_Exception;
331: END IF;
332: END IF;
333: IF ((UPPER (column_name) = 'LOCATION_CD') OR (column_name IS NULL)) THEN
334: IF (new_references.location_cd <> UPPER (new_references.location_cd)) THEN

Line 337: App_Exception.Raise_Exception;

333: IF ((UPPER (column_name) = 'LOCATION_CD') OR (column_name IS NULL)) THEN
334: IF (new_references.location_cd <> UPPER (new_references.location_cd)) THEN
335: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
336: IGS_GE_MSG_STACK.ADD;
337: App_Exception.Raise_Exception;
338: END IF;
339: END IF;
340: IF ((UPPER (column_name) = 'UNIT_CD') OR (column_name IS NULL)) THEN
341: IF (new_references.unit_cd <> UPPER (new_references.unit_cd)) THEN

Line 344: App_Exception.Raise_Exception;

340: IF ((UPPER (column_name) = 'UNIT_CD') OR (column_name IS NULL)) THEN
341: IF (new_references.unit_cd <> UPPER (new_references.unit_cd)) THEN
342: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
343: IGS_GE_MSG_STACK.ADD;
344: App_Exception.Raise_Exception;
345: END IF;
346: END IF;
347: IF ((UPPER (column_name) = 'UNIT_CLASS') OR (column_name IS NULL)) THEN
348: IF (new_references.unit_class <> UPPER (new_references.unit_class)) THEN

Line 351: App_Exception.Raise_Exception;

347: IF ((UPPER (column_name) = 'UNIT_CLASS') OR (column_name IS NULL)) THEN
348: IF (new_references.unit_class <> UPPER (new_references.unit_class)) THEN
349: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
350: IGS_GE_MSG_STACK.ADD;
351: App_Exception.Raise_Exception;
352: END IF;
353: END IF;
354: END Check_Constraints;
355: PROCEDURE Check_Uniqueness AS

Line 372: App_Exception.Raise_Exception;

368: new_references.create_dt
369: )) THEN
370: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
371: IGS_GE_MSG_STACK.ADD;
372: App_Exception.Raise_Exception;
373: END IF;
374: END Check_Uniqueness;
375: PROCEDURE Check_Parent_Existance AS
376: BEGIN

Line 386: App_Exception.Raise_Exception;

382: new_references.cal_type
383: ) THEN
384: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
385: IGS_GE_MSG_STACK.ADD;
386: App_Exception.Raise_Exception;
387: END IF;
388: END IF;
389: IF (((old_references.cal_type = new_references.cal_type) AND
390: (old_references.ci_sequence_number = new_references.ci_sequence_number)) OR

Line 401: App_Exception.Raise_Exception;

397: new_references.ci_sequence_number
398: ) THEN
399: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
400: IGS_GE_MSG_STACK.ADD;
401: App_Exception.Raise_Exception;
402: END IF;
403: END IF;
404: IF (((old_references.fee_cat = new_references.fee_cat) AND
405: (old_references.fee_cal_type = new_references.fee_cal_type) AND

Line 422: App_Exception.Raise_Exception;

418: new_references.fee_type
419: ) THEN
420: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
421: IGS_GE_MSG_STACK.ADD;
422: App_Exception.Raise_Exception;
423: END IF;
424: END IF;
425: IF (((old_references.fee_cat = new_references.fee_cat) AND
426: (old_references.fee_cal_type = new_references.fee_cal_type) AND

Line 446: App_Exception.Raise_Exception;

442: new_references.fee_trigger_group_number
443: ) THEN
444: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
445: IGS_GE_MSG_STACK.ADD;
446: App_Exception.Raise_Exception;
447: END IF;
448: END IF;
449: IF (((old_references.location_cd = new_references.location_cd)) OR
450: ((new_references.location_cd IS NULL))) THEN

Line 459: App_Exception.Raise_Exception;

455: 'N'
456: ) THEN
457: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
458: IGS_GE_MSG_STACK.ADD;
459: App_Exception.Raise_Exception;
460: END IF;
461: END IF;
462: IF (((old_references.unit_class = new_references.unit_class)) OR
463: ((new_references.unit_class IS NULL))) THEN

Line 471: App_Exception.Raise_Exception;

467: new_references.unit_class
468: ) THEN
469: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
470: IGS_GE_MSG_STACK.ADD;
471: App_Exception.Raise_Exception;
472: END IF;
473: END IF;
474: IF (((old_references.unit_cd = new_references.unit_cd)) OR
475: ((new_references.unit_cd IS NULL))) THEN

Line 483: App_Exception.Raise_Exception;

479: new_references.unit_cd
480: ) THEN
481: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
482: IGS_GE_MSG_STACK.ADD;
483: App_Exception.Raise_Exception;
484: END IF;
485: END IF;
486: IF (((old_references.unit_cd = new_references.unit_cd) AND
487: (old_references.version_number = new_references.version_number)) OR

Line 498: App_Exception.Raise_Exception;

494: new_references.version_number
495: ) THEN
496: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
497: IGS_GE_MSG_STACK.ADD;
498: App_Exception.Raise_Exception;
499: END IF;
500: END IF;
501: END Check_Parent_Existance;
502: FUNCTION Get_PK_For_Validation (

Line 588: App_Exception.Raise_Exception;

584: IF (cur_rowid%FOUND) THEN
585: Close cur_rowid;
586: Fnd_Message.Set_Name ('IGS', 'IGS_FI_UFT_CAT_FK');
587: IGS_GE_MSG_STACK.ADD;
588: App_Exception.Raise_Exception;
589: Return;
590: END IF;
591: Close cur_rowid;
592: END GET_FK_IGS_CA_TYPE;

Line 610: App_Exception.Raise_Exception;

606: IF (cur_rowid%FOUND) THEN
607: Close cur_rowid;
608: Fnd_Message.Set_Name ('IGS', 'IGS_FI_UFT_CI_FK');
609: IGS_GE_MSG_STACK.ADD;
610: App_Exception.Raise_Exception;
611: Return;
612: END IF;
613: Close cur_rowid;
614: END GET_FK_IGS_CA_INST;

Line 639: App_Exception.Raise_Exception;

635: IF (cur_rowid%FOUND) THEN
636: Close cur_rowid;
637: Fnd_Message.Set_Name ('IGS', 'IGS_FI_UFT_FTG_FK');
638: IGS_GE_MSG_STACK.ADD;
639: App_Exception.Raise_Exception;
640: Return;
641: END IF;
642: Close cur_rowid;
643: END GET_FK_IGS_FI_FEE_TRG_GRP;

Line 659: App_Exception.Raise_Exception;

655: IF (cur_rowid%FOUND) THEN
656: Close cur_rowid;
657: Fnd_Message.Set_Name ('IGS', 'IGS_FI_UFT_LOC_FK');
658: IGS_GE_MSG_STACK.ADD;
659: App_Exception.Raise_Exception;
660: Return;
661: END IF;
662: Close cur_rowid;
663: END GET_FK_IGS_AD_LOCATION;

Line 679: App_Exception.Raise_Exception;

675: IF (cur_rowid%FOUND) THEN
676: Close cur_rowid;
677: Fnd_Message.Set_Name ('IGS', 'IGS_FI_UFT_UN_FK');
678: IGS_GE_MSG_STACK.ADD;
679: App_Exception.Raise_Exception;
680: Return;
681: END IF;
682: Close cur_rowid;
683: END GET_FK_IGS_PS_UNIT;

Line 701: App_Exception.Raise_Exception;

697: IF (cur_rowid%FOUND) THEN
698: Close cur_rowid;
699: Fnd_Message.Set_Name ('IGS', 'IGS_FI_UFT_UV_FK');
700: IGS_GE_MSG_STACK.ADD;
701: App_Exception.Raise_Exception;
702: Return;
703: END IF;
704: Close cur_rowid;
705: END GET_FK_IGS_PS_UNIT_VER;

Line 766: App_Exception.Raise_Exception;

762: new_references.sequence_number
763: )) THEN
764: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
765: IGS_GE_MSG_STACK.ADD;
766: App_Exception.Raise_Exception;
767: END IF;
768: Check_Uniqueness;
769: Check_Constraints;
770: Check_Parent_Existance;

Line 788: App_Exception.Raise_Exception;

784: new_references.sequence_number
785: )) THEN
786: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
787: IGS_GE_MSG_STACK.ADD;
788: App_Exception.Raise_Exception;
789: END IF;
790: Check_Uniqueness;
791: Check_Constraints;
792: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 857: app_exception.raise_exception;

853: end if;
854: else
855: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
856: IGS_GE_MSG_STACK.ADD;
857: app_exception.raise_exception;
858: end if;
859: Before_DML(
860: p_action=>'INSERT',
861: x_rowid=>X_ROWID,

Line 968: app_exception.raise_exception;

964: if (c1%notfound) then
965: close c1;
966: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
967: IGS_GE_MSG_STACK.ADD;
968: app_exception.raise_exception;
969: return;
970: end if;
971: close c1;
972: if ( ((tlinfo.VERSION_NUMBER = X_VERSION_NUMBER)

Line 999: app_exception.raise_exception;

995: null;
996: else
997: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
998: IGS_GE_MSG_STACK.ADD;
999: app_exception.raise_exception;
1000: end if;
1001: return;
1002: end LOCK_ROW;
1003: procedure UPDATE_ROW (

Line 1041: app_exception.raise_exception;

1037: end if;
1038: else
1039: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
1040: IGS_GE_MSG_STACK.ADD;
1041: app_exception.raise_exception;
1042: end if;
1043: Before_DML(
1044: p_action=>'UPDATE',
1045: x_rowid=>X_ROWID,