APPS.ECE_TIMEZONE_API dependencies on ECE_TIMEZONE_API

Line 1: PACKAGE BODY ece_timezone_api AS

1: PACKAGE BODY ece_timezone_api AS
2: -- $Header: ECETZAPB.pls 120.3.12000000.2 2007/10/03 15:00:55 cpeixoto ship $
3:
4: PROCEDURE get_server_timezone_details(
5: p_date IN DATE,

Line 19: ec_debug.push('ECE_TIMEZONE_API.GET_SERVER_TIMEZONE_DETAILS');

15: xProgress VARCHAR2(80);
16:
17: BEGIN
18: if ec_debug.G_debug_level >= 2 then
19: ec_debug.push('ECE_TIMEZONE_API.GET_SERVER_TIMEZONE_DETAILS');
20: end if;
21: xProgress := 'TZAPI-10-1000';
22: fnd_profile.get('SERVER_TIMEZONE_ID',st_tz_id);
23: xProgress := 'TZAPI-10-1010';

Line 41: ec_debug.pop('ECE_TIMEZONE_API.GET_SERVER_TIMEZONE_DETAILS');

37: end if;
38: if ec_debug.G_debug_level >= 2 then
39: ec_debug.pl(3,'gmt deviation: ',x_gmt_deviation);
40: ec_debug.pl(3,'Timezone Code: ',x_global_timezone_name);
41: ec_debug.pop('ECE_TIMEZONE_API.GET_SERVER_TIMEZONE_DETAILS');
42: end if;
43: EXCEPTION
44: WHEN OTHERS THEN
45: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);

Line 48: ec_debug.pop('ECE_TIMEZONE_API.GET_SERVER_TIMEZONE_DETAILS');

44: WHEN OTHERS THEN
45: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);
46: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
47: if ec_debug.G_debug_level >= 2 then
48: ec_debug.pop('ECE_TIMEZONE_API.GET_SERVER_TIMEZONE_DETAILS');
49: end if;
50: app_exception.raise_exception;
51:
52:

Line 83: ec_debug.push('ECE_TIMEZONE_API.GET_DATE');

79: where upper(timezone_code) = p_timezone_name;
80:
81: BEGIN
82: if ec_debug.G_debug_level >= 2 then
83: ec_debug.push('ECE_TIMEZONE_API.GET_DATE');
84: end if;
85: xProgress := 'TZAPI-20-1000';
86: if (p_timezone_name is not null) then
87: FOR i_timezone in c_timezone(upper(p_timezone_name))

Line 110: ec_debug.pop('ECE_TIMEZONE_API.GET_DATE');

106: x_dest_date := p_src_date;
107: end if;
108: if ec_debug.G_debug_level >= 2 then
109: ec_debug.pl(3,'x_dest_date: ',x_dest_date);
110: ec_debug.pop('ECE_TIMEZONE_API.GET_DATE');
111: end if;
112: EXCEPTION
113: WHEN OTHERS THEN
114: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);

Line 117: ec_debug.pop('ECE_TIMEZONE_API.GET_DATE');

113: WHEN OTHERS THEN
114: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);
115: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
116: if ec_debug.G_debug_level >= 2 then
117: ec_debug.pop('ECE_TIMEZONE_API.GET_DATE');
118: end if;
119: app_exception.raise_exception;
120:
121: END get_date;