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_DEBUG_SV

Line 30: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

26: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
27: --
28: IF l_debug_on IS NULL
29: THEN
30: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
31: END IF;
32: --
33: IF l_debug_on THEN
34: WSH_DEBUG_SV.push(l_module_name);

Line 34: WSH_DEBUG_SV.push(l_module_name);

30: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
31: END IF;
32: --
33: IF l_debug_on THEN
34: WSH_DEBUG_SV.push(l_module_name);
35: --
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;

Line 36: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE',P_FREIGHT_COST_TYPE);

32: --
33: IF l_debug_on THEN
34: WSH_DEBUG_SV.push(l_module_name);
35: --
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;

Line 37: WSH_DEBUG_SV.log(l_module_name,'X_FREIGHT_COST_TYPE_ID',X_FREIGHT_COST_TYPE_ID);

33: IF l_debug_on THEN
34: WSH_DEBUG_SV.push(l_module_name);
35: --
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:

Line 61: WSH_DEBUG_SV.log(l_module_name,

57: END IF;
58: END IF;
59:
60: IF l_debug_on THEN
61: WSH_DEBUG_SV.log(l_module_name,
62: 'x_freight_cost_type_id',x_freight_cost_type_id);
63: END IF;
64: --
65: IF l_debug_on THEN

Line 66: WSH_DEBUG_SV.pop(l_module_name);

62: 'x_freight_cost_type_id',x_freight_cost_type_id);
63: END IF;
64: --
65: IF l_debug_on THEN
66: WSH_DEBUG_SV.pop(l_module_name);
67: END IF;
68: --
69: EXCEPTION
70: WHEN No_Data_Found THEN

Line 74: WSH_DEBUG_SV.logmsg(l_module_name,'NO_DATA_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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');
76: END IF;
77: --
78: WHEN Invalid_Type THEN

Line 75: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');

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');
76: END IF;
77: --
78: WHEN Invalid_Type THEN
79: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 82: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_TYPE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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');
84: END IF;
85: --
86: WHEN others THEN

Line 83: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_TYPE');

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');
84: END IF;
85: --
86: WHEN others THEN
87: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 90: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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');
92: END IF;
93: --
94: END validate_freight_cost_type;

Line 91: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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');
92: END IF;
93: --
94: END validate_freight_cost_type;
95:

Line 119: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

115: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
116: --
117: IF l_debug_on IS NULL
118: THEN
119: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
120: END IF;
121: --
122: IF l_debug_on THEN
123: WSH_DEBUG_SV.push(l_module_name);

Line 123: WSH_DEBUG_SV.push(l_module_name);

119: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
120: END IF;
121: --
122: IF l_debug_on THEN
123: WSH_DEBUG_SV.push(l_module_name);
124: --
125: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
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);

Line 125: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);

121: --
122: IF l_debug_on THEN
123: WSH_DEBUG_SV.push(l_module_name);
124: --
125: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
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: --

Line 126: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);

122: IF l_debug_on THEN
123: WSH_DEBUG_SV.push(l_module_name);
124: --
125: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
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;

Line 127: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

123: WSH_DEBUG_SV.push(l_module_name);
124: --
125: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
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:

Line 139: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);

135: x_return_status => x_return_status);
136:
137: --
138: IF l_debug_on THEN
139: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
140: WSH_DEBUG_SV.pop(l_module_name);
141: END IF;
142: --
143: EXCEPTION

Line 140: WSH_DEBUG_SV.pop(l_module_name);

136:
137: --
138: IF l_debug_on THEN
139: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
140: WSH_DEBUG_SV.pop(l_module_name);
141: END IF;
142: --
143: EXCEPTION
144: WHEN OTHERS THEN

Line 159: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

155: p_data => x_msg_data
156: );
157: --
158: IF l_debug_on THEN
159: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
160: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
161: END IF;
162: --
163: END Delete_Freight_Costs;

Line 160: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

156: );
157: --
158: IF l_debug_on THEN
159: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
160: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
161: END IF;
162: --
163: END Delete_Freight_Costs;
164:

Line 184: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

180: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
181: --
182: IF l_debug_on IS NULL
183: THEN
184: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
185: END IF;
186: --
187: IF l_debug_on THEN
188: WSH_DEBUG_SV.push(l_module_name);

Line 188: WSH_DEBUG_SV.push(l_module_name);

184: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
185: END IF;
186: --
187: IF l_debug_on THEN
188: WSH_DEBUG_SV.push(l_module_name);
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: --

Line 189: WSH_DEBUG_SV.log(l_module_name,'p_grp_freight_rec.FREIGHT_COST_ID',p_grp_freight_rec.FREIGHT_COST_ID);

185: END IF;
186: --
187: IF l_debug_on THEN
188: WSH_DEBUG_SV.push(l_module_name);
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;

Line 190: WSH_DEBUG_SV.log(l_module_name,'p_grp_freight_rec.FREIGHT_COST_TYPE_ID',p_grp_freight_rec.FREIGHT_COST_TYPE_ID);

186: --
187: IF l_debug_on THEN
188: WSH_DEBUG_SV.push(l_module_name);
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:

Line 252: WSH_DEBUG_SV.pop(l_module_name);

248: x_pvt_freight_rec.PLANNED_DEP_DATE := p_grp_freight_rec.PLANNED_DEP_DATE;
249: x_pvt_freight_rec.COMMODITY_CATEGORY_ID := p_grp_freight_rec.COMMODITY_CATEGORY_ID;
250:
251: IF l_debug_on THEN
252: WSH_DEBUG_SV.pop(l_module_name);
253: END IF;
254: --
255: EXCEPTION
256: WHEN OTHERS THEN

Line 261: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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');
263: END IF;
264: --
265: END map_freightgrp_to_pvt;

Line 262: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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');
263: END IF;
264: --
265: END map_freightgrp_to_pvt;
266:

Line 357: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

353: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
354: --
355: IF l_debug_on IS NULL
356: THEN
357: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
358: END IF;
359: --
360: IF l_debug_on THEN
361: WSH_DEBUG_SV.push(l_module_name);

Line 361: WSH_DEBUG_SV.push(l_module_name);

357: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
358: END IF;
359: --
360: IF l_debug_on THEN
361: WSH_DEBUG_SV.push(l_module_name);
362: WSH_DEBUG_SV.log(l_module_name,'freight_cost_id',p_freight_rec.freight_cost_id);
363: END IF;
364:
365: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 362: WSH_DEBUG_SV.log(l_module_name,'freight_cost_id',p_freight_rec.freight_cost_id);

358: END IF;
359: --
360: IF l_debug_on THEN
361: WSH_DEBUG_SV.push(l_module_name);
362: WSH_DEBUG_SV.log(l_module_name,'freight_cost_id',p_freight_rec.freight_cost_id);
363: END IF;
364:
365: x_return_status := FND_API.G_RET_STS_SUCCESS;
366:

Line 404: WSH_DEBUG_SV.logmsg(l_module_name,'NO_DATA_FOUND exception has occurred for conversion type.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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');
406: END IF;
407:
408: END;

Line 405: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');

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');
406: END IF;
407:
408: END;
409: --Bugfix 8736256 End

Line 642: WSH_DEBUG_SV.pop(l_module_name);

638:
639: END IF;
640:
641: IF l_debug_on THEN
642: WSH_DEBUG_SV.pop(l_module_name);
643: END IF;
644:
645: EXCEPTION
646: WHEN e_dp_no_entity THEN

Line 661: WSH_DEBUG_SV.logmsg(l_module_name,'Exception occured: Missing FREIGHT COST ID ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

657: );
658: END IF;
659: --
660: IF l_debug_on THEN
661: WSH_DEBUG_SV.logmsg(l_module_name,'Exception occured: Missing FREIGHT COST ID ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
662: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:MISSING_FREIGHT_COST_ID');
663: END IF;
664: --
665:

Line 662: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:MISSING_FREIGHT_COST_ID');

658: END IF;
659: --
660: IF l_debug_on THEN
661: WSH_DEBUG_SV.logmsg(l_module_name,'Exception occured: Missing FREIGHT COST ID ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
662: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:MISSING_FREIGHT_COST_ID');
663: END IF;
664: --
665:
666: WHEN OTHERS THEN

Line 670: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||

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');
673: END IF;
674: END Get_Disabled_List;

Line 671: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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');
673: END IF;
674: END Get_Disabled_List;
675:

Line 672: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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');
673: END IF;
674: END Get_Disabled_List;
675:
676: PROCEDURE Create_Update_Freight_Costs(

Line 795: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

791: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
792: --
793: IF l_debug_on IS NULL
794: THEN
795: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
796: END IF;
797: --
798: SAVEPOINT Create_Update_Freight_Costs_Gp;
799: IF l_debug_on THEN

Line 800: WSH_DEBUG_SV.push(l_module_name);

796: END IF;
797: --
798: SAVEPOINT Create_Update_Freight_Costs_Gp;
799: IF l_debug_on THEN
800: WSH_DEBUG_SV.push(l_module_name);
801: --
802: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
803: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
804: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

Line 802: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);

798: SAVEPOINT Create_Update_Freight_Costs_Gp;
799: IF l_debug_on THEN
800: WSH_DEBUG_SV.push(l_module_name);
801: --
802: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
803: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
804: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
805: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.caller',p_in_rec.caller);
806: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.action_code',p_in_rec.action_code);

Line 803: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);

799: IF l_debug_on THEN
800: WSH_DEBUG_SV.push(l_module_name);
801: --
802: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
803: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
804: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
805: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.caller',p_in_rec.caller);
806: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.action_code',p_in_rec.action_code);
807: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.phase',p_in_rec.phase);

Line 804: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

800: WSH_DEBUG_SV.push(l_module_name);
801: --
802: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
803: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
804: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
805: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.caller',p_in_rec.caller);
806: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.action_code',p_in_rec.action_code);
807: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.phase',p_in_rec.phase);
808: END IF;

Line 805: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.caller',p_in_rec.caller);

801: --
802: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
803: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
804: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
805: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.caller',p_in_rec.caller);
806: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.action_code',p_in_rec.action_code);
807: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.phase',p_in_rec.phase);
808: END IF;
809: --

Line 806: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.action_code',p_in_rec.action_code);

802: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
803: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
804: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
805: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.caller',p_in_rec.caller);
806: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.action_code',p_in_rec.action_code);
807: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.phase',p_in_rec.phase);
808: END IF;
809: --
810: IF NOT FND_API.Compatible_API_Call(l_api_version_number, p_api_version_number,l_api_name,G_PKG_NAME) THEN

Line 807: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.phase',p_in_rec.phase);

803: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
804: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
805: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.caller',p_in_rec.caller);
806: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.action_code',p_in_rec.action_code);
807: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.phase',p_in_rec.phase);
808: END IF;
809: --
810: IF NOT FND_API.Compatible_API_Call(l_api_version_number, p_api_version_number,l_api_name,G_PKG_NAME) THEN
811: IF l_debug_on THEN

Line 812: WSH_DEBUG_SV.log(l_module_name,'Not compatible');

808: END IF;
809: --
810: IF NOT FND_API.Compatible_API_Call(l_api_version_number, p_api_version_number,l_api_name,G_PKG_NAME) THEN
811: IF l_debug_on THEN
812: WSH_DEBUG_SV.log(l_module_name,'Not compatible');
813: END IF;
814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
815: END IF;
816:

Line 848: WSH_DEBUG_SV.log(l_module_name,'WSH_ACTIONS_LEVELS.set_validation_level l_return_status',l_return_status);

844: p_action => p_in_rec.action_code,
845: x_return_status => l_return_status);
846:
847: IF l_debug_on THEN
848: WSH_DEBUG_SV.log(l_module_name,'WSH_ACTIONS_LEVELS.set_validation_level l_return_status',l_return_status);
849: WSH_DEBUG_SV.log(l_module_name,'C_FREIGHT_UNIT_AMT_LVL',WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FREIGHT_UNIT_AMT_LVL));
850: WSH_DEBUG_SV.log(l_module_name,'C_FREIGHT_CONV_RATE_LVL',WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FREIGHT_CONV_RATE_LVL));
851: WSH_DEBUG_SV.log(l_module_name,'C_FREIGHT_CURR_CODE_LVL',WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FREIGHT_CURR_CODE_LVL));
852: WSH_DEBUG_SV.log(l_module_name,'C_PARENT_ENTITY_LVL',WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_PARENT_ENTITY_LVL));

Line 849: WSH_DEBUG_SV.log(l_module_name,'C_FREIGHT_UNIT_AMT_LVL',WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FREIGHT_UNIT_AMT_LVL));

845: x_return_status => l_return_status);
846:
847: IF l_debug_on THEN
848: WSH_DEBUG_SV.log(l_module_name,'WSH_ACTIONS_LEVELS.set_validation_level l_return_status',l_return_status);
849: WSH_DEBUG_SV.log(l_module_name,'C_FREIGHT_UNIT_AMT_LVL',WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FREIGHT_UNIT_AMT_LVL));
850: WSH_DEBUG_SV.log(l_module_name,'C_FREIGHT_CONV_RATE_LVL',WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FREIGHT_CONV_RATE_LVL));
851: WSH_DEBUG_SV.log(l_module_name,'C_FREIGHT_CURR_CODE_LVL',WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FREIGHT_CURR_CODE_LVL));
852: WSH_DEBUG_SV.log(l_module_name,'C_PARENT_ENTITY_LVL',WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_PARENT_ENTITY_LVL));
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));

Line 850: WSH_DEBUG_SV.log(l_module_name,'C_FREIGHT_CONV_RATE_LVL',WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FREIGHT_CONV_RATE_LVL));

846:
847: IF l_debug_on THEN
848: WSH_DEBUG_SV.log(l_module_name,'WSH_ACTIONS_LEVELS.set_validation_level l_return_status',l_return_status);
849: WSH_DEBUG_SV.log(l_module_name,'C_FREIGHT_UNIT_AMT_LVL',WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FREIGHT_UNIT_AMT_LVL));
850: WSH_DEBUG_SV.log(l_module_name,'C_FREIGHT_CONV_RATE_LVL',WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FREIGHT_CONV_RATE_LVL));
851: WSH_DEBUG_SV.log(l_module_name,'C_FREIGHT_CURR_CODE_LVL',WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FREIGHT_CURR_CODE_LVL));
852: WSH_DEBUG_SV.log(l_module_name,'C_PARENT_ENTITY_LVL',WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_PARENT_ENTITY_LVL));
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));

Line 851: WSH_DEBUG_SV.log(l_module_name,'C_FREIGHT_CURR_CODE_LVL',WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FREIGHT_CURR_CODE_LVL));

847: IF l_debug_on THEN
848: WSH_DEBUG_SV.log(l_module_name,'WSH_ACTIONS_LEVELS.set_validation_level l_return_status',l_return_status);
849: WSH_DEBUG_SV.log(l_module_name,'C_FREIGHT_UNIT_AMT_LVL',WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FREIGHT_UNIT_AMT_LVL));
850: WSH_DEBUG_SV.log(l_module_name,'C_FREIGHT_CONV_RATE_LVL',WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FREIGHT_CONV_RATE_LVL));
851: WSH_DEBUG_SV.log(l_module_name,'C_FREIGHT_CURR_CODE_LVL',WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FREIGHT_CURR_CODE_LVL));
852: WSH_DEBUG_SV.log(l_module_name,'C_PARENT_ENTITY_LVL',WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_PARENT_ENTITY_LVL));
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;

Line 852: WSH_DEBUG_SV.log(l_module_name,'C_PARENT_ENTITY_LVL',WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_PARENT_ENTITY_LVL));

848: WSH_DEBUG_SV.log(l_module_name,'WSH_ACTIONS_LEVELS.set_validation_level l_return_status',l_return_status);
849: WSH_DEBUG_SV.log(l_module_name,'C_FREIGHT_UNIT_AMT_LVL',WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FREIGHT_UNIT_AMT_LVL));
850: WSH_DEBUG_SV.log(l_module_name,'C_FREIGHT_CONV_RATE_LVL',WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FREIGHT_CONV_RATE_LVL));
851: WSH_DEBUG_SV.log(l_module_name,'C_FREIGHT_CURR_CODE_LVL',WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FREIGHT_CURR_CODE_LVL));
852: WSH_DEBUG_SV.log(l_module_name,'C_PARENT_ENTITY_LVL',WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_PARENT_ENTITY_LVL));
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:

Line 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));

849: WSH_DEBUG_SV.log(l_module_name,'C_FREIGHT_UNIT_AMT_LVL',WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FREIGHT_UNIT_AMT_LVL));
850: WSH_DEBUG_SV.log(l_module_name,'C_FREIGHT_CONV_RATE_LVL',WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FREIGHT_CONV_RATE_LVL));
851: WSH_DEBUG_SV.log(l_module_name,'C_FREIGHT_CURR_CODE_LVL',WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FREIGHT_CURR_CODE_LVL));
852: WSH_DEBUG_SV.log(l_module_name,'C_PARENT_ENTITY_LVL',WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_PARENT_ENTITY_LVL));
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,

Line 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));

850: WSH_DEBUG_SV.log(l_module_name,'C_FREIGHT_CONV_RATE_LVL',WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FREIGHT_CONV_RATE_LVL));
851: WSH_DEBUG_SV.log(l_module_name,'C_FREIGHT_CURR_CODE_LVL',WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FREIGHT_CURR_CODE_LVL));
852: WSH_DEBUG_SV.log(l_module_name,'C_PARENT_ENTITY_LVL',WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_PARENT_ENTITY_LVL));
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,

Line 905: WSH_DEBUG_SV.log(l_module_name,'validate_freight_cost_type l_return_status',l_return_status);

901: p_freight_cost_type => l_freight_info_tab(l_index).freight_cost_type,
902: x_freight_cost_type_id => l_freight_info_tab(l_index).freight_cost_type_id,
903: x_return_status => l_return_status);
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,

Line 938: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_Negative x_return_status',l_return_status);

934: p_field_name => 'unit_amount',
935: x_return_status => l_return_status );
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,

Line 958: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_Negative x_return_status',l_return_status);

954: p_field_name => 'conversion_rate',
955: x_return_status => l_return_status );
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,

Line 980: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_Currency l_return_status',l_return_status);

976: x_return_status => l_return_status,
977: x_adjusted_amount => l_adjusted_amount); -- OTM R12, glog proj
978:
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,

Line 1033: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_Trip_name x_return_status',l_return_status);

1029: p_trip_name => l_freight_info_tab(l_index).trip_name,
1030: x_return_status => l_return_status);
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,

Line 1110: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_stop_name x_return_status',l_return_status);

1106: p_planned_dep_date =>l_freight_info_tab(l_index).planned_dep_date,
1107: x_return_status =>l_return_status);
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,

Line 1166: WSH_DEBUG_SV.log(l_module_name,'l_counts',l_counts);

1162: WHERE stop_id = l_stop_id
1163: AND ROWNUM = 1;
1164:
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,

Line 1187: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_delivery_name x_return_status',l_return_status);

1183: p_delivery_name =>l_freight_info_tab(l_index).delivery_name,
1184: x_return_status =>l_return_status);
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,

Line 1353: wsh_debug_sv.log (l_module_name,'WSH_DETAIL_NOT_EXIST');

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;
1356: --
1357: END IF;

Line 1390: wsh_debug_sv.log (l_module_name,'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;
1392: --
1393: RAISE FND_API.G_EXC_ERROR;
1394: END IF;

Line 1425: wsh_debug_sv.log (l_module_name,'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;
1427: --
1428: RAISE FND_API.G_EXC_ERROR;
1429: END IF;

Line 1460: wsh_debug_sv.log (l_module_name,'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;
1462: --
1463: RAISE FND_API.G_EXC_ERROR;
1464: END IF;

Line 1493: WSH_DEBUG_SV.log(l_module_name,'WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost x_freight_cost_id,x_return_status',

1489: x_freight_cost_id => x_out_tab(l_index).freight_cost_id,
1490: x_return_status => l_return_status);
1491:
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,

Line 1512: WSH_DEBUG_SV.log(l_module_name,'Update_Freight_Costs x_return_status',l_return_status);

1508: p_freight_cost_info => l_freight_info_tab(l_index),
1509: x_return_status => l_return_status);
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,

Line 1610: WSH_DEBUG_SV.pop(l_module_name);

1606: p_count => x_msg_count,
1607: p_data => x_msg_data);
1608:
1609: IF l_debug_on THEN
1610: WSH_DEBUG_SV.pop(l_module_name);
1611: END IF;
1612:
1613: EXCEPTION
1614: WHEN RECORD_LOCKED THEN

Line 1619: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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;
1622: Rollback to Create_Update_Freight_Costs_Gp;
1623:

Line 1620: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');

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;
1622: Rollback to Create_Update_Freight_Costs_Gp;
1623:
1624: WHEN FND_API.G_EXC_ERROR THEN

Line 1631: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1627: p_count => x_msg_count,
1628: p_data => x_msg_data,
1629: p_encoded => FND_API.G_FALSE);
1630: IF l_debug_on THEN
1631: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1632: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1633: END IF;
1634: Rollback to Create_Update_Freight_Costs_Gp;
1635:

Line 1632: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

1628: p_data => x_msg_data,
1629: p_encoded => FND_API.G_FALSE);
1630: IF l_debug_on THEN
1631: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1632: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1633: END IF;
1634: Rollback to Create_Update_Freight_Costs_Gp;
1635:
1636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1643: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1639: p_count => x_msg_count,
1640: p_data => x_msg_data,
1641: p_encoded => FND_API.G_FALSE);
1642: IF l_debug_on THEN
1643: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
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:

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

1640: p_data => x_msg_data,
1641: p_encoded => FND_API.G_FALSE);
1642: IF l_debug_on THEN
1643: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
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

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 1667: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||

1663: p_count => x_msg_count,
1664: p_data => x_msg_data,
1665: p_encoded => FND_API.G_FALSE);
1666: IF l_debug_on THEN
1667: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1668: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1669: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1670: END IF;
1671: Rollback to Create_Update_Freight_Costs_Gp;

Line 1668: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1664: p_data => x_msg_data,
1665: p_encoded => FND_API.G_FALSE);
1666: IF l_debug_on THEN
1667: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1668: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1669: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1670: END IF;
1671: Rollback to Create_Update_Freight_Costs_Gp;
1672: END Create_Update_Freight_Costs;

Line 1669: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

1665: p_encoded => FND_API.G_FALSE);
1666: IF l_debug_on THEN
1667: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1668: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1669: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1670: END IF;
1671: Rollback to Create_Update_Freight_Costs_Gp;
1672: END Create_Update_Freight_Costs;
1673:

Line 1720: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1716: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1717: --
1718: IF l_debug_on IS NULL
1719: THEN
1720: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1721: END IF;
1722: --
1723: IF NOT FND_API.Compatible_API_Call (l_api_version_number,p_api_version_number ,l_api_name ,G_PKG_NAME) THEN
1724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1736: wsh_debug_sv.log (l_module_name, 'map_freightgrp_to_pvt x_return_status',x_return_status);

1732: p_grp_freight_rec => p_pub_freight_costs,
1733: x_pvt_freight_rec => l_pvt_freight_rec,
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;

Line 1763: WSH_DEBUG_SV.pop(l_module_name);

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
1763: WSH_DEBUG_SV.pop(l_module_name);
1764: END IF;
1765:
1766: EXCEPTION
1767: WHEN FND_API.G_EXC_ERROR THEN

Line 1769: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1765:
1766: EXCEPTION
1767: WHEN FND_API.G_EXC_ERROR THEN
1768: IF l_debug_on THEN
1769: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1770: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1771: END IF;
1772:
1773:

Line 1770: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

1766: EXCEPTION
1767: WHEN FND_API.G_EXC_ERROR THEN
1768: IF l_debug_on THEN
1769: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1770: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1771: END IF;
1772:
1773:
1774: WHEN OTHERS THEN

Line 1778: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||

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');
1781: END IF;
1782: END Create_Update_Freight_Costs;

Line 1779: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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');
1781: END IF;
1782: END Create_Update_Freight_Costs;
1783: --Harmonizing Project I :heali

Line 1780: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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');
1781: END IF;
1782: END Create_Update_Freight_Costs;
1783: --Harmonizing Project I :heali
1784: