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_CA_DA_OFST_PKG dependencies on IGS_GE_MSG_STACK

Line 39: IGS_GE_MSG_STACK.ADD;

35: Fetch cur_old_ref_values INTO old_references;
36: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
37: Close cur_old_ref_values;
38: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
39: IGS_GE_MSG_STACK.ADD;
40: App_Exception.Raise_Exception;
41: Return;
42: END IF;
43: Close cur_old_ref_values;

Line 86: IGS_GE_MSG_STACK.ADD;

82: new_references.offset_dt_alias,
83: v_message_name) = FALSE
84: THEN
85: Fnd_Message.Set_Name('IGS',v_message_name);
86: IGS_GE_MSG_STACK.ADD;
87: APP_EXCEPTION.RAISE_EXCEPTION;
88: END IF;
89: END IF;
90: END AfterStmtInsertUpdate2;

Line 117: IGS_GE_MSG_STACK.ADD;

113:
114: If upper(Column_name)= 'DAY_OFFSET' Or column_name is null then
115: If new_references.day_offset < -999 or new_references.day_offset > 999 Then
116: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
117: IGS_GE_MSG_STACK.ADD;
118: App_Exception.Raise_Exception;
119: End if;
120: End if;
121:

Line 125: IGS_GE_MSG_STACK.ADD;

121:
122: If upper(Column_name)= 'WEEK_OFFSET' Or column_name is null then
123: If new_references.week_offset < -99 or new_references.week_offset > 99 Then
124: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
125: IGS_GE_MSG_STACK.ADD;
126: App_Exception.Raise_Exception;
127: End if;
128: End if;
129:

Line 133: IGS_GE_MSG_STACK.ADD;

129:
130: If upper(Column_name)= 'MONTH_OFFSET' Or column_name is null then
131: If new_references.month_offset < -99 or new_references.month_offset > 99 Then
132: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
133: IGS_GE_MSG_STACK.ADD;
134: App_Exception.Raise_Exception;
135: End if;
136: End if;
137:

Line 141: IGS_GE_MSG_STACK.ADD;

137:
138: If upper(Column_name)= 'YEAR_OFFSET' Or column_name is null then
139: If new_references.year_offset < -99 or new_references.year_offset > 99 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:

Line 149: IGS_GE_MSG_STACK.ADD;

145:
146: If upper(Column_name)= 'DT_ALIAS' Or column_name is null then
147: If UPPER(new_references.dt_alias) <> new_references.dt_alias Then
148: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
149: IGS_GE_MSG_STACK.ADD;
150: App_Exception.Raise_Exception;
151: End if;
152: End if;
153:

Line 157: IGS_GE_MSG_STACK.ADD;

153:
154: If upper(Column_name)= 'OFFSET_DT_ALIAS' Or column_name is null then
155: If UPPER(new_references.offset_dt_alias) <> new_references.offset_dt_alias Then
156: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
157: IGS_GE_MSG_STACK.ADD;
158: App_Exception.Raise_Exception;
159: End if;
160: End if;
161:

Line 177: IGS_GE_MSG_STACK.ADD;

173: IF NOT IGS_CA_DA_PKG.Get_PK_For_Validation (
174: new_references.dt_alias
175: ) Then
176: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
177: IGS_GE_MSG_STACK.ADD;
178: app_exception.raise_exception;
179: END IF;
180:
181: END IF;

Line 191: IGS_GE_MSG_STACK.ADD;

187: IF NOT IGS_CA_DA_PKG.Get_PK_For_Validation (
188: new_references.offset_dt_alias
189: ) Then
190: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
191: IGS_GE_MSG_STACK.ADD;
192: app_exception.raise_exception;
193: END IF;
194: END IF;
195:

Line 255: IGS_GE_MSG_STACK.ADD;

251: Fetch cur_rowid INTO lv_rowid;
252: IF (cur_rowid%FOUND) THEN
253: Close cur_rowid;
254: Fnd_Message.Set_Name ('IGS', 'IGS_CA_DAO_DA_FK');
255: IGS_GE_MSG_STACK.ADD;
256: App_Exception.Raise_Exception;
257: Return;
258: END IF;
259: Close cur_rowid;

Line 303: IGS_GE_MSG_STACK.ADD;

299: x_dt_alias ,
300: x_offset_dt_alias
301: ) Then
302: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
303: IGS_GE_MSG_STACK.ADD;
304: app_exception.raise_exception;
305: end if;
306:
307: check_constraints;

Line 327: IGS_GE_MSG_STACK.ADD;

323: x_dt_alias ,
324: x_offset_dt_alias
325: ) Then
326: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
327: IGS_GE_MSG_STACK.ADD;
328: app_exception.raise_exception;
329: end if;
330: check_constraints;
331: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 393: IGS_GE_MSG_STACK.ADD;

389: X_LAST_UPDATE_LOGIN := -1;
390: end if;
391: else
392: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
393: IGS_GE_MSG_STACK.ADD;
394: app_exception.raise_exception;
395: end if;
396: Before_DML (
397: p_action =>'INSERT',

Line 477: IGS_GE_MSG_STACK.ADD;

473: fetch c1 into tlinfo;
474: if (c1%notfound) then
475: close c1;
476: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
477: IGS_GE_MSG_STACK.ADD;
478: app_exception.raise_exception;
479: return;
480: end if;
481: close c1;

Line 499: IGS_GE_MSG_STACK.ADD;

495: ) then
496: null;
497: else
498: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
499: IGS_GE_MSG_STACK.ADD;
500: app_exception.raise_exception;
501: end if;
502: return;
503: end LOCK_ROW;

Line 534: IGS_GE_MSG_STACK.ADD;

530: X_LAST_UPDATE_LOGIN := -1;
531: end if;
532: else
533: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
534: IGS_GE_MSG_STACK.ADD;
535: app_exception.raise_exception;
536: end if;
537: Before_DML (
538: p_action =>'UPDATE',