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

Line 38: IGS_GE_MSG_STACK.ADD;

34: Open cur_old_ref_values;
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: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
38: IGS_GE_MSG_STACK.ADD;
39: App_Exception.Raise_Exception;
40: Close cur_old_ref_values;
41: Return;
42: END IF;

Line 85: IGS_GE_MSG_STACK.ADD;

81: IF IGS_AD_VAL_ACOS.admp_val_sacoos_clsd(
82: new_references.s_adm_cndtnl_offer_status,
83: v_message_name) = FALSE THEN
84: Fnd_Message.Set_Name('IGS',v_message_name);
85: IGS_GE_MSG_STACK.ADD;
86: App_Exception.Raise_Exception;
87: END IF;
88: END IF;
89: IF (new_references.closed_ind = 'Y' AND new_references.system_default_ind = 'Y') THEN

Line 91: IGS_GE_MSG_STACK.ADD;

87: END IF;
88: END IF;
89: IF (new_references.closed_ind = 'Y' AND new_references.system_default_ind = 'Y') THEN
90: Fnd_Message.Set_Name('IGS','IGS_AD_SYS_DFLT_IND_NOTSET_CLS');
91: IGS_GE_MSG_STACK.ADD;
92: App_Exception.Raise_Exception;
93: END IF;
94:
95:

Line 119: IGS_GE_MSG_STACK.ADD;

115:
116: IF upper(column_name) = 'ADM_CNDTNL_OFFER_STATUS' OR column_name is null Then
117: IF new_references.adm_cndtnl_offer_status<> UPPER(new_references.adm_cndtnl_offer_status) Then
118: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
119: IGS_GE_MSG_STACK.ADD;
120: App_Exception.Raise_Exception;
121: END IF;
122: END IF;
123: IF upper(column_name) = 'CLOSED_IND' OR column_name is null Then

Line 126: IGS_GE_MSG_STACK.ADD;

122: END IF;
123: IF upper(column_name) = 'CLOSED_IND' OR column_name is null Then
124: IF new_references.closed_ind NOT IN ( 'Y' , 'N' ) Then
125: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
126: IGS_GE_MSG_STACK.ADD;
127: App_Exception.Raise_Exception;
128: END IF;
129: END IF;
130: IF upper(column_name) = 'SYSTEM_DEFAULT_IND' OR column_name is null Then

Line 133: IGS_GE_MSG_STACK.ADD;

129: END IF;
130: IF upper(column_name) = 'SYSTEM_DEFAULT_IND' OR column_name is null Then
131: IF new_references.system_default_ind NOT IN ( 'Y' , 'N' ) 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: IF upper(column_name) = 'S_ADM_CNDTNL_OFFER_STATUS' OR column_name is null Then

Line 140: IGS_GE_MSG_STACK.ADD;

136: END IF;
137: IF upper(column_name) = 'S_ADM_CNDTNL_OFFER_STATUS' OR column_name is null Then
138: IF new_references.s_adm_cndtnl_offer_status<> UPPER(new_references.s_adm_cndtnl_offer_status) 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: END Check_Constraints;

Line 157: IGS_GE_MSG_STACK.ADD;

153: IF NOT IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation (
154: 'ADM_CNDTNL_OFFER_STATUS',
155: new_references.s_adm_cndtnl_offer_status ) THEN
156: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
157: IGS_GE_MSG_STACK.ADD;
158: App_Exception.Raise_Exception;
159: END IF;
160: END IF;
161:

Line 214: IGS_GE_MSG_STACK.ADD;

210: Fetch cur_rowid INTO lv_rowid;
211: IF (cur_rowid%FOUND) THEN
212: Close cur_rowid;
213: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACOS_SLV_FK');
214: IGS_GE_MSG_STACK.ADD;
215: App_Exception.Raise_Exception;
216: Return;
217: END IF;
218: Close cur_rowid;

Line 258: IGS_GE_MSG_STACK.ADD;

254: BeforeRowInsertUpdate1 ( p_inserting => TRUE );
255: IF Get_PK_For_Validation (
256: new_references.adm_cndtnl_offer_status ) THEN
257: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
258: IGS_GE_MSG_STACK.ADD;
259: App_Exception.Raise_Exception;
260: END IF;
261: Check_Constraints;
262: Check_Parent_Existance;

Line 275: IGS_GE_MSG_STACK.ADD;

271: ELSIF (p_action = 'VALIDATE_INSERT') THEN
272: IF Get_PK_For_Validation (
273: new_references.adm_cndtnl_offer_status ) THEN
274: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
275: IGS_GE_MSG_STACK.ADD;
276: App_Exception.Raise_Exception;
277: END IF;
278: Check_Constraints;
279: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 326: IGS_GE_MSG_STACK.ADD;

322: X_LAST_UPDATE_LOGIN := -1;
323: end if;
324: else
325: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
326: IGS_GE_MSG_STACK.ADD;
327: app_exception.raise_exception;
328: end if;
329:
330: Before_DML(

Line 405: IGS_GE_MSG_STACK.ADD;

401: open c1;
402: fetch c1 into tlinfo;
403: if (c1%notfound) then
404: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
405: IGS_GE_MSG_STACK.ADD;
406: app_exception.raise_exception;
407: close c1;
408: return;
409: end if;

Line 420: IGS_GE_MSG_STACK.ADD;

416: ) then
417: null;
418: else
419: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
420: IGS_GE_MSG_STACK.ADD;
421: app_exception.raise_exception;
422: end if;
423: return;
424: end LOCK_ROW;

Line 454: IGS_GE_MSG_STACK.ADD;

450: X_LAST_UPDATE_LOGIN := -1;
451: end if;
452: else
453: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
454: IGS_GE_MSG_STACK.ADD;
455: app_exception.raise_exception;
456: end if;
457:
458: Before_DML(