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_INIT_PKG dependencies on FND_PROFILE

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

216: l_debug_mode VARCHAR2(1);
217: l_module_name VARCHAR2(30);
218: BEGIN
219: l_proc_name := 'clean_staging_tables';
220: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
221: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
222:
223: l_stmt_num := 0;
224: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then

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

217: l_module_name VARCHAR2(30);
218: BEGIN
219: l_proc_name := 'clean_staging_tables';
220: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
221: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
222:
223: l_stmt_num := 0;
224: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
225: l_debug_msg := 'Start of cleaning staging table';

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

366: l_module_name VARCHAR2(30);
367:
368: BEGIN
369: l_proc_name := 'COST_DISCRETE_INCEPTION_QTY';
370: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
371: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
372:
373: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
374: l_debug_msg := 'Entered Into COST_DISCRETE_INCEPTION_QTY ';

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

367:
368: BEGIN
369: l_proc_name := 'COST_DISCRETE_INCEPTION_QTY';
370: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
371: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
372:
373: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
374: l_debug_msg := 'Entered Into COST_DISCRETE_INCEPTION_QTY ';
375: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );

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

687: l_module_name VARCHAR2(30);
688:
689: BEGIN
690: l_proc_name := 'GET_OPM_ITEM_COST';
691: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
692: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
693: x_no_cost := NULL;
694:
695: l_ret_value := GMF_CMCOMMON.Get_Process_Item_Cost

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

688:
689: BEGIN
690: l_proc_name := 'GET_OPM_ITEM_COST';
691: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
692: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
693: x_no_cost := NULL;
694:
695: l_ret_value := GMF_CMCOMMON.Get_Process_Item_Cost
696: (

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

751:
752: BEGIN
753:
754: l_proc_name := 'COST_OPM_INCEPTION_QTY';
755: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
756: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
757: l_row_count := 0;
758:
759: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then

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

752: BEGIN
753:
754: l_proc_name := 'COST_OPM_INCEPTION_QTY';
755: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
756: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
757: l_row_count := 0;
758:
759: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
760: l_debug_msg := 'Entered Into COST_OPM_INCEPTION_QTY ';

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

826:
827: BEGIN
828:
829: l_proc_name := 'GET_ONHAND_BALANCE';
830: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
831: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
832:
833: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
834: l_debug_msg := 'Entered Into GET_ONHAND_BALANCE ';

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

827: BEGIN
828:
829: l_proc_name := 'GET_ONHAND_BALANCE';
830: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
831: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
832:
833: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
834: l_debug_msg := 'Entered Into GET_ONHAND_BALANCE ';
835: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );

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

926: l_debug_mode VARCHAR2(1);
927: l_module_name Varchar2 (30);
928: BEGIN
929: l_proc_name := 'GET_INTRANSIT_INITIAL_LOAD';
930: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
931: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
932:
933: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
934: l_debug_msg := 'Entered into INTRANSIT_SETUP ';

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

927: l_module_name Varchar2 (30);
928: BEGIN
929: l_proc_name := 'GET_INTRANSIT_INITIAL_LOAD';
930: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
931: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
932:
933: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
934: l_debug_msg := 'Entered into INTRANSIT_SETUP ';
935: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );

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

1172: l_module_name VARCHAR2 (30);
1173: BEGIN
1174:
1175: l_proc_name := 'GET_INTRANSIT_BALANCE';
1176: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1177: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
1178:
1179: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
1180: l_debug_msg := 'Entered Into GET_INTRANSIT_BALANCE';

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

1173: BEGIN
1174:
1175: l_proc_name := 'GET_INTRANSIT_BALANCE';
1176: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1177: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
1178:
1179: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
1180: l_debug_msg := 'Entered Into GET_INTRANSIT_BALANCE';
1181: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );

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

1340: l_debug_mode VARCHAR2(1);
1341: l_module_name VARCHAR2(30);
1342: BEGIN
1343: l_proc_name := 'GET_WIP_BALANCE';
1344: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1345: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
1346:
1347: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
1348: l_debug_msg := 'Entered Into GET_WIP_BALANCE ';

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

1341: l_module_name VARCHAR2(30);
1342: BEGIN
1343: l_proc_name := 'GET_WIP_BALANCE';
1344: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1345: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
1346:
1347: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
1348: l_debug_msg := 'Entered Into GET_WIP_BALANCE ';
1349: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );

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

1432: l_module_name VARCHAR2 (30);
1433: BEGIN
1434:
1435: l_proc_name := 'GET_INCEPTION_INV_BALANCE';
1436: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1437: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
1438:
1439: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
1440: l_debug_msg := 'Entered Into GET_INCEPTION_INV_BALANCE';

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

1433: BEGIN
1434:
1435: l_proc_name := 'GET_INCEPTION_INV_BALANCE';
1436: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1437: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
1438:
1439: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
1440: l_debug_msg := 'Entered Into GET_INCEPTION_INV_BALANCE';
1441: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );

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

1512: l_debug_mode VARCHAR2(1);
1513: l_module_name VARCHAR2 (30);
1514: BEGIN
1515: l_proc_name := 'GET_INTRANSIT_INITIAL_LOAD';
1516: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1517: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
1518:
1519: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
1520: l_debug_msg := 'Entered Into GET_INTRANSIT_INITIAL_LOAD ';

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

1513: l_module_name VARCHAR2 (30);
1514: BEGIN
1515: l_proc_name := 'GET_INTRANSIT_INITIAL_LOAD';
1516: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1517: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
1518:
1519: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
1520: l_debug_msg := 'Entered Into GET_INTRANSIT_INITIAL_LOAD ';
1521: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );

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

1911: l_module_name VARCHAR2 (30);
1912: BEGIN
1913:
1914: l_proc_name := 'EXTRACT_INVENTORY_TXN_QTY';
1915: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1916: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
1917:
1918: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
1919: l_debug_msg := 'Entered Into EXTRACT_INVENTORY_TXN_QTY ';

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

1912: BEGIN
1913:
1914: l_proc_name := 'EXTRACT_INVENTORY_TXN_QTY';
1915: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1916: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
1917:
1918: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
1919: l_debug_msg := 'Entered Into EXTRACT_INVENTORY_TXN_QTY ';
1920: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );

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

2093: l_module_name VARCHAR2 (30);
2094: BEGIN
2095:
2096: l_proc_name := 'EXTRACT_INVENTORY_TXN_VALUE';
2097: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
2098: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
2099:
2100: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
2101: l_debug_msg := 'Enter Into EXTRACT_INVENTORY_TXN_VALUE ';

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

2094: BEGIN
2095:
2096: l_proc_name := 'EXTRACT_INVENTORY_TXN_VALUE';
2097: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
2098: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
2099:
2100: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
2101: l_debug_msg := 'Enter Into EXTRACT_INVENTORY_TXN_VALUE ';
2102: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );

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

2442: l_module_name VARCHAR2 (30);
2443: BEGIN
2444:
2445: l_proc_name := 'MERGE_INITIAL_LOAD';
2446: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
2447: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
2448:
2449: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
2450: l_debug_msg := 'Entered Into MERGE_INITIAL_LOAD';

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

2443: BEGIN
2444:
2445: l_proc_name := 'MERGE_INITIAL_LOAD';
2446: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
2447: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
2448:
2449: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
2450: l_debug_msg := 'Entered Into MERGE_INITIAL_LOAD';
2451: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );

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

2689:
2690: BEGIN
2691:
2692: l_proc_name := 'RUN_DISCRETE_FIRST_ETL';
2693: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
2694: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
2695:
2696: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
2697: l_debug_msg := 'Entered Into RUN_DISCRETE_FIRST_ETL';

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

2690: BEGIN
2691:
2692: l_proc_name := 'RUN_DISCRETE_FIRST_ETL';
2693: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
2694: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
2695:
2696: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
2697: l_debug_msg := 'Entered Into RUN_DISCRETE_FIRST_ETL';
2698: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );

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

2788: --declared for bug 3429014
2789:
2790: BEGIN
2791: l_proc_name := 'SEED_INV_TYPE_CODES';
2792: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
2793: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
2794:
2795: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
2796: l_debug_msg := 'Entered Into SEED_INV_TYPE_CODES';

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

2789:
2790: BEGIN
2791: l_proc_name := 'SEED_INV_TYPE_CODES';
2792: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
2793: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
2794:
2795: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
2796: l_debug_msg := 'Entered Into SEED_INV_TYPE_CODES';
2797: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );

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

2852:
2853: BEGIN
2854:
2855: l_proc_name := 'RUN_FIRST_ETL';
2856: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
2857: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
2858:
2859: l_stmt_num := 10;
2860: l_debug_msg := 'Starting Initial Load for Inventory Management page';

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

2853: BEGIN
2854:
2855: l_proc_name := 'RUN_FIRST_ETL';
2856: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
2857: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
2858:
2859: l_stmt_num := 10;
2860: l_debug_msg := 'Starting Initial Load for Inventory Management page';
2861: bis_collection_utilities.put_line(l_debug_msg );