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_SHIP_CONFIRM_ACTIONS dependencies on OE_SHIP_CONFIRMATION_PUB

Line 7303: p_ship_line IN OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type,

7299: --
7300: --========================================================================
7301:
7302: PROCEDURE print_ship_line (p_bulk_mode IN varchar2,
7303: p_ship_line IN OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type,
7304: p_start_index IN number default null,
7305: p_end_index IN number default null) IS
7306:
7307: l_debug_on BOOLEAN;

Line 7446: p_bulk_ship_line IN OUT NOCOPY OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type,

7442: --========================================================================
7443:
7444: PROCEDURE Process_Stop_To_OM (
7445: p_batch_id IN NUMBER,
7446: p_bulk_ship_line IN OUT NOCOPY OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type,
7447: p_bulk_req_line IN OUT NOCOPY OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type,
7448: p_bulk_mode IN varchar2,
7449: p_org_id IN NUMBER DEFAULT NULL,
7450: x_freight_costs IN OUT NOCOPY OE_Ship_Confirmation_Pub.Ship_Adj_Rec_Type,

Line 7447: p_bulk_req_line IN OUT NOCOPY OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type,

7443:
7444: PROCEDURE Process_Stop_To_OM (
7445: p_batch_id IN NUMBER,
7446: p_bulk_ship_line IN OUT NOCOPY OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type,
7447: p_bulk_req_line IN OUT NOCOPY OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type,
7448: p_bulk_mode IN varchar2,
7449: p_org_id IN NUMBER DEFAULT NULL,
7450: x_freight_costs IN OUT NOCOPY OE_Ship_Confirmation_Pub.Ship_Adj_Rec_Type,
7451: x_charges_are_calculated IN OUT NOCOPY BOOLEAN ,

Line 7450: x_freight_costs IN OUT NOCOPY OE_Ship_Confirmation_Pub.Ship_Adj_Rec_Type,

7446: p_bulk_ship_line IN OUT NOCOPY OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type,
7447: p_bulk_req_line IN OUT NOCOPY OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type,
7448: p_bulk_mode IN varchar2,
7449: p_org_id IN NUMBER DEFAULT NULL,
7450: x_freight_costs IN OUT NOCOPY OE_Ship_Confirmation_Pub.Ship_Adj_Rec_Type,
7451: x_charges_are_calculated IN OUT NOCOPY BOOLEAN ,
7452: x_return_status IN OUT NOCOPY varchar2) IS
7453:
7454: l_debug_on BOOLEAN;

Line 7465: l_ship_adj_line_all OE_Ship_Confirmation_Pub.Ship_Adj_Rec_Type;

7461: x_msg_count number;
7462: x_msg_data VARCHAR2(3000);
7463:
7464: l_freight_costs_all WSH_FC_INTERFACE_PKG.OMInterfaceCostTabType;
7465: l_ship_adj_line_all OE_Ship_Confirmation_Pub.Ship_Adj_Rec_Type;
7466: l_ship_adj_line OE_Ship_Confirmation_Pub.Ship_Adj_Rec_Type;
7467:
7468: l_total_count NUMBER:=0;
7469: l_start_index NUMBER;

Line 7466: l_ship_adj_line OE_Ship_Confirmation_Pub.Ship_Adj_Rec_Type;

7462: x_msg_data VARCHAR2(3000);
7463:
7464: l_freight_costs_all WSH_FC_INTERFACE_PKG.OMInterfaceCostTabType;
7465: l_ship_adj_line_all OE_Ship_Confirmation_Pub.Ship_Adj_Rec_Type;
7466: l_ship_adj_line OE_Ship_Confirmation_Pub.Ship_Adj_Rec_Type;
7467:
7468: l_total_count NUMBER:=0;
7469: l_start_index NUMBER;
7470: l_end_index NUMBER;

Line 7801: WSH_DEBUG_SV.log(l_module_name,'Calling OE_Ship_Confirmation_Pub.Ship_Confirm_New TIME:',SYSDATE);

7797: IF l_debug_on THEN
7798: WSH_DEBUG_SV.logmsg(l_module_name,'After Forall Update');
7799: WSH_DEBUG_SV.logmsg(l_module_name,'Printing P_ship_line_rec');
7800: print_ship_line(p_bulk_mode,p_bulk_ship_line,l_start_index,l_end_index);
7801: WSH_DEBUG_SV.log(l_module_name,'Calling OE_Ship_Confirmation_Pub.Ship_Confirm_New TIME:',SYSDATE);
7802: END IF;
7803: OE_Ship_Confirmation_Pub.Ship_Confirm_New(
7804: P_ship_line_rec => p_bulk_ship_line,
7805: P_requested_line_rec => p_bulk_req_line,

Line 7803: OE_Ship_Confirmation_Pub.Ship_Confirm_New(

7799: WSH_DEBUG_SV.logmsg(l_module_name,'Printing P_ship_line_rec');
7800: print_ship_line(p_bulk_mode,p_bulk_ship_line,l_start_index,l_end_index);
7801: WSH_DEBUG_SV.log(l_module_name,'Calling OE_Ship_Confirmation_Pub.Ship_Confirm_New TIME:',SYSDATE);
7802: END IF;
7803: OE_Ship_Confirmation_Pub.Ship_Confirm_New(
7804: P_ship_line_rec => p_bulk_ship_line,
7805: P_requested_line_rec => p_bulk_req_line,
7806: P_line_adj_rec => l_ship_adj_line,
7807: P_bulk_mode => p_bulk_mode,

Line 8240: p_ship_line IN OUT NOCOPY OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type,

8236: --
8237: --========================================================================
8238:
8239: PROCEDURE extend_om_ship_line (
8240: p_ship_line IN OUT NOCOPY OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type,
8241: x_return_status OUT NOCOPY VARCHAR2) IS
8242:
8243: l_debug_on BOOLEAN;
8244: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'extend_om_ship_line';

Line 8503: l_line_qtys OE_SHIP_CONFIRMATION_PUB.Req_Quantity_Tbl_Type;

8499: PRAGMA EXCEPTION_INIT(line_locked, -54);
8500:
8501:
8502: -- OM bug 2022029
8503: l_line_qtys OE_SHIP_CONFIRMATION_PUB.Req_Quantity_Tbl_Type;
8504:
8505: -- anxsharm for Load Tender
8506: l_trip_id_tab wsh_util_core.id_tab_type;
8507:

Line 8779: l_bulk_ship_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;

8775: dd.organization_id,
8776: NVL(dd.oe_interfaced_flag, 'N') ,
8777: dl.initial_pickup_date ;
8778:
8779: l_bulk_ship_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;
8780: l_bulk_req_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;
8781: l_non_bulk_ship_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;
8782: l_non_bulk_req_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;
8783:

Line 8780: l_bulk_req_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;

8776: NVL(dd.oe_interfaced_flag, 'N') ,
8777: dl.initial_pickup_date ;
8778:
8779: l_bulk_ship_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;
8780: l_bulk_req_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;
8781: l_non_bulk_ship_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;
8782: l_non_bulk_req_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;
8783:
8784: l_check_bulk VARCHAR2(1);

Line 8781: l_non_bulk_ship_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;

8777: dl.initial_pickup_date ;
8778:
8779: l_bulk_ship_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;
8780: l_bulk_req_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;
8781: l_non_bulk_ship_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;
8782: l_non_bulk_req_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;
8783:
8784: l_check_bulk VARCHAR2(1);
8785: l_prev_source_header_number VARCHAR2(150);

Line 8782: l_non_bulk_req_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;

8778:
8779: l_bulk_ship_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;
8780: l_bulk_req_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;
8781: l_non_bulk_ship_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;
8782: l_non_bulk_req_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;
8783:
8784: l_check_bulk VARCHAR2(1);
8785: l_prev_source_header_number VARCHAR2(150);
8786: l_bulk_count NUMBER:=0;

Line 8802: l_freight_costs OE_Ship_Confirmation_Pub.Ship_Adj_Rec_Type;

8798:
8799: l_org_id number;
8800: l_prev_org_id number;
8801: --HVOP heali
8802: l_freight_costs OE_Ship_Confirmation_Pub.Ship_Adj_Rec_Type;
8803: l_charges_are_calculated BOOLEAN DEFAULT FALSE;
8804: l_setsmc_input_rec OE_Shipping_Integration_PUB.Setsmc_Input_Rec_Type;
8805:
8806: oe_interface_rec c_oe_interface%ROWTYPE ;

Line 10814: l_bulk_ship_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;

10810: l_row_count NUMBER;
10811: l_end_index_nonbulk NUMBER;
10812: l_start_index_nonbulk NUMBER;
10813: l_row_count_nonbulk NUMBER;
10814: l_bulk_ship_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;
10815: l_non_bulk_ship_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;
10816: p_bulk_req_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;
10817: l_ship_adj_line OE_Ship_Confirmation_Pub.Ship_Adj_Rec_Type;
10818: i NUMBER:=0;

Line 10815: l_non_bulk_ship_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;

10811: l_end_index_nonbulk NUMBER;
10812: l_start_index_nonbulk NUMBER;
10813: l_row_count_nonbulk NUMBER;
10814: l_bulk_ship_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;
10815: l_non_bulk_ship_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;
10816: p_bulk_req_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;
10817: l_ship_adj_line OE_Ship_Confirmation_Pub.Ship_Adj_Rec_Type;
10818: i NUMBER:=0;
10819:

Line 10816: p_bulk_req_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;

10812: l_start_index_nonbulk NUMBER;
10813: l_row_count_nonbulk NUMBER;
10814: l_bulk_ship_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;
10815: l_non_bulk_ship_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;
10816: p_bulk_req_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;
10817: l_ship_adj_line OE_Ship_Confirmation_Pub.Ship_Adj_Rec_Type;
10818: i NUMBER:=0;
10819:
10820: /* Cursor should fetch the order lines which have ONLY shipped delivery details */

Line 10817: l_ship_adj_line OE_Ship_Confirmation_Pub.Ship_Adj_Rec_Type;

10813: l_row_count_nonbulk NUMBER;
10814: l_bulk_ship_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;
10815: l_non_bulk_ship_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;
10816: p_bulk_req_line OE_Ship_Confirmation_Pub.Ship_Line_Rec_Type;
10817: l_ship_adj_line OE_Ship_Confirmation_Pub.Ship_Adj_Rec_Type;
10818: i NUMBER:=0;
10819:
10820: /* Cursor should fetch the order lines which have ONLY shipped delivery details */
10821: CURSOR c_get_line_detail_to_interface(c_line_id NUMBER) IS

Line 11107: WSH_DEBUG_SV.log(l_module_name,'Calling OE_Ship_Confirmation_Pub.Ship_Confirm_New TIME:',SYSDATE);

11103: END IF;
11104:
11105: SAVEPOINT l_interface_om_bulk;
11106: IF l_debug_on THEN
11107: WSH_DEBUG_SV.log(l_module_name,'Calling OE_Ship_Confirmation_Pub.Ship_Confirm_New TIME:',SYSDATE);
11108: END IF;
11109:
11110: MO_GLOBAL.set_policy_context('S', l_bulk_ship_line.org_id(l_start_index));
11111: IF l_debug_on THEN

Line 11117: OE_Ship_Confirmation_Pub.Ship_Confirm_New(P_ship_line_rec => l_bulk_ship_line,

11113: END IF;
11114: l_loop_count := l_loop_count +1;
11115:
11116: /*Call OM API in bulk mode to interface wdd to OM*/
11117: OE_Ship_Confirmation_Pub.Ship_Confirm_New(P_ship_line_rec => l_bulk_ship_line,
11118: P_requested_line_rec => p_bulk_req_line,
11119: P_line_adj_rec => l_ship_adj_line,
11120: P_bulk_mode => 'Y',
11121: P_start_index => l_start_index,

Line 11177: WSH_DEBUG_SV.log(l_module_name,'Calling OE_Ship_Confirmation_Pub.Ship_Confirm_New TIME:',SYSDATE);

11173: WSH_DEBUG_SV.logmsg(l_module_name,'Establishing save point l_interface_om_non_bulk');
11174: END IF;
11175: SAVEPOINT l_interface_om_non_bulk;
11176: IF l_debug_on THEN
11177: WSH_DEBUG_SV.log(l_module_name,'Calling OE_Ship_Confirmation_Pub.Ship_Confirm_New TIME:',SYSDATE);
11178: END IF;
11179:
11180: MO_GLOBAL.set_policy_context('S', l_non_bulk_ship_line.org_id(l_start_index_nonbulk));
11181:

Line 11189: OE_Ship_Confirmation_Pub.Ship_Confirm_New(P_ship_line_rec => l_non_bulk_ship_line,

11185:
11186: l_loop_count := l_loop_count + 1;
11187:
11188: /*Call OM API in non bulk mode to interface WDD to OM*/
11189: OE_Ship_Confirmation_Pub.Ship_Confirm_New(P_ship_line_rec => l_non_bulk_ship_line,
11190: P_requested_line_rec => p_bulk_req_line,
11191: P_line_adj_rec => l_ship_adj_line,
11192: P_bulk_mode => 'N',
11193: P_start_index => l_start_index_nonbulk,