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

Line 55: App_Exception.Raise_Exception;

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

Line 128: App_Exception.Raise_Exception;

124: IF ((UPPER (column_name) = 'RETENTION_PERCENTAGE') OR (column_name IS NULL)) THEN
125: IF ((new_references.retention_percentage < 0) OR (new_references.retention_percentage > 100.00)) THEN
126: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
127: IGS_GE_MSG_STACK.ADD;
128: App_Exception.Raise_Exception;
129: END IF;
130: END IF;
131: IF ((UPPER (column_name) = 'RETENTION_AMOUNT') OR (column_name IS NULL)) THEN
132: IF ((new_references.retention_amount < 0)) THEN

Line 135: App_Exception.Raise_Exception;

131: IF ((UPPER (column_name) = 'RETENTION_AMOUNT') OR (column_name IS NULL)) THEN
132: IF ((new_references.retention_amount < 0)) THEN
133: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
134: IGS_GE_MSG_STACK.ADD;
135: App_Exception.Raise_Exception;
136: END IF;
137: END IF;
138: IF ((UPPER (column_name) = 'DT_ALIAS') OR (column_name IS NULL)) THEN
139: IF (new_references.dt_alias <> UPPER (new_references.dt_alias)) THEN

Line 142: App_Exception.Raise_Exception;

138: IF ((UPPER (column_name) = 'DT_ALIAS') OR (column_name IS NULL)) THEN
139: IF (new_references.dt_alias <> UPPER (new_references.dt_alias)) THEN
140: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
141: IGS_GE_MSG_STACK.ADD;
142: App_Exception.Raise_Exception;
143: END IF;
144: END IF;
145: IF ((UPPER (column_name) = 'FEE_CAL_TYPE') OR (column_name IS NULL)) THEN
146: IF (new_references.fee_cal_type <> UPPER (new_references.fee_cal_type)) THEN

Line 149: App_Exception.Raise_Exception;

145: IF ((UPPER (column_name) = 'FEE_CAL_TYPE') OR (column_name IS NULL)) THEN
146: IF (new_references.fee_cal_type <> UPPER (new_references.fee_cal_type)) THEN
147: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
148: IGS_GE_MSG_STACK.ADD;
149: App_Exception.Raise_Exception;
150: END IF;
151: END IF;
152: IF ((UPPER (column_name) = 'S_RELATION_TYPE') OR (column_name IS NULL)) THEN
153: IF (new_references.s_relation_type <> UPPER (new_references.s_relation_type)) THEN

Line 156: App_Exception.Raise_Exception;

152: IF ((UPPER (column_name) = 'S_RELATION_TYPE') OR (column_name IS NULL)) THEN
153: IF (new_references.s_relation_type <> UPPER (new_references.s_relation_type)) THEN
154: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
155: IGS_GE_MSG_STACK.ADD;
156: App_Exception.Raise_Exception;
157: END IF;
158: END IF;
159: IF ((UPPER (column_name) = 'SEQUENCE_NUMBER') OR (column_name IS NULL)) THEN
160: IF ((new_references.sequence_number < 1) OR (new_references.sequence_number > 999999)) THEN

Line 163: App_Exception.Raise_Exception;

159: IF ((UPPER (column_name) = 'SEQUENCE_NUMBER') OR (column_name IS NULL)) THEN
160: IF ((new_references.sequence_number < 1) OR (new_references.sequence_number > 999999)) THEN
161: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
162: IGS_GE_MSG_STACK.ADD;
163: App_Exception.Raise_Exception;
164: END IF;
165: END IF;
166: IF ((UPPER (column_name) = 'DAI_SEQUENCE_NUMBER') OR (column_name IS NULL)) THEN
167: IF ((new_references.dai_sequence_number < 1) OR (new_references.dai_sequence_number > 999999)) THEN

Line 170: App_Exception.Raise_Exception;

166: IF ((UPPER (column_name) = 'DAI_SEQUENCE_NUMBER') OR (column_name IS NULL)) THEN
167: IF ((new_references.dai_sequence_number < 1) OR (new_references.dai_sequence_number > 999999)) THEN
168: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
169: IGS_GE_MSG_STACK.ADD;
170: App_Exception.Raise_Exception;
171: END IF;
172: END IF;
173: IF ((UPPER (column_name) = 'SCHEDULE_NUMBER') OR (column_name IS NULL)) THEN
174: IF ((new_references.schedule_number < 1) OR (new_references.schedule_number > 999999)) THEN

Line 177: App_Exception.Raise_Exception;

