DBA Data[Home] [Help]

APPS.PAY_US_TAX_WF dependencies on HR_UTILITY

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

80: lv_itemkey VARCHAR2(100);
81: l_proc VARCHAR2(80) := gv_package || '.start_wf';
82: BEGIN
83:
84: hr_utility.set_location('Entering: ' || l_proc,5);
85:
86: lv_itemkey := to_char(p_transaction_id);
87:
88: wf_engine.createProcess(itemtype => gv_itemtype

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

99: wf_engine.startProcess(itemtype => gv_itemtype
100: ,itemkey => lv_itemkey
101: );
102:
103: hr_utility.set_location('Leaving: ' || l_proc,20);
104: END start_wf;
105:
106:
107: PROCEDURE init_tax_notifications(itemtype in varchar2

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

157: lv_disp_name VARCHAR2(80);
158: l_proc VARCHAR2(80) := gv_package || '.init_tax_notifications';
159:
160: BEGIN
161: hr_utility.set_location('Entering: ' || l_proc,5);
162:
163: if funcmode = 'RUN' then
164: -- get the transaction
165: ln_transaction_id := wf_engine.GetItemAttrNumber(

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

170:
171: OPEN c_transaction;
172: FETCH c_transaction into r_trans_rec;
173: CLOSE c_transaction;
174: hr_utility.set_location(l_proc,10);
175:
176: wf_directory.GetUserName( p_orig_system => 'PER',
177: p_orig_system_id => r_trans_rec.person_id,
178: p_name => lv_username,

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

216: -- build the submission details
217: if r_trans_rec.transaction_subtype = 'W4' then
218:
219: if r_trans_rec.source1 = '00-000-0000' then
220: hr_utility.set_location(l_proc,20);
221: lv_status_code := r_trans_rec.audit_information1;
222: open c_fed_filing_status_code;
223: fetch c_fed_filing_status_code into lv_status;
224: if c_fed_filing_status_code%NOTFOUND then

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

270: ,itemkey => itemkey
271: ,aname => 'STATE_LIST'
272: ,avalue => lv_state_list
273: );
274: hr_utility.set_location(l_proc,30);
275:
276: end if; -- Federal jurisdiction
277: end if; -- W4 transaction subtype
278: end if; -- funcmode = RUN

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

276: end if; -- Federal jurisdiction
277: end if; -- W4 transaction subtype
278: end if; -- funcmode = RUN
279:
280: hr_utility.set_location('Leaving: ' || l_proc, 100);
281:
282: end init_tax_notifications;
283:
284: procedure check_final_notifier( itemtype in varchar2,

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

339:
340:
341: begin
342:
343: hr_utility.set_location('Entering: ' || l_proc || ':' || funcmode, 5);
344:
345: if ( funcmode = 'RUN' ) then
346: lv_contact_source := fnd_profile.value('HR_PAYROLL_CONTACT_SOURCE');
347:

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

416: null;
417:
418: end if;
419:
420: hr_utility.set_location('Leaving: ' || l_proc, 100);
421: end check_final_notifier;
422:
423:
424: PROCEDURE get_next_notifier(itemtype in varchar2

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

489: order by pta.assignment_id asc;
490:
491: begin
492:
493: hr_utility.set_location('Entering: ' || l_proc || ':'|| funcmode,5);
494: if ( funcmode = 'RUN' ) then
495: lv_contact_source := fnd_profile.value('HR_PAYROLL_CONTACT_SOURCE');
496:
497: ln_transaction_id := wf_engine.GetItemAttrNumber

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

574: ,itemkey => itemkey
575: ,aname => 'CONTACT_USERNAME'
576: ,avalue => lv_next_contact_user);
577:
578: hr_utility.set_location('Leaving: ' || l_proc,100);
579: result := 'COMPLETE:T';
580:
581: end if;
582:

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

630: lr_fed_rec c_fed_allowance_limit%ROWTYPE;
631: l_proc VARCHAR2(80) := gv_package || '.check_for_notification';
632:
633: BEGIN
634: hr_utility.set_location('Entering: ' || l_proc || ':' || funcmode,5);
635: if (funcmode = 'RUN') then
636: ln_transaction_id := wf_engine.GetItemAttrNumber(itemtype => itemtype
637: ,itemkey => itemkey
638: ,aname => 'TRANSACTION_ID');

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

654:
655: if (lr_fed_rec.fed_information1 is not null) and
656: (to_number(lr_trans_rec.audit_information2) >
657: to_number(lr_fed_rec.fed_information1)) then
658: hr_utility.set_message(801,'PAY_US_OTF_W4_FED_OVERALLOW');
659:
660: wf_engine.SetItemAttrText(itemtype => itemtype
661: ,itemkey => itemkey
662: ,aname => 'EXCEPTION_REASON'

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

659:
660: wf_engine.SetItemAttrText(itemtype => itemtype
661: ,itemkey => itemkey
662: ,aname => 'EXCEPTION_REASON'
663: ,avalue => hr_utility.get_message);
664: result := 'COMPLETE:Y';
665:
666: elsif lr_trans_rec.audit_information4 = 'Y' then
667: hr_utility.set_message(801,'PAY_US_OTF_FED_EXEMPTWARN');

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

663: ,avalue => hr_utility.get_message);
664: result := 'COMPLETE:Y';
665:
666: elsif lr_trans_rec.audit_information4 = 'Y' then
667: hr_utility.set_message(801,'PAY_US_OTF_FED_EXEMPTWARN');
668:
669: wf_engine.SetItemAttrText(itemtype => itemtype
670: ,itemkey => itemkey
671: ,aname => 'EXCEPTION_REASON'

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

668:
669: wf_engine.SetItemAttrText(itemtype => itemtype
670: ,itemkey => itemkey
671: ,aname => 'EXCEPTION_REASON'
672: ,avalue => hr_utility.get_message);
673: result := 'COMPLETE:Y';
674: else
675: result := 'COMPLETE:N';
676: end if;

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

680: else
681: result := 'COMPLETE:N';
682: end if;
683: end if;
684: hr_utility.set_location('Leaving: ' || l_proc || ':' || result,100);
685:
686: end check_for_notification;
687:
688: END pay_us_tax_wf;