[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,
3841: |
3842: *=======================================================================*/
3843: PROCEDURE get_pc_code(
3844: p_api_version IN NUMBER,
3845: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3846: x_return_status OUT NOCOPY VARCHAR2,
3847: x_msg_count OUT NOCOPY NUMBER,
3848: x_msg_data OUT NOCOPY VARCHAR2,
3849: p_sty_id IN NUMBER,
4471: *=======================================================================*/
4472:
4473: PROCEDURE get_ufc_code(
4474: p_api_version IN NUMBER,
4475: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4476: x_return_status OUT NOCOPY VARCHAR2,
4477: x_msg_count OUT NOCOPY NUMBER,
4478: x_msg_data OUT NOCOPY VARCHAR2,
4479: p_purchase_option IN VARCHAR2,
5576: *=======================================================================*/
5577:
5578: PROCEDURE populate_tax_info(
5579: p_api_version IN NUMBER,
5580: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
5581: x_return_status OUT NOCOPY VARCHAR2,
5582: x_msg_count OUT NOCOPY NUMBER,
5583: x_msg_data OUT NOCOPY VARCHAR2,
5584: p_prch_opt_det IN VARCHAR2,
5714: -- the Serialized/Non-Serialized asset. It will be processed as needed for
5715: -- other transactions
5716: -- Get TBC code
5717: get_tbc_code(p_api_version => p_api_version,
5718: p_init_msg_list => OKC_API.G_FALSE,
5719: x_return_status => x_return_status,
5720: x_msg_count => x_msg_count,
5721: x_msg_data => x_msg_data,
5722: p_sty_id => p_tax_src_params_rec.sty_id, -- used if pymnts exist
5771: END IF;
5772:
5773: -- Get PC code
5774: get_pc_code(p_api_version => p_api_version,
5775: p_init_msg_list => OKC_API.G_FALSE,
5776: x_return_status => x_return_status,
5777: x_msg_count => x_msg_count,
5778: x_msg_data => x_msg_data,
5779: p_sty_id => p_tax_src_params_rec.sty_id, -- used if pymnts exist
5827:
5828: -- contract level call begin
5829: -- Get UFC code
5830: get_ufc_code(p_api_version => p_api_version,
5831: p_init_msg_list => OKC_API.G_FALSE,
5832: x_return_status => x_return_status,
5833: x_msg_count => x_msg_count,
5834: x_msg_data => x_msg_data,
5835: p_purchase_option => p_prch_opt_det,
6386: | 22-AUG-07 RRAVIKIR Created
6387: *=======================================================================*/
6388: PROCEDURE populate_tax_codes(
6389: p_api_version IN NUMBER,
6390: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
6391: x_return_status OUT NOCOPY VARCHAR2,
6392: x_msg_count OUT NOCOPY NUMBER,
6393: x_msg_data OUT NOCOPY VARCHAR2,
6394: p_prch_opt_det IN VARCHAR2,
6466: END IF;
6467:
6468: -- Get TBC code
6469: get_tbc_code(p_api_version => p_api_version,
6470: p_init_msg_list => OKC_API.G_FALSE,
6471: x_return_status => x_return_status,
6472: x_msg_count => x_msg_count,
6473: x_msg_data => x_msg_data,
6474: p_sty_id => p_sty_id, -- used if pymnts exist
6513: END IF;
6514:
6515: -- Get PC code
6516: get_pc_code(p_api_version => p_api_version,
6517: p_init_msg_list => OKC_API.G_FALSE,
6518: x_return_status => x_return_status,
6519: x_msg_count => x_msg_count,
6520: x_msg_data => x_msg_data,
6521: p_sty_id => p_sty_id,
6562: END IF;
6563:
6564: -- Get UFC code
6565: get_ufc_code(p_api_version => p_api_version,
6566: p_init_msg_list => OKC_API.G_FALSE,
6567: x_return_status => x_return_status,
6568: x_msg_count => x_msg_count,
6569: x_msg_data => x_msg_data,
6570: p_purchase_option => p_prch_opt_det,
6748:
6749:
6750: PROCEDURE get_billing_stream_types(
6751: p_api_version IN NUMBER,
6752: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
6753: x_return_status OUT NOCOPY VARCHAR2,
6754: x_msg_count OUT NOCOPY NUMBER,
6755: x_msg_data OUT NOCOPY VARCHAR2,
6756: p_org_id IN NUMBER,
7056: *=======================================================================*/
7057:
7058: PROCEDURE get_k_hdr_tax_params(
7059: p_api_version IN NUMBER,
7060: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
7061: x_return_status OUT NOCOPY VARCHAR2,
7062: x_msg_count OUT NOCOPY NUMBER,
7063: x_msg_data OUT NOCOPY VARCHAR2,
7064: p_khr_id IN NUMBER,
7167: OPEN c_get_contractinfo_csr(p_khr_id);
7168: FETCH c_get_contractinfo_csr INTO l_get_contractinfo_rec;
7169: IF c_get_contractinfo_csr%NOTFOUND THEN
7170: -- KHR ID is invalid
7171: OKC_API.set_message( p_app_name => 'OKC',
7172: p_msg_name => G_INVALID_VALUE,
7173: p_token1 => G_COL_NAME_TOKEN,
7174: p_token1_value => 'KHR_ID');
7175: RAISE OKL_API.G_EXCEPTION_ERROR;
7176: END IF;
7177: CLOSE c_get_contractinfo_csr;
7178:
7179: IF l_get_contractinfo_rec.currency_code IS NULL THEN
7180: OKC_API.set_message( p_app_name => 'OKC',
7181: p_msg_name => G_REQUIRED_VALUE,
7182: p_token1 => G_COL_NAME_TOKEN,
7183: p_token1_value => 'CURRENCY_CODE');
7184:
7202: -- but mandatory for tax team
7203: -- check with Nilesh
7204: IF l_fndcurrency_csr%NOTFOUND THEN
7205: -- currency code is invalid
7206: OKC_API.set_message( p_app_name => 'OKC',
7207: p_msg_name => G_INVALID_VALUE,
7208: p_token1 => G_COL_NAME_TOKEN,
7209: p_token1_value => 'CURRENCY_CODE');
7210:
7216: OPEN l_racusttrxtypes_csr;
7217: FETCH l_racusttrxtypes_csr INTO l_cust_trx_type_id;
7218: IF l_racusttrxtypes_csr%NOTFOUND THEN
7219: -- cust trx tyep id is required
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 => 'CUST_TRX_TYPE_ID');
7224:
7247: FETCH l_oklkheaders_csr INTO l_fin_prod_id_det, l_book_class_code;
7248: CLOSE l_oklkheaders_csr;
7249:
7250: IF l_fin_prod_id_det IS NULL THEN -- financial product is mandatory on the contract
7251: OKC_API.set_message( p_app_name => 'OKC',
7252: p_msg_name => G_REQUIRED_VALUE,
7253: p_token1 => G_COL_NAME_TOKEN,
7254: p_token1_value => 'Financial Product');
7255: RAISE OKL_API.G_EXCEPTION_ERROR;
7744: *=======================================================================*/
7745:
7746: PROCEDURE get_asset_tax_params(
7747: p_api_version IN NUMBER,
7748: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
7749: x_return_status OUT NOCOPY VARCHAR2,
7750: x_msg_count OUT NOCOPY NUMBER,
7751: x_msg_data OUT NOCOPY VARCHAR2,
7752: p_khr_id IN NUMBER,
8161: |
8162: *=======================================================================*/
8163: PROCEDURE process_tax_schedule_tax(
8164: p_api_version IN NUMBER,
8165: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
8166: x_return_status OUT NOCOPY VARCHAR2,
8167: x_msg_count OUT NOCOPY NUMBER,
8168: x_msg_data OUT NOCOPY VARCHAR2,
8169: p_source_trx_id IN NUMBER,
8666: FETCH l_trxrequests_csr INTO l_ts_khr_id, l_ts_start_date, l_ts_end_date,
8667: l_ts_trx_type_id_det, l_legal_entity_id, l_org_id;
8668: IF l_trxrequests_csr%NOTFOUND THEN
8669: -- source trx id is invalid
8670: OKC_API.set_message( p_app_name => 'OKC',
8671: p_msg_name => G_INVALID_VALUE,
8672: p_token1 => G_COL_NAME_TOKEN,
8673: p_token1_value => 'SOURCE_TRX_ID');
8674: RAISE OKL_API.G_EXCEPTION_ERROR;
8686:
8687: -- Get K header level tax parameters
8688: get_k_hdr_tax_params(
8689: p_api_version => p_api_version,
8690: p_init_msg_list => OKC_API.G_FALSE,
8691: x_return_status => x_return_status,
8692: x_msg_count => x_msg_count,
8693: x_msg_data => x_msg_data,
8694: p_khr_id => l_ts_khr_id,
9082: FOR K IN l_finassets_tbl.FIRST..l_finassets_tbl.LAST LOOP
9083:
9084: get_asset_tax_params(
9085: p_api_version => p_api_version,
9086: p_init_msg_list => OKC_API.G_FALSE,
9087: x_return_status => x_return_status,
9088: x_msg_count => x_msg_count,
9089: x_msg_data => x_msg_data,
9090: p_khr_id => l_ts_khr_id,
9174: END IF;
9175: END IF;
9176:
9177: populate_tax_codes( p_api_version => p_api_version,
9178: p_init_msg_list => OKC_API.G_FALSE,
9179: x_return_status => x_return_status,
9180: x_msg_count => x_msg_count,
9181: x_msg_data => x_msg_data,
9182: p_prch_opt_det => l_ts_prch_opt_det,
9252:
9253: -- get the Location Party ID's
9254: get_location_party_ids(
9255: p_api_version => p_api_version,
9256: p_init_msg_list => OKC_API.G_FALSE,
9257: x_return_status => x_return_status,
9258: x_msg_count => x_msg_count,
9259: x_msg_data => x_msg_data,
9260: p_cust_acct_id => l_cust_acct_id,
9275: RAISE OKL_API.G_EXCEPTION_ERROR;
9276: END IF;
9277:
9278: populate_tax_codes( p_api_version => p_api_version,
9279: p_init_msg_list => OKC_API.G_FALSE,
9280: x_return_status => x_return_status,
9281: x_msg_count => x_msg_count,
9282: x_msg_data => x_msg_data,
9283: p_prch_opt_det => l_ts_prch_opt_det,
9379: l_contract_streams_tbl(k).asset_number := l_name;-- populate asset num for subline as well
9380:
9381: get_location_party_ids(
9382: p_api_version => p_api_version,
9383: p_init_msg_list => OKC_API.G_FALSE,
9384: x_return_status => x_return_status,
9385: x_msg_count => x_msg_count,
9386: x_msg_data => x_msg_data,
9387: p_cust_acct_id => l_cust_acct_id,
9961: |
9962: *====================================================================================================================*/
9963: PROCEDURE process_quote_tax(
9964: p_api_version IN NUMBER,
9965: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
9966: x_return_status OUT NOCOPY VARCHAR2,
9967: x_msg_count OUT NOCOPY NUMBER,
9968: x_msg_data OUT NOCOPY VARCHAR2,
9969: p_source_trx_id IN NUMBER,
10152: l_early_term_yn, l_qtp_code, l_legal_entity_id,
10153: l_qrs_code;
10154: IF l_trxquotes_csr%NOTFOUND THEN
10155: -- source trx id is invalid
10156: OKC_API.set_message( p_app_name => 'OKC',
10157: p_msg_name => G_INVALID_VALUE,
10158: p_token1 => G_COL_NAME_TOKEN,
10159: p_token1_value => 'SOURCE_TRX_ID');
10160: RAISE OKL_API.G_EXCEPTION_ERROR;
10363: IF (l_lse_id = 33) THEN
10364: -- Get the financial asset level determinants
10365: get_asset_tax_params(
10366: p_api_version => p_api_version,
10367: p_init_msg_list => OKC_API.G_FALSE,
10368: x_return_status => x_return_status,
10369: x_msg_count => x_msg_count,
10370: x_msg_data => x_msg_data,
10371: p_khr_id => l_qte_khr_id,
10404: IF l_qtp_code LIKE 'TER%' THEN -- Ship to Location is not applicable for repurchase quote
10405: -- Get the ship_to and _bill_to identifiers
10406: get_location_party_ids(
10407: p_api_version => p_api_version,
10408: p_init_msg_list => OKC_API.G_FALSE,
10409: x_return_status => x_return_status,
10410: x_msg_count => x_msg_count,
10411: x_msg_data => x_msg_data,
10412: p_cust_acct_id => lx_cust_acct_id,
10501: IF l_fma_id IS NOT NULL THEN
10502: OPEN l_formulae_csr(l_fma_id);
10503: FETCH l_formulae_csr INTO l_formula_name;
10504: IF l_formulae_csr%NOTFOUND THEN
10505: OKC_API.set_message( p_app_name => 'OKC',
10506: p_msg_name => G_INVALID_VALUE,
10507: p_token1 => G_COL_NAME_TOKEN,
10508: p_token1_value => 'FMA_ID');
10509: RAISE OKL_API.G_EXCEPTION_ERROR;
10575: -- Populate tax sources record -- end
10576:
10577: populate_tax_info(
10578: p_api_version => p_api_version,
10579: p_init_msg_list => OKC_API.G_FALSE,
10580: x_return_status => x_return_status,
10581: x_msg_count => x_msg_count,
10582: x_msg_data => x_msg_data,
10583: p_prch_opt_det => lx_pb_prch_opt_det,
10925: |
10926: *=======================================================================*/
10927: PROCEDURE process_asset_loc_tax(
10928: p_api_version IN NUMBER,
10929: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
10930: x_return_status OUT NOCOPY VARCHAR2,
10931: x_msg_count OUT NOCOPY NUMBER,
10932: x_msg_data OUT NOCOPY VARCHAR2,
10933: p_source_trx_id IN NUMBER,
11211: OPEN l_trxassets_csr(p_source_trx_id, p_source_trx_name);
11212: FETCH l_trxassets_csr INTO l_alc_trx_type_id_det, l_trx_date, l_legal_entity_id;
11213: IF l_trxassets_csr%NOTFOUND THEN
11214: -- source trx id is invalid
11215: OKC_API.set_message( p_app_name => 'OKC',
11216: p_msg_name => G_INVALID_VALUE,
11217: p_token1 => G_COL_NAME_TOKEN,
11218: p_token1_value => 'SOURCE_TRX_ID');
11219: RAISE OKL_API.G_EXCEPTION_ERROR;
11225: -- get trx line details
11226: OPEN l_txlitminsts_csr(p_source_trx_id);
11227: FETCH l_txlitminsts_csr INTO l_inst_item_line_id, l_party_site_uses_id1, l_fin_asset_id;
11228: IF l_txlitminsts_csr%NOTFOUND THEN
11229: OKC_API.set_message( p_app_name => 'OKC',
11230: p_msg_name => G_REQUIRED_VALUE,
11231: p_token1 => G_COL_NAME_TOKEN,
11232: p_token1_value => 'PARTY_SITE_USES_ID1');
11233: RAISE OKL_API.G_EXCEPTION_ERROR;
11233: RAISE OKL_API.G_EXCEPTION_ERROR;
11234: END IF;
11235:
11236: IF l_fin_asset_id IS NULL THEN
11237: OKC_API.set_message( p_app_name => 'OKC',
11238: p_msg_name => G_REQUIRED_VALUE,
11239: p_token1 => G_COL_NAME_TOKEN,
11240: p_token1_value => 'DNZ_CLE_ID');
11241: RAISE OKL_API.G_EXCEPTION_ERROR;
11244:
11245: OPEN l_okcklines_csr(l_fin_asset_id);
11246: FETCH l_okcklines_csr INTO l_chr_id, l_name;
11247: IF l_okcklines_csr%NOTFOUND THEN
11248: OKC_API.set_message( p_app_name => 'OKC',
11249: p_msg_name => G_INVALID_VALUE,
11250: p_token1 => G_COL_NAME_TOKEN,
11251: p_token1_value => 'DNZ_CLE_ID');
11252: RAISE OKL_API.G_EXCEPTION_ERROR;
11256: -- get the new location id
11257: OPEN l_partysiteuses_csr(l_party_site_uses_id1);
11258: FETCH l_partysiteuses_csr INTO l_new_location_id,l_install_location_id;
11259: IF l_partysiteuses_csr%NOTFOUND THEN
11260: OKC_API.set_message( p_app_name => 'OKC',
11261: p_msg_name => G_REQUIRED_VALUE,
11262: p_token1 => G_COL_NAME_TOKEN,
11263: p_token1_value => 'LOCATION_ID');
11264: RAISE OKL_API.G_EXCEPTION_ERROR;
11420:
11421: -- get the asset level determinants
11422: get_asset_tax_params(
11423: p_api_version => p_api_version,
11424: p_init_msg_list => OKC_API.G_FALSE,
11425: x_return_status => x_return_status,
11426: x_msg_count => x_msg_count,
11427: x_msg_data => x_msg_data,
11428: p_khr_id => l_chr_id,
11456: CLOSE l_invitem_csr;
11457:
11458: -- get the Equipment Locationn (IB Loc)
11459: get_location_party_ids( p_api_version => p_api_version,
11460: p_init_msg_list => OKC_API.G_FALSE,
11461: x_return_status => x_return_status,
11462: x_msg_count => x_msg_count,
11463: x_msg_data => x_msg_data,
11464: p_cust_acct_id => lx_cust_acct_id,
11553:
11554: OPEN l_formulae_csr(l_fma_id);
11555: FETCH l_formulae_csr INTO l_formula_name;
11556: IF l_formulae_csr%NOTFOUND THEN
11557: OKC_API.set_message( p_app_name => 'OKC',
11558: p_msg_name => G_INVALID_VALUE,
11559: p_token1 => G_COL_NAME_TOKEN,
11560: p_token1_value => 'FMA_ID');
11561: RAISE OKL_API.G_EXCEPTION_ERROR;
11706: -- Populate tax sources record -- end
11707:
11708: populate_tax_info(
11709: p_api_version => p_api_version,
11710: p_init_msg_list => OKC_API.G_FALSE,
11711: x_return_status => x_return_status,
11712: x_msg_count => x_msg_count,
11713: x_msg_data => x_msg_data,
11714: p_prch_opt_det => lx_alc_prch_opt_det,
12165: |
12166: *=======================================================================*/
12167: PROCEDURE process_split_asset_tax(
12168: p_api_version IN NUMBER,
12169: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
12170: x_return_status OUT NOCOPY VARCHAR2,
12171: x_msg_count OUT NOCOPY NUMBER,
12172: x_msg_data OUT NOCOPY VARCHAR2,
12173: p_source_trx_id IN NUMBER,
12323: OPEN l_trxassets_csr(p_source_trx_id, p_source_trx_name);
12324: FETCH l_trxassets_csr INTO l_spl_trx_type_id, l_trx_date;
12325: IF l_trxassets_csr%NOTFOUND THEN
12326: -- source trx id is invalid
12327: OKC_API.set_message( p_app_name => 'OKC',
12328: p_msg_name => G_INVALID_VALUE,
12329: p_token1 => G_COL_NAME_TOKEN,
12330: p_token1_value => 'SOURCE_TRX_ID');
12331: RAISE OKL_API.G_EXCEPTION_ERROR;
12336: OPEN l_txlassets_csr(p_source_trx_id);
12337: FETCH l_txlassets_csr INTO l_txl_id, l_fin_asset_id, l_dnz_khr_id,
12338: l_asset_number, l_current_units;
12339: IF l_txlassets_csr%NOTFOUND THEN
12340: OKC_API.set_message( p_app_name => 'OKC',
12341: p_msg_name => G_REQUIRED_VALUE,
12342: p_token1 => G_COL_NAME_TOKEN,
12343: p_token1_value => 'Financial Asset');
12344: RAISE OKL_API.G_EXCEPTION_ERROR;
12344: RAISE OKL_API.G_EXCEPTION_ERROR;
12345: END IF;
12346:
12347: IF l_fin_asset_id IS NULL THEN
12348: OKC_API.set_message( p_app_name => 'OKC',
12349: p_msg_name => G_REQUIRED_VALUE,
12350: p_token1 => G_COL_NAME_TOKEN,
12351: p_token1_value => 'KLE_ID');
12352: RAISE OKL_API.G_EXCEPTION_ERROR;
12352: RAISE OKL_API.G_EXCEPTION_ERROR;
12353: END IF;
12354:
12355: IF l_current_units IS NULL THEN
12356: OKC_API.set_message( p_app_name => 'OKC',
12357: p_msg_name => G_REQUIRED_VALUE,
12358: p_token1 => G_COL_NAME_TOKEN,
12359: p_token1_value => 'CURRENT_UNITS');
12360: RAISE OKL_API.G_EXCEPTION_ERROR;
12365: IF l_dnz_khr_id IS NULL OR l_asset_number IS NULL THEN
12366: OPEN l_okcklines_csr(l_fin_asset_id);
12367: FETCH l_okcklines_csr INTO l_dnz_chr_id, l_name;
12368: IF l_okcklines_csr%NOTFOUND THEN
12369: OKC_API.set_message( p_app_name => 'OKC',
12370: p_msg_name => G_INVALID_VALUE,
12371: p_token1 => G_COL_NAME_TOKEN,
12372: p_token1_value => 'KLE_ID');
12373: RAISE OKL_API.G_EXCEPTION_ERROR;
12380:
12381: IF l_asset_number IS NULL THEN
12382: l_asset_number := l_name;
12383: IF l_asset_number IS NULL THEN
12384: OKC_API.set_message( p_app_name => 'OKC',
12385: p_msg_name => G_REQUIRED_VALUE,
12386: p_token1 => G_COL_NAME_TOKEN,
12387: p_token1_value => 'ASSET_NUMBER');
12388: RAISE OKL_API.G_EXCEPTION_ERROR;
12679: OPEN l_racusttrxtypes_csr;
12680: FETCH l_racusttrxtypes_csr INTO l_cust_trx_type_id;
12681: IF l_racusttrxtypes_csr%NOTFOUND THEN
12682: -- cust trx tyep id is required
12683: OKC_API.set_message( p_app_name => 'OKC',
12684: p_msg_name => G_REQUIRED_VALUE,
12685: p_token1 => G_COL_NAME_TOKEN,
12686: p_token1_value => 'CUST_TRX_TYPE_ID');
12687: RAISE OKL_API.G_EXCEPTION_ERROR;
12692: FETCH l_fndcurrency_csr INTO l_precision, l_minimum_accountable_unit; -- l_minimum_accountable_unit is optional in fnd_currencies
12693: -- but mandatory for tax team
12694: -- check with Nilesh
12695: IF l_fndcurrency_csr%NOTFOUND THEN
12696: OKC_API.set_message( p_app_name => 'OKC',
12697: p_msg_name => G_INVALID_VALUE,
12698: p_token1 => G_COL_NAME_TOKEN,
12699: p_token1_value => 'CURRENCY_CODE');
12700: RAISE OKL_API.G_EXCEPTION_ERROR;
13178: |
13179: *=======================================================================*/
13180: PROCEDURE process_booking_upfront_tax(
13181: p_api_version IN NUMBER,
13182: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
13183: x_return_status OUT NOCOPY VARCHAR2,
13184: x_msg_count OUT NOCOPY NUMBER,
13185: x_msg_data OUT NOCOPY VARCHAR2,
13186: p_source_trx_id IN NUMBER,
13474: FETCH l_trxcontracts_csr INTO l_bk_trx_type_id_det, l_khr_id, l_legal_entity_id;
13475: -- At this point, l_bk_trx_type_id_det will be the id of Booking trx type
13476: IF l_trxcontracts_csr%NOTFOUND THEN
13477: -- source trx id is invalid
13478: OKC_API.set_message( p_app_name => 'OKC',
13479: p_msg_name => G_INVALID_VALUE,
13480: p_token1 => G_COL_NAME_TOKEN,
13481: p_token1_value => 'SOURCE_TRX_ID');
13482: RAISE OKL_API.G_EXCEPTION_ERROR;
13489: FETCH l_trxcontracts_rbk_csr INTO l_khr_id, l_legal_entity_id;
13490: -- At this point, l_bk_trx_type_id_det will be the id of Booking trx type
13491: IF l_trxcontracts_rbk_csr%NOTFOUND THEN
13492: -- source trx id is invalid
13493: OKC_API.set_message( p_app_name => 'OKC',
13494: p_msg_name => G_INVALID_VALUE,
13495: p_token1 => G_COL_NAME_TOKEN,
13496: p_token1_value => 'SOURCE_TRX_ID');
13497: RAISE OKL_API.G_EXCEPTION_ERROR;
13507: l_tax_call_type := upper(p_tax_call_type);
13508:
13509: IF (l_tax_call_type IS NOT NULL AND
13510: l_tax_call_type NOT IN (G_ESTIMATED_CALL_TYPE, G_ACTUAL_CALL_TYPE)) THEN
13511: OKC_API.set_message( p_app_name => 'OKC',
13512: p_msg_name => G_INVALID_VALUE,
13513: p_token1 => G_COL_NAME_TOKEN,
13514: p_token1_value => 'TAX_CALL_TYPE');
13515: RAISE OKL_API.G_EXCEPTION_ERROR;
13620: IF l_fma_id IS NOT NULL THEN
13621: OPEN l_formulae_csr(l_fma_id);
13622: FETCH l_formulae_csr INTO l_formula_name;
13623: IF l_formulae_csr%NOTFOUND THEN
13624: OKC_API.set_message( p_app_name => 'OKC',
13625: p_msg_name => G_INVALID_VALUE,
13626: p_token1 => G_COL_NAME_TOKEN,
13627: p_token1_value => 'FMA_ID');
13628: RAISE OKL_API.G_EXCEPTION_ERROR;
13748:
13749: -- Get financial asset line level tax determinants --
13750: get_asset_tax_params(
13751: p_api_version => p_api_version,
13752: p_init_msg_list => OKC_API.G_FALSE,
13753: x_return_status => x_return_status,
13754: x_msg_count => x_msg_count,
13755: x_msg_data => x_msg_data,
13756: p_khr_id => l_khr_id,
13787:
13788: -- get the Location Party ID's
13789: get_location_party_ids(
13790: p_api_version => p_api_version,
13791: p_init_msg_list => OKC_API.G_FALSE,
13792: x_return_status => x_return_status,
13793: x_msg_count => x_msg_count,
13794: x_msg_data => x_msg_data,
13795: p_cust_acct_id => lx_cust_acct_id,
13958: -- Populate tax sources record -- end
13959:
13960: populate_tax_info(
13961: p_api_version => p_api_version,
13962: p_init_msg_list => OKC_API.G_FALSE,
13963: x_return_status => x_return_status,
13964: x_msg_count => x_msg_count,
13965: x_msg_data => x_msg_data,
13966: p_prch_opt_det => lx_pb_prch_opt_det,
14069:
14070: -- asset level call begin
14071: populate_tax_info(
14072: p_api_version => p_api_version,
14073: p_init_msg_list => OKC_API.G_FALSE,
14074: x_return_status => x_return_status,
14075: x_msg_count => x_msg_count,
14076: x_msg_data => x_msg_data,
14077: p_prch_opt_det => lx_pb_prch_opt_det,
14194: -- Populate tax sources record -- end
14195:
14196: populate_tax_info(
14197: p_api_version => p_api_version,
14198: p_init_msg_list => OKC_API.G_FALSE,
14199: x_return_status => x_return_status,
14200: x_msg_count => x_msg_count,
14201: x_msg_data => x_msg_data,
14202: p_prch_opt_det => lx_pb_prch_opt_det,
14309:
14310: -- asset level call begin
14311: populate_tax_info(
14312: p_api_version => p_api_version,
14313: p_init_msg_list => OKC_API.G_FALSE,
14314: x_return_status => x_return_status,
14315: x_msg_count => x_msg_count,
14316: x_msg_data => x_msg_data,
14317: p_prch_opt_det => lx_pb_prch_opt_det,
14442: -- Populate tax sources record -- end
14443:
14444: populate_tax_info(
14445: p_api_version => p_api_version,
14446: p_init_msg_list => OKC_API.G_FALSE,
14447: x_return_status => x_return_status,
14448: x_msg_count => x_msg_count,
14449: x_msg_data => x_msg_data,
14450: p_prch_opt_det => lx_pb_prch_opt_det,
14551:
14552: -- asset level call begin
14553: populate_tax_info(
14554: p_api_version => p_api_version,
14555: p_init_msg_list => OKC_API.G_FALSE,
14556: x_return_status => x_return_status,
14557: x_msg_count => x_msg_count,
14558: x_msg_data => x_msg_data,
14559: p_prch_opt_det => lx_pb_prch_opt_det,
14915: |
14916: *=======================================================================*/
14917: PROCEDURE process_pre_rbk_upfront_tax(
14918: p_api_version IN NUMBER,
14919: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
14920: x_return_status OUT NOCOPY VARCHAR2,
14921: x_msg_count OUT NOCOPY NUMBER,
14922: x_msg_data OUT NOCOPY VARCHAR2,
14923: p_source_trx_id IN NUMBER,
15052: |
15053: *=======================================================================*/
15054: PROCEDURE process_rebook_upfront_tax(
15055: p_api_version IN NUMBER,
15056: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
15057: x_return_status OUT NOCOPY VARCHAR2,
15058: x_msg_count OUT NOCOPY NUMBER,
15059: x_msg_data OUT NOCOPY VARCHAR2,
15060: p_source_trx_id IN NUMBER,
15177: 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
15178: -- At this point l_rbk_trx_type_id_det has the id of the Rebook trx type
15179: IF l_trxcontracts_csr%NOTFOUND THEN
15180: -- source trx id is invalid
15181: OKC_API.set_message( p_app_name => 'OKC',
15182: p_msg_name => G_INVALID_VALUE,
15183: p_token1 => G_COL_NAME_TOKEN,
15184: p_token1_value => 'SOURCE_TRX_ID');
15185: RAISE OKL_API.G_EXCEPTION_ERROR;
15474: -- Sync the parent contract kle_id's
15475: OPEN l_orig_kle_id(cp_kle_id => l_kle_id);
15476: FETCH l_orig_kle_id INTO l_sync_kle_id;
15477: IF l_orig_kle_id%NOTFOUND THEN
15478: OKC_API.set_message( p_app_name => 'OKC',
15479: p_msg_name => G_INVALID_VALUE,
15480: p_token1 => G_COL_NAME_TOKEN,
15481: p_token1_value => 'SOURCE_TRX_ID');
15482: RAISE OKL_API.G_EXCEPTION_ERROR;
15491: -- l_rbk_taxablelines_rec
15492: OPEN l_new_line_id(cp_orig_system_id => l_kle_id);
15493: FETCH l_new_line_id INTO l_sync_kle_id;
15494: IF l_new_line_id%NOTFOUND THEN
15495: OKC_API.set_message( p_app_name => 'OKC',
15496: p_msg_name => G_INVALID_VALUE,
15497: p_token1 => G_COL_NAME_TOKEN,
15498: p_token1_value => 'SOURCE_TRX_ID');
15499: RAISE OKL_API.G_EXCEPTION_ERROR;
15721: |
15722: *=======================================================================*/
15723: PROCEDURE process_quoting_upfront_tax(
15724: p_api_version IN NUMBER,
15725: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
15726: x_return_status OUT NOCOPY VARCHAR2,
15727: x_msg_count OUT NOCOPY NUMBER,
15728: x_msg_data OUT NOCOPY VARCHAR2,
15729: p_source_trx_id IN NUMBER,
16036: l_sq_age_of_equipment, l_parent_object_code, l_parent_object_id, l_legal_entity_id;
16037:
16038: IF l_leasequotes_csr%NOTFOUND THEN
16039: -- Source trx id is invalid
16040: OKC_API.set_message( p_app_name => 'OKC',
16041: p_msg_name => G_INVALID_VALUE,
16042: p_token1 => G_COL_NAME_TOKEN,
16043: p_token1_value => 'SOURCE_TRX_ID');
16044: RAISE OKL_API.G_EXCEPTION_ERROR;
16175: IF l_fma_id IS NOT NULL THEN
16176: OPEN l_formulae_csr(l_fma_id);
16177: FETCH l_formulae_csr INTO l_formula_name;
16178: IF l_formulae_csr%NOTFOUND THEN
16179: OKC_API.set_message( p_app_name => 'OKC',
16180: p_msg_name => G_INVALID_VALUE,
16181: p_token1 => G_COL_NAME_TOKEN,
16182: p_token1_value => 'FMA_ID');
16183: RAISE OKL_API.G_EXCEPTION_ERROR;
16194: OPEN l_racusttrxtypes_csr;
16195: FETCH l_racusttrxtypes_csr INTO l_cust_trx_type_id;
16196: IF l_racusttrxtypes_csr%NOTFOUND THEN
16197: -- Cust trx type id is required
16198: OKC_API.set_message( p_app_name => 'OKC',
16199: p_msg_name => G_REQUIRED_VALUE,
16200: p_token1 => G_COL_NAME_TOKEN,
16201: p_token1_value => 'CUST_TRX_TYPE_ID');
16202: RAISE OKL_API.G_EXCEPTION_ERROR;
16210: l_org_id, l_start_date, l_currency_conversion_type,
16211: l_currency_conversion_rate, l_currency_conversion_date,
16212: l_line_intended_use,l_deal_type;
16213: IF l_leaseopp_csr%NOTFOUND THEN
16214: OKC_API.set_message( p_app_name => 'OKC',
16215: p_msg_name => G_REQUIRED_VALUE,
16216: p_token1 => G_COL_NAME_TOKEN,
16217: p_token1_value => 'CURRENCY_CODE');
16218: RAISE OKL_API.G_EXCEPTION_ERROR;
16224: l_org_id, l_start_date, l_currency_conversion_type,
16225: l_currency_conversion_rate, l_currency_conversion_date,
16226: l_line_intended_use, l_deal_type;
16227: IF l_leaseapp_csr%NOTFOUND THEN
16228: OKC_API.set_message( p_app_name => 'OKC',
16229: p_msg_name => G_REQUIRED_VALUE,
16230: p_token1 => G_COL_NAME_TOKEN,
16231: p_token1_value => 'CURRENCY_CODE');
16232: RAISE OKL_API.G_EXCEPTION_ERROR;
16251: OPEN l_billtosite_csr(l_party_id);
16252: FETCH l_billtosite_csr INTO l_bill_to_siteuseid, l_bill_to_party_site_id,
16253: l_bill_to_party_id, l_bill_to_location_id;
16254: IF l_billtosite_csr%NOTFOUND THEN
16255: OKC_API.set_message( p_app_name => 'OKL',
16256: p_msg_name => 'OKL_TX_NO_SQ_BILL_TO');
16257: RAISE OKL_API.G_EXCEPTION_ERROR;
16258: END IF;
16259: CLOSE l_billtosite_csr ;
16262: OPEN l_fndcurrency_csr(l_currency_code);
16263: FETCH l_fndcurrency_csr INTO l_precision, l_minimum_accountable_unit;
16264: IF l_fndcurrency_csr%NOTFOUND THEN
16265: -- Currency code is invalid
16266: OKC_API.set_message( p_app_name => 'OKC',
16267: p_msg_name => G_INVALID_VALUE,
16268: p_token1 => G_COL_NAME_TOKEN,
16269: p_token1_value => 'CURRENCY_CODE');
16270: RAISE OKL_API.G_EXCEPTION_ERROR;
16441: -- Populate tax sources record -- end
16442:
16443: populate_tax_info(
16444: p_api_version => p_api_version,
16445: p_init_msg_list => OKC_API.G_FALSE,
16446: x_return_status => x_return_status,
16447: x_msg_count => x_msg_count,
16448: x_msg_data => x_msg_data,
16449: p_prch_opt_det => null, -- purchase option is not captured on Sales Quote
16552:
16553: -- asset level call begin
16554: populate_tax_info(
16555: p_api_version => p_api_version,
16556: p_init_msg_list => OKC_API.G_FALSE,
16557: x_return_status => x_return_status,
16558: x_msg_count => x_msg_count,
16559: x_msg_data => x_msg_data,
16560: p_prch_opt_det => null, -- purchase option is not captured on Sales Quote
16678: -- Populate tax sources record -- end
16679:
16680: populate_tax_info(
16681: p_api_version => p_api_version,
16682: p_init_msg_list => OKC_API.G_FALSE,
16683: x_return_status => x_return_status,
16684: x_msg_count => x_msg_count,
16685: x_msg_data => x_msg_data,
16686: p_prch_opt_det => null, -- purchase option is not captured on Sales Quote
16791:
16792: -- asset level call begin
16793: populate_tax_info(
16794: p_api_version => p_api_version,
16795: p_init_msg_list => OKC_API.G_FALSE,
16796: x_return_status => x_return_status,
16797: x_msg_count => x_msg_count,
16798: x_msg_data => x_msg_data,
16799: p_prch_opt_det => null, -- purchase option is not captured on Sales Quote
16923: -- Populate tax sources record -- end
16924:
16925: populate_tax_info(
16926: p_api_version => p_api_version,
16927: p_init_msg_list => OKC_API.G_FALSE,
16928: x_return_status => x_return_status,
16929: x_msg_count => x_msg_count,
16930: x_msg_data => x_msg_data,
16931: p_prch_opt_det => null, -- purchase option is not captured on Sales Quote
17034:
17035: -- asset level call begin
17036: populate_tax_info(
17037: p_api_version => p_api_version,
17038: p_init_msg_list => OKC_API.G_FALSE,
17039: x_return_status => x_return_status,
17040: x_msg_count => x_msg_count,
17041: x_msg_data => x_msg_data,
17042: p_prch_opt_det => null, -- purchase option is not captured on Sales Quote
17504: | 23-MAR-10 SMADHAVA 9327076 Calculate Upfront tax only if prior upfront tax calculation done
17505: *=======================================================================*/
17506: PROCEDURE calculate_sales_tax(
17507: p_api_version IN NUMBER,
17508: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
17509: x_return_status OUT NOCOPY VARCHAR2,
17510: x_msg_count OUT NOCOPY NUMBER,
17511: x_msg_data OUT NOCOPY VARCHAR2,
17512: p_source_trx_id IN NUMBER,
17743:
17744: IF (OKL_LA_SALES_TAX_PVT.check_prior_upfront_tax(l_chr_id)) THEN
17745:
17746: IF p_tax_call_type IS NULL THEN
17747: OKC_API.set_message( p_app_name => 'OKC',
17748: p_msg_name => G_REQUIRED_VALUE,
17749: p_token1 => G_COL_NAME_TOKEN,
17750: p_token1_value => 'Tax Call Type');
17751: RAISE OKL_API.G_EXCEPTION_ERROR;
17751: RAISE OKL_API.G_EXCEPTION_ERROR;
17752: ELSE
17753: l_tax_call_type := upper(p_tax_call_type);
17754: IF l_tax_call_type NOT IN (G_ESTIMATED_CALL_TYPE, G_ACTUAL_CALL_TYPE) THEN
17755: OKC_API.set_message( p_app_name => 'OKC',
17756: p_msg_name => G_INVALID_VALUE,
17757: p_token1 => G_COL_NAME_TOKEN,
17758: p_token1_value => 'Tax Call Type');
17759: RAISE OKL_API.G_EXCEPTION_ERROR;
17818:
17819: ELSIF ( p_source_trx_name = 'Booking') THEN
17820: IF l_ou_tax_upfront_yn = 'Y' THEN -- OU allows upfront type of call
17821: IF p_tax_call_type IS NULL THEN
17822: OKC_API.set_message( p_app_name => 'OKC',
17823: p_msg_name => G_REQUIRED_VALUE,
17824: p_token1 => G_COL_NAME_TOKEN,
17825: p_token1_value => 'Tax Call Type');
17826: RAISE OKL_API.G_EXCEPTION_ERROR;
17826: RAISE OKL_API.G_EXCEPTION_ERROR;
17827: ELSE
17828: l_tax_call_type := upper(p_tax_call_type);
17829: IF l_tax_call_type NOT IN (G_ESTIMATED_CALL_TYPE, G_ACTUAL_CALL_TYPE) THEN
17830: OKC_API.set_message( p_app_name => 'OKC',
17831: p_msg_name => G_INVALID_VALUE,
17832: p_token1 => G_COL_NAME_TOKEN,
17833: p_token1_value => 'Tax Call Type');
17834: RAISE OKL_API.G_EXCEPTION_ERROR;
18026: p_token1_value => 'Upfront Tax');
18027: END IF;
18028:
18029: ELSE
18030: OKC_API.set_message( p_app_name => 'OKC',
18031: p_msg_name => G_INVALID_VALUE,
18032: p_token1 => G_COL_NAME_TOKEN,
18033: p_token1_value => 'Transaction Type');
18034: RAISE OKL_API.G_EXCEPTION_ERROR;
19302: -- Validate source trx id
19303: OPEN l_billingdtls_csr(p_source_trx_id);
19304: FETCH l_billingdtls_csr INTO l_billingdtls_rec;
19305: IF l_billingdtls_csr %NOTFOUND THEN
19306: OKC_API.set_message( p_app_name => 'OKC',
19307: p_msg_name => G_INVALID_VALUE,
19308: p_token1 => G_COL_NAME_TOKEN,
19309: p_token1_value => 'SOURCE_TRX_ID');
19310: RAISE OKL_API.G_EXCEPTION_ERROR;
19533: FETCH l_oeorderlines_csr INTO l_inv_item_id, l_inv_item_org_id, lx_ship_to_siteuseid;
19534: -- ship_to_org_id from oe_order_lines_all is the site_use_id value from hz_cust_site_uses_all
19535: -- which is the ship_to_site_use_id
19536: IF l_oeorderlines_csr%NOTFOUND THEN
19537: OKC_API.set_message( p_app_name => 'OKC',
19538: p_msg_name => G_INVALID_VALUE,
19539: p_token1 => G_COL_NAME_TOKEN,
19540: p_token1_value => 'ISL_ID');
19541: RAISE OKL_API.G_EXCEPTION_ERROR;
19875: OPEN l_formulae_csr(l_fma_id);
19876: FETCH l_formulae_csr INTO l_formula_name;
19877:
19878: IF l_formulae_csr%NOTFOUND THEN
19879: OKC_API.set_message( p_app_name => 'OKC',
19880: p_msg_name => G_INVALID_VALUE,
19881: p_token1 => G_COL_NAME_TOKEN,
19882: p_token1_value => 'FMA_ID');
19883: RAISE OKL_API.G_EXCEPTION_ERROR;
20012: -- Validate source trx id
20013: OPEN l_disbdtls_csr(p_source_trx_id);
20014: FETCH l_disbdtls_csr INTO l_disbdtls_rec;
20015: IF l_disbdtls_csr %NOTFOUND THEN
20016: OKC_API.set_message( p_app_name => 'OKC',
20017: p_msg_name => G_INVALID_VALUE,
20018: p_token1 => G_COL_NAME_TOKEN,
20019: p_token1_value => 'SOURCE_TRX_ID');
20020: RAISE OKL_API.G_EXCEPTION_ERROR;
20335: OPEN l_formulae_csr(l_fma_id);
20336: FETCH l_formulae_csr INTO l_formula_name;
20337:
20338: IF l_formulae_csr%NOTFOUND THEN
20339: OKC_API.set_message( p_app_name => 'OKC',
20340: p_msg_name => G_INVALID_VALUE,
20341: p_token1 => G_COL_NAME_TOKEN,
20342: p_token1_value => 'FMA_ID');
20343: RAISE OKL_API.G_EXCEPTION_ERROR;
20464: x_tax_det_rec.x_user_defined_fisc_class := null;
20465: x_tax_det_rec.x_upstream_trx_reported_flag := null;
20466:
20467: ELSE
20468: OKC_API.set_message( p_app_name => 'OKC',
20469: p_msg_name => G_INVALID_VALUE,
20470: p_token1 => G_COL_NAME_TOKEN,
20471: p_token1_value => 'SOURCE_TRX_NAME');
20472: RAISE OKL_API.G_EXCEPTION_ERROR;
20996: IF (p_source_trx_name = 'Pre-Rebook') THEN
20997: OPEN l_trxcontracts_base_csr(p_source_trx_id, p_source_trx_name);
20998: IF l_trxcontracts_base_csr%NOTFOUND THEN
20999: -- source trx id is invalid
21000: OKC_API.set_message( p_app_name => 'OKC',
21001: p_msg_name => G_INVALID_VALUE,
21002: p_token1 => G_COL_NAME_TOKEN,
21003: p_token1_value => 'SOURCE_TRX_ID');
21004: RAISE OKL_API.G_EXCEPTION_ERROR;
21007: ELSIF (p_source_trx_name = 'Rebook') THEN
21008: OPEN l_trxcontracts_csr(p_source_trx_id, p_source_trx_name);
21009: IF l_trxcontracts_csr%NOTFOUND THEN
21010: -- source trx id is invalid
21011: OKC_API.set_message( p_app_name => 'OKC',
21012: p_msg_name => G_INVALID_VALUE,
21013: p_token1 => G_COL_NAME_TOKEN,
21014: p_token1_value => 'SOURCE_TRX_ID');
21015: RAISE OKL_API.G_EXCEPTION_ERROR;