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

Line 120: hr_utility.set_location('Entering: ' || l_proc,5);

116: lv_itemkey VARCHAR2(100);
117: l_proc VARCHAR2(80) := gv_package || '.start_wf';
118: BEGIN
119:
120: hr_utility.set_location('Entering: ' || l_proc,5);
121:
122: lv_itemkey := to_char(p_transaction_id);
123:
124: wf_engine.createProcess(itemtype => gv_itemtype

Line 139: hr_utility.set_location('Leaving: ' || l_proc,20);

135: wf_engine.startProcess(itemtype => gv_itemtype
136: ,itemkey => lv_itemkey
137: );
138:
139: hr_utility.set_location('Leaving: ' || l_proc,20);
140: END start_wf;
141:
142:
143: PROCEDURE init_tax_notifications(itemtype in varchar2

Line 220: hr_utility.set_location('Entering: ' || l_proc,5);

216: lv_exempt_state_list VARCHAR2(10000);
217: lv_exempt_state_name VARCHAR2(50);
218: lv_exempt_state_msg fnd_new_messages.message_text%TYPE;
219: BEGIN
220: hr_utility.set_location('Entering: ' || l_proc,5);
221:
222: if funcmode = 'RUN' then
223: -- get the transaction
224:

Line 235: hr_utility.set_location(l_proc,10);

231: -- open this cursor with transaction_step_id
232: OPEN c_transaction;
233: FETCH c_transaction into r_trans_rec;
234: CLOSE c_transaction;
235: hr_utility.set_location(l_proc,10);
236:
237: wf_directory.GetUserName(p_orig_system => 'PER',
238: p_orig_system_id => r_trans_rec.person_id,
239: p_name => lv_username,

Line 281: hr_utility.set_location(l_proc,20);

277: -- build the submission details
278: if r_trans_rec.transaction_subtype = 'W4' then
279:
280: if r_trans_rec.source1 = '00-000-0000' then
281: hr_utility.set_location(l_proc,20);
282:
283: lv_status_code := r_trans_rec.audit_information1;
284: open c_fed_filing_status_code;
285: fetch c_fed_filing_status_code into lv_status;

Line 353: hr_utility.set_location(l_proc,30);

349: ,itemkey => itemkey
350: ,aname => 'STATE_LIST'
351: ,avalue => lv_state_list
352: );
353: hr_utility.set_location(l_proc,30);
354:
355: end if; -- Federal jurisdiction
356: end if; -- W4 transaction subtype
357: end if; -- funcmode = RUN

Line 359: hr_utility.set_location('Leaving: ' || l_proc, 100);

355: end if; -- Federal jurisdiction
356: end if; -- W4 transaction subtype
357: end if; -- funcmode = RUN
358:
359: hr_utility.set_location('Leaving: ' || l_proc, 100);
360:
361: end init_tax_notifications;
362:
363: procedure check_final_notifier( itemtype in varchar2,

Line 445: --hr_utility.trace_on(null,'oracle');

441: order by pta.assignment_id asc;
442: */
443:
444: begin
445: --hr_utility.trace_on(null,'oracle');
446:
447: hr_utility.set_location('Entering: ' || l_proc || ':' || funcmode, 5);
448:
449: if ( funcmode = 'RUN' ) then

Line 447: hr_utility.set_location('Entering: ' || l_proc || ':' || funcmode, 5);

443:
444: begin
445: --hr_utility.trace_on(null,'oracle');
446:
447: hr_utility.set_location('Entering: ' || l_proc || ':' || funcmode, 5);
448:
449: if ( funcmode = 'RUN' ) then
450: lv_contact_source := fnd_profile.value('HR_PAYROLL_CONTACT_SOURCE');
451:

Line 475: hr_utility.trace('Profile Value is : '|| lv_contact_source);

471: (itemtype => itemtype
472: ,itemkey => itemkey
473: ,aname => 'EMPLOYEE_PERSON_ID'
474: );
475: hr_utility.trace('Profile Value is : '|| lv_contact_source);
476: hr_utility.trace('Transaction Id is : '|| ln_transaction_id);
477: hr_utility.trace('Assignment Id is : '|| ln_current_assignment_id);
478: hr_utility.trace('Contact Person Id is : '|| ln_contact_person_id);
479: hr_utility.trace('Employee Id is : '|| ln_employee_person_id);

Line 476: hr_utility.trace('Transaction Id is : '|| ln_transaction_id);

472: ,itemkey => itemkey
473: ,aname => 'EMPLOYEE_PERSON_ID'
474: );
475: hr_utility.trace('Profile Value is : '|| lv_contact_source);
476: hr_utility.trace('Transaction Id is : '|| ln_transaction_id);
477: hr_utility.trace('Assignment Id is : '|| ln_current_assignment_id);
478: hr_utility.trace('Contact Person Id is : '|| ln_contact_person_id);
479: hr_utility.trace('Employee Id is : '|| ln_employee_person_id);
480:

Line 477: hr_utility.trace('Assignment Id is : '|| ln_current_assignment_id);

473: ,aname => 'EMPLOYEE_PERSON_ID'
474: );
475: hr_utility.trace('Profile Value is : '|| lv_contact_source);
476: hr_utility.trace('Transaction Id is : '|| ln_transaction_id);
477: hr_utility.trace('Assignment Id is : '|| ln_current_assignment_id);
478: hr_utility.trace('Contact Person Id is : '|| ln_contact_person_id);
479: hr_utility.trace('Employee Id is : '|| ln_employee_person_id);
480:
481: -- -----------------------------------------------------------------------

Line 478: hr_utility.trace('Contact Person Id is : '|| ln_contact_person_id);

474: );
475: hr_utility.trace('Profile Value is : '|| lv_contact_source);
476: hr_utility.trace('Transaction Id is : '|| ln_transaction_id);
477: hr_utility.trace('Assignment Id is : '|| ln_current_assignment_id);
478: hr_utility.trace('Contact Person Id is : '|| ln_contact_person_id);
479: hr_utility.trace('Employee Id is : '|| ln_employee_person_id);
480:
481: -- -----------------------------------------------------------------------
482: -- expose the wf control variables to the custom package

Line 479: hr_utility.trace('Employee Id is : '|| ln_employee_person_id);

475: hr_utility.trace('Profile Value is : '|| lv_contact_source);
476: hr_utility.trace('Transaction Id is : '|| ln_transaction_id);
477: hr_utility.trace('Assignment Id is : '|| ln_current_assignment_id);
478: hr_utility.trace('Contact Person Id is : '|| ln_contact_person_id);
479: hr_utility.trace('Employee Id is : '|| ln_employee_person_id);
480:
481: -- -----------------------------------------------------------------------
482: -- expose the wf control variables to the custom package
483: -- -----------------------------------------------------------------------

Line 500: hr_utility.trace('Contact User is : '|| lv_contact_user_name);

496:
497: elsif lv_contact_source = 'PAYROLL' then
498: open c_payroll_contact;
499: fetch c_payroll_contact into lv_contact_user_name;
500: hr_utility.trace('Contact User is : '|| lv_contact_user_name);
501: if c_payroll_contact%FOUND then
502: result := 'COMPLETE:N';
503: else
504: result := 'COMPLETE:Y';

Line 509: hr_utility.trace('Result is : '|| result);

505: end if;
506:
507: close c_payroll_contact;
508:
509: hr_utility.trace('Result is : '|| result);
510:
511: elsif lv_contact_source = 'GRE' then
512: open c_gre_contact;
513: fetch c_gre_contact into lv_contact_user_name;

Line 532: hr_utility.set_location('Leaving: ' || l_proc, 100);

528: null;
529:
530: end if;
531:
532: hr_utility.set_location('Leaving: ' || l_proc, 100);
533: end check_final_notifier;
534:
535:
536: PROCEDURE get_next_notifier(itemtype in varchar2

Line 611: hr_utility.set_location('Entering: ' || l_proc || ':'|| funcmode,5);

607:
608:
609: begin
610:
611: hr_utility.set_location('Entering: ' || l_proc || ':'|| funcmode,5);
612:
613: if ( funcmode = 'RUN' ) then
614:
615: lv_contact_source := fnd_profile.value('HR_PAYROLL_CONTACT_SOURCE');

Line 694: hr_utility.set_location('Leaving: ' || l_proc,100);

690: ,itemkey => itemkey
691: ,aname => 'CONTACT_USERNAME'
692: ,avalue => lv_next_contact_user);
693:
694: hr_utility.set_location('Leaving: ' || l_proc,100);
695: result := 'COMPLETE:T';
696:
697: end if;
698:

Line 759: hr_utility.set_location('Entering: ' || l_proc || ':' || funcmode,5);

755: lr_fed_rec c_fed_allowance_limit%ROWTYPE;
756: l_proc VARCHAR2(80) := gv_package || '.check_for_notification';
757:
758: BEGIN
759: hr_utility.set_location('Entering: ' || l_proc || ':' || funcmode,5);
760: if (funcmode = 'RUN') then
761: ln_transaction_id := wf_engine.GetItemAttrNumber(itemtype => itemtype
762: ,itemkey => itemkey
763: ,aname => 'TRANSACTION_ID');

Line 765: hr_utility.trace('Transaction Id is : '|| to_char(ln_transaction_id));

761: ln_transaction_id := wf_engine.GetItemAttrNumber(itemtype => itemtype
762: ,itemkey => itemkey
763: ,aname => 'TRANSACTION_ID');
764:
765: hr_utility.trace('Transaction Id is : '|| to_char(ln_transaction_id));
766:
767: -- from the transaction_id get the details
768:
769: open c_transaction;

Line 773: hr_utility.trace('lr_trans_rec.transaction_subtype is : '|| lr_trans_rec.transaction_subtype);

769: open c_transaction;
770: fetch c_transaction into lr_trans_rec;
771: close c_transaction;
772:
773: hr_utility.trace('lr_trans_rec.transaction_subtype is : '|| lr_trans_rec.transaction_subtype);
774:
775: if lr_trans_rec.transaction_subtype = 'W4' then
776:
777: -- check the W4 Notification Required setup at Business Group level

Line 788: hr_utility.trace('ORG pay_us_web_w4.get_org_context lv_notify = '||lv_notify);

784: lv_level := 'ORG';
785:
786: lv_notify := pay_us_web_w4.get_org_context(lr_trans_rec.person_id, lv_context,lv_level);
787:
788: hr_utility.trace('ORG pay_us_web_w4.get_org_context lv_notify = '||lv_notify);
789: if lv_notify = 'NOTFOUND' then
790: -- Business Group Level Context
791: lv_context := 'US_BG_REP_PREFERENCES';
792: lv_level := 'BG';

Line 794: hr_utility.trace('BG pay_us_web_w4.get_org_context lv_notify = '||lv_notify);

790: -- Business Group Level Context
791: lv_context := 'US_BG_REP_PREFERENCES';
792: lv_level := 'BG';
793: lv_notify := pay_us_web_w4.get_org_context(lr_trans_rec.person_id, lv_context,lv_level);
794: hr_utility.trace('BG pay_us_web_w4.get_org_context lv_notify = '||lv_notify);
795: end if;
796:
797:
798:

Line 799: hr_utility.trace('lr_trans_rec.source1 is : '|| lr_trans_rec.source1);

795: end if;
796:
797:
798:
799: hr_utility.trace('lr_trans_rec.source1 is : '|| lr_trans_rec.source1);
800:
801: if lv_notify = 'Y' then
802:
803: if lr_trans_rec.source1 = '00-000-0000' then

Line 813: hr_utility.trace('lr_fed_rec.fed_information1 is : '||lr_fed_rec.fed_information1);

809: open c_fed_allowance_limit;
810: fetch c_fed_allowance_limit into lr_fed_rec;
811: close c_fed_allowance_limit;
812:
813: hr_utility.trace('lr_fed_rec.fed_information1 is : '||lr_fed_rec.fed_information1);
814: if (lr_fed_rec.fed_information1 is not null) and
815: (to_number(lr_trans_rec.audit_information2) >
816: to_number(lr_fed_rec.fed_information1)) then
817:

Line 818: hr_utility.trace('Inside if for allowance checking.');

814: if (lr_fed_rec.fed_information1 is not null) and
815: (to_number(lr_trans_rec.audit_information2) >
816: to_number(lr_fed_rec.fed_information1)) then
817:
818: hr_utility.trace('Inside if for allowance checking.');
819: hr_utility.set_message(801,'PAY_US_OTF_W4_FED_OVERALLOW');
820:
821: wf_engine.SetItemAttrText(itemtype => itemtype
822: ,itemkey => itemkey

Line 819: hr_utility.set_message(801,'PAY_US_OTF_W4_FED_OVERALLOW');

815: (to_number(lr_trans_rec.audit_information2) >
816: to_number(lr_fed_rec.fed_information1)) then
817:
818: hr_utility.trace('Inside if for allowance checking.');
819: hr_utility.set_message(801,'PAY_US_OTF_W4_FED_OVERALLOW');
820:
821: wf_engine.SetItemAttrText(itemtype => itemtype
822: ,itemkey => itemkey
823: ,aname => 'EXCEPTION_REASON'

Line 824: ,avalue => hr_utility.get_message);

820:
821: wf_engine.SetItemAttrText(itemtype => itemtype
822: ,itemkey => itemkey
823: ,aname => 'EXCEPTION_REASON'
824: ,avalue => hr_utility.get_message);
825:
826: result := 'COMPLETE:Y';
827:
828: elsif lr_trans_rec.audit_information4 = 'Y' then

Line 829: hr_utility.trace('Inside elsif lr_trans_rec.audit_information4.');

825:
826: result := 'COMPLETE:Y';
827:
828: elsif lr_trans_rec.audit_information4 = 'Y' then
829: hr_utility.trace('Inside elsif lr_trans_rec.audit_information4.');
830: hr_utility.set_message(801,'PAY_US_OTF_FED_EXEMPTWARN');
831:
832: wf_engine.SetItemAttrText(itemtype => itemtype
833: ,itemkey => itemkey

Line 830: hr_utility.set_message(801,'PAY_US_OTF_FED_EXEMPTWARN');

826: result := 'COMPLETE:Y';
827:
828: elsif lr_trans_rec.audit_information4 = 'Y' then
829: hr_utility.trace('Inside elsif lr_trans_rec.audit_information4.');
830: hr_utility.set_message(801,'PAY_US_OTF_FED_EXEMPTWARN');
831:
832: wf_engine.SetItemAttrText(itemtype => itemtype
833: ,itemkey => itemkey
834: ,aname => 'EXCEPTION_REASON'

Line 835: ,avalue => hr_utility.get_message);

831:
832: wf_engine.SetItemAttrText(itemtype => itemtype
833: ,itemkey => itemkey
834: ,aname => 'EXCEPTION_REASON'
835: ,avalue => hr_utility.get_message);
836: result := 'COMPLETE:Y';
837: else
838: hr_utility.trace('failed on allowances and exempt');
839: result := 'COMPLETE:N';

Line 838: hr_utility.trace('failed on allowances and exempt');

834: ,aname => 'EXCEPTION_REASON'
835: ,avalue => hr_utility.get_message);
836: result := 'COMPLETE:Y';
837: else
838: hr_utility.trace('failed on allowances and exempt');
839: result := 'COMPLETE:N';
840: end if;
841: else /* lr_trans_rec.source1 = '00-000-0000' */
842:

Line 843: hr_utility.trace('source1 <> 00-000-0000');

839: result := 'COMPLETE:N';
840: end if;
841: else /* lr_trans_rec.source1 = '00-000-0000' */
842:
843: hr_utility.trace('source1 <> 00-000-0000');
844: result := 'COMPLETE:N';
845: end if;
846: else /*lv_notify = 'Y' */
847: hr_utility.trace('lv_notify <> Y');

Line 847: hr_utility.trace('lv_notify <> Y');

843: hr_utility.trace('source1 <> 00-000-0000');
844: result := 'COMPLETE:N';
845: end if;
846: else /*lv_notify = 'Y' */
847: hr_utility.trace('lv_notify <> Y');
848: result := 'COMPLETE:N';
849: end if;
850: else /* lr_trans_rec.transaction_subtype = 'W4' */
851: hr_utility.trace('transaction_subtype <> W4');

Line 851: hr_utility.trace('transaction_subtype <> W4');

847: hr_utility.trace('lv_notify <> Y');
848: result := 'COMPLETE:N';
849: end if;
850: else /* lr_trans_rec.transaction_subtype = 'W4' */
851: hr_utility.trace('transaction_subtype <> W4');
852: result := 'COMPLETE:N';
853: end if;
854: end if;
855: hr_utility.set_location('Leaving: ' || l_proc || ':' || result,100);

Line 855: hr_utility.set_location('Leaving: ' || l_proc || ':' || result,100);

851: hr_utility.trace('transaction_subtype <> W4');
852: result := 'COMPLETE:N';
853: end if;
854: end if;
855: hr_utility.set_location('Leaving: ' || l_proc || ':' || result,100);
856:
857: end check_for_notification;
858:
859: /* Uncomment following two lines for debug */

Line 861: -- hr_utility.trace_on(null,'pyusw4wf');

857: end check_for_notification;
858:
859: /* Uncomment following two lines for debug */
860: -- begin
861: -- hr_utility.trace_on(null,'pyusw4wf');
862:
863: END pay_us_w4_wf;