APPS.PER_KW_XDO_REPORT dependencies on FND_FILE

Line 314: --fnd_file.put_line(fnd_file.log,'in org cursor: '||rec_get_org_id.name);

310: OPEN csr_get_org_id;
311: LOOP
312: FETCH csr_get_org_id INTO rec_get_org_id;
313: EXIT WHEN csr_get_org_id%NOTFOUND;
314: --fnd_file.put_line(fnd_file.log,'in org cursor: '||rec_get_org_id.name);
315: l_emp_found := 0;
316: i := 1;
317: OPEN csr_get_dis_emp;
318: LOOP

Line 415: --fnd_file.put_line(fnd_file.log,'in dis procedure: '||rec_get_dis_emp.employee_number||'*'||rec_get_org_id.name);

411: gxmltable(gCtr).tagValue := ('----------------');
412: gctr := gctr + 1;
413: l_emp_found := 1;
414: END IF;
415: --fnd_file.put_line(fnd_file.log,'in dis procedure: '||rec_get_dis_emp.employee_number||'*'||rec_get_org_id.name);
416: l_incident_date := NULL;
417: IF rec_get_dis_emp.incident_id IS NOT NULL THEN
418: BEGIN
419: SELECT incident_date

Line 639: fnd_file.put_line(fnd_file.log,'l_date: '|| l_date);

635: l_date := TRUNC(sysdate);
636: END IF;
637: INSERT INTO fnd_sessions (session_id, effective_date)
638: VALUES (userenv('SESSIONID'), l_date);
639: fnd_file.put_line(fnd_file.log,'l_date: '|| l_date);
640: l_parent_id := NULL;
641: l_org_name := NULL;
642: l_structure_name := NULL;
643: l_version := NULL;

Line 794: fnd_file.put_line(fnd_file.log,'BG ID: '|| l_business_group_id);

790: LOOP
791: FETCH csr_get_bg_id INTO rec_get_bg_id;
792: EXIT WHEN csr_get_bg_id%NOTFOUND;
793: l_business_group_id := rec_get_bg_id.business_group_id;
794: fnd_file.put_line(fnd_file.log,'BG ID: '|| l_business_group_id);
795: OPEN csr_get_org_id;
796: LOOP
797: FETCH csr_get_org_id INTO rec_get_org_id;
798: fnd_file.put_line(fnd_file.log,'rec_get_org_id.organization_id: '|| rec_get_org_id.organization_id);

Line 798: fnd_file.put_line(fnd_file.log,'rec_get_org_id.organization_id: '|| rec_get_org_id.organization_id);

794: fnd_file.put_line(fnd_file.log,'BG ID: '|| l_business_group_id);
795: OPEN csr_get_org_id;
796: LOOP
797: FETCH csr_get_org_id INTO rec_get_org_id;
798: fnd_file.put_line(fnd_file.log,'rec_get_org_id.organization_id: '|| rec_get_org_id.organization_id);
799: EXIT WHEN csr_get_org_id%NOTFOUND;
800: --fnd_file.put_line(fnd_file.log,'in org cursor: '||rec_get_org_id.name);
801: fnd_file.put_line(fnd_file.log,'rec_get_org_id.organization_id: '|| rec_get_org_id.organization_id);
802: l_emp_found := 0;

Line 800: --fnd_file.put_line(fnd_file.log,'in org cursor: '||rec_get_org_id.name);

796: LOOP
797: FETCH csr_get_org_id INTO rec_get_org_id;
798: fnd_file.put_line(fnd_file.log,'rec_get_org_id.organization_id: '|| rec_get_org_id.organization_id);
799: EXIT WHEN csr_get_org_id%NOTFOUND;
800: --fnd_file.put_line(fnd_file.log,'in org cursor: '||rec_get_org_id.name);
801: fnd_file.put_line(fnd_file.log,'rec_get_org_id.organization_id: '|| rec_get_org_id.organization_id);
802: l_emp_found := 0;
803: i := 1;
804: OPEN csr_get_cont_emp;

Line 801: fnd_file.put_line(fnd_file.log,'rec_get_org_id.organization_id: '|| rec_get_org_id.organization_id);

797: FETCH csr_get_org_id INTO rec_get_org_id;
798: fnd_file.put_line(fnd_file.log,'rec_get_org_id.organization_id: '|| rec_get_org_id.organization_id);
799: EXIT WHEN csr_get_org_id%NOTFOUND;
800: --fnd_file.put_line(fnd_file.log,'in org cursor: '||rec_get_org_id.name);
801: fnd_file.put_line(fnd_file.log,'rec_get_org_id.organization_id: '|| rec_get_org_id.organization_id);
802: l_emp_found := 0;
803: i := 1;
804: OPEN csr_get_cont_emp;
805: LOOP