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

Line 124: App_Exception.Raise_Exception;

120: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
121: Close cur_old_ref_values;
122: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
123: IGS_GE_MSG_STACK.ADD;
124: App_Exception.Raise_Exception;
125: Return;
126: END IF;
127: Close cur_old_ref_values;
128:

Line 289: App_Exception.Raise_Exception;

285: IF Upper(Column_Name)='ABBREVIATION' OR Column_Name IS NULL Then
286: IF New_References.abbreviation <> UPPER(New_References.abbreviation) Then
287: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
288: IGS_GE_MSG_STACK.ADD;
289: App_Exception.Raise_Exception;
290: END IF;
291: END IF;
292:
293: IF Upper(Column_Name)='ASSESSABLE_IND' OR Column_Name IS NULL Then

Line 297: App_Exception.Raise_Exception;

293: IF Upper(Column_Name)='ASSESSABLE_IND' OR Column_Name IS NULL Then
294: IF New_References.Assessable_Ind NOT IN ( 'Y' , 'N' ) Then
295: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
296: IGS_GE_MSG_STACK.ADD;
297: App_Exception.Raise_Exception;
298: END IF;
299: END IF;
300:
301: IF Upper(Column_Name)='AWARD_COURSE_ONLY_IND' OR Column_Name IS NULL Then

Line 305: App_Exception.Raise_Exception;

301: IF Upper(Column_Name)='AWARD_COURSE_ONLY_IND' OR Column_Name IS NULL Then
302: IF New_References.Award_Course_Only_Ind NOT IN ( 'Y' , 'N' ) Then
303: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
304: IGS_GE_MSG_STACK.ADD;
305: App_Exception.Raise_Exception;
306: END IF;
307: END IF;
308:
309: IF Upper(Column_Name)='CREDIT_POINT_DESCRIPTOR' OR Column_Name IS NULL Then

Line 313: App_Exception.Raise_Exception;

309: IF Upper(Column_Name)='CREDIT_POINT_DESCRIPTOR' OR Column_Name IS NULL Then
310: IF New_References.Credit_Point_Descriptor <> UPPER(New_References.Credit_Point_Descriptor) Then
311: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
312: IGS_GE_MSG_STACK.ADD;
313: App_Exception.Raise_Exception;
314: END IF;
315: END IF;
316:
317: IF Upper(Column_Name)='INDUSTRIAL_IND' OR Column_Name IS NULL Then

Line 321: App_Exception.Raise_Exception;

317: IF Upper(Column_Name)='INDUSTRIAL_IND' OR Column_Name IS NULL Then
318: IF New_References.Industrial_Ind NOT IN ( 'Y' , 'N' ) Then
319: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
320: IGS_GE_MSG_STACK.ADD;
321: App_Exception.Raise_Exception;
322: END IF;
323:
324: END IF;
325:

Line 331: App_Exception.Raise_Exception;

327:
328: IF New_References.Points_Override_Ind NOT IN ( 'Y' , 'N' ) Then
329: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
330: IGS_GE_MSG_STACK.ADD;
331: App_Exception.Raise_Exception;
332: END IF;
333:
334:
335: END IF;

Line 341: App_Exception.Raise_Exception;

337: IF Upper(Column_Name)='PRACTICAL_IND' OR Column_Name IS NULL Then
338: IF New_References.Practical_Ind <> UPPER(New_References.Practical_Ind) Then
339: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
340: IGS_GE_MSG_STACK.ADD;
341: App_Exception.Raise_Exception;
342: END IF;
343: END IF;
344:
345: IF Upper(Column_Name)='REPEATABLE_IND' OR Column_Name IS NULL Then

Line 350: App_Exception.Raise_Exception;

346:
347: IF New_References.Repeatable_Ind NOT IN ( 'Y' , 'N','X' ) Then
348: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
349: IGS_GE_MSG_STACK.ADD;
350: App_Exception.Raise_Exception;
351: END IF;
352:
353: END IF;
354:

Line 361: App_Exception.Raise_Exception;

357:
358: IF New_References.Research_Unit_Ind NOT IN ( 'Y' , 'N' ) Then
359: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
360: IGS_GE_MSG_STACK.ADD;
361: App_Exception.Raise_Exception;
362: END IF;
363:
364:
365: END IF;

Line 373: App_Exception.Raise_Exception;

369:
370: IF New_References.Supp_Exam_Permitted_Ind NOT IN ( 'Y' , 'N' ) Then
371: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
372: IGS_GE_MSG_STACK.ADD;
373: App_Exception.Raise_Exception;
374: END IF;
375:
376:
377: END IF;

Line 385: App_Exception.Raise_Exception;

381:
382: IF New_References.Title_Override_Ind NOT IN ( 'Y' , 'N' ) Then
383: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
384: IGS_GE_MSG_STACK.ADD;
385: App_Exception.Raise_Exception;
386: END IF;
387:
388:
389: END IF;

Line 395: App_Exception.Raise_Exception;

391: IF Upper(Column_Name)='AUDITABLE_IND' OR Column_Name IS NULL Then
392: IF New_References.auditable_Ind NOT IN ( 'Y' , 'N' ) Then
393: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
394: IGS_GE_MSG_STACK.ADD;
395: App_Exception.Raise_Exception;
396: END IF;
397: END IF;
398:
399: IF Upper(Column_Name)='AUDIT_PERMISSION_IND' OR Column_Name IS NULL Then

Line 403: App_Exception.Raise_Exception;

399: IF Upper(Column_Name)='AUDIT_PERMISSION_IND' OR Column_Name IS NULL Then
400: IF New_References.audit_permission_Ind NOT IN ( 'Y' , 'N' ) Then
401: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
402: IGS_GE_MSG_STACK.ADD;
403: App_Exception.Raise_Exception;
404: END IF;
405: END IF;
406:
407: IF Upper(Column_Name)='UNIT_CD' OR Column_Name IS NULL Then

Line 411: App_Exception.Raise_Exception;

407: IF Upper(Column_Name)='UNIT_CD' OR Column_Name IS NULL Then
408: IF New_References.Unit_Cd <> UPPER(New_References.Unit_CD) Then
409: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
410: IGS_GE_MSG_STACK.ADD;
411: App_Exception.Raise_Exception;
412: END IF;
413: END IF;
414:
415: IF Upper(Column_Name)='UNIT_INT_COURSE_LEVEL_CD' OR Column_Name IS NULL Then

Line 419: App_Exception.Raise_Exception;

415: IF Upper(Column_Name)='UNIT_INT_COURSE_LEVEL_CD' OR Column_Name IS NULL Then
416: IF New_References.Unit_Int_Course_Level_Cd <> UPPER(New_References.Unit_Int_Course_Level_Cd) Then
417: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
418: IGS_GE_MSG_STACK.ADD;
419: App_Exception.Raise_Exception;
420: END IF;
421: END IF;
422:
423: IF Upper(Column_Name)='UNIT_LEVEL' OR Column_Name IS NULL Then

Line 427: App_Exception.Raise_Exception;

423: IF Upper(Column_Name)='UNIT_LEVEL' OR Column_Name IS NULL Then
424: IF New_References.Unit_Level <> UPPER(New_References.Unit_Level) Then
425: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
426: IGS_GE_MSG_STACK.ADD;
427: App_Exception.Raise_Exception;
428: END IF;
429: END IF;
430:
431: IF Upper(Column_Name)='UNIT_STATUS' OR Column_Name IS NULL Then

Line 435: App_Exception.Raise_Exception;

431: IF Upper(Column_Name)='UNIT_STATUS' OR Column_Name IS NULL Then
432: IF New_References.Unit_Status <> UPPER(New_References.Unit_Status) Then
433: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
434: IGS_GE_MSG_STACK.ADD;
435: App_Exception.Raise_Exception;
436: END IF;
437: END IF;
438:
439: -- check that atleast one enrollemnt method is selected

Line 444: App_Exception.Raise_Exception;

440: IF (Upper(Column_name)='SS_ENROL_IND' OR Upper(Column_name)='IVR_ENROL_IND') OR Column_name IS NULL THEN
441: IF NOT (New_References.ss_enrol_ind = 'Y' OR New_references.ivr_enrol_ind = 'Y') THEN
442: Fnd_Message.Set_Name('IGS', 'IGS_PS_ONE_UNIT_ENR_MTHD');
443: IGS_GE_MSG_STACK.ADD;
444: App_Exception.Raise_Exception;
445: END IF;
446: END IF;
447:
448: IF Upper(Column_Name)='BILLING_HRS' OR Column_Name IS NULL Then

Line 452: App_Exception.Raise_Exception;

448: IF Upper(Column_Name)='BILLING_HRS' OR Column_Name IS NULL Then
449: IF New_References.billing_hrs < 0 OR New_References.billing_hrs > 999.999 Then
450: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
451: IGS_GE_MSG_STACK.ADD;
452: App_Exception.Raise_Exception;
453: END IF;
454: END IF;
455:
456:

Line 740: App_Exception.Raise_Exception;

736: New_References.version_number,
737: New_References.hist_start_dt) THEN
738: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
739: IGS_GE_MSG_STACK.ADD;
740: App_Exception.Raise_Exception;
741: END IF;
742: Check_Constraints;
743: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
744: Check_Constraints;

Line 880: app_exception.raise_exception;

876: end if;
877: else
878: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
879: IGS_GE_MSG_STACK.ADD;
880: app_exception.raise_exception;
881: end if;
882:
883: Before_DML(
884: p_action => 'INSERT',

Line 1381: app_exception.raise_exception;

1377: if (c1%notfound) then
1378: close c1;
1379: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1380: IGS_GE_MSG_STACK.ADD;
1381: app_exception.raise_exception;
1382: return;
1383: end if;
1384: close c1;
1385:

Line 1644: app_exception.raise_exception;

1640: NULL;
1641: else
1642: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1643: IGS_GE_MSG_STACK.ADD;
1644: app_exception.raise_exception;
1645: end if;
1646: return;
1647: END LOCK_ROW;
1648:

Line 1762: app_exception.raise_exception;

1758: end if;
1759: else
1760: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
1761: IGS_GE_MSG_STACK.ADD;
1762: app_exception.raise_exception;
1763: end if;
1764: Before_DML(
1765: p_action => 'UPDATE',
1766: x_rowid => X_ROWID,