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

Line 40: IGS_GE_MSG_STACK.ADD;

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

Line 88: IGS_GE_MSG_STACK.ADD;

84: END IF;
85: if upper(column_name) = 'CLOSED_IND' or column_name is null Then
86: if new_references.closed_ind NOT IN ('Y', 'N') Then
87: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
88: IGS_GE_MSG_STACK.ADD;
89: App_Exception.Raise_Exception;
90: end if;
91: end if;
92: if upper(column_name) = 'ABBREVIATION' or column_name is null Then

Line 95: IGS_GE_MSG_STACK.ADD;

91: end if;
92: if upper(column_name) = 'ABBREVIATION' or column_name is null Then
93: if new_references.abbreviation <> UPPER( new_references.abbreviation) then
94: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
95: IGS_GE_MSG_STACK.ADD;
96: App_Exception.Raise_Exception;
97: end if;
98: end if;
99: if upper(column_name) = 'DT_ALIAS' or column_name is null Then

Line 102: IGS_GE_MSG_STACK.ADD;

98: end if;
99: if upper(column_name) = 'DT_ALIAS' or column_name is null Then
100: if new_references.dt_alias <> UPPER( new_references.dt_alias) then
101: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
102: IGS_GE_MSG_STACK.ADD;
103: App_Exception.Raise_Exception;
104: end if;
105: end if;
106: if upper(column_name) = 'DT_CAT' or column_name is null Then

Line 109: IGS_GE_MSG_STACK.ADD;

105: end if;
106: if upper(column_name) = 'DT_CAT' or column_name is null Then
107: if new_references.dt_cat <> UPPER( new_references.dt_cat) then
108: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
109: IGS_GE_MSG_STACK.ADD;
110: App_Exception.Raise_Exception;
111: end if;
112: end if;
113: if upper(column_name) = 'S_CAL_CAT' or column_name is null Then

Line 116: IGS_GE_MSG_STACK.ADD;

112: end if;
113: if upper(column_name) = 'S_CAL_CAT' or column_name is null Then
114: if new_references.s_cal_cat <> UPPER( new_references.s_cal_cat) then
115: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
116: IGS_GE_MSG_STACK.ADD;
117: App_Exception.Raise_Exception;
118: end if;
119: end if;
120:

Line 133: IGS_GE_MSG_STACK.ADD;

129: IF NOT IGS_CA_DA_CAT_PKG.Get_PK_For_Validation (
130: new_references.dt_cat
131: ) THEN
132: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
133: IGS_GE_MSG_STACK.ADD;
134: App_Exception.Raise_Exception;
135: END IF;
136:
137: END IF;

Line 148: IGS_GE_MSG_STACK.ADD;

144: 'CAL_CAT',
145: new_references.s_cal_cat
146: )THEN
147: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
148: IGS_GE_MSG_STACK.ADD;
149: App_Exception.Raise_Exception;
150: END IF;
151:
152: END IF;

Line 262: IGS_GE_MSG_STACK.ADD;

258: Fetch cur_rowid INTO lv_rowid;
259: IF (cur_rowid%FOUND) THEN
260: Close cur_rowid;
261: Fnd_Message.Set_Name ('IGS', 'IGS_CA_DA_DAC_FK');
262: IGS_GE_MSG_STACK.ADD;
263: App_Exception.Raise_Exception;
264: Return;
265: END IF;
266: Close cur_rowid;

Line 318: IGS_GE_MSG_STACK.ADD;

314: -- Call all the procedures related to Before Insert.
315: IF Get_PK_For_Validation (
316: new_references.dt_alias )THEN
317: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
318: IGS_GE_MSG_STACK.ADD;
319: App_Exception.Raise_Exception;
320: END IF;
321: Check_Constraints;
322: Check_Parent_Existance;

Line 327: IGS_GE_MSG_STACK.ADD;

323: ELSIF (p_action = 'VALIDATE_INSERT') THEN
324: IF Get_PK_For_Validation (
325: new_references.dt_alias )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:

Line 379: IGS_GE_MSG_STACK.ADD;

375: X_LAST_UPDATE_LOGIN := -1;
376: end if;
377: else
378: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
379: IGS_GE_MSG_STACK.ADD;
380: app_exception.raise_exception;
381: end if;
382: Before_DML (
383: p_action =>'INSERT',

Line 465: IGS_GE_MSG_STACK.ADD;

461: fetch c1 into tlinfo;
462: if (c1%notfound) then
463: close c1;
464: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
465: IGS_GE_MSG_STACK.ADD;
466: app_exception.raise_exception;
467: return;
468: end if;
469: close c1;

Line 487: IGS_GE_MSG_STACK.ADD;

483: ) then
484: null;
485: else
486: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
487: IGS_GE_MSG_STACK.ADD;
488: app_exception.raise_exception;
489: end if;
490: return;
491: end LOCK_ROW;

Line 523: IGS_GE_MSG_STACK.ADD;

519: X_LAST_UPDATE_LOGIN := -1;
520: end if;
521: else
522: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
523: IGS_GE_MSG_STACK.ADD;
524: app_exception.raise_exception;
525: end if;
526:
527: Before_DML (