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

Line 39: app_exception.raise_exception;

35: -- Only planned unit status are allowed for deletion
36: IF old_references.unit_section_status <> 'PLANNED' THEN
37: fnd_message.set_name('IGS','IGS_PS_USEC_NO_DEL_ALLOWED');
38: igs_ge_msg_stack.add;
39: app_exception.raise_exception;
40: END IF;
41:
42: END beforerowdelete;
43:

Line 139: app_exception.raise_exception;

135: IF p_c_new_usec_sts = 'PLANNED' AND
136: p_c_old_usec_sts <> 'PLANNED' THEN
137: fnd_message.set_name ('IGS','IGS_PS_USEC_STATUS_TO_PLANNED');
138: igs_ge_msg_stack.add;
139: app_exception.raise_exception;
140: END IF;
141:
142: -- get the unit version system status
143: l_c_unit_status := NULL;

Line 154: app_exception.raise_exception;

150: p_c_new_usec_sts NOT IN ('PLANNED', 'NOT_OFFERED') THEN
151: fnd_message.set_name ('IGS','IGS_PS_PLN_UNT_VER');
152: fnd_message.set_token('STATUS',get_meaning('UNIT_SECTION_STATUS', p_c_new_usec_sts));
153: igs_ge_msg_stack.add;
154: app_exception.raise_exception;
155: END IF;
156:
157: -- Following Status transition are invalid.
158: -- (2) PLANNED -> FULLWAITOK, (5) PLANNED -> CLOSED, (27) CANCELLED -> FULLWAITOK, (29) CANCELLED -> CLOSED

Line 165: app_exception.raise_exception;

161: fnd_message.set_name('IGS','IGS_PS_INVALID_STATE_TRANS' );
162: fnd_message.set_token('OLD_STATUS_DESC', get_meaning('UNIT_SECTION_STATUS',p_c_old_usec_sts));
163: fnd_message.set_token('NEW_STATUS_DESC', get_meaning('UNIT_SECTION_STATUS',p_c_new_usec_sts));
164: igs_ge_msg_stack.add;
165: app_exception.raise_exception;
166: END IF;
167:
168: -- Can reach 'HOLD' status only from FULLWAITOK,OPEN and CLOSED.
169: -- Following status transitions are valid

Line 179: app_exception.raise_exception;

175: fnd_message.set_name('IGS','IGS_PS_INVALID_STATE_TRANS' );
176: fnd_message.set_token('OLD_STATUS_DESC', get_meaning('UNIT_SECTION_STATUS',p_c_old_usec_sts));
177: fnd_message.set_token('NEW_STATUS_DESC', get_meaning('UNIT_SECTION_STATUS',p_c_new_usec_sts));
178: igs_ge_msg_stack.add;
179: app_exception.raise_exception;
180: END IF;
181:
182:
183: -- Can Cancel the unit section status if it does not have unit attempt or have unit attempt in unit attempt status 'DISCONTIN' and/or 'DROPPED'.

Line 194: app_exception.raise_exception;

190: fnd_message.set_name('IGS','IGS_PS_USEC_STATUS_PLN_CNC');
191: fnd_message.set_token('SUASTATUS',get_meaning('UNIT_ATTEMPT_STATUS',l_c_unit_attempt_status));
192: -- IGS_PS_USEC_STATUS_CNC'); -- "Unit Section status cannot be changed to Cancelled as there exists student unit attempt which is not discontinued"
193: igs_ge_msg_stack.add;
194: app_exception.raise_exception;
195: END IF;
196: CLOSE c_discontin;
197: END IF;
198:

Line 208: app_exception.raise_exception;

204: IF c_exist%FOUND THEN
205: CLOSE c_exist;
206: fnd_message.set_name ('IGS','IGS_PS_CNT_UPD_NOT_OFFERED');
207: igs_ge_msg_stack.add;
208: app_exception.raise_exception;
209: END IF;
210: CLOSE c_exist;
211: END IF;
212:

Line 222: app_exception.raise_exception;

218: fnd_message.set_name('IGS','IGS_PS_INVALID_STATE_TRANS' );
219: fnd_message.set_token('OLD_STATUS_DESC', get_meaning('UNIT_SECTION_STATUS',p_c_old_usec_sts));
220: fnd_message.set_token('NEW_STATUS_DESC', get_meaning('UNIT_SECTION_STATUS',p_c_new_usec_sts));
221: igs_ge_msg_stack.add;
222: app_exception.raise_exception;
223: END IF;
224:
225: END check_status_transition;
226:

Line 340: App_Exception.Raise_Exception;

336: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
337: Close cur_old_ref_values;
338: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
339: IGS_GE_MSG_STACK.ADD;
340: App_Exception.Raise_Exception;
341: Return;
342: END IF;
343: Close cur_old_ref_values;
344:

Line 424: app_exception.raise_exception;

420: new_references.unit_section_start_date IS NULL
421: )THEN
422: fnd_message.set_name ('IGS','IGS_EN_OFFSET_DT_NULL');
423: igs_ge_msg_stack.add;
424: app_exception.raise_exception;
425: END IF;
426:
427: -- Set variables.
428: IF p_deleting THEN

Line 446: App_Exception.Raise_Exception;

442: v_version_number,
443: v_message_name) = FALSE THEN
444: Fnd_Message.Set_Name('IGS',v_message_name);
445: IGS_GE_MSG_STACK.ADD;
446: App_Exception.Raise_Exception;
447: END IF;
448: -- IF IGS_aS_VAL_uai.crsp_val_crs_ci (
449: -- v_cal_type,
450: -- v_ci_sequence_number,

Line 462: App_Exception.Raise_Exception;

458: new_references.cal_type,
459: v_message_name) = FALSE THEN
460: Fnd_Message.Set_Name('IGS','IGS_PS_UOO_UAI_CANNOT_CREATE');
461: IGS_GE_MSG_STACK.ADD;
462: App_Exception.Raise_Exception;
463: END IF;
464: -- Validate IGS_AD_LOCATION code. IGS_AD_LOCATION code is not updateable.
465: IF IGS_PS_VAL_UOo.crsp_val_loc_cd (
466: new_references.location_cd,

Line 470: App_Exception.Raise_Exception;

466: new_references.location_cd,
467: v_message_name) = FALSE THEN
468: Fnd_Message.Set_Name('IGS',v_message_name);
469: IGS_GE_MSG_STACK.ADD;
470: App_Exception.Raise_Exception;
471: END IF;
472: -- Validate IGS_PS_UNIT class. IGS_PS_UNIT class is not updateable.
473: IF IGS_PS_VAL_UOo.crsp_val_uoo_uc (
474: new_references.unit_class,

Line 478: App_Exception.Raise_Exception;

474: new_references.unit_class,
475: v_message_name) = FALSE 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: IF p_inserting OR p_updating THEN
482: -- Validate grading schema.

Line 489: App_Exception.Raise_Exception;

485: new_references.gs_version_number,
486: v_message_name) = FALSE THEN
487: Fnd_Message.Set_Name('IGS',v_message_name);
488: IGS_GE_MSG_STACK.ADD;
489: App_Exception.Raise_Exception;
490: END IF;
491: END IF;
492: -- Validate IGS_PS_UNIT contact.
493: IF new_references.unit_contact IS NOT NULL AND

Line 500: App_Exception.Raise_Exception;

496: new_references.unit_contact,
497: v_message_name) = FALSE THEN
498: Fnd_Message.Set_Name('IGS',v_message_name);
499: IGS_GE_MSG_STACK.ADD;
500: App_Exception.Raise_Exception;
501: END IF;
502: END IF;
503:
504: -- Validate that atleast one enrollment method is checked

Line 509: App_Exception.Raise_Exception;

505: IF p_inserting or p_updating THEN
506: IF NOT (new_references.ss_enrol_ind = 'Y' or new_references.ivrs_available_ind = 'Y') THEN
507: Fnd_Message.Set_Name('IGS','IGS_PS_ONE_UNIT_ENR_MTHD');
508: IGS_GE_MSG_STACK.ADD;
509: App_Exception.Raise_Exception;
510: END IF;
511: END IF;
512:
513: --Record cannot be updated if the values of location_cd and unit_class unit_class r different

Line 519: App_Exception.Raise_Exception;

515: IF new_references.location_cd<> old_references.location_cd OR
516: new_references.unit_class<> old_references.unit_class THEN
517: Fnd_message.Set_Name('IGS','IGS_PS_UPDN_LOCCD_UNTCLS');
518: IGS_GE_MSG_STACK.ADD;
519: App_Exception.Raise_Exception;
520: END IF;
521: END IF;
522: END BeforeRowInsertUpdateDelete1;
523:

Line 601: App_Exception.Raise_Exception;

597:
598: IF Get_UK_For_Validation (new_references.uoo_id) THEN
599: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
600: IGS_GE_MSG_STACK.ADD;
601: App_Exception.Raise_Exception;
602: END IF;
603:
604: END Check_Uniqueness;
605:

Line 668: App_Exception.Raise_Exception;

664: IF Upper(Column_Name)='CAL_TYPE' OR Column_Name IS NULL Then
665: IF New_References.Cal_Type <> UPPER(New_References.Cal_Type) Then
666: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
667: IGS_GE_MSG_STACK.ADD;
668: App_Exception.Raise_Exception;
669: END IF;
670: END IF;
671:
672: IF Upper(Column_Name)='GRADING_SCHEMA_CD' OR Column_Name IS NULL Then

Line 676: App_Exception.Raise_Exception;

672: IF Upper(Column_Name)='GRADING_SCHEMA_CD' OR Column_Name IS NULL Then
673: IF New_References.Grading_Schema_Cd <> UPPER(New_References.Grading_Schema_Cd) Then
674: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
675: IGS_GE_MSG_STACK.ADD;
676: App_Exception.Raise_Exception;
677: END IF;
678: END IF;
679:
680: IF Upper(Column_Name)='GRADING_SCHEMA_PRCDNCE_IND' OR Column_Name IS NULL Then

Line 685: App_Exception.Raise_Exception;

681:
682: IF New_References.grading_schema_prcdnce_ind NOT IN ( 'Y' , 'N' ) Then
683: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
684: IGS_GE_MSG_STACK.ADD;
685: App_Exception.Raise_Exception;
686: END IF;
687:
688: END IF;
689:

Line 695: App_Exception.Raise_Exception;

691:
692: IF New_References.ivrs_available_ind NOT IN ( 'Y' , 'N' ) Then
693: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
694: IGS_GE_MSG_STACK.ADD;
695: App_Exception.Raise_Exception;
696: END IF;
697:
698: END IF;
699:

Line 705: App_Exception.Raise_Exception;

701:
702: IF New_References.Offered_ind NOT IN ( 'Y' , 'N' ) 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:
708: END IF;
709:

Line 714: App_Exception.Raise_Exception;

710: IF Upper(Column_Name)='LOCATION_CD' OR Column_Name IS NULL Then
711: IF New_References.Location_Cd <> UPPER(New_References.Location_Cd) 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:
718: IF Upper(Column_Name)='UNIT_CD' OR Column_Name IS NULL Then

Line 722: App_Exception.Raise_Exception;

718: IF Upper(Column_Name)='UNIT_CD' OR Column_Name IS NULL Then
719: IF New_References.Unit_Cd <> UPPER(New_References.Unit_CD) Then
720: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
721: IGS_GE_MSG_STACK.ADD;
722: App_Exception.Raise_Exception;
723: END IF;
724: END IF;
725:
726: IF Upper(Column_Name)='UNIT_CLASS' OR Column_Name IS NULL Then

Line 730: App_Exception.Raise_Exception;

726: IF Upper(Column_Name)='UNIT_CLASS' OR Column_Name IS NULL Then
727: IF New_References.Unit_Class <> UPPER(New_References.Unit_Class) Then
728: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
729: IGS_GE_MSG_STACK.ADD;
730: App_Exception.Raise_Exception;
731: END IF;
732: END IF;
733:
734: IF Upper(Column_Name)='UNIT_QUOTA' OR Column_Name IS NULL Then

Line 738: App_Exception.Raise_Exception;

734: IF Upper(Column_Name)='UNIT_QUOTA' OR Column_Name IS NULL Then
735: IF New_References.Unit_Quota < 0 OR New_References.Unit_Quota > 999999 Then
736: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
737: IGS_GE_MSG_STACK.ADD;
738: App_Exception.Raise_Exception;
739: END IF;
740: END IF;
741:
742: IF Upper(Column_Name)='CI_SEQUENCE_NUMBER' OR Column_Name IS NULL Then

Line 746: App_Exception.Raise_Exception;

742: IF Upper(Column_Name)='CI_SEQUENCE_NUMBER' OR Column_Name IS NULL Then
743: IF New_References.Ci_sequence_Number < 1 OR New_References.Ci_sequence_Number > 999999 Then
744: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
745: IGS_GE_MSG_STACK.ADD;
746: App_Exception.Raise_Exception;
747: END IF;
748: END IF;
749:
750:

Line 756: App_Exception.Raise_Exception;

752: IF (Upper(Column_Name)='SS_ENROL_IND' OR Upper(Column_Name)='IVRS_AVAILABLE_IND') OR Column_Name is NULL THEN
753: IF NOT (new_references.ss_enrol_ind = 'Y' OR new_references.ivrs_available_ind = 'Y') THEN
754: Fnd_Message.Set_Name('IGS','IGS_PS_ONE_UNIT_ENR_MTHD');
755: IGS_GE_MSG_STACK.ADD;
756: App_Exception.Raise_Exception;
757: END IF;
758: END IF;
759:
760: -- Added by Prem Raj for the build of PSCR017 bug #2224366

Line 766: App_Exception.Raise_Exception;

762: IF Upper(Column_Name)= 'NON_STD_USEC_IND' OR Column_Name IS NULL Then
763: IF New_References.Non_std_usec_ind NOT IN ( 'Y' , 'N' ) 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:
770: --Added by shtatiko as part of Bug# 2636716, EN Integration

Line 775: App_Exception.Raise_Exception;

771: IF Upper(Column_Name)= 'AUDITABLE_IND' OR Column_Name IS NULL Then
772: IF New_References.auditable_ind NOT IN ( 'Y' , 'N' ) Then
773: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
774: IGS_GE_MSG_STACK.ADD;
775: App_Exception.Raise_Exception;
776: END IF;
777: END IF;
778:
779: IF Upper(Column_Name)= 'AUDIT_PERMISSION_IND' OR Column_Name IS NULL Then

Line 783: App_Exception.Raise_Exception;

779: IF Upper(Column_Name)= 'AUDIT_PERMISSION_IND' OR Column_Name IS NULL Then
780: IF New_References.audit_permission_ind NOT IN ( 'Y' , 'N' ) Then
781: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
782: IGS_GE_MSG_STACK.ADD;
783: App_Exception.Raise_Exception;
784: END IF;
785: END IF;
786:
787: IF Upper(Column_Name)='UNIT_QUOTA_RESERVED_PLACES' OR Column_Name IS NULL Then

Line 791: App_Exception.Raise_Exception;

787: IF Upper(Column_Name)='UNIT_QUOTA_RESERVED_PLACES' OR Column_Name IS NULL Then
788: IF New_References.unit_quota_reserved_places < 0 OR New_References.unit_quota_reserved_places > 999999 Then
789: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
790: IGS_GE_MSG_STACK.ADD;
791: App_Exception.Raise_Exception;
792: END IF;
793: END IF;
794:
795: IF UPPER(column_name)= 'NOT_MULTIPLE_SECTION_FLAG' OR column_name IS NULL THEN

Line 799: app_exception.raise_exception;

795: IF UPPER(column_name)= 'NOT_MULTIPLE_SECTION_FLAG' OR column_name IS NULL THEN
796: IF new_references.not_multiple_section_flag NOT IN ('Y','N') THEN
797: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
798: igs_ge_msg_stack.add;
799: app_exception.raise_exception;
800: END IF;
801: END IF;
802:
803: IF UPPER(column_name)= 'DEFAULT_ENROLL_FLAG' OR column_name IS NULL THEN

Line 807: app_exception.raise_exception;

803: IF UPPER(column_name)= 'DEFAULT_ENROLL_FLAG' OR column_name IS NULL THEN
804: IF new_references.default_enroll_flag NOT IN ('Y','N') THEN
805: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
806: igs_ge_msg_stack.add;
807: app_exception.raise_exception;
808: END IF;
809: END IF;
810:
811: IF UPPER(column_name)= 'ABORT_FLAG' OR column_name IS NULL THEN

Line 815: app_exception.raise_exception;

811: IF UPPER(column_name)= 'ABORT_FLAG' OR column_name IS NULL THEN
812: IF new_references.abort_flag NOT IN ('Y','N') THEN
813: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
814: igs_ge_msg_stack.add;
815: app_exception.raise_exception;
816: END IF;
817: END IF;
818:
819: END Check_Constraints;

Line 854: App_Exception.Raise_Exception;

850: new_references.grading_schema_cd,
851: new_references.gs_version_number) THEN
852: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
853: IGS_GE_MSG_STACK.ADD;
854: App_Exception.Raise_Exception;
855: END IF;
856:
857: END IF;
858:

Line 867: App_Exception.Raise_Exception;

863: IF NOT IGS_AD_LOCATION_PKG.Get_PK_For_Validation (
864: new_references.location_cd, 'N') THEN
865: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
866: IGS_GE_MSG_STACK.ADD;
867: App_Exception.Raise_Exception;
868: END IF;
869:
870: END IF;
871:

Line 880: App_Exception.Raise_Exception;

876: IF NOT IGS_PE_PERSON_PKG.Get_PK_For_Validation (
877: new_references.unit_contact) THEN
878: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
879: IGS_GE_MSG_STACK.ADD;
880: App_Exception.Raise_Exception;
881: END IF;
882:
883: END IF;
884:

Line 893: App_Exception.Raise_Exception;

889: IF NOT IGS_AS_UNIT_CLASS_PKG.Get_PK_For_Validation (
890: new_references.unit_class) THEN
891: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
892: IGS_GE_MSG_STACK.ADD;
893: App_Exception.Raise_Exception;
894: END IF;
895:
896: END IF;
897:

Line 915: App_Exception.Raise_Exception;

911: new_references.cal_type,
912: new_references.ci_sequence_number) THEN
913: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
914: IGS_GE_MSG_STACK.ADD;
915: App_Exception.Raise_Exception;
916: END IF;
917:
918: END IF;
919:

Line 931: app_exception.raise_exception;

927: IF c_check_hz_exists%NOTFOUND THEN
928: CLOSE c_check_hz_exists;
929: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
930: igs_ge_msg_stack.add;
931: app_exception.raise_exception;
932: ELSE
933: CLOSE c_check_hz_exists;
934: END IF;
935: END IF;

Line 946: App_Exception.Raise_Exception;

942: new_references.rev_account_cd
943: ) THEN
944: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
945: IGS_GE_MSG_STACK.ADD;
946: App_Exception.Raise_Exception;
947: END IF;
948: END IF;
949:
950: --check the existance of sup_uoo_id as a uoo_id

Line 960: App_Exception.Raise_Exception;

956: new_references.sup_uoo_id
957: ) THEN
958: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
959: IGS_GE_MSG_STACK.ADD;
960: App_Exception.Raise_Exception;
961: END IF;
962: END IF;
963:
964: END Check_Parent_Existance;

Line 1095: App_Exception.Raise_Exception;

1091: IF (cur_rowid%FOUND) THEN
1092: Close cur_rowid;
1093: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UOO_UOO_FK');
1094: IGS_GE_MSG_STACK.ADD;
1095: App_Exception.Raise_Exception;
1096: Return;
1097: END IF;
1098: Close cur_rowid;
1099:

Line 1419: App_Exception.Raise_Exception;

1415: IF (cur_rowid%FOUND) THEN
1416: Close cur_rowid;
1417: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UOO_GS_FK');
1418: IGS_GE_MSG_STACK.ADD;
1419: App_Exception.Raise_Exception;
1420: Return;
1421: END IF;
1422: Close cur_rowid;
1423:

Line 1455: App_Exception.Raise_Exception;

1451: IF (cur_rowid%FOUND) THEN
1452: Close cur_rowid;
1453: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UOO_LOC_FK');
1454: IGS_GE_MSG_STACK.ADD;
1455: App_Exception.Raise_Exception;
1456: Return;
1457: END IF;
1458: Close cur_rowid;
1459:

Line 1491: App_Exception.Raise_Exception;

1487: IF (cur_rowid%FOUND) THEN
1488: Close cur_rowid;
1489: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UOO_PE_FK');
1490: IGS_GE_MSG_STACK.ADD;
1491: App_Exception.Raise_Exception;
1492: Return;
1493: END IF;
1494: Close cur_rowid;
1495:

Line 1533: App_Exception.Raise_Exception;

1529: IF (cur_rowid%FOUND) THEN
1530: Close cur_rowid;
1531: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UOO_UOP_FK');
1532: IGS_GE_MSG_STACK.ADD;
1533: App_Exception.Raise_Exception;
1534: Return;
1535: END IF;
1536: Close cur_rowid;
1537:

Line 1697: App_Exception.Raise_Exception;

1693: New_References.location_cd,
1694: New_References.unit_class) THEN
1695: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
1696: IGS_GE_MSG_STACK.ADD;
1697: App_Exception.Raise_Exception;
1698: END IF;
1699: Check_Uniqueness;
1700: Check_Constraints;
1701: Check_Parent_Existance;

Line 1762: App_Exception.Raise_Exception;

1758: New_References.location_cd,
1759: New_References.unit_class) THEN
1760: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
1761: IGS_GE_MSG_STACK.ADD;
1762: App_Exception.Raise_Exception;
1763: END IF;
1764: Check_Uniqueness;
1765: Check_Constraints;
1766: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 1786: App_Exception.Raise_Exception;

1782: IF cur_teach_to_load%NOTFOUND THEN
1783: CLOSE cur_teach_to_load;
1784: fnd_message.set_name('IGS','IGS_PS_TECH_NO_LOAD_CAL_EXST');
1785: IGS_GE_MSG_STACK.ADD;
1786: App_Exception.Raise_Exception;
1787: END IF;
1788: CLOSE cur_teach_to_load;
1789:
1790: --check the call number uniqueness

Line 1795: App_Exception.Raise_Exception;

1791: IF ((FND_PROFILE.VALUE('IGS_PS_CALL_NUMBER') = 'USER_DEFINED') AND (x_call_number IS NOT NULL) ) THEN
1792: IF NOT check_call_number(x_cal_type,x_ci_sequence_number,x_call_number,x_rowid) THEN
1793: Fnd_Message.Set_Name ('IGS', 'IGS_PS_DUPLICATE_CALL_NUMBER');
1794: IGS_GE_MSG_STACK.ADD;
1795: App_Exception.Raise_Exception;
1796: END IF;
1797: END IF;
1798:
1799: ELSIF p_action IN ('UPDATE','VALIDATE_UPDATE') THEN

Line 1810: App_Exception.Raise_Exception;

1806: IF ((FND_PROFILE.VALUE('IGS_PS_CALL_NUMBER') = 'USER_DEFINED') AND (x_call_number IS NOT NULL) ) THEN
1807: IF NOT check_call_number(x_cal_type,x_ci_sequence_number,x_call_number,x_rowid) THEN
1808: Fnd_Message.Set_Name ('IGS', 'IGS_PS_DUPLICATE_CALL_NUMBER');
1809: IGS_GE_MSG_STACK.ADD;
1810: App_Exception.Raise_Exception;
1811: END IF;
1812: END IF;
1813:
1814: END IF;

Line 1971: app_exception.raise_exception;

1967: EXCEPTION
1968: WHEN OTHERS THEN
1969: -- If an error occurs during insertion in igs_ps_ref_cd then raise an exception.
1970: igs_ge_msg_stack.add;
1971: app_exception.raise_exception;
1972: RETURN;
1973: END dflt_usec_ref_code;
1974:
1975: PROCEDURE After_DML (

Line 2117: app_exception.raise_exception;

2113: end if;
2114: else
2115: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
2116: IGS_GE_MSG_STACK.ADD;
2117: app_exception.raise_exception;
2118: end if;
2119:
2120:
2121:

Line 2182: app_exception.raise_exception;

2178: IF FND_PROFILE.VALUE('IGS_PS_CALL_NUMBER') = 'AUTO' THEN
2179: x_call_number := get_call_number(new_references.cal_type, new_references.ci_sequence_number);
2180: IF x_call_number = -1 THEN
2181: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
2182: app_exception.raise_exception;
2183: END IF;
2184: END IF;
2185:
2186: insert into IGS_PS_UNIT_OFR_OPT_ALL (

Line 2422: app_exception.raise_exception;

2418: if (c1%notfound) then
2419: close c1;
2420: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
2421: IGS_GE_MSG_STACK.ADD;
2422: app_exception.raise_exception;
2423: return;
2424: end if;
2425: close c1;
2426:

Line 2533: app_exception.raise_exception;

2529: null;
2530: else
2531: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
2532: IGS_GE_MSG_STACK.ADD;
2533: app_exception.raise_exception;
2534: end if;
2535: return;
2536: end LOCK_ROW;
2537:

Line 2626: app_exception.raise_exception;

2622: end if;
2623: else
2624: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
2625: IGS_GE_MSG_STACK.ADD;
2626: app_exception.raise_exception;
2627: end if;
2628:
2629: Before_DML(
2630: p_action=>'UPDATE',