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.JE_BE_CSSR_PKG dependencies on JE_BE_CSSR_PKG

Line 1: PACKAGE BODY JE_BE_CSSR_PKG AS

1: PACKAGE BODY JE_BE_CSSR_PKG AS
2: /* $Header: jebecsrb.pls 120.1.12010000.3 2008/09/02 07:16:30 vgadde ship $ */
3:
4: procedure main(
5: p_errbuf OUT NOCOPY VARCHAR2,

Line 133: fnd_file.put_line(fnd_file.log,' JE_BE_CSSR_PKG: JEBE: Survey code Profile Option not set ');

129: when l_exc_survey_code_null then
130: fnd_file.put_line(fnd_file.log,'-------------');
131: fnd_file.put_line(fnd_file.log,' ERROR LOG ');
132: fnd_file.put_line(fnd_file.log,'-------------');
133: fnd_file.put_line(fnd_file.log,' JE_BE_CSSR_PKG: JEBE: Survey code Profile Option not set ');
134: fnd_file.put_line(fnd_file.log,'-------------');
135: P_RETCODE := 2;
136: RETURN;
137:

Line 142: fnd_file.put_line(fnd_file.log,' JE_BE_CSSR_PKG: The Report can be run for only the following languages');

138: when l_exc_lang_limit then
139: fnd_file.put_line(fnd_file.log,'-------------');
140: fnd_file.put_line(fnd_file.log,' ERROR LOG ');
141: fnd_file.put_line(fnd_file.log,'-------------');
142: fnd_file.put_line(fnd_file.log,' JE_BE_CSSR_PKG: The Report can be run for only the following languages');
143: fnd_file.put_line(fnd_file.log,' EN DE NL FR ');
144: fnd_file.put_line(fnd_file.log,'-------------');
145: P_RETCODE := 2;
146: RETURN;

Line 152: fnd_file.put_line(fnd_file.log,' Unexpected error occured in the JE_BE_CSSR_PKG package');

148: when others then
149: fnd_file.put_line(fnd_file.log,'-------------');
150: fnd_file.put_line(fnd_file.log,' ERROR LOG ');
151: fnd_file.put_line(fnd_file.log,'-------------');
152: fnd_file.put_line(fnd_file.log,' Unexpected error occured in the JE_BE_CSSR_PKG package');
153: fnd_file.put_line(fnd_file.log,' Please check if all the setup is done properly');
154: fnd_file.put_line(fnd_file.log,'-------------');
155: raise;
156: end main;

Line 194: l_var := JE_BE_CSSR_PKG.level_up;

190: into l_sysdate
191: from dual;
192: --main open
193: -- g_xml := '';
194: l_var := JE_BE_CSSR_PKG.level_up;
195: fnd_file.put_line(fnd_file.output,l_var);
196:
197: fnd_file.put_line(fnd_file.output,'');
198: --admin open

Line 199: l_var := JE_BE_CSSR_PKG.level_up;

195: fnd_file.put_line(fnd_file.output,l_var);
196:
197: fnd_file.put_line(fnd_file.output,'');
198: --admin open
199: l_var := JE_BE_CSSR_PKG.level_up;
200: fnd_file.put_line(fnd_file.output,l_var||'');
201:
202: -- sender info open
203: l_var := JE_BE_CSSR_PKG.level_up;

Line 203: l_var := JE_BE_CSSR_PKG.level_up;

199: l_var := JE_BE_CSSR_PKG.level_up;
200: fnd_file.put_line(fnd_file.output,l_var||'');
201:
202: -- sender info open
203: l_var := JE_BE_CSSR_PKG.level_up;
204: fnd_file.put_line(fnd_file.output,l_var||'');
205:
206: --contact tag open
207: l_var := JE_BE_CSSR_PKG.level_up;

Line 207: l_var := JE_BE_CSSR_PKG.level_up;

203: l_var := JE_BE_CSSR_PKG.level_up;
204: fnd_file.put_line(fnd_file.output,l_var||'');
205:
206: --contact tag open
207: l_var := JE_BE_CSSR_PKG.level_up;
208: fnd_file.put_line(fnd_file.output,l_var||'');
209:
210: -- name tag open and close
211: l_var := JE_BE_CSSR_PKG.level_up;

Line 211: l_var := JE_BE_CSSR_PKG.level_up;

207: l_var := JE_BE_CSSR_PKG.level_up;
208: fnd_file.put_line(fnd_file.output,l_var||'');
209:
210: -- name tag open and close
211: l_var := JE_BE_CSSR_PKG.level_up;
212: if( p_name is not null ) then
213: fnd_file.put_line(fnd_file.output,l_var||''||p_name||'');
214: else
215: fnd_file.put_line(fnd_file.output,l_var||'');

Line 241: l_var := JE_BE_CSSR_PKG.level_down;

237: fnd_file.put_line(fnd_file.output,l_var||l_string);
238: end if;
239:
240: -- contact tag close
241: l_var := JE_BE_CSSR_PKG.level_down;
242: fnd_file.put_line(fnd_file.output,l_var||'');
243: -- sender info close
244: l_var := JE_BE_CSSR_PKG.level_down;
245: fnd_file.put_line(fnd_file.output,l_var||'');

Line 244: l_var := JE_BE_CSSR_PKG.level_down;

240: -- contact tag close
241: l_var := JE_BE_CSSR_PKG.level_down;
242: fnd_file.put_line(fnd_file.output,l_var||'');
243: -- sender info close
244: l_var := JE_BE_CSSR_PKG.level_down;
245: fnd_file.put_line(fnd_file.output,l_var||'');
246:
247: fnd_file.put_line(fnd_file.output,l_var||'');
248:

Line 259: l_var := JE_BE_CSSR_PKG.level_up;

255:
256: -- processsing parameters tag open
257: fnd_file.put_line(fnd_file.output,l_var||'');
258:
259: l_var := JE_BE_CSSR_PKG.level_up;
260: -- email response tag
261: if ( p_email_resp is not null ) then
262: fnd_file.put_line(fnd_file.output,l_var||''
263: ||lower(p_email_resp)||'');

Line 296: l_var := JE_BE_CSSR_PKG.level_down;

292: close c_get_iso_lang;
293: l_string := ''||l_iso_lang||'';
294: fnd_file.put_line(fnd_file.output,l_var||l_string);
295:
296: l_var := JE_BE_CSSR_PKG.level_down;
297:
298: -- processsing parameters tag close
299: fnd_file.put_line(fnd_file.output,l_var||'');
300: else

Line 304: l_var := JE_BE_CSSR_PKG.level_down;

300: else
301: fnd_file.put_line(fnd_file.output,l_var||'');
302: end if;
303: --admin close
304: l_var := JE_BE_CSSR_PKG.level_down;
305: fnd_file.put_line(fnd_file.output,l_var||'');
306:
307: end get_admin_data;
308:

Line 403: l_var := JE_BE_CSSR_PKG.level_down;

399:
400: l_string := ' 401: ||'xsi:type="BbpAcquisitionDataset" survey="' || p_survey_code ||'" per="'
402: || l_disp_period ||'">';
403: l_var := JE_BE_CSSR_PKG.level_down;
404: l_var := JE_BE_CSSR_PKG.level_up;
405: fnd_file.put_line(fnd_file.output,l_var||l_string);
406:
407: IF l_reporting_level <> 'LE' THEN

Line 404: l_var := JE_BE_CSSR_PKG.level_up;

400: l_string := ' 401: ||'xsi:type="BbpAcquisitionDataset" survey="' || p_survey_code ||'" per="'
402: || l_disp_period ||'">';
403: l_var := JE_BE_CSSR_PKG.level_down;
404: l_var := JE_BE_CSSR_PKG.level_up;
405: fnd_file.put_line(fnd_file.output,l_var||l_string);
406:
407: IF l_reporting_level <> 'LE' THEN
408: l_sob_id := l_ledger_id;

Line 422: l_seg_name := JE_BE_CSSR_PKG.get_accounting_segment(l_coa_id);

418:
419: -- Get the accounting/natural segment for the chart of accounts defined.
420:
421: l_status_text := ' Get the accounting/natural segment for coa '||l_coa_id;
422: l_seg_name := JE_BE_CSSR_PKG.get_accounting_segment(l_coa_id);
423:
424: fnd_file.put_line(fnd_file.log,'Accounting Segment :'||l_seg_name);
425:
426: END IF;

Line 428: l_var := JE_BE_CSSR_PKG.level_up;

424: fnd_file.put_line(fnd_file.log,'Accounting Segment :'||l_seg_name);
425:
426: END IF;
427:
428: l_var := JE_BE_CSSR_PKG.level_up;
429: l_string := l_var ||'

430: -- dbms_lob.writeappend(g_xml,length(l_var||l_string),l_var||l_string);
431: -- fnd_file.put_line(fnd_file.output,l_var||l_string);
432:

Line 434: l_var := JE_BE_CSSR_PKG.level_up;

430: -- dbms_lob.writeappend(g_xml,length(l_var||l_string),l_var||l_string);
431: -- fnd_file.put_line(fnd_file.output,l_var||l_string);
432:
433: --to op tag level
434: l_var := JE_BE_CSSR_PKG.level_up;
435: l_cntnt_prsnc_flag := 0;
436: -- 4. get a list of defined mappings and get the corresponding ccids.
437: -- 4a. find the totals for AP and AR and produce the codes.
438:

Line 556: AND JE_BE_CSSR_PKG.get_bsv(ap_inv.set_of_books_id,glcc.chart_of_accounts_id,ap_dist.dist_code_combination_id) = :bsv1

552: AND glcc.'||l_seg_name||' = lv.lookup_code
553: AND lv.lookup_type = ''JEBE_NBBN_CODES''
554: AND lv.LANGUAGE = USERENV(''LANG'')
555: AND ap_inv.set_of_books_id = :v_sob_id1
556: AND JE_BE_CSSR_PKG.get_bsv(ap_inv.set_of_books_id,glcc.chart_of_accounts_id,ap_dist.dist_code_combination_id) = :bsv1
557: AND ven.country <> ''BE''
558: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
559: ap_dist.ACCRUAL_POSTED_FLAG,
560: ap_dist.CASH_POSTED_FLAG,

Line 603: AND JE_BE_CSSR_PKG.get_bsv(trx.set_of_books_id,glcc.chart_of_accounts_id,gld.code_combination_id) = :bsv2

599: AND lv.lookup_type = ''JEBE_NBBN_CODES''
600: AND glcc.'||l_seg_name||' = lv.lookup_code
601: AND lv.LANGUAGE = USERENV(''LANG'')
602: AND trx.set_of_books_id = :v_sob_id2
603: AND JE_BE_CSSR_PKG.get_bsv(trx.set_of_books_id,glcc.chart_of_accounts_id,gld.code_combination_id) = :bsv2
604: AND hzl.country <> ''BE''
605: AND gld.GL_DATE BETWEEN :v_start_date2 AND :v_end_date2
606: AND trx.complete_flag = ''Y''
607: AND gld.posting_control_id <> -3

Line 642: AND JE_BE_CSSR_PKG.get_accounting_segment(glr.chart_of_accounts_id,ap_dist.dist_code_combination_id) = lv.lookup_code

638: WHERE ap_inv.legal_entity_id = :p_legal_entity_id1
639: AND ap_inv.vendor_site_id = ven.vendor_site_id
640: AND ap_dist.invoice_id = ap_inv.invoice_id
641: AND glr.ledger_id = ap_inv.set_of_books_id
642: AND JE_BE_CSSR_PKG.get_accounting_segment(glr.chart_of_accounts_id,ap_dist.dist_code_combination_id) = lv.lookup_code
643: AND lv.lookup_type = ''JEBE_NBBN_CODES''
644: AND lv.LANGUAGE = USERENV(''LANG'')
645: AND ven.country <> ''BE''
646: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(

Line 691: AND JE_BE_CSSR_PKG.get_accounting_segment(glr.chart_of_accounts_id, gld.code_combination_id ) = lv.lookup_code

687: AND hzl.country <> ''BE''
688: AND gld.GL_DATE BETWEEN :v_start_date2 AND :v_end_date2
689: AND trx.complete_flag = ''Y''
690: AND gld.posting_control_id <> -3
691: AND JE_BE_CSSR_PKG.get_accounting_segment(glr.chart_of_accounts_id, gld.code_combination_id ) = lv.lookup_code
692: GROUP BY hzl.COUNTRY,
693: invoice_currency_code,
694: trx.customer_trx_id,
695: decode (instr(lv.description,'':''), 0,lv.description, substr(lv.description,0,instr(lv.description,'':'')-1)),

Line 772: l_var := JE_BE_CSSR_PKG.level_down;

768: end loop;
769: CLOSE op_curvar;
770: -- end loop;
771: --to form tag level
772: l_var := JE_BE_CSSR_PKG.level_down;
773: if( l_cntnt_prsnc_flag = 1 ) then
774: l_string := '

';
775: fnd_file.put_line(fnd_file.output,l_var||l_string);
776: else

Line 781: l_var := JE_BE_CSSR_PKG.level_down;

777: fnd_file.put_line(fnd_file.output,l_string ||' nihil = "true" />');
778: end if;
779:
780: --content tag close
781: l_var := JE_BE_CSSR_PKG.level_down;
782: fnd_file.put_line(fnd_file.output,l_var||'');
783:
784: --main close
785: l_var := JE_BE_CSSR_PKG.level_down;

Line 785: l_var := JE_BE_CSSR_PKG.level_down;

781: l_var := JE_BE_CSSR_PKG.level_down;
782: fnd_file.put_line(fnd_file.output,l_var||'');
783:
784: --main close
785: l_var := JE_BE_CSSR_PKG.level_down;
786: fnd_file.put_line(fnd_file.output,'');
787:
788: end get_content_data;
789:

Line 912: end JE_BE_CSSR_PKG;

908:
909: END get_accounting_segment;
910:
911:
912: end JE_BE_CSSR_PKG;