DBA Data[Home] [Help]

APPS.OKC_K_TERM_ASMBLR_PVT dependencies on OKC_API

Line 41: l_return_status := OKC_API.START_ACTIVITY

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

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

Line 121: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 122: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 123: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

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

Line 124: RAISE OKC_API.G_EXCEPTION_ERROR;

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

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

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

Line 130: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

Line 131: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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

Line 134: 'OKC_API.G_RET_STS_ERROR',

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

Line 138: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 139: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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

Line 142: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 147: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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