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

Line 33: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

29: BEGIN
30:
31: -- Conversion type cannot be null in profile
32: IF l_conversion_type IS NULL THEN
33: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
34: fnd_message.set_name('OZF', 'OZF_NO_EXCHANGE_TYPE');
35: fnd_msg_pub.add;
36: END IF;
37: RETURN 0;

Line 35: fnd_msg_pub.add;

31: -- Conversion type cannot be null in profile
32: IF l_conversion_type IS NULL THEN
33: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
34: fnd_message.set_name('OZF', 'OZF_NO_EXCHANGE_TYPE');
35: fnd_msg_pub.add;
36: END IF;
37: RETURN 0;
38: END IF;
39:

Line 56: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

52: ,x_rate => l_rate);
53: RETURN (l_to_amount);
54: EXCEPTION
55: WHEN gl_currency_api.no_rate THEN
56: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
57: fnd_message.set_name('OZF', 'OZF_NO_RATE');
58: fnd_msg_pub.add;
59: END IF;
60: RETURN 0;

Line 58: fnd_msg_pub.add;

54: EXCEPTION
55: WHEN gl_currency_api.no_rate THEN
56: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
57: fnd_message.set_name('OZF', 'OZF_NO_RATE');
58: fnd_msg_pub.add;
59: END IF;
60: RETURN 0;
61: WHEN gl_currency_api.invalid_currency THEN
62: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

Line 62: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

58: fnd_msg_pub.add;
59: END IF;
60: RETURN 0;
61: WHEN gl_currency_api.invalid_currency THEN
62: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
63: fnd_message.set_name('OZF', 'OZF_INVALID_CURR');
64: fnd_msg_pub.add;
65: END IF;
66: RETURN 0;

Line 64: fnd_msg_pub.add;

60: RETURN 0;
61: WHEN gl_currency_api.invalid_currency THEN
62: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
63: fnd_message.set_name('OZF', 'OZF_INVALID_CURR');
64: fnd_msg_pub.add;
65: END IF;
66: RETURN 0;
67: WHEN OTHERS THEN
68: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 68: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

64: fnd_msg_pub.add;
65: END IF;
66: RETURN 0;
67: WHEN OTHERS THEN
68: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
69: fnd_msg_pub.add_exc_msg('OZF_UTLITY_PVT', 'Convert_curency');
70: END IF;
71: RETURN 0;
72: END convert_currency;

Line 69: fnd_msg_pub.add_exc_msg('OZF_UTLITY_PVT', 'Convert_curency');

65: END IF;
66: RETURN 0;
67: WHEN OTHERS THEN
68: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
69: fnd_msg_pub.add_exc_msg('OZF_UTLITY_PVT', 'Convert_curency');
70: END IF;
71: RETURN 0;
72: END convert_currency;
73:

Line 303: --FND_MSG_PUB.Add;

299: --dbms_output.put_line('error updateing balance'||sqlerrm(sqlcode));
300: --x_return_status := FND_API.G_RET_STS_ERROR;
301: --FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
302: --FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
303: --FND_MSG_PUB.Add;
304: END update_balance;
305:
306: ---------------------------------------------------------------------
307: -- PROCEDURE

Line 638: FND_MSG_PUB.initialize;

634:
635: -- Initialize message list IF p_init_msg_list IS set to TRUE.
636: IF FND_API.to_Boolean( p_init_msg_list )
637: THEN
638: FND_MSG_PUB.initialize;
639: END IF;
640:
641: -- Debug Message
642: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 742: FND_msg_PUB.Count_And_Get

738: COMMIT WORK;
739: END IF;
740:
741: -- Standard call to get message count and IF count IS 1, get message info.
742: FND_msg_PUB.Count_And_Get
743: (p_count => x_msg_count,
744: p_data => x_msg_data
745: );
746: fnd_message.set_name('BIM','BIM_R_END_FACTS');

Line 753: FND_msg_PUB.Count_And_Get (

749: EXCEPTION
750: WHEN FND_API.G_EXC_ERROR THEN
751: x_return_status := FND_API.G_RET_STS_ERROR;
752: -- Standard call to get message count and IF count=1, get the message
753: FND_msg_PUB.Count_And_Get (
754: -- p_encoded => FND_API.G_FALSE,
755: p_count => x_msg_count,
756: p_data => x_msg_data );
757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 760: FND_msg_PUB.Count_And_Get (

756: p_data => x_msg_data );
757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
759: -- Standard call to get message count and IF count=1, get the message
760: FND_msg_PUB.Count_And_Get (
761: --p_encoded => FND_API.G_FALSE,
762: p_count => x_msg_count,
763: p_data => x_msg_data
764: );

Line 768: IF FND_msg_PUB.Check_msg_Level ( FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)

764: );
765:
766: WHEN OTHERS THEN
767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
768: IF FND_msg_PUB.Check_msg_Level ( FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
769: THEN
770: FND_msg_PUB.Add_Exc_msg( G_PKG_NAME,l_api_name);
771: END IF;
772: -- Standard call to get message count and IF count=1, get the message

Line 770: FND_msg_PUB.Add_Exc_msg( G_PKG_NAME,l_api_name);

766: WHEN OTHERS THEN
767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
768: IF FND_msg_PUB.Check_msg_Level ( FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
769: THEN
770: FND_msg_PUB.Add_Exc_msg( G_PKG_NAME,l_api_name);
771: END IF;
772: -- Standard call to get message count and IF count=1, get the message
773: FND_msg_PUB.Count_And_Get (
774: -- p_encoded => FND_API.G_FALSE,

Line 773: FND_msg_PUB.Count_And_Get (

769: THEN
770: FND_msg_PUB.Add_Exc_msg( G_PKG_NAME,l_api_name);
771: END IF;
772: -- Standard call to get message count and IF count=1, get the message
773: FND_msg_PUB.Count_And_Get (
774: -- p_encoded => FND_API.G_FALSE,
775: p_count => x_msg_count,
776: p_data => x_msg_data
777: );

Line 822: FND_MSG_PUB.Add;

818: WHEN OTHERS THEN
819: x_return_status := FND_API.G_RET_STS_ERROR;
820: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
821: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
822: FND_MSG_PUB.Add;
823: fnd_file.put_line(fnd_file.log,fnd_message.get);
824: END LOG_HISTORY;
825:
826: ---------------------------------------------------------------------

Line 1302: FND_MSG_PUB.Add;

1298: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_daily_facts_s CACHE 20';
1299: x_return_status := FND_API.G_RET_STS_ERROR;
1300: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
1301: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
1302: FND_MSG_PUB.Add;
1303: fnd_file.put_line(fnd_file.log,fnd_message.get);
1304: END;
1305:
1306: /*Second insert: more records which transact before active date */

Line 1538: FND_MSG_PUB.Add;

1534: --dbms_output.put_line('error looping inserting INTO bim_r_fund_daily_facts'||sqlerrm(sqlcode));
1535: x_return_status := FND_API.G_RET_STS_ERROR;
1536: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
1537: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
1538: FND_MSG_PUB.Add;
1539: END;
1540: /* Start inserting into 'bim_r_fdsp_daily_facts' */
1541: l_table_name :='bim_r_fdsp_daily_facts';
1542: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');

Line 1684: FND_MSG_PUB.Add;

1680: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_daily_facts_s CACHE 20';
1681: x_return_status := FND_API.G_RET_STS_ERROR;
1682: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
1683: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
1684: FND_MSG_PUB.Add;
1685: END ; --end of insertion into bim_r_fdsp_load.
1686:
1687: -- dbms_output.put_line('inside fist inserting into fdsp daily');
1688: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');

Line 1888: FND_MSG_PUB.Add;

1884: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_daily_facts_s CACHE 20';
1885: x_return_status := FND_API.G_RET_STS_ERROR;
1886: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
1887: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
1888: FND_MSG_PUB.Add;
1889: END ;
1890:
1891: /* Second insert: extra records which happened before start date active */
1892: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');

Line 2081: FND_MSG_PUB.Add;

2077: --dbms_output.put_line('error inserting extra INTO bim_r_fdsp_daily_facts'||sqlerrm(sqlcode));
2078: x_return_status := FND_API.G_RET_STS_ERROR;
2079: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
2080: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
2081: FND_MSG_PUB.Add;
2082: END;
2083: -- dbms_output.put_line('l_count'||l_count);
2084: fnd_message.set_name('BIM','BIM_R_CALL_PROC');
2085: fnd_message.set_token('proc_name', 'LOG_HISTORY', FALSE);

Line 2206: FND_MSG_PUB.Add;

2202: -- dbms_output.put_line('error insert fund_daily for balancing with fdsp'||sqlerrm(sqlcode));
2203: x_return_status := FND_API.G_RET_STS_ERROR;
2204: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
2205: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
2206: FND_MSG_PUB.Add;
2207: fnd_file.put_line(fnd_file.log,fnd_message.get);
2208: END;
2209: /* Start of inserting into 'bim_r_fund_weekly_facts'.
2210: Weekly table are summarized on daily tables. */

Line 2334: FND_MSG_PUB.Add;

2330: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_weekly_facts_s CACHE 20';
2331: x_return_status := FND_API.G_RET_STS_ERROR;
2332: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
2333: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
2334: FND_MSG_PUB.Add;
2335: END;
2336: /* Insert into bim_r_fdsp_weekly_facts. */
2337: BEGIN
2338: l_table_name :='bim_r_fdsp_weekly_facts';

Line 2423: FND_MSG_PUB.Add;

2419: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_weekly_facts_s CACHE 20';
2420: x_return_status := FND_API.G_RET_STS_ERROR;
2421: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
2422: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
2423: FND_MSG_PUB.Add;
2424: END;
2425:
2426: fnd_message.set_name('BIM','BIM_R_RECREATE_INDEXES');
2427: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 2804: FND_MSG_PUB.Add;

2800: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_daily_facts_s CACHE 20';
2801: x_return_status := FND_API.G_RET_STS_ERROR;
2802: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
2803: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
2804: FND_MSG_PUB.Add;
2805: END;
2806:
2807: /*Second insert: For funds whose active date is between p_start_date and p_end_date, insert
2808: transactions happened before active date */

Line 3039: FND_MSG_PUB.Add;

3035: --dbms_output.put_line('error looping inserting INTO bim_r_fund_daily_facts'||sqlerrm(sqlcode));
3036: x_return_status := FND_API.G_RET_STS_ERROR;
3037: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
3038: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
3039: FND_MSG_PUB.Add;
3040: END;
3041:
3042: /* insert dummy 0s for dates between p_start_date/start_date_active and p_end_date/end_date_active,
3043: but has no transactions.*/

Line 3161: FND_MSG_PUB.Add;

3157: --dbms_output.put_line('error insert into fund_daily for missing date'||sqlerrm(sqlcode));
3158: x_return_status := FND_API.G_RET_STS_ERROR;
3159: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
3160: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
3161: FND_MSG_PUB.Add;
3162: END;
3163:
3164: /* insert dummy 0s for funds created between p_start_datel and p_end_datel,
3165: and in those dates between p_start_date/start_date_active and p_end_date/end_date_active,

Line 3289: FND_MSG_PUB.Add;

3285: --dbms_output.put_line('error insert into fund_daily for missing date 2'||sqlerrm(sqlcode));
3286: x_return_status := FND_API.G_RET_STS_ERROR;
3287: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
3288: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
3289: FND_MSG_PUB.Add;
3290: END;
3291:
3292: /* Inserting into 'bim_r_fdsp_load' all the objects information */
3293: l_table_name :='bim_r_fdsp_daily_facts';

Line 3434: FND_MSG_PUB.Add;

3430: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_daily_facts_s CACHE 20';
3431: x_return_status := FND_API.G_RET_STS_ERROR;
3432: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
3433: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
3434: FND_MSG_PUB.Add;
3435: END ; --end of insertion into bim_r_fdsp_load.
3436:
3437: --dbms_output.put_line('inside fist inserting into fdsp daily');
3438: /* First insert:Insert into 'bim_r_fdsp_daily_facts' the transactions happend between

Line 3631: FND_MSG_PUB.Add;

3627: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_daily_facts_s CACHE 20';
3628: x_return_status := FND_API.G_RET_STS_ERROR;
3629: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
3630: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
3631: FND_MSG_PUB.Add;
3632: END ;
3633:
3634: /* Second insert: Insert extra records which happened before start date active */
3635: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');

Line 3825: FND_MSG_PUB.Add;

3821: -- dbms_output.put_line('error inserting extra INTO bim_r_fdsp_daily_facts'||sqlerrm(sqlcode));
3822: x_return_status := FND_API.G_RET_STS_ERROR;
3823: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
3824: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
3825: FND_MSG_PUB.Add;
3826: END;
3827:
3828: /* Insert dummy 0s for the dates between p_start_date/start_date_active and p_end_date/end_date_active,
3829: but has no transactions. */

Line 3917: FND_MSG_PUB.Add;

3913: -- dbms_output.put_line('error inserting fdsp daily for missing dates'||sqlerrm(sqlcode));
3914: x_return_status := FND_API.G_RET_STS_ERROR;
3915: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
3916: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
3917: FND_MSG_PUB.Add;
3918: END;
3919:
3920: /* Insert into bim_r_fdsp_daily_facts the dates which are in bim_r_fund_daily_facts
3921: but not in bim_r_fdsp_daily_facts. */

Line 3997: FND_MSG_PUB.Add;

3993: -- dbms_output.put_line('error inserting bim_r_fdsp_daily_facts for balancing'||sqlerrm(sqlcode));
3994: x_return_status := FND_API.G_RET_STS_ERROR;
3995: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
3996: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
3997: FND_MSG_PUB.Add;
3998: END;
3999: --Insert dummy records into bim_r_fund_daily_facts for balancing
4000: /* Insert into bim_r_fund_daily_facts dates which are in bim_r_fdsp_daily_facts
4001: but not in bim_r_fund_daily_facts */

Line 4104: FND_MSG_PUB.Add;

4100: -- dbms_output.put_line('error insert fund_daily for balancing with fdsp'||sqlerrm(sqlcode));
4101: x_return_status := FND_API.G_RET_STS_ERROR;
4102: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
4103: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
4104: FND_MSG_PUB.Add;
4105: END;
4106:
4107: --Insert into history table.
4108: FND_FILE.put_line(fnd_file.log,'Insert into log history');

Line 4243: FND_MSG_PUB.Add;

4239: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_weekly_facts_s CACHE 20';
4240: x_return_status := FND_API.G_RET_STS_ERROR;
4241: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
4242: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
4243: FND_MSG_PUB.Add;
4244: END;
4245: BEGIN
4246: EXECUTE IMMEDIATE 'truncate table '||l_schema||'.bim_r_fdsp_weekly_facts';
4247: l_table_name :='bim_r_fdsp_weekly_facts';

Line 4335: FND_MSG_PUB.Add;

4331: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_weekly_facts_s CACHE 20';
4332: x_return_status := FND_API.G_RET_STS_ERROR;
4333: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
4334: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
4335: FND_MSG_PUB.Add;
4336: END;
4337: -- for performance reasons
4338: BEGIN
4339: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_fund_weekly_facts noparallel';