[Home] [Help]
445:
446: -- added by sriram -- bug # 2769440
447:
448: /* Ramananda for File.Sql.35 */
449: v_ref_10 gl_interface.reference10%type; -- := 'India Localization Entry for sales order # '; -- will hold a standard text such as 'India Localization Entry for sales order'
450: v_std_text varchar2(50); -- := 'India Localization Entry for sales order # '; -- bug # 3158976
451: v_ref_23 gl_interface.reference23%type; -- := 'process_delivery'; -- holds the object name -- 'process_delivery'
452: v_ref_24 gl_interface.reference24%type; -- := 'wsh_new_deliveries'; -- holds the table name -- ' wsh_new_deliveries'
453: v_ref_25 gl_interface.reference25%type; -- := 'delivery_id'; -- holds the column name -- 'delivery_id'
790:
791:
792: 32. 11/10/2003 ssumaith - Bug # 3158976 File Version 616.6
793:
794: Sales order number is appended to the variable v_ref_10 which holds a standard text
795: in a loop of delivery details for a particular delivery.
796: If the number of delivery details are huge , the appending is causing the width of the concatenated text
797: to exceed beyond 250 characters.
798: It causes PL/SQL Numeric or value error.
1184: lv_procedure_name := 'process_delivery';
1185: v_creation_date := SYSDATE;
1186: v_source_name := 'Register India' ;
1187: v_category_name := 'Register India' ;
1188: v_ref_10 := 'India Localization Entry for sales order # '; -- will hold a standard text such as 'India Localization Entry for sales order'
1189: v_std_text := 'India Localization Entry for sales order # '; -- bug # 3158976
1190: v_ref_23 := 'process_delivery'; -- holds the object name -- 'process_delivery'
1191: v_ref_24 := 'wsh_new_deliveries'; -- holds the table name -- ' wsh_new_deliveries'
1192: v_ref_25 := 'delivery_id'; -- holds the column name -- 'delivery_id';
1230: FETCH c_conc_request_submit_date INTO ld_request_submit_Date;
1231: CLOSE c_conc_request_submit_date;
1232: /* Ends here Bug 4562791. Added by Lakshmi Gopalsami */
1233:
1234: v_ref_10 := v_std_text || v_ord_num; -- instead of appending v_ref_10 every time , appending the so# to the standard text instead.-- bug # 3158976
1235: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', '||'2 Each_record.Delivery detail id = ' || Each_record.delivery_detail_id );
1236: v_tax_rate := 0; --2001/08/07 Jagdish
1237: lv_statement_no := '1';
1238: