144: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
145: --
146: IF l_debug_on IS NULL
147: THEN
148: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
149: END IF;
150: --
151:
152: --
150: --
151:
152: --
153: IF l_debug_on THEN
154: WSH_DEBUG_SV.push(l_module_name);
155: WSH_DEBUG_SV.logmsg(l_module_name, 'Inside print_pvt ');
156: --
157: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_ID',P_REPORT_SET_ID);
158: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
151:
152: --
153: IF l_debug_on THEN
154: WSH_DEBUG_SV.push(l_module_name);
155: WSH_DEBUG_SV.logmsg(l_module_name, 'Inside print_pvt ');
156: --
157: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_ID',P_REPORT_SET_ID);
158: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
159: WSH_DEBUG_SV.log(l_module_name,'P_PICK_SLIP_NUMBER',P_PICK_SLIP_NUMBER);
153: IF l_debug_on THEN
154: WSH_DEBUG_SV.push(l_module_name);
155: WSH_DEBUG_SV.logmsg(l_module_name, 'Inside print_pvt ');
156: --
157: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_ID',P_REPORT_SET_ID);
158: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
159: WSH_DEBUG_SV.log(l_module_name,'P_PICK_SLIP_NUMBER',P_PICK_SLIP_NUMBER);
160: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_HEADER_ID',P_ORDER_HEADER_ID);
161: WSH_DEBUG_SV.log(l_module_name,'P_BATCH_ID',P_BATCH_ID);
154: WSH_DEBUG_SV.push(l_module_name);
155: WSH_DEBUG_SV.logmsg(l_module_name, 'Inside print_pvt ');
156: --
157: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_ID',P_REPORT_SET_ID);
158: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
159: WSH_DEBUG_SV.log(l_module_name,'P_PICK_SLIP_NUMBER',P_PICK_SLIP_NUMBER);
160: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_HEADER_ID',P_ORDER_HEADER_ID);
161: WSH_DEBUG_SV.log(l_module_name,'P_BATCH_ID',P_BATCH_ID);
162: WSH_DEBUG_SV.logmsg(l_module_name, 'REPORT SET ID ' || TO_CHAR ( P_REPORT_SET_ID ) );
155: WSH_DEBUG_SV.logmsg(l_module_name, 'Inside print_pvt ');
156: --
157: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_ID',P_REPORT_SET_ID);
158: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
159: WSH_DEBUG_SV.log(l_module_name,'P_PICK_SLIP_NUMBER',P_PICK_SLIP_NUMBER);
160: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_HEADER_ID',P_ORDER_HEADER_ID);
161: WSH_DEBUG_SV.log(l_module_name,'P_BATCH_ID',P_BATCH_ID);
162: WSH_DEBUG_SV.logmsg(l_module_name, 'REPORT SET ID ' || TO_CHAR ( P_REPORT_SET_ID ) );
163: WSH_DEBUG_SV.logmsg(l_module_name, 'p_ps_mode ' || p_ps_mode );
156: --
157: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_ID',P_REPORT_SET_ID);
158: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
159: WSH_DEBUG_SV.log(l_module_name,'P_PICK_SLIP_NUMBER',P_PICK_SLIP_NUMBER);
160: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_HEADER_ID',P_ORDER_HEADER_ID);
161: WSH_DEBUG_SV.log(l_module_name,'P_BATCH_ID',P_BATCH_ID);
162: WSH_DEBUG_SV.logmsg(l_module_name, 'REPORT SET ID ' || TO_CHAR ( P_REPORT_SET_ID ) );
163: WSH_DEBUG_SV.logmsg(l_module_name, 'p_ps_mode ' || p_ps_mode );
164: WSH_DEBUG_SV.logmsg(l_module_name, 'count of g_printertab ' || WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.count );
157: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_ID',P_REPORT_SET_ID);
158: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
159: WSH_DEBUG_SV.log(l_module_name,'P_PICK_SLIP_NUMBER',P_PICK_SLIP_NUMBER);
160: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_HEADER_ID',P_ORDER_HEADER_ID);
161: WSH_DEBUG_SV.log(l_module_name,'P_BATCH_ID',P_BATCH_ID);
162: WSH_DEBUG_SV.logmsg(l_module_name, 'REPORT SET ID ' || TO_CHAR ( P_REPORT_SET_ID ) );
163: WSH_DEBUG_SV.logmsg(l_module_name, 'p_ps_mode ' || p_ps_mode );
164: WSH_DEBUG_SV.logmsg(l_module_name, 'count of g_printertab ' || WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.count );
165: END IF;
158: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
159: WSH_DEBUG_SV.log(l_module_name,'P_PICK_SLIP_NUMBER',P_PICK_SLIP_NUMBER);
160: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_HEADER_ID',P_ORDER_HEADER_ID);
161: WSH_DEBUG_SV.log(l_module_name,'P_BATCH_ID',P_BATCH_ID);
162: WSH_DEBUG_SV.logmsg(l_module_name, 'REPORT SET ID ' || TO_CHAR ( P_REPORT_SET_ID ) );
163: WSH_DEBUG_SV.logmsg(l_module_name, 'p_ps_mode ' || p_ps_mode );
164: WSH_DEBUG_SV.logmsg(l_module_name, 'count of g_printertab ' || WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.count );
165: END IF;
166: --
159: WSH_DEBUG_SV.log(l_module_name,'P_PICK_SLIP_NUMBER',P_PICK_SLIP_NUMBER);
160: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_HEADER_ID',P_ORDER_HEADER_ID);
161: WSH_DEBUG_SV.log(l_module_name,'P_BATCH_ID',P_BATCH_ID);
162: WSH_DEBUG_SV.logmsg(l_module_name, 'REPORT SET ID ' || TO_CHAR ( P_REPORT_SET_ID ) );
163: WSH_DEBUG_SV.logmsg(l_module_name, 'p_ps_mode ' || p_ps_mode );
164: WSH_DEBUG_SV.logmsg(l_module_name, 'count of g_printertab ' || WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.count );
165: END IF;
166: --
167: l_order_number := null;
160: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_HEADER_ID',P_ORDER_HEADER_ID);
161: WSH_DEBUG_SV.log(l_module_name,'P_BATCH_ID',P_BATCH_ID);
162: WSH_DEBUG_SV.logmsg(l_module_name, 'REPORT SET ID ' || TO_CHAR ( P_REPORT_SET_ID ) );
163: WSH_DEBUG_SV.logmsg(l_module_name, 'p_ps_mode ' || p_ps_mode );
164: WSH_DEBUG_SV.logmsg(l_module_name, 'count of g_printertab ' || WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.count );
165: END IF;
166: --
167: l_order_number := null;
168: IF ( nvl(p_order_header_id,0) <> 0) THEN
174: null;
175: END IF;
176: --
177: IF l_debug_on THEN
178: WSH_DEBUG_SV.logmsg(l_module_name, 'ORDER HDR ID: ' || TO_CHAR ( P_ORDER_HEADER_ID ) );
179: WSH_DEBUG_SV.logmsg(l_module_name, 'ORDER NUMBER: ' || L_ORDER_NUMBER );
180: END IF;
181: --
182: CLOSE get_order_number;
175: END IF;
176: --
177: IF l_debug_on THEN
178: WSH_DEBUG_SV.logmsg(l_module_name, 'ORDER HDR ID: ' || TO_CHAR ( P_ORDER_HEADER_ID ) );
179: WSH_DEBUG_SV.logmsg(l_module_name, 'ORDER NUMBER: ' || L_ORDER_NUMBER );
180: END IF;
181: --
182: CLOSE get_order_number;
183: END IF;
192:
193: l_document_info(1).p_move_order_h := l_batch_name;
194: l_document_info(1).p_move_order_l := l_batch_name;
195: IF l_debug_on THEN
196: WSH_DEBUG_SV.log(l_module_name,'l_batch_name',l_batch_name);
197: END IF;
198:
199: ELSE
200: l_document_info(1).pick_slip_num_l := p_pick_slip_number;
214:
215: l_document_info(1).p_printer_name := WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i);
216: --
217: IF l_debug_on THEN
218: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling Print_Document_sets for printer ' || WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i) );
219: END IF ;
220: --
221: WSH_DOCUMENT_SETS.Print_Document_Sets(
222: p_report_set_id => l_report_set_id,
227: p_document_param_info => l_document_info,
228: x_return_status => x_api_status);
229: --
230: IF l_debug_on THEN
231: WSH_DEBUG_SV.log(l_module_name,'x_api_status',x_api_status);
232: WSH_DEBUG_SV.pop(l_module_name);
233: END IF;
234: --
235: End LOOP ;
228: x_return_status => x_api_status);
229: --
230: IF l_debug_on THEN
231: WSH_DEBUG_SV.log(l_module_name,'x_api_status',x_api_status);
232: WSH_DEBUG_SV.pop(l_module_name);
233: END IF;
234: --
235: End LOOP ;
236: else
234: --
235: End LOOP ;
236: else
237: IF l_debug_on THEN
238: WSH_DEBUG_SV.logmsg(l_module_name, 'ORDER NUMBER: ' || L_ORDER_NUMBER );
239: END IF;
240: WSH_DOCUMENT_SETS.Print_Document_Sets(
241: p_report_set_id => l_report_set_id,
242: p_organization_id => l_organization_id,
246: p_document_param_info => l_document_info,
247: x_return_status => x_api_status);
248: --
249: IF l_debug_on THEN
250: WSH_DEBUG_SV.log(l_module_name,'x_api_status',x_api_status);
251: WSH_DEBUG_SV.pop(l_module_name);
252: END IF;
253: --
254: end if ;
247: x_return_status => x_api_status);
248: --
249: IF l_debug_on THEN
250: WSH_DEBUG_SV.log(l_module_name,'x_api_status',x_api_status);
251: WSH_DEBUG_SV.pop(l_module_name);
252: END IF;
253: --
254: end if ;
255:
310: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
311: --
312: IF l_debug_on IS NULL
313: THEN
314: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
315: END IF;
316: --
317: --
318: IF l_debug_on THEN
315: END IF;
316: --
317: --
318: IF l_debug_on THEN
319: WSH_DEBUG_SV.push(l_module_name);
320: --
321: WSH_DEBUG_SV.log(l_module_name,'P_PICK_SLIP_NUMBER',P_PICK_SLIP_NUMBER);
322: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_ID',P_REPORT_SET_ID);
323: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
317: --
318: IF l_debug_on THEN
319: WSH_DEBUG_SV.push(l_module_name);
320: --
321: WSH_DEBUG_SV.log(l_module_name,'P_PICK_SLIP_NUMBER',P_PICK_SLIP_NUMBER);
322: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_ID',P_REPORT_SET_ID);
323: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
324: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_HEADER_ID',P_ORDER_HEADER_ID);
325: WSH_DEBUG_SV.log(l_module_name,'P_BATCH_ID',P_BATCH_ID);
318: IF l_debug_on THEN
319: WSH_DEBUG_SV.push(l_module_name);
320: --
321: WSH_DEBUG_SV.log(l_module_name,'P_PICK_SLIP_NUMBER',P_PICK_SLIP_NUMBER);
322: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_ID',P_REPORT_SET_ID);
323: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
324: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_HEADER_ID',P_ORDER_HEADER_ID);
325: WSH_DEBUG_SV.log(l_module_name,'P_BATCH_ID',P_BATCH_ID);
326: WSH_DEBUG_SV.log(l_module_name,'P_PS_MODE',P_PS_MODE);
319: WSH_DEBUG_SV.push(l_module_name);
320: --
321: WSH_DEBUG_SV.log(l_module_name,'P_PICK_SLIP_NUMBER',P_PICK_SLIP_NUMBER);
322: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_ID',P_REPORT_SET_ID);
323: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
324: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_HEADER_ID',P_ORDER_HEADER_ID);
325: WSH_DEBUG_SV.log(l_module_name,'P_BATCH_ID',P_BATCH_ID);
326: WSH_DEBUG_SV.log(l_module_name,'P_PS_MODE',P_PS_MODE);
327: END IF;
320: --
321: WSH_DEBUG_SV.log(l_module_name,'P_PICK_SLIP_NUMBER',P_PICK_SLIP_NUMBER);
322: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_ID',P_REPORT_SET_ID);
323: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
324: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_HEADER_ID',P_ORDER_HEADER_ID);
325: WSH_DEBUG_SV.log(l_module_name,'P_BATCH_ID',P_BATCH_ID);
326: WSH_DEBUG_SV.log(l_module_name,'P_PS_MODE',P_PS_MODE);
327: END IF;
328: --
321: WSH_DEBUG_SV.log(l_module_name,'P_PICK_SLIP_NUMBER',P_PICK_SLIP_NUMBER);
322: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_ID',P_REPORT_SET_ID);
323: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
324: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_HEADER_ID',P_ORDER_HEADER_ID);
325: WSH_DEBUG_SV.log(l_module_name,'P_BATCH_ID',P_BATCH_ID);
326: WSH_DEBUG_SV.log(l_module_name,'P_PS_MODE',P_PS_MODE);
327: END IF;
328: --
329: /*
322: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_ID',P_REPORT_SET_ID);
323: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
324: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_HEADER_ID',P_ORDER_HEADER_ID);
325: WSH_DEBUG_SV.log(l_module_name,'P_BATCH_ID',P_BATCH_ID);
326: WSH_DEBUG_SV.log(l_module_name,'P_PS_MODE',P_PS_MODE);
327: END IF;
328: --
329: /*
330: ############### PLEASE READ ####################################
349: END IF;
350: --
351: x_api_status := FND_API.G_RET_STS_SUCCESS;
352: IF l_debug_on THEN
353: WSH_DEBUG_SV.log(l_module_name,'l_index',l_index);
354: END IF;
355:
356: -- If report set id is NULL, there is no report to print
357: IF (WSH_PICK_LIST.G_SEED_DOC_SET IS NULL) THEN
357: IF (WSH_PICK_LIST.G_SEED_DOC_SET IS NULL) THEN
358: x_api_status := FND_API.G_RET_STS_SUCCESS;
359: --
360: IF l_debug_on THEN
361: WSH_DEBUG_SV.log(l_module_name,'there is no report to print');
362: WSH_DEBUG_SV.pop(l_module_name);
363: END IF;
364: --
365: RETURN;
358: x_api_status := FND_API.G_RET_STS_SUCCESS;
359: --
360: IF l_debug_on THEN
361: WSH_DEBUG_SV.log(l_module_name,'there is no report to print');
362: WSH_DEBUG_SV.pop(l_module_name);
363: END IF;
364: --
365: RETURN;
366: END IF;
426: p_ps_mode => p_ps_mode ,
427: x_api_status => x_api_status);
428: --
429: IF l_debug_on THEN
430: WSH_DEBUG_SV.logmsg(l_module_name, 'X_API_STATUS PRINT_PVT:'|| X_API_STATUS );
431: END IF;
432: --
433: END IF;
434: ELSE
445: x_error_message := 'Error occurred in call to ' ||
446: 'Print_Pvt in ' ||
447: 'WSH_PR_PICK_SLIP_NUMBER.Print_Pick_Slip';
448: IF l_debug_on THEN
449: WSH_DEBUG_SV.log(l_module_name,'Error:',x_error_message);
450:
451: END IF;
452: END IF;
453: --
451: END IF;
452: END IF;
453: --
454: IF l_debug_on THEN
455: WSH_DEBUG_SV.log(l_module_name,'x_api_status',x_api_status);
456: WSH_DEBUG_SV.pop(l_module_name);
457: END IF;
458: --
459: EXCEPTION
452: END IF;
453: --
454: IF l_debug_on THEN
455: WSH_DEBUG_SV.log(l_module_name,'x_api_status',x_api_status);
456: WSH_DEBUG_SV.pop(l_module_name);
457: END IF;
458: --
459: EXCEPTION
460: WHEN OTHERS THEN
461: x_error_message := 'Exception occurred in WSH_PR_PICK_SLIP_NUMBER.Print_Pick_Slip';
462: x_api_status := FND_API.G_RET_STS_UNEXP_ERROR;
463: --
464: IF l_debug_on THEN
465: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
466: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
467: END IF;
468: --
469: END Print_Pick_Slip;
462: x_api_status := FND_API.G_RET_STS_UNEXP_ERROR;
463: --
464: IF l_debug_on THEN
465: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
466: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
467: END IF;
468: --
469: END Print_Pick_Slip;
470: