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

Line 51: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

47: ----------------------------------------------------------------------------------
48:
49: PROCEDURE create_accounting_dist(
50: p_api_version IN NUMBER
51: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
52: ,x_return_status OUT NOCOPY VARCHAR2
53: ,x_msg_count OUT NOCOPY NUMBER
54: ,x_msg_data OUT NOCOPY VARCHAR2
55: ,p_tldv_tbl IN okl_tld_pvt.tldv_tbl_type

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

58: IS
59: l_api_name CONSTANT VARCHAR2(30) := 'create_accounting_dist';
60: l_api_version CONSTANT NUMBER := 1.0;
61: l_til_loop_cnt NUMBER;
62: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
63: lp_tldv_tbl okl_tld_pvt.tldv_tbl_type := p_tldv_tbl;
64: lx_tldv_tbl okl_tld_pvt.tldv_tbl_type;
65: l_tld_loop_cnt NUMBER;
66: lx_tldv_rec okl_tld_pvt.tldv_rec_type;

Line 109: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

105: x_msg_count => x_msg_count,
106: x_msg_data => x_msg_data,
107: p_bpd_acc_rec => p_bpd_acc_rec);
108:
109: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
110: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
111: x_return_status := l_return_status;
112: END IF;
113: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

106: x_msg_data => x_msg_data,
107: p_bpd_acc_rec => p_bpd_acc_rec);
108:
109: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
110: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
111: x_return_status := l_return_status;
112: END IF;
113: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
114: END IF;

Line 113: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

109: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
110: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
111: x_return_status := l_return_status;
112: END IF;
113: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
114: END IF;
115:
116: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
117: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Okl_Acc_Call_Pub.CREATE_ACC_TRANS:p_bpd_acc_rec.id: '||to_char(p_bpd_acc_rec.id));

Line 134: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

130: x_dist_info_rec => l_dist_info_rec,
131: x_ctxt_val_tbl => l_ctxt_val_tbl,
132: x_acc_gen_primary_key_tbl => l_acc_gen_primary_key_tbl);
133:
134: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
135: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
136: x_return_status := l_return_status;
137: END IF;
138: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

131: x_ctxt_val_tbl => l_ctxt_val_tbl,
132: x_acc_gen_primary_key_tbl => l_acc_gen_primary_key_tbl);
133:
134: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
135: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
136: x_return_status := l_return_status;
137: END IF;
138: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
139: END IF;

Line 138: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

134: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
135: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
136: x_return_status := l_return_status;
137: END IF;
138: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
139: END IF;
140:
141: --debug_proc('Vipp 333...p_bpd_acc_rec.id '||p_bpd_acc_rec.id );
142: --- populate the tables for passing to Okl_Account_Dist_Pvt.CREATE_ACCOUNTING_DIST

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

180: x_amount_tbl => l_amount_out_tbl,
181: p_trx_header_id => l_trx_header_id,
182: p_trx_header_table => l_trx_header_tbl);
183:
184: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
185: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
186: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
187: RAISE OKL_API.G_EXCEPTION_ERROR;
188: END IF;

Line 185: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

181: p_trx_header_id => l_trx_header_id,
182: p_trx_header_table => l_trx_header_tbl);
183:
184: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
185: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
186: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
187: RAISE OKL_API.G_EXCEPTION_ERROR;
188: END IF;
189:

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

182: p_trx_header_table => l_trx_header_tbl);
183:
184: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
185: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
186: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
187: RAISE OKL_API.G_EXCEPTION_ERROR;
188: END IF;
189:
190: --debug_proc('Vipp 333...l_trx_header_id '||l_trx_header_id );

Line 187: RAISE OKL_API.G_EXCEPTION_ERROR;

183:
184: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
185: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
186: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
187: RAISE OKL_API.G_EXCEPTION_ERROR;
188: END IF;
189:
190: --debug_proc('Vipp 333...l_trx_header_id '||l_trx_header_id );
191: ---- End Added by Vpanwar --- Code for new accounting API uptake

Line 200: WHEN OKL_API.G_EXCEPTION_ERROR THEN

196: (p_count => x_msg_count,
197: p_data => x_msg_data);
198:
199: EXCEPTION
200: WHEN OKL_API.G_EXCEPTION_ERROR THEN
201: ROLLBACK TO CREATE_ACCOUNTING_DIST;
202: x_return_status := OKL_API.G_RET_STS_ERROR;
203: FND_MSG_PUB.Count_And_Get
204: (p_count => x_msg_count,

Line 202: x_return_status := OKL_API.G_RET_STS_ERROR;

198:
199: EXCEPTION
200: WHEN OKL_API.G_EXCEPTION_ERROR THEN
201: ROLLBACK TO CREATE_ACCOUNTING_DIST;
202: x_return_status := OKL_API.G_RET_STS_ERROR;
203: FND_MSG_PUB.Count_And_Get
204: (p_count => x_msg_count,
205: p_data => x_msg_data);
206:

Line 207: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

203: FND_MSG_PUB.Count_And_Get
204: (p_count => x_msg_count,
205: p_data => x_msg_data);
206:
207: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
208: ROLLBACK TO CREATE_ACCOUNTING_DIST;
209: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
210: FND_MSG_PUB.Count_And_Get
211: (p_count => x_msg_count,

Line 209: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

205: p_data => x_msg_data);
206:
207: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
208: ROLLBACK TO CREATE_ACCOUNTING_DIST;
209: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
210: FND_MSG_PUB.Count_And_Get
211: (p_count => x_msg_count,
212: p_data => x_msg_data);
213:

Line 216: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

212: p_data => x_msg_data);
213:
214: WHEN OTHERS THEN
215: ROLLBACK TO CREATE_ACCOUNTING_DIST;
216: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
217: OKL_API.Set_Message(p_app_name => G_APP_NAME,
218: p_msg_name => G_UNEXPECTED_ERROR,
219: p_token1 => G_SQLCODE_TOKEN,
220: p_token1_value => SQLCODE,

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

213:
214: WHEN OTHERS THEN
215: ROLLBACK TO CREATE_ACCOUNTING_DIST;
216: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
217: OKL_API.Set_Message(p_app_name => G_APP_NAME,
218: p_msg_name => G_UNEXPECTED_ERROR,
219: p_token1 => G_SQLCODE_TOKEN,
220: p_token1_value => SQLCODE,
221: p_token2 => G_SQLERRM_TOKEN,

Line 248: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

244: -- End of comments
245: ----------------------------------------------------------------------------------
246: PROCEDURE additional_tai_attr(
247: p_api_version IN NUMBER
248: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
249: ,x_return_status OUT NOCOPY VARCHAR2
250: ,x_msg_count OUT NOCOPY NUMBER
251: ,x_msg_data OUT NOCOPY VARCHAR2
252: ,p_taiv_rec IN taiv_rec_type

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

257: )
258: is
259: l_api_name CONSTANT VARCHAR2(30) := 'additional_tai_attr';
260: l_api_version CONSTANT NUMBER := 1.0;
261: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
262: l_rgd_code okc_rule_groups_b.rgd_code%TYPE DEFAULT NULL;
263:
264: --START: cklee 3/20/07
265: l_legal_entity_id okl_trx_ar_invoices_b.legal_entity_id%TYPE; -- for LE Uptake project 08-11-2006

Line 454: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

450: p_api_version,
451: l_api_name,
452: G_PKG_NAME ))
453: THEN
454: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
455: END IF;
456:
457: -- Initialize message list if requested
458: IF (FND_API.to_Boolean(p_init_msg_list)) THEN

Line 463: x_return_status := OKL_API.G_RET_STS_SUCCESS;

459: FND_MSG_PUB.initialize;
460: END IF;
461:
462: -- Initialize API status to success
463: x_return_status := OKL_API.G_RET_STS_SUCCESS;
464:
465:
466: /*** Begin API body ****************************************************/
467: -- assign all passed in attributes from IN to OUT record

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

513: l_object1_id2 := NULL;
514: l_jtot_object2_code := NULL;
515:
516: -- for LE Uptake project 08-11-2006
517: IF (p_taiv_rec.legal_entity_id IS NULL OR (p_taiv_rec.legal_entity_id = Okl_Api.G_MISS_NUM)) THEN
518: l_legal_entity_id := OKL_LEGAL_ENTITY_UTIL.get_khr_le_id(l_khr_id);
519: ELSE
520: l_legal_entity_id := p_taiv_rec.legal_entity_id;
521: END IF;

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

588: -- x_taiv_rec.ixx_id := NVL(p_taiv_rec.ixx_id, billto_rec.cust_account_id);
589: -- x_taiv_rec.ibt_id := NVL(p_taiv_rec.ibt_id, billto_rec.cust_acct_site_id);
590:
591: -- rmunjulu R12 Fixes -- changed to check for g_miss
592: IF (p_taiv_rec.ixx_id IS NULL OR (p_taiv_rec.ixx_id = Okl_Api.G_MISS_NUM)) THEN
593: x_taiv_rec.ixx_id := billto_rec.cust_account_id;
594: ELSE
595: x_taiv_rec.ixx_id := p_taiv_rec.ixx_id;
596: END IF;

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

594: ELSE
595: x_taiv_rec.ixx_id := p_taiv_rec.ixx_id;
596: END IF;
597:
598: IF (p_taiv_rec.ibt_id IS NULL OR (p_taiv_rec.ibt_id = Okl_Api.G_MISS_NUM)) THEN
599: x_taiv_rec.ibt_id := billto_rec.cust_acct_site_id;
600: ELSE
601: x_taiv_rec.ibt_id := p_taiv_rec.ibt_id;
602: END IF;

Line 613: if p_taiv_rec.irt_id is null or p_taiv_rec.irt_id = okl_api.g_miss_num

609: CLOSE std_terms_csr;
610:
611: -- cklee: set when irt_id is null
612: --x_taiv_rec.irt_id := NVL(p_taiv_rec.irt_id, l_term_id); -- 6140771
613: if p_taiv_rec.irt_id is null or p_taiv_rec.irt_id = okl_api.g_miss_num
614: then
615: x_taiv_rec.irt_id := l_term_id;
616: else
617: x_taiv_rec.irt_id := p_taiv_rec.irt_id;

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

616: else
617: x_taiv_rec.irt_id := p_taiv_rec.irt_id;
618: end if;
619:
620: IF (p_taiv_rec.org_id IS NULL OR p_taiv_rec.org_id=OKL_API.G_MISS_NUM) THEN
621:
622: OPEN org_id_csr(l_khr_id);
623: FETCH org_id_csr
624: INTO x_taiv_rec.org_id;

Line 739: IF ( p_ie_tbl1(k).legal_entity_id IS NULL OR (p_ie_tbl1(k).legal_entity_id = Okl_Api.G_MISS_NUM)) THEN

735: --l_xsiv_rec.ORG_ID := ln_dtls_rec.ORG_ID; --TAI
736: xsi_tbl(l_xsi_cnt).org_id := NULL;
737: END IF;
738: -- for LE Uptake project 08-11-2006
739: IF ( p_ie_tbl1(k).legal_entity_id IS NULL OR (p_ie_tbl1(k).legal_entity_id = Okl_Api.G_MISS_NUM)) THEN
740: --d*bms_output.put_line ('LEGAL_ENTITY_ID must be populated WHEN the contract header IS NULL!');
741: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'LEGAL_ENTITY_ID must be populated WHEN the contract header IS NULL');
742: ELSE
743: xsi_tbl(l_xsi_cnt).legal_entity_id := p_ie_tbl1(k).legal_entity_id;

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

747: END IF; -- IF l_khr_id IS NOT NULL THEN
748:
749: --How to get the set_of_books_id ?
750:
751: IF (p_taiv_rec.set_of_books_id IS NULL OR p_taiv_rec.set_of_books_id = OKL_API.G_MISS_NUM) THEN
752: x_taiv_rec.set_of_books_id := Okl_Accounting_Util.get_set_of_books_id;
753: ELSE
754: x_taiv_rec.set_of_books_id := p_taiv_rec.set_of_books_id;
755: --TAI

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

757:
758: --Start code added by pgomes on 20-NOV-2002
759: --Check for currency code
760:
761: IF (p_taiv_rec.currency_code IS NULL OR p_taiv_rec.currency_code=OKL_API.G_MISS_CHAR) THEN
762: x_taiv_rec.currency_code := l_currency_code;
763: ELSE
764: x_taiv_rec.currency_code := p_taiv_rec.currency_code;
765: END IF;

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

765: END IF;
766:
767: --Check for currency conversion type
768:
769: IF (p_taiv_rec.currency_conversion_type IS NULL OR p_taiv_rec.currency_conversion_type = OKL_API.G_MISS_CHAR) THEN
770: x_taiv_rec.currency_conversion_type := l_currency_conversion_type;
771: ELSE
772: x_taiv_rec.currency_conversion_type := p_taiv_rec.currency_conversion_type;
773: END IF;

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

780: IF(x_taiv_rec.currency_code = Okl_Accounting_Util.get_func_curr_code) THEN
781: x_taiv_rec.currency_conversion_rate := 1;
782: ELSE
783:
784: IF (p_taiv_rec.currency_conversion_rate IS NULL OR p_taiv_rec.currency_conversion_rate=OKL_API.G_MISS_NUM) THEN
785: x_taiv_rec.currency_conversion_rate := l_currency_conversion_rate;
786: ELSE
787: x_taiv_rec.currency_conversion_rate := p_taiv_rec.currency_conversion_rate;
788: END IF;

Line 801: IF p_taiv_rec.currency_conversion_date IS NULL OR p_taiv_rec.currency_conversion_date = OKL_API.G_MISS_DATE THEN

797:
798: --Bug 9001169: Adding IF condition for manual invoice check
799: -- and for others keeping as it in ELSE part. (Added by NIKSHAH)
800: IF NVL(p_taiv_rec.OKL_SOURCE_BILLING_TRX,'NONE') = 'MANUAL_INVOICE' THEN
801: IF p_taiv_rec.currency_conversion_date IS NULL OR p_taiv_rec.currency_conversion_date = OKL_API.G_MISS_DATE THEN
802: IF(x_taiv_rec.currency_conversion_type = 'User') THEN
803: x_taiv_rec.currency_conversion_date := l_currency_conversion_date;
804: ELSE
805: x_taiv_rec.currency_conversion_date := p_taiv_rec.date_invoiced;

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

807: ELSE
808: x_taiv_rec.currency_conversion_date := p_taiv_rec.currency_conversion_date;
809: END IF;
810: ELSE
811: IF (p_taiv_rec.currency_conversion_date IS NULL OR p_taiv_rec.currency_conversion_date = OKL_API.G_MISS_DATE) THEN
812: x_taiv_rec.currency_conversion_date := l_currency_conversion_date;
813: ELSE
814: x_taiv_rec.currency_conversion_date := p_taiv_rec.currency_conversion_date;
815: END IF;

Line 825: IF(x_taiv_rec.currency_conversion_type IS NULL OR x_taiv_rec.currency_conversion_type = OKL_API.G_MISS_CHAR) THEN

821:
822: --Bug 9001169: Adding IF condition for manual invoice check
823: -- and for others keeping as it in ELSE part. (Added by NIKSHAH)
824: IF NVL(p_taiv_rec.OKL_SOURCE_BILLING_TRX,'NONE') = 'MANUAL_INVOICE' THEN
825: IF(x_taiv_rec.currency_conversion_type IS NULL OR x_taiv_rec.currency_conversion_type = OKL_API.G_MISS_CHAR) THEN
826: x_taiv_rec.currency_conversion_type := 'User';
827: x_taiv_rec.currency_conversion_rate := 1;
828: x_taiv_rec.currency_conversion_date := SYSDATE;
829: END IF;

Line 835: IF(x_taiv_rec.currency_conversion_type IS NULL OR x_taiv_rec.currency_conversion_type = OKL_API.G_MISS_CHAR) THEN

831: -- 6140771
832: /* ankushar 16-Apr-2008 Bug# 6237730, Added condition for defaulting currency rate, date and type
833: start code changes
834: */
835: IF(x_taiv_rec.currency_conversion_type IS NULL OR x_taiv_rec.currency_conversion_type = OKL_API.G_MISS_CHAR) THEN
836: --SECHAWLA 06-DEC-10 10275346 : For conversion type <> User, the rate is correctly set to Null above
837: -- It is incorrect to default currency fields with following values when rate is null but type and date are populated
838: -- OR x_taiv_rec.currency_conversion_date IS NULL OR x_taiv_rec.currency_conversion_date = OKL_API.G_MISS_DATE
839: -- OR x_taiv_rec.currency_conversion_rate IS NULL OR x_taiv_rec.currency_conversion_rate = OKL_API.G_MISS_NUM) THEN

Line 838: -- OR x_taiv_rec.currency_conversion_date IS NULL OR x_taiv_rec.currency_conversion_date = OKL_API.G_MISS_DATE

834: */
835: IF(x_taiv_rec.currency_conversion_type IS NULL OR x_taiv_rec.currency_conversion_type = OKL_API.G_MISS_CHAR) THEN
836: --SECHAWLA 06-DEC-10 10275346 : For conversion type <> User, the rate is correctly set to Null above
837: -- It is incorrect to default currency fields with following values when rate is null but type and date are populated
838: -- OR x_taiv_rec.currency_conversion_date IS NULL OR x_taiv_rec.currency_conversion_date = OKL_API.G_MISS_DATE
839: -- OR x_taiv_rec.currency_conversion_rate IS NULL OR x_taiv_rec.currency_conversion_rate = OKL_API.G_MISS_NUM) THEN
840: /* ankushar End Changes */
841:
842: x_taiv_rec.currency_conversion_type := 'User';

Line 839: -- OR x_taiv_rec.currency_conversion_rate IS NULL OR x_taiv_rec.currency_conversion_rate = OKL_API.G_MISS_NUM) THEN

835: IF(x_taiv_rec.currency_conversion_type IS NULL OR x_taiv_rec.currency_conversion_type = OKL_API.G_MISS_CHAR) THEN
836: --SECHAWLA 06-DEC-10 10275346 : For conversion type <> User, the rate is correctly set to Null above
837: -- It is incorrect to default currency fields with following values when rate is null but type and date are populated
838: -- OR x_taiv_rec.currency_conversion_date IS NULL OR x_taiv_rec.currency_conversion_date = OKL_API.G_MISS_DATE
839: -- OR x_taiv_rec.currency_conversion_rate IS NULL OR x_taiv_rec.currency_conversion_rate = OKL_API.G_MISS_NUM) THEN
840: /* ankushar End Changes */
841:
842: x_taiv_rec.currency_conversion_type := 'User';
843: x_taiv_rec.currency_conversion_rate := 1;

Line 900: IF p_taiv_rec.trx_status_code IS NULL or p_taiv_rec.trx_status_code = okl_api.g_miss_char

896: x_taiv_rec.tax_exempt_reason_code := NULL;
897:
898: --start: | 30-Mar-2007 cklee -- validate taiv_rec.trx_status_code and default to |
899: --| 'SUBMITTED' |
900: IF p_taiv_rec.trx_status_code IS NULL or p_taiv_rec.trx_status_code = okl_api.g_miss_char
901: THEN
902: x_taiv_rec.trx_status_code := G_SUBMITTED;
903: END IF;
904: --end: | 30-Mar-2007 cklee -- validate taiv_rec.trx_status_code and default to |

Line 915: WHEN OKL_API.G_EXCEPTION_ERROR THEN

911: (p_count => x_msg_count,
912: p_data => x_msg_data);
913:
914: EXCEPTION
915: WHEN OKL_API.G_EXCEPTION_ERROR THEN
916: ROLLBACK TO additional_tai_attr;
917: x_return_status := OKL_API.G_RET_STS_ERROR;
918: FND_MSG_PUB.Count_And_Get
919: (p_count => x_msg_count,

Line 917: x_return_status := OKL_API.G_RET_STS_ERROR;

913:
914: EXCEPTION
915: WHEN OKL_API.G_EXCEPTION_ERROR THEN
916: ROLLBACK TO additional_tai_attr;
917: x_return_status := OKL_API.G_RET_STS_ERROR;
918: FND_MSG_PUB.Count_And_Get
919: (p_count => x_msg_count,
920: p_data => x_msg_data);
921:

Line 922: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

918: FND_MSG_PUB.Count_And_Get
919: (p_count => x_msg_count,
920: p_data => x_msg_data);
921:
922: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
923: ROLLBACK TO additional_tai_attr;
924: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
925: FND_MSG_PUB.Count_And_Get
926: (p_count => x_msg_count,

Line 924: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

920: p_data => x_msg_data);
921:
922: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
923: ROLLBACK TO additional_tai_attr;
924: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
925: FND_MSG_PUB.Count_And_Get
926: (p_count => x_msg_count,
927: p_data => x_msg_data);
928:

Line 931: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

927: p_data => x_msg_data);
928:
929: WHEN OTHERS THEN
930: ROLLBACK TO additional_tai_attr;
931: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
932: OKL_API.Set_Message(p_app_name => G_APP_NAME,
933: p_msg_name => G_UNEXPECTED_ERROR,
934: p_token1 => G_SQLCODE_TOKEN,
935: p_token1_value => SQLCODE,

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

928:
929: WHEN OTHERS THEN
930: ROLLBACK TO additional_tai_attr;
931: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
932: OKL_API.Set_Message(p_app_name => G_APP_NAME,
933: p_msg_name => G_UNEXPECTED_ERROR,
934: p_token1 => G_SQLCODE_TOKEN,
935: p_token1_value => SQLCODE,
936: p_token2 => G_SQLERRM_TOKEN,

Line 958: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

954: -- End of comments
955: ----------------------------------------------------------------------------------
956: PROCEDURE additional_til_attr(
957: p_api_version IN NUMBER
958: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
959: ,x_return_status OUT NOCOPY VARCHAR2
960: ,x_msg_count OUT NOCOPY NUMBER
961: ,x_msg_data OUT NOCOPY VARCHAR2
962: ,p_tilv_rec IN tilv_rec_type

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

964: )
965: is
966: l_api_name CONSTANT VARCHAR2(30) := 'additional_til_attr';
967: l_api_version CONSTANT NUMBER := 1.0;
968: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
969: l_line_code CONSTANT VARCHAR2(30) := 'LINE';
970:
971:
972: begin

Line 988: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

984: p_api_version,
985: l_api_name,
986: G_PKG_NAME ))
987: THEN
988: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
989: END IF;
990:
991: -- Initialize message list if requested
992: IF (FND_API.to_Boolean(p_init_msg_list)) THEN

Line 997: x_return_status := OKL_API.G_RET_STS_SUCCESS;

993: FND_MSG_PUB.initialize;
994: END IF;
995:
996: -- Initialize API status to success
997: x_return_status := OKL_API.G_RET_STS_SUCCESS;
998:
999:
1000: /*** Begin API body ****************************************************/
1001: -- assign all passed in attributes from IN to OUT record

Line 1022: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1018: (p_count => x_msg_count,
1019: p_data => x_msg_data);
1020:
1021: EXCEPTION
1022: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1023: ROLLBACK TO additional_til_attr;
1024: x_return_status := OKL_API.G_RET_STS_ERROR;
1025: FND_MSG_PUB.Count_And_Get
1026: (p_count => x_msg_count,

Line 1024: x_return_status := OKL_API.G_RET_STS_ERROR;

1020:
1021: EXCEPTION
1022: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1023: ROLLBACK TO additional_til_attr;
1024: x_return_status := OKL_API.G_RET_STS_ERROR;
1025: FND_MSG_PUB.Count_And_Get
1026: (p_count => x_msg_count,
1027: p_data => x_msg_data);
1028:

Line 1029: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1025: FND_MSG_PUB.Count_And_Get
1026: (p_count => x_msg_count,
1027: p_data => x_msg_data);
1028:
1029: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1030: ROLLBACK TO additional_til_attr;
1031: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1032: FND_MSG_PUB.Count_And_Get
1033: (p_count => x_msg_count,

Line 1031: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1027: p_data => x_msg_data);
1028:
1029: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1030: ROLLBACK TO additional_til_attr;
1031: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1032: FND_MSG_PUB.Count_And_Get
1033: (p_count => x_msg_count,
1034: p_data => x_msg_data);
1035:

Line 1038: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

1034: p_data => x_msg_data);
1035:
1036: WHEN OTHERS THEN
1037: ROLLBACK TO additional_til_attr;
1038: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
1039: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1040: p_msg_name => G_UNEXPECTED_ERROR,
1041: p_token1 => G_SQLCODE_TOKEN,
1042: p_token1_value => SQLCODE,

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

1035:
1036: WHEN OTHERS THEN
1037: ROLLBACK TO additional_til_attr;
1038: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
1039: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1040: p_msg_name => G_UNEXPECTED_ERROR,
1041: p_token1 => G_SQLCODE_TOKEN,
1042: p_token1_value => SQLCODE,
1043: p_token2 => G_SQLERRM_TOKEN,

Line 1065: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

1061: -- End of comments
1062: ----------------------------------------------------------------------------------
1063: PROCEDURE additional_tld_attr(
1064: p_api_version IN NUMBER
1065: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
1066: ,x_return_status OUT NOCOPY VARCHAR2
1067: ,x_msg_count OUT NOCOPY NUMBER
1068: ,x_msg_data OUT NOCOPY VARCHAR2
1069: ,p_tldv_rec IN tldv_rec_type

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

1071: )
1072: is
1073: l_api_name CONSTANT VARCHAR2(30) := 'additional_tld_attr';
1074: l_api_version CONSTANT NUMBER := 1.0;
1075: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1076: /*
1077: l_recv_inv_id NUMBER;
1078: CURSOR reverse_csr1(p_tld_id NUMBER) IS
1079: SELECT receivables_invoice_id

Line 1133: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1129: p_api_version,
1130: l_api_name,
1131: G_PKG_NAME ))
1132: THEN
1133: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1134: END IF;
1135:
1136: -- Initialize message list if requested
1137: IF (FND_API.to_Boolean(p_init_msg_list)) THEN

Line 1142: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1138: FND_MSG_PUB.initialize;
1139: END IF;
1140:
1141: -- Initialize API status to success
1142: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1143:
1144:
1145: /*** Begin API body ****************************************************/
1146: -- assign all passed in attributes from IN to OUT record

Line 1168: IF(p_tldv_rec.inventory_org_id IS NULL OR p_tldv_rec.inventory_org_id=OKL_API.G_MISS_NUM) THEN

1164: x_tldv_rec.receivables_invoice_id := NULL;
1165: -- Populated later by fetch
1166: */
1167:
1168: IF(p_tldv_rec.inventory_org_id IS NULL OR p_tldv_rec.inventory_org_id=OKL_API.G_MISS_NUM) THEN
1169:
1170: OPEN inv_org_id_csr(p_tldv_rec.khr_id);
1171: FETCH inv_org_id_csr
1172: INTO x_tldv_rec.inventory_org_id;

Line 1210: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1206: (p_count => x_msg_count,
1207: p_data => x_msg_data);
1208:
1209: EXCEPTION
1210: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1211: ROLLBACK TO additional_tld_attr;
1212: x_return_status := OKL_API.G_RET_STS_ERROR;
1213: FND_MSG_PUB.Count_And_Get
1214: (p_count => x_msg_count,

Line 1212: x_return_status := OKL_API.G_RET_STS_ERROR;

1208:
1209: EXCEPTION
1210: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1211: ROLLBACK TO additional_tld_attr;
1212: x_return_status := OKL_API.G_RET_STS_ERROR;
1213: FND_MSG_PUB.Count_And_Get
1214: (p_count => x_msg_count,
1215: p_data => x_msg_data);
1216:

Line 1217: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1213: FND_MSG_PUB.Count_And_Get
1214: (p_count => x_msg_count,
1215: p_data => x_msg_data);
1216:
1217: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1218: ROLLBACK TO additional_tld_attr;
1219: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1220: FND_MSG_PUB.Count_And_Get
1221: (p_count => x_msg_count,

Line 1219: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1215: p_data => x_msg_data);
1216:
1217: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1218: ROLLBACK TO additional_tld_attr;
1219: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1220: FND_MSG_PUB.Count_And_Get
1221: (p_count => x_msg_count,
1222: p_data => x_msg_data);
1223:

Line 1226: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

1222: p_data => x_msg_data);
1223:
1224: WHEN OTHERS THEN
1225: ROLLBACK TO additional_tld_attr;
1226: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
1227: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1228: p_msg_name => G_UNEXPECTED_ERROR,
1229: p_token1 => G_SQLCODE_TOKEN,
1230: p_token1_value => SQLCODE,

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

1223:
1224: WHEN OTHERS THEN
1225: ROLLBACK TO additional_tld_attr;
1226: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
1227: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1228: p_msg_name => G_UNEXPECTED_ERROR,
1229: p_token1 => G_SQLCODE_TOKEN,
1230: p_token1_value => SQLCODE,
1231: p_token2 => G_SQLERRM_TOKEN,

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

1252: p_tilv_tbl IN tilv_tbl_type,
1253: p_tldv_tbl IN tldv_tbl_type
1254: ) RETURN VARCHAR2
1255: IS
1256: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1257: l_til_exist BOOLEAN;
1258: l_tld_exist BOOLEAN;
1259:
1260: BEGIN

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

1270: G_IS_STREAM_BASED_BILLING := FALSE;
1271: ELSIF p_tilv_tbl.COUNT = 0 THEN
1272:
1273: -- developer note: Replace with a proper message
1274: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1275: p_msg_name => G_REQUIRED_VALUE,
1276: p_token1 => G_COL_NAME_TOKEN,
1277: p_token1_value => 'p_tilv_tbl.STY_ID');
1278:

Line 1290: l_return_status := OKL_API.G_RET_STS_ERROR;

1286:
1287:
1288: EXCEPTION
1289: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1290: l_return_status := OKL_API.G_RET_STS_ERROR;
1291: RETURN l_return_status;
1292: WHEN OTHERS THEN
1293: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
1294: OKL_API.Set_Message(p_app_name => G_APP_NAME,

Line 1293: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

1289: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1290: l_return_status := OKL_API.G_RET_STS_ERROR;
1291: RETURN l_return_status;
1292: WHEN OTHERS THEN
1293: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
1294: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1295: p_msg_name => G_UNEXPECTED_ERROR,
1296: p_token1 => G_SQLCODE_TOKEN,
1297: p_token1_value => SQLCODE,

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

1290: l_return_status := OKL_API.G_RET_STS_ERROR;
1291: RETURN l_return_status;
1292: WHEN OTHERS THEN
1293: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
1294: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1295: p_msg_name => G_UNEXPECTED_ERROR,
1296: p_token1 => G_SQLCODE_TOKEN,
1297: p_token1_value => SQLCODE,
1298: p_token2 => G_SQLERRM_TOKEN,

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

1316: p_tilv_tbl IN tilv_tbl_type,
1317: p_tldv_tbl IN tldv_tbl_type
1318: ) RETURN VARCHAR2
1319: IS
1320: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1321: l_til_loop_cnt NUMBER := 0;
1322: l_til_ln_number NUMBER := 0;
1323: l_current NUMBER := 0;
1324: l_tld_loop_cnt NUMBER := 0;

Line 1336: p_tilv_tbl(l_til_loop_cnt).TXL_AR_LINE_NUMBER = Okl_Api.G_MISS_NUM

1332:
1333: -- for l_til_loop_cnt in 1 .. p_tilv_tbl.count loop
1334: -- Raise Exception if any of til records does not have TXL_AR_LINE_NUMBER
1335: if p_tilv_tbl(l_til_loop_cnt).TXL_AR_LINE_NUMBER is null OR
1336: p_tilv_tbl(l_til_loop_cnt).TXL_AR_LINE_NUMBER = Okl_Api.G_MISS_NUM
1337: then
1338: raise G_EXCEPTION_HALT_VALIDATION;
1339: end if;
1340: l_til_ln_number := p_tilv_tbl(l_til_loop_cnt).TXL_AR_LINE_NUMBER;

Line 1347: p_tilv_tbl(l_til_loop_cnt).TXL_AR_LINE_NUMBER = Okl_Api.G_MISS_NUM

1343: loop
1344: --for l_tld_loop_cnt in 1 .. p_tldv_tbl.count loop
1345: -- Raise Exception if any of tld record does not have txl_ar_ln_number
1346: if p_tldv_tbl(l_tld_loop_cnt).TXL_AR_LINE_NUMBER is null OR
1347: p_tilv_tbl(l_til_loop_cnt).TXL_AR_LINE_NUMBER = Okl_Api.G_MISS_NUM
1348: then
1349: raise G_EXCEPTION_HALT_VALIDATION;
1350: end if;
1351: if (p_tldv_tbl(l_tld_loop_cnt).TXL_AR_LINE_NUMBER = l_til_ln_number) then

Line 1379: l_return_status := OKL_API.G_RET_STS_ERROR;

1375:
1376:
1377: EXCEPTION
1378: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1379: l_return_status := OKL_API.G_RET_STS_ERROR;
1380: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1381: p_msg_name => G_REQUIRED_VALUE,
1382: p_token1 => G_COL_NAME_TOKEN,
1383: p_token1_value => 'TXL_AR_LINE_NUMBER');

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

1376:
1377: EXCEPTION
1378: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1379: l_return_status := OKL_API.G_RET_STS_ERROR;
1380: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1381: p_msg_name => G_REQUIRED_VALUE,
1382: p_token1 => G_COL_NAME_TOKEN,
1383: p_token1_value => 'TXL_AR_LINE_NUMBER');
1384: RETURN l_return_status;

Line 1386: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

1382: p_token1 => G_COL_NAME_TOKEN,
1383: p_token1_value => 'TXL_AR_LINE_NUMBER');
1384: RETURN l_return_status;
1385: WHEN OTHERS THEN
1386: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
1387: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1388: p_msg_name => G_UNEXPECTED_ERROR,
1389: p_token1 => G_SQLCODE_TOKEN,
1390: p_token1_value => SQLCODE,

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

1383: p_token1_value => 'TXL_AR_LINE_NUMBER');
1384: RETURN l_return_status;
1385: WHEN OTHERS THEN
1386: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
1387: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1388: p_msg_name => G_UNEXPECTED_ERROR,
1389: p_token1 => G_SQLCODE_TOKEN,
1390: p_token1_value => SQLCODE,
1391: p_token2 => G_SQLERRM_TOKEN,

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

1409: p_tilv_tbl IN tilv_tbl_type,
1410: p_tldv_tbl IN tldv_tbl_type
1411: ) RETURN VARCHAR2
1412: IS
1413: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1414: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1415:
1416: BEGIN
1417:

Line 1414: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1410: p_tldv_tbl IN tldv_tbl_type
1411: ) RETURN VARCHAR2
1412: IS
1413: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1414: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1415:
1416: BEGIN
1417:
1418: -- Do formal attribute validation:

Line 1422: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

1418: -- Do formal attribute validation:
1419: l_return_status := validate_billing_usage(p_tilv_tbl => p_tilv_tbl,
1420: p_tldv_tbl => p_tldv_tbl);
1421: --- Store the highest degree of error
1422: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
1423: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1424: x_return_status := l_return_status;
1425: END IF;
1426: RAISE G_EXCEPTION_HALT_VALIDATION;

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

1419: l_return_status := validate_billing_usage(p_tilv_tbl => p_tilv_tbl,
1420: p_tldv_tbl => p_tldv_tbl);
1421: --- Store the highest degree of error
1422: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
1423: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1424: x_return_status := l_return_status;
1425: END IF;
1426: RAISE G_EXCEPTION_HALT_VALIDATION;
1427: END IF;

Line 1436: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

1432:
1433: l_return_status := validate_TXL_AR_LINE_NUMBER(p_tilv_tbl => p_tilv_tbl,
1434: p_tldv_tbl => p_tldv_tbl);
1435: --- Store the highest degree of error
1436: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
1437: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1438: x_return_status := l_return_status;
1439: END IF;
1440: RAISE G_EXCEPTION_HALT_VALIDATION;

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

1433: l_return_status := validate_TXL_AR_LINE_NUMBER(p_tilv_tbl => p_tilv_tbl,
1434: p_tldv_tbl => p_tldv_tbl);
1435: --- Store the highest degree of error
1436: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
1437: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1438: x_return_status := l_return_status;
1439: END IF;
1440: RAISE G_EXCEPTION_HALT_VALIDATION;
1441: END IF;

Line 1448: l_return_status := OKL_API.G_RET_STS_ERROR;

1444:
1445: RETURN x_return_status;
1446: EXCEPTION
1447: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1448: l_return_status := OKL_API.G_RET_STS_ERROR;
1449: RETURN l_return_status;
1450: WHEN OTHERS THEN
1451: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
1452: OKL_API.Set_Message(p_app_name => G_APP_NAME,

Line 1451: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

1447: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1448: l_return_status := OKL_API.G_RET_STS_ERROR;
1449: RETURN l_return_status;
1450: WHEN OTHERS THEN
1451: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
1452: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1453: p_msg_name => G_UNEXPECTED_ERROR,
1454: p_token1 => G_SQLCODE_TOKEN,
1455: p_token1_value => SQLCODE,

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

1448: l_return_status := OKL_API.G_RET_STS_ERROR;
1449: RETURN l_return_status;
1450: WHEN OTHERS THEN
1451: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
1452: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1453: p_msg_name => G_UNEXPECTED_ERROR,
1454: p_token1 => G_SQLCODE_TOKEN,
1455: p_token1_value => SQLCODE,
1456: p_token2 => G_SQLERRM_TOKEN,

Line 1477: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;

1473: PROCEDURE validate_tai_values(
1474: p_taiv_rec IN taiv_rec_type,
1475: x_return_status OUT NOCOPY VARCHAR2
1476: ) IS
1477: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
1478: BEGIN
1479:
1480: IF (p_taiv_rec.khr_id IS NULL OR p_taiv_rec.khr_id = Okl_Api.G_MISS_NUM) AND
1481: (p_taiv_rec.ixx_id IS NULL OR p_taiv_rec.ixx_id = Okl_Api.G_MISS_NUM)

Line 1480: IF (p_taiv_rec.khr_id IS NULL OR p_taiv_rec.khr_id = Okl_Api.G_MISS_NUM) AND

1476: ) IS
1477: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
1478: BEGIN
1479:
1480: IF (p_taiv_rec.khr_id IS NULL OR p_taiv_rec.khr_id = Okl_Api.G_MISS_NUM) AND
1481: (p_taiv_rec.ixx_id IS NULL OR p_taiv_rec.ixx_id = Okl_Api.G_MISS_NUM)
1482: THEN
1483: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1484: p_msg_name => G_REQUIRED_VALUE,

Line 1481: (p_taiv_rec.ixx_id IS NULL OR p_taiv_rec.ixx_id = Okl_Api.G_MISS_NUM)

1477: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
1478: BEGIN
1479:
1480: IF (p_taiv_rec.khr_id IS NULL OR p_taiv_rec.khr_id = Okl_Api.G_MISS_NUM) AND
1481: (p_taiv_rec.ixx_id IS NULL OR p_taiv_rec.ixx_id = Okl_Api.G_MISS_NUM)
1482: THEN
1483: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1484: p_msg_name => G_REQUIRED_VALUE,
1485: p_token1 => G_COL_NAME_TOKEN,

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

1479:
1480: IF (p_taiv_rec.khr_id IS NULL OR p_taiv_rec.khr_id = Okl_Api.G_MISS_NUM) AND
1481: (p_taiv_rec.ixx_id IS NULL OR p_taiv_rec.ixx_id = Okl_Api.G_MISS_NUM)
1482: THEN
1483: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1484: p_msg_name => G_REQUIRED_VALUE,
1485: p_token1 => G_COL_NAME_TOKEN,
1486: p_token1_value => 'okl_trx_ar_invoices_b.ixx_id');
1487:

Line 1491: IF (p_taiv_rec.khr_id IS NULL OR p_taiv_rec.khr_id = Okl_Api.G_MISS_NUM) AND

1487:
1488: RAISE G_EXCEPTION_HALT_VALIDATION;
1489: END IF;
1490:
1491: IF (p_taiv_rec.khr_id IS NULL OR p_taiv_rec.khr_id = Okl_Api.G_MISS_NUM) AND
1492: (p_taiv_rec.irm_id IS NULL OR p_taiv_rec.irm_id = Okl_Api.G_MISS_NUM)
1493: THEN
1494: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1495: p_msg_name => G_REQUIRED_VALUE,

Line 1492: (p_taiv_rec.irm_id IS NULL OR p_taiv_rec.irm_id = Okl_Api.G_MISS_NUM)

1488: RAISE G_EXCEPTION_HALT_VALIDATION;
1489: END IF;
1490:
1491: IF (p_taiv_rec.khr_id IS NULL OR p_taiv_rec.khr_id = Okl_Api.G_MISS_NUM) AND
1492: (p_taiv_rec.irm_id IS NULL OR p_taiv_rec.irm_id = Okl_Api.G_MISS_NUM)
1493: THEN
1494: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1495: p_msg_name => G_REQUIRED_VALUE,
1496: p_token1 => G_COL_NAME_TOKEN,

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

1490:
1491: IF (p_taiv_rec.khr_id IS NULL OR p_taiv_rec.khr_id = Okl_Api.G_MISS_NUM) AND
1492: (p_taiv_rec.irm_id IS NULL OR p_taiv_rec.irm_id = Okl_Api.G_MISS_NUM)
1493: THEN
1494: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1495: p_msg_name => G_REQUIRED_VALUE,
1496: p_token1 => G_COL_NAME_TOKEN,
1497: p_token1_value => 'okl_trx_ar_invoices_b.irm_id');
1498:

Line 1502: IF (p_taiv_rec.khr_id IS NULL OR p_taiv_rec.khr_id = Okl_Api.G_MISS_NUM) AND

1498:
1499: RAISE G_EXCEPTION_HALT_VALIDATION;
1500: END IF;
1501:
1502: IF (p_taiv_rec.khr_id IS NULL OR p_taiv_rec.khr_id = Okl_Api.G_MISS_NUM) AND
1503: (p_taiv_rec.irt_id IS NULL OR p_taiv_rec.irt_id = Okl_Api.G_MISS_NUM)
1504: THEN
1505: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1506: p_msg_name => G_REQUIRED_VALUE,

Line 1503: (p_taiv_rec.irt_id IS NULL OR p_taiv_rec.irt_id = Okl_Api.G_MISS_NUM)

1499: RAISE G_EXCEPTION_HALT_VALIDATION;
1500: END IF;
1501:
1502: IF (p_taiv_rec.khr_id IS NULL OR p_taiv_rec.khr_id = Okl_Api.G_MISS_NUM) AND
1503: (p_taiv_rec.irt_id IS NULL OR p_taiv_rec.irt_id = Okl_Api.G_MISS_NUM)
1504: THEN
1505: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1506: p_msg_name => G_REQUIRED_VALUE,
1507: p_token1 => G_COL_NAME_TOKEN,

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

1501:
1502: IF (p_taiv_rec.khr_id IS NULL OR p_taiv_rec.khr_id = Okl_Api.G_MISS_NUM) AND
1503: (p_taiv_rec.irt_id IS NULL OR p_taiv_rec.irt_id = Okl_Api.G_MISS_NUM)
1504: THEN
1505: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1506: p_msg_name => G_REQUIRED_VALUE,
1507: p_token1 => G_COL_NAME_TOKEN,
1508: p_token1_value => 'okl_trx_ar_invoices_b.irt_id');
1509:

Line 1513: IF (p_taiv_rec.khr_id IS NULL OR p_taiv_rec.khr_id = Okl_Api.G_MISS_NUM) AND

1509:
1510: RAISE G_EXCEPTION_HALT_VALIDATION;
1511: END IF;
1512:
1513: IF (p_taiv_rec.khr_id IS NULL OR p_taiv_rec.khr_id = Okl_Api.G_MISS_NUM) AND
1514: (p_taiv_rec.ibt_id IS NULL OR p_taiv_rec.ibt_id = Okl_Api.G_MISS_NUM)
1515: THEN
1516: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1517: p_msg_name => G_REQUIRED_VALUE,

Line 1514: (p_taiv_rec.ibt_id IS NULL OR p_taiv_rec.ibt_id = Okl_Api.G_MISS_NUM)

1510: RAISE G_EXCEPTION_HALT_VALIDATION;
1511: END IF;
1512:
1513: IF (p_taiv_rec.khr_id IS NULL OR p_taiv_rec.khr_id = Okl_Api.G_MISS_NUM) AND
1514: (p_taiv_rec.ibt_id IS NULL OR p_taiv_rec.ibt_id = Okl_Api.G_MISS_NUM)
1515: THEN
1516: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1517: p_msg_name => G_REQUIRED_VALUE,
1518: p_token1 => G_COL_NAME_TOKEN,

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

1512:
1513: IF (p_taiv_rec.khr_id IS NULL OR p_taiv_rec.khr_id = Okl_Api.G_MISS_NUM) AND
1514: (p_taiv_rec.ibt_id IS NULL OR p_taiv_rec.ibt_id = Okl_Api.G_MISS_NUM)
1515: THEN
1516: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1517: p_msg_name => G_REQUIRED_VALUE,
1518: p_token1 => G_COL_NAME_TOKEN,
1519: p_token1_value => 'okl_trx_ar_invoices_b.ibt_id');
1520:

Line 1524: IF (p_taiv_rec.khr_id IS NULL OR p_taiv_rec.khr_id = Okl_Api.G_MISS_NUM) AND

1520:
1521: RAISE G_EXCEPTION_HALT_VALIDATION;
1522: END IF;
1523:
1524: IF (p_taiv_rec.khr_id IS NULL OR p_taiv_rec.khr_id = Okl_Api.G_MISS_NUM) AND
1525: (p_taiv_rec.org_id IS NULL OR p_taiv_rec.org_id = Okl_Api.G_MISS_NUM)
1526: THEN
1527: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1528: p_msg_name => G_REQUIRED_VALUE,

Line 1525: (p_taiv_rec.org_id IS NULL OR p_taiv_rec.org_id = Okl_Api.G_MISS_NUM)

1521: RAISE G_EXCEPTION_HALT_VALIDATION;
1522: END IF;
1523:
1524: IF (p_taiv_rec.khr_id IS NULL OR p_taiv_rec.khr_id = Okl_Api.G_MISS_NUM) AND
1525: (p_taiv_rec.org_id IS NULL OR p_taiv_rec.org_id = Okl_Api.G_MISS_NUM)
1526: THEN
1527: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1528: p_msg_name => G_REQUIRED_VALUE,
1529: p_token1 => G_COL_NAME_TOKEN,

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

1523:
1524: IF (p_taiv_rec.khr_id IS NULL OR p_taiv_rec.khr_id = Okl_Api.G_MISS_NUM) AND
1525: (p_taiv_rec.org_id IS NULL OR p_taiv_rec.org_id = Okl_Api.G_MISS_NUM)
1526: THEN
1527: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1528: p_msg_name => G_REQUIRED_VALUE,
1529: p_token1 => G_COL_NAME_TOKEN,
1530: p_token1_value => 'okl_trx_ar_invoices_b.org_id');
1531:

Line 1535: IF (p_taiv_rec.khr_id IS NULL OR p_taiv_rec.khr_id = Okl_Api.G_MISS_NUM) AND

1531:
1532: RAISE G_EXCEPTION_HALT_VALIDATION;
1533: END IF;
1534:
1535: IF (p_taiv_rec.khr_id IS NULL OR p_taiv_rec.khr_id = Okl_Api.G_MISS_NUM) AND
1536: (p_taiv_rec.legal_entity_id IS NULL OR p_taiv_rec.legal_entity_id = Okl_Api.G_MISS_NUM)
1537: THEN
1538: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1539: p_msg_name => G_REQUIRED_VALUE,

Line 1536: (p_taiv_rec.legal_entity_id IS NULL OR p_taiv_rec.legal_entity_id = Okl_Api.G_MISS_NUM)

1532: RAISE G_EXCEPTION_HALT_VALIDATION;
1533: END IF;
1534:
1535: IF (p_taiv_rec.khr_id IS NULL OR p_taiv_rec.khr_id = Okl_Api.G_MISS_NUM) AND
1536: (p_taiv_rec.legal_entity_id IS NULL OR p_taiv_rec.legal_entity_id = Okl_Api.G_MISS_NUM)
1537: THEN
1538: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1539: p_msg_name => G_REQUIRED_VALUE,
1540: p_token1 => G_COL_NAME_TOKEN,

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

1534:
1535: IF (p_taiv_rec.khr_id IS NULL OR p_taiv_rec.khr_id = Okl_Api.G_MISS_NUM) AND
1536: (p_taiv_rec.legal_entity_id IS NULL OR p_taiv_rec.legal_entity_id = Okl_Api.G_MISS_NUM)
1537: THEN
1538: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1539: p_msg_name => G_REQUIRED_VALUE,
1540: p_token1 => G_COL_NAME_TOKEN,
1541: p_token1_value => 'okl_trx_ar_invoices_b.legal_entity_id');
1542:

Line 1554: OKL_API.set_message(p_app_name => 'OKL',

1550: --gkhuntet added for Manual Invoice on 06-07-2007 End.
1551: p_taiv_rec.trx_status_code IS NOT NULL
1552: and p_taiv_rec.trx_status_code <> G_SUBMITTED
1553: THEN
1554: OKL_API.set_message(p_app_name => 'OKL',
1555: p_msg_name => 'OKL_CONTRACTS_INVALID_VALUE',
1556: p_token1 => 'COL_NAME',
1557: p_token1_value => 'okl_trx_ar_invoices_b.trx_status_code');
1558: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1568: x_return_status := OKL_API.G_RET_STS_ERROR;

1564: x_return_status := l_return_status;
1565:
1566: EXCEPTION
1567: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1568: x_return_status := OKL_API.G_RET_STS_ERROR;
1569: WHEN OTHERS THEN
1570: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
1571: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1572: p_msg_name => G_UNEXPECTED_ERROR,

Line 1570: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

1566: EXCEPTION
1567: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1568: x_return_status := OKL_API.G_RET_STS_ERROR;
1569: WHEN OTHERS THEN
1570: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
1571: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1572: p_msg_name => G_UNEXPECTED_ERROR,
1573: p_token1 => G_SQLCODE_TOKEN,
1574: p_token1_value => SQLCODE,

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

1567: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1568: x_return_status := OKL_API.G_RET_STS_ERROR;
1569: WHEN OTHERS THEN
1570: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
1571: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1572: p_msg_name => G_UNEXPECTED_ERROR,
1573: p_token1 => G_SQLCODE_TOKEN,
1574: p_token1_value => SQLCODE,
1575: p_token2 => G_SQLERRM_TOKEN,

Line 1604: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;

1600: p_tldv_rec IN tldv_rec_type,
1601: p_source IN VARCHAR2,
1602: x_return_status OUT NOCOPY VARCHAR2
1603: ) IS
1604: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
1605: BEGIN
1606: -- rmunjulu R12 Fixes -- do not allow caller to pass values to following columns
1607: --INVOICE_FORMAT_LINE_TYPE
1608: --LATE_CHARGE_ASSESS_DATE

Line 1620: OKL_API.set_message(p_app_name => 'OKL',

1616: --TAX_AMOUNT
1617: --INVOICE_FORMAT_TYPE
1618: /*
1619: IF p_tldv_rec.INVOICE_FORMAT_LINE_TYPE IS NOT NULL THEN
1620: OKL_API.set_message(p_app_name => 'OKL',
1621: p_msg_name => 'OKL_CONTRACTS_INVALID_VALUE',
1622: p_token1 => 'COL_NAME',
1623: p_token1_value => 'INVOICE_FORMAT_LINE_TYPE');
1624: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1628: OKL_API.set_message(p_app_name => 'OKL',

1624: RAISE G_EXCEPTION_HALT_VALIDATION;
1625: END IF;
1626:
1627: IF p_tldv_rec.LATE_CHARGE_ASSESS_DATE IS NOT NULL THEN
1628: OKL_API.set_message(p_app_name => 'OKL',
1629: p_msg_name => 'OKL_CONTRACTS_INVALID_VALUE',
1630: p_token1 => 'COL_NAME',
1631: p_token1_value => 'LATE_CHARGE_ASSESS_DATE');
1632: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1636: OKL_API.set_message(p_app_name => 'OKL',

1632: RAISE G_EXCEPTION_HALT_VALIDATION;
1633: END IF;
1634:
1635: IF p_tldv_rec.LATE_INT_ASSESS_DATE IS NOT NULL THEN
1636: OKL_API.set_message(p_app_name => 'OKL',
1637: p_msg_name => 'OKL_CONTRACTS_INVALID_VALUE',
1638: p_token1 => 'COL_NAME',
1639: p_token1_value => 'LATE_INT_ASSESS_DATE');
1640: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1644: OKL_API.set_message(p_app_name => 'OKL',

1640: RAISE G_EXCEPTION_HALT_VALIDATION;
1641: END IF;
1642:
1643: IF p_tldv_rec.LATE_CHARGE_ASS_YN IS NOT NULL THEN
1644: OKL_API.set_message(p_app_name => 'OKL',
1645: p_msg_name => 'OKL_CONTRACTS_INVALID_VALUE',
1646: p_token1 => 'COL_NAME',
1647: p_token1_value => 'LATE_CHARGE_ASS_YN');
1648: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1652: OKL_API.set_message(p_app_name => 'OKL',

1648: RAISE G_EXCEPTION_HALT_VALIDATION;
1649: END IF;
1650:
1651: IF p_tldv_rec.LATE_INT_ASS_YN IS NOT NULL THEN
1652: OKL_API.set_message(p_app_name => 'OKL',
1653: p_msg_name => 'OKL_CONTRACTS_INVALID_VALUE',
1654: p_token1 => 'COL_NAME',
1655: p_token1_value => 'LATE_INT_ASS_YN');
1656: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1660: OKL_API.set_message(p_app_name => 'OKL',

1656: RAISE G_EXCEPTION_HALT_VALIDATION;
1657: END IF;
1658:
1659: IF p_tldv_rec.INVESTOR_DISB_STATUS IS NOT NULL THEN
1660: OKL_API.set_message(p_app_name => 'OKL',
1661: p_msg_name => 'OKL_CONTRACTS_INVALID_VALUE',
1662: p_token1 => 'COL_NAME',
1663: p_token1_value => 'INVESTOR_DISB_STATUS');
1664: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1668: OKL_API.set_message(p_app_name => 'OKL',

1664: RAISE G_EXCEPTION_HALT_VALIDATION;
1665: END IF;
1666:
1667: IF p_tldv_rec.INVESTOR_DISB_ERR_MG IS NOT NULL THEN
1668: OKL_API.set_message(p_app_name => 'OKL',
1669: p_msg_name => 'OKL_CONTRACTS_INVALID_VALUE',
1670: p_token1 => 'COL_NAME',
1671: p_token1_value => 'INVESTOR_DISB_ERR_MG');
1672: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1676: OKL_API.set_message(p_app_name => 'OKL',

1672: RAISE G_EXCEPTION_HALT_VALIDATION;
1673: END IF;
1674:
1675: IF p_tldv_rec.DATE_DISBURSED IS NOT NULL THEN
1676: OKL_API.set_message(p_app_name => 'OKL',
1677: p_msg_name => 'OKL_CONTRACTS_INVALID_VALUE',
1678: p_token1 => 'COL_NAME',
1679: p_token1_value => 'DATE_DISBURSED');
1680: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1684: OKL_API.set_message(p_app_name => 'OKL',

1680: RAISE G_EXCEPTION_HALT_VALIDATION;
1681: END IF;
1682:
1683: IF p_tldv_rec.PAY_STATUS_CODE IS NOT NULL THEN
1684: OKL_API.set_message(p_app_name => 'OKL',
1685: p_msg_name => 'OKL_CONTRACTS_INVALID_VALUE',
1686: p_token1 => 'COL_NAME',
1687: p_token1_value => 'PAY_STATUS_CODE');
1688: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1692: OKL_API.set_message(p_app_name => 'OKL',

1688: RAISE G_EXCEPTION_HALT_VALIDATION;
1689: END IF;
1690:
1691: IF p_tldv_rec.TAX_AMOUNT IS NOT NULL THEN
1692: OKL_API.set_message(p_app_name => 'OKL',
1693: p_msg_name => 'OKL_CONTRACTS_INVALID_VALUE',
1694: p_token1 => 'COL_NAME',
1695: p_token1_value => 'TAX_AMOUNT');
1696: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1700: OKL_API.set_message(p_app_name => 'OKL',

1696: RAISE G_EXCEPTION_HALT_VALIDATION;
1697: END IF;
1698:
1699: IF p_tldv_rec.INVOICE_FORMAT_TYPE IS NOT NULL THEN
1700: OKL_API.set_message(p_app_name => 'OKL',
1701: p_msg_name => 'OKL_CONTRACTS_INVALID_VALUE',
1702: p_token1 => 'COL_NAME',
1703: p_token1_value => 'INVOICE_FORMAT_TYPE');
1704: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1710: OKL_API.set_message(p_app_name => 'OKL',

1706: */
1707: -- LSM_ID does not exist in tapi yet
1708: /*
1709: IF p_tldv_rec.LSM_ID IS NOT NULL THEN
1710: OKL_API.set_message(p_app_name => 'OKL',
1711: p_msg_name => 'OKL_CONTRACTS_INVALID_VALUE',
1712: p_token1 => 'COL_NAME',
1713: p_token1_value => 'LSM_ID');
1714: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1719: OKL_API.set_message(p_app_name => 'OKL',

1715: END IF;
1716: */
1717: /*
1718: IF p_tldv_rec.KHR_ID IS NOT NULL THEN
1719: OKL_API.set_message(p_app_name => 'OKL',
1720: p_msg_name => 'OKL_CONTRACTS_INVALID_VALUE',
1721: p_token1 => 'COL_NAME',
1722: p_token1_value => 'KHR_ID');
1723: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1728: OKL_API.set_message(p_app_name => 'OKL',

1724: END IF;
1725:
1726: -- if source not rebook then do not allow this column to be populated by called process
1727: IF nvl(p_source,'*') <> 'REBOOK' AND p_tldv_rec.RBK_ORI_INVOICE_NUMBER IS NOT NULL THEN
1728: OKL_API.set_message(p_app_name => 'OKL',
1729: p_msg_name => 'OKL_CONTRACTS_INVALID_VALUE',
1730: p_token1 => 'COL_NAME',
1731: p_token1_value => 'RBK_ORI_INVOICE_NUMBER');
1732: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1737: OKL_API.set_message(p_app_name => 'OKL',

1733: END IF;
1734:
1735: -- if source not rebook then do not allow this column to be populated by called process
1736: IF nvl(p_source,'*') <> 'REBOOK' AND p_tldv_rec.RBK_ORI_INVOICE_LINE_NUMBER IS NOT NULL THEN
1737: OKL_API.set_message(p_app_name => 'OKL',
1738: p_msg_name => 'OKL_CONTRACTS_INVALID_VALUE',
1739: p_token1 => 'COL_NAME',
1740: p_token1_value => 'RBK_ORI_INVOICE_LINE_NUMBER');
1741: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1746: OKL_API.set_message(p_app_name => 'OKL',

1742: END IF;
1743:
1744: -- if source not rebook then do not allow this column to be populated by called process
1745: IF nvl(p_source,'*') <> 'REBOOK' AND p_tldv_rec.RBK_ADJUSTMENT_DATE IS NOT NULL THEN
1746: OKL_API.set_message(p_app_name => 'OKL',
1747: p_msg_name => 'OKL_CONTRACTS_INVALID_VALUE',
1748: p_token1 => 'COL_NAME',
1749: p_token1_value => 'RBK_ADJUSTMENT_DATE');
1750: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1758: IF (p_tldv_rec.SEL_ID IS NULL or p_tldv_rec.SEL_ID = okl_api.g_miss_num )

1754:
1755:
1756: IF G_IS_STREAM_BASED_BILLING = TRUE THEN
1757:
1758: IF (p_tldv_rec.SEL_ID IS NULL or p_tldv_rec.SEL_ID = okl_api.g_miss_num )
1759: AND (p_source <> 'UBB')
1760: --gkhuntet 26-07-2007
1761: AND (p_source <> 'REMARKETING') ----gkhuntet 26-07-2007 -- apaul 20-June-2007
1762: AND (p_source <> 'LEASE_CENTER') THEN -- Added by venkatho as part of Bug# 14483814

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

1759: AND (p_source <> 'UBB')
1760: --gkhuntet 26-07-2007
1761: AND (p_source <> 'REMARKETING') ----gkhuntet 26-07-2007 -- apaul 20-June-2007
1762: AND (p_source <> 'LEASE_CENTER') THEN -- Added by venkatho as part of Bug# 14483814
1763: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1764: p_msg_name => G_REQUIRED_VALUE,
1765: p_token1 => G_COL_NAME_TOKEN,
1766: p_token1_value => 'SEL_ID');
1767: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1778: x_return_status := OKL_API.G_RET_STS_ERROR;

1774: x_return_status := l_return_status;
1775:
1776: EXCEPTION
1777: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1778: x_return_status := OKL_API.G_RET_STS_ERROR;
1779: WHEN OTHERS THEN
1780: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
1781: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1782: p_msg_name => G_UNEXPECTED_ERROR,

Line 1780: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

1776: EXCEPTION
1777: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1778: x_return_status := OKL_API.G_RET_STS_ERROR;
1779: WHEN OTHERS THEN
1780: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
1781: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1782: p_msg_name => G_UNEXPECTED_ERROR,
1783: p_token1 => G_SQLCODE_TOKEN,
1784: p_token1_value => SQLCODE,

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

1777: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1778: x_return_status := OKL_API.G_RET_STS_ERROR;
1779: WHEN OTHERS THEN
1780: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
1781: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1782: p_msg_name => G_UNEXPECTED_ERROR,
1783: p_token1 => G_SQLCODE_TOKEN,
1784: p_token1_value => SQLCODE,
1785: p_token2 => G_SQLERRM_TOKEN,

Line 1809: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;

1805: x_return_status OUT NOCOPY VARCHAR2
1806: )
1807: IS
1808:
1809: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
1810:
1811: BEGIN
1812:
1813: OKL_API.set_message(p_app_name => 'OKL',

Line 1813: OKL_API.set_message(p_app_name => 'OKL',

1809: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
1810:
1811: BEGIN
1812:
1813: OKL_API.set_message(p_app_name => 'OKL',
1814: p_msg_name => p_msg_name,
1815: p_token1 => p_msg_token,
1816: p_token1_value => p_msg_token_val);
1817:

Line 1823: x_return_status := OKL_API.G_RET_STS_ERROR;

1819: x_return_status := l_return_status;
1820:
1821: EXCEPTION
1822: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1823: x_return_status := OKL_API.G_RET_STS_ERROR;
1824: WHEN OTHERS THEN
1825: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
1826: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1827: p_msg_name => G_UNEXPECTED_ERROR,

Line 1825: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

1821: EXCEPTION
1822: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1823: x_return_status := OKL_API.G_RET_STS_ERROR;
1824: WHEN OTHERS THEN
1825: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
1826: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1827: p_msg_name => G_UNEXPECTED_ERROR,
1828: p_token1 => G_SQLCODE_TOKEN,
1829: p_token1_value => SQLCODE,

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

1822: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1823: x_return_status := OKL_API.G_RET_STS_ERROR;
1824: WHEN OTHERS THEN
1825: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
1826: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1827: p_msg_name => G_UNEXPECTED_ERROR,
1828: p_token1 => G_SQLCODE_TOKEN,
1829: p_token1_value => SQLCODE,
1830: p_token2 => G_SQLERRM_TOKEN,

Line 1869: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

1865: ----------------------------------------------------------------------------------
1866:
1867: PROCEDURE create_non_sel_billing_trx(
1868: p_api_version IN NUMBER
1869: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
1870: ,x_return_status OUT NOCOPY VARCHAR2
1871: ,x_msg_count OUT NOCOPY NUMBER
1872: ,x_msg_data OUT NOCOPY VARCHAR2
1873: ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type

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

1882: is
1883: l_api_name CONSTANT VARCHAR2(30) := 'create_non_sel_billing_trx';
1884: l_api_version CONSTANT NUMBER := 1.0;
1885: l_til_loop_cnt NUMBER;
1886: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1887: lp_taiv_rec okl_tai_pvt.taiv_rec_type := p_taiv_rec;
1888: lx_taiv_rec okl_tai_pvt.taiv_rec_type;
1889: lp_tilv_tbl okl_til_pvt.tilv_tbl_type := p_tilv_tbl;
1890: lx_tilv_tbl okl_til_pvt.tilv_tbl_type;

Line 1958: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1954: p_api_version,
1955: l_api_name,
1956: G_PKG_NAME ))
1957: THEN
1958: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1959: END IF;
1960:
1961: -- Initialize message list if requested
1962: IF (FND_API.to_Boolean(p_init_msg_list)) THEN

Line 1967: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1963: FND_MSG_PUB.initialize;
1964: END IF;
1965:
1966: -- Initialize API status to success
1967: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1968:
1969:
1970: /*** Begin API body ****************************************************/
1971:

Line 1980: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1976: validate_tai_values(
1977: p_taiv_rec => lp_taiv_rec,
1978: x_return_status => l_return_status);
1979:
1980: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1981: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1982: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1983: RAISE OKL_API.G_EXCEPTION_ERROR;
1984: END IF;

Line 1981: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1977: p_taiv_rec => lp_taiv_rec,
1978: x_return_status => l_return_status);
1979:
1980: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1981: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1982: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1983: RAISE OKL_API.G_EXCEPTION_ERROR;
1984: END IF;
1985:

Line 1982: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1978: x_return_status => l_return_status);
1979:
1980: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1981: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1982: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1983: RAISE OKL_API.G_EXCEPTION_ERROR;
1984: END IF;
1985:
1986: IF p_cpl_id IS NOT NULL THEN

Line 1983: RAISE OKL_API.G_EXCEPTION_ERROR;

1979:
1980: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1981: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1982: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1983: RAISE OKL_API.G_EXCEPTION_ERROR;
1984: END IF;
1985:
1986: IF p_cpl_id IS NOT NULL THEN
1987: OPEN l_get_rle_code_csr(p_cpl_id);

Line 2007: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

2003:
2004:
2005: lp_taiv_rec := lx_taiv_rec;
2006:
2007: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2008: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2009: x_return_status := l_return_status;
2010: END IF;
2011: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2004:
2005: lp_taiv_rec := lx_taiv_rec;
2006:
2007: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2008: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2009: x_return_status := l_return_status;
2010: END IF;
2011: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2012: END IF;

Line 2011: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2007: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2008: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2009: x_return_status := l_return_status;
2010: END IF;
2011: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2012: END IF;
2013: -- end: cklee -- add additional columns 3/19/07
2014:
2015: okl_tai_pvt.insert_row(

Line 2024: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

2020: x_msg_data => x_msg_data,
2021: p_taiv_rec => lp_taiv_rec,
2022: x_taiv_rec => lx_taiv_rec);
2023:
2024: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2025: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2026: x_return_status := l_return_status;
2027: END IF;
2028: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2021: p_taiv_rec => lp_taiv_rec,
2022: x_taiv_rec => lx_taiv_rec);
2023:
2024: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2025: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2026: x_return_status := l_return_status;
2027: END IF;
2028: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2029: END IF;

Line 2028: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2024: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2025: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2026: x_return_status := l_return_status;
2027: END IF;
2028: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2029: END IF;
2030:
2031: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2032: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lx_taiv_rec.id: '||to_char(lx_taiv_rec.id));

Line 2062: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

2058: x_tilv_rec => lx_tilv_tbl(l_til_loop_cnt));
2059:
2060: lp_tilv_tbl(l_til_loop_cnt) := lx_tilv_tbl(l_til_loop_cnt);
2061:
2062: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2063: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2064: x_return_status := l_return_status;
2065: END IF;
2066: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2059:
2060: lp_tilv_tbl(l_til_loop_cnt) := lx_tilv_tbl(l_til_loop_cnt);
2061:
2062: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2063: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2064: x_return_status := l_return_status;
2065: END IF;
2066: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2067: END IF;

Line 2066: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2062: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2063: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2064: x_return_status := l_return_status;
2065: END IF;
2066: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2067: END IF;
2068: -- end: cklee -- add additional columns 3/19/07
2069:
2070: -- Create okl_TXL_AR_INV_LNS_B record: okl_til_pvt.insert_row;

Line 2081: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

2077: p_tilv_rec => lp_tilv_tbl(l_til_loop_cnt),
2078: x_tilv_rec => lx_tilv_rec);
2079:
2080: -- Error handling lx_taiv_rec;
2081: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2082: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2083: x_return_status := l_return_status;
2084: END IF;
2085: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2078: x_tilv_rec => lx_tilv_rec);
2079:
2080: -- Error handling lx_taiv_rec;
2081: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2082: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2083: x_return_status := l_return_status;
2084: END IF;
2085: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2086: END IF;

Line 2085: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2081: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2082: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2083: x_return_status := l_return_status;
2084: END IF;
2085: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2086: END IF;
2087:
2088: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2089: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lx_tilv_rec.id: '||to_char(lx_tilv_rec.id));

Line 2122: ,p_init_msg_list => OKL_API.G_FALSE

2118:
2119: -- rmunjulu R12 Fixes -- Default invoice_format_type, invoice_format_line_type
2120: Get_Invoice_format(
2121: p_api_version => p_api_version
2122: ,p_init_msg_list => OKL_API.G_FALSE
2123: ,x_return_status => l_return_status
2124: ,x_msg_count => x_msg_count
2125: ,x_msg_data => x_msg_data
2126: ,p_inf_id => lp_taiv_rec.inf_id

Line 2131: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2127: ,p_sty_id => lp_tldv_tbl(l_til_loop_cnt).STY_ID
2128: ,x_invoice_format_type => lp_tldv_tbl(l_til_loop_cnt).invoice_format_type
2129: ,x_invoice_format_line_type => lp_tldv_tbl(l_til_loop_cnt).invoice_format_line_type);
2130:
2131: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2132: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2133: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2134: RAISE OKL_API.G_EXCEPTION_ERROR;
2135: END IF;

Line 2132: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2128: ,x_invoice_format_type => lp_tldv_tbl(l_til_loop_cnt).invoice_format_type
2129: ,x_invoice_format_line_type => lp_tldv_tbl(l_til_loop_cnt).invoice_format_line_type);
2130:
2131: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2132: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2133: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2134: RAISE OKL_API.G_EXCEPTION_ERROR;
2135: END IF;
2136:

Line 2133: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2129: ,x_invoice_format_line_type => lp_tldv_tbl(l_til_loop_cnt).invoice_format_line_type);
2130:
2131: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2132: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2133: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2134: RAISE OKL_API.G_EXCEPTION_ERROR;
2135: END IF;
2136:
2137: -- start: cklee -- add additional columns 3/19/07

Line 2134: RAISE OKL_API.G_EXCEPTION_ERROR;

2130:
2131: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2132: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2133: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2134: RAISE OKL_API.G_EXCEPTION_ERROR;
2135: END IF;
2136:
2137: -- start: cklee -- add additional columns 3/19/07
2138: additional_tld_attr(

Line 2149: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

2145: x_tldv_rec => lx_tldv_tbl(l_til_loop_cnt));
2146:
2147: lp_tldv_tbl(l_til_loop_cnt) := lx_tldv_tbl(l_til_loop_cnt);
2148:
2149: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2150: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2151: x_return_status := l_return_status;
2152: END IF;
2153: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2146:
2147: lp_tldv_tbl(l_til_loop_cnt) := lx_tldv_tbl(l_til_loop_cnt);
2148:
2149: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2150: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2151: x_return_status := l_return_status;
2152: END IF;
2153: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2154: END IF;

Line 2153: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2149: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2150: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2151: x_return_status := l_return_status;
2152: END IF;
2153: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2154: END IF;
2155: -- end: cklee -- add additional columns 3/19/07
2156:
2157: okl_tld_pvt.insert_row(

Line 2166: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

2162: x_msg_data => x_msg_data,
2163: p_tldv_rec => lp_tldv_tbl(l_til_loop_cnt),
2164: x_tldv_rec => lx_tldv_rec);
2165:
2166: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2167: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2168: x_return_status := l_return_status;
2169: END IF;
2170: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2163: p_tldv_rec => lp_tldv_tbl(l_til_loop_cnt),
2164: x_tldv_rec => lx_tldv_rec);
2165:
2166: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2167: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2168: x_return_status := l_return_status;
2169: END IF;
2170: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2171: END IF;

Line 2170: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2166: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2167: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2168: x_return_status := l_return_status;
2169: END IF;
2170: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2171: END IF;
2172: lp_tldv_tbl(l_til_loop_cnt) := lx_tldv_rec;
2173:
2174: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 2201: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

2197: p_tldv_rec => lp_tldv_tbl(l_tld_loop_cnt),
2198: x_tldv_rec => lx_tldv_rec);
2199: -- Assign attributes back to lx_tldv_rec along with ID;
2200: -- Error handling;
2201: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2202: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2203: x_return_status := l_return_status;
2204: END IF;
2205: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2198: x_tldv_rec => lx_tldv_rec);
2199: -- Assign attributes back to lx_tldv_rec along with ID;
2200: -- Error handling;
2201: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2202: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2203: x_return_status := l_return_status;
2204: END IF;
2205: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2206: END IF;

Line 2205: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2201: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2202: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2203: x_return_status := l_return_status;
2204: END IF;
2205: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2206: END IF;
2207: lp_tldv_tbl(l_tld_loop_cnt) := lx_tldv_rec;
2208: -- end if;
2209: End If;

Line 2244: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

2240: p_tldv_tbl => lp_tldv_tbl ,
2241: p_tai_id => lx_taiv_rec.ID
2242: );
2243: END IF;
2244: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2245: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2246: x_return_status := l_return_status;
2247: END IF;
2248: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2241: p_tai_id => lx_taiv_rec.ID
2242: );
2243: END IF;
2244: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2245: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2246: x_return_status := l_return_status;
2247: END IF;
2248: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2249: END IF;

Line 2248: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2244: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2245: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2246: x_return_status := l_return_status;
2247: END IF;
2248: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2249: END IF;
2250: --gkhuntet end.
2251:
2252: /****** Code commented by gkhuntet , call the create_accounting_dist. ******/

Line 2272: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

2268: x_msg_count => x_msg_count,
2269: x_msg_data => x_msg_data,
2270: p_bpd_acc_rec => p_bpd_acc_rec);
2271:
2272: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2273: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2274: x_return_status := l_return_status;
2275: END IF;
2276: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2269: x_msg_data => x_msg_data,
2270: p_bpd_acc_rec => p_bpd_acc_rec);
2271:
2272: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2273: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2274: x_return_status := l_return_status;
2275: END IF;
2276: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2277: END IF;

Line 2276: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2272: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2273: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2274: x_return_status := l_return_status;
2275: END IF;
2276: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2277: END IF;
2278:
2279: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2280: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Okl_Acc_Call_Pub.CREATE_ACC_TRANS:p_bpd_acc_rec.id: '||to_char(p_bpd_acc_rec.id));

Line 2297: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

2293: x_dist_info_rec => l_dist_info_rec,
2294: x_ctxt_val_tbl => l_ctxt_val_tbl,
2295: x_acc_gen_primary_key_tbl => l_acc_gen_primary_key_tbl);
2296:
2297: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2298: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2299: x_return_status := l_return_status;
2300: END IF;
2301: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2294: x_ctxt_val_tbl => l_ctxt_val_tbl,
2295: x_acc_gen_primary_key_tbl => l_acc_gen_primary_key_tbl);
2296:
2297: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2298: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2299: x_return_status := l_return_status;
2300: END IF;
2301: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2302: END IF;

Line 2301: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2297: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2298: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2299: x_return_status := l_return_status;
2300: END IF;
2301: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2302: END IF;
2303:
2304:
2305: --- populate the tables for passing to Okl_Account_Dist_Pvt.CREATE_ACCOUNTING_DIST

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

2342: x_amount_tbl => l_amount_out_tbl,
2343: p_trx_header_id => l_trx_header_id,
2344: p_trx_header_table => l_trx_header_tbl);
2345:
2346: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2347: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2348: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2349: RAISE OKL_API.G_EXCEPTION_ERROR;
2350: END IF;

Line 2347: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2343: p_trx_header_id => l_trx_header_id,
2344: p_trx_header_table => l_trx_header_tbl);
2345:
2346: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2347: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2348: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2349: RAISE OKL_API.G_EXCEPTION_ERROR;
2350: END IF;
2351: */

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

2344: p_trx_header_table => l_trx_header_tbl);
2345:
2346: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2347: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2348: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2349: RAISE OKL_API.G_EXCEPTION_ERROR;
2350: END IF;
2351: */
2352: ---- End Added by Vpanwar --- Code for new accounting API uptake

Line 2349: RAISE OKL_API.G_EXCEPTION_ERROR;

2345:
2346: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2347: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2348: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2349: RAISE OKL_API.G_EXCEPTION_ERROR;
2350: END IF;
2351: */
2352: ---- End Added by Vpanwar --- Code for new accounting API uptake
2353:

Line 2366: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2362: (p_count => x_msg_count,
2363: p_data => x_msg_data);
2364:
2365: EXCEPTION
2366: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2367: ROLLBACK TO create_non_sel_billing_trx;
2368: x_return_status := OKL_API.G_RET_STS_ERROR;
2369: FND_MSG_PUB.Count_And_Get
2370: (p_count => x_msg_count,

Line 2368: x_return_status := OKL_API.G_RET_STS_ERROR;

2364:
2365: EXCEPTION
2366: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2367: ROLLBACK TO create_non_sel_billing_trx;
2368: x_return_status := OKL_API.G_RET_STS_ERROR;
2369: FND_MSG_PUB.Count_And_Get
2370: (p_count => x_msg_count,
2371: p_data => x_msg_data);
2372:

Line 2373: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2369: FND_MSG_PUB.Count_And_Get
2370: (p_count => x_msg_count,
2371: p_data => x_msg_data);
2372:
2373: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2374: ROLLBACK TO create_non_sel_billing_trx;
2375: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2376: FND_MSG_PUB.Count_And_Get
2377: (p_count => x_msg_count,

Line 2375: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

2371: p_data => x_msg_data);
2372:
2373: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2374: ROLLBACK TO create_non_sel_billing_trx;
2375: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2376: FND_MSG_PUB.Count_And_Get
2377: (p_count => x_msg_count,
2378: p_data => x_msg_data);
2379:

Line 2383: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

2379:
2380: WHEN OTHERS THEN
2381: ROLLBACK TO create_non_sel_billing_trx;
2382:
2383: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
2384: OKL_API.Set_Message(p_app_name => G_APP_NAME,
2385: p_msg_name => G_UNEXPECTED_ERROR,
2386: p_token1 => G_SQLCODE_TOKEN,
2387: p_token1_value => SQLCODE,

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

2380: WHEN OTHERS THEN
2381: ROLLBACK TO create_non_sel_billing_trx;
2382:
2383: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
2384: OKL_API.Set_Message(p_app_name => G_APP_NAME,
2385: p_msg_name => G_UNEXPECTED_ERROR,
2386: p_token1 => G_SQLCODE_TOKEN,
2387: p_token1_value => SQLCODE,
2388: p_token2 => G_SQLERRM_TOKEN,

Line 2437: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

2433: ----------------------------------------------------------------------------------
2434:
2435: PROCEDURE create_sel_billing_trx(
2436: p_api_version IN NUMBER
2437: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
2438: ,x_return_status OUT NOCOPY VARCHAR2
2439: ,x_msg_count OUT NOCOPY NUMBER
2440: ,x_msg_data OUT NOCOPY VARCHAR2
2441: ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type

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

2448: is
2449: l_api_name CONSTANT VARCHAR2(30) := 'create_sel_billing_trx';
2450: l_api_version CONSTANT NUMBER := 1.0;
2451: l_til_loop_cnt NUMBER;
2452: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2453: lp_taiv_rec okl_tai_pvt.taiv_rec_type := p_taiv_rec;
2454: lx_taiv_rec okl_tai_pvt.taiv_rec_type;
2455: lp_tilv_tbl okl_til_pvt.tilv_tbl_type := p_tilv_tbl;
2456: lx_tilv_tbl okl_til_pvt.tilv_tbl_type;

Line 2523: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2519: p_api_version,
2520: l_api_name,
2521: G_PKG_NAME ))
2522: THEN
2523: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2524: END IF;
2525:
2526: -- Initialize message list if requested
2527: IF (FND_API.to_Boolean(p_init_msg_list)) THEN

Line 2532: x_return_status := OKL_API.G_RET_STS_SUCCESS;

2528: FND_MSG_PUB.initialize;
2529: END IF;
2530:
2531: -- Initialize API status to success
2532: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2533:
2534:
2535: /*** Begin API body ****************************************************/
2536:

Line 2547: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2543: validate_tai_values(
2544: p_taiv_rec => lp_taiv_rec,
2545: x_return_status => l_return_status);
2546:
2547: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2548: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2549: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2550: RAISE OKL_API.G_EXCEPTION_ERROR;
2551: END IF;

Line 2548: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2544: p_taiv_rec => lp_taiv_rec,
2545: x_return_status => l_return_status);
2546:
2547: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2548: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2549: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2550: RAISE OKL_API.G_EXCEPTION_ERROR;
2551: END IF;
2552:

Line 2549: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2545: x_return_status => l_return_status);
2546:
2547: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2548: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2549: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2550: RAISE OKL_API.G_EXCEPTION_ERROR;
2551: END IF;
2552:
2553: additional_tai_attr(

Line 2550: RAISE OKL_API.G_EXCEPTION_ERROR;

2546:
2547: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2548: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2549: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2550: RAISE OKL_API.G_EXCEPTION_ERROR;
2551: END IF;
2552:
2553: additional_tai_attr(
2554: p_api_version => p_api_version,

Line 2564: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

2560: x_taiv_rec => lx_taiv_rec);
2561:
2562: lp_taiv_rec := lx_taiv_rec;
2563:
2564: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2565: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2566: x_return_status := l_return_status;
2567: END IF;
2568: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2561:
2562: lp_taiv_rec := lx_taiv_rec;
2563:
2564: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2565: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2566: x_return_status := l_return_status;
2567: END IF;
2568: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2569: END IF;

Line 2568: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2564: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2565: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2566: x_return_status := l_return_status;
2567: END IF;
2568: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2569: END IF;
2570: -- end: cklee -- add additional columns 3/19/07
2571:
2572: okl_tai_pvt.insert_row(

Line 2581: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

2577: x_msg_data => x_msg_data,
2578: p_taiv_rec => lp_taiv_rec,
2579: x_taiv_rec => lx_taiv_rec);
2580:
2581: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2582: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2583: x_return_status := l_return_status;
2584: END IF;
2585: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2578: p_taiv_rec => lp_taiv_rec,
2579: x_taiv_rec => lx_taiv_rec);
2580:
2581: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2582: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2583: x_return_status := l_return_status;
2584: END IF;
2585: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2586: END IF;

Line 2585: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2581: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2582: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2583: x_return_status := l_return_status;
2584: END IF;
2585: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2586: END IF;
2587: -- 3. Assign attributes back to lx_taiv_rec along with ID (passed lx_taiv_rec as OUT parameter)
2588: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2589: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lx_taiv_rec.id: '||to_char(lx_taiv_rec.id));

Line 2617: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

2613: x_tilv_rec => lx_tilv_tbl(l_til_loop_cnt));
2614:
2615: lp_tilv_tbl(l_til_loop_cnt) := lx_tilv_tbl(l_til_loop_cnt);
2616:
2617: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2618: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2619: x_return_status := l_return_status;
2620: END IF;
2621: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2614:
2615: lp_tilv_tbl(l_til_loop_cnt) := lx_tilv_tbl(l_til_loop_cnt);
2616:
2617: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2618: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2619: x_return_status := l_return_status;
2620: END IF;
2621: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2622: END IF;

Line 2621: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2617: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2618: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2619: x_return_status := l_return_status;
2620: END IF;
2621: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2622: END IF;
2623: -- end: cklee -- add additional columns 3/19/07
2624:
2625: -- Create okl_TXL_AR_INV_LNS_B record: okl_til_pvt.insert_row;

Line 2636: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

2632: p_tilv_rec => lp_tilv_tbl(l_til_loop_cnt),
2633: x_tilv_rec => lx_tilv_rec);
2634:
2635: -- Error handling lx_taiv_rec;
2636: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2637: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2638: x_return_status := l_return_status;
2639: END IF;
2640: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2633: x_tilv_rec => lx_tilv_rec);
2634:
2635: -- Error handling lx_taiv_rec;
2636: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2637: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2638: x_return_status := l_return_status;
2639: END IF;
2640: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2641: END IF;

Line 2640: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2636: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2637: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2638: x_return_status := l_return_status;
2639: END IF;
2640: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2641: END IF;
2642: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2643: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lx_tilv_rec.id: '||to_char(lx_tilv_rec.id));
2644: END IF;

Line 2671: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2667: p_tldv_rec => lp_tldv_tbl(l_til_loop_cnt),
2668: p_source => lp_taiv_rec.okl_source_billing_trx,
2669: x_return_status => l_return_status);
2670:
2671: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2672: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2673: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2674: RAISE OKL_API.G_EXCEPTION_ERROR;
2675: END IF;

Line 2672: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2668: p_source => lp_taiv_rec.okl_source_billing_trx,
2669: x_return_status => l_return_status);
2670:
2671: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2672: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2673: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2674: RAISE OKL_API.G_EXCEPTION_ERROR;
2675: END IF;
2676:

Line 2673: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2669: x_return_status => l_return_status);
2670:
2671: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2672: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2673: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2674: RAISE OKL_API.G_EXCEPTION_ERROR;
2675: END IF;
2676:
2677: -- Assign lx_til_rec.ID to lp_tld_rec.TIL_ID_DETAILS;

Line 2674: RAISE OKL_API.G_EXCEPTION_ERROR;

2670:
2671: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2672: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2673: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2674: RAISE OKL_API.G_EXCEPTION_ERROR;
2675: END IF;
2676:
2677: -- Assign lx_til_rec.ID to lp_tld_rec.TIL_ID_DETAILS;
2678: lp_tldv_tbl(l_tld_loop_cnt).TIL_ID_DETAILS := l_til_id;

Line 2696: ,p_init_msg_list => OKL_API.G_FALSE

2692:
2693: -- rmunjulu R12 Fixes -- Default invoice_format_type, invoice_format_line_type
2694: Get_Invoice_format(
2695: p_api_version => p_api_version
2696: ,p_init_msg_list => OKL_API.G_FALSE
2697: ,x_return_status => l_return_status
2698: ,x_msg_count => x_msg_count
2699: ,x_msg_data => x_msg_data
2700: ,p_inf_id => lp_taiv_rec.inf_id

Line 2705: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2701: ,p_sty_id => lp_tldv_tbl(l_til_loop_cnt).STY_ID
2702: ,x_invoice_format_type => lp_tldv_tbl(l_til_loop_cnt).invoice_format_type
2703: ,x_invoice_format_line_type => lp_tldv_tbl(l_til_loop_cnt).invoice_format_line_type);
2704:
2705: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2706: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2707: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2708: RAISE OKL_API.G_EXCEPTION_ERROR;
2709: END IF;

Line 2706: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2702: ,x_invoice_format_type => lp_tldv_tbl(l_til_loop_cnt).invoice_format_type
2703: ,x_invoice_format_line_type => lp_tldv_tbl(l_til_loop_cnt).invoice_format_line_type);
2704:
2705: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2706: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2707: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2708: RAISE OKL_API.G_EXCEPTION_ERROR;
2709: END IF;
2710:

Line 2707: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2703: ,x_invoice_format_line_type => lp_tldv_tbl(l_til_loop_cnt).invoice_format_line_type);
2704:
2705: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2706: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2707: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2708: RAISE OKL_API.G_EXCEPTION_ERROR;
2709: END IF;
2710:
2711: -- start: cklee -- add additional columns 3/19/07

Line 2708: RAISE OKL_API.G_EXCEPTION_ERROR;

2704:
2705: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2706: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2707: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2708: RAISE OKL_API.G_EXCEPTION_ERROR;
2709: END IF;
2710:
2711: -- start: cklee -- add additional columns 3/19/07
2712: additional_tld_attr(

Line 2723: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

2719: x_tldv_rec => lx_tldv_tbl(l_tld_loop_cnt));
2720:
2721: lp_tldv_tbl(l_tld_loop_cnt) := lx_tldv_tbl(l_tld_loop_cnt);
2722:
2723: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2724: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2725: x_return_status := l_return_status;
2726: END IF;
2727: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2720:
2721: lp_tldv_tbl(l_tld_loop_cnt) := lx_tldv_tbl(l_tld_loop_cnt);
2722:
2723: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2724: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2725: x_return_status := l_return_status;
2726: END IF;
2727: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2728: END IF;

Line 2727: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2723: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2724: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2725: x_return_status := l_return_status;
2726: END IF;
2727: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2728: END IF;
2729: -- end: cklee -- add additional columns 3/19/07
2730:
2731: okl_tld_pvt.insert_row(

Line 2741: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

2737: p_tldv_rec => lp_tldv_tbl(l_tld_loop_cnt),
2738: x_tldv_rec => lx_tldv_rec);
2739: -- Assign attributes back to lx_tldv_rec along with ID;
2740: -- Error handling;
2741: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2742: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2743: x_return_status := l_return_status;
2744: END IF;
2745: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2738: x_tldv_rec => lx_tldv_rec);
2739: -- Assign attributes back to lx_tldv_rec along with ID;
2740: -- Error handling;
2741: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2742: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2743: x_return_status := l_return_status;
2744: END IF;
2745: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2746: END IF;

Line 2745: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2741: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2742: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2743: x_return_status := l_return_status;
2744: END IF;
2745: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2746: END IF;
2747: lp_tldv_tbl(l_tld_loop_cnt) := lx_tldv_rec;
2748:
2749: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 2778: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

2774: x_msg_data => x_msg_data ,
2775: p_tldv_tbl => lp_tldv_tbl ,
2776: p_tai_id => lx_taiv_rec.ID);
2777:
2778: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2779: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2780: x_return_status := l_return_status;
2781: END IF;
2782: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2775: p_tldv_tbl => lp_tldv_tbl ,
2776: p_tai_id => lx_taiv_rec.ID);
2777:
2778: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2779: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2780: x_return_status := l_return_status;
2781: END IF;
2782: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2783: END IF;

Line 2782: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2778: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2779: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2780: x_return_status := l_return_status;
2781: END IF;
2782: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2783: END IF;
2784: --gkhuntet end.
2785:
2786: /*-- Increase the counter;

Line 2805: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

2801: x_msg_count => x_msg_count,
2802: x_msg_data => x_msg_data,
2803: p_bpd_acc_rec => p_bpd_acc_rec);
2804:
2805: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2806: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2807: x_return_status := l_return_status;
2808: END IF;
2809: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2802: x_msg_data => x_msg_data,
2803: p_bpd_acc_rec => p_bpd_acc_rec);
2804:
2805: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2806: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2807: x_return_status := l_return_status;
2808: END IF;
2809: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2810: END IF;

Line 2809: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2805: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2806: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2807: x_return_status := l_return_status;
2808: END IF;
2809: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2810: END IF;
2811:
2812: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2813: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Okl_Acc_Call_Pub.CREATE_ACC_TRANS:p_bpd_acc_rec.id: '||to_char(p_bpd_acc_rec.id));

Line 2832: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

2828: x_dist_info_rec => l_dist_info_rec,
2829: x_ctxt_val_tbl => l_ctxt_val_tbl,
2830: x_acc_gen_primary_key_tbl => l_acc_gen_primary_key_tbl);
2831:
2832: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2833: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2834: x_return_status := l_return_status;
2835: END IF;
2836: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2829: x_ctxt_val_tbl => l_ctxt_val_tbl,
2830: x_acc_gen_primary_key_tbl => l_acc_gen_primary_key_tbl);
2831:
2832: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2833: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2834: x_return_status := l_return_status;
2835: END IF;
2836: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2837: END IF;

Line 2836: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2832: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2833: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2834: x_return_status := l_return_status;
2835: END IF;
2836: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2837: END IF;
2838:
2839:
2840: --- populate the tables for passing to Okl_Account_Dist_Pvt.CREATE_ACCOUNTING_DIST

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

2878: x_amount_tbl => l_amount_out_tbl,
2879: p_trx_header_id => l_trx_header_id,
2880: p_trx_header_table => l_trx_header_tbl);
2881:
2882: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2883: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2884: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2885: RAISE OKL_API.G_EXCEPTION_ERROR;
2886: END IF;

Line 2883: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2879: p_trx_header_id => l_trx_header_id,
2880: p_trx_header_table => l_trx_header_tbl);
2881:
2882: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2883: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2884: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2885: RAISE OKL_API.G_EXCEPTION_ERROR;
2886: END IF;
2887: */

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

2880: p_trx_header_table => l_trx_header_tbl);
2881:
2882: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2883: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2884: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2885: RAISE OKL_API.G_EXCEPTION_ERROR;
2886: END IF;
2887: */
2888: ---- End Added by Vpanwar --- Code for new accounting API uptake

Line 2885: RAISE OKL_API.G_EXCEPTION_ERROR;

2881:
2882: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2883: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2884: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2885: RAISE OKL_API.G_EXCEPTION_ERROR;
2886: END IF;
2887: */
2888: ---- End Added by Vpanwar --- Code for new accounting API uptake
2889:

Line 2901: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2897: (p_count => x_msg_count,
2898: p_data => x_msg_data);
2899:
2900: EXCEPTION
2901: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2902: ROLLBACK TO create_sel_billing_trx;
2903: x_return_status := OKL_API.G_RET_STS_ERROR;
2904: FND_MSG_PUB.Count_And_Get
2905: (p_count => x_msg_count,

Line 2903: x_return_status := OKL_API.G_RET_STS_ERROR;

2899:
2900: EXCEPTION
2901: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2902: ROLLBACK TO create_sel_billing_trx;
2903: x_return_status := OKL_API.G_RET_STS_ERROR;
2904: FND_MSG_PUB.Count_And_Get
2905: (p_count => x_msg_count,
2906: p_data => x_msg_data);
2907:

Line 2908: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2904: FND_MSG_PUB.Count_And_Get
2905: (p_count => x_msg_count,
2906: p_data => x_msg_data);
2907:
2908: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2909: ROLLBACK TO create_sel_billing_trx;
2910: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2911: FND_MSG_PUB.Count_And_Get
2912: (p_count => x_msg_count,

Line 2910: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

2906: p_data => x_msg_data);
2907:
2908: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2909: ROLLBACK TO create_sel_billing_trx;
2910: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2911: FND_MSG_PUB.Count_And_Get
2912: (p_count => x_msg_count,
2913: p_data => x_msg_data);
2914:

Line 2917: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

2913: p_data => x_msg_data);
2914:
2915: WHEN OTHERS THEN
2916: ROLLBACK TO create_sel_billing_trx;
2917: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
2918: OKL_API.Set_Message(p_app_name => G_APP_NAME,
2919: p_msg_name => G_UNEXPECTED_ERROR,
2920: p_token1 => G_SQLCODE_TOKEN,
2921: p_token1_value => SQLCODE,

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

2914:
2915: WHEN OTHERS THEN
2916: ROLLBACK TO create_sel_billing_trx;
2917: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
2918: OKL_API.Set_Message(p_app_name => G_APP_NAME,
2919: p_msg_name => G_UNEXPECTED_ERROR,
2920: p_token1 => G_SQLCODE_TOKEN,
2921: p_token1_value => SQLCODE,
2922: p_token2 => G_SQLERRM_TOKEN,

Line 2994: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

2990: -- End of comments
2991: ----------------------------------------------------------------------------------
2992: PROCEDURE create_billing_trx(
2993: p_api_version IN NUMBER
2994: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
2995: ,x_return_status OUT NOCOPY VARCHAR2
2996: ,x_msg_count OUT NOCOPY NUMBER
2997: ,x_msg_data OUT NOCOPY VARCHAR2
2998: ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type

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

3006: is
3007: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_BILLING_TRX';
3008: l_api_version CONSTANT NUMBER := 1.0;
3009: l_til_loop_cnt NUMBER;
3010: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3011: lp_taiv_rec okl_tai_pvt.taiv_rec_type := p_taiv_rec;
3012: lx_taiv_rec okl_tai_pvt.taiv_rec_type;
3013: lp_tilv_tbl okl_til_pvt.tilv_tbl_type := p_tilv_tbl;
3014: lx_tilv_tbl okl_til_pvt.tilv_tbl_type;

Line 3124: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3120: p_api_version,
3121: l_api_name,
3122: G_PKG_NAME ))
3123: THEN
3124: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3125: END IF;
3126:
3127: -- Initialize message list if requested
3128: IF (FND_API.to_Boolean(p_init_msg_list)) THEN

Line 3133: x_return_status := OKL_API.G_RET_STS_SUCCESS;

3129: FND_MSG_PUB.initialize;
3130: END IF;
3131:
3132: -- Initialize API status to success
3133: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3134:
3135:
3136: /*** Begin API body ****************************************************/
3137:

Line 3145: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

3141: p_tilv_tbl => lp_tilv_tbl,
3142: p_tldv_tbl => lp_tldv_tbl);
3143:
3144: --- Store the highest degree of error
3145: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3146: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3147: x_return_status := l_return_status;
3148: END IF;
3149: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

3142: p_tldv_tbl => lp_tldv_tbl);
3143:
3144: --- Store the highest degree of error
3145: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3146: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3147: x_return_status := l_return_status;
3148: END IF;
3149: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3150: END IF;

Line 3149: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3145: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3146: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3147: x_return_status := l_return_status;
3148: END IF;
3149: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3150: END IF;
3151:
3152: IF G_IS_STREAM_BASED_BILLING = TRUE THEN
3153:

Line 3167: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

3163: x_taiv_rec => lx_taiv_rec,
3164: x_tilv_tbl => lx_tilv_tbl,
3165: x_tldv_tbl => lx_tldv_tbl);
3166:
3167: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3168: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3169: x_return_status := l_return_status;
3170: END IF;
3171: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

3164: x_tilv_tbl => lx_tilv_tbl,
3165: x_tldv_tbl => lx_tldv_tbl);
3166:
3167: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3168: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3169: x_return_status := l_return_status;
3170: END IF;
3171: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3172: END IF;

Line 3171: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3167: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3168: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3169: x_return_status := l_return_status;
3170: END IF;
3171: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3172: END IF;
3173:
3174: ELSE
3175:

Line 3191: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

3187: x_tldv_tbl => lx_tldv_tbl,
3188: -- end: cklee -- fixed return parameters issues 4/6/07
3189: p_cpl_id => p_cpl_id);
3190:
3191: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3192: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3193: x_return_status := l_return_status;
3194: END IF;
3195: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

3188: -- end: cklee -- fixed return parameters issues 4/6/07
3189: p_cpl_id => p_cpl_id);
3190:
3191: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3192: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3193: x_return_status := l_return_status;
3194: END IF;
3195: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3196: END IF;

Line 3195: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3191: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3192: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3193: x_return_status := l_return_status;
3194: END IF;
3195: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3196: END IF;
3197:
3198: END IF;
3199:

Line 3222: WHEN OKL_API.G_EXCEPTION_ERROR THEN

3218:
3219: END IF; -- End of IF (l_bankruptcy_flag = 'N') added as part of Bug# 14119181
3220:
3221: EXCEPTION
3222: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3223: ROLLBACK TO CREATE_BILLING_TRX;
3224: x_return_status := OKL_API.G_RET_STS_ERROR;
3225: FND_MSG_PUB.Count_And_Get
3226: (p_count => x_msg_count,

Line 3224: x_return_status := OKL_API.G_RET_STS_ERROR;

3220:
3221: EXCEPTION
3222: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3223: ROLLBACK TO CREATE_BILLING_TRX;
3224: x_return_status := OKL_API.G_RET_STS_ERROR;
3225: FND_MSG_PUB.Count_And_Get
3226: (p_count => x_msg_count,
3227: p_data => x_msg_data);
3228:

Line 3229: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3225: FND_MSG_PUB.Count_And_Get
3226: (p_count => x_msg_count,
3227: p_data => x_msg_data);
3228:
3229: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3230: ROLLBACK TO CREATE_BILLING_TRX;
3231: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
3232: FND_MSG_PUB.Count_And_Get
3233: (p_count => x_msg_count,

Line 3231: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

3227: p_data => x_msg_data);
3228:
3229: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3230: ROLLBACK TO CREATE_BILLING_TRX;
3231: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
3232: FND_MSG_PUB.Count_And_Get
3233: (p_count => x_msg_count,
3234: p_data => x_msg_data);
3235:

Line 3238: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

3234: p_data => x_msg_data);
3235:
3236: WHEN OTHERS THEN
3237: ROLLBACK TO CREATE_BILLING_TRX;
3238: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
3239: OKL_API.Set_Message(p_app_name => G_APP_NAME,
3240: p_msg_name => G_UNEXPECTED_ERROR,
3241: p_token1 => G_SQLCODE_TOKEN,
3242: p_token1_value => SQLCODE,

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

3235:
3236: WHEN OTHERS THEN
3237: ROLLBACK TO CREATE_BILLING_TRX;
3238: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
3239: OKL_API.Set_Message(p_app_name => G_APP_NAME,
3240: p_msg_name => G_UNEXPECTED_ERROR,
3241: p_token1 => G_SQLCODE_TOKEN,
3242: p_token1_value => SQLCODE,
3243: p_token2 => G_SQLERRM_TOKEN,

Line 3271: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

3267: -- End of comments
3268: ----------------------------------------------------------------------------------
3269: PROCEDURE Get_Invoice_format(
3270: p_api_version IN NUMBER
3271: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
3272: ,x_return_status OUT NOCOPY VARCHAR2
3273: ,x_msg_count OUT NOCOPY NUMBER
3274: ,x_msg_data OUT NOCOPY VARCHAR2
3275: ,p_inf_id IN NUMBER DEFAULT NULL

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

3279: )
3280: is
3281: l_api_name CONSTANT VARCHAR2(30) := 'Get_Invoice_format';
3282: l_api_version CONSTANT NUMBER := 1.0;
3283: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3284:
3285: CURSOR inv_format_csr ( p_format_id IN NUMBER, p_stream_id IN NUMBER ) IS
3286: SELECT
3287: ity.name ity_name,

Line 3331: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3327: p_api_version,
3328: l_api_name,
3329: G_PKG_NAME ))
3330: THEN
3331: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3332: END IF;
3333:
3334: -- Initialize message list if requested
3335: IF (FND_API.to_Boolean(p_init_msg_list)) THEN

Line 3340: x_return_status := OKL_API.G_RET_STS_SUCCESS;

3336: FND_MSG_PUB.initialize;
3337: END IF;
3338:
3339: -- Initialize API status to success
3340: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3341:
3342:
3343: /*** Begin API body ****************************************************/
3344:

Line 3384: WHEN OKL_API.G_EXCEPTION_ERROR THEN

3380: (p_count => x_msg_count,
3381: p_data => x_msg_data);
3382:
3383: EXCEPTION
3384: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3385: ROLLBACK TO Get_Invoice_format;
3386: x_return_status := OKL_API.G_RET_STS_ERROR;
3387: FND_MSG_PUB.Count_And_Get
3388: (p_count => x_msg_count,

Line 3386: x_return_status := OKL_API.G_RET_STS_ERROR;

3382:
3383: EXCEPTION
3384: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3385: ROLLBACK TO Get_Invoice_format;
3386: x_return_status := OKL_API.G_RET_STS_ERROR;
3387: FND_MSG_PUB.Count_And_Get
3388: (p_count => x_msg_count,
3389: p_data => x_msg_data);
3390:

Line 3391: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3387: FND_MSG_PUB.Count_And_Get
3388: (p_count => x_msg_count,
3389: p_data => x_msg_data);
3390:
3391: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3392: ROLLBACK TO Get_Invoice_format;
3393: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
3394: FND_MSG_PUB.Count_And_Get
3395: (p_count => x_msg_count,

Line 3393: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

3389: p_data => x_msg_data);
3390:
3391: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3392: ROLLBACK TO Get_Invoice_format;
3393: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
3394: FND_MSG_PUB.Count_And_Get
3395: (p_count => x_msg_count,
3396: p_data => x_msg_data);
3397:

Line 3400: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

3396: p_data => x_msg_data);
3397:
3398: WHEN OTHERS THEN
3399: ROLLBACK TO Get_Invoice_format;
3400: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
3401: OKL_API.Set_Message(p_app_name => G_APP_NAME,
3402: p_msg_name => G_UNEXPECTED_ERROR,
3403: p_token1 => G_SQLCODE_TOKEN,
3404: p_token1_value => SQLCODE,

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

3397:
3398: WHEN OTHERS THEN
3399: ROLLBACK TO Get_Invoice_format;
3400: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
3401: OKL_API.Set_Message(p_app_name => G_APP_NAME,
3402: p_msg_name => G_UNEXPECTED_ERROR,
3403: p_token1 => G_SQLCODE_TOKEN,
3404: p_token1_value => SQLCODE,
3405: p_token2 => G_SQLERRM_TOKEN,

Line 3433: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

3429: -- End of comments
3430:
3431: PROCEDURE update_manual_invoice(
3432: p_api_version IN NUMBER
3433: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
3434: ,x_return_status OUT NOCOPY VARCHAR2
3435: ,x_msg_count OUT NOCOPY NUMBER
3436: ,x_msg_data OUT NOCOPY VARCHAR2
3437: ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type

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

3444:
3445: l_api_name CONSTANT VARCHAR2(30) := 'update_manual_invoice';
3446: l_api_version CONSTANT NUMBER := 1.0;
3447: l_til_loop_cnt NUMBER;
3448: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3449: lp_taiv_rec okl_tai_pvt.taiv_rec_type := p_taiv_rec;
3450: lx_taiv_rec okl_tai_pvt.taiv_rec_type;
3451: lp_tilv_tbl okl_til_pvt.tilv_tbl_type := p_tilv_tbl;
3452: lx_tilv_tbl okl_til_pvt.tilv_tbl_type;

Line 3479: x_return_status := OKL_API.G_RET_STS_SUCCESS;

3475:
3476: BEGIN
3477:
3478: SAVEPOINT UPDATE_MANUAL_INVOICE;
3479: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3480: x_return_status := OKL_API.START_ACTIVITY( l_api_name
3481: , g_pkg_name
3482: , p_init_msg_list
3483: , l_api_version

Line 3480: x_return_status := OKL_API.START_ACTIVITY( l_api_name

3476: BEGIN
3477:
3478: SAVEPOINT UPDATE_MANUAL_INVOICE;
3479: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3480: x_return_status := OKL_API.START_ACTIVITY( l_api_name
3481: , g_pkg_name
3482: , p_init_msg_list
3483: , l_api_version
3484: , p_api_version

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

3483: , l_api_version
3484: , p_api_version
3485: , '_PVT'
3486: , x_return_status);
3487: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3488: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3489: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3490: RAISE OKL_API.G_EXCEPTION_ERROR;
3491: END IF;

Line 3488: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3484: , p_api_version
3485: , '_PVT'
3486: , x_return_status);
3487: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3488: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3489: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3490: RAISE OKL_API.G_EXCEPTION_ERROR;
3491: END IF;
3492:

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

3485: , '_PVT'
3486: , x_return_status);
3487: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3488: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3489: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3490: RAISE OKL_API.G_EXCEPTION_ERROR;
3491: END IF;
3492:
3493: --Validating the TAI Attributes.

Line 3490: RAISE OKL_API.G_EXCEPTION_ERROR;

3486: , x_return_status);
3487: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3488: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3489: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3490: RAISE OKL_API.G_EXCEPTION_ERROR;
3491: END IF;
3492:
3493: --Validating the TAI Attributes.
3494: validate_tai_values(

Line 3498: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

3494: validate_tai_values(
3495: p_taiv_rec => lp_taiv_rec,
3496: x_return_status => l_return_status);
3497:
3498: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3499: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3500: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3501: RAISE OKL_API.G_EXCEPTION_ERROR;
3502: END IF;

Line 3499: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3495: p_taiv_rec => lp_taiv_rec,
3496: x_return_status => l_return_status);
3497:
3498: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3499: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3500: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3501: RAISE OKL_API.G_EXCEPTION_ERROR;
3502: END IF;
3503: --Updating the TAI table.

Line 3500: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

3496: x_return_status => l_return_status);
3497:
3498: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3499: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3500: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3501: RAISE OKL_API.G_EXCEPTION_ERROR;
3502: END IF;
3503: --Updating the TAI table.
3504: okl_tai_pvt.update_row(

Line 3501: RAISE OKL_API.G_EXCEPTION_ERROR;

3497:
3498: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3499: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3500: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3501: RAISE OKL_API.G_EXCEPTION_ERROR;
3502: END IF;
3503: --Updating the TAI table.
3504: okl_tai_pvt.update_row(
3505: p_api_version => p_api_version,

Line 3513: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

3509: x_msg_data => x_msg_data,
3510: p_taiv_rec => lp_taiv_rec,
3511: x_taiv_rec => lx_taiv_rec);
3512:
3513: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3514: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3515: x_return_status := l_return_status;
3516: END IF;
3517: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

3510: p_taiv_rec => lp_taiv_rec,
3511: x_taiv_rec => lx_taiv_rec);
3512:
3513: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3514: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3515: x_return_status := l_return_status;
3516: END IF;
3517: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3518: END IF;

Line 3517: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3513: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3514: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3515: x_return_status := l_return_status;
3516: END IF;
3517: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3518: END IF;
3519:
3520: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3521: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lx_taiv_rec.id: '||to_char(lx_taiv_rec.id));

Line 3529: IF (lp_tilv_tbl(i).id = OKL_API.G_MISS_NUM or

3525:
3526:
3527: --TO filter the insert and update record from the the lp_tilv_tbl.
3528: FOR i IN lp_tilv_tbl.FIRST .. lp_tilv_tbl.LAST LOOP
3529: IF (lp_tilv_tbl(i).id = OKL_API.G_MISS_NUM or
3530: lp_tilv_tbl(i).id IS NULL) THEN
3531: l_tilv_Crt_tbl(crt_count) := lp_tilv_tbl(i);
3532: crt_count := crt_count + 1;
3533: ELSE

Line 3551: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

3547: x_msg_data => x_msg_data,
3548: p_tilv_rec => l_tilv_Updt_tbl(i),
3549: x_tilv_rec => lx_tilv_rec);
3550:
3551: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3552: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3553: x_return_status := l_return_status;
3554: END IF;
3555: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

3548: p_tilv_rec => l_tilv_Updt_tbl(i),
3549: x_tilv_rec => lx_tilv_rec);
3550:
3551: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3552: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3553: x_return_status := l_return_status;
3554: END IF;
3555: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3556: END IF;

Line 3555: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3551: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3552: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3553: x_return_status := l_return_status;
3554: END IF;
3555: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3556: END IF;
3557:
3558: --Run the Cursor that query record from the TLD on the basis l_tilv_Updt_tbl(i).id
3559: -- Which is TIL_ID_Details in the TLD table.

Line 3589: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

3585: x_msg_data => x_msg_data,
3586: p_tldv_rec => lp_tldv_tbl(i),
3587: x_tldv_rec => lx_tldv_rec);
3588:
3589: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3590: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3591: x_return_status := l_return_status;
3592: END IF;
3593: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

3586: p_tldv_rec => lp_tldv_tbl(i),
3587: x_tldv_rec => lx_tldv_rec);
3588:
3589: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3590: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3591: x_return_status := l_return_status;
3592: END IF;
3593: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3594: END IF;

Line 3593: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3589: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3590: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3591: x_return_status := l_return_status;
3592: END IF;
3593: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3594: END IF;
3595: END LOOP;
3596: /***** Updation Completed in TIL and TLD *****/
3597:

Line 3619: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

3615: p_tldv_tbl => lp_tldv_tbl ,
3616: p_tai_id => lx_taiv_rec.ID
3617: );
3618: END IF;
3619: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3620: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3621: x_return_status := l_return_status;
3622: END IF;
3623: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

3616: p_tai_id => lx_taiv_rec.ID
3617: );
3618: END IF;
3619: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3620: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3621: x_return_status := l_return_status;
3622: END IF;
3623: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3624: END IF;

Line 3623: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3619: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3620: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3621: x_return_status := l_return_status;
3622: END IF;
3623: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3624: END IF;
3625: END IF;
3626:
3627:

Line 3650: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

3646: x_tilv_rec => lx_tilv_tbl(i));
3647:
3648: l_tilv_Crt_tbl(i) := lx_tilv_tbl(i);
3649:
3650: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3651: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3652: x_return_status := l_return_status;
3653: END IF;
3654: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

3647:
3648: l_tilv_Crt_tbl(i) := lx_tilv_tbl(i);
3649:
3650: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3651: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3652: x_return_status := l_return_status;
3653: END IF;
3654: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3655: END IF;

Line 3654: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3650: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3651: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3652: x_return_status := l_return_status;
3653: END IF;
3654: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3655: END IF;
3656:
3657:
3658: -- Create okl_TXL_AR_INV_LNS_B record: okl_til_pvt.insert_row;

Line 3667: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

3663: x_msg_count => x_msg_count,
3664: x_msg_data => x_msg_data,
3665: p_tilv_rec => l_tilv_Crt_tbl(i),
3666: x_tilv_rec => lx_tilv_rec);
3667: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3668: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3669: x_return_status := l_return_status;
3670: END IF;
3671: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

3664: x_msg_data => x_msg_data,
3665: p_tilv_rec => l_tilv_Crt_tbl(i),
3666: x_tilv_rec => lx_tilv_rec);
3667: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3668: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3669: x_return_status := l_return_status;
3670: END IF;
3671: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3672: END IF;

Line 3671: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3667: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3668: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3669: x_return_status := l_return_status;
3670: END IF;
3671: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3672: END IF;
3673:
3674: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3675: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lx_tilv_rec.id: '||to_char(lx_tilv_rec.id));

Line 3699: ,p_init_msg_list => OKL_API.G_FALSE

3695: lp_tldv_tbl(i).KLE_ID := lx_tilv_rec.KLE_ID;
3696:
3697: Get_Invoice_format(
3698: p_api_version => p_api_version
3699: ,p_init_msg_list => OKL_API.G_FALSE
3700: ,x_return_status => l_return_status
3701: ,x_msg_count => x_msg_count
3702: ,x_msg_data => x_msg_data
3703: ,p_inf_id => lp_taiv_rec.inf_id

Line 3708: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

3704: ,p_sty_id => lp_tldv_tbl(i).STY_ID
3705: ,x_invoice_format_type => lp_tldv_tbl(i).invoice_format_type
3706: ,x_invoice_format_line_type => lp_tldv_tbl(i).invoice_format_line_type);
3707:
3708: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3709: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3710: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3711: RAISE OKL_API.G_EXCEPTION_ERROR;
3712: END IF;

Line 3709: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3705: ,x_invoice_format_type => lp_tldv_tbl(i).invoice_format_type
3706: ,x_invoice_format_line_type => lp_tldv_tbl(i).invoice_format_line_type);
3707:
3708: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3709: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3710: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3711: RAISE OKL_API.G_EXCEPTION_ERROR;
3712: END IF;
3713:

Line 3710: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

3706: ,x_invoice_format_line_type => lp_tldv_tbl(i).invoice_format_line_type);
3707:
3708: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3709: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3710: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3711: RAISE OKL_API.G_EXCEPTION_ERROR;
3712: END IF;
3713:
3714: additional_tld_attr(

Line 3711: RAISE OKL_API.G_EXCEPTION_ERROR;

3707:
3708: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3709: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3710: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3711: RAISE OKL_API.G_EXCEPTION_ERROR;
3712: END IF;
3713:
3714: additional_tld_attr(
3715: p_api_version => p_api_version,

Line 3725: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

3721: x_tldv_rec => lx_tldv_tbl(i));
3722:
3723: lp_tldv_tbl(i) := lx_tldv_tbl(i);
3724:
3725: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3726: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3727: x_return_status := l_return_status;
3728: END IF;
3729: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

3722:
3723: lp_tldv_tbl(i) := lx_tldv_tbl(i);
3724:
3725: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3726: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3727: x_return_status := l_return_status;
3728: END IF;
3729: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3730: END IF;

Line 3729: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3725: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3726: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3727: x_return_status := l_return_status;
3728: END IF;
3729: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3730: END IF;
3731:
3732: okl_tld_pvt.insert_row(
3733: p_api_version => p_api_version,

Line 3741: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

3737: x_msg_data => x_msg_data,
3738: p_tldv_rec => lp_tldv_tbl(i),
3739: x_tldv_rec => lx_tldv_rec);
3740:
3741: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3742: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3743: x_return_status := l_return_status;
3744: END IF;
3745: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

3738: p_tldv_rec => lp_tldv_tbl(i),
3739: x_tldv_rec => lx_tldv_rec);
3740:
3741: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3742: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3743: x_return_status := l_return_status;
3744: END IF;
3745: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3746: END IF;

Line 3745: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3741: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3742: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3743: x_return_status := l_return_status;
3744: END IF;
3745: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3746: END IF;
3747: -- lp_tldv_tbl(l_til_loop_cnt) := lx_tldv_rec;
3748:
3749: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 3776: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

3772: p_tldv_tbl => lp_tldv_tbl ,
3773: p_tai_id => lx_taiv_rec.ID
3774: );
3775: END IF;
3776: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3777: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3778: x_return_status := l_return_status;
3779: END IF;
3780: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

3773: p_tai_id => lx_taiv_rec.ID
3774: );
3775: END IF;
3776: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3777: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3778: x_return_status := l_return_status;
3779: END IF;
3780: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3781: END IF;

Line 3780: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3776: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3777: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3778: x_return_status := l_return_status;
3779: END IF;
3780: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3781: END IF;
3782: END IF;
3783:
3784:

Line 3791: WHEN OKL_API.G_EXCEPTION_ERROR THEN

3787: (p_count => x_msg_count,
3788: p_data => x_msg_data);
3789:
3790: EXCEPTION
3791: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3792: ROLLBACK TO UPDATE_MANUAL_INVOICE;
3793: x_return_status := OKL_API.G_RET_STS_ERROR;
3794: FND_MSG_PUB.Count_And_Get
3795: (p_count => x_msg_count,

Line 3793: x_return_status := OKL_API.G_RET_STS_ERROR;

3789:
3790: EXCEPTION
3791: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3792: ROLLBACK TO UPDATE_MANUAL_INVOICE;
3793: x_return_status := OKL_API.G_RET_STS_ERROR;
3794: FND_MSG_PUB.Count_And_Get
3795: (p_count => x_msg_count,
3796: p_data => x_msg_data);
3797:

Line 3798: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3794: FND_MSG_PUB.Count_And_Get
3795: (p_count => x_msg_count,
3796: p_data => x_msg_data);
3797:
3798: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3799: ROLLBACK TO UPDATE_MANUAL_INVOICE;
3800: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
3801: FND_MSG_PUB.Count_And_Get
3802: (p_count => x_msg_count,

Line 3800: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

3796: p_data => x_msg_data);
3797:
3798: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3799: ROLLBACK TO UPDATE_MANUAL_INVOICE;
3800: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
3801: FND_MSG_PUB.Count_And_Get
3802: (p_count => x_msg_count,
3803: p_data => x_msg_data);
3804:

Line 3807: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

3803: p_data => x_msg_data);
3804:
3805: WHEN OTHERS THEN
3806: ROLLBACK TO UPDATE_MANUAL_INVOICE;
3807: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
3808: OKL_API.Set_Message(p_app_name => G_APP_NAME,
3809: p_msg_name => G_UNEXPECTED_ERROR,
3810: p_token1 => G_SQLCODE_TOKEN,
3811: p_token1_value => SQLCODE,

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

3804:
3805: WHEN OTHERS THEN
3806: ROLLBACK TO UPDATE_MANUAL_INVOICE;
3807: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
3808: OKL_API.Set_Message(p_app_name => G_APP_NAME,
3809: p_msg_name => G_UNEXPECTED_ERROR,
3810: p_token1 => G_SQLCODE_TOKEN,
3811: p_token1_value => SQLCODE,
3812: p_token2 => G_SQLERRM_TOKEN,

Line 3842: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

3838: -- End of comments
3839:
3840: PROCEDURE delete_manual_invoice(
3841: p_api_version IN NUMBER
3842: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
3843: ,x_return_status OUT NOCOPY VARCHAR2
3844: ,x_msg_count OUT NOCOPY NUMBER
3845: ,x_msg_data OUT NOCOPY VARCHAR2
3846: ,p_taiv_id NUMBER

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

3850:
3851: l_api_name CONSTANT VARCHAR2(30) := 'update_manual_invoice';
3852: l_api_version CONSTANT NUMBER := 1.0;
3853: l_til_loop_cnt NUMBER;
3854: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3855: lp_tai_id OKL_TRX_AR_INVOICES_B.ID%TYPE :=p_taiv_id;
3856: lp_til_id OKL_TXL_AR_INV_LNS_B.ID%TYPE :=p_tilv_id;
3857: l_tai_id OKL_TRX_AR_INVOICES_B.ID%TYPE;
3858: l_til_id OKL_TXL_AR_INV_LNS_B.ID%TYPE ;

Line 3883: x_return_status := OKL_API.G_RET_STS_SUCCESS;

3879:
3880: BEGIN
3881: SAVEPOINT DELETE_MANUAL_INVOICE ;
3882:
3883: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3884: x_return_status := OKL_API.START_ACTIVITY( l_api_name
3885: , g_pkg_name
3886: , p_init_msg_list
3887: , l_api_version

Line 3884: x_return_status := OKL_API.START_ACTIVITY( l_api_name

3880: BEGIN
3881: SAVEPOINT DELETE_MANUAL_INVOICE ;
3882:
3883: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3884: x_return_status := OKL_API.START_ACTIVITY( l_api_name
3885: , g_pkg_name
3886: , p_init_msg_list
3887: , l_api_version
3888: , p_api_version

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

3887: , l_api_version
3888: , p_api_version
3889: , '_PVT'
3890: , x_return_status);
3891: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3892: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3893: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3894: RAISE OKL_API.G_EXCEPTION_ERROR;
3895: END IF;

Line 3892: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3888: , p_api_version
3889: , '_PVT'
3890: , x_return_status);
3891: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3892: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3893: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3894: RAISE OKL_API.G_EXCEPTION_ERROR;
3895: END IF;
3896:

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

3889: , '_PVT'
3890: , x_return_status);
3891: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3892: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3893: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3894: RAISE OKL_API.G_EXCEPTION_ERROR;
3895: END IF;
3896:
3897: -- IF lp_taiv_id is not null then delete TAI , TIL and TLD records else TIL and TLD.

Line 3894: RAISE OKL_API.G_EXCEPTION_ERROR;

3890: , x_return_status);
3891: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3892: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3893: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3894: RAISE OKL_API.G_EXCEPTION_ERROR;
3895: END IF;
3896:
3897: -- IF lp_taiv_id is not null then delete TAI , TIL and TLD records else TIL and TLD.
3898: IF lp_tai_id IS NOT NULL THEN

Line 3915: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

3911: x_msg_count => x_msg_count,
3912: x_msg_data => x_msg_data,
3913: p_tldv_rec => l_tldv_rec
3914: );
3915: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3916: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3917: x_return_status := l_return_status;
3918: END IF;
3919: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

3912: x_msg_data => x_msg_data,
3913: p_tldv_rec => l_tldv_rec
3914: );
3915: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3916: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3917: x_return_status := l_return_status;
3918: END IF;
3919: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3920: END IF;

Line 3919: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3915: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3916: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3917: x_return_status := l_return_status;
3918: END IF;
3919: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3920: END IF;
3921:
3922: END LOOP; --End loop for TLD
3923: --Delete a TIL Record.

Line 3931: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

3927: x_msg_count => x_msg_count,
3928: x_msg_data => x_msg_data,
3929: p_tilv_rec => l_tilv_rec
3930: );
3931: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3932: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3933: x_return_status := l_return_status;
3934: END IF;
3935: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

3928: x_msg_data => x_msg_data,
3929: p_tilv_rec => l_tilv_rec
3930: );
3931: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3932: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3933: x_return_status := l_return_status;
3934: END IF;
3935: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3936: END IF;

Line 3935: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3931: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3932: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3933: x_return_status := l_return_status;
3934: END IF;
3935: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3936: END IF;
3937:
3938: END LOOP;--End loop for TIL.
3939: --Delete a TAI Record.

Line 3947: IF(l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

3943: x_return_status => l_return_status,
3944: x_msg_count => x_msg_count,
3945: x_msg_data => x_msg_data,
3946: p_taiv_rec => l_taiv_rec);
3947: IF(l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3948: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3949: x_return_status := l_return_status;
3950: END IF;
3951: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

3944: x_msg_count => x_msg_count,
3945: x_msg_data => x_msg_data,
3946: p_taiv_rec => l_taiv_rec);
3947: IF(l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3948: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3949: x_return_status := l_return_status;
3950: END IF;
3951: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3952: END IF;

Line 3951: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3947: IF(l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3948: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3949: x_return_status := l_return_status;
3950: END IF;
3951: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3952: END IF;
3953:
3954: ELSIF lp_til_id IS NOT NULL THEN -- Delete a TIL Rccord and all its TLD Records.
3955: FOR get_tld_dtl_rec in get_tld_dtl_csr(lp_til_id)

Line 3966: IF(l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

3962: x_msg_count => x_msg_count,
3963: x_msg_data => x_msg_data,
3964: p_tldv_rec => l_tldv_rec
3965: );
3966: IF(l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3967: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3968: x_return_status := l_return_status;
3969: END IF;
3970: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

3963: x_msg_data => x_msg_data,
3964: p_tldv_rec => l_tldv_rec
3965: );
3966: IF(l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3967: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3968: x_return_status := l_return_status;
3969: END IF;
3970: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3971: END IF;

Line 3970: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3966: IF(l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3967: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3968: x_return_status := l_return_status;
3969: END IF;
3970: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3971: END IF;
3972:
3973: END LOOP; --End loop for TLD.
3974: l_tilv_rec.id := lp_til_id;

Line 3983: IF(l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

3979: x_msg_count => x_msg_count,
3980: x_msg_data => x_msg_data,
3981: p_tilv_rec => l_tilv_rec
3982: );
3983: IF(l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3984: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3985: x_return_status := l_return_status;
3986: END IF;
3987: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

3980: x_msg_data => x_msg_data,
3981: p_tilv_rec => l_tilv_rec
3982: );
3983: IF(l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3984: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3985: x_return_status := l_return_status;
3986: END IF;
3987: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3988: END IF;

Line 3987: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3983: IF(l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3984: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3985: x_return_status := l_return_status;
3986: END IF;
3987: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3988: END IF;
3989:
3990: END IF ;
3991:

Line 4000: WHEN OKL_API.G_EXCEPTION_ERROR THEN

3996: (p_count => x_msg_count,
3997: p_data => x_msg_data);
3998:
3999: EXCEPTION
4000: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4001: ROLLBACK TO DELETE_MANUAL_INVOICE;
4002: x_return_status := OKL_API.G_RET_STS_ERROR;
4003: FND_MSG_PUB.Count_And_Get
4004: (p_count => x_msg_count,

Line 4002: x_return_status := OKL_API.G_RET_STS_ERROR;

3998:
3999: EXCEPTION
4000: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4001: ROLLBACK TO DELETE_MANUAL_INVOICE;
4002: x_return_status := OKL_API.G_RET_STS_ERROR;
4003: FND_MSG_PUB.Count_And_Get
4004: (p_count => x_msg_count,
4005: p_data => x_msg_data);
4006:

Line 4007: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

4003: FND_MSG_PUB.Count_And_Get
4004: (p_count => x_msg_count,
4005: p_data => x_msg_data);
4006:
4007: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4008: ROLLBACK TO DELETE_MANUAL_INVOICE;
4009: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
4010: FND_MSG_PUB.Count_And_Get
4011: (p_count => x_msg_count,

Line 4009: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

4005: p_data => x_msg_data);
4006:
4007: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4008: ROLLBACK TO DELETE_MANUAL_INVOICE;
4009: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
4010: FND_MSG_PUB.Count_And_Get
4011: (p_count => x_msg_count,
4012: p_data => x_msg_data);
4013:

Line 4016: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

4012: p_data => x_msg_data);
4013:
4014: WHEN OTHERS THEN
4015: ROLLBACK TO DELETE_MANUAL_INVOICE;
4016: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
4017: OKL_API.Set_Message(p_app_name => G_APP_NAME,
4018: p_msg_name => G_UNEXPECTED_ERROR,
4019: p_token1 => G_SQLCODE_TOKEN,
4020: p_token1_value => SQLCODE,

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

4013:
4014: WHEN OTHERS THEN
4015: ROLLBACK TO DELETE_MANUAL_INVOICE;
4016: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
4017: OKL_API.Set_Message(p_app_name => G_APP_NAME,
4018: p_msg_name => G_UNEXPECTED_ERROR,
4019: p_token1 => G_SQLCODE_TOKEN,
4020: p_token1_value => SQLCODE,
4021: p_token2 => G_SQLERRM_TOKEN,