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.OZF_NET_ACCRUAL_ENGINE_PVT dependencies on FND_MSG_PUB

Line 4: G_DEBUG_LOW BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);

1: PACKAGE BODY ozf_net_accrual_engine_pvt AS
2: /* $Header: ozfvnaeb.pls 120.11.12010000.3 2008/08/04 09:00:57 nirprasa ship $ */
3:
4: G_DEBUG_LOW BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
5: TYPE number_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
6:
7: FUNCTION validate_customer( p_invoice_to_org_id IN NUMBER,
8: p_ship_to_org_id IN NUMBER,

Line 383: FND_MSG_PUB.add;

379: x_return_status := FND_API.g_ret_sts_unexp_error;
380:
381: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PARTY_STMT_FAILED');
382: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
383: FND_MSG_PUB.add;
384:
385: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
386: THEN
387: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 385: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

381: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PARTY_STMT_FAILED');
382: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
383: FND_MSG_PUB.add;
384:
385: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
386: THEN
387: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
388: END IF;
389:

Line 387: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

383: FND_MSG_PUB.add;
384:
385: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
386: THEN
387: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
388: END IF;
389:
390: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
391: p_count => x_msg_count,

Line 390: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

386: THEN
387: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
388: END IF;
389:
390: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
391: p_count => x_msg_count,
392: p_data => x_msg_data);
393: END refresh_parties;
394:

Line 484: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

480:
481: ozf_utility_pvt.write_conc_log(l_stmt_debug);
482: ozf_utility_pvt.write_conc_log(SQLERRM);
483:
484: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
485: THEN
486: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
487: END IF;
488:

Line 486: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

482: ozf_utility_pvt.write_conc_log(SQLERRM);
483:
484: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
485: THEN
486: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
487: END IF;
488:
489: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
490: p_count => x_msg_count,

Line 489: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

485: THEN
486: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
487: END IF;
488:
489: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
490: p_count => x_msg_count,
491: p_data => x_msg_data);
492: END populate_customers;
493:

Line 699: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

695:
696: ozf_utility_pvt.write_conc_log(l_stmt_debug);
697: ozf_utility_pvt.write_conc_log(SQLERRM);
698:
699: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
700: THEN
701: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
702: END IF;
703:

Line 701: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

697: ozf_utility_pvt.write_conc_log(SQLERRM);
698:
699: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
700: THEN
701: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
702: END IF;
703:
704: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
705: p_count => x_msg_count,

Line 704: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

700: THEN
701: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
702: END IF;
703:
704: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
705: p_count => x_msg_count,
706: p_data => x_msg_data);
707: END populate_prod_line;
708:

Line 850: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

846:
847: ozf_utility_pvt.write_conc_log(l_stmt_debug);
848: ozf_utility_pvt.write_conc_log(SQLERRM);
849:
850: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
851: THEN
852: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
853: END IF;
854:

Line 852: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

848: ozf_utility_pvt.write_conc_log(SQLERRM);
849:
850: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
851: THEN
852: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
853: END IF;
854:
855: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
856: p_count => x_msg_count,

Line 855: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

851: THEN
852: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
853: END IF;
854:
855: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
856: p_count => x_msg_count,
857: p_data => x_msg_data);
858:
859: END populate_prod_tier;

Line 3496: Fnd_Msg_Pub.Count_AND_Get(p_count => l_msg_count,

3492:
3493: ozf_utility_pvt.write_conc_log('-- Done -- ' || to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));
3494:
3495:
3496: Fnd_Msg_Pub.Count_AND_Get(p_count => l_msg_count,
3497: p_data => l_msg_data,
3498: p_encoded => Fnd_Api.G_FALSE);
3499:
3500: EXCEPTION

Line 3508: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

3504:
3505: WHEN FND_API.G_EXC_ERROR THEN
3506: ROLLBACK TO net_accrual_engine;
3507: -- Standard call to get message count and if count=1, get the message
3508: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
3509: p_count => l_msg_count,
3510: p_data => l_msg_data);
3511:
3512: ERRBUF := l_msg_data;

Line 3518: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

3514:
3515: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3516: ROLLBACK TO net_accrual_engine;
3517: -- Standard call to get message count and if count=1, get the message
3518: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
3519: p_count => l_msg_count,
3520: p_data => l_msg_data);
3521:
3522: ERRBUF := l_msg_data;

Line 3528: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

3524:
3525: WHEN OTHERS THEN
3526: ROLLBACK TO net_accrual_engine;
3527: -- Standard call to get message count and if count=1, get the message
3528: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
3529: p_count => l_msg_count,
3530: p_data => l_msg_data);
3531: --ERRBUF := l_msg_data;
3532: ERRBUF := SQLERRM;

Line 3587: Fnd_Msg_Pub.initialize;

3583:
3584: SAVEPOINT retroactive_offer_adj;
3585:
3586: IF Fnd_Api.to_boolean(p_init_msg_list) THEN
3587: Fnd_Msg_Pub.initialize;
3588: END IF;
3589:
3590: x_return_status := Fnd_Api.g_ret_sts_success;
3591:

Line 3616: Fnd_Msg_Pub.Count_AND_Get

3612: EXCEPTION
3613: WHEN Fnd_Api.G_EXC_ERROR THEN
3614: x_return_status := Fnd_Api.g_ret_sts_error;
3615: ROLLBACK TO retroactive_offer_adj;
3616: Fnd_Msg_Pub.Count_AND_Get
3617: ( p_count => x_msg_count,
3618: p_data => x_msg_data,
3619: p_encoded => Fnd_Api.G_FALSE
3620: );

Line 3624: Fnd_Msg_Pub.Count_AND_Get

3620: );
3621: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
3622: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
3623: ROLLBACK TO retroactive_offer_adj;
3624: Fnd_Msg_Pub.Count_AND_Get
3625: ( p_count => x_msg_count,
3626: p_data => x_msg_data,
3627: p_encoded => Fnd_Api.G_FALSE
3628: );

Line 3632: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN

3628: );
3629: WHEN OTHERS THEN
3630: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
3631: ROLLBACK TO retroactive_offer_adj;
3632: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
3633: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3634: END IF;
3635: Fnd_Msg_Pub.Count_AND_Get
3636: ( p_count => x_msg_count,

Line 3633: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

3629: WHEN OTHERS THEN
3630: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
3631: ROLLBACK TO retroactive_offer_adj;
3632: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
3633: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3634: END IF;
3635: Fnd_Msg_Pub.Count_AND_Get
3636: ( p_count => x_msg_count,
3637: p_data => x_msg_data,

Line 3635: Fnd_Msg_Pub.Count_AND_Get

3631: ROLLBACK TO retroactive_offer_adj;
3632: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
3633: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3634: END IF;
3635: Fnd_Msg_Pub.Count_AND_Get
3636: ( p_count => x_msg_count,
3637: p_data => x_msg_data,
3638: p_encoded => Fnd_Api.G_FALSE
3639: );

Line 3702: Fnd_Msg_Pub.initialize;

3698: BEGIN
3699: SAVEPOINT offer_adj_new_product;
3700:
3701: IF Fnd_Api.to_boolean(p_init_msg_list) THEN
3702: Fnd_Msg_Pub.initialize;
3703: END IF;
3704:
3705: x_return_status := Fnd_Api.g_ret_sts_success;
3706:

Line 3765: Fnd_Msg_Pub.Count_AND_Get

3761: EXCEPTION
3762: WHEN Fnd_Api.G_EXC_ERROR THEN
3763: x_return_status := Fnd_Api.g_ret_sts_error;
3764: ROLLBACK TO offer_adj_new_product;
3765: Fnd_Msg_Pub.Count_AND_Get
3766: ( p_count => x_msg_count,
3767: p_data => x_msg_data,
3768: p_encoded => Fnd_Api.G_FALSE
3769: );

Line 3773: Fnd_Msg_Pub.Count_AND_Get

3769: );
3770: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
3771: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
3772: ROLLBACK TO offer_adj_new_product;
3773: Fnd_Msg_Pub.Count_AND_Get
3774: ( p_count => x_msg_count,
3775: p_data => x_msg_data,
3776: p_encoded => Fnd_Api.G_FALSE
3777: );

Line 3781: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN

3777: );
3778: WHEN OTHERS THEN
3779: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
3780: ROLLBACK TO offer_adj_new_product;
3781: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
3782: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3783: END IF;
3784: Fnd_Msg_Pub.Count_AND_Get
3785: ( p_count => x_msg_count,

Line 3782: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

3778: WHEN OTHERS THEN
3779: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
3780: ROLLBACK TO offer_adj_new_product;
3781: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
3782: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3783: END IF;
3784: Fnd_Msg_Pub.Count_AND_Get
3785: ( p_count => x_msg_count,
3786: p_data => x_msg_data,

Line 3784: Fnd_Msg_Pub.Count_AND_Get

3780: ROLLBACK TO offer_adj_new_product;
3781: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
3782: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3783: END IF;
3784: Fnd_Msg_Pub.Count_AND_Get
3785: ( p_count => x_msg_count,
3786: p_data => x_msg_data,
3787: p_encoded => Fnd_Api.G_FALSE
3788: );