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

Line 44: App_Exception.Raise_Exception;

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

Line 90: App_Exception.Raise_Exception;

86: new_references.pue_start_dt,
87: v_message_name ) = FALSE THEN
88: Fnd_Message.Set_Name('IGS', v_message_name);
89: IGS_GE_MSG_STACK.ADD;
90: App_Exception.Raise_Exception;
91: END IF;
92: END IF;
93: -- Validate that start date is not less than the parent IGS_PE_PERSON
94: -- Encumbrance Effect start date.

Line 102: App_Exception.Raise_Exception;

98: new_references.pue_start_dt,
99: v_message_name ) = FALSE THEN
100: Fnd_Message.Set_Name('IGS', v_message_name);
101: IGS_GE_MSG_STACK.ADD;
102: App_Exception.Raise_Exception;
103: END IF;
104: END IF;
105: -- Validate that if expiry date is specified, then expiry date is not
106: -- less than the start date.

Line 118: App_Exception.Raise_Exception;

114: new_references.expiry_dt,
115: v_message_name ) = FALSE THEN
116: Fnd_Message.Set_Name('IGS', v_message_name);
117: IGS_GE_MSG_STACK.ADD;
118: App_Exception.Raise_Exception;
119: END IF;
120: IF IGS_EN_VAL_PCE.enrp_val_encmb_dt (
121: new_references.expiry_dt,
122: v_message_name ) = FALSE THEN

Line 125: App_Exception.Raise_Exception;

121: new_references.expiry_dt,
122: v_message_name ) = FALSE THEN
123: Fnd_Message.Set_Name('IGS', v_message_name);
124: IGS_GE_MSG_STACK.ADD;
125: App_Exception.Raise_Exception;
126: END IF;
127: END IF;
128: -- Validate that records for this table can be created for the encumbrance
129: -- effect type.

Line 137: App_Exception.Raise_Exception;

133: 'IGS_PE_PERS_UNT_EXCL',
134: v_message_name ) = FALSE THEN
135: Fnd_Message.Set_Name('IGS', v_message_name);
136: IGS_GE_MSG_STACK.ADD;
137: App_Exception.Raise_Exception;
138: END IF;
139: END IF;
140: -- Validate if IGS_PE_PERSON is enrolled in the IGS_PS_UNIT which is to be excluded. If so,
141: -- raise an error as this is not allowable.

Line 150: App_Exception.Raise_Exception;

146: null,
147: v_message_name ) = FALSE THEN
148: Fnd_Message.Set_Name('IGS', v_message_name);
149: IGS_GE_MSG_STACK.ADD;
150: App_Exception.Raise_Exception;
151: END IF;
152: END IF;
153:
154:

Line 186: App_Exception.Raise_Exception;

182: new_references.pue_start_dt,
183: v_message_name) = FALSE THEN
184: Fnd_Message.Set_Name('IGS', v_message_name);
185: IGS_GE_MSG_STACK.ADD;
186: App_Exception.Raise_Exception;
187: END IF;
188: END IF;
189:
190: END IF;

Line 223: App_Exception.Raise_Exception;

219: column_name is null Then
220: IF new_references.encumbrance_type <>UPPER(new_references.encumbrance_type)Then
221: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
222: IGS_GE_MSG_STACK.ADD;
223: App_Exception.Raise_Exception;
224: END IF;
225: END IF;
226: IF upper(column_name) = 'S_ENCMB_EFFECT_TYPE' OR
227: column_name is null Then

Line 231: App_Exception.Raise_Exception;

227: column_name is null Then
228: IF new_references.s_encmb_effect_type <>UPPER(new_references.s_encmb_effect_type)Then
229: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
230: IGS_GE_MSG_STACK.ADD;
231: App_Exception.Raise_Exception;
232: END IF;
233: END IF;
234: IF upper(column_name) = 'UNIT_CD' OR
235: column_name is null Then

Line 239: App_Exception.Raise_Exception;

235: column_name is null Then
236: IF new_references.unit_cd <>UPPER(new_references.unit_cd)Then
237: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
238: IGS_GE_MSG_STACK.ADD;
239: App_Exception.Raise_Exception;
240: END IF;
241: END IF;
242:
243: END Check_Constraints;

Line 271: App_Exception.Raise_Exception;

267: new_references.pee_start_dt,
268: new_references.pee_sequence_number ) THEN
269: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
270: IGS_GE_MSG_STACK.ADD;
271: App_Exception.Raise_Exception;
272: END IF;
273: END IF;
274:
275: IF (((old_references.unit_cd = new_references.unit_cd)) OR

Line 283: App_Exception.Raise_Exception;

279: IF NOT IGS_PS_UNIT_PKG.Get_PK_For_Validation (
280: new_references.unit_cd) THEN
281: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
282: IGS_GE_MSG_STACK.ADD;
283: App_Exception.Raise_Exception;
284: END IF;
285: END IF;
286:
287: END Check_Parent_Existance;

Line 358: App_Exception.Raise_Exception;

354: IF (cur_rowid%FOUND) THEN
355: Fnd_Message.Set_Name ('IGS', 'IGS_PE_PUE_PEE_FK');
356: IGS_GE_MSG_STACK.ADD;
357: Close cur_rowid;
358: App_Exception.Raise_Exception;
359: Return;
360: END IF;
361: Close cur_rowid;
362:

Line 384: App_Exception.Raise_Exception;

380: IF (cur_rowid%FOUND) THEN
381: Fnd_Message.Set_Name ('IGS', 'IGS_PE_PUE_UN_FK');
382: IGS_GE_MSG_STACK.ADD;
383: Close cur_rowid;
384: App_Exception.Raise_Exception;
385: Return;
386: END IF;
387: Close cur_rowid;
388:

Line 445: App_Exception.Raise_Exception;

441: NEW_REFERENCES.pue_start_dt
442: ) THEN
443: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
444: IGS_GE_MSG_STACK.ADD;
445: App_Exception.Raise_Exception;
446: END IF;
447:
448: Check_Constraints; -- if procedure present
449: Check_Parent_Existance; -- if procedure present

Line 473: App_Exception.Raise_Exception;

469: NEW_REFERENCES.unit_cd ,
470: NEW_REFERENCES.pue_start_dt) THEN
471: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
472: IGS_GE_MSG_STACK.ADD;
473: App_Exception.Raise_Exception;
474: END IF;
475:
476: Check_Constraints; -- if procedure present
477: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 552: app_exception.raise_exception;

548: end if;
549: else
550: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
551: IGS_GE_MSG_STACK.ADD;
552: app_exception.raise_exception;
553: end if;
554: Before_DML(
555: p_action=>'INSERT',
556: x_rowid=>X_ROWID,

Line 644: App_Exception.Raise_Exception;

640: if (c1%notfound) then
641: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
642:
643: close c1;
644: App_Exception.Raise_Exception;
645: return;
646: end if;
647: close c1;
648:

Line 656: app_exception.raise_exception;

652: ) then
653: null;
654: else
655: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
656: app_exception.raise_exception;
657: end if;
658: return;
659: end LOCK_ROW;
660:

Line 694: app_exception.raise_exception;

690: end if;
691: else
692: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
693: IGS_GE_MSG_STACK.ADD;
694: app_exception.raise_exception;
695: end if;
696: Before_DML(
697: p_action=>'UPDATE',
698: x_rowid=>X_ROWID,