APPS.OKL_INS_QUOTE_PVT dependencies on OKL_INS_QUOTE_PVT

Line 1: PACKAGE BODY OKL_INS_QUOTE_PVT AS

1: PACKAGE BODY OKL_INS_QUOTE_PVT AS
2: /* $Header: OKLRINQB.pls 120.55.12010000.2 2008/09/10 17:46:40 rkuttiya ship $ */
3: -- Start of wraper code generated automatically by Debug code generator
4: L_MODULE VARCHAR2(40) := 'LEASE.INSURANCE';
5: L_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;

Line 4994: x_message := OKL_INS_QUOTE_PVT.G_NO_INS ;

4990: l_max_deal := fnd_profile.value('OKLINMAXDEALSIZE');
4991: IF ((l_max_deal IS NULL ) OR (l_max_deal = OKC_API.G_MISS_NUM )) THEN
4992: x_return_status := OKC_API.G_RET_STS_ERROR;
4993: OKC_API.set_message(G_APP_NAME, G_NO_SYSTEM_PROFILE,G_SYS_PROFILE_NAME,'OKLINMAXDEALSIZE' );
4994: x_message := OKL_INS_QUOTE_PVT.G_NO_INS ;
4995: RAISE OKC_API.G_EXCEPTION_ERROR;
4996: END IF ;
4997:
4998: ---- Get deal amount in functional Currency

Line 5019: x_message := OKL_INS_QUOTE_PVT.G_NO_INS ;

5015:
5016: OKC_API.set_message(G_APP_NAME, G_NO_INSURANCE,G_COL_NAME_TOKEN,
5017: l_contract_number,'SYS_VALUE', 'Maximum Deal Amount' );
5018: x_return_status := OKC_API.G_RET_STS_ERROR;
5019: x_message := OKL_INS_QUOTE_PVT.G_NO_INS ;
5020: -- Message --
5021: RAISE OKC_API.G_EXCEPTION_ERROR;
5022: END IF;
5023: -- Get deal term in months

Line 5056: x_message := OKL_INS_QUOTE_PVT.G_NO_INS ;

5052: END IF ;
5053:
5054: -- Business Rule for term for which we can sell insurance
5055: IF ( (l_deal_size >l_max_term) OR (l_deal_size < l_min_term) ) THEN
5056: x_message := OKL_INS_QUOTE_PVT.G_NO_INS ;
5057:
5058: OKC_API.set_message(G_APP_NAME, G_NO_INSURANCE,G_COL_NAME_TOKEN,
5059: l_contract_number,'SYS_VALUE', 'Deal Term' );
5060: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 5126: x_message := OKL_INS_QUOTE_PVT.G_NOT_ABLE ;

5122: -- inventory org change
5123: OPEN okl_k_product_csr(px_ipyv_rec.ISU_ID,l_fun_total_oec,px_ipyv_rec.date_from ,l_inv_org_id );
5124: FETCH okl_k_product_csr INTO l_product, l_product_name ;
5125: IF(okl_k_product_csr%NOTFOUND) THEN
5126: x_message := OKL_INS_QUOTE_PVT.G_NOT_ABLE ;
5127: OKC_API.set_message(G_APP_NAME, 'OKL_NO_INSPRODUCT',
5128: G_COL_NAME_TOKEN,l_contract_number );
5129: IF okl_k_product_csr%ISOPEN THEN
5130: CLOSE okl_k_product_csr;

Line 5221: x_message := OKL_INS_QUOTE_PVT.G_NOT_ABLE ;

5217: l_func_oec,l_product,
5218: l_ins_class , px_ipyv_rec.DATE_FROM, l_freq_factor );
5219: FETCH okl_ins_rate_csr INTO l_func_premium, l_func_lessor_premium ;
5220: IF(okl_ins_rate_csr%NOTFOUND) THEN
5221: x_message := OKL_INS_QUOTE_PVT.G_NOT_ABLE ;
5222: OKC_API.set_message(G_APP_NAME, 'OKL_NO_INSPRODUCT_RATE',
5223: G_COL_NAME_TOKEN,l_contract_number );
5224: IF okl_ins_rate_csr%ISOPEN THEN
5225: CLOSE okl_ins_rate_csr;

Line 6062: activated_pol_tbl OKL_INS_QUOTE_PVT.policy_tbl_type ;

6058: l_afterlease_criteria NUMBER ;
6059:
6060: l_policy_id NUMBER;
6061: l_policy_number VARCHAR2(50);
6062: activated_pol_tbl OKL_INS_QUOTE_PVT.policy_tbl_type ;
6063: nonactivated_pol_tbl OKL_INS_QUOTE_PVT.policy_tbl_type;
6064: l_activated_counter NUMBER := 0;
6065: l_notactivated_counter NUMBER := 0;
6066: l_khr_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR ;

Line 6063: nonactivated_pol_tbl OKL_INS_QUOTE_PVT.policy_tbl_type;

6059:
6060: l_policy_id NUMBER;
6061: l_policy_number VARCHAR2(50);
6062: activated_pol_tbl OKL_INS_QUOTE_PVT.policy_tbl_type ;
6063: nonactivated_pol_tbl OKL_INS_QUOTE_PVT.policy_tbl_type;
6064: l_activated_counter NUMBER := 0;
6065: l_notactivated_counter NUMBER := 0;
6066: l_khr_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR ;
6067:

Line 7952: END Okl_Ins_Quote_Pvt;

7948: x_msg_data,
7949: '_PROCESS'
7950: );
7951: END accept_quote;
7952: END Okl_Ins_Quote_Pvt;