DBA Data[Home] [Help]

APPS.OKS_RENEW_CONTRACT_PVT dependencies on OKC_TIME_UTIL_PUB

Line 52: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.get_duration', 'before call to OKC_TIME_UTIL_PUB.get_duration p_start_date='||to_char(p_old_start_date)||' ,p_end_date='||to_char(p_old_end_date));

48: --if duration/period are also null, use the old contract's duration period
49: IF(l_duration IS NULL OR l_uom_code IS NULL) THEN
50:
51: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
52: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.get_duration', 'before call to OKC_TIME_UTIL_PUB.get_duration p_start_date='||to_char(p_old_start_date)||' ,p_end_date='||to_char(p_old_end_date));
53: END IF;
54:
55: OKC_TIME_UTIL_PUB.get_duration(
56: p_start_date => trunc(p_old_start_date),

Line 55: OKC_TIME_UTIL_PUB.get_duration(

51: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
52: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.get_duration', 'before call to OKC_TIME_UTIL_PUB.get_duration p_start_date='||to_char(p_old_start_date)||' ,p_end_date='||to_char(p_old_end_date));
53: END IF;
54:
55: OKC_TIME_UTIL_PUB.get_duration(
56: p_start_date => trunc(p_old_start_date),
57: p_end_date => trunc(p_old_end_date),
58: x_duration => l_duration,
59: x_timeunit => l_uom_code,

Line 69: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.get_duration', 'after call to OKC_TIME_UTIL_PUB.get_duration, l_duration='||l_duration||' ,l_uom_code='||l_uom_code);

65: RAISE FND_API.g_exc_error;
66: END IF;
67:
68: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
69: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.get_duration', 'after call to OKC_TIME_UTIL_PUB.get_duration, l_duration='||l_duration||' ,l_uom_code='||l_uom_code);
70: END IF;
71: END IF; --of (l_duration IS NULL OR l_uom_code IS NULL) THEN
72:
73: --now determine the end date from duration/period

Line 75: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.derive_end_date', 'before call to OKC_TIME_UTIL_PUB.get_enddate, p_start_date='||to_char(p_new_start_date)||' ,p_timeunit='||l_uom_code||' ,p_duration='||l_duration);

71: END IF; --of (l_duration IS NULL OR l_uom_code IS NULL) THEN
72:
73: --now determine the end date from duration/period
74: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
75: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.derive_end_date', 'before call to OKC_TIME_UTIL_PUB.get_enddate, p_start_date='||to_char(p_new_start_date)||' ,p_timeunit='||l_uom_code||' ,p_duration='||l_duration);
76: END IF;
77:
78: l_end_date := OKC_TIME_UTIL_PUB.get_enddate(
79: p_start_date => trunc(p_new_start_date),

Line 78: l_end_date := OKC_TIME_UTIL_PUB.get_enddate(

74: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
75: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.derive_end_date', 'before call to OKC_TIME_UTIL_PUB.get_enddate, p_start_date='||to_char(p_new_start_date)||' ,p_timeunit='||l_uom_code||' ,p_duration='||l_duration);
76: END IF;
77:
78: l_end_date := OKC_TIME_UTIL_PUB.get_enddate(
79: p_start_date => trunc(p_new_start_date),
80: p_timeunit => l_uom_code,
81: p_duration => l_duration);
82:

Line 84: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.derive_end_date', 'after call to OKC_TIME_UTIL_PUB.get_enddate, l_end_date='||to_char(l_end_date));

80: p_timeunit => l_uom_code,
81: p_duration => l_duration);
82:
83: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
84: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.derive_end_date', 'after call to OKC_TIME_UTIL_PUB.get_enddate, l_end_date='||to_char(l_end_date));
85: END IF;
86:
87: END IF; --of IF (l_end_date IS NULL) THEN
88:

Line 2985: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.get_duration_new', 'calling OKC_TIME_UTIL_PUB.get_duration, l_new_start_date='||l_new_start_date||' ,l_new_end_date='||l_new_end_date);

2981: FETCH c_hdr_dates INTO l_new_start_date, l_new_end_date, l_old_start_date, l_old_end_date, l_old_chr_id, l_new_period_type, l_new_period_start, l_old_period_type, l_old_period_start;
2982: CLOSE c_hdr_dates;
2983:
2984: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2985: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.get_duration_new', 'calling OKC_TIME_UTIL_PUB.get_duration, l_new_start_date='||l_new_start_date||' ,l_new_end_date='||l_new_end_date);
2986: END IF;
2987:
2988: OKC_TIME_UTIL_PUB.get_duration(
2989: p_start_date => l_new_start_date,

Line 2988: OKC_TIME_UTIL_PUB.get_duration(

2984: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2985: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.get_duration_new', 'calling OKC_TIME_UTIL_PUB.get_duration, l_new_start_date='||l_new_start_date||' ,l_new_end_date='||l_new_end_date);
2986: END IF;
2987:
2988: OKC_TIME_UTIL_PUB.get_duration(
2989: p_start_date => l_new_start_date,
2990: p_end_date => l_new_end_date,
2991: x_duration => l_new_duration,
2992: x_timeunit => l_new_period,

Line 2996: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.get_duration_new', 'after call to OKC_TIME_UTIL_PUB.get_duration, x_return_status='||x_return_status||' ,l_new_duration='||l_new_duration||' ,l_new_period='||l_new_period);

2992: x_timeunit => l_new_period,
2993: x_return_status => x_return_status);
2994:
2995: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2996: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.get_duration_new', 'after call to OKC_TIME_UTIL_PUB.get_duration, x_return_status='||x_return_status||' ,l_new_duration='||l_new_duration||' ,l_new_period='||l_new_period);
2997: END IF;
2998: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
2999: RAISE FND_API.g_exc_unexpected_error;
3000: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

Line 3005: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.get_duration_old', 'calling OKC_TIME_UTIL_PUB.get_duration, l_old_start_date='||l_old_start_date||' ,l_old_end_date='||l_old_end_date);

3001: RAISE FND_API.g_exc_error;
3002: END IF;
3003:
3004: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3005: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.get_duration_old', 'calling OKC_TIME_UTIL_PUB.get_duration, l_old_start_date='||l_old_start_date||' ,l_old_end_date='||l_old_end_date);
3006: END IF;
3007:
3008: OKC_TIME_UTIL_PUB.get_duration(
3009: p_start_date => l_old_start_date,

Line 3008: OKC_TIME_UTIL_PUB.get_duration(

3004: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3005: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.get_duration_old', 'calling OKC_TIME_UTIL_PUB.get_duration, l_old_start_date='||l_old_start_date||' ,l_old_end_date='||l_old_end_date);
3006: END IF;
3007:
3008: OKC_TIME_UTIL_PUB.get_duration(
3009: p_start_date => l_old_start_date,
3010: p_end_date => l_old_end_date,
3011: x_duration => l_old_duration,
3012: x_timeunit => l_old_period,

Line 3016: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.get_duration_old', 'after call to OKC_TIME_UTIL_PUB.get_duration, x_return_status='||x_return_status||' ,l_old_duration='||l_old_duration||' ,l_old_period='||l_old_period);

3012: x_timeunit => l_old_period,
3013: x_return_status => x_return_status);
3014:
3015: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3016: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.get_duration_old', 'after call to OKC_TIME_UTIL_PUB.get_duration, x_return_status='||x_return_status||' ,l_old_duration='||l_old_duration||' ,l_old_period='||l_old_period);
3017: END IF;
3018: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
3019: RAISE FND_API.g_exc_unexpected_error;
3020: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

Line 3652: l_est_rev_date := OKC_TIME_UTIL_PUB.get_enddate(

3648: l_est_rev_date_offset := 1;
3649: END IF;
3650:
3651: l_est_rev_percent := p_rnrl_rec.revenue_estimated_percent;
3652: l_est_rev_date := OKC_TIME_UTIL_PUB.get_enddate(
3653: p_start_date => trunc(l_date_renewed),
3654: p_duration => p_rnrl_rec.revenue_estimated_duration,
3655: p_timeunit => p_rnrl_rec.revenue_estimated_period) + l_est_rev_date_offset; --bug 4967105
3656:

Line 3658: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.get_enddate', 'after call to OKC_TIME_UTIL_PUB.get_enddate, l_est_rev_date='||l_est_rev_date);

3654: p_duration => p_rnrl_rec.revenue_estimated_duration,
3655: p_timeunit => p_rnrl_rec.revenue_estimated_period) + l_est_rev_date_offset; --bug 4967105
3656:
3657: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3658: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.get_enddate', 'after call to OKC_TIME_UTIL_PUB.get_enddate, l_est_rev_date='||l_est_rev_date);
3659: END IF;
3660:
3661: l_grace_period := nvl(p_rnrl_rec.grace_period, l_grace_period);
3662: l_grace_duration := nvl(p_rnrl_rec.grace_duration, l_grace_duration);