APPS.IGS_PE_PERSON_ADDR_PKG dependencies on APP_EXCEPTION

Line 68: APP_EXCEPTION.RAISE_EXCEPTION;

64: IF p_start_dt IS NOT NULL AND p_end_dt IS NOT NULL THEN
65: IF p_start_dt > p_end_dt THEN
66: FND_MESSAGE.SET_NAME('IGS','IGS_PE_FROM_DT_GRT_TO_DATE');
67: IGS_GE_MSG_STACK.ADD;
68: APP_EXCEPTION.RAISE_EXCEPTION;
69: END IF;
70: END IF;
71:
72: IF p_start_dt IS NULL AND p_end_dt IS NOT NULL THEN

Line 75: APP_EXCEPTION.RAISE_EXCEPTION;

71:
72: IF p_start_dt IS NULL AND p_end_dt IS NOT NULL THEN
73: FND_MESSAGE.SET_NAME('IGS','IGS_PE_CANT_SPECIFY_FROM_DATE');
74: IGS_GE_MSG_STACK.ADD;
75: APP_EXCEPTION.RAISE_EXCEPTION;
76: END IF;
77:
78: IF p_start_dt IS NOT NULL THEN
79: OPEN c_birth_date_val; FETCH c_birth_date_val INTO l_date_of_birth;

Line 85: App_Exception.Raise_Exception;

81: IF(p_start_dt IS NOT NULL AND l_Date_of_birth IS NOT NULL) THEN
82: IF(p_start_dt < l_date_of_birth) THEN
83: Fnd_Message.Set_Name('IGS','IGS_PE_DREC_GT_BTDT');
84: IGS_GE_MSG_STACK.ADD;
85: App_Exception.Raise_Exception;
86: END IF;
87: END IF;
88: END IF;
89:

Line 265: APP_EXCEPTION.RAISE_EXCEPTION;

261: IF p_start_dt IS NOT NULL AND p_end_dt IS NOT NULL THEN
262: IF p_start_dt > p_end_dt THEN
263: FND_MESSAGE.SET_NAME('IGS','IGS_PE_FROM_DT_GRT_TO_DATE');
264: IGS_GE_MSG_STACK.ADD;
265: APP_EXCEPTION.RAISE_EXCEPTION;
266: END IF;
267: END IF;
268:
269: IF p_start_dt IS NULL AND p_end_dt IS NOT NULL THEN

Line 272: APP_EXCEPTION.RAISE_EXCEPTION;

268:
269: IF p_start_dt IS NULL AND p_end_dt IS NOT NULL THEN
270: FND_MESSAGE.SET_NAME('IGS','IGS_PE_CANT_SPECIFY_FROM_DATE');
271: IGS_GE_MSG_STACK.ADD;
272: APP_EXCEPTION.RAISE_EXCEPTION;
273: END IF;
274: IF p_start_dt IS NOT NULL THEN
275: OPEN c_birth_date_val; FETCH c_birth_date_val INTO l_date_of_birth;
276: CLOSE c_birth_date_val;

Line 281: App_Exception.Raise_Exception;

277: IF(p_start_dt IS NOT NULL AND l_Date_of_birth IS NOT NULL) THEN
278: IF(p_start_dt < l_date_of_birth) THEN
279: Fnd_Message.Set_Name('IGS','IGS_PE_DREC_GT_BTDT');
280: IGS_GE_MSG_STACK.ADD;
281: App_Exception.Raise_Exception;
282: END IF;
283: END IF;
284: END IF;
285: