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

Line 44: hr_utility.set_location('Entering ' || l_proc,10);

40:
41: l_proc VARCHAR2(120) := g_package || 'setup_balance_table';
42: BEGIN
43:
44: hr_utility.set_location('Entering ' || l_proc,10);
45: hr_utility.set_location('Step ' || l_proc,20);
46:
47: g_balance_name(1).balance_name := 'Regular Earnings';
48: g_balance_name(2).balance_name := 'Irregular Earnings';

Line 45: hr_utility.set_location('Step ' || l_proc,20);

41: l_proc VARCHAR2(120) := g_package || 'setup_balance_table';
42: BEGIN
43:
44: hr_utility.set_location('Entering ' || l_proc,10);
45: hr_utility.set_location('Step ' || l_proc,20);
46:
47: g_balance_name(1).balance_name := 'Regular Earnings';
48: g_balance_name(2).balance_name := 'Irregular Earnings';
49: g_balance_name(3).balance_name := 'Overtime Payments';

Line 81: hr_utility.set_location('Step = ' || l_proc,30);

77:
78: g_balance_name(28).balance_name := 'Annual Leave and Bank Holiday Hours';
79: g_balance_name(29).balance_name := 'Annual Leave and Bank Holiday Days';
80:
81: hr_utility.set_location('Step = ' || l_proc,30);
82:
83: FOR l_index IN 1 .. g_balance_name.COUNT
84: LOOP
85:

Line 87: hr_utility.set_location('l_index = ' || l_index,30);

83: FOR l_index IN 1 .. g_balance_name.COUNT
84: LOOP
85:
86: l_dimension := '_ASG_QTD';
87: hr_utility.set_location('l_index = ' || l_index,30);
88: hr_utility.set_location('balance_name = ' || g_balance_name(l_index).balance_name,30);
89: hr_utility.set_location('l_dimension = ' || l_dimension,30);
90:
91: l_index_id := l_index_id +1;

Line 88: hr_utility.set_location('balance_name = ' || g_balance_name(l_index).balance_name,30);

84: LOOP
85:
86: l_dimension := '_ASG_QTD';
87: hr_utility.set_location('l_index = ' || l_index,30);
88: hr_utility.set_location('balance_name = ' || g_balance_name(l_index).balance_name,30);
89: hr_utility.set_location('l_dimension = ' || l_dimension,30);
90:
91: l_index_id := l_index_id +1;
92: OPEN csr_balance_dimension(g_balance_name(l_index).balance_name,

Line 89: hr_utility.set_location('l_dimension = ' || l_dimension,30);

85:
86: l_dimension := '_ASG_QTD';
87: hr_utility.set_location('l_index = ' || l_index,30);
88: hr_utility.set_location('balance_name = ' || g_balance_name(l_index).balance_name,30);
89: hr_utility.set_location('l_dimension = ' || l_dimension,30);
90:
91: l_index_id := l_index_id +1;
92: OPEN csr_balance_dimension(g_balance_name(l_index).balance_name,
93: l_dimension);

Line 105: hr_utility.set_location('Balance Name = ' || g_def_bal_id(l_index_id).balance_name,30);

101: END IF;
102:
103: CLOSE csr_balance_dimension;
104:
105: hr_utility.set_location('Balance Name = ' || g_def_bal_id(l_index_id).balance_name,30);
106: hr_utility.set_location('defined_balance_id = ' || g_def_bal_id(l_index_id).defined_balance_id,30);
107:
108: END LOOP;
109:

Line 106: hr_utility.set_location('defined_balance_id = ' || g_def_bal_id(l_index_id).defined_balance_id,30);

102:
103: CLOSE csr_balance_dimension;
104:
105: hr_utility.set_location('Balance Name = ' || g_def_bal_id(l_index_id).balance_name,30);
106: hr_utility.set_location('defined_balance_id = ' || g_def_bal_id(l_index_id).defined_balance_id,30);
107:
108: END LOOP;
109:
110: hr_utility.set_location('Step ' || l_proc,50);

Line 110: hr_utility.set_location('Step ' || l_proc,50);

106: hr_utility.set_location('defined_balance_id = ' || g_def_bal_id(l_index_id).defined_balance_id,30);
107:
108: END LOOP;
109:
110: hr_utility.set_location('Step ' || l_proc,50);
111:
112: hr_utility.set_location('Leaving ' || l_proc,60);
113:
114: END setup_balance_table;

Line 112: hr_utility.set_location('Leaving ' || l_proc,60);

108: END LOOP;
109:
110: hr_utility.set_location('Step ' || l_proc,50);
111:
112: hr_utility.set_location('Leaving ' || l_proc,60);
113:
114: END setup_balance_table;
115:
116: -----------------------------------------------------------------------

Line 210: hr_utility.set_location('Entering ' || l_proc, 100);

206:
207:
208: BEGIN
209:
210: hr_utility.set_location('Entering ' || l_proc, 100);
211: hr_utility.set_location('p_token_name ' || TO_CHAR(p_token_name), 110);
212:
213: OPEN csr_parameter_info
214: (

Line 211: hr_utility.set_location('p_token_name ' || TO_CHAR(p_token_name), 110);

207:
208: BEGIN
209:
210: hr_utility.set_location('Entering ' || l_proc, 100);
211: hr_utility.set_location('p_token_name ' || TO_CHAR(p_token_name), 110);
212:
213: OPEN csr_parameter_info
214: (
215: p_payroll_action_id,

Line 221: hr_utility.set_location('l_token_value ' || TO_CHAR(l_token_value), 115);

217: );
218: FETCH csr_parameter_info INTO l_token_value, l_business_group_id;
219: CLOSE csr_parameter_info;
220:
221: hr_utility.set_location('l_token_value ' || TO_CHAR(l_token_value), 115);
222: hr_utility.set_location('l_business_group_id ' || TO_CHAR(l_business_group_id), 120);
223:
224: IF p_token_name = 'BG_ID' THEN
225: p_token_value := l_business_group_id;

Line 222: hr_utility.set_location('l_business_group_id ' || TO_CHAR(l_business_group_id), 120);

218: FETCH csr_parameter_info INTO l_token_value, l_business_group_id;
219: CLOSE csr_parameter_info;
220:
221: hr_utility.set_location('l_token_value ' || TO_CHAR(l_token_value), 115);
222: hr_utility.set_location('l_business_group_id ' || TO_CHAR(l_business_group_id), 120);
223:
224: IF p_token_name = 'BG_ID' THEN
225: p_token_value := l_business_group_id;
226: hr_utility.set_location('p_token_name '||p_token_name,125);

Line 226: hr_utility.set_location('p_token_name '||p_token_name,125);

222: hr_utility.set_location('l_business_group_id ' || TO_CHAR(l_business_group_id), 120);
223:
224: IF p_token_name = 'BG_ID' THEN
225: p_token_value := l_business_group_id;
226: hr_utility.set_location('p_token_name '||p_token_name,125);
227: /*6856473 */
228:
229: ELSIF p_token_name= 'COMMENTS' THEN
230: hr_utility.set_location('comments before replace ' || TO_CHAR(l_token_value), 120);

Line 230: hr_utility.set_location('comments before replace ' || TO_CHAR(l_token_value), 120);

226: hr_utility.set_location('p_token_name '||p_token_name,125);
227: /*6856473 */
228:
229: ELSIF p_token_name= 'COMMENTS' THEN
230: hr_utility.set_location('comments before replace ' || TO_CHAR(l_token_value), 120);
231: OPEN csr_comments
232: (
233: p_payroll_action_id,
234: p_token_name

Line 238: hr_utility.set_location('comments after replace ' || TO_CHAR(l_token_value), 120);

234: p_token_name
235: );
236: FETCH csr_comments INTO l_token_value;
237: CLOSE csr_comments;
238: hr_utility.set_location('comments after replace ' || TO_CHAR(l_token_value), 120);
239: p_token_value := l_token_value;
240: ELSE
241: p_token_value := l_token_value;
242: --7367314

Line 251: hr_utility.set_location('p_token_name '||p_token_name,130);

247: p_token_value := '0' ;
248: END IF;
249: END IF;
250: --7367314
251: hr_utility.set_location('p_token_name '||p_token_name,130);
252: END IF;
253:
254: hr_utility.set_location('Leaving ' || l_proc, 135);
255: --

Line 254: hr_utility.set_location('Leaving ' || l_proc, 135);

250: --7367314
251: hr_utility.set_location('p_token_name '||p_token_name,130);
252: END IF;
253:
254: hr_utility.set_location('Leaving ' || l_proc, 135);
255: --
256: EXCEPTION
257: WHEN others THEN
258: hr_utility.set_location('Leaving' || l_proc,140);

Line 258: hr_utility.set_location('Leaving' || l_proc,140);

254: hr_utility.set_location('Leaving ' || l_proc, 135);
255: --
256: EXCEPTION
257: WHEN others THEN
258: hr_utility.set_location('Leaving' || l_proc,140);
259: p_token_value := NULL;
260: --
261: END get_parameters;
262: -----------------------------------------------------------------------

Line 303: hr_utility.set_location(' Entering PAY_IE_EHECS_REPORT.get_all_parameters ', 200);

299: l_occupational_catg VARCHAR2(50);
300: l_cur_inc_exc_flag_rec cur_inc_exc_flag%rowtype;
301:
302: BEGIN
303: hr_utility.set_location(' Entering PAY_IE_EHECS_REPORT.get_all_parameters ', 200);
304:
305: get_parameters(p_payroll_action_id,'REP_GROUP',p_rep_group);
306: get_parameters(p_payroll_action_id,'PAYROLL',p_payroll_id);
307: get_parameters(p_payroll_action_id,'YEAR',p_year);

Line 318: hr_utility.set_location(' After last get_parameters call ', 210);

314: get_parameters(p_payroll_action_id,'DDATE',p_declare_date);
315: get_parameters(p_payroll_action_id,'ADD_CHANGE',p_change_add);
316: get_parameters(p_payroll_action_id,'COMMENTS',p_comments);
317:
318: hr_utility.set_location(' After last get_parameters call ', 210);
319:
320: IF p_quarter = '1' THEN
321: g_qtr_start_date := to_date('01/01/' || p_year,'DD/MM/RRRR');
322: g_qtr_end_date := to_date('31/03/' || p_year,'DD/MM/RRRR');

Line 334: hr_utility.set_location(' After populating the Quarter dates. ', 220);

330: g_qtr_start_date := to_date('01/10/' || p_year,'DD/MM/RRRR');
331: g_qtr_end_date := to_date('31/12/' || p_year,'DD/MM/RRRR');
332: END IF;
333:
334: hr_utility.set_location(' After populating the Quarter dates. ', 220);
335:
336: OPEN cur_nat_min_wg;
337: FETCH cur_nat_min_wg INTO g_ie_nat_min_wage_rate;
338: CLOSE cur_nat_min_wg;

Line 340: hr_utility.set_location(' After cur_nat_min_wg Cursor ', 230);

336: OPEN cur_nat_min_wg;
337: FETCH cur_nat_min_wg INTO g_ie_nat_min_wage_rate;
338: CLOSE cur_nat_min_wg;
339:
340: hr_utility.set_location(' After cur_nat_min_wg Cursor ', 230);
341: hr_utility.set_location(' g_ie_nat_min_wage_rate '||g_ie_nat_min_wage_rate, 230);
342:
343: OPEN cur_inc_exc_flag;
344: FETCH cur_inc_exc_flag INTO l_cur_inc_exc_flag_rec;

Line 341: hr_utility.set_location(' g_ie_nat_min_wage_rate '||g_ie_nat_min_wage_rate, 230);

337: FETCH cur_nat_min_wg INTO g_ie_nat_min_wage_rate;
338: CLOSE cur_nat_min_wg;
339:
340: hr_utility.set_location(' After cur_nat_min_wg Cursor ', 230);
341: hr_utility.set_location(' g_ie_nat_min_wage_rate '||g_ie_nat_min_wage_rate, 230);
342:
343: OPEN cur_inc_exc_flag;
344: FETCH cur_inc_exc_flag INTO l_cur_inc_exc_flag_rec;
345: CLOSE cur_inc_exc_flag;

Line 349: hr_utility.set_location(' After cur_inc_exc_flag Cursor ', 235);

345: CLOSE cur_inc_exc_flag;
346:
347: g_exc_inc := l_cur_inc_exc_flag_rec.inc_or_exc;
348:
349: hr_utility.set_location(' After cur_inc_exc_flag Cursor ', 235);
350: hr_utility.set_location(' l_cur_inc_exc_flag_rec.inc_or_exc '||l_cur_inc_exc_flag_rec.inc_or_exc, 235);
351: hr_utility.set_location(' p_business_Group_id = '||p_business_Group_id,240);
352: hr_utility.set_location(' REP_GROUP = '||p_rep_group,240);
353: hr_utility.set_location(' PAYROLL = '||p_payroll_id,240);

Line 350: hr_utility.set_location(' l_cur_inc_exc_flag_rec.inc_or_exc '||l_cur_inc_exc_flag_rec.inc_or_exc, 235);

346:
347: g_exc_inc := l_cur_inc_exc_flag_rec.inc_or_exc;
348:
349: hr_utility.set_location(' After cur_inc_exc_flag Cursor ', 235);
350: hr_utility.set_location(' l_cur_inc_exc_flag_rec.inc_or_exc '||l_cur_inc_exc_flag_rec.inc_or_exc, 235);
351: hr_utility.set_location(' p_business_Group_id = '||p_business_Group_id,240);
352: hr_utility.set_location(' REP_GROUP = '||p_rep_group,240);
353: hr_utility.set_location(' PAYROLL = '||p_payroll_id,240);
354: hr_utility.set_location(' YEAR = '||p_year,240);

Line 351: hr_utility.set_location(' p_business_Group_id = '||p_business_Group_id,240);

347: g_exc_inc := l_cur_inc_exc_flag_rec.inc_or_exc;
348:
349: hr_utility.set_location(' After cur_inc_exc_flag Cursor ', 235);
350: hr_utility.set_location(' l_cur_inc_exc_flag_rec.inc_or_exc '||l_cur_inc_exc_flag_rec.inc_or_exc, 235);
351: hr_utility.set_location(' p_business_Group_id = '||p_business_Group_id,240);
352: hr_utility.set_location(' REP_GROUP = '||p_rep_group,240);
353: hr_utility.set_location(' PAYROLL = '||p_payroll_id,240);
354: hr_utility.set_location(' YEAR = '||p_year,240);
355: hr_utility.set_location(' QUARTER = '||p_quarter,240);

Line 352: hr_utility.set_location(' REP_GROUP = '||p_rep_group,240);

348:
349: hr_utility.set_location(' After cur_inc_exc_flag Cursor ', 235);
350: hr_utility.set_location(' l_cur_inc_exc_flag_rec.inc_or_exc '||l_cur_inc_exc_flag_rec.inc_or_exc, 235);
351: hr_utility.set_location(' p_business_Group_id = '||p_business_Group_id,240);
352: hr_utility.set_location(' REP_GROUP = '||p_rep_group,240);
353: hr_utility.set_location(' PAYROLL = '||p_payroll_id,240);
354: hr_utility.set_location(' YEAR = '||p_year,240);
355: hr_utility.set_location(' QUARTER = '||p_quarter,240);
356: hr_utility.set_location(' ASSIGNMENT_SET_ID = '||p_assignment_set_id,240);

Line 353: hr_utility.set_location(' PAYROLL = '||p_payroll_id,240);

349: hr_utility.set_location(' After cur_inc_exc_flag Cursor ', 235);
350: hr_utility.set_location(' l_cur_inc_exc_flag_rec.inc_or_exc '||l_cur_inc_exc_flag_rec.inc_or_exc, 235);
351: hr_utility.set_location(' p_business_Group_id = '||p_business_Group_id,240);
352: hr_utility.set_location(' REP_GROUP = '||p_rep_group,240);
353: hr_utility.set_location(' PAYROLL = '||p_payroll_id,240);
354: hr_utility.set_location(' YEAR = '||p_year,240);
355: hr_utility.set_location(' QUARTER = '||p_quarter,240);
356: hr_utility.set_location(' ASSIGNMENT_SET_ID = '||p_assignment_set_id,240);
357: hr_utility.set_location(' OCCUPATION CATEGORY = '||p_occupational_category,240);

Line 354: hr_utility.set_location(' YEAR = '||p_year,240);

350: hr_utility.set_location(' l_cur_inc_exc_flag_rec.inc_or_exc '||l_cur_inc_exc_flag_rec.inc_or_exc, 235);
351: hr_utility.set_location(' p_business_Group_id = '||p_business_Group_id,240);
352: hr_utility.set_location(' REP_GROUP = '||p_rep_group,240);
353: hr_utility.set_location(' PAYROLL = '||p_payroll_id,240);
354: hr_utility.set_location(' YEAR = '||p_year,240);
355: hr_utility.set_location(' QUARTER = '||p_quarter,240);
356: hr_utility.set_location(' ASSIGNMENT_SET_ID = '||p_assignment_set_id,240);
357: hr_utility.set_location(' OCCUPATION CATEGORY = '||p_occupational_category,240);
358: hr_utility.set_location(' EMPLOYER = '||p_employer_id,240);

Line 355: hr_utility.set_location(' QUARTER = '||p_quarter,240);

351: hr_utility.set_location(' p_business_Group_id = '||p_business_Group_id,240);
352: hr_utility.set_location(' REP_GROUP = '||p_rep_group,240);
353: hr_utility.set_location(' PAYROLL = '||p_payroll_id,240);
354: hr_utility.set_location(' YEAR = '||p_year,240);
355: hr_utility.set_location(' QUARTER = '||p_quarter,240);
356: hr_utility.set_location(' ASSIGNMENT_SET_ID = '||p_assignment_set_id,240);
357: hr_utility.set_location(' OCCUPATION CATEGORY = '||p_occupational_category,240);
358: hr_utility.set_location(' EMPLOYER = '||p_employer_id,240);
359: hr_utility.set_location(' REPORT TYPE = '||p_report_type,240);

Line 356: hr_utility.set_location(' ASSIGNMENT_SET_ID = '||p_assignment_set_id,240);

352: hr_utility.set_location(' REP_GROUP = '||p_rep_group,240);
353: hr_utility.set_location(' PAYROLL = '||p_payroll_id,240);
354: hr_utility.set_location(' YEAR = '||p_year,240);
355: hr_utility.set_location(' QUARTER = '||p_quarter,240);
356: hr_utility.set_location(' ASSIGNMENT_SET_ID = '||p_assignment_set_id,240);
357: hr_utility.set_location(' OCCUPATION CATEGORY = '||p_occupational_category,240);
358: hr_utility.set_location(' EMPLOYER = '||p_employer_id,240);
359: hr_utility.set_location(' REPORT TYPE = '||p_report_type,240);
360: hr_utility.set_location(' DDATE = '||p_declare_date,240);

Line 357: hr_utility.set_location(' OCCUPATION CATEGORY = '||p_occupational_category,240);

353: hr_utility.set_location(' PAYROLL = '||p_payroll_id,240);
354: hr_utility.set_location(' YEAR = '||p_year,240);
355: hr_utility.set_location(' QUARTER = '||p_quarter,240);
356: hr_utility.set_location(' ASSIGNMENT_SET_ID = '||p_assignment_set_id,240);
357: hr_utility.set_location(' OCCUPATION CATEGORY = '||p_occupational_category,240);
358: hr_utility.set_location(' EMPLOYER = '||p_employer_id,240);
359: hr_utility.set_location(' REPORT TYPE = '||p_report_type,240);
360: hr_utility.set_location(' DDATE = '||p_declare_date,240);
361: hr_utility.set_location(' ADD_CHANGE = '||p_change_add,240);

Line 358: hr_utility.set_location(' EMPLOYER = '||p_employer_id,240);

354: hr_utility.set_location(' YEAR = '||p_year,240);
355: hr_utility.set_location(' QUARTER = '||p_quarter,240);
356: hr_utility.set_location(' ASSIGNMENT_SET_ID = '||p_assignment_set_id,240);
357: hr_utility.set_location(' OCCUPATION CATEGORY = '||p_occupational_category,240);
358: hr_utility.set_location(' EMPLOYER = '||p_employer_id,240);
359: hr_utility.set_location(' REPORT TYPE = '||p_report_type,240);
360: hr_utility.set_location(' DDATE = '||p_declare_date,240);
361: hr_utility.set_location(' ADD_CHANGE = '||p_change_add,240);
362: hr_utility.set_location(' COMMENTS = '||p_comments,240);

Line 359: hr_utility.set_location(' REPORT TYPE = '||p_report_type,240);

355: hr_utility.set_location(' QUARTER = '||p_quarter,240);
356: hr_utility.set_location(' ASSIGNMENT_SET_ID = '||p_assignment_set_id,240);
357: hr_utility.set_location(' OCCUPATION CATEGORY = '||p_occupational_category,240);
358: hr_utility.set_location(' EMPLOYER = '||p_employer_id,240);
359: hr_utility.set_location(' REPORT TYPE = '||p_report_type,240);
360: hr_utility.set_location(' DDATE = '||p_declare_date,240);
361: hr_utility.set_location(' ADD_CHANGE = '||p_change_add,240);
362: hr_utility.set_location(' COMMENTS = '||p_comments,240);
363: hr_utility.set_location(' g_qtr_start_date = '||g_qtr_start_date,240);

Line 360: hr_utility.set_location(' DDATE = '||p_declare_date,240);

356: hr_utility.set_location(' ASSIGNMENT_SET_ID = '||p_assignment_set_id,240);
357: hr_utility.set_location(' OCCUPATION CATEGORY = '||p_occupational_category,240);
358: hr_utility.set_location(' EMPLOYER = '||p_employer_id,240);
359: hr_utility.set_location(' REPORT TYPE = '||p_report_type,240);
360: hr_utility.set_location(' DDATE = '||p_declare_date,240);
361: hr_utility.set_location(' ADD_CHANGE = '||p_change_add,240);
362: hr_utility.set_location(' COMMENTS = '||p_comments,240);
363: hr_utility.set_location(' g_qtr_start_date = '||g_qtr_start_date,240);
364: hr_utility.set_location(' g_qtr_end_date = '||g_qtr_end_date,240);

Line 361: hr_utility.set_location(' ADD_CHANGE = '||p_change_add,240);

357: hr_utility.set_location(' OCCUPATION CATEGORY = '||p_occupational_category,240);
358: hr_utility.set_location(' EMPLOYER = '||p_employer_id,240);
359: hr_utility.set_location(' REPORT TYPE = '||p_report_type,240);
360: hr_utility.set_location(' DDATE = '||p_declare_date,240);
361: hr_utility.set_location(' ADD_CHANGE = '||p_change_add,240);
362: hr_utility.set_location(' COMMENTS = '||p_comments,240);
363: hr_utility.set_location(' g_qtr_start_date = '||g_qtr_start_date,240);
364: hr_utility.set_location(' g_qtr_end_date = '||g_qtr_end_date,240);
365:

Line 362: hr_utility.set_location(' COMMENTS = '||p_comments,240);

358: hr_utility.set_location(' EMPLOYER = '||p_employer_id,240);
359: hr_utility.set_location(' REPORT TYPE = '||p_report_type,240);
360: hr_utility.set_location(' DDATE = '||p_declare_date,240);
361: hr_utility.set_location(' ADD_CHANGE = '||p_change_add,240);
362: hr_utility.set_location(' COMMENTS = '||p_comments,240);
363: hr_utility.set_location(' g_qtr_start_date = '||g_qtr_start_date,240);
364: hr_utility.set_location(' g_qtr_end_date = '||g_qtr_end_date,240);
365:
366: IF p_occupational_category IS NOT NULL THEN

Line 363: hr_utility.set_location(' g_qtr_start_date = '||g_qtr_start_date,240);

359: hr_utility.set_location(' REPORT TYPE = '||p_report_type,240);
360: hr_utility.set_location(' DDATE = '||p_declare_date,240);
361: hr_utility.set_location(' ADD_CHANGE = '||p_change_add,240);
362: hr_utility.set_location(' COMMENTS = '||p_comments,240);
363: hr_utility.set_location(' g_qtr_start_date = '||g_qtr_start_date,240);
364: hr_utility.set_location(' g_qtr_end_date = '||g_qtr_end_date,240);
365:
366: IF p_occupational_category IS NOT NULL THEN
367: --g_occupational_category_M_C_P :=

Line 364: hr_utility.set_location(' g_qtr_end_date = '||g_qtr_end_date,240);

360: hr_utility.set_location(' DDATE = '||p_declare_date,240);
361: hr_utility.set_location(' ADD_CHANGE = '||p_change_add,240);
362: hr_utility.set_location(' COMMENTS = '||p_comments,240);
363: hr_utility.set_location(' g_qtr_start_date = '||g_qtr_start_date,240);
364: hr_utility.set_location(' g_qtr_end_date = '||g_qtr_end_date,240);
365:
366: IF p_occupational_category IS NOT NULL THEN
367: --g_occupational_category_M_C_P :=
368: /*NVL(hruserdt.get_table_value(p_business_Group_id,'EHECS_CATG_TAB','MPAP',substr(p_occupational_category,-2,length(p_occupational_category)),g_qtr_start_date),

Line 387: hr_utility.set_location(' g_occupational_category_M_C_P = '||g_occupational_category_M_C_P,245);

383:
384:
385: END IF;
386:
387: hr_utility.set_location(' g_occupational_category_M_C_P = '||g_occupational_category_M_C_P,245);
388:
389: IF p_payroll_id IS NOT NULL THEN
390: g_where_clause :=
391: ' and papf.payroll_id = '||to_char(p_payroll_id);

Line 433: hr_utility.set_location(' Inside get_all_parameters:g_where_clause: '||g_where_clause,250);

429: g_where_clause_asg_set := ' and 1=1 ';
430: END IF;
431:
432:
433: hr_utility.set_location(' Inside get_all_parameters:g_where_clause: '||g_where_clause,250);
434: hr_utility.set_location(' Inside get_all_parameters:g_where_clause1: '||g_where_clause1,260);
435: hr_utility.set_location(' Inside get_all_parameters:g_where_clause1: '||g_where_clause_asg_set,265);
436:
437: hr_utility.set_location(' Leaving: PAY_IE_EHECS_REPORT.get_all_parameters: ', 270);

Line 434: hr_utility.set_location(' Inside get_all_parameters:g_where_clause1: '||g_where_clause1,260);

430: END IF;
431:
432:
433: hr_utility.set_location(' Inside get_all_parameters:g_where_clause: '||g_where_clause,250);
434: hr_utility.set_location(' Inside get_all_parameters:g_where_clause1: '||g_where_clause1,260);
435: hr_utility.set_location(' Inside get_all_parameters:g_where_clause1: '||g_where_clause_asg_set,265);
436:
437: hr_utility.set_location(' Leaving: PAY_IE_EHECS_REPORT.get_all_parameters: ', 270);
438:

Line 435: hr_utility.set_location(' Inside get_all_parameters:g_where_clause1: '||g_where_clause_asg_set,265);

431:
432:
433: hr_utility.set_location(' Inside get_all_parameters:g_where_clause: '||g_where_clause,250);
434: hr_utility.set_location(' Inside get_all_parameters:g_where_clause1: '||g_where_clause1,260);
435: hr_utility.set_location(' Inside get_all_parameters:g_where_clause1: '||g_where_clause_asg_set,265);
436:
437: hr_utility.set_location(' Leaving: PAY_IE_EHECS_REPORT.get_all_parameters: ', 270);
438:
439: EXCEPTION

Line 437: hr_utility.set_location(' Leaving: PAY_IE_EHECS_REPORT.get_all_parameters: ', 270);

433: hr_utility.set_location(' Inside get_all_parameters:g_where_clause: '||g_where_clause,250);
434: hr_utility.set_location(' Inside get_all_parameters:g_where_clause1: '||g_where_clause1,260);
435: hr_utility.set_location(' Inside get_all_parameters:g_where_clause1: '||g_where_clause_asg_set,265);
436:
437: hr_utility.set_location(' Leaving: PAY_IE_EHECS_REPORT.get_all_parameters: ', 270);
438:
439: EXCEPTION
440: WHEN Others THEN
441: hr_utility.set_location(' Leaving: PAY_IE_EHECS_REPORT.get_all_parameters with errors: ', 280);

Line 441: hr_utility.set_location(' Leaving: PAY_IE_EHECS_REPORT.get_all_parameters with errors: ', 280);

437: hr_utility.set_location(' Leaving: PAY_IE_EHECS_REPORT.get_all_parameters: ', 270);
438:
439: EXCEPTION
440: WHEN Others THEN
441: hr_utility.set_location(' Leaving: PAY_IE_EHECS_REPORT.get_all_parameters with errors: ', 280);
442: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1215);
443: END get_all_parameters;
444:
445: -----------------------------------------------------------------------

Line 442: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1215);

438:
439: EXCEPTION
440: WHEN Others THEN
441: hr_utility.set_location(' Leaving: PAY_IE_EHECS_REPORT.get_all_parameters with errors: ', 280);
442: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1215);
443: END get_all_parameters;
444:
445: -----------------------------------------------------------------------
446: -- RANGE_CODE

Line 550: hr_utility.set_location('Entering '||l_procedure_name, 300);

546: BEGIN
547:
548: l_procedure_name := g_package||'range_code';
549:
550: hr_utility.set_location('Entering '||l_procedure_name, 300);
551: hr_utility.set_location('pactid '||TO_CHAR(pactid), 300);
552:
553: sqlstr := ' select distinct p.person_id' ||
554: ' from per_people_f p,' ||

Line 551: hr_utility.set_location('pactid '||TO_CHAR(pactid), 300);

547:
548: l_procedure_name := g_package||'range_code';
549:
550: hr_utility.set_location('Entering '||l_procedure_name, 300);
551: hr_utility.set_location('pactid '||TO_CHAR(pactid), 300);
552:
553: sqlstr := ' select distinct p.person_id' ||
554: ' from per_people_f p,' ||
555: ' pay_payroll_actions pa' ||

Line 567: hr_utility.set_location('After fetching the g_archive_effective_date '||g_archive_effective_date, 310);

563: FETCH csr_archive_effective_date
564: INTO g_archive_effective_date;
565: CLOSE csr_archive_effective_date;
566:
567: hr_utility.set_location('After fetching the g_archive_effective_date '||g_archive_effective_date, 310);
568:
569: get_all_parameters(pactid
570: ,g_rep_group
571: ,g_payroll_id

Line 588: hr_utility.set_location('After fetching the g_archive_effective_date '||g_archive_effective_date, 310);

584: g_quarter := l_quarter;
585: g_occupational_category := l_occupational_category;
586: g_assignment_set_id := l_assignment_set_id;
587:
588: hr_utility.set_location('After fetching the g_archive_effective_date '||g_archive_effective_date, 310);
589:
590: setup_balance_table;
591:
592: hr_utility.set_location('After the call of setup_balance_table in '||l_procedure_name, 320);

Line 592: hr_utility.set_location('After the call of setup_balance_table in '||l_procedure_name, 320);

588: hr_utility.set_location('After fetching the g_archive_effective_date '||g_archive_effective_date, 310);
589:
590: setup_balance_table;
591:
592: hr_utility.set_location('After the call of setup_balance_table in '||l_procedure_name, 320);
593:
594: OPEN csr_employer_details(g_employer_id, g_business_group_id);
595: FETCH csr_employer_details INTO l_employer_details;
596: CLOSE csr_employer_details;

Line 598: hr_utility.set_location('After fetching the csr_employer_details ', 330);

594: OPEN csr_employer_details(g_employer_id, g_business_group_id);
595: FETCH csr_employer_details INTO l_employer_details;
596: CLOSE csr_employer_details;
597:
598: hr_utility.set_location('After fetching the csr_employer_details ', 330);
599:
600: l_org_id := l_employer_details.org_id;
601: l_employer_name := l_employer_details.employer_name;
602: l_addr1 := l_employer_details.addr1;

Line 608: hr_utility.set_location('After fetching the csr_employer_details l_org_id'||l_org_id, 330);

604: l_addr3 := l_employer_details.addr3;
605: l_addr4 := ' ';
606: l_addr5 := ' ';
607:
608: hr_utility.set_location('After fetching the csr_employer_details l_org_id'||l_org_id, 330);
609: hr_utility.set_location('After fetching the csr_employer_details l_employer_name'||l_employer_name, 330);
610: hr_utility.set_location('After fetching the csr_employer_details l_addr1'||l_addr1, 330);
611: hr_utility.set_location('After fetching the csr_employer_details l_addr2'||l_addr2, 330);
612: hr_utility.set_location('After fetching the csr_employer_details l_addr3'||l_addr3, 330);

Line 609: hr_utility.set_location('After fetching the csr_employer_details l_employer_name'||l_employer_name, 330);

605: l_addr4 := ' ';
606: l_addr5 := ' ';
607:
608: hr_utility.set_location('After fetching the csr_employer_details l_org_id'||l_org_id, 330);
609: hr_utility.set_location('After fetching the csr_employer_details l_employer_name'||l_employer_name, 330);
610: hr_utility.set_location('After fetching the csr_employer_details l_addr1'||l_addr1, 330);
611: hr_utility.set_location('After fetching the csr_employer_details l_addr2'||l_addr2, 330);
612: hr_utility.set_location('After fetching the csr_employer_details l_addr3'||l_addr3, 330);
613:

Line 610: hr_utility.set_location('After fetching the csr_employer_details l_addr1'||l_addr1, 330);

606: l_addr5 := ' ';
607:
608: hr_utility.set_location('After fetching the csr_employer_details l_org_id'||l_org_id, 330);
609: hr_utility.set_location('After fetching the csr_employer_details l_employer_name'||l_employer_name, 330);
610: hr_utility.set_location('After fetching the csr_employer_details l_addr1'||l_addr1, 330);
611: hr_utility.set_location('After fetching the csr_employer_details l_addr2'||l_addr2, 330);
612: hr_utility.set_location('After fetching the csr_employer_details l_addr3'||l_addr3, 330);
613:
614: OPEN csr_declarant(g_employer_id, g_business_group_id, l_year, l_quarter);

Line 611: hr_utility.set_location('After fetching the csr_employer_details l_addr2'||l_addr2, 330);

607:
608: hr_utility.set_location('After fetching the csr_employer_details l_org_id'||l_org_id, 330);
609: hr_utility.set_location('After fetching the csr_employer_details l_employer_name'||l_employer_name, 330);
610: hr_utility.set_location('After fetching the csr_employer_details l_addr1'||l_addr1, 330);
611: hr_utility.set_location('After fetching the csr_employer_details l_addr2'||l_addr2, 330);
612: hr_utility.set_location('After fetching the csr_employer_details l_addr3'||l_addr3, 330);
613:
614: OPEN csr_declarant(g_employer_id, g_business_group_id, l_year, l_quarter);
615: FETCH csr_declarant INTO l_declarant;

Line 612: hr_utility.set_location('After fetching the csr_employer_details l_addr3'||l_addr3, 330);

608: hr_utility.set_location('After fetching the csr_employer_details l_org_id'||l_org_id, 330);
609: hr_utility.set_location('After fetching the csr_employer_details l_employer_name'||l_employer_name, 330);
610: hr_utility.set_location('After fetching the csr_employer_details l_addr1'||l_addr1, 330);
611: hr_utility.set_location('After fetching the csr_employer_details l_addr2'||l_addr2, 330);
612: hr_utility.set_location('After fetching the csr_employer_details l_addr3'||l_addr3, 330);
613:
614: OPEN csr_declarant(g_employer_id, g_business_group_id, l_year, l_quarter);
615: FETCH csr_declarant INTO l_declarant;
616: CLOSE csr_declarant;

Line 623: hr_utility.set_location('After fetching the csr_declarant ', 340);

619: l_declarant_position := l_declarant.position; -- bug 6850742
620: l_declarant_phone := l_declarant.phone; -- bug 6850742
621: l_declarant_email_add := l_declarant.email; -- bug 6850742
622:
623: hr_utility.set_location('After fetching the csr_declarant ', 340);
624: hr_utility.set_location('After fetching the l_cbr_no '||l_cbr_no, 340);
625: hr_utility.set_location('After fetching the l_person_id '||l_person_id, 340);
626: hr_utility.set_location('l_declarant_position '||l_declarant_position, 340);
627: hr_utility.set_location('l_declarant_phone '||l_declarant_phone, 340);

Line 624: hr_utility.set_location('After fetching the l_cbr_no '||l_cbr_no, 340);

620: l_declarant_phone := l_declarant.phone; -- bug 6850742
621: l_declarant_email_add := l_declarant.email; -- bug 6850742
622:
623: hr_utility.set_location('After fetching the csr_declarant ', 340);
624: hr_utility.set_location('After fetching the l_cbr_no '||l_cbr_no, 340);
625: hr_utility.set_location('After fetching the l_person_id '||l_person_id, 340);
626: hr_utility.set_location('l_declarant_position '||l_declarant_position, 340);
627: hr_utility.set_location('l_declarant_phone '||l_declarant_phone, 340);
628: hr_utility.set_location('l_declarant_email_add '||l_declarant_email_add, 340);

Line 625: hr_utility.set_location('After fetching the l_person_id '||l_person_id, 340);

621: l_declarant_email_add := l_declarant.email; -- bug 6850742
622:
623: hr_utility.set_location('After fetching the csr_declarant ', 340);
624: hr_utility.set_location('After fetching the l_cbr_no '||l_cbr_no, 340);
625: hr_utility.set_location('After fetching the l_person_id '||l_person_id, 340);
626: hr_utility.set_location('l_declarant_position '||l_declarant_position, 340);
627: hr_utility.set_location('l_declarant_phone '||l_declarant_phone, 340);
628: hr_utility.set_location('l_declarant_email_add '||l_declarant_email_add, 340);
629:

Line 626: hr_utility.set_location('l_declarant_position '||l_declarant_position, 340);

622:
623: hr_utility.set_location('After fetching the csr_declarant ', 340);
624: hr_utility.set_location('After fetching the l_cbr_no '||l_cbr_no, 340);
625: hr_utility.set_location('After fetching the l_person_id '||l_person_id, 340);
626: hr_utility.set_location('l_declarant_position '||l_declarant_position, 340);
627: hr_utility.set_location('l_declarant_phone '||l_declarant_phone, 340);
628: hr_utility.set_location('l_declarant_email_add '||l_declarant_email_add, 340);
629:
630: OPEN csr_declarant_details(l_person_id);

Line 627: hr_utility.set_location('l_declarant_phone '||l_declarant_phone, 340);

623: hr_utility.set_location('After fetching the csr_declarant ', 340);
624: hr_utility.set_location('After fetching the l_cbr_no '||l_cbr_no, 340);
625: hr_utility.set_location('After fetching the l_person_id '||l_person_id, 340);
626: hr_utility.set_location('l_declarant_position '||l_declarant_position, 340);
627: hr_utility.set_location('l_declarant_phone '||l_declarant_phone, 340);
628: hr_utility.set_location('l_declarant_email_add '||l_declarant_email_add, 340);
629:
630: OPEN csr_declarant_details(l_person_id);
631: FETCH csr_declarant_details into l_declarant_details;

Line 628: hr_utility.set_location('l_declarant_email_add '||l_declarant_email_add, 340);

624: hr_utility.set_location('After fetching the l_cbr_no '||l_cbr_no, 340);
625: hr_utility.set_location('After fetching the l_person_id '||l_person_id, 340);
626: hr_utility.set_location('l_declarant_position '||l_declarant_position, 340);
627: hr_utility.set_location('l_declarant_phone '||l_declarant_phone, 340);
628: hr_utility.set_location('l_declarant_email_add '||l_declarant_email_add, 340);
629:
630: OPEN csr_declarant_details(l_person_id);
631: FETCH csr_declarant_details into l_declarant_details;
632: CLOSE csr_declarant_details;

Line 634: hr_utility.set_location('After fetching the csr_declarant_details ', 350);

630: OPEN csr_declarant_details(l_person_id);
631: FETCH csr_declarant_details into l_declarant_details;
632: CLOSE csr_declarant_details;
633:
634: hr_utility.set_location('After fetching the csr_declarant_details ', 350);
635:
636: l_declarant_name := l_declarant_details.declarant_name;
637: /* bug 6850742*/
638: -- l_declarant_phone := l_declarant_details.declarant_phone;

Line 642: hr_utility.set_location('l_declarant_name '||l_declarant_name, 350);

638: -- l_declarant_phone := l_declarant_details.declarant_phone;
639: --l_declarant_email_add := l_declarant_details.declarant_email;
640: -- l_declarant_position := l_declarant_details.declarant_position;
641:
642: hr_utility.set_location('l_declarant_name '||l_declarant_name, 350);
643: --hr_utility.set_location('l_declarant_phone '||l_declarant_phone, 350);
644: --hr_utility.set_location('l_declarant_email_add '||l_declarant_email_add, 350);
645: --hr_utility.set_location('l_declarant_position '||l_declarant_position, 350);
646:

Line 643: --hr_utility.set_location('l_declarant_phone '||l_declarant_phone, 350);

639: --l_declarant_email_add := l_declarant_details.declarant_email;
640: -- l_declarant_position := l_declarant_details.declarant_position;
641:
642: hr_utility.set_location('l_declarant_name '||l_declarant_name, 350);
643: --hr_utility.set_location('l_declarant_phone '||l_declarant_phone, 350);
644: --hr_utility.set_location('l_declarant_email_add '||l_declarant_email_add, 350);
645: --hr_utility.set_location('l_declarant_position '||l_declarant_position, 350);
646:
647: IF l_employer_name IS NULL THEN

Line 644: --hr_utility.set_location('l_declarant_email_add '||l_declarant_email_add, 350);

640: -- l_declarant_position := l_declarant_details.declarant_position;
641:
642: hr_utility.set_location('l_declarant_name '||l_declarant_name, 350);
643: --hr_utility.set_location('l_declarant_phone '||l_declarant_phone, 350);
644: --hr_utility.set_location('l_declarant_email_add '||l_declarant_email_add, 350);
645: --hr_utility.set_location('l_declarant_position '||l_declarant_position, 350);
646:
647: IF l_employer_name IS NULL THEN
648: l_errflag := 'Y';

Line 645: --hr_utility.set_location('l_declarant_position '||l_declarant_position, 350);

641:
642: hr_utility.set_location('l_declarant_name '||l_declarant_name, 350);
643: --hr_utility.set_location('l_declarant_phone '||l_declarant_phone, 350);
644: --hr_utility.set_location('l_declarant_email_add '||l_declarant_email_add, 350);
645: --hr_utility.set_location('l_declarant_position '||l_declarant_position, 350);
646:
647: IF l_employer_name IS NULL THEN
648: l_errflag := 'Y';
649: --Fnd_file.put_line(FND_FILE.LOG,'Employer name is missing. Please enter it first.' );

Line 669: hr_utility.set_location('l_errflag '||l_errflag, 370);

665: --Fnd_file.put_line(FND_FILE.LOG,'Declarant details are missing. Please check for Name, Phone, Email, Position.' );
666: Fnd_file.put_line(FND_FILE.LOG,'You have not entered the declaration contact details. Enter the Name, Phone, Email and Position of the declaration contact.' );
667: END IF;
668:
669: hr_utility.set_location('l_errflag '||l_errflag, 370);
670:
671: IF l_errflag = 'Y' THEN
672: Fnd_file.put_line(FND_FILE.LOG,'Some mandatory data is misssing.' );
673: Raise l_ehecs_exception;

Line 676: hr_utility.set_location('Before entering record for IE_EHECS_HEADER ', 380);

672: Fnd_file.put_line(FND_FILE.LOG,'Some mandatory data is misssing.' );
673: Raise l_ehecs_exception;
674: END IF;
675:
676: hr_utility.set_location('Before entering record for IE_EHECS_HEADER ', 380);
677:
678: pay_action_information_api.create_action_information
679: ( p_action_information_id => l_action_info_id
680: ,p_action_context_id => pactid

Line 710: hr_utility.set_location('After entering record for IE_EHECS_HEADER ', 390);

706: ,p_action_information25 => l_declare_date
707: ,p_action_information26 => l_declarant_position
708: );
709:
710: hr_utility.set_location('After entering record for IE_EHECS_HEADER ', 390);
711:
712: hr_utility.set_location('Leaving '||l_procedure_name, 400);
713:
714: EXCEPTION

Line 712: hr_utility.set_location('Leaving '||l_procedure_name, 400);

708: );
709:
710: hr_utility.set_location('After entering record for IE_EHECS_HEADER ', 390);
711:
712: hr_utility.set_location('Leaving '||l_procedure_name, 400);
713:
714: EXCEPTION
715: WHEN l_ehecs_exception THEN
716: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,410);

Line 716: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,410);

712: hr_utility.set_location('Leaving '||l_procedure_name, 400);
713:
714: EXCEPTION
715: WHEN l_ehecs_exception THEN
716: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,410);
717: error_message := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','EHECS Report errors out. Some mandatory values are missing.');
718: WHEN Others THEN
719: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,410);
720: END range_code;

Line 719: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,410);

715: WHEN l_ehecs_exception THEN
716: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,410);
717: error_message := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','EHECS Report errors out. Some mandatory values are missing.');
718: WHEN Others THEN
719: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,410);
720: END range_code;
721: -----------------------------------------------------------------------
722: -- ASSIGNMENT_ACTION_CODE
723: -----------------------------------------------------------------------

Line 754: hr_utility.set_location('Entering PAY_IE_EHECS_REPORT_PKG.assignment_action_code',500);

750: l_ass_check varchar2(1);
751: l_csr_already_archived pay_element_entry_values_f.screen_entry_value%TYPE := 'N';
752: BEGIN
753:
754: hr_utility.set_location('Entering PAY_IE_EHECS_REPORT_PKG.assignment_action_code',500);
755:
756: -- Get all the parameters
757: /*6978389 */
758: hr_utility.set_location('Before get_all_parameters',501);

Line 758: hr_utility.set_location('Before get_all_parameters',501);

754: hr_utility.set_location('Entering PAY_IE_EHECS_REPORT_PKG.assignment_action_code',500);
755:
756: -- Get all the parameters
757: /*6978389 */
758: hr_utility.set_location('Before get_all_parameters',501);
759: get_all_parameters(pactid
760: ,g_rep_group
761: ,g_payroll_id
762: ,g_year

Line 772: hr_utility.set_location('after get_all_parameters',502);

768: ,g_report_type
769: ,g_declare_date
770: ,g_change_indicator
771: ,g_comments);
772: hr_utility.set_location('after get_all_parameters',502);
773: hr_utility.set_location(' g_qtr_start_date = '||g_qtr_start_date,505);
774: hr_utility.set_location(' g_qtr_end_date = '||g_qtr_end_date,505);
775: hr_utility.set_location(' g_business_group_id = '||g_business_group_id,505);
776: hr_utility.set_location(' g_employer_id = '||g_employer_id,505);

Line 773: hr_utility.set_location(' g_qtr_start_date = '||g_qtr_start_date,505);

769: ,g_declare_date
770: ,g_change_indicator
771: ,g_comments);
772: hr_utility.set_location('after get_all_parameters',502);
773: hr_utility.set_location(' g_qtr_start_date = '||g_qtr_start_date,505);
774: hr_utility.set_location(' g_qtr_end_date = '||g_qtr_end_date,505);
775: hr_utility.set_location(' g_business_group_id = '||g_business_group_id,505);
776: hr_utility.set_location(' g_employer_id = '||g_employer_id,505);
777:

Line 774: hr_utility.set_location(' g_qtr_end_date = '||g_qtr_end_date,505);

770: ,g_change_indicator
771: ,g_comments);
772: hr_utility.set_location('after get_all_parameters',502);
773: hr_utility.set_location(' g_qtr_start_date = '||g_qtr_start_date,505);
774: hr_utility.set_location(' g_qtr_end_date = '||g_qtr_end_date,505);
775: hr_utility.set_location(' g_business_group_id = '||g_business_group_id,505);
776: hr_utility.set_location(' g_employer_id = '||g_employer_id,505);
777:
778: --g_start_date := fnd_date.canonical_to_date(l_start_date);

Line 775: hr_utility.set_location(' g_business_group_id = '||g_business_group_id,505);

771: ,g_comments);
772: hr_utility.set_location('after get_all_parameters',502);
773: hr_utility.set_location(' g_qtr_start_date = '||g_qtr_start_date,505);
774: hr_utility.set_location(' g_qtr_end_date = '||g_qtr_end_date,505);
775: hr_utility.set_location(' g_business_group_id = '||g_business_group_id,505);
776: hr_utility.set_location(' g_employer_id = '||g_employer_id,505);
777:
778: --g_start_date := fnd_date.canonical_to_date(l_start_date);
779: --g_end_date := fnd_date.canonical_to_date(l_end_date);

Line 776: hr_utility.set_location(' g_employer_id = '||g_employer_id,505);

772: hr_utility.set_location('after get_all_parameters',502);
773: hr_utility.set_location(' g_qtr_start_date = '||g_qtr_start_date,505);
774: hr_utility.set_location(' g_qtr_end_date = '||g_qtr_end_date,505);
775: hr_utility.set_location(' g_business_group_id = '||g_business_group_id,505);
776: hr_utility.set_location(' g_employer_id = '||g_employer_id,505);
777:
778: --g_start_date := fnd_date.canonical_to_date(l_start_date);
779: --g_end_date := fnd_date.canonical_to_date(l_end_date);
780:

Line 783: --hr_utility.set_location('after get_all_parameter called',225);

779: --g_end_date := fnd_date.canonical_to_date(l_end_date);
780:
781: -- g_pact_id := pactid;
782:
783: --hr_utility.set_location('after get_all_parameter called',225);
784: --hr_utility.set_location('report start date= '||g_start_date,300);
785:
786: hr_utility.set_location('Before building the dynamic query.',510);
787: /* 6856486 modified the employment_category 's IN condition to a value fetch from USER TABLE EHECS_ASG_CATG_TAB */

Line 784: --hr_utility.set_location('report start date= '||g_start_date,300);

780:
781: -- g_pact_id := pactid;
782:
783: --hr_utility.set_location('after get_all_parameter called',225);
784: --hr_utility.set_location('report start date= '||g_start_date,300);
785:
786: hr_utility.set_location('Before building the dynamic query.',510);
787: /* 6856486 modified the employment_category 's IN condition to a value fetch from USER TABLE EHECS_ASG_CATG_TAB */
788: l_select_str :='select distinct paaf.assignment_id asgid

Line 786: hr_utility.set_location('Before building the dynamic query.',510);

782:
783: --hr_utility.set_location('after get_all_parameter called',225);
784: --hr_utility.set_location('report start date= '||g_start_date,300);
785:
786: hr_utility.set_location('Before building the dynamic query.',510);
787: /* 6856486 modified the employment_category 's IN condition to a value fetch from USER TABLE EHECS_ASG_CATG_TAB */
788: l_select_str :='select distinct paaf.assignment_id asgid
789: from per_all_assignments_f paaf,
790: per_all_people_f ppf,

Line 816: hr_utility.set_location('After building the dynamic query.',520);

812: ||g_where_clause
813: ||g_where_clause_asg_set
814: ||' Order by paaf.assignment_id';
815:
816: hr_utility.set_location('After building the dynamic query.',520);
817:
818: /*6978389 */
819: Fnd_file.put_line(FND_FILE.LOG,'Dynamic Query:'||l_select_str );
820:

Line 823: hr_utility.set_location(' Inside ass action code, inside loop for ref cursor',530);

819: Fnd_file.put_line(FND_FILE.LOG,'Dynamic Query:'||l_select_str );
820:
821: OPEN csr_get_asg FOR l_select_str; -- ref cursor
822: LOOP
823: hr_utility.set_location(' Inside ass action code, inside loop for ref cursor',530);
824: FETCH csr_get_asg INTO l_assg_id;
825: EXIT WHEN csr_get_asg%NOTFOUND;
826: SELECT pay_assignment_actions_s.nextval
827: INTO lockingactid

Line 830: hr_utility.set_location('assignment_action_code, the assignment id finally picked up: '||l_assg_id, 540);

826: SELECT pay_assignment_actions_s.nextval
827: INTO lockingactid
828: FROM dual;
829:
830: hr_utility.set_location('assignment_action_code, the assignment id finally picked up: '||l_assg_id, 540);
831: -- Insert assignment into PAY_ASSIGNMENT_ACTIONS TABLE
832: /* hr_nonrun_asact.insact(lockingactid => lockingactid
833: ,assignid => l_assg_id
834: ,pactid => pactid

Line 840: hr_utility.set_location(' Before hr_nonrun_asact.insact call',550);

836: ,greid => NULL);
837: */
838:
839: -- Insert assignment into PAY_TEMP_OBJECT_ACTION TABLE.
840: hr_utility.set_location(' Before hr_nonrun_asact.insact call',550);
841: hr_nonrun_asact.insact(lockingactid => lockingactid
842: ,assignid => l_assg_id --asgrec.assignment_id --
843: ,object_id => l_assg_id --asgrec.assignment_id --
844: ,pactid => pactid

Line 848: hr_utility.set_location(' After hr_nonrun_asact.insact call',560);

844: ,pactid => pactid
845: ,chunk => chunk
846: ,greid => NULL);
847: --,p_transient_action => TRUE);
848: hr_utility.set_location(' After hr_nonrun_asact.insact call',560);
849:
850: END LOOP;-- ref cursor
851:
852: END assignment_action_code;

Line 870: hr_utility.set_location('Entering: PAY_IE_EHECS_REPORT_PKG.archive_init: ',600);

866: WHERE payroll_action_id = pactid;
867:
868: BEGIN
869:
870: hr_utility.set_location('Entering: PAY_IE_EHECS_REPORT_PKG.archive_init: ',600);
871:
872: OPEN csr_archive_effective_date(p_payroll_action_id);
873: FETCH csr_archive_effective_date
874: INTO g_archive_effective_date;

Line 877: hr_utility.set_location('Before calling get_all_parameters ',610);

873: FETCH csr_archive_effective_date
874: INTO g_archive_effective_date;
875: CLOSE csr_archive_effective_date;
876:
877: hr_utility.set_location('Before calling get_all_parameters ',610);
878:
879: get_all_parameters(p_payroll_action_id
880: ,g_rep_group
881: ,g_payroll_id

Line 893: hr_utility.set_location('After calling get_all_parameters ',620);

889: ,g_declare_date
890: ,g_change_indicator
891: ,g_comments);
892:
893: hr_utility.set_location('After calling get_all_parameters ',620);
894:
895: setup_balance_table;
896:
897: hr_utility.set_location('After calling setup_balance_table ',630);

Line 897: hr_utility.set_location('After calling setup_balance_table ',630);

893: hr_utility.set_location('After calling get_all_parameters ',620);
894:
895: setup_balance_table;
896:
897: hr_utility.set_location('After calling setup_balance_table ',630);
898:
899: hr_utility.set_location(' Leaving PAY_IE_EHECS_REPORT_PKG.archive_init', 640);
900:
901: EXCEPTION

Line 899: hr_utility.set_location(' Leaving PAY_IE_EHECS_REPORT_PKG.archive_init', 640);

895: setup_balance_table;
896:
897: hr_utility.set_location('After calling setup_balance_table ',630);
898:
899: hr_utility.set_location(' Leaving PAY_IE_EHECS_REPORT_PKG.archive_init', 640);
900:
901: EXCEPTION
902: WHEN Others THEN
903: hr_utility.set_location(' Leaving PAY_IE_EHECS_REPORT_PKG.archive_init with errors', 650);

Line 903: hr_utility.set_location(' Leaving PAY_IE_EHECS_REPORT_PKG.archive_init with errors', 650);

899: hr_utility.set_location(' Leaving PAY_IE_EHECS_REPORT_PKG.archive_init', 640);
900:
901: EXCEPTION
902: WHEN Others THEN
903: hr_utility.set_location(' Leaving PAY_IE_EHECS_REPORT_PKG.archive_init with errors', 650);
904: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1211);
905:
906: END archive_init;
907: -----------------------------------------------------------------------

Line 904: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1211);

900:
901: EXCEPTION
902: WHEN Others THEN
903: hr_utility.set_location(' Leaving PAY_IE_EHECS_REPORT_PKG.archive_init with errors', 650);
904: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1211);
905:
906: END archive_init;
907: -----------------------------------------------------------------------
908: -- ARCHIVE_DATA

Line 916: hr_utility.set_location(' Entering PAY_IE_EHECS_REPORT_PKG.ARCHIVE_CODE: ',700);

912: IS
913:
914: BEGIN
915:
916: hr_utility.set_location(' Entering PAY_IE_EHECS_REPORT_PKG.ARCHIVE_CODE: ',700);
917: hr_utility.set_location('g_pact_id '||TO_CHAR(g_pact_id),700);
918: hr_utility.set_location('p_assignment_action_id '||TO_CHAR(p_assactid),700);
919:
920: NUll;

Line 917: hr_utility.set_location('g_pact_id '||TO_CHAR(g_pact_id),700);

913:
914: BEGIN
915:
916: hr_utility.set_location(' Entering PAY_IE_EHECS_REPORT_PKG.ARCHIVE_CODE: ',700);
917: hr_utility.set_location('g_pact_id '||TO_CHAR(g_pact_id),700);
918: hr_utility.set_location('p_assignment_action_id '||TO_CHAR(p_assactid),700);
919:
920: NUll;
921:

Line 918: hr_utility.set_location('p_assignment_action_id '||TO_CHAR(p_assactid),700);

914: BEGIN
915:
916: hr_utility.set_location(' Entering PAY_IE_EHECS_REPORT_PKG.ARCHIVE_CODE: ',700);
917: hr_utility.set_location('g_pact_id '||TO_CHAR(g_pact_id),700);
918: hr_utility.set_location('p_assignment_action_id '||TO_CHAR(p_assactid),700);
919:
920: NUll;
921:
922: hr_utility.set_location(' Leaving PAY_IE_EHECS_REPORT_PKG.ARCHIVE_CODE: ',700);

Line 922: hr_utility.set_location(' Leaving PAY_IE_EHECS_REPORT_PKG.ARCHIVE_CODE: ',700);

918: hr_utility.set_location('p_assignment_action_id '||TO_CHAR(p_assactid),700);
919:
920: NUll;
921:
922: hr_utility.set_location(' Leaving PAY_IE_EHECS_REPORT_PKG.ARCHIVE_CODE: ',700);
923:
924: END archive_data;
925:
926: PROCEDURE ehecs_main_proc(p_business_group_id IN VARCHAR2

Line 1051: hr_utility.set_location(' Entering PAY_IE_EHECS_REPORT_PKG.ehecs_main_proc', 800);

1047: l_al_bal_val number:=0;
1048: --------------------------- Variables which will hold the Balance Values.
1049:
1050: BEGIN
1051: hr_utility.set_location(' Entering PAY_IE_EHECS_REPORT_PKG.ehecs_main_proc', 800);
1052:
1053: /*6856473*/
1054: hr_utility.set_location(' before calling get parameters ', 800);
1055:

Line 1054: hr_utility.set_location(' before calling get parameters ', 800);

1050: BEGIN
1051: hr_utility.set_location(' Entering PAY_IE_EHECS_REPORT_PKG.ehecs_main_proc', 800);
1052:
1053: /*6856473*/
1054: hr_utility.set_location(' before calling get parameters ', 800);
1055:
1056: get_parameters(p_payroll_action_id,'EMPLOYER',l_org_id);
1057: hr_utility.set_location(' before cursor csr_hours_per_day and org_id '||l_org_id, 801);
1058: OPEN csr_hours_per_day(l_org_id,p_business_group_id);

Line 1057: hr_utility.set_location(' before cursor csr_hours_per_day and org_id '||l_org_id, 801);

1053: /*6856473*/
1054: hr_utility.set_location(' before calling get parameters ', 800);
1055:
1056: get_parameters(p_payroll_action_id,'EMPLOYER',l_org_id);
1057: hr_utility.set_location(' before cursor csr_hours_per_day and org_id '||l_org_id, 801);
1058: OPEN csr_hours_per_day(l_org_id,p_business_group_id);
1059: FETCH csr_hours_per_day INTO l_hours_per_day;
1060: CLOSE csr_hours_per_day;
1061:

Line 1062: hr_utility.set_location(' AFTER cursor csr_hours_per_day '||l_hours_per_day, 801);

1058: OPEN csr_hours_per_day(l_org_id,p_business_group_id);
1059: FETCH csr_hours_per_day INTO l_hours_per_day;
1060: CLOSE csr_hours_per_day;
1061:
1062: hr_utility.set_location(' AFTER cursor csr_hours_per_day '||l_hours_per_day, 801);
1063:
1064: hr_utility.set_location(' Before Cursor cur_valid_asg', 810);
1065:
1066: OPEN cur_valid_asg(p_assignment_id, p_person_id);

Line 1064: hr_utility.set_location(' Before Cursor cur_valid_asg', 810);

1060: CLOSE csr_hours_per_day;
1061:
1062: hr_utility.set_location(' AFTER cursor csr_hours_per_day '||l_hours_per_day, 801);
1063:
1064: hr_utility.set_location(' Before Cursor cur_valid_asg', 810);
1065:
1066: OPEN cur_valid_asg(p_assignment_id, p_person_id);
1067: FETCH cur_valid_asg INTO l_valid_asg_rec;
1068: --EXIT WHEN cur_valid_asg%NOTFOUND;

Line 1069: hr_utility.set_location(' Inside Cursor cur_valid_asg', 820);

1065:
1066: OPEN cur_valid_asg(p_assignment_id, p_person_id);
1067: FETCH cur_valid_asg INTO l_valid_asg_rec;
1068: --EXIT WHEN cur_valid_asg%NOTFOUND;
1069: hr_utility.set_location(' Inside Cursor cur_valid_asg', 820);
1070: hr_utility.set_location(' l_valid_asg_rec.assignment_id '||l_valid_asg_rec.assignment_id, 820);
1071: hr_utility.set_location(' l_valid_asg_rec.payroll_id '||l_valid_asg_rec.payroll_id, 820);
1072:
1073: hr_utility.set_location(' Before Cursor cur_valid_asg_act', 830);

Line 1070: hr_utility.set_location(' l_valid_asg_rec.assignment_id '||l_valid_asg_rec.assignment_id, 820);

1066: OPEN cur_valid_asg(p_assignment_id, p_person_id);
1067: FETCH cur_valid_asg INTO l_valid_asg_rec;
1068: --EXIT WHEN cur_valid_asg%NOTFOUND;
1069: hr_utility.set_location(' Inside Cursor cur_valid_asg', 820);
1070: hr_utility.set_location(' l_valid_asg_rec.assignment_id '||l_valid_asg_rec.assignment_id, 820);
1071: hr_utility.set_location(' l_valid_asg_rec.payroll_id '||l_valid_asg_rec.payroll_id, 820);
1072:
1073: hr_utility.set_location(' Before Cursor cur_valid_asg_act', 830);
1074:

Line 1071: hr_utility.set_location(' l_valid_asg_rec.payroll_id '||l_valid_asg_rec.payroll_id, 820);

1067: FETCH cur_valid_asg INTO l_valid_asg_rec;
1068: --EXIT WHEN cur_valid_asg%NOTFOUND;
1069: hr_utility.set_location(' Inside Cursor cur_valid_asg', 820);
1070: hr_utility.set_location(' l_valid_asg_rec.assignment_id '||l_valid_asg_rec.assignment_id, 820);
1071: hr_utility.set_location(' l_valid_asg_rec.payroll_id '||l_valid_asg_rec.payroll_id, 820);
1072:
1073: hr_utility.set_location(' Before Cursor cur_valid_asg_act', 830);
1074:
1075: OPEN cur_valid_asg_act(l_valid_asg_rec.assignment_id, l_valid_asg_rec.payroll_id);

Line 1073: hr_utility.set_location(' Before Cursor cur_valid_asg_act', 830);

1069: hr_utility.set_location(' Inside Cursor cur_valid_asg', 820);
1070: hr_utility.set_location(' l_valid_asg_rec.assignment_id '||l_valid_asg_rec.assignment_id, 820);
1071: hr_utility.set_location(' l_valid_asg_rec.payroll_id '||l_valid_asg_rec.payroll_id, 820);
1072:
1073: hr_utility.set_location(' Before Cursor cur_valid_asg_act', 830);
1074:
1075: OPEN cur_valid_asg_act(l_valid_asg_rec.assignment_id, l_valid_asg_rec.payroll_id);
1076: FETCH cur_valid_asg_act INTO l_valid_asg_act_rec;
1077:

Line 1078: hr_utility.set_location(' Inside Cursor cur_valid_asg_act', 840);

1074:
1075: OPEN cur_valid_asg_act(l_valid_asg_rec.assignment_id, l_valid_asg_rec.payroll_id);
1076: FETCH cur_valid_asg_act INTO l_valid_asg_act_rec;
1077:
1078: hr_utility.set_location(' Inside Cursor cur_valid_asg_act', 840);
1079:
1080: IF cur_valid_asg_act%FOUND THEN
1081: --IF l_valid_asg_act_rec.assignment_action_id IS NOT NULL
1082: --THEN

Line 1087: hr_utility.set_location(' Inside balance Loop ', 850);

1083: FOR bal_index IN 1..g_def_bal_id.COUNT
1084: LOOP
1085: IF g_def_bal_id(bal_index).balance_name = 'Regular Earnings' THEN
1086:
1087: hr_utility.set_location(' Inside balance Loop ', 850);
1088: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1089: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1090:
1091: l_regwg_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

Line 1088: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

1084: LOOP
1085: IF g_def_bal_id(bal_index).balance_name = 'Regular Earnings' THEN
1086:
1087: hr_utility.set_location(' Inside balance Loop ', 850);
1088: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1089: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1090:
1091: l_regwg_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1092: l_valid_asg_act_rec.assignment_action_id,

Line 1089: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);

1085: IF g_def_bal_id(bal_index).balance_name = 'Regular Earnings' THEN
1086:
1087: hr_utility.set_location(' Inside balance Loop ', 850);
1088: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1089: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1090:
1091: l_regwg_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1092: l_valid_asg_act_rec.assignment_action_id,
1093: g_employer_id,

Line 1099: hr_utility.set_location(' l_regwg_bal_val '|| l_regwg_bal_val, 850);

1095: null,
1096: null,
1097: null,
1098: null);
1099: hr_utility.set_location(' l_regwg_bal_val '|| l_regwg_bal_val, 850);
1100: ELSIF g_def_bal_id(bal_index).balance_name = 'Irregular Earnings' THEN
1101:
1102: hr_utility.set_location(' Inside balance Loop ', 850);
1103: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

Line 1102: hr_utility.set_location(' Inside balance Loop ', 850);

1098: null);
1099: hr_utility.set_location(' l_regwg_bal_val '|| l_regwg_bal_val, 850);
1100: ELSIF g_def_bal_id(bal_index).balance_name = 'Irregular Earnings' THEN
1101:
1102: hr_utility.set_location(' Inside balance Loop ', 850);
1103: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1104: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1105:
1106: l_irrb_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

Line 1103: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

1099: hr_utility.set_location(' l_regwg_bal_val '|| l_regwg_bal_val, 850);
1100: ELSIF g_def_bal_id(bal_index).balance_name = 'Irregular Earnings' THEN
1101:
1102: hr_utility.set_location(' Inside balance Loop ', 850);
1103: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1104: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1105:
1106: l_irrb_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1107: l_valid_asg_act_rec.assignment_action_id,

Line 1104: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);

1100: ELSIF g_def_bal_id(bal_index).balance_name = 'Irregular Earnings' THEN
1101:
1102: hr_utility.set_location(' Inside balance Loop ', 850);
1103: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1104: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1105:
1106: l_irrb_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1107: l_valid_asg_act_rec.assignment_action_id,
1108: g_employer_id,

Line 1114: hr_utility.set_location(' l_irrb_bal_val '|| l_irrb_bal_val, 850);

1110: null,
1111: null,
1112: null,
1113: null);
1114: hr_utility.set_location(' l_irrb_bal_val '|| l_irrb_bal_val, 850);
1115: ELSIF g_def_bal_id(bal_index).balance_name = 'Overtime Payments' THEN
1116:
1117: hr_utility.set_location(' Inside balance Loop ', 850);
1118: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

Line 1117: hr_utility.set_location(' Inside balance Loop ', 850);

1113: null);
1114: hr_utility.set_location(' l_irrb_bal_val '|| l_irrb_bal_val, 850);
1115: ELSIF g_def_bal_id(bal_index).balance_name = 'Overtime Payments' THEN
1116:
1117: hr_utility.set_location(' Inside balance Loop ', 850);
1118: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1119: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1120:
1121: l_ovrt_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

Line 1118: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

1114: hr_utility.set_location(' l_irrb_bal_val '|| l_irrb_bal_val, 850);
1115: ELSIF g_def_bal_id(bal_index).balance_name = 'Overtime Payments' THEN
1116:
1117: hr_utility.set_location(' Inside balance Loop ', 850);
1118: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1119: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1120:
1121: l_ovrt_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1122: l_valid_asg_act_rec.assignment_action_id,

Line 1119: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);

1115: ELSIF g_def_bal_id(bal_index).balance_name = 'Overtime Payments' THEN
1116:
1117: hr_utility.set_location(' Inside balance Loop ', 850);
1118: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1119: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1120:
1121: l_ovrt_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1122: l_valid_asg_act_rec.assignment_action_id,
1123: g_employer_id,

Line 1129: hr_utility.set_location(' l_ovrt_bal_val '|| l_ovrt_bal_val, 850);

1125: null,
1126: null,
1127: null,
1128: null);
1129: hr_utility.set_location(' l_ovrt_bal_val '|| l_ovrt_bal_val, 850);
1130: ELSIF g_def_bal_id(bal_index).balance_name = 'Paid Overtime Hours' THEN
1131:
1132: hr_utility.set_location(' Inside balance Loop ', 850);
1133: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

Line 1132: hr_utility.set_location(' Inside balance Loop ', 850);

1128: null);
1129: hr_utility.set_location(' l_ovrt_bal_val '|| l_ovrt_bal_val, 850);
1130: ELSIF g_def_bal_id(bal_index).balance_name = 'Paid Overtime Hours' THEN
1131:
1132: hr_utility.set_location(' Inside balance Loop ', 850);
1133: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1134: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1135:
1136: l_othr_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

Line 1133: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

1129: hr_utility.set_location(' l_ovrt_bal_val '|| l_ovrt_bal_val, 850);
1130: ELSIF g_def_bal_id(bal_index).balance_name = 'Paid Overtime Hours' THEN
1131:
1132: hr_utility.set_location(' Inside balance Loop ', 850);
1133: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1134: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1135:
1136: l_othr_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1137: l_valid_asg_act_rec.assignment_action_id,

Line 1134: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);

1130: ELSIF g_def_bal_id(bal_index).balance_name = 'Paid Overtime Hours' THEN
1131:
1132: hr_utility.set_location(' Inside balance Loop ', 850);
1133: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1134: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1135:
1136: l_othr_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1137: l_valid_asg_act_rec.assignment_action_id,
1138: g_employer_id,

Line 1144: hr_utility.set_location(' l_othr_bal_val '|| l_othr_bal_val, 850);

1140: null,
1141: null,
1142: null,
1143: null);
1144: hr_utility.set_location(' l_othr_bal_val '|| l_othr_bal_val, 850);
1145: ELSIF g_def_bal_id(bal_index).balance_name = 'Normal Working Hours' THEN
1146:
1147: hr_utility.set_location(' Inside balance Loop ', 850);
1148: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

Line 1147: hr_utility.set_location(' Inside balance Loop ', 850);

1143: null);
1144: hr_utility.set_location(' l_othr_bal_val '|| l_othr_bal_val, 850);
1145: ELSIF g_def_bal_id(bal_index).balance_name = 'Normal Working Hours' THEN
1146:
1147: hr_utility.set_location(' Inside balance Loop ', 850);
1148: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1149: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1150:
1151:

Line 1148: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

1144: hr_utility.set_location(' l_othr_bal_val '|| l_othr_bal_val, 850);
1145: ELSIF g_def_bal_id(bal_index).balance_name = 'Normal Working Hours' THEN
1146:
1147: hr_utility.set_location(' Inside balance Loop ', 850);
1148: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1149: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1150:
1151:
1152:

Line 1149: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);

1145: ELSIF g_def_bal_id(bal_index).balance_name = 'Normal Working Hours' THEN
1146:
1147: hr_utility.set_location(' Inside balance Loop ', 850);
1148: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1149: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1150:
1151:
1152:
1153: /*6856473 added if conditions to check for salaried code*/

Line 1155: hr_utility.set_location(' l_valid_asg_rec.normal_hours '||l_valid_asg_rec.normal_hours, 850);

1151:
1152:
1153: /*6856473 added if conditions to check for salaried code*/
1154:
1155: hr_utility.set_location(' l_valid_asg_rec.normal_hours '||l_valid_asg_rec.normal_hours, 850);
1156: hr_utility.set_location(' l_valid_asg_rec.frequency '||l_valid_asg_rec.frequency, 850);
1157: hr_utility.set_location(' l_valid_asg_rec.hourly_or_salaried '||l_valid_asg_rec.hourly_or_salaried, 850);
1158:
1159: IF(l_valid_asg_rec.hourly_or_salaried='S')

Line 1156: hr_utility.set_location(' l_valid_asg_rec.frequency '||l_valid_asg_rec.frequency, 850);

1152:
1153: /*6856473 added if conditions to check for salaried code*/
1154:
1155: hr_utility.set_location(' l_valid_asg_rec.normal_hours '||l_valid_asg_rec.normal_hours, 850);
1156: hr_utility.set_location(' l_valid_asg_rec.frequency '||l_valid_asg_rec.frequency, 850);
1157: hr_utility.set_location(' l_valid_asg_rec.hourly_or_salaried '||l_valid_asg_rec.hourly_or_salaried, 850);
1158:
1159: IF(l_valid_asg_rec.hourly_or_salaried='S')
1160: THEN

Line 1157: hr_utility.set_location(' l_valid_asg_rec.hourly_or_salaried '||l_valid_asg_rec.hourly_or_salaried, 850);

1153: /*6856473 added if conditions to check for salaried code*/
1154:
1155: hr_utility.set_location(' l_valid_asg_rec.normal_hours '||l_valid_asg_rec.normal_hours, 850);
1156: hr_utility.set_location(' l_valid_asg_rec.frequency '||l_valid_asg_rec.frequency, 850);
1157: hr_utility.set_location(' l_valid_asg_rec.hourly_or_salaried '||l_valid_asg_rec.hourly_or_salaried, 850);
1158:
1159: IF(l_valid_asg_rec.hourly_or_salaried='S')
1160: THEN
1161:

Line 1192: hr_utility.set_location(' l_chrs_bal_val '|| l_chrs_bal_val, 850);

1188: null,
1189: null,
1190: null);
1191: END IF;
1192: hr_utility.set_location(' l_chrs_bal_val '|| l_chrs_bal_val, 850);
1193: --Bug # 6774024
1194: ELSIF (g_def_bal_id(bal_index).balance_name = 'Paid Maternity Hours') THEN
1195:
1196: hr_utility.set_location(' Inside balance Loop ', 850);

Line 1196: hr_utility.set_location(' Inside balance Loop ', 850);

1192: hr_utility.set_location(' l_chrs_bal_val '|| l_chrs_bal_val, 850);
1193: --Bug # 6774024
1194: ELSIF (g_def_bal_id(bal_index).balance_name = 'Paid Maternity Hours') THEN
1195:
1196: hr_utility.set_location(' Inside balance Loop ', 850);
1197: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1198: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1199:
1200: l_mat_bal_val := nvl(l_mat_bal_val,0)

Line 1197: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

1193: --Bug # 6774024
1194: ELSIF (g_def_bal_id(bal_index).balance_name = 'Paid Maternity Hours') THEN
1195:
1196: hr_utility.set_location(' Inside balance Loop ', 850);
1197: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1198: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1199:
1200: l_mat_bal_val := nvl(l_mat_bal_val,0)
1201: +

Line 1198: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);

1194: ELSIF (g_def_bal_id(bal_index).balance_name = 'Paid Maternity Hours') THEN
1195:
1196: hr_utility.set_location(' Inside balance Loop ', 850);
1197: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1198: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1199:
1200: l_mat_bal_val := nvl(l_mat_bal_val,0)
1201: +
1202: PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

Line 1211: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

1207: null,
1208: null,
1209: null);/*6856473*/
1210:
1211: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1212:
1213: hr_utility.set_location(' l_mat_bal_val '|| l_mat_bal_val, 850);
1214: ELSIF (g_def_bal_id(bal_index).balance_name = 'Paid Sick Leave Hours' ) THEN
1215:

Line 1213: hr_utility.set_location(' l_mat_bal_val '|| l_mat_bal_val, 850);

1209: null);/*6856473*/
1210:
1211: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1212:
1213: hr_utility.set_location(' l_mat_bal_val '|| l_mat_bal_val, 850);
1214: ELSIF (g_def_bal_id(bal_index).balance_name = 'Paid Sick Leave Hours' ) THEN
1215:
1216: hr_utility.set_location(' Inside balance Loop ', 850);
1217: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

Line 1216: hr_utility.set_location(' Inside balance Loop ', 850);

1212:
1213: hr_utility.set_location(' l_mat_bal_val '|| l_mat_bal_val, 850);
1214: ELSIF (g_def_bal_id(bal_index).balance_name = 'Paid Sick Leave Hours' ) THEN
1215:
1216: hr_utility.set_location(' Inside balance Loop ', 850);
1217: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1218: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1219:
1220: l_sic_bal_val :=

Line 1217: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

1213: hr_utility.set_location(' l_mat_bal_val '|| l_mat_bal_val, 850);
1214: ELSIF (g_def_bal_id(bal_index).balance_name = 'Paid Sick Leave Hours' ) THEN
1215:
1216: hr_utility.set_location(' Inside balance Loop ', 850);
1217: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1218: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1219:
1220: l_sic_bal_val :=
1221: nvl(l_sic_bal_val,0)

Line 1218: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);

1214: ELSIF (g_def_bal_id(bal_index).balance_name = 'Paid Sick Leave Hours' ) THEN
1215:
1216: hr_utility.set_location(' Inside balance Loop ', 850);
1217: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1218: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1219:
1220: l_sic_bal_val :=
1221: nvl(l_sic_bal_val,0)
1222: +

Line 1232: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

1228: null,
1229: null,
1230: null);/*6856473*/
1231:
1232: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1233: hr_utility.set_location(' l_sic_bal_val '|| l_sic_bal_val, 850);
1234: ELSIF (g_def_bal_id(bal_index).balance_name = 'Paid Other Leave Hours' ) THEN
1235:
1236: hr_utility.set_location(' Inside balance Loop ', 850);

Line 1233: hr_utility.set_location(' l_sic_bal_val '|| l_sic_bal_val, 850);

1229: null,
1230: null);/*6856473*/
1231:
1232: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1233: hr_utility.set_location(' l_sic_bal_val '|| l_sic_bal_val, 850);
1234: ELSIF (g_def_bal_id(bal_index).balance_name = 'Paid Other Leave Hours' ) THEN
1235:
1236: hr_utility.set_location(' Inside balance Loop ', 850);
1237: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

Line 1236: hr_utility.set_location(' Inside balance Loop ', 850);

1232: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1233: hr_utility.set_location(' l_sic_bal_val '|| l_sic_bal_val, 850);
1234: ELSIF (g_def_bal_id(bal_index).balance_name = 'Paid Other Leave Hours' ) THEN
1235:
1236: hr_utility.set_location(' Inside balance Loop ', 850);
1237: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1238: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1239:
1240: l_otl_bal_val :=

Line 1237: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

1233: hr_utility.set_location(' l_sic_bal_val '|| l_sic_bal_val, 850);
1234: ELSIF (g_def_bal_id(bal_index).balance_name = 'Paid Other Leave Hours' ) THEN
1235:
1236: hr_utility.set_location(' Inside balance Loop ', 850);
1237: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1238: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1239:
1240: l_otl_bal_val :=
1241: l_otl_bal_val

Line 1238: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);

1234: ELSIF (g_def_bal_id(bal_index).balance_name = 'Paid Other Leave Hours' ) THEN
1235:
1236: hr_utility.set_location(' Inside balance Loop ', 850);
1237: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1238: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1239:
1240: l_otl_bal_val :=
1241: l_otl_bal_val
1242: +

Line 1252: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

1248: null,
1249: null,
1250: null);/*6856473*/
1251:
1252: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1253: hr_utility.set_location(' l_otl_bal_val '|| l_otl_bal_val, 850);
1254:
1255: /*6856473 added checks for balances Paid Maternity Days, Paid Sick Leave Days and Paid Other Leave Days*/
1256:

Line 1253: hr_utility.set_location(' l_otl_bal_val '|| l_otl_bal_val, 850);

1249: null,
1250: null);/*6856473*/
1251:
1252: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1253: hr_utility.set_location(' l_otl_bal_val '|| l_otl_bal_val, 850);
1254:
1255: /*6856473 added checks for balances Paid Maternity Days, Paid Sick Leave Days and Paid Other Leave Days*/
1256:
1257: ELSIF (g_def_bal_id(bal_index).balance_name = 'Paid Maternity Days') THEN

Line 1259: hr_utility.set_location(' Inside balance Loop ', 850);

1255: /*6856473 added checks for balances Paid Maternity Days, Paid Sick Leave Days and Paid Other Leave Days*/
1256:
1257: ELSIF (g_def_bal_id(bal_index).balance_name = 'Paid Maternity Days') THEN
1258:
1259: hr_utility.set_location(' Inside balance Loop ', 850);
1260: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1261: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1262:
1263: l_mat_bal_val :=

Line 1260: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

1256:
1257: ELSIF (g_def_bal_id(bal_index).balance_name = 'Paid Maternity Days') THEN
1258:
1259: hr_utility.set_location(' Inside balance Loop ', 850);
1260: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1261: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1262:
1263: l_mat_bal_val :=
1264: nvl(l_mat_bal_val,0)

Line 1261: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);

1257: ELSIF (g_def_bal_id(bal_index).balance_name = 'Paid Maternity Days') THEN
1258:
1259: hr_utility.set_location(' Inside balance Loop ', 850);
1260: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1261: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1262:
1263: l_mat_bal_val :=
1264: nvl(l_mat_bal_val,0)
1265: +

Line 1275: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

1271: null,
1272: null,
1273: null)*l_hours_per_day;
1274:
1275: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1276:
1277: hr_utility.set_location(' l_mat_bal_val '|| l_mat_bal_val, 850);
1278: ELSIF ( g_def_bal_id(bal_index).balance_name = 'Paid Sick Leave Days') THEN
1279:

Line 1277: hr_utility.set_location(' l_mat_bal_val '|| l_mat_bal_val, 850);

1273: null)*l_hours_per_day;
1274:
1275: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1276:
1277: hr_utility.set_location(' l_mat_bal_val '|| l_mat_bal_val, 850);
1278: ELSIF ( g_def_bal_id(bal_index).balance_name = 'Paid Sick Leave Days') THEN
1279:
1280: hr_utility.set_location(' Inside balance Loop ', 850);
1281: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

Line 1280: hr_utility.set_location(' Inside balance Loop ', 850);

1276:
1277: hr_utility.set_location(' l_mat_bal_val '|| l_mat_bal_val, 850);
1278: ELSIF ( g_def_bal_id(bal_index).balance_name = 'Paid Sick Leave Days') THEN
1279:
1280: hr_utility.set_location(' Inside balance Loop ', 850);
1281: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1282: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1283:
1284: l_sic_bal_val :=

Line 1281: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

1277: hr_utility.set_location(' l_mat_bal_val '|| l_mat_bal_val, 850);
1278: ELSIF ( g_def_bal_id(bal_index).balance_name = 'Paid Sick Leave Days') THEN
1279:
1280: hr_utility.set_location(' Inside balance Loop ', 850);
1281: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1282: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1283:
1284: l_sic_bal_val :=
1285: nvl(l_sic_bal_val,0)

Line 1282: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);

1278: ELSIF ( g_def_bal_id(bal_index).balance_name = 'Paid Sick Leave Days') THEN
1279:
1280: hr_utility.set_location(' Inside balance Loop ', 850);
1281: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1282: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1283:
1284: l_sic_bal_val :=
1285: nvl(l_sic_bal_val,0)
1286: +

Line 1295: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

1291: null,
1292: null,
1293: null,
1294: null)*l_hours_per_day;
1295: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1296: hr_utility.set_location(' l_sic_bal_val '|| l_sic_bal_val, 850);
1297: ELSIF ( g_def_bal_id(bal_index).balance_name = 'Paid Other Leave Days') THEN
1298:
1299: hr_utility.set_location(' Inside balance Loop ', 850);

Line 1296: hr_utility.set_location(' l_sic_bal_val '|| l_sic_bal_val, 850);

1292: null,
1293: null,
1294: null)*l_hours_per_day;
1295: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1296: hr_utility.set_location(' l_sic_bal_val '|| l_sic_bal_val, 850);
1297: ELSIF ( g_def_bal_id(bal_index).balance_name = 'Paid Other Leave Days') THEN
1298:
1299: hr_utility.set_location(' Inside balance Loop ', 850);
1300: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

Line 1299: hr_utility.set_location(' Inside balance Loop ', 850);

1295: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1296: hr_utility.set_location(' l_sic_bal_val '|| l_sic_bal_val, 850);
1297: ELSIF ( g_def_bal_id(bal_index).balance_name = 'Paid Other Leave Days') THEN
1298:
1299: hr_utility.set_location(' Inside balance Loop ', 850);
1300: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1301: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1302:
1303: l_otl_bal_val :=

Line 1300: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

1296: hr_utility.set_location(' l_sic_bal_val '|| l_sic_bal_val, 850);
1297: ELSIF ( g_def_bal_id(bal_index).balance_name = 'Paid Other Leave Days') THEN
1298:
1299: hr_utility.set_location(' Inside balance Loop ', 850);
1300: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1301: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1302:
1303: l_otl_bal_val :=
1304: nvl(l_otl_bal_val,0)

Line 1301: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);

1297: ELSIF ( g_def_bal_id(bal_index).balance_name = 'Paid Other Leave Days') THEN
1298:
1299: hr_utility.set_location(' Inside balance Loop ', 850);
1300: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1301: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1302:
1303: l_otl_bal_val :=
1304: nvl(l_otl_bal_val,0)
1305: +

Line 1315: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

1311: null,
1312: null,
1313: null)*l_hours_per_day
1314: ;
1315: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1316:
1317: hr_utility.set_location(' l_otl_bal_val '|| l_otl_bal_val, 850);
1318:
1319: ELSIF g_def_bal_id(bal_index).balance_name = 'Income Continuance Insurance' THEN

Line 1317: hr_utility.set_location(' l_otl_bal_val '|| l_otl_bal_val, 850);

1313: null)*l_hours_per_day
1314: ;
1315: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1316:
1317: hr_utility.set_location(' l_otl_bal_val '|| l_otl_bal_val, 850);
1318:
1319: ELSIF g_def_bal_id(bal_index).balance_name = 'Income Continuance Insurance' THEN
1320:
1321: hr_utility.set_location(' Inside balance Loop ', 850);

Line 1321: hr_utility.set_location(' Inside balance Loop ', 850);

1317: hr_utility.set_location(' l_otl_bal_val '|| l_otl_bal_val, 850);
1318:
1319: ELSIF g_def_bal_id(bal_index).balance_name = 'Income Continuance Insurance' THEN
1320:
1321: hr_utility.set_location(' Inside balance Loop ', 850);
1322: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1323: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1324:
1325: l_incct_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

Line 1322: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

1318:
1319: ELSIF g_def_bal_id(bal_index).balance_name = 'Income Continuance Insurance' THEN
1320:
1321: hr_utility.set_location(' Inside balance Loop ', 850);
1322: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1323: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1324:
1325: l_incct_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1326: l_valid_asg_act_rec.assignment_action_id,

Line 1323: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);

1319: ELSIF g_def_bal_id(bal_index).balance_name = 'Income Continuance Insurance' THEN
1320:
1321: hr_utility.set_location(' Inside balance Loop ', 850);
1322: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1323: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1324:
1325: l_incct_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1326: l_valid_asg_act_rec.assignment_action_id,
1327: g_employer_id,

Line 1333: hr_utility.set_location(' l_incct_bal_val '|| l_incct_bal_val, 850);

1329: null,
1330: null,
1331: null,
1332: null);
1333: hr_utility.set_location(' l_incct_bal_val '|| l_incct_bal_val, 850);
1334: ELSIF g_def_bal_id(bal_index).balance_name = 'Redundancy Payments' THEN
1335:
1336: hr_utility.set_location(' Inside balance Loop ', 850);
1337: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

Line 1336: hr_utility.set_location(' Inside balance Loop ', 850);

1332: null);
1333: hr_utility.set_location(' l_incct_bal_val '|| l_incct_bal_val, 850);
1334: ELSIF g_def_bal_id(bal_index).balance_name = 'Redundancy Payments' THEN
1335:
1336: hr_utility.set_location(' Inside balance Loop ', 850);
1337: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1338: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1339:
1340: l_red_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

Line 1337: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

1333: hr_utility.set_location(' l_incct_bal_val '|| l_incct_bal_val, 850);
1334: ELSIF g_def_bal_id(bal_index).balance_name = 'Redundancy Payments' THEN
1335:
1336: hr_utility.set_location(' Inside balance Loop ', 850);
1337: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1338: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1339:
1340: l_red_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1341: l_valid_asg_act_rec.assignment_action_id,

Line 1338: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);

1334: ELSIF g_def_bal_id(bal_index).balance_name = 'Redundancy Payments' THEN
1335:
1336: hr_utility.set_location(' Inside balance Loop ', 850);
1337: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1338: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1339:
1340: l_red_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1341: l_valid_asg_act_rec.assignment_action_id,
1342: g_employer_id,

Line 1348: hr_utility.set_location(' l_red_bal_val '|| l_red_bal_val, 850);

1344: null,
1345: null,
1346: null,
1347: null);
1348: hr_utility.set_location(' l_red_bal_val '|| l_red_bal_val, 850);
1349: ELSIF g_def_bal_id(bal_index).balance_name = 'Employee Related Payments' THEN
1350:
1351: hr_utility.set_location(' Inside balance Loop ', 850);
1352: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

Line 1351: hr_utility.set_location(' Inside balance Loop ', 850);

1347: null);
1348: hr_utility.set_location(' l_red_bal_val '|| l_red_bal_val, 850);
1349: ELSIF g_def_bal_id(bal_index).balance_name = 'Employee Related Payments' THEN
1350:
1351: hr_utility.set_location(' Inside balance Loop ', 850);
1352: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1353: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1354:
1355: l_otsoc_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

Line 1352: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

1348: hr_utility.set_location(' l_red_bal_val '|| l_red_bal_val, 850);
1349: ELSIF g_def_bal_id(bal_index).balance_name = 'Employee Related Payments' THEN
1350:
1351: hr_utility.set_location(' Inside balance Loop ', 850);
1352: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1353: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1354:
1355: l_otsoc_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1356: l_valid_asg_act_rec.assignment_action_id,

Line 1353: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);

1349: ELSIF g_def_bal_id(bal_index).balance_name = 'Employee Related Payments' THEN
1350:
1351: hr_utility.set_location(' Inside balance Loop ', 850);
1352: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1353: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1354:
1355: l_otsoc_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1356: l_valid_asg_act_rec.assignment_action_id,
1357: g_employer_id,

Line 1363: hr_utility.set_location(' l_otsoc_bal_val '|| l_otsoc_bal_val, 850);

1359: null,
1360: null,
1361: null,
1362: null);
1363: hr_utility.set_location(' l_otsoc_bal_val '|| l_otsoc_bal_val, 850);
1364: ELSIF g_def_bal_id(bal_index).balance_name = 'Training Subsidies' THEN
1365:
1366: hr_utility.set_location(' Inside balance Loop ', 850);
1367: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

Line 1366: hr_utility.set_location(' Inside balance Loop ', 850);

1362: null);
1363: hr_utility.set_location(' l_otsoc_bal_val '|| l_otsoc_bal_val, 850);
1364: ELSIF g_def_bal_id(bal_index).balance_name = 'Training Subsidies' THEN
1365:
1366: hr_utility.set_location(' Inside balance Loop ', 850);
1367: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1368: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1369:
1370: l_tr_sub_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

Line 1367: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

1363: hr_utility.set_location(' l_otsoc_bal_val '|| l_otsoc_bal_val, 850);
1364: ELSIF g_def_bal_id(bal_index).balance_name = 'Training Subsidies' THEN
1365:
1366: hr_utility.set_location(' Inside balance Loop ', 850);
1367: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1368: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1369:
1370: l_tr_sub_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1371: l_valid_asg_act_rec.assignment_action_id,

Line 1368: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);

1364: ELSIF g_def_bal_id(bal_index).balance_name = 'Training Subsidies' THEN
1365:
1366: hr_utility.set_location(' Inside balance Loop ', 850);
1367: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1368: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1369:
1370: l_tr_sub_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1371: l_valid_asg_act_rec.assignment_action_id,
1372: g_employer_id,

Line 1378: hr_utility.set_location(' l_tr_sub_bal_val '|| l_tr_sub_bal_val, 850);

1374: null,
1375: null,
1376: null,
1377: null);
1378: hr_utility.set_location(' l_tr_sub_bal_val '|| l_tr_sub_bal_val, 850);
1379: ELSIF g_def_bal_id(bal_index).balance_name = 'Refunds' THEN
1380:
1381: hr_utility.set_location(' Inside balance Loop ', 850);
1382: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

Line 1381: hr_utility.set_location(' Inside balance Loop ', 850);

1377: null);
1378: hr_utility.set_location(' l_tr_sub_bal_val '|| l_tr_sub_bal_val, 850);
1379: ELSIF g_def_bal_id(bal_index).balance_name = 'Refunds' THEN
1380:
1381: hr_utility.set_location(' Inside balance Loop ', 850);
1382: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1383: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1384:
1385: l_refund_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

Line 1382: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

1378: hr_utility.set_location(' l_tr_sub_bal_val '|| l_tr_sub_bal_val, 850);
1379: ELSIF g_def_bal_id(bal_index).balance_name = 'Refunds' THEN
1380:
1381: hr_utility.set_location(' Inside balance Loop ', 850);
1382: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1383: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1384:
1385: l_refund_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1386: l_valid_asg_act_rec.assignment_action_id,

Line 1383: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);

1379: ELSIF g_def_bal_id(bal_index).balance_name = 'Refunds' THEN
1380:
1381: hr_utility.set_location(' Inside balance Loop ', 850);
1382: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1383: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1384:
1385: l_refund_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1386: l_valid_asg_act_rec.assignment_action_id,
1387: g_employer_id,

Line 1393: hr_utility.set_location(' l_refund_bal_val '|| l_refund_bal_val, 850);

1389: null,
1390: null,
1391: null,
1392: null);
1393: hr_utility.set_location(' l_refund_bal_val '|| l_refund_bal_val, 850);
1394: ELSIF g_def_bal_id(bal_index).balance_name = 'Voluntary Sickness Insurance' THEN
1395:
1396: hr_utility.set_location(' Inside balance Loop ', 850);
1397: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

Line 1396: hr_utility.set_location(' Inside balance Loop ', 850);

1392: null);
1393: hr_utility.set_location(' l_refund_bal_val '|| l_refund_bal_val, 850);
1394: ELSIF g_def_bal_id(bal_index).balance_name = 'Voluntary Sickness Insurance' THEN
1395:
1396: hr_utility.set_location(' Inside balance Loop ', 850);
1397: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1398: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1399:
1400: l_vhi_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

Line 1397: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

1393: hr_utility.set_location(' l_refund_bal_val '|| l_refund_bal_val, 850);
1394: ELSIF g_def_bal_id(bal_index).balance_name = 'Voluntary Sickness Insurance' THEN
1395:
1396: hr_utility.set_location(' Inside balance Loop ', 850);
1397: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1398: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1399:
1400: l_vhi_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1401: l_valid_asg_act_rec.assignment_action_id,

Line 1398: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);

1394: ELSIF g_def_bal_id(bal_index).balance_name = 'Voluntary Sickness Insurance' THEN
1395:
1396: hr_utility.set_location(' Inside balance Loop ', 850);
1397: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1398: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1399:
1400: l_vhi_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1401: l_valid_asg_act_rec.assignment_action_id,
1402: g_employer_id,

Line 1408: hr_utility.set_location(' l_vhi_bal_val '|| l_vhi_bal_val, 850);

1404: null,
1405: null,
1406: null,
1407: null);
1408: hr_utility.set_location(' l_vhi_bal_val '|| l_vhi_bal_val, 850);
1409: ELSIF g_def_bal_id(bal_index).balance_name = 'Staff Housing' THEN
1410:
1411: hr_utility.set_location(' Inside balance Loop ', 850);
1412: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

Line 1411: hr_utility.set_location(' Inside balance Loop ', 850);

1407: null);
1408: hr_utility.set_location(' l_vhi_bal_val '|| l_vhi_bal_val, 850);
1409: ELSIF g_def_bal_id(bal_index).balance_name = 'Staff Housing' THEN
1410:
1411: hr_utility.set_location(' Inside balance Loop ', 850);
1412: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1413: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1414:
1415: l_hse_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

Line 1412: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

1408: hr_utility.set_location(' l_vhi_bal_val '|| l_vhi_bal_val, 850);
1409: ELSIF g_def_bal_id(bal_index).balance_name = 'Staff Housing' THEN
1410:
1411: hr_utility.set_location(' Inside balance Loop ', 850);
1412: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1413: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1414:
1415: l_hse_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1416: l_valid_asg_act_rec.assignment_action_id,

Line 1413: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);

1409: ELSIF g_def_bal_id(bal_index).balance_name = 'Staff Housing' THEN
1410:
1411: hr_utility.set_location(' Inside balance Loop ', 850);
1412: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1413: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1414:
1415: l_hse_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1416: l_valid_asg_act_rec.assignment_action_id,
1417: g_employer_id,

Line 1423: hr_utility.set_location(' l_hse_bal_val '|| l_hse_bal_val, 850);

1419: null,
1420: null,
1421: null,
1422: null);
1423: hr_utility.set_location(' l_hse_bal_val '|| l_hse_bal_val, 850);
1424: ELSIF g_def_bal_id(bal_index).balance_name = 'Other Benefits' THEN
1425:
1426: hr_utility.set_location(' Inside balance Loop ', 850);
1427: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

Line 1426: hr_utility.set_location(' Inside balance Loop ', 850);

1422: null);
1423: hr_utility.set_location(' l_hse_bal_val '|| l_hse_bal_val, 850);
1424: ELSIF g_def_bal_id(bal_index).balance_name = 'Other Benefits' THEN
1425:
1426: hr_utility.set_location(' Inside balance Loop ', 850);
1427: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1428: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1429:
1430: l_otben_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

Line 1427: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

1423: hr_utility.set_location(' l_hse_bal_val '|| l_hse_bal_val, 850);
1424: ELSIF g_def_bal_id(bal_index).balance_name = 'Other Benefits' THEN
1425:
1426: hr_utility.set_location(' Inside balance Loop ', 850);
1427: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1428: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1429:
1430: l_otben_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1431: l_valid_asg_act_rec.assignment_action_id,

Line 1428: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);

1424: ELSIF g_def_bal_id(bal_index).balance_name = 'Other Benefits' THEN
1425:
1426: hr_utility.set_location(' Inside balance Loop ', 850);
1427: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1428: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1429:
1430: l_otben_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1431: l_valid_asg_act_rec.assignment_action_id,
1432: g_employer_id,

Line 1438: hr_utility.set_location(' l_otben_bal_val '|| l_otben_bal_val, 850);

1434: null,
1435: null,
1436: null,
1437: null);
1438: hr_utility.set_location(' l_otben_bal_val '|| l_otben_bal_val, 850);
1439: ELSIF g_def_bal_id(bal_index).balance_name = 'Other Subsidies' THEN
1440:
1441: hr_utility.set_location(' Inside balance Loop ', 850);
1442: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

Line 1441: hr_utility.set_location(' Inside balance Loop ', 850);

1437: null);
1438: hr_utility.set_location(' l_otben_bal_val '|| l_otben_bal_val, 850);
1439: ELSIF g_def_bal_id(bal_index).balance_name = 'Other Subsidies' THEN
1440:
1441: hr_utility.set_location(' Inside balance Loop ', 850);
1442: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1443: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1444:
1445: l_ot_sub_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

Line 1442: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

1438: hr_utility.set_location(' l_otben_bal_val '|| l_otben_bal_val, 850);
1439: ELSIF g_def_bal_id(bal_index).balance_name = 'Other Subsidies' THEN
1440:
1441: hr_utility.set_location(' Inside balance Loop ', 850);
1442: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1443: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1444:
1445: l_ot_sub_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1446: l_valid_asg_act_rec.assignment_action_id,

Line 1443: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);

1439: ELSIF g_def_bal_id(bal_index).balance_name = 'Other Subsidies' THEN
1440:
1441: hr_utility.set_location(' Inside balance Loop ', 850);
1442: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1443: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1444:
1445: l_ot_sub_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1446: l_valid_asg_act_rec.assignment_action_id,
1447: g_employer_id,

Line 1453: hr_utility.set_location(' l_ot_sub_bal_val '|| l_ot_sub_bal_val, 850);

1449: null,
1450: null,
1451: null,
1452: null);
1453: hr_utility.set_location(' l_ot_sub_bal_val '|| l_ot_sub_bal_val, 850);
1454: ELSIF g_def_bal_id(bal_index).balance_name = 'Hourly Rate' THEN
1455:
1456: hr_utility.set_location(' Inside balance Loop ', 850);
1457: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

Line 1456: hr_utility.set_location(' Inside balance Loop ', 850);

1452: null);
1453: hr_utility.set_location(' l_ot_sub_bal_val '|| l_ot_sub_bal_val, 850);
1454: ELSIF g_def_bal_id(bal_index).balance_name = 'Hourly Rate' THEN
1455:
1456: hr_utility.set_location(' Inside balance Loop ', 850);
1457: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1458: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1459:
1460: /* l_nmw_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

Line 1457: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

1453: hr_utility.set_location(' l_ot_sub_bal_val '|| l_ot_sub_bal_val, 850);
1454: ELSIF g_def_bal_id(bal_index).balance_name = 'Hourly Rate' THEN
1455:
1456: hr_utility.set_location(' Inside balance Loop ', 850);
1457: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1458: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1459:
1460: /* l_nmw_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1461: l_valid_asg_act_rec.assignment_action_id,

Line 1458: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);

1454: ELSIF g_def_bal_id(bal_index).balance_name = 'Hourly Rate' THEN
1455:
1456: hr_utility.set_location(' Inside balance Loop ', 850);
1457: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1458: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1459:
1460: /* l_nmw_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1461: l_valid_asg_act_rec.assignment_action_id,
1462: g_employer_id,

Line 1470: hr_utility.set_location(' l_nmw_bal_val '|| l_nmw_bal_val, 850);

1466: null,
1467: null);
1468: */
1469: l_nmw_bal_val:=( NVL(l_regwg_bal_val,0) + NVL(l_irrb_bal_val,0));
1470: hr_utility.set_location(' l_nmw_bal_val '|| l_nmw_bal_val, 850);
1471: ELSIF g_def_bal_id(bal_index).balance_name = 'Stock Options and Share Purchase' THEN
1472:
1473: hr_utility.set_location(' Inside balance Loop ', 850);
1474: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

Line 1473: hr_utility.set_location(' Inside balance Loop ', 850);

1469: l_nmw_bal_val:=( NVL(l_regwg_bal_val,0) + NVL(l_irrb_bal_val,0));
1470: hr_utility.set_location(' l_nmw_bal_val '|| l_nmw_bal_val, 850);
1471: ELSIF g_def_bal_id(bal_index).balance_name = 'Stock Options and Share Purchase' THEN
1472:
1473: hr_utility.set_location(' Inside balance Loop ', 850);
1474: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1475: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1476:
1477: l_stks_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

Line 1474: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

1470: hr_utility.set_location(' l_nmw_bal_val '|| l_nmw_bal_val, 850);
1471: ELSIF g_def_bal_id(bal_index).balance_name = 'Stock Options and Share Purchase' THEN
1472:
1473: hr_utility.set_location(' Inside balance Loop ', 850);
1474: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1475: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1476:
1477: l_stks_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1478: l_valid_asg_act_rec.assignment_action_id,

Line 1475: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);

1471: ELSIF g_def_bal_id(bal_index).balance_name = 'Stock Options and Share Purchase' THEN
1472:
1473: hr_utility.set_location(' Inside balance Loop ', 850);
1474: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1475: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1476:
1477: l_stks_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1478: l_valid_asg_act_rec.assignment_action_id,
1479: g_employer_id,

Line 1485: hr_utility.set_location(' l_stks_bal_val '|| l_stks_bal_val, 850);

1481: null,
1482: null,
1483: null,
1484: null);
1485: hr_utility.set_location(' l_stks_bal_val '|| l_stks_bal_val, 850);
1486: ELSIF g_def_bal_id(bal_index).balance_name = 'IE RBS ER Contribution' THEN
1487:
1488: hr_utility.set_location(' Inside balance Loop ', 850);
1489: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

Line 1488: hr_utility.set_location(' Inside balance Loop ', 850);

1484: null);
1485: hr_utility.set_location(' l_stks_bal_val '|| l_stks_bal_val, 850);
1486: ELSIF g_def_bal_id(bal_index).balance_name = 'IE RBS ER Contribution' THEN
1487:
1488: hr_utility.set_location(' Inside balance Loop ', 850);
1489: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1490: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1491:
1492: l_rbs_er_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

Line 1489: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

1485: hr_utility.set_location(' l_stks_bal_val '|| l_stks_bal_val, 850);
1486: ELSIF g_def_bal_id(bal_index).balance_name = 'IE RBS ER Contribution' THEN
1487:
1488: hr_utility.set_location(' Inside balance Loop ', 850);
1489: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1490: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1491:
1492: l_rbs_er_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1493: l_valid_asg_act_rec.assignment_action_id,

Line 1490: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);

1486: ELSIF g_def_bal_id(bal_index).balance_name = 'IE RBS ER Contribution' THEN
1487:
1488: hr_utility.set_location(' Inside balance Loop ', 850);
1489: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1490: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1491:
1492: l_rbs_er_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1493: l_valid_asg_act_rec.assignment_action_id,
1494: g_employer_id,

Line 1500: hr_utility.set_location(' l_rbs_er_bal_val '|| l_rbs_er_bal_val, 850);

1496: null,
1497: null,
1498: null,
1499: null);
1500: hr_utility.set_location(' l_rbs_er_bal_val '|| l_rbs_er_bal_val, 850);
1501: ELSIF g_def_bal_id(bal_index).balance_name = 'IE PRSA ER Contribution' THEN
1502:
1503: hr_utility.set_location(' Inside balance Loop ', 850);
1504: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

Line 1503: hr_utility.set_location(' Inside balance Loop ', 850);

1499: null);
1500: hr_utility.set_location(' l_rbs_er_bal_val '|| l_rbs_er_bal_val, 850);
1501: ELSIF g_def_bal_id(bal_index).balance_name = 'IE PRSA ER Contribution' THEN
1502:
1503: hr_utility.set_location(' Inside balance Loop ', 850);
1504: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1505: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1506:
1507: l_prsa_er_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

Line 1504: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

1500: hr_utility.set_location(' l_rbs_er_bal_val '|| l_rbs_er_bal_val, 850);
1501: ELSIF g_def_bal_id(bal_index).balance_name = 'IE PRSA ER Contribution' THEN
1502:
1503: hr_utility.set_location(' Inside balance Loop ', 850);
1504: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1505: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1506:
1507: l_prsa_er_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1508: l_valid_asg_act_rec.assignment_action_id,

Line 1505: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);

1501: ELSIF g_def_bal_id(bal_index).balance_name = 'IE PRSA ER Contribution' THEN
1502:
1503: hr_utility.set_location(' Inside balance Loop ', 850);
1504: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1505: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1506:
1507: l_prsa_er_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1508: l_valid_asg_act_rec.assignment_action_id,
1509: g_employer_id,

Line 1515: hr_utility.set_location(' l_prsa_er_bal_val '|| l_prsa_er_bal_val, 850);

1511: null,
1512: null,
1513: null,
1514: null);
1515: hr_utility.set_location(' l_prsa_er_bal_val '|| l_prsa_er_bal_val, 850);
1516: ELSIF g_def_bal_id(bal_index).balance_name = 'IE RAC ER Contribution' THEN
1517:
1518: hr_utility.set_location(' Inside balance Loop ', 850);
1519: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

Line 1518: hr_utility.set_location(' Inside balance Loop ', 850);

1514: null);
1515: hr_utility.set_location(' l_prsa_er_bal_val '|| l_prsa_er_bal_val, 850);
1516: ELSIF g_def_bal_id(bal_index).balance_name = 'IE RAC ER Contribution' THEN
1517:
1518: hr_utility.set_location(' Inside balance Loop ', 850);
1519: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1520: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1521:
1522: l_rac_er_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

Line 1519: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

1515: hr_utility.set_location(' l_prsa_er_bal_val '|| l_prsa_er_bal_val, 850);
1516: ELSIF g_def_bal_id(bal_index).balance_name = 'IE RAC ER Contribution' THEN
1517:
1518: hr_utility.set_location(' Inside balance Loop ', 850);
1519: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1520: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1521:
1522: l_rac_er_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1523: l_valid_asg_act_rec.assignment_action_id,

Line 1520: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);

1516: ELSIF g_def_bal_id(bal_index).balance_name = 'IE RAC ER Contribution' THEN
1517:
1518: hr_utility.set_location(' Inside balance Loop ', 850);
1519: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1520: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1521:
1522: l_rac_er_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1523: l_valid_asg_act_rec.assignment_action_id,
1524: g_employer_id,

Line 1530: hr_utility.set_location(' l_rac_er_bal_val '|| l_rac_er_bal_val, 850);

1526: null,
1527: null,
1528: null,
1529: null);
1530: hr_utility.set_location(' l_rac_er_bal_val '|| l_rac_er_bal_val, 850);
1531: ELSIF g_def_bal_id(bal_index).balance_name = 'IE PRSI Employer' THEN
1532:
1533: hr_utility.set_location(' Inside balance Loop ', 850);
1534: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

Line 1533: hr_utility.set_location(' Inside balance Loop ', 850);

1529: null);
1530: hr_utility.set_location(' l_rac_er_bal_val '|| l_rac_er_bal_val, 850);
1531: ELSIF g_def_bal_id(bal_index).balance_name = 'IE PRSI Employer' THEN
1532:
1533: hr_utility.set_location(' Inside balance Loop ', 850);
1534: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1535: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1536:
1537: l_prsi_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

Line 1534: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

1530: hr_utility.set_location(' l_rac_er_bal_val '|| l_rac_er_bal_val, 850);
1531: ELSIF g_def_bal_id(bal_index).balance_name = 'IE PRSI Employer' THEN
1532:
1533: hr_utility.set_location(' Inside balance Loop ', 850);
1534: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1535: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1536:
1537: l_prsi_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1538: l_valid_asg_act_rec.assignment_action_id,

Line 1535: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);

1531: ELSIF g_def_bal_id(bal_index).balance_name = 'IE PRSI Employer' THEN
1532:
1533: hr_utility.set_location(' Inside balance Loop ', 850);
1534: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1535: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1536:
1537: l_prsi_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1538: l_valid_asg_act_rec.assignment_action_id,
1539: g_employer_id,

Line 1545: hr_utility.set_location(' l_prsi_bal_val '|| l_prsi_bal_val, 850);

1541: null,
1542: null,
1543: null,
1544: null);
1545: hr_utility.set_location(' l_prsi_bal_val '|| l_prsi_bal_val, 850);
1546: ELSIF g_def_bal_id(bal_index).balance_name = 'IE BIK Company Vehicle' THEN
1547:
1548: hr_utility.set_location(' Inside balance Loop ', 850);
1549: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

Line 1548: hr_utility.set_location(' Inside balance Loop ', 850);

1544: null);
1545: hr_utility.set_location(' l_prsi_bal_val '|| l_prsi_bal_val, 850);
1546: ELSIF g_def_bal_id(bal_index).balance_name = 'IE BIK Company Vehicle' THEN
1547:
1548: hr_utility.set_location(' Inside balance Loop ', 850);
1549: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1550: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1551:
1552: l_bik_veh_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

Line 1549: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

1545: hr_utility.set_location(' l_prsi_bal_val '|| l_prsi_bal_val, 850);
1546: ELSIF g_def_bal_id(bal_index).balance_name = 'IE BIK Company Vehicle' THEN
1547:
1548: hr_utility.set_location(' Inside balance Loop ', 850);
1549: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1550: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1551:
1552: l_bik_veh_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1553: l_valid_asg_act_rec.assignment_action_id,

Line 1550: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);

1546: ELSIF g_def_bal_id(bal_index).balance_name = 'IE BIK Company Vehicle' THEN
1547:
1548: hr_utility.set_location(' Inside balance Loop ', 850);
1549: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1550: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1551:
1552: l_bik_veh_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1553: l_valid_asg_act_rec.assignment_action_id,
1554: g_employer_id,

Line 1561: hr_utility.set_location(' l_bik_veh_bal_val '|| l_bik_veh_bal_val, 850);

1557: null,
1558: null,
1559: null);
1560:
1561: hr_utility.set_location(' l_bik_veh_bal_val '|| l_bik_veh_bal_val, 850);
1562:
1563: /* 6856473 */
1564: ELSIF g_def_bal_id(bal_index).balance_name = 'Annual Leave and Bank Holiday Hours' THEN
1565: hr_utility.set_location(' Inside balance Loop ', 850);

Line 1565: hr_utility.set_location(' Inside balance Loop ', 850);

1561: hr_utility.set_location(' l_bik_veh_bal_val '|| l_bik_veh_bal_val, 850);
1562:
1563: /* 6856473 */
1564: ELSIF g_def_bal_id(bal_index).balance_name = 'Annual Leave and Bank Holiday Hours' THEN
1565: hr_utility.set_location(' Inside balance Loop ', 850);
1566: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1567: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1568: l_al_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1569: l_valid_asg_act_rec.assignment_action_id,

Line 1566: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

1562:
1563: /* 6856473 */
1564: ELSIF g_def_bal_id(bal_index).balance_name = 'Annual Leave and Bank Holiday Hours' THEN
1565: hr_utility.set_location(' Inside balance Loop ', 850);
1566: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1567: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1568: l_al_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1569: l_valid_asg_act_rec.assignment_action_id,
1570: g_employer_id,

Line 1567: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);

1563: /* 6856473 */
1564: ELSIF g_def_bal_id(bal_index).balance_name = 'Annual Leave and Bank Holiday Hours' THEN
1565: hr_utility.set_location(' Inside balance Loop ', 850);
1566: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1567: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1568: l_al_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1569: l_valid_asg_act_rec.assignment_action_id,
1570: g_employer_id,
1571: null,

Line 1576: hr_utility.set_location(' l_al_bal_val '|| l_al_bal_val, 850);

1572: null,
1573: null,
1574: null,
1575: null);
1576: hr_utility.set_location(' l_al_bal_val '|| l_al_bal_val, 850);
1577: ELSIF ( g_def_bal_id(bal_index).balance_name = 'Annual Leave and Bank Holiday Days') THEN
1578: hr_utility.set_location(' Inside balance Loop ', 850);
1579: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1580: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);

Line 1578: hr_utility.set_location(' Inside balance Loop ', 850);

1574: null,
1575: null);
1576: hr_utility.set_location(' l_al_bal_val '|| l_al_bal_val, 850);
1577: ELSIF ( g_def_bal_id(bal_index).balance_name = 'Annual Leave and Bank Holiday Days') THEN
1578: hr_utility.set_location(' Inside balance Loop ', 850);
1579: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1580: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1581: l_al_bal_val :=
1582: nvl(l_al_bal_val,0)

Line 1579: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);

1575: null);
1576: hr_utility.set_location(' l_al_bal_val '|| l_al_bal_val, 850);
1577: ELSIF ( g_def_bal_id(bal_index).balance_name = 'Annual Leave and Bank Holiday Days') THEN
1578: hr_utility.set_location(' Inside balance Loop ', 850);
1579: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1580: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1581: l_al_bal_val :=
1582: nvl(l_al_bal_val,0)
1583: +

Line 1580: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);

1576: hr_utility.set_location(' l_al_bal_val '|| l_al_bal_val, 850);
1577: ELSIF ( g_def_bal_id(bal_index).balance_name = 'Annual Leave and Bank Holiday Days') THEN
1578: hr_utility.set_location(' Inside balance Loop ', 850);
1579: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1580: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1581: l_al_bal_val :=
1582: nvl(l_al_bal_val,0)
1583: +
1584: PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

Line 1593: hr_utility.set_location(' l_al_bal_val '|| l_al_bal_val, 850);

1589: null,
1590: null,
1591: null)*l_hours_per_day
1592: ;
1593: hr_utility.set_location(' l_al_bal_val '|| l_al_bal_val, 850);
1594:
1595: END IF;
1596: END LOOP;
1597:

Line 1608: hr_utility.set_location(' l_nmw_count '|| l_nmw_count , 860);

1604: IF (l_nmw_bal_val / l_chrs_bal_val) <= g_ie_nat_min_wage_rate THEN
1605: l_nmw_count := l_nmw_count + 1;
1606: END IF;
1607: END IF;
1608: hr_utility.set_location(' l_nmw_count '|| l_nmw_count , 860);
1609:
1610: l_pen_bal_val_tot := NVL(l_rbs_er_bal_val,0) + NVL(l_prsa_er_bal_val,0) + NVL(l_rac_er_bal_val,0);
1611:
1612: hr_utility.set_location(' l_pen_bal_val_tot '|| l_pen_bal_val_tot , 870);

Line 1612: hr_utility.set_location(' l_pen_bal_val_tot '|| l_pen_bal_val_tot , 870);

1608: hr_utility.set_location(' l_nmw_count '|| l_nmw_count , 860);
1609:
1610: l_pen_bal_val_tot := NVL(l_rbs_er_bal_val,0) + NVL(l_prsa_er_bal_val,0) + NVL(l_rac_er_bal_val,0);
1611:
1612: hr_utility.set_location(' l_pen_bal_val_tot '|| l_pen_bal_val_tot , 870);
1613:
1614: IF l_valid_asg_rec.EMP_CATG = 'AT' THEN
1615: l_app_wg_bal_val_tot := NVL(l_regwg_bal_val,0) + NVL(l_ovrt_bal_val,0) + NVL(l_irrb_bal_val,0);
1616: l_lap_bal_val_tot := NVL(l_mat_bal_val,0) + NVL(l_sic_bal_val,0) + NVL(l_otl_bal_val,0);

Line 1620: hr_utility.set_location(' l_app_wg_bal_val_tot '|| l_app_wg_bal_val_tot , 880);

1616: l_lap_bal_val_tot := NVL(l_mat_bal_val,0) + NVL(l_sic_bal_val,0) + NVL(l_otl_bal_val,0);
1617: l_ssec_bal_val_tot := NVL(l_prsi_bal_val,0) + NVL(l_incct_bal_val,0)
1618: + NVL(l_red_bal_val,0) + NVL(l_otsoc_bal_val,0);
1619:
1620: hr_utility.set_location(' l_app_wg_bal_val_tot '|| l_app_wg_bal_val_tot , 880);
1621: hr_utility.set_location(' l_lap_bal_val_tot '|| l_lap_bal_val_tot , 880);
1622: hr_utility.set_location(' l_ssec_bal_val_tot '|| l_ssec_bal_val_tot , 880);
1623: END IF;
1624: -- END IF; --assignment action ID

Line 1621: hr_utility.set_location(' l_lap_bal_val_tot '|| l_lap_bal_val_tot , 880);

1617: l_ssec_bal_val_tot := NVL(l_prsi_bal_val,0) + NVL(l_incct_bal_val,0)
1618: + NVL(l_red_bal_val,0) + NVL(l_otsoc_bal_val,0);
1619:
1620: hr_utility.set_location(' l_app_wg_bal_val_tot '|| l_app_wg_bal_val_tot , 880);
1621: hr_utility.set_location(' l_lap_bal_val_tot '|| l_lap_bal_val_tot , 880);
1622: hr_utility.set_location(' l_ssec_bal_val_tot '|| l_ssec_bal_val_tot , 880);
1623: END IF;
1624: -- END IF; --assignment action ID
1625: END IF;

Line 1622: hr_utility.set_location(' l_ssec_bal_val_tot '|| l_ssec_bal_val_tot , 880);

1618: + NVL(l_red_bal_val,0) + NVL(l_otsoc_bal_val,0);
1619:
1620: hr_utility.set_location(' l_app_wg_bal_val_tot '|| l_app_wg_bal_val_tot , 880);
1621: hr_utility.set_location(' l_lap_bal_val_tot '|| l_lap_bal_val_tot , 880);
1622: hr_utility.set_location(' l_ssec_bal_val_tot '|| l_ssec_bal_val_tot , 880);
1623: END IF;
1624: -- END IF; --assignment action ID
1625: END IF;
1626: CLOSE cur_valid_asg_act;

Line 1628: hr_utility.set_location(' Before Inserting PAY_US_RPT_TOTALS', 890);

1624: -- END IF; --assignment action ID
1625: END IF;
1626: CLOSE cur_valid_asg_act;
1627:
1628: hr_utility.set_location(' Before Inserting PAY_US_RPT_TOTALS', 890);
1629: hr_utility.set_location(' VALUE OF EMP_CATG'||l_valid_asg_rec.EMP_CATG, 890);
1630:
1631: INSERT INTO PAY_US_RPT_TOTALS
1632: (BUSINESS_GROUP_ID

Line 1629: hr_utility.set_location(' VALUE OF EMP_CATG'||l_valid_asg_rec.EMP_CATG, 890);

1625: END IF;
1626: CLOSE cur_valid_asg_act;
1627:
1628: hr_utility.set_location(' Before Inserting PAY_US_RPT_TOTALS', 890);
1629: hr_utility.set_location(' VALUE OF EMP_CATG'||l_valid_asg_rec.EMP_CATG, 890);
1630:
1631: INSERT INTO PAY_US_RPT_TOTALS
1632: (BUSINESS_GROUP_ID
1633: ,ATTRIBUTE1 --payroll_action_id

Line 1706: hr_utility.set_location(' After Inserting PAY_US_RPT_TOTALS', 900);

1702: ,l_rac_er_bal_val
1703: ,l_al_bal_val -- 6856473
1704: );
1705:
1706: hr_utility.set_location(' After Inserting PAY_US_RPT_TOTALS', 900);
1707:
1708: CLOSE cur_valid_asg;
1709:
1710: hr_utility.set_location(' Leaving PAY_IE_EHECS_REPORT_PKG.ehecs_main_proc', 910);

Line 1710: hr_utility.set_location(' Leaving PAY_IE_EHECS_REPORT_PKG.ehecs_main_proc', 910);

1706: hr_utility.set_location(' After Inserting PAY_US_RPT_TOTALS', 900);
1707:
1708: CLOSE cur_valid_asg;
1709:
1710: hr_utility.set_location(' Leaving PAY_IE_EHECS_REPORT_PKG.ehecs_main_proc', 910);
1711:
1712: END;
1713:
1714: -----------------------------------------------------------------------

Line 1726: Hr_Utility.set_location('Entering: PAY_IE_EHECS_REPORT_PKG.c2b',1000);

1722: buffer RAW( 32767 );
1723: res BLOB;
1724: lob_len PLS_INTEGER := DBMS_LOB.getLength( c );
1725: BEGIN
1726: Hr_Utility.set_location('Entering: PAY_IE_EHECS_REPORT_PKG.c2b',1000);
1727: DBMS_LOB.createTemporary( res, TRUE );
1728: DBMS_LOB.OPEN( res, DBMS_LOB.LOB_ReadWrite );
1729:
1730:

Line 1742: Hr_Utility.set_location('Leaving: PAY_IE_EHECS_REPORT_PKG.c2b',1010);

1738: pos := pos + 16000;
1739: EXIT WHEN pos > lob_len;
1740: END LOOP;
1741:
1742: Hr_Utility.set_location('Leaving: PAY_IE_EHECS_REPORT_PKG.c2b',1010);
1743: RETURN res; -- res is OPEN here
1744: END c2b;
1745: -----------------------------------------------------------------------
1746: -- GEN_BODY_XML

Line 1775: hr_utility.set_location(' Entering: pay_ie_p45part3_p46_pkg_test.gen_body_xml: ', 2000);

1771: AND ptoa.Object_id = paa.assignment_id
1772: AND ptoa.object_action_id = p_object_action_id;
1773:
1774: BEGIN
1775: hr_utility.set_location(' Entering: pay_ie_p45part3_p46_pkg_test.gen_body_xml: ', 2000);
1776:
1777: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
1778: l_object_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');
1779:

Line 1784: hr_utility.set_location('l_person_id '||TO_CHAR(l_person_id),2010);

1780: OPEN C_Perid_Asgid(l_payroll_action_id, l_object_action_id);
1781: FETCH C_Perid_Asgid into l_person_id, l_assignment_id;
1782: CLOSE C_Perid_Asgid;
1783:
1784: hr_utility.set_location('l_person_id '||TO_CHAR(l_person_id),2010);
1785: hr_utility.set_location('l_assignment_id '||TO_CHAR(l_assignment_id),2010);
1786: hr_utility.set_location('l_payroll_action_id '||TO_CHAR(l_payroll_action_id),2010);
1787: hr_utility.set_location('l_object_action_id '||TO_CHAR(l_object_action_id),2010);
1788:

Line 1785: hr_utility.set_location('l_assignment_id '||TO_CHAR(l_assignment_id),2010);

1781: FETCH C_Perid_Asgid into l_person_id, l_assignment_id;
1782: CLOSE C_Perid_Asgid;
1783:
1784: hr_utility.set_location('l_person_id '||TO_CHAR(l_person_id),2010);
1785: hr_utility.set_location('l_assignment_id '||TO_CHAR(l_assignment_id),2010);
1786: hr_utility.set_location('l_payroll_action_id '||TO_CHAR(l_payroll_action_id),2010);
1787: hr_utility.set_location('l_object_action_id '||TO_CHAR(l_object_action_id),2010);
1788:
1789: hr_utility.set_location('befiore calling Ehecs_main_proc ',2020);

Line 1786: hr_utility.set_location('l_payroll_action_id '||TO_CHAR(l_payroll_action_id),2010);

1782: CLOSE C_Perid_Asgid;
1783:
1784: hr_utility.set_location('l_person_id '||TO_CHAR(l_person_id),2010);
1785: hr_utility.set_location('l_assignment_id '||TO_CHAR(l_assignment_id),2010);
1786: hr_utility.set_location('l_payroll_action_id '||TO_CHAR(l_payroll_action_id),2010);
1787: hr_utility.set_location('l_object_action_id '||TO_CHAR(l_object_action_id),2010);
1788:
1789: hr_utility.set_location('befiore calling Ehecs_main_proc ',2020);
1790:

Line 1787: hr_utility.set_location('l_object_action_id '||TO_CHAR(l_object_action_id),2010);

1783:
1784: hr_utility.set_location('l_person_id '||TO_CHAR(l_person_id),2010);
1785: hr_utility.set_location('l_assignment_id '||TO_CHAR(l_assignment_id),2010);
1786: hr_utility.set_location('l_payroll_action_id '||TO_CHAR(l_payroll_action_id),2010);
1787: hr_utility.set_location('l_object_action_id '||TO_CHAR(l_object_action_id),2010);
1788:
1789: hr_utility.set_location('befiore calling Ehecs_main_proc ',2020);
1790:
1791: ehecs_main_proc( g_business_Group_id

Line 1789: hr_utility.set_location('befiore calling Ehecs_main_proc ',2020);

1785: hr_utility.set_location('l_assignment_id '||TO_CHAR(l_assignment_id),2010);
1786: hr_utility.set_location('l_payroll_action_id '||TO_CHAR(l_payroll_action_id),2010);
1787: hr_utility.set_location('l_object_action_id '||TO_CHAR(l_object_action_id),2010);
1788:
1789: hr_utility.set_location('befiore calling Ehecs_main_proc ',2020);
1790:
1791: ehecs_main_proc( g_business_Group_id
1792: ,l_payroll_action_id
1793: ,l_assignment_id

Line 1796: hr_utility.set_location('befiore calling Ehecs_main_proc ',2030);

1792: ,l_payroll_action_id
1793: ,l_assignment_id
1794: ,l_person_id);
1795:
1796: hr_utility.set_location('befiore calling Ehecs_main_proc ',2030);
1797:
1798: hr_utility.set_location(' Leaving: pay_ie_p45part3_p46_pkg_test.gen_body_xml: ', 2040);
1799:
1800: EXCEPTION

Line 1798: hr_utility.set_location(' Leaving: pay_ie_p45part3_p46_pkg_test.gen_body_xml: ', 2040);

1794: ,l_person_id);
1795:
1796: hr_utility.set_location('befiore calling Ehecs_main_proc ',2030);
1797:
1798: hr_utility.set_location(' Leaving: pay_ie_p45part3_p46_pkg_test.gen_body_xml: ', 2040);
1799:
1800: EXCEPTION
1801: WHEN Others THEN
1802: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,2050);

Line 1802: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,2050);

1798: hr_utility.set_location(' Leaving: pay_ie_p45part3_p46_pkg_test.gen_body_xml: ', 2040);
1799:
1800: EXCEPTION
1801: WHEN Others THEN
1802: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,2050);
1803: END gen_body_xml;
1804: -----------------------------------------------------------------------
1805: -- GEN_HEADER_XML
1806: -----------------------------------------------------------------------

Line 1849: hr_utility.set_location ('Entering '||l_proc,1500);

1845: l_payroll_action_id number;
1846:
1847: BEGIN
1848: l_proc := g_package || 'gen_header_xml';
1849: hr_utility.set_location ('Entering '||l_proc,1500);
1850:
1851: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
1852: hr_utility.set_location('Inside PAY_IE_EHECS_REPORT_PKG.gen_header_xml,l_payroll_action_id: '||l_payroll_action_id,300);
1853:

Line 1852: hr_utility.set_location('Inside PAY_IE_EHECS_REPORT_PKG.gen_header_xml,l_payroll_action_id: '||l_payroll_action_id,300);

1848: l_proc := g_package || 'gen_header_xml';
1849: hr_utility.set_location ('Entering '||l_proc,1500);
1850:
1851: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
1852: hr_utility.set_location('Inside PAY_IE_EHECS_REPORT_PKG.gen_header_xml,l_payroll_action_id: '||l_payroll_action_id,300);
1853:
1854: OPEN c_get_header(l_payroll_action_id);
1855: FETCH c_get_header into l_header;
1856: CLOSE c_get_header;

Line 1897: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1214);

1893: END IF;
1894:
1895: EXCEPTION
1896: WHEN Others THEN
1897: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1214);
1898:
1899: END gen_header_xml;
1900: -----------------------------------------------------------------------
1901: -- GEN_FOOTER_XML

Line 2863: hr_utility.set_location('entering pay_ie_ehecs_report_pkg,gen_footer ',3000);

2859: l_is_gt_0 Varchar2(100);
2860:
2861: begin
2862:
2863: hr_utility.set_location('entering pay_ie_ehecs_report_pkg,gen_footer ',3000);
2864:
2865: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
2866: hr_utility.set_location('l_payroll_action_id. '||TO_CHAR(l_payroll_action_id),3010);
2867:

Line 2866: hr_utility.set_location('l_payroll_action_id. '||TO_CHAR(l_payroll_action_id),3010);

2862:
2863: hr_utility.set_location('entering pay_ie_ehecs_report_pkg,gen_footer ',3000);
2864:
2865: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
2866: hr_utility.set_location('l_payroll_action_id. '||TO_CHAR(l_payroll_action_id),3010);
2867:
2868:
2869: l_tab_get_totals.delete;
2870: hr_utility.set_location('After deleting l_tab_get_totals pltable ',3020);

Line 2870: hr_utility.set_location('After deleting l_tab_get_totals pltable ',3020);

2866: hr_utility.set_location('l_payroll_action_id. '||TO_CHAR(l_payroll_action_id),3010);
2867:
2868:
2869: l_tab_get_totals.delete;
2870: hr_utility.set_location('After deleting l_tab_get_totals pltable ',3020);
2871:
2872: --Initializing to prevent the no data found error
2873: l_tab_get_totals('M') := l_get_totals_empty_rec;
2874: l_tab_get_totals('C') := l_get_totals_empty_rec;

Line 2877: hr_utility.set_location('After initializing l_tab_get_totals pltable ',3030);

2873: l_tab_get_totals('M') := l_get_totals_empty_rec;
2874: l_tab_get_totals('C') := l_get_totals_empty_rec;
2875: l_tab_get_totals('P') := l_get_totals_empty_rec;
2876:
2877: hr_utility.set_location('After initializing l_tab_get_totals pltable ',3030);
2878:
2879: open cur_get_totals(l_payroll_action_id);
2880: loop
2881: fetch cur_get_totals into l_get_totals_rec;

Line 2883: hr_utility.set_location('Inside cursor cur_get_totals.',3031);

2879: open cur_get_totals(l_payroll_action_id);
2880: loop
2881: fetch cur_get_totals into l_get_totals_rec;
2882: EXIT WHEN cur_get_totals%NOTFOUND;
2883: hr_utility.set_location('Inside cursor cur_get_totals.',3031);
2884: l_tab_get_totals(l_get_totals_rec.ehecs_catg) := l_get_totals_rec;
2885: end loop;
2886: close cur_get_totals;
2887:

Line 2888: hr_utility.set_location('After cursor cur_get_totals ',3040);

2884: l_tab_get_totals(l_get_totals_rec.ehecs_catg) := l_get_totals_rec;
2885: end loop;
2886: close cur_get_totals;
2887:
2888: hr_utility.set_location('After cursor cur_get_totals ',3040);
2889:
2890: -- Override Values.
2891: l_tab_get_override_totals.delete;
2892: hr_utility.set_location('After deleting l_tab_get_override_totals pltable ',3050);

Line 2892: hr_utility.set_location('After deleting l_tab_get_override_totals pltable ',3050);

2888: hr_utility.set_location('After cursor cur_get_totals ',3040);
2889:
2890: -- Override Values.
2891: l_tab_get_override_totals.delete;
2892: hr_utility.set_location('After deleting l_tab_get_override_totals pltable ',3050);
2893:
2894: --Initializing to prevent the no data found error
2895: l_tab_get_override_totals('M') := l_get_ovrrd_tot_empty_rec;
2896: l_tab_get_override_totals('C') := l_get_ovrrd_tot_empty_rec;

Line 2899: hr_utility.set_location('After initializing l_tab_get_override_totals pltable ',3060);

2895: l_tab_get_override_totals('M') := l_get_ovrrd_tot_empty_rec;
2896: l_tab_get_override_totals('C') := l_get_ovrrd_tot_empty_rec;
2897: l_tab_get_override_totals('P') := l_get_ovrrd_tot_empty_rec;
2898:
2899: hr_utility.set_location('After initializing l_tab_get_override_totals pltable ',3060);
2900:
2901: open cur_get_override_totals(g_employer_id,g_business_group_id);
2902: loop
2903: fetch cur_get_override_totals into l_get_override_totals_rec;

Line 2905: hr_utility.set_location('Inside cursor cur_get_override_totals.',3061);

2901: open cur_get_override_totals(g_employer_id,g_business_group_id);
2902: loop
2903: fetch cur_get_override_totals into l_get_override_totals_rec;
2904: EXIT WHEN cur_get_override_totals%NOTFOUND;
2905: hr_utility.set_location('Inside cursor cur_get_override_totals.',3061);
2906: l_tab_get_override_totals(l_get_override_totals_rec.ehecs_catg) := l_get_override_totals_rec;
2907: end loop;
2908: close cur_get_override_totals;
2909:

Line 2910: hr_utility.set_location('After Cursor cur_get_override_totals ',3070);

2906: l_tab_get_override_totals(l_get_override_totals_rec.ehecs_catg) := l_get_override_totals_rec;
2907: end loop;
2908: close cur_get_override_totals;
2909:
2910: hr_utility.set_location('After Cursor cur_get_override_totals ',3070);
2911:
2912: OPEN csr_ehecs_eit(g_employer_id, g_business_group_id, g_year, g_quarter);
2913: FETCH csr_ehecs_eit INTO l_csr_ehecs_eit;
2914: CLOSE csr_ehecs_eit;

Line 2916: hr_utility.set_location('After Cursor csr_ehecs_eit ',3080);

2912: OPEN csr_ehecs_eit(g_employer_id, g_business_group_id, g_year, g_quarter);
2913: FETCH csr_ehecs_eit INTO l_csr_ehecs_eit;
2914: CLOSE csr_ehecs_eit;
2915:
2916: hr_utility.set_location('After Cursor csr_ehecs_eit ',3080);
2917:
2918: OPEN csr_part1_qtr_start;
2919: LOOP
2920: FETCH csr_part1_qtr_start INTO l_part1_qtr_start;

Line 2922: hr_utility.set_location('Inside Cursor csr_part1_qtr_start ',3085);

2918: OPEN csr_part1_qtr_start;
2919: LOOP
2920: FETCH csr_part1_qtr_start INTO l_part1_qtr_start;
2921: EXIT WHEN csr_part1_qtr_start%NOTFOUND;
2922: hr_utility.set_location('Inside Cursor csr_part1_qtr_start ',3085);
2923: hr_utility.set_location('l_part1_qtr_start.EMP_CATG '||l_part1_qtr_start.EMP_CATG,3086);
2924: hr_utility.set_location('l_part1_qtr_start.EHECS_CATG '||l_part1_qtr_start.EHECS_CATG,3087);
2925:
2926: IF l_part1_qtr_start.EMP_CATG = 'F' AND l_part1_qtr_start.EHECS_CATG = 'M' THEN

Line 2923: hr_utility.set_location('l_part1_qtr_start.EMP_CATG '||l_part1_qtr_start.EMP_CATG,3086);

2919: LOOP
2920: FETCH csr_part1_qtr_start INTO l_part1_qtr_start;
2921: EXIT WHEN csr_part1_qtr_start%NOTFOUND;
2922: hr_utility.set_location('Inside Cursor csr_part1_qtr_start ',3085);
2923: hr_utility.set_location('l_part1_qtr_start.EMP_CATG '||l_part1_qtr_start.EMP_CATG,3086);
2924: hr_utility.set_location('l_part1_qtr_start.EHECS_CATG '||l_part1_qtr_start.EHECS_CATG,3087);
2925:
2926: IF l_part1_qtr_start.EMP_CATG = 'F' AND l_part1_qtr_start.EHECS_CATG = 'M' THEN
2927: l_fst_ft_mg := l_part1_qtr_start.tot;

Line 2924: hr_utility.set_location('l_part1_qtr_start.EHECS_CATG '||l_part1_qtr_start.EHECS_CATG,3087);

2920: FETCH csr_part1_qtr_start INTO l_part1_qtr_start;
2921: EXIT WHEN csr_part1_qtr_start%NOTFOUND;
2922: hr_utility.set_location('Inside Cursor csr_part1_qtr_start ',3085);
2923: hr_utility.set_location('l_part1_qtr_start.EMP_CATG '||l_part1_qtr_start.EMP_CATG,3086);
2924: hr_utility.set_location('l_part1_qtr_start.EHECS_CATG '||l_part1_qtr_start.EHECS_CATG,3087);
2925:
2926: IF l_part1_qtr_start.EMP_CATG = 'F' AND l_part1_qtr_start.EHECS_CATG = 'M' THEN
2927: l_fst_ft_mg := l_part1_qtr_start.tot;
2928: ELSIF l_part1_qtr_start.EMP_CATG = 'F' AND l_part1_qtr_start.EHECS_CATG = 'C' THEN

Line 2942: hr_utility.set_location('l_fst_ft_mg'||l_fst_ft_mg,3085);

2938: END IF;
2939: END LOOP;
2940: CLOSE csr_part1_qtr_start;
2941:
2942: hr_utility.set_location('l_fst_ft_mg'||l_fst_ft_mg,3085);
2943: hr_utility.set_location('l_fst_ft_cl'||l_fst_ft_cl,3085);
2944: hr_utility.set_location('l_fst_ft_ot'||l_fst_ft_ot,3085);
2945: hr_utility.set_location('l_fst_pt_mg'||l_fst_pt_mg,3085);
2946: hr_utility.set_location('l_fst_pt_cl'||l_fst_pt_cl,3085);

Line 2943: hr_utility.set_location('l_fst_ft_cl'||l_fst_ft_cl,3085);

2939: END LOOP;
2940: CLOSE csr_part1_qtr_start;
2941:
2942: hr_utility.set_location('l_fst_ft_mg'||l_fst_ft_mg,3085);
2943: hr_utility.set_location('l_fst_ft_cl'||l_fst_ft_cl,3085);
2944: hr_utility.set_location('l_fst_ft_ot'||l_fst_ft_ot,3085);
2945: hr_utility.set_location('l_fst_pt_mg'||l_fst_pt_mg,3085);
2946: hr_utility.set_location('l_fst_pt_cl'||l_fst_pt_cl,3085);
2947: hr_utility.set_location('l_fst_pt_ot'||l_fst_pt_ot,3085);

Line 2944: hr_utility.set_location('l_fst_ft_ot'||l_fst_ft_ot,3085);

2940: CLOSE csr_part1_qtr_start;
2941:
2942: hr_utility.set_location('l_fst_ft_mg'||l_fst_ft_mg,3085);
2943: hr_utility.set_location('l_fst_ft_cl'||l_fst_ft_cl,3085);
2944: hr_utility.set_location('l_fst_ft_ot'||l_fst_ft_ot,3085);
2945: hr_utility.set_location('l_fst_pt_mg'||l_fst_pt_mg,3085);
2946: hr_utility.set_location('l_fst_pt_cl'||l_fst_pt_cl,3085);
2947: hr_utility.set_location('l_fst_pt_ot'||l_fst_pt_ot,3085);
2948:

Line 2945: hr_utility.set_location('l_fst_pt_mg'||l_fst_pt_mg,3085);

2941:
2942: hr_utility.set_location('l_fst_ft_mg'||l_fst_ft_mg,3085);
2943: hr_utility.set_location('l_fst_ft_cl'||l_fst_ft_cl,3085);
2944: hr_utility.set_location('l_fst_ft_ot'||l_fst_ft_ot,3085);
2945: hr_utility.set_location('l_fst_pt_mg'||l_fst_pt_mg,3085);
2946: hr_utility.set_location('l_fst_pt_cl'||l_fst_pt_cl,3085);
2947: hr_utility.set_location('l_fst_pt_ot'||l_fst_pt_ot,3085);
2948:
2949:

Line 2946: hr_utility.set_location('l_fst_pt_cl'||l_fst_pt_cl,3085);

2942: hr_utility.set_location('l_fst_ft_mg'||l_fst_ft_mg,3085);
2943: hr_utility.set_location('l_fst_ft_cl'||l_fst_ft_cl,3085);
2944: hr_utility.set_location('l_fst_ft_ot'||l_fst_ft_ot,3085);
2945: hr_utility.set_location('l_fst_pt_mg'||l_fst_pt_mg,3085);
2946: hr_utility.set_location('l_fst_pt_cl'||l_fst_pt_cl,3085);
2947: hr_utility.set_location('l_fst_pt_ot'||l_fst_pt_ot,3085);
2948:
2949:
2950: hr_utility.set_location('After Cursor csr_part1_qtr_start ',3090);

Line 2947: hr_utility.set_location('l_fst_pt_ot'||l_fst_pt_ot,3085);

2943: hr_utility.set_location('l_fst_ft_cl'||l_fst_ft_cl,3085);
2944: hr_utility.set_location('l_fst_ft_ot'||l_fst_ft_ot,3085);
2945: hr_utility.set_location('l_fst_pt_mg'||l_fst_pt_mg,3085);
2946: hr_utility.set_location('l_fst_pt_cl'||l_fst_pt_cl,3085);
2947: hr_utility.set_location('l_fst_pt_ot'||l_fst_pt_ot,3085);
2948:
2949:
2950: hr_utility.set_location('After Cursor csr_part1_qtr_start ',3090);
2951:

Line 2950: hr_utility.set_location('After Cursor csr_part1_qtr_start ',3090);

2946: hr_utility.set_location('l_fst_pt_cl'||l_fst_pt_cl,3085);
2947: hr_utility.set_location('l_fst_pt_ot'||l_fst_pt_ot,3085);
2948:
2949:
2950: hr_utility.set_location('After Cursor csr_part1_qtr_start ',3090);
2951:
2952: OPEN csr_part1_qtr_end;
2953: LOOP
2954: FETCH csr_part1_qtr_end INTO l_part1_qtr_end;

Line 2956: hr_utility.set_location('Inside Cursor csr_part1_qtr_end ',3091);

2952: OPEN csr_part1_qtr_end;
2953: LOOP
2954: FETCH csr_part1_qtr_end INTO l_part1_qtr_end;
2955: EXIT WHEN csr_part1_qtr_end%NOTFOUND;
2956: hr_utility.set_location('Inside Cursor csr_part1_qtr_end ',3091);
2957: hr_utility.set_location('l_part1_qtr_end.EMP_CATG '||l_part1_qtr_end.EMP_CATG,3092);
2958: hr_utility.set_location('l_part1_qtr_end.EHECS_CATG '||l_part1_qtr_end.EHECS_CATG,3093);
2959:
2960: IF l_part1_qtr_end.EMP_CATG = 'F' AND l_part1_qtr_end.EHECS_CATG = 'M' THEN

Line 2957: hr_utility.set_location('l_part1_qtr_end.EMP_CATG '||l_part1_qtr_end.EMP_CATG,3092);

2953: LOOP
2954: FETCH csr_part1_qtr_end INTO l_part1_qtr_end;
2955: EXIT WHEN csr_part1_qtr_end%NOTFOUND;
2956: hr_utility.set_location('Inside Cursor csr_part1_qtr_end ',3091);
2957: hr_utility.set_location('l_part1_qtr_end.EMP_CATG '||l_part1_qtr_end.EMP_CATG,3092);
2958: hr_utility.set_location('l_part1_qtr_end.EHECS_CATG '||l_part1_qtr_end.EHECS_CATG,3093);
2959:
2960: IF l_part1_qtr_end.EMP_CATG = 'F' AND l_part1_qtr_end.EHECS_CATG = 'M' THEN
2961: l_lst_ft_mg := l_part1_qtr_end.tot;

Line 2958: hr_utility.set_location('l_part1_qtr_end.EHECS_CATG '||l_part1_qtr_end.EHECS_CATG,3093);

2954: FETCH csr_part1_qtr_end INTO l_part1_qtr_end;
2955: EXIT WHEN csr_part1_qtr_end%NOTFOUND;
2956: hr_utility.set_location('Inside Cursor csr_part1_qtr_end ',3091);
2957: hr_utility.set_location('l_part1_qtr_end.EMP_CATG '||l_part1_qtr_end.EMP_CATG,3092);
2958: hr_utility.set_location('l_part1_qtr_end.EHECS_CATG '||l_part1_qtr_end.EHECS_CATG,3093);
2959:
2960: IF l_part1_qtr_end.EMP_CATG = 'F' AND l_part1_qtr_end.EHECS_CATG = 'M' THEN
2961: l_lst_ft_mg := l_part1_qtr_end.tot;
2962: ELSIF l_part1_qtr_end.EMP_CATG = 'F' AND l_part1_qtr_end.EHECS_CATG = 'C' THEN

Line 2976: hr_utility.set_location('l_lst_ft_mg'||l_lst_ft_mg,3095);

2972: END IF;
2973: END LOOP;
2974: CLOSE csr_part1_qtr_end;
2975:
2976: hr_utility.set_location('l_lst_ft_mg'||l_lst_ft_mg,3095);
2977: hr_utility.set_location('l_lst_ft_cl'||l_lst_ft_cl,3095);
2978: hr_utility.set_location('l_lst_ft_ot'||l_lst_ft_ot,3095);
2979: hr_utility.set_location('l_lst_pt_mg'||l_lst_pt_mg,3095);
2980: hr_utility.set_location('l_lst_pt_cl'||l_lst_pt_cl,3095);

Line 2977: hr_utility.set_location('l_lst_ft_cl'||l_lst_ft_cl,3095);

2973: END LOOP;
2974: CLOSE csr_part1_qtr_end;
2975:
2976: hr_utility.set_location('l_lst_ft_mg'||l_lst_ft_mg,3095);
2977: hr_utility.set_location('l_lst_ft_cl'||l_lst_ft_cl,3095);
2978: hr_utility.set_location('l_lst_ft_ot'||l_lst_ft_ot,3095);
2979: hr_utility.set_location('l_lst_pt_mg'||l_lst_pt_mg,3095);
2980: hr_utility.set_location('l_lst_pt_cl'||l_lst_pt_cl,3095);
2981: hr_utility.set_location('l_lst_pt_ot'||l_lst_pt_ot,3095);

Line 2978: hr_utility.set_location('l_lst_ft_ot'||l_lst_ft_ot,3095);

2974: CLOSE csr_part1_qtr_end;
2975:
2976: hr_utility.set_location('l_lst_ft_mg'||l_lst_ft_mg,3095);
2977: hr_utility.set_location('l_lst_ft_cl'||l_lst_ft_cl,3095);
2978: hr_utility.set_location('l_lst_ft_ot'||l_lst_ft_ot,3095);
2979: hr_utility.set_location('l_lst_pt_mg'||l_lst_pt_mg,3095);
2980: hr_utility.set_location('l_lst_pt_cl'||l_lst_pt_cl,3095);
2981: hr_utility.set_location('l_lst_pt_ot'||l_lst_pt_ot,3095);
2982:

Line 2979: hr_utility.set_location('l_lst_pt_mg'||l_lst_pt_mg,3095);

2975:
2976: hr_utility.set_location('l_lst_ft_mg'||l_lst_ft_mg,3095);
2977: hr_utility.set_location('l_lst_ft_cl'||l_lst_ft_cl,3095);
2978: hr_utility.set_location('l_lst_ft_ot'||l_lst_ft_ot,3095);
2979: hr_utility.set_location('l_lst_pt_mg'||l_lst_pt_mg,3095);
2980: hr_utility.set_location('l_lst_pt_cl'||l_lst_pt_cl,3095);
2981: hr_utility.set_location('l_lst_pt_ot'||l_lst_pt_ot,3095);
2982:
2983: hr_utility.set_location('After Cursor csr_part1_qtr_end ',3100);

Line 2980: hr_utility.set_location('l_lst_pt_cl'||l_lst_pt_cl,3095);

2976: hr_utility.set_location('l_lst_ft_mg'||l_lst_ft_mg,3095);
2977: hr_utility.set_location('l_lst_ft_cl'||l_lst_ft_cl,3095);
2978: hr_utility.set_location('l_lst_ft_ot'||l_lst_ft_ot,3095);
2979: hr_utility.set_location('l_lst_pt_mg'||l_lst_pt_mg,3095);
2980: hr_utility.set_location('l_lst_pt_cl'||l_lst_pt_cl,3095);
2981: hr_utility.set_location('l_lst_pt_ot'||l_lst_pt_ot,3095);
2982:
2983: hr_utility.set_location('After Cursor csr_part1_qtr_end ',3100);
2984:

Line 2981: hr_utility.set_location('l_lst_pt_ot'||l_lst_pt_ot,3095);

2977: hr_utility.set_location('l_lst_ft_cl'||l_lst_ft_cl,3095);
2978: hr_utility.set_location('l_lst_ft_ot'||l_lst_ft_ot,3095);
2979: hr_utility.set_location('l_lst_pt_mg'||l_lst_pt_mg,3095);
2980: hr_utility.set_location('l_lst_pt_cl'||l_lst_pt_cl,3095);
2981: hr_utility.set_location('l_lst_pt_ot'||l_lst_pt_ot,3095);
2982:
2983: hr_utility.set_location('After Cursor csr_part1_qtr_end ',3100);
2984:
2985: OPEN csr_part1_hire_qtr;

Line 2983: hr_utility.set_location('After Cursor csr_part1_qtr_end ',3100);

2979: hr_utility.set_location('l_lst_pt_mg'||l_lst_pt_mg,3095);
2980: hr_utility.set_location('l_lst_pt_cl'||l_lst_pt_cl,3095);
2981: hr_utility.set_location('l_lst_pt_ot'||l_lst_pt_ot,3095);
2982:
2983: hr_utility.set_location('After Cursor csr_part1_qtr_end ',3100);
2984:
2985: OPEN csr_part1_hire_qtr;
2986: LOOP
2987: FETCH csr_part1_hire_qtr INTO l_part1_hire_qtr;

Line 2989: hr_utility.set_location('Inside Cursor csr_part1_hire_qtr ',3101);

2985: OPEN csr_part1_hire_qtr;
2986: LOOP
2987: FETCH csr_part1_hire_qtr INTO l_part1_hire_qtr;
2988: EXIT WHEN csr_part1_hire_qtr%NOTFOUND;
2989: hr_utility.set_location('Inside Cursor csr_part1_hire_qtr ',3101);
2990: hr_utility.set_location('l_part1_hire_qtr.EMP_CATG '||l_part1_hire_qtr.EMP_CATG,3102);
2991: hr_utility.set_location('l_part1_hire_qtr.EHECS_CATG '||l_part1_hire_qtr.EHECS_CATG,3103);
2992:
2993: IF l_part1_hire_qtr.EMP_CATG = 'F' AND l_part1_hire_qtr.EHECS_CATG = 'M' THEN

Line 2990: hr_utility.set_location('l_part1_hire_qtr.EMP_CATG '||l_part1_hire_qtr.EMP_CATG,3102);

2986: LOOP
2987: FETCH csr_part1_hire_qtr INTO l_part1_hire_qtr;
2988: EXIT WHEN csr_part1_hire_qtr%NOTFOUND;
2989: hr_utility.set_location('Inside Cursor csr_part1_hire_qtr ',3101);
2990: hr_utility.set_location('l_part1_hire_qtr.EMP_CATG '||l_part1_hire_qtr.EMP_CATG,3102);
2991: hr_utility.set_location('l_part1_hire_qtr.EHECS_CATG '||l_part1_hire_qtr.EHECS_CATG,3103);
2992:
2993: IF l_part1_hire_qtr.EMP_CATG = 'F' AND l_part1_hire_qtr.EHECS_CATG = 'M' THEN
2994: l_hire_ft_mg := l_part1_hire_qtr.tot;

Line 2991: hr_utility.set_location('l_part1_hire_qtr.EHECS_CATG '||l_part1_hire_qtr.EHECS_CATG,3103);

2987: FETCH csr_part1_hire_qtr INTO l_part1_hire_qtr;
2988: EXIT WHEN csr_part1_hire_qtr%NOTFOUND;
2989: hr_utility.set_location('Inside Cursor csr_part1_hire_qtr ',3101);
2990: hr_utility.set_location('l_part1_hire_qtr.EMP_CATG '||l_part1_hire_qtr.EMP_CATG,3102);
2991: hr_utility.set_location('l_part1_hire_qtr.EHECS_CATG '||l_part1_hire_qtr.EHECS_CATG,3103);
2992:
2993: IF l_part1_hire_qtr.EMP_CATG = 'F' AND l_part1_hire_qtr.EHECS_CATG = 'M' THEN
2994: l_hire_ft_mg := l_part1_hire_qtr.tot;
2995: ELSIF l_part1_hire_qtr.EMP_CATG = 'F' AND l_part1_hire_qtr.EHECS_CATG = 'C' THEN

Line 3009: hr_utility.set_location('l_hire_ft_mg'||l_hire_ft_mg,3095);

3005: END IF;
3006: END LOOP;
3007: CLOSE csr_part1_hire_qtr;
3008:
3009: hr_utility.set_location('l_hire_ft_mg'||l_hire_ft_mg,3095);
3010: hr_utility.set_location('l_hire_ft_cl'||l_hire_ft_cl,3095);
3011: hr_utility.set_location('l_hire_ft_ot'||l_hire_ft_ot,3095);
3012: hr_utility.set_location('l_hire_pt_mg'||l_hire_pt_mg,3095);
3013: hr_utility.set_location('l_hire_pt_cl'||l_hire_pt_cl,3095);

Line 3010: hr_utility.set_location('l_hire_ft_cl'||l_hire_ft_cl,3095);

3006: END LOOP;
3007: CLOSE csr_part1_hire_qtr;
3008:
3009: hr_utility.set_location('l_hire_ft_mg'||l_hire_ft_mg,3095);
3010: hr_utility.set_location('l_hire_ft_cl'||l_hire_ft_cl,3095);
3011: hr_utility.set_location('l_hire_ft_ot'||l_hire_ft_ot,3095);
3012: hr_utility.set_location('l_hire_pt_mg'||l_hire_pt_mg,3095);
3013: hr_utility.set_location('l_hire_pt_cl'||l_hire_pt_cl,3095);
3014: hr_utility.set_location('l_hire_pt_ot'||l_hire_pt_ot,3095);

Line 3011: hr_utility.set_location('l_hire_ft_ot'||l_hire_ft_ot,3095);

3007: CLOSE csr_part1_hire_qtr;
3008:
3009: hr_utility.set_location('l_hire_ft_mg'||l_hire_ft_mg,3095);
3010: hr_utility.set_location('l_hire_ft_cl'||l_hire_ft_cl,3095);
3011: hr_utility.set_location('l_hire_ft_ot'||l_hire_ft_ot,3095);
3012: hr_utility.set_location('l_hire_pt_mg'||l_hire_pt_mg,3095);
3013: hr_utility.set_location('l_hire_pt_cl'||l_hire_pt_cl,3095);
3014: hr_utility.set_location('l_hire_pt_ot'||l_hire_pt_ot,3095);
3015:

Line 3012: hr_utility.set_location('l_hire_pt_mg'||l_hire_pt_mg,3095);

3008:
3009: hr_utility.set_location('l_hire_ft_mg'||l_hire_ft_mg,3095);
3010: hr_utility.set_location('l_hire_ft_cl'||l_hire_ft_cl,3095);
3011: hr_utility.set_location('l_hire_ft_ot'||l_hire_ft_ot,3095);
3012: hr_utility.set_location('l_hire_pt_mg'||l_hire_pt_mg,3095);
3013: hr_utility.set_location('l_hire_pt_cl'||l_hire_pt_cl,3095);
3014: hr_utility.set_location('l_hire_pt_ot'||l_hire_pt_ot,3095);
3015:
3016: hr_utility.set_location('After Cursor csr_part1_hire_qtr ',3110);

Line 3013: hr_utility.set_location('l_hire_pt_cl'||l_hire_pt_cl,3095);

3009: hr_utility.set_location('l_hire_ft_mg'||l_hire_ft_mg,3095);
3010: hr_utility.set_location('l_hire_ft_cl'||l_hire_ft_cl,3095);
3011: hr_utility.set_location('l_hire_ft_ot'||l_hire_ft_ot,3095);
3012: hr_utility.set_location('l_hire_pt_mg'||l_hire_pt_mg,3095);
3013: hr_utility.set_location('l_hire_pt_cl'||l_hire_pt_cl,3095);
3014: hr_utility.set_location('l_hire_pt_ot'||l_hire_pt_ot,3095);
3015:
3016: hr_utility.set_location('After Cursor csr_part1_hire_qtr ',3110);
3017:

Line 3014: hr_utility.set_location('l_hire_pt_ot'||l_hire_pt_ot,3095);

3010: hr_utility.set_location('l_hire_ft_cl'||l_hire_ft_cl,3095);
3011: hr_utility.set_location('l_hire_ft_ot'||l_hire_ft_ot,3095);
3012: hr_utility.set_location('l_hire_pt_mg'||l_hire_pt_mg,3095);
3013: hr_utility.set_location('l_hire_pt_cl'||l_hire_pt_cl,3095);
3014: hr_utility.set_location('l_hire_pt_ot'||l_hire_pt_ot,3095);
3015:
3016: hr_utility.set_location('After Cursor csr_part1_hire_qtr ',3110);
3017:
3018: l_cnt_app_mgr_final := 0;

Line 3016: hr_utility.set_location('After Cursor csr_part1_hire_qtr ',3110);

3012: hr_utility.set_location('l_hire_pt_mg'||l_hire_pt_mg,3095);
3013: hr_utility.set_location('l_hire_pt_cl'||l_hire_pt_cl,3095);
3014: hr_utility.set_location('l_hire_pt_ot'||l_hire_pt_ot,3095);
3015:
3016: hr_utility.set_location('After Cursor csr_part1_hire_qtr ',3110);
3017:
3018: l_cnt_app_mgr_final := 0;
3019: l_cnt_app_clk_final := 0;
3020: l_cnt_app_oth_final := 0;

Line 3022: hr_utility.set_location('Before Cursor csr_all_payrolls ',3130);

3018: l_cnt_app_mgr_final := 0;
3019: l_cnt_app_clk_final := 0;
3020: l_cnt_app_oth_final := 0;
3021:
3022: hr_utility.set_location('Before Cursor csr_all_payrolls ',3130);
3023:
3024: FOR pyr_index IN csr_all_payrolls
3025: LOOP
3026: hr_utility.set_location('Inside Cursor csr_all_payrolls ',3140);

Line 3026: hr_utility.set_location('Inside Cursor csr_all_payrolls ',3140);

3022: hr_utility.set_location('Before Cursor csr_all_payrolls ',3130);
3023:
3024: FOR pyr_index IN csr_all_payrolls
3025: LOOP
3026: hr_utility.set_location('Inside Cursor csr_all_payrolls ',3140);
3027: l_number_of_periods := 0;
3028: FOR prd_index IN csr_period_dates(pyr_index.payroll_id)
3029: LOOP
3030: hr_utility.set_location('Inside Cursor csr_period_dates ',3150);

Line 3030: hr_utility.set_location('Inside Cursor csr_period_dates ',3150);

3026: hr_utility.set_location('Inside Cursor csr_all_payrolls ',3140);
3027: l_number_of_periods := 0;
3028: FOR prd_index IN csr_period_dates(pyr_index.payroll_id)
3029: LOOP
3030: hr_utility.set_location('Inside Cursor csr_period_dates ',3150);
3031: hr_utility.set_location('l_number_of_periods '||l_number_of_periods,3150);
3032: l_number_of_periods := l_number_of_periods + 1;
3033: FOR asg_index IN csr_app_mgr_clk_pro(pyr_index.payroll_id, prd_index.pay_advice_date)
3034: LOOP

Line 3031: hr_utility.set_location('l_number_of_periods '||l_number_of_periods,3150);

3027: l_number_of_periods := 0;
3028: FOR prd_index IN csr_period_dates(pyr_index.payroll_id)
3029: LOOP
3030: hr_utility.set_location('Inside Cursor csr_period_dates ',3150);
3031: hr_utility.set_location('l_number_of_periods '||l_number_of_periods,3150);
3032: l_number_of_periods := l_number_of_periods + 1;
3033: FOR asg_index IN csr_app_mgr_clk_pro(pyr_index.payroll_id, prd_index.pay_advice_date)
3034: LOOP
3035: hr_utility.set_location('Inside Cursor csr_app_mgr_clk_pro ',3160);

Line 3035: hr_utility.set_location('Inside Cursor csr_app_mgr_clk_pro ',3160);

3031: hr_utility.set_location('l_number_of_periods '||l_number_of_periods,3150);
3032: l_number_of_periods := l_number_of_periods + 1;
3033: FOR asg_index IN csr_app_mgr_clk_pro(pyr_index.payroll_id, prd_index.pay_advice_date)
3034: LOOP
3035: hr_utility.set_location('Inside Cursor csr_app_mgr_clk_pro ',3160);
3036: hr_utility.set_location('asg_index.EHECS_CATG '||asg_index.EHECS_CATG,3160);
3037: hr_utility.set_location('l_cnt_app_mgr '||l_cnt_app_mgr,3160);
3038: hr_utility.set_location('l_cnt_app_clk '||l_cnt_app_clk,3160);
3039: hr_utility.set_location('l_cnt_app_oth '||l_cnt_app_oth,3160);

Line 3036: hr_utility.set_location('asg_index.EHECS_CATG '||asg_index.EHECS_CATG,3160);

3032: l_number_of_periods := l_number_of_periods + 1;
3033: FOR asg_index IN csr_app_mgr_clk_pro(pyr_index.payroll_id, prd_index.pay_advice_date)
3034: LOOP
3035: hr_utility.set_location('Inside Cursor csr_app_mgr_clk_pro ',3160);
3036: hr_utility.set_location('asg_index.EHECS_CATG '||asg_index.EHECS_CATG,3160);
3037: hr_utility.set_location('l_cnt_app_mgr '||l_cnt_app_mgr,3160);
3038: hr_utility.set_location('l_cnt_app_clk '||l_cnt_app_clk,3160);
3039: hr_utility.set_location('l_cnt_app_oth '||l_cnt_app_oth,3160);
3040: hr_utility.set_location('asg_index.tot '||asg_index.tot,3160);

Line 3037: hr_utility.set_location('l_cnt_app_mgr '||l_cnt_app_mgr,3160);

3033: FOR asg_index IN csr_app_mgr_clk_pro(pyr_index.payroll_id, prd_index.pay_advice_date)
3034: LOOP
3035: hr_utility.set_location('Inside Cursor csr_app_mgr_clk_pro ',3160);
3036: hr_utility.set_location('asg_index.EHECS_CATG '||asg_index.EHECS_CATG,3160);
3037: hr_utility.set_location('l_cnt_app_mgr '||l_cnt_app_mgr,3160);
3038: hr_utility.set_location('l_cnt_app_clk '||l_cnt_app_clk,3160);
3039: hr_utility.set_location('l_cnt_app_oth '||l_cnt_app_oth,3160);
3040: hr_utility.set_location('asg_index.tot '||asg_index.tot,3160);
3041:

Line 3038: hr_utility.set_location('l_cnt_app_clk '||l_cnt_app_clk,3160);

3034: LOOP
3035: hr_utility.set_location('Inside Cursor csr_app_mgr_clk_pro ',3160);
3036: hr_utility.set_location('asg_index.EHECS_CATG '||asg_index.EHECS_CATG,3160);
3037: hr_utility.set_location('l_cnt_app_mgr '||l_cnt_app_mgr,3160);
3038: hr_utility.set_location('l_cnt_app_clk '||l_cnt_app_clk,3160);
3039: hr_utility.set_location('l_cnt_app_oth '||l_cnt_app_oth,3160);
3040: hr_utility.set_location('asg_index.tot '||asg_index.tot,3160);
3041:
3042: IF asg_index.EHECS_CATG = 'M' THEN

Line 3039: hr_utility.set_location('l_cnt_app_oth '||l_cnt_app_oth,3160);

3035: hr_utility.set_location('Inside Cursor csr_app_mgr_clk_pro ',3160);
3036: hr_utility.set_location('asg_index.EHECS_CATG '||asg_index.EHECS_CATG,3160);
3037: hr_utility.set_location('l_cnt_app_mgr '||l_cnt_app_mgr,3160);
3038: hr_utility.set_location('l_cnt_app_clk '||l_cnt_app_clk,3160);
3039: hr_utility.set_location('l_cnt_app_oth '||l_cnt_app_oth,3160);
3040: hr_utility.set_location('asg_index.tot '||asg_index.tot,3160);
3041:
3042: IF asg_index.EHECS_CATG = 'M' THEN
3043: l_cnt_app_mgr := l_cnt_app_mgr + asg_index.tot;

Line 3040: hr_utility.set_location('asg_index.tot '||asg_index.tot,3160);

3036: hr_utility.set_location('asg_index.EHECS_CATG '||asg_index.EHECS_CATG,3160);
3037: hr_utility.set_location('l_cnt_app_mgr '||l_cnt_app_mgr,3160);
3038: hr_utility.set_location('l_cnt_app_clk '||l_cnt_app_clk,3160);
3039: hr_utility.set_location('l_cnt_app_oth '||l_cnt_app_oth,3160);
3040: hr_utility.set_location('asg_index.tot '||asg_index.tot,3160);
3041:
3042: IF asg_index.EHECS_CATG = 'M' THEN
3043: l_cnt_app_mgr := l_cnt_app_mgr + asg_index.tot;
3044: ELSIF asg_index.EHECS_CATG = 'C' THEN

Line 3053: hr_utility.set_location('Inside IF l_number_of_periods > 0 before ',3170);

3049: END LOOP;
3050: END LOOP;
3051:
3052: IF l_number_of_periods > 0 THEN
3053: hr_utility.set_location('Inside IF l_number_of_periods > 0 before ',3170);
3054: hr_utility.set_location('l_cnt_app_mgr_final '||l_cnt_app_mgr_final,3170);
3055: hr_utility.set_location('l_cnt_app_mgr '||l_cnt_app_mgr,3170);
3056:
3057: hr_utility.set_location('l_cnt_app_clk_final '||l_cnt_app_clk_final,3170);

Line 3054: hr_utility.set_location('l_cnt_app_mgr_final '||l_cnt_app_mgr_final,3170);

3050: END LOOP;
3051:
3052: IF l_number_of_periods > 0 THEN
3053: hr_utility.set_location('Inside IF l_number_of_periods > 0 before ',3170);
3054: hr_utility.set_location('l_cnt_app_mgr_final '||l_cnt_app_mgr_final,3170);
3055: hr_utility.set_location('l_cnt_app_mgr '||l_cnt_app_mgr,3170);
3056:
3057: hr_utility.set_location('l_cnt_app_clk_final '||l_cnt_app_clk_final,3170);
3058: hr_utility.set_location('l_cnt_app_clk '||l_cnt_app_clk,3170);

Line 3055: hr_utility.set_location('l_cnt_app_mgr '||l_cnt_app_mgr,3170);

3051:
3052: IF l_number_of_periods > 0 THEN
3053: hr_utility.set_location('Inside IF l_number_of_periods > 0 before ',3170);
3054: hr_utility.set_location('l_cnt_app_mgr_final '||l_cnt_app_mgr_final,3170);
3055: hr_utility.set_location('l_cnt_app_mgr '||l_cnt_app_mgr,3170);
3056:
3057: hr_utility.set_location('l_cnt_app_clk_final '||l_cnt_app_clk_final,3170);
3058: hr_utility.set_location('l_cnt_app_clk '||l_cnt_app_clk,3170);
3059:

Line 3057: hr_utility.set_location('l_cnt_app_clk_final '||l_cnt_app_clk_final,3170);

3053: hr_utility.set_location('Inside IF l_number_of_periods > 0 before ',3170);
3054: hr_utility.set_location('l_cnt_app_mgr_final '||l_cnt_app_mgr_final,3170);
3055: hr_utility.set_location('l_cnt_app_mgr '||l_cnt_app_mgr,3170);
3056:
3057: hr_utility.set_location('l_cnt_app_clk_final '||l_cnt_app_clk_final,3170);
3058: hr_utility.set_location('l_cnt_app_clk '||l_cnt_app_clk,3170);
3059:
3060: hr_utility.set_location('l_cnt_app_oth_final '||l_cnt_app_oth_final,3170);
3061: hr_utility.set_location('l_cnt_app_oth '||l_cnt_app_oth,3170);

Line 3058: hr_utility.set_location('l_cnt_app_clk '||l_cnt_app_clk,3170);

3054: hr_utility.set_location('l_cnt_app_mgr_final '||l_cnt_app_mgr_final,3170);
3055: hr_utility.set_location('l_cnt_app_mgr '||l_cnt_app_mgr,3170);
3056:
3057: hr_utility.set_location('l_cnt_app_clk_final '||l_cnt_app_clk_final,3170);
3058: hr_utility.set_location('l_cnt_app_clk '||l_cnt_app_clk,3170);
3059:
3060: hr_utility.set_location('l_cnt_app_oth_final '||l_cnt_app_oth_final,3170);
3061: hr_utility.set_location('l_cnt_app_oth '||l_cnt_app_oth,3170);
3062:

Line 3060: hr_utility.set_location('l_cnt_app_oth_final '||l_cnt_app_oth_final,3170);

3056:
3057: hr_utility.set_location('l_cnt_app_clk_final '||l_cnt_app_clk_final,3170);
3058: hr_utility.set_location('l_cnt_app_clk '||l_cnt_app_clk,3170);
3059:
3060: hr_utility.set_location('l_cnt_app_oth_final '||l_cnt_app_oth_final,3170);
3061: hr_utility.set_location('l_cnt_app_oth '||l_cnt_app_oth,3170);
3062:
3063: l_cnt_app_mgr_final := l_cnt_app_mgr_final + ROUND(l_cnt_app_mgr/l_number_of_periods);
3064: l_cnt_app_clk_final := l_cnt_app_clk_final + ROUND(l_cnt_app_clk/l_number_of_periods);

Line 3061: hr_utility.set_location('l_cnt_app_oth '||l_cnt_app_oth,3170);

3057: hr_utility.set_location('l_cnt_app_clk_final '||l_cnt_app_clk_final,3170);
3058: hr_utility.set_location('l_cnt_app_clk '||l_cnt_app_clk,3170);
3059:
3060: hr_utility.set_location('l_cnt_app_oth_final '||l_cnt_app_oth_final,3170);
3061: hr_utility.set_location('l_cnt_app_oth '||l_cnt_app_oth,3170);
3062:
3063: l_cnt_app_mgr_final := l_cnt_app_mgr_final + ROUND(l_cnt_app_mgr/l_number_of_periods);
3064: l_cnt_app_clk_final := l_cnt_app_clk_final + ROUND(l_cnt_app_clk/l_number_of_periods);
3065: l_cnt_app_oth_final := l_cnt_app_oth_final + ROUND(l_cnt_app_oth/l_number_of_periods);

Line 3067: hr_utility.set_location('Inside IF l_number_of_periods > 0 after ',3170);

3063: l_cnt_app_mgr_final := l_cnt_app_mgr_final + ROUND(l_cnt_app_mgr/l_number_of_periods);
3064: l_cnt_app_clk_final := l_cnt_app_clk_final + ROUND(l_cnt_app_clk/l_number_of_periods);
3065: l_cnt_app_oth_final := l_cnt_app_oth_final + ROUND(l_cnt_app_oth/l_number_of_periods);
3066:
3067: hr_utility.set_location('Inside IF l_number_of_periods > 0 after ',3170);
3068: hr_utility.set_location('l_cnt_app_mgr_final '||l_cnt_app_mgr_final,3170);
3069: hr_utility.set_location('l_cnt_app_clk_final '||l_cnt_app_clk_final,3170);
3070: hr_utility.set_location('l_cnt_app_oth_final '||l_cnt_app_oth_final,3170);
3071: END IF;

Line 3068: hr_utility.set_location('l_cnt_app_mgr_final '||l_cnt_app_mgr_final,3170);

3064: l_cnt_app_clk_final := l_cnt_app_clk_final + ROUND(l_cnt_app_clk/l_number_of_periods);
3065: l_cnt_app_oth_final := l_cnt_app_oth_final + ROUND(l_cnt_app_oth/l_number_of_periods);
3066:
3067: hr_utility.set_location('Inside IF l_number_of_periods > 0 after ',3170);
3068: hr_utility.set_location('l_cnt_app_mgr_final '||l_cnt_app_mgr_final,3170);
3069: hr_utility.set_location('l_cnt_app_clk_final '||l_cnt_app_clk_final,3170);
3070: hr_utility.set_location('l_cnt_app_oth_final '||l_cnt_app_oth_final,3170);
3071: END IF;
3072:

Line 3069: hr_utility.set_location('l_cnt_app_clk_final '||l_cnt_app_clk_final,3170);

3065: l_cnt_app_oth_final := l_cnt_app_oth_final + ROUND(l_cnt_app_oth/l_number_of_periods);
3066:
3067: hr_utility.set_location('Inside IF l_number_of_periods > 0 after ',3170);
3068: hr_utility.set_location('l_cnt_app_mgr_final '||l_cnt_app_mgr_final,3170);
3069: hr_utility.set_location('l_cnt_app_clk_final '||l_cnt_app_clk_final,3170);
3070: hr_utility.set_location('l_cnt_app_oth_final '||l_cnt_app_oth_final,3170);
3071: END IF;
3072:
3073: END LOOP;

Line 3070: hr_utility.set_location('l_cnt_app_oth_final '||l_cnt_app_oth_final,3170);

3066:
3067: hr_utility.set_location('Inside IF l_number_of_periods > 0 after ',3170);
3068: hr_utility.set_location('l_cnt_app_mgr_final '||l_cnt_app_mgr_final,3170);
3069: hr_utility.set_location('l_cnt_app_clk_final '||l_cnt_app_clk_final,3170);
3070: hr_utility.set_location('l_cnt_app_oth_final '||l_cnt_app_oth_final,3170);
3071: END IF;
3072:
3073: END LOOP;
3074:

Line 3076: hr_utility.set_location('l_payroll_action_id. '||TO_CHAR(l_payroll_action_id),3180);

3072:
3073: END LOOP;
3074:
3075:
3076: hr_utility.set_location('l_payroll_action_id. '||TO_CHAR(l_payroll_action_id),3180);
3077: hr_utility.set_location('Before Inserting IE_EHECS_PART1 ',3190);
3078:
3079: pay_action_information_api.create_action_information
3080: ( p_action_information_id => l_action_info_id

Line 3077: hr_utility.set_location('Before Inserting IE_EHECS_PART1 ',3190);

3073: END LOOP;
3074:
3075:
3076: hr_utility.set_location('l_payroll_action_id. '||TO_CHAR(l_payroll_action_id),3180);
3077: hr_utility.set_location('Before Inserting IE_EHECS_PART1 ',3190);
3078:
3079: pay_action_information_api.create_action_information
3080: ( p_action_information_id => l_action_info_id
3081: ,p_action_context_id => l_payroll_action_id

Line 3120: hr_utility.set_location('After Inserting IE_EHECS_PART1 ',3200);

3116: ,p_action_information29 => NVL(l_tab_get_override_totals('C').l_sum_nmw,l_tab_get_totals('C').nmw_pt_ft_mg_cl_ot)
3117: ,p_action_information30 => NVL(l_tab_get_override_totals('P').l_sum_nmw,l_tab_get_totals('P').nmw_pt_ft_mg_cl_ot)
3118: );
3119:
3120: hr_utility.set_location('After Inserting IE_EHECS_PART1 ',3200);
3121:
3122: l_appwgmg := NVL(l_tab_get_override_totals('M').l_sum_regwg_at,NVL(l_tab_get_totals('M').regwg_at_mg_cl_ot,0))
3123: + NVL(l_tab_get_override_totals('M').l_sum_ovrt_at,NVL(l_tab_get_totals('M').ovrt_at_mg_cl_ot,0))
3124: + NVL(l_tab_get_override_totals('M').l_sum_irrb_at,NVL(l_tab_get_totals('M').irrb_at_mg_cl_ot,0));

Line 3134: hr_utility.set_location('Before Inserting IE_EHECS_PART2 ',3210);

3130: l_appwgot := NVL(l_tab_get_override_totals('P').l_sum_regwg_at,NVL(l_tab_get_totals('P').regwg_at_mg_cl_ot,0))
3131: + NVL(l_tab_get_override_totals('P').l_sum_ovrt_at,NVL(l_tab_get_totals('P').ovrt_at_mg_cl_ot,0))
3132: + NVL(l_tab_get_override_totals('P').l_sum_irrb_at,NVL(l_tab_get_totals('P').irrb_at_mg_cl_ot,0));
3133:
3134: hr_utility.set_location('Before Inserting IE_EHECS_PART2 ',3210);
3135:
3136: pay_action_information_api.create_action_information
3137: ( p_action_information_id => l_action_info_id
3138: ,p_action_context_id => l_payroll_action_id

Line 3168: hr_utility.set_location('After Inserting IE_EHECS_PART2 ',3220);

3164: ,p_action_information20 => l_appwgcl
3165: ,p_action_information21 => l_appwgot
3166: );
3167:
3168: hr_utility.set_location('After Inserting IE_EHECS_PART2 ',3220);
3169:
3170: pay_action_information_api.create_action_information
3171: ( p_action_information_id => l_action_info_id
3172: ,p_action_context_id => l_payroll_action_id

Line 3199: hr_utility.set_location('After Inserting IE_EHECS_PART3 ',3230);

3195: ,p_action_information17 => NVL(l_tab_get_override_totals('C').l_sum_othr_at,NVL(l_tab_get_totals('C').othr_at_mg_cl_ot,0))
3196: ,p_action_information18 => NVL(l_tab_get_override_totals('P').l_sum_othr_at,NVL(l_tab_get_totals('P').othr_at_mg_cl_ot,0))
3197: );
3198:
3199: hr_utility.set_location('After Inserting IE_EHECS_PART3 ',3230);
3200:
3201: /* 6856473 */
3202: hr_utility.set_location(' l_tab_get_totals:M.al_at_mg_cl_ot ' || l_tab_get_totals('M').al_at_mg_cl_ot,3230);
3203: hr_utility.set_location(' l_tab_get_totals:C.al_at_mg_cl_ot ' || l_tab_get_totals('C').al_at_mg_cl_ot,3230);

Line 3202: hr_utility.set_location(' l_tab_get_totals:M.al_at_mg_cl_ot ' || l_tab_get_totals('M').al_at_mg_cl_ot,3230);

3198:
3199: hr_utility.set_location('After Inserting IE_EHECS_PART3 ',3230);
3200:
3201: /* 6856473 */
3202: hr_utility.set_location(' l_tab_get_totals:M.al_at_mg_cl_ot ' || l_tab_get_totals('M').al_at_mg_cl_ot,3230);
3203: hr_utility.set_location(' l_tab_get_totals:C.al_at_mg_cl_ot ' || l_tab_get_totals('C').al_at_mg_cl_ot,3230);
3204: hr_utility.set_location(' l_tab_get_totals:P.al_at_mg_cl_ot ' || l_tab_get_totals('P').al_at_mg_cl_ot,3230);
3205:
3206:

Line 3203: hr_utility.set_location(' l_tab_get_totals:C.al_at_mg_cl_ot ' || l_tab_get_totals('C').al_at_mg_cl_ot,3230);

3199: hr_utility.set_location('After Inserting IE_EHECS_PART3 ',3230);
3200:
3201: /* 6856473 */
3202: hr_utility.set_location(' l_tab_get_totals:M.al_at_mg_cl_ot ' || l_tab_get_totals('M').al_at_mg_cl_ot,3230);
3203: hr_utility.set_location(' l_tab_get_totals:C.al_at_mg_cl_ot ' || l_tab_get_totals('C').al_at_mg_cl_ot,3230);
3204: hr_utility.set_location(' l_tab_get_totals:P.al_at_mg_cl_ot ' || l_tab_get_totals('P').al_at_mg_cl_ot,3230);
3205:
3206:
3207: l_lapmg := NVL(l_tab_get_override_totals('M').l_sum_al_at,NVL(l_tab_get_totals('M').al_at_mg_cl_ot,0)) -- 6856473

Line 3204: hr_utility.set_location(' l_tab_get_totals:P.al_at_mg_cl_ot ' || l_tab_get_totals('P').al_at_mg_cl_ot,3230);

3200:
3201: /* 6856473 */
3202: hr_utility.set_location(' l_tab_get_totals:M.al_at_mg_cl_ot ' || l_tab_get_totals('M').al_at_mg_cl_ot,3230);
3203: hr_utility.set_location(' l_tab_get_totals:C.al_at_mg_cl_ot ' || l_tab_get_totals('C').al_at_mg_cl_ot,3230);
3204: hr_utility.set_location(' l_tab_get_totals:P.al_at_mg_cl_ot ' || l_tab_get_totals('P').al_at_mg_cl_ot,3230);
3205:
3206:
3207: l_lapmg := NVL(l_tab_get_override_totals('M').l_sum_al_at,NVL(l_tab_get_totals('M').al_at_mg_cl_ot,0)) -- 6856473
3208: + NVL(l_tab_get_override_totals('M').l_sum_mat_at,NVL(l_tab_get_totals('M').mat_at_mg_cl_ot,0))

Line 3222: hr_utility.set_location('Before Inserting IE_EHECS_PART4 ',3240);

3218: + NVL(l_tab_get_override_totals('P').l_sum_mat_at,NVL(l_tab_get_totals('P').mat_at_mg_cl_ot,0))
3219: + NVL(l_tab_get_override_totals('P').l_sum_sic_at,NVL(l_tab_get_totals('P').sic_at_mg_cl_ot,0))
3220: + NVL(l_tab_get_override_totals('P').l_sum_otl_at,NVL(l_tab_get_totals('P').otl_at_mg_cl_ot,0));
3221:
3222: hr_utility.set_location('Before Inserting IE_EHECS_PART4 ',3240);
3223:
3224: /* 6856473 */
3225: hr_utility.set_location(' l_tab_get_totals:M.al_ft_mg_cl_ot ' || l_tab_get_totals('M').al_ft_mg_cl_ot,3230);
3226: hr_utility.set_location(' l_tab_get_totals:C.al_ft_mg_cl_ot ' || l_tab_get_totals('C').al_ft_mg_cl_ot,3230);

Line 3225: hr_utility.set_location(' l_tab_get_totals:M.al_ft_mg_cl_ot ' || l_tab_get_totals('M').al_ft_mg_cl_ot,3230);

3221:
3222: hr_utility.set_location('Before Inserting IE_EHECS_PART4 ',3240);
3223:
3224: /* 6856473 */
3225: hr_utility.set_location(' l_tab_get_totals:M.al_ft_mg_cl_ot ' || l_tab_get_totals('M').al_ft_mg_cl_ot,3230);
3226: hr_utility.set_location(' l_tab_get_totals:C.al_ft_mg_cl_ot ' || l_tab_get_totals('C').al_ft_mg_cl_ot,3230);
3227: hr_utility.set_location(' l_tab_get_totals:P.al_ft_mg_cl_ot ' || l_tab_get_totals('P').al_ft_mg_cl_ot,3230);
3228:
3229:

Line 3226: hr_utility.set_location(' l_tab_get_totals:C.al_ft_mg_cl_ot ' || l_tab_get_totals('C').al_ft_mg_cl_ot,3230);

3222: hr_utility.set_location('Before Inserting IE_EHECS_PART4 ',3240);
3223:
3224: /* 6856473 */
3225: hr_utility.set_location(' l_tab_get_totals:M.al_ft_mg_cl_ot ' || l_tab_get_totals('M').al_ft_mg_cl_ot,3230);
3226: hr_utility.set_location(' l_tab_get_totals:C.al_ft_mg_cl_ot ' || l_tab_get_totals('C').al_ft_mg_cl_ot,3230);
3227: hr_utility.set_location(' l_tab_get_totals:P.al_ft_mg_cl_ot ' || l_tab_get_totals('P').al_ft_mg_cl_ot,3230);
3228:
3229:
3230: hr_utility.set_location(' l_tab_get_totals:M.al_pt_mg_cl_ot ' || l_tab_get_totals('M').al_pt_mg_cl_ot,3230);

Line 3227: hr_utility.set_location(' l_tab_get_totals:P.al_ft_mg_cl_ot ' || l_tab_get_totals('P').al_ft_mg_cl_ot,3230);

3223:
3224: /* 6856473 */
3225: hr_utility.set_location(' l_tab_get_totals:M.al_ft_mg_cl_ot ' || l_tab_get_totals('M').al_ft_mg_cl_ot,3230);
3226: hr_utility.set_location(' l_tab_get_totals:C.al_ft_mg_cl_ot ' || l_tab_get_totals('C').al_ft_mg_cl_ot,3230);
3227: hr_utility.set_location(' l_tab_get_totals:P.al_ft_mg_cl_ot ' || l_tab_get_totals('P').al_ft_mg_cl_ot,3230);
3228:
3229:
3230: hr_utility.set_location(' l_tab_get_totals:M.al_pt_mg_cl_ot ' || l_tab_get_totals('M').al_pt_mg_cl_ot,3230);
3231: hr_utility.set_location(' l_tab_get_totals:C.al_pt_mg_cl_ot ' || l_tab_get_totals('C').al_pt_mg_cl_ot,3230);

Line 3230: hr_utility.set_location(' l_tab_get_totals:M.al_pt_mg_cl_ot ' || l_tab_get_totals('M').al_pt_mg_cl_ot,3230);

3226: hr_utility.set_location(' l_tab_get_totals:C.al_ft_mg_cl_ot ' || l_tab_get_totals('C').al_ft_mg_cl_ot,3230);
3227: hr_utility.set_location(' l_tab_get_totals:P.al_ft_mg_cl_ot ' || l_tab_get_totals('P').al_ft_mg_cl_ot,3230);
3228:
3229:
3230: hr_utility.set_location(' l_tab_get_totals:M.al_pt_mg_cl_ot ' || l_tab_get_totals('M').al_pt_mg_cl_ot,3230);
3231: hr_utility.set_location(' l_tab_get_totals:C.al_pt_mg_cl_ot ' || l_tab_get_totals('C').al_pt_mg_cl_ot,3230);
3232: hr_utility.set_location(' l_tab_get_totals:Pal_pt_mg_cl_ot ' || l_tab_get_totals('P').al_pt_mg_cl_ot,3230);
3233: pay_action_information_api.create_action_information
3234: ( p_action_information_id => l_action_info_id

Line 3231: hr_utility.set_location(' l_tab_get_totals:C.al_pt_mg_cl_ot ' || l_tab_get_totals('C').al_pt_mg_cl_ot,3230);

3227: hr_utility.set_location(' l_tab_get_totals:P.al_ft_mg_cl_ot ' || l_tab_get_totals('P').al_ft_mg_cl_ot,3230);
3228:
3229:
3230: hr_utility.set_location(' l_tab_get_totals:M.al_pt_mg_cl_ot ' || l_tab_get_totals('M').al_pt_mg_cl_ot,3230);
3231: hr_utility.set_location(' l_tab_get_totals:C.al_pt_mg_cl_ot ' || l_tab_get_totals('C').al_pt_mg_cl_ot,3230);
3232: hr_utility.set_location(' l_tab_get_totals:Pal_pt_mg_cl_ot ' || l_tab_get_totals('P').al_pt_mg_cl_ot,3230);
3233: pay_action_information_api.create_action_information
3234: ( p_action_information_id => l_action_info_id
3235: ,p_action_context_id => l_payroll_action_id

Line 3232: hr_utility.set_location(' l_tab_get_totals:Pal_pt_mg_cl_ot ' || l_tab_get_totals('P').al_pt_mg_cl_ot,3230);

3228:
3229:
3230: hr_utility.set_location(' l_tab_get_totals:M.al_pt_mg_cl_ot ' || l_tab_get_totals('M').al_pt_mg_cl_ot,3230);
3231: hr_utility.set_location(' l_tab_get_totals:C.al_pt_mg_cl_ot ' || l_tab_get_totals('C').al_pt_mg_cl_ot,3230);
3232: hr_utility.set_location(' l_tab_get_totals:Pal_pt_mg_cl_ot ' || l_tab_get_totals('P').al_pt_mg_cl_ot,3230);
3233: pay_action_information_api.create_action_information
3234: ( p_action_information_id => l_action_info_id
3235: ,p_action_context_id => l_payroll_action_id
3236: ,p_action_context_type => 'PA'

Line 3271: hr_utility.set_location('After Inserting IE_EHECS_PART4 ',3250);

3267: ,p_action_information26 => l_lapcl
3268: ,p_action_information27 => l_lapot
3269: );
3270:
3271: hr_utility.set_location('After Inserting IE_EHECS_PART4 ',3250);
3272:
3273: l_ssecapmg := NVL(l_tab_get_totals('M').prsi_at_mg_cl_ot,0)
3274: + NVL(l_tab_get_override_totals('M').l_sum_incc_at,NVL(l_tab_get_totals('M').incct_at_mg_cl_ot,0))
3275: + NVL(l_tab_get_override_totals('M').l_sum_red_at,NVL(l_tab_get_totals('M').red_at_mg_cl_ot,0))

Line 3288: hr_utility.set_location('Before Inserting IE_EHECS_PART7 ',3260);

3284: + NVL(l_tab_get_override_totals('P').l_sum_incc_at,NVL(l_tab_get_totals('P').incct_at_mg_cl_ot,0))
3285: + NVL(l_tab_get_override_totals('P').l_sum_red_at,NVL(l_tab_get_totals('P').red_at_mg_cl_ot,0))
3286: + NVL(l_tab_get_override_totals('P').l_sum_otsoc_at,NVL(l_tab_get_totals('P').otsoc_at_mg_cl_ot,0));
3287:
3288: hr_utility.set_location('Before Inserting IE_EHECS_PART7 ',3260);
3289:
3290: pay_action_information_api.create_action_information
3291: ( p_action_information_id => l_action_info_id
3292: ,p_action_context_id => l_payroll_action_id

Line 3316: hr_utility.set_location('After Inserting IE_EHECS_PART7 ',3270);

3312: ,p_action_information14 => l_ssecapcl
3313: ,p_action_information15 => l_ssecapot
3314: );
3315:
3316: hr_utility.set_location('After Inserting IE_EHECS_PART7 ',3270);
3317:
3318: pay_action_information_api.create_action_information
3319: ( p_action_information_id => l_action_info_id
3320: ,p_action_context_id => l_payroll_action_id

Line 3344: hr_utility.set_location('After Inserting IE_EHECS_PART8 ',3270);

3340: ,p_action_information14 => NVL(l_tab_get_override_totals('C').l_sum_otben_ft,NVL(l_tab_get_totals('C').otben_pt_ft_mg_cl_ot,0))
3341: ,p_action_information15 => NVL(l_tab_get_override_totals('P').l_sum_otben_ft,NVL(l_tab_get_totals('P').otben_pt_ft_mg_cl_ot,0))
3342: );
3343:
3344: hr_utility.set_location('After Inserting IE_EHECS_PART8 ',3270);
3345:
3346: pay_action_information_api.create_action_information
3347: ( p_action_information_id => l_action_info_id
3348: ,p_action_context_id => l_payroll_action_id

Line 3369: hr_utility.set_location('After Inserting IE_EHECS_ALL_OTHER ',3280);

3365: ,p_action_information11 => NULL -- not used
3366: ,p_action_information12 => NULL -- not used
3367: );
3368:
3369: hr_utility.set_location('After Inserting IE_EHECS_ALL_OTHER ',3280);
3370:
3371: OPEN c_get_part1(l_payroll_action_id);
3372: FETCH c_get_part1 INTO l_data_part1;
3373: CLOSE c_get_part1;

Line 3399: hr_utility.set_location('After Fetching ALL Cursors.',3280);

3395: OPEN c_get_part_all_other(l_payroll_action_id);
3396: FETCH c_get_part_all_other INTO l_data_part_all_other;
3397: CLOSE c_get_part_all_other;
3398:
3399: hr_utility.set_location('After Fetching ALL Cursors.',3280);
3400:
3401: --for l_data_part1 in c_get_part1(l_payroll_action_id)
3402: --loop
3403:

Line 5008: hr_utility.set_location('Before completing the l_data_part1: length(l_string) = '||length(l_string),3300);

5004: l_string:=l_string || '' || l_data_part1.l_min_paid_ot || '';
5005:
5006: --end loop;
5007:
5008: hr_utility.set_location('Before completing the l_data_part1: length(l_string) = '||length(l_string),3300);
5009: l_clob := l_clob||l_string;
5010:
5011: IF l_clob IS NOT NULL THEN
5012: l_blob := c2b(l_clob);

Line 5021: hr_utility.set_location('entering c_get_part2 ',280);

5017: l_clob:='';
5018:
5019: --for l_data_part2 in c_get_part2(l_payroll_action_id)
5020: --loop
5021: hr_utility.set_location('entering c_get_part2 ',280);
5022: l_string:=l_string || '' || l_data_part2.l_reg_wg_ft_mg || '';
5023: l_string:=l_string || '' || l_data_part2.l_reg_wg_ft_cl || '';
5024: l_string:=l_string || '' || l_data_part2.l_reg_wg_ft_ot || '';
5025: l_string:=l_string || '' || l_data_part2.l_ot_paid_ft_mg || '';

Line 5045: hr_utility.set_location('Before completing the l_data_part2: length(l_string) = '||length(l_string),3310);

5041: l_string:=l_string || '' || l_data_part2.l_tot_wg_app_cl || '';
5042: l_string:=l_string || '' || l_data_part2.l_tot_wg_app_ot || '';
5043: -- end loop;
5044:
5045: hr_utility.set_location('Before completing the l_data_part2: length(l_string) = '||length(l_string),3310);
5046: l_clob := l_clob||l_string;
5047:
5048: IF l_clob IS NOT NULL THEN
5049: l_blob := c2b(l_clob);

Line 5057: hr_utility.set_location('entering c_get_part3 ',280);

5053: l_string:='';
5054: l_clob:='';
5055: --for l_data_part3 in c_get_part3(l_payroll_action_id)
5056: --loop
5057: hr_utility.set_location('entering c_get_part3 ',280);
5058: l_string:=l_string || '' || l_data_part3.l_contracted_hrs_paid_ft_mg || '';
5059: l_string:=l_string || '' || l_data_part3.l_contracted_hrs_paid_ft_cl || '';
5060: l_string:=l_string || '' || l_data_part3.l_contracted_hrs_paid_ft_ot || '';
5061: l_string:=l_string || '' || l_data_part3.l_ot_hrs_paid_ft_mg || '';

Line 5078: hr_utility.set_location('Before completing the l_data_part3: length(l_string) = '||length(l_string),3320);

5074: l_string:=l_string || '' || l_data_part3.l_ot_hrs_paid_app_cl || '';
5075: l_string:=l_string || '' || l_data_part3.l_ot_hrs_paid_app_ot || '';
5076: -- end loop;
5077:
5078: hr_utility.set_location('Before completing the l_data_part3: length(l_string) = '||length(l_string),3320);
5079: l_clob := l_clob||l_string;
5080:
5081: IF l_clob IS NOT NULL THEN
5082: l_blob := c2b(l_clob);

Line 5090: hr_utility.set_location('entering c_get_part4 ',280);

5086: l_string:='';
5087: l_clob:='';
5088: --for l_data_part4 in c_get_part4(l_payroll_action_id)
5089: --loop
5090: hr_utility.set_location('entering c_get_part4 ',280);
5091: l_string:=l_string || '' || l_data_part4.l_ann_leave_ft_mg || '';
5092: l_string:=l_string || '' || l_data_part4.l_ann_leave_ft_cl || '';
5093: l_string:=l_string || '' || l_data_part4.l_ann_leave_ft_ot || '';
5094: l_string:=l_string || '' || l_data_part4.l_mat_leave_ft_mg || '';

Line 5120: hr_utility.set_location('Before completing the l_data_part4: length(l_string) = '||length(l_string),3330);

5116: l_string:=l_string || '' || l_data_part4.l_all_paid_leave_app_cl || '';
5117: l_string:=l_string || '' || l_data_part4.l_all_paid_leave_app_ot || '';
5118: --end loop;
5119:
5120: hr_utility.set_location('Before completing the l_data_part4: length(l_string) = '||length(l_string),3330);
5121: l_clob := l_clob||l_string;
5122:
5123: IF l_clob IS NOT NULL THEN
5124: l_blob := c2b(l_clob);

Line 5144: hr_utility.set_location('entering c_get_part7 ',280);

5140: l_string:=l_string || '' || l_data_part_all_other.l_employer_liability_premium || '';
5141:
5142: --for l_data_part7 in c_get_part7(l_payroll_action_id)
5143: --loop
5144: hr_utility.set_location('entering c_get_part7 ',280);
5145: l_string:=l_string || '' || l_data_part7.l_employer_prsi_mg || '';
5146: l_string:=l_string || '' || l_data_part7.l_employer_prsi_cl || '';
5147: l_string:=l_string || '' || l_data_part7.l_employer_prsi_ot || '';
5148: l_string:=l_string || '' || l_data_part7.l_continuance_income_mg || '';

Line 5162: hr_utility.set_location('Before completing the l_data_part7: length(l_string) = '||length(l_string),3340);

5158: l_string:=l_string || '' || l_data_part7.l_ssc_contributions_app_cl || '';
5159: l_string:=l_string || '' || l_data_part7.l_ssc_contributions_app_ot || '';
5160: --end loop;
5161:
5162: hr_utility.set_location('Before completing the l_data_part7: length(l_string) = '||length(l_string),3340);
5163: l_clob := l_clob||l_string;
5164:
5165: IF l_clob IS NOT NULL THEN
5166: l_blob := c2b(l_clob);

Line 5173: hr_utility.set_location('entering c_get_part8 ',280);

5169: l_string:='';
5170: l_clob:='';
5171: --for l_data_part8 in c_get_part8(l_payroll_action_id)
5172: --loop
5173: hr_utility.set_location('entering c_get_part8 ',280);
5174: l_string:=l_string || '' || l_data_part8.l_company_car_mg || '';
5175: l_string:=l_string || '' || l_data_part8.l_company_car_cl || '';
5176: l_string:=l_string || '' || l_data_part8.l_company_car_ot || '';
5177: l_string:=l_string || '' || l_data_part8.l_stock_options_mg || '';

Line 5191: hr_utility.set_location('Before completing the l_data_part8: length(l_string) = '||length(l_string),3350);

5187: l_string:=l_string || '' || l_data_part8.l_other_benefits_cl || '';
5188: l_string:=l_string || '' || l_data_part8.l_other_benefits_ot || '';
5189: --end loop;
5190:
5191: hr_utility.set_location('Before completing the l_data_part8: length(l_string) = '||length(l_string),3350);
5192:
5193: /*
5194: for l_data_part_all_other in c_get_part_all_other(l_payroll_action_id)
5195: loop

Line 5197: hr_utility.set_location('entering c_get_part others ',280);

5193: /*
5194: for l_data_part_all_other in c_get_part_all_other(l_payroll_action_id)
5195: loop
5196: */
5197: hr_utility.set_location('entering c_get_part others ',280);
5198: l_string:=l_string || '' || l_data_part_all_other.l_employer_training_costs || '';
5199: l_string:=l_string || '' || l_data_part_all_other.l_other_expenditure || '';
5200: l_string:=l_string || '' || l_data_part_all_other.l_training_subsudies || '';
5201: l_string:=l_string || '' || l_data_part_all_other.l_other_subsidies || '';

Line 5216: hr_utility.set_location('Before completing the l_data_part_all_other: length(l_string) = '||length(l_string),3360);

5212: */
5213: l_string:=l_string || '' || g_comments || '';
5214:
5215: l_string := l_string ||''||EOL ;
5216: hr_utility.set_location('Before completing the l_data_part_all_other: length(l_string) = '||length(l_string),3360);
5217:
5218: l_clob := l_clob||l_string;
5219:
5220: IF l_clob IS NOT NULL THEN

Line 5239: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1223);

5235:
5236:
5237: EXCEPTION
5238: WHEN l_ehecs_exception THEN
5239: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1223);
5240: l_string := l_string ||''||EOL ;
5241: l_clob := l_clob||l_string;
5242: IF l_clob IS NOT NULL THEN
5243: l_blob := c2b(l_clob);

Line 5248: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,3370);

5244: pay_core_files.write_to_magtape_lob(l_blob);
5245: END IF;
5246: error_message := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','EHECS Report errors out.');
5247: WHEN Others THEN
5248: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,3370);
5249: l_string := l_string ||''||EOL ;
5250: l_clob := l_clob||l_string;
5251: IF l_clob IS NOT NULL THEN
5252: l_blob := c2b(l_clob);