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.RCV_NORMALIZE_DATA_PKG dependencies on ASN_DEBUG

Line 65: asn_debug.put_line('count of running rtis'|| x_rti_count);

61: WHERE header_interface_id = p_rhi_row.header_interface_id
62: AND processing_status_code in ('PENDING','RUNNING')
63: AND transaction_status_code = 'PENDING';
64:
65: asn_debug.put_line('count of running rtis'|| x_rti_count);
66:
67: IF x_rti_count = 0 THEN -- error out orphan rhi
68: asn_debug.put_line('Erroring out orphan RHI: ' ||
69: p_rhi_row.header_interface_id);

Line 68: asn_debug.put_line('Erroring out orphan RHI: ' ||

64:
65: asn_debug.put_line('count of running rtis'|| x_rti_count);
66:
67: IF x_rti_count = 0 THEN -- error out orphan rhi
68: asn_debug.put_line('Erroring out orphan RHI: ' ||
69: p_rhi_row.header_interface_id);
70:
71: p_rhi_row.processing_status_code := 'ERROR';
72: p_rhi_row.processing_request_id := g_request_id;

Line 156: asn_debug.put_line('Processing row INTERFACE_TRANSACTION_ID = ' || p_rti_row.interface_transaction_id);

152: BEGIN
153: l_true := TRUE; -- BugFix 5078706
154:
155: BEGIN
156: asn_debug.put_line('Processing row INTERFACE_TRANSACTION_ID = ' || p_rti_row.interface_transaction_id);
157:
158: -- Following code is added for BugFix 5078706
159: BEGIN
160: select transaction_id,

Line 241: asn_debug.put_line('Setting current row to status LC_PENDING');

237: AND p_rti_row.auto_transact_code in ('RECEIVE','DELIVER')))
238: AND rcv_table_functions.is_lcm_shipment (p_rti_row.po_line_location_id) = 'Y'
239: AND p_rti_row.lcm_shipment_line_id is null) THEN
240: --
241: asn_debug.put_line('Setting current row to status LC_PENDING');
242: p_rti_row.processing_status_code := 'LC_PENDING';
243: --
244: ELSE
245: /* If a non-lcm line and lcm line are tied to the same lpn_group_id, we

Line 260: asn_debug.put_line('LPN Group check : l_lpn_group_rti_count = ' ||l_lpn_group_rti_count, null,14);

256: where pll.line_location_id = rti.po_line_location_id
257: and lcm_flag = 'Y')
258: and (rti.lcm_shipment_line_id is null or rti.unit_landed_cost is null);
259: --
260: asn_debug.put_line('LPN Group check : l_lpn_group_rti_count = ' ||l_lpn_group_rti_count, null,14);
261: --
262: END IF;
263: --
264: IF (x_rhi_row.asn_type = 'ASN'

Line 278: asn_debug.put_line('ASN check : l_lpn_group_rti_count = ' ||l_lpn_group_rti_count, null,14);

274: where pll.line_location_id = rti.po_line_location_id
275: and lcm_flag = 'Y')
276: and (rti.lcm_shipment_line_id is null or rti.unit_landed_cost is null);
277: --
278: asn_debug.put_line('ASN check : l_lpn_group_rti_count = ' ||l_lpn_group_rti_count, null,14);
279: --
280: END IF;
281: IF (l_lpn_group_rti_count > 0) THEN
282: asn_debug.put_line('Setting current row to status WLC_PENDING');

Line 282: asn_debug.put_line('Setting current row to status WLC_PENDING');

278: asn_debug.put_line('ASN check : l_lpn_group_rti_count = ' ||l_lpn_group_rti_count, null,14);
279: --
280: END IF;
281: IF (l_lpn_group_rti_count > 0) THEN
282: asn_debug.put_line('Setting current row to status WLC_PENDING');
283: p_rti_row.processing_status_code := 'WLC_PENDING';
284: p_rti_row.processing_request_id := g_request_id;
285: IF (x_rhi_row.processing_status_code = 'ERROR') THEN
286: asn_debug.put_line('Setting header row status HEADER_INTERFACE_ID=' || x_rhi_row.header_interface_id);

Line 286: asn_debug.put_line('Setting header row status HEADER_INTERFACE_ID=' || x_rhi_row.header_interface_id);

282: asn_debug.put_line('Setting current row to status WLC_PENDING');
283: p_rti_row.processing_status_code := 'WLC_PENDING';
284: p_rti_row.processing_request_id := g_request_id;
285: IF (x_rhi_row.processing_status_code = 'ERROR') THEN
286: asn_debug.put_line('Setting header row status HEADER_INTERFACE_ID=' || x_rhi_row.header_interface_id);
287: x_rhi_row.processing_status_code := 'PENDING';
288: x_rhi_row.processing_request_id := g_request_id;
289: rcv_table_functions.update_rhi_row(x_rhi_row);
290: END IF;

Line 292: asn_debug.put_line('Setting current row to status RUNNING');

288: x_rhi_row.processing_request_id := g_request_id;
289: rcv_table_functions.update_rhi_row(x_rhi_row);
290: END IF;
291: ELSE
292: asn_debug.put_line('Setting current row to status RUNNING');
293: p_rti_row.processing_status_code := 'RUNNING';
294: p_rti_row.processing_request_id := g_request_id;
295: IF (x_rhi_row.processing_status_code IN ('PENDING', 'ERROR')) THEN
296: asn_debug.put_line('Setting header row status HEADER_INTERFACE_ID=' || x_rhi_row.header_interface_id);

Line 296: asn_debug.put_line('Setting header row status HEADER_INTERFACE_ID=' || x_rhi_row.header_interface_id);

292: asn_debug.put_line('Setting current row to status RUNNING');
293: p_rti_row.processing_status_code := 'RUNNING';
294: p_rti_row.processing_request_id := g_request_id;
295: IF (x_rhi_row.processing_status_code IN ('PENDING', 'ERROR')) THEN
296: asn_debug.put_line('Setting header row status HEADER_INTERFACE_ID=' || x_rhi_row.header_interface_id);
297: x_rhi_row.processing_status_code := 'RUNNING';
298: x_rhi_row.processing_request_id := g_request_id;
299: rcv_table_functions.update_rhi_row(x_rhi_row);
300: END IF;

Line 306: asn_debug.put_line('Setting current row to status RUNNING');

302: --
303: END IF;
304: --
305: ELSE
306: asn_debug.put_line('Setting current row to status RUNNING');
307: p_rti_row.processing_status_code := 'RUNNING';
308: p_rti_row.processing_request_id := g_request_id;
309:
310: IF (x_rhi_row.processing_status_code IN('PENDING', 'ERROR')) THEN

Line 311: asn_debug.put_line('Setting header row status HEADER_INTERFACE_ID=' || x_rhi_row.header_interface_id);

307: p_rti_row.processing_status_code := 'RUNNING';
308: p_rti_row.processing_request_id := g_request_id;
309:
310: IF (x_rhi_row.processing_status_code IN('PENDING', 'ERROR')) THEN
311: asn_debug.put_line('Setting header row status HEADER_INTERFACE_ID=' || x_rhi_row.header_interface_id);
312: x_rhi_row.processing_status_code := 'RUNNING';
313: x_rhi_row.processing_request_id := g_request_id;
314: rcv_table_functions.update_rhi_row(x_rhi_row);
315: END IF;

Line 329: asn_debug.put_line('in explode_all_lpn');

325: l_ret_status VARCHAR2(20);
326: l_msg_count NUMBER;
327: l_msg_data VARCHAR2(100);
328: BEGIN
329: asn_debug.put_line('in explode_all_lpn');
330:
331: UPDATE rcv_transactions_interface
332: SET processing_status_code = 'RUNNING',
333: processing_request_id = g_request_id

Line 359: asn_debug.put_line('finished explode_all_lpn');

355: SET processing_status_code = 'PENDING'
356: WHERE processing_status_code = 'RUNNING'
357: AND processing_request_id = g_request_id;
358:
359: asn_debug.put_line('finished explode_all_lpn');
360: EXCEPTION
361: WHEN OTHERS THEN
362: asn_debug.put_line('encountered an error in explode_all_lpn');
363: END explode_all_lpn;

Line 362: asn_debug.put_line('encountered an error in explode_all_lpn');

358:
359: asn_debug.put_line('finished explode_all_lpn');
360: EXCEPTION
361: WHEN OTHERS THEN
362: asn_debug.put_line('encountered an error in explode_all_lpn');
363: END explode_all_lpn;
364:
365: PROCEDURE explode_lpn IS
366: l_ret_status VARCHAR2(20);

Line 370: asn_debug.put_line('in explode_lpn');

366: l_ret_status VARCHAR2(20);
367: l_msg_count NUMBER;
368: l_msg_data VARCHAR2(100);
369: BEGIN
370: asn_debug.put_line('in explode_lpn');
371:
372: UPDATE rcv_transactions_interface
373: SET processing_status_code = 'RUNNING',
374: processing_request_id = g_request_id,

Line 401: asn_debug.put_line('finished explode_lpn');

397: WHERE processing_status_code = 'RUNNING'
398: AND processing_request_id = g_request_id
399: AND GROUP_ID = g_group_id;
400:
401: asn_debug.put_line('finished explode_lpn');
402: EXCEPTION
403: WHEN OTHERS THEN
404: asn_debug.put_line('encountered an error in explode_lpn');
405: END explode_lpn;

Line 404: asn_debug.put_line('encountered an error in explode_lpn');

400:
401: asn_debug.put_line('finished explode_lpn');
402: EXCEPTION
403: WHEN OTHERS THEN
404: asn_debug.put_line('encountered an error in explode_lpn');
405: END explode_lpn;
406:
407: PROCEDURE process_pending_rows(
408: p_processing_mode IN VARCHAR2,

Line 515: asn_debug.put_line('Process Pending Rows: p_processing_mode=' || p_processing_mode || ' g_group_id=' || g_group_id || ' g_request_id=' || g_request_id || ' p_org_id=' || p_org_id);

511: FETCH c_get_group_id INTO g_group_id;
512: CLOSE c_get_group_id;
513: END IF;
514:
515: asn_debug.put_line('Process Pending Rows: p_processing_mode=' || p_processing_mode || ' g_group_id=' || g_group_id || ' g_request_id=' || g_request_id || ' p_org_id=' || p_org_id);
516:
517: /* we cannot use bulk collects because we are using the tablespace as working memory */
518: IF (g_multiple_groups = TRUE) THEN
519: asn_debug.put_line('Processing multiple groups...');

Line 519: asn_debug.put_line('Processing multiple groups...');

515: asn_debug.put_line('Process Pending Rows: p_processing_mode=' || p_processing_mode || ' g_group_id=' || g_group_id || ' g_request_id=' || g_request_id || ' p_org_id=' || p_org_id);
516:
517: /* we cannot use bulk collects because we are using the tablespace as working memory */
518: IF (g_multiple_groups = TRUE) THEN
519: asn_debug.put_line('Processing multiple groups...');
520: explode_all_lpn;
521:
522: FOR x_rhi_row IN c_get_all_pending_rhi_row LOOP
523: prepare_pending_rhi(x_rhi_row);

Line 534: asn_debug.put_line('Processing single group...');

530: FOR x_rti_row IN c_get_all_orphan_rti_row LOOP
531: process_orphan_rti(x_rti_row);
532: END LOOP;
533: ELSE
534: asn_debug.put_line('Processing single group...');
535: explode_lpn;
536:
537: FOR x_rhi_row IN c_get_pending_rhi_row LOOP
538: prepare_pending_rhi(x_rhi_row);

Line 562: asn_debug.put_line('Check orphan RHI');

558: END LOOP;
559: END IF;
560:
561: /* rhi could be without any pending rti at this point. */
562: asn_debug.put_line('Check orphan RHI');
563: IF (g_multiple_groups = TRUE) THEN
564: FOR x_rhi_row IN c_get_all_pending_rhi_row LOOP
565: check_orphan_rhi(x_rhi_row);
566: END LOOP;

Line 574: asn_debug.put_line('Calling RCV_LCM_WEB_SERVICE.Get_Landed_Cost');

570: END LOOP;
571: END IF;
572:
573: /* lcm changes */
574: asn_debug.put_line('Calling RCV_LCM_WEB_SERVICE.Get_Landed_Cost');
575: RCV_LCM_WEB_SERVICE.Get_Landed_Cost (p_group_id, p_processing_mode);
576:
577: END process_pending_rows;
578: END rcv_normalize_data_pkg;