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

Line 276: -- Standard start of API savepoint

272:
273: l_stage_date_rec c_stage_date%rowtype;
274:
275: BEGIN
276: -- Standard start of API savepoint
277: SAVEPOINT Get_Stages_Details;
278:
279: -- Check if API is called in debug mode. If yes, enable debug.
280: IF G_DEBUG='Y' THEN

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

294:
295: -- Initialize API return status to success
296: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
297:
298: -- Standard call to check for call compatibility.
299: IF NOT Fnd_Api.compatible_api_call(
300: l_api_version,
301: p_api_version,
302: l_api_name,

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

412: --------------------------
413: x_stages_tbl := l_stages_tbl;
414:
415: ------------------------End of API Body------------------------------------
416: -- Standard call to get message count and if count is 1, get message info
417: Fnd_Msg_Pub.Count_And_Get
418: ( p_count => x_msg_count,
419: p_data => x_msg_data,
420: p_encoded => Fnd_Api.g_false);

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

565: -- Initialize API return status to success
566: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
567: l_return_status := x_return_status;
568:
569: -- Standard call to check for call compatibility.
570: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
571: p_api_version,
572: l_api_name,G_PKG_NAME)
573: THEN

Line 788: --Standard check to count messages

784: RAISE Fnd_Api.G_EXC_ERROR;
785: END IF;
786:
787: ---------------------------End of API Body---------------------------------------
788: --Standard check to count messages
789: l_msg_count := Fnd_Msg_Pub.count_msg;
790: IF l_msg_count > 0 THEN
791: X_msg_count := l_msg_count;
792: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 796: --Standard check for commit

792: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
793: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
794: END IF;
795:
796: --Standard check for commit
797: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
798: COMMIT;
799: END IF;
800:

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

973: -- Initialize API return status to success
974: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
975: l_return_status := x_return_status;
976:
977: -- Standard call to check for call compatibility.
978: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
979: p_api_version,
980: l_api_name,G_PKG_NAME)
981: THEN

Line 1013: /* --Standard check to count messages

1009: end if;
1010: close c_check_visit_status;
1011:
1012: -- Commented by amagrawa as per review commenst.
1013: /* --Standard check to count messages
1014: l_msg_count := Fnd_Msg_Pub.count_msg;
1015:
1016: IF l_msg_count > 0 THEN
1017: x_msg_count := l_msg_count;

Line 1292: --Standard check to count messages

1288:
1289: END IF;
1290:
1291:
1292: --Standard check to count messages
1293: l_msg_count := Fnd_Msg_Pub.count_msg;
1294:
1295: IF l_msg_count > 0 THEN
1296: X_msg_count := l_msg_count;

Line 1301: --Standard check for commit

1297: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1298: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1299: END IF;
1300:
1301: --Standard check for commit
1302: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
1303: COMMIT;
1304: END IF;
1305:

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

1442: -- Initialize API return status to success
1443: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1444: l_return_status := x_return_status;
1445:
1446: -- Standard call to check for call compatibility.
1447: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
1448: p_api_version,
1449: l_api_name,G_PKG_NAME)
1450: THEN

Line 1612: --Standard check to count messages

1608:
1609: -- Since stage deletion ios allowed only if no tasks associated to it
1610: END LOOP;
1611:
1612: --Standard check to count messages
1613: l_msg_count := Fnd_Msg_Pub.count_msg;
1614: IF l_msg_count > 0 THEN
1615: X_msg_count := l_msg_count;
1616: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 1620: --Standard check for commit

1616: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1617: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1618: END IF;
1619:
1620: --Standard check for commit
1621: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
1622: COMMIT;
1623: END IF;
1624:

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

1717:
1718: -- Initialize API return status to success
1719: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1720:
1721: -- Standard call to check for call compatibility.
1722: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
1723: p_api_version,
1724: l_api_name,G_PKG_NAME)
1725: THEN

Line 1755: --Standard check to count messages

1751:
1752: -- directly delete as we need to delete all stages for the visit
1753:
1754: ---------------------------End of API Body---------------------------------------
1755: --Standard check to count messages
1756: l_msg_count := Fnd_Msg_Pub.count_msg;
1757: IF l_msg_count > 0 THEN
1758: X_msg_count := l_msg_count;
1759: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 1763: --Standard check for commit

1759: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1760: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1761: END IF;
1762:
1763: --Standard check for commit
1764: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
1765: COMMIT;
1766: END IF;
1767:

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

2133: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
2134: Fnd_Msg_Pub.initialize;
2135: END IF;
2136:
2137: -- Standard call to check for call compatibility.
2138: IF NOT Fnd_Api.compatible_api_call (
2139: l_api_version,
2140: p_api_version,
2141: l_api_name,

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

2929:
2930: -- Initialize API return status to success
2931: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2932:
2933: -- Standard call to check for call compatibility.
2934: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
2935: p_api_version,
2936: l_api_name,G_PKG_NAME)
2937: THEN

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

3208:
3209: -- Initialize API return status to success
3210: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3211:
3212: -- Standard call to check for call compatibility.
3213: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
3214: p_api_version,
3215: l_api_name,G_PKG_NAME)
3216: THEN

Line 3514: -- Standard check of p_commit

3510: RAISE Fnd_Api.g_exc_unexpected_error;
3511: END IF;
3512: END IF;
3513:
3514: -- Standard check of p_commit
3515: IF FND_API.TO_BOOLEAN(p_commit) THEN
3516: COMMIT WORK;
3517: END IF;
3518:

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

3727: --Initialize API return status to success
3728: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3729: l_return_status := x_return_status;
3730:
3731: -- Standard call to check for call compatibility.
3732: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3733: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3734: END IF;
3735:

Line 3771: --Standard check for commit

3767: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3768: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
3769: END IF;
3770:
3771: --Standard check for commit
3772: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
3773: COMMIT;
3774: END IF;
3775:

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

3886: --Initialize API return status to success
3887: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3888: l_return_status := x_return_status;
3889:
3890: -- Standard call to check for call compatibility.
3891: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3893: END IF;
3894:

Line 4015: --Standard check for commit

4011: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
4012: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4013: END IF;
4014:
4015: --Standard check for commit
4016: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
4017: COMMIT;
4018: END IF;
4019:

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

4407: --Initialize API return status to success
4408: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4409: l_return_status := x_return_status;
4410:
4411: -- Standard call to check for call compatibility.
4412: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4414: END IF;
4415:

Line 4589: --Standard check for commit

4585: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
4586: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4587: END IF;
4588:
4589: --Standard check for commit
4590: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
4591: COMMIT;
4592: END IF;
4593:

Line 5188: --Standard check to count messages

5184: IF l_isValidationFailed THEN
5185: RAISE Fnd_Api.G_EXC_ERROR;
5186: END IF;
5187:
5188: --Standard check to count messages
5189: l_msg_count := Fnd_Msg_Pub.count_msg;
5190: IF l_msg_count > 0 THEN
5191: X_msg_count := l_msg_count;
5192: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 5357: --Standard check to count messages

5353: END IF;
5354:
5355: END IF;
5356:
5357: --Standard check to count messages
5358: l_msg_count := Fnd_Msg_Pub.count_msg;
5359: IF l_msg_count > 0 THEN
5360: X_msg_count := l_msg_count;
5361: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 5512: --Standard check to count messages

5508: l_obj_stage_id := p_all_stage_details.NEXT(l_obj_stage_id);
5509:
5510: END LOOP;
5511:
5512: --Standard check to count messages
5513: l_msg_count := Fnd_Msg_Pub.count_msg;
5514: IF l_msg_count > 0 THEN
5515: X_msg_count := l_msg_count;
5516: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 5662: --Standard check to count messages

5658:
5659: l_stage_id := p_valid_stages.NEXT(l_stage_id);
5660: END LOOP;
5661:
5662: --Standard check to count messages
5663: l_msg_count := Fnd_Msg_Pub.count_msg;
5664: IF l_msg_count > 0 THEN
5665: X_msg_count := l_msg_count;
5666: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 5994: --Standard check to count messages

5990: END IF;
5991: END IF;
5992: -- PRAKKUM :: 13-FEB-2011 :: Bug 13711800 :: END
5993:
5994: --Standard check to count messages
5995: l_msg_count := Fnd_Msg_Pub.count_msg;
5996: IF l_msg_count > 0 THEN
5997: X_msg_count := l_msg_count;
5998: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 6119: --Standard check to count messages

6115: IF (l_log_statement >= l_log_current_level) THEN
6116: fnd_log.string(l_log_statement,L_DEBUG,' p_x_stages_ovn_tbl count is '||p_x_stages_ovn_tbl.count);
6117: END IF;
6118:
6119: --Standard check to count messages
6120: l_msg_count := Fnd_Msg_Pub.count_msg;
6121: IF l_msg_count > 0 THEN
6122: X_msg_count := l_msg_count;
6123: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 6240: --Standard check to count messages

6236: IF (l_log_statement >= l_log_current_level) THEN
6237: fnd_log.string(l_log_statement,L_DEBUG,' l_isValidationFailed --@>'|| l_isValidationFailed);
6238: END IF;
6239:
6240: --Standard check to count messages
6241: l_msg_count := Fnd_Msg_Pub.count_msg;
6242: IF l_msg_count > 0 THEN
6243: X_msg_count := l_msg_count;
6244: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;