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

Line 45: App_Exception.Raise_Exception;

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

Line 94: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 108: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 120: APP_EXCEPTION.RAISE_EXCEPTION;

116: v_message_name) = FALSE THEN
117: --raise_application_error(-20000, IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
118: FND_MESSAGE.SET_NAME('IGS',v_message_name);
119: IGS_GE_MSG_STACK.ADD;
120: APP_EXCEPTION.RAISE_EXCEPTION;
121: END IF;
122: END IF;
123: -- Validate Intake target Type closed ind.
124: IF p_inserting OR

Line 132: APP_EXCEPTION.RAISE_EXCEPTION;

128: v_message_name) = FALSE THEN
129: --raise_application_error(-20000, IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
130: FND_MESSAGE.SET_NAME('IGS',v_message_name);
131: IGS_GE_MSG_STACK.ADD;
132: APP_EXCEPTION.RAISE_EXCEPTION;
133: END IF;
134: END IF;
135: -- Validate override system amount type does not equal the system amount type
136: -- of the intake target type

Line 148: APP_EXCEPTION.RAISE_EXCEPTION;

144: v_message_name) = FALSE THEN
145: --raise_application_error(-20000, IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
146: FND_MESSAGE.SET_NAME('IGS',v_message_name);
147: IGS_GE_MSG_STACK.ADD;
148: APP_EXCEPTION.RAISE_EXCEPTION;
149: END IF;
150: END IF;
151: -- Validate target and maximum target against amount type
152: IF p_inserting OR

Line 167: APP_EXCEPTION.RAISE_EXCEPTION;

163: v_message_name) = FALSE THEN
164: --raise_application_error(-20000, IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
165: FND_MESSAGE.SET_NAME('IGS',v_message_name);
166: IGS_GE_MSG_STACK.ADD;
167: APP_EXCEPTION.RAISE_EXCEPTION;
168: END IF;
169: ELSE
170: IF IGS_AD_VAL_SIT.admp_val_trgt_amt(
171: new_references.override_s_amount_type,

Line 178: APP_EXCEPTION.RAISE_EXCEPTION;

174: v_message_name) = FALSE THEN
175: --raise_application_error(-20000, IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
176: FND_MESSAGE.SET_NAME('IGS',v_message_name);
177: IGS_GE_MSG_STACK.ADD;
178: APP_EXCEPTION.RAISE_EXCEPTION;
179: END IF;
180: END IF;
181: END IF;
182:

Line 198: APP_EXCEPTION.RAISE_EXCEPTION;

194: new_references.funding_source
195: )THEN
196: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
197: IGS_GE_MSG_STACK.ADD;
198: APP_EXCEPTION.RAISE_EXCEPTION;
199: END IF;
200: END IF;
201:
202: IF (((old_references.submission_yr = new_references.submission_yr) AND

Line 214: APP_EXCEPTION.RAISE_EXCEPTION;

210: new_references.submission_number
211: )THEN
212: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
213: IGS_GE_MSG_STACK.ADD;
214: APP_EXCEPTION.RAISE_EXCEPTION;
215: END IF;
216: END IF;
217:
218: IF (((old_references.intake_target_type = new_references.intake_target_type)) OR

Line 228: APP_EXCEPTION.RAISE_EXCEPTION;

224: 'N'
225: )THEN
226: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
227: IGS_GE_MSG_STACK.ADD;
228: APP_EXCEPTION.RAISE_EXCEPTION;
229: END IF;
230: END IF;
231:
232: IF (((old_references.org_unit_cd = new_references.org_unit_cd) AND

Line 244: APP_EXCEPTION.RAISE_EXCEPTION;

240: new_references.ou_start_dt
241: )THEN
242: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
243: IGS_GE_MSG_STACK.ADD;
244: APP_EXCEPTION.RAISE_EXCEPTION;
245: END IF;
246: END IF;
247:
248: IF (((old_references.unit_int_course_level_cd = new_references.unit_int_course_level_cd)) OR

Line 257: APP_EXCEPTION.RAISE_EXCEPTION;

253: new_references.unit_int_course_level_cd
254: )THEN
255: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
256: IGS_GE_MSG_STACK.ADD;
257: APP_EXCEPTION.RAISE_EXCEPTION;
258: END IF;
259: END IF;
260:
261: IF (((old_references.override_s_amount_type = new_references.override_s_amount_type)) OR

Line 271: App_Exception.Raise_Exception;

267: new_references.override_s_amount_type
268: ) THEN
269: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
270: IGS_GE_MSG_STACK.ADD;
271: App_Exception.Raise_Exception;
272: END IF;
273: END IF;
274:
275: END Check_Parent_Existance;

Line 334: App_Exception.Raise_Exception;

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

Line 362: App_Exception.Raise_Exception;

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

Line 388: App_Exception.Raise_Exception;

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

Line 416: App_Exception.Raise_Exception;

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

Line 442: App_Exception.Raise_Exception;

438: IF (cur_rowid%FOUND) THEN
439: Close cur_rowid;
440: Fnd_Message.Set_Name ('IGS', 'IGS_AD_SAFUT_UICL_FK');
441: IGS_GE_MSG_STACK.ADD;
442: App_Exception.Raise_Exception;
443: Return;
444: END IF;
445: Close cur_rowid;
446:

Line 468: App_Exception.Raise_Exception;

464: IF (cur_rowid%FOUND) THEN
465: Close cur_rowid;
466: Fnd_Message.Set_Name ('IGS', 'IGS_AD_OVR_AMT_SLV_FK');
467: IGS_GE_MSG_STACK.ADD;
468: App_Exception.Raise_Exception;
469: Return;
470: END IF;
471: Close cur_rowid;
472:

Line 503: APP_EXCEPTION.RAISE_EXCEPTION;

499: IF upper(column_name) = 'TARGET' OR column_name IS NULL THEN
500: IF new_references.target < 00000.000 OR new_references.target > 99999.999 THEN
501: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
502: IGS_GE_MSG_STACK.ADD;
503: APP_EXCEPTION.RAISE_EXCEPTION;
504: END IF;
505: END IF;
506: IF upper(column_name) = 'MAX_TARGET' OR column_name IS NULL THEN
507: IF new_references.max_target < 00000.000 OR new_references.max_target > 99999.999 THEN

Line 510: APP_EXCEPTION.RAISE_EXCEPTION;

506: IF upper(column_name) = 'MAX_TARGET' OR column_name IS NULL THEN
507: IF new_references.max_target < 00000.000 OR new_references.max_target > 99999.999 THEN
508: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
509: IGS_GE_MSG_STACK.ADD;
510: APP_EXCEPTION.RAISE_EXCEPTION;
511: END IF;
512: END IF;
513: IF upper(column_name) = 'ACTUAL_ENROLMENT' OR column_name IS NULL THEN
514: IF new_references.actual_enrolment < 00000.000 OR new_references.actual_enrolment > 99999.999 THEN

Line 517: APP_EXCEPTION.RAISE_EXCEPTION;

513: IF upper(column_name) = 'ACTUAL_ENROLMENT' OR column_name IS NULL THEN
514: IF new_references.actual_enrolment < 00000.000 OR new_references.actual_enrolment > 99999.999 THEN
515: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
516: IGS_GE_MSG_STACK.ADD;
517: APP_EXCEPTION.RAISE_EXCEPTION;
518: END IF;
519: END IF;
520: IF upper(column_name) = 'FUNDING_SOURCE' OR column_name IS NULL THEN
521: IF new_references.funding_source <> UPPER(new_references.funding_source) THEN

Line 524: APP_EXCEPTION.RAISE_EXCEPTION;

520: IF upper(column_name) = 'FUNDING_SOURCE' OR column_name IS NULL THEN
521: IF new_references.funding_source <> UPPER(new_references.funding_source) THEN
522: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
523: IGS_GE_MSG_STACK.ADD;
524: APP_EXCEPTION.RAISE_EXCEPTION;
525: END IF;
526: END IF;
527: IF upper(column_name) = 'INTAKE_TARGET_TYPE' OR column_name IS NULL THEN
528: IF new_references.intake_target_type <> UPPER(new_references.intake_target_type) THEN

Line 531: APP_EXCEPTION.RAISE_EXCEPTION;

527: IF upper(column_name) = 'INTAKE_TARGET_TYPE' OR column_name IS NULL THEN
528: IF new_references.intake_target_type <> UPPER(new_references.intake_target_type) THEN
529: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
530: IGS_GE_MSG_STACK.ADD;
531: APP_EXCEPTION.RAISE_EXCEPTION;
532: END IF;
533: END IF;
534: IF upper(column_name) = 'OVERRIDE_S_AMOUNT_TYPE' OR column_name IS NULL THEN
535: IF new_references.override_s_amount_type <> UPPER(new_references.override_s_amount_type) THEN

Line 538: APP_EXCEPTION.RAISE_EXCEPTION;

534: IF upper(column_name) = 'OVERRIDE_S_AMOUNT_TYPE' OR column_name IS NULL THEN
535: IF new_references.override_s_amount_type <> UPPER(new_references.override_s_amount_type) THEN
536: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
537: IGS_GE_MSG_STACK.ADD;
538: APP_EXCEPTION.RAISE_EXCEPTION;
539: END IF;
540: END IF;
541: IF upper(column_name) = 'UNIT_INT_COURSE_LEVEL_CD' OR column_name IS NULL THEN
542: IF new_references.unit_int_course_level_cd <> UPPER(new_references.unit_int_course_level_cd) THEN

Line 545: APP_EXCEPTION.RAISE_EXCEPTION;

541: IF upper(column_name) = 'UNIT_INT_COURSE_LEVEL_CD' OR column_name IS NULL THEN
542: IF new_references.unit_int_course_level_cd <> UPPER(new_references.unit_int_course_level_cd) THEN
543: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
544: IGS_GE_MSG_STACK.ADD;
545: APP_EXCEPTION.RAISE_EXCEPTION;
546: END IF;
547: END IF;
548: END CHECK_CONSTRAINTS;
549:

Line 610: APP_EXCEPTION.RAISE_EXCEPTION;

606: new_references.intake_target_type
607: )THEN
608: FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
609: IGS_GE_MSG_STACK.ADD;
610: APP_EXCEPTION.RAISE_EXCEPTION;
611: END IF;
612: Check_Constraints;
613: Check_Parent_Existance;
614: ELSIF (p_action = 'UPDATE') THEN

Line 635: APP_EXCEPTION.RAISE_EXCEPTION;

631: new_references.intake_target_type
632: )THEN
633: FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
634: IGS_GE_MSG_STACK.ADD;
635: APP_EXCEPTION.RAISE_EXCEPTION;
636: END IF;
637: Check_Constraints;
638: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
639: -- Call all the procedures related to Before Delete.

Line 702: app_exception.raise_exception;

698: end if;
699: else
700: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
701: IGS_GE_MSG_STACK.ADD;
702: app_exception.raise_exception;
703: end if;
704:
705: Before_DML (
706: p_action =>'INSERT',

Line 813: app_exception.raise_exception;

809: fetch c1 into tlinfo;
810: if (c1%notfound) then
811: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
812: IGS_GE_MSG_STACK.ADD;
813: app_exception.raise_exception;
814: close c1;
815: return;
816: end if;
817: close c1;

Line 837: app_exception.raise_exception;

833: null;
834: else
835: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
836: IGS_GE_MSG_STACK.ADD;
837: app_exception.raise_exception;
838: end if;
839: return;
840: end LOCK_ROW;
841:

Line 878: app_exception.raise_exception;

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