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_AD_ADM_UNIT_STAT_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 80: IGS_GE_MSG_STACK.ADD;

76: IF new_references.unit_attempt_status <> 'DISCONTIN' THEN
77: IF IGS_EN_VAL_AUS.ENRP_VAL_AUS_AUSG(new_references.administrative_unit_status
78: ,v_message_name) = FALSE THEN
79: Fnd_Message.Set_Name('IGS',v_message_name);
80: IGS_GE_MSG_STACK.ADD;
81: App_Exception.Raise_Exception;
82: END IF;
83: END IF;
84: END IF;

Line 99: IGS_GE_MSG_STACK.ADD;

95: ELSE
96: IF NOT IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation (
97: 'UNIT_ATTEMPT_STATUS', new_references.unit_attempt_status ) THEN
98: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
99: IGS_GE_MSG_STACK.ADD;
100: App_Exception.Raise_Exception;
101: END IF;
102: END IF;
103:

Line 132: IGS_GE_MSG_STACK.ADD;

128: IF upper(column_name) = 'EFFECTIVE_PROGRESSION_IND' OR
129: column_name IS NULL THEN
130: IF new_references.effective_progression_ind NOT IN ( 'Y' , 'N' ) THEN
131: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
132: IGS_GE_MSG_STACK.ADD;
133: App_Exception.Raise_Exception;
134: END IF;
135: END IF;
136: IF upper(column_name) = 'CLOSED_IND' OR

Line 140: IGS_GE_MSG_STACK.ADD;

136: IF upper(column_name) = 'CLOSED_IND' OR
137: column_name IS NULL THEN
138: IF new_references.closed_ind NOT IN ( 'Y' , 'N' ) THEN
139: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
140: IGS_GE_MSG_STACK.ADD;
141: App_Exception.Raise_Exception;
142: END IF;
143: END IF;
144: IF upper(column_name) = 'ADMINISTRATIVE_UNIT_STATUS' OR

Line 148: IGS_GE_MSG_STACK.ADD;

144: IF upper(column_name) = 'ADMINISTRATIVE_UNIT_STATUS' OR
145: column_name IS NULL THEN
146: IF new_references.administrative_unit_status <> UPPER(new_references.administrative_unit_status) 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:

Line 157: IGS_GE_MSG_STACK.ADD;

153: IF upper(column_name) = 'EFFECTIVE_TIME_ELAPSED_IND' OR
154: column_name IS NULL THEN
155: IF new_references.effective_time_elapsed_ind NOT IN ( 'Y' , 'N' ) 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: IF upper(column_Name) = 'SHOW_ON_OFFIC_NTFCTN_IND' OR

Line 165: IGS_GE_MSG_STACK.ADD;

161: IF upper(column_Name) = 'SHOW_ON_OFFIC_NTFCTN_IND' OR
162: column_name IS NULL THEN
163: IF new_references.show_on_offic_ntfctn_ind NOT IN ( 'Y' , 'N' ) THEN
164: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
165: IGS_GE_MSG_STACK.ADD;
166: App_Exception.Raise_Exception;
167: END IF;
168: END IF;
169: IF upper(Column_Name) = 'UNIT_ATTEMPT_STATUS' OR

Line 173: IGS_GE_MSG_STACK.ADD;

169: IF upper(Column_Name) = 'UNIT_ATTEMPT_STATUS' OR
170: column_name IS NULL THEN
171: IF new_references.unit_attempt_status <> upper(new_references.unit_attempt_status) THEN
172: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
173: IGS_GE_MSG_STACK.ADD;
174: App_Exception.Raise_Exception;
175: END IF;
176: END IF;
177:

Line 227: IGS_GE_MSG_STACK.ADD;

223: Fetch cur_rowid INTO lv_rowid;
224: IF (cur_rowid%FOUND) THEN
225: Close cur_rowid;
226: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AUS_LKUPV_FK');
227: IGS_GE_MSG_STACK.ADD;
228: App_Exception.Raise_Exception;
229: Return;
230: END IF;
231: Close cur_rowid;

Line 277: IGS_GE_MSG_STACK.ADD;

273: -- Call all the procedures related to Before Insert.
274: BeforeRowInsertUpdate1 ( p_inserting => TRUE );
275: IF Get_PK_For_Validation (new_references.administrative_unit_status ) THEN
276: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
277: IGS_GE_MSG_STACK.ADD;
278: App_Exception.Raise_Exception;
279: END IF;
280: Check_Constraints ;
281: Check_Parent_Existance;

Line 290: IGS_GE_MSG_STACK.ADD;

286: Check_Parent_Existance;
287: ELSIF (p_action = 'VALIDATE_INSERT') THEN
288: IF Get_PK_For_Validation (new_references.administrative_unit_status ) THEN
289: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
290: IGS_GE_MSG_STACK.ADD;
291: App_Exception.Raise_Exception;
292: END IF;
293: Check_Constraints ;
294: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 342: IGS_GE_MSG_STACK.ADD;

338: X_LAST_UPDATE_LOGIN := -1;
339: end if;
340: else
341: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
342: IGS_GE_MSG_STACK.ADD;
343: app_exception.raise_exception;
344: end if;
345:
346: Before_DML (

Line 485: IGS_GE_MSG_STACK.ADD;

481: X_LAST_UPDATE_LOGIN := -1;
482: end if;
483: else
484: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
485: IGS_GE_MSG_STACK.ADD;
486: app_exception.raise_exception;
487: end if;
488:
489: Before_DML (