DBA Data[Home] [Help]

APPS.IGS_PE_PERS_PREFS_PKG dependencies on IGS_GE_MSG_STACK

Line 53: IGS_GE_MSG_STACK.ADD;

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

Line 111: IGS_GE_MSG_STACK.ADD;

107: new_references.allow_stnd_req_ind <> 'N') OR
108: (p_updating AND
109: new_references.allow_stnd_req_ind <> old_references.allow_stnd_req_ind) THEN
110: Fnd_Message.Set_Name('IGS', 'IGS_AV_INSUFICIENT_PRIV');
111: IGS_GE_MSG_STACK.ADD;
112: App_Exception.Raise_Exception;
113: END IF;
114:
115:

Line 163: IGS_GE_MSG_STACK.ADD;

159: IF upper(column_name) = 'ADM_ACAD_CAL_TYPE' OR
160: column_name is null Then
161: IF new_references.adm_acad_cal_type <>UPPER(new_references.adm_acad_cal_type )Then
162: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
163: IGS_GE_MSG_STACK.ADD;
164: App_Exception.Raise_Exception;
165: END IF;
166: END IF;
167:

Line 172: IGS_GE_MSG_STACK.ADD;

168: IF upper(column_name) = 'ADM_ADMISSION_CAT' OR
169: column_name is null Then
170: IF new_references.adm_admission_cat <>UPPER(new_references.adm_admission_cat)Then
171: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
172: IGS_GE_MSG_STACK.ADD;
173: App_Exception.Raise_Exception;
174: END IF;
175: END IF;
176: IF upper(column_name) = 'ADM_ADM_CAL_TYPE' OR

Line 180: IGS_GE_MSG_STACK.ADD;

176: IF upper(column_name) = 'ADM_ADM_CAL_TYPE' OR
177: column_name is null Then
178: IF new_references.adm_adm_cal_type <>UPPER(new_references.adm_adm_cal_type ) Then
179: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
180: IGS_GE_MSG_STACK.ADD;
181: App_Exception.Raise_Exception;
182: END IF;
183: END IF;
184: IF upper(column_name) = 'ADM_S_ADMISSION_PROCESS_TYPE' OR

Line 188: IGS_GE_MSG_STACK.ADD;

184: IF upper(column_name) = 'ADM_S_ADMISSION_PROCESS_TYPE' OR
185: column_name is null Then
186: IF new_references.adm_s_admission_process_type <>UPPER(new_references.adm_s_admission_process_type) Then
187: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
188: IGS_GE_MSG_STACK.ADD;
189: App_Exception.Raise_Exception;
190: END IF;
191: END IF;
192: IF upper(column_name) = 'ENR_ACAD_CAL_TYPE' OR

Line 196: IGS_GE_MSG_STACK.ADD;

192: IF upper(column_name) = 'ENR_ACAD_CAL_TYPE' OR
193: column_name is null Then
194: IF new_references.enr_acad_cal_type <>UPPER(new_references.enr_acad_cal_type)Then
195: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
196: IGS_GE_MSG_STACK.ADD;
197: App_Exception.Raise_Exception;
198: END IF;
199: END IF;
200: IF upper(column_name) = 'ENR_ENROLMENT_CAT' OR

Line 204: IGS_GE_MSG_STACK.ADD;

200: IF upper(column_name) = 'ENR_ENROLMENT_CAT' OR
201: column_name is null Then
202: IF new_references.enr_enrolment_cat <>UPPER(new_references.enr_enrolment_cat ) Then
203: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
204: IGS_GE_MSG_STACK.ADD;
205: App_Exception.Raise_Exception;
206: END IF;
207: END IF;
208: IF upper(column_name) = 'ENR_ENR_METHOD_TYPE' OR

Line 212: IGS_GE_MSG_STACK.ADD;

208: IF upper(column_name) = 'ENR_ENR_METHOD_TYPE' OR
209: column_name is null Then
210: IF new_references.enr_enr_method_type <>UPPER(new_references.enr_enr_method_type) Then
211: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
212: IGS_GE_MSG_STACK.ADD;
213: App_Exception.Raise_Exception;
214: END IF;
215: END IF;
216: IF upper(column_name) = 'ADM_ADM_CI_SEQUENCE_NUMBER' OR

Line 220: IGS_GE_MSG_STACK.ADD;

216: IF upper(column_name) = 'ADM_ADM_CI_SEQUENCE_NUMBER' OR
217: column_name is null Then
218: IF new_references.adm_adm_ci_sequence_number < 0 OR new_references.adm_adm_ci_sequence_number > 999999 Then
219: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
220: IGS_GE_MSG_STACK.ADD;
221: App_Exception.Raise_Exception;
222: END IF;
223: END IF;
224: IF upper(column_name) = 'ALLOW_STND_REQ_IND' OR

Line 228: IGS_GE_MSG_STACK.ADD;

224: IF upper(column_name) = 'ALLOW_STND_REQ_IND' OR
225: column_name is null Then
226: IF new_references.allow_stnd_req_ind NOT IN ( 'Y' , 'N' ) Then
227: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
228: IGS_GE_MSG_STACK.ADD;
229: App_Exception.Raise_Exception;
230: END IF;
231: END IF;
232: IF upper(column_name) = 'ADM_ACAD_CI_SEQUENCE_NUMBER' OR

Line 236: IGS_GE_MSG_STACK.ADD;

232: IF upper(column_name) = 'ADM_ACAD_CI_SEQUENCE_NUMBER' OR
233: column_name is null Then
234: IF new_references.adm_acad_ci_sequence_number < 0 OR new_references.adm_acad_ci_sequence_number > 999999 Then
235: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
236: IGS_GE_MSG_STACK.ADD;
237: App_Exception.Raise_Exception;
238: END IF;
239: END IF;
240: IF upper(column_name) = 'ENR_ACAD_SEQUENCE_NUMBER' OR

Line 244: IGS_GE_MSG_STACK.ADD;

240: IF upper(column_name) = 'ENR_ACAD_SEQUENCE_NUMBER' OR
241: column_name is null Then
242: IF new_references.enr_acad_sequence_number < 0 OR new_references.enr_acad_sequence_number > 999999 Then
243: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
244: IGS_GE_MSG_STACK.ADD;
245: App_Exception.Raise_Exception;
246: END IF;
247: END IF;
248: IF upper(column_name) = 'ENR_ACAD_CI_SEQUENCE_NUMBER' OR

Line 252: IGS_GE_MSG_STACK.ADD;

248: IF upper(column_name) = 'ENR_ACAD_CI_SEQUENCE_NUMBER' OR
249: column_name is null Then
250: IF new_references.enq_acad_ci_sequence_number < 0 OR new_references.enq_acad_ci_sequence_number > 999999 Then
251: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
252: IGS_GE_MSG_STACK.ADD;
253: App_Exception.Raise_Exception;
254: END IF;
255: END IF;
256: IF upper(column_name) = 'ENQ_ADM_CI_SEQUENCE_NUMBER' OR

Line 260: IGS_GE_MSG_STACK.ADD;

256: IF upper(column_name) = 'ENQ_ADM_CI_SEQUENCE_NUMBER' OR
257: column_name is null Then
258: IF new_references.enq_adm_ci_sequence_number < 0 OR new_references.enq_adm_ci_sequence_number > 999999 Then
259: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
260: IGS_GE_MSG_STACK.ADD;
261: App_Exception.Raise_Exception;
262: END IF;
263: END IF;
264:

Line 280: IGS_GE_MSG_STACK.ADD;

276:
277: IF NOT IGS_PE_PERSON_PKG.Get_PK_For_Validation (
278: new_references.person_id) THEN
279: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
280: IGS_GE_MSG_STACK.ADD;
281: App_Exception.Raise_Exception;
282: END IF;
283: END IF;
284:

Line 331: IGS_GE_MSG_STACK.ADD;

327: Open cur_rowid;
328: Fetch cur_rowid INTO lv_rowid;
329: IF (cur_rowid%FOUND) THEN
330: Fnd_Message.Set_Name ('IGS', 'IGS_PE_PP_PE_FK');
331: IGS_GE_MSG_STACK.ADD;
332: Close cur_rowid;
333: App_Exception.Raise_Exception;
334: Return;
335: END IF;

Line 403: IGS_GE_MSG_STACK.ADD;

399: BeforeRowInsertUpdatedelete2 ( p_inserting => TRUE );
400: IF Get_PK_For_Validation (
401: new_references.person_id ) THEN
402: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
403: IGS_GE_MSG_STACK.ADD;
404: App_Exception.Raise_Exception;
405: END IF;
406:
407: Check_Constraints; -- if procedure present

Line 424: IGS_GE_MSG_STACK.ADD;

420: ELSIF (p_action = 'VALIDATE_INSERT') THEN
421: IF Get_PK_For_Validation (
422: new_references.person_id ) THEN
423: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
424: IGS_GE_MSG_STACK.ADD;
425: App_Exception.Raise_Exception;
426: END IF;
427:
428: Check_Constraints; -- if procedure present

Line 503: IGS_GE_MSG_STACK.ADD;

499: X_LAST_UPDATE_LOGIN := -1;
500: end if;
501: else
502: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
503: IGS_GE_MSG_STACK.ADD;
504: app_exception.raise_exception;
505: end if;
506: Before_DML(
507: p_action=>'INSERT',

Line 745: IGS_GE_MSG_STACK.ADD;

741: X_LAST_UPDATE_LOGIN := -1;
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: Before_DML(
749: p_action=>'UPDATE',