DBA Data[Home] [Help]

APPS.WSH_PICK_LIST dependencies on WSH_PR_PICK_SLIP_NUMBER

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

665: --{
666: IF l_debug_on THEN
667: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
668: WSH_DEBUG_SV.logmsg(l_module_name, 'PRINT PICK SLIP REPORT' );
669: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PR_PICK_SLIP_NUMBER.PRINT_PICK_SLIP'
670: ,WSH_DEBUG_SV.C_PROC_LEVEL);
671: END IF;
672: WSH_PR_PICK_SLIP_NUMBER.Print_Pick_Slip (
673: p_report_set_id => WSH_PICK_LIST.G_SEED_DOC_SET,

Line 672: WSH_PR_PICK_SLIP_NUMBER.Print_Pick_Slip (

668: WSH_DEBUG_SV.logmsg(l_module_name, 'PRINT PICK SLIP REPORT' );
669: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PR_PICK_SLIP_NUMBER.PRINT_PICK_SLIP'
670: ,WSH_DEBUG_SV.C_PROC_LEVEL);
671: END IF;
672: WSH_PR_PICK_SLIP_NUMBER.Print_Pick_Slip (
673: p_report_set_id => WSH_PICK_LIST.G_SEED_DOC_SET,
674: p_organization_id => p_organization_id,
675: p_order_header_id => WSH_PR_CRITERIA.g_order_header_id,
676: p_ps_mode => p_ps_mode,

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

3090: -- OR Pick Slip Print Mode is Immediate and Cartonization is done before Allocation for WMS Orgs
3091: IF (l_org_info.print_pick_slip_mode = 'I') AND (l_org_info.wms_org = 'N' OR
3092: (l_org_info.wms_org = 'Y' AND p_worker_id IS NULL AND WSH_PICK_LIST.G_NUM_WORKERS = 1)) THEN
3093: --{
3094: IF (WSH_PR_PICK_SLIP_NUMBER.g_print_ps_table.COUNT > 0) THEN
3095: --{
3096: IF l_debug_on THEN
3097: WSH_DEBUG_SV.logmsg(l_module_name, 'PRINTING PICK SLIPS IN IMMEDIATE MODE...' );
3098: END IF;

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

3095: --{
3096: IF l_debug_on THEN
3097: WSH_DEBUG_SV.logmsg(l_module_name, 'PRINTING PICK SLIPS IN IMMEDIATE MODE...' );
3098: END IF;
3099: FOR i in WSH_PR_PICK_SLIP_NUMBER.g_print_ps_table.FIRST ..
3100: WSH_PR_PICK_SLIP_NUMBER.g_print_ps_table.LAST
3101: LOOP
3102: IF l_debug_on THEN
3103: WSH_DEBUG_SV.logmsg(l_module_name, ' === PRINTING PICK SLIP '

Line 3100: WSH_PR_PICK_SLIP_NUMBER.g_print_ps_table.LAST

3096: IF l_debug_on THEN
3097: WSH_DEBUG_SV.logmsg(l_module_name, 'PRINTING PICK SLIPS IN IMMEDIATE MODE...' );
3098: END IF;
3099: FOR i in WSH_PR_PICK_SLIP_NUMBER.g_print_ps_table.FIRST ..
3100: WSH_PR_PICK_SLIP_NUMBER.g_print_ps_table.LAST
3101: LOOP
3102: IF l_debug_on THEN
3103: WSH_DEBUG_SV.logmsg(l_module_name, ' === PRINTING PICK SLIP '
3104: ||WSH_PR_PICK_SLIP_NUMBER.G_PRINT_PS_TABLE ( I ) ||' ===' );

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

3100: WSH_PR_PICK_SLIP_NUMBER.g_print_ps_table.LAST
3101: LOOP
3102: IF l_debug_on THEN
3103: WSH_DEBUG_SV.logmsg(l_module_name, ' === PRINTING PICK SLIP '
3104: ||WSH_PR_PICK_SLIP_NUMBER.G_PRINT_PS_TABLE ( I ) ||' ===' );
3105: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PR_PICK_SLIP_NUMBER.PRINT_PICK_SLIP',WSH_DEBUG_SV.C_PROC_LEVEL);
3106: END IF;
3107: WSH_PR_PICK_SLIP_NUMBER.Print_Pick_Slip(
3108: p_pick_slip_number => WSH_PR_PICK_SLIP_NUMBER.g_print_ps_table(i),

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

3101: LOOP
3102: IF l_debug_on THEN
3103: WSH_DEBUG_SV.logmsg(l_module_name, ' === PRINTING PICK SLIP '
3104: ||WSH_PR_PICK_SLIP_NUMBER.G_PRINT_PS_TABLE ( I ) ||' ===' );
3105: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PR_PICK_SLIP_NUMBER.PRINT_PICK_SLIP',WSH_DEBUG_SV.C_PROC_LEVEL);
3106: END IF;
3107: WSH_PR_PICK_SLIP_NUMBER.Print_Pick_Slip(
3108: p_pick_slip_number => WSH_PR_PICK_SLIP_NUMBER.g_print_ps_table(i),
3109: p_report_set_id => WSH_PICK_LIST.G_SEED_DOC_SET,

Line 3107: WSH_PR_PICK_SLIP_NUMBER.Print_Pick_Slip(

3103: WSH_DEBUG_SV.logmsg(l_module_name, ' === PRINTING PICK SLIP '
3104: ||WSH_PR_PICK_SLIP_NUMBER.G_PRINT_PS_TABLE ( I ) ||' ===' );
3105: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PR_PICK_SLIP_NUMBER.PRINT_PICK_SLIP',WSH_DEBUG_SV.C_PROC_LEVEL);
3106: END IF;
3107: WSH_PR_PICK_SLIP_NUMBER.Print_Pick_Slip(
3108: p_pick_slip_number => WSH_PR_PICK_SLIP_NUMBER.g_print_ps_table(i),
3109: p_report_set_id => WSH_PICK_LIST.G_SEED_DOC_SET,
3110: p_organization_id => batch_rec.organization_id,
3111: p_ps_mode => 'I',

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

3104: ||WSH_PR_PICK_SLIP_NUMBER.G_PRINT_PS_TABLE ( I ) ||' ===' );
3105: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PR_PICK_SLIP_NUMBER.PRINT_PICK_SLIP',WSH_DEBUG_SV.C_PROC_LEVEL);
3106: END IF;
3107: WSH_PR_PICK_SLIP_NUMBER.Print_Pick_Slip(
3108: p_pick_slip_number => WSH_PR_PICK_SLIP_NUMBER.g_print_ps_table(i),
3109: p_report_set_id => WSH_PICK_LIST.G_SEED_DOC_SET,
3110: p_organization_id => batch_rec.organization_id,
3111: p_ps_mode => 'I',
3112: x_api_status => l_return_status,

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

3111: p_ps_mode => 'I',
3112: x_api_status => l_return_status,
3113: x_error_message => l_message );
3114: IF l_debug_on THEN
3115: WSH_DEBUG_SV.log(l_module_name,'WSH_PR_PICK_SLIP_NUMBER.Print_Pick_Slip l_return_status'
3116: ,l_return_status);
3117: WSH_DEBUG_SV.log(l_module_name,'WSH_PR_PICK_SLIP_NUMBER.Print_Pick_Slip l_message'
3118: ,l_message);
3119: END IF;

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

3113: x_error_message => l_message );
3114: IF l_debug_on THEN
3115: WSH_DEBUG_SV.log(l_module_name,'WSH_PR_PICK_SLIP_NUMBER.Print_Pick_Slip l_return_status'
3116: ,l_return_status);
3117: WSH_DEBUG_SV.log(l_module_name,'WSH_PR_PICK_SLIP_NUMBER.Print_Pick_Slip l_message'
3118: ,l_message);
3119: END IF;
3120: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
3121: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN

Line 3133: WSH_PR_PICK_SLIP_NUMBER.g_print_ps_table.DELETE;

3129: IF l_debug_on THEN
3130: WSH_DEBUG_SV.logmsg(l_module_name, 'NO PICK SLIPS TO PRINT' );
3131: END IF;
3132: END IF;
3133: WSH_PR_PICK_SLIP_NUMBER.g_print_ps_table.DELETE;
3134: --}
3135: END IF;
3136:
3137: l_total_detailed_count := l_total_detailed_count + l_pick_release_stat.count ;

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

4211: -- Bug 5222079
4212: -- Clear the pick slip number table
4213: --
4214: IF l_debug_on THEN
4215: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PR_PICK_SLIP_NUMBER.DELETE_PS_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);
4216: END IF;
4217: --
4218: WSH_PR_PICK_SLIP_NUMBER.Delete_ps_tbl (x_api_status => l_return_status,
4219: x_error_message => l_message);

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

4214: IF l_debug_on THEN
4215: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PR_PICK_SLIP_NUMBER.DELETE_PS_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);
4216: END IF;
4217: --
4218: WSH_PR_PICK_SLIP_NUMBER.Delete_ps_tbl (x_api_status => l_return_status,
4219: x_error_message => l_message);
4220: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
4221: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
4222: --{

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

4219: x_error_message => l_message);
4220: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
4221: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
4222: --{
4223: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_PR_PICK_SLIP_NUMBER.Delete_ps_tbl');
4224: RAISE e_return;
4225: END IF; --}
4226: -- end bug 5222079
4227:

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

6316: -- Call Inventory API to delete pick slip numbers from table as Inventory stores the numbers
6317: -- in physical table in case of Parallel Pick Release mode
6318: IF l_debug_on THEN
6319: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
6320: 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);
6321: END IF;
6322: WSH_PR_PICK_SLIP_NUMBER.Delete_Pick_Slip_Numbers ( p_batch_id => p_batch_id );
6323: IF l_debug_on THEN
6324: WSH_DEBUG_SV.logmsg(l_module_name,'Return from WSH_PR_PICK_SLIP_NUMBER.delete_pick_slip_numbers');

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

6318: IF l_debug_on THEN
6319: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
6320: 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);
6321: END IF;
6322: WSH_PR_PICK_SLIP_NUMBER.Delete_Pick_Slip_Numbers ( p_batch_id => p_batch_id );
6323: IF l_debug_on THEN
6324: WSH_DEBUG_SV.logmsg(l_module_name,'Return from WSH_PR_PICK_SLIP_NUMBER.delete_pick_slip_numbers');
6325: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
6326: END IF;

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

6320: 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);
6321: END IF;
6322: WSH_PR_PICK_SLIP_NUMBER.Delete_Pick_Slip_Numbers ( p_batch_id => p_batch_id );
6323: IF l_debug_on THEN
6324: WSH_DEBUG_SV.logmsg(l_module_name,'Return from WSH_PR_PICK_SLIP_NUMBER.delete_pick_slip_numbers');
6325: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
6326: END IF;
6327: --}
6328: