APPS.WSH_PR_PICK_SLIP_NUMBER dependencies on WSH_PR_PICK_SLIP_NUMBER

Line 1: PACKAGE BODY WSH_PR_PICK_SLIP_NUMBER AS

1: PACKAGE BODY WSH_PR_PICK_SLIP_NUMBER AS
2: /* $Header: WSHPRPNB.pls 120.1 2006/06/20 09:06:52 aymohant noship $ */
3:
4: /*
5: ############### PLEASE READ ####################################

Line 82: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_PR_PICK_SLIP_NUMBER';

78: g_prev_org_id NUMBER;
79: g_pickslip_limit NUMBER;
80: --
81: --
82: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_PR_PICK_SLIP_NUMBER';
83: --
84: --
85: -- Name
86: -- PROCEDURE Print_Pvt

Line 339: from wsh_pr_pick_slip_number.g_pskey_table

335:
336: Hence, we have the following in-line branch in the code.
337:
338: IF WSH is at level before I, we continue to read
339: from wsh_pr_pick_slip_number.g_pskey_table
340: Otherwise,
341: we read from inv_pr_pick_slip_number.g_pskey_table
342: */
343:

Line 447: 'WSH_PR_PICK_SLIP_NUMBER.Print_Pick_Slip';

443:
444: IF x_api_status <> FND_API.G_RET_STS_SUCCESS THEN
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;

Line 461: x_error_message := 'Exception occurred in WSH_PR_PICK_SLIP_NUMBER.Print_Pick_Slip';

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);

Line 1031: END WSH_PR_PICK_SLIP_NUMBER;

1027: x_error_message := 'Error occurred in WSH_PR_PICK_NUMBER.DELETE_PS_TBL: ' || SQLERRM;
1028: x_api_status := FND_API.G_RET_STS_UNEXP_ERROR;
1029: END DELETE_PS_TBL ;
1030:
1031: END WSH_PR_PICK_SLIP_NUMBER;