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_MSG_PUB

Line 182: FND_MSG_PUB.ADD;

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';
186: --AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- inside org cursor -- l_check_flag' || l_check_flag);

Line 192: FND_MSG_PUB.ADD;

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;
196: END IF;

Line 204: FND_MSG_PUB.ADD;

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';
208: END IF;

Line 217: FND_MSG_PUB.ADD;

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;
221: END IF;

Line 230: FND_MSG_PUB.ADD;

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';
234: END IF;

Line 244: FND_MSG_PUB.ADD;

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';
248: END IF;

Line 259: FND_MSG_PUB.ADD;

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';
263: END IF;

Line 272: FND_MSG_PUB.ADD;

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';
276: END IF;

Line 292: FND_MSG_PUB.ADD;

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';
296: END IF;

Line 310: FND_MSG_PUB.ADD;

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;
314: IF G_DEBUG='Y' THEN

Line 321: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

317:
318: EXCEPTION
319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
320: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
321: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
322: p_count => x_msg_count,
323: p_data => x_msg_data);
324:
325: WHEN FND_API.G_EXC_ERROR THEN

Line 327: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

323: p_data => x_msg_data);
324:
325: WHEN FND_API.G_EXC_ERROR THEN
326: X_return_status := FND_API.G_RET_STS_ERROR;
327: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
328: p_count => x_msg_count,
329: p_data => X_msg_data);
330: WHEN OTHERS THEN
331: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 332: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

328: p_count => x_msg_count,
329: p_data => X_msg_data);
330: WHEN OTHERS THEN
331: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
332: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
333: THEN
334: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_VWP_DEPT_SHIFTS_PUB',
335: p_procedure_name => 'TRANSLATE_VALUE_ID',
336: p_error_text => SUBSTR(SQLERRM,1,240));

Line 334: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_VWP_DEPT_SHIFTS_PUB',

330: WHEN OTHERS THEN
331: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
332: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
333: THEN
334: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_VWP_DEPT_SHIFTS_PUB',
335: p_procedure_name => 'TRANSLATE_VALUE_ID',
336: p_error_text => SUBSTR(SQLERRM,1,240));
337: END IF;
338: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 338: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

334: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_VWP_DEPT_SHIFTS_PUB',
335: p_procedure_name => 'TRANSLATE_VALUE_ID',
336: p_error_text => SUBSTR(SQLERRM,1,240));
337: END IF;
338: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
339: p_count => x_msg_count,
340: p_data => x_msg_data);
341: END;
342:

Line 363: FND_MSG_PUB.ADD;

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
367: THEN

Line 369: FND_MSG_PUB.ADD;

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
373: WHERE AHL_DEPARTMENT_SHIFTS_ID=p_vwp_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID;

Line 383: FND_MSG_PUB.ADD;

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:
387: EXCEPTION

Line 390: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

386:
387: EXCEPTION
388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
389: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
390: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
391: p_count => x_msg_count,
392: p_data => x_msg_data);
393:
394: WHEN FND_API.G_EXC_ERROR THEN

Line 396: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

392: p_data => x_msg_data);
393:
394: WHEN FND_API.G_EXC_ERROR THEN
395: X_return_status := FND_API.G_RET_STS_ERROR;
396: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
397: p_count => x_msg_count,
398: p_data => X_msg_data);
399:
400: WHEN OTHERS THEN

Line 402: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

398: p_data => X_msg_data);
399:
400: WHEN OTHERS THEN
401: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
402: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
403: THEN
404: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_VWP_DEPT_SHIFTS_PUB',
405: p_procedure_name => 'VALIDATE_VWP_DEPT_SHIFT',
406: p_error_text => SUBSTR(SQLERRM,1,240));

Line 404: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_VWP_DEPT_SHIFTS_PUB',

400: WHEN OTHERS THEN
401: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
402: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
403: THEN
404: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_VWP_DEPT_SHIFTS_PUB',
405: p_procedure_name => 'VALIDATE_VWP_DEPT_SHIFT',
406: p_error_text => SUBSTR(SQLERRM,1,240));
407: END IF;
408: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 408: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

404: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_VWP_DEPT_SHIFTS_PUB',
405: p_procedure_name => 'VALIDATE_VWP_DEPT_SHIFT',
406: p_error_text => SUBSTR(SQLERRM,1,240));
407: END IF;
408: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
409: p_count => x_msg_count,
410: p_data => X_msg_data);
411:
412: END;

Line 453: FND_MSG_PUB.initialize;

449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
450: END IF;
451:
452: IF FND_API.to_boolean(l_init_msg_list) THEN
453: FND_MSG_PUB.initialize;
454: END IF;
455:
456: x_return_status:=FND_API.G_RET_STS_SUCCESS;
457:

Line 486: l_msg_count := FND_MSG_PUB.count_msg;

482: );
483: IF G_DEBUG='Y' THEN
484: AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- after transalate shift_num' || l_vwp_deptshift_rec.SHIFT_NUM);
485: END IF;
486: l_msg_count := FND_MSG_PUB.count_msg;
487: IF l_msg_count > 0
488: THEN
489: x_msg_count := l_msg_count;
490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 517: l_msg_count := FND_MSG_PUB.count_msg;

513: IF G_DEBUG='Y' THEN
514: AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- after validation shift_num' || l_vwp_deptshift_rec.SHIFT_NUM);
515: END IF;
516:
517: l_msg_count := FND_MSG_PUB.count_msg;
518:
519: IF l_msg_count > 0
520: THEN
521: x_msg_count := l_msg_count;

Line 616: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

612: EXCEPTION
613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
614: ROLLBACK TO CREATE_VWP_DEPT_SHIFTS;
615: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
616: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
617: p_count => x_msg_count,
618: p_data => x_msg_data);
619: WHEN FND_API.G_EXC_ERROR THEN
620: ROLLBACK TO CREATE_VWP_DEPT_SHIFTS;

Line 622: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

618: p_data => x_msg_data);
619: WHEN FND_API.G_EXC_ERROR THEN
620: ROLLBACK TO CREATE_VWP_DEPT_SHIFTS;
621: X_return_status := FND_API.G_RET_STS_ERROR;
622: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
623: p_count => x_msg_count,
624: p_data => X_msg_data);
625: WHEN OTHERS THEN
626: ROLLBACK TO CREATE_VWP_DEPT_SHIFTS;

Line 628: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

624: p_data => X_msg_data);
625: WHEN OTHERS THEN
626: ROLLBACK TO CREATE_VWP_DEPT_SHIFTS;
627: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
628: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
629: THEN
630: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_VWP_DEPT_SHIFTS_PUB',
631: p_procedure_name => 'CREATE_VWP_DEPT_SHIFTS',
632: p_error_text => SUBSTR(SQLERRM,1,240));

Line 630: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_VWP_DEPT_SHIFTS_PUB',

626: ROLLBACK TO CREATE_VWP_DEPT_SHIFTS;
627: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
628: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
629: THEN
630: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_VWP_DEPT_SHIFTS_PUB',
631: p_procedure_name => 'CREATE_VWP_DEPT_SHIFTS',
632: p_error_text => SUBSTR(SQLERRM,1,240));
633:
634: END IF;

Line 635: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

631: p_procedure_name => 'CREATE_VWP_DEPT_SHIFTS',
632: p_error_text => SUBSTR(SQLERRM,1,240));
633:
634: END IF;
635: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
636: p_count => x_msg_count,
637: p_data => X_msg_data);
638: END;
639:

Line 683: FND_MSG_PUB.initialize;

679: END IF;
680:
681:
682: IF FND_API.to_boolean(l_init_msg_list) THEN
683: FND_MSG_PUB.initialize;
684: END IF;
685:
686:
687: x_return_status:=FND_API.G_RET_STS_SUCCESS;

Line 719: l_msg_count := FND_MSG_PUB.count_msg;

715: x_msg_data =>l_msg_data,
716: p_vwp_deptshift_rec =>l_vwp_deptshift_rec);
717: END IF;
718:
719: l_msg_count := FND_MSG_PUB.count_msg;
720:
721: IF l_msg_count > 0
722: THEN
723: x_msg_count := l_msg_count;

Line 738: FND_MSG_PUB.ADD;

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:
742: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 753: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

749: EXCEPTION
750: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
751: ROLLBACK TO DELETE_DEPT_SHIFTS;
752: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
753: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
754: p_count => x_msg_count,
755: p_data => x_msg_data);
756: WHEN FND_API.G_EXC_ERROR THEN
757: ROLLBACK TO DELETE_DEPT_SHIFTS;

Line 759: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

755: p_data => x_msg_data);
756: WHEN FND_API.G_EXC_ERROR THEN
757: ROLLBACK TO DELETE_DEPT_SHIFTS;
758: X_return_status := FND_API.G_RET_STS_ERROR;
759: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
760: p_count => x_msg_count,
761: p_data => X_msg_data);
762:
763: WHEN OTHERS THEN

Line 766: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

762:
763: WHEN OTHERS THEN
764: ROLLBACK TO DELETE_DEPT_SHIFTS;
765: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
766: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
767: THEN
768: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_VWP_DEPT_SHIFTS_PUB',
769: p_procedure_name => 'CREATE_VWP_DEPT_SHIFTS',
770: p_error_text => SUBSTR(SQLERRM,1,240));

Line 768: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_VWP_DEPT_SHIFTS_PUB',

764: ROLLBACK TO DELETE_DEPT_SHIFTS;
765: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
766: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
767: THEN
768: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_VWP_DEPT_SHIFTS_PUB',
769: p_procedure_name => 'CREATE_VWP_DEPT_SHIFTS',
770: p_error_text => SUBSTR(SQLERRM,1,240));
771:
772: END IF;

Line 773: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

769: p_procedure_name => 'CREATE_VWP_DEPT_SHIFTS',
770: p_error_text => SUBSTR(SQLERRM,1,240));
771:
772: END IF;
773: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
774: p_count => x_msg_count,
775: p_data => X_msg_data);
776: END;
777: