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.2 2012/01/05 16:58:43 brana ship $ */
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 340: from wsh_pr_pick_slip_number.g_pskey_table

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

Line 448: 'WSH_PR_PICK_SLIP_NUMBER.Print_Pick_Slip';

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

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

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

Line 1032: END WSH_PR_PICK_SLIP_NUMBER;

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