153:
154:
155: if lv_business_group_name is not null
156: and l_bg_flag <> 'Y'then
157: X_segment1 := 'Business Group :'||lv_business_group_name||l_space||wf_core.newline;
158: l_bg_flag := 'Y';
159: end if;
160:
161: if asg_info_rec.PAYROLL_NAME is not null
159: end if;
160:
161: if asg_info_rec.PAYROLL_NAME is not null
162: and l_payroll_flag <> 'Y'then
163: X_segment2 := 'Payroll :'||asg_info_rec.PAYROLL_NAME||l_space||wf_core.newline;
164: l_payroll_flag := 'Y';
165: end if;
166:
167: if asg_info_rec.ASG_STATUS = 'C' then
173: end if;
174:
175: END LOOP ;
176:
177: X_segment3 := 'Total Assignment Successfully Processed :'||to_char(ln_complete)||l_space||wf_core.newline;
178: X_segment4 := 'Total Assignment Errored :'||to_char(ln_error)||l_space||wf_core.newline;
179: X_segment5 := 'Total Assignment Un-Processed :'||to_char(ln_unprocessed)||l_space||wf_core.newline;
180:
181: document := '
'||X_segment3||'
'||X_segment4||'
'||X_segment5||'
174:
175: END LOOP ;
176:
177: X_segment3 := 'Total Assignment Successfully Processed :'||to_char(ln_complete)||l_space||wf_core.newline;
178: X_segment4 := 'Total Assignment Errored :'||to_char(ln_error)||l_space||wf_core.newline;
179: X_segment5 := 'Total Assignment Un-Processed :'||to_char(ln_unprocessed)||l_space||wf_core.newline;
180:
181: document := '
'||X_segment3||'
'||X_segment4||'
'||X_segment5||'
175: END LOOP ;
176:
177: X_segment3 := 'Total Assignment Successfully Processed :'||to_char(ln_complete)||l_space||wf_core.newline;
178: X_segment4 := 'Total Assignment Errored :'||to_char(ln_error)||l_space||wf_core.newline;
179: X_segment5 := 'Total Assignment Un-Processed :'||to_char(ln_unprocessed)||l_space||wf_core.newline;
180:
181: document := '
'||X_segment3||'
'||X_segment4||'
'||X_segment5||'
179: X_segment5 := 'Total Assignment Un-Processed :'||to_char(ln_unprocessed)||l_space||wf_core.newline;
180:
181: document := '
'||X_segment3||'
'||X_segment4||'
'||X_segment5||'
220: end if;
221: return;
222: exception
223: when others then
224: WF_CORE.CONTEXT ('PAY_WORKFLOW_API_PKG', 'set_attr_value', itemtype,
225: itemkey, to_char(actid), funcmode);
226: raise;
227: end set_attr_value;
228:
251: end if;
252: return;
253: exception
254: when others then
255: WF_CORE.CONTEXT ('PAY_WORKFLOW_API_PKG', 'get_attr_value', itemtype,
256: itemkey, to_char(actid), funcmode);
257: raise;
258: end get_attr_value;
259: */
The Function GET_VALUE retrives the value of the request id for the given attribute name Request Id :'||l_cur_req_id||wf_core.newline ||'
303: hr_utility.trace('Attr Name '||lv_attr_name);
304:
305: -- l_cur_req_id := get_value(lv_itemtype,lv_itemkey,lv_attr_name);
306:
307: X_segment1 := '
The Function GET_VALUE retrives the value of the request id for the given attribute name Request Id :'||l_cur_req_id||wf_core.newline ||'
304:
305: -- l_cur_req_id := get_value(lv_itemtype,lv_itemkey,lv_attr_name);
306:
307: X_segment1 := '
The Function GET_VALUE retrives the value of the request id for the given attribute name Request Id :'||l_cur_req_id||wf_core.newline ||'
468: end if;
469:
470: exception
471: when others then
472: WF_CORE.CONTEXT ('PAY_US_WORKFLOW_API_PKG', 'GetRetroInformation', itemtype, itemkey, to_char(actid), funcmode);
473: raise;
474: end GetRetroInformation;
475:
476:
611:
612:
613: exception
614: when others then
615: WF_CORE.CONTEXT ('PAY_US_WORKFLOW_API_PKG', 'post_notification_set_attr', itemtype, itemkey, to_char(actid), funcmode);
616: raise;
617: end post_notification_set_attr;
618:
619: PROCEDURE ExecuteConcProgram
764:
765:
766: EXCEPTION
767: WHEN OTHERS THEN NULL;
768: WF_CORE.Context('PAY_US_WORKFLOW_API_PKG', 'ExecuteConcProgram',
769: p_itemtype, p_itemkey, p_actid, p_funcmode);
770: RAISE;
771:
772:
843:
844:
845: EXCEPTION
846: WHEN OTHERS THEN NULL;
847: WF_CORE.Context('PAY_US_WORKFLOW_API_PKG', 'CheckProcessInputs',
848: p_itemtype, p_itemkey, p_actid, p_funcmode);
849: RAISE;
850:
851:
923:
924:
925: EXCEPTION
926: WHEN OTHERS THEN NULL;
927: WF_CORE.Context('PAY_US_WORKFLOW_API_PKG', 'IsResponseRequired',
928: p_itemtype, p_itemkey, p_actid, p_funcmode);
929: RAISE;
930:
931: