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 355: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 359: WSH_DEBUG_SV.push(l_module_name);

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

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

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

Line 615: WSH_DEBUG_SV.pop(l_module_name);

611:
612: END IF;
613:
614: IF l_debug_on THEN
615: WSH_DEBUG_SV.pop(l_module_name);
616: END IF;
617:
618: EXCEPTION
619: WHEN e_dp_no_entity THEN

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

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');
629: END IF;
630: END Get_Disabled_List;

Line 627: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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');
629: END IF;
630: END Get_Disabled_List;
631:

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

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');
629: END IF;
630: END Get_Disabled_List;
631:
632: PROCEDURE Create_Update_Freight_Costs(

Line 749: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

745: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
746: --
747: IF l_debug_on IS NULL
748: THEN
749: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
750: END IF;
751: --
752: SAVEPOINT Create_Update_Freight_Costs_Gp;
753: IF l_debug_on THEN

Line 754: WSH_DEBUG_SV.push(l_module_name);

750: END IF;
751: --
752: SAVEPOINT Create_Update_Freight_Costs_Gp;
753: IF l_debug_on THEN
754: WSH_DEBUG_SV.push(l_module_name);
755: --
756: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
757: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
758: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

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

752: SAVEPOINT Create_Update_Freight_Costs_Gp;
753: IF l_debug_on THEN
754: WSH_DEBUG_SV.push(l_module_name);
755: --
756: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
757: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
758: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
759: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.caller',p_in_rec.caller);
760: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.action_code',p_in_rec.action_code);

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

753: IF l_debug_on THEN
754: WSH_DEBUG_SV.push(l_module_name);
755: --
756: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
757: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
758: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
759: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.caller',p_in_rec.caller);
760: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.action_code',p_in_rec.action_code);
761: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.phase',p_in_rec.phase);

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

754: WSH_DEBUG_SV.push(l_module_name);
755: --
756: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
757: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
758: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
759: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.caller',p_in_rec.caller);
760: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.action_code',p_in_rec.action_code);
761: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.phase',p_in_rec.phase);
762: END IF;

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

755: --
756: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
757: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
758: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
759: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.caller',p_in_rec.caller);
760: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.action_code',p_in_rec.action_code);
761: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.phase',p_in_rec.phase);
762: END IF;
763: --

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

756: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
757: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
758: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
759: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.caller',p_in_rec.caller);
760: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.action_code',p_in_rec.action_code);
761: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.phase',p_in_rec.phase);
762: END IF;
763: --
764: IF NOT FND_API.Compatible_API_Call(l_api_version_number, p_api_version_number,l_api_name,G_PKG_NAME) THEN

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

757: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
758: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
759: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.caller',p_in_rec.caller);
760: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.action_code',p_in_rec.action_code);
761: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.phase',p_in_rec.phase);
762: END IF;
763: --
764: IF NOT FND_API.Compatible_API_Call(l_api_version_number, p_api_version_number,l_api_name,G_PKG_NAME) THEN
765: IF l_debug_on THEN

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

762: END IF;
763: --
764: IF NOT FND_API.Compatible_API_Call(l_api_version_number, p_api_version_number,l_api_name,G_PKG_NAME) THEN
765: IF l_debug_on THEN
766: WSH_DEBUG_SV.log(l_module_name,'Not compatible');
767: END IF;
768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
769: END IF;
770:

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

798: p_action => p_in_rec.action_code,
799: x_return_status => l_return_status);
800:
801: IF l_debug_on THEN
802: WSH_DEBUG_SV.log(l_module_name,'WSH_ACTIONS_LEVELS.set_validation_level l_return_status',l_return_status);
803: 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));
804: 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));
805: 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));
806: 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 803: 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));

799: x_return_status => l_return_status);
800:
801: IF l_debug_on THEN
802: WSH_DEBUG_SV.log(l_module_name,'WSH_ACTIONS_LEVELS.set_validation_level l_return_status',l_return_status);
803: 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));
804: 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));
805: 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));
806: 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));
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));

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

800:
801: IF l_debug_on THEN
802: WSH_DEBUG_SV.log(l_module_name,'WSH_ACTIONS_LEVELS.set_validation_level l_return_status',l_return_status);
803: 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));
804: 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));
805: 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));
806: 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));
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));

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

801: IF l_debug_on THEN
802: WSH_DEBUG_SV.log(l_module_name,'WSH_ACTIONS_LEVELS.set_validation_level l_return_status',l_return_status);
803: 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));
804: 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));
805: 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));
806: 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));
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;

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

802: WSH_DEBUG_SV.log(l_module_name,'WSH_ACTIONS_LEVELS.set_validation_level l_return_status',l_return_status);
803: 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));
804: 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));
805: 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));
806: 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));
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:

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

803: 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));
804: 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));
805: 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));
806: 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));
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,

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

804: 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));
805: 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));
806: 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));
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,

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

855: p_freight_cost_type => l_freight_info_tab(l_index).freight_cost_type,
856: x_freight_cost_type_id => l_freight_info_tab(l_index).freight_cost_type_id,
857: x_return_status => l_return_status);
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,

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

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

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

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

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

930: x_return_status => l_return_status,
931: x_adjusted_amount => l_adjusted_amount); -- OTM R12, glog proj
932:
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,

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

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

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

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

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

1116: WHERE stop_id = l_stop_id
1117: AND ROWNUM = 1;
1118:
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,

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

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

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

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;
1310: --
1311: END IF;

Line 1344: wsh_debug_sv.log (l_module_name,'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;
1346: --
1347: RAISE FND_API.G_EXC_ERROR;
1348: END IF;

Line 1379: wsh_debug_sv.log (l_module_name,'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;
1381: --
1382: RAISE FND_API.G_EXC_ERROR;
1383: END IF;

Line 1414: wsh_debug_sv.log (l_module_name,'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;
1416: --
1417: RAISE FND_API.G_EXC_ERROR;
1418: END IF;

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

1443: x_freight_cost_id => x_out_tab(l_index).freight_cost_id,
1444: x_return_status => l_return_status);
1445:
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,

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

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

Line 1564: WSH_DEBUG_SV.pop(l_module_name);

1560: p_count => x_msg_count,
1561: p_data => x_msg_data);
1562:
1563: IF l_debug_on THEN
1564: WSH_DEBUG_SV.pop(l_module_name);
1565: END IF;
1566:
1567: EXCEPTION
1568: WHEN RECORD_LOCKED THEN

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

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;
1576: Rollback to Create_Update_Freight_Costs_Gp;
1577:

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

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;
1576: Rollback to Create_Update_Freight_Costs_Gp;
1577:
1578: WHEN FND_API.G_EXC_ERROR THEN

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

1581: p_count => x_msg_count,
1582: p_data => x_msg_data,
1583: p_encoded => FND_API.G_FALSE);
1584: IF l_debug_on THEN
1585: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1586: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1587: END IF;
1588: Rollback to Create_Update_Freight_Costs_Gp;
1589:

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

1582: p_data => x_msg_data,
1583: p_encoded => FND_API.G_FALSE);
1584: IF l_debug_on THEN
1585: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1586: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1587: END IF;
1588: Rollback to Create_Update_Freight_Costs_Gp;
1589:
1590: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1593: p_count => x_msg_count,
1594: p_data => x_msg_data,
1595: p_encoded => FND_API.G_FALSE);
1596: IF l_debug_on THEN
1597: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
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:

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

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

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

1617: p_count => x_msg_count,
1618: p_data => x_msg_data,
1619: p_encoded => FND_API.G_FALSE);
1620: IF l_debug_on THEN
1621: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1622: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1623: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1624: END IF;
1625: Rollback to Create_Update_Freight_Costs_Gp;

Line 1622: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1618: p_data => x_msg_data,
1619: p_encoded => FND_API.G_FALSE);
1620: IF l_debug_on THEN
1621: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1622: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1623: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1624: END IF;
1625: Rollback to Create_Update_Freight_Costs_Gp;
1626: END Create_Update_Freight_Costs;

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

1619: p_encoded => FND_API.G_FALSE);
1620: IF l_debug_on THEN
1621: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1622: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1623: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1624: END IF;
1625: Rollback to Create_Update_Freight_Costs_Gp;
1626: END Create_Update_Freight_Costs;
1627:

Line 1674: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1670: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1671: --
1672: IF l_debug_on IS NULL
1673: THEN
1674: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1675: END IF;
1676: --
1677: IF NOT FND_API.Compatible_API_Call (l_api_version_number,p_api_version_number ,l_api_name ,G_PKG_NAME) THEN
1678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

Line 1717: WSH_DEBUG_SV.pop(l_module_name);

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
1717: WSH_DEBUG_SV.pop(l_module_name);
1718: END IF;
1719:
1720: EXCEPTION
1721: WHEN FND_API.G_EXC_ERROR THEN

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

1719:
1720: EXCEPTION
1721: WHEN FND_API.G_EXC_ERROR THEN
1722: IF l_debug_on THEN
1723: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1724: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1725: END IF;
1726:
1727:

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

1720: EXCEPTION
1721: WHEN FND_API.G_EXC_ERROR THEN
1722: IF l_debug_on THEN
1723: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1724: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1725: END IF;
1726:
1727:
1728: WHEN OTHERS THEN

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

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');
1735: END IF;
1736: END Create_Update_Freight_Costs;

Line 1733: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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');
1735: END IF;
1736: END Create_Update_Freight_Costs;
1737: --Harmonizing Project I :heali

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

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');
1735: END IF;
1736: END Create_Update_Freight_Costs;
1737: --Harmonizing Project I :heali
1738: