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

Line 41: App_Exception.Raise_Exception;

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

Line 87: App_Exception.Raise_Exception;

83: new_references.prg_cal_type,
84: v_message_name) = FALSE THEN
85: Fnd_Message.Set_Name('IGS',v_message_name);
86: IGS_GE_MSG_STACK.ADD;
87: App_Exception.Raise_Exception;
88: END IF;
89: END IF;
90: -- Validate the show cause length
91: IF p_inserting OR (p_updating AND

Line 100: App_Exception.Raise_Exception;

96: new_references.show_cause_length,
97: v_message_name) = FALSE THEN
98: Fnd_Message.Set_Name('IGS',v_message_name);
99: IGS_GE_MSG_STACK.ADD;
100: App_Exception.Raise_Exception;
101: END IF;
102: END IF;
103: -- Validate the appeal length
104: IF p_inserting OR (p_updating AND

Line 113: App_Exception.Raise_Exception;

109: new_references.appeal_length,
110: v_message_name) = FALSE THEN
111: Fnd_Message.Set_Name('IGS',v_message_name);
112: IGS_GE_MSG_STACK.ADD;
113: App_Exception.Raise_Exception;
114: END IF;
115: END IF;
116:
117:

Line 133: App_Exception.Raise_Exception;

129: new_references.prg_cal_type
130: ) THEN
131: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
132: IGS_GE_MSG_STACK.ADD;
133: App_Exception.Raise_Exception;
134: END IF;
135: END IF;
136:
137: IF (((old_references.org_unit_cd = new_references.org_unit_cd) AND

Line 149: App_Exception.Raise_Exception;

145: new_references.ou_start_dt
146: ) THEN
147: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
148: IGS_GE_MSG_STACK.ADD;
149: App_Exception.Raise_Exception;
150: END IF;
151: END IF;
152:
153: END Check_Parent_Existance;

Line 204: App_Exception.Raise_Exception;

200: IF (cur_rowid%FOUND) THEN
201: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SOPCA_CAT_FK');
202: IGS_GE_MSG_STACK.ADD;
203: Close cur_rowid;
204: App_Exception.Raise_Exception;
205:
206: Return;
207: END IF;
208: Close cur_rowid;

Line 233: App_Exception.Raise_Exception;

229: IF (cur_rowid%FOUND) THEN
230: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SOPCA_SOPC_FK');
231: IGS_GE_MSG_STACK.ADD;
232: Close cur_rowid;
233: App_Exception.Raise_Exception;
234:
235: Return;
236: END IF;
237: Close cur_rowid;

Line 284: App_Exception.Raise_Exception;

280: new_references.prg_cal_type
281: ) THEN
282: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
283: IGS_GE_MSG_STACK.ADD;
284: App_Exception.Raise_Exception;
285: END IF;
286: Check_Constraints;
287: Check_Parent_Existance;
288: ELSIF (p_action = 'UPDATE') THEN

Line 302: App_Exception.Raise_Exception;

298: new_references.prg_cal_type
299: ) THEN
300: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
301: IGS_GE_MSG_STACK.ADD;
302: App_Exception.Raise_Exception;
303: END IF;
304: Check_Constraints;
305: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
306: -- Call all the procedures related to Before Update.

Line 346: app_exception.raise_exception;

342: end if;
343: else
344: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
345: IGS_GE_MSG_STACK.ADD;
346: app_exception.raise_exception;
347: end if;
348:
349: Before_DML(
350: p_action => 'INSERT',

Line 427: app_exception.raise_exception;

423: if (c1%notfound) then
424: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
425: IGS_GE_MSG_STACK.ADD;
426: close c1;
427: app_exception.raise_exception;
428:
429: return;
430: end if;
431: close c1;

Line 445: app_exception.raise_exception;

441: null;
442: else
443: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
444: IGS_GE_MSG_STACK.ADD;
445: app_exception.raise_exception;
446: end if;
447: return;
448: end LOCK_ROW;
449:

Line 480: app_exception.raise_exception;

476: end if;
477: else
478: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
479: IGS_GE_MSG_STACK.ADD;
480: app_exception.raise_exception;
481: end if;
482:
483: Before_DML(
484: p_action => 'UPDATE',

Line 599: App_Exception.Raise_Exception;

595: IF TO_NUMBER(new_references.SHOW_CAUSE_LENGTH) < 0 OR
596: TO_NUMBER(new_references.SHOW_CAUSE_LENGTH) > 999 THEN
597: Fnd_Message.Set_Name('IGS','IGS_INDVALID_VALUE');
598: IGS_GE_MSG_STACK.ADD;
599: App_Exception.Raise_Exception;
600: END IF;
601: END IF;
602:
603: IF upper(column_name) = 'APPEAL_LENGTH' OR

Line 609: App_Exception.Raise_Exception;

605: IF TO_NUMBER(new_references.APPEAL_LENGTH) < 0 OR
606: TO_NUMBER(new_references.APPEAL_LENGTH) > 999 THEN
607: Fnd_Message.Set_Name('IGS','IGS_INVALID_VALUE');
608: IGS_GE_MSG_STACK.ADD;
609: App_Exception.Raise_Exception;
610: END IF;
611: END IF;
612:
613: IF upper(column_name) = 'PRG_CAL_TYPE' OR

Line 618: App_Exception.Raise_Exception;

614: column_name is NULL THEN
615: IF new_references.PRG_CAL_TYPE <> UPPER(new_references.PRG_CAL_TYPE) THEN
616: Fnd_Message.Set_Name('IGS','IGS_INVALID_VALUE');
617: IGS_GE_MSG_STACK.ADD;
618: App_Exception.Raise_Exception;
619: END IF;
620: END IF;
621:
622: END Check_Constraints;