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

Line 18: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

14: G_AR_DATA_LENGTH CONSTANT VARCHAR2(4) := '150';
15: -- end vpanwar 20-July-07 -- interface line length increase from 30 to 150
16: G_ACC_SYS_OPTION VARCHAR2(4);
17: -- G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_BPD_ADVANCED_BILLING_PVT';
18: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
19: G_REQUIRED_VALUE CONSTANT VARCHAR2(30) := 'OKL_REQUIRED_VALUE';
20: G_COL_NAME_TOKEN CONSTANT VARCHAR2(30) := OKL_API.G_COL_NAME_TOKEN;
21:
22: --

Line 20: G_COL_NAME_TOKEN CONSTANT VARCHAR2(30) := OKL_API.G_COL_NAME_TOKEN;

16: G_ACC_SYS_OPTION VARCHAR2(4);
17: -- G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_BPD_ADVANCED_BILLING_PVT';
18: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
19: G_REQUIRED_VALUE CONSTANT VARCHAR2(30) := 'OKL_REQUIRED_VALUE';
20: G_COL_NAME_TOKEN CONSTANT VARCHAR2(30) := OKL_API.G_COL_NAME_TOKEN;
21:
22: --
23: ----------------------------------------------------------------------------------
24: -- Start of comments

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

42: ,x_customer_bank_account_id OUT NOCOPY NUMBER
43: ,x_receipt_method_id OUT NOCOPY NUMBER
44: )
45: IS
46: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
47: -- -----------------------------------------------------
48: -- Variable definitions for line level bill-to_support
49: -- -----------------------------------------------------
50: l_pmth_line_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;

Line 218: IF (p_kle_id IS NOT NULL AND p_kle_id <> okl_api.g_miss_num)

214: -- -------------------------------------------------------
215: l_line_cust_address_id := NULL;
216: l_line_term_id := NULL;
217:
218: IF (p_kle_id IS NOT NULL AND p_kle_id <> okl_api.g_miss_num)
219: THEN
220:
221: OPEN get_chr_id(p_kle_id);
222: FETCH get_chr_id INTO l_khr_id;

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

303: ,x_customer_bank_account_id OUT NOCOPY NUMBER
304: ,x_receipt_method_id OUT NOCOPY NUMBER
305: )
306: IS
307: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
308: lx_remrkt_sty_id number;
309:
310: BEGIN
311:

Line 324: IF l_return_status = Okl_Api.g_ret_sts_success THEN

320: 'ASSET_SALE_RECEIVABLE',
321: l_return_status,
322: lx_remrkt_sty_id);
323:
324: IF l_return_status = Okl_Api.g_ret_sts_success THEN
325:
326: IF(lx_remrkt_sty_id = p_sty_id) THEN
327:
328: x_customer_bank_account_id := NULL;

Line 620: x_return_status := OKL_API.G_RET_STS_SUCCESS;

616: AND ORG_ID = MO_GLOBAL.get_current_org_id();
617: --gkhuntet end.
618: BEGIN
619:
620: x_return_status := OKL_API.G_RET_STS_SUCCESS;
621: -------------------------------------------
622: -- Fetch Batch Source Id for OKL_CONTRACTS
623: -------------------------------------------
624: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Fetching Batch Source');

Line 634: RAISE Okl_Api.G_EXCEPTION_ERROR;

630: FETCH batch_src_csr INTO l_batch_source_rec.batch_source_id;
631: IF (batch_src_csr%NOTFOUND) THEN
632: CLOSE batch_src_csr;
633: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error: Unable to retrieve Batch Source');
634: RAISE Okl_Api.G_EXCEPTION_ERROR;
635: END IF;
636: CLOSE batch_src_csr;
637: l_batch_source_rec.default_date := p_trx_date;
638:

Line 644: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

640: ||' l_batch_source_rec.default_date: '||l_batch_source_rec.default_date);
641:
642: EXCEPTION
643: WHEN OTHERS THEN
644: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
645: END PREPARE_BATCH_SOURCE_REC;
646:
647:
648: --------------------------------------------

Line 813: x_return_status := OKL_API.G_RET_STS_SUCCESS;

809: BEGIN
810: -- Assign IN record to local record
811: lxfer_rec := xfer_rec;
812:
813: x_return_status := OKL_API.G_RET_STS_SUCCESS;
814:
815: --start: 02-APR-07 cklee R12 Billing enhancement project |
816: --start:| 06-Apr-2007 cklee -- Fixed kle_id, asset_number issues |
817: -- 1. Check if it's a top line

Line 1097: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1093:
1094:
1095: EXCEPTION
1096: WHEN OTHERS THEN
1097: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1098: END PREPARE_TRX_HDR_TBL;
1099:
1100: --------------------------------------------
1101: -- Prepare Transaction Lines Table

Line 1123: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;

1119: x_tax_det_rec OKL_PROCESS_SALES_TAX_PVT.tax_det_rec_type;
1120: l_api_version NUMBER := 1.0;
1121: x_msg_count NUMBER;
1122: x_msg_data VARCHAR2(4000);
1123: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;
1124:
1125: l_ship_to NUMBER;
1126: l_kle_id NUMBER;
1127: l_top_kle_id NUMBER;

Line 1315: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1311:
1312: -- Assign to local record
1313: lxfer_rec := xfer_rec;
1314:
1315: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1316:
1317: --start: 02-APR-07 cklee R12 Billing enhancement project |
1318: -- Migrated logic from okl_arintf_pvt
1319: -- get memo line id for tax only invoices

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

1634: p_source_table => 'OKL_TXD_AR_LN_DTLS_B',
1635: x_tax_det_rec => x_tax_det_rec);
1636:
1637:
1638: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1639: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1640: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1641: RAISE OKL_API.G_EXCEPTION_ERROR;
1642: END IF;

Line 1639: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1635: x_tax_det_rec => x_tax_det_rec);
1636:
1637:
1638: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1639: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1640: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1641: RAISE OKL_API.G_EXCEPTION_ERROR;
1642: END IF;
1643:

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

1636:
1637:
1638: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1639: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1640: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1641: RAISE OKL_API.G_EXCEPTION_ERROR;
1642: END IF;
1643:
1644: -- l_trx_lines_tbl(1).TAX_CODE := x_tax_det_rec.x_TAX_CODE;

Line 1641: RAISE OKL_API.G_EXCEPTION_ERROR;

1637:
1638: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1639: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1640: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1641: RAISE OKL_API.G_EXCEPTION_ERROR;
1642: END IF;
1643:
1644: -- l_trx_lines_tbl(1).TAX_CODE := x_tax_det_rec.x_TAX_CODE;
1645: /* inv_lines_tbl(hdr_cnt).TRX_BUSINESS_CATEGORY := x_tax_det_rec.x_TRX_BUSINESS_CATEGORY; */

Line 1711: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1707: l_trx_lines_tbl(1).SHIP_DATE_ACTUAL := NULL;
1708:
1709: EXCEPTION
1710: WHEN OTHERS THEN
1711: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1712: END PREPARE_TRX_LNS_TBL;
1713:
1714:
1715: --------------------------------------------

Line 1744: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1740:
1741: -- Assign IN to local record
1742: lxfer_rec := xfer_rec;
1743:
1744: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1745:
1746: i := 0;
1747: --start: | 02-APR-07 cklee R12 Billing enhancement project |
1748: /* commented out for R12

Line 1818: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1814: --end: | 02-APR-07 cklee R12 Billing enhancement project |
1815:
1816: EXCEPTION
1817: WHEN OTHERS THEN
1818: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1819: END PREPARE_TRX_DIST_TBL;
1820:
1821: ------------------------------------------------------------------
1822: -- Procedure ADVANCED_BILLING to bill outstanding stream elements

Line 1843: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1839: -- Declare variables required by APIs
1840: -- ---------------------------------------------------------
1841: l_api_version CONSTANT NUMBER := 1;
1842: l_api_name CONSTANT VARCHAR2(30) := 'ADVANCED_BILLING';
1843: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1844:
1845: --start: | 02-APR-07 cklee R12 Billing enhancement project
1846:
1847: --gkhuntet - FP Bug 5516814..start

Line 2278: l_overall_err_sts := Okl_Api.G_RET_STS_SUCCESS;

2274:
2275: ------------------------------------------------------------
2276: -- Start processing
2277: ------------------------------------------------------------
2278: l_overall_err_sts := Okl_Api.G_RET_STS_SUCCESS;
2279:
2280: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2281:
2282: l_return_status := Okl_Api.START_ACTIVITY(

Line 2280: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

2276: -- Start processing
2277: ------------------------------------------------------------
2278: l_overall_err_sts := Okl_Api.G_RET_STS_SUCCESS;
2279:
2280: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2281:
2282: l_return_status := Okl_Api.START_ACTIVITY(
2283: p_api_name => l_api_name,
2284: p_pkg_name => G_PKG_NAME,

Line 2282: l_return_status := Okl_Api.START_ACTIVITY(

2278: l_overall_err_sts := Okl_Api.G_RET_STS_SUCCESS;
2279:
2280: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2281:
2282: l_return_status := Okl_Api.START_ACTIVITY(
2283: p_api_name => l_api_name,
2284: p_pkg_name => G_PKG_NAME,
2285: p_init_msg_list => p_init_msg_list,
2286: l_api_version => l_api_version,

Line 2291: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2287: p_api_version => p_api_version,
2288: p_api_type => '_PVT',
2289: x_return_status => l_return_status);
2290:
2291: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2292: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2293: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2294: RAISE Okl_Api.G_EXCEPTION_ERROR;
2295: END IF;

Line 2292: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2288: p_api_type => '_PVT',
2289: x_return_status => l_return_status);
2290:
2291: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2292: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2293: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2294: RAISE Okl_Api.G_EXCEPTION_ERROR;
2295: END IF;
2296: --gkhuntet FP Bug 5516814 start

Line 2293: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2289: x_return_status => l_return_status);
2290:
2291: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2292: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2293: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2294: RAISE Okl_Api.G_EXCEPTION_ERROR;
2295: END IF;
2296: --gkhuntet FP Bug 5516814 start
2297: FOR c_get_adv_rcpt_for_cont_rec IN c_get_adv_rcpt_for_cont (p_contract_number)

Line 2294: RAISE Okl_Api.G_EXCEPTION_ERROR;

2290:
2291: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2292: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2293: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2294: RAISE Okl_Api.G_EXCEPTION_ERROR;
2295: END IF;
2296: --gkhuntet FP Bug 5516814 start
2297: FOR c_get_adv_rcpt_for_cont_rec IN c_get_adv_rcpt_for_cont (p_contract_number)
2298: LOOP

Line 2310: IF (l_contract_number is null or l_contract_number = okl_api.g_miss_char ) THEN -- rmunjulu R12 Fixes

2306: --start: | 02-APR-07 cklee R12 Billing enhancement project |
2307: -- Verify if contract number is passed in
2308: -- gboomina Bug 7168534 - start
2309: -- passing correct variable for contract number
2310: IF (l_contract_number is null or l_contract_number = okl_api.g_miss_char ) THEN -- rmunjulu R12 Fixes
2311: OKL_API.Set_Message(p_app_name => G_APP_NAME,
2312: p_msg_name => G_REQUIRED_VALUE,
2313: p_token1 => G_COL_NAME_TOKEN,
2314: p_token1_value => 'OKL_BPD_ADVANCED_BILLING_PVT.ADVANCED_BILLING.p_contract_number');

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

2307: -- Verify if contract number is passed in
2308: -- gboomina Bug 7168534 - start
2309: -- passing correct variable for contract number
2310: IF (l_contract_number is null or l_contract_number = okl_api.g_miss_char ) THEN -- rmunjulu R12 Fixes
2311: OKL_API.Set_Message(p_app_name => G_APP_NAME,
2312: p_msg_name => G_REQUIRED_VALUE,
2313: p_token1 => G_COL_NAME_TOKEN,
2314: p_token1_value => 'OKL_BPD_ADVANCED_BILLING_PVT.ADVANCED_BILLING.p_contract_number');
2315:

Line 2316: RAISE OKL_API.G_EXCEPTION_ERROR;

2312: p_msg_name => G_REQUIRED_VALUE,
2313: p_token1 => G_COL_NAME_TOKEN,
2314: p_token1_value => 'OKL_BPD_ADVANCED_BILLING_PVT.ADVANCED_BILLING.p_contract_number');
2315:
2316: RAISE OKL_API.G_EXCEPTION_ERROR;
2317: END IF;
2318: -- gboomina Bug 7168534 - end
2319: --end: | 02-APR-07 cklee R12 Billing enhancement project |
2320:

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

2352: p_contract_number => p_contract_number);
2353: END IF;
2354:
2355:
2356: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2357: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
2358: p_msg_name => 'OKL_BPD_RTA_REC_ERR',
2359: p_token1 => 'TABLE',
2360: p_token1_value => 'AR BATCH SOURCE');

Line 2357: OKL_API.SET_MESSAGE(p_app_name => 'OKL',

2353: END IF;
2354:
2355:
2356: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2357: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
2358: p_msg_name => 'OKL_BPD_RTA_REC_ERR',
2359: p_token1 => 'TABLE',
2360: p_token1_value => 'AR BATCH SOURCE');
2361: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 2361: RAISE OKL_API.G_EXCEPTION_ERROR;

2357: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
2358: p_msg_name => 'OKL_BPD_RTA_REC_ERR',
2359: p_token1 => 'TABLE',
2360: p_token1_value => 'AR BATCH SOURCE');
2361: RAISE OKL_API.G_EXCEPTION_ERROR;
2362: END IF;
2363:
2364: -- ----------------------------------------------
2365: -- Contract Specific Consolidation

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

2370: x_return_status => x_return_status,
2371: x_msg_count => x_msg_count,
2372: x_msg_data => x_msg_data);
2373:
2374: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2375: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
2376: p_msg_name => 'OKL_BPD_RTA_REC_ERR',
2377: p_token1 => 'TABLE',
2378: p_token1_value => 'AR BATCH SOURCE');

Line 2375: OKL_API.SET_MESSAGE(p_app_name => 'OKL',

2371: x_msg_count => x_msg_count,
2372: x_msg_data => x_msg_data);
2373:
2374: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2375: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
2376: p_msg_name => 'OKL_BPD_RTA_REC_ERR',
2377: p_token1 => 'TABLE',
2378: p_token1_value => 'AR BATCH SOURCE');
2379: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 2379: RAISE OKL_API.G_EXCEPTION_ERROR;

2375: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
2376: p_msg_name => 'OKL_BPD_RTA_REC_ERR',
2377: p_token1 => 'TABLE',
2378: p_token1_value => 'AR BATCH SOURCE');
2379: RAISE OKL_API.G_EXCEPTION_ERROR;
2380: END IF;
2381: */
2382: --end: | 02-APR-07 cklee R12 Billing enhancement project |
2383:

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

2484: --end: | 02-APR-07 cklee R12 Billing enhancement project |
2485: ,l_batch_source_rec );
2486: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Done Preparing Batch rec '||l_num_cnt);
2487:
2488: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2489: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
2490: p_msg_name => 'OKL_BPD_RTA_REC_ERR',
2491: p_token1 => 'TABLE',
2492: p_token1_value => 'AR BATCH SOURCE'

Line 2489: OKL_API.SET_MESSAGE(p_app_name => 'OKL',

2485: ,l_batch_source_rec );
2486: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Done Preparing Batch rec '||l_num_cnt);
2487:
2488: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2489: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
2490: p_msg_name => 'OKL_BPD_RTA_REC_ERR',
2491: p_token1 => 'TABLE',
2492: p_token1_value => 'AR BATCH SOURCE'
2493: );

Line 2494: RAISE OKL_API.G_EXCEPTION_ERROR;

2490: p_msg_name => 'OKL_BPD_RTA_REC_ERR',
2491: p_token1 => 'TABLE',
2492: p_token1_value => 'AR BATCH SOURCE'
2493: );
2494: RAISE OKL_API.G_EXCEPTION_ERROR;
2495: END IF;
2496:
2497: ---------------------------------------
2498: -- Prepare trx hdr tbl

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

2639:
2640: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Done Preparing Trx Hdr tbl '||l_num_cnt);
2641:
2642:
2643: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2644: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
2645: p_msg_name => 'OKL_BPD_RTA_REC_ERR',
2646: p_token1 => 'TABLE',
2647: p_token1_value => 'AR Transaction Header Table '

Line 2644: OKL_API.SET_MESSAGE(p_app_name => 'OKL',

2640: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Done Preparing Trx Hdr tbl '||l_num_cnt);
2641:
2642:
2643: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2644: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
2645: p_msg_name => 'OKL_BPD_RTA_REC_ERR',
2646: p_token1 => 'TABLE',
2647: p_token1_value => 'AR Transaction Header Table '
2648: );

Line 2649: RAISE OKL_API.G_EXCEPTION_ERROR;

2645: p_msg_name => 'OKL_BPD_RTA_REC_ERR',
2646: p_token1 => 'TABLE',
2647: p_token1_value => 'AR Transaction Header Table '
2648: );
2649: RAISE OKL_API.G_EXCEPTION_ERROR;
2650: END IF;
2651:
2652: ---------------------------------------
2653: -- Prepare trx lines tbl

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

2665: --end: | 02-APR-07 cklee R12 Billing enhancement project |
2666: ,l_trx_lines_tbl );
2667: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Done Preparing Trx Lines tbl '||l_num_cnt);
2668:
2669: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2670: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
2671: p_msg_name => 'OKL_BPD_RTA_REC_ERR',
2672: p_token1 => 'TABLE',
2673: p_token1_value => 'AR Transaction Lines Table '

Line 2670: OKL_API.SET_MESSAGE(p_app_name => 'OKL',

2666: ,l_trx_lines_tbl );
2667: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Done Preparing Trx Lines tbl '||l_num_cnt);
2668:
2669: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2670: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
2671: p_msg_name => 'OKL_BPD_RTA_REC_ERR',
2672: p_token1 => 'TABLE',
2673: p_token1_value => 'AR Transaction Lines Table '
2674: );

Line 2675: RAISE OKL_API.G_EXCEPTION_ERROR;

2671: p_msg_name => 'OKL_BPD_RTA_REC_ERR',
2672: p_token1 => 'TABLE',
2673: p_token1_value => 'AR Transaction Lines Table '
2674: );
2675: RAISE OKL_API.G_EXCEPTION_ERROR;
2676: END IF;
2677:
2678: --start: | 02-APR-07 cklee R12 Billing enhancement project |
2679: /* commented out for R12

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

2749: --end: | 02-APR-07 cklee R12 Billing enhancement project |
2750: ,l_trx_dist_tbl );
2751: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Done Preparing trx dist tbl '||l_num_cnt);
2752:
2753: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2754: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
2755: p_msg_name => 'OKL_BPD_RTA_REC_ERR',
2756: p_token1 => 'TABLE',
2757: p_token1_value => 'AR Transaction Distributions Table '

Line 2754: OKL_API.SET_MESSAGE(p_app_name => 'OKL',

2750: ,l_trx_dist_tbl );
2751: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Done Preparing trx dist tbl '||l_num_cnt);
2752:
2753: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2754: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
2755: p_msg_name => 'OKL_BPD_RTA_REC_ERR',
2756: p_token1 => 'TABLE',
2757: p_token1_value => 'AR Transaction Distributions Table '
2758: );

Line 2759: RAISE OKL_API.G_EXCEPTION_ERROR;

2755: p_msg_name => 'OKL_BPD_RTA_REC_ERR',
2756: p_token1 => 'TABLE',
2757: p_token1_value => 'AR Transaction Distributions Table '
2758: );
2759: RAISE OKL_API.G_EXCEPTION_ERROR;
2760: END IF;
2761:
2762: l_trx_salescredits_tbl := l_init_trx_salescredits_tbl;
2763:

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

2985: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error_message: '||err_rec.error_message);
2986: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Invalid_value: '||err_rec.Invalid_value);
2987: END LOOP;
2988:
2989: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2990: x_msg_count := l_msg_count;
2991: x_msg_data := l_msg_data;
2992: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
2993: p_msg_name => 'OKL_BPD_RTA_TXN_ERR1',

Line 2992: OKL_API.SET_MESSAGE(p_app_name => 'OKL',

2988:
2989: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2990: x_msg_count := l_msg_count;
2991: x_msg_data := l_msg_data;
2992: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
2993: p_msg_name => 'OKL_BPD_RTA_TXN_ERR1',
2994: p_token1 => 'TXN',
2995: p_token1_value => 'Receivables Invoice'
2996: );

Line 3008: OKL_API.SET_MESSAGE(p_app_name => 'OKL',

3004: IF l_cnt > 0 THEN
3005: l_err_cnt := 0;
3006: FOR ar_trx_rec IN ar_trx_errs_csr( 110 ) LOOP
3007: l_err_cnt := l_err_cnt + 1;
3008: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
3009: p_msg_name => 'OKL_BPD_RTA_GEN_ERR1',
3010: p_token1 => 'NUM',
3011: p_token1_value => to_char(l_err_cnt),
3012: p_token2 => 'MESSAGE',

Line 3114: Okl_Api.END_ACTIVITY (

3110:
3111: ------------------------------------------------------------
3112: -- End processing
3113: ------------------------------------------------------------
3114: Okl_Api.END_ACTIVITY (
3115: x_msg_count => x_msg_count,
3116: x_msg_data => x_msg_data);
3117:
3118:

Line 3131: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

3127: ------------------------------------------------------------
3128: -- Exception handling
3129: ------------------------------------------------------------
3130:
3131: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
3132: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
3133: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3134: p_api_name => l_api_name,
3135: p_pkg_name => G_PKG_NAME,

Line 3133: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

3129: ------------------------------------------------------------
3130:
3131: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
3132: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
3133: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3134: p_api_name => l_api_name,
3135: p_pkg_name => G_PKG_NAME,
3136: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
3137: x_msg_count => x_msg_count,

Line 3136: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',

3132: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
3133: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3134: p_api_name => l_api_name,
3135: p_pkg_name => G_PKG_NAME,
3136: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
3137: x_msg_count => x_msg_count,
3138: x_msg_data => x_msg_data,
3139: p_api_type => '_PVT');
3140:

Line 3141: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

3137: x_msg_count => x_msg_count,
3138: x_msg_data => x_msg_data,
3139: p_api_type => '_PVT');
3140:
3141: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3142: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
3143: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3144: p_api_name => l_api_name,
3145: p_pkg_name => G_PKG_NAME,

Line 3143: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

3139: p_api_type => '_PVT');
3140:
3141: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3142: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
3143: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3144: p_api_name => l_api_name,
3145: p_pkg_name => G_PKG_NAME,
3146: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
3147: x_msg_count => x_msg_count,

Line 3146: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',

3142: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
3143: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3144: p_api_name => l_api_name,
3145: p_pkg_name => G_PKG_NAME,
3146: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
3147: x_msg_count => x_msg_count,
3148: x_msg_data => x_msg_data,
3149: p_api_type => '_PVT');
3150: WHEN AR_API_CALL_EXCP THEN

Line 3152: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

3148: x_msg_data => x_msg_data,
3149: p_api_type => '_PVT');
3150: WHEN AR_API_CALL_EXCP THEN
3151: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (AR_API_CALL_EXCP) => '||SQLERRM);
3152: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3153: p_api_name => 'AR_INVOICE_API',
3154: p_pkg_name => G_PKG_NAME,
3155: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
3156: x_msg_count => x_msg_count,

Line 3155: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',

3151: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (AR_API_CALL_EXCP) => '||SQLERRM);
3152: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3153: p_api_name => 'AR_INVOICE_API',
3154: p_pkg_name => G_PKG_NAME,
3155: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
3156: x_msg_count => x_msg_count,
3157: x_msg_data => x_msg_data,
3158: p_api_type => '_PVT');
3159:

Line 3162: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

3158: p_api_type => '_PVT');
3159:
3160: WHEN OTHERS THEN
3161: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (OTHERS) => '||SQLERRM);
3162: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3163: p_api_name => l_api_name,
3164: p_pkg_name => G_PKG_NAME,
3165: p_exc_name => 'OTHERS',
3166: x_msg_count => x_msg_count,