DBA Data[Home] [Help]

APPS.OKC_K_RENEW_ASMBLR_PVT dependencies on OKC_API

Line 44: l_return_status := OKC_API.START_ACTIVITY

40: AND acn.correlation = 'KRENEW' ;
41:
42: BEGIN
43:
44: l_return_status := OKC_API.START_ACTIVITY
45: (l_api_name
46: ,p_init_msg_list
47: ,'_PROCESS'
48: ,x_return_status);

Line 50: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

46: ,p_init_msg_list
47: ,'_PROCESS'
48: ,x_return_status);
49:
50: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
51: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
52: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
53: RAISE OKC_API.G_EXCEPTION_ERROR;
54: END IF;

Line 51: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

47: ,'_PROCESS'
48: ,x_return_status);
49:
50: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
51: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
52: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
53: RAISE OKC_API.G_EXCEPTION_ERROR;
54: END IF;
55:

Line 52: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

48: ,x_return_status);
49:
50: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
51: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
52: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
53: RAISE OKC_API.G_EXCEPTION_ERROR;
54: END IF;
55:
56: l_corrid_rec.corrid := 'KRENEW' ;

Line 53: RAISE OKC_API.G_EXCEPTION_ERROR;

49:
50: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
51: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
52: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
53: RAISE OKC_API.G_EXCEPTION_ERROR;
54: END IF;
55:
56: l_corrid_rec.corrid := 'KRENEW' ;
57:

Line 158: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

154: ,p_corrid_rec => l_corrid_rec
155: ,p_msg_tab => l_msg_tbl
156: ,p_queue_name => okc_aq_pvt.g_event_queue_name);
157:
158: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
159: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
160: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
161: RAISE OKC_API.G_EXCEPTION_ERROR;
162: END IF;

Line 159: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

155: ,p_msg_tab => l_msg_tbl
156: ,p_queue_name => okc_aq_pvt.g_event_queue_name);
157:
158: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
159: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
160: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
161: RAISE OKC_API.G_EXCEPTION_ERROR;
162: END IF;
163: END IF; -- OKC_K_SIGN_ASMBLR_PVT.isActionEnabled

Line 160: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

156: ,p_queue_name => okc_aq_pvt.g_event_queue_name);
157:
158: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
159: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
160: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
161: RAISE OKC_API.G_EXCEPTION_ERROR;
162: END IF;
163: END IF; -- OKC_K_SIGN_ASMBLR_PVT.isActionEnabled
164: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 161: RAISE OKC_API.G_EXCEPTION_ERROR;

157:
158: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
159: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
160: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
161: RAISE OKC_API.G_EXCEPTION_ERROR;
162: END IF;
163: END IF; -- OKC_K_SIGN_ASMBLR_PVT.isActionEnabled
164: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
165:

Line 164: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

160: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
161: RAISE OKC_API.G_EXCEPTION_ERROR;
162: END IF;
163: END IF; -- OKC_K_SIGN_ASMBLR_PVT.isActionEnabled
164: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
165:
166: EXCEPTION
167: WHEN OKC_API.G_EXCEPTION_ERROR THEN
168: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 167: WHEN OKC_API.G_EXCEPTION_ERROR THEN

163: END IF; -- OKC_K_SIGN_ASMBLR_PVT.isActionEnabled
164: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
165:
166: EXCEPTION
167: WHEN OKC_API.G_EXCEPTION_ERROR THEN
168: x_return_status := OKC_API.HANDLE_EXCEPTIONS
169: (l_api_name,
170: G_PKG_NAME,
171: 'OKC_API.G_RET_STS_ERROR',

Line 168: x_return_status := OKC_API.HANDLE_EXCEPTIONS

164: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
165:
166: EXCEPTION
167: WHEN OKC_API.G_EXCEPTION_ERROR THEN
168: x_return_status := OKC_API.HANDLE_EXCEPTIONS
169: (l_api_name,
170: G_PKG_NAME,
171: 'OKC_API.G_RET_STS_ERROR',
172: x_msg_count,

Line 171: 'OKC_API.G_RET_STS_ERROR',

167: WHEN OKC_API.G_EXCEPTION_ERROR THEN
168: x_return_status := OKC_API.HANDLE_EXCEPTIONS
169: (l_api_name,
170: G_PKG_NAME,
171: 'OKC_API.G_RET_STS_ERROR',
172: x_msg_count,
173: x_msg_data,
174: '_PROCESS');
175: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 175: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

171: 'OKC_API.G_RET_STS_ERROR',
172: x_msg_count,
173: x_msg_data,
174: '_PROCESS');
175: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
176: x_return_status := OKC_API.HANDLE_EXCEPTIONS
177: (l_api_name,
178: G_PKG_NAME,
179: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 176: x_return_status := OKC_API.HANDLE_EXCEPTIONS

172: x_msg_count,
173: x_msg_data,
174: '_PROCESS');
175: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
176: x_return_status := OKC_API.HANDLE_EXCEPTIONS
177: (l_api_name,
178: G_PKG_NAME,
179: 'OKC_API.G_RET_STS_UNEXP_ERROR',
180: x_msg_count,

Line 179: 'OKC_API.G_RET_STS_UNEXP_ERROR',

175: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
176: x_return_status := OKC_API.HANDLE_EXCEPTIONS
177: (l_api_name,
178: G_PKG_NAME,
179: 'OKC_API.G_RET_STS_UNEXP_ERROR',
180: x_msg_count,
181: x_msg_data,
182: '_PROCESS');
183: WHEN OTHERS THEN

Line 184: x_return_status := OKC_API.HANDLE_EXCEPTIONS

180: x_msg_count,
181: x_msg_data,
182: '_PROCESS');
183: WHEN OTHERS THEN
184: x_return_status := OKC_API.HANDLE_EXCEPTIONS
185: (l_api_name,
186: G_PKG_NAME,
187: 'OTHERS',
188: x_msg_count,