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_FTE_CONSTRAINT_FRAMEWORK dependencies on WSH_LOCATIONS_PKG

Line 9177: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

9173: --Made the changes outside if condition.
9174:
9175: --#DUM_LOC(S)
9176: --Check if ultimate drop off location is a dummy location
9177: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
9178: p_internal_cust_location_id => l_ultimate_do_loc_id,
9179: x_internal_org_location_id => l_physical_location_id,
9180: x_return_status => l_return_status);
9181:

Line 11784: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

11780: -- Delivery's ultimate_dropoff_location_id to be converted to physical internal
11781: -- location if it is a dummy location.
11782: -- We have to use the API for this purpose.
11783:
11784: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
11785: p_internal_cust_location_id => l_delivery_info(i).ultimate_dropoff_location_id,
11786: x_internal_org_location_id => l_physical_location_id,
11787: x_return_status => l_return_status);
11788:

Line 11884: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

11880: WSH_DEBUG_SV.logmsg(l_module_name,'l_delivery_info(i).ultimate_dropoff_location_id : '||l_delivery_info(i).ultimate_dropoff_location_id);
11881: END IF;
11882: --
11883: --#DUM_LOC(S)
11884: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
11885: p_internal_cust_location_id => l_delivery_info(i).ultimate_dropoff_location_id,
11886: x_internal_org_location_id => l_physical_location_id,
11887: x_return_status => l_return_status);
11888:

Line 12003: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

11999: --#DUM_LOC(S)
12000: -- Delivery detail's Dummy ship_to_location_id has to be converted to physical internal
12001: -- location
12002:
12003: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
12004: p_internal_cust_location_id => l_dlvy_assigned_lines(j).ship_to_location_id,
12005: x_internal_org_location_id => l_physical_location_id,
12006: x_return_status => l_return_status);
12007:

Line 12064: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

12060: l_dlvy_assigned_lines(i).line_direction := p_dlvy_assigned_lines(i).line_direction;
12061: l_dlvy_assigned_lines(i).shipping_control := nvl(p_dlvy_assigned_lines(i).shipping_control,'BUYER');
12062:
12063: --#DUM_LOC(S)
12064: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
12065: p_internal_cust_location_id => l_dlvy_assigned_lines(i).ship_to_location_id,
12066: x_internal_org_location_id => l_physical_location_id,
12067: x_return_status => l_return_status);
12068:

Line 12104: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

12100: FETCH c_get_trip_dlvy INTO l_delivery_rec;
12101: EXIT WHEN c_get_trip_dlvy%NOTFOUND;
12102:
12103: --#DUM_LOC(S)
12104: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
12105: p_internal_cust_location_id => l_delivery_rec.ultimate_dropoff_location_id,
12106: x_internal_org_location_id => l_physical_location_id,
12107: x_return_status => l_return_status);
12108:

Line 12138: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

12134: l_target_trip_assign_dels(l) := p_target_trip_assign_dels(l);
12135: -- AGDUMMY
12136:
12137: --#DUM_LOC(S)
12138: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
12139: p_internal_cust_location_id => l_target_trip_assign_dels(l).ultimate_dropoff_location_id,
12140: x_internal_org_location_id => l_physical_location_id,
12141: x_return_status => l_return_status);
12142:

Line 12174: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

12170: FETCH c_get_trip_details_std INTO l_detail_rec;
12171: EXIT WHEN c_get_trip_details_std%NOTFOUND;
12172:
12173: --#DUM_LOC(S)
12174: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
12175: p_internal_cust_location_id => l_detail_rec.ship_to_location_id,
12176: x_internal_org_location_id => l_physical_location_id,
12177: x_return_status => l_return_status);
12178:

Line 12208: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

12204: FETCH c_get_trip_details INTO l_detail_rec;
12205: EXIT WHEN c_get_trip_details%NOTFOUND;
12206:
12207: --#DUM_LOC(S)
12208: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
12209: p_internal_cust_location_id => l_detail_rec.ship_to_location_id,
12210: x_internal_org_location_id => l_physical_location_id,
12211: x_return_status => l_return_status);
12212:

Line 12242: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

12238: LOOP
12239: l_target_trip_dlvy_lines(l) := p_target_trip_dlvy_lines(l);
12240:
12241: --#DUM_LOC(S)
12242: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
12243: p_internal_cust_location_id => l_target_trip_dlvy_lines(l).ship_to_location_id,
12244: x_internal_org_location_id => l_physical_location_id,
12245: x_return_status => l_return_status);
12246:

Line 12349: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

12345:
12346: -- #DUM_LOC(S)
12347: -- p_target_tripstops.PICKUP_LOCATION_ID
12348:
12349: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
12350: p_internal_cust_location_id => p_target_tripstops.pickup_location_id,
12351: x_internal_org_location_id => l_physical_location_id,
12352: x_return_status => l_return_status);
12353:

Line 12371: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

12367: END IF;
12368:
12369: -- p_target_tripstops.DROPOFF_LOCATION_ID
12370:
12371: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
12372: p_internal_cust_location_id => p_target_tripstops.dropoff_location_id,
12373: x_internal_org_location_id => l_physical_location_id,
12374: x_return_status => l_return_status);
12375:

Line 13300: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

13296: -- TODO
13297:
13298: --#DUM_LOC(S)
13299: --Check if ultimate drop off location is a dummy location
13300: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
13301: p_internal_cust_location_id => l_detail_rec.ship_to_location_id,
13302: x_internal_org_location_id => l_physical_location_id,
13303: x_return_status => l_return_status);
13304:

Line 13338: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

13334: -- TODO
13335:
13336: --#DUM_LOC(S)
13337: --Check if ultimate drop off location is a dummy location
13338: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
13339: p_internal_cust_location_id => l_detail_rec.ship_to_location_id,
13340: x_internal_org_location_id => l_physical_location_id,
13341: x_return_status => l_return_status);
13342:

Line 13375: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

13371: -- TODO
13372:
13373: --#DUM_LOC(S)
13374: --Check if ultimate drop off location is a dummy location
13375: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
13376: p_internal_cust_location_id => l_dleg_dlvy_rec.ultimate_dropoff_location_id,
13377: x_internal_org_location_id => l_physical_location_id,
13378: x_return_status => l_return_status);
13379:

Line 13404: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

13400: --#DUM_LOC(S)
13401: --Check if input dleg's drop off location is a dummy location
13402: l_delivery_leg_rec := p_delivery_leg_rec;
13403:
13404: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
13405: p_internal_cust_location_id => p_delivery_leg_rec.dropoffstop_location_id,
13406: x_internal_org_location_id => l_physical_location_id,
13407: x_return_status => l_return_status);
13408:

Line 13902: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

13898: -- TODO
13899:
13900: --#DUM_LOC(S)
13901: --Check if ultimate drop off location is a dummy location
13902: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
13903: p_internal_cust_location_id => l_detail_rec.ship_to_location_id,
13904: x_internal_org_location_id => l_physical_location_id,
13905: x_return_status => l_return_status);
13906:

Line 13940: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

13936: -- TODO
13937:
13938: --#DUM_LOC(S)
13939: --Check if ultimate drop off location is a dummy location
13940: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
13941: p_internal_cust_location_id => l_dlvy_rec.ultimate_dropoff_location_id,
13942: x_internal_org_location_id => l_physical_location_id,
13943: x_return_status => l_return_status);
13944:

Line 14577: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

14573: FETCH c_get_line_details into l_del_detail_info(i);
14574: CLOSE c_get_line_details;
14575:
14576: --#DUM_LOC(S)
14577: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
14578: p_internal_cust_location_id => l_del_detail_info(i).ship_to_location_id,
14579: x_internal_org_location_id => l_physical_location_id,
14580: x_return_status => l_return_status);
14581:

Line 14641: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

14637: l_del_detail_info(i).SHIPPING_CONTROL := nvl(p_del_detail_info(i).SHIPPING_CONTROL,'BUYER');
14638: l_del_detail_info(i).ORGANIZATION_ID := p_del_detail_info(i).ORGANIZATION_ID;
14639:
14640: --#DUM_LOC(S)
14641: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
14642: p_internal_cust_location_id => l_del_detail_info(i).ship_to_location_id,
14643: x_internal_org_location_id => l_physical_location_id,
14644: x_return_status => l_return_status);
14645:

Line 14679: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

14675: FETCH c_get_dlvy into l_target_delivery;
14676: CLOSE c_get_dlvy;
14677:
14678: --#DUM_LOC(S)
14679: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
14680: p_internal_cust_location_id => l_target_delivery.ultimate_dropoff_location_id,
14681: x_internal_org_location_id => l_physical_location_id,
14682: x_return_status => l_return_status);
14683:

Line 14713: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

14709: FETCH c_get_line_details into l_target_container;
14710: CLOSE c_get_line_details;
14711:
14712: --#DUM_LOC(S)
14713: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
14714: p_internal_cust_location_id => l_target_container.ship_to_location_id,
14715: x_internal_org_location_id => l_physical_location_id,
14716: x_return_status => l_return_status);
14717:

Line 14750: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

14746: FETCH c_get_details INTO l_detail_rec;
14747: EXIT WHEN c_get_details%NOTFOUND;
14748:
14749: --#DUM_LOC(S)
14750: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
14751: p_internal_cust_location_id => l_detail_rec.ship_to_location_id,
14752: x_internal_org_location_id => l_physical_location_id,
14753: x_return_status => l_return_status);
14754:

Line 14783: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

14779: FETCH c_get_details_consol INTO l_detail_rec;
14780: EXIT WHEN c_get_details%NOTFOUND;
14781:
14782: --#DUM_LOC(S)
14783: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
14784: p_internal_cust_location_id => l_detail_rec.ship_to_location_id,
14785: x_internal_org_location_id => l_physical_location_id,
14786: x_return_status => l_return_status);
14787:

Line 14820: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

14816: FETCH c_get_assigned_lines_cont INTO l_detail_rec;
14817: EXIT WHEN c_get_assigned_lines_cont%NOTFOUND;
14818:
14819: --#DUM_LOC(S)
14820: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
14821: p_internal_cust_location_id => l_detail_rec.ship_to_location_id,
14822: x_internal_org_location_id => l_physical_location_id,
14823: x_return_status => l_return_status);
14824:

Line 14884: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

14880: l_dlvy_assigned_lines(i).LINE_DIRECTION := p_dlvy_assigned_lines(i).LINE_DIRECTION;
14881: l_dlvy_assigned_lines(i).SHIPPING_CONTROL := nvl(p_dlvy_assigned_lines(i).SHIPPING_CONTROL,'BUYER');
14882:
14883: --#DUM_LOC(S)
14884: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
14885: p_internal_cust_location_id => l_dlvy_assigned_lines(i).ship_to_location_id,
14886: x_internal_org_location_id => l_physical_location_id,
14887: x_return_status => l_return_status);
14888:

Line 15815: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

15811: FETCH c_get_trip_dlvy INTO l_delivery_rec;
15812: EXIT WHEN c_get_trip_dlvy%NOTFOUND;
15813:
15814: --#DUM_LOC(S)
15815: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
15816: p_internal_cust_location_id => l_delivery_rec.ultimate_dropoff_location_id,
15817: x_internal_org_location_id => l_physical_location_id,
15818: x_return_status => l_return_status);
15819:

Line 15851: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

15847: LOOP
15848: FETCH c_get_trip_details_std INTO l_detail_rec;
15849: EXIT WHEN c_get_trip_details_std%NOTFOUND;
15850: --#DUM_LOC(S)
15851: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
15852: p_internal_cust_location_id => l_detail_rec.ship_to_location_id,
15853: x_internal_org_location_id => l_physical_location_id,
15854: x_return_status => l_return_status);
15855:

Line 15907: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

15903: LOOP
15904: l_trip_assigned_dels(l) := p_trip_assigned_dels(l);
15905:
15906: --#DUM_LOC(S)
15907: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
15908: p_internal_cust_location_id => l_trip_assigned_dels(l).ultimate_dropoff_location_id,
15909: x_internal_org_location_id => l_physical_location_id,
15910: x_return_status => l_return_status);
15911:

Line 15942: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

15938: l := p_trip_dlvy_lines.FIRST;
15939: LOOP
15940: l_trip_dlvy_lines(l) := p_trip_dlvy_lines(l);
15941: --#DUM_LOC(S)
15942: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
15943: p_internal_cust_location_id => l_trip_dlvy_lines(l).ship_to_location_id,
15944: x_internal_org_location_id => l_physical_location_id,
15945: x_return_status => l_return_status);
15946:

Line 18331: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(

18327: -- Delivery's ultimate_dropoff_location_id to be converted to physical internal
18328: -- location if it is a dummy location.
18329: -- We have to use the API for this purpose.
18330:
18331: WSH_LOCATIONS_PKG.CONVERT_INTERNAL_CUST_LOCATION(
18332: p_internal_cust_location_id => p_delivery_info(i).ultimate_dropoff_location_id,
18333: x_internal_org_location_id => l_physical_location_id,
18334: x_return_status => l_return_status);
18335: