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 248: PO_DEBUG.debug_begin(l_log_head);

244:
245: BEGIN
246:
247: IF g_debug_stmt THEN
248: PO_DEBUG.debug_begin(l_log_head);
249: PO_DEBUG.debug_var(l_log_head,l_progress,'p_unique_id_tbl'
250: ,p_unique_id_tbl);
251: PO_DEBUG.debug_var(l_log_head,l_progress,'p_amount_in_tbl'
252: ,p_amount_in_tbl);

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

245: BEGIN
246:
247: IF g_debug_stmt THEN
248: PO_DEBUG.debug_begin(l_log_head);
249: PO_DEBUG.debug_var(l_log_head,l_progress,'p_unique_id_tbl'
250: ,p_unique_id_tbl);
251: PO_DEBUG.debug_var(l_log_head,l_progress,'p_amount_in_tbl'
252: ,p_amount_in_tbl);
253: PO_DEBUG.debug_var(l_log_head,l_progress,'p_exchange_rate_tbl'

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

247: IF g_debug_stmt THEN
248: PO_DEBUG.debug_begin(l_log_head);
249: PO_DEBUG.debug_var(l_log_head,l_progress,'p_unique_id_tbl'
250: ,p_unique_id_tbl);
251: PO_DEBUG.debug_var(l_log_head,l_progress,'p_amount_in_tbl'
252: ,p_amount_in_tbl);
253: PO_DEBUG.debug_var(l_log_head,l_progress,'p_exchange_rate_tbl'
254: ,p_exchange_rate_tbl);
255: PO_DEBUG.debug_var(l_log_head,l_progress,'p_from_currency_precision_tbl'

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

249: PO_DEBUG.debug_var(l_log_head,l_progress,'p_unique_id_tbl'
250: ,p_unique_id_tbl);
251: PO_DEBUG.debug_var(l_log_head,l_progress,'p_amount_in_tbl'
252: ,p_amount_in_tbl);
253: PO_DEBUG.debug_var(l_log_head,l_progress,'p_exchange_rate_tbl'
254: ,p_exchange_rate_tbl);
255: PO_DEBUG.debug_var(l_log_head,l_progress,'p_from_currency_precision_tbl'
256: ,p_from_currency_precision_tbl);
257: PO_DEBUG.debug_var(l_log_head,l_progress,'p_from_currency_mau_tbl'

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

251: PO_DEBUG.debug_var(l_log_head,l_progress,'p_amount_in_tbl'
252: ,p_amount_in_tbl);
253: PO_DEBUG.debug_var(l_log_head,l_progress,'p_exchange_rate_tbl'
254: ,p_exchange_rate_tbl);
255: PO_DEBUG.debug_var(l_log_head,l_progress,'p_from_currency_precision_tbl'
256: ,p_from_currency_precision_tbl);
257: PO_DEBUG.debug_var(l_log_head,l_progress,'p_from_currency_mau_tbl'
258: ,p_from_currency_mau_tbl);
259: PO_DEBUG.debug_var(l_log_head,l_progress,'p_to_currency_precision_tbl'

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

253: PO_DEBUG.debug_var(l_log_head,l_progress,'p_exchange_rate_tbl'
254: ,p_exchange_rate_tbl);
255: PO_DEBUG.debug_var(l_log_head,l_progress,'p_from_currency_precision_tbl'
256: ,p_from_currency_precision_tbl);
257: PO_DEBUG.debug_var(l_log_head,l_progress,'p_from_currency_mau_tbl'
258: ,p_from_currency_mau_tbl);
259: PO_DEBUG.debug_var(l_log_head,l_progress,'p_to_currency_precision_tbl'
260: ,p_to_currency_precision_tbl);
261: PO_DEBUG.debug_var(l_log_head,l_progress,'p_to_currency_mau_tbl'

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

255: PO_DEBUG.debug_var(l_log_head,l_progress,'p_from_currency_precision_tbl'
256: ,p_from_currency_precision_tbl);
257: PO_DEBUG.debug_var(l_log_head,l_progress,'p_from_currency_mau_tbl'
258: ,p_from_currency_mau_tbl);
259: PO_DEBUG.debug_var(l_log_head,l_progress,'p_to_currency_precision_tbl'
260: ,p_to_currency_precision_tbl);
261: PO_DEBUG.debug_var(l_log_head,l_progress,'p_to_currency_mau_tbl'
262: ,p_to_currency_mau_tbl);
263: END IF;

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

257: PO_DEBUG.debug_var(l_log_head,l_progress,'p_from_currency_mau_tbl'
258: ,p_from_currency_mau_tbl);
259: PO_DEBUG.debug_var(l_log_head,l_progress,'p_to_currency_precision_tbl'
260: ,p_to_currency_precision_tbl);
261: PO_DEBUG.debug_var(l_log_head,l_progress,'p_to_currency_mau_tbl'
262: ,p_to_currency_mau_tbl);
263: END IF;
264:
265: x_return_status := FND_API.g_ret_sts_success;

Line 272: PO_DEBUG.debug_var(l_log_head,l_progress,

268: INTO l_transaction_id
269: FROM DUAL;
270:
271: IF g_debug_stmt THEN
272: PO_DEBUG.debug_var(l_log_head,l_progress,
273: 'l_transaction_id', l_transaction_id);
274: END IF;
275:
276: l_progress := '010';

Line 360: SELECT rowid BULK COLLECT INTO PO_DEBUG.g_rowid_tbl

356:
357:
358: IF g_debug_stmt THEN
359: l_progress := '040';
360: SELECT rowid BULK COLLECT INTO PO_DEBUG.g_rowid_tbl
361: FROM PO_SESSION_GT WHERE key = l_transaction_id;
362:
363: PO_DEBUG.debug_table(l_log_head,l_progress,'PO_SESSION_GT',
364: PO_DEBUG.g_rowid_tbl,

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

359: l_progress := '040';
360: SELECT rowid BULK COLLECT INTO PO_DEBUG.g_rowid_tbl
361: FROM PO_SESSION_GT WHERE key = l_transaction_id;
362:
363: PO_DEBUG.debug_table(l_log_head,l_progress,'PO_SESSION_GT',
364: PO_DEBUG.g_rowid_tbl,
365: po_tbl_varchar30('num1','num2','num3',
366: 'num4','num5','num6',
367: 'num7')

Line 364: PO_DEBUG.g_rowid_tbl,

360: SELECT rowid BULK COLLECT INTO PO_DEBUG.g_rowid_tbl
361: FROM PO_SESSION_GT WHERE key = l_transaction_id;
362:
363: PO_DEBUG.debug_table(l_log_head,l_progress,'PO_SESSION_GT',
364: PO_DEBUG.g_rowid_tbl,
365: po_tbl_varchar30('num1','num2','num3',
366: 'num4','num5','num6',
367: 'num7')
368: );

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

378: ORDER BY TEMP.num1; --input and output tbls have same ordering
379:
380: l_progress := '050';
381: IF g_debug_stmt THEN
382: PO_DEBUG.debug_var(l_log_head,l_progress,'x_amount_out_tbl'
383: ,x_amount_out_tbl);
384: PO_DEBUG.debug_end(l_log_head);
385: END IF;
386:

Line 384: PO_DEBUG.debug_end(l_log_head);

380: l_progress := '050';
381: IF g_debug_stmt THEN
382: PO_DEBUG.debug_var(l_log_head,l_progress,'x_amount_out_tbl'
383: ,x_amount_out_tbl);
384: PO_DEBUG.debug_end(l_log_head);
385: END IF;
386:
387:
388: EXCEPTION

Line 397: PO_DEBUG.debug_exc(

393: po_message_s.sql_error(g_pkg_name, l_api_name,
394: l_progress, SQLCODE, SQLERRM);
395: fnd_msg_pub.add;
396: IF g_debug_unexp THEN
397: PO_DEBUG.debug_exc(
398: p_log_head => l_log_head
399: , p_progress => l_progress
400: );
401: END IF;