173: IF ((UPPER (column_name) = 'SCHEDULE_NUMBER') OR (column_name IS NULL)) THEN
174: IF ((new_references.schedule_number < 1) OR (new_references.schedule_number > 999999)) THEN
175: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
176: IGS_GE_MSG_STACK.ADD;
177: App_Exception.Raise_Exception;
178: END IF;
179: END IF;
180: IF ((UPPER (column_name) = 'FEE_CI_SEQUENCE_NUMBER') OR (column_name IS NULL)) THEN
181: IF ((new_references.fee_ci_sequence_number < 1) OR (new_references.fee_ci_sequence_number > 999999)) THEN

Line 184: App_Exception.Raise_Exception;

180: IF ((UPPER (column_name) = 'FEE_CI_SEQUENCE_NUMBER') OR (column_name IS NULL)) THEN
181: IF ((new_references.fee_ci_sequence_number < 1) OR (new_references.fee_ci_sequence_number > 999999)) THEN
182: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
183: IGS_GE_MSG_STACK.ADD;
184: App_Exception.Raise_Exception;
185: END IF;
186: END IF;
187: END Check_Constraints;
188: PROCEDURE Check_Uniqueness AS

Line 200: App_Exception.Raise_Exception;

196: new_references.hist_start_dt
197: ) THEN
198: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
199: IGS_GE_MSG_STACK.ADD;
200: App_Exception.Raise_Exception;
201: END IF;
202: END Check_Uniqueness;
203: PROCEDURE Check_Parent_Existance AS
204: BEGIN

Line 220: App_Exception.Raise_Exception;

216: new_references.fee_ci_sequence_number
217: ) THEN
218: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
219: IGS_GE_MSG_STACK.ADD;
220: App_Exception.Raise_Exception;
221: END IF;
222: END IF;
223: IF (((old_references.fee_cat = new_references.fee_cat) AND
224: (old_references.fee_cal_type = new_references.fee_cal_type) AND

Line 241: App_Exception.Raise_Exception;

237: new_references.fee_type
238: ) THEN
239: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
240: IGS_GE_MSG_STACK.ADD;
241: App_Exception.Raise_Exception;
242: END IF;
243: END IF;
244: IF (((old_references.fee_type = new_references.fee_type) AND
245: (old_references.fee_cal_type = new_references.fee_cal_type) AND

Line 259: App_Exception.Raise_Exception;

255: new_references.fee_ci_sequence_number
256: ) THEN
257: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
258: IGS_GE_MSG_STACK.ADD;
259: App_Exception.Raise_Exception;
260: END IF;
261: END IF;
262: END Check_Parent_Existance;
263: FUNCTION Get_PK_For_Validation (

Line 341: App_Exception.Raise_Exception;

337: IF (cur_rowid%FOUND) THEN
338: Close cur_rowid;
339: Fnd_Message.Set_Name ('IGS', 'IGS_FI_FRTNSH_FCCI_FK');
340: IGS_GE_MSG_STACK.ADD;
341: App_Exception.Raise_Exception;
342: Return;
343: END IF;
344: Close cur_rowid;
345: END GET_FK_IGS_FI_F_CAT_CA_INST;

Line 418: App_Exception.Raise_Exception;

414: new_references.hist_start_dt
415: )) THEN
416: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
417: IGS_GE_MSG_STACK.ADD;
418: App_Exception.Raise_Exception;
419: END IF;
420: Check_Uniqueness;
421: Check_Constraints;
422: Check_Parent_Existance;

Line 439: App_Exception.Raise_Exception;

435: new_references.hist_start_dt
436: )) THEN
437: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
438: IGS_GE_MSG_STACK.ADD;
439: App_Exception.Raise_Exception;
440: END IF;
441: Check_Uniqueness;
442: Check_Constraints;
443: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 504: app_exception.raise_exception;

500: end if;
501: else
502: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
503: IGS_GE_MSG_STACK.ADD;
504: app_exception.raise_exception;
505: end if;
506: Before_DML(
507: p_action=>'INSERT',
508: x_rowid=>X_ROWID,

Line 630: app_exception.raise_exception;

626: if (c1%notfound) then
627: close c1;
628: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
629: IGS_GE_MSG_STACK.ADD;
630: app_exception.raise_exception;
631: return;
632: end if;
633: close c1;
634: if ( (tlinfo.HIST_END_DT = X_HIST_END_DT)

Line 662: app_exception.raise_exception;

658: null;
659: else
660: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
661: IGS_GE_MSG_STACK.ADD;
662: app_exception.raise_exception;
663: end if;
664: return;
665: end LOCK_ROW;
666: procedure UPDATE_ROW (

Line 715: app_exception.raise_exception;

711: end if;
712: else
713: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
714: IGS_GE_MSG_STACK.ADD;
715: app_exception.raise_exception;
716: end if;
717: Before_DML(
718: p_action=>'UPDATE',
719: x_rowid=>X_ROWID,