69: IF (is_debug_statement_on) THEN
70: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_RECYCLE_TRMNT_PVT.recycle_termination , return status: ' || l_return_status);
71: END IF;
72:
73: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
74: RAISE FND_API.G_EXC_ERROR;
75: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
77: END IF;
70: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_RECYCLE_TRMNT_PVT.recycle_termination , return status: ' || l_return_status);
71: END IF;
72:
73: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
74: RAISE FND_API.G_EXC_ERROR;
75: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
77: END IF;
78:
71: END IF;
72:
73: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
74: RAISE FND_API.G_EXC_ERROR;
75: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
77: END IF;
78:
79: --Copy value of OUT variable in the IN record type
72:
73: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
74: RAISE FND_API.G_EXC_ERROR;
75: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
77: END IF;
78:
79: --Copy value of OUT variable in the IN record type
80: lp_recy_rec := lx_recy_rec;
91: END IF;
92:
93: EXCEPTION
94:
95: WHEN FND_API.G_EXC_ERROR THEN
96: ROLLBACK TO trx_recycle_termination;
97: x_return_status := FND_API.G_RET_STS_ERROR;
98: x_msg_count := l_msg_count ;
99: x_msg_data := l_msg_data ;
93: EXCEPTION
94:
95: WHEN FND_API.G_EXC_ERROR THEN
96: ROLLBACK TO trx_recycle_termination;
97: x_return_status := FND_API.G_RET_STS_ERROR;
98: x_msg_count := l_msg_count ;
99: x_msg_data := l_msg_data ;
100: FND_MSG_PUB.count_and_get(
101: p_count => x_msg_count
102: ,p_data => x_msg_data);
103: IF (is_debug_exception_on) THEN
104: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXC_ERROR');
105: END IF;
106: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
107: ROLLBACK TO trx_recycle_termination;
108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
109: x_msg_count := l_msg_count ;
110: x_msg_data := l_msg_data ;
104: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXC_ERROR');
105: END IF;
106: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
107: ROLLBACK TO trx_recycle_termination;
108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
109: x_msg_count := l_msg_count ;
110: x_msg_data := l_msg_data ;
111: FND_MSG_PUB.count_and_get(
112: p_count => x_msg_count
115: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXC_UNEXPECTED_ERROR');
116: END IF;
117: WHEN OTHERS THEN
118: ROLLBACK TO trx_recycle_termination;
119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
120: x_msg_count := l_msg_count ;
121: x_msg_data := l_msg_data ;
122: FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_RECYCLE_TRMNT_PUB','recycle_termination');
123: FND_MSG_PUB.count_and_get(
196: IF (is_debug_statement_on) THEN
197: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_RECYCLE_TRMNT_PVT.recycle_termination , return status: ' || l_return_status);
198: END IF;
199:
200: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
201: RAISE FND_API.G_EXC_ERROR;
202: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
204: END IF;
197: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_RECYCLE_TRMNT_PVT.recycle_termination , return status: ' || l_return_status);
198: END IF;
199:
200: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
201: RAISE FND_API.G_EXC_ERROR;
202: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
204: END IF;
205:
198: END IF;
199:
200: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
201: RAISE FND_API.G_EXC_ERROR;
202: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
204: END IF;
205:
206: --Copy value of OUT variable in the IN record type
199:
200: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
201: RAISE FND_API.G_EXC_ERROR;
202: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
204: END IF;
205:
206: --Copy value of OUT variable in the IN record type
207: lp_recy_tbl := lx_recy_tbl;
218: END IF;
219:
220: EXCEPTION
221:
222: WHEN FND_API.G_EXC_ERROR THEN
223: ROLLBACK TO trx_recycle_termination;
224: x_return_status := FND_API.G_RET_STS_ERROR;
225: x_msg_count := l_msg_count ;
226: x_msg_data := l_msg_data ;
220: EXCEPTION
221:
222: WHEN FND_API.G_EXC_ERROR THEN
223: ROLLBACK TO trx_recycle_termination;
224: x_return_status := FND_API.G_RET_STS_ERROR;
225: x_msg_count := l_msg_count ;
226: x_msg_data := l_msg_data ;
227: FND_MSG_PUB.count_and_get(
228: p_count => x_msg_count
229: ,p_data => x_msg_data);
230: IF (is_debug_exception_on) THEN
231: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXC_ERROR');
232: END IF;
233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
234: ROLLBACK TO trx_recycle_termination;
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
236: x_msg_count := l_msg_count ;
237: x_msg_data := l_msg_data ;
231: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXC_ERROR');
232: END IF;
233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
234: ROLLBACK TO trx_recycle_termination;
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
236: x_msg_count := l_msg_count ;
237: x_msg_data := l_msg_data ;
238: FND_MSG_PUB.count_and_get(
239: p_count => x_msg_count
242: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXC_UNEXPECTED_ERROR');
243: END IF;
244: WHEN OTHERS THEN
245: ROLLBACK TO trx_recycle_termination;
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
247: x_msg_count := l_msg_count ;
248: x_msg_data := l_msg_data ;
249: FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_RECYCLE_TRMNT_PUB','recycle_termination');
250: FND_MSG_PUB.count_and_get(