APPS.PAY_ZA_SOTC_PKG dependencies on FND_FILE

Line 28: fnd_file.put_line(fnd_file.log,'C_PAYROLL_ACTION_ID:'||C_PAYROLL_ACTION_ID);

24: ' and NVL(pay_za_irp5_archive_pkg.get_parameter(''PERIOD_RECON'',ppa.legislative_parameters), ''02'') = NVL('||P_PERIOD_RECON||',''02'')
25: )';
26: END IF;
27:
28: fnd_file.put_line(fnd_file.log,'C_PAYROLL_ACTION_ID:'||C_PAYROLL_ACTION_ID);
29:
30: -- Find Effective Date
31: l_eff_date_sql := ' select max(paa.effective_date) '||
32: ' from pay_payroll_actions paa'||

Line 38: fnd_file.put_line(fnd_file.log,'l_eff_date_sql:'||l_eff_date_sql);

34: C_PAYROLL_ACTION_ID;
35: EXECUTE IMMEDIATE l_eff_date_sql INTO l_eff_date ;
36:
37:
38: fnd_file.put_line(fnd_file.log,'l_eff_date_sql:'||l_eff_date_sql);
39:
40: -- Find Busincess group name
41: select pbg.name
42: into CP_BG_NAME

Line 47: fnd_file.put_line(fnd_file.log,'CP_BG_NAME:'||CP_BG_NAME);

43: from per_business_groups pbg
44: where pbg.business_group_id = p_business_group_id
45: and l_eff_date between pbg.DATE_FROM and nvl(pbg.DATE_TO,to_date('31-12-4712','DD-MM-YYYY'));
46:
47: fnd_file.put_line(fnd_file.log,'CP_BG_NAME:'||CP_BG_NAME);
48:
49: -- Find Legal Entity , Tax Ref
50: select haou.name, hoi.org_information3
51: into CP_LE_NAME, CP_TAX_REF

Line 58: fnd_file.put_line(fnd_file.log,'CP_LE_NAME:'||CP_LE_NAME);

54: where haou.organization_id = P_LEGAL_ENTITY_ID
55: and hoi.organization_id = haou.organization_id
56: and hoi.org_information_context = 'ZA_LEGAL_ENTITY';
57:
58: fnd_file.put_line(fnd_file.log,'CP_LE_NAME:'||CP_LE_NAME);
59: fnd_file.put_line(fnd_file.log,'CP_TAX_REF:'||CP_TAX_REF);
60:
61: -- Tax Year
62: CP_TAX_YEAR := P_TAX_YEAR;

Line 59: fnd_file.put_line(fnd_file.log,'CP_TAX_REF:'||CP_TAX_REF);

55: and hoi.organization_id = haou.organization_id
56: and hoi.org_information_context = 'ZA_LEGAL_ENTITY';
57:
58: fnd_file.put_line(fnd_file.log,'CP_LE_NAME:'||CP_LE_NAME);
59: fnd_file.put_line(fnd_file.log,'CP_TAX_REF:'||CP_TAX_REF);
60:
61: -- Tax Year
62: CP_TAX_YEAR := P_TAX_YEAR;
63: CP_PERIOD_RECON := P_PERIOD_RECON; -- 9877034 fix

Line 92: fnd_file.put_line(fnd_file.log,'l_cert_count_sql:'||l_cert_count_sql);

88: ' and pai.action_information_category = ''ZATYE_EMPLOYEE_INFO'''||
89: C_PAYROLL_ACTION_ID ||
90: ' ) where rownum < 2';
91:
92: fnd_file.put_line(fnd_file.log,'l_cert_count_sql:'||l_cert_count_sql);
93:
94: EXECUTE IMMEDIATE l_cert_count_sql INTO CP_FIRST_CERT_NUM,CP_LAST_CERT_NUM,CP_CERT_COUNT;
95:
96:

Line 107: fnd_file.put_line(fnd_file.log,'l_man_cert_count_sql:'||l_man_cert_count_sql);

103: ' and pai.action_information_category = ''ZATYE_EMPLOYEE_INFO'''||
104: C_PAYROLL_ACTION_ID||
105: ' and pai.action_information28 is not null ';
106:
107: fnd_file.put_line(fnd_file.log,'l_man_cert_count_sql:'||l_man_cert_count_sql);
108:
109: EXECUTE IMMEDIATE l_man_cert_count_sql INTO CP_MAN_CERT_COUNT;
110:
111: