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.OPI_DBI_INV_VALUE_INCR_PKG dependencies on FND_PROFILE

Line 130: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

126: l_debug_mode VARCHAR2(1);
127: l_module_name VARCHAR2(30);
128: BEGIN
129: l_proc_name := 'CLEAN_STAGING_TABLE';
130: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
131: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
132:
133: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
134: l_debug_msg := 'Start of cleaning staging table';

Line 131: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

127: l_module_name VARCHAR2(30);
128: BEGIN
129: l_proc_name := 'CLEAN_STAGING_TABLE';
130: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
131: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
132:
133: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
134: l_debug_msg := 'Start of cleaning staging table';
135: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );

Line 199: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

195: l_debug_mode VARCHAR2(1);
196: l_module_name VARCHAR2(30);
197: BEGIN
198: l_proc_name := 'GET_ONHAND_ACTIVITY';
199: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
200: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
201:
202: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
203: l_debug_msg := 'Start of GET_ONHAND_ACTIVITY';

Line 200: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

196: l_module_name VARCHAR2(30);
197: BEGIN
198: l_proc_name := 'GET_ONHAND_ACTIVITY';
199: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
200: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
201:
202: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
203: l_debug_msg := 'Start of GET_ONHAND_ACTIVITY';
204: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );

Line 462: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

458: from_mta_id NUMBER;
459: to_mta_id NUMBER;
460: BEGIN
461: l_proc_name := 'GET_INTRANSIT_ACTIVITY';
462: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
463: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
464:
465: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
466: l_debug_msg := 'Start of GET_INTRANSIT_ACTIVITY';

Line 463: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

459: to_mta_id NUMBER;
460: BEGIN
461: l_proc_name := 'GET_INTRANSIT_ACTIVITY';
462: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
463: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
464:
465: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
466: l_debug_msg := 'Start of GET_INTRANSIT_ACTIVITY';
467: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );

Line 911: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

907: l_debug_mode VARCHAR2(1);
908: l_module_name VARCHAR2(30);
909: BEGIN
910: l_proc_name := 'GET_WIP_ACTIVITY';
911: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
912: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
913:
914: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
915: l_debug_msg := 'Start of GET_WIP_ACTIVITY';

Line 912: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

908: l_module_name VARCHAR2(30);
909: BEGIN
910: l_proc_name := 'GET_WIP_ACTIVITY';
911: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
912: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
913:
914: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
915: l_debug_msg := 'Start of GET_WIP_ACTIVITY';
916: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );

Line 1160: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

1156: l_debug_mode VARCHAR2(1);
1157: l_module_name VARCHAR2(30);
1158: BEGIN
1159: l_proc_name := 'GET_NET_ACTIVITY';
1160: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1161: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
1162:
1163: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
1164: l_debug_msg := 'Start of GET_NET_ACTIVITY';

Line 1161: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

1157: l_module_name VARCHAR2(30);
1158: BEGIN
1159: l_proc_name := 'GET_NET_ACTIVITY';
1160: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1161: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
1162:
1163: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
1164: l_debug_msg := 'Start of GET_NET_ACTIVITY';
1165: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );

Line 1215: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

1211: l_debug_mode VARCHAR2(1);
1212: l_module_name VARCHAR2(30);
1213: BEGIN
1214: l_proc_name := 'MERGE_INTO_SUMMARY';
1215: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1216: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
1217:
1218: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
1219: l_debug_msg := 'Start of MERGE_INTO_SUMMARY';

Line 1216: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

1212: l_module_name VARCHAR2(30);
1213: BEGIN
1214: l_proc_name := 'MERGE_INTO_SUMMARY';
1215: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1216: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
1217:
1218: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
1219: l_debug_msg := 'Start of MERGE_INTO_SUMMARY';
1220: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );

Line 1456: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

1452: errbuf VARCHAR2(30);
1453: retcode VARCHAR2(30);
1454: BEGIN
1455: l_proc_name := 'DISCRETE_REFRESH';
1456: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1457: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
1458:
1459: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
1460: l_debug_msg := 'Start of Discrete_Refresh';

Line 1457: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

1453: retcode VARCHAR2(30);
1454: BEGIN
1455: l_proc_name := 'DISCRETE_REFRESH';
1456: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1457: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
1458:
1459: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
1460: l_debug_msg := 'Start of Discrete_Refresh';
1461: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );

Line 1565: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

1561: l_uncost_trx BOOLEAN;
1562:
1563: BEGIN
1564: l_proc_name := 'REFRESH';
1565: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1566: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
1567:
1568:
1569: l_debug_msg := 'Start of Incremental Load for Inventory ';

Line 1566: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

1562:
1563: BEGIN
1564: l_proc_name := 'REFRESH';
1565: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1566: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
1567:
1568:
1569: l_debug_msg := 'Start of Incremental Load for Inventory ';
1570: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );