DBA Data[Home] [Help]

APPS.OKC_CHG_REJ_ASMBLR_PVT dependencies on OKC_API

Line 41: l_return_status := OKC_API.START_ACTIVITY

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

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: l_corrid_rec.corrid := 'CH_REJECT' ;
53: -- check if action is enabled

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: l_corrid_rec.corrid := 'CH_REJECT' ;
53: -- check if action is enabled
54: IF OKC_K_SIGN_ASMBLR_PVT.isActionEnabled(l_corrid_rec.corrid) = 'Y' THEN

Line 117: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 118: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 119: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

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

Line 120: RAISE OKC_API.G_EXCEPTION_ERROR;

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

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

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

Line 126: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

Line 127: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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

Line 130: 'OKC_API.G_RET_STS_ERROR',

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

Line 134: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 135: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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

Line 138: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 143: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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