[Home] [Help]
432:
433: -- added by sriram -- bug # 2769440
434:
435: /* Ramananda for File.Sql.35 */
436: 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'
437: v_std_text varchar2(50); -- := 'India Localization Entry for sales order # '; -- bug # 3158976
438: v_ref_23 gl_interface.reference23%type; -- := 'process_delivery'; -- holds the object name -- 'process_delivery'
439: v_ref_24 gl_interface.reference24%type; -- := 'wsh_new_deliveries'; -- holds the table name -- ' wsh_new_deliveries'
440: v_ref_25 gl_interface.reference25%type; -- := 'delivery_id'; -- holds the column name -- 'delivery_id'
762:
763:
764: 32. 11/10/2003 ssumaith - Bug # 3158976 File Version 616.6
765:
766: Sales order number is appended to the variable v_ref_10 which holds a standard text
767: in a loop of delivery details for a particular delivery.
768: If the number of delivery details are huge , the appending is causing the width of the concatenated text
769: to exceed beyond 250 characters.
770: It causes PL/SQL Numeric or value error.
1104: lv_procedure_name := 'process_delivery';
1105: v_creation_date := SYSDATE;
1106: v_source_name := 'Register India' ;
1107: v_category_name := 'Register India' ;
1108: v_ref_10 := 'India Localization Entry for sales order # '; -- will hold a standard text such as 'India Localization Entry for sales order'
1109: v_std_text := 'India Localization Entry for sales order # '; -- bug # 3158976
1110: v_ref_23 := 'process_delivery'; -- holds the object name -- 'process_delivery'
1111: v_ref_24 := 'wsh_new_deliveries'; -- holds the table name -- ' wsh_new_deliveries'
1112: v_ref_25 := 'delivery_id'; -- holds the column name -- 'delivery_id';
1150: FETCH c_conc_request_submit_date INTO ld_request_submit_Date;
1151: CLOSE c_conc_request_submit_date;
1152: /* Ends here Bug 4562791. Added by Lakshmi Gopalsami */
1153:
1154: 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
1155: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', '||'2 Each_record.Delivery detail id = ' || Each_record.delivery_detail_id );
1156: v_tax_rate := 0; --2001/08/07 Jagdish
1157: lv_statement_no := '1';
1158: