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.OKS_RENEW_UTIL_PUB dependencies on FND_API

Line 29: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN

25: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_chr_id=' || p_chr_id||' ,p_party_id='||p_party_id||' ,p_org_id='||p_org_id||' ,p_date='||p_date);
26: END IF;
27:
28: --standard api initilization and checks
29: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
30: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
31: END IF;
32: IF FND_API.to_boolean(p_init_msg_list ) THEN
33: FND_MSG_PUB.initialize;

Line 30: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

26: END IF;
27:
28: --standard api initilization and checks
29: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
30: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
31: END IF;
32: IF FND_API.to_boolean(p_init_msg_list ) THEN
33: FND_MSG_PUB.initialize;
34: END IF;

Line 32: IF FND_API.to_boolean(p_init_msg_list ) THEN

28: --standard api initilization and checks
29: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
30: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
31: END IF;
32: IF FND_API.to_boolean(p_init_msg_list ) THEN
33: FND_MSG_PUB.initialize;
34: END IF;
35: x_return_status := FND_API.G_RET_STS_SUCCESS;
36:

Line 35: x_return_status := FND_API.G_RET_STS_SUCCESS;

31: END IF;
32: IF FND_API.to_boolean(p_init_msg_list ) THEN
33: FND_MSG_PUB.initialize;
34: END IF;
35: x_return_status := FND_API.G_RET_STS_SUCCESS;
36:
37:
38: OKS_RENEW_UTIL_PVT.GET_RENEW_RULES(
39: p_api_version => 1,

Line 40: p_init_msg_list => FND_API.G_FALSE,

36:
37:
38: OKS_RENEW_UTIL_PVT.GET_RENEW_RULES(
39: p_api_version => 1,
40: p_init_msg_list => FND_API.G_FALSE,
41: p_chr_id => p_chr_id,
42: p_party_id => p_party_id,
43: p_org_id => p_org_id,
44: p_date => p_date,

Line 51: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

47: x_return_status => x_return_status,
48: x_msg_count => x_msg_count,
49: x_msg_data => x_msg_data );
50:
51: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
52: RAISE FND_API.g_exc_unexpected_error;
53: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
54: RAISE FND_API.g_exc_error;
55: END IF;

Line 52: RAISE FND_API.g_exc_unexpected_error;

48: x_msg_count => x_msg_count,
49: x_msg_data => x_msg_data );
50:
51: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
52: RAISE FND_API.g_exc_unexpected_error;
53: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
54: RAISE FND_API.g_exc_error;
55: END IF;
56:

Line 53: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

49: x_msg_data => x_msg_data );
50:
51: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
52: RAISE FND_API.g_exc_unexpected_error;
53: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
54: RAISE FND_API.g_exc_error;
55: END IF;
56:
57: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

Line 54: RAISE FND_API.g_exc_error;

50:
51: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
52: RAISE FND_API.g_exc_unexpected_error;
53: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
54: RAISE FND_API.g_exc_error;
55: END IF;
56:
57: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
58: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end','x_return_status='|| x_return_status);

Line 63: WHEN FND_API.g_exc_error THEN

59: END IF;
60: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
61:
62: EXCEPTION
63: WHEN FND_API.g_exc_error THEN
64: x_return_status := FND_API.g_ret_sts_error ;
65:
66: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
67: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);

Line 64: x_return_status := FND_API.g_ret_sts_error ;

60: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
61:
62: EXCEPTION
63: WHEN FND_API.g_exc_error THEN
64: x_return_status := FND_API.g_ret_sts_error ;
65:
66: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
67: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
68: END IF;

Line 71: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

67: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
68: END IF;
69: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
70:
71: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
73:
74: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
75: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);

Line 72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

68: END IF;
69: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
70:
71: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
73:
74: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
75: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
76: END IF;

Line 80: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

76: END IF;
77: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
78:
79: WHEN OTHERS THEN
80: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
81:
82: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
83: --first log the sqlerrm
84: l_error_text := substr (SQLERRM, 1, 240);

Line 325: p_chr_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

321:
322: PROCEDURE get_payment_terms (
323: p_api_version IN NUMBER,
324: p_init_msg_list IN VARCHAR2,
325: p_chr_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
326: p_party_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
327: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
328: p_effective_date IN DATE DEFAULT SYSDATE,
329: x_pay_term_id1 OUT NOCOPY VARCHAR2,

Line 326: p_party_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

322: PROCEDURE get_payment_terms (
323: p_api_version IN NUMBER,
324: p_init_msg_list IN VARCHAR2,
325: p_chr_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
326: p_party_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
327: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
328: p_effective_date IN DATE DEFAULT SYSDATE,
329: x_pay_term_id1 OUT NOCOPY VARCHAR2,
330: x_pay_term_id2 OUT NOCOPY VARCHAR2,

Line 327: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

323: p_api_version IN NUMBER,
324: p_init_msg_list IN VARCHAR2,
325: p_chr_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
326: p_party_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
327: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
328: p_effective_date IN DATE DEFAULT SYSDATE,
329: x_pay_term_id1 OUT NOCOPY VARCHAR2,
330: x_pay_term_id2 OUT NOCOPY VARCHAR2,
331: x_msg_count OUT NOCOPY NUMBER,

Line 462: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

458: END get_period_defaults;
459:
460: /* stripped down version of get_renew_rules, only gets the template set id and template lang */
461: PROCEDURE get_template_set(p_api_version IN NUMBER DEFAULT 1,
462: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
463: p_chr_id IN NUMBER,
464: x_template_set_id OUT NOCOPY NUMBER,
465: x_template_lang OUT NOCOPY VARCHAR2,
466: x_return_status OUT NOCOPY VARCHAR2,

Line 484: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN

480: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_chr_id=' || p_chr_id);
481: END IF;
482:
483: --standard api initilization and checks
484: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
486: END IF;
487: IF FND_API.to_boolean(p_init_msg_list ) THEN
488: FND_MSG_PUB.initialize;

Line 485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

481: END IF;
482:
483: --standard api initilization and checks
484: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
486: END IF;
487: IF FND_API.to_boolean(p_init_msg_list ) THEN
488: FND_MSG_PUB.initialize;
489: END IF;

Line 487: IF FND_API.to_boolean(p_init_msg_list ) THEN

483: --standard api initilization and checks
484: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
486: END IF;
487: IF FND_API.to_boolean(p_init_msg_list ) THEN
488: FND_MSG_PUB.initialize;
489: END IF;
490: x_return_status := FND_API.G_RET_STS_SUCCESS;
491:

Line 490: x_return_status := FND_API.G_RET_STS_SUCCESS;

486: END IF;
487: IF FND_API.to_boolean(p_init_msg_list ) THEN
488: FND_MSG_PUB.initialize;
489: END IF;
490: x_return_status := FND_API.G_RET_STS_SUCCESS;
491:
492: OKS_RENEW_UTIL_PVT.get_template_set(
493: p_api_version => 1,
494: p_init_msg_list => FND_API.G_FALSE,

Line 494: p_init_msg_list => FND_API.G_FALSE,

490: x_return_status := FND_API.G_RET_STS_SUCCESS;
491:
492: OKS_RENEW_UTIL_PVT.get_template_set(
493: p_api_version => 1,
494: p_init_msg_list => FND_API.G_FALSE,
495: p_chr_id => p_chr_id,
496: x_template_set_id => x_template_set_id,
497: x_template_lang => x_template_lang,
498: x_return_status => x_return_status,

Line 502: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

498: x_return_status => x_return_status,
499: x_msg_count => x_msg_count,
500: x_msg_data => x_msg_data);
501:
502: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
503: RAISE FND_API.g_exc_unexpected_error;
504: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
505: RAISE FND_API.g_exc_error;
506: END IF;

Line 503: RAISE FND_API.g_exc_unexpected_error;

499: x_msg_count => x_msg_count,
500: x_msg_data => x_msg_data);
501:
502: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
503: RAISE FND_API.g_exc_unexpected_error;
504: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
505: RAISE FND_API.g_exc_error;
506: END IF;
507:

Line 504: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

500: x_msg_data => x_msg_data);
501:
502: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
503: RAISE FND_API.g_exc_unexpected_error;
504: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
505: RAISE FND_API.g_exc_error;
506: END IF;
507:
508: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

Line 505: RAISE FND_API.g_exc_error;

501:
502: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
503: RAISE FND_API.g_exc_unexpected_error;
504: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
505: RAISE FND_API.g_exc_error;
506: END IF;
507:
508: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
509: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end','x_return_status='|| x_return_status);

Line 514: WHEN FND_API.g_exc_error THEN

510: END IF;
511: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
512:
513: EXCEPTION
514: WHEN FND_API.g_exc_error THEN
515: x_return_status := FND_API.g_ret_sts_error ;
516:
517: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
518: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);

Line 515: x_return_status := FND_API.g_ret_sts_error ;

511: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
512:
513: EXCEPTION
514: WHEN FND_API.g_exc_error THEN
515: x_return_status := FND_API.g_ret_sts_error ;
516:
517: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
518: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
519: END IF;

Line 522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

518: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
519: END IF;
520: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
521:
522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
524:
525: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
526: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);

Line 523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

519: END IF;
520: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
521:
522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
524:
525: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
526: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
527: END IF;

Line 531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

527: END IF;
528: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
529:
530: WHEN OTHERS THEN
531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
532:
533: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
534: --first log the sqlerrm
535: l_error_text := substr (SQLERRM, 1, 240);

Line 578: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

574: */
575: PROCEDURE GET_RENEWAL_TYPE
576: (
577: p_api_version IN NUMBER,
578: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
579: x_return_status OUT NOCOPY VARCHAR2,
580: x_msg_count OUT NOCOPY NUMBER,
581: x_msg_data OUT NOCOPY VARCHAR2,
582: p_chr_id IN NUMBER,

Line 604: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN

600: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_chr_id=' || p_chr_id);
601: END IF;
602:
603: --standard api initilization and checks
604: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
606: END IF;
607: IF FND_API.to_boolean(p_init_msg_list ) THEN
608: FND_MSG_PUB.initialize;

Line 605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

601: END IF;
602:
603: --standard api initilization and checks
604: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
606: END IF;
607: IF FND_API.to_boolean(p_init_msg_list ) THEN
608: FND_MSG_PUB.initialize;
609: END IF;

Line 607: IF FND_API.to_boolean(p_init_msg_list ) THEN

603: --standard api initilization and checks
604: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
606: END IF;
607: IF FND_API.to_boolean(p_init_msg_list ) THEN
608: FND_MSG_PUB.initialize;
609: END IF;
610: x_return_status := FND_API.G_RET_STS_SUCCESS;
611:

Line 610: x_return_status := FND_API.G_RET_STS_SUCCESS;

606: END IF;
607: IF FND_API.to_boolean(p_init_msg_list ) THEN
608: FND_MSG_PUB.initialize;
609: END IF;
610: x_return_status := FND_API.G_RET_STS_SUCCESS;
611:
612: OKS_RENEW_UTIL_PVT.get_renewal_type(
613: p_api_version => 1,
614: p_init_msg_list => FND_API.G_FALSE,

Line 614: p_init_msg_list => FND_API.G_FALSE,

610: x_return_status := FND_API.G_RET_STS_SUCCESS;
611:
612: OKS_RENEW_UTIL_PVT.get_renewal_type(
613: p_api_version => 1,
614: p_init_msg_list => FND_API.G_FALSE,
615: x_return_status => x_return_status,
616: x_msg_count => x_msg_count,
617: x_msg_data => x_msg_data,
618: p_chr_id => p_chr_id,

Line 626: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

622: x_renewal_type => x_renewal_type,
623: x_approval_type => x_approval_type,
624: x_threshold_used => x_threshold_used);
625:
626: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
627: RAISE FND_API.g_exc_unexpected_error;
628: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
629: RAISE FND_API.g_exc_error;
630: END IF;

Line 627: RAISE FND_API.g_exc_unexpected_error;

623: x_approval_type => x_approval_type,
624: x_threshold_used => x_threshold_used);
625:
626: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
627: RAISE FND_API.g_exc_unexpected_error;
628: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
629: RAISE FND_API.g_exc_error;
630: END IF;
631:

Line 628: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

624: x_threshold_used => x_threshold_used);
625:
626: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
627: RAISE FND_API.g_exc_unexpected_error;
628: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
629: RAISE FND_API.g_exc_error;
630: END IF;
631:
632: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

Line 629: RAISE FND_API.g_exc_error;

625:
626: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
627: RAISE FND_API.g_exc_unexpected_error;
628: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
629: RAISE FND_API.g_exc_error;
630: END IF;
631:
632: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
633: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end','x_return_status='|| x_return_status);

Line 638: WHEN FND_API.g_exc_error THEN

634: END IF;
635: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
636:
637: EXCEPTION
638: WHEN FND_API.g_exc_error THEN
639: x_return_status := FND_API.g_ret_sts_error ;
640:
641: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
642: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);

Line 639: x_return_status := FND_API.g_ret_sts_error ;

635: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
636:
637: EXCEPTION
638: WHEN FND_API.g_exc_error THEN
639: x_return_status := FND_API.g_ret_sts_error ;
640:
641: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
642: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
643: END IF;

Line 646: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

642: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
643: END IF;
644: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
645:
646: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
648:
649: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
650: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);

Line 647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

643: END IF;
644: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
645:
646: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
648:
649: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
650: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
651: END IF;

Line 655: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

651: END IF;
652: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
653:
654: WHEN OTHERS THEN
655: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
656:
657: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
658: --first log the sqlerrm
659: l_error_text := substr (SQLERRM, 1, 240);