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 486: Fnd_Msg_Pub.Initialize;

482: END IF;
483:
484: -- Initialize message list if p_init_msg_list is set to TRUE
485: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
486: Fnd_Msg_Pub.Initialize;
487: END IF;
488:
489: -- Initialize API RETURN status to success
490: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 508: --Fnd_Msg_Pub.ADD;

504: AND nvl(Status_Code, 'X') <>'DELETED';
505:
506: --Fnd_Message.Set_Name('AHL','AHL_LTP_VISIT_ID_INVALID');
507: --Fnd_Message.Set_Token('VISIT_ID', p_visit_id);
508: --Fnd_Msg_Pub.ADD;
509: CLOSE get_visit_data_csr;
510: RETURN;
511: END IF;
512: CLOSE get_visit_data_csr;

Line 518: --Fnd_Msg_Pub.ADD;

514: /*
515: --Can not evaluate if either visit start date or visit department is null
516: IF (G_VISIT_START_DATE IS NULL) THEN
517: --Fnd_Message.Set_Name('AHL','AHL_LTP_VISIT_ST_DATE_NULL');
518: --Fnd_Msg_Pub.ADD;
519: RETURN;
520: ELSIF (G_VISIT_DEPT_ID IS NULL) THEN
521: --Fnd_Message.Set_Name('AHL','AHL_LTP_VISIT_DEPT_NULL');
522: --Fnd_Msg_Pub.ADD;

Line 522: --Fnd_Msg_Pub.ADD;

518: --Fnd_Msg_Pub.ADD;
519: RETURN;
520: ELSIF (G_VISIT_DEPT_ID IS NULL) THEN
521: --Fnd_Message.Set_Name('AHL','AHL_LTP_VISIT_DEPT_NULL');
522: --Fnd_Msg_Pub.ADD;
523: RETURN;
524: END IF;
525: */
526:

Line 604: Fnd_Msg_Pub.Count_And_Get

600: COMMIT WORK;
601: END IF;
602:
603: -- Standard call to get message count and if count is 1, get message info
604: Fnd_Msg_Pub.Count_And_Get
605: ( p_count => x_msg_count,
606: p_data => x_msg_data,
607: p_encoded => Fnd_Api.g_false
608: );

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

616: EXCEPTION
617: WHEN Fnd_Api.G_EXC_ERROR THEN
618: ROLLBACK TO calculate_task_Times_pvt;
619: x_return_status := Fnd_Api.G_RET_STS_ERROR;
620: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
621: p_data => x_msg_data,
622: p_encoded => Fnd_Api.g_false);
623:
624: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

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

623:
624: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
625: ROLLBACK TO calculate_task_Times_pvt;
626: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
627: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
628: p_data => x_msg_data,
629: p_encoded => Fnd_Api.g_false);
630:
631: WHEN OTHERS THEN

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

630:
631: WHEN OTHERS THEN
632: ROLLBACK TO calculate_task_Times_pvt;
633: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
634: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
635: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
636: p_procedure_name => 'Calculate_Task_Times',
637: p_error_text => SUBSTR(SQLERRM,1,240));
638: END IF;

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

631: WHEN OTHERS THEN
632: ROLLBACK TO calculate_task_Times_pvt;
633: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
634: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
635: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
636: p_procedure_name => 'Calculate_Task_Times',
637: p_error_text => SUBSTR(SQLERRM,1,240));
638: END IF;
639: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,

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

635: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
636: p_procedure_name => 'Calculate_Task_Times',
637: p_error_text => SUBSTR(SQLERRM,1,240));
638: END IF;
639: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
640: p_data => x_msg_data,
641: p_encoded => Fnd_Api.g_false);
642: END Calculate_Task_Times;
643:

Line 715: Fnd_Msg_Pub.Initialize;

711: END IF;
712:
713: -- Initialize message list if p_init_msg_list is set to TRUE
714: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
715: Fnd_Msg_Pub.Initialize;
716: END IF;
717:
718: -- Initialize API RETURN status to success
719: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 728: --Fnd_Msg_Pub.ADD;

724: FETCH get_visit_data_csr INTO G_VISIT_START_DATE, G_VISIT_DEPT_ID, l_visit_id, G_VISIT_STATUS;
725: IF (get_visit_data_csr%NOTFOUND) THEN
726: --Fnd_Message.Set_Name('AHL','AHL_LTP_VISIT_ID_INVALID');
727: --Fnd_Message.Set_Token('VISIT_ID', l_visit_id);
728: --Fnd_Msg_Pub.ADD;
729: CLOSE get_visit_data_csr;
730: RETURN;
731: END IF;
732: CLOSE get_visit_data_csr;

Line 737: --Fnd_Msg_Pub.ADD;

733:
734: --Can not evaluate if either visit start date or visit department is null
735: IF (G_VISIT_START_DATE IS NULL)THEN
736: --Fnd_Message.Set_Name('AHL','AHL_LTP_VISIT_ST_DATE_NULL');
737: --Fnd_Msg_Pub.ADD;
738: RETURN;
739: ELSIF (G_VISIT_DEPT_ID IS NULL) THEN
740: --Fnd_Message.Set_Name('AHL','AHL_LTP_VISIT_DEPT_NULL');
741: --Fnd_Msg_Pub.ADD;

Line 741: --Fnd_Msg_Pub.ADD;

737: --Fnd_Msg_Pub.ADD;
738: RETURN;
739: ELSIF (G_VISIT_DEPT_ID IS NULL) THEN
740: --Fnd_Message.Set_Name('AHL','AHL_LTP_VISIT_DEPT_NULL');
741: --Fnd_Msg_Pub.ADD;
742: RETURN;
743: END IF;
744:
745: --2. Derive the stage time durations

Line 763: Fnd_Msg_Pub.Count_And_Get

759: COMMIT WORK;
760: END IF;
761:
762: -- Standard call to get message count and if count is 1, get message info
763: Fnd_Msg_Pub.Count_And_Get
764: ( p_count => x_msg_count,
765: p_data => x_msg_data,
766: p_encoded => Fnd_Api.g_false
767: );

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

775: EXCEPTION
776: WHEN Fnd_Api.G_EXC_ERROR THEN
777: ROLLBACK TO Adjust_Task_Times_pvt;
778: x_return_status := Fnd_Api.G_RET_STS_ERROR;
779: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
780: p_data => x_msg_data,
781: p_encoded => Fnd_Api.g_false);
782:
783: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

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

782:
783: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
784: ROLLBACK TO Adjust_Task_Times_pvt;
785: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
786: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
787: p_data => x_msg_data,
788: p_encoded => Fnd_Api.g_false);
789:
790: WHEN OTHERS THEN

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

789:
790: WHEN OTHERS THEN
791: ROLLBACK TO Adjust_Task_Times_pvt;
792: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
793: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
794: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
795: p_procedure_name => 'Adjust_Task_Times',
796: p_error_text => SUBSTR(SQLERRM,1,240));
797: END IF;

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

790: WHEN OTHERS THEN
791: ROLLBACK TO Adjust_Task_Times_pvt;
792: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
793: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
794: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
795: p_procedure_name => 'Adjust_Task_Times',
796: p_error_text => SUBSTR(SQLERRM,1,240));
797: END IF;
798: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,

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

794: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
795: p_procedure_name => 'Adjust_Task_Times',
796: p_error_text => SUBSTR(SQLERRM,1,240));
797: END IF;
798: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
799: p_data => x_msg_data,
800: p_encoded => Fnd_Api.g_false);
801: END Adjust_Task_Times;
802:

Line 1012: Fnd_Msg_Pub.Initialize;

1008: END IF;
1009:
1010: -- Initialize message list if p_init_msg_list is set to TRUE
1011: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
1012: Fnd_Msg_Pub.Initialize;
1013: END IF;
1014:
1015: -- Initialize API RETURN status to success
1016: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 1068: Fnd_Msg_Pub.Count_And_Get

1064: COMMIT WORK;
1065: END IF;
1066:
1067: -- Standard call to get message count and if count is 1, get message info
1068: Fnd_Msg_Pub.Count_And_Get
1069: ( p_count => x_msg_count,
1070: p_data => x_msg_data,
1071: p_encoded => Fnd_Api.g_false
1072: );

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

1080: EXCEPTION
1081: WHEN Fnd_Api.G_EXC_ERROR THEN
1082: ROLLBACK TO calculate_Times_for_dept_pvt;
1083: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1084: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
1085: p_data => x_msg_data,
1086: p_encoded => Fnd_Api.g_false);
1087:
1088: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

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

1087:
1088: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1089: ROLLBACK TO calculate_Times_for_dept_pvt;
1090: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1091: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
1092: p_data => x_msg_data,
1093: p_encoded => Fnd_Api.g_false);
1094:
1095: WHEN OTHERS THEN

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

1094:
1095: WHEN OTHERS THEN
1096: ROLLBACK TO calculate_Times_for_dept_pvt;
1097: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1098: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1099: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
1100: p_procedure_name => 'Calculate_Task_Times_For_Dept',
1101: p_error_text => SUBSTR(SQLERRM,1,240));
1102: END IF;

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

1095: WHEN OTHERS THEN
1096: ROLLBACK TO calculate_Times_for_dept_pvt;
1097: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1098: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1099: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
1100: p_procedure_name => 'Calculate_Task_Times_For_Dept',
1101: p_error_text => SUBSTR(SQLERRM,1,240));
1102: END IF;
1103: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,

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

1099: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
1100: p_procedure_name => 'Calculate_Task_Times_For_Dept',
1101: p_error_text => SUBSTR(SQLERRM,1,240));
1102: END IF;
1103: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
1104: p_data => x_msg_data,
1105: p_encoded => Fnd_Api.g_false);
1106: END Calculate_Task_Times_For_Dept;
1107:

Line 1375: --Fnd_Msg_Pub.ADD;

1371: G_DAYS_ON, G_DAYS_OFF;
1372: IF (l_shift_info_csr%NOTFOUND) THEN
1373: --Fnd_Message.Set_Name('AHL','AHL_LTP_NO_SHIFT_FOR_DEPT');
1374: --Fnd_Message.Set_Token('DEPT_ID', p_department_id);
1375: --Fnd_Msg_Pub.ADD;
1376: CLOSE l_shift_info_csr;
1377: RETURN; --RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1378: END IF;
1379: CLOSE l_shift_info_csr;