DBA Data[Home] [Help]

APPS.PO_CORE_S2 dependencies on PO_DEBUG

Line 12: g_debug_stmt BOOLEAN := PO_DEBUG.is_debug_stmt_on;

8: -- Logging/debugging
9: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_CORE_S2';
10: g_log_head CONSTANT VARCHAR2(50) :=
11: 'po.plsql.' || g_pkg_name || '.';
12: g_debug_stmt BOOLEAN := PO_DEBUG.is_debug_stmt_on;
13: g_debug_unexp BOOLEAN := PO_DEBUG.is_debug_unexp_on;
14:
15:
16:

Line 13: g_debug_unexp BOOLEAN := PO_DEBUG.is_debug_unexp_on;

9: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_CORE_S2';
10: g_log_head CONSTANT VARCHAR2(50) :=
11: 'po.plsql.' || g_pkg_name || '.';
12: g_debug_stmt BOOLEAN := PO_DEBUG.is_debug_stmt_on;
13: g_debug_unexp BOOLEAN := PO_DEBUG.is_debug_unexp_on;
14:
15:
16:
17:

Line 275: PO_DEBUG.debug_begin(l_log_head);

271:
272: BEGIN
273:
274: IF g_debug_stmt THEN
275: PO_DEBUG.debug_begin(l_log_head);
276: PO_DEBUG.debug_var(l_log_head,l_progress,'p_unique_id_tbl'
277: ,p_unique_id_tbl);
278: PO_DEBUG.debug_var(l_log_head,l_progress,'p_amount_in_tbl'
279: ,p_amount_in_tbl);

Line 276: PO_DEBUG.debug_var(l_log_head,l_progress,'p_unique_id_tbl'

272: BEGIN
273:
274: IF g_debug_stmt THEN
275: PO_DEBUG.debug_begin(l_log_head);
276: PO_DEBUG.debug_var(l_log_head,l_progress,'p_unique_id_tbl'
277: ,p_unique_id_tbl);
278: PO_DEBUG.debug_var(l_log_head,l_progress,'p_amount_in_tbl'
279: ,p_amount_in_tbl);
280: PO_DEBUG.debug_var(l_log_head,l_progress,'p_exchange_rate_tbl'

Line 278: PO_DEBUG.debug_var(l_log_head,l_progress,'p_amount_in_tbl'

274: IF g_debug_stmt THEN
275: PO_DEBUG.debug_begin(l_log_head);
276: PO_DEBUG.debug_var(l_log_head,l_progress,'p_unique_id_tbl'
277: ,p_unique_id_tbl);
278: PO_DEBUG.debug_var(l_log_head,l_progress,'p_amount_in_tbl'
279: ,p_amount_in_tbl);
280: PO_DEBUG.debug_var(l_log_head,l_progress,'p_exchange_rate_tbl'
281: ,p_exchange_rate_tbl);
282: PO_DEBUG.debug_var(l_log_head,l_progress,'p_from_currency_precision_tbl'

Line 280: PO_DEBUG.debug_var(l_log_head,l_progress,'p_exchange_rate_tbl'

276: PO_DEBUG.debug_var(l_log_head,l_progress,'p_unique_id_tbl'
277: ,p_unique_id_tbl);
278: PO_DEBUG.debug_var(l_log_head,l_progress,'p_amount_in_tbl'
279: ,p_amount_in_tbl);
280: PO_DEBUG.debug_var(l_log_head,l_progress,'p_exchange_rate_tbl'
281: ,p_exchange_rate_tbl);
282: PO_DEBUG.debug_var(l_log_head,l_progress,'p_from_currency_precision_tbl'
283: ,p_from_currency_precision_tbl);
284: PO_DEBUG.debug_var(l_log_head,l_progress,'p_from_currency_mau_tbl'

Line 282: PO_DEBUG.debug_var(l_log_head,l_progress,'p_from_currency_precision_tbl'

278: PO_DEBUG.debug_var(l_log_head,l_progress,'p_amount_in_tbl'
279: ,p_amount_in_tbl);
280: PO_DEBUG.debug_var(l_log_head,l_progress,'p_exchange_rate_tbl'
281: ,p_exchange_rate_tbl);
282: PO_DEBUG.debug_var(l_log_head,l_progress,'p_from_currency_precision_tbl'
283: ,p_from_currency_precision_tbl);
284: PO_DEBUG.debug_var(l_log_head,l_progress,'p_from_currency_mau_tbl'
285: ,p_from_currency_mau_tbl);
286: PO_DEBUG.debug_var(l_log_head,l_progress,'p_to_currency_precision_tbl'

Line 284: PO_DEBUG.debug_var(l_log_head,l_progress,'p_from_currency_mau_tbl'

280: PO_DEBUG.debug_var(l_log_head,l_progress,'p_exchange_rate_tbl'
281: ,p_exchange_rate_tbl);
282: PO_DEBUG.debug_var(l_log_head,l_progress,'p_from_currency_precision_tbl'
283: ,p_from_currency_precision_tbl);
284: PO_DEBUG.debug_var(l_log_head,l_progress,'p_from_currency_mau_tbl'
285: ,p_from_currency_mau_tbl);
286: PO_DEBUG.debug_var(l_log_head,l_progress,'p_to_currency_precision_tbl'
287: ,p_to_currency_precision_tbl);
288: PO_DEBUG.debug_var(l_log_head,l_progress,'p_to_currency_mau_tbl'

Line 286: PO_DEBUG.debug_var(l_log_head,l_progress,'p_to_currency_precision_tbl'

282: PO_DEBUG.debug_var(l_log_head,l_progress,'p_from_currency_precision_tbl'
283: ,p_from_currency_precision_tbl);
284: PO_DEBUG.debug_var(l_log_head,l_progress,'p_from_currency_mau_tbl'
285: ,p_from_currency_mau_tbl);
286: PO_DEBUG.debug_var(l_log_head,l_progress,'p_to_currency_precision_tbl'
287: ,p_to_currency_precision_tbl);
288: PO_DEBUG.debug_var(l_log_head,l_progress,'p_to_currency_mau_tbl'
289: ,p_to_currency_mau_tbl);
290: END IF;

Line 288: PO_DEBUG.debug_var(l_log_head,l_progress,'p_to_currency_mau_tbl'

284: PO_DEBUG.debug_var(l_log_head,l_progress,'p_from_currency_mau_tbl'
285: ,p_from_currency_mau_tbl);
286: PO_DEBUG.debug_var(l_log_head,l_progress,'p_to_currency_precision_tbl'
287: ,p_to_currency_precision_tbl);
288: PO_DEBUG.debug_var(l_log_head,l_progress,'p_to_currency_mau_tbl'
289: ,p_to_currency_mau_tbl);
290: END IF;
291:
292: x_return_status := FND_API.g_ret_sts_success;

Line 299: PO_DEBUG.debug_var(l_log_head,l_progress,

295: INTO l_transaction_id
296: FROM DUAL;
297:
298: IF g_debug_stmt THEN
299: PO_DEBUG.debug_var(l_log_head,l_progress,
300: 'l_transaction_id', l_transaction_id);
301: END IF;
302:
303: l_progress := '010';

Line 387: SELECT rowid BULK COLLECT INTO PO_DEBUG.g_rowid_tbl

383:
384:
385: IF g_debug_stmt THEN
386: l_progress := '040';
387: SELECT rowid BULK COLLECT INTO PO_DEBUG.g_rowid_tbl
388: FROM PO_SESSION_GT WHERE key = l_transaction_id;
389:
390: PO_DEBUG.debug_table(l_log_head,l_progress,'PO_SESSION_GT',
391: PO_DEBUG.g_rowid_tbl,

Line 390: PO_DEBUG.debug_table(l_log_head,l_progress,'PO_SESSION_GT',

386: l_progress := '040';
387: SELECT rowid BULK COLLECT INTO PO_DEBUG.g_rowid_tbl
388: FROM PO_SESSION_GT WHERE key = l_transaction_id;
389:
390: PO_DEBUG.debug_table(l_log_head,l_progress,'PO_SESSION_GT',
391: PO_DEBUG.g_rowid_tbl,
392: po_tbl_varchar30('num1','num2','num3',
393: 'num4','num5','num6',
394: 'num7')

Line 391: PO_DEBUG.g_rowid_tbl,

387: SELECT rowid BULK COLLECT INTO PO_DEBUG.g_rowid_tbl
388: FROM PO_SESSION_GT WHERE key = l_transaction_id;
389:
390: PO_DEBUG.debug_table(l_log_head,l_progress,'PO_SESSION_GT',
391: PO_DEBUG.g_rowid_tbl,
392: po_tbl_varchar30('num1','num2','num3',
393: 'num4','num5','num6',
394: 'num7')
395: );

Line 409: PO_DEBUG.debug_var(l_log_head,l_progress,'x_amount_out_tbl'

405: ORDER BY TEMP.num1; --input and output tbls have same ordering
406:
407: l_progress := '050';
408: IF g_debug_stmt THEN
409: PO_DEBUG.debug_var(l_log_head,l_progress,'x_amount_out_tbl'
410: ,x_amount_out_tbl);
411: PO_DEBUG.debug_end(l_log_head);
412: END IF;
413:

Line 411: PO_DEBUG.debug_end(l_log_head);

407: l_progress := '050';
408: IF g_debug_stmt THEN
409: PO_DEBUG.debug_var(l_log_head,l_progress,'x_amount_out_tbl'
410: ,x_amount_out_tbl);
411: PO_DEBUG.debug_end(l_log_head);
412: END IF;
413:
414:
415: EXCEPTION

Line 424: PO_DEBUG.debug_exc(

420: po_message_s.sql_error(g_pkg_name, l_api_name,
421: l_progress, SQLCODE, SQLERRM);
422: fnd_msg_pub.add;
423: IF g_debug_unexp THEN
424: PO_DEBUG.debug_exc(
425: p_log_head => l_log_head
426: , p_progress => l_progress
427: );
428: END IF;