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.CE_BANK_ACCT_BALANCE_REPORT dependencies on FND_FILE

Line 60: --fnd_file.put_line(FND_FILE.LOG, p_bank_account_id);

56:
57: begin
58:
59: v_date := p_date;
60: --fnd_file.put_line(FND_FILE.LOG, p_bank_account_id);
61: --fnd_file.put_line(fnd_file.log, 'as of date ' || to_char(p_date, 'YYYY/MM/DD HH24:MI:SS'));
62: --fnd_file.put_line(fnd_file.log, 'balance type ' || p_balance_type);
63: --fnd_file.put_line(fnd_file.log, 'exchange rate type ' || p_exchange_rate_type);
64:

Line 61: --fnd_file.put_line(fnd_file.log, 'as of date ' || to_char(p_date, 'YYYY/MM/DD HH24:MI:SS'));

57: begin
58:
59: v_date := p_date;
60: --fnd_file.put_line(FND_FILE.LOG, p_bank_account_id);
61: --fnd_file.put_line(fnd_file.log, 'as of date ' || to_char(p_date, 'YYYY/MM/DD HH24:MI:SS'));
62: --fnd_file.put_line(fnd_file.log, 'balance type ' || p_balance_type);
63: --fnd_file.put_line(fnd_file.log, 'exchange rate type ' || p_exchange_rate_type);
64:
65: /*

Line 62: --fnd_file.put_line(fnd_file.log, 'balance type ' || p_balance_type);

58:
59: v_date := p_date;
60: --fnd_file.put_line(FND_FILE.LOG, p_bank_account_id);
61: --fnd_file.put_line(fnd_file.log, 'as of date ' || to_char(p_date, 'YYYY/MM/DD HH24:MI:SS'));
62: --fnd_file.put_line(fnd_file.log, 'balance type ' || p_balance_type);
63: --fnd_file.put_line(fnd_file.log, 'exchange rate type ' || p_exchange_rate_type);
64:
65: /*
66: v_LegerBalanceAC number;

Line 63: --fnd_file.put_line(fnd_file.log, 'exchange rate type ' || p_exchange_rate_type);

59: v_date := p_date;
60: --fnd_file.put_line(FND_FILE.LOG, p_bank_account_id);
61: --fnd_file.put_line(fnd_file.log, 'as of date ' || to_char(p_date, 'YYYY/MM/DD HH24:MI:SS'));
62: --fnd_file.put_line(fnd_file.log, 'balance type ' || p_balance_type);
63: --fnd_file.put_line(fnd_file.log, 'exchange rate type ' || p_exchange_rate_type);
64:
65: /*
66: v_LegerBalanceAC number;
67: v_AvailableBalanceAC number;

Line 126: --fnd_file.put_line(fnd_file.log, 'v balance ' || v_balance);

122: from ce_bank_acct_balances
123: where BANK_ACCOUNT_ID = p_bank_account_id
124: and BALANCE_DATE = v_date;
125:
126: --fnd_file.put_line(fnd_file.log, 'v balance ' || v_balance);
127:
128: end if;
129: end if;
130:

Line 448: --fnd_file.put_line(FND_FILE.LOG, 'start single day reporting processing');

444:
445: n_loop number :=0;
446:
447: begin
448: --fnd_file.put_line(FND_FILE.LOG, 'start single day reporting processing');
449: --fnd_file.put_line(fnd_file.log, 'as of date ' || to_char(to_date(p_as_of_date, 'YYYY/MM/DD HH24:MI:SS')));
450: --fnd_file.put_line(fnd_file.log, 'reportint currency ' || p_reporting_currency);
451: --fnd_file.put_line(fnd_file.log, 'exchange rate type ' || p_exchange_rate_type);
452:

Line 449: --fnd_file.put_line(fnd_file.log, 'as of date ' || to_char(to_date(p_as_of_date, 'YYYY/MM/DD HH24:MI:SS')));

445: n_loop number :=0;
446:
447: begin
448: --fnd_file.put_line(FND_FILE.LOG, 'start single day reporting processing');
449: --fnd_file.put_line(fnd_file.log, 'as of date ' || to_char(to_date(p_as_of_date, 'YYYY/MM/DD HH24:MI:SS')));
450: --fnd_file.put_line(fnd_file.log, 'reportint currency ' || p_reporting_currency);
451: --fnd_file.put_line(fnd_file.log, 'exchange rate type ' || p_exchange_rate_type);
452:
453: -- populate ce_security_profiles_gt table with ce_security_procfiles_v

Line 450: --fnd_file.put_line(fnd_file.log, 'reportint currency ' || p_reporting_currency);

446:
447: begin
448: --fnd_file.put_line(FND_FILE.LOG, 'start single day reporting processing');
449: --fnd_file.put_line(fnd_file.log, 'as of date ' || to_char(to_date(p_as_of_date, 'YYYY/MM/DD HH24:MI:SS')));
450: --fnd_file.put_line(fnd_file.log, 'reportint currency ' || p_reporting_currency);
451: --fnd_file.put_line(fnd_file.log, 'exchange rate type ' || p_exchange_rate_type);
452:
453: -- populate ce_security_profiles_gt table with ce_security_procfiles_v
454: -- CEP_STANDARD.init_security;

Line 451: --fnd_file.put_line(fnd_file.log, 'exchange rate type ' || p_exchange_rate_type);

447: begin
448: --fnd_file.put_line(FND_FILE.LOG, 'start single day reporting processing');
449: --fnd_file.put_line(fnd_file.log, 'as of date ' || to_char(to_date(p_as_of_date, 'YYYY/MM/DD HH24:MI:SS')));
450: --fnd_file.put_line(fnd_file.log, 'reportint currency ' || p_reporting_currency);
451: --fnd_file.put_line(fnd_file.log, 'exchange rate type ' || p_exchange_rate_type);
452:
453: -- populate ce_security_profiles_gt table with ce_security_procfiles_v
454: -- CEP_STANDARD.init_security;
455:

Line 465: --fnd_file.put_line(fnd_file.log, 'l_total_balance_flag '||to_char(l_total_balance_flag));

461: l_date := to_date(p_as_of_date, 'YYYY/MM/DD HH24:MI:SS');
462:
463: -- get total_balance_flag, 1 when exchange rate exists for all currencies for query conditions
464: l_total_balance_flag := get_total_balance_flag(p_branch_party_id,p_bank_acct_id,p_bank_acct_currency,p_legal_entity_id,l_date,p_reporting_currency,p_exchange_rate_type,nvl(p_exchange_rate_date,to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS')));
465: --fnd_file.put_line(fnd_file.log, 'l_total_balance_flag '||to_char(l_total_balance_flag));
466:
467: -- get bank branch name
468: if p_branch_party_id is not null then
469: select BANK_BRANCH_NAME

Line 536: fnd_file.put_line(FND_FILE.LOG, 'n_loop ' || n_loop);

532: v_AvgAvailableMTDSubTRC := null;
533: v_AvgAvailableYTDSubTRC := null;
534:
535: n_loop := n_loop+1;
536: fnd_file.put_line(FND_FILE.LOG, 'n_loop ' || n_loop);
537: fnd_file.put_line(FND_FILE.LOG, 'currency ' || v_currency_code);
538:
539: open cursor_bank_account_id(v_currency_code);
540: loop

Line 537: fnd_file.put_line(FND_FILE.LOG, 'currency ' || v_currency_code);

533: v_AvgAvailableYTDSubTRC := null;
534:
535: n_loop := n_loop+1;
536: fnd_file.put_line(FND_FILE.LOG, 'n_loop ' || n_loop);
537: fnd_file.put_line(FND_FILE.LOG, 'currency ' || v_currency_code);
538:
539: open cursor_bank_account_id(v_currency_code);
540: loop
541: fetch cursor_bank_account_id into v_bank_account_id;

Line 545: fnd_file.put_line(FND_FILE.LOG, 'bank account id ' || v_bank_account_id);

541: fetch cursor_bank_account_id into v_bank_account_id;
542: exit when cursor_bank_account_id%NOTFOUND;
543:
544:
545: fnd_file.put_line(FND_FILE.LOG, 'bank account id ' || v_bank_account_id);
546:
547: -- get the xml segment containing only the current account id info
548:
549: select bb.LEDGER_BALANCE, bb.AVAILABLE_BALANCE, bb.VALUE_DATED_BALANCE, bb.ONE_DAY_FLOAT, bb.TWO_DAY_FLOAT, bb.AVERAGE_CLOSE_LEDGER_MTD, bb.AVERAGE_CLOSE_LEDGER_YTD, bb.AVERAGE_CLOSE_AVAILABLE_MTD, bb.AVERAGE_CLOSE_AVAILABLE_YTD

Line 584: --fnd_file.put_line(FND_FILE.LOG, 'available balance ' || v_AvailableBalanceAC );

580: if v_AvailableBalanceAC is null then
581: get_balance_near_date(v_bank_account_id, l_date, v_AvailableBalanceAC, v_AvailableBalance_Date, 'AvailableBalance');
582: end if;
583:
584: --fnd_file.put_line(FND_FILE.LOG, 'available balance ' || v_AvailableBalanceAC );
585:
586: -- set the v_AvailableBalanceRC
587: select decode(v_exchange_rate, -1, v_dummy, v_AvailableBalanceAC*CE_BANKACCT_BA_REPORT_UTIL.get_rate(v_currency_code, p_reporting_currency, nvl(p_exchange_rate_date, to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS')) ,p_exchange_rate_type))
588: into v_AvailableBalanceRC

Line 975: fnd_file.put(FND_FILE.OUTPUT, l_buffer);

971:
972: loop
973: exit when l_length <= 0;
974: dbms_lob.read(l_xml_doc, l_amount, l_offset, l_buffer);
975: fnd_file.put(FND_FILE.OUTPUT, l_buffer);
976: l_length := l_length-l_amount;
977: l_offset := l_offset + l_amount;
978: end loop;
979: */

Line 991: fnd_file.put_line(fnd_file.log, xrate);

987: exception
988: WHEN OTHERS THEN
989: xrate := -1;
990:
991: fnd_file.put_line(fnd_file.log, xrate);
992:
993: end single_day_balance_report;
994:
995:

Line 1029: --fnd_file.put_line(FND_FILE.LOG, 'hello world');

1025: l_to_date varchar2(100);
1026: e_date_exp EXCEPTION;
1027:
1028: begin
1029: --fnd_file.put_line(FND_FILE.LOG, 'hello world');
1030: --fnd_file.put_line(FND_FILE.LOG, p_as_of_date);
1031: --fnd_file.put_line(fnd_file.log, to_char(to_date(p_as_of_date, 'YYYY/MM/DD HH24:MI:SS')));
1032: --fnd_file.put_line(fnd_file.log, p_branch_name);
1033:

Line 1030: --fnd_file.put_line(FND_FILE.LOG, p_as_of_date);

1026: e_date_exp EXCEPTION;
1027:
1028: begin
1029: --fnd_file.put_line(FND_FILE.LOG, 'hello world');
1030: --fnd_file.put_line(FND_FILE.LOG, p_as_of_date);
1031: --fnd_file.put_line(fnd_file.log, to_char(to_date(p_as_of_date, 'YYYY/MM/DD HH24:MI:SS')));
1032: --fnd_file.put_line(fnd_file.log, p_branch_name);
1033:
1034: -- populate ce_security_profiles_gt table with ce_security_procfiles_v

