APPS.PAY_KR_WF_SUBMIT_PROGRAM_PKG dependencies on HR_UTILITY

Line 4: g_debug constant boolean := hr_utility.debug_enabled ;

1: package body pay_kr_wf_submit_program_pkg AS
2: /* $Header: pykrwfsp.pkb 120.2 2006/02/17 01:14:25 mmark noship $ */
3:
4: g_debug constant boolean := hr_utility.debug_enabled ;
5: procedure submit_program (
6: itemtype in varchar2, -- the name of the item type
7: itemkey in varchar2, -- the unique item key
8: actid in number, -- the activity id

Line 68: hr_utility.trace('Into submit_program.') ;

64: --
65: begin
66: --
67: if g_debug then
68: hr_utility.trace('Into submit_program.') ;
69: end if ;
70: --
71: if wf_engine.getActivityAttrText(itemtype, itemkey, actid, 'PROGRAM') = 'PAYKRSOE'
72: and wf_engine.getItemAttrText(itemtype, itemkey, 'TO_RUN_PREPAYMENTS') = 'Y'

Line 77: hr_utility.trace('Getting payroll action id from PrePayments to run Payslip (Korea)');

73: and wf_engine.getItemAttrText(itemtype, itemkey, 'RUNTYPEPERIODID') is null
74: then
75: --
76: if g_debug then
77: hr_utility.trace('Getting payroll action id from PrePayments to run Payslip (Korea)');
78: end if ;
79: --
80: -- Get payroll action id from PrePayments to run Payslip (Korea)
81: --

Line 89: hr_utility.trace('Got PrePayments request id = ' || l_prepayments_req_id );

85: l_payroll_id := wf_engine.getItemAttrNumber(itemtype, itemkey, 'PAYROLL_ID') ;
86: -- End of 4859652
87: --
88: if g_debug then
89: hr_utility.trace('Got PrePayments request id = ' || l_prepayments_req_id );
90: end if ;
91: --
92: for rec in csr_payroll_action_id(
93: p_prepayments_req_id => l_prepayments_req_id,

Line 99: hr_utility.trace('Set run type period id in workflow = payroll action id = ' || to_char(rec.payroll_action_id) ) ;

95: p_payroll_id => l_payroll_id -- Bug 4859652
96: ) loop
97: --
98: if g_debug then
99: hr_utility.trace('Set run type period id in workflow = payroll action id = ' || to_char(rec.payroll_action_id) ) ;
100: end if ;
101: --
102: -- set the payroll action id as the run type period in workflow
103: --

Line 114: hr_utility.trace('Now calling fnd_wf_standard.executeconcprogram for program ' || wf_engine.getActivityAttrText(itemtype, itemkey, actid, 'PROGRAM') ) ;

110: --
111: end if ;
112: --
113: if g_debug then
114: hr_utility.trace('Now calling fnd_wf_standard.executeconcprogram for program ' || wf_engine.getActivityAttrText(itemtype, itemkey, actid, 'PROGRAM') ) ;
115: end if ;
116: --
117: fnd_wf_standard.executeconcprogram(itemtype, itemkey, actid, funcmode, resultout) ;
118: --

Line 120: hr_utility.trace('Called fnd_wf_standard.executeconcprogram. Quiting submit_program.') ;

116: --
117: fnd_wf_standard.executeconcprogram(itemtype, itemkey, actid, funcmode, resultout) ;
118: --
119: if g_debug then
120: hr_utility.trace('Called fnd_wf_standard.executeconcprogram. Quiting submit_program.') ;
121: end if ;
122: --
123: exception
124: when others then

Line 126: hr_utility.trace(sqlerrm);

122: --
123: exception
124: when others then
125: if g_debug then
126: hr_utility.trace(sqlerrm);
127: end if ;
128: resultout := 'ERROR:';
129: end submit_program ;
130: ----------------------------------------------------------------------------------------------------------------------------------------

Line 150: hr_utility.trace('In check_run_flags') ;

146: l_per_security_id number ;
147:
148: begin
149: if g_debug then
150: hr_utility.trace('In check_run_flags') ;
151: end if ;
152:
153: if (p_funcmode = 'RUN') then
154: wf_standard.compare(

Line 230: hr_utility.trace('Got Monthly Payroll request id = ' || ln_req_id );

226: if wf_engine.getActivityAttrText(p_itemtype, p_itemkey, p_actid, 'PROGRAM') = 'PAYKRMTH' then -- we're running monthly
227: ln_req_id := wf_engine.getItemAttrNumber(p_itemtype, p_itemkey, 'MONTHLY_PAYROLL_REQ_ID_NUM');
228: --
229: if g_debug then
230: hr_utility.trace('Got Monthly Payroll request id = ' || ln_req_id );
231: end if ;
232: --
233: lb_to_get_counts := true ; -- will need to get assignment count information
234: elsif wf_engine.getActivityAttrText(p_itemtype, p_itemkey, p_actid, 'PROGRAM') = 'PAYKRBON' then -- we're running bonus

Line 238: hr_utility.trace('Got Bonus Payroll request id = ' || ln_req_id );

234: elsif wf_engine.getActivityAttrText(p_itemtype, p_itemkey, p_actid, 'PROGRAM') = 'PAYKRBON' then -- we're running bonus
235: ln_req_id := wf_engine.getItemAttrNumber(p_itemtype, p_itemkey, 'BONUS_PAYROLL_REQ_ID_NUM');
236: --
237: if g_debug then
238: hr_utility.trace('Got Bonus Payroll request id = ' || ln_req_id );
239: end if ;
240: --
241: lb_to_get_counts := true ; -- will need to get assignment count information
242:

Line 272: hr_utility.trace(sqlerrm);

268: --
269: exception
270: when others then
271: if g_debug then
272: hr_utility.trace(sqlerrm);
273: end if ;
274: p_result := 'ERROR:';
275: end get_assignment_count ;
276: