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 IGS_GE_MSG_STACK

Line 54: IGS_GE_MSG_STACK.ADD;

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

Line 127: IGS_GE_MSG_STACK.ADD;

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

Line 134: IGS_GE_MSG_STACK.ADD;

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

Line 141: IGS_GE_MSG_STACK.ADD;

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

Line 148: IGS_GE_MSG_STACK.ADD;

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

Line 155: IGS_GE_MSG_STACK.ADD;

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

Line 162: IGS_GE_MSG_STACK.ADD;

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

Line 169: IGS_GE_MSG_STACK.ADD;

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

Line 176: IGS_GE_MSG_STACK.ADD;

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

Line 183: IGS_GE_MSG_STACK.ADD;

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

Line 199: IGS_GE_MSG_STACK.ADD;

195: new_references.schedule_number,
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

Line 219: IGS_GE_MSG_STACK.ADD;

215: new_references.fee_cal_type,
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

Line 240: IGS_GE_MSG_STACK.ADD;

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

Line 258: IGS_GE_MSG_STACK.ADD;

254: new_references.fee_cal_type,
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;

Line 340: IGS_GE_MSG_STACK.ADD;

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

Line 417: IGS_GE_MSG_STACK.ADD;

413: new_references.sequence_number,
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;

Line 438: IGS_GE_MSG_STACK.ADD;

434: new_references.sequence_number,
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;

Line 503: IGS_GE_MSG_STACK.ADD;

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

Line 629: IGS_GE_MSG_STACK.ADD;

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

Line 661: IGS_GE_MSG_STACK.ADD;

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

Line 714: IGS_GE_MSG_STACK.ADD;

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