eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_DATE_ASSEMBLER_PUB dependencies on OKC_API

Line 15: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

11: retcode OUT NOCOPY VARCHAR2) IS
12:
13: l_api_name CONSTANT VARCHAR2(30) := 'conc_mgr';
14: l_api_version CONSTANT VARCHAR2(30) := 1.0;
15: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
16: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
17: l_msg_count NUMBER;
18: l_msg_data VARCHAR2(1000);
19: l_init_msg_list VARCHAR2(3) := 'F';

Line 16: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

12:
13: l_api_name CONSTANT VARCHAR2(30) := 'conc_mgr';
14: l_api_version CONSTANT VARCHAR2(30) := 1.0;
15: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
16: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
17: l_msg_count NUMBER;
18: l_msg_data VARCHAR2(1000);
19: l_init_msg_list VARCHAR2(3) := 'F';
20: E_Resource_Busy EXCEPTION;

Line 36: l_return_status := OKC_API.START_ACTIVITY(l_api_name

32: END IF;
33:
34: -- call start_activity to create savepoint, check comptability
35: -- and initialize message list
36: l_return_status := OKC_API.START_ACTIVITY(l_api_name
37: ,l_init_msg_list
38: ,'_PUBLIC'
39: ,x_return_status
40: );

Line 51: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

47: ,x_msg_count => l_msg_count
48: ,x_msg_data => l_msg_data);
49:
50:
51: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
52: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
53: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
54: RAISE OKC_API.G_EXCEPTION_ERROR;
55: END IF;

Line 52: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

48: ,x_msg_data => l_msg_data);
49:
50:
51: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
52: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
53: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
54: RAISE OKC_API.G_EXCEPTION_ERROR;
55: END IF;
56:

Line 53: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

49:
50:
51: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
52: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
53: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
54: RAISE OKC_API.G_EXCEPTION_ERROR;
55: END IF;
56:
57: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);

Line 54: RAISE OKC_API.G_EXCEPTION_ERROR;

50:
51: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
52: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
53: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
54: RAISE OKC_API.G_EXCEPTION_ERROR;
55: END IF;
56:
57: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);
58:

Line 57: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);

53: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
54: RAISE OKC_API.G_EXCEPTION_ERROR;
55: END IF;
56:
57: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);
58:
59: IF (l_debug = 'Y') THEN
60: okc_debug.Log('1000: Leaving ',2);
61: okc_debug.Reset_Indentation;

Line 66: l_return_status := okc_api.g_ret_sts_error;

62: END IF;
63:
64: EXCEPTION
65: WHEN E_Resource_Busy THEN
66: l_return_status := okc_api.g_ret_sts_error;
67: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
68: IF (l_debug = 'Y') THEN
69: okc_debug.Log('2000: Leaving ',2);
70: okc_debug.Reset_Indentation;

Line 72: WHEN OKC_API.G_EXCEPTION_ERROR THEN

68: IF (l_debug = 'Y') THEN
69: okc_debug.Log('2000: Leaving ',2);
70: okc_debug.Reset_Indentation;
71: END IF;
72: WHEN OKC_API.G_EXCEPTION_ERROR THEN
73: retcode := 2;
74: errbuf := substr(sqlerrm,1,200);
75: l_return_status := OKC_API.HANDLE_EXCEPTIONS
76: (l_api_name,

Line 75: l_return_status := OKC_API.HANDLE_EXCEPTIONS

71: END IF;
72: WHEN OKC_API.G_EXCEPTION_ERROR THEN
73: retcode := 2;
74: errbuf := substr(sqlerrm,1,200);
75: l_return_status := OKC_API.HANDLE_EXCEPTIONS
76: (l_api_name,
77: G_PKG_NAME,
78: 'OKC_API.G_RET_STS_ERROR',
79: l_msg_count,

Line 78: 'OKC_API.G_RET_STS_ERROR',

74: errbuf := substr(sqlerrm,1,200);
75: l_return_status := OKC_API.HANDLE_EXCEPTIONS
76: (l_api_name,
77: G_PKG_NAME,
78: 'OKC_API.G_RET_STS_ERROR',
79: l_msg_count,
80: l_msg_data,
81: '_PUBLIC');
82: IF (l_debug = 'Y') THEN

Line 86: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

82: IF (l_debug = 'Y') THEN
83: okc_debug.Log('3000: Leaving ',2);
84: okc_debug.Reset_Indentation;
85: END IF;
86: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
87: retcode := 2;
88: errbuf := substr(sqlerrm,1,200);
89: l_return_status := OKC_API.HANDLE_EXCEPTIONS
90: (l_api_name,

Line 89: l_return_status := OKC_API.HANDLE_EXCEPTIONS

85: END IF;
86: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
87: retcode := 2;
88: errbuf := substr(sqlerrm,1,200);
89: l_return_status := OKC_API.HANDLE_EXCEPTIONS
90: (l_api_name,
91: G_PKG_NAME,
92: 'OKC_API.G_RET_STS_UNEXP_ERROR',
93: l_msg_count,

Line 92: 'OKC_API.G_RET_STS_UNEXP_ERROR',

88: errbuf := substr(sqlerrm,1,200);
89: l_return_status := OKC_API.HANDLE_EXCEPTIONS
90: (l_api_name,
91: G_PKG_NAME,
92: 'OKC_API.G_RET_STS_UNEXP_ERROR',
93: l_msg_count,
94: l_msg_data,
95: '_PUBLIC');
96: IF (l_debug = 'Y') THEN

Line 103: l_return_status := OKC_API.HANDLE_EXCEPTIONS

99: END IF;
100: WHEN OTHERS THEN
101: retcode := 2;
102: errbuf := substr(sqlerrm,1,200);
103: l_return_status := OKC_API.HANDLE_EXCEPTIONS
104: (l_api_name,
105: G_PKG_NAME,
106: 'OTHERS',
107: l_msg_count,

Line 125: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

121: x_msg_data OUT NOCOPY VARCHAR2) IS
122:
123: l_api_name CONSTANT VARCHAR2(30) := 'date_assemble';
124: --l_api_version CONSTANT NUMBER := 1.0;
125: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
126: --l_msg_count NUMBER;
127: --l_msg_data VARCHAR2(1000);
128: l_cnhv_rec OKC_CNH_PVT.cnhv_rec_type;
129: i_cnhv_rec OKC_CNH_PVT.cnhv_rec_type;

Line 162: l_return_status := OKC_API.START_ACTIVITY(l_api_name

158: END IF;
159:
160: -- call start_activity to create savepoint, check comptability
161: -- and initialize message list
162: l_return_status := OKC_API.START_ACTIVITY(l_api_name
163: ,p_init_msg_list
164: ,'_PUBLIC'
165: ,x_return_status
166: );

Line 168: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

164: ,'_PUBLIC'
165: ,x_return_status
166: );
167: -- check if activity started successfully
168: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
169: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
170: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
171: RAISE OKC_API.G_EXCEPTION_ERROR;
172: END IF;

Line 169: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

165: ,x_return_status
166: );
167: -- check if activity started successfully
168: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
169: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
170: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
171: RAISE OKC_API.G_EXCEPTION_ERROR;
172: END IF;
173:

Line 170: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

166: );
167: -- check if activity started successfully
168: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
169: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
170: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
171: RAISE OKC_API.G_EXCEPTION_ERROR;
172: END IF;
173:
174: fnd_message.set_name('OKC','OKC_EXPIRY_DATE_CONTRACTS');

Line 171: RAISE OKC_API.G_EXCEPTION_ERROR;

167: -- check if activity started successfully
168: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
169: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
170: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
171: RAISE OKC_API.G_EXCEPTION_ERROR;
172: END IF;
173:
174: fnd_message.set_name('OKC','OKC_EXPIRY_DATE_CONTRACTS');
175: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 204: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

200: ,p_cnh_variance => acn_rec.cnh_variance
201: ,p_before_after => acn_rec.before_after
202: ,p_last_rundate => acn_rec.last_rundate);
203:
204: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
205: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
206: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
207: RAISE OKC_API.G_EXCEPTION_ERROR;
208: ELSIF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

Line 205: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

201: ,p_before_after => acn_rec.before_after
202: ,p_last_rundate => acn_rec.last_rundate);
203:
204: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
205: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
206: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
207: RAISE OKC_API.G_EXCEPTION_ERROR;
208: ELSIF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
209: l_cnhv_rec.id := acn_rec.id;

Line 206: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

202: ,p_last_rundate => acn_rec.last_rundate);
203:
204: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
205: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
206: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
207: RAISE OKC_API.G_EXCEPTION_ERROR;
208: ELSIF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
209: l_cnhv_rec.id := acn_rec.id;
210: l_cnhv_rec.last_rundate := sysdate;

Line 207: RAISE OKC_API.G_EXCEPTION_ERROR;

203:
204: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
205: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
206: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
207: RAISE OKC_API.G_EXCEPTION_ERROR;
208: ELSIF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
209: l_cnhv_rec.id := acn_rec.id;
210: l_cnhv_rec.last_rundate := sysdate;
211:

Line 208: ELSIF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

204: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
205: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
206: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
207: RAISE OKC_API.G_EXCEPTION_ERROR;
208: ELSIF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
209: l_cnhv_rec.id := acn_rec.id;
210: l_cnhv_rec.last_rundate := sysdate;
211:
212: --

Line 216: p_init_msg_list => okc_api.g_false,

212: --
213: -- Update the Last Run date for the picked condition
214: --
215: OKC_CONDITIONS_PUB.update_cond_hdrs(p_api_version => 1,
216: p_init_msg_list => okc_api.g_false,
217: x_return_status => l_return_status,
218: x_msg_count => x_msg_count,
219: x_msg_data => x_msg_data,
220: p_cnhv_rec => l_cnhv_rec,

Line 223: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

219: x_msg_data => x_msg_data,
220: p_cnhv_rec => l_cnhv_rec,
221: x_cnhv_rec => i_cnhv_rec);
222:
223: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
224: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
225: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
226: RAISE OKC_API.G_EXCEPTION_ERROR;
227: END IF; -- Update the Last Run date

Line 224: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

220: p_cnhv_rec => l_cnhv_rec,
221: x_cnhv_rec => i_cnhv_rec);
222:
223: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
224: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
225: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
226: RAISE OKC_API.G_EXCEPTION_ERROR;
227: END IF; -- Update the Last Run date
228:

Line 225: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

221: x_cnhv_rec => i_cnhv_rec);
222:
223: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
224: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
225: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
226: RAISE OKC_API.G_EXCEPTION_ERROR;
227: END IF; -- Update the Last Run date
228:
229: COMMIT;

Line 226: RAISE OKC_API.G_EXCEPTION_ERROR;

222:
223: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
224: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
225: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
226: RAISE OKC_API.G_EXCEPTION_ERROR;
227: END IF; -- Update the Last Run date
228:
229: COMMIT;
230:

Line 257: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

253: ,p_cnh_variance => acn_rec.cnh_variance
254: ,p_before_after => acn_rec.before_after
255: ,p_last_rundate => acn_rec.last_rundate);
256:
257: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
258: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
259: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
260: RAISE OKC_API.G_EXCEPTION_ERROR;
261: ELSIF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

Line 258: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

254: ,p_before_after => acn_rec.before_after
255: ,p_last_rundate => acn_rec.last_rundate);
256:
257: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
258: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
259: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
260: RAISE OKC_API.G_EXCEPTION_ERROR;
261: ELSIF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
262: l_cnhv_rec.id := acn_rec.id;

Line 259: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

255: ,p_last_rundate => acn_rec.last_rundate);
256:
257: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
258: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
259: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
260: RAISE OKC_API.G_EXCEPTION_ERROR;
261: ELSIF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
262: l_cnhv_rec.id := acn_rec.id;
263: l_cnhv_rec.last_rundate := sysdate;

Line 260: RAISE OKC_API.G_EXCEPTION_ERROR;

256:
257: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
258: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
259: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
260: RAISE OKC_API.G_EXCEPTION_ERROR;
261: ELSIF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
262: l_cnhv_rec.id := acn_rec.id;
263: l_cnhv_rec.last_rundate := sysdate;
264:

Line 261: ELSIF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

257: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
258: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
259: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
260: RAISE OKC_API.G_EXCEPTION_ERROR;
261: ELSIF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
262: l_cnhv_rec.id := acn_rec.id;
263: l_cnhv_rec.last_rundate := sysdate;
264:
265: --

Line 269: p_init_msg_list => okc_api.g_false,

265: --
266: -- Update the Last Run date for the picked condition
267: --
268: OKC_CONDITIONS_PUB.update_cond_hdrs(p_api_version => 1,
269: p_init_msg_list => okc_api.g_false,
270: x_return_status => l_return_status,
271: x_msg_count => x_msg_count,
272: x_msg_data => x_msg_data,
273: p_cnhv_rec => l_cnhv_rec,

Line 276: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

272: x_msg_data => x_msg_data,
273: p_cnhv_rec => l_cnhv_rec,
274: x_cnhv_rec => i_cnhv_rec);
275:
276: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
277: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
278: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
279: RAISE OKC_API.G_EXCEPTION_ERROR;
280: END IF; -- Update the Last Run date

Line 277: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

273: p_cnhv_rec => l_cnhv_rec,
274: x_cnhv_rec => i_cnhv_rec);
275:
276: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
277: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
278: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
279: RAISE OKC_API.G_EXCEPTION_ERROR;
280: END IF; -- Update the Last Run date
281: COMMIT;

Line 278: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

274: x_cnhv_rec => i_cnhv_rec);
275:
276: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
277: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
278: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
279: RAISE OKC_API.G_EXCEPTION_ERROR;
280: END IF; -- Update the Last Run date
281: COMMIT;
282:

Line 279: RAISE OKC_API.G_EXCEPTION_ERROR;

275:
276: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
277: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
278: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
279: RAISE OKC_API.G_EXCEPTION_ERROR;
280: END IF; -- Update the Last Run date
281: COMMIT;
282:
283: END IF; -- Call the date assembler for contract LINES expiry date

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

285: END IF; -- acn_rec.acn_type = 'DBA' and acn_rec.correlation = 'KEXPIRE'
286:
287: END LOOP;
288:
289: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
290:
291: IF (l_debug = 'Y') THEN
292: okc_debug.Log('1000: Leaving ',2);
293: okc_debug.Reset_Indentation;

Line 297: WHEN OKC_API.G_EXCEPTION_ERROR THEN

293: okc_debug.Reset_Indentation;
294: END IF;
295:
296: EXCEPTION
297: WHEN OKC_API.G_EXCEPTION_ERROR THEN
298: x_return_status := OKC_API.HANDLE_EXCEPTIONS
299: (l_api_name,
300: G_PKG_NAME,
301: 'OKC_API.G_RET_STS_ERROR',

Line 298: x_return_status := OKC_API.HANDLE_EXCEPTIONS

294: END IF;
295:
296: EXCEPTION
297: WHEN OKC_API.G_EXCEPTION_ERROR THEN
298: x_return_status := OKC_API.HANDLE_EXCEPTIONS
299: (l_api_name,
300: G_PKG_NAME,
301: 'OKC_API.G_RET_STS_ERROR',
302: x_msg_count,

Line 301: 'OKC_API.G_RET_STS_ERROR',

297: WHEN OKC_API.G_EXCEPTION_ERROR THEN
298: x_return_status := OKC_API.HANDLE_EXCEPTIONS
299: (l_api_name,
300: G_PKG_NAME,
301: 'OKC_API.G_RET_STS_ERROR',
302: x_msg_count,
303: x_msg_data,
304: '_PUBLIC');
305: IF (l_debug = 'Y') THEN

Line 309: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

305: IF (l_debug = 'Y') THEN
306: okc_debug.Log('2000: Leaving ',2);
307: okc_debug.Reset_Indentation;
308: END IF;
309: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
310: x_return_status := OKC_API.HANDLE_EXCEPTIONS
311: (l_api_name,
312: G_PKG_NAME,
313: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 310: x_return_status := OKC_API.HANDLE_EXCEPTIONS

306: okc_debug.Log('2000: Leaving ',2);
307: okc_debug.Reset_Indentation;
308: END IF;
309: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
310: x_return_status := OKC_API.HANDLE_EXCEPTIONS
311: (l_api_name,
312: G_PKG_NAME,
313: 'OKC_API.G_RET_STS_UNEXP_ERROR',
314: x_msg_count,

Line 313: 'OKC_API.G_RET_STS_UNEXP_ERROR',

309: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
310: x_return_status := OKC_API.HANDLE_EXCEPTIONS
311: (l_api_name,
312: G_PKG_NAME,
313: 'OKC_API.G_RET_STS_UNEXP_ERROR',
314: x_msg_count,
315: x_msg_data,
316: '_PUBLIC');
317: IF (l_debug = 'Y') THEN

Line 322: x_return_status := OKC_API.HANDLE_EXCEPTIONS

318: okc_debug.Log('3000: Leaving ',2);
319: okc_debug.Reset_Indentation;
320: END IF;
321: WHEN OTHERS THEN
322: x_return_status := OKC_API.HANDLE_EXCEPTIONS
323: (l_api_name,
324: G_PKG_NAME,
325: 'OTHERS',
326: x_msg_count,