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.OE_INF_POPULATE_PUB dependencies on OE_LINES_IFACE_ALL

Line 527: oe_debug_pub.add( 'OEXPIFPB: BEFORE INSERT TO OE_LINES_IFACE_ALL' ) ;

523: return;
524: END IF;
525:
526: IF l_debug_level > 0 THEN
527: oe_debug_pub.add( 'OEXPIFPB: BEFORE INSERT TO OE_LINES_IFACE_ALL' ) ;
528: END IF;
529:
530: INSERT INTO oe_lines_iface_all (
531: order_source_id /* number */

Line 530: INSERT INTO oe_lines_iface_all (

526: IF l_debug_level > 0 THEN
527: oe_debug_pub.add( 'OEXPIFPB: BEFORE INSERT TO OE_LINES_IFACE_ALL' ) ;
528: END IF;
529:
530: INSERT INTO oe_lines_iface_all (
531: order_source_id /* number */
532: , orig_sys_document_ref /* varchar2(50) */
533: , orig_sys_line_ref /* varchar2(50) */
534: , orig_sys_shipment_ref /* varchar2(50) */

Line 1156: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_LINES_IFACE_ALL' ) ;

1152: where header_id = old_header_id_v;
1153:
1154: IF SQL%ROWCOUNT > 0 THEN
1155: IF l_debug_level > 0 THEN
1156: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_LINES_IFACE_ALL' ) ;
1157: END IF;
1158: ELSE
1159: IF l_debug_level > 0 THEN
1160: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_LINES_IFACE_ALL' ) ;

Line 1160: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_LINES_IFACE_ALL' ) ;

1156: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_LINES_IFACE_ALL' ) ;
1157: END IF;
1158: ELSE
1159: IF l_debug_level > 0 THEN
1160: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_LINES_IFACE_ALL' ) ;
1161: END IF;
1162: END IF;
1163:
1164: IF l_debug_level > 0 THEN

Line 2015: oe_debug_pub.add( 'OEXPIFPB: BEFORE UPDATE OE_LINES_IFACE_ALL' ) ;

2011: END IF;
2012: END IF;
2013:
2014: IF l_debug_level > 0 THEN
2015: oe_debug_pub.add( 'OEXPIFPB: BEFORE UPDATE OE_LINES_IFACE_ALL' ) ;
2016: END IF;
2017: update oe_lines_iface_all
2018: set line_id = ''
2019: where orig_sys_document_ref = to_char(order_number_v);

Line 2017: update oe_lines_iface_all

2013:
2014: IF l_debug_level > 0 THEN
2015: oe_debug_pub.add( 'OEXPIFPB: BEFORE UPDATE OE_LINES_IFACE_ALL' ) ;
2016: END IF;
2017: update oe_lines_iface_all
2018: set line_id = ''
2019: where orig_sys_document_ref = to_char(order_number_v);
2020:
2021: IF SQL%ROWCOUNT > 0 THEN

Line 2023: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL UPDATE OF OE_LINES_IFACE_ALL' ) ;

2019: where orig_sys_document_ref = to_char(order_number_v);
2020:
2021: IF SQL%ROWCOUNT > 0 THEN
2022: IF l_debug_level > 0 THEN
2023: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL UPDATE OF OE_LINES_IFACE_ALL' ) ;
2024: END IF;
2025: ELSE
2026: IF l_debug_level > 0 THEN
2027: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL UPDATE OF OE_LINES_IFACE_ALL' ) ;

Line 2027: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL UPDATE OF OE_LINES_IFACE_ALL' ) ;

2023: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL UPDATE OF OE_LINES_IFACE_ALL' ) ;
2024: END IF;
2025: ELSE
2026: IF l_debug_level > 0 THEN
2027: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL UPDATE OF OE_LINES_IFACE_ALL' ) ;
2028: END IF;
2029: END IF;
2030:
2031: END IF;

Line 2176: FROM oe_lines_iface_all

2172: END IF;
2173:
2174: SELECT orig_sys_line_ref
2175: INTO l_orig_sys_line_ref
2176: FROM oe_lines_iface_all
2177: WHERE line_id = p_line_id;
2178:
2179: IF l_debug_level > 0 THEN
2180: oe_debug_pub.add( 'OEXPIFPB: BEFORE RETURN LINE REF' ) ;