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_VISITS_PVT dependencies on STANDARD

Line 667: -- Standard Start of API savepoint

663:
664: -- yazhou end
665: --
666: BEGIN
667: -- Standard Start of API savepoint
668: SAVEPOINT Process_Visit;
669:
670: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
671: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of PLSQL procedure');

Line 682: -- Standard call to check for call compatibility.

678: END IF;
679:
680: x_return_status := FND_API.G_RET_STS_SUCCESS;
681:
682: -- Standard call to check for call compatibility.
683: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
684: p_api_version,
685: l_api_name,G_PKG_NAME) THEN
686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 864: --Standard check to count messages

860: END LOOP;
861: END IF;
862:
863: ------------------------End of API Body---------------------------------------
864: --Standard check to count messages
865: l_msg_count := Fnd_Msg_Pub.count_msg;
866:
867: IF l_msg_count > 0 THEN
868: x_msg_count := l_msg_count;

Line 873: --Standard check for commit

869: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
870: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
871: END IF;
872:
873: --Standard check for commit
874: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
875: COMMIT;
876: END IF;
877:

Line 1131: -- Standard start of API savepoint

1127: l_sub_code VARCHAR2(10) := NULL;
1128: l_locator_code VARCHAR2(240) := NULL;
1129:
1130: BEGIN
1131: -- Standard start of API savepoint
1132: SAVEPOINT Get_Visit_Details;
1133:
1134: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1135: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of PLSQL procedure, p_visit_id - '||p_visit_id);

Line 1146: -- Standard call to check for call compatibility.

1142:
1143: -- Initialize API return status to success
1144: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1145:
1146: -- Standard call to check for call compatibility.
1147: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
1148: p_api_version,
1149: l_api_name,G_PKG_NAME) THEN
1150: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

Line 1326: -- Standard call to get message count and if count is 1, get message info

1322: --End Changes
1323: x_visit_rec := l_visit_rec;
1324: END IF;
1325: ------------------------End of API Body------------------------------------
1326: -- Standard call to get message count and if count is 1, get message info
1327: Fnd_Msg_Pub.Count_And_Get
1328: ( p_count => x_msg_count,
1329: p_data => x_msg_data,
1330: p_encoded => Fnd_Api.g_false);

Line 1542: -- Standard call to check for call compatibility.

1538:
1539: -- Initialize API return status to success
1540: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1541:
1542: -- Standard call to check for call compatibility.
1543: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
1544: p_api_version,
1545: l_api_name,G_PKG_NAME) THEN
1546: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

Line 1933: --Standard check to count messages

1929: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Visit ID : '||l_Visit_rec.VISIT_ID);
1930: END IF;
1931: END IF;
1932:
1933: --Standard check to count messages
1934: l_msg_count := Fnd_Msg_Pub.count_msg;
1935:
1936: IF l_msg_count > 0 THEN
1937: x_msg_count := l_msg_count;

Line 2014: --Standard check to count messages

2010: ELSE
2011: l_Visit_rec.unit_schedule_id := NULL;
2012: END IF;
2013:
2014: --Standard check to count messages
2015: l_msg_count := Fnd_Msg_Pub.count_msg;
2016:
2017: IF l_msg_count > 0 THEN
2018: x_msg_count := l_msg_count;

Line 2138: --Standard check to count messages

2134: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2135: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_VWP_TASKS_PVT.ASSOCIATE_DEFAULT_MRS - x_return_status : '||x_return_status);
2136: END IF;
2137:
2138: --Standard check to count messages
2139: l_msg_count := Fnd_Msg_Pub.count_msg;
2140:
2141: IF l_msg_count > 0 THEN
2142: X_msg_count := l_msg_count;

Line 2166: --Standard check to count messages

2162: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2163: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_VWP_TIMES_PVT.Calculate_Task_Times - l_return_status : '||l_return_status);
2164: END IF;
2165:
2166: --Standard check to count messages
2167: l_msg_count := Fnd_Msg_Pub.count_msg;
2168:
2169: IF l_msg_count > 0 THEN
2170: X_msg_count := l_msg_count;

Line 2222: --Standard check to count messages

2218: END IF;
2219: END IF;
2220: END IF; -- l_Visit_rec.visit_create_type IS NOT NULL
2221: ---------------------------End of API Body---------------------------------------
2222: --Standard check to count messages
2223: l_msg_count := Fnd_Msg_Pub.count_msg;
2224:
2225: IF l_msg_count > 0 THEN
2226: X_msg_count := l_msg_count;

Line 2231: --Standard check for commit

2227: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2228: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
2229: END IF;
2230:
2231: --Standard check for commit
2232: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
2233: COMMIT;
2234: END IF;
2235:

Line 2387: -- Standard call to check for call compatibility.

2383:
2384: -- Initialize API return status to success
2385: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2386:
2387: -- Standard call to check for call compatibility.
2388: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
2389: p_api_version,
2390: l_api_name,G_PKG_NAME) THEN
2391: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

Line 2734: --Standard check to count messages

2730: -- Return ID of the new visit
2731: p_x_Visit_rec.visit_id := l_visit_id;
2732:
2733: ---------------------------End of API Body---------------------------------------
2734: --Standard check to count messages
2735: l_msg_count := Fnd_Msg_Pub.count_msg;
2736:
2737: IF l_msg_count > 0 THEN
2738: X_msg_count := l_msg_count;

Line 2743: --Standard check for commit

2739: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2740: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
2741: END IF;
2742:
2743: --Standard check for commit
2744: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
2745: COMMIT;
2746: END IF;
2747:

Line 2915: -- Standard call to check for call compatibility.

2911:
2912: -- Initialize API return status to success
2913: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2914:
2915: -- Standard call to check for call compatibility.
2916: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
2917: p_api_version,
2918: l_api_name,G_PKG_NAME)
2919: THEN

Line 3799: --Standard check for commit

3795: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3796: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
3797: END IF;
3798:
3799: --Standard check for commit
3800: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
3801: COMMIT;
3802: END IF;
3803:

Line 4068: -- Standard call to check for call compatibility.

4064:
4065: --Initialize API return status to success
4066: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4067:
4068: -- Standard call to check for call compatibility.
4069: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
4070: p_api_version,
4071: l_api_name,G_PKG_NAME) THEN
4072: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

Line 4363: --Standard check to count messages

4359: OBJECT_VERSION_NUMBER =OBJECT_VERSION_NUMBER + 1
4360: WHERE VISIT_ID = l_visit_rec.visit_id;
4361: END IF; -- soft delete flag
4362: --------------------------End of API Body---------------------------------------
4363: --Standard check to count messages
4364: l_msg_count := Fnd_Msg_Pub.count_msg;
4365:
4366: IF l_msg_count > 0 THEN
4367: X_msg_count := l_msg_count;

Line 4372: --Standard check for commit

4368: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
4369: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4370: END IF;
4371:
4372: --Standard check for commit
4373: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
4374: COMMIT;
4375: END IF;
4376:

Line 4809: -- Standard call to check for call compatibility.

4805:
4806: -- Initialize API return status to success
4807: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4808:
4809: -- Standard call to check for call compatibility.
4810: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
4811: p_api_version,
4812: l_api_name,G_PKG_NAME) THEN
4813: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

Line 5091: -- Standard check of p_commit.

5087: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Mr Session ID:' || p_x_mr_session_id);
5088: END IF;
5089: ---------------------------End of API Body-------------------------------------
5090:
5091: -- Standard check of p_commit.
5092: IF Fnd_Api.To_Boolean ( p_commit ) THEN
5093: COMMIT WORK;
5094: END IF;
5095:

Line 5235: -- Standard call to check for call compatibility.

5231:
5232: -- Initialize API return status to success
5233: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
5234:
5235: -- Standard call to check for call compatibility.
5236: IF NOT Fnd_Api.COMPATIBLE_API_CALL( l_api_version,
5237: p_api_version,
5238: l_api_name,G_PKG_NAME) THEN
5239: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

Line 5457: -- Standard check of p_commit.

5453: CLOSE c_service_request;
5454:
5455:
5456: ---------------------------End of API Body-------------------------------------
5457: -- Standard check of p_commit.
5458:
5459: IF Fnd_Api.To_Boolean ( p_commit ) THEN
5460: COMMIT WORK;
5461: END IF;

Line 5569: -- Standard call to check for call compatibility.

5565:
5566: -- Initialize API return status to success
5567: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
5568:
5569: -- Standard call to check for call compatibility.
5570: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
5571: p_api_version,
5572: l_api_name,G_PKG_NAME)
5573: THEN

Line 5846: --Standard check for commit

5842: X_msg_count := l_msg_count;
5843: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5844: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
5845: END IF;
5846: --Standard check for commit
5847: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
5848: COMMIT;
5849: END IF;
5850: