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

Line 57: App_Exception.Raise_Exception;

53: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN( 'INSERT','VALIDATE_INSERT' )) THEN
54: Close cur_old_ref_values;
55: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
56: IGS_GE_MSG_STACK.ADD;
57: App_Exception.Raise_Exception;
58: Return;
59: END IF;
60: Close cur_old_ref_values;
61:

Line 145: App_Exception.Raise_Exception;

141: Column_name is null THEN
142: IF new_references.s_control_num NOT IN ( 1 ) THEN
143: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
144: IGS_GE_MSG_STACK.ADD;
145: App_Exception.Raise_Exception;
146: END IF;
147: END IF;
148:
149: IF upper(column_name) = 'COMMENCEMENT_DT_ALIAS' OR

Line 155: App_Exception.Raise_Exception;

151: IF new_references.commencement_dt_alias <>
152: upper(new_references.commencement_dt_alias) THEN
153: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
154: IGS_GE_MSG_STACK.ADD;
155: App_Exception.Raise_Exception;
156: END IF;
157: END IF;
158:
159: IF upper(column_name) = 'COMMENCE_CUTOFF_DT_ALIAS' OR

Line 165: App_Exception.Raise_Exception;

161: IF new_references.commence_cutoff_dt_alias <>
162: upper(new_references.commence_cutoff_dt_alias) THEN
163: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
164: IGS_GE_MSG_STACK.ADD;
165: App_Exception.Raise_Exception;
166: END IF;
167: END IF;
168:
169: IF upper(column_name) = 'EFFECT_ENR_STRT_DT_ALIAS' OR

Line 175: App_Exception.Raise_Exception;

171: IF new_references.effect_enr_strt_dt_alias <>
172: upper(new_references.effect_enr_strt_dt_alias) THEN
173: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
174: IGS_GE_MSG_STACK.ADD;
175: App_Exception.Raise_Exception;
176: END IF;
177: END IF;
178:
179: IF upper(column_name) = 'ENROLLED_RULE_CUTOFF_DT_ALIAS' OR

Line 185: App_Exception.Raise_Exception;

181: IF new_references.enrolled_rule_cutoff_dt_alias <>
182: upper(new_references.enrolled_rule_cutoff_dt_alias) THEN
183: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
184: IGS_GE_MSG_STACK.ADD;
185: App_Exception.Raise_Exception;
186: END IF;
187: END IF;
188: IF upper(column_name) = 'ENR_CLEANUP_DT_ALIAS' OR
189: Column_name is null THEN

Line 194: App_Exception.Raise_Exception;

190: IF new_references.enr_cleanup_dt_alias <>
191: upper(new_references.enr_cleanup_dt_alias) THEN
192: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
193: IGS_GE_MSG_STACK.ADD;
194: App_Exception.Raise_Exception;
195: END IF;
196: END IF;
197:
198: IF upper(column_name) = 'ENR_FORM_DUE_DT_ALIAS' OR

Line 204: App_Exception.Raise_Exception;

200: IF new_references.enr_form_due_dt_alias <>
201: upper(new_references.enr_form_due_dt_alias) THEN
202: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
203: IGS_GE_MSG_STACK.ADD;
204: App_Exception.Raise_Exception;
205: END IF;
206: END IF;
207:
208: IF upper(column_name) = 'ENR_PCKG_PROD_DT_ALIAS' OR

Line 214: App_Exception.Raise_Exception;

210: IF new_references.enr_pckg_prod_dt_alias <>
211: upper(new_references.enr_pckg_prod_dt_alias) THEN
212: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
213: IGS_GE_MSG_STACK.ADD;
214: App_Exception.Raise_Exception;
215: END IF;
216: END IF;
217:
218: IF upper(column_name) = 'INVALID_RULE_CUTOFF_DT_ALIAS' OR

Line 224: App_Exception.Raise_Exception;

220: IF new_references.invalid_rule_cutoff_dt_alias <>
221: upper(new_references.invalid_rule_cutoff_dt_alias) THEN
222: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
223: IGS_GE_MSG_STACK.ADD;
224: App_Exception.Raise_Exception;
225: END IF;
226: END IF;
227:
228: IF upper(column_name) = 'LAPSE_DT_ALIAS' OR

Line 234: App_Exception.Raise_Exception;

230: IF new_references.lapse_dt_alias <>
231: upper(new_references.lapse_dt_alias) THEN
232: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
233: IGS_GE_MSG_STACK.ADD;
234: App_Exception.Raise_Exception;
235: END IF;
236: END IF;
237:
238: IF upper(column_name) = 'LOAD_EFFECT_DT_ALIAS' OR

Line 244: App_Exception.Raise_Exception;

240: IF new_references.load_effect_dt_alias <>
241: upper(new_references.load_effect_dt_alias) THEN
242: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
243: IGS_GE_MSG_STACK.ADD;
244: App_Exception.Raise_Exception;
245: END IF;
246: END IF;
247:
248: IF upper(column_name) = 'RECORD_CUTOFF_DT_ALIAS' OR

Line 254: App_Exception.Raise_Exception;

250: IF new_references.record_cutoff_dt_alias <>
251: upper(new_references.record_cutoff_dt_alias) THEN
252: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
253: IGS_GE_MSG_STACK.ADD;
254: App_Exception.Raise_Exception;
255: END IF;
256: END IF;
257:
258: IF upper(column_name) = 'RECORD_OPEN_DT_ALIAS' OR

Line 264: App_Exception.Raise_Exception;

260: IF new_references.record_open_dt_alias <>
261: upper(new_references.record_open_dt_alias) THEN
262: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
263: IGS_GE_MSG_STACK.ADD;
264: App_Exception.Raise_Exception;
265: END IF;
266: END IF;
267:
268: IF upper(column_name) = 'SUB_UNIT_DT_ALIAS' OR

Line 274: App_Exception.Raise_Exception;

270: IF new_references.sub_unit_dt_alias <>
271: upper(new_references.sub_unit_dt_alias) THEN
272: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
273: IGS_GE_MSG_STACK.ADD;
274: App_Exception.Raise_Exception;
275: END IF;
276: END IF;
277:
278: IF upper(column_name) = 'VARIATION_CUTOFF_DT_ALIAS' OR

Line 284: App_Exception.Raise_Exception;

280: IF new_references.variation_cutoff_dt_alias <>
281: upper(new_references.variation_cutoff_dt_alias) THEN
282: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
283: IGS_GE_MSG_STACK.ADD;
284: App_Exception.Raise_Exception;
285: END IF;
286: END IF;
287:
288: IF upper(column_name) = 'BEGIN_TRANS_DT_ALIAS' OR

Line 294: App_Exception.Raise_Exception;

290: IF new_references.begin_trans_dt_alias <>
291: upper(new_references.begin_trans_dt_alias) THEN
292: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
293: IGS_GE_MSG_STACK.ADD;
294: App_Exception.Raise_Exception;
295: END IF;
296: END IF;
297:
298: IF upper(column_name) = 'CLEAN_TRANS_DT_ALIAS' OR

Line 304: App_Exception.Raise_Exception;

300: IF new_references.clean_trans_dt_alias <>
301: upper(new_references.clean_trans_dt_alias) THEN
302: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
303: IGS_GE_MSG_STACK.ADD;
304: App_Exception.Raise_Exception;
305: END IF;
306: END IF;
307:
308: IF upper(column_name) = 'PLANNING_OPEN_DT_ALIAS' OR

Line 314: App_Exception.Raise_Exception;

310: IF new_references.planning_open_dt_alias <>
311: upper(new_references.planning_open_dt_alias) THEN
312: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
313: IGS_GE_MSG_STACK.ADD;
314: App_Exception.Raise_Exception;
315: END IF;
316: END IF;
317:
318: IF upper(column_name) = 'SCHEDULE_OPEN_DT_ALIAS' OR

Line 324: App_Exception.Raise_Exception;

320: IF new_references.schedule_open_dt_alias <>
321: upper(new_references.schedule_open_dt_alias) THEN
322: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
323: IGS_GE_MSG_STACK.ADD;
324: App_Exception.Raise_Exception;
325: END IF;
326: END IF;
327:
328: IF upper(column_name) = 'AUDIT_STATUS_DT_ALIAS' OR

Line 334: App_Exception.Raise_Exception;

330: IF new_references.audit_status_dt_alias <>
331: upper(new_references.audit_status_dt_alias) THEN
332: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
333: IGS_GE_MSG_STACK.ADD;
334: App_Exception.Raise_Exception;
335: END IF;
336: END IF;
337:
338:

Line 353: App_Exception.Raise_Exception;

349: new_references.enr_pckg_prod_dt_alias
350: ) then
351: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
352: IGS_GE_MSG_STACK.ADD;
353: App_Exception.Raise_Exception;
354: end if;
355: END IF;
356:
357: IF (((old_references.record_cutoff_dt_alias = new_references.record_cutoff_dt_alias)) OR

Line 366: App_Exception.Raise_Exception;

362: new_references.record_cutoff_dt_alias
363: ) then
364: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
365: IGS_GE_MSG_STACK.ADD;
366: App_Exception.Raise_Exception;
367: end if;
368: END IF;
369:
370: IF (((old_references.record_open_dt_alias = new_references.record_open_dt_alias)) OR

Line 379: App_Exception.Raise_Exception;

375: new_references.record_open_dt_alias
376: ) then
377: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
378: IGS_GE_MSG_STACK.ADD;
379: App_Exception.Raise_Exception;
380: end if;
381: END IF;
382:
383: IF (((old_references.sub_unit_dt_alias = new_references.sub_unit_dt_alias)) OR

Line 392: App_Exception.Raise_Exception;

388: new_references.sub_unit_dt_alias
389: ) then
390: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
391: IGS_GE_MSG_STACK.ADD;
392: App_Exception.Raise_Exception;
393: end if;
394: END IF;
395:
396: IF (((old_references.variation_cutoff_dt_alias = new_references.variation_cutoff_dt_alias)) OR

Line 405: App_Exception.Raise_Exception;

401: new_references.variation_cutoff_dt_alias
402: ) then
403: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
404: IGS_GE_MSG_STACK.ADD;
405: App_Exception.Raise_Exception;
406: end if;
407: END IF;
408:
409: IF (((old_references.commencement_dt_alias = new_references.commencement_dt_alias)) OR

Line 418: App_Exception.Raise_Exception;

414: new_references.commencement_dt_alias
415: ) then
416: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
417: IGS_GE_MSG_STACK.ADD;
418: App_Exception.Raise_Exception;
419: end if;
420: END IF;
421:
422: IF (((old_references.commence_cutoff_dt_alias = new_references.commence_cutoff_dt_alias)) OR

Line 431: App_Exception.Raise_Exception;

427: new_references.commence_cutoff_dt_alias
428: ) then
429: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
430: IGS_GE_MSG_STACK.ADD;
431: App_Exception.Raise_Exception;
432: end if;
433: END IF;
434:
435: IF (((old_references.enr_form_due_dt_alias = new_references.enr_form_due_dt_alias)) OR

Line 444: App_Exception.Raise_Exception;

440: new_references.enr_form_due_dt_alias
441: ) then
442: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
443: IGS_GE_MSG_STACK.ADD;
444: App_Exception.Raise_Exception;
445: end if;
446: END IF;
447:
448: IF (((old_references.effect_enr_strt_dt_alias = new_references.effect_enr_strt_dt_alias)) OR

Line 457: App_Exception.Raise_Exception;

453: new_references.effect_enr_strt_dt_alias
454: ) then
455: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
456: IGS_GE_MSG_STACK.ADD;
457: App_Exception.Raise_Exception;
458: end if;
459: END IF;
460:
461: IF (((old_references.enrolled_rule_cutoff_dt_alias = new_references.enrolled_rule_cutoff_dt_alias)) OR

Line 470: App_Exception.Raise_Exception;

466: new_references.enrolled_rule_cutoff_dt_alias
467: ) then
468: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
469: IGS_GE_MSG_STACK.ADD;
470: App_Exception.Raise_Exception;
471: end if;
472: END IF;
473:
474: IF (((old_references.invalid_rule_cutoff_dt_alias = new_references.invalid_rule_cutoff_dt_alias)) OR

Line 483: App_Exception.Raise_Exception;

479: new_references.invalid_rule_cutoff_dt_alias
480: ) then
481: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
482: IGS_GE_MSG_STACK.ADD;
483: App_Exception.Raise_Exception;
484: end if;
485: END IF;
486:
487: IF (((old_references.lapse_dt_alias = new_references.lapse_dt_alias)) OR

Line 496: App_Exception.Raise_Exception;

492: new_references.lapse_dt_alias
493: ) then
494: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
495: IGS_GE_MSG_STACK.ADD;
496: App_Exception.Raise_Exception;
497: end if;
498: END IF;
499:
500: IF (((old_references.load_effect_dt_alias = new_references.load_effect_dt_alias)) OR

Line 509: App_Exception.Raise_Exception;

505: new_references.load_effect_dt_alias
506: ) then
507: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
508: IGS_GE_MSG_STACK.ADD;
509: App_Exception.Raise_Exception;
510: end if;
511: END IF;
512:
513: IF (((old_references.enr_cleanup_dt_alias = new_references.enr_cleanup_dt_alias)) OR

Line 522: App_Exception.Raise_Exception;

518: new_references.enr_cleanup_dt_alias
519: ) then
520: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
521: IGS_GE_MSG_STACK.ADD;
522: App_Exception.Raise_Exception;
523: end if;
524: END IF;
525:
526: IF (((old_references.begin_trans_dt_alias = new_references.begin_trans_dt_alias)) OR

Line 535: App_Exception.Raise_Exception;

531: new_references.begin_trans_dt_alias
532: ) then
533: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
534: IGS_GE_MSG_STACK.ADD;
535: App_Exception.Raise_Exception;
536: end if;
537: END IF;
538:
539: IF (((old_references.clean_trans_dt_alias = new_references.clean_trans_dt_alias)) OR

Line 548: App_Exception.Raise_Exception;

544: new_references.clean_trans_dt_alias
545: ) then
546: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
547: IGS_GE_MSG_STACK.ADD;
548: App_Exception.Raise_Exception;
549: end if;
550: END IF;
551:
552: IF (((old_references.planning_open_dt_alias = new_references.planning_open_dt_alias)) OR

Line 561: App_Exception.Raise_Exception;

557: new_references.planning_open_dt_alias
558: ) then
559: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
560: IGS_GE_MSG_STACK.ADD;
561: App_Exception.Raise_Exception;
562: end if;
563: END IF;
564:
565: IF (((old_references.schedule_open_dt_alias = new_references.schedule_open_dt_alias)) OR

Line 574: App_Exception.Raise_Exception;

570: new_references.schedule_open_dt_alias
571: ) then
572: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
573: IGS_GE_MSG_STACK.ADD;
574: App_Exception.Raise_Exception;
575: end if;
576: END IF;
577:
578: IF (((old_references.audit_status_dt_alias = new_references.audit_status_dt_alias)) OR

Line 587: App_Exception.Raise_Exception;

583: new_references.audit_status_dt_alias
584: ) then
585: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
586: IGS_GE_MSG_STACK.ADD;
587: App_Exception.Raise_Exception;
588: end if;
589: END IF;
590:
591:

Line 657: App_Exception.Raise_Exception;

653: IF (cur_rowid%FOUND) THEN
654: Close cur_rowid;
655: Fnd_Message.Set_Name ('IGS', 'IGS_EN_SECC_DA_FK');
656: IGS_GE_MSG_STACK.ADD;
657: App_Exception.Raise_Exception;
658: Return;
659: END IF;
660: Close cur_rowid;
661:

Line 735: App_Exception.Raise_Exception;

731: new_references.s_control_num
732: ) then
733: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
734: IGS_GE_MSG_STACK.ADD;
735: App_Exception.Raise_Exception;
736: end if;
737: Check_constraints;
738: Check_Parent_Existance;
739: ELSIF (p_action = 'UPDATE') THEN

Line 753: App_Exception.Raise_Exception;

749: new_references.s_control_num
750: ) then
751: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
752: IGS_GE_MSG_STACK.ADD;
753: App_Exception.Raise_Exception;
754: end if;
755: Check_constraints;
756: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
757: Check_constraints;

Line 834: app_exception.raise_exception;

830: end if;
831: else
832: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
833: IGS_GE_MSG_STACK.ADD;
834: app_exception.raise_exception;
835: end if;
836:
837: Before_DML (
838: p_action => 'INSERT' ,

Line 996: app_exception.raise_exception;

992: if (c1%notfound) then
993: close c1;
994: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
995: IGS_GE_MSG_STACK.ADD;
996: app_exception.raise_exception;
997: return;
998: end if;
999: close c1;
1000:

Line 1060: app_exception.raise_exception;

1056: null;
1057: else
1058: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1059: IGS_GE_MSG_STACK.ADD;
1060: app_exception.raise_exception;
1061: end if;
1062: return;
1063: end LOCK_ROW;
1064:

Line 1110: app_exception.raise_exception;

1106: end if;
1107: else
1108: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
1109: IGS_GE_MSG_STACK.ADD;
1110: app_exception.raise_exception;
1111: end if;
1112:
1113:
1114: Before_DML (