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_ANNUAL_SI_FILE dependencies on HR_UTILITY

Line 30: hr_utility.set_location('Checking Field '||p_field,425);

26: v_employee_dat VARCHAR2(255);
27: v_label_desc hr_lookups.meaning%TYPE;
28: Begin
29: if g_debug then
30: hr_utility.set_location('Checking Field '||p_field,425);
31: end if;
32:
33: If p_value is null then
34: v_label_desc := hr_general.decode_lookup('HR_NL_REPORT_LABELS', p_field);

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

38: ||' '||RPAD(SUBSTR(g_error_flag,1,15),15);
39: g_error_count := NVL(g_error_count,0) +1;
40:
41: if p_message_name <> g_message_name then
42: hr_utility.set_message(801,p_message_name);
43: v_message_text := rpad(fnd_message.get,255,' ');
44: FND_FILE.PUT_LINE(FND_FILE.LOG,v_message_text);
45: g_message_name := p_message_name;
46: end if;

Line 72: hr_utility.set_location('Entering get_wage',800);

68: l_si_wage number;
69:
70: BEGIN
71: if g_debug then
72: hr_utility.set_location('Entering get_wage',800);
73: end if;
74:
75: l_sum_of_balances:=0;
76:

Line 79: --hr_utility.trace('L_DEFINED_BALANCE_ID'||l_defined_balance_id);

75: l_sum_of_balances:=0;
76:
77:
78: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('SI_INCOME_STANDARD_TAX_ASG_YTD');
79: --hr_utility.trace('L_DEFINED_BALANCE_ID'||l_defined_balance_id);
80: --hr_utility.trace('ASSIGNMENT_ACTION_ID'||p_assgt_act_id);
81: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
82: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
83:

Line 80: --hr_utility.trace('ASSIGNMENT_ACTION_ID'||p_assgt_act_id);

76:
77:
78: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('SI_INCOME_STANDARD_TAX_ASG_YTD');
79: --hr_utility.trace('L_DEFINED_BALANCE_ID'||l_defined_balance_id);
80: --hr_utility.trace('ASSIGNMENT_ACTION_ID'||p_assgt_act_id);
81: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
82: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
83:
84: if g_debug then

Line 85: hr_utility.set_location('SI_INCOME_STANDARD_TAX_ASG_YTD',425);

81: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
82: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
83:
84: if g_debug then
85: hr_utility.set_location('SI_INCOME_STANDARD_TAX_ASG_YTD',425);
86: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
87: hr_utility.set_location('l_balance_value'||l_balance_value,425);
88: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
89: end if;

Line 86: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);

82: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
83:
84: if g_debug then
85: hr_utility.set_location('SI_INCOME_STANDARD_TAX_ASG_YTD',425);
86: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
87: hr_utility.set_location('l_balance_value'||l_balance_value,425);
88: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
89: end if;
90:

Line 87: hr_utility.set_location('l_balance_value'||l_balance_value,425);

83:
84: if g_debug then
85: hr_utility.set_location('SI_INCOME_STANDARD_TAX_ASG_YTD',425);
86: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
87: hr_utility.set_location('l_balance_value'||l_balance_value,425);
88: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
89: end if;
90:
91: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('SI_INCOME_SPECIAL_TAX_ASG_YTD');

Line 88: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);

84: if g_debug then
85: hr_utility.set_location('SI_INCOME_STANDARD_TAX_ASG_YTD',425);
86: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
87: hr_utility.set_location('l_balance_value'||l_balance_value,425);
88: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
89: end if;
90:
91: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('SI_INCOME_SPECIAL_TAX_ASG_YTD');
92: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

Line 96: hr_utility.set_location('SI_INCOME_SPECIAL_TAX_ASG_YTD',425);

92: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
93: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
94:
95: if g_debug then
96: hr_utility.set_location('SI_INCOME_SPECIAL_TAX_ASG_YTD',425);
97: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
98: hr_utility.set_location('l_balance_value'||l_balance_value,425);
99: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
100: end if;

Line 97: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);

93: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
94:
95: if g_debug then
96: hr_utility.set_location('SI_INCOME_SPECIAL_TAX_ASG_YTD',425);
97: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
98: hr_utility.set_location('l_balance_value'||l_balance_value,425);
99: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
100: end if;
101:

Line 98: hr_utility.set_location('l_balance_value'||l_balance_value,425);

94:
95: if g_debug then
96: hr_utility.set_location('SI_INCOME_SPECIAL_TAX_ASG_YTD',425);
97: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
98: hr_utility.set_location('l_balance_value'||l_balance_value,425);
99: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
100: end if;
101:
102: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_SI_INCOME_STANDARD_TAX_ASG_YTD');

Line 99: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);

95: if g_debug then
96: hr_utility.set_location('SI_INCOME_SPECIAL_TAX_ASG_YTD',425);
97: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
98: hr_utility.set_location('l_balance_value'||l_balance_value,425);
99: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
100: end if;
101:
102: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_SI_INCOME_STANDARD_TAX_ASG_YTD');
103: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

Line 107: hr_utility.set_location('WAGE_IN_MONEY_STANDARD_TAX_ONLY_ASG_YTD',425);

103: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
104: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
105:
106: if g_debug then
107: hr_utility.set_location('WAGE_IN_MONEY_STANDARD_TAX_ONLY_ASG_YTD',425);
108: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
109: hr_utility.set_location('l_balance_value'||l_balance_value,425);
110: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
111: end if;

Line 108: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);

104: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
105:
106: if g_debug then
107: hr_utility.set_location('WAGE_IN_MONEY_STANDARD_TAX_ONLY_ASG_YTD',425);
108: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
109: hr_utility.set_location('l_balance_value'||l_balance_value,425);
110: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
111: end if;
112:

Line 109: hr_utility.set_location('l_balance_value'||l_balance_value,425);

105:
106: if g_debug then
107: hr_utility.set_location('WAGE_IN_MONEY_STANDARD_TAX_ONLY_ASG_YTD',425);
108: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
109: hr_utility.set_location('l_balance_value'||l_balance_value,425);
110: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
111: end if;
112:
113: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_SI_INCOME_SPECIAL_TAX_ASG_YTD');

Line 110: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);

106: if g_debug then
107: hr_utility.set_location('WAGE_IN_MONEY_STANDARD_TAX_ONLY_ASG_YTD',425);
108: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
109: hr_utility.set_location('l_balance_value'||l_balance_value,425);
110: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
111: end if;
112:
113: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_SI_INCOME_SPECIAL_TAX_ASG_YTD');
114: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

Line 118: hr_utility.set_location('WAGE_IN_MONEY_SPECIAL_TAX_ONLY_ASG_YTD',425);

114: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
115: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
116:
117: if g_debug then
118: hr_utility.set_location('WAGE_IN_MONEY_SPECIAL_TAX_ONLY_ASG_YTD',425);
119: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
120: hr_utility.set_location('l_balance_value'||l_balance_value,425);
121: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
122: end if;

Line 119: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);

115: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
116:
117: if g_debug then
118: hr_utility.set_location('WAGE_IN_MONEY_SPECIAL_TAX_ONLY_ASG_YTD',425);
119: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
120: hr_utility.set_location('l_balance_value'||l_balance_value,425);
121: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
122: end if;
123:

Line 120: hr_utility.set_location('l_balance_value'||l_balance_value,425);

116:
117: if g_debug then
118: hr_utility.set_location('WAGE_IN_MONEY_SPECIAL_TAX_ONLY_ASG_YTD',425);
119: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
120: hr_utility.set_location('l_balance_value'||l_balance_value,425);
121: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
122: end if;
123:
124: l_si_wage:=floor(l_sum_of_balances);

Line 121: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);

117: if g_debug then
118: hr_utility.set_location('WAGE_IN_MONEY_SPECIAL_TAX_ONLY_ASG_YTD',425);
119: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
120: hr_utility.set_location('l_balance_value'||l_balance_value,425);
121: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
122: end if;
123:
124: l_si_wage:=floor(l_sum_of_balances);
125:

Line 146: hr_utility.set_location('Entering get_wage',800);

142: l_si_supplementary_days number;
143:
144: BEGIN
145: if g_debug then
146: hr_utility.set_location('Entering get_wage',800);
147: end if;
148:
149: l_sum_of_balances:=0;
150:

Line 157: hr_utility.set_location('SI_SUPPLEMENTARY_DAYS_ASG_YTD',425);

153: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
154: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
155:
156: if g_debug then
157: hr_utility.set_location('SI_SUPPLEMENTARY_DAYS_ASG_YTD',425);
158: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
159: hr_utility.set_location('l_balance_value'||l_balance_value,425);
160: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
161: end if;

Line 158: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);

154: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
155:
156: if g_debug then
157: hr_utility.set_location('SI_SUPPLEMENTARY_DAYS_ASG_YTD',425);
158: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
159: hr_utility.set_location('l_balance_value'||l_balance_value,425);
160: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
161: end if;
162:

Line 159: hr_utility.set_location('l_balance_value'||l_balance_value,425);

155:
156: if g_debug then
157: hr_utility.set_location('SI_SUPPLEMENTARY_DAYS_ASG_YTD',425);
158: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
159: hr_utility.set_location('l_balance_value'||l_balance_value,425);
160: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
161: end if;
162:
163: l_si_supplementary_days:=l_sum_of_balances;

Line 160: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);

156: if g_debug then
157: hr_utility.set_location('SI_SUPPLEMENTARY_DAYS_ASG_YTD',425);
158: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
159: hr_utility.set_location('l_balance_value'||l_balance_value,425);
160: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
161: end if;
162:
163: l_si_supplementary_days:=l_sum_of_balances;
164:

Line 184: hr_utility.set_location('Entering get_wage',800);

180: l_si_amount_allowance number;
181:
182: BEGIN
183: if g_debug then
184: hr_utility.set_location('Entering get_wage',800);
185: end if;
186:
187: l_sum_of_balances:=0;
188:

Line 195: hr_utility.set_location('SI_AMOUNT_ALLOWANCE_ASG_YTD',425);

191: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
192: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
193:
194: if g_debug then
195: hr_utility.set_location('SI_AMOUNT_ALLOWANCE_ASG_YTD',425);
196: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
197: hr_utility.set_location('l_balance_value'||l_balance_value,425);
198: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
199: end if;

Line 196: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);

192: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
193:
194: if g_debug then
195: hr_utility.set_location('SI_AMOUNT_ALLOWANCE_ASG_YTD',425);
196: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
197: hr_utility.set_location('l_balance_value'||l_balance_value,425);
198: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
199: end if;
200:

Line 197: hr_utility.set_location('l_balance_value'||l_balance_value,425);

193:
194: if g_debug then
195: hr_utility.set_location('SI_AMOUNT_ALLOWANCE_ASG_YTD',425);
196: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
197: hr_utility.set_location('l_balance_value'||l_balance_value,425);
198: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
199: end if;
200:
201: l_si_amount_allowance:=floor(l_sum_of_balances);

Line 198: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);

194: if g_debug then
195: hr_utility.set_location('SI_AMOUNT_ALLOWANCE_ASG_YTD',425);
196: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
197: hr_utility.set_location('l_balance_value'||l_balance_value,425);
198: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
199: end if;
200:
201: l_si_amount_allowance:=floor(l_sum_of_balances);
202:

Line 300: hr_utility.set_location('Entering get_wage',800);

296: l_number_of_days number;
297:
298: BEGIN
299: if g_debug then
300: hr_utility.set_location('Entering get_wage',800);
301: end if;
302:
303: l_sum_of_balances:=0;
304:

Line 324: hr_utility.set_location('SI_AMOUNT_ALLOWANCE_ASG_YTD',425);

320: END IF;
321: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
322:
323: if g_debug then
324: hr_utility.set_location('SI_AMOUNT_ALLOWANCE_ASG_YTD',425);
325: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
326: hr_utility.set_location('l_balance_value'||l_balance_value,425);
327: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
328: end if;

Line 325: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);

321: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
322:
323: if g_debug then
324: hr_utility.set_location('SI_AMOUNT_ALLOWANCE_ASG_YTD',425);
325: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
326: hr_utility.set_location('l_balance_value'||l_balance_value,425);
327: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
328: end if;
329:

Line 326: hr_utility.set_location('l_balance_value'||l_balance_value,425);

322:
323: if g_debug then
324: hr_utility.set_location('SI_AMOUNT_ALLOWANCE_ASG_YTD',425);
325: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
326: hr_utility.set_location('l_balance_value'||l_balance_value,425);
327: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
328: end if;
329:
330: l_number_of_days:=floor(l_sum_of_balances);

Line 327: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);

323: if g_debug then
324: hr_utility.set_location('SI_AMOUNT_ALLOWANCE_ASG_YTD',425);
325: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
326: hr_utility.set_location('l_balance_value'||l_balance_value,425);
327: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
328: end if;
329:
330: l_number_of_days:=floor(l_sum_of_balances);
331:

Line 422: --hr_utility.trace('YEAR'||p_tax_year);

418: p_tax_year,p_employer, p_org_struct_id,p_si_provider_id
419: ,p_effective_date,p_business_group_id;
420: CLOSE csr_parameter_info;
421: --
422: --hr_utility.trace('YEAR'||p_tax_year);
423: --hr_utility.trace('EMPLOYER'||p_employer);
424: --hr_utility.trace('ORG STRUCT'||p_org_struct_id);
425: --hr_utility.trace('EFFECTIVE_DATE'||p_effective_date);
426: --hr_utility.trace('BUSINESS_GROUP'||p_business_group_id);

Line 423: --hr_utility.trace('EMPLOYER'||p_employer);

419: ,p_effective_date,p_business_group_id;
420: CLOSE csr_parameter_info;
421: --
422: --hr_utility.trace('YEAR'||p_tax_year);
423: --hr_utility.trace('EMPLOYER'||p_employer);
424: --hr_utility.trace('ORG STRUCT'||p_org_struct_id);
425: --hr_utility.trace('EFFECTIVE_DATE'||p_effective_date);
426: --hr_utility.trace('BUSINESS_GROUP'||p_business_group_id);
427: END get_all_parameters;

Line 424: --hr_utility.trace('ORG STRUCT'||p_org_struct_id);

420: CLOSE csr_parameter_info;
421: --
422: --hr_utility.trace('YEAR'||p_tax_year);
423: --hr_utility.trace('EMPLOYER'||p_employer);
424: --hr_utility.trace('ORG STRUCT'||p_org_struct_id);
425: --hr_utility.trace('EFFECTIVE_DATE'||p_effective_date);
426: --hr_utility.trace('BUSINESS_GROUP'||p_business_group_id);
427: END get_all_parameters;
428: --

Line 425: --hr_utility.trace('EFFECTIVE_DATE'||p_effective_date);

421: --
422: --hr_utility.trace('YEAR'||p_tax_year);
423: --hr_utility.trace('EMPLOYER'||p_employer);
424: --hr_utility.trace('ORG STRUCT'||p_org_struct_id);
425: --hr_utility.trace('EFFECTIVE_DATE'||p_effective_date);
426: --hr_utility.trace('BUSINESS_GROUP'||p_business_group_id);
427: END get_all_parameters;
428: --
429:

Line 426: --hr_utility.trace('BUSINESS_GROUP'||p_business_group_id);

422: --hr_utility.trace('YEAR'||p_tax_year);
423: --hr_utility.trace('EMPLOYER'||p_employer);
424: --hr_utility.trace('ORG STRUCT'||p_org_struct_id);
425: --hr_utility.trace('EFFECTIVE_DATE'||p_effective_date);
426: --hr_utility.trace('BUSINESS_GROUP'||p_business_group_id);
427: END get_all_parameters;
428: --
429:
430: /*--------------------------------------------------------------------

Line 527: --hr_utility.trace(l_tax_year_start_date);

523: l_org_struct_version_id:=pay_nl_taxoffice_archive.get_org_hierarchy(l_org_struct_id,l_tax_year_end_date);
524: l_ASI_Process_Date := l_tax_year_end_date;
525:
526:
527: --hr_utility.trace(l_tax_year_start_date);
528: --hr_utility.trace(l_tax_year_end_date);
529: --hr_utility.trace(l_ASI_Process_Date);
530:
531: l_return_value := Get_SIP_Details

Line 528: --hr_utility.trace(l_tax_year_end_date);

524: l_ASI_Process_Date := l_tax_year_end_date;
525:
526:
527: --hr_utility.trace(l_tax_year_start_date);
528: --hr_utility.trace(l_tax_year_end_date);
529: --hr_utility.trace(l_ASI_Process_Date);
530:
531: l_return_value := Get_SIP_Details
532: ( l_Employer_ID

Line 529: --hr_utility.trace(l_ASI_Process_Date);

525:
526:
527: --hr_utility.trace(l_tax_year_start_date);
528: --hr_utility.trace(l_tax_year_end_date);
529: --hr_utility.trace(l_ASI_Process_Date);
530:
531: l_return_value := Get_SIP_Details
532: ( l_Employer_ID
533: ,l_SI_PROVIDER_ID

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

583: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','MESSAGE'),1,70),70);
584: Fnd_file.put_line(FND_FILE.LOG,v_log_header);
585:
586: if g_debug then
587: hr_utility.set_location('Leaving Range Code',350);
588: end if;
589:
590:
591: ELSE

Line 731: --hr_utility.trace(l_tax_year_start_date);

727: l_org_struct_version_id:=pay_nl_taxoffice_archive.get_org_hierarchy(l_org_struct_id,l_tax_year_end_date);
728: l_ASI_Process_Date := l_tax_year_end_date;
729:
730:
731: --hr_utility.trace(l_tax_year_start_date);
732: --hr_utility.trace(l_tax_year_end_date);
733: --hr_utility.trace(l_ASI_Process_Date);
734:
735:

Line 732: --hr_utility.trace(l_tax_year_end_date);

728: l_ASI_Process_Date := l_tax_year_end_date;
729:
730:
731: --hr_utility.trace(l_tax_year_start_date);
732: --hr_utility.trace(l_tax_year_end_date);
733: --hr_utility.trace(l_ASI_Process_Date);
734:
735:
736:

Line 733: --hr_utility.trace(l_ASI_Process_Date);

729:
730:
731: --hr_utility.trace(l_tax_year_start_date);
732: --hr_utility.trace(l_tax_year_end_date);
733: --hr_utility.trace(l_ASI_Process_Date);
734:
735:
736:
737: FOR process_rec in csr_process_assignments

Line 767: --hr_utility.trace('ASSIGNMENT_DETAILS'||TO_CHAR(l_assignment_id)||' '||to_char(l_max_assgt_act_id));

763: --
764: hr_nonrun_asact.insact(l_asg_act_id,l_Assignment_ID, p_payroll_action_id,p_chunk,NULL);
765:
766:
767: --hr_utility.trace('ASSIGNMENT_DETAILS'||TO_CHAR(l_assignment_id)||' '||to_char(l_max_assgt_act_id));
768:
769: -- Now Create the locking actions
770: IF l_max_assgt_act_id IS NOT NULL THEN
771: hr_nonrun_asact.insint(l_asg_act_id,l_max_assgt_act_id);

Line 792: --hr_utility.trace('NUMBER OF DAYS'||to_char(l_number_of_days));

788: l_si_supplementary_days := NVL(PAY_NL_ANNUAL_SI_FILE.get_si_supplementary_days(l_max_assgt_act_id),0);
789: l_si_amount_allowance := NVL(PAY_NL_ANNUAL_SI_FILE.get_si_amount_Allowance(l_max_assgt_act_id),0);
790: PAY_NL_ANNUAL_SI_FILE.get_si_special_indicator(l_assignment_id,l_si_special_indicator);
791: l_number_of_days := NVL(PAY_NL_ANNUAL_SI_FILE.get_number_of_days(l_max_assgt_act_id),0);
792: --hr_utility.trace('NUMBER OF DAYS'||to_char(l_number_of_days));
793:
794: pay_action_information_api.create_action_information
795: (
796: p_action_information_id => l_action_info_id

Line 833: hr_utility.set_location('Entering Archive Init',600);

829: Procedure ARCHIVE_INIT(p_payroll_action_id IN NUMBER)IS
830: l_number number;
831: BEGIN
832: if g_debug then
833: hr_utility.set_location('Entering Archive Init',600);
834: hr_utility.set_location('Leaving Archive Init',700);
835: end if;
836:
837: END ARCHIVE_INIT;

Line 834: hr_utility.set_location('Leaving Archive Init',700);

830: l_number number;
831: BEGIN
832: if g_debug then
833: hr_utility.set_location('Entering Archive Init',600);
834: hr_utility.set_location('Leaving Archive Init',700);
835: end if;
836:
837: END ARCHIVE_INIT;
838:

Line 853: hr_utility.set_location('Entering Archive Code',700);

849: l_number number;
850: BEGIN
851: if g_debug then
852:
853: hr_utility.set_location('Entering Archive Code',700);
854: hr_utility.set_location('Leaving Archive Code',700);
855: end if;
856:
857: END ARCHIVE_CODE;

Line 854: hr_utility.set_location('Leaving Archive Code',700);

850: BEGIN
851: if g_debug then
852:
853: hr_utility.set_location('Entering Archive Code',700);
854: hr_utility.set_location('Leaving Archive Code',700);
855: end if;
856:
857: END ARCHIVE_CODE;
858: