2171: lv_appl_src, /*'JA_IN_OE_AR_LINES_INSERT_TRG', Ramananda for removal of SQL LITERALs */
2172: lv_err_msg, /* 'Default Location is not setup for Inventory Organization ' || pr_new.warehouse_id , */
2173: lv_addl_msg, /* 'Please setup the Default Location in Organization Additional Information Screen for Trx id : ' || pr_new.customer_trx_id , */
2174: sysdate,
2175: fnd_global.user_id ,
2176: -- added, Harshita for Bug 4866533
2177: fnd_global.user_id,
2178: sysdate
2179: );
2173: lv_addl_msg, /* 'Please setup the Default Location in Organization Additional Information Screen for Trx id : ' || pr_new.customer_trx_id , */
2174: sysdate,
2175: fnd_global.user_id ,
2176: -- added, Harshita for Bug 4866533
2177: fnd_global.user_id,
2178: sysdate
2179: );
2180: end if;
2181:
2221: 0 ,
2222: lr_trx_rec.trx_number ,
2223: lr_trx_rec.batch_source_id ,
2224: sysdate ,
2225: fnd_global.user_id ,
2226: sysdate ,
2227: fnd_global.user_id ,
2228: fnd_global.login_id ,
2229: lr_trx_rec.set_of_books_id ,
2223: lr_trx_rec.batch_source_id ,
2224: sysdate ,
2225: fnd_global.user_id ,
2226: sysdate ,
2227: fnd_global.user_id ,
2228: fnd_global.login_id ,
2229: lr_trx_rec.set_of_books_id ,
2230: lr_trx_rec.primary_salesrep_id ,
2231: lr_trx_rec.invoice_currency_code ,
2224: sysdate ,
2225: fnd_global.user_id ,
2226: sysdate ,
2227: fnd_global.user_id ,
2228: fnd_global.login_id ,
2229: lr_trx_rec.set_of_books_id ,
2230: lr_trx_rec.primary_salesrep_id ,
2231: lr_trx_rec.invoice_currency_code ,
2232: lr_trx_rec.exchange_rate_type ,
2333: round(tax_rec.tax_amount,2) ,
2334: round(tax_rec.func_tax_amount,2) ,
2335: round(tax_rec.base_tax_amount,2) ,
2336: sysdate ,
2337: fnd_global.user_id ,
2338: sysdate ,
2339: fnd_global.user_id ,
2340: fnd_global.login_id
2341: );
2335: round(tax_rec.base_tax_amount,2) ,
2336: sysdate ,
2337: fnd_global.user_id ,
2338: sysdate ,
2339: fnd_global.user_id ,
2340: fnd_global.login_id
2341: );
2342: end if; /* end if for tax type not in excise .... */
2343: else /* register association is not bond register , so all taxes can flow */
2336: sysdate ,
2337: fnd_global.user_id ,
2338: sysdate ,
2339: fnd_global.user_id ,
2340: fnd_global.login_id
2341: );
2342: end if; /* end if for tax type not in excise .... */
2343: else /* register association is not bond register , so all taxes can flow */
2344: /* Date 23/02/2006 by sacsethi for bug 5228046
2393: round(tax_rec.tax_amount,2) ,
2394: round(tax_rec.func_tax_amount,2) ,
2395: round(tax_rec.base_tax_amount,2) ,
2396: sysdate ,
2397: fnd_global.user_id ,
2398: sysdate ,
2399: fnd_global.user_id ,
2400: fnd_global.login_id
2401: );
2395: round(tax_rec.base_tax_amount,2) ,
2396: sysdate ,
2397: fnd_global.user_id ,
2398: sysdate ,
2399: fnd_global.user_id ,
2400: fnd_global.login_id
2401: );
2402:
2403: end if;
2396: sysdate ,
2397: fnd_global.user_id ,
2398: sysdate ,
2399: fnd_global.user_id ,
2400: fnd_global.login_id
2401: );
2402:
2403: end if;
2404: end loop;
2573: round(nvl(rec_so_lines.line_amount,0) +
2574: nvl(ln_ar_tax_amount,0),2) ,
2575: rec_so_lines.assessable_value ,
2576: sysdate ,
2577: fnd_global.user_id ,
2578: sysdate ,
2579: fnd_global.user_id ,
2580: fnd_global.login_id ,
2581: rec_so_lines.excise_exempt_type ,
2575: rec_so_lines.assessable_value ,
2576: sysdate ,
2577: fnd_global.user_id ,
2578: sysdate ,
2579: fnd_global.user_id ,
2580: fnd_global.login_id ,
2581: rec_so_lines.excise_exempt_type ,
2582: rec_so_lines.excise_exempt_refno ,
2583: rec_so_lines.excise_exempt_date ,
2576: sysdate ,
2577: fnd_global.user_id ,
2578: sysdate ,
2579: fnd_global.user_id ,
2580: fnd_global.login_id ,
2581: rec_so_lines.excise_exempt_type ,
2582: rec_so_lines.excise_exempt_refno ,
2583: rec_so_lines.excise_exempt_date ,
2584: NULL ,
4474: substr(vsqlerrm,1,200) ,
4475: sysdate ,
4476: user ,
4477: -- added, Harshita for Bug 4866533
4478: fnd_global.user_id,
4479: sysdate
4480: );
4481:
4482: END ARI_T2 ;
4899: lv_appl_src, /*'JA_IN_OE_AR_LINES_INSERT_TRG', Ramananda for removal of SQL LITERALs */
4900: lv_err_msg, /* 'Default Location is not setup for Inventory Organization ' || pr_new.warehouse_id , */
4901: lv_addl_msg, /* 'Please setup the Default Location in Organization Additional Information Screen for Trx id : ' || pr_new.customer_trx_id , */
4902: sysdate,
4903: fnd_global.user_id ,
4904: -- added, Harshita for Bug 4866533
4905: fnd_global.user_id,
4906: sysdate
4907: );
4901: lv_addl_msg, /* 'Please setup the Default Location in Organization Additional Information Screen for Trx id : ' || pr_new.customer_trx_id , */
4902: sysdate,
4903: fnd_global.user_id ,
4904: -- added, Harshita for Bug 4866533
4905: fnd_global.user_id,
4906: sysdate
4907: );
4908: end if;
4909: insert into JAI_AR_TRXS -- bill only invoice
4946: 0 ,
4947: lr_trx_rec.trx_number ,
4948: lr_trx_rec.batch_source_id ,
4949: sysdate ,
4950: fnd_global.user_id ,
4951: sysdate ,
4952: fnd_global.user_id ,
4953: fnd_global.login_id ,
4954: lr_trx_rec.set_of_books_id ,
4948: lr_trx_rec.batch_source_id ,
4949: sysdate ,
4950: fnd_global.user_id ,
4951: sysdate ,
4952: fnd_global.user_id ,
4953: fnd_global.login_id ,
4954: lr_trx_rec.set_of_books_id ,
4955: lr_trx_rec.primary_salesrep_id ,
4956: lr_trx_rec.invoice_currency_code ,
4949: sysdate ,
4950: fnd_global.user_id ,
4951: sysdate ,
4952: fnd_global.user_id ,
4953: fnd_global.login_id ,
4954: lr_trx_rec.set_of_books_id ,
4955: lr_trx_rec.primary_salesrep_id ,
4956: lr_trx_rec.invoice_currency_code ,
4957: lr_trx_rec.exchange_rate_type ,
5057: -round(tax_rec.tax_amount,2) ,
5058: -round(tax_rec.func_tax_amount,2) ,
5059: -round(tax_rec.base_tax_amount,2) ,
5060: sysdate ,
5061: fnd_global.user_id ,
5062: sysdate ,
5063: fnd_global.user_id ,
5064: fnd_global.login_id
5065: );
5059: -round(tax_rec.base_tax_amount,2) ,
5060: sysdate ,
5061: fnd_global.user_id ,
5062: sysdate ,
5063: fnd_global.user_id ,
5064: fnd_global.login_id
5065: );
5066: end if; /* end if for tax type not in excise .... */
5067: else /* register association is not bond register , so all taxes can flow */
5060: sysdate ,
5061: fnd_global.user_id ,
5062: sysdate ,
5063: fnd_global.user_id ,
5064: fnd_global.login_id
5065: );
5066: end if; /* end if for tax type not in excise .... */
5067: else /* register association is not bond register , so all taxes can flow */
5068: /* Date 23/02/2006 by sacsethi for bug 5228046
5117: -round(tax_rec.tax_amount,2) ,
5118: -round(tax_rec.func_tax_amount,2) ,
5119: -round(tax_rec.base_tax_amount,2) ,
5120: sysdate ,
5121: fnd_global.user_id ,
5122: sysdate ,
5123: fnd_global.user_id ,
5124: fnd_global.login_id
5125: );
5119: -round(tax_rec.base_tax_amount,2) ,
5120: sysdate ,
5121: fnd_global.user_id ,
5122: sysdate ,
5123: fnd_global.user_id ,
5124: fnd_global.login_id
5125: );
5126:
5127: end if;
5120: sysdate ,
5121: fnd_global.user_id ,
5122: sysdate ,
5123: fnd_global.user_id ,
5124: fnd_global.login_id
5125: );
5126:
5127: end if;
5128: end loop;
5282: nvl(ln_ar_tax_amount,0),
5283: NVL(pr_new.quantity_credited * pr_new.unit_selling_price, nvl(pr_new.extended_amount,0)) + nvl(ln_ar_tax_amount,0) ,
5284: rec_so_lines.assessable_value ,
5285: sysdate ,
5286: fnd_global.user_id ,
5287: sysdate ,
5288: fnd_global.user_id ,
5289: fnd_global.login_id ,
5290: rec_so_lines.service_type_code
5284: rec_so_lines.assessable_value ,
5285: sysdate ,
5286: fnd_global.user_id ,
5287: sysdate ,
5288: fnd_global.user_id ,
5289: fnd_global.login_id ,
5290: rec_so_lines.service_type_code
5291: );
5292:
5285: sysdate ,
5286: fnd_global.user_id ,
5287: sysdate ,
5288: fnd_global.user_id ,
5289: fnd_global.login_id ,
5290: rec_so_lines.service_type_code
5291: );
5292:
5293: open c_get_amounts;
6977: lv_add_err, /* 'CUSTOMER_TRX_ID = ' || TO_CHAR(pr_new.CUSTOMER_TRX_ID) || ' CUSTOMER_TRX_LINE_ID = ' || TO_CHAR(pr_new.CUSTOMER_TRX_LINE_ID) , */
6978: sysdate,
6979: user ,
6980: -- added, Harshita for Bug 4866533
6981: fnd_global.user_id,
6982: sysdate
6983: );
6984:
6985: END ARIU_T1 ;