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 STANDARD

Line 61: cep_standard.debug('as of date ' || to_char(p_date, 'YYYY/MM/DD HH24:MI:SS'));

57:
58: begin
59:
60: v_date := p_date;
61: cep_standard.debug('as of date ' || to_char(p_date, 'YYYY/MM/DD HH24:MI:SS'));
62: cep_standard.debug('balance type ' || p_balance_type);
63: /*
64: v_LegerBalanceAC number;
65: v_AvailableBalanceAC number;

Line 62: cep_standard.debug('balance type ' || p_balance_type);

58: begin
59:
60: v_date := p_date;
61: cep_standard.debug('as of date ' || to_char(p_date, 'YYYY/MM/DD HH24:MI:SS'));
62: cep_standard.debug('balance type ' || p_balance_type);
63: /*
64: v_LegerBalanceAC number;
65: v_AvailableBalanceAC number;
66: v_IntCalBalanceAC number;

Line 462: cep_standard.debug( 'start single day reporting processing');

458:
459: n_loop number :=0;
460:
461: begin
462: cep_standard.debug( 'start single day reporting processing');
463: --cep_standard.debug( 'as of date ' || to_char(to_date(p_as_of_date, 'YYYY/MM/DD HH24:MI:S')));
464: cep_standard.debug( 'reporting currency ' || p_reporting_currency);
465: cep_standard.debug( 'exchange rate type ' || p_exchange_rate_type);
466:

Line 463: --cep_standard.debug( 'as of date ' || to_char(to_date(p_as_of_date, 'YYYY/MM/DD HH24:MI:S')));

459: n_loop number :=0;
460:
461: begin
462: cep_standard.debug( 'start single day reporting processing');
463: --cep_standard.debug( 'as of date ' || to_char(to_date(p_as_of_date, 'YYYY/MM/DD HH24:MI:S')));
464: cep_standard.debug( 'reporting currency ' || p_reporting_currency);
465: cep_standard.debug( 'exchange rate type ' || p_exchange_rate_type);
466:
467: -- populate ce_security_profiles_gt table with ce_security_procfiles_v

Line 464: cep_standard.debug( 'reporting currency ' || p_reporting_currency);

460:
461: begin
462: cep_standard.debug( 'start single day reporting processing');
463: --cep_standard.debug( 'as of date ' || to_char(to_date(p_as_of_date, 'YYYY/MM/DD HH24:MI:S')));
464: cep_standard.debug( 'reporting currency ' || p_reporting_currency);
465: cep_standard.debug( 'exchange rate type ' || p_exchange_rate_type);
466:
467: -- populate ce_security_profiles_gt table with ce_security_procfiles_v
468: -- CEP_STANDARD.init_security;

Line 465: cep_standard.debug( 'exchange rate type ' || p_exchange_rate_type);

461: begin
462: cep_standard.debug( 'start single day reporting processing');
463: --cep_standard.debug( 'as of date ' || to_char(to_date(p_as_of_date, 'YYYY/MM/DD HH24:MI:S')));
464: cep_standard.debug( 'reporting currency ' || p_reporting_currency);
465: cep_standard.debug( 'exchange rate type ' || p_exchange_rate_type);
466:
467: -- populate ce_security_profiles_gt table with ce_security_procfiles_v
468: -- CEP_STANDARD.init_security;
469:

Line 468: -- CEP_STANDARD.init_security;

464: cep_standard.debug( 'reporting currency ' || p_reporting_currency);
465: cep_standard.debug( 'exchange rate type ' || p_exchange_rate_type);
466:
467: -- populate ce_security_profiles_gt table with ce_security_procfiles_v
468: -- CEP_STANDARD.init_security;
469:
470: --if p_exchange_rate_date is not null then
471: -- p_exchange_rate_date := to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS');
472: --end if;

Line 479: --cep_standard.debug( 'l_total_balance_flag '||to_char(l_total_balance_flag));

475: l_date := to_date(p_as_of_date, 'YYYY/MM/DD HH24:MI:SS');
476:
477: -- get total_balance_flag, 1 when exchange rate exists for all currencies for query conditions
478: 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')));
479: --cep_standard.debug( 'l_total_balance_flag '||to_char(l_total_balance_flag));
480:
481: -- get bank branch name
482: if p_branch_party_id is not null then
483: select BANK_BRANCH_NAME

Line 512: CEP_STANDARD.init_security; -- Bug 8620223

508: into l_legal_entity_name
509: from CE_LE_BG_OU_VS_V
510: where legal_entity_id = p_legal_entity_id and organization_type = 'LEGAL_ENTITY';
511: end if;
512: CEP_STANDARD.init_security; -- Bug 8620223
513: -- loop through all currencies to generate the XML node BankAccttGroupByCurrency
514: open cursor_bank_currency_code;
515: loop
516: fetch cursor_bank_currency_code into v_currency_code;

Line 551: cep_standard.debug( 'n_loop ' || n_loop);

547: v_AvgAvailableMTDSubTRC := null;
548: v_AvgAvailableYTDSubTRC := null;
549:
550: n_loop := n_loop+1;
551: cep_standard.debug( 'n_loop ' || n_loop);
552: cep_standard.debug( 'currency ' || v_currency_code);
553:
554: open cursor_bank_account_id(v_currency_code);
555: loop

Line 552: cep_standard.debug( 'currency ' || v_currency_code);

548: v_AvgAvailableYTDSubTRC := null;
549:
550: n_loop := n_loop+1;
551: cep_standard.debug( 'n_loop ' || n_loop);
552: cep_standard.debug( 'currency ' || v_currency_code);
553:
554: open cursor_bank_account_id(v_currency_code);
555: loop
556: fetch cursor_bank_account_id into v_bank_account_id;

Line 562: cep_standard.debug( 'bank account id ' || v_bank_account_id);

558:
559: counterflag:= counterflag+1;
560:
561:
562: cep_standard.debug( 'bank account id ' || v_bank_account_id);
563:
564: -- get the xml segment containing only the current account id info
565: -- Bug 8620223
566: begin

Line 598: cep_standard.debug( 'v_LegerBalanceAC ' || v_LegerBalanceAC);

594: v_AvgAvailableMTD_Date := l_date;
595: v_AvgAvailableYTD_Date := l_date;
596:
597:
598: cep_standard.debug( 'v_LegerBalanceAC ' || v_LegerBalanceAC);
599: -- get v_LegerBalanceAC from the nearest date
600: if v_LegerBalanceAC is null then
601: get_balance_near_date(v_bank_account_id, l_date, v_LegerBalanceAC, v_LegerBalance_Date, 'LegerBalance');
602: end if;

Line 614: --cep_standard.debug( 'available balance ' || v_AvailableBalanceAC );

610: if v_AvailableBalanceAC is null then
611: get_balance_near_date(v_bank_account_id, l_date, v_AvailableBalanceAC, v_AvailableBalance_Date, 'AvailableBalance');
612: end if;
613:
614: --cep_standard.debug( 'available balance ' || v_AvailableBalanceAC );
615:
616: -- set the v_AvailableBalanceRC
617: 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))
618: into v_AvailableBalanceRC

Line 1022: cep_standard.debug( xrate);

1018: exception
1019: WHEN OTHERS THEN
1020: xrate := -1;
1021:
1022: cep_standard.debug( xrate);
1023:
1024: end single_day_balance_report;
1025:
1026:

Line 1060: --cep_standard.debug( 'hello world');

1056: l_to_date varchar2(100);
1057: e_date_exp EXCEPTION;
1058:
1059: begin
1060: --cep_standard.debug( 'hello world');
1061: --cep_standard.debug( p_as_of_date);
1062: --cep_standard.debug( to_char(to_date(p_as_of_date, 'YYYY/MM/DD HH24:MI:SS')));
1063: --cep_standard.debug( p_branch_name);
1064:

Line 1061: --cep_standard.debug( p_as_of_date);

1057: e_date_exp EXCEPTION;
1058:
1059: begin
1060: --cep_standard.debug( 'hello world');
1061: --cep_standard.debug( p_as_of_date);
1062: --cep_standard.debug( to_char(to_date(p_as_of_date, 'YYYY/MM/DD HH24:MI:SS')));
1063: --cep_standard.debug( p_branch_name);
1064:
1065: -- populate ce_security_profiles_gt table with ce_security_procfiles_v

Line 1062: --cep_standard.debug( to_char(to_date(p_as_of_date, 'YYYY/MM/DD HH24:MI:SS')));

1058:
1059: begin
1060: --cep_standard.debug( 'hello world');
1061: --cep_standard.debug( p_as_of_date);
1062: --cep_standard.debug( to_char(to_date(p_as_of_date, 'YYYY/MM/DD HH24:MI:SS')));
1063: --cep_standard.debug( p_branch_name);
1064:
1065: -- populate ce_security_profiles_gt table with ce_security_procfiles_v
1066: -- CEP_STANDARD.init_security;

Line 1063: --cep_standard.debug( p_branch_name);

1059: begin
1060: --cep_standard.debug( 'hello world');
1061: --cep_standard.debug( p_as_of_date);
1062: --cep_standard.debug( to_char(to_date(p_as_of_date, 'YYYY/MM/DD HH24:MI:SS')));
1063: --cep_standard.debug( p_branch_name);
1064:
1065: -- populate ce_security_profiles_gt table with ce_security_procfiles_v
1066: -- CEP_STANDARD.init_security;
1067:

Line 1066: -- CEP_STANDARD.init_security;

1062: --cep_standard.debug( to_char(to_date(p_as_of_date, 'YYYY/MM/DD HH24:MI:SS')));
1063: --cep_standard.debug( p_branch_name);
1064:
1065: -- populate ce_security_profiles_gt table with ce_security_procfiles_v
1066: -- CEP_STANDARD.init_security;
1067:
1068: if p_branch_party_id is not null then
1069: select BANK_BRANCH_NAME, BANK_NAME
1070: into l_Bank_Branch_Name, l_Bank_Name

Line 1169: cep_standard.debug( 'xml query end');

1165: --select c.accountBalance
1166: --into l_xml
1167: --from ce_balance_reporting_xml_v c;
1168:
1169: cep_standard.debug( 'xml query end');
1170:
1171: l_xml_doc := l_xml.getClobVal();
1172: CE_BANKACCT_BA_REPORT_UTIL.printClobOut(l_xml_doc);
1173:

Line 1179: cep_standard.debug( concat('clob length is ', l_length));

1175: l_length := nvl(DBMS_LOB.getlength(l_xml_doc), 0);
1176: l_offset := 1;
1177: l_amount := 32767;
1178:
1179: cep_standard.debug( concat('clob length is ', l_length));
1180:
1181: loop
1182: exit when l_length <= 0;
1183: dbms_lob.read(l_xml_doc, l_amount, l_offset, l_buffer);

Line 1184: -- cep_standard.debug( 'buffer read');

1180:
1181: loop
1182: exit when l_length <= 0;
1183: dbms_lob.read(l_xml_doc, l_amount, l_offset, l_buffer);
1184: -- cep_standard.debug( 'buffer read');
1185: fnd_file.put(FND_FILE.OUTPUT, l_buffer);
1186: -- cep_standard.debug( 'buffer write');
1187: l_length := l_length-l_amount;
1188: l_offset := l_offset + l_amount;

Line 1186: -- cep_standard.debug( 'buffer write');

1182: exit when l_length <= 0;
1183: dbms_lob.read(l_xml_doc, l_amount, l_offset, l_buffer);
1184: -- cep_standard.debug( 'buffer read');
1185: fnd_file.put(FND_FILE.OUTPUT, l_buffer);
1186: -- cep_standard.debug( 'buffer write');
1187: l_length := l_length-l_amount;
1188: l_offset := l_offset + l_amount;
1189: end loop;
1190: */

Line 1202: cep_standard.debug( 'ERROR:from date can not be later than to date');

1198:
1199: exception
1200:
1201: WHEN e_date_exp then
1202: cep_standard.debug( 'ERROR:from date can not be later than to date');
1203:
1204: WHEN OTHERS THEN
1205: xrate := -1;
1206:

Line 1207: cep_standard.debug( xrate);

1203:
1204: WHEN OTHERS THEN
1205: xrate := -1;
1206:
1207: cep_standard.debug( xrate);
1208: cep_standard.debug( SQLCODE);
1209: cep_standard.debug( SQLERRM);
1210: end;
1211:

Line 1208: cep_standard.debug( SQLCODE);

1204: WHEN OTHERS THEN
1205: xrate := -1;
1206:
1207: cep_standard.debug( xrate);
1208: cep_standard.debug( SQLCODE);
1209: cep_standard.debug( SQLERRM);
1210: end;
1211:
1212:

Line 1209: cep_standard.debug( SQLERRM);

1205: xrate := -1;
1206:
1207: cep_standard.debug( xrate);
1208: cep_standard.debug( SQLCODE);
1209: cep_standard.debug( SQLERRM);
1210: end;
1211:
1212:
1213: procedure act_proj_balance_report

Line 1241: --cep_standard.debug( 'hello world');

1237: l_Bank_Name varchar2(100);
1238: l_balance_type_meaning varchar2(200);
1239: e_date_exp EXCEPTION;
1240: begin
1241: --cep_standard.debug( 'hello world');
1242: --cep_standard.debug( p_as_of_date);
1243: --cep_standard.debug( to_char(to_date(p_as_of_date, 'YYYY/MM/DD HH24:MI:SS')));
1244: --cep_standard.debug( p_branch_name);
1245:

Line 1242: --cep_standard.debug( p_as_of_date);

1238: l_balance_type_meaning varchar2(200);
1239: e_date_exp EXCEPTION;
1240: begin
1241: --cep_standard.debug( 'hello world');
1242: --cep_standard.debug( p_as_of_date);
1243: --cep_standard.debug( to_char(to_date(p_as_of_date, 'YYYY/MM/DD HH24:MI:SS')));
1244: --cep_standard.debug( p_branch_name);
1245:
1246: -- populate ce_security_profiles_gt table with ce_security_procfiles_v

Line 1243: --cep_standard.debug( to_char(to_date(p_as_of_date, 'YYYY/MM/DD HH24:MI:SS')));

1239: e_date_exp EXCEPTION;
1240: begin
1241: --cep_standard.debug( 'hello world');
1242: --cep_standard.debug( p_as_of_date);
1243: --cep_standard.debug( to_char(to_date(p_as_of_date, 'YYYY/MM/DD HH24:MI:SS')));
1244: --cep_standard.debug( p_branch_name);
1245:
1246: -- populate ce_security_profiles_gt table with ce_security_procfiles_v
1247: -- CEP_STANDARD.init_security;

Line 1244: --cep_standard.debug( p_branch_name);

1240: begin
1241: --cep_standard.debug( 'hello world');
1242: --cep_standard.debug( p_as_of_date);
1243: --cep_standard.debug( to_char(to_date(p_as_of_date, 'YYYY/MM/DD HH24:MI:SS')));
1244: --cep_standard.debug( p_branch_name);
1245:
1246: -- populate ce_security_profiles_gt table with ce_security_procfiles_v
1247: -- CEP_STANDARD.init_security;
1248:

Line 1247: -- CEP_STANDARD.init_security;

1243: --cep_standard.debug( to_char(to_date(p_as_of_date, 'YYYY/MM/DD HH24:MI:SS')));
1244: --cep_standard.debug( p_branch_name);
1245:
1246: -- populate ce_security_profiles_gt table with ce_security_procfiles_v
1247: -- CEP_STANDARD.init_security;
1248:
1249: if p_branch_party_id is not null then
1250: select BANK_BRANCH_NAME, BANK_NAME
1251: into l_Bank_Branch_Name, l_Bank_Name

Line 1417: cep_standard.debug( 'ERROR: from date can not be later than to date');

1413:
1414: exception
1415:
1416: WHEN e_date_exp then
1417: cep_standard.debug( 'ERROR: from date can not be later than to date');
1418:
1419: WHEN OTHERS THEN
1420: xrate := -1;
1421:

Line 1422: cep_standard.debug( xrate);

1418:
1419: WHEN OTHERS THEN
1420: xrate := -1;
1421:
1422: cep_standard.debug( xrate);
1423: cep_standard.debug( SQLCODE);
1424: cep_standard.debug( SQLERRM);
1425:
1426: end;

Line 1423: cep_standard.debug( SQLCODE);

1419: WHEN OTHERS THEN
1420: xrate := -1;
1421:
1422: cep_standard.debug( xrate);
1423: cep_standard.debug( SQLCODE);
1424: cep_standard.debug( SQLERRM);
1425:
1426: end;
1427: END CE_BANK_ACCT_BALANCE_REPORT;

Line 1424: cep_standard.debug( SQLERRM);

1420: xrate := -1;
1421:
1422: cep_standard.debug( xrate);
1423: cep_standard.debug( SQLCODE);
1424: cep_standard.debug( SQLERRM);
1425:
1426: end;
1427: END CE_BANK_ACCT_BALANCE_REPORT;