3175: p_api_version IN NUMBER
3176: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
3177: ,p_trxh_out_rec IN Okl_Trx_Contracts_Pvt.tcnv_rec_type
3178: ,p_tclv_tbl IN okl_trx_contracts_pvt.tclv_tbl_type
3179: ,p_acc_gen_tbl IN OUT NOCOPY okl_account_dist_pvt.ACC_GEN_TBL_TYPE
3180: ,p_tmpl_identify_tbl IN OUT NOCOPY okl_account_dist_pvt.tmpl_identify_tbl_type
3181: ,p_dist_info_tbl IN OUT NOCOPY okl_account_dist_pvt.dist_info_tbl_type
3182: ,x_return_status OUT NOCOPY VARCHAR2
3183: ,x_msg_count OUT NOCOPY NUMBER
3176: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
3177: ,p_trxh_out_rec IN Okl_Trx_Contracts_Pvt.tcnv_rec_type
3178: ,p_tclv_tbl IN okl_trx_contracts_pvt.tclv_tbl_type
3179: ,p_acc_gen_tbl IN OUT NOCOPY okl_account_dist_pvt.ACC_GEN_TBL_TYPE
3180: ,p_tmpl_identify_tbl IN OUT NOCOPY okl_account_dist_pvt.tmpl_identify_tbl_type
3181: ,p_dist_info_tbl IN OUT NOCOPY okl_account_dist_pvt.dist_info_tbl_type
3182: ,x_return_status OUT NOCOPY VARCHAR2
3183: ,x_msg_count OUT NOCOPY NUMBER
3184: ,x_msg_data OUT NOCOPY VARCHAR2)
3177: ,p_trxh_out_rec IN Okl_Trx_Contracts_Pvt.tcnv_rec_type
3178: ,p_tclv_tbl IN okl_trx_contracts_pvt.tclv_tbl_type
3179: ,p_acc_gen_tbl IN OUT NOCOPY okl_account_dist_pvt.ACC_GEN_TBL_TYPE
3180: ,p_tmpl_identify_tbl IN OUT NOCOPY okl_account_dist_pvt.tmpl_identify_tbl_type
3181: ,p_dist_info_tbl IN OUT NOCOPY okl_account_dist_pvt.dist_info_tbl_type
3182: ,x_return_status OUT NOCOPY VARCHAR2
3183: ,x_msg_count OUT NOCOPY NUMBER
3184: ,x_msg_data OUT NOCOPY VARCHAR2)
3185: IS
3229:
3230: l_custBillTo_rec custBillTo_csr%ROWTYPE;
3231:
3232: -- Cursors plucked from OKL_LA_JE_PVT for a/c - END
3233: l_acc_gen_primary_key_tbl okl_account_dist_pvt.acc_gen_primary_key;
3234: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;
3235: l_inv_acct_code OKC_RULES_B.Rule_Information1%TYPE;
3236:
3237: account_data_exception EXCEPTION;
3243: FROM okc_k_lines_b
3244: WHERE id = p_cle_id;
3245:
3246: l_assetBillTo_rec assetBillTo_csr%ROWTYPE;
3247: l_acc_gen_primary_key_tbl1 okl_account_dist_pvt.acc_gen_primary_key;
3248:
3249: BEGIN
3250:
3251: okl_debug_pub.logmessage('OKL: populate_account_data : START');
3740: l_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
3741: x_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
3742:
3743:
3744: l_tmpl_identify_rec okl_account_dist_pvt.tmpl_identify_rec_type;
3745: l_tmpl_identify_tbl okl_account_dist_pvt.tmpl_identify_tbl_type;
3746: l_template_tbl okl_account_dist_pvt.avlv_tbl_type;
3747: l_dist_info_tbl okl_account_dist_pvt.dist_info_tbl_type;
3748: l_template_out_tbl okl_account_dist_pvt.avlv_out_tbl_type;
3741: x_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
3742:
3743:
3744: l_tmpl_identify_rec okl_account_dist_pvt.tmpl_identify_rec_type;
3745: l_tmpl_identify_tbl okl_account_dist_pvt.tmpl_identify_tbl_type;
3746: l_template_tbl okl_account_dist_pvt.avlv_tbl_type;
3747: l_dist_info_tbl okl_account_dist_pvt.dist_info_tbl_type;
3748: l_template_out_tbl okl_account_dist_pvt.avlv_out_tbl_type;
3749: l_amount_tbl okl_account_dist_pvt.amount_out_tbl_type;
3742:
3743:
3744: l_tmpl_identify_rec okl_account_dist_pvt.tmpl_identify_rec_type;
3745: l_tmpl_identify_tbl okl_account_dist_pvt.tmpl_identify_tbl_type;
3746: l_template_tbl okl_account_dist_pvt.avlv_tbl_type;
3747: l_dist_info_tbl okl_account_dist_pvt.dist_info_tbl_type;
3748: l_template_out_tbl okl_account_dist_pvt.avlv_out_tbl_type;
3749: l_amount_tbl okl_account_dist_pvt.amount_out_tbl_type;
3750: l_ctxt_val_tbl okl_account_dist_pvt.CTXT_VAL_TBL_TYPE;
3743:
3744: l_tmpl_identify_rec okl_account_dist_pvt.tmpl_identify_rec_type;
3745: l_tmpl_identify_tbl okl_account_dist_pvt.tmpl_identify_tbl_type;
3746: l_template_tbl okl_account_dist_pvt.avlv_tbl_type;
3747: l_dist_info_tbl okl_account_dist_pvt.dist_info_tbl_type;
3748: l_template_out_tbl okl_account_dist_pvt.avlv_out_tbl_type;
3749: l_amount_tbl okl_account_dist_pvt.amount_out_tbl_type;
3750: l_ctxt_val_tbl okl_account_dist_pvt.CTXT_VAL_TBL_TYPE;
3751: l_acc_gen_tbl okl_account_dist_pvt.ACC_GEN_TBL_TYPE;
3744: l_tmpl_identify_rec okl_account_dist_pvt.tmpl_identify_rec_type;
3745: l_tmpl_identify_tbl okl_account_dist_pvt.tmpl_identify_tbl_type;
3746: l_template_tbl okl_account_dist_pvt.avlv_tbl_type;
3747: l_dist_info_tbl okl_account_dist_pvt.dist_info_tbl_type;
3748: l_template_out_tbl okl_account_dist_pvt.avlv_out_tbl_type;
3749: l_amount_tbl okl_account_dist_pvt.amount_out_tbl_type;
3750: l_ctxt_val_tbl okl_account_dist_pvt.CTXT_VAL_TBL_TYPE;
3751: l_acc_gen_tbl okl_account_dist_pvt.ACC_GEN_TBL_TYPE;
3752: l_ctxt_tbl okl_account_dist_pvt.CTXT_TBL_TYPE;
3745: l_tmpl_identify_tbl okl_account_dist_pvt.tmpl_identify_tbl_type;
3746: l_template_tbl okl_account_dist_pvt.avlv_tbl_type;
3747: l_dist_info_tbl okl_account_dist_pvt.dist_info_tbl_type;
3748: l_template_out_tbl okl_account_dist_pvt.avlv_out_tbl_type;
3749: l_amount_tbl okl_account_dist_pvt.amount_out_tbl_type;
3750: l_ctxt_val_tbl okl_account_dist_pvt.CTXT_VAL_TBL_TYPE;
3751: l_acc_gen_tbl okl_account_dist_pvt.ACC_GEN_TBL_TYPE;
3752: l_ctxt_tbl okl_account_dist_pvt.CTXT_TBL_TYPE;
3753:
3746: l_template_tbl okl_account_dist_pvt.avlv_tbl_type;
3747: l_dist_info_tbl okl_account_dist_pvt.dist_info_tbl_type;
3748: l_template_out_tbl okl_account_dist_pvt.avlv_out_tbl_type;
3749: l_amount_tbl okl_account_dist_pvt.amount_out_tbl_type;
3750: l_ctxt_val_tbl okl_account_dist_pvt.CTXT_VAL_TBL_TYPE;
3751: l_acc_gen_tbl okl_account_dist_pvt.ACC_GEN_TBL_TYPE;
3752: l_ctxt_tbl okl_account_dist_pvt.CTXT_TBL_TYPE;
3753:
3754: counter NUMBER := 0;
3747: l_dist_info_tbl okl_account_dist_pvt.dist_info_tbl_type;
3748: l_template_out_tbl okl_account_dist_pvt.avlv_out_tbl_type;
3749: l_amount_tbl okl_account_dist_pvt.amount_out_tbl_type;
3750: l_ctxt_val_tbl okl_account_dist_pvt.CTXT_VAL_TBL_TYPE;
3751: l_acc_gen_tbl okl_account_dist_pvt.ACC_GEN_TBL_TYPE;
3752: l_ctxt_tbl okl_account_dist_pvt.CTXT_TBL_TYPE;
3753:
3754: counter NUMBER := 0;
3755: j NUMBER := 0;
3748: l_template_out_tbl okl_account_dist_pvt.avlv_out_tbl_type;
3749: l_amount_tbl okl_account_dist_pvt.amount_out_tbl_type;
3750: l_ctxt_val_tbl okl_account_dist_pvt.CTXT_VAL_TBL_TYPE;
3751: l_acc_gen_tbl okl_account_dist_pvt.ACC_GEN_TBL_TYPE;
3752: l_ctxt_tbl okl_account_dist_pvt.CTXT_TBL_TYPE;
3753:
3754: counter NUMBER := 0;
3755: j NUMBER := 0;
3756: l_trx_id NUMBER;
4125: ,G_MODULE
4126: ,'OKL: create_upfront_tax_accounting Procedure: Calling Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST');
4127: END IF;
4128:
4129: okl_account_dist_pvt.create_accounting_dist(
4130: p_api_version => 1.0,
4131: p_init_msg_list => p_init_msg_list,
4132: x_return_status => x_return_status,
4133: x_msg_count => x_msg_count,
4363: ,G_MODULE
4364: ,'OKL: create_upfront_tax_accounting Procedure: Calling Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST');
4365: END IF;
4366:
4367: okl_debug_pub.logmessage('OKL: UPF A/C : before calling okl_account_dist_pvt');
4368:
4369: -- Call Accounting API to create distributions
4370: okl_account_dist_pvt.create_accounting_dist(
4371: p_api_version => 1.0,
4366:
4367: okl_debug_pub.logmessage('OKL: UPF A/C : before calling okl_account_dist_pvt');
4368:
4369: -- Call Accounting API to create distributions
4370: okl_account_dist_pvt.create_accounting_dist(
4371: p_api_version => 1.0,
4372: p_init_msg_list => p_init_msg_list,
4373: x_return_status => x_return_status,
4374: x_msg_count => x_msg_count,
4380: x_template_tbl => l_template_out_tbl,
4381: x_amount_tbl => l_amount_tbl,
4382: p_trx_header_id => l_trxh_out_rec.id);
4383:
4384: okl_debug_pub.logmessage('OKL: UPF A/C : after calling okl_account_dist_pvt : '|| x_return_status);
4385:
4386: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS)
4387: THEN
4388: RAISE upfront_tax_acct_exception;