31: PROCEDURE set_defaults(
32: px_artv_rec IN OUT NOCOPY artv_rec_type,
33: x_return_status OUT NOCOPY VARCHAR2) IS
34: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'set_defaults';
35: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
36: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
37: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
38: BEGIN
39:
32: px_artv_rec IN OUT NOCOPY artv_rec_type,
33: x_return_status OUT NOCOPY VARCHAR2) IS
34: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'set_defaults';
35: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
36: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
37: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
38: BEGIN
39:
40: IF (is_debug_procedure_on) THEN
33: x_return_status OUT NOCOPY VARCHAR2) IS
34: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'set_defaults';
35: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
36: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
37: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
38: BEGIN
39:
40: IF (is_debug_procedure_on) THEN
41: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
37: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
38: BEGIN
39:
40: IF (is_debug_procedure_on) THEN
41: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
42: END IF;
43: IF (is_debug_statement_on) THEN
44: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In out param, px_artv_rec.relocate_asset_yn: '||px_artv_rec.relocate_asset_yn);
45: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In out param, px_artv_rec.asset_relocated_yn: '||px_artv_rec.asset_relocated_yn);
40: IF (is_debug_procedure_on) THEN
41: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
42: END IF;
43: IF (is_debug_statement_on) THEN
44: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In out param, px_artv_rec.relocate_asset_yn: '||px_artv_rec.relocate_asset_yn);
45: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In out param, px_artv_rec.asset_relocated_yn: '||px_artv_rec.asset_relocated_yn);
46: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In out param, px_artv_rec.commmercially_reas_sale_yn: '||px_artv_rec.commmercially_reas_sale_yn);
47: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In out param, px_artv_rec.voluntary_yn: '||px_artv_rec.voluntary_yn);
48: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In out param, px_artv_rec.repurchase_agmt_yn: '||px_artv_rec.repurchase_agmt_yn);
41: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'Begin(+)');
42: END IF;
43: IF (is_debug_statement_on) THEN
44: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In out param, px_artv_rec.relocate_asset_yn: '||px_artv_rec.relocate_asset_yn);
45: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In out param, px_artv_rec.asset_relocated_yn: '||px_artv_rec.asset_relocated_yn);
46: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In out param, px_artv_rec.commmercially_reas_sale_yn: '||px_artv_rec.commmercially_reas_sale_yn);
47: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In out param, px_artv_rec.voluntary_yn: '||px_artv_rec.voluntary_yn);
48: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In out param, px_artv_rec.repurchase_agmt_yn: '||px_artv_rec.repurchase_agmt_yn);
49: END IF;
42: END IF;
43: IF (is_debug_statement_on) THEN
44: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In out param, px_artv_rec.relocate_asset_yn: '||px_artv_rec.relocate_asset_yn);
45: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In out param, px_artv_rec.asset_relocated_yn: '||px_artv_rec.asset_relocated_yn);
46: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In out param, px_artv_rec.commmercially_reas_sale_yn: '||px_artv_rec.commmercially_reas_sale_yn);
47: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In out param, px_artv_rec.voluntary_yn: '||px_artv_rec.voluntary_yn);
48: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In out param, px_artv_rec.repurchase_agmt_yn: '||px_artv_rec.repurchase_agmt_yn);
49: END IF;
50:
43: IF (is_debug_statement_on) THEN
44: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In out param, px_artv_rec.relocate_asset_yn: '||px_artv_rec.relocate_asset_yn);
45: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In out param, px_artv_rec.asset_relocated_yn: '||px_artv_rec.asset_relocated_yn);
46: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In out param, px_artv_rec.commmercially_reas_sale_yn: '||px_artv_rec.commmercially_reas_sale_yn);
47: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In out param, px_artv_rec.voluntary_yn: '||px_artv_rec.voluntary_yn);
48: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In out param, px_artv_rec.repurchase_agmt_yn: '||px_artv_rec.repurchase_agmt_yn);
49: END IF;
50:
51: -- Set the relocate_asset_yn if null
44: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In out param, px_artv_rec.relocate_asset_yn: '||px_artv_rec.relocate_asset_yn);
45: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In out param, px_artv_rec.asset_relocated_yn: '||px_artv_rec.asset_relocated_yn);
46: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In out param, px_artv_rec.commmercially_reas_sale_yn: '||px_artv_rec.commmercially_reas_sale_yn);
47: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In out param, px_artv_rec.voluntary_yn: '||px_artv_rec.voluntary_yn);
48: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In out param, px_artv_rec.repurchase_agmt_yn: '||px_artv_rec.repurchase_agmt_yn);
49: END IF;
50:
51: -- Set the relocate_asset_yn if null
52: IF ((px_artv_rec.relocate_asset_yn IS NULL) OR
80:
81: x_return_status := OKL_API.G_RET_STS_SUCCESS;
82:
83: IF (is_debug_procedure_on) THEN
84: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name,'End(-)');
85: END IF;
86:
87: EXCEPTION
88: WHEN OTHERS THEN
94: p_token1_value => sqlcode,
95: p_token2 => g_sqlerrm_token,
96: p_token2_value => sqlerrm);
97: IF (is_debug_exception_on) THEN
98: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '
99: || sqlcode || ' , SQLERRM : ' || sqlerrm);
100: END IF;
101:
102: END set_defaults;
124: l_rulv_rec okl_rule_pub.rulv_rec_type;
125: floor_price_error EXCEPTION;
126: l_formula_name VARCHAR2(150) := 'DEFAULT ASSET FLOOR PRICE';
127: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'get_floor_price';
128: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
129: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
130: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
131:
132: BEGIN
125: floor_price_error EXCEPTION;
126: l_formula_name VARCHAR2(150) := 'DEFAULT ASSET FLOOR PRICE';
127: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'get_floor_price';
128: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
129: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
130: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
131:
132: BEGIN
133:
126: l_formula_name VARCHAR2(150) := 'DEFAULT ASSET FLOOR PRICE';
127: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'get_floor_price';
128: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
129: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
130: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
131:
132: BEGIN
133:
134: IF (is_debug_procedure_on) THEN
131:
132: BEGIN
133:
134: IF (is_debug_procedure_on) THEN
135: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name,'Begin(+)');
136: END IF;
137: IF (is_debug_statement_on) THEN
138: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
139: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_kle_id: '||p_kle_id);
134: IF (is_debug_procedure_on) THEN
135: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name,'Begin(+)');
136: END IF;
137: IF (is_debug_statement_on) THEN
138: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
139: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_kle_id: '||p_kle_id);
140: END IF;
141:
142: IF (is_debug_statement_on) THEN
135: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name,'Begin(+)');
136: END IF;
137: IF (is_debug_statement_on) THEN
138: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
139: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_kle_id: '||p_kle_id);
140: END IF;
141:
142: IF (is_debug_statement_on) THEN
143: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');
139: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_kle_id: '||p_kle_id);
140: END IF;
141:
142: IF (is_debug_statement_on) THEN
143: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');
144: END IF;
145:
146: okl_am_util_pvt.get_rule_record( p_rgd_code => 'AMLARL'
147: ,p_rdf_code => 'AMCFPR'
152: ,x_return_status => x_return_status
153: ,x_msg_count => x_msg_count
154: ,x_msg_data => x_msg_data);
155: IF (is_debug_statement_on) THEN
156: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called okl_am_util_pvt.get_rule_record, return status :'||x_return_status);
157: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_rulv_rec.rule_information1 :'||l_rulv_rec.rule_information1);
158: END IF;
159:
160: IF (x_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
153: ,x_msg_count => x_msg_count
154: ,x_msg_data => x_msg_data);
155: IF (is_debug_statement_on) THEN
156: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called okl_am_util_pvt.get_rule_record, return status :'||x_return_status);
157: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_rulv_rec.rule_information1 :'||l_rulv_rec.rule_information1);
158: END IF;
159:
160: IF (x_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
161: -- Rule instance is found and formula is found
166: END IF;
167: END IF;
168:
169: IF (is_debug_statement_on) THEN
170: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_formula_value');
171: END IF;
172:
173: okl_am_util_pvt.get_formula_value(
174: p_formula_name => l_formula_name,
176: p_cle_id => p_kle_id,
177: x_formula_value => l_floor_price,
178: x_return_status => x_return_status);
179: IF (is_debug_statement_on) THEN
180: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called okl_am_util_pvt.get_formula_value, return status :'||x_return_status);
181: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_floor_price :'||l_floor_price);
182: END IF;
183:
184: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
177: x_formula_value => l_floor_price,
178: x_return_status => x_return_status);
179: IF (is_debug_statement_on) THEN
180: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called okl_am_util_pvt.get_formula_value, return status :'||x_return_status);
181: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_floor_price :'||l_floor_price);
182: END IF;
183:
184: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
185: -- Unable to create Asset Return because of the missing floor price formula.
187: p_msg_name => 'OKL_AM_MISSING_FORMULA');
188: RAISE floor_price_error;
189: END IF;
190: IF (is_debug_statement_on) THEN
191: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Returning l_floor_price: '||l_floor_price);
192: END IF;
193:
194: IF (is_debug_procedure_on) THEN
195: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name,'End(-)');
191: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Returning l_floor_price: '||l_floor_price);
192: END IF;
193:
194: IF (is_debug_procedure_on) THEN
195: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name,'End(-)');
196: END IF;
197:
198:
199: RETURN l_floor_price;
201: EXCEPTION
202: WHEN floor_price_error THEN
203: x_return_status := OKL_API.G_RET_STS_ERROR;
204: IF (is_debug_exception_on) THEN
205: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'floor_price_error');
206: END IF;
207:
208: RETURN NULL;
209:
216: p_token1_value => sqlcode,
217: p_token2 => g_sqlerrm_token,
218: p_token2_value => sqlerrm);
219: IF (is_debug_exception_on) THEN
220: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '
221: || sqlcode || ' , SQLERRM : ' || sqlerrm);
222: END IF;
223:
224: RETURN NULL;
244:
245: l_item_price NUMBER ;
246: l_rulv_rec okl_rule_pub.rulv_rec_type;
247: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'get_item_price';
248: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
249: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
250: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
251:
252: BEGIN
245: l_item_price NUMBER ;
246: l_rulv_rec okl_rule_pub.rulv_rec_type;
247: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'get_item_price';
248: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
249: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
250: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
251:
252: BEGIN
253:
246: l_rulv_rec okl_rule_pub.rulv_rec_type;
247: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'get_item_price';
248: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
249: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
250: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
251:
252: BEGIN
253:
254: IF (is_debug_procedure_on) THEN
251:
252: BEGIN
253:
254: IF (is_debug_procedure_on) THEN
255: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name,'Begin(+)');
256: END IF;
257: IF (is_debug_statement_on) THEN
258: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
259: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_kle_id: '||p_kle_id);
254: IF (is_debug_procedure_on) THEN
255: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name,'Begin(+)');
256: END IF;
257: IF (is_debug_statement_on) THEN
258: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
259: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_kle_id: '||p_kle_id);
260: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');
261: END IF;
262: okl_am_util_pvt.get_rule_record( p_rgd_code => 'AMLARL'
255: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name,'Begin(+)');
256: END IF;
257: IF (is_debug_statement_on) THEN
258: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
259: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_kle_id: '||p_kle_id);
260: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');
261: END IF;
262: okl_am_util_pvt.get_rule_record( p_rgd_code => 'AMLARL'
263: ,p_rdf_code => 'AMCFPR'
256: END IF;
257: IF (is_debug_statement_on) THEN
258: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
259: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_kle_id: '||p_kle_id);
260: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');
261: END IF;
262: okl_am_util_pvt.get_rule_record( p_rgd_code => 'AMLARL'
263: ,p_rdf_code => 'AMCFPR'
264: ,p_chr_id => p_chr_id
268: ,x_return_status => x_return_status
269: ,x_msg_count => x_msg_count
270: ,x_msg_data => x_msg_data);
271: IF (is_debug_statement_on) THEN
272: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record, return status: ' || x_return_status);
273: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_rulv_rec.rule_information2: ' || l_rulv_rec.rule_information2);
274: END IF;
275:
276: IF (x_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
269: ,x_msg_count => x_msg_count
270: ,x_msg_data => x_msg_data);
271: IF (is_debug_statement_on) THEN
272: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record, return status: ' || x_return_status);
273: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_rulv_rec.rule_information2: ' || l_rulv_rec.rule_information2);
274: END IF;
275:
276: IF (x_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
277: -- Rule instance is found, but formula not found
285: RETURN NULL;
286: END IF;
287:
288: IF (is_debug_statement_on) THEN
289: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_formula_value');
290: END IF;
291: okl_am_util_pvt.get_formula_value(
292: p_formula_name => l_rulv_rec.rule_information2,
293: p_chr_id => p_chr_id,
294: p_cle_id => p_kle_id,
295: x_formula_value => l_item_price,
296: x_return_status => x_return_status);
297: IF (is_debug_statement_on) THEN
298: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_formula_value, return status: ' || x_return_status);
299: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_item_price: ' || l_item_price);
300: END IF;
301: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
302: RETURN NULL;
295: x_formula_value => l_item_price,
296: x_return_status => x_return_status);
297: IF (is_debug_statement_on) THEN
298: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_formula_value, return status: ' || x_return_status);
299: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_item_price: ' || l_item_price);
300: END IF;
301: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
302: RETURN NULL;
303: END IF;
301: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
302: RETURN NULL;
303: END IF;
304: IF (is_debug_statement_on) THEN
305: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Returning l_item_price: '||l_item_price);
306: END IF;
307: IF (is_debug_procedure_on) THEN
308: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name,'End(-)');
309: END IF;
304: IF (is_debug_statement_on) THEN
305: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Returning l_item_price: '||l_item_price);
306: END IF;
307: IF (is_debug_procedure_on) THEN
308: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name,'End(-)');
309: END IF;
310:
311: RETURN l_item_price;
312:
321: p_token1_value => sqlcode,
322: p_token2 => g_sqlerrm_token,
323: p_token2_value => sqlerrm);
324: IF (is_debug_exception_on) THEN
325: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '
326: || sqlcode || ' , SQLERRM : ' || sqlerrm);
327: END IF;
328:
329: RETURN NULL;
353: FROM okl_k_headers khr
354: WHERE khr.id = p_id;
355:
356: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'get_repurchase_agreement';
357: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
358: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
359: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
360: l_repuchase_agreement_yn VARCHAR2(1);
361: l_program_khr_id NUMBER := NULL;
354: WHERE khr.id = p_id;
355:
356: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'get_repurchase_agreement';
357: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
358: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
359: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
360: l_repuchase_agreement_yn VARCHAR2(1);
361: l_program_khr_id NUMBER := NULL;
362: l_rulv_rec okl_rule_pub.rulv_rec_type;
355:
356: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'get_repurchase_agreement';
357: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
358: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
359: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
360: l_repuchase_agreement_yn VARCHAR2(1);
361: l_program_khr_id NUMBER := NULL;
362: l_rulv_rec okl_rule_pub.rulv_rec_type;
363: repurchase_agreement_error EXCEPTION;
363: repurchase_agreement_error EXCEPTION;
364: BEGIN
365:
366: IF (is_debug_procedure_on) THEN
367: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name,'Begin(+)');
368: END IF;
369: IF (is_debug_statement_on) THEN
370: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
371: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_kle_id: '||p_kle_id);
366: IF (is_debug_procedure_on) THEN
367: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name,'Begin(+)');
368: END IF;
369: IF (is_debug_statement_on) THEN
370: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
371: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_kle_id: '||p_kle_id);
372: END IF;
373:
374: --Check if Vendor program is attached to the Lease contract
367: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name,'Begin(+)');
368: END IF;
369: IF (is_debug_statement_on) THEN
370: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
371: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_kle_id: '||p_kle_id);
372: END IF;
373:
374: --Check if Vendor program is attached to the Lease contract
375: OPEN l_khr_csr(p_chr_id);
381: RAISE repurchase_agreement_error;
382: END IF;
383:
384: IF (is_debug_statement_on) THEN
385: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');
386: END IF;
387: okl_am_util_pvt.get_rule_record( p_rgd_code => 'AMREPQ'
388: ,p_rdf_code => 'AMARQC'
389: ,p_chr_id => p_chr_id
394: ,x_msg_count => x_msg_count
395: ,x_msg_data => x_msg_data);
396:
397: IF (is_debug_statement_on) THEN
398: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record, x_return_status: ' || x_return_status);
399: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record, l_rulv_rec.rule_information1: ' || l_rulv_rec.rule_information1);
400: END IF;
401:
402: IF (x_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
395: ,x_msg_data => x_msg_data);
396:
397: IF (is_debug_statement_on) THEN
398: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record, x_return_status: ' || x_return_status);
399: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record, l_rulv_rec.rule_information1: ' || l_rulv_rec.rule_information1);
400: END IF;
401:
402: IF (x_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
403: -- Rule instance is found, but formula not found
409: END IF;
410:
411: l_repuchase_agreement_yn := l_rulv_rec.rule_information1;
412: IF (is_debug_statement_on) THEN
413: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Returning l_repuchase_agreement_yn: '||l_repuchase_agreement_yn);
414: END IF;
415:
416: IF (is_debug_procedure_on) THEN
417: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name,'End(-)');
413: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'Returning l_repuchase_agreement_yn: '||l_repuchase_agreement_yn);
414: END IF;
415:
416: IF (is_debug_procedure_on) THEN
417: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name,'End(-)');
418: END IF;
419:
420: RETURN l_repuchase_agreement_yn;
421:
425: IF l_khr_csr%ISOPEN THEN
426: CLOSE l_khr_csr;
427: END IF;
428: IF (is_debug_exception_on) THEN
429: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'repurchase_agreement_error');
430: END IF;
431:
432: RETURN 'N';
433:
444: p_token1_value => sqlcode,
445: p_token2 => g_sqlerrm_token,
446: p_token2_value => sqlerrm);
447: IF (is_debug_exception_on) THEN
448: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '
449: || sqlcode || ' , SQLERRM : ' || sqlerrm);
450: END IF;
451:
452: RETURN 'N';
479: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
480: p_catalog_group_id NUMBER;
481: p_rmr_id NUMBER;
482: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'assign_remarketer';
483: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
484: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
485: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
486:
487: -- This cursor is used to get the remarketer
480: p_catalog_group_id NUMBER;
481: p_rmr_id NUMBER;
482: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'assign_remarketer';
483: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
484: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
485: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
486:
487: -- This cursor is used to get the remarketer
488: CURSOR l_remarketcombo_csr(p_id NUMBER) IS
481: p_rmr_id NUMBER;
482: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'assign_remarketer';
483: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
484: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
485: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
486:
487: -- This cursor is used to get the remarketer
488: CURSOR l_remarketcombo_csr(p_id NUMBER) IS
489: SELECT RC.rmr_id
497:
498: BEGIN
499:
500: IF (is_debug_procedure_on) THEN
501: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name,'Begin(+)');
502: END IF;
503: IF (is_debug_statement_on) THEN
504: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_kle_id: '||p_kle_id);
505: END IF;
500: IF (is_debug_procedure_on) THEN
501: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name,'Begin(+)');
502: END IF;
503: IF (is_debug_statement_on) THEN
504: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_kle_id: '||p_kle_id);
505: END IF;
506:
507: OPEN l_catgrp_csr(p_kle_id);
508: FETCH l_catgrp_csr into p_catalog_group_id;
508: FETCH l_catgrp_csr into p_catalog_group_id;
509: CLOSE l_catgrp_csr;
510:
511: IF (is_debug_statement_on) THEN
512: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'p_catalog_group_id: '||p_catalog_group_id);
513: END IF;
514:
515: IF p_catalog_group_id IS NOT NULL AND p_catalog_group_id <> OKL_API.G_MISS_NUM THEN
516:
550: END IF;
551:
552: END IF;
553: IF (is_debug_statement_on) THEN
554: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'x_rmr_id: '||x_rmr_id);
555: END IF;
556:
557: IF (is_debug_procedure_on) THEN
558: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name,'End(-)');
554: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'x_rmr_id: '||x_rmr_id);
555: END IF;
556:
557: IF (is_debug_procedure_on) THEN
558: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name,'End(-)');
559: END IF;
560:
561: EXCEPTION
562: WHEN OTHERS THEN
574: p_token2 => g_sqlerrm_token,
575: p_token2_value => sqlerrm);
576: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
577: IF (is_debug_exception_on) THEN
578: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '
579: || sqlcode || ' , SQLERRM : ' || sqlerrm);
580: END IF;
581:
582: END assign_remarketer;
632:
633: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
634: l_api_name CONSTANT VARCHAR2(30) := 'create_asset_return';
635: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'create_asset_return';
636: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
637: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
638: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
639: l_floor_price NUMBER := OKL_API.G_MISS_NUM;
640: l_inventory_item_id NUMBER := OKL_API.G_MISS_NUM;
633: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
634: l_api_name CONSTANT VARCHAR2(30) := 'create_asset_return';
635: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'create_asset_return';
636: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
637: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
638: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
639: l_floor_price NUMBER := OKL_API.G_MISS_NUM;
640: l_inventory_item_id NUMBER := OKL_API.G_MISS_NUM;
641: l_Item_Price NUMBER := OKL_API.G_MISS_NUM;
634: l_api_name CONSTANT VARCHAR2(30) := 'create_asset_return';
635: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'create_asset_return';
636: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
637: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
638: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
639: l_floor_price NUMBER := OKL_API.G_MISS_NUM;
640: l_inventory_item_id NUMBER := OKL_API.G_MISS_NUM;
641: l_Item_Price NUMBER := OKL_API.G_MISS_NUM;
642: l_New_Item_Number VARCHAR2(25);
699: lx_return_Status VARCHAR2(1);
700: BEGIN
701:
702: IF (is_debug_procedure_on) THEN
703: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name,'Begin(+)');
704: END IF;
705: IF (is_debug_statement_on) THEN
706: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.id:' || lp_artv_rec.id);
707: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.kle_id:' || lp_artv_rec.kle_id);
702: IF (is_debug_procedure_on) THEN
703: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name,'Begin(+)');
704: END IF;
705: IF (is_debug_statement_on) THEN
706: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.id:' || lp_artv_rec.id);
707: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.kle_id:' || lp_artv_rec.kle_id);
708: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.legal_entity_id:' || lp_artv_rec.legal_entity_id);
709: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_description:' || lp_artv_rec.new_item_description);
710: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.ARS_CODE:' || lp_artv_rec.ARS_CODE);
703: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name,'Begin(+)');
704: END IF;
705: IF (is_debug_statement_on) THEN
706: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.id:' || lp_artv_rec.id);
707: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.kle_id:' || lp_artv_rec.kle_id);
708: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.legal_entity_id:' || lp_artv_rec.legal_entity_id);
709: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_description:' || lp_artv_rec.new_item_description);
710: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.ARS_CODE:' || lp_artv_rec.ARS_CODE);
711: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.art1_code:' || lp_artv_rec.art1_code);
704: END IF;
705: IF (is_debug_statement_on) THEN
706: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.id:' || lp_artv_rec.id);
707: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.kle_id:' || lp_artv_rec.kle_id);
708: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.legal_entity_id:' || lp_artv_rec.legal_entity_id);
709: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_description:' || lp_artv_rec.new_item_description);
710: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.ARS_CODE:' || lp_artv_rec.ARS_CODE);
711: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.art1_code:' || lp_artv_rec.art1_code);
712: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.rna_id:' || lp_artv_rec.rna_id);
705: IF (is_debug_statement_on) THEN
706: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.id:' || lp_artv_rec.id);
707: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.kle_id:' || lp_artv_rec.kle_id);
708: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.legal_entity_id:' || lp_artv_rec.legal_entity_id);
709: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_description:' || lp_artv_rec.new_item_description);
710: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.ARS_CODE:' || lp_artv_rec.ARS_CODE);
711: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.art1_code:' || lp_artv_rec.art1_code);
712: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.rna_id:' || lp_artv_rec.rna_id);
713: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_repossession_required:' || lp_artv_rec.date_repossession_required);
706: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.id:' || lp_artv_rec.id);
707: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.kle_id:' || lp_artv_rec.kle_id);
708: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.legal_entity_id:' || lp_artv_rec.legal_entity_id);
709: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_description:' || lp_artv_rec.new_item_description);
710: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.ARS_CODE:' || lp_artv_rec.ARS_CODE);
711: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.art1_code:' || lp_artv_rec.art1_code);
712: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.rna_id:' || lp_artv_rec.rna_id);
713: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_repossession_required:' || lp_artv_rec.date_repossession_required);
714: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_repossession_actual:' || lp_artv_rec.date_repossession_actual);
707: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.kle_id:' || lp_artv_rec.kle_id);
708: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.legal_entity_id:' || lp_artv_rec.legal_entity_id);
709: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_description:' || lp_artv_rec.new_item_description);
710: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.ARS_CODE:' || lp_artv_rec.ARS_CODE);
711: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.art1_code:' || lp_artv_rec.art1_code);
712: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.rna_id:' || lp_artv_rec.rna_id);
713: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_repossession_required:' || lp_artv_rec.date_repossession_required);
714: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_repossession_actual:' || lp_artv_rec.date_repossession_actual);
715: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_hold_until:' || lp_artv_rec.date_hold_until);
708: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.legal_entity_id:' || lp_artv_rec.legal_entity_id);
709: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_description:' || lp_artv_rec.new_item_description);
710: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.ARS_CODE:' || lp_artv_rec.ARS_CODE);
711: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.art1_code:' || lp_artv_rec.art1_code);
712: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.rna_id:' || lp_artv_rec.rna_id);
713: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_repossession_required:' || lp_artv_rec.date_repossession_required);
714: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_repossession_actual:' || lp_artv_rec.date_repossession_actual);
715: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_hold_until:' || lp_artv_rec.date_hold_until);
716: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.floor_price:' || lp_artv_rec.floor_price);
709: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_description:' || lp_artv_rec.new_item_description);
710: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.ARS_CODE:' || lp_artv_rec.ARS_CODE);
711: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.art1_code:' || lp_artv_rec.art1_code);
712: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.rna_id:' || lp_artv_rec.rna_id);
713: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_repossession_required:' || lp_artv_rec.date_repossession_required);
714: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_repossession_actual:' || lp_artv_rec.date_repossession_actual);
715: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_hold_until:' || lp_artv_rec.date_hold_until);
716: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.floor_price:' || lp_artv_rec.floor_price);
717: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_price:' || lp_artv_rec.new_item_price);
710: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.ARS_CODE:' || lp_artv_rec.ARS_CODE);
711: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.art1_code:' || lp_artv_rec.art1_code);
712: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.rna_id:' || lp_artv_rec.rna_id);
713: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_repossession_required:' || lp_artv_rec.date_repossession_required);
714: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_repossession_actual:' || lp_artv_rec.date_repossession_actual);
715: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_hold_until:' || lp_artv_rec.date_hold_until);
716: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.floor_price:' || lp_artv_rec.floor_price);
717: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_price:' || lp_artv_rec.new_item_price);
718: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.currency_code:' || lp_artv_rec.currency_code);
711: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.art1_code:' || lp_artv_rec.art1_code);
712: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.rna_id:' || lp_artv_rec.rna_id);
713: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_repossession_required:' || lp_artv_rec.date_repossession_required);
714: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_repossession_actual:' || lp_artv_rec.date_repossession_actual);
715: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_hold_until:' || lp_artv_rec.date_hold_until);
716: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.floor_price:' || lp_artv_rec.floor_price);
717: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_price:' || lp_artv_rec.new_item_price);
718: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.currency_code:' || lp_artv_rec.currency_code);
719: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.currency_conversion_code:' || lp_artv_rec.currency_conversion_code);
712: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.rna_id:' || lp_artv_rec.rna_id);
713: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_repossession_required:' || lp_artv_rec.date_repossession_required);
714: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_repossession_actual:' || lp_artv_rec.date_repossession_actual);
715: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_hold_until:' || lp_artv_rec.date_hold_until);
716: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.floor_price:' || lp_artv_rec.floor_price);
717: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_price:' || lp_artv_rec.new_item_price);
718: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.currency_code:' || lp_artv_rec.currency_code);
719: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.currency_conversion_code:' || lp_artv_rec.currency_conversion_code);
720: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.repurchase_agmt_yn:' || lp_artv_rec.repurchase_agmt_yn);
713: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_repossession_required:' || lp_artv_rec.date_repossession_required);
714: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_repossession_actual:' || lp_artv_rec.date_repossession_actual);
715: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_hold_until:' || lp_artv_rec.date_hold_until);
716: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.floor_price:' || lp_artv_rec.floor_price);
717: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_price:' || lp_artv_rec.new_item_price);
718: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.currency_code:' || lp_artv_rec.currency_code);
719: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.currency_conversion_code:' || lp_artv_rec.currency_conversion_code);
720: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.repurchase_agmt_yn:' || lp_artv_rec.repurchase_agmt_yn);
721: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.rmr_id:' || lp_artv_rec.rmr_id);
714: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_repossession_actual:' || lp_artv_rec.date_repossession_actual);
715: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_hold_until:' || lp_artv_rec.date_hold_until);
716: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.floor_price:' || lp_artv_rec.floor_price);
717: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_price:' || lp_artv_rec.new_item_price);
718: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.currency_code:' || lp_artv_rec.currency_code);
719: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.currency_conversion_code:' || lp_artv_rec.currency_conversion_code);
720: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.repurchase_agmt_yn:' || lp_artv_rec.repurchase_agmt_yn);
721: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.rmr_id:' || lp_artv_rec.rmr_id);
722: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.ASSET_FMV_AMOUNT:' || lp_artv_rec.ASSET_FMV_AMOUNT);
715: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_hold_until:' || lp_artv_rec.date_hold_until);
716: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.floor_price:' || lp_artv_rec.floor_price);
717: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_price:' || lp_artv_rec.new_item_price);
718: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.currency_code:' || lp_artv_rec.currency_code);
719: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.currency_conversion_code:' || lp_artv_rec.currency_conversion_code);
720: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.repurchase_agmt_yn:' || lp_artv_rec.repurchase_agmt_yn);
721: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.rmr_id:' || lp_artv_rec.rmr_id);
722: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.ASSET_FMV_AMOUNT:' || lp_artv_rec.ASSET_FMV_AMOUNT);
723: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.legal_entity_id:' || lp_artv_rec.legal_entity_id);
716: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.floor_price:' || lp_artv_rec.floor_price);
717: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_price:' || lp_artv_rec.new_item_price);
718: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.currency_code:' || lp_artv_rec.currency_code);
719: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.currency_conversion_code:' || lp_artv_rec.currency_conversion_code);
720: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.repurchase_agmt_yn:' || lp_artv_rec.repurchase_agmt_yn);
721: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.rmr_id:' || lp_artv_rec.rmr_id);
722: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.ASSET_FMV_AMOUNT:' || lp_artv_rec.ASSET_FMV_AMOUNT);
723: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.legal_entity_id:' || lp_artv_rec.legal_entity_id);
724: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.imr_id:' || lp_artv_rec.imr_id);
717: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_price:' || lp_artv_rec.new_item_price);
718: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.currency_code:' || lp_artv_rec.currency_code);
719: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.currency_conversion_code:' || lp_artv_rec.currency_conversion_code);
720: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.repurchase_agmt_yn:' || lp_artv_rec.repurchase_agmt_yn);
721: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.rmr_id:' || lp_artv_rec.rmr_id);
722: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.ASSET_FMV_AMOUNT:' || lp_artv_rec.ASSET_FMV_AMOUNT);
723: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.legal_entity_id:' || lp_artv_rec.legal_entity_id);
724: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.imr_id:' || lp_artv_rec.imr_id);
725: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.attribute14:' || lp_artv_rec.attribute14);
718: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.currency_code:' || lp_artv_rec.currency_code);
719: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.currency_conversion_code:' || lp_artv_rec.currency_conversion_code);
720: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.repurchase_agmt_yn:' || lp_artv_rec.repurchase_agmt_yn);
721: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.rmr_id:' || lp_artv_rec.rmr_id);
722: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.ASSET_FMV_AMOUNT:' || lp_artv_rec.ASSET_FMV_AMOUNT);
723: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.legal_entity_id:' || lp_artv_rec.legal_entity_id);
724: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.imr_id:' || lp_artv_rec.imr_id);
725: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.attribute14:' || lp_artv_rec.attribute14);
726: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_number:' || lp_artv_rec.new_item_number);
719: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.currency_conversion_code:' || lp_artv_rec.currency_conversion_code);
720: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.repurchase_agmt_yn:' || lp_artv_rec.repurchase_agmt_yn);
721: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.rmr_id:' || lp_artv_rec.rmr_id);
722: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.ASSET_FMV_AMOUNT:' || lp_artv_rec.ASSET_FMV_AMOUNT);
723: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.legal_entity_id:' || lp_artv_rec.legal_entity_id);
724: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.imr_id:' || lp_artv_rec.imr_id);
725: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.attribute14:' || lp_artv_rec.attribute14);
726: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_number:' || lp_artv_rec.new_item_number);
727: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, p_quote_id:' || p_quote_id);
720: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.repurchase_agmt_yn:' || lp_artv_rec.repurchase_agmt_yn);
721: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.rmr_id:' || lp_artv_rec.rmr_id);
722: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.ASSET_FMV_AMOUNT:' || lp_artv_rec.ASSET_FMV_AMOUNT);
723: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.legal_entity_id:' || lp_artv_rec.legal_entity_id);
724: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.imr_id:' || lp_artv_rec.imr_id);
725: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.attribute14:' || lp_artv_rec.attribute14);
726: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_number:' || lp_artv_rec.new_item_number);
727: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, p_quote_id:' || p_quote_id);
728: END IF;
721: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.rmr_id:' || lp_artv_rec.rmr_id);
722: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.ASSET_FMV_AMOUNT:' || lp_artv_rec.ASSET_FMV_AMOUNT);
723: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.legal_entity_id:' || lp_artv_rec.legal_entity_id);
724: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.imr_id:' || lp_artv_rec.imr_id);
725: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.attribute14:' || lp_artv_rec.attribute14);
726: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_number:' || lp_artv_rec.new_item_number);
727: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, p_quote_id:' || p_quote_id);
728: END IF;
729:
722: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.ASSET_FMV_AMOUNT:' || lp_artv_rec.ASSET_FMV_AMOUNT);
723: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.legal_entity_id:' || lp_artv_rec.legal_entity_id);
724: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.imr_id:' || lp_artv_rec.imr_id);
725: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.attribute14:' || lp_artv_rec.attribute14);
726: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_number:' || lp_artv_rec.new_item_number);
727: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, p_quote_id:' || p_quote_id);
728: END IF;
729:
730: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
723: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.legal_entity_id:' || lp_artv_rec.legal_entity_id);
724: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.imr_id:' || lp_artv_rec.imr_id);
725: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.attribute14:' || lp_artv_rec.attribute14);
726: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_number:' || lp_artv_rec.new_item_number);
727: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, p_quote_id:' || p_quote_id);
728: END IF;
729:
730: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
731: G_PKG_NAME,
766: p_token1_value => 'Asset Number');
767: RAISE OKL_API.G_EXCEPTION_ERROR;
768: END IF;
769: IF (is_debug_statement_on) THEN
770: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_chr_id :'||l_chr_id);
771: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_name :'||l_name);
772: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_item_description :'||l_item_description);
773: END IF;
774:
767: RAISE OKL_API.G_EXCEPTION_ERROR;
768: END IF;
769: IF (is_debug_statement_on) THEN
770: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_chr_id :'||l_chr_id);
771: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_name :'||l_name);
772: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_item_description :'||l_item_description);
773: END IF;
774:
775: IF l_chr_id IS NULL OR l_chr_id = OKL_API.G_MISS_NUM THEN
768: END IF;
769: IF (is_debug_statement_on) THEN
770: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_chr_id :'||l_chr_id);
771: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_name :'||l_name);
772: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_item_description :'||l_item_description);
773: END IF;
774:
775: IF l_chr_id IS NULL OR l_chr_id = OKL_API.G_MISS_NUM THEN
776: x_return_status := OKL_API.G_RET_STS_ERROR;
788: FETCH fetch_legal_entity INTO l_legal_entity_id;
789: CLOSE fetch_legal_entity;
790:
791: IF (is_debug_statement_on) THEN
792: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_legal_entity_id :'||l_legal_entity_id);
793: END IF;
794:
795: IF (l_legal_entity_id is null or l_legal_entity_id = OKC_API.G_MISS_NUM) THEN
796: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
809: lp_artv_rec.new_item_description := l_name||', '||l_item_description;
810: END IF;
811:
812: IF (is_debug_statement_on) THEN
813: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'calling OKL_AM_LEASE_LOAN_TRMNT_PVT.validate_contract');
814: END IF;
815:
816: OKL_AM_LEASE_LOAN_TRMNT_PVT.validate_contract(
817: p_api_version => p_api_version,
823: p_control_flag => 'ASSET_RETURN_CREATE',
824: x_contract_status => l_contract_status);
825:
826: IF (is_debug_statement_on) THEN
827: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called OKL_AM_LEASE_LOAN_TRMNT_PVT.validate_contract, x_return_status: ' || x_return_status);
828: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_contract_status: ' || l_contract_status);
829: END IF;
830:
831: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
824: x_contract_status => l_contract_status);
825:
826: IF (is_debug_statement_on) THEN
827: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called OKL_AM_LEASE_LOAN_TRMNT_PVT.validate_contract, x_return_status: ' || x_return_status);
828: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_contract_status: ' || l_contract_status);
829: END IF;
830:
831: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
832: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
842: CLOSE l_qte_type_csr;
843: END IF;
844:
845: IF (is_debug_statement_on) THEN
846: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_qtp_code: ' || l_qtp_code);
847: END IF;
848:
849: --Bug# 3925453: pagarg +++ T and A +++++++ End ++++++++++
850:
865: END IF;
866: --rkuttiya added for Loans Repossession
867: -- validate that it is not a Loans Repossession
868: IF (is_debug_statement_on) THEN
869: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'calling OKL_AM_CREATE_QUOTE_PVT.check_repo_quote');
870: END IF;
871:
872: l_repo_yn := OKL_AM_CREATE_QUOTE_PVT.check_repo_quote(p_quote_id,
873: lx_return_status);
871:
872: l_repo_yn := OKL_AM_CREATE_QUOTE_PVT.check_repo_quote(p_quote_id,
873: lx_return_status);
874: IF (is_debug_statement_on) THEN
875: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called OKL_AM_CREATE_QUOTE_PVT.check_repo_quote, lx_return_status: ' || lx_return_status);
876: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_repo_yn: ' || l_repo_yn);
877: END IF;
878:
879: IF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
872: l_repo_yn := OKL_AM_CREATE_QUOTE_PVT.check_repo_quote(p_quote_id,
873: lx_return_status);
874: IF (is_debug_statement_on) THEN
875: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called OKL_AM_CREATE_QUOTE_PVT.check_repo_quote, lx_return_status: ' || lx_return_status);
876: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_repo_yn: ' || l_repo_yn);
877: END IF;
878:
879: IF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
880: RAISE OKC_API.G_EXCEPTION_ERROR;
942: x_msg_data => x_msg_data,
943: x_return_status => x_return_status);
944:
945: IF (is_debug_statement_on) THEN
946: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'x_return_status of get_floor_price: ' || x_return_status);
947: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_func_curr_code: ' || l_func_curr_code);
948: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_contract_curr_code: ' || l_contract_curr_code);
949: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_floor_price: ' || l_floor_price);
950: END IF;
943: x_return_status => x_return_status);
944:
945: IF (is_debug_statement_on) THEN
946: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'x_return_status of get_floor_price: ' || x_return_status);
947: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_func_curr_code: ' || l_func_curr_code);
948: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_contract_curr_code: ' || l_contract_curr_code);
949: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_floor_price: ' || l_floor_price);
950: END IF;
951:
944:
945: IF (is_debug_statement_on) THEN
946: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'x_return_status of get_floor_price: ' || x_return_status);
947: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_func_curr_code: ' || l_func_curr_code);
948: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_contract_curr_code: ' || l_contract_curr_code);
949: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_floor_price: ' || l_floor_price);
950: END IF;
951:
952:
945: IF (is_debug_statement_on) THEN
946: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'x_return_status of get_floor_price: ' || x_return_status);
947: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_func_curr_code: ' || l_func_curr_code);
948: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_contract_curr_code: ' || l_contract_curr_code);
949: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_floor_price: ' || l_floor_price);
950: END IF;
951:
952:
953: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
964: IF l_contract_curr_code <> l_func_curr_code THEN
965: -- convert amount to functional currency
966: --SECHAWLA 07-FEB-03 Bug # 2789656 : Added x_return_status parameter to the following procedure call
967: IF (is_debug_statement_on) THEN
968: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'calling okl_accounting_util.convert_to_functional_currency');
969: END IF;
970: okl_accounting_util.convert_to_functional_currency(
971: p_khr_id => l_chr_id,
972: p_to_currency => l_func_curr_code,
978: x_currency_conversion_rate => lx_currency_conversion_rate,
979: x_currency_conversion_date => lx_currency_conversion_date,
980: x_converted_amount => lx_converted_amount );
981: IF (is_debug_statement_on) THEN
982: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called okl_accounting_util.convert_to_functional_currency, x_return_status: ' || x_return_status);
983: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_contract_currency: ' || lx_contract_currency);
984: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_currency_conversion_type: ' || lx_currency_conversion_type);
985: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_currency_conversion_rate: ' || lx_currency_conversion_rate);
986: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_currency_conversion_date: ' || lx_currency_conversion_date);
979: x_currency_conversion_date => lx_currency_conversion_date,
980: x_converted_amount => lx_converted_amount );
981: IF (is_debug_statement_on) THEN
982: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called okl_accounting_util.convert_to_functional_currency, x_return_status: ' || x_return_status);
983: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_contract_currency: ' || lx_contract_currency);
984: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_currency_conversion_type: ' || lx_currency_conversion_type);
985: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_currency_conversion_rate: ' || lx_currency_conversion_rate);
986: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_currency_conversion_date: ' || lx_currency_conversion_date);
987: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_converted_amount: ' || lx_converted_amount);
980: x_converted_amount => lx_converted_amount );
981: IF (is_debug_statement_on) THEN
982: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called okl_accounting_util.convert_to_functional_currency, x_return_status: ' || x_return_status);
983: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_contract_currency: ' || lx_contract_currency);
984: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_currency_conversion_type: ' || lx_currency_conversion_type);
985: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_currency_conversion_rate: ' || lx_currency_conversion_rate);
986: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_currency_conversion_date: ' || lx_currency_conversion_date);
987: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_converted_amount: ' || lx_converted_amount);
988: END IF;
981: IF (is_debug_statement_on) THEN
982: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called okl_accounting_util.convert_to_functional_currency, x_return_status: ' || x_return_status);
983: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_contract_currency: ' || lx_contract_currency);
984: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_currency_conversion_type: ' || lx_currency_conversion_type);
985: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_currency_conversion_rate: ' || lx_currency_conversion_rate);
986: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_currency_conversion_date: ' || lx_currency_conversion_date);
987: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_converted_amount: ' || lx_converted_amount);
988: END IF;
989:
982: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called okl_accounting_util.convert_to_functional_currency, x_return_status: ' || x_return_status);
983: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_contract_currency: ' || lx_contract_currency);
984: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_currency_conversion_type: ' || lx_currency_conversion_type);
985: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_currency_conversion_rate: ' || lx_currency_conversion_rate);
986: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_currency_conversion_date: ' || lx_currency_conversion_date);
987: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_converted_amount: ' || lx_converted_amount);
988: END IF;
989:
990: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
983: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_contract_currency: ' || lx_contract_currency);
984: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_currency_conversion_type: ' || lx_currency_conversion_type);
985: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_currency_conversion_rate: ' || lx_currency_conversion_rate);
986: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_currency_conversion_date: ' || lx_currency_conversion_date);
987: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_converted_amount: ' || lx_converted_amount);
988: END IF;
989:
990: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
991: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1011: x_msg_data => x_msg_data,
1012: x_return_status => x_return_status);
1013:
1014: IF (is_debug_statement_on) THEN
1015: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'x_return_status of get_item_price: ' || x_return_status);
1016: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_item_price: ' || l_item_price);
1017: END IF;
1018:
1019: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1012: x_return_status => x_return_status);
1013:
1014: IF (is_debug_statement_on) THEN
1015: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'x_return_status of get_item_price: ' || x_return_status);
1016: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_item_price: ' || l_item_price);
1017: END IF;
1018:
1019: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1020: -- SECHAWLA 07-FEB-03 Bug # 2758114 : Do not default item price to floor price. Propogate error if a formula
1044: x_currency_conversion_date => lx_currency_conversion_date,
1045: x_converted_amount => lx_converted_amount );
1046:
1047: IF (is_debug_statement_on) THEN
1048: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called okl_accounting_util.convert_to_functional_currency, x_return_status: ' || x_return_status);
1049: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_contract_currency: ' || lx_contract_currency);
1050: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_currency_conversion_type: ' || lx_currency_conversion_type);
1051: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_currency_conversion_rate: ' || lx_currency_conversion_rate);
1052: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_currency_conversion_date: ' || lx_currency_conversion_date);
1045: x_converted_amount => lx_converted_amount );
1046:
1047: IF (is_debug_statement_on) THEN
1048: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called okl_accounting_util.convert_to_functional_currency, x_return_status: ' || x_return_status);
1049: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_contract_currency: ' || lx_contract_currency);
1050: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_currency_conversion_type: ' || lx_currency_conversion_type);
1051: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_currency_conversion_rate: ' || lx_currency_conversion_rate);
1052: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_currency_conversion_date: ' || lx_currency_conversion_date);
1053: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_converted_amount: ' || lx_converted_amount);
1046:
1047: IF (is_debug_statement_on) THEN
1048: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called okl_accounting_util.convert_to_functional_currency, x_return_status: ' || x_return_status);
1049: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_contract_currency: ' || lx_contract_currency);
1050: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_currency_conversion_type: ' || lx_currency_conversion_type);
1051: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_currency_conversion_rate: ' || lx_currency_conversion_rate);
1052: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_currency_conversion_date: ' || lx_currency_conversion_date);
1053: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_converted_amount: ' || lx_converted_amount);
1054: END IF;
1047: IF (is_debug_statement_on) THEN
1048: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called okl_accounting_util.convert_to_functional_currency, x_return_status: ' || x_return_status);
1049: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_contract_currency: ' || lx_contract_currency);
1050: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_currency_conversion_type: ' || lx_currency_conversion_type);
1051: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_currency_conversion_rate: ' || lx_currency_conversion_rate);
1052: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_currency_conversion_date: ' || lx_currency_conversion_date);
1053: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_converted_amount: ' || lx_converted_amount);
1054: END IF;
1055:
1048: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called okl_accounting_util.convert_to_functional_currency, x_return_status: ' || x_return_status);
1049: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_contract_currency: ' || lx_contract_currency);
1050: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_currency_conversion_type: ' || lx_currency_conversion_type);
1051: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_currency_conversion_rate: ' || lx_currency_conversion_rate);
1052: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_currency_conversion_date: ' || lx_currency_conversion_date);
1053: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_converted_amount: ' || lx_converted_amount);
1054: END IF;
1055:
1056: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1049: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_contract_currency: ' || lx_contract_currency);
1050: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_currency_conversion_type: ' || lx_currency_conversion_type);
1051: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_currency_conversion_rate: ' || lx_currency_conversion_rate);
1052: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_currency_conversion_date: ' || lx_currency_conversion_date);
1053: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_converted_amount: ' || lx_converted_amount);
1054: END IF;
1055:
1056: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1057: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1085: x_msg_data => x_msg_data,
1086: x_return_status => x_return_status);
1087:
1088: IF (is_debug_statement_on) THEN
1089: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'x_return_status of get_repurchase_agreement: ' || x_return_status);
1090: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_repurchase_yn: ' || l_repurchase_yn);
1091: END IF;
1092: lp_artv_rec.repurchase_agmt_yn := l_repurchase_yn;
1093:
1086: x_return_status => x_return_status);
1087:
1088: IF (is_debug_statement_on) THEN
1089: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'x_return_status of get_repurchase_agreement: ' || x_return_status);
1090: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_repurchase_yn: ' || l_repurchase_yn);
1091: END IF;
1092: lp_artv_rec.repurchase_agmt_yn := l_repurchase_yn;
1093:
1094: -- Call AssignRemarker procedure to assign the default remarketer
1100: x_rmr_id => l_rmr_id,
1101: x_return_status => x_return_status);
1102:
1103: IF (is_debug_statement_on) THEN
1104: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'x_return_status of assign_remarketer: ' || x_return_status);
1105: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_rmr_id: ' || l_rmr_id);
1106: END IF;
1107:
1108: -- Set the message if no default remarketer found
1101: x_return_status => x_return_status);
1102:
1103: IF (is_debug_statement_on) THEN
1104: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'x_return_status of assign_remarketer: ' || x_return_status);
1105: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_rmr_id: ' || l_rmr_id);
1106: END IF;
1107:
1108: -- Set the message if no default remarketer found
1109: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
1113: l_user_profile_name := okl_am_util_pvt.get_user_profile_option_name(
1114: p_profile_option_name => 'OKL_DEFAULT_REMARKETER',
1115: x_return_status => x_return_status);
1116: IF (is_debug_statement_on) THEN
1117: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'x_return_status of okl_am_util_pvt.get_user_profile_option_name: ' || x_return_status);
1118: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_user_profile_name: ' || l_user_profile_name);
1119: END IF;
1120:
1121: IF x_return_status = OKL_API.G_RET_STS_ERROR THEN
1114: p_profile_option_name => 'OKL_DEFAULT_REMARKETER',
1115: x_return_status => x_return_status);
1116: IF (is_debug_statement_on) THEN
1117: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'x_return_status of okl_am_util_pvt.get_user_profile_option_name: ' || x_return_status);
1118: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_user_profile_name: ' || l_user_profile_name);
1119: END IF;
1120:
1121: IF x_return_status = OKL_API.G_RET_STS_ERROR THEN
1122: --Default Remarketer profile is missing.
1163: px_artv_rec => lp_artv_rec,
1164: x_return_status => x_return_status);
1165:
1166: IF (is_debug_statement_on) THEN
1167: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'x_return_status of set_defaults: ' || x_return_status);
1168: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'calling OKL_ASSET_RETURNS_PUB.insert_asset_returns');
1169: END IF;
1170:
1171: -- call insert of tapi
1164: x_return_status => x_return_status);
1165:
1166: IF (is_debug_statement_on) THEN
1167: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'x_return_status of set_defaults: ' || x_return_status);
1168: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'calling OKL_ASSET_RETURNS_PUB.insert_asset_returns');
1169: END IF;
1170:
1171: -- call insert of tapi
1172: OKL_ASSET_RETURNS_PUB.insert_asset_returns(
1178: p_artv_rec => lp_artv_rec,
1179: x_artv_rec => lx_artv_rec);
1180:
1181: IF (is_debug_statement_on) THEN
1182: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called OKL_ASSET_RETURNS_PUB.insert_asset_returns, x_return_status: ' || x_return_status);
1183: END IF;
1184:
1185: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1186: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1197:
1198: IF lp_artv_rec.art1_code = 'REPOS_REQUEST' AND l_repo_yn = 'N' THEN
1199: -- call notify repossession agent wf
1200: IF (is_debug_statement_on) THEN
1201: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'Raising workflow OKL_AM_WF.raise_business_event,oracle.apps.okl.am.notifyrepoagent, lx_artv_rec.id:' || lx_artv_rec.id);
1202: END IF;
1203: OKL_AM_WF.raise_business_event(lx_artv_rec.id,'oracle.apps.okl.am.notifyrepoagent');
1204: END IF;
1205:
1208: lp_rasv_rec.art_id := lx_artv_rec.id;
1209: lp_rasv_rec.trans_option_accepted_yn := 'N';
1210:
1211: IF (is_debug_statement_on) THEN
1212: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'calling OKL_AM_SHIPPING_INSTR_PUB.create_shipping_instr');
1213: END IF;
1214: OKL_AM_SHIPPING_INSTR_PUB.create_shipping_instr(p_api_version => p_api_version
1215: ,p_init_msg_list => OKL_API.G_FALSE
1216: ,x_return_status => x_return_status
1218: ,x_msg_data => x_msg_data
1219: ,p_rasv_rec => lp_rasv_rec
1220: ,x_rasv_rec => lx_rasv_rec);
1221: IF (is_debug_statement_on) THEN
1222: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called OKL_AM_SHIPPING_INSTR_PUB.create_shipping_instr, x_return_status: ' || x_return_status);
1223: END IF;
1224:
1225: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1226: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1228: RAISE OKL_API.G_EXCEPTION_ERROR;
1229: END IF;
1230:
1231: IF (is_debug_statement_on) THEN
1232: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'Raising workflow OKL_AM_WF.raise_business_event,oracle.apps.okl.am.notifyremarketer, lx_artv_rec.id:' || lx_artv_rec.id);
1233: END IF;
1234: -- notify remarketer
1235: OKL_AM_WF.raise_business_event(lx_artv_rec.id,'oracle.apps.okl.am.notifyremarketer');
1236:
1235: OKL_AM_WF.raise_business_event(lx_artv_rec.id,'oracle.apps.okl.am.notifyremarketer');
1236:
1237:
1238: IF (is_debug_statement_on) THEN
1239: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'calling okl_am_util_pvt.get_rule_record');
1240: END IF;
1241: -- First get the party id from the rule if the custodian is a 3rd party
1242: okl_am_util_pvt.get_rule_record (
1243: p_rgd_code => 'LAAFLG',
1248: x_return_status => l_return_status,
1249: p_message_yn => FALSE); -- put error message on stack if there is no rule
1250:
1251: IF (is_debug_statement_on) THEN
1252: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called okl_am_util_pvt.get_rule_record, l_return_status: ' || l_return_status);
1253: END IF;
1254:
1255: IF l_return_status = OKL_API.G_RET_STS_SUCCESS AND l_rulv_rec.object2_id1 IS NOT NULL AND l_rulv_rec.object2_id1 <> OKL_API.G_MISS_NUM THEN
1256: IF (is_debug_statement_on) THEN
1253: END IF;
1254:
1255: IF l_return_status = OKL_API.G_RET_STS_SUCCESS AND l_rulv_rec.object2_id1 IS NOT NULL AND l_rulv_rec.object2_id1 <> OKL_API.G_MISS_NUM THEN
1256: IF (is_debug_statement_on) THEN
1257: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'Raising workflow OKL_AM_WF.raise_business_event,oracle.apps.okl.am.notifytitleholder, lx_artv_rec.id:' || lx_artv_rec.id);
1258: END IF;
1259: OKL_AM_WF.raise_business_event(lx_artv_rec.id,'oracle.apps.okl.am.notifytitleholder');
1260:
1261: END IF;
1264:
1265: -- RMUNJULU 3061751 27-AUG-2003
1266: -- Check if linked service contract exists for the asset which is returned
1267: IF (is_debug_statement_on) THEN
1268: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'calling OKL_AM_LEASE_LOAN_TRMNT_PVT.check_service_k_int_needed');
1269: END IF;
1270: l_service_int_needed := OKL_AM_LEASE_LOAN_TRMNT_PVT.check_service_k_int_needed(
1271: p_asset_id => lp_artv_rec.kle_id,
1272: p_source => 'RETURN');
1270: l_service_int_needed := OKL_AM_LEASE_LOAN_TRMNT_PVT.check_service_k_int_needed(
1271: p_asset_id => lp_artv_rec.kle_id,
1272: p_source => 'RETURN');
1273: IF (is_debug_statement_on) THEN
1274: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called OKL_AM_LEASE_LOAN_TRMNT_PVT.check_service_k_int_needed');
1275: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_service_int_needed: ' || l_service_int_needed);
1276: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'calling OKL_AM_LEASE_LOAN_TRMNT_PVT.service_k_integration');
1277: END IF;
1278:
1271: p_asset_id => lp_artv_rec.kle_id,
1272: p_source => 'RETURN');
1273: IF (is_debug_statement_on) THEN
1274: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called OKL_AM_LEASE_LOAN_TRMNT_PVT.check_service_k_int_needed');
1275: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_service_int_needed: ' || l_service_int_needed);
1276: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'calling OKL_AM_LEASE_LOAN_TRMNT_PVT.service_k_integration');
1277: END IF;
1278:
1279: -- Do the Service Contract Integration Notification for RETURN
1272: p_source => 'RETURN');
1273: IF (is_debug_statement_on) THEN
1274: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called OKL_AM_LEASE_LOAN_TRMNT_PVT.check_service_k_int_needed');
1275: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_service_int_needed: ' || l_service_int_needed);
1276: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'calling OKL_AM_LEASE_LOAN_TRMNT_PVT.service_k_integration');
1277: END IF;
1278:
1279: -- Do the Service Contract Integration Notification for RETURN
1280: OKL_AM_LEASE_LOAN_TRMNT_PVT.service_k_integration(
1282: p_transaction_date => SYSDATE,
1283: p_source => 'RETURN',
1284: p_service_integration_needed => l_service_int_needed);
1285: IF (is_debug_statement_on) THEN
1286: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called OKL_AM_LEASE_LOAN_TRMNT_PVT.service_k_integration');
1287: END IF;
1288:
1289: -- ++++++++++++++++++++ service contract integration end ++++++++++++++++++
1290:
1291:
1292: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1293:
1294: IF (is_debug_procedure_on) THEN
1295: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name,'End(-)');
1296: END IF;
1297:
1298: EXCEPTION
1299:
1298: EXCEPTION
1299:
1300: WHEN floor_price_error THEN
1301: IF (is_debug_exception_on) THEN
1302: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'floor_price_error');
1303: END IF;
1304: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name || '_PVT');
1305:
1306: -- SECHAWLA 07-FEB-03 Bug # 2758114 : Added a new exception
1305:
1306: -- SECHAWLA 07-FEB-03 Bug # 2758114 : Added a new exception
1307: WHEN item_price_error THEN
1308: IF (is_debug_exception_on) THEN
1309: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'item_price_error');
1310: END IF;
1311: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name || '_PVT');
1312:
1313: WHEN G_EXCEPTION_INSURANCE_ERROR THEN
1311: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name || '_PVT');
1312:
1313: WHEN G_EXCEPTION_INSURANCE_ERROR THEN
1314: IF (is_debug_exception_on) THEN
1315: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_INSURANCE_ERROR');
1316: END IF;
1317:
1318: -- notify caller of an UNEXPECTED error
1319: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1328: CLOSE fetch_legal_entity;
1329: END IF;
1330: -- Legal Entity Changes End
1331: IF (is_debug_exception_on) THEN
1332: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_ERROR');
1333: END IF;
1334:
1335: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1336: (
1352: CLOSE fetch_legal_entity;
1353: END IF;
1354: -- Legal Entity Changes End
1355: IF (is_debug_exception_on) THEN
1356: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_UNEXPECTED_ERROR');
1357: END IF;
1358:
1359: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1360: (
1376: CLOSE fetch_legal_entity;
1377: END IF;
1378: -- Legal Entity Changes End
1379: IF (is_debug_exception_on) THEN
1380: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '
1381: || sqlcode || ' , SQLERRM : ' || sqlerrm);
1382: END IF;
1383:
1384: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1433: WHERE id = p_kle_id;
1434:
1435: l_sts_code okc_k_lines_b.sts_code%TYPE;
1436: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_asset_status';
1437: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1438: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1439: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1440: BEGIN
1441:
1434:
1435: l_sts_code okc_k_lines_b.sts_code%TYPE;
1436: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_asset_status';
1437: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1438: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1439: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1440: BEGIN
1441:
1442: IF (is_debug_procedure_on) THEN
1435: l_sts_code okc_k_lines_b.sts_code%TYPE;
1436: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_asset_status';
1437: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1438: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1439: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1440: BEGIN
1441:
1442: IF (is_debug_procedure_on) THEN
1443: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name,'Begin(+)');
1439: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1440: BEGIN
1441:
1442: IF (is_debug_procedure_on) THEN
1443: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name,'Begin(+)');
1444: END IF;
1445: IF (is_debug_statement_on) THEN
1446: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, p_kle_id:' || p_kle_id);
1447: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, p_asset_number:' || p_asset_number);
1442: IF (is_debug_procedure_on) THEN
1443: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name,'Begin(+)');
1444: END IF;
1445: IF (is_debug_statement_on) THEN
1446: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, p_kle_id:' || p_kle_id);
1447: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, p_asset_number:' || p_asset_number);
1448: END IF;
1449:
1450: OPEN l_okclines_csr;
1443: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name,'Begin(+)');
1444: END IF;
1445: IF (is_debug_statement_on) THEN
1446: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, p_kle_id:' || p_kle_id);
1447: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, p_asset_number:' || p_asset_number);
1448: END IF;
1449:
1450: OPEN l_okclines_csr;
1451: FETCH l_okclines_csr INTO l_sts_code;
1474:
1475: END IF;
1476:
1477: IF (is_debug_procedure_on) THEN
1478: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name,'End(-)');
1479: END IF;
1480:
1481: EXCEPTION
1482: WHEN OTHERS THEN
1484: IF l_okclines_csr%ISOPEN THEN
1485: CLOSE l_okclines_csr;
1486: END IF;
1487: IF (is_debug_exception_on) THEN
1488: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '
1489: || sqlcode || ' , SQLERRM : ' || sqlerrm);
1490: END IF;
1491:
1492: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1555: l_total_quantity NUMBER;
1556: l_item_number VARCHAR2(40);
1557: l_meaning fnd_lookups.meaning%TYPE := NULL;
1558: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'update_asset_return';
1559: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1560: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1561: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1562:
1563:
1556: l_item_number VARCHAR2(40);
1557: l_meaning fnd_lookups.meaning%TYPE := NULL;
1558: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'update_asset_return';
1559: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1560: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1561: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1562:
1563:
1564:
1557: l_meaning fnd_lookups.meaning%TYPE := NULL;
1558: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'update_asset_return';
1559: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1560: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1561: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1562:
1563:
1564:
1565: -- This cursor is used to get the quantity for the inventory Item
1721:
1722:
1723: BEGIN
1724: IF (is_debug_procedure_on) THEN
1725: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name,'Begin(+)');
1726: END IF;
1727: IF (is_debug_statement_on) THEN
1728: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.id:' || lp_artv_rec.id);
1729: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.kle_id:' || lp_artv_rec.kle_id);
1724: IF (is_debug_procedure_on) THEN
1725: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name,'Begin(+)');
1726: END IF;
1727: IF (is_debug_statement_on) THEN
1728: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.id:' || lp_artv_rec.id);
1729: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.kle_id:' || lp_artv_rec.kle_id);
1730: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.legal_entity_id:' || lp_artv_rec.legal_entity_id);
1731: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_description:' || lp_artv_rec.new_item_description);
1732: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.ARS_CODE:' || lp_artv_rec.ARS_CODE);
1725: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name,'Begin(+)');
1726: END IF;
1727: IF (is_debug_statement_on) THEN
1728: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.id:' || lp_artv_rec.id);
1729: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.kle_id:' || lp_artv_rec.kle_id);
1730: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.legal_entity_id:' || lp_artv_rec.legal_entity_id);
1731: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_description:' || lp_artv_rec.new_item_description);
1732: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.ARS_CODE:' || lp_artv_rec.ARS_CODE);
1733: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.art1_code:' || lp_artv_rec.art1_code);
1726: END IF;
1727: IF (is_debug_statement_on) THEN
1728: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.id:' || lp_artv_rec.id);
1729: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.kle_id:' || lp_artv_rec.kle_id);
1730: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.legal_entity_id:' || lp_artv_rec.legal_entity_id);
1731: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_description:' || lp_artv_rec.new_item_description);
1732: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.ARS_CODE:' || lp_artv_rec.ARS_CODE);
1733: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.art1_code:' || lp_artv_rec.art1_code);
1734: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.rna_id:' || lp_artv_rec.rna_id);
1727: IF (is_debug_statement_on) THEN
1728: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.id:' || lp_artv_rec.id);
1729: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.kle_id:' || lp_artv_rec.kle_id);
1730: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.legal_entity_id:' || lp_artv_rec.legal_entity_id);
1731: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_description:' || lp_artv_rec.new_item_description);
1732: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.ARS_CODE:' || lp_artv_rec.ARS_CODE);
1733: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.art1_code:' || lp_artv_rec.art1_code);
1734: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.rna_id:' || lp_artv_rec.rna_id);
1735: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_repossession_required:' || lp_artv_rec.date_repossession_required);
1728: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.id:' || lp_artv_rec.id);
1729: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.kle_id:' || lp_artv_rec.kle_id);
1730: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.legal_entity_id:' || lp_artv_rec.legal_entity_id);
1731: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_description:' || lp_artv_rec.new_item_description);
1732: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.ARS_CODE:' || lp_artv_rec.ARS_CODE);
1733: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.art1_code:' || lp_artv_rec.art1_code);
1734: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.rna_id:' || lp_artv_rec.rna_id);
1735: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_repossession_required:' || lp_artv_rec.date_repossession_required);
1736: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_repossession_actual:' || lp_artv_rec.date_repossession_actual);
1729: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.kle_id:' || lp_artv_rec.kle_id);
1730: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.legal_entity_id:' || lp_artv_rec.legal_entity_id);
1731: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_description:' || lp_artv_rec.new_item_description);
1732: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.ARS_CODE:' || lp_artv_rec.ARS_CODE);
1733: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.art1_code:' || lp_artv_rec.art1_code);
1734: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.rna_id:' || lp_artv_rec.rna_id);
1735: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_repossession_required:' || lp_artv_rec.date_repossession_required);
1736: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_repossession_actual:' || lp_artv_rec.date_repossession_actual);
1737: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_hold_until:' || lp_artv_rec.date_hold_until);
1730: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.legal_entity_id:' || lp_artv_rec.legal_entity_id);
1731: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_description:' || lp_artv_rec.new_item_description);
1732: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.ARS_CODE:' || lp_artv_rec.ARS_CODE);
1733: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.art1_code:' || lp_artv_rec.art1_code);
1734: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.rna_id:' || lp_artv_rec.rna_id);
1735: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_repossession_required:' || lp_artv_rec.date_repossession_required);
1736: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_repossession_actual:' || lp_artv_rec.date_repossession_actual);
1737: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_hold_until:' || lp_artv_rec.date_hold_until);
1738: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.floor_price:' || lp_artv_rec.floor_price);
1731: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_description:' || lp_artv_rec.new_item_description);
1732: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.ARS_CODE:' || lp_artv_rec.ARS_CODE);
1733: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.art1_code:' || lp_artv_rec.art1_code);
1734: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.rna_id:' || lp_artv_rec.rna_id);
1735: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_repossession_required:' || lp_artv_rec.date_repossession_required);
1736: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_repossession_actual:' || lp_artv_rec.date_repossession_actual);
1737: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_hold_until:' || lp_artv_rec.date_hold_until);
1738: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.floor_price:' || lp_artv_rec.floor_price);
1739: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_price:' || lp_artv_rec.new_item_price);
1732: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.ARS_CODE:' || lp_artv_rec.ARS_CODE);
1733: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.art1_code:' || lp_artv_rec.art1_code);
1734: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.rna_id:' || lp_artv_rec.rna_id);
1735: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_repossession_required:' || lp_artv_rec.date_repossession_required);
1736: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_repossession_actual:' || lp_artv_rec.date_repossession_actual);
1737: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_hold_until:' || lp_artv_rec.date_hold_until);
1738: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.floor_price:' || lp_artv_rec.floor_price);
1739: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_price:' || lp_artv_rec.new_item_price);
1740: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.currency_code:' || lp_artv_rec.currency_code);
1733: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.art1_code:' || lp_artv_rec.art1_code);
1734: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.rna_id:' || lp_artv_rec.rna_id);
1735: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_repossession_required:' || lp_artv_rec.date_repossession_required);
1736: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_repossession_actual:' || lp_artv_rec.date_repossession_actual);
1737: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_hold_until:' || lp_artv_rec.date_hold_until);
1738: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.floor_price:' || lp_artv_rec.floor_price);
1739: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_price:' || lp_artv_rec.new_item_price);
1740: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.currency_code:' || lp_artv_rec.currency_code);
1741: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.currency_conversion_code:' || lp_artv_rec.currency_conversion_code);
1734: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.rna_id:' || lp_artv_rec.rna_id);
1735: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_repossession_required:' || lp_artv_rec.date_repossession_required);
1736: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_repossession_actual:' || lp_artv_rec.date_repossession_actual);
1737: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_hold_until:' || lp_artv_rec.date_hold_until);
1738: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.floor_price:' || lp_artv_rec.floor_price);
1739: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_price:' || lp_artv_rec.new_item_price);
1740: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.currency_code:' || lp_artv_rec.currency_code);
1741: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.currency_conversion_code:' || lp_artv_rec.currency_conversion_code);
1742: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.repurchase_agmt_yn:' || lp_artv_rec.repurchase_agmt_yn);
1735: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_repossession_required:' || lp_artv_rec.date_repossession_required);
1736: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_repossession_actual:' || lp_artv_rec.date_repossession_actual);
1737: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_hold_until:' || lp_artv_rec.date_hold_until);
1738: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.floor_price:' || lp_artv_rec.floor_price);
1739: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_price:' || lp_artv_rec.new_item_price);
1740: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.currency_code:' || lp_artv_rec.currency_code);
1741: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.currency_conversion_code:' || lp_artv_rec.currency_conversion_code);
1742: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.repurchase_agmt_yn:' || lp_artv_rec.repurchase_agmt_yn);
1743: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.rmr_id:' || lp_artv_rec.rmr_id);
1736: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_repossession_actual:' || lp_artv_rec.date_repossession_actual);
1737: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_hold_until:' || lp_artv_rec.date_hold_until);
1738: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.floor_price:' || lp_artv_rec.floor_price);
1739: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_price:' || lp_artv_rec.new_item_price);
1740: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.currency_code:' || lp_artv_rec.currency_code);
1741: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.currency_conversion_code:' || lp_artv_rec.currency_conversion_code);
1742: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.repurchase_agmt_yn:' || lp_artv_rec.repurchase_agmt_yn);
1743: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.rmr_id:' || lp_artv_rec.rmr_id);
1744: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.ASSET_FMV_AMOUNT:' || lp_artv_rec.ASSET_FMV_AMOUNT);
1737: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.date_hold_until:' || lp_artv_rec.date_hold_until);
1738: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.floor_price:' || lp_artv_rec.floor_price);
1739: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_price:' || lp_artv_rec.new_item_price);
1740: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.currency_code:' || lp_artv_rec.currency_code);
1741: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.currency_conversion_code:' || lp_artv_rec.currency_conversion_code);
1742: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.repurchase_agmt_yn:' || lp_artv_rec.repurchase_agmt_yn);
1743: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.rmr_id:' || lp_artv_rec.rmr_id);
1744: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.ASSET_FMV_AMOUNT:' || lp_artv_rec.ASSET_FMV_AMOUNT);
1745: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.legal_entity_id:' || lp_artv_rec.legal_entity_id);
1738: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.floor_price:' || lp_artv_rec.floor_price);
1739: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_price:' || lp_artv_rec.new_item_price);
1740: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.currency_code:' || lp_artv_rec.currency_code);
1741: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.currency_conversion_code:' || lp_artv_rec.currency_conversion_code);
1742: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.repurchase_agmt_yn:' || lp_artv_rec.repurchase_agmt_yn);
1743: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.rmr_id:' || lp_artv_rec.rmr_id);
1744: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.ASSET_FMV_AMOUNT:' || lp_artv_rec.ASSET_FMV_AMOUNT);
1745: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.legal_entity_id:' || lp_artv_rec.legal_entity_id);
1746: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.imr_id:' || lp_artv_rec.imr_id);
1739: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_price:' || lp_artv_rec.new_item_price);
1740: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.currency_code:' || lp_artv_rec.currency_code);
1741: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.currency_conversion_code:' || lp_artv_rec.currency_conversion_code);
1742: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.repurchase_agmt_yn:' || lp_artv_rec.repurchase_agmt_yn);
1743: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.rmr_id:' || lp_artv_rec.rmr_id);
1744: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.ASSET_FMV_AMOUNT:' || lp_artv_rec.ASSET_FMV_AMOUNT);
1745: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.legal_entity_id:' || lp_artv_rec.legal_entity_id);
1746: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.imr_id:' || lp_artv_rec.imr_id);
1747: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.attribute14:' || lp_artv_rec.attribute14);
1740: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.currency_code:' || lp_artv_rec.currency_code);
1741: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.currency_conversion_code:' || lp_artv_rec.currency_conversion_code);
1742: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.repurchase_agmt_yn:' || lp_artv_rec.repurchase_agmt_yn);
1743: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.rmr_id:' || lp_artv_rec.rmr_id);
1744: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.ASSET_FMV_AMOUNT:' || lp_artv_rec.ASSET_FMV_AMOUNT);
1745: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.legal_entity_id:' || lp_artv_rec.legal_entity_id);
1746: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.imr_id:' || lp_artv_rec.imr_id);
1747: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.attribute14:' || lp_artv_rec.attribute14);
1748: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_number:' || lp_artv_rec.new_item_number);
1741: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.currency_conversion_code:' || lp_artv_rec.currency_conversion_code);
1742: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.repurchase_agmt_yn:' || lp_artv_rec.repurchase_agmt_yn);
1743: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.rmr_id:' || lp_artv_rec.rmr_id);
1744: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.ASSET_FMV_AMOUNT:' || lp_artv_rec.ASSET_FMV_AMOUNT);
1745: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.legal_entity_id:' || lp_artv_rec.legal_entity_id);
1746: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.imr_id:' || lp_artv_rec.imr_id);
1747: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.attribute14:' || lp_artv_rec.attribute14);
1748: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_number:' || lp_artv_rec.new_item_number);
1749: END IF;
1742: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.repurchase_agmt_yn:' || lp_artv_rec.repurchase_agmt_yn);
1743: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.rmr_id:' || lp_artv_rec.rmr_id);
1744: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.ASSET_FMV_AMOUNT:' || lp_artv_rec.ASSET_FMV_AMOUNT);
1745: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.legal_entity_id:' || lp_artv_rec.legal_entity_id);
1746: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.imr_id:' || lp_artv_rec.imr_id);
1747: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.attribute14:' || lp_artv_rec.attribute14);
1748: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_number:' || lp_artv_rec.new_item_number);
1749: END IF;
1750:
1743: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.rmr_id:' || lp_artv_rec.rmr_id);
1744: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.ASSET_FMV_AMOUNT:' || lp_artv_rec.ASSET_FMV_AMOUNT);
1745: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.legal_entity_id:' || lp_artv_rec.legal_entity_id);
1746: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.imr_id:' || lp_artv_rec.imr_id);
1747: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.attribute14:' || lp_artv_rec.attribute14);
1748: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_number:' || lp_artv_rec.new_item_number);
1749: END IF;
1750:
1751: l_return_status := OKL_API.START_ACTIVITY( l_api_name,
1744: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.ASSET_FMV_AMOUNT:' || lp_artv_rec.ASSET_FMV_AMOUNT);
1745: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.legal_entity_id:' || lp_artv_rec.legal_entity_id);
1746: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.imr_id:' || lp_artv_rec.imr_id);
1747: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.attribute14:' || lp_artv_rec.attribute14);
1748: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'In param, lp_artv_rec.new_item_number:' || lp_artv_rec.new_item_number);
1749: END IF;
1750:
1751: l_return_status := OKL_API.START_ACTIVITY( l_api_name,
1752: G_PKG_NAME,
1790: FETCH fetch_legal_entity INTO l_legal_entity_id, l_deal_type; --6674730
1791: CLOSE fetch_legal_entity;
1792:
1793: IF (is_debug_statement_on) THEN
1794: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_asset_number :'||l_asset_number);
1795: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_quantity :'||l_quantity);
1796: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_current_db_status :'||l_current_db_status);
1797: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_kle_id :'||l_kle_id);
1798: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_chr_id :'||l_chr_id);
1791: CLOSE fetch_legal_entity;
1792:
1793: IF (is_debug_statement_on) THEN
1794: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_asset_number :'||l_asset_number);
1795: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_quantity :'||l_quantity);
1796: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_current_db_status :'||l_current_db_status);
1797: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_kle_id :'||l_kle_id);
1798: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_chr_id :'||l_chr_id);
1799: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_item_number :'||l_item_number);
1792:
1793: IF (is_debug_statement_on) THEN
1794: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_asset_number :'||l_asset_number);
1795: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_quantity :'||l_quantity);
1796: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_current_db_status :'||l_current_db_status);
1797: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_kle_id :'||l_kle_id);
1798: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_chr_id :'||l_chr_id);
1799: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_item_number :'||l_item_number);
1800: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_legal_entity_id :'||l_legal_entity_id);
1793: IF (is_debug_statement_on) THEN
1794: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_asset_number :'||l_asset_number);
1795: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_quantity :'||l_quantity);
1796: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_current_db_status :'||l_current_db_status);
1797: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_kle_id :'||l_kle_id);
1798: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_chr_id :'||l_chr_id);
1799: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_item_number :'||l_item_number);
1800: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_legal_entity_id :'||l_legal_entity_id);
1801: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_deal_type :'||l_deal_type);
1794: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_asset_number :'||l_asset_number);
1795: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_quantity :'||l_quantity);
1796: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_current_db_status :'||l_current_db_status);
1797: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_kle_id :'||l_kle_id);
1798: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_chr_id :'||l_chr_id);
1799: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_item_number :'||l_item_number);
1800: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_legal_entity_id :'||l_legal_entity_id);
1801: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_deal_type :'||l_deal_type);
1802: END IF;
1795: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_quantity :'||l_quantity);
1796: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_current_db_status :'||l_current_db_status);
1797: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_kle_id :'||l_kle_id);
1798: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_chr_id :'||l_chr_id);
1799: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_item_number :'||l_item_number);
1800: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_legal_entity_id :'||l_legal_entity_id);
1801: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_deal_type :'||l_deal_type);
1802: END IF;
1803:
1796: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_current_db_status :'||l_current_db_status);
1797: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_kle_id :'||l_kle_id);
1798: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_chr_id :'||l_chr_id);
1799: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_item_number :'||l_item_number);
1800: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_legal_entity_id :'||l_legal_entity_id);
1801: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_deal_type :'||l_deal_type);
1802: END IF;
1803:
1804: IF (l_legal_entity_id is null or l_legal_entity_id = OKC_API.G_MISS_NUM) THEN
1797: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_kle_id :'||l_kle_id);
1798: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_chr_id :'||l_chr_id);
1799: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_item_number :'||l_item_number);
1800: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_legal_entity_id :'||l_legal_entity_id);
1801: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_deal_type :'||l_deal_type);
1802: END IF;
1803:
1804: IF (l_legal_entity_id is null or l_legal_entity_id = OKC_API.G_MISS_NUM) THEN
1805: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
1930: p_asset_number => l_asset_number,
1931: x_return_status => x_return_status);
1932:
1933: IF (is_debug_statement_on) THEN
1934: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called check_asset_status, x_return_status: '||x_return_status);
1935: END IF;
1936: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1937: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1938: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1975: END IF;
1976: CLOSE l_systemparamsall_csr;
1977:
1978: IF (is_debug_statement_on) THEN
1979: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_remk_process: '||l_remk_process);
1980: END IF;
1981:
1982: IF l_remk_process IS NULL THEN
1983: -- Remarketing process is not setup for this operating unit.
2030: -- SECHAWLA 04-OCT-04 3924244 : Call the following API if the Remarketing process is setup as "Standard"
2031: -- Pass the item number entered by the user. Item number may be NULL (if user does not enter)
2032: IF l_remk_process = 'STANDARD' THEN
2033: IF (is_debug_statement_on) THEN
2034: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'calling OKL_AM_REMARKET_ASSET_PUB.create_rmk_item');
2035: END IF;
2036:
2037: OKL_AM_REMARKET_ASSET_PUB.create_rmk_item(
2038: p_api_version => p_api_version,
2046: x_msg_data => x_msg_data,
2047: x_New_Item_Number => l_New_Item_Number,
2048: x_New_Item_Id => l_New_Item_id);
2049: IF (is_debug_statement_on) THEN
2050: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called OKL_AM_REMARKET_ASSET_PUB.create_rmk_item, x_return_status: '|| x_return_status);
2051: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_New_Item_Number: '|| l_New_Item_Number);
2052: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_New_Item_id: '|| l_New_Item_id);
2053: END IF;
2054:
2047: x_New_Item_Number => l_New_Item_Number,
2048: x_New_Item_Id => l_New_Item_id);
2049: IF (is_debug_statement_on) THEN
2050: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called OKL_AM_REMARKET_ASSET_PUB.create_rmk_item, x_return_status: '|| x_return_status);
2051: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_New_Item_Number: '|| l_New_Item_Number);
2052: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_New_Item_id: '|| l_New_Item_id);
2053: END IF;
2054:
2055: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2048: x_New_Item_Id => l_New_Item_id);
2049: IF (is_debug_statement_on) THEN
2050: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called OKL_AM_REMARKET_ASSET_PUB.create_rmk_item, x_return_status: '|| x_return_status);
2051: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_New_Item_Number: '|| l_New_Item_Number);
2052: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_New_Item_id: '|| l_New_Item_id);
2053: END IF;
2054:
2055: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2056: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2086: -- SECHAWLA 04-OCT-04 3924244 : For Custom Remarketing Process, launch a WF
2087: ELSIF l_remk_process = 'CUSTOM' THEN
2088: -- Raise event to launch the service k integration workflow
2089: IF (is_debug_statement_on) THEN
2090: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'calling OKL_AM_REMARKET_ASSET_WF.RAISE_RMK_CUSTOM_PROCESS_EVENT');
2091: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lp_artv_rec.id: '|| lp_artv_rec.id);
2092: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'p_artv_rec.new_item_number: '|| p_artv_rec.new_item_number);
2093: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'p_artv_rec.new_item_description: '|| p_artv_rec.new_item_description);
2094: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'p_artv_rec.new_Item_Price: '|| p_artv_rec.new_Item_Price);
2087: ELSIF l_remk_process = 'CUSTOM' THEN
2088: -- Raise event to launch the service k integration workflow
2089: IF (is_debug_statement_on) THEN
2090: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'calling OKL_AM_REMARKET_ASSET_WF.RAISE_RMK_CUSTOM_PROCESS_EVENT');
2091: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lp_artv_rec.id: '|| lp_artv_rec.id);
2092: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'p_artv_rec.new_item_number: '|| p_artv_rec.new_item_number);
2093: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'p_artv_rec.new_item_description: '|| p_artv_rec.new_item_description);
2094: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'p_artv_rec.new_Item_Price: '|| p_artv_rec.new_Item_Price);
2095: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_quantity: '|| l_quantity);
2088: -- Raise event to launch the service k integration workflow
2089: IF (is_debug_statement_on) THEN
2090: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'calling OKL_AM_REMARKET_ASSET_WF.RAISE_RMK_CUSTOM_PROCESS_EVENT');
2091: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lp_artv_rec.id: '|| lp_artv_rec.id);
2092: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'p_artv_rec.new_item_number: '|| p_artv_rec.new_item_number);
2093: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'p_artv_rec.new_item_description: '|| p_artv_rec.new_item_description);
2094: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'p_artv_rec.new_Item_Price: '|| p_artv_rec.new_Item_Price);
2095: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_quantity: '|| l_quantity);
2096: END IF;
2089: IF (is_debug_statement_on) THEN
2090: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'calling OKL_AM_REMARKET_ASSET_WF.RAISE_RMK_CUSTOM_PROCESS_EVENT');
2091: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lp_artv_rec.id: '|| lp_artv_rec.id);
2092: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'p_artv_rec.new_item_number: '|| p_artv_rec.new_item_number);
2093: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'p_artv_rec.new_item_description: '|| p_artv_rec.new_item_description);
2094: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'p_artv_rec.new_Item_Price: '|| p_artv_rec.new_Item_Price);
2095: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_quantity: '|| l_quantity);
2096: END IF;
2097:
2090: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'calling OKL_AM_REMARKET_ASSET_WF.RAISE_RMK_CUSTOM_PROCESS_EVENT');
2091: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lp_artv_rec.id: '|| lp_artv_rec.id);
2092: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'p_artv_rec.new_item_number: '|| p_artv_rec.new_item_number);
2093: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'p_artv_rec.new_item_description: '|| p_artv_rec.new_item_description);
2094: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'p_artv_rec.new_Item_Price: '|| p_artv_rec.new_Item_Price);
2095: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_quantity: '|| l_quantity);
2096: END IF;
2097:
2098: OKL_AM_REMARKET_ASSET_WF.RAISE_RMK_CUSTOM_PROCESS_EVENT(
2091: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lp_artv_rec.id: '|| lp_artv_rec.id);
2092: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'p_artv_rec.new_item_number: '|| p_artv_rec.new_item_number);
2093: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'p_artv_rec.new_item_description: '|| p_artv_rec.new_item_description);
2094: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'p_artv_rec.new_Item_Price: '|| p_artv_rec.new_Item_Price);
2095: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_quantity: '|| l_quantity);
2096: END IF;
2097:
2098: OKL_AM_REMARKET_ASSET_WF.RAISE_RMK_CUSTOM_PROCESS_EVENT(
2099: p_asset_return_id => lp_artv_rec.id,
2101: p_Item_Description => p_artv_rec.new_item_description,
2102: p_Item_Price => p_artv_rec.new_Item_Price,
2103: p_quantity => l_quantity);
2104: IF (is_debug_statement_on) THEN
2105: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called OKL_AM_REMARKET_ASSET_WF.RAISE_RMK_CUSTOM_PROCESS_EVENT');
2106: END IF;
2107:
2108: l_custom_rmk_wf := 'Y'; -- SECHAWLA 29-OCT-04 3924244 added
2109:
2186: check_asset_status(p_kle_id => l_kle_id,
2187: p_asset_number => l_asset_number,
2188: x_return_status => x_return_status);
2189: IF (is_debug_statement_on) THEN
2190: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called check_asset_status, x_return_status: ' || x_return_status);
2191: END IF;
2192:
2193: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2194: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2209: check_asset_status(p_kle_id => l_kle_id,
2210: p_asset_number => l_asset_number,
2211: x_return_status => x_return_status);
2212: IF (is_debug_statement_on) THEN
2213: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called check_asset_status, x_return_status: ' || x_return_status);
2214: END IF;
2215:
2216: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2217: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2221:
2222: -- SECHAWLA 22-JAN-03 Bug # 2762419 : end modification
2223:
2224: IF (is_debug_statement_on) THEN
2225: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'calling OKL_AM_ASSET_DISPOSE_PVT.dispose_asset');
2226: END IF;
2227:
2228: -- call asset disposition for full retirement of the asset
2229: OKL_AM_ASSET_DISPOSE_PVT.dispose_asset (
2236: p_quantity => l_quantity,
2237: p_proceeds_of_sale => 0,
2238: p_legal_entity_id => lp_artv_rec.legal_entity_id);
2239: IF (is_debug_statement_on) THEN
2240: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called OKL_AM_ASSET_DISPOSE_PVT.dispose_asset, x_return_status: ' || x_return_status);
2241: END IF;
2242:
2243: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2244: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2455: END IF; -- for LOAN
2456: -- rmunjulu Bug 6674730 end
2457:
2458: IF (is_debug_statement_on) THEN
2459: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'calling OKL_ASSET_RETURNS_PUB.update_asset_returns');
2460: END IF;
2461: -- call update of tapi
2462: OKL_ASSET_RETURNS_PUB.update_asset_returns(
2463: p_api_version => p_api_version,
2467: x_msg_data => x_msg_data,
2468: p_artv_rec => lp_artv_rec,
2469: x_artv_rec => lx_artv_rec);
2470: IF (is_debug_statement_on) THEN
2471: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called OKL_ASSET_RETURNS_PUB.update_asset_returns, x_return_status: ' || x_return_status);
2472: END IF;
2473:
2474: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2475: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2484:
2485: IF lp_artv_rec.art1_code = 'REPOS_REQUEST' THEN
2486:
2487: IF (is_debug_statement_on) THEN
2488: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'calling okl_am_wf.raise_business_event,oracle.apps.okl.am.notifycollections, lp_artv_rec.id: ' || lp_artv_rec.id);
2489: END IF;
2490: -- send notification to the user who created the notification request
2491: okl_am_wf.raise_business_event(lp_artv_rec.id,'oracle.apps.okl.am.notifycollections');
2492: END IF;
2495:
2496:
2497: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2498: IF (is_debug_procedure_on) THEN
2499: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name,'End(-)');
2500: END IF;
2501:
2502: EXCEPTION
2503: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2501:
2502: EXCEPTION
2503: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2504: IF (is_debug_exception_on) THEN
2505: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_ERROR');
2506: END IF;
2507:
2508: IF l_assetreturnuv_csr%ISOPEN THEN
2509: CLOSE l_assetreturnuv_csr;
2551: );
2552:
2553: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2554: IF (is_debug_exception_on) THEN
2555: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_UNEXPECTED_ERROR');
2556: END IF;
2557:
2558: IF l_assetreturnuv_csr%ISOPEN THEN
2559: CLOSE l_assetreturnuv_csr;
2602: );
2603:
2604: WHEN OTHERS THEN
2605: IF (is_debug_exception_on) THEN
2606: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '
2607: || sqlcode || ' , SQLERRM : ' || sqlerrm);
2608: END IF;
2609:
2610: IF l_assetreturnuv_csr%ISOPEN THEN
2681: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2682: l_api_name CONSTANT VARCHAR2(30) := 'update_asset_return';
2683: l_api_version CONSTANT NUMBER := 1;
2684: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'create_asset_return';
2685: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
2686: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
2687: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
2688: BEGIN
2689: IF (is_debug_procedure_on) THEN
2682: l_api_name CONSTANT VARCHAR2(30) := 'update_asset_return';
2683: l_api_version CONSTANT NUMBER := 1;
2684: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'create_asset_return';
2685: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
2686: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
2687: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
2688: BEGIN
2689: IF (is_debug_procedure_on) THEN
2690: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name,'Begin(+)');
2683: l_api_version CONSTANT NUMBER := 1;
2684: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'create_asset_return';
2685: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
2686: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
2687: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
2688: BEGIN
2689: IF (is_debug_procedure_on) THEN
2690: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name,'Begin(+)');
2691: END IF;
2686: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
2687: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
2688: BEGIN
2689: IF (is_debug_procedure_on) THEN
2690: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name,'Begin(+)');
2691: END IF;
2692: IF (is_debug_statement_on) THEN
2693: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'p_artv_tbl.COUNT:'||p_artv_tbl.COUNT);
2694: END IF;
2689: IF (is_debug_procedure_on) THEN
2690: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name,'Begin(+)');
2691: END IF;
2692: IF (is_debug_statement_on) THEN
2693: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'p_artv_tbl.COUNT:'||p_artv_tbl.COUNT);
2694: END IF;
2695:
2696: l_return_status := OKL_API.START_ACTIVITY( l_api_name,
2697: G_PKG_NAME,
2712: i := p_artv_tbl.FIRST;
2713: -- loop thru the table of records and create asset return for each record
2714: LOOP
2715: IF (is_debug_statement_on) THEN
2716: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'calling create_asset_return');
2717: END IF;
2718: create_asset_return (
2719: p_api_version => p_api_version,
2720: p_init_msg_list => OKL_API.G_FALSE,
2724: p_artv_rec => p_artv_tbl(i),
2725: x_artv_rec => x_artv_tbl(i),
2726: p_quote_id => p_quote_id); -- 29 Oct 2004 PAGARG Bug# 3925453
2727: IF (is_debug_statement_on) THEN
2728: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called create_asset_return, l_return_status: ' || l_return_status);
2729: END IF;
2730:
2731: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
2732: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
2741: x_return_status := l_overall_status;
2742:
2743: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2744: IF (is_debug_procedure_on) THEN
2745: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name,'End(-)');
2746: END IF;
2747:
2748: EXCEPTION
2749: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2747:
2748: EXCEPTION
2749: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2750: IF (is_debug_exception_on) THEN
2751: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_ERROR');
2752: END IF;
2753:
2754: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2755: (
2762: );
2763:
2764: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2765: IF (is_debug_exception_on) THEN
2766: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_UNEXPECTED_ERROR');
2767: END IF;
2768:
2769: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
2770: (
2777: );
2778:
2779: WHEN OTHERS THEN
2780: IF (is_debug_exception_on) THEN
2781: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '
2782: || sqlcode || ' , SQLERRM : ' || sqlerrm);
2783: END IF;
2784:
2785:
2819: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2820: l_api_name CONSTANT VARCHAR2(30) := 'update_asset_return';
2821: l_api_version CONSTANT NUMBER := 1;
2822: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'update_asset_return';
2823: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
2824: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
2825: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
2826: BEGIN
2827: IF (is_debug_procedure_on) THEN
2820: l_api_name CONSTANT VARCHAR2(30) := 'update_asset_return';
2821: l_api_version CONSTANT NUMBER := 1;
2822: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'update_asset_return';
2823: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
2824: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
2825: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
2826: BEGIN
2827: IF (is_debug_procedure_on) THEN
2828: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name,'Begin(+)');
2821: l_api_version CONSTANT NUMBER := 1;
2822: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'update_asset_return';
2823: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
2824: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
2825: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
2826: BEGIN
2827: IF (is_debug_procedure_on) THEN
2828: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name,'Begin(+)');
2829: END IF;
2824: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
2825: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
2826: BEGIN
2827: IF (is_debug_procedure_on) THEN
2828: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name,'Begin(+)');
2829: END IF;
2830: IF (is_debug_statement_on) THEN
2831: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'p_artv_tbl.COUNT:'||p_artv_tbl.COUNT);
2832: END IF;
2827: IF (is_debug_procedure_on) THEN
2828: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name,'Begin(+)');
2829: END IF;
2830: IF (is_debug_statement_on) THEN
2831: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'p_artv_tbl.COUNT:'||p_artv_tbl.COUNT);
2832: END IF;
2833:
2834: l_return_status := OKL_API.START_ACTIVITY( l_api_name,
2835: G_PKG_NAME,
2850: i := p_artv_tbl.FIRST;
2851: -- update asset return for each table record
2852: LOOP
2853: IF (is_debug_statement_on) THEN
2854: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'calling update_asset_return');
2855: END IF;
2856:
2857: update_asset_return (
2858: p_api_version => p_api_version,
2862: x_msg_data => x_msg_data,
2863: p_artv_rec => p_artv_tbl(i),
2864: x_artv_rec => x_artv_tbl(i));
2865: IF (is_debug_statement_on) THEN
2866: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called update_asset_return, l_return_status: ' || l_return_status);
2867: END IF;
2868:
2869: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
2870: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
2880: x_return_status := l_overall_status;
2881:
2882: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2883: IF (is_debug_procedure_on) THEN
2884: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name,'End(-)');
2885: END IF;
2886:
2887: EXCEPTION
2888: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2886:
2887: EXCEPTION
2888: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2889: IF (is_debug_exception_on) THEN
2890: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_ERROR');
2891: END IF;
2892:
2893: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2894: (
2901: );
2902:
2903: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2904: IF (is_debug_exception_on) THEN
2905: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_UNEXPECTED_ERROR');
2906: END IF;
2907:
2908: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
2909: (
2916: );
2917:
2918: WHEN OTHERS THEN
2919: IF (is_debug_exception_on) THEN
2920: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '
2921: || sqlcode || ' , SQLERRM : ' || sqlerrm);
2922: END IF;
2923: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
2924: (