DBA Data[Home] [Help]

APPS.WSH_TMS_RELEASE dependencies on FND_API

Line 1788: p_init_msg_list => FND_API.G_TRUE,

1784: l_del_action_prms.trip_id := l_trip_info_tab(i).trip_id;
1785:
1786: WSH_DELIVERIES_GRP.delivery_action(
1787: p_api_version_number => 1.0,
1788: p_init_msg_list => FND_API.G_TRUE,
1789: p_commit => FND_API.G_FALSE,
1790: p_action_prms => l_del_action_prms,
1791: p_rec_attr_tab => l_del_attrs,
1792: x_delivery_out_rec => l_del_action_rec,

Line 1789: p_commit => FND_API.G_FALSE,

1785:
1786: WSH_DELIVERIES_GRP.delivery_action(
1787: p_api_version_number => 1.0,
1788: p_init_msg_list => FND_API.G_TRUE,
1789: p_commit => FND_API.G_FALSE,
1790: p_action_prms => l_del_action_prms,
1791: p_rec_attr_tab => l_del_attrs,
1792: x_delivery_out_rec => l_del_action_rec,
1793: x_defaults_rec => l_del_defaults,

Line 1881: p_init_msg_list => FND_API.G_TRUE,

1877: END IF;
1878:
1879: WSH_TRIPS_GRP.Create_Update_Trip(
1880: p_api_version_number => 1.0,
1881: p_init_msg_list => FND_API.G_TRUE,
1882: p_commit => FND_API.G_FALSE,
1883: x_return_status => l_rs,
1884: x_msg_count => l_msg_count,
1885: x_msg_data => l_msg_data,

Line 1882: p_commit => FND_API.G_FALSE,

1878:
1879: WSH_TRIPS_GRP.Create_Update_Trip(
1880: p_api_version_number => 1.0,
1881: p_init_msg_list => FND_API.G_TRUE,
1882: p_commit => FND_API.G_FALSE,
1883: x_return_status => l_rs,
1884: x_msg_count => l_msg_count,
1885: x_msg_data => l_msg_data,
1886: p_trip_info_tab => l_trip_input_tab,

Line 2247: p_init_msg_list => FND_API.G_TRUE,

2243: l_del_action_prms.trip_id := l_trip_info_tab(i).trip_id;
2244:
2245: WSH_DELIVERIES_GRP.delivery_action(
2246: p_api_version_number => 1.0,
2247: p_init_msg_list => FND_API.G_TRUE,
2248: p_commit => FND_API.G_FALSE,
2249: p_action_prms => l_del_action_prms,
2250: p_rec_attr_tab => l_del_attrs,
2251: x_delivery_out_rec => l_del_action_rec,

Line 2248: p_commit => FND_API.G_FALSE,

2244:
2245: WSH_DELIVERIES_GRP.delivery_action(
2246: p_api_version_number => 1.0,
2247: p_init_msg_list => FND_API.G_TRUE,
2248: p_commit => FND_API.G_FALSE,
2249: p_action_prms => l_del_action_prms,
2250: p_rec_attr_tab => l_del_attrs,
2251: x_delivery_out_rec => l_del_action_rec,
2252: x_defaults_rec => l_del_defaults,

Line 2279: p_init_msg_list => FND_API.G_TRUE,

2275: l_stop_attrs(1).trip_id := l_trip_info_tab(i).trip_id;
2276:
2277: WSH_TRIP_STOPS_GRP.stop_action(
2278: p_api_version_number => 1.0,
2279: p_init_msg_list => FND_API.G_TRUE,
2280: p_commit => FND_API.G_FALSE,
2281: p_action_prms => l_stop_action_prms,
2282: p_rec_attr_tab => l_stop_attrs,
2283: x_stop_out_rec => l_stop_action_rec,

Line 2280: p_commit => FND_API.G_FALSE,

2276:
2277: WSH_TRIP_STOPS_GRP.stop_action(
2278: p_api_version_number => 1.0,
2279: p_init_msg_list => FND_API.G_TRUE,
2280: p_commit => FND_API.G_FALSE,
2281: p_action_prms => l_stop_action_prms,
2282: p_rec_attr_tab => l_stop_attrs,
2283: x_stop_out_rec => l_stop_action_rec,
2284: x_def_rec => l_stop_defaults,

Line 2539: p_init_msg_list => FND_API.G_FALSE,

2535: END IF;
2536:
2537: wsh_trip_stops_grp.Create_Update_Stop(
2538: p_api_version_number => 1.0,
2539: p_init_msg_list => FND_API.G_FALSE,
2540: p_commit => FND_API.G_FALSE,
2541: p_in_rec => l_stop_in_rec,
2542: p_rec_attr_tab => l_stop_attrs,
2543: x_stop_out_tab => l_stop_out_tab,

Line 2540: p_commit => FND_API.G_FALSE,

2536:
2537: wsh_trip_stops_grp.Create_Update_Stop(
2538: p_api_version_number => 1.0,
2539: p_init_msg_list => FND_API.G_FALSE,
2540: p_commit => FND_API.G_FALSE,
2541: p_in_rec => l_stop_in_rec,
2542: p_rec_attr_tab => l_stop_attrs,
2543: x_stop_out_tab => l_stop_out_tab,
2544: x_return_status => l_rs,

Line 2883: p_init_msg_list => FND_API.G_TRUE,

2879: l_del_action_prms.trip_id := l_trip_info_tab(i).trip_id;
2880:
2881: WSH_DELIVERIES_GRP.delivery_action(
2882: p_api_version_number => 1.0,
2883: p_init_msg_list => FND_API.G_TRUE,
2884: p_commit => FND_API.G_FALSE,
2885: p_action_prms => l_del_action_prms,
2886: p_rec_attr_tab => l_del_attrs,
2887: x_delivery_out_rec => l_del_action_rec,

Line 2884: p_commit => FND_API.G_FALSE,

2880:
2881: WSH_DELIVERIES_GRP.delivery_action(
2882: p_api_version_number => 1.0,
2883: p_init_msg_list => FND_API.G_TRUE,
2884: p_commit => FND_API.G_FALSE,
2885: p_action_prms => l_del_action_prms,
2886: p_rec_attr_tab => l_del_attrs,
2887: x_delivery_out_rec => l_del_action_rec,
2888: x_defaults_rec => l_del_defaults,

Line 3048: p_init_msg_list => FND_API.G_TRUE,

3044: END IF;
3045:
3046: WSH_DELIVERIES_GRP.delivery_action(
3047: p_api_version_number => 1.0,
3048: p_init_msg_list => FND_API.G_TRUE,
3049: p_commit => FND_API.G_FALSE,
3050: p_action_prms => l_del_action_prms,
3051: p_rec_attr_tab => l_del_attrs,
3052: x_delivery_out_rec => l_del_action_rec,

Line 3049: p_commit => FND_API.G_FALSE,

3045:
3046: WSH_DELIVERIES_GRP.delivery_action(
3047: p_api_version_number => 1.0,
3048: p_init_msg_list => FND_API.G_TRUE,
3049: p_commit => FND_API.G_FALSE,
3050: p_action_prms => l_del_action_prms,
3051: p_rec_attr_tab => l_del_attrs,
3052: x_delivery_out_rec => l_del_action_rec,
3053: x_defaults_rec => l_del_defaults,

Line 3316: IF ( l_freight_info_tab(l_count).currency_code <> fnd_api.g_miss_char ) THEN--{

3312: END IF;
3313:
3314: -- Per ECO 5008405, Validate GC3 sent currency
3315: -- Need to adjust precision, dependent on WSHUTVLB new parameter
3316: IF ( l_freight_info_tab(l_count).currency_code <> fnd_api.g_miss_char ) THEN--{
3317: WSH_UTIL_VALIDATE.Validate_Currency(
3318: p_currency_code => l_freight_info_tab(l_count).currency_code,
3319: p_currency_name => NULL,
3320: p_amount => l_freight_info_tab(l_count).unit_amount,

Line 3517: p_init_msg_list => FND_API.G_TRUE,

3513: END IF;
3514:
3515: WSH_FREIGHT_COSTS_GRP.Create_Update_Freight_Costs
3516: (p_api_version_number => 1.0,
3517: p_init_msg_list => FND_API.G_TRUE,
3518: p_commit => FND_API.G_FALSE,
3519: p_freight_info_tab => l_freight_info_tab,
3520: p_in_rec => l_in_rec,
3521: x_out_tab => l_out_tab,

Line 3518: p_commit => FND_API.G_FALSE,

3514:
3515: WSH_FREIGHT_COSTS_GRP.Create_Update_Freight_Costs
3516: (p_api_version_number => 1.0,
3517: p_init_msg_list => FND_API.G_TRUE,
3518: p_commit => FND_API.G_FALSE,
3519: p_freight_info_tab => l_freight_info_tab,
3520: p_in_rec => l_in_rec,
3521: x_out_tab => l_out_tab,
3522: x_return_status => l_rs,

Line 3755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3751: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3752: IF l_debug_on THEN
3753: WSH_DEBUG_SV.log(l_module_name, 'purge_interface_data Failed');
3754: END IF;
3755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3756: END IF;
3757: -- OTM R12
3758:
3759: END IF;--}

Line 3787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3783: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3784: IF l_debug_on THEN
3785: WSH_DEBUG_SV.log(l_module_name, 'stamp_interface_error Failed');
3786: END IF;
3787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3788: END IF;
3789: -- OTM R12
3790:
3791: END IF;--} -- l_return_status = E

Line 3837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3833: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3834: IF l_debug_on THEN
3835: WSH_DEBUG_SV.log(l_module_name, 'WSH_XC_UTIL.log_exception Failed');
3836: END IF;
3837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3838: END IF;
3839: -- OTM R12
3840:
3841: END IF;

Line 3900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3896: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3897: IF l_debug_on THEN
3898: WSH_DEBUG_SV.log(l_module_name, 'WSH_XC_UTIL.Purge Failed');
3899: END IF;
3900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3901: END IF;
3902:
3903: -- OTM R12 populate record structure to call update_tms_interface_flag
3904: l_upd_dlvy_id_tab(l_upd_dlvy_id_tab.COUNT + 1) := l_dleg_local_tab(rec).delivery_id;

Line 3942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3938: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3939: IF l_debug_on THEN
3940: WSH_DEBUG_SV.log(l_module_name, 'purge_interface_data Failed');
3941: END IF;
3942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3943: END IF;
3944:
3945: l_success_trips := l_success_trips + 1;
3946:

Line 3986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3982: --l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3983: IF l_debug_on THEN
3984: WSH_DEBUG_SV.log(l_module_name, 'WSH_NEW_DELIVERIES_PVT.TABLE_TO_RECORD Failed');
3985: END IF;
3986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3987: END IF;
3988: -- OTM R12
3989:
3990:

Line 4075: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4071: WSH_DEBUG_SV.pop(l_module_name);
4072: END IF;
4073:
4074: EXCEPTION
4075: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4076: ROLLBACK TO process_group;
4077: --
4078: IF l_debug_on THEN
4079: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 4080: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

4076: ROLLBACK TO process_group;
4077: --
4078: IF l_debug_on THEN
4079: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4080: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4081: END IF;
4082: --
4083: -- Always concurrent request,no online option
4084: l_ret_code := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');

Line 4585: FND_MSG_PUB.get(p_encoded => FND_API.G_FALSE,

4581: IF l_debug_on THEN
4582: WSH_DEBUG_SV.logmsg(l_module_name,'C:'||i);
4583: END IF;
4584:
4585: FND_MSG_PUB.get(p_encoded => FND_API.G_FALSE,
4586: p_msg_index => i,
4587: p_data => l_buffer,
4588: p_msg_index_out => l_index_out);
4589:

Line 4901: p_init_msg_list => FND_API.G_TRUE,

4897: l_del_action_prms.trip_id := l_current_trip_id;
4898:
4899: WSH_DELIVERIES_GRP.delivery_action(
4900: p_api_version_number => 1.0,
4901: p_init_msg_list => FND_API.G_TRUE,
4902: p_commit => FND_API.G_FALSE,
4903: p_action_prms => l_del_action_prms,
4904: p_rec_attr_tab => l_del_attrs,
4905: x_delivery_out_rec => l_del_action_rec,

Line 4902: p_commit => FND_API.G_FALSE,

4898:
4899: WSH_DELIVERIES_GRP.delivery_action(
4900: p_api_version_number => 1.0,
4901: p_init_msg_list => FND_API.G_TRUE,
4902: p_commit => FND_API.G_FALSE,
4903: p_action_prms => l_del_action_prms,
4904: p_rec_attr_tab => l_del_attrs,
4905: x_delivery_out_rec => l_del_action_rec,
4906: x_defaults_rec => l_del_defaults,

Line 5404: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

5400: --
5401: IF l_debug_on THEN
5402: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5403: WSH_DEBUG_SV.logmsg(l_module_name,'-------------- END ----------------');
5404: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
5405: END IF;
5406: --
5407: END get_server_time;
5408: