APPS.OE_INF_POPULATE_PUB dependencies on OE_LOTSERIALS_IFACE_ALL

Line 1905: oe_debug_pub.add( 'OEXPIFPB: BEFORE INSERT TO OE_LOTSERIALS_IFACE_ALL' ) ;

1901: END IF;
1902: END IF;
1903:
1904: IF l_debug_level > 0 THEN
1905: oe_debug_pub.add( 'OEXPIFPB: BEFORE INSERT TO OE_LOTSERIALS_IFACE_ALL' ) ;
1906: END IF;
1907:
1908: /* Line Level Lots Serial */
1909: INSERT INTO OE_LOTSERIALS_IFACE_ALL (

Line 1909: INSERT INTO OE_LOTSERIALS_IFACE_ALL (

1905: oe_debug_pub.add( 'OEXPIFPB: BEFORE INSERT TO OE_LOTSERIALS_IFACE_ALL' ) ;
1906: END IF;
1907:
1908: /* Line Level Lots Serial */
1909: INSERT INTO OE_LOTSERIALS_IFACE_ALL (
1910: ORIG_SYS_LINE_REF /*VARCHAR2(50)*/
1911: , ORIG_SYS_SHIPMENT_REF /*VARCHAR2(50)*/
1912: , ORIG_SYS_LOTSERIAL_REF /*VARCHAR2(50)*/
1913: , CHANGE_SEQUENCE /*VARCHAR2(50)*/

Line 2006: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_LOTSERIALS_IFACE_ALL FOR LINES' ) ;

2002: where header_id = old_header_id_v);
2003:
2004: IF SQL%ROWCOUNT > 0 THEN
2005: IF l_debug_level > 0 THEN
2006: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_LOTSERIALS_IFACE_ALL FOR LINES' ) ;
2007: END IF;
2008: ELSE
2009: IF l_debug_level > 0 THEN
2010: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_LOTSERIALS_IFACE_ALL FOR LINES' ) ;

Line 2010: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_LOTSERIALS_IFACE_ALL FOR LINES' ) ;

2006: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_LOTSERIALS_IFACE_ALL FOR LINES' ) ;
2007: END IF;
2008: ELSE
2009: IF l_debug_level > 0 THEN
2010: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_LOTSERIALS_IFACE_ALL FOR LINES' ) ;
2011: END IF;
2012: END IF;
2013:
2014: IF l_debug_level > 0 THEN