APPS.PAY_US_YEPP_ADD_ACTIONS_PKG dependencies on HR_UTILITY

Line 100: hr_utility.set_location(gv_package_name || '.formated_header_string', 10);

96: lv_format1 varchar2(32000);
97:
98: BEGIN
99:
100: hr_utility.set_location(gv_package_name || '.formated_header_string', 10);
101: lv_format1 :=
102: pay_us_payroll_utils.formated_data_string
103: (p_input_string => 'Year '
104: ,p_bold => 'Y'

Line 123: hr_utility.trace('Static Label1 = ' || lv_format1);

119: (p_input_string => 'Employee #'
120: ,p_bold => 'Y'
121: ,p_output_file_type => p_output_file_type) ;
122:
123: hr_utility.trace('Static Label1 = ' || lv_format1);
124:
125: hr_utility.set_location(gv_package_name || '.formated_header_string', 40);
126: return lv_format1 ;
127:

Line 125: hr_utility.set_location(gv_package_name || '.formated_header_string', 40);

121: ,p_output_file_type => p_output_file_type) ;
122:
123: hr_utility.trace('Static Label1 = ' || lv_format1);
124:
125: hr_utility.set_location(gv_package_name || '.formated_header_string', 40);
126: return lv_format1 ;
127:
128: EXCEPTION
129: WHEN OTHERS THEN

Line 130: hr_utility.trace('Error in gv_package_name' || '.formated_header_string');

126: return lv_format1 ;
127:
128: EXCEPTION
129: WHEN OTHERS THEN
130: hr_utility.trace('Error in gv_package_name' || '.formated_header_string');
131: RAISE;
132:
133: END formated_header_string;
134:

Line 156: hr_utility.set_location(gv_package_name || '.formated_detail_string', 10);

152: lv_format1 varchar2(22000);
153:
154: BEGIN
155:
156: hr_utility.set_location(gv_package_name || '.formated_detail_string', 10);
157: lv_format1 :=
158: pay_us_payroll_utils.formated_data_string
159: (p_input_string => p_year
160: ,p_bold => 'N'

Line 179: hr_utility.set_location(gv_package_name || '.formated_detail_string', 20);

175: (p_input_string => p_emplyee_number
176: ,p_bold => 'N'
177: ,p_output_file_type => p_output_file_type);
178:
179: hr_utility.set_location(gv_package_name || '.formated_detail_string', 20);
180: hr_utility.trace('Static Label1 = ' || lv_format1);
181: hr_utility.set_location(gv_package_name || '.formated_detail_string', 30);
182:
183: return lv_format1;

Line 180: hr_utility.trace('Static Label1 = ' || lv_format1);

176: ,p_bold => 'N'
177: ,p_output_file_type => p_output_file_type);
178:
179: hr_utility.set_location(gv_package_name || '.formated_detail_string', 20);
180: hr_utility.trace('Static Label1 = ' || lv_format1);
181: hr_utility.set_location(gv_package_name || '.formated_detail_string', 30);
182:
183: return lv_format1;
184:

Line 181: hr_utility.set_location(gv_package_name || '.formated_detail_string', 30);

177: ,p_output_file_type => p_output_file_type);
178:
179: hr_utility.set_location(gv_package_name || '.formated_detail_string', 20);
180: hr_utility.trace('Static Label1 = ' || lv_format1);
181: hr_utility.set_location(gv_package_name || '.formated_detail_string', 30);
182:
183: return lv_format1;
184:
185: EXCEPTION

Line 187: hr_utility.trace('Error in '|| gv_package_name || '.formated_detail_string');

183: return lv_format1;
184:
185: EXCEPTION
186: WHEN OTHERS THEN
187: hr_utility.trace('Error in '|| gv_package_name || '.formated_detail_string');
188: RAISE;
189:
190: END formated_detail_string;
191:

Line 213: hr_utility.set_location(gv_package_name || '.formated_zero_count', 10);

209:
210: lvc_return_message varchar2(400);
211: BEGIN
212:
213: hr_utility.set_location(gv_package_name || '.formated_zero_count', 10);
214:
215: lvc_message1 := '1. No employee from assignment set is already processed by'
216: || ' Year End Pre-Process.';
217: lvc_message2 := '2. No employee from assignment set is eligible for Year'

Line 232: hr_utility.set_location(gv_package_name || '.formated_zero_count', 20);

228: if p_flag='PROCESSED' then
229: fnd_file.put_line(fnd_file.output,lvc_message1);
230: end if;
231:
232: hr_utility.set_location(gv_package_name || '.formated_zero_count', 20);
233:
234: if p_flag='ELGBLE' then
235: fnd_file.put_line(fnd_file.output, lvc_message2);
236: end if;

Line 238: hr_utility.set_location(gv_package_name || '.formated_zero_count', 30);

234: if p_flag='ELGBLE' then
235: fnd_file.put_line(fnd_file.output, lvc_message2);
236: end if;
237:
238: hr_utility.set_location(gv_package_name || '.formated_zero_count', 30);
239:
240: if p_flag='NOTELGBLE' then
241: fnd_file.put_line(fnd_file.output, lvc_message3);
242: end if;

Line 244: hr_utility.set_location(gv_package_name || '.formated_zero_count', 40);

240: if p_flag='NOTELGBLE' then
241: fnd_file.put_line(fnd_file.output, lvc_message3);
242: end if;
243:
244: hr_utility.set_location(gv_package_name || '.formated_zero_count', 40);
245:
246: EXCEPTION
247: WHEN OTHERS THEN
248: hr_utility.trace('Error in '|| gv_package_name || '.formated_zero_count');

Line 248: hr_utility.trace('Error in '|| gv_package_name || '.formated_zero_count');

244: hr_utility.set_location(gv_package_name || '.formated_zero_count', 40);
245:
246: EXCEPTION
247: WHEN OTHERS THEN
248: hr_utility.trace('Error in '|| gv_package_name || '.formated_zero_count');
249: RAISE;
250:
251: END formated_zero_count;
252:

Line 264: hr_utility.set_location(gv_package_name || '.print_table_header', 10);

260: p_output_file_type in varchar2)
261: IS
262: l_header_text varchar2(200);
263: BEGIN
264: hr_utility.set_location(gv_package_name || '.print_table_header', 10);
265: l_header_text := p_header_text ;
266:
267: if p_output_file_type = 'HTML' then
268: l_header_text := '

'||l_header_text||'

Line 278: hr_utility.set_location(gv_package_name || '.print_table_header', 20);

274: fnd_file.put_line(fnd_file.output, '');
275: fnd_file.put_line(fnd_file.output, '');
276: end if;
277:
278: hr_utility.set_location(gv_package_name || '.print_table_header', 20);
279:
280: fnd_file.put_line(fnd_file.output,formated_header_string(p_output_file_type));
281:
282: if p_output_file_type ='HTML' then

Line 286: hr_utility.set_location(gv_package_name || '.print_table_header', 30);

282: if p_output_file_type ='HTML' then
283: fnd_file.put_line(fnd_file.output, '

');
284: end if;
285:
286: hr_utility.set_location(gv_package_name || '.print_table_header', 30);
287:
288: EXCEPTION
289: WHEN OTHERS THEN
290: hr_utility.trace('Error in '|| gv_package_name || '.print_table_header');

Line 290: hr_utility.trace('Error in '|| gv_package_name || '.print_table_header');

286: hr_utility.set_location(gv_package_name || '.print_table_header', 30);
287:
288: EXCEPTION
289: WHEN OTHERS THEN
290: hr_utility.trace('Error in '|| gv_package_name || '.print_table_header');
291: RAISE;
292: END print_table_header;
293:
294:

Line 324: hr_utility.set_location(gv_package_name || '.bal_db_item', 10);

320:
321: l_defined_balance_id pay_defined_balances.defined_balance_id%type;
322:
323: BEGIN
324: hr_utility.set_location(gv_package_name || '.bal_db_item', 10);
325: hr_utility.trace('p_db_item_name is '||p_db_item_name);
326:
327: open csr_defined_balance;
328: fetch csr_defined_balance into l_defined_balance_id;

Line 325: hr_utility.trace('p_db_item_name is '||p_db_item_name);

321: l_defined_balance_id pay_defined_balances.defined_balance_id%type;
322:
323: BEGIN
324: hr_utility.set_location(gv_package_name || '.bal_db_item', 10);
325: hr_utility.trace('p_db_item_name is '||p_db_item_name);
326:
327: open csr_defined_balance;
328: fetch csr_defined_balance into l_defined_balance_id;
329:

Line 332: raise hr_utility.hr_error;

328: fetch csr_defined_balance into l_defined_balance_id;
329:
330: if csr_defined_balance%notfound then
331: close csr_defined_balance;
332: raise hr_utility.hr_error;
333: else
334: close csr_defined_balance;
335: end if;
336:

Line 337: hr_utility.trace('l_defined_balance_id is '||to_char(l_defined_balance_id));

333: else
334: close csr_defined_balance;
335: end if;
336:
337: hr_utility.trace('l_defined_balance_id is '||to_char(l_defined_balance_id));
338: hr_utility.set_location(gv_package_name || '.bal_db_item', 20);
339:
340: return (l_defined_balance_id);
341:

Line 338: hr_utility.set_location(gv_package_name || '.bal_db_item', 20);

334: close csr_defined_balance;
335: end if;
336:
337: hr_utility.trace('l_defined_balance_id is '||to_char(l_defined_balance_id));
338: hr_utility.set_location(gv_package_name || '.bal_db_item', 20);
339:
340: return (l_defined_balance_id);
341:
342: EXCEPTION

Line 344: hr_utility.trace('Error in '|| gv_package_name || '.bal_db_item');

340: return (l_defined_balance_id);
341:
342: EXCEPTION
343: WHEN OTHERS THEN
344: hr_utility.trace('Error in '|| gv_package_name || '.bal_db_item');
345: RAISE;
346:
347: END bal_db_item;
348:

Line 471: hr_utility.set_location(gv_package_name || '.create_archive', 10);

467: l_user_entity_id number;
468: l_context_id number;
469: BEGIN
470:
471: hr_utility.set_location(gv_package_name || '.create_archive', 10);
472: select context_id
473: into l_context_id
474: from ff_contexts
475: where context_name = 'TAX_UNIT_ID';

Line 485: hr_utility.set_location(gv_package_name || '.create_archive', 20);

481: ||'A_ADD_ARCHIVE'||' - '||to_char(sqlcode) || '-' || sqlerrm);
482: end if;
483: close c_get_dbi_id;
484:
485: hr_utility.set_location(gv_package_name || '.create_archive', 20);
486:
487: -- Inserting into ff_archive_items
488:
489: insert into ff_archive_items

Line 512: hr_utility.set_location(gv_package_name || '.create_archive', 30);

508: (ff_archive_items_s.currval,
509: 1,
510: cp_gre_id,
511: l_context_id);
512: hr_utility.set_location(gv_package_name || '.create_archive', 30);
513: end create_archive;
514: /******************************************************************
515: Procedure get_eligible_assignments
516: Description : Gets the list of all primary assignments eligible for

Line 641: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 10);

637: ORDER BY assignment_id desc;
638:
639: BEGIN
640:
641: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 10);
642:
643: -- Get the Payroll Action of Year End Archive Pre-Process Run
644: -- For given GRE and Year.
645:

Line 652: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 20);

648: fetch get_yepp_payroll_action into l_yepp_payroll_action_id;
649: close get_yepp_payroll_action ;
650:
651:
652: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 20);
653:
654: /* Set up the context of tax unit id */
655: pay_balance_pkg.set_context('TAX_UNIT_ID',p_gre_id);
656:

Line 657: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 30);

653:
654: /* Set up the context of tax unit id */
655: pay_balance_pkg.set_context('TAX_UNIT_ID',p_gre_id);
656:
657: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 30);
658:
659:
660: -- Get the latest assignment actions of all the primary assignments from the
661: -- assignment set

Line 670: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 40);

666: );
667: LOOP
668: fetch c_get_latest_asg into l_bal_aaid, l_assignment_id, l_person_id;
669: exit when c_get_latest_asg%NOTFOUND;
670: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 40);
671:
672: if (l_prev_person_id <> l_person_id) or
673: (l_prev_person_id is null) then -- bug 3315082
674: l_prev_person_id := l_person_id;

Line 677: hr_utility.trace('bal_aaid = '||to_char(l_bal_aaid));

673: (l_prev_person_id is null) then -- bug 3315082
674: l_prev_person_id := l_person_id;
675: if l_bal_aaid <> -9999 then /* Assignment action in year */
676:
677: hr_utility.trace('bal_aaid = '||to_char(l_bal_aaid));
678: hr_utility.trace('defined_balance_id = '||to_char(bal_db_item('GROSS_EARNINGS_PER_GRE_YTD')));
679: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 50);
680: l_value := nvl(pay_balance_pkg.get_value
681: (p_defined_balance_id => bal_db_item('GROSS_EARNINGS_PER_GRE_YTD'),

Line 678: hr_utility.trace('defined_balance_id = '||to_char(bal_db_item('GROSS_EARNINGS_PER_GRE_YTD')));

674: l_prev_person_id := l_person_id;
675: if l_bal_aaid <> -9999 then /* Assignment action in year */
676:
677: hr_utility.trace('bal_aaid = '||to_char(l_bal_aaid));
678: hr_utility.trace('defined_balance_id = '||to_char(bal_db_item('GROSS_EARNINGS_PER_GRE_YTD')));
679: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 50);
680: l_value := nvl(pay_balance_pkg.get_value
681: (p_defined_balance_id => bal_db_item('GROSS_EARNINGS_PER_GRE_YTD'),
682: p_assignment_action_id => l_bal_aaid),0);

Line 679: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 50);

675: if l_bal_aaid <> -9999 then /* Assignment action in year */
676:
677: hr_utility.trace('bal_aaid = '||to_char(l_bal_aaid));
678: hr_utility.trace('defined_balance_id = '||to_char(bal_db_item('GROSS_EARNINGS_PER_GRE_YTD')));
679: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 50);
680: l_value := nvl(pay_balance_pkg.get_value
681: (p_defined_balance_id => bal_db_item('GROSS_EARNINGS_PER_GRE_YTD'),
682: p_assignment_action_id => l_bal_aaid),0);
683:

Line 685: hr_utility.trace('bal_aaid = '||to_char(l_bal_aaid));

681: (p_defined_balance_id => bal_db_item('GROSS_EARNINGS_PER_GRE_YTD'),
682: p_assignment_action_id => l_bal_aaid),0);
683:
684: if l_value = 0 then
685: hr_utility.trace('bal_aaid = '||to_char(l_bal_aaid));
686: hr_utility.trace('defined_balance_id = '||to_char(bal_db_item('W2_NONTAX_SICK_PER_GRE_YTD')));
687: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 60);
688: l_value := nvl(pay_balance_pkg.get_value
689: (p_defined_balance_id => bal_db_item('W2_NONTAX_SICK_PER_GRE_YTD'),

Line 686: hr_utility.trace('defined_balance_id = '||to_char(bal_db_item('W2_NONTAX_SICK_PER_GRE_YTD')));

682: p_assignment_action_id => l_bal_aaid),0);
683:
684: if l_value = 0 then
685: hr_utility.trace('bal_aaid = '||to_char(l_bal_aaid));
686: hr_utility.trace('defined_balance_id = '||to_char(bal_db_item('W2_NONTAX_SICK_PER_GRE_YTD')));
687: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 60);
688: l_value := nvl(pay_balance_pkg.get_value
689: (p_defined_balance_id => bal_db_item('W2_NONTAX_SICK_PER_GRE_YTD'),
690: p_assignment_action_id => l_bal_aaid),0);

Line 687: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 60);

683:
684: if l_value = 0 then
685: hr_utility.trace('bal_aaid = '||to_char(l_bal_aaid));
686: hr_utility.trace('defined_balance_id = '||to_char(bal_db_item('W2_NONTAX_SICK_PER_GRE_YTD')));
687: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 60);
688: l_value := nvl(pay_balance_pkg.get_value
689: (p_defined_balance_id => bal_db_item('W2_NONTAX_SICK_PER_GRE_YTD'),
690: p_assignment_action_id => l_bal_aaid),0);
691:

Line 693: hr_utility.trace('bal_aaid = '||to_char(l_bal_aaid));

689: (p_defined_balance_id => bal_db_item('W2_NONTAX_SICK_PER_GRE_YTD'),
690: p_assignment_action_id => l_bal_aaid),0);
691:
692: if l_value = 0 then
693: hr_utility.trace('bal_aaid = '||to_char(l_bal_aaid));
694: hr_utility.trace('defined_balance_id = '||to_char(bal_db_item('W2_EXPENSE_REIMB_PER_GRE_YTD')));
695: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 70);
696: l_value := nvl(pay_balance_pkg.get_value
697: (p_defined_balance_id => bal_db_item('W2_EXPENSE_REIMB_PER_GRE_YTD'),

Line 694: hr_utility.trace('defined_balance_id = '||to_char(bal_db_item('W2_EXPENSE_REIMB_PER_GRE_YTD')));

690: p_assignment_action_id => l_bal_aaid),0);
691:
692: if l_value = 0 then
693: hr_utility.trace('bal_aaid = '||to_char(l_bal_aaid));
694: hr_utility.trace('defined_balance_id = '||to_char(bal_db_item('W2_EXPENSE_REIMB_PER_GRE_YTD')));
695: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 70);
696: l_value := nvl(pay_balance_pkg.get_value
697: (p_defined_balance_id => bal_db_item('W2_EXPENSE_REIMB_PER_GRE_YTD'),
698: p_assignment_action_id => l_bal_aaid),0);

Line 695: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 70);

691:
692: if l_value = 0 then
693: hr_utility.trace('bal_aaid = '||to_char(l_bal_aaid));
694: hr_utility.trace('defined_balance_id = '||to_char(bal_db_item('W2_EXPENSE_REIMB_PER_GRE_YTD')));
695: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 70);
696: l_value := nvl(pay_balance_pkg.get_value
697: (p_defined_balance_id => bal_db_item('W2_EXPENSE_REIMB_PER_GRE_YTD'),
698: p_assignment_action_id => l_bal_aaid),0);
699:

Line 701: hr_utility.trace('bal_aaid = '||to_char(l_bal_aaid));

697: (p_defined_balance_id => bal_db_item('W2_EXPENSE_REIMB_PER_GRE_YTD'),
698: p_assignment_action_id => l_bal_aaid),0);
699:
700: if l_value = 0 then
701: hr_utility.trace('bal_aaid = '||to_char(l_bal_aaid));
702: hr_utility.trace('defined_balance_id = '||to_char(bal_db_item('W2_QUAL_MOVE_PER_GRE_YTD')));
703: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 80);
704: l_value := nvl(pay_balance_pkg.get_value
705: (p_defined_balance_id => bal_db_item('W2_QUAL_MOVE_PER_GRE_YTD'),

Line 702: hr_utility.trace('defined_balance_id = '||to_char(bal_db_item('W2_QUAL_MOVE_PER_GRE_YTD')));

698: p_assignment_action_id => l_bal_aaid),0);
699:
700: if l_value = 0 then
701: hr_utility.trace('bal_aaid = '||to_char(l_bal_aaid));
702: hr_utility.trace('defined_balance_id = '||to_char(bal_db_item('W2_QUAL_MOVE_PER_GRE_YTD')));
703: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 80);
704: l_value := nvl(pay_balance_pkg.get_value
705: (p_defined_balance_id => bal_db_item('W2_QUAL_MOVE_PER_GRE_YTD'),
706: p_assignment_action_id => l_bal_aaid),0);

Line 703: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 80);

699:
700: if l_value = 0 then
701: hr_utility.trace('bal_aaid = '||to_char(l_bal_aaid));
702: hr_utility.trace('defined_balance_id = '||to_char(bal_db_item('W2_QUAL_MOVE_PER_GRE_YTD')));
703: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 80);
704: l_value := nvl(pay_balance_pkg.get_value
705: (p_defined_balance_id => bal_db_item('W2_QUAL_MOVE_PER_GRE_YTD'),
706: p_assignment_action_id => l_bal_aaid),0);
707: if l_value = 0 then

Line 708: hr_utility.trace('bal_aaid = '||to_char(l_bal_aaid));

704: l_value := nvl(pay_balance_pkg.get_value
705: (p_defined_balance_id => bal_db_item('W2_QUAL_MOVE_PER_GRE_YTD'),
706: p_assignment_action_id => l_bal_aaid),0);
707: if l_value = 0 then
708: hr_utility.trace('bal_aaid = '||to_char(l_bal_aaid));
709: hr_utility.trace('defined_balance_id = '||to_char(bal_db_item('W2_NO_GROSS_EARNINGS_PER_GRE_YTD')));
710: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 90);
711: l_value := nvl(pay_balance_pkg.get_value
712: (p_defined_balance_id => bal_db_item('W2_NO_GROSS_EARNINGS_PER_GRE_YTD'),

Line 709: hr_utility.trace('defined_balance_id = '||to_char(bal_db_item('W2_NO_GROSS_EARNINGS_PER_GRE_YTD')));

705: (p_defined_balance_id => bal_db_item('W2_QUAL_MOVE_PER_GRE_YTD'),
706: p_assignment_action_id => l_bal_aaid),0);
707: if l_value = 0 then
708: hr_utility.trace('bal_aaid = '||to_char(l_bal_aaid));
709: hr_utility.trace('defined_balance_id = '||to_char(bal_db_item('W2_NO_GROSS_EARNINGS_PER_GRE_YTD')));
710: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 90);
711: l_value := nvl(pay_balance_pkg.get_value
712: (p_defined_balance_id => bal_db_item('W2_NO_GROSS_EARNINGS_PER_GRE_YTD'),
713: p_assignment_action_id => l_bal_aaid),0);

Line 710: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 90);

706: p_assignment_action_id => l_bal_aaid),0);
707: if l_value = 0 then
708: hr_utility.trace('bal_aaid = '||to_char(l_bal_aaid));
709: hr_utility.trace('defined_balance_id = '||to_char(bal_db_item('W2_NO_GROSS_EARNINGS_PER_GRE_YTD')));
710: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 90);
711: l_value := nvl(pay_balance_pkg.get_value
712: (p_defined_balance_id => bal_db_item('W2_NO_GROSS_EARNINGS_PER_GRE_YTD'),
713: p_assignment_action_id => l_bal_aaid),0);
714: end if;

Line 720: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 100);

716: end if;
717: end if;
718:
719: -- Check if the assignment has got a value for any of the above five balances
720: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 100);
721: if l_value <> 0 then
722:
723: /* Create the assignment action to represnt the person / tax unit
724: combination. */

Line 725: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 110);

721: if l_value <> 0 then
722:
723: /* Create the assignment action to represnt the person / tax unit
724: combination. */
725: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 110);
726:
727: select pay_assignment_actions_s.nextval
728: into lockingactid
729: from dual;

Line 735: raise hr_utility.hr_error;

731: open c_get_asg_id(l_person_id);
732: fetch c_get_asg_id into l_assignment_id;
733: if c_get_asg_id%NOTFOUND then
734: close c_get_asg_id;
735: raise hr_utility.hr_error;
736: else
737: close c_get_asg_id;
738: end if;
739:

Line 741: hr_utility.trace('creating asg action');

737: close c_get_asg_id;
738: end if;
739:
740: /* Insert into pay_assignment_actions. */
741: hr_utility.trace('creating asg action');
742:
743: hr_nonrun_asact.insact(lockingactid => lockingactid,
744: assignid => l_assignment_id,
745: pactid => l_yepp_payroll_action_id,

Line 750: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 120);

746: chunk => '1',
747: greid => p_gre_id,
748: status => 'M' );
749:
750: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 120);
751:
752: /* insert into ff_archive_items */
753: -- Bug 3829668
754: hr_utility.trace('creating ff_archive_items entry');

Line 754: hr_utility.trace('creating ff_archive_items entry');

750: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 120);
751:
752: /* insert into ff_archive_items */
753: -- Bug 3829668
754: hr_utility.trace('creating ff_archive_items entry');
755: create_archive(lockingactid ,
756: p_gre_id);
757:
758: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 121);

Line 758: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 121);

754: hr_utility.trace('creating ff_archive_items entry');
755: create_archive(lockingactid ,
756: p_gre_id);
757:
758: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 121);
759:
760: /* Bug No : 3137858 Update the serial number column with the person id
761: So that retry us payroll process archives balance values*/
762: hr_utility.trace('updating asg action');

Line 762: hr_utility.trace('updating asg action');

758: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 121);
759:
760: /* Bug No : 3137858 Update the serial number column with the person id
761: So that retry us payroll process archives balance values*/
762: hr_utility.trace('updating asg action');
763:
764: update pay_assignment_actions aa
765: set aa.serial_number = to_char(l_person_id)
766: where aa.assignment_action_id = lockingactid;

Line 776: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 130);

772: -- Populate plsql table of all reported assignments. It will be used to
773: -- Identify all assignments in different GRE and in the assignment set.
774: l_gre_reported_asg_table(l_assignment_id).c_assignment_id := l_assignment_id;
775:
776: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 130);
777:
778: end if; /* l_value <> 0 */
779: end if; /* l_prev_person_id <> l_person_id */
780: end if; /* l_bal_aaid <> -9999 */

Line 802: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 140);

798: := ma_rec.assignment_id;
799: end loop;
800:
801: */
802: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 140);
803:
804: EXCEPTION
805: WHEN OTHERS THEN
806: hr_utility.trace('Error in '|| gv_package_name || '.get_eligible_assignments');

Line 806: hr_utility.trace('Error in '|| gv_package_name || '.get_eligible_assignments');

802: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 140);
803:
804: EXCEPTION
805: WHEN OTHERS THEN
806: hr_utility.trace('Error in '|| gv_package_name || '.get_eligible_assignments');
807: RAISE;
808:
809: END get_eligible_assignments;
810:

Line 875: hr_utility.set_location(gv_package_name || '.get_processed_assignments', 10);

871: l_processed_assignment_id per_assignments_f.assignment_id%type;
872:
873: BEGIN
874:
875: hr_utility.set_location(gv_package_name || '.get_processed_assignments', 10);
876:
877: -- Open Curosr c_get_processed_assignments
878: open c_get_processed_assignments(p_effective_date ,
879: p_gre_id,

Line 885: hr_utility.set_location(gv_package_name || '.get_processed_assignments', 20);

881: LOOP
882:
883: fetch c_get_processed_assignments into l_processed_assignment_id;
884: exit when c_get_processed_assignments%notfound;
885: hr_utility.set_location(gv_package_name || '.get_processed_assignments', 20);
886: -- Populate plsql tbales
887: l_yepp_prc_asg_table(l_processed_assignment_id).c_assignment_id := l_processed_assignment_id;
888: l_gre_reported_asg_table(l_processed_assignment_id).c_assignment_id := l_processed_assignment_id;
889:

Line 893: hr_utility.set_location(gv_package_name || '.get_processed_assignments', 30);

889:
890: END LOOP;
891: close c_get_processed_assignments;
892:
893: hr_utility.set_location(gv_package_name || '.get_processed_assignments', 30);
894:
895: EXCEPTION
896: WHEN OTHERS THEN
897: hr_utility.trace('Error in '|| gv_package_name || '.get_processed_assignments');

Line 897: hr_utility.trace('Error in '|| gv_package_name || '.get_processed_assignments');

893: hr_utility.set_location(gv_package_name || '.get_processed_assignments', 30);
894:
895: EXCEPTION
896: WHEN OTHERS THEN
897: hr_utility.trace('Error in '|| gv_package_name || '.get_processed_assignments');
898: RAISE;
899: END get_processed_assignments;
900:
901:

Line 936: hr_utility.set_location(gv_package_name || '.get_non_elgble_assignments', 10);

932: l_assignment_id per_assignments_f.assignment_id%type;
933:
934: BEGIN
935:
936: hr_utility.set_location(gv_package_name || '.get_non_elgble_assignments', 10);
937: hr_utility.trace('Assign Set ID'||p_assignment_set_id);
938:
939: -- Open Cursor c_get_assignments
940: open c_get_assignments(p_assignment_set_id,p_gre_id,p_effective_date);

Line 937: hr_utility.trace('Assign Set ID'||p_assignment_set_id);

933:
934: BEGIN
935:
936: hr_utility.set_location(gv_package_name || '.get_non_elgble_assignments', 10);
937: hr_utility.trace('Assign Set ID'||p_assignment_set_id);
938:
939: -- Open Cursor c_get_assignments
940: open c_get_assignments(p_assignment_set_id,p_gre_id,p_effective_date);
941:

Line 946: hr_utility.set_location(gv_package_name || '.get_non_elgble_assignments', 20);

942: LOOP
943:
944: fetch c_get_assignments into l_assignment_id;
945: exit when c_get_assignments%notfound;
946: hr_utility.set_location(gv_package_name || '.get_non_elgble_assignments', 20);
947:
948: if l_yepp_elgble_asg_table.exists(l_assignment_id) then
949: hr_utility.set_location(gv_package_name || '.get_non_elgble_assignments', 30);
950: hr_utility.trace('Assignment Exists');

Line 949: hr_utility.set_location(gv_package_name || '.get_non_elgble_assignments', 30);

945: exit when c_get_assignments%notfound;
946: hr_utility.set_location(gv_package_name || '.get_non_elgble_assignments', 20);
947:
948: if l_yepp_elgble_asg_table.exists(l_assignment_id) then
949: hr_utility.set_location(gv_package_name || '.get_non_elgble_assignments', 30);
950: hr_utility.trace('Assignment Exists');
951:
952: elsif l_yepp_prc_asg_table.exists(l_assignment_id) then
953: hr_utility.trace('Assignment Exists');

Line 950: hr_utility.trace('Assignment Exists');

946: hr_utility.set_location(gv_package_name || '.get_non_elgble_assignments', 20);
947:
948: if l_yepp_elgble_asg_table.exists(l_assignment_id) then
949: hr_utility.set_location(gv_package_name || '.get_non_elgble_assignments', 30);
950: hr_utility.trace('Assignment Exists');
951:
952: elsif l_yepp_prc_asg_table.exists(l_assignment_id) then
953: hr_utility.trace('Assignment Exists');
954: hr_utility.set_location(gv_package_name || '.get_non_elgble_assignments', 40);

Line 953: hr_utility.trace('Assignment Exists');

949: hr_utility.set_location(gv_package_name || '.get_non_elgble_assignments', 30);
950: hr_utility.trace('Assignment Exists');
951:
952: elsif l_yepp_prc_asg_table.exists(l_assignment_id) then
953: hr_utility.trace('Assignment Exists');
954: hr_utility.set_location(gv_package_name || '.get_non_elgble_assignments', 40);
955:
956: else
957: -- populate not eligible assignments table

Line 954: hr_utility.set_location(gv_package_name || '.get_non_elgble_assignments', 40);

950: hr_utility.trace('Assignment Exists');
951:
952: elsif l_yepp_prc_asg_table.exists(l_assignment_id) then
953: hr_utility.trace('Assignment Exists');
954: hr_utility.set_location(gv_package_name || '.get_non_elgble_assignments', 40);
955:
956: else
957: -- populate not eligible assignments table
958: l_yepp_not_elgble_asg_table(l_assignment_id).c_assignment_id := l_assignment_id;

Line 960: hr_utility.set_location(gv_package_name || '.get_non_elgble_assignments', 50);

956: else
957: -- populate not eligible assignments table
958: l_yepp_not_elgble_asg_table(l_assignment_id).c_assignment_id := l_assignment_id;
959: l_gre_reported_asg_table(l_assignment_id).c_assignment_id := l_assignment_id;
960: hr_utility.set_location(gv_package_name || '.get_non_elgble_assignments', 50);
961:
962: end if;
963:
964: hr_utility.set_location(gv_package_name || '.get_non_elgble_assignments', 60);

Line 964: hr_utility.set_location(gv_package_name || '.get_non_elgble_assignments', 60);

960: hr_utility.set_location(gv_package_name || '.get_non_elgble_assignments', 50);
961:
962: end if;
963:
964: hr_utility.set_location(gv_package_name || '.get_non_elgble_assignments', 60);
965: END LOOP;
966:
967: close c_get_assignments;
968:

Line 969: hr_utility.set_location(gv_package_name || '.get_non_elgble_assignments', 70);

965: END LOOP;
966:
967: close c_get_assignments;
968:
969: hr_utility.set_location(gv_package_name || '.get_non_elgble_assignments', 70);
970:
971: EXCEPTION
972: WHEN OTHERS THEN
973: hr_utility.trace('Error in '|| gv_package_name || '.get_non_elgble_assignments');

Line 973: hr_utility.trace('Error in '|| gv_package_name || '.get_non_elgble_assignments');

969: hr_utility.set_location(gv_package_name || '.get_non_elgble_assignments', 70);
970:
971: EXCEPTION
972: WHEN OTHERS THEN
973: hr_utility.trace('Error in '|| gv_package_name || '.get_non_elgble_assignments');
974: RAISE;
975:
976: END get_non_elgble_assignments;
977:

Line 986: hr_utility.set_location(gv_package_name || 'print_table_details', 10);

982: ******************************************************************/
983: PROCEDURE print_table_details(p_assignment_id in number)
984: IS
985: BEGIN
986: hr_utility.set_location(gv_package_name || 'print_table_details', 10);
987:
988: -- Get person_id of the employee
989: open c_person_id(p_assignment_id);
990: fetch c_person_id into lv_person_id;

Line 994: hr_utility.set_location(gv_package_name || 'print_table_details', 20);

990: fetch c_person_id into lv_person_id;
991: close c_person_id;
992:
993: -- Get Employee Details
994: hr_utility.set_location(gv_package_name || 'print_table_details', 20);
995: open c_employee_details(lv_person_id);
996: fetch c_employee_details into lv_emp_no,lv_emp_name,lv_emp_ssn;
997: close c_employee_details;
998:

Line 999: hr_utility.set_location(gv_package_name || 'print_table_details', 30);

995: open c_employee_details(lv_person_id);
996: fetch c_employee_details into lv_emp_no,lv_emp_name,lv_emp_ssn;
997: close c_employee_details;
998:
999: hr_utility.set_location(gv_package_name || 'print_table_details', 30);
1000: l_assignment_inserted := l_assignment_inserted + 1;
1001: lv_data_row := formated_detail_string(
1002: p_output_file_type
1003: ,to_char(l_effective_date,'YYYY')

Line 1013: hr_utility.set_location(gv_package_name || 'print_table_details', 40);

1009: lv_data_row := '

' || lv_data_row || '' ;
1010: end if;
1011:
1012: fnd_file.put_line(fnd_file.output, lv_data_row);
1013: hr_utility.set_location(gv_package_name || 'print_table_details', 40);
1014:
1015: END print_table_details;
1016:
1017:

Line 1052: hr_utility.set_location(gv_package_name || '.report_secondary_Assignments', 10);

1048: l_count number := 0;
1049: l_header_printed varchar2(1) := 'N';
1050: BEGIN
1051:
1052: hr_utility.set_location(gv_package_name || '.report_secondary_Assignments', 10);
1053: hr_utility.trace('Assign Set ID'||p_assignment_set_id);
1054:
1055: -- Open Cursor c_get_secondary_assignments
1056: open c_get_secondary_assignments(p_assignment_set_id,

Line 1053: hr_utility.trace('Assign Set ID'||p_assignment_set_id);

1049: l_header_printed varchar2(1) := 'N';
1050: BEGIN
1051:
1052: hr_utility.set_location(gv_package_name || '.report_secondary_Assignments', 10);
1053: hr_utility.trace('Assign Set ID'||p_assignment_set_id);
1054:
1055: -- Open Cursor c_get_secondary_assignments
1056: open c_get_secondary_assignments(p_assignment_set_id,
1057: p_gre_id,

Line 1068: hr_utility.set_location(gv_package_name || '.report_secondary_assignments', 20);

1064: /* we should be displaying the secondary assignments only if it does not
1065: exists in any other tables. Bug 3440806 */
1066:
1067: if l_yepp_elgble_asg_table.exists(l_assignment_id) then
1068: hr_utility.set_location(gv_package_name || '.report_secondary_assignments', 20);
1069: hr_utility.trace('Assignment Exists');
1070:
1071: elsif l_yepp_prc_asg_table.exists(l_assignment_id) then
1072: hr_utility.trace('Assignment Exists');

Line 1069: hr_utility.trace('Assignment Exists');

1065: exists in any other tables. Bug 3440806 */
1066:
1067: if l_yepp_elgble_asg_table.exists(l_assignment_id) then
1068: hr_utility.set_location(gv_package_name || '.report_secondary_assignments', 20);
1069: hr_utility.trace('Assignment Exists');
1070:
1071: elsif l_yepp_prc_asg_table.exists(l_assignment_id) then
1072: hr_utility.trace('Assignment Exists');
1073: hr_utility.set_location(gv_package_name || '.report_secondary_assignments', 30);

Line 1072: hr_utility.trace('Assignment Exists');

1068: hr_utility.set_location(gv_package_name || '.report_secondary_assignments', 20);
1069: hr_utility.trace('Assignment Exists');
1070:
1071: elsif l_yepp_prc_asg_table.exists(l_assignment_id) then
1072: hr_utility.trace('Assignment Exists');
1073: hr_utility.set_location(gv_package_name || '.report_secondary_assignments', 30);
1074:
1075: elsif l_yepp_not_elgble_asg_table.exists(l_assignment_id) then
1076: hr_utility.trace('Assignment Exists');

Line 1073: hr_utility.set_location(gv_package_name || '.report_secondary_assignments', 30);

1069: hr_utility.trace('Assignment Exists');
1070:
1071: elsif l_yepp_prc_asg_table.exists(l_assignment_id) then
1072: hr_utility.trace('Assignment Exists');
1073: hr_utility.set_location(gv_package_name || '.report_secondary_assignments', 30);
1074:
1075: elsif l_yepp_not_elgble_asg_table.exists(l_assignment_id) then
1076: hr_utility.trace('Assignment Exists');
1077: hr_utility.set_location(gv_package_name || '.report_secondary_assignments', 40);

Line 1076: hr_utility.trace('Assignment Exists');

1072: hr_utility.trace('Assignment Exists');
1073: hr_utility.set_location(gv_package_name || '.report_secondary_assignments', 30);
1074:
1075: elsif l_yepp_not_elgble_asg_table.exists(l_assignment_id) then
1076: hr_utility.trace('Assignment Exists');
1077: hr_utility.set_location(gv_package_name || '.report_secondary_assignments', 40);
1078:
1079: else
1080:

Line 1077: hr_utility.set_location(gv_package_name || '.report_secondary_assignments', 40);

1073: hr_utility.set_location(gv_package_name || '.report_secondary_assignments', 30);
1074:
1075: elsif l_yepp_not_elgble_asg_table.exists(l_assignment_id) then
1076: hr_utility.trace('Assignment Exists');
1077: hr_utility.set_location(gv_package_name || '.report_secondary_assignments', 40);
1078:
1079: else
1080:
1081: l_count := l_count + 1 ;

Line 1082: hr_utility.set_location(gv_package_name || '.report_secondary_Assignments', 20);

1078:
1079: else
1080:
1081: l_count := l_count + 1 ;
1082: hr_utility.set_location(gv_package_name || '.report_secondary_Assignments', 20);
1083:
1084: if l_header_printed = 'N' then
1085: -- Print the Table Header
1086: print_table_header('4. '||l_secasg_table_header,p_output_file_type);

Line 1107: hr_utility.set_location(gv_package_name || '.report_secondary_assignments', 30);

1103: if l_count > 0 then
1104: gv_sec_asg_reported := 'Y';
1105: end if;
1106: --
1107: hr_utility.set_location(gv_package_name || '.report_secondary_assignments', 30);
1108:
1109: EXCEPTION
1110: WHEN OTHERS THEN
1111: hr_utility.trace('Error in '|| gv_package_name || '.report_secondary_assignments');

Line 1111: hr_utility.trace('Error in '|| gv_package_name || '.report_secondary_assignments');

1107: hr_utility.set_location(gv_package_name || '.report_secondary_assignments', 30);
1108:
1109: EXCEPTION
1110: WHEN OTHERS THEN
1111: hr_utility.trace('Error in '|| gv_package_name || '.report_secondary_assignments');
1112: RAISE;
1113:
1114: END report_secondary_assignments;
1115:

Line 1158: hr_utility.set_location(gv_package_name || '.get_other_assignments', 10);

1154: l_header_printed varchar2(1) := 'N';
1155:
1156: BEGIN
1157:
1158: hr_utility.set_location(gv_package_name || '.get_other_assignments', 10);
1159: hr_utility.trace('Assign Set ID'||p_assignment_set_id);
1160:
1161: -- Check of secondary assignment is reported.
1162: -- Used for formating of squence number

Line 1159: hr_utility.trace('Assign Set ID'||p_assignment_set_id);

1155:
1156: BEGIN
1157:
1158: hr_utility.set_location(gv_package_name || '.get_other_assignments', 10);
1159: hr_utility.trace('Assign Set ID'||p_assignment_set_id);
1160:
1161: -- Check of secondary assignment is reported.
1162: -- Used for formating of squence number
1163: if gv_sec_asg_reported = 'Y' then

Line 1178: hr_utility.set_location(gv_package_name || '.get_other_assignments', 20);

1174: LOOP
1175:
1176: fetch c_other_assignments into l_oth_assignment_id,l_gre_id;
1177: exit when c_other_assignments%notfound;
1178: hr_utility.set_location(gv_package_name || '.get_other_assignments', 20);
1179:
1180: if l_gre_reported_asg_table.exists(l_oth_assignment_id) then
1181: hr_utility.trace('The assignment already reported above');
1182: else

Line 1181: hr_utility.trace('The assignment already reported above');

1177: exit when c_other_assignments%notfound;
1178: hr_utility.set_location(gv_package_name || '.get_other_assignments', 20);
1179:
1180: if l_gre_reported_asg_table.exists(l_oth_assignment_id) then
1181: hr_utility.trace('The assignment already reported above');
1182: else
1183: -- Get other GRE Names
1184: open c_get_gre_name(l_gre_id);
1185: fetch c_get_gre_name into lv_gre_name;

Line 1187: hr_utility.set_location(gv_package_name || '.get_other_assignments', 30);

1183: -- Get other GRE Names
1184: open c_get_gre_name(l_gre_id);
1185: fetch c_get_gre_name into lv_gre_name;
1186: close c_get_gre_name;
1187: hr_utility.set_location(gv_package_name || '.get_other_assignments', 30);
1188: if l_header_printed = 'N' then
1189: -- Print the Table Header
1190: print_table_header(l_othasg_table_header,p_output_file_type);
1191: l_header_printed := 'Y';

Line 1193: hr_utility.set_location(gv_package_name || '.get_other_assignments', 40);

1189: -- Print the Table Header
1190: print_table_header(l_othasg_table_header,p_output_file_type);
1191: l_header_printed := 'Y';
1192: end if;
1193: hr_utility.set_location(gv_package_name || '.get_other_assignments', 40);
1194:
1195: -- Print the details of the employee
1196: print_table_details(l_oth_assignment_id);
1197: hr_utility.set_location(gv_package_name || '.get_other_assignments', 50);

Line 1197: hr_utility.set_location(gv_package_name || '.get_other_assignments', 50);

1193: hr_utility.set_location(gv_package_name || '.get_other_assignments', 40);
1194:
1195: -- Print the details of the employee
1196: print_table_details(l_oth_assignment_id);
1197: hr_utility.set_location(gv_package_name || '.get_other_assignments', 50);
1198: end if;
1199:
1200: END LOOP;
1201: hr_utility.set_location(gv_package_name || '.get_other_assignments', 60);

Line 1201: hr_utility.set_location(gv_package_name || '.get_other_assignments', 60);

1197: hr_utility.set_location(gv_package_name || '.get_other_assignments', 50);
1198: end if;
1199:
1200: END LOOP;
1201: hr_utility.set_location(gv_package_name || '.get_other_assignments', 60);
1202: if p_output_file_type ='HTML' then
1203: fnd_file.put_line(fnd_file.output,'

') ;
1204: end if;
1205:

Line 1207: hr_utility.set_location(gv_package_name || '.get_other_assignments', 90);

1203: fnd_file.put_line(fnd_file.output,'') ;
1204: end if;
1205:
1206: close c_other_assignments;
1207: hr_utility.set_location(gv_package_name || '.get_other_assignments', 90);
1208:
1209: EXCEPTION
1210: WHEN OTHERS THEN
1211: hr_utility.trace('Error in '|| gv_package_name || '.get_other_assignments');

Line 1211: hr_utility.trace('Error in '|| gv_package_name || '.get_other_assignments');

1207: hr_utility.set_location(gv_package_name || '.get_other_assignments', 90);
1208:
1209: EXCEPTION
1210: WHEN OTHERS THEN
1211: hr_utility.trace('Error in '|| gv_package_name || '.get_other_assignments');
1212: RAISE;
1213:
1214: END get_other_assignments;
1215:

Line 1223: -- hr_utility.trace_on(null, 'pyusyeaa');

1219: --------------------------------------------------------------------
1220:
1221: BEGIN
1222:
1223: -- hr_utility.trace_on(null, 'pyusyeaa');
1224: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 10);
1225:
1226: -- Get the date in canonical format
1227: l_effective_date := fnd_date.canonical_to_date(p_effective_date);

Line 1224: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 10);

1220:
1221: BEGIN
1222:
1223: -- hr_utility.trace_on(null, 'pyusyeaa');
1224: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 10);
1225:
1226: -- Get the date in canonical format
1227: l_effective_date := fnd_date.canonical_to_date(p_effective_date);
1228:

Line 1235: hr_utility.trace('Fetching GRE type (1099R/W2)');

1231: fetch c_gre_name into lv_gre_name,lv_business_group_id;
1232: close c_gre_name;
1233:
1234: -- Get GRE type
1235: hr_utility.trace('Fetching GRE type (1099R/W2)');
1236: open c_gre_type(p_gre_id);
1237: fetch c_gre_type into lv_gre_type;
1238: if c_gre_type%notfound then
1239: lv_gre_type := 'W2';

Line 1243: hr_utility.trace('Checking if Federal Magtape is run...');

1239: lv_gre_type := 'W2';
1240: end if;
1241: close c_gre_type;
1242:
1243: hr_utility.trace('Checking if Federal Magtape is run...');
1244: -- Check if the Federal Magtape is already processed in the year
1245: open c_w2_magtape_run_exists(l_effective_date,
1246: lv_business_group_id,
1247: lv_gre_type);

Line 1311: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 30);

1307: have an action in YEPP.
1308: */
1309:
1310: -- Call get_processed_assignments
1311: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 30);
1312: get_processed_assignments(l_effective_Date,
1313: p_gre_id,
1314: p_assign_set);
1315:

Line 1317: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 20);

1313: p_gre_id,
1314: p_assign_set);
1315:
1316: -- Call get_eligible_assignments
1317: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 20);
1318: get_eligible_assignments(l_effective_Date,
1319: p_gre_id,
1320: p_assign_set);
1321:

Line 1323: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 40);

1319: p_gre_id,
1320: p_assign_set);
1321:
1322: -- Call get_non_elgble_assignments
1323: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 40);
1324: get_non_elgble_assignments(p_assign_set,
1325: p_gre_id,
1326: l_effective_date);
1327:

Line 1328: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 50);

1324: get_non_elgble_assignments(p_assign_set,
1325: p_gre_id,
1326: l_effective_date);
1327:
1328: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 50);
1329:
1330:
1331: /***Start Formating of the out put for all Processed Assignments***/
1332:

Line 1333: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 70);

1329:
1330:
1331: /***Start Formating of the out put for all Processed Assignments***/
1332:
1333: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 70);
1334: if l_yepp_prc_asg_table.count>0 Then
1335:
1336: -- Print the Table Header
1337: print_table_header(l_prced_table_header,p_output_file_type);

Line 1341: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 80);

1337: print_table_header(l_prced_table_header,p_output_file_type);
1338:
1339: -- Report the Employees
1340:
1341: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 80);
1342:
1343: for l_assignment_id in l_yepp_prc_asg_table.first..l_yepp_prc_asg_table.last
1344: LOOP
1345: if l_yepp_prc_asg_table.exists(l_assignment_id) Then

Line 1346: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 90);

1342:
1343: for l_assignment_id in l_yepp_prc_asg_table.first..l_yepp_prc_asg_table.last
1344: LOOP
1345: if l_yepp_prc_asg_table.exists(l_assignment_id) Then
1346: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 90);
1347: print_table_details(l_yepp_prc_asg_table(l_assignment_id).c_assignment_id);
1348: end if;
1349: END LOOP;
1350:

Line 1357: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 100);

1353: end if;
1354:
1355: end if;
1356:
1357: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 100);
1358: -- If not processed assignment found from the assignment set
1359:
1360: if l_assignment_inserted=0 then
1361: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 110);

Line 1361: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 110);

1357: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 100);
1358: -- If not processed assignment found from the assignment set
1359:
1360: if l_assignment_inserted=0 then
1361: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 110);
1362: formated_zero_count(p_output_file_type,'PROCESSED');
1363: end if;
1364:
1365: /***End Formating of the out put for all Processed Assignments*****/

Line 1371: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 120);

1367:
1368: /***Start Formating of the out put for all Eligible Assignments****/
1369:
1370: l_assignment_inserted := 0;
1371: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 120);
1372: if l_yepp_elgble_asg_table.count >0 Then
1373:
1374: -- Print the Table Header
1375: print_table_header(l_elgbl_table_header,p_output_file_type);

Line 1378: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 130);

1374: -- Print the Table Header
1375: print_table_header(l_elgbl_table_header,p_output_file_type);
1376:
1377: -- Report all Eligible Assignments
1378: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 130);
1379:
1380: for l_assignment_id in l_yepp_elgble_asg_table.first..l_yepp_elgble_asg_table.last
1381:
1382: LOOP

Line 1385: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 140);

1381:
1382: LOOP
1383:
1384: if l_yepp_elgble_asg_table.exists(l_assignment_id) then
1385: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 140);
1386: print_table_details(l_yepp_elgble_asg_table(l_assignment_id).c_assignment_id);
1387:
1388: end if;
1389: END LOOP;

Line 1395: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 150);

1391: fnd_file.put_line(fnd_file.output,'') ;
1392: end if;
1393: end if;
1394:
1395: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 150);
1396:
1397: -- If no elgible assignments found
1398: if l_assignment_inserted=0 then
1399: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 260);

Line 1399: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 260);

1395: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 150);
1396:
1397: -- If no elgible assignments found
1398: if l_assignment_inserted=0 then
1399: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 260);
1400: formated_zero_count(p_output_file_type,'ELGBLE');
1401: end if;
1402:
1403: /***End Formating of the out put for all Eligible Assignments******/

Line 1409: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 170);

1405:
1406: /***Start Formating of the output for Non Eligible Assignments*****/
1407: --Print Non Eligible Employees
1408: l_assignment_inserted := 0;
1409: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 170);
1410: if l_yepp_not_elgble_asg_table.count >0 then
1411:
1412: -- Print the Table Header
1413: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 180);

Line 1413: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 180);

1409: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 170);
1410: if l_yepp_not_elgble_asg_table.count >0 then
1411:
1412: -- Print the Table Header
1413: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 180);
1414: print_table_header(l_nonelgbl_table_header,p_output_file_type);
1415:
1416: --Report Non Elgible Employees Output
1417:

Line 1421: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 190);

1417:
1418: for l_assignment_id in l_yepp_not_elgble_asg_table.first..l_yepp_not_elgble_asg_table.last
1419:
1420: LOOP
1421: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 190);
1422: if l_yepp_not_elgble_asg_table.exists(l_assignment_id) then
1423: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 200);
1424: print_table_details(l_yepp_not_elgble_asg_table(l_assignment_id).c_assignment_id);
1425:

Line 1423: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 200);

1419:
1420: LOOP
1421: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 190);
1422: if l_yepp_not_elgble_asg_table.exists(l_assignment_id) then
1423: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 200);
1424: print_table_details(l_yepp_not_elgble_asg_table(l_assignment_id).c_assignment_id);
1425:
1426: end if;
1427: END LOOP;

Line 1433: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 210);

1429: if p_output_file_type ='HTML' then
1430: fnd_file.put_line(fnd_file.output,'') ;
1431: end if;
1432:
1433: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 210);
1434: end if;
1435:
1436: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 220);
1437:

Line 1436: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 220);

1432:
1433: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 210);
1434: end if;
1435:
1436: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 220);
1437:
1438: -- When no employee found who is not elogible
1439: if l_assignment_inserted=0 then
1440:

Line 1441: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 230);

1437:
1438: -- When no employee found who is not elogible
1439: if l_assignment_inserted=0 then
1440:
1441: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 230);
1442: formated_zero_count(p_output_file_type,'NOTELGBLE');
1443: end if;
1444:
1445: /***End Formating of the output for Non Eligible Assignments*******/

Line 1449: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 240);

1445: /***End Formating of the output for Non Eligible Assignments*******/
1446:
1447:
1448: -- Call report_secondary_assignments
1449: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 240);
1450: report_secondary_assignments(p_assign_set,
1451: p_gre_id,
1452: l_effective_date);
1453:

Line 1454: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 250);

1450: report_secondary_assignments(p_assign_set,
1451: p_gre_id,
1452: l_effective_date);
1453:
1454: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 250);
1455: -- Call get_other_assignments
1456: get_other_assignments(p_assign_set,
1457: p_gre_id,
1458: l_effective_date);

Line 1460: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 260);

1456: get_other_assignments(p_assign_set,
1457: p_gre_id,
1458: l_effective_date);
1459:
1460: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 260);
1461:
1462: close c_w2_magtape_run_exists;
1463:
1464: if p_output_file_type ='HTML' then

Line 1470: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 270);

1466: end if;
1467:
1468: end if; -- Magnetic tape not processed
1469:
1470: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 270);
1471:
1472: -- Update the concurrent program request if the output type is HTML
1473: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 280);
1474: if p_output_file_type ='HTML' then

Line 1473: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 280);

1469:
1470: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 270);
1471:
1472: -- Update the concurrent program request if the output type is HTML
1473: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 280);
1474: if p_output_file_type ='HTML' then
1475: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 290);
1476: UPDATE fnd_concurrent_requests
1477: SET output_file_type = 'HTML'

Line 1475: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 290);

1471:
1472: -- Update the concurrent program request if the output type is HTML
1473: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 280);
1474: if p_output_file_type ='HTML' then
1475: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 290);
1476: UPDATE fnd_concurrent_requests
1477: SET output_file_type = 'HTML'
1478: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID ;
1479:

Line 1482: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 300);

1478: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID ;
1479:
1480: commit;
1481: end if;
1482: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 300);
1483:
1484: EXCEPTION
1485: WHEN OTHERS THEN
1486: hr_utility.trace('Error in '|| gv_package_name || '.add_actions_to_yepp');

Line 1486: hr_utility.trace('Error in '|| gv_package_name || '.add_actions_to_yepp');

1482: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 300);
1483:
1484: EXCEPTION
1485: WHEN OTHERS THEN
1486: hr_utility.trace('Error in '|| gv_package_name || '.add_actions_to_yepp');
1487: RAISE;
1488:
1489: END add_actions_to_yepp;
1490: