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.OKL_VAR_INT_CATCHUP_PVT dependencies on OKL_VARIABLE_INTEREST_PVT

Line 60: OKL_VARIABLE_INTEREST_PVT.print_debug('l_chr_term_days: '|| l_chr_term_days);

56: OPEN l_contract_csr(p_khr_id);
57: FETCH l_contract_csr INTO l_chr_term_days;
58: CLOSE l_contract_csr;
59:
60: OKL_VARIABLE_INTEREST_PVT.print_debug('l_chr_term_days: '|| l_chr_term_days);
61:
62: FOR cur_khr_params IN c_khr_params(p_khr_id) LOOP
63: l_chr_start_date := cur_khr_params.start_date;
64: l_catchup_start_date := cur_khr_params.catchup_start_date;

Line 70: OKL_VARIABLE_INTEREST_PVT.print_debug('l_chr_start_date: '|| l_chr_start_date);

66: l_chr_end_date := cur_khr_params.end_date;
67: EXIT;
68: END LOOP;
69:
70: OKL_VARIABLE_INTEREST_PVT.print_debug('l_chr_start_date: '|| l_chr_start_date);
71: OKL_VARIABLE_INTEREST_PVT.print_debug('l_chr_end_date: '|| l_chr_end_date);
72: OKL_VARIABLE_INTEREST_PVT.print_debug('l_catchup_start_date: '|| l_catchup_start_date);
73: OKL_VARIABLE_INTEREST_PVT.print_debug('l_catchup_frequency: '|| l_catchup_frequency);
74:

Line 71: OKL_VARIABLE_INTEREST_PVT.print_debug('l_chr_end_date: '|| l_chr_end_date);

67: EXIT;
68: END LOOP;
69:
70: OKL_VARIABLE_INTEREST_PVT.print_debug('l_chr_start_date: '|| l_chr_start_date);
71: OKL_VARIABLE_INTEREST_PVT.print_debug('l_chr_end_date: '|| l_chr_end_date);
72: OKL_VARIABLE_INTEREST_PVT.print_debug('l_catchup_start_date: '|| l_catchup_start_date);
73: OKL_VARIABLE_INTEREST_PVT.print_debug('l_catchup_frequency: '|| l_catchup_frequency);
74:
75: IF(UPPER(l_catchup_frequency) = 'ANNUAL') THEN

Line 72: OKL_VARIABLE_INTEREST_PVT.print_debug('l_catchup_start_date: '|| l_catchup_start_date);

68: END LOOP;
69:
70: OKL_VARIABLE_INTEREST_PVT.print_debug('l_chr_start_date: '|| l_chr_start_date);
71: OKL_VARIABLE_INTEREST_PVT.print_debug('l_chr_end_date: '|| l_chr_end_date);
72: OKL_VARIABLE_INTEREST_PVT.print_debug('l_catchup_start_date: '|| l_catchup_start_date);
73: OKL_VARIABLE_INTEREST_PVT.print_debug('l_catchup_frequency: '|| l_catchup_frequency);
74:
75: IF(UPPER(l_catchup_frequency) = 'ANNUAL') THEN
76: l_adder_months := 12;

Line 73: OKL_VARIABLE_INTEREST_PVT.print_debug('l_catchup_frequency: '|| l_catchup_frequency);

69:
70: OKL_VARIABLE_INTEREST_PVT.print_debug('l_chr_start_date: '|| l_chr_start_date);
71: OKL_VARIABLE_INTEREST_PVT.print_debug('l_chr_end_date: '|| l_chr_end_date);
72: OKL_VARIABLE_INTEREST_PVT.print_debug('l_catchup_start_date: '|| l_catchup_start_date);
73: OKL_VARIABLE_INTEREST_PVT.print_debug('l_catchup_frequency: '|| l_catchup_frequency);
74:
75: IF(UPPER(l_catchup_frequency) = 'ANNUAL') THEN
76: l_adder_months := 12;
77: ELSIF(UPPER(l_catchup_frequency) = 'SEMI_ANNUAL') THEN

Line 93: OKL_VARIABLE_INTEREST_PVT.print_debug('l_actual_stub_days start of term: '|| l_actual_stub_days);

89:
90: IF (l_catchup_start_date > l_chr_start_date) THEN
91: l_actual_stub_days := l_catchup_start_date - l_chr_start_date;
92:
93: OKL_VARIABLE_INTEREST_PVT.print_debug('l_actual_stub_days start of term: '|| l_actual_stub_days);
94:
95: IF (p_start_date = l_chr_start_date) THEN
96:
97: i := i + 1;

Line 102: OKL_VARIABLE_INTEREST_PVT.print_debug('i : '|| i);

98: x_payment_tbl(i).period_start_date := l_chr_start_date;
99: x_payment_tbl(i).period_end_date := l_catchup_start_date - 1;
100: x_payment_tbl(i).period_or_stub_flag := 'S';
101:
102: OKL_VARIABLE_INTEREST_PVT.print_debug('i : '|| i);
103: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_start_date : '|| x_payment_tbl(i).period_start_date);
104: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_end_date : '|| x_payment_tbl(i).period_end_date);
105: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_or_stub_flag : '|| x_payment_tbl(i).period_or_stub_flag);
106: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).conversion_factor : '|| x_payment_tbl(i).conversion_factor);

Line 103: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_start_date : '|| x_payment_tbl(i).period_start_date);

99: x_payment_tbl(i).period_end_date := l_catchup_start_date - 1;
100: x_payment_tbl(i).period_or_stub_flag := 'S';
101:
102: OKL_VARIABLE_INTEREST_PVT.print_debug('i : '|| i);
103: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_start_date : '|| x_payment_tbl(i).period_start_date);
104: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_end_date : '|| x_payment_tbl(i).period_end_date);
105: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_or_stub_flag : '|| x_payment_tbl(i).period_or_stub_flag);
106: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).conversion_factor : '|| x_payment_tbl(i).conversion_factor);
107: END IF;

Line 104: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_end_date : '|| x_payment_tbl(i).period_end_date);

100: x_payment_tbl(i).period_or_stub_flag := 'S';
101:
102: OKL_VARIABLE_INTEREST_PVT.print_debug('i : '|| i);
103: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_start_date : '|| x_payment_tbl(i).period_start_date);
104: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_end_date : '|| x_payment_tbl(i).period_end_date);
105: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_or_stub_flag : '|| x_payment_tbl(i).period_or_stub_flag);
106: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).conversion_factor : '|| x_payment_tbl(i).conversion_factor);
107: END IF;
108: END IF;

Line 105: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_or_stub_flag : '|| x_payment_tbl(i).period_or_stub_flag);

101:
102: OKL_VARIABLE_INTEREST_PVT.print_debug('i : '|| i);
103: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_start_date : '|| x_payment_tbl(i).period_start_date);
104: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_end_date : '|| x_payment_tbl(i).period_end_date);
105: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_or_stub_flag : '|| x_payment_tbl(i).period_or_stub_flag);
106: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).conversion_factor : '|| x_payment_tbl(i).conversion_factor);
107: END IF;
108: END IF;
109:

Line 106: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).conversion_factor : '|| x_payment_tbl(i).conversion_factor);

102: OKL_VARIABLE_INTEREST_PVT.print_debug('i : '|| i);
103: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_start_date : '|| x_payment_tbl(i).period_start_date);
104: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_end_date : '|| x_payment_tbl(i).period_end_date);
105: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_or_stub_flag : '|| x_payment_tbl(i).period_or_stub_flag);
106: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).conversion_factor : '|| x_payment_tbl(i).conversion_factor);
107: END IF;
108: END IF;
109:
110: l_start_date := l_catchup_start_date;

Line 128: OKL_VARIABLE_INTEREST_PVT.print_debug('l_start_date: '|| l_start_date);

124: IF(l_return_status <> OKL_API.G_RET_STS_SUCCESS)THEN
125: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
126: END IF;
127:
128: OKL_VARIABLE_INTEREST_PVT.print_debug('l_start_date: '|| l_start_date);
129: OKL_VARIABLE_INTEREST_PVT.print_debug('l_end_date: '|| l_end_date);
130:
131: EXIT WHEN l_end_date > l_chr_end_date;
132:

Line 129: OKL_VARIABLE_INTEREST_PVT.print_debug('l_end_date: '|| l_end_date);

125: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
126: END IF;
127:
128: OKL_VARIABLE_INTEREST_PVT.print_debug('l_start_date: '|| l_start_date);
129: OKL_VARIABLE_INTEREST_PVT.print_debug('l_end_date: '|| l_end_date);
130:
131: EXIT WHEN l_end_date > l_chr_end_date;
132:
133: IF(l_end_date < p_start_date) THEN

Line 144: OKL_VARIABLE_INTEREST_PVT.print_debug('i : '|| i);

140: x_payment_tbl(i).period_end_date := l_end_date;
141: x_payment_tbl(i).period_or_stub_flag := 'P';
142: x_payment_tbl(i).conversion_factor := (30 * l_adder_months)/(l_end_date - l_start_date + 1);
143:
144: OKL_VARIABLE_INTEREST_PVT.print_debug('i : '|| i);
145: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_start_date : '|| x_payment_tbl(i).period_start_date);
146: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_end_date : '|| x_payment_tbl(i).period_end_date);
147: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_or_stub_flag : '|| x_payment_tbl(i).period_or_stub_flag);
148: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).conversion_factor : '|| x_payment_tbl(i).conversion_factor);

Line 145: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_start_date : '|| x_payment_tbl(i).period_start_date);

141: x_payment_tbl(i).period_or_stub_flag := 'P';
142: x_payment_tbl(i).conversion_factor := (30 * l_adder_months)/(l_end_date - l_start_date + 1);
143:
144: OKL_VARIABLE_INTEREST_PVT.print_debug('i : '|| i);
145: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_start_date : '|| x_payment_tbl(i).period_start_date);
146: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_end_date : '|| x_payment_tbl(i).period_end_date);
147: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_or_stub_flag : '|| x_payment_tbl(i).period_or_stub_flag);
148: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).conversion_factor : '|| x_payment_tbl(i).conversion_factor);
149:

Line 146: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_end_date : '|| x_payment_tbl(i).period_end_date);

142: x_payment_tbl(i).conversion_factor := (30 * l_adder_months)/(l_end_date - l_start_date + 1);
143:
144: OKL_VARIABLE_INTEREST_PVT.print_debug('i : '|| i);
145: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_start_date : '|| x_payment_tbl(i).period_start_date);
146: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_end_date : '|| x_payment_tbl(i).period_end_date);
147: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_or_stub_flag : '|| x_payment_tbl(i).period_or_stub_flag);
148: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).conversion_factor : '|| x_payment_tbl(i).conversion_factor);
149:
150: END IF;

Line 147: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_or_stub_flag : '|| x_payment_tbl(i).period_or_stub_flag);

143:
144: OKL_VARIABLE_INTEREST_PVT.print_debug('i : '|| i);
145: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_start_date : '|| x_payment_tbl(i).period_start_date);
146: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_end_date : '|| x_payment_tbl(i).period_end_date);
147: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_or_stub_flag : '|| x_payment_tbl(i).period_or_stub_flag);
148: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).conversion_factor : '|| x_payment_tbl(i).conversion_factor);
149:
150: END IF;
151:

Line 148: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).conversion_factor : '|| x_payment_tbl(i).conversion_factor);

144: OKL_VARIABLE_INTEREST_PVT.print_debug('i : '|| i);
145: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_start_date : '|| x_payment_tbl(i).period_start_date);
146: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_end_date : '|| x_payment_tbl(i).period_end_date);
147: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_or_stub_flag : '|| x_payment_tbl(i).period_or_stub_flag);
148: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).conversion_factor : '|| x_payment_tbl(i).conversion_factor);
149:
150: END IF;
151:
152: l_chr_period_days := l_chr_period_days + (30 * l_adder_months);

Line 157: OKL_VARIABLE_INTEREST_PVT.print_debug('l_chr_period_days: '|| l_chr_period_days);

153: l_start_date := l_end_date + 1;
154:
155: END LOOP;
156:
157: OKL_VARIABLE_INTEREST_PVT.print_debug('l_chr_period_days: '|| l_chr_period_days);
158:
159: IF (l_start_date <= l_chr_end_date) THEN
160: l_actual_stub_days := l_actual_stub_days + (l_chr_end_date - l_start_date + 1);
161:

Line 162: OKL_VARIABLE_INTEREST_PVT.print_debug('l_actual_stub_days: '|| l_actual_stub_days);

158:
159: IF (l_start_date <= l_chr_end_date) THEN
160: l_actual_stub_days := l_actual_stub_days + (l_chr_end_date - l_start_date + 1);
161:
162: OKL_VARIABLE_INTEREST_PVT.print_debug('l_actual_stub_days: '|| l_actual_stub_days);
163:
164: IF (p_due_date >= l_start_date) THEN
165: i := i + 1;
166: x_payment_tbl(i).period_start_date := l_start_date;

Line 170: OKL_VARIABLE_INTEREST_PVT.print_debug('i : '|| i);

166: x_payment_tbl(i).period_start_date := l_start_date;
167: x_payment_tbl(i).period_end_date := l_chr_end_date;
168: x_payment_tbl(i).period_or_stub_flag := 'S';
169:
170: OKL_VARIABLE_INTEREST_PVT.print_debug('i : '|| i);
171: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_start_date : '|| x_payment_tbl(i).period_start_date);
172: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_end_date : '|| x_payment_tbl(i).period_end_date);
173: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_or_stub_flag : '|| x_payment_tbl(i).period_or_stub_flag);
174: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).conversion_factor : '|| x_payment_tbl(i).conversion_factor);

Line 171: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_start_date : '|| x_payment_tbl(i).period_start_date);

167: x_payment_tbl(i).period_end_date := l_chr_end_date;
168: x_payment_tbl(i).period_or_stub_flag := 'S';
169:
170: OKL_VARIABLE_INTEREST_PVT.print_debug('i : '|| i);
171: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_start_date : '|| x_payment_tbl(i).period_start_date);
172: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_end_date : '|| x_payment_tbl(i).period_end_date);
173: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_or_stub_flag : '|| x_payment_tbl(i).period_or_stub_flag);
174: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).conversion_factor : '|| x_payment_tbl(i).conversion_factor);
175: END IF;

Line 172: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_end_date : '|| x_payment_tbl(i).period_end_date);

168: x_payment_tbl(i).period_or_stub_flag := 'S';
169:
170: OKL_VARIABLE_INTEREST_PVT.print_debug('i : '|| i);
171: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_start_date : '|| x_payment_tbl(i).period_start_date);
172: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_end_date : '|| x_payment_tbl(i).period_end_date);
173: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_or_stub_flag : '|| x_payment_tbl(i).period_or_stub_flag);
174: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).conversion_factor : '|| x_payment_tbl(i).conversion_factor);
175: END IF;
176: END IF;

Line 173: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_or_stub_flag : '|| x_payment_tbl(i).period_or_stub_flag);

169:
170: OKL_VARIABLE_INTEREST_PVT.print_debug('i : '|| i);
171: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_start_date : '|| x_payment_tbl(i).period_start_date);
172: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_end_date : '|| x_payment_tbl(i).period_end_date);
173: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_or_stub_flag : '|| x_payment_tbl(i).period_or_stub_flag);
174: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).conversion_factor : '|| x_payment_tbl(i).conversion_factor);
175: END IF;
176: END IF;
177:

Line 174: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).conversion_factor : '|| x_payment_tbl(i).conversion_factor);

170: OKL_VARIABLE_INTEREST_PVT.print_debug('i : '|| i);
171: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_start_date : '|| x_payment_tbl(i).period_start_date);
172: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_end_date : '|| x_payment_tbl(i).period_end_date);
173: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).period_or_stub_flag : '|| x_payment_tbl(i).period_or_stub_flag);
174: OKL_VARIABLE_INTEREST_PVT.print_debug('x_payment_tbl(i).conversion_factor : '|| x_payment_tbl(i).conversion_factor);
175: END IF;
176: END IF;
177:
178: l_chr_stub_days := l_chr_term_days - l_chr_period_days;

Line 180: OKL_VARIABLE_INTEREST_PVT.print_debug('l_chr_stub_days: '|| l_chr_stub_days);

176: END IF;
177:
178: l_chr_stub_days := l_chr_term_days - l_chr_period_days;
179:
180: OKL_VARIABLE_INTEREST_PVT.print_debug('l_chr_stub_days: '|| l_chr_stub_days);
181: OKL_VARIABLE_INTEREST_PVT.print_debug('l_actual_stub_days: '|| l_actual_stub_days);
182:
183: IF (l_actual_stub_days <> 0 AND l_chr_stub_days <> 0) THEN
184: l_stub_conversion_factor := l_chr_stub_days/l_actual_stub_days;

Line 181: OKL_VARIABLE_INTEREST_PVT.print_debug('l_actual_stub_days: '|| l_actual_stub_days);

177:
178: l_chr_stub_days := l_chr_term_days - l_chr_period_days;
179:
180: OKL_VARIABLE_INTEREST_PVT.print_debug('l_chr_stub_days: '|| l_chr_stub_days);
181: OKL_VARIABLE_INTEREST_PVT.print_debug('l_actual_stub_days: '|| l_actual_stub_days);
182:
183: IF (l_actual_stub_days <> 0 AND l_chr_stub_days <> 0) THEN
184: l_stub_conversion_factor := l_chr_stub_days/l_actual_stub_days;
185:

Line 186: OKL_VARIABLE_INTEREST_PVT.print_debug('l_stub_conversion_factor : '|| l_stub_conversion_factor);

182:
183: IF (l_actual_stub_days <> 0 AND l_chr_stub_days <> 0) THEN
184: l_stub_conversion_factor := l_chr_stub_days/l_actual_stub_days;
185:
186: OKL_VARIABLE_INTEREST_PVT.print_debug('l_stub_conversion_factor : '|| l_stub_conversion_factor);
187:
188: IF (x_payment_tbl.COUNT) > 0 THEN
189: FOR i IN x_payment_tbl.FIRST..x_payment_tbl.LAST LOOP
190: IF (x_payment_tbl(i).period_or_stub_flag = 'S') THEN

Line 320: l_principal_balance_tbl OKL_VARIABLE_INTEREST_PVT.principal_balance_tbl_typ;

316: -- l_catchup_settlement_code OKL_K_RATE_PARAMS.catchup_settlement_code%TYPE;
317: l_invoice_amt NUMBER := 0;
318: l_stream_type_purpose OKL_STRM_TYPE_V.stream_type_purpose%TYPE;
319: l_invoice_id NUMBER;
320: l_principal_balance_tbl OKL_VARIABLE_INTEREST_PVT.principal_balance_tbl_typ;
321: l_total_asset_val NUMBER := 0;
322: l_principal_balance NUMBER := 0;
323: l_asset_line_tbl okl_kle_pvt.kle_tbl_type;
324: l_line_index NUMBER := 0;

Line 328: i_vir_tbl OKL_VARIABLE_INTEREST_PVT.vir_tbl_type;

324: l_line_index NUMBER := 0;
325: l_index NUMBER := 0;
326: l_asset_line_tbl_count NUMBER := 0;
327: l_prorated_invoice_amt NUMBER := 0;
328: i_vir_tbl OKL_VARIABLE_INTEREST_PVT.vir_tbl_type;
329: r_vir_tbl OKL_VARIABLE_INTEREST_PVT.vir_tbl_type;
330: l_stream_element_id OKL_STRM_ELEMENTS_V.id%TYPE;
331: var_int_catchup_failed EXCEPTION;
332:

Line 329: r_vir_tbl OKL_VARIABLE_INTEREST_PVT.vir_tbl_type;

325: l_index NUMBER := 0;
326: l_asset_line_tbl_count NUMBER := 0;
327: l_prorated_invoice_amt NUMBER := 0;
328: i_vir_tbl OKL_VARIABLE_INTEREST_PVT.vir_tbl_type;
329: r_vir_tbl OKL_VARIABLE_INTEREST_PVT.vir_tbl_type;
330: l_stream_element_id OKL_STRM_ELEMENTS_V.id%TYPE;
331: var_int_catchup_failed EXCEPTION;
332:
333: --Bug# 13001695: Added parameter cp_stream_type_purpose

Line 413: WHERE cle.lse_id = OKL_VARIABLE_INTEREST_PVT.G_FIN_LINE_LTY_ID

409: CURSOR l_assets_csr(p_contract_id NUMBER) IS
410: SELECT cle.id
411: FROM okc_k_lines_b cle,
412: okc_statuses_b sts
413: WHERE cle.lse_id = OKL_VARIABLE_INTEREST_PVT.G_FIN_LINE_LTY_ID
414: AND cle.dnz_chr_id = p_contract_id
415: AND cle.chr_id = p_contract_id
416: AND cle.sts_code = sts.code
417: AND sts.ste_code NOT IN ('TERMINATED', 'CANCELLED');

Line 432: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure VARIABLE_INTEREST_CATCHUP using following parameters : ');

428: ------------------------------------------------------------
429:
430: x_return_status := OKL_API.G_RET_STS_SUCCESS;
431:
432: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure VARIABLE_INTEREST_CATCHUP using following parameters : ');
433: OKL_VARIABLE_INTEREST_PVT.print_debug('contract ID: '|| p_contract_id);
434: OKL_VARIABLE_INTEREST_PVT.print_Debug('Principal Basis: '|| p_principal_basis);
435: OKL_VARIABLE_INTEREST_PVT.print_debug('Revenue Recognition Method: '|| p_rev_rec_method);
436: OKL_VARIABLE_INTEREST_PVT.print_debug('Deal Type: '|| p_deal_type);

Line 433: OKL_VARIABLE_INTEREST_PVT.print_debug('contract ID: '|| p_contract_id);

429:
430: x_return_status := OKL_API.G_RET_STS_SUCCESS;
431:
432: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure VARIABLE_INTEREST_CATCHUP using following parameters : ');
433: OKL_VARIABLE_INTEREST_PVT.print_debug('contract ID: '|| p_contract_id);
434: OKL_VARIABLE_INTEREST_PVT.print_Debug('Principal Basis: '|| p_principal_basis);
435: OKL_VARIABLE_INTEREST_PVT.print_debug('Revenue Recognition Method: '|| p_rev_rec_method);
436: OKL_VARIABLE_INTEREST_PVT.print_debug('Deal Type: '|| p_deal_type);
437: OKL_VARIABLE_INTEREST_PVT.Print_debug('Currency Code: '|| p_currency_code);

Line 434: OKL_VARIABLE_INTEREST_PVT.print_Debug('Principal Basis: '|| p_principal_basis);

430: x_return_status := OKL_API.G_RET_STS_SUCCESS;
431:
432: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure VARIABLE_INTEREST_CATCHUP using following parameters : ');
433: OKL_VARIABLE_INTEREST_PVT.print_debug('contract ID: '|| p_contract_id);
434: OKL_VARIABLE_INTEREST_PVT.print_Debug('Principal Basis: '|| p_principal_basis);
435: OKL_VARIABLE_INTEREST_PVT.print_debug('Revenue Recognition Method: '|| p_rev_rec_method);
436: OKL_VARIABLE_INTEREST_PVT.print_debug('Deal Type: '|| p_deal_type);
437: OKL_VARIABLE_INTEREST_PVT.Print_debug('Currency Code: '|| p_currency_code);
438: OKL_VARIABLE_INTEREST_PVT.print_debug('Start Date: '|| p_start_date);

Line 435: OKL_VARIABLE_INTEREST_PVT.print_debug('Revenue Recognition Method: '|| p_rev_rec_method);

431:
432: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure VARIABLE_INTEREST_CATCHUP using following parameters : ');
433: OKL_VARIABLE_INTEREST_PVT.print_debug('contract ID: '|| p_contract_id);
434: OKL_VARIABLE_INTEREST_PVT.print_Debug('Principal Basis: '|| p_principal_basis);
435: OKL_VARIABLE_INTEREST_PVT.print_debug('Revenue Recognition Method: '|| p_rev_rec_method);
436: OKL_VARIABLE_INTEREST_PVT.print_debug('Deal Type: '|| p_deal_type);
437: OKL_VARIABLE_INTEREST_PVT.Print_debug('Currency Code: '|| p_currency_code);
438: OKL_VARIABLE_INTEREST_PVT.print_debug('Start Date: '|| p_start_date);
439: OKL_VARIABLE_INTEREST_PVT.print_debug('Due Date: '|| p_due_date);

Line 436: OKL_VARIABLE_INTEREST_PVT.print_debug('Deal Type: '|| p_deal_type);

432: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure VARIABLE_INTEREST_CATCHUP using following parameters : ');
433: OKL_VARIABLE_INTEREST_PVT.print_debug('contract ID: '|| p_contract_id);
434: OKL_VARIABLE_INTEREST_PVT.print_Debug('Principal Basis: '|| p_principal_basis);
435: OKL_VARIABLE_INTEREST_PVT.print_debug('Revenue Recognition Method: '|| p_rev_rec_method);
436: OKL_VARIABLE_INTEREST_PVT.print_debug('Deal Type: '|| p_deal_type);
437: OKL_VARIABLE_INTEREST_PVT.Print_debug('Currency Code: '|| p_currency_code);
438: OKL_VARIABLE_INTEREST_PVT.print_debug('Start Date: '|| p_start_date);
439: OKL_VARIABLE_INTEREST_PVT.print_debug('Due Date: '|| p_due_date);
440:

Line 437: OKL_VARIABLE_INTEREST_PVT.Print_debug('Currency Code: '|| p_currency_code);

433: OKL_VARIABLE_INTEREST_PVT.print_debug('contract ID: '|| p_contract_id);
434: OKL_VARIABLE_INTEREST_PVT.print_Debug('Principal Basis: '|| p_principal_basis);
435: OKL_VARIABLE_INTEREST_PVT.print_debug('Revenue Recognition Method: '|| p_rev_rec_method);
436: OKL_VARIABLE_INTEREST_PVT.print_debug('Deal Type: '|| p_deal_type);
437: OKL_VARIABLE_INTEREST_PVT.Print_debug('Currency Code: '|| p_currency_code);
438: OKL_VARIABLE_INTEREST_PVT.print_debug('Start Date: '|| p_start_date);
439: OKL_VARIABLE_INTEREST_PVT.print_debug('Due Date: '|| p_due_date);
440:
441: --Bug# 13447258: Variable Rate processing is not allowed for Catchup-Cleanup Loan contracts if

Line 438: OKL_VARIABLE_INTEREST_PVT.print_debug('Start Date: '|| p_start_date);

434: OKL_VARIABLE_INTEREST_PVT.print_Debug('Principal Basis: '|| p_principal_basis);
435: OKL_VARIABLE_INTEREST_PVT.print_debug('Revenue Recognition Method: '|| p_rev_rec_method);
436: OKL_VARIABLE_INTEREST_PVT.print_debug('Deal Type: '|| p_deal_type);
437: OKL_VARIABLE_INTEREST_PVT.Print_debug('Currency Code: '|| p_currency_code);
438: OKL_VARIABLE_INTEREST_PVT.print_debug('Start Date: '|| p_start_date);
439: OKL_VARIABLE_INTEREST_PVT.print_debug('Due Date: '|| p_due_date);
440:
441: --Bug# 13447258: Variable Rate processing is not allowed for Catchup-Cleanup Loan contracts if
442: -- contract streams have not been upgraded to asset level

Line 439: OKL_VARIABLE_INTEREST_PVT.print_debug('Due Date: '|| p_due_date);

435: OKL_VARIABLE_INTEREST_PVT.print_debug('Revenue Recognition Method: '|| p_rev_rec_method);
436: OKL_VARIABLE_INTEREST_PVT.print_debug('Deal Type: '|| p_deal_type);
437: OKL_VARIABLE_INTEREST_PVT.Print_debug('Currency Code: '|| p_currency_code);
438: OKL_VARIABLE_INTEREST_PVT.print_debug('Start Date: '|| p_start_date);
439: OKL_VARIABLE_INTEREST_PVT.print_debug('Due Date: '|| p_due_date);
440:
441: --Bug# 13447258: Variable Rate processing is not allowed for Catchup-Cleanup Loan contracts if
442: -- contract streams have not been upgraded to asset level
443: OKL_VARIABLE_INT_UTIL_PVT.check_vr_asset_level_upgrade(

Line 453: OKL_VARIABLE_INTEREST_PVT.g_vpb_tbl.delete;

449: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
450: RAISE var_int_catchup_failed;
451: END IF;
452:
453: OKL_VARIABLE_INTEREST_PVT.g_vpb_tbl.delete;
454: OKL_VARIABLE_INTEREST_PVT.g_vpb_tbl_counter := 0;
455:
456: OKL_VARIABLE_INTEREST_PVT.populate_txns(
457: p_api_version => p_api_version,

Line 454: OKL_VARIABLE_INTEREST_PVT.g_vpb_tbl_counter := 0;

450: RAISE var_int_catchup_failed;
451: END IF;
452:
453: OKL_VARIABLE_INTEREST_PVT.g_vpb_tbl.delete;
454: OKL_VARIABLE_INTEREST_PVT.g_vpb_tbl_counter := 0;
455:
456: OKL_VARIABLE_INTEREST_PVT.populate_txns(
457: p_api_version => p_api_version,
458: p_init_msg_list => p_init_msg_list,

Line 456: OKL_VARIABLE_INTEREST_PVT.populate_txns(

452:
453: OKL_VARIABLE_INTEREST_PVT.g_vpb_tbl.delete;
454: OKL_VARIABLE_INTEREST_PVT.g_vpb_tbl_counter := 0;
455:
456: OKL_VARIABLE_INTEREST_PVT.populate_txns(
457: p_api_version => p_api_version,
458: p_init_msg_list => p_init_msg_list,
459: p_khr_id => p_contract_id,
460: p_from_date => p_start_date,

Line 467: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to POPULATE_TXNS');

463: x_msg_count => x_msg_count,
464: x_msg_data => x_msg_data);
465:
466: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
467: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to POPULATE_TXNS');
468: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
469: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
470: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to POPULATE_TXNS');
471: RAISE var_int_catchup_failed;

Line 470: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to POPULATE_TXNS');

466: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
467: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to POPULATE_TXNS');
468: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
469: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
470: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to POPULATE_TXNS');
471: RAISE var_int_catchup_failed;
472: END IF;
473:
474: --Bug# 13001695

Line 487: IF OKL_VARIABLE_INTEREST_PVT.G_DAYS_IN_A_MONTH_CODE = '30' THEN

483: RAISE OKL_API.G_EXCEPTION_ERROR;
484: END IF;
485:
486: --Bug# 14165508
487: IF OKL_VARIABLE_INTEREST_PVT.G_DAYS_IN_A_MONTH_CODE = '30' THEN
488:
489: l_payment_tbl := get_conversion_factor(p_khr_id => p_contract_id,
490: p_start_date => p_start_date,
491: p_due_date => p_due_date);

Line 500: OKL_VARIABLE_INTEREST_PVT.g_vir_tbl.delete;

496: FOR l_assets_rec IN l_assets_csr(p_contract_id)
497: LOOP
498:
499: l_cle_id := l_assets_rec.id;
500: OKL_VARIABLE_INTEREST_PVT.g_vir_tbl.delete;
501: OKL_VARIABLE_INTEREST_PVT.g_vir_tbl_counter := 0;
502:
503: OKL_VARIABLE_INTEREST_PVT.print_debug('Calculating Interest for Line ID : ' || l_cle_id);
504:

Line 501: OKL_VARIABLE_INTEREST_PVT.g_vir_tbl_counter := 0;

497: LOOP
498:
499: l_cle_id := l_assets_rec.id;
500: OKL_VARIABLE_INTEREST_PVT.g_vir_tbl.delete;
501: OKL_VARIABLE_INTEREST_PVT.g_vir_tbl_counter := 0;
502:
503: OKL_VARIABLE_INTEREST_PVT.print_debug('Calculating Interest for Line ID : ' || l_cle_id);
504:
505: --Bug# 14165508

Line 503: OKL_VARIABLE_INTEREST_PVT.print_debug('Calculating Interest for Line ID : ' || l_cle_id);

499: l_cle_id := l_assets_rec.id;
500: OKL_VARIABLE_INTEREST_PVT.g_vir_tbl.delete;
501: OKL_VARIABLE_INTEREST_PVT.g_vir_tbl_counter := 0;
502:
503: OKL_VARIABLE_INTEREST_PVT.print_debug('Calculating Interest for Line ID : ' || l_cle_id);
504:
505: --Bug# 14165508
506: IF OKL_VARIABLE_INTEREST_PVT.G_DAYS_IN_A_MONTH_CODE = '30' THEN
507:

Line 506: IF OKL_VARIABLE_INTEREST_PVT.G_DAYS_IN_A_MONTH_CODE = '30' THEN

502:
503: OKL_VARIABLE_INTEREST_PVT.print_debug('Calculating Interest for Line ID : ' || l_cle_id);
504:
505: --Bug# 14165508
506: IF OKL_VARIABLE_INTEREST_PVT.G_DAYS_IN_A_MONTH_CODE = '30' THEN
507:
508: l_interest_calculated := 0;
509: OKL_VARIABLE_INTEREST_PVT.print_debug('l_payment_tbl COUNT '||l_payment_tbl.COUNT);
510: IF (l_payment_tbl.COUNT > 0) THEN

Line 509: OKL_VARIABLE_INTEREST_PVT.print_debug('l_payment_tbl COUNT '||l_payment_tbl.COUNT);

505: --Bug# 14165508
506: IF OKL_VARIABLE_INTEREST_PVT.G_DAYS_IN_A_MONTH_CODE = '30' THEN
507:
508: l_interest_calculated := 0;
509: OKL_VARIABLE_INTEREST_PVT.print_debug('l_payment_tbl COUNT '||l_payment_tbl.COUNT);
510: IF (l_payment_tbl.COUNT > 0) THEN
511: FOR i IN l_payment_tbl.FIRST..l_payment_tbl.LAST LOOP
512:
513: l_interest := OKL_VARIABLE_INTEREST_PVT.calculate_total_interest_due(

Line 513: l_interest := OKL_VARIABLE_INTEREST_PVT.calculate_total_interest_due(

509: OKL_VARIABLE_INTEREST_PVT.print_debug('l_payment_tbl COUNT '||l_payment_tbl.COUNT);
510: IF (l_payment_tbl.COUNT > 0) THEN
511: FOR i IN l_payment_tbl.FIRST..l_payment_tbl.LAST LOOP
512:
513: l_interest := OKL_VARIABLE_INTEREST_PVT.calculate_total_interest_due(
514: p_api_version => 1.0,
515: p_init_msg_list => OKL_API.G_FALSE,
516: x_return_status => x_return_status,
517: x_msg_count => x_msg_count,

Line 526: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to CALCULATE_TOTAL_INTEREST_DUE');

522: p_due_date => l_payment_tbl(i).period_end_date,
523: p_line_id => l_cle_id,
524: p_conversion_factor => l_payment_tbl(i).conversion_factor);
525: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
526: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to CALCULATE_TOTAL_INTEREST_DUE');
527: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
528: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
529: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to CALCULATE_TOTAL_INTEREST_DUE');
530: RAISE var_int_catchup_failed;

Line 529: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to CALCULATE_TOTAL_INTEREST_DUE');

525: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
526: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to CALCULATE_TOTAL_INTEREST_DUE');
527: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
528: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
529: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to CALCULATE_TOTAL_INTEREST_DUE');
530: RAISE var_int_catchup_failed;
531: END IF;
532:
533: l_interest_calculated := l_interest_calculated + NVL(l_interest,0);

Line 538: l_interest_calculated := OKL_VARIABLE_INTEREST_PVT.calculate_total_interest_due(

534: END LOOP;
535: END IF;
536: ELSE
537:
538: l_interest_calculated := OKL_VARIABLE_INTEREST_PVT.calculate_total_interest_due(
539: p_api_version => 1.0,
540: p_init_msg_list => OKL_API.G_FALSE,
541: x_return_status => x_return_status,
542: x_msg_count => x_msg_count,

Line 550: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to CALCULATE_TOTAL_INTEREST_DUE');

546: p_start_date => p_start_date,
547: p_due_date => p_due_date,
548: p_line_id => l_cle_id);
549: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
550: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to CALCULATE_TOTAL_INTEREST_DUE');
551: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
552: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
553: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to CALCULATE_TOTAL_INTEREST_DUE');
554: RAISE var_int_catchup_failed;

Line 553: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to CALCULATE_TOTAL_INTEREST_DUE');

549: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
550: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to CALCULATE_TOTAL_INTEREST_DUE');
551: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
552: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
553: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to CALCULATE_TOTAL_INTEREST_DUE');
554: RAISE var_int_catchup_failed;
555: END IF;
556:
557: END IF;

Line 560: OKL_VARIABLE_INTEREST_PVT.print_debug('Interest Calculated : ' || l_interest_calculated);

556:
557: END IF;
558: --Bug# 14165508
559:
560: OKL_VARIABLE_INTEREST_PVT.print_debug('Interest Calculated : ' || l_interest_calculated);
561: l_total_interest_billed := 0;
562:
563: IF (p_deal_type = 'LOAN') THEN
564: IF (p_principal_basis = 'ACTUAL') THEN

Line 568: IF (p_due_date = OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_END_DATE) THEN

564: IF (p_principal_basis = 'ACTUAL') THEN
565: IF (p_rev_rec_method = 'STREAMS') THEN
566:
567: --fix for bug 5072399
568: IF (p_due_date = OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_END_DATE) THEN
569:
570: --Bug# 13001695: Effective Date of Interest Catchup should be last day of previous period
571: -- regardless of SGT Arrears option
572:

Line 583: OKL_VARIABLE_INTEREST_PVT.print_debug('Interest Payment Billed : ' || l_interest_billed);

579: l_interest_billed := 0;
580: END IF;
581: CLOSE int_pay_amt_end_date_csr;
582:
583: OKL_VARIABLE_INTEREST_PVT.print_debug('Interest Payment Billed : ' || l_interest_billed);
584:
585: IF (l_arrears_pay_dates_option = 'FIRST_DAY_OF_NEXT_PERIOD') THEN
586: l_stream_element_start_date := p_start_date + 1;
587: END IF;

Line 596: OKL_VARIABLE_INTEREST_PVT.print_debug('Interest Catchup Billed : ' || l_catchup_interest_billed);

592: l_catchup_interest_billed := 0;
593: END IF;
594: CLOSE int_pay_amt_end_date_csr;
595:
596: OKL_VARIABLE_INTEREST_PVT.print_debug('Interest Catchup Billed : ' || l_catchup_interest_billed);
597:
598: l_total_interest_billed := l_interest_billed + l_catchup_interest_billed;
599:
600: --Bug# 13001695

Line 618: OKL_VARIABLE_INTEREST_PVT.print_debug('Interest Payment Billed : ' || l_interest_billed);

614: l_interest_billed := 0;
615: END IF;
616: CLOSE interest_payment_amount_csr;
617:
618: OKL_VARIABLE_INTEREST_PVT.print_debug('Interest Payment Billed : ' || l_interest_billed);
619:
620: IF (l_arrears_pay_dates_option = 'FIRST_DAY_OF_NEXT_PERIOD') THEN
621: l_stream_element_start_date := p_start_date + 1;
622: l_stream_element_end_date := p_due_date + 1;

Line 632: OKL_VARIABLE_INTEREST_PVT.print_debug('Interest Catchup Billed : ' || l_catchup_interest_billed);

628: l_catchup_interest_billed := 0;
629: END IF;
630: CLOSE interest_payment_amount_csr;
631:
632: OKL_VARIABLE_INTEREST_PVT.print_debug('Interest Catchup Billed : ' || l_catchup_interest_billed);
633:
634: l_total_interest_billed := l_interest_billed + l_catchup_interest_billed;
635:
636: --Bug# 13001695

Line 642: OKL_VARIABLE_INTEREST_PVT.print_debug('Interest Billed before considering Principal Catchup: ' || l_total_interest_billed);

638: END IF;
639:
640: --Bug# 13043342: Reduce Principal Adjustment to calculate Net Interest Billed
641:
642: OKL_VARIABLE_INTEREST_PVT.print_debug('Interest Billed before considering Principal Catchup: ' || l_total_interest_billed);
643:
644: OPEN principal_adjustment_csr (p_contract_id, p_start_date, p_due_date,l_cle_id);
645: FETCH principal_adjustment_csr INTO l_principal_adjusted;
646: IF (principal_adjustment_csr % NOTFOUND) THEN

Line 651: OKL_VARIABLE_INTEREST_PVT.print_debug('Principal Catchup: ' || l_principal_adjusted);

647: l_principal_adjusted := 0;
648: END IF;
649: CLOSE principal_adjustment_csr;
650:
651: OKL_VARIABLE_INTEREST_PVT.print_debug('Principal Catchup: ' || l_principal_adjusted);
652:
653: IF (l_principal_adjusted > 0) THEN
654: l_total_interest_billed := l_total_interest_billed - l_principal_adjusted;
655: END IF;

Line 658: OKL_VARIABLE_INTEREST_PVT.print_debug('Net Interest Billed : ' || l_total_interest_billed);

654: l_total_interest_billed := l_total_interest_billed - l_principal_adjusted;
655: END IF;
656: --Bug# 13043342
657:
658: OKL_VARIABLE_INTEREST_PVT.print_debug('Net Interest Billed : ' || l_total_interest_billed);
659: l_invoice_amt := OKL_ACCOUNTING_UTIL.round_amount(l_interest_calculated - l_total_interest_billed, p_currency_code);
660:
661: OKL_VARIABLE_INTEREST_PVT.Print_debug ('Invoice Amount : '|| l_invoice_amt);
662:

Line 661: OKL_VARIABLE_INTEREST_PVT.Print_debug ('Invoice Amount : '|| l_invoice_amt);

657:
658: OKL_VARIABLE_INTEREST_PVT.print_debug('Net Interest Billed : ' || l_total_interest_billed);
659: l_invoice_amt := OKL_ACCOUNTING_UTIL.round_amount(l_interest_calculated - l_total_interest_billed, p_currency_code);
660:
661: OKL_VARIABLE_INTEREST_PVT.Print_debug ('Invoice Amount : '|| l_invoice_amt);
662:
663: --Bug# 12974796
664: OPEN contract_csr(p_khr_id => p_contract_id);
665: FETCH contract_csr INTO l_contract_rec;

Line 695: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to CREATE_STREAM_INVOICE');

691: p_parent_strm_element_id => NULL,
692: x_invoice_id => l_invoice_id,
693: x_stream_element_id => l_stream_element_id);
694: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
695: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to CREATE_STREAM_INVOICE');
696: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
697: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
698: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to CREATE_STREAM_INVOICE');
699: RAISE var_int_catchup_failed;

Line 698: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to CREATE_STREAM_INVOICE');

694: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
695: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to CREATE_STREAM_INVOICE');
696: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
697: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
698: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to CREATE_STREAM_INVOICE');
699: RAISE var_int_catchup_failed;
700: END IF;
701:
702: i_vir_tbl := OKL_VARIABLE_INTEREST_PVT.g_vir_tbl;

Line 702: i_vir_tbl := OKL_VARIABLE_INTEREST_PVT.g_vir_tbl;

698: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to CREATE_STREAM_INVOICE');
699: RAISE var_int_catchup_failed;
700: END IF;
701:
702: i_vir_tbl := OKL_VARIABLE_INTEREST_PVT.g_vir_tbl;
703:
704: OKL_VARIABLE_INTEREST_PVT.upd_vir_params_with_invoice (
705: p_api_version => 1.0,
706: p_init_msg_list => OKL_API.G_TRUE,

Line 704: OKL_VARIABLE_INTEREST_PVT.upd_vir_params_with_invoice (

700: END IF;
701:
702: i_vir_tbl := OKL_VARIABLE_INTEREST_PVT.g_vir_tbl;
703:
704: OKL_VARIABLE_INTEREST_PVT.upd_vir_params_with_invoice (
705: p_api_version => 1.0,
706: p_init_msg_list => OKL_API.G_TRUE,
707: x_return_status => x_return_status,
708: x_msg_count => x_msg_count,

Line 716: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to UPD_VIR_PARAMS_WITH_INVOICE');

712: p_catchup_settlement_code => 'INTEREST_CATCHUP',
713: p_vir_tbl => i_vir_tbl,
714: x_vir_tbl => r_vir_tbl);
715: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
716: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to UPD_VIR_PARAMS_WITH_INVOICE');
717: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
718: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
719: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to UPD_VIR_PARAMS_WITH_INVOICE');
720: RAISE var_int_catchup_failed;

Line 719: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to UPD_VIR_PARAMS_WITH_INVOICE');

715: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
716: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to UPD_VIR_PARAMS_WITH_INVOICE');
717: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
718: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
719: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to UPD_VIR_PARAMS_WITH_INVOICE');
720: RAISE var_int_catchup_failed;
721: END IF;
722:
723: OKL_VARIABLE_INTEREST_PVT.g_vir_tbl := r_vir_tbl;

Line 723: OKL_VARIABLE_INTEREST_PVT.g_vir_tbl := r_vir_tbl;

719: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to UPD_VIR_PARAMS_WITH_INVOICE');
720: RAISE var_int_catchup_failed;
721: END IF;
722:
723: OKL_VARIABLE_INTEREST_PVT.g_vir_tbl := r_vir_tbl;
724:
725: OKL_VR_DATA_HANDLER_PVT.insert_vir_params(
726: p_api_version => 1.0,
727: p_init_msg_list => OKL_API.G_TRUE,

Line 731: p_vir_tbl => OKL_VARIABLE_INTEREST_PVT.g_vir_tbl);

727: p_init_msg_list => OKL_API.G_TRUE,
728: x_return_status => x_return_status,
729: x_msg_count => x_msg_count,
730: x_msg_data => x_msg_data,
731: p_vir_tbl => OKL_VARIABLE_INTEREST_PVT.g_vir_tbl);
732: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
733: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to POPULATE_VIR_PARAMS');
734: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
735: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 733: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to POPULATE_VIR_PARAMS');

729: x_msg_count => x_msg_count,
730: x_msg_data => x_msg_data,
731: p_vir_tbl => OKL_VARIABLE_INTEREST_PVT.g_vir_tbl);
732: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
733: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to POPULATE_VIR_PARAMS');
734: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
735: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
736: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to POPULATE_VIR_PARAMS');
737: RAISE var_int_catchup_failed;

Line 736: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to POPULATE_VIR_PARAMS');

732: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
733: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to POPULATE_VIR_PARAMS');
734: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
735: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
736: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to POPULATE_VIR_PARAMS');
737: RAISE var_int_catchup_failed;
738: END IF;
739:
740: ELSIF (l_invoice_amt < 0) THEN

Line 742: OKL_VARIABLE_INTEREST_PVT.print_debug (' catchup settlement code : '|| OKL_VARIABLE_INTEREST_PVT.G_CATCHUP_SETTLEMENT_CODE);

738: END IF;
739:
740: ELSIF (l_invoice_amt < 0) THEN
741:
742: OKL_VARIABLE_INTEREST_PVT.print_debug (' catchup settlement code : '|| OKL_VARIABLE_INTEREST_PVT.G_CATCHUP_SETTLEMENT_CODE);
743:
744: IF (OKL_VARIABLE_INTEREST_PVT.G_CATCHUP_SETTLEMENT_CODE = 'CREDIT') THEN
745:
746: l_stream_type_purpose := 'INTEREST_CATCHUP';

Line 744: IF (OKL_VARIABLE_INTEREST_PVT.G_CATCHUP_SETTLEMENT_CODE = 'CREDIT') THEN

740: ELSIF (l_invoice_amt < 0) THEN
741:
742: OKL_VARIABLE_INTEREST_PVT.print_debug (' catchup settlement code : '|| OKL_VARIABLE_INTEREST_PVT.G_CATCHUP_SETTLEMENT_CODE);
743:
744: IF (OKL_VARIABLE_INTEREST_PVT.G_CATCHUP_SETTLEMENT_CODE = 'CREDIT') THEN
745:
746: l_stream_type_purpose := 'INTEREST_CATCHUP';
747: OKL_VR_DOCUMENT_PVT.Create_Stream_Invoice (
748: p_api_version => 1.0,

Line 765: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to CREATE_STREAM_INVOICE');

761: x_invoice_id => l_invoice_id,
762: x_stream_element_id => l_stream_element_id);
763:
764: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
765: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to CREATE_STREAM_INVOICE');
766: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
767: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
768: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to CREATE_STREAM_INVOICE');
769: RAISE var_int_catchup_failed;

Line 768: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to CREATE_STREAM_INVOICE');

764: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
765: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to CREATE_STREAM_INVOICE');
766: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
767: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
768: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to CREATE_STREAM_INVOICE');
769: RAISE var_int_catchup_failed;
770: END IF;
771:
772: i_vir_tbl := OKL_VARIABLE_INTEREST_PVT.g_vir_tbl;

Line 772: i_vir_tbl := OKL_VARIABLE_INTEREST_PVT.g_vir_tbl;

768: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to CREATE_STREAM_INVOICE');
769: RAISE var_int_catchup_failed;
770: END IF;
771:
772: i_vir_tbl := OKL_VARIABLE_INTEREST_PVT.g_vir_tbl;
773:
774: OKL_VARIABLE_INTEREST_PVT.upd_vir_params_with_invoice (
775: p_api_version => 1.0,
776: p_init_msg_list => OKL_API.G_TRUE,

Line 774: OKL_VARIABLE_INTEREST_PVT.upd_vir_params_with_invoice (

770: END IF;
771:
772: i_vir_tbl := OKL_VARIABLE_INTEREST_PVT.g_vir_tbl;
773:
774: OKL_VARIABLE_INTEREST_PVT.upd_vir_params_with_invoice (
775: p_api_version => 1.0,
776: p_init_msg_list => OKL_API.G_TRUE,
777: x_return_status => x_return_status,
778: x_msg_count => x_msg_count,

Line 782: p_catchup_settlement_code => OKL_VARIABLE_INTEREST_PVT.G_CATCHUP_SETTLEMENT_CODE,

778: x_msg_count => x_msg_count,
779: x_msg_data => x_msg_data,
780: p_source_id => l_invoice_id,
781: p_catchup_amt => l_invoice_amt,
782: p_catchup_settlement_code => OKL_VARIABLE_INTEREST_PVT.G_CATCHUP_SETTLEMENT_CODE,
783: p_vir_tbl => i_vir_tbl,
784: x_vir_tbl => r_vir_tbl);
785: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
786: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to UPD_VIR_PARAMS_WITH_INVOICE');

Line 786: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to UPD_VIR_PARAMS_WITH_INVOICE');

782: p_catchup_settlement_code => OKL_VARIABLE_INTEREST_PVT.G_CATCHUP_SETTLEMENT_CODE,
783: p_vir_tbl => i_vir_tbl,
784: x_vir_tbl => r_vir_tbl);
785: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
786: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to UPD_VIR_PARAMS_WITH_INVOICE');
787: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
788: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
789: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to UPD_VIR_PARAMS_WITH_INVOICE');
790: RAISE var_int_catchup_failed;

Line 789: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to UPD_VIR_PARAMS_WITH_INVOICE');

785: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
786: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to UPD_VIR_PARAMS_WITH_INVOICE');
787: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
788: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
789: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to UPD_VIR_PARAMS_WITH_INVOICE');
790: RAISE var_int_catchup_failed;
791: END IF;
792:
793: OKL_VARIABLE_INTEREST_PVT.g_vir_tbl := r_vir_tbl;

Line 793: OKL_VARIABLE_INTEREST_PVT.g_vir_tbl := r_vir_tbl;

789: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to UPD_VIR_PARAMS_WITH_INVOICE');
790: RAISE var_int_catchup_failed;
791: END IF;
792:
793: OKL_VARIABLE_INTEREST_PVT.g_vir_tbl := r_vir_tbl;
794:
795: OKL_VR_DATA_HANDLER_PVT.insert_vir_params(
796: p_api_version => 1.0,
797: p_init_msg_list => OKL_API.G_TRUE,

Line 801: p_vir_tbl => OKL_VARIABLE_INTEREST_PVT.g_vir_tbl);

797: p_init_msg_list => OKL_API.G_TRUE,
798: x_return_status => x_return_status,
799: x_msg_count => x_msg_count,
800: x_msg_data => x_msg_data,
801: p_vir_tbl => OKL_VARIABLE_INTEREST_PVT.g_vir_tbl);
802: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
803: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to POPULATE_VIR_PARAMS');
804: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
805: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 803: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to POPULATE_VIR_PARAMS');

799: x_msg_count => x_msg_count,
800: x_msg_data => x_msg_data,
801: p_vir_tbl => OKL_VARIABLE_INTEREST_PVT.g_vir_tbl);
802: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
803: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to POPULATE_VIR_PARAMS');
804: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
805: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
806: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to POPULATE_VIR_PARAMS');
807: RAISE var_int_catchup_failed;

Line 806: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to POPULATE_VIR_PARAMS');

802: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
803: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to POPULATE_VIR_PARAMS');
804: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
805: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
806: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to POPULATE_VIR_PARAMS');
807: RAISE var_int_catchup_failed;
808: END IF;
809:
810: ELSIF (OKL_VARIABLE_INTEREST_PVT.G_CATCHUP_SETTLEMENT_CODE = 'ADJUST') THEN

Line 810: ELSIF (OKL_VARIABLE_INTEREST_PVT.G_CATCHUP_SETTLEMENT_CODE = 'ADJUST') THEN

806: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to POPULATE_VIR_PARAMS');
807: RAISE var_int_catchup_failed;
808: END IF;
809:
810: ELSIF (OKL_VARIABLE_INTEREST_PVT.G_CATCHUP_SETTLEMENT_CODE = 'ADJUST') THEN
811:
812: l_invoice_amt := -1 * l_invoice_amt;
813:
814: OKL_VARIABLE_INTEREST_PVT.print_debug('Net Invoice amount after adjustment : '|| l_invoice_amt);

Line 814: OKL_VARIABLE_INTEREST_PVT.print_debug('Net Invoice amount after adjustment : '|| l_invoice_amt);

810: ELSIF (OKL_VARIABLE_INTEREST_PVT.G_CATCHUP_SETTLEMENT_CODE = 'ADJUST') THEN
811:
812: l_invoice_amt := -1 * l_invoice_amt;
813:
814: OKL_VARIABLE_INTEREST_PVT.print_debug('Net Invoice amount after adjustment : '|| l_invoice_amt);
815:
816: OKL_VARIABLE_INTEREST_PVT.print_debug('Creating PRINCIPAL_CATCHUP adjustment streams for asset id : ' || l_cle_id || ' for Amount :' || l_invoice_amt);
817: l_stream_type_purpose := 'PRINCIPAL_CATCHUP';
818: OKL_VR_DOCUMENT_PVT.Create_Stream_Invoice (

Line 816: OKL_VARIABLE_INTEREST_PVT.print_debug('Creating PRINCIPAL_CATCHUP adjustment streams for asset id : ' || l_cle_id || ' for Amount :' || l_invoice_amt);

812: l_invoice_amt := -1 * l_invoice_amt;
813:
814: OKL_VARIABLE_INTEREST_PVT.print_debug('Net Invoice amount after adjustment : '|| l_invoice_amt);
815:
816: OKL_VARIABLE_INTEREST_PVT.print_debug('Creating PRINCIPAL_CATCHUP adjustment streams for asset id : ' || l_cle_id || ' for Amount :' || l_invoice_amt);
817: l_stream_type_purpose := 'PRINCIPAL_CATCHUP';
818: OKL_VR_DOCUMENT_PVT.Create_Stream_Invoice (
819: p_api_version => 1.0,
820: p_init_msg_list => p_init_msg_list,

Line 836: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to CREATE_STREAM_INVOICE');

832: x_invoice_id => l_invoice_id,
833: x_stream_element_id => l_stream_element_id);
834:
835: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
836: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to CREATE_STREAM_INVOICE');
837: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
838: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
839: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to CREATE_STREAM_INVOICE');
840: RAISE var_int_catchup_failed;

Line 839: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to CREATE_STREAM_INVOICE');

835: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
836: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to CREATE_STREAM_INVOICE');
837: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
838: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
839: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to CREATE_STREAM_INVOICE');
840: RAISE var_int_catchup_failed;
841: END IF;
842:
843: OKL_VARIABLE_INTEREST_PVT.print_debug('Successfully created PRINCIPAL_CATCHUP adjustment streams for asset id : ' || l_cle_id || ' for Amount :' || l_invoice_amt);

Line 843: OKL_VARIABLE_INTEREST_PVT.print_debug('Successfully created PRINCIPAL_CATCHUP adjustment streams for asset id : ' || l_cle_id || ' for Amount :' || l_invoice_amt);

839: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to CREATE_STREAM_INVOICE');
840: RAISE var_int_catchup_failed;
841: END IF;
842:
843: OKL_VARIABLE_INTEREST_PVT.print_debug('Successfully created PRINCIPAL_CATCHUP adjustment streams for asset id : ' || l_cle_id || ' for Amount :' || l_invoice_amt);
844:
845: i_vir_tbl := OKL_VARIABLE_INTEREST_PVT.g_vir_tbl;
846:
847: OKL_VARIABLE_INTEREST_PVT.upd_vir_params_with_invoice (

Line 845: i_vir_tbl := OKL_VARIABLE_INTEREST_PVT.g_vir_tbl;

841: END IF;
842:
843: OKL_VARIABLE_INTEREST_PVT.print_debug('Successfully created PRINCIPAL_CATCHUP adjustment streams for asset id : ' || l_cle_id || ' for Amount :' || l_invoice_amt);
844:
845: i_vir_tbl := OKL_VARIABLE_INTEREST_PVT.g_vir_tbl;
846:
847: OKL_VARIABLE_INTEREST_PVT.upd_vir_params_with_invoice (
848: p_api_version => 1.0,
849: p_init_msg_list => OKL_API.G_TRUE,

Line 847: OKL_VARIABLE_INTEREST_PVT.upd_vir_params_with_invoice (

843: OKL_VARIABLE_INTEREST_PVT.print_debug('Successfully created PRINCIPAL_CATCHUP adjustment streams for asset id : ' || l_cle_id || ' for Amount :' || l_invoice_amt);
844:
845: i_vir_tbl := OKL_VARIABLE_INTEREST_PVT.g_vir_tbl;
846:
847: OKL_VARIABLE_INTEREST_PVT.upd_vir_params_with_invoice (
848: p_api_version => 1.0,
849: p_init_msg_list => OKL_API.G_TRUE,
850: x_return_status => x_return_status,
851: x_msg_count => x_msg_count,

Line 855: p_catchup_settlement_code => OKL_VARIABLE_INTEREST_PVT.G_CATCHUP_SETTLEMENT_CODE,

851: x_msg_count => x_msg_count,
852: x_msg_data => x_msg_data,
853: p_source_id => l_stream_element_id,
854: p_catchup_amt => (-1 * l_invoice_amt),
855: p_catchup_settlement_code => OKL_VARIABLE_INTEREST_PVT.G_CATCHUP_SETTLEMENT_CODE,
856: p_vir_tbl => i_vir_tbl,
857: x_vir_tbl => r_vir_tbl,
858: --Bug# 12974796
859: p_source_table => 'OKL_STRM_ELEMENTS_V');

Line 861: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to UPD_VIR_PARAMS_WITH_INVOICE');

857: x_vir_tbl => r_vir_tbl,
858: --Bug# 12974796
859: p_source_table => 'OKL_STRM_ELEMENTS_V');
860: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
861: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to UPD_VIR_PARAMS_WITH_INVOICE');
862: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
863: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
864: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to UPD_VIR_PARAMS_WITH_INVOICE');
865: RAISE var_int_catchup_failed;

Line 864: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to UPD_VIR_PARAMS_WITH_INVOICE');

860: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
861: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to UPD_VIR_PARAMS_WITH_INVOICE');
862: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
863: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
864: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to UPD_VIR_PARAMS_WITH_INVOICE');
865: RAISE var_int_catchup_failed;
866: END IF;
867:
868: OKL_VARIABLE_INTEREST_PVT.g_vir_tbl := r_vir_tbl;

Line 868: OKL_VARIABLE_INTEREST_PVT.g_vir_tbl := r_vir_tbl;

864: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to UPD_VIR_PARAMS_WITH_INVOICE');
865: RAISE var_int_catchup_failed;
866: END IF;
867:
868: OKL_VARIABLE_INTEREST_PVT.g_vir_tbl := r_vir_tbl;
869:
870: OKL_VR_DATA_HANDLER_PVT.insert_vir_params(
871: p_api_version => 1.0,
872: p_init_msg_list => OKL_API.G_TRUE,

Line 876: p_vir_tbl => OKL_VARIABLE_INTEREST_PVT.g_vir_tbl);

872: p_init_msg_list => OKL_API.G_TRUE,
873: x_return_status => x_return_status,
874: x_msg_count => x_msg_count,
875: x_msg_data => x_msg_data,
876: p_vir_tbl => OKL_VARIABLE_INTEREST_PVT.g_vir_tbl);
877: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
878: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to POPULATE_VIR_PARAMS');
879: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
880: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 878: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to POPULATE_VIR_PARAMS');

874: x_msg_count => x_msg_count,
875: x_msg_data => x_msg_data,
876: p_vir_tbl => OKL_VARIABLE_INTEREST_PVT.g_vir_tbl);
877: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
878: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to POPULATE_VIR_PARAMS');
879: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
880: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
881: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to POPULATE_VIR_PARAMS');
882: RAISE var_int_catchup_failed;

Line 881: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to POPULATE_VIR_PARAMS');

877: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
878: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to POPULATE_VIR_PARAMS');
879: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
880: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
881: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to POPULATE_VIR_PARAMS');
882: RAISE var_int_catchup_failed;
883: END IF;
884: --Bug# 12974796
885: ELSIF (OKL_VARIABLE_INTEREST_PVT.G_CATCHUP_SETTLEMENT_CODE = 'NOT_ADJUST') THEN

Line 885: ELSIF (OKL_VARIABLE_INTEREST_PVT.G_CATCHUP_SETTLEMENT_CODE = 'NOT_ADJUST') THEN

881: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to POPULATE_VIR_PARAMS');
882: RAISE var_int_catchup_failed;
883: END IF;
884: --Bug# 12974796
885: ELSIF (OKL_VARIABLE_INTEREST_PVT.G_CATCHUP_SETTLEMENT_CODE = 'NOT_ADJUST') THEN
886:
887: i_vir_tbl := OKL_VARIABLE_INTEREST_PVT.g_vir_tbl;
888:
889: OKL_VARIABLE_INTEREST_PVT.upd_vir_params_with_invoice (

Line 887: i_vir_tbl := OKL_VARIABLE_INTEREST_PVT.g_vir_tbl;

883: END IF;
884: --Bug# 12974796
885: ELSIF (OKL_VARIABLE_INTEREST_PVT.G_CATCHUP_SETTLEMENT_CODE = 'NOT_ADJUST') THEN
886:
887: i_vir_tbl := OKL_VARIABLE_INTEREST_PVT.g_vir_tbl;
888:
889: OKL_VARIABLE_INTEREST_PVT.upd_vir_params_with_invoice (
890: p_api_version => 1.0,
891: p_init_msg_list => OKL_API.G_TRUE,

Line 889: OKL_VARIABLE_INTEREST_PVT.upd_vir_params_with_invoice (

885: ELSIF (OKL_VARIABLE_INTEREST_PVT.G_CATCHUP_SETTLEMENT_CODE = 'NOT_ADJUST') THEN
886:
887: i_vir_tbl := OKL_VARIABLE_INTEREST_PVT.g_vir_tbl;
888:
889: OKL_VARIABLE_INTEREST_PVT.upd_vir_params_with_invoice (
890: p_api_version => 1.0,
891: p_init_msg_list => OKL_API.G_TRUE,
892: x_return_status => x_return_status,
893: x_msg_count => x_msg_count,

Line 897: p_catchup_settlement_code => OKL_VARIABLE_INTEREST_PVT.G_CATCHUP_SETTLEMENT_CODE,

893: x_msg_count => x_msg_count,
894: x_msg_data => x_msg_data,
895: p_source_id => NULL,
896: p_catchup_amt => l_invoice_amt,
897: p_catchup_settlement_code => OKL_VARIABLE_INTEREST_PVT.G_CATCHUP_SETTLEMENT_CODE,
898: p_vir_tbl => i_vir_tbl,
899: x_vir_tbl => r_vir_tbl,
900: --Bug# 12974796
901: p_source_table => 'OKL_VAR_INT_PARAMS');

Line 903: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to UPD_VIR_PARAMS_WITH_INVOICE');

899: x_vir_tbl => r_vir_tbl,
900: --Bug# 12974796
901: p_source_table => 'OKL_VAR_INT_PARAMS');
902: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
903: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to UPD_VIR_PARAMS_WITH_INVOICE');
904: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
905: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
906: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to UPD_VIR_PARAMS_WITH_INVOICE');
907: RAISE var_int_catchup_failed;

Line 906: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to UPD_VIR_PARAMS_WITH_INVOICE');

902: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
903: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to UPD_VIR_PARAMS_WITH_INVOICE');
904: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
905: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
906: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to UPD_VIR_PARAMS_WITH_INVOICE');
907: RAISE var_int_catchup_failed;
908: END IF;
909:
910: OKL_VARIABLE_INTEREST_PVT.g_vir_tbl := r_vir_tbl;

Line 910: OKL_VARIABLE_INTEREST_PVT.g_vir_tbl := r_vir_tbl;

906: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to UPD_VIR_PARAMS_WITH_INVOICE');
907: RAISE var_int_catchup_failed;
908: END IF;
909:
910: OKL_VARIABLE_INTEREST_PVT.g_vir_tbl := r_vir_tbl;
911:
912: OKL_VR_DATA_HANDLER_PVT.insert_vir_params(
913: p_api_version => 1.0,
914: p_init_msg_list => OKL_API.G_TRUE,

Line 918: p_vir_tbl => OKL_VARIABLE_INTEREST_PVT.g_vir_tbl);

914: p_init_msg_list => OKL_API.G_TRUE,
915: x_return_status => x_return_status,
916: x_msg_count => x_msg_count,
917: x_msg_data => x_msg_data,
918: p_vir_tbl => OKL_VARIABLE_INTEREST_PVT.g_vir_tbl);
919: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
920: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to POPULATE_VIR_PARAMS');
921: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
922: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 920: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to POPULATE_VIR_PARAMS');

916: x_msg_count => x_msg_count,
917: x_msg_data => x_msg_data,
918: p_vir_tbl => OKL_VARIABLE_INTEREST_PVT.g_vir_tbl);
919: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
920: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to POPULATE_VIR_PARAMS');
921: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
922: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
923: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to POPULATE_VIR_PARAMS');
924: RAISE var_int_catchup_failed;

Line 923: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to POPULATE_VIR_PARAMS');

919: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
920: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to POPULATE_VIR_PARAMS');
921: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
922: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
923: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to POPULATE_VIR_PARAMS');
924: RAISE var_int_catchup_failed;
925: END IF;
926: END IF;
927: --Bug# 12974796

Line 941: p_vpb_tbl => OKL_VARIABLE_INTEREST_PVT.g_vpb_tbl);

937: p_init_msg_list => p_init_msg_list,
938: x_return_status => x_return_status,
939: x_msg_count => x_msg_count,
940: x_msg_data => x_msg_data,
941: p_vpb_tbl => OKL_VARIABLE_INTEREST_PVT.g_vpb_tbl);
942:
943: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
944: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to POPULATE_PRINCIPAL_BAL_TXN');
945: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 944: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to POPULATE_PRINCIPAL_BAL_TXN');

940: x_msg_data => x_msg_data,
941: p_vpb_tbl => OKL_VARIABLE_INTEREST_PVT.g_vpb_tbl);
942:
943: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
944: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to POPULATE_PRINCIPAL_BAL_TXN');
945: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
946: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
947: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to POPULATE_PRINCIPAL_BAL_TXN');
948: RAISE var_int_catchup_failed;

Line 947: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to POPULATE_PRINCIPAL_BAL_TXN');

943: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
944: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to POPULATE_PRINCIPAL_BAL_TXN');
945: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
946: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
947: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to POPULATE_PRINCIPAL_BAL_TXN');
948: RAISE var_int_catchup_failed;
949: END IF;
950:
951: OKL_VARIABLE_INTEREST_PVT.g_vpb_tbl.delete;

Line 951: OKL_VARIABLE_INTEREST_PVT.g_vpb_tbl.delete;

947: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to POPULATE_PRINCIPAL_BAL_TXN');
948: RAISE var_int_catchup_failed;
949: END IF;
950:
951: OKL_VARIABLE_INTEREST_PVT.g_vpb_tbl.delete;
952: OKL_VARIABLE_INTEREST_PVT.g_vpb_tbl_counter := 0;
953:
954: EXCEPTION
955: WHEN var_int_catchup_failed THEN

Line 952: OKL_VARIABLE_INTEREST_PVT.g_vpb_tbl_counter := 0;

948: RAISE var_int_catchup_failed;
949: END IF;
950:
951: OKL_VARIABLE_INTEREST_PVT.g_vpb_tbl.delete;
952: OKL_VARIABLE_INTEREST_PVT.g_vpb_tbl_counter := 0;
953:
954: EXCEPTION
955: WHEN var_int_catchup_failed THEN
956: OKL_VARIABLE_INTEREST_PVT.print_error_message ('Exception var_int_catchup_failed raised in procedure VARIABLE_INTEREST_CATCHUP');

Line 956: OKL_VARIABLE_INTEREST_PVT.print_error_message ('Exception var_int_catchup_failed raised in procedure VARIABLE_INTEREST_CATCHUP');

952: OKL_VARIABLE_INTEREST_PVT.g_vpb_tbl_counter := 0;
953:
954: EXCEPTION
955: WHEN var_int_catchup_failed THEN
956: OKL_VARIABLE_INTEREST_PVT.print_error_message ('Exception var_int_catchup_failed raised in procedure VARIABLE_INTEREST_CATCHUP');
957: x_return_status := OKL_API.G_RET_STS_ERROR;
958: WHEN OTHERS THEN
959: OKL_VARIABLE_INTEREST_PVT.print_error_message ('Exception raised in procedure VARIABLE_INTEREST_CATCHUP');
960: Okl_Api.SET_MESSAGE(

Line 959: OKL_VARIABLE_INTEREST_PVT.print_error_message ('Exception raised in procedure VARIABLE_INTEREST_CATCHUP');

955: WHEN var_int_catchup_failed THEN
956: OKL_VARIABLE_INTEREST_PVT.print_error_message ('Exception var_int_catchup_failed raised in procedure VARIABLE_INTEREST_CATCHUP');
957: x_return_status := OKL_API.G_RET_STS_ERROR;
958: WHEN OTHERS THEN
959: OKL_VARIABLE_INTEREST_PVT.print_error_message ('Exception raised in procedure VARIABLE_INTEREST_CATCHUP');
960: Okl_Api.SET_MESSAGE(
961: p_app_name => G_APP_NAME,
962: p_msg_name => G_UNEXPECTED_ERROR,
963: p_token1 => G_SQLCODE_TOKEN,

Line 1006: OKL_VARIABLE_INTEREST_PVT.Print_Debug ('Principal Basis : '|| OKL_VARIABLE_INTEREST_PVT.G_PRINCIPAL_BASIS_CODE);

1002: l_last_interest_cal_date := p_last_interest_cal_date;
1003: l_catchup_date := get_next_catchup_date(p_contract_id);
1004: l_calculate_from_khr_start := 'Y';
1005:
1006: OKL_VARIABLE_INTEREST_PVT.Print_Debug ('Principal Basis : '|| OKL_VARIABLE_INTEREST_PVT.G_PRINCIPAL_BASIS_CODE);
1007: OKL_VARIABLE_INTEREST_PVT.Print_Debug ('Catchup Date : '|| l_catchup_date);
1008:
1009: LOOP
1010: IF (l_catchup_date > NVL(l_last_interest_cal_date, l_catchup_date - 1) AND

Line 1007: OKL_VARIABLE_INTEREST_PVT.Print_Debug ('Catchup Date : '|| l_catchup_date);

1003: l_catchup_date := get_next_catchup_date(p_contract_id);
1004: l_calculate_from_khr_start := 'Y';
1005:
1006: OKL_VARIABLE_INTEREST_PVT.Print_Debug ('Principal Basis : '|| OKL_VARIABLE_INTEREST_PVT.G_PRINCIPAL_BASIS_CODE);
1007: OKL_VARIABLE_INTEREST_PVT.Print_Debug ('Catchup Date : '|| l_catchup_date);
1008:
1009: LOOP
1010: IF (l_catchup_date > NVL(l_last_interest_cal_date, l_catchup_date - 1) AND
1011: l_catchup_date <= (trunc(sysdate)+ p_print_lead_days) AND

Line 1022: l_period_start_date := NVL(l_last_interest_cal_date + 1, OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_START_DATE);

1018: END IF;
1019:
1020: EXIT WHEN l_end_of_process = TRUE;
1021:
1022: l_period_start_date := NVL(l_last_interest_cal_date + 1, OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_START_DATE);
1023:
1024: l_calculate_from_khr_start := OKL_VARIABLE_INTEREST_PVT.calculate_from_khr_start_date(p_khr_id => p_contract_id,
1025: p_from_date => l_period_start_date);
1026:

Line 1024: l_calculate_from_khr_start := OKL_VARIABLE_INTEREST_PVT.calculate_from_khr_start_date(p_khr_id => p_contract_id,

1020: EXIT WHEN l_end_of_process = TRUE;
1021:
1022: l_period_start_date := NVL(l_last_interest_cal_date + 1, OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_START_DATE);
1023:
1024: l_calculate_from_khr_start := OKL_VARIABLE_INTEREST_PVT.calculate_from_khr_start_date(p_khr_id => p_contract_id,
1025: p_from_date => l_period_start_date);
1026:
1027: IF (l_calculate_from_khr_start = 'Y') THEN
1028: l_int_cal_start_date := OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_START_DATE;

Line 1028: l_int_cal_start_date := OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_START_DATE;

1024: l_calculate_from_khr_start := OKL_VARIABLE_INTEREST_PVT.calculate_from_khr_start_date(p_khr_id => p_contract_id,
1025: p_from_date => l_period_start_date);
1026:
1027: IF (l_calculate_from_khr_start = 'Y') THEN
1028: l_int_cal_start_date := OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_START_DATE;
1029: OKL_VARIABLE_INTEREST_PVT.print_debug('Catchup Cleanup interest calculation will start from contract start date : ' || l_int_cal_start_date);
1030: ELSE
1031: l_int_cal_start_date := l_period_start_date;
1032: OKL_VARIABLE_INTEREST_PVT.print_debug('Catchup Cleanup interest calculation will start from catchup period start date : ' || l_int_cal_start_date);

Line 1029: OKL_VARIABLE_INTEREST_PVT.print_debug('Catchup Cleanup interest calculation will start from contract start date : ' || l_int_cal_start_date);

1025: p_from_date => l_period_start_date);
1026:
1027: IF (l_calculate_from_khr_start = 'Y') THEN
1028: l_int_cal_start_date := OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_START_DATE;
1029: OKL_VARIABLE_INTEREST_PVT.print_debug('Catchup Cleanup interest calculation will start from contract start date : ' || l_int_cal_start_date);
1030: ELSE
1031: l_int_cal_start_date := l_period_start_date;
1032: OKL_VARIABLE_INTEREST_PVT.print_debug('Catchup Cleanup interest calculation will start from catchup period start date : ' || l_int_cal_start_date);
1033: END IF;

Line 1032: OKL_VARIABLE_INTEREST_PVT.print_debug('Catchup Cleanup interest calculation will start from catchup period start date : ' || l_int_cal_start_date);

1028: l_int_cal_start_date := OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_START_DATE;
1029: OKL_VARIABLE_INTEREST_PVT.print_debug('Catchup Cleanup interest calculation will start from contract start date : ' || l_int_cal_start_date);
1030: ELSE
1031: l_int_cal_start_date := l_period_start_date;
1032: OKL_VARIABLE_INTEREST_PVT.print_debug('Catchup Cleanup interest calculation will start from catchup period start date : ' || l_int_cal_start_date);
1033: END IF;
1034:
1035: VARIABLE_INTEREST_CATCHUP(
1036: p_api_version => p_api_version,

Line 1042: p_principal_basis => OKL_VARIABLE_INTEREST_PVT.G_PRINCIPAL_BASIS_CODE,

1038: x_return_status => x_return_status,
1039: x_msg_count => x_msg_count,
1040: x_msg_data => x_msg_data,
1041: p_contract_id => p_contract_id,
1042: p_principal_basis => OKL_VARIABLE_INTEREST_PVT.G_PRINCIPAL_BASIS_CODE,
1043: p_rev_rec_method => OKL_VARIABLE_INTEREST_PVT.G_REVENUE_RECOGNITION_METHOD,
1044: p_deal_type => OKL_VARIABLE_INTEREST_PVT.G_DEAL_TYPE,
1045: p_currency_code => OKL_VARIABLE_INTEREST_PVT.G_CURRENCY_CODE,
1046: p_start_date => l_int_cal_start_date,

Line 1043: p_rev_rec_method => OKL_VARIABLE_INTEREST_PVT.G_REVENUE_RECOGNITION_METHOD,

1039: x_msg_count => x_msg_count,
1040: x_msg_data => x_msg_data,
1041: p_contract_id => p_contract_id,
1042: p_principal_basis => OKL_VARIABLE_INTEREST_PVT.G_PRINCIPAL_BASIS_CODE,
1043: p_rev_rec_method => OKL_VARIABLE_INTEREST_PVT.G_REVENUE_RECOGNITION_METHOD,
1044: p_deal_type => OKL_VARIABLE_INTEREST_PVT.G_DEAL_TYPE,
1045: p_currency_code => OKL_VARIABLE_INTEREST_PVT.G_CURRENCY_CODE,
1046: p_start_date => l_int_cal_start_date,
1047: p_due_date => l_catchup_date);

Line 1044: p_deal_type => OKL_VARIABLE_INTEREST_PVT.G_DEAL_TYPE,

1040: x_msg_data => x_msg_data,
1041: p_contract_id => p_contract_id,
1042: p_principal_basis => OKL_VARIABLE_INTEREST_PVT.G_PRINCIPAL_BASIS_CODE,
1043: p_rev_rec_method => OKL_VARIABLE_INTEREST_PVT.G_REVENUE_RECOGNITION_METHOD,
1044: p_deal_type => OKL_VARIABLE_INTEREST_PVT.G_DEAL_TYPE,
1045: p_currency_code => OKL_VARIABLE_INTEREST_PVT.G_CURRENCY_CODE,
1046: p_start_date => l_int_cal_start_date,
1047: p_due_date => l_catchup_date);
1048:

Line 1045: p_currency_code => OKL_VARIABLE_INTEREST_PVT.G_CURRENCY_CODE,

1041: p_contract_id => p_contract_id,
1042: p_principal_basis => OKL_VARIABLE_INTEREST_PVT.G_PRINCIPAL_BASIS_CODE,
1043: p_rev_rec_method => OKL_VARIABLE_INTEREST_PVT.G_REVENUE_RECOGNITION_METHOD,
1044: p_deal_type => OKL_VARIABLE_INTEREST_PVT.G_DEAL_TYPE,
1045: p_currency_code => OKL_VARIABLE_INTEREST_PVT.G_CURRENCY_CODE,
1046: p_start_date => l_int_cal_start_date,
1047: p_due_date => l_catchup_date);
1048:
1049: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 1050: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to VARIABLE_INTEREST_CATCHUP');

1046: p_start_date => l_int_cal_start_date,
1047: p_due_date => l_catchup_date);
1048:
1049: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1050: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to VARIABLE_INTEREST_CATCHUP');
1051: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1052: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1053: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to VARIABLE_INTEREST_CATCHUP');
1054: RAISE process_int_catchup_failed;

Line 1053: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to VARIABLE_INTEREST_CATCHUP');

1049: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1050: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to VARIABLE_INTEREST_CATCHUP');
1051: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1052: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1053: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to VARIABLE_INTEREST_CATCHUP');
1054: RAISE process_int_catchup_failed;
1055: END IF;
1056:
1057: OKL_VARIABLE_INTEREST_PVT.print_debug ('Updating contract - id : '|| p_contract_id || 'with interest calculation date : '|| l_catchup_date);

Line 1057: OKL_VARIABLE_INTEREST_PVT.print_debug ('Updating contract - id : '|| p_contract_id || 'with interest calculation date : '|| l_catchup_date);

1053: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to VARIABLE_INTEREST_CATCHUP');
1054: RAISE process_int_catchup_failed;
1055: END IF;
1056:
1057: OKL_VARIABLE_INTEREST_PVT.print_debug ('Updating contract - id : '|| p_contract_id || 'with interest calculation date : '|| l_catchup_date);
1058:
1059: OKL_VR_DATA_HANDLER_PVT.UPDATE_LAST_INT_CAL_DATE(
1060: p_api_version => p_api_version,
1061: p_init_msg_list => Okl_Api.G_TRUE,

Line 1084: OKL_VARIABLE_INTEREST_PVT.print_error_message ('Exception process_int_catchup_failed raised in procedure PROCESS_INTEREST_CATCHUP');

1080:
1081: EXCEPTION
1082:
1083: WHEN process_int_catchup_failed THEN
1084: OKL_VARIABLE_INTEREST_PVT.print_error_message ('Exception process_int_catchup_failed raised in procedure PROCESS_INTEREST_CATCHUP');
1085: x_return_status := OKL_API.G_RET_STS_ERROR;
1086: WHEN OTHERS THEN
1087: OKL_VARIABLE_INTEREST_PVT.print_error_message ('Exception raised in procedure PROCESS_INTEREST_CATCHUP');
1088: Okl_Api.SET_MESSAGE(

Line 1087: OKL_VARIABLE_INTEREST_PVT.print_error_message ('Exception raised in procedure PROCESS_INTEREST_CATCHUP');

1083: WHEN process_int_catchup_failed THEN
1084: OKL_VARIABLE_INTEREST_PVT.print_error_message ('Exception process_int_catchup_failed raised in procedure PROCESS_INTEREST_CATCHUP');
1085: x_return_status := OKL_API.G_RET_STS_ERROR;
1086: WHEN OTHERS THEN
1087: OKL_VARIABLE_INTEREST_PVT.print_error_message ('Exception raised in procedure PROCESS_INTEREST_CATCHUP');
1088: Okl_Api.SET_MESSAGE(
1089: p_app_name => G_APP_NAME,
1090: p_msg_name => G_UNEXPECTED_ERROR,
1091: p_token1 => G_SQLCODE_TOKEN,