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

Line 336: hr_utility.trace('magtape must be terminated as FCN already exists');

332: --
333: IF l_override_fcn = 1 THEN -- i.e does exist
334: --
335: -- NEED TO RAISE AN ERROR THAT CAN BE RAISED IN FAST FORMULA
336: hr_utility.trace('magtape must be terminated as FCN already exists');
337: -- dbms_output.put_line('magtape must be terminated as FCN already exists');
338: l_new_fcn := 1.1;
339: RETURN l_new_fcn;
340: ELSE -- Override does not exist on FCN table

Line 631: hr_utility.trace('l_max_pact_id: '||to_char(l_max_pact_id));

627: -- digits only
628:
629: open digits_only_max_sequence(p_org_pmt_method_id, p_bg_id);
630: fetch digits_only_max_sequence into l_max_pact_id;
631: hr_utility.trace('l_max_pact_id: '||to_char(l_max_pact_id));
632:
633: if digits_only_max_sequence%FOUND and
634: l_max_pact_id is not NULL then
635:

Line 638: hr_utility.trace('Digits_only_max_sequence found ');

634: l_max_pact_id is not NULL then
635:
636: -- Get the potential new FCN
637:
638: hr_utility.trace('Digits_only_max_sequence found ');
639: open get_new_fcn(l_var, p_org_pmt_method_id, l_max_pact_id,
640: p_bg_id);
641: fetch get_new_fcn into l_new_fcn;
642: close get_new_fcn;

Line 644: hr_utility.trace('1st new fcn l_new_fcn: '||l_new_fcn);

640: p_bg_id);
641: fetch get_new_fcn into l_new_fcn;
642: close get_new_fcn;
643: l_new_fcn := lpad(l_new_fcn,4,'0');
644: hr_utility.trace('1st new fcn l_new_fcn: '||l_new_fcn);
645: -- dbms_output.put_line('1st new fcn is '||l_new_fcn);
646:
647: -- Check if the potential FCN already exists in last N records
648:

Line 653: hr_utility.trace('l_fcn_exists: '||to_char(l_fcn_exists));

649: open current_fcns(p_org_pmt_method_id, l_new_fcn,
650: p_bg_id,p_no_fcn_rows);
651: fetch current_fcns into l_fcn_exists;
652: close current_fcns;
653: hr_utility.trace('l_fcn_exists: '||to_char(l_fcn_exists));
654: -- dbms_output.put_line('l_exists is '||l_fcn_exists);
655: --
656: -- If the potential FCN does already exist in last N records
657: -- then keep adding 1 to the number

Line 662: hr_utility.trace('l_fcn_exists is satisfied');

658: -- until it does not exist. This will be the new FCN.
659: --
660: if l_fcn_exists = 1 then
661:
662: hr_utility.trace('l_fcn_exists is satisfied');
663: loop
664: l_var := l_var + 1;
665: l_fcn_exists := 0;
666: open get_new_fcn(l_var, p_org_pmt_method_id,

Line 672: hr_utility.trace('In the loop l_new_fcn: '||l_new_fcn);

668: fetch get_new_fcn into l_new_fcn;
669: close get_new_fcn;
670: l_new_fcn := lpad(l_new_fcn,4,'0');
671:
672: hr_utility.trace('In the loop l_new_fcn: '||l_new_fcn);
673: -- dbms_output.put_line('lnewfcn is
674: -- '||l_new_fcn);
675:
676: open current_fcns(p_org_pmt_method_id, l_new_fcn,

Line 683: hr_utility.trace('In the loop l_fcn_exists: '||l_fcn_exists);

679:
680: -- dbms_output.put_line('l_fcn_exists is
681: -- '||l_fcn_exists);
682:
683: hr_utility.trace('In the loop l_fcn_exists: '||l_fcn_exists);
684: exit when current_fcns%NOTFOUND;
685:
686: close current_fcns;
687: end loop;

Line 707: hr_utility.trace('Final FCN Generated, before Update the l_new_fcn:'||l_new_fcn);

703: --
704: -- Stamp New FCN record in pay_payroll_actions table
705:
706: l_new_fcn := lpad(l_new_fcn,4,'0');
707: hr_utility.trace('Final FCN Generated, before Update the l_new_fcn:'||l_new_fcn);
708: insert_new_fcn(p_org_pmt_method_id,l_new_fcn,p_pact_id);
709:
710: RETURN l_new_fcn;
711: END; --get_actual_dd_fcn

Line 715: /* hr_utility.trace_on('Y','TESTFCN'); */

711: END; --get_actual_dd_fcn
712:
713:
714: BEGIN -- Main function get_dd_file_creation_number
715: /* hr_utility.trace_on('Y','TESTFCN'); */
716: hr_utility.trace('Start of Get_dd_file_Creation_Number function');
717: --
718: -- Does any DD exist for the given Payment Method in
719: -- pay_payroll_actions table?

Line 716: hr_utility.trace('Start of Get_dd_file_Creation_Number function');

712:
713:
714: BEGIN -- Main function get_dd_file_creation_number
715: /* hr_utility.trace_on('Y','TESTFCN'); */
716: hr_utility.trace('Start of Get_dd_file_Creation_Number function');
717: --
718: -- Does any DD exist for the given Payment Method in
719: -- pay_payroll_actions table?
720: -- l_max_pact_id is not null then Exists

Line 723: hr_utility.trace('p_business_group_id :'||to_char(p_business_group_id));

719: -- pay_payroll_actions table?
720: -- l_max_pact_id is not null then Exists
721: -- l_max_pact_id is null then Not exists
722:
723: hr_utility.trace('p_business_group_id :'||to_char(p_business_group_id));
724: hr_utility.trace('p_org_payment_method_id :'||to_char(p_org_payment_method_id));
725: hr_utility.trace('p_fin_institution :'||p_fin_institution);
726: hr_utility.trace('p_override_fcn : '||p_override_fcn);
727: hr_utility.trace('p_pact_id :'||to_char(p_pact_id));

Line 724: hr_utility.trace('p_org_payment_method_id :'||to_char(p_org_payment_method_id));

720: -- l_max_pact_id is not null then Exists
721: -- l_max_pact_id is null then Not exists
722:
723: hr_utility.trace('p_business_group_id :'||to_char(p_business_group_id));
724: hr_utility.trace('p_org_payment_method_id :'||to_char(p_org_payment_method_id));
725: hr_utility.trace('p_fin_institution :'||p_fin_institution);
726: hr_utility.trace('p_override_fcn : '||p_override_fcn);
727: hr_utility.trace('p_pact_id :'||to_char(p_pact_id));
728:

Line 725: hr_utility.trace('p_fin_institution :'||p_fin_institution);

721: -- l_max_pact_id is null then Not exists
722:
723: hr_utility.trace('p_business_group_id :'||to_char(p_business_group_id));
724: hr_utility.trace('p_org_payment_method_id :'||to_char(p_org_payment_method_id));
725: hr_utility.trace('p_fin_institution :'||p_fin_institution);
726: hr_utility.trace('p_override_fcn : '||p_override_fcn);
727: hr_utility.trace('p_pact_id :'||to_char(p_pact_id));
728:
729: open digits_only_max_sequence(p_org_payment_method_id,

Line 726: hr_utility.trace('p_override_fcn : '||p_override_fcn);

722:
723: hr_utility.trace('p_business_group_id :'||to_char(p_business_group_id));
724: hr_utility.trace('p_org_payment_method_id :'||to_char(p_org_payment_method_id));
725: hr_utility.trace('p_fin_institution :'||p_fin_institution);
726: hr_utility.trace('p_override_fcn : '||p_override_fcn);
727: hr_utility.trace('p_pact_id :'||to_char(p_pact_id));
728:
729: open digits_only_max_sequence(p_org_payment_method_id,
730: p_business_group_id);

Line 727: hr_utility.trace('p_pact_id :'||to_char(p_pact_id));

723: hr_utility.trace('p_business_group_id :'||to_char(p_business_group_id));
724: hr_utility.trace('p_org_payment_method_id :'||to_char(p_org_payment_method_id));
725: hr_utility.trace('p_fin_institution :'||p_fin_institution);
726: hr_utility.trace('p_override_fcn : '||p_override_fcn);
727: hr_utility.trace('p_pact_id :'||to_char(p_pact_id));
728:
729: open digits_only_max_sequence(p_org_payment_method_id,
730: p_business_group_id);
731: fetch digits_only_max_sequence into l_max_pact_id;

Line 734: hr_utility.trace('l_max_pact_id :'||to_char(l_max_pact_id));

730: p_business_group_id);
731: fetch digits_only_max_sequence into l_max_pact_id;
732: close digits_only_max_sequence;
733:
734: hr_utility.trace('l_max_pact_id :'||to_char(l_max_pact_id));
735: -- Check how many max FCN rows allowed for a particular
736: -- Financial Institution.
737: --
738: open get_num_fcns_allowed(p_fin_institution);

Line 745: hr_utility.trace('l_fcn_rows :'||to_char(l_fcn_rows));

741: if get_num_fcns_allowed%NOTFOUND then
742: l_fcn_rows := 50;
743: end if;
744: close get_num_fcns_allowed;
745: hr_utility.trace('l_fcn_rows :'||to_char(l_fcn_rows));
746: --
747:
748: hr_utility.trace('p_override_fcn : '||p_override_fcn);
749: /* check if there exists atleast one DD for the given

Line 748: hr_utility.trace('p_override_fcn : '||p_override_fcn);

744: close get_num_fcns_allowed;
745: hr_utility.trace('l_fcn_rows :'||to_char(l_fcn_rows));
746: --
747:
748: hr_utility.trace('p_override_fcn : '||p_override_fcn);
749: /* check if there exists atleast one DD for the given
750: payment method, Similar to Originator Id exists or not */
751:
752: IF l_max_pact_id is not null then

Line 761: hr_utility.trace('p_override_fcn is null');

757: l_new_fcn := get_actual_dd_fcn(p_org_payment_method_id,
758: p_business_group_id,
759: l_fcn_rows);
760:
761: hr_utility.trace('p_override_fcn is null');
762: RETURN l_new_fcn;
763:
764:
765: ELSE -- Override FCN is not null

Line 780: hr_utility.trace('l_new_fcn final:'||l_new_fcn);

776: l_new_fcn := p_override_fcn;
777:
778: /* Update Pay_Payroll_actions table with FCN value */
779:
780: hr_utility.trace('l_new_fcn final:'||l_new_fcn);
781: insert_new_fcn(p_org_payment_method_id,l_new_fcn,p_pact_id);
782: RETURN l_new_fcn;
783:
784: ELSE

Line 796: hr_utility.trace('l_override_fcn :'||l_override_fcn);

792: p_business_group_id, l_fcn_rows);
793: fetch override_fcn_exists into l_override_fcn;
794: close override_fcn_exists;
795:
796: hr_utility.trace('l_override_fcn :'||l_override_fcn);
797: -- dbms_output.put_line('l_override_fcn is
798: -- '||l_override_fcn);
799:
800: IF l_override_fcn = 1 THEN -- i.e does exist

Line 804: hr_utility.trace('magtape must be terminated as FCN already exists');

800: IF l_override_fcn = 1 THEN -- i.e does exist
801:
802: -- NEED TO RAISE AN ERROR THAT CAN BE RAISED IN FAST
803: -- FORMULA and XML Magtape formats
804: hr_utility.trace('magtape must be terminated as FCN already exists');
805: -- dbms_output.put_line('magtape must be terminated as
806: -- FCN already exists');
807: l_new_fcn := '1.1';
808: RETURN l_new_fcn;

Line 832: hr_utility.trace('l_new_fcn final:'||l_new_fcn);

828: IF p_override_fcn is null THEN
829:
830: l_new_fcn := '0001';
831: insert_new_fcn(p_org_payment_method_id ,l_new_fcn,p_pact_id);
832: hr_utility.trace('l_new_fcn final:'||l_new_fcn);
833:
834: RETURN l_new_fcn;
835:
836: ELSE -- Override FCN is not null NB. as it is a new

Line 858: hr_utility.trace('l_new_fcn final:'||l_new_fcn);

854: FCN value */
855: insert_new_fcn(p_org_payment_method_id,l_new_fcn,
856: p_pact_id);
857:
858: hr_utility.trace('l_new_fcn final:'||l_new_fcn);
859: RETURN l_new_fcn;
860:
861: ELSE
862:

Line 865: hr_utility.trace('l_new_fcn final:'||l_new_fcn);

861: ELSE
862:
863: insert_new_fcn(p_org_payment_method_id,p_override_fcn,
864: p_pact_id);
865: hr_utility.trace('l_new_fcn final:'||l_new_fcn);
866: RETURN p_override_fcn;
867:
868: END IF; -- Is override FCN the test fcn?
869:

Line 873: /* hr_utility.trace_off; */

869:
870: END IF; -- Is Override FCN null/not null?
871: END IF;
872:
873: /* hr_utility.trace_off; */
874: END get_dd_file_creation_number;
875:
876: FUNCTION convert_uppercase(p_input_string varchar2)
877: RETURN varchar2 IS