DBA Data[Home] [Help]

APPS.PAY_PAYSLIP_UTIL dependencies on HR_UTILITY

Line 124: hr_utility.trace('Entered into get_id_for_employer_address.');

120: ld_payslip_eff_dt date;
121:
122: BEGIN
123:
124: hr_utility.trace('Entered into get_id_for_employer_address.');
125: hr_utility.trace('Parameter p_business_group_id := ' || p_business_group_id);
126: hr_utility.trace('Parameter p_tax_unit_id := ' || p_tax_unit_id);
127: hr_utility.trace('Parameter p_organization_id := ' || p_organization_id);
128: hr_utility.trace('Parameter p_effective_date := ' || TO_CHAR(p_effective_date));

Line 125: hr_utility.trace('Parameter p_business_group_id := ' || p_business_group_id);

121:
122: BEGIN
123:
124: hr_utility.trace('Entered into get_id_for_employer_address.');
125: hr_utility.trace('Parameter p_business_group_id := ' || p_business_group_id);
126: hr_utility.trace('Parameter p_tax_unit_id := ' || p_tax_unit_id);
127: hr_utility.trace('Parameter p_organization_id := ' || p_organization_id);
128: hr_utility.trace('Parameter p_effective_date := ' || TO_CHAR(p_effective_date));
129:

Line 126: hr_utility.trace('Parameter p_tax_unit_id := ' || p_tax_unit_id);

122: BEGIN
123:
124: hr_utility.trace('Entered into get_id_for_employer_address.');
125: hr_utility.trace('Parameter p_business_group_id := ' || p_business_group_id);
126: hr_utility.trace('Parameter p_tax_unit_id := ' || p_tax_unit_id);
127: hr_utility.trace('Parameter p_organization_id := ' || p_organization_id);
128: hr_utility.trace('Parameter p_effective_date := ' || TO_CHAR(p_effective_date));
129:
130: /* Following section of code has been introduced for US legislation

Line 127: hr_utility.trace('Parameter p_organization_id := ' || p_organization_id);

123:
124: hr_utility.trace('Entered into get_id_for_employer_address.');
125: hr_utility.trace('Parameter p_business_group_id := ' || p_business_group_id);
126: hr_utility.trace('Parameter p_tax_unit_id := ' || p_tax_unit_id);
127: hr_utility.trace('Parameter p_organization_id := ' || p_organization_id);
128: hr_utility.trace('Parameter p_effective_date := ' || TO_CHAR(p_effective_date));
129:
130: /* Following section of code has been introduced for US legislation
131: to enable display of GRE Address on payslip. In addition to leg

Line 128: hr_utility.trace('Parameter p_effective_date := ' || TO_CHAR(p_effective_date));

124: hr_utility.trace('Entered into get_id_for_employer_address.');
125: hr_utility.trace('Parameter p_business_group_id := ' || p_business_group_id);
126: hr_utility.trace('Parameter p_tax_unit_id := ' || p_tax_unit_id);
127: hr_utility.trace('Parameter p_organization_id := ' || p_organization_id);
128: hr_utility.trace('Parameter p_effective_date := ' || TO_CHAR(p_effective_date));
129:
130: /* Following section of code has been introduced for US legislation
131: to enable display of GRE Address on payslip. In addition to leg
132: rule US has introduced 2 DFF segments under BG > Self Service Prefernces.

Line 158: hr_utility.trace('gv_employer_addr_cd := ' || gv_employer_addr_cd);

154: CLOSE get_legi_rule;
155:
156: END IF;
157:
158: hr_utility.trace('gv_employer_addr_cd := ' || gv_employer_addr_cd);
159: hr_utility.trace('gv_legislation_code := ' || gv_legislation_code);
160:
161: IF gv_legislation_code = 'US' THEN
162:

Line 159: hr_utility.trace('gv_legislation_code := ' || gv_legislation_code);

155:
156: END IF;
157:
158: hr_utility.trace('gv_employer_addr_cd := ' || gv_employer_addr_cd);
159: hr_utility.trace('gv_legislation_code := ' || gv_legislation_code);
160:
161: IF gv_legislation_code = 'US' THEN
162:
163: hr_utility.trace('Code specific to US legislation.');

Line 163: hr_utility.trace('Code specific to US legislation.');

159: hr_utility.trace('gv_legislation_code := ' || gv_legislation_code);
160:
161: IF gv_legislation_code = 'US' THEN
162:
163: hr_utility.trace('Code specific to US legislation.');
164:
165: IF p_tax_unit_id IS NULL and p_organization_id IS NOT NULL THEN
166: return (p_organization_id);
167: ELSIF p_tax_unit_id IS NOT NULL and p_organization_id IS NULL THEN

Line 184: hr_utility.trace('lv_employer_type := ' || lv_employer_type);

180: else
181: lv_employer_type:=g_employer_type;
182: ld_payslip_eff_dt:=g_payslip_eff_dt;
183: end if;
184: hr_utility.trace('lv_employer_type := ' || lv_employer_type);
185: hr_utility.trace('ld_payslip_eff_dt := ' || TO_CHAR(ld_payslip_eff_dt));
186:
187: IF lv_employer_type = 'G' AND p_effective_date >= ld_payslip_eff_dt THEN
188: return(p_tax_unit_id);

Line 185: hr_utility.trace('ld_payslip_eff_dt := ' || TO_CHAR(ld_payslip_eff_dt));

181: lv_employer_type:=g_employer_type;
182: ld_payslip_eff_dt:=g_payslip_eff_dt;
183: end if;
184: hr_utility.trace('lv_employer_type := ' || lv_employer_type);
185: hr_utility.trace('ld_payslip_eff_dt := ' || TO_CHAR(ld_payslip_eff_dt));
186:
187: IF lv_employer_type = 'G' AND p_effective_date >= ld_payslip_eff_dt THEN
188: return(p_tax_unit_id);
189: ELSE

Line 248: --hr_utility.trace_on(null,'payslip_util');

244: l_rule_mode VARCHAR2(50);
245: lv_legislation_code varchar2(3);
246:
247: BEGIN
248: --hr_utility.trace_on(null,'payslip_util');
249: hr_utility.trace(gv_legislation_code);
250:
251: lv_legislation_code := get_legislation_code(p_business_group_id);
252:

Line 249: hr_utility.trace(gv_legislation_code);

245: lv_legislation_code varchar2(3);
246:
247: BEGIN
248: --hr_utility.trace_on(null,'payslip_util');
249: hr_utility.trace(gv_legislation_code);
250:
251: lv_legislation_code := get_legislation_code(p_business_group_id);
252:
253: hr_utility.trace('lv_legislation_code ' ||lv_legislation_code);

Line 253: hr_utility.trace('lv_legislation_code ' ||lv_legislation_code);

249: hr_utility.trace(gv_legislation_code);
250:
251: lv_legislation_code := get_legislation_code(p_business_group_id);
252:
253: hr_utility.trace('lv_legislation_code ' ||lv_legislation_code);
254:
255: OPEN get_legislative_rule(lv_legislation_code);
256: FETCH get_legislative_rule into l_rule_mode;
257: CLOSE get_legislative_rule;

Line 260: hr_utility.trace('l_rule_mode '||l_rule_mode);

256: FETCH get_legislative_rule into l_rule_mode;
257: CLOSE get_legislative_rule;
258:
259:
260: hr_utility.trace('l_rule_mode '||l_rule_mode);
261: return l_rule_mode;
262:
263: END get_leg_rule_state;
264: