DBA Data[Home] [Help]

APPS.OKL_AM_LEASE_TRMNT_PVT dependencies on OKL_TRX_CONTRACTS_PUB

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

3222: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'p_trn_mode = '||p_trn_mode);
3223: END IF;
3224: IF p_trn_mode = 'INSERT' THEN
3225: IF (is_debug_statement_on) THEN
3226: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling OKL_TRX_CONTRACTS_PUB.create_trx_contracts');
3227: END IF;
3228: -- insert transaction rec
3229: OKL_TRX_CONTRACTS_PUB.create_trx_contracts(
3230: p_api_version => p_api_version,

Line 3229: OKL_TRX_CONTRACTS_PUB.create_trx_contracts(

3225: IF (is_debug_statement_on) THEN
3226: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling OKL_TRX_CONTRACTS_PUB.create_trx_contracts');
3227: END IF;
3228: -- insert transaction rec
3229: OKL_TRX_CONTRACTS_PUB.create_trx_contracts(
3230: p_api_version => p_api_version,
3231: p_init_msg_list => OKL_API.G_FALSE,
3232: x_return_status => l_return_status,
3233: x_msg_count => x_msg_count,

Line 3238: 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);

3234: x_msg_data => x_msg_data,
3235: p_tcnv_rec => lp_tcnv_rec,
3236: x_tcnv_rec => lx_tcnv_rec);
3237: IF (is_debug_statement_on) THEN
3238: 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);
3239: END IF;
3240: ELSIF p_trn_mode = 'UPDATE' THEN
3241: IF (is_debug_statement_on) THEN
3242: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling OKL_TRX_CONTRACTS_PUB.update_trx_contracts');

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

3238: 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);
3239: END IF;
3240: ELSIF p_trn_mode = 'UPDATE' THEN
3241: IF (is_debug_statement_on) THEN
3242: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling OKL_TRX_CONTRACTS_PUB.update_trx_contracts');
3243: END IF;
3244:
3245: -- update transaction rec
3246: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(

Line 3246: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(

3242: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling OKL_TRX_CONTRACTS_PUB.update_trx_contracts');
3243: END IF;
3244:
3245: -- update transaction rec
3246: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(
3247: p_api_version => p_api_version,
3248: p_init_msg_list => OKL_API.G_FALSE,
3249: x_return_status => l_return_status,
3250: x_msg_count => x_msg_count,

Line 3255: 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);

3251: x_msg_data => x_msg_data,
3252: p_tcnv_rec => lp_tcnv_rec,
3253: x_tcnv_rec => lx_tcnv_rec);
3254: IF (is_debug_statement_on) THEN
3255: 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);
3256: END IF;
3257: END IF;
3258:
3259: -- rollback if error

Line 6192: lx_tcnv_tbl okl_trx_contracts_pub.tcnv_tbl_type;

6188: lp_ctxt_val_tbl okl_account_dist_pub.ctxt_val_tbl_type;
6189: lp_acc_gen_primary_key_tbl okl_account_dist_pub.acc_gen_primary_key;
6190: lx_template_tbl okl_account_dist_pub.avlv_tbl_type;
6191: lx_amount_tbl okl_account_dist_pub.amount_tbl_type;
6192: lx_tcnv_tbl okl_trx_contracts_pub.tcnv_tbl_type;
6193: l_catchup_rec okl_generate_accruals_pub.accrual_rec_type;
6194: l_lprv_rec okl_rev_loss_prov_pub.lprv_rec_type;
6195: l_trans_meaning VARCHAR2(200);
6196: lp_tclv_rec okl_trx_contracts_pub.tclv_rec_type;

Line 6196: lp_tclv_rec okl_trx_contracts_pub.tclv_rec_type;

6192: lx_tcnv_tbl okl_trx_contracts_pub.tcnv_tbl_type;
6193: l_catchup_rec okl_generate_accruals_pub.accrual_rec_type;
6194: l_lprv_rec okl_rev_loss_prov_pub.lprv_rec_type;
6195: l_trans_meaning VARCHAR2(200);
6196: lp_tclv_rec okl_trx_contracts_pub.tclv_rec_type;
6197: lx_tclv_rec okl_trx_contracts_pub.tclv_rec_type;
6198: li_tclv_rec okl_trx_contracts_pub.tclv_rec_type;
6199: i NUMBER;
6200: l_total_amount NUMBER := 0;

Line 6197: lx_tclv_rec okl_trx_contracts_pub.tclv_rec_type;

6193: l_catchup_rec okl_generate_accruals_pub.accrual_rec_type;
6194: l_lprv_rec okl_rev_loss_prov_pub.lprv_rec_type;
6195: l_trans_meaning VARCHAR2(200);
6196: lp_tclv_rec okl_trx_contracts_pub.tclv_rec_type;
6197: lx_tclv_rec okl_trx_contracts_pub.tclv_rec_type;
6198: li_tclv_rec okl_trx_contracts_pub.tclv_rec_type;
6199: i NUMBER;
6200: l_total_amount NUMBER := 0;
6201: lip_tmpl_identify_rec okl_account_dist_pub.tmpl_identify_rec_type;

Line 6198: li_tclv_rec okl_trx_contracts_pub.tclv_rec_type;

6194: l_lprv_rec okl_rev_loss_prov_pub.lprv_rec_type;
6195: l_trans_meaning VARCHAR2(200);
6196: lp_tclv_rec okl_trx_contracts_pub.tclv_rec_type;
6197: lx_tclv_rec okl_trx_contracts_pub.tclv_rec_type;
6198: li_tclv_rec okl_trx_contracts_pub.tclv_rec_type;
6199: i NUMBER;
6200: l_total_amount NUMBER := 0;
6201: lip_tmpl_identify_rec okl_account_dist_pub.tmpl_identify_rec_type;
6202: lix_template_tbl okl_account_dist_pub.avlv_tbl_type;

Line 6203: lip_tcnv_rec okl_trx_contracts_pub.tcnv_rec_type;

6199: i NUMBER;
6200: l_total_amount NUMBER := 0;
6201: lip_tmpl_identify_rec okl_account_dist_pub.tmpl_identify_rec_type;
6202: lix_template_tbl okl_account_dist_pub.avlv_tbl_type;
6203: lip_tcnv_rec okl_trx_contracts_pub.tcnv_rec_type;
6204: lix_tcnv_rec okl_trx_contracts_pub.tcnv_rec_type;
6205: l_product_type VARCHAR2(2000);
6206: l_line_number NUMBER := 1;
6207:

Line 6204: lix_tcnv_rec okl_trx_contracts_pub.tcnv_rec_type;

6200: l_total_amount NUMBER := 0;
6201: lip_tmpl_identify_rec okl_account_dist_pub.tmpl_identify_rec_type;
6202: lix_template_tbl okl_account_dist_pub.avlv_tbl_type;
6203: lip_tcnv_rec okl_trx_contracts_pub.tcnv_rec_type;
6204: lix_tcnv_rec okl_trx_contracts_pub.tcnv_rec_type;
6205: l_product_type VARCHAR2(2000);
6206: l_line_number NUMBER := 1;
6207:
6208: -- RMUNJULU 23-DEC-02 2726739 Added variables

Line 6368: l_tclv_tbl okl_trx_contracts_pub.tclv_tbl_type;

6364: --akrangan Bug 5514059 end
6365: --akrangan sla single accounting call to ae uptake starts
6366: l_org_id NUMBER(15);
6367: --txl contracts specific tbl types
6368: l_tclv_tbl okl_trx_contracts_pub.tclv_tbl_type;
6369: lx_tclv_tbl okl_trx_contracts_pub.tclv_tbl_type;
6370: --ae new table types declaration
6371: l_tmpl_identify_tbl okl_account_dist_pvt.tmpl_identify_tbl_type;
6372: l_dist_info_tbl okl_account_dist_pvt.dist_info_tbl_type;

Line 6369: lx_tclv_tbl okl_trx_contracts_pub.tclv_tbl_type;

6365: --akrangan sla single accounting call to ae uptake starts
6366: l_org_id NUMBER(15);
6367: --txl contracts specific tbl types
6368: l_tclv_tbl okl_trx_contracts_pub.tclv_tbl_type;
6369: lx_tclv_tbl okl_trx_contracts_pub.tclv_tbl_type;
6370: --ae new table types declaration
6371: l_tmpl_identify_tbl okl_account_dist_pvt.tmpl_identify_tbl_type;
6372: l_dist_info_tbl okl_account_dist_pvt.dist_info_tbl_type;
6373: l_ctxt_tbl okl_account_dist_pvt.ctxt_tbl_type;

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

6751: EXIT WHEN(i = lix_template_tbl.LAST);
6752: i := lix_template_tbl.NEXT(i);
6753: END LOOP;
6754: IF (is_debug_statement_on) THEN
6755: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling okl_trx_contracts_pub.create_trx_cntrct_lines');
6756: END IF;
6757: --create trx contract lines table
6758: okl_trx_contracts_pub.create_trx_cntrct_lines(p_api_version => p_api_version,
6759: p_init_msg_list => okl_api.g_false,

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

6754: IF (is_debug_statement_on) THEN
6755: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling okl_trx_contracts_pub.create_trx_cntrct_lines');
6756: END IF;
6757: --create trx contract lines table
6758: okl_trx_contracts_pub.create_trx_cntrct_lines(p_api_version => p_api_version,
6759: p_init_msg_list => okl_api.g_false,
6760: x_return_status => l_return_status,
6761: x_msg_count => x_msg_count,
6762: x_msg_data => x_msg_data,

Line 6766: 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);

6762: x_msg_data => x_msg_data,
6763: p_tclv_tbl => l_tclv_tbl,
6764: x_tclv_tbl => lx_tclv_tbl);
6765: IF (is_debug_statement_on) THEN
6766: 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);
6767: END IF;
6768:
6769: -- If error inserting line then set message
6770: IF l_return_status <> okl_api.g_ret_sts_success

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

6977: END LOOP;
6978: END IF;
6979: --call the api to update trx contracts hdr and lines
6980: IF (is_debug_statement_on) THEN
6981: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling okl_trx_contracts_pub.update_trx_contracts');
6982: END IF;
6983: okl_trx_contracts_pub.update_trx_contracts(p_api_version => p_api_version,
6984: p_init_msg_list => okl_api.g_false,
6985: x_return_status => l_return_status,

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

6979: --call the api to update trx contracts hdr and lines
6980: IF (is_debug_statement_on) THEN
6981: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling okl_trx_contracts_pub.update_trx_contracts');
6982: END IF;
6983: okl_trx_contracts_pub.update_trx_contracts(p_api_version => p_api_version,
6984: p_init_msg_list => okl_api.g_false,
6985: x_return_status => l_return_status,
6986: x_msg_count => x_msg_count,
6987: x_msg_data => x_msg_data,

Line 6994: 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);

6990: x_tcnv_rec => lix_tcnv_rec,
6991: x_tclv_tbl => lx_tclv_tbl);
6992: --handle exception
6993: IF (is_debug_statement_on) THEN
6994: 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);
6995: END IF;
6996: IF l_return_status <> okl_api.g_ret_sts_success
6997: THEN
6998: -- Error occurred when creating accounting entries for transaction TRX_TYPE.