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

Line 49: app_exception.raise_exception;

45: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
46: CLOSE cur_old_ref_values;
47: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
48: igs_ge_msg_stack.add;
49: app_exception.raise_exception;
50: RETURN;
51: END IF;
52: CLOSE cur_old_ref_values;
53:

Line 121: APP_EXCEPTION.RAISE_EXCEPTION;

117:
118: IF l_count > 0 THEN
119: FND_MESSAGE.SET_NAME('IGS','IGS_GE_TIME_OVERLAP');
120: IGS_GE_MSG_STACK.ADD;
121: APP_EXCEPTION.RAISE_EXCEPTION;
122: END IF;
123:
124: CLOSE c_overlap;
125:

Line 158: APP_EXCEPTION.RAISE_EXCEPTION;

154:
155: IF to_char(new_references.start_tm_date,'HH24:MI') >= to_char(new_references.end_tm_date,'HH24:MI') THEN
156: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_ST_TIME_LT_END_TIME');
157: IGS_GE_MSG_STACK.ADD;
158: APP_EXCEPTION.RAISE_EXCEPTION;
159: END IF;
160:
161: END IF;
162:

Line 227: APP_EXCEPTION.RAISE_EXCEPTION;

223: IF check_cont_pref_cur%NOTFOUND THEN
224: CLOSE check_cont_pref_cur;
225: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
226: IGS_GE_MSG_STACK.ADD;
227: APP_EXCEPTION.RAISE_EXCEPTION;
228: END IF;
229: CLOSE check_cont_pref_cur;
230: END IF;
231:

Line 294: app_exception.raise_exception;

290: IF ( get_pk_for_validation( new_references.office_hrs_id )
291: ) THEN
292: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
293: igs_ge_msg_stack.add;
294: app_exception.raise_exception;
295: END IF;
296: -- check valid cont pref
297: Check_Parent_Existance;
298:

Line 312: app_exception.raise_exception;

308: IF ( get_pk_for_validation( new_references.office_hrs_id )
309: ) THEN
310: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
311: igs_ge_msg_stack.add;
312: app_exception.raise_exception;
313: END IF;
314:
315: ELSIF (p_action = 'UPDATE') THEN
316:

Line 389: app_exception.raise_exception;

385: ELSE
386: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
387: fnd_message.set_token ('ROUTINE', 'IGS_PE_OFFICE_HRS_PKG.INSERT_ROW');
388: igs_ge_msg_stack.add;
389: app_exception.raise_exception;
390: END IF;
391:
392: x_office_hrs_id := NULL;
393:

Line 451: app_exception.raise_exception;

447: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
448: fnd_message.set_token ('ERR_CD', SQLCODE);
449: igs_ge_msg_stack.add;
450: igs_sc_gen_001.unset_ctx('R');
451: app_exception.raise_exception;
452: ELSE
453: igs_sc_gen_001.unset_ctx('R');
454: RAISE;
455: END IF;

Line 497: app_exception.raise_exception;

493: IF (c1%notfound) THEN
494: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
495: igs_ge_msg_stack.add;
496: CLOSE c1;
497: app_exception.raise_exception;
498: RETURN;
499: END IF;
500: CLOSE c1;
501:

Line 513: app_exception.raise_exception;

509: NULL;
510: ELSE
511: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
512: igs_ge_msg_stack.add;
513: app_exception.raise_exception;
514: END IF;
515:
516: RETURN;
517:

Line 562: app_exception.raise_exception;

558: ELSE
559: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
560: fnd_message.set_token ('ROUTINE', 'IGS_PE_OFFICE_HRS_PKG.UPDATE_ROW');
561: igs_ge_msg_stack.add;
562: app_exception.raise_exception;
563: END IF;
564:
565: -- x_office_hrs_id := NULL;
566:

Line 601: app_exception.raise_exception;

597: IF (SQL%NOTFOUND) THEN
598: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
599: igs_ge_msg_stack.add;
600: igs_sc_gen_001.unset_ctx('R');
601: app_exception.raise_exception;
602: END IF;
603: IF (x_mode = 'S') THEN
604: igs_sc_gen_001.unset_ctx('R');
605: END IF;

Line 617: app_exception.raise_exception;

613: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
614: fnd_message.set_token ('ERR_CD', SQLCODE);
615: igs_ge_msg_stack.add;
616: igs_sc_gen_001.unset_ctx('R');
617: app_exception.raise_exception;
618: ELSE
619: igs_sc_gen_001.unset_ctx('R');
620: RAISE;
621: END IF;

Line 711: app_exception.raise_exception;

707: IF (SQL%NOTFOUND) THEN
708: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
709: igs_ge_msg_stack.add;
710: igs_sc_gen_001.unset_ctx('R');
711: app_exception.raise_exception;
712: END IF;
713: IF (x_mode = 'S') THEN
714: igs_sc_gen_001.unset_ctx('R');
715: END IF;

Line 843: app_exception.raise_exception;

839: IF (c1%notfound) THEN
840: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
841: igs_ge_msg_stack.add;
842: CLOSE c1;
843: app_exception.raise_exception;
844: RETURN;
845: END IF;
846: CLOSE c1;
847:

Line 859: app_exception.raise_exception;

855: NULL;
856: ELSE
857: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
858: igs_ge_msg_stack.add;
859: app_exception.raise_exception;
860: END IF;
861:
862: RETURN;
863: