DBA Data[Home] [Help]

APPS.PO_AUTOCREATE_PVT dependencies on PO_DEBUG

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

4:
5: g_pkg_name CONSTANT VARCHAR2(1000) := 'PO_AUTOCREATE_PVT';
6: g_log_head CONSTANT VARCHAR2(1000) := 'po.plsql.PO_AUTOCREATE_PVT.';
7:
8: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
9: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
10:
11:
12:

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

5: g_pkg_name CONSTANT VARCHAR2(1000) := 'PO_AUTOCREATE_PVT';
6: g_log_head CONSTANT VARCHAR2(1000) := 'po.plsql.PO_AUTOCREATE_PVT.';
7:
8: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
9: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
10:
11:
12:
13: /* ----------------------------------------------------

Line 30: PO_DEBUG.debug_begin(p_log_head => g_log_head||'wrapup');

26: PROCEDURE wrapup
27: IS
28: BEGIN
29: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >
30: PO_DEBUG.debug_begin(p_log_head => g_log_head||'wrapup');
31: END IF;
32:
33: DELETE po_distributions_interface
34: WHERE interface_header_id = PO_AUTOCREATE_PARAMS.x_interface_header_id;

Line 54: PO_DEBUG.debug_end(p_log_head => g_log_head||'wrapup');

50: DELETE po_headers_interface
51: WHERE interface_header_id = PO_AUTOCREATE_PARAMS.x_interface_header_id;
52:
53: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >
54: PO_DEBUG.debug_end(p_log_head => g_log_head||'wrapup');
55: END IF;
56: END wrapup;
57:
58:

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

114:
115: BEGIN
116:
117: IF g_debug_stmt THEN
118: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
119: END IF;
120:
121: -- Create savepoint for create_po
122: SAVEPOINT create_po;

Line 136: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

132:
133: l_progress := '015';
134:
135: IF g_debug_stmt THEN
136: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
137: p_token => l_progress,
138: p_message => 'At begin of create_po : Interface Header Id:'||x_interface_header_id);
139:
140: END IF;

Line 164: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

160: END IF;
161:
162:
163: IF g_debug_stmt THEN
164: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
165: p_token => l_progress,
166: p_message => 'At the end of create_po');
167:
168: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

Line 168: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

164: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
165: p_token => l_progress,
166: p_message => 'At the end of create_po');
167:
168: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
169: p_token => l_progress,
170: p_message => 'l_return_status:'||l_return_status||' x_document_id:'||x_document_id);
171:
172: END IF;

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

171:
172: END IF;
173:
174: IF g_debug_stmt THEN
175: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
176: END IF;
177:
178: EXCEPTION
179: WHEN OTHERS THEN

Line 186: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,

182: PO_AUTOCREATE_PVT.report_error('PO_AUTOCREATE_ERR',x_token1_value => sqlerrm);
183:
184: wrapup;
185: IF g_debug_unexp THEN
186: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
187: p_progress => l_progress);
188: END IF;
189: po_message_s.sql_error('CREATE_PO',l_progress,sqlcode);
190: --

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

231:
232: -- Added call to JG_GLOBE_UTIL_PKG.process_po_globe_event
233:
234: IF g_debug_stmt THEN
235: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
236: END IF;
237:
238: ---------------------------------------------------
239: -- Check whether the Regional Package is installed

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

275: -- Close the cursor
276: dbms_sql.close_cursor(l_cursor);
277:
278: IF g_debug_stmt THEN
279: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
280: END IF;
281:
282: EXCEPTION
283:

Line 290: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

286: ----------------------------------------
287: -- Regional Procedure is not installed
288: ----------------------------------------
289: IF g_debug_stmt THEN
290: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
291: p_token => l_progress,
292: p_message => 'NO_DATA_FOUND: '||SQLERRM);
293: END IF;
294:

Line 298: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,

294:
295: WHEN OTHERS THEN
296:
297: IF g_debug_unexp THEN
298: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
299: p_progress => l_progress);
300: END IF;
301: RAISE;
302: END calculate_local;

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

317: l_progress VARCHAR2(10) := '000';
318: BEGIN
319:
320: IF g_debug_stmt THEN
321: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
322: END IF;
323:
324: fnd_message.set_name('PO',error_msg);
325: fnd_message.set_token(x_token1_name,x_token1_value);

Line 335: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

331: PO_AUTOCREATE_PARAMS.g_error_code_tbl.extend(1);
332: PO_AUTOCREATE_PARAMS.g_error_code_tbl(PO_AUTOCREATE_PARAMS.g_error_code_tbl.count) := fnd_message.get;
333:
334: IF g_debug_stmt THEN
335: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
336: p_token => l_progress,
337: p_message => PO_AUTOCREATE_PARAMS.g_error_code_tbl(PO_AUTOCREATE_PARAMS.g_error_code_tbl.count));
338: END IF;
339:

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

337: p_message => PO_AUTOCREATE_PARAMS.g_error_code_tbl(PO_AUTOCREATE_PARAMS.g_error_code_tbl.count));
338: END IF;
339:
340: IF g_debug_stmt THEN
341: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
342: END IF;
343:
344: END report_error;
345: -- CLM Phase 2 Changes : Error Handling

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

355:
356: BEGIN
357:
358: IF g_debug_stmt THEN
359: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
360: END IF;
361:
362: select prh.segment1||','||prl.line_num_display into l_requisition_number
363: from po_requisition_lines_all prl, po_requisition_headers_all prh

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

364: where prh.REQUISITION_HEADER_ID = prl.REQUISITION_HEADER_ID
365: and prl.requisition_line_id = p_req_line_id;
366:
367: IF g_debug_stmt THEN
368: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
369: END IF;
370:
371: RETURN l_requisition_number;
372:

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

395:
396: BEGIN
397:
398: IF g_debug_stmt THEN
399: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
400: END IF;
401:
402: RETURN PO_AUTOCREATE_PARAMS.g_error_code_tbl;
403: