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

Line 8: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;

4: -------------------------------------------------------------------------------------------------
5: -- GLOBAL MESSAGE CONSTANTS
6: -------------------------------------------------------------------------------------------------
7: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKC_NO_PARENT_RECORD';
8: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
9: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
10: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
11: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
12: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

Line 9: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;

5: -- GLOBAL MESSAGE CONSTANTS
6: -------------------------------------------------------------------------------------------------
7: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKC_NO_PARENT_RECORD';
8: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
9: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
10: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
11: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
12: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
13: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

Line 10: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;

6: -------------------------------------------------------------------------------------------------
7: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKC_NO_PARENT_RECORD';
8: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
9: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
10: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
11: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
12: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
13: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
14: G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UPPERCASE_REQ';

Line 15: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

11: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
12: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
13: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
14: G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UPPERCASE_REQ';
15: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
16: ------------------------------------------------------------------------------------
17: -- GLOBAL EXCEPTION
18: ------------------------------------------------------------------------------------
19: G_EXCEPTION_HALT_VALIDATION EXCEPTION;

Line 67: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

63: -- End Of Comments
64: ----------------------------------------------------------------------------------
65: PROCEDURE additional_tai_attr(
66: p_api_version IN NUMBER
67: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
68: ,x_return_status OUT NOCOPY VARCHAR2
69: ,x_msg_count OUT NOCOPY NUMBER
70: ,x_msg_data OUT NOCOPY VARCHAR2
71: ,p_taiv_rec IN Okl_Trx_Ar_Invoices_Pub.taiv_rec_type

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

73: )
74: is
75: l_api_name CONSTANT VARCHAR2(30) := 'additional_tai_attr';
76: l_api_version CONSTANT NUMBER := 1.0;
77: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
78:
79: l_legal_entity_id okl_trx_ar_invoices_b.legal_entity_id%TYPE;
80:
81: l_jtot_object1_code okc_rules_b.jtot_object1_code%TYPE;

Line 221: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

217: p_api_version,
218: l_api_name,
219: G_PKG_NAME ))
220: THEN
221: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
222: END IF;
223:
224: -- Initialize message list if requested
225: IF (FND_API.to_Boolean(p_init_msg_list)) THEN

Line 230: x_return_status := OKL_API.G_RET_STS_SUCCESS;

226: FND_MSG_PUB.initialize;
227: END IF;
228:
229: -- Initialize API status to success
230: x_return_status := OKL_API.G_RET_STS_SUCCESS;
231:
232:
233: -- assign all passed in attributes from IN to OUT record
234: x_taiv_rec := p_taiv_rec;

Line 263: IF (p_taiv_rec.legal_entity_id IS NULL OR (p_taiv_rec.legal_entity_id = Okl_Api.G_MISS_NUM)) THEN

259: l_object1_id1 := NULL;
260: l_object1_id2 := NULL;
261: l_jtot_object2_code := NULL;
262:
263: IF (p_taiv_rec.legal_entity_id IS NULL OR (p_taiv_rec.legal_entity_id = Okl_Api.G_MISS_NUM)) THEN
264: l_legal_entity_id := OKL_LEGAL_ENTITY_UTIL.get_khr_le_id(l_khr_id);
265: ELSE
266: l_legal_entity_id := p_taiv_rec.legal_entity_id;
267: END IF;

Line 271: IF(p_taiv_rec.irm_id IS NULL OR p_taiv_rec.irm_id = Okl_Api.G_MISS_NUM) THEN

267: END IF;
268: x_taiv_rec.legal_entity_id := l_legal_entity_id;
269: --akrangan added for tax only invoice changes begin
270: --added gmiss condition
271: IF(p_taiv_rec.irm_id IS NULL OR p_taiv_rec.irm_id = Okl_Api.G_MISS_NUM) THEN
272: --akrangan added for tax only invoice changes end
273: OPEN rule_code_csr(l_khr_id, 'LAPMTH');
274: FETCH rule_code_csr
275: INTO l_jtot_object1_code,

Line 309: IF (p_taiv_rec.ixx_id IS NULL OR (p_taiv_rec.ixx_id = Okl_Api.G_MISS_NUM)) THEN

305: FETCH cur_address_billto
306: INTO billto_rec;
307: CLOSE cur_address_billto;
308:
309: IF (p_taiv_rec.ixx_id IS NULL OR (p_taiv_rec.ixx_id = Okl_Api.G_MISS_NUM)) THEN
310: x_taiv_rec.ixx_id := billto_rec.cust_account_id;
311: ELSE
312: x_taiv_rec.ixx_id := p_taiv_rec.ixx_id;
313: END IF;

Line 315: IF (p_taiv_rec.ibt_id IS NULL OR (p_taiv_rec.ibt_id = Okl_Api.G_MISS_NUM)) THEN

311: ELSE
312: x_taiv_rec.ixx_id := p_taiv_rec.ixx_id;
313: END IF;
314:
315: IF (p_taiv_rec.ibt_id IS NULL OR (p_taiv_rec.ibt_id = Okl_Api.G_MISS_NUM)) THEN
316: x_taiv_rec.ibt_id := billto_rec.cust_acct_site_id;
317: ELSE
318: x_taiv_rec.ibt_id := p_taiv_rec.ibt_id;
319: END IF;

Line 328: OR p_taiv_rec.irt_id = Okl_Api.G_MISS_NUM THEN

324: CLOSE std_terms_csr;
325: --akrangan added for tax only invoice changes begin
326: --changed for handling gmiss values
327: IF p_taiv_rec.irt_id IS NULL
328: OR p_taiv_rec.irt_id = Okl_Api.G_MISS_NUM THEN
329: x_taiv_rec.irt_id := l_term_id;
330: ELSE
331: x_taiv_rec.irt_id := p_taiv_rec.irt_id;
332: END IF;

Line 334: IF (p_taiv_rec.org_id IS NULL OR p_taiv_rec.org_id=OKL_API.G_MISS_NUM) THEN

330: ELSE
331: x_taiv_rec.irt_id := p_taiv_rec.irt_id;
332: END IF;
333: --akrangan added for tax only invoice changes end
334: IF (p_taiv_rec.org_id IS NULL OR p_taiv_rec.org_id=OKL_API.G_MISS_NUM) THEN
335:
336: OPEN org_id_csr(l_khr_id);
337: FETCH org_id_csr
338: INTO x_taiv_rec.org_id;

Line 391: IF (p_taiv_rec.set_of_books_id IS NULL OR p_taiv_rec.set_of_books_id = OKL_API.G_MISS_NUM) THEN

387: END IF; -- IF l_khr_id IS NOT NULL THEN
388:
389: --How to get the set_of_books_id ?
390:
391: IF (p_taiv_rec.set_of_books_id IS NULL OR p_taiv_rec.set_of_books_id = OKL_API.G_MISS_NUM) THEN
392: x_taiv_rec.set_of_books_id := Okl_Accounting_Util.get_set_of_books_id;
393: ELSE
394: x_taiv_rec.set_of_books_id := p_taiv_rec.set_of_books_id;
395: --TAI

Line 400: IF (p_taiv_rec.currency_code IS NULL OR p_taiv_rec.currency_code=OKL_API.G_MISS_CHAR) THEN

396: END IF;
397:
398: --Check for currency code
399:
400: IF (p_taiv_rec.currency_code IS NULL OR p_taiv_rec.currency_code=OKL_API.G_MISS_CHAR) THEN
401: x_taiv_rec.currency_code := l_currency_code;
402: ELSE
403: x_taiv_rec.currency_code := p_taiv_rec.currency_code;
404: END IF;

Line 408: IF (p_taiv_rec.currency_conversion_type IS NULL OR p_taiv_rec.currency_conversion_type = OKL_API.G_MISS_CHAR) THEN

404: END IF;
405:
406: --Check for currency conversion type
407:
408: IF (p_taiv_rec.currency_conversion_type IS NULL OR p_taiv_rec.currency_conversion_type = OKL_API.G_MISS_CHAR) THEN
409: x_taiv_rec.currency_conversion_type := l_currency_conversion_type;
410: ELSE
411: x_taiv_rec.currency_conversion_type := p_taiv_rec.currency_conversion_type;
412: END IF;

Line 422: IF (p_taiv_rec.currency_conversion_rate IS NULL OR p_taiv_rec.currency_conversion_rate=OKL_API.G_MISS_NUM) THEN

418: IF(p_taiv_rec.currency_code = Okl_Accounting_Util.get_func_curr_code) THEN
419: x_taiv_rec.currency_conversion_rate := 1;
420: ELSE
421:
422: IF (p_taiv_rec.currency_conversion_rate IS NULL OR p_taiv_rec.currency_conversion_rate=OKL_API.G_MISS_NUM) THEN
423: x_taiv_rec.currency_conversion_rate := l_currency_conversion_rate;
424: ELSE
425: x_taiv_rec.currency_conversion_rate := p_taiv_rec.currency_conversion_rate;
426: END IF;

Line 436: IF (p_taiv_rec.currency_conversion_date IS NULL OR p_taiv_rec.currency_conversion_date = OKL_API.G_MISS_DATE) THEN

432: END IF;
433:
434: --Check for currency conversion date
435:
436: IF (p_taiv_rec.currency_conversion_date IS NULL OR p_taiv_rec.currency_conversion_date = OKL_API.G_MISS_DATE) THEN
437: x_taiv_rec.currency_conversion_date := l_currency_conversion_date;
438: ELSE
439: x_taiv_rec.currency_conversion_date := p_taiv_rec.currency_conversion_date;
440: END IF;

Line 443: IF(p_taiv_rec.currency_conversion_type IS NULL OR p_taiv_rec.currency_conversion_date = OKL_API.G_MISS_DATE) THEN

439: x_taiv_rec.currency_conversion_date := p_taiv_rec.currency_conversion_date;
440: END IF;
441:
442:
443: IF(p_taiv_rec.currency_conversion_type IS NULL OR p_taiv_rec.currency_conversion_date = OKL_API.G_MISS_DATE) THEN
444: x_taiv_rec.currency_conversion_type := 'User';
445: x_taiv_rec.currency_conversion_rate := 1;
446: x_taiv_rec.currency_conversion_date := SYSDATE;
447: END IF;

Line 481: WHEN OKL_API.G_EXCEPTION_ERROR THEN

477: (p_count => x_msg_count,
478: p_data => x_msg_data);
479:
480: EXCEPTION
481: WHEN OKL_API.G_EXCEPTION_ERROR THEN
482: ROLLBACK TO additional_tai_attr;
483: x_return_status := OKL_API.G_RET_STS_ERROR;
484: FND_MSG_PUB.Count_And_Get
485: (p_count => x_msg_count,

Line 483: x_return_status := OKL_API.G_RET_STS_ERROR;

479:
480: EXCEPTION
481: WHEN OKL_API.G_EXCEPTION_ERROR THEN
482: ROLLBACK TO additional_tai_attr;
483: x_return_status := OKL_API.G_RET_STS_ERROR;
484: FND_MSG_PUB.Count_And_Get
485: (p_count => x_msg_count,
486: p_data => x_msg_data);
487:

Line 488: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

484: FND_MSG_PUB.Count_And_Get
485: (p_count => x_msg_count,
486: p_data => x_msg_data);
487:
488: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
489: ROLLBACK TO additional_tai_attr;
490: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
491: FND_MSG_PUB.Count_And_Get
492: (p_count => x_msg_count,

Line 490: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

486: p_data => x_msg_data);
487:
488: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
489: ROLLBACK TO additional_tai_attr;
490: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
491: FND_MSG_PUB.Count_And_Get
492: (p_count => x_msg_count,
493: p_data => x_msg_data);
494:

Line 497: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

493: p_data => x_msg_data);
494:
495: WHEN OTHERS THEN
496: ROLLBACK TO additional_tai_attr;
497: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
498: OKL_API.Set_Message(p_app_name => G_APP_NAME,
499: p_msg_name => G_UNEXPECTED_ERROR,
500: p_token1 => G_SQLCODE_TOKEN,
501: p_token1_value => SQLCODE,

Line 498: OKL_API.Set_Message(p_app_name => G_APP_NAME,

494:
495: WHEN OTHERS THEN
496: ROLLBACK TO additional_tai_attr;
497: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
498: OKL_API.Set_Message(p_app_name => G_APP_NAME,
499: p_msg_name => G_UNEXPECTED_ERROR,
500: p_token1 => G_SQLCODE_TOKEN,
501: p_token1_value => SQLCODE,
502: p_token2 => G_SQLERRM_TOKEN,

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

518: x_msg_data OUT NOCOPY VARCHAR2) IS
519:
520: l_api_name CONSTANT VARCHAR2(30) := 'BILL_UPFRONT_TAX';
521: l_api_version CONSTANT NUMBER := 1;
522: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
523:
524: l_line_code CONSTANT VARCHAR2(30) := 'LINE';
525: l_zero_amount CONSTANT NUMBER := 0;
526: l_def_desc CONSTANT VARCHAR2(30) := 'Upfront Tax Billing';

Line 738: x_return_status := OKL_API.START_ACTIVITY(

734: --akrangan ebtax billing impacts coding end
735:
736: BEGIN
737:
738: x_return_status := OKL_API.START_ACTIVITY(
739: p_api_name => l_api_name,
740: p_pkg_name => g_pkg_name,
741: p_init_msg_list => p_init_msg_list,
742: l_api_version => l_api_version,

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

744: p_api_type => G_API_TYPE,
745: x_return_status => x_return_status);
746:
747: -- check if activity started successfully
748: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
749: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
750: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
751: RAISE OKL_API.G_EXCEPTION_ERROR;
752: END IF;

Line 749: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

745: x_return_status => x_return_status);
746:
747: -- check if activity started successfully
748: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
749: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
750: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
751: RAISE OKL_API.G_EXCEPTION_ERROR;
752: END IF;
753:

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

746:
747: -- check if activity started successfully
748: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
749: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
750: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
751: RAISE OKL_API.G_EXCEPTION_ERROR;
752: END IF;
753:
754: -- Populate Billing Header Record

Line 751: RAISE OKL_API.G_EXCEPTION_ERROR;

747: -- check if activity started successfully
748: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
749: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
750: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
751: RAISE OKL_API.G_EXCEPTION_ERROR;
752: END IF;
753:
754: -- Populate Billing Header Record
755: lp_taiv_rec := l_init_taiv_rec;

Line 792: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

788: ,x_msg_data => x_msg_data
789: ,p_taiv_rec => lp_taiv_rec
790: ,x_taiv_rec => lx_taiv_rec
791: );
792: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
793: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
794: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
795: raise OKL_API.G_EXCEPTION_ERROR;
796: END IF;

Line 793: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

789: ,p_taiv_rec => lp_taiv_rec
790: ,x_taiv_rec => lx_taiv_rec
791: );
792: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
793: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
794: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
795: raise OKL_API.G_EXCEPTION_ERROR;
796: END IF;
797: --akrangan added for populating additional attributes for taiv_rec end

Line 794: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

790: ,x_taiv_rec => lx_taiv_rec
791: );
792: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
793: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
794: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
795: raise OKL_API.G_EXCEPTION_ERROR;
796: END IF;
797: --akrangan added for populating additional attributes for taiv_rec end
798: -- Create Billing Header Record

Line 795: raise OKL_API.G_EXCEPTION_ERROR;

791: );
792: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
793: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
794: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
795: raise OKL_API.G_EXCEPTION_ERROR;
796: END IF;
797: --akrangan added for populating additional attributes for taiv_rec end
798: -- Create Billing Header Record
799:

Line 810: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

806: ,x_msg_data => x_msg_data
807: ,p_taiv_rec => lx_taiv_rec
808: ,x_taiv_rec => xp_taiv_rec);
809:
810: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
811: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
812: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
813: raise OKL_API.G_EXCEPTION_ERROR;
814: END IF;

Line 811: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

807: ,p_taiv_rec => lx_taiv_rec
808: ,x_taiv_rec => xp_taiv_rec);
809:
810: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
811: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
812: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
813: raise OKL_API.G_EXCEPTION_ERROR;
814: END IF;
815:

Line 812: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

808: ,x_taiv_rec => xp_taiv_rec);
809:
810: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
811: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
812: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
813: raise OKL_API.G_EXCEPTION_ERROR;
814: END IF;
815:
816:

Line 813: raise OKL_API.G_EXCEPTION_ERROR;

809:
810: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
811: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
812: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
813: raise OKL_API.G_EXCEPTION_ERROR;
814: END IF;
815:
816:
817: OPEN upfront_tax_csr(p_khr_id => p_khr_id);

Line 1118: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

1114: ,x_msg_data => x_msg_data
1115: ,p_taiv_rec => lp_taiv_rec
1116: ,x_taiv_rec => lx_taiv_rec);
1117:
1118: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1119: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1120: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
1121: raise OKL_API.G_EXCEPTION_ERROR;
1122: END IF;

Line 1119: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1115: ,p_taiv_rec => lp_taiv_rec
1116: ,x_taiv_rec => lx_taiv_rec);
1117:
1118: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1119: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1120: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
1121: raise OKL_API.G_EXCEPTION_ERROR;
1122: END IF;
1123:

Line 1120: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

1116: ,x_taiv_rec => lx_taiv_rec);
1117:
1118: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1119: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1120: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
1121: raise OKL_API.G_EXCEPTION_ERROR;
1122: END IF;
1123:
1124:

Line 1121: raise OKL_API.G_EXCEPTION_ERROR;

1117:
1118: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1119: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1120: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
1121: raise OKL_API.G_EXCEPTION_ERROR;
1122: END IF;
1123:
1124:
1125: --use for all i loop and bulk insert into invoice lines table

Line 1142: okl_api.set_message(p_app_name => 'OKL',

1138: IF SQL%bulk_exceptions.COUNT > 0
1139: THEN
1140: FOR i IN 1 .. SQL%bulk_exceptions.COUNT
1141: LOOP
1142: okl_api.set_message(p_app_name => 'OKL',
1143: p_msg_name => 'OKL_TX_TRX_INS_ERR',
1144: p_token1 => 'TABLE_NAME',
1145: p_token1_value => 'OKL_TXL_AR_INV_LNS_B',
1146: p_token2 => 'ERROR_CODE',

Line 1153: x_return_status := okl_api.g_ret_sts_error;

1149: p_token3 => 'ITERATION',
1150: p_token3_value => SQL%bulk_exceptions(i)
1151: .error_index);
1152: END LOOP;
1153: x_return_status := okl_api.g_ret_sts_error;
1154: RAISE okl_api.g_exception_error;
1155: END IF;
1156: END;
1157: --invoice line details population

Line 1154: RAISE okl_api.g_exception_error;

1150: p_token3_value => SQL%bulk_exceptions(i)
1151: .error_index);
1152: END LOOP;
1153: x_return_status := okl_api.g_ret_sts_error;
1154: RAISE okl_api.g_exception_error;
1155: END IF;
1156: END;
1157: --invoice line details population
1158: BEGIN

Line 1173: okl_api.set_message(p_app_name => 'OKL',

1169: IF SQL%bulk_exceptions.COUNT > 0
1170: THEN
1171: FOR i IN 1 .. SQL%bulk_exceptions.COUNT
1172: LOOP
1173: okl_api.set_message(p_app_name => 'OKL',
1174: p_msg_name => 'OKL_TX_TRX_INS_ERR',
1175: p_token1 => 'TABLE_NAME',
1176: p_token1_value => 'OKL_TXD_AR_LN_DTLS_B',
1177: p_token2 => 'ERROR_CODE',

Line 1184: x_return_status := okl_api.g_ret_sts_error;

1180: p_token3 => 'ITERATION',
1181: p_token3_value => SQL%bulk_exceptions(i)
1182: .error_index);
1183: END LOOP;
1184: x_return_status := okl_api.g_ret_sts_error;
1185: RAISE okl_api.g_exception_error;
1186: END IF;
1187: END;
1188: --Bulk insert into okl_txl_ar_inv_lns_tl

Line 1185: RAISE okl_api.g_exception_error;

1181: p_token3_value => SQL%bulk_exceptions(i)
1182: .error_index);
1183: END LOOP;
1184: x_return_status := okl_api.g_ret_sts_error;
1185: RAISE okl_api.g_exception_error;
1186: END IF;
1187: END;
1188: --Bulk insert into okl_txl_ar_inv_lns_tl
1189: --tl table insert

Line 1205: okl_api.set_message(p_app_name => 'OKL',

1201: IF SQL%bulk_exceptions.COUNT > 0
1202: THEN
1203: FOR i IN 1 .. SQL%bulk_exceptions.COUNT
1204: LOOP
1205: okl_api.set_message(p_app_name => 'OKL',
1206: p_msg_name => 'OKL_TX_TRX_INS_ERR',
1207: p_token1 => 'TABLE_NAME',
1208: p_token1_value => 'OKL_TXL_AR_INV_LNS_B',
1209: p_token2 => 'ERROR_CODE',

Line 1216: x_return_status := okl_api.g_ret_sts_error;

1212: p_token3 => 'ITERATION',
1213: p_token3_value => SQL%bulk_exceptions(i)
1214: .error_index);
1215: END LOOP;
1216: x_return_status := okl_api.g_ret_sts_error;
1217: RAISE okl_api.g_exception_error;
1218: END IF;
1219: END;
1220: --line details table

Line 1217: RAISE okl_api.g_exception_error;

1213: p_token3_value => SQL%bulk_exceptions(i)
1214: .error_index);
1215: END LOOP;
1216: x_return_status := okl_api.g_ret_sts_error;
1217: RAISE okl_api.g_exception_error;
1218: END IF;
1219: END;
1220: --line details table
1221: --akrangan ebtax billing impacts coding ends

Line 1223: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1219: END;
1220: --line details table
1221: --akrangan ebtax billing impacts coding ends
1222:
1223: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1224:
1225: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1226:
1227: EXCEPTION

Line 1225: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

1221: --akrangan ebtax billing impacts coding ends
1222:
1223: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1224:
1225: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1226:
1227: EXCEPTION
1228: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1229:

Line 1228: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1224:
1225: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1226:
1227: EXCEPTION
1228: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1229:
1230: --sechawla 13-may-2008 6619311
1231: IF zx_lines_csr%ISOPEN THEN
1232: CLOSE zx_lines_csr;

Line 1268: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1264: IF cust_trx_type_csr%ISOPEN THEN
1265: CLOSE cust_trx_type_csr;
1266: END IF;
1267:
1268: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1269: p_api_name => l_api_name,
1270: p_pkg_name => g_pkg_name,
1271: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1272: x_msg_count => x_msg_count,

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

1267:
1268: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1269: p_api_name => l_api_name,
1270: p_pkg_name => g_pkg_name,
1271: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1272: x_msg_count => x_msg_count,
1273: x_msg_data => x_msg_data,
1274: p_api_type => g_api_type);
1275:

Line 1276: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1272: x_msg_count => x_msg_count,
1273: x_msg_data => x_msg_data,
1274: p_api_type => g_api_type);
1275:
1276: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1277:
1278: --sechawla 13-may-2008 6619311
1279: IF zx_lines_csr%ISOPEN THEN
1280: CLOSE zx_lines_csr;

Line 1316: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1312: IF cust_trx_type_csr%ISOPEN THEN
1313: CLOSE cust_trx_type_csr;
1314: END IF;
1315:
1316: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1317: p_api_name => l_api_name,
1318: p_pkg_name => g_pkg_name,
1319: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1320: x_msg_count => x_msg_count,

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

1315:
1316: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1317: p_api_name => l_api_name,
1318: p_pkg_name => g_pkg_name,
1319: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1320: x_msg_count => x_msg_count,
1321: x_msg_data => x_msg_data,
1322: p_api_type => g_api_type);
1323:

Line 1363: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1359: IF cust_trx_type_csr%ISOPEN THEN
1360: CLOSE cust_trx_type_csr;
1361: END IF;
1362:
1363: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1364: p_api_name => l_api_name,
1365: p_pkg_name => g_pkg_name,
1366: p_exc_name => 'OTHERS',
1367: x_msg_count => x_msg_count,