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 378: -- Standard check of p_commit

374: END LOOP;
375: END IF;
376: CLOSE get_position_id_csr;
377:
378: -- Standard check of p_commit
379: IF FND_API.TO_BOOLEAN(p_commit) THEN
380: COMMIT WORK;
381: END IF;
382: -- Standard call to get message count and if count is 1, get message info

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

378: -- Standard check of p_commit
379: IF FND_API.TO_BOOLEAN(p_commit) THEN
380: COMMIT WORK;
381: END IF;
382: -- Standard call to get message count and if count is 1, get message info
383: FND_MSG_PUB.Count_And_Get
384: ( p_count => x_msg_count,
385: p_data => x_msg_data,
386: p_encoded => fnd_api.g_false

Line 505: -- Standard start of API savepoint

501: l_position_id NUMBER;
502: l_unit_csi_id NUMBER;
503: --
504: BEGIN
505: -- Standard start of API savepoint
506: SAVEPOINT Map_Instance_To_Positions_pvt;
507:
508: -- Initialize Procedure return status to success
509: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

506: SAVEPOINT Map_Instance_To_Positions_pvt;
507:
508: -- Initialize Procedure return status to success
509: x_return_status := FND_API.G_RET_STS_SUCCESS;
510: -- Standard call to check for call compatibility
511: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
512: G_PKG_NAME) THEN
513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
514: END IF;

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

606:
607: END IF;
608: CLOSE get_last_uc_rec_csr;
609:
610: -- Standard call to get message count and if count is 1, get message info
611: FND_MSG_PUB.Count_And_Get
612: ( p_count => x_msg_count,
613: p_data => x_msg_data,
614: p_encoded => fnd_api.g_false

Line 709: -- Standard start of API savepoint

705: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
706: fnd_log.string(fnd_log.level_procedure,L_FULL_NAME||'.begin','At the start of PLSQL procedure');
707: END IF;
708:
709: -- Standard start of API savepoint
710: SAVEPOINT map_position_to_instances_pvt;
711:
712: -- Initialize Procedure return status to success
713: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

710: SAVEPOINT map_position_to_instances_pvt;
711:
712: -- Initialize Procedure return status to success
713: x_return_status := FND_API.G_RET_STS_SUCCESS;
714: -- Standard call to check for call compatibility
715: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
716: G_PKG_NAME) THEN
717: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
718: END IF;

Line 867: -- Standard check of p_commit

863: END IF;
864:
865: DBMS_SQL.CLOSE_CURSOR(v_CursorID);
866:
867: -- Standard check of p_commit
868: IF FND_API.TO_BOOLEAN(p_commit) THEN
869: COMMIT WORK;
870: END IF;
871:

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

868: IF FND_API.TO_BOOLEAN(p_commit) THEN
869: COMMIT WORK;
870: END IF;
871:
872: -- Standard call to get message count and if count is 1, get message info
873: FND_MSG_PUB.Count_And_Get
874: ( p_count => x_msg_count,
875: p_data => x_msg_data,
876: p_encoded => fnd_api.g_false

Line 1072: -- Standard start of API savepoint

1068: l_full_name CONSTANT VARCHAR2(60) := 'ahl.plsql.' || g_pkg_name || '.' || l_api_name;
1069:
1070: --
1071: BEGIN
1072: -- Standard start of API savepoint
1073: SAVEPOINT Get_Pos_Empty_Instance_pvt;
1074:
1075: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1076: 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 1083: -- Standard call to check for call compatibility

1079: -- Initialize Procedure return status to success
1080: x_return_status := FND_API.G_RET_STS_SUCCESS;
1081: x_mapping_status := 'NULL';
1082:
1083: -- Standard call to check for call compatibility
1084: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1085: G_PKG_NAME) THEN
1086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1087: END IF;

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

1247:
1248: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1249: fnd_log.string(fnd_log.level_procedure, l_full_name||'.end', 'At the end of PLSQL procedure. About to count and get error messages.');
1250: END IF;
1251: -- Standard call to get message count and if count is 1, get message info
1252: FND_MSG_PUB.Count_And_Get
1253: ( p_count => x_msg_count,
1254: p_data => x_msg_data,
1255: p_encoded => fnd_api.g_false

Line 1413: -- Standard start of API savepoint

1409: l_new_position_id NUMBER;
1410: l_msg_count NUMBER;
1411: --
1412: BEGIN
1413: -- Standard start of API savepoint
1414: SAVEPOINT Copy_Positions_For_Mc_pvt;
1415:
1416: -- Initialize Procedure return status to success
1417: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1414: SAVEPOINT Copy_Positions_For_Mc_pvt;
1415:
1416: -- Initialize Procedure return status to success
1417: x_return_status := FND_API.G_RET_STS_SUCCESS;
1418: -- Standard call to check for call compatibility
1419: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1420: G_PKG_NAME) THEN
1421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1422: END IF;

Line 1514: -- Standard check of p_commit

1510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1511: END IF;
1512:
1513:
1514: -- Standard check of p_commit
1515: IF FND_API.TO_BOOLEAN(p_commit) THEN
1516: COMMIT WORK;
1517: END IF;
1518: -- Standard call to get message count and if count is 1, get message info

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

1514: -- Standard check of p_commit
1515: IF FND_API.TO_BOOLEAN(p_commit) THEN
1516: COMMIT WORK;
1517: END IF;
1518: -- Standard call to get message count and if count is 1, get message info
1519: FND_MSG_PUB.Count_And_Get
1520: ( p_count => x_msg_count,
1521: p_data => x_msg_data,
1522: p_encoded => fnd_api.g_false

Line 1606: -- Standard start of API savepoint

1602: l_msg_count NUMBER;
1603: l_msg_data varchar2(2000);
1604: --
1605: BEGIN
1606: -- Standard start of API savepoint
1607: SAVEPOINT Copy_Position_pvt;
1608:
1609: -- Initialize Procedure return status to success
1610: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1607: SAVEPOINT Copy_Position_pvt;
1608:
1609: -- Initialize Procedure return status to success
1610: x_return_status := FND_API.G_RET_STS_SUCCESS;
1611: -- Standard call to check for call compatibility
1612: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1613: G_PKG_NAME) THEN
1614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1615: END IF;

Line 1725: -- Standard check of p_commit

1721: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1723: END IF;
1724:
1725: -- Standard check of p_commit
1726: IF FND_API.TO_BOOLEAN(p_commit) THEN
1727: COMMIT WORK;
1728: END IF;
1729:

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

1726: IF FND_API.TO_BOOLEAN(p_commit) THEN
1727: COMMIT WORK;
1728: END IF;
1729:
1730: -- Standard call to get message count and if count is 1, get message info
1731: FND_MSG_PUB.Count_And_Get
1732: ( p_count => x_msg_count,
1733: p_data => x_msg_data,
1734: p_encoded => fnd_api.g_false

Line 1833: -- Standard start of API savepoint

1829: l_status VARCHAR2(80);
1830: l_num_of_version NUMBER;
1831: --
1832: BEGIN
1833: -- Standard start of API savepoint
1834: SAVEPOINT Delete_Positions_For_Mc_pvt;
1835:
1836: -- Initialize Procedure return status to success
1837: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1834: SAVEPOINT Delete_Positions_For_Mc_pvt;
1835:
1836: -- Initialize Procedure return status to success
1837: x_return_status := FND_API.G_RET_STS_SUCCESS;
1838: -- Standard call to check for call compatibility
1839: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1840: G_PKG_NAME) THEN
1841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1842: END IF;

Line 1926: -- Standard check of p_commit

1922: END LOOP;
1923: CLOSE get_nover_position_ids_csr;
1924: END IF;
1925:
1926: -- Standard check of p_commit
1927: IF FND_API.TO_BOOLEAN(p_commit) THEN
1928: COMMIT WORK;
1929: END IF;
1930: -- Standard call to get message count and if count is 1, get message info

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

1926: -- Standard check of p_commit
1927: IF FND_API.TO_BOOLEAN(p_commit) THEN
1928: COMMIT WORK;
1929: END IF;
1930: -- Standard call to get message count and if count is 1, get message info
1931: FND_MSG_PUB.Count_And_Get
1932: ( p_count => x_msg_count,
1933: p_data => x_msg_data,
1934: p_encoded => fnd_api.g_false

Line 2540: -- Standard start of API savepoint

2536: l_full_name CONSTANT VARCHAR2(60) := 'ahl.plsql.' || g_pkg_name || '.' || l_api_name;
2537:
2538: --
2539: BEGIN
2540: -- Standard start of API savepoint
2541: SAVEPOINT Map_Instance_To_Pos_ID_pvt;
2542:
2543: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2544: 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 2551: -- Standard call to check for call compatibility

2547: -- Initialize Procedure return status to success
2548: x_return_status := FND_API.G_RET_STS_SUCCESS;
2549: x_path_position_id := null;
2550:
2551: -- Standard call to check for call compatibility
2552: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
2553: G_PKG_NAME) THEN
2554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2555: END IF;

Line 2663: -- Standard check of p_commit

2659:
2660: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2661: fnd_log.string(fnd_log.level_procedure, l_full_name||'.end', 'At the end of PLSQL procedure. About to commit work.');
2662: END IF;
2663: -- Standard check of p_commit
2664: IF FND_API.TO_BOOLEAN(p_commit) THEN
2665: COMMIT WORK;
2666: END IF;
2667:

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

2664: IF FND_API.TO_BOOLEAN(p_commit) THEN
2665: COMMIT WORK;
2666: END IF;
2667:
2668: -- Standard call to get message count and if count is 1, get message info
2669: FND_MSG_PUB.Count_And_Get
2670: ( p_count => x_msg_count,
2671: p_data => x_msg_data,
2672: p_encoded => fnd_api.g_false