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.BIS_UTILITIES_PUB dependencies on BIS_UTILITIES_PVT

Line 54: BIS_UTILITIES_PVT.Add_Error_Message

50: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
51: when others then
52: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
53: l_error_tbl := x_error_Tbl;
54: BIS_UTILITIES_PVT.Add_Error_Message
55: ( p_error_msg_id => SQLCODE
56: , p_error_description => SQLERRM
57: , p_error_proc_name => G_PKG_NAME||'.Retrieve_User'
58: , p_error_table => l_error_tbl

Line 104: BIS_UTILITIES_PVT.Add_Error_Message

100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
101: when others then
102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
103: l_error_tbl := x_error_Tbl;
104: BIS_UTILITIES_PVT.Add_Error_Message
105: ( p_error_msg_id => SQLCODE
106: , p_error_description => SQLERRM
107: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Organization'
108: , p_error_table => l_error_tbl

Line 206: IF p_dimension_short_name = BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME(p_DimLevelId => NULL

202: ELSE
203: l_user_id := p_user_id;
204: END IF;
205:
206: IF p_dimension_short_name = BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME(p_DimLevelId => NULL
207: ,p_DimLevelName => l_dim_level_short_name) THEN --'ORGANIZATION'
208: Retrieve_Org_Where_Clause
209: ( p_database_object => l_database_object
210: , p_user_id => l_user_id

Line 217: ELSIF p_dimension_short_name = BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME(p_DimLevelId => NULL

213: , x_return_status => x_return_status
214: , x_error_tbl => x_error_tbl
215: );
216:
217: ELSIF p_dimension_short_name = BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME(p_DimLevelId => NULL
218: ,p_DimLevelName => l_dim_level_short_name) THEN
219: IF ( BIS_UTILITIES_PUB.Value_Missing(p_organization_id) = FND_API.G_TRUE ) THEN -- 2694965
220: RAISE FND_API.G_EXC_ERROR;
221: END IF;

Line 255: BIS_UTILITIES_PVT.Add_Error_Message

251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
252: when others then
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
254: l_error_tbl := x_error_Tbl;
255: BIS_UTILITIES_PVT.Add_Error_Message
256: ( p_error_msg_id => SQLCODE
257: , p_error_description => SQLERRM
258: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Where_Clause'
259: , p_error_table => l_error_tbl

Line 386: BIS_UTILITIES_PVT.Add_Error_Message

382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
383: when others then
384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
385: l_error_tbl := x_error_Tbl;
386: BIS_UTILITIES_PVT.Add_Error_Message
387: ( p_error_msg_id => SQLCODE
388: , p_error_description => SQLERRM
389: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Org_Where_Clause'
390: , p_error_table => l_error_tbl

Line 514: BIS_UTILITIES_PVT.Add_Error_Message

510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
511: when others then
512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
513: l_error_tbl := x_error_Tbl;
514: BIS_UTILITIES_PVT.Add_Error_Message
515: ( p_error_msg_id => SQLCODE
516: , p_error_description => SQLERRM
517: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Time_Where_Clause'
518: , p_error_table => l_error_tbl

Line 561: BIS_UTILITIES_PVT.Add_Error_Message

557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
558: when others then
559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
560: l_error_tbl := x_error_Tbl;
561: BIS_UTILITIES_PVT.Add_Error_Message
562: ( p_error_msg_id => SQLCODE
563: , p_error_description => SQLERRM
564: , p_error_proc_name => G_PKG_NAME||'.Retrieve_DimX_Where_Clause'
565: , p_error_table => l_error_tbl

Line 738: return BIS_UTILITIES_PVT.Value_Not_Missing(p_value);

734: p_value IN VARCHAR2 )
735: RETURN VARCHAR2
736: IS
737: BEGIN
738: return BIS_UTILITIES_PVT.Value_Not_Missing(p_value);
739: END Value_Not_Missing;
740:
741: FUNCTION Value_Not_Missing(
742: p_value IN NUMBER )

Line 746: return BIS_UTILITIES_PVT.Value_Not_Missing(p_value);

742: p_value IN NUMBER )
743: RETURN VARCHAR2
744: IS
745: BEGIN
746: return BIS_UTILITIES_PVT.Value_Not_Missing(p_value);
747: END Value_Not_Missing;
748:
749: FUNCTION Value_Not_Missing(
750: p_value IN DATE )

Line 754: return BIS_UTILITIES_PVT.Value_Not_Missing(p_value);

750: p_value IN DATE )
751: RETURN VARCHAR2
752: IS
753: BEGIN
754: return BIS_UTILITIES_PVT.Value_Not_Missing(p_value);
755: END Value_Not_Missing;
756:
757: FUNCTION Value_Missing(
758: p_value IN VARCHAR2 )

Line 762: return BIS_UTILITIES_PVT.Value_Missing(p_value);

758: p_value IN VARCHAR2 )
759: RETURN VARCHAR2
760: IS
761: BEGIN
762: return BIS_UTILITIES_PVT.Value_Missing(p_value);
763: END Value_Missing;
764:
765: FUNCTION Value_Missing(
766: p_value IN NUMBER )

Line 770: return BIS_UTILITIES_PVT.Value_Missing(p_value);

766: p_value IN NUMBER )
767: RETURN VARCHAR2
768: IS
769: BEGIN
770: return BIS_UTILITIES_PVT.Value_Missing(p_value);
771: END Value_Missing;
772:
773: FUNCTION Value_Missing(
774: p_value IN DATE )

Line 778: return BIS_UTILITIES_PVT.Value_Missing(p_value);

774: p_value IN DATE )
775: RETURN VARCHAR2
776: IS
777: BEGIN
778: return BIS_UTILITIES_PVT.Value_Missing(p_value);
779: END Value_Missing;
780:
781: FUNCTION Value_Not_NULL(
782: p_value IN VARCHAR2 )

Line 786: return BIS_UTILITIES_PVT.Value_Not_NULL(p_value);

782: p_value IN VARCHAR2 )
783: RETURN VARCHAR2
784: IS
785: BEGIN
786: return BIS_UTILITIES_PVT.Value_Not_NULL(p_value);
787: END Value_Not_NULL;
788:
789: FUNCTION Value_Not_NULL(
790: p_value IN NUMBER )

Line 794: return BIS_UTILITIES_PVT.Value_Not_NULL(p_value);

790: p_value IN NUMBER )
791: RETURN VARCHAR2
792: IS
793: BEGIN
794: return BIS_UTILITIES_PVT.Value_Not_NULL(p_value);
795: END Value_Not_NULL;
796:
797: FUNCTION Value_Not_NULL(
798: p_value IN DATE )

Line 802: return BIS_UTILITIES_PVT.Value_Not_NULL(p_value);

798: p_value IN DATE )
799: RETURN VARCHAR2
800: IS
801: BEGIN
802: return BIS_UTILITIES_PVT.Value_Not_NULL(p_value);
803: END Value_Not_NULL;
804:
805: FUNCTION Value_NULL(
806: p_value IN VARCHAR2 )

Line 810: return BIS_UTILITIES_PVT.Value_NULL(p_value);

806: p_value IN VARCHAR2 )
807: RETURN VARCHAR2
808: IS
809: BEGIN
810: return BIS_UTILITIES_PVT.Value_NULL(p_value);
811: END Value_NULL;
812:
813: FUNCTION Value_NULL(
814: p_value IN NUMBER )

Line 818: return BIS_UTILITIES_PVT.Value_NULL(p_value);

814: p_value IN NUMBER )
815: RETURN VARCHAR2
816: IS
817: BEGIN
818: return BIS_UTILITIES_PVT.Value_NULL(p_value);
819: END Value_NULL;
820:
821: FUNCTION Value_NULL(
822: p_value IN DATE )

Line 826: return BIS_UTILITIES_PVT.Value_NULL(p_value);

822: p_value IN DATE )
823: RETURN VARCHAR2
824: IS
825: BEGIN
826: return BIS_UTILITIES_PVT.Value_NULL(p_value);
827: END Value_NULL;
828:
829: PROCEDURE Build_HTML_Banner
830: ( p_title IN VARCHAR2

Line 855: BIS_UTILITIES_PVT.Add_Error_Message

851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
852: when others then
853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
854: l_error_tbl := x_error_Tbl;
855: BIS_UTILITIES_PVT.Add_Error_Message
856: ( p_error_msg_id => SQLCODE
857: , p_error_description => SQLERRM
858: , p_error_proc_name => G_PKG_NAME||'.Build_HTML_Banner'
859: , p_error_table => l_error_tbl

Line 894: BIS_UTILITIES_PVT.Add_Error_Message

890: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
891: when others then
892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
893: l_error_tbl := x_error_Tbl;
894: BIS_UTILITIES_PVT.Add_Error_Message
895: ( p_error_msg_id => SQLCODE
896: , p_error_description => SQLERRM
897: , p_error_proc_name => G_PKG_NAME||'.Build_HTML_Banner'
898: , p_error_table => l_error_tbl

Line 1276: BIS_UTILITIES_PVT.Add_Error_Message

1272: EXCEPTION
1273: WHEN FND_API.G_EXC_ERROR THEN
1274: x_return_status := FND_API.G_RET_STS_ERROR;
1275: l_error_tbl := x_error_tbl;
1276: BIS_UTILITIES_PVT.Add_Error_Message
1277: ( p_error_table => l_error_Tbl
1278: , p_error_msg_id => SQLCODE
1279: , p_error_description => SQLERRM
1280: , x_error_table => x_error_Tbl

Line 1289: BIS_UTILITIES_PVT.Add_Error_Message

1285: );
1286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1288: l_error_tbl := x_error_tbl;
1289: BIS_UTILITIES_PVT.Add_Error_Message
1290: ( p_error_table => l_error_Tbl
1291: , p_error_msg_id => SQLCODE
1292: , p_error_description => SQLERRM
1293: , x_error_table => x_error_Tbl

Line 1302: BIS_UTILITIES_PVT.Add_Error_Message

1298: );
1299: WHEN OTHERS THEN
1300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1301: l_error_tbl := x_error_tbl;
1302: BIS_UTILITIES_PVT.Add_Error_Message
1303: ( p_error_table => l_error_Tbl
1304: , p_error_msg_id => SQLCODE
1305: , p_error_description => SQLERRM
1306: , x_error_table => x_error_Tbl

Line 1350: BIS_UTILITIES_PVT.Add_Error_Message

1346: EXCEPTION
1347: WHEN FND_API.G_EXC_ERROR THEN
1348: x_return_status := FND_API.G_RET_STS_ERROR;
1349: l_error_tbl := x_error_tbl;
1350: BIS_UTILITIES_PVT.Add_Error_Message
1351: ( p_error_table => l_error_Tbl
1352: , p_error_msg_id => SQLCODE
1353: , p_error_description => SQLERRM
1354: , x_error_table => x_error_Tbl

Line 1363: BIS_UTILITIES_PVT.Add_Error_Message

1359: );
1360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1362: l_error_tbl := x_error_tbl;
1363: BIS_UTILITIES_PVT.Add_Error_Message
1364: ( p_error_table => l_error_Tbl
1365: , p_error_msg_id => SQLCODE
1366: , p_error_description => SQLERRM
1367: , x_error_table => x_error_Tbl

Line 1376: BIS_UTILITIES_PVT.Add_Error_Message

1372: );
1373: WHEN OTHERS THEN
1374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1375: l_error_tbl := x_error_tbl;
1376: BIS_UTILITIES_PVT.Add_Error_Message
1377: ( p_error_table => l_error_Tbl
1378: , p_error_msg_id => SQLCODE
1379: , p_error_description => SQLERRM
1380: , x_error_table => x_error_Tbl

Line 1562: bis_utilities_pvt.get_debug_mode_profile(

1558: BEGIN
1559:
1560: x_return_status := FND_API.G_RET_STS_SUCCESS;
1561: x_return_msg := NULL;
1562: bis_utilities_pvt.get_debug_mode_profile(
1563: x_is_debug_mode => x_is_debug_mode
1564: , x_return_status => x_return_status
1565: , x_return_msg => x_return_msg
1566: );

Line 1593: bis_utilities_pvt.set_debug_log_flag(

1589:
1590: x_return_status := FND_API.G_RET_STS_SUCCESS;
1591: x_return_msg := NULL;
1592:
1593: bis_utilities_pvt.set_debug_log_flag(
1594: p_is_true => p_is_true
1595: , x_return_status => x_return_status
1596: , x_return_msg => x_return_msg );
1597:

Line 1612: RETURN bis_utilities_pvt.is_debug_on();

1608: RETURN BOOLEAN
1609: IS
1610: BEGIN
1611:
1612: RETURN bis_utilities_pvt.is_debug_on();
1613:
1614: EXCEPTION
1615: WHEN OTHERS THEN
1616: RETURN FALSE;

Line 1631: bis_utilities_pvt.open_debug_log ( -- 2694978

1627: BEGIN
1628: x_return_status := FND_API.G_RET_STS_SUCCESS;
1629: x_return_msg := NULL;
1630:
1631: bis_utilities_pvt.open_debug_log ( -- 2694978
1632: p_file_name => p_file_name ,
1633: p_dir_name => p_dir_name,
1634: x_return_status => x_return_status,
1635: x_return_msg => x_return_msg);

Line 1655: bis_utilities_pvt.close_debug_log(

1651: BEGIN
1652: x_return_status := FND_API.G_RET_STS_SUCCESS;
1653: x_return_msg := NULL;
1654:
1655: bis_utilities_pvt.close_debug_log(
1656: p_file_name => p_file_name
1657: , p_dir_name => p_dir_name
1658: , x_return_status => x_return_status
1659: , x_return_msg => x_return_msg);

Line 1672: bis_utilities_pvt.put(p_text => p_text);

1668:
1669: PROCEDURE put(p_text IN VARCHAR2) -- 2694978
1670: IS
1671: BEGIN
1672: bis_utilities_pvt.put(p_text => p_text);
1673: EXCEPTION
1674: WHEN OTHERS THEN
1675: NULL;
1676: END put;

Line 1682: bis_utilities_pvt.put_line(p_text => p_text);

1678:
1679: PROCEDURE put_line(p_text IN VARCHAR2) -- 2694978
1680: IS
1681: BEGIN
1682: bis_utilities_pvt.put_line(p_text => p_text);
1683: EXCEPTION
1684: WHEN OTHERS THEN
1685: NULL;
1686: END put_line;