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_MSG_PUB

Line 211: FND_MSG_PUB.ADD;

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';
215: OPEN get_org_id(p_x_appr_deptshift_rec.ORGANIZATION_NAME);

Line 220: FND_MSG_PUB.ADD;

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

Line 230: FND_MSG_PUB.ADD;

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

Line 243: FND_MSG_PUB.ADD;

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

Line 254: FND_MSG_PUB.ADD;

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

Line 268: FND_MSG_PUB.ADD;

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

Line 281: FND_MSG_PUB.ADD;

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

Line 294: FND_MSG_PUB.ADD;

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

Line 307: FND_MSG_PUB.ADD;

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

Line 319: FND_MSG_PUB.ADD;

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;
323: CLOSE get_bom_workdays;

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

365:
366: EXCEPTION
367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
368: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
369: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
370: p_count => x_msg_count,
371: p_data => x_msg_data);
372:
373: WHEN FND_API.G_EXC_ERROR THEN

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

371: p_data => x_msg_data);
372:
373: WHEN FND_API.G_EXC_ERROR THEN
374: X_return_status := FND_API.G_RET_STS_ERROR;
375: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
376: p_count => x_msg_count,
377: p_data => X_msg_data);
378: WHEN OTHERS THEN
379: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

376: p_count => x_msg_count,
377: p_data => X_msg_data);
378: WHEN OTHERS THEN
379: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
380: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
381: THEN
382: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_APPR_DEPT_SHIFTS_PUB',
383: p_procedure_name => 'TRANSLATE_VALUE_ID',
384: p_error_text => SUBSTR(SQLERRM,1,240));

Line 382: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_APPR_DEPT_SHIFTS_PUB',

378: WHEN OTHERS THEN
379: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
380: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
381: THEN
382: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_APPR_DEPT_SHIFTS_PUB',
383: p_procedure_name => 'TRANSLATE_VALUE_ID',
384: p_error_text => SUBSTR(SQLERRM,1,240));
385: END IF;
386: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

382: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_APPR_DEPT_SHIFTS_PUB',
383: p_procedure_name => 'TRANSLATE_VALUE_ID',
384: p_error_text => SUBSTR(SQLERRM,1,240));
385: END IF;
386: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
387: p_count => x_msg_count,
388: p_data => x_msg_data);
389: END;
390:

Line 436: FND_MSG_PUB.ADD;

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

Line 442: FND_MSG_PUB.ADD;

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
446: WHERE AHL_DEPARTMENT_SHIFTS_ID=p_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID;

Line 456: FND_MSG_PUB.ADD;

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:
460: -- Added by rbhavsar on Nov 27, 2007 for ER 5854712

Line 476: FND_MSG_PUB.ADD;

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
480: CLOSE validate_subinventory;

Line 483: FND_MSG_PUB.ADD;

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;
487: CLOSE validate_subinventory;

Line 493: FND_MSG_PUB.ADD;

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:
497: IF (p_appr_deptshift_rec.INV_LOCATOR_ID IS NOT NULL) THEN

Line 506: FND_MSG_PUB.ADD;

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

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

517:
518: EXCEPTION
519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
520: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
521: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
522: p_count => x_msg_count,
523: p_data => x_msg_data);
524:
525: WHEN FND_API.G_EXC_ERROR THEN

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

523: p_data => x_msg_data);
524:
525: WHEN FND_API.G_EXC_ERROR THEN
526: X_return_status := FND_API.G_RET_STS_ERROR;
527: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
528: p_count => x_msg_count,
529: p_data => X_msg_data);
530:
531: WHEN OTHERS THEN

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

529: p_data => X_msg_data);
530:
531: WHEN OTHERS THEN
532: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
533: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
534: THEN
535: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_APPR_DEPT_SHIFTS_PUB',
536: p_procedure_name => 'VALIDATE_APPR_DEPT_SHIFT',
537: p_error_text => SUBSTR(SQLERRM,1,240));

Line 535: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_APPR_DEPT_SHIFTS_PUB',

531: WHEN OTHERS THEN
532: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
533: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
534: THEN
535: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_APPR_DEPT_SHIFTS_PUB',
536: p_procedure_name => 'VALIDATE_APPR_DEPT_SHIFT',
537: p_error_text => SUBSTR(SQLERRM,1,240));
538: END IF;
539: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

535: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_APPR_DEPT_SHIFTS_PUB',
536: p_procedure_name => 'VALIDATE_APPR_DEPT_SHIFT',
537: p_error_text => SUBSTR(SQLERRM,1,240));
538: END IF;
539: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
540: p_count => x_msg_count,
541: p_data => X_msg_data);
542:
543: END;

Line 589: FND_MSG_PUB.initialize;

585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
586: END IF;
587:
588: IF FND_API.to_boolean(l_init_msg_list) THEN
589: FND_MSG_PUB.initialize;
590: END IF;
591:
592: x_return_status:=FND_API.G_RET_STS_SUCCESS;
593:

Line 619: l_msg_count := FND_MSG_PUB.count_msg;

615: );
616: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
617: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Returned from TRANSLATE_VALUE_ID. x_return_status = ' || x_return_status);
618: END IF;
619: l_msg_count := FND_MSG_PUB.count_msg;
620: IF l_msg_count > 0
621: THEN
622: x_msg_count := l_msg_count;
623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 650: l_msg_count := FND_MSG_PUB.count_msg;

646: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
647: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Returned from VALIDATE_APPR_DEPT_SHIFT. x_return_status = ' || x_return_status);
648: END IF;
649:
650: l_msg_count := FND_MSG_PUB.count_msg;
651:
652: IF l_msg_count > 0
653: THEN
654: x_msg_count := l_msg_count;

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

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

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

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

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

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

Line 769: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_APPR_DEPT_SHIFTS_PUB',

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

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

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

Line 827: FND_MSG_PUB.initialize;

823: END IF;
824:
825:
826: IF FND_API.to_boolean(l_init_msg_list) THEN
827: FND_MSG_PUB.initialize;
828: END IF;
829:
830:
831: x_return_status:=FND_API.G_RET_STS_SUCCESS;

Line 856: l_msg_count := FND_MSG_PUB.count_msg;

852: x_msg_data =>l_msg_data,
853: p_appr_deptshift_rec =>l_appr_deptshift_rec);
854: END IF;
855:
856: l_msg_count := FND_MSG_PUB.count_msg;
857:
858: IF l_msg_count > 0
859: THEN
860: x_msg_count := l_msg_count;

Line 875: FND_MSG_PUB.ADD;

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

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

886: EXCEPTION
887: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
888: ROLLBACK TO DELETE_DEPT_SHIFTS;
889: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
890: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
891: p_count => x_msg_count,
892: p_data => x_msg_data);
893: WHEN FND_API.G_EXC_ERROR THEN
894: ROLLBACK TO DELETE_DEPT_SHIFTS;

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

892: p_data => x_msg_data);
893: WHEN FND_API.G_EXC_ERROR THEN
894: ROLLBACK TO DELETE_DEPT_SHIFTS;
895: X_return_status := FND_API.G_RET_STS_ERROR;
896: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
897: p_count => x_msg_count,
898: p_data => X_msg_data);
899:
900: WHEN OTHERS THEN

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

899:
900: WHEN OTHERS THEN
901: ROLLBACK TO DELETE_DEPT_SHIFTS;
902: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
903: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
904: THEN
905: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_APPR_DEPT_SHIFTS_PUB',
906: p_procedure_name => 'CREATE_APPR_DEPT_SHIFTS',
907: p_error_text => SUBSTR(SQLERRM,1,240));

Line 905: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_APPR_DEPT_SHIFTS_PUB',

901: ROLLBACK TO DELETE_DEPT_SHIFTS;
902: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
903: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
904: THEN
905: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_APPR_DEPT_SHIFTS_PUB',
906: p_procedure_name => 'CREATE_APPR_DEPT_SHIFTS',
907: p_error_text => SUBSTR(SQLERRM,1,240));
908:
909: END IF;

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

906: p_procedure_name => 'CREATE_APPR_DEPT_SHIFTS',
907: p_error_text => SUBSTR(SQLERRM,1,240));
908:
909: END IF;
910: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
911: p_count => x_msg_count,
912: p_data => X_msg_data);
913: END;
914: