DBA Data[Home] [Help]

APPS.OKS_MASS_UPD_PVT dependencies on OKC_CONTRACT_PUB

Line 570: l_clev_rec_in okc_contract_pub.clev_rec_type;

566: l_input_details OKS_QP_PKG.INPUT_DETAILS;
567: l_output_details OKS_QP_PKG.PRICE_DETAILS;
568: l_modif_details QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
569: l_pb_details OKS_QP_PKG.G_PRICE_BREAK_TBL_TYPE;
570: l_clev_rec_in okc_contract_pub.clev_rec_type;
571: l_clev_rec_out okc_contract_pub.clev_rec_type;
572: l_k_det_rec oks_qp_int_pvt.k_details_rec;
573: l_khrv_tbl_type_in oks_contract_hdr_pub.khrv_tbl_type;
574: l_khrv_tbl_type_out oks_contract_hdr_pub.khrv_tbl_type;

Line 571: l_clev_rec_out okc_contract_pub.clev_rec_type;

567: l_output_details OKS_QP_PKG.PRICE_DETAILS;
568: l_modif_details QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
569: l_pb_details OKS_QP_PKG.G_PRICE_BREAK_TBL_TYPE;
570: l_clev_rec_in okc_contract_pub.clev_rec_type;
571: l_clev_rec_out okc_contract_pub.clev_rec_type;
572: l_k_det_rec oks_qp_int_pvt.k_details_rec;
573: l_khrv_tbl_type_in oks_contract_hdr_pub.khrv_tbl_type;
574: l_khrv_tbl_type_out oks_contract_hdr_pub.khrv_tbl_type;
575: l_kln_rec_in oks_contract_line_pub.klnv_rec_type;

Line 685: 'before call to okc_contract_pub.update_contract_line ');

681: --update the new price amount
682: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
683: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
684: G_MODULE || l_api_name,
685: 'before call to okc_contract_pub.update_contract_line ');
686: END IF;
687: okc_contract_pub.update_contract_line(p_api_version => l_api_version,
688: p_init_msg_list => l_init_msg_list,
689: x_return_status => l_return_status,

Line 687: okc_contract_pub.update_contract_line(p_api_version => l_api_version,

683: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
684: G_MODULE || l_api_name,
685: 'before call to okc_contract_pub.update_contract_line ');
686: END IF;
687: okc_contract_pub.update_contract_line(p_api_version => l_api_version,
688: p_init_msg_list => l_init_msg_list,
689: x_return_status => l_return_status,
690: x_msg_count => l_msg_count,
691: x_msg_data => l_msg_data,

Line 698: 'after call to okc_contract_pub.update_contract_line ' ||

694:
695: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
696: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
697: G_MODULE || l_api_name,
698: 'after call to okc_contract_pub.update_contract_line ' ||
699: 'l_return_status -' || l_return_status);
700: END IF;
701:
702: FND_FILE.PUT_LINE(FND_FILE.Log,'after call to okc_contract_pub.update_contract_line AND l_return_status - ' ||l_return_status);

Line 702: FND_FILE.PUT_LINE(FND_FILE.Log,'after call to okc_contract_pub.update_contract_line AND l_return_status - ' ||l_return_status);

698: 'after call to okc_contract_pub.update_contract_line ' ||
699: 'l_return_status -' || l_return_status);
700: END IF;
701:
702: FND_FILE.PUT_LINE(FND_FILE.Log,'after call to okc_contract_pub.update_contract_line AND l_return_status - ' ||l_return_status);
703:
704: IF (l_return_status <> 'S') then
705: x_return_status := l_return_status;
706: oks_bill_rec_pub.get_message(l_msg_cnt => x_msg_count,

Line 1863: l_clev_tbl_kl_in okc_contract_pub.clev_tbl_type;

1859: l_return_status VARCHAR2(1);
1860: l_msg_count NUMBER;
1861: l_msg_data VARCHAR2(2000);
1862: --l_object_version_number NUMBER;
1863: l_clev_tbl_kl_in okc_contract_pub.clev_tbl_type;
1864: l_clev_tbl_kl_out okc_contract_pub.clev_tbl_type;
1865: l_clev_tbl_sl_in okc_contract_pub.clev_tbl_type;
1866: l_clev_tbl_sl_out okc_contract_pub.clev_tbl_type;
1867: L_KL_LSE_ID number;

Line 1864: l_clev_tbl_kl_out okc_contract_pub.clev_tbl_type;

1860: l_msg_count NUMBER;
1861: l_msg_data VARCHAR2(2000);
1862: --l_object_version_number NUMBER;
1863: l_clev_tbl_kl_in okc_contract_pub.clev_tbl_type;
1864: l_clev_tbl_kl_out okc_contract_pub.clev_tbl_type;
1865: l_clev_tbl_sl_in okc_contract_pub.clev_tbl_type;
1866: l_clev_tbl_sl_out okc_contract_pub.clev_tbl_type;
1867: L_KL_LSE_ID number;
1868: l_flag BOOLEAN;

Line 1865: l_clev_tbl_sl_in okc_contract_pub.clev_tbl_type;

1861: l_msg_data VARCHAR2(2000);
1862: --l_object_version_number NUMBER;
1863: l_clev_tbl_kl_in okc_contract_pub.clev_tbl_type;
1864: l_clev_tbl_kl_out okc_contract_pub.clev_tbl_type;
1865: l_clev_tbl_sl_in okc_contract_pub.clev_tbl_type;
1866: l_clev_tbl_sl_out okc_contract_pub.clev_tbl_type;
1867: L_KL_LSE_ID number;
1868: l_flag BOOLEAN;
1869: x_msg_tbl oks_attr_defaults_pvt.attr_msg_tbl_type;

Line 1866: l_clev_tbl_sl_out okc_contract_pub.clev_tbl_type;

1862: --l_object_version_number NUMBER;
1863: l_clev_tbl_kl_in okc_contract_pub.clev_tbl_type;
1864: l_clev_tbl_kl_out okc_contract_pub.clev_tbl_type;
1865: l_clev_tbl_sl_in okc_contract_pub.clev_tbl_type;
1866: l_clev_tbl_sl_out okc_contract_pub.clev_tbl_type;
1867: L_KL_LSE_ID number;
1868: l_flag BOOLEAN;
1869: x_msg_tbl oks_attr_defaults_pvt.attr_msg_tbl_type;
1870: x_msg_data VARCHAR2(1000);

Line 2210: fnd_file.put_line (fnd_file.log,l_api_name || ' Before Calling : okc_contract_pub.update_contract_line');

2206:
2207: IF l_clev_tbl_kl_in(j).exception_yn <> 'Y' THEN
2208: BEGIN
2209: DBMS_TRANSACTION.SAVEPOINT('MASS_UPDATE_EFFECTIVITY');
2210: fnd_file.put_line (fnd_file.log,l_api_name || ' Before Calling : okc_contract_pub.update_contract_line');
2211:
2212: okc_contract_pub.update_contract_line(p_api_version => l_api_version,
2213: p_init_msg_list => l_init_msg_list,
2214: x_return_status => l_return_status,

Line 2212: okc_contract_pub.update_contract_line(p_api_version => l_api_version,

2208: BEGIN
2209: DBMS_TRANSACTION.SAVEPOINT('MASS_UPDATE_EFFECTIVITY');
2210: fnd_file.put_line (fnd_file.log,l_api_name || ' Before Calling : okc_contract_pub.update_contract_line');
2211:
2212: okc_contract_pub.update_contract_line(p_api_version => l_api_version,
2213: p_init_msg_list => l_init_msg_list,
2214: x_return_status => l_return_status,
2215: x_msg_count => l_msg_count,
2216: x_msg_data => l_msg_data,

Line 2220: fnd_file.put_line (fnd_file.log,l_api_name || ' After Calling : okc_contract_pub.update_contract_line');

2216: x_msg_data => l_msg_data,
2217: p_restricted_update => 'F',
2218: p_clev_rec => l_clev_tbl_kl_in(j),
2219: X_CLEV_rec => l_clev_tbl_kl_out(j));
2220: fnd_file.put_line (fnd_file.log,l_api_name || ' After Calling : okc_contract_pub.update_contract_line');
2221:
2222: IF (l_return_status <> 'S') then
2223: x_return_status := l_return_status;
2224: oks_bill_rec_pub.get_message(l_msg_cnt => x_msg_count,

Line 2264: ' Error from okc_contract_pub.update_contract_line procedure' ||

2260: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('MASS_UPDATE_EFFECTIVITY');
2261: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2262: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2263: l_api_name,
2264: ' Error from okc_contract_pub.update_contract_line procedure' ||
2265: SQLERRM);
2266: END IF;
2267: x_overall_status := 'W';
2268: END;

Line 2408: fnd_file.put_line (fnd_file.log,l_api_name || ' Before Calling okc_contract_pub.update_contract_line');

2404: fnd_file.put_line (fnd_file.log,l_api_name || ' Processing SubLine Id:' || To_Char(l_clev_tbl_sl_in(k).id));
2405:
2406: -- Resetting before calling the update package only for sublines
2407: l_clev_tbl_sl_in(k).CHR_id := NULL;
2408: fnd_file.put_line (fnd_file.log,l_api_name || ' Before Calling okc_contract_pub.update_contract_line');
2409: okc_contract_pub.update_contract_line(p_api_version => l_api_version,
2410: p_init_msg_list => l_init_msg_list,
2411: x_return_status => l_return_status,
2412: x_msg_count => l_msg_count,

Line 2409: okc_contract_pub.update_contract_line(p_api_version => l_api_version,

2405:
2406: -- Resetting before calling the update package only for sublines
2407: l_clev_tbl_sl_in(k).CHR_id := NULL;
2408: fnd_file.put_line (fnd_file.log,l_api_name || ' Before Calling okc_contract_pub.update_contract_line');
2409: okc_contract_pub.update_contract_line(p_api_version => l_api_version,
2410: p_init_msg_list => l_init_msg_list,
2411: x_return_status => l_return_status,
2412: x_msg_count => l_msg_count,
2413: x_msg_data => l_msg_data,

Line 2417: fnd_file.put_line (fnd_file.log,l_api_name || ' After Calling okc_contract_pub.update_contract_line');

2413: x_msg_data => l_msg_data,
2414: p_restricted_update => 'F',
2415: p_clev_rec => l_clev_tbl_sl_in(k),
2416: X_CLEV_rec => l_clev_tbl_sl_out(k));
2417: fnd_file.put_line (fnd_file.log,l_api_name || ' After Calling okc_contract_pub.update_contract_line');
2418:
2419:
2420: EXCEPTION
2421: when OTHERS THEN

Line 2425: ' Exception from okc_contract_pub.update_contract_line, Error is: ' ||

2421: when OTHERS THEN
2422: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2423: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2424: l_api_name,
2425: ' Exception from okc_contract_pub.update_contract_line, Error is: ' ||
2426: SQLERRM);
2427: END IF;
2428: END;
2429: