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

Line 516: -- hr_utility.trace_on(null,'EQUITY');

512: l_person_exists char(1);
513: l_asgchk_flag char(1);
514: Begin
515:
516: -- hr_utility.trace_on(null,'EQUITY');
517: hr_utility.trace('Enter in employee_dtls');
518: v_year_start := trunc(to_date(p_year,'YYYY'),'Y');
519: v_year_end := add_months(trunc(to_date(p_year,'YYYY'),'Y'), 12) -1;
520: l_excep_cnt := 0;

Line 517: hr_utility.trace('Enter in employee_dtls');

513: l_asgchk_flag char(1);
514: Begin
515:
516: -- hr_utility.trace_on(null,'EQUITY');
517: hr_utility.trace('Enter in employee_dtls');
518: v_year_start := trunc(to_date(p_year,'YYYY'),'Y');
519: v_year_end := add_months(trunc(to_date(p_year,'YYYY'),'Y'), 12) -1;
520: l_excep_cnt := 0;
521: hr_utility.trace('p_business_group_id '||p_business_group_id);

Line 521: hr_utility.trace('p_business_group_id '||p_business_group_id);

517: hr_utility.trace('Enter in employee_dtls');
518: v_year_start := trunc(to_date(p_year,'YYYY'),'Y');
519: v_year_end := add_months(trunc(to_date(p_year,'YYYY'),'Y'), 12) -1;
520: l_excep_cnt := 0;
521: hr_utility.trace('p_business_group_id '||p_business_group_id);
522: hr_utility.trace('p_year '||p_year);
523: hr_utility.trace('p_naic_code '||p_naic_code);
524: /* Added by ssmukher for Bug */
525: l_asgchk_flag := 'Y';

Line 522: hr_utility.trace('p_year '||p_year);

518: v_year_start := trunc(to_date(p_year,'YYYY'),'Y');
519: v_year_end := add_months(trunc(to_date(p_year,'YYYY'),'Y'), 12) -1;
520: l_excep_cnt := 0;
521: hr_utility.trace('p_business_group_id '||p_business_group_id);
522: hr_utility.trace('p_year '||p_year);
523: hr_utility.trace('p_naic_code '||p_naic_code);
524: /* Added by ssmukher for Bug */
525: l_asgchk_flag := 'Y';
526:

Line 523: hr_utility.trace('p_naic_code '||p_naic_code);

519: v_year_end := add_months(trunc(to_date(p_year,'YYYY'),'Y'), 12) -1;
520: l_excep_cnt := 0;
521: hr_utility.trace('p_business_group_id '||p_business_group_id);
522: hr_utility.trace('p_year '||p_year);
523: hr_utility.trace('p_naic_code '||p_naic_code);
524: /* Added by ssmukher for Bug */
525: l_asgchk_flag := 'Y';
526:
527: /* Added by ssmukher in v115.1

Line 563: hr_utility.trace('The value of l_asgchk_flag is '||l_asgchk_flag);

559: end if;
560:
561:
562: open cur_emp_categ_person(v_year_start);
563: hr_utility.trace('The value of l_asgchk_flag is '||l_asgchk_flag);
564: loop -- cur_emp_categ_person(v_year_start)
565:
566: fetch cur_emp_categ_person
567: into l_personid,

Line 589: hr_utility.set_message(800,'PAY_74160_SUPER_USER');

585: into l_person_exists;
586:
587: if c_person_exists%notfound then
588: close c_person_exists;
589: hr_utility.set_message(800,'PAY_74160_SUPER_USER');
590: pay_core_utils.push_message(800,'PAY_74160_SUPER_USER','P');
591: hr_utility.raise_error;
592: else
593: close c_person_exists;

Line 591: hr_utility.raise_error;

587: if c_person_exists%notfound then
588: close c_person_exists;
589: hr_utility.set_message(800,'PAY_74160_SUPER_USER');
590: pay_core_utils.push_message(800,'PAY_74160_SUPER_USER','P');
591: hr_utility.raise_error;
592: else
593: close c_person_exists;
594: end if;
595:

Line 613: hr_utility.trace('Assignment Id :'||l_asg_id);

609: l_employment_category,
610: l_loc_id,
611: l_keyflex_id,
612: l_st_date;
613: hr_utility.trace('Assignment Id :'||l_asg_id);
614:
615: else
616: fetch cur_emp_categ_naic_asg
617: into l_asg_id,

Line 622: hr_utility.trace('l_asg_id '||l_asg_id);

618: l_noc_code,
619: l_employment_category,
620: l_loc_id,
621: l_st_date;
622: hr_utility.trace('l_asg_id '||l_asg_id);
623: hr_utility.trace('l_employment_category '||l_employment_category);
624:
625: end if;
626: /* Added by ssmukher for Bug 4493278 */

Line 623: hr_utility.trace('l_employment_category '||l_employment_category);

619: l_employment_category,
620: l_loc_id,
621: l_st_date;
622: hr_utility.trace('l_asg_id '||l_asg_id);
623: hr_utility.trace('l_employment_category '||l_employment_category);
624:
625: end if;
626: /* Added by ssmukher for Bug 4493278 */
627: if p_naic_code is null then

Line 635: hr_utility.trace('Code is null');

631: l_asgchk_flag := 'Y';
632: end if;
633: close cur_emp_categ_asg ;
634: else
635: hr_utility.trace('Code is null');
636: if cur_emp_categ_naic_asg%notfound then
637: l_asgchk_flag := 'N';
638: else
639: l_asgchk_flag := 'Y';

Line 679: hr_utility.trace('The NAIC code for GRE is '||l_naics_no);

675: l_naics_no := lpad(l_naics_no,4,'0');
676: end if;
677: close cur_naic_code;
678:
679: hr_utility.trace('The NAIC code for GRE is '||l_naics_no);
680: else
681: /* Added by ssmukher for Bug 4501549 */
682: open cur_naic_code(l_keyflex_id);
683: fetch cur_naic_code

Line 808: hr_utility.trace('l_end_dt '||to_char(l_end_dt,'YYYY-MM-DD'));

804: end if;
805: -- if condition added for bug 10287946
806: if l_end_dt is null then
807: l_end_dt := trunc(to_date(to_char(v_year_end,'YYYY')+101,'YYYY'),'YYYY')-1;
808: hr_utility.trace('l_end_dt '||to_char(l_end_dt,'YYYY-MM-DD'));
809: end if;
810: insert into
811: per_ca_ee_report_lines (REQUEST_ID ,
812: LINE_NUMBER,

Line 844: hr_utility.trace('Employee '||l_emp_no||' has l_tmp_cnt');

840: ||fnd_global.local_chr(9)||fnd_global.local_chr(9);
841: --commented for bug 10287946
842: /* else
843: if l_tmp_cnt > 0 then
844: hr_utility.trace('Employee '||l_emp_no||' has l_tmp_cnt');
845: hr_utility.trace('l_employment_category '||l_employment_category);
846: l_output_txt := l_emp_no|| fnd_global.local_chr(9)||l_cma_code||fnd_global.local_chr(9)||l_province
847: ||fnd_global.local_chr(9)||l_noc_code||fnd_global.local_chr(9)||l_naics_no||fnd_global.local_chr(9)
848: ||l_employment_category||fnd_global.local_chr(9)||fnd_global.local_chr(9)

Line 845: hr_utility.trace('l_employment_category '||l_employment_category);

841: --commented for bug 10287946
842: /* else
843: if l_tmp_cnt > 0 then
844: hr_utility.trace('Employee '||l_emp_no||' has l_tmp_cnt');
845: hr_utility.trace('l_employment_category '||l_employment_category);
846: l_output_txt := l_emp_no|| fnd_global.local_chr(9)||l_cma_code||fnd_global.local_chr(9)||l_province
847: ||fnd_global.local_chr(9)||l_noc_code||fnd_global.local_chr(9)||l_naics_no||fnd_global.local_chr(9)
848: ||l_employment_category||fnd_global.local_chr(9)||fnd_global.local_chr(9)
849: ||l_gender||fnd_global.local_chr(9)

Line 878: --hr_utility.trace('The value of the person id is '||l_personid);

874:
875: /* Inserting the Promotion details in the table */
876: begin
877: l_promo_cnt := 0;
878: --hr_utility.trace('The value of the person id is '||l_personid);
879: /* Added by ssmukher in v115.1 */
880: /* Checking firstly if the employee details are correct */
881: if l_flag = 'Y' then
882:

Line 921: hr_utility.trace('The value of promotion number is '||l_promo_no);

917: v_year_end,
918: table_date);
919: end if;
920:
921: hr_utility.trace('The value of promotion number is '||l_promo_no);
922: hr_utility.trace('The first record in the plsql table is '||nvl(table_date.count,0));
923: hr_utility.trace('The person_id been checked is '||l_personid);
924:
925: if l_flag = 'Y' then

Line 922: hr_utility.trace('The first record in the plsql table is '||nvl(table_date.count,0));

918: table_date);
919: end if;
920:
921: hr_utility.trace('The value of promotion number is '||l_promo_no);
922: hr_utility.trace('The first record in the plsql table is '||nvl(table_date.count,0));
923: hr_utility.trace('The person_id been checked is '||l_personid);
924:
925: if l_flag = 'Y' then
926: if l_promo_no <> 0 then

Line 923: hr_utility.trace('The person_id been checked is '||l_personid);

919: end if;
920:
921: hr_utility.trace('The value of promotion number is '||l_promo_no);
922: hr_utility.trace('The first record in the plsql table is '||nvl(table_date.count,0));
923: hr_utility.trace('The person_id been checked is '||l_personid);
924:
925: if l_flag = 'Y' then
926: if l_promo_no <> 0 then
927:

Line 930: hr_utility.trace('Inside the PLSQl table ');

926: if l_promo_no <> 0 then
927:
928: for i in nvl(table_date.first,0)..nvl(table_date.last,-1)
929: loop
930: hr_utility.trace('Inside the PLSQl table ');
931: hr_utility.trace('The value of the date fetched is '||table_date(i));
932: l_promo_cnt := l_promo_cnt + 1;
933: insert into
934: per_ca_ee_report_lines (REQUEST_ID ,

Line 931: hr_utility.trace('The value of the date fetched is '||table_date(i));

927:
928: for i in nvl(table_date.first,0)..nvl(table_date.last,-1)
929: loop
930: hr_utility.trace('Inside the PLSQl table ');
931: hr_utility.trace('The value of the date fetched is '||table_date(i));
932: l_promo_cnt := l_promo_cnt + 1;
933: insert into
934: per_ca_ee_report_lines (REQUEST_ID ,
935: LINE_NUMBER,

Line 951: hr_utility.trace('Outside the cur_emp_categ cursor ');

947: end;
948: end if; /* Added by ssmukher for Bug No 4493278 */
949: end loop; -- end cur_emp_categ_person(v_year_start)
950:
951: hr_utility.trace('Outside the cur_emp_categ cursor ');
952: close cur_emp_categ_person;
953: COMMIT;
954: End;
955:

Line 1116: -- hr_utility.trace_on(null,'Exception');

1112: l_flag char(1);
1113: l_output varchar2(1000);
1114: l_count number;
1115: begin
1116: -- hr_utility.trace_on(null,'Exception');
1117: l_flag := 'N';
1118: open c_excep_report;
1119: loop
1120: fetch c_excep_report

Line 1132: hr_utility.trace('The value of Employee number is '||l_emp_no);

1128: if c_excep_report%notfound then
1129: exit;
1130: end if;
1131: l_count := 0;
1132: hr_utility.trace('The value of Employee number is '||l_emp_no);
1133: l_output := 'Following information are missing for Employee :'||l_emp_no;
1134: if l_prov is not null then
1135: l_count := l_count + 1;
1136: l_output := l_output ||fnd_global.local_chr(9)||l_count||')'|| l_prov;