APPS.OKC_CHG_REQ_ASMBLR_PVT dependencies on OKC_API

Line 41: l_return_status := OKC_API.START_ACTIVITY

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

Line 47: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 48: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 49: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

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

Line 50: RAISE OKC_API.G_EXCEPTION_ERROR;

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

Line 120: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 121: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 122: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

118: ,p_queue_name => okc_aq_pvt.g_event_queue_name);
119:
120: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
121: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
122: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
123: RAISE OKC_API.G_EXCEPTION_ERROR;
124: END IF;
125: END IF; -- OKC_K_SIGN_ASMBLR_PVT.isActionEnabled
126: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 123: RAISE OKC_API.G_EXCEPTION_ERROR;

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

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

122: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
123: RAISE OKC_API.G_EXCEPTION_ERROR;
124: END IF;
125: END IF; -- OKC_K_SIGN_ASMBLR_PVT.isActionEnabled
126: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
127:
128: EXCEPTION
129: WHEN OKC_API.G_EXCEPTION_ERROR THEN
130: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 129: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

Line 130: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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

Line 133: 'OKC_API.G_RET_STS_ERROR',

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

Line 137: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 138: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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

Line 141: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 146: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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