DBA Data[Home] [Help]

APPS.PO_AUTO_LINE_LOC_PROCESS_PVT dependencies on PO_DEBUG

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

2: /* $Header: PO_AUTO_LINE_LOC_PROCESS_PVT.plb 120.17.12020000.3 2013/02/10 17:14:46 vegajula ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(1000) := 'PO_AUTO_LINE_LOC_PROCESS_PVT';
5: g_log_head CONSTANT VARCHAR2(1000) := 'po.plsql.PO_AUTO_LINE_LOC_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: **

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

3:
4: g_pkg_name CONSTANT VARCHAR2(1000) := 'PO_AUTO_LINE_LOC_PROCESS_PVT';
5: g_log_head CONSTANT VARCHAR2(1000) := 'po.plsql.PO_AUTO_LINE_LOC_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: **
11: ** NAME

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

146:
147: BEGIN
148:
149: IF g_debug_stmt THEN
150: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
151: END IF;
152:
153: l_progress :='001';
154:

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

152:
153: l_progress :='001';
154:
155: IF g_debug_stmt THEN
156: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
157: p_message => 'Num of lines:'||p_lines.intf_line_id_tbl.Count);
158: END IF;
159:
160: FOR i IN 1.. p_lines.intf_line_id_tbl.Count

Line 188: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Inside CLM shipment processing');

184:
185: IF NVL(p_lines.clm_info_flag_tbl(i),'N') = 'N' AND p_lines.shipment_num_tbl(i) IS NOT NULL THEN
186:
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 => 'Inside CLM shipment processing');
189: END IF;
190:
191: IF p_lines.item_id_tbl(i) IS NOT NULL THEN
192:

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

217: -- source document is a quote and profile 'PO: Convert Requisition UOM to Source Document UOM'
218: -- should be ignored in that case
219:
220: IF g_debug_stmt THEN
221: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
222: p_message => 'from line id :'||p_lines.from_line_id_tbl(i)||'from header id:'||p_lines.from_header_id_tbl(i));
223: END IF;
224:
225: l_progress :='030';

Line 236: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'l_from_type_lookup_code :'||l_from_type_lookup_code);

232: FROM po_headers_all poh
233: WHERE poh.po_header_id=p_lines.from_header_id_tbl(i) ;
234:
235: IF g_debug_stmt THEN
236: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'l_from_type_lookup_code :'||l_from_type_lookup_code);
237: END IF;
238:
239: EXCEPTION
240: WHEN OTHERS THEN

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

238:
239: EXCEPTION
240: WHEN OTHERS THEN
241: IF g_debug_unexp THEN
242: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
243: END IF;
244:
245: --CLM Phase 2 changes : error handling
246: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_LOC_LOOKUP_ERR',

Line 256: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'x_uom_convert:'||x_uom_convert);

252: END IF;
253:
254: -- got the source document type, now compare it and if required do the UOM conversion
255: IF g_debug_stmt THEN
256: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'x_uom_convert:'||x_uom_convert);
257: END IF;
258:
259: IF (NVL(x_uom_convert,'N') = 'Y') THEN
260: -- Convert UOM when autocreating a PO that references a GA

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

270: AND draft_id =po_autocreate_params.g_draft_id;
271: EXCEPTION
272: WHEN OTHERS THEN
273: IF g_debug_unexp THEN
274: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
275: END IF;
276: po_message_s.sql_error('CREATE_SHIPMENTS',l_progress,SQLCODE);
277:
278: --CLM Phase 2 changes : error handling

Line 291: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Create_shipment: UOM: '||x_temp_uom);

287: /* before inserting the quantity into the shipments table convert the quantity
288: into the BPA uom if the uom's on the req and BPA are different .
289: This conversion is done only if the Convert UOM profile option is set to Yes. */
290: IF g_debug_stmt THEN
291: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Create_shipment: UOM: '||x_temp_uom);
292: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Create_shipment: item id: '||x_temp_item_id);
293: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Create_shipment: PO UOM: '||x_po_uom);
294: END IF;
295:

Line 292: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Create_shipment: item id: '||x_temp_item_id);

288: into the BPA uom if the uom's on the req and BPA are different .
289: This conversion is done only if the Convert UOM profile option is set to Yes. */
290: IF g_debug_stmt THEN
291: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Create_shipment: UOM: '||x_temp_uom);
292: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Create_shipment: item id: '||x_temp_item_id);
293: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Create_shipment: PO UOM: '||x_po_uom);
294: END IF;
295:
296: l_progress := '060';

Line 293: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Create_shipment: PO UOM: '||x_po_uom);

289: This conversion is done only if the Convert UOM profile option is set to Yes. */
290: IF g_debug_stmt THEN
291: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Create_shipment: UOM: '||x_temp_uom);
292: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Create_shipment: item id: '||x_temp_item_id);
293: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'Create_shipment: PO UOM: '||x_po_uom);
294: END IF;
295:
296: l_progress := '060';
297: IF ( ( p_lines.unit_of_measure_tbl(i) <> x_po_uom ) AND ( x_order_type_lookup_code IN ('QUANTITY','AMOUNT') ) ) THEN --

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

300: x_quantity := ROUND(x_quantity * l_conversion_rate , 15);
301: x_shipment_uom := x_po_uom ; --
302:
303: IF g_debug_stmt THEN
304: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
305: p_message => 'Create_shipment: Converted Qty: '||x_quantity);
306: END IF;
307: END IF;
308: END IF;

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

340:
341: EXCEPTION
342: WHEN NO_DATA_FOUND THEN
343: IF g_debug_stmt THEN
344: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'NO_DATA_FOUND: '||SQLERRM);
345: END IF;
346: WHEN OTHERS THEN
347: IF g_debug_unexp THEN
348: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

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

344: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress, p_message => 'NO_DATA_FOUND: '||SQLERRM);
345: END IF;
346: WHEN OTHERS THEN
347: IF g_debug_unexp THEN
348: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
349: END IF;
350:
351: --CLM Phase 2 changes : error handling
352: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_LOC_SEC_UOM_ERR',

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

371:
372: EXCEPTION
373: WHEN OTHERS THEN
374: IF g_debug_stmt THEN
375: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
376: p_message => 'EXCEPTION caught; SQL Code is '||SQLCODE||'; Error is '||SQLERRM);
377: END IF;
378: x_price := NULL;
379: END;

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

410:
411:
412:
413: IF l_return_status = 'E' THEN
414: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
415: p_token => l_progress,
416: p_message => 'Create_shipment: Error while obtaining lock');
417: Raise l_lock_exception;
418: END IF;

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

424: ** Update everything except closed_code
425: */
426: l_progress:='120';
427: IF g_debug_stmt THEN
428: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
429: p_token => l_progress,
430: p_message => 'Create_shipment: shipment exist');
431: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
432: p_token => l_progress,

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

427: IF g_debug_stmt THEN
428: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
429: p_token => l_progress,
430: p_message => 'Create_shipment: shipment exist');
431: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
432: p_token => l_progress,
433: p_message => 'Create_shipment: Update PO line locations');
434: END IF;
435:

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

532: END IF;
533: END IF;
534: l_progress := '150';
535: IF g_debug_stmt THEN
536: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
537: p_message => 'Create shipment: Before calling Auto close');
538: END IF;
539: IF NOT po_actions.close_po(p_lines.po_header_id_tbl(i),
540: x_doctype,

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

598: END IF;
599:
600: l_progress:='190';
601: IF g_debug_stmt THEN
602: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
603: p_message => 'create shipment: Shipment does not exist');
604: END IF;
605:
606: l_progress := '200';

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

634: ** Create a new shipment.
635: */
636: l_progress:='230';
637: IF g_debug_stmt THEN
638: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
639: p_message => 'Create shipment: Create a new shipment');
640: END IF;
641:
642: l_progress:='240';

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

688: END IF;
689: l_progress := '310';
690:
691: IF g_debug_stmt THEN
692: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
693: p_message => 'Create shipment: Before insert into po line locations');
694: END IF;
695:
696: IF p_lines.consigned_flag_tbl(i) = 'Y' THEN

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

704: END IF;
705:
706: l_progress := '320';
707: IF g_debug_stmt THEN
708: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
709: p_message => 'interface.trxn_flow_header_id='||p_lines.txn_flow_header_id_tbl(i));
710: END IF;
711:
712: IF p_lines.item_id_tbl(i) IS NOT NULL THEN

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

981: );
982:
983: l_progress := '360';
984: IF g_debug_stmt THEN
985: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
986: p_message => 'Create shipment: After insert into po line locations DRAFT');
987: END IF;
988: END IF;
989:

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

994:
995: END LOOP;
996:
997: IF g_debug_stmt THEN
998: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
999: END IF;
1000:
1001: EXCEPTION
1002:

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

1002:
1003: --autocreate grouping start
1004: WHEN l_lock_exception THEN
1005: IF g_debug_unexp THEN
1006: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
1007: p_progress => l_progress);
1008: END IF;
1009: po_message_s.sql_error('CREATE_SHIPMENT_DRAFT',l_progress,sqlcode);
1010: PO_AUTOCREATE_PVT.wrapup();

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

1011: RAISE;
1012: --autocreate grouping end
1013: WHEN OTHERS THEN
1014: IF g_debug_unexp THEN
1015: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
1016: END IF;
1017:
1018: --CLM Phase 2 changes : error handling
1019: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_LOC_DEFAULT_ERR',x_token1_value => sqlerrm);

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

1820: -- Standard start of API savepoint
1821: SAVEPOINT create_price_break_pvt;
1822:
1823: IF g_debug_stmt THEN
1824: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
1825: END IF;
1826:
1827: BEGIN
1828: l_progress := '030';

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

1830:
1831: EXCEPTION
1832: WHEN OTHERS THEN
1833: IF g_debug_unexp THEN
1834: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
1835: END IF;
1836:
1837: po_message_s.sql_error('Exception of create_price_break()', l_progress,SQLCODE);
1838: FND_MSG_PUB.Add;

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

2177:
2178: EXCEPTION
2179: WHEN OTHERS THEN
2180: IF g_debug_unexp THEN
2181: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
2182: END IF;
2183:
2184: po_message_s.sql_error('Exception of create_price_break()', l_progress, SQLCODE);
2185: FND_MSG_PUB.Add;

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

2188: END IF; --
2189: END LOOP;
2190:
2191: IF g_debug_stmt THEN
2192: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
2193: END IF;
2194:
2195: EXCEPTION
2196: WHEN unexpected_create_pb_err THEN

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

2194:
2195: EXCEPTION
2196: WHEN unexpected_create_pb_err THEN
2197: IF g_debug_unexp THEN
2198: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
2199: END IF;
2200:
2201: --CLM Phase 2 changes : error handling
2202: PO_AUTOCREATE_PVT.report_error('PO_AUTO_LINE_LOC_PB_ERR',x_token1_value => sqlerrm);

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

2206: --ROLLBACK to create_price_break_pvt;
2207:
2208: WHEN OTHERS THEN
2209: IF g_debug_unexp THEN
2210: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
2211: END IF;
2212:
2213: --ROLLBACK to create_price_break_pvt;
2214: --CLM Phase 2 changes : error handling

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

2254: l_requisition_header_id NUMBER;
2255:
2256: BEGIN
2257: IF g_debug_stmt THEN
2258: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
2259: END IF;
2260:
2261: l_progress := '010';
2262:

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

2295: last_update_login = p_lines.last_update_login_tbl(i)
2296: WHERE requisition_line_id = p_lines.requisition_line_id_tbl(i);
2297:
2298: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >
2299: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
2300: p_message => 'Upadte the req lines with '||p_lines.line_loc_id_tbl(i));
2301: END IF;
2302: -- added for Linking requisition to modification project
2303: IF (po_autocreate_params.g_is_clm_po ='Y' AND po_autocreate_params.g_process_code = 'ADD_FUNDS') THEN

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

2308: LINKED_TO_FUND = 'Y'
2309: WHERE requisition_line_id = p_lines.requisition_line_id_tbl(i);
2310:
2311: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >
2312: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
2313: p_message => 'Mod: Upadte the req lines with '||p_lines.po_line_id_tbl(i));
2314: END IF;
2315:
2316: END IF;

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

2326:
2327: l_progress := '030';
2328:
2329: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >
2330: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
2331: p_message => 'l_bid_number: ' || l_bid_number);
2332: END IF;
2333:
2334:

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

2351:
2352: l_count := SQL%ROWCOUNT;
2353:
2354: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >
2355: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
2356: p_message => 'Updated the req lines with Po Line Ref. l_count: ' || l_count);
2357: END IF;
2358:
2359: IF l_count > 0 THEN

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

2365:
2366: l_progress := '040';
2367:
2368: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >
2369: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
2370: p_message => 'Before update statment l_count: row i is : ' || i || ' header id : ' || l_requisition_header_id);
2371: END IF;
2372:
2373: UPDATE po_requisition_lines_all

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

2423: END LOOP;
2424: END IF;
2425:
2426: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >
2427: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
2428: p_message => 'Update the req in pool');
2429: END IF;
2430:
2431: IF g_debug_stmt THEN

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

2428: p_message => 'Update the req in pool');
2429: END IF;
2430:
2431: IF g_debug_stmt THEN
2432: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
2433: END IF;
2434: EXCEPTION
2435: WHEN OTHERS THEN
2436: IF g_debug_unexp THEN

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

2433: END IF;
2434: EXCEPTION
2435: WHEN OTHERS THEN
2436: IF g_debug_unexp THEN
2437: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
2438: END IF;
2439:
2440: --CLM Phase 2 changes : error handling
2441: PO_AUTOCREATE_PVT.report_error('PO_AUTO_UPD_REQ_LINE_ERR',x_token1_value => sqlerrm);