DBA Data[Home] [Help]

APPS.IGS_PE_CITIZENSHIPS_PKG dependencies on APP_EXCEPTION

Line 50: APP_EXCEPTION.RAISE_EXCEPTION;

46:
47: IF p_end_dt IS NOT NULL AND p_end_dt < p_start_dt THEN
48: FND_MESSAGE.SET_NAME('IGS','IGS_FI_ST_DT_LE_END_DT');
49: IGS_GE_MSG_STACK.ADD;
50: APP_EXCEPTION.RAISE_EXCEPTION;
51:
52: ELSIF l_bth_dt IS NOT NULL AND l_bth_dt > p_start_dt THEN
53: FND_MESSAGE.SET_NAME('IGS','IGS_PE_DREC_GT_BTDT');
54: IGS_GE_MSG_STACK.ADD;

Line 55: APP_EXCEPTION.RAISE_EXCEPTION;

51:
52: ELSIF l_bth_dt IS NOT NULL AND l_bth_dt > p_start_dt THEN
53: FND_MESSAGE.SET_NAME('IGS','IGS_PE_DREC_GT_BTDT');
54: IGS_GE_MSG_STACK.ADD;
55: APP_EXCEPTION.RAISE_EXCEPTION;
56: END IF;
57:
58:
59: OPEN validate_dt_overlap(party_id, p_start_dt, p_end_dt ,citznship_id,country_cd);

Line 65: APP_EXCEPTION.RAISE_EXCEPTION;

61: IF (validate_dt_overlap%FOUND) THEN
62: CLOSE validate_dt_overlap;
63: FND_MESSAGE.SET_NAME('IGS','IGS_PE_CIT_DATE_OVER');
64: IGS_GE_MSG_STACK.ADD;
65: APP_EXCEPTION.RAISE_EXCEPTION;
66: END IF;
67: CLOSE validate_dt_overlap;
68: END validate_date;
69: