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_CTTT_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 95: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 109: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 121: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 133: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 149: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 168: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 179: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 199: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 212: APP_EXCEPTION.RAISE_EXCEPTION;

208: new_references.funding_source
209: )THEN
210: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
211: IGS_GE_MSG_STACK.ADD;
212: APP_EXCEPTION.RAISE_EXCEPTION;
213: END IF;
214: END IF;
215:
216: IF (((old_references.submission_yr = new_references.submission_yr) AND

Line 228: APP_EXCEPTION.RAISE_EXCEPTION;

224: new_references.submission_number
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.intake_target_type = new_references.intake_target_type)) OR

Line 242: APP_EXCEPTION.RAISE_EXCEPTION;

238: 'N'
239: )THEN
240: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
241: IGS_GE_MSG_STACK.ADD;
242: APP_EXCEPTION.RAISE_EXCEPTION;
243: END IF;
244: END IF;
245:
246: IF (((old_references.org_unit_cd = new_references.org_unit_cd) AND

Line 258: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 272: App_Exception.Raise_Exception;

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

Line 336: App_Exception.Raise_Exception;

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

Line 362: App_Exception.Raise_Exception;

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

Line 390: App_Exception.Raise_Exception;

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

Line 416: App_Exception.Raise_Exception;

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

Line 444: App_Exception.Raise_Exception;

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

Line 470: App_Exception.Raise_Exception;

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

Line 505: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 512: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 519: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 526: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 533: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 541: APP_EXCEPTION.RAISE_EXCEPTION;

537: IF upper(column_name) = 'COURSE_TYPE_GROUP_CD' OR column_name IS NULL THEN
538: IF new_references.course_type_group_cd <> UPPER(new_references.course_type_group_cd) THEN
539: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
540: IGS_GE_MSG_STACK.ADD;
541: APP_EXCEPTION.RAISE_EXCEPTION;
542: END IF;
543: END IF;
544: END CHECK_CONSTRAINTS;
545:

Line 606: APP_EXCEPTION.RAISE_EXCEPTION;

602: new_references.intake_target_type
603: )THEN
604: FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
605: IGS_GE_MSG_STACK.ADD;
606: APP_EXCEPTION.RAISE_EXCEPTION;
607: END IF;
608: Check_Constraints;
609: Check_Parent_Existance;
610: ELSIF (p_action = 'UPDATE') THEN

Line 631: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 698: app_exception.raise_exception;

694: end if;
695: else
696: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
697: IGS_GE_MSG_STACK.ADD;
698: app_exception.raise_exception;
699: end if;
700:
701: Before_DML(p_action =>'INSERT',
702: x_rowid =>X_ROWID,

Line 806: app_exception.raise_exception;

802: fetch c1 into tlinfo;
803: if (c1%notfound) then
804: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
805: IGS_GE_MSG_STACK.ADD;
806: app_exception.raise_exception;
807: close c1;
808: return;
809: end if;
810: close c1;

Line 830: app_exception.raise_exception;

826: null;
827: else
828: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
829: IGS_GE_MSG_STACK.ADD;
830: app_exception.raise_exception;
831: end if;
832: return;
833: end LOCK_ROW;
834:

Line 871: app_exception.raise_exception;

867: end if;
868: else
869: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
870: IGS_GE_MSG_STACK.ADD;
871: app_exception.raise_exception;
872: end if;
873:
874: Before_DML(p_action =>'UPDATE',
875: x_rowid =>X_ROWID,