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_FREIGHT_COSTS_GRP dependencies on WSH_UTIL_CORE

Line 40: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

36: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE',P_FREIGHT_COST_TYPE);
37: WSH_DEBUG_SV.log(l_module_name,'X_FREIGHT_COST_TYPE_ID',X_FREIGHT_COST_TYPE_ID);
38: END IF;
39: --
40: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
41:
42: IF (x_freight_cost_type_id IS NULL) THEN
43: IF (p_freight_cost_type <> FND_API.G_MISS_CHAR) THEN
44: SELECT freight_cost_type_id INTO x_freight_cost_type_id

Line 71: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

67: END IF;
68: --
69: EXCEPTION
70: WHEN No_Data_Found THEN
71: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
72: --
73: IF l_debug_on THEN
74: WSH_DEBUG_SV.logmsg(l_module_name,'NO_DATA_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
75: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');

Line 79: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

75: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
76: END IF;
77: --
78: WHEN Invalid_Type THEN
79: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
80: --
81: IF l_debug_on THEN
82: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_TYPE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
83: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_TYPE');

Line 87: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

83: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_TYPE');
84: END IF;
85: --
86: WHEN others THEN
87: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
88: --
89: IF l_debug_on THEN
90: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
91: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 130: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

126: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
127: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
128: END IF;
129: --
130: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
131:
132: WSH_FREIGHT_COSTS_PVT.Delete_freight_cost(
133: p_rowid => NULL,
134: p_freight_cost_id => p_pub_freight_costs.freight_cost_id,

Line 193: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

189: WSH_DEBUG_SV.log(l_module_name,'p_grp_freight_rec.FREIGHT_COST_ID',p_grp_freight_rec.FREIGHT_COST_ID);
190: WSH_DEBUG_SV.log(l_module_name,'p_grp_freight_rec.FREIGHT_COST_TYPE_ID',p_grp_freight_rec.FREIGHT_COST_TYPE_ID);
191: END IF;
192: --
193: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
194:
195: x_pvt_freight_rec.FREIGHT_COST_ID := p_grp_freight_rec.FREIGHT_COST_ID;
196: x_pvt_freight_rec.FREIGHT_COST_TYPE_ID := p_grp_freight_rec.FREIGHT_COST_TYPE_ID;
197: x_pvt_freight_rec.UNIT_AMOUNT := p_grp_freight_rec.UNIT_AMOUNT;

Line 257: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_FTE_INTEGRATION.map_freightgrp_to_pvt',l_module_name);

253: END IF;
254: --
255: EXCEPTION
256: WHEN OTHERS THEN
257: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_FTE_INTEGRATION.map_freightgrp_to_pvt',l_module_name);
258: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
259: --
260: IF l_debug_on THEN
261: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 258: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

254: --
255: EXCEPTION
256: WHEN OTHERS THEN
257: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_FTE_INTEGRATION.map_freightgrp_to_pvt',l_module_name);
258: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
259: --
260: IF l_debug_on THEN
261: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
262: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 279: l_disabled_list WSH_UTIL_CORE.column_tab_type;

275:
276: l_debug_on BOOLEAN;
277: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_DISABLED_LIST';
278:
279: l_disabled_list WSH_UTIL_CORE.column_tab_type;
280: l_db_col_rec WSH_TRIPS_PVT.trip_rec_type;
281: l_return_status VARCHAR2(30);
282: l_field_name VARCHAR2(100);
283: l_conversion_type VARCHAR2(100); --Bugfix 8736256

Line 401: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

397:
398: EXCEPTION
399: WHEN NO_DATA_FOUND THEN
400:
401: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
402: --
403: IF l_debug_on THEN
404: WSH_DEBUG_SV.logmsg(l_module_name,'NO_DATA_FOUND exception has occurred for conversion type.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
405: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');

Line 647: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

643: END IF;
644:
645: EXCEPTION
646: WHEN e_dp_no_entity THEN
647: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
648:
649: -- Added for bug 13590798
650: WHEN missing_freight_cost_id THEN
651: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 651: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

647: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
648:
649: -- Added for bug 13590798
650: WHEN missing_freight_cost_id THEN
651: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
652:
653: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
654: FND_MSG_PUB.Add_Exc_Msg (
655: G_PKG_NAME,

Line 667: wsh_util_core.default_handler('WSH_FREIGHT_COSTS_GRP.get_disabled_list',l_module_name);

663: END IF;
664: --
665:
666: WHEN OTHERS THEN
667: wsh_util_core.default_handler('WSH_FREIGHT_COSTS_GRP.get_disabled_list',l_module_name);
668: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
669: IF l_debug_on THEN
670: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
671: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 668: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

664: --
665:
666: WHEN OTHERS THEN
667: wsh_util_core.default_handler('WSH_FREIGHT_COSTS_GRP.get_disabled_list',l_module_name);
668: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
669: IF l_debug_on THEN
670: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
671: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
672: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 760: l_valid_index_tab wsh_util_core.id_tab_type;

756: l_del_rec_tab WSH_DELIVERY_VALIDATIONS.dlvy_rec_tab_type;
757: l_trip_rec_tab WSH_TRIP_VALIDATIONS.trip_rec_tab_type;
758: l_stop_rec_tab WSH_TRIP_STOPS_VALIDATIONS.stop_rec_tab_type;
759:
760: l_valid_index_tab wsh_util_core.id_tab_type;
761: l_valid_id_tab wsh_util_core.id_tab_type;
762: l_error_ids wsh_util_core.id_tab_type;
763: --J-IB-JCKWOK
764:

Line 761: l_valid_id_tab wsh_util_core.id_tab_type;

757: l_trip_rec_tab WSH_TRIP_VALIDATIONS.trip_rec_tab_type;
758: l_stop_rec_tab WSH_TRIP_STOPS_VALIDATIONS.stop_rec_tab_type;
759:
760: l_valid_index_tab wsh_util_core.id_tab_type;
761: l_valid_id_tab wsh_util_core.id_tab_type;
762: l_error_ids wsh_util_core.id_tab_type;
763: --J-IB-JCKWOK
764:
765: l_currency_code VARCHAR2(30);

Line 762: l_error_ids wsh_util_core.id_tab_type;

758: l_stop_rec_tab WSH_TRIP_STOPS_VALIDATIONS.stop_rec_tab_type;
759:
760: l_valid_index_tab wsh_util_core.id_tab_type;
761: l_valid_id_tab wsh_util_core.id_tab_type;
762: l_error_ids wsh_util_core.id_tab_type;
763: --J-IB-JCKWOK
764:
765: l_currency_code VARCHAR2(30);
766: l_amount NUMBER;

Line 824: wsh_util_core.add_message(x_return_status,l_module_name);

820:
821: IF (p_in_rec.caller IS NULL) THEN
822: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
823: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_in_rec.caller');
824: wsh_util_core.add_message(x_return_status,l_module_name);
825: raise fnd_api.g_exc_error;
826: END IF;
827: IF (nvl(p_in_rec.phase,1) <> 1) THEN
828: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');

Line 830: wsh_util_core.add_message(x_return_status,l_module_name);

826: END IF;
827: IF (nvl(p_in_rec.phase,1) <> 1) THEN
828: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
829: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_in_rec.phase');
830: wsh_util_core.add_message(x_return_status,l_module_name);
831: raise fnd_api.g_exc_error;
832: END IF;
833: IF (p_in_rec.action_code IS NULL OR p_in_rec.action_code NOT IN ('CREATE','UPDATE') ) THEN
834: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');

Line 836: wsh_util_core.add_message(x_return_status,l_module_name);

832: END IF;
833: IF (p_in_rec.action_code IS NULL OR p_in_rec.action_code NOT IN ('CREATE','UPDATE') ) THEN
834: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
835: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_in_rec.action_code');
836: wsh_util_core.add_message(x_return_status,l_module_name);
837: raise fnd_api.g_exc_error;
838: END IF;
839:
840: WSH_ACTIONS_LEVELS.set_validation_level (

Line 857: WSH_UTIL_CORE.api_post_call(p_return_status => l_return_status,

853: WSH_DEBUG_SV.log(l_module_name,'C_FREIGHT_COST_TYPE_LVL',WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FREIGHT_COST_TYPE_LVL));
854: WSH_DEBUG_SV.log(l_module_name,'C_ACTION_ENABLED_LVL',WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_ACTION_ENABLED_LVL));
855: END IF;
856:
857: WSH_UTIL_CORE.api_post_call(p_return_status => l_return_status,
858: x_num_warnings =>l_num_warnings,
859: x_num_errors =>l_num_errors);
860:
861: l_freight_info_tab:=p_freight_info_tab;

Line 883: WSH_UTIL_CORE.api_post_call(p_return_status => l_return_status,

879: x_return_status => l_return_status);
880: END IF;
881:
882:
883: WSH_UTIL_CORE.api_post_call(p_return_status => l_return_status,
884: x_num_warnings =>l_num_warnings,
885: x_num_errors =>l_num_errors);
886:
887: IF (WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FREIGHT_COST_TYPE_LVL)=1) THEN

Line 891: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

887: IF (WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FREIGHT_COST_TYPE_LVL)=1) THEN
888: IF (l_freight_info_tab(l_index).freight_cost_type IS NULL AND
889: l_freight_info_tab(l_index).freight_cost_type_id IS NULL) THEN
890:
891: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
892: WSH_UTIL_CORE.api_post_call(p_return_status => l_return_status,
893: x_num_warnings =>l_num_warnings,
894: x_num_errors =>l_num_errors,
895: p_module_name => l_module_name,

Line 892: WSH_UTIL_CORE.api_post_call(p_return_status => l_return_status,

888: IF (l_freight_info_tab(l_index).freight_cost_type IS NULL AND
889: l_freight_info_tab(l_index).freight_cost_type_id IS NULL) THEN
890:
891: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
892: WSH_UTIL_CORE.api_post_call(p_return_status => l_return_status,
893: x_num_warnings =>l_num_warnings,
894: x_num_errors =>l_num_errors,
895: p_module_name => l_module_name,
896: p_msg_data => 'WSH_REQUIRED_FIELD_NULL',

Line 908: WSH_UTIL_CORE.api_post_call(

904: IF l_debug_on THEN
905: WSH_DEBUG_SV.log(l_module_name,'validate_freight_cost_type l_return_status',l_return_status);
906: END IF;
907:
908: WSH_UTIL_CORE.api_post_call(
909: p_return_status => l_return_status,
910: x_num_warnings => l_num_warnings,
911: x_num_errors => l_num_errors,
912: p_module_name => l_module_name,

Line 940: WSH_UTIL_CORE.api_post_call(

936: --
937: IF l_debug_on THEN
938: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_Negative x_return_status',l_return_status);
939: END IF;
940: WSH_UTIL_CORE.api_post_call(
941: p_return_status => l_return_status,
942: x_num_warnings => l_num_warnings,
943: x_num_errors => l_num_errors,
944: p_module_name => l_module_name,

Line 960: WSH_UTIL_CORE.api_post_call(

956: --
957: IF l_debug_on THEN
958: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_Negative x_return_status',l_return_status);
959: END IF;
960: WSH_UTIL_CORE.api_post_call(
961: p_return_status => l_return_status,
962: x_num_warnings => l_num_warnings,
963: x_num_errors => l_num_errors,
964: p_module_name => l_module_name,

Line 983: WSH_UTIL_CORE.api_post_call(

979: IF l_debug_on THEN
980: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_Currency l_return_status',l_return_status);
981: END IF;
982:
983: WSH_UTIL_CORE.api_post_call(
984: p_return_status => l_return_status,
985: x_num_warnings => l_num_warnings,
986: x_num_errors => l_num_errors,
987: p_module_name => l_module_name,

Line 1012: WSH_UTIL_CORE.api_post_call(

1008: l_num_entity := l_num_entity +1;
1009: END IF;
1010:
1011: IF (l_num_entity > 1 ) THEN
1012: WSH_UTIL_CORE.api_post_call(
1013: p_return_status => WSH_UTIL_CORE.G_RET_STS_ERROR,
1014: x_num_warnings => l_num_warnings,
1015: x_num_errors => l_num_errors,
1016: p_module_name => l_module_name,

Line 1013: p_return_status => WSH_UTIL_CORE.G_RET_STS_ERROR,

1009: END IF;
1010:
1011: IF (l_num_entity > 1 ) THEN
1012: WSH_UTIL_CORE.api_post_call(
1013: p_return_status => WSH_UTIL_CORE.G_RET_STS_ERROR,
1014: x_num_warnings => l_num_warnings,
1015: x_num_errors => l_num_errors,
1016: p_module_name => l_module_name,
1017: p_msg_data => 'WSH_FC_ONE_MASTER_ENTITY');

Line 1035: WSH_UTIL_CORE.api_post_call(

1031:
1032: IF l_debug_on THEN
1033: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_Trip_name x_return_status',l_return_status);
1034: END IF;
1035: WSH_UTIL_CORE.api_post_call(
1036: p_return_status => l_return_status,
1037: x_num_warnings => l_num_warnings,
1038: x_num_errors => l_num_errors,
1039: p_module_name => l_module_name,

Line 1066: WSH_UTIL_CORE.api_post_call(p_return_status => WSH_UTIL_CORE.G_RET_STS_WARNING,

1062: AND wdd.oe_interfaced_flag = 'Y'
1063: AND ROWNUM = 1;
1064:
1065: IF l_status = 'Y' THEN
1066: WSH_UTIL_CORE.api_post_call(p_return_status => WSH_UTIL_CORE.G_RET_STS_WARNING,
1067: x_num_warnings => l_num_warnings,
1068: x_num_errors => l_num_errors,
1069: p_module_name => l_module_name,
1070: p_msg_data => 'WSH_FC_OTHER_WARN',

Line 1090: WSH_UTIL_CORE.api_post_call(

1086: WHERE trip_id = l_trip_id
1087: AND ROWNUM = 1;
1088:
1089: IF (l_counts = 0) THEN
1090: WSH_UTIL_CORE.api_post_call(
1091: p_return_status => WSH_UTIL_CORE.G_RET_STS_ERROR,
1092: x_num_warnings => l_num_warnings,
1093: x_num_errors => l_num_errors,
1094: p_module_name => l_module_name,

Line 1091: p_return_status => WSH_UTIL_CORE.G_RET_STS_ERROR,

1087: AND ROWNUM = 1;
1088:
1089: IF (l_counts = 0) THEN
1090: WSH_UTIL_CORE.api_post_call(
1091: p_return_status => WSH_UTIL_CORE.G_RET_STS_ERROR,
1092: x_num_warnings => l_num_warnings,
1093: x_num_errors => l_num_errors,
1094: p_module_name => l_module_name,
1095: p_msg_data => 'WSH_FC_ONE_MASTER_ENTITY');

Line 1112: WSH_UTIL_CORE.api_post_call(

1108:
1109: IF l_debug_on THEN
1110: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_stop_name x_return_status',l_return_status);
1111: END IF;
1112: WSH_UTIL_CORE.api_post_call(
1113: p_return_status => l_return_status,
1114: x_num_warnings => l_num_warnings,
1115: x_num_errors => l_num_errors,
1116: p_module_name => l_module_name,

Line 1141: l_name := wsh_util_core.get_location_description(l_stop_loc_id,'NEW UI CODE INFO');

1137: AND wdd.delivery_detail_id = wda.delivery_detail_id
1138: AND wdd.oe_interfaced_flag = 'Y'
1139: AND ROWNUM = 1;
1140: IF l_status = 'Y' THEN
1141: l_name := wsh_util_core.get_location_description(l_stop_loc_id,'NEW UI CODE INFO');
1142: WSH_UTIL_CORE.api_post_call(p_return_status => WSH_UTIL_CORE.G_RET_STS_WARNING,
1143: x_num_warnings => l_num_warnings,
1144: x_num_errors => l_num_errors,
1145: p_module_name => l_module_name,

Line 1142: WSH_UTIL_CORE.api_post_call(p_return_status => WSH_UTIL_CORE.G_RET_STS_WARNING,

1138: AND wdd.oe_interfaced_flag = 'Y'
1139: AND ROWNUM = 1;
1140: IF l_status = 'Y' THEN
1141: l_name := wsh_util_core.get_location_description(l_stop_loc_id,'NEW UI CODE INFO');
1142: WSH_UTIL_CORE.api_post_call(p_return_status => WSH_UTIL_CORE.G_RET_STS_WARNING,
1143: x_num_warnings => l_num_warnings,
1144: x_num_errors => l_num_errors,
1145: p_module_name => l_module_name,
1146: p_msg_data => 'WSH_FC_OTHER_WARN',

Line 1169: WSH_UTIL_CORE.api_post_call(

1165: IF l_debug_on THEN
1166: WSH_DEBUG_SV.log(l_module_name,'l_counts',l_counts);
1167: END IF;
1168: IF (l_counts = 0) THEN
1169: WSH_UTIL_CORE.api_post_call(
1170: p_return_status => WSH_UTIL_CORE.G_RET_STS_ERROR,
1171: x_num_warnings => l_num_warnings,
1172: x_num_errors => l_num_errors,
1173: p_module_name => l_module_name,

Line 1170: p_return_status => WSH_UTIL_CORE.G_RET_STS_ERROR,

1166: WSH_DEBUG_SV.log(l_module_name,'l_counts',l_counts);
1167: END IF;
1168: IF (l_counts = 0) THEN
1169: WSH_UTIL_CORE.api_post_call(
1170: p_return_status => WSH_UTIL_CORE.G_RET_STS_ERROR,
1171: x_num_warnings => l_num_warnings,
1172: x_num_errors => l_num_errors,
1173: p_module_name => l_module_name,
1174: p_msg_data => 'WSH_FC_ONE_MASTER_ENTITY');

Line 1189: WSH_UTIL_CORE.api_post_call(

1185:
1186: IF l_debug_on THEN
1187: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_delivery_name x_return_status',l_return_status);
1188: END IF;
1189: WSH_UTIL_CORE.api_post_call(
1190: p_return_status => l_return_status,
1191: x_num_warnings => l_num_warnings,
1192: x_num_errors => l_num_errors,
1193: p_module_name => l_module_name,

Line 1215: WSH_UTIL_CORE.api_post_call(p_return_status => WSH_UTIL_CORE.G_RET_STS_WARNING,

1211: AND wdd.delivery_detail_id = wda.delivery_detail_id
1212: AND wdd.oe_interfaced_flag = 'Y'
1213: AND ROWNUM = 1;
1214: IF l_status = 'Y' THEN
1215: WSH_UTIL_CORE.api_post_call(p_return_status => WSH_UTIL_CORE.G_RET_STS_WARNING,
1216: x_num_warnings => l_num_warnings,
1217: x_num_errors => l_num_errors,
1218: p_module_name => l_module_name,
1219: p_msg_data => 'WSH_FC_OTHER_WARN',

Line 1239: WSH_UTIL_CORE.api_post_call(

1235: WHERE delivery_id = l_delivery_id
1236: AND ROWNUM = 1;
1237:
1238: IF (l_counts = 0) THEN
1239: WSH_UTIL_CORE.api_post_call(
1240: p_return_status => WSH_UTIL_CORE.G_RET_STS_ERROR,
1241: x_num_warnings => l_num_warnings,
1242: x_num_errors => l_num_errors,
1243: p_module_name => l_module_name,

Line 1240: p_return_status => WSH_UTIL_CORE.G_RET_STS_ERROR,

1236: AND ROWNUM = 1;
1237:
1238: IF (l_counts = 0) THEN
1239: WSH_UTIL_CORE.api_post_call(
1240: p_return_status => WSH_UTIL_CORE.G_RET_STS_ERROR,
1241: x_num_warnings => l_num_warnings,
1242: x_num_errors => l_num_errors,
1243: p_module_name => l_module_name,
1244: p_msg_data => 'WSH_FC_ONE_MASTER_ENTITY');

Line 1258: WSH_UTIL_CORE.api_post_call(

1254: WHERE delivery_leg_id = l_freight_info_tab(l_index).delivery_leg_id
1255: AND ROWNUM = 1;
1256:
1257: IF (l_counts = 0) THEN
1258: WSH_UTIL_CORE.api_post_call(
1259: p_return_status => WSH_UTIL_CORE.G_RET_STS_ERROR,
1260: x_num_warnings => l_num_warnings,
1261: x_num_errors => l_num_errors,
1262: p_module_name => l_module_name,

Line 1259: p_return_status => WSH_UTIL_CORE.G_RET_STS_ERROR,

1255: AND ROWNUM = 1;
1256:
1257: IF (l_counts = 0) THEN
1258: WSH_UTIL_CORE.api_post_call(
1259: p_return_status => WSH_UTIL_CORE.G_RET_STS_ERROR,
1260: x_num_warnings => l_num_warnings,
1261: x_num_errors => l_num_errors,
1262: p_module_name => l_module_name,
1263: p_msg_data => 'WSH_FC_ONE_MASTER_ENTITY');

Line 1295: WSH_UTIL_CORE.api_post_call(p_return_status => WSH_UTIL_CORE.G_RET_STS_WARNING,

1291: WHERE delivery_detail_id = l_freight_info_tab(l_index).delivery_detail_id;
1292: END IF;
1293:
1294: IF l_status = 'Y' THEN
1295: WSH_UTIL_CORE.api_post_call(p_return_status => WSH_UTIL_CORE.G_RET_STS_WARNING,
1296: x_num_warnings => l_num_warnings,
1297: x_num_errors => l_num_errors,
1298: p_module_name => l_module_name,
1299: p_msg_data => 'WSH_FC_DET_WARN',

Line 1319: WSH_UTIL_CORE.api_post_call(

1315: WHERE delivery_detail_id = l_freight_info_tab(l_index).delivery_detail_id
1316: AND ROWNUM = 1;
1317:
1318: IF (l_counts = 0) THEN
1319: WSH_UTIL_CORE.api_post_call(
1320: p_return_status => WSH_UTIL_CORE.G_RET_STS_ERROR,
1321: x_num_warnings => l_num_warnings,
1322: x_num_errors => l_num_errors,
1323: p_module_name => l_module_name,

Line 1320: p_return_status => WSH_UTIL_CORE.G_RET_STS_ERROR,

1316: AND ROWNUM = 1;
1317:
1318: IF (l_counts = 0) THEN
1319: WSH_UTIL_CORE.api_post_call(
1320: p_return_status => WSH_UTIL_CORE.G_RET_STS_ERROR,
1321: x_num_warnings => l_num_warnings,
1322: x_num_errors => l_num_errors,
1323: p_module_name => l_module_name,
1324: p_msg_data => 'WSH_FC_ONE_MASTER_ENTITY');

Line 1351: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

1347: --
1348: CLOSE c_detail_rec;
1349: FND_MESSAGE.SET_NAME('WSH','WSH_DETAIL_NOT_EXIST');
1350: FND_MESSAGE.SET_TOKEN('DETAIL_ID', l_freight_info_tab(l_index).DELIVERY_DETAIL_ID);
1351: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1352: IF l_debug_on THEN
1353: wsh_debug_sv.log (l_module_name,'WSH_DETAIL_NOT_EXIST');
1354: END IF;
1355: RAISE FND_API.G_EXC_ERROR;

Line 1371: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,

1367: x_valid_ids => l_valid_id_tab ,
1368: x_error_ids => l_error_ids ,
1369: x_valid_index_tab => l_valid_index_tab);
1370: --
1371: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
1372: x_num_warnings =>l_num_warnings,
1373: x_num_errors =>l_num_errors);
1374: --
1375: END IF;

Line 1387: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

1383: IF c_del_rec%NOTFOUND THEN
1384: CLOSE c_del_rec;
1385: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_NOT_EXIST');
1386: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME', l_freight_info_tab(l_index).DELIVERY_NAME);
1387: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1388: --
1389: IF l_debug_on THEN
1390: wsh_debug_sv.log (l_module_name,'WSH_DELIVERY_NOT_EXIST');
1391: END IF;

Line 1407: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,

1403: x_valid_ids => l_valid_id_tab ,
1404: x_error_ids => l_error_ids ,
1405: x_valid_index_tab => l_valid_index_tab);
1406:
1407: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
1408: x_num_warnings =>l_num_warnings,
1409: x_num_errors =>l_num_errors);
1410: END IF;
1411: --

Line 1422: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

1418: IF c_trip_rec%NOTFOUND THEN
1419: CLOSE c_trip_rec;
1420: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NOT_EXIST');
1421: FND_MESSAGE.SET_TOKEN('TRIP_NAME', l_freight_info_tab(l_index).TRIP_NAME);
1422: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1423: --
1424: IF l_debug_on THEN
1425: wsh_debug_sv.log (l_module_name,'WSH_TRIP_NOT_EXIST');
1426: END IF;

Line 1442: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,

1438: x_valid_ids => l_valid_id_tab ,
1439: x_error_ids => l_error_ids ,
1440: x_valid_index_tab => l_valid_index_tab);
1441:
1442: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
1443: x_num_warnings =>l_num_warnings,
1444: x_num_errors =>l_num_errors);
1445: END IF;
1446: --

Line 1457: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

1453: IF c_stop_rec%NOTFOUND THEN
1454: CLOSE c_stop_rec;
1455: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_EXIST');
1456: FND_MESSAGE.SET_TOKEN('STOP_ID', l_freight_info_tab(l_index).STOP_ID);
1457: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1458: --
1459: IF l_debug_on THEN
1460: wsh_debug_sv.log (l_module_name,'WSH_STOP_NOT_EXIST');
1461: END IF;

Line 1477: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,

1473: x_valid_ids => l_valid_id_tab ,
1474: x_error_ids => l_error_ids ,
1475: x_valid_index_tab => l_valid_index_tab);
1476:
1477: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
1478: x_num_warnings =>l_num_warnings,
1479: x_num_errors =>l_num_errors);
1480: END IF;
1481: --

Line 1496: WSH_UTIL_CORE.api_post_call(

1492: IF l_debug_on THEN
1493: WSH_DEBUG_SV.log(l_module_name,'WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost x_freight_cost_id,x_return_status',
1494: x_out_tab(l_index).freight_cost_id||','||l_return_status);
1495: END IF;
1496: WSH_UTIL_CORE.api_post_call(
1497: p_return_status => l_return_status,
1498: x_num_warnings => l_num_warnings,
1499: x_num_errors => l_num_errors,
1500: p_module_name => l_module_name,

Line 1514: WSH_UTIL_CORE.api_post_call(

1510:
1511: IF l_debug_on THEN
1512: WSH_DEBUG_SV.log(l_module_name,'Update_Freight_Costs x_return_status',l_return_status);
1513: END IF;
1514: WSH_UTIL_CORE.api_post_call(
1515: p_return_status => l_return_status,
1516: x_num_warnings => l_num_warnings,
1517: x_num_errors => l_num_errors,
1518: p_module_name => l_module_name,

Line 1588: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1584: l_index := p_freight_info_tab.NEXT(l_index);
1585: END LOOP;
1586:
1587: IF (l_num_errors = p_freight_info_tab.count ) THEN
1588: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1589: RAISE FND_API.G_EXC_ERROR;
1590: ELSIF (l_num_errors > 0 ) THEN
1591: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1592: RAISE WSH_UTIL_CORE.G_EXC_WARNING;

Line 1591: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1587: IF (l_num_errors = p_freight_info_tab.count ) THEN
1588: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1589: RAISE FND_API.G_EXC_ERROR;
1590: ELSIF (l_num_errors > 0 ) THEN
1591: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1592: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1593: ELSIF (l_num_warnings > 0 ) THEN
1594: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1595: RAISE WSH_UTIL_CORE.G_EXC_WARNING;

Line 1592: RAISE WSH_UTIL_CORE.G_EXC_WARNING;

1588: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1589: RAISE FND_API.G_EXC_ERROR;
1590: ELSIF (l_num_errors > 0 ) THEN
1591: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1592: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1593: ELSIF (l_num_warnings > 0 ) THEN
1594: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1595: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1596: ELSE

Line 1594: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1590: ELSIF (l_num_errors > 0 ) THEN
1591: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1592: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1593: ELSIF (l_num_warnings > 0 ) THEN
1594: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1595: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1596: ELSE
1597: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1598: END IF;

Line 1595: RAISE WSH_UTIL_CORE.G_EXC_WARNING;

1591: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1592: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1593: ELSIF (l_num_warnings > 0 ) THEN
1594: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1595: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1596: ELSE
1597: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1598: END IF;
1599:

Line 1597: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1593: ELSIF (l_num_warnings > 0 ) THEN
1594: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1595: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1596: ELSE
1597: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1598: END IF;
1599:
1600:
1601: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 1615: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1611: END IF;
1612:
1613: EXCEPTION
1614: WHEN RECORD_LOCKED THEN
1615: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1616: FND_MESSAGE.Set_Name('WSH', 'WSH_NO_LOCK');
1617: wsh_util_core.add_message(x_return_status,l_module_name);
1618: IF l_debug_on THEN
1619: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 1617: wsh_util_core.add_message(x_return_status,l_module_name);

1613: EXCEPTION
1614: WHEN RECORD_LOCKED THEN
1615: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1616: FND_MESSAGE.Set_Name('WSH', 'WSH_NO_LOCK');
1617: wsh_util_core.add_message(x_return_status,l_module_name);
1618: IF l_debug_on THEN
1619: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1620: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
1621: END IF;

Line 1625: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;

1621: END IF;
1622: Rollback to Create_Update_Freight_Costs_Gp;
1623:
1624: WHEN FND_API.G_EXC_ERROR THEN
1625: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
1626: FND_MSG_PUB.Count_And_Get (
1627: p_count => x_msg_count,
1628: p_data => x_msg_data,
1629: p_encoded => FND_API.G_FALSE);

Line 1637: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

1633: END IF;
1634: Rollback to Create_Update_Freight_Costs_Gp;
1635:
1636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1637: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1638: FND_MSG_PUB.Count_And_Get (
1639: p_count => x_msg_count,
1640: p_data => x_msg_data,
1641: p_encoded => FND_API.G_FALSE);

Line 1648: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

1644: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1645: END IF;
1646: Rollback to Create_Update_Freight_Costs_Gp;
1647:
1648: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1649: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1650: FND_MSG_PUB.Count_And_Get (
1651: p_count => x_msg_count,
1652: p_data => x_msg_data,

Line 1649: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1645: END IF;
1646: Rollback to Create_Update_Freight_Costs_Gp;
1647:
1648: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1649: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1650: FND_MSG_PUB.Count_And_Get (
1651: p_count => x_msg_count,
1652: p_data => x_msg_data,
1653: p_encoded => FND_API.G_FALSE);

Line 1655: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1651: p_count => x_msg_count,
1652: p_data => x_msg_data,
1653: p_encoded => FND_API.G_FALSE);
1654: IF l_debug_on THEN
1655: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1656: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1657: END IF;
1658:
1659: WHEN OTHERS THEN

Line 1656: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

1652: p_data => x_msg_data,
1653: p_encoded => FND_API.G_FALSE);
1654: IF l_debug_on THEN
1655: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1656: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1657: END IF;
1658:
1659: WHEN OTHERS THEN
1660: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 1660: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

1656: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1657: END IF;
1658:
1659: WHEN OTHERS THEN
1660: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1661: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');
1662: FND_MSG_PUB.Count_And_Get (
1663: p_count => x_msg_count,
1664: p_data => x_msg_data,

Line 1661: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');

1657: END IF;
1658:
1659: WHEN OTHERS THEN
1660: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1661: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');
1662: FND_MSG_PUB.Count_And_Get (
1663: p_count => x_msg_count,
1664: p_data => x_msg_data,
1665: p_encoded => FND_API.G_FALSE);

Line 1738: IF ( x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN

1734: x_return_status => x_return_status);
1735: IF l_debug_on THEN
1736: wsh_debug_sv.log (l_module_name, 'map_freightgrp_to_pvt x_return_status',x_return_status);
1737: END IF;
1738: IF ( x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
1739: raise FND_API.G_EXC_ERROR;
1740: END IF;
1741:
1742: l_in_rec.caller := 'WSH_GRP';

Line 1758: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS AND l_out_tab.COUNT > 0 ) THEN

1754: p_freight_info_tab => l_freight_info_tab,
1755: p_in_rec => l_in_rec,
1756: x_out_tab => l_out_tab );
1757:
1758: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS AND l_out_tab.COUNT > 0 ) THEN
1759: x_freight_cost_id := l_out_tab(l_out_tab.FIRST).freight_cost_id;
1760: END IF;
1761:
1762: IF l_debug_on THEN

Line 1775: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

1771: END IF;
1772:
1773:
1774: WHEN OTHERS THEN
1775: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1776: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');
1777: IF l_debug_on THEN
1778: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1779: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1776: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');

1772:
1773:
1774: WHEN OTHERS THEN
1775: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1776: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');
1777: IF l_debug_on THEN
1778: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1779: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1780: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');