DBA Data[Home] [Help]

APPS.OKS_RENEW_CONTRACT_PVT dependencies on OKC_TIME_UTIL_PVT

Line 505: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.calc_dates_KEP_1', 'i='||i||' calling OKC_TIME_UTIL_PVT.get_oracle_months_and_days, p_start_date='||l_parent_old_start_date||' ,p_end_date='||l_lines_tbl(i).old_start_date);

501: l_duration := 0;
502: l_additional_days := 0;
503:
504: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
505: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.calc_dates_KEP_1', 'i='||i||' calling OKC_TIME_UTIL_PVT.get_oracle_months_and_days, p_start_date='||l_parent_old_start_date||' ,p_end_date='||l_lines_tbl(i).old_start_date);
506: END IF;
507:
508: OKC_TIME_UTIL_PVT.get_oracle_months_and_days(
509: p_start_date => trunc(l_parent_old_start_date),

Line 508: OKC_TIME_UTIL_PVT.get_oracle_months_and_days(

504: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
505: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.calc_dates_KEP_1', 'i='||i||' calling OKC_TIME_UTIL_PVT.get_oracle_months_and_days, p_start_date='||l_parent_old_start_date||' ,p_end_date='||l_lines_tbl(i).old_start_date);
506: END IF;
507:
508: OKC_TIME_UTIL_PVT.get_oracle_months_and_days(
509: p_start_date => trunc(l_parent_old_start_date),
510: p_end_date => trunc(l_lines_tbl(i).old_start_date),
511: x_month_duration => l_duration,
512: x_day_duration => l_additional_days,

Line 516: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.calc_dates_KEP_1', 'i='||i||',after OKC_TIME_UTIL_PVT.get_oracle_months_and_days, x_return_status='||x_return_status||

512: x_day_duration => l_additional_days,
513: x_return_status => x_return_status);
514:
515: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
516: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.calc_dates_KEP_1', 'i='||i||',after OKC_TIME_UTIL_PVT.get_oracle_months_and_days, x_return_status='||x_return_status||
517: ',x_mth_duration='||l_duration||',x_day_duration='||l_additional_days);
518: END IF;
519:
520: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 537: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.calc_dates_KEP_2', 'i='||i||' calling OKC_TIME_UTIL_PVT.get_oracle_months_and_days, p_start_date='||l_parent_old_start_date||

533: l_duration := 0;
534: l_additional_days := 0;
535:
536: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
537: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.calc_dates_KEP_2', 'i='||i||' calling OKC_TIME_UTIL_PVT.get_oracle_months_and_days, p_start_date='||l_parent_old_start_date||
538: ' ,p_end_date='||l_lines_tbl(i).old_end_date||' ,x_return_status='||x_return_status);
539: END IF;
540:
541: OKC_TIME_UTIL_PVT.get_oracle_months_and_days(

Line 541: OKC_TIME_UTIL_PVT.get_oracle_months_and_days(

537: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.calc_dates_KEP_2', 'i='||i||' calling OKC_TIME_UTIL_PVT.get_oracle_months_and_days, p_start_date='||l_parent_old_start_date||
538: ' ,p_end_date='||l_lines_tbl(i).old_end_date||' ,x_return_status='||x_return_status);
539: END IF;
540:
541: OKC_TIME_UTIL_PVT.get_oracle_months_and_days(
542: p_start_date => trunc(l_parent_old_start_date),
543: p_end_date => trunc(l_lines_tbl(i).old_end_date),
544: x_month_duration => l_duration,
545: x_day_duration => l_additional_days,

Line 549: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.calc_dates_KEP_3', 'i='||i||'after OKC_TIME_UTIL_PVTget_oracle_months_and_days, x_return_status='||x_return_status||

545: x_day_duration => l_additional_days,
546: x_return_status => x_return_status);
547:
548: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
549: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.calc_dates_KEP_3', 'i='||i||'after OKC_TIME_UTIL_PVTget_oracle_months_and_days, x_return_status='||x_return_status||
550: ',x_mth_duration='||l_duration||',x_day_duration='||l_additional_days);
551: END IF;
552:
553: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN