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

Line 44: FND_FILE.PUT_LINE(FND_FILE.log, lv_procedure_name);

40: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
41: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
42: BEGIN
43: --logging for debug
44: FND_FILE.PUT_LINE(FND_FILE.log, lv_procedure_name);
45: IF (ln_proc_level >= ln_dbg_level) THEN
46: FND_LOG.STRING(ln_proc_level,
47: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
48: '.begin',

Line 52: FND_FILE.PUT_LINE(FND_FILE.LOG,'pn_branch='||pn_branch);

48: '.begin',
49: 'Enter procedure');
50:
51: END IF; --ln_proc_level>=ln_dbg_level
52: FND_FILE.PUT_LINE(FND_FILE.LOG,'pn_branch='||pn_branch);
53: IF pn_branch=1 THEN
54: --Balance
55: Add_GL_BALANCE(pn_chart_of_account_id ,
56: pn_ledger_id ,

Line 95: FND_FILE.put_line(FND_FILE.log,

91: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
92: '.Other_Exception ',
93: SQLCODE || SQLERRM);
94: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
95: FND_FILE.put_line(FND_FILE.log,
96: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
97: SQLCODE || SQLERRM);
98: RAISE;
99: END Combination_Exec;

Line 126: FND_FILE.PUT_LINE(FND_FILE.log, lv_procedure_name);

122: order by ffh.FLEX_VALUE;
123:
124: BEGIN
125: --logging for debug
126: FND_FILE.PUT_LINE(FND_FILE.log, lv_procedure_name);
127: IF (ln_proc_level >= ln_dbg_level) THEN
128: FND_LOG.STRING(ln_proc_level,
129: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
130: '.begin',

Line 139: FND_FILE.put_line(FND_FILE.log,

135: 'pn_ledger_id=' || pn_ledger_id || ',' ||
136: 'pn_accounting_year=' || pv_accounting_year);
137:
138: END IF; --ln_proc_level>=ln_dbg_level
139: FND_FILE.put_line(FND_FILE.log,
140: lv_procedure_name || '.parameters:' ||
141: 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
142: 'pn_ledger_id=' || pn_ledger_id || ',' ||
143: 'pv_bsv='||pv_bsv ||',' ||

Line 187: FND_FILE.put_line(FND_FILE.log,lv_procedure_name||',Y='||l_bsv_temp);

183: FOR l_parent in CUR_PARENT(l_flex_valueset_id,l_bsv_temp) LOOP
184: l_bsv_temp := l_parent.FLEX_VALUE;
185: --recursion
186: IF l_parent.SUMMARY_FLAG='Y' THEN
187: FND_FILE.put_line(FND_FILE.log,lv_procedure_name||',Y='||l_bsv_temp);
188:
189: Recursion_BSV(pn_chart_of_account_id,
190: pn_ledger_id ,
191: pn_legal_entity_id ,

Line 199: FND_FILE.put_line(FND_FILE.log,lv_procedure_name||',N='||l_bsv_temp);

195: pv_end ,
196: pn_branch );
197:
198: ELSE
199: FND_FILE.put_line(FND_FILE.log,lv_procedure_name||',N='||l_bsv_temp);
200: Combination_Exec(pn_chart_of_account_id,
201: pn_ledger_id,
202: pn_legal_entity_id ,
203: l_bsv_temp ,

Line 226: FND_FILE.put_line(FND_FILE.log,

222: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
223: '.Other_Exception ',
224: SQLCODE || SQLERRM);
225: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
226: FND_FILE.put_line(FND_FILE.log,
227: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
228: SQLCODE || SQLERRM);
229: RAISE;
230: END Recursion_BSV;

Line 310: FND_FILE.put_line(FND_FILE.log,

306: 'pv_xml_template_territory=' ||
307: pv_xml_template_territory || ',' ||
308: 'pv_xml_output_format=' || pv_xml_output_format);
309: END IF; --l_proc_level>=l_dbg_level
310: FND_FILE.put_line(FND_FILE.log,
311: lv_procedure_name || '.parameters:' ||
312: 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
313: 'pn_chart_of_account_id=' || pn_chart_of_account_id || ',' ||
314: 'pn_ledger_id=' || pn_ledger_id || ',' ||

Line 328: FND_FILE.put_line(FND_FILE.output,

324: pv_xml_template_territory || ',' ||
325: 'pv_xml_output_format=' || pv_xml_output_format);
326:
327: --Step0: Generate XML header part
328: FND_FILE.put_line(FND_FILE.output,
329: ' 330: JA_CN_UTILITY.Get_XML_Encoding || '"?>');
331:
332: --added by jar.wang for bug 16655327

Line 354: FND_FILE.put_line(FND_FILE.output, lv_gl_element);

350: ' xmlns:'||Ja_Cn_Utility.Get_XML_Tag('BANK')||'="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema"'
351: ||' xmlns="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema"' ||
352: ' xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">' ;
353:
354: FND_FILE.put_line(FND_FILE.output, lv_gl_element);
355:
356: FND_FILE.put_line(FND_FILE.log, 'Setup1:Add_GL_BALANCE');
357: Ja_Cn_Utility.Add_Sub_Root_Node('GL_BALANCE_FLIE',Ja_Cn_Utility.GV_TAG_TYPE_START);
358: Recursion_BSV(pn_chart_of_account_id ,

Line 356: FND_FILE.put_line(FND_FILE.log, 'Setup1:Add_GL_BALANCE');

352: ' xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">' ;
353:
354: FND_FILE.put_line(FND_FILE.output, lv_gl_element);
355:
356: FND_FILE.put_line(FND_FILE.log, 'Setup1:Add_GL_BALANCE');
357: Ja_Cn_Utility.Add_Sub_Root_Node('GL_BALANCE_FLIE',Ja_Cn_Utility.GV_TAG_TYPE_START);
358: Recursion_BSV(pn_chart_of_account_id ,
359: pn_ledger_id ,
360: pn_legal_entity_id ,

Line 369: FND_FILE.put_line(FND_FILE.log, 'Setup2:Add_GL_AVG_BAL');

365: 1 );
366: Print_GL_BALANCE;
367: Ja_Cn_Utility.Add_Sub_Root_Node('GL_BALANCE_FLIE', Ja_Cn_Utility.GV_TAG_TYPE_END);
368:
369: FND_FILE.put_line(FND_FILE.log, 'Setup2:Add_GL_AVG_BAL');
370: Ja_Cn_Utility.Add_Sub_Root_Node('GL_DETAIL_FILE',Ja_Cn_Utility.GV_TAG_TYPE_START);
371: Recursion_BSV(pn_chart_of_account_id ,
372: pn_ledger_id ,
373: pn_legal_entity_id ,

Line 383: FND_FILE.put_line(FND_FILE.log, 'Setup3:Add_GL_JOURNAL');

379: Print_GL_AVG_BAL;
380: Ja_Cn_Utility.Add_Sub_Root_Node('GL_DETAIL_FILE',Ja_Cn_Utility.GV_TAG_TYPE_END);
381:
382:
383: FND_FILE.put_line(FND_FILE.log, 'Setup3:Add_GL_JOURNAL');
384: Ja_Cn_Utility.Add_Sub_Root_Node('GL_JOURNAL_FILE',Ja_Cn_Utility.GV_TAG_TYPE_START);
385: Recursion_BSV(pn_chart_of_account_id ,
386: pn_ledger_id ,
387: pn_legal_entity_id ,

Line 394: FND_FILE.put_line(FND_FILE.output, Ja_Cn_Utility.Get_XML_Tag('GENERAL_LEDGER',Ja_Cn_Utility.GV_TAG_TYPE_END));

390: pv_period_from ,
391: pv_period_to ,
392: 3 );
393: Ja_Cn_Utility.Add_Sub_Root_Node('GL_JOURNAL_FILE', Ja_Cn_Utility.GV_TAG_TYPE_END);
394: FND_FILE.put_line(FND_FILE.output, Ja_Cn_Utility.Get_XML_Tag('GENERAL_LEDGER',Ja_Cn_Utility.GV_TAG_TYPE_END));
395: COMMIT;
396: --logging for debug
397: IF (ln_proc_level >= ln_dbg_level) THEN
398: FND_LOG.STRING(ln_proc_level,

Line 413: FND_FILE.put_line(FND_FILE.log,GV_MODULE_PREFIX||'.'||

409: SQLCODE || SQLERRM);
410: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
411: pv_retcode := '2';
412: pv_errbuf := SQLCODE || SQLERRM;
413: FND_FILE.put_line(FND_FILE.log,GV_MODULE_PREFIX||'.'||
414: lv_procedure_name ||': '|| SQLCODE || SQLERRM);
415: END Export_GL;
416:
417:

Line 567: FND_FILE.put_line(FND_FILE.log, lv_procedure_name||'Setup1.1');

563: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
564: '.begin',
565: 'Enter procedure');
566: END IF;
567: FND_FILE.put_line(FND_FILE.log, lv_procedure_name||'Setup1.1');
568: --Fetch start date and end date
569: Convert_Period(pn_ledger_id ,
570: pv_accounting_year ,
571: pv_start ,

Line 580: FND_FILE.put_line(FND_FILE.log, lv_procedure_name||'Setup1.2');

576: OPEN CUR_GL_BAL(l_period_from,l_period_to);
577: LOOP
578: FETCH CUR_GL_BAL INTO l_gl_bal;
579: EXIT WHEN CUR_GL_BAL%NOTFOUND;
580: FND_FILE.put_line(FND_FILE.log, lv_procedure_name||'Setup1.2');
581: INSERT INTO JA_CN_BANK_BALANCE_GT
582: (ACCOUNT_SEG,
583: CURRENCY_CODE,
584: PERIOD_YEAR,

Line 610: FND_FILE.put_line(FND_FILE.log, lv_procedure_name||'Setup1.3');

606: l_gl_bal.ytd_beq);
607: END LOOP;
608: CLOSE CUR_GL_BAL;
609:
610: FND_FILE.put_line(FND_FILE.log, lv_procedure_name||'Setup1.3');
611: --logging for debug
612: IF (ln_proc_level >= ln_dbg_level) THEN
613: FND_LOG.STRING(ln_proc_level,
614: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',

Line 691: FND_FILE.put_line(FND_FILE.log, lv_procedure_name||'Setup1.1');

687: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
688: '.begin',
689: 'Enter procedure');
690: END IF;
691: FND_FILE.put_line(FND_FILE.log, lv_procedure_name||'Setup1.1');
692:
693: OPEN CUR_GL_BAL;
694: LOOP
695: FETCH CUR_GL_BAL INTO l_gl_bal;

Line 698: FND_FILE.put_line(FND_FILE.log, lv_procedure_name||'Setup1.2');

694: LOOP
695: FETCH CUR_GL_BAL INTO l_gl_bal;
696: EXIT WHEN CUR_GL_BAL%NOTFOUND;
697: l_row_count:=l_row_count+1;
698: FND_FILE.put_line(FND_FILE.log, lv_procedure_name||'Setup1.2');
699: Ja_Cn_Utility.Add_Sub_Root_Node('GL_BALANCE',Ja_Cn_Utility.GV_TAG_TYPE_START);
700: Ja_Cn_Utility.Add_Child_Node('ACCOUNT_NUMBER',l_gl_bal.account_seg);
701: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE',l_gl_bal.currency_code);
702: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR',l_gl_bal.period_year);

Line 735: FND_FILE.put_line(FND_FILE.log, lv_procedure_name||'Setup1.3');

731: Ja_Cn_Utility.Add_Child_Node('END_FUNCTIONAL_BALANCE','');
732: Ja_Cn_Utility.Add_Sub_Root_Node('GL_BALANCE', Ja_Cn_Utility.GV_TAG_TYPE_END);
733: END IF;
734:
735: FND_FILE.put_line(FND_FILE.log, lv_procedure_name||'Setup1.3');
736: --logging for debug
737: IF (ln_proc_level >= ln_dbg_level) THEN
738: FND_LOG.STRING(ln_proc_level,
739: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',

Line 797: FND_FILE.put_line(FND_FILE.log, 'Setup2.1');

793: l_period_from DATE;
794: l_period_to DATE;
795: l_journal CUR_AVG_JOURNAL%ROWTYPE;
796: BEGIN
797: FND_FILE.put_line(FND_FILE.log, 'Setup2.1');
798: IF (ln_proc_level >= ln_dbg_level) THEN
799: FND_LOG.STRING(ln_proc_level,
800: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
801: '.begin',

Line 813: FND_FILE.put_line(FND_FILE.log, 'Setup2.2');

809: pv_end ,
810: l_period_from ,
811: l_period_to ) ;
812:
813: FND_FILE.put_line(FND_FILE.log, 'Setup2.2');
814: OPEN CUR_AVG_JOURNAL(l_period_from,l_period_to);
815: LOOP
816: FETCH CUR_AVG_JOURNAL INTO l_journal;
817: EXIT WHEN CUR_AVG_JOURNAL%NOTFOUND;

Line 819: FND_FILE.put_line(FND_FILE.log, 'Setup2.3');

815: LOOP
816: FETCH CUR_AVG_JOURNAL INTO l_journal;
817: EXIT WHEN CUR_AVG_JOURNAL%NOTFOUND;
818:
819: FND_FILE.put_line(FND_FILE.log, 'Setup2.3');
820: INSERT INTO JA_CN_BANK_AVG_BAL_GT
821: (ACCOUNT_SEG,
822: CURRENCY_CODE,
823: PERIOD_YEAR,

Line 843: FND_FILE.put_line(FND_FILE.log, 'Setup2.4');

839: l_journal.ACCOUNTED_CR);
840: END LOOP;
841: CLOSE CUR_AVG_JOURNAL;
842:
843: FND_FILE.put_line(FND_FILE.log, 'Setup2.4');
844: --logging for debug
845: IF (ln_proc_level >= ln_dbg_level) THEN
846: FND_LOG.STRING(ln_proc_level,
847: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',

Line 896: FND_FILE.put_line(FND_FILE.log, 'AVG Setup1.1 ');

892: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
893: '.begin',
894: 'Enter procedure');
895: END IF;
896: FND_FILE.put_line(FND_FILE.log, 'AVG Setup1.1 ');
897: OPEN CUR_AVG_JOURNAL;
898: LOOP
899: FETCH CUR_AVG_JOURNAL INTO l_journal;
900: EXIT WHEN CUR_AVG_JOURNAL%NOTFOUND;

Line 903: FND_FILE.put_line(FND_FILE.log, 'AVG Setup1.2 ');

899: FETCH CUR_AVG_JOURNAL INTO l_journal;
900: EXIT WHEN CUR_AVG_JOURNAL%NOTFOUND;
901: l_row_count :=l_row_count+1;
902: Ja_Cn_Utility.Add_Sub_Root_Node('GL_DETAIL',Ja_Cn_Utility.GV_TAG_TYPE_START);
903: FND_FILE.put_line(FND_FILE.log, 'AVG Setup1.2 ');
904: Ja_Cn_Utility.Add_Child_Node('ACCOUNT_NUMBER',l_journal.ACCOUNT_SEG );
905: Ja_Cn_Utility.Add_Child_Node('CURRENCY_CODE',l_journal.CURRENCY_CODE );
906: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR',l_journal.PERIOD_YEAR );
907: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER',l_journal.PERIOD_NUM );

Line 1057: FND_FILE.put_line(FND_FILE.log,'GL Setup:3.1');

1053: pv_end ,
1054: l_period_from ,
1055: l_period_to ) ;
1056:
1057: FND_FILE.put_line(FND_FILE.log,'GL Setup:3.1');
1058:
1059: OPEN CUR_JOURNAL(l_period_from,l_period_to);
1060: LOOP
1061: FETCH CUR_JOURNAL INTO l_journal;

Line 1063: FND_FILE.put_line(FND_FILE.log,'GL Setup:3.2');

1059: OPEN CUR_JOURNAL(l_period_from,l_period_to);
1060: LOOP
1061: FETCH CUR_JOURNAL INTO l_journal;
1062: EXIT WHEN CUR_JOURNAL%NOTFOUND;
1063: FND_FILE.put_line(FND_FILE.log,'GL Setup:3.2');
1064: l_row_num :=l_row_num+1;
1065: --get voucher number
1066: SELECT (SELECT NVL(VOUCHER_NUM, '') FROM JA_CN_BANK_JOURNAL
1067: WHERE JE_HEADER_ID = l_journal.Je_Header_Id AND JE_LINE_NUM = l_journal.Je_Line_Num )

Line 1079: FND_FILE.put_line(FND_FILE.log,'GL Setup:3.3:'||l_vouchernum_t);

1075: pv_bsv ,
1076: pn_ledger_id ,
1077: l_journal.PERIOD_NAME );
1078: END IF;
1079: FND_FILE.put_line(FND_FILE.log,'GL Setup:3.3:'||l_vouchernum_t);
1080: l_vouchernum := pv_bsv || l_vouchernum_t;
1081: INSERT INTO JA_CN_BANK_JOURNAL
1082: (JE_HEADER_ID,
1083: JE_LINE_NUM,

Line 1101: FND_FILE.put_line(FND_FILE.log,'GL Setup:3.4:'||l_vouchernum);

1097: sysdate,
1098: fnd_global.LOGIN_ID);
1099:
1100: END IF;
1101: FND_FILE.put_line(FND_FILE.log,'GL Setup:3.4:'||l_vouchernum);
1102: Ja_Cn_Utility.Add_Sub_Root_Node('GL_JOURNAL',Ja_Cn_Utility.GV_TAG_TYPE_START);
1103: Ja_Cn_Utility.Add_Child_Node('JOURNAL_NUMBER',l_vouchernum);
1104: Ja_Cn_Utility.Add_Child_Node('GL_JOURNAL_CREATION_DATE',l_journal.journal_date);
1105: Ja_Cn_Utility.Add_Child_Node('JOURNAL_DESCRIPTION',l_journal.DESCRIPTION);

Line 1140: FND_FILE.put_line(FND_FILE.log,'Warning:'||pv_bsv||','||l_mes);

1136:
1137: IF l_row_num=0 THEN
1138: FND_MESSAGE.SET_NAME('JA','JA_CN_NO_DATA_FOUND') ;
1139: l_mes := FND_MESSAGE.GET;
1140: FND_FILE.put_line(FND_FILE.log,'Warning:'||pv_bsv||','||l_mes);
1141:
1142: Ja_Cn_Utility.Add_Sub_Root_Node('GL_JOURNAL',Ja_Cn_Utility.GV_TAG_TYPE_START);
1143: Ja_Cn_Utility.Add_Child_Node('JOURNAL_NUMBER','');
1144: Ja_Cn_Utility.Add_Child_Node('GL_JOURNAL_CREATION_DATE','');

Line 1165: FND_FILE.put_line(FND_FILE.log,'GL Setup:3.5');

1161:
1162: Ja_Cn_Utility.Add_Sub_Root_Node('GL_JOURNAL', Ja_Cn_Utility.GV_TAG_TYPE_END);
1163: END IF;
1164:
1165: FND_FILE.put_line(FND_FILE.log,'GL Setup:3.5');
1166: --logging for debug
1167: IF (ln_proc_level >= ln_dbg_level) THEN
1168: FND_LOG.STRING(ln_proc_level,
1169: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',

Line 1181: FND_FILE.put_line(FND_FILE.log,GV_MODULE_PREFIX||'.'||

1177: ,GV_MODULE_PREFIX||'.'||lv_procedure_name||'EXCEPTION'
1178: ,SQLCODE||':'||SQLERRM
1179: );
1180: END IF;
1181: FND_FILE.put_line(FND_FILE.log,GV_MODULE_PREFIX||'.'||
1182: lv_procedure_name ||': '|| SQLCODE || SQLERRM);
1183: RAISE;
1184: END Add_GL_JOURNAL;
1185:

Line 1217: FND_FILE.put_line(FND_FILE.log,GV_MODULE_PREFIX||'.'||

1213: ,GV_MODULE_PREFIX||'.'||lv_procedure_name||'EXCEPTION'
1214: ,SQLCODE||':'||SQLERRM
1215: );
1216: END IF;
1217: FND_FILE.put_line(FND_FILE.log,GV_MODULE_PREFIX||'.'||
1218: lv_procedure_name ||': '|| SQLCODE || SQLERRM);
1219: RAISE;
1220: END Get_FullName;
1221:

Line 1272: FND_FILE.put_line(FND_FILE.log,GV_MODULE_PREFIX||'.'||

1268: ,GV_MODULE_PREFIX||'.'||lv_procedure_name||'EXCEPTION'
1269: ,SQLCODE||':'||SQLERRM
1270: );
1271: END IF;
1272: FND_FILE.put_line(FND_FILE.log,GV_MODULE_PREFIX||'.'||
1273: lv_procedure_name ||': '|| SQLCODE || SQLERRM);
1274: RAISE;
1275:
1276: END Get_Approver;