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.PO_AUTO_DIST_PROCESS_PVT dependencies on PO_DEBUG

Line 6: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;

2: /* $Header: PO_AUTO_DIST_PROCESS_PVT.plb 120.29.12020000.3 2013/03/25 11:06:43 amalick ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(1000) := 'po_auto_dist_process_pvt';
5: g_log_head CONSTANT VARCHAR2(1000) := 'po.plsql.po_auto_dist_process_pvt.';
6: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
7: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
8:
9: /* ----------------------------------------------------
10: ----------------- PRIVATE PROCEDURES -------------------

Line 7: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;

3:
4: g_pkg_name CONSTANT VARCHAR2(1000) := 'po_auto_dist_process_pvt';
5: g_log_head CONSTANT VARCHAR2(1000) := 'po.plsql.po_auto_dist_process_pvt.';
6: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
7: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
8:
9: /* ----------------------------------------------------
10: ----------------- PRIVATE PROCEDURES -------------------
11: -------------------------Moved 3 Private procedures to public, by moving to spec--------------------------- */

Line 89: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);

85:
86: BEGIN
87:
88: IF g_debug_stmt THEN
89: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
90: END IF;
91:
92: l_progress := '010';
93:

Line 160: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,

156: FROM financials_system_params_all --
157: WHERE NVL(org_id, -99) = NVL(PO_AUTOCREATE_PARAMS.g_purchasing_ou_id, -99);
158:
159: IF g_debug_stmt THEN
160: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
161: p_message => 'Create_distributions: Order type: '||x_order_type_lookup_code);
162: END IF;
163:
164: --added not null check for currency

Line 188: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'NO_DATA_FOUND: '||SQLERRM);

184: EXCEPTION
185: WHEN NO_DATA_FOUND THEN
186: /* Not all req has kanban id */
187: IF g_debug_stmt THEN
188: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'NO_DATA_FOUND: '||SQLERRM);
189: END IF;
190: WHEN OTHERS THEN
191: IF g_debug_unexp THEN
192: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

Line 192: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

188: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'NO_DATA_FOUND: '||SQLERRM);
189: END IF;
190: WHEN OTHERS THEN
191: IF g_debug_unexp THEN
192: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
193: END IF;
194:
195: --CLM Phase 2 changes : error handling
196: PO_AUTOCREATE_PVT.report_error('PO_AUTO_DIST_KANBAN_ERR',

Line 213: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,

209:
210: --Bug13553227
211: l_validate_gl_period := nvl(FND_PROFILE.VALUE('PO_VALIDATE_GL_PERIOD'),'Y');
212: IF g_debug_stmt THEN
213: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
214: p_message => 'l_validate_gl_period: '||l_validate_gl_period);
215: END IF;
216:
217: --The following should be done only if the po encumbrance flag is yes

Line 245: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,

241: END IF;
242:
243:
244: IF g_debug_stmt THEN
245: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
246: p_message => 'PO_AUTOCREATE_PARAMS.g_sys.period_name: '||PO_AUTOCREATE_PARAMS.g_sys.period_name);
247: END IF;
248:
249:

Line 293: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

289:
290: EXCEPTION
291: WHEN OTHERS THEN
292: IF g_debug_unexp THEN
293: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
294: END IF;
295:
296: --CLM Phase 2 changes : error handling
297: PO_AUTOCREATE_PVT.report_error('PO_AUTO_DIST_TYPE_LOOKUP_ERR',

Line 321: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'derive_dists: UOM is: '||x_po_uom);

317: INTO x_po_uom
318: FROM po_lines_all
319: WHERE po_line_id = p_lines.from_line_id_tbl(i);
320: IF g_debug_stmt THEN
321: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'derive_dists: UOM is: '||x_po_uom);
322: END IF;
323:
324: EXCEPTION
325: WHEN OTHERS THEN

Line 327: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

323:
324: EXCEPTION
325: WHEN OTHERS THEN
326: IF g_debug_unexp THEN
327: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
328: END IF;
329: po_message_s.sql_error('CREATE_DISTRIBUTIONS',l_progress,SQLCODE);
330:
331: --CLM Phase 2 changes : error handling

Line 354: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,

350: x_conversion_rate := 1;
351: END IF;
352:
353: IF g_debug_stmt THEN
354: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
355: p_message => 'Create_distributions: Conversion rate is: '||x_conversion_rate);
356: END IF;
357:
358: END IF; -- g_document_subtype

