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 2974: 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);

2970: 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;
2971: CLOSE c_hdr_dates;
2972:
2973: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2974: 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);
2975: END IF;
2976:
2977: OKC_TIME_UTIL_PUB.get_duration(
2978: p_start_date => l_new_start_date,

Line 2977: OKC_TIME_UTIL_PUB.get_duration(

2973: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2974: 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);
2975: END IF;
2976:
2977: OKC_TIME_UTIL_PUB.get_duration(
2978: p_start_date => l_new_start_date,
2979: p_end_date => l_new_end_date,
2980: x_duration => l_new_duration,
2981: x_timeunit => l_new_period,

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

2981: x_timeunit => l_new_period,
2982: x_return_status => x_return_status);
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', '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);
2986: END IF;
2987: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
2988: RAISE FND_API.g_exc_unexpected_error;
2989: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

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

2990: RAISE FND_API.g_exc_error;
2991: END IF;
2992:
2993: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2994: 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);
2995: END IF;
2996:
2997: OKC_TIME_UTIL_PUB.get_duration(
2998: p_start_date => l_old_start_date,

Line 2997: OKC_TIME_UTIL_PUB.get_duration(

2993: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2994: 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);
2995: END IF;
2996:
2997: OKC_TIME_UTIL_PUB.get_duration(
2998: p_start_date => l_old_start_date,
2999: p_end_date => l_old_end_date,
3000: x_duration => l_old_duration,
3001: x_timeunit => l_old_period,

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

3001: x_timeunit => l_old_period,
3002: x_return_status => x_return_status);
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', '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);
3006: END IF;
3007: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
3008: RAISE FND_API.g_exc_unexpected_error;
3009: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

Line 3629: l_est_rev_date := OKC_TIME_UTIL_PUB.get_enddate(

3625: l_est_rev_date_offset := 1;
3626: END IF;
3627:
3628: l_est_rev_percent := p_rnrl_rec.revenue_estimated_percent;
3629: l_est_rev_date := OKC_TIME_UTIL_PUB.get_enddate(
3630: p_start_date => trunc(l_date_renewed),
3631: p_duration => p_rnrl_rec.revenue_estimated_duration,
3632: p_timeunit => p_rnrl_rec.revenue_estimated_period) + l_est_rev_date_offset; --bug 4967105
3633:

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

3631: p_duration => p_rnrl_rec.revenue_estimated_duration,
3632: p_timeunit => p_rnrl_rec.revenue_estimated_period) + l_est_rev_date_offset; --bug 4967105
3633:
3634: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3635: 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);
3636: END IF;
3637:
3638: l_grace_period := nvl(p_rnrl_rec.grace_period, l_grace_period);
3639: l_grace_duration := nvl(p_rnrl_rec.grace_duration, l_grace_duration);