APPS.OKC_ASYNC_PUB dependencies on OKC_API

Line 94: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),

90: okc_debug.Set_Indentation(l_proc);
91: okc_debug.Log('10: Entering ',2);
92: END IF;
93:
94: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
95: 'OKC_ASYNC_PUB',
96: OKC_API.G_TRUE,
97: p_api_version,
98: p_api_version,

Line 96: OKC_API.G_TRUE,

92: END IF;
93:
94: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
95: 'OKC_ASYNC_PUB',
96: OKC_API.G_TRUE,
97: p_api_version,
98: p_api_version,
99: 'PUB',
100: x_return_status);

Line 101: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

97: p_api_version,
98: p_api_version,
99: 'PUB',
100: x_return_status);
101: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
102: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
103: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
104: RAISE OKC_API.G_EXCEPTION_ERROR;
105: END IF;

Line 102: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

98: p_api_version,
99: 'PUB',
100: x_return_status);
101: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
102: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
103: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
104: RAISE OKC_API.G_EXCEPTION_ERROR;
105: END IF;
106: l_wf_name := OKC_ASYNC_PVT.G_WF_NAME;

Line 103: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

99: 'PUB',
100: x_return_status);
101: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
102: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
103: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
104: RAISE OKC_API.G_EXCEPTION_ERROR;
105: END IF;
106: l_wf_name := OKC_ASYNC_PVT.G_WF_NAME;
107: open wf_active;

Line 104: RAISE OKC_API.G_EXCEPTION_ERROR;

100: x_return_status);
101: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
102: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
103: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
104: RAISE OKC_API.G_EXCEPTION_ERROR;
105: END IF;
106: l_wf_name := OKC_ASYNC_PVT.G_WF_NAME;
107: open wf_active;
108: fetch wf_active into l_end_date;

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

130: itemkey => p_key_to_stop,
131: aname => 'P_STOP_DATE',
132: avalue => trunc(p_stop_date) );
133: end if;
134: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
135:
136: IF (l_debug = 'Y') THEN
137: okc_debug.Log('1000: Leaving ',2);
138: okc_debug.Reset_Indentation;

Line 142: WHEN OKC_API.G_EXCEPTION_ERROR THEN

138: okc_debug.Reset_Indentation;
139: END IF;
140:
141: EXCEPTION
142: WHEN OKC_API.G_EXCEPTION_ERROR THEN
143: x_return_status := OKC_API.HANDLE_EXCEPTIONS
144: (substr(l_api_name,1,26),
145: 'OKC_ASYNC_PUB',
146: 'OKC_API.G_RET_STS_ERROR',

Line 143: x_return_status := OKC_API.HANDLE_EXCEPTIONS

139: END IF;
140:
141: EXCEPTION
142: WHEN OKC_API.G_EXCEPTION_ERROR THEN
143: x_return_status := OKC_API.HANDLE_EXCEPTIONS
144: (substr(l_api_name,1,26),
145: 'OKC_ASYNC_PUB',
146: 'OKC_API.G_RET_STS_ERROR',
147: x_msg_count,

Line 146: 'OKC_API.G_RET_STS_ERROR',

142: WHEN OKC_API.G_EXCEPTION_ERROR THEN
143: x_return_status := OKC_API.HANDLE_EXCEPTIONS
144: (substr(l_api_name,1,26),
145: 'OKC_ASYNC_PUB',
146: 'OKC_API.G_RET_STS_ERROR',
147: x_msg_count,
148: x_msg_data,
149: 'PUB');
150: IF (l_debug = 'Y') THEN

Line 154: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

150: IF (l_debug = 'Y') THEN
151: okc_debug.Log('2000: Leaving ',2);
152: okc_debug.Reset_Indentation;
153: END IF;
154: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
155: x_return_status := OKC_API.HANDLE_EXCEPTIONS
156: (substr(l_api_name,1,26),
157: 'OKC_ASYNC_PUB',
158: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 155: x_return_status := OKC_API.HANDLE_EXCEPTIONS

151: okc_debug.Log('2000: Leaving ',2);
152: okc_debug.Reset_Indentation;
153: END IF;
154: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
155: x_return_status := OKC_API.HANDLE_EXCEPTIONS
156: (substr(l_api_name,1,26),
157: 'OKC_ASYNC_PUB',
158: 'OKC_API.G_RET_STS_UNEXP_ERROR',
159: x_msg_count,

Line 158: 'OKC_API.G_RET_STS_UNEXP_ERROR',

154: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
155: x_return_status := OKC_API.HANDLE_EXCEPTIONS
156: (substr(l_api_name,1,26),
157: 'OKC_ASYNC_PUB',
158: 'OKC_API.G_RET_STS_UNEXP_ERROR',
159: x_msg_count,
160: x_msg_data,
161: 'PUB');
162: IF (l_debug = 'Y') THEN

Line 167: x_return_status := OKC_API.HANDLE_EXCEPTIONS

163: okc_debug.Log('3000: Leaving ',2);
164: okc_debug.Reset_Indentation;
165: END IF;
166: WHEN OTHERS THEN
167: x_return_status := OKC_API.HANDLE_EXCEPTIONS
168: (substr(l_api_name,1,26),
169: 'OKC_ASYNC_PUB',
170: 'OTHERS',
171: x_msg_count,