DBA Data[Home] [Help]

APPS.WSH_SHIPMENT_BATCH_PUB dependencies on WSH_DEBUG_SV

Line 113: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

109: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
110: --
111: IF l_debug_on IS NULL
112: THEN
113: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
114: END IF;
115: --
116: IF l_debug_on THEN
117: WSH_DEBUG_SV.push(l_module_name);

Line 117: WSH_DEBUG_SV.push(l_module_name);

113: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
114: END IF;
115: --
116: IF l_debug_on THEN
117: WSH_DEBUG_SV.push(l_module_name);
118: --
119: WSH_DEBUG_SV.log(l_module_name, 'p_commit',p_commit);
120: WSH_DEBUG_SV.log(l_module_name, 'p_log_level',p_log_level);
121: WSH_DEBUG_SV.log(l_module_name, 'p_process_mode',p_process_mode);

Line 119: WSH_DEBUG_SV.log(l_module_name, 'p_commit',p_commit);

115: --
116: IF l_debug_on THEN
117: WSH_DEBUG_SV.push(l_module_name);
118: --
119: WSH_DEBUG_SV.log(l_module_name, 'p_commit',p_commit);
120: WSH_DEBUG_SV.log(l_module_name, 'p_log_level',p_log_level);
121: WSH_DEBUG_SV.log(l_module_name, 'p_process_mode',p_process_mode);
122: WSH_DEBUG_SV.log(l_module_name, 'p_api_version_number', p_api_version_number);
123: WSH_DEBUG_SV.log(l_module_name, 'p_organization_id', p_organization_id);

Line 120: WSH_DEBUG_SV.log(l_module_name, 'p_log_level',p_log_level);

116: IF l_debug_on THEN
117: WSH_DEBUG_SV.push(l_module_name);
118: --
119: WSH_DEBUG_SV.log(l_module_name, 'p_commit',p_commit);
120: WSH_DEBUG_SV.log(l_module_name, 'p_log_level',p_log_level);
121: WSH_DEBUG_SV.log(l_module_name, 'p_process_mode',p_process_mode);
122: WSH_DEBUG_SV.log(l_module_name, 'p_api_version_number', p_api_version_number);
123: WSH_DEBUG_SV.log(l_module_name, 'p_organization_id', p_organization_id);
124: WSH_DEBUG_SV.log(l_module_name, 'p_customer_id', p_customer_id);

Line 121: WSH_DEBUG_SV.log(l_module_name, 'p_process_mode',p_process_mode);

117: WSH_DEBUG_SV.push(l_module_name);
118: --
119: WSH_DEBUG_SV.log(l_module_name, 'p_commit',p_commit);
120: WSH_DEBUG_SV.log(l_module_name, 'p_log_level',p_log_level);
121: WSH_DEBUG_SV.log(l_module_name, 'p_process_mode',p_process_mode);
122: WSH_DEBUG_SV.log(l_module_name, 'p_api_version_number', p_api_version_number);
123: WSH_DEBUG_SV.log(l_module_name, 'p_organization_id', p_organization_id);
124: WSH_DEBUG_SV.log(l_module_name, 'p_customer_id', p_customer_id);
125: WSH_DEBUG_SV.log(l_module_name, 'p_ship_to_location_id', p_ship_to_location_id);

Line 122: WSH_DEBUG_SV.log(l_module_name, 'p_api_version_number', p_api_version_number);

118: --
119: WSH_DEBUG_SV.log(l_module_name, 'p_commit',p_commit);
120: WSH_DEBUG_SV.log(l_module_name, 'p_log_level',p_log_level);
121: WSH_DEBUG_SV.log(l_module_name, 'p_process_mode',p_process_mode);
122: WSH_DEBUG_SV.log(l_module_name, 'p_api_version_number', p_api_version_number);
123: WSH_DEBUG_SV.log(l_module_name, 'p_organization_id', p_organization_id);
124: WSH_DEBUG_SV.log(l_module_name, 'p_customer_id', p_customer_id);
125: WSH_DEBUG_SV.log(l_module_name, 'p_ship_to_location_id', p_ship_to_location_id);
126: WSH_DEBUG_SV.log(l_module_name, 'p_transaction_type_id', p_transaction_type_id);

Line 123: WSH_DEBUG_SV.log(l_module_name, 'p_organization_id', p_organization_id);

119: WSH_DEBUG_SV.log(l_module_name, 'p_commit',p_commit);
120: WSH_DEBUG_SV.log(l_module_name, 'p_log_level',p_log_level);
121: WSH_DEBUG_SV.log(l_module_name, 'p_process_mode',p_process_mode);
122: WSH_DEBUG_SV.log(l_module_name, 'p_api_version_number', p_api_version_number);
123: WSH_DEBUG_SV.log(l_module_name, 'p_organization_id', p_organization_id);
124: WSH_DEBUG_SV.log(l_module_name, 'p_customer_id', p_customer_id);
125: WSH_DEBUG_SV.log(l_module_name, 'p_ship_to_location_id', p_ship_to_location_id);
126: WSH_DEBUG_SV.log(l_module_name, 'p_transaction_type_id', p_transaction_type_id);
127: WSH_DEBUG_SV.log(l_module_name, 'p_from_order_number', p_from_order_number);

Line 124: WSH_DEBUG_SV.log(l_module_name, 'p_customer_id', p_customer_id);

120: WSH_DEBUG_SV.log(l_module_name, 'p_log_level',p_log_level);
121: WSH_DEBUG_SV.log(l_module_name, 'p_process_mode',p_process_mode);
122: WSH_DEBUG_SV.log(l_module_name, 'p_api_version_number', p_api_version_number);
123: WSH_DEBUG_SV.log(l_module_name, 'p_organization_id', p_organization_id);
124: WSH_DEBUG_SV.log(l_module_name, 'p_customer_id', p_customer_id);
125: WSH_DEBUG_SV.log(l_module_name, 'p_ship_to_location_id', p_ship_to_location_id);
126: WSH_DEBUG_SV.log(l_module_name, 'p_transaction_type_id', p_transaction_type_id);
127: WSH_DEBUG_SV.log(l_module_name, 'p_from_order_number', p_from_order_number);
128: WSH_DEBUG_SV.log(l_module_name, 'p_to_order_number', p_to_order_number);

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

121: WSH_DEBUG_SV.log(l_module_name, 'p_process_mode',p_process_mode);
122: WSH_DEBUG_SV.log(l_module_name, 'p_api_version_number', p_api_version_number);
123: WSH_DEBUG_SV.log(l_module_name, 'p_organization_id', p_organization_id);
124: WSH_DEBUG_SV.log(l_module_name, 'p_customer_id', p_customer_id);
125: WSH_DEBUG_SV.log(l_module_name, 'p_ship_to_location_id', p_ship_to_location_id);
126: WSH_DEBUG_SV.log(l_module_name, 'p_transaction_type_id', p_transaction_type_id);
127: WSH_DEBUG_SV.log(l_module_name, 'p_from_order_number', p_from_order_number);
128: WSH_DEBUG_SV.log(l_module_name, 'p_to_order_number', p_to_order_number);
129: WSH_DEBUG_SV.log(l_module_name, 'p_from_request_date', p_from_request_date);

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

122: WSH_DEBUG_SV.log(l_module_name, 'p_api_version_number', p_api_version_number);
123: WSH_DEBUG_SV.log(l_module_name, 'p_organization_id', p_organization_id);
124: WSH_DEBUG_SV.log(l_module_name, 'p_customer_id', p_customer_id);
125: WSH_DEBUG_SV.log(l_module_name, 'p_ship_to_location_id', p_ship_to_location_id);
126: WSH_DEBUG_SV.log(l_module_name, 'p_transaction_type_id', p_transaction_type_id);
127: WSH_DEBUG_SV.log(l_module_name, 'p_from_order_number', p_from_order_number);
128: WSH_DEBUG_SV.log(l_module_name, 'p_to_order_number', p_to_order_number);
129: WSH_DEBUG_SV.log(l_module_name, 'p_from_request_date', p_from_request_date);
130: WSH_DEBUG_SV.log(l_module_name, 'p_to_request_date', p_to_request_date);

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

123: WSH_DEBUG_SV.log(l_module_name, 'p_organization_id', p_organization_id);
124: WSH_DEBUG_SV.log(l_module_name, 'p_customer_id', p_customer_id);
125: WSH_DEBUG_SV.log(l_module_name, 'p_ship_to_location_id', p_ship_to_location_id);
126: WSH_DEBUG_SV.log(l_module_name, 'p_transaction_type_id', p_transaction_type_id);
127: WSH_DEBUG_SV.log(l_module_name, 'p_from_order_number', p_from_order_number);
128: WSH_DEBUG_SV.log(l_module_name, 'p_to_order_number', p_to_order_number);
129: WSH_DEBUG_SV.log(l_module_name, 'p_from_request_date', p_from_request_date);
130: WSH_DEBUG_SV.log(l_module_name, 'p_to_request_date', p_to_request_date);
131: WSH_DEBUG_SV.log(l_module_name, 'p_from_schedule_date', p_from_schedule_date);

Line 128: WSH_DEBUG_SV.log(l_module_name, 'p_to_order_number', p_to_order_number);

124: WSH_DEBUG_SV.log(l_module_name, 'p_customer_id', p_customer_id);
125: WSH_DEBUG_SV.log(l_module_name, 'p_ship_to_location_id', p_ship_to_location_id);
126: WSH_DEBUG_SV.log(l_module_name, 'p_transaction_type_id', p_transaction_type_id);
127: WSH_DEBUG_SV.log(l_module_name, 'p_from_order_number', p_from_order_number);
128: WSH_DEBUG_SV.log(l_module_name, 'p_to_order_number', p_to_order_number);
129: WSH_DEBUG_SV.log(l_module_name, 'p_from_request_date', p_from_request_date);
130: WSH_DEBUG_SV.log(l_module_name, 'p_to_request_date', p_to_request_date);
131: WSH_DEBUG_SV.log(l_module_name, 'p_from_schedule_date', p_from_schedule_date);
132: WSH_DEBUG_SV.log(l_module_name, 'p_to_schedule_date', p_to_schedule_date);

Line 129: WSH_DEBUG_SV.log(l_module_name, 'p_from_request_date', p_from_request_date);

125: WSH_DEBUG_SV.log(l_module_name, 'p_ship_to_location_id', p_ship_to_location_id);
126: WSH_DEBUG_SV.log(l_module_name, 'p_transaction_type_id', p_transaction_type_id);
127: WSH_DEBUG_SV.log(l_module_name, 'p_from_order_number', p_from_order_number);
128: WSH_DEBUG_SV.log(l_module_name, 'p_to_order_number', p_to_order_number);
129: WSH_DEBUG_SV.log(l_module_name, 'p_from_request_date', p_from_request_date);
130: WSH_DEBUG_SV.log(l_module_name, 'p_to_request_date', p_to_request_date);
131: WSH_DEBUG_SV.log(l_module_name, 'p_from_schedule_date', p_from_schedule_date);
132: WSH_DEBUG_SV.log(l_module_name, 'p_to_schedule_date', p_to_schedule_date);
133: WSH_DEBUG_SV.log(l_module_name, 'p_shipment_priority', p_shipment_priority);

Line 130: WSH_DEBUG_SV.log(l_module_name, 'p_to_request_date', p_to_request_date);

126: WSH_DEBUG_SV.log(l_module_name, 'p_transaction_type_id', p_transaction_type_id);
127: WSH_DEBUG_SV.log(l_module_name, 'p_from_order_number', p_from_order_number);
128: WSH_DEBUG_SV.log(l_module_name, 'p_to_order_number', p_to_order_number);
129: WSH_DEBUG_SV.log(l_module_name, 'p_from_request_date', p_from_request_date);
130: WSH_DEBUG_SV.log(l_module_name, 'p_to_request_date', p_to_request_date);
131: WSH_DEBUG_SV.log(l_module_name, 'p_from_schedule_date', p_from_schedule_date);
132: WSH_DEBUG_SV.log(l_module_name, 'p_to_schedule_date', p_to_schedule_date);
133: WSH_DEBUG_SV.log(l_module_name, 'p_shipment_priority', p_shipment_priority);
134: WSH_DEBUG_SV.log(l_module_name, 'p_include_internal_so', p_include_internal_so);

Line 131: WSH_DEBUG_SV.log(l_module_name, 'p_from_schedule_date', p_from_schedule_date);

127: WSH_DEBUG_SV.log(l_module_name, 'p_from_order_number', p_from_order_number);
128: WSH_DEBUG_SV.log(l_module_name, 'p_to_order_number', p_to_order_number);
129: WSH_DEBUG_SV.log(l_module_name, 'p_from_request_date', p_from_request_date);
130: WSH_DEBUG_SV.log(l_module_name, 'p_to_request_date', p_to_request_date);
131: WSH_DEBUG_SV.log(l_module_name, 'p_from_schedule_date', p_from_schedule_date);
132: WSH_DEBUG_SV.log(l_module_name, 'p_to_schedule_date', p_to_schedule_date);
133: WSH_DEBUG_SV.log(l_module_name, 'p_shipment_priority', p_shipment_priority);
134: WSH_DEBUG_SV.log(l_module_name, 'p_include_internal_so', p_include_internal_so);
135: WSH_DEBUG_SV.log(l_module_name, 'p_include_lines_with_hold', p_include_lines_with_hold);

Line 132: WSH_DEBUG_SV.log(l_module_name, 'p_to_schedule_date', p_to_schedule_date);

128: WSH_DEBUG_SV.log(l_module_name, 'p_to_order_number', p_to_order_number);
129: WSH_DEBUG_SV.log(l_module_name, 'p_from_request_date', p_from_request_date);
130: WSH_DEBUG_SV.log(l_module_name, 'p_to_request_date', p_to_request_date);
131: WSH_DEBUG_SV.log(l_module_name, 'p_from_schedule_date', p_from_schedule_date);
132: WSH_DEBUG_SV.log(l_module_name, 'p_to_schedule_date', p_to_schedule_date);
133: WSH_DEBUG_SV.log(l_module_name, 'p_shipment_priority', p_shipment_priority);
134: WSH_DEBUG_SV.log(l_module_name, 'p_include_internal_so', p_include_internal_so);
135: WSH_DEBUG_SV.log(l_module_name, 'p_include_lines_with_hold', p_include_lines_with_hold);
136: END IF;

Line 133: WSH_DEBUG_SV.log(l_module_name, 'p_shipment_priority', p_shipment_priority);

129: WSH_DEBUG_SV.log(l_module_name, 'p_from_request_date', p_from_request_date);
130: WSH_DEBUG_SV.log(l_module_name, 'p_to_request_date', p_to_request_date);
131: WSH_DEBUG_SV.log(l_module_name, 'p_from_schedule_date', p_from_schedule_date);
132: WSH_DEBUG_SV.log(l_module_name, 'p_to_schedule_date', p_to_schedule_date);
133: WSH_DEBUG_SV.log(l_module_name, 'p_shipment_priority', p_shipment_priority);
134: WSH_DEBUG_SV.log(l_module_name, 'p_include_internal_so', p_include_internal_so);
135: WSH_DEBUG_SV.log(l_module_name, 'p_include_lines_with_hold', p_include_lines_with_hold);
136: END IF;
137: --

Line 134: WSH_DEBUG_SV.log(l_module_name, 'p_include_internal_so', p_include_internal_so);

130: WSH_DEBUG_SV.log(l_module_name, 'p_to_request_date', p_to_request_date);
131: WSH_DEBUG_SV.log(l_module_name, 'p_from_schedule_date', p_from_schedule_date);
132: WSH_DEBUG_SV.log(l_module_name, 'p_to_schedule_date', p_to_schedule_date);
133: WSH_DEBUG_SV.log(l_module_name, 'p_shipment_priority', p_shipment_priority);
134: WSH_DEBUG_SV.log(l_module_name, 'p_include_internal_so', p_include_internal_so);
135: WSH_DEBUG_SV.log(l_module_name, 'p_include_lines_with_hold', p_include_lines_with_hold);
136: END IF;
137: --
138:

Line 135: WSH_DEBUG_SV.log(l_module_name, 'p_include_lines_with_hold', p_include_lines_with_hold);

131: WSH_DEBUG_SV.log(l_module_name, 'p_from_schedule_date', p_from_schedule_date);
132: WSH_DEBUG_SV.log(l_module_name, 'p_to_schedule_date', p_to_schedule_date);
133: WSH_DEBUG_SV.log(l_module_name, 'p_shipment_priority', p_shipment_priority);
134: WSH_DEBUG_SV.log(l_module_name, 'p_include_internal_so', p_include_internal_so);
135: WSH_DEBUG_SV.log(l_module_name, 'p_include_lines_with_hold', p_include_lines_with_hold);
136: END IF;
137: --
138:
139: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 170: WSH_DEBUG_SV.log(l_module_name, 'Error: Invalid date format', sqlerrm);

166: EXCEPTION
167: WHEN OTHERS THEN
168: --
169: IF l_debug_on THEN
170: WSH_DEBUG_SV.log(l_module_name, 'Error: Invalid date format', sqlerrm);
171: END IF;
172: --
173: RAISE FND_API.G_EXC_ERROR;
174: END;

Line 179: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_SHIPMENT_BATCH_PKG.Create_Shipment_Batch', WSH_DEBUG_SV.C_PROC_LEVEL);

175:
176: IF p_process_mode = 'ONLINE' THEN
177: --
178: IF l_debug_on THEN
179: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_SHIPMENT_BATCH_PKG.Create_Shipment_Batch', WSH_DEBUG_SV.C_PROC_LEVEL);
180: END IF;
181: --
182: WSH_SHIPMENT_BATCH_PKG.Create_Shipment_Batch (
183: p_organization_id => p_organization_id,

Line 200: WSH_DEBUG_SV.log(l_module_name, 'Return Status of WSH_SHIPMENT_BATCH_PKG.Create_Shipment_Batch', l_return_status);

196: x_return_status => l_return_status );
197:
198: --
199: IF l_debug_on THEN
200: WSH_DEBUG_SV.log(l_module_name, 'Return Status of WSH_SHIPMENT_BATCH_PKG.Create_Shipment_Batch', l_return_status);
201: END IF;
202: --
203: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
204: FND_MESSAGE.Set_Name('WSH', 'WSH_SUCCESS_PROCESS');

Line 215: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling FND_REQUEST.SUBMIT_REQUEST', WSH_DEBUG_SV.C_PROC_LEVEL);

211: END IF;
212: ELSIF p_process_mode = 'CONCURRENT' THEN
213: --
214: IF l_debug_on THEN
215: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling FND_REQUEST.SUBMIT_REQUEST', WSH_DEBUG_SV.C_PROC_LEVEL);
216: END IF;
217: --
218: x_request_id := FND_REQUEST.SUBMIT_REQUEST(
219: application => 'WSH',

Line 241: WSH_DEBUG_SV.log(l_module_name, 'Request Id returned from FND_REQUEST.SUBMIT_REQUEST', x_request_id);

237: argument14 => p_log_level );
238:
239: --
240: IF l_debug_on THEN
241: WSH_DEBUG_SV.log(l_module_name, 'Request Id returned from FND_REQUEST.SUBMIT_REQUEST', x_request_id);
242: END IF;
243: --
244: IF (nvl(x_request_id,0) <= 0) THEN
245: RAISE FND_API.G_EXC_ERROR;

Line 258: WSH_DEBUG_SV.logmsg(l_module_name, 'p_process_mode should be ONLINE/CONCURRENT');

254: FND_MESSAGE.Set_Token('ATTRIBUTE', 'PROCESS_MODE');
255: WSH_UTIL_CORE.Add_Message(x_return_status);
256: --
257: IF l_debug_on THEN
258: WSH_DEBUG_SV.logmsg(l_module_name, 'p_process_mode should be ONLINE/CONCURRENT');
259: END IF;
260: --
261: RAISE FND_API.G_EXC_ERROR;
262: END IF;

Line 276: WSH_DEBUG_SV.log(l_module_name, 'Return Status', x_return_status);

272: p_encoded => fnd_api.g_false);
273:
274: --
275: IF l_debug_on THEN
276: WSH_DEBUG_SV.log(l_module_name, 'Return Status', x_return_status);
277: WSH_DEBUG_SV.pop(l_module_name);
278: END IF;
279: --
280: EXCEPTION

Line 277: WSH_DEBUG_SV.pop(l_module_name);

273:
274: --
275: IF l_debug_on THEN
276: WSH_DEBUG_SV.log(l_module_name, 'Return Status', x_return_status);
277: WSH_DEBUG_SV.pop(l_module_name);
278: END IF;
279: --
280: EXCEPTION
281: WHEN FND_API.G_EXC_ERROR THEN

Line 285: WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');

281: WHEN FND_API.G_EXC_ERROR THEN
282: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
283: --
284: IF l_debug_on THEN
285: WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');
286: END IF;
287: --
288: ROLLBACK;
289: FND_MSG_PUB.Count_And_Get(

Line 294: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occured while creating Shipment Batch');

290: p_count => x_msg_count,
291: p_data => x_msg_data,
292: p_encoded => fnd_api.g_false);
293: IF l_debug_on THEN
294: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occured while creating Shipment Batch');
295: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
296: END IF;
297: WHEN others THEN
298: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

291: p_data => x_msg_data,
292: p_encoded => fnd_api.g_false);
293: IF l_debug_on THEN
294: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occured while creating Shipment Batch');
295: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
296: END IF;
297: WHEN others THEN
298: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
299: --

Line 301: WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');

297: WHEN others THEN
298: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
299: --
300: IF l_debug_on THEN
301: WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');
302: END IF;
303: --
304: ROLLBACK;
305: FND_MSG_PUB.Count_And_Get(

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

307: p_data => x_msg_data,
308: p_encoded => fnd_api.g_false);
309: --
310: IF l_debug_on THEN
311: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
312: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
313: END IF;
314: END Create_Shipment_Batch;
315: --

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

308: p_encoded => fnd_api.g_false);
309: --
310: IF l_debug_on THEN
311: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
312: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
313: END IF;
314: END Create_Shipment_Batch;
315: --
316: --========================================================================

Line 378: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

374: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
375: --
376: IF l_debug_on IS NULL
377: THEN
378: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
379: END IF;
380: --
381: IF l_debug_on THEN
382: WSH_DEBUG_SV.push(l_module_name);

Line 382: WSH_DEBUG_SV.push(l_module_name);

378: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
379: END IF;
380: --
381: IF l_debug_on THEN
382: WSH_DEBUG_SV.push(l_module_name);
383: --
384: WSH_DEBUG_SV.log(l_module_name, 'p_commit', p_commit);
385: WSH_DEBUG_SV.log(l_module_name, 'p_api_version_number', p_api_version_number);
386: WSH_DEBUG_SV.log(l_module_name, 'p_document_number', p_document_number);

Line 384: WSH_DEBUG_SV.log(l_module_name, 'p_commit', p_commit);

380: --
381: IF l_debug_on THEN
382: WSH_DEBUG_SV.push(l_module_name);
383: --
384: WSH_DEBUG_SV.log(l_module_name, 'p_commit', p_commit);
385: WSH_DEBUG_SV.log(l_module_name, 'p_api_version_number', p_api_version_number);
386: WSH_DEBUG_SV.log(l_module_name, 'p_document_number', p_document_number);
387: WSH_DEBUG_SV.log(l_module_name, 'p_line_number', p_line_number);
388: WSH_DEBUG_SV.log(l_module_name, 'p_cancel_quantity', p_cancel_quantity);

Line 385: WSH_DEBUG_SV.log(l_module_name, 'p_api_version_number', p_api_version_number);

381: IF l_debug_on THEN
382: WSH_DEBUG_SV.push(l_module_name);
383: --
384: WSH_DEBUG_SV.log(l_module_name, 'p_commit', p_commit);
385: WSH_DEBUG_SV.log(l_module_name, 'p_api_version_number', p_api_version_number);
386: WSH_DEBUG_SV.log(l_module_name, 'p_document_number', p_document_number);
387: WSH_DEBUG_SV.log(l_module_name, 'p_line_number', p_line_number);
388: WSH_DEBUG_SV.log(l_module_name, 'p_cancel_quantity', p_cancel_quantity);
389: END IF;

Line 386: WSH_DEBUG_SV.log(l_module_name, 'p_document_number', p_document_number);

382: WSH_DEBUG_SV.push(l_module_name);
383: --
384: WSH_DEBUG_SV.log(l_module_name, 'p_commit', p_commit);
385: WSH_DEBUG_SV.log(l_module_name, 'p_api_version_number', p_api_version_number);
386: WSH_DEBUG_SV.log(l_module_name, 'p_document_number', p_document_number);
387: WSH_DEBUG_SV.log(l_module_name, 'p_line_number', p_line_number);
388: WSH_DEBUG_SV.log(l_module_name, 'p_cancel_quantity', p_cancel_quantity);
389: END IF;
390: --

Line 387: WSH_DEBUG_SV.log(l_module_name, 'p_line_number', p_line_number);

383: --
384: WSH_DEBUG_SV.log(l_module_name, 'p_commit', p_commit);
385: WSH_DEBUG_SV.log(l_module_name, 'p_api_version_number', p_api_version_number);
386: WSH_DEBUG_SV.log(l_module_name, 'p_document_number', p_document_number);
387: WSH_DEBUG_SV.log(l_module_name, 'p_line_number', p_line_number);
388: WSH_DEBUG_SV.log(l_module_name, 'p_cancel_quantity', p_cancel_quantity);
389: END IF;
390: --
391: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 388: WSH_DEBUG_SV.log(l_module_name, 'p_cancel_quantity', p_cancel_quantity);

384: WSH_DEBUG_SV.log(l_module_name, 'p_commit', p_commit);
385: WSH_DEBUG_SV.log(l_module_name, 'p_api_version_number', p_api_version_number);
386: WSH_DEBUG_SV.log(l_module_name, 'p_document_number', p_document_number);
387: WSH_DEBUG_SV.log(l_module_name, 'p_line_number', p_line_number);
388: WSH_DEBUG_SV.log(l_module_name, 'p_cancel_quantity', p_cancel_quantity);
389: END IF;
390: --
391: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
392: -- Initialize Message List

Line 409: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_SHIPMENT_BATCH_PKG.Cancel_Line', WSH_DEBUG_SV.C_PROC_LEVEL);

405: RAISE FND_API.G_EXC_ERROR;
406: END IF;
407:
408: IF l_debug_on THEN
409: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_SHIPMENT_BATCH_PKG.Cancel_Line', WSH_DEBUG_SV.C_PROC_LEVEL);
410: END IF;
411: --
412: WSH_SHIPMENT_BATCH_PKG.Cancel_Line(
413: p_document_number => p_document_number ,

Line 420: WSH_DEBUG_SV.log(l_module_name, 'Return Status of WSH_SHIPMENT_BATCH_PKG.Cancel_Line', l_return_status);

416: x_return_status => l_return_status );
417:
418: --
419: IF l_debug_on THEN
420: WSH_DEBUG_SV.log(l_module_name, 'Return Status of WSH_SHIPMENT_BATCH_PKG.Cancel_Line', l_return_status);
421: END IF;
422: --
423:
424: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 434: WSH_DEBUG_SV.log(l_module_name, 'Return Status', x_return_status);

430: END IF;
431:
432: --
433: IF l_debug_on THEN
434: WSH_DEBUG_SV.log(l_module_name, 'Return Status', x_return_status);
435: WSH_DEBUG_SV.pop(l_module_name);
436: END IF;
437: --
438: EXCEPTION

Line 435: WSH_DEBUG_SV.pop(l_module_name);

431:
432: --
433: IF l_debug_on THEN
434: WSH_DEBUG_SV.log(l_module_name, 'Return Status', x_return_status);
435: WSH_DEBUG_SV.pop(l_module_name);
436: END IF;
437: --
438: EXCEPTION
439: WHEN FND_API.G_EXC_ERROR THEN

Line 443: WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');

439: WHEN FND_API.G_EXC_ERROR THEN
440: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
441: --
442: IF l_debug_on THEN
443: WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');
444: END IF;
445: --
446: ROLLBACK;
447: FND_MSG_PUB.Count_And_Get(

Line 452: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occured while cancelling delivery line');

448: p_count => x_msg_count,
449: p_data => x_msg_data,
450: p_encoded => fnd_api.g_false);
451: IF l_debug_on THEN
452: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occured while cancelling delivery line');
453: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
454: END IF;
455: WHEN others THEN
456: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

449: p_data => x_msg_data,
450: p_encoded => fnd_api.g_false);
451: IF l_debug_on THEN
452: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occured while cancelling delivery line');
453: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
454: END IF;
455: WHEN others THEN
456: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
457: --

Line 459: WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');

455: WHEN others THEN
456: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
457: --
458: IF l_debug_on THEN
459: WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');
460: END IF;
461: --
462: ROLLBACK;
463: FND_MSG_PUB.Count_And_Get(

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

465: p_data => x_msg_data,
466: p_encoded => fnd_api.g_false);
467: --
468: IF l_debug_on THEN
469: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
470: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
471: END IF;
472: END Cancel_Line;
473:

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

466: p_encoded => fnd_api.g_false);
467: --
468: IF l_debug_on THEN
469: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
470: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
471: END IF;
472: END Cancel_Line;
473:
474: END WSH_SHIPMENT_BATCH_PUB;