+---------------------------------------------------------------------------+ Oracle Shipping: Version : 11.5.0 - Development Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved. WSHINTERFACES module: Interface Trip Stop - SRS +---------------------------------------------------------------------------+ Current system time is 19-JUN-2008 15:35:51 +---------------------------------------------------------------------------+ **Starts**19-JUN-2008 15:35:52 **Ends**19-JUN-2008 15:35:57 Interface trip stop is completed successfully +---------------------------------------------------------------------------+ Start of log messages from Plsql program +---------------------------------------------------------------------------+ InterfaceTripStop: finding stop for delivery_id 23085 InterfaceTripStop: processing stop_id 24301 for INV OM DSNO ======================================================================== OM Interfacing trip_stop_id 24301 No orders need to be interfaced to OM for 24301 InterfaceTripStop: result of OM interfacing stop_id 24301 = INTERFACED ------------------------------------------------------------------------ Number of rows updated as interfaced to Inventory = 0 NEW TRANSACTION_HEADER : 5453022 Get delivery detail 12573, inv_interfaced_flag: N Not Assigned to a container LPN id is Null for the Parent Container of Line 23085 Found MTL order line: 733 Not an internal order Calling OE_FLEX_COGS_PUB.START_PROCESS to get the cogs account no. of OE messages :1 Return Status from OE_FLEX_COGS_PUB.START_PROCESS is E Concat_Segs is 01-701-402001-030-000 Concat_IDs is Concat_Descrs is Error msg: Cost Of Goods Sold Account Generation Failed with error : Please choo se an existing combination. Unable to get account Get delivery detail 12574, inv_interfaced_flag: N Not Assigned to a container LPN id is Null for the Parent Container of Line 23085 Found MTL order line: 733 Not an internal order Calling OE_FLEX_COGS_PUB.START_PROCESS to get the cogs account no. of OE messages :2 Return Status from OE_FLEX_COGS_PUB.START_PROCESS is E Concat_Segs is 01-701-402001-010-000 Concat_IDs is Concat_Descrs is Error msg: Cost Of Goods Sold Account Generation Failed with error : Please choo se an existing combination. Error msg: Cost Of Goods Sold Account Generation Failed with error : Please choo se an existing combination. Unable to get account Get delivery detail 12576, inv_interfaced_flag: N Not Assigned to a container LPN id is Null for the Parent Container of Line 23085 Found MTL order line: 733 Not an internal order Calling OE_FLEX_COGS_PUB.START_PROCESS to get the cogs account no. of OE messages :3 Return Status from OE_FLEX_COGS_PUB.START_PROCESS is E Concat_Segs is 01-701-402001-790-000 Concat_IDs is Concat_Descrs is Error msg: Cost Of Goods Sold Account Generation Failed with error : Please choo se an existing combination. Error msg: Cost Of Goods Sold Account Generation Failed with error : Please choo se an existing combination. Error msg: Cost Of Goods Sold Account Generation Failed with error : Please choo se an existing combination. Unable to get account Get delivery detail 12578, inv_interfaced_flag: N Not Assigned to a container LPN id is Null for the Parent Container of Line 23085 Found MTL order line: 733 Not an internal order Calling OE_FLEX_COGS_PUB.START_PROCESS to get the cogs account no. of OE messages :4 Return Status from OE_FLEX_COGS_PUB.START_PROCESS is E Concat_Segs is 01-701-402001-760-000 Concat_IDs is Concat_Descrs is Error msg: Cost Of Goods Sold Account Generation Failed with error : Please choo se an existing combination. Error msg: Cost Of Goods Sold Account Generation Failed with error : Please choo se an existing combination. Error msg: Cost Of Goods Sold Account Generation Failed with error : Please choo se an existing combination. Error msg: Cost Of Goods Sold Account Generation Failed with error : Please choo se an existing combination. Unable to get account Get delivery detail 12586, inv_interfaced_flag: N Not Assigned to a container LPN id is Null for the Parent Container of Line 23085 Found MTL order line: 733 Not an internal order Calling OE_FLEX_COGS_PUB.START_PROCESS to get the cogs account no. of OE messages :5 Return Status from OE_FLEX_COGS_PUB.START_PROCESS is E Concat_Segs is 01-701-402001-760-000 Concat_IDs is Concat_Descrs is Error msg: Cost Of Goods Sold Account Generation Failed with error : Please choo se an existing combination. Error msg: Cost Of Goods Sold Account Generation Failed with error : Please choo se an existing combination. Error msg: Cost Of Goods Sold Account Generation Failed with error : Please choo se an existing combination. Error msg: Cost Of Goods Sold Account Generation Failed with error : Please choo se an existing combination. Error msg: Cost Of Goods Sold Account Generation Failed with error : Please choo se an existing combination. Unable to get account Current Time: 19-JUN-2008 15:47:53 Right before calling MTL_ONLINE_TRANSACTION_PUB.process_online Current Time: 19-JUN-2008 15:47:53 ******** New Session.:19-JUN-08:03.47.54 ********** INV_TXN_MANAGER_PUB: -----Inside process_Transactions-------.trxhdr=5453022 INV_TXN_MANAGER_PUB: *** SQL error ORA-01403: no data found INVONL: Error1 from process_online Current Time: 19-JUN-2008 15:47:54 Right after calling MTL_ONLINE_TRANSACTION_PUB.process_online Number of rows updated as interfaced to Inventory = 0 InterfaceTripStop: result of INVENTORY interfacing stop_id 24301 = NORMAL ======================================================================== InterfaceTripStop: total stops processed: 1 Stops processed for ORDER MANAGEMENT with status NORMAL: 0 Stops processed for ORDER MANAGEMENT with status WARNING: 0 Stops already interfaced for ORDER MANAGEMENT: 1 Stops processed for INVENTORY with status NORMAL: 1 Stops processed for INVENTORY with status WARNING: 0 Stops already interfaced for INVENTORY: 0 +---------------------------------------------------------------------------+ End of log messages from PlSql program +---------------------------------------------------------------------------+ +---------------------------------------------------------------------------+ Executing request completion options... Printing output file. Request ID : 1133003 Number of copies : 0 Printer : noprint Finished executing request completion options. +---------------------------------------------------------------------------+ Concurrent request completed successfully Current system time is 19-JUN-2008 15:35:57 +---------------------------------------------------------------------------+