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.

[Home] [Help]

APPS.CE_JE_CREATION dependencies on FND_GLOBAL

Line 642: NVL(FND_GLOBAL.user_id,-1),

638: null, -- cleared_by_flag
639: CE_JE_CREATION.cf_reference_text,
640: CE_JE_CREATION.cf_bank_account_text,
641: CE_JE_CREATION.cf_customer_text,
642: NVL(FND_GLOBAL.user_id,-1),
643: sysdate,
644: NVL(FND_GLOBAL.user_id,-1),
645: sysdate,
646: NVL(FND_GLOBAL.user_id,-1));

Line 644: NVL(FND_GLOBAL.user_id,-1),

640: CE_JE_CREATION.cf_bank_account_text,
641: CE_JE_CREATION.cf_customer_text,
642: NVL(FND_GLOBAL.user_id,-1),
643: sysdate,
644: NVL(FND_GLOBAL.user_id,-1),
645: sysdate,
646: NVL(FND_GLOBAL.user_id,-1));
647: log('< 648: EXCEPTION

Line 646: NVL(FND_GLOBAL.user_id,-1));

642: NVL(FND_GLOBAL.user_id,-1),
643: sysdate,
644: NVL(FND_GLOBAL.user_id,-1),
645: sysdate,
646: NVL(FND_GLOBAL.user_id,-1));
647: log('< 648: EXCEPTION
649: WHEN OTHERS THEN
650: log('Exception in Populate_CF_table');

Line 757: NVL(FND_GLOBAL.user_id,-1),

753: CE_JE_CREATION_ERRORS_PKG.insert_row(
754: CE_JE_CREATION.csh_statement_header_id,
755: CE_JE_CREATION.csl_statement_line_id,
756: 'DUMMY',
757: NVL(FND_GLOBAL.user_id,-1),
758: sysdate,
759: sysdate,
760: NVL(FND_GLOBAL.user_id,-1),
761: NVL(FND_GLOBAL.user_id,-1),

Line 760: NVL(FND_GLOBAL.user_id,-1),

756: 'DUMMY',
757: NVL(FND_GLOBAL.user_id,-1),
758: sysdate,
759: sysdate,
760: NVL(FND_GLOBAL.user_id,-1),
761: NVL(FND_GLOBAL.user_id,-1),
762: g_request_id);
763:
764: ELSE -- Invalid gl account

Line 761: NVL(FND_GLOBAL.user_id,-1),

757: NVL(FND_GLOBAL.user_id,-1),
758: sysdate,
759: sysdate,
760: NVL(FND_GLOBAL.user_id,-1),
761: NVL(FND_GLOBAL.user_id,-1),
762: g_request_id);
763:
764: ELSE -- Invalid gl account
765: Update_statement_line(CE_JE_CREATION.csl_statement_line_id,

Line 771: NVL(FND_GLOBAL.user_id,-1),

767: CE_JE_CREATION_ERRORS_PKG.insert_row(
768: CE_JE_CREATION.csh_statement_header_id,
769: CE_JE_CREATION.csl_statement_line_id,
770: 'CE_INVALID_GL_ACCOUNT',
771: NVL(FND_GLOBAL.user_id,-1),
772: sysdate,
773: sysdate,
774: NVL(FND_GLOBAL.user_id,-1),
775: NVL(FND_GLOBAL.user_id,-1),

Line 774: NVL(FND_GLOBAL.user_id,-1),

770: 'CE_INVALID_GL_ACCOUNT',
771: NVL(FND_GLOBAL.user_id,-1),
772: sysdate,
773: sysdate,
774: NVL(FND_GLOBAL.user_id,-1),
775: NVL(FND_GLOBAL.user_id,-1),
776: g_request_id);
777: log('invalid gl account');
778: END IF;

Line 775: NVL(FND_GLOBAL.user_id,-1),

771: NVL(FND_GLOBAL.user_id,-1),
772: sysdate,
773: sysdate,
774: NVL(FND_GLOBAL.user_id,-1),
775: NVL(FND_GLOBAL.user_id,-1),
776: g_request_id);
777: log('invalid gl account');
778: END IF;
779: ELSE --bank account not multi currency enabled

Line 786: NVL(FND_GLOBAL.user_id,-1),

782: CE_JE_CREATION_ERRORS_PKG.insert_row(
783: CE_JE_CREATION.csh_statement_header_id,
784: CE_JE_CREATION.csl_statement_line_id,
785: 'CE_NOT_MULTI_CURR',
786: NVL(FND_GLOBAL.user_id,-1),
787: sysdate,
788: sysdate,
789: NVL(FND_GLOBAL.user_id,-1),
790: NVL(FND_GLOBAL.user_id,-1),

Line 789: NVL(FND_GLOBAL.user_id,-1),

785: 'CE_NOT_MULTI_CURR',
786: NVL(FND_GLOBAL.user_id,-1),
787: sysdate,
788: sysdate,
789: NVL(FND_GLOBAL.user_id,-1),
790: NVL(FND_GLOBAL.user_id,-1),
791: g_request_id);
792: END IF;
793: ELSE -- exchange info cannot be determined

Line 790: NVL(FND_GLOBAL.user_id,-1),

786: NVL(FND_GLOBAL.user_id,-1),
787: sysdate,
788: sysdate,
789: NVL(FND_GLOBAL.user_id,-1),
790: NVL(FND_GLOBAL.user_id,-1),
791: g_request_id);
792: END IF;
793: ELSE -- exchange info cannot be determined
794: Update_statement_line(CE_JE_CREATION.csl_statement_line_id,

Line 800: NVL(FND_GLOBAL.user_id,-1),

796: CE_JE_CREATION_ERRORS_PKG.insert_row(
797: CE_JE_CREATION.csh_statement_header_id,
798: CE_JE_CREATION.csl_statement_line_id,
799: 'CE_MISSING_USER_RATE',
800: NVL(FND_GLOBAL.user_id,-1),
801: sysdate,
802: sysdate,
803: NVL(FND_GLOBAL.user_id,-1),
804: NVL(FND_GLOBAL.user_id,-1),

Line 803: NVL(FND_GLOBAL.user_id,-1),

799: 'CE_MISSING_USER_RATE',
800: NVL(FND_GLOBAL.user_id,-1),
801: sysdate,
802: sysdate,
803: NVL(FND_GLOBAL.user_id,-1),
804: NVL(FND_GLOBAL.user_id,-1),
805: g_request_id);
806: log('Exchange info cannot be determined.');
807: END IF;

Line 804: NVL(FND_GLOBAL.user_id,-1),

800: NVL(FND_GLOBAL.user_id,-1),
801: sysdate,
802: sysdate,
803: NVL(FND_GLOBAL.user_id,-1),
804: NVL(FND_GLOBAL.user_id,-1),
805: g_request_id);
806: log('Exchange info cannot be determined.');
807: END IF;
808: ELSE -- invalid cleared date

Line 815: NVL(FND_GLOBAL.user_id,-1),

811: CE_JE_CREATION_ERRORS_PKG.insert_row(
812: CE_JE_CREATION.csh_statement_header_id,
813: CE_JE_CREATION.csl_statement_line_id,
814: 'CE_INVALID_CLEARED_DATE',
815: NVL(FND_GLOBAL.user_id,-1),
816: sysdate,
817: sysdate,
818: NVL(FND_GLOBAL.user_id,-1),
819: NVL(FND_GLOBAL.user_id,-1),

Line 818: NVL(FND_GLOBAL.user_id,-1),

814: 'CE_INVALID_CLEARED_DATE',
815: NVL(FND_GLOBAL.user_id,-1),
816: sysdate,
817: sysdate,
818: NVL(FND_GLOBAL.user_id,-1),
819: NVL(FND_GLOBAL.user_id,-1),
820: g_request_id);
821: log('invalid accounting date');
822: END IF;

Line 819: NVL(FND_GLOBAL.user_id,-1),

815: NVL(FND_GLOBAL.user_id,-1),
816: sysdate,
817: sysdate,
818: NVL(FND_GLOBAL.user_id,-1),
819: NVL(FND_GLOBAL.user_id,-1),
820: g_request_id);
821: log('invalid accounting date');
822: END IF;
823: log('<

Line 871: g_request_id := FND_GLOBAL.CONC_REQUEST_ID;

867: g_p_statement_date_from := to_date(p_statement_date_from,'YYYY/MM/DD HH24:MI:SS');
868: g_p_statement_date_to := to_date(p_statement_date_to,'YYYY/MM/DD HH24:MI:SS');
869: --g_p_gl_date := to_char(to_date(p_gl_date,'YYYY/MM/DD HH24:MI:SS'));
870: --g_p_report_mode := p_report_mode;
871: g_request_id := FND_GLOBAL.CONC_REQUEST_ID;
872:
873: --
874: -- fetch the bank accounts for the submitted
875: -- bank branch (and) bank account

Line 973: NVL(FND_GLOBAL.user_id,-1),

969: CE_JE_CREATION_ERRORS_PKG.insert_row(
970: CE_JE_CREATION.csh_statement_header_id,
971: CE_JE_CREATION.csl_statement_line_id,
972: 'CE_NO_BA_LE_IN_SYS',
973: NVL(FND_GLOBAL.user_id,-1),
974: sysdate,
975: sysdate,
976: NVL(FND_GLOBAL.user_id,-1),
977: NVL(FND_GLOBAL.user_id,-1),

Line 976: NVL(FND_GLOBAL.user_id,-1),

972: 'CE_NO_BA_LE_IN_SYS',
973: NVL(FND_GLOBAL.user_id,-1),
974: sysdate,
975: sysdate,
976: NVL(FND_GLOBAL.user_id,-1),
977: NVL(FND_GLOBAL.user_id,-1),
978: g_request_id);
979: EXIT;
980: END IF;

Line 977: NVL(FND_GLOBAL.user_id,-1),

973: NVL(FND_GLOBAL.user_id,-1),
974: sysdate,
975: sysdate,
976: NVL(FND_GLOBAL.user_id,-1),
977: NVL(FND_GLOBAL.user_id,-1),
978: g_request_id);
979: EXIT;
980: END IF;
981: --

Line 995: NVL(FND_GLOBAL.user_id,-1),

991: CE_JE_CREATION_ERRORS_PKG.insert_row(
992: CE_JE_CREATION.csh_statement_header_id,
993: CE_JE_CREATION.csl_statement_line_id,
994: 'CE_LINE_LOCKED',
995: NVL(FND_GLOBAL.user_id,-1),
996: sysdate,
997: sysdate,
998: NVL(FND_GLOBAL.user_id,-1),
999: NVL(FND_GLOBAL.user_id,-1),

Line 998: NVL(FND_GLOBAL.user_id,-1),

994: 'CE_LINE_LOCKED',
995: NVL(FND_GLOBAL.user_id,-1),
996: sysdate,
997: sysdate,
998: NVL(FND_GLOBAL.user_id,-1),
999: NVL(FND_GLOBAL.user_id,-1),
1000: g_request_id);
1001: END IF;
1002: l_last_statement_line_id := CE_JE_CREATION.csl_statement_line_id;

Line 999: NVL(FND_GLOBAL.user_id,-1),

995: NVL(FND_GLOBAL.user_id,-1),
996: sysdate,
997: sysdate,
998: NVL(FND_GLOBAL.user_id,-1),
999: NVL(FND_GLOBAL.user_id,-1),
1000: g_request_id);
1001: END IF;
1002: l_last_statement_line_id := CE_JE_CREATION.csl_statement_line_id;
1003: END IF;