Line 1031: --fnd_file.put_line(fnd_file.log, to_char(to_date(p_as_of_date, 'YYYY/MM/DD HH24:MI:SS')));

1027:
1028: begin
1029: --fnd_file.put_line(FND_FILE.LOG, 'hello world');
1030: --fnd_file.put_line(FND_FILE.LOG, p_as_of_date);
1031: --fnd_file.put_line(fnd_file.log, to_char(to_date(p_as_of_date, 'YYYY/MM/DD HH24:MI:SS')));
1032: --fnd_file.put_line(fnd_file.log, p_branch_name);
1033:
1034: -- populate ce_security_profiles_gt table with ce_security_procfiles_v
1035: -- CEP_STANDARD.init_security;

Line 1032: --fnd_file.put_line(fnd_file.log, p_branch_name);

1028: begin
1029: --fnd_file.put_line(FND_FILE.LOG, 'hello world');
1030: --fnd_file.put_line(FND_FILE.LOG, p_as_of_date);
1031: --fnd_file.put_line(fnd_file.log, to_char(to_date(p_as_of_date, 'YYYY/MM/DD HH24:MI:SS')));
1032: --fnd_file.put_line(fnd_file.log, p_branch_name);
1033:
1034: -- populate ce_security_profiles_gt table with ce_security_procfiles_v
1035: -- CEP_STANDARD.init_security;
1036:

Line 1138: fnd_file.put_line(fnd_file.log, 'xml query end');

1134: --select c.accountBalance
1135: --into l_xml
1136: --from ce_balance_reporting_xml_v c;
1137:
1138: fnd_file.put_line(fnd_file.log, 'xml query end');
1139:
1140: l_xml_doc := l_xml.getClobVal();
1141: CE_BANKACCT_BA_REPORT_UTIL.printClobOut(l_xml_doc);
1142:

Line 1148: fnd_file.put_line(fnd_file.log, concat('clob length is ', l_length));

1144: l_length := nvl(DBMS_LOB.getlength(l_xml_doc), 0);
1145: l_offset := 1;
1146: l_amount := 32767;
1147:
1148: fnd_file.put_line(fnd_file.log, concat('clob length is ', l_length));
1149:
1150: loop
1151: exit when l_length <= 0;
1152: dbms_lob.read(l_xml_doc, l_amount, l_offset, l_buffer);

Line 1153: -- fnd_file.put_line(fnd_file.log, 'buffer read');

1149:
1150: loop
1151: exit when l_length <= 0;
1152: dbms_lob.read(l_xml_doc, l_amount, l_offset, l_buffer);
1153: -- fnd_file.put_line(fnd_file.log, 'buffer read');
1154: fnd_file.put(FND_FILE.OUTPUT, l_buffer);
1155: -- fnd_file.put_line(fnd_file.log, 'buffer write');
1156: l_length := l_length-l_amount;
1157: l_offset := l_offset + l_amount;

Line 1154: fnd_file.put(FND_FILE.OUTPUT, l_buffer);

1150: loop
1151: exit when l_length <= 0;
1152: dbms_lob.read(l_xml_doc, l_amount, l_offset, l_buffer);
1153: -- fnd_file.put_line(fnd_file.log, 'buffer read');
1154: fnd_file.put(FND_FILE.OUTPUT, l_buffer);
1155: -- fnd_file.put_line(fnd_file.log, 'buffer write');
1156: l_length := l_length-l_amount;
1157: l_offset := l_offset + l_amount;
1158: end loop;

Line 1155: -- fnd_file.put_line(fnd_file.log, 'buffer write');

1151: exit when l_length <= 0;
1152: dbms_lob.read(l_xml_doc, l_amount, l_offset, l_buffer);
1153: -- fnd_file.put_line(fnd_file.log, 'buffer read');
1154: fnd_file.put(FND_FILE.OUTPUT, l_buffer);
1155: -- fnd_file.put_line(fnd_file.log, 'buffer write');
1156: l_length := l_length-l_amount;
1157: l_offset := l_offset + l_amount;
1158: end loop;
1159: */

Line 1171: fnd_file.put_line(fnd_file.log, 'ERROR:from date can not be later than to date');

1167:
1168: exception
1169:
1170: WHEN e_date_exp then
1171: fnd_file.put_line(fnd_file.log, 'ERROR:from date can not be later than to date');
1172:
1173: WHEN OTHERS THEN
1174: xrate := -1;
1175:

Line 1176: fnd_file.put_line(fnd_file.log, xrate);

1172:
1173: WHEN OTHERS THEN
1174: xrate := -1;
1175:
1176: fnd_file.put_line(fnd_file.log, xrate);
1177: fnd_file.put_line(fnd_file.log, SQLCODE);
1178: fnd_file.put_line(fnd_file.log, SQLERRM);
1179: end;
1180:

Line 1177: fnd_file.put_line(fnd_file.log, SQLCODE);

1173: WHEN OTHERS THEN
1174: xrate := -1;
1175:
1176: fnd_file.put_line(fnd_file.log, xrate);
1177: fnd_file.put_line(fnd_file.log, SQLCODE);
1178: fnd_file.put_line(fnd_file.log, SQLERRM);
1179: end;
1180:
1181:

Line 1178: fnd_file.put_line(fnd_file.log, SQLERRM);

1174: xrate := -1;
1175:
1176: fnd_file.put_line(fnd_file.log, xrate);
1177: fnd_file.put_line(fnd_file.log, SQLCODE);
1178: fnd_file.put_line(fnd_file.log, SQLERRM);
1179: end;
1180:
1181:
1182: procedure act_proj_balance_report

Line 1210: --fnd_file.put_line(FND_FILE.LOG, 'hello world');

1206: l_Bank_Name varchar2(100);
1207: l_balance_type_meaning varchar2(200);
1208: e_date_exp EXCEPTION;
1209: begin
1210: --fnd_file.put_line(FND_FILE.LOG, 'hello world');
1211: --fnd_file.put_line(FND_FILE.LOG, p_as_of_date);
1212: --fnd_file.put_line(fnd_file.log, to_char(to_date(p_as_of_date, 'YYYY/MM/DD HH24:MI:SS')));
1213: --fnd_file.put_line(fnd_file.log, p_branch_name);
1214:

Line 1211: --fnd_file.put_line(FND_FILE.LOG, p_as_of_date);

1207: l_balance_type_meaning varchar2(200);
1208: e_date_exp EXCEPTION;
1209: begin
1210: --fnd_file.put_line(FND_FILE.LOG, 'hello world');
1211: --fnd_file.put_line(FND_FILE.LOG, p_as_of_date);
1212: --fnd_file.put_line(fnd_file.log, to_char(to_date(p_as_of_date, 'YYYY/MM/DD HH24:MI:SS')));
1213: --fnd_file.put_line(fnd_file.log, p_branch_name);
1214:
1215: -- populate ce_security_profiles_gt table with ce_security_procfiles_v

Line 1212: --fnd_file.put_line(fnd_file.log, to_char(to_date(p_as_of_date, 'YYYY/MM/DD HH24:MI:SS')));

1208: e_date_exp EXCEPTION;
1209: begin
1210: --fnd_file.put_line(FND_FILE.LOG, 'hello world');
1211: --fnd_file.put_line(FND_FILE.LOG, p_as_of_date);
1212: --fnd_file.put_line(fnd_file.log, to_char(to_date(p_as_of_date, 'YYYY/MM/DD HH24:MI:SS')));
1213: --fnd_file.put_line(fnd_file.log, p_branch_name);
1214:
1215: -- populate ce_security_profiles_gt table with ce_security_procfiles_v
1216: -- CEP_STANDARD.init_security;

Line 1213: --fnd_file.put_line(fnd_file.log, p_branch_name);

1209: begin
1210: --fnd_file.put_line(FND_FILE.LOG, 'hello world');
1211: --fnd_file.put_line(FND_FILE.LOG, p_as_of_date);
1212: --fnd_file.put_line(fnd_file.log, to_char(to_date(p_as_of_date, 'YYYY/MM/DD HH24:MI:SS')));
1213: --fnd_file.put_line(fnd_file.log, p_branch_name);
1214:
1215: -- populate ce_security_profiles_gt table with ce_security_procfiles_v
1216: -- CEP_STANDARD.init_security;
1217:

Line 1313: fnd_file.put(FND_FILE.OUTPUT, l_buffer);

1309:
1310: loop
1311: exit when l_length <= 0;
1312: dbms_lob.read(l_xml_doc, l_amount, l_offset, l_buffer);
1313: fnd_file.put(FND_FILE.OUTPUT, l_buffer);
1314: l_length := l_length-l_amount;
1315: l_offset := l_offset + l_amount;
1316: end loop;
1317: */

Line 1328: fnd_file.put_line(fnd_file.log, 'ERROR: from date can not be later than to date');

1324:
1325: exception
1326:
1327: WHEN e_date_exp then
1328: fnd_file.put_line(fnd_file.log, 'ERROR: from date can not be later than to date');
1329:
1330: WHEN OTHERS THEN
1331: xrate := -1;
1332:

Line 1333: fnd_file.put_line(fnd_file.log, xrate);

1329:
1330: WHEN OTHERS THEN
1331: xrate := -1;
1332:
1333: fnd_file.put_line(fnd_file.log, xrate);
1334: fnd_file.put_line(fnd_file.log, SQLCODE);
1335: fnd_file.put_line(fnd_file.log, SQLERRM);
1336:
1337: end;

Line 1334: fnd_file.put_line(fnd_file.log, SQLCODE);

1330: WHEN OTHERS THEN
1331: xrate := -1;
1332:
1333: fnd_file.put_line(fnd_file.log, xrate);
1334: fnd_file.put_line(fnd_file.log, SQLCODE);
1335: fnd_file.put_line(fnd_file.log, SQLERRM);
1336:
1337: end;
1338:

Line 1335: fnd_file.put_line(fnd_file.log, SQLERRM);

1331: xrate := -1;
1332:
1333: fnd_file.put_line(fnd_file.log, xrate);
1334: fnd_file.put_line(fnd_file.log, SQLCODE);
1335: fnd_file.put_line(fnd_file.log, SQLERRM);
1336:
1337: end;
1338:
1339: