eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_CS_TRANSFER_ASSUMPTION_PVT dependencies on OKL_API

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

24: x_msg_data OUT NOCOPY VARCHAR2)
25:
26: AS
27: l_count NUMBER;
28: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
29: l_api_name CONSTANT VARCHAR2(30) := 'Create_Request';
30: l_api_version CONSTANT NUMBER := 1;
31: j BINARY_INTEGER;
32:

Line 36: x_return_status := OKL_API.G_RET_STS_SUCCESS;

32:
33:
34: BEGIN
35:
36: x_return_status := OKL_API.G_RET_STS_SUCCESS;
37:
38: --Call start_activity to create savepoint, check compatibility and initialize message list
39:
40: x_return_status := OKL_API.START_ACTIVITY(

Line 40: x_return_status := OKL_API.START_ACTIVITY(

36: x_return_status := OKL_API.G_RET_STS_SUCCESS;
37:
38: --Call start_activity to create savepoint, check compatibility and initialize message list
39:
40: x_return_status := OKL_API.START_ACTIVITY(
41: l_api_name
42: ,p_init_msg_list
43: ,'_PUB'
44: ,x_return_status);

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

44: ,x_return_status);
45:
46: --Check if activity started successfully
47:
48: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
49: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
50: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
51: RAISE OKL_API.G_EXCEPTION_ERROR;
52: END IF;

Line 49: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

45:
46: --Check if activity started successfully
47:
48: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
49: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
50: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
51: RAISE OKL_API.G_EXCEPTION_ERROR;
52: END IF;
53: --populating the header record

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

46: --Check if activity started successfully
47:
48: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
49: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
50: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
51: RAISE OKL_API.G_EXCEPTION_ERROR;
52: END IF;
53: --populating the header record
54: l_tcnv_rec.khr_id := p_header_tbl(1).khr_id;

Line 51: RAISE OKL_API.G_EXCEPTION_ERROR;

47:
48: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
49: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
50: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
51: RAISE OKL_API.G_EXCEPTION_ERROR;
52: END IF;
53: --populating the header record
54: l_tcnv_rec.khr_id := p_header_tbl(1).khr_id;
55: l_tcnv_rec.khr_id_old := p_header_tbl(1).khr_id_old;

Line 162: OKL_API.END_ACTIVITY (x_msg_count,

158: x_msg_data => x_msg_data,
159: p_taav_tbl => l_taav_tbl,
160: x_taav_tbl => x_taav_tbl);
161:
162: OKL_API.END_ACTIVITY (x_msg_count,
163: x_msg_data );
164:
165:
166: EXCEPTION

Line 167: WHEN OKL_API.G_EXCEPTION_ERROR THEN

163: x_msg_data );
164:
165:
166: EXCEPTION
167: WHEN OKL_API.G_EXCEPTION_ERROR THEN
168: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
169: l_api_name,
170: G_PKG_NAME,
171: 'OKL_API.G_RET_STS_ERROR',

Line 168: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

164:
165:
166: EXCEPTION
167: WHEN OKL_API.G_EXCEPTION_ERROR THEN
168: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
169: l_api_name,
170: G_PKG_NAME,
171: 'OKL_API.G_RET_STS_ERROR',
172: x_msg_count,

Line 171: 'OKL_API.G_RET_STS_ERROR',

167: WHEN OKL_API.G_EXCEPTION_ERROR THEN
168: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
169: l_api_name,
170: G_PKG_NAME,
171: 'OKL_API.G_RET_STS_ERROR',
172: x_msg_count,
173: x_msg_data,
174: '_PUB');
175: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 175: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

171: 'OKL_API.G_RET_STS_ERROR',
172: x_msg_count,
173: x_msg_data,
174: '_PUB');
175: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
176: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
177: l_api_name,
178: G_PKG_NAME,
179: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 176: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

172: x_msg_count,
173: x_msg_data,
174: '_PUB');
175: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
176: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
177: l_api_name,
178: G_PKG_NAME,
179: 'OKL_API.G_RET_STS_UNEXP_ERROR',
180: x_msg_count,

Line 179: 'OKL_API.G_RET_STS_UNEXP_ERROR',

175: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
176: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
177: l_api_name,
178: G_PKG_NAME,
179: 'OKL_API.G_RET_STS_UNEXP_ERROR',
180: x_msg_count,
181: x_msg_data,
182: '_PUB');
183: WHEN OTHERS THEN

Line 184: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

180: x_msg_count,
181: x_msg_data,
182: '_PUB');
183: WHEN OTHERS THEN
184: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
185: l_api_name,
186: G_PKG_NAME,
187: 'OTHERS',
188: x_msg_count,

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

206: x_msg_data OUT NOCOPY VARCHAR2)
207: AS
208:
209: l_api_name varchar2(100) := 'Accept_Requests';
210: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
211: l_api_version CONSTANT NUMBER := 1;
212:
213:
214: l_tcnv_rec tcnv_rec_type;

Line 222: x_return_status := OKL_API.G_RET_STS_SUCCESS;

218: l_count NUMBER;
219: j NUMBER;
220:
221: BEGIN
222: x_return_status := OKL_API.G_RET_STS_SUCCESS;
223:
224: --Call start_activity to create savepoint, check compatibility and initialize message list
225:
226: x_return_status := OKL_API.START_ACTIVITY(

Line 226: x_return_status := OKL_API.START_ACTIVITY(

222: x_return_status := OKL_API.G_RET_STS_SUCCESS;
223:
224: --Call start_activity to create savepoint, check compatibility and initialize message list
225:
226: x_return_status := OKL_API.START_ACTIVITY(
227: l_api_name
228: ,p_init_msg_list
229: ,'_PUB'
230: ,x_return_status);

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

230: ,x_return_status);
231:
232: --Check if activity started successfully
233:
234: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
235: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
236: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
237: RAISE OKL_API.G_EXCEPTION_ERROR;
238: END IF;

Line 235: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

231:
232: --Check if activity started successfully
233:
234: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
235: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
236: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
237: RAISE OKL_API.G_EXCEPTION_ERROR;
238: END IF;
239:

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

232: --Check if activity started successfully
233:
234: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
235: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
236: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
237: RAISE OKL_API.G_EXCEPTION_ERROR;
238: END IF;
239:
240: --populating the header record

Line 237: RAISE OKL_API.G_EXCEPTION_ERROR;

233:
234: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
235: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
236: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
237: RAISE OKL_API.G_EXCEPTION_ERROR;
238: END IF;
239:
240: --populating the header record
241: l_tcnv_rec.id := p_header_tbl(1).id;

Line 309: OKL_API.END_ACTIVITY (x_msg_count,

305: x_taav_tbl => x_taav_tbl);
306:
307:
308:
309: OKL_API.END_ACTIVITY (x_msg_count,
310: x_msg_data );
311:
312:
313: EXCEPTION

Line 314: WHEN OKL_API.G_EXCEPTION_ERROR THEN

310: x_msg_data );
311:
312:
313: EXCEPTION
314: WHEN OKL_API.G_EXCEPTION_ERROR THEN
315: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
316: l_api_name,
317: G_PKG_NAME,
318: 'OKL_API.G_RET_STS_ERROR',

Line 315: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

311:
312:
313: EXCEPTION
314: WHEN OKL_API.G_EXCEPTION_ERROR THEN
315: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
316: l_api_name,
317: G_PKG_NAME,
318: 'OKL_API.G_RET_STS_ERROR',
319: x_msg_count,

Line 318: 'OKL_API.G_RET_STS_ERROR',

314: WHEN OKL_API.G_EXCEPTION_ERROR THEN
315: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
316: l_api_name,
317: G_PKG_NAME,
318: 'OKL_API.G_RET_STS_ERROR',
319: x_msg_count,
320: x_msg_data,
321: '_PUB');
322: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 322: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

318: 'OKL_API.G_RET_STS_ERROR',
319: x_msg_count,
320: x_msg_data,
321: '_PUB');
322: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
323: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
324: l_api_name,
325: G_PKG_NAME,
326: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 323: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

319: x_msg_count,
320: x_msg_data,
321: '_PUB');
322: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
323: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
324: l_api_name,
325: G_PKG_NAME,
326: 'OKL_API.G_RET_STS_UNEXP_ERROR',
327: x_msg_count,

Line 326: 'OKL_API.G_RET_STS_UNEXP_ERROR',

322: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
323: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
324: l_api_name,
325: G_PKG_NAME,
326: 'OKL_API.G_RET_STS_UNEXP_ERROR',
327: x_msg_count,
328: x_msg_data,
329: '_PUB');
330: WHEN OTHERS THEN

Line 331: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

327: x_msg_count,
328: x_msg_data,
329: '_PUB');
330: WHEN OTHERS THEN
331: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
332: l_api_name,
333: G_PKG_NAME,
334: 'OTHERS',
335: x_msg_count,

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

353: x_msg_data OUT NOCOPY VARCHAR2)
354: AS
355:
356: l_api_name varchar2(100) := 'Update_Requests';
357: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
358: l_api_version CONSTANT NUMBER := 1;
359:
360: l_tcnv_rec tcnv_rec_type;
361: l_tclv_tbl tclv_tbl_type;

Line 368: x_return_status := OKL_API.G_RET_STS_SUCCESS;

364: l_count NUMBER;
365: j NUMBER;
366:
367: BEGIN
368: x_return_status := OKL_API.G_RET_STS_SUCCESS;
369:
370: --Call start_activity to create savepoint, check compatibility and initialize message list
371:
372: x_return_status := OKL_API.START_ACTIVITY(

Line 372: x_return_status := OKL_API.START_ACTIVITY(

368: x_return_status := OKL_API.G_RET_STS_SUCCESS;
369:
370: --Call start_activity to create savepoint, check compatibility and initialize message list
371:
372: x_return_status := OKL_API.START_ACTIVITY(
373: l_api_name
374: ,p_init_msg_list
375: ,'_PUB'
376: ,x_return_status);

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

376: ,x_return_status);
377:
378: --Check if activity started successfully
379:
380: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
381: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
382: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
383: RAISE OKL_API.G_EXCEPTION_ERROR;
384: END IF;

Line 381: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

377:
378: --Check if activity started successfully
379:
380: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
381: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
382: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
383: RAISE OKL_API.G_EXCEPTION_ERROR;
384: END IF;
385:

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

378: --Check if activity started successfully
379:
380: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
381: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
382: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
383: RAISE OKL_API.G_EXCEPTION_ERROR;
384: END IF;
385:
386: --populating the header record

Line 383: RAISE OKL_API.G_EXCEPTION_ERROR;

379:
380: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
381: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
382: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
383: RAISE OKL_API.G_EXCEPTION_ERROR;
384: END IF;
385:
386: --populating the header record
387: l_tcnv_rec.id := p_header_tbl(1).id;

Line 450: OKL_API.END_ACTIVITY (x_msg_count,

446: x_taav_tbl => x_taav_tbl);
447:
448:
449:
450: OKL_API.END_ACTIVITY (x_msg_count,
451: x_msg_data );
452:
453:
454: EXCEPTION

Line 455: WHEN OKL_API.G_EXCEPTION_ERROR THEN

451: x_msg_data );
452:
453:
454: EXCEPTION
455: WHEN OKL_API.G_EXCEPTION_ERROR THEN
456: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
457: l_api_name,
458: G_PKG_NAME,
459: 'OKL_API.G_RET_STS_ERROR',

Line 456: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

452:
453:
454: EXCEPTION
455: WHEN OKL_API.G_EXCEPTION_ERROR THEN
456: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
457: l_api_name,
458: G_PKG_NAME,
459: 'OKL_API.G_RET_STS_ERROR',
460: x_msg_count,

Line 459: 'OKL_API.G_RET_STS_ERROR',

455: WHEN OKL_API.G_EXCEPTION_ERROR THEN
456: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
457: l_api_name,
458: G_PKG_NAME,
459: 'OKL_API.G_RET_STS_ERROR',
460: x_msg_count,
461: x_msg_data,
462: '_PUB');
463: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 463: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

459: 'OKL_API.G_RET_STS_ERROR',
460: x_msg_count,
461: x_msg_data,
462: '_PUB');
463: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
464: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
465: l_api_name,
466: G_PKG_NAME,
467: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 464: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

460: x_msg_count,
461: x_msg_data,
462: '_PUB');
463: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
464: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
465: l_api_name,
466: G_PKG_NAME,
467: 'OKL_API.G_RET_STS_UNEXP_ERROR',
468: x_msg_count,

Line 467: 'OKL_API.G_RET_STS_UNEXP_ERROR',

463: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
464: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
465: l_api_name,
466: G_PKG_NAME,
467: 'OKL_API.G_RET_STS_UNEXP_ERROR',
468: x_msg_count,
469: x_msg_data,
470: '_PUB');
471: WHEN OTHERS THEN

Line 472: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

468: x_msg_count,
469: x_msg_data,
470: '_PUB');
471: WHEN OTHERS THEN
472: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
473: l_api_name,
474: G_PKG_NAME,
475: 'OTHERS',
476: x_msg_count,

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

577: WHERE owner_table_id = p_party_id
578: AND contact_point_type = 'PHONE';
579:
580:
581: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
582: l_api_name CONSTANT VARCHAR2(30) := 'Populate';
583: l_api_version CONSTANT NUMBER := 1;
584: l_id1 VARCHAR2(40);
585: l_id2 VARCHAR2(200);

Line 626: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

622: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_CS_TRANSFER_ASSUMPTION_PVT.Populate_New_Lessee_details',
623: 'p_request_id :'||p_request_id);
624: END IF;
625:
626: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
627: G_PKG_NAME,
628: p_init_msg_list,
629: l_api_version,
630: p_api_version,

Line 738: OKL_API.END_ACTIVITY (x_msg_count, x_msg_data);

734: x_new_lessee_tbl(1).lease_policy_yn := l_taa_record.lease_policy_yn;
735:
736: x_return_status := l_return_status;
737:
738: OKL_API.END_ACTIVITY (x_msg_count, x_msg_data);
739: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
740: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_PROCESS_TAX.Create_Tax_Schedule ','End(-)');
741: END IF;
742:

Line 744: WHEN OKL_API.G_EXCEPTION_ERROR THEN

740: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_PROCESS_TAX.Create_Tax_Schedule ','End(-)');
741: END IF;
742:
743: EXCEPTION
744: WHEN OKL_API.G_EXCEPTION_ERROR THEN
745: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
746: l_api_name,
747: G_PKG_NAME,
748: 'OKL_API.G_RET_STS_ERROR',

Line 745: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

741: END IF;
742:
743: EXCEPTION
744: WHEN OKL_API.G_EXCEPTION_ERROR THEN
745: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
746: l_api_name,
747: G_PKG_NAME,
748: 'OKL_API.G_RET_STS_ERROR',
749: x_msg_count,

Line 748: 'OKL_API.G_RET_STS_ERROR',

744: WHEN OKL_API.G_EXCEPTION_ERROR THEN
745: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
746: l_api_name,
747: G_PKG_NAME,
748: 'OKL_API.G_RET_STS_ERROR',
749: x_msg_count,
750: x_msg_data,
751: '_PUB');
752: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 752: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

748: 'OKL_API.G_RET_STS_ERROR',
749: x_msg_count,
750: x_msg_data,
751: '_PUB');
752: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
753: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
754: l_api_name,
755: G_PKG_NAME,
756: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 753: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

749: x_msg_count,
750: x_msg_data,
751: '_PUB');
752: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
753: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
754: l_api_name,
755: G_PKG_NAME,
756: 'OKL_API.G_RET_STS_UNEXP_ERROR',
757: x_msg_count,

Line 756: 'OKL_API.G_RET_STS_UNEXP_ERROR',

752: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
753: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
754: l_api_name,
755: G_PKG_NAME,
756: 'OKL_API.G_RET_STS_UNEXP_ERROR',
757: x_msg_count,
758: x_msg_data,
759: '_PUB');
760: WHEN OTHERS THEN

Line 761: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

757: x_msg_count,
758: x_msg_data,
759: '_PUB');
760: WHEN OTHERS THEN
761: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
762: l_api_name,
763: G_PKG_NAME,
764: 'OTHERS',
765: x_msg_count,

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

788: FROM HZ_PARTIES PARTY
789: WHERE PARTY_ID = p_party_id;
790:
791:
792: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
793: l_api_name CONSTANT VARCHAR2(30) := 'Populate_Insurance_Details';
794: l_api_version CONSTANT NUMBER := 1;
795:
796: l_insurer VARCHAR2(360);

Line 814: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

810: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_CS_TRANSFER_ASSUMPTION_PVT.Populate_Insurance_Details',
811: 'p_taa_id :'||p_taa_id);
812: END IF;
813:
814: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
815: G_PKG_NAME,
816: p_init_msg_list,
817: l_api_version,
818: p_api_version,

Line 851: OKL_API.END_ACTIVITY (x_msg_count, x_msg_data);

847: x_insurance_tbl(1).lessor_insured_yn := l_taa_record.lessor_insured_yn;
848: x_insurance_tbl(1).lessor_payee_yn := l_taa_record.lessor_payee_yn;
849:
850: x_return_status := l_return_status;
851: OKL_API.END_ACTIVITY (x_msg_count, x_msg_data);
852: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
853: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_CS_TRANSFER_ASSUMPTION_PVT.populate_thirdparty_insurance','End(-)');
854: END IF;
855:

Line 857: WHEN OKL_API.G_EXCEPTION_ERROR THEN

853: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_CS_TRANSFER_ASSUMPTION_PVT.populate_thirdparty_insurance','End(-)');
854: END IF;
855:
856: EXCEPTION
857: WHEN OKL_API.G_EXCEPTION_ERROR THEN
858: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
859: l_api_name,
860: G_PKG_NAME,
861: 'OKL_API.G_RET_STS_ERROR',

Line 858: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

854: END IF;
855:
856: EXCEPTION
857: WHEN OKL_API.G_EXCEPTION_ERROR THEN
858: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
859: l_api_name,
860: G_PKG_NAME,
861: 'OKL_API.G_RET_STS_ERROR',
862: x_msg_count,

Line 861: 'OKL_API.G_RET_STS_ERROR',

857: WHEN OKL_API.G_EXCEPTION_ERROR THEN
858: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
859: l_api_name,
860: G_PKG_NAME,
861: 'OKL_API.G_RET_STS_ERROR',
862: x_msg_count,
863: x_msg_data,
864: '_PUB');
865: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 865: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

861: 'OKL_API.G_RET_STS_ERROR',
862: x_msg_count,
863: x_msg_data,
864: '_PUB');
865: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
866: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
867: l_api_name,
868: G_PKG_NAME,
869: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 866: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

862: x_msg_count,
863: x_msg_data,
864: '_PUB');
865: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
866: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
867: l_api_name,
868: G_PKG_NAME,
869: 'OKL_API.G_RET_STS_UNEXP_ERROR',
870: x_msg_count,

Line 869: 'OKL_API.G_RET_STS_UNEXP_ERROR',

865: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
866: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
867: l_api_name,
868: G_PKG_NAME,
869: 'OKL_API.G_RET_STS_UNEXP_ERROR',
870: x_msg_count,
871: x_msg_data,
872: '_PUB');
873: WHEN OTHERS THEN

Line 874: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

870: x_msg_count,
871: x_msg_data,
872: '_PUB');
873: WHEN OTHERS THEN
874: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
875: l_api_name,
876: G_PKG_NAME,
877: 'OTHERS',
878: x_msg_count,