DBA Data[Home] [Help]

APPS.OKL_AM_LEASE_TRMNT_PVT dependencies on OKL_TRX_CONTRACTS_PUB

Line 3342: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling OKL_TRX_CONTRACTS_PUB.create_trx_contracts');

3338: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'p_trn_mode = '||p_trn_mode);
3339: END IF;
3340: IF p_trn_mode = 'INSERT' THEN
3341: IF (is_debug_statement_on) THEN
3342: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling OKL_TRX_CONTRACTS_PUB.create_trx_contracts');
3343: END IF;
3344: -- insert transaction rec
3345: OKL_TRX_CONTRACTS_PUB.create_trx_contracts(
3346: p_api_version => p_api_version,

Line 3345: OKL_TRX_CONTRACTS_PUB.create_trx_contracts(

3341: IF (is_debug_statement_on) THEN
3342: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling OKL_TRX_CONTRACTS_PUB.create_trx_contracts');
3343: END IF;
3344: -- insert transaction rec
3345: OKL_TRX_CONTRACTS_PUB.create_trx_contracts(
3346: p_api_version => p_api_version,
3347: p_init_msg_list => OKL_API.G_FALSE,
3348: x_return_status => l_return_status,
3349: x_msg_count => x_msg_count,

Line 3354: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'called OKL_TRX_CONTRACTS_PUB.insert_trx_contracts l_return_status = '||l_return_status);

3350: x_msg_data => x_msg_data,
3351: p_tcnv_rec => lp_tcnv_rec,
3352: x_tcnv_rec => lx_tcnv_rec);
3353: IF (is_debug_statement_on) THEN
3354: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'called OKL_TRX_CONTRACTS_PUB.insert_trx_contracts l_return_status = '||l_return_status);
3355: END IF;
3356: ELSIF p_trn_mode = 'UPDATE' THEN
3357: IF (is_debug_statement_on) THEN
3358: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling OKL_TRX_CONTRACTS_PUB.update_trx_contracts');

Line 3358: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling OKL_TRX_CONTRACTS_PUB.update_trx_contracts');

3354: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'called OKL_TRX_CONTRACTS_PUB.insert_trx_contracts l_return_status = '||l_return_status);
3355: END IF;
3356: ELSIF p_trn_mode = 'UPDATE' THEN
3357: IF (is_debug_statement_on) THEN
3358: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling OKL_TRX_CONTRACTS_PUB.update_trx_contracts');
3359: END IF;
3360:
3361: -- update transaction rec
3362: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(

Line 3362: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(

3358: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling OKL_TRX_CONTRACTS_PUB.update_trx_contracts');
3359: END IF;
3360:
3361: -- update transaction rec
3362: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(
3363: p_api_version => p_api_version,
3364: p_init_msg_list => OKL_API.G_FALSE,
3365: x_return_status => l_return_status,
3366: x_msg_count => x_msg_count,

Line 3371: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'called OKL_TRX_CONTRACTS_PUB.update_trx_contracts l_return_status = '||l_return_status);

3367: x_msg_data => x_msg_data,
3368: p_tcnv_rec => lp_tcnv_rec,
3369: x_tcnv_rec => lx_tcnv_rec);
3370: IF (is_debug_statement_on) THEN
3371: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'called OKL_TRX_CONTRACTS_PUB.update_trx_contracts l_return_status = '||l_return_status);
3372: END IF;
3373: END IF;
3374:
3375: -- rollback if error

Line 6358: lx_tcnv_tbl okl_trx_contracts_pub.tcnv_tbl_type;

6354: lp_ctxt_val_tbl okl_account_dist_pub.ctxt_val_tbl_type;
6355: lp_acc_gen_primary_key_tbl okl_account_dist_pub.acc_gen_primary_key;
6356: lx_template_tbl okl_account_dist_pub.avlv_tbl_type;
6357: lx_amount_tbl okl_account_dist_pub.amount_tbl_type;
6358: lx_tcnv_tbl okl_trx_contracts_pub.tcnv_tbl_type;
6359: l_catchup_rec okl_generate_accruals_pub.accrual_rec_type;
6360: l_lprv_rec okl_rev_loss_prov_pub.lprv_rec_type;
6361: l_trans_meaning VARCHAR2(200);
6362: lp_tclv_rec okl_trx_contracts_pub.tclv_rec_type;

Line 6362: lp_tclv_rec okl_trx_contracts_pub.tclv_rec_type;

6358: lx_tcnv_tbl okl_trx_contracts_pub.tcnv_tbl_type;
6359: l_catchup_rec okl_generate_accruals_pub.accrual_rec_type;
6360: l_lprv_rec okl_rev_loss_prov_pub.lprv_rec_type;
6361: l_trans_meaning VARCHAR2(200);
6362: lp_tclv_rec okl_trx_contracts_pub.tclv_rec_type;
6363: lx_tclv_rec okl_trx_contracts_pub.tclv_rec_type;
6364: li_tclv_rec okl_trx_contracts_pub.tclv_rec_type;
6365: i NUMBER;
6366: l_total_amount NUMBER := 0;

Line 6363: lx_tclv_rec okl_trx_contracts_pub.tclv_rec_type;

6359: l_catchup_rec okl_generate_accruals_pub.accrual_rec_type;
6360: l_lprv_rec okl_rev_loss_prov_pub.lprv_rec_type;
6361: l_trans_meaning VARCHAR2(200);
6362: lp_tclv_rec okl_trx_contracts_pub.tclv_rec_type;
6363: lx_tclv_rec okl_trx_contracts_pub.tclv_rec_type;
6364: li_tclv_rec okl_trx_contracts_pub.tclv_rec_type;
6365: i NUMBER;
6366: l_total_amount NUMBER := 0;
6367: lip_tmpl_identify_rec okl_account_dist_pub.tmpl_identify_rec_type;

Line 6364: li_tclv_rec okl_trx_contracts_pub.tclv_rec_type;

6360: l_lprv_rec okl_rev_loss_prov_pub.lprv_rec_type;
6361: l_trans_meaning VARCHAR2(200);
6362: lp_tclv_rec okl_trx_contracts_pub.tclv_rec_type;
6363: lx_tclv_rec okl_trx_contracts_pub.tclv_rec_type;
6364: li_tclv_rec okl_trx_contracts_pub.tclv_rec_type;
6365: i NUMBER;
6366: l_total_amount NUMBER := 0;
6367: lip_tmpl_identify_rec okl_account_dist_pub.tmpl_identify_rec_type;
6368: lix_template_tbl okl_account_dist_pub.avlv_tbl_type;

Line 6369: lip_tcnv_rec okl_trx_contracts_pub.tcnv_rec_type;

6365: i NUMBER;
6366: l_total_amount NUMBER := 0;
6367: lip_tmpl_identify_rec okl_account_dist_pub.tmpl_identify_rec_type;
6368: lix_template_tbl okl_account_dist_pub.avlv_tbl_type;
6369: lip_tcnv_rec okl_trx_contracts_pub.tcnv_rec_type;
6370: lix_tcnv_rec okl_trx_contracts_pub.tcnv_rec_type;
6371: l_product_type VARCHAR2(2000);
6372: l_line_number NUMBER := 1;
6373:

Line 6370: lix_tcnv_rec okl_trx_contracts_pub.tcnv_rec_type;

6366: l_total_amount NUMBER := 0;
6367: lip_tmpl_identify_rec okl_account_dist_pub.tmpl_identify_rec_type;
6368: lix_template_tbl okl_account_dist_pub.avlv_tbl_type;
6369: lip_tcnv_rec okl_trx_contracts_pub.tcnv_rec_type;
6370: lix_tcnv_rec okl_trx_contracts_pub.tcnv_rec_type;
6371: l_product_type VARCHAR2(2000);
6372: l_line_number NUMBER := 1;
6373:
6374: -- RMUNJULU 23-DEC-02 2726739 Added variables

Line 6534: l_tclv_tbl okl_trx_contracts_pub.tclv_tbl_type;

6530: --akrangan Bug 5514059 end
6531: --akrangan sla single accounting call to ae uptake starts
6532: l_org_id NUMBER(15);
6533: --txl contracts specific tbl types
6534: l_tclv_tbl okl_trx_contracts_pub.tclv_tbl_type;
6535: lx_tclv_tbl okl_trx_contracts_pub.tclv_tbl_type;
6536: --ae new table types declaration
6537: l_tmpl_identify_tbl okl_account_dist_pvt.tmpl_identify_tbl_type;
6538: l_dist_info_tbl okl_account_dist_pvt.dist_info_tbl_type;

Line 6535: lx_tclv_tbl okl_trx_contracts_pub.tclv_tbl_type;

6531: --akrangan sla single accounting call to ae uptake starts
6532: l_org_id NUMBER(15);
6533: --txl contracts specific tbl types
6534: l_tclv_tbl okl_trx_contracts_pub.tclv_tbl_type;
6535: lx_tclv_tbl okl_trx_contracts_pub.tclv_tbl_type;
6536: --ae new table types declaration
6537: l_tmpl_identify_tbl okl_account_dist_pvt.tmpl_identify_tbl_type;
6538: l_dist_info_tbl okl_account_dist_pvt.dist_info_tbl_type;
6539: l_ctxt_tbl okl_account_dist_pvt.ctxt_tbl_type;

Line 6927: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling okl_trx_contracts_pub.create_trx_cntrct_lines');

6923: EXIT WHEN(i = lix_template_tbl.LAST);
6924: i := lix_template_tbl.NEXT(i);
6925: END LOOP;
6926: IF (is_debug_statement_on) THEN
6927: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling okl_trx_contracts_pub.create_trx_cntrct_lines');
6928: END IF;
6929: --create trx contract lines table
6930: okl_trx_contracts_pub.create_trx_cntrct_lines(p_api_version => p_api_version,
6931: p_init_msg_list => okl_api.g_false,

Line 6930: okl_trx_contracts_pub.create_trx_cntrct_lines(p_api_version => p_api_version,

6926: IF (is_debug_statement_on) THEN
6927: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling okl_trx_contracts_pub.create_trx_cntrct_lines');
6928: END IF;
6929: --create trx contract lines table
6930: okl_trx_contracts_pub.create_trx_cntrct_lines(p_api_version => p_api_version,
6931: p_init_msg_list => okl_api.g_false,
6932: x_return_status => l_return_status,
6933: x_msg_count => x_msg_count,
6934: x_msg_data => x_msg_data,

Line 6938: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'called okl_trx_contracts_pub.create_trx_cntrct_lines l_return_status = '||l_return_status);

6934: x_msg_data => x_msg_data,
6935: p_tclv_tbl => l_tclv_tbl,
6936: x_tclv_tbl => lx_tclv_tbl);
6937: IF (is_debug_statement_on) THEN
6938: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'called okl_trx_contracts_pub.create_trx_cntrct_lines l_return_status = '||l_return_status);
6939: END IF;
6940:
6941: -- If error inserting line then set message
6942: IF l_return_status <> okl_api.g_ret_sts_success

Line 7153: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling okl_trx_contracts_pub.update_trx_contracts');

7149: END LOOP;
7150: END IF;
7151: --call the api to update trx contracts hdr and lines
7152: IF (is_debug_statement_on) THEN
7153: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling okl_trx_contracts_pub.update_trx_contracts');
7154: END IF;
7155: okl_trx_contracts_pub.update_trx_contracts(p_api_version => p_api_version,
7156: p_init_msg_list => okl_api.g_false,
7157: x_return_status => l_return_status,

Line 7155: okl_trx_contracts_pub.update_trx_contracts(p_api_version => p_api_version,

7151: --call the api to update trx contracts hdr and lines
7152: IF (is_debug_statement_on) THEN
7153: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling okl_trx_contracts_pub.update_trx_contracts');
7154: END IF;
7155: okl_trx_contracts_pub.update_trx_contracts(p_api_version => p_api_version,
7156: p_init_msg_list => okl_api.g_false,
7157: x_return_status => l_return_status,
7158: x_msg_count => x_msg_count,
7159: x_msg_data => x_msg_data,

Line 7166: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'called okl_trx_contracts_pub.update_trx_contracts l_return_status = '||l_return_status);

7162: x_tcnv_rec => lix_tcnv_rec,
7163: x_tclv_tbl => lx_tclv_tbl);
7164: --handle exception
7165: IF (is_debug_statement_on) THEN
7166: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'called okl_trx_contracts_pub.update_trx_contracts l_return_status = '||l_return_status);
7167: END IF;
7168: IF l_return_status <> okl_api.g_ret_sts_success
7169: THEN
7170: -- Error occurred when creating accounting entries for transaction TRX_TYPE.