APPS.OKC_SCHR_AD_ASMBLR_PVT dependencies on OKC_API

Line 58: l_return_status := OKC_API.START_ACTIVITY

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

Line 64: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 65: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 66: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

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

Line 67: RAISE OKC_API.G_EXCEPTION_ERROR;

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

Line 142: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

138: ,p_corrid_rec => l_corrid_rec
139: ,p_msg_tab => l_msg_tbl
140: ,p_queue_name => okc_aq_pvt.g_event_queue_name);
141:
142: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
143: commit;
144: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
145: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
146: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

Line 144: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 145: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

141:
142: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
143: commit;
144: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
145: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
146: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
147: RAISE OKC_API.G_EXCEPTION_ERROR;
148: END IF;
149:

Line 146: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

142: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
143: commit;
144: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
145: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
146: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
147: RAISE OKC_API.G_EXCEPTION_ERROR;
148: END IF;
149:
150: END LOOP;

Line 147: RAISE OKC_API.G_EXCEPTION_ERROR;

143: commit;
144: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
145: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
146: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
147: RAISE OKC_API.G_EXCEPTION_ERROR;
148: END IF;
149:
150: END LOOP;
151: END LOOP;

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

149:
150: END LOOP;
151: END LOOP;
152: END IF; -- OKC_K_SIGN_ASMBLR_PVT.isActionEnabled
153: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
154: EXCEPTION
155: WHEN OKC_API.G_EXCEPTION_ERROR THEN
156: x_return_status := OKC_API.HANDLE_EXCEPTIONS
157: (l_api_name,

Line 155: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

Line 156: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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

Line 159: 'OKC_API.G_RET_STS_ERROR',

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

Line 163: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 164: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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

Line 167: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 172: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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