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.WSH_USA_ACTIONS_PVT dependencies on WSH_INTERFACE

Line 12: p_changed_attributes IN WSH_INTERFACE.ChangedAttributeTabType,

8: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_USA_ACTIONS_PVT';
9: --
10: PROCEDURE Import_Records(
11: p_source_code IN VARCHAR2,
12: p_changed_attributes IN WSH_INTERFACE.ChangedAttributeTabType,
13: x_return_status OUT NOCOPY VARCHAR2)
14: IS
15: l_counter NUMBER;
16: l_rs VARCHAR2(1);

Line 312: p_changed_attributes IN WSH_INTERFACE.ChangedAttributeTabType,

308: --
309:
310: PROCEDURE Split_Records_Int (
311: p_source_code IN VARCHAR2,
312: p_changed_attributes IN WSH_INTERFACE.ChangedAttributeTabType,
313: p_interface_flag IN VARCHAR2,
314: p_index_tab IN WSH_UTIL_CORE.ID_Tab_Type ,
315: p_split_lines IN WSH_USA_ACTIONS_PVT.split_Table_Tab_type ,
316: x_return_status OUT NOCOPY VARCHAR2

Line 1711: WSH_INTERFACE.Delete_Details(

1707: --
1708: -- purge delivery details pending overpick
1709: IF l_rs NOT IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1710: AND l_delete_dds.count > 0 THEN
1711: WSH_INTERFACE.Delete_Details(
1712: p_details_id => l_delete_dds,
1713: x_return_status => l_rs
1714: );
1715: END IF;

Line 1743: p_changed_attributes IN WSH_INTERFACE.ChangedAttributeTabType,

1739: END Split_Records_Int;
1740:
1741: PROCEDURE Split_Records (
1742: p_source_code IN VARCHAR2,
1743: p_changed_attributes IN WSH_INTERFACE.ChangedAttributeTabType,
1744: p_interface_flag IN VARCHAR2,
1745: x_return_status OUT NOCOPY VARCHAR2
1746: ) IS
1747: l_index number ;

Line 1916: p_changed_attributes IN WSH_INTERFACE.ChangedAttributeTabType,

1912: END split_Records ;
1913:
1914: PROCEDURE Update_Records(
1915: p_source_code IN VARCHAR2,
1916: p_changed_attributes IN WSH_INTERFACE.ChangedAttributeTabType,
1917: p_interface_flag IN VARCHAR2,
1918: x_return_status OUT NOCOPY VARCHAR2)
1919: IS
1920: l_counter NUMBER;

Line 2031: p_attributes_rec IN WSH_INTERFACE.ChangedAttributeRecType,

2027:
2028:
2029: Procedure Update_Attributes(
2030: p_source_code IN VARCHAR2,
2031: p_attributes_rec IN WSH_INTERFACE.ChangedAttributeRecType,
2032: p_changed_detail IN WSH_USA_CATEGORIES_PVT.ChangedDetailRec,
2033: p_interface_flag IN VARCHAR2 , --bugfix 10175902
2034: x_return_status OUT NOCOPY VARCHAR2)
2035: IS

Line 3055: WSH_INTERFACE.PrintMsg(name=>'WSH_CALC_CONT_DEL_TPDATES',

3051: p_entity_ids => l_tp_details,
3052: x_return_status => l_return_status);
3053: -- }
3054: IF (l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS, WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
3055: WSH_INTERFACE.PrintMsg(name=>'WSH_CALC_CONT_DEL_TPDATES',
3056: txt=>'Error in calculating Container/Delivery TP dates ');
3057: IF l_debug_on THEN
3058: WSH_DEBUG_SV.log(l_module_name,'Error in calculating Container/Delivery TP dates ');
3059: END IF;

Line 3611: WSH_INTERFACE.PrintMsg(txt=>'Importing order line ' || ln_rec_info.line_id);

3607: OPEN c_specific_item_info(ln_rec_info.inventory_item_id, ln_rec_info.ship_from_org_id);
3608: FETCH C_SPECIFIC_ITEM_INFO INTO haz_class_id, prim_uom_code, weight_uom, unit_weight,
3609: volume_uom, unit_volume, transactable_flag;
3610: CLOSE c_specific_item_info;
3611: WSH_INTERFACE.PrintMsg(txt=>'Importing order line ' || ln_rec_info.line_id);
3612: WSH_UTIL_CORE.GET_LOCATION_ID('ORG', ln_rec_info.ship_from_org_id,
3613: l_ship_from_location_id, l_location_status);
3614:
3615: IF (l_location_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

Line 3622: WSH_INTERFACE.PrintMsg(txt=>'From organization:'|| ln_rec_info.ship_from_org_id||' loc:'|| l_ship_from_location_id );

3618: END IF;
3619: l_booked_ln_excpn := TRUE;
3620: GOTO start_over;
3621: END IF;
3622: WSH_INTERFACE.PrintMsg(txt=>'From organization:'|| ln_rec_info.ship_from_org_id||' loc:'|| l_ship_from_location_id );
3623:
3624: WSH_UTIL_CORE.GET_LOCATION_ID('CUSTOMER SITE', ln_rec_info.ship_to_org_id,
3625: l_ship_to_location_id, l_location_status);
3626: IF (l_location_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

Line 3627: WSH_INTERFACE.PrintMsg(name=>'WSH_DET_NO_LOCATION_FOR_ORG',

3623:
3624: WSH_UTIL_CORE.GET_LOCATION_ID('CUSTOMER SITE', ln_rec_info.ship_to_org_id,
3625: l_ship_to_location_id, l_location_status);
3626: IF (l_location_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
3627: WSH_INTERFACE.PrintMsg(name=>'WSH_DET_NO_LOCATION_FOR_ORG',
3628: txt=>'Failed to get location for line: '||ln_rec_info.line_id||
3629: ' ship to org:'||ln_rec_info.ship_to_org_id);
3630: IF l_debug_on THEN
3631: WSH_DEBUG_SV.log(l_module_name,'Failed to get location for line: '||ln_rec_info.line_id|| ' ship to org:'||ln_rec_info.ship_to_org_id);

Line 3636: WSH_INTERFACE.PrintMsg(txt=>'To organization:'|| ln_rec_info.ship_to_org_id||' loc:'|| l_ship_to_location_id );

3632: END IF;
3633: l_booked_ln_excpn := TRUE;
3634: GOTO start_over;
3635: END IF;
3636: WSH_INTERFACE.PrintMsg(txt=>'To organization:'|| ln_rec_info.ship_to_org_id||' loc:'|| l_ship_to_location_id );
3637:
3638: IF (ln_rec_info.deliver_to_org_id IS NOT NULL) THEN
3639: WSH_UTIL_CORE.GET_LOCATION_ID('CUSTOMER SITE', ln_rec_info.deliver_to_org_id,
3640: l_deliver_to_location_id, l_location_status);

Line 3642: WSH_INTERFACE.PrintMsg(name=>'WSH_DET_NO_LOCATION_FOR_ORG',

3638: IF (ln_rec_info.deliver_to_org_id IS NOT NULL) THEN
3639: WSH_UTIL_CORE.GET_LOCATION_ID('CUSTOMER SITE', ln_rec_info.deliver_to_org_id,
3640: l_deliver_to_location_id, l_location_status);
3641: IF (l_location_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
3642: WSH_INTERFACE.PrintMsg(name=>'WSH_DET_NO_LOCATION_FOR_ORG',
3643: txt=> 'Failed to get location for line: '||ln_rec_info.line_id||
3644: ' delivery to org:'||ln_rec_info.deliver_to_org_id);
3645: IF l_debug_on THEN
3646: WSH_DEBUG_SV.log(l_module_name,'Failed to get location for line: '||ln_rec_info.line_id||' delivery to org:'||ln_rec_info.deliver_to_org_id);

Line 3652: WSH_INTERFACE.PrintMsg(txt=>'Deliver to org:'|| ln_rec_info.deliver_to_org_id||' loc:'|| l_deliver_to_location_id );

3648: l_booked_ln_excpn := TRUE;
3649: GOTO start_over;
3650: END IF;
3651: END IF;
3652: WSH_INTERFACE.PrintMsg(txt=>'Deliver to org:'|| ln_rec_info.deliver_to_org_id||' loc:'|| l_deliver_to_location_id );
3653:
3654: IF (ln_rec_info.intmed_ship_to_org_id IS NOT NULL) THEN
3655: WSH_UTIL_CORE.GET_LOCATION_ID('CUSTOMER SITE', ln_rec_info.intmed_ship_to_org_id,
3656: l_intmed_ship_to_location_id, l_location_status);

Line 3658: WSH_INTERFACE.PrintMsg(name=>'WSH_DET_NO_LOCATION_FOR_ORG',

3654: IF (ln_rec_info.intmed_ship_to_org_id IS NOT NULL) THEN
3655: WSH_UTIL_CORE.GET_LOCATION_ID('CUSTOMER SITE', ln_rec_info.intmed_ship_to_org_id,
3656: l_intmed_ship_to_location_id, l_location_status);
3657: IF (l_location_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
3658: WSH_INTERFACE.PrintMsg(name=>'WSH_DET_NO_LOCATION_FOR_ORG',
3659: txt=> 'Failed to get location for line: '||ln_rec_info.line_id||
3660: ' intermediate ship to org:'||ln_rec_info.intmed_ship_to_org_id);
3661: IF l_debug_on THEN
3662: WSH_DEBUG_SV.log(l_module_name,'Failed to get location for line: '||ln_rec_info.line_id||' intermediate ship to org:'||ln_rec_info.intmed_ship_to_org_id);

Line 3668: WSH_INTERFACE.PrintMsg(txt=>'Intermediate ship to org:'|| ln_rec_info.intmed_ship_to_org_id||' loc:'|| l_intmed_ship_to_location_id );

3664: l_booked_ln_excpn := TRUE;
3665: GOTO start_over;
3666: END IF;
3667: END IF;
3668: WSH_INTERFACE.PrintMsg(txt=>'Intermediate ship to org:'|| ln_rec_info.intmed_ship_to_org_id||' loc:'|| l_intmed_ship_to_location_id );
3669:
3670: IF (l_deliver_to_location_id is NULL) THEN
3671: l_deliver_to_location_id := l_ship_to_location_id;
3672: END IF;

Line 3680: WSH_INTERFACE.PrintMsg(txt=>'Shipping Parameters notfound for warehouse:'||ln_rec_info.ship_from_org_id);

3676: IF ( c_shipping_parameters%NOTFOUND ) THEN
3677: IF l_debug_on THEN
3678: WSH_DEBUG_SV.log(l_module_name,'Shipping Parameters notfound for warehuse:'||ln_rec_info.ship_from_org_id);
3679: END IF;
3680: WSH_INTERFACE.PrintMsg(txt=>'Shipping Parameters notfound for warehouse:'||ln_rec_info.ship_from_org_id);
3681: END IF;
3682: CLOSE c_shipping_parameters;
3683:
3684: OPEN c_category_id(ln_rec_info.inventory_item_id,

Line 3689: WSH_INTERFACE.PrintMsg(txt=>'Freight Catergory id notfound for item:'||ln_rec_info.inventory_item_id||

3685: ln_rec_info.ship_from_org_id,
3686: l_ship_parameters.freight_class_cat_set_id);
3687: FETCH c_category_id INTO l_freight_cl_cat_id;
3688: IF (c_category_id%NOTFOUND) THEN
3689: WSH_INTERFACE.PrintMsg(txt=>'Freight Catergory id notfound for item:'||ln_rec_info.inventory_item_id||
3690: ' warehouse:'||ln_rec_info.ship_from_org_id ||
3691: ' freight_class:'||l_ship_parameters.freight_class_cat_set_id);
3692: END IF;
3693: CLOSE c_category_id;

Line 3700: WSH_INTERFACE.PrintMsg(txt=>'Commodity Catergory id notfound for item:'||ln_rec_info.inventory_item_id||

3696: ln_rec_info.ship_from_org_id,
3697: l_ship_parameters.commodity_code_cat_set_id);
3698: FETCH c_category_id INTO l_commodity_cat_id;
3699: IF (c_category_id%NOTFOUND) THEN
3700: WSH_INTERFACE.PrintMsg(txt=>'Commodity Catergory id notfound for item:'||ln_rec_info.inventory_item_id||
3701: ' warehouse:'||ln_rec_info.ship_from_org_id ||
3702: ' commodity_class:'||l_ship_parameters.commodity_code_cat_set_id);
3703: END IF;
3704: CLOSE c_category_id;

Line 3705: WSH_INTERFACE.PrintMsg(txt=>'frght_class_catg_id:'|| l_freight_cl_cat_id ||' commodity_class_ctg_id:'|| l_commodity_cat_id);

3701: ' warehouse:'||ln_rec_info.ship_from_org_id ||
3702: ' commodity_class:'||l_ship_parameters.commodity_code_cat_set_id);
3703: END IF;
3704: CLOSE c_category_id;
3705: WSH_INTERFACE.PrintMsg(txt=>'frght_class_catg_id:'|| l_freight_cl_cat_id ||' commodity_class_ctg_id:'|| l_commodity_cat_id);
3706:
3707:
3708: -- Check added for Standalone Project
3709: IF NVL(WMS_DEPLOY.Wms_Deployment_Mode,'I') <> 'D' THEN --{

Line 3728: WSH_INTERFACE.PrintMsg(name=>'WSH_CALC_TP_DATES',

3724: x_earliest_dropoff_date => l_delivery_details_info.earliest_dropoff_date,
3725: x_latest_dropoff_date => l_delivery_details_info.latest_dropoff_date
3726: );
3727: IF (l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS, WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
3728: WSH_INTERFACE.PrintMsg(name=>'WSH_CALC_TP_DATES',
3729: txt=>'Error in calculating TP dates: '||ln_rec_info.order_date_type_code||ln_rec_info.latest_acceptable_date||ln_rec_info.promise_date||ln_rec_info.schedule_arrival_date||ln_rec_info.earliest_acceptable_date||ln_rec_info.earliest_ship_date);
3730: IF l_debug_on THEN
3731: WSH_DEBUG_SV.log(l_module_name,'Error in calculating TP dates: ' ||
3732: ln_rec_info.order_date_type_code ||

Line 3779: WSH_INTERFACE.PrintMsg(txt=>'calling Convert uom=> order uom:'||ln_rec_info.order_quantity_uom||

3775: l_delivery_details_info.intmed_ship_to_location_id := l_intmed_ship_to_location_id;
3776: l_delivery_details_info.intmed_ship_to_contact_id := ln_rec_info.intmed_ship_to_contact_id;
3777: l_delivery_details_info.ship_tolerance_above := ln_rec_info.ship_tolerance_above;
3778: l_delivery_details_info.ship_tolerance_below := ln_rec_info.ship_tolerance_below;
3779: WSH_INTERFACE.PrintMsg(txt=>'calling Convert uom=> order uom:'||ln_rec_info.order_quantity_uom||
3780: ' order_qty:'||ln_rec_info.ordered_quantity || ' item_id:'|| ln_rec_info.inventory_item_id ||
3781: 'to uom:'||prim_uom_code);
3782:
3783: -- HW OPMCONV.

Line 3787: WSH_INTERFACE.PrintMsg(txt=>'Convert uom=> prim_uom:'||prim_uom_code);

3783: -- HW OPMCONV.
3784: l_delivery_details_info.requested_quantity := wsh_wv_utils.convert_uom(ln_rec_info.order_quantity_uom,
3785: prim_uom_code,ln_rec_info.ordered_quantity,
3786: ln_rec_info.inventory_item_id);
3787: WSH_INTERFACE.PrintMsg(txt=>'Convert uom=> prim_uom:'||prim_uom_code);
3788: l_delivery_details_info.requested_quantity_uom := prim_uom_code;
3789:
3790: -- odaboval : Begin of OPM Changes
3791: -- requested_quantities need to converted from apps primary uom code to

Line 3811: WSH_INTERFACE.PrintMsg(txt=>'Continuing to populate delivery_details_info record.');

3807: END IF;
3808: --
3809: l_delivery_details_info.cancelled_quantity2:= NULL;
3810: -- odaboval : End of OPM Changes
3811: WSH_INTERFACE.PrintMsg(txt=>'Continuing to populate delivery_details_info record.');
3812:
3813: l_delivery_details_info.customer_requested_lot_flag := NULL;
3814: l_delivery_details_info.date_requested := ln_rec_info.date_requested;
3815: l_delivery_details_info.date_scheduled := ln_rec_info.date_scheduled;

Line 3933: WSH_INTERFACE.PrintMsg(name=>'WSH_QTY_OR_UOM_NOT_VALID',

3929: l_delivery_details_info.wv_frozen_flag := 'N';
3930: l_delivery_details_info.request_date_type_code := ln_rec_info.order_date_type_code;
3931:
3932: IF (l_delivery_details_info.requested_quantity = 0) THEN
3933: WSH_INTERFACE.PrintMsg(name=>'WSH_QTY_OR_UOM_NOT_VALID',
3934: txt=>'Failed to import order line ' || ln_rec_info.line_id || ' because quantity uom or quantity is invalid');
3935: l_booked_ln_excpn := TRUE;
3936: GOTO start_over;
3937: END IF;

Line 3943: WSH_INTERFACE.PrintMsg(txt=> 'Source Line Set id -'||l_delivery_details_info.source_line_set_id);

3939: -- anxsharm Bug 2181132
3940: l_delivery_details_info.source_line_set_id := ln_rec_info.line_set_id;
3941:
3942: IF (l_delivery_details_info.source_line_set_id IS NOT NULL) THEN
3943: WSH_INTERFACE.PrintMsg(txt=> 'Source Line Set id -'||l_delivery_details_info.source_line_set_id);
3944: END IF;
3945: IF l_debug_on THEN
3946: WSH_DEBUG_SV.log(l_module_name,'Source Line Set id -'||l_delivery_details_info.source_line_set_id);
3947: END IF;

Line 3953: WSH_INTERFACE.PrintMsg(name=>'WSH_DET_CREATE_DET_FAILED',

3949: WSH_DELIVERY_DETAILS_PKG.Create_Delivery_Details( l_delivery_details_info, dummy_rowid,
3950: DUMMY_DELIVERY_DETAIL_ID,
3951: l_cr_dt_status );
3952: IF (l_cr_dt_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
3953: WSH_INTERFACE.PrintMsg(name=>'WSH_DET_CREATE_DET_FAILED',
3954: txt=>'Create_delivery_details failed for line: ' || ln_rec_info.line_id );
3955: WSH_UTIL_CORE.Get_Messages('N', l_cr_as_summary, l_cr_as_details, l_cr_as_count);
3956: WSH_INTERFACE.PrintMsg(txt=>'Creation of the delivery details failed because of ' || l_cr_as_summary || ':'|| l_cr_as_details);
3957: l_booked_ln_excpn := TRUE;

Line 3956: WSH_INTERFACE.PrintMsg(txt=>'Creation of the delivery details failed because of ' || l_cr_as_summary || ':'|| l_cr_as_details);

3952: IF (l_cr_dt_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
3953: WSH_INTERFACE.PrintMsg(name=>'WSH_DET_CREATE_DET_FAILED',
3954: txt=>'Create_delivery_details failed for line: ' || ln_rec_info.line_id );
3955: WSH_UTIL_CORE.Get_Messages('N', l_cr_as_summary, l_cr_as_details, l_cr_as_count);
3956: WSH_INTERFACE.PrintMsg(txt=>'Creation of the delivery details failed because of ' || l_cr_as_summary || ':'|| l_cr_as_details);
3957: l_booked_ln_excpn := TRUE;
3958: GOTO start_over;
3959: END IF;
3960: WSH_INTERFACE.PrintMsg(txt=>'Created dd:' || dummy_delivery_detail_id|| ' for line:'|| ln_rec_info.line_id );

Line 3960: WSH_INTERFACE.PrintMsg(txt=>'Created dd:' || dummy_delivery_detail_id|| ' for line:'|| ln_rec_info.line_id );

3956: WSH_INTERFACE.PrintMsg(txt=>'Creation of the delivery details failed because of ' || l_cr_as_summary || ':'|| l_cr_as_details);
3957: l_booked_ln_excpn := TRUE;
3958: GOTO start_over;
3959: END IF;
3960: WSH_INTERFACE.PrintMsg(txt=>'Created dd:' || dummy_delivery_detail_id|| ' for line:'|| ln_rec_info.line_id );
3961: IF DUMMY_DELIVERY_DETAIL_ID IS NOT NULL THEN
3962: IF latest_pickup_tpdate_excep IS NOT NULL THEN
3963: WSH_TP_RELEASE.log_tpdate_exception('LINE',dummy_delivery_detail_id,TRUE,l_delivery_details_info.earliest_pickup_date,latest_pickup_tpdate_excep);
3964: END IF;

Line 3975: WSH_INTERFACE.Default_Container(dummy_delivery_detail_id, l_return_status);

3971: -- HW OPMCONV. Removed code forking
3972:
3973: -- Call default container after create a new delivery detail to populate
3974: -- default container
3975: WSH_INTERFACE.Default_Container(dummy_delivery_detail_id, l_return_status);
3976: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
3977: WSH_INTERFACE.PrintMsg(txt=>'Default container failed for dd:'||dummy_delivery_detail_id);
3978: END IF;
3979:

Line 3977: WSH_INTERFACE.PrintMsg(txt=>'Default container failed for dd:'||dummy_delivery_detail_id);

3973: -- Call default container after create a new delivery detail to populate
3974: -- default container
3975: WSH_INTERFACE.Default_Container(dummy_delivery_detail_id, l_return_status);
3976: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
3977: WSH_INTERFACE.PrintMsg(txt=>'Default container failed for dd:'||dummy_delivery_detail_id);
3978: END IF;
3979:
3980: l_delivery_assignments_info.delivery_id := NULL;
3981: l_delivery_assignments_info.parent_delivery_id := NULL;

Line 3990: WSH_INTERFACE.PrintMsg(name=>'WSH_DET_CREATE_AS_FAILED',

3986: dummy_assgn_rowid,
3987: DUMMY_DELIVERY_ASSIGNMENT_ID,
3988: l_cr_as_status);
3989: IF (l_cr_as_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
3990: WSH_INTERFACE.PrintMsg(name=>'WSH_DET_CREATE_AS_FAILED',
3991: txt=>'Create Delivery assignments failed for order line:' || ln_rec_info.line_id);
3992: WSH_UTIL_CORE.Get_Messages('N', l_cr_as_summary, l_cr_as_details, l_cr_as_count);
3993: WSH_INTERFACE.PrintMsg(txt=>'Creation of the delivery assignments failed because of ' || l_cr_as_summary || ':'|| l_cr_as_details);
3994: l_booked_ln_excpn := TRUE;

Line 3993: WSH_INTERFACE.PrintMsg(txt=>'Creation of the delivery assignments failed because of ' || l_cr_as_summary || ':'|| l_cr_as_details);

3989: IF (l_cr_as_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
3990: WSH_INTERFACE.PrintMsg(name=>'WSH_DET_CREATE_AS_FAILED',
3991: txt=>'Create Delivery assignments failed for order line:' || ln_rec_info.line_id);
3992: WSH_UTIL_CORE.Get_Messages('N', l_cr_as_summary, l_cr_as_details, l_cr_as_count);
3993: WSH_INTERFACE.PrintMsg(txt=>'Creation of the delivery assignments failed because of ' || l_cr_as_summary || ':'|| l_cr_as_details);
3994: l_booked_ln_excpn := TRUE;
3995: GOTO start_over;
3996: END IF;
3997: WSH_INTERFACE.PrintMsg(txt=>'Created da:' || DUMMY_DELIVERY_ASSIGNMENT_ID|| ' for dd:'|| l_delivery_assignments_info.delivery_detail_id);

Line 3997: WSH_INTERFACE.PrintMsg(txt=>'Created da:' || DUMMY_DELIVERY_ASSIGNMENT_ID|| ' for dd:'|| l_delivery_assignments_info.delivery_detail_id);

3993: WSH_INTERFACE.PrintMsg(txt=>'Creation of the delivery assignments failed because of ' || l_cr_as_summary || ':'|| l_cr_as_details);
3994: l_booked_ln_excpn := TRUE;
3995: GOTO start_over;
3996: END IF;
3997: WSH_INTERFACE.PrintMsg(txt=>'Created da:' || DUMMY_DELIVERY_ASSIGNMENT_ID|| ' for dd:'|| l_delivery_assignments_info.delivery_detail_id);
3998:
3999: --OTM R12, calling delivery detail splitter
4000: IF (l_gc3_is_installed = 'Y') THEN
4001:

Line 4002: WSH_INTERFACE.PrintMsg(txt=>'Delivery Detail Splitter Data:');

3998:
3999: --OTM R12, calling delivery detail splitter
4000: IF (l_gc3_is_installed = 'Y') THEN
4001:
4002: WSH_INTERFACE.PrintMsg(txt=>'Delivery Detail Splitter Data:');
4003: WSH_INTERFACE.PrintMsg(txt=>'delivery detail id: '||dummy_delivery_detail_id);
4004: WSH_INTERFACE.PrintMsg(txt=>'inventory item id: '||l_delivery_details_info.inventory_item_id);
4005: WSH_INTERFACE.PrintMsg(txt=>'net weight: '|| l_delivery_details_info.net_weight);
4006: WSH_INTERFACE.PrintMsg(txt=>'organization id: '||l_delivery_details_info.organization_id);

Line 4003: WSH_INTERFACE.PrintMsg(txt=>'delivery detail id: '||dummy_delivery_detail_id);

3999: --OTM R12, calling delivery detail splitter
4000: IF (l_gc3_is_installed = 'Y') THEN
4001:
4002: WSH_INTERFACE.PrintMsg(txt=>'Delivery Detail Splitter Data:');
4003: WSH_INTERFACE.PrintMsg(txt=>'delivery detail id: '||dummy_delivery_detail_id);
4004: WSH_INTERFACE.PrintMsg(txt=>'inventory item id: '||l_delivery_details_info.inventory_item_id);
4005: WSH_INTERFACE.PrintMsg(txt=>'net weight: '|| l_delivery_details_info.net_weight);
4006: WSH_INTERFACE.PrintMsg(txt=>'organization id: '||l_delivery_details_info.organization_id);
4007: WSH_INTERFACE.PrintMsg(txt=>'weight uom code: '||l_delivery_details_info.weight_uom_code);

Line 4004: WSH_INTERFACE.PrintMsg(txt=>'inventory item id: '||l_delivery_details_info.inventory_item_id);

4000: IF (l_gc3_is_installed = 'Y') THEN
4001:
4002: WSH_INTERFACE.PrintMsg(txt=>'Delivery Detail Splitter Data:');
4003: WSH_INTERFACE.PrintMsg(txt=>'delivery detail id: '||dummy_delivery_detail_id);
4004: WSH_INTERFACE.PrintMsg(txt=>'inventory item id: '||l_delivery_details_info.inventory_item_id);
4005: WSH_INTERFACE.PrintMsg(txt=>'net weight: '|| l_delivery_details_info.net_weight);
4006: WSH_INTERFACE.PrintMsg(txt=>'organization id: '||l_delivery_details_info.organization_id);
4007: WSH_INTERFACE.PrintMsg(txt=>'weight uom code: '||l_delivery_details_info.weight_uom_code);
4008: WSH_INTERFACE.PrintMsg(txt=>'requested quantity: '||l_delivery_details_info.requested_quantity);

Line 4005: WSH_INTERFACE.PrintMsg(txt=>'net weight: '|| l_delivery_details_info.net_weight);

4001:
4002: WSH_INTERFACE.PrintMsg(txt=>'Delivery Detail Splitter Data:');
4003: WSH_INTERFACE.PrintMsg(txt=>'delivery detail id: '||dummy_delivery_detail_id);
4004: WSH_INTERFACE.PrintMsg(txt=>'inventory item id: '||l_delivery_details_info.inventory_item_id);
4005: WSH_INTERFACE.PrintMsg(txt=>'net weight: '|| l_delivery_details_info.net_weight);
4006: WSH_INTERFACE.PrintMsg(txt=>'organization id: '||l_delivery_details_info.organization_id);
4007: WSH_INTERFACE.PrintMsg(txt=>'weight uom code: '||l_delivery_details_info.weight_uom_code);
4008: WSH_INTERFACE.PrintMsg(txt=>'requested quantity: '||l_delivery_details_info.requested_quantity);
4009: WSH_INTERFACE.PrintMsg(txt=>'ship from location id: '||l_delivery_details_info.ship_from_location_id);

Line 4006: WSH_INTERFACE.PrintMsg(txt=>'organization id: '||l_delivery_details_info.organization_id);

4002: WSH_INTERFACE.PrintMsg(txt=>'Delivery Detail Splitter Data:');
4003: WSH_INTERFACE.PrintMsg(txt=>'delivery detail id: '||dummy_delivery_detail_id);
4004: WSH_INTERFACE.PrintMsg(txt=>'inventory item id: '||l_delivery_details_info.inventory_item_id);
4005: WSH_INTERFACE.PrintMsg(txt=>'net weight: '|| l_delivery_details_info.net_weight);
4006: WSH_INTERFACE.PrintMsg(txt=>'organization id: '||l_delivery_details_info.organization_id);
4007: WSH_INTERFACE.PrintMsg(txt=>'weight uom code: '||l_delivery_details_info.weight_uom_code);
4008: WSH_INTERFACE.PrintMsg(txt=>'requested quantity: '||l_delivery_details_info.requested_quantity);
4009: WSH_INTERFACE.PrintMsg(txt=>'ship from location id: '||l_delivery_details_info.ship_from_location_id);
4010: WSH_INTERFACE.PrintMsg(txt=>'requested_quantity_uom: '||l_delivery_details_info.requested_quantity_uom);

Line 4007: WSH_INTERFACE.PrintMsg(txt=>'weight uom code: '||l_delivery_details_info.weight_uom_code);

4003: WSH_INTERFACE.PrintMsg(txt=>'delivery detail id: '||dummy_delivery_detail_id);
4004: WSH_INTERFACE.PrintMsg(txt=>'inventory item id: '||l_delivery_details_info.inventory_item_id);
4005: WSH_INTERFACE.PrintMsg(txt=>'net weight: '|| l_delivery_details_info.net_weight);
4006: WSH_INTERFACE.PrintMsg(txt=>'organization id: '||l_delivery_details_info.organization_id);
4007: WSH_INTERFACE.PrintMsg(txt=>'weight uom code: '||l_delivery_details_info.weight_uom_code);
4008: WSH_INTERFACE.PrintMsg(txt=>'requested quantity: '||l_delivery_details_info.requested_quantity);
4009: WSH_INTERFACE.PrintMsg(txt=>'ship from location id: '||l_delivery_details_info.ship_from_location_id);
4010: WSH_INTERFACE.PrintMsg(txt=>'requested_quantity_uom: '||l_delivery_details_info.requested_quantity_uom);
4011:

Line 4008: WSH_INTERFACE.PrintMsg(txt=>'requested quantity: '||l_delivery_details_info.requested_quantity);

4004: WSH_INTERFACE.PrintMsg(txt=>'inventory item id: '||l_delivery_details_info.inventory_item_id);
4005: WSH_INTERFACE.PrintMsg(txt=>'net weight: '|| l_delivery_details_info.net_weight);
4006: WSH_INTERFACE.PrintMsg(txt=>'organization id: '||l_delivery_details_info.organization_id);
4007: WSH_INTERFACE.PrintMsg(txt=>'weight uom code: '||l_delivery_details_info.weight_uom_code);
4008: WSH_INTERFACE.PrintMsg(txt=>'requested quantity: '||l_delivery_details_info.requested_quantity);
4009: WSH_INTERFACE.PrintMsg(txt=>'ship from location id: '||l_delivery_details_info.ship_from_location_id);
4010: WSH_INTERFACE.PrintMsg(txt=>'requested_quantity_uom: '||l_delivery_details_info.requested_quantity_uom);
4011:
4012: --prepare table of delivery detail information to call splitter

Line 4009: WSH_INTERFACE.PrintMsg(txt=>'ship from location id: '||l_delivery_details_info.ship_from_location_id);

4005: WSH_INTERFACE.PrintMsg(txt=>'net weight: '|| l_delivery_details_info.net_weight);
4006: WSH_INTERFACE.PrintMsg(txt=>'organization id: '||l_delivery_details_info.organization_id);
4007: WSH_INTERFACE.PrintMsg(txt=>'weight uom code: '||l_delivery_details_info.weight_uom_code);
4008: WSH_INTERFACE.PrintMsg(txt=>'requested quantity: '||l_delivery_details_info.requested_quantity);
4009: WSH_INTERFACE.PrintMsg(txt=>'ship from location id: '||l_delivery_details_info.ship_from_location_id);
4010: WSH_INTERFACE.PrintMsg(txt=>'requested_quantity_uom: '||l_delivery_details_info.requested_quantity_uom);
4011:
4012: --prepare table of delivery detail information to call splitter
4013: l_delivery_detail_tab(1) := WSH_ENTITY_INFO_REC(

Line 4010: WSH_INTERFACE.PrintMsg(txt=>'requested_quantity_uom: '||l_delivery_details_info.requested_quantity_uom);

4006: WSH_INTERFACE.PrintMsg(txt=>'organization id: '||l_delivery_details_info.organization_id);
4007: WSH_INTERFACE.PrintMsg(txt=>'weight uom code: '||l_delivery_details_info.weight_uom_code);
4008: WSH_INTERFACE.PrintMsg(txt=>'requested quantity: '||l_delivery_details_info.requested_quantity);
4009: WSH_INTERFACE.PrintMsg(txt=>'ship from location id: '||l_delivery_details_info.ship_from_location_id);
4010: WSH_INTERFACE.PrintMsg(txt=>'requested_quantity_uom: '||l_delivery_details_info.requested_quantity_uom);
4011:
4012: --prepare table of delivery detail information to call splitter
4013: l_delivery_detail_tab(1) := WSH_ENTITY_INFO_REC(
4014: dummy_delivery_detail_id,

Line 4044: WSH_INTERFACE.PrintMsg(txt=>'Delivery detail split failed for dd:'||dummy_delivery_detail_id);

4040: -- we do not want to stop the flow
4041: -- if the detail doesn't split, it will be caught later in
4042: -- delivery splitting and will have exception on the detail
4043: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
4044: WSH_INTERFACE.PrintMsg(txt=>'Delivery detail split failed for dd:'||dummy_delivery_detail_id);
4045: END IF;
4046:
4047: END IF;
4048: --END OTM R12

Line 4077: WSH_INTERFACE.PrintMsg(name=>'WSH_DET_PROCESS_ORDER_FAILED',

4073: IF l_debug_on THEN
4074: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR: OE_SHIPPING_INTEGRATION_PUB.UPDATE_SHIPPING_INTERFACE RETURNED ' || L_RETURN_STATUS );
4075: END IF;
4076: --
4077: WSH_INTERFACE.PrintMsg(name=>'WSH_DET_PROCESS_ORDER_FAILED',
4078: txt=>'Update_Shipping_Interface failed for line:' || ln_rec_info.line_id );
4079: WSH_UTIL_CORE.Get_Messages('N',l_summary, l_details, l_get_msg_count);
4080: WSH_INTERFACE.PrintMsg(txt=>'no. of OE messages :'||l_msg_count);
4081: FOR k IN 1 .. l_msg_count LOOP

Line 4080: WSH_INTERFACE.PrintMsg(txt=>'no. of OE messages :'||l_msg_count);

4076: --
4077: WSH_INTERFACE.PrintMsg(name=>'WSH_DET_PROCESS_ORDER_FAILED',
4078: txt=>'Update_Shipping_Interface failed for line:' || ln_rec_info.line_id );
4079: WSH_UTIL_CORE.Get_Messages('N',l_summary, l_details, l_get_msg_count);
4080: WSH_INTERFACE.PrintMsg(txt=>'no. of OE messages :'||l_msg_count);
4081: FOR k IN 1 .. l_msg_count LOOP
4082: l_msg_data := OE_MSG_PUB.GET( p_msg_index => k, p_encoded => 'F');
4083: --
4084: IF l_debug_on THEN

Line 4088: WSH_INTERFACE.PrintMsg(txt=>substr(l_msg_data,1,255));

4084: IF l_debug_on THEN
4085: WSH_DEBUG_SV.log(l_module_name,'l_msg_data',SUBSTR(l_msg_data,1,200));
4086: END IF;
4087: --
4088: WSH_INTERFACE.PrintMsg(txt=>substr(l_msg_data,1,255));
4089: END LOOP;
4090: -- Added for Bug-2876707
4091: l_booked_ln_excpn := TRUE;
4092: GOTO Start_Over;

Line 4133: WSH_INTERFACE.PrintMsg(txt=>'Started workflow for '||l_wf_source_header_id||'-'||l_wf_source_code||'-'||

4129: IF l_debug_on THEN
4130: WSH_DEBUG_SV.logmsg(l_module_name, 'WSH_WF.START_WORKFLOW : RETURNED TRUE' );
4131: END IF;
4132: --
4133: WSH_INTERFACE.PrintMsg(txt=>'Started workflow for '||l_wf_source_header_id||'-'||l_wf_source_code||'-'||
4134: l_wf_contact_type||'-'||l_wf_contact_id);
4135: ELSE
4136: --
4137: IF l_debug_on THEN

Line 4141: WSH_INTERFACE.PrintMsg(txt=>'Did not Start workflow for '||l_wf_source_header_id||'-'||l_wf_source_code||'-'||

4137: IF l_debug_on THEN
4138: WSH_DEBUG_SV.logmsg(l_module_name, 'WSH_WF.START_WORKFLOW : DID NOT RETURNED TRUE' );
4139: END IF;
4140: --
4141: WSH_INTERFACE.PrintMsg(txt=>'Did not Start workflow for '||l_wf_source_header_id||'-'||l_wf_source_code||'-'||
4142: l_wf_contact_type||'-'||l_wf_contact_id);
4143: END IF;
4144: --
4145: IF l_debug_on THEN