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

Line 62: App_Exception.Raise_Exception;

58: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
59: Close cur_old_ref_values;
60: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
61: IGS_GE_MSG_STACK.ADD;
62: App_Exception.Raise_Exception;
63: Return;
64: END IF;
65: Close cur_old_ref_values;
66:

Line 131: app_exception.raise_exception;

127: new_references.course_cd,
128: v_message_name) = FALSE THEN
129: fnd_message.set_name('IGS',v_message_name);
130: IGS_GE_MSG_STACK.ADD;
131: app_exception.raise_exception;
132:
133: END IF;
134: -- Create an entry on the IGS_PE_STD_TODO table.
135: v_return_val := IGS_GE_GEN_003.GENP_INS_STDNT_TODO(new_references.person_id, 'FEE_RECALC', NULL,'Y');

Line 146: app_exception.raise_exception;

142: old_references.start_dt,
143: v_message_name) = FALSE THEN
144: fnd_message.set_name('IGS',v_message_name);
145: IGS_GE_MSG_STACK.ADD;
146: app_exception.raise_exception;
147: END IF;
148: END IF;
149: IF p_updating THEN
150: -- Validate if the update is allowed.

Line 166: app_exception.raise_exception;

162: old_references.start_dt,
163: v_message_name) = FALSE THEN
164: fnd_message.set_name('IGS',v_message_name);
165: IGS_GE_MSG_STACK.ADD;
166: app_exception.raise_exception;
167: END IF;
168: END IF;
169: END IF;
170: IF p_inserting OR p_updating THEN

Line 187: app_exception.raise_exception;

183: new_references.end_dt,
184: v_message_name) = FALSE THEN
185: fnd_message.set_name('IGS',v_message_name);
186: IGS_GE_MSG_STACK.ADD;
187: app_exception.raise_exception;
188: END IF;
189: END IF;
190: -- Validate END DATE.
191: IF (NVL(old_references.hecs_payment_option, 'NULL') <>

Line 205: app_exception.raise_exception;

201: new_references.hecs_payment_option,
202: v_message_name) = FALSE THEN
203: fnd_message.set_name('IGS',v_message_name);
204: IGS_GE_MSG_STACK.ADD;
205: app_exception.raise_exception;
206: END IF;
207: END IF;
208: -- Validate HECS PAYMENT OPTION closed indicator.
209: IF NVL(old_references.hecs_payment_option, 'NULL') <>

Line 216: app_exception.raise_exception;

212: new_references.hecs_payment_option,
213: v_message_name) = FALSE THEN
214: fnd_message.set_name('IGS',v_message_name);
215: IGS_GE_MSG_STACK.ADD;
216: app_exception.raise_exception;
217: END IF;
218: END IF;
219: -- Validate TAX FILE NUMBER INVALID DATE.
220: IF IGS_EN_VAL_SCHO.enrp_val_tfn_invalid (

Line 226: app_exception.raise_exception;

222: new_references.tax_file_invalid_dt,
223: v_message_name) = FALSE THEN
224: fnd_message.set_name('IGS',v_message_name);
225: IGS_GE_MSG_STACK.ADD;
226: app_exception.raise_exception;
227: END IF;
228: -- Validate TAX FILE NUMBER CERTIFICATE NUMBER.
229: IF IGS_EN_VAL_SCHO.enrp_val_tfn_crtfct (
230: new_references.tax_file_number,

Line 236: app_exception.raise_exception;

232: new_references.tax_file_certificate_number,
233: v_message_name) = FALSE THEN
234: fnd_message.set_name('IGS',v_message_name);
235: IGS_GE_MSG_STACK.ADD;
236: app_exception.raise_exception;
237: END IF;
238: -- Validate the VISA INDICATORS.
239: IF (NVL(old_references.outside_aus_res_ind, 'NULL') <>
240: NVL(new_references.outside_aus_res_ind, 'NULL')) OR

Line 255: app_exception.raise_exception;

251: new_references.nz_citizen_not_res_ind,
252: v_message_name) = FALSE THEN
253: fnd_message.set_name('IGS',v_message_name);
254: IGS_GE_MSG_STACK.ADD;
255: app_exception.raise_exception;
256: END IF;
257: END IF;
258: -- Cross-table validations.
259: -- IGS_EN_STDNTPSHECSOP and IGS_PE_STATISTICS and IGS_PS_COURSE VERSION.

Line 273: app_exception.raise_exception;

269: v_return_type) = FALSE THEN
270: IF v_return_type = cst_error THEN
271: fnd_message.set_name('IGS',v_message_name);
272: IGS_GE_MSG_STACK.ADD;
273: app_exception.raise_exception;
274: END IF;
275: END IF;
276: END IF;
277: -- Validate the student IGS_PS_COURSE attempt HECS option HECS payment option,

Line 291: app_exception.raise_exception;

287: v_return_type) = FALSE THEN
288: IF v_return_type = cst_error THEN
289: fnd_message.set_name('IGS',v_message_name);
290: IGS_GE_MSG_STACK.ADD;
291: app_exception.raise_exception;
292: END IF;
293: END IF;
294: END IF;
295: -- Validate the student IGS_PS_COURSE attempt HECS option HECS payment option,

Line 318: app_exception.raise_exception;

314: v_return_type) = FALSE THEN
315: IF v_return_type = cst_error THEN
316: fnd_message.set_name('IGS',v_message_name);
317: IGS_GE_MSG_STACK.ADD;
318: app_exception.raise_exception;
319: END IF;
320: END IF;
321: END IF;
322: -- Validate the student IGS_PS_COURSE attempt HECS option HECS payment option,

Line 344: app_exception.raise_exception;

340: v_return_type) = FALSE THEN
341: IF v_return_type = cst_error THEN
342: fnd_message.set_name('IGS',v_message_name);
343: IGS_GE_MSG_STACK.ADD;
344: app_exception.raise_exception;
345: END IF;
346: END IF;
347: END IF;
348: -- Validate the student IGS_PS_COURSE attempt HECS option HECS payment option,

Line 371: app_exception.raise_exception;

367: v_return_type) = FALSE THEN
368: IF v_return_type = cst_error THEN
369: fnd_message.set_name('IGS',v_message_name);
370: IGS_GE_MSG_STACK.ADD;
371: app_exception.raise_exception;
372: END IF;
373: END IF;
374: END IF;
375: -- Validate the student IGS_PS_COURSE attempt HECS option visa indicators,

Line 407: app_exception.raise_exception;

403: v_return_type) = FALSE THEN
404: IF v_return_type = cst_error THEN
405: fnd_message.set_name('IGS',v_message_name);
406: IGS_GE_MSG_STACK.ADD;
407: app_exception.raise_exception;
408: END IF;
409: END IF;
410: END IF;
411: -- Validate the student IGS_PS_COURSE attempt HECS option HECS payment option,

Line 438: app_exception.raise_exception;

434: v_return_type) = FALSE THEN
435: IF v_return_type = cst_error THEN
436: fnd_message.set_name('IGS',v_message_name);
437: IGS_GE_MSG_STACK.ADD;
438: app_exception.raise_exception;
439: END IF;
440: END IF;
441: END IF;
442: -- Validate the student IGS_PS_COURSE attempt HECS option HECS payment option,

Line 478: app_exception.raise_exception;

474: v_return_type) = FALSE THEN
475: IF v_return_type = cst_error THEN
476: fnd_message.set_name('IGS',v_message_name);
477: IGS_GE_MSG_STACK.ADD;
478: app_exception.raise_exception;
479: END IF;
480: END IF;
481: END IF;
482: -- Validate the student IGS_PS_COURSE attempt HECS option HECS payment option,

Line 509: app_exception.raise_exception;

505: v_return_type) = FALSE THEN
506: IF v_return_type = cst_error THEN
507: fnd_message.set_name('IGS',v_message_name);
508: IGS_GE_MSG_STACK.ADD;
509: app_exception.raise_exception;
510: END IF;
511: END IF;
512: END IF;
513: END IF;

Line 598: app_exception.raise_exception;

594: New_References.start_dt,
595: v_message_name) = FALSE THEN
596: fnd_message.set_name('IGS',v_message_name);
597: IGS_GE_MSG_STACK.ADD;
598: app_exception.raise_exception;
599: END IF;
600: END IF;
601: -- Validate IGS_EN_STDNTPSHECSOP date overlaps.
602: IF IGS_EN_VAL_SCHO.enrp_val_scho_ovrlp (

Line 610: app_exception.raise_exception;

606: New_References.end_dt,
607: v_message_name) = FALSE THEN
608: fnd_message.set_name('IGS',v_message_name);
609: IGS_GE_MSG_STACK.ADD;
610: app_exception.raise_exception;
611: END IF;
612: -- Validate TAX FILE NUMBER.
613: IF IGS_EN_VAL_SCHO.enrp_val_scho_tfn(
614: New_References.person_id,

Line 623: app_exception.raise_exception;

619: v_return_type) = FALSE THEN
620: IF v_return_type = cst_error THEN
621: fnd_message.set_name('IGS',v_message_name);
622: IGS_GE_MSG_STACK.ADD;
623: app_exception.raise_exception;
624: END IF;
625: END IF;
626: -- Validate HECS PAYMENT OPTION and other fields.
627: IF IGS_EN_VAL_SCHO.enrp_val_scho_hpo (

Line 643: app_exception.raise_exception;

639: v_return_type) = FALSE THEN
640: IF v_return_type = cst_error THEN
641: fnd_message.set_name('IGS',v_message_name);
642: IGS_GE_MSG_STACK.ADD;
643: app_exception.raise_exception;
644: END IF;
645: END IF;
646: END IF;
647: END IF;

Line 687: App_Exception.Raise_Exception;

683: if new_references.differential_hecs_ind not IN ('Y','N') OR
684: new_references.differential_hecs_ind <> upper(new_references.differential_hecs_ind) then
685: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
686: IGS_GE_MSG_STACK.ADD;
687: App_Exception.Raise_Exception;
688: end if;
689: end if;
690: if upper(column_name) = 'OUTSIDE_AUS_RES_IND' OR
691: column_name is null then

Line 696: App_Exception.Raise_Exception;

692: if new_references.outside_aus_res_ind not IN ('Y','N') OR
693: new_references.outside_aus_res_ind <> upper(new_references.outside_aus_res_ind) then
694: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
695: IGS_GE_MSG_STACK.ADD;
696: App_Exception.Raise_Exception;
697: end if;
698: end if;
699: if upper(column_name) = 'NZ_CITIZEN_IND' OR
700: column_name is null then

Line 705: App_Exception.Raise_Exception;

701: if new_references.nz_citizen_ind not IN ('Y','N') OR
702: new_references.nz_citizen_ind <> upper(new_references.nz_citizen_ind) then
703: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
704: IGS_GE_MSG_STACK.ADD;
705: App_Exception.Raise_Exception;
706: end if;
707: end if;
708: if upper(column_name) = 'NZ_CITIZEN_LESS2YR_IND' OR
709: column_name is null then

Line 714: App_Exception.Raise_Exception;

710: if new_references.nz_citizen_less2yr_ind not IN ('Y','N') OR
711: new_references.nz_citizen_less2yr_ind <> upper(new_references.nz_citizen_less2yr_ind) then
712: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
713: IGS_GE_MSG_STACK.ADD;
714: App_Exception.Raise_Exception;
715: end if;
716: end if;
717: if upper(column_name) = 'NZ_CITIZEN_NOT_RES_IND' OR
718: column_name is null then

Line 723: App_Exception.Raise_Exception;

719: if new_references.nz_citizen_not_res_ind not IN ('Y','N') OR
720: new_references.nz_citizen_not_res_ind <> upper(new_references.nz_citizen_not_res_ind) then
721: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
722: IGS_GE_MSG_STACK.ADD;
723: App_Exception.Raise_Exception;
724: end if;
725: end if;
726: if upper(column_name) = 'SAFETY_NET_IND' OR
727: column_name is null then

Line 732: App_Exception.Raise_Exception;

728: if new_references.safety_net_ind not IN ('Y','N') OR
729: new_references.safety_net_ind <> upper(new_references.safety_net_ind) then
730: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
731: IGS_GE_MSG_STACK.ADD;
732: App_Exception.Raise_Exception;
733: end if;
734: end if;
735: if upper(column_name) = 'TAX_FILE_CERTIFICATE_NUMBER' OR
736: column_name is null then

Line 741: App_Exception.Raise_Exception;

737: if new_references.tax_file_certificate_number < 0 OR
738: new_references.tax_file_certificate_number > 9999999999 then
739: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
740: IGS_GE_MSG_STACK.ADD;
741: App_Exception.Raise_Exception;
742: end if;
743: end if;
744: if upper(column_name) = 'COURSE_CD' OR
745: column_name is null then

Line 749: App_Exception.Raise_Exception;

745: column_name is null then
746: if new_references.course_cd <> upper(new_references.course_cd) then
747: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
748: IGS_GE_MSG_STACK.ADD;
749: App_Exception.Raise_Exception;
750: end if;
751: end if;
752: if upper(column_name) = 'DIFF_HECS_IND_UPDATE_WHO' OR
753: column_name is null then

Line 758: App_Exception.Raise_Exception;

754: if new_references.diff_hecs_ind_update_who <>
755: upper(new_references.diff_hecs_ind_update_who) then
756: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
757: IGS_GE_MSG_STACK.ADD;
758: App_Exception.Raise_Exception;
759: end if;
760: end if;
761: if upper(column_name) = 'HECS_PAYMENT_OPTION' OR
762: column_name is null then

Line 766: App_Exception.Raise_Exception;

762: column_name is null then
763: if new_references.hecs_payment_option <>upper(new_references.hecs_payment_option) then
764: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
765: IGS_GE_MSG_STACK.ADD;
766: App_Exception.Raise_Exception;
767: end if;
768: end if;
769: END check_constraints;
770: PROCEDURE Check_Parent_Existance AS

Line 782: App_Exception.Raise_Exception;

778: new_references.hecs_payment_option
779: )then
780: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
781: IGS_GE_MSG_STACK.ADD;
782: App_Exception.Raise_Exception;
783: end if;
784: END IF;
785:
786: IF (((old_references.person_id = new_references.person_id) AND

Line 798: App_Exception.Raise_Exception;

794: new_references.course_cd
795: )then
796: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
797: IGS_GE_MSG_STACK.ADD;
798: App_Exception.Raise_Exception;
799: end if;
800: END IF;
801:
802: END Check_Parent_Existance;

Line 853: App_Exception.Raise_Exception;

849: IF (cur_rowid%FOUND) THEN
850: Close cur_rowid;
851: Fnd_Message.Set_Name ('IGS', 'IGS_EN_SCHO_HPO_FK');
852: IGS_GE_MSG_STACK.ADD;
853: App_Exception.Raise_Exception;
854: Return;
855: END IF;
856: Close cur_rowid;
857:

Line 881: App_Exception.Raise_Exception;

877: IF (cur_rowid%FOUND) THEN
878: Close cur_rowid;
879: Fnd_Message.Set_Name ('IGS', 'IGS_EN_SCHO_SCA_FK');
880: IGS_GE_MSG_STACK.ADD;
881: App_Exception.Raise_Exception;
882: Return;
883: END IF;
884: Close cur_rowid;
885:

Line 955: App_Exception.Raise_Exception;

951: new_references.start_dt
952: ) then
953: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
954: IGS_GE_MSG_STACK.ADD;
955: App_Exception.Raise_Exception;
956: end if;
957: Check_constraints;
958: Check_Parent_Existance;
959: ELSIF (p_action = 'UPDATE') THEN

Line 975: App_Exception.Raise_Exception;

971: new_references.start_dt
972: ) then
973: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
974: IGS_GE_MSG_STACK.ADD;
975: App_Exception.Raise_Exception;
976: end if;
977: Check_constraints;
978: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
979: Check_constraints;

Line 1077: app_exception.raise_exception;

1073:
1074: else
1075: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
1076: IGS_GE_MSG_STACK.ADD;
1077: app_exception.raise_exception;
1078: end if;
1079:
1080: Before_DML(
1081: p_action => 'INSERT',

Line 1230: app_exception.raise_exception;

1226: if (c1%notfound) then
1227: close c1;
1228: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1229: IGS_GE_MSG_STACK.ADD;
1230: app_exception.raise_exception;
1231: return;
1232: end if;
1233: close c1;
1234:

Line 1271: app_exception.raise_exception;

1267: null;
1268: else
1269: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1270: IGS_GE_MSG_STACK.ADD;
1271: app_exception.raise_exception;
1272: end if;
1273: return;
1274: end LOCK_ROW;
1275:

Line 1324: app_exception.raise_exception;

1320: end if;
1321: else
1322: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
1323: IGS_GE_MSG_STACK.ADD;
1324: app_exception.raise_exception;
1325: end if;
1326:
1327:
1328: