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 223: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_ORG_NAME_NULL');

219: END IF;
220: x_return_status:=FND_API.G_RET_STS_SUCCESS;
221: IF p_x_appr_deptshift_rec.ORGANIZATION_NAME IS NULL OR p_x_appr_deptshift_rec.ORGANIZATION_NAME=FND_API.G_MISS_CHAR
222: THEN
223: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_ORG_NAME_NULL');
224: FND_MSG_PUB.ADD;
225: l_check_flag:='N';
226: ELSE
227: l_check_flag:='Y';

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

228: OPEN get_org_id(p_x_appr_deptshift_rec.ORGANIZATION_NAME);
229: FETCH get_org_id INTO p_x_appr_deptshift_rec.ORGANIZATION_ID;
230: IF get_org_id%NOTFOUND
231: THEN
232: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_ORG_NAME_INVALID');
233: FND_MSG_PUB.ADD;
234: l_check_flag:='N';
235: END IF;
236: CLOSE get_org_id;

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

238:
239: l_check_flag:='N';
240: IF p_x_appr_deptshift_rec.DEPT_DESCRIPTION IS NULL OR p_x_appr_deptshift_rec.DEPT_DESCRIPTION=FND_API.G_MISS_CHAR
241: THEN
242: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_DEPT_NAME_NULL');
243: FND_MSG_PUB.ADD;
244: l_check_flag:='N';
245: ELSE
246: l_check_flag:='Y';

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

251: OPEN get_org_dept_id(p_x_appr_deptshift_rec.ORGANIZATION_ID,p_x_appr_deptshift_rec.DEPT_DESCRIPTION);
252: FETCH get_org_dept_id INTO p_x_appr_deptshift_rec.DEPARTMENT_ID;
253: IF get_org_dept_id%NOTFOUND
254: THEN
255: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_DEPT_NAME_INVALID');
256: FND_MSG_PUB.ADD;
257: l_check_flag:='N';
258: END IF;
259: CLOSE get_org_dept_id;

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

262:
263: l_check_flag:='N';
264: IF p_x_appr_deptshift_rec.CALENDAR_DESCRIPTION IS NULL OR p_x_appr_deptshift_rec.CALENDAR_DESCRIPTION=FND_API.G_MISS_CHAR
265: THEN
266: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_CALENDER_NAME_NULL');
267: FND_MSG_PUB.ADD;
268: l_check_flag:='N';
269: ELSE
270: l_check_flag:='Y';

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

276: OPEN get_bom_calendar(p_x_appr_deptshift_rec.CALENDAR_DESCRIPTION);
277: FETCH get_bom_calendar INTO p_x_appr_deptshift_rec.CALENDAR_CODE;
278: IF get_bom_calendar%NOTFOUND
279: THEN
280: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_CALENDER_INVALID');
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_NULL');

289:
290: l_check_flag:='N';
291: IF p_x_appr_deptshift_rec.SHIFT_NUM IS NULL OR p_x_appr_deptshift_rec.SHIFT_NUM=FND_API.G_MISS_NUM
292: THEN
293: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_SHIFT_NUMBER_NULL');
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_SHIFT_NUMBER_INVALID');

302: OPEN get_bom_shift_num(p_x_appr_deptshift_rec.CALENDAR_CODE,p_x_appr_deptshift_rec.SHIFT_NUM);
303: FETCH get_bom_shift_num INTO p_x_appr_deptshift_rec.SHIFT_NUM;
304: IF get_bom_shift_num%NOTFOUND
305: THEN
306: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_SHIFT_NUMBER_INVALID');
307: FND_MSG_PUB.ADD;
308: l_check_flag:='N';
309: ELSE
310: l_check_flag:='Y';

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

315:
316: l_check_flag:='N';
317: IF p_x_appr_deptshift_rec.SEQ_NAME IS NULL OR p_x_appr_deptshift_rec.SEQ_NAME=FND_API.G_MISS_CHAR
318: THEN
319: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_WORK_DAYS_NULL');
320: FND_MSG_PUB.ADD;
321: l_check_flag:='N';
322: ELSE
323: l_check_flag:='Y';

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

327: 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);
328: FETCH get_bom_workdays INTO p_x_appr_deptshift_rec.SEQ_NUM;
329: IF get_bom_workdays%NOTFOUND
330: THEN
331: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_SEQ_DESCRIP_INVALID');
332: FND_MSG_PUB.ADD;
333: -- Added by rbhavsar on Nov 27, 2007 for ER 5854712
334: l_check_flag:='N';
335: END IF;

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

456: IF p_appr_deptshift_rec.DML_OPERATION='D'
457: THEN
458: IF p_appr_deptshift_rec.OBJECT_VERSION_NUMBER IS NULL OR p_appr_deptshift_rec.OBJECT_VERSION_NUMBER=FND_API.G_MISS_NUM
459: THEN
460: FND_MESSAGE.SET_NAME('AHL','AHL_COM_OBJECT_VERS_NUM_NULL');
461: FND_MSG_PUB.ADD;
462: END IF;
463:
464: 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 466: FND_MESSAGE.SET_NAME('AHL','AHL_DEPARTMENT_SHIFTS_ID_NULL');

462: END IF;
463:
464: 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
465: THEN
466: FND_MESSAGE.SET_NAME('AHL','AHL_DEPARTMENT_SHIFTS_ID_NULL');
467: FND_MSG_PUB.ADD;
468: ELSE
469: SELECT AHL_DEPARTMENT_SHIFTS_ID INTO l_prim_key
470: FROM AHL_DEPARTMENT_SHIFTS

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

477: WHERE DEPARTMENT_ID=p_appr_deptshift_rec.DEPARTMENT_ID;
478:
479: IF l_counter>0
480: THEN
481: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_DEPT_EXISTS');
482: FND_MSG_PUB.ADD;
483: END IF;
484: END IF;
485:

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

496: C_SUBINVENTORY => p_appr_deptshift_rec.SUBINVENTORY);
497: FETCH validate_subinventory INTO l_status_id;
498: IF (validate_subinventory%NOTFOUND) THEN
499: CLOSE validate_subinventory;
500: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_SUBINVENTORY');
501: FND_MESSAGE.Set_Token('INV', p_appr_deptshift_rec.SUBINVENTORY);
502: FND_MSG_PUB.ADD;
503: RAISE FND_API.G_EXC_ERROR;
504: ELSE

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

497: FETCH validate_subinventory INTO l_status_id;
498: IF (validate_subinventory%NOTFOUND) THEN
499: CLOSE validate_subinventory;
500: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_SUBINVENTORY');
501: FND_MESSAGE.Set_Token('INV', p_appr_deptshift_rec.SUBINVENTORY);
502: FND_MSG_PUB.ADD;
503: RAISE FND_API.G_EXC_ERROR;
504: ELSE
505: 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 507: FND_MESSAGE.SET_NAME('AHL', 'AHL_SUBINVENTORY_NOT_SVC');

503: RAISE FND_API.G_EXC_ERROR;
504: ELSE
505: 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
506: CLOSE validate_subinventory;
507: FND_MESSAGE.SET_NAME('AHL', 'AHL_SUBINVENTORY_NOT_SVC');
508: FND_MESSAGE.Set_Token('INV', p_appr_deptshift_rec.SUBINVENTORY);
509: FND_MSG_PUB.ADD;
510: RAISE FND_API.G_EXC_ERROR;
511: END IF;

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

504: ELSE
505: 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
506: CLOSE validate_subinventory;
507: FND_MESSAGE.SET_NAME('AHL', 'AHL_SUBINVENTORY_NOT_SVC');
508: FND_MESSAGE.Set_Token('INV', p_appr_deptshift_rec.SUBINVENTORY);
509: FND_MSG_PUB.ADD;
510: RAISE FND_API.G_EXC_ERROR;
511: END IF;
512: END IF;

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

514: END IF;
515:
516: IF (p_appr_deptshift_rec.SUBINVENTORY IS NULL AND
517: (p_appr_deptshift_rec.INV_LOCATOR_ID IS NOT NULL OR p_appr_deptshift_rec.LOCATOR_SEGMENTS IS NOT NULL)) THEN
518: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_PC_SUBINV_MANDATORY');
519: FND_MSG_PUB.ADD;
520: RAISE FND_API.G_EXC_ERROR;
521: END IF;
522:

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

526: C_INVENTORY_LOCATION_ID => p_appr_deptshift_rec.INV_LOCATOR_ID);
527: FETCH validate_inv_loc_id INTO l_temp_num;
528: IF (validate_inv_loc_id%NOTFOUND) THEN
529: CLOSE validate_inv_loc_id;
530: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_LOCATOR');
531: FND_MESSAGE.Set_Token('LOC', p_appr_deptshift_rec.INV_LOCATOR_ID);
532: FND_MSG_PUB.ADD;
533: RAISE FND_API.G_EXC_ERROR;
534: END IF;

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

527: FETCH validate_inv_loc_id INTO l_temp_num;
528: IF (validate_inv_loc_id%NOTFOUND) THEN
529: CLOSE validate_inv_loc_id;
530: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_LOCATOR');
531: FND_MESSAGE.Set_Token('LOC', p_appr_deptshift_rec.INV_LOCATOR_ID);
532: FND_MSG_PUB.ADD;
533: RAISE FND_API.G_EXC_ERROR;
534: END IF;
535: CLOSE validate_inv_loc_id;

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

916: WHERE AHL_DEPARTMENT_SHIFTS_ID=l_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID
917: AND OBJECT_VERSION_NUMBER=l_appr_deptshift_rec.OBJECT_VERSION_NUMBER;
918: IF (sql%ROWCOUNT=0)
919: THEN
920: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
921: FND_MSG_PUB.ADD;
922: END IF;
923: END IF;
924:

Line 1131: FND_MESSAGE.set_name('AHL','AHL_FMP_RECORD_CHANGED');

1127: END IF;
1128:
1129: -- If the record does not exist, then, abort API.
1130: IF ( SQL%ROWCOUNT = 0 ) THEN
1131: FND_MESSAGE.set_name('AHL','AHL_FMP_RECORD_CHANGED');
1132: --FND_MESSAGE.set_token( 'RECORD', get_record_identifier( l_appr_deptshift_rec ) );
1133: FND_MSG_PUB.add;
1134: END IF;
1135:

Line 1132: --FND_MESSAGE.set_token( 'RECORD', get_record_identifier( l_appr_deptshift_rec ) );

1128:
1129: -- If the record does not exist, then, abort API.
1130: IF ( SQL%ROWCOUNT = 0 ) THEN
1131: FND_MESSAGE.set_name('AHL','AHL_FMP_RECORD_CHANGED');
1132: --FND_MESSAGE.set_token( 'RECORD', get_record_identifier( l_appr_deptshift_rec ) );
1133: FND_MSG_PUB.add;
1134: END IF;
1135:
1136: IF FND_API.TO_BOOLEAN(p_commit) THEN