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

Line 192: fnd_file.put_line(FND_FILE.LOG,'Start************');

188: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_export_oriented_unit is ' || v_export_oriented_unit);
189: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_register_code is ' || v_register_code);
190: END IF;
191:
192: fnd_file.put_line(FND_FILE.LOG,'************************Start************************************');
193: fnd_file.put_line(FND_FILE.LOG,'The Time Stamp this Entry is Created is ' ||TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS'));
194: fnd_file.put_line(FND_FILE.LOG,'The Value of v_pref_rg23a is ' || v_pref_rg23a);
195: fnd_file.put_line(FND_FILE.LOG,'The Value of v_pref_rg23c is ' || v_pref_rg23c);
196: fnd_file.put_line(FND_FILE.LOG,'The Value of v_pref_pla is ' || v_pref_pla);

Line 193: fnd_file.put_line(FND_FILE.LOG,'The Time Stamp this Entry is Created is ' ||TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS'));

189: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_register_code is ' || v_register_code);
190: END IF;
191:
192: fnd_file.put_line(FND_FILE.LOG,'************************Start************************************');
193: fnd_file.put_line(FND_FILE.LOG,'The Time Stamp this Entry is Created is ' ||TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS'));
194: fnd_file.put_line(FND_FILE.LOG,'The Value of v_pref_rg23a is ' || v_pref_rg23a);
195: fnd_file.put_line(FND_FILE.LOG,'The Value of v_pref_rg23c is ' || v_pref_rg23c);
196: fnd_file.put_line(FND_FILE.LOG,'The Value of v_pref_pla is ' || v_pref_pla);
197: fnd_file.put_line(FND_FILE.LOG,'The Value of v_rg23a_balance is ' ||v_rg23a_balance);

Line 194: fnd_file.put_line(FND_FILE.LOG,'The Value of v_pref_rg23a is ' || v_pref_rg23a);

190: END IF;
191:
192: fnd_file.put_line(FND_FILE.LOG,'************************Start************************************');
193: fnd_file.put_line(FND_FILE.LOG,'The Time Stamp this Entry is Created is ' ||TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS'));
194: fnd_file.put_line(FND_FILE.LOG,'The Value of v_pref_rg23a is ' || v_pref_rg23a);
195: fnd_file.put_line(FND_FILE.LOG,'The Value of v_pref_rg23c is ' || v_pref_rg23c);
196: fnd_file.put_line(FND_FILE.LOG,'The Value of v_pref_pla is ' || v_pref_pla);
197: fnd_file.put_line(FND_FILE.LOG,'The Value of v_rg23a_balance is ' ||v_rg23a_balance);
198: fnd_file.put_line(FND_FILE.LOG,'The Value of v_rg23c_balance is ' ||v_rg23c_balance);

Line 195: fnd_file.put_line(FND_FILE.LOG,'The Value of v_pref_rg23c is ' || v_pref_rg23c);

191:
192: fnd_file.put_line(FND_FILE.LOG,'************************Start************************************');
193: fnd_file.put_line(FND_FILE.LOG,'The Time Stamp this Entry is Created is ' ||TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS'));
194: fnd_file.put_line(FND_FILE.LOG,'The Value of v_pref_rg23a is ' || v_pref_rg23a);
195: fnd_file.put_line(FND_FILE.LOG,'The Value of v_pref_rg23c is ' || v_pref_rg23c);
196: fnd_file.put_line(FND_FILE.LOG,'The Value of v_pref_pla is ' || v_pref_pla);
197: fnd_file.put_line(FND_FILE.LOG,'The Value of v_rg23a_balance is ' ||v_rg23a_balance);
198: fnd_file.put_line(FND_FILE.LOG,'The Value of v_rg23c_balance is ' ||v_rg23c_balance);
199: fnd_file.put_line(FND_FILE.LOG,'The Value of v_pla_balance is ' ||v_pla_balance);

Line 196: fnd_file.put_line(FND_FILE.LOG,'The Value of v_pref_pla is ' || v_pref_pla);

192: fnd_file.put_line(FND_FILE.LOG,'************************Start************************************');
193: fnd_file.put_line(FND_FILE.LOG,'The Time Stamp this Entry is Created is ' ||TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS'));
194: fnd_file.put_line(FND_FILE.LOG,'The Value of v_pref_rg23a is ' || v_pref_rg23a);
195: fnd_file.put_line(FND_FILE.LOG,'The Value of v_pref_rg23c is ' || v_pref_rg23c);
196: fnd_file.put_line(FND_FILE.LOG,'The Value of v_pref_pla is ' || v_pref_pla);
197: fnd_file.put_line(FND_FILE.LOG,'The Value of v_rg23a_balance is ' ||v_rg23a_balance);
198: fnd_file.put_line(FND_FILE.LOG,'The Value of v_rg23c_balance is ' ||v_rg23c_balance);
199: fnd_file.put_line(FND_FILE.LOG,'The Value of v_pla_balance is ' ||v_pla_balance);
200: fnd_file.put_line(FND_FILE.LOG,'The Value of v_ssi_unit_flag is ' ||v_ssi_unit_flag);

Line 197: fnd_file.put_line(FND_FILE.LOG,'The Value of v_rg23a_balance is ' ||v_rg23a_balance);

193: fnd_file.put_line(FND_FILE.LOG,'The Time Stamp this Entry is Created is ' ||TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS'));
194: fnd_file.put_line(FND_FILE.LOG,'The Value of v_pref_rg23a is ' || v_pref_rg23a);
195: fnd_file.put_line(FND_FILE.LOG,'The Value of v_pref_rg23c is ' || v_pref_rg23c);
196: fnd_file.put_line(FND_FILE.LOG,'The Value of v_pref_pla is ' || v_pref_pla);
197: fnd_file.put_line(FND_FILE.LOG,'The Value of v_rg23a_balance is ' ||v_rg23a_balance);
198: fnd_file.put_line(FND_FILE.LOG,'The Value of v_rg23c_balance is ' ||v_rg23c_balance);
199: fnd_file.put_line(FND_FILE.LOG,'The Value of v_pla_balance is ' ||v_pla_balance);
200: fnd_file.put_line(FND_FILE.LOG,'The Value of v_ssi_unit_flag is ' ||v_ssi_unit_flag);
201: fnd_file.put_line(FND_FILE.LOG,'The Value of v_tot_excise_amt is ' ||v_tot_excise_amt);

Line 198: fnd_file.put_line(FND_FILE.LOG,'The Value of v_rg23c_balance is ' ||v_rg23c_balance);

194: fnd_file.put_line(FND_FILE.LOG,'The Value of v_pref_rg23a is ' || v_pref_rg23a);
195: fnd_file.put_line(FND_FILE.LOG,'The Value of v_pref_rg23c is ' || v_pref_rg23c);
196: fnd_file.put_line(FND_FILE.LOG,'The Value of v_pref_pla is ' || v_pref_pla);
197: fnd_file.put_line(FND_FILE.LOG,'The Value of v_rg23a_balance is ' ||v_rg23a_balance);
198: fnd_file.put_line(FND_FILE.LOG,'The Value of v_rg23c_balance is ' ||v_rg23c_balance);
199: fnd_file.put_line(FND_FILE.LOG,'The Value of v_pla_balance is ' ||v_pla_balance);
200: fnd_file.put_line(FND_FILE.LOG,'The Value of v_ssi_unit_flag is ' ||v_ssi_unit_flag);
201: fnd_file.put_line(FND_FILE.LOG,'The Value of v_tot_excise_amt is ' ||v_tot_excise_amt);
202: fnd_file.put_line(FND_FILE.LOG,'The Value of v_basic_pla_balance is ' ||v_basic_pla_balance);

Line 199: fnd_file.put_line(FND_FILE.LOG,'The Value of v_pla_balance is ' ||v_pla_balance);

195: fnd_file.put_line(FND_FILE.LOG,'The Value of v_pref_rg23c is ' || v_pref_rg23c);
196: fnd_file.put_line(FND_FILE.LOG,'The Value of v_pref_pla is ' || v_pref_pla);
197: fnd_file.put_line(FND_FILE.LOG,'The Value of v_rg23a_balance is ' ||v_rg23a_balance);
198: fnd_file.put_line(FND_FILE.LOG,'The Value of v_rg23c_balance is ' ||v_rg23c_balance);
199: fnd_file.put_line(FND_FILE.LOG,'The Value of v_pla_balance is ' ||v_pla_balance);
200: fnd_file.put_line(FND_FILE.LOG,'The Value of v_ssi_unit_flag is ' ||v_ssi_unit_flag);
201: fnd_file.put_line(FND_FILE.LOG,'The Value of v_tot_excise_amt is ' ||v_tot_excise_amt);
202: fnd_file.put_line(FND_FILE.LOG,'The Value of v_basic_pla_balance is ' ||v_basic_pla_balance);
203: fnd_file.put_line(FND_FILE.LOG,'The Value of v_additional_pla_balance is ' ||v_additional_pla_balance);

Line 200: fnd_file.put_line(FND_FILE.LOG,'The Value of v_ssi_unit_flag is ' ||v_ssi_unit_flag);

196: fnd_file.put_line(FND_FILE.LOG,'The Value of v_pref_pla is ' || v_pref_pla);
197: fnd_file.put_line(FND_FILE.LOG,'The Value of v_rg23a_balance is ' ||v_rg23a_balance);
198: fnd_file.put_line(FND_FILE.LOG,'The Value of v_rg23c_balance is ' ||v_rg23c_balance);
199: fnd_file.put_line(FND_FILE.LOG,'The Value of v_pla_balance is ' ||v_pla_balance);
200: fnd_file.put_line(FND_FILE.LOG,'The Value of v_ssi_unit_flag is ' ||v_ssi_unit_flag);
201: fnd_file.put_line(FND_FILE.LOG,'The Value of v_tot_excise_amt is ' ||v_tot_excise_amt);
202: fnd_file.put_line(FND_FILE.LOG,'The Value of v_basic_pla_balance is ' ||v_basic_pla_balance);
203: fnd_file.put_line(FND_FILE.LOG,'The Value of v_additional_pla_balance is ' ||v_additional_pla_balance);
204: fnd_file.put_line(FND_FILE.LOG,'The Value of v_other_pla_balance is ' ||v_other_pla_balance);

Line 201: fnd_file.put_line(FND_FILE.LOG,'The Value of v_tot_excise_amt is ' ||v_tot_excise_amt);

197: fnd_file.put_line(FND_FILE.LOG,'The Value of v_rg23a_balance is ' ||v_rg23a_balance);
198: fnd_file.put_line(FND_FILE.LOG,'The Value of v_rg23c_balance is ' ||v_rg23c_balance);
199: fnd_file.put_line(FND_FILE.LOG,'The Value of v_pla_balance is ' ||v_pla_balance);
200: fnd_file.put_line(FND_FILE.LOG,'The Value of v_ssi_unit_flag is ' ||v_ssi_unit_flag);
201: fnd_file.put_line(FND_FILE.LOG,'The Value of v_tot_excise_amt is ' ||v_tot_excise_amt);
202: fnd_file.put_line(FND_FILE.LOG,'The Value of v_basic_pla_balance is ' ||v_basic_pla_balance);
203: fnd_file.put_line(FND_FILE.LOG,'The Value of v_additional_pla_balance is ' ||v_additional_pla_balance);
204: fnd_file.put_line(FND_FILE.LOG,'The Value of v_other_pla_balance is ' ||v_other_pla_balance);
205: fnd_file.put_line(FND_FILE.LOG,'The Value of v_basic_excise_duty_amount is ' ||v_basic_excise_duty_amount);

Line 202: fnd_file.put_line(FND_FILE.LOG,'The Value of v_basic_pla_balance is ' ||v_basic_pla_balance);

198: fnd_file.put_line(FND_FILE.LOG,'The Value of v_rg23c_balance is ' ||v_rg23c_balance);
199: fnd_file.put_line(FND_FILE.LOG,'The Value of v_pla_balance is ' ||v_pla_balance);
200: fnd_file.put_line(FND_FILE.LOG,'The Value of v_ssi_unit_flag is ' ||v_ssi_unit_flag);
201: fnd_file.put_line(FND_FILE.LOG,'The Value of v_tot_excise_amt is ' ||v_tot_excise_amt);
202: fnd_file.put_line(FND_FILE.LOG,'The Value of v_basic_pla_balance is ' ||v_basic_pla_balance);
203: fnd_file.put_line(FND_FILE.LOG,'The Value of v_additional_pla_balance is ' ||v_additional_pla_balance);
204: fnd_file.put_line(FND_FILE.LOG,'The Value of v_other_pla_balance is ' ||v_other_pla_balance);
205: fnd_file.put_line(FND_FILE.LOG,'The Value of v_basic_excise_duty_amount is ' ||v_basic_excise_duty_amount);
206: fnd_file.put_line(FND_FILE.LOG,'The Value of v_add_excise_duty_amount is ' ||v_add_excise_duty_amount);

Line 203: fnd_file.put_line(FND_FILE.LOG,'The Value of v_additional_pla_balance is ' ||v_additional_pla_balance);

199: fnd_file.put_line(FND_FILE.LOG,'The Value of v_pla_balance is ' ||v_pla_balance);
200: fnd_file.put_line(FND_FILE.LOG,'The Value of v_ssi_unit_flag is ' ||v_ssi_unit_flag);
201: fnd_file.put_line(FND_FILE.LOG,'The Value of v_tot_excise_amt is ' ||v_tot_excise_amt);
202: fnd_file.put_line(FND_FILE.LOG,'The Value of v_basic_pla_balance is ' ||v_basic_pla_balance);
203: fnd_file.put_line(FND_FILE.LOG,'The Value of v_additional_pla_balance is ' ||v_additional_pla_balance);
204: fnd_file.put_line(FND_FILE.LOG,'The Value of v_other_pla_balance is ' ||v_other_pla_balance);
205: fnd_file.put_line(FND_FILE.LOG,'The Value of v_basic_excise_duty_amount is ' ||v_basic_excise_duty_amount);
206: fnd_file.put_line(FND_FILE.LOG,'The Value of v_add_excise_duty_amount is ' ||v_add_excise_duty_amount);
207: fnd_file.put_line(FND_FILE.LOG,'The Value of v_oth_excise_duty_amount is ' ||v_oth_excise_duty_amount);

Line 204: fnd_file.put_line(FND_FILE.LOG,'The Value of v_other_pla_balance is ' ||v_other_pla_balance);

200: fnd_file.put_line(FND_FILE.LOG,'The Value of v_ssi_unit_flag is ' ||v_ssi_unit_flag);
201: fnd_file.put_line(FND_FILE.LOG,'The Value of v_tot_excise_amt is ' ||v_tot_excise_amt);
202: fnd_file.put_line(FND_FILE.LOG,'The Value of v_basic_pla_balance is ' ||v_basic_pla_balance);
203: fnd_file.put_line(FND_FILE.LOG,'The Value of v_additional_pla_balance is ' ||v_additional_pla_balance);
204: fnd_file.put_line(FND_FILE.LOG,'The Value of v_other_pla_balance is ' ||v_other_pla_balance);
205: fnd_file.put_line(FND_FILE.LOG,'The Value of v_basic_excise_duty_amount is ' ||v_basic_excise_duty_amount);
206: fnd_file.put_line(FND_FILE.LOG,'The Value of v_add_excise_duty_amount is ' ||v_add_excise_duty_amount);
207: fnd_file.put_line(FND_FILE.LOG,'The Value of v_oth_excise_duty_amount is ' ||v_oth_excise_duty_amount);
208: fnd_file.put_line(FND_FILE.LOG,'The Value of v_export_oriented_unit is ' || v_export_oriented_unit);

Line 205: fnd_file.put_line(FND_FILE.LOG,'The Value of v_basic_excise_duty_amount is ' ||v_basic_excise_duty_amount);

201: fnd_file.put_line(FND_FILE.LOG,'The Value of v_tot_excise_amt is ' ||v_tot_excise_amt);
202: fnd_file.put_line(FND_FILE.LOG,'The Value of v_basic_pla_balance is ' ||v_basic_pla_balance);
203: fnd_file.put_line(FND_FILE.LOG,'The Value of v_additional_pla_balance is ' ||v_additional_pla_balance);
204: fnd_file.put_line(FND_FILE.LOG,'The Value of v_other_pla_balance is ' ||v_other_pla_balance);
205: fnd_file.put_line(FND_FILE.LOG,'The Value of v_basic_excise_duty_amount is ' ||v_basic_excise_duty_amount);
206: fnd_file.put_line(FND_FILE.LOG,'The Value of v_add_excise_duty_amount is ' ||v_add_excise_duty_amount);
207: fnd_file.put_line(FND_FILE.LOG,'The Value of v_oth_excise_duty_amount is ' ||v_oth_excise_duty_amount);
208: fnd_file.put_line(FND_FILE.LOG,'The Value of v_export_oriented_unit is ' || v_export_oriented_unit);
209: fnd_file.put_line(FND_FILE.LOG,'The Value of v_register_code is ' || v_register_code);

Line 206: fnd_file.put_line(FND_FILE.LOG,'The Value of v_add_excise_duty_amount is ' ||v_add_excise_duty_amount);

202: fnd_file.put_line(FND_FILE.LOG,'The Value of v_basic_pla_balance is ' ||v_basic_pla_balance);
203: fnd_file.put_line(FND_FILE.LOG,'The Value of v_additional_pla_balance is ' ||v_additional_pla_balance);
204: fnd_file.put_line(FND_FILE.LOG,'The Value of v_other_pla_balance is ' ||v_other_pla_balance);
205: fnd_file.put_line(FND_FILE.LOG,'The Value of v_basic_excise_duty_amount is ' ||v_basic_excise_duty_amount);
206: fnd_file.put_line(FND_FILE.LOG,'The Value of v_add_excise_duty_amount is ' ||v_add_excise_duty_amount);
207: fnd_file.put_line(FND_FILE.LOG,'The Value of v_oth_excise_duty_amount is ' ||v_oth_excise_duty_amount);
208: fnd_file.put_line(FND_FILE.LOG,'The Value of v_export_oriented_unit is ' || v_export_oriented_unit);
209: fnd_file.put_line(FND_FILE.LOG,'The Value of v_register_code is ' || v_register_code);
210: fnd_file.put_line(FND_FILE.LOG,'The Value of delivery id '|| p_delivery_id);

Line 207: fnd_file.put_line(FND_FILE.LOG,'The Value of v_oth_excise_duty_amount is ' ||v_oth_excise_duty_amount);

203: fnd_file.put_line(FND_FILE.LOG,'The Value of v_additional_pla_balance is ' ||v_additional_pla_balance);
204: fnd_file.put_line(FND_FILE.LOG,'The Value of v_other_pla_balance is ' ||v_other_pla_balance);
205: fnd_file.put_line(FND_FILE.LOG,'The Value of v_basic_excise_duty_amount is ' ||v_basic_excise_duty_amount);
206: fnd_file.put_line(FND_FILE.LOG,'The Value of v_add_excise_duty_amount is ' ||v_add_excise_duty_amount);
207: fnd_file.put_line(FND_FILE.LOG,'The Value of v_oth_excise_duty_amount is ' ||v_oth_excise_duty_amount);
208: fnd_file.put_line(FND_FILE.LOG,'The Value of v_export_oriented_unit is ' || v_export_oriented_unit);
209: fnd_file.put_line(FND_FILE.LOG,'The Value of v_register_code is ' || v_register_code);
210: fnd_file.put_line(FND_FILE.LOG,'The Value of delivery id '|| p_delivery_id);
211: fnd_file.put_line(FND_FILE.LOG,'The Value of organization id '|| p_organization_id);

Line 208: fnd_file.put_line(FND_FILE.LOG,'The Value of v_export_oriented_unit is ' || v_export_oriented_unit);

204: fnd_file.put_line(FND_FILE.LOG,'The Value of v_other_pla_balance is ' ||v_other_pla_balance);
205: fnd_file.put_line(FND_FILE.LOG,'The Value of v_basic_excise_duty_amount is ' ||v_basic_excise_duty_amount);
206: fnd_file.put_line(FND_FILE.LOG,'The Value of v_add_excise_duty_amount is ' ||v_add_excise_duty_amount);
207: fnd_file.put_line(FND_FILE.LOG,'The Value of v_oth_excise_duty_amount is ' ||v_oth_excise_duty_amount);
208: fnd_file.put_line(FND_FILE.LOG,'The Value of v_export_oriented_unit is ' || v_export_oriented_unit);
209: fnd_file.put_line(FND_FILE.LOG,'The Value of v_register_code is ' || v_register_code);
210: fnd_file.put_line(FND_FILE.LOG,'The Value of delivery id '|| p_delivery_id);
211: fnd_file.put_line(FND_FILE.LOG,'The Value of organization id '|| p_organization_id);
212: fnd_file.put_line(FND_FILE.LOG,'The Value of location id '|| p_location_id);

Line 209: fnd_file.put_line(FND_FILE.LOG,'The Value of v_register_code is ' || v_register_code);

205: fnd_file.put_line(FND_FILE.LOG,'The Value of v_basic_excise_duty_amount is ' ||v_basic_excise_duty_amount);
206: fnd_file.put_line(FND_FILE.LOG,'The Value of v_add_excise_duty_amount is ' ||v_add_excise_duty_amount);
207: fnd_file.put_line(FND_FILE.LOG,'The Value of v_oth_excise_duty_amount is ' ||v_oth_excise_duty_amount);
208: fnd_file.put_line(FND_FILE.LOG,'The Value of v_export_oriented_unit is ' || v_export_oriented_unit);
209: fnd_file.put_line(FND_FILE.LOG,'The Value of v_register_code is ' || v_register_code);
210: fnd_file.put_line(FND_FILE.LOG,'The Value of delivery id '|| p_delivery_id);
211: fnd_file.put_line(FND_FILE.LOG,'The Value of organization id '|| p_organization_id);
212: fnd_file.put_line(FND_FILE.LOG,'The Value of location id '|| p_location_id);
213: fnd_file.put_line(FND_FILE.LOG,'The Value of cess amount'|| p_cess_amount);

Line 210: fnd_file.put_line(FND_FILE.LOG,'The Value of delivery id '|| p_delivery_id);

206: fnd_file.put_line(FND_FILE.LOG,'The Value of v_add_excise_duty_amount is ' ||v_add_excise_duty_amount);
207: fnd_file.put_line(FND_FILE.LOG,'The Value of v_oth_excise_duty_amount is ' ||v_oth_excise_duty_amount);
208: fnd_file.put_line(FND_FILE.LOG,'The Value of v_export_oriented_unit is ' || v_export_oriented_unit);
209: fnd_file.put_line(FND_FILE.LOG,'The Value of v_register_code is ' || v_register_code);
210: fnd_file.put_line(FND_FILE.LOG,'The Value of delivery id '|| p_delivery_id);
211: fnd_file.put_line(FND_FILE.LOG,'The Value of organization id '|| p_organization_id);
212: fnd_file.put_line(FND_FILE.LOG,'The Value of location id '|| p_location_id);
213: fnd_file.put_line(FND_FILE.LOG,'The Value of cess amount'|| p_cess_amount);
214: fnd_file.put_line(FND_FILE.LOG,'The Value of sh cess amount'|| p_sh_cess_amount);

Line 211: fnd_file.put_line(FND_FILE.LOG,'The Value of organization id '|| p_organization_id);

207: fnd_file.put_line(FND_FILE.LOG,'The Value of v_oth_excise_duty_amount is ' ||v_oth_excise_duty_amount);
208: fnd_file.put_line(FND_FILE.LOG,'The Value of v_export_oriented_unit is ' || v_export_oriented_unit);
209: fnd_file.put_line(FND_FILE.LOG,'The Value of v_register_code is ' || v_register_code);
210: fnd_file.put_line(FND_FILE.LOG,'The Value of delivery id '|| p_delivery_id);
211: fnd_file.put_line(FND_FILE.LOG,'The Value of organization id '|| p_organization_id);
212: fnd_file.put_line(FND_FILE.LOG,'The Value of location id '|| p_location_id);
213: fnd_file.put_line(FND_FILE.LOG,'The Value of cess amount'|| p_cess_amount);
214: fnd_file.put_line(FND_FILE.LOG,'The Value of sh cess amount'|| p_sh_cess_amount);
215: -----------------------------------------------------------------------------------------------------------------

Line 212: fnd_file.put_line(FND_FILE.LOG,'The Value of location id '|| p_location_id);

208: fnd_file.put_line(FND_FILE.LOG,'The Value of v_export_oriented_unit is ' || v_export_oriented_unit);
209: fnd_file.put_line(FND_FILE.LOG,'The Value of v_register_code is ' || v_register_code);
210: fnd_file.put_line(FND_FILE.LOG,'The Value of delivery id '|| p_delivery_id);
211: fnd_file.put_line(FND_FILE.LOG,'The Value of organization id '|| p_organization_id);
212: fnd_file.put_line(FND_FILE.LOG,'The Value of location id '|| p_location_id);
213: fnd_file.put_line(FND_FILE.LOG,'The Value of cess amount'|| p_cess_amount);
214: fnd_file.put_line(FND_FILE.LOG,'The Value of sh cess amount'|| p_sh_cess_amount);
215: -----------------------------------------------------------------------------------------------------------------
216: BEGIN

Line 213: fnd_file.put_line(FND_FILE.LOG,'The Value of cess amount'|| p_cess_amount);

209: fnd_file.put_line(FND_FILE.LOG,'The Value of v_register_code is ' || v_register_code);
210: fnd_file.put_line(FND_FILE.LOG,'The Value of delivery id '|| p_delivery_id);
211: fnd_file.put_line(FND_FILE.LOG,'The Value of organization id '|| p_organization_id);
212: fnd_file.put_line(FND_FILE.LOG,'The Value of location id '|| p_location_id);
213: fnd_file.put_line(FND_FILE.LOG,'The Value of cess amount'|| p_cess_amount);
214: fnd_file.put_line(FND_FILE.LOG,'The Value of sh cess amount'|| p_sh_cess_amount);
215: -----------------------------------------------------------------------------------------------------------------
216: BEGIN
217:

Line 214: fnd_file.put_line(FND_FILE.LOG,'The Value of sh cess amount'|| p_sh_cess_amount);

210: fnd_file.put_line(FND_FILE.LOG,'The Value of delivery id '|| p_delivery_id);
211: fnd_file.put_line(FND_FILE.LOG,'The Value of organization id '|| p_organization_id);
212: fnd_file.put_line(FND_FILE.LOG,'The Value of location id '|| p_location_id);
213: fnd_file.put_line(FND_FILE.LOG,'The Value of cess amount'|| p_cess_amount);
214: fnd_file.put_line(FND_FILE.LOG,'The Value of sh cess amount'|| p_sh_cess_amount);
215: -----------------------------------------------------------------------------------------------------------------
216: BEGIN
217:
218: fnd_file.put_line(FND_FILE.LOG, ' Call RG others check balances');

Line 218: fnd_file.put_line(FND_FILE.LOG, ' Call RG others check balances');

214: fnd_file.put_line(FND_FILE.LOG,'The Value of sh cess amount'|| p_sh_cess_amount);
215: -----------------------------------------------------------------------------------------------------------------
216: BEGIN
217:
218: fnd_file.put_line(FND_FILE.LOG, ' Call RG others check balances');
219:
220: lv_register_type := 'RG23A';
221: jai_cmn_rg_others_pkg.check_balances(
222: p_organization_id => p_organization_id ,

Line 232: fnd_file.put_line(FND_FILE.LOG, ' Problem in cess balance');

228: );
229:
230: if lv_process_flag <> jai_constants.successful then
231: lv_rg23a_cess_avlbl := 'FALSE';
232: fnd_file.put_line(FND_FILE.LOG, ' Problem in cess balance');
233: else
234: lv_rg23a_cess_avlbl := 'TRUE';
235: end if;
236:

Line 237: fnd_file.put_line(FND_FILE.LOG, ' call RG others sh check balances');

233: else
234: lv_rg23a_cess_avlbl := 'TRUE';
235: end if;
236:
237: fnd_file.put_line(FND_FILE.LOG, ' call RG others sh check balances');
238: /* added by ssawant for bug 5989740 */
239: jai_cmn_rg_others_pkg .check_sh_balances(
240: p_organization_id => p_organization_id ,
241: p_location_id => p_location_id ,

Line 250: fnd_file.put_line(FND_FILE.LOG, ' Problem in SH cess balance');

246: );
247:
248: if lv_process_flag <> jai_constants.successful then
249: lv_rg23a_sh_cess_avlbl := 'FALSE';
250: fnd_file.put_line(FND_FILE.LOG, ' Problem in SH cess balance');
251: else
252: lv_rg23a_sh_cess_avlbl := 'TRUE';
253: end if;
254:

Line 255: fnd_file.put_line(FND_FILE.LOG, ' call rg23 c check balances');

251: else
252: lv_rg23a_sh_cess_avlbl := 'TRUE';
253: end if;
254:
255: fnd_file.put_line(FND_FILE.LOG, ' call rg23 c check balances');
256:
257: lv_register_type := 'RG23C';
258: jai_cmn_rg_others_pkg.check_balances(
259: p_organization_id => p_organization_id ,

Line 269: fnd_file.put_line(FND_FILE.LOG, ' Problem in cess balance');

265: );
266:
267: if lv_process_flag <> jai_constants.successful then
268: lv_rg23c_cess_avlbl := 'FALSE';
269: fnd_file.put_line(FND_FILE.LOG, ' Problem in cess balance');
270: else
271: lv_rg23c_cess_avlbl := 'TRUE';
272: end if;
273: fnd_file.put_line(FND_FILE.LOG, ' call rg 23 c sh check balances');

Line 273: fnd_file.put_line(FND_FILE.LOG, ' call rg 23 c sh check balances');

269: fnd_file.put_line(FND_FILE.LOG, ' Problem in cess balance');
270: else
271: lv_rg23c_cess_avlbl := 'TRUE';
272: end if;
273: fnd_file.put_line(FND_FILE.LOG, ' call rg 23 c sh check balances');
274:
275: /* added by ssawant for bug 5989740 */
276: lv_register_type := 'RG23C';
277: jai_cmn_rg_others_pkg .check_sh_balances(

Line 292: fnd_file.put_line(FND_FILE.LOG, ' call pla check balances');

288: else
289: lv_rg23c_sh_cess_avlbl := 'TRUE';
290: end if;
291:
292: fnd_file.put_line(FND_FILE.LOG, ' call pla check balances');
293:
294: lv_register_type := 'PLA';
295: jai_cmn_rg_others_pkg.check_balances(
296: p_organization_id => p_organization_id ,

Line 309: fnd_file.put_line(FND_FILE.LOG, ' call pla sh check balances');

305: lv_pla_cess_avlbl := 'FALSE';
306: else
307: lv_pla_cess_avlbl := 'TRUE';
308: end if;
309: fnd_file.put_line(FND_FILE.LOG, ' call pla sh check balances');
310:
311: /* added by ssawant for bug 5989740 */
312: jai_cmn_rg_others_pkg .check_sh_balances(
313: p_organization_id => p_organization_id ,

Line 323: fnd_file.put_line(FND_FILE.LOG, ' Problem in SH cess balance');

319: );
320:
321: if lv_process_flag <> jai_constants.successful then
322: lv_pla_sh_cess_avlbl := 'FALSE';
323: fnd_file.put_line(FND_FILE.LOG, ' Problem in SH cess balance');
324: else
325: lv_pla_sh_cess_avlbl := 'TRUE';
326: end if;
327:

Line 440: fnd_file.put_line(FND_FILE.LOG, ' validation for export excise ');

436:
437: --Balance Validations if EOU is Yes.....
438: ELSIF v_export_oriented_unit ='Y' and v_register_code='EXPORT_EXCISE' then
439:
440: fnd_file.put_line(FND_FILE.LOG, ' validation for export excise ');
441:
442: --Validation for Basic Excise Duty Amount.
443: IF nvl(v_basic_excise_duty_amount,0) >0 THEN
444: IF v_basic_pla_balance >= v_basic_excise_duty_amount AND lv_pla_cess_avlbl = 'TRUE' AND lv_pla_sh_cess_avlbl = 'TRUE' then /* added by ssawant for bug 5989740 */

Line 451: fnd_file.put_line(FND_FILE.LOG, ' Basic - reg type '|| v_reg_type);

447: v_reg_type := 'ERROR';
448: END IF;
449: END IF;
450:
451: fnd_file.put_line(FND_FILE.LOG, ' Basic - reg type '|| v_reg_type);
452:
453: --Validation for Additional Excise Duty Amount.
454: IF v_reg_type<>'ERROR' THEN
455: IF nvl(v_add_excise_duty_amount,0) >0 THEN

Line 465: fnd_file.put_line(FND_FILE.LOG, ' Additional - reg type '|| v_reg_type);

461: END IF;
462: END IF;
463: END IF;
464:
465: fnd_file.put_line(FND_FILE.LOG, ' Additional - reg type '|| v_reg_type);
466:
467: --Validation for Other Excise Duty Amount.
468: IF v_reg_type<>'ERROR' THEN
469:

Line 480: fnd_file.put_line(FND_FILE.LOG, ' Other reg type '|| v_reg_type);

476: END IF;
477: END IF;
478:
479: END IF; --End of Export Oriented Check......
480: fnd_file.put_line(FND_FILE.LOG, ' Other reg type '|| v_reg_type);
481: -----------------------------------------------------------------------------------------------------------------
482: EXCEPTION
483: when others then
484: fnd_file.put_line(FND_FILE.LOG, ' Error raised ni excise_balance_check function');

Line 484: fnd_file.put_line(FND_FILE.LOG, ' Error raised ni excise_balance_check function');

480: fnd_file.put_line(FND_FILE.LOG, ' Other reg type '|| v_reg_type);
481: -----------------------------------------------------------------------------------------------------------------
482: EXCEPTION
483: when others then
484: fnd_file.put_line(FND_FILE.LOG, ' Error raised ni excise_balance_check function');
485: raise_application_error(-20001,'Error Raised in excise_balance_check function');
486: END;
487:
488: --To Raise an Application Error in the Function only rather than in the Trigger or Procedure........

Line 507: fnd_file.put_line(FND_FILE.LOG, 'None of the Register Have Balances Greater OR Equal TO the Excisable Amount ->'

503: UTL_FILE.PUT_LINE(v_myfilehandle,'************************END************************************');
504: UTL_FILE.FCLOSE(v_myfileHandle);
505: END IF;
506: IF v_export_oriented_unit ='N' THEN
507: fnd_file.put_line(FND_FILE.LOG, 'None of the Register Have Balances Greater OR Equal TO the Excisable Amount ->'
508: || TO_CHAR(v_tot_excise_amt )||' OR Education Cess Amount => ' || to_char(p_cess_amount) );
509: RAISE_APPLICATION_ERROR(-20120, 'None of the Register Have Balances Greater OR Equal TO the Excisable Amount ->'
510: || TO_CHAR(v_tot_excise_amt )||' OR Education Cess Amount => ' || to_char(p_cess_amount) );
511: ELSIF v_export_oriented_unit ='Y' and v_register_code='EXPORT_EXCISE' THEN

Line 512: fnd_file.put_line(FND_FILE.LOG, 'The Excise Component Balances are not sufficient' );

508: || TO_CHAR(v_tot_excise_amt )||' OR Education Cess Amount => ' || to_char(p_cess_amount) );
509: RAISE_APPLICATION_ERROR(-20120, 'None of the Register Have Balances Greater OR Equal TO the Excisable Amount ->'
510: || TO_CHAR(v_tot_excise_amt )||' OR Education Cess Amount => ' || to_char(p_cess_amount) );
511: ELSIF v_export_oriented_unit ='Y' and v_register_code='EXPORT_EXCISE' THEN
512: fnd_file.put_line(FND_FILE.LOG, 'The Excise Component Balances are not sufficient' );
513: RAISE_APPLICATION_ERROR(-20120, 'The Excise Component Balances are not sufficient');
514: fnd_file.put_line(FND_FILE.LOG, ' The Excise Component Balances are not sufficient ');
515: END IF;
516: END IF;

Line 514: fnd_file.put_line(FND_FILE.LOG, ' The Excise Component Balances are not sufficient ');

510: || TO_CHAR(v_tot_excise_amt )||' OR Education Cess Amount => ' || to_char(p_cess_amount) );
511: ELSIF v_export_oriented_unit ='Y' and v_register_code='EXPORT_EXCISE' THEN
512: fnd_file.put_line(FND_FILE.LOG, 'The Excise Component Balances are not sufficient' );
513: RAISE_APPLICATION_ERROR(-20120, 'The Excise Component Balances are not sufficient');
514: fnd_file.put_line(FND_FILE.LOG, ' The Excise Component Balances are not sufficient ');
515: END IF;
516: END IF;
517:
518: RETURN(v_reg_type);