DBA Data[Home] [Help]

APPS.OZF_CLAIM_AGING_PVT dependencies on FND_MSG_PUB

Line 4: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

1: PACKAGE BODY OZF_Claim_Aging_PVT AS
2: /* $Header: ozfvcagb.pls 120.2.12010000.2 2010/02/22 05:10:26 hbandi ship $ */
3:
4: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
5:
6: --------------------------------------------------------------------------------
7: PROCEDURE insert_aging_dates(
8: p_bucket_id IN NUMBER,

Line 519: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

515:
516: -- check if atleast one bucket exists
517: IF l_bucket_lines_tbl.count = 0 THEN
518: -- raise error and log message
519: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
520: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_AGING_NO_BUCKET');
521: FND_MSG_PUB.add;
522: END IF;
523: RAISE FND_API.g_exc_error;

Line 521: FND_MSG_PUB.add;

517: IF l_bucket_lines_tbl.count = 0 THEN
518: -- raise error and log message
519: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
520: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_AGING_NO_BUCKET');
521: FND_MSG_PUB.add;
522: END IF;
523: RAISE FND_API.g_exc_error;
524: END IF;
525:

Line 592: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

588: FND_FILE.PUT_LINE(FND_FILE.LOG, 'return status#'||i||' ::' || l_return_status);
589:
590: IF l_return_status = FND_API.g_ret_sts_error THEN
591: -- raise error and log message
592: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
593: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_AGING_SUMMARY_ERR');
594: FND_MSG_PUB.add;
595: END IF;
596: RAISE FND_API.g_exc_error;

Line 594: FND_MSG_PUB.add;

590: IF l_return_status = FND_API.g_ret_sts_error THEN
591: -- raise error and log message
592: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
593: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_AGING_SUMMARY_ERR');
594: FND_MSG_PUB.add;
595: END IF;
596: RAISE FND_API.g_exc_error;
597: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
598: RAISE FND_API.g_exc_unexpected_error;

Line 611: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

607: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Total number of Bucket lines selected: ' || to_char(l_bucket_lines_tbl.count));
608:
609: IF l_return_status <> FND_API.g_ret_sts_success THEN
610: -- raise error and log message
611: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
612: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_AGING_POPULATE_ERR');
613: FND_MSG_PUB.add;
614: END IF;
615: RAISE FND_API.g_exc_error;

Line 613: FND_MSG_PUB.add;

609: IF l_return_status <> FND_API.g_ret_sts_success THEN
610: -- raise error and log message
611: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
612: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_AGING_POPULATE_ERR');
613: FND_MSG_PUB.add;
614: END IF;
615: RAISE FND_API.g_exc_error;
616: END IF;
617:

Line 630: FND_MSG_PUB.count_and_get (

626: EXCEPTION
627: WHEN FND_API.g_exc_error THEN
628: ROLLBACK TO Aging_Summary;
629: /*
630: FND_MSG_PUB.count_and_get (
631: p_encoded => FND_API.g_false
632: ,p_count => l_msg_count
633: ,p_data => l_msg_data
634: );

Line 638: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || FND_MSG_PUB.get(2, FND_API.g_false)||')');

634: );
635: */
636: OZF_UTILITY_PVT.write_conc_log;
637: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'FND_API.g_exc_error');
638: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || FND_MSG_PUB.get(2, FND_API.g_false)||')');
639: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
640: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
641:
642: ERRBUF := l_msg_data;

Line 647: FND_MSG_PUB.count_and_get (

643: RETCODE := 2;
644: WHEN FND_API.g_exc_unexpected_error THEN
645: ROLLBACK TO Aging_Summary;
646: /*
647: FND_MSG_PUB.count_and_get (
648: p_encoded => FND_API.g_false
649: ,p_count => l_msg_count
650: ,p_data => l_msg_data
651: );

Line 655: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || FND_MSG_PUB.get(2, FND_API.g_false)||')');

651: );
652: */
653: OZF_UTILITY_PVT.write_conc_log;
654: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'FND_API.g_exc_unexpected_error');
655: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || FND_MSG_PUB.get(2, FND_API.g_false)||')');
656: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
657: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
658: ERRBUF := l_msg_data;
659: RETCODE := 2;