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_FILE

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 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 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 355: FND_FILE.put_line(fnd_file.log,'error alter table in balance'||sqlerrm(sqlcode));

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';
353: EXCEPTION
354: WHEN OTHERS THEN
355: FND_FILE.put_line(fnd_file.log,'error alter table in balance'||sqlerrm(sqlcode));
356: END;
357:
358: SELECT i.index_tablespace into l_index_tablespace
359: FROM fnd_product_installations i, fnd_application a

Line 465: FND_FILE.put_line(fnd_file.log,'error updateing delta balance'||sqlerrm(sqlcode));

461: and ba.fund_id = a.fund_id;
462: END LOOP;
463: EXCEPTION
464: WHEN OTHERS THEN
465: FND_FILE.put_line(fnd_file.log,'error updateing delta balance'||sqlerrm(sqlcode));
466: END;
467:
468: --Insert new funds which don't have entries in bim_r_fund_balance.
469: BEGIN

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 575: FND_FILE.put_line(fnd_file.log,'error updateing new balance'||sqlerrm(sqlcode));

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;
577: END update_sub_balance;
578:
579: ---------------------------------------------------------------------

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 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 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 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 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 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 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 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 967: FND_FILE.put_line(fnd_file.log,'error dropping index'||sqlerrm(sqlcode));

963: END LOOP;
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

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

1529: EXECUTE IMMEDIATE 'commit';
1530: --End inserting transactions happened before start_date
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);

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 1678: FND_FILE.put_line(fnd_file.log,'error insert fdsp daily'||sqlerrm(sqlcode));

1674: ) act_util;
1675: EXECUTE IMMEDIATE 'COMMIT';
1676: EXCEPTION
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');

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 1882: FND_FILE.put_line(fnd_file.log,'error insert fdsp daily'||sqlerrm(sqlcode));

1878: EXECUTE IMMEDIATE 'COMMIT';
1879: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_daily_facts_s CACHE 20';
1880: EXCEPTION
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');

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

2072: l_count :=l_count+SQL%ROWCOUNT;
2073: EXECUTE IMMEDIATE 'commit';
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);

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

2197: WHERE b2.fund_id = a.fund_id;
2198: EXECUTE IMMEDIATE 'commit';
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);

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 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 2328: FND_FILE.put_line(fnd_file.log,'Error insertg fund weekly:'||sqlerrm(sqlcode));

2324: EXECUTE IMMEDIATE 'commit';
2325: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_weekly_facts_s CACHE 20';
2326: EXCEPTION
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');

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 2417: FND_FILE.put_line(fnd_file.log,'error insert fdsp_weekly'||sqlerrm(sqlcode));

2413: EXECUTE IMMEDIATE 'commit';
2414: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_weekly_facts_s CACHE 20';
2415: EXCEPTION
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');

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 2468: --FND_FILE.put_line(fnd_file.log,'error creating all indexes'||sqlerrm(sqlcode));

2464: END LOOP;
2465: EXCEPTION
2466: WHEN OTHERS THEN
2467: null;
2468: --FND_FILE.put_line(fnd_file.log,'error creating all indexes'||sqlerrm(sqlcode));
2469: -- DBMS_OUTPUT.PUT_LINE(sqlerrm(sqlcode));
2470: END;
2471:
2472: -- For performance reasons.

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 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 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 2798: FND_FILE.put_line(fnd_file.log,'error insert into fund_daily'||sqlerrm(sqlcode));

2794: EXECUTE IMMEDIATE 'COMMIT';
2795: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_daily_facts_s CACHE 20';
2796: EXCEPTION
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');

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

3030: EXECUTE IMMEDIATE 'commit';
3031: --End inserting transactions happened before start_date
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);

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

3152: l_count :=l_count +SQL%ROWCOUNT;
3153: EXECUTE IMMEDIATE 'commit';
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);

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

3280: l_count :=l_count +SQL%ROWCOUNT;
3281: EXECUTE IMMEDIATE 'commit';
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);

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 3428: FND_FILE.put_line(fnd_file.log,'error insert fdsp daily'||sqlerrm(sqlcode));

3424: ) act_util;
3425: EXECUTE IMMEDIATE 'COMMIT';
3426: EXCEPTION
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');

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 3625: FND_FILE.put_line(fnd_file.log,'first insert:error insert fdsp daily'||sqlerrm(sqlcode));

3621: EXECUTE IMMEDIATE 'COMMIT';
3622: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_daily_facts_s CACHE 20';
3623: EXCEPTION
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');

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

3816: l_count :=l_count+SQL%ROWCOUNT;
3817: EXECUTE IMMEDIATE 'commit';
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);

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

3908: -- dbms_output.put_line('missing fdsp:l_count'||l_count);
3909: EXECUTE IMMEDIATE 'commit';
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);

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

3988: AND b1.transaction_create_date = b2.transaction_create_date ;
3989: EXECUTE IMMEDIATE 'commit';
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);

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

4095: WHERE b2.fund_id = a.fund_id;
4096: EXECUTE IMMEDIATE 'commit';
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);

Line 4108: FND_FILE.put_line(fnd_file.log,'Insert into log history');

4104: FND_MSG_PUB.Add;
4105: END;
4106:
4107: --Insert into history table.
4108: FND_FILE.put_line(fnd_file.log,'Insert into log history');
4109: -- IF l_count>0 THEN
4110: LOG_HISTORY(
4111: 'FUND',
4112: p_start_datel,

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 4237: FND_FILE.put_line(fnd_file.log,'Error insertg fund weekly:'||sqlerrm(sqlcode));

4233: EXECUTE IMMEDIATE 'commit';
4234: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fund_weekly_facts_s CACHE 20';
4235: EXCEPTION
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');

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 4329: FND_FILE.put_line(fnd_file.log,'error insert fdsp_weekly'||sqlerrm(sqlcode));

4325: EXECUTE IMMEDIATE 'commit';
4326: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_weekly_facts_s CACHE 20';
4327: EXCEPTION
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');

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