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_PRD_MRSHL_PVT dependencies on FND_LOG

Line 861: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

857: END IF;
858: j:= j+1;
859: END LOOP;
860: END IF;
861: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
862: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
863: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
864: ' Count : ' || to_char(j -1));
865: END IF;

Line 862: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

858: j:= j+1;
859: END LOOP;
860: END IF;
861: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
862: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
863: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
864: ' Count : ' || to_char(j -1));
865: END IF;
866: x_available_items_tbl := l_available_items_tbl;

Line 1703: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1699: j NUMBER;
1700: l_allowed_quantity NUMBER;
1701:
1702: BEGIN
1703: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1704: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1705: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
1706: 'At the start of the procedure');
1707: END IF;

Line 1704: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1700: l_allowed_quantity NUMBER;
1701:
1702: BEGIN
1703: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1704: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1705: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
1706: 'At the start of the procedure');
1707: END IF;
1708:

Line 1738: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1734: l_Uc_mrshl_details_tbl(j).parent_rel_id := l_uc_descendant_tbl(i).parent_rel_id;
1735: l_Uc_mrshl_details_tbl(j).POSITION := l_uc_descendant_tbl(i).position_reference;
1736:
1737: l_Uc_mrshl_details_tbl(j).CURR_INSTANCE_ID := l_uc_descendant_tbl(i).INSTANCE_ID;
1738: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1739: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1740: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1741: 'l_uc_descendant_tbl(i).INSTANCE_ID :: ' || l_uc_descendant_tbl(i).INSTANCE_ID);
1742: END IF;

Line 1739: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1735: l_Uc_mrshl_details_tbl(j).POSITION := l_uc_descendant_tbl(i).position_reference;
1736:
1737: l_Uc_mrshl_details_tbl(j).CURR_INSTANCE_ID := l_uc_descendant_tbl(i).INSTANCE_ID;
1738: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1739: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1740: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1741: 'l_uc_descendant_tbl(i).INSTANCE_ID :: ' || l_uc_descendant_tbl(i).INSTANCE_ID);
1742: END IF;
1743: l_Uc_mrshl_details_tbl(j).parent_instance_id := l_uc_descendant_tbl(i).parent_instance_id;

Line 1744: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1740: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1741: 'l_uc_descendant_tbl(i).INSTANCE_ID :: ' || l_uc_descendant_tbl(i).INSTANCE_ID);
1742: END IF;
1743: l_Uc_mrshl_details_tbl(j).parent_instance_id := l_uc_descendant_tbl(i).parent_instance_id;
1744: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1745: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1746: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1747: 'l_uc_descendant_tbl(i).parent_instance_id :: ' || l_uc_descendant_tbl(i).parent_instance_id);
1748: END IF;

Line 1745: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1741: 'l_uc_descendant_tbl(i).INSTANCE_ID :: ' || l_uc_descendant_tbl(i).INSTANCE_ID);
1742: END IF;
1743: l_Uc_mrshl_details_tbl(j).parent_instance_id := l_uc_descendant_tbl(i).parent_instance_id;
1744: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1745: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1746: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1747: 'l_uc_descendant_tbl(i).parent_instance_id :: ' || l_uc_descendant_tbl(i).parent_instance_id);
1748: END IF;
1749: IF l_Uc_mrshl_details_tbl(j).CURR_INSTANCE_ID IS NOT NULL THEN

Line 1778: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1774: AHL_MC_PATH_POSITION_PVT.Is_Position_Serial_Controlled(
1775: p_relationship_id => l_Uc_mrshl_details_tbl(j).relationship_id,
1776: p_path_position_id => NULL
1777: );
1778: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1779: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1780: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1781: 'l_Uc_mrshl_details_tbl(j).IS_POSITION_SER_CTRLD :: ' || l_Uc_mrshl_details_tbl(j).IS_POSITION_SER_CTRLD);
1782: END IF;

Line 1779: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1775: p_relationship_id => l_Uc_mrshl_details_tbl(j).relationship_id,
1776: p_path_position_id => NULL
1777: );
1778: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1779: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1780: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1781: 'l_Uc_mrshl_details_tbl(j).IS_POSITION_SER_CTRLD :: ' || l_Uc_mrshl_details_tbl(j).IS_POSITION_SER_CTRLD);
1782: END IF;
1783: IF(l_Uc_mrshl_details_tbl(j).IS_POSITION_SER_CTRLD = 'Y')THEN

Line 1901: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1897: j := j+1;
1898: END LOOP;
1899: END IF;
1900:
1901: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1902: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1903: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1904: 'Done fetching details');
1905: END IF;

Line 1902: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1898: END LOOP;
1899: END IF;
1900:
1901: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1902: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1903: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1904: 'Done fetching details');
1905: END IF;
1906:

Line 1908: /*IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1904: 'Done fetching details');
1905: END IF;
1906:
1907: x_Uc_mrshl_details_tbl := l_Uc_mrshl_details_tbl;
1908: /*IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1909: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1910: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1911: 'final fetch');
1912: END IF;

Line 1909: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1905: END IF;
1906:
1907: x_Uc_mrshl_details_tbl := l_Uc_mrshl_details_tbl;
1908: /*IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1909: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1910: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1911: 'final fetch');
1912: END IF;
1913: FOR get_all_details_rec IN get_all_details(p_unit_header_id) LOOP

Line 1982: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1978:
1979:
1980:
1981: BEGIN
1982: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1983: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1984: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
1985: 'At the start of the procedure');
1986: END IF;

Line 1983: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1979:
1980:
1981: BEGIN
1982: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1983: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1984: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
1985: 'At the start of the procedure');
1986: END IF;
1987:

Line 2012: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2008: l_inst_mrshl_details_tbl(j).POSITION := l_inst_mrshl_details_tbl(j).POSITION || '(' ||
2009: l_inst_mrshl_details_tbl(j).CURR_SERIAL_NUMBER || ')';
2010: END IF;
2011:
2012: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2013: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2014: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2015: 'l_inst_mrshl_details_tbl(j).IS_POSITION_SER_CTRLD :: ' || l_inst_mrshl_details_tbl(j).IS_POSITION_SER_CTRLD);
2016: END IF;

Line 2013: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2009: l_inst_mrshl_details_tbl(j).CURR_SERIAL_NUMBER || ')';
2010: END IF;
2011:
2012: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2013: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2014: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2015: 'l_inst_mrshl_details_tbl(j).IS_POSITION_SER_CTRLD :: ' || l_inst_mrshl_details_tbl(j).IS_POSITION_SER_CTRLD);
2016: END IF;
2017: IF(l_inst_mrshl_details_tbl(j).IS_POSITION_SER_CTRLD = 'Y')THEN

Line 2108: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2104: j := j+1;
2105: END LOOP;
2106: END IF;
2107:
2108: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2109: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2110: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2111: 'Done fetching details');
2112: END IF;

Line 2109: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2105: END LOOP;
2106: END IF;
2107:
2108: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2109: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2110: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2111: 'Done fetching details');
2112: END IF;
2113: