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 382: x_return_status := OKL_API.G_RET_STS_SUCCESS;

378: --
379:
380:
381: BEGIN
382: x_return_status := OKL_API.G_RET_STS_SUCCESS;
383:
384: --Call start_activity to create savepoint, check compatibility and initialize message list
385:
386: x_return_status := OKL_API.START_ACTIVITY(

Line 386: x_return_status := OKL_API.START_ACTIVITY(

382: x_return_status := OKL_API.G_RET_STS_SUCCESS;
383:
384: --Call start_activity to create savepoint, check compatibility and initialize message list
385:
386: x_return_status := OKL_API.START_ACTIVITY(
387: l_api_name
388: ,p_init_msg_list
389: ,'_PUB'
390: ,x_return_status);

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

390: ,x_return_status);
391:
392: --Check if activity started successfully
393:
394: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
395: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
396: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
397: RAISE OKL_API.G_EXCEPTION_ERROR;
398: END IF;

Line 395: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

391:
392: --Check if activity started successfully
393:
394: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
395: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
396: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
397: RAISE OKL_API.G_EXCEPTION_ERROR;
398: END IF;
399:

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

392: --Check if activity started successfully
393:
394: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
395: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
396: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
397: RAISE OKL_API.G_EXCEPTION_ERROR;
398: END IF;
399:
400: --populating the header record

Line 397: RAISE OKL_API.G_EXCEPTION_ERROR;

393:
394: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
395: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
396: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
397: RAISE OKL_API.G_EXCEPTION_ERROR;
398: END IF;
399:
400: --populating the header record
401: l_tcnv_rec.id := p_header_tbl(1).id;

Line 493: OKL_API.END_ACTIVITY (x_msg_count,

489: x_taav_tbl => x_taav_tbl);
490:
491: commit;
492:
493: OKL_API.END_ACTIVITY (x_msg_count,
494: x_msg_data );
495:
496:
497: EXCEPTION

Line 498: WHEN OKL_API.G_EXCEPTION_ERROR THEN

494: x_msg_data );
495:
496:
497: EXCEPTION
498: WHEN OKL_API.G_EXCEPTION_ERROR THEN
499: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
500: l_api_name,
501: G_PKG_NAME,
502: 'OKL_API.G_RET_STS_ERROR',

Line 499: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

495:
496:
497: EXCEPTION
498: WHEN OKL_API.G_EXCEPTION_ERROR THEN
499: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
500: l_api_name,
501: G_PKG_NAME,
502: 'OKL_API.G_RET_STS_ERROR',
503: x_msg_count,

Line 502: 'OKL_API.G_RET_STS_ERROR',

498: WHEN OKL_API.G_EXCEPTION_ERROR THEN
499: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
500: l_api_name,
501: G_PKG_NAME,
502: 'OKL_API.G_RET_STS_ERROR',
503: x_msg_count,
504: x_msg_data,
505: '_PUB');
506: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 506: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

502: 'OKL_API.G_RET_STS_ERROR',
503: x_msg_count,
504: x_msg_data,
505: '_PUB');
506: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
507: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
508: l_api_name,
509: G_PKG_NAME,
510: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 507: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

503: x_msg_count,
504: x_msg_data,
505: '_PUB');
506: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
507: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
508: l_api_name,
509: G_PKG_NAME,
510: 'OKL_API.G_RET_STS_UNEXP_ERROR',
511: x_msg_count,

Line 510: 'OKL_API.G_RET_STS_UNEXP_ERROR',

506: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
507: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
508: l_api_name,
509: G_PKG_NAME,
510: 'OKL_API.G_RET_STS_UNEXP_ERROR',
511: x_msg_count,
512: x_msg_data,
513: '_PUB');
514: WHEN OTHERS THEN

Line 515: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

511: x_msg_count,
512: x_msg_data,
513: '_PUB');
514: WHEN OTHERS THEN
515: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
516: l_api_name,
517: G_PKG_NAME,
518: 'OTHERS',
519: x_msg_count,

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

623: WHERE owner_table_id = p_party_id
624: AND contact_point_type = 'PHONE';
625:
626:
627: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
628: l_api_name CONSTANT VARCHAR2(30) := 'Populate';
629: l_api_version CONSTANT NUMBER := 1;
630: l_id1 VARCHAR2(40);
631: l_id2 VARCHAR2(200);

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

668: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_CS_TRANSFER_ASSUMPTION_PVT.Populate_New_Lessee_details',
669: 'p_request_id :'||p_request_id);
670: END IF;
671:
672: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
673: G_PKG_NAME,
674: p_init_msg_list,
675: l_api_version,
676: p_api_version,

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

780: x_new_lessee_tbl(1).lease_policy_yn := l_taa_record.lease_policy_yn;
781:
782: x_return_status := l_return_status;
783:
784: OKL_API.END_ACTIVITY (x_msg_count, x_msg_data);
785: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
786: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_PROCESS_TAX.Create_Tax_Schedule ','End(-)');
787: END IF;
788:

Line 790: WHEN OKL_API.G_EXCEPTION_ERROR THEN

786: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_PROCESS_TAX.Create_Tax_Schedule ','End(-)');
787: END IF;
788:
789: EXCEPTION
790: WHEN OKL_API.G_EXCEPTION_ERROR THEN
791: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
792: l_api_name,
793: G_PKG_NAME,
794: 'OKL_API.G_RET_STS_ERROR',

Line 791: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

787: END IF;
788:
789: EXCEPTION
790: WHEN OKL_API.G_EXCEPTION_ERROR THEN
791: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
792: l_api_name,
793: G_PKG_NAME,
794: 'OKL_API.G_RET_STS_ERROR',
795: x_msg_count,

Line 794: 'OKL_API.G_RET_STS_ERROR',

790: WHEN OKL_API.G_EXCEPTION_ERROR THEN
791: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
792: l_api_name,
793: G_PKG_NAME,
794: 'OKL_API.G_RET_STS_ERROR',
795: x_msg_count,
796: x_msg_data,
797: '_PUB');
798: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 798: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

794: 'OKL_API.G_RET_STS_ERROR',
795: x_msg_count,
796: x_msg_data,
797: '_PUB');
798: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
799: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
800: l_api_name,
801: G_PKG_NAME,
802: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 799: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

795: x_msg_count,
796: x_msg_data,
797: '_PUB');
798: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
799: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
800: l_api_name,
801: G_PKG_NAME,
802: 'OKL_API.G_RET_STS_UNEXP_ERROR',
803: x_msg_count,

Line 802: 'OKL_API.G_RET_STS_UNEXP_ERROR',

798: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
799: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
800: l_api_name,
801: G_PKG_NAME,
802: 'OKL_API.G_RET_STS_UNEXP_ERROR',
803: x_msg_count,
804: x_msg_data,
805: '_PUB');
806: WHEN OTHERS THEN

Line 807: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

803: x_msg_count,
804: x_msg_data,
805: '_PUB');
806: WHEN OTHERS THEN
807: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
808: l_api_name,
809: G_PKG_NAME,
810: 'OTHERS',
811: x_msg_count,

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

834: FROM HZ_PARTIES PARTY
835: WHERE PARTY_ID = p_party_id;
836:
837:
838: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
839: l_api_name CONSTANT VARCHAR2(30) := 'Populate_Insurance_Details';
840: l_api_version CONSTANT NUMBER := 1;
841:
842: l_insurer VARCHAR2(360);

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

856: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_CS_TRANSFER_ASSUMPTION_PVT.Populate_Insurance_Details',
857: 'p_taa_id :'||p_taa_id);
858: END IF;
859:
860: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
861: G_PKG_NAME,
862: p_init_msg_list,
863: l_api_version,
864: p_api_version,

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

893: x_insurance_tbl(1).lessor_insured_yn := l_taa_record.lessor_insured_yn;
894: x_insurance_tbl(1).lessor_payee_yn := l_taa_record.lessor_payee_yn;
895:
896: x_return_status := l_return_status;
897: OKL_API.END_ACTIVITY (x_msg_count, x_msg_data);
898: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
899: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_CS_TRANSFER_ASSUMPTION_PVT.populate_thirdparty_insurance','End(-)');
900: END IF;
901:

Line 903: WHEN OKL_API.G_EXCEPTION_ERROR THEN

899: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_CS_TRANSFER_ASSUMPTION_PVT.populate_thirdparty_insurance','End(-)');
900: END IF;
901:
902: EXCEPTION
903: WHEN OKL_API.G_EXCEPTION_ERROR THEN
904: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
905: l_api_name,
906: G_PKG_NAME,
907: 'OKL_API.G_RET_STS_ERROR',

Line 904: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

900: END IF;
901:
902: EXCEPTION
903: WHEN OKL_API.G_EXCEPTION_ERROR THEN
904: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
905: l_api_name,
906: G_PKG_NAME,
907: 'OKL_API.G_RET_STS_ERROR',
908: x_msg_count,

Line 907: 'OKL_API.G_RET_STS_ERROR',

903: WHEN OKL_API.G_EXCEPTION_ERROR THEN
904: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
905: l_api_name,
906: G_PKG_NAME,
907: 'OKL_API.G_RET_STS_ERROR',
908: x_msg_count,
909: x_msg_data,
910: '_PUB');
911: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 911: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

907: 'OKL_API.G_RET_STS_ERROR',
908: x_msg_count,
909: x_msg_data,
910: '_PUB');
911: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
912: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
913: l_api_name,
914: G_PKG_NAME,
915: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 912: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

908: x_msg_count,
909: x_msg_data,
910: '_PUB');
911: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
912: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
913: l_api_name,
914: G_PKG_NAME,
915: 'OKL_API.G_RET_STS_UNEXP_ERROR',
916: x_msg_count,

Line 915: 'OKL_API.G_RET_STS_UNEXP_ERROR',

911: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
912: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
913: l_api_name,
914: G_PKG_NAME,
915: 'OKL_API.G_RET_STS_UNEXP_ERROR',
916: x_msg_count,
917: x_msg_data,
918: '_PUB');
919: WHEN OTHERS THEN

Line 920: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

916: x_msg_count,
917: x_msg_data,
918: '_PUB');
919: WHEN OTHERS THEN
920: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
921: l_api_name,
922: G_PKG_NAME,
923: 'OTHERS',
924: x_msg_count,