DBA Data[Home] [Help]

APPS.IGS_PE_ALT_PERS_ID_PKG dependencies on IGS_EN_VAL_API

Line 7: --smadathi 28-AUG-2001 Bug No. 1956374 .The Call to igs_en_val_api.genp_val_strt_end_dt

3: -------------------------------------------------------------------------------------------
4: --Change History:
5: --Who When What
6: --avenkatr 09-OCT-2001 Bug No. 2037667 .Comparision in the Lock_row procedure of the Start_dt and End_dt has been changed to compare only the date part.
7: --smadathi 28-AUG-2001 Bug No. 1956374 .The Call to igs_en_val_api.genp_val_strt_end_dt
8: -- is replaced by igs_ad_val_edtl.genp_val_strt_end_dt
9: --smadathi 24-AUG-2001 Bug No. 1956374 .The call to igs_en_val_api.genp_val_sdtt_sess
10: -- is changed to igs_as_val_suaap.genp_val_sdtt_sess
11: --

Line 9: --smadathi 24-AUG-2001 Bug No. 1956374 .The call to igs_en_val_api.genp_val_sdtt_sess

5: --Who When What
6: --avenkatr 09-OCT-2001 Bug No. 2037667 .Comparision in the Lock_row procedure of the Start_dt and End_dt has been changed to compare only the date part.
7: --smadathi 28-AUG-2001 Bug No. 1956374 .The Call to igs_en_val_api.genp_val_strt_end_dt
8: -- is replaced by igs_ad_val_edtl.genp_val_strt_end_dt
9: --smadathi 24-AUG-2001 Bug No. 1956374 .The call to igs_en_val_api.genp_val_sdtt_sess
10: -- is changed to igs_as_val_suaap.genp_val_sdtt_sess
11: --
12: -- who when what
13: -- CDCRUZ Sep 24,2002 Bug ID : 2000408

Line 86: new_references.api_person_id_uf := igs_en_val_api.unformat_api(x_api_person_id);

82: END IF;
83:
84: new_references.pe_person_id := x_pe_person_id;
85: new_references.api_person_id := x_api_person_id;
86: new_references.api_person_id_uf := igs_en_val_api.unformat_api(x_api_person_id);
87: new_references.person_id_type := x_person_id_type;
88: new_references.start_dt := trunc(x_start_dt);
89: new_references.end_dt := trunc(x_end_dt);
90: new_references.attribute_category := x_attribute_category ;

Line 170: IF NOT igs_en_val_api.fm_equal(new_references.api_person_id, format_mask_rec.format_mask) THEN

166: FETCH format_mask_cur INTO format_mask_rec;
167: CLOSE format_mask_cur;
168:
169: IF format_mask_rec.format_mask IS NOT NULL THEN
170: IF NOT igs_en_val_api.fm_equal(new_references.api_person_id, format_mask_rec.format_mask) THEN
171: FND_MESSAGE.SET_NAME('IGS','IGS_PE_PID_MASK');
172: FND_MESSAGE.SET_TOKEN('FORMAT',format_mask_rec.format_mask);
173: IGS_GE_MSG_STACK.ADD;
174: APP_EXCEPTION.RAISE_EXCEPTION;

Line 184: -- As part of the bug 1956374 changed the following call from IGS_EN_VAL_API.enrp_val_api_end_dt

180: -- Validate START DATE AND END DATE.
181: IF p_inserting OR p_updating THEN
182:
183: -- Validate that if end date is specified, then start date is also specified.
184: -- As part of the bug 1956374 changed the following call from IGS_EN_VAL_API.enrp_val_api_end_dt
185: IF IGS_EN_VAL_PAL.enrp_val_api_end_dt (
186: new_references.start_dt,
187: new_references.end_dt,
188: v_message_name) = FALSE THEN

Line 246: -- Added the call igs_en_val_api.val_overlap_api so that there would be only one ACTIVE

242: --
243: --Change History:
244: --Who When What
245: --pkpatel 8-JUN-2002 Bug No: 2402077
246: -- Added the call igs_en_val_api.val_overlap_api so that there would be only one ACTIVE
247: -- alternate person id exist for a person ID type for a person
248: -- Added the call igs_en_val_api.val_ssn_overlap_api so that there would be only one ACTIVE
249: -- alternate person id exist for Social Security Number for a person
250: --ssaleem 17-Sep-2004 Bug 3787210 -- added Closed Ind igs_pe_person_id_typ table

Line 248: -- Added the call igs_en_val_api.val_ssn_overlap_api so that there would be only one ACTIVE

244: --Who When What
245: --pkpatel 8-JUN-2002 Bug No: 2402077
246: -- Added the call igs_en_val_api.val_overlap_api so that there would be only one ACTIVE
247: -- alternate person id exist for a person ID type for a person
248: -- Added the call igs_en_val_api.val_ssn_overlap_api so that there would be only one ACTIVE
249: -- alternate person id exist for Social Security Number for a person
250: --ssaleem 17-Sep-2004 Bug 3787210 -- added Closed Ind igs_pe_person_id_typ table
251: --gmaheswa 29-Sep-2004 BUG 3787210 removed Closed indicator check for the Alternate Person Id type while end date overlap check.
252:

Line 286: IF IGS_EN_VAL_API.enrp_val_api_pan (

282: OPEN c_pit (new_references.person_id_type);
283: FETCH c_pit INTO v_dummy;
284: IF (c_pit%FOUND) THEN
285: CLOSE c_pit;
286: IF IGS_EN_VAL_API.enrp_val_api_pan (
287: new_references.pe_person_id,
288: new_references.api_person_id,
289: v_message_name) = FALSE THEN
290: Fnd_Message.Set_Name('IGS', v_message_name);

Line 301: IF NOT igs_en_val_api.val_overlap_api(new_references.pe_person_id) THEN

297: END IF;
298:
299:
300: IF l_s_person_id_type <> 'SSN' THEN
301: IF NOT igs_en_val_api.val_overlap_api(new_references.pe_person_id) THEN
302: FND_MESSAGE.SET_NAME('IGS','IGS_PE_PERS_ID_PRD_OVRLP');
303: IGS_GE_MSG_STACK.ADD;
304: APP_EXCEPTION.RAISE_EXCEPTION;
305: END IF;

Line 307: IF NOT igs_en_val_api.val_ssn_overlap_api(new_references.pe_person_id) THEN

303: IGS_GE_MSG_STACK.ADD;
304: APP_EXCEPTION.RAISE_EXCEPTION;
305: END IF;
306: ELSE
307: IF NOT igs_en_val_api.val_ssn_overlap_api(new_references.pe_person_id) THEN
308: FND_MESSAGE.SET_NAME('IGS','IGS_PE_SSN_PERS_ID_PRD_OVRLP');
309: IGS_GE_MSG_STACK.ADD;
310: APP_EXCEPTION.RAISE_EXCEPTION;
311: END IF;