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_SETUPFMACONSTRAINTS_PVT dependencies on OKC_API

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

148: x_fodv_rec OUT NOCOPY fodv_rec_type
149: ) IS
150: l_api_version CONSTANT NUMBER := 1;
151: l_api_name CONSTANT VARCHAR2(30) := 'insert_fmaconstraints';
152: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
153: l_valid BOOLEAN;
154: l_fmav_rec fmav_rec_type;
155: l_fodv_rec fodv_rec_type;
156: BEGIN

Line 157: x_return_status := OKC_API.G_RET_STS_SUCCESS;

153: l_valid BOOLEAN;
154: l_fmav_rec fmav_rec_type;
155: l_fodv_rec fodv_rec_type;
156: BEGIN
157: x_return_status := OKC_API.G_RET_STS_SUCCESS;
158: l_return_status := OKC_API.START_ACTIVITY(p_api_name => l_api_name,
159: p_pkg_name => G_PKG_NAME,
160: p_init_msg_list => p_init_msg_list,
161: l_api_version => l_api_version,

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

154: l_fmav_rec fmav_rec_type;
155: l_fodv_rec fodv_rec_type;
156: BEGIN
157: x_return_status := OKC_API.G_RET_STS_SUCCESS;
158: l_return_status := OKC_API.START_ACTIVITY(p_api_name => l_api_name,
159: p_pkg_name => G_PKG_NAME,
160: p_init_msg_list => p_init_msg_list,
161: l_api_version => l_api_version,
162: p_api_version => p_api_version,

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

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

Line 166: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 168: RAISE OKC_API.G_EXCEPTION_ERROR;

164: x_return_status => l_return_status);
165: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
166: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
167: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
168: RAISE OKC_API.G_EXCEPTION_ERROR;
169: END IF;
170:
171: l_fmav_rec := p_fmav_rec;
172: l_fodv_rec := p_fodv_rec;

Line 181: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

177: p_fodv_rec => l_fodv_rec,
178: x_return_status => l_return_status,
179: x_valid => l_valid);
180: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
181: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
182: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
183: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
184: l_valid <> TRUE) THEN
185: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 186: RAISE OKC_API.G_EXCEPTION_ERROR;

182: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
183: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
184: l_valid <> TRUE) THEN
185: x_return_status := OKL_API.G_RET_STS_ERROR;
186: RAISE OKC_API.G_EXCEPTION_ERROR;
187: END IF;
188:
189: /* public api to insert formulae constraints */
190: -- Start of wraper code generated automatically by Debug code generator for okl_fmla_oprnds_pub.insert_fmla_oprnds

Line 214: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN

210: END;
211: END IF;
212: -- End of wraper code generated automatically by Debug code generator for okl_fmla_oprnds_pub.insert_fmla_oprnds
213:
214: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
215: RAISE OKC_API.G_EXCEPTION_ERROR;
216: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
217: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
218: END IF;

Line 215: RAISE OKC_API.G_EXCEPTION_ERROR;

211: END IF;
212: -- End of wraper code generated automatically by Debug code generator for okl_fmla_oprnds_pub.insert_fmla_oprnds
213:
214: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
215: RAISE OKC_API.G_EXCEPTION_ERROR;
216: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
217: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
218: END IF;
219:

Line 216: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

212: -- End of wraper code generated automatically by Debug code generator for okl_fmla_oprnds_pub.insert_fmla_oprnds
213:
214: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
215: RAISE OKC_API.G_EXCEPTION_ERROR;
216: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
217: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
218: END IF;
219:
220: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 217: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

213:
214: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
215: RAISE OKC_API.G_EXCEPTION_ERROR;
216: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
217: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
218: END IF;
219:
220: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
221: x_msg_data => x_msg_data);

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

216: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
217: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
218: END IF;
219:
220: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
221: x_msg_data => x_msg_data);
222: EXCEPTION
223: WHEN OKC_API.G_EXCEPTION_ERROR THEN
224: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

Line 223: WHEN OKC_API.G_EXCEPTION_ERROR THEN

219:
220: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
221: x_msg_data => x_msg_data);
222: EXCEPTION
223: WHEN OKC_API.G_EXCEPTION_ERROR THEN
224: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
225: p_pkg_name => G_PKG_NAME,
226: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
227: x_msg_count => x_msg_count,

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

220: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
221: x_msg_data => x_msg_data);
222: EXCEPTION
223: WHEN OKC_API.G_EXCEPTION_ERROR THEN
224: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
225: p_pkg_name => G_PKG_NAME,
226: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
227: x_msg_count => x_msg_count,
228: x_msg_data => x_msg_data,

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

222: EXCEPTION
223: WHEN OKC_API.G_EXCEPTION_ERROR THEN
224: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
225: p_pkg_name => G_PKG_NAME,
226: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
227: x_msg_count => x_msg_count,
228: x_msg_data => x_msg_data,
229: p_api_type => '_PVT');
230: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 230: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

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

227: x_msg_count => x_msg_count,
228: x_msg_data => x_msg_data,
229: p_api_type => '_PVT');
230: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
231: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
232: p_pkg_name => G_PKG_NAME,
233: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
234: x_msg_count => x_msg_count,
235: x_msg_data => x_msg_data,

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

229: p_api_type => '_PVT');
230: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
231: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
232: p_pkg_name => G_PKG_NAME,
233: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
234: x_msg_count => x_msg_count,
235: x_msg_data => x_msg_data,
236: p_api_type => '_PVT');
237: WHEN OTHERS THEN

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

234: x_msg_count => x_msg_count,
235: x_msg_data => x_msg_data,
236: p_api_type => '_PVT');
237: WHEN OTHERS THEN
238: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
239: p_pkg_name => G_PKG_NAME,
240: p_exc_name => 'OTHERS',
241: x_msg_count => x_msg_count,
242: x_msg_data => x_msg_data,

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

257: x_fodv_rec OUT NOCOPY fodv_rec_type
258: ) IS
259: l_api_version CONSTANT NUMBER := 1;
260: l_api_name CONSTANT VARCHAR2(30) := 'update_fmaconstraints';
261: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
262: l_valid BOOLEAN;
263: l_fmav_rec fmav_rec_type;
264: l_fodv_rec fodv_rec_type;
265: BEGIN

Line 266: x_return_status := OKC_API.G_RET_STS_SUCCESS;

262: l_valid BOOLEAN;
263: l_fmav_rec fmav_rec_type;
264: l_fodv_rec fodv_rec_type;
265: BEGIN
266: x_return_status := OKC_API.G_RET_STS_SUCCESS;
267: l_return_status := OKC_API.START_ACTIVITY(p_api_name => l_api_name,
268: p_pkg_name => G_PKG_NAME,
269: p_init_msg_list => p_init_msg_list,
270: l_api_version => l_api_version,

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

263: l_fmav_rec fmav_rec_type;
264: l_fodv_rec fodv_rec_type;
265: BEGIN
266: x_return_status := OKC_API.G_RET_STS_SUCCESS;
267: l_return_status := OKC_API.START_ACTIVITY(p_api_name => l_api_name,
268: p_pkg_name => G_PKG_NAME,
269: p_init_msg_list => p_init_msg_list,
270: l_api_version => l_api_version,
271: p_api_version => p_api_version,

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

270: l_api_version => l_api_version,
271: p_api_version => p_api_version,
272: p_api_type => '_PVT',
273: x_return_status => l_return_status);
274: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
275: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
276: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
277: RAISE OKC_API.G_EXCEPTION_ERROR;
278: END IF;

Line 275: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

271: p_api_version => p_api_version,
272: p_api_type => '_PVT',
273: x_return_status => l_return_status);
274: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
275: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
276: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
277: RAISE OKC_API.G_EXCEPTION_ERROR;
278: END IF;
279:

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

272: p_api_type => '_PVT',
273: x_return_status => l_return_status);
274: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
275: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
276: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
277: RAISE OKC_API.G_EXCEPTION_ERROR;
278: END IF;
279:
280: l_fmav_rec := p_fmav_rec;

Line 277: RAISE OKC_API.G_EXCEPTION_ERROR;

273: x_return_status => l_return_status);
274: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
275: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
276: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
277: RAISE OKC_API.G_EXCEPTION_ERROR;
278: END IF;
279:
280: l_fmav_rec := p_fmav_rec;
281: l_fodv_rec := p_fodv_rec;

Line 289: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

285: p_fodv_rec => l_fodv_rec,
286: x_return_status => l_return_status,
287: x_valid => l_valid);
288: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
289: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
290: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
291: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
292: l_valid <> TRUE) THEN
293: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 294: RAISE OKC_API.G_EXCEPTION_ERROR;

290: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
291: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
292: l_valid <> TRUE) THEN
293: x_return_status := OKL_API.G_RET_STS_ERROR;
294: RAISE OKC_API.G_EXCEPTION_ERROR;
295: END IF;
296:
297: /* public api to insert formulae constraints */
298: -- Start of wraper code generated automatically by Debug code generator for okl_fmla_oprnds_pub.update_fmla_oprnds

Line 322: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN

318: END;
319: END IF;
320: -- End of wraper code generated automatically by Debug code generator for okl_fmla_oprnds_pub.update_fmla_oprnds
321:
322: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
323: RAISE OKC_API.G_EXCEPTION_ERROR;
324: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
325: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
326: END IF;

Line 323: RAISE OKC_API.G_EXCEPTION_ERROR;

319: END IF;
320: -- End of wraper code generated automatically by Debug code generator for okl_fmla_oprnds_pub.update_fmla_oprnds
321:
322: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
323: RAISE OKC_API.G_EXCEPTION_ERROR;
324: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
325: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
326: END IF;
327:

Line 324: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

320: -- End of wraper code generated automatically by Debug code generator for okl_fmla_oprnds_pub.update_fmla_oprnds
321:
322: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
323: RAISE OKC_API.G_EXCEPTION_ERROR;
324: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
325: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
326: END IF;
327:
328: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 325: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

321:
322: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
323: RAISE OKC_API.G_EXCEPTION_ERROR;
324: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
325: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
326: END IF;
327:
328: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
329: x_msg_data => x_msg_data);

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

324: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
325: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
326: END IF;
327:
328: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
329: x_msg_data => x_msg_data);
330: EXCEPTION
331: WHEN OKC_API.G_EXCEPTION_ERROR THEN
332: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

Line 331: WHEN OKC_API.G_EXCEPTION_ERROR THEN

327:
328: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
329: x_msg_data => x_msg_data);
330: EXCEPTION
331: WHEN OKC_API.G_EXCEPTION_ERROR THEN
332: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
333: p_pkg_name => G_PKG_NAME,
334: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
335: x_msg_count => x_msg_count,

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

328: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
329: x_msg_data => x_msg_data);
330: EXCEPTION
331: WHEN OKC_API.G_EXCEPTION_ERROR THEN
332: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
333: p_pkg_name => G_PKG_NAME,
334: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
335: x_msg_count => x_msg_count,
336: x_msg_data => x_msg_data,

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

330: EXCEPTION
331: WHEN OKC_API.G_EXCEPTION_ERROR THEN
332: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
333: p_pkg_name => G_PKG_NAME,
334: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
335: x_msg_count => x_msg_count,
336: x_msg_data => x_msg_data,
337: p_api_type => '_PVT');
338: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 338: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

334: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
335: x_msg_count => x_msg_count,
336: x_msg_data => x_msg_data,
337: p_api_type => '_PVT');
338: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
339: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
340: p_pkg_name => G_PKG_NAME,
341: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
342: x_msg_count => x_msg_count,

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

335: x_msg_count => x_msg_count,
336: x_msg_data => x_msg_data,
337: p_api_type => '_PVT');
338: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
339: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
340: p_pkg_name => G_PKG_NAME,
341: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
342: x_msg_count => x_msg_count,
343: x_msg_data => x_msg_data,

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

337: p_api_type => '_PVT');
338: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
339: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
340: p_pkg_name => G_PKG_NAME,
341: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
342: x_msg_count => x_msg_count,
343: x_msg_data => x_msg_data,
344: p_api_type => '_PVT');
345: WHEN OTHERS THEN

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

342: x_msg_count => x_msg_count,
343: x_msg_data => x_msg_data,
344: p_api_type => '_PVT');
345: WHEN OTHERS THEN
346: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
347: p_pkg_name => G_PKG_NAME,
348: p_exc_name => 'OTHERS',
349: x_msg_count => x_msg_count,
350: x_msg_data => x_msg_data,

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

367: ) IS
368: l_api_version CONSTANT NUMBER := 1;
369: l_fodv_tbl fodv_tbl_type;
370: l_api_name CONSTANT VARCHAR2(30) := 'delete_fmaconstraints';
371: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
372:
373: BEGIN
374: x_return_status := OKC_API.G_RET_STS_SUCCESS;
375: l_return_status := OKC_API.START_ACTIVITY(p_api_name => l_api_name,

Line 374: x_return_status := OKC_API.G_RET_STS_SUCCESS;

370: l_api_name CONSTANT VARCHAR2(30) := 'delete_fmaconstraints';
371: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
372:
373: BEGIN
374: x_return_status := OKC_API.G_RET_STS_SUCCESS;
375: l_return_status := OKC_API.START_ACTIVITY(p_api_name => l_api_name,
376: p_pkg_name => G_PKG_NAME,
377: p_init_msg_list => p_init_msg_list,
378: l_api_version => l_api_version,

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

371: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
372:
373: BEGIN
374: x_return_status := OKC_API.G_RET_STS_SUCCESS;
375: l_return_status := OKC_API.START_ACTIVITY(p_api_name => l_api_name,
376: p_pkg_name => G_PKG_NAME,
377: p_init_msg_list => p_init_msg_list,
378: l_api_version => l_api_version,
379: p_api_version => p_api_version,

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

378: l_api_version => l_api_version,
379: p_api_version => p_api_version,
380: p_api_type => '_PVT',
381: x_return_status => l_return_status);
382: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
383: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
384: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
385: RAISE OKC_API.G_EXCEPTION_ERROR;
386: END IF;

Line 383: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

379: p_api_version => p_api_version,
380: p_api_type => '_PVT',
381: x_return_status => l_return_status);
382: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
383: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
384: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
385: RAISE OKC_API.G_EXCEPTION_ERROR;
386: END IF;
387:

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

380: p_api_type => '_PVT',
381: x_return_status => l_return_status);
382: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
383: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
384: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
385: RAISE OKC_API.G_EXCEPTION_ERROR;
386: END IF;
387:
388: l_fodv_tbl := p_fodv_tbl;

Line 385: RAISE OKC_API.G_EXCEPTION_ERROR;

381: x_return_status => l_return_status);
382: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
383: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
384: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
385: RAISE OKC_API.G_EXCEPTION_ERROR;
386: END IF;
387:
388: l_fodv_tbl := p_fodv_tbl;
389:

Line 414: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN

410: END;
411: END IF;
412: -- End of wraper code generated automatically by Debug code generator for okl_fmla_oprnds_pub.delete_fmla_oprnds
413:
414: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
415: RAISE OKC_API.G_EXCEPTION_ERROR;
416: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
417: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
418: END IF;

Line 415: RAISE OKC_API.G_EXCEPTION_ERROR;

411: END IF;
412: -- End of wraper code generated automatically by Debug code generator for okl_fmla_oprnds_pub.delete_fmla_oprnds
413:
414: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
415: RAISE OKC_API.G_EXCEPTION_ERROR;
416: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
417: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
418: END IF;
419:

Line 416: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

412: -- End of wraper code generated automatically by Debug code generator for okl_fmla_oprnds_pub.delete_fmla_oprnds
413:
414: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
415: RAISE OKC_API.G_EXCEPTION_ERROR;
416: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
417: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
418: END IF;
419:
420: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 417: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

413:
414: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
415: RAISE OKC_API.G_EXCEPTION_ERROR;
416: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
417: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
418: END IF;
419:
420: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
421: x_msg_data => x_msg_data);

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

416: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
417: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
418: END IF;
419:
420: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
421: x_msg_data => x_msg_data);
422: EXCEPTION
423: WHEN OKC_API.G_EXCEPTION_ERROR THEN
424: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

Line 423: WHEN OKC_API.G_EXCEPTION_ERROR THEN

419:
420: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
421: x_msg_data => x_msg_data);
422: EXCEPTION
423: WHEN OKC_API.G_EXCEPTION_ERROR THEN
424: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
425: p_pkg_name => G_PKG_NAME,
426: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
427: x_msg_count => x_msg_count,

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

420: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
421: x_msg_data => x_msg_data);
422: EXCEPTION
423: WHEN OKC_API.G_EXCEPTION_ERROR THEN
424: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
425: p_pkg_name => G_PKG_NAME,
426: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
427: x_msg_count => x_msg_count,
428: x_msg_data => x_msg_data,

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

422: EXCEPTION
423: WHEN OKC_API.G_EXCEPTION_ERROR THEN
424: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
425: p_pkg_name => G_PKG_NAME,
426: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
427: x_msg_count => x_msg_count,
428: x_msg_data => x_msg_data,
429: p_api_type => '_PVT');
430: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 430: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

426: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
427: x_msg_count => x_msg_count,
428: x_msg_data => x_msg_data,
429: p_api_type => '_PVT');
430: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
431: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
432: p_pkg_name => G_PKG_NAME,
433: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
434: x_msg_count => x_msg_count,

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

427: x_msg_count => x_msg_count,
428: x_msg_data => x_msg_data,
429: p_api_type => '_PVT');
430: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
431: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
432: p_pkg_name => G_PKG_NAME,
433: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
434: x_msg_count => x_msg_count,
435: x_msg_data => x_msg_data,

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

429: p_api_type => '_PVT');
430: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
431: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
432: p_pkg_name => G_PKG_NAME,
433: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
434: x_msg_count => x_msg_count,
435: x_msg_data => x_msg_data,
436: p_api_type => '_PVT');
437: WHEN OTHERS THEN

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

434: x_msg_count => x_msg_count,
435: x_msg_data => x_msg_data,
436: p_api_type => '_PVT');
437: WHEN OTHERS THEN
438: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
439: p_pkg_name => G_PKG_NAME,
440: p_exc_name => 'OTHERS',
441: x_msg_count => x_msg_count,
442: x_msg_data => x_msg_data,

Line 521: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

517: WHEN FND_API.G_EXC_ERROR THEN
518: ROLLBACK TO insert_fmaconstraints;
519: x_return_status := FND_API.G_RET_STS_ERROR;
520:
521: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
522: ,p_count => x_msg_count
523: ,p_data => x_msg_data);
524:
525: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 528: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

524:
525: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
526: ROLLBACK TO insert_fmaconstraints;
527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
528: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
529: ,p_count => x_msg_count
530: ,p_data => x_msg_data);
531:
532: WHEN OTHERS THEN

Line 535: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

531:
532: WHEN OTHERS THEN
533: FND_MSG_PUB.ADD_EXC_MSG('OKL_fmaconstraints_PUB','insert_fmaconstraints');
534: -- store SQL error message on message stack for caller
535: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
536: ,p_count => x_msg_count
537: ,p_data => x_msg_data);
538: -- notify caller of an UNEXPECTED error
539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 622: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

618: WHEN FND_API.G_EXC_ERROR THEN
619: ROLLBACK TO update_fmaconstraints;
620: x_return_status := FND_API.G_RET_STS_ERROR;
621:
622: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
623: ,p_count => x_msg_count
624: ,p_data => x_msg_data);
625:
626: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 629: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

625:
626: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
627: ROLLBACK TO update_fmaconstraints;
628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
629: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
630: ,p_count => x_msg_count
631: ,p_data => x_msg_data);
632:
633: WHEN OTHERS THEN

Line 636: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

632:
633: WHEN OTHERS THEN
634: FND_MSG_PUB.ADD_EXC_MSG('OKL_fmaconstraints_PUB','update_fmaconstraints');
635: -- store SQL error message on message stack for caller
636: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
637: ,p_count => x_msg_count
638: ,p_data => x_msg_data);
639: -- notify caller of an UNEXPECTED error
640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;