APPS.OKE_FUNDING_PUB dependencies on OKE_API

Line 47: OKE_API.set_message(p_app_name => G_APP_NAME ,

43: CLOSE c_exist;
44:
45: EXCEPTION
46: WHEN OTHERS THEN
47: OKE_API.set_message(p_app_name => G_APP_NAME ,
48: p_msg_name => G_UNEXPECTED_ERROR ,
49: p_token1 => G_SQLCODE_TOKEN ,
50: p_token1_value => SQLCODE ,
51: p_token2 => G_SQLERRM_TOKEN ,

Line 59: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

55: IF (c_exist%ISOPEN) THEN
56: CLOSE c_exist;
57: END IF;
58:
59: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
60:
61: END check_update_add_pa;
62:
63:

Line 100: OKE_API.set_message(p_app_name => G_APP_NAME ,

96: CLOSE c_update;
97:
98: EXCEPTION
99: WHEN OTHERS THEN
100: OKE_API.set_message(p_app_name => G_APP_NAME ,
101: p_msg_name => G_UNEXPECTED_ERROR ,
102: p_token1 => G_SQLCODE_TOKEN ,
103: p_token1_value => SQLCODE ,
104: p_token2 => G_SQLERRM_TOKEN ,

Line 112: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

108: IF (c_update%ISOPEN) THEN
109: CLOSE c_update;
110: END IF;
111:
112: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
113:
114: END check_update_add;
115:
116:

Line 140: (p_agreement_id = OKE_API.G_MISS_NUM) THEN

136:
137: BEGIN
138:
139: IF (p_agreement_id is null) OR
140: (p_agreement_id = OKE_API.G_MISS_NUM) THEN
141:
142: OKE_API.set_message(p_app_name => G_APP_NAME ,
143: p_msg_name => 'OKE_API_MISSING_VALUE' ,
144: p_token1 => 'VALUE' ,

Line 142: OKE_API.set_message(p_app_name => G_APP_NAME ,

138:
139: IF (p_agreement_id is null) OR
140: (p_agreement_id = OKE_API.G_MISS_NUM) THEN
141:
142: OKE_API.set_message(p_app_name => G_APP_NAME ,
143: p_msg_name => 'OKE_API_MISSING_VALUE' ,
144: p_token1 => 'VALUE' ,
145: p_token1_value => 'agreement_id'
146: );

Line 143: p_msg_name => 'OKE_API_MISSING_VALUE' ,

139: IF (p_agreement_id is null) OR
140: (p_agreement_id = OKE_API.G_MISS_NUM) THEN
141:
142: OKE_API.set_message(p_app_name => G_APP_NAME ,
143: p_msg_name => 'OKE_API_MISSING_VALUE' ,
144: p_token1 => 'VALUE' ,
145: p_token1_value => 'agreement_id'
146: );
147:

Line 148: RAISE OKE_API.G_EXCEPTION_ERROR;

144: p_token1 => 'VALUE' ,
145: p_token1_value => 'agreement_id'
146: );
147:
148: RAISE OKE_API.G_EXCEPTION_ERROR;
149:
150: END IF;
151:
152: OPEN c_agreement((LENGTH(p_funding_source_id) + 1));

Line 158: OKE_API.set_message(p_app_name => G_APP_NAME ,

154: CLOSE c_agreement;
155:
156: IF (l_dummy_value = '?') THEN
157:
158: OKE_API.set_message(p_app_name => G_APP_NAME ,
159: p_msg_name => 'OKE_API_INVALID_VALUE' ,
160: p_token1 => 'VALUE' ,
161: p_token1_value => 'agreement_id'
162: );

Line 159: p_msg_name => 'OKE_API_INVALID_VALUE' ,

155:
156: IF (l_dummy_value = '?') THEN
157:
158: OKE_API.set_message(p_app_name => G_APP_NAME ,
159: p_msg_name => 'OKE_API_INVALID_VALUE' ,
160: p_token1 => 'VALUE' ,
161: p_token1_value => 'agreement_id'
162: );
163:

Line 164: RAISE OKE_API.G_EXCEPTION_ERROR;

160: p_token1 => 'VALUE' ,
161: p_token1_value => 'agreement_id'
162: );
163:
164: RAISE OKE_API.G_EXCEPTION_ERROR;
165:
166: END IF;
167:
168: EXCEPTION

Line 170: OKE_API.set_message(p_app_name => G_APP_NAME ,

166: END IF;
167:
168: EXCEPTION
169: WHEN OTHERS THEN
170: OKE_API.set_message(p_app_name => G_APP_NAME ,
171: p_msg_name => G_UNEXPECTED_ERROR ,
172: p_token1 => G_SQLCODE_TOKEN ,
173: p_token1_value => SQLCODE ,
174: p_token2 => G_SQLERRM_TOKEN ,

Line 182: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

178: IF (c_agreement%ISOPEN) THEN
179: CLOSE c_agreement;
180: END IF;
181:
182: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
183:
184: END validate_agreement_id;
185:
186:

Line 231: OKE_API.set_message(p_app_name => G_APP_NAME ,

227: RETURN (l_allocation_in_rec);
228:
229: EXCEPTION
230: WHEN OTHERS THEN
231: OKE_API.set_message(p_app_name => G_APP_NAME ,
232: p_msg_name => G_UNEXPECTED_ERROR ,
233: p_token1 => G_SQLCODE_TOKEN ,
234: p_token1_value => SQLCODE ,
235: p_token2 => G_SQLERRM_TOKEN ,

Line 243: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

239: IF (c_allocation%ISOPEN) THEN
240: CLOSE c_allocation;
241: END IF;
242:
243: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
244:
245: END get_record;
246:
247:

Line 262: -- Calling subprograms: OKE_API.start_activity

258: -- Procedure: create_pa_oke_funding
259: --
260: -- Description: This procedure is used to create contract funding and pa agreement
261: --
262: -- Calling subprograms: OKE_API.start_activity
263: -- OKE_API.end_activity
264: -- OKE_FUNDSOURCE_PVT.fetch_create_funding
265: --
266:

Line 263: -- OKE_API.end_activity

259: --
260: -- Description: This procedure is used to create contract funding and pa agreement
261: --
262: -- Calling subprograms: OKE_API.start_activity
263: -- OKE_API.end_activity
264: -- OKE_FUNDSOURCE_PVT.fetch_create_funding
265: --
266:
267: PROCEDURE create_pa_oke_funding(p_api_version IN NUMBER ,

Line 268: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,

264: -- OKE_FUNDSOURCE_PVT.fetch_create_funding
265: --
266:
267: PROCEDURE create_pa_oke_funding(p_api_version IN NUMBER ,
268: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
269: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
270: x_return_status OUT NOCOPY VARCHAR2 ,
271: x_msg_count OUT NOCOPY NUMBER ,
272: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 269: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,

265: --
266:
267: PROCEDURE create_pa_oke_funding(p_api_version IN NUMBER ,
268: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
269: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
270: x_return_status OUT NOCOPY VARCHAR2 ,
271: x_msg_count OUT NOCOPY NUMBER ,
272: x_msg_data OUT NOCOPY VARCHAR2 ,
273: x_funding_source_id OUT NOCOPY NUMBER ,

Line 292: x_return_status := OKE_API.G_RET_STS_SUCCESS;

288: l_return_status VARCHAR2(1);
289:
290: BEGIN
291:
292: x_return_status := OKE_API.G_RET_STS_SUCCESS;
293:
294: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,
295: p_pkg_name => G_PKG_NAME ,
296: p_init_msg_list => p_init_msg_list ,

Line 294: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,

290: BEGIN
291:
292: x_return_status := OKE_API.G_RET_STS_SUCCESS;
293:
294: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,
295: p_pkg_name => G_PKG_NAME ,
296: p_init_msg_list => p_init_msg_list ,
297: l_api_version => G_API_VERSION_NUMBER ,
298: p_api_version => p_api_version ,

Line 303: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

299: p_api_type => '_PUB' ,
300: x_return_status => x_return_status
301: );
302:
303: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
304:
305: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
306:
307: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 305: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

301: );
302:
303: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
304:
305: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
306:
307: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
308:
309: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 307: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN

303: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
304:
305: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
306:
307: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
308:
309: RAISE OKE_API.G_EXCEPTION_ERROR;
310:
311: END IF;

Line 309: RAISE OKE_API.G_EXCEPTION_ERROR;

305: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
306:
307: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
308:
309: RAISE OKE_API.G_EXCEPTION_ERROR;
310:
311: END IF;
312:
313: OKE_FUNDSOURCE_PVT.fetch_create_funding(p_init_msg_list => OKE_API.G_FALSE ,

Line 313: OKE_FUNDSOURCE_PVT.fetch_create_funding(p_init_msg_list => OKE_API.G_FALSE ,

309: RAISE OKE_API.G_EXCEPTION_ERROR;
310:
311: END IF;
312:
313: OKE_FUNDSOURCE_PVT.fetch_create_funding(p_init_msg_list => OKE_API.G_FALSE ,
314: p_api_version => p_api_version ,
315: p_msg_count => x_msg_count ,
316: p_msg_data => x_msg_data ,
317: p_commit => OKE_API.G_FALSE ,

Line 317: p_commit => OKE_API.G_FALSE ,

313: OKE_FUNDSOURCE_PVT.fetch_create_funding(p_init_msg_list => OKE_API.G_FALSE ,
314: p_api_version => p_api_version ,
315: p_msg_count => x_msg_count ,
316: p_msg_data => x_msg_data ,
317: p_commit => OKE_API.G_FALSE ,
318: p_pool_party_id => p_pool_party_id ,
319: p_party_id => p_party_id ,
320: --p_source_currency => p_source_currency ,
321: p_agreement_id => p_agreement_id ,

Line 333: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

329: p_funding_source_id => x_funding_source_id ,
330: p_return_status => x_return_status
331: );
332:
333: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
334:
335: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
336:
337: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 335: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

331: );
332:
333: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
334:
335: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
336:
337: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN
338:
339: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 337: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN

333: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
334:
335: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
336:
337: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN
338:
339: RAISE OKE_API.G_EXCEPTION_ERROR;
340:
341: END IF;

Line 339: RAISE OKE_API.G_EXCEPTION_ERROR;

335: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
336:
337: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN
338:
339: RAISE OKE_API.G_EXCEPTION_ERROR;
340:
341: END IF;
342:
343: IF FND_API.to_boolean(p_commit) THEN

Line 349: OKE_API.END_ACTIVITY(x_msg_count => x_msg_count ,

345: COMMIT WORK;
346:
347: END IF;
348:
349: OKE_API.END_ACTIVITY(x_msg_count => x_msg_count ,
350: x_msg_data => x_msg_data
351: );
352:
353: EXCEPTION

Line 354: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN

350: x_msg_data => x_msg_data
351: );
352:
353: EXCEPTION
354: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
355: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
356: p_pkg_name => G_PKG_NAME ,
357: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
358: x_msg_count => x_msg_count ,

Line 355: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,

351: );
352:
353: EXCEPTION
354: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
355: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
356: p_pkg_name => G_PKG_NAME ,
357: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
358: x_msg_count => x_msg_count ,
359: x_msg_data => x_msg_data ,

Line 357: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,

353: EXCEPTION
354: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
355: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
356: p_pkg_name => G_PKG_NAME ,
357: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
358: x_msg_count => x_msg_count ,
359: x_msg_data => x_msg_data ,
360: p_api_type => '_PUB'
361: );

Line 363: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

359: x_msg_data => x_msg_data ,
360: p_api_type => '_PUB'
361: );
362:
363: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
364: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
365: p_pkg_name => G_PKG_NAME ,
366: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,
367: x_msg_count => x_msg_count ,

Line 364: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,

360: p_api_type => '_PUB'
361: );
362:
363: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
364: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
365: p_pkg_name => G_PKG_NAME ,
366: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,
367: x_msg_count => x_msg_count ,
368: x_msg_data => x_msg_data ,

Line 366: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,

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

Line 373: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,

369: p_api_type => '_PUB'
370: );
371:
372: WHEN OTHERS THEN
373: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
374: p_pkg_name => G_PKG_NAME ,
375: p_exc_name => 'OTHERS' ,
376: x_msg_count => x_msg_count ,
377: x_msg_data => x_msg_data ,

Line 389: -- Calling subprograms: OKE_API.start_activity

385: -- Procedure: create_funding
386: --
387: -- Description: This procedure is used to create contract funding and pa agreement
388: --
389: -- Calling subprograms: OKE_API.start_activity
390: -- OKE_API.end_activity
391: -- OKE_FUNDSOURCE_PVT.create_funding
392: -- OKE_ALLOCATION_PVT.add_allocation
393: -- OKE_FUNDSOURCE_PVT.update_funding

Line 390: -- OKE_API.end_activity

386: --
387: -- Description: This procedure is used to create contract funding and pa agreement
388: --
389: -- Calling subprograms: OKE_API.start_activity
390: -- OKE_API.end_activity
391: -- OKE_FUNDSOURCE_PVT.create_funding
392: -- OKE_ALLOCATION_PVT.add_allocation
393: -- OKE_FUNDSOURCE_PVT.update_funding
394: -- OKE_AGREEMENT_PVT.create_agreement

Line 398: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,

394: -- OKE_AGREEMENT_PVT.create_agreement
395: --
396:
397: PROCEDURE create_funding(p_api_version IN NUMBER ,
398: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
399: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
400: x_return_status OUT NOCOPY VARCHAR2 ,
401: x_msg_count OUT NOCOPY NUMBER ,
402: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 399: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,

395: --
396:
397: PROCEDURE create_funding(p_api_version IN NUMBER ,
398: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
399: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
400: x_return_status OUT NOCOPY VARCHAR2 ,
401: x_msg_count OUT NOCOPY NUMBER ,
402: x_msg_data OUT NOCOPY VARCHAR2 ,
403: p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE ,

Line 403: p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE ,

399: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
400: x_return_status OUT NOCOPY VARCHAR2 ,
401: x_msg_count OUT NOCOPY NUMBER ,
402: x_msg_data OUT NOCOPY VARCHAR2 ,
403: p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE ,
404: p_agreement_type IN VARCHAR2 ,
405: p_receivables_term_id IN NUMBER DEFAULT NULL, /*skuchima 14344021 */
406: p_funding_in_rec IN FUNDING_REC_IN_TYPE ,
407: x_funding_out_rec OUT NOCOPY FUNDING_REC_OUT_TYPE ,

Line 424: x_return_status := OKE_API.G_RET_STS_SUCCESS;

420:
421: --dbms_output.put_line('entering oke_funding_pub.create_funding');
422: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'entering oke_funding_pub.create_funding');
423:
424: x_return_status := OKE_API.G_RET_STS_SUCCESS;
425: x_funding_out_rec.return_status := OKE_API.G_RET_STS_SUCCESS;
426:
427: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,
428: p_pkg_name => G_PKG_NAME ,

Line 425: x_funding_out_rec.return_status := OKE_API.G_RET_STS_SUCCESS;

421: --dbms_output.put_line('entering oke_funding_pub.create_funding');
422: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'entering oke_funding_pub.create_funding');
423:
424: x_return_status := OKE_API.G_RET_STS_SUCCESS;
425: x_funding_out_rec.return_status := OKE_API.G_RET_STS_SUCCESS;
426:
427: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,
428: p_pkg_name => G_PKG_NAME ,
429: p_init_msg_list => p_init_msg_list ,

Line 427: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,

423:
424: x_return_status := OKE_API.G_RET_STS_SUCCESS;
425: x_funding_out_rec.return_status := OKE_API.G_RET_STS_SUCCESS;
426:
427: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,
428: p_pkg_name => G_PKG_NAME ,
429: p_init_msg_list => p_init_msg_list ,
430: l_api_version => G_API_VERSION_NUMBER ,
431: p_api_version => p_api_version ,

Line 436: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

432: p_api_type => '_PUB' ,
433: x_return_status => x_return_status
434: );
435:
436: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
437:
438: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
439:
440: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 438: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

434: );
435:
436: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
437:
438: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
439:
440: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
441:
442: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 440: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN

436: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
437:
438: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
439:
440: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
441:
442: RAISE OKE_API.G_EXCEPTION_ERROR;
443:
444: END IF;

Line 442: RAISE OKE_API.G_EXCEPTION_ERROR;

438: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
439:
440: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
441:
442: RAISE OKE_API.G_EXCEPTION_ERROR;
443:
444: END IF;
445:
446: --

Line 454: p_init_msg_list => OKE_API.G_FALSE ,

450: --dbms_output.put_line('calling oke_fundsource_pvt.create_funding from oke_funding_pub');
451: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_fundsource_pvt.create_funding from oke_funding_pub');
452:
453: OKE_FUNDSOURCE_PVT.create_funding(p_api_version => p_api_version ,
454: p_init_msg_list => OKE_API.G_FALSE ,
455: p_commit => OKE_API.G_FALSE ,
456: p_msg_count => x_msg_count ,
457: p_msg_data => x_msg_data ,
458: p_funding_in_rec => p_funding_in_rec ,

Line 455: p_commit => OKE_API.G_FALSE ,

451: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_fundsource_pvt.create_funding from oke_funding_pub');
452:
453: OKE_FUNDSOURCE_PVT.create_funding(p_api_version => p_api_version ,
454: p_init_msg_list => OKE_API.G_FALSE ,
455: p_commit => OKE_API.G_FALSE ,
456: p_msg_count => x_msg_count ,
457: p_msg_data => x_msg_data ,
458: p_funding_in_rec => p_funding_in_rec ,
459: p_funding_out_rec => x_funding_out_rec ,

Line 463: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

459: p_funding_out_rec => x_funding_out_rec ,
460: p_return_status => x_return_status
461: );
462:
463: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
464:
465: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
466:
467: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 465: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

461: );
462:
463: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
464:
465: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
466:
467: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN
468:
469: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 467: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN

463: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
464:
465: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
466:
467: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN
468:
469: RAISE OKE_API.G_EXCEPTION_ERROR;
470:
471: END IF;

Line 469: RAISE OKE_API.G_EXCEPTION_ERROR;

465: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
466:
467: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN
468:
469: RAISE OKE_API.G_EXCEPTION_ERROR;
470:
471: END IF;
472:
473: l_funding_in_rec := p_funding_in_rec;

Line 493: p_init_msg_list => OKE_API.G_FALSE ,

489: l_allocation_in_rec := p_allocation_in_tbl(i);
490: l_allocation_in_rec.funding_source_id := x_funding_out_rec.funding_source_id;
491:
492: OKE_ALLOCATION_PVT.add_allocation(p_api_version => p_api_version ,
493: p_init_msg_list => OKE_API.G_FALSE ,
494: p_commit => OKE_API.G_FALSE ,
495: p_return_status => x_return_status ,
496: p_msg_count => x_msg_count ,
497: p_msg_data => x_msg_data ,

Line 494: p_commit => OKE_API.G_FALSE ,

490: l_allocation_in_rec.funding_source_id := x_funding_out_rec.funding_source_id;
491:
492: OKE_ALLOCATION_PVT.add_allocation(p_api_version => p_api_version ,
493: p_init_msg_list => OKE_API.G_FALSE ,
494: p_commit => OKE_API.G_FALSE ,
495: p_return_status => x_return_status ,
496: p_msg_count => x_msg_count ,
497: p_msg_data => x_msg_data ,
498: p_allocation_in_rec => l_allocation_in_rec ,

Line 500: p_validation_flag => OKE_API.G_FALSE

496: p_msg_count => x_msg_count ,
497: p_msg_data => x_msg_data ,
498: p_allocation_in_rec => l_allocation_in_rec ,
499: p_allocation_out_rec => l_allocation_out_rec ,
500: p_validation_flag => OKE_API.G_FALSE
501: );
502:
503: x_allocation_out_tbl(i) := l_allocation_out_rec;
504:

Line 505: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

501: );
502:
503: x_allocation_out_tbl(i) := l_allocation_out_rec;
504:
505: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
506:
507: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
508:
509: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 507: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

503: x_allocation_out_tbl(i) := l_allocation_out_rec;
504:
505: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
506:
507: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
508:
509: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN
510:
511: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 509: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN

505: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
506:
507: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
508:
509: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN
510:
511: RAISE OKE_API.G_EXCEPTION_ERROR;
512:
513: END IF;

Line 511: RAISE OKE_API.G_EXCEPTION_ERROR;

507: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
508:
509: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN
510:
511: RAISE OKE_API.G_EXCEPTION_ERROR;
512:
513: END IF;
514:
515: EXIT WHEN (i = p_allocation_in_tbl.LAST);

Line 527: p_init_msg_list => OKE_API.G_FALSE ,

523: -- Call OKE_FUNDSOURCE_PVT.update_funding to validate the entire funding record
524: --
525:
526: OKE_FUNDSOURCE_PVT.update_funding(p_api_version => p_api_version ,
527: p_init_msg_list => OKE_API.G_FALSE ,
528: p_commit => OKE_API.G_FALSE ,
529: p_msg_count => x_msg_count ,
530: p_msg_data => x_msg_data ,
531: p_funding_in_rec => l_funding_in_rec ,

Line 528: p_commit => OKE_API.G_FALSE ,

524: --
525:
526: OKE_FUNDSOURCE_PVT.update_funding(p_api_version => p_api_version ,
527: p_init_msg_list => OKE_API.G_FALSE ,
528: p_commit => OKE_API.G_FALSE ,
529: p_msg_count => x_msg_count ,
530: p_msg_data => x_msg_data ,
531: p_funding_in_rec => l_funding_in_rec ,
532: p_funding_out_rec => x_funding_out_rec ,

Line 536: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

532: p_funding_out_rec => x_funding_out_rec ,
533: p_return_status => x_return_status
534: );
535:
536: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
537:
538: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
539:
540: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 538: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

534: );
535:
536: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
537:
538: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
539:
540: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN
541:
542: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 540: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN

536: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
537:
538: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
539:
540: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN
541:
542: RAISE OKE_API.G_EXCEPTION_ERROR;
543:
544: END IF;

Line 542: RAISE OKE_API.G_EXCEPTION_ERROR;

538: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
539:
540: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN
541:
542: RAISE OKE_API.G_EXCEPTION_ERROR;
543:
544: END IF;
545:
546: --

Line 556: p_init_msg_list => OKE_API.G_FALSE ,

552: --dbms_output.put_line('calling oke_agreement_pvt.create_agreement');
553: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_agreement_pvt.create_agreement');
554:
555: OKE_AGREEMENT_PVT.create_agreement(p_api_version => G_API_VERSION_NUMBER ,
556: p_init_msg_list => OKE_API.G_FALSE ,
557: p_commit => OKE_API.G_FALSE ,
558: p_msg_count => x_msg_count ,
559: p_msg_data => x_msg_data ,
560: p_agreement_type => p_agreement_type ,

Line 557: p_commit => OKE_API.G_FALSE ,

553: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_agreement_pvt.create_agreement');
554:
555: OKE_AGREEMENT_PVT.create_agreement(p_api_version => G_API_VERSION_NUMBER ,
556: p_init_msg_list => OKE_API.G_FALSE ,
557: p_commit => OKE_API.G_FALSE ,
558: p_msg_count => x_msg_count ,
559: p_msg_data => x_msg_data ,
560: p_agreement_type => p_agreement_type ,
561: p_funding_in_rec => l_funding_in_rec ,

Line 567: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

563: p_return_status => x_return_status ,
564: p_receivables_term_id => p_receivables_term_id
565: );
566:
567: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
568:
569: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
570:
571: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 569: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

565: );
566:
567: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
568:
569: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
570:
571: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN
572:
573: RAISE OKE_API.G_EXCEPTION_ERROR;

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

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

Line 573: RAISE OKE_API.G_EXCEPTION_ERROR;

569: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
570:
571: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN
572:
573: RAISE OKE_API.G_EXCEPTION_ERROR;
574:
575: END IF;
576:
577: END IF;

Line 588: OKE_API.END_ACTIVITY(x_msg_count => x_msg_count ,

584:
585: --dbms_output.put_line('finished oke_funding_pub.create_funding w/ ' || x_return_status);
586: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'finished oke_funding_pub.create_funding w/ ' || x_return_status);
587:
588: OKE_API.END_ACTIVITY(x_msg_count => x_msg_count ,
589: x_msg_data => x_msg_data
590: );
591:
592: EXCEPTION

Line 593: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN

589: x_msg_data => x_msg_data
590: );
591:
592: EXCEPTION
593: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
594: x_funding_out_rec.return_status := OKE_API.G_RET_STS_ERROR;
595: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
596: p_pkg_name => G_PKG_NAME ,
597: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,

Line 594: x_funding_out_rec.return_status := OKE_API.G_RET_STS_ERROR;

590: );
591:
592: EXCEPTION
593: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
594: x_funding_out_rec.return_status := OKE_API.G_RET_STS_ERROR;
595: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
596: p_pkg_name => G_PKG_NAME ,
597: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
598: x_msg_count => x_msg_count ,

Line 595: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,

591:
592: EXCEPTION
593: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
594: x_funding_out_rec.return_status := OKE_API.G_RET_STS_ERROR;
595: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
596: p_pkg_name => G_PKG_NAME ,
597: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
598: x_msg_count => x_msg_count ,
599: x_msg_data => x_msg_data ,

Line 597: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,

593: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
594: x_funding_out_rec.return_status := OKE_API.G_RET_STS_ERROR;
595: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
596: p_pkg_name => G_PKG_NAME ,
597: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
598: x_msg_count => x_msg_count ,
599: x_msg_data => x_msg_data ,
600: p_api_type => '_PUB'
601: );

Line 603: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

599: x_msg_data => x_msg_data ,
600: p_api_type => '_PUB'
601: );
602:
603: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
604: x_funding_out_rec.return_status := OKE_API.G_RET_STS_UNEXP_ERROR;
605: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
606: p_pkg_name => G_PKG_NAME ,
607: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,

Line 604: x_funding_out_rec.return_status := OKE_API.G_RET_STS_UNEXP_ERROR;

600: p_api_type => '_PUB'
601: );
602:
603: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
604: x_funding_out_rec.return_status := OKE_API.G_RET_STS_UNEXP_ERROR;
605: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
606: p_pkg_name => G_PKG_NAME ,
607: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,
608: x_msg_count => x_msg_count ,

Line 605: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,

601: );
602:
603: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
604: x_funding_out_rec.return_status := OKE_API.G_RET_STS_UNEXP_ERROR;
605: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
606: p_pkg_name => G_PKG_NAME ,
607: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,
608: x_msg_count => x_msg_count ,
609: x_msg_data => x_msg_data ,

Line 607: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,

603: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
604: x_funding_out_rec.return_status := OKE_API.G_RET_STS_UNEXP_ERROR;
605: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
606: p_pkg_name => G_PKG_NAME ,
607: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,
608: x_msg_count => x_msg_count ,
609: x_msg_data => x_msg_data ,
610: p_api_type => '_PUB'
611: );

Line 614: x_funding_out_rec.return_status := OKE_API.G_RET_STS_UNEXP_ERROR;

610: p_api_type => '_PUB'
611: );
612:
613: WHEN OTHERS THEN
614: x_funding_out_rec.return_status := OKE_API.G_RET_STS_UNEXP_ERROR;
615: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
616: p_pkg_name => G_PKG_NAME ,
617: p_exc_name => 'OTHERS' ,
618: x_msg_count => x_msg_count ,

Line 615: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,

611: );
612:
613: WHEN OTHERS THEN
614: x_funding_out_rec.return_status := OKE_API.G_RET_STS_UNEXP_ERROR;
615: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
616: p_pkg_name => G_PKG_NAME ,
617: p_exc_name => 'OTHERS' ,
618: x_msg_count => x_msg_count ,
619: x_msg_data => x_msg_data ,

Line 631: -- Calling subprograms: OKE_API.start_activity

627: -- Procedure: update_funding
628: --
629: -- Description: This procedure is used to update contract funding and pa agreement
630: --
631: -- Calling subprograms: OKE_API.start_activity
632: -- OKE_API.end_activity
633: -- OKE_FUNDSOURCE_PVT.update_funding
634: -- OKE_API.set_message
635: -- OKE_AGREEMENT_PVT.update_agreement

Line 632: -- OKE_API.end_activity

628: --
629: -- Description: This procedure is used to update contract funding and pa agreement
630: --
631: -- Calling subprograms: OKE_API.start_activity
632: -- OKE_API.end_activity
633: -- OKE_FUNDSOURCE_PVT.update_funding
634: -- OKE_API.set_message
635: -- OKE_AGREEMENT_PVT.update_agreement
636: -- OKE_AGREEMENT_PVT.create_agreement

Line 634: -- OKE_API.set_message

630: --
631: -- Calling subprograms: OKE_API.start_activity
632: -- OKE_API.end_activity
633: -- OKE_FUNDSOURCE_PVT.update_funding
634: -- OKE_API.set_message
635: -- OKE_AGREEMENT_PVT.update_agreement
636: -- OKE_AGREEMENT_PVT.create_agreement
637: -- OKE_FUNDING_UTIL_PKG.check_agreement_exist
638: -- check_update_add

Line 644: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,

640: -- OKE_ALLOCATION_PVT.update_allocation
641: --
642:
643: PROCEDURE update_funding(p_api_version IN NUMBER ,
644: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
645: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
646: x_return_status OUT NOCOPY VARCHAR2 ,
647: x_msg_count OUT NOCOPY NUMBER ,
648: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 645: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,

641: --
642:
643: PROCEDURE update_funding(p_api_version IN NUMBER ,
644: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
645: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
646: x_return_status OUT NOCOPY VARCHAR2 ,
647: x_msg_count OUT NOCOPY NUMBER ,
648: x_msg_data OUT NOCOPY VARCHAR2 ,
649: p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE ,

Line 649: p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE ,

645: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
646: x_return_status OUT NOCOPY VARCHAR2 ,
647: x_msg_count OUT NOCOPY NUMBER ,
648: x_msg_data OUT NOCOPY VARCHAR2 ,
649: p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE ,
650: p_agreement_type IN VARCHAR2 ,
651: p_receivables_term_id IN NUMBER DEFAULT NULL,
652: p_funding_in_rec IN FUNDING_REC_IN_TYPE ,
653: x_funding_out_rec OUT NOCOPY FUNDING_REC_OUT_TYPE ,

Line 677: x_funding_out_rec.return_status := OKE_API.G_RET_STS_SUCCESS;

673: --dbms_output.put_line('entering oke_funding_pub.update_funding');
674: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'entering oke_funding_pub.update_funding');
675:
676: x_return_status := FND_API.G_RET_STS_SUCCESS;
677: x_funding_out_rec.return_status := OKE_API.G_RET_STS_SUCCESS;
678:
679: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,
680: p_pkg_name => G_PKG_NAME ,
681: p_init_msg_list => p_init_msg_list ,

Line 679: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,

675:
676: x_return_status := FND_API.G_RET_STS_SUCCESS;
677: x_funding_out_rec.return_status := OKE_API.G_RET_STS_SUCCESS;
678:
679: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,
680: p_pkg_name => G_PKG_NAME ,
681: p_init_msg_list => p_init_msg_list ,
682: l_api_version => G_API_VERSION_NUMBER ,
683: p_api_version => p_api_version ,

Line 688: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

684: p_api_type => '_PUB' ,
685: x_return_status => x_return_status
686: );
687:
688: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
689:
690: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
691:
692: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 690: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

686: );
687:
688: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
689:
690: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
691:
692: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
693:
694: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 692: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN

688: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
689:
690: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
691:
692: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
693:
694: RAISE OKE_API.G_EXCEPTION_ERROR;
695:
696: END IF;

Line 694: RAISE OKE_API.G_EXCEPTION_ERROR;

690: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
691:
692: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
693:
694: RAISE OKE_API.G_EXCEPTION_ERROR;
695:
696: END IF;
697:
698: --

Line 719: OKE_API.set_message(p_app_name => G_APP_NAME ,

715: --
716:
717: IF (l_allocation_in_rec.funding_source_id <> p_funding_in_rec.funding_source_id) THEN
718:
719: OKE_API.set_message(p_app_name => G_APP_NAME ,
720: p_msg_name => 'OKE_API_INVALID_VALUE' ,
721: p_token1 => 'VALUE' ,
722: p_token1_value => 'allocation.funding_source_id'
723: );

Line 720: p_msg_name => 'OKE_API_INVALID_VALUE' ,

716:
717: IF (l_allocation_in_rec.funding_source_id <> p_funding_in_rec.funding_source_id) THEN
718:
719: OKE_API.set_message(p_app_name => G_APP_NAME ,
720: p_msg_name => 'OKE_API_INVALID_VALUE' ,
721: p_token1 => 'VALUE' ,
722: p_token1_value => 'allocation.funding_source_id'
723: );
724:

Line 732: p_init_msg_list => OKE_API.G_FALSE ,

728:
729: IF (check_update_add(p_fund_allocation_id => l_allocation_in_rec.fund_allocation_id)) THEN
730:
731: OKE_ALLOCATION_PVT.update_allocation(p_api_version => p_api_version ,
732: p_init_msg_list => OKE_API.G_FALSE ,
733: p_commit => OKE_API.G_FALSE ,
734: p_return_status => x_return_status ,
735: p_msg_count => x_msg_count ,
736: p_msg_data => x_msg_data ,

Line 733: p_commit => OKE_API.G_FALSE ,

729: IF (check_update_add(p_fund_allocation_id => l_allocation_in_rec.fund_allocation_id)) THEN
730:
731: OKE_ALLOCATION_PVT.update_allocation(p_api_version => p_api_version ,
732: p_init_msg_list => OKE_API.G_FALSE ,
733: p_commit => OKE_API.G_FALSE ,
734: p_return_status => x_return_status ,
735: p_msg_count => x_msg_count ,
736: p_msg_data => x_msg_data ,
737: p_allocation_in_rec => l_allocation_in_rec ,

Line 739: p_validation_flag => OKE_API.G_FALSE

735: p_msg_count => x_msg_count ,
736: p_msg_data => x_msg_data ,
737: p_allocation_in_rec => l_allocation_in_rec ,
738: p_allocation_out_rec => l_allocation_out_rec ,
739: p_validation_flag => OKE_API.G_FALSE
740: );
741:
742: ELSE
743:

Line 745: p_init_msg_list => OKE_API.G_FALSE ,

741:
742: ELSE
743:
744: OKE_ALLOCATION_PVT.add_allocation(p_api_version => p_api_version ,
745: p_init_msg_list => OKE_API.G_FALSE ,
746: p_commit => OKE_API.G_FALSE ,
747: p_return_status => x_return_status ,
748: p_msg_count => x_msg_count ,
749: p_msg_data => x_msg_data ,

Line 746: p_commit => OKE_API.G_FALSE ,

742: ELSE
743:
744: OKE_ALLOCATION_PVT.add_allocation(p_api_version => p_api_version ,
745: p_init_msg_list => OKE_API.G_FALSE ,
746: p_commit => OKE_API.G_FALSE ,
747: p_return_status => x_return_status ,
748: p_msg_count => x_msg_count ,
749: p_msg_data => x_msg_data ,
750: p_validation_flag => OKE_API.G_FALSE ,

Line 750: p_validation_flag => OKE_API.G_FALSE ,

746: p_commit => OKE_API.G_FALSE ,
747: p_return_status => x_return_status ,
748: p_msg_count => x_msg_count ,
749: p_msg_data => x_msg_data ,
750: p_validation_flag => OKE_API.G_FALSE ,
751: p_allocation_in_rec => l_allocation_in_rec ,
752: p_allocation_out_rec => l_allocation_out_rec
753: );
754:

Line 759: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

755: END IF;
756:
757: x_allocation_out_tbl(i) := l_allocation_out_rec;
758:
759: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
760:
761: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
762:
763: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 761: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

757: x_allocation_out_tbl(i) := l_allocation_out_rec;
758:
759: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
760:
761: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
762:
763: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN
764:
765: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 763: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN

759: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
760:
761: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
762:
763: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN
764:
765: RAISE OKE_API.G_EXCEPTION_ERROR;
766:
767: END IF;

Line 765: RAISE OKE_API.G_EXCEPTION_ERROR;

761: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
762:
763: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN
764:
765: RAISE OKE_API.G_EXCEPTION_ERROR;
766:
767: END IF;
768:
769: EXIT WHEN (i = p_allocation_in_tbl.LAST);

Line 784: p_init_msg_list => OKE_API.G_FALSE ,

780: --dbms_output.put_line('calling oke_fundsource_pvt.update_funding');
781: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_fundsource_pvt.update_funding');
782:
783: OKE_FUNDSOURCE_PVT.update_funding(p_api_version => p_api_version ,
784: p_init_msg_list => OKE_API.G_FALSE ,
785: p_commit => OKE_API.G_FALSE ,
786: p_msg_count => x_msg_count ,
787: p_msg_data => x_msg_data ,
788: p_funding_in_rec => p_funding_in_rec ,

Line 785: p_commit => OKE_API.G_FALSE ,

781: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_fundsource_pvt.update_funding');
782:
783: OKE_FUNDSOURCE_PVT.update_funding(p_api_version => p_api_version ,
784: p_init_msg_list => OKE_API.G_FALSE ,
785: p_commit => OKE_API.G_FALSE ,
786: p_msg_count => x_msg_count ,
787: p_msg_data => x_msg_data ,
788: p_funding_in_rec => p_funding_in_rec ,
789: p_funding_out_rec => x_funding_out_rec ,

Line 792: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

788: p_funding_in_rec => p_funding_in_rec ,
789: p_funding_out_rec => x_funding_out_rec ,
790: p_return_status => x_return_status );
791:
792: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
793:
794: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
795:
796: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 794: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

790: p_return_status => x_return_status );
791:
792: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
793:
794: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
795:
796: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN
797:
798: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 796: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN

792: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
793:
794: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
795:
796: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN
797:
798: RAISE OKE_API.G_EXCEPTION_ERROR;
799:
800: END IF;

Line 798: RAISE OKE_API.G_EXCEPTION_ERROR;

794: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
795:
796: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN
797:
798: RAISE OKE_API.G_EXCEPTION_ERROR;
799:
800: END IF;
801:
802: --

Line 821: p_init_msg_list => OKE_API.G_FALSE ,

817: fetch get_term into l_receivables_term_id;
818: close get_term;
819:
820: OKE_AGREEMENT_PVT.update_agreement(p_api_version => p_api_version ,
821: p_init_msg_list => OKE_API.G_FALSE ,
822: p_commit => OKE_API.G_FALSE ,
823: p_msg_count => x_msg_count ,
824: p_msg_data => x_msg_data ,
825: p_agreement_type => p_agreement_type ,

Line 822: p_commit => OKE_API.G_FALSE ,

818: close get_term;
819:
820: OKE_AGREEMENT_PVT.update_agreement(p_api_version => p_api_version ,
821: p_init_msg_list => OKE_API.G_FALSE ,
822: p_commit => OKE_API.G_FALSE ,
823: p_msg_count => x_msg_count ,
824: p_msg_data => x_msg_data ,
825: p_agreement_type => p_agreement_type ,
826: p_funding_in_rec => p_funding_in_rec ,

Line 838: p_init_msg_list => OKE_API.G_FALSE ,

834: --dbms_output.put_line('calling oke_agreement_pvt.create_agreement');
835: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_agreement_pvt.create_agreement');
836:
837: OKE_AGREEMENT_PVT.create_agreement(p_api_version => p_api_version ,
838: p_init_msg_list => OKE_API.G_FALSE ,
839: p_commit => OKE_API.G_FALSE ,
840: p_msg_count => x_msg_count ,
841: p_msg_data => x_msg_data ,
842: p_agreement_type => p_agreement_type ,

Line 839: p_commit => OKE_API.G_FALSE ,

835: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_agreement_pvt.create_agreement');
836:
837: OKE_AGREEMENT_PVT.create_agreement(p_api_version => p_api_version ,
838: p_init_msg_list => OKE_API.G_FALSE ,
839: p_commit => OKE_API.G_FALSE ,
840: p_msg_count => x_msg_count ,
841: p_msg_data => x_msg_data ,
842: p_agreement_type => p_agreement_type ,
843: p_funding_in_rec => p_funding_in_rec ,

Line 851: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

847: );
848:
849: END IF;
850:
851: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
852:
853: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
854:
855: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 853: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

849: END IF;
850:
851: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
852:
853: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
854:
855: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN
856:
857: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 855: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN

851: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
852:
853: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
854:
855: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN
856:
857: RAISE OKE_API.G_EXCEPTION_ERROR;
858:
859: END IF;

Line 857: RAISE OKE_API.G_EXCEPTION_ERROR;

853: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
854:
855: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN
856:
857: RAISE OKE_API.G_EXCEPTION_ERROR;
858:
859: END IF;
860:
861: END IF;

Line 872: OKE_API.END_ACTIVITY(x_msg_count => x_msg_count ,

868:
869: --dbms_output.put_line('finished oke_funding_pub.create_funding w/ ' || x_return_status);
870: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'finished oke_funding_pub.create_funding w/ ' || x_return_status);
871:
872: OKE_API.END_ACTIVITY(x_msg_count => x_msg_count ,
873: x_msg_data => x_msg_data
874: );
875:
876: EXCEPTION

Line 877: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN

873: x_msg_data => x_msg_data
874: );
875:
876: EXCEPTION
877: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
878: x_funding_out_rec.return_status := OKE_API.G_RET_STS_ERROR;
879: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
880: p_pkg_name => G_PKG_NAME ,
881: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,

Line 878: x_funding_out_rec.return_status := OKE_API.G_RET_STS_ERROR;

874: );
875:
876: EXCEPTION
877: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
878: x_funding_out_rec.return_status := OKE_API.G_RET_STS_ERROR;
879: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
880: p_pkg_name => G_PKG_NAME ,
881: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
882: x_msg_count => x_msg_count ,

Line 879: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,

875:
876: EXCEPTION
877: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
878: x_funding_out_rec.return_status := OKE_API.G_RET_STS_ERROR;
879: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
880: p_pkg_name => G_PKG_NAME ,
881: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
882: x_msg_count => x_msg_count ,
883: x_msg_data => x_msg_data ,

Line 881: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,

877: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
878: x_funding_out_rec.return_status := OKE_API.G_RET_STS_ERROR;
879: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
880: p_pkg_name => G_PKG_NAME ,
881: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
882: x_msg_count => x_msg_count ,
883: x_msg_data => x_msg_data ,
884: p_api_type => '_PUB'
885: );

Line 887: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

883: x_msg_data => x_msg_data ,
884: p_api_type => '_PUB'
885: );
886:
887: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
888: x_funding_out_rec.return_status := OKE_API.G_RET_STS_UNEXP_ERROR;
889: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
890: p_pkg_name => G_PKG_NAME ,
891: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,

Line 888: x_funding_out_rec.return_status := OKE_API.G_RET_STS_UNEXP_ERROR;

884: p_api_type => '_PUB'
885: );
886:
887: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
888: x_funding_out_rec.return_status := OKE_API.G_RET_STS_UNEXP_ERROR;
889: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
890: p_pkg_name => G_PKG_NAME ,
891: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,
892: x_msg_count => x_msg_count ,

Line 889: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,

885: );
886:
887: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
888: x_funding_out_rec.return_status := OKE_API.G_RET_STS_UNEXP_ERROR;
889: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
890: p_pkg_name => G_PKG_NAME ,
891: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,
892: x_msg_count => x_msg_count ,
893: x_msg_data => x_msg_data ,

Line 891: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,

887: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
888: x_funding_out_rec.return_status := OKE_API.G_RET_STS_UNEXP_ERROR;
889: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
890: p_pkg_name => G_PKG_NAME ,
891: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,
892: x_msg_count => x_msg_count ,
893: x_msg_data => x_msg_data ,
894: p_api_type => '_PUB'
895: );

Line 898: x_funding_out_rec.return_status := OKE_API.G_RET_STS_UNEXP_ERROR;

894: p_api_type => '_PUB'
895: );
896:
897: WHEN OTHERS THEN
898: x_funding_out_rec.return_status := OKE_API.G_RET_STS_UNEXP_ERROR;
899: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
900: p_pkg_name => G_PKG_NAME ,
901: p_exc_name => 'OTHERS' ,
902: x_msg_count => x_msg_count ,

Line 899: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,

895: );
896:
897: WHEN OTHERS THEN
898: x_funding_out_rec.return_status := OKE_API.G_RET_STS_UNEXP_ERROR;
899: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
900: p_pkg_name => G_PKG_NAME ,
901: p_exc_name => 'OTHERS' ,
902: x_msg_count => x_msg_count ,
903: x_msg_data => x_msg_data ,

Line 914: -- Calling subprograms: OKE_API.start_activity

910: -- Procedure: delete_funding
911: --
912: -- Description: This procedure is used to delete contract funding and pa agreement
913: --
914: -- Calling subprograms: OKE_API.start_activity
915: -- OKE_API.end_activity
916: -- OKE_FUNDSOURCE_PVT.delete_funding
917: -- OKE_FUNDING_PUB.delete_allocation
918: --

Line 915: -- OKE_API.end_activity

911: --
912: -- Description: This procedure is used to delete contract funding and pa agreement
913: --
914: -- Calling subprograms: OKE_API.start_activity
915: -- OKE_API.end_activity
916: -- OKE_FUNDSOURCE_PVT.delete_funding
917: -- OKE_FUNDING_PUB.delete_allocation
918: --
919:

Line 921: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,

917: -- OKE_FUNDING_PUB.delete_allocation
918: --
919:
920: PROCEDURE delete_funding(p_api_version IN NUMBER ,
921: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
922: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
923: x_return_status OUT NOCOPY VARCHAR2 ,
924: x_msg_count OUT NOCOPY NUMBER ,
925: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 922: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,

918: --
919:
920: PROCEDURE delete_funding(p_api_version IN NUMBER ,
921: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
922: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
923: x_return_status OUT NOCOPY VARCHAR2 ,
924: x_msg_count OUT NOCOPY NUMBER ,
925: x_msg_data OUT NOCOPY VARCHAR2 ,
926: p_funding_source_id IN NUMBER

Line 927: -- p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE

923: x_return_status OUT NOCOPY VARCHAR2 ,
924: x_msg_count OUT NOCOPY NUMBER ,
925: x_msg_data OUT NOCOPY VARCHAR2 ,
926: p_funding_source_id IN NUMBER
927: -- p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE
928: ) is
929:
930: -- l_length NUMBER;
931: -- l_temp_val VARCHAR2(1) :='?';

Line 948: x_return_status := OKE_API.G_RET_STS_SUCCESS;

944:
945: --dbms_output.put_line('entering oke_funding_pub.delete_funding');
946: -- --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'entering oke_funding_pub.delete_funding');
947:
948: x_return_status := OKE_API.G_RET_STS_SUCCESS;
949:
950: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,
951: p_pkg_name => G_PKG_NAME ,
952: p_init_msg_list => p_init_msg_list ,

Line 950: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,

946: -- --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'entering oke_funding_pub.delete_funding');
947:
948: x_return_status := OKE_API.G_RET_STS_SUCCESS;
949:
950: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,
951: p_pkg_name => G_PKG_NAME ,
952: p_init_msg_list => p_init_msg_list ,
953: l_api_version => G_API_VERSION_NUMBER ,
954: p_api_version => p_api_version ,

Line 959: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

955: p_api_type => '_PUB' ,
956: x_return_status => x_return_status
957: );
958:
959: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
960:
961: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
962:
963: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 961: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

957: );
958:
959: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
960:
961: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
962:
963: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
964:
965: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 963: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN

959: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
960:
961: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
962:
963: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
964:
965: RAISE OKE_API.G_EXCEPTION_ERROR;
966:
967: END IF;

Line 965: RAISE OKE_API.G_EXCEPTION_ERROR;

961: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
962:
963: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
964:
965: RAISE OKE_API.G_EXCEPTION_ERROR;
966:
967: END IF;
968:
969: --

Line 979: p_init_msg_list => OKE_API.G_FALSE ,

975:
976: FOR l_allocation_id IN c_fund_allocation_id(p_funding_source_id) LOOP
977:
978: OKE_ALLOCATION_PVT.delete_allocation(p_api_version => p_api_version ,
979: p_init_msg_list => OKE_API.G_FALSE ,
980: p_commit => OKE_API.G_FALSE ,
981: p_return_status => x_return_status ,
982: p_msg_count => x_msg_count ,
983: p_msg_data => x_msg_data ,

Line 980: p_commit => OKE_API.G_FALSE ,

976: FOR l_allocation_id IN c_fund_allocation_id(p_funding_source_id) LOOP
977:
978: OKE_ALLOCATION_PVT.delete_allocation(p_api_version => p_api_version ,
979: p_init_msg_list => OKE_API.G_FALSE ,
980: p_commit => OKE_API.G_FALSE ,
981: p_return_status => x_return_status ,
982: p_msg_count => x_msg_count ,
983: p_msg_data => x_msg_data ,
984: p_fund_allocation_id => l_allocation_id.fund_allocation_id

Line 987: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

983: p_msg_data => x_msg_data ,
984: p_fund_allocation_id => l_allocation_id.fund_allocation_id
985: );
986:
987: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
988:
989: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
990:
991: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 989: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

985: );
986:
987: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
988:
989: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
990:
991: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN
992:
993: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 991: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN

987: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
988:
989: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
990:
991: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN
992:
993: RAISE OKE_API.G_EXCEPTION_ERROR;
994:
995: END IF;

Line 993: RAISE OKE_API.G_EXCEPTION_ERROR;

989: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
990:
991: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN
992:
993: RAISE OKE_API.G_EXCEPTION_ERROR;
994:
995: END IF;
996:
997: END LOOP;

Line 1010: p_commit => OKE_API.G_FALSE ,

1006: --dbms_output.put_line('calling oke_fundsource_pvt.delete_funding');
1007: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_fundsource_pvt.delete_funding');
1008:
1009: OKE_FUNDSOURCE_PVT.delete_funding(p_api_version => p_api_version ,
1010: p_commit => OKE_API.G_FALSE ,
1011: p_init_msg_list => OKE_API.G_FALSE ,
1012: p_msg_count => x_msg_count ,
1013: p_msg_data => x_msg_data ,
1014: p_funding_source_id => p_funding_source_id ,

Line 1011: p_init_msg_list => OKE_API.G_FALSE ,

1007: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_fundsource_pvt.delete_funding');
1008:
1009: OKE_FUNDSOURCE_PVT.delete_funding(p_api_version => p_api_version ,
1010: p_commit => OKE_API.G_FALSE ,
1011: p_init_msg_list => OKE_API.G_FALSE ,
1012: p_msg_count => x_msg_count ,
1013: p_msg_data => x_msg_data ,
1014: p_funding_source_id => p_funding_source_id ,
1015: -- p_agreement_flag => p_agreement_flag ,

Line 1019: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

1015: -- p_agreement_flag => p_agreement_flag ,
1016: p_return_status => x_return_status
1017: );
1018:
1019: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1020:
1021: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1022:
1023: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 1021: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1017: );
1018:
1019: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1020:
1021: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1022:
1023: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN
1024:
1025: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 1023: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN

1019: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1020:
1021: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1022:
1023: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN
1024:
1025: RAISE OKE_API.G_EXCEPTION_ERROR;
1026:
1027: END IF;

Line 1025: RAISE OKE_API.G_EXCEPTION_ERROR;

1021: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1022:
1023: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN
1024:
1025: RAISE OKE_API.G_EXCEPTION_ERROR;
1026:
1027: END IF;
1028:
1029: --dbms_output.put_line('finished oke_funding_pub.delete_funding w/ ' || x_return_status);

Line 1038: OKE_API.END_ACTIVITY(x_msg_count => x_msg_count ,

1034: COMMIT WORK;
1035:
1036: END IF;
1037:
1038: OKE_API.END_ACTIVITY(x_msg_count => x_msg_count ,
1039: x_msg_data => x_msg_data
1040: );
1041:
1042: EXCEPTION

Line 1043: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN

1039: x_msg_data => x_msg_data
1040: );
1041:
1042: EXCEPTION
1043: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
1044: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
1045: p_pkg_name => G_PKG_NAME ,
1046: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
1047: x_msg_count => x_msg_count ,

Line 1044: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,

1040: );
1041:
1042: EXCEPTION
1043: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
1044: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
1045: p_pkg_name => G_PKG_NAME ,
1046: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
1047: x_msg_count => x_msg_count ,
1048: x_msg_data => x_msg_data ,

Line 1046: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,

1042: EXCEPTION
1043: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
1044: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
1045: p_pkg_name => G_PKG_NAME ,
1046: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
1047: x_msg_count => x_msg_count ,
1048: x_msg_data => x_msg_data ,
1049: p_api_type => '_PUB'
1050: );

Line 1052: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1048: x_msg_data => x_msg_data ,
1049: p_api_type => '_PUB'
1050: );
1051:
1052: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1053: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
1054: p_pkg_name => G_PKG_NAME ,
1055: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,
1056: x_msg_count => x_msg_count ,

Line 1053: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,

1049: p_api_type => '_PUB'
1050: );
1051:
1052: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1053: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
1054: p_pkg_name => G_PKG_NAME ,
1055: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,
1056: x_msg_count => x_msg_count ,
1057: x_msg_data => x_msg_data ,

Line 1055: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,

1051:
1052: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1053: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
1054: p_pkg_name => G_PKG_NAME ,
1055: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,
1056: x_msg_count => x_msg_count ,
1057: x_msg_data => x_msg_data ,
1058: p_api_type => '_PUB'
1059: );

Line 1062: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,

1058: p_api_type => '_PUB'
1059: );
1060:
1061: WHEN OTHERS THEN
1062: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
1063: p_pkg_name => G_PKG_NAME ,
1064: p_exc_name => 'OTHERS' ,
1065: x_msg_count => x_msg_count ,
1066: x_msg_data => x_msg_data ,

Line 1078: -- Calling subprograms: OKE_API.start_activity

1074: -- Procedure: add_allocation
1075: --
1076: -- Description: This procedure is used to create funding allocation and update/add pa funding
1077: --
1078: -- Calling subprograms: OKE_API.start_activity
1079: -- OKE_API.end_activity
1080: -- OKE_ALLOCATION_PVT.add_allocation
1081: -- OKE_AGREEMENT_PVT.add_pa_funding
1082: --

Line 1079: -- OKE_API.end_activity

1075: --
1076: -- Description: This procedure is used to create funding allocation and update/add pa funding
1077: --
1078: -- Calling subprograms: OKE_API.start_activity
1079: -- OKE_API.end_activity
1080: -- OKE_ALLOCATION_PVT.add_allocation
1081: -- OKE_AGREEMENT_PVT.add_pa_funding
1082: --
1083:

Line 1085: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,

1081: -- OKE_AGREEMENT_PVT.add_pa_funding
1082: --
1083:
1084: PROCEDURE add_allocation(p_api_version IN NUMBER ,
1085: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
1086: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
1087: x_return_status OUT NOCOPY VARCHAR2 ,
1088: x_msg_count OUT NOCOPY NUMBER ,
1089: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 1086: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,

1082: --
1083:
1084: PROCEDURE add_allocation(p_api_version IN NUMBER ,
1085: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
1086: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
1087: x_return_status OUT NOCOPY VARCHAR2 ,
1088: x_msg_count OUT NOCOPY NUMBER ,
1089: x_msg_data OUT NOCOPY VARCHAR2 ,
1090: p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE ,

Line 1090: p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE ,

1086: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
1087: x_return_status OUT NOCOPY VARCHAR2 ,
1088: x_msg_count OUT NOCOPY NUMBER ,
1089: x_msg_data OUT NOCOPY VARCHAR2 ,
1090: p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE ,
1091: p_allocation_in_rec IN ALLOCATION_REC_IN_TYPE ,
1092: x_allocation_out_rec OUT NOCOPY ALLOCATION_REC_OUT_TYPE
1093: ) is
1094:

Line 1104: x_return_status := OKE_API.G_RET_STS_SUCCESS;

1100:
1101: --dbms_output.put_line('entering oke_funding_pub.add_allocation');
1102: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'entering oke_funding_pub.add_allocation');
1103:
1104: x_return_status := OKE_API.G_RET_STS_SUCCESS;
1105: x_allocation_out_rec.return_status := OKE_API.G_RET_STS_SUCCESS;
1106:
1107: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,
1108: p_pkg_name => G_PKG_NAME ,

Line 1105: x_allocation_out_rec.return_status := OKE_API.G_RET_STS_SUCCESS;

1101: --dbms_output.put_line('entering oke_funding_pub.add_allocation');
1102: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'entering oke_funding_pub.add_allocation');
1103:
1104: x_return_status := OKE_API.G_RET_STS_SUCCESS;
1105: x_allocation_out_rec.return_status := OKE_API.G_RET_STS_SUCCESS;
1106:
1107: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,
1108: p_pkg_name => G_PKG_NAME ,
1109: p_init_msg_list => p_init_msg_list ,

Line 1107: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,

1103:
1104: x_return_status := OKE_API.G_RET_STS_SUCCESS;
1105: x_allocation_out_rec.return_status := OKE_API.G_RET_STS_SUCCESS;
1106:
1107: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,
1108: p_pkg_name => G_PKG_NAME ,
1109: p_init_msg_list => p_init_msg_list ,
1110: l_api_version => G_API_VERSION_NUMBER ,
1111: p_api_version => p_api_version ,

Line 1116: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

1112: p_api_type => '_PUB' ,
1113: x_return_status => x_return_status
1114: );
1115:
1116: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1117:
1118: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1119:
1120: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 1118: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1114: );
1115:
1116: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1117:
1118: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1119:
1120: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1121:
1122: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 1120: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN

1116: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1117:
1118: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1119:
1120: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1121:
1122: RAISE OKE_API.G_EXCEPTION_ERROR;
1123:
1124: END IF;

Line 1122: RAISE OKE_API.G_EXCEPTION_ERROR;

1118: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1119:
1120: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1121:
1122: RAISE OKE_API.G_EXCEPTION_ERROR;
1123:
1124: END IF;
1125:
1126: --

Line 1134: p_init_msg_list => OKE_API.G_FALSE ,

1130: --dbms_output.put_line('calling oke_allocation_pvt.add_allocation from oke_funding_pub');
1131: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_allocation_pvt.add_allocation from oke_funding_pub');
1132:
1133: OKE_ALLOCATION_PVT.add_allocation(p_api_version => p_api_version ,
1134: p_init_msg_list => OKE_API.G_FALSE ,
1135: p_commit => OKE_API.G_FALSE ,
1136: p_msg_count => x_msg_count ,
1137: p_msg_data => x_msg_data ,
1138: p_allocation_in_rec => p_allocation_in_rec ,

Line 1135: p_commit => OKE_API.G_FALSE ,

1131: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_allocation_pvt.add_allocation from oke_funding_pub');
1132:
1133: OKE_ALLOCATION_PVT.add_allocation(p_api_version => p_api_version ,
1134: p_init_msg_list => OKE_API.G_FALSE ,
1135: p_commit => OKE_API.G_FALSE ,
1136: p_msg_count => x_msg_count ,
1137: p_msg_data => x_msg_data ,
1138: p_allocation_in_rec => p_allocation_in_rec ,
1139: p_allocation_out_rec => x_allocation_out_rec ,

Line 1140: p_validation_flag => OKE_API.G_TRUE ,

1136: p_msg_count => x_msg_count ,
1137: p_msg_data => x_msg_data ,
1138: p_allocation_in_rec => p_allocation_in_rec ,
1139: p_allocation_out_rec => x_allocation_out_rec ,
1140: p_validation_flag => OKE_API.G_TRUE ,
1141: p_return_status => x_return_status
1142: );
1143:
1144: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1144: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

1140: p_validation_flag => OKE_API.G_TRUE ,
1141: p_return_status => x_return_status
1142: );
1143:
1144: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1145:
1146: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1147:
1148: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 1146: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1142: );
1143:
1144: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1145:
1146: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1147:
1148: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN
1149:
1150: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 1148: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN

1144: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1145:
1146: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1147:
1148: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN
1149:
1150: RAISE OKE_API.G_EXCEPTION_ERROR;
1151:
1152: END IF;

Line 1150: RAISE OKE_API.G_EXCEPTION_ERROR;

1146: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1147:
1148: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN
1149:
1150: RAISE OKE_API.G_EXCEPTION_ERROR;
1151:
1152: END IF;
1153:
1154: --

Line 1182: p_init_msg_list => OKE_API.G_FALSE ,

1178: --dbms_output.put_line('calling oke_agreement_pvt.add_pa_funding from oke_funding_pub');
1179: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_agreement_pvt.add_pa_funding from oke_funding_pub');
1180:
1181: OKE_AGREEMENT_PVT.add_pa_funding(p_api_version => p_api_version ,
1182: p_init_msg_list => OKE_API.G_FALSE ,
1183: p_commit => OKE_API.G_FALSE ,
1184: p_msg_count => x_msg_count ,
1185: p_msg_data => x_msg_data ,
1186: p_allocation_in_rec => l_allocation_in_rec ,

Line 1183: p_commit => OKE_API.G_FALSE ,

1179: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_agreement_pvt.add_pa_funding from oke_funding_pub');
1180:
1181: OKE_AGREEMENT_PVT.add_pa_funding(p_api_version => p_api_version ,
1182: p_init_msg_list => OKE_API.G_FALSE ,
1183: p_commit => OKE_API.G_FALSE ,
1184: p_msg_count => x_msg_count ,
1185: p_msg_data => x_msg_data ,
1186: p_allocation_in_rec => l_allocation_in_rec ,
1187: p_return_status => x_return_status

Line 1190: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

1186: p_allocation_in_rec => l_allocation_in_rec ,
1187: p_return_status => x_return_status
1188: );
1189:
1190: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1191:
1192: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1193:
1194: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 1192: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1188: );
1189:
1190: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1191:
1192: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1193:
1194: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN
1195:
1196: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 1194: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN

1190: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1191:
1192: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1193:
1194: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN
1195:
1196: RAISE OKE_API.G_EXCEPTION_ERROR;
1197:
1198: END IF;

Line 1196: RAISE OKE_API.G_EXCEPTION_ERROR;

1192: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1193:
1194: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN
1195:
1196: RAISE OKE_API.G_EXCEPTION_ERROR;
1197:
1198: END IF;
1199:
1200: END IF;

Line 1211: OKE_API.END_ACTIVITY(x_msg_count => x_msg_count ,

1207: COMMIT WORK;
1208:
1209: END IF;
1210:
1211: OKE_API.END_ACTIVITY(x_msg_count => x_msg_count ,
1212: x_msg_data => x_msg_data
1213: );
1214:
1215: EXCEPTION

Line 1216: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN

1212: x_msg_data => x_msg_data
1213: );
1214:
1215: EXCEPTION
1216: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
1217: x_allocation_out_rec.return_status := OKE_API.G_RET_STS_ERROR;
1218: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
1219: p_pkg_name => G_PKG_NAME ,
1220: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,

Line 1217: x_allocation_out_rec.return_status := OKE_API.G_RET_STS_ERROR;

1213: );
1214:
1215: EXCEPTION
1216: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
1217: x_allocation_out_rec.return_status := OKE_API.G_RET_STS_ERROR;
1218: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
1219: p_pkg_name => G_PKG_NAME ,
1220: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
1221: x_msg_count => x_msg_count ,

Line 1218: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,

1214:
1215: EXCEPTION
1216: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
1217: x_allocation_out_rec.return_status := OKE_API.G_RET_STS_ERROR;
1218: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
1219: p_pkg_name => G_PKG_NAME ,
1220: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
1221: x_msg_count => x_msg_count ,
1222: x_msg_data => x_msg_data ,

Line 1220: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,

1216: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
1217: x_allocation_out_rec.return_status := OKE_API.G_RET_STS_ERROR;
1218: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
1219: p_pkg_name => G_PKG_NAME ,
1220: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
1221: x_msg_count => x_msg_count ,
1222: x_msg_data => x_msg_data ,
1223: p_api_type => '_PUB'
1224: );

Line 1226: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1222: x_msg_data => x_msg_data ,
1223: p_api_type => '_PUB'
1224: );
1225:
1226: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1227: x_allocation_out_rec.return_status := OKE_API.G_RET_STS_UNEXP_ERROR;
1228: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
1229: p_pkg_name => G_PKG_NAME ,
1230: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,

Line 1227: x_allocation_out_rec.return_status := OKE_API.G_RET_STS_UNEXP_ERROR;

1223: p_api_type => '_PUB'
1224: );
1225:
1226: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1227: x_allocation_out_rec.return_status := OKE_API.G_RET_STS_UNEXP_ERROR;
1228: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
1229: p_pkg_name => G_PKG_NAME ,
1230: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,
1231: x_msg_count => x_msg_count ,

Line 1228: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,

1224: );
1225:
1226: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1227: x_allocation_out_rec.return_status := OKE_API.G_RET_STS_UNEXP_ERROR;
1228: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
1229: p_pkg_name => G_PKG_NAME ,
1230: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,
1231: x_msg_count => x_msg_count ,
1232: x_msg_data => x_msg_data ,

Line 1230: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,

1226: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1227: x_allocation_out_rec.return_status := OKE_API.G_RET_STS_UNEXP_ERROR;
1228: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
1229: p_pkg_name => G_PKG_NAME ,
1230: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,
1231: x_msg_count => x_msg_count ,
1232: x_msg_data => x_msg_data ,
1233: p_api_type => '_PUB'
1234: );

Line 1237: x_allocation_out_rec.return_status := OKE_API.G_RET_STS_UNEXP_ERROR;

1233: p_api_type => '_PUB'
1234: );
1235:
1236: WHEN OTHERS THEN
1237: x_allocation_out_rec.return_status := OKE_API.G_RET_STS_UNEXP_ERROR;
1238: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
1239: p_pkg_name => G_PKG_NAME ,
1240: p_exc_name => 'OTHERS' ,
1241: x_msg_count => x_msg_count ,

Line 1238: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,

1234: );
1235:
1236: WHEN OTHERS THEN
1237: x_allocation_out_rec.return_status := OKE_API.G_RET_STS_UNEXP_ERROR;
1238: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
1239: p_pkg_name => G_PKG_NAME ,
1240: p_exc_name => 'OTHERS' ,
1241: x_msg_count => x_msg_count ,
1242: x_msg_data => x_msg_data ,

Line 1253: -- Calling subprograms: OKE_API.start_activity

1249: -- Procedure: update_allocation
1250: --
1251: -- Description: This procedure is used to update contract funding allocation and pa funding line
1252: --
1253: -- Calling subprograms: OKE_API.start_activity
1254: -- OKE_API.end_activity
1255: -- OKE_ALLOCATION_PVT.update_allocation
1256: -- OKE_AGREEMENT_PVT.update_pa_funding
1257: -- OKE_AGREEMENT_PVT.add_pa_funding

Line 1254: -- OKE_API.end_activity

1250: --
1251: -- Description: This procedure is used to update contract funding allocation and pa funding line
1252: --
1253: -- Calling subprograms: OKE_API.start_activity
1254: -- OKE_API.end_activity
1255: -- OKE_ALLOCATION_PVT.update_allocation
1256: -- OKE_AGREEMENT_PVT.update_pa_funding
1257: -- OKE_AGREEMENT_PVT.add_pa_funding
1258: -- check_update_add_pa

Line 1262: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,

1258: -- check_update_add_pa
1259: --
1260:
1261: PROCEDURE update_allocation(p_api_version IN NUMBER ,
1262: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
1263: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
1264: x_return_status OUT NOCOPY VARCHAR2 ,
1265: x_msg_count OUT NOCOPY NUMBER ,
1266: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 1263: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,

1259: --
1260:
1261: PROCEDURE update_allocation(p_api_version IN NUMBER ,
1262: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
1263: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
1264: x_return_status OUT NOCOPY VARCHAR2 ,
1265: x_msg_count OUT NOCOPY NUMBER ,
1266: x_msg_data OUT NOCOPY VARCHAR2 ,
1267: p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE ,

Line 1267: p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE ,

1263: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
1264: x_return_status OUT NOCOPY VARCHAR2 ,
1265: x_msg_count OUT NOCOPY NUMBER ,
1266: x_msg_data OUT NOCOPY VARCHAR2 ,
1267: p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE ,
1268: p_allocation_in_rec IN ALLOCATION_REC_IN_TYPE ,
1269: x_allocation_out_rec OUT NOCOPY ALLOCATION_REC_OUT_TYPE
1270: ) is
1271:

Line 1281: x_return_status := OKE_API.G_RET_STS_SUCCESS;

1277:
1278: --dbms_output.put_line('entering oke_funding_pub.update_allocation');
1279: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'entering oke_funding_pub.update_allocation');
1280:
1281: x_return_status := OKE_API.G_RET_STS_SUCCESS;
1282: x_allocation_out_rec.return_status := OKE_API.G_RET_STS_SUCCESS;
1283:
1284: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,
1285: p_pkg_name => G_PKG_NAME ,

Line 1282: x_allocation_out_rec.return_status := OKE_API.G_RET_STS_SUCCESS;

1278: --dbms_output.put_line('entering oke_funding_pub.update_allocation');
1279: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'entering oke_funding_pub.update_allocation');
1280:
1281: x_return_status := OKE_API.G_RET_STS_SUCCESS;
1282: x_allocation_out_rec.return_status := OKE_API.G_RET_STS_SUCCESS;
1283:
1284: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,
1285: p_pkg_name => G_PKG_NAME ,
1286: p_init_msg_list => p_init_msg_list ,

Line 1284: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,

1280:
1281: x_return_status := OKE_API.G_RET_STS_SUCCESS;
1282: x_allocation_out_rec.return_status := OKE_API.G_RET_STS_SUCCESS;
1283:
1284: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,
1285: p_pkg_name => G_PKG_NAME ,
1286: p_init_msg_list => p_init_msg_list ,
1287: l_api_version => G_API_VERSION_NUMBER ,
1288: p_api_version => p_api_version ,

Line 1293: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

1289: p_api_type => '_PUB' ,
1290: x_return_status => x_return_status
1291: );
1292:
1293: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1294:
1295: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1296:
1297: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 1295: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1291: );
1292:
1293: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1294:
1295: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1296:
1297: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1298:
1299: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 1297: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN

1293: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1294:
1295: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1296:
1297: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1298:
1299: RAISE OKE_API.G_EXCEPTION_ERROR;
1300:
1301: END IF;

Line 1299: RAISE OKE_API.G_EXCEPTION_ERROR;

1295: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1296:
1297: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1298:
1299: RAISE OKE_API.G_EXCEPTION_ERROR;
1300:
1301: END IF;
1302:
1303: x_allocation_out_rec.fund_allocation_id := p_allocation_in_rec.fund_allocation_id;

Line 1313: p_init_msg_list => OKE_API.G_FALSE ,

1309: --dbms_output.put_line('calling oke_allocation_pvt.update_allocation from oke_funding_pub');
1310: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_allocation_pvt.update_allocation from oke_funding_pub');
1311:
1312: OKE_ALLOCATION_PVT.update_allocation(p_api_version => p_api_version ,
1313: p_init_msg_list => OKE_API.G_FALSE ,
1314: p_commit => OKE_API.G_FALSE ,
1315: p_msg_count => x_msg_count ,
1316: p_msg_data => x_msg_data ,
1317: p_allocation_in_rec => p_allocation_in_rec ,

Line 1314: p_commit => OKE_API.G_FALSE ,

1310: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_allocation_pvt.update_allocation from oke_funding_pub');
1311:
1312: OKE_ALLOCATION_PVT.update_allocation(p_api_version => p_api_version ,
1313: p_init_msg_list => OKE_API.G_FALSE ,
1314: p_commit => OKE_API.G_FALSE ,
1315: p_msg_count => x_msg_count ,
1316: p_msg_data => x_msg_data ,
1317: p_allocation_in_rec => p_allocation_in_rec ,
1318: p_allocation_out_rec => x_allocation_out_rec ,

Line 1319: p_validation_flag => OKE_API.G_TRUE ,

1315: p_msg_count => x_msg_count ,
1316: p_msg_data => x_msg_data ,
1317: p_allocation_in_rec => p_allocation_in_rec ,
1318: p_allocation_out_rec => x_allocation_out_rec ,
1319: p_validation_flag => OKE_API.G_TRUE ,
1320: p_return_status => x_return_status
1321: );
1322:
1323: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1323: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

1319: p_validation_flag => OKE_API.G_TRUE ,
1320: p_return_status => x_return_status
1321: );
1322:
1323: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1324:
1325: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1326:
1327: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 1325: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1321: );
1322:
1323: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1324:
1325: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1326:
1327: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN
1328:
1329: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 1327: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN

1323: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1324:
1325: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1326:
1327: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN
1328:
1329: RAISE OKE_API.G_EXCEPTION_ERROR;
1330:
1331: END IF;

Line 1329: RAISE OKE_API.G_EXCEPTION_ERROR;

1325: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1326:
1327: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN
1328:
1329: RAISE OKE_API.G_EXCEPTION_ERROR;
1330:
1331: END IF;
1332:
1333: --

Line 1361: p_init_msg_list => OKE_API.G_FALSE ,

1357: --dbms_output.put_line('calling oke_agreement_pvt.update_pa_funding from oke_funding_pub');
1358: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_agreement_pvt.update_pa_funding from oke_funding_pub');
1359:
1360: OKE_AGREEMENT_PVT.update_pa_funding(p_api_version => p_api_version ,
1361: p_init_msg_list => OKE_API.G_FALSE ,
1362: p_commit => OKE_API.G_FALSE ,
1363: p_msg_count => x_msg_count ,
1364: p_msg_data => x_msg_data ,
1365: p_allocation_in_rec => l_allocation_in_rec ,

Line 1362: p_commit => OKE_API.G_FALSE ,

1358: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_agreement_pvt.update_pa_funding from oke_funding_pub');
1359:
1360: OKE_AGREEMENT_PVT.update_pa_funding(p_api_version => p_api_version ,
1361: p_init_msg_list => OKE_API.G_FALSE ,
1362: p_commit => OKE_API.G_FALSE ,
1363: p_msg_count => x_msg_count ,
1364: p_msg_data => x_msg_data ,
1365: p_allocation_in_rec => l_allocation_in_rec ,
1366: p_return_status => x_return_status

Line 1374: p_init_msg_list => OKE_API.G_FALSE ,

1370: --dbms_output.put_line('calling oke_agreement_pvt.add_pa_funding from oke_funding_pub');
1371: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_agreement_pvt.add_pa_funding from oke_funding_pub');
1372:
1373: OKE_AGREEMENT_PVT.add_pa_funding(p_api_version => p_api_version ,
1374: p_init_msg_list => OKE_API.G_FALSE ,
1375: p_commit => OKE_API.G_FALSE ,
1376: p_msg_count => x_msg_count ,
1377: p_msg_data => x_msg_data ,
1378: p_allocation_in_rec => l_allocation_in_rec ,

Line 1375: p_commit => OKE_API.G_FALSE ,

1371: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_agreement_pvt.add_pa_funding from oke_funding_pub');
1372:
1373: OKE_AGREEMENT_PVT.add_pa_funding(p_api_version => p_api_version ,
1374: p_init_msg_list => OKE_API.G_FALSE ,
1375: p_commit => OKE_API.G_FALSE ,
1376: p_msg_count => x_msg_count ,
1377: p_msg_data => x_msg_data ,
1378: p_allocation_in_rec => l_allocation_in_rec ,
1379: p_return_status => x_return_status

Line 1384: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

1380: );
1381:
1382: END IF;
1383:
1384: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1385:
1386: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1387:
1388: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 1386: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1382: END IF;
1383:
1384: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1385:
1386: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1387:
1388: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN
1389:
1390: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 1388: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN

1384: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1385:
1386: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1387:
1388: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN
1389:
1390: RAISE OKE_API.G_EXCEPTION_ERROR;
1391:
1392: END IF;

Line 1390: RAISE OKE_API.G_EXCEPTION_ERROR;

1386: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1387:
1388: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN
1389:
1390: RAISE OKE_API.G_EXCEPTION_ERROR;
1391:
1392: END IF;
1393:
1394: END IF;

Line 1405: OKE_API.END_ACTIVITY(x_msg_count => x_msg_count ,

1401: COMMIT WORK;
1402:
1403: END IF;
1404:
1405: OKE_API.END_ACTIVITY(x_msg_count => x_msg_count ,
1406: x_msg_data => x_msg_data
1407: );
1408:
1409: EXCEPTION

Line 1410: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN

1406: x_msg_data => x_msg_data
1407: );
1408:
1409: EXCEPTION
1410: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
1411: x_allocation_out_rec.return_status := OKE_API.G_RET_STS_ERROR;
1412: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
1413: p_pkg_name => G_PKG_NAME ,
1414: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,

Line 1411: x_allocation_out_rec.return_status := OKE_API.G_RET_STS_ERROR;

1407: );
1408:
1409: EXCEPTION
1410: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
1411: x_allocation_out_rec.return_status := OKE_API.G_RET_STS_ERROR;
1412: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
1413: p_pkg_name => G_PKG_NAME ,
1414: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
1415: x_msg_count => x_msg_count ,

Line 1412: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,

1408:
1409: EXCEPTION
1410: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
1411: x_allocation_out_rec.return_status := OKE_API.G_RET_STS_ERROR;
1412: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
1413: p_pkg_name => G_PKG_NAME ,
1414: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
1415: x_msg_count => x_msg_count ,
1416: x_msg_data => x_msg_data ,

Line 1414: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,

1410: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
1411: x_allocation_out_rec.return_status := OKE_API.G_RET_STS_ERROR;
1412: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
1413: p_pkg_name => G_PKG_NAME ,
1414: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
1415: x_msg_count => x_msg_count ,
1416: x_msg_data => x_msg_data ,
1417: p_api_type => '_PUB'
1418: );

Line 1420: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1416: x_msg_data => x_msg_data ,
1417: p_api_type => '_PUB'
1418: );
1419:
1420: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1421: x_allocation_out_rec.return_status := OKE_API.G_RET_STS_UNEXP_ERROR;
1422: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
1423: p_pkg_name => G_PKG_NAME ,
1424: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,

Line 1421: x_allocation_out_rec.return_status := OKE_API.G_RET_STS_UNEXP_ERROR;

1417: p_api_type => '_PUB'
1418: );
1419:
1420: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1421: x_allocation_out_rec.return_status := OKE_API.G_RET_STS_UNEXP_ERROR;
1422: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
1423: p_pkg_name => G_PKG_NAME ,
1424: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,
1425: x_msg_count => x_msg_count ,

Line 1422: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,

1418: );
1419:
1420: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1421: x_allocation_out_rec.return_status := OKE_API.G_RET_STS_UNEXP_ERROR;
1422: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
1423: p_pkg_name => G_PKG_NAME ,
1424: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,
1425: x_msg_count => x_msg_count ,
1426: x_msg_data => x_msg_data ,

Line 1424: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,

1420: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1421: x_allocation_out_rec.return_status := OKE_API.G_RET_STS_UNEXP_ERROR;
1422: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
1423: p_pkg_name => G_PKG_NAME ,
1424: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,
1425: x_msg_count => x_msg_count ,
1426: x_msg_data => x_msg_data ,
1427: p_api_type => '_PUB'
1428: );

Line 1431: x_allocation_out_rec.return_status := OKE_API.G_RET_STS_UNEXP_ERROR;

1427: p_api_type => '_PUB'
1428: );
1429:
1430: WHEN OTHERS THEN
1431: x_allocation_out_rec.return_status := OKE_API.G_RET_STS_UNEXP_ERROR;
1432: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
1433: p_pkg_name => G_PKG_NAME ,
1434: p_exc_name => 'OTHERS' ,
1435: x_msg_count => x_msg_count ,

Line 1432: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,

