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

Line 44: App_Exception.Raise_Exception;

40: Fetch cur_old_ref_values INTO old_references;
41: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
42: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
43: IGS_GE_MSG_STACK.ADD;
44: App_Exception.Raise_Exception;
45: Close cur_old_ref_values;
46: Return;
47: END IF;
48: Close cur_old_ref_values;

Line 92: APP_EXCEPTION.RAISE_EXCEPTION;

88: v_message_name) = FALSE THEN
89: --raise_application_error(-20000, IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
90: FND_MESSAGE.SET_NAME('IGS',v_message_name);
91: IGS_GE_MSG_STACK.ADD;
92: APP_EXCEPTION.RAISE_EXCEPTION;
93: END IF;
94: END IF;
95: -- Validate org IGS_PS_UNIT is active and at the local IGS_OR_INSTITUTION.
96: IF p_inserting OR

Line 106: APP_EXCEPTION.RAISE_EXCEPTION;

102: v_message_name) = FALSE THEN
103: --raise_application_error(-20000, IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
104: FND_MESSAGE.SET_NAME('IGS',v_message_name);
105: IGS_GE_MSG_STACK.ADD;
106: APP_EXCEPTION.RAISE_EXCEPTION;
107: END IF;
108: END IF;
109: -- Validate Intake target Type closed ind.
110: IF p_inserting OR

Line 118: APP_EXCEPTION.RAISE_EXCEPTION;

114: v_message_name) = FALSE THEN
115: --raise_application_error(-20000, IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
116: FND_MESSAGE.SET_NAME('IGS',v_message_name);
117: IGS_GE_MSG_STACK.ADD;
118: APP_EXCEPTION.RAISE_EXCEPTION;
119: END IF;
120: END IF;
121: -- Validate override system amount type does not equal the system amount type
122: -- of the intake target type

Line 134: APP_EXCEPTION.RAISE_EXCEPTION;

130: v_message_name) = FALSE THEN
131: --raise_application_error(-20000, IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
132: FND_MESSAGE.SET_NAME('IGS',v_message_name);
133: IGS_GE_MSG_STACK.ADD;
134: APP_EXCEPTION.RAISE_EXCEPTION;
135: END IF;
136: END IF;
137: -- Validate target and maximum target against amount type
138: IF p_inserting OR

Line 153: APP_EXCEPTION.RAISE_EXCEPTION;

149: v_message_name) = FALSE THEN
150: --raise_application_error(-20000, IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
151: FND_MESSAGE.SET_NAME('IGS',v_message_name);
152: IGS_GE_MSG_STACK.ADD;
153: APP_EXCEPTION.RAISE_EXCEPTION;
154: END IF;
155: ELSE
156: IF IGS_AD_VAL_SIT.admp_val_trgt_amt(
157: new_references.override_s_amount_type,

Line 164: APP_EXCEPTION.RAISE_EXCEPTION;

160: v_message_name) = FALSE THEN
161: --raise_application_error(-20000, IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
162: FND_MESSAGE.SET_NAME('IGS',v_message_name);
163: IGS_GE_MSG_STACK.ADD;
164: APP_EXCEPTION.RAISE_EXCEPTION;
165: END IF;
166: END IF;
167: END IF;
168:

Line 185: APP_EXCEPTION.RAISE_EXCEPTION;

181: new_references.funding_source
182: )THEN
183: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
184: IGS_GE_MSG_STACK.ADD;
185: APP_EXCEPTION.RAISE_EXCEPTION;
186: END IF;
187: END IF;
188:
189: IF (((old_references.submission_yr = new_references.submission_yr) AND

Line 201: APP_EXCEPTION.RAISE_EXCEPTION;

197: new_references.submission_number
198: )THEN
199: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
200: IGS_GE_MSG_STACK.ADD;
201: APP_EXCEPTION.RAISE_EXCEPTION;
202: END IF;
203: END IF;
204:
205: IF (((old_references.intake_target_type = new_references.intake_target_type)) OR

Line 215: APP_EXCEPTION.RAISE_EXCEPTION;

211: 'N'
212: )THEN
213: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
214: IGS_GE_MSG_STACK.ADD;
215: APP_EXCEPTION.RAISE_EXCEPTION;
216: END IF;
217: END IF;
218:
219: IF (((old_references.org_unit_cd = new_references.org_unit_cd) AND

Line 231: APP_EXCEPTION.RAISE_EXCEPTION;

227: new_references.ou_start_dt
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.override_s_amount_type = new_references.override_s_amount_type)) OR

Line 245: App_Exception.Raise_Exception;

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

Line 307: App_Exception.Raise_Exception;

303: IF (cur_rowid%FOUND) THEN
304: Close cur_rowid;
305: Fnd_Message.Set_Name ('IGS', 'IGS_AD_SAFT_FS_FK');
306: IGS_GE_MSG_STACK.ADD;
307: App_Exception.Raise_Exception;
308: Return;
309: END IF;
310: Close cur_rowid;
311:

Line 335: App_Exception.Raise_Exception;

331: IF (cur_rowid%FOUND) THEN
332: Close cur_rowid;
333: Fnd_Message.Set_Name ('IGS', 'IGS_AD_SAFT_GSC_FK');
334: IGS_GE_MSG_STACK.ADD;
335: App_Exception.Raise_Exception;
336: Return;
337: END IF;
338: Close cur_rowid;
339:

Line 361: App_Exception.Raise_Exception;

357: IF (cur_rowid%FOUND) THEN
358: Close cur_rowid;
359: Fnd_Message.Set_Name ('IGS', 'IGS_AD_SAFT_ITT_FK');
360: IGS_GE_MSG_STACK.ADD;
361: App_Exception.Raise_Exception;
362: Return;
363: END IF;
364: Close cur_rowid;
365:

Line 389: App_Exception.Raise_Exception;

385: IF (cur_rowid%FOUND) THEN
386: Close cur_rowid;
387: Fnd_Message.Set_Name ('IGS', 'IGS_AD_SAFT_OU_FK');
388: IGS_GE_MSG_STACK.ADD;
389: App_Exception.Raise_Exception;
390: Return;
391: END IF;
392: Close cur_rowid;
393:

Line 415: App_Exception.Raise_Exception;

411: IF (cur_rowid%FOUND) THEN
412: Close cur_rowid;
413: Fnd_Message.Set_Name ('IGS', 'IGS_AD_OVR_AMT_SLV_FK');
414: IGS_GE_MSG_STACK.ADD;
415: App_Exception.Raise_Exception;
416: Return;
417: END IF;
418: Close cur_rowid;
419:

Line 448: APP_EXCEPTION.RAISE_EXCEPTION;

444: IF upper(column_name) = 'TARGET' OR column_name IS NULL THEN
445: IF new_references.target < 00000.000 OR new_references.target > 99999.999 THEN
446: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
447: IGS_GE_MSG_STACK.ADD;
448: APP_EXCEPTION.RAISE_EXCEPTION;
449: END IF;
450: END IF;
451: IF upper(column_name) = 'MAX_TARGET' OR column_name IS NULL THEN
452: IF new_references.max_target < 00000.000 OR new_references.max_target > 99999.999 THEN

Line 455: APP_EXCEPTION.RAISE_EXCEPTION;

451: IF upper(column_name) = 'MAX_TARGET' OR column_name IS NULL THEN
452: IF new_references.max_target < 00000.000 OR new_references.max_target > 99999.999 THEN
453: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
454: IGS_GE_MSG_STACK.ADD;
455: APP_EXCEPTION.RAISE_EXCEPTION;
456: END IF;
457: END IF;
458: IF upper(column_name) = 'OVERRIDE_S_AMOUNT_TYPE' OR column_name IS NULL THEN
459: IF new_references.override_s_amount_type <> UPPER(new_references.override_s_amount_type) THEN

Line 462: APP_EXCEPTION.RAISE_EXCEPTION;

458: IF upper(column_name) = 'OVERRIDE_S_AMOUNT_TYPE' OR column_name IS NULL THEN
459: IF new_references.override_s_amount_type <> UPPER(new_references.override_s_amount_type) THEN
460: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
461: IGS_GE_MSG_STACK.ADD;
462: APP_EXCEPTION.RAISE_EXCEPTION;
463: END IF;
464: END IF;
465: IF upper(column_name) = 'ACTUAL_ENROLMENT' OR column_name IS NULL THEN
466: IF new_references.actual_enrolment < 00000.000 OR new_references.actual_enrolment > 99999.999 THEN

Line 469: APP_EXCEPTION.RAISE_EXCEPTION;

465: IF upper(column_name) = 'ACTUAL_ENROLMENT' OR column_name IS NULL THEN
466: IF new_references.actual_enrolment < 00000.000 OR new_references.actual_enrolment > 99999.999 THEN
467: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
468: IGS_GE_MSG_STACK.ADD;
469: APP_EXCEPTION.RAISE_EXCEPTION;
470: END IF;
471: END IF;
472: IF upper(column_name) = 'FUNDING_SOURCE' OR column_name IS NULL THEN
473: IF new_references.funding_source <> UPPER(new_references.funding_source) THEN

Line 476: APP_EXCEPTION.RAISE_EXCEPTION;

472: IF upper(column_name) = 'FUNDING_SOURCE' OR column_name IS NULL THEN
473: IF new_references.funding_source <> UPPER(new_references.funding_source) THEN
474: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
475: IGS_GE_MSG_STACK.ADD;
476: APP_EXCEPTION.RAISE_EXCEPTION;
477: END IF;
478: END IF;
479: IF upper(column_name) = 'INTAKE_TARGET_TYPE' OR column_name IS NULL THEN
480: IF new_references.intake_target_type <> UPPER(new_references.intake_target_type) THEN

Line 483: APP_EXCEPTION.RAISE_EXCEPTION;

479: IF upper(column_name) = 'INTAKE_TARGET_TYPE' OR column_name IS NULL THEN
480: IF new_references.intake_target_type <> UPPER(new_references.intake_target_type) THEN
481: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
482: IGS_GE_MSG_STACK.ADD;
483: APP_EXCEPTION.RAISE_EXCEPTION;
484: END IF;
485: END IF;
486: END CHECK_CONSTRAINTS;
487:

Line 546: APP_EXCEPTION.RAISE_EXCEPTION;

542: new_references.intake_target_type
543: )THEN
544: FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
545: IGS_GE_MSG_STACK.ADD;
546: APP_EXCEPTION.RAISE_EXCEPTION;
547: END IF;
548: Check_Constraints;
549: Check_Parent_Existance;
550: ELSIF (p_action = 'UPDATE') THEN

Line 570: APP_EXCEPTION.RAISE_EXCEPTION;

566: new_references.intake_target_type
567: )THEN
568: FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
569: IGS_GE_MSG_STACK.ADD;
570: APP_EXCEPTION.RAISE_EXCEPTION;
571: END IF;
572: Check_Constraints;
573: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
574: -- Call all the procedures related to Before Delete.

Line 637: app_exception.raise_exception;

633: end if;
634: else
635: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
636: IGS_GE_MSG_STACK.ADD;
637: app_exception.raise_exception;
638: end if;
639:
640: Before_DML (
641: p_action =>'INSERT',

Line 743: app_exception.raise_exception;

739: fetch c1 into tlinfo;
740: if (c1%notfound) then
741: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
742: IGS_GE_MSG_STACK.ADD;
743: app_exception.raise_exception;
744: close c1;
745: return;
746: end if;
747: close c1;

Line 767: app_exception.raise_exception;

763: null;
764: else
765: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
766: IGS_GE_MSG_STACK.ADD;
767: app_exception.raise_exception;
768: end if;
769: return;
770: end LOCK_ROW;
771:

Line 807: app_exception.raise_exception;

803: end if;
804: else
805: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
806: IGS_GE_MSG_STACK.ADD;
807: app_exception.raise_exception;
808: end if;
809:
810: Before_DML (
811: p_action =>'UPDATE',