APPS.IGS_PE_RES_DTLS_PKG dependencies on APP_EXCEPTION

Line 89: App_Exception.Raise_Exception;

85: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
86: Close cur_old_ref_values;
87: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
88: IGS_GE_MSG_STACK.ADD;
89: App_Exception.Raise_Exception;
90: Return;
91: END IF;
92: Close cur_old_ref_values;
93:

Line 192: app_exception.raise_exception;

188: new_references.sequence_number
189: ) THEN
190: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
191: IGS_GE_MSG_STACK.ADD;
192: app_exception.raise_exception;
193: END IF;
194: END Check_Uniqueness ;
195:
196:

Line 224: App_Exception.Raise_Exception;

220: new_references.person_id
221: ) THEN
222: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
223: IGS_GE_MSG_STACK.ADD;
224: App_Exception.Raise_Exception;
225: END IF;
226:
227: END Check_Parent_Existance;
228:

Line 349: App_Exception.Raise_Exception;

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

Line 462: App_Exception.Raise_Exception;

458: IF Get_Pk_For_Validation(
459: new_references.resident_details_id) THEN
460: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
461: IGS_GE_MSG_STACK.ADD;
462: App_Exception.Raise_Exception;
463: END IF;
464: Check_Constraints;
465: Check_Uniqueness;
466: Check_Parent_Existance;

Line 482: App_Exception.Raise_Exception;

478: IF Get_PK_For_Validation (
479: new_references.resident_details_id) THEN
480: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
481: IGS_GE_MSG_STACK.ADD;
482: App_Exception.Raise_Exception;
483: END IF;
484: Check_Constraints;
485: Check_Uniqueness;
486: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 746: app_exception.raise_exception;

742: END if;
743: else
744: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
745: IGS_GE_MSG_STACK.ADD;
746: app_exception.raise_exception;
747: END if;
748: SELECT IGS_PE_RES_DTLS_S.NEXTVAL INTO X_RESIDENT_DETAILS_ID
749: FROM DUAL;
750:

Line 892: app_exception.raise_exception;

888: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
889: fnd_message.set_token ('ERR_CD', SQLCODE);
890: igs_ge_msg_stack.add;
891: igs_sc_gen_001.unset_ctx('R');
892: app_exception.raise_exception;
893: ELSE
894: igs_sc_gen_001.unset_ctx('R');
895: RAISE;
896: END IF;

Line 988: app_exception.raise_exception;

984: if (c1%notfound) then
985: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
986: IGS_GE_MSG_STACK.ADD;
987: close c1;
988: app_exception.raise_exception;
989: return;
990: END if;
991: close c1;
992: if ( ( tlinfo.PERSON_ID = X_PERSON_ID)

Line 1070: app_exception.raise_exception;

1066: null;
1067: else
1068: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1069: IGS_GE_MSG_STACK.ADD;
1070: app_exception.raise_exception;
1071: END if;
1072: return;
1073: END LOCK_ROW;
1074:

Line 1144: app_exception.raise_exception;

1140: END if;
1141: else
1142: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
1143: IGS_GE_MSG_STACK.ADD;
1144: app_exception.raise_exception;
1145: END if;
1146: Before_DML(
1147: p_action=>'UPDATE',
1148: x_rowid=>X_ROWID,

Line 1225: app_exception.raise_exception;

1221: if (sql%notfound) then
1222: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1223: igs_ge_msg_stack.add;
1224: igs_sc_gen_001.unset_ctx('R');
1225: app_exception.raise_exception;
1226: END if;
1227: IF (x_mode = 'S') THEN
1228: igs_sc_gen_001.unset_ctx('R');
1229: END IF;

Line 1242: app_exception.raise_exception;

1238: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1239: fnd_message.set_token ('ERR_CD', SQLCODE);
1240: igs_ge_msg_stack.add;
1241: igs_sc_gen_001.unset_ctx('R');
1242: app_exception.raise_exception;
1243: ELSE
1244: igs_sc_gen_001.unset_ctx('R');
1245: RAISE;
1246: END IF;

Line 1414: app_exception.raise_exception;

1410: if (sql%notfound) then
1411: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1412: igs_ge_msg_stack.add;
1413: igs_sc_gen_001.unset_ctx('R');
1414: app_exception.raise_exception;
1415: END if;
1416: IF (x_mode = 'S') THEN
1417: igs_sc_gen_001.unset_ctx('R');
1418: END IF;