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_MESSAGE

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

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

Line 57: fnd_message.set_name('OZF', 'OZF_NO_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;
61: WHEN gl_currency_api.invalid_currency THEN

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

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

Line 142: fnd_message.set_name('BIM','BIM_R_PROC_START');

138:
139: BEGIN
140: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
141: begin
142: fnd_message.set_name('BIM','BIM_R_PROC_START');
143: fnd_message.set_token('proc_name', 'UPDATE_BALANCE', FALSE);
144: fnd_file.put_line(fnd_file.log,fnd_message.get);
145: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_fund_daily_facts noparallel';
146: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_fdsp_daily_facts noparallel';

Line 143: fnd_message.set_token('proc_name', 'UPDATE_BALANCE', FALSE);

139: BEGIN
140: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
141: begin
142: fnd_message.set_name('BIM','BIM_R_PROC_START');
143: fnd_message.set_token('proc_name', 'UPDATE_BALANCE', FALSE);
144: fnd_file.put_line(fnd_file.log,fnd_message.get);
145: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_fund_daily_facts noparallel';
146: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_fdsp_daily_facts noparallel';
147: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_fund_balance noparallel';

Line 144: fnd_file.put_line(fnd_file.log,fnd_message.get);

140: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
141: begin
142: fnd_message.set_name('BIM','BIM_R_PROC_START');
143: fnd_message.set_token('proc_name', 'UPDATE_BALANCE', FALSE);
144: fnd_file.put_line(fnd_file.log,fnd_message.get);
145: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_fund_daily_facts noparallel';
146: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_fdsp_daily_facts noparallel';
147: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_fund_balance noparallel';
148: exception

Line 293: fnd_message.set_name('BIM','BIM_R_PROC_END');

289: ams_utility_pvt.write_conc_log('error updateing balance in loop'||sqlerrm(sqlcode));
290: --dbms_output.put_line('error updateing balance in loop'||sqlerrm(sqlcode));
291: END;
292: END LOOP;
293: fnd_message.set_name('BIM','BIM_R_PROC_END');
294: fnd_message.set_token('proc_name', 'UPDATE_BALANCE', FALSE);
295: fnd_file.put_line(fnd_file.log,fnd_message.get);
296: EXCEPTION
297: WHEN OTHERS THEN

Line 294: fnd_message.set_token('proc_name', 'UPDATE_BALANCE', FALSE);

290: --dbms_output.put_line('error updateing balance in loop'||sqlerrm(sqlcode));
291: END;
292: END LOOP;
293: fnd_message.set_name('BIM','BIM_R_PROC_END');
294: fnd_message.set_token('proc_name', 'UPDATE_BALANCE', FALSE);
295: fnd_file.put_line(fnd_file.log,fnd_message.get);
296: EXCEPTION
297: WHEN OTHERS THEN
298: ams_utility_pvt.write_conc_log('error updateing balance'||sqlerrm(sqlcode));

Line 295: fnd_file.put_line(fnd_file.log,fnd_message.get);

291: END;
292: END LOOP;
293: fnd_message.set_name('BIM','BIM_R_PROC_END');
294: fnd_message.set_token('proc_name', 'UPDATE_BALANCE', FALSE);
295: fnd_file.put_line(fnd_file.log,fnd_message.get);
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));

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

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;
305:

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

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;
305:
306: ---------------------------------------------------------------------

Line 346: fnd_message.set_name('BIM','BIM_R_PROC_START');

342: l_return BOOLEAN;
343:
344: BEGIN
345: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
346: fnd_message.set_name('BIM','BIM_R_PROC_START');
347: fnd_message.set_token('proc_name', 'UPDATE_SUB_BALANCE', FALSE);
348: fnd_file.put_line(fnd_file.log,fnd_message.get);
349: BEGIN
350: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_fund_daily_facts noparallel';

Line 347: fnd_message.set_token('proc_name', 'UPDATE_SUB_BALANCE', FALSE);

343:
344: BEGIN
345: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
346: fnd_message.set_name('BIM','BIM_R_PROC_START');
347: fnd_message.set_token('proc_name', 'UPDATE_SUB_BALANCE', FALSE);
348: fnd_file.put_line(fnd_file.log,fnd_message.get);
349: BEGIN
350: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_fund_daily_facts noparallel';
351: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_fdsp_daily_facts noparallel';

Line 348: fnd_file.put_line(fnd_file.log,fnd_message.get);

344: BEGIN
345: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
346: fnd_message.set_name('BIM','BIM_R_PROC_START');
347: fnd_message.set_token('proc_name', 'UPDATE_SUB_BALANCE', FALSE);
348: fnd_file.put_line(fnd_file.log,fnd_message.get);
349: BEGIN
350: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_fund_daily_facts noparallel';
351: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_fdsp_daily_facts noparallel';
352: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_fund_balance noparallel';

Line 570: fnd_message.set_name('BIM','BIM_R_PROC_END');

566: and ba.fund_id = x.fund_id;
567: END IF;
568: l_oldid :=x.fund_id;
569: END LOOP;
570: fnd_message.set_name('BIM','BIM_R_PROC_END');
571: fnd_message.set_token('proc_name', 'UPDATE_SUB_BALANCE', FALSE);
572: fnd_file.put_line(fnd_file.log,fnd_message.get);
573: EXCEPTION
574: WHEN OTHERS THEN

Line 571: fnd_message.set_token('proc_name', 'UPDATE_SUB_BALANCE', FALSE);

567: END IF;
568: l_oldid :=x.fund_id;
569: END LOOP;
570: fnd_message.set_name('BIM','BIM_R_PROC_END');
571: fnd_message.set_token('proc_name', 'UPDATE_SUB_BALANCE', FALSE);
572: fnd_file.put_line(fnd_file.log,fnd_message.get);
573: EXCEPTION
574: WHEN OTHERS THEN
575: FND_FILE.put_line(fnd_file.log,'error updateing new balance'||sqlerrm(sqlcode));

Line 572: fnd_file.put_line(fnd_file.log,fnd_message.get);

568: l_oldid :=x.fund_id;
569: END LOOP;
570: fnd_message.set_name('BIM','BIM_R_PROC_END');
571: fnd_message.set_token('proc_name', 'UPDATE_SUB_BALANCE', FALSE);
572: fnd_file.put_line(fnd_file.log,fnd_message.get);
573: EXCEPTION
574: WHEN OTHERS THEN
575: FND_FILE.put_line(fnd_file.log,'error updateing new balance'||sqlerrm(sqlcode));
576: END;

Line 647: fnd_message.set_name('BIM','BIM_R_START_FACTS');

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);
650: -- Always make sure data be populated up to sysdate-1
651: IF (trunc(p_end_date) =trunc(sysdate)) THEN

Line 648: fnd_message.set_token('p_object', 'Fund', FALSE);

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);
650: -- Always make sure data be populated up to sysdate-1
651: IF (trunc(p_end_date) =trunc(sysdate)) THEN
652: l_end_date :=trunc(sysdate-1);

Line 649: fnd_file.put_line(fnd_file.log,fnd_message.get);

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);
650: -- Always make sure data be populated up to sysdate-1
651: IF (trunc(p_end_date) =trunc(sysdate)) THEN
652: l_end_date :=trunc(sysdate-1);
653: ELSE

Line 672: fnd_message.set_name('BIM','BIM_R_GL_PERIODS');

668: )
669: AND rownum < 2;
670:
671: IF (l_start_date IS NULL) THEN
672: fnd_message.set_name('BIM','BIM_R_GL_PERIODS');
673: fnd_file.put_line(fnd_file.log,fnd_message.get);
674: END IF ;
675: EXCEPTION
676: WHEN OTHERS THEN

Line 673: fnd_file.put_line(fnd_file.log,fnd_message.get);

669: AND rownum < 2;
670:
671: IF (l_start_date IS NULL) THEN
672: fnd_message.set_name('BIM','BIM_R_GL_PERIODS');
673: fnd_file.put_line(fnd_file.log,fnd_message.get);
674: END IF ;
675: EXCEPTION
676: WHEN OTHERS THEN
677: fnd_message.set_name('BIM','BIM_R_GL_PERIODS');

Line 677: fnd_message.set_name('BIM','BIM_R_GL_PERIODS');

673: fnd_file.put_line(fnd_file.log,fnd_message.get);
674: END IF ;
675: EXCEPTION
676: WHEN OTHERS THEN
677: fnd_message.set_name('BIM','BIM_R_GL_PERIODS');
678: fnd_file.put_line(fnd_file.log,fnd_message.get);
679: END;
680:
681:

Line 678: fnd_file.put_line(fnd_file.log,fnd_message.get);

674: END IF ;
675: EXCEPTION
676: WHEN OTHERS THEN
677: fnd_message.set_name('BIM','BIM_R_GL_PERIODS');
678: fnd_file.put_line(fnd_file.log,fnd_message.get);
679: END;
680:
681:
682: OPEN last_update_history;

Line 689: fnd_message.set_name('BIM','BIM_R_FIRST_LOAD');

685:
686: --Logic check.When load subsequently, p_start_date should be null.
687: IF (l_last_update_date IS NOT NULL AND p_start_date IS NOT NULL) THEN
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;

Line 690: fnd_message.set_token('end_date', l_last_update_date, FALSE);

686: --Logic check.When load subsequently, p_start_date should be null.
687: IF (l_last_update_date IS NOT NULL AND p_start_date IS NOT NULL) THEN
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:

Line 691: fnd_file.put_line(fnd_file.log,fnd_message.get);

687: IF (l_last_update_date IS NOT NULL AND p_start_date IS NOT NULL) THEN
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

Line 697: fnd_message.set_name('BIM',' BIM_R_DATE_VALIDATION');

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

Line 698: fnd_file.put_line(fnd_file.log,fnd_message.get) ;

694:
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)

Line 746: fnd_message.set_name('BIM','BIM_R_END_FACTS');

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');
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

Line 747: fnd_message.set_token('object_name', 'Fund', FALSE);

743: (p_count => x_msg_count,
744: p_data => x_msg_data
745: );
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;

Line 748: fnd_file.put_line(fnd_file.log,fnd_message.get);

744: p_data => x_msg_data
745: );
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

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

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);
824: END LOG_HISTORY;

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

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);
824: END LOG_HISTORY;
825:

Line 823: fnd_file.put_line(fnd_file.log,fnd_message.get);

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: ---------------------------------------------------------------------
827: -- PROCEDURE

Line 933: fnd_message.set_name('BIM','BIM_R_DROP_INDEXES');

929: OPEN get_ts_name;
930: FETCH get_ts_name INTO l_def_tablespace, l_index_tablespace, l_oracle_username;
931: CLOSE get_ts_name;
932:
933: fnd_message.set_name('BIM','BIM_R_DROP_INDEXES');
934: fnd_file.put_line(fnd_file.log,fnd_message.get);
935: /* Piece of Code for retrieving,storing storage parameters and Dropping the indexes */
936: BEGIN
937: i := 1;

Line 934: fnd_file.put_line(fnd_file.log,fnd_message.get);

930: FETCH get_ts_name INTO l_def_tablespace, l_index_tablespace, l_oracle_username;
931: CLOSE get_ts_name;
932:
933: fnd_message.set_name('BIM','BIM_R_DROP_INDEXES');
934: fnd_file.put_line(fnd_file.log,fnd_message.get);
935: /* Piece of Code for retrieving,storing storage parameters and Dropping the indexes */
936: BEGIN
937: i := 1;
938: l_old_index :='N';

Line 981: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');

977: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_fdsp_weekly_facts nologging';
978: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_daily_facts_s CACHE 1000';
979:
980: l_table_name :='bim_r_fund_daily_facts';
981: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
982: fnd_message.set_token('TABLE_NAME','bim_r_fund_daily_facts', FALSE);
983: fnd_file.put_line(fnd_file.log,fnd_message.get);
984: /* First insert: Insert all the transactions: transfer in/out for funds whose active date between p_start_date and p_end_date */
985: INSERT /*+ append parallel(fdf,p_para_num) */

Line 982: fnd_message.set_token('TABLE_NAME','bim_r_fund_daily_facts', FALSE);

978: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_daily_facts_s CACHE 1000';
979:
980: l_table_name :='bim_r_fund_daily_facts';
981: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
982: fnd_message.set_token('TABLE_NAME','bim_r_fund_daily_facts', FALSE);
983: fnd_file.put_line(fnd_file.log,fnd_message.get);
984: /* First insert: Insert all the transactions: transfer in/out for funds whose active date between p_start_date and p_end_date */
985: INSERT /*+ append parallel(fdf,p_para_num) */
986: INTO bim_r_fund_daily_facts fdf(

Line 983: fnd_file.put_line(fnd_file.log,fnd_message.get);

979:
980: l_table_name :='bim_r_fund_daily_facts';
981: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
982: fnd_message.set_token('TABLE_NAME','bim_r_fund_daily_facts', FALSE);
983: fnd_file.put_line(fnd_file.log,fnd_message.get);
984: /* First insert: Insert all the transactions: transfer in/out for funds whose active date between p_start_date and p_end_date */
985: INSERT /*+ append parallel(fdf,p_para_num) */
986: INTO bim_r_fund_daily_facts fdf(
987: fund_transaction_id

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

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

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

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);
1304: END;
1305:

Line 1303: fnd_file.put_line(fnd_file.log,fnd_message.get);

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 */
1307: BEGIN

Line 1309: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');

1305:
1306: /*Second insert: more records which transact before active date */
1307: BEGIN
1308: -- dbms_output.put_line('inserting extra');
1309: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
1310: fnd_message.set_token('table_name', 'bim_r_fund_daily_facts', FALSE);
1311: fnd_file.put_line(fnd_file.log,fnd_message.get);
1312: INSERT
1313: INTO bim_r_fund_daily_facts fdf(

Line 1310: fnd_message.set_token('table_name', 'bim_r_fund_daily_facts', FALSE);

1306: /*Second insert: more records which transact before active date */
1307: BEGIN
1308: -- dbms_output.put_line('inserting extra');
1309: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
1310: fnd_message.set_token('table_name', 'bim_r_fund_daily_facts', FALSE);
1311: fnd_file.put_line(fnd_file.log,fnd_message.get);
1312: INSERT
1313: INTO bim_r_fund_daily_facts fdf(
1314: fund_transaction_id

Line 1311: fnd_file.put_line(fnd_file.log,fnd_message.get);

1307: BEGIN
1308: -- dbms_output.put_line('inserting extra');
1309: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
1310: fnd_message.set_token('table_name', 'bim_r_fund_daily_facts', FALSE);
1311: fnd_file.put_line(fnd_file.log,fnd_message.get);
1312: INSERT
1313: INTO bim_r_fund_daily_facts fdf(
1314: fund_transaction_id
1315: ,creation_date

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

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;
1540: /* Start inserting into 'bim_r_fdsp_daily_facts' */

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

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;
1540: /* Start inserting into 'bim_r_fdsp_daily_facts' */
1541: l_table_name :='bim_r_fdsp_daily_facts';

Line 1542: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');

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');
1543: fnd_message.set_token('table_name', 'bim_r_fdsp_load', FALSE);
1544: fnd_file.put_line(fnd_file.log,fnd_message.get);
1545: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_daily_facts_s CACHE 1000';
1546: EXECUTE IMMEDIATE 'truncate table '||l_schema||'.bim_r_fdsp_load';

Line 1543: fnd_message.set_token('table_name', 'bim_r_fdsp_load', FALSE);

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');
1543: fnd_message.set_token('table_name', 'bim_r_fdsp_load', FALSE);
1544: fnd_file.put_line(fnd_file.log,fnd_message.get);
1545: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_daily_facts_s CACHE 1000';
1546: EXECUTE IMMEDIATE 'truncate table '||l_schema||'.bim_r_fdsp_load';
1547: /* bim_r_fdsp_load is a intermediate table which holds commited amount, planned amount etc for all objects */

Line 1544: fnd_file.put_line(fnd_file.log,fnd_message.get);

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');
1543: fnd_message.set_token('table_name', 'bim_r_fdsp_load', FALSE);
1544: fnd_file.put_line(fnd_file.log,fnd_message.get);
1545: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_daily_facts_s CACHE 1000';
1546: EXECUTE IMMEDIATE 'truncate table '||l_schema||'.bim_r_fdsp_load';
1547: /* bim_r_fdsp_load is a intermediate table which holds commited amount, planned amount etc for all objects */
1548: BEGIN

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

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.
1686:

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

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.
1686:
1687: -- dbms_output.put_line('inside fist inserting into fdsp daily');

Line 1688: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');

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');
1689: fnd_message.set_token('table_name', l_table_name, FALSE);
1690: fnd_file.put_line(fnd_file.log,fnd_message.get);
1691: /* First insert: insert into bim_r_fdsp_daily_facts for the funds whose active
1692: date between p_start_date and p_end_date. Fund transactions are: commited, planned, utilized

Line 1689: fnd_message.set_token('table_name', l_table_name, FALSE);

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');
1689: fnd_message.set_token('table_name', l_table_name, FALSE);
1690: fnd_file.put_line(fnd_file.log,fnd_message.get);
1691: /* First insert: insert into bim_r_fdsp_daily_facts for the funds whose active
1692: date between p_start_date and p_end_date. Fund transactions are: commited, planned, utilized
1693: etc. The measures are on object level. Object are like campaigns, events, offers, etc. */

Line 1690: fnd_file.put_line(fnd_file.log,fnd_message.get);

1686:
1687: -- dbms_output.put_line('inside fist inserting into fdsp daily');
1688: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
1689: fnd_message.set_token('table_name', l_table_name, FALSE);
1690: fnd_file.put_line(fnd_file.log,fnd_message.get);
1691: /* First insert: insert into bim_r_fdsp_daily_facts for the funds whose active
1692: date between p_start_date and p_end_date. Fund transactions are: commited, planned, utilized
1693: etc. The measures are on object level. Object are like campaigns, events, offers, etc. */
1694: BEGIN

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

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 ;
1890:

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

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 ;
1890:
1891: /* Second insert: extra records which happened before start date active */

Line 1892: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');

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');
1893: fnd_message.set_token('table_name', l_table_name, FALSE);
1894: fnd_file.put_line(fnd_file.log,fnd_message.get);
1895: BEGIN
1896: INSERT INTO bim_r_fdsp_daily_facts fdf(

Line 1893: fnd_message.set_token('table_name', l_table_name, FALSE);

1889: END ;
1890:
1891: /* Second insert: extra records which happened before start date active */
1892: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
1893: fnd_message.set_token('table_name', l_table_name, FALSE);
1894: fnd_file.put_line(fnd_file.log,fnd_message.get);
1895: BEGIN
1896: INSERT INTO bim_r_fdsp_daily_facts fdf(
1897: spend_transaction_id

Line 1894: fnd_file.put_line(fnd_file.log,fnd_message.get);

1890:
1891: /* Second insert: extra records which happened before start date active */
1892: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
1893: fnd_message.set_token('table_name', l_table_name, FALSE);
1894: fnd_file.put_line(fnd_file.log,fnd_message.get);
1895: BEGIN
1896: INSERT INTO bim_r_fdsp_daily_facts fdf(
1897: spend_transaction_id
1898: ,creation_date

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

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;
2083: -- dbms_output.put_line('l_count'||l_count);

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

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;
2083: -- dbms_output.put_line('l_count'||l_count);
2084: fnd_message.set_name('BIM','BIM_R_CALL_PROC');

Line 2084: fnd_message.set_name('BIM','BIM_R_CALL_PROC');

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);
2086: fnd_file.put_line(fnd_file.log,fnd_message.get);
2087: /* Insert into history table */
2088: --IF l_count>0 THEN

Line 2085: fnd_message.set_token('proc_name', 'LOG_HISTORY', 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);
2086: fnd_file.put_line(fnd_file.log,fnd_message.get);
2087: /* Insert into history table */
2088: --IF l_count>0 THEN
2089: LOG_HISTORY(

Line 2086: fnd_file.put_line(fnd_file.log,fnd_message.get);

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);
2086: fnd_file.put_line(fnd_file.log,fnd_message.get);
2087: /* Insert into history table */
2088: --IF l_count>0 THEN
2089: LOG_HISTORY(
2090: 'FUND',

Line 2106: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');

2102: -- dbms_output.put_line('balancing');
2103:
2104: /* Insert into bim_r_fund_daily_facts the dates which are in bim_r_fdsp_daily_facts
2105: but not in bim_r_fund_daily_facts. */
2106: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
2107: fnd_message.set_token('table_name', 'BIM_R_FUND_DAILY_FACTS', FALSE);
2108: fnd_file.put_line(fnd_file.log,fnd_message.get);
2109: INSERT into bim_r_fund_daily_facts(
2110: fund_transaction_id

Line 2107: fnd_message.set_token('table_name', 'BIM_R_FUND_DAILY_FACTS', FALSE);

2103:
2104: /* Insert into bim_r_fund_daily_facts the dates which are in bim_r_fdsp_daily_facts
2105: but not in bim_r_fund_daily_facts. */
2106: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
2107: fnd_message.set_token('table_name', 'BIM_R_FUND_DAILY_FACTS', FALSE);
2108: fnd_file.put_line(fnd_file.log,fnd_message.get);
2109: INSERT into bim_r_fund_daily_facts(
2110: fund_transaction_id
2111: ,creation_date

Line 2108: fnd_file.put_line(fnd_file.log,fnd_message.get);

2104: /* Insert into bim_r_fund_daily_facts the dates which are in bim_r_fdsp_daily_facts
2105: but not in bim_r_fund_daily_facts. */
2106: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
2107: fnd_message.set_token('table_name', 'BIM_R_FUND_DAILY_FACTS', FALSE);
2108: fnd_file.put_line(fnd_file.log,fnd_message.get);
2109: INSERT into bim_r_fund_daily_facts(
2110: fund_transaction_id
2111: ,creation_date
2112: ,last_update_date

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

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

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

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);
2208: END;
2209: /* Start of inserting into 'bim_r_fund_weekly_facts'.

Line 2207: fnd_file.put_line(fnd_file.log,fnd_message.get);

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. */
2211: BEGIN

Line 2213: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');

2209: /* Start of inserting into 'bim_r_fund_weekly_facts'.
2210: Weekly table are summarized on daily tables. */
2211: BEGIN
2212: l_table_name :='bim_r_fund_weekly_facts';
2213: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
2214: fnd_message.set_token('table_name', l_table_name, FALSE);
2215: fnd_file.put_line(fnd_file.log,fnd_message.get);
2216: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_weekly_facts_s CACHE 1000';
2217: INSERT /*+ append parallel(fwf,p_para_num) */ INTO bim_r_fund_weekly_facts fwf(

Line 2214: fnd_message.set_token('table_name', l_table_name, FALSE);

2210: Weekly table are summarized on daily tables. */
2211: BEGIN
2212: l_table_name :='bim_r_fund_weekly_facts';
2213: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
2214: fnd_message.set_token('table_name', l_table_name, FALSE);
2215: fnd_file.put_line(fnd_file.log,fnd_message.get);
2216: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_weekly_facts_s CACHE 1000';
2217: INSERT /*+ append parallel(fwf,p_para_num) */ INTO bim_r_fund_weekly_facts fwf(
2218: fund_transaction_id

Line 2215: fnd_file.put_line(fnd_file.log,fnd_message.get);

2211: BEGIN
2212: l_table_name :='bim_r_fund_weekly_facts';
2213: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
2214: fnd_message.set_token('table_name', l_table_name, FALSE);
2215: fnd_file.put_line(fnd_file.log,fnd_message.get);
2216: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_weekly_facts_s CACHE 1000';
2217: INSERT /*+ append parallel(fwf,p_para_num) */ INTO bim_r_fund_weekly_facts fwf(
2218: fund_transaction_id
2219: ,creation_date

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

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;
2336: /* Insert into bim_r_fdsp_weekly_facts. */

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

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;
2336: /* Insert into bim_r_fdsp_weekly_facts. */
2337: BEGIN

Line 2339: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');

2335: END;
2336: /* Insert into bim_r_fdsp_weekly_facts. */
2337: BEGIN
2338: l_table_name :='bim_r_fdsp_weekly_facts';
2339: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
2340: fnd_message.set_token('table_name', l_table_name, FALSE);
2341: fnd_file.put_line(fnd_file.log,fnd_message.get);
2342: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_weekly_facts_s CACHE 1000';
2343: INSERT /*+ append parallel(fwf,p_para_num) */

Line 2340: fnd_message.set_token('table_name', l_table_name, FALSE);

2336: /* Insert into bim_r_fdsp_weekly_facts. */
2337: BEGIN
2338: l_table_name :='bim_r_fdsp_weekly_facts';
2339: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
2340: fnd_message.set_token('table_name', l_table_name, FALSE);
2341: fnd_file.put_line(fnd_file.log,fnd_message.get);
2342: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_weekly_facts_s CACHE 1000';
2343: INSERT /*+ append parallel(fwf,p_para_num) */
2344: INTO bim_r_fdsp_weekly_facts fwf(

Line 2341: fnd_file.put_line(fnd_file.log,fnd_message.get);

2337: BEGIN
2338: l_table_name :='bim_r_fdsp_weekly_facts';
2339: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
2340: fnd_message.set_token('table_name', l_table_name, FALSE);
2341: fnd_file.put_line(fnd_file.log,fnd_message.get);
2342: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_weekly_facts_s CACHE 1000';
2343: INSERT /*+ append parallel(fwf,p_para_num) */
2344: INTO bim_r_fdsp_weekly_facts fwf(
2345: spend_transaction_id

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

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;
2425:

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

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;
2425:
2426: fnd_message.set_name('BIM','BIM_R_RECREATE_INDEXES');

Line 2426: fnd_message.set_name('BIM','BIM_R_RECREATE_INDEXES');

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);
2428: /* Piece of Code for Recreating the index on the same tablespace with the same storage parameters */
2429: BEGIN
2430: i := i - 1;

Line 2427: fnd_file.put_line(fnd_file.log,fnd_message.get);

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);
2428: /* Piece of Code for Recreating the index on the same tablespace with the same storage parameters */
2429: BEGIN
2430: i := i - 1;
2431: WHILE(i>=1) LOOP

Line 2497: fnd_message.set_name('BIM','BIM_R_CALL_PROC');

2493: BEGIN
2494: DBMS_STATS.gather_table_stats('BIM','BIM_R_FDSP_WEEKLY_FACTS', estimate_percent => 5,
2495: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
2496: END;
2497: fnd_message.set_name('BIM','BIM_R_CALL_PROC');
2498: fnd_message.set_token('proc_name', 'UPDATE_BALANCE', FALSE);
2499: fnd_file.put_line(fnd_file.log,fnd_message.get);
2500: update_balance;
2501: EXECUTE IMMEDIATE 'COMMIT';

Line 2498: fnd_message.set_token('proc_name', 'UPDATE_BALANCE', FALSE);

2494: DBMS_STATS.gather_table_stats('BIM','BIM_R_FDSP_WEEKLY_FACTS', estimate_percent => 5,
2495: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
2496: END;
2497: fnd_message.set_name('BIM','BIM_R_CALL_PROC');
2498: fnd_message.set_token('proc_name', 'UPDATE_BALANCE', FALSE);
2499: fnd_file.put_line(fnd_file.log,fnd_message.get);
2500: update_balance;
2501: EXECUTE IMMEDIATE 'COMMIT';
2502: fnd_message.set_name('BIM','BIM_R_PROG_COMPLETION');

Line 2499: fnd_file.put_line(fnd_file.log,fnd_message.get);

2495: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
2496: END;
2497: fnd_message.set_name('BIM','BIM_R_CALL_PROC');
2498: fnd_message.set_token('proc_name', 'UPDATE_BALANCE', FALSE);
2499: fnd_file.put_line(fnd_file.log,fnd_message.get);
2500: update_balance;
2501: EXECUTE IMMEDIATE 'COMMIT';
2502: fnd_message.set_name('BIM','BIM_R_PROG_COMPLETION');
2503: fnd_message.set_token('program_name', 'Fund first load', FALSE);

Line 2502: fnd_message.set_name('BIM','BIM_R_PROG_COMPLETION');

2498: fnd_message.set_token('proc_name', 'UPDATE_BALANCE', FALSE);
2499: fnd_file.put_line(fnd_file.log,fnd_message.get);
2500: update_balance;
2501: EXECUTE IMMEDIATE 'COMMIT';
2502: fnd_message.set_name('BIM','BIM_R_PROG_COMPLETION');
2503: fnd_message.set_token('program_name', 'Fund first load', FALSE);
2504: fnd_file.put_line(fnd_file.log,fnd_message.get);
2505: END FUND_FIRST_LOAD;
2506:

Line 2503: fnd_message.set_token('program_name', 'Fund first load', FALSE);

2499: fnd_file.put_line(fnd_file.log,fnd_message.get);
2500: update_balance;
2501: EXECUTE IMMEDIATE 'COMMIT';
2502: fnd_message.set_name('BIM','BIM_R_PROG_COMPLETION');
2503: fnd_message.set_token('program_name', 'Fund first load', FALSE);
2504: fnd_file.put_line(fnd_file.log,fnd_message.get);
2505: END FUND_FIRST_LOAD;
2506:
2507:

Line 2504: fnd_file.put_line(fnd_file.log,fnd_message.get);

2500: update_balance;
2501: EXECUTE IMMEDIATE 'COMMIT';
2502: fnd_message.set_name('BIM','BIM_R_PROG_COMPLETION');
2503: fnd_message.set_token('program_name', 'Fund first load', FALSE);
2504: fnd_file.put_line(fnd_file.log,fnd_message.get);
2505: END FUND_FIRST_LOAD;
2506:
2507:
2508: ---------------------------------------------------------------------

Line 2566: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');

2562: ELSE
2563: l_end_date :=p_end_datel;
2564: END IF;
2565: l_table_name :='bim_r_fund_daily_facts';
2566: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
2567: fnd_message.set_token('table_name', l_table_name, FALSE);
2568: fnd_file.put_line(fnd_file.log,fnd_message.get);
2569: --dbms_output.put_line('b4 first inserting into fund daily');
2570:

Line 2567: fnd_message.set_token('table_name', l_table_name, FALSE);

2563: l_end_date :=p_end_datel;
2564: END IF;
2565: l_table_name :='bim_r_fund_daily_facts';
2566: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
2567: fnd_message.set_token('table_name', l_table_name, FALSE);
2568: fnd_file.put_line(fnd_file.log,fnd_message.get);
2569: --dbms_output.put_line('b4 first inserting into fund daily');
2570:
2571: BEGIN -- Alter table for performance reasons

Line 2568: fnd_file.put_line(fnd_file.log,fnd_message.get);

2564: END IF;
2565: l_table_name :='bim_r_fund_daily_facts';
2566: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
2567: fnd_message.set_token('table_name', l_table_name, FALSE);
2568: fnd_file.put_line(fnd_file.log,fnd_message.get);
2569: --dbms_output.put_line('b4 first inserting into fund daily');
2570:
2571: BEGIN -- Alter table for performance reasons
2572: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_fund_daily_facts nologging';

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

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;
2806:

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

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;
2806:
2807: /*Second insert: For funds whose active date is between p_start_date and p_end_date, insert

Line 2809: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');

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 */
2809: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
2810: fnd_message.set_token('table_name', l_table_name, FALSE);
2811: fnd_file.put_line(fnd_file.log,fnd_message.get);
2812: BEGIN
2813: INSERT /*+ append parallel(fdf,p_para_num) */

Line 2810: fnd_message.set_token('table_name', l_table_name, FALSE);

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 */
2809: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
2810: fnd_message.set_token('table_name', l_table_name, FALSE);
2811: fnd_file.put_line(fnd_file.log,fnd_message.get);
2812: BEGIN
2813: INSERT /*+ append parallel(fdf,p_para_num) */
2814: INTO bim_r_fund_daily_facts fdf(

Line 2811: fnd_file.put_line(fnd_file.log,fnd_message.get);

2807: /*Second insert: For funds whose active date is between p_start_date and p_end_date, insert
2808: transactions happened before active date */
2809: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
2810: fnd_message.set_token('table_name', l_table_name, FALSE);
2811: fnd_file.put_line(fnd_file.log,fnd_message.get);
2812: BEGIN
2813: INSERT /*+ append parallel(fdf,p_para_num) */
2814: INTO bim_r_fund_daily_facts fdf(
2815: fund_transaction_id

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

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;
3041:

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

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;
3041:
3042: /* insert dummy 0s for dates between p_start_date/start_date_active and p_end_date/end_date_active,

Line 3044: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');

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.*/
3044: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
3045: fnd_message.set_token('table_name', l_table_name, FALSE);
3046: fnd_file.put_line(fnd_file.log,fnd_message.get);
3047: BEGIN
3048: INSERT /*+ append parallel(fdf,p_para_num) */

Line 3045: fnd_message.set_token('table_name', l_table_name, FALSE);

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.*/
3044: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
3045: fnd_message.set_token('table_name', l_table_name, FALSE);
3046: fnd_file.put_line(fnd_file.log,fnd_message.get);
3047: BEGIN
3048: INSERT /*+ append parallel(fdf,p_para_num) */
3049: INTO bim_r_fund_daily_facts fdf(

Line 3046: fnd_file.put_line(fnd_file.log,fnd_message.get);

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.*/
3044: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
3045: fnd_message.set_token('table_name', l_table_name, FALSE);
3046: fnd_file.put_line(fnd_file.log,fnd_message.get);
3047: BEGIN
3048: INSERT /*+ append parallel(fdf,p_para_num) */
3049: INTO bim_r_fund_daily_facts fdf(
3050: fund_transaction_id

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

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;
3163:

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

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;
3163:
3164: /* insert dummy 0s for funds created between p_start_datel and p_end_datel,

Line 3167: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');

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,
3166: but has no transactions.*/
3167: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
3168: fnd_message.set_token('table_name', l_table_name, FALSE);
3169: fnd_file.put_line(fnd_file.log,fnd_message.get);
3170: BEGIN
3171: INSERT /*+ append parallel(fdf,p_para_num) */

Line 3168: fnd_message.set_token('table_name', l_table_name, FALSE);

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,
3166: but has no transactions.*/
3167: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
3168: fnd_message.set_token('table_name', l_table_name, FALSE);
3169: fnd_file.put_line(fnd_file.log,fnd_message.get);
3170: BEGIN
3171: INSERT /*+ append parallel(fdf,p_para_num) */
3172: INTO bim_r_fund_daily_facts fdf(

Line 3169: fnd_file.put_line(fnd_file.log,fnd_message.get);

3165: and in those dates between p_start_date/start_date_active and p_end_date/end_date_active,
3166: but has no transactions.*/
3167: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
3168: fnd_message.set_token('table_name', l_table_name, FALSE);
3169: fnd_file.put_line(fnd_file.log,fnd_message.get);
3170: BEGIN
3171: INSERT /*+ append parallel(fdf,p_para_num) */
3172: INTO bim_r_fund_daily_facts fdf(
3173: fund_transaction_id

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

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;
3291:

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

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;
3291:
3292: /* Inserting into 'bim_r_fdsp_load' all the objects information */

Line 3294: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');

3290: END;
3291:
3292: /* Inserting into 'bim_r_fdsp_load' all the objects information */
3293: l_table_name :='bim_r_fdsp_daily_facts';
3294: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
3295: fnd_message.set_token('table_name', 'bim_r_fdsp_load', FALSE);
3296: fnd_file.put_line(fnd_file.log,fnd_message.get);
3297: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_daily_facts_s CACHE 1000';
3298: EXECUTE IMMEDIATE 'truncate table '||l_schema||'.bim_r_fdsp_load';

Line 3295: fnd_message.set_token('table_name', 'bim_r_fdsp_load', FALSE);

3291:
3292: /* Inserting into 'bim_r_fdsp_load' all the objects information */
3293: l_table_name :='bim_r_fdsp_daily_facts';
3294: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
3295: fnd_message.set_token('table_name', 'bim_r_fdsp_load', FALSE);
3296: fnd_file.put_line(fnd_file.log,fnd_message.get);
3297: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_daily_facts_s CACHE 1000';
3298: EXECUTE IMMEDIATE 'truncate table '||l_schema||'.bim_r_fdsp_load';
3299: BEGIN

Line 3296: fnd_file.put_line(fnd_file.log,fnd_message.get);

3292: /* Inserting into 'bim_r_fdsp_load' all the objects information */
3293: l_table_name :='bim_r_fdsp_daily_facts';
3294: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
3295: fnd_message.set_token('table_name', 'bim_r_fdsp_load', FALSE);
3296: fnd_file.put_line(fnd_file.log,fnd_message.get);
3297: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_daily_facts_s CACHE 1000';
3298: EXECUTE IMMEDIATE 'truncate table '||l_schema||'.bim_r_fdsp_load';
3299: BEGIN
3300: INSERT /*+ append parallel(bfl,p_para_num) */

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

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.
3436:

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

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.
3436:
3437: --dbms_output.put_line('inside fist inserting into fdsp daily');

Line 3440: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');

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
3439: p_start_date and p_end_date */
3440: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
3441: fnd_message.set_token('table_name', l_table_name, FALSE);
3442: fnd_file.put_line(fnd_file.log,fnd_message.get);
3443: BEGIN
3444: INSERT /*+ append parallel(fdf,p_para_num) */

Line 3441: fnd_message.set_token('table_name', l_table_name, FALSE);

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
3439: p_start_date and p_end_date */
3440: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
3441: fnd_message.set_token('table_name', l_table_name, FALSE);
3442: fnd_file.put_line(fnd_file.log,fnd_message.get);
3443: BEGIN
3444: INSERT /*+ append parallel(fdf,p_para_num) */
3445: INTO bim_r_fdsp_daily_facts fdf(

Line 3442: fnd_file.put_line(fnd_file.log,fnd_message.get);

3438: /* First insert:Insert into 'bim_r_fdsp_daily_facts' the transactions happend between
3439: p_start_date and p_end_date */
3440: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
3441: fnd_message.set_token('table_name', l_table_name, FALSE);
3442: fnd_file.put_line(fnd_file.log,fnd_message.get);
3443: BEGIN
3444: INSERT /*+ append parallel(fdf,p_para_num) */
3445: INTO bim_r_fdsp_daily_facts fdf(
3446: spend_transaction_id

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

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 ;
3633:

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

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 ;
3633:
3634: /* Second insert: Insert extra records which happened before start date active */

Line 3635: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');

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');
3636: fnd_message.set_token('table_name', l_table_name, FALSE);
3637: fnd_file.put_line(fnd_file.log,fnd_message.get);
3638: BEGIN
3639: INSERT /*+ append parallel(fdf,p_para_num) */

Line 3636: fnd_message.set_token('table_name', l_table_name, FALSE);

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');
3636: fnd_message.set_token('table_name', l_table_name, FALSE);
3637: fnd_file.put_line(fnd_file.log,fnd_message.get);
3638: BEGIN
3639: INSERT /*+ append parallel(fdf,p_para_num) */
3640: INTO bim_r_fdsp_daily_facts fdf(

Line 3637: fnd_file.put_line(fnd_file.log,fnd_message.get);

3633:
3634: /* Second insert: Insert extra records which happened before start date active */
3635: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
3636: fnd_message.set_token('table_name', l_table_name, FALSE);
3637: fnd_file.put_line(fnd_file.log,fnd_message.get);
3638: BEGIN
3639: INSERT /*+ append parallel(fdf,p_para_num) */
3640: INTO bim_r_fdsp_daily_facts fdf(
3641: spend_transaction_id

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

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;
3827:

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

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;
3827:
3828: /* Insert dummy 0s for the dates between p_start_date/start_date_active and p_end_date/end_date_active,

Line 3830: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');

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. */
3830: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
3831: fnd_message.set_token('table_name', l_table_name, FALSE);
3832: fnd_file.put_line(fnd_file.log,fnd_message.get);
3833: BEGIN
3834: INSERT /*+ append parallel(fdf,p_para_num) */

Line 3831: fnd_message.set_token('table_name', l_table_name, FALSE);

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. */
3830: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
3831: fnd_message.set_token('table_name', l_table_name, FALSE);
3832: fnd_file.put_line(fnd_file.log,fnd_message.get);
3833: BEGIN
3834: INSERT /*+ append parallel(fdf,p_para_num) */
3835: INTO bim_r_fdsp_daily_facts fdf(

Line 3832: fnd_file.put_line(fnd_file.log,fnd_message.get);

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. */
3830: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
3831: fnd_message.set_token('table_name', l_table_name, FALSE);
3832: fnd_file.put_line(fnd_file.log,fnd_message.get);
3833: BEGIN
3834: INSERT /*+ append parallel(fdf,p_para_num) */
3835: INTO bim_r_fdsp_daily_facts fdf(
3836: spend_transaction_id

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

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;
3919:

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

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;
3919:
3920: /* Insert into bim_r_fdsp_daily_facts the dates which are in bim_r_fund_daily_facts

Line 3922: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');

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. */
3922: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
3923: fnd_message.set_token('table_name', l_table_name, FALSE);
3924: fnd_file.put_line(fnd_file.log,fnd_message.get);
3925: BEGIN --insert into fdsp for balancing
3926: l_table_name :='bim_r_fdsp_daily_facts';

Line 3923: fnd_message.set_token('table_name', l_table_name, FALSE);

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. */
3922: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
3923: fnd_message.set_token('table_name', l_table_name, FALSE);
3924: fnd_file.put_line(fnd_file.log,fnd_message.get);
3925: BEGIN --insert into fdsp for balancing
3926: l_table_name :='bim_r_fdsp_daily_facts';
3927: INSERT /*+ append parallel(fdf,p_para_num) */

Line 3924: fnd_file.put_line(fnd_file.log,fnd_message.get);

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. */
3922: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
3923: fnd_message.set_token('table_name', l_table_name, FALSE);
3924: fnd_file.put_line(fnd_file.log,fnd_message.get);
3925: BEGIN --insert into fdsp for balancing
3926: l_table_name :='bim_r_fdsp_daily_facts';
3927: INSERT /*+ append parallel(fdf,p_para_num) */
3928: INTO bim_r_fdsp_daily_facts fdf(

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

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;
3999: --Insert dummy records into bim_r_fund_daily_facts for balancing

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

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

Line 4004: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');

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 */
4002: BEGIN
4003: l_table_name :='bim_r_fund_daily_facts';
4004: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
4005: fnd_message.set_token('table_name', l_table_name, FALSE);
4006: fnd_file.put_line(fnd_file.log,fnd_message.get);
4007: INSERT into bim_r_fund_daily_facts(
4008: fund_transaction_id

Line 4005: fnd_message.set_token('table_name', l_table_name, FALSE);

4001: but not in bim_r_fund_daily_facts */
4002: BEGIN
4003: l_table_name :='bim_r_fund_daily_facts';
4004: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
4005: fnd_message.set_token('table_name', l_table_name, FALSE);
4006: fnd_file.put_line(fnd_file.log,fnd_message.get);
4007: INSERT into bim_r_fund_daily_facts(
4008: fund_transaction_id
4009: ,creation_date

Line 4006: fnd_file.put_line(fnd_file.log,fnd_message.get);

4002: BEGIN
4003: l_table_name :='bim_r_fund_daily_facts';
4004: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
4005: fnd_message.set_token('table_name', l_table_name, FALSE);
4006: fnd_file.put_line(fnd_file.log,fnd_message.get);
4007: INSERT into bim_r_fund_daily_facts(
4008: fund_transaction_id
4009: ,creation_date
4010: ,last_update_date

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

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;
4106:

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

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;
4106:
4107: --Insert into history table.

Line 4122: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');

4118: EXECUTE IMMEDIATE 'truncate table '||l_schema||'.bim_r_fund_weekly_facts';
4119: --Start of inserting into 'bim_r_fund_weekly_facts'
4120: BEGIN
4121: l_table_name :='bim_r_fund_weekly_facts';
4122: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
4123: fnd_message.set_token('table_name', l_table_name, FALSE);
4124: fnd_file.put_line(fnd_file.log,fnd_message.get);
4125: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_weekly_facts_s CACHE 1000';
4126: INSERT /*+ append parallel(fwf,p_para_num) */ INTO bim_r_fund_weekly_facts fwf(

Line 4123: fnd_message.set_token('table_name', l_table_name, FALSE);

4119: --Start of inserting into 'bim_r_fund_weekly_facts'
4120: BEGIN
4121: l_table_name :='bim_r_fund_weekly_facts';
4122: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
4123: fnd_message.set_token('table_name', l_table_name, FALSE);
4124: fnd_file.put_line(fnd_file.log,fnd_message.get);
4125: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_weekly_facts_s CACHE 1000';
4126: INSERT /*+ append parallel(fwf,p_para_num) */ INTO bim_r_fund_weekly_facts fwf(
4127: fund_transaction_id

Line 4124: fnd_file.put_line(fnd_file.log,fnd_message.get);

4120: BEGIN
4121: l_table_name :='bim_r_fund_weekly_facts';
4122: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
4123: fnd_message.set_token('table_name', l_table_name, FALSE);
4124: fnd_file.put_line(fnd_file.log,fnd_message.get);
4125: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_weekly_facts_s CACHE 1000';
4126: INSERT /*+ append parallel(fwf,p_para_num) */ INTO bim_r_fund_weekly_facts fwf(
4127: fund_transaction_id
4128: ,creation_date

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

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;
4245: BEGIN

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

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;
4245: BEGIN
4246: EXECUTE IMMEDIATE 'truncate table '||l_schema||'.bim_r_fdsp_weekly_facts';

Line 4248: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');

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';
4248: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
4249: fnd_message.set_token('table_name', l_table_name, FALSE);
4250: fnd_file.put_line(fnd_file.log,fnd_message.get);
4251: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_weekly_facts_s CACHE 1000';
4252: --dbms_output.put_line('inside fist inserting into fdsp weekly');

Line 4249: fnd_message.set_token('table_name', l_table_name, FALSE);

4245: BEGIN
4246: EXECUTE IMMEDIATE 'truncate table '||l_schema||'.bim_r_fdsp_weekly_facts';
4247: l_table_name :='bim_r_fdsp_weekly_facts';
4248: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
4249: fnd_message.set_token('table_name', l_table_name, FALSE);
4250: fnd_file.put_line(fnd_file.log,fnd_message.get);
4251: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_weekly_facts_s CACHE 1000';
4252: --dbms_output.put_line('inside fist inserting into fdsp weekly');
4253:

Line 4250: fnd_file.put_line(fnd_file.log,fnd_message.get);

4246: EXECUTE IMMEDIATE 'truncate table '||l_schema||'.bim_r_fdsp_weekly_facts';
4247: l_table_name :='bim_r_fdsp_weekly_facts';
4248: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
4249: fnd_message.set_token('table_name', l_table_name, FALSE);
4250: fnd_file.put_line(fnd_file.log,fnd_message.get);
4251: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_weekly_facts_s CACHE 1000';
4252: --dbms_output.put_line('inside fist inserting into fdsp weekly');
4253:
4254: --Insert into bim_r_fdsp_weekly_facts

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

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;
4337: -- for performance reasons

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

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;
4337: -- for performance reasons
4338: BEGIN

Line 4366: fnd_message.set_name('BIM','BIM_R_CALL_PROC');

4362: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
4363: END;
4364:
4365: --call update subsequent balance
4366: fnd_message.set_name('BIM','BIM_R_CALL_PROC');
4367: fnd_message.set_token('proc_name', 'UPDATE_SUB_BALANCE', FALSE);
4368: fnd_file.put_line(fnd_file.log,fnd_message.get);
4369: update_sub_balance(p_start_datel, p_end_datel);
4370: fnd_message.set_name('BIM','BIM_R_PROG_COMPLETION');

Line 4367: fnd_message.set_token('proc_name', 'UPDATE_SUB_BALANCE', FALSE);

4363: END;
4364:
4365: --call update subsequent balance
4366: fnd_message.set_name('BIM','BIM_R_CALL_PROC');
4367: fnd_message.set_token('proc_name', 'UPDATE_SUB_BALANCE', FALSE);
4368: fnd_file.put_line(fnd_file.log,fnd_message.get);
4369: update_sub_balance(p_start_datel, p_end_datel);
4370: fnd_message.set_name('BIM','BIM_R_PROG_COMPLETION');
4371: fnd_message.set_token('program_name', 'Fund first load', FALSE);

Line 4368: fnd_file.put_line(fnd_file.log,fnd_message.get);

4364:
4365: --call update subsequent balance
4366: fnd_message.set_name('BIM','BIM_R_CALL_PROC');
4367: fnd_message.set_token('proc_name', 'UPDATE_SUB_BALANCE', FALSE);
4368: fnd_file.put_line(fnd_file.log,fnd_message.get);
4369: update_sub_balance(p_start_datel, p_end_datel);
4370: fnd_message.set_name('BIM','BIM_R_PROG_COMPLETION');
4371: fnd_message.set_token('program_name', 'Fund first load', FALSE);
4372: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 4370: fnd_message.set_name('BIM','BIM_R_PROG_COMPLETION');

4366: fnd_message.set_name('BIM','BIM_R_CALL_PROC');
4367: fnd_message.set_token('proc_name', 'UPDATE_SUB_BALANCE', FALSE);
4368: fnd_file.put_line(fnd_file.log,fnd_message.get);
4369: update_sub_balance(p_start_datel, p_end_datel);
4370: fnd_message.set_name('BIM','BIM_R_PROG_COMPLETION');
4371: fnd_message.set_token('program_name', 'Fund first load', FALSE);
4372: fnd_file.put_line(fnd_file.log,fnd_message.get);
4373: END FUND_SUB_LOAD;
4374: END BIM_FUND_FACTS;

Line 4371: fnd_message.set_token('program_name', 'Fund first load', FALSE);

4367: fnd_message.set_token('proc_name', 'UPDATE_SUB_BALANCE', FALSE);
4368: fnd_file.put_line(fnd_file.log,fnd_message.get);
4369: update_sub_balance(p_start_datel, p_end_datel);
4370: fnd_message.set_name('BIM','BIM_R_PROG_COMPLETION');
4371: fnd_message.set_token('program_name', 'Fund first load', FALSE);
4372: fnd_file.put_line(fnd_file.log,fnd_message.get);
4373: END FUND_SUB_LOAD;
4374: END BIM_FUND_FACTS;

Line 4372: fnd_file.put_line(fnd_file.log,fnd_message.get);

4368: fnd_file.put_line(fnd_file.log,fnd_message.get);
4369: update_sub_balance(p_start_datel, p_end_datel);
4370: fnd_message.set_name('BIM','BIM_R_PROG_COMPLETION');
4371: fnd_message.set_token('program_name', 'Fund first load', FALSE);
4372: fnd_file.put_line(fnd_file.log,fnd_message.get);
4373: END FUND_SUB_LOAD;
4374: END BIM_FUND_FACTS;