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.

[Home] [Help]

APPS.PAYUSUNB_PKG dependencies on HR_UTILITY

Line 491: hr_utility.set_location('procpyr',1);

487: p_report_type => 'PAYUSUNB'
488: ,p_report_format => 'DEFAULT'
489: ,p_report_qualifier => 'DEFAULT'
490: ,p_report_category => 'REPORT');
491: hr_utility.set_location('procpyr',1);
492: if l_range_person then
493: OPEN c_actions_person_on(IN_pactid, IN_chunk);
494: else
495: OPEN c_actions(IN_stperson, IN_endperson, L_gre_id,

Line 501: hr_utility.set_location('procpyr',2);

497: L_start_date, L_as_of_date);
498: end if;
499:
500: LOOP
501: hr_utility.set_location('procpyr',2);
502: if l_range_person then
503: FETCH c_actions_person_on INTO L_person_id;
504: EXIT WHEN c_actions_person_on%NOTFOUND;
505: else

Line 518: hr_utility.trace('L_person_id = '||to_char(L_person_id));

514:
515: -- we need to insert one action for each of the
516: -- rows that we return FROM the cursor (i.e. one
517: -- for each assignment/pre-payment/reversal).
518: hr_utility.trace('L_person_id = '||to_char(L_person_id));
519: hr_utility.trace('L_org_id = '||to_char(L_org_id));
520: hr_utility.trace('L_location_id = '||to_char(L_location_id));
521: hr_utility.trace('L_as_of_date = '||L_as_of_date);
522: hr_utility.trace('L_start_date = '||L_start_date);

Line 519: hr_utility.trace('L_org_id = '||to_char(L_org_id));

515: -- we need to insert one action for each of the
516: -- rows that we return FROM the cursor (i.e. one
517: -- for each assignment/pre-payment/reversal).
518: hr_utility.trace('L_person_id = '||to_char(L_person_id));
519: hr_utility.trace('L_org_id = '||to_char(L_org_id));
520: hr_utility.trace('L_location_id = '||to_char(L_location_id));
521: hr_utility.trace('L_as_of_date = '||L_as_of_date);
522: hr_utility.trace('L_start_date = '||L_start_date);
523: hr_utility.trace('L_gre_id = '||to_char(L_gre_id));

Line 520: hr_utility.trace('L_location_id = '||to_char(L_location_id));

516: -- rows that we return FROM the cursor (i.e. one
517: -- for each assignment/pre-payment/reversal).
518: hr_utility.trace('L_person_id = '||to_char(L_person_id));
519: hr_utility.trace('L_org_id = '||to_char(L_org_id));
520: hr_utility.trace('L_location_id = '||to_char(L_location_id));
521: hr_utility.trace('L_as_of_date = '||L_as_of_date);
522: hr_utility.trace('L_start_date = '||L_start_date);
523: hr_utility.trace('L_gre_id = '||to_char(L_gre_id));
524:

Line 521: hr_utility.trace('L_as_of_date = '||L_as_of_date);

517: -- for each assignment/pre-payment/reversal).
518: hr_utility.trace('L_person_id = '||to_char(L_person_id));
519: hr_utility.trace('L_org_id = '||to_char(L_org_id));
520: hr_utility.trace('L_location_id = '||to_char(L_location_id));
521: hr_utility.trace('L_as_of_date = '||L_as_of_date);
522: hr_utility.trace('L_start_date = '||L_start_date);
523: hr_utility.trace('L_gre_id = '||to_char(L_gre_id));
524:
525: OPEN c_get_latest_asg(L_person_id,L_gre_id,L_as_of_date,

Line 522: hr_utility.trace('L_start_date = '||L_start_date);

518: hr_utility.trace('L_person_id = '||to_char(L_person_id));
519: hr_utility.trace('L_org_id = '||to_char(L_org_id));
520: hr_utility.trace('L_location_id = '||to_char(L_location_id));
521: hr_utility.trace('L_as_of_date = '||L_as_of_date);
522: hr_utility.trace('L_start_date = '||L_start_date);
523: hr_utility.trace('L_gre_id = '||to_char(L_gre_id));
524:
525: OPEN c_get_latest_asg(L_person_id,L_gre_id,L_as_of_date,
526: L_start_date,L_org_id,L_location_id);

Line 523: hr_utility.trace('L_gre_id = '||to_char(L_gre_id));

519: hr_utility.trace('L_org_id = '||to_char(L_org_id));
520: hr_utility.trace('L_location_id = '||to_char(L_location_id));
521: hr_utility.trace('L_as_of_date = '||L_as_of_date);
522: hr_utility.trace('L_start_date = '||L_start_date);
523: hr_utility.trace('L_gre_id = '||to_char(L_gre_id));
524:
525: OPEN c_get_latest_asg(L_person_id,L_gre_id,L_as_of_date,
526: L_start_date,L_org_id,L_location_id);
527: FETCH c_get_latest_asg INTO L_lockedactid; /* Change for Performance Bug 6360505 */

Line 530: hr_utility.trace('L_lockedactid ' || L_lockedactid);

526: L_start_date,L_org_id,L_location_id);
527: FETCH c_get_latest_asg INTO L_lockedactid; /* Change for Performance Bug 6360505 */
528: CLOSE c_get_latest_asg;
529:
530: hr_utility.trace('L_lockedactid ' || L_lockedactid);
531: /* Change for Performance Bug 6360505 */
532: OPEN c_get_asg_details(L_lockedactid, L_gre_id, L_person_id,
533: L_as_of_date, L_start_date);
534: FETCH c_get_asg_details INTO L_assignid,L_loc_id,

Line 539: hr_utility.trace('L_assignid '||to_char(L_assignid));

535: L_organization_id,L_assignment_number;
536: CLOSE c_get_asg_details;
537: /* Change for Performance Bug 6360505 */
538:
539: hr_utility.trace('L_assignid '||to_char(L_assignid));
540: hr_utility.trace('L_assignid ' || L_assignid);
541: hr_utility.set_location('procpyr',3);
542:
543: SELECT pay_assignment_actions_s.NEXTVAL

Line 540: hr_utility.trace('L_assignid ' || L_assignid);

536: CLOSE c_get_asg_details;
537: /* Change for Performance Bug 6360505 */
538:
539: hr_utility.trace('L_assignid '||to_char(L_assignid));
540: hr_utility.trace('L_assignid ' || L_assignid);
541: hr_utility.set_location('procpyr',3);
542:
543: SELECT pay_assignment_actions_s.NEXTVAL
544: INTO L_lockingactid

Line 541: hr_utility.set_location('procpyr',3);

537: /* Change for Performance Bug 6360505 */
538:
539: hr_utility.trace('L_assignid '||to_char(L_assignid));
540: hr_utility.trace('L_assignid ' || L_assignid);
541: hr_utility.set_location('procpyr',3);
542:
543: SELECT pay_assignment_actions_s.NEXTVAL
544: INTO L_lockingactid
545: FROM dual;

Line 687: --hr_utility.trace('Error: PAYUSUNB_PKG.fnc_get_parameter failed - ORA'||TO_CHAR(SQLCODE));

683: RETURN L_par_value;
684:
685: EXCEPTION
686: WHEN OTHERS THEN
687: --hr_utility.trace('Error: PAYUSUNB_PKG.fnc_get_parameter failed - ORA'||TO_CHAR(SQLCODE));
688: RAISE;
689: END fnc_get_parameter;
690:
691: /*************************************************************************

Line 917: hr_utility.trace('L_count ' || to_char(l_count));

913: OPEN c_get_state_code(IN_sui_state_code);
914: FETCH c_get_state_code into l_sui_state_code;
915: CLOSE c_get_state_code;
916:
917: hr_utility.trace('L_count ' || to_char(l_count));
918: hr_utility.trace('Org Id ' || to_char(IN_organization_id));
919: IF l_count > 0 THEN
920: For i in 1..l_count
921: LOOP

Line 918: hr_utility.trace('Org Id ' || to_char(IN_organization_id));

914: FETCH c_get_state_code into l_sui_state_code;
915: CLOSE c_get_state_code;
916:
917: hr_utility.trace('L_count ' || to_char(l_count));
918: hr_utility.trace('Org Id ' || to_char(IN_organization_id));
919: IF l_count > 0 THEN
920: For i in 1..l_count
921: LOOP
922: hr_utility.trace('IN_sui_state_code : ' || IN_sui_state_code);

Line 922: hr_utility.trace('IN_sui_state_code : ' || IN_sui_state_code);

918: hr_utility.trace('Org Id ' || to_char(IN_organization_id));
919: IF l_count > 0 THEN
920: For i in 1..l_count
921: LOOP
922: hr_utility.trace('IN_sui_state_code : ' || IN_sui_state_code);
923: IF payusunb_pkg.futa_credit_info.exists(i) THEN
924: IF payusunb_pkg.futa_credit_info(i).organization_id = IN_organization_id THEN
925: l_flag := 'T' ;
926: IF (payusunb_pkg.futa_credit_info(i).sui_state_code = l_sui_state_code) THEN

Line 940: hr_utility.trace('State_code pupulated : ' || l_futa_state_code);

936: LOOP
937: l_count := l_count + 1;
938: FETCH c_get_futa_credit_rt INTO l_futa_state_code,l_futa_credit_rate ;
939: EXIT WHEN c_get_futa_credit_rt%NOTFOUND;
940: hr_utility.trace('State_code pupulated : ' || l_futa_state_code);
941: payusunb_pkg.futa_credit_info(l_count).organization_id := IN_organization_id;
942: payusunb_pkg.futa_credit_info(l_count).sui_state_code := l_futa_state_code;
943: payusunb_pkg.futa_credit_info(l_count).futa_credit_rate := NVL(l_futa_credit_rate,0);
944: IF l_futa_state_code = IN_sui_state_code THEN

Line 951: hr_utility.trace('return value : ' || L_return_val);

947:
948: END LOOP;
949: CLOSE c_get_futa_credit_rt;
950: END IF;
951: hr_utility.trace('return value : ' || L_return_val);
952:
953: RETURN nvl(L_return_val,0);
954:
955: END fnc_get_futa_credit_rate;

Line 984: hr_utility.trace('Inside the sui_override');

980: ln_count NUMBER;
981:
982: BEGIN
983: IF payusunb_pkg.sui_sdi_override_info.count < 1 THEN
984: hr_utility.trace('Inside the sui_override');
985: OPEN c_get_sui_sdi_overide_rt ( IN_tax_unit_id );
986: LOOP
987: FETCH c_get_sui_sdi_overide_rt INTO lv_state_code,ln_sui_override_rt,ln_sui_dummy_rt,ln_sdi_override_rt ;
988: EXIT WHEN c_get_sui_sdi_overide_rt%NOTFOUND;

Line 3731: hr_utility.trace('Balances are valid .Inside vailid state cursor');

3727: /************************ 3005756 start *******************************************************/
3728:
3729: IF G_state_flag = 'Y' THEN
3730:
3731: hr_utility.trace('Balances are valid .Inside vailid state cursor');
3732:
3733: FOR curr_state IN c_state_jurisdictions_valid(IN_prc_person_id,
3734: L_tax_type_state, L_start_date,
3735: L_as_of_date)

Line 3743: hr_utility.trace('Balances are invalid .Inside invalid state cursor');

3739:
3740: END LOOP; -- end curr_state
3741:
3742: ELSE
3743: hr_utility.trace('Balances are invalid .Inside invalid state cursor');
3744:
3745: FOR curr_state IN c_state_jurisdictions(IN_prc_person_id,
3746: L_tax_type_state, L_start_date,
3747: L_as_of_date)

Line 3770: hr_utility.trace('Balances are valid .Inside valid county cursor');

3766:
3767: /******************** 3005756 start ***********************************************/
3768:
3769: IF G_county_flag = 'Y' THEN
3770: hr_utility.trace('Balances are valid .Inside valid county cursor');
3771:
3772: FOR curr_county IN c_county_jurisdictions_valid(IN_prc_person_id,
3773: L_tax_type_state, L_start_date,
3774: L_as_of_date)

Line 3782: hr_utility.trace('Balances are invalid .Inside invalid county cursor');

3778:
3779: END LOOP; -- end curr_county loop
3780:
3781: ELSE
3782: hr_utility.trace('Balances are invalid .Inside invalid county cursor');
3783:
3784: FOR curr_county IN c_county_jurisdictions(IN_prc_person_id,
3785: L_tax_type_state, L_start_date,
3786: L_as_of_date)

Line 3803: hr_utility.trace('Balances are valid .Inside valid city cursor');

3799:
3800: /*********************** 3005756 start *****************************************/
3801:
3802: IF G_city_flag = 'Y' THEN
3803: hr_utility.trace('Balances are valid .Inside valid city cursor');
3804:
3805: FOR curr_city IN c_city_jurisdictions_valid(IN_prc_person_id,
3806: L_tax_type_state, L_start_date,
3807: L_as_of_date)

Line 3815: hr_utility.trace('Balances are invalid .Inside invalid city cursor');

3811:
3812: END LOOP; -- end curr_city loop
3813:
3814: ELSE
3815: hr_utility.trace('Balances are invalid .Inside invalid city cursor');
3816:
3817: FOR curr_city IN c_city_jurisdictions(IN_prc_person_id,
3818: L_tax_type_state, L_start_date,
3819: L_as_of_date)

Line 3836: hr_utility.trace('Balances are valid .Inside valid school cursor');

3832:
3833: /**************************** 3005756 start **********************************/
3834:
3835: IF G_school_flag = 'Y' THEN
3836: hr_utility.trace('Balances are valid .Inside valid school cursor');
3837:
3838: FOR curr_school IN c_school_jurisdictions_valid(IN_prc_person_id,
3839: L_tax_type_state,
3840: IN_prc_tax_unit_id, L_start_date,

Line 3851: hr_utility.trace('Balances are invalid .Inside invalid school cursor');

3847:
3848: END LOOP; -- end curr_school loop
3849:
3850: ELSE
3851: hr_utility.trace('Balances are invalid .Inside invalid school cursor');
3852:
3853: FOR curr_school IN c_school_jurisdictions(IN_prc_person_id,
3854: L_tax_type_state,
3855: IN_prc_tax_unit_id, L_start_date,