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 2006/04/11 08:53:13 kdhulipa 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 517: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

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

Line 519: FND_MSG_PUB.add;

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

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

579: FND_FILE.PUT_LINE(FND_FILE.LOG, 'return status#'||i||' ::' || l_return_status);
580:
581: IF l_return_status = FND_API.g_ret_sts_error THEN
582: -- raise error and log message
583: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
584: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_AGING_SUMMARY_ERR');
585: FND_MSG_PUB.add;
586: END IF;
587: RAISE FND_API.g_exc_error;

Line 585: FND_MSG_PUB.add;

581: IF l_return_status = FND_API.g_ret_sts_error THEN
582: -- raise error and log message
583: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
584: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_AGING_SUMMARY_ERR');
585: FND_MSG_PUB.add;
586: END IF;
587: RAISE FND_API.g_exc_error;
588: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
589: RAISE FND_API.g_exc_unexpected_error;

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

598: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Total number of Bucket lines selected: ' || to_char(l_bucket_lines_tbl.count));
599:
600: IF l_return_status <> FND_API.g_ret_sts_success THEN
601: -- raise error and log message
602: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
603: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_AGING_POPULATE_ERR');
604: FND_MSG_PUB.add;
605: END IF;
606: RAISE FND_API.g_exc_error;

Line 604: FND_MSG_PUB.add;

600: IF l_return_status <> FND_API.g_ret_sts_success THEN
601: -- raise error and log message
602: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
603: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_AGING_POPULATE_ERR');
604: FND_MSG_PUB.add;
605: END IF;
606: RAISE FND_API.g_exc_error;
607: END IF;
608:

Line 621: FND_MSG_PUB.count_and_get (

617: EXCEPTION
618: WHEN FND_API.g_exc_error THEN
619: ROLLBACK TO Aging_Summary;
620: /*
621: FND_MSG_PUB.count_and_get (
622: p_encoded => FND_API.g_false
623: ,p_count => l_msg_count
624: ,p_data => l_msg_data
625: );

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

625: );
626: */
627: OZF_UTILITY_PVT.write_conc_log;
628: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'FND_API.g_exc_error');
629: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || FND_MSG_PUB.get(2, FND_API.g_false)||')');
630: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
631: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
632:
633: ERRBUF := l_msg_data;

Line 638: FND_MSG_PUB.count_and_get (

634: RETCODE := 2;
635: WHEN FND_API.g_exc_unexpected_error THEN
636: ROLLBACK TO Aging_Summary;
637: /*
638: FND_MSG_PUB.count_and_get (
639: p_encoded => FND_API.g_false
640: ,p_count => l_msg_count
641: ,p_data => l_msg_data
642: );

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

642: );
643: */
644: OZF_UTILITY_PVT.write_conc_log;
645: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'FND_API.g_exc_unexpected_error');
646: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || FND_MSG_PUB.get(2, FND_API.g_false)||')');
647: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
648: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
649: ERRBUF := l_msg_data;
650: RETCODE := 2;