171: */
172: ld_start_date := fnd_date.canonical_to_date(p_start_date);
173: ld_end_date := fnd_date.canonical_to_date(p_end_date) ;
174:
175: fnd_file.put_line(FND_FILE.LOG,'Input parameters are p_org_id-> ' || p_org_id
176: ||' ,p_start_date -> ' || p_start_date
177: ||' ,p_end_date -> ' || p_end_date
178: ||' ,p_customer_trx_id -> ' || p_customer_trx_id); --bug#5194107
179:
183: ln_last_update_login := fnd_global.login_id; --bug#5194107
184:
185: ln_org_id := mo_global.get_current_org_id() ; -- Harshita for Bug 5490479
186:
187: fnd_file.put_line(FND_FILE.LOG,'Processing Customer Trx id : ' || p_customer_trx_id);
188:
189: for delivery_rec in c_delivery(ld_start_date , ld_end_Date)
190: Loop
191: fnd_file.put_line(FND_FILE.LOG,'Delivery id : ' || delivery_rec.interface_line_attribute3);
187: fnd_file.put_line(FND_FILE.LOG,'Processing Customer Trx id : ' || p_customer_trx_id);
188:
189: for delivery_rec in c_delivery(ld_start_date , ld_end_Date)
190: Loop
191: fnd_file.put_line(FND_FILE.LOG,'Delivery id : ' || delivery_rec.interface_line_attribute3);
192: fnd_file.put_line(FND_FILE.LOG,'Customer Trx Line id : ' ||delivery_rec.customer_trx_line_id);
193: --added for bug#6685050, start
194: OPEN c_same_inv_no(delivery_rec.customer_trx_id);
195: FETCH c_same_inv_no INTO lv_same_inv_no;
188:
189: for delivery_rec in c_delivery(ld_start_date , ld_end_Date)
190: Loop
191: fnd_file.put_line(FND_FILE.LOG,'Delivery id : ' || delivery_rec.interface_line_attribute3);
192: fnd_file.put_line(FND_FILE.LOG,'Customer Trx Line id : ' ||delivery_rec.customer_trx_line_id);
193: --added for bug#6685050, start
194: OPEN c_same_inv_no(delivery_rec.customer_trx_id);
195: FETCH c_same_inv_no INTO lv_same_inv_no;
196: CLOSE c_same_inv_no;
219:
220: --start additions by vkaranam for bug#5194107
221: IF ln_vat_invoice_no IS NOT NULL or ld_vat_invoice_date IS NOT NULL THEN
222:
223: fnd_file.put_line(FND_FILE.LOG,' VAT invoice No -> '||ln_vat_invoice_no
224: || ', VAT inv date -> ' ||ld_vat_invoice_date
225: ||' for customer_trx_id -> '||delivery_rec.customer_trx_id );
226:
227: UPDATE JAI_AR_TRXS
253: p_param3 => ln_vat_invoice_no, --added for bug#6685050
254: p_param4 => lv_same_inv_no); --added for bug#6685050
255:
256: IF retcode <> 0 THEN
257: fnd_file.put_line(FND_FILE.LOG,'System encountered the error '||errbuf);
258: raise_application_error(20011,'System encountered the error '||errbuf);
259: END IF;
260: END IF;
261: --End of Addition by anujsax for Bug#5636544