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_OFR_RESP_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 79: IGS_GE_MSG_STACK.ADD;

75: IF IGS_AD_VAL_AORS.admp_val_saors_clsd(
76: new_references.s_adm_offer_resp_status,
77: v_message_name) = FALSE THEN
78: Fnd_Message.Set_Name('IGS',v_message_name);
79: IGS_GE_MSG_STACK.ADD;
80: App_Exception.Raise_Exception;
81: END IF;
82: END IF;
83: IF (new_references.closed_ind = 'Y' AND new_references.system_default_ind = 'Y') THEN

Line 85: IGS_GE_MSG_STACK.ADD;

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

Line 118: IGS_GE_MSG_STACK.ADD;

114:
115: IF upper(Column_name) = 'CLOSED_IND' OR COLUMN_NAME IS NULL THEN
116: IF new_references.CLOSED_IND<> upper(new_references.CLOSED_IND) then
117: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
118: IGS_GE_MSG_STACK.ADD;
119: App_Exception.Raise_Exception ;
120: END IF;
121:
122: IF new_references.CLOSED_IND not in ('Y','N') then

Line 124: IGS_GE_MSG_STACK.ADD;

120: END IF;
121:
122: IF new_references.CLOSED_IND not in ('Y','N') then
123: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
124: IGS_GE_MSG_STACK.ADD;
125: App_Exception.Raise_Exception ;
126: END IF;
127:
128: END IF ;

Line 133: IGS_GE_MSG_STACK.ADD;

129:
130: IF upper(Column_name) = 'ADM_OFFER_RESP_STATUS' OR COLUMN_NAME IS NULL THEN
131: IF new_references.ADM_OFFER_RESP_STATUS<> upper(new_references.ADM_OFFER_RESP_STATUS) 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:
137: END IF ;

Line 143: IGS_GE_MSG_STACK.ADD;

139:
140: IF upper(Column_name) = 'SYSTEM_DEFAULT_IND' OR COLUMN_NAME IS NULL THEN
141: IF new_references.SYSTEM_DEFAULT_IND<> upper(new_references.SYSTEM_DEFAULT_IND) then
142: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
143: IGS_GE_MSG_STACK.ADD;
144: App_Exception.Raise_Exception ;
145: END IF;
146:
147: IF new_references.SYSTEM_DEFAULT_IND not in ('Y','N') then

Line 149: IGS_GE_MSG_STACK.ADD;

145: END IF;
146:
147: IF new_references.SYSTEM_DEFAULT_IND not in ('Y','N') 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:
153: END IF ;

Line 158: IGS_GE_MSG_STACK.ADD;

154:
155: IF upper(Column_name) = 'S_ADM_OFFER_RESP_STATUS' OR COLUMN_NAME IS NULL THEN
156: IF new_references.S_ADM_OFFER_RESP_STATUS<> upper(new_references.S_ADM_OFFER_RESP_STATUS) then
157: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
158: IGS_GE_MSG_STACK.ADD;
159: App_Exception.Raise_Exception ;
160: END IF;
161:
162: END IF ;

Line 177: IGS_GE_MSG_STACK.ADD;

173: IF NOT IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation (
174: 'ADM_OFFER_RESP_STATUS',new_references.s_adm_offer_resp_status
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: END IF;
181:

Line 239: IGS_GE_MSG_STACK.ADD;

235: Fetch cur_rowid INTO lv_rowid;
236: IF (cur_rowid%FOUND) THEN
237: Close cur_rowid;
238: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AORS_SLV_FK');
239: IGS_GE_MSG_STACK.ADD;
240: App_Exception.Raise_Exception;
241: Return;
242: END IF;
243: Close cur_rowid;

Line 285: IGS_GE_MSG_STACK.ADD;

281:
282: IF Get_PK_For_Validation (
283: new_references.adm_offer_resp_status ) THEN
284: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
285: IGS_GE_MSG_STACK.ADD;
286: App_Exception.Raise_Exception;
287: END IF;
288: Check_Constraints;
289: Check_Parent_Existance;

Line 304: IGS_GE_MSG_STACK.ADD;

300: IF Get_PK_For_Validation (
301: new_references.adm_offer_resp_status
302: ) THEN
303: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
304: IGS_GE_MSG_STACK.ADD;
305: App_Exception.Raise_Exception;
306: END IF;
307: Check_Constraints;
308: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 357: IGS_GE_MSG_STACK.ADD;

353: X_LAST_UPDATE_LOGIN := -1;
354: end if;
355: else
356: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
357: IGS_GE_MSG_STACK.ADD;
358: app_exception.raise_exception;
359: end if;
360:
361: Before_DML(

Line 440: IGS_GE_MSG_STACK.ADD;

436: fetch c1 into tlinfo;
437: if (c1%notfound) then
438: close c1;
439: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
440: IGS_GE_MSG_STACK.ADD;
441: app_exception.raise_exception;
442: return;
443: end if;
444: close c1;

Line 454: IGS_GE_MSG_STACK.ADD;

450: ) then
451: null;
452: else
453: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
454: IGS_GE_MSG_STACK.ADD;
455: app_exception.raise_exception;
456: end if;
457: return;
458: end LOCK_ROW;

Line 488: IGS_GE_MSG_STACK.ADD;

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