DBA Data[Home] [Help]

APPS.WSH_ASN_RECEIPT_PVT dependencies on WSH_PO_CMG_PVT

Line 1593: p_dd_list WSH_PO_CMG_PVT.dd_list_type;

1589:
1590: p_dd_info WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
1591: p_dd_assign_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_type;
1592:
1593: p_dd_list WSH_PO_CMG_PVT.dd_list_type;
1594: l_local_dd_rec LOCAL_DD_REC_TABLE_TYPE;
1595:
1596: l_parent_wdd_id NUMBER;
1597: l_return_status VARCHAR2(1);

Line 2130: -- WSH_PO_CMG_PVT.populate_additional_line_info API and then calling

2126:
2127: ELSE
2128: -- p_dd_rec.delivery_detail_id is null.Need to insert record into wsh_delivery_details.
2129: -- This is done by first populating addtional line information using
2130: -- WSH_PO_CMG_PVT.populate_additional_line_info API and then calling
2131: -- WSH_BULK_PROCESS_PVT.bulk_insert_details API to do the insert operation.
2132: --
2133: -- Debug Statements
2134: --

Line 2136: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PO_CMG_PVT.POPULATE_ADDITIONAL_LINE_INFO',WSH_DEBUG_SV.C_PROC_LEVEL);

2132: --
2133: -- Debug Statements
2134: --
2135: IF l_debug_on THEN
2136: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PO_CMG_PVT.POPULATE_ADDITIONAL_LINE_INFO',WSH_DEBUG_SV.C_PROC_LEVEL);
2137: END IF;
2138: --
2139: -- calling WSH_PO_CMG_PVT.populate_additional_line_info
2140: WSH_PO_CMG_PVT.populate_additional_line_info(

Line 2139: -- calling WSH_PO_CMG_PVT.populate_additional_line_info

2135: IF l_debug_on THEN
2136: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PO_CMG_PVT.POPULATE_ADDITIONAL_LINE_INFO',WSH_DEBUG_SV.C_PROC_LEVEL);
2137: END IF;
2138: --
2139: -- calling WSH_PO_CMG_PVT.populate_additional_line_info
2140: WSH_PO_CMG_PVT.populate_additional_line_info(
2141: p_line_rec => p_line_rec,
2142: p_index => p_dd_rec.shpmt_line_id_idx_tab(i),
2143: p_additional_line_info_rec => l_additional_line_info_rec ,

Line 2140: WSH_PO_CMG_PVT.populate_additional_line_info(

2136: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PO_CMG_PVT.POPULATE_ADDITIONAL_LINE_INFO',WSH_DEBUG_SV.C_PROC_LEVEL);
2137: END IF;
2138: --
2139: -- calling WSH_PO_CMG_PVT.populate_additional_line_info
2140: WSH_PO_CMG_PVT.populate_additional_line_info(
2141: p_line_rec => p_line_rec,
2142: p_index => p_dd_rec.shpmt_line_id_idx_tab(i),
2143: p_additional_line_info_rec => l_additional_line_info_rec ,
2144: x_return_status => l_return_status);

Line 2677: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PO_CMG_PVT.POPULATE_ADDITIONAL_LINE_INFO',WSH_DEBUG_SV.C_PROC_LEVEL);

2673: --
2674: -- Debug Statements
2675: --
2676: IF l_debug_on THEN
2677: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PO_CMG_PVT.POPULATE_ADDITIONAL_LINE_INFO',WSH_DEBUG_SV.C_PROC_LEVEL);
2678: END IF;
2679: --
2680: -- Calling WSH_PO_CMG_PVT.populate_additional_line_info
2681: WSH_PO_CMG_PVT.populate_additional_line_info(

Line 2680: -- Calling WSH_PO_CMG_PVT.populate_additional_line_info

2676: IF l_debug_on THEN
2677: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PO_CMG_PVT.POPULATE_ADDITIONAL_LINE_INFO',WSH_DEBUG_SV.C_PROC_LEVEL);
2678: END IF;
2679: --
2680: -- Calling WSH_PO_CMG_PVT.populate_additional_line_info
2681: WSH_PO_CMG_PVT.populate_additional_line_info(
2682: p_line_rec => p_line_rec,
2683: p_index => p_dd_rec.shpmt_line_id_idx_tab(i),
2684: p_additional_line_info_rec => l_additional_line_info_rec ,

Line 2681: WSH_PO_CMG_PVT.populate_additional_line_info(

2677: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PO_CMG_PVT.POPULATE_ADDITIONAL_LINE_INFO',WSH_DEBUG_SV.C_PROC_LEVEL);
2678: END IF;
2679: --
2680: -- Calling WSH_PO_CMG_PVT.populate_additional_line_info
2681: WSH_PO_CMG_PVT.populate_additional_line_info(
2682: p_line_rec => p_line_rec,
2683: p_index => p_dd_rec.shpmt_line_id_idx_tab(i),
2684: p_additional_line_info_rec => l_additional_line_info_rec ,
2685: x_return_status => l_return_status);

Line 3524: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PO_CMG_PVT.REAPPROVE_PO',WSH_DEBUG_SV.C_PROC_LEVEL);

3520: --
3521: -- Debug Statements
3522: --
3523: IF l_debug_on THEN
3524: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PO_CMG_PVT.REAPPROVE_PO',WSH_DEBUG_SV.C_PROC_LEVEL);
3525: END IF;
3526: --
3527: WSH_PO_CMG_PVT.Reapprove_PO(
3528: p_line_rec => p_line_rec,

Line 3527: WSH_PO_CMG_PVT.Reapprove_PO(

3523: IF l_debug_on THEN
3524: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PO_CMG_PVT.REAPPROVE_PO',WSH_DEBUG_SV.C_PROC_LEVEL);
3525: END IF;
3526: --
3527: WSH_PO_CMG_PVT.Reapprove_PO(
3528: p_line_rec => p_line_rec,
3529: p_action_prms => l_action_prms,
3530: p_dd_list => p_dd_list,
3531: x_return_status => l_return_status);

Line 3795: l_dd_list WSH_PO_CMG_PVT.dd_list_type;

3791: WHERE ASN_SHIPMENT_HEADER_ID = p_header_id;
3792:
3793: l_line_rec OE_WSH_BULK_GRP.line_rec_type;
3794: l_max_txn_id NUMBER;
3795: l_dd_list WSH_PO_CMG_PVT.dd_list_type;
3796: l_Stop_ids wsh_util_core.Id_Tab_Type;
3797: l_Trip_ids wsh_util_core.Id_Tab_Type;
3798: l_Delivery_ids wsh_util_core.Id_Tab_Type;
3799: l_sf_locn_id_tbl wsh_util_core.Id_Tab_Type;

Line 3937: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PO_CMG_PVT.REAPPROVE_PO',WSH_DEBUG_SV.C_PROC_LEVEL);

3933: --
3934: -- Debug Statements
3935: --
3936: IF l_debug_on THEN
3937: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PO_CMG_PVT.REAPPROVE_PO',WSH_DEBUG_SV.C_PROC_LEVEL);
3938: END IF;
3939: --
3940: l_action_prms.action_code := 'CANCEL_ASN';
3941:

Line 3945: WSH_PO_CMG_PVT.Reapprove_PO(

3941:
3942: -- Call Reapprove_PO with action code as 'CANCEL_ASN'.
3943: -- This will inturn call Update_Atributes to update the non quantity attributes.
3944:
3945: WSH_PO_CMG_PVT.Reapprove_PO(
3946: p_line_rec => l_line_rec,
3947: p_action_prms => l_action_prms,
3948: p_dd_list => l_dd_list,
3949: x_return_status => l_return_status);

Line 4504: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PO_CMG_PVT.LOG_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);

4500: --
4501: -- Debug Statements
4502: --
4503: IF l_debug_on THEN
4504: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PO_CMG_PVT.LOG_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);
4505: END IF;
4506: --
4507: WSH_PO_CMG_PVT.Log_Exception(
4508: p_entity_id => p_del_ids(i),

Line 4507: WSH_PO_CMG_PVT.Log_Exception(

4503: IF l_debug_on THEN
4504: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PO_CMG_PVT.LOG_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);
4505: END IF;
4506: --
4507: WSH_PO_CMG_PVT.Log_Exception(
4508: p_entity_id => p_del_ids(i),
4509: p_logging_entity_name => 'DELIVERY_ID',
4510: p_exception_name => 'WSH_IB_DEL_CHANGE',
4511: x_return_status => l_return_status);

Line 8085: -- Function : This API calls the WSH_PO_CMG_PVT.close_cancel_po with two sets of data

8081: -- Start of comments
8082: -- API name : cancel_close_pending_txns
8083: -- Type : Public
8084: -- Pre-reqs : None.
8085: -- Function : This API calls the WSH_PO_CMG_PVT.close_cancel_po with two sets of data
8086: -- which were collected in the API WSH_ASN_RECEIPT_PVT.Process_Matched_Txns
8087: -- .These(two sets of data) contain rows which were tried to be closed or
8088: -- cancelled when txns were pending against them and therefore those lines
8089: -- have to be closed when the txns have been matched.This job is taken care

Line 8154: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PO_CMG_PVT.CANCEL_CLOSE_PO',WSH_DEBUG_SV.C_PROC_LEVEL);

8150: --
8151: -- Debug Statements
8152: --
8153: IF l_debug_on THEN
8154: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PO_CMG_PVT.CANCEL_CLOSE_PO',WSH_DEBUG_SV.C_PROC_LEVEL);
8155:
8156: END IF;
8157: --
8158: l_action_prms.action_code := 'CANCEL_PO';

Line 8159: --Call API WSH_PO_CMG_PVT.cancel_close_po

8155:
8156: END IF;
8157: --
8158: l_action_prms.action_code := 'CANCEL_PO';
8159: --Call API WSH_PO_CMG_PVT.cancel_close_po
8160: WSH_PO_CMG_PVT.cancel_close_po(
8161: p_line_rec => p_po_cancel_rec,
8162: p_action_prms => l_action_prms,
8163: x_return_status => l_return_status);

Line 8160: WSH_PO_CMG_PVT.cancel_close_po(

8156: END IF;
8157: --
8158: l_action_prms.action_code := 'CANCEL_PO';
8159: --Call API WSH_PO_CMG_PVT.cancel_close_po
8160: WSH_PO_CMG_PVT.cancel_close_po(
8161: p_line_rec => p_po_cancel_rec,
8162: p_action_prms => l_action_prms,
8163: x_return_status => l_return_status);
8164: --

Line 8185: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PO_CMG_PVT.CANCEL_CLOSE_PO',WSH_DEBUG_SV.C_PROC_LEVEL);

8181: --
8182: -- Debug Statements
8183: --
8184: IF l_debug_on THEN
8185: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PO_CMG_PVT.CANCEL_CLOSE_PO',WSH_DEBUG_SV.C_PROC_LEVEL);
8186: END IF;
8187: --
8188: l_action_prms.action_code := 'CLOSE_PO';
8189: --

Line 8190: --Call API WSH_PO_CMG_PVT.cancel_close_po

8186: END IF;
8187: --
8188: l_action_prms.action_code := 'CLOSE_PO';
8189: --
8190: --Call API WSH_PO_CMG_PVT.cancel_close_po
8191: WSH_PO_CMG_PVT.cancel_close_po(
8192: p_line_rec => p_po_close_rec,
8193: p_action_prms => l_action_prms,
8194: x_return_status => l_return_status);

Line 8191: WSH_PO_CMG_PVT.cancel_close_po(

8187: --
8188: l_action_prms.action_code := 'CLOSE_PO';
8189: --
8190: --Call API WSH_PO_CMG_PVT.cancel_close_po
8191: WSH_PO_CMG_PVT.cancel_close_po(
8192: p_line_rec => p_po_close_rec,
8193: p_action_prms => l_action_prms,
8194: x_return_status => l_return_status);
8195: --