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;
215:
216: -- l_document_info(1).p_printer_name := WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i);
217: --
218: -- IF l_debug_on THEN
219: -- WSH_DEBUG_SV.logmsg(l_module_name, 'Calling Print_Document_sets for printer ' || WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i) );
220: -- END IF ;
221: --
222: WSH_DOCUMENT_SETS.Print_Document_Sets(
223: p_report_set_id => l_report_set_id,
228: p_document_param_info => l_document_info,
229: x_return_status => x_api_status);
230: --
231: IF l_debug_on THEN
232: WSH_DEBUG_SV.log(l_module_name,'x_api_status',x_api_status);
233: WSH_DEBUG_SV.pop(l_module_name);
234: END IF;
235: --
236: --- End LOOP ;
229: x_return_status => x_api_status);
230: --
231: IF l_debug_on THEN
232: WSH_DEBUG_SV.log(l_module_name,'x_api_status',x_api_status);
233: WSH_DEBUG_SV.pop(l_module_name);
234: END IF;
235: --
236: --- End LOOP ;
237: else
235: --
236: --- End LOOP ;
237: else
238: IF l_debug_on THEN
239: WSH_DEBUG_SV.logmsg(l_module_name, 'ORDER NUMBER: ' || L_ORDER_NUMBER );
240: END IF;
241: WSH_DOCUMENT_SETS.Print_Document_Sets(
242: p_report_set_id => l_report_set_id,
243: p_organization_id => l_organization_id,
247: p_document_param_info => l_document_info,
248: x_return_status => x_api_status);
249: --
250: IF l_debug_on THEN
251: WSH_DEBUG_SV.log(l_module_name,'x_api_status',x_api_status);
252: WSH_DEBUG_SV.pop(l_module_name);
253: END IF;
254: --
255: end if ;
248: x_return_status => x_api_status);
249: --
250: IF l_debug_on THEN
251: WSH_DEBUG_SV.log(l_module_name,'x_api_status',x_api_status);
252: WSH_DEBUG_SV.pop(l_module_name);
253: END IF;
254: --
255: end if ;
256:
311: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
312: --
313: IF l_debug_on IS NULL
314: THEN
315: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
316: END IF;
317: --
318: --
319: IF l_debug_on THEN
316: END IF;
317: --
318: --
319: IF l_debug_on THEN
320: WSH_DEBUG_SV.push(l_module_name);
321: --
322: WSH_DEBUG_SV.log(l_module_name,'P_PICK_SLIP_NUMBER',P_PICK_SLIP_NUMBER);
323: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_ID',P_REPORT_SET_ID);
324: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
318: --
319: IF l_debug_on THEN
320: WSH_DEBUG_SV.push(l_module_name);
321: --
322: WSH_DEBUG_SV.log(l_module_name,'P_PICK_SLIP_NUMBER',P_PICK_SLIP_NUMBER);
323: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_ID',P_REPORT_SET_ID);
324: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
325: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_HEADER_ID',P_ORDER_HEADER_ID);
326: WSH_DEBUG_SV.log(l_module_name,'P_BATCH_ID',P_BATCH_ID);
319: IF l_debug_on THEN
320: WSH_DEBUG_SV.push(l_module_name);
321: --
322: WSH_DEBUG_SV.log(l_module_name,'P_PICK_SLIP_NUMBER',P_PICK_SLIP_NUMBER);
323: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_ID',P_REPORT_SET_ID);
324: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
325: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_HEADER_ID',P_ORDER_HEADER_ID);
326: WSH_DEBUG_SV.log(l_module_name,'P_BATCH_ID',P_BATCH_ID);
327: WSH_DEBUG_SV.log(l_module_name,'P_PS_MODE',P_PS_MODE);
320: WSH_DEBUG_SV.push(l_module_name);
321: --
322: WSH_DEBUG_SV.log(l_module_name,'P_PICK_SLIP_NUMBER',P_PICK_SLIP_NUMBER);
323: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_ID',P_REPORT_SET_ID);
324: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
325: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_HEADER_ID',P_ORDER_HEADER_ID);
326: WSH_DEBUG_SV.log(l_module_name,'P_BATCH_ID',P_BATCH_ID);
327: WSH_DEBUG_SV.log(l_module_name,'P_PS_MODE',P_PS_MODE);
328: END IF;
321: --
322: WSH_DEBUG_SV.log(l_module_name,'P_PICK_SLIP_NUMBER',P_PICK_SLIP_NUMBER);
323: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_ID',P_REPORT_SET_ID);
324: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
325: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_HEADER_ID',P_ORDER_HEADER_ID);
326: WSH_DEBUG_SV.log(l_module_name,'P_BATCH_ID',P_BATCH_ID);
327: WSH_DEBUG_SV.log(l_module_name,'P_PS_MODE',P_PS_MODE);
328: END IF;
329: --
322: WSH_DEBUG_SV.log(l_module_name,'P_PICK_SLIP_NUMBER',P_PICK_SLIP_NUMBER);
323: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_ID',P_REPORT_SET_ID);
324: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
325: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_HEADER_ID',P_ORDER_HEADER_ID);
326: WSH_DEBUG_SV.log(l_module_name,'P_BATCH_ID',P_BATCH_ID);
327: WSH_DEBUG_SV.log(l_module_name,'P_PS_MODE',P_PS_MODE);
328: END IF;
329: --
330: /*
323: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_ID',P_REPORT_SET_ID);
324: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
325: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_HEADER_ID',P_ORDER_HEADER_ID);
326: WSH_DEBUG_SV.log(l_module_name,'P_BATCH_ID',P_BATCH_ID);
327: WSH_DEBUG_SV.log(l_module_name,'P_PS_MODE',P_PS_MODE);
328: END IF;
329: --
330: /*
331: ############### PLEASE READ ####################################
350: END IF;
351: --
352: x_api_status := FND_API.G_RET_STS_SUCCESS;
353: IF l_debug_on THEN
354: WSH_DEBUG_SV.log(l_module_name,'l_index',l_index);
355: END IF;
356:
357: -- If report set id is NULL, there is no report to print
358: IF (WSH_PICK_LIST.G_SEED_DOC_SET IS NULL) THEN
358: IF (WSH_PICK_LIST.G_SEED_DOC_SET IS NULL) THEN
359: x_api_status := FND_API.G_RET_STS_SUCCESS;
360: --
361: IF l_debug_on THEN
362: WSH_DEBUG_SV.log(l_module_name,'there is no report to print');
363: WSH_DEBUG_SV.pop(l_module_name);
364: END IF;
365: --
366: RETURN;
359: x_api_status := FND_API.G_RET_STS_SUCCESS;
360: --
361: IF l_debug_on THEN
362: WSH_DEBUG_SV.log(l_module_name,'there is no report to print');
363: WSH_DEBUG_SV.pop(l_module_name);
364: END IF;
365: --
366: RETURN;
367: END IF;
427: p_ps_mode => p_ps_mode ,
428: x_api_status => x_api_status);
429: --
430: IF l_debug_on THEN
431: WSH_DEBUG_SV.logmsg(l_module_name, 'X_API_STATUS PRINT_PVT:'|| X_API_STATUS );
432: END IF;
433: --
434: END IF;
435: ELSE
446: x_error_message := 'Error occurred in call to ' ||
447: 'Print_Pvt in ' ||
448: 'WSH_PR_PICK_SLIP_NUMBER.Print_Pick_Slip';
449: IF l_debug_on THEN
450: WSH_DEBUG_SV.log(l_module_name,'Error:',x_error_message);
451:
452: END IF;
453: END IF;
454: --
452: END IF;
453: END IF;
454: --
455: IF l_debug_on THEN
456: WSH_DEBUG_SV.log(l_module_name,'x_api_status',x_api_status);
457: WSH_DEBUG_SV.pop(l_module_name);
458: END IF;
459: --
460: EXCEPTION
453: END IF;
454: --
455: IF l_debug_on THEN
456: WSH_DEBUG_SV.log(l_module_name,'x_api_status',x_api_status);
457: WSH_DEBUG_SV.pop(l_module_name);
458: END IF;
459: --
460: EXCEPTION
461: WHEN OTHERS THEN
462: x_error_message := 'Exception occurred in WSH_PR_PICK_SLIP_NUMBER.Print_Pick_Slip';
463: x_api_status := FND_API.G_RET_STS_UNEXP_ERROR;
464: --
465: IF l_debug_on THEN
466: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
467: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
468: END IF;
469: --
470: END Print_Pick_Slip;
463: x_api_status := FND_API.G_RET_STS_UNEXP_ERROR;
464: --
465: IF l_debug_on THEN
466: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
467: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
468: END IF;
469: --
470: END Print_Pick_Slip;
471: