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 IGS_GE_MSG_STACK

Line 42: IGS_GE_MSG_STACK.ADD;

38: Fetch cur_old_ref_values INTO old_references;
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;

Line 93: IGS_GE_MSG_STACK.ADD;

89: IF IGS_FI_VAL_UFT.finp_val_uft_ins (
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:

Line 110: IGS_GE_MSG_STACK.ADD;

106: new_references.unit_cd,
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;

Line 122: IGS_GE_MSG_STACK.ADD;

118: new_references.fee_type,
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.

Line 134: IGS_GE_MSG_STACK.ADD;

130: IF IGS_PS_VAL_POSP.crsp_val_posp_cat (
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.

Line 147: IGS_GE_MSG_STACK.ADD;

143: new_references.cal_type,
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.

Line 158: IGS_GE_MSG_STACK.ADD;

154: IF IGS_PS_VAL_UOO.crsp_val_loc_cd (
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.

Line 169: IGS_GE_MSG_STACK.ADD;

165: IF IGS_AS_VAL_UAI.crsp_val_ucl_closed (
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;

Line 240: IGS_GE_MSG_STACK.ADD;

236: new_references.create_dt,
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;

Line 287: IGS_GE_MSG_STACK.ADD;

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

Line 294: IGS_GE_MSG_STACK.ADD;

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

Line 301: IGS_GE_MSG_STACK.ADD;

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

Line 308: IGS_GE_MSG_STACK.ADD;

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

Line 315: IGS_GE_MSG_STACK.ADD;

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

Line 322: IGS_GE_MSG_STACK.ADD;

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

Line 329: IGS_GE_MSG_STACK.ADD;

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

Line 336: IGS_GE_MSG_STACK.ADD;

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

Line 343: IGS_GE_MSG_STACK.ADD;

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

Line 350: IGS_GE_MSG_STACK.ADD;

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
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;

Line 371: IGS_GE_MSG_STACK.ADD;

367: new_references.unit_class,
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

Line 385: IGS_GE_MSG_STACK.ADD;

381: IF NOT IGS_CA_TYPE_PKG.Get_PK_For_Validation (
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

Line 400: IGS_GE_MSG_STACK.ADD;

396: new_references.cal_type,
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

Line 421: IGS_GE_MSG_STACK.ADD;

417: new_references.fee_ci_sequence_number,
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

Line 445: IGS_GE_MSG_STACK.ADD;

441: new_references.fee_type,
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

Line 458: IGS_GE_MSG_STACK.ADD;

454: new_references.location_cd ,
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

Line 470: IGS_GE_MSG_STACK.ADD;

466: IF NOT IGS_AS_UNIT_CLASS_PKG.Get_PK_For_Validation (
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

Line 482: IGS_GE_MSG_STACK.ADD;

478: IF NOT IGS_PS_UNIT_PKG.Get_PK_For_Validation (
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

Line 497: IGS_GE_MSG_STACK.ADD;

493: new_references.unit_cd,
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;

Line 587: IGS_GE_MSG_STACK.ADD;

583: Fetch cur_rowid INTO lv_rowid;
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;

Line 609: IGS_GE_MSG_STACK.ADD;

605: Fetch cur_rowid INTO lv_rowid;
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;

Line 638: IGS_GE_MSG_STACK.ADD;

634: Fetch cur_rowid INTO lv_rowid;
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;

Line 658: IGS_GE_MSG_STACK.ADD;

654: Fetch cur_rowid INTO lv_rowid;
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;

Line 678: IGS_GE_MSG_STACK.ADD;

674: Fetch cur_rowid INTO lv_rowid;
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;

Line 700: IGS_GE_MSG_STACK.ADD;

696: Fetch cur_rowid INTO lv_rowid;
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;

Line 765: IGS_GE_MSG_STACK.ADD;

761: new_references.unit_cd,
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;

Line 787: IGS_GE_MSG_STACK.ADD;

783: new_references.unit_cd,
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;

Line 856: IGS_GE_MSG_STACK.ADD;

852: X_LAST_UPDATE_LOGIN := -1;
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',

Line 967: IGS_GE_MSG_STACK.ADD;

963: fetch c1 into tlinfo;
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;

Line 998: IGS_GE_MSG_STACK.ADD;

994: ) then
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;

Line 1040: IGS_GE_MSG_STACK.ADD;

1036: X_LAST_UPDATE_LOGIN := -1;
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',