eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_VWP_DEPT_SHIFTS_PUB dependencies on FND_MESSAGE

Line 181: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_ORG_NAME_NULL');

177: --AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- inside translate1 -- l_check_flag' || l_check_flag);
178: IF p_x_vwp_deptshift_rec.ORGANIZATION_NAME IS NULL OR p_x_vwp_deptshift_rec.ORGANIZATION_NAME=FND_API.G_MISS_CHAR
179: THEN
180: --AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- inside organization-- l_check_flag' || l_check_flag);
181: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_ORG_NAME_NULL');
182: FND_MSG_PUB.ADD;
183: l_check_flag:='N';
184: ELSE
185: l_check_flag:='Y';

Line 191: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_ORG_NAME_INVALID');

187: OPEN get_org_id(p_x_vwp_deptshift_rec.ORGANIZATION_NAME);
188: FETCH get_org_id INTO p_x_vwp_deptshift_rec.ORGANIZATION_ID;
189: IF get_org_id%NOTFOUND
190: THEN
191: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_ORG_NAME_INVALID');
192: FND_MSG_PUB.ADD;
193: l_check_flag:='N';
194: END IF;
195: CLOSE get_org_id;

Line 203: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_DEPT_NAME_NULL');

199: l_check_flag:='N';
200: IF p_x_vwp_deptshift_rec.DEPT_DESCRIPTION IS NULL OR p_x_vwp_deptshift_rec.DEPT_DESCRIPTION=FND_API.G_MISS_CHAR
201: THEN
202: --AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- inside department-- l_check_flag' || l_check_flag);
203: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_DEPT_NAME_NULL');
204: FND_MSG_PUB.ADD;
205: l_check_flag:='N';
206: ELSE
207: l_check_flag:='Y';

Line 216: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_DEPT_NAME_INVALID');

212: OPEN get_org_dept_id(p_x_vwp_deptshift_rec.ORGANIZATION_ID,p_x_vwp_deptshift_rec.DEPT_DESCRIPTION);
213: FETCH get_org_dept_id INTO p_x_vwp_deptshift_rec.DEPARTMENT_ID;
214: IF get_org_dept_id%NOTFOUND
215: THEN
216: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_DEPT_NAME_INVALID');
217: FND_MSG_PUB.ADD;
218: l_check_flag:='N';
219: END IF;
220: CLOSE get_org_dept_id;

Line 229: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_CALENDER_NAME_NULL');

225: l_check_flag:='N';
226: IF p_x_vwp_deptshift_rec.CALENDAR_DESCRIPTION IS NULL OR p_x_vwp_deptshift_rec.CALENDAR_DESCRIPTION=FND_API.G_MISS_CHAR
227: THEN
228: --AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- inside calender-- l_check_flag' || l_check_flag);
229: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_CALENDER_NAME_NULL');
230: FND_MSG_PUB.ADD;
231: l_check_flag:='N';
232: ELSE
233: l_check_flag:='Y';

Line 243: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_CALENDER_INVALID');

239: OPEN get_bom_calendar(p_x_vwp_deptshift_rec.CALENDAR_DESCRIPTION);
240: FETCH get_bom_calendar INTO p_x_vwp_deptshift_rec.CALENDAR_CODE;
241: IF get_bom_calendar%NOTFOUND
242: THEN
243: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_CALENDER_INVALID');
244: FND_MSG_PUB.ADD;
245: l_check_flag:='N';
246: ELSE
247: l_check_flag:='Y';

Line 258: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_SHIFT_NUMBER_NULL');

254: l_check_flag:='N';
255: IF p_x_vwp_deptshift_rec.SHIFT_NUM IS NULL OR p_x_vwp_deptshift_rec.SHIFT_NUM=FND_API.G_MISS_NUM
256: THEN
257: --AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- inside shift number-- l_check_flag' || l_check_flag);
258: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_SHIFT_NUMBER_NULL');
259: FND_MSG_PUB.ADD;
260: l_check_flag:='N';
261: ELSE
262: l_check_flag:='Y';

Line 271: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_SHIFT_NUMBER_INVALID');

267: OPEN get_bom_shift_num(p_x_vwp_deptshift_rec.CALENDAR_CODE,p_x_vwp_deptshift_rec.SHIFT_NUM);
268: FETCH get_bom_shift_num INTO p_x_vwp_deptshift_rec.SHIFT_NUM;
269: IF get_bom_shift_num%NOTFOUND
270: THEN
271: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_SHIFT_NUMBER_INVALID');
272: FND_MSG_PUB.ADD;
273: l_check_flag:='N';
274: ELSE
275: l_check_flag:='Y';

Line 291: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_WORK_DAYS_NULL');

287: IF G_DEBUG='Y' THEN
288: AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- inside sequence number-- l_check_flag' || l_check_flag);
289: END IF;
290: --
291: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_WORK_DAYS_NULL');
292: FND_MSG_PUB.ADD;
293: l_check_flag:='N';
294: ELSE
295: l_check_flag:='Y';

Line 309: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_SEQ_DESCRIP_INVALID');

305: OPEN get_bom_workdays(p_x_vwp_deptshift_rec.CALENDAR_CODE,p_x_vwp_deptshift_rec.SHIFT_NUM,p_x_vwp_deptshift_rec.SEQ_NAME);
306: FETCH get_bom_workdays INTO p_x_vwp_deptshift_rec.SEQ_NUM;
307: IF get_bom_workdays%NOTFOUND
308: THEN
309: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_SEQ_DESCRIP_INVALID');
310: FND_MSG_PUB.ADD;
311: END IF;
312: CLOSE get_bom_workdays;
313: END IF;

Line 362: FND_MESSAGE.SET_NAME('AHL','AHL_COM_OBJECT_VERS_NUM_NULL');

358: IF p_vwp_deptshift_rec.DML_OPERATION='D'
359: THEN
360: IF p_vwp_deptshift_rec.OBJECT_VERSION_NUMBER IS NULL OR p_vwp_deptshift_rec.OBJECT_VERSION_NUMBER=FND_API.G_MISS_NUM
361: THEN
362: FND_MESSAGE.SET_NAME('AHL','AHL_COM_OBJECT_VERS_NUM_NULL');
363: FND_MSG_PUB.ADD;
364: END IF;
365:
366: IF p_vwp_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID IS NULL OR p_vwp_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID=FND_API.G_MISS_NUM

Line 368: FND_MESSAGE.SET_NAME('AHL','AHL_DEPARTMENT_SHIFTS_ID_NULL');

364: END IF;
365:
366: IF p_vwp_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID IS NULL OR p_vwp_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID=FND_API.G_MISS_NUM
367: THEN
368: FND_MESSAGE.SET_NAME('AHL','AHL_DEPARTMENT_SHIFTS_ID_NULL');
369: FND_MSG_PUB.ADD;
370: ELSE
371: SELECT AHL_DEPARTMENT_SHIFTS_ID INTO l_prim_key
372: FROM AHL_DEPARTMENT_SHIFTS

Line 382: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_DEPT_EXISTS');

378: WHERE DEPARTMENT_ID=p_vwp_deptshift_rec.DEPARTMENT_ID;
379:
380: IF l_counter>0
381: THEN
382: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_DEPT_EXISTS');
383: FND_MSG_PUB.ADD;
384: END IF;
385: END IF;
386:

Line 737: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');

733: WHERE AHL_DEPARTMENT_SHIFTS_ID=l_vwp_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID
734: AND OBJECT_VERSION_NUMBER=l_vwp_deptshift_rec.OBJECT_VERSION_NUMBER;
735: IF (sql%ROWCOUNT=0)
736: THEN
737: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
738: FND_MSG_PUB.ADD;
739: END IF;
740: END IF;
741: