DBA Data[Home] [Help]

APPS.WSH_PICK_LIST dependencies on WSH_PR_PICK_SLIP_NUMBER

Line 655: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PR_PICK_SLIP_NUMBER.PRINT_PICK_SLIP'

651: --{
652: IF l_debug_on THEN
653: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
654: WSH_DEBUG_SV.logmsg(l_module_name, 'PRINT PICK SLIP REPORT' );
655: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PR_PICK_SLIP_NUMBER.PRINT_PICK_SLIP'
656: ,WSH_DEBUG_SV.C_PROC_LEVEL);
657: END IF;
658: WSH_PR_PICK_SLIP_NUMBER.Print_Pick_Slip (
659: p_report_set_id => WSH_PICK_LIST.G_SEED_DOC_SET,

Line 658: WSH_PR_PICK_SLIP_NUMBER.Print_Pick_Slip (

654: WSH_DEBUG_SV.logmsg(l_module_name, 'PRINT PICK SLIP REPORT' );
655: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PR_PICK_SLIP_NUMBER.PRINT_PICK_SLIP'
656: ,WSH_DEBUG_SV.C_PROC_LEVEL);
657: END IF;
658: WSH_PR_PICK_SLIP_NUMBER.Print_Pick_Slip (
659: p_report_set_id => WSH_PICK_LIST.G_SEED_DOC_SET,
660: p_organization_id => p_organization_id,
661: p_order_header_id => WSH_PR_CRITERIA.g_order_header_id,
662: p_ps_mode => p_ps_mode,

Line 3020: IF (WSH_PR_PICK_SLIP_NUMBER.g_print_ps_table.COUNT > 0) THEN

3016: -- OR Pick Slip Print Mode is Immediate and Cartonization is done before Allocation for WMS Orgs
3017: IF (l_org_info.print_pick_slip_mode = 'I') AND (l_org_info.wms_org = 'N' OR
3018: (l_org_info.wms_org = 'Y' AND p_worker_id IS NULL AND WSH_PICK_LIST.G_NUM_WORKERS = 1)) THEN
3019: --{
3020: IF (WSH_PR_PICK_SLIP_NUMBER.g_print_ps_table.COUNT > 0) THEN
3021: --{
3022: IF l_debug_on THEN
3023: WSH_DEBUG_SV.logmsg(l_module_name, 'PRINTING PICK SLIPS IN IMMEDIATE MODE...' );
3024: END IF;

Line 3025: FOR i in WSH_PR_PICK_SLIP_NUMBER.g_print_ps_table.FIRST ..

3021: --{
3022: IF l_debug_on THEN
3023: WSH_DEBUG_SV.logmsg(l_module_name, 'PRINTING PICK SLIPS IN IMMEDIATE MODE...' );
3024: END IF;
3025: FOR i in WSH_PR_PICK_SLIP_NUMBER.g_print_ps_table.FIRST ..
3026: WSH_PR_PICK_SLIP_NUMBER.g_print_ps_table.LAST
3027: LOOP
3028: IF l_debug_on THEN
3029: WSH_DEBUG_SV.logmsg(l_module_name, ' === PRINTING PICK SLIP '

Line 3026: WSH_PR_PICK_SLIP_NUMBER.g_print_ps_table.LAST

3022: IF l_debug_on THEN
3023: WSH_DEBUG_SV.logmsg(l_module_name, 'PRINTING PICK SLIPS IN IMMEDIATE MODE...' );
3024: END IF;
3025: FOR i in WSH_PR_PICK_SLIP_NUMBER.g_print_ps_table.FIRST ..
3026: WSH_PR_PICK_SLIP_NUMBER.g_print_ps_table.LAST
3027: LOOP
3028: IF l_debug_on THEN
3029: WSH_DEBUG_SV.logmsg(l_module_name, ' === PRINTING PICK SLIP '
3030: ||WSH_PR_PICK_SLIP_NUMBER.G_PRINT_PS_TABLE ( I ) ||' ===' );

Line 3030: ||WSH_PR_PICK_SLIP_NUMBER.G_PRINT_PS_TABLE ( I ) ||' ===' );

3026: WSH_PR_PICK_SLIP_NUMBER.g_print_ps_table.LAST
3027: LOOP
3028: IF l_debug_on THEN
3029: WSH_DEBUG_SV.logmsg(l_module_name, ' === PRINTING PICK SLIP '
3030: ||WSH_PR_PICK_SLIP_NUMBER.G_PRINT_PS_TABLE ( I ) ||' ===' );
3031: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PR_PICK_SLIP_NUMBER.PRINT_PICK_SLIP',WSH_DEBUG_SV.C_PROC_LEVEL);
3032: END IF;
3033: WSH_PR_PICK_SLIP_NUMBER.Print_Pick_Slip(
3034: p_pick_slip_number => WSH_PR_PICK_SLIP_NUMBER.g_print_ps_table(i),

Line 3031: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PR_PICK_SLIP_NUMBER.PRINT_PICK_SLIP',WSH_DEBUG_SV.C_PROC_LEVEL);

3027: LOOP
3028: IF l_debug_on THEN
3029: WSH_DEBUG_SV.logmsg(l_module_name, ' === PRINTING PICK SLIP '
3030: ||WSH_PR_PICK_SLIP_NUMBER.G_PRINT_PS_TABLE ( I ) ||' ===' );
3031: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PR_PICK_SLIP_NUMBER.PRINT_PICK_SLIP',WSH_DEBUG_SV.C_PROC_LEVEL);
3032: END IF;
3033: WSH_PR_PICK_SLIP_NUMBER.Print_Pick_Slip(
3034: p_pick_slip_number => WSH_PR_PICK_SLIP_NUMBER.g_print_ps_table(i),
3035: p_report_set_id => WSH_PICK_LIST.G_SEED_DOC_SET,

Line 3033: WSH_PR_PICK_SLIP_NUMBER.Print_Pick_Slip(

3029: WSH_DEBUG_SV.logmsg(l_module_name, ' === PRINTING PICK SLIP '
3030: ||WSH_PR_PICK_SLIP_NUMBER.G_PRINT_PS_TABLE ( I ) ||' ===' );
3031: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PR_PICK_SLIP_NUMBER.PRINT_PICK_SLIP',WSH_DEBUG_SV.C_PROC_LEVEL);
3032: END IF;
3033: WSH_PR_PICK_SLIP_NUMBER.Print_Pick_Slip(
3034: p_pick_slip_number => WSH_PR_PICK_SLIP_NUMBER.g_print_ps_table(i),
3035: p_report_set_id => WSH_PICK_LIST.G_SEED_DOC_SET,
3036: p_organization_id => batch_rec.organization_id,
3037: p_ps_mode => 'I',

Line 3034: p_pick_slip_number => WSH_PR_PICK_SLIP_NUMBER.g_print_ps_table(i),

3030: ||WSH_PR_PICK_SLIP_NUMBER.G_PRINT_PS_TABLE ( I ) ||' ===' );
3031: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PR_PICK_SLIP_NUMBER.PRINT_PICK_SLIP',WSH_DEBUG_SV.C_PROC_LEVEL);
3032: END IF;
3033: WSH_PR_PICK_SLIP_NUMBER.Print_Pick_Slip(
3034: p_pick_slip_number => WSH_PR_PICK_SLIP_NUMBER.g_print_ps_table(i),
3035: p_report_set_id => WSH_PICK_LIST.G_SEED_DOC_SET,
3036: p_organization_id => batch_rec.organization_id,
3037: p_ps_mode => 'I',
3038: x_api_status => l_return_status,

Line 3041: WSH_DEBUG_SV.log(l_module_name,'WSH_PR_PICK_SLIP_NUMBER.Print_Pick_Slip l_return_status'

3037: p_ps_mode => 'I',
3038: x_api_status => l_return_status,
3039: x_error_message => l_message );
3040: IF l_debug_on THEN
3041: WSH_DEBUG_SV.log(l_module_name,'WSH_PR_PICK_SLIP_NUMBER.Print_Pick_Slip l_return_status'
3042: ,l_return_status);
3043: WSH_DEBUG_SV.log(l_module_name,'WSH_PR_PICK_SLIP_NUMBER.Print_Pick_Slip l_message'
3044: ,l_message);
3045: END IF;

Line 3043: WSH_DEBUG_SV.log(l_module_name,'WSH_PR_PICK_SLIP_NUMBER.Print_Pick_Slip l_message'

3039: x_error_message => l_message );
3040: IF l_debug_on THEN
3041: WSH_DEBUG_SV.log(l_module_name,'WSH_PR_PICK_SLIP_NUMBER.Print_Pick_Slip l_return_status'
3042: ,l_return_status);
3043: WSH_DEBUG_SV.log(l_module_name,'WSH_PR_PICK_SLIP_NUMBER.Print_Pick_Slip l_message'
3044: ,l_message);
3045: END IF;
3046: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
3047: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN

Line 3059: WSH_PR_PICK_SLIP_NUMBER.g_print_ps_table.DELETE;

3055: IF l_debug_on THEN
3056: WSH_DEBUG_SV.logmsg(l_module_name, 'NO PICK SLIPS TO PRINT' );
3057: END IF;
3058: END IF;
3059: WSH_PR_PICK_SLIP_NUMBER.g_print_ps_table.DELETE;
3060: --}
3061: END IF;
3062:
3063: l_total_detailed_count := l_total_detailed_count + l_pick_release_stat.count ;

Line 4123: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PR_PICK_SLIP_NUMBER.DELETE_PS_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);

4119: -- Bug 5222079
4120: -- Clear the pick slip number table
4121: --
4122: IF l_debug_on THEN
4123: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PR_PICK_SLIP_NUMBER.DELETE_PS_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);
4124: END IF;
4125: --
4126: WSH_PR_PICK_SLIP_NUMBER.Delete_ps_tbl (x_api_status => l_return_status,
4127: x_error_message => l_message);

Line 4126: WSH_PR_PICK_SLIP_NUMBER.Delete_ps_tbl (x_api_status => l_return_status,

4122: IF l_debug_on THEN
4123: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PR_PICK_SLIP_NUMBER.DELETE_PS_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);
4124: END IF;
4125: --
4126: WSH_PR_PICK_SLIP_NUMBER.Delete_ps_tbl (x_api_status => l_return_status,
4127: x_error_message => l_message);
4128: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
4129: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
4130: --{

Line 4131: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_PR_PICK_SLIP_NUMBER.Delete_ps_tbl');

4127: x_error_message => l_message);
4128: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
4129: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
4130: --{
4131: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_PR_PICK_SLIP_NUMBER.Delete_ps_tbl');
4132: RAISE e_return;
4133: END IF; --}
4134: -- end bug 5222079
4135:

Line 6185: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PR_PICK_SLIP_NUMBER.delete_pick_slip_numbers' ,WSH_DEBUG_SV.C_PROC_LEVEL);

6181: -- Call Inventory API to delete pick slip numbers from table as Inventory stores the numbers
6182: -- in physical table in case of Parallel Pick Release mode
6183: IF l_debug_on THEN
6184: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
6185: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PR_PICK_SLIP_NUMBER.delete_pick_slip_numbers' ,WSH_DEBUG_SV.C_PROC_LEVEL);
6186: END IF;
6187: WSH_PR_PICK_SLIP_NUMBER.Delete_Pick_Slip_Numbers ( p_batch_id => p_batch_id );
6188: IF l_debug_on THEN
6189: WSH_DEBUG_SV.logmsg(l_module_name,'Return from WSH_PR_PICK_SLIP_NUMBER.delete_pick_slip_numbers');

Line 6187: WSH_PR_PICK_SLIP_NUMBER.Delete_Pick_Slip_Numbers ( p_batch_id => p_batch_id );

6183: IF l_debug_on THEN
6184: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
6185: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PR_PICK_SLIP_NUMBER.delete_pick_slip_numbers' ,WSH_DEBUG_SV.C_PROC_LEVEL);
6186: END IF;
6187: WSH_PR_PICK_SLIP_NUMBER.Delete_Pick_Slip_Numbers ( p_batch_id => p_batch_id );
6188: IF l_debug_on THEN
6189: WSH_DEBUG_SV.logmsg(l_module_name,'Return from WSH_PR_PICK_SLIP_NUMBER.delete_pick_slip_numbers');
6190: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
6191: END IF;

Line 6189: WSH_DEBUG_SV.logmsg(l_module_name,'Return from WSH_PR_PICK_SLIP_NUMBER.delete_pick_slip_numbers');

6185: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PR_PICK_SLIP_NUMBER.delete_pick_slip_numbers' ,WSH_DEBUG_SV.C_PROC_LEVEL);
6186: END IF;
6187: WSH_PR_PICK_SLIP_NUMBER.Delete_Pick_Slip_Numbers ( p_batch_id => p_batch_id );
6188: IF l_debug_on THEN
6189: WSH_DEBUG_SV.logmsg(l_module_name,'Return from WSH_PR_PICK_SLIP_NUMBER.delete_pick_slip_numbers');
6190: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
6191: END IF;
6192: --}
6193: