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 FND_FILE

Line 49: fnd_file.put_line(fnd_file.log,'Parameters..');

45: l_exc_lang_limit exception;
46:
47: begin
48:
49: fnd_file.put_line(fnd_file.log,'Parameters..');
50: fnd_file.put_line(fnd_file.log,'p_vat_reporting_entity_id :'||p_vat_reporting_entity_id);
51: fnd_file.put_line(fnd_file.log,'p_rep_period :'||p_rep_period);
52: fnd_file.put_line(fnd_file.log,'p_fax_number :'||p_fax_number);
53: fnd_file.put_line(fnd_file.log,'p_email :'||p_email);

Line 50: fnd_file.put_line(fnd_file.log,'p_vat_reporting_entity_id :'||p_vat_reporting_entity_id);

46:
47: begin
48:
49: fnd_file.put_line(fnd_file.log,'Parameters..');
50: fnd_file.put_line(fnd_file.log,'p_vat_reporting_entity_id :'||p_vat_reporting_entity_id);
51: fnd_file.put_line(fnd_file.log,'p_rep_period :'||p_rep_period);
52: fnd_file.put_line(fnd_file.log,'p_fax_number :'||p_fax_number);
53: fnd_file.put_line(fnd_file.log,'p_email :'||p_email);
54: fnd_file.put_line(fnd_file.log,'p_resp_email :'||p_resp_email);

Line 51: fnd_file.put_line(fnd_file.log,'p_rep_period :'||p_rep_period);

47: begin
48:
49: fnd_file.put_line(fnd_file.log,'Parameters..');
50: fnd_file.put_line(fnd_file.log,'p_vat_reporting_entity_id :'||p_vat_reporting_entity_id);
51: fnd_file.put_line(fnd_file.log,'p_rep_period :'||p_rep_period);
52: fnd_file.put_line(fnd_file.log,'p_fax_number :'||p_fax_number);
53: fnd_file.put_line(fnd_file.log,'p_email :'||p_email);
54: fnd_file.put_line(fnd_file.log,'p_resp_email :'||p_resp_email);
55: fnd_file.put_line(fnd_file.log,'p_trans_resp :'||p_trans_resp);

Line 52: fnd_file.put_line(fnd_file.log,'p_fax_number :'||p_fax_number);

48:
49: fnd_file.put_line(fnd_file.log,'Parameters..');
50: fnd_file.put_line(fnd_file.log,'p_vat_reporting_entity_id :'||p_vat_reporting_entity_id);
51: fnd_file.put_line(fnd_file.log,'p_rep_period :'||p_rep_period);
52: fnd_file.put_line(fnd_file.log,'p_fax_number :'||p_fax_number);
53: fnd_file.put_line(fnd_file.log,'p_email :'||p_email);
54: fnd_file.put_line(fnd_file.log,'p_resp_email :'||p_resp_email);
55: fnd_file.put_line(fnd_file.log,'p_trans_resp :'||p_trans_resp);
56: fnd_file.put_line(fnd_file.log,'p_trans_ackn :'||p_trans_ackn);

Line 53: fnd_file.put_line(fnd_file.log,'p_email :'||p_email);

49: fnd_file.put_line(fnd_file.log,'Parameters..');
50: fnd_file.put_line(fnd_file.log,'p_vat_reporting_entity_id :'||p_vat_reporting_entity_id);
51: fnd_file.put_line(fnd_file.log,'p_rep_period :'||p_rep_period);
52: fnd_file.put_line(fnd_file.log,'p_fax_number :'||p_fax_number);
53: fnd_file.put_line(fnd_file.log,'p_email :'||p_email);
54: fnd_file.put_line(fnd_file.log,'p_resp_email :'||p_resp_email);
55: fnd_file.put_line(fnd_file.log,'p_trans_resp :'||p_trans_resp);
56: fnd_file.put_line(fnd_file.log,'p_trans_ackn :'||p_trans_ackn);
57: fnd_file.put_line(fnd_file.log,'p_sec_resp :'||p_sec_resp);

Line 54: fnd_file.put_line(fnd_file.log,'p_resp_email :'||p_resp_email);

50: fnd_file.put_line(fnd_file.log,'p_vat_reporting_entity_id :'||p_vat_reporting_entity_id);
51: fnd_file.put_line(fnd_file.log,'p_rep_period :'||p_rep_period);
52: fnd_file.put_line(fnd_file.log,'p_fax_number :'||p_fax_number);
53: fnd_file.put_line(fnd_file.log,'p_email :'||p_email);
54: fnd_file.put_line(fnd_file.log,'p_resp_email :'||p_resp_email);
55: fnd_file.put_line(fnd_file.log,'p_trans_resp :'||p_trans_resp);
56: fnd_file.put_line(fnd_file.log,'p_trans_ackn :'||p_trans_ackn);
57: fnd_file.put_line(fnd_file.log,'p_sec_resp :'||p_sec_resp);
58: fnd_file.put_line(fnd_file.log,'p_sec_ackn :'||p_sec_ackn);

Line 55: fnd_file.put_line(fnd_file.log,'p_trans_resp :'||p_trans_resp);

51: fnd_file.put_line(fnd_file.log,'p_rep_period :'||p_rep_period);
52: fnd_file.put_line(fnd_file.log,'p_fax_number :'||p_fax_number);
53: fnd_file.put_line(fnd_file.log,'p_email :'||p_email);
54: fnd_file.put_line(fnd_file.log,'p_resp_email :'||p_resp_email);
55: fnd_file.put_line(fnd_file.log,'p_trans_resp :'||p_trans_resp);
56: fnd_file.put_line(fnd_file.log,'p_trans_ackn :'||p_trans_ackn);
57: fnd_file.put_line(fnd_file.log,'p_sec_resp :'||p_sec_resp);
58: fnd_file.put_line(fnd_file.log,'p_sec_ackn :'||p_sec_ackn);
59:

Line 56: fnd_file.put_line(fnd_file.log,'p_trans_ackn :'||p_trans_ackn);

52: fnd_file.put_line(fnd_file.log,'p_fax_number :'||p_fax_number);
53: fnd_file.put_line(fnd_file.log,'p_email :'||p_email);
54: fnd_file.put_line(fnd_file.log,'p_resp_email :'||p_resp_email);
55: fnd_file.put_line(fnd_file.log,'p_trans_resp :'||p_trans_resp);
56: fnd_file.put_line(fnd_file.log,'p_trans_ackn :'||p_trans_ackn);
57: fnd_file.put_line(fnd_file.log,'p_sec_resp :'||p_sec_resp);
58: fnd_file.put_line(fnd_file.log,'p_sec_ackn :'||p_sec_ackn);
59:
60: open c_get_reg_det(p_vat_reporting_entity_id);

Line 57: fnd_file.put_line(fnd_file.log,'p_sec_resp :'||p_sec_resp);

53: fnd_file.put_line(fnd_file.log,'p_email :'||p_email);
54: fnd_file.put_line(fnd_file.log,'p_resp_email :'||p_resp_email);
55: fnd_file.put_line(fnd_file.log,'p_trans_resp :'||p_trans_resp);
56: fnd_file.put_line(fnd_file.log,'p_trans_ackn :'||p_trans_ackn);
57: fnd_file.put_line(fnd_file.log,'p_sec_resp :'||p_sec_resp);
58: fnd_file.put_line(fnd_file.log,'p_sec_ackn :'||p_sec_ackn);
59:
60: open c_get_reg_det(p_vat_reporting_entity_id);
61: fetch c_get_reg_det into l_be_reg_number,l_legal_entity_id;

Line 58: fnd_file.put_line(fnd_file.log,'p_sec_ackn :'||p_sec_ackn);

54: fnd_file.put_line(fnd_file.log,'p_resp_email :'||p_resp_email);
55: fnd_file.put_line(fnd_file.log,'p_trans_resp :'||p_trans_resp);
56: fnd_file.put_line(fnd_file.log,'p_trans_ackn :'||p_trans_ackn);
57: fnd_file.put_line(fnd_file.log,'p_sec_resp :'||p_sec_resp);
58: fnd_file.put_line(fnd_file.log,'p_sec_ackn :'||p_sec_ackn);
59:
60: open c_get_reg_det(p_vat_reporting_entity_id);
61: fetch c_get_reg_det into l_be_reg_number,l_legal_entity_id;
62: close c_get_reg_det;

Line 87: fnd_file.put_line(fnd_file.log,'Survey Code :'||l_survey_code);

83: --get the value of form/survey code
84:
85: fnd_profile.get('JEBE_CSSR_SURVEY_CODE',l_survey_code);
86:
87: fnd_file.put_line(fnd_file.log,'Survey Code :'||l_survey_code);
88:
89: if (l_survey_code is null ) then
90: raise l_exc_survey_code_null;
91: end if;

Line 105: fnd_file.put_line(fnd_file.log,'Generating admin data....');

101: l_proc_status := 'Initilising the xml';
102:
103: g_vc_spacing := 1;
104:
105: fnd_file.put_line(fnd_file.log,'Generating admin data....');
106:
107: get_admin_data(
108: p_vat_reg_num =>l_be_reg_number,
109: p_email_address =>p_email,

Line 122: fnd_file.put_line(fnd_file.log,'Completed admin data');

118: p_survey_code =>l_survey_code,
119: p_period =>p_rep_period
120: );
121:
122: fnd_file.put_line(fnd_file.log,'Completed admin data');
123:
124: fnd_file.put_line(fnd_file.log,'Generating content data...');
125: get_content_data (l_survey_code,p_rep_period,p_vat_reporting_entity_id);
126: fnd_file.put_line(fnd_file.log,'Completed content data');

Line 124: fnd_file.put_line(fnd_file.log,'Generating content data...');

120: );
121:
122: fnd_file.put_line(fnd_file.log,'Completed admin data');
123:
124: fnd_file.put_line(fnd_file.log,'Generating content data...');
125: get_content_data (l_survey_code,p_rep_period,p_vat_reporting_entity_id);
126: fnd_file.put_line(fnd_file.log,'Completed content data');
127:
128: exception

Line 126: fnd_file.put_line(fnd_file.log,'Completed content data');

122: fnd_file.put_line(fnd_file.log,'Completed admin data');
123:
124: fnd_file.put_line(fnd_file.log,'Generating content data...');
125: get_content_data (l_survey_code,p_rep_period,p_vat_reporting_entity_id);
126: fnd_file.put_line(fnd_file.log,'Completed content data');
127:
128: exception
129: when l_exc_survey_code_null then
130: fnd_file.put_line(fnd_file.log,'-------------');

Line 130: fnd_file.put_line(fnd_file.log,'-------------');

126: fnd_file.put_line(fnd_file.log,'Completed content data');
127:
128: exception
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,'-------------');

Line 131: fnd_file.put_line(fnd_file.log,' ERROR LOG ');

127:
128: exception
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;

Line 132: fnd_file.put_line(fnd_file.log,'-------------');

128: exception
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;

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 134: fnd_file.put_line(fnd_file.log,'-------------');

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:
138: when l_exc_lang_limit then

Line 139: fnd_file.put_line(fnd_file.log,'-------------');

135: P_RETCODE := 2;
136: RETURN;
137:
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 ');

Line 140: fnd_file.put_line(fnd_file.log,' ERROR LOG ');

136: RETURN;
137:
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,'-------------');

Line 141: fnd_file.put_line(fnd_file.log,'-------------');

137:
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;

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 143: fnd_file.put_line(fnd_file.log,' EN DE NL FR ');

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;
147:

Line 144: 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;
147:
148: when others then

Line 149: fnd_file.put_line(fnd_file.log,'-------------');

145: P_RETCODE := 2;
146: RETURN;
147:
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');

Line 150: fnd_file.put_line(fnd_file.log,' ERROR LOG ');

146: RETURN;
147:
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,'-------------');

Line 151: fnd_file.put_line(fnd_file.log,'-------------');

147:
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;

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 153: fnd_file.put_line(fnd_file.log,' Please check if all the setup is done properly');

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;
157:

Line 154: 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;
157:
158: procedure get_admin_data

Line 195: fnd_file.put_line(fnd_file.output,l_var);

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
199: l_var := JE_BE_CSSR_PKG.level_up;

Line 197: fnd_file.put_line(fnd_file.output,'');

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
199: l_var := JE_BE_CSSR_PKG.level_up;
200: fnd_file.put_line(fnd_file.output,l_var||'');
201:

Line 200: 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;
204: fnd_file.put_line(fnd_file.output,l_var||'');

Line 204: fnd_file.put_line(fnd_file.output,l_var||'');

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;
208: fnd_file.put_line(fnd_file.output,l_var||'');

Line 208: fnd_file.put_line(fnd_file.output,l_var||'');

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;
212: if( p_name is not null ) then

Line 213: fnd_file.put_line(fnd_file.output,l_var||''||p_name||'');

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||'');
216: end if;
217: -- same level ..

Line 215: fnd_file.put_line(fnd_file.output,l_var||'');

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||'');
216: end if;
217: -- same level ..
218:
219: if(p_email_address is not null) then

Line 223: fnd_file.put_line(fnd_file.output,l_var||l_string);

219: if(p_email_address is not null) then
220: l_string := '';
223: fnd_file.put_line(fnd_file.output,l_var||l_string);
224: end if;
225:
226: if ( p_tel_num is not null ) then
227: l_string := ' 228: '2001/XMLSchema-instance" xsi:type="Telephone" number="' ||
229: p_tel_num || '" />';
230: fnd_file.put_line(fnd_file.output,l_var||l_string);
231: end if;
232:
233: if( p_fax_num is not null ) then
234: l_string := ' 235: '2001/XMLSchema-instance" xsi:type="Fax" number="' ||
236: p_fax_num || '" />';
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;

Line 242: fnd_file.put_line(fnd_file.output,l_var||'');

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||'');
246:

Line 245: fnd_file.put_line(fnd_file.output,l_var||'');

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:
249: -- receiver info open

Line 247: 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:
249: -- receiver info open
250: if( p_email_resp is not null or
251: p_trans_resp is not null or

Line 257: fnd_file.put_line(fnd_file.output,l_var||'');

253: p_sec_resp is not null or
254: p_sec_ackn is not null ) then
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

Line 262: 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)||'');
264: end if;
265:
266: -- transform response tag

Line 268: fnd_file.put_line(fnd_file.output,l_var||''

264: end if;
265:
266: -- transform response tag
267: if ( p_trans_resp is not null ) then
268: fnd_file.put_line(fnd_file.output,l_var||''
269: ||lower(p_trans_resp)||'');
270: end if;
271:
272: -- transform acknowledgement tag open

Line 274: fnd_file.put_line(fnd_file.output,l_var||''

270: end if;
271:
272: -- transform acknowledgement tag open
273: if ( p_trans_ackn is not null ) then
274: fnd_file.put_line(fnd_file.output,l_var||''
275: ||lower(p_trans_ackn)||'');
276: end if;
277:
278: -- secure response tag

Line 280: fnd_file.put_line(fnd_file.output,l_var||''

276: end if;
277:
278: -- secure response tag
279: if ( p_sec_resp is not null ) then
280: fnd_file.put_line(fnd_file.output,l_var||''
281: ||lower(p_sec_resp)||'');
282: end if;
283:
284: -- secure acknowledgement tag

Line 286: fnd_file.put_line(fnd_file.output,l_var||''

282: end if;
283:
284: -- secure acknowledgement tag
285: if ( p_sec_ackn is not null ) then
286: fnd_file.put_line(fnd_file.output,l_var||''
287: ||lower(p_sec_ackn)||'');
288: end if;
289:
290: open c_get_iso_lang;

Line 294: fnd_file.put_line(fnd_file.output,l_var||l_string);

290: open c_get_iso_lang;
291: fetch c_get_iso_lang into l_iso_lang;
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

Line 299: fnd_file.put_line(fnd_file.output,l_var||'');

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
301: fnd_file.put_line(fnd_file.output,l_var||'');
302: end if;
303: --admin close

Line 301: fnd_file.put_line(fnd_file.output,l_var||'');

297:
298: -- processsing parameters tag close
299: fnd_file.put_line(fnd_file.output,l_var||'');
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||'');

Line 305: fnd_file.put_line(fnd_file.output,l_var||'');

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:
309:

Line 393: fnd_file.put_line(fnd_file.log,'Reporting level :'||l_reporting_level);

389: ,l_reporting_level
390: ,l_legal_entity_id;
391: close get_disp_period;
392:
393: fnd_file.put_line(fnd_file.log,'Reporting level :'||l_reporting_level);
394: fnd_file.put_line(fnd_file.log,'Legal Entity ID :'||l_legal_entity_id);
395: fnd_file.put_line(fnd_file.log,'Ledger ID :'||l_ledger_id);
396: fnd_file.put_line(fnd_file.log,'Balancing Segment Value :'||l_bsv);
397: fnd_file.put_line(fnd_file.log,'Start Date :'||l_start_date);

Line 394: fnd_file.put_line(fnd_file.log,'Legal Entity ID :'||l_legal_entity_id);

390: ,l_legal_entity_id;
391: close get_disp_period;
392:
393: fnd_file.put_line(fnd_file.log,'Reporting level :'||l_reporting_level);
394: fnd_file.put_line(fnd_file.log,'Legal Entity ID :'||l_legal_entity_id);
395: fnd_file.put_line(fnd_file.log,'Ledger ID :'||l_ledger_id);
396: fnd_file.put_line(fnd_file.log,'Balancing Segment Value :'||l_bsv);
397: fnd_file.put_line(fnd_file.log,'Start Date :'||l_start_date);
398: fnd_file.put_line(fnd_file.log,'End Date :'||l_end_date);

Line 395: fnd_file.put_line(fnd_file.log,'Ledger ID :'||l_ledger_id);

391: close get_disp_period;
392:
393: fnd_file.put_line(fnd_file.log,'Reporting level :'||l_reporting_level);
394: fnd_file.put_line(fnd_file.log,'Legal Entity ID :'||l_legal_entity_id);
395: fnd_file.put_line(fnd_file.log,'Ledger ID :'||l_ledger_id);
396: fnd_file.put_line(fnd_file.log,'Balancing Segment Value :'||l_bsv);
397: fnd_file.put_line(fnd_file.log,'Start Date :'||l_start_date);
398: fnd_file.put_line(fnd_file.log,'End Date :'||l_end_date);
399:

Line 396: fnd_file.put_line(fnd_file.log,'Balancing Segment Value :'||l_bsv);

392:
393: fnd_file.put_line(fnd_file.log,'Reporting level :'||l_reporting_level);
394: fnd_file.put_line(fnd_file.log,'Legal Entity ID :'||l_legal_entity_id);
395: fnd_file.put_line(fnd_file.log,'Ledger ID :'||l_ledger_id);
396: fnd_file.put_line(fnd_file.log,'Balancing Segment Value :'||l_bsv);
397: fnd_file.put_line(fnd_file.log,'Start Date :'||l_start_date);
398: fnd_file.put_line(fnd_file.log,'End Date :'||l_end_date);
399:
400: l_string := '

Line 397: fnd_file.put_line(fnd_file.log,'Start Date :'||l_start_date);

393: fnd_file.put_line(fnd_file.log,'Reporting level :'||l_reporting_level);
394: fnd_file.put_line(fnd_file.log,'Legal Entity ID :'||l_legal_entity_id);
395: fnd_file.put_line(fnd_file.log,'Ledger ID :'||l_ledger_id);
396: fnd_file.put_line(fnd_file.log,'Balancing Segment Value :'||l_bsv);
397: fnd_file.put_line(fnd_file.log,'Start Date :'||l_start_date);
398: fnd_file.put_line(fnd_file.log,'End Date :'||l_end_date);
399:
400: l_string := ' 401: ||'xsi:type="BbpAcquisitionDataset" survey="' || p_survey_code ||'" per="'

Line 398: fnd_file.put_line(fnd_file.log,'End Date :'||l_end_date);

394: fnd_file.put_line(fnd_file.log,'Legal Entity ID :'||l_legal_entity_id);
395: fnd_file.put_line(fnd_file.log,'Ledger ID :'||l_ledger_id);
396: fnd_file.put_line(fnd_file.log,'Balancing Segment Value :'||l_bsv);
397: fnd_file.put_line(fnd_file.log,'Start Date :'||l_start_date);
398: fnd_file.put_line(fnd_file.log,'End Date :'||l_end_date);
399:
400: l_string := ' 401: ||'xsi:type="BbpAcquisitionDataset" survey="' || p_survey_code ||'" per="'
402: || l_disp_period ||'">';

Line 405: fnd_file.put_line(fnd_file.output,l_var||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;
409:

Line 417: fnd_file.put_line(fnd_file.log,'Char of account id :'||l_coa_id);

413: open get_coa_id(l_sob_id);
414: fetch get_coa_id into l_coa_id;
415: close get_coa_id;
416:
417: fnd_file.put_line(fnd_file.log,'Char of account id :'||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;

Line 424: fnd_file.put_line(fnd_file.log,'Accounting Segment :'||l_seg_name);

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;
427:
428: l_var := JE_BE_CSSR_PKG.level_up;

Line 431: -- fnd_file.put_line(fnd_file.output,l_var||l_string);

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:
433: --to op tag level
434: l_var := JE_BE_CSSR_PKG.level_up;
435: l_cntnt_prsnc_flag := 0;

Line 765: fnd_file.put_line(fnd_file.output,l_string ||' nihil = "false">');

761: ' />' ;
762:
763: if ( l_cntnt_prsnc_flag = 0) then
764: l_cntnt_prsnc_flag := 1;
765: fnd_file.put_line(fnd_file.output,l_string ||' nihil = "false">');
766: end if;
767: fnd_file.put_line(fnd_file.output,l_var||l_op_string);
768: end loop;
769: CLOSE op_curvar;

Line 767: fnd_file.put_line(fnd_file.output,l_var||l_op_string);

763: if ( l_cntnt_prsnc_flag = 0) then
764: l_cntnt_prsnc_flag := 1;
765: fnd_file.put_line(fnd_file.output,l_string ||' nihil = "false">');
766: end if;
767: fnd_file.put_line(fnd_file.output,l_var||l_op_string);
768: end loop;
769: CLOSE op_curvar;
770: -- end loop;
771: --to form tag level

Line 775: fnd_file.put_line(fnd_file.output,l_var||l_string);

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
777: fnd_file.put_line(fnd_file.output,l_string ||' nihil = "true" />');
778: end if;
779:

Line 777: fnd_file.put_line(fnd_file.output,l_string ||' nihil = "true" />');

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
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;

Line 782: fnd_file.put_line(fnd_file.output,l_var||'');

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;
786: fnd_file.put_line(fnd_file.output,'');

Line 786: fnd_file.put_line(fnd_file.output,'');

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:
790: function level_up

Line 853: fnd_file.put_line(fnd_file.log,' Exception in get_bsv function : ' || SUBSTR(SQLERRM,1,200));

849: RETURN (bal_segment_value);
850:
851: EXCEPTION
852: WHEN NO_DATA_FOUND THEN
853: fnd_file.put_line(fnd_file.log,' Exception in get_bsv function : ' || SUBSTR(SQLERRM,1,200));
854: RETURN NULL;
855:
856: END get_bsv;
857:

Line 906: fnd_file.put_line(fnd_file.log,' No record was returned for the Accounting segment. Error : ' || SUBSTR(SQLERRM,1,200));

902: RETURN (l_segment);
903:
904: EXCEPTION
905: WHEN NO_DATA_FOUND THEN
906: fnd_file.put_line(fnd_file.log,' No record was returned for the Accounting segment. Error : ' || SUBSTR(SQLERRM,1,200));
907: RETURN NULL;
908:
909: END get_accounting_segment;
910: