[Home] [Help]
39: |
40: *=======================================================================*/
41: PROCEDURE get_ship_to_site_use_id(
42: p_api_version IN NUMBER,
43: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
44: x_return_status OUT NOCOPY VARCHAR2,
45: x_msg_count OUT NOCOPY NUMBER,
46: x_msg_data OUT NOCOPY VARCHAR2,
47: p_cust_acct_id IN NUMBER,
2585: |
2586: *=======================================================================*/
2587: PROCEDURE process_contract_reversal_tax(
2588: p_api_version IN NUMBER,
2589: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2590: x_return_status OUT NOCOPY VARCHAR2,
2591: x_msg_count OUT NOCOPY NUMBER,
2592: x_msg_data OUT NOCOPY VARCHAR2,
2593: p_source_trx_id IN NUMBER,
2682: OPEN l_trxcontracts_csr(p_source_trx_id, p_source_trx_name);
2683: FETCH l_trxcontracts_csr INTO l_rev_trx_type_id, l_khr_id, l_legal_entity_id, l_trx_date;
2684: IF l_trxcontracts_csr%NOTFOUND THEN
2685: -- source trx id is invalid
2686: OKC_API.set_message( p_app_name => 'OKC',
2687: p_msg_name => G_INVALID_VALUE,
2688: p_token1 => G_COL_NAME_TOKEN,
2689: p_token1_value => 'SOURCE_TRX_ID');
2690: RAISE OKL_API.G_EXCEPTION_ERROR;
3186: END IF;
3187: IF (p_fin_asset_id IS NOT NULL) THEN
3188: get_ship_to_site_use_id(
3189: p_api_version => p_api_version,
3190: p_init_msg_list => OKC_API.G_FALSE,
3191: x_return_status => x_return_status,
3192: x_msg_count => x_msg_count,
3193: x_msg_data => x_msg_data,
3194: p_cust_acct_id => p_cust_acct_id,
3359: |
3360: *=======================================================================*/
3361: PROCEDURE get_tbc_code(
3362: p_api_version IN NUMBER,
3363: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3364: x_return_status OUT NOCOPY VARCHAR2,
3365: x_msg_count OUT NOCOPY NUMBER,
3366: x_msg_data OUT NOCOPY VARCHAR2,
3367: p_try_id IN NUMBER,
3830: |
3831: *=======================================================================*/
3832: PROCEDURE get_pc_code(
3833: p_api_version IN NUMBER,
3834: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3835: x_return_status OUT NOCOPY VARCHAR2,
3836: x_msg_count OUT NOCOPY NUMBER,
3837: x_msg_data OUT NOCOPY VARCHAR2,
3838: p_sty_id IN NUMBER,
4460: *=======================================================================*/
4461:
4462: PROCEDURE get_ufc_code(
4463: p_api_version IN NUMBER,
4464: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4465: x_return_status OUT NOCOPY VARCHAR2,
4466: x_msg_count OUT NOCOPY NUMBER,
4467: x_msg_data OUT NOCOPY VARCHAR2,
4468: p_purchase_option IN VARCHAR2,
5561: *=======================================================================*/
5562:
5563: PROCEDURE populate_tax_info(
5564: p_api_version IN NUMBER,
5565: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
5566: x_return_status OUT NOCOPY VARCHAR2,
5567: x_msg_count OUT NOCOPY NUMBER,
5568: x_msg_data OUT NOCOPY VARCHAR2,
5569: p_prch_opt_det IN VARCHAR2,
5699: -- the Serialized/Non-Serialized asset. It will be processed as needed for
5700: -- other transactions
5701: -- Get TBC code
5702: get_tbc_code(p_api_version => p_api_version,
5703: p_init_msg_list => OKC_API.G_FALSE,
5704: x_return_status => x_return_status,
5705: x_msg_count => x_msg_count,
5706: x_msg_data => x_msg_data,
5707: p_sty_id => p_tax_src_params_rec.sty_id, -- used if pymnts exist
5756: END IF;
5757:
5758: -- Get PC code
5759: get_pc_code(p_api_version => p_api_version,
5760: p_init_msg_list => OKC_API.G_FALSE,
5761: x_return_status => x_return_status,
5762: x_msg_count => x_msg_count,
5763: x_msg_data => x_msg_data,
5764: p_sty_id => p_tax_src_params_rec.sty_id, -- used if pymnts exist
5812:
5813: -- contract level call begin
5814: -- Get UFC code
5815: get_ufc_code(p_api_version => p_api_version,
5816: p_init_msg_list => OKC_API.G_FALSE,
5817: x_return_status => x_return_status,
5818: x_msg_count => x_msg_count,
5819: x_msg_data => x_msg_data,
5820: p_purchase_option => p_prch_opt_det,
6357: | 22-AUG-07 RRAVIKIR Created
6358: *=======================================================================*/
6359: PROCEDURE populate_tax_codes(
6360: p_api_version IN NUMBER,
6361: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
6362: x_return_status OUT NOCOPY VARCHAR2,
6363: x_msg_count OUT NOCOPY NUMBER,
6364: x_msg_data OUT NOCOPY VARCHAR2,
6365: p_prch_opt_det IN VARCHAR2,
6437: END IF;
6438:
6439: -- Get TBC code
6440: get_tbc_code(p_api_version => p_api_version,
6441: p_init_msg_list => OKC_API.G_FALSE,
6442: x_return_status => x_return_status,
6443: x_msg_count => x_msg_count,
6444: x_msg_data => x_msg_data,
6445: p_sty_id => p_sty_id, -- used if pymnts exist
6484: END IF;
6485:
6486: -- Get PC code
6487: get_pc_code(p_api_version => p_api_version,
6488: p_init_msg_list => OKC_API.G_FALSE,
6489: x_return_status => x_return_status,
6490: x_msg_count => x_msg_count,
6491: x_msg_data => x_msg_data,
6492: p_sty_id => p_sty_id,
6533: END IF;
6534:
6535: -- Get UFC code
6536: get_ufc_code(p_api_version => p_api_version,
6537: p_init_msg_list => OKC_API.G_FALSE,
6538: x_return_status => x_return_status,
6539: x_msg_count => x_msg_count,
6540: x_msg_data => x_msg_data,
6541: p_purchase_option => p_prch_opt_det,
6717:
6718:
6719: PROCEDURE get_billing_stream_types(
6720: p_api_version IN NUMBER,
6721: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
6722: x_return_status OUT NOCOPY VARCHAR2,
6723: x_msg_count OUT NOCOPY NUMBER,
6724: x_msg_data OUT NOCOPY VARCHAR2,
6725: p_org_id IN NUMBER,
7025: *=======================================================================*/
7026:
7027: PROCEDURE get_k_hdr_tax_params(
7028: p_api_version IN NUMBER,
7029: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
7030: x_return_status OUT NOCOPY VARCHAR2,
7031: x_msg_count OUT NOCOPY NUMBER,
7032: x_msg_data OUT NOCOPY VARCHAR2,
7033: p_khr_id IN NUMBER,
7136: OPEN c_get_contractinfo_csr(p_khr_id);
7137: FETCH c_get_contractinfo_csr INTO l_get_contractinfo_rec;
7138: IF c_get_contractinfo_csr%NOTFOUND THEN
7139: -- KHR ID is invalid
7140: OKC_API.set_message( p_app_name => 'OKC',
7141: p_msg_name => G_INVALID_VALUE,
7142: p_token1 => G_COL_NAME_TOKEN,
7143: p_token1_value => 'KHR_ID');
7144: RAISE OKL_API.G_EXCEPTION_ERROR;
7145: END IF;
7146: CLOSE c_get_contractinfo_csr;
7147:
7148: IF l_get_contractinfo_rec.currency_code IS NULL THEN
7149: OKC_API.set_message( p_app_name => 'OKC',
7150: p_msg_name => G_REQUIRED_VALUE,
7151: p_token1 => G_COL_NAME_TOKEN,
7152: p_token1_value => 'CURRENCY_CODE');
7153:
7171: -- but mandatory for tax team
7172: -- check with Nilesh
7173: IF l_fndcurrency_csr%NOTFOUND THEN
7174: -- currency code is invalid
7175: OKC_API.set_message( p_app_name => 'OKC',
7176: p_msg_name => G_INVALID_VALUE,
7177: p_token1 => G_COL_NAME_TOKEN,
7178: p_token1_value => 'CURRENCY_CODE');
7179:
7185: OPEN l_racusttrxtypes_csr;
7186: FETCH l_racusttrxtypes_csr INTO l_cust_trx_type_id;
7187: IF l_racusttrxtypes_csr%NOTFOUND THEN
7188: -- cust trx tyep id is required
7189: OKC_API.set_message( p_app_name => 'OKC',
7190: p_msg_name => G_REQUIRED_VALUE,
7191: p_token1 => G_COL_NAME_TOKEN,
7192: p_token1_value => 'CUST_TRX_TYPE_ID');
7193:
7216: FETCH l_oklkheaders_csr INTO l_fin_prod_id_det, l_book_class_code;
7217: CLOSE l_oklkheaders_csr;
7218:
7219: IF l_fin_prod_id_det IS NULL THEN -- financial product is mandatory on the contract
7220: OKC_API.set_message( p_app_name => 'OKC',
7221: p_msg_name => G_REQUIRED_VALUE,
7222: p_token1 => G_COL_NAME_TOKEN,
7223: p_token1_value => 'Financial Product');
7224: RAISE OKL_API.G_EXCEPTION_ERROR;
7713: *=======================================================================*/
7714:
7715: PROCEDURE get_asset_tax_params(
7716: p_api_version IN NUMBER,
7717: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
7718: x_return_status OUT NOCOPY VARCHAR2,
7719: x_msg_count OUT NOCOPY NUMBER,
7720: x_msg_data OUT NOCOPY VARCHAR2,
7721: p_khr_id IN NUMBER,
8130: |
8131: *=======================================================================*/
8132: PROCEDURE process_tax_schedule_tax(
8133: p_api_version IN NUMBER,
8134: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
8135: x_return_status OUT NOCOPY VARCHAR2,
8136: x_msg_count OUT NOCOPY NUMBER,
8137: x_msg_data OUT NOCOPY VARCHAR2,
8138: p_source_trx_id IN NUMBER,
8635: FETCH l_trxrequests_csr INTO l_ts_khr_id, l_ts_start_date, l_ts_end_date,
8636: l_ts_trx_type_id_det, l_legal_entity_id, l_org_id;
8637: IF l_trxrequests_csr%NOTFOUND THEN
8638: -- source trx id is invalid
8639: OKC_API.set_message( p_app_name => 'OKC',
8640: p_msg_name => G_INVALID_VALUE,
8641: p_token1 => G_COL_NAME_TOKEN,
8642: p_token1_value => 'SOURCE_TRX_ID');
8643: RAISE OKL_API.G_EXCEPTION_ERROR;
8655:
8656: -- Get K header level tax parameters
8657: get_k_hdr_tax_params(
8658: p_api_version => p_api_version,
8659: p_init_msg_list => OKC_API.G_FALSE,
8660: x_return_status => x_return_status,
8661: x_msg_count => x_msg_count,
8662: x_msg_data => x_msg_data,
8663: p_khr_id => l_ts_khr_id,
9051: FOR K IN l_finassets_tbl.FIRST..l_finassets_tbl.LAST LOOP
9052:
9053: get_asset_tax_params(
9054: p_api_version => p_api_version,
9055: p_init_msg_list => OKC_API.G_FALSE,
9056: x_return_status => x_return_status,
9057: x_msg_count => x_msg_count,
9058: x_msg_data => x_msg_data,
9059: p_khr_id => l_ts_khr_id,
9143: END IF;
9144: END IF;
9145:
9146: populate_tax_codes( p_api_version => p_api_version,
9147: p_init_msg_list => OKC_API.G_FALSE,
9148: x_return_status => x_return_status,
9149: x_msg_count => x_msg_count,
9150: x_msg_data => x_msg_data,
9151: p_prch_opt_det => l_ts_prch_opt_det,
9221:
9222: -- get the Location Party ID's
9223: get_location_party_ids(
9224: p_api_version => p_api_version,
9225: p_init_msg_list => OKC_API.G_FALSE,
9226: x_return_status => x_return_status,
9227: x_msg_count => x_msg_count,
9228: x_msg_data => x_msg_data,
9229: p_cust_acct_id => l_cust_acct_id,
9244: RAISE OKL_API.G_EXCEPTION_ERROR;
9245: END IF;
9246:
9247: populate_tax_codes( p_api_version => p_api_version,
9248: p_init_msg_list => OKC_API.G_FALSE,
9249: x_return_status => x_return_status,
9250: x_msg_count => x_msg_count,
9251: x_msg_data => x_msg_data,
9252: p_prch_opt_det => l_ts_prch_opt_det,
9348: l_contract_streams_tbl(k).asset_number := l_name;-- populate asset num for subline as well
9349:
9350: get_location_party_ids(
9351: p_api_version => p_api_version,
9352: p_init_msg_list => OKC_API.G_FALSE,
9353: x_return_status => x_return_status,
9354: x_msg_count => x_msg_count,
9355: x_msg_data => x_msg_data,
9356: p_cust_acct_id => l_cust_acct_id,
9928: |
9929: *=======================================================================*/
9930: PROCEDURE process_quote_tax(
9931: p_api_version IN NUMBER,
9932: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
9933: x_return_status OUT NOCOPY VARCHAR2,
9934: x_msg_count OUT NOCOPY NUMBER,
9935: x_msg_data OUT NOCOPY VARCHAR2,
9936: p_source_trx_id IN NUMBER,
10119: l_early_term_yn, l_qtp_code, l_legal_entity_id,
10120: l_qrs_code;
10121: IF l_trxquotes_csr%NOTFOUND THEN
10122: -- source trx id is invalid
10123: OKC_API.set_message( p_app_name => 'OKC',
10124: p_msg_name => G_INVALID_VALUE,
10125: p_token1 => G_COL_NAME_TOKEN,
10126: p_token1_value => 'SOURCE_TRX_ID');
10127: RAISE OKL_API.G_EXCEPTION_ERROR;
10330: IF (l_lse_id = 33) THEN
10331: -- Get the financial asset level determinants
10332: get_asset_tax_params(
10333: p_api_version => p_api_version,
10334: p_init_msg_list => OKC_API.G_FALSE,
10335: x_return_status => x_return_status,
10336: x_msg_count => x_msg_count,
10337: x_msg_data => x_msg_data,
10338: p_khr_id => l_qte_khr_id,
10371: IF l_qtp_code LIKE 'TER%' THEN -- Ship to Location is not applicable for repurchase quote
10372: -- Get the ship_to and _bill_to identifiers
10373: get_location_party_ids(
10374: p_api_version => p_api_version,
10375: p_init_msg_list => OKC_API.G_FALSE,
10376: x_return_status => x_return_status,
10377: x_msg_count => x_msg_count,
10378: x_msg_data => x_msg_data,
10379: p_cust_acct_id => lx_cust_acct_id,
10468: IF l_fma_id IS NOT NULL THEN
10469: OPEN l_formulae_csr(l_fma_id);
10470: FETCH l_formulae_csr INTO l_formula_name;
10471: IF l_formulae_csr%NOTFOUND THEN
10472: OKC_API.set_message( p_app_name => 'OKC',
10473: p_msg_name => G_INVALID_VALUE,
10474: p_token1 => G_COL_NAME_TOKEN,
10475: p_token1_value => 'FMA_ID');
10476: RAISE OKL_API.G_EXCEPTION_ERROR;
10540: -- Populate tax sources record -- end
10541:
10542: populate_tax_info(
10543: p_api_version => p_api_version,
10544: p_init_msg_list => OKC_API.G_FALSE,
10545: x_return_status => x_return_status,
10546: x_msg_count => x_msg_count,
10547: x_msg_data => x_msg_data,
10548: p_prch_opt_det => lx_pb_prch_opt_det,
10890: |
10891: *=======================================================================*/
10892: PROCEDURE process_asset_loc_tax(
10893: p_api_version IN NUMBER,
10894: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
10895: x_return_status OUT NOCOPY VARCHAR2,
10896: x_msg_count OUT NOCOPY NUMBER,
10897: x_msg_data OUT NOCOPY VARCHAR2,
10898: p_source_trx_id IN NUMBER,
11176: OPEN l_trxassets_csr(p_source_trx_id, p_source_trx_name);
11177: FETCH l_trxassets_csr INTO l_alc_trx_type_id_det, l_trx_date, l_legal_entity_id;
11178: IF l_trxassets_csr%NOTFOUND THEN
11179: -- source trx id is invalid
11180: OKC_API.set_message( p_app_name => 'OKC',
11181: p_msg_name => G_INVALID_VALUE,
11182: p_token1 => G_COL_NAME_TOKEN,
11183: p_token1_value => 'SOURCE_TRX_ID');
11184: RAISE OKL_API.G_EXCEPTION_ERROR;
11190: -- get trx line details
11191: OPEN l_txlitminsts_csr(p_source_trx_id);
11192: FETCH l_txlitminsts_csr INTO l_inst_item_line_id, l_party_site_uses_id1, l_fin_asset_id;
11193: IF l_txlitminsts_csr%NOTFOUND THEN
11194: OKC_API.set_message( p_app_name => 'OKC',
11195: p_msg_name => G_REQUIRED_VALUE,
11196: p_token1 => G_COL_NAME_TOKEN,
11197: p_token1_value => 'PARTY_SITE_USES_ID1');
11198: RAISE OKL_API.G_EXCEPTION_ERROR;
11198: RAISE OKL_API.G_EXCEPTION_ERROR;
11199: END IF;
11200:
11201: IF l_fin_asset_id IS NULL THEN
11202: OKC_API.set_message( p_app_name => 'OKC',
11203: p_msg_name => G_REQUIRED_VALUE,
11204: p_token1 => G_COL_NAME_TOKEN,
11205: p_token1_value => 'DNZ_CLE_ID');
11206: RAISE OKL_API.G_EXCEPTION_ERROR;
11209:
11210: OPEN l_okcklines_csr(l_fin_asset_id);
11211: FETCH l_okcklines_csr INTO l_chr_id, l_name;
11212: IF l_okcklines_csr%NOTFOUND THEN
11213: OKC_API.set_message( p_app_name => 'OKC',
11214: p_msg_name => G_INVALID_VALUE,
11215: p_token1 => G_COL_NAME_TOKEN,
11216: p_token1_value => 'DNZ_CLE_ID');
11217: RAISE OKL_API.G_EXCEPTION_ERROR;
11221: -- get the new location id
11222: OPEN l_partysiteuses_csr(l_party_site_uses_id1);
11223: FETCH l_partysiteuses_csr INTO l_new_location_id,l_install_location_id;
11224: IF l_partysiteuses_csr%NOTFOUND THEN
11225: OKC_API.set_message( p_app_name => 'OKC',
11226: p_msg_name => G_REQUIRED_VALUE,
11227: p_token1 => G_COL_NAME_TOKEN,
11228: p_token1_value => 'LOCATION_ID');
11229: RAISE OKL_API.G_EXCEPTION_ERROR;
11385:
11386: -- get the asset level determinants
11387: get_asset_tax_params(
11388: p_api_version => p_api_version,
11389: p_init_msg_list => OKC_API.G_FALSE,
11390: x_return_status => x_return_status,
11391: x_msg_count => x_msg_count,
11392: x_msg_data => x_msg_data,
11393: p_khr_id => l_chr_id,
11421: CLOSE l_invitem_csr;
11422:
11423: -- get the Equipment Locationn (IB Loc)
11424: get_location_party_ids( p_api_version => p_api_version,
11425: p_init_msg_list => OKC_API.G_FALSE,
11426: x_return_status => x_return_status,
11427: x_msg_count => x_msg_count,
11428: x_msg_data => x_msg_data,
11429: p_cust_acct_id => lx_cust_acct_id,
11518:
11519: OPEN l_formulae_csr(l_fma_id);
11520: FETCH l_formulae_csr INTO l_formula_name;
11521: IF l_formulae_csr%NOTFOUND THEN
11522: OKC_API.set_message( p_app_name => 'OKC',
11523: p_msg_name => G_INVALID_VALUE,
11524: p_token1 => G_COL_NAME_TOKEN,
11525: p_token1_value => 'FMA_ID');
11526: RAISE OKL_API.G_EXCEPTION_ERROR;
11671: -- Populate tax sources record -- end
11672:
11673: populate_tax_info(
11674: p_api_version => p_api_version,
11675: p_init_msg_list => OKC_API.G_FALSE,
11676: x_return_status => x_return_status,
11677: x_msg_count => x_msg_count,
11678: x_msg_data => x_msg_data,
11679: p_prch_opt_det => lx_alc_prch_opt_det,
12130: |
12131: *=======================================================================*/
12132: PROCEDURE process_split_asset_tax(
12133: p_api_version IN NUMBER,
12134: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
12135: x_return_status OUT NOCOPY VARCHAR2,
12136: x_msg_count OUT NOCOPY NUMBER,
12137: x_msg_data OUT NOCOPY VARCHAR2,
12138: p_source_trx_id IN NUMBER,
12288: OPEN l_trxassets_csr(p_source_trx_id, p_source_trx_name);
12289: FETCH l_trxassets_csr INTO l_spl_trx_type_id, l_trx_date;
12290: IF l_trxassets_csr%NOTFOUND THEN
12291: -- source trx id is invalid
12292: OKC_API.set_message( p_app_name => 'OKC',
12293: p_msg_name => G_INVALID_VALUE,
12294: p_token1 => G_COL_NAME_TOKEN,
12295: p_token1_value => 'SOURCE_TRX_ID');
12296: RAISE OKL_API.G_EXCEPTION_ERROR;
12301: OPEN l_txlassets_csr(p_source_trx_id);
12302: FETCH l_txlassets_csr INTO l_txl_id, l_fin_asset_id, l_dnz_khr_id,
12303: l_asset_number, l_current_units;
12304: IF l_txlassets_csr%NOTFOUND THEN
12305: OKC_API.set_message( p_app_name => 'OKC',
12306: p_msg_name => G_REQUIRED_VALUE,
12307: p_token1 => G_COL_NAME_TOKEN,
12308: p_token1_value => 'Financial Asset');
12309: RAISE OKL_API.G_EXCEPTION_ERROR;
12309: RAISE OKL_API.G_EXCEPTION_ERROR;
12310: END IF;
12311:
12312: IF l_fin_asset_id IS NULL THEN
12313: OKC_API.set_message( p_app_name => 'OKC',
12314: p_msg_name => G_REQUIRED_VALUE,
12315: p_token1 => G_COL_NAME_TOKEN,
12316: p_token1_value => 'KLE_ID');
12317: RAISE OKL_API.G_EXCEPTION_ERROR;
12317: RAISE OKL_API.G_EXCEPTION_ERROR;
12318: END IF;
12319:
12320: IF l_current_units IS NULL THEN
12321: OKC_API.set_message( p_app_name => 'OKC',
12322: p_msg_name => G_REQUIRED_VALUE,
12323: p_token1 => G_COL_NAME_TOKEN,
12324: p_token1_value => 'CURRENT_UNITS');
12325: RAISE OKL_API.G_EXCEPTION_ERROR;
12330: IF l_dnz_khr_id IS NULL OR l_asset_number IS NULL THEN
12331: OPEN l_okcklines_csr(l_fin_asset_id);
12332: FETCH l_okcklines_csr INTO l_dnz_chr_id, l_name;
12333: IF l_okcklines_csr%NOTFOUND THEN
12334: OKC_API.set_message( p_app_name => 'OKC',
12335: p_msg_name => G_INVALID_VALUE,
12336: p_token1 => G_COL_NAME_TOKEN,
12337: p_token1_value => 'KLE_ID');
12338: RAISE OKL_API.G_EXCEPTION_ERROR;
12345:
12346: IF l_asset_number IS NULL THEN
12347: l_asset_number := l_name;
12348: IF l_asset_number IS NULL THEN
12349: OKC_API.set_message( p_app_name => 'OKC',
12350: p_msg_name => G_REQUIRED_VALUE,
12351: p_token1 => G_COL_NAME_TOKEN,
12352: p_token1_value => 'ASSET_NUMBER');
12353: RAISE OKL_API.G_EXCEPTION_ERROR;
12644: OPEN l_racusttrxtypes_csr;
12645: FETCH l_racusttrxtypes_csr INTO l_cust_trx_type_id;
12646: IF l_racusttrxtypes_csr%NOTFOUND THEN
12647: -- cust trx tyep id is required
12648: OKC_API.set_message( p_app_name => 'OKC',
12649: p_msg_name => G_REQUIRED_VALUE,
12650: p_token1 => G_COL_NAME_TOKEN,
12651: p_token1_value => 'CUST_TRX_TYPE_ID');
12652: RAISE OKL_API.G_EXCEPTION_ERROR;
12657: FETCH l_fndcurrency_csr INTO l_precision, l_minimum_accountable_unit; -- l_minimum_accountable_unit is optional in fnd_currencies
12658: -- but mandatory for tax team
12659: -- check with Nilesh
12660: IF l_fndcurrency_csr%NOTFOUND THEN
12661: OKC_API.set_message( p_app_name => 'OKC',
12662: p_msg_name => G_INVALID_VALUE,
12663: p_token1 => G_COL_NAME_TOKEN,
12664: p_token1_value => 'CURRENCY_CODE');
12665: RAISE OKL_API.G_EXCEPTION_ERROR;
13143: |
13144: *=======================================================================*/
13145: PROCEDURE process_booking_upfront_tax(
13146: p_api_version IN NUMBER,
13147: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
13148: x_return_status OUT NOCOPY VARCHAR2,
13149: x_msg_count OUT NOCOPY NUMBER,
13150: x_msg_data OUT NOCOPY VARCHAR2,
13151: p_source_trx_id IN NUMBER,
13404: FETCH l_trxcontracts_csr INTO l_bk_trx_type_id_det, l_khr_id, l_legal_entity_id;
13405: -- At this point, l_bk_trx_type_id_det will be the id of Booking trx type
13406: IF l_trxcontracts_csr%NOTFOUND THEN
13407: -- source trx id is invalid
13408: OKC_API.set_message( p_app_name => 'OKC',
13409: p_msg_name => G_INVALID_VALUE,
13410: p_token1 => G_COL_NAME_TOKEN,
13411: p_token1_value => 'SOURCE_TRX_ID');
13412: RAISE OKL_API.G_EXCEPTION_ERROR;
13418: FETCH l_trxcontracts_rbk_csr INTO l_khr_id, l_legal_entity_id;
13419: -- At this point, l_bk_trx_type_id_det will be the id of Booking trx type
13420: IF l_trxcontracts_rbk_csr%NOTFOUND THEN
13421: -- source trx id is invalid
13422: OKC_API.set_message( p_app_name => 'OKC',
13423: p_msg_name => G_INVALID_VALUE,
13424: p_token1 => G_COL_NAME_TOKEN,
13425: p_token1_value => 'SOURCE_TRX_ID');
13426: RAISE OKL_API.G_EXCEPTION_ERROR;
13436: l_tax_call_type := upper(p_tax_call_type);
13437:
13438: IF (l_tax_call_type IS NOT NULL AND
13439: l_tax_call_type NOT IN (G_ESTIMATED_CALL_TYPE, G_ACTUAL_CALL_TYPE)) THEN
13440: OKC_API.set_message( p_app_name => 'OKC',
13441: p_msg_name => G_INVALID_VALUE,
13442: p_token1 => G_COL_NAME_TOKEN,
13443: p_token1_value => 'TAX_CALL_TYPE');
13444: RAISE OKL_API.G_EXCEPTION_ERROR;
13549: IF l_fma_id IS NOT NULL THEN
13550: OPEN l_formulae_csr(l_fma_id);
13551: FETCH l_formulae_csr INTO l_formula_name;
13552: IF l_formulae_csr%NOTFOUND THEN
13553: OKC_API.set_message( p_app_name => 'OKC',
13554: p_msg_name => G_INVALID_VALUE,
13555: p_token1 => G_COL_NAME_TOKEN,
13556: p_token1_value => 'FMA_ID');
13557: RAISE OKL_API.G_EXCEPTION_ERROR;
13677:
13678: -- Get financial asset line level tax determinants --
13679: get_asset_tax_params(
13680: p_api_version => p_api_version,
13681: p_init_msg_list => OKC_API.G_FALSE,
13682: x_return_status => x_return_status,
13683: x_msg_count => x_msg_count,
13684: x_msg_data => x_msg_data,
13685: p_khr_id => l_khr_id,
13716:
13717: -- get the Location Party ID's
13718: get_location_party_ids(
13719: p_api_version => p_api_version,
13720: p_init_msg_list => OKC_API.G_FALSE,
13721: x_return_status => x_return_status,
13722: x_msg_count => x_msg_count,
13723: x_msg_data => x_msg_data,
13724: p_cust_acct_id => lx_cust_acct_id,
13887: -- Populate tax sources record -- end
13888:
13889: populate_tax_info(
13890: p_api_version => p_api_version,
13891: p_init_msg_list => OKC_API.G_FALSE,
13892: x_return_status => x_return_status,
13893: x_msg_count => x_msg_count,
13894: x_msg_data => x_msg_data,
13895: p_prch_opt_det => lx_pb_prch_opt_det,
13998:
13999: -- asset level call begin
14000: populate_tax_info(
14001: p_api_version => p_api_version,
14002: p_init_msg_list => OKC_API.G_FALSE,
14003: x_return_status => x_return_status,
14004: x_msg_count => x_msg_count,
14005: x_msg_data => x_msg_data,
14006: p_prch_opt_det => lx_pb_prch_opt_det,
14123: -- Populate tax sources record -- end
14124:
14125: populate_tax_info(
14126: p_api_version => p_api_version,
14127: p_init_msg_list => OKC_API.G_FALSE,
14128: x_return_status => x_return_status,
14129: x_msg_count => x_msg_count,
14130: x_msg_data => x_msg_data,
14131: p_prch_opt_det => lx_pb_prch_opt_det,
14238:
14239: -- asset level call begin
14240: populate_tax_info(
14241: p_api_version => p_api_version,
14242: p_init_msg_list => OKC_API.G_FALSE,
14243: x_return_status => x_return_status,
14244: x_msg_count => x_msg_count,
14245: x_msg_data => x_msg_data,
14246: p_prch_opt_det => lx_pb_prch_opt_det,
14371: -- Populate tax sources record -- end
14372:
14373: populate_tax_info(
14374: p_api_version => p_api_version,
14375: p_init_msg_list => OKC_API.G_FALSE,
14376: x_return_status => x_return_status,
14377: x_msg_count => x_msg_count,
14378: x_msg_data => x_msg_data,
14379: p_prch_opt_det => lx_pb_prch_opt_det,
14480:
14481: -- asset level call begin
14482: populate_tax_info(
14483: p_api_version => p_api_version,
14484: p_init_msg_list => OKC_API.G_FALSE,
14485: x_return_status => x_return_status,
14486: x_msg_count => x_msg_count,
14487: x_msg_data => x_msg_data,
14488: p_prch_opt_det => lx_pb_prch_opt_det,
14844: |
14845: *=======================================================================*/
14846: PROCEDURE process_pre_rbk_upfront_tax(
14847: p_api_version IN NUMBER,
14848: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
14849: x_return_status OUT NOCOPY VARCHAR2,
14850: x_msg_count OUT NOCOPY NUMBER,
14851: x_msg_data OUT NOCOPY VARCHAR2,
14852: p_source_trx_id IN NUMBER,
14981: |
14982: *=======================================================================*/
14983: PROCEDURE process_rebook_upfront_tax(
14984: p_api_version IN NUMBER,
14985: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
14986: x_return_status OUT NOCOPY VARCHAR2,
14987: x_msg_count OUT NOCOPY NUMBER,
14988: x_msg_data OUT NOCOPY VARCHAR2,
14989: p_source_trx_id IN NUMBER,
15105: FETCH l_trxcontracts_csr INTO l_rbk_trx_type_id_det, l_khr_id, l_rbk_khr_id, l_trx_date; -- l_khr_id has original contract id
15106: -- At this point l_rbk_trx_type_id_det has the id of the Rebook trx type
15107: IF l_trxcontracts_csr%NOTFOUND THEN
15108: -- source trx id is invalid
15109: OKC_API.set_message( p_app_name => 'OKC',
15110: p_msg_name => G_INVALID_VALUE,
15111: p_token1 => G_COL_NAME_TOKEN,
15112: p_token1_value => 'SOURCE_TRX_ID');
15113: RAISE OKL_API.G_EXCEPTION_ERROR;
15402: -- Sync the parent contract kle_id's
15403: OPEN l_orig_kle_id(cp_kle_id => l_kle_id);
15404: FETCH l_orig_kle_id INTO l_sync_kle_id;
15405: IF l_orig_kle_id%NOTFOUND THEN
15406: OKC_API.set_message( p_app_name => 'OKC',
15407: p_msg_name => G_INVALID_VALUE,
15408: p_token1 => G_COL_NAME_TOKEN,
15409: p_token1_value => 'SOURCE_TRX_ID');
15410: RAISE OKL_API.G_EXCEPTION_ERROR;
15419: -- l_rbk_taxablelines_rec
15420: OPEN l_new_line_id(cp_orig_system_id => l_kle_id);
15421: FETCH l_new_line_id INTO l_sync_kle_id;
15422: IF l_new_line_id%NOTFOUND THEN
15423: OKC_API.set_message( p_app_name => 'OKC',
15424: p_msg_name => G_INVALID_VALUE,
15425: p_token1 => G_COL_NAME_TOKEN,
15426: p_token1_value => 'SOURCE_TRX_ID');
15427: RAISE OKL_API.G_EXCEPTION_ERROR;
15649: |
15650: *=======================================================================*/
15651: PROCEDURE process_quoting_upfront_tax(
15652: p_api_version IN NUMBER,
15653: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
15654: x_return_status OUT NOCOPY VARCHAR2,
15655: x_msg_count OUT NOCOPY NUMBER,
15656: x_msg_data OUT NOCOPY VARCHAR2,
15657: p_source_trx_id IN NUMBER,
15964: l_sq_age_of_equipment, l_parent_object_code, l_parent_object_id, l_legal_entity_id;
15965:
15966: IF l_leasequotes_csr%NOTFOUND THEN
15967: -- Source trx id is invalid
15968: OKC_API.set_message( p_app_name => 'OKC',
15969: p_msg_name => G_INVALID_VALUE,
15970: p_token1 => G_COL_NAME_TOKEN,
15971: p_token1_value => 'SOURCE_TRX_ID');
15972: RAISE OKL_API.G_EXCEPTION_ERROR;
16103: IF l_fma_id IS NOT NULL THEN
16104: OPEN l_formulae_csr(l_fma_id);
16105: FETCH l_formulae_csr INTO l_formula_name;
16106: IF l_formulae_csr%NOTFOUND THEN
16107: OKC_API.set_message( p_app_name => 'OKC',
16108: p_msg_name => G_INVALID_VALUE,
16109: p_token1 => G_COL_NAME_TOKEN,
16110: p_token1_value => 'FMA_ID');
16111: RAISE OKL_API.G_EXCEPTION_ERROR;
16122: OPEN l_racusttrxtypes_csr;
16123: FETCH l_racusttrxtypes_csr INTO l_cust_trx_type_id;
16124: IF l_racusttrxtypes_csr%NOTFOUND THEN
16125: -- Cust trx type id is required
16126: OKC_API.set_message( p_app_name => 'OKC',
16127: p_msg_name => G_REQUIRED_VALUE,
16128: p_token1 => G_COL_NAME_TOKEN,
16129: p_token1_value => 'CUST_TRX_TYPE_ID');
16130: RAISE OKL_API.G_EXCEPTION_ERROR;
16138: l_org_id, l_start_date, l_currency_conversion_type,
16139: l_currency_conversion_rate, l_currency_conversion_date,
16140: l_line_intended_use,l_deal_type;
16141: IF l_leaseopp_csr%NOTFOUND THEN
16142: OKC_API.set_message( p_app_name => 'OKC',
16143: p_msg_name => G_REQUIRED_VALUE,
16144: p_token1 => G_COL_NAME_TOKEN,
16145: p_token1_value => 'CURRENCY_CODE');
16146: RAISE OKL_API.G_EXCEPTION_ERROR;
16152: l_org_id, l_start_date, l_currency_conversion_type,
16153: l_currency_conversion_rate, l_currency_conversion_date,
16154: l_line_intended_use, l_deal_type;
16155: IF l_leaseapp_csr%NOTFOUND THEN
16156: OKC_API.set_message( p_app_name => 'OKC',
16157: p_msg_name => G_REQUIRED_VALUE,
16158: p_token1 => G_COL_NAME_TOKEN,
16159: p_token1_value => 'CURRENCY_CODE');
16160: RAISE OKL_API.G_EXCEPTION_ERROR;
16179: OPEN l_billtosite_csr(l_party_id);
16180: FETCH l_billtosite_csr INTO l_bill_to_siteuseid, l_bill_to_party_site_id,
16181: l_bill_to_party_id, l_bill_to_location_id;
16182: IF l_billtosite_csr%NOTFOUND THEN
16183: OKC_API.set_message( p_app_name => 'OKL',
16184: p_msg_name => 'OKL_TX_NO_SQ_BILL_TO');
16185: RAISE OKL_API.G_EXCEPTION_ERROR;
16186: END IF;
16187: CLOSE l_billtosite_csr ;
16190: OPEN l_fndcurrency_csr(l_currency_code);
16191: FETCH l_fndcurrency_csr INTO l_precision, l_minimum_accountable_unit;
16192: IF l_fndcurrency_csr%NOTFOUND THEN
16193: -- Currency code is invalid
16194: OKC_API.set_message( p_app_name => 'OKC',
16195: p_msg_name => G_INVALID_VALUE,
16196: p_token1 => G_COL_NAME_TOKEN,
16197: p_token1_value => 'CURRENCY_CODE');
16198: RAISE OKL_API.G_EXCEPTION_ERROR;
16369: -- Populate tax sources record -- end
16370:
16371: populate_tax_info(
16372: p_api_version => p_api_version,
16373: p_init_msg_list => OKC_API.G_FALSE,
16374: x_return_status => x_return_status,
16375: x_msg_count => x_msg_count,
16376: x_msg_data => x_msg_data,
16377: p_prch_opt_det => null, -- purchase option is not captured on Sales Quote
16480:
16481: -- asset level call begin
16482: populate_tax_info(
16483: p_api_version => p_api_version,
16484: p_init_msg_list => OKC_API.G_FALSE,
16485: x_return_status => x_return_status,
16486: x_msg_count => x_msg_count,
16487: x_msg_data => x_msg_data,
16488: p_prch_opt_det => null, -- purchase option is not captured on Sales Quote
16606: -- Populate tax sources record -- end
16607:
16608: populate_tax_info(
16609: p_api_version => p_api_version,
16610: p_init_msg_list => OKC_API.G_FALSE,
16611: x_return_status => x_return_status,
16612: x_msg_count => x_msg_count,
16613: x_msg_data => x_msg_data,
16614: p_prch_opt_det => null, -- purchase option is not captured on Sales Quote
16719:
16720: -- asset level call begin
16721: populate_tax_info(
16722: p_api_version => p_api_version,
16723: p_init_msg_list => OKC_API.G_FALSE,
16724: x_return_status => x_return_status,
16725: x_msg_count => x_msg_count,
16726: x_msg_data => x_msg_data,
16727: p_prch_opt_det => null, -- purchase option is not captured on Sales Quote
16851: -- Populate tax sources record -- end
16852:
16853: populate_tax_info(
16854: p_api_version => p_api_version,
16855: p_init_msg_list => OKC_API.G_FALSE,
16856: x_return_status => x_return_status,
16857: x_msg_count => x_msg_count,
16858: x_msg_data => x_msg_data,
16859: p_prch_opt_det => null, -- purchase option is not captured on Sales Quote
16962:
16963: -- asset level call begin
16964: populate_tax_info(
16965: p_api_version => p_api_version,
16966: p_init_msg_list => OKC_API.G_FALSE,
16967: x_return_status => x_return_status,
16968: x_msg_count => x_msg_count,
16969: x_msg_data => x_msg_data,
16970: p_prch_opt_det => null, -- purchase option is not captured on Sales Quote
17432: |
17433: *=======================================================================*/
17434: PROCEDURE calculate_sales_tax(
17435: p_api_version IN NUMBER,
17436: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
17437: x_return_status OUT NOCOPY VARCHAR2,
17438: x_msg_count OUT NOCOPY NUMBER,
17439: x_msg_data OUT NOCOPY VARCHAR2,
17440: p_source_trx_id IN NUMBER,
17631:
17632: ELSIF (p_source_trx_name = 'Asset Relocation') THEN
17633: IF l_ou_tax_upfront_yn = 'Y' THEN -- OU allows upfront type of call
17634: IF p_tax_call_type IS NULL THEN
17635: OKC_API.set_message( p_app_name => 'OKC',
17636: p_msg_name => G_REQUIRED_VALUE,
17637: p_token1 => G_COL_NAME_TOKEN,
17638: p_token1_value => 'Tax Call Type');
17639: RAISE OKL_API.G_EXCEPTION_ERROR;
17639: RAISE OKL_API.G_EXCEPTION_ERROR;
17640: ELSE
17641: l_tax_call_type := upper(p_tax_call_type);
17642: IF l_tax_call_type NOT IN (G_ESTIMATED_CALL_TYPE, G_ACTUAL_CALL_TYPE) THEN
17643: OKC_API.set_message( p_app_name => 'OKC',
17644: p_msg_name => G_INVALID_VALUE,
17645: p_token1 => G_COL_NAME_TOKEN,
17646: p_token1_value => 'Tax Call Type');
17647: RAISE OKL_API.G_EXCEPTION_ERROR;
17705:
17706: ELSIF ( p_source_trx_name = 'Booking') THEN
17707: IF l_ou_tax_upfront_yn = 'Y' THEN -- OU allows upfront type of call
17708: IF p_tax_call_type IS NULL THEN
17709: OKC_API.set_message( p_app_name => 'OKC',
17710: p_msg_name => G_REQUIRED_VALUE,
17711: p_token1 => G_COL_NAME_TOKEN,
17712: p_token1_value => 'Tax Call Type');
17713: RAISE OKL_API.G_EXCEPTION_ERROR;
17713: RAISE OKL_API.G_EXCEPTION_ERROR;
17714: ELSE
17715: l_tax_call_type := upper(p_tax_call_type);
17716: IF l_tax_call_type NOT IN (G_ESTIMATED_CALL_TYPE, G_ACTUAL_CALL_TYPE) THEN
17717: OKC_API.set_message( p_app_name => 'OKC',
17718: p_msg_name => G_INVALID_VALUE,
17719: p_token1 => G_COL_NAME_TOKEN,
17720: p_token1_value => 'Tax Call Type');
17721: RAISE OKL_API.G_EXCEPTION_ERROR;
17875: p_token1_value => 'Upfront Tax');
17876: END IF;
17877:
17878: ELSE
17879: OKC_API.set_message( p_app_name => 'OKC',
17880: p_msg_name => G_INVALID_VALUE,
17881: p_token1 => G_COL_NAME_TOKEN,
17882: p_token1_value => 'Transaction Type');
17883: RAISE OKL_API.G_EXCEPTION_ERROR;
19135: -- Validate source trx id
19136: OPEN l_billingdtls_csr(p_source_trx_id);
19137: FETCH l_billingdtls_csr INTO l_billingdtls_rec;
19138: IF l_billingdtls_csr %NOTFOUND THEN
19139: OKC_API.set_message( p_app_name => 'OKC',
19140: p_msg_name => G_INVALID_VALUE,
19141: p_token1 => G_COL_NAME_TOKEN,
19142: p_token1_value => 'SOURCE_TRX_ID');
19143: RAISE OKL_API.G_EXCEPTION_ERROR;
19350: FETCH l_oeorderlines_csr INTO l_inv_item_id, l_inv_item_org_id, lx_ship_to_siteuseid;
19351: -- ship_to_org_id from oe_order_lines_all is the site_use_id value from hz_cust_site_uses_all
19352: -- which is the ship_to_site_use_id
19353: IF l_oeorderlines_csr%NOTFOUND THEN
19354: OKC_API.set_message( p_app_name => 'OKC',
19355: p_msg_name => G_INVALID_VALUE,
19356: p_token1 => G_COL_NAME_TOKEN,
19357: p_token1_value => 'ISL_ID');
19358: RAISE OKL_API.G_EXCEPTION_ERROR;
19689: OPEN l_formulae_csr(l_fma_id);
19690: FETCH l_formulae_csr INTO l_formula_name;
19691:
19692: IF l_formulae_csr%NOTFOUND THEN
19693: OKC_API.set_message( p_app_name => 'OKC',
19694: p_msg_name => G_INVALID_VALUE,
19695: p_token1 => G_COL_NAME_TOKEN,
19696: p_token1_value => 'FMA_ID');
19697: RAISE OKL_API.G_EXCEPTION_ERROR;
19826: -- Validate source trx id
19827: OPEN l_disbdtls_csr(p_source_trx_id);
19828: FETCH l_disbdtls_csr INTO l_disbdtls_rec;
19829: IF l_disbdtls_csr %NOTFOUND THEN
19830: OKC_API.set_message( p_app_name => 'OKC',
19831: p_msg_name => G_INVALID_VALUE,
19832: p_token1 => G_COL_NAME_TOKEN,
19833: p_token1_value => 'SOURCE_TRX_ID');
19834: RAISE OKL_API.G_EXCEPTION_ERROR;
20147: OPEN l_formulae_csr(l_fma_id);
20148: FETCH l_formulae_csr INTO l_formula_name;
20149:
20150: IF l_formulae_csr%NOTFOUND THEN
20151: OKC_API.set_message( p_app_name => 'OKC',
20152: p_msg_name => G_INVALID_VALUE,
20153: p_token1 => G_COL_NAME_TOKEN,
20154: p_token1_value => 'FMA_ID');
20155: RAISE OKL_API.G_EXCEPTION_ERROR;
20276: x_tax_det_rec.x_user_defined_fisc_class := null;
20277: x_tax_det_rec.x_upstream_trx_reported_flag := null;
20278:
20279: ELSE
20280: OKC_API.set_message( p_app_name => 'OKC',
20281: p_msg_name => G_INVALID_VALUE,
20282: p_token1 => G_COL_NAME_TOKEN,
20283: p_token1_value => 'SOURCE_TRX_NAME');
20284: RAISE OKL_API.G_EXCEPTION_ERROR;
20808: IF (p_source_trx_name = 'Pre-Rebook') THEN
20809: OPEN l_trxcontracts_base_csr(p_source_trx_id, p_source_trx_name);
20810: IF l_trxcontracts_base_csr%NOTFOUND THEN
20811: -- source trx id is invalid
20812: OKC_API.set_message( p_app_name => 'OKC',
20813: p_msg_name => G_INVALID_VALUE,
20814: p_token1 => G_COL_NAME_TOKEN,
20815: p_token1_value => 'SOURCE_TRX_ID');
20816: RAISE OKL_API.G_EXCEPTION_ERROR;
20819: ELSIF (p_source_trx_name = 'Rebook') THEN
20820: OPEN l_trxcontracts_csr(p_source_trx_id, p_source_trx_name);
20821: IF l_trxcontracts_csr%NOTFOUND THEN
20822: -- source trx id is invalid
20823: OKC_API.set_message( p_app_name => 'OKC',
20824: p_msg_name => G_INVALID_VALUE,
20825: p_token1 => G_COL_NAME_TOKEN,
20826: p_token1_value => 'SOURCE_TRX_ID');
20827: RAISE OKL_API.G_EXCEPTION_ERROR;