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_PS_OFR_NOTE_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 85: IGS_GE_MSG_STACK.ADD;

81: IF upper(column_name) = 'CAL_TYPE' OR
82: column_name is null Then
83: IF ( new_references.cal_type <> UPPER(new_references.cal_type) ) Then
84: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
85: IGS_GE_MSG_STACK.ADD;
86: App_Exception.Raise_Exception;
87: END IF;
88: END IF;
89:

Line 94: IGS_GE_MSG_STACK.ADD;

90: IF upper(column_name) = 'COURSE_CD' OR
91: column_name is null Then
92: IF ( new_references.course_cd <> UPPER(new_references.course_cd) ) Then
93: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
94: IGS_GE_MSG_STACK.ADD;
95: App_Exception.Raise_Exception;
96: END IF;
97: END IF;
98:

Line 103: IGS_GE_MSG_STACK.ADD;

99: IF upper(column_name) = 'CRS_NOTE_TYPE' OR
100: column_name is null Then
101: IF ( new_references.crs_note_type <> UPPER(new_references.crs_note_type) ) Then
102: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
103: IGS_GE_MSG_STACK.ADD;
104: App_Exception.Raise_Exception;
105: END IF;
106: END IF;
107:

Line 121: IGS_GE_MSG_STACK.ADD;

117: IF NOT IGS_PS_NOTE_TYPE_PKG.Get_PK_For_Validation (
118: new_references.crs_note_type
119: ) THEN
120: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
121: IGS_GE_MSG_STACK.ADD;
122: App_Exception.Raise_Exception;
123: END IF;
124: END IF;
125:

Line 140: IGS_GE_MSG_STACK.ADD;

136: new_references.version_number,
137: new_references.cal_type
138: ) THEN
139: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
140: IGS_GE_MSG_STACK.ADD;
141: App_Exception.Raise_Exception;
142: END IF;
143: END IF;
144:

Line 153: IGS_GE_MSG_STACK.ADD;

149: IF NOT IGS_GE_NOTE_PKG.Get_PK_For_Validation (
150: new_references.reference_number
151: ) THEN
152: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
153: IGS_GE_MSG_STACK.ADD;
154: App_Exception.Raise_Exception;
155: END IF;
156: END IF;
157:

Line 211: IGS_GE_MSG_STACK.ADD;

207: Fetch cur_rowid INTO lv_rowid;
208: IF (cur_rowid%FOUND) THEN
209: Close cur_rowid;
210: Fnd_Message.Set_Name ('IGS', 'IGS_PS_CON_CNT_FK');
211: IGS_GE_MSG_STACK.ADD;
212: App_Exception.Raise_Exception;
213: Return;
214: END IF;
215: Close cur_rowid;

Line 241: IGS_GE_MSG_STACK.ADD;

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

Line 267: IGS_GE_MSG_STACK.ADD;

263: Fetch cur_rowid INTO lv_rowid;
264: IF (cur_rowid%FOUND) THEN
265: Close cur_rowid;
266: Fnd_Message.Set_Name ('IGS', 'IGS_PS_CON_NOTE_FK');
267: IGS_GE_MSG_STACK.ADD;
268: App_Exception.Raise_Exception;
269: Return;
270: END IF;
271: Close cur_rowid;

Line 314: IGS_GE_MSG_STACK.ADD;

310: new_references.version_number,
311: new_references.cal_type,
312: new_references.reference_number ) THEN
313: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
314: IGS_GE_MSG_STACK.ADD;
315: App_Exception.Raise_Exception;
316: END IF;
317: Check_Constraints;
318: Check_Parent_Existance;

Line 334: IGS_GE_MSG_STACK.ADD;

330: new_references.version_number,
331: new_references.cal_type,
332: new_references.reference_number ) THEN
333: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
334: IGS_GE_MSG_STACK.ADD;
335: App_Exception.Raise_Exception;
336: END IF;
337: Check_Constraints;
338: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 388: IGS_GE_MSG_STACK.ADD;

384: X_LAST_UPDATE_LOGIN := -1;
385: end if;
386: else
387: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
388: IGS_GE_MSG_STACK.ADD;
389: app_exception.raise_exception;
390: end if;
391: Before_DML (
392: p_action => 'INSERT',

Line 464: IGS_GE_MSG_STACK.ADD;

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

Line 475: IGS_GE_MSG_STACK.ADD;

471: ) then
472: null;
473: else
474: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
475: IGS_GE_MSG_STACK.ADD;
476: app_exception.raise_exception;
477: end if;
478: return;
479: end LOCK_ROW;

Line 509: IGS_GE_MSG_STACK.ADD;

505: X_LAST_UPDATE_LOGIN := -1;
506: end if;
507: else
508: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
509: IGS_GE_MSG_STACK.ADD;
510: app_exception.raise_exception;
511: end if;
512: Before_DML (
513: p_action => 'UPDATE',