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.OKL_SETUPCONTEXTGROUPS_PVT dependencies on OKC_API

Line 80: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

76: x_cgrv_rec OUT NOCOPY cgrv_rec_type
77: ) IS
78: l_api_version CONSTANT NUMBER := 1;
79: l_api_name CONSTANT VARCHAR2(30) := 'insert_contextgroups';
80: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
81: l_valid BOOLEAN;
82: l_cgrv_rec cgrv_rec_type;
83: BEGIN
84: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 84: x_return_status := OKC_API.G_RET_STS_SUCCESS;

80: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
81: l_valid BOOLEAN;
82: l_cgrv_rec cgrv_rec_type;
83: BEGIN
84: x_return_status := OKC_API.G_RET_STS_SUCCESS;
85: l_return_status := OKC_API.START_ACTIVITY(p_api_name => l_api_name,
86: p_pkg_name => G_PKG_NAME,
87: p_init_msg_list => p_init_msg_list,
88: l_api_version => l_api_version,

Line 85: l_return_status := OKC_API.START_ACTIVITY(p_api_name => l_api_name,

81: l_valid BOOLEAN;
82: l_cgrv_rec cgrv_rec_type;
83: BEGIN
84: x_return_status := OKC_API.G_RET_STS_SUCCESS;
85: l_return_status := OKC_API.START_ACTIVITY(p_api_name => l_api_name,
86: p_pkg_name => G_PKG_NAME,
87: p_init_msg_list => p_init_msg_list,
88: l_api_version => l_api_version,
89: p_api_version => p_api_version,

Line 92: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

88: l_api_version => l_api_version,
89: p_api_version => p_api_version,
90: p_api_type => '_PVT',
91: x_return_status => l_return_status);
92: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
93: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
94: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
95: RAISE OKC_API.G_EXCEPTION_ERROR;
96: END IF;

Line 93: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

89: p_api_version => p_api_version,
90: p_api_type => '_PVT',
91: x_return_status => l_return_status);
92: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
93: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
94: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
95: RAISE OKC_API.G_EXCEPTION_ERROR;
96: END IF;
97:

Line 94: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

90: p_api_type => '_PVT',
91: x_return_status => l_return_status);
92: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
93: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
94: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
95: RAISE OKC_API.G_EXCEPTION_ERROR;
96: END IF;
97:
98: l_cgrv_rec := p_cgrv_rec;

Line 95: RAISE OKC_API.G_EXCEPTION_ERROR;

91: x_return_status => l_return_status);
92: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
93: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
94: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
95: RAISE OKC_API.G_EXCEPTION_ERROR;
96: END IF;
97:
98: l_cgrv_rec := p_cgrv_rec;
99:

Line 109: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN

105: x_msg_data => x_msg_data,
106: p_cgrv_rec => l_cgrv_rec,
107: x_cgrv_rec => x_cgrv_rec);
108:
109: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
110: RAISE OKC_API.G_EXCEPTION_ERROR;
111: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
112: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
113: END IF;

Line 110: RAISE OKC_API.G_EXCEPTION_ERROR;

106: p_cgrv_rec => l_cgrv_rec,
107: x_cgrv_rec => x_cgrv_rec);
108:
109: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
110: RAISE OKC_API.G_EXCEPTION_ERROR;
111: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
112: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
113: END IF;
114:

Line 111: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

107: x_cgrv_rec => x_cgrv_rec);
108:
109: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
110: RAISE OKC_API.G_EXCEPTION_ERROR;
111: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
112: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
113: END IF;
114:
115: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 112: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

108:
109: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
110: RAISE OKC_API.G_EXCEPTION_ERROR;
111: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
112: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
113: END IF;
114:
115: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
116: x_msg_data => x_msg_data);

Line 115: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,

111: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
112: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
113: END IF;
114:
115: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
116: x_msg_data => x_msg_data);
117: EXCEPTION
118: WHEN OKC_API.G_EXCEPTION_ERROR THEN
119: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

Line 118: WHEN OKC_API.G_EXCEPTION_ERROR THEN

114:
115: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
116: x_msg_data => x_msg_data);
117: EXCEPTION
118: WHEN OKC_API.G_EXCEPTION_ERROR THEN
119: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
120: p_pkg_name => G_PKG_NAME,
121: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
122: x_msg_count => x_msg_count,

Line 119: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

115: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
116: x_msg_data => x_msg_data);
117: EXCEPTION
118: WHEN OKC_API.G_EXCEPTION_ERROR THEN
119: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
120: p_pkg_name => G_PKG_NAME,
121: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
122: x_msg_count => x_msg_count,
123: x_msg_data => x_msg_data,

Line 121: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

117: EXCEPTION
118: WHEN OKC_API.G_EXCEPTION_ERROR THEN
119: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
120: p_pkg_name => G_PKG_NAME,
121: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
122: x_msg_count => x_msg_count,
123: x_msg_data => x_msg_data,
124: p_api_type => '_PVT');
125: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 125: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

121: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
122: x_msg_count => x_msg_count,
123: x_msg_data => x_msg_data,
124: p_api_type => '_PVT');
125: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
126: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
127: p_pkg_name => G_PKG_NAME,
128: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
129: x_msg_count => x_msg_count,

Line 126: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

122: x_msg_count => x_msg_count,
123: x_msg_data => x_msg_data,
124: p_api_type => '_PVT');
125: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
126: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
127: p_pkg_name => G_PKG_NAME,
128: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
129: x_msg_count => x_msg_count,
130: x_msg_data => x_msg_data,

Line 128: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

124: p_api_type => '_PVT');
125: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
126: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
127: p_pkg_name => G_PKG_NAME,
128: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
129: x_msg_count => x_msg_count,
130: x_msg_data => x_msg_data,
131: p_api_type => '_PVT');
132: WHEN OTHERS THEN

Line 133: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

129: x_msg_count => x_msg_count,
130: x_msg_data => x_msg_data,
131: p_api_type => '_PVT');
132: WHEN OTHERS THEN
133: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
134: p_pkg_name => G_PKG_NAME,
135: p_exc_name => 'OTHERS',
136: x_msg_count => x_msg_count,
137: x_msg_data => x_msg_data,

Line 155: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

151: x_cgrv_rec OUT NOCOPY cgrv_rec_type
152: ) IS
153: l_api_version CONSTANT NUMBER := 1;
154: l_api_name CONSTANT VARCHAR2(30) := 'update_contextgroups';
155: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
156: l_valid BOOLEAN;
157: l_cgrv_rec cgrv_rec_type;
158: BEGIN
159: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 159: x_return_status := OKC_API.G_RET_STS_SUCCESS;

155: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
156: l_valid BOOLEAN;
157: l_cgrv_rec cgrv_rec_type;
158: BEGIN
159: x_return_status := OKC_API.G_RET_STS_SUCCESS;
160: l_return_status := OKC_API.START_ACTIVITY(p_api_name => l_api_name,
161: p_pkg_name => G_PKG_NAME,
162: p_init_msg_list => p_init_msg_list,
163: l_api_version => l_api_version,

Line 160: l_return_status := OKC_API.START_ACTIVITY(p_api_name => l_api_name,

156: l_valid BOOLEAN;
157: l_cgrv_rec cgrv_rec_type;
158: BEGIN
159: x_return_status := OKC_API.G_RET_STS_SUCCESS;
160: l_return_status := OKC_API.START_ACTIVITY(p_api_name => l_api_name,
161: p_pkg_name => G_PKG_NAME,
162: p_init_msg_list => p_init_msg_list,
163: l_api_version => l_api_version,
164: p_api_version => p_api_version,

Line 167: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

163: l_api_version => l_api_version,
164: p_api_version => p_api_version,
165: p_api_type => '_PVT',
166: x_return_status => l_return_status);
167: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
168: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
169: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
170: RAISE OKC_API.G_EXCEPTION_ERROR;
171: END IF;

Line 168: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

164: p_api_version => p_api_version,
165: p_api_type => '_PVT',
166: x_return_status => l_return_status);
167: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
168: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
169: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
170: RAISE OKC_API.G_EXCEPTION_ERROR;
171: END IF;
172:

Line 169: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

165: p_api_type => '_PVT',
166: x_return_status => l_return_status);
167: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
168: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
169: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
170: RAISE OKC_API.G_EXCEPTION_ERROR;
171: END IF;
172:
173: l_cgrv_rec := p_cgrv_rec;

Line 170: RAISE OKC_API.G_EXCEPTION_ERROR;

166: x_return_status => l_return_status);
167: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
168: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
169: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
170: RAISE OKC_API.G_EXCEPTION_ERROR;
171: END IF;
172:
173: l_cgrv_rec := p_cgrv_rec;
174:

Line 184: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN

180: x_msg_data => x_msg_data,
181: p_cgrv_rec => l_cgrv_rec,
182: x_cgrv_rec => x_cgrv_rec);
183:
184: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
185: RAISE OKC_API.G_EXCEPTION_ERROR;
186: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
187: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
188: END IF;

Line 185: RAISE OKC_API.G_EXCEPTION_ERROR;

181: p_cgrv_rec => l_cgrv_rec,
182: x_cgrv_rec => x_cgrv_rec);
183:
184: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
185: RAISE OKC_API.G_EXCEPTION_ERROR;
186: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
187: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
188: END IF;
189:

Line 186: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

182: x_cgrv_rec => x_cgrv_rec);
183:
184: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
185: RAISE OKC_API.G_EXCEPTION_ERROR;
186: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
187: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
188: END IF;
189:
190: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 187: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

183:
184: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
185: RAISE OKC_API.G_EXCEPTION_ERROR;
186: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
187: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
188: END IF;
189:
190: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
191: x_msg_data => x_msg_data);

Line 190: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,

186: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
187: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
188: END IF;
189:
190: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
191: x_msg_data => x_msg_data);
192: EXCEPTION
193: WHEN OKC_API.G_EXCEPTION_ERROR THEN
194: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

Line 193: WHEN OKC_API.G_EXCEPTION_ERROR THEN

189:
190: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
191: x_msg_data => x_msg_data);
192: EXCEPTION
193: WHEN OKC_API.G_EXCEPTION_ERROR THEN
194: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
195: p_pkg_name => G_PKG_NAME,
196: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
197: x_msg_count => x_msg_count,

Line 194: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

190: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
191: x_msg_data => x_msg_data);
192: EXCEPTION
193: WHEN OKC_API.G_EXCEPTION_ERROR THEN
194: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
195: p_pkg_name => G_PKG_NAME,
196: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
197: x_msg_count => x_msg_count,
198: x_msg_data => x_msg_data,

Line 196: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

192: EXCEPTION
193: WHEN OKC_API.G_EXCEPTION_ERROR THEN
194: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
195: p_pkg_name => G_PKG_NAME,
196: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
197: x_msg_count => x_msg_count,
198: x_msg_data => x_msg_data,
199: p_api_type => '_PVT');
200: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 200: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

196: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
197: x_msg_count => x_msg_count,
198: x_msg_data => x_msg_data,
199: p_api_type => '_PVT');
200: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
201: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
202: p_pkg_name => G_PKG_NAME,
203: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
204: x_msg_count => x_msg_count,

Line 201: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

197: x_msg_count => x_msg_count,
198: x_msg_data => x_msg_data,
199: p_api_type => '_PVT');
200: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
201: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
202: p_pkg_name => G_PKG_NAME,
203: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
204: x_msg_count => x_msg_count,
205: x_msg_data => x_msg_data,

Line 203: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

199: p_api_type => '_PVT');
200: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
201: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
202: p_pkg_name => G_PKG_NAME,
203: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
204: x_msg_count => x_msg_count,
205: x_msg_data => x_msg_data,
206: p_api_type => '_PVT');
207: WHEN OTHERS THEN

Line 208: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

204: x_msg_count => x_msg_count,
205: x_msg_data => x_msg_data,
206: p_api_type => '_PVT');
207: WHEN OTHERS THEN
208: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
209: p_pkg_name => G_PKG_NAME,
210: p_exc_name => 'OTHERS',
211: x_msg_count => x_msg_count,
212: x_msg_data => x_msg_data,