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

Line 52: App_Exception.Raise_Exception;

48: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
49: Close cur_old_ref_values;
50: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
51: IGS_GE_MSG_STACK.ADD;
52: App_Exception.Raise_Exception;
53: Return;
54: END IF;
55: Close cur_old_ref_values;
56:

Line 103: App_Exception.Raise_Exception;

99: v_attendance_type,
100: v_message_name) = FALSE THEN
101: Fnd_Message.Set_Name ('IGS', v_message_name);
102: IGS_GE_MSG_STACK.ADD;
103: App_Exception.Raise_Exception;
104: END IF;
105: END IF;
106: IF p_inserting OR
107: p_updating OR

Line 116: App_Exception.Raise_Exception;

112: new_references.ca_sequence_number,
113: v_message_name) = FALSE THEN
114: Fnd_Message.Set_Name ('IGS', v_message_name);
115: IGS_GE_MSG_STACK.ADD;
116: App_Exception.Raise_Exception;
117: END IF;
118: END IF;
119: IF p_inserting OR
120: p_updating THEN

Line 135: App_Exception.Raise_Exception;

131: new_references.hist_end_dt,
132: v_message_name) = FALSE THEN
133: Fnd_Message.Set_Name ('IGS', v_message_name);
134: IGS_GE_MSG_STACK.ADD;
135: App_Exception.Raise_Exception;
136: END IF;
137: END IF;
138: END IF;
139: -- Save rowid to validate all IGS_RE_CANDIDATURE attendance histories are continuous

Line 159: App_Exception.Raise_Exception;

155: 'Y', -- validate first history start date
156: v_message_name) = FALSE THEN
157: Fnd_Message.Set_Name ('IGS', v_message_name);
158: IGS_GE_MSG_STACK.ADD;
159: App_Exception.Raise_Exception;
160: END IF;
161: END IF;
162: END IF;
163: END IF;

Line 187: App_Exception.Raise_Exception ;

183: IF upper(column_name) = 'ATTENDANCE_TYPE' OR COLUMN_NAME IS NULL THEN
184: IF new_references.ATTENDANCE_TYPE <> upper(new_references.ATTENDANCE_TYPE) then
185: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
186: IGS_GE_MSG_STACK.ADD;
187: App_Exception.Raise_Exception ;
188: END IF;
189: END IF;
190:
191: IF upper(column_name) = 'CA_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN

Line 195: App_Exception.Raise_Exception ;

191: IF upper(column_name) = 'CA_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
192: IF new_references.CA_SEQUENCE_NUMBER < 1 OR new_references.CA_SEQUENCE_NUMBER > 999999 then
193: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
194: IGS_GE_MSG_STACK.ADD;
195: App_Exception.Raise_Exception ;
196: END IF;
197: END IF;
198:
199: IF upper(column_name) = 'SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN

Line 203: App_Exception.Raise_Exception ;

199: IF upper(column_name) = 'SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
200: IF new_references.SEQUENCE_NUMBER < 1 OR new_references.SEQUENCE_NUMBER > 999999 then
201: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
202: IGS_GE_MSG_STACK.ADD;
203: App_Exception.Raise_Exception ;
204: END IF;
205: END IF;
206:
207: IF upper(column_name) = 'ATTENDANCE_PERCENTAGE' OR COLUMN_NAME IS NULL THEN

Line 211: App_Exception.Raise_Exception ;

207: IF upper(column_name) = 'ATTENDANCE_PERCENTAGE' OR COLUMN_NAME IS NULL THEN
208: IF new_references.ATTENDANCE_PERCENTAGE < 1 OR new_references.ATTENDANCE_PERCENTAGE > 100 then
209: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
210: IGS_GE_MSG_STACK.ADD;
211: App_Exception.Raise_Exception ;
212: END IF;
213: END IF;
214:
215: END Check_Constraints ;

Line 231: App_Exception.Raise_Exception;

227: new_references.attendance_type
228: ) THEN
229: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
230: IGS_GE_MSG_STACK.ADD;
231: App_Exception.Raise_Exception;
232: END IF;
233: END IF;
234:
235: IF (((old_references.person_id = new_references.person_id) AND

Line 247: App_Exception.Raise_Exception;

243: new_references.ca_sequence_number
244: ) THEN
245: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
246: IGS_GE_MSG_STACK.ADD;
247: App_Exception.Raise_Exception;
248: END IF;
249: END IF;
250:
251: END Check_Parent_Existance;

Line 302: App_Exception.Raise_Exception;

298: IF (cur_rowid%FOUND) THEN
299: Close cur_rowid;
300: Fnd_Message.Set_Name ('IGS', 'IGS_RE_CAH_ATT_FK');
301: IGS_GE_MSG_STACK.ADD;
302: App_Exception.Raise_Exception;
303: Return;
304: END IF;
305: Close cur_rowid;
306:

Line 330: App_Exception.Raise_Exception;

326: IF (cur_rowid%FOUND) THEN
327: Close cur_rowid;
328: Fnd_Message.Set_Name ('IGS', 'IGS_RE_CAH_CA_FK');
329: IGS_GE_MSG_STACK.ADD;
330: App_Exception.Raise_Exception;
331: Return;
332: END IF;
333: Close cur_rowid;
334:

Line 385: App_Exception.Raise_Exception;

381: ) THEN
382:
383: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
384: IGS_GE_MSG_STACK.ADD;
385: App_Exception.Raise_Exception;
386: END IF;
387: Check_Constraints;
388: Check_Parent_Existance;
389: ELSIF (p_action = 'UPDATE') THEN

Line 407: App_Exception.Raise_Exception;

403: ) THEN
404:
405: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
406: IGS_GE_MSG_STACK.ADD;
407: App_Exception.Raise_Exception;
408: END IF;
409: Check_Constraints;
410: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
411: Check_Constraints;

Line 451: app_exception.raise_exception;

447: end if;
448: else
449: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
450: IGS_GE_MSG_STACK.ADD;
451: app_exception.raise_exception;
452: end if;
453:
454: Before_DML (
455: p_action => 'INSERT',

Line 524: app_exception.raise_exception;

520: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
521: fnd_message.set_token ('ERR_CD', SQLCODE);
522: igs_ge_msg_stack.add;
523: igs_sc_gen_001.unset_ctx('R');
524: app_exception.raise_exception;
525: ELSE
526: igs_sc_gen_001.unset_ctx('R');
527: RAISE;
528: END IF;

Line 558: app_exception.raise_exception;

554: fetch c1 into tlinfo;
555: if (c1%notfound) then
556: close c1;
557: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
558: app_exception.raise_exception;
559: return;
560: end if;
561: close c1;
562:

Line 571: app_exception.raise_exception;

567: ) then
568: null;
569: else
570: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
571: app_exception.raise_exception;
572: end if;
573: return;
574: end LOCK_ROW;
575:

Line 607: app_exception.raise_exception;

603: end if;
604: else
605: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
606: IGS_GE_MSG_STACK.ADD;
607: app_exception.raise_exception;
608: end if;
609:
610: Before_DML (
611: p_action => 'UPDATE',

Line 644: app_exception.raise_exception;

640: if (sql%notfound) then
641: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
642: igs_ge_msg_stack.add;
643: igs_sc_gen_001.unset_ctx('R');
644: app_exception.raise_exception;
645: end if;
646: IF (x_mode = 'S') THEN
647: igs_sc_gen_001.unset_ctx('R');
648: END IF;

Line 659: app_exception.raise_exception;

655: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
656: fnd_message.set_token ('ERR_CD', SQLCODE);
657: igs_ge_msg_stack.add;
658: igs_sc_gen_001.unset_ctx('R');
659: app_exception.raise_exception;
660: ELSE
661: igs_sc_gen_001.unset_ctx('R');
662: RAISE;
663: END IF;

Line 734: app_exception.raise_exception;

730: if (sql%notfound) then
731: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
732: igs_ge_msg_stack.add;
733: igs_sc_gen_001.unset_ctx('R');
734: app_exception.raise_exception;
735: end if;
736: IF (x_mode = 'S') THEN
737: igs_sc_gen_001.unset_ctx('R');
738: END IF;