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_GRP_PKG dependencies on APP_EXCEPTION

Line 42: App_Exception.Raise_Exception;

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

Line 89: App_Exception.Raise_Exception;

85: new_references.course_group_type,
86: v_message_name) = FALSE THEN
87: Fnd_Message.Set_Name('IGS',v_message_name);
88: IGS_GE_MSG_STACK.ADD;
89: App_Exception.Raise_Exception;
90: END IF;
91: END IF;
92: -- Validate the responsible org IGS_PS_UNIT.
93: IF p_inserting OR

Line 106: App_Exception.Raise_Exception;

102: new_references.responsible_ou_start_dt,
103: v_message_name) = FALSE THEN
104: Fnd_Message.Set_Name('IGS',v_message_name);
105: IGS_GE_MSG_STACK.ADD;
106: App_Exception.Raise_Exception;
107: END IF;
108: END IF;
109:
110:

Line 135: App_Exception.Raise_Exception;

131: column_name is null Then
132: IF ( new_references.closed_ind NOT IN ( 'Y' , 'N' )) Then
133: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
134: IGS_GE_MSG_STACK.ADD;
135: App_Exception.Raise_Exception;
136: END IF;
137: END IF;
138:
139: IF upper(column_name) = 'COURSE_GROUP_CD' OR

Line 144: App_Exception.Raise_Exception;

140: column_name is null Then
141: IF ( new_references.course_group_cd <> UPPER(new_references.course_group_cd) ) 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: END IF;
147:
148: IF upper(column_name) = 'COURSE_GROUP_TYPE' OR

Line 153: App_Exception.Raise_Exception;

149: column_name is null Then
150: IF ( new_references.course_group_type <> UPPER(new_references.course_group_type) ) Then
151: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
152: IGS_GE_MSG_STACK.ADD;
153: App_Exception.Raise_Exception;
154: END IF;
155: END IF;
156:
157: END Check_Constraints;

Line 171: App_Exception.Raise_Exception;

167: new_references.course_group_type
168: ) THEN
169: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
170: IGS_GE_MSG_STACK.ADD;
171: App_Exception.Raise_Exception;
172: END IF;
173: END IF;
174:
175: IF (((old_references.responsible_org_unit_cd = new_references.responsible_org_unit_cd) AND

Line 187: App_Exception.Raise_Exception;

183: new_references.responsible_ou_start_dt
184: ) THEN
185: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
186: IGS_GE_MSG_STACK.ADD;
187: App_Exception.Raise_Exception;
188: END IF;
189: END IF;
190:
191: END Check_Parent_Existance;

Line 240: App_Exception.Raise_Exception;

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

Line 268: App_Exception.Raise_Exception;

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

Line 322: App_Exception.Raise_Exception;

318: IF Get_PK_For_Validation (
319: new_references.course_group_cd) THEN
320: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
321: IGS_GE_MSG_STACK.ADD;
322: App_Exception.Raise_Exception;
323: END IF;
324: Check_Constraints;
325: Check_Parent_Existance;
326: ELSIF (p_action = 'UPDATE') THEN

Line 336: App_Exception.Raise_Exception;

332: IF Get_PK_For_Validation (
333: new_references.course_group_cd) THEN
334: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
335: IGS_GE_MSG_STACK.ADD;
336: App_Exception.Raise_Exception;
337: END IF;
338: Check_Constraints;
339: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
340: Check_Constraints;

Line 389: app_exception.raise_exception;

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',
393: x_rowid => X_ROWID,

Line 477: app_exception.raise_exception;

473: if (c1%notfound) then
474: close c1;
475: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
476: IGS_GE_MSG_STACK.ADD;
477: app_exception.raise_exception;
478: return;
479: end if;
480: close c1;
481:

Line 496: app_exception.raise_exception;

492: null;
493: else
494: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
495: IGS_GE_MSG_STACK.ADD;
496: app_exception.raise_exception;
497: end if;
498: return;
499: end LOCK_ROW;
500:

Line 532: app_exception.raise_exception;

528: end if;
529: else
530: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
531: IGS_GE_MSG_STACK.ADD;
532: app_exception.raise_exception;
533: end if;
534:
535: Before_DML (
536: p_action => 'UPDATE',