APPS.OKC_KL_STS_CHG_ASMBLR_PVT dependencies on OKC_API

Line 43: l_return_status := OKC_API.START_ACTIVITY

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

Line 49: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 50: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 51: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

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

Line 52: RAISE OKC_API.G_EXCEPTION_ERROR;

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

Line 122: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

118: ,p_corrid_rec => l_corrid_rec
119: ,p_msg_tab => l_msg_tbl
120: ,p_queue_name => okc_aq_pvt.g_event_queue_name);
121:
122: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
123: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
124: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
125: RAISE OKC_API.G_EXCEPTION_ERROR;
126: END IF;

Line 123: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

119: ,p_msg_tab => l_msg_tbl
120: ,p_queue_name => okc_aq_pvt.g_event_queue_name);
121:
122: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
123: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
124: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
125: RAISE OKC_API.G_EXCEPTION_ERROR;
126: END IF;
127:

Line 124: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

120: ,p_queue_name => okc_aq_pvt.g_event_queue_name);
121:
122: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
123: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
124: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
125: RAISE OKC_API.G_EXCEPTION_ERROR;
126: END IF;
127:
128: END IF; -- OKC_K_SIGN_ASMBLR_PVT.isActionEnabled

Line 125: RAISE OKC_API.G_EXCEPTION_ERROR;

121:
122: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
123: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
124: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
125: RAISE OKC_API.G_EXCEPTION_ERROR;
126: END IF;
127:
128: END IF; -- OKC_K_SIGN_ASMBLR_PVT.isActionEnabled
129: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

125: RAISE OKC_API.G_EXCEPTION_ERROR;
126: END IF;
127:
128: END IF; -- OKC_K_SIGN_ASMBLR_PVT.isActionEnabled
129: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
130: EXCEPTION
131: WHEN OKC_API.G_EXCEPTION_ERROR THEN
132: x_return_status := OKC_API.HANDLE_EXCEPTIONS
133: (l_api_name,

Line 131: WHEN OKC_API.G_EXCEPTION_ERROR THEN

127:
128: END IF; -- OKC_K_SIGN_ASMBLR_PVT.isActionEnabled
129: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
130: EXCEPTION
131: WHEN OKC_API.G_EXCEPTION_ERROR THEN
132: x_return_status := OKC_API.HANDLE_EXCEPTIONS
133: (l_api_name,
134: G_PKG_NAME,
135: 'OKC_API.G_RET_STS_ERROR',

Line 132: x_return_status := OKC_API.HANDLE_EXCEPTIONS

128: END IF; -- OKC_K_SIGN_ASMBLR_PVT.isActionEnabled
129: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
130: EXCEPTION
131: WHEN OKC_API.G_EXCEPTION_ERROR THEN
132: x_return_status := OKC_API.HANDLE_EXCEPTIONS
133: (l_api_name,
134: G_PKG_NAME,
135: 'OKC_API.G_RET_STS_ERROR',
136: x_msg_count,

Line 135: 'OKC_API.G_RET_STS_ERROR',

131: WHEN OKC_API.G_EXCEPTION_ERROR THEN
132: x_return_status := OKC_API.HANDLE_EXCEPTIONS
133: (l_api_name,
134: G_PKG_NAME,
135: 'OKC_API.G_RET_STS_ERROR',
136: x_msg_count,
137: x_msg_data,
138: '_PROCESS');
139: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 139: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

135: 'OKC_API.G_RET_STS_ERROR',
136: x_msg_count,
137: x_msg_data,
138: '_PROCESS');
139: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
140: x_return_status := OKC_API.HANDLE_EXCEPTIONS
141: (l_api_name,
142: G_PKG_NAME,
143: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 140: x_return_status := OKC_API.HANDLE_EXCEPTIONS

136: x_msg_count,
137: x_msg_data,
138: '_PROCESS');
139: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
140: x_return_status := OKC_API.HANDLE_EXCEPTIONS
141: (l_api_name,
142: G_PKG_NAME,
143: 'OKC_API.G_RET_STS_UNEXP_ERROR',
144: x_msg_count,

Line 143: 'OKC_API.G_RET_STS_UNEXP_ERROR',

139: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
140: x_return_status := OKC_API.HANDLE_EXCEPTIONS
141: (l_api_name,
142: G_PKG_NAME,
143: 'OKC_API.G_RET_STS_UNEXP_ERROR',
144: x_msg_count,
145: x_msg_data,
146: '_PROCESS');
147: WHEN OTHERS THEN

Line 148: x_return_status := OKC_API.HANDLE_EXCEPTIONS

144: x_msg_count,
145: x_msg_data,
146: '_PROCESS');
147: WHEN OTHERS THEN
148: x_return_status := OKC_API.HANDLE_EXCEPTIONS
149: (l_api_name,
150: G_PKG_NAME,
151: 'OTHERS',
152: x_msg_count,