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.OKL_POPULATE_PRCENG_RESULT_PVT dependencies on OKL_API

Line 115: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

111: p_sirv_rec IN sirv_rec_type,
112: x_sirv_rec OUT NOCOPY sirv_rec_type
113: ) IS
114: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_rets';
115: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
116:
117: BEGIN
118: OKL_SIF_RETS_PUB.insert_sif_rets(p_api_version => p_api_version,
119: p_init_msg_list => p_init_msg_list,

Line 126: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

122: x_msg_data => x_msg_data,
123: p_sirv_rec => p_sirv_rec,
124: x_sirv_rec => x_sirv_rec);
125:
126: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
127: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
128: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
129: RAISE OKL_API.G_EXCEPTION_ERROR;
130: END IF;

Line 127: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

123: p_sirv_rec => p_sirv_rec,
124: x_sirv_rec => x_sirv_rec);
125:
126: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
127: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
128: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
129: RAISE OKL_API.G_EXCEPTION_ERROR;
130: END IF;
131:

Line 128: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

124: x_sirv_rec => x_sirv_rec);
125:
126: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
127: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
128: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
129: RAISE OKL_API.G_EXCEPTION_ERROR;
130: END IF;
131:
132: x_return_status := l_return_status;

Line 129: RAISE OKL_API.G_EXCEPTION_ERROR;

125:
126: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
127: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
128: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
129: RAISE OKL_API.G_EXCEPTION_ERROR;
130: END IF;
131:
132: x_return_status := l_return_status;
133:

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

137: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
138: x_return_status := G_RET_STS_UNEXP_ERROR;
139: WHEN OTHERS THEN
140: -- store SQL error message on message stack for caller
141: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
142: p_msg_name => G_UNEXPECTED_ERROR,
143: p_token1 => G_SQLCODE_TOKEN,
144: p_token1_value => sqlcode,
145: p_token2 => G_SQLERRM_TOKEN,

Line 163: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

159: p_sirv_rec IN sirv_rec_type,
160: x_sirv_rec OUT NOCOPY sirv_rec_type
161: ) IS
162: l_api_name CONSTANT VARCHAR2(30) := 'update_sif_rets';
163: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
164: l_sirv_rec sirv_rec_type;
165: l_no_data_found BOOLEAN := FALSE;
166:
167: BEGIN

Line 295: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

291: x_msg_data => x_msg_data,
292: p_sirv_rec => l_sirv_rec,
293: x_sirv_rec => x_sirv_rec);
294:
295: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
296: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
297: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
298: RAISE OKL_API.G_EXCEPTION_ERROR;
299: END IF;

Line 296: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

292: p_sirv_rec => l_sirv_rec,
293: x_sirv_rec => x_sirv_rec);
294:
295: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
296: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
297: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
298: RAISE OKL_API.G_EXCEPTION_ERROR;
299: END IF;
300:

Line 297: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

293: x_sirv_rec => x_sirv_rec);
294:
295: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
296: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
297: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
298: RAISE OKL_API.G_EXCEPTION_ERROR;
299: END IF;
300:
301: x_return_status := l_return_status;

Line 298: RAISE OKL_API.G_EXCEPTION_ERROR;

294:
295: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
296: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
297: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
298: RAISE OKL_API.G_EXCEPTION_ERROR;
299: END IF;
300:
301: x_return_status := l_return_status;
302:

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

306: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
307: x_return_status := G_RET_STS_UNEXP_ERROR;
308: WHEN OTHERS THEN
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,

Line 334: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

330: p_srsv_rec IN srsv_rec_type,
331: x_srsv_rec OUT NOCOPY srsv_rec_type
332: ) IS
333: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_ret_strms';
334: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
335:
336: BEGIN
337: --dbms_output.PUT_LINE('populate_sif_ret_strms pvt');
338: --BAKUCHIB Bug#2807737 start

Line 350: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

346: x_srsv_rec => x_srsv_rec);
347: G_COUNTER := G_COUNTER + 1;
348: G_SRSV_TBL(G_COUNTER) := x_srsv_rec;
349: --BAKUCHIB Bug#2807737 end
350: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
351: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
352: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
353: RAISE OKL_API.G_EXCEPTION_ERROR;
354: END IF;

Line 351: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

347: G_COUNTER := G_COUNTER + 1;
348: G_SRSV_TBL(G_COUNTER) := x_srsv_rec;
349: --BAKUCHIB Bug#2807737 end
350: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
351: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
352: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
353: RAISE OKL_API.G_EXCEPTION_ERROR;
354: END IF;
355:

Line 352: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

348: G_SRSV_TBL(G_COUNTER) := x_srsv_rec;
349: --BAKUCHIB Bug#2807737 end
350: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
351: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
352: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
353: RAISE OKL_API.G_EXCEPTION_ERROR;
354: END IF;
355:
356: x_return_status := l_return_status;

Line 353: RAISE OKL_API.G_EXCEPTION_ERROR;

