43: INTO lp_company_name
44: FROM fa_system_controls;
45: EXCEPTION
46: WHEN OTHERS THEN
47: fnd_file.put_line(fnd_file.log,'Error in Fetching company name. Error => '||SQLERRM);
48: END;
49:
50: BEGIN
51: SELECT gl.currency_code
54: WHERE book_type_code = p_book_name
55: AND fbc.set_of_books_id = gl.ledger_id;
56: EXCEPTION
57: WHEN OTHERS THEN
58: fnd_file.put_line(fnd_file.log,'Error in Fetching currency code. Error => '||SQLERRM);
59: END;
60:
61:
62: RETURN (TRUE);
116: UPPER ('Global Data Elements')
117: AND UPPER (fdfcu.end_user_column_name) = 'FREE_OF_CHARGE';
118: EXCEPTION
119: WHEN OTHERS THEN
120: fnd_file.put_line(fnd_file.log,'Error in Fetching DFF Column for Free of charge. Error => '||SQLERRM);
121: END;
122:
123: IF(v_free_charge IS NOT NULL ) THEN
124: lp_free_of_charge :='flb.'||v_free_charge ;
140: INTO lp_com_name
141: FROM fa_system_controls;
142: EXCEPTION
143: WHEN OTHERS THEN
144: fnd_file.put_line(fnd_file.log,'Error in Fetching company name. Error => '||SQLERRM);
145: END;
146:
147: RETURN lp_com_name;
148: END;
159: WHERE book_type_code = p_book_name
160: AND fbc.set_of_books_id = gl.ledger_id;
161: EXCEPTION
162: WHEN OTHERS THEN
163: fnd_file.put_line(fnd_file.log,'Error in Fetching currency code. Error => '||SQLERRM);
164: END;
165:
166: RETURN lp_curr_code;
167: END;
177: WHERE fadp.book_type_code = p_book_name
178: AND fadp.period_name = p_from_period;
179: EXCEPTION
180: WHEN OTHERS THEN
181: fnd_file.put_line(fnd_file.log,'Error in Fetching From Date. Error => '||SQLERRM);
182: END;
183:
184: RETURN lp_from_date;
185: END;
195: WHERE fadp.book_type_code = p_book_name
196: AND fadp.period_name = p_to_period;
197: EXCEPTION
198: WHEN OTHERS THEN
199: fnd_file.put_line(fnd_file.log,'Error in Fetching To Date. Error => '||SQLERRM);
200: END;
201:
202: RETURN lp_to_date;
203: END;