DBA Data[Home] [Help]

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(2000);
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 475: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

471: RETURN(g_unit_selling_price_tbl(l_line_index));
472: END get_transfer_price;
473:
474: 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
475: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
476: BEGIN
477: x_return_status := fnd_api.g_ret_sts_success;
478:
479: -- Header population

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

792: , p_request_type_code IN VARCHAR2 DEFAULT 'IC'
793: -- OPM INVCONV umoogala Added above parameter
794: , x_return_status OUT NOCOPY VARCHAR2
795: ) IS
796: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
797: BEGIN
798: x_return_status := fnd_api.g_ret_sts_success;
799: inv_ic_order_pub.g_line.accounting_rule_id := fnd_api.g_miss_num;
800: inv_ic_order_pub.g_line.actual_arrival_date := fnd_api.g_miss_date;

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

1828: p_header_rec inv_ic_order_pub.header_rec_type
1829: , p_request_type_code VARCHAR2
1830: , px_line_index IN OUT NOCOPY NUMBER
1831: ) IS
1832: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1833: BEGIN
1834: px_line_index := px_line_index + 1;
1835: g_request_type_code_tbl(px_line_index) := p_request_type_code;
1836: g_price_request_code_tbl(px_line_index) := p_request_type_code;

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

1882: , p_request_type_code VARCHAR2
1883: , px_line_index IN OUT NOCOPY NUMBER
1884: ) IS
1885: l_uom_rate NUMBER;
1886: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1887: BEGIN
1888: px_line_index := px_line_index + 1;
1889: g_request_type_code_tbl(px_line_index) := p_request_type_code;
1890: g_price_request_code_tbl(px_line_index) := p_request_type_code;

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

1954: PROCEDURE populate_temp_table(x_return_status OUT NOCOPY VARCHAR2) IS
1955: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1956: l_return_status_text VARCHAR2(2000);
1957: i NUMBER := 0;
1958: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1959: BEGIN
1960: x_return_status := fnd_api.g_ret_sts_success;
1961:
1962: FOR i IN g_line_index_tbl.FIRST .. g_line_index_tbl.LAST LOOP

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

2072: END populate_temp_table;
2073:
2074: PROCEDURE populate_results(p_line_index NUMBER, x_return_status OUT NOCOPY VARCHAR2) IS
2075: i NUMBER := 0;
2076: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2077: BEGIN
2078: x_return_status := fnd_api.g_ret_sts_success;
2079:
2080: FOR i IN g_line_index_tbl.FIRST .. g_line_index_tbl.LAST LOOP

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

2218: RAISE fnd_api.g_exc_unexpected_error;
2219: END populate_results;
2220:
2221: PROCEDURE print_debug(p_message IN VARCHAR2) IS
2222: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2223: BEGIN
2224: -- dbms_output.put_line(p_message);
2225: IF (l_debug = 1) THEN
2226: inv_log_util.TRACE(p_message, 'INV_INTERCOMPANY_INVOICING', 4);

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

2232: p_header_rec inv_ic_order_pub.proc_header_rec_type
2233: , p_request_type_code VARCHAR2
2234: , px_line_index IN OUT NOCOPY NUMBER
2235: ) IS
2236: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2237: BEGIN
2238: print_debug('Start Copy_Proc_Header_To_Request');
2239: print_debug('p_request_type_code = ' || p_request_type_code);
2240: print_debug('px_line_index = ' || px_line_index);

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

2282: , p_request_type_code VARCHAR2
2283: , px_line_index IN OUT NOCOPY NUMBER
2284: ) IS
2285: l_uom_rate NUMBER;
2286: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2287: BEGIN
2288: print_debug('START Copy_Proc_Line_to_Request');
2289: print_debug('p_pricing_events = ' || p_pricing_events);
2290: print_debug('p_requst_type_code = ' || p_request_type_code);

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

2384: l_tfrprice NUMBER;
2385: l_uom_rate NUMBER;
2386: l_doc_type VARCHAR2(4); /* OPM Bug 2865040 */
2387: l_progress NUMBER;
2388: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2389: BEGIN
2390: x_return_status := fnd_api.g_ret_sts_success;
2391: x_currency_code := ' ';
2392: x_tfrpricecode := 1;

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

2595: , p_incr_code IN NUMBER
2596: , p_incrcurrency IN VARCHAR2
2597: , x_return_status OUT NOCOPY VARCHAR2
2598: ) IS
2599: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2600: BEGIN
2601: x_return_status := fnd_api.g_ret_sts_success;
2602:
2603: -- Header population

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

2877: , p_inventory_item_id IN NUMBER
2878: , p_cto_item_flag IN VARCHAR2
2879: , x_return_status OUT NOCOPY VARCHAR2
2880: ) IS
2881: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2882: l_primary_uom VARCHAR2(3);
2883: BEGIN
2884: x_return_status := fnd_api.g_ret_sts_success;
2885: