eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_RENEW_CONTRACT_PVT dependencies on OKS_RENEW_UTIL_PVT

Line 3453: p_rnrl_rec IN OKS_RENEW_UTIL_PVT.rnrl_rec_type,

3449: */
3450: PROCEDURE UPDATE_RENEWED_CONTRACT
3451: (
3452: p_chr_id IN NUMBER,
3453: p_rnrl_rec IN OKS_RENEW_UTIL_PVT.rnrl_rec_type,
3454: p_notify_to IN NUMBER,
3455: x_msg_count OUT NOCOPY NUMBER,
3456: x_msg_data OUT NOCOPY VARCHAR2,
3457: x_return_status OUT NOCOPY VARCHAR2

Line 3539: OKS_RENEW_UTIL_PVT.log_rules(l_mod_name || '.effective_renewal_rules', p_rnrl_rec);

3535:
3536: --log key input parameters
3537: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
3538: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_chr_id=' || p_chr_id);
3539: OKS_RENEW_UTIL_PVT.log_rules(l_mod_name || '.effective_renewal_rules', p_rnrl_rec);
3540: END IF;
3541: x_return_status := FND_API.G_RET_STS_SUCCESS;
3542:
3543: OPEN c_k_hdr(p_chr_id);

Line 3589: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.determine_renewal_type', 'calling OKS_RENEW_UTIL_PVT.get_renewal_type');

3585: END IF;
3586:
3587: --determine the renewal type and corresponding approval type
3588: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3589: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.determine_renewal_type', 'calling OKS_RENEW_UTIL_PVT.get_renewal_type');
3590: END IF;
3591: OKS_RENEW_UTIL_PVT.get_renewal_type(
3592: p_api_version => 1,
3593: p_init_msg_list => FND_API.G_FALSE,

Line 3591: OKS_RENEW_UTIL_PVT.get_renewal_type(

3587: --determine the renewal type and corresponding approval type
3588: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3589: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.determine_renewal_type', 'calling OKS_RENEW_UTIL_PVT.get_renewal_type');
3590: END IF;
3591: OKS_RENEW_UTIL_PVT.get_renewal_type(
3592: p_api_version => 1,
3593: p_init_msg_list => FND_API.G_FALSE,
3594: x_return_status => x_return_status,
3595: x_msg_count => x_msg_count,

Line 3606: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.determine_renewal_type', 'after call to OKS_RENEW_UTIL_PVT.get_renewal_type, x_renewal_type='||l_renewal_type||

3602: x_approval_type => l_approval_type,
3603: x_threshold_used => l_threshold_used);
3604:
3605: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3606: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.determine_renewal_type', 'after call to OKS_RENEW_UTIL_PVT.get_renewal_type, x_renewal_type='||l_renewal_type||
3607: ' ,x_approval_type='||l_approval_type||' ,x_threshold_used='||l_threshold_used);
3608: END IF;
3609:
3610: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 3913: x_rnrl_rec OUT NOCOPY OKS_RENEW_UTIL_PVT.rnrl_rec_type,

3909: x_msg_data OUT NOCOPY VARCHAR2,
3910: p_chr_id IN NUMBER,
3911: p_date IN DATE,
3912: p_validation_level IN VARCHAR2 DEFAULT G_VALIDATE_ALL,
3913: x_rnrl_rec OUT NOCOPY OKS_RENEW_UTIL_PVT.rnrl_rec_type,
3914: x_validation_status OUT NOCOPY VARCHAR2,
3915: x_validation_tbl OUT NOCOPY validation_tbl_type
3916: )
3917: IS

Line 4009: l_rnrl_rec OKS_RENEW_UTIL_PVT.rnrl_rec_type;

4005: l_k_template_yn okc_k_headers_b.template_yn%TYPE;
4006: l_k_date_terminated okc_k_headers_b.date_terminated%TYPE;
4007: l_k_date_renewed okc_k_headers_b.date_renewed%TYPE;
4008: l_k_end_date okc_k_headers_b.end_date%TYPE;
4009: l_rnrl_rec OKS_RENEW_UTIL_PVT.rnrl_rec_type;
4010:
4011: l_date DATE;
4012: l_k_num_mod VARCHAR2(250);
4013: l_msg_count INTEGER := 0;

Line 4198: OKS_RENEW_UTIL_PVT.get_renew_rules(

4194: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
4195: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.calling_get_renew_rules', 'p_chr_id=' || p_chr_id ||', p_date='|| l_date);
4196: END IF;
4197:
4198: OKS_RENEW_UTIL_PVT.get_renew_rules(
4199: x_return_status => x_return_status,
4200: p_api_version => 1.0,
4201: p_init_msg_list => FND_API.G_FALSE,
4202: p_chr_id => p_chr_id,

Line 4854: l_rnrl_rec OKS_RENEW_UTIL_PVT.rnrl_rec_type;

4850: l_cpl_id NUMBER;
4851: l_user_id NUMBER;
4852: l_user_name VARCHAR2(100);
4853:
4854: l_rnrl_rec OKS_RENEW_UTIL_PVT.rnrl_rec_type;
4855: x_rnrl_rec OKS_RENEW_UTIL_PVT.rnrl_rec_type;
4856:
4857: BEGIN
4858:

Line 4855: x_rnrl_rec OKS_RENEW_UTIL_PVT.rnrl_rec_type;

4851: l_user_id NUMBER;
4852: l_user_name VARCHAR2(100);
4853:
4854: l_rnrl_rec OKS_RENEW_UTIL_PVT.rnrl_rec_type;
4855: x_rnrl_rec OKS_RENEW_UTIL_PVT.rnrl_rec_type;
4856:
4857: BEGIN
4858:
4859: --log key input parameters

Line 4920: OKS_RENEW_UTIL_PVT.get_renew_rules(

4916: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
4917: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.calling_get_renew_rules', 'p_chr_id=' || p_chr_id ||', p_date='|| sysdate);
4918: END IF;
4919:
4920: OKS_RENEW_UTIL_PVT.get_renew_rules(
4921: x_return_status => x_return_status,
4922: p_api_version => 1.0,
4923: p_init_msg_list => FND_API.G_FALSE,
4924: p_chr_id => p_chr_id,

Line 5111: l_rnrl_rec OKS_RENEW_UTIL_PVT.rnrl_rec_type;

5107: l_k_renewal_end_date DATE;
5108: l_k_currency_code VARCHAR2(15);
5109:
5110: l_validation_level VARCHAR2(1);
5111: l_rnrl_rec OKS_RENEW_UTIL_PVT.rnrl_rec_type;
5112: l_rnrl_rec_dummy OKS_RENEW_UTIL_PVT.rnrl_rec_type;
5113: l_validation_status VARCHAR2(1);
5114: l_validation_tbl validation_tbl_type;
5115:

Line 5112: l_rnrl_rec_dummy OKS_RENEW_UTIL_PVT.rnrl_rec_type;

5108: l_k_currency_code VARCHAR2(15);
5109:
5110: l_validation_level VARCHAR2(1);
5111: l_rnrl_rec OKS_RENEW_UTIL_PVT.rnrl_rec_type;
5112: l_rnrl_rec_dummy OKS_RENEW_UTIL_PVT.rnrl_rec_type;
5113: l_validation_status VARCHAR2(1);
5114: l_validation_tbl validation_tbl_type;
5115:
5116: l_renk_num okc_k_headers_b.contract_number%TYPE;

Line 5245: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.renewal_validation', 'calling OKS_RENEW_UTIL_PVT.validate_renewal, p_chr_id='||p_chr_id||' ,p_date='||to_char(nvl(p_new_start_date, l_k_end_date + 1))||

5241: l_validation_level := G_VALIDATE_ALL;
5242: END IF;
5243:
5244: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5245: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.renewal_validation', 'calling OKS_RENEW_UTIL_PVT.validate_renewal, p_chr_id='||p_chr_id||' ,p_date='||to_char(nvl(p_new_start_date, l_k_end_date + 1))||
5246: ' ,p_validation_level='||l_validation_level);
5247: END IF;
5248:
5249: validate_renewal(

Line 5263: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.renewal_validation', 'after call to OKS_RENEW_UTIL_PVT.validate_renewal, x_return_status='||x_return_status||' ,x_validation_status='||l_validation_status);

5259: x_validation_status => l_validation_status,
5260: x_validation_tbl => l_validation_tbl);
5261:
5262: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5263: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.renewal_validation', 'after call to OKS_RENEW_UTIL_PVT.validate_renewal, x_return_status='||x_return_status||' ,x_validation_status='||l_validation_status);
5264: END IF;
5265:
5266: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5267: RAISE FND_API.g_exc_unexpected_error;

Line 5393: OKS_RENEW_UTIL_PVT.get_renew_rules(

5389: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5390: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.calling_get_renew_rules', 'p_chr_id=' || x_chr_id ||', p_date='|| l_renk_start_date||' ,l_k_currency_code='||l_k_currency_code||' ,l_renk_currency_code='||l_renk_currency_code);
5391: END IF;
5392:
5393: OKS_RENEW_UTIL_PVT.get_renew_rules(
5394: x_return_status => x_return_status,
5395: p_api_version => 1.0,
5396: p_init_msg_list => FND_API.G_FALSE,
5397: p_chr_id => x_chr_id,