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 76: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

72: -- End Of Comments
73: ----------------------------------------------------------------------------------
74: PROCEDURE additional_tai_attr(
75: p_api_version IN NUMBER
76: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
77: ,x_return_status OUT NOCOPY VARCHAR2
78: ,x_msg_count OUT NOCOPY NUMBER
79: ,x_msg_data OUT NOCOPY VARCHAR2
80: ,p_taiv_rec IN Okl_Trx_Ar_Invoices_Pub.taiv_rec_type

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

82: )
83: is
84: l_api_name CONSTANT VARCHAR2(30) := 'additional_tai_attr';
85: l_api_version CONSTANT NUMBER := 1.0;
86: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
87:
88: l_legal_entity_id okl_trx_ar_invoices_b.legal_entity_id%TYPE;
89:
90: l_jtot_object1_code okc_rules_b.jtot_object1_code%TYPE;

Line 230: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

226: p_api_version,
227: l_api_name,
228: G_PKG_NAME ))
229: THEN
230: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
231: END IF;
232:
233: -- Initialize message list if requested
234: IF (FND_API.to_Boolean(p_init_msg_list)) THEN

Line 239: x_return_status := OKL_API.G_RET_STS_SUCCESS;

235: FND_MSG_PUB.initialize;
236: END IF;
237:
238: -- Initialize API status to success
239: x_return_status := OKL_API.G_RET_STS_SUCCESS;
240:
241:
242: -- assign all passed in attributes from IN to OUT record
243: x_taiv_rec := p_taiv_rec;

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

268: l_object1_id1 := NULL;
269: l_object1_id2 := NULL;
270: l_jtot_object2_code := NULL;
271:
272: IF (p_taiv_rec.legal_entity_id IS NULL OR (p_taiv_rec.legal_entity_id = Okl_Api.G_MISS_NUM)) THEN
273: l_legal_entity_id := OKL_LEGAL_ENTITY_UTIL.get_khr_le_id(l_khr_id);
274: ELSE
275: l_legal_entity_id := p_taiv_rec.legal_entity_id;
276: END IF;

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

276: END IF;
277: x_taiv_rec.legal_entity_id := l_legal_entity_id;
278: --akrangan added for tax only invoice changes begin
279: --added gmiss condition
280: IF(p_taiv_rec.irm_id IS NULL OR p_taiv_rec.irm_id = Okl_Api.G_MISS_NUM) THEN
281: --akrangan added for tax only invoice changes end
282: OPEN rule_code_csr(l_khr_id, 'LAPMTH');
283: FETCH rule_code_csr
284: INTO l_jtot_object1_code,

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

314: FETCH cur_address_billto
315: INTO billto_rec;
316: CLOSE cur_address_billto;
317:
318: IF (p_taiv_rec.ixx_id IS NULL OR (p_taiv_rec.ixx_id = Okl_Api.G_MISS_NUM)) THEN
319: x_taiv_rec.ixx_id := billto_rec.cust_account_id;
320: ELSE
321: x_taiv_rec.ixx_id := p_taiv_rec.ixx_id;
322: END IF;

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

320: ELSE
321: x_taiv_rec.ixx_id := p_taiv_rec.ixx_id;
322: END IF;
323:
324: IF (p_taiv_rec.ibt_id IS NULL OR (p_taiv_rec.ibt_id = Okl_Api.G_MISS_NUM)) THEN
325: x_taiv_rec.ibt_id := billto_rec.cust_acct_site_id;
326: ELSE
327: x_taiv_rec.ibt_id := p_taiv_rec.ibt_id;
328: END IF;

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

333: CLOSE std_terms_csr;
334: --akrangan added for tax only invoice changes begin
335: --changed for handling gmiss values
336: IF p_taiv_rec.irt_id IS NULL
337: OR p_taiv_rec.irt_id = Okl_Api.G_MISS_NUM THEN
338: x_taiv_rec.irt_id := l_term_id;
339: ELSE
340: x_taiv_rec.irt_id := p_taiv_rec.irt_id;
341: END IF;

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

339: ELSE
340: x_taiv_rec.irt_id := p_taiv_rec.irt_id;
341: END IF;
342: --akrangan added for tax only invoice changes end
343: IF (p_taiv_rec.org_id IS NULL OR p_taiv_rec.org_id=OKL_API.G_MISS_NUM) THEN
344:
345: OPEN org_id_csr(l_khr_id);
346: FETCH org_id_csr
347: INTO x_taiv_rec.org_id;

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

396: END IF; -- IF l_khr_id IS NOT NULL THEN
397:
398: --How to get the set_of_books_id ?
399:
400: IF (p_taiv_rec.set_of_books_id IS NULL OR p_taiv_rec.set_of_books_id = OKL_API.G_MISS_NUM) THEN
401: x_taiv_rec.set_of_books_id := Okl_Accounting_Util.get_set_of_books_id;
402: ELSE
403: x_taiv_rec.set_of_books_id := p_taiv_rec.set_of_books_id;
404: --TAI

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

405: END IF;
406:
407: --Check for currency code
408:
409: IF (p_taiv_rec.currency_code IS NULL OR p_taiv_rec.currency_code=OKL_API.G_MISS_CHAR) THEN
410: x_taiv_rec.currency_code := l_currency_code;
411: ELSE
412: x_taiv_rec.currency_code := p_taiv_rec.currency_code;
413: END IF;

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

413: END IF;
414:
415: --Check for currency conversion type
416:
417: IF (p_taiv_rec.currency_conversion_type IS NULL OR p_taiv_rec.currency_conversion_type = OKL_API.G_MISS_CHAR) THEN
418: x_taiv_rec.currency_conversion_type := l_currency_conversion_type;
419: ELSE
420: x_taiv_rec.currency_conversion_type := p_taiv_rec.currency_conversion_type;
421: END IF;

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

427: IF(p_taiv_rec.currency_code = Okl_Accounting_Util.get_func_curr_code) THEN
428: x_taiv_rec.currency_conversion_rate := 1;
429: ELSE
430:
431: IF (p_taiv_rec.currency_conversion_rate IS NULL OR p_taiv_rec.currency_conversion_rate=OKL_API.G_MISS_NUM) THEN
432: x_taiv_rec.currency_conversion_rate := l_currency_conversion_rate;
433: ELSE
434: x_taiv_rec.currency_conversion_rate := p_taiv_rec.currency_conversion_rate;
435: END IF;

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

441: END IF;
442:
443: --Check for currency conversion date
444:
445: IF (p_taiv_rec.currency_conversion_date IS NULL OR p_taiv_rec.currency_conversion_date = OKL_API.G_MISS_DATE) THEN
446: x_taiv_rec.currency_conversion_date := l_currency_conversion_date;
447: ELSE
448: x_taiv_rec.currency_conversion_date := p_taiv_rec.currency_conversion_date;
449: END IF;

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

448: x_taiv_rec.currency_conversion_date := p_taiv_rec.currency_conversion_date;
449: END IF;
450:
451:
452: IF(p_taiv_rec.currency_conversion_type IS NULL OR p_taiv_rec.currency_conversion_date = OKL_API.G_MISS_DATE) THEN
453: x_taiv_rec.currency_conversion_type := 'User';
454: x_taiv_rec.currency_conversion_rate := 1;
455: x_taiv_rec.currency_conversion_date := SYSDATE;
456: END IF;

Line 490: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 492: x_return_status := OKL_API.G_RET_STS_ERROR;

488:
489: EXCEPTION
490: WHEN OKL_API.G_EXCEPTION_ERROR THEN
491: ROLLBACK TO additional_tai_attr;
492: x_return_status := OKL_API.G_RET_STS_ERROR;
493: FND_MSG_PUB.Count_And_Get
494: (p_count => x_msg_count,
495: p_data => x_msg_data);
496:

Line 497: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

493: FND_MSG_PUB.Count_And_Get
494: (p_count => x_msg_count,
495: p_data => x_msg_data);
496:
497: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
498: ROLLBACK TO additional_tai_attr;
499: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
500: FND_MSG_PUB.Count_And_Get
501: (p_count => x_msg_count,

Line 499: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

495: p_data => x_msg_data);
496:
497: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
498: ROLLBACK TO additional_tai_attr;
499: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
500: FND_MSG_PUB.Count_And_Get
501: (p_count => x_msg_count,
502: p_data => x_msg_data);
503:

Line 506: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

502: p_data => x_msg_data);
503:
504: WHEN OTHERS THEN
505: ROLLBACK TO additional_tai_attr;
506: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
507: OKL_API.Set_Message(p_app_name => G_APP_NAME,
508: p_msg_name => G_UNEXPECTED_ERROR,
509: p_token1 => G_SQLCODE_TOKEN,
510: p_token1_value => SQLCODE,

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

503:
504: WHEN OTHERS THEN
505: ROLLBACK TO additional_tai_attr;
506: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
507: OKL_API.Set_Message(p_app_name => G_APP_NAME,
508: p_msg_name => G_UNEXPECTED_ERROR,
509: p_token1 => G_SQLCODE_TOKEN,
510: p_token1_value => SQLCODE,
511: p_token2 => G_SQLERRM_TOKEN,

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

527: x_msg_data OUT NOCOPY VARCHAR2) IS
528:
529: l_api_name CONSTANT VARCHAR2(30) := 'BILL_UPFRONT_TAX';
530: l_api_version CONSTANT NUMBER := 1;
531: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
532:
533: l_line_code CONSTANT VARCHAR2(30) := 'LINE';
534: l_zero_amount CONSTANT NUMBER := 0;
535: l_def_desc CONSTANT VARCHAR2(30) := 'Upfront Tax Billing';

Line 767: x_return_status := OKL_API.START_ACTIVITY(

763: -- End -- Bug 906799
764:
765: BEGIN
766:
767: x_return_status := OKL_API.START_ACTIVITY(
768: p_api_name => l_api_name,
769: p_pkg_name => g_pkg_name,
770: p_init_msg_list => p_init_msg_list,
771: l_api_version => l_api_version,

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

773: p_api_type => G_API_TYPE,
774: x_return_status => x_return_status);
775:
776: -- check if activity started successfully
777: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
778: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
779: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
780: RAISE OKL_API.G_EXCEPTION_ERROR;
781: END IF;

Line 778: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

774: x_return_status => x_return_status);
775:
776: -- check if activity started successfully
777: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
778: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
779: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
780: RAISE OKL_API.G_EXCEPTION_ERROR;
781: END IF;
782:

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

775:
776: -- check if activity started successfully
777: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
778: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
779: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
780: RAISE OKL_API.G_EXCEPTION_ERROR;
781: END IF;
782:
783: IF (G_DEBUG_ENABLED = 'Y') THEN

Line 780: RAISE OKL_API.G_EXCEPTION_ERROR;

776: -- check if activity started successfully
777: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
778: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
779: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
780: RAISE OKL_API.G_EXCEPTION_ERROR;
781: END IF;
782:
783: IF (G_DEBUG_ENABLED = 'Y') THEN
784: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

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

820: ,x_msg_data => x_msg_data
821: ,p_taiv_rec => lp_taiv_rec
822: ,x_taiv_rec => lx_taiv_rec
823: );
824: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
825: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
826: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
827: raise OKL_API.G_EXCEPTION_ERROR;
828: END IF;

Line 825: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

821: ,p_taiv_rec => lp_taiv_rec
822: ,x_taiv_rec => lx_taiv_rec
823: );
824: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
825: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
826: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
827: raise OKL_API.G_EXCEPTION_ERROR;
828: END IF;
829: --akrangan added for populating additional attributes for taiv_rec end

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

822: ,x_taiv_rec => lx_taiv_rec
823: );
824: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
825: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
826: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
827: raise OKL_API.G_EXCEPTION_ERROR;
828: END IF;
829: --akrangan added for populating additional attributes for taiv_rec end
830: -- Create Billing Header Record

Line 827: raise OKL_API.G_EXCEPTION_ERROR;

823: );
824: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
825: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
826: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
827: raise OKL_API.G_EXCEPTION_ERROR;
828: END IF;
829: --akrangan added for populating additional attributes for taiv_rec end
830: -- Create Billing Header Record
831:

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

838: ,x_msg_data => x_msg_data
839: ,p_taiv_rec => lx_taiv_rec
840: ,x_taiv_rec => xp_taiv_rec);
841:
842: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
843: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
844: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
845: raise OKL_API.G_EXCEPTION_ERROR;
846: END IF;

Line 843: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

839: ,p_taiv_rec => lx_taiv_rec
840: ,x_taiv_rec => xp_taiv_rec);
841:
842: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
843: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
844: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
845: raise OKL_API.G_EXCEPTION_ERROR;
846: END IF;
847:

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

840: ,x_taiv_rec => xp_taiv_rec);
841:
842: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
843: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
844: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
845: raise OKL_API.G_EXCEPTION_ERROR;
846: END IF;
847:
848:

Line 845: raise OKL_API.G_EXCEPTION_ERROR;

841:
842: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
843: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
844: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
845: raise OKL_API.G_EXCEPTION_ERROR;
846: END IF;
847:
848:
849: OPEN upfront_tax_csr(p_khr_id => p_khr_id);

Line 972: ,p_init_msg_list => OKL_API.G_FALSE

968: END IF;
969:
970: OKL_INTERNAL_BILLING_PVT.Get_Invoice_format(
971: p_api_version => p_api_version
972: ,p_init_msg_list => OKL_API.G_FALSE
973: ,x_return_status => l_return_status
974: ,x_msg_count => x_msg_count
975: ,x_msg_data => x_msg_data
976: ,p_inf_id => lx_taiv_rec.inf_id

Line 1117: ,p_init_msg_list => OKL_API.G_FALSE

1113: END IF;
1114:
1115: OKL_INTERNAL_BILLING_PVT.Get_Invoice_format(
1116: p_api_version => p_api_version
1117: ,p_init_msg_list => OKL_API.G_FALSE
1118: ,x_return_status => l_return_status
1119: ,x_msg_count => x_msg_count
1120: ,x_msg_data => x_msg_data
1121: ,p_inf_id => lx_taiv_rec.inf_id

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

1186: ,x_msg_data => x_msg_data
1187: ,p_taiv_rec => lp_taiv_rec
1188: ,x_taiv_rec => lx_taiv_rec);
1189:
1190: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1191: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1192: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
1193: raise OKL_API.G_EXCEPTION_ERROR;
1194: END IF;

Line 1191: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1187: ,p_taiv_rec => lp_taiv_rec
1188: ,x_taiv_rec => lx_taiv_rec);
1189:
1190: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1191: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1192: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
1193: raise OKL_API.G_EXCEPTION_ERROR;
1194: END IF;
1195:

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

1188: ,x_taiv_rec => lx_taiv_rec);
1189:
1190: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1191: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1192: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
1193: raise OKL_API.G_EXCEPTION_ERROR;
1194: END IF;
1195:
1196:

Line 1193: raise OKL_API.G_EXCEPTION_ERROR;

1189:
1190: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1191: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1192: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
1193: raise OKL_API.G_EXCEPTION_ERROR;
1194: END IF;
1195:
1196:
1197: --use for all i loop and bulk insert into invoice lines table

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

1210: IF SQL%bulk_exceptions.COUNT > 0
1211: THEN
1212: FOR i IN 1 .. SQL%bulk_exceptions.COUNT
1213: LOOP
1214: okl_api.set_message(p_app_name => 'OKL',
1215: p_msg_name => 'OKL_TX_TRX_INS_ERR',
1216: p_token1 => 'TABLE_NAME',
1217: p_token1_value => 'OKL_TXL_AR_INV_LNS_B',
1218: p_token2 => 'ERROR_CODE',

Line 1225: x_return_status := okl_api.g_ret_sts_error;

1221: p_token3 => 'ITERATION',
1222: p_token3_value => SQL%bulk_exceptions(i)
1223: .error_index);
1224: END LOOP;
1225: x_return_status := okl_api.g_ret_sts_error;
1226: RAISE okl_api.g_exception_error;
1227: END IF;
1228: END;
1229: --invoice line details population

Line 1226: RAISE okl_api.g_exception_error;

1222: p_token3_value => SQL%bulk_exceptions(i)
1223: .error_index);
1224: END LOOP;
1225: x_return_status := okl_api.g_ret_sts_error;
1226: RAISE okl_api.g_exception_error;
1227: END IF;
1228: END;
1229: --invoice line details population
1230: BEGIN

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

1269: IF SQL%bulk_exceptions.COUNT > 0
1270: THEN
1271: FOR i IN 1 .. SQL%bulk_exceptions.COUNT
1272: LOOP
1273: okl_api.set_message(p_app_name => 'OKL',
1274: p_msg_name => 'OKL_TX_TRX_INS_ERR',
1275: p_token1 => 'TABLE_NAME',
1276: p_token1_value => 'OKL_TXD_AR_LN_DTLS_B',
1277: p_token2 => 'ERROR_CODE',

Line 1284: x_return_status := okl_api.g_ret_sts_error;

1280: p_token3 => 'ITERATION',
1281: p_token3_value => SQL%bulk_exceptions(i)
1282: .error_index);
1283: END LOOP;
1284: x_return_status := okl_api.g_ret_sts_error;
1285: RAISE okl_api.g_exception_error;
1286: END IF;
1287: END;
1288: --Bulk insert into okl_txl_ar_inv_lns_tl

Line 1285: RAISE okl_api.g_exception_error;

1281: p_token3_value => SQL%bulk_exceptions(i)
1282: .error_index);
1283: END LOOP;
1284: x_return_status := okl_api.g_ret_sts_error;
1285: RAISE okl_api.g_exception_error;
1286: END IF;
1287: END;
1288: --Bulk insert into okl_txl_ar_inv_lns_tl
1289: --tl table insert

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

1301: IF SQL%bulk_exceptions.COUNT > 0
1302: THEN
1303: FOR i IN 1 .. SQL%bulk_exceptions.COUNT
1304: LOOP
1305: okl_api.set_message(p_app_name => 'OKL',
1306: p_msg_name => 'OKL_TX_TRX_INS_ERR',
1307: p_token1 => 'TABLE_NAME',
1308: p_token1_value => 'OKL_TXL_AR_INV_LNS_B',
1309: p_token2 => 'ERROR_CODE',

Line 1316: x_return_status := okl_api.g_ret_sts_error;

1312: p_token3 => 'ITERATION',
1313: p_token3_value => SQL%bulk_exceptions(i)
1314: .error_index);
1315: END LOOP;
1316: x_return_status := okl_api.g_ret_sts_error;
1317: RAISE okl_api.g_exception_error;
1318: END IF;
1319: END;
1320: --line details table

Line 1317: RAISE okl_api.g_exception_error;

1313: p_token3_value => SQL%bulk_exceptions(i)
1314: .error_index);
1315: END LOOP;
1316: x_return_status := okl_api.g_ret_sts_error;
1317: RAISE okl_api.g_exception_error;
1318: END IF;
1319: END;
1320: --line details table
1321: --akrangan ebtax billing impacts coding ends

Line 1405: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

1401: p_tldv_tbl => l_tldv_tbl,
1402: p_tai_id => lx_taiv_rec.ID
1403: );
1404:
1405: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
1406: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1407: x_return_status := x_return_status;
1408: END IF;
1409: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1406: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1402: p_tai_id => lx_taiv_rec.ID
1403: );
1404:
1405: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
1406: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1407: x_return_status := x_return_status;
1408: END IF;
1409: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1410: END IF;

Line 1409: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1405: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
1406: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1407: x_return_status := x_return_status;
1408: END IF;
1409: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1410: END IF;
1411: END IF;
1412: END IF;
1413: -- End Bug 9523844

Line 1415: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1411: END IF;
1412: END IF;
1413: -- End Bug 9523844
1414:
1415: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1416:
1417: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1418:
1419: EXCEPTION

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

1413: -- End Bug 9523844
1414:
1415: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1416:
1417: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1418:
1419: EXCEPTION
1420: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1421:

Line 1420: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1416:
1417: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1418:
1419: EXCEPTION
1420: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1421:
1422: --sechawla 13-may-2008 6619311
1423: IF zx_lines_csr%ISOPEN THEN
1424: CLOSE zx_lines_csr;

Line 1460: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1456: IF cust_trx_type_csr%ISOPEN THEN
1457: CLOSE cust_trx_type_csr;
1458: END IF;
1459:
1460: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1461: p_api_name => l_api_name,
1462: p_pkg_name => g_pkg_name,
1463: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1464: x_msg_count => x_msg_count,

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

1459:
1460: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1461: p_api_name => l_api_name,
1462: p_pkg_name => g_pkg_name,
1463: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1464: x_msg_count => x_msg_count,
1465: x_msg_data => x_msg_data,
1466: p_api_type => g_api_type);
1467:

Line 1468: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1464: x_msg_count => x_msg_count,
1465: x_msg_data => x_msg_data,
1466: p_api_type => g_api_type);
1467:
1468: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1469:
1470: --sechawla 13-may-2008 6619311
1471: IF zx_lines_csr%ISOPEN THEN
1472: CLOSE zx_lines_csr;

Line 1508: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1504: IF cust_trx_type_csr%ISOPEN THEN
1505: CLOSE cust_trx_type_csr;
1506: END IF;
1507:
1508: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1509: p_api_name => l_api_name,
1510: p_pkg_name => g_pkg_name,
1511: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1512: x_msg_count => x_msg_count,

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

1507:
1508: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1509: p_api_name => l_api_name,
1510: p_pkg_name => g_pkg_name,
1511: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1512: x_msg_count => x_msg_count,
1513: x_msg_data => x_msg_data,
1514: p_api_type => g_api_type);
1515:

Line 1555: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1551: IF cust_trx_type_csr%ISOPEN THEN
1552: CLOSE cust_trx_type_csr;
1553: END IF;
1554:
1555: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1556: p_api_name => l_api_name,
1557: p_pkg_name => g_pkg_name,
1558: p_exc_name => 'OTHERS',
1559: x_msg_count => x_msg_count,