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.
PACKAGE: APPS.OKE_API

Source


1 PACKAGE OKE_API AUTHID CURRENT_USER AS
2 /* $Header: OKEPAPIS.pls 115.9 2003/03/25 22:43:30 who ship $ */
3 
4 -- GLOBAL STRUCTURES
5 
6  TYPE msg_rec_type IS RECORD (
7   	error_status		NUMBER,
8 	data			VARCHAR2(2000));
9  TYPE msg_tbl_type IS TABLE OF msg_rec_type
10   	INDEX BY BINARY_INTEGER;
11 
12 -- GLOBAL CONSTANTS
13 
14 G_FALSE		CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
15 G_TRUE		CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
16 G_MISS_NUM	CONSTANT NUMBER := FND_API.G_MISS_NUM;
17 G_MISS_CHAR	CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
18 G_MISS_DATE	CONSTANT DATE := FND_API.G_MISS_DATE;
19 
20 -- GLOBAL MESSAGE CONSTANTS
21 
22 G_FND_APP			CONSTANT VARCHAR2(200) := 'FND';
23 G_APP_NAME			CONSTANT VARCHAR2(200) := 'OKE';
24 -- remove line due to bug 2865218 G_FORM_UNABLE_TO_RESERVE_REC	CONSTANT VARCHAR2(200) := 'FORM_UNABLE_TO_RESERVE_RECORD';
25 G_FORM_UNABLE_TO_RESERVE_REC    CONSTANT VARCHAR2(200) := 'FORM_COULD_NOT_RESERVE_RECORD';
26 
27 
28 G_FORM_RECORD_DELETED		CONSTANT VARCHAR2(200) := 'FORM_RECORD_DELETED';
29 G_FORM_RECORD_CHANGED		CONSTANT VARCHAR2(200) := 'FORM_RECORD_CHANGED';
30 G_RECORD_LOGICALLY_DELETED	CONSTANT VARCHAR2(200) := 'OKE_CONTRACTS_RECORD_LDELETED';
31 G_REQUIRED_VALUE		CONSTANT VARCHAR2(200) := 'OKE_CONTRACTS_REQUIRED_VALUE';
32 G_INVALID_VALUE			CONSTANT VARCHAR2(200) := 'OKE_CONTRACTS_INVALID_VALUE';
33 G_CHILD_RECORD_FOUND		CONSTANT VARCHAR2(200) := 'OKE_CONTRACTS_CHILD_RECORD';
34 G_NO_PARENT_RECORD		CONSTANT VARCHAR2(200) := 'OKE_CONTRACTS_NO_PARENT_RECORD';
35 G_UNEXPECTED_ERROR 		CONSTANT VARCHAR2(200) := 'OKE_CONTRACTS_UNEXPECTED_ERROR';
36 
37 G_COL_NAME_TOKEN		CONSTANT VARCHAR2(200) := 'COL_NAME';
38 G_PARENT_TABLE_TOKEN		CONSTANT VARCHAR2(200) := 'PARENT_TABLE';
39 G_CHILD_TABLE_TOKEN		CONSTANT VARCHAR2(200) := 'CHILD_TABLE';
40 G_SQLERRM_TOKEN 		CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
41 G_SQLCODE_TOKEN 		CONSTANT VARCHAR2(200) := 'ERROR_CODE';
42 
43 
44 
45 
46 -- ERRORS AND EXCEPTIONS
47 
48 G_RET_STS_SUCCESS		CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
49 G_RET_STS_WARNING		CONSTANT VARCHAR2(1) := 'W';
50 G_RET_STS_ERROR			CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
51 G_RET_STS_UNEXP_ERROR		CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
52 G_EXCEPTION_ERROR		EXCEPTION;
53 G_EXCEPTION_UNEXPECTED_ERROR	EXCEPTION;
54 G_EXC_WARNING			EXCEPTION;
55 
56 -- GLOBAL VARIABLES
57 
58 -- Functions and Procedures
59 
60 PROCEDURE init_msg_list(
61 	p_init_msg_list			IN VARCHAR2);
62 
63 FUNCTION start_activity(
64 	p_api_name			IN VARCHAR2,
65 	p_pkg_name			IN VARCHAR2,
66 	p_init_msg_list			IN VARCHAR2,
67 	l_api_version			IN NUMBER,
68 	p_api_version			IN NUMBER,
69 	p_api_type			IN VARCHAR2,
70 	x_return_status			OUT NOCOPY VARCHAR2
71 ) RETURN VARCHAR2;
72 
73 FUNCTION start_activity(
74 	p_api_name			IN VARCHAR2,
75 	p_init_msg_list			IN VARCHAR2,
76 	p_api_type			IN VARCHAR2,
77 	x_return_status			OUT NOCOPY VARCHAR2
78 ) RETURN VARCHAR2;
79 
80 FUNCTION handle_exceptions (
81 	p_api_name		IN VARCHAR2,
82 	p_pkg_name		IN VARCHAR2,
83 	p_exc_name		IN VARCHAR2,
84 	x_msg_count		OUT NOCOPY NUMBER,
85 	x_msg_data		OUT NOCOPY VARCHAR2,
86 	p_api_type		IN VARCHAR2
87 ) RETURN VARCHAR2;
88 
89 PROCEDURE end_activity
90 (
91 	x_msg_count		OUT NOCOPY NUMBER,
92 	x_msg_data		OUT NOCOPY VARCHAR2
93 );
94 
95 -- Added translation flag by syho on 11-may-01
96 PROCEDURE set_message (
97 	p_app_name		IN VARCHAR2 DEFAULT OKE_API.G_APP_NAME,
98 	p_msg_name		IN VARCHAR2,
99 	p_token1		IN VARCHAR2 DEFAULT NULL,
100 	p_token1_value		IN VARCHAR2 DEFAULT NULL,
101 	p_token1_translate	IN VARCHAR2 DEFAULT OKE_API.G_FALSE ,
102 	p_token2		IN VARCHAR2 DEFAULT NULL,
103 	p_token2_value		IN VARCHAR2 DEFAULT NULL,
104 	p_token2_translate	IN VARCHAR2 DEFAULT OKE_API.G_FALSE ,
105 	p_token3		IN VARCHAR2 DEFAULT NULL,
106 	p_token3_value		IN VARCHAR2 DEFAULT NULL,
107 	p_token3_translate	IN VARCHAR2 DEFAULT OKE_API.G_FALSE ,
108 	p_token4		IN VARCHAR2 DEFAULT NULL,
109 	p_token4_value		IN VARCHAR2 DEFAULT NULL,
110 	p_token4_translate	IN VARCHAR2 DEFAULT OKE_API.G_FALSE ,
111 	p_token5		IN VARCHAR2 DEFAULT NULL,
112 	p_token5_value		IN VARCHAR2 DEFAULT NULL,
113 	p_token5_translate	IN VARCHAR2 DEFAULT OKE_API.G_FALSE ,
114 	p_token6		IN VARCHAR2 DEFAULT NULL,
115 	p_token6_value		IN VARCHAR2 DEFAULT NULL,
116 	p_token6_translate	IN VARCHAR2 DEFAULT OKE_API.G_FALSE ,
117 	p_token7		IN VARCHAR2 DEFAULT NULL,
118 	p_token7_value		IN VARCHAR2 DEFAULT NULL,
119 	p_token7_translate	IN VARCHAR2 DEFAULT OKE_API.G_FALSE ,
120 	p_token8		IN VARCHAR2 DEFAULT NULL,
121 	p_token8_value		IN VARCHAR2 DEFAULT NULL,
122 	p_token8_translate	IN VARCHAR2 DEFAULT OKE_API.G_FALSE ,
123 	p_token9		IN VARCHAR2 DEFAULT NULL,
124 	p_token9_value		IN VARCHAR2 DEFAULT NULL,
125 	p_token9_translate	IN VARCHAR2 DEFAULT OKE_API.G_FALSE ,
126 	p_token10		IN VARCHAR2 DEFAULT NULL,
127 	p_token10_value		IN VARCHAR2 DEFAULT NULL,
128 	p_token10_translate	IN VARCHAR2 DEFAULT OKE_API.G_FALSE
129 );
130 END OKE_API;
131