349: --BAKUCHIB Bug#2807737 end
350: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
351: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
352: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
353: RAISE OKL_API.G_EXCEPTION_ERROR;
354: END IF;
355:
356: x_return_status := l_return_status;
357:

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

361: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
362: x_return_status := G_RET_STS_UNEXP_ERROR;
363: WHEN OTHERS THEN
364: -- store SQL error message on message stack for caller
365: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
366: p_msg_name => G_UNEXPECTED_ERROR,
367: p_token1 => G_SQLCODE_TOKEN,
368: p_token1_value => sqlcode,
369: p_token2 => G_SQLERRM_TOKEN,

Line 390: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

386: p_srmv_rec IN srmv_rec_type,
387: x_srmv_rec OUT NOCOPY srmv_rec_type
388: ) IS
389: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_ret_errors';
390: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
391:
392: BEGIN
393: OKL_SIF_RET_ERRORS_PUB.insert_sif_ret_errors(p_api_version => p_api_version,
394: p_init_msg_list => p_init_msg_list,

Line 400: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

396: x_msg_count => x_msg_count,
397: x_msg_data => x_msg_data,
398: p_srmv_rec => p_srmv_rec,
399: x_srmv_rec => x_srmv_rec);
400: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
401: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
402: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
403: RAISE OKL_API.G_EXCEPTION_ERROR;
404: END IF;

Line 401: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

397: x_msg_data => x_msg_data,
398: p_srmv_rec => p_srmv_rec,
399: x_srmv_rec => x_srmv_rec);
400: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
401: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
402: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
403: RAISE OKL_API.G_EXCEPTION_ERROR;
404: END IF;
405:

Line 402: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

398: p_srmv_rec => p_srmv_rec,
399: x_srmv_rec => x_srmv_rec);
400: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
401: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
402: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
403: RAISE OKL_API.G_EXCEPTION_ERROR;
404: END IF;
405:
406: x_return_status := l_return_status;

Line 403: RAISE OKL_API.G_EXCEPTION_ERROR;

399: x_srmv_rec => x_srmv_rec);
400: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
401: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
402: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
403: RAISE OKL_API.G_EXCEPTION_ERROR;
404: END IF;
405:
406: x_return_status := l_return_status;
407:

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

411: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
412: x_return_status := G_RET_STS_UNEXP_ERROR;
413: WHEN OTHERS THEN
414: -- store SQL error message on message stack for caller
415: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
416: p_msg_name => G_UNEXPECTED_ERROR,
417: p_token1 => G_SQLCODE_TOKEN,
418: p_token1_value => sqlcode,
419: p_token2 => G_SQLERRM_TOKEN,

Line 440: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

436: x_msg_count OUT NOCOPY NUMBER,
437: x_msg_data OUT NOCOPY VARCHAR2
438: ) IS
439: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_ret_levels';
440: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
441:
442: BEGIN
443: OKL_SIF_RET_LEVELS_PUB.insert_sif_ret_levels(p_api_version => p_api_version,
444: p_init_msg_list => p_init_msg_list,

Line 450: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

446: x_msg_count => x_msg_count,
447: x_msg_data => x_msg_data,
448: p_srlv_rec => p_srlv_rec,
449: x_srlv_rec => x_srlv_rec);
450: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
451: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
452: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
453: RAISE OKL_API.G_EXCEPTION_ERROR;
454: END IF;

Line 451: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

447: x_msg_data => x_msg_data,
448: p_srlv_rec => p_srlv_rec,
449: x_srlv_rec => x_srlv_rec);
450: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
451: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
452: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
453: RAISE OKL_API.G_EXCEPTION_ERROR;
454: END IF;
455:

Line 452: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

448: p_srlv_rec => p_srlv_rec,
449: x_srlv_rec => x_srlv_rec);
450: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
451: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
452: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
453: RAISE OKL_API.G_EXCEPTION_ERROR;
454: END IF;
455:
456: x_return_status := l_return_status;

Line 453: RAISE OKL_API.G_EXCEPTION_ERROR;

449: x_srlv_rec => x_srlv_rec);
450: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
451: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
452: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
453: RAISE OKL_API.G_EXCEPTION_ERROR;
454: END IF;
455:
456: x_return_status := l_return_status;
457:

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

461: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
462: x_return_status := G_RET_STS_UNEXP_ERROR;
463: WHEN OTHERS THEN
464: -- store SQL error message on message stack for caller
465: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
466: p_msg_name => G_UNEXPECTED_ERROR,
467: p_token1 => G_SQLCODE_TOKEN,
468: p_token1_value => sqlcode,
469: p_token2 => G_SQLERRM_TOKEN,

Line 489: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

485: x_sifv_rec OUT NOCOPY sifv_rec_type,
486: x_msg_count OUT NOCOPY NUMBER,
487: x_msg_data OUT NOCOPY VARCHAR2,
488: x_return_status OUT NOCOPY VARCHAR2) IS
489: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
490: l_api_name CONSTANT VARCHAR2(30) := 'update_outbound_status';
491: BEGIN
492: --BAKUCHIB Bug#2807737 start
493: --Added by BKATRAGA.