DBA Data[Home] [Help]

APPS.OKC_CG_UPD_ASMBLR_PVT dependencies on OKC_API

Line 70: l_return_status := OKC_API.START_ACTIVITY

66: ctr_rec ctr_cur%ROWTYPE;
67:
68: BEGIN
69:
70: l_return_status := OKC_API.START_ACTIVITY
71: (l_api_name
72: ,l_init_msg_list
73: ,'_PVT'
74: ,x_return_status);

Line 76: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

72: ,l_init_msg_list
73: ,'_PVT'
74: ,x_return_status);
75:
76: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
77: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
78: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
79: RAISE OKC_API.G_EXCEPTION_ERROR;
80: END IF;

Line 77: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

73: ,'_PVT'
74: ,x_return_status);
75:
76: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
77: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
78: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
79: RAISE OKC_API.G_EXCEPTION_ERROR;
80: END IF;
81:

Line 78: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

74: ,x_return_status);
75:
76: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
77: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
78: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
79: RAISE OKC_API.G_EXCEPTION_ERROR;
80: END IF;
81:
82: l_corrid_rec.corrid := 'CTR_GRP_UPD' ;

Line 79: RAISE OKC_API.G_EXCEPTION_ERROR;

75:
76: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
77: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
78: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
79: RAISE OKC_API.G_EXCEPTION_ERROR;
80: END IF;
81:
82: l_corrid_rec.corrid := 'CTR_GRP_UPD' ;
83: i := 0;

Line 148: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

144: ,p_corrid_rec => l_corrid_rec
145: ,p_msg_tab => l_msg_tbl
146: ,p_queue_name => okc_aq_pvt.g_event_queue_name);
147:
148: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
149: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
150: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
151: RAISE OKC_API.G_EXCEPTION_ERROR;
152: END IF;

Line 149: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

145: ,p_msg_tab => l_msg_tbl
146: ,p_queue_name => okc_aq_pvt.g_event_queue_name);
147:
148: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
149: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
150: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
151: RAISE OKC_API.G_EXCEPTION_ERROR;
152: END IF;
153: END IF; -- OKC_K_SIGN_ASMBLR_PVT.isActionEnabled

Line 150: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

146: ,p_queue_name => okc_aq_pvt.g_event_queue_name);
147:
148: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
149: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
150: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
151: RAISE OKC_API.G_EXCEPTION_ERROR;
152: END IF;
153: END IF; -- OKC_K_SIGN_ASMBLR_PVT.isActionEnabled
154: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 151: RAISE OKC_API.G_EXCEPTION_ERROR;

147:
148: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
149: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
150: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
151: RAISE OKC_API.G_EXCEPTION_ERROR;
152: END IF;
153: END IF; -- OKC_K_SIGN_ASMBLR_PVT.isActionEnabled
154: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
155:

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

150: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
151: RAISE OKC_API.G_EXCEPTION_ERROR;
152: END IF;
153: END IF; -- OKC_K_SIGN_ASMBLR_PVT.isActionEnabled
154: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
155:
156: EXCEPTION
157: WHEN OKC_API.G_EXCEPTION_ERROR THEN
158: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 157: WHEN OKC_API.G_EXCEPTION_ERROR THEN

153: END IF; -- OKC_K_SIGN_ASMBLR_PVT.isActionEnabled
154: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
155:
156: EXCEPTION
157: WHEN OKC_API.G_EXCEPTION_ERROR THEN
158: x_return_status := OKC_API.HANDLE_EXCEPTIONS
159: (l_api_name,
160: G_PKG_NAME,
161: 'OKC_API.G_RET_STS_ERROR',

Line 158: x_return_status := OKC_API.HANDLE_EXCEPTIONS

154: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
155:
156: EXCEPTION
157: WHEN OKC_API.G_EXCEPTION_ERROR THEN
158: x_return_status := OKC_API.HANDLE_EXCEPTIONS
159: (l_api_name,
160: G_PKG_NAME,
161: 'OKC_API.G_RET_STS_ERROR',
162: x_msg_count,

Line 161: 'OKC_API.G_RET_STS_ERROR',

157: WHEN OKC_API.G_EXCEPTION_ERROR THEN
158: x_return_status := OKC_API.HANDLE_EXCEPTIONS
159: (l_api_name,
160: G_PKG_NAME,
161: 'OKC_API.G_RET_STS_ERROR',
162: x_msg_count,
163: x_msg_data,
164: '_PVT');
165: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 165: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

161: 'OKC_API.G_RET_STS_ERROR',
162: x_msg_count,
163: x_msg_data,
164: '_PVT');
165: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
166: x_return_status := OKC_API.HANDLE_EXCEPTIONS
167: (l_api_name,
168: G_PKG_NAME,
169: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 166: x_return_status := OKC_API.HANDLE_EXCEPTIONS

162: x_msg_count,
163: x_msg_data,
164: '_PVT');
165: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
166: x_return_status := OKC_API.HANDLE_EXCEPTIONS
167: (l_api_name,
168: G_PKG_NAME,
169: 'OKC_API.G_RET_STS_UNEXP_ERROR',
170: x_msg_count,

Line 169: 'OKC_API.G_RET_STS_UNEXP_ERROR',

165: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
166: x_return_status := OKC_API.HANDLE_EXCEPTIONS
167: (l_api_name,
168: G_PKG_NAME,
169: 'OKC_API.G_RET_STS_UNEXP_ERROR',
170: x_msg_count,
171: x_msg_data,
172: '_PVT');
173: WHEN OTHERS THEN

Line 174: x_return_status := OKC_API.HANDLE_EXCEPTIONS

170: x_msg_count,
171: x_msg_data,
172: '_PVT');
173: WHEN OTHERS THEN
174: x_return_status := OKC_API.HANDLE_EXCEPTIONS
175: (l_api_name,
176: G_PKG_NAME,
177: 'OTHERS',
178: x_msg_count,