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.GMI_SHIPPING_UTIL dependencies on WSH_UTIL_CORE

Line 131: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

127:
128: /* Standard Start OF API savepoint */
129:
130: SAVEPOINT process_backorders;
131: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
132:
133:
134: GMI_RESERVATION_UTIL.println('Start Of OPM BackOrder Routine');
135:

Line 563: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

559: /* Standard Start OF API savepoint */
560:
561: GMI_RESERVATION_UTIL.println('deleting trans ');
562: SAVEPOINT process_backorders;
563: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
564:
565: l_transaction_rec.trans_id := p_trans_id;
566: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
567: (l_transaction_rec, l_transaction_rec )

Line 807: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

803: BEGIN
804: /* Standard Start OF API savepoint */
805:
806: SAVEPOINT process_shipments;
807: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
808: /* Bug 2775197 */
809:
810: -- HW BUG 3434884 - GSCC issue. Need to get proper Schema Name
811:

Line 1529: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1525:
1526: EXCEPTION
1527:
1528: WHEN INVENTORY_NEG_WARNING THEN
1529: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1530:
1531: WHEN NO_DATA_FOUND THEN
1532: rollback to process_shipments;
1533: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1611: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1607: BEGIN
1608: /* Standard Start OF API savepoint */
1609:
1610: SAVEPOINT process_shipments;
1611: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1612:
1613: GMI_RESERVATION_UTIL.println('Start Of OPM Inventory Interface Routine');
1614: GMI_RESERVATION_UTIL.println('delivery_detail_id '||p_shipping_line.delivery_detail_id);
1615: GMI_RESERVATION_UTIL.println('shipped_qty '||p_shipping_line.shipped_quantity);

Line 1864: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1860:
1861: /* Let's First Update all the move order lines ( backordered and */
1862: /* Not Pick Confirmed). */
1863:
1864: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1865:
1866: GMI_RESERVATION_UTIL.println('In GMI BACKORDER UPDATE');
1867: GMI_RESERVATION_UTIL.println('P_source_line_id => ' || p_source_line_id);
1868: GMI_RESERVATION_UTIL.println('Original SOURCE => ' || p_original_source_line_id );

Line 1883: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1879: SET TXN_SOURCE_LINE_ID = p_source_line_id
1880: WHERE line_id = l_move_order.move_order_line_id;
1881:
1882: IF (SQL%NOTFOUND) THEN
1883: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1884: GMI_RESERVATION_UTIL.println('Error In Updating MO LINE');
1885: Close get_move_order; /* B2886561 close cursor before exception */
1886: RAISE NO_DATA_FOUND;
1887: END IF;

Line 1936: -- x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1932: IF (SQL%NOTFOUND)
1933: THEN
1934: GMI_RESERVATION_UTIL.println('No Update in wsh_delivery_details, line_id='||p_source_line_id);
1935:
1936: -- x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1937: -- RAISE NO_DATA_FOUND;
1938: END IF;
1939:
1940: GMI_RESERVATION_UTIL.println('New Line Id => '|| p_source_line_id );

Line 1966: --x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1962: IF (SQL%NOTFOUND) THEN
1963: /* bug 1783859 */
1964: /*for a pure back order line, this trans may not exsit, no error should be returned*/
1965: GMI_RESERVATION_UTIL.println('No Update in ic_tran_pnd, line_id='||p_source_line_id);
1966: --x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1967: --RAISE NO_DATA_FOUND;
1968: END IF;
1969:
1970:

Line 2394: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2390: OPEN c_order_line_info(l_detail_rec.source_line_id);
2391: FETCH c_order_line_info into l_order_line_info;
2392: if (c_order_line_info%NOTFOUND) THEN
2393: CLOSE c_order_line_info;
2394: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2395: GMI_RESERVATION_UTIL.Println('Sales order not valid');
2396: return;
2397: END if;
2398: CLOSE c_order_line_info;

Line 2413: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2409: , l_ultimate_dropoff_date
2410: ;
2411: if (c_delivery_info%NOTFOUND) THEN
2412: CLOSE c_delivery_info;
2413: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2414: GMI_RESERVATION_UTIL.Println('Delivery Detail is not assigned to any delivery');
2415: return;
2416: -- raise NOT_ASSIGNED_TO_DEL_ERROR;
2417: END if;

Line 2426: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2422: l_order_line_info.source_document_id);
2423: FETCH c_po_info into l_po_info;
2424: if c_po_info%NOTFOUND then
2425: CLOSE c_po_info;
2426: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2427: WSH_UTIL_CORE.Println('Requisition line not found');
2428: return;
2429: end if;
2430: CLOSE c_po_info;

Line 2427: WSH_UTIL_CORE.Println('Requisition line not found');

2423: FETCH c_po_info into l_po_info;
2424: if c_po_info%NOTFOUND then
2425: CLOSE c_po_info;
2426: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2427: WSH_UTIL_CORE.Println('Requisition line not found');
2428: return;
2429: end if;
2430: CLOSE c_po_info;
2431: GMI_RESERVATION_UTIL.Println('Requisition line id:' || l_order_line_info.source_document_line_id);

Line 2534: wsh_util_core.println ( 'Error: More than one Distribution accounts ' || l_account );

2530:
2531: --l_account := PO_REQ_DIST_SV1.get_dist_account( l_requisition_line_id ) ; -- Bug 1610178
2532:
2533: /*if ( l_account = -11 ) then
2534: wsh_util_core.println ( 'Error: More than one Distribution accounts ' || l_account );
2535: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING ;
2536: return;
2537: elsif ( l_account is null ) then
2538: wsh_util_core.println ( 'Error: Cannot get Distribution account ' || l_account );

Line 2535: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING ;

2531: --l_account := PO_REQ_DIST_SV1.get_dist_account( l_requisition_line_id ) ; -- Bug 1610178
2532:
2533: /*if ( l_account = -11 ) then
2534: wsh_util_core.println ( 'Error: More than one Distribution accounts ' || l_account );
2535: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING ;
2536: return;
2537: elsif ( l_account is null ) then
2538: wsh_util_core.println ( 'Error: Cannot get Distribution account ' || l_account );
2539: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING ;

Line 2538: wsh_util_core.println ( 'Error: Cannot get Distribution account ' || l_account );

2534: wsh_util_core.println ( 'Error: More than one Distribution accounts ' || l_account );
2535: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING ;
2536: return;
2537: elsif ( l_account is null ) then
2538: wsh_util_core.println ( 'Error: Cannot get Distribution account ' || l_account );
2539: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING ;
2540: return;
2541: end if ;
2542:

Line 2539: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING ;

2535: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING ;
2536: return;
2537: elsif ( l_account is null ) then
2538: wsh_util_core.println ( 'Error: Cannot get Distribution account ' || l_account );
2539: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING ;
2540: return;
2541: end if ;
2542:
2543: wsh_util_core.println ( 'Distribution account is ' || l_account );

Line 2543: wsh_util_core.println ( 'Distribution account is ' || l_account );

2539: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING ;
2540: return;
2541: end if ;
2542:
2543: wsh_util_core.println ( 'Distribution account is ' || l_account );
2544: */
2545: if (l_detail_rec.source_code = 'OE') then
2546: if (WSH_SHIP_CONFIRM_ACTIONS.ont_source_code is NULL) then
2547: WSH_SHIP_CONFIRM_ACTIONS.ont_source_code := FND_PROFILE.VALUE('ONT_SOURCE_CODE');

Line 2891: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2887: OPEN c_order_line_info(l_detail_in_delivery.source_line_id);
2888: FETCH c_order_line_info into l_order_line_info;
2889: if (c_order_line_info%NOTFOUND) THEN
2890: CLOSE c_order_line_info;
2891: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2892: GMI_RESERVATION_UTIL.Println('Warning, Sales order not valid');
2893: CLOSE c_detail_in_delivery; /* B2886561 close this cursor before return */
2894: return;
2895: END if;

Line 2911: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2907: OPEN c_details_for_interface(l_detail_in_delivery.delivery_detail_id);
2908: FETCH c_details_for_interface into l_detail_rec;
2909: if c_details_for_interface%NOTFOUND then
2910: CLOSE c_details_for_interface;
2911: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2912: WSH_UTIL_CORE.Println('Warning, Delivery Detail ' ||l_detail_in_delivery.delivery_detail_id ||' not found');
2913: IF c_detail_in_delivery%ISOPEN THEN /* B2886561 close this cursor before return */
2914: CLOSE c_detail_in_delivery;
2915: END IF;

Line 2912: WSH_UTIL_CORE.Println('Warning, Delivery Detail ' ||l_detail_in_delivery.delivery_detail_id ||' not found');

2908: FETCH c_details_for_interface into l_detail_rec;
2909: if c_details_for_interface%NOTFOUND then
2910: CLOSE c_details_for_interface;
2911: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2912: WSH_UTIL_CORE.Println('Warning, Delivery Detail ' ||l_detail_in_delivery.delivery_detail_id ||' not found');
2913: IF c_detail_in_delivery%ISOPEN THEN /* B2886561 close this cursor before return */
2914: CLOSE c_detail_in_delivery;
2915: END IF;
2916: return;

Line 2924: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2920: OPEN c_trip_stop(p_stop_id);
2921: FETCH c_trip_stop into l_trip_stop_rec;
2922: if c_trip_stop%NOTFOUND then
2923: CLOSE c_trip_stop;
2924: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2925: WSH_UTIL_CORE.Println('Warning, Trip Stop '|| p_stop_id ||' not found');
2926: IF c_detail_in_delivery%ISOPEN THEN /* B2886561 close this cursor before return */
2927: CLOSE c_detail_in_delivery;
2928: END IF;

Line 2925: WSH_UTIL_CORE.Println('Warning, Trip Stop '|| p_stop_id ||' not found');

2921: FETCH c_trip_stop into l_trip_stop_rec;
2922: if c_trip_stop%NOTFOUND then
2923: CLOSE c_trip_stop;
2924: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2925: WSH_UTIL_CORE.Println('Warning, Trip Stop '|| p_stop_id ||' not found');
2926: IF c_detail_in_delivery%ISOPEN THEN /* B2886561 close this cursor before return */
2927: CLOSE c_detail_in_delivery;
2928: END IF;
2929: return;

Line 2946: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

2942: , x_msg_count => l_msg_count
2943: , x_msg_data => l_msg_data
2944: );
2945: oe_debug_pub.add('Finished calling GMI_Shipping_Util.create_rcv_transaction');
2946: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2947: WSH_UTIL_CORE.println('Warning ...');
2948: WSH_UTIL_CORE.println('Failed GMI_Shipping_Util.create_rcv_transaction for delivery ID '
2949: || l_detail_rec.DELIVERY_DETAIL_ID );
2950: x_return_status := l_return_status;

Line 2947: WSH_UTIL_CORE.println('Warning ...');

2943: , x_msg_data => l_msg_data
2944: );
2945: oe_debug_pub.add('Finished calling GMI_Shipping_Util.create_rcv_transaction');
2946: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2947: WSH_UTIL_CORE.println('Warning ...');
2948: WSH_UTIL_CORE.println('Failed GMI_Shipping_Util.create_rcv_transaction for delivery ID '
2949: || l_detail_rec.DELIVERY_DETAIL_ID );
2950: x_return_status := l_return_status;
2951: END IF;

Line 2948: WSH_UTIL_CORE.println('Failed GMI_Shipping_Util.create_rcv_transaction for delivery ID '

2944: );
2945: oe_debug_pub.add('Finished calling GMI_Shipping_Util.create_rcv_transaction');
2946: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2947: WSH_UTIL_CORE.println('Warning ...');
2948: WSH_UTIL_CORE.println('Failed GMI_Shipping_Util.create_rcv_transaction for delivery ID '
2949: || l_detail_rec.DELIVERY_DETAIL_ID );
2950: x_return_status := l_return_status;
2951: END IF;
2952:

Line 3451: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

3447: p_req_quantity2 => NVL(p_qty2_to_split,0),
3448: x_return_status => x_return_status,
3449: x_msg_count => x_msg_count,
3450: x_msg_data => x_msg_data );
3451: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3453: END IF;
3454: oe_debug_pub.add('Done calling update_opm_transaction',2);
3455: ELSE /* not staged */

Line 3467: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

3463: x_return_status => x_return_status,
3464: x_msg_count => x_msg_count,
3465: x_msg_data => x_msg_data
3466: );
3467: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3469: END IF;
3470: oe_debug_pub.add('Done calling split_trans',2);
3471:

Line 3653: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

3649: x_msg_data => x_msg_data,
3650: x_reservation_id => l_trans_id,
3651: p_line_id => p_old_source_line_id
3652: );
3653: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3654: GMI_RESERVATION_UTIL.println('Error returned by find default lot');
3655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3656: END IF;
3657:

Line 3690: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

3686: x_reservation_id => l_trans_id,
3687: p_line_id => p_new_source_line_id
3688: );
3689:
3690: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3691: GMI_RESERVATION_UTIL.println('Error returned by find default lot');
3692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3693: END IF;
3694:

Line 4198: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4194: and delete_mark = 0;
4195:
4196: BEGIN
4197:
4198: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4199:
4200: OPEN c_get_opm_txn;
4201: GMI_RESERVATION_UTIL.println('unreserve wdd ' || p_delivery_detail_id);
4202: --GMI_RESERVATION_UTIL.println('unreserve line_id ' || p_source_line_id);

Line 4375: , p_old_dd_ids IN WSH_UTIL_CORE.Id_Tab_Type

4371: -- Action is Cycle Count All
4372:
4373: PROCEDURE UPDATE_NEW_LINE_DETAIL_ID
4374: ( p_cons_dd_id IN NUMBER
4375: , p_old_dd_ids IN WSH_UTIL_CORE.Id_Tab_Type
4376: , x_return_status OUT NOCOPY VARCHAR2
4377: )
4378: IS
4379:

Line 4411: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4407:
4408:
4409: BEGIN
4410:
4411: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4412: gmi_reservation_util.println('In GMI_SHIPPING_UTIL.UPDATE_NEW_LINE_DETAIL_ID');
4413: gmi_reservation_util.println('Value of p_cons_dd_id is '||p_cons_dd_id);
4414:
4415: -- Find the source_line_id associated with the new consolidated

Line 4487: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4483: CLOSE GET_IC_RECORDS;
4484: END IF;
4485:
4486:
4487: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4488:
4489: gmi_reservation_util.println('Done calling GMI_SHIPPING_UTIL.UPDATE_NEW_LINE_DETAIL_ID');
4490:
4491: EXCEPTION