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 3: g_debug_flag CONSTANT VARCHAR2(1) := asn_debug.is_debug_on; -- Bug 9152790

1: PACKAGE BODY rcv_table_functions AS
2: /* $Header: RCVTBFNB.pls 120.11.12020000.2 2012/07/10 09:28:38 ptkumar ship $*/
3: g_debug_flag CONSTANT VARCHAR2(1) := asn_debug.is_debug_on; -- Bug 9152790
4: g_rhi_row rcv_headers_interface%ROWTYPE;
5: g_rti_row rcv_transactions_interface%ROWTYPE;
6: g_rt_row rcv_transactions%ROWTYPE;
7: g_rsh_row rcv_shipment_headers%ROWTYPE;

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 211: asn_debug.put_line('too many rows in get_rsh_row_from_num(' || p_shipment_num || ',' || p_vendor_id || ');');

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

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

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

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

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

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

361: WHEN NO_DATA_FOUND THEN
362: invalid_value(p_po_num, 'PO_HEADER_NUM');
363: WHEN TOO_MANY_ROWS THEN
364: IF (g_debug_flag = 'Y') THEN
365: asn_debug.put_line('too many rows in get_poh_row_from_num(' || p_po_num || ',' || p_org_id || ');');
366: END IF;
367:
368: RETURN NULL;
369: END;

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

387: END;
388: END IF;
389:
390: IF (g_debug_flag = 'Y') THEN
391: asn_debug.put_line('too many rows in get_poh_row_from_num(' || p_po_num || ',' || p_org_id || ');');
392: END IF;
393:
394: RETURN NULL;
395: END get_poh_row_from_num;

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

514: WHEN NO_DATA_FOUND THEN
515: invalid_value(p_line_num, 'PO_LINE_NUM');
516: WHEN TOO_MANY_ROWS THEN
517: IF (g_debug_flag = 'Y') THEN
518: asn_debug.put_line('too many rows in get_pol_row_from_num(' || p_line_num || ',' || p_header_id || ');');
519: END IF;
520:
521: /*Bug 12618848 Do not error out the RTI if it fetches more than one PO line.
522: In preprocessor, it will be decided*/

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

526: /*End of Bug 12618848 */
527: END;
528: WHEN TOO_MANY_ROWS THEN
529: IF (g_debug_flag = 'Y') THEN
530: asn_debug.put_line('too many rows in get_pol_row_from_num(' || p_line_num || ',' || p_header_id || ');');
531: END IF;
532:
533: /*Bug 12618848 Do not error out the RTI if it fetches more than one PO line.
534: In preprocessor, it will be decided*/

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

606: WHEN NO_DATA_FOUND THEN
607: invalid_value(p_shipment_num, 'PO_LINE_LOCATION_NUM');
608: WHEN TOO_MANY_ROWS THEN
609: IF (g_debug_flag = 'Y') THEN
610: asn_debug.put_line('too many rows in get_pll_row_from_num(' || p_shipment_num || ',' || p_line_id || ');');
611: END IF;
612:
613: g_pll_row := NULL; -- bug#12568219 null out g_pll_row otherwise it will be populated with value even for TOO_MANY_ROWS exception.
614:

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

615: RETURN NULL;
616: END;
617: WHEN TOO_MANY_ROWS THEN
618: IF (g_debug_flag = 'Y') THEN
619: asn_debug.put_line('too many rows in get_pll_row_from_num(' || p_shipment_num || ',' || p_line_id || ');');
620: END IF;
621:
622: g_pll_row := NULL; -- bug#12568219 null out g_pll_row otherwise it will be populated with value even for TOO_MANY_ROWS exception.
623:

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

691: WHEN NO_DATA_FOUND THEN
692: invalid_value(p_distribution_num, 'PO_DISTRIBUTION_NUM');
693: WHEN TOO_MANY_ROWS THEN
694: IF (g_debug_flag = 'Y') THEN
695: asn_debug.put_line('too many rows in get_pod_row_from_num(' || p_distribution_num || ',' || p_line_location_id || ');');
696: END IF;
697:
698: RETURN NULL;
699: END;

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

698: RETURN NULL;
699: END;
700: WHEN TOO_MANY_ROWS THEN
701: IF (g_debug_flag = 'Y') THEN
702: asn_debug.put_line('too many rows in get_pod_row_from_num(' || p_distribution_num || ',' || p_line_location_id || ');');
703: END IF;
704:
705: RETURN NULL;
706: END get_pod_row_from_num;

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

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

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

812: END;
813: END IF;
814:
815: IF (g_debug_flag = 'Y') THEN
816: asn_debug.put_line('too many rows in get_oeh_row_from_num(' || p_order_number || ',' || p_order_type_id || ');');
817: END IF;
818:
819: RETURN NULL;
820: END get_oeh_row_from_num;

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

888: WHEN NO_DATA_FOUND THEN
889: invalid_value(p_line_number, 'OE_ORDER_LINE_NUM');
890: WHEN TOO_MANY_ROWS THEN
891: IF (g_debug_flag = 'Y') THEN
892: asn_debug.put_line('too many rows in get_oel_row_from_num(' || p_line_number || ',' || p_header_id || ');');
893: END IF;
894:
895: RETURN NULL;
896: END;

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

895: RETURN NULL;
896: END;
897: WHEN TOO_MANY_ROWS THEN
898: IF (g_debug_flag = 'Y') THEN
899: asn_debug.put_line('too many rows in get_oel_row_from_num(' || p_line_number || ',' || p_header_id || ');');
900: END IF;
901:
902: RETURN NULL;
903: END get_oel_row_from_num;