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_OTM_INTEGRATION_PVT dependencies on PO_DEBUG

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

1: PACKAGE BODY PO_OTM_INTEGRATION_PVT AS
2: /* $Header: POXVOTMB.pls 120.2.12010000.2 2008/08/04 08:34:20 rramasam ship $ */
3:
4: -- Debugging booleans used to bypass logging when turned off
5: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
6: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
7: g_po_wf_debug CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');
8:
9: -- Logging constants

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

2: /* $Header: POXVOTMB.pls 120.2.12010000.2 2008/08/04 08:34:20 rramasam ship $ */
3:
4: -- Debugging booleans used to bypass logging when turned off
5: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
6: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
7: g_po_wf_debug CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');
8:
9: -- Logging constants
10: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_OTM_INTEGRATION_PVT';

Line 140: PO_DEBUG.debug_begin(d_module);

136:
137: d_progress := '000';
138:
139: IF (g_debug_stmt) THEN
140: PO_DEBUG.debug_begin(d_module);
141: END IF;
142:
143: d_progress := '100';
144:

Line 156: PO_DEBUG.debug_var(d_module, d_progress, 'l_is_otm_installed', l_is_otm_installed);

152:
153: d_progress := '130';
154:
155: IF (g_debug_stmt) THEN
156: PO_DEBUG.debug_var(d_module, d_progress, 'l_is_otm_installed', l_is_otm_installed);
157: PO_DEBUG.debug_end(d_module);
158: END IF;
159:
160: RETURN l_is_otm_installed;

Line 157: PO_DEBUG.debug_end(d_module);

153: d_progress := '130';
154:
155: IF (g_debug_stmt) THEN
156: PO_DEBUG.debug_var(d_module, d_progress, 'l_is_otm_installed', l_is_otm_installed);
157: PO_DEBUG.debug_end(d_module);
158: END IF;
159:
160: RETURN l_is_otm_installed;
161:

Line 165: PO_DEBUG.debug_unexp(d_module, d_progress, 'Unexpected error');

161:
162: EXCEPTION
163: WHEN OTHERS THEN
164: IF (g_debug_unexp) THEN
165: PO_DEBUG.debug_unexp(d_module, d_progress, 'Unexpected error');
166: END IF;
167:
168: END is_otm_installed;
169:

Line 184: PO_DEBUG.debug_begin(d_module);

180:
181: d_progress := '000';
182:
183: IF (g_debug_stmt) THEN
184: PO_DEBUG.debug_begin(d_module);
185: END IF;
186:
187: d_progress := '100';
188:

Line 201: PO_DEBUG.debug_var(d_module, d_progress, 'l_is_logistics_enabled', l_is_logistics_enabled);

197:
198: d_progress := '130';
199:
200: IF (g_debug_stmt) THEN
201: PO_DEBUG.debug_var(d_module, d_progress, 'l_is_logistics_enabled', l_is_logistics_enabled);
202: PO_DEBUG.debug_end(d_module);
203: END IF;
204:
205: RETURN l_is_logistics_enabled;

Line 202: PO_DEBUG.debug_end(d_module);

198: d_progress := '130';
199:
200: IF (g_debug_stmt) THEN
201: PO_DEBUG.debug_var(d_module, d_progress, 'l_is_logistics_enabled', l_is_logistics_enabled);
202: PO_DEBUG.debug_end(d_module);
203: END IF;
204:
205: RETURN l_is_logistics_enabled;
206:

Line 210: PO_DEBUG.debug_unexp(d_module, d_progress, 'Unexpected error');

206:
207: EXCEPTION
208: WHEN OTHERS THEN
209: IF (g_debug_unexp) THEN
210: PO_DEBUG.debug_unexp(d_module, d_progress, 'Unexpected error');
211: END IF;
212:
213: END is_inbound_logistics_enabled;
214:

Line 246: PO_DEBUG.debug_begin(d_module);

242:
243: d_progress := '000';
244:
245: IF (g_debug_stmt) THEN
246: PO_DEBUG.debug_begin(d_module);
247: PO_DEBUG.debug_var(d_module, d_progress, 'p_doc_type', p_doc_type);
248: PO_DEBUG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
249: PO_DEBUG.debug_var(d_module, d_progress, 'p_action', p_action);
250: PO_DEBUG.debug_var(d_module, d_progress, 'p_action', p_action);

Line 247: PO_DEBUG.debug_var(d_module, d_progress, 'p_doc_type', p_doc_type);

243: d_progress := '000';
244:
245: IF (g_debug_stmt) THEN
246: PO_DEBUG.debug_begin(d_module);
247: PO_DEBUG.debug_var(d_module, d_progress, 'p_doc_type', p_doc_type);
248: PO_DEBUG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
249: PO_DEBUG.debug_var(d_module, d_progress, 'p_action', p_action);
250: PO_DEBUG.debug_var(d_module, d_progress, 'p_action', p_action);
251: PO_DEBUG.debug_var(d_module, d_progress, 'p_line_id', p_line_id);

Line 248: PO_DEBUG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);

244:
245: IF (g_debug_stmt) THEN
246: PO_DEBUG.debug_begin(d_module);
247: PO_DEBUG.debug_var(d_module, d_progress, 'p_doc_type', p_doc_type);
248: PO_DEBUG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
249: PO_DEBUG.debug_var(d_module, d_progress, 'p_action', p_action);
250: PO_DEBUG.debug_var(d_module, d_progress, 'p_action', p_action);
251: PO_DEBUG.debug_var(d_module, d_progress, 'p_line_id', p_line_id);
252: PO_DEBUG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);

Line 249: PO_DEBUG.debug_var(d_module, d_progress, 'p_action', p_action);

245: IF (g_debug_stmt) THEN
246: PO_DEBUG.debug_begin(d_module);
247: PO_DEBUG.debug_var(d_module, d_progress, 'p_doc_type', p_doc_type);
248: PO_DEBUG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
249: PO_DEBUG.debug_var(d_module, d_progress, 'p_action', p_action);
250: PO_DEBUG.debug_var(d_module, d_progress, 'p_action', p_action);
251: PO_DEBUG.debug_var(d_module, d_progress, 'p_line_id', p_line_id);
252: PO_DEBUG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);
253: END IF;

Line 250: PO_DEBUG.debug_var(d_module, d_progress, 'p_action', p_action);

246: PO_DEBUG.debug_begin(d_module);
247: PO_DEBUG.debug_var(d_module, d_progress, 'p_doc_type', p_doc_type);
248: PO_DEBUG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
249: PO_DEBUG.debug_var(d_module, d_progress, 'p_action', p_action);
250: PO_DEBUG.debug_var(d_module, d_progress, 'p_action', p_action);
251: PO_DEBUG.debug_var(d_module, d_progress, 'p_line_id', p_line_id);
252: PO_DEBUG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);
253: END IF;
254:

Line 251: PO_DEBUG.debug_var(d_module, d_progress, 'p_line_id', p_line_id);

247: PO_DEBUG.debug_var(d_module, d_progress, 'p_doc_type', p_doc_type);
248: PO_DEBUG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
249: PO_DEBUG.debug_var(d_module, d_progress, 'p_action', p_action);
250: PO_DEBUG.debug_var(d_module, d_progress, 'p_action', p_action);
251: PO_DEBUG.debug_var(d_module, d_progress, 'p_line_id', p_line_id);
252: PO_DEBUG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);
253: END IF;
254:
255: d_progress := '010';

Line 252: PO_DEBUG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);

248: PO_DEBUG.debug_var(d_module, d_progress, 'p_doc_id', p_doc_id);
249: PO_DEBUG.debug_var(d_module, d_progress, 'p_action', p_action);
250: PO_DEBUG.debug_var(d_module, d_progress, 'p_action', p_action);
251: PO_DEBUG.debug_var(d_module, d_progress, 'p_line_id', p_line_id);
252: PO_DEBUG.debug_var(d_module, d_progress, 'p_line_loc_id', p_line_loc_id);
253: END IF;
254:
255: d_progress := '010';
256:

Line 269: PO_DEBUG.debug_stmt(d_module, d_progress, 'Not initiating OTM integration because PO: ' || p_doc_id || ' is a Complex Work Purchase Order.');

265: -- We do not want to communicate Complex Work Purchase Orders to OTM.
266: IF(p_doc_type = 'PO' AND PO_COMPLEX_WORK_PVT.is_complex_work_po(p_doc_id)) THEN
267: d_progress := '040';
268: IF (g_debug_stmt) THEN
269: PO_DEBUG.debug_stmt(d_module, d_progress, 'Not initiating OTM integration because PO: ' || p_doc_id || ' is a Complex Work Purchase Order.');
270: END IF;
271: RETURN;
272: END IF; --IF complex work PO
273:

Line 323: PO_DEBUG.debug_var(d_module, d_progress, 'l_command', l_command);

319: l_command := '';
320: END IF;
321:
322: IF (g_debug_stmt) THEN
323: PO_DEBUG.debug_var(d_module, d_progress, 'l_command', l_command);
324: END IF;
325:
326: d_progress := '200';
327:

Line 477: PO_DEBUG.debug_stmt(d_module, d_progress, 'Not initiating OTM integration because SHIPPING_CONTROL (Transporation Arranged By) is NULL.');

473:
474: ELSE
475: d_progress := '395';
476: IF (g_debug_stmt) THEN
477: PO_DEBUG.debug_stmt(d_module, d_progress, 'Not initiating OTM integration because SHIPPING_CONTROL (Transporation Arranged By) is NULL.');
478: END IF;
479:
480: END IF; -- IF (l_shipping_control IN ('BUYER', 'SUPPLIER')) THEN
481:

Line 485: PO_DEBUG.debug_stmt(d_module, d_progress, 'Ignoring doc action: ' || l_command);

481:
482: ELSE
483: d_progress := '400';
484: IF (g_debug_stmt) THEN
485: PO_DEBUG.debug_stmt(d_module, d_progress, 'Ignoring doc action: ' || l_command);
486: END IF;
487:
488: END IF; -- IF (l_command IN ('APPROVE', 'CANCEL', 'HOLD', 'UNHOLD')) THEN
489:

Line 493: PO_DEBUG.debug_end(d_module);

489:
490: d_progress := '500';
491:
492: IF (g_debug_stmt) THEN
493: PO_DEBUG.debug_end(d_module);
494: END IF;
495:
496: EXCEPTION
497: WHEN NO_DATA_FOUND THEN

Line 499: PO_DEBUG.debug_unexp(d_module, d_progress, 'No data found for document');

495:
496: EXCEPTION
497: WHEN NO_DATA_FOUND THEN
498: IF (g_debug_unexp) THEN
499: PO_DEBUG.debug_unexp(d_module, d_progress, 'No data found for document');
500: END IF;
501: RAISE;
502:
503: WHEN OTHERS THEN

Line 505: PO_DEBUG.debug_unexp(d_module, d_progress, d_log_msg);

501: RAISE;
502:
503: WHEN OTHERS THEN
504: IF (g_debug_unexp) THEN
505: PO_DEBUG.debug_unexp(d_module, d_progress, d_log_msg);
506: END IF;
507: RAISE;
508:
509: END handle_doc_update;