Line 366: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Sourcing to FPH-5 starts');

362: --Dont insert distribution record if the various account_id s are
363: --not defaulted for negotiation lines which are not backed by req for sourcing
364:
365: IF g_debug_stmt THEN
366: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Sourcing to FPH-5 starts');
367: END IF;
368: l_progress := '170';
369: OPEN c_dis_accounts(p_lines.intf_line_id_tbl(i));
370: FETCH c_dis_accounts

Line 425: PO_DEBUG.debug_var(g_log_head||l_api_name, l_progress, 'l_amount_ordered',l_amount_ordered);

421: AND pdi.interface_line_id = p_lines.intf_line_id_tbl(i)
422: AND poll.line_location_id = p_lines.line_loc_id_tbl(i)
423: AND poll.draft_id = po_autocreate_params.g_draft_id;
424:
425: PO_DEBUG.debug_var(g_log_head||l_api_name, l_progress, 'l_amount_ordered',l_amount_ordered);
426: PO_DEBUG.debug_var(g_log_head||l_api_name, l_progress, 'x_order_type_lookup_code',x_order_type_lookup_code);
427: PO_DEBUG.debug_var(g_log_head||l_api_name, l_progress, 'l_currency_conversion_rate',l_currency_conversion_rate);
428: PO_DEBUG.debug_var(g_log_head||l_api_name, l_progress, 'l_uom_conversion_rate',l_uom_conversion_rate);
429: PO_DEBUG.debug_var(g_log_head||l_api_name, l_progress, 'x_precision',x_precision);

Line 426: PO_DEBUG.debug_var(g_log_head||l_api_name, l_progress, 'x_order_type_lookup_code',x_order_type_lookup_code);

422: AND poll.line_location_id = p_lines.line_loc_id_tbl(i)
423: AND poll.draft_id = po_autocreate_params.g_draft_id;
424:
425: PO_DEBUG.debug_var(g_log_head||l_api_name, l_progress, 'l_amount_ordered',l_amount_ordered);
426: PO_DEBUG.debug_var(g_log_head||l_api_name, l_progress, 'x_order_type_lookup_code',x_order_type_lookup_code);
427: PO_DEBUG.debug_var(g_log_head||l_api_name, l_progress, 'l_currency_conversion_rate',l_currency_conversion_rate);
428: PO_DEBUG.debug_var(g_log_head||l_api_name, l_progress, 'l_uom_conversion_rate',l_uom_conversion_rate);
429: PO_DEBUG.debug_var(g_log_head||l_api_name, l_progress, 'x_precision',x_precision);
430: EXCEPTION

Line 427: PO_DEBUG.debug_var(g_log_head||l_api_name, l_progress, 'l_currency_conversion_rate',l_currency_conversion_rate);

423: AND poll.draft_id = po_autocreate_params.g_draft_id;
424:
425: PO_DEBUG.debug_var(g_log_head||l_api_name, l_progress, 'l_amount_ordered',l_amount_ordered);
426: PO_DEBUG.debug_var(g_log_head||l_api_name, l_progress, 'x_order_type_lookup_code',x_order_type_lookup_code);
427: PO_DEBUG.debug_var(g_log_head||l_api_name, l_progress, 'l_currency_conversion_rate',l_currency_conversion_rate);
428: PO_DEBUG.debug_var(g_log_head||l_api_name, l_progress, 'l_uom_conversion_rate',l_uom_conversion_rate);
429: PO_DEBUG.debug_var(g_log_head||l_api_name, l_progress, 'x_precision',x_precision);
430: EXCEPTION
431: WHEN OTHERS THEN

Line 428: PO_DEBUG.debug_var(g_log_head||l_api_name, l_progress, 'l_uom_conversion_rate',l_uom_conversion_rate);

424:
425: PO_DEBUG.debug_var(g_log_head||l_api_name, l_progress, 'l_amount_ordered',l_amount_ordered);
426: PO_DEBUG.debug_var(g_log_head||l_api_name, l_progress, 'x_order_type_lookup_code',x_order_type_lookup_code);
427: PO_DEBUG.debug_var(g_log_head||l_api_name, l_progress, 'l_currency_conversion_rate',l_currency_conversion_rate);
428: PO_DEBUG.debug_var(g_log_head||l_api_name, l_progress, 'l_uom_conversion_rate',l_uom_conversion_rate);
429: PO_DEBUG.debug_var(g_log_head||l_api_name, l_progress, 'x_precision',x_precision);
430: EXCEPTION
431: WHEN OTHERS THEN
432: NULL;

Line 429: PO_DEBUG.debug_var(g_log_head||l_api_name, l_progress, 'x_precision',x_precision);

425: PO_DEBUG.debug_var(g_log_head||l_api_name, l_progress, 'l_amount_ordered',l_amount_ordered);
426: PO_DEBUG.debug_var(g_log_head||l_api_name, l_progress, 'x_order_type_lookup_code',x_order_type_lookup_code);
427: PO_DEBUG.debug_var(g_log_head||l_api_name, l_progress, 'l_currency_conversion_rate',l_currency_conversion_rate);
428: PO_DEBUG.debug_var(g_log_head||l_api_name, l_progress, 'l_uom_conversion_rate',l_uom_conversion_rate);
429: PO_DEBUG.debug_var(g_log_head||l_api_name, l_progress, 'x_precision',x_precision);
430: EXCEPTION
431: WHEN OTHERS THEN
432: NULL;
433: END;

Line 468: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,

464: AND poll.draft_id =po_autocreate_params.g_draft_id
465: AND poll.line_location_id = p_lines.line_loc_id_tbl(i);
466:
467: IF g_debug_stmt THEN
468: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
469: p_message => 'Create_distributions: l_drop_ship_flag : '||l_drop_ship_flag
470: ||' l_amount_ordered : '||l_amount_ordered
471: ||' x_req_currency_code : '||x_req_currency_code
472: ||' x_req_rate : '||x_req_rate

Line 791: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);

787:
788:
789:
790: IF g_debug_stmt THEN
791: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
792: END IF;
793:
794: EXCEPTION
795: WHEN OTHERS THEN

Line 797: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

793:
794: EXCEPTION
795: WHEN OTHERS THEN
796: IF g_debug_unexp THEN
797: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
798: END IF;
799:
800: --CLM Phase 2 changes : error handling
801: PO_AUTOCREATE_PVT.report_error('PO_AUTO_DIST_DEFAULT_ERR',x_token1_value => sqlerrm);

Line 912: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);

908:
909: BEGIN
910:
911: IF g_debug_stmt THEN
912: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
913: END IF;
914:
915: FOR i IN 1..p_lines.intf_line_id_tbl.Count
916: LOOP

Line 1711: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);

1707: END IF;
1708: END LOOP;
1709:
1710: IF g_debug_stmt THEN
1711: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
1712: END IF;
1713:
1714: EXCEPTION
1715: WHEN OTHERS THEN

Line 1783: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);

1779:
1780: BEGIN
1781:
1782: IF g_debug_stmt THEN
1783: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
1784: END IF;
1785:
1786: --assign value to local variable.
1787: l_intf_header_id := p_intf_header_id;

Line 1881: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);

1877: WHERE po_distribution_id = l_gms_po_interface_obj.distribution_id(i);
1878: END IF; -- if p_table_type = 'ALL'
1879: --
1880: IF g_debug_stmt THEN
1881: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
1882: END IF;
1883:
1884: EXCEPTION
1885: WHEN FND_API.G_EXC_ERROR THEN

Line 1893: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'EXCEPTION: '|| l_msg_buf);

1889: IF g_debug_stmt THEN
1890: FOR i IN 1..FND_MSG_PUB.count_msg
1891: LOOP
1892: l_msg_buf := SUBSTRB(FND_MSG_PUB.get(p_msg_index => i, p_encoded => FND_API.G_FALSE), 1, 2000);
1893: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'EXCEPTION: '|| l_msg_buf);
1894: END LOOP;
1895: END IF;
1896: --CLM Phase 2 changes : error handling
1897: PO_AUTOCREATE_PVT.report_error('PO_AUTO_DIST_GMS_INTG_ERR',x_token1_value => sqlerrm);

Line 1902: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

1898:
1899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1900: WHEN OTHERS THEN
1901: IF g_debug_unexp THEN
1902: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
1903: END IF;
1904: IF FND_MSG_PUB.check_msg_level( p_message_level => FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1905: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_PKG_NAME, p_procedure_name => l_api_name);
1906: END IF;

Line 1954: PO_DEBUG.debug_begin(l_log_head);

1950:
1951: BEGIN
1952:
1953: l_progress:='000';
1954: PO_DEBUG.debug_begin(l_log_head);
1955:
1956: l_progress:='010';
1957: PO_DEBUG.debug_var(l_log_head,l_progress,'p_line_location_id',p_line_location_id);
1958: -- Retrieve Distribution Data =============================================

Line 1957: PO_DEBUG.debug_var(l_log_head,l_progress,'p_line_location_id',p_line_location_id);

1953: l_progress:='000';
1954: PO_DEBUG.debug_begin(l_log_head);
1955:
1956: l_progress:='010';
1957: PO_DEBUG.debug_var(l_log_head,l_progress,'p_line_location_id',p_line_location_id);
1958: -- Retrieve Distribution Data =============================================
1959: --
1960: -- Get the sum of all distribution amounts
1961: -- and the ID of the last distribution.

Line 1972: PO_DEBUG.debug_var(l_log_head,l_progress,'l_sum_dist_amounts',l_sum_dist_amounts);

1968: WHERE line_location_id = p_line_location_id
1969: AND draft_id =po_autocreate_params.g_draft_id;
1970:
1971: l_progress:='020';
1972: PO_DEBUG.debug_var(l_log_head,l_progress,'l_sum_dist_amounts',l_sum_dist_amounts);
1973: l_progress:='030';
1974: PO_DEBUG.debug_var(l_log_head,l_progress,'l_last_distribution_id',l_last_distribution_id);
1975: -- Get the shipment amount ================================================
1976: --

Line 1974: PO_DEBUG.debug_var(l_log_head,l_progress,'l_last_distribution_id',l_last_distribution_id);

1970:
1971: l_progress:='020';
1972: PO_DEBUG.debug_var(l_log_head,l_progress,'l_sum_dist_amounts',l_sum_dist_amounts);
1973: l_progress:='030';
1974: PO_DEBUG.debug_var(l_log_head,l_progress,'l_last_distribution_id',l_last_distribution_id);
1975: -- Get the shipment amount ================================================
1976: --
1977: SELECT amount
1978: INTO l_shipment_amount

Line 1983: PO_DEBUG.debug_var(l_log_head,l_progress,'l_shipment_amount',l_shipment_amount);

1979: FROM po_line_locations_draft_all
1980: WHERE line_location_id = p_line_location_id;
1981:
1982: l_progress:='040';
1983: PO_DEBUG.debug_var(l_log_head,l_progress,'l_shipment_amount',l_shipment_amount);
1984: -- Correct the last distribution ==========================================
1985: --
1986: -- Set it to the shipment amount minus the sum of all distribution
1987: -- amounts (except the last distribution).

Line 1996: PO_DEBUG.debug_var(l_log_head,l_progress,'l_last_dist_amount',l_last_dist_amount);

1992: AND draft_id =po_autocreate_params.g_draft_id RETURNING amount_ordered
1993: INTO l_last_dist_amount;
1994:
1995: l_progress:='050';
1996: PO_DEBUG.debug_var(l_log_head,l_progress,'l_last_dist_amount',l_last_dist_amount);
1997: --=========================================================================
1998: l_progress:='060';
1999: PO_DEBUG.debug_end(l_log_head);
2000: EXCEPTION

Line 1999: PO_DEBUG.debug_end(l_log_head);

1995: l_progress:='050';
1996: PO_DEBUG.debug_var(l_log_head,l_progress,'l_last_dist_amount',l_last_dist_amount);
1997: --=========================================================================
1998: l_progress:='060';
1999: PO_DEBUG.debug_end(l_log_head);
2000: EXCEPTION
2001: WHEN OTHERS THEN
2002: PO_DEBUG.debug_exc ( p_log_head => l_log_head , p_progress => l_progress);
2003:

Line 2002: PO_DEBUG.debug_exc ( p_log_head => l_log_head , p_progress => l_progress);

1998: l_progress:='060';
1999: PO_DEBUG.debug_end(l_log_head);
2000: EXCEPTION
2001: WHEN OTHERS THEN
2002: PO_DEBUG.debug_exc ( p_log_head => l_log_head , p_progress => l_progress);
2003:
2004: --CLM Phase 2 changes : error handling
2005: PO_AUTOCREATE_PVT.report_error('PO_AUTO_DIST_CAL_AMT',x_token1_value => sqlerrm);
2006: