eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_REGIONS_PKG dependencies on WSH_REGIONS_PKG

Line 1: PACKAGE BODY WSH_REGIONS_PKG AS

1: PACKAGE BODY WSH_REGIONS_PKG AS
2: /* $Header: WSHRETHB.pls 120.5 2010/11/09 22:56:29 skanduku ship $ */
3:
4: --
5: -- Package

Line 6: -- WSH_REGIONS_PKG

2: /* $Header: WSHRETHB.pls 120.5 2010/11/09 22:56:29 skanduku ship $ */
3:
4: --
5: -- Package
6: -- WSH_REGIONS_PKG
7: --
8: -- Purpose
9: --
10:

Line 31: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_REGIONS_PKG';

27: -- region_id
28: --
29:
30: --
31: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_REGIONS_PKG';
32: --
33: PROCEDURE Add_Region (
34: p_country_code IN VARCHAR2,
35: p_country_region_code IN VARCHAR2,

Line 1033: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_PKG.INSERT_GLOBAL_TABLE', WSH_DEBUG_SV.C_PROC_LEVEL);

1029: --
1030: -- Debug Statements
1031: --
1032: IF l_debug_on THEN
1033: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_PKG.INSERT_GLOBAL_TABLE', WSH_DEBUG_SV.C_PROC_LEVEL);
1034: END IF;
1035: --
1036: Insert_Global_Table(
1037: p_country => p_country,

Line 1248: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_PKG.VALIDATE_REGION', WSH_DEBUG_SV.C_PROC_LEVEL);

1244: --
1245: -- Debug Statements
1246: --
1247: IF l_debug_on THEN
1248: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_PKG.VALIDATE_REGION', WSH_DEBUG_SV.C_PROC_LEVEL);
1249: END IF;
1250: --
1251: Validate_Region( p_country => p_country,
1252: p_state => p_state,

Line 1944: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_PKG.UPDATE_GLOBAL_TABLE', WSH_DEBUG_SV.C_PROC_LEVEL);

1940: --
1941: -- Debug Statements
1942: --
1943: IF l_debug_on THEN
1944: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_PKG.UPDATE_GLOBAL_TABLE', WSH_DEBUG_SV.C_PROC_LEVEL);
1945: END IF;
1946: --
1947: Update_Global_Table(
1948: p_country => p_country,

Line 3837: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_PKG.VALIDATE_REGION', WSH_DEBUG_SV.C_PROC_LEVEL);

3833: --
3834: -- Debug Statements
3835: --
3836: IF l_debug_on THEN
3837: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_PKG.VALIDATE_REGION', WSH_DEBUG_SV.C_PROC_LEVEL);
3838: END IF;
3839: --
3840: Validate_Region( p_country => l_country_rec(i),
3841: p_state => l_state_rec(i),

Line 3903: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_PKG.INIT_GLOBAL_TABLE', WSH_DEBUG_SV.C_PROC_LEVEL);

3899: --
3900: -- Debug Statements
3901: --
3902: IF l_debug_on THEN
3903: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_PKG.INIT_GLOBAL_TABLE', WSH_DEBUG_SV.C_PROC_LEVEL);
3904: END IF;
3905: --
3906: -- To popualte Global temp tables
3907: Init_Global_Table(

Line 3941: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_PKG.UPDATE_REGION', WSH_DEBUG_SV.C_PROC_LEVEL);

3937: --
3938: -- Debug Statements
3939: --
3940: IF l_debug_on THEN
3941: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_PKG.UPDATE_REGION', WSH_DEBUG_SV.C_PROC_LEVEL);
3942: END IF;
3943:
3944: Update_Region(
3945: p_insert_type => 'SYNC',

Line 5470: END WSH_REGIONS_PKG;

5466: fnd_message.set_token('MSG_TEXT', SQLERRM);
5467: fnd_file.put_line(fnd_file.log, 'UPDATE_GLOBAL_TABLE EXCEPTION : ' || sqlerrm);
5468: END Update_Global_Table;
5469:
5470: END WSH_REGIONS_PKG;
5471: