APPS.OKL_GENERATE_STREAMS_PVT dependencies on OKL_API

Line 54: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

50:
51:
52: EXCEPTION
53: WHEN OTHERS THEN
54: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
55: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
56: END raise_business_event;
57:
58: --| : 10-08-04 GKADARKA -- Fixes for bug 3909261 -End |

Line 55: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

51:
52: EXCEPTION
53: WHEN OTHERS THEN
54: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
55: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
56: END raise_business_event;
57:
58: --| : 10-08-04 GKADARKA -- Fixes for bug 3909261 -End |
59:

Line 109: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

105:
106: --| : 10-08-04 GKADARKA -- Fixes for bug 3909261 -Start |
107:
108: raise_business_event(x_return_status => x_return_status);
109: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
110: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
111: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
112: RAISE OKL_API.G_EXCEPTION_ERROR;
113: END IF;

Line 110: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

106: --| : 10-08-04 GKADARKA -- Fixes for bug 3909261 -Start |
107:
108: raise_business_event(x_return_status => x_return_status);
109: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
110: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
111: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
112: RAISE OKL_API.G_EXCEPTION_ERROR;
113: END IF;
114:

Line 111: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

107:
108: raise_business_event(x_return_status => x_return_status);
109: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
110: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
111: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
112: RAISE OKL_API.G_EXCEPTION_ERROR;
113: END IF;
114:
115: --| : 10-08-04 GKADARKA -- Fixes for bug 3909261 -End |

Line 112: RAISE OKL_API.G_EXCEPTION_ERROR;

108: raise_business_event(x_return_status => x_return_status);
109: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
110: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
111: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
112: RAISE OKL_API.G_EXCEPTION_ERROR;
113: END IF;
114:
115: --| : 10-08-04 GKADARKA -- Fixes for bug 3909261 -End |
116: EXCEPTION

Line 120: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

116: EXCEPTION
117:
118: WHEN G_EXCEPTION_ERROR THEN
119: x_return_status := G_RET_STS_ERROR;
120: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
121: p_msg_name => G_UNEXPECTED_ERROR,
122: p_token1 => G_SQLCODE_TOKEN,
123: p_token1_value => SQLCODE,
124: p_token2 => G_SQLERRM_TOKEN,

Line 128: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

124: p_token2 => G_SQLERRM_TOKEN,
125: p_token2_value => SQLERRM );
126: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
127: x_return_status := G_RET_STS_UNEXP_ERROR;
128: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
129: p_msg_name => G_UNEXPECTED_ERROR,
130: p_token1 => G_SQLCODE_TOKEN,
131: p_token1_value => SQLCODE,
132: p_token2 => G_SQLERRM_TOKEN,

Line 136: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

132: p_token2 => G_SQLERRM_TOKEN,
133: p_token2_value => SQLERRM );
134: WHEN OTHERS THEN
135: x_return_status := G_RET_STS_UNEXP_ERROR;
136: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
137: p_msg_name => G_UNEXPECTED_ERROR,
138: p_token1 => G_SQLCODE_TOKEN,
139: p_token1_value => SQLCODE,
140: p_token2 => G_SQLERRM_TOKEN,

Line 205: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

201:
202: WHEN G_EXCEPTION_ERROR THEN
203: --dbms_output.put_line('gen stream pvt error' || sqlcode || sqlerrm);
204: x_return_status := G_RET_STS_ERROR;
205: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
206: p_msg_name => G_UNEXPECTED_ERROR,
207: p_token1 => G_SQLCODE_TOKEN,
208: p_token1_value => SQLCODE,
209: p_token2 => G_SQLERRM_TOKEN,

Line 214: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

210: p_token2_value => SQLERRM );
211: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
212: --dbms_output.put_line('gen stream pvt UU' || sqlcode || sqlerrm);
213: x_return_status := G_RET_STS_UNEXP_ERROR;
214: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
215: p_msg_name => G_UNEXPECTED_ERROR,
216: p_token1 => G_SQLCODE_TOKEN,
217: p_token1_value => SQLCODE,
218: p_token2 => G_SQLERRM_TOKEN,

Line 224: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

220: WHEN OTHERS THEN
221: --dbms_output.put_line('gen stream pvt OO' || sqlcode || sqlerrm);
222: x_return_status := G_RET_STS_UNEXP_ERROR;
223: -- store SQL error message on message stack for caller
224: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
225: p_msg_name => G_UNEXPECTED_ERROR,
226: p_token1 => G_SQLCODE_TOKEN,
227: p_token1_value => SQLCODE,
228: p_token2 => G_SQLERRM_TOKEN,

Line 293: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

289: EXCEPTION
290:
291: WHEN G_EXCEPTION_ERROR THEN
292: x_return_status := G_RET_STS_ERROR;
293: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
294: p_msg_name => G_UNEXPECTED_ERROR,
295: p_token1 => G_SQLCODE_TOKEN,
296: p_token1_value => SQLCODE,
297: p_token2 => G_SQLERRM_TOKEN,

Line 301: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

297: p_token2 => G_SQLERRM_TOKEN,
298: p_token2_value => SQLERRM );
299: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
300: x_return_status := G_RET_STS_UNEXP_ERROR;
301: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
302: p_msg_name => G_UNEXPECTED_ERROR,
303: p_token1 => G_SQLCODE_TOKEN,
304: p_token1_value => SQLCODE,
305: p_token2 => G_SQLERRM_TOKEN,

Line 310: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

306: p_token2_value => SQLERRM );
307: WHEN OTHERS THEN
308: x_return_status := G_RET_STS_UNEXP_ERROR;
309: -- store SQL error message on message stack for caller
310: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
311: p_msg_name => G_UNEXPECTED_ERROR,
312: p_token1 => G_SQLCODE_TOKEN,
313: p_token1_value => SQLCODE,
314: p_token2 => G_SQLERRM_TOKEN,