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: -- Start of comments
24: --

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

41: ,x_receipt_method_id OUT NOCOPY NUMBER
42: ,x_payment_trxn_extension_id OUT NOCOPY NUMBER --Bug 7623549
43: )
44: IS
45: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
46: lx_remrkt_sty_id number;
47:
48: BEGIN
49:

Line 62: IF l_return_status = Okl_Api.g_ret_sts_success THEN

58: 'ASSET_SALE_RECEIVABLE',
59: l_return_status,
60: lx_remrkt_sty_id);
61:
62: IF l_return_status = Okl_Api.g_ret_sts_success THEN
63:
64: IF(lx_remrkt_sty_id = p_sty_id) THEN
65:
66: x_customer_bank_account_id := NULL;

Line 362: x_return_status := OKL_API.G_RET_STS_SUCCESS;

358: AND ORG_ID = MO_GLOBAL.get_current_org_id();
359: --gkhuntet end.
360: BEGIN
361:
362: x_return_status := OKL_API.G_RET_STS_SUCCESS;
363: -------------------------------------------
364: -- Fetch Batch Source Id for OKL_CONTRACTS
365: -------------------------------------------
366: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Fetching Batch Source');

Line 376: RAISE Okl_Api.G_EXCEPTION_ERROR;

372: FETCH batch_src_csr INTO l_batch_source_rec.batch_source_id;
373: IF (batch_src_csr%NOTFOUND) THEN
374: CLOSE batch_src_csr;
375: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error: Unable to retrieve Batch Source');
376: RAISE Okl_Api.G_EXCEPTION_ERROR;
377: END IF;
378: CLOSE batch_src_csr;
379: l_batch_source_rec.default_date := p_trx_date;
380:

Line 386: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

382: ||' l_batch_source_rec.default_date: '||l_batch_source_rec.default_date);
383:
384: EXCEPTION
385: WHEN OTHERS THEN
386: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
387: END PREPARE_BATCH_SOURCE_REC;
388:
389:
390: --------------------------------------------

Line 414: l_init_msg_list VARCHAR2(1):= OKL_API.G_FALSE;

410: --l_api_version NUMBER := '1.0';
411: l_api_version NUMBER := 1.0;
412: --11-MAY-10 sechawla 9692959
413:
414: l_init_msg_list VARCHAR2(1):= OKL_API.G_FALSE;
415: l_khr_id NUMBER;
416: l_return_status VARCHAR2(100);
417: l_msg_count NUMBER;
418: l_msg_data VARCHAR2(2000);

Line 571: x_return_status := OKL_API.G_RET_STS_SUCCESS;

567: BEGIN
568: -- Assign IN record to local record
569: lxfer_rec := xfer_rec;
570:
571: x_return_status := OKL_API.G_RET_STS_SUCCESS;
572:
573: --start: 02-APR-07 cklee R12 Billing enhancement project |
574: --start:| 06-Apr-2007 cklee -- Fixed kle_id, asset_number issues |
575: -- 1. Check if it's a top line

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

780: x_msg_count => l_msg_count,
781: x_msg_data => l_msg_data
782: );
783:
784: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
786: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
787: RAISE FND_API.G_EXC_ERROR;
788: END IF;

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

782: );
783:
784: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
786: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
787: RAISE FND_API.G_EXC_ERROR;
788: END IF;
789: -- For Automatic receipt method, bank account id should be NULL as the column is obsoleted
790: l_trx_header_tbl(1).customer_bank_account_id := NULL;

Line 889: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

885:
886:
887: EXCEPTION
888: WHEN OTHERS THEN
889: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
890: END PREPARE_TRX_HDR_TBL;
891:
892: --------------------------------------------
893: -- Prepare Transaction Lines Table

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

911: x_tax_det_rec OKL_PROCESS_SALES_TAX_PVT.tax_det_rec_type;
912: l_api_version NUMBER := 1.0;
913: x_msg_count NUMBER;
914: x_msg_data VARCHAR2(4000);
915: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;
916:
917: l_ship_to NUMBER;
918: l_kle_id NUMBER;
919: l_top_kle_id NUMBER;

Line 1107: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1103:
1104: -- Assign to local record
1105: lxfer_rec := xfer_rec;
1106:
1107: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1108:
1109: --start: 02-APR-07 cklee R12 Billing enhancement project |
1110: -- Migrated logic from okl_arintf_pvt
1111: -- get memo line id for tax only invoices

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

1426: p_source_table => 'OKL_TXD_AR_LN_DTLS_B',
1427: x_tax_det_rec => x_tax_det_rec);
1428:
1429:
1430: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1431: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1432: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1433: RAISE OKL_API.G_EXCEPTION_ERROR;
1434: END IF;

Line 1431: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1427: x_tax_det_rec => x_tax_det_rec);
1428:
1429:
1430: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1431: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1432: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1433: RAISE OKL_API.G_EXCEPTION_ERROR;
1434: END IF;
1435:

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

1428:
1429:
1430: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1431: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1432: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1433: RAISE OKL_API.G_EXCEPTION_ERROR;
1434: END IF;
1435:
1436: -- l_trx_lines_tbl(1).TAX_CODE := x_tax_det_rec.x_TAX_CODE;

Line 1433: RAISE OKL_API.G_EXCEPTION_ERROR;

1429:
1430: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1431: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1432: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1433: RAISE OKL_API.G_EXCEPTION_ERROR;
1434: END IF;
1435:
1436: -- l_trx_lines_tbl(1).TAX_CODE := x_tax_det_rec.x_TAX_CODE;
1437: /* inv_lines_tbl(hdr_cnt).TRX_BUSINESS_CATEGORY := x_tax_det_rec.x_TRX_BUSINESS_CATEGORY; */

Line 1503: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1499: l_trx_lines_tbl(1).SHIP_DATE_ACTUAL := NULL;
1500:
1501: EXCEPTION
1502: WHEN OTHERS THEN
1503: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1504: END PREPARE_TRX_LNS_TBL;
1505:
1506:
1507: --------------------------------------------

Line 1536: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1532:
1533: -- Assign IN to local record
1534: lxfer_rec := xfer_rec;
1535:
1536: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1537:
1538: i := 0;
1539: --start: | 02-APR-07 cklee R12 Billing enhancement project |
1540: /* commented out for R12

Line 1610: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1606: --end: | 02-APR-07 cklee R12 Billing enhancement project |
1607:
1608: EXCEPTION
1609: WHEN OTHERS THEN
1610: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1611: END PREPARE_TRX_DIST_TBL;
1612:
1613: ------------------------------------------------------------------
1614: -- Procedure ADVANCED_BILLING to bill outstanding stream elements

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

1631: -- Declare variables required by APIs
1632: -- ---------------------------------------------------------
1633: l_api_version CONSTANT NUMBER := 1;
1634: l_api_name CONSTANT VARCHAR2(30) := 'ADVANCED_BILLING';
1635: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1636:
1637: --start: | 02-APR-07 cklee R12 Billing enhancement project
1638:
1639: --gkhuntet - FP Bug 5516814..start

Line 2082: l_overall_err_sts := Okl_Api.G_RET_STS_SUCCESS;

2078:
2079: ------------------------------------------------------------
2080: -- Start processing
2081: ------------------------------------------------------------
2082: l_overall_err_sts := Okl_Api.G_RET_STS_SUCCESS;
2083:
2084: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2085:
2086: l_return_status := Okl_Api.START_ACTIVITY(

Line 2084: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

2080: -- Start processing
2081: ------------------------------------------------------------
2082: l_overall_err_sts := Okl_Api.G_RET_STS_SUCCESS;
2083:
2084: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2085:
2086: l_return_status := Okl_Api.START_ACTIVITY(
2087: p_api_name => l_api_name,
2088: p_pkg_name => G_PKG_NAME,

Line 2086: l_return_status := Okl_Api.START_ACTIVITY(

2082: l_overall_err_sts := Okl_Api.G_RET_STS_SUCCESS;
2083:
2084: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2085:
2086: l_return_status := Okl_Api.START_ACTIVITY(
2087: p_api_name => l_api_name,
2088: p_pkg_name => G_PKG_NAME,
2089: p_init_msg_list => p_init_msg_list,
2090: l_api_version => l_api_version,

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

2091: p_api_version => p_api_version,
2092: p_api_type => '_PVT',
2093: x_return_status => l_return_status);
2094:
2095: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2096: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2097: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2098: RAISE Okl_Api.G_EXCEPTION_ERROR;
2099: END IF;

Line 2096: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2092: p_api_type => '_PVT',
2093: x_return_status => l_return_status);
2094:
2095: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2096: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2097: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2098: RAISE Okl_Api.G_EXCEPTION_ERROR;
2099: END IF;
2100: --gkhuntet FP Bug 5516814 start

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

2093: x_return_status => l_return_status);
2094:
2095: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2096: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2097: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2098: RAISE Okl_Api.G_EXCEPTION_ERROR;
2099: END IF;
2100: --gkhuntet FP Bug 5516814 start
2101: FOR c_get_adv_rcpt_for_cont_rec IN c_get_adv_rcpt_for_cont (p_contract_number)

Line 2098: RAISE Okl_Api.G_EXCEPTION_ERROR;

2094:
2095: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2096: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2097: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2098: RAISE Okl_Api.G_EXCEPTION_ERROR;
2099: END IF;
2100: --gkhuntet FP Bug 5516814 start
2101: FOR c_get_adv_rcpt_for_cont_rec IN c_get_adv_rcpt_for_cont (p_contract_number)
2102: LOOP

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

2110: --start: | 02-APR-07 cklee R12 Billing enhancement project |
2111: -- Verify if contract number is passed in
2112: -- gboomina Bug 7168534 - start
2113: -- passing correct variable for contract number
2114: IF (l_contract_number is null or l_contract_number = okl_api.g_miss_char ) THEN -- rmunjulu R12 Fixes
2115: OKL_API.Set_Message(p_app_name => G_APP_NAME,
2116: p_msg_name => G_REQUIRED_VALUE,
2117: p_token1 => G_COL_NAME_TOKEN,
2118: p_token1_value => 'OKL_BPD_ADVANCED_BILLING_PVT.ADVANCED_BILLING.p_contract_number');

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

2111: -- Verify if contract number is passed in
2112: -- gboomina Bug 7168534 - start
2113: -- passing correct variable for contract number
2114: IF (l_contract_number is null or l_contract_number = okl_api.g_miss_char ) THEN -- rmunjulu R12 Fixes
2115: OKL_API.Set_Message(p_app_name => G_APP_NAME,
2116: p_msg_name => G_REQUIRED_VALUE,
2117: p_token1 => G_COL_NAME_TOKEN,
2118: p_token1_value => 'OKL_BPD_ADVANCED_BILLING_PVT.ADVANCED_BILLING.p_contract_number');
2119:

Line 2120: RAISE OKL_API.G_EXCEPTION_ERROR;

2116: p_msg_name => G_REQUIRED_VALUE,
2117: p_token1 => G_COL_NAME_TOKEN,
2118: p_token1_value => 'OKL_BPD_ADVANCED_BILLING_PVT.ADVANCED_BILLING.p_contract_number');
2119:
2120: RAISE OKL_API.G_EXCEPTION_ERROR;
2121: END IF;
2122: -- gboomina Bug 7168534 - end
2123: --end: | 02-APR-07 cklee R12 Billing enhancement project |
2124:

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

2206: p_contract_number => p_contract_number);
2207: END IF;
2208:
2209:
2210: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2211: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
2212: p_msg_name => 'OKL_BPD_RTA_REC_ERR',
2213: p_token1 => 'TABLE',
2214: p_token1_value => 'AR BATCH SOURCE');

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

2207: END IF;
2208:
2209:
2210: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2211: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
2212: p_msg_name => 'OKL_BPD_RTA_REC_ERR',
2213: p_token1 => 'TABLE',
2214: p_token1_value => 'AR BATCH SOURCE');
2215: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 2215: RAISE OKL_API.G_EXCEPTION_ERROR;

2211: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
2212: p_msg_name => 'OKL_BPD_RTA_REC_ERR',
2213: p_token1 => 'TABLE',
2214: p_token1_value => 'AR BATCH SOURCE');
2215: RAISE OKL_API.G_EXCEPTION_ERROR;
2216: END IF;
2217:
2218: -- ----------------------------------------------
2219: -- Contract Specific Consolidation

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

2224: x_return_status => x_return_status,
2225: x_msg_count => x_msg_count,
2226: x_msg_data => x_msg_data);
2227:
2228: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2229: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
2230: p_msg_name => 'OKL_BPD_RTA_REC_ERR',
2231: p_token1 => 'TABLE',
2232: p_token1_value => 'AR BATCH SOURCE');

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

2225: x_msg_count => x_msg_count,
2226: x_msg_data => x_msg_data);
2227:
2228: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2229: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
2230: p_msg_name => 'OKL_BPD_RTA_REC_ERR',
2231: p_token1 => 'TABLE',
2232: p_token1_value => 'AR BATCH SOURCE');
2233: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 2233: RAISE OKL_API.G_EXCEPTION_ERROR;

2229: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
2230: p_msg_name => 'OKL_BPD_RTA_REC_ERR',
2231: p_token1 => 'TABLE',
2232: p_token1_value => 'AR BATCH SOURCE');
2233: RAISE OKL_API.G_EXCEPTION_ERROR;
2234: END IF;
2235: */
2236: --end: | 02-APR-07 cklee R12 Billing enhancement project |
2237:

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

2338: --end: | 02-APR-07 cklee R12 Billing enhancement project |
2339: ,l_batch_source_rec );
2340: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Done Preparing Batch rec '||l_num_cnt);
2341:
2342: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2343: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
2344: p_msg_name => 'OKL_BPD_RTA_REC_ERR',
2345: p_token1 => 'TABLE',
2346: p_token1_value => 'AR BATCH SOURCE'

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

2339: ,l_batch_source_rec );
2340: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Done Preparing Batch rec '||l_num_cnt);
2341:
2342: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2343: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
2344: p_msg_name => 'OKL_BPD_RTA_REC_ERR',
2345: p_token1 => 'TABLE',
2346: p_token1_value => 'AR BATCH SOURCE'
2347: );

Line 2348: RAISE OKL_API.G_EXCEPTION_ERROR;

2344: p_msg_name => 'OKL_BPD_RTA_REC_ERR',
2345: p_token1 => 'TABLE',
2346: p_token1_value => 'AR BATCH SOURCE'
2347: );
2348: RAISE OKL_API.G_EXCEPTION_ERROR;
2349: END IF;
2350:
2351: ---------------------------------------
2352: -- Prepare trx hdr tbl

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

2493:
2494: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Done Preparing Trx Hdr tbl '||l_num_cnt);
2495:
2496:
2497: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2498: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
2499: p_msg_name => 'OKL_BPD_RTA_REC_ERR',
2500: p_token1 => 'TABLE',
2501: p_token1_value => 'AR Transaction Header Table '

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

2494: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Done Preparing Trx Hdr tbl '||l_num_cnt);
2495:
2496:
2497: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2498: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
2499: p_msg_name => 'OKL_BPD_RTA_REC_ERR',
2500: p_token1 => 'TABLE',
2501: p_token1_value => 'AR Transaction Header Table '
2502: );

Line 2503: RAISE OKL_API.G_EXCEPTION_ERROR;

2499: p_msg_name => 'OKL_BPD_RTA_REC_ERR',
2500: p_token1 => 'TABLE',
2501: p_token1_value => 'AR Transaction Header Table '
2502: );
2503: RAISE OKL_API.G_EXCEPTION_ERROR;
2504: END IF;
2505:
2506: ---------------------------------------
2507: -- Prepare trx lines tbl

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

2519: --end: | 02-APR-07 cklee R12 Billing enhancement project |
2520: ,l_trx_lines_tbl );
2521: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Done Preparing Trx Lines tbl '||l_num_cnt);
2522:
2523: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2524: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
2525: p_msg_name => 'OKL_BPD_RTA_REC_ERR',
2526: p_token1 => 'TABLE',
2527: p_token1_value => 'AR Transaction Lines Table '

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

2520: ,l_trx_lines_tbl );
2521: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Done Preparing Trx Lines tbl '||l_num_cnt);
2522:
2523: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2524: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
2525: p_msg_name => 'OKL_BPD_RTA_REC_ERR',
2526: p_token1 => 'TABLE',
2527: p_token1_value => 'AR Transaction Lines Table '
2528: );

Line 2529: RAISE OKL_API.G_EXCEPTION_ERROR;

2525: p_msg_name => 'OKL_BPD_RTA_REC_ERR',
2526: p_token1 => 'TABLE',
2527: p_token1_value => 'AR Transaction Lines Table '
2528: );
2529: RAISE OKL_API.G_EXCEPTION_ERROR;
2530: END IF;
2531:
2532: --start: | 02-APR-07 cklee R12 Billing enhancement project |
2533: /* commented out for R12

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

2603: --end: | 02-APR-07 cklee R12 Billing enhancement project |
2604: ,l_trx_dist_tbl );
2605: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Done Preparing trx dist tbl '||l_num_cnt);
2606:
2607: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2608: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
2609: p_msg_name => 'OKL_BPD_RTA_REC_ERR',
2610: p_token1 => 'TABLE',
2611: p_token1_value => 'AR Transaction Distributions Table '

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

2604: ,l_trx_dist_tbl );
2605: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Done Preparing trx dist tbl '||l_num_cnt);
2606:
2607: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2608: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
2609: p_msg_name => 'OKL_BPD_RTA_REC_ERR',
2610: p_token1 => 'TABLE',
2611: p_token1_value => 'AR Transaction Distributions Table '
2612: );

Line 2613: RAISE OKL_API.G_EXCEPTION_ERROR;

2609: p_msg_name => 'OKL_BPD_RTA_REC_ERR',
2610: p_token1 => 'TABLE',
2611: p_token1_value => 'AR Transaction Distributions Table '
2612: );
2613: RAISE OKL_API.G_EXCEPTION_ERROR;
2614: END IF;
2615:
2616: l_trx_salescredits_tbl := l_init_trx_salescredits_tbl;
2617:

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

2839: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error_message: '||err_rec.error_message);
2840: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Invalid_value: '||err_rec.Invalid_value);
2841: END LOOP;
2842:
2843: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2844: x_msg_count := l_msg_count;
2845: x_msg_data := l_msg_data;
2846: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
2847: p_msg_name => 'OKL_BPD_RTA_TXN_ERR1',

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

2842:
2843: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2844: x_msg_count := l_msg_count;
2845: x_msg_data := l_msg_data;
2846: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
2847: p_msg_name => 'OKL_BPD_RTA_TXN_ERR1',
2848: p_token1 => 'TXN',
2849: p_token1_value => 'Receivables Invoice'
2850: );

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

2858: IF l_cnt > 0 THEN
2859: l_err_cnt := 0;
2860: FOR ar_trx_rec IN ar_trx_errs_csr( 110 ) LOOP
2861: l_err_cnt := l_err_cnt + 1;
2862: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
2863: p_msg_name => 'OKL_BPD_RTA_GEN_ERR1',
2864: p_token1 => 'NUM',
2865: p_token1_value => to_char(l_err_cnt),
2866: p_token2 => 'MESSAGE',

Line 2968: Okl_Api.END_ACTIVITY (

2964:
2965: ------------------------------------------------------------
2966: -- End processing
2967: ------------------------------------------------------------
2968: Okl_Api.END_ACTIVITY (
2969: x_msg_count => x_msg_count,
2970: x_msg_data => x_msg_data);
2971:
2972: END; -- END is added as part of Bug# 14119181

Line 2986: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

2982: ------------------------------------------------------------
2983: -- Exception handling
2984: ------------------------------------------------------------
2985:
2986: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2987: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
2988: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2989: p_api_name => l_api_name,
2990: p_pkg_name => G_PKG_NAME,

Line 2988: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

2984: ------------------------------------------------------------
2985:
2986: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2987: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
2988: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2989: p_api_name => l_api_name,
2990: p_pkg_name => G_PKG_NAME,
2991: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
2992: x_msg_count => x_msg_count,

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

2987: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
2988: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2989: p_api_name => l_api_name,
2990: p_pkg_name => G_PKG_NAME,
2991: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
2992: x_msg_count => x_msg_count,
2993: x_msg_data => x_msg_data,
2994: p_api_type => '_PVT');
2995:

Line 2996: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2992: x_msg_count => x_msg_count,
2993: x_msg_data => x_msg_data,
2994: p_api_type => '_PVT');
2995:
2996: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2997: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
2998: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2999: p_api_name => l_api_name,
3000: p_pkg_name => G_PKG_NAME,

Line 2998: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

2994: p_api_type => '_PVT');
2995:
2996: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2997: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
2998: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2999: p_api_name => l_api_name,
3000: p_pkg_name => G_PKG_NAME,
3001: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
3002: x_msg_count => x_msg_count,

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

2997: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
2998: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2999: p_api_name => l_api_name,
3000: p_pkg_name => G_PKG_NAME,
3001: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
3002: x_msg_count => x_msg_count,
3003: x_msg_data => x_msg_data,
3004: p_api_type => '_PVT');
3005: WHEN AR_API_CALL_EXCP THEN

Line 3007: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

3003: x_msg_data => x_msg_data,
3004: p_api_type => '_PVT');
3005: WHEN AR_API_CALL_EXCP THEN
3006: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (AR_API_CALL_EXCP) => '||SQLERRM);
3007: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3008: p_api_name => 'AR_INVOICE_API',
3009: p_pkg_name => G_PKG_NAME,
3010: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
3011: x_msg_count => x_msg_count,

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

3006: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (AR_API_CALL_EXCP) => '||SQLERRM);
3007: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3008: p_api_name => 'AR_INVOICE_API',
3009: p_pkg_name => G_PKG_NAME,
3010: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
3011: x_msg_count => x_msg_count,
3012: x_msg_data => x_msg_data,
3013: p_api_type => '_PVT');
3014:

Line 3017: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

3013: p_api_type => '_PVT');
3014:
3015: WHEN OTHERS THEN
3016: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (OTHERS) => '||SQLERRM);
3017: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3018: p_api_name => l_api_name,
3019: p_pkg_name => G_PKG_NAME,
3020: p_exc_name => 'OTHERS',
3021: x_msg_count => x_msg_count,