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.CSC_RESPONSE_CENTER_PKG dependencies on FND_API

Line 7: -- Local Function. Returns the Value of the Constant FND_API.G_MISS_NUM

3:
4: -- Constants used as tokens for unexpected error messages.
5: G_PKG_NAME CONSTANT VARCHAR2(25):= 'CSC_RESPONSE_CENTER_PKG';
6:
7: -- Local Function. Returns the Value of the Constant FND_API.G_MISS_NUM
8: FUNCTION G_MISS_NUM RETURN NUMBER IS
9: BEGIN
10: RETURN FND_API.G_MISS_NUM ;
11: END G_MISS_NUM ;

Line 10: RETURN FND_API.G_MISS_NUM ;

6:
7: -- Local Function. Returns the Value of the Constant FND_API.G_MISS_NUM
8: FUNCTION G_MISS_NUM RETURN NUMBER IS
9: BEGIN
10: RETURN FND_API.G_MISS_NUM ;
11: END G_MISS_NUM ;
12:
13: -- Local Function. Returns the Value of the Constant FND_API.G_MISS_CHAR to the caller
14: FUNCTION G_MISS_CHAR RETURN VARCHAR2 IS

Line 13: -- Local Function. Returns the Value of the Constant FND_API.G_MISS_CHAR to the caller

9: BEGIN
10: RETURN FND_API.G_MISS_NUM ;
11: END G_MISS_NUM ;
12:
13: -- Local Function. Returns the Value of the Constant FND_API.G_MISS_CHAR to the caller
14: FUNCTION G_MISS_CHAR RETURN VARCHAR2 IS
15: BEGIN
16: RETURN FND_API.G_MISS_CHAR ;
17: END G_MISS_CHAR ;

Line 16: RETURN FND_API.G_MISS_CHAR ;

12:
13: -- Local Function. Returns the Value of the Constant FND_API.G_MISS_CHAR to the caller
14: FUNCTION G_MISS_CHAR RETURN VARCHAR2 IS
15: BEGIN
16: RETURN FND_API.G_MISS_CHAR ;
17: END G_MISS_CHAR ;
18:
19: -- Local Function. REturns the Value of the Constant FND_API.G_MISS_DATE to the caller
20: FUNCTION G_MISS_DATE RETURN DATE IS

Line 19: -- Local Function. REturns the Value of the Constant FND_API.G_MISS_DATE to the caller

15: BEGIN
16: RETURN FND_API.G_MISS_CHAR ;
17: END G_MISS_CHAR ;
18:
19: -- Local Function. REturns the Value of the Constant FND_API.G_MISS_DATE to the caller
20: FUNCTION G_MISS_DATE RETURN DATE IS
21: BEGIN
22: RETURN FND_API.G_MISS_DATE ;
23: END G_MISS_DATE ;

Line 22: RETURN FND_API.G_MISS_DATE ;

18:
19: -- Local Function. REturns the Value of the Constant FND_API.G_MISS_DATE to the caller
20: FUNCTION G_MISS_DATE RETURN DATE IS
21: BEGIN
22: RETURN FND_API.G_MISS_DATE ;
23: END G_MISS_DATE ;
24:
25: -- Local Function. REturns the Value of the Constants
26: -- FND_API.G_VALID_LEVEL_NONE , FND_API.G_VALID_LEVEL_FULL to the caller

Line 26: -- FND_API.G_VALID_LEVEL_NONE , FND_API.G_VALID_LEVEL_FULL to the caller

22: RETURN FND_API.G_MISS_DATE ;
23: END G_MISS_DATE ;
24:
25: -- Local Function. REturns the Value of the Constants
26: -- FND_API.G_VALID_LEVEL_NONE , FND_API.G_VALID_LEVEL_FULL to the caller
27: FUNCTION G_VALID_LEVEL(p_level varchar2) RETURN NUMBER IS
28: BEGIN
29: IF p_level = ('NONE') then
30: RETURN FND_API.G_VALID_LEVEL_NONE ;

Line 30: RETURN FND_API.G_VALID_LEVEL_NONE ;

26: -- FND_API.G_VALID_LEVEL_NONE , FND_API.G_VALID_LEVEL_FULL to the caller
27: FUNCTION G_VALID_LEVEL(p_level varchar2) RETURN NUMBER IS
28: BEGIN
29: IF p_level = ('NONE') then
30: RETURN FND_API.G_VALID_LEVEL_NONE ;
31: ELSIF p_level = ('FULL') then
32: RETURN FND_API.G_VALID_LEVEL_FULL ;
33: ELSE
34: -- Unrecognized parameter.

Line 32: RETURN FND_API.G_VALID_LEVEL_FULL ;

28: BEGIN
29: IF p_level = ('NONE') then
30: RETURN FND_API.G_VALID_LEVEL_NONE ;
31: ELSIF p_level = ('FULL') then
32: RETURN FND_API.G_VALID_LEVEL_FULL ;
33: ELSE
34: -- Unrecognized parameter.
35: FND_MSG_PUB.Add_Exc_Msg
36: ( p_pkg_name => G_PKG_NAME ,

Line 40: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

36: ( p_pkg_name => G_PKG_NAME ,
37: p_procedure_name => 'G_VALID_LEVEL' ,
38: p_error_text => 'Unrecognized Value : '||p_level
39: );
40: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
41: END IF;
42: END G_VALID_LEVEL ;
43:
44: -- Local Function. REturns the Value of the Constants

Line 45: -- FND_API.G_TRUE , FND_API.G_FALSE To the caller

41: END IF;
42: END G_VALID_LEVEL ;
43:
44: -- Local Function. REturns the Value of the Constants
45: -- FND_API.G_TRUE , FND_API.G_FALSE To the caller
46: FUNCTION G_BOOLEAN(p_FLAG varchar2) RETURN VARCHAR2 IS
47: BEGIN
48: if p_flag = 'TRUE' then
49: return FND_API.G_TRUE ;

Line 49: return FND_API.G_TRUE ;

45: -- FND_API.G_TRUE , FND_API.G_FALSE To the caller
46: FUNCTION G_BOOLEAN(p_FLAG varchar2) RETURN VARCHAR2 IS
47: BEGIN
48: if p_flag = 'TRUE' then
49: return FND_API.G_TRUE ;
50: elsif p_flag = 'FALSE' then
51: return FND_API.G_FALSE ;
52: ELSE
53: -- Unrecognized parameter.

Line 51: return FND_API.G_FALSE ;

47: BEGIN
48: if p_flag = 'TRUE' then
49: return FND_API.G_TRUE ;
50: elsif p_flag = 'FALSE' then
51: return FND_API.G_FALSE ;
52: ELSE
53: -- Unrecognized parameter.
54: FND_MSG_PUB.Add_Exc_Msg
55: ( p_pkg_name => G_PKG_NAME ,

Line 59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

55: ( p_pkg_name => G_PKG_NAME ,
56: p_procedure_name => 'G_BOOLEAN' ,
57: p_error_text => 'Unrecognized Value : '||p_flag
58: );
59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
60: END if;
61: END G_BOOLEAN;
62:
63: FUNCTION GET_ERROR_CONSTANT(err_msg VARCHAR2) RETURN VARCHAR2 IS

Line 67: RETURN FND_API.G_RET_STS_ERROR;

63: FUNCTION GET_ERROR_CONSTANT(err_msg VARCHAR2) RETURN VARCHAR2 IS
64:
65: BEGIN
66: IF err_msg = 'G_RET_STS_ERROR' THEN
67: RETURN FND_API.G_RET_STS_ERROR;
68: ELSIF err_msg = 'G_RET_STS_UNEXP_ERROR' THEN
69: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
70: ELSIF err_msg = 'G_RET_STS_SUCCESS' THEN
71: RETURN FND_API.G_RET_STS_SUCCESS;

Line 69: RETURN FND_API.G_RET_STS_UNEXP_ERROR;

65: BEGIN
66: IF err_msg = 'G_RET_STS_ERROR' THEN
67: RETURN FND_API.G_RET_STS_ERROR;
68: ELSIF err_msg = 'G_RET_STS_UNEXP_ERROR' THEN
69: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
70: ELSIF err_msg = 'G_RET_STS_SUCCESS' THEN
71: RETURN FND_API.G_RET_STS_SUCCESS;
72: END IF;
73:

Line 71: RETURN FND_API.G_RET_STS_SUCCESS;

67: RETURN FND_API.G_RET_STS_ERROR;
68: ELSIF err_msg = 'G_RET_STS_UNEXP_ERROR' THEN
69: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
70: ELSIF err_msg = 'G_RET_STS_SUCCESS' THEN
71: RETURN FND_API.G_RET_STS_SUCCESS;
72: END IF;
73:
74: END GET_ERROR_CONSTANT;
75:

Line 139: p_init_msg_list => FND_API.G_FALSE,

135: l_phone_number := p_phone_number;
136:
137: /* HZ_CONTACT_POINT_PUB.phone_format (
138: p_api_version => 1.0,
139: p_init_msg_list => FND_API.G_FALSE,
140: p_territory_code => l_territory_code,
141: x_formatted_phone_number => l_formatted_phone_number,
142: x_phone_country_code => l_phone_country_code,
143: x_phone_area_code => l_phone_area_code,

Line 150: p_init_msg_list => FND_API.G_FALSE,

146: x_msg_count => l_msg_count,
147: x_msg_data => l_msg_data);
148: */
149: HZ_CONTACT_POINT_V2PUB.phone_format (
150: p_init_msg_list => FND_API.G_FALSE,
151: p_raw_phone_number => l_raw_phone_number,
152: x_formatted_phone_number => l_formatted_phone_number,
153: p_territory_code => l_territory_code,
154: x_phone_country_code => l_phone_country_code,

Line 162: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

158: x_msg_count => l_msg_count,
159: x_msg_data => l_msg_data);
160:
161: -- If procedure does not return success then pass back null (since will be used in view definition)
162: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
163: -- return FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' );
164: return null;
165: else
166: return l_formatted_phone_number;

Line 386: --references FND_API package (G_MISS_NUM) which cannot be accessed directly from libraries

382: END get_sitephone_details;
383:
384: --This procedure calls the Open_MediaItem API to log a media item.
385: --This procedure has been moved to the server side because JTF_IH_PUB.media_rec_type
386: --references FND_API package (G_MISS_NUM) which cannot be accessed directly from libraries
387: PROCEDURE start_media_item( p_resp_appl_id in number,
388: p_resp_id in number,
389: p_user_id in number,
390: p_login_id in number,