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 3464: p_rnrl_rec IN OKS_RENEW_UTIL_PVT.rnrl_rec_type,

3460: */
3461: PROCEDURE UPDATE_RENEWED_CONTRACT
3462: (
3463: p_chr_id IN NUMBER,
3464: p_rnrl_rec IN OKS_RENEW_UTIL_PVT.rnrl_rec_type,
3465: p_notify_to IN NUMBER,
3466: x_msg_count OUT NOCOPY NUMBER,
3467: x_msg_data OUT NOCOPY VARCHAR2,
3468: x_return_status OUT NOCOPY VARCHAR2

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

3558:
3559: --log key input parameters
3560: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
3561: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_chr_id=' || p_chr_id);
3562: OKS_RENEW_UTIL_PVT.log_rules(l_mod_name || '.effective_renewal_rules', p_rnrl_rec);
3563: END IF;
3564: x_return_status := FND_API.G_RET_STS_SUCCESS;
3565:
3566: OPEN c_k_hdr(p_chr_id);

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

3608: END IF;
3609:
3610: --determine the renewal type and corresponding approval type
3611: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3612: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.determine_renewal_type', 'calling OKS_RENEW_UTIL_PVT.get_renewal_type');
3613: END IF;
3614: OKS_RENEW_UTIL_PVT.get_renewal_type(
3615: p_api_version => 1,
3616: p_init_msg_list => FND_API.G_FALSE,

Line 3614: OKS_RENEW_UTIL_PVT.get_renewal_type(

3610: --determine the renewal type and corresponding approval type
3611: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3612: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.determine_renewal_type', 'calling OKS_RENEW_UTIL_PVT.get_renewal_type');
3613: END IF;
3614: OKS_RENEW_UTIL_PVT.get_renewal_type(
3615: p_api_version => 1,
3616: p_init_msg_list => FND_API.G_FALSE,
3617: x_return_status => x_return_status,
3618: x_msg_count => x_msg_count,

Line 3629: 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||

3625: x_approval_type => l_approval_type,
3626: x_threshold_used => l_threshold_used);
3627:
3628: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3629: 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||
3630: ' ,x_approval_type='||l_approval_type||' ,x_threshold_used='||l_threshold_used);
3631: END IF;
3632:
3633: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 3948: x_rnrl_rec OUT NOCOPY OKS_RENEW_UTIL_PVT.rnrl_rec_type,

3944: x_msg_data OUT NOCOPY VARCHAR2,
3945: p_chr_id IN NUMBER,
3946: p_date IN DATE,
3947: p_validation_level IN VARCHAR2 DEFAULT G_VALIDATE_ALL,
3948: x_rnrl_rec OUT NOCOPY OKS_RENEW_UTIL_PVT.rnrl_rec_type,
3949: x_validation_status OUT NOCOPY VARCHAR2,
3950: x_validation_tbl OUT NOCOPY validation_tbl_type
3951: )
3952: IS

Line 4044: l_rnrl_rec OKS_RENEW_UTIL_PVT.rnrl_rec_type;

4040: l_k_template_yn okc_k_headers_b.template_yn%TYPE;
4041: l_k_date_terminated okc_k_headers_b.date_terminated%TYPE;
4042: l_k_date_renewed okc_k_headers_b.date_renewed%TYPE;
4043: l_k_end_date okc_k_headers_b.end_date%TYPE;
4044: l_rnrl_rec OKS_RENEW_UTIL_PVT.rnrl_rec_type;
4045:
4046: l_date DATE;
4047: l_k_num_mod VARCHAR2(250);
4048: l_msg_count INTEGER := 0;

Line 4233: OKS_RENEW_UTIL_PVT.get_renew_rules(

4229: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
4230: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.calling_get_renew_rules', 'p_chr_id=' || p_chr_id ||', p_date='|| l_date);
4231: END IF;
4232:
4233: OKS_RENEW_UTIL_PVT.get_renew_rules(
4234: x_return_status => x_return_status,
4235: p_api_version => 1.0,
4236: p_init_msg_list => FND_API.G_FALSE,
4237: p_chr_id => p_chr_id,

Line 4889: l_rnrl_rec OKS_RENEW_UTIL_PVT.rnrl_rec_type;

4885: l_cpl_id NUMBER;
4886: l_user_id NUMBER;
4887: l_user_name VARCHAR2(100);
4888:
4889: l_rnrl_rec OKS_RENEW_UTIL_PVT.rnrl_rec_type;
4890: x_rnrl_rec OKS_RENEW_UTIL_PVT.rnrl_rec_type;
4891:
4892: BEGIN
4893:

Line 4890: x_rnrl_rec OKS_RENEW_UTIL_PVT.rnrl_rec_type;

4886: l_user_id NUMBER;
4887: l_user_name VARCHAR2(100);
4888:
4889: l_rnrl_rec OKS_RENEW_UTIL_PVT.rnrl_rec_type;
4890: x_rnrl_rec OKS_RENEW_UTIL_PVT.rnrl_rec_type;
4891:
4892: BEGIN
4893:
4894: --log key input parameters

Line 4955: OKS_RENEW_UTIL_PVT.get_renew_rules(

4951: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
4952: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.calling_get_renew_rules', 'p_chr_id=' || p_chr_id ||', p_date='|| sysdate);
4953: END IF;
4954:
4955: OKS_RENEW_UTIL_PVT.get_renew_rules(
4956: x_return_status => x_return_status,
4957: p_api_version => 1.0,
4958: p_init_msg_list => FND_API.G_FALSE,
4959: p_chr_id => p_chr_id,

Line 5146: l_rnrl_rec OKS_RENEW_UTIL_PVT.rnrl_rec_type;

5142: l_k_renewal_end_date DATE;
5143: l_k_currency_code VARCHAR2(15);
5144:
5145: l_validation_level VARCHAR2(1);
5146: l_rnrl_rec OKS_RENEW_UTIL_PVT.rnrl_rec_type;
5147: l_rnrl_rec_dummy OKS_RENEW_UTIL_PVT.rnrl_rec_type;
5148: l_validation_status VARCHAR2(1);
5149: l_validation_tbl validation_tbl_type;
5150:

Line 5147: l_rnrl_rec_dummy OKS_RENEW_UTIL_PVT.rnrl_rec_type;

5143: l_k_currency_code VARCHAR2(15);
5144:
5145: l_validation_level VARCHAR2(1);
5146: l_rnrl_rec OKS_RENEW_UTIL_PVT.rnrl_rec_type;
5147: l_rnrl_rec_dummy OKS_RENEW_UTIL_PVT.rnrl_rec_type;
5148: l_validation_status VARCHAR2(1);
5149: l_validation_tbl validation_tbl_type;
5150:
5151: l_renk_num okc_k_headers_b.contract_number%TYPE;

Line 5280: 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))||

5276: l_validation_level := G_VALIDATE_ALL;
5277: END IF;
5278:
5279: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5280: 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))||
5281: ' ,p_validation_level='||l_validation_level);
5282: END IF;
5283:
5284: validate_renewal(

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

5294: x_validation_status => l_validation_status,
5295: x_validation_tbl => l_validation_tbl);
5296:
5297: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5298: 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);
5299: END IF;
5300:
5301: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
5302: RAISE FND_API.g_exc_unexpected_error;

Line 5428: OKS_RENEW_UTIL_PVT.get_renew_rules(

5424: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5425: 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);
5426: END IF;
5427:
5428: OKS_RENEW_UTIL_PVT.get_renew_rules(
5429: x_return_status => x_return_status,
5430: p_api_version => 1.0,
5431: p_init_msg_list => FND_API.G_FALSE,
5432: p_chr_id => x_chr_id,