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_API

Line 300: --x_return_status := FND_API.G_RET_STS_ERROR;

296: EXCEPTION
297: WHEN OTHERS THEN
298: ams_utility_pvt.write_conc_log('error updateing balance'||sqlerrm(sqlcode));
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;

Line 589: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

585: ---------------------------------------------------------------------
586: PROCEDURE POPULATE
587: (
588: p_api_version_number IN NUMBER ,
589: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
590: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
591: p_commit IN VARCHAR2 := FND_API.G_FALSE,
592: x_msg_count OUT NOCOPY NUMBER ,
593: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 590: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

586: PROCEDURE POPULATE
587: (
588: p_api_version_number IN NUMBER ,
589: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
590: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
591: p_commit IN VARCHAR2 := FND_API.G_FALSE,
592: x_msg_count OUT NOCOPY NUMBER ,
593: x_msg_data OUT NOCOPY VARCHAR2 ,
594: x_return_status OUT NOCOPY VARCHAR2 ,

Line 591: p_commit IN VARCHAR2 := FND_API.G_FALSE,

587: (
588: p_api_version_number IN NUMBER ,
589: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
590: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
591: p_commit IN VARCHAR2 := FND_API.G_FALSE,
592: x_msg_count OUT NOCOPY NUMBER ,
593: x_msg_data OUT NOCOPY VARCHAR2 ,
594: x_return_status OUT NOCOPY VARCHAR2 ,
595: p_object IN VARCHAR2 ,

Line 627: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

623: BEGIN
624: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
625:
626: -- Standard call to check for call compatibility.
627: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
628: p_api_version_number,
629: l_api_name,
630: G_PKG_NAME)
631: THEN

Line 632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

628: p_api_version_number,
629: l_api_name,
630: G_PKG_NAME)
631: THEN
632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
633: END IF;
634:
635: -- Initialize message list IF p_init_msg_list IS set to TRUE.
636: IF FND_API.to_Boolean( p_init_msg_list )

Line 636: IF FND_API.to_Boolean( p_init_msg_list )

632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
633: END IF;
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:

Line 645: x_return_status := FND_API.G_RET_STS_SUCCESS;

641: -- Debug Message
642: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
643:
644: -- Initialize API RETURN status to SUCCESS
645: x_return_status := FND_API.G_RET_STS_SUCCESS;
646:
647: fnd_message.set_name('BIM','BIM_R_START_FACTS');
648: fnd_message.set_token('p_object', 'Fund', FALSE);
649: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 692: RAISE FND_API.G_EXC_ERROR;

688:
689: fnd_message.set_name('BIM','BIM_R_FIRST_LOAD');
690: fnd_message.set_token('end_date', l_last_update_date, FALSE);
691: fnd_file.put_line(fnd_file.log,fnd_message.get);
692: RAISE FND_API.G_EXC_ERROR;
693: END IF;
694:
695: IF p_start_date IS NOT NULL THEN
696: IF (p_start_date >= p_end_date) THEN

Line 699: RAISE FND_API.G_EXC_ERROR;

695: IF p_start_date IS NOT NULL THEN
696: IF (p_start_date >= p_end_date) THEN
697: fnd_message.set_name('BIM',' BIM_R_DATE_VALIDATION');
698: fnd_file.put_line(fnd_file.log,fnd_message.get) ;
699: RAISE FND_API.G_EXC_ERROR;
700: END IF;
701:
702: FUND_FIRST_LOAD(p_start_datel =>TRUNC(p_start_date)
703: ,p_end_datel => TRUNC(l_end_date)

Line 708: IF x_return_status = FND_API.g_ret_sts_error THEN

704: ,p_para_num =>p_para_num
705: ,x_msg_count => x_msg_count
706: ,x_msg_data => x_msg_data
707: ,x_return_status => x_return_status);
708: IF x_return_status = FND_API.g_ret_sts_error THEN
709: RAISE FND_API.g_exc_error;
710: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
711: RAISE FND_API.g_exc_unexpected_error;
712: END IF;

Line 709: RAISE FND_API.g_exc_error;

705: ,x_msg_count => x_msg_count
706: ,x_msg_data => x_msg_data
707: ,x_return_status => x_return_status);
708: IF x_return_status = FND_API.g_ret_sts_error THEN
709: RAISE FND_API.g_exc_error;
710: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
711: RAISE FND_API.g_exc_unexpected_error;
712: END IF;
713: ELSE

Line 710: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

706: ,x_msg_data => x_msg_data
707: ,x_return_status => x_return_status);
708: IF x_return_status = FND_API.g_ret_sts_error THEN
709: RAISE FND_API.g_exc_error;
710: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
711: RAISE FND_API.g_exc_unexpected_error;
712: END IF;
713: ELSE
714: IF l_last_update_date IS NOT NULL THEN

Line 711: RAISE FND_API.g_exc_unexpected_error;

707: ,x_return_status => x_return_status);
708: IF x_return_status = FND_API.g_ret_sts_error THEN
709: RAISE FND_API.g_exc_error;
710: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
711: RAISE FND_API.g_exc_unexpected_error;
712: END IF;
713: ELSE
714: IF l_last_update_date IS NOT NULL THEN
715: IF (p_end_date <= l_last_update_date) THEN

Line 717: RAISE FND_API.g_exc_error;

713: ELSE
714: IF l_last_update_date IS NOT NULL THEN
715: IF (p_end_date <= l_last_update_date) THEN
716: ams_utility_pvt.write_conc_log('The current end date cannot be less than the last end date ');
717: RAISE FND_API.g_exc_error;
718: END IF;
719: -- dbms_output.put_line('in sub load');
720:
721: --Load fund subsequently

Line 729: IF x_return_status = FND_API.g_ret_sts_error THEN

725: ,x_msg_count => x_msg_count
726: ,x_msg_data => x_msg_data
727: ,x_return_status => x_return_status);
728: END IF;
729: IF x_return_status = FND_API.g_ret_sts_error THEN
730: RAISE FND_API.g_exc_error;
731: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
732: RAISE FND_API.g_exc_unexpected_error;
733: END IF;

Line 730: RAISE FND_API.g_exc_error;

726: ,x_msg_data => x_msg_data
727: ,x_return_status => x_return_status);
728: END IF;
729: IF x_return_status = FND_API.g_ret_sts_error THEN
730: RAISE FND_API.g_exc_error;
731: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
732: RAISE FND_API.g_exc_unexpected_error;
733: END IF;
734: END IF;

Line 731: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

727: ,x_return_status => x_return_status);
728: END IF;
729: IF x_return_status = FND_API.g_ret_sts_error THEN
730: RAISE FND_API.g_exc_error;
731: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
732: RAISE FND_API.g_exc_unexpected_error;
733: END IF;
734: END IF;
735:

Line 732: RAISE FND_API.g_exc_unexpected_error;

728: END IF;
729: IF x_return_status = FND_API.g_ret_sts_error THEN
730: RAISE FND_API.g_exc_error;
731: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
732: RAISE FND_API.g_exc_unexpected_error;
733: END IF;
734: END IF;
735:
736: --Standard check of commit

Line 737: IF FND_API.To_Boolean (p_commit) THEN

733: END IF;
734: END IF;
735:
736: --Standard check of commit
737: IF FND_API.To_Boolean (p_commit) THEN
738: COMMIT WORK;
739: END IF;
740:
741: -- Standard call to get message count and IF count IS 1, get message info.

Line 750: WHEN FND_API.G_EXC_ERROR THEN

746: fnd_message.set_name('BIM','BIM_R_END_FACTS');
747: fnd_message.set_token('object_name', 'Fund', FALSE);
748: fnd_file.put_line(fnd_file.log,fnd_message.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,

Line 751: x_return_status := FND_API.G_RET_STS_ERROR;

747: fnd_message.set_token('object_name', 'Fund', FALSE);
748: fnd_file.put_line(fnd_file.log,fnd_message.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,

Line 754: -- p_encoded => FND_API.G_FALSE,

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
758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
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,

Line 758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
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,

Line 761: --p_encoded => FND_API.G_FALSE,

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: );
765:

Line 767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

763: p_data => x_msg_data
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;

Line 774: -- p_encoded => FND_API.G_FALSE,

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: );
778: END POPULATE;

Line 819: x_return_status := FND_API.G_RET_STS_ERROR;

815: p_start_time,
816: p_end_time);
817: EXCEPTION
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);

Line 912: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

908: BEGIN
909: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
910:
911: -- Standard call to check for call compatibility.
912: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
913: l_api_version_number,
914: l_api_name,
915: G_PKG_NAME)
916: THEN

Line 917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

913: l_api_version_number,
914: l_api_name,
915: G_PKG_NAME)
916: THEN
917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
918: END IF;
919:
920: -- Debug Message
921: --AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 924: x_return_status := FND_API.G_RET_STS_SUCCESS;

920: -- Debug Message
921: --AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
922:
923: -- Initialize API RETURN status to SUCCESS
924: x_return_status := FND_API.G_RET_STS_SUCCESS;
925:
926: /* In order to speed up insertion. We drop all the index before inserting, and
927: create them back after inserting. But we want to keep the parameters(tablespace,
928: indexspace etc) they were created before. */

Line 968: x_return_status := FND_API.G_RET_STS_ERROR;

964: EXCEPTION
965: WHEN others THEN
966: --dbms_output.put_line('error dropping index:'||sqlerrm(sqlcode));
967: FND_FILE.put_line(fnd_file.log,'error dropping index'||sqlerrm(sqlcode));
968: x_return_status := FND_API.G_RET_STS_ERROR;
969: END;
970:
971: BEGIN
972:

Line 1299: x_return_status := FND_API.G_RET_STS_ERROR;

1295: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_daily_facts_s CACHE 20';
1296: EXCEPTION
1297: WHEN others THEN
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);

Line 1535: x_return_status := FND_API.G_RET_STS_ERROR;

1531: EXCEPTION
1532: WHEN others THEN
1533: FND_FILE.put_line(fnd_file.log,'error insert into fund_daily for transactions happened b4 start date'||sqlerrm(sqlcode));
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;

Line 1681: x_return_status := FND_API.G_RET_STS_ERROR;

1677: WHEN OTHERS THEN
1678: FND_FILE.put_line(fnd_file.log,'error insert fdsp daily'||sqlerrm(sqlcode));
1679: --dbms_output.put_line('error inserting INTO bim_r_fdsp_daily_facts'||sqlerrm(sqlcode));
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.

Line 1885: x_return_status := FND_API.G_RET_STS_ERROR;

1881: WHEN OTHERS THEN
1882: FND_FILE.put_line(fnd_file.log,'error insert fdsp daily'||sqlerrm(sqlcode));
1883: --dbms_output.put_line('error inserting INTO bim_r_fdsp_daily_facts'||sqlerrm(sqlcode));
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 ;

Line 2078: x_return_status := FND_API.G_RET_STS_ERROR;

2074: EXCEPTION
2075: WHEN others THEN
2076: FND_FILE.put_line(fnd_file.log,'error insert extras into fdsp daily'||sqlerrm(sqlcode));
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;

Line 2203: x_return_status := FND_API.G_RET_STS_ERROR;

2199: EXCEPTION
2200: WHEN OTHERS THEN
2201: FND_FILE.put_line(fnd_file.log,'error insert fund daily for balancing'||sqlerrm(sqlcode));
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);

Line 2331: x_return_status := FND_API.G_RET_STS_ERROR;

2327: WHEN others THEN
2328: FND_FILE.put_line(fnd_file.log,'Error insertg fund weekly:'||sqlerrm(sqlcode));
2329: -- dbms_output.put_line('Errorin inserting fund weekly:'||sqlerrm(sqlcode));
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;

Line 2420: x_return_status := FND_API.G_RET_STS_ERROR;

2416: when others THEN
2417: FND_FILE.put_line(fnd_file.log,'error insert fdsp_weekly'||sqlerrm(sqlcode));
2418: -- dbms_output.put_line('error inserting INTO bim_r_fdsp_weekly_facts'||sqlerrm(sqlcode));
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;

Line 2545: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

2541: BEGIN
2542: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
2543:
2544: -- Standard call to check for call compatibility.
2545: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2546: l_api_version_number,
2547: l_api_name,
2548: G_PKG_NAME)
2549: THEN

Line 2550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2546: l_api_version_number,
2547: l_api_name,
2548: G_PKG_NAME)
2549: THEN
2550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2551: END IF;
2552:
2553: -- Debug Message
2554: --AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 2557: x_return_status := FND_API.G_RET_STS_SUCCESS;

2553: -- Debug Message
2554: --AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
2555:
2556: -- Initialize API RETURN status to SUCCESS
2557: x_return_status := FND_API.G_RET_STS_SUCCESS;
2558:
2559: -- Make sure p_end_date is not greate than sysdate-1
2560: IF (trunc(p_end_datel) =trunc(sysdate)) THEN
2561: l_end_date :=trunc(sysdate-1);

Line 2801: x_return_status := FND_API.G_RET_STS_ERROR;

2797: WHEN others THEN
2798: FND_FILE.put_line(fnd_file.log,'error insert into fund_daily'||sqlerrm(sqlcode));
2799: --dbms_output.put_line('error inserting INTO bim_r_fund_daily_facts'||sqlerrm(sqlcode));
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;

Line 3036: x_return_status := FND_API.G_RET_STS_ERROR;

3032: EXCEPTION
3033: WHEN others THEN
3034: FND_FILE.put_line(fnd_file.log,'error insert into fund_daily for transactions happened b4 start date'||sqlerrm(sqlcode));
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;

Line 3158: x_return_status := FND_API.G_RET_STS_ERROR;

3154: EXCEPTION
3155: WHEN others THEN
3156: FND_FILE.put_line(fnd_file.log,'error insert into fund_daily for missing date'||sqlerrm(sqlcode));
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;

Line 3286: x_return_status := FND_API.G_RET_STS_ERROR;

3282: EXCEPTION
3283: WHEN others THEN
3284: FND_FILE.put_line(fnd_file.log,'error insert into fund_daily for missing date 2'||sqlerrm(sqlcode));
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;

Line 3431: x_return_status := FND_API.G_RET_STS_ERROR;

3427: WHEN OTHERS THEN
3428: FND_FILE.put_line(fnd_file.log,'error insert fdsp daily'||sqlerrm(sqlcode));
3429: --dbms_output.put_line('error inserting INTO bim_r_fdsp_daily_facts'||sqlerrm(sqlcode));
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.

Line 3628: x_return_status := FND_API.G_RET_STS_ERROR;

3624: WHEN OTHERS THEN
3625: FND_FILE.put_line(fnd_file.log,'first insert:error insert fdsp daily'||sqlerrm(sqlcode));
3626: -- dbms_output.put_line('error inserting INTO bim_r_fdsp_daily_facts'||sqlerrm(sqlcode));
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 ;

Line 3822: x_return_status := FND_API.G_RET_STS_ERROR;

3818: EXCEPTION
3819: WHEN others THEN
3820: FND_FILE.put_line(fnd_file.log,'error insert extras into fdsp daily'||sqlerrm(sqlcode));
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;

Line 3914: x_return_status := FND_API.G_RET_STS_ERROR;

3910: EXCEPTION
3911: WHEN others THEN
3912: FND_FILE.put_line(fnd_file.log,'error insert fdsp daily for missing dates'||sqlerrm(sqlcode));
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;

Line 3994: x_return_status := FND_API.G_RET_STS_ERROR;

3990: EXCEPTION
3991: WHEN OTHERS THEN
3992: FND_FILE.put_line(fnd_file.log,'error insert fdsp daily for balancing'||sqlerrm(sqlcode));
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;

Line 4101: x_return_status := FND_API.G_RET_STS_ERROR;

4097: EXCEPTION
4098: WHEN OTHERS THEN
4099: FND_FILE.put_line(fnd_file.log,'error insert fund daily for balancing'||sqlerrm(sqlcode));
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;

Line 4240: x_return_status := FND_API.G_RET_STS_ERROR;

4236: WHEN others THEN
4237: FND_FILE.put_line(fnd_file.log,'Error insertg fund weekly:'||sqlerrm(sqlcode));
4238: --dbms_output.put_line('Errorin inserting fund weekly:'||sqlerrm(sqlcode));
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;

Line 4332: x_return_status := FND_API.G_RET_STS_ERROR;

4328: when others THEN
4329: FND_FILE.put_line(fnd_file.log,'error insert fdsp_weekly'||sqlerrm(sqlcode));
4330: --dbms_output.put_line('error inserting INTO bim_r_fdsp_weekly_facts'||sqlerrm(sqlcode));
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;