DBA Data[Home] [Help]

APPS.OKL_AM_RECYCLE_TRMNT_PUB dependencies on FND_API

Line 73: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

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;

Line 74: RAISE FND_API.G_EXC_ERROR;

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:

Line 75: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

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

Line 76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;

Line 95: WHEN FND_API.G_EXC_ERROR THEN

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 ;

Line 97: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 106: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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 ;

Line 108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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(

Line 200: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

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;

Line 201: RAISE FND_API.G_EXC_ERROR;

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:

Line 202: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

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

Line 203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;

Line 222: WHEN FND_API.G_EXC_ERROR THEN

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 ;

Line 224: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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 ;

Line 235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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(