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_APPR_DEPT_SHIFTS_PUB dependencies on FND_MESSAGE

Line 210: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_ORG_NAME_NULL');

206: END IF;
207: x_return_status:=FND_API.G_RET_STS_SUCCESS;
208: IF p_x_appr_deptshift_rec.ORGANIZATION_NAME IS NULL OR p_x_appr_deptshift_rec.ORGANIZATION_NAME=FND_API.G_MISS_CHAR
209: THEN
210: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_ORG_NAME_NULL');
211: FND_MSG_PUB.ADD;
212: l_check_flag:='N';
213: ELSE
214: l_check_flag:='Y';

Line 219: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_ORG_NAME_INVALID');

215: OPEN get_org_id(p_x_appr_deptshift_rec.ORGANIZATION_NAME);
216: FETCH get_org_id INTO p_x_appr_deptshift_rec.ORGANIZATION_ID;
217: IF get_org_id%NOTFOUND
218: THEN
219: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_ORG_NAME_INVALID');
220: FND_MSG_PUB.ADD;
221: l_check_flag:='N';
222: END IF;
223: CLOSE get_org_id;

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

225:
226: l_check_flag:='N';
227: IF p_x_appr_deptshift_rec.DEPT_DESCRIPTION IS NULL OR p_x_appr_deptshift_rec.DEPT_DESCRIPTION=FND_API.G_MISS_CHAR
228: THEN
229: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_DEPT_NAME_NULL');
230: FND_MSG_PUB.ADD;
231: l_check_flag:='N';
232: ELSE
233: l_check_flag:='Y';

Line 242: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_DEPT_NAME_INVALID');

238: OPEN get_org_dept_id(p_x_appr_deptshift_rec.ORGANIZATION_ID,p_x_appr_deptshift_rec.DEPT_DESCRIPTION);
239: FETCH get_org_dept_id INTO p_x_appr_deptshift_rec.DEPARTMENT_ID;
240: IF get_org_dept_id%NOTFOUND
241: THEN
242: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_DEPT_NAME_INVALID');
243: FND_MSG_PUB.ADD;
244: l_check_flag:='N';
245: END IF;
246: CLOSE get_org_dept_id;

Line 253: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_CALENDER_NAME_NULL');

249:
250: l_check_flag:='N';
251: IF p_x_appr_deptshift_rec.CALENDAR_DESCRIPTION IS NULL OR p_x_appr_deptshift_rec.CALENDAR_DESCRIPTION=FND_API.G_MISS_CHAR
252: THEN
253: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_CALENDER_NAME_NULL');
254: FND_MSG_PUB.ADD;
255: l_check_flag:='N';
256: ELSE
257: l_check_flag:='Y';

Line 267: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_CALENDER_INVALID');

263: OPEN get_bom_calendar(p_x_appr_deptshift_rec.CALENDAR_DESCRIPTION);
264: FETCH get_bom_calendar INTO p_x_appr_deptshift_rec.CALENDAR_CODE;
265: IF get_bom_calendar%NOTFOUND
266: THEN
267: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_CALENDER_INVALID');
268: FND_MSG_PUB.ADD;
269: l_check_flag:='N';
270: ELSE
271: l_check_flag:='Y';

Line 280: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_SHIFT_NUMBER_NULL');

276:
277: l_check_flag:='N';
278: IF p_x_appr_deptshift_rec.SHIFT_NUM IS NULL OR p_x_appr_deptshift_rec.SHIFT_NUM=FND_API.G_MISS_NUM
279: THEN
280: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_SHIFT_NUMBER_NULL');
281: FND_MSG_PUB.ADD;
282: l_check_flag:='N';
283: ELSE
284: l_check_flag:='Y';

Line 293: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_SHIFT_NUMBER_INVALID');

289: OPEN get_bom_shift_num(p_x_appr_deptshift_rec.CALENDAR_CODE,p_x_appr_deptshift_rec.SHIFT_NUM);
290: FETCH get_bom_shift_num INTO p_x_appr_deptshift_rec.SHIFT_NUM;
291: IF get_bom_shift_num%NOTFOUND
292: THEN
293: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_SHIFT_NUMBER_INVALID');
294: FND_MSG_PUB.ADD;
295: l_check_flag:='N';
296: ELSE
297: l_check_flag:='Y';

Line 306: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_WORK_DAYS_NULL');

302:
303: l_check_flag:='N';
304: IF p_x_appr_deptshift_rec.SEQ_NAME IS NULL OR p_x_appr_deptshift_rec.SEQ_NAME=FND_API.G_MISS_CHAR
305: THEN
306: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_WORK_DAYS_NULL');
307: FND_MSG_PUB.ADD;
308: l_check_flag:='N';
309: ELSE
310: l_check_flag:='Y';

Line 318: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_SEQ_DESCRIP_INVALID');

314: OPEN get_bom_workdays(p_x_appr_deptshift_rec.CALENDAR_CODE,p_x_appr_deptshift_rec.SHIFT_NUM,p_x_appr_deptshift_rec.SEQ_NAME);
315: FETCH get_bom_workdays INTO p_x_appr_deptshift_rec.SEQ_NUM;
316: IF get_bom_workdays%NOTFOUND
317: THEN
318: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_SEQ_DESCRIP_INVALID');
319: FND_MSG_PUB.ADD;
320: -- Added by rbhavsar on Nov 27, 2007 for ER 5854712
321: l_check_flag:='N';
322: END IF;

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

431: IF p_appr_deptshift_rec.DML_OPERATION='D'
432: THEN
433: IF p_appr_deptshift_rec.OBJECT_VERSION_NUMBER IS NULL OR p_appr_deptshift_rec.OBJECT_VERSION_NUMBER=FND_API.G_MISS_NUM
434: THEN
435: FND_MESSAGE.SET_NAME('AHL','AHL_COM_OBJECT_VERS_NUM_NULL');
436: FND_MSG_PUB.ADD;
437: END IF;
438:
439: IF p_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID IS NULL OR p_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID=FND_API.G_MISS_NUM

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

437: END IF;
438:
439: IF p_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID IS NULL OR p_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID=FND_API.G_MISS_NUM
440: THEN
441: FND_MESSAGE.SET_NAME('AHL','AHL_DEPARTMENT_SHIFTS_ID_NULL');
442: FND_MSG_PUB.ADD;
443: ELSE
444: SELECT AHL_DEPARTMENT_SHIFTS_ID INTO l_prim_key
445: FROM AHL_DEPARTMENT_SHIFTS

Line 455: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_DEPT_EXISTS');

451: WHERE DEPARTMENT_ID=p_appr_deptshift_rec.DEPARTMENT_ID;
452:
453: IF l_counter>0
454: THEN
455: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_DEPT_EXISTS');
456: FND_MSG_PUB.ADD;
457: END IF;
458: END IF;
459:

Line 474: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_SUBINVENTORY');

470: C_SUBINVENTORY => p_appr_deptshift_rec.SUBINVENTORY);
471: FETCH validate_subinventory INTO l_status_id;
472: IF (validate_subinventory%NOTFOUND) THEN
473: CLOSE validate_subinventory;
474: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_SUBINVENTORY');
475: FND_MESSAGE.Set_Token('INV', p_appr_deptshift_rec.SUBINVENTORY);
476: FND_MSG_PUB.ADD;
477: RAISE FND_API.G_EXC_ERROR;
478: ELSE

Line 475: FND_MESSAGE.Set_Token('INV', p_appr_deptshift_rec.SUBINVENTORY);

471: FETCH validate_subinventory INTO l_status_id;
472: IF (validate_subinventory%NOTFOUND) THEN
473: CLOSE validate_subinventory;
474: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_SUBINVENTORY');
475: FND_MESSAGE.Set_Token('INV', p_appr_deptshift_rec.SUBINVENTORY);
476: FND_MSG_PUB.ADD;
477: RAISE FND_API.G_EXC_ERROR;
478: ELSE
479: IF l_status_id in (NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1), NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1)) THEN

Line 481: FND_MESSAGE.SET_NAME('AHL', 'AHL_SUBINVENTORY_NOT_SVC');

477: RAISE FND_API.G_EXC_ERROR;
478: ELSE
479: IF l_status_id in (NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1), NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1)) THEN
480: CLOSE validate_subinventory;
481: FND_MESSAGE.SET_NAME('AHL', 'AHL_SUBINVENTORY_NOT_SVC');
482: FND_MESSAGE.Set_Token('INV', p_appr_deptshift_rec.SUBINVENTORY);
483: FND_MSG_PUB.ADD;
484: RAISE FND_API.G_EXC_ERROR;
485: END IF;

Line 482: FND_MESSAGE.Set_Token('INV', p_appr_deptshift_rec.SUBINVENTORY);

478: ELSE
479: IF l_status_id in (NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1), NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1)) THEN
480: CLOSE validate_subinventory;
481: FND_MESSAGE.SET_NAME('AHL', 'AHL_SUBINVENTORY_NOT_SVC');
482: FND_MESSAGE.Set_Token('INV', p_appr_deptshift_rec.SUBINVENTORY);
483: FND_MSG_PUB.ADD;
484: RAISE FND_API.G_EXC_ERROR;
485: END IF;
486: END IF;

Line 492: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_PC_SUBINV_MANDATORY');

488: END IF;
489:
490: IF (p_appr_deptshift_rec.SUBINVENTORY IS NULL AND
491: (p_appr_deptshift_rec.INV_LOCATOR_ID IS NOT NULL OR p_appr_deptshift_rec.LOCATOR_SEGMENTS IS NOT NULL)) THEN
492: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_PC_SUBINV_MANDATORY');
493: FND_MSG_PUB.ADD;
494: RAISE FND_API.G_EXC_ERROR;
495: END IF;
496:

Line 504: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_LOCATOR');

500: C_INVENTORY_LOCATION_ID => p_appr_deptshift_rec.INV_LOCATOR_ID);
501: FETCH validate_inv_loc_id INTO l_temp_num;
502: IF (validate_inv_loc_id%NOTFOUND) THEN
503: CLOSE validate_inv_loc_id;
504: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_LOCATOR');
505: FND_MESSAGE.Set_Token('LOC', p_appr_deptshift_rec.INV_LOCATOR_ID);
506: FND_MSG_PUB.ADD;
507: RAISE FND_API.G_EXC_ERROR;
508: END IF;

Line 505: FND_MESSAGE.Set_Token('LOC', p_appr_deptshift_rec.INV_LOCATOR_ID);

501: FETCH validate_inv_loc_id INTO l_temp_num;
502: IF (validate_inv_loc_id%NOTFOUND) THEN
503: CLOSE validate_inv_loc_id;
504: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_LOCATOR');
505: FND_MESSAGE.Set_Token('LOC', p_appr_deptshift_rec.INV_LOCATOR_ID);
506: FND_MSG_PUB.ADD;
507: RAISE FND_API.G_EXC_ERROR;
508: END IF;
509: CLOSE validate_inv_loc_id;

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

870: WHERE AHL_DEPARTMENT_SHIFTS_ID=l_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID
871: AND OBJECT_VERSION_NUMBER=l_appr_deptshift_rec.OBJECT_VERSION_NUMBER;
872: IF (sql%ROWCOUNT=0)
873: THEN
874: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
875: FND_MSG_PUB.ADD;
876: END IF;
877: END IF;
878: