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.PAY_NL_CBS_FILE dependencies on HR_UTILITY

Line 56: -- hr_utility.set_location('Entered get all parameters',425);

52: -- l_proc VARCHAR2(80):= g_package||' get_all_parameters ';
53: --
54: BEGIN
55: --
56: -- hr_utility.set_location('Entered get all parameters',425);
57:
58: OPEN csr_parameter_info (p_payroll_action_id);
59: FETCH csr_parameter_info INTO
60: p_reporting_date,p_employer, p_org_struct_id,p_si_provider,p_medium_code,p_density

Line 65: hr_utility.set_location('Executed the cursor in get all parameters ',425);

61: ,p_effective_date,p_business_group_id;
62: CLOSE csr_parameter_info;
63: g_reporting_date:= p_reporting_date;
64: if g_debug then
65: hr_utility.set_location('Executed the cursor in get all parameters ',425);
66: hr_utility.set_location('p_reporting_date'||p_reporting_date,425);
67: hr_utility.set_location('p_employer'||p_employer,425);
68: hr_utility.set_location('p_org_struct_id'||p_org_struct_id,425);
69: hr_utility.set_location('p_si_provider'||p_si_provider,425);

Line 66: hr_utility.set_location('p_reporting_date'||p_reporting_date,425);

62: CLOSE csr_parameter_info;
63: g_reporting_date:= p_reporting_date;
64: if g_debug then
65: hr_utility.set_location('Executed the cursor in get all parameters ',425);
66: hr_utility.set_location('p_reporting_date'||p_reporting_date,425);
67: hr_utility.set_location('p_employer'||p_employer,425);
68: hr_utility.set_location('p_org_struct_id'||p_org_struct_id,425);
69: hr_utility.set_location('p_si_provider'||p_si_provider,425);
70: hr_utility.set_location('p_medium_code'||p_medium_code,425);

Line 67: hr_utility.set_location('p_employer'||p_employer,425);

63: g_reporting_date:= p_reporting_date;
64: if g_debug then
65: hr_utility.set_location('Executed the cursor in get all parameters ',425);
66: hr_utility.set_location('p_reporting_date'||p_reporting_date,425);
67: hr_utility.set_location('p_employer'||p_employer,425);
68: hr_utility.set_location('p_org_struct_id'||p_org_struct_id,425);
69: hr_utility.set_location('p_si_provider'||p_si_provider,425);
70: hr_utility.set_location('p_medium_code'||p_medium_code,425);
71: hr_utility.set_location('p_density'||p_density,425);

Line 68: hr_utility.set_location('p_org_struct_id'||p_org_struct_id,425);

64: if g_debug then
65: hr_utility.set_location('Executed the cursor in get all parameters ',425);
66: hr_utility.set_location('p_reporting_date'||p_reporting_date,425);
67: hr_utility.set_location('p_employer'||p_employer,425);
68: hr_utility.set_location('p_org_struct_id'||p_org_struct_id,425);
69: hr_utility.set_location('p_si_provider'||p_si_provider,425);
70: hr_utility.set_location('p_medium_code'||p_medium_code,425);
71: hr_utility.set_location('p_density'||p_density,425);
72: hr_utility.set_location('p_effective_date'||p_effective_date,425);

Line 69: hr_utility.set_location('p_si_provider'||p_si_provider,425);

65: hr_utility.set_location('Executed the cursor in get all parameters ',425);
66: hr_utility.set_location('p_reporting_date'||p_reporting_date,425);
67: hr_utility.set_location('p_employer'||p_employer,425);
68: hr_utility.set_location('p_org_struct_id'||p_org_struct_id,425);
69: hr_utility.set_location('p_si_provider'||p_si_provider,425);
70: hr_utility.set_location('p_medium_code'||p_medium_code,425);
71: hr_utility.set_location('p_density'||p_density,425);
72: hr_utility.set_location('p_effective_date'||p_effective_date,425);
73: hr_utility.set_location('p_business_group_id'||p_business_group_id,425);

Line 70: hr_utility.set_location('p_medium_code'||p_medium_code,425);

66: hr_utility.set_location('p_reporting_date'||p_reporting_date,425);
67: hr_utility.set_location('p_employer'||p_employer,425);
68: hr_utility.set_location('p_org_struct_id'||p_org_struct_id,425);
69: hr_utility.set_location('p_si_provider'||p_si_provider,425);
70: hr_utility.set_location('p_medium_code'||p_medium_code,425);
71: hr_utility.set_location('p_density'||p_density,425);
72: hr_utility.set_location('p_effective_date'||p_effective_date,425);
73: hr_utility.set_location('p_business_group_id'||p_business_group_id,425);
74: end if;

Line 71: hr_utility.set_location('p_density'||p_density,425);

67: hr_utility.set_location('p_employer'||p_employer,425);
68: hr_utility.set_location('p_org_struct_id'||p_org_struct_id,425);
69: hr_utility.set_location('p_si_provider'||p_si_provider,425);
70: hr_utility.set_location('p_medium_code'||p_medium_code,425);
71: hr_utility.set_location('p_density'||p_density,425);
72: hr_utility.set_location('p_effective_date'||p_effective_date,425);
73: hr_utility.set_location('p_business_group_id'||p_business_group_id,425);
74: end if;
75: -- hr_utility.set_location('Leaving get all parameters',425);

Line 72: hr_utility.set_location('p_effective_date'||p_effective_date,425);

68: hr_utility.set_location('p_org_struct_id'||p_org_struct_id,425);
69: hr_utility.set_location('p_si_provider'||p_si_provider,425);
70: hr_utility.set_location('p_medium_code'||p_medium_code,425);
71: hr_utility.set_location('p_density'||p_density,425);
72: hr_utility.set_location('p_effective_date'||p_effective_date,425);
73: hr_utility.set_location('p_business_group_id'||p_business_group_id,425);
74: end if;
75: -- hr_utility.set_location('Leaving get all parameters',425);
76:

Line 73: hr_utility.set_location('p_business_group_id'||p_business_group_id,425);

69: hr_utility.set_location('p_si_provider'||p_si_provider,425);
70: hr_utility.set_location('p_medium_code'||p_medium_code,425);
71: hr_utility.set_location('p_density'||p_density,425);
72: hr_utility.set_location('p_effective_date'||p_effective_date,425);
73: hr_utility.set_location('p_business_group_id'||p_business_group_id,425);
74: end if;
75: -- hr_utility.set_location('Leaving get all parameters',425);
76:
77: --

Line 75: -- hr_utility.set_location('Leaving get all parameters',425);

71: hr_utility.set_location('p_density'||p_density,425);
72: hr_utility.set_location('p_effective_date'||p_effective_date,425);
73: hr_utility.set_location('p_business_group_id'||p_business_group_id,425);
74: end if;
75: -- hr_utility.set_location('Leaving get all parameters',425);
76:
77: --
78: END get_all_parameters;
79: --

Line 97: -- hr_utility.set_location('Entered Mandatory_check',425);

93: v_log_header VARCHAR2(255);
94: v_label_desc hr_lookups.meaning%TYPE;
95:
96: Begin
97: -- hr_utility.set_location('Entered Mandatory_check',425);
98:
99: if g_debug then
100: hr_utility.set_location('Started Checking Field in Mandatory_Check '||p_field,425);
101: end if;

Line 100: hr_utility.set_location('Started Checking Field in Mandatory_Check '||p_field,425);

96: Begin
97: -- hr_utility.set_location('Entered Mandatory_check',425);
98:
99: if g_debug then
100: hr_utility.set_location('Started Checking Field in Mandatory_Check '||p_field,425);
101: end if;
102:
103: If p_value is null then
104: v_label_desc := hr_general.decode_lookup('HR_NL_REPORT_LABELS', p_field);

Line 109: hr_utility.set_message(801,p_message_name);

105: v_employee_dat :=RPAD(SUBSTR(g_assignment_number,1,20),20)
106: ||' '||RPAD(SUBSTR(g_full_name,1,35),35)
107: ||' '||RPAD(SUBSTR(v_label_desc,1,35),35);
108: -- ||' '||RPAD(SUBSTR(g_error_flag,1,15),15);
109: hr_utility.set_message(801,p_message_name);
110: -- v_message_text :=SUBSTR(fnd_message.get,1,65);
111: g_error_count := NVL(g_error_count,0) +1;
112: if p_message_name <> g_message_name then
113: if g_message_name = 'PAY_NL_EE_REQUIRED_FIELD' then

Line 122: hr_utility.set_message(801,p_message_name);

118: --||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','MESSAGE'),1,70),70
119: ;
120: Fnd_file.put_line(FND_FILE.LOG,v_log_header);
121: end if;
122: hr_utility.set_message(801,p_message_name);
123: v_message_text := rpad(fnd_message.get,255,' ');
124: FND_FILE.PUT_LINE(FND_FILE.LOG,v_message_text);
125: g_message_name := p_message_name;
126: end if;

Line 129: -- hr_utility.set_location('Leaving get all parameters',425);

125: g_message_name := p_message_name;
126: end if;
127: FND_FILE.PUT_LINE(FND_FILE.LOG, v_employee_dat);
128: end if;
129: -- hr_utility.set_location('Leaving get all parameters',425);
130: End Mandatory_Check;
131:
132: /********************************************************************************
133: |Name : get_loc_extra_info |

Line 149: -- hr_utility.set_location('Entering Get_loc_extra_info',600);

145: from hr_location_extra_info
146: where information_type = 'NL_POSTAL_ADDRESS'
147: and location_id = (select location_id from hr_organization_units where organization_id = p_org_id);
148: begin
149: -- hr_utility.set_location('Entering Get_loc_extra_info',600);
150: open csr_loc_extra_info(p_org_id);
151: fetch csr_loc_extra_info into p_contact,p_telephone;
152: close csr_loc_extra_info;
153: -- hr_utility.set_location('Exiting Get_loc_extra_info',600);

Line 153: -- hr_utility.set_location('Exiting Get_loc_extra_info',600);

149: -- hr_utility.set_location('Entering Get_loc_extra_info',600);
150: open csr_loc_extra_info(p_org_id);
151: fetch csr_loc_extra_info into p_contact,p_telephone;
152: close csr_loc_extra_info;
153: -- hr_utility.set_location('Exiting Get_loc_extra_info',600);
154: return 1;
155: end get_loc_extra_info;
156:
157: /********************************************************************************

Line 179: -- hr_utility.set_location('Entering Get_er_Sequence',600);

175:
176: l_max_sequence varchar2(30);
177: l_sequence number;
178: BEGIN
179: -- hr_utility.set_location('Entering Get_er_Sequence',600);
180: open csr_get_max_sequence;
181: fetch csr_get_max_sequence into l_max_Sequence;
182: close csr_get_max_Sequence;
183: l_sequence := fnd_number.canonical_to_number(l_max_Sequence);

Line 185: -- hr_utility.set_location('Exiting Get_er_Sequence',600);

181: fetch csr_get_max_sequence into l_max_Sequence;
182: close csr_get_max_Sequence;
183: l_sequence := fnd_number.canonical_to_number(l_max_Sequence);
184: p_sequence := nvl(to_number(l_sequence),0) + 1;
185: -- hr_utility.set_location('Exiting Get_er_Sequence',600);
186: return 1;
187: END Get_er_sequence;
188:
189: /*******************************************************************************

Line 222: -- hr_utility.set_location('Entered get_balances1',425);

218: l_defined_balance_id NUMBER;
219:
220:
221: BEGIN
222: -- hr_utility.set_location('Entered get_balances1',425);
223:
224: if p_frequency = 'K' then
225: l_dimension := '_ASG_QTD';
226: else

Line 234: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_HOLIDAY_HOURS',500);

230: l_dimension := '_ASG_LMONTH';
231: end if;
232: end if;
233:
234: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_HOLIDAY_HOURS',500);
235: l_defined_balance := 'CBS_HOLIDAY_HOURS'||l_dimension;
236: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
237: l_holiday_hours:= nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
238: -- hr_utility.set_location('l_holiday_hours'||l_holiday_hours,425);

Line 238: -- hr_utility.set_location('l_holiday_hours'||l_holiday_hours,425);

234: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_HOLIDAY_HOURS',500);
235: l_defined_balance := 'CBS_HOLIDAY_HOURS'||l_dimension;
236: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
237: l_holiday_hours:= nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
238: -- hr_utility.set_location('l_holiday_hours'||l_holiday_hours,425);
239:
240: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_ADV_HOURS',500);
241: l_defined_balance := 'CBS_ADV_HOURS'||l_dimension;
242: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);

Line 240: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_ADV_HOURS',500);

236: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
237: l_holiday_hours:= nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
238: -- hr_utility.set_location('l_holiday_hours'||l_holiday_hours,425);
239:
240: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_ADV_HOURS',500);
241: l_defined_balance := 'CBS_ADV_HOURS'||l_dimension;
242: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
243: l_adv_hours:=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
244: -- hr_utility.set_location('l_adv_hours'||l_adv_hours,425);

Line 244: -- hr_utility.set_location('l_adv_hours'||l_adv_hours,425);

240: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_ADV_HOURS',500);
241: l_defined_balance := 'CBS_ADV_HOURS'||l_dimension;
242: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
243: l_adv_hours:=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
244: -- hr_utility.set_location('l_adv_hours'||l_adv_hours,425);
245:
246: -- hr_utility.set_location('Fetching Defined Balance ID for SI_INCOME_STANDARD_TAX',500);
247: l_defined_balance := 'SI_INCOME_STANDARD_TAX'||l_dimension;
248: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);

Line 246: -- hr_utility.set_location('Fetching Defined Balance ID for SI_INCOME_STANDARD_TAX',500);

242: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
243: l_adv_hours:=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
244: -- hr_utility.set_location('l_adv_hours'||l_adv_hours,425);
245:
246: -- hr_utility.set_location('Fetching Defined Balance ID for SI_INCOME_STANDARD_TAX',500);
247: l_defined_balance := 'SI_INCOME_STANDARD_TAX'||l_dimension;
248: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
249: l_si_std_tax:=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
250: -- hr_utility.set_location('l_si_std_tax'||l_si_std_tax,425);

Line 250: -- hr_utility.set_location('l_si_std_tax'||l_si_std_tax,425);

246: -- hr_utility.set_location('Fetching Defined Balance ID for SI_INCOME_STANDARD_TAX',500);
247: l_defined_balance := 'SI_INCOME_STANDARD_TAX'||l_dimension;
248: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
249: l_si_std_tax:=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
250: -- hr_utility.set_location('l_si_std_tax'||l_si_std_tax,425);
251:
252: -- hr_utility.set_location('Fetching Defined Balance ID for SI_INCOME_SPECIAL_TAX',500);
253: l_defined_balance := 'SI_INCOME_SPECIAL_TAX'||l_dimension;
254: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);

Line 252: -- hr_utility.set_location('Fetching Defined Balance ID for SI_INCOME_SPECIAL_TAX',500);

248: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
249: l_si_std_tax:=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
250: -- hr_utility.set_location('l_si_std_tax'||l_si_std_tax,425);
251:
252: -- hr_utility.set_location('Fetching Defined Balance ID for SI_INCOME_SPECIAL_TAX',500);
253: l_defined_balance := 'SI_INCOME_SPECIAL_TAX'||l_dimension;
254: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
255: l_si_spl_tax:=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
256: -- hr_utility.set_location('l_si_spl_tax'||l_si_spl_tax,425);

Line 256: -- hr_utility.set_location('l_si_spl_tax'||l_si_spl_tax,425);

252: -- hr_utility.set_location('Fetching Defined Balance ID for SI_INCOME_SPECIAL_TAX',500);
253: l_defined_balance := 'SI_INCOME_SPECIAL_TAX'||l_dimension;
254: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
255: l_si_spl_tax:=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
256: -- hr_utility.set_location('l_si_spl_tax'||l_si_spl_tax,425);
257:
258: -- hr_utility.set_location('Fetching Defined Balance ID for RETRO SI_INCOME_STANDARD_TAX',500);
259: l_defined_balance := 'RETRO_SI_INCOME_STANDARD_TAX'||l_dimension;
260: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);

Line 258: -- hr_utility.set_location('Fetching Defined Balance ID for RETRO SI_INCOME_STANDARD_TAX',500);

254: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
255: l_si_spl_tax:=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
256: -- hr_utility.set_location('l_si_spl_tax'||l_si_spl_tax,425);
257:
258: -- hr_utility.set_location('Fetching Defined Balance ID for RETRO SI_INCOME_STANDARD_TAX',500);
259: l_defined_balance := 'RETRO_SI_INCOME_STANDARD_TAX'||l_dimension;
260: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
261: l_ret_si_std_tax :=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
262: -- hr_utility.set_location('l_ret_si_std_tax'||l_ret_si_std_tax,425);

Line 262: -- hr_utility.set_location('l_ret_si_std_tax'||l_ret_si_std_tax,425);

258: -- hr_utility.set_location('Fetching Defined Balance ID for RETRO SI_INCOME_STANDARD_TAX',500);
259: l_defined_balance := 'RETRO_SI_INCOME_STANDARD_TAX'||l_dimension;
260: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
261: l_ret_si_std_tax :=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
262: -- hr_utility.set_location('l_ret_si_std_tax'||l_ret_si_std_tax,425);
263:
264: -- hr_utility.set_location('Fetching Defined Balance ID for RETRO_SI_INCOME_SPECIAL_TAX',500);
265: l_defined_balance := 'RETRO_SI_INCOME_SPECIAL_TAX'||l_dimension;
266: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);

Line 264: -- hr_utility.set_location('Fetching Defined Balance ID for RETRO_SI_INCOME_SPECIAL_TAX',500);

260: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
261: l_ret_si_std_tax :=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
262: -- hr_utility.set_location('l_ret_si_std_tax'||l_ret_si_std_tax,425);
263:
264: -- hr_utility.set_location('Fetching Defined Balance ID for RETRO_SI_INCOME_SPECIAL_TAX',500);
265: l_defined_balance := 'RETRO_SI_INCOME_SPECIAL_TAX'||l_dimension;
266: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
267: l_ret_si_spl_tax:=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
268: -- hr_utility.set_location('l_ret_si_spl_tax'||l_ret_si_spl_tax,425);

Line 268: -- hr_utility.set_location('l_ret_si_spl_tax'||l_ret_si_spl_tax,425);

264: -- hr_utility.set_location('Fetching Defined Balance ID for RETRO_SI_INCOME_SPECIAL_TAX',500);
265: l_defined_balance := 'RETRO_SI_INCOME_SPECIAL_TAX'||l_dimension;
266: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
267: l_ret_si_spl_tax:=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
268: -- hr_utility.set_location('l_ret_si_spl_tax'||l_ret_si_spl_tax,425);
269:
270: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_UNIQUE_PAYMENTS',500);
271: l_defined_balance := 'CBS_UNIQUE_PAYMENTS'||l_dimension;
272: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);

Line 270: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_UNIQUE_PAYMENTS',500);

266: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
267: l_ret_si_spl_tax:=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
268: -- hr_utility.set_location('l_ret_si_spl_tax'||l_ret_si_spl_tax,425);
269:
270: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_UNIQUE_PAYMENTS',500);
271: l_defined_balance := 'CBS_UNIQUE_PAYMENTS'||l_dimension;
272: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
273: l_unique_payments :=round(nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0));
274: -- hr_utility.set_location('l_unique_payments'||l_unique_payments,425);

Line 274: -- hr_utility.set_location('l_unique_payments'||l_unique_payments,425);

270: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_UNIQUE_PAYMENTS',500);
271: l_defined_balance := 'CBS_UNIQUE_PAYMENTS'||l_dimension;
272: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
273: l_unique_payments :=round(nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0));
274: -- hr_utility.set_location('l_unique_payments'||l_unique_payments,425);
275:
276: -- hr_utility.set_location('Fetching Defined Balance ID for PRE_TAX_ONLY_DEDUCTIONS',500);
277: l_defined_balance := 'PRE_TAX_ONLY_DEDUCTIONS'||l_dimension;
278: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);

Line 276: -- hr_utility.set_location('Fetching Defined Balance ID for PRE_TAX_ONLY_DEDUCTIONS',500);

272: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
273: l_unique_payments :=round(nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0));
274: -- hr_utility.set_location('l_unique_payments'||l_unique_payments,425);
275:
276: -- hr_utility.set_location('Fetching Defined Balance ID for PRE_TAX_ONLY_DEDUCTIONS',500);
277: l_defined_balance := 'PRE_TAX_ONLY_DEDUCTIONS'||l_dimension;
278: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
279: l_pre_tax_only_ded:=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
280: -- hr_utility.set_location('l_pre_tax_only_ded'||l_pre_tax_only_ded,425);

Line 280: -- hr_utility.set_location('l_pre_tax_only_ded'||l_pre_tax_only_ded,425);

276: -- hr_utility.set_location('Fetching Defined Balance ID for PRE_TAX_ONLY_DEDUCTIONS',500);
277: l_defined_balance := 'PRE_TAX_ONLY_DEDUCTIONS'||l_dimension;
278: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
279: l_pre_tax_only_ded:=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
280: -- hr_utility.set_location('l_pre_tax_only_ded'||l_pre_tax_only_ded,425);
281:
282: -- hr_utility.set_location('Fetching Defined Balance ID for PRE_TAX_ONLY_DEDUCTIONS',500);
283: l_defined_balance := 'PRE_TAX_DEDUCTIONS'||l_dimension;
284: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);

Line 282: -- hr_utility.set_location('Fetching Defined Balance ID for PRE_TAX_ONLY_DEDUCTIONS',500);

278: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
279: l_pre_tax_only_ded:=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
280: -- hr_utility.set_location('l_pre_tax_only_ded'||l_pre_tax_only_ded,425);
281:
282: -- hr_utility.set_location('Fetching Defined Balance ID for PRE_TAX_ONLY_DEDUCTIONS',500);
283: l_defined_balance := 'PRE_TAX_DEDUCTIONS'||l_dimension;
284: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
285: l_pre_si_pre_tax_ded :=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
286: -- hr_utility.set_location('l_pre_si_pre_tax_ded'||l_pre_si_pre_tax_ded,425);

Line 286: -- hr_utility.set_location('l_pre_si_pre_tax_ded'||l_pre_si_pre_tax_ded,425);

282: -- hr_utility.set_location('Fetching Defined Balance ID for PRE_TAX_ONLY_DEDUCTIONS',500);
283: l_defined_balance := 'PRE_TAX_DEDUCTIONS'||l_dimension;
284: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
285: l_pre_si_pre_tax_ded :=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
286: -- hr_utility.set_location('l_pre_si_pre_tax_ded'||l_pre_si_pre_tax_ded,425);
287:
288: -- hr_utility.set_location('Fetching Defined Balance ID for EMPLOYEE_SAVINGS_CONTRIBUTION',500);
289: l_defined_balance := 'EMPLOYEE_SAVINGS_CONTRIBUTION'||l_dimension;
290: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);

Line 288: -- hr_utility.set_location('Fetching Defined Balance ID for EMPLOYEE_SAVINGS_CONTRIBUTION',500);

284: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
285: l_pre_si_pre_tax_ded :=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
286: -- hr_utility.set_location('l_pre_si_pre_tax_ded'||l_pre_si_pre_tax_ded,425);
287:
288: -- hr_utility.set_location('Fetching Defined Balance ID for EMPLOYEE_SAVINGS_CONTRIBUTION',500);
289: l_defined_balance := 'EMPLOYEE_SAVINGS_CONTRIBUTION'||l_dimension;
290: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
291: l_saving_scheme:=round(nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0));
292: -- hr_utility.set_location('l_saving_scheme'||l_saving_scheme,425);

Line 292: -- hr_utility.set_location('l_saving_scheme'||l_saving_scheme,425);

288: -- hr_utility.set_location('Fetching Defined Balance ID for EMPLOYEE_SAVINGS_CONTRIBUTION',500);
289: l_defined_balance := 'EMPLOYEE_SAVINGS_CONTRIBUTION'||l_dimension;
290: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
291: l_saving_scheme:=round(nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0));
292: -- hr_utility.set_location('l_saving_scheme'||l_saving_scheme,425);
293:
294: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_SICKNESS_DAYS',500);
295: l_defined_balance := 'CBS_SICKNESS_DAYS'||l_dimension;
296: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);

Line 294: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_SICKNESS_DAYS',500);

290: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
291: l_saving_scheme:=round(nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0));
292: -- hr_utility.set_location('l_saving_scheme'||l_saving_scheme,425);
293:
294: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_SICKNESS_DAYS',500);
295: l_defined_balance := 'CBS_SICKNESS_DAYS'||l_dimension;
296: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
297: l_sickness_days :=round(nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0));
298: -- hr_utility.set_location('l_sickness_days'||l_sickness_days,425);

Line 298: -- hr_utility.set_location('l_sickness_days'||l_sickness_days,425);

294: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_SICKNESS_DAYS',500);
295: l_defined_balance := 'CBS_SICKNESS_DAYS'||l_dimension;
296: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
297: l_sickness_days :=round(nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0));
298: -- hr_utility.set_location('l_sickness_days'||l_sickness_days,425);
299:
300: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_SICKNESS_PAY',500);
301: l_defined_balance := 'CBS_SICKNESS_PAY'||l_dimension;
302: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);

Line 300: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_SICKNESS_PAY',500);

296: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
297: l_sickness_days :=round(nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0));
298: -- hr_utility.set_location('l_sickness_days'||l_sickness_days,425);
299:
300: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_SICKNESS_PAY',500);
301: l_defined_balance := 'CBS_SICKNESS_PAY'||l_dimension;
302: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
303: l_sickness_pay:=round(nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0));
304: -- hr_utility.set_location('l_sickness_pay'||l_sickness_pay,425);

Line 304: -- hr_utility.set_location('l_sickness_pay'||l_sickness_pay,425);

300: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_SICKNESS_PAY',500);
301: l_defined_balance := 'CBS_SICKNESS_PAY'||l_dimension;
302: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
303: l_sickness_pay:=round(nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0));
304: -- hr_utility.set_location('l_sickness_pay'||l_sickness_pay,425);
305:
306: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_UNPAID_HOURS',500);
307: l_defined_balance := 'CBS_UNPAID_HOURS'||l_dimension;
308: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);

Line 306: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_UNPAID_HOURS',500);

302: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
303: l_sickness_pay:=round(nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0));
304: -- hr_utility.set_location('l_sickness_pay'||l_sickness_pay,425);
305:
306: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_UNPAID_HOURS',500);
307: l_defined_balance := 'CBS_UNPAID_HOURS'||l_dimension;
308: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
309: l_unpaid_hours :=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
310: -- hr_utility.set_location('l_unpaid_hours'||l_unpaid_hours,425);

Line 310: -- hr_utility.set_location('l_unpaid_hours'||l_unpaid_hours,425);

306: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_UNPAID_HOURS',500);
307: l_defined_balance := 'CBS_UNPAID_HOURS'||l_dimension;
308: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
309: l_unpaid_hours :=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
310: -- hr_utility.set_location('l_unpaid_hours'||l_unpaid_hours,425);
311:
312: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_OVERTIME_HOURS',500);
313: l_defined_balance := 'CBS_OVERTIME_HOURS'||l_dimension;
314: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);

Line 312: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_OVERTIME_HOURS',500);

308: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
309: l_unpaid_hours :=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
310: -- hr_utility.set_location('l_unpaid_hours'||l_unpaid_hours,425);
311:
312: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_OVERTIME_HOURS',500);
313: l_defined_balance := 'CBS_OVERTIME_HOURS'||l_dimension;
314: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
315: l_overtime_hours:=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
316: -- hr_utility.set_location('l_overtime_hours'||l_overtime_hours,425);

Line 316: -- hr_utility.set_location('l_overtime_hours'||l_overtime_hours,425);

312: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_OVERTIME_HOURS',500);
313: l_defined_balance := 'CBS_OVERTIME_HOURS'||l_dimension;
314: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
315: l_overtime_hours:=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
316: -- hr_utility.set_location('l_overtime_hours'||l_overtime_hours,425);
317:
318: l_si_wage :=round(NVL(l_si_std_tax,0)+NVL(l_si_spl_tax,0)+NVL(l_ret_si_std_tax,0)+ NVL(l_ret_si_spl_tax,0));
319: l_pre_tax_deductions := round(NVL(l_pre_si_pre_tax_ded,0)- NVL(l_pre_tax_only_ded,0));
320:

Line 322: -- hr_utility.set_location('Exited get_balances1',425);

318: l_si_wage :=round(NVL(l_si_std_tax,0)+NVL(l_si_spl_tax,0)+NVL(l_ret_si_std_tax,0)+ NVL(l_ret_si_spl_tax,0));
319: l_pre_tax_deductions := round(NVL(l_pre_si_pre_tax_ded,0)- NVL(l_pre_tax_only_ded,0));
320:
321: return 1;
322: -- hr_utility.set_location('Exited get_balances1',425);
323:
324: end get_balances1;
325:
326: /*******************************************************************************

Line 362: -- hr_utility.set_location('Exited get_balances2',425);

358: l_defined_balance_id NUMBER;
359:
360:
361: begin
362: -- hr_utility.set_location('Exited get_balances2',425);
363:
364: if p_frequency = 'K' then
365: l_dimension := '_ASG_PTD';
366: else

Line 381: -- hr_utility.set_location('l_wage_agreed_by_contract'||l_wage_agreed_by_contract,425);

377:
378: l_defined_balance := 'CBS_CONTRACT_WAGE'||l_dimension;
379: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
380: l_wage_agreed_by_contract :=round(nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0));
381: -- hr_utility.set_location('l_wage_agreed_by_contract'||l_wage_agreed_by_contract,425);
382:
383: if ( l_context_id is not null and l_context_value is not null ) then
384: if (p_frequency = 'M') then
385: -- hr_utility.set_location('Fetching Defined Balance ID for REAL_SOCIAL_INSURANCE_DAYS_ASG_SIT_MONTH',500);

Line 385: -- hr_utility.set_location('Fetching Defined Balance ID for REAL_SOCIAL_INSURANCE_DAYS_ASG_SIT_MONTH',500);

381: -- hr_utility.set_location('l_wage_agreed_by_contract'||l_wage_agreed_by_contract,425);
382:
383: if ( l_context_id is not null and l_context_value is not null ) then
384: if (p_frequency = 'M') then
385: -- hr_utility.set_location('Fetching Defined Balance ID for REAL_SOCIAL_INSURANCE_DAYS_ASG_SIT_MONTH',500);
386: l_defined_balance := 'REAL_SOCIAL_INSURANCE_DAYS_ASG_SIT_MONTH';
387: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
388: l_number_of_days := nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,l_context_value,null,null),0);
389: -- hr_utility.set_location('l_number_of_days'||l_number_of_days,425);

Line 389: -- hr_utility.set_location('l_number_of_days'||l_number_of_days,425);

385: -- hr_utility.set_location('Fetching Defined Balance ID for REAL_SOCIAL_INSURANCE_DAYS_ASG_SIT_MONTH',500);
386: l_defined_balance := 'REAL_SOCIAL_INSURANCE_DAYS_ASG_SIT_MONTH';
387: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
388: l_number_of_days := nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,l_context_value,null,null),0);
389: -- hr_utility.set_location('l_number_of_days'||l_number_of_days,425);
390: else
391: if (p_frequency = 'K') then
392: -- hr_utility.set_location('Fetching Defined Balance ID for REAL_SOCIAL_INSURANCE_DAYS_ASG_SIT_QTD',500);
393: l_defined_balance := 'REAL_SOCIAL_INSURANCE_DAYS_ASG_SIT_QTD';

Line 392: -- hr_utility.set_location('Fetching Defined Balance ID for REAL_SOCIAL_INSURANCE_DAYS_ASG_SIT_QTD',500);

388: l_number_of_days := nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,l_context_value,null,null),0);
389: -- hr_utility.set_location('l_number_of_days'||l_number_of_days,425);
390: else
391: if (p_frequency = 'K') then
392: -- hr_utility.set_location('Fetching Defined Balance ID for REAL_SOCIAL_INSURANCE_DAYS_ASG_SIT_QTD',500);
393: l_defined_balance := 'REAL_SOCIAL_INSURANCE_DAYS_ASG_SIT_QTD';
394: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
395: l_number_of_days := nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,l_context_value,null,null),0);
396: else

Line 397: -- hr_utility.set_location('Fetching Defined Balance ID for REAL_SOCIAL_INSURANCE_DAYS_ASG_SIT_LMONTH',500);

393: l_defined_balance := 'REAL_SOCIAL_INSURANCE_DAYS_ASG_SIT_QTD';
394: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
395: l_number_of_days := nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,l_context_value,null,null),0);
396: else
397: -- hr_utility.set_location('Fetching Defined Balance ID for REAL_SOCIAL_INSURANCE_DAYS_ASG_SIT_LMONTH',500);
398: l_defined_balance := 'REAL_SOCIAL_INSURANCE_DAYS_ASG_SIT_LMONTH';
399: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
400: l_number_of_days := nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,l_context_value,null,null),0);
401: end if;

Line 404: -- hr_utility.set_location('Fetching Defined Balance ID for REAL_SOCIAL_INSURANCE_DAYS_ASG_SIT_QTD',500);

400: l_number_of_days := nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,l_context_value,null,null),0);
401: end if;
402: end if;
403:
404: -- hr_utility.set_location('Fetching Defined Balance ID for REAL_SOCIAL_INSURANCE_DAYS_ASG_SIT_QTD',500);
405: l_defined_balance := 'REAL_SOCIAL_INSURANCE_DAYS_ASG_SIT_QTD';
406: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
407: l_si_days_quarter := nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,l_context_value,null,null),0);
408: -- hr_utility.set_location('l_si_days_quarter'||l_si_days_quarter,425);

Line 408: -- hr_utility.set_location('l_si_days_quarter'||l_si_days_quarter,425);

404: -- hr_utility.set_location('Fetching Defined Balance ID for REAL_SOCIAL_INSURANCE_DAYS_ASG_SIT_QTD',500);
405: l_defined_balance := 'REAL_SOCIAL_INSURANCE_DAYS_ASG_SIT_QTD';
406: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
407: l_si_days_quarter := nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,l_context_value,null,null),0);
408: -- hr_utility.set_location('l_si_days_quarter'||l_si_days_quarter,425);
409: else
410: l_number_of_days := 0;
411: l_si_days_quarter := 0;
412: end if;

Line 414: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_PAID_GROSS_WAGE',500);

410: l_number_of_days := 0;
411: l_si_days_quarter := 0;
412: end if;
413:
414: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_PAID_GROSS_WAGE',500);
415: l_defined_balance := 'CBS_PAID_GROSS_WAGE'||l_dimension;
416: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
417: l_paid_gross_wage :=round(nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0));
418: -- hr_utility.set_location('l_paid_gross_wage'||l_paid_gross_wage,425);

Line 418: -- hr_utility.set_location('l_paid_gross_wage'||l_paid_gross_wage,425);

414: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_PAID_GROSS_WAGE',500);
415: l_defined_balance := 'CBS_PAID_GROSS_WAGE'||l_dimension;
416: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
417: l_paid_gross_wage :=round(nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0));
418: -- hr_utility.set_location('l_paid_gross_wage'||l_paid_gross_wage,425);
419:
420: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_OVERTIME_WAGE',500);
421: l_defined_balance := 'CBS_OVERTIME_WAGE'||l_dimension;
422: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);

Line 420: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_OVERTIME_WAGE',500);

416: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
417: l_paid_gross_wage :=round(nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0));
418: -- hr_utility.set_location('l_paid_gross_wage'||l_paid_gross_wage,425);
419:
420: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_OVERTIME_WAGE',500);
421: l_defined_balance := 'CBS_OVERTIME_WAGE'||l_dimension;
422: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
423: l_wage_for_overtime :=round(nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0));
424: -- hr_utility.set_location('l_wage_for_overtime'||l_wage_for_overtime,425);

Line 424: -- hr_utility.set_location('l_wage_for_overtime'||l_wage_for_overtime,425);

420: -- hr_utility.set_location('Fetching Defined Balance ID for CBS_OVERTIME_WAGE',500);
421: l_defined_balance := 'CBS_OVERTIME_WAGE'||l_dimension;
422: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
423: l_wage_for_overtime :=round(nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0));
424: -- hr_utility.set_location('l_wage_for_overtime'||l_wage_for_overtime,425);
425:
426: return 1;
427: -- hr_utility.set_location('Exited get_balances2',425);
428: end get_balances2;

Line 427: -- hr_utility.set_location('Exited get_balances2',425);

423: l_wage_for_overtime :=round(nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0));
424: -- hr_utility.set_location('l_wage_for_overtime'||l_wage_for_overtime,425);
425:
426: return 1;
427: -- hr_utility.set_location('Exited get_balances2',425);
428: end get_balances2;
429:
430: /*******************************************************************************
431: |Name : Get_health_insurance |

Line 471: -- hr_utility.set_location('Entering Get_health_insurance ',425);

467: l_si_status NUMBER;
468: l_si_provider VARCHAR2(150);
469:
470: BEGIN
471: -- hr_utility.set_location('Entering Get_health_insurance ',425);
472:
473: open csr_get_si_status(p_assignment_id,p_date);
474: -- if csr_get_si_status % found then
475: fetch csr_get_si_status into l_si_status;

Line 479: -- hr_utility.set_location('fETCHED l_si_status '|| l_si_status,425);

475: fetch csr_get_si_status into l_si_status;
476: -- end if;
477: close csr_get_si_status;
478:
479: -- hr_utility.set_location('fETCHED l_si_status '|| l_si_status,425);
480:
481: if l_si_status is not null THEN
482: if l_si_status =4 then
483: open csr_get_iza(p_assignment_id,p_date);

Line 484: -- hr_utility.set_location('opened the cursor '|| l_si_status,425);

480:
481: if l_si_status is not null THEN
482: if l_si_status =4 then
483: open csr_get_iza(p_assignment_id,p_date);
484: -- hr_utility.set_location('opened the cursor '|| l_si_status,425);
485: fetch csr_get_iza into l_si_provider;
486: close csr_get_iza;
487: if l_si_provider is null then
488: -- hr_utility.set_location('entered into if loop '|| l_si_status,425);

Line 488: -- hr_utility.set_location('entered into if loop '|| l_si_status,425);

484: -- hr_utility.set_location('opened the cursor '|| l_si_status,425);
485: fetch csr_get_iza into l_si_provider;
486: close csr_get_iza;
487: if l_si_provider is null then
488: -- hr_utility.set_location('entered into if loop '|| l_si_status,425);
489: open csr_get_phi_information(p_assignment_id,p_date);
490: -- hr_utility.set_location('opened the cursor '|| l_si_status,425);
491: fetch csr_get_phi_information into l_si_provider;
492: -- hr_utility.set_location('fETCHED l_si_provider from org info '|| l_si_status,425);

Line 490: -- hr_utility.set_location('opened the cursor '|| l_si_status,425);

486: close csr_get_iza;
487: if l_si_provider is null then
488: -- hr_utility.set_location('entered into if loop '|| l_si_status,425);
489: open csr_get_phi_information(p_assignment_id,p_date);
490: -- hr_utility.set_location('opened the cursor '|| l_si_status,425);
491: fetch csr_get_phi_information into l_si_provider;
492: -- hr_utility.set_location('fETCHED l_si_provider from org info '|| l_si_status,425);
493: close csr_get_phi_information;
494: end if;

Line 492: -- hr_utility.set_location('fETCHED l_si_provider from org info '|| l_si_status,425);

488: -- hr_utility.set_location('entered into if loop '|| l_si_status,425);
489: open csr_get_phi_information(p_assignment_id,p_date);
490: -- hr_utility.set_location('opened the cursor '|| l_si_status,425);
491: fetch csr_get_phi_information into l_si_provider;
492: -- hr_utility.set_location('fETCHED l_si_provider from org info '|| l_si_status,425);
493: close csr_get_phi_information;
494: end if;
495: else
496: l_si_provider :='1';

Line 498: -- hr_utility.set_location('Leaving Get_health_insurance ',425);

494: end if;
495: else
496: l_si_provider :='1';
497: end if;
498: -- hr_utility.set_location('Leaving Get_health_insurance ',425);
499: return l_si_provider;
500: else
501: return '0';
502: end if;

Line 505: hr_utility.set_location('Exception :' ||'health insurance'||SQLERRM(SQLCODE),999);

501: return '0';
502: end if;
503: EXCEPTION
504: when others then
505: hr_utility.set_location('Exception :' ||'health insurance'||SQLERRM(SQLCODE),999);
506: -- hr_utility.set_location('Leaving Get_health_insurance ',425);
507: end;
508:
509: /*******************************************************************************

Line 506: -- hr_utility.set_location('Leaving Get_health_insurance ',425);

502: end if;
503: EXCEPTION
504: when others then
505: hr_utility.set_location('Exception :' ||'health insurance'||SQLERRM(SQLCODE),999);
506: -- hr_utility.set_location('Leaving Get_health_insurance ',425);
507: end;
508:
509: /*******************************************************************************
510: |Name : Get_working_schedule |

Line 534: -- hr_utility.set_location('Entering Get_working_schedule ',425);

530: l_temp_working_schedule VARCHAR2(10);
531: l_days NUMBER;
532:
533: BEGIN
534: -- hr_utility.set_location('Entering Get_working_schedule ',425);
535:
536: OPEN csr_get_working_schedule;
537: FETCH csr_get_working_schedule into l_temp_working_schedule,l_days;
538: CLOSE csr_get_working_schedule;

Line 549: -- hr_utility.set_location('Exiting Get_working_schedule ',425);

545: Else
546: p_working_schedule := 3;
547: End if;
548: End if;
549: -- hr_utility.set_location('Exiting Get_working_schedule ',425);
550:
551: END get_working_schedule;
552:
553: /********************************************************************************

Line 578: -- hr_utility.set_location('Entering Get_dev_work_hours ',425);

574: l_temp_dev_work_hrs VARCHAR2(100);
575: l_days NUMBER;
576:
577: BEGIN
578: -- hr_utility.set_location('Entering Get_dev_work_hours ',425);
579:
580: OPEN csr_get_dev_work_hrs;
581: FETCH csr_get_dev_work_hrs into l_temp_dev_work_hrs,l_days;
582: CLOSE csr_get_dev_work_hrs;

Line 589: -- hr_utility.set_location('Leaving Get_dev_work_hours ',425);

585: p_dev_work_hours := fnd_number.canonical_to_number(l_temp_dev_work_hrs);
586: else
587: p_dev_work_hours :=0;
588: End if;
589: -- hr_utility.set_location('Leaving Get_dev_work_hours ',425);
590:
591: END Get_dev_work_hours;
592:
593:

Line 620: -- hr_utility.set_location('Entering Get_Employment_Code ',425);

616: l_emp_category VARCHAR2(20);
617: l_days NUMBER;
618:
619: BEGIN
620: -- hr_utility.set_location('Entering Get_Employment_Code ',425);
621:
622: OPEN csr_get_employmetnt_code;
623: FETCH csr_get_employmetnt_code into l_temp_working_schedule,l_emp_category,l_days;
624: CLOSE csr_get_employmetnt_code;

Line 645: -- hr_utility.set_location('leaving Get_Employment_Code ',425);

641: p_employment_code :=0;
642: return 1;
643: End if;
644:
645: -- hr_utility.set_location('leaving Get_Employment_Code ',425);
646:
647: END Get_Employment_Code;
648:
649:

Line 683: -- hr_utility.set_location('--In Get Working Hours ',10);

679:
680:
681: BEGIN
682: --
683: -- hr_utility.set_location('--In Get Working Hours ',10);
684: g_working_hours_formula_name := 'NL_WEEKLY_WORKING_HOURS';
685: IF g_working_hours_formula_exists = TRUE THEN
686: IF g_working_hours_formula_cached = FALSE THEN
687: PAY_NL_GENERAL.cache_formula('NL_WEEKLY_WORKING_HOURS',p_business_group_id,p_reporting_date,l_formula_id,l_formula_exists,l_formula_cached);

Line 716: -- hr_utility.set_location('--In the ELSE Part of get working hours '|| p_assignment_id || p_reporting_date ,10);

712: l_weekly_working_hours := 0;
713: end if;
714: return l_weekly_working_hours;
715: ELSE
716: -- hr_utility.set_location('--In the ELSE Part of get working hours '|| p_assignment_id || p_reporting_date ,10);
717: OPEN csr_get_freq_ind_hours(p_assignment_id,p_reporting_date);
718: fetch csr_get_freq_ind_hours into l_ind_work_hours2,l_frequency;
719: close csr_get_freq_ind_hours;
720: l_ind_work_hours := fnd_number.canonical_to_number(l_ind_work_hours2);

Line 734: -- hr_utility.set_location('--In the ELSE Part of get working hours '|| l_weekly_working_hours,10);

730: if l_weekly_working_hours is null then
731: l_weekly_working_hours := 0;
732: end if;
733: end if;
734: -- hr_utility.set_location('--In the ELSE Part of get working hours '|| l_weekly_working_hours,10);
735: return l_weekly_working_hours;
736: END IF;
737: -- hr_utility.set_location('Leaving Get_CBS_Working_Hours ',425);
738:

Line 737: -- hr_utility.set_location('Leaving Get_CBS_Working_Hours ',425);

733: end if;
734: -- hr_utility.set_location('--In the ELSE Part of get working hours '|| l_weekly_working_hours,10);
735: return l_weekly_working_hours;
736: END IF;
737: -- hr_utility.set_location('Leaving Get_CBS_Working_Hours ',425);
738:
739: EXCEPTION
740: when others then
741: hr_utility.set_location('Exception :' ||'cbs working hours'||SQLERRM(SQLCODE),999);

Line 741: hr_utility.set_location('Exception :' ||'cbs working hours'||SQLERRM(SQLCODE),999);

737: -- hr_utility.set_location('Leaving Get_CBS_Working_Hours ',425);
738:
739: EXCEPTION
740: when others then
741: hr_utility.set_location('Exception :' ||'cbs working hours'||SQLERRM(SQLCODE),999);
742: End Get_CBS_Working_Hours;
743:
744: /*******************************************************************************
745: |Name : GET_CAO_CODE |

Line 762: -- hr_utility.set_location('Entering GET_CAO_CODE ',425);

758: l_cao_code VARCHAR2(50);
759:
760: begin
761:
762: -- hr_utility.set_location('Entering GET_CAO_CODE ',425);
763:
764: OPEN csr_get_cao_code(p_assignment_id);
765: FETCH csr_get_cao_code INTO l_cao_code;
766: CLOSE csr_get_cao_code;

Line 769: -- hr_utility.set_location('Leaving GET_CAO_CODE ',425);

765: FETCH csr_get_cao_code INTO l_cao_code;
766: CLOSE csr_get_cao_code;
767: p_cao_code := fnd_number.canonical_to_number(l_cao_code);
768:
769: -- hr_utility.set_location('Leaving GET_CAO_CODE ',425);
770:
771: END GET_CAO_CODE;
772:
773: /********************************************************************************

Line 831: -- hr_utility.set_location('--Entering get_grade_salary_number ',10);

827:
828: Begin
829:
830: -- l_public_sector_org := hr_nl_org_info.Get_Public_Sector_Org(p_org_id);
831: -- hr_utility.set_location('--Entering get_grade_salary_number ',10);
832:
833: if P_public_sector = 'Y' then
834: Open csr_get_grade_number(p_grade_id,p_business_group_id);
835: Fetch csr_get_grade_number into l_grade_number;

Line 864: -- hr_utility.set_location('Leaving get_grade_salary_number ',425);

860: p_grade_number := lpad(to_char(l_grade_number),3,'0');
861: p_salary_number := lpad(to_char(l_salary_number),3,'0');
862:
863: Return 1;
864: -- hr_utility.set_location('Leaving get_grade_salary_number ',425);
865:
866: End get_grade_salary_number;
867:
868:

Line 902: -- hr_utility.set_location('-- Entering Get_tax_details ',10);

898: l_tax_code_input_id NUMBER;
899: l_labour_relation_code_id NUMBER;
900:
901: BEGIN
902: -- hr_utility.set_location('-- Entering Get_tax_details ',10);
903:
904: open csr_get_date_earned(p_max_assgt_act_id);
905: fetch csr_get_date_earned into l_date_earned;
906: close csr_get_date_Earned;

Line 932: -- hr_utility.set_location('-- Leaving Get_tax_details ',10);

928: p_labour_relation_code := '01';
929: end if;
930:
931: return 1;
932: -- hr_utility.set_location('-- Leaving Get_tax_details ',10);
933:
934: end get_tax_details;
935:
936: /********************************************************************************

Line 1032: hr_utility.trace_on(NULL,'CBS');

1028: BEGIN
1029:
1030: g_debug := FALSE ;
1031: if g_debug then
1032: hr_utility.trace_on(NULL,'CBS');
1033: hr_utility.set_location('Entering GET ALL PARAMETERS of Range Code ',600);
1034: end if;
1035:
1036: g_error_flag := hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR');

Line 1033: hr_utility.set_location('Entering GET ALL PARAMETERS of Range Code ',600);

1029:
1030: g_debug := FALSE ;
1031: if g_debug then
1032: hr_utility.trace_on(NULL,'CBS');
1033: hr_utility.set_location('Entering GET ALL PARAMETERS of Range Code ',600);
1034: end if;
1035:
1036: g_error_flag := hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR');
1037:

Line 1048: hr_utility.set_location('exited GET ALL PARAMETERS',600);

1044: P_org_struct_id => l_org_struct_id,
1045: P_medium_code => l_medium_code,
1046: P_density => l_density);
1047:
1048: hr_utility.set_location('exited GET ALL PARAMETERS',600);
1049:
1050: l_return_value := PAY_NL_TAXOFFICE_FILE.GET_TOS_SENDER_DETAILS
1051: (l_Business_Group_Id,
1052: l_Employer,

Line 1058: hr_utility.set_location('Executing Get_SIP_Details',600);

1054: l_Sender_Reg_Number_bg,
1055: l_Wage_Tax_Rep_Name_org,
1056: l_Wage_Tax_Reg_Number_org);
1057:
1058: hr_utility.set_location('Executing Get_SIP_Details',600);
1059:
1060: l_return_value := PAY_NL_ANNUAL_SI_FILE.Get_SIP_Details
1061: ( l_employer
1062: ,l_si_provider

Line 1075: -- hr_utility.set_location('Executing GET BG ADDRESS',600);

1071: (l_employer,
1072: p_contact => l_employer_contact,
1073: p_telephone => l_employer_telephone);
1074:
1075: -- hr_utility.set_location('Executing GET BG ADDRESS',600);
1076:
1077: l_sender_address:=PAY_NL_GENERAL.GET_ORGANIZATION_ADDRESS
1078: (l_business_group_id,
1079: l_business_group_id,

Line 1090: -- hr_utility.set_location('Executing GET ORG ADDRESS',600);

1086: l_sen_city,
1087: l_sen_country,
1088: l_sen_postal_code);
1089:
1090: -- hr_utility.set_location('Executing GET ORG ADDRESS',600);
1091:
1092: l_org_address:=PAY_NL_GENERAL.GET_ORGANIZATION_ADDRESS
1093: (l_employer
1094: ,l_business_group_id

Line 1105: -- hr_utility.set_location('Going to retrieve all the address fields',600);

1101: ,l_city
1102: ,l_country
1103: ,l_postal_code);
1104:
1105: -- hr_utility.set_location('Going to retrieve all the address fields',600);
1106:
1107: l_sender_address_field := l_sen_street_name || l_sen_house_number || l_sen_house_no_add;
1108: l_sen_city_field := l_sen_postal_code || l_sen_city;
1109: l_tax_address_field := l_street_name || l_house_number || l_house_no_add;

Line 1111: -- hr_utility.set_location('Going to retrieve the Data of org struct id,frequency and cust no'||l_reporting_date,600);

1107: l_sender_address_field := l_sen_street_name || l_sen_house_number || l_sen_house_no_add;
1108: l_sen_city_field := l_sen_postal_code || l_sen_city;
1109: l_tax_address_field := l_street_name || l_house_number || l_house_no_add;
1110: l_tax_city_field := l_postal_code || l_city;
1111: -- hr_utility.set_location('Going to retrieve the Data of org struct id,frequency and cust no'||l_reporting_date,600);
1112: l_org_struct_version_id := pay_nl_taxoffice_archive.get_org_hierarchy(l_org_struct_id,l_reporting_date);
1113: l_frequency := hr_nl_org_info.get_reporting_frequency(l_employer);
1114: l_customer_number := hr_nl_org_info.get_customer_number(l_employer);
1115:

Line 1116: -- hr_utility.set_location('Going to perform mandatory check the Data in Range Code',600);

1112: l_org_struct_version_id := pay_nl_taxoffice_archive.get_org_hierarchy(l_org_struct_id,l_reporting_date);
1113: l_frequency := hr_nl_org_info.get_reporting_frequency(l_employer);
1114: l_customer_number := hr_nl_org_info.get_customer_number(l_employer);
1115:
1116: -- hr_utility.set_location('Going to perform mandatory check the Data in Range Code',600);
1117:
1118: Mandatory_Check('PAY_NL_ER_REQUIRED_FIELD','NL_SENDER_NAME', l_Sender_Rep_Name_bg);
1119: Mandatory_Check('PAY_NL_ER_REQUIRED_FIELD','NL_SENDER_ADDR', l_sender_address_field);
1120: Mandatory_Check('PAY_NL_ER_REQUIRED_FIELD','NL_SENDER_CITY', l_sen_city_field);

Line 1135: -- hr_utility.set_location('Fetched the sequence, employer = '||l_employer||'si provider='||l_si_provider,600);

1131:
1132:
1133: IF g_error_count=0 THEN
1134: -- l_return_value := Pay_nl_cbs_file.Get_er_sequence(l_employer,l_si_provider,l_reporting_date,l_sequence);
1135: -- hr_utility.set_location('Fetched the sequence, employer = '||l_employer||'si provider='||l_si_provider,600);
1136: l_sequence :=1;
1137: Pay_Action_information_api.create_action_information(
1138: P_action_information_id => l_action_info_id
1139: ,p_action_context_id => pactid

Line 1150: -- hr_utility.set_location('Completed the Employer Archive',600);

1146: ,p_action_information1 => l_employer
1147: ,p_action_information2 => l_si_provider
1148: ,p_action_information4 => l_sequence);
1149:
1150: -- hr_utility.set_location('Completed the Employer Archive',600);
1151:
1152: -- hr_utility.set_location('Generating the query for assignment actiond ids',600);
1153:
1154: sqlstr := 'SELECT DISTINCT person_id

Line 1152: -- hr_utility.set_location('Generating the query for assignment actiond ids',600);

1148: ,p_action_information4 => l_sequence);
1149:
1150: -- hr_utility.set_location('Completed the Employer Archive',600);
1151:
1152: -- hr_utility.set_location('Generating the query for assignment actiond ids',600);
1153:
1154: sqlstr := 'SELECT DISTINCT person_id
1155: FROM per_people_f ppf
1156: ,pay_payroll_actions ppa

Line 1173: hr_utility.set_location('Leaving Range Code',350);

1169:
1170: Fnd_file.put_line(FND_FILE.LOG,v_log_header);*/
1171:
1172: if g_debug then
1173: hr_utility.set_location('Leaving Range Code',350);
1174: end if;
1175:
1176: ELSE
1177: /*If mandatory data is missing do not return any person ids*/

Line 1186: -- hr_utility.set_location('Exiting Range Code',600);

1182: AND 1 = 2
1183: AND ppa.business_group_id = ppf.business_group_id
1184: ORDER BY ppf.person_id';
1185: END IF;
1186: -- hr_utility.set_location('Exiting Range Code',600);
1187:
1188: END RANGE_CODE;
1189:
1190: /*******************************************************************************|

Line 1204: -- hr_utility.set_location('Entering check_Asg_si_provider funciton ',600);

1200:
1201: l_si_provider_id NUMBER;
1202: BEGIN
1203:
1204: -- hr_utility.set_location('Entering check_Asg_si_provider funciton ',600);
1205:
1206: l_si_provider_id := HR_NL_ORG_INFO.GET_SI_PROVIDER_INFO(p_organization_id,'ZFW',p_assignment_id);
1207: IF ( l_si_provider_id = p_si_provider_id) THEN
1208: RETURN 1;

Line 1232: -- hr_utility.set_location('Exiting check_Asg_si_provider funciton ',600);

1228: RETURN 1;
1229: else
1230: return 0;
1231: end if;
1232: -- hr_utility.set_location('Exiting check_Asg_si_provider funciton ',600);
1233:
1234: end check_Asg_si_provider;
1235:
1236:

Line 1260: -- hr_utility.set_location('Entering chekck_asg_terminate funciton ',600);

1256: l_eff_date Date;
1257:
1258: BEGIN
1259:
1260: -- hr_utility.set_location('Entering chekck_asg_terminate funciton ',600);
1261:
1262: OPEN csr_asg_term ;
1263: fetch csr_asg_term into l_eff_date;
1264: if csr_asg_term % found and l_eff_date = p_rep_date then

Line 1269: -- hr_utility.set_location('Exiting chekck_asg_terminate funciton ',600);

1265: return 1;
1266: else return 0;
1267: end if;
1268: close csr_asg_term;
1269: -- hr_utility.set_location('Exiting chekck_asg_terminate funciton ',600);
1270: end check_asg_terminate;
1271:
1272: /*******************************************************************************|
1273: |Name : ASSIGNMENT_ACTION_CODE |

Line 1417: -- hr_utility.trace_on(NULL,'CBS');

1413: --
1414:
1415: g_debug := FALSE;
1416: if g_debug then
1417: -- hr_utility.trace_on(NULL,'CBS');
1418: hr_utility.set_location('Entering Assignment Action Code',600);
1419: hr_utility.set_location('p_payroll_action_id'||p_payroll_action_id,400);
1420: end if;
1421:

Line 1418: hr_utility.set_location('Entering Assignment Action Code',600);

1414:
1415: g_debug := FALSE;
1416: if g_debug then
1417: -- hr_utility.trace_on(NULL,'CBS');
1418: hr_utility.set_location('Entering Assignment Action Code',600);
1419: hr_utility.set_location('p_payroll_action_id'||p_payroll_action_id,400);
1420: end if;
1421:
1422: g_error_flag := hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR');

Line 1419: hr_utility.set_location('p_payroll_action_id'||p_payroll_action_id,400);

1415: g_debug := FALSE;
1416: if g_debug then
1417: -- hr_utility.trace_on(NULL,'CBS');
1418: hr_utility.set_location('Entering Assignment Action Code',600);
1419: hr_utility.set_location('p_payroll_action_id'||p_payroll_action_id,400);
1420: end if;
1421:
1422: g_error_flag := hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR');
1423:

Line 1436: hr_utility.set_location('Executed the cursor in get all parameters ',425);

1432: P_medium_code => l_medium_code,
1433: P_density => l_density);
1434:
1435: if g_debug then
1436: hr_utility.set_location('Executed the cursor in get all parameters ',425);
1437: hr_utility.set_location('p_reporting_date'||l_reporting_date,425);
1438: hr_utility.set_location('p_employer'||l_employer_id,425);
1439: hr_utility.set_location('p_org_struct_id'||l_org_struct_id,425);
1440: hr_utility.set_location('p_si_provider'||l_si_provider_id,425);

Line 1437: hr_utility.set_location('p_reporting_date'||l_reporting_date,425);

1433: P_density => l_density);
1434:
1435: if g_debug then
1436: hr_utility.set_location('Executed the cursor in get all parameters ',425);
1437: hr_utility.set_location('p_reporting_date'||l_reporting_date,425);
1438: hr_utility.set_location('p_employer'||l_employer_id,425);
1439: hr_utility.set_location('p_org_struct_id'||l_org_struct_id,425);
1440: hr_utility.set_location('p_si_provider'||l_si_provider_id,425);
1441: hr_utility.set_location('p_medium_code'||l_medium_code,425);

Line 1438: hr_utility.set_location('p_employer'||l_employer_id,425);

1434:
1435: if g_debug then
1436: hr_utility.set_location('Executed the cursor in get all parameters ',425);
1437: hr_utility.set_location('p_reporting_date'||l_reporting_date,425);
1438: hr_utility.set_location('p_employer'||l_employer_id,425);
1439: hr_utility.set_location('p_org_struct_id'||l_org_struct_id,425);
1440: hr_utility.set_location('p_si_provider'||l_si_provider_id,425);
1441: hr_utility.set_location('p_medium_code'||l_medium_code,425);
1442: hr_utility.set_location('p_density'||l_density,425);

Line 1439: hr_utility.set_location('p_org_struct_id'||l_org_struct_id,425);

1435: if g_debug then
1436: hr_utility.set_location('Executed the cursor in get all parameters ',425);
1437: hr_utility.set_location('p_reporting_date'||l_reporting_date,425);
1438: hr_utility.set_location('p_employer'||l_employer_id,425);
1439: hr_utility.set_location('p_org_struct_id'||l_org_struct_id,425);
1440: hr_utility.set_location('p_si_provider'||l_si_provider_id,425);
1441: hr_utility.set_location('p_medium_code'||l_medium_code,425);
1442: hr_utility.set_location('p_density'||l_density,425);
1443: hr_utility.set_location('p_effective_date'||l_effective_date,425);

Line 1440: hr_utility.set_location('p_si_provider'||l_si_provider_id,425);

1436: hr_utility.set_location('Executed the cursor in get all parameters ',425);
1437: hr_utility.set_location('p_reporting_date'||l_reporting_date,425);
1438: hr_utility.set_location('p_employer'||l_employer_id,425);
1439: hr_utility.set_location('p_org_struct_id'||l_org_struct_id,425);
1440: hr_utility.set_location('p_si_provider'||l_si_provider_id,425);
1441: hr_utility.set_location('p_medium_code'||l_medium_code,425);
1442: hr_utility.set_location('p_density'||l_density,425);
1443: hr_utility.set_location('p_effective_date'||l_effective_date,425);
1444: hr_utility.set_location('p_business_group_id'||l_business_group_id,425);

Line 1441: hr_utility.set_location('p_medium_code'||l_medium_code,425);

1437: hr_utility.set_location('p_reporting_date'||l_reporting_date,425);
1438: hr_utility.set_location('p_employer'||l_employer_id,425);
1439: hr_utility.set_location('p_org_struct_id'||l_org_struct_id,425);
1440: hr_utility.set_location('p_si_provider'||l_si_provider_id,425);
1441: hr_utility.set_location('p_medium_code'||l_medium_code,425);
1442: hr_utility.set_location('p_density'||l_density,425);
1443: hr_utility.set_location('p_effective_date'||l_effective_date,425);
1444: hr_utility.set_location('p_business_group_id'||l_business_group_id,425);
1445: end if;

Line 1442: hr_utility.set_location('p_density'||l_density,425);

1438: hr_utility.set_location('p_employer'||l_employer_id,425);
1439: hr_utility.set_location('p_org_struct_id'||l_org_struct_id,425);
1440: hr_utility.set_location('p_si_provider'||l_si_provider_id,425);
1441: hr_utility.set_location('p_medium_code'||l_medium_code,425);
1442: hr_utility.set_location('p_density'||l_density,425);
1443: hr_utility.set_location('p_effective_date'||l_effective_date,425);
1444: hr_utility.set_location('p_business_group_id'||l_business_group_id,425);
1445: end if;
1446:

Line 1443: hr_utility.set_location('p_effective_date'||l_effective_date,425);

1439: hr_utility.set_location('p_org_struct_id'||l_org_struct_id,425);
1440: hr_utility.set_location('p_si_provider'||l_si_provider_id,425);
1441: hr_utility.set_location('p_medium_code'||l_medium_code,425);
1442: hr_utility.set_location('p_density'||l_density,425);
1443: hr_utility.set_location('p_effective_date'||l_effective_date,425);
1444: hr_utility.set_location('p_business_group_id'||l_business_group_id,425);
1445: end if;
1446:
1447: l_org_struct_version_id:=pay_nl_taxoffice_archive.get_org_hierarchy(l_org_struct_id,l_reporting_date);

Line 1444: hr_utility.set_location('p_business_group_id'||l_business_group_id,425);

1440: hr_utility.set_location('p_si_provider'||l_si_provider_id,425);
1441: hr_utility.set_location('p_medium_code'||l_medium_code,425);
1442: hr_utility.set_location('p_density'||l_density,425);
1443: hr_utility.set_location('p_effective_date'||l_effective_date,425);
1444: hr_utility.set_location('p_business_group_id'||l_business_group_id,425);
1445: end if;
1446:
1447: l_org_struct_version_id:=pay_nl_taxoffice_archive.get_org_hierarchy(l_org_struct_id,l_reporting_date);
1448: l_frequency := hr_nl_org_info.get_reporting_frequency(l_employer_id);

Line 1450: -- hr_utility.set_location('l_frequency'||l_frequency,425);

1446:
1447: l_org_struct_version_id:=pay_nl_taxoffice_archive.get_org_hierarchy(l_org_struct_id,l_reporting_date);
1448: l_frequency := hr_nl_org_info.get_reporting_frequency(l_employer_id);
1449:
1450: -- hr_utility.set_location('l_frequency'||l_frequency,425);
1451: if l_frequency = 'K' then
1452: l_reporting_start_date := ADD_MONTHS(l_reporting_date,-3);
1453: else
1454: if l_frequency = 'M' then

Line 1463: -- hr_utility.set_location('l_reporting_start_date'||l_reporting_start_date,425);

1459: END IF;
1460: end if;
1461: end if;
1462:
1463: -- hr_utility.set_location('l_reporting_start_date'||l_reporting_start_date,425);
1464: l_reporting_end_date := l_reporting_date;
1465: -- hr_utility.set_location('l_reporting_end_date'||l_reporting_end_date,425);
1466:
1467:

Line 1465: -- hr_utility.set_location('l_reporting_end_date'||l_reporting_end_date,425);

1461: end if;
1462:
1463: -- hr_utility.set_location('l_reporting_start_date'||l_reporting_start_date,425);
1464: l_reporting_end_date := l_reporting_date;
1465: -- hr_utility.set_location('l_reporting_end_date'||l_reporting_end_date,425);
1466:
1467:
1468: FOR csr_process_rec in csr_process_assignments
1469: (l_business_group_id,

Line 1478: -- hr_utility.set_location('l_assignment_id'||l_assignment_id,425);

1474: l_si_provider_id,
1475: l_frequency) LOOP
1476:
1477: l_assignment_id := csr_process_rec.assignment_id;
1478: -- hr_utility.set_location('l_assignment_id'||l_assignment_id,425);
1479: l_person_id := csr_process_rec.person_id;
1480: -- hr_utility.set_location('l_person_id'||l_person_id,425);
1481: l_asg_employer_id := csr_process_rec.organization_id;
1482: -- hr_utility.set_location('l_asg_employer_id'||l_asg_employer_id,425);

Line 1480: -- hr_utility.set_location('l_person_id'||l_person_id,425);

1476:
1477: l_assignment_id := csr_process_rec.assignment_id;
1478: -- hr_utility.set_location('l_assignment_id'||l_assignment_id,425);
1479: l_person_id := csr_process_rec.person_id;
1480: -- hr_utility.set_location('l_person_id'||l_person_id,425);
1481: l_asg_employer_id := csr_process_rec.organization_id;
1482: -- hr_utility.set_location('l_asg_employer_id'||l_asg_employer_id,425);
1483: g_assignment_number:=csr_process_rec.assignment_number;
1484: g_full_name:=csr_process_rec.full_name;

Line 1482: -- hr_utility.set_location('l_asg_employer_id'||l_asg_employer_id,425);

1478: -- hr_utility.set_location('l_assignment_id'||l_assignment_id,425);
1479: l_person_id := csr_process_rec.person_id;
1480: -- hr_utility.set_location('l_person_id'||l_person_id,425);
1481: l_asg_employer_id := csr_process_rec.organization_id;
1482: -- hr_utility.set_location('l_asg_employer_id'||l_asg_employer_id,425);
1483: g_assignment_number:=csr_process_rec.assignment_number;
1484: g_full_name:=csr_process_rec.full_name;
1485: l_soft_coding_keyflex_id := csr_process_rec.soft_coding_keyflex_id;
1486: l_grade_id := csr_process_rec.grade_id;

Line 1490: -- hr_utility.set_location('l_si_provider_check'||l_si_provider_check,500);

1486: l_grade_id := csr_process_rec.grade_id;
1487:
1488: g_error_count := 0;
1489: l_si_provider_check := check_Asg_si_provider(l_asg_employer_id,l_si_provider_id,l_assignment_id);
1490: -- hr_utility.set_location('l_si_provider_check'||l_si_provider_check,500);
1491: -- Fetch maximum assignment action id in the reporting period
1492: l_max_assgt_act_id := pay_nl_taxoffice_archive.get_max_assgt_act_id(l_assignment_id,l_reporting_start_date,l_reporting_end_date);
1493: -- hr_utility.set_location('max assignmentid'||l_max_assgt_act_id,600);
1494:

Line 1493: -- hr_utility.set_location('max assignmentid'||l_max_assgt_act_id,600);

1489: l_si_provider_check := check_Asg_si_provider(l_asg_employer_id,l_si_provider_id,l_assignment_id);
1490: -- hr_utility.set_location('l_si_provider_check'||l_si_provider_check,500);
1491: -- Fetch maximum assignment action id in the reporting period
1492: l_max_assgt_act_id := pay_nl_taxoffice_archive.get_max_assgt_act_id(l_assignment_id,l_reporting_start_date,l_reporting_end_date);
1493: -- hr_utility.set_location('max assignmentid'||l_max_assgt_act_id,600);
1494:
1495: IF (l_si_provider_check = 1 AND l_max_assgt_act_id is not null) THEN
1496: l_number := get_tax_details(l_max_assgt_act_id,l_wage_tax_discount,l_tax_code,l_labour_relation_code);
1497: l_income_code := pay_nl_taxoffice_archive.get_income_code(l_assignment_id,l_reporting_start_date,l_reporting_end_date);

Line 1500: -- hr_utility.set_location('FETCHED HEALTH INSURANCE'||l_health_insurance,400);

1496: l_number := get_tax_details(l_max_assgt_act_id,l_wage_tax_discount,l_tax_code,l_labour_relation_code);
1497: l_income_code := pay_nl_taxoffice_archive.get_income_code(l_assignment_id,l_reporting_start_date,l_reporting_end_date);
1498: l_health_insurance := get_health_insurance(l_assignment_id,l_reporting_date);
1499: --l_work_pattern := get_work_pattern(l_soft_coding_keyflex_id);
1500: -- hr_utility.set_location('FETCHED HEALTH INSURANCE'||l_health_insurance,400);
1501: get_working_schedule(l_assignment_id,l_working_schedule,l_reporting_start_date,l_reporting_end_date);
1502: -- hr_utility.set_location('FETCHED WORKING SCHEDULE',600);
1503: l_asg_term := check_asg_terminate ( l_assignment_id , l_reporting_start_date );
1504: -- hr_utility.set_location('CHECKED ASG TERM'||l_asg_term,600);

Line 1502: -- hr_utility.set_location('FETCHED WORKING SCHEDULE',600);

1498: l_health_insurance := get_health_insurance(l_assignment_id,l_reporting_date);
1499: --l_work_pattern := get_work_pattern(l_soft_coding_keyflex_id);
1500: -- hr_utility.set_location('FETCHED HEALTH INSURANCE'||l_health_insurance,400);
1501: get_working_schedule(l_assignment_id,l_working_schedule,l_reporting_start_date,l_reporting_end_date);
1502: -- hr_utility.set_location('FETCHED WORKING SCHEDULE',600);
1503: l_asg_term := check_asg_terminate ( l_assignment_id , l_reporting_start_date );
1504: -- hr_utility.set_location('CHECKED ASG TERM'||l_asg_term,600);
1505:
1506: if l_asg_term = 1 then

Line 1504: -- hr_utility.set_location('CHECKED ASG TERM'||l_asg_term,600);

1500: -- hr_utility.set_location('FETCHED HEALTH INSURANCE'||l_health_insurance,400);
1501: get_working_schedule(l_assignment_id,l_working_schedule,l_reporting_start_date,l_reporting_end_date);
1502: -- hr_utility.set_location('FETCHED WORKING SCHEDULE',600);
1503: l_asg_term := check_asg_terminate ( l_assignment_id , l_reporting_start_date );
1504: -- hr_utility.set_location('CHECKED ASG TERM'||l_asg_term,600);
1505:
1506: if l_asg_term = 1 then
1507:
1508: l_holiday_hours := 0;

Line 1529: -- hr_utility.set_location('fetched full sickness wage paid'||l_asg_term,600);

1525: if (hr_nl_org_info.Get_Full_Sickness_Wage_Paid (l_employer_id) <> 'Y')
1526: then l_sickness_days := 99;
1527: l_sickness_pay := 9999999;
1528: end if;
1529: -- hr_utility.set_location('fetched full sickness wage paid'||l_asg_term,600);
1530:
1531: else
1532: l_number := get_balances1(l_frequency
1533: ,l_max_assgt_act_id

Line 1546: -- hr_utility.set_location('l_holiday_hours'||l_holiday_hours,600);

1542: ,l_sickness_pay
1543: ,l_overtime_hours );
1544:
1545:
1546: -- hr_utility.set_location('l_holiday_hours'||l_holiday_hours,600);
1547:
1548: l_number := get_balances2(l_frequency
1549: ,l_max_assgt_act_id
1550: ,l_wage_agreed_by_contract

Line 1564: -- hr_utility.set_location('l_wage_agreed_by_contract'||l_wage_agreed_by_contract,600);

1560:
1561: end if;
1562:
1563:
1564: -- hr_utility.set_location('l_wage_agreed_by_contract'||l_wage_agreed_by_contract,600);
1565: get_cao_code(l_assignment_id,l_cao_code,l_reporting_date);
1566: get_dev_work_hours(l_assignment_id,l_deviating_working_hours,l_reporting_start_date,l_reporting_end_date);
1567:
1568: l_number:= get_employment_code(l_assignment_id,l_employment_code,l_reporting_start_date,l_reporting_end_date);

Line 1594: -- hr_utility.set_location('creating asg_act_id'||l_asg_act_id,600);

1590: IF g_error_count = 0 then
1591: IF l_max_assgt_act_id IS NOT NULL THEN
1592: /*Create the Assignment Action for the Assignments */
1593:
1594: -- hr_utility.set_location('creating asg_act_id'||l_asg_act_id,600);
1595:
1596: SELECT pay_assignment_actions_s.NEXTVAL
1597: INTO l_asg_act_id
1598: FROM dual;

Line 1600: -- hr_utility.set_location('new l_asg_act_id'||l_asg_act_id,600);

1596: SELECT pay_assignment_actions_s.NEXTVAL
1597: INTO l_asg_act_id
1598: FROM dual;
1599:
1600: -- hr_utility.set_location('new l_asg_act_id'||l_asg_act_id,600);
1601: --
1602: -- Create the archive assignment action
1603: --
1604: -- hr_utility.set_location('Before Inserting new assignment action id',600);

Line 1604: -- hr_utility.set_location('Before Inserting new assignment action id',600);

1600: -- hr_utility.set_location('new l_asg_act_id'||l_asg_act_id,600);
1601: --
1602: -- Create the archive assignment action
1603: --
1604: -- hr_utility.set_location('Before Inserting new assignment action id',600);
1605:
1606: hr_nonrun_asact.insact(l_asg_act_id,l_Assignment_ID, p_payroll_action_id,p_chunk,NULL);
1607: -- hr_utility.set_location('Inserted new assignment action id',600);
1608: end if;

Line 1607: -- hr_utility.set_location('Inserted new assignment action id',600);

1603: --
1604: -- hr_utility.set_location('Before Inserting new assignment action id',600);
1605:
1606: hr_nonrun_asact.insact(l_asg_act_id,l_Assignment_ID, p_payroll_action_id,p_chunk,NULL);
1607: -- hr_utility.set_location('Inserted new assignment action id',600);
1608: end if;
1609:
1610: -- hr_utility.set_location('Going to archive the ee data',600);
1611: pay_action_information_api.create_action_information

Line 1610: -- hr_utility.set_location('Going to archive the ee data',600);

1606: hr_nonrun_asact.insact(l_asg_act_id,l_Assignment_ID, p_payroll_action_id,p_chunk,NULL);
1607: -- hr_utility.set_location('Inserted new assignment action id',600);
1608: end if;
1609:
1610: -- hr_utility.set_location('Going to archive the ee data',600);
1611: pay_action_information_api.create_action_information
1612: ( p_action_information_id => l_action_info_id
1613: ,p_action_context_id => l_asg_act_id
1614: ,p_action_context_type => 'AAP'

Line 1644: -- hr_utility.set_location('Finished the archival process',600);

1640: ,p_action_information21 => l_sickness_pay
1641: ,p_action_information22 => l_sickness_days
1642: ,p_action_information23 => l_si_days_quarter
1643: );
1644: -- hr_utility.set_location('Finished the archival process',600);
1645: END IF;
1646: END IF;
1647: END LOOP;
1648: END ASSIGNMENT_ACTION_CODE;

Line 1661: hr_utility.trace_on(NULL,'CBS');

1657: Procedure ARCHIVE_INIT(p_payroll_action_id IN NUMBER) IS
1658: l_dummy number;
1659: BEGIN
1660: if g_debug then
1661: hr_utility.trace_on(NULL,'CBS');
1662: hr_utility.set_location('Entering ARCHIVE_INIT ',600);
1663: end if;
1664:
1665: END ARCHIVE_INIT;

Line 1662: hr_utility.set_location('Entering ARCHIVE_INIT ',600);

1658: l_dummy number;
1659: BEGIN
1660: if g_debug then
1661: hr_utility.trace_on(NULL,'CBS');
1662: hr_utility.set_location('Entering ARCHIVE_INIT ',600);
1663: end if;
1664:
1665: END ARCHIVE_INIT;
1666:

Line 1680: hr_utility.trace_on(NULL,'CBS');

1676: l_dummy number;
1677: BEGIN
1678:
1679: if g_debug then
1680: hr_utility.trace_on(NULL,'CBS');
1681: hr_utility.set_location('Entering ARCHIVE_INIT ',600);
1682: end if;
1683:
1684: END ARCHIVE_CODE;

Line 1681: hr_utility.set_location('Entering ARCHIVE_INIT ',600);

1677: BEGIN
1678:
1679: if g_debug then
1680: hr_utility.trace_on(NULL,'CBS');
1681: hr_utility.set_location('Entering ARCHIVE_INIT ',600);
1682: end if;
1683:
1684: END ARCHIVE_CODE;
1685: end PAY_NL_CBS_FILE;