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:

Line 620: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

616: END IF;
617:
618: EXCEPTION
619: WHEN e_dp_no_entity THEN
620: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
621:
622: WHEN OTHERS THEN
623: wsh_util_core.default_handler('WSH_FREIGHT_COSTS_GRP.get_disabled_list',l_module_name);
624: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

619: WHEN e_dp_no_entity THEN
620: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
621:
622: WHEN OTHERS THEN
623: wsh_util_core.default_handler('WSH_FREIGHT_COSTS_GRP.get_disabled_list',l_module_name);
624: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
625: IF l_debug_on THEN
626: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
627: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 624: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

620: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
621:
622: WHEN OTHERS THEN
623: wsh_util_core.default_handler('WSH_FREIGHT_COSTS_GRP.get_disabled_list',l_module_name);
624: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
625: IF l_debug_on THEN
626: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
627: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
628: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 714: l_valid_index_tab wsh_util_core.id_tab_type;

710: l_del_rec_tab WSH_DELIVERY_VALIDATIONS.dlvy_rec_tab_type;
711: l_trip_rec_tab WSH_TRIP_VALIDATIONS.trip_rec_tab_type;
712: l_stop_rec_tab WSH_TRIP_STOPS_VALIDATIONS.stop_rec_tab_type;
713:
714: l_valid_index_tab wsh_util_core.id_tab_type;
715: l_valid_id_tab wsh_util_core.id_tab_type;
716: l_error_ids wsh_util_core.id_tab_type;
717: --J-IB-JCKWOK
718:

Line 715: l_valid_id_tab wsh_util_core.id_tab_type;

711: l_trip_rec_tab WSH_TRIP_VALIDATIONS.trip_rec_tab_type;
712: l_stop_rec_tab WSH_TRIP_STOPS_VALIDATIONS.stop_rec_tab_type;
713:
714: l_valid_index_tab wsh_util_core.id_tab_type;
715: l_valid_id_tab wsh_util_core.id_tab_type;
716: l_error_ids wsh_util_core.id_tab_type;
717: --J-IB-JCKWOK
718:
719: l_currency_code VARCHAR2(30);

Line 716: l_error_ids wsh_util_core.id_tab_type;

712: l_stop_rec_tab WSH_TRIP_STOPS_VALIDATIONS.stop_rec_tab_type;
713:
714: l_valid_index_tab wsh_util_core.id_tab_type;
715: l_valid_id_tab wsh_util_core.id_tab_type;
716: l_error_ids wsh_util_core.id_tab_type;
717: --J-IB-JCKWOK
718:
719: l_currency_code VARCHAR2(30);
720: l_amount NUMBER;

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

774:
775: IF (p_in_rec.caller IS NULL) THEN
776: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
777: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_in_rec.caller');
778: wsh_util_core.add_message(x_return_status,l_module_name);
779: raise fnd_api.g_exc_error;
780: END IF;
781: IF (nvl(p_in_rec.phase,1) <> 1) THEN
782: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');

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

780: END IF;
781: IF (nvl(p_in_rec.phase,1) <> 1) THEN
782: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
783: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_in_rec.phase');
784: wsh_util_core.add_message(x_return_status,l_module_name);
785: raise fnd_api.g_exc_error;
786: END IF;
787: IF (p_in_rec.action_code IS NULL OR p_in_rec.action_code NOT IN ('CREATE','UPDATE') ) THEN
788: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');

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

786: END IF;
787: IF (p_in_rec.action_code IS NULL OR p_in_rec.action_code NOT IN ('CREATE','UPDATE') ) THEN
788: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
789: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_in_rec.action_code');
790: wsh_util_core.add_message(x_return_status,l_module_name);
791: raise fnd_api.g_exc_error;
792: END IF;
793:
794: WSH_ACTIONS_LEVELS.set_validation_level (

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

807: 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));
808: 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));
809: END IF;
810:
811: WSH_UTIL_CORE.api_post_call(p_return_status => l_return_status,
812: x_num_warnings =>l_num_warnings,
813: x_num_errors =>l_num_errors);
814:
815: l_freight_info_tab:=p_freight_info_tab;

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

833: x_return_status => l_return_status);
834: END IF;
835:
836:
837: WSH_UTIL_CORE.api_post_call(p_return_status => l_return_status,
838: x_num_warnings =>l_num_warnings,
839: x_num_errors =>l_num_errors);
840:
841: IF (WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FREIGHT_COST_TYPE_LVL)=1) THEN

Line 845: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

841: IF (WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FREIGHT_COST_TYPE_LVL)=1) THEN
842: IF (l_freight_info_tab(l_index).freight_cost_type IS NULL AND
843: l_freight_info_tab(l_index).freight_cost_type_id IS NULL) THEN
844:
845: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
846: WSH_UTIL_CORE.api_post_call(p_return_status => l_return_status,
847: x_num_warnings =>l_num_warnings,
848: x_num_errors =>l_num_errors,
849: p_module_name => l_module_name,

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

842: IF (l_freight_info_tab(l_index).freight_cost_type IS NULL AND
843: l_freight_info_tab(l_index).freight_cost_type_id IS NULL) THEN
844:
845: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
846: WSH_UTIL_CORE.api_post_call(p_return_status => l_return_status,
847: x_num_warnings =>l_num_warnings,
848: x_num_errors =>l_num_errors,
849: p_module_name => l_module_name,
850: p_msg_data => 'WSH_REQUIRED_FIELD_NULL',

Line 862: WSH_UTIL_CORE.api_post_call(

858: IF l_debug_on THEN
859: WSH_DEBUG_SV.log(l_module_name,'validate_freight_cost_type l_return_status',l_return_status);
860: END IF;
861:
862: WSH_UTIL_CORE.api_post_call(
863: p_return_status => l_return_status,
864: x_num_warnings => l_num_warnings,
865: x_num_errors => l_num_errors,
866: p_module_name => l_module_name,

Line 894: WSH_UTIL_CORE.api_post_call(

890: --
891: IF l_debug_on THEN
892: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_Negative x_return_status',l_return_status);
893: END IF;
894: WSH_UTIL_CORE.api_post_call(
895: p_return_status => l_return_status,
896: x_num_warnings => l_num_warnings,
897: x_num_errors => l_num_errors,
898: p_module_name => l_module_name,

Line 914: WSH_UTIL_CORE.api_post_call(

910: --
911: IF l_debug_on THEN
912: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_Negative x_return_status',l_return_status);
913: END IF;
914: WSH_UTIL_CORE.api_post_call(
915: p_return_status => l_return_status,
916: x_num_warnings => l_num_warnings,
917: x_num_errors => l_num_errors,
918: p_module_name => l_module_name,

Line 937: WSH_UTIL_CORE.api_post_call(

933: IF l_debug_on THEN
934: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_Currency l_return_status',l_return_status);
935: END IF;
936:
937: WSH_UTIL_CORE.api_post_call(
938: p_return_status => l_return_status,
939: x_num_warnings => l_num_warnings,
940: x_num_errors => l_num_errors,
941: p_module_name => l_module_name,

Line 966: WSH_UTIL_CORE.api_post_call(

962: l_num_entity := l_num_entity +1;
963: END IF;
964:
965: IF (l_num_entity > 1 ) THEN
966: WSH_UTIL_CORE.api_post_call(
967: p_return_status => WSH_UTIL_CORE.G_RET_STS_ERROR,
968: x_num_warnings => l_num_warnings,
969: x_num_errors => l_num_errors,
970: p_module_name => l_module_name,

Line 967: p_return_status => WSH_UTIL_CORE.G_RET_STS_ERROR,

963: END IF;
964:
965: IF (l_num_entity > 1 ) THEN
966: WSH_UTIL_CORE.api_post_call(
967: p_return_status => WSH_UTIL_CORE.G_RET_STS_ERROR,
968: x_num_warnings => l_num_warnings,
969: x_num_errors => l_num_errors,
970: p_module_name => l_module_name,
971: p_msg_data => 'WSH_FC_ONE_MASTER_ENTITY');

Line 989: WSH_UTIL_CORE.api_post_call(

985:
986: IF l_debug_on THEN
987: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_Trip_name x_return_status',l_return_status);
988: END IF;
989: WSH_UTIL_CORE.api_post_call(
990: p_return_status => l_return_status,
991: x_num_warnings => l_num_warnings,
992: x_num_errors => l_num_errors,
993: p_module_name => l_module_name,

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

1016: AND wdd.oe_interfaced_flag = 'Y'
1017: AND ROWNUM = 1;
1018:
1019: IF l_status = 'Y' THEN
1020: WSH_UTIL_CORE.api_post_call(p_return_status => WSH_UTIL_CORE.G_RET_STS_WARNING,
1021: x_num_warnings => l_num_warnings,
1022: x_num_errors => l_num_errors,
1023: p_module_name => l_module_name,
1024: p_msg_data => 'WSH_FC_OTHER_WARN',

Line 1044: WSH_UTIL_CORE.api_post_call(

1040: WHERE trip_id = l_trip_id
1041: AND ROWNUM = 1;
1042:
1043: IF (l_counts = 0) THEN
1044: WSH_UTIL_CORE.api_post_call(
1045: p_return_status => WSH_UTIL_CORE.G_RET_STS_ERROR,
1046: x_num_warnings => l_num_warnings,
1047: x_num_errors => l_num_errors,
1048: p_module_name => l_module_name,

Line 1045: p_return_status => WSH_UTIL_CORE.G_RET_STS_ERROR,

1041: AND ROWNUM = 1;
1042:
1043: IF (l_counts = 0) THEN
1044: WSH_UTIL_CORE.api_post_call(
1045: p_return_status => WSH_UTIL_CORE.G_RET_STS_ERROR,
1046: x_num_warnings => l_num_warnings,
1047: x_num_errors => l_num_errors,
1048: p_module_name => l_module_name,
1049: p_msg_data => 'WSH_FC_ONE_MASTER_ENTITY');

Line 1066: WSH_UTIL_CORE.api_post_call(

1062:
1063: IF l_debug_on THEN
1064: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_stop_name x_return_status',l_return_status);
1065: END IF;
1066: WSH_UTIL_CORE.api_post_call(
1067: p_return_status => l_return_status,
1068: x_num_warnings => l_num_warnings,
1069: x_num_errors => l_num_errors,
1070: p_module_name => l_module_name,

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

1091: AND wdd.delivery_detail_id = wda.delivery_detail_id
1092: AND wdd.oe_interfaced_flag = 'Y'
1093: AND ROWNUM = 1;
1094: IF l_status = 'Y' THEN
1095: l_name := wsh_util_core.get_location_description(l_stop_loc_id,'NEW UI CODE INFO');
1096: WSH_UTIL_CORE.api_post_call(p_return_status => WSH_UTIL_CORE.G_RET_STS_WARNING,
1097: x_num_warnings => l_num_warnings,
1098: x_num_errors => l_num_errors,
1099: p_module_name => l_module_name,

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

1092: AND wdd.oe_interfaced_flag = 'Y'
1093: AND ROWNUM = 1;
1094: IF l_status = 'Y' THEN
1095: l_name := wsh_util_core.get_location_description(l_stop_loc_id,'NEW UI CODE INFO');
1096: WSH_UTIL_CORE.api_post_call(p_return_status => WSH_UTIL_CORE.G_RET_STS_WARNING,
1097: x_num_warnings => l_num_warnings,
1098: x_num_errors => l_num_errors,
1099: p_module_name => l_module_name,
1100: p_msg_data => 'WSH_FC_OTHER_WARN',

Line 1123: WSH_UTIL_CORE.api_post_call(

1119: IF l_debug_on THEN
1120: WSH_DEBUG_SV.log(l_module_name,'l_counts',l_counts);
1121: END IF;
1122: IF (l_counts = 0) THEN
1123: WSH_UTIL_CORE.api_post_call(
1124: p_return_status => WSH_UTIL_CORE.G_RET_STS_ERROR,
1125: x_num_warnings => l_num_warnings,
1126: x_num_errors => l_num_errors,
1127: p_module_name => l_module_name,

Line 1124: p_return_status => WSH_UTIL_CORE.G_RET_STS_ERROR,

1120: WSH_DEBUG_SV.log(l_module_name,'l_counts',l_counts);
1121: END IF;
1122: IF (l_counts = 0) THEN
1123: WSH_UTIL_CORE.api_post_call(
1124: p_return_status => WSH_UTIL_CORE.G_RET_STS_ERROR,
1125: x_num_warnings => l_num_warnings,
1126: x_num_errors => l_num_errors,
1127: p_module_name => l_module_name,
1128: p_msg_data => 'WSH_FC_ONE_MASTER_ENTITY');

Line 1143: WSH_UTIL_CORE.api_post_call(

1139:
1140: IF l_debug_on THEN
1141: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_delivery_name x_return_status',l_return_status);
1142: END IF;
1143: WSH_UTIL_CORE.api_post_call(
1144: p_return_status => l_return_status,
1145: x_num_warnings => l_num_warnings,
1146: x_num_errors => l_num_errors,
1147: p_module_name => l_module_name,

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

1165: AND wdd.delivery_detail_id = wda.delivery_detail_id
1166: AND wdd.oe_interfaced_flag = 'Y'
1167: AND ROWNUM = 1;
1168: IF l_status = 'Y' THEN
1169: WSH_UTIL_CORE.api_post_call(p_return_status => WSH_UTIL_CORE.G_RET_STS_WARNING,
1170: x_num_warnings => l_num_warnings,
1171: x_num_errors => l_num_errors,
1172: p_module_name => l_module_name,
1173: p_msg_data => 'WSH_FC_OTHER_WARN',

Line 1193: WSH_UTIL_CORE.api_post_call(

1189: WHERE delivery_id = l_delivery_id
1190: AND ROWNUM = 1;
1191:
1192: IF (l_counts = 0) THEN
1193: WSH_UTIL_CORE.api_post_call(
1194: p_return_status => WSH_UTIL_CORE.G_RET_STS_ERROR,
1195: x_num_warnings => l_num_warnings,
1196: x_num_errors => l_num_errors,
1197: p_module_name => l_module_name,

Line 1194: p_return_status => WSH_UTIL_CORE.G_RET_STS_ERROR,

1190: AND ROWNUM = 1;
1191:
1192: IF (l_counts = 0) THEN
1193: WSH_UTIL_CORE.api_post_call(
1194: p_return_status => WSH_UTIL_CORE.G_RET_STS_ERROR,
1195: x_num_warnings => l_num_warnings,
1196: x_num_errors => l_num_errors,
1197: p_module_name => l_module_name,
1198: p_msg_data => 'WSH_FC_ONE_MASTER_ENTITY');

Line 1212: WSH_UTIL_CORE.api_post_call(

1208: WHERE delivery_leg_id = l_freight_info_tab(l_index).delivery_leg_id
1209: AND ROWNUM = 1;
1210:
1211: IF (l_counts = 0) THEN
1212: WSH_UTIL_CORE.api_post_call(
1213: p_return_status => WSH_UTIL_CORE.G_RET_STS_ERROR,
1214: x_num_warnings => l_num_warnings,
1215: x_num_errors => l_num_errors,
1216: p_module_name => l_module_name,

Line 1213: p_return_status => WSH_UTIL_CORE.G_RET_STS_ERROR,

1209: AND ROWNUM = 1;
1210:
1211: IF (l_counts = 0) THEN
1212: WSH_UTIL_CORE.api_post_call(
1213: p_return_status => WSH_UTIL_CORE.G_RET_STS_ERROR,
1214: x_num_warnings => l_num_warnings,
1215: x_num_errors => l_num_errors,
1216: p_module_name => l_module_name,
1217: p_msg_data => 'WSH_FC_ONE_MASTER_ENTITY');

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

1245: WHERE delivery_detail_id = l_freight_info_tab(l_index).delivery_detail_id;
1246: END IF;
1247:
1248: IF l_status = 'Y' THEN
1249: WSH_UTIL_CORE.api_post_call(p_return_status => WSH_UTIL_CORE.G_RET_STS_WARNING,
1250: x_num_warnings => l_num_warnings,
1251: x_num_errors => l_num_errors,
1252: p_module_name => l_module_name,
1253: p_msg_data => 'WSH_FC_DET_WARN',

Line 1273: WSH_UTIL_CORE.api_post_call(

1269: WHERE delivery_detail_id = l_freight_info_tab(l_index).delivery_detail_id
1270: AND ROWNUM = 1;
1271:
1272: IF (l_counts = 0) THEN
1273: WSH_UTIL_CORE.api_post_call(
1274: p_return_status => WSH_UTIL_CORE.G_RET_STS_ERROR,
1275: x_num_warnings => l_num_warnings,
1276: x_num_errors => l_num_errors,
1277: p_module_name => l_module_name,

Line 1274: p_return_status => WSH_UTIL_CORE.G_RET_STS_ERROR,

1270: AND ROWNUM = 1;
1271:
1272: IF (l_counts = 0) THEN
1273: WSH_UTIL_CORE.api_post_call(
1274: p_return_status => WSH_UTIL_CORE.G_RET_STS_ERROR,
1275: x_num_warnings => l_num_warnings,
1276: x_num_errors => l_num_errors,
1277: p_module_name => l_module_name,
1278: p_msg_data => 'WSH_FC_ONE_MASTER_ENTITY');

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

1301: --
1302: CLOSE c_detail_rec;
1303: FND_MESSAGE.SET_NAME('WSH','WSH_DETAIL_NOT_EXIST');
1304: FND_MESSAGE.SET_TOKEN('DETAIL_ID', l_freight_info_tab(l_index).DELIVERY_DETAIL_ID);
1305: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1306: IF l_debug_on THEN
1307: wsh_debug_sv.log (l_module_name,'WSH_DETAIL_NOT_EXIST');
1308: END IF;
1309: RAISE FND_API.G_EXC_ERROR;

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

1321: x_valid_ids => l_valid_id_tab ,
1322: x_error_ids => l_error_ids ,
1323: x_valid_index_tab => l_valid_index_tab);
1324: --
1325: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
1326: x_num_warnings =>l_num_warnings,
1327: x_num_errors =>l_num_errors);
1328: --
1329: END IF;

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

1337: IF c_del_rec%NOTFOUND THEN
1338: CLOSE c_del_rec;
1339: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_NOT_EXIST');
1340: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME', l_freight_info_tab(l_index).DELIVERY_NAME);
1341: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1342: --
1343: IF l_debug_on THEN
1344: wsh_debug_sv.log (l_module_name,'WSH_DELIVERY_NOT_EXIST');
1345: END IF;

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

1357: x_valid_ids => l_valid_id_tab ,
1358: x_error_ids => l_error_ids ,
1359: x_valid_index_tab => l_valid_index_tab);
1360:
1361: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
1362: x_num_warnings =>l_num_warnings,
1363: x_num_errors =>l_num_errors);
1364: END IF;
1365: --

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

1372: IF c_trip_rec%NOTFOUND THEN
1373: CLOSE c_trip_rec;
1374: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NOT_EXIST');
1375: FND_MESSAGE.SET_TOKEN('TRIP_NAME', l_freight_info_tab(l_index).TRIP_NAME);
1376: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1377: --
1378: IF l_debug_on THEN
1379: wsh_debug_sv.log (l_module_name,'WSH_TRIP_NOT_EXIST');
1380: END IF;

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

1392: x_valid_ids => l_valid_id_tab ,
1393: x_error_ids => l_error_ids ,
1394: x_valid_index_tab => l_valid_index_tab);
1395:
1396: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
1397: x_num_warnings =>l_num_warnings,
1398: x_num_errors =>l_num_errors);
1399: END IF;
1400: --

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

1407: IF c_stop_rec%NOTFOUND THEN
1408: CLOSE c_stop_rec;
1409: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_EXIST');
1410: FND_MESSAGE.SET_TOKEN('STOP_ID', l_freight_info_tab(l_index).STOP_ID);
1411: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1412: --
1413: IF l_debug_on THEN
1414: wsh_debug_sv.log (l_module_name,'WSH_STOP_NOT_EXIST');
1415: END IF;

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

1427: x_valid_ids => l_valid_id_tab ,
1428: x_error_ids => l_error_ids ,
1429: x_valid_index_tab => l_valid_index_tab);
1430:
1431: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
1432: x_num_warnings =>l_num_warnings,
1433: x_num_errors =>l_num_errors);
1434: END IF;
1435: --

Line 1450: WSH_UTIL_CORE.api_post_call(

1446: IF l_debug_on THEN
1447: WSH_DEBUG_SV.log(l_module_name,'WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost x_freight_cost_id,x_return_status',
1448: x_out_tab(l_index).freight_cost_id||','||l_return_status);
1449: END IF;
1450: WSH_UTIL_CORE.api_post_call(
1451: p_return_status => l_return_status,
1452: x_num_warnings => l_num_warnings,
1453: x_num_errors => l_num_errors,
1454: p_module_name => l_module_name,

Line 1468: WSH_UTIL_CORE.api_post_call(

1464:
1465: IF l_debug_on THEN
1466: WSH_DEBUG_SV.log(l_module_name,'Update_Freight_Costs x_return_status',l_return_status);
1467: END IF;
1468: WSH_UTIL_CORE.api_post_call(
1469: p_return_status => l_return_status,
1470: x_num_warnings => l_num_warnings,
1471: x_num_errors => l_num_errors,
1472: p_module_name => l_module_name,

Line 1542: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1538: l_index := p_freight_info_tab.NEXT(l_index);
1539: END LOOP;
1540:
1541: IF (l_num_errors = p_freight_info_tab.count ) THEN
1542: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1543: RAISE FND_API.G_EXC_ERROR;
1544: ELSIF (l_num_errors > 0 ) THEN
1545: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1546: RAISE WSH_UTIL_CORE.G_EXC_WARNING;

Line 1545: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1541: IF (l_num_errors = p_freight_info_tab.count ) THEN
1542: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1543: RAISE FND_API.G_EXC_ERROR;
1544: ELSIF (l_num_errors > 0 ) THEN
1545: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1546: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1547: ELSIF (l_num_warnings > 0 ) THEN
1548: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1549: RAISE WSH_UTIL_CORE.G_EXC_WARNING;

Line 1546: RAISE WSH_UTIL_CORE.G_EXC_WARNING;

1542: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1543: RAISE FND_API.G_EXC_ERROR;
1544: ELSIF (l_num_errors > 0 ) THEN
1545: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1546: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1547: ELSIF (l_num_warnings > 0 ) THEN
1548: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1549: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1550: ELSE

Line 1548: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1544: ELSIF (l_num_errors > 0 ) THEN
1545: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1546: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1547: ELSIF (l_num_warnings > 0 ) THEN
1548: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1549: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1550: ELSE
1551: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1552: END IF;

Line 1549: RAISE WSH_UTIL_CORE.G_EXC_WARNING;

1545: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1546: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1547: ELSIF (l_num_warnings > 0 ) THEN
1548: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1549: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1550: ELSE
1551: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1552: END IF;
1553:

Line 1551: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1547: ELSIF (l_num_warnings > 0 ) THEN
1548: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1549: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1550: ELSE
1551: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1552: END IF;
1553:
1554:
1555: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 1569: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1565: END IF;
1566:
1567: EXCEPTION
1568: WHEN RECORD_LOCKED THEN
1569: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1570: FND_MESSAGE.Set_Name('WSH', 'WSH_NO_LOCK');
1571: wsh_util_core.add_message(x_return_status,l_module_name);
1572: IF l_debug_on THEN
1573: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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

1567: EXCEPTION
1568: WHEN RECORD_LOCKED THEN
1569: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1570: FND_MESSAGE.Set_Name('WSH', 'WSH_NO_LOCK');
1571: wsh_util_core.add_message(x_return_status,l_module_name);
1572: IF l_debug_on THEN
1573: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1574: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
1575: END IF;

Line 1579: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;

1575: END IF;
1576: Rollback to Create_Update_Freight_Costs_Gp;
1577:
1578: WHEN FND_API.G_EXC_ERROR THEN
1579: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
1580: FND_MSG_PUB.Count_And_Get (
1581: p_count => x_msg_count,
1582: p_data => x_msg_data,
1583: p_encoded => FND_API.G_FALSE);

Line 1591: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

1587: END IF;
1588: Rollback to Create_Update_Freight_Costs_Gp;
1589:
1590: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1591: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1592: FND_MSG_PUB.Count_And_Get (
1593: p_count => x_msg_count,
1594: p_data => x_msg_data,
1595: p_encoded => FND_API.G_FALSE);

Line 1602: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

1598: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1599: END IF;
1600: Rollback to Create_Update_Freight_Costs_Gp;
1601:
1602: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1603: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1604: FND_MSG_PUB.Count_And_Get (
1605: p_count => x_msg_count,
1606: p_data => x_msg_data,

Line 1603: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1599: END IF;
1600: Rollback to Create_Update_Freight_Costs_Gp;
1601:
1602: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1603: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1604: FND_MSG_PUB.Count_And_Get (
1605: p_count => x_msg_count,
1606: p_data => x_msg_data,
1607: p_encoded => FND_API.G_FALSE);

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

1605: p_count => x_msg_count,
1606: p_data => x_msg_data,
1607: p_encoded => FND_API.G_FALSE);
1608: IF l_debug_on THEN
1609: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1610: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1611: END IF;
1612:
1613: WHEN OTHERS THEN

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

1606: p_data => x_msg_data,
1607: p_encoded => FND_API.G_FALSE);
1608: IF l_debug_on THEN
1609: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1610: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1611: END IF;
1612:
1613: WHEN OTHERS THEN
1614: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 1614: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

1610: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1611: END IF;
1612:
1613: WHEN OTHERS THEN
1614: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1615: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');
1616: FND_MSG_PUB.Count_And_Get (
1617: p_count => x_msg_count,
1618: p_data => x_msg_data,

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

1611: END IF;
1612:
1613: WHEN OTHERS THEN
1614: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1615: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');
1616: FND_MSG_PUB.Count_And_Get (
1617: p_count => x_msg_count,
1618: p_data => x_msg_data,
1619: p_encoded => FND_API.G_FALSE);

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

1688: x_return_status => x_return_status);
1689: IF l_debug_on THEN
1690: wsh_debug_sv.log (l_module_name, 'map_freightgrp_to_pvt x_return_status',x_return_status);
1691: END IF;
1692: IF ( x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
1693: raise FND_API.G_EXC_ERROR;
1694: END IF;
1695:
1696: l_in_rec.caller := 'WSH_GRP';

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

1708: p_freight_info_tab => l_freight_info_tab,
1709: p_in_rec => l_in_rec,
1710: x_out_tab => l_out_tab );
1711:
1712: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS AND l_out_tab.COUNT > 0 ) THEN
1713: x_freight_cost_id := l_out_tab(l_out_tab.FIRST).freight_cost_id;
1714: END IF;
1715:
1716: IF l_debug_on THEN

Line 1729: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

1725: END IF;
1726:
1727:
1728: WHEN OTHERS THEN
1729: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1730: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');
1731: IF l_debug_on THEN
1732: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1733: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

1726:
1727:
1728: WHEN OTHERS THEN
1729: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1730: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');
1731: IF l_debug_on THEN
1732: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1733: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1734: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');