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

Line 321: fnd_file.put_line(fnd_file.LOG, 'begin '||g_pkg_name||'.'||l_api_name||': '||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

317: AND fv.flex_value = es.subsidiary_code
318: AND fv.flex_value_set_id = fnd_profile.value('AMW_SUBSIDIARY_AUDIT_UNIT');
319:
320: BEGIN
321: fnd_file.put_line(fnd_file.LOG, 'begin '||g_pkg_name||'.'||l_api_name||': '||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
322:
323: fnd_file.put_line(fnd_file.LOG, 'Certification_Id:'||p_certification_id);
324:
325: -- First clear out the hierarchy

Line 323: fnd_file.put_line(fnd_file.LOG, 'Certification_Id:'||p_certification_id);

319:
320: BEGIN
321: fnd_file.put_line(fnd_file.LOG, 'begin '||g_pkg_name||'.'||l_api_name||': '||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
322:
323: fnd_file.put_line(fnd_file.LOG, 'Certification_Id:'||p_certification_id);
324:
325: -- First clear out the hierarchy
326: DELETE FROM amw_full_entity_hier
327: WHERE entity_id = p_certification_id;

Line 336: fnd_file.put_line(fnd_file.LOG, 'end '||g_pkg_name||'.'||l_api_name||': '||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

332: END LOOP;
333:
334: populate_org_cert_aggr_rows(p_certification_id);
335:
336: fnd_file.put_line(fnd_file.LOG, 'end '||g_pkg_name||'.'||l_api_name||': '||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
337:
338: EXCEPTION
339: WHEN OTHERS THEN
340: fnd_file.put_line(fnd_file.LOG, 'error '||g_pkg_name||'.'||l_api_name||': '||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

Line 340: fnd_file.put_line(fnd_file.LOG, 'error '||g_pkg_name||'.'||l_api_name||': '||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

336: fnd_file.put_line(fnd_file.LOG, 'end '||g_pkg_name||'.'||l_api_name||': '||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
337:
338: EXCEPTION
339: WHEN OTHERS THEN
340: fnd_file.put_line(fnd_file.LOG, 'error '||g_pkg_name||'.'||l_api_name||': '||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
341: RAISE;
342: END populate_full_hierarchies;
343:
344:

Line 365: fnd_file.put_line(fnd_file.LOG, 'begin '||g_pkg_name||'.'||l_api_name||': '||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

361: AND fv.flex_value = es.subsidiary_code
362: AND fv.flex_value_set_id = fnd_profile.value('AMW_SUBSIDIARY_AUDIT_UNIT');
363:
364: BEGIN
365: fnd_file.put_line(fnd_file.LOG, 'begin '||g_pkg_name||'.'||l_api_name||': '||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
366:
367: SAVEPOINT populate_org_cert_aggr_rows;
368:
369: -- First clear out the existing data

Line 378: fnd_file.put_line(fnd_file.LOG, 'end '||g_pkg_name||'.'||l_api_name||': '||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

374: FOR sub_info IN get_all_subs LOOP
375: recurse_aggregate(p_certification_id, sub_info.flex_value_id);
376: END LOOP;
377:
378: fnd_file.put_line(fnd_file.LOG, 'end '||g_pkg_name||'.'||l_api_name||': '||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
379:
380: EXCEPTION
381: WHEN OTHERS THEN
382: ROLLBACK TO populate_org_cert_aggr_rows;

Line 383: fnd_file.put_line(fnd_file.LOG, 'error '||g_pkg_name||'.'||l_api_name||': '||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

379:
380: EXCEPTION
381: WHEN OTHERS THEN
382: ROLLBACK TO populate_org_cert_aggr_rows;
383: fnd_file.put_line(fnd_file.LOG, 'error '||g_pkg_name||'.'||l_api_name||': '||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
384: RAISE;
385: END populate_org_cert_aggr_rows;
386:
387:

Line 398: fnd_file.put_line(fnd_file.LOG, 'begin '||g_pkg_name||'.'||l_api_name||': '||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

394: l_api_name CONSTANT VARCHAR2(30) := 'update_org_cert_aggr_rows';
395:
396: l_flex_value_id NUMBER;
397: BEGIN
398: fnd_file.put_line(fnd_file.LOG, 'begin '||g_pkg_name||'.'||l_api_name||': '||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
399:
400: SAVEPOINT update_org_cert_aggr_rows;
401:
402: SELECT to_number(org_information1)

Line 412: fnd_file.put_line(fnd_file.LOG, 'end '||g_pkg_name||'.'||l_api_name||': '||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

408:
409: recurse_aggregate(p_certification_id, l_flex_value_id);
410:
411:
412: fnd_file.put_line(fnd_file.LOG, 'end '||g_pkg_name||'.'||l_api_name||': '||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
413:
414: EXCEPTION
415: WHEN OTHERS THEN
416: ROLLBACK TO update_org_cert_aggr_rows;

Line 417: fnd_file.put_line(fnd_file.LOG, 'error '||g_pkg_name||'.'||l_api_name||': '||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

413:
414: EXCEPTION
415: WHEN OTHERS THEN
416: ROLLBACK TO update_org_cert_aggr_rows;
417: fnd_file.put_line(fnd_file.LOG, 'error '||g_pkg_name||'.'||l_api_name||': '||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
418: RAISE;
419: END update_org_cert_aggr_rows;
420:
421: