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_TABLE_FUNCTIONS dependencies on ASN_DEBUG

Line 43: asn_debug.put_line('Invalid value ' || p_value || ' for ' || p_column || ' in RCV_TABLE_FUNCTIONS');

39: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE_NE');
40: rcv_error_pkg.set_token('COLUMN', p_column);
41: rcv_error_pkg.set_token('ROI_VALUE', p_value);
42: g_error_column := p_column;
43: asn_debug.put_line('Invalid value ' || p_value || ' for ' || p_column || ' in RCV_TABLE_FUNCTIONS');
44: RAISE e_fatal_error;
45: END invalid_value;
46:
47: /* NOTE: All functions except IS_ORG_ID_IN_OU are operating unit (OU) agnostic */

Line 81: asn_debug.put_line('Updating RHI HEADER_INTERFACE_ID=' || p_rhi_row.header_interface_id);

77: PROCEDURE update_rhi_row(
78: p_rhi_row IN rcv_headers_interface%ROWTYPE
79: ) IS
80: BEGIN
81: asn_debug.put_line('Updating RHI HEADER_INTERFACE_ID=' || p_rhi_row.header_interface_id);
82:
83: UPDATE rcv_headers_interface
84: SET ROW = p_rhi_row
85: WHERE header_interface_id = p_rhi_row.header_interface_id;

Line 121: asn_debug.put_line('Updating RTI INTERFACE_TRANSACTION_ID=' || p_rti_row.interface_transaction_id);

117: PROCEDURE update_rti_row(
118: p_rti_row IN rcv_transactions_interface%ROWTYPE
119: ) IS
120: BEGIN
121: asn_debug.put_line('Updating RTI INTERFACE_TRANSACTION_ID=' || p_rti_row.interface_transaction_id);
122:
123: UPDATE rcv_transactions_interface
124: SET ROW = p_rti_row
125: WHERE interface_transaction_id = p_rti_row.interface_transaction_id

Line 208: asn_debug.put_line('too many rows in get_rsh_row_from_num(' || p_shipment_num || ',' || p_vendor_id || ');');

204: RETURN NULL;
205: END IF;
206: WHEN TOO_MANY_ROWS THEN
207: IF (g_debug_flag = 'Y') THEN
208: asn_debug.put_line('too many rows in get_rsh_row_from_num(' || p_shipment_num || ',' || p_vendor_id || ');');
209: END IF;
210:
211: RETURN NULL;
212: END get_rsh_row_from_num;

Line 269: asn_debug.put_line('too many rows in get_rsl_row_from_num(' || p_line_num || ',' || p_shipment_header_id || ');');

265: WHEN NO_DATA_FOUND THEN
266: invalid_value(p_line_num, 'LINE_NUM');
267: WHEN TOO_MANY_ROWS THEN
268: IF (g_debug_flag = 'Y') THEN
269: asn_debug.put_line('too many rows in get_rsl_row_from_num(' || p_line_num || ',' || p_shipment_header_id || ');');
270: END IF;
271:
272: RETURN NULL;
273: END get_rsl_row_from_num;

Line 303: asn_debug.put_line('Updating RSL SHIPMENT_LINE_ID=' || p_rsl_row.shipment_line_id);

299: PROCEDURE update_rsl_row(
300: p_rsl_row IN rcv_shipment_lines%ROWTYPE
301: ) IS
302: BEGIN
303: asn_debug.put_line('Updating RSL SHIPMENT_LINE_ID=' || p_rsl_row.shipment_line_id);
304:
305: UPDATE rcv_shipment_lines
306: SET ROW = p_rsl_row
307: WHERE shipment_line_id = p_rsl_row.shipment_line_id;

Line 356: asn_debug.put_line('too many rows in get_poh_row_from_num(' || p_po_num || ',' || p_org_id || ');');

352: WHEN NO_DATA_FOUND THEN
353: invalid_value(p_po_num, 'PO_HEADER_NUM');
354: WHEN TOO_MANY_ROWS THEN
355: IF (g_debug_flag = 'Y') THEN
356: asn_debug.put_line('too many rows in get_poh_row_from_num(' || p_po_num || ',' || p_org_id || ');');
357: END IF;
358:
359: RETURN NULL;
360: END;

Line 379: asn_debug.put_line('too many rows in get_poh_row_from_num(' || p_po_num || ',' || p_org_id || ');');

375: END;
376: END IF;
377:
378: IF (g_debug_flag = 'Y') THEN
379: asn_debug.put_line('too many rows in get_poh_row_from_num(' || p_po_num || ',' || p_org_id || ');');
380: END IF;
381:
382: RETURN NULL;
383: END get_poh_row_from_num;

Line 506: asn_debug.put_line('too many rows in get_pol_row_from_num(' || p_line_num || ',' || p_header_id || ');');

502: WHEN NO_DATA_FOUND THEN
503: invalid_value(p_line_num, 'PO_LINE_NUM');
504: WHEN TOO_MANY_ROWS THEN
505: IF (g_debug_flag = 'Y') THEN
506: asn_debug.put_line('too many rows in get_pol_row_from_num(' || p_line_num || ',' || p_header_id || ');');
507: END IF;
508:
509: RETURN NULL;
510: END;

Line 513: asn_debug.put_line('too many rows in get_pol_row_from_num(' || p_line_num || ',' || p_header_id || ');');

509: RETURN NULL;
510: END;
511: WHEN TOO_MANY_ROWS THEN
512: IF (g_debug_flag = 'Y') THEN
513: asn_debug.put_line('too many rows in get_pol_row_from_num(' || p_line_num || ',' || p_header_id || ');');
514: END IF;
515:
516: RETURN NULL;
517: END get_pol_row_from_num;

Line 587: asn_debug.put_line('too many rows in get_pll_row_from_num(' || p_shipment_num || ',' || p_line_id || ');');

583: WHEN NO_DATA_FOUND THEN
584: invalid_value(p_shipment_num, 'PO_LINE_LOCATION_NUM');
585: WHEN TOO_MANY_ROWS THEN
586: IF (g_debug_flag = 'Y') THEN
587: asn_debug.put_line('too many rows in get_pll_row_from_num(' || p_shipment_num || ',' || p_line_id || ');');
588: END IF;
589:
590: RETURN NULL;
591: END;

Line 594: asn_debug.put_line('too many rows in get_pll_row_from_num(' || p_shipment_num || ',' || p_line_id || ');');

590: RETURN NULL;
591: END;
592: WHEN TOO_MANY_ROWS THEN
593: IF (g_debug_flag = 'Y') THEN
594: asn_debug.put_line('too many rows in get_pll_row_from_num(' || p_shipment_num || ',' || p_line_id || ');');
595: END IF;
596:
597: RETURN NULL;
598: END get_pll_row_from_num;

Line 668: asn_debug.put_line('too many rows in get_pod_row_from_num(' || p_distribution_num || ',' || p_line_location_id || ');');

664: WHEN NO_DATA_FOUND THEN
665: invalid_value(p_distribution_num, 'PO_DISTRIBUTION_NUM');
666: WHEN TOO_MANY_ROWS THEN
667: IF (g_debug_flag = 'Y') THEN
668: asn_debug.put_line('too many rows in get_pod_row_from_num(' || p_distribution_num || ',' || p_line_location_id || ');');
669: END IF;
670:
671: RETURN NULL;
672: END;

Line 675: asn_debug.put_line('too many rows in get_pod_row_from_num(' || p_distribution_num || ',' || p_line_location_id || ');');

671: RETURN NULL;
672: END;
673: WHEN TOO_MANY_ROWS THEN
674: IF (g_debug_flag = 'Y') THEN
675: asn_debug.put_line('too many rows in get_pod_row_from_num(' || p_distribution_num || ',' || p_line_location_id || ');');
676: END IF;
677:
678: RETURN NULL;
679: END get_pod_row_from_num;

Line 763: asn_debug.put_line('too many rows in get_oeh_row_from_num(' || p_order_number || ',' || p_order_type_id || ');');

759: WHEN NO_DATA_FOUND THEN
760: invalid_value(p_order_number, 'OE_ORDER_HEADER_NUM');
761: WHEN TOO_MANY_ROWS THEN
762: IF (g_debug_flag = 'Y') THEN
763: asn_debug.put_line('too many rows in get_oeh_row_from_num(' || p_order_number || ',' || p_order_type_id || ');');
764: END IF;
765:
766: RETURN NULL;
767: END;

Line 789: asn_debug.put_line('too many rows in get_oeh_row_from_num(' || p_order_number || ',' || p_order_type_id || ');');

785: END;
786: END IF;
787:
788: IF (g_debug_flag = 'Y') THEN
789: asn_debug.put_line('too many rows in get_oeh_row_from_num(' || p_order_number || ',' || p_order_type_id || ');');
790: END IF;
791:
792: RETURN NULL;
793: END get_oeh_row_from_num;

Line 865: asn_debug.put_line('too many rows in get_oel_row_from_num(' || p_line_number || ',' || p_header_id || ');');

861: WHEN NO_DATA_FOUND THEN
862: invalid_value(p_line_number, 'OE_ORDER_LINE_NUM');
863: WHEN TOO_MANY_ROWS THEN
864: IF (g_debug_flag = 'Y') THEN
865: asn_debug.put_line('too many rows in get_oel_row_from_num(' || p_line_number || ',' || p_header_id || ');');
866: END IF;
867:
868: RETURN NULL;
869: END;

Line 872: asn_debug.put_line('too many rows in get_oel_row_from_num(' || p_line_number || ',' || p_header_id || ');');

868: RETURN NULL;
869: END;
870: WHEN TOO_MANY_ROWS THEN
871: IF (g_debug_flag = 'Y') THEN
872: asn_debug.put_line('too many rows in get_oel_row_from_num(' || p_line_number || ',' || p_header_id || ');');
873: END IF;
874:
875: RETURN NULL;
876: END get_oel_row_from_num;