APPS.INV_MWB_TREE1 dependencies on INV_TRX_UTIL_PUB

Line 6001: inv_trx_util_pub.trace(query_str, 'Add-Status Material Workbench', 9);

5997:
5998: END IF;
5999:
6000: -- Enable this during debugging
6001: inv_trx_util_pub.trace(query_str, 'Add-Status Material Workbench', 9);
6002: --trace1('Add_Statuses - ' || query_str);
6003: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, query_str );
6004:
6005: inv_mwb_globals.g_last_query := query_str;

Line 7335: -- inv_trx_util_pub.trace( query_str, 'Add_subs Material Workbench', 9);

7331:
7332: query_str := query_str || ' ORDER BY subinventory_code ';
7333: END IF;
7334: END IF;
7335: -- inv_trx_util_pub.trace( query_str, 'Add_subs Material Workbench', 9);
7336: --trace1(query_str, 'add_subs', 9);
7337:
7338: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, query_str );
7339:

Line 8586: inv_trx_util_pub.trace(query_str, 'Add Loc :- Material Workbench', 9);

8582: query_str := query_str || 'ORDER BY locator ';
8583: END IF;
8584: END IF;
8585:
8586: inv_trx_util_pub.trace(query_str, 'Add Loc :- Material Workbench', 9);
8587: --trace1(query_str, 'add_locs', 9);
8588: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, query_str );
8589:
8590: inv_mwb_globals.g_last_query := query_str;

Line 9948: inv_trx_util_pub.trace(query_str, 'Add- Cgs Material Workbench', 9);

9944:
9945: END IF;
9946:
9947: -- Enable this during debugging
9948: inv_trx_util_pub.trace(query_str, 'Add- Cgs Material Workbench', 9);
9949: --trace1(query_str, 'add_cgs', 9);
9950:
9951: --RS
9952: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, query_str );

Line 10967: inv_trx_util_pub.trace(query_str, 'Material Workbench :- ADD LPNs', 9);

10963: AND inv_mwb_globals.g_prepacked <> 999 THEN
10964: query_str := query_str || 'AND lpn_context = :prepacked ';
10965: END IF;
10966:
10967: inv_trx_util_pub.trace(query_str, 'Material Workbench :- ADD LPNs', 9);
10968: --trace1('QUERY STR ' || query_str, 'add_lpns', 9);
10969: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, query_str );
10970: inv_mwb_globals.g_last_query := query_str;
10971: query_hdl := DBMS_SQL.open_cursor;

Line 10987: -- inv_trx_util_pub.trace(query_str, 'ADD LPNs Material Workbench :', 9);

10983: END IF;
10984:
10985: IF (is_bind_required = TRUE) THEN
10986: -- Enable this during debugging
10987: -- inv_trx_util_pub.trace(query_str, 'ADD LPNs Material Workbench :', 9);
10988: --trace1(query_str, 'add_lpns', 9);
10989:
10990: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, query_str );
10991: inv_mwb_globals.g_last_query := query_str;

Line 13568: inv_trx_util_pub.trace(query_str, 'Material Workbench - Add Items : ', 9);

13564: END IF;
13565:
13566:
13567: -- Enable this during debugging
13568: inv_trx_util_pub.trace(query_str, 'Material Workbench - Add Items : ', 9);
13569: --trace1(query_str, 'add_items', 9);
13570: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, query_str );
13571: inv_mwb_globals.g_last_query := query_str;
13572: query_hdl := DBMS_SQL.open_cursor;

Line 16759: inv_trx_util_pub.trace(query_str, 'Add_lot :- Material Workbench', 9);

16755: query_str := query_str || 'ORDER BY lot_number ';
16756: END IF;
16757:
16758: -- Enable this during debugging
16759: inv_trx_util_pub.trace(query_str, 'Add_lot :- Material Workbench', 9);
16760: --trace1(query_str, 'add_lots', 9);
16761: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, query_str );
16762: inv_mwb_globals.g_last_query := query_str;
16763: query_hdl := DBMS_SQL.open_cursor;

Line 17811: inv_trx_util_pub.trace(query_str, 'Add Serails :- Material Workbench', 9);

17807: query_str := query_str || 'GROUP BY serial_number ';
17808: query_str := query_str || 'ORDER BY serial_number ';
17809: END IF;
17810:
17811: inv_trx_util_pub.trace(query_str, 'Add Serails :- Material Workbench', 9);
17812: --trace1(query_str, 'add_serials', 9);
17813:
17814: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, query_str );
17815:

Line 18431: inv_trx_util_pub.trace( query_str, 'Add-Grades Material Workbench', 9);

18427: query_str := query_str || ' GROUP BY grade_code ';
18428:
18429: END IF ;
18430:
18431: inv_trx_util_pub.trace( query_str, 'Add-Grades Material Workbench', 9);
18432: -- execute the query and populate the node table
18433: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, query_str );
18434: inv_mwb_globals.g_last_query := query_str;
18435: query_hdl := DBMS_SQL.open_cursor;

Line 18555: --inv_trx_util_pub.trace( 'Material Workbench rows processed ' || rows_processed, 'Material Workbench', 9);

18551:
18552: DBMS_SQL.define_column(query_hdl, 1, grade, 150);
18553: rows_processed := DBMS_SQL.EXECUTE(query_hdl);
18554:
18555: --inv_trx_util_pub.trace( 'Material Workbench rows processed ' || rows_processed, 'Material Workbench', 9);
18556:
18557: LOOP
18558: -- fetch a row
18559: IF DBMS_SQL.fetch_rows(query_hdl) > 0 THEN