1428: );
1429:
1430: WHEN OTHERS THEN
1431: x_allocation_out_rec.return_status := OKE_API.G_RET_STS_UNEXP_ERROR;
1432: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
1433: p_pkg_name => G_PKG_NAME ,
1434: p_exc_name => 'OTHERS' ,
1435: x_msg_count => x_msg_count ,
1436: x_msg_data => x_msg_data ,

Line 1448: -- Calling subprograms: OKE_API.start_activity

1444: -- Procedure: delete_allocation
1445: --
1446: -- Description: This procedure is used to delete contract funding allocation and pa project_funding
1447: --
1448: -- Calling subprograms: OKE_API.start_activity
1449: -- OKE_API.end_activity
1450: -- OKE_ALLOCATION_PVT.delete_allocation
1451: --
1452:

Line 1449: -- OKE_API.end_activity

1445: --
1446: -- Description: This procedure is used to delete contract funding allocation and pa project_funding
1447: --
1448: -- Calling subprograms: OKE_API.start_activity
1449: -- OKE_API.end_activity
1450: -- OKE_ALLOCATION_PVT.delete_allocation
1451: --
1452:
1453: PROCEDURE delete_allocation(p_api_version IN NUMBER ,

Line 1454: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,

1450: -- OKE_ALLOCATION_PVT.delete_allocation
1451: --
1452:
1453: PROCEDURE delete_allocation(p_api_version IN NUMBER ,
1454: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
1455: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
1456: x_return_status OUT NOCOPY VARCHAR2 ,
1457: x_msg_count OUT NOCOPY NUMBER ,
1458: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 1455: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,

1451: --
1452:
1453: PROCEDURE delete_allocation(p_api_version IN NUMBER ,
1454: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
1455: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
1456: x_return_status OUT NOCOPY VARCHAR2 ,
1457: x_msg_count OUT NOCOPY NUMBER ,
1458: x_msg_data OUT NOCOPY VARCHAR2 ,
1459: p_fund_allocation_id IN NUMBER

Line 1460: -- p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE

1456: x_return_status OUT NOCOPY VARCHAR2 ,
1457: x_msg_count OUT NOCOPY NUMBER ,
1458: x_msg_data OUT NOCOPY VARCHAR2 ,
1459: p_fund_allocation_id IN NUMBER
1460: -- p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE
1461: ) is
1462:
1463: l_api_name CONSTANT VARCHAR2(30) := 'delete_allocation';
1464: l_return_status VARCHAR2(1);

Line 1492: x_return_status := OKE_API.G_RET_STS_SUCCESS;

1488:
1489: --dbms_output.put_line('entering oke_funding_pub.delete_allocation');
1490: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'entering oke_funding_pub.delete_allocation');
1491:
1492: x_return_status := OKE_API.G_RET_STS_SUCCESS;
1493:
1494: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,
1495: p_pkg_name => G_PKG_NAME ,
1496: p_init_msg_list => p_init_msg_list ,

Line 1494: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,

1490: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'entering oke_funding_pub.delete_allocation');
1491:
1492: x_return_status := OKE_API.G_RET_STS_SUCCESS;
1493:
1494: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,
1495: p_pkg_name => G_PKG_NAME ,
1496: p_init_msg_list => p_init_msg_list ,
1497: l_api_version => G_API_VERSION_NUMBER ,
1498: p_api_version => p_api_version ,

Line 1503: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

1499: p_api_type => '_PUB' ,
1500: x_return_status => x_return_status
1501: );
1502:
1503: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1504:
1505: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1506:
1507: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 1505: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1501: );
1502:
1503: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1504:
1505: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1506:
1507: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1508:
1509: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 1507: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN

1503: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1504:
1505: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1506:
1507: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1508:
1509: RAISE OKE_API.G_EXCEPTION_ERROR;
1510:
1511: END IF;

Line 1509: RAISE OKE_API.G_EXCEPTION_ERROR;

1505: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1506:
1507: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1508:
1509: RAISE OKE_API.G_EXCEPTION_ERROR;
1510:
1511: END IF;
1512:
1513: --

Line 1521: OKE_API.set_message(p_app_name => 'OKE' ,

1517: FETCH c_source INTO l_s_amount, l_s_hard_limit, l_s_revenue_limit, l_funding_source_id;
1518: IF (c_source%NOTFOUND) THEN
1519:
1520: CLOSE c_source;
1521: OKE_API.set_message(p_app_name => 'OKE' ,
1522: p_msg_name => 'OKE_API_INVALID_VALUE' ,
1523: p_token1 => 'VALUE' ,
1524: p_token1_value => 'fund_allocation_id'
1525: );

Line 1522: p_msg_name => 'OKE_API_INVALID_VALUE' ,

1518: IF (c_source%NOTFOUND) THEN
1519:
1520: CLOSE c_source;
1521: OKE_API.set_message(p_app_name => 'OKE' ,
1522: p_msg_name => 'OKE_API_INVALID_VALUE' ,
1523: p_token1 => 'VALUE' ,
1524: p_token1_value => 'fund_allocation_id'
1525: );
1526:

Line 1540: p_commit => OKE_API.G_FALSE ,

1536: --dbms_output.put_line('calling oke_allocation_pvt.delete_allocation from oke_funding_pub');
1537: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_allocation_pvt.delete_allocation from oke_funding_pub');
1538:
1539: OKE_ALLOCATION_PVT.delete_allocation(p_api_version => p_api_version ,
1540: p_commit => OKE_API.G_FALSE ,
1541: p_init_msg_list => OKE_API.G_FALSE ,
1542: p_msg_count => x_msg_count ,
1543: p_msg_data => x_msg_data ,
1544: p_fund_allocation_id => p_fund_allocation_id ,

Line 1541: p_init_msg_list => OKE_API.G_FALSE ,

1537: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_allocation_pvt.delete_allocation from oke_funding_pub');
1538:
1539: OKE_ALLOCATION_PVT.delete_allocation(p_api_version => p_api_version ,
1540: p_commit => OKE_API.G_FALSE ,
1541: p_init_msg_list => OKE_API.G_FALSE ,
1542: p_msg_count => x_msg_count ,
1543: p_msg_data => x_msg_data ,
1544: p_fund_allocation_id => p_fund_allocation_id ,
1545: p_return_status => x_return_status

Line 1548: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

1544: p_fund_allocation_id => p_fund_allocation_id ,
1545: p_return_status => x_return_status
1546: );
1547:
1548: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1549:
1550: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1551:
1552: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 1550: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1546: );
1547:
1548: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1549:
1550: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1551:
1552: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN
1553:
1554: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 1552: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN

1548: IF (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1549:
1550: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1551:
1552: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN
1553:
1554: RAISE OKE_API.G_EXCEPTION_ERROR;
1555:
1556: END IF;

Line 1554: RAISE OKE_API.G_EXCEPTION_ERROR;

1550: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1551:
1552: ELSIF (x_return_status = OKE_API.G_RET_STS_ERROR) THEN
1553:
1554: RAISE OKE_API.G_EXCEPTION_ERROR;
1555:
1556: END IF;
1557:
1558: --

Line 1575: OKE_API.set_message(p_app_name => 'OKE' ,

1571: CLOSE c_allocation;
1572:
1573: IF (l_a_amount < 0) THEN
1574:
1575: OKE_API.set_message(p_app_name => 'OKE' ,
1576: p_msg_name => 'OKE_NEGATIVE_ALLOCATION_SUM'
1577: );
1578:
1579: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1583: OKE_API.set_message(p_app_name => 'OKE' ,

1579: RAISE G_EXCEPTION_HALT_VALIDATION;
1580:
1581: ELSIF (l_a_amount > l_s_amount) THEN
1582:
1583: OKE_API.set_message(p_app_name => 'OKE' ,
1584: p_msg_name => 'OKE_FUND_AMT_EXCEED'
1585: );
1586:
1587: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1593: OKE_API.set_message(p_app_name => 'OKE' ,

1589: END IF;
1590:
1591: IF (l_a_hard_limit < 0) THEN
1592:
1593: OKE_API.set_message(p_app_name => 'OKE' ,
1594: p_msg_name => 'OKE_NEGATIVE_HARD_LIMIT_SUM'
1595: );
1596:
1597: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1601: OKE_API.set_message(p_app_name => 'OKE' ,

1597: RAISE G_EXCEPTION_HALT_VALIDATION;
1598:
1599: ELSIF (l_a_hard_limit > l_s_hard_limit) THEN
1600:
1601: OKE_API.set_message(p_app_name => 'OKE' ,
1602: p_msg_name => 'OKE_HARD_LIMIT_EXCEED'
1603: );
1604:
1605: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1611: OKE_API.set_message(p_app_name => 'OKE' ,

1607: END IF;
1608:
1609: IF (l_a_revenue_limit < 0) THEN
1610:
1611: OKE_API.set_message(p_app_name => 'OKE' ,
1612: p_msg_name => 'OKE_NEGATIVE_REV_LIMIT_SUM'
1613: );
1614:
1615: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1619: OKE_API.set_message(p_app_name => 'OKE' ,

1615: RAISE G_EXCEPTION_HALT_VALIDATION;
1616:
1617: ELSIF (l_a_revenue_limit > l_s_revenue_limit) THEN
1618:
1619: OKE_API.set_message(p_app_name => 'OKE' ,
1620: p_msg_name => 'OKE_REV_LIMIT_EXCEED'
1621: );
1622:
1623: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1636: OKE_API.END_ACTIVITY(x_msg_count => x_msg_count ,

1632: COMMIT WORK;
1633:
1634: END IF;
1635:
1636: OKE_API.END_ACTIVITY(x_msg_count => x_msg_count ,
1637: x_msg_data => x_msg_data
1638: );
1639:
1640: EXCEPTION

Line 1641: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN

1637: x_msg_data => x_msg_data
1638: );
1639:
1640: EXCEPTION
1641: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
1642: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
1643: p_pkg_name => G_PKG_NAME ,
1644: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
1645: x_msg_count => x_msg_count ,

Line 1642: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,

1638: );
1639:
1640: EXCEPTION
1641: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
1642: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
1643: p_pkg_name => G_PKG_NAME ,
1644: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
1645: x_msg_count => x_msg_count ,
1646: x_msg_data => x_msg_data ,

Line 1644: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,

1640: EXCEPTION
1641: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
1642: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
1643: p_pkg_name => G_PKG_NAME ,
1644: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
1645: x_msg_count => x_msg_count ,
1646: x_msg_data => x_msg_data ,
1647: p_api_type => '_PUB'
1648: );

Line 1650: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1646: x_msg_data => x_msg_data ,
1647: p_api_type => '_PUB'
1648: );
1649:
1650: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1651: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
1652: p_pkg_name => G_PKG_NAME ,
1653: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,
1654: x_msg_count => x_msg_count ,

Line 1651: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,

1647: p_api_type => '_PUB'
1648: );
1649:
1650: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1651: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
1652: p_pkg_name => G_PKG_NAME ,
1653: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,
1654: x_msg_count => x_msg_count ,
1655: x_msg_data => x_msg_data ,

Line 1653: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,

1649:
1650: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1651: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
1652: p_pkg_name => G_PKG_NAME ,
1653: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,
1654: x_msg_count => x_msg_count ,
1655: x_msg_data => x_msg_data ,
1656: p_api_type => '_PUB'
1657: );

Line 1660: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,

1656: p_api_type => '_PUB'
1657: );
1658:
1659: WHEN OTHERS THEN
1660: x_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
1661: p_pkg_name => G_PKG_NAME ,
1662: p_exc_name => 'OTHERS' ,
1663: x_msg_count => x_msg_count ,
1664: x_msg_data => x_msg_data ,