eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_PLSQL_CACHE_PKG dependencies on FND_FILE

Line 29: fnd_file.put_line(FND_FILE.LOG, ' Error reading cache' || SQLERRM);

25:
26: EXCEPTION
27: WHEN OTHERS THEN
28: --NULL ;
29: fnd_file.put_line(FND_FILE.LOG, ' Error reading cache' || SQLERRM);
30:
31: END read_cache;
32:
33:

Line 54: fnd_file.put_line(FND_FILE.LOG, ' Error writing cache'|| SQLERRM);

50:
51: EXCEPTION
52: WHEN OTHERS THEN
53: -- null;
54: fnd_file.put_line(FND_FILE.LOG, ' Error writing cache'|| SQLERRM);
55: END write_cache;
56:
57:
58: /* Read from db and write into cache */

Line 87: --fnd_file.put_line(FND_FILE.LOG, '1. ledger id '

83: -- jai_cmn_utils_pkg.print_log('JAI_PLSQL_CACHE_PKG.log',
84: -- ' Inv org ledger id ' || lc_fetch_org_det.ledger_id);
85: End if;
86:
87: --fnd_file.put_line(FND_FILE.LOG, '1. ledger id '
88: --|| lc_fetch_org_det.ledger_id);
89:
90: IF lc_fetch_org_det.ledger_id IS NULL THEN
91: OPEN get_OU (p_org_id);

Line 99: --fnd_file.put_line(FND_FILE.LOG, ' 3. ledger id '

95: If v_debug ='Y' Then
96: jai_cmn_utils_pkg.print_log('JAI_PLSQL_CACHE_PKG.log',
97: 'OU ledger id ' || lc_fetch_org_det.ledger_id);
98: End if;
99: --fnd_file.put_line(FND_FILE.LOG, ' 3. ledger id '
100: --|| lc_fetch_org_det.ledger_id);
101: END if;
102:
103: IF lc_fetch_org_det.ledger_id IS NOT NULL THEN

Line 107: --fnd_file.put_line(FND_FILE.LOG, ' 2. curr code '

103: IF lc_fetch_org_det.ledger_id IS NOT NULL THEN
104: OPEN get_func_curr(lc_fetch_org_det.ledger_id);
105: FETCH get_func_curr INTO lc_fetch_curr_det;
106: CLOSE get_func_curr;
107: --fnd_file.put_line(FND_FILE.LOG, ' 2. curr code '
108: -- || lc_fetch_curr_det.curr_code);
109: /* Bug 5243532. Added by Lakshmi Gopalsami
110: Get the precision and minimum accountable unit
111: */

Line 139: fnd_file.put_line(FND_FILE.LOG, ' Error reading database'|| SQLERRM);

135:
136: EXCEPTION
137: WHEN OTHERS THEN
138: -- null;
139: fnd_file.put_line(FND_FILE.LOG, ' Error reading database'|| SQLERRM);
140: END read_from_db;
141:
142:
143: /* Function which performs reading from cache, if not found

Line 161: fnd_file.put_line(FND_FILE.LOG, ' value of org id '

157:
158: -- Read from cache and display .
159:
160: /*
161: fnd_file.put_line(FND_FILE.LOG, ' value of org id '
162: || p_org_id);
163: fnd_file.put_line(FND_FILE.LOG, ' Cache values - ledger id '
164: || l_func_curr_det.ledger_id);
165: fnd_file.put_line(FND_FILE.LOG, ' Currency Code '

Line 163: fnd_file.put_line(FND_FILE.LOG, ' Cache values - ledger id '

159:
160: /*
161: fnd_file.put_line(FND_FILE.LOG, ' value of org id '
162: || p_org_id);
163: fnd_file.put_line(FND_FILE.LOG, ' Cache values - ledger id '
164: || l_func_curr_det.ledger_id);
165: fnd_file.put_line(FND_FILE.LOG, ' Currency Code '
166: || l_func_curr_det.currency_code);
167: fnd_file.put_line(FND_FILE.LOG, ' Chart of Accounts id '

Line 165: fnd_file.put_line(FND_FILE.LOG, ' Currency Code '

161: fnd_file.put_line(FND_FILE.LOG, ' value of org id '
162: || p_org_id);
163: fnd_file.put_line(FND_FILE.LOG, ' Cache values - ledger id '
164: || l_func_curr_det.ledger_id);
165: fnd_file.put_line(FND_FILE.LOG, ' Currency Code '
166: || l_func_curr_det.currency_code);
167: fnd_file.put_line(FND_FILE.LOG, ' Chart of Accounts id '
168: || l_func_curr_det.chart_of_accounts_id);
169: fnd_file.put_line(FND_FILE.LOG, ' Organization code '

Line 167: fnd_file.put_line(FND_FILE.LOG, ' Chart of Accounts id '

163: fnd_file.put_line(FND_FILE.LOG, ' Cache values - ledger id '
164: || l_func_curr_det.ledger_id);
165: fnd_file.put_line(FND_FILE.LOG, ' Currency Code '
166: || l_func_curr_det.currency_code);
167: fnd_file.put_line(FND_FILE.LOG, ' Chart of Accounts id '
168: || l_func_curr_det.chart_of_accounts_id);
169: fnd_file.put_line(FND_FILE.LOG, ' Organization code '
170: || l_func_curr_det.organization_code);
171: fnd_file.put_line(FND_FILE.LOG, ' Organization Name '

Line 169: fnd_file.put_line(FND_FILE.LOG, ' Organization code '

165: fnd_file.put_line(FND_FILE.LOG, ' Currency Code '
166: || l_func_curr_det.currency_code);
167: fnd_file.put_line(FND_FILE.LOG, ' Chart of Accounts id '
168: || l_func_curr_det.chart_of_accounts_id);
169: fnd_file.put_line(FND_FILE.LOG, ' Organization code '
170: || l_func_curr_det.organization_code);
171: fnd_file.put_line(FND_FILE.LOG, ' Organization Name '
172: || l_func_curr_det.organization_name);
173: fnd_file.put_line(FND_FILE.LOG, ' Legal Entity'

Line 171: fnd_file.put_line(FND_FILE.LOG, ' Organization Name '

167: fnd_file.put_line(FND_FILE.LOG, ' Chart of Accounts id '
168: || l_func_curr_det.chart_of_accounts_id);
169: fnd_file.put_line(FND_FILE.LOG, ' Organization code '
170: || l_func_curr_det.organization_code);
171: fnd_file.put_line(FND_FILE.LOG, ' Organization Name '
172: || l_func_curr_det.organization_name);
173: fnd_file.put_line(FND_FILE.LOG, ' Legal Entity'
174: || l_func_curr_det.legal_entity);
175: */

Line 173: fnd_file.put_line(FND_FILE.LOG, ' Legal Entity'

169: fnd_file.put_line(FND_FILE.LOG, ' Organization code '
170: || l_func_curr_det.organization_code);
171: fnd_file.put_line(FND_FILE.LOG, ' Organization Name '
172: || l_func_curr_det.organization_name);
173: fnd_file.put_line(FND_FILE.LOG, ' Legal Entity'
174: || l_func_curr_det.legal_entity);
175: */
176: /* Print into util file if v_debug ='Y' */
177:

Line 191: fnd_file.put_line(FND_FILE.LOG, ' Inside cache value null - org id '

187: -- Read from db as the details are not available in cache.
188:
189: l_func_curr_det := read_from_db(p_org_id);
190: /*
191: fnd_file.put_line(FND_FILE.LOG, ' Inside cache value null - org id '
192: || p_org_id);
193: fnd_file.put_line(FND_FILE.LOG, ' Cache values - ledger id '
194: || l_func_curr_det.ledger_id);
195: fnd_file.put_line(FND_FILE.LOG, ' Currency Code '

Line 193: fnd_file.put_line(FND_FILE.LOG, ' Cache values - ledger id '

189: l_func_curr_det := read_from_db(p_org_id);
190: /*
191: fnd_file.put_line(FND_FILE.LOG, ' Inside cache value null - org id '
192: || p_org_id);
193: fnd_file.put_line(FND_FILE.LOG, ' Cache values - ledger id '
194: || l_func_curr_det.ledger_id);
195: fnd_file.put_line(FND_FILE.LOG, ' Currency Code '
196: || l_func_curr_det.currency_code);
197: fnd_file.put_line(FND_FILE.LOG, ' Chart of Accounts id '

Line 195: fnd_file.put_line(FND_FILE.LOG, ' Currency Code '

191: fnd_file.put_line(FND_FILE.LOG, ' Inside cache value null - org id '
192: || p_org_id);
193: fnd_file.put_line(FND_FILE.LOG, ' Cache values - ledger id '
194: || l_func_curr_det.ledger_id);
195: fnd_file.put_line(FND_FILE.LOG, ' Currency Code '
196: || l_func_curr_det.currency_code);
197: fnd_file.put_line(FND_FILE.LOG, ' Chart of Accounts id '
198: || l_func_curr_det.chart_of_accounts_id);
199: fnd_file.put_line(FND_FILE.LOG, ' Organization code '

Line 197: fnd_file.put_line(FND_FILE.LOG, ' Chart of Accounts id '

193: fnd_file.put_line(FND_FILE.LOG, ' Cache values - ledger id '
194: || l_func_curr_det.ledger_id);
195: fnd_file.put_line(FND_FILE.LOG, ' Currency Code '
196: || l_func_curr_det.currency_code);
197: fnd_file.put_line(FND_FILE.LOG, ' Chart of Accounts id '
198: || l_func_curr_det.chart_of_accounts_id);
199: fnd_file.put_line(FND_FILE.LOG, ' Organization code '
200: || l_func_curr_det.organization_code);
201: fnd_file.put_line(FND_FILE.LOG, ' Organization Name '

Line 199: fnd_file.put_line(FND_FILE.LOG, ' Organization code '

195: fnd_file.put_line(FND_FILE.LOG, ' Currency Code '
196: || l_func_curr_det.currency_code);
197: fnd_file.put_line(FND_FILE.LOG, ' Chart of Accounts id '
198: || l_func_curr_det.chart_of_accounts_id);
199: fnd_file.put_line(FND_FILE.LOG, ' Organization code '
200: || l_func_curr_det.organization_code);
201: fnd_file.put_line(FND_FILE.LOG, ' Organization Name '
202: || l_func_curr_det.organization_name);
203: fnd_file.put_line(FND_FILE.LOG, ' Legal Entity'

Line 201: fnd_file.put_line(FND_FILE.LOG, ' Organization Name '

197: fnd_file.put_line(FND_FILE.LOG, ' Chart of Accounts id '
198: || l_func_curr_det.chart_of_accounts_id);
199: fnd_file.put_line(FND_FILE.LOG, ' Organization code '
200: || l_func_curr_det.organization_code);
201: fnd_file.put_line(FND_FILE.LOG, ' Organization Name '
202: || l_func_curr_det.organization_name);
203: fnd_file.put_line(FND_FILE.LOG, ' Legal Entity'
204: || l_func_curr_det.legal_entity);
205: */

Line 203: fnd_file.put_line(FND_FILE.LOG, ' Legal Entity'

199: fnd_file.put_line(FND_FILE.LOG, ' Organization code '
200: || l_func_curr_det.organization_code);
201: fnd_file.put_line(FND_FILE.LOG, ' Organization Name '
202: || l_func_curr_det.organization_name);
203: fnd_file.put_line(FND_FILE.LOG, ' Legal Entity'
204: || l_func_curr_det.legal_entity);
205: */
206: /* Print into util file if v_debug ='Y' */
207:

Line 215: fnd_file.put_line(FND_FILE.LOG, ' Cache values - ledger id '

211: End if;
212:
213: if l_func_curr_det.ledger_id is not null then
214: /*
215: fnd_file.put_line(FND_FILE.LOG, ' Cache values - ledger id '
216: || l_func_curr_det.ledger_id);
217: fnd_file.put_line(FND_FILE.LOG, ' Currency Code '
218: || l_func_curr_det.currency_code);
219: fnd_file.put_line(FND_FILE.LOG, ' Chart of Accounts id '

Line 217: fnd_file.put_line(FND_FILE.LOG, ' Currency Code '

213: if l_func_curr_det.ledger_id is not null then
214: /*
215: fnd_file.put_line(FND_FILE.LOG, ' Cache values - ledger id '
216: || l_func_curr_det.ledger_id);
217: fnd_file.put_line(FND_FILE.LOG, ' Currency Code '
218: || l_func_curr_det.currency_code);
219: fnd_file.put_line(FND_FILE.LOG, ' Chart of Accounts id '
220: || l_func_curr_det.chart_of_accounts_id);
221: fnd_file.put_line(FND_FILE.LOG, ' Organization code '

Line 219: fnd_file.put_line(FND_FILE.LOG, ' Chart of Accounts id '

215: fnd_file.put_line(FND_FILE.LOG, ' Cache values - ledger id '
216: || l_func_curr_det.ledger_id);
217: fnd_file.put_line(FND_FILE.LOG, ' Currency Code '
218: || l_func_curr_det.currency_code);
219: fnd_file.put_line(FND_FILE.LOG, ' Chart of Accounts id '
220: || l_func_curr_det.chart_of_accounts_id);
221: fnd_file.put_line(FND_FILE.LOG, ' Organization code '
222: || l_func_curr_det.organization_code);
223: fnd_file.put_line(FND_FILE.LOG, ' Organization Name '

Line 221: fnd_file.put_line(FND_FILE.LOG, ' Organization code '

217: fnd_file.put_line(FND_FILE.LOG, ' Currency Code '
218: || l_func_curr_det.currency_code);
219: fnd_file.put_line(FND_FILE.LOG, ' Chart of Accounts id '
220: || l_func_curr_det.chart_of_accounts_id);
221: fnd_file.put_line(FND_FILE.LOG, ' Organization code '
222: || l_func_curr_det.organization_code);
223: fnd_file.put_line(FND_FILE.LOG, ' Organization Name '
224: || l_func_curr_det.organization_name);
225: fnd_file.put_line(FND_FILE.LOG, ' Legal Entity'

Line 223: fnd_file.put_line(FND_FILE.LOG, ' Organization Name '

219: fnd_file.put_line(FND_FILE.LOG, ' Chart of Accounts id '
220: || l_func_curr_det.chart_of_accounts_id);
221: fnd_file.put_line(FND_FILE.LOG, ' Organization code '
222: || l_func_curr_det.organization_code);
223: fnd_file.put_line(FND_FILE.LOG, ' Organization Name '
224: || l_func_curr_det.organization_name);
225: fnd_file.put_line(FND_FILE.LOG, ' Legal Entity'
226: || l_func_curr_det.legal_entity);
227: */

Line 225: fnd_file.put_line(FND_FILE.LOG, ' Legal Entity'

221: fnd_file.put_line(FND_FILE.LOG, ' Organization code '
222: || l_func_curr_det.organization_code);
223: fnd_file.put_line(FND_FILE.LOG, ' Organization Name '
224: || l_func_curr_det.organization_name);
225: fnd_file.put_line(FND_FILE.LOG, ' Legal Entity'
226: || l_func_curr_det.legal_entity);
227: */
228: /* Print into util file if v_debug ='Y' */
229: