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 IGS_GE_MSG_STACK

Line 48: igs_ge_msg_stack.add;

44: FETCH cur_old_ref_values INTO old_references;
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;

Line 120: IGS_GE_MSG_STACK.ADD;

116: FETCH c_overlap INTO l_count;
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;

Line 157: IGS_GE_MSG_STACK.ADD;

153: (new_references.end_tm_date <> NVL(old_references.end_tm_date,IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN
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;

Line 226: IGS_GE_MSG_STACK.ADD;

222: FETCH check_cont_pref_cur into l_var;
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;

Line 293: igs_ge_msg_stack.add;

289:
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;

Line 311: igs_ge_msg_stack.add;

307: -- Call all the procedures related to Before Insert.
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

Line 388: igs_ge_msg_stack.add;

384: END IF;
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;

Line 449: igs_ge_msg_stack.add;

445: WHEN OTHERS THEN
446: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
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');

Line 495: igs_ge_msg_stack.add;

491: OPEN c1;
492: FETCH c1 INTO tlinfo;
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;

Line 512: igs_ge_msg_stack.add;

508: ) THEN
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;

Line 561: igs_ge_msg_stack.add;

557: END IF;
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;

Line 599: igs_ge_msg_stack.add;

595: WHERE rowid = x_rowid;
596:
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

Line 615: igs_ge_msg_stack.add;

611: WHEN OTHERS THEN
612: IF (SQLCODE = (-28115)) THEN
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');

Line 709: igs_ge_msg_stack.add;

705: WHERE rowid = x_rowid;
706:
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

Line 841: igs_ge_msg_stack.add;

837: OPEN c1;
838: FETCH c1 INTO tlinfo;
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;

Line 858: igs_ge_msg_stack.add;

854: ) THEN
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;