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_TIMES_PVT dependencies on FND_MSG_PUB

Line 371: Fnd_Msg_Pub.Initialize;

367: END IF;
368:
369: -- Initialize message list if p_init_msg_list is set to TRUE
370: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
371: Fnd_Msg_Pub.Initialize;
372: END IF;
373:
374: -- Initialize API RETURN status to success
375: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 433: Fnd_Msg_Pub.Count_And_Get

429: COMMIT WORK;
430: END IF;
431:
432: -- Standard call to get message count and if count is 1, get message info
433: Fnd_Msg_Pub.Count_And_Get
434: ( p_count => x_msg_count,
435: p_data => x_msg_data,
436: p_encoded => Fnd_Api.g_false
437: );

Line 449: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,

445: EXCEPTION
446: WHEN Fnd_Api.G_EXC_ERROR THEN
447: ROLLBACK TO calculate_task_Times_pvt;
448: x_return_status := Fnd_Api.G_RET_STS_ERROR;
449: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
450: p_data => x_msg_data,
451: p_encoded => Fnd_Api.g_false);
452:
453: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

Line 456: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,

452:
453: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
454: ROLLBACK TO calculate_task_Times_pvt;
455: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
456: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
457: p_data => x_msg_data,
458: p_encoded => Fnd_Api.g_false);
459:
460: WHEN OTHERS THEN

Line 463: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN

459:
460: WHEN OTHERS THEN
461: ROLLBACK TO calculate_task_Times_pvt;
462: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
463: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
464: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
465: p_procedure_name => 'Calculate_Task_Times',
466: p_error_text => SUBSTR(SQLERRM,1,240));
467: END IF;

Line 464: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

460: WHEN OTHERS THEN
461: ROLLBACK TO calculate_task_Times_pvt;
462: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
463: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
464: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
465: p_procedure_name => 'Calculate_Task_Times',
466: p_error_text => SUBSTR(SQLERRM,1,240));
467: END IF;
468: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,

Line 468: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,

464: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
465: p_procedure_name => 'Calculate_Task_Times',
466: p_error_text => SUBSTR(SQLERRM,1,240));
467: END IF;
468: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
469: p_data => x_msg_data,
470: p_encoded => Fnd_Api.g_false);
471: END Calculate_Task_Times;
472:

Line 564: Fnd_Msg_Pub.Initialize;

560: END IF;
561:
562: -- Initialize message list if p_init_msg_list is set to TRUE
563: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
564: Fnd_Msg_Pub.Initialize;
565: END IF;
566:
567: -- Initialize API RETURN status to success
568: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 624: Fnd_Msg_Pub.Count_And_Get

620: COMMIT WORK;
621: END IF;
622:
623: -- Standard call to get message count and if count is 1, get message info
624: Fnd_Msg_Pub.Count_And_Get
625: ( p_count => x_msg_count,
626: p_data => x_msg_data,
627: p_encoded => Fnd_Api.g_false
628: );

Line 640: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,

636: EXCEPTION
637: WHEN Fnd_Api.G_EXC_ERROR THEN
638: ROLLBACK TO Adjust_Task_Times_pvt;
639: x_return_status := Fnd_Api.G_RET_STS_ERROR;
640: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
641: p_data => x_msg_data,
642: p_encoded => Fnd_Api.g_false);
643:
644: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

Line 647: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,

643:
644: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
645: ROLLBACK TO Adjust_Task_Times_pvt;
646: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
647: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
648: p_data => x_msg_data,
649: p_encoded => Fnd_Api.g_false);
650:
651: WHEN OTHERS THEN

Line 654: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN

650:
651: WHEN OTHERS THEN
652: ROLLBACK TO Adjust_Task_Times_pvt;
653: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
654: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
655: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
656: p_procedure_name => 'Adjust_Task_Times',
657: p_error_text => SUBSTR(SQLERRM,1,240));
658: END IF;

Line 655: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

651: WHEN OTHERS THEN
652: ROLLBACK TO Adjust_Task_Times_pvt;
653: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
654: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
655: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
656: p_procedure_name => 'Adjust_Task_Times',
657: p_error_text => SUBSTR(SQLERRM,1,240));
658: END IF;
659: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,

Line 659: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,

655: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
656: p_procedure_name => 'Adjust_Task_Times',
657: p_error_text => SUBSTR(SQLERRM,1,240));
658: END IF;
659: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
660: p_data => x_msg_data,
661: p_encoded => Fnd_Api.g_false);
662: END Adjust_Task_Times;
663:

Line 885: Fnd_Msg_Pub.Initialize;

881: END IF;
882:
883: -- Initialize message list if p_init_msg_list is set to TRUE
884: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
885: Fnd_Msg_Pub.Initialize;
886: END IF;
887:
888: -- Initialize API RETURN status to success
889: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 941: Fnd_Msg_Pub.Count_And_Get

937: COMMIT WORK;
938: END IF;
939:
940: -- Standard call to get message count and if count is 1, get message info
941: Fnd_Msg_Pub.Count_And_Get
942: ( p_count => x_msg_count,
943: p_data => x_msg_data,
944: p_encoded => Fnd_Api.g_false
945: );

Line 957: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,

953: EXCEPTION
954: WHEN Fnd_Api.G_EXC_ERROR THEN
955: ROLLBACK TO calculate_Times_for_dept_pvt;
956: x_return_status := Fnd_Api.G_RET_STS_ERROR;
957: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
958: p_data => x_msg_data,
959: p_encoded => Fnd_Api.g_false);
960:
961: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

Line 964: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,

960:
961: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
962: ROLLBACK TO calculate_Times_for_dept_pvt;
963: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
964: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
965: p_data => x_msg_data,
966: p_encoded => Fnd_Api.g_false);
967:
968: WHEN OTHERS THEN

Line 971: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN

967:
968: WHEN OTHERS THEN
969: ROLLBACK TO calculate_Times_for_dept_pvt;
970: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
971: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
972: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
973: p_procedure_name => 'Calculate_Task_Times_For_Dept',
974: p_error_text => SUBSTR(SQLERRM,1,240));
975: END IF;

Line 972: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,

968: WHEN OTHERS THEN
969: ROLLBACK TO calculate_Times_for_dept_pvt;
970: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
971: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
972: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
973: p_procedure_name => 'Calculate_Task_Times_For_Dept',
974: p_error_text => SUBSTR(SQLERRM,1,240));
975: END IF;
976: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,

Line 976: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,

972: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
973: p_procedure_name => 'Calculate_Task_Times_For_Dept',
974: p_error_text => SUBSTR(SQLERRM,1,240));
975: END IF;
976: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
977: p_data => x_msg_data,
978: p_encoded => Fnd_Api.g_false);
979: END Calculate_Task_Times_For_Dept;
980:

Line 1285: --Fnd_Msg_Pub.ADD;

1281: G_DAYS_ON, G_DAYS_OFF;
1282: IF (l_shift_info_csr%NOTFOUND) THEN
1283: --Fnd_Message.Set_Name('AHL','AHL_LTP_NO_SHIFT_FOR_DEPT');
1284: --Fnd_Message.Set_Token('DEPT_ID', p_department_id);
1285: --Fnd_Msg_Pub.ADD;
1286: CLOSE l_shift_info_csr;
1287: RETURN; --RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1288: END IF;
1289: CLOSE l_shift_info_csr;