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_EVENT_FACTS dependencies on FND_MSG_PUB

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

36: l_conversion_type := fnd_profile.VALUE(l_conversion_type_profile);
37:
38: -- Conversion type cannot be null in profile
39: IF l_conversion_type IS NULL THEN
40: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
41: fnd_message.set_name('OZF', 'OZF_NO_EXCHANGE_TYPE');
42: fnd_msg_pub.add;
43: END IF;
44: RETURN 0;

Line 42: fnd_msg_pub.add;

38: -- Conversion type cannot be null in profile
39: IF l_conversion_type IS NULL THEN
40: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
41: fnd_message.set_name('OZF', 'OZF_NO_EXCHANGE_TYPE');
42: fnd_msg_pub.add;
43: END IF;
44: RETURN 0;
45: END IF;
46:

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

57: RETURN (l_to_amount);
58:
59: EXCEPTION
60: WHEN gl_currency_api.no_rate THEN
61: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
62: fnd_message.set_name('OZF', 'OZF_NO_RATE');
63: fnd_msg_pub.add;
64: END IF;
65: WHEN gl_currency_api.invalid_currency THEN

Line 63: fnd_msg_pub.add;

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

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

62: fnd_message.set_name('OZF', 'OZF_NO_RATE');
63: fnd_msg_pub.add;
64: END IF;
65: WHEN gl_currency_api.invalid_currency THEN
66: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
67: fnd_message.set_name('OZF', 'OZF_INVALID_CURR');
68: fnd_msg_pub.add;
69: END IF;
70: WHEN OTHERS THEN

Line 68: fnd_msg_pub.add;

64: END IF;
65: WHEN gl_currency_api.invalid_currency THEN
66: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
67: fnd_message.set_name('OZF', 'OZF_INVALID_CURR');
68: fnd_msg_pub.add;
69: END IF;
70: WHEN OTHERS THEN
71: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
72: fnd_msg_pub.add_exc_msg('OZF_UTLITY_PVT', 'Convert_curency');

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

67: fnd_message.set_name('OZF', 'OZF_INVALID_CURR');
68: fnd_msg_pub.add;
69: END IF;
70: WHEN OTHERS THEN
71: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
72: fnd_msg_pub.add_exc_msg('OZF_UTLITY_PVT', 'Convert_curency');
73: END IF;
74: END convert_currency;
75:

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

68: fnd_msg_pub.add;
69: END IF;
70: WHEN OTHERS THEN
71: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
72: fnd_msg_pub.add_exc_msg('OZF_UTLITY_PVT', 'Convert_curency');
73: END IF;
74: END convert_currency;
75:
76: -----------------------------------------------------------------------

Line 133: FND_MSG_PUB.initialize;

129:
130: -- Initialize message list IF p_init_msg_list IS set to TRUE.
131: IF FND_API.to_Boolean( p_init_msg_list )
132: THEN
133: FND_MSG_PUB.initialize;
134: END IF;
135:
136: -- Debug Message
137: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 230: FND_msg_PUB.Count_And_Get

226: --add this
227: commit;
228:
229: -- Standard call to get message count and IF count IS 1, get message info.
230: FND_msg_PUB.Count_And_Get
231: (p_count => x_msg_count,
232: p_data => x_msg_data
233: );
234: EXCEPTION

Line 239: FND_msg_PUB.Count_And_Get (

235:
236: WHEN FND_API.G_EXC_ERROR THEN
237: x_return_status := FND_API.G_RET_STS_ERROR;
238: -- Standard call to get message count and IF count=1, get the message
239: FND_msg_PUB.Count_And_Get (
240: -- p_encoded => FND_API.G_FALSE,
241: p_count => x_msg_count,
242: p_data => x_msg_data
243: );

Line 247: FND_msg_PUB.Count_And_Get (

243: );
244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
246: -- Standard call to get message count and IF count=1, get the message
247: FND_msg_PUB.Count_And_Get (
248: --p_encoded => FND_API.G_FALSE,
249: p_count => x_msg_count,
250: p_data => x_msg_data
251: );

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

251: );
252:
253: WHEN OTHERS THEN
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
255: IF FND_msg_PUB.Check_msg_Level ( FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
256: THEN
257: FND_msg_PUB.Add_Exc_msg( G_PKG_NAME,l_api_name);
258: END IF;
259: -- Standard call to get message count and IF count=1, get the message

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

253: WHEN OTHERS THEN
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
255: IF FND_msg_PUB.Check_msg_Level ( FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
256: THEN
257: FND_msg_PUB.Add_Exc_msg( G_PKG_NAME,l_api_name);
258: END IF;
259: -- Standard call to get message count and IF count=1, get the message
260: FND_msg_PUB.Count_And_Get (
261: -- p_encoded => FND_API.G_FALSE,

Line 260: FND_msg_PUB.Count_And_Get (

256: THEN
257: FND_msg_PUB.Add_Exc_msg( G_PKG_NAME,l_api_name);
258: END IF;
259: -- Standard call to get message count and IF count=1, get the message
260: FND_msg_PUB.Count_And_Get (
261: -- p_encoded => FND_API.G_FALSE,
262: p_count => x_msg_count,
263: p_data => x_msg_data
264: );

Line 841: FND_MSG_PUB.Add;

837: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_even_daily_facts_s CACHE 20';
838: x_return_status := FND_API.G_RET_STS_ERROR;
839: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
840: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
841: FND_MSG_PUB.Add;
842: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: EXCEPTION FOR FIRST INSERT. '||sqlerrm(sqlcode));
843: RAISE FND_API.G_EXC_ERROR;
844: end;
845:

Line 1174: FND_MSG_PUB.Add;

1170: --dbms_output.put_line('even_daily:'||sqlerrm(sqlcode));
1171: x_return_status := FND_API.G_RET_STS_ERROR;
1172: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
1173: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
1174: FND_MSG_PUB.Add;
1175: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: EXCEPTION FOR SECOND INSERT. '||sqlerrm(sqlcode));
1176: RAISE FND_API.G_EXC_ERROR;
1177: END;
1178:

Line 1474: FND_MSG_PUB.Add;

1470: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_even_daily_facts_s CACHE 20';
1471: x_return_status := FND_API.G_RET_STS_ERROR;
1472: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
1473: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
1474: FND_MSG_PUB.Add;
1475: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: EXCEPTION FOR THIRD INSERT. '||sqlerrm(sqlcode));
1476: RAISE FND_API.G_EXC_ERROR;
1477: END;
1478:

Line 2071: FND_MSG_PUB.Add;

2067: --dbms_output.put_line('even_update:'||sqlerrm(sqlcode));
2068: x_return_status := FND_API.G_RET_STS_ERROR;
2069: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
2070: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
2071: FND_MSG_PUB.Add;
2072: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: EXCEPTION registration insert statement. '||sqlerrm(sqlcode));
2073: RAISE FND_API.G_EXC_ERROR;
2074: END;
2075:

Line 2266: FND_MSG_PUB.Add;

2262: --dbms_output.put_line('even_update:'||sqlerrm(sqlcode));
2263: x_return_status := FND_API.G_RET_STS_ERROR;
2264: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
2265: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
2266: FND_MSG_PUB.Add;
2267: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: EXCEPTION registration insert statement. '||sqlerrm(sqlcode));
2268: RAISE FND_API.G_EXC_ERROR;
2269: END;
2270:

Line 2669: FND_MSG_PUB.Add;

2665:
2666: x_return_status := FND_API.G_RET_STS_ERROR;
2667: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
2668: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
2669: FND_MSG_PUB.Add;
2670: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: EXCEPTION FOR INSERT INTO WEEKLY FACTS. '||sqlerrm(sqlcode));
2671: RAISE FND_API.G_EXC_ERROR;
2672: END;
2673:

Line 2722: FND_msg_PUB.Count_And_Get (

2718:
2719: WHEN FND_API.G_EXC_ERROR THEN
2720: x_return_status := FND_API.G_RET_STS_ERROR;
2721: -- Standard call to get message count and if count=1, get the message
2722: FND_msg_PUB.Count_And_Get (
2723: p_count => x_msg_count,
2724: p_data => x_msg_data
2725: );
2726:

Line 2735: FND_msg_PUB.Count_And_Get (

2731:
2732: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2733:
2734: -- Standard call to get message count and if count=1, get the message
2735: FND_msg_PUB.Count_And_Get (
2736: --p_encoded => FND_API.G_FALSE,
2737: p_count => x_msg_count,
2738: p_data => x_msg_data
2739: );

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

2744: WHEN OTHERS THEN
2745:
2746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2747:
2748: IF FND_msg_PUB.Check_msg_Level (FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
2749: THEN
2750: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
2751: END IF;
2752:

Line 2750: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);

2746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2747:
2748: IF FND_msg_PUB.Check_msg_Level (FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
2749: THEN
2750: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
2751: END IF;
2752:
2753: -- Standard call to get message count and if count=1, get the message
2754: FND_msg_PUB.Count_And_Get (

Line 2754: FND_msg_PUB.Count_And_Get (

2750: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
2751: END IF;
2752:
2753: -- Standard call to get message count and if count=1, get the message
2754: FND_msg_PUB.Count_And_Get (
2755: -- p_encoded => FND_API.G_FALSE,
2756: p_count => x_msg_count,
2757: p_data => x_msg_data
2758: );

Line 3788: FND_MSG_PUB.Add;

3784: --dbms_output.put_line('even_daily:'||sqlerrm(sqlcode));
3785: x_return_status := FND_API.G_RET_STS_ERROR;
3786: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
3787: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
3788: FND_MSG_PUB.Add;
3789: ams_utility_pvt.write_conc_log('EVENT:LOAD: EXCEPTION FOR FIRST INSERT. '||sqlerrm(sqlcode));
3790: RAISE FND_API.G_EXC_ERROR;
3791: END;
3792:

Line 4260: FND_MSG_PUB.Add;

4256: --dbms_output.put_line('even_update:'||sqlerrm(sqlcode));
4257: x_return_status := FND_API.G_RET_STS_ERROR;
4258: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
4259: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
4260: FND_MSG_PUB.Add;
4261:
4262: ams_utility_pvt.write_conc_log('EVENT:LOAD: EXCEPTION FOR SECOND INSERT. '||sqlerrm(sqlcode));
4263: RAISE FND_API.G_EXC_ERROR;
4264: END;

Line 4478: FND_MSG_PUB.Add;

4474: WHEN OTHERS THEN
4475: x_return_status := FND_API.G_RET_STS_ERROR;
4476: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
4477: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
4478: FND_MSG_PUB.Add;
4479: ams_utility_pvt.write_conc_log('EVENT:LOAD: EXCEPTION FOR INSERT INTO WEEKLY TABLE. '||sqlerrm(sqlcode));
4480: RAISE FND_API.G_EXC_ERROR;
4481: END ;
4482: --END IF;

Line 4488: FND_msg_PUB.Count_And_Get (

4484:
4485: WHEN FND_API.G_EXC_ERROR THEN
4486: x_return_status := FND_API.G_RET_STS_ERROR;
4487: -- Standard call to get message count and if count=1, get the message
4488: FND_msg_PUB.Count_And_Get (
4489: -- p_encoded => FND_API.G_FALSE,
4490: p_count => x_msg_count,
4491: p_data => x_msg_data
4492: );

Line 4501: FND_msg_PUB.Count_And_Get (

4497:
4498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4499:
4500: -- Standard call to get message count and if count=1, get the message
4501: FND_msg_PUB.Count_And_Get (
4502: --p_encoded => FND_API.G_FALSE,
4503: p_count => x_msg_count,
4504: p_data => x_msg_data
4505: );

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

4509: WHEN OTHERS THEN
4510:
4511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4512:
4513: IF FND_msg_PUB.Check_msg_Level (FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
4514: THEN
4515: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
4516: END IF;
4517:

Line 4515: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);

4511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4512:
4513: IF FND_msg_PUB.Check_msg_Level (FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
4514: THEN
4515: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
4516: END IF;
4517:
4518: -- Standard call to get message count and if count=1, get the message
4519: FND_msg_PUB.Count_And_Get (

Line 4519: FND_msg_PUB.Count_And_Get (

4515: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
4516: END IF;
4517:
4518: -- Standard call to get message count and if count=1, get the message
4519: FND_msg_PUB.Count_And_Get (
4520: -- p_encoded => FND_API.G_FALSE,
4521: p_count => x_msg_count,
4522: p_data => x_msg_data
4523: );