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

Line 98: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

94: l_dir VARCHAR2(4000); /* bug11876955 change l_dir definition from varchar2(2000) to varchar2(4000) */
95: l_tfrprice NUMBER;
96: l_uom_rate NUMBER;
97: l_doc_type VARCHAR2(4); /* OPM Bug 2865040 */
98: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
99: l_order_line_id NUMBER;
100: l_base_item_id NUMBER;
101: l_transaction_source_type_id NUMBER;
102: l_transaction_action_id NUMBER;

Line 104: IF fnd_profile.VALUE('INV_DEBUG_TRACE') = 1 THEN

100: l_base_item_id NUMBER;
101: l_transaction_source_type_id NUMBER;
102: l_transaction_action_id NUMBER;
103: BEGIN
104: IF fnd_profile.VALUE('INV_DEBUG_TRACE') = 1 THEN
105: IF (l_debug = 1) THEN
106: print_debug('Enabling QP debug option...');
107: END IF;
108:

Line 517: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

513: RETURN(g_unit_selling_price_tbl(l_line_index));
514: END get_transfer_price;
515:
516: PROCEDURE g_hdr_initialize(p_header_id IN NUMBER, p_incr_code IN NUMBER, p_incrcurrency IN VARCHAR2, x_return_status OUT NOCOPY VARCHAR2) IS
517: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
518: BEGIN
519: x_return_status := fnd_api.g_ret_sts_success;
520:
521: -- Header population

Line 838: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

834: , p_request_type_code IN VARCHAR2 DEFAULT 'IC'
835: -- OPM INVCONV umoogala Added above parameter
836: , x_return_status OUT NOCOPY VARCHAR2
837: ) IS
838: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
839: BEGIN
840: x_return_status := fnd_api.g_ret_sts_success;
841: inv_ic_order_pub.g_line.accounting_rule_id := fnd_api.g_miss_num;
842: inv_ic_order_pub.g_line.actual_arrival_date := fnd_api.g_miss_date;

Line 1874: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

1870: p_header_rec inv_ic_order_pub.header_rec_type
1871: , p_request_type_code VARCHAR2
1872: , px_line_index IN OUT NOCOPY NUMBER
1873: ) IS
1874: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1875: BEGIN
1876: px_line_index := px_line_index + 1;
1877: g_request_type_code_tbl(px_line_index) := p_request_type_code;
1878: g_price_request_code_tbl(px_line_index) := p_request_type_code;

Line 1928: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

1924: , p_request_type_code VARCHAR2
1925: , px_line_index IN OUT NOCOPY NUMBER
1926: ) IS
1927: l_uom_rate NUMBER;
1928: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1929: --bug 6700919
1930: l_return_Status VARCHAR2(1);
1931: l_msg_data VARCHAR2(255);
1932: l_msg_count NUMBER;

Line 2025: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

2021: PROCEDURE populate_temp_table(x_return_status OUT NOCOPY VARCHAR2) IS
2022: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
2023: l_return_status_text VARCHAR2(2000);
2024: i NUMBER := 0;
2025: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2026: BEGIN
2027: x_return_status := fnd_api.g_ret_sts_success;
2028:
2029: FOR i IN g_line_index_tbl.FIRST .. g_line_index_tbl.LAST LOOP

Line 2143: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

2139: END populate_temp_table;
2140:
2141: PROCEDURE populate_results(p_line_index NUMBER, x_return_status OUT NOCOPY VARCHAR2) IS
2142: i NUMBER := 0;
2143: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2144: BEGIN
2145: x_return_status := fnd_api.g_ret_sts_success;
2146:
2147: FOR i IN g_line_index_tbl.FIRST .. g_line_index_tbl.LAST LOOP

Line 2289: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

2285: RAISE fnd_api.g_exc_unexpected_error;
2286: END populate_results;
2287:
2288: PROCEDURE print_debug(p_message IN VARCHAR2) IS
2289: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2290: BEGIN
2291: -- dbms_output.put_line(p_message);
2292: IF (l_debug = 1) THEN
2293: inv_log_util.TRACE(p_message, 'INV_INTERCOMPANY_INVOICING', 4);

Line 2303: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

2299: p_header_rec inv_ic_order_pub.proc_header_rec_type
2300: , p_request_type_code VARCHAR2
2301: , px_line_index IN OUT NOCOPY NUMBER
2302: ) IS
2303: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2304: BEGIN
2305: print_debug('Start Copy_Proc_Header_To_Request');
2306: print_debug('p_request_type_code = ' || p_request_type_code);
2307: print_debug('px_line_index = ' || px_line_index);

Line 2353: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

2349: , p_request_type_code VARCHAR2
2350: , px_line_index IN OUT NOCOPY NUMBER
2351: ) IS
2352: l_uom_rate NUMBER;
2353: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2354: --bug 6700919
2355: l_return_Status VARCHAR2(1);
2356: l_msg_data VARCHAR2(255);
2357: l_msg_count NUMBER;

Line 2480: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

2476: l_tfrprice NUMBER;
2477: l_uom_rate NUMBER;
2478: l_doc_type VARCHAR2(4); /* OPM Bug 2865040 */
2479: l_progress NUMBER;
2480: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2481: BEGIN
2482: x_return_status := fnd_api.g_ret_sts_success;
2483: x_currency_code := ' ';
2484: x_tfrpricecode := 1;

Line 2700: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

2696: , p_incr_code IN NUMBER
2697: , p_incrcurrency IN VARCHAR2
2698: , x_return_status OUT NOCOPY VARCHAR2
2699: ) IS
2700: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2701: BEGIN
2702: x_return_status := fnd_api.g_ret_sts_success;
2703:
2704: -- Header population

Line 2982: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

2978: , p_inventory_item_id IN NUMBER
2979: , p_cto_item_flag IN VARCHAR2
2980: , x_return_status OUT NOCOPY VARCHAR2
2981: ) IS
2982: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2983: l_primary_uom VARCHAR2(3);
2984: BEGIN
2985: x_return_status := fnd_api.g_ret_sts_success;
2986: