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_VAR_INT_PARAMS_PVT dependencies on OKL_API

Line 32: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

28:
29: -- Variables Declarations
30: l_api_version CONSTANT NUMBER DEFAULT 1.0;
31: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'create_var_int_params';
32: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
33:
34: -- Record/Table Type Declarations
35: l_virv_rec virv_rec_type;
36:

Line 41: x_return_status := OKL_API.G_RET_STS_SUCCESS;

37: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VAR_INT_PARAMS_PVT.create_var_int_params';
38: l_debug_enabled VARCHAR2(10);
39:
40: BEGIN
41: x_return_status := OKL_API.G_RET_STS_SUCCESS;
42:
43: -- check for logging on PROCEDURE level
44: l_debug_enabled := okl_debug_pub.check_log_enabled;
45:

Line 52: l_return_status := OKL_API.START_ACTIVITY( p_api_name => l_api_name

48: END IF;
49:
50: -- call START_ACTIVITY to create savepoint, check compatibility
51: -- and initialize message list
52: l_return_status := OKL_API.START_ACTIVITY( p_api_name => l_api_name
53: ,p_pkg_name => G_PKG_NAME
54: ,p_init_msg_list => p_init_msg_list
55: ,l_api_version => l_api_version
56: ,p_api_version => p_api_version

Line 60: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

56: ,p_api_version => p_api_version
57: ,p_api_type => g_api_type
58: ,x_return_status => x_return_status);
59: -- check if activity started successfully
60: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
61: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
62: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
63: RAISE OKL_API.G_EXCEPTION_ERROR;
64: END IF;

Line 61: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

57: ,p_api_type => g_api_type
58: ,x_return_status => x_return_status);
59: -- check if activity started successfully
60: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
61: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
62: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
63: RAISE OKL_API.G_EXCEPTION_ERROR;
64: END IF;
65:

Line 62: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

58: ,x_return_status => x_return_status);
59: -- check if activity started successfully
60: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
61: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
62: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
63: RAISE OKL_API.G_EXCEPTION_ERROR;
64: END IF;
65:
66: l_virv_rec := p_virv_rec;

Line 63: RAISE OKL_API.G_EXCEPTION_ERROR;

59: -- check if activity started successfully
60: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
61: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
62: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
63: RAISE OKL_API.G_EXCEPTION_ERROR;
64: END IF;
65:
66: l_virv_rec := p_virv_rec;
67:

Line 85: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN

81: 'okl_vir_pvt.insert_row returned with status '||x_return_status||' id '||x_virv_rec.id
82: );
83: END IF;
84:
85: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
86: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
87: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
88: RAISE OKL_API.G_EXCEPTION_ERROR;
89: END IF;

Line 86: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

82: );
83: END IF;
84:
85: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
86: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
87: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
88: RAISE OKL_API.G_EXCEPTION_ERROR;
89: END IF;
90:

Line 87: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN

83: END IF;
84:
85: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
86: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
87: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
88: RAISE OKL_API.G_EXCEPTION_ERROR;
89: END IF;
90:
91: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count

Line 88: RAISE OKL_API.G_EXCEPTION_ERROR;

84:
85: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
86: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
87: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
88: RAISE OKL_API.G_EXCEPTION_ERROR;
89: END IF;
90:
91: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
92: ,x_msg_data => x_msg_data

Line 91: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count

87: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
88: RAISE OKL_API.G_EXCEPTION_ERROR;
89: END IF;
90:
91: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
92: ,x_msg_data => x_msg_data
93: );
94:
95: IF(NVL(l_debug_enabled,'N')='Y') THEN

Line 100: WHEN OKL_API.G_EXCEPTION_ERROR THEN

96: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVISB.pls call create_var_int_params for record');
97: END IF;
98:
99: EXCEPTION
100: WHEN OKL_API.G_EXCEPTION_ERROR THEN
101: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
102: p_api_name => l_api_name,
103: p_pkg_name => G_PKG_NAME,
104: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 101: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

97: END IF;
98:
99: EXCEPTION
100: WHEN OKL_API.G_EXCEPTION_ERROR THEN
101: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
102: p_api_name => l_api_name,
103: p_pkg_name => G_PKG_NAME,
104: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
105: x_msg_count => x_msg_count,

Line 104: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

100: WHEN OKL_API.G_EXCEPTION_ERROR THEN
101: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
102: p_api_name => l_api_name,
103: p_pkg_name => G_PKG_NAME,
104: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
105: x_msg_count => x_msg_count,
106: x_msg_data => x_msg_data,
107: p_api_type => g_api_type);
108:

Line 109: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

105: x_msg_count => x_msg_count,
106: x_msg_data => x_msg_data,
107: p_api_type => g_api_type);
108:
109: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
110: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
111: p_api_name => l_api_name,
112: p_pkg_name => G_PKG_NAME,
113: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 110: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

106: x_msg_data => x_msg_data,
107: p_api_type => g_api_type);
108:
109: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
110: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
111: p_api_name => l_api_name,
112: p_pkg_name => G_PKG_NAME,
113: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
114: x_msg_count => x_msg_count,

Line 113: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

109: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
110: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
111: p_api_name => l_api_name,
112: p_pkg_name => G_PKG_NAME,
113: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
114: x_msg_count => x_msg_count,
115: x_msg_data => x_msg_data,
116: p_api_type => g_api_type);
117:

Line 119: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

115: x_msg_data => x_msg_data,
116: p_api_type => g_api_type);
117:
118: WHEN OTHERS THEN
119: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
120: p_api_name => l_api_name,
121: p_pkg_name => G_PKG_NAME,
122: p_exc_name => 'OTHERS',
123: x_msg_count => x_msg_count,

Line 157: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

153:
154: -- Variables Declarations
155: l_api_version CONSTANT NUMBER DEFAULT 1.0;
156: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'create_var_int_params';
157: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
158:
159: -- Record/Table Type Declarations
160: l_virv_tbl virv_tbl_type;
161:

Line 167: x_return_status := OKL_API.G_RET_STS_SUCCESS;

163: l_debug_enabled VARCHAR2(10);
164: is_debug_procedure_on BOOLEAN;
165:
166: BEGIN
167: x_return_status := OKL_API.G_RET_STS_SUCCESS;
168:
169: -- check for logging on PROCEDURE level
170: l_debug_enabled := okl_debug_pub.check_log_enabled;
171:

Line 178: l_return_status := OKL_API.START_ACTIVITY( p_api_name => l_api_name

174: END IF;
175:
176: -- call START_ACTIVITY to create savepoint, check compatibility
177: -- and initialize message list
178: l_return_status := OKL_API.START_ACTIVITY( p_api_name => l_api_name
179: ,p_pkg_name => G_PKG_NAME
180: ,p_init_msg_list => p_init_msg_list
181: ,l_api_version => l_api_version
182: ,p_api_version => p_api_version

Line 186: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

182: ,p_api_version => p_api_version
183: ,p_api_type => g_api_type
184: ,x_return_status => x_return_status);
185: -- check if activity started successfully
186: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
187: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
188: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
189: RAISE OKL_API.G_EXCEPTION_ERROR;
190: END IF;

Line 187: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

183: ,p_api_type => g_api_type
184: ,x_return_status => x_return_status);
185: -- check if activity started successfully
186: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
187: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
188: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
189: RAISE OKL_API.G_EXCEPTION_ERROR;
190: END IF;
191:

Line 188: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

184: ,x_return_status => x_return_status);
185: -- check if activity started successfully
186: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
187: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
188: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
189: RAISE OKL_API.G_EXCEPTION_ERROR;
190: END IF;
191:
192: l_virv_tbl := p_virv_tbl;

Line 189: RAISE OKL_API.G_EXCEPTION_ERROR;

185: -- check if activity started successfully
186: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
187: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
188: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
189: RAISE OKL_API.G_EXCEPTION_ERROR;
190: END IF;
191:
192: l_virv_tbl := p_virv_tbl;
193:

Line 211: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN

207: 'okl_vir_pvt.insert_row returned with status '||x_return_status
208: );
209: END IF;
210:
211: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
212: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
213: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
214: RAISE OKL_API.G_EXCEPTION_ERROR;
215: END IF;

Line 212: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

208: );
209: END IF;
210:
211: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
212: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
213: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
214: RAISE OKL_API.G_EXCEPTION_ERROR;
215: END IF;
216:

Line 213: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN

209: END IF;
210:
211: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
212: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
213: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
214: RAISE OKL_API.G_EXCEPTION_ERROR;
215: END IF;
216:
217: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count

Line 214: RAISE OKL_API.G_EXCEPTION_ERROR;

210:
211: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
212: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
213: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
214: RAISE OKL_API.G_EXCEPTION_ERROR;
215: END IF;
216:
217: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
218: ,x_msg_data => x_msg_data

Line 217: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count

213: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
214: RAISE OKL_API.G_EXCEPTION_ERROR;
215: END IF;
216:
217: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
218: ,x_msg_data => x_msg_data
219: );
220:
221: IF(NVL(l_debug_enabled,'N')='Y') THEN

Line 226: WHEN OKL_API.G_EXCEPTION_ERROR THEN

222: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVISB.pls call create_var_int_params for table');
223: END IF;
224:
225: EXCEPTION
226: WHEN OKL_API.G_EXCEPTION_ERROR THEN
227: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
228: p_api_name => l_api_name,
229: p_pkg_name => G_PKG_NAME,
230: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 227: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

223: END IF;
224:
225: EXCEPTION
226: WHEN OKL_API.G_EXCEPTION_ERROR THEN
227: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
228: p_api_name => l_api_name,
229: p_pkg_name => G_PKG_NAME,
230: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
231: x_msg_count => x_msg_count,

Line 230: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

226: WHEN OKL_API.G_EXCEPTION_ERROR THEN
227: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
228: p_api_name => l_api_name,
229: p_pkg_name => G_PKG_NAME,
230: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
231: x_msg_count => x_msg_count,
232: x_msg_data => x_msg_data,
233: p_api_type => g_api_type);
234:

Line 235: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

231: x_msg_count => x_msg_count,
232: x_msg_data => x_msg_data,
233: p_api_type => g_api_type);
234:
235: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
236: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
237: p_api_name => l_api_name,
238: p_pkg_name => G_PKG_NAME,
239: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 236: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

232: x_msg_data => x_msg_data,
233: p_api_type => g_api_type);
234:
235: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
236: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
237: p_api_name => l_api_name,
238: p_pkg_name => G_PKG_NAME,
239: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
240: x_msg_count => x_msg_count,

Line 239: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

235: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
236: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
237: p_api_name => l_api_name,
238: p_pkg_name => G_PKG_NAME,
239: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
240: x_msg_count => x_msg_count,
241: x_msg_data => x_msg_data,
242: p_api_type => g_api_type);
243:

Line 245: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

241: x_msg_data => x_msg_data,
242: p_api_type => g_api_type);
243:
244: WHEN OTHERS THEN
245: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
246: p_api_name => l_api_name,
247: p_pkg_name => G_PKG_NAME,
248: p_exc_name => 'OTHERS',
249: x_msg_count => x_msg_count,

Line 282: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

278:
279: -- Variables Declarations
280: l_api_version CONSTANT NUMBER DEFAULT 1.0;
281: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'update_var_int_params';
282: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
283:
284: -- Record/Table Type Declarations
285: l_virv_rec virv_rec_type;
286:

Line 291: x_return_status := OKL_API.G_RET_STS_SUCCESS;

287: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VAR_INT_PARAMS_PVT.update_var_int_params';
288: l_debug_enabled VARCHAR2(10);
289:
290: BEGIN
291: x_return_status := OKL_API.G_RET_STS_SUCCESS;
292:
293: -- check for logging on PROCEDURE level
294: l_debug_enabled := okl_debug_pub.check_log_enabled;
295:

Line 302: l_return_status := OKL_API.START_ACTIVITY( p_api_name => l_api_name

298: END IF;
299:
300: -- call START_ACTIVITY to create savepoint, check compatibility
301: -- and initialize message list
302: l_return_status := OKL_API.START_ACTIVITY( p_api_name => l_api_name
303: ,p_pkg_name => G_PKG_NAME
304: ,p_init_msg_list => p_init_msg_list
305: ,l_api_version => l_api_version
306: ,p_api_version => p_api_version

Line 310: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

306: ,p_api_version => p_api_version
307: ,p_api_type => g_api_type
308: ,x_return_status => x_return_status);
309: -- check if activity started successfully
310: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
311: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
312: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
313: RAISE OKL_API.G_EXCEPTION_ERROR;
314: END IF;

Line 311: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

307: ,p_api_type => g_api_type
308: ,x_return_status => x_return_status);
309: -- check if activity started successfully
310: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
311: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
312: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
313: RAISE OKL_API.G_EXCEPTION_ERROR;
314: END IF;
315:

Line 312: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

308: ,x_return_status => x_return_status);
309: -- check if activity started successfully
310: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
311: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
312: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
313: RAISE OKL_API.G_EXCEPTION_ERROR;
314: END IF;
315:
316: l_virv_rec := p_virv_rec;

Line 313: RAISE OKL_API.G_EXCEPTION_ERROR;

309: -- check if activity started successfully
310: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
311: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
312: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
313: RAISE OKL_API.G_EXCEPTION_ERROR;
314: END IF;
315:
316: l_virv_rec := p_virv_rec;
317:

Line 331: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN

327: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
328: l_module,'okl_vir_pvt.update_row returned with status '||x_return_status||' id '||x_virv_rec.id
329: );
330: END IF;
331: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
332: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
333: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
334: RAISE OKL_API.G_EXCEPTION_ERROR;
335: END IF;

Line 332: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

328: l_module,'okl_vir_pvt.update_row returned with status '||x_return_status||' id '||x_virv_rec.id
329: );
330: END IF;
331: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
332: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
333: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
334: RAISE OKL_API.G_EXCEPTION_ERROR;
335: END IF;
336:

Line 333: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN

329: );
330: END IF;
331: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
332: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
333: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
334: RAISE OKL_API.G_EXCEPTION_ERROR;
335: END IF;
336:
337:

Line 334: RAISE OKL_API.G_EXCEPTION_ERROR;

330: END IF;
331: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
332: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
333: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
334: RAISE OKL_API.G_EXCEPTION_ERROR;
335: END IF;
336:
337:
338: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count

Line 338: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count

334: RAISE OKL_API.G_EXCEPTION_ERROR;
335: END IF;
336:
337:
338: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
339: ,x_msg_data => x_msg_data
340: );
341:
342: IF(NVL(l_debug_enabled,'N')='Y') THEN

Line 347: WHEN OKL_API.G_EXCEPTION_ERROR THEN

343: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'ends debug OKLRVISB.pls call update_var_int_params for record');
344: END IF;
345:
346: EXCEPTION
347: WHEN OKL_API.G_EXCEPTION_ERROR THEN
348: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
349: p_api_name => l_api_name,
350: p_pkg_name => G_PKG_NAME,
351: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 348: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

344: END IF;
345:
346: EXCEPTION
347: WHEN OKL_API.G_EXCEPTION_ERROR THEN
348: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
349: p_api_name => l_api_name,
350: p_pkg_name => G_PKG_NAME,
351: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
352: x_msg_count => x_msg_count,

Line 351: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

347: WHEN OKL_API.G_EXCEPTION_ERROR THEN
348: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
349: p_api_name => l_api_name,
350: p_pkg_name => G_PKG_NAME,
351: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
352: x_msg_count => x_msg_count,
353: x_msg_data => x_msg_data,
354: p_api_type => g_api_type);
355:

Line 356: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

352: x_msg_count => x_msg_count,
353: x_msg_data => x_msg_data,
354: p_api_type => g_api_type);
355:
356: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
357: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
358: p_api_name => l_api_name,
359: p_pkg_name => G_PKG_NAME,
360: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 357: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

353: x_msg_data => x_msg_data,
354: p_api_type => g_api_type);
355:
356: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
357: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
358: p_api_name => l_api_name,
359: p_pkg_name => G_PKG_NAME,
360: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
361: x_msg_count => x_msg_count,

Line 360: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

356: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
357: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
358: p_api_name => l_api_name,
359: p_pkg_name => G_PKG_NAME,
360: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
361: x_msg_count => x_msg_count,
362: x_msg_data => x_msg_data,
363: p_api_type => g_api_type);
364:

Line 366: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

362: x_msg_data => x_msg_data,
363: p_api_type => g_api_type);
364:
365: WHEN OTHERS THEN
366: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
367: p_api_name => l_api_name,
368: p_pkg_name => G_PKG_NAME,
369: p_exc_name => 'OTHERS',
370: x_msg_count => x_msg_count,

Line 402: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

398: x_virv_tbl OUT NOCOPY virv_tbl_type) IS
399: -- Variables Declarations
400: l_api_version CONSTANT NUMBER DEFAULT 1.0;
401: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'update_var_int_params';
402: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
403:
404: -- Record/Table Type Declarations
405: l_virv_tbl virv_tbl_type;
406:

Line 411: x_return_status := OKL_API.G_RET_STS_SUCCESS;

407: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VAR_INT_PARAMS_PVT.update_var_int_params';
408: l_debug_enabled VARCHAR2(10);
409:
410: BEGIN
411: x_return_status := OKL_API.G_RET_STS_SUCCESS;
412:
413: -- check for logging on PROCEDURE level
414: l_debug_enabled := okl_debug_pub.check_log_enabled;
415:

Line 422: l_return_status := OKL_API.START_ACTIVITY( p_api_name => l_api_name

418: END IF;
419:
420: -- call START_ACTIVITY to create savepoint, check compatibility
421: -- and initialize message list
422: l_return_status := OKL_API.START_ACTIVITY( p_api_name => l_api_name
423: ,p_pkg_name => G_PKG_NAME
424: ,p_init_msg_list => p_init_msg_list
425: ,l_api_version => l_api_version
426: ,p_api_version => p_api_version

Line 430: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

426: ,p_api_version => p_api_version
427: ,p_api_type => g_api_type
428: ,x_return_status => x_return_status);
429: -- check if activity started successfully
430: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
431: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
432: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
433: RAISE OKL_API.G_EXCEPTION_ERROR;
434: END IF;

Line 431: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

427: ,p_api_type => g_api_type
428: ,x_return_status => x_return_status);
429: -- check if activity started successfully
430: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
431: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
432: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
433: RAISE OKL_API.G_EXCEPTION_ERROR;
434: END IF;
435:

Line 432: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

428: ,x_return_status => x_return_status);
429: -- check if activity started successfully
430: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
431: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
432: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
433: RAISE OKL_API.G_EXCEPTION_ERROR;
434: END IF;
435:
436: l_virv_tbl := p_virv_tbl;

Line 433: RAISE OKL_API.G_EXCEPTION_ERROR;

429: -- check if activity started successfully
430: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
431: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
432: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
433: RAISE OKL_API.G_EXCEPTION_ERROR;
434: END IF;
435:
436: l_virv_tbl := p_virv_tbl;
437:

Line 451: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN

447: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
448: l_module,'okl_vir_pvt.update_row returned with status '||x_return_status
449: );
450: END IF;
451: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
452: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
453: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
454: RAISE OKL_API.G_EXCEPTION_ERROR;
455: END IF;

Line 452: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

448: l_module,'okl_vir_pvt.update_row returned with status '||x_return_status
449: );
450: END IF;
451: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
452: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
453: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
454: RAISE OKL_API.G_EXCEPTION_ERROR;
455: END IF;
456:

Line 453: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN

449: );
450: END IF;
451: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
452: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
453: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
454: RAISE OKL_API.G_EXCEPTION_ERROR;
455: END IF;
456:
457: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count

Line 454: RAISE OKL_API.G_EXCEPTION_ERROR;

450: END IF;
451: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
452: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
453: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
454: RAISE OKL_API.G_EXCEPTION_ERROR;
455: END IF;
456:
457: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
458: ,x_msg_data => x_msg_data

Line 457: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count

453: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
454: RAISE OKL_API.G_EXCEPTION_ERROR;
455: END IF;
456:
457: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
458: ,x_msg_data => x_msg_data
459: );
460: IF(NVL(l_debug_enabled,'N')='Y') THEN
461: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'ends debug OKLRVISB.pls call update_var_int_params for table');

Line 465: WHEN OKL_API.G_EXCEPTION_ERROR THEN

461: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'ends debug OKLRVISB.pls call update_var_int_params for table');
462: END IF;
463:
464: EXCEPTION
465: WHEN OKL_API.G_EXCEPTION_ERROR THEN
466: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
467: p_api_name => l_api_name,
468: p_pkg_name => G_PKG_NAME,
469: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 466: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

462: END IF;
463:
464: EXCEPTION
465: WHEN OKL_API.G_EXCEPTION_ERROR THEN
466: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
467: p_api_name => l_api_name,
468: p_pkg_name => G_PKG_NAME,
469: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
470: x_msg_count => x_msg_count,

Line 469: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

465: WHEN OKL_API.G_EXCEPTION_ERROR THEN
466: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
467: p_api_name => l_api_name,
468: p_pkg_name => G_PKG_NAME,
469: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
470: x_msg_count => x_msg_count,
471: x_msg_data => x_msg_data,
472: p_api_type => g_api_type);
473:

Line 474: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

470: x_msg_count => x_msg_count,
471: x_msg_data => x_msg_data,
472: p_api_type => g_api_type);
473:
474: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
475: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
476: p_api_name => l_api_name,
477: p_pkg_name => G_PKG_NAME,
478: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 475: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

471: x_msg_data => x_msg_data,
472: p_api_type => g_api_type);
473:
474: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
475: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
476: p_api_name => l_api_name,
477: p_pkg_name => G_PKG_NAME,
478: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
479: x_msg_count => x_msg_count,

Line 478: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

474: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
475: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
476: p_api_name => l_api_name,
477: p_pkg_name => G_PKG_NAME,
478: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
479: x_msg_count => x_msg_count,
480: x_msg_data => x_msg_data,
481: p_api_type => g_api_type);
482:

Line 484: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

480: x_msg_data => x_msg_data,
481: p_api_type => g_api_type);
482:
483: WHEN OTHERS THEN
484: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
485: p_api_name => l_api_name,
486: p_pkg_name => G_PKG_NAME,
487: p_exc_name => 'OTHERS',
488: x_msg_count => x_msg_count,

Line 520: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

516:
517: -- Variables Declarations
518: l_api_version CONSTANT NUMBER DEFAULT 1.0;
519: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'delete_var_int_params';
520: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
521:
522: -- Record/Table Type Declarations
523: l_virv_tbl virv_tbl_type;
524:

Line 529: x_return_status := OKL_API.G_RET_STS_SUCCESS;

525: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VAR_INT_PARAMS_PVT.delete_var_int_params';
526: l_debug_enabled VARCHAR2(10);
527:
528: BEGIN
529: x_return_status := OKL_API.G_RET_STS_SUCCESS;
530:
531: -- check for logging on PROCEDURE level
532: l_debug_enabled := okl_debug_pub.check_log_enabled;
533:

Line 540: l_return_status := OKL_API.START_ACTIVITY( p_api_name => l_api_name

536: END IF;
537:
538: -- call START_ACTIVITY to create savepoint, check compatibility
539: -- and initialize message list
540: l_return_status := OKL_API.START_ACTIVITY( p_api_name => l_api_name
541: ,p_pkg_name => G_PKG_NAME
542: ,p_init_msg_list => p_init_msg_list
543: ,l_api_version => l_api_version
544: ,p_api_version => p_api_version

Line 548: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

544: ,p_api_version => p_api_version
545: ,p_api_type => g_api_type
546: ,x_return_status => x_return_status);
547: -- check if activity started successfully
548: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
549: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
550: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
551: RAISE OKL_API.G_EXCEPTION_ERROR;
552: END IF;

Line 549: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

545: ,p_api_type => g_api_type
546: ,x_return_status => x_return_status);
547: -- check if activity started successfully
548: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
549: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
550: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
551: RAISE OKL_API.G_EXCEPTION_ERROR;
552: END IF;
553:

Line 550: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

546: ,x_return_status => x_return_status);
547: -- check if activity started successfully
548: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
549: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
550: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
551: RAISE OKL_API.G_EXCEPTION_ERROR;
552: END IF;
553:
554: l_virv_tbl := p_virv_tbl;

Line 551: RAISE OKL_API.G_EXCEPTION_ERROR;

547: -- check if activity started successfully
548: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
549: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
550: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
551: RAISE OKL_API.G_EXCEPTION_ERROR;
552: END IF;
553:
554: l_virv_tbl := p_virv_tbl;
555:

Line 569: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN

565: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
566: l_module,'okl_vir_pvt.delete_row returned with status '||x_return_status
567: );
568: END IF;
569: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
570: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
571: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
572: RAISE OKL_API.G_EXCEPTION_ERROR;
573: END IF;

Line 570: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

566: l_module,'okl_vir_pvt.delete_row returned with status '||x_return_status
567: );
568: END IF;
569: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
570: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
571: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
572: RAISE OKL_API.G_EXCEPTION_ERROR;
573: END IF;
574:

Line 571: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN

567: );
568: END IF;
569: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
570: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
571: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
572: RAISE OKL_API.G_EXCEPTION_ERROR;
573: END IF;
574:
575: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count

Line 572: RAISE OKL_API.G_EXCEPTION_ERROR;

568: END IF;
569: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
570: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
571: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
572: RAISE OKL_API.G_EXCEPTION_ERROR;
573: END IF;
574:
575: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
576: ,x_msg_data => x_msg_data

Line 575: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count

571: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
572: RAISE OKL_API.G_EXCEPTION_ERROR;
573: END IF;
574:
575: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
576: ,x_msg_data => x_msg_data
577: );
578: IF(NVL(l_debug_enabled,'N')='Y') THEN
579: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'ends debug OKLRVISB.pls call delete_var_int_params for a table');

Line 583: WHEN OKL_API.G_EXCEPTION_ERROR THEN

579: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'ends debug OKLRVISB.pls call delete_var_int_params for a table');
580: END IF;
581:
582: EXCEPTION
583: WHEN OKL_API.G_EXCEPTION_ERROR THEN
584: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
585: p_api_name => l_api_name,
586: p_pkg_name => G_PKG_NAME,
587: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 584: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

580: END IF;
581:
582: EXCEPTION
583: WHEN OKL_API.G_EXCEPTION_ERROR THEN
584: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
585: p_api_name => l_api_name,
586: p_pkg_name => G_PKG_NAME,
587: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
588: x_msg_count => x_msg_count,

Line 587: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

583: WHEN OKL_API.G_EXCEPTION_ERROR THEN
584: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
585: p_api_name => l_api_name,
586: p_pkg_name => G_PKG_NAME,
587: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
588: x_msg_count => x_msg_count,
589: x_msg_data => x_msg_data,
590: p_api_type => g_api_type);
591:

Line 592: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

588: x_msg_count => x_msg_count,
589: x_msg_data => x_msg_data,
590: p_api_type => g_api_type);
591:
592: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
593: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
594: p_api_name => l_api_name,
595: p_pkg_name => G_PKG_NAME,
596: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 593: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

589: x_msg_data => x_msg_data,
590: p_api_type => g_api_type);
591:
592: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
593: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
594: p_api_name => l_api_name,
595: p_pkg_name => G_PKG_NAME,
596: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
597: x_msg_count => x_msg_count,

Line 596: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

592: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
593: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
594: p_api_name => l_api_name,
595: p_pkg_name => G_PKG_NAME,
596: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
597: x_msg_count => x_msg_count,
598: x_msg_data => x_msg_data,
599: p_api_type => g_api_type);
600:

Line 602: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

598: x_msg_data => x_msg_data,
599: p_api_type => g_api_type);
600:
601: WHEN OTHERS THEN
602: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
603: p_api_name => l_api_name,
604: p_pkg_name => G_PKG_NAME,
605: p_exc_name => 'OTHERS',
606: x_msg_count => x_msg_count,

Line 639: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

635:
636:
637: l_api_name CONSTANT VARCHAR2(30) := 'validate_var_int_params';
638: l_api_version CONSTANT NUMBER := 1.0;
639: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
640:
641: l_virv_rec virv_rec_type;
642:
643: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VAR_INT_PARAMS_PVT.validate_var_int_params';

Line 648: x_return_status := OKL_API.G_RET_STS_SUCCESS;

644: l_debug_enabled VARCHAR2(10);
645:
646: Begin
647:
648: x_return_status := OKL_API.G_RET_STS_SUCCESS;
649:
650: -- check for logging on PROCEDURE level
651: l_debug_enabled := okl_debug_pub.check_log_enabled;
652:

Line 660: l_return_status := OKL_API.START_ACTIVITY(

656:
657: -- call START_ACTIVITY to create savepoint, check compatibility
658: -- and initialize message list
659:
660: l_return_status := OKL_API.START_ACTIVITY(
661: p_api_name => l_api_name,
662: p_pkg_name => g_pkg_name,
663: p_init_msg_list => p_init_msg_list,
664: l_api_version => l_api_version,

Line 670: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

666: p_api_type => g_api_type,
667: x_return_status => x_return_status);
668:
669: -- check if activity started successfully
670: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
671: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
672: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
673: raise OKL_API.G_EXCEPTION_ERROR;
674: End If;

Line 671: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

667: x_return_status => x_return_status);
668:
669: -- check if activity started successfully
670: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
671: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
672: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
673: raise OKL_API.G_EXCEPTION_ERROR;
674: End If;
675:

Line 672: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then

668:
669: -- check if activity started successfully
670: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
671: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
672: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
673: raise OKL_API.G_EXCEPTION_ERROR;
674: End If;
675:
676: l_virv_rec := p_virv_rec;

Line 673: raise OKL_API.G_EXCEPTION_ERROR;

669: -- check if activity started successfully
670: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
671: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
672: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
673: raise OKL_API.G_EXCEPTION_ERROR;
674: End If;
675:
676: l_virv_rec := p_virv_rec;
677: --call the TAPI validate_row to validate the row.

Line 693: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

689: );
690: END IF;
691:
692: -- check return status
693: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
694: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
695: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
696: raise OKL_API.G_EXCEPTION_ERROR;
697: End If;

Line 694: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

690: END IF;
691:
692: -- check return status
693: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
694: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
695: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
696: raise OKL_API.G_EXCEPTION_ERROR;
697: End If;
698:

Line 695: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

691:
692: -- check return status
693: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
694: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
695: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
696: raise OKL_API.G_EXCEPTION_ERROR;
697: End If;
698:
699: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 696: raise OKL_API.G_EXCEPTION_ERROR;

692: -- check return status
693: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
694: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
695: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
696: raise OKL_API.G_EXCEPTION_ERROR;
697: End If;
698:
699: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
700: x_msg_data => x_msg_data

Line 699: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

695: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
696: raise OKL_API.G_EXCEPTION_ERROR;
697: End If;
698:
699: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
700: x_msg_data => x_msg_data
701: );
702: IF(NVL(l_debug_enabled,'N')='Y') THEN
703: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'ends debug OKLRVISB.pls call validate_var_int_params for a record');

Line 707: when OKL_API.G_EXCEPTION_ERROR then

703: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'ends debug OKLRVISB.pls call validate_var_int_params for a record');
704: END IF;
705:
706: EXCEPTION
707: when OKL_API.G_EXCEPTION_ERROR then
708: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
709: p_api_name => l_api_name,
710: p_pkg_name => g_pkg_name,
711: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 708: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

704: END IF;
705:
706: EXCEPTION
707: when OKL_API.G_EXCEPTION_ERROR then
708: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
709: p_api_name => l_api_name,
710: p_pkg_name => g_pkg_name,
711: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
712: x_msg_count => x_msg_count,

Line 711: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

707: when OKL_API.G_EXCEPTION_ERROR then
708: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
709: p_api_name => l_api_name,
710: p_pkg_name => g_pkg_name,
711: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
712: x_msg_count => x_msg_count,
713: x_msg_data => x_msg_data,
714: p_api_type => g_api_type);
715:

Line 716: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

712: x_msg_count => x_msg_count,
713: x_msg_data => x_msg_data,
714: p_api_type => g_api_type);
715:
716: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
717: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
718: p_api_name => l_api_name,
719: p_pkg_name => g_pkg_name,
720: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 717: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

713: x_msg_data => x_msg_data,
714: p_api_type => g_api_type);
715:
716: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
717: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
718: p_api_name => l_api_name,
719: p_pkg_name => g_pkg_name,
720: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
721: x_msg_count => x_msg_count,

Line 720: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

716: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
717: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
718: p_api_name => l_api_name,
719: p_pkg_name => g_pkg_name,
720: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
721: x_msg_count => x_msg_count,
722: x_msg_data => x_msg_data,
723: p_api_type => g_api_type);
724:

Line 726: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

722: x_msg_data => x_msg_data,
723: p_api_type => g_api_type);
724:
725: when OTHERS then
726: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
727: p_api_name => l_api_name,
728: p_pkg_name => g_pkg_name,
729: p_exc_name => 'OTHERS',
730: x_msg_count => x_msg_count,

Line 763: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

759:
760:
761: l_api_name CONSTANT VARCHAR2(30) := 'validate_var_int_params';
762: l_api_version CONSTANT NUMBER := 1.0;
763: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
764:
765: l_virv_tbl virv_tbl_type;
766:
767: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VAR_INT_PARAMS_PVT.validate_var_int_params';

Line 772: x_return_status := OKL_API.G_RET_STS_SUCCESS;

768: l_debug_enabled VARCHAR2(10);
769:
770: Begin
771:
772: x_return_status := OKL_API.G_RET_STS_SUCCESS;
773:
774: -- check for logging on PROCEDURE level
775: l_debug_enabled := okl_debug_pub.check_log_enabled;
776:

Line 784: l_return_status := OKL_API.START_ACTIVITY(

780:
781: -- call START_ACTIVITY to create savepoint, check compatibility
782: -- and initialize message list
783:
784: l_return_status := OKL_API.START_ACTIVITY(
785: p_api_name => l_api_name,
786: p_pkg_name => g_pkg_name,
787: p_init_msg_list => p_init_msg_list,
788: l_api_version => l_api_version,

Line 794: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

790: p_api_type => g_api_type,
791: x_return_status => x_return_status);
792:
793: -- check if activity started successfully
794: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
795: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
796: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
797: raise OKL_API.G_EXCEPTION_ERROR;
798: End If;

Line 795: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

791: x_return_status => x_return_status);
792:
793: -- check if activity started successfully
794: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
795: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
796: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
797: raise OKL_API.G_EXCEPTION_ERROR;
798: End If;
799:

Line 796: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then

792:
793: -- check if activity started successfully
794: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
795: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
796: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
797: raise OKL_API.G_EXCEPTION_ERROR;
798: End If;
799:
800: l_virv_tbl := p_virv_tbl;

Line 797: raise OKL_API.G_EXCEPTION_ERROR;

793: -- check if activity started successfully
794: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
795: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
796: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
797: raise OKL_API.G_EXCEPTION_ERROR;
798: End If;
799:
800: l_virv_tbl := p_virv_tbl;
801: --call the TAPI validate_row to validate the row.

Line 817: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

813: );
814: END IF;
815:
816: -- check return status
817: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
818: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
819: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
820: raise OKL_API.G_EXCEPTION_ERROR;
821: End If;

Line 818: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

814: END IF;
815:
816: -- check return status
817: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
818: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
819: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
820: raise OKL_API.G_EXCEPTION_ERROR;
821: End If;
822:

Line 819: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

815:
816: -- check return status
817: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
818: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
819: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
820: raise OKL_API.G_EXCEPTION_ERROR;
821: End If;
822:
823: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 820: raise OKL_API.G_EXCEPTION_ERROR;

816: -- check return status
817: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
818: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
819: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
820: raise OKL_API.G_EXCEPTION_ERROR;
821: End If;
822:
823: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
824: x_msg_data => x_msg_data

Line 823: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

819: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
820: raise OKL_API.G_EXCEPTION_ERROR;
821: End If;
822:
823: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
824: x_msg_data => x_msg_data
825: );
826: IF(NVL(l_debug_enabled,'N')='Y') THEN
827: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'ends debug OKLRVISB.pls call validate_var_int_params for a table');

Line 831: when OKL_API.G_EXCEPTION_ERROR then

827: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'ends debug OKLRVISB.pls call validate_var_int_params for a table');
828: END IF;
829:
830: EXCEPTION
831: when OKL_API.G_EXCEPTION_ERROR then
832: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
833: p_api_name => l_api_name,
834: p_pkg_name => g_pkg_name,
835: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 832: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

828: END IF;
829:
830: EXCEPTION
831: when OKL_API.G_EXCEPTION_ERROR then
832: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
833: p_api_name => l_api_name,
834: p_pkg_name => g_pkg_name,
835: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
836: x_msg_count => x_msg_count,

Line 835: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

831: when OKL_API.G_EXCEPTION_ERROR then
832: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
833: p_api_name => l_api_name,
834: p_pkg_name => g_pkg_name,
835: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
836: x_msg_count => x_msg_count,
837: x_msg_data => x_msg_data,
838: p_api_type => g_api_type);
839:

Line 840: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

836: x_msg_count => x_msg_count,
837: x_msg_data => x_msg_data,
838: p_api_type => g_api_type);
839:
840: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
841: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
842: p_api_name => l_api_name,
843: p_pkg_name => g_pkg_name,
844: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 841: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

837: x_msg_data => x_msg_data,
838: p_api_type => g_api_type);
839:
840: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
841: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
842: p_api_name => l_api_name,
843: p_pkg_name => g_pkg_name,
844: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
845: x_msg_count => x_msg_count,

Line 844: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

840: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
841: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
842: p_api_name => l_api_name,
843: p_pkg_name => g_pkg_name,
844: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
845: x_msg_count => x_msg_count,
846: x_msg_data => x_msg_data,
847: p_api_type => g_api_type);
848:

Line 850: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

846: x_msg_data => x_msg_data,
847: p_api_type => g_api_type);
848:
849: when OTHERS then
850: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
851: p_api_name => l_api_name,
852: p_pkg_name => g_pkg_name,
853: p_exc_name => 'OTHERS',
854: x_msg_count => x_msg_count,