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

Line 115: -- Standard start of API savepoint

111: l_ver_spec_score NUMBER;
112: l_count NUMBER;
113: --
114: BEGIN
115: -- Standard start of API savepoint
116: SAVEPOINT Create_Position_ID_pvt;
117:
118: -- Initialize Procedure return status to success
119: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 120: -- Standard call to check for call compatibility

116: SAVEPOINT Create_Position_ID_pvt;
117:
118: -- Initialize Procedure return status to success
119: x_return_status := FND_API.G_RET_STS_SUCCESS;
120: -- Standard call to check for call compatibility
121: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
122: G_PKG_NAME) THEN
123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
124: END IF;

Line 387: -- Standard check of p_commit

383: END LOOP;
384: END IF;
385: CLOSE get_position_id_csr;
386:
387: -- Standard check of p_commit
388: IF FND_API.TO_BOOLEAN(p_commit) THEN
389: COMMIT WORK;
390: END IF;
391: -- Standard call to get message count and if count is 1, get message info

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

387: -- Standard check of p_commit
388: IF FND_API.TO_BOOLEAN(p_commit) THEN
389: COMMIT WORK;
390: END IF;
391: -- Standard call to get message count and if count is 1, get message info
392: FND_MSG_PUB.Count_And_Get
393: ( p_count => x_msg_count,
394: p_data => x_msg_data,
395: p_encoded => fnd_api.g_false

Line 537: -- Standard start of API savepoint

533: l_mc_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;
534:
535: --
536: BEGIN
537: -- Standard start of API savepoint
538: SAVEPOINT Map_Instance_To_Positions_pvt;
539:
540: -- Initialize Procedure return status to success
541: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 542: -- Standard call to check for call compatibility

538: SAVEPOINT Map_Instance_To_Positions_pvt;
539:
540: -- Initialize Procedure return status to success
541: x_return_status := FND_API.G_RET_STS_SUCCESS;
542: -- Standard call to check for call compatibility
543: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
544: G_PKG_NAME) THEN
545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
546: END IF;

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

660:
661: END IF;
662: CLOSE get_last_uc_rec_csr;
663:
664: -- Standard call to get message count and if count is 1, get message info
665: FND_MSG_PUB.Count_And_Get
666: ( p_count => x_msg_count,
667: p_data => x_msg_data,
668: p_encoded => fnd_api.g_false

Line 763: -- Standard start of API savepoint

759: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
760: fnd_log.string(fnd_log.level_procedure,L_FULL_NAME||'.begin','At the start of PLSQL procedure');
761: END IF;
762:
763: -- Standard start of API savepoint
764: SAVEPOINT map_position_to_instances_pvt;
765:
766: -- Initialize Procedure return status to success
767: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 768: -- Standard call to check for call compatibility

764: SAVEPOINT map_position_to_instances_pvt;
765:
766: -- Initialize Procedure return status to success
767: x_return_status := FND_API.G_RET_STS_SUCCESS;
768: -- Standard call to check for call compatibility
769: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
770: G_PKG_NAME) THEN
771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
772: END IF;

Line 925: -- Standard check of p_commit

921: END IF;
922:
923: DBMS_SQL.CLOSE_CURSOR(v_CursorID);
924:
925: -- Standard check of p_commit
926: IF FND_API.TO_BOOLEAN(p_commit) THEN
927: COMMIT WORK;
928: END IF;
929:

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

926: IF FND_API.TO_BOOLEAN(p_commit) THEN
927: COMMIT WORK;
928: END IF;
929:
930: -- Standard call to get message count and if count is 1, get message info
931: FND_MSG_PUB.Count_And_Get
932: ( p_count => x_msg_count,
933: p_data => x_msg_data,
934: p_encoded => fnd_api.g_false

Line 1130: -- Standard start of API savepoint

1126: l_full_name CONSTANT VARCHAR2(60) := 'ahl.plsql.' || g_pkg_name || '.' || l_api_name;
1127:
1128: --
1129: BEGIN
1130: -- Standard start of API savepoint
1131: SAVEPOINT Get_Pos_Empty_Instance_pvt;
1132:
1133: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1134: fnd_log.string(fnd_log.level_procedure, l_full_name||'.begin', 'At the start of PLSQL procedure. p_csi_item_instance_id = ' || p_csi_item_instance_id ||

Line 1141: -- Standard call to check for call compatibility

1137: -- Initialize Procedure return status to success
1138: x_return_status := FND_API.G_RET_STS_SUCCESS;
1139: x_mapping_status := 'NULL';
1140:
1141: -- Standard call to check for call compatibility
1142: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1143: G_PKG_NAME) THEN
1144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1145: END IF;

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

1305:
1306: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1307: fnd_log.string(fnd_log.level_procedure, l_full_name||'.end', 'At the end of PLSQL procedure. About to count and get error messages.');
1308: END IF;
1309: -- Standard call to get message count and if count is 1, get message info
1310: FND_MSG_PUB.Count_And_Get
1311: ( p_count => x_msg_count,
1312: p_data => x_msg_data,
1313: p_encoded => fnd_api.g_false

Line 1471: -- Standard start of API savepoint

1467: l_new_position_id NUMBER;
1468: l_msg_count NUMBER;
1469: --
1470: BEGIN
1471: -- Standard start of API savepoint
1472: SAVEPOINT Copy_Positions_For_Mc_pvt;
1473:
1474: -- Initialize Procedure return status to success
1475: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1476: -- Standard call to check for call compatibility

1472: SAVEPOINT Copy_Positions_For_Mc_pvt;
1473:
1474: -- Initialize Procedure return status to success
1475: x_return_status := FND_API.G_RET_STS_SUCCESS;
1476: -- Standard call to check for call compatibility
1477: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1478: G_PKG_NAME) THEN
1479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1480: END IF;

Line 1572: -- Standard check of p_commit

1568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1569: END IF;
1570:
1571:
1572: -- Standard check of p_commit
1573: IF FND_API.TO_BOOLEAN(p_commit) THEN
1574: COMMIT WORK;
1575: END IF;
1576: -- Standard call to get message count and if count is 1, get message info

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

1572: -- Standard check of p_commit
1573: IF FND_API.TO_BOOLEAN(p_commit) THEN
1574: COMMIT WORK;
1575: END IF;
1576: -- Standard call to get message count and if count is 1, get message info
1577: FND_MSG_PUB.Count_And_Get
1578: ( p_count => x_msg_count,
1579: p_data => x_msg_data,
1580: p_encoded => fnd_api.g_false

Line 1664: -- Standard start of API savepoint

1660: l_msg_count NUMBER;
1661: l_msg_data varchar2(2000);
1662: --
1663: BEGIN
1664: -- Standard start of API savepoint
1665: SAVEPOINT Copy_Position_pvt;
1666:
1667: -- Initialize Procedure return status to success
1668: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1669: -- Standard call to check for call compatibility

1665: SAVEPOINT Copy_Position_pvt;
1666:
1667: -- Initialize Procedure return status to success
1668: x_return_status := FND_API.G_RET_STS_SUCCESS;
1669: -- Standard call to check for call compatibility
1670: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1671: G_PKG_NAME) THEN
1672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1673: END IF;

Line 1783: -- Standard check of p_commit

1779: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1781: END IF;
1782:
1783: -- Standard check of p_commit
1784: IF FND_API.TO_BOOLEAN(p_commit) THEN
1785: COMMIT WORK;
1786: END IF;
1787:

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

1784: IF FND_API.TO_BOOLEAN(p_commit) THEN
1785: COMMIT WORK;
1786: END IF;
1787:
1788: -- Standard call to get message count and if count is 1, get message info
1789: FND_MSG_PUB.Count_And_Get
1790: ( p_count => x_msg_count,
1791: p_data => x_msg_data,
1792: p_encoded => fnd_api.g_false

Line 1891: -- Standard start of API savepoint

1887: l_status VARCHAR2(80);
1888: l_num_of_version NUMBER;
1889: --
1890: BEGIN
1891: -- Standard start of API savepoint
1892: SAVEPOINT Delete_Positions_For_Mc_pvt;
1893:
1894: -- Initialize Procedure return status to success
1895: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1896: -- Standard call to check for call compatibility

1892: SAVEPOINT Delete_Positions_For_Mc_pvt;
1893:
1894: -- Initialize Procedure return status to success
1895: x_return_status := FND_API.G_RET_STS_SUCCESS;
1896: -- Standard call to check for call compatibility
1897: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1898: G_PKG_NAME) THEN
1899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1900: END IF;

Line 1984: -- Standard check of p_commit

1980: END LOOP;
1981: CLOSE get_nover_position_ids_csr;
1982: END IF;
1983:
1984: -- Standard check of p_commit
1985: IF FND_API.TO_BOOLEAN(p_commit) THEN
1986: COMMIT WORK;
1987: END IF;
1988: -- Standard call to get message count and if count is 1, get message info

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

1984: -- Standard check of p_commit
1985: IF FND_API.TO_BOOLEAN(p_commit) THEN
1986: COMMIT WORK;
1987: END IF;
1988: -- Standard call to get message count and if count is 1, get message info
1989: FND_MSG_PUB.Count_And_Get
1990: ( p_count => x_msg_count,
1991: p_data => x_msg_data,
1992: p_encoded => fnd_api.g_false

Line 2598: -- Standard start of API savepoint

2594: l_full_name CONSTANT VARCHAR2(60) := 'ahl.plsql.' || g_pkg_name || '.' || l_api_name;
2595:
2596: --
2597: BEGIN
2598: -- Standard start of API savepoint
2599: SAVEPOINT Map_Instance_To_Pos_ID_pvt;
2600:
2601: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2602: fnd_log.string(fnd_log.level_procedure, l_full_name||'.begin', 'At the start of PLSQL procedure. p_csi_item_instance_id = ' || p_csi_item_instance_id ||

Line 2609: -- Standard call to check for call compatibility

2605: -- Initialize Procedure return status to success
2606: x_return_status := FND_API.G_RET_STS_SUCCESS;
2607: x_path_position_id := null;
2608:
2609: -- Standard call to check for call compatibility
2610: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
2611: G_PKG_NAME) THEN
2612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2613: END IF;

Line 2721: -- Standard check of p_commit

2717:
2718: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2719: fnd_log.string(fnd_log.level_procedure, l_full_name||'.end', 'At the end of PLSQL procedure. About to commit work.');
2720: END IF;
2721: -- Standard check of p_commit
2722: IF FND_API.TO_BOOLEAN(p_commit) THEN
2723: COMMIT WORK;
2724: END IF;
2725:

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

2722: IF FND_API.TO_BOOLEAN(p_commit) THEN
2723: COMMIT WORK;
2724: END IF;
2725:
2726: -- Standard call to get message count and if count is 1, get message info
2727: FND_MSG_PUB.Count_And_Get
2728: ( p_count => x_msg_count,
2729: p_data => x_msg_data,
2730: p_encoded => fnd_api.g_false