205: WHERE ORGANIZATION_ID = C_PARENT_ORG_ID
206: AND LOCATION_ID is not null;
207: EXCEPTION
208: WHEN NO_DATA_FOUND THEN
209: FND_MESSAGE.SET_NAME('PER'
210: ,'PER_75228_ORG_LOC_MISSING');
211: /*SRW.MESSAGE('10'
212: ,FND_MESSAGE.GET)*/NULL;
213: RAISE;
208: WHEN NO_DATA_FOUND THEN
209: FND_MESSAGE.SET_NAME('PER'
210: ,'PER_75228_ORG_LOC_MISSING');
211: /*SRW.MESSAGE('10'
212: ,FND_MESSAGE.GET)*/NULL;
213: RAISE;
214: END;
215: BEGIN
216: SELECT
221: WHERE ORGANIZATION_ID = C_PARENT_ORG_ID
222: AND ORG_INFORMATION_CONTEXT = 'EEO_Spec';
223: EXCEPTION
224: WHEN NO_DATA_FOUND THEN
225: FND_MESSAGE.SET_NAME('PER'
226: ,'PER_75229_EEO_CLASS_MISSING');
227: /*SRW.MESSAGE('10'
228: ,FND_MESSAGE.GET)*/NULL;
229: RAISE;
224: WHEN NO_DATA_FOUND THEN
225: FND_MESSAGE.SET_NAME('PER'
226: ,'PER_75229_EEO_CLASS_MISSING');
227: /*SRW.MESSAGE('10'
228: ,FND_MESSAGE.GET)*/NULL;
229: RAISE;
230: END;
231: BEGIN
232: SELECT
247: AND HLEI2.INFORMATION_TYPE = 'Establishment Information'
248: AND HLEI2.LEI_INFORMATION_CATEGORY = 'Establishment Information';
249: EXCEPTION
250: WHEN NO_DATA_FOUND THEN
251: FND_MESSAGE.SET_NAME('PER'
252: ,'PER_75230_EST_CLASS_MISSING');
253: /*SRW.MESSAGE('10'
254: ,FND_MESSAGE.GET)*/NULL;
255: RAISE;
250: WHEN NO_DATA_FOUND THEN
251: FND_MESSAGE.SET_NAME('PER'
252: ,'PER_75230_EST_CLASS_MISSING');
253: /*SRW.MESSAGE('10'
254: ,FND_MESSAGE.GET)*/NULL;
255: RAISE;
256: WHEN OTHERS THEN
257: NULL;
258: END;
891: --CP_HW_AUD_FEMALE := NULL;
892:
893: EXCEPTION
894: WHEN NO_DATA_FOUND THEN
895: FND_MESSAGE.SET_NAME('PER'
896: ,'PER_75230_EST_CLASS_MISSING');
897: /*SRW.MESSAGE('10'
898: ,FND_MESSAGE.GET)*/NULL;
899: /*SRW.MESSAGE('20'
894: WHEN NO_DATA_FOUND THEN
895: FND_MESSAGE.SET_NAME('PER'
896: ,'PER_75230_EST_CLASS_MISSING');
897: /*SRW.MESSAGE('10'
898: ,FND_MESSAGE.GET)*/NULL;
899: /*SRW.MESSAGE('20'
900: ,'message will talk about how there needs to be eit set up and assigned to resp')*/NULL;
901: /*SRW.MESSAGE('30'
902: ,'also will suggest running report for previous year to fill in the figures.')*/NULL;