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 1425: WSH_INTERFACE.Delete_Details(

1421:
1422: -- purge delivery details pending overpick
1423: IF l_rs NOT IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1424: AND l_delete_dds.count > 0 THEN
1425: WSH_INTERFACE.Delete_Details(
1426: p_details_id => l_delete_dds,
1427: x_return_status => l_rs
1428: );
1429: END IF;

Line 1457: p_changed_attributes IN WSH_INTERFACE.ChangedAttributeTabType,

1453: END Split_Records_Int;
1454:
1455: PROCEDURE Split_Records (
1456: p_source_code IN VARCHAR2,
1457: p_changed_attributes IN WSH_INTERFACE.ChangedAttributeTabType,
1458: p_interface_flag IN VARCHAR2,
1459: x_return_status OUT NOCOPY VARCHAR2
1460: ) IS
1461: l_index number ;

Line 1624: p_changed_attributes IN WSH_INTERFACE.ChangedAttributeTabType,

1620: END split_Records ;
1621:
1622: PROCEDURE Update_Records(
1623: p_source_code IN VARCHAR2,
1624: p_changed_attributes IN WSH_INTERFACE.ChangedAttributeTabType,
1625: p_interface_flag IN VARCHAR2,
1626: x_return_status OUT NOCOPY VARCHAR2)
1627: IS
1628: l_counter NUMBER;

Line 1738: p_attributes_rec IN WSH_INTERFACE.ChangedAttributeRecType,

1734:
1735:
1736: Procedure Update_Attributes(
1737: p_source_code IN VARCHAR2,
1738: p_attributes_rec IN WSH_INTERFACE.ChangedAttributeRecType,
1739: p_changed_detail IN WSH_USA_CATEGORIES_PVT.ChangedDetailRec,
1740: x_return_status OUT NOCOPY VARCHAR2)
1741: IS
1742:

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

2739: p_entity_ids => l_tp_details,
2740: x_return_status => l_return_status);
2741: -- }
2742: IF (l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS, WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
2743: WSH_INTERFACE.PrintMsg(name=>'WSH_CALC_CONT_DEL_TPDATES',
2744: txt=>'Error in calculating Container/Delivery TP dates ');
2745: IF l_debug_on THEN
2746: WSH_DEBUG_SV.log(l_module_name,'Error in calculating Container/Delivery TP dates ');
2747: END IF;

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

3295: OPEN c_specific_item_info(ln_rec_info.inventory_item_id, ln_rec_info.ship_from_org_id);
3296: FETCH C_SPECIFIC_ITEM_INFO INTO haz_class_id, prim_uom_code, weight_uom, unit_weight,
3297: volume_uom, unit_volume, transactable_flag;
3298: CLOSE c_specific_item_info;
3299: WSH_INTERFACE.PrintMsg(txt=>'Importing order line ' || ln_rec_info.line_id);
3300: WSH_UTIL_CORE.GET_LOCATION_ID('ORG', ln_rec_info.ship_from_org_id,
3301: l_ship_from_location_id, l_location_status);
3302:
3303: IF (l_location_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

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

3306: END IF;
3307: l_booked_ln_excpn := TRUE;
3308: GOTO start_over;
3309: END IF;
3310: WSH_INTERFACE.PrintMsg(txt=>'From organization:'|| ln_rec_info.ship_from_org_id||' loc:'|| l_ship_from_location_id );
3311:
3312: WSH_UTIL_CORE.GET_LOCATION_ID('CUSTOMER SITE', ln_rec_info.ship_to_org_id,
3313: l_ship_to_location_id, l_location_status);
3314: IF (l_location_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

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

3311:
3312: WSH_UTIL_CORE.GET_LOCATION_ID('CUSTOMER SITE', ln_rec_info.ship_to_org_id,
3313: l_ship_to_location_id, l_location_status);
3314: IF (l_location_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
3315: WSH_INTERFACE.PrintMsg(name=>'WSH_DET_NO_LOCATION_FOR_ORG',
3316: txt=>'Failed to get location for line: '||ln_rec_info.line_id||
3317: ' ship to org:'||ln_rec_info.ship_to_org_id);
3318: IF l_debug_on THEN
3319: 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 3324: WSH_INTERFACE.PrintMsg(txt=>'To organization:'|| ln_rec_info.ship_to_org_id||' loc:'|| l_ship_to_location_id );

3320: END IF;
3321: l_booked_ln_excpn := TRUE;
3322: GOTO start_over;
3323: END IF;
3324: WSH_INTERFACE.PrintMsg(txt=>'To organization:'|| ln_rec_info.ship_to_org_id||' loc:'|| l_ship_to_location_id );
3325:
3326: IF (ln_rec_info.deliver_to_org_id IS NOT NULL) THEN
3327: WSH_UTIL_CORE.GET_LOCATION_ID('CUSTOMER SITE', ln_rec_info.deliver_to_org_id,
3328: l_deliver_to_location_id, l_location_status);

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

3326: IF (ln_rec_info.deliver_to_org_id IS NOT NULL) THEN
3327: WSH_UTIL_CORE.GET_LOCATION_ID('CUSTOMER SITE', ln_rec_info.deliver_to_org_id,
3328: l_deliver_to_location_id, l_location_status);
3329: IF (l_location_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
3330: WSH_INTERFACE.PrintMsg(name=>'WSH_DET_NO_LOCATION_FOR_ORG',
3331: txt=> 'Failed to get location for line: '||ln_rec_info.line_id||
3332: ' delivery to org:'||ln_rec_info.deliver_to_org_id);
3333: IF l_debug_on THEN
3334: 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 3340: WSH_INTERFACE.PrintMsg(txt=>'Deliver to org:'|| ln_rec_info.deliver_to_org_id||' loc:'|| l_deliver_to_location_id );

3336: l_booked_ln_excpn := TRUE;
3337: GOTO start_over;
3338: END IF;
3339: END IF;
3340: WSH_INTERFACE.PrintMsg(txt=>'Deliver to org:'|| ln_rec_info.deliver_to_org_id||' loc:'|| l_deliver_to_location_id );
3341:
3342: IF (ln_rec_info.intmed_ship_to_org_id IS NOT NULL) THEN
3343: WSH_UTIL_CORE.GET_LOCATION_ID('CUSTOMER SITE', ln_rec_info.intmed_ship_to_org_id,
3344: l_intmed_ship_to_location_id, l_location_status);

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

3342: IF (ln_rec_info.intmed_ship_to_org_id IS NOT NULL) THEN
3343: WSH_UTIL_CORE.GET_LOCATION_ID('CUSTOMER SITE', ln_rec_info.intmed_ship_to_org_id,
3344: l_intmed_ship_to_location_id, l_location_status);
3345: IF (l_location_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
3346: WSH_INTERFACE.PrintMsg(name=>'WSH_DET_NO_LOCATION_FOR_ORG',
3347: txt=> 'Failed to get location for line: '||ln_rec_info.line_id||
3348: ' intermediate ship to org:'||ln_rec_info.intmed_ship_to_org_id);
3349: IF l_debug_on THEN
3350: 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 3356: WSH_INTERFACE.PrintMsg(txt=>'Intermediate ship to org:'|| ln_rec_info.intmed_ship_to_org_id||' loc:'|| l_intmed_ship_to_location_id );

3352: l_booked_ln_excpn := TRUE;
3353: GOTO start_over;
3354: END IF;
3355: END IF;
3356: WSH_INTERFACE.PrintMsg(txt=>'Intermediate ship to org:'|| ln_rec_info.intmed_ship_to_org_id||' loc:'|| l_intmed_ship_to_location_id );
3357:
3358: IF (l_deliver_to_location_id is NULL) THEN
3359: l_deliver_to_location_id := l_ship_to_location_id;
3360: END IF;

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

3364: IF ( c_shipping_parameters%NOTFOUND ) THEN
3365: IF l_debug_on THEN
3366: WSH_DEBUG_SV.log(l_module_name,'Shipping Parameters notfound for warehuse:'||ln_rec_info.ship_from_org_id);
3367: END IF;
3368: WSH_INTERFACE.PrintMsg(txt=>'Shipping Parameters notfound for warehouse:'||ln_rec_info.ship_from_org_id);
3369: END IF;
3370: CLOSE c_shipping_parameters;
3371:
3372: OPEN c_category_id(ln_rec_info.inventory_item_id,

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

3373: ln_rec_info.ship_from_org_id,
3374: l_ship_parameters.freight_class_cat_set_id);
3375: FETCH c_category_id INTO l_freight_cl_cat_id;
3376: IF (c_category_id%NOTFOUND) THEN
3377: WSH_INTERFACE.PrintMsg(txt=>'Freight Catergory id notfound for item:'||ln_rec_info.inventory_item_id||
3378: ' warehouse:'||ln_rec_info.ship_from_org_id ||
3379: ' freight_class:'||l_ship_parameters.freight_class_cat_set_id);
3380: END IF;
3381: CLOSE c_category_id;

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

3384: ln_rec_info.ship_from_org_id,
3385: l_ship_parameters.commodity_code_cat_set_id);
3386: FETCH c_category_id INTO l_commodity_cat_id;
3387: IF (c_category_id%NOTFOUND) THEN
3388: WSH_INTERFACE.PrintMsg(txt=>'Commodity Catergory id notfound for item:'||ln_rec_info.inventory_item_id||
3389: ' warehouse:'||ln_rec_info.ship_from_org_id ||
3390: ' commodity_class:'||l_ship_parameters.commodity_code_cat_set_id);
3391: END IF;
3392: CLOSE c_category_id;

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

3389: ' warehouse:'||ln_rec_info.ship_from_org_id ||
3390: ' commodity_class:'||l_ship_parameters.commodity_code_cat_set_id);
3391: END IF;
3392: CLOSE c_category_id;
3393: WSH_INTERFACE.PrintMsg(txt=>'frght_class_catg_id:'|| l_freight_cl_cat_id ||' commodity_class_ctg_id:'|| l_commodity_cat_id);
3394:
3395:
3396: /* J TP Release */
3397: WSH_TP_RELEASE.calculate_tp_dates (

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

3410: x_earliest_dropoff_date => l_delivery_details_info.earliest_dropoff_date,
3411: x_latest_dropoff_date => l_delivery_details_info.latest_dropoff_date
3412: );
3413: IF (l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS, WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
3414: WSH_INTERFACE.PrintMsg(name=>'WSH_CALC_TP_DATES',
3415: 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);
3416: IF l_debug_on THEN
3417: WSH_DEBUG_SV.log(l_module_name,'Error in calculating TP dates: ' ||
3418: ln_rec_info.order_date_type_code ||

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

3459: l_delivery_details_info.intmed_ship_to_location_id := l_intmed_ship_to_location_id;
3460: l_delivery_details_info.intmed_ship_to_contact_id := ln_rec_info.intmed_ship_to_contact_id;
3461: l_delivery_details_info.ship_tolerance_above := ln_rec_info.ship_tolerance_above;
3462: l_delivery_details_info.ship_tolerance_below := ln_rec_info.ship_tolerance_below;
3463: WSH_INTERFACE.PrintMsg(txt=>'calling Convert uom=> order uom:'||ln_rec_info.order_quantity_uom||
3464: ' order_qty:'||ln_rec_info.ordered_quantity || ' item_id:'|| ln_rec_info.inventory_item_id ||
3465: 'to uom:'||prim_uom_code);
3466:
3467: -- HW OPMCONV.

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

3467: -- HW OPMCONV.
3468: l_delivery_details_info.requested_quantity := wsh_wv_utils.convert_uom(ln_rec_info.order_quantity_uom,
3469: prim_uom_code,ln_rec_info.ordered_quantity,
3470: ln_rec_info.inventory_item_id);
3471: WSH_INTERFACE.PrintMsg(txt=>'Convert uom=> prim_uom:'||prim_uom_code);
3472: l_delivery_details_info.requested_quantity_uom := prim_uom_code;
3473:
3474: -- odaboval : Begin of OPM Changes
3475: -- requested_quantities need to converted from apps primary uom code to

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

3491: END IF;
3492: --
3493: l_delivery_details_info.cancelled_quantity2:= NULL;
3494: -- odaboval : End of OPM Changes
3495: WSH_INTERFACE.PrintMsg(txt=>'Continuing to populate delivery_details_info record.');
3496:
3497: l_delivery_details_info.customer_requested_lot_flag := NULL;
3498: l_delivery_details_info.date_requested := ln_rec_info.date_requested;
3499: l_delivery_details_info.date_scheduled := ln_rec_info.date_scheduled;

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

3613: l_delivery_details_info.wv_frozen_flag := 'N';
3614: l_delivery_details_info.request_date_type_code := ln_rec_info.order_date_type_code;
3615:
3616: IF (l_delivery_details_info.requested_quantity = 0) THEN
3617: WSH_INTERFACE.PrintMsg(name=>'WSH_QTY_OR_UOM_NOT_VALID',
3618: txt=>'Failed to import order line ' || ln_rec_info.line_id || ' because quantity uom or quantity is invalid');
3619: l_booked_ln_excpn := TRUE;
3620: GOTO start_over;
3621: END IF;

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

3623: -- anxsharm Bug 2181132
3624: l_delivery_details_info.source_line_set_id := ln_rec_info.line_set_id;
3625:
3626: IF (l_delivery_details_info.source_line_set_id IS NOT NULL) THEN
3627: WSH_INTERFACE.PrintMsg(txt=> 'Source Line Set id -'||l_delivery_details_info.source_line_set_id);
3628: END IF;
3629: IF l_debug_on THEN
3630: WSH_DEBUG_SV.log(l_module_name,'Source Line Set id -'||l_delivery_details_info.source_line_set_id);
3631: END IF;

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

3633: WSH_DELIVERY_DETAILS_PKG.Create_Delivery_Details( l_delivery_details_info, dummy_rowid,
3634: DUMMY_DELIVERY_DETAIL_ID,
3635: l_cr_dt_status );
3636: IF (l_cr_dt_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
3637: WSH_INTERFACE.PrintMsg(name=>'WSH_DET_CREATE_DET_FAILED',
3638: txt=>'Create_delivery_details failed for line: ' || ln_rec_info.line_id );
3639: WSH_UTIL_CORE.Get_Messages('N', l_cr_as_summary, l_cr_as_details, l_cr_as_count);
3640: WSH_INTERFACE.PrintMsg(txt=>'Creation of the delivery details failed because of ' || l_cr_as_summary || ':'|| l_cr_as_details);
3641: l_booked_ln_excpn := TRUE;

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

3636: IF (l_cr_dt_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
3637: WSH_INTERFACE.PrintMsg(name=>'WSH_DET_CREATE_DET_FAILED',
3638: txt=>'Create_delivery_details failed for line: ' || ln_rec_info.line_id );
3639: WSH_UTIL_CORE.Get_Messages('N', l_cr_as_summary, l_cr_as_details, l_cr_as_count);
3640: WSH_INTERFACE.PrintMsg(txt=>'Creation of the delivery details failed because of ' || l_cr_as_summary || ':'|| l_cr_as_details);
3641: l_booked_ln_excpn := TRUE;
3642: GOTO start_over;
3643: END IF;
3644: WSH_INTERFACE.PrintMsg(txt=>'Created dd:' || dummy_delivery_detail_id|| ' for line:'|| ln_rec_info.line_id );

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

3640: WSH_INTERFACE.PrintMsg(txt=>'Creation of the delivery details failed because of ' || l_cr_as_summary || ':'|| l_cr_as_details);
3641: l_booked_ln_excpn := TRUE;
3642: GOTO start_over;
3643: END IF;
3644: WSH_INTERFACE.PrintMsg(txt=>'Created dd:' || dummy_delivery_detail_id|| ' for line:'|| ln_rec_info.line_id );
3645: IF DUMMY_DELIVERY_DETAIL_ID IS NOT NULL THEN
3646: IF latest_pickup_tpdate_excep IS NOT NULL THEN
3647: WSH_TP_RELEASE.log_tpdate_exception('LINE',dummy_delivery_detail_id,TRUE,l_delivery_details_info.earliest_pickup_date,latest_pickup_tpdate_excep);
3648: END IF;

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

3655: -- HW OPMCONV. Removed code forking
3656:
3657: -- Call default container after create a new delivery detail to populate
3658: -- default container
3659: WSH_INTERFACE.Default_Container(dummy_delivery_detail_id, l_return_status);
3660: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
3661: WSH_INTERFACE.PrintMsg(txt=>'Default container failed for dd:'||dummy_delivery_detail_id);
3662: END IF;
3663:

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

3657: -- Call default container after create a new delivery detail to populate
3658: -- default container
3659: WSH_INTERFACE.Default_Container(dummy_delivery_detail_id, l_return_status);
3660: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
3661: WSH_INTERFACE.PrintMsg(txt=>'Default container failed for dd:'||dummy_delivery_detail_id);
3662: END IF;
3663:
3664: l_delivery_assignments_info.delivery_id := NULL;
3665: l_delivery_assignments_info.parent_delivery_id := NULL;

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

3670: dummy_assgn_rowid,
3671: DUMMY_DELIVERY_ASSIGNMENT_ID,
3672: l_cr_as_status);
3673: IF (l_cr_as_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
3674: WSH_INTERFACE.PrintMsg(name=>'WSH_DET_CREATE_AS_FAILED',
3675: txt=>'Create Delivery assignments failed for order line:' || ln_rec_info.line_id);
3676: WSH_UTIL_CORE.Get_Messages('N', l_cr_as_summary, l_cr_as_details, l_cr_as_count);
3677: WSH_INTERFACE.PrintMsg(txt=>'Creation of the delivery assignments failed because of ' || l_cr_as_summary || ':'|| l_cr_as_details);
3678: l_booked_ln_excpn := TRUE;

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

3673: IF (l_cr_as_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
3674: WSH_INTERFACE.PrintMsg(name=>'WSH_DET_CREATE_AS_FAILED',
3675: txt=>'Create Delivery assignments failed for order line:' || ln_rec_info.line_id);
3676: WSH_UTIL_CORE.Get_Messages('N', l_cr_as_summary, l_cr_as_details, l_cr_as_count);
3677: WSH_INTERFACE.PrintMsg(txt=>'Creation of the delivery assignments failed because of ' || l_cr_as_summary || ':'|| l_cr_as_details);
3678: l_booked_ln_excpn := TRUE;
3679: GOTO start_over;
3680: END IF;
3681: WSH_INTERFACE.PrintMsg(txt=>'Created da:' || DUMMY_DELIVERY_ASSIGNMENT_ID|| ' for dd:'|| l_delivery_assignments_info.delivery_detail_id);

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

3677: WSH_INTERFACE.PrintMsg(txt=>'Creation of the delivery assignments failed because of ' || l_cr_as_summary || ':'|| l_cr_as_details);
3678: l_booked_ln_excpn := TRUE;
3679: GOTO start_over;
3680: END IF;
3681: WSH_INTERFACE.PrintMsg(txt=>'Created da:' || DUMMY_DELIVERY_ASSIGNMENT_ID|| ' for dd:'|| l_delivery_assignments_info.delivery_detail_id);
3682:
3683: --OTM R12, calling delivery detail splitter
3684: IF (l_gc3_is_installed = 'Y') THEN
3685:

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

3682:
3683: --OTM R12, calling delivery detail splitter
3684: IF (l_gc3_is_installed = 'Y') THEN
3685:
3686: WSH_INTERFACE.PrintMsg(txt=>'Delivery Detail Splitter Data:');
3687: WSH_INTERFACE.PrintMsg(txt=>'delivery detail id: '||dummy_delivery_detail_id);
3688: WSH_INTERFACE.PrintMsg(txt=>'inventory item id: '||l_delivery_details_info.inventory_item_id);
3689: WSH_INTERFACE.PrintMsg(txt=>'net weight: '|| l_delivery_details_info.net_weight);
3690: WSH_INTERFACE.PrintMsg(txt=>'organization id: '||l_delivery_details_info.organization_id);

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

3683: --OTM R12, calling delivery detail splitter
3684: IF (l_gc3_is_installed = 'Y') THEN
3685:
3686: WSH_INTERFACE.PrintMsg(txt=>'Delivery Detail Splitter Data:');
3687: WSH_INTERFACE.PrintMsg(txt=>'delivery detail id: '||dummy_delivery_detail_id);
3688: WSH_INTERFACE.PrintMsg(txt=>'inventory item id: '||l_delivery_details_info.inventory_item_id);
3689: WSH_INTERFACE.PrintMsg(txt=>'net weight: '|| l_delivery_details_info.net_weight);
3690: WSH_INTERFACE.PrintMsg(txt=>'organization id: '||l_delivery_details_info.organization_id);
3691: WSH_INTERFACE.PrintMsg(txt=>'weight uom code: '||l_delivery_details_info.weight_uom_code);

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

3684: IF (l_gc3_is_installed = 'Y') THEN
3685:
3686: WSH_INTERFACE.PrintMsg(txt=>'Delivery Detail Splitter Data:');
3687: WSH_INTERFACE.PrintMsg(txt=>'delivery detail id: '||dummy_delivery_detail_id);
3688: WSH_INTERFACE.PrintMsg(txt=>'inventory item id: '||l_delivery_details_info.inventory_item_id);
3689: WSH_INTERFACE.PrintMsg(txt=>'net weight: '|| l_delivery_details_info.net_weight);
3690: WSH_INTERFACE.PrintMsg(txt=>'organization id: '||l_delivery_details_info.organization_id);
3691: WSH_INTERFACE.PrintMsg(txt=>'weight uom code: '||l_delivery_details_info.weight_uom_code);
3692: WSH_INTERFACE.PrintMsg(txt=>'requested quantity: '||l_delivery_details_info.requested_quantity);

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

3685:
3686: WSH_INTERFACE.PrintMsg(txt=>'Delivery Detail Splitter Data:');
3687: WSH_INTERFACE.PrintMsg(txt=>'delivery detail id: '||dummy_delivery_detail_id);
3688: WSH_INTERFACE.PrintMsg(txt=>'inventory item id: '||l_delivery_details_info.inventory_item_id);
3689: WSH_INTERFACE.PrintMsg(txt=>'net weight: '|| l_delivery_details_info.net_weight);
3690: WSH_INTERFACE.PrintMsg(txt=>'organization id: '||l_delivery_details_info.organization_id);
3691: WSH_INTERFACE.PrintMsg(txt=>'weight uom code: '||l_delivery_details_info.weight_uom_code);
3692: WSH_INTERFACE.PrintMsg(txt=>'requested quantity: '||l_delivery_details_info.requested_quantity);
3693: WSH_INTERFACE.PrintMsg(txt=>'ship from location id: '||l_delivery_details_info.ship_from_location_id);

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

3686: WSH_INTERFACE.PrintMsg(txt=>'Delivery Detail Splitter Data:');
3687: WSH_INTERFACE.PrintMsg(txt=>'delivery detail id: '||dummy_delivery_detail_id);
3688: WSH_INTERFACE.PrintMsg(txt=>'inventory item id: '||l_delivery_details_info.inventory_item_id);
3689: WSH_INTERFACE.PrintMsg(txt=>'net weight: '|| l_delivery_details_info.net_weight);
3690: WSH_INTERFACE.PrintMsg(txt=>'organization id: '||l_delivery_details_info.organization_id);
3691: WSH_INTERFACE.PrintMsg(txt=>'weight uom code: '||l_delivery_details_info.weight_uom_code);
3692: WSH_INTERFACE.PrintMsg(txt=>'requested quantity: '||l_delivery_details_info.requested_quantity);
3693: WSH_INTERFACE.PrintMsg(txt=>'ship from location id: '||l_delivery_details_info.ship_from_location_id);
3694: WSH_INTERFACE.PrintMsg(txt=>'requested_quantity_uom: '||l_delivery_details_info.requested_quantity_uom);

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

3687: WSH_INTERFACE.PrintMsg(txt=>'delivery detail id: '||dummy_delivery_detail_id);
3688: WSH_INTERFACE.PrintMsg(txt=>'inventory item id: '||l_delivery_details_info.inventory_item_id);
3689: WSH_INTERFACE.PrintMsg(txt=>'net weight: '|| l_delivery_details_info.net_weight);
3690: WSH_INTERFACE.PrintMsg(txt=>'organization id: '||l_delivery_details_info.organization_id);
3691: WSH_INTERFACE.PrintMsg(txt=>'weight uom code: '||l_delivery_details_info.weight_uom_code);
3692: WSH_INTERFACE.PrintMsg(txt=>'requested quantity: '||l_delivery_details_info.requested_quantity);
3693: WSH_INTERFACE.PrintMsg(txt=>'ship from location id: '||l_delivery_details_info.ship_from_location_id);
3694: WSH_INTERFACE.PrintMsg(txt=>'requested_quantity_uom: '||l_delivery_details_info.requested_quantity_uom);
3695:

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

3688: WSH_INTERFACE.PrintMsg(txt=>'inventory item id: '||l_delivery_details_info.inventory_item_id);
3689: WSH_INTERFACE.PrintMsg(txt=>'net weight: '|| l_delivery_details_info.net_weight);
3690: WSH_INTERFACE.PrintMsg(txt=>'organization id: '||l_delivery_details_info.organization_id);
3691: WSH_INTERFACE.PrintMsg(txt=>'weight uom code: '||l_delivery_details_info.weight_uom_code);
3692: WSH_INTERFACE.PrintMsg(txt=>'requested quantity: '||l_delivery_details_info.requested_quantity);
3693: WSH_INTERFACE.PrintMsg(txt=>'ship from location id: '||l_delivery_details_info.ship_from_location_id);
3694: WSH_INTERFACE.PrintMsg(txt=>'requested_quantity_uom: '||l_delivery_details_info.requested_quantity_uom);
3695:
3696: --prepare table of delivery detail information to call splitter

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

3689: WSH_INTERFACE.PrintMsg(txt=>'net weight: '|| l_delivery_details_info.net_weight);
3690: WSH_INTERFACE.PrintMsg(txt=>'organization id: '||l_delivery_details_info.organization_id);
3691: WSH_INTERFACE.PrintMsg(txt=>'weight uom code: '||l_delivery_details_info.weight_uom_code);
3692: WSH_INTERFACE.PrintMsg(txt=>'requested quantity: '||l_delivery_details_info.requested_quantity);
3693: WSH_INTERFACE.PrintMsg(txt=>'ship from location id: '||l_delivery_details_info.ship_from_location_id);
3694: WSH_INTERFACE.PrintMsg(txt=>'requested_quantity_uom: '||l_delivery_details_info.requested_quantity_uom);
3695:
3696: --prepare table of delivery detail information to call splitter
3697: l_delivery_detail_tab(1) := WSH_ENTITY_INFO_REC(

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

3690: WSH_INTERFACE.PrintMsg(txt=>'organization id: '||l_delivery_details_info.organization_id);
3691: WSH_INTERFACE.PrintMsg(txt=>'weight uom code: '||l_delivery_details_info.weight_uom_code);
3692: WSH_INTERFACE.PrintMsg(txt=>'requested quantity: '||l_delivery_details_info.requested_quantity);
3693: WSH_INTERFACE.PrintMsg(txt=>'ship from location id: '||l_delivery_details_info.ship_from_location_id);
3694: WSH_INTERFACE.PrintMsg(txt=>'requested_quantity_uom: '||l_delivery_details_info.requested_quantity_uom);
3695:
3696: --prepare table of delivery detail information to call splitter
3697: l_delivery_detail_tab(1) := WSH_ENTITY_INFO_REC(
3698: dummy_delivery_detail_id,

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

3724: -- we do not want to stop the flow
3725: -- if the detail doesn't split, it will be caught later in
3726: -- delivery splitting and will have exception on the detail
3727: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
3728: WSH_INTERFACE.PrintMsg(txt=>'Delivery detail split failed for dd:'||dummy_delivery_detail_id);
3729: END IF;
3730:
3731: END IF;
3732: --END OTM R12

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

3757: IF l_debug_on THEN
3758: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR: OE_SHIPPING_INTEGRATION_PUB.UPDATE_SHIPPING_INTERFACE RETURNED ' || L_RETURN_STATUS );
3759: END IF;
3760: --
3761: WSH_INTERFACE.PrintMsg(name=>'WSH_DET_PROCESS_ORDER_FAILED',
3762: txt=>'Update_Shipping_Interface failed for line:' || ln_rec_info.line_id );
3763: WSH_UTIL_CORE.Get_Messages('N',l_summary, l_details, l_get_msg_count);
3764: WSH_INTERFACE.PrintMsg(txt=>'no. of OE messages :'||l_msg_count);
3765: FOR k IN 1 .. l_msg_count LOOP

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

3760: --
3761: WSH_INTERFACE.PrintMsg(name=>'WSH_DET_PROCESS_ORDER_FAILED',
3762: txt=>'Update_Shipping_Interface failed for line:' || ln_rec_info.line_id );
3763: WSH_UTIL_CORE.Get_Messages('N',l_summary, l_details, l_get_msg_count);
3764: WSH_INTERFACE.PrintMsg(txt=>'no. of OE messages :'||l_msg_count);
3765: FOR k IN 1 .. l_msg_count LOOP
3766: l_msg_data := OE_MSG_PUB.GET( p_msg_index => k, p_encoded => 'F');
3767: --
3768: IF l_debug_on THEN

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

3768: IF l_debug_on THEN
3769: WSH_DEBUG_SV.log(l_module_name,'l_msg_data',SUBSTR(l_msg_data,1,200));
3770: END IF;
3771: --
3772: WSH_INTERFACE.PrintMsg(txt=>substr(l_msg_data,1,255));
3773: END LOOP;
3774: -- Added for Bug-2876707
3775: l_booked_ln_excpn := TRUE;
3776: GOTO Start_Over;

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

3813: IF l_debug_on THEN
3814: WSH_DEBUG_SV.logmsg(l_module_name, 'WSH_WF.START_WORKFLOW : RETURNED TRUE' );
3815: END IF;
3816: --
3817: WSH_INTERFACE.PrintMsg(txt=>'Started workflow for '||l_wf_source_header_id||'-'||l_wf_source_code||'-'||
3818: l_wf_contact_type||'-'||l_wf_contact_id);
3819: ELSE
3820: --
3821: IF l_debug_on THEN

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

3821: IF l_debug_on THEN
3822: WSH_DEBUG_SV.logmsg(l_module_name, 'WSH_WF.START_WORKFLOW : DID NOT RETURNED TRUE' );
3823: END IF;
3824: --
3825: WSH_INTERFACE.PrintMsg(txt=>'Did not Start workflow for '||l_wf_source_header_id||'-'||l_wf_source_code||'-'||
3826: l_wf_contact_type||'-'||l_wf_contact_id);
3827: END IF;
3828: --
3829: IF l_debug_on THEN