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.IBE_DELIVERABLE_EXPIMP_PVT dependencies on FND_FILE

Line 154: FND_FILE.PUT_LINE(FND_FILE.LOG, '*****Template import Starts-'||to_char(sysdate,'MM/DD/RRRR HH24:MI:SS'));

150: FND_PROFILE.Put('AFLOG_LEVEL',FND_LOG.LEVEL_EVENT);
151: FND_LOG_REPOSITORY.Init;
152:
153: IF (p_enable_debug = 'Y') THEN
154: FND_FILE.PUT_LINE(FND_FILE.LOG, '*****Template import Starts-'||to_char(sysdate,'MM/DD/RRRR HH24:MI:SS'));
155: END IF;
156:
157: -- Standard Start of API savepoint
158: SAVEPOINT save_template_mapping_pvt;

Line 175: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Opening cursor c_get_template_csr');

171: x_return_status := FND_API.G_RET_STS_SUCCESS;
172: -- API body
173: -- Check if the template exists or not
174: IF (p_enable_debug = 'Y') THEN
175: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Opening cursor c_get_template_csr');
176: END IF;
177: OPEN c_get_template_csr(p_access_name);
178: FETCH c_get_template_csr INTO l_item_id ,l_object_ver_num;
179: IF (c_get_template_csr%NOTFOUND) THEN

Line 181: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_item_id is null');

177: OPEN c_get_template_csr(p_access_name);
178: FETCH c_get_template_csr INTO l_item_id ,l_object_ver_num;
179: IF (c_get_template_csr%NOTFOUND) THEN
180: IF (p_enable_debug = 'Y') THEN
181: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_item_id is null');
182: END IF;
183: l_item_id := NULL;
184: END IF;
185: CLOSE c_get_template_csr;

Line 196: FND_FILE.PUT_LINE(FND_FILE.LOG,

192: l_deliverable_rec.deliverable_id := l_item_id;
193: l_deliverable_rec.object_version_number:=l_object_ver_num;
194:
195: IF (p_enable_debug = 'Y') THEN
196: FND_FILE.PUT_LINE(FND_FILE.LOG,
197: 'Step 1 : item_id='||l_item_id||
198: ':access_name='||p_access_name||
199: ':display_name='||p_item_name||
200: ':description='||p_description||

Line 212: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Before calling IBE_Deliverable_Grp.save_deliverable');

208:
209: IF (l_item_id IS NULL) OR (l_item_id >=10000) THEN
210:
211: IF (p_enable_debug = 'Y') THEN
212: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Before calling IBE_Deliverable_Grp.save_deliverable');
213: END IF;
214:
215: IBE_Deliverable_GRP.save_deliverable(
216: p_api_version => 1.0,

Line 225: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 2 :After item save :return status='||l_return_status);

221: x_msg_data => l_msg_data,
222: p_deliverable_rec => l_deliverable_rec);
223:
224: IF (p_enable_debug = 'Y') THEN
225: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 2 :After item save :return status='||l_return_status);
226: END IF;
227: l_item_id := l_deliverable_rec.deliverable_id;
228: IF (p_enable_debug = 'Y') THEN
229: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 2a :l_item_id='||l_item_id);

Line 229: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 2a :l_item_id='||l_item_id);

225: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 2 :After item save :return status='||l_return_status);
226: END IF;
227: l_item_id := l_deliverable_rec.deliverable_id;
228: IF (p_enable_debug = 'Y') THEN
229: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 2a :l_item_id='||l_item_id);
230: END IF;
231:
232: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
233: RAISE FND_API.G_EXC_ERROR;

Line 242: FND_FILE.PUT_LINE(FND_FILE.LOG, 'step2b : number of array count ='||p_minisite_ids.COUNT);

238:
239: END IF;
240:
241: IF (p_enable_debug = 'Y') THEN
242: FND_FILE.PUT_LINE(FND_FILE.LOG, 'step2b : number of array count ='||p_minisite_ids.COUNT);
243: END IF;
244: -- Process the template mappings
245: FOR l_i IN 1..p_minisite_ids.COUNT LOOP
246: -- Check if the mapping exists or not

Line 248: FND_FILE.PUT_LINE(FND_FILE.LOG,

244: -- Process the template mappings
245: FOR l_i IN 1..p_minisite_ids.COUNT LOOP
246: -- Check if the mapping exists or not
247: IF (p_enable_debug = 'Y') THEN
248: FND_FILE.PUT_LINE(FND_FILE.LOG,
249: 'Step 3 : itemid='||l_item_id||
250: ':access_name='||p_access_name||
251: 'msite_id='||p_minisite_ids(l_i)||
252: 'langcode='||p_language_codes(l_i)||

Line 265: FND_FILE.PUT_LINE(FND_FILE.LOG,

261:
262: FETCH c_get_map_csr INTO l_lgl_phys_map_id, l_attachment_id;
263:
264: IF (p_enable_debug = 'Y') THEN
265: FND_FILE.PUT_LINE(FND_FILE.LOG,
266: 'Step4 : lgl_phys_map_id='||l_lgl_phys_map_id||
267: ':l_attachment_id='||l_attachment_id);
268: END IF;
269:

Line 296: FND_FILE.PUT_LINE(FND_FILE.LOG,

292: through the variable of type IBE_ATTACHMENT_GRP.ATTACHMENT_REC_TYPE.
293: */
294:
295: IF (p_enable_debug = 'Y') THEN
296: FND_FILE.PUT_LINE(FND_FILE.LOG,
297: 'Item id is '||l_item_id);
298: FND_FILE.PUT_LINE(FND_FILE.LOG,
299: 'File name is '|| p_file_names(l_i) );
300: END IF;

Line 298: FND_FILE.PUT_LINE(FND_FILE.LOG,

294:
295: IF (p_enable_debug = 'Y') THEN
296: FND_FILE.PUT_LINE(FND_FILE.LOG,
297: 'Item id is '||l_item_id);
298: FND_FILE.PUT_LINE(FND_FILE.LOG,
299: 'File name is '|| p_file_names(l_i) );
300: END IF;
301:
302: OPEN c_get_attachment_id_csr(l_attachment_rec.deliverable_id,l_attachment_rec.file_name);

Line 307: FND_FILE.PUT_LINE(FND_FILE.LOG,'The Attachment id is '|| l_attachment_id);

303: FETCH c_get_attachment_id_csr INTO l_attachment_id;
304: CLOSE c_get_attachment_id_csr;
305:
306: IF (p_enable_debug = 'Y') THEN
307: FND_FILE.PUT_LINE(FND_FILE.LOG,'The Attachment id is '|| l_attachment_id);
308: END IF;
309:
310: -- retrieve the existing attachment details if attachment id not null
311: IF (l_attachment_id IS NOT NULL AND l_attachment_id >0) then

Line 333: FND_FILE.PUT_LINE(FND_FILE.LOG,

329: l_attachment_rec.description;
330:
331:
332: IF (p_enable_debug = 'Y') THEN
333: FND_FILE.PUT_LINE(FND_FILE.LOG,
334: 'Step4a :object version number ='||l_attachment_rec.object_version_number);
335: END IF;
336: CLOSE c_get_attachment_csr;
337: END IF;

Line 340: FND_FILE.PUT_LINE(FND_FILE.LOG,

336: CLOSE c_get_attachment_csr;
337: END IF;
338:
339: IF (p_enable_debug = 'Y') THEN
340: FND_FILE.PUT_LINE(FND_FILE.LOG,
341: 'Step 5 :Attachment id='||l_attachment_id||
342: ':file_names='||l_attachment_rec.file_name);
343: END IF;
344:

Line 357: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 6 :after save atachment return status='||l_return_status);

353: p_attachment_rec => l_attachment_rec);
354:
355:
356: IF (p_enable_debug = 'Y') THEN
357: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 6 :after save atachment return status='||l_return_status);
358: END IF;
359:
360: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
361: RAISE FND_API.G_EXC_ERROR;

Line 369: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 6a :The attachment id now is='||l_attachment_id);

365: END IF;
366:
367: l_attachment_id := l_attachment_rec.attachment_id;
368: IF (p_enable_debug = 'Y') THEN
369: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 6a :The attachment id now is='||l_attachment_id);
370: END IF;
371:
372: IF (l_lgl_phys_map_id IS NULL) THEN
373:

Line 375: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 7: inserting into ibe_dsp_lgl_phys_map');

371:
372: IF (l_lgl_phys_map_id IS NULL) THEN
373:
374: IF (p_enable_debug = 'Y') THEN
375: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 7: inserting into ibe_dsp_lgl_phys_map');
376: END IF;
377: -- OPEN c_lgl_phys_map_seq;
378: -- FETCH c_lgl_phys_map_seq into l_next_val;
379: -- close c_lgl_phys_map_seq;

Line 382: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 7a :value of next sequence='||l_next_val);

378: -- FETCH c_lgl_phys_map_seq into l_next_val;
379: -- close c_lgl_phys_map_seq;
380:
381: IF (p_enable_debug = 'Y') THEN
382: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 7a :value of next sequence='||l_next_val);
383: END IF;
384:
385: INSERT INTO IBE_DSP_LGL_PHYS_MAP(lgl_phys_map_id, item_id,
386: msite_id, language_code, default_site, default_language,

Line 395: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 8 :after insertion into ibe_sp_lgl_phys_map');

391: p_default_languages(l_i), l_attachment_id, NULL,
392: 1,FND_GLOBAL.user_id,sysdate,FND_GLOBAL.user_id,sysdate);
393:
394: IF (p_enable_debug = 'Y') THEN
395: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 8 :after insertion into ibe_sp_lgl_phys_map');
396: END IF;
397:
398:
399: END IF;

Line 404: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 9: out of the mappings loop');

400: END IF;
401:
402: END LOOP;
403: IF (p_enable_debug = 'Y') THEN
404: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 9: out of the mappings loop');
405: END IF;
406: IF (p_commit = l_true) THEN
407: COMMIT;
408: END IF;