705: IS
706: l_api_version CONSTANT NUMBER := 1.0;
707: l_api_name CONSTANT VARCHAR2 (50)
708: := 'update_contract_status';
709: l_chrv_rec okc_contract_pub.chrv_rec_type;
710: x_chrv_rec okc_contract_pub.chrv_rec_type;
711: l_clev_rec okc_contract_pub.clev_rec_type;
712: x_clev_rec okc_contract_pub.clev_rec_type;
713: l_return_status VARCHAR2 (1)
706: l_api_version CONSTANT NUMBER := 1.0;
707: l_api_name CONSTANT VARCHAR2 (50)
708: := 'update_contract_status';
709: l_chrv_rec okc_contract_pub.chrv_rec_type;
710: x_chrv_rec okc_contract_pub.chrv_rec_type;
711: l_clev_rec okc_contract_pub.clev_rec_type;
712: x_clev_rec okc_contract_pub.clev_rec_type;
713: l_return_status VARCHAR2 (1)
714: := okc_api.g_ret_sts_success;
707: l_api_name CONSTANT VARCHAR2 (50)
708: := 'update_contract_status';
709: l_chrv_rec okc_contract_pub.chrv_rec_type;
710: x_chrv_rec okc_contract_pub.chrv_rec_type;
711: l_clev_rec okc_contract_pub.clev_rec_type;
712: x_clev_rec okc_contract_pub.clev_rec_type;
713: l_return_status VARCHAR2 (1)
714: := okc_api.g_ret_sts_success;
715: l_msg_data VARCHAR2 (2000);
708: := 'update_contract_status';
709: l_chrv_rec okc_contract_pub.chrv_rec_type;
710: x_chrv_rec okc_contract_pub.chrv_rec_type;
711: l_clev_rec okc_contract_pub.clev_rec_type;
712: x_clev_rec okc_contract_pub.clev_rec_type;
713: l_return_status VARCHAR2 (1)
714: := okc_api.g_ret_sts_success;
715: l_msg_data VARCHAR2 (2000);
716: l_msg_count NUMBER;
788: (fnd_log.level_event,
789: g_module ||
790: l_api_name ||
791: '.external_call.before',
792: 'OKC_CONTRACT_PUB.update_contract_header(p_chr_id=' ||
793: p_chr_id ||
794: ')'
795: );
796: END IF;
800: l_chrv_rec.term_cancel_source := 'CUSTOMER';
801: l_chrv_rec.trn_code := 'NFC';
802: l_chrv_rec.new_ste_code := 'CANCELLED';
803: /*commented and modified for bug8345674
804: okc_contract_pub.update_contract_header
805: (p_api_version => l_api_version,
806: p_init_msg_list => okc_api.g_false,
807: x_return_status => l_return_status,
808: x_msg_count => l_msg_count,
835: SET renewal_status = 'QUOTE_CNCLD'
836: WHERE chr_id = p_chr_id;
837: /*end of bug8345674*/
838: ELSE
839: okc_contract_pub.update_contract_header
840: (p_api_version => l_api_version,
841: p_init_msg_list => okc_api.g_false,
842: x_return_status => l_return_status,
843: x_msg_count => l_msg_count,
854: (fnd_log.level_event,
855: g_module ||
856: l_api_name ||
857: '.external_call.after',
858: 'OKC_CONTRACT_PUB.update_contract_header(x_return_status= ' ||
859: l_return_status ||
860: ' l_msg_count =' ||
861: l_msg_count ||
862: ')'
876: fnd_log.STRING (fnd_log.level_event,
877: g_module ||
878: l_api_name ||
879: '.external_call.before',
880: 'OKC_CONTRACT_PUB.update_contract_line - Loop begin'
881: );
882: END IF;
883:
884: l_clev_rec.sts_code := p_status;
898: l_lines_rec.ID
899: );
900: END IF;
901:
902: okc_contract_pub.update_contract_line
903: (p_api_version => l_api_version,
904: p_init_msg_list => okc_api.g_false,
905: x_return_status => l_return_status,
906: x_msg_count => l_msg_count,
950: l_clev_rec.date_cancelled := SYSDATE;
951: l_clev_rec.term_cancel_source := 'CUSTOMER';
952: l_clev_rec.trn_code := 'NFC';
953: l_clev_rec.new_ste_code := 'CANCELLED';
954: okc_contract_pub.update_contract_line
955: (p_api_version => l_api_version,
956: p_init_msg_list => okc_api.g_false,
957: x_return_status => l_return_status,
958: x_msg_count => l_msg_count,
963: );
964: */
965: NULL;
966: ELSE
967: okc_contract_pub.update_contract_line
968: (p_api_version => l_api_version,
969: p_init_msg_list => okc_api.g_false,
970: x_return_status => l_return_status,
971: x_msg_count => l_msg_count,
1000: fnd_log.STRING (fnd_log.level_event,
1001: g_module ||
1002: l_api_name ||
1003: '.external_call.after',
1004: 'OKC_CONTRACT_PUB.update_contract_line - loop end'
1005: );
1006: END IF;
1007: EXCEPTION
1008: WHEN fnd_api.g_exc_error
2295: -- STEP 1: Check for active workflow processes
2296: IF x_is_eligible = 'Y' THEN
2297: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2298: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2299: 'okc_contract_pub.get_active_process(p_contract_number= '||
2300: l_k_details_rec.contract_number||
2301: ' p_contract_number_modifier ='||l_k_details_rec.contract_number_modifier||')');
2302: END IF;
2303: okc_contract_pub.get_active_process
2299: 'okc_contract_pub.get_active_process(p_contract_number= '||
2300: l_k_details_rec.contract_number||
2301: ' p_contract_number_modifier ='||l_k_details_rec.contract_number_modifier||')');
2302: END IF;
2303: okc_contract_pub.get_active_process
2304: (
2305: p_api_version => 1.0,
2306: p_init_msg_list => 'Y',
2307: x_return_status => x_return_status,
2316: x_usage => l_usage
2317: );
2318: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2319: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
2320: 'okc_contract_pub.get_active_process(x_return_status= '||x_return_status||
2321: ' x_msg_count ='||x_msg_count||')');
2322: END IF;
2323:
2324: /*BUG6956935*/