APPS.OKC_SCHR_PD_ASMBLR_PVT dependencies on OKC_API

Line 57: l_return_status := OKC_API.START_ACTIVITY

53: AND khr.scs_code = cls.code;
54:
55: BEGIN
56:
57: l_return_status := OKC_API.START_ACTIVITY
58: (l_api_name
59: ,p_init_msg_list
60: ,'_PROCESS'
61: ,x_return_status);

Line 63: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

59: ,p_init_msg_list
60: ,'_PROCESS'
61: ,x_return_status);
62:
63: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
64: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
65: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
66: RAISE OKC_API.G_EXCEPTION_ERROR;
67: END IF;

Line 64: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

60: ,'_PROCESS'
61: ,x_return_status);
62:
63: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
64: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
65: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
66: RAISE OKC_API.G_EXCEPTION_ERROR;
67: END IF;
68:

Line 65: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

61: ,x_return_status);
62:
63: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
64: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
65: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
66: RAISE OKC_API.G_EXCEPTION_ERROR;
67: END IF;
68:
69: --The correlation for the scheduled planned date reached event

Line 66: RAISE OKC_API.G_EXCEPTION_ERROR;

62:
63: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
64: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
65: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
66: RAISE OKC_API.G_EXCEPTION_ERROR;
67: END IF;
68:
69: --The correlation for the scheduled planned date reached event
70: l_corrid_rec.corrid := 'SHR_PDATE_REACH' ;

Line 140: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

136: ,p_corrid_rec => l_corrid_rec
137: ,p_msg_tab => l_msg_tbl
138: ,p_queue_name => okc_aq_pvt.g_event_queue_name);
139:
140: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
141: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
142: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
143: RAISE OKC_API.G_EXCEPTION_ERROR;
144: END IF;

Line 141: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

137: ,p_msg_tab => l_msg_tbl
138: ,p_queue_name => okc_aq_pvt.g_event_queue_name);
139:
140: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
141: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
142: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
143: RAISE OKC_API.G_EXCEPTION_ERROR;
144: END IF;
145: END LOOP;

Line 142: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

138: ,p_queue_name => okc_aq_pvt.g_event_queue_name);
139:
140: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
141: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
142: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
143: RAISE OKC_API.G_EXCEPTION_ERROR;
144: END IF;
145: END LOOP;
146: END LOOP;

Line 143: RAISE OKC_API.G_EXCEPTION_ERROR;

139:
140: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
141: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
142: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
143: RAISE OKC_API.G_EXCEPTION_ERROR;
144: END IF;
145: END LOOP;
146: END LOOP;
147: END IF; -- OKC_K_SIGN_ASMBLR_PVT.isActionEnabled

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

144: END IF;
145: END LOOP;
146: END LOOP;
147: END IF; -- OKC_K_SIGN_ASMBLR_PVT.isActionEnabled
148: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
149: EXCEPTION
150: WHEN OKC_API.G_EXCEPTION_ERROR THEN
151: x_return_status := OKC_API.HANDLE_EXCEPTIONS
152: (l_api_name,

Line 150: WHEN OKC_API.G_EXCEPTION_ERROR THEN

146: END LOOP;
147: END IF; -- OKC_K_SIGN_ASMBLR_PVT.isActionEnabled
148: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
149: EXCEPTION
150: WHEN OKC_API.G_EXCEPTION_ERROR THEN
151: x_return_status := OKC_API.HANDLE_EXCEPTIONS
152: (l_api_name,
153: G_PKG_NAME,
154: 'OKC_API.G_RET_STS_ERROR',

Line 151: x_return_status := OKC_API.HANDLE_EXCEPTIONS

147: END IF; -- OKC_K_SIGN_ASMBLR_PVT.isActionEnabled
148: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
149: EXCEPTION
150: WHEN OKC_API.G_EXCEPTION_ERROR THEN
151: x_return_status := OKC_API.HANDLE_EXCEPTIONS
152: (l_api_name,
153: G_PKG_NAME,
154: 'OKC_API.G_RET_STS_ERROR',
155: x_msg_count,

Line 154: 'OKC_API.G_RET_STS_ERROR',

150: WHEN OKC_API.G_EXCEPTION_ERROR THEN
151: x_return_status := OKC_API.HANDLE_EXCEPTIONS
152: (l_api_name,
153: G_PKG_NAME,
154: 'OKC_API.G_RET_STS_ERROR',
155: x_msg_count,
156: x_msg_data,
157: '_PROCESS');
158: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 158: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 159: x_return_status := OKC_API.HANDLE_EXCEPTIONS

155: x_msg_count,
156: x_msg_data,
157: '_PROCESS');
158: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
159: x_return_status := OKC_API.HANDLE_EXCEPTIONS
160: (l_api_name,
161: G_PKG_NAME,
162: 'OKC_API.G_RET_STS_UNEXP_ERROR',
163: x_msg_count,

Line 162: 'OKC_API.G_RET_STS_UNEXP_ERROR',

158: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
159: x_return_status := OKC_API.HANDLE_EXCEPTIONS
160: (l_api_name,
161: G_PKG_NAME,
162: 'OKC_API.G_RET_STS_UNEXP_ERROR',
163: x_msg_count,
164: x_msg_data,
165: '_PROCESS');
166: WHEN OTHERS THEN

Line 167: x_return_status := OKC_API.HANDLE_EXCEPTIONS

163: x_msg_count,
164: x_msg_data,
165: '_PROCESS');
166: WHEN OTHERS THEN
167: x_return_status := OKC_API.HANDLE_EXCEPTIONS
168: (l_api_name,
169: G_PKG_NAME,
170: 'OTHERS',
171: x_msg_count,