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

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

36: p_tapv_rec IN tapv_rec_type
37: ,x_tapv_rec OUT NOCOPY tapv_rec_type
38: ) RETURN VARCHAR2
39: IS
40: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
41: -- l_set_of_books_id NUMBER;
42: l_terms_id NUMBER;
43: -- l_application_id NUMBER;
44: l_pay_group_lookup_code PO_VENDOR_SITES_ALL.PAY_GROUP_LOOKUP_CODE%TYPE;

Line 96: p_tapv_rec.payment_method_code = OKL_API.G_MISS_CHAR) THEN

92:
93: -- assgin to OUT always
94: x_tapv_rec := p_tapv_rec;
95: IF (p_tapv_rec.payment_method_code is null or
96: p_tapv_rec.payment_method_code = OKL_API.G_MISS_CHAR) THEN
97: x_tapv_rec.payment_method_code := 'CHECK'; -- set default value
98: END IF;
99: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
100: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.populate_more_attrs: x_tapv_rec.payment_method_code:' || x_tapv_rec.payment_method_code);

Line 111: p_tapv_rec.SET_OF_BOOKS_ID = OKL_API.G_MISS_NUM) THEN

107: CLOSE c_set_of_books;
108: */
109:
110: IF (p_tapv_rec.SET_OF_BOOKS_ID is null or
111: p_tapv_rec.SET_OF_BOOKS_ID = OKL_API.G_MISS_NUM) THEN
112: x_tapv_rec.SET_OF_BOOKS_ID := OKL_ACCOUNTING_UTIL.get_set_of_books_id;--l_set_of_books_id;
113: END IF;
114: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
115: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.populate_more_attrs: x_tapv_rec.SET_OF_BOOKS_ID:' || x_tapv_rec.SET_OF_BOOKS_ID);

Line 123: p_tapv_rec.IPPT_ID = OKL_API.G_MISS_NUM) THEN

119: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
120: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.populate_more_attrs: p_tapv_rec.IPPT_ID:' || p_tapv_rec.IPPT_ID);
121: END IF;
122: IF (p_tapv_rec.IPPT_ID IS NULL or
123: p_tapv_rec.IPPT_ID = OKL_API.G_MISS_NUM) THEN
124:
125: OPEN c_vendor_sites(p_tapv_rec.ipvs_id);
126: FETCH c_vendor_sites INTO l_terms_id, l_pay_group_lookup_code;
127: CLOSE c_vendor_sites;

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

154: dbseqid => lx_dbseqid);
155: EXCEPTION
156: WHEN OTHERS THEN
157: IF SQLCODE = 100 THEN
158: OKL_API.Set_Message(p_app_name => G_APP_NAME,
159: p_msg_name => 'OKL_PAY_INV_SEQ_CHECK');
160: RAISE G_EXCEPTION_HALT_VALIDATION;
161: END IF;
162: END;

Line 171: p_tapv_rec.NETTABLE_YN = OKL_API.G_MISS_CHAR) THEN

167: END IF;
168: */
169: -- 4. NETTABLE_YN
170: IF (p_tapv_rec.NETTABLE_YN is null or
171: p_tapv_rec.NETTABLE_YN = OKL_API.G_MISS_CHAR) THEN
172: x_tapv_rec.NETTABLE_YN := 'N';
173: END IF;
174: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
175: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.populate_more_attrs: x_tapv_rec.NETTABLE_YN:' || x_tapv_rec.NETTABLE_YN);

Line 185: p_tapv_rec.PAY_GROUP_LOOKUP_CODE = OKL_API.G_MISS_CHAR) THEN

181: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.populate_more_attrs: p_tapv_rec.PAY_GROUP_LOOKUP_CODE:' || p_tapv_rec.PAY_GROUP_LOOKUP_CODE);
182: END IF;
183:
184: IF (p_tapv_rec.PAY_GROUP_LOOKUP_CODE IS NULL or
185: p_tapv_rec.PAY_GROUP_LOOKUP_CODE = OKL_API.G_MISS_CHAR) THEN
186:
187: -- fixed PAY_GROUP_LOOKUP_CODE default data missing issues
188: OPEN c_vendor_sites(p_tapv_rec.ipvs_id);
189: FETCH c_vendor_sites INTO l_terms_id, l_pay_group_lookup_code;

Line 204: p_tapv_rec.VENDOR_ID = OKL_API.G_MISS_NUM) THEN

200: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
201: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.populate_more_attrs: p_tapv_rec.VENDOR_ID:' || p_tapv_rec.VENDOR_ID);
202: END IF;
203: IF (p_tapv_rec.VENDOR_ID is null or
204: p_tapv_rec.VENDOR_ID = OKL_API.G_MISS_NUM) THEN
205:
206: OPEN c_vendor(p_tapv_rec.ipvs_id);
207: FETCH c_vendor INTO l_vendor_id;
208: CLOSE c_vendor;

Line 221: p_tapv_rec.INVOICE_TYPE = OKL_API.G_MISS_CHAR) THEN

217: -- 7. invoice_type
218: -- cklee 05/04/2004
219:
220: IF (p_tapv_rec.INVOICE_TYPE is null or
221: p_tapv_rec.INVOICE_TYPE = OKL_API.G_MISS_CHAR) THEN
222:
223: x_tapv_rec.INVOICE_TYPE := G_STANDARD;
224:
225: END IF;

Line 260: l_return_status := OKL_API.G_RET_STS_ERROR;

256: EXCEPTION
257:
258: WHEN G_EXCEPTION_HALT_VALIDATION THEN
259:
260: l_return_status := OKL_API.G_RET_STS_ERROR;
261:
262:
263: RETURN l_return_status;
264: WHEN OTHERS THEN

Line 265: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

261:
262:
263: RETURN l_return_status;
264: WHEN OTHERS THEN
265: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
266:
267: OKL_API.Set_Message(p_app_name => G_APP_NAME,
268: p_msg_name => G_UNEXPECTED_ERROR,
269: p_token1 => G_SQLCODE_TOKEN,

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

263: RETURN l_return_status;
264: WHEN OTHERS THEN
265: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
266:
267: OKL_API.Set_Message(p_app_name => G_APP_NAME,
268: p_msg_name => G_UNEXPECTED_ERROR,
269: p_token1 => G_SQLCODE_TOKEN,
270: p_token1_value => SQLCODE,
271: p_token2 => G_SQLERRM_TOKEN,

Line 288: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

284: -- End of comments
285: --
286: ----------------------------------------------------------------------------
287: PROCEDURE create_disb_trx(p_api_version IN NUMBER
288: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
289: ,x_return_status OUT NOCOPY VARCHAR2
290: ,x_msg_count OUT NOCOPY NUMBER
291: ,x_msg_data OUT NOCOPY VARCHAR2
292: ,p_tapv_rec IN tapv_rec_type

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

303: l_application_id NUMBER(3);
304: l_document_category VARCHAR2(100):= 'OKL Lease Pay Invoices';
305: lX_dbseqnm VARCHAR2(2000):= '';
306: lX_dbseqid NUMBER(38):= NULL;
307: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
308: cnt NUMBER;
309: l_total_amount NUMBER;
310: l_khr_id NUMBER;
311: l_legal_entity_id NUMBER;

Line 421: l_return_status := okl_api.start_activity(

417: END LOOP;
418: END IF;
419: END IF;
420:
421: l_return_status := okl_api.start_activity(
422: p_api_name => l_api_name,
423: p_init_msg_list => p_init_msg_list,
424: p_api_type => '_PVT',
425: x_return_status => l_return_status);

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

423: p_init_msg_list => p_init_msg_list,
424: p_api_type => '_PVT',
425: x_return_status => l_return_status);
426:
427: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
428: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
429: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
430: RAISE OKL_API.G_EXCEPTION_ERROR;
431: END IF;

Line 428: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

424: p_api_type => '_PVT',
425: x_return_status => l_return_status);
426:
427: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
428: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
429: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
430: RAISE OKL_API.G_EXCEPTION_ERROR;
431: END IF;
432:

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

425: x_return_status => l_return_status);
426:
427: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
428: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
429: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
430: RAISE OKL_API.G_EXCEPTION_ERROR;
431: END IF;
432:
433: ------------------------------------------------------------

Line 430: RAISE OKL_API.G_EXCEPTION_ERROR;

426:
427: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
428: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
429: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
430: RAISE OKL_API.G_EXCEPTION_ERROR;
431: END IF;
432:
433: ------------------------------------------------------------
434: -- Initialization of Parameters

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

441: --start:| 11-May-07 cklee -- added defaulted attributes for the following: |
442: -- populates more attributes
443: l_return_status := populate_more_attrs(p_tapv_rec, l_tapv_rec);
444: --- Store the highest degree of error
445: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
446: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
447: x_return_status := l_return_status;
448: END IF;
449:

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

442: -- populates more attributes
443: l_return_status := populate_more_attrs(p_tapv_rec, l_tapv_rec);
444: --- Store the highest degree of error
445: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
446: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
447: x_return_status := l_return_status;
448: END IF;
449:
450: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 453: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

449:
450: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
451: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: populate_more_attrs raise exception');
452: END IF;
453: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
454: END IF;
455: --end:| 11-May-07 cklee -- added defaulted attributes for the following: |
456:
457: -- Generating Invoice Number from Document Sequence if no invoice number is passed from source transaction

Line 466: IF (NVL(l_tapv_rec.invoice_number,okl_api.g_miss_char) = okl_api.g_miss_char) THEN

462: CLOSE c_app;
463:
464: l_okl_application_id := nvl(l_application_id,540);
465:
466: IF (NVL(l_tapv_rec.invoice_number,okl_api.g_miss_char) = okl_api.g_miss_char) THEN
467: l_tapv_rec.invoice_number := fnd_seqnum.get_next_sequence
468: (appid => l_okl_application_id,
469: cat_code => l_document_category,
470: sobid => l_tapv_rec.set_of_books_id, -- | 28-Sep-07 cklee -- Fixed bug:6457524 set_of_book_id is missing issue |

Line 475: IF (NVL(l_tapv_rec.vendor_invoice_number,okl_api.g_miss_char) = okl_api.g_miss_char) THEN

471: met_code => 'A',
472: trx_date => SYSDATE,
473: dbseqnm => lx_dbseqnm,
474: dbseqid => lx_dbseqid);
475: IF (NVL(l_tapv_rec.vendor_invoice_number,okl_api.g_miss_char) = okl_api.g_miss_char) THEN
476: l_tapv_rec.vendor_invoice_number := l_tapv_rec.invoice_number;
477: END IF;
478: ELSE
479: IF (NVL(l_tapv_rec.vendor_invoice_number,okl_api.g_miss_char) = okl_api.g_miss_char) THEN

Line 479: IF (NVL(l_tapv_rec.vendor_invoice_number,okl_api.g_miss_char) = okl_api.g_miss_char) THEN

475: IF (NVL(l_tapv_rec.vendor_invoice_number,okl_api.g_miss_char) = okl_api.g_miss_char) THEN
476: l_tapv_rec.vendor_invoice_number := l_tapv_rec.invoice_number;
477: END IF;
478: ELSE
479: IF (NVL(l_tapv_rec.vendor_invoice_number,okl_api.g_miss_char) = okl_api.g_miss_char) THEN
480: l_tapv_rec.vendor_invoice_number := fnd_seqnum.get_next_sequence
481: (appid => l_okl_application_id,
482: cat_code => l_document_category,
483: sobid => l_tapv_rec.set_of_books_id,

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

489: END IF;
490: EXCEPTION
491: WHEN OTHERS THEN
492:
493: OKL_API.Set_Message(p_app_name => G_APP_NAME,
494: p_msg_name => 'OKL_PAY_INV_SEQ_CHECK');
495: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
496: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: fnd_seqnum.get_next_sequence raise exception');
497: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: fnd_seqnum.get_next_sequence: l_okl_application_id' || l_okl_application_id);

Line 501: RAISE OKL_API.G_EXCEPTION_ERROR ;

497: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: fnd_seqnum.get_next_sequence: l_okl_application_id' || l_okl_application_id);
498: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: fnd_seqnum.get_next_sequence: l_document_category' || l_document_category);
499: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: fnd_seqnum.get_next_sequence: l_tapv_rec.set_of_books_id' || l_tapv_rec.set_of_books_id);
500: END IF;
501: RAISE OKL_API.G_EXCEPTION_ERROR ;
502:
503: END;
504:
505: --| 06-Dec-07 cklee -- Fixed bug: 6663203 |

Line 509: OKL_API.SET_MESSAGE

505: --| 06-Dec-07 cklee -- Fixed bug: 6663203 |
506: --| raise proper error message if request amount = 0 |
507: --Raise message if amount = 0
508: IF l_tapv_rec.amount = 0 THEN
509: OKL_API.SET_MESSAGE
510: ( p_app_name => g_app_name,
511: p_msg_name => 'OKL_AMT_CANNOT_BE_ZERO'
512: ) ;
513: RAISE OKL_API.G_EXCEPTION_ERROR ;

Line 513: RAISE OKL_API.G_EXCEPTION_ERROR ;

509: OKL_API.SET_MESSAGE
510: ( p_app_name => g_app_name,
511: p_msg_name => 'OKL_AMT_CANNOT_BE_ZERO'
512: ) ;
513: RAISE OKL_API.G_EXCEPTION_ERROR ;
514: END IF;
515:
516: --Raise message if Currency code is not passed
517: IF l_tapv_rec.currency_code IS NULL THEN

Line 518: OKL_API.SET_MESSAGE

514: END IF;
515:
516: --Raise message if Currency code is not passed
517: IF l_tapv_rec.currency_code IS NULL THEN
518: OKL_API.SET_MESSAGE
519: ( p_app_name => g_app_name,
520: p_msg_name => g_required_value,
521: p_token1 => g_col_name_token,
522: p_token1_value => 'currency_code'

Line 524: RAISE OKL_API.G_EXCEPTION_ERROR ;

520: p_msg_name => g_required_value,
521: p_token1 => g_col_name_token,
522: p_token1_value => 'currency_code'
523: ) ;
524: RAISE OKL_API.G_EXCEPTION_ERROR ;
525: END IF;
526:
527: --get contract currency parameters
528: --start:| 11-May-07 cklee -- added defaulted attributes for the following: |

Line 555: IF (NVL(l_tapv_rec.khr_id,okl_api.g_miss_num) = okl_api.g_miss_num) then -- 28-Sep-07 cklee -- Fixed bug:6455033

551: END IF;
552:
553:
554: --start:| 14-Sep-07 cklee -- Restored khr_id back to okl_trx_ap_invs_all_b for the |
555: IF (NVL(l_tapv_rec.khr_id,okl_api.g_miss_num) = okl_api.g_miss_num) then -- 28-Sep-07 cklee -- Fixed bug:6455033
556: l_tapv_rec.khr_id := l_khr_id;
557: END IF;
558: --end:| 14-Sep-07 cklee -- Restored khr_id back to okl_trx_ap_invs_all_b for the |
559:

Line 561: IF (NVL(l_tapv_rec.trx_status_code,okl_api.g_miss_char) = okl_api.g_miss_char) then

557: END IF;
558: --end:| 14-Sep-07 cklee -- Restored khr_id back to okl_trx_ap_invs_all_b for the |
559:
560: --Transaction Status defaulted to Entered
561: IF (NVL(l_tapv_rec.trx_status_code,okl_api.g_miss_char) = okl_api.g_miss_char) then
562: l_tapv_rec.trx_status_code := 'ENTERED';
563: END IF;
564:
565: --Check for currency conversion type

Line 566: IF (NVL(l_tapv_rec.currency_conversion_type, okl_api.g_miss_char) = okl_api.g_miss_char) THEN

562: l_tapv_rec.trx_status_code := 'ENTERED';
563: END IF;
564:
565: --Check for currency conversion type
566: IF (NVL(l_tapv_rec.currency_conversion_type, okl_api.g_miss_char) = okl_api.g_miss_char) THEN
567: l_tapv_rec.currency_conversion_type := l_currency_conversion_type;
568: END IF;
569:
570: --Check for currency conversion date

Line 571: IF (NVL(l_tapv_rec.currency_conversion_date, okl_api.g_miss_date) = okl_api.g_miss_date) THEN

567: l_tapv_rec.currency_conversion_type := l_currency_conversion_type;
568: END IF;
569:
570: --Check for currency conversion date
571: IF (NVL(l_tapv_rec.currency_conversion_date, okl_api.g_miss_date) = okl_api.g_miss_date) THEN
572: l_tapv_rec.currency_conversion_date := l_currency_conversion_date;
573: END IF;
574:
575: --Handle Currency Conversion Rate

Line 580: IF NVL(l_tapv_rec.currency_conversion_rate,okl_api.g_miss_num) = okl_api.g_miss_num THEN

576: IF l_tapv_rec.currency_conversion_type = 'User' THEN
577: IF (l_tapv_rec.currency_code = okl_accounting_util.get_func_curr_code) THEN
578: l_tapv_rec.currency_conversion_rate := 1;
579: ELSE
580: IF NVL(l_tapv_rec.currency_conversion_rate,okl_api.g_miss_num) = okl_api.g_miss_num THEN
581: l_tapv_rec.currency_conversion_rate := l_currency_conversion_rate;
582: END IF;
583: END IF;
584: END IF;

Line 587: IF (NVL(l_tapv_rec.payment_method_code,okl_api.g_miss_char) = okl_api.g_miss_char) THEN

583: END IF;
584: END IF;
585:
586: --Raise message if Payment Method Code is not passed
587: IF (NVL(l_tapv_rec.payment_method_code,okl_api.g_miss_char) = okl_api.g_miss_char) THEN
588: --raise message
589: OKL_Api.SET_MESSAGE
590: ( p_app_name => g_app_name,
591: p_msg_name => g_required_value,

Line 589: OKL_Api.SET_MESSAGE

585:
586: --Raise message if Payment Method Code is not passed
587: IF (NVL(l_tapv_rec.payment_method_code,okl_api.g_miss_char) = okl_api.g_miss_char) THEN
588: --raise message
589: OKL_Api.SET_MESSAGE
590: ( p_app_name => g_app_name,
591: p_msg_name => g_required_value,
592: p_token1 => g_col_name_token,
593: p_token1_value => 'payment_method_code'

Line 595: RAISE OKL_API.G_EXCEPTION_ERROR;

591: p_msg_name => g_required_value,
592: p_token1 => g_col_name_token,
593: p_token1_value => 'payment_method_code'
594: ) ;
595: RAISE OKL_API.G_EXCEPTION_ERROR;
596: END IF;
597:
598: --Raise message if Pay Group Lookup Code is not passed
599: IF (NVL(l_tapv_rec.pay_group_lookup_code,okl_api.g_miss_char) = okl_api.g_miss_char) THEN

Line 599: IF (NVL(l_tapv_rec.pay_group_lookup_code,okl_api.g_miss_char) = okl_api.g_miss_char) THEN

595: RAISE OKL_API.G_EXCEPTION_ERROR;
596: END IF;
597:
598: --Raise message if Pay Group Lookup Code is not passed
599: IF (NVL(l_tapv_rec.pay_group_lookup_code,okl_api.g_miss_char) = okl_api.g_miss_char) THEN
600: --raise message
601: OKL_Api.SET_MESSAGE
602: ( p_app_name => g_app_name,
603: p_msg_name => g_required_value,

Line 601: OKL_Api.SET_MESSAGE

597:
598: --Raise message if Pay Group Lookup Code is not passed
599: IF (NVL(l_tapv_rec.pay_group_lookup_code,okl_api.g_miss_char) = okl_api.g_miss_char) THEN
600: --raise message
601: OKL_Api.SET_MESSAGE
602: ( p_app_name => g_app_name,
603: p_msg_name => g_required_value,
604: p_token1 => g_col_name_token,
605: p_token1_value => 'pay_group_lookup_code'

Line 607: RAISE OKL_API.G_EXCEPTION_ERROR;

603: p_msg_name => g_required_value,
604: p_token1 => g_col_name_token,
605: p_token1_value => 'pay_group_lookup_code'
606: ) ;
607: RAISE OKL_API.G_EXCEPTION_ERROR;
608: END IF;
609:
610: --Raise message if Invoice Type is not passed
611: IF (NVL(l_tapv_rec.invoice_type,okl_api.g_miss_char) = okl_api.g_miss_char) THEN

Line 611: IF (NVL(l_tapv_rec.invoice_type,okl_api.g_miss_char) = okl_api.g_miss_char) THEN

607: RAISE OKL_API.G_EXCEPTION_ERROR;
608: END IF;
609:
610: --Raise message if Invoice Type is not passed
611: IF (NVL(l_tapv_rec.invoice_type,okl_api.g_miss_char) = okl_api.g_miss_char) THEN
612: --raise message
613: OKL_Api.SET_MESSAGE
614: ( p_app_name => g_app_name,
615: p_msg_name => g_required_value,

Line 613: OKL_Api.SET_MESSAGE

609:
610: --Raise message if Invoice Type is not passed
611: IF (NVL(l_tapv_rec.invoice_type,okl_api.g_miss_char) = okl_api.g_miss_char) THEN
612: --raise message
613: OKL_Api.SET_MESSAGE
614: ( p_app_name => g_app_name,
615: p_msg_name => g_required_value,
616: p_token1 => g_col_name_token,
617: p_token1_value => 'invoice_type'

Line 619: RAISE OKL_API.G_EXCEPTION_ERROR;

615: p_msg_name => g_required_value,
616: p_token1 => g_col_name_token,
617: p_token1_value => 'invoice_type'
618: ) ;
619: RAISE OKL_API.G_EXCEPTION_ERROR;
620:
621: END IF;
622:
623: --Negate the positive amount passed if invoice type is CREDIT

Line 631: IF NVL(l_tapv_rec.set_of_books_id,okl_api.g_miss_num) = okl_api.g_miss_num THEN

627: END IF;
628: END IF;
629:
630: -- Raise message if Set of Books Id is not passed
631: IF NVL(l_tapv_rec.set_of_books_id,okl_api.g_miss_num) = okl_api.g_miss_num THEN
632: --raise message
633: OKL_Api.SET_MESSAGE
634: ( p_app_name => g_app_name,
635: p_msg_name => g_required_value,

Line 633: OKL_Api.SET_MESSAGE

629:
630: -- Raise message if Set of Books Id is not passed
631: IF NVL(l_tapv_rec.set_of_books_id,okl_api.g_miss_num) = okl_api.g_miss_num THEN
632: --raise message
633: OKL_Api.SET_MESSAGE
634: ( p_app_name => g_app_name,
635: p_msg_name => g_required_value,
636: p_token1 => g_col_name_token,
637: p_token1_value => 'set_of_books_id'

Line 639: RAISE OKL_API.G_EXCEPTION_ERROR;

635: p_msg_name => g_required_value,
636: p_token1 => g_col_name_token,
637: p_token1_value => 'set_of_books_id'
638: ) ;
639: RAISE OKL_API.G_EXCEPTION_ERROR;
640:
641: END IF;
642:
643:

Line 645: IF NVL(l_tapv_rec.try_id,okl_api.g_miss_num) = okl_api.g_miss_num THEN

641: END IF;
642:
643:
644: --Raise message if try id is not passed
645: IF NVL(l_tapv_rec.try_id,okl_api.g_miss_num) = okl_api.g_miss_num THEN
646: --raise message
647: OKL_Api.SET_MESSAGE
648: ( p_app_name => g_app_name,
649: p_msg_name => g_required_value,

Line 647: OKL_Api.SET_MESSAGE

643:
644: --Raise message if try id is not passed
645: IF NVL(l_tapv_rec.try_id,okl_api.g_miss_num) = okl_api.g_miss_num THEN
646: --raise message
647: OKL_Api.SET_MESSAGE
648: ( p_app_name => g_app_name,
649: p_msg_name => g_required_value,
650: p_token1 => g_col_name_token,
651: p_token1_value => 'try_id'

Line 653: RAISE OKL_API.G_EXCEPTION_ERROR;

649: p_msg_name => g_required_value,
650: p_token1 => g_col_name_token,
651: p_token1_value => 'try_id'
652: ) ;
653: RAISE OKL_API.G_EXCEPTION_ERROR;
654: END IF;
655:
656: --Raise message if vendor site id is not passed
657: IF NVL(l_tapv_rec.ipvs_id,okl_api.g_miss_num) = okl_api.g_miss_num THEN

Line 657: IF NVL(l_tapv_rec.ipvs_id,okl_api.g_miss_num) = okl_api.g_miss_num THEN

653: RAISE OKL_API.G_EXCEPTION_ERROR;
654: END IF;
655:
656: --Raise message if vendor site id is not passed
657: IF NVL(l_tapv_rec.ipvs_id,okl_api.g_miss_num) = okl_api.g_miss_num THEN
658: --raise message
659: OKL_Api.SET_MESSAGE
660: ( p_app_name => g_app_name,
661: p_msg_name => g_required_value,

Line 659: OKL_Api.SET_MESSAGE

655:
656: --Raise message if vendor site id is not passed
657: IF NVL(l_tapv_rec.ipvs_id,okl_api.g_miss_num) = okl_api.g_miss_num THEN
658: --raise message
659: OKL_Api.SET_MESSAGE
660: ( p_app_name => g_app_name,
661: p_msg_name => g_required_value,
662: p_token1 => g_col_name_token,
663: p_token1_value => 'ipvs_id'

Line 665: RAISE OKL_API.G_EXCEPTION_ERROR;

661: p_msg_name => g_required_value,
662: p_token1 => g_col_name_token,
663: p_token1_value => 'ipvs_id'
664: ) ;
665: RAISE OKL_API.G_EXCEPTION_ERROR;
666: END IF;
667:
668: --Raise message id payment terms id is not passed
669: IF NVL(l_tapv_rec.ippt_id,okl_api.g_miss_num) = okl_api.g_miss_num THEN

Line 669: IF NVL(l_tapv_rec.ippt_id,okl_api.g_miss_num) = okl_api.g_miss_num THEN

665: RAISE OKL_API.G_EXCEPTION_ERROR;
666: END IF;
667:
668: --Raise message id payment terms id is not passed
669: IF NVL(l_tapv_rec.ippt_id,okl_api.g_miss_num) = okl_api.g_miss_num THEN
670: --raise message
671: OKL_Api.SET_MESSAGE
672: ( p_app_name => g_app_name,
673: p_msg_name => g_required_value,

Line 671: OKL_Api.SET_MESSAGE

667:
668: --Raise message id payment terms id is not passed
669: IF NVL(l_tapv_rec.ippt_id,okl_api.g_miss_num) = okl_api.g_miss_num THEN
670: --raise message
671: OKL_Api.SET_MESSAGE
672: ( p_app_name => g_app_name,
673: p_msg_name => g_required_value,
674: p_token1 => g_col_name_token,
675: p_token1_value => 'ippt_id'

Line 677: RAISE OKL_API.G_EXCEPTION_ERROR;

673: p_msg_name => g_required_value,
674: p_token1 => g_col_name_token,
675: p_token1_value => 'ippt_id'
676: ) ;
677: RAISE OKL_API.G_EXCEPTION_ERROR;
678: END IF;
679:
680:
681: --Raise message if date entered is not passed

Line 682: IF NVL(l_tapv_rec.date_entered,okl_api.g_miss_date) = okl_api.g_miss_date THEN

678: END IF;
679:
680:
681: --Raise message if date entered is not passed
682: IF NVL(l_tapv_rec.date_entered,okl_api.g_miss_date) = okl_api.g_miss_date THEN
683: --raise message
684: OKL_Api.SET_MESSAGE
685: ( p_app_name => g_app_name,
686: p_msg_name => g_required_value,

Line 684: OKL_Api.SET_MESSAGE

680:
681: --Raise message if date entered is not passed
682: IF NVL(l_tapv_rec.date_entered,okl_api.g_miss_date) = okl_api.g_miss_date THEN
683: --raise message
684: OKL_Api.SET_MESSAGE
685: ( p_app_name => g_app_name,
686: p_msg_name => g_required_value,
687: p_token1 => g_col_name_token,
688: p_token1_value => 'date_entered'

Line 690: RAISE OKL_API.G_EXCEPTION_ERROR;

686: p_msg_name => g_required_value,
687: p_token1 => g_col_name_token,
688: p_token1_value => 'date_entered'
689: ) ;
690: RAISE OKL_API.G_EXCEPTION_ERROR;
691: END IF;
692:
693: --Raise message if date invoiced is not passed
694: IF NVL(l_tapv_rec.date_invoiced,okl_api.g_miss_date) = okl_api.g_miss_date THEN

Line 694: IF NVL(l_tapv_rec.date_invoiced,okl_api.g_miss_date) = okl_api.g_miss_date THEN

690: RAISE OKL_API.G_EXCEPTION_ERROR;
691: END IF;
692:
693: --Raise message if date invoiced is not passed
694: IF NVL(l_tapv_rec.date_invoiced,okl_api.g_miss_date) = okl_api.g_miss_date THEN
695: --raise message
696: OKL_Api.SET_MESSAGE
697: ( p_app_name => g_app_name,
698: p_msg_name => g_required_value,

Line 696: OKL_Api.SET_MESSAGE

692:
693: --Raise message if date invoiced is not passed
694: IF NVL(l_tapv_rec.date_invoiced,okl_api.g_miss_date) = okl_api.g_miss_date THEN
695: --raise message
696: OKL_Api.SET_MESSAGE
697: ( p_app_name => g_app_name,
698: p_msg_name => g_required_value,
699: p_token1 => g_col_name_token,
700: p_token1_value => 'date_invoiced'

Line 702: RAISE OKL_API.G_EXCEPTION_ERROR;

698: p_msg_name => g_required_value,
699: p_token1 => g_col_name_token,
700: p_token1_value => 'date_invoiced'
701: ) ;
702: RAISE OKL_API.G_EXCEPTION_ERROR;
703: END IF;
704:
705: --Raise message if amount is not passed
706: IF NVL(l_tapv_rec.amount,okl_api.g_miss_num) = okl_api.g_miss_num THEN

Line 706: IF NVL(l_tapv_rec.amount,okl_api.g_miss_num) = okl_api.g_miss_num THEN

702: RAISE OKL_API.G_EXCEPTION_ERROR;
703: END IF;
704:
705: --Raise message if amount is not passed
706: IF NVL(l_tapv_rec.amount,okl_api.g_miss_num) = okl_api.g_miss_num THEN
707: --raise message
708: OKL_Api.SET_MESSAGE
709: ( p_app_name => g_app_name,
710: p_msg_name => g_required_value,

Line 708: OKL_Api.SET_MESSAGE

704:
705: --Raise message if amount is not passed
706: IF NVL(l_tapv_rec.amount,okl_api.g_miss_num) = okl_api.g_miss_num THEN
707: --raise message
708: OKL_Api.SET_MESSAGE
709: ( p_app_name => g_app_name,
710: p_msg_name => g_required_value,
711: p_token1 => g_col_name_token,
712: p_token1_value => 'amount'

Line 714: RAISE OKL_API.G_EXCEPTION_ERROR;

710: p_msg_name => g_required_value,
711: p_token1 => g_col_name_token,
712: p_token1_value => 'amount'
713: ) ;
714: RAISE OKL_API.G_EXCEPTION_ERROR;
715:
716: END IF;
717:
718: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 748: IF NVL(l_tapv_rec.date_gl,okl_api.g_miss_date) = okl_api.g_miss_date THEN

744: END LOOP;
745: --end: 5/18/2007 cklee added rounding logc for line's amount
746:
747: -- Default gl date to date invoiced
748: IF NVL(l_tapv_rec.date_gl,okl_api.g_miss_date) = okl_api.g_miss_date THEN
749: l_tapv_rec.date_gl := l_tapv_rec.date_invoiced;
750: END IF;
751:
752: --Raise message id org id is not passed

Line 753: IF NVL(l_tapv_rec.org_id,okl_api.g_miss_num) = okl_api.g_miss_num THEN

749: l_tapv_rec.date_gl := l_tapv_rec.date_invoiced;
750: END IF;
751:
752: --Raise message id org id is not passed
753: IF NVL(l_tapv_rec.org_id,okl_api.g_miss_num) = okl_api.g_miss_num THEN
754: --Raise message
755: OKL_Api.SET_MESSAGE
756: ( p_app_name => g_app_name,
757: p_msg_name => g_required_value,

Line 755: OKL_Api.SET_MESSAGE

751:
752: --Raise message id org id is not passed
753: IF NVL(l_tapv_rec.org_id,okl_api.g_miss_num) = okl_api.g_miss_num THEN
754: --Raise message
755: OKL_Api.SET_MESSAGE
756: ( p_app_name => g_app_name,
757: p_msg_name => g_required_value,
758: p_token1 => g_col_name_token,
759: p_token1_value => 'org_id'

Line 761: RAISE OKL_API.G_EXCEPTION_ERROR;

757: p_msg_name => g_required_value,
758: p_token1 => g_col_name_token,
759: p_token1_value => 'org_id'
760: ) ;
761: RAISE OKL_API.G_EXCEPTION_ERROR;
762: END IF;
763:
764: -- Default legal entity id from the contract legal entity
765: IF NVL(l_tapv_rec.legal_entity_id,okl_api.g_miss_num) = okl_api.g_miss_num THEN

Line 765: IF NVL(l_tapv_rec.legal_entity_id,okl_api.g_miss_num) = okl_api.g_miss_num THEN

761: RAISE OKL_API.G_EXCEPTION_ERROR;
762: END IF;
763:
764: -- Default legal entity id from the contract legal entity
765: IF NVL(l_tapv_rec.legal_entity_id,okl_api.g_miss_num) = okl_api.g_miss_num THEN
766: --derive the legal entity id from the contract
767: l_tapv_rec.legal_entity_id := l_legal_entity_id;
768: END IF;
769:

Line 801: IF NVL(l_tplv_tbl(cnt).inv_distr_line_code,okl_api.g_miss_char) = okl_api.g_miss_char THEN

797:
798: l_total_amount := 0;
799: cnt := l_tplv_tbl.FIRST;
800: LOOP
801: IF NVL(l_tplv_tbl(cnt).inv_distr_line_code,okl_api.g_miss_char) = okl_api.g_miss_char THEN
802: l_tplv_tbl(cnt).inv_distr_line_code := 'ITEM';
803: END IF;
804: IF NVL(l_tplv_tbl(cnt).sty_id,okl_api.g_miss_num) = okl_api.g_miss_num THEN
805: --Raise message

Line 804: IF NVL(l_tplv_tbl(cnt).sty_id,okl_api.g_miss_num) = okl_api.g_miss_num THEN

800: LOOP
801: IF NVL(l_tplv_tbl(cnt).inv_distr_line_code,okl_api.g_miss_char) = okl_api.g_miss_char THEN
802: l_tplv_tbl(cnt).inv_distr_line_code := 'ITEM';
803: END IF;
804: IF NVL(l_tplv_tbl(cnt).sty_id,okl_api.g_miss_num) = okl_api.g_miss_num THEN
805: --Raise message
806: OKL_Api.SET_MESSAGE
807: ( p_app_name => g_app_name,
808: p_msg_name => g_required_value,

Line 806: OKL_Api.SET_MESSAGE

802: l_tplv_tbl(cnt).inv_distr_line_code := 'ITEM';
803: END IF;
804: IF NVL(l_tplv_tbl(cnt).sty_id,okl_api.g_miss_num) = okl_api.g_miss_num THEN
805: --Raise message
806: OKL_Api.SET_MESSAGE
807: ( p_app_name => g_app_name,
808: p_msg_name => g_required_value,
809: p_token1 => g_col_name_token,
810: p_token1_value => 'line'||cnt||' sty_id'

Line 812: RAISE OKL_API.G_EXCEPTION_ERROR;

808: p_msg_name => g_required_value,
809: p_token1 => g_col_name_token,
810: p_token1_value => 'line'||cnt||' sty_id'
811: ) ;
812: RAISE OKL_API.G_EXCEPTION_ERROR;
813: END IF;
814: IF NVL(l_tplv_tbl(cnt).line_number,okl_api.g_miss_num) = okl_api.g_miss_num THEN
815: --Raise message
816: OKL_Api.SET_MESSAGE

Line 814: IF NVL(l_tplv_tbl(cnt).line_number,okl_api.g_miss_num) = okl_api.g_miss_num THEN

810: p_token1_value => 'line'||cnt||' sty_id'
811: ) ;
812: RAISE OKL_API.G_EXCEPTION_ERROR;
813: END IF;
814: IF NVL(l_tplv_tbl(cnt).line_number,okl_api.g_miss_num) = okl_api.g_miss_num THEN
815: --Raise message
816: OKL_Api.SET_MESSAGE
817: ( p_app_name => g_app_name,
818: p_msg_name => g_required_value,

Line 816: OKL_Api.SET_MESSAGE

812: RAISE OKL_API.G_EXCEPTION_ERROR;
813: END IF;
814: IF NVL(l_tplv_tbl(cnt).line_number,okl_api.g_miss_num) = okl_api.g_miss_num THEN
815: --Raise message
816: OKL_Api.SET_MESSAGE
817: ( p_app_name => g_app_name,
818: p_msg_name => g_required_value,
819: p_token1 => g_col_name_token,
820: p_token1_value => 'line'||cnt||' line_number'

Line 822: RAISE OKL_API.G_EXCEPTION_ERROR;

818: p_msg_name => g_required_value,
819: p_token1 => g_col_name_token,
820: p_token1_value => 'line'||cnt||' line_number'
821: ) ;
822: RAISE OKL_API.G_EXCEPTION_ERROR;
823: END IF;
824: IF NVL(l_tplv_tbl(cnt).amount,okl_api.g_miss_num) = okl_api.g_miss_num THEN
825: --Raise message
826: OKL_Api.SET_MESSAGE

Line 824: IF NVL(l_tplv_tbl(cnt).amount,okl_api.g_miss_num) = okl_api.g_miss_num THEN

820: p_token1_value => 'line'||cnt||' line_number'
821: ) ;
822: RAISE OKL_API.G_EXCEPTION_ERROR;
823: END IF;
824: IF NVL(l_tplv_tbl(cnt).amount,okl_api.g_miss_num) = okl_api.g_miss_num THEN
825: --Raise message
826: OKL_Api.SET_MESSAGE
827: ( p_app_name => g_app_name,
828: p_msg_name => g_required_value,

Line 826: OKL_Api.SET_MESSAGE

822: RAISE OKL_API.G_EXCEPTION_ERROR;
823: END IF;
824: IF NVL(l_tplv_tbl(cnt).amount,okl_api.g_miss_num) = okl_api.g_miss_num THEN
825: --Raise message
826: OKL_Api.SET_MESSAGE
827: ( p_app_name => g_app_name,
828: p_msg_name => g_required_value,
829: p_token1 => g_col_name_token,
830: p_token1_value => 'line'||cnt||' amount'

Line 832: RAISE OKL_API.G_EXCEPTION_ERROR;

828: p_msg_name => g_required_value,
829: p_token1 => g_col_name_token,
830: p_token1_value => 'line'||cnt||' amount'
831: ) ;
832: RAISE OKL_API.G_EXCEPTION_ERROR;
833: ELSE
834: IF l_tapv_rec.invoice_type = 'CREDIT' THEN
835: IF SIGN(l_tplv_tbl(cnt).amount) = 1 THEN
836: l_tplv_tbl(cnt).amount := -(l_tplv_tbl(cnt).amount);

Line 840: IF NVL(l_tplv_tbl(cnt).org_id,okl_api.g_miss_num) = okl_api.g_miss_num THEN

836: l_tplv_tbl(cnt).amount := -(l_tplv_tbl(cnt).amount);
837: END IF;
838: END IF;
839: END IF;
840: IF NVL(l_tplv_tbl(cnt).org_id,okl_api.g_miss_num) = okl_api.g_miss_num THEN
841: --Raise message
842: OKL_Api.SET_MESSAGE
843: ( p_app_name => g_app_name,
844: p_msg_name => g_required_value,

Line 842: OKL_Api.SET_MESSAGE

838: END IF;
839: END IF;
840: IF NVL(l_tplv_tbl(cnt).org_id,okl_api.g_miss_num) = okl_api.g_miss_num THEN
841: --Raise message
842: OKL_Api.SET_MESSAGE
843: ( p_app_name => g_app_name,
844: p_msg_name => g_required_value,
845: p_token1 => g_col_name_token,
846: p_token1_value => 'line'||cnt||' org_id'

Line 848: RAISE OKL_API.G_EXCEPTION_ERROR;

844: p_msg_name => g_required_value,
845: p_token1 => g_col_name_token,
846: p_token1_value => 'line'||cnt||' org_id'
847: ) ;
848: RAISE OKL_API.G_EXCEPTION_ERROR;
849: END IF;
850: --START:| 11-Dec-07 cklee -- Fixed bug: 6682348 -- stamped request_id when insert |
851: l_tplv_tbl(cnt).REQUEST_ID := Fnd_Global.CONC_REQUEST_ID;
852: --END:| 11-Dec-07 cklee -- Fixed bug: 6682348 -- stamped request_id when insert |

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

859: END LOOP;
860:
861: --Error: Sign of total amount on lines do not match the sign of amount on the header transaction
862: IF SIGN(l_total_amount) <> SIGN(l_tapv_rec.amount) THEN
863: OKL_API.set_message( p_app_name => 'OKL',
864: p_msg_name => 'OKL_BPD_SIGN_ERROR');
865: RAISE OKL_API.G_EXCEPTION_ERROR;
866: END IF;
867:

Line 865: RAISE OKL_API.G_EXCEPTION_ERROR;

861: --Error: Sign of total amount on lines do not match the sign of amount on the header transaction
862: IF SIGN(l_total_amount) <> SIGN(l_tapv_rec.amount) THEN
863: OKL_API.set_message( p_app_name => 'OKL',
864: p_msg_name => 'OKL_BPD_SIGN_ERROR');
865: RAISE OKL_API.G_EXCEPTION_ERROR;
866: END IF;
867:
868: IF l_total_amount <> l_tapv_rec.amount THEN
869: OKL_API.set_message( p_app_name => 'OKL',

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

865: RAISE OKL_API.G_EXCEPTION_ERROR;
866: END IF;
867:
868: IF l_total_amount <> l_tapv_rec.amount THEN
869: OKL_API.set_message( p_app_name => 'OKL',
870: p_msg_name => 'OKL_BPD_AMOUNT_ERROR');
871: RAISE OKL_API.G_EXCEPTION_ERROR;
872: END IF;
873:

Line 871: RAISE OKL_API.G_EXCEPTION_ERROR;

867:
868: IF l_total_amount <> l_tapv_rec.amount THEN
869: OKL_API.set_message( p_app_name => 'OKL',
870: p_msg_name => 'OKL_BPD_AMOUNT_ERROR');
871: RAISE OKL_API.G_EXCEPTION_ERROR;
872: END IF;
873:
874: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
875: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'before create transaction invoice line');

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

883: ,x_msg_data => x_msg_data
884: ,p_tplv_tbl => l_tplv_tbl
885: ,x_tplv_tbl => lx_tplv_tbl);
886:
887: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
888: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
889: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
890: RAISE OKl_API.G_EXCEPTION_ERROR;
891: END IF;

Line 888: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

884: ,p_tplv_tbl => l_tplv_tbl
885: ,x_tplv_tbl => lx_tplv_tbl);
886:
887: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
888: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
889: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
890: RAISE OKl_API.G_EXCEPTION_ERROR;
891: END IF;
892:

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

885: ,x_tplv_tbl => lx_tplv_tbl);
886:
887: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
888: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
889: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
890: RAISE OKl_API.G_EXCEPTION_ERROR;
891: END IF;
892:
893: cnt := lx_tplv_tbl.FIRST;

Line 890: RAISE OKl_API.G_EXCEPTION_ERROR;

886:
887: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
888: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
889: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
890: RAISE OKl_API.G_EXCEPTION_ERROR;
891: END IF;
892:
893: cnt := lx_tplv_tbl.FIRST;
894: LOOP

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

939: ,p_trx_date => p_tapv_rec.date_invoiced
940: ,x_fact_synd_code => l_tmpl_identify_rec.FACTORING_SYND_FLAG
941: ,x_inv_acct_code => l_tmpl_identify_rec.INVESTOR_CODE);
942:
943: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
944: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
945: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
946: RAISE OKL_API.G_EXCEPTION_ERROR;
947: END IF;

Line 944: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

940: ,x_fact_synd_code => l_tmpl_identify_rec.FACTORING_SYND_FLAG
941: ,x_inv_acct_code => l_tmpl_identify_rec.INVESTOR_CODE);
942:
943: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
944: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
945: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
946: RAISE OKL_API.G_EXCEPTION_ERROR;
947: END IF;
948:

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

941: ,x_inv_acct_code => l_tmpl_identify_rec.INVESTOR_CODE);
942:
943: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
944: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
945: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
946: RAISE OKL_API.G_EXCEPTION_ERROR;
947: END IF;
948:
949: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 946: RAISE OKL_API.G_EXCEPTION_ERROR;

942:
943: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
944: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
945: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
946: RAISE OKL_API.G_EXCEPTION_ERROR;
947: END IF;
948:
949: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
950: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Okl_Securitization_pvt.check_khr_ia_associated called successfully'|| x_return_status);

Line 970: IF (NVL(l_dist_info_rec.currency_code, okl_api.g_miss_char) = okl_api.g_miss_char) IS NULL THEN

966:
967: --Check for currency code
968: l_dist_info_rec.currency_code := l_tapv_rec.currency_code;
969:
970: IF (NVL(l_dist_info_rec.currency_code, okl_api.g_miss_char) = okl_api.g_miss_char) IS NULL THEN
971: l_dist_info_rec.currency_code := l_currency_code;
972: END IF;
973:
974: --Check for currency conversion type

Line 977: IF (NVL(l_dist_info_rec.currency_conversion_type, okl_api.g_miss_char) = okl_api.g_miss_char) THEN

973:
974: --Check for currency conversion type
975: l_dist_info_rec.currency_conversion_type := l_tapv_rec.currency_conversion_type;
976:
977: IF (NVL(l_dist_info_rec.currency_conversion_type, okl_api.g_miss_char) = okl_api.g_miss_char) THEN
978: l_dist_info_rec.currency_conversion_type := l_currency_conversion_type;
979: END IF;
980:
981: --Check for currency conversion date

Line 984: IF (NVL(l_dist_info_rec.currency_conversion_date, okl_api.g_miss_date) = okl_api.g_miss_date) THEN

980:
981: --Check for currency conversion date
982: l_dist_info_rec.currency_conversion_date := l_tapv_rec.currency_conversion_date;
983:
984: IF (NVL(l_dist_info_rec.currency_conversion_date, okl_api.g_miss_date) = okl_api.g_miss_date) THEN
985: l_dist_info_rec.currency_conversion_date := l_currency_conversion_date;
986: END IF;
987:
988:

Line 993: IF (NVL(l_tapv_rec.currency_conversion_rate, okl_api.g_miss_num) = okl_api.g_miss_num) THEN

989: IF (l_dist_info_rec.currency_conversion_type = 'User') THEN
990: IF (l_dist_info_rec.currency_code = okl_accounting_util.get_func_curr_code) THEN
991: l_dist_info_rec.currency_conversion_rate := 1;
992: ELSE
993: IF (NVL(l_tapv_rec.currency_conversion_rate, okl_api.g_miss_num) = okl_api.g_miss_num) THEN
994: l_dist_info_rec.currency_conversion_rate := l_currency_conversion_rate;
995: ELSE
996: l_dist_info_rec.currency_conversion_rate := l_tapv_rec.currency_conversion_rate;
997: END IF;

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

1020: p_contract_line_id => lx_tplv_tbl(cnt).kle_id,
1021: x_acc_gen_tbl => l_acc_gen_primary_key_tbl,
1022: x_return_status => x_return_status);
1023:
1024: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1025: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1026: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1027: RAISE OKL_API.G_EXCEPTION_ERROR;
1028: END IF;

Line 1025: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1021: x_acc_gen_tbl => l_acc_gen_primary_key_tbl,
1022: x_return_status => x_return_status);
1023:
1024: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1025: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1026: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1027: RAISE OKL_API.G_EXCEPTION_ERROR;
1028: END IF;
1029:

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

1022: x_return_status => x_return_status);
1023:
1024: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1025: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1026: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1027: RAISE OKL_API.G_EXCEPTION_ERROR;
1028: END IF;
1029:
1030: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 1027: RAISE OKL_API.G_EXCEPTION_ERROR;

1023:
1024: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1025: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1026: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1027: RAISE OKL_API.G_EXCEPTION_ERROR;
1028: END IF;
1029:
1030: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1031: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'End call to Okl_Acc_Call_Pvt.Okl_Populate_Acc_Gen');

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

1049: ,p_acc_gen_primary_key_tbl => l_acc_gen_primary_key_tbl
1050: ,x_template_tbl => l_template_tbl
1051: ,x_amount_tbl => l_amount_tbl);
1052:
1053: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1054: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1055: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1056: RAISE OKL_API.G_EXCEPTION_ERROR;
1057: END IF;

Line 1054: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1050: ,x_template_tbl => l_template_tbl
1051: ,x_amount_tbl => l_amount_tbl);
1052:
1053: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1054: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1055: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1056: RAISE OKL_API.G_EXCEPTION_ERROR;
1057: END IF;
1058:

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

1051: ,x_amount_tbl => l_amount_tbl);
1052:
1053: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1054: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1055: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1056: RAISE OKL_API.G_EXCEPTION_ERROR;
1057: END IF;
1058:
1059: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 1056: RAISE OKL_API.G_EXCEPTION_ERROR;

1052:
1053: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1054: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1055: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1056: RAISE OKL_API.G_EXCEPTION_ERROR;
1057: END IF;
1058:
1059: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1060: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'End Call to Okl_Account_Dist_Pub.Create_Accounting_Dist ');

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

1103: ,p_trx_date => p_tapv_rec.date_invoiced
1104: ,x_fact_synd_code => l_fact_synd_code
1105: ,x_inv_acct_code => l_inv_acct_code);
1106:
1107: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1108: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1109: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1110: RAISE OKL_API.G_EXCEPTION_ERROR;
1111: END IF;

Line 1108: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1104: ,x_fact_synd_code => l_fact_synd_code
1105: ,x_inv_acct_code => l_inv_acct_code);
1106:
1107: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1108: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1109: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1110: RAISE OKL_API.G_EXCEPTION_ERROR;
1111: END IF;
1112:

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

1105: ,x_inv_acct_code => l_inv_acct_code);
1106:
1107: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1108: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1109: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1110: RAISE OKL_API.G_EXCEPTION_ERROR;
1111: END IF;
1112:
1113: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 1110: RAISE OKL_API.G_EXCEPTION_ERROR;

1106:
1107: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1108: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1109: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1110: RAISE OKL_API.G_EXCEPTION_ERROR;
1111: END IF;
1112:
1113: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1114: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Okl_Securitization_pvt.check_khr_ia_associated called successfully'|| x_return_status);

Line 1146: IF (NVL(l_dist_info_tbl(cnt).currency_code, okl_api.g_miss_char) = okl_api.g_miss_char) IS NULL THEN

1142:
1143: --Check for currency code
1144: l_dist_info_tbl(cnt).currency_code := l_tapv_rec.currency_code;
1145:
1146: IF (NVL(l_dist_info_tbl(cnt).currency_code, okl_api.g_miss_char) = okl_api.g_miss_char) IS NULL THEN
1147: l_dist_info_tbl(cnt).currency_code := l_currency_code;
1148: END IF;
1149:
1150: --Check for currency conversion type

Line 1153: IF (NVL(l_dist_info_tbl(cnt).currency_conversion_type, okl_api.g_miss_char) = okl_api.g_miss_char) THEN

1149:
1150: --Check for currency conversion type
1151: l_dist_info_tbl(cnt).currency_conversion_type := l_tapv_rec.currency_conversion_type;
1152:
1153: IF (NVL(l_dist_info_tbl(cnt).currency_conversion_type, okl_api.g_miss_char) = okl_api.g_miss_char) THEN
1154: l_dist_info_tbl(cnt).currency_conversion_type := l_currency_conversion_type;
1155: END IF;
1156:
1157: --Check for currency conversion date

Line 1160: IF (NVL(l_dist_info_tbl(cnt).currency_conversion_date, okl_api.g_miss_date) = okl_api.g_miss_date) THEN

1156:
1157: --Check for currency conversion date
1158: l_dist_info_tbl(cnt).currency_conversion_date := l_tapv_rec.currency_conversion_date;
1159:
1160: IF (NVL(l_dist_info_tbl(cnt).currency_conversion_date, okl_api.g_miss_date) = okl_api.g_miss_date) THEN
1161: l_dist_info_tbl(cnt).currency_conversion_date := l_currency_conversion_date;
1162: END IF;
1163:
1164: IF (l_dist_info_tbl(cnt).currency_conversion_type = 'User') THEN

Line 1168: IF (NVL(l_tapv_rec.currency_conversion_rate, okl_api.g_miss_num) = okl_api.g_miss_num) THEN

1164: IF (l_dist_info_tbl(cnt).currency_conversion_type = 'User') THEN
1165: IF (l_dist_info_tbl(cnt).currency_code = okl_accounting_util.get_func_curr_code) THEN
1166: l_dist_info_tbl(cnt).currency_conversion_rate := 1;
1167: ELSE
1168: IF (NVL(l_tapv_rec.currency_conversion_rate, okl_api.g_miss_num) = okl_api.g_miss_num) THEN
1169: l_dist_info_tbl(cnt).currency_conversion_rate := l_currency_conversion_rate;
1170: ELSE
1171: l_dist_info_tbl(cnt).currency_conversion_rate := l_tapv_rec.currency_conversion_rate;
1172: END IF;

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

1194: x_return_status => x_return_status);
1195:
1196: l_acc_gen_primary_key_tbl(cnt).source_id := lx_tplv_tbl(cnt).id;
1197:
1198: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1199: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1200: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1201: RAISE OKL_API.G_EXCEPTION_ERROR;
1202: END IF;

Line 1199: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1195:
1196: l_acc_gen_primary_key_tbl(cnt).source_id := lx_tplv_tbl(cnt).id;
1197:
1198: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1199: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1200: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1201: RAISE OKL_API.G_EXCEPTION_ERROR;
1202: END IF;
1203:

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

1196: l_acc_gen_primary_key_tbl(cnt).source_id := lx_tplv_tbl(cnt).id;
1197:
1198: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1199: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1200: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1201: RAISE OKL_API.G_EXCEPTION_ERROR;
1202: END IF;
1203:
1204: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 1201: RAISE OKL_API.G_EXCEPTION_ERROR;

1197:
1198: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1199: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1200: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1201: RAISE OKL_API.G_EXCEPTION_ERROR;
1202: END IF;
1203:
1204: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1205: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'End call to Okl_Acc_Call_Pvt.Okl_Populate_Acc_Gen');

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

1226: ,x_amount_tbl => l_amount_tbl
1227: ,p_trx_header_id => lx_tapv_rec.ID
1228: ,p_trx_header_table => 'OKL_TRX_AP_INVOICES_B');
1229:
1230: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1231: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1232: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1233: RAISE OKL_API.G_EXCEPTION_ERROR;
1234: END IF;

Line 1231: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1227: ,p_trx_header_id => lx_tapv_rec.ID
1228: ,p_trx_header_table => 'OKL_TRX_AP_INVOICES_B');
1229:
1230: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1231: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1232: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1233: RAISE OKL_API.G_EXCEPTION_ERROR;
1234: END IF;
1235:

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

1228: ,p_trx_header_table => 'OKL_TRX_AP_INVOICES_B');
1229:
1230: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1231: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1232: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1233: RAISE OKL_API.G_EXCEPTION_ERROR;
1234: END IF;
1235:
1236: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 1233: RAISE OKL_API.G_EXCEPTION_ERROR;

1229:
1230: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1231: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1232: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1233: RAISE OKL_API.G_EXCEPTION_ERROR;
1234: END IF;
1235:
1236: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1237: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'End Call to Okl_Account_Dist_Pub.Create_Accounting_Dist ');

Line 1246: OKL_API.END_ACTIVITY (x_msg_count,

1242: -- END: Move accounting call after creating the OKL AP internal invoice lines
1243: ------------------------------------------------------------------------------
1244:
1245:
1246: OKL_API.END_ACTIVITY (x_msg_count,
1247: x_msg_data );
1248:
1249: IF (G_IS_DEBUG_PROCEDURE_ON = true) THEN
1250: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, G_MODULE,'End OKLRCDTB.pls Debug call ');

Line 1253: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1249: IF (G_IS_DEBUG_PROCEDURE_ON = true) THEN
1250: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, G_MODULE,'End OKLRCDTB.pls Debug call ');
1251: END IF;
1252: EXCEPTION
1253: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1254: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1255: l_api_name,
1256: G_PKG_NAME,
1257: 'OKL_API.G_RET_STS_ERROR',

Line 1254: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1250: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, G_MODULE,'End OKLRCDTB.pls Debug call ');
1251: END IF;
1252: EXCEPTION
1253: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1254: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1255: l_api_name,
1256: G_PKG_NAME,
1257: 'OKL_API.G_RET_STS_ERROR',
1258: x_msg_count,

Line 1257: 'OKL_API.G_RET_STS_ERROR',

1253: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1254: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1255: l_api_name,
1256: G_PKG_NAME,
1257: 'OKL_API.G_RET_STS_ERROR',
1258: x_msg_count,
1259: x_msg_data,
1260: '_PVT');
1261: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1261: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1257: 'OKL_API.G_RET_STS_ERROR',
1258: x_msg_count,
1259: x_msg_data,
1260: '_PVT');
1261: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1262: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1263: l_api_name,
1264: G_PKG_NAME,
1265: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1262: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

1258: x_msg_count,
1259: x_msg_data,
1260: '_PVT');
1261: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1262: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1263: l_api_name,
1264: G_PKG_NAME,
1265: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1266: x_msg_count,

Line 1265: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1261: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1262: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1263: l_api_name,
1264: G_PKG_NAME,
1265: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1266: x_msg_count,
1267: x_msg_data,
1268: '_PVT');
1269: WHEN OTHERS THEN

Line 1270: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

1266: x_msg_count,
1267: x_msg_data,
1268: '_PVT');
1269: WHEN OTHERS THEN
1270: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1271: l_api_name,
1272: G_PKG_NAME,
1273: 'OTHERS',
1274: x_msg_count,

Line 1283: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

1279:
1280:
1281: -- Procedure for updating Transaction status
1282: PROCEDURE Update_Disb_Trx(p_api_version IN NUMBER
1283: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
1284: ,x_return_status OUT NOCOPY VARCHAR2
1285: ,x_msg_count OUT NOCOPY NUMBER
1286: ,x_msg_data OUT NOCOPY VARCHAR2
1287: ,p_tapv_rec IN tapv_rec_type

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

1288: ,x_tapv_rec OUT NOCOPY tapv_rec_type
1289: )
1290: IS
1291: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_DISB_TRX';
1292: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1293: l_tapv_rec tapv_rec_type;
1294: lx_tapv_rec tapv_rec_type;
1295: BEGIN
1296: IF (G_DEBUG_ENABLED = 'Y') THEN

Line 1300: l_return_status := okl_api.start_activity(

1296: IF (G_DEBUG_ENABLED = 'Y') THEN
1297: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1298: END IF;
1299:
1300: l_return_status := okl_api.start_activity(
1301: p_api_name => l_api_name,
1302: p_init_msg_list => p_init_msg_list,
1303: p_api_type => '_PVT',
1304: x_return_status => l_return_status);

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

1302: p_init_msg_list => p_init_msg_list,
1303: p_api_type => '_PVT',
1304: x_return_status => l_return_status);
1305:
1306: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1307: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1308: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1309: RAISE OKL_API.G_EXCEPTION_ERROR;
1310: END IF;

Line 1307: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1303: p_api_type => '_PVT',
1304: x_return_status => l_return_status);
1305:
1306: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1307: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1308: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1309: RAISE OKL_API.G_EXCEPTION_ERROR;
1310: END IF;
1311:

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

1304: x_return_status => l_return_status);
1305:
1306: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1307: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1308: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1309: RAISE OKL_API.G_EXCEPTION_ERROR;
1310: END IF;
1311:
1312: l_tapv_rec := p_tapv_rec;

Line 1309: RAISE OKL_API.G_EXCEPTION_ERROR;

1305:
1306: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1307: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1308: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1309: RAISE OKL_API.G_EXCEPTION_ERROR;
1310: END IF;
1311:
1312: l_tapv_rec := p_tapv_rec;
1313:

Line 1330: OKL_API.END_ACTIVITY (x_msg_count,

1326: END IF;
1327:
1328: x_tapv_rec := lx_tapv_rec;
1329:
1330: OKL_API.END_ACTIVITY (x_msg_count,
1331: x_msg_data );
1332:
1333: EXCEPTION
1334: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 1334: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1330: OKL_API.END_ACTIVITY (x_msg_count,
1331: x_msg_data );
1332:
1333: EXCEPTION
1334: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1335: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1336: l_api_name,
1337: G_PKG_NAME,
1338: 'OKL_API.G_RET_STS_ERROR',

Line 1335: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1331: x_msg_data );
1332:
1333: EXCEPTION
1334: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1335: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1336: l_api_name,
1337: G_PKG_NAME,
1338: 'OKL_API.G_RET_STS_ERROR',
1339: x_msg_count,

Line 1338: 'OKL_API.G_RET_STS_ERROR',

1334: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1335: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1336: l_api_name,
1337: G_PKG_NAME,
1338: 'OKL_API.G_RET_STS_ERROR',
1339: x_msg_count,
1340: x_msg_data,
1341: '_PVT');
1342: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1342: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1338: 'OKL_API.G_RET_STS_ERROR',
1339: x_msg_count,
1340: x_msg_data,
1341: '_PVT');
1342: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1343: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1344: l_api_name,
1345: G_PKG_NAME,
1346: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1343: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

1339: x_msg_count,
1340: x_msg_data,
1341: '_PVT');
1342: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1343: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1344: l_api_name,
1345: G_PKG_NAME,
1346: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1347: x_msg_count,

Line 1346: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1342: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1343: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1344: l_api_name,
1345: G_PKG_NAME,
1346: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1347: x_msg_count,
1348: x_msg_data,
1349: '_PVT');
1350: WHEN OTHERS THEN

Line 1351: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

1347: x_msg_count,
1348: x_msg_data,
1349: '_PVT');
1350: WHEN OTHERS THEN
1351: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1352: l_api_name,
1353: G_PKG_NAME,
1354: 'OTHERS',
1355: x_msg_count,