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_JE_CREATION dependencies on FND_GLOBAL

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

591: null, -- cleared_by_flag
592: CE_JE_CREATION.cf_reference_text,
593: CE_JE_CREATION.cf_bank_account_text,
594: CE_JE_CREATION.cf_customer_text,
595: NVL(FND_GLOBAL.user_id,-1),
596: sysdate,
597: NVL(FND_GLOBAL.user_id,-1),
598: sysdate,
599: NVL(FND_GLOBAL.user_id,-1));

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

593: CE_JE_CREATION.cf_bank_account_text,
594: CE_JE_CREATION.cf_customer_text,
595: NVL(FND_GLOBAL.user_id,-1),
596: sysdate,
597: NVL(FND_GLOBAL.user_id,-1),
598: sysdate,
599: NVL(FND_GLOBAL.user_id,-1));
600: log('< 601: EXCEPTION

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

595: NVL(FND_GLOBAL.user_id,-1),
596: sysdate,
597: NVL(FND_GLOBAL.user_id,-1),
598: sysdate,
599: NVL(FND_GLOBAL.user_id,-1));
600: log('< 601: EXCEPTION
602: WHEN OTHERS THEN
603: log('Exception in Populate_CF_table');

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

706: CE_JE_CREATION_ERRORS_PKG.insert_row(
707: CE_JE_CREATION.csh_statement_header_id,
708: CE_JE_CREATION.csl_statement_line_id,
709: 'DUMMY',
710: NVL(FND_GLOBAL.user_id,-1),
711: sysdate,
712: sysdate,
713: NVL(FND_GLOBAL.user_id,-1),
714: NVL(FND_GLOBAL.user_id,-1),

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

709: 'DUMMY',
710: NVL(FND_GLOBAL.user_id,-1),
711: sysdate,
712: sysdate,
713: NVL(FND_GLOBAL.user_id,-1),
714: NVL(FND_GLOBAL.user_id,-1),
715: g_request_id);
716:
717: ELSE -- Invalid gl account

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

710: NVL(FND_GLOBAL.user_id,-1),
711: sysdate,
712: sysdate,
713: NVL(FND_GLOBAL.user_id,-1),
714: NVL(FND_GLOBAL.user_id,-1),
715: g_request_id);
716:
717: ELSE -- Invalid gl account
718: Update_statement_line(CE_JE_CREATION.csl_statement_line_id,

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

720: CE_JE_CREATION_ERRORS_PKG.insert_row(
721: CE_JE_CREATION.csh_statement_header_id,
722: CE_JE_CREATION.csl_statement_line_id,
723: 'CE_INVALID_GL_ACCOUNT',
724: NVL(FND_GLOBAL.user_id,-1),
725: sysdate,
726: sysdate,
727: NVL(FND_GLOBAL.user_id,-1),
728: NVL(FND_GLOBAL.user_id,-1),

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

723: 'CE_INVALID_GL_ACCOUNT',
724: NVL(FND_GLOBAL.user_id,-1),
725: sysdate,
726: sysdate,
727: NVL(FND_GLOBAL.user_id,-1),
728: NVL(FND_GLOBAL.user_id,-1),
729: g_request_id);
730: log('invalid gl account');
731: END IF;

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

724: NVL(FND_GLOBAL.user_id,-1),
725: sysdate,
726: sysdate,
727: NVL(FND_GLOBAL.user_id,-1),
728: NVL(FND_GLOBAL.user_id,-1),
729: g_request_id);
730: log('invalid gl account');
731: END IF;
732: ELSE --bank account not multi currency enabled

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

735: CE_JE_CREATION_ERRORS_PKG.insert_row(
736: CE_JE_CREATION.csh_statement_header_id,
737: CE_JE_CREATION.csl_statement_line_id,
738: 'CE_NOT_MULTI_CURR',
739: NVL(FND_GLOBAL.user_id,-1),
740: sysdate,
741: sysdate,
742: NVL(FND_GLOBAL.user_id,-1),
743: NVL(FND_GLOBAL.user_id,-1),

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

738: 'CE_NOT_MULTI_CURR',
739: NVL(FND_GLOBAL.user_id,-1),
740: sysdate,
741: sysdate,
742: NVL(FND_GLOBAL.user_id,-1),
743: NVL(FND_GLOBAL.user_id,-1),
744: g_request_id);
745: END IF;
746: ELSE -- exchange info cannot be determined

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

739: NVL(FND_GLOBAL.user_id,-1),
740: sysdate,
741: sysdate,
742: NVL(FND_GLOBAL.user_id,-1),
743: NVL(FND_GLOBAL.user_id,-1),
744: g_request_id);
745: END IF;
746: ELSE -- exchange info cannot be determined
747: Update_statement_line(CE_JE_CREATION.csl_statement_line_id,

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

749: CE_JE_CREATION_ERRORS_PKG.insert_row(
750: CE_JE_CREATION.csh_statement_header_id,
751: CE_JE_CREATION.csl_statement_line_id,
752: 'CE_MISSING_USER_RATE',
753: NVL(FND_GLOBAL.user_id,-1),
754: sysdate,
755: sysdate,
756: NVL(FND_GLOBAL.user_id,-1),
757: NVL(FND_GLOBAL.user_id,-1),

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

752: 'CE_MISSING_USER_RATE',
753: NVL(FND_GLOBAL.user_id,-1),
754: sysdate,
755: sysdate,
756: NVL(FND_GLOBAL.user_id,-1),
757: NVL(FND_GLOBAL.user_id,-1),
758: g_request_id);
759: log('Exchange info cannot be determined.');
760: END IF;

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

753: NVL(FND_GLOBAL.user_id,-1),
754: sysdate,
755: sysdate,
756: NVL(FND_GLOBAL.user_id,-1),
757: NVL(FND_GLOBAL.user_id,-1),
758: g_request_id);
759: log('Exchange info cannot be determined.');
760: END IF;
761: ELSE -- invalid cleared date

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

764: CE_JE_CREATION_ERRORS_PKG.insert_row(
765: CE_JE_CREATION.csh_statement_header_id,
766: CE_JE_CREATION.csl_statement_line_id,
767: 'CE_INVALID_CLEARED_DATE',
768: NVL(FND_GLOBAL.user_id,-1),
769: sysdate,
770: sysdate,
771: NVL(FND_GLOBAL.user_id,-1),
772: NVL(FND_GLOBAL.user_id,-1),

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

767: 'CE_INVALID_CLEARED_DATE',
768: NVL(FND_GLOBAL.user_id,-1),
769: sysdate,
770: sysdate,
771: NVL(FND_GLOBAL.user_id,-1),
772: NVL(FND_GLOBAL.user_id,-1),
773: g_request_id);
774: log('invalid accounting date');
775: END IF;

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

768: NVL(FND_GLOBAL.user_id,-1),
769: sysdate,
770: sysdate,
771: NVL(FND_GLOBAL.user_id,-1),
772: NVL(FND_GLOBAL.user_id,-1),
773: g_request_id);
774: log('invalid accounting date');
775: END IF;
776: log('<

Line 824: g_request_id := FND_GLOBAL.CONC_REQUEST_ID;

820: g_p_statement_date_from := to_date(p_statement_date_from,'YYYY/MM/DD HH24:MI:SS');
821: g_p_statement_date_to := to_date(p_statement_date_to,'YYYY/MM/DD HH24:MI:SS');
822: --g_p_gl_date := to_char(to_date(p_gl_date,'YYYY/MM/DD HH24:MI:SS'));
823: --g_p_report_mode := p_report_mode;
824: g_request_id := FND_GLOBAL.CONC_REQUEST_ID;
825:
826: --
827: -- fetch the bank accounts for the submitted
828: -- bank branch (and) bank account

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

922: CE_JE_CREATION_ERRORS_PKG.insert_row(
923: CE_JE_CREATION.csh_statement_header_id,
924: CE_JE_CREATION.csl_statement_line_id,
925: 'CE_NO_BA_LE_IN_SYS',
926: NVL(FND_GLOBAL.user_id,-1),
927: sysdate,
928: sysdate,
929: NVL(FND_GLOBAL.user_id,-1),
930: NVL(FND_GLOBAL.user_id,-1),

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

925: 'CE_NO_BA_LE_IN_SYS',
926: NVL(FND_GLOBAL.user_id,-1),
927: sysdate,
928: sysdate,
929: NVL(FND_GLOBAL.user_id,-1),
930: NVL(FND_GLOBAL.user_id,-1),
931: g_request_id);
932: EXIT;
933: END IF;

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

926: NVL(FND_GLOBAL.user_id,-1),
927: sysdate,
928: sysdate,
929: NVL(FND_GLOBAL.user_id,-1),
930: NVL(FND_GLOBAL.user_id,-1),
931: g_request_id);
932: EXIT;
933: END IF;
934: --

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

944: CE_JE_CREATION_ERRORS_PKG.insert_row(
945: CE_JE_CREATION.csh_statement_header_id,
946: CE_JE_CREATION.csl_statement_line_id,
947: 'CE_LINE_LOCKED',
948: NVL(FND_GLOBAL.user_id,-1),
949: sysdate,
950: sysdate,
951: NVL(FND_GLOBAL.user_id,-1),
952: NVL(FND_GLOBAL.user_id,-1),

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

947: 'CE_LINE_LOCKED',
948: NVL(FND_GLOBAL.user_id,-1),
949: sysdate,
950: sysdate,
951: NVL(FND_GLOBAL.user_id,-1),
952: NVL(FND_GLOBAL.user_id,-1),
953: g_request_id);
954: END IF;
955: l_last_statement_line_id := CE_JE_CREATION.csl_statement_line_id;

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

948: NVL(FND_GLOBAL.user_id,-1),
949: sysdate,
950: sysdate,
951: NVL(FND_GLOBAL.user_id,-1),
952: NVL(FND_GLOBAL.user_id,-1),
953: g_request_id);
954: END IF;
955: l_last_statement_line_id := CE_JE_CREATION.csl_statement_line_id;
956: END IF;