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

Line 54: App_Exception.Raise_Exception;

50: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
51: Close cur_old_ref_values;
52: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
53: IGS_GE_MSG_STACK.ADD;
54: App_Exception.Raise_Exception;
55: Return;
56: END IF;
57: Close cur_old_ref_values;
58: -- Populate New Values.

Line 149: App_Exception.Raise_Exception;

145: CLOSE c_sft;
146: IF( l_s_fee_type = 'REFUND') THEN
147: Fnd_Message.Set_Name('IGS','IGS_FI_INVALID_REFUND_FCFL');
148: IGS_GE_MSG_STACK.ADD;
149: App_Exception.Raise_Exception;
150: END IF;
151: END IF;
152: -- Validate Fee Liability Status.
153: IF (p_inserting OR (old_references.fee_liability_status) <>

Line 160: App_Exception.Raise_Exception;

156: new_references.fee_liability_status,
157: v_message_name) = FALSE THEN
158: Fnd_Message.Set_Name('IGS',v_message_name);
159: IGS_GE_MSG_STACK.ADD;
160: App_Exception.Raise_Exception;
161: END IF;
162: -- Validate status can be set to 'ACTIVE'
163: IF IGS_FI_VAL_FCFL.finp_val_fcfl_active (
164: new_references.fee_liability_status,

Line 170: App_Exception.Raise_Exception;

166: new_references.fee_ci_sequence_number,
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: IF IGS_FI_VAL_FCFL.finp_val_fcfl_status (
173: new_references.fee_cal_type,
174: new_references.fee_ci_sequence_number,

Line 181: App_Exception.Raise_Exception;

177: new_references.fee_liability_status,
178: v_message_name) = FALSE THEN
179: Fnd_Message.Set_Name('IGS',v_message_name);
180: IGS_GE_MSG_STACK.ADD;
181: App_Exception.Raise_Exception;
182: END IF;
183: END IF;
184: -- Validate Fee Liability Charge Method Type and Rule Sequence Number.
185: IF p_inserting OR p_updating THEN

Line 195: App_Exception.Raise_Exception;

191: new_references.rul_sequence_number,
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: -- Validate fee category currency with details inherited from FTCI
199: IF p_inserting THEN

Line 208: App_Exception.Raise_Exception;

204: new_references.fee_cat,
205: v_message_name) = FALSE THEN
206: Fnd_Message.Set_Name('IGS',v_message_name);
207: IGS_GE_MSG_STACK.ADD;
208: App_Exception.Raise_Exception;
209: END IF;
210: END IF;
211:
212: -- Enh# 2747325, Removed the case for p_deleting as deletion is disabled as part of Locking Issues Build.

Line 285: App_Exception.Raise_Exception;

281: new_references.s_chg_method_type
282: ) THEN
283: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
284: IGS_GE_MSG_STACK.ADD;
285: App_Exception.Raise_Exception;
286: END IF;
287: END Check_Uniqueness;
288: PROCEDURE Check_Constraints (
289: column_name IN VARCHAR2,

Line 323: App_Exception.Raise_Exception;

319: IF ((UPPER (column_name) = 'START_DAI_SEQUENCE_NUMBER') OR (column_name IS NULL)) THEN
320: IF ((new_references.start_dai_sequence_number < 1) OR (new_references.start_dai_sequence_number > 999999)) 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) = 'RUL_SEQUENCE_NUMBER') OR (column_name IS NULL)) THEN
327: IF ((new_references.rul_sequence_number < 1) OR (new_references.rul_sequence_number > 999999)) THEN

Line 330: App_Exception.Raise_Exception;

326: IF ((UPPER (column_name) = 'RUL_SEQUENCE_NUMBER') OR (column_name IS NULL)) THEN
327: IF ((new_references.rul_sequence_number < 1) OR (new_references.rul_sequence_number > 999999)) 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) = 'FEE_CI_SEQUENCE_NUMBER') OR (column_name IS NULL)) THEN
334: IF ((new_references.fee_ci_sequence_number < 1) OR (new_references.fee_ci_sequence_number > 999999)) THEN

Line 337: App_Exception.Raise_Exception;

333: IF ((UPPER (column_name) = 'FEE_CI_SEQUENCE_NUMBER') OR (column_name IS NULL)) THEN
334: IF ((new_references.fee_ci_sequence_number < 1) OR (new_references.fee_ci_sequence_number > 999999)) 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) = 'FEE_CAL_TYPE') OR (column_name IS NULL)) THEN
341: IF (new_references.fee_cal_type <> UPPER (new_references.fee_cal_type)) THEN

Line 344: App_Exception.Raise_Exception;

340: IF ((UPPER (column_name) = 'FEE_CAL_TYPE') OR (column_name IS NULL)) THEN
341: IF (new_references.fee_cal_type <> UPPER (new_references.fee_cal_type)) 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) = 'START_DT_ALIAS') OR (column_name IS NULL)) THEN
348: IF (new_references.start_dt_alias <> UPPER (new_references.start_dt_alias)) THEN

Line 351: App_Exception.Raise_Exception;

347: IF ((UPPER (column_name) = 'START_DT_ALIAS') OR (column_name IS NULL)) THEN
348: IF (new_references.start_dt_alias <> UPPER (new_references.start_dt_alias)) 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: IF ((UPPER (column_name) = 'S_CHG_METHOD_TYPE') OR (column_name IS NULL)) THEN
355: IF (new_references.s_chg_method_type <> UPPER (new_references.s_chg_method_type)) THEN

Line 358: App_Exception.Raise_Exception;

354: IF ((UPPER (column_name) = 'S_CHG_METHOD_TYPE') OR (column_name IS NULL)) THEN
355: IF (new_references.s_chg_method_type <> UPPER (new_references.s_chg_method_type)) THEN
356: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
357: IGS_GE_MSG_STACK.ADD;
358: App_Exception.Raise_Exception;
359: END IF;
360: END IF;
361: END Check_Constraints;
362: PROCEDURE Check_Parent_Existance AS

Line 382: App_Exception.Raise_Exception;

378: new_references.fee_ci_sequence_number
379: ) THEN
380: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
381: IGS_GE_MSG_STACK.ADD;
382: App_Exception.Raise_Exception;
383: END IF;
384: END IF;
385: IF (((old_references.fee_cat = new_references.fee_cat) AND
386: (old_references.fee_cal_type = new_references.fee_cal_type) AND

Line 400: App_Exception.Raise_Exception;

396: new_references.fee_ci_sequence_number
397: ) THEN
398: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
399: IGS_GE_MSG_STACK.ADD;
400: App_Exception.Raise_Exception;
401: END IF;
402: END IF;
403: IF (((old_references.fee_liability_status = new_references.fee_liability_status)) OR
404: ((new_references.fee_liability_status IS NULL))) THEN

Line 412: App_Exception.Raise_Exception;

408: new_references.fee_liability_status
409: ) THEN
410: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
411: IGS_GE_MSG_STACK.ADD;
412: App_Exception.Raise_Exception;
413: END IF;
414: END IF;
415: IF (((old_references.fee_type = new_references.fee_type) AND
416: (old_references.fee_cal_type = new_references.fee_cal_type) AND

Line 430: App_Exception.Raise_Exception;

426: new_references.fee_ci_sequence_number
427: ) THEN
428: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
429: IGS_GE_MSG_STACK.ADD;
430: App_Exception.Raise_Exception;
431: END IF;
432: END IF;
433: IF (((old_references.rul_sequence_number = new_references.rul_sequence_number)) OR
434: ((new_references.rul_sequence_number IS NULL))) THEN

Line 442: App_Exception.Raise_Exception;

438: new_references.rul_sequence_number
439: ) THEN
440: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
441: IGS_GE_MSG_STACK.ADD;
442: App_Exception.Raise_Exception;
443: END IF;
444: END IF;
445: END Check_Parent_Existance;
446:

Line 525: App_Exception.Raise_Exception;

521: IF (cur_rowid%FOUND) THEN
522: Close cur_rowid;
523: Fnd_Message.Set_Name ('IGS', 'IGS_FI_FCFL_DAI_FK');
524: IGS_GE_MSG_STACK.ADD;
525: App_Exception.Raise_Exception;
526: Return;
527: END IF;
528: Close cur_rowid;
529: END GET_FK_IGS_CA_DA_INST;

Line 549: App_Exception.Raise_Exception;

545: IF (cur_rowid%FOUND) THEN
546: Close cur_rowid;
547: Fnd_Message.Set_Name ('IGS', 'IGS_FI_FCFL_FCCI_FK');
548: IGS_GE_MSG_STACK.ADD;
549: App_Exception.Raise_Exception;
550: Return;
551: END IF;
552: Close cur_rowid;
553: END GET_FK_IGS_FI_F_CAT_CA_INST;

Line 569: App_Exception.Raise_Exception;

565: IF (cur_rowid%FOUND) THEN
566: Close cur_rowid;
567: Fnd_Message.Set_Name ('IGS', 'IGS_FI_FCFL_FSST_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_FI_FEE_STR_STAT;

Line 590: App_Exception.Raise_Exception;

586: IF (cur_rowid%FOUND) THEN
587: Close cur_rowid;
588: Fnd_Message.Set_Name ('IGS', 'IGS_FI_FCFL_RUL_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_RU_RULE;

Line 610: App_Exception.Raise_Exception;

606: IF (cur_rowid%FOUND) THEN
607: Close cur_rowid;
608: Fnd_Message.Set_Name ('IGS', 'IGS_FI_FCFL_LKUP_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_LOOKUPS_VIEW;

Line 686: App_Exception.Raise_Exception;

682: x_fee_type
683: )) THEN
684: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
685: IGS_GE_MSG_STACK.ADD;
686: App_Exception.Raise_Exception;
687: END IF;
688: Check_Uniqueness;
689: Check_Constraints;
690: Check_Parent_Existance;

Line 706: App_Exception.Raise_Exception;

702: x_fee_type
703: )) THEN
704: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
705: IGS_GE_MSG_STACK.ADD;
706: App_Exception.Raise_Exception;
707: END IF;
708: Check_Uniqueness;
709: Check_Constraints;
710: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 804: app_exception.raise_exception;

800: end if;
801: else
802: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
803: IGS_GE_MSG_STACK.ADD;
804: app_exception.raise_exception;
805: end if;
806: Before_DML(
807: p_action=>'INSERT',
808: x_rowid=>X_ROWID,

Line 923: app_exception.raise_exception;

919: if (c1%notfound) then
920: close c1;
921: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
922: IGS_GE_MSG_STACK.ADD;
923: app_exception.raise_exception;
924: return;
925: end if;
926: close c1;
927: if ( (tlinfo.FEE_LIABILITY_STATUS = X_FEE_LIABILITY_STATUS)

Line 948: app_exception.raise_exception;

944: null;
945: else
946: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
947: IGS_GE_MSG_STACK.ADD;
948: app_exception.raise_exception;
949: end if;
950: return;
951: end LOCK_ROW;
952: procedure UPDATE_ROW (

Line 1012: app_exception.raise_exception;

1008: end if;
1009: else
1010: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
1011: IGS_GE_MSG_STACK.ADD;
1012: app_exception.raise_exception;
1013: end if;
1014: Before_DML(
1015: p_action=>'UPDATE',
1016: x_rowid=>X_ROWID,