1792: l_del_action_prms.trip_id := l_trip_info_tab(i).trip_id;
1793:
1794: WSH_DELIVERIES_GRP.delivery_action(
1795: p_api_version_number => 1.0,
1796: p_init_msg_list => FND_API.G_TRUE,
1797: p_commit => FND_API.G_FALSE,
1798: p_action_prms => l_del_action_prms,
1799: p_rec_attr_tab => l_del_attrs,
1800: x_delivery_out_rec => l_del_action_rec,
1793:
1794: WSH_DELIVERIES_GRP.delivery_action(
1795: p_api_version_number => 1.0,
1796: p_init_msg_list => FND_API.G_TRUE,
1797: p_commit => FND_API.G_FALSE,
1798: p_action_prms => l_del_action_prms,
1799: p_rec_attr_tab => l_del_attrs,
1800: x_delivery_out_rec => l_del_action_rec,
1801: x_defaults_rec => l_del_defaults,
1885: END IF;
1886:
1887: WSH_TRIPS_GRP.Create_Update_Trip(
1888: p_api_version_number => 1.0,
1889: p_init_msg_list => FND_API.G_TRUE,
1890: p_commit => FND_API.G_FALSE,
1891: x_return_status => l_rs,
1892: x_msg_count => l_msg_count,
1893: x_msg_data => l_msg_data,
1886:
1887: WSH_TRIPS_GRP.Create_Update_Trip(
1888: p_api_version_number => 1.0,
1889: p_init_msg_list => FND_API.G_TRUE,
1890: p_commit => FND_API.G_FALSE,
1891: x_return_status => l_rs,
1892: x_msg_count => l_msg_count,
1893: x_msg_data => l_msg_data,
1894: p_trip_info_tab => l_trip_input_tab,
2251: l_del_action_prms.trip_id := l_trip_info_tab(i).trip_id;
2252:
2253: WSH_DELIVERIES_GRP.delivery_action(
2254: p_api_version_number => 1.0,
2255: p_init_msg_list => FND_API.G_TRUE,
2256: p_commit => FND_API.G_FALSE,
2257: p_action_prms => l_del_action_prms,
2258: p_rec_attr_tab => l_del_attrs,
2259: x_delivery_out_rec => l_del_action_rec,
2252:
2253: WSH_DELIVERIES_GRP.delivery_action(
2254: p_api_version_number => 1.0,
2255: p_init_msg_list => FND_API.G_TRUE,
2256: p_commit => FND_API.G_FALSE,
2257: p_action_prms => l_del_action_prms,
2258: p_rec_attr_tab => l_del_attrs,
2259: x_delivery_out_rec => l_del_action_rec,
2260: x_defaults_rec => l_del_defaults,
2283: l_stop_attrs(1).trip_id := l_trip_info_tab(i).trip_id;
2284:
2285: WSH_TRIP_STOPS_GRP.stop_action(
2286: p_api_version_number => 1.0,
2287: p_init_msg_list => FND_API.G_TRUE,
2288: p_commit => FND_API.G_FALSE,
2289: p_action_prms => l_stop_action_prms,
2290: p_rec_attr_tab => l_stop_attrs,
2291: x_stop_out_rec => l_stop_action_rec,
2284:
2285: WSH_TRIP_STOPS_GRP.stop_action(
2286: p_api_version_number => 1.0,
2287: p_init_msg_list => FND_API.G_TRUE,
2288: p_commit => FND_API.G_FALSE,
2289: p_action_prms => l_stop_action_prms,
2290: p_rec_attr_tab => l_stop_attrs,
2291: x_stop_out_rec => l_stop_action_rec,
2292: x_def_rec => l_stop_defaults,
2543: END IF;
2544:
2545: wsh_trip_stops_grp.Create_Update_Stop(
2546: p_api_version_number => 1.0,
2547: p_init_msg_list => FND_API.G_FALSE,
2548: p_commit => FND_API.G_FALSE,
2549: p_in_rec => l_stop_in_rec,
2550: p_rec_attr_tab => l_stop_attrs,
2551: x_stop_out_tab => l_stop_out_tab,
2544:
2545: wsh_trip_stops_grp.Create_Update_Stop(
2546: p_api_version_number => 1.0,
2547: p_init_msg_list => FND_API.G_FALSE,
2548: p_commit => FND_API.G_FALSE,
2549: p_in_rec => l_stop_in_rec,
2550: p_rec_attr_tab => l_stop_attrs,
2551: x_stop_out_tab => l_stop_out_tab,
2552: x_return_status => l_rs,
2887: l_del_action_prms.trip_id := l_trip_info_tab(i).trip_id;
2888:
2889: WSH_DELIVERIES_GRP.delivery_action(
2890: p_api_version_number => 1.0,
2891: p_init_msg_list => FND_API.G_TRUE,
2892: p_commit => FND_API.G_FALSE,
2893: p_action_prms => l_del_action_prms,
2894: p_rec_attr_tab => l_del_attrs,
2895: x_delivery_out_rec => l_del_action_rec,
2888:
2889: WSH_DELIVERIES_GRP.delivery_action(
2890: p_api_version_number => 1.0,
2891: p_init_msg_list => FND_API.G_TRUE,
2892: p_commit => FND_API.G_FALSE,
2893: p_action_prms => l_del_action_prms,
2894: p_rec_attr_tab => l_del_attrs,
2895: x_delivery_out_rec => l_del_action_rec,
2896: x_defaults_rec => l_del_defaults,
3052: END IF;
3053:
3054: WSH_DELIVERIES_GRP.delivery_action(
3055: p_api_version_number => 1.0,
3056: p_init_msg_list => FND_API.G_TRUE,
3057: p_commit => FND_API.G_FALSE,
3058: p_action_prms => l_del_action_prms,
3059: p_rec_attr_tab => l_del_attrs,
3060: x_delivery_out_rec => l_del_action_rec,
3053:
3054: WSH_DELIVERIES_GRP.delivery_action(
3055: p_api_version_number => 1.0,
3056: p_init_msg_list => FND_API.G_TRUE,
3057: p_commit => FND_API.G_FALSE,
3058: p_action_prms => l_del_action_prms,
3059: p_rec_attr_tab => l_del_attrs,
3060: x_delivery_out_rec => l_del_action_rec,
3061: x_defaults_rec => l_del_defaults,
3320: END IF;
3321:
3322: -- Per ECO 5008405, Validate GC3 sent currency
3323: -- Need to adjust precision, dependent on WSHUTVLB new parameter
3324: IF ( l_freight_info_tab(l_count).currency_code <> fnd_api.g_miss_char ) THEN--{
3325: WSH_UTIL_VALIDATE.Validate_Currency(
3326: p_currency_code => l_freight_info_tab(l_count).currency_code,
3327: p_currency_name => NULL,
3328: p_amount => l_freight_info_tab(l_count).unit_amount,
3521: END IF;
3522:
3523: WSH_FREIGHT_COSTS_GRP.Create_Update_Freight_Costs
3524: (p_api_version_number => 1.0,
3525: p_init_msg_list => FND_API.G_TRUE,
3526: p_commit => FND_API.G_FALSE,
3527: p_freight_info_tab => l_freight_info_tab,
3528: p_in_rec => l_in_rec,
3529: x_out_tab => l_out_tab,
3522:
3523: WSH_FREIGHT_COSTS_GRP.Create_Update_Freight_Costs
3524: (p_api_version_number => 1.0,
3525: p_init_msg_list => FND_API.G_TRUE,
3526: p_commit => FND_API.G_FALSE,
3527: p_freight_info_tab => l_freight_info_tab,
3528: p_in_rec => l_in_rec,
3529: x_out_tab => l_out_tab,
3530: x_return_status => l_rs,
3759: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3760: IF l_debug_on THEN
3761: WSH_DEBUG_SV.log(l_module_name, 'purge_interface_data Failed');
3762: END IF;
3763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3764: END IF;
3765: -- OTM R12
3766:
3767: END IF;--}
3791: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3792: IF l_debug_on THEN
3793: WSH_DEBUG_SV.log(l_module_name, 'stamp_interface_error Failed');
3794: END IF;
3795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3796: END IF;
3797: -- OTM R12
3798:
3799: END IF;--} -- l_return_status = E
3841: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3842: IF l_debug_on THEN
3843: WSH_DEBUG_SV.log(l_module_name, 'WSH_XC_UTIL.log_exception Failed');
3844: END IF;
3845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3846: END IF;
3847: -- OTM R12
3848:
3849: END IF;
3904: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3905: IF l_debug_on THEN
3906: WSH_DEBUG_SV.log(l_module_name, 'WSH_XC_UTIL.Purge Failed');
3907: END IF;
3908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3909: END IF;
3910:
3911: -- OTM R12 populate record structure to call update_tms_interface_flag
3912: l_upd_dlvy_id_tab(l_upd_dlvy_id_tab.COUNT + 1) := l_dleg_local_tab(rec).delivery_id;
3946: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3947: IF l_debug_on THEN
3948: WSH_DEBUG_SV.log(l_module_name, 'purge_interface_data Failed');
3949: END IF;
3950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3951: END IF;
3952:
3953: l_success_trips := l_success_trips + 1;
3954:
3990: --l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3991: IF l_debug_on THEN
3992: WSH_DEBUG_SV.log(l_module_name, 'WSH_NEW_DELIVERIES_PVT.TABLE_TO_RECORD Failed');
3993: END IF;
3994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3995: END IF;
3996: -- OTM R12
3997:
3998:
4079: WSH_DEBUG_SV.pop(l_module_name);
4080: END IF;
4081:
4082: EXCEPTION
4083: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4084: ROLLBACK TO process_group;
4085: --
4086: IF l_debug_on THEN
4087: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4084: ROLLBACK TO process_group;
4085: --
4086: IF l_debug_on THEN
4087: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4088: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4089: END IF;
4090: --
4091: -- Always concurrent request,no online option
4092: l_ret_code := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');
4589: IF l_debug_on THEN
4590: WSH_DEBUG_SV.logmsg(l_module_name,'C:'||i);
4591: END IF;
4592:
4593: FND_MSG_PUB.get(p_encoded => FND_API.G_FALSE,
4594: p_msg_index => i,
4595: p_data => l_buffer,
4596: p_msg_index_out => l_index_out);
4597:
4905: l_del_action_prms.trip_id := l_current_trip_id;
4906:
4907: WSH_DELIVERIES_GRP.delivery_action(
4908: p_api_version_number => 1.0,
4909: p_init_msg_list => FND_API.G_TRUE,
4910: p_commit => FND_API.G_FALSE,
4911: p_action_prms => l_del_action_prms,
4912: p_rec_attr_tab => l_del_attrs,
4913: x_delivery_out_rec => l_del_action_rec,
4906:
4907: WSH_DELIVERIES_GRP.delivery_action(
4908: p_api_version_number => 1.0,
4909: p_init_msg_list => FND_API.G_TRUE,
4910: p_commit => FND_API.G_FALSE,
4911: p_action_prms => l_del_action_prms,
4912: p_rec_attr_tab => l_del_attrs,
4913: x_delivery_out_rec => l_del_action_rec,
4914: x_defaults_rec => l_del_defaults,
5408: --
5409: IF l_debug_on THEN
5410: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5411: WSH_DEBUG_SV.logmsg(l_module_name,'-------------- END ----------------');
5412: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
5413: END IF;
5414: --
5415: END get_server_time;
5416: