APPS.OKC_CHG_APR_ASMBLR_PVT dependencies on OKC_API

Line 41: l_return_status := OKC_API.START_ACTIVITY

37: AND acn.correlation = 'CH_APP' ;
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 := 'CH_APP' ;

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 := 'CH_APP' ;
54:

Line 119: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 120: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 121: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

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

Line 122: RAISE OKC_API.G_EXCEPTION_ERROR;

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

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

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

Line 128: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

Line 129: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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

Line 132: 'OKC_API.G_RET_STS_ERROR',

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

Line 136: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 137: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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

Line 140: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 145: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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