DBA Data[Home] [Help]

APPS.BIM_EVENT_FACTS dependencies on FND_MESSAGE

Line 41: fnd_message.set_name('OZF', 'OZF_NO_EXCHANGE_TYPE');

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;
45: END IF;

Line 62: fnd_message.set_name('OZF', 'OZF_NO_RATE');

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
66: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

Line 67: fnd_message.set_name('OZF', 'OZF_INVALID_CURR');

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
71: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 839: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');

835: EXCEPTION
836: WHEN OTHERS THEN
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;

Line 840: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);

836: WHEN OTHERS THEN
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;

Line 1172: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');

1168: WHEN OTHERS THEN
1169: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_even_daily_facts_s CACHE 20';
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;

Line 1173: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);

1169: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_even_daily_facts_s CACHE 20';
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;

Line 1472: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');

1468: EXCEPTION
1469: WHEN OTHERS THEN
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;

Line 1473: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);

1469: WHEN OTHERS THEN
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;

Line 2069: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');

2065: WHEN OTHERS THEN
2066: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_even_daily_facts_s CACHE 20';
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;

Line 2070: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);

2066: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_even_daily_facts_s CACHE 20';
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;

Line 2264: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');

2260: WHEN OTHERS THEN
2261: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_even_daily_facts_s CACHE 20';
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;

Line 2265: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);

2261: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_even_daily_facts_s CACHE 20';
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;

Line 2667: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');

2663:
2664: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_even_weekly_facts_s CACHE 20';
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;

Line 2668: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);

2664: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_even_weekly_facts_s CACHE 20';
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;

Line 3786: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');

3782: WHEN OTHERS THEN
3783: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_even_daily_facts_s CACHE 20';
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;

Line 3787: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);

3783: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_even_daily_facts_s CACHE 20';
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;

Line 4258: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');

4254: WHEN OTHERS THEN
4255: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_even_daily_facts_s CACHE 20';
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));

Line 4259: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);

4255: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_even_daily_facts_s CACHE 20';
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;

Line 4476: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');

4472:
4473: EXCEPTION
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;

Line 4477: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);

4473: EXCEPTION
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 ;