159:
160:
161: if lv_business_group_name is not null
162: and l_bg_flag <> 'Y'then
163: X_segment1 := 'Business Group :'||lv_business_group_name||l_space||wf_core.newline;
164: l_bg_flag := 'Y';
165: end if;
166:
167: if asg_info_rec.PAYROLL_NAME is not null
165: end if;
166:
167: if asg_info_rec.PAYROLL_NAME is not null
168: and l_payroll_flag <> 'Y'then
169: X_segment2 := 'Payroll :'||asg_info_rec.PAYROLL_NAME||l_space||wf_core.newline;
170: l_payroll_flag := 'Y';
171: end if;
172:
173: if asg_info_rec.ASG_STATUS = 'C' then
179: end if;
180:
181: END LOOP ;
182:
183: X_segment3 := 'Total Assignment Successfully Processed :'||to_char(ln_complete)||l_space||wf_core.newline;
184: X_segment4 := 'Total Assignment Errored :'||to_char(ln_error)||l_space||wf_core.newline;
185: X_segment5 := 'Total Assignment Un-Processed :'||to_char(ln_unprocessed)||l_space||wf_core.newline;
186:
187: document := '
'||X_segment3||'
'||X_segment4||'
'||X_segment5||'
180:
181: END LOOP ;
182:
183: X_segment3 := 'Total Assignment Successfully Processed :'||to_char(ln_complete)||l_space||wf_core.newline;
184: X_segment4 := 'Total Assignment Errored :'||to_char(ln_error)||l_space||wf_core.newline;
185: X_segment5 := 'Total Assignment Un-Processed :'||to_char(ln_unprocessed)||l_space||wf_core.newline;
186:
187: document := '
'||X_segment3||'
'||X_segment4||'
'||X_segment5||'
181: END LOOP ;
182:
183: X_segment3 := 'Total Assignment Successfully Processed :'||to_char(ln_complete)||l_space||wf_core.newline;
184: X_segment4 := 'Total Assignment Errored :'||to_char(ln_error)||l_space||wf_core.newline;
185: X_segment5 := 'Total Assignment Un-Processed :'||to_char(ln_unprocessed)||l_space||wf_core.newline;
186:
187: document := '
'||X_segment3||'
'||X_segment4||'
'||X_segment5||'
185: X_segment5 := 'Total Assignment Un-Processed :'||to_char(ln_unprocessed)||l_space||wf_core.newline;
186:
187: document := '
'||X_segment3||'
'||X_segment4||'
'||X_segment5||'
226: end if;
227: return;
228: exception
229: when others then
230: WF_CORE.CONTEXT ('PAY_WORKFLOW_API_PKG', 'set_attr_value', itemtype,
231: itemkey, to_char(actid), funcmode);
232: raise;
233: end set_attr_value;
234:
257: end if;
258: return;
259: exception
260: when others then
261: WF_CORE.CONTEXT ('PAY_WORKFLOW_API_PKG', 'get_attr_value', itemtype,
262: itemkey, to_char(actid), funcmode);
263: raise;
264: end get_attr_value;
265: */
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 ||'
309: hr_utility.trace('Attr Name '||lv_attr_name);
310:
311: -- l_cur_req_id := get_value(lv_itemtype,lv_itemkey,lv_attr_name);
312:
313: 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 ||'
310:
311: -- l_cur_req_id := get_value(lv_itemtype,lv_itemkey,lv_attr_name);
312:
313: 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 ||'
474: end if;
475:
476: exception
477: when others then
478: WF_CORE.CONTEXT ('PAY_US_WORKFLOW_API_PKG', 'GetRetroInformation', itemtype, itemkey, to_char(actid), funcmode);
479: raise;
480: end GetRetroInformation;
481:
482: --bug 12704242
554: end if;
555:
556: exception
557: when others then
558: WF_CORE.CONTEXT ('PAY_US_WORKFLOW_API_PKG', 'GetRetroInformation', itemtype, itemkey, to_char(actid), funcmode);
559: raise;
560: end GetRetroEnhancedInfo;
561:
562: procedure post_notification_set_attr(itemtype in varchar2,
696:
697:
698: exception
699: when others then
700: WF_CORE.CONTEXT ('PAY_US_WORKFLOW_API_PKG', 'post_notification_set_attr', itemtype, itemkey, to_char(actid), funcmode);
701: raise;
702: end post_notification_set_attr;
703:
704: PROCEDURE ExecuteConcProgram
853:
854:
855: EXCEPTION
856: WHEN OTHERS THEN NULL;
857: WF_CORE.Context('PAY_US_WORKFLOW_API_PKG', 'ExecuteConcProgram',
858: p_itemtype, p_itemkey, p_actid, p_funcmode);
859: RAISE;
860:
861:
933:
934:
935: EXCEPTION
936: WHEN OTHERS THEN NULL;
937: WF_CORE.Context('PAY_US_WORKFLOW_API_PKG', 'CheckProcessInputs',
938: p_itemtype, p_itemkey, p_actid, p_funcmode);
939: RAISE;
940:
941:
1014:
1015:
1016: EXCEPTION
1017: WHEN OTHERS THEN NULL;
1018: WF_CORE.Context('PAY_US_WORKFLOW_API_PKG', 'IsResponseRequired',
1019: p_itemtype, p_itemkey, p_actid, p_funcmode);
1020: RAISE;
1021:
1022: