DBA Data[Home] [Help]

APPS.IGS_PE_PERSENC_EFFCT_PKG dependencies on APP_EXCEPTION

Line 85: App_Exception.Raise_Exception;

81: IGS_GE_MSG_STACK.ADD;
82:
83:
84: Close cur_old_ref_values;
85: App_Exception.Raise_Exception;
86: Return;
87:
88: END IF;
89:

Line 178: App_Exception.Raise_Exception;

174: v_message_name ) = FALSE THEN
175:
176: Fnd_Message.Set_Name('IGS', v_message_name);
177: IGS_GE_MSG_STACK.ADD;
178: App_Exception.Raise_Exception;
179:
180: END IF;
181:
182: END IF;

Line 202: App_Exception.Raise_Exception;

198: v_message_name ) = FALSE THEN
199:
200: Fnd_Message.Set_Name('IGS', v_message_name);
201: IGS_GE_MSG_STACK.ADD;
202: App_Exception.Raise_Exception;
203:
204: END IF;
205:
206: END IF;

Line 226: App_Exception.Raise_Exception;

222: v_message_name ) = FALSE THEN
223:
224: Fnd_Message.Set_Name('IGS', v_message_name);
225: IGS_GE_MSG_STACK.ADD;
226: App_Exception.Raise_Exception;
227:
228: END IF;
229:
230: END IF;

Line 262: App_Exception.Raise_Exception;

258: v_message_name ) = FALSE THEN
259:
260: Fnd_Message.Set_Name('IGS', v_message_name);
261: IGS_GE_MSG_STACK.ADD;
262: App_Exception.Raise_Exception;
263:
264: END IF;
265: IF IGS_EN_VAL_PCE.enrp_val_encmb_dt (
266:

Line 273: App_Exception.Raise_Exception;

269: v_message_name ) = FALSE THEN
270:
271: Fnd_Message.Set_Name('IGS', v_message_name);
272: IGS_GE_MSG_STACK.ADD;
273: App_Exception.Raise_Exception;
274: END IF;
275:
276: END IF;
277: END IF;

Line 296: App_Exception.Raise_Exception;

292: v_message_name ) = FALSE THEN
293:
294: Fnd_Message.Set_Name('IGS', v_message_name);
295: IGS_GE_MSG_STACK.ADD;
296: App_Exception.Raise_Exception;
297:
298: END IF;
299:
300: END IF;

Line 320: App_Exception.Raise_Exception;

316: v_message_name ) = FALSE THEN
317:
318: Fnd_Message.Set_Name('IGS', 'IGS_EN_CAN_SPEC_RESTR_ATT');
319: IGS_GE_MSG_STACK.ADD;
320: App_Exception.Raise_Exception;
321:
322: END IF;
323:
324: END IF;

Line 338: App_Exception.Raise_Exception;

334: (new_references.s_encmb_effect_type <> 'RSTR_AT_TY') THEN
335:
336: Fnd_Message.Set_Name('IGS', v_message_name);
337: IGS_GE_MSG_STACK.ADD;
338: App_Exception.Raise_Exception;
339: END IF;
340:
341: -- Validate that restricted attendance type is not closed.
342:

Line 357: App_Exception.Raise_Exception;

353: v_message_name ) = FALSE THEN
354:
355: Fnd_Message.Set_Name('IGS', v_message_name);
356: IGS_GE_MSG_STACK.ADD;
357: App_Exception.Raise_Exception;
358: END IF;
359:
360: END IF;
361:

Line 388: App_Exception.Raise_Exception;

384: v_message_name ) = FALSE THEN
385:
386: Fnd_Message.Set_Name('IGS', v_message_name);
387: IGS_GE_MSG_STACK.ADD;
388: App_Exception.Raise_Exception;
389:
390: END IF;
391:
392: END IF;

Line 408: App_Exception.Raise_Exception;

404: new_references.s_encmb_effect_type <> 'RSTR_LE_CP') THEN
405:
406: Fnd_Message.Set_Name('IGS','IGS_EN_CANT_SPEC_ENRL_CRDT');
407: IGS_GE_MSG_STACK.ADD;
408: App_Exception.Raise_Exception;
409:
410: END IF;
411:
412: -- Validate IGS_PE_PERSON does not already have a credit point restriction on the

Line 438: App_Exception.Raise_Exception;

434: v_message_name ) = FALSE THEN
435:
436: Fnd_Message.Set_Name('IGS', v_message_name);
437: IGS_GE_MSG_STACK.ADD;
438: App_Exception.Raise_Exception;
439:
440: END IF;
441:
442: END IF;

Line 536: App_Exception.Raise_Exception;

532: v_message_name) = FALSE THEN
533:
534: Fnd_Message.Set_Name('IGS', v_message_name);
535: IGS_GE_MSG_STACK.ADD;
536: App_Exception.Raise_Exception;
537:
538: END IF;
539:
540: END IF;

Line 568: App_Exception.Raise_Exception;

564: IF v_message_name IS NOT NULL THEN
565:
566: Fnd_Message.Set_Name('IGS', v_message_name);
567: IGS_GE_MSG_STACK.ADD;
568: App_Exception.Raise_Exception;
569: END IF;
570:
571: END IF;
572:

Line 598: App_Exception.Raise_Exception;

594: IF v_message_name IS NOT NULL THEN
595:
596: Fnd_Message.Set_Name('IGS', v_message_name);
597: IGS_GE_MSG_STACK.ADD;
598: App_Exception.Raise_Exception;
599:
600: END IF;
601:
602: END IF;

Line 650: App_Exception.Raise_Exception;

646: column_name is null Then
647: IF new_references.course_cd <> UPPER(new_references.course_cd) Then
648: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
649: IGS_GE_MSG_STACK.ADD;
650: App_Exception.Raise_Exception;
651: END IF;
652: END IF;
653:
654: IF upper(column_name) = 'ENCUMBRANCE_TYPE' OR

Line 660: App_Exception.Raise_Exception;

656: IF new_references.encumbrance_type <>
657: UPPER(new_references.encumbrance_type) Then
658: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
659: IGS_GE_MSG_STACK.ADD;
660: App_Exception.Raise_Exception;
661: END IF;
662: END IF;
663: IF upper(column_name) = 'RESTRICTED_ATTENDANCE_TYPE' OR
664: column_name is null Then

Line 669: App_Exception.Raise_Exception;

665: IF new_references.restricted_attendance_type <>
666: UPPER(new_references.restricted_attendance_type) Then
667: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
668: IGS_GE_MSG_STACK.ADD;
669: App_Exception.Raise_Exception;
670: END IF;
671: END IF;
672: IF upper(column_name) = 'S_ENCMB_EFFECT_TYPE' OR
673: column_name is null Then

Line 678: App_Exception.Raise_Exception;

674: IF new_references.s_encmb_effect_type<>
675: UPPER(new_references.s_encmb_effect_type) Then
676: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
677: IGS_GE_MSG_STACK.ADD;
678: App_Exception.Raise_Exception;
679: END IF;
680: END IF;
681: IF upper(column_name) = 'RESTRICTED_ENROLMENT_CP' OR
682: column_name is null Then

Line 687: App_Exception.Raise_Exception;

683: IF new_references.restricted_enrolment_cp < 0 OR
684: new_references.restricted_enrolment_cp > 999.999 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:
691:

Line 716: App_Exception.Raise_Exception;

712: new_references.restricted_attendance_type
713: ) THEN
714: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
715: IGS_GE_MSG_STACK.ADD;
716: App_Exception.Raise_Exception;
717: END IF;
718:
719:
720: END IF;

Line 747: App_Exception.Raise_Exception;

743: new_references.encumbrance_type,
744: new_references.pen_start_dt ) THEN
745: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
746: IGS_GE_MSG_STACK.ADD;
747: App_Exception.Raise_Exception;
748: END IF;
749:
750: END IF;
751:

Line 767: App_Exception.Raise_Exception;

763: IF NOT IGS_EN_ENCMB_EFCTTYP_Pkg.Get_PK_For_Validation (
764: new_references.s_encmb_effect_type ) THEN
765: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
766: IGS_GE_MSG_STACK.ADD;
767: App_Exception.Raise_Exception;
768: END IF;
769:
770: END IF;
771:

Line 997: App_Exception.Raise_Exception;

993:
994: IGS_GE_MSG_STACK.ADD;
995:
996: Close cur_rowid;
997: App_Exception.Raise_Exception;
998: Return;
999:
1000: END IF;
1001:

Line 1054: App_Exception.Raise_Exception;

1050:
1051: IGS_GE_MSG_STACK.ADD;
1052:
1053: Close cur_rowid;
1054: App_Exception.Raise_Exception;
1055: Return;
1056:
1057: END IF;
1058:

Line 1164: App_Exception.Raise_Exception;

1160: new_references.pee_start_dt,
1161: new_references.sequence_number) THEN
1162: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
1163: IGS_GE_MSG_STACK.ADD;
1164: App_Exception.Raise_Exception;
1165: END IF;
1166:
1167: Check_Constraints; -- if procedure present
1168: Check_Parent_Existance; -- if procedure present

Line 1194: App_Exception.Raise_Exception;

1190: new_references.pee_start_dt,
1191: new_references.sequence_number) THEN
1192: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
1193: IGS_GE_MSG_STACK.ADD;
1194: App_Exception.Raise_Exception;
1195: END IF;
1196: Check_Constraints; -- if procedure present
1197: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
1198:

Line 1299: app_exception.raise_exception;

1295: end if;
1296: else
1297: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
1298: IGS_GE_MSG_STACK.ADD;
1299: app_exception.raise_exception;
1300: end if;
1301:
1302:
1303:

Line 1426: App_Exception.Raise_Exception;

1422: if (c1%notfound) then
1423: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1424:
1425: close c1;
1426: App_Exception.Raise_Exception;
1427: return;
1428: end if;
1429: close c1;
1430:

Line 1447: app_exception.raise_exception;

1443: ) then
1444: null;
1445: else
1446: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1447: app_exception.raise_exception;
1448: end if;
1449: return;
1450: end LOCK_ROW;
1451:

Line 1487: app_exception.raise_exception;

1483: end if;
1484: else
1485: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
1486: IGS_GE_MSG_STACK.ADD;
1487: app_exception.raise_exception;
1488: end if;
1489:
1490:
1491: