DBA Data[Home] [Help]

APPS.IGS_AD_UNIT_SETS_PKG dependencies on APP_EXCEPTION

Line 54: App_Exception.Raise_Exception;

50: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
51: Close cur_old_ref_values;
52: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
53: IGS_GE_MSG_STACK.ADD;
54: App_Exception.Raise_Exception;
55: Return;
56: END IF;
57: Close cur_old_ref_values;
58:

Line 110: App_Exception.Raise_Exception;

106: IF NOT (new_references.rank > 0) THEN
107: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
108: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_SS_DSRD_RANK_NONEGATE'));
109: IGS_GE_MSG_STACK.ADD;
110: App_Exception.Raise_Exception;
111: END IF;
112: END IF;
113: END Check_Constraints;
114:

Line 137: app_exception.raise_exception;

133: ,new_references.person_id
134: ) THEN
135: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
136: IGS_GE_MSG_STACK.ADD;
137: app_exception.raise_exception;
138: END IF;
139: END Check_Uniqueness ;
140:
141: PROCEDURE Check_Parent_Existance AS

Line 173: App_Exception.Raise_Exception;

169: ) THEN
170: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
171: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PROGRAM_APPL'));
172: IGS_GE_MSG_STACK.ADD;
173: App_Exception.Raise_Exception;
174: END IF;
175:
176: IF (((old_references.unit_set_cd = new_references.unit_set_cd) AND
177: (old_references.version_number = new_references.version_number)) OR

Line 188: App_Exception.Raise_Exception;

184: ) THEN
185: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
186: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_PS_UNIT_SET'));
187: IGS_GE_MSG_STACK.ADD;
188: App_Exception.Raise_Exception;
189: END IF;
190:
191: END Check_Parent_Existance;
192:

Line 311: App_Exception.Raise_Exception;

307: IF (cur_rowid%FOUND) THEN
308: Close cur_rowid;
309: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AUTS_ACAI_FK');
310: IGS_GE_MSG_STACK.ADD;
311: App_Exception.Raise_Exception;
312: Return;
313: END IF;
314: Close cur_rowid;
315:

Line 347: App_Exception.Raise_Exception;

343: IF (cur_rowid%FOUND) THEN
344: Close cur_rowid;
345: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AUTS_EUS_FK');
346: IGS_GE_MSG_STACK.ADD;
347: App_Exception.Raise_Exception;
348: Return;
349: END IF;
350: Close cur_rowid;
351:

Line 395: App_Exception.Raise_Exception;

391: IF (cur_rowid%FOUND) THEN
392: Close cur_rowid;
393: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AUTS_EUS_FK');
394: IGS_GE_MSG_STACK.ADD;
395: App_Exception.Raise_Exception;
396: Return;
397: END IF;
398: Close cur_rowid;
399:

Line 577: App_Exception.Raise_Exception;

573: IF Get_Pk_For_Validation(
574: new_references.unit_set_id) THEN
575: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
576: IGS_GE_MSG_STACK.ADD;
577: App_Exception.Raise_Exception;
578: END IF;
579:
580: IF NOT Validate_Unit_Set(
581: new_references.version_number

Line 593: App_Exception.Raise_Exception;

589: ,c_appl_rec.attendance_type
590: ) THEN
591: Fnd_Message.Set_name('IGS','IGS_AD_PRGOFOP_NOT_VALID');
592: IGS_GE_MSG_STACK.ADD;
593: App_Exception.Raise_Exception;
594: END IF;
595:
596: Check_Uniqueness;
597: Check_Constraints;

Line 614: App_Exception.Raise_Exception;

610: ,c_appl_rec.attendance_type
611: ) THEN
612: Fnd_Message.Set_name('IGS','IGS_AD_PRGOFOP_NOT_VALID');
613: IGS_GE_MSG_STACK.ADD;
614: App_Exception.Raise_Exception;
615: END IF;
616: Check_Uniqueness;
617: Check_Constraints;
618: Check_Parent_Existance;

Line 628: App_Exception.Raise_Exception;

624: IF Get_PK_For_Validation (
625: new_references.unit_set_id) THEN
626: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
627: IGS_GE_MSG_STACK.ADD;
628: App_Exception.Raise_Exception;
629: END IF;
630:
631: Check_Uniqueness;
632: Check_Constraints;

Line 739: app_exception.raise_exception;

735: end if;
736: else
737: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
738: IGS_GE_MSG_STACK.ADD;
739: app_exception.raise_exception;
740: end if;
741:
742: X_UNIT_SET_ID := -1;
743: Before_DML(

Line 827: app_exception.raise_exception;

823: -- that the ownerof policy function does not have privilege to access.
824: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
825: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
826: IGS_GE_MSG_STACK.ADD;
827: app_exception.raise_exception;
828: ELSE
829: RAISE;
830: END IF;
831: end INSERT_ROW;

Line 872: app_exception.raise_exception;

868: if (c1%notfound) then
869: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
870: IGS_GE_MSG_STACK.ADD;
871: close c1;
872: app_exception.raise_exception;
873: return;
874: end if;
875: close c1;
876: if ( ( tlinfo.PERSON_ID = X_PERSON_ID)

Line 888: app_exception.raise_exception;

884: null;
885: else
886: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
887: IGS_GE_MSG_STACK.ADD;
888: app_exception.raise_exception;
889: end if;
890: return;
891: end LOCK_ROW;
892: Procedure UPDATE_ROW (

Line 940: app_exception.raise_exception;

936: end if;
937: else
938: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
939: IGS_GE_MSG_STACK.ADD;
940: app_exception.raise_exception;
941: end if;
942: Before_DML(
943: p_action=>'UPDATE',
944: x_rowid=>X_ROWID,

Line 998: app_exception.raise_exception;

994: igs_ge_msg_stack.add;
995: IF (x_mode = 'S') THEN
996: igs_sc_gen_001.unset_ctx('R');
997: END IF;
998: app_exception.raise_exception;
999: end if;
1000: IF (x_mode = 'S') THEN
1001: igs_sc_gen_001.unset_ctx('R');
1002: END IF;

Line 1023: app_exception.raise_exception;

1019: -- that the ownerof policy function does not have privilege to access.
1020: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1021: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
1022: IGS_GE_MSG_STACK.ADD;
1023: app_exception.raise_exception;
1024: ELSE
1025: RAISE;
1026: END IF;
1027: end UPDATE_ROW;

Line 1117: app_exception.raise_exception;

1113: igs_ge_msg_stack.add;
1114: IF (x_mode = 'S') THEN
1115: igs_sc_gen_001.unset_ctx('R');
1116: END IF;
1117: app_exception.raise_exception;
1118: end if;
1119: IF (x_mode = 'S') THEN
1120: igs_sc_gen_001.unset_ctx('R');
1121: END IF;

Line 1141: app_exception.raise_exception;

1137: -- that the ownerof policy function does not have privilege to access.
1138: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1139: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
1140: IGS_GE_MSG_STACK.ADD;
1141: app_exception.raise_exception;
1142: ELSE
1143: RAISE;
1144: END IF;
1145: end DELETE_ROW;