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

Line 133: hr_utility.trace('B4 ASG Info');

129: ln_complete := 0;
130: ln_error := 0;
131: ln_unprocessed := 0;
132:
133: hr_utility.trace('B4 ASG Info');
134: hr_utility.trace('Document Id '||document_id);
135:
136: ln_request_id := substr(document_id,1,instr(document_id,':') -1 );
137: ln_business_group_id := substr(document_id,instr(document_id,':',1,1)+1 ,

Line 134: hr_utility.trace('Document Id '||document_id);

130: ln_error := 0;
131: ln_unprocessed := 0;
132:
133: hr_utility.trace('B4 ASG Info');
134: hr_utility.trace('Document Id '||document_id);
135:
136: ln_request_id := substr(document_id,1,instr(document_id,':') -1 );
137: ln_business_group_id := substr(document_id,instr(document_id,':',1,1)+1 ,
138: instr(document_id,':',1,2) -instr(document_id,':',1,1)-1 );

Line 143: hr_utility.trace('ln_request_id = '||ln_request_id);

139: ln_payroll_id := substr(document_id,instr(document_id,':',1,2)+1 ,
140: instr(document_id,':',1,3) -instr(document_id,':',1,2)-1 );
141: ld_payroll_date_paid := substr(document_id,instr(document_id,':',1,3)+1 );
142:
143: hr_utility.trace('ln_request_id = '||ln_request_id);
144: hr_utility.trace('ln_business_group_id = '||ln_business_group_id);
145: hr_utility.trace('ln_payroll_id = '||ln_payroll_id);
146: hr_utility.trace('ld_payroll_date_paid = '||ld_payroll_date_paid);
147:

Line 144: hr_utility.trace('ln_business_group_id = '||ln_business_group_id);

140: instr(document_id,':',1,3) -instr(document_id,':',1,2)-1 );
141: ld_payroll_date_paid := substr(document_id,instr(document_id,':',1,3)+1 );
142:
143: hr_utility.trace('ln_request_id = '||ln_request_id);
144: hr_utility.trace('ln_business_group_id = '||ln_business_group_id);
145: hr_utility.trace('ln_payroll_id = '||ln_payroll_id);
146: hr_utility.trace('ld_payroll_date_paid = '||ld_payroll_date_paid);
147:
148: begin

Line 145: hr_utility.trace('ln_payroll_id = '||ln_payroll_id);

141: ld_payroll_date_paid := substr(document_id,instr(document_id,':',1,3)+1 );
142:
143: hr_utility.trace('ln_request_id = '||ln_request_id);
144: hr_utility.trace('ln_business_group_id = '||ln_business_group_id);
145: hr_utility.trace('ln_payroll_id = '||ln_payroll_id);
146: hr_utility.trace('ld_payroll_date_paid = '||ld_payroll_date_paid);
147:
148: begin
149: select pbg.name into lv_business_group_name

Line 146: hr_utility.trace('ld_payroll_date_paid = '||ld_payroll_date_paid);

142:
143: hr_utility.trace('ln_request_id = '||ln_request_id);
144: hr_utility.trace('ln_business_group_id = '||ln_business_group_id);
145: hr_utility.trace('ln_payroll_id = '||ln_payroll_id);
146: hr_utility.trace('ld_payroll_date_paid = '||ld_payroll_date_paid);
147:
148: begin
149: select pbg.name into lv_business_group_name
150: from per_business_groups pbg

Line 153: hr_utility.trace('ln_business_group_id = '||ln_business_group_id);

149: select pbg.name into lv_business_group_name
150: from per_business_groups pbg
151: where pbg.business_group_id = ln_business_group_id;
152:
153: hr_utility.trace('ln_business_group_id = '||ln_business_group_id);
154: exception when others then
155: null;
156: end;
157:

Line 191: hr_utility.trace('Document '||document);

187: document := '

'||X_segment3||'
'||X_segment4||'
'||X_segment5||'

';
188:
189: document := document || l_space||wf_core.newline;
190:
191: hr_utility.trace('Document '||document);
192:
193:
194: document_type := 'text/html';
195: Exception When others then

Line 196: hr_utility.trace('In Exception ');

192:
193:
194: document_type := 'text/html';
195: Exception When others then
196: hr_utility.trace('In Exception ');
197:
198: End Get_Assignment_Info;
199:
200: --

Line 218: hr_utility.trace('lv_aname = '|| lv_aname);

214: resultout := wf_engine.eng_null;
215: else
216:
217: lv_aname := PAY_WORKFLOW_API_PKG.set_value(itemtype,itemkey,actid);
218: hr_utility.trace('lv_aname = '|| lv_aname);
219: -- put this activity in wait/notified state
220: if lv_aname is not null then
221: resultout := 'COMPLETE'||':'||wf_engine.eng_null;
222: else

Line 297: hr_utility.trace('B4 MSG Details ');

293: BEGIN
294: l_payroll_flag := 'N';
295: l_bg_flag := 'N';
296: l_space := ' ';
297: hr_utility.trace('B4 MSG Details ');
298: hr_utility.trace('Document Id '||document_id);
299:
300: args := document_id;
301: -- args has format itemtype:itemkey:attr_name

Line 298: hr_utility.trace('Document Id '||document_id);

294: l_payroll_flag := 'N';
295: l_bg_flag := 'N';
296: l_space := ' ';
297: hr_utility.trace('B4 MSG Details ');
298: hr_utility.trace('Document Id '||document_id);
299:
300: args := document_id;
301: -- args has format itemtype:itemkey:attr_name
302: firstcolon := instr(args,':');

Line 305: hr_utility.trace('Item Type '||lv_itemtype);

301: -- args has format itemtype:itemkey:attr_name
302: firstcolon := instr(args,':');
303: nextcolon := instr(args,':',firstcolon+1);
304: lv_itemtype := substr(args,1, firstcolon-1);
305: hr_utility.trace('Item Type '||lv_itemtype);
306: lv_itemkey := substr(args,firstcolon+1,nextcolon -(firstcolon-1));
307: hr_utility.trace('Item Key '||lv_itemkey);
308: lv_attr_name := substr(args,nextcolon+1);
309: hr_utility.trace('Attr Name '||lv_attr_name);

Line 307: hr_utility.trace('Item Key '||lv_itemkey);

303: nextcolon := instr(args,':',firstcolon+1);
304: lv_itemtype := substr(args,1, firstcolon-1);
305: hr_utility.trace('Item Type '||lv_itemtype);
306: lv_itemkey := substr(args,firstcolon+1,nextcolon -(firstcolon-1));
307: hr_utility.trace('Item Key '||lv_itemkey);
308: lv_attr_name := substr(args,nextcolon+1);
309: hr_utility.trace('Attr Name '||lv_attr_name);
310:
311: -- l_cur_req_id := get_value(lv_itemtype,lv_itemkey,lv_attr_name);

Line 309: hr_utility.trace('Attr Name '||lv_attr_name);

305: hr_utility.trace('Item Type '||lv_itemtype);
306: lv_itemkey := substr(args,firstcolon+1,nextcolon -(firstcolon-1));
307: hr_utility.trace('Item Key '||lv_itemkey);
308: lv_attr_name := substr(args,nextcolon+1);
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 ||'

Line 316: hr_utility.trace('Document '||document);

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 ||'

';
314: document := document || X_segment1||wf_core.newline;
315: document_type := 'text/html';
316: hr_utility.trace('Document '||document);
317: Exception When others then
318: hr_utility.trace('In Exception of Get message_details');
319:
320: End get_message_details;

Line 318: hr_utility.trace('In Exception of Get message_details');

314: document := document || X_segment1||wf_core.newline;
315: document_type := 'text/html';
316: hr_utility.trace('Document '||document);
317: Exception When others then
318: hr_utility.trace('In Exception of Get message_details');
319:
320: End get_message_details;
321:
322: /*

Line 341: hr_utility.trace('In Exception of get_value');

337:
338: return attr_value;
339:
340: Exception When others then
341: hr_utility.trace('In Exception of get_value');
342:
343: End get_value;
344: */
345:

Line 368: hr_utility.trace('aname = '|| lv_attr_name);

364: lv_attr_value := wf_engine.GetActivityAttrText(wf_item_type,wf_item_key,wf_actid, 'ATTR_VALUE');
365: -- aname(1) := lv_attr_name;
366: -- avalue(1) := lv_attr_value;
367:
368: hr_utility.trace('aname = '|| lv_attr_name);
369: hr_utility.trace('avalue = '|| lv_attr_value);
370: if aname is not null then
371: --WF_Engine.AddItemAttr(wf_item_type, wf_item_key, aname, avalue);
372: WF_Engine.AddItemAttr(wf_item_type, wf_item_key, lv_attr_name, lv_attr_value);

Line 369: hr_utility.trace('avalue = '|| lv_attr_value);

365: -- aname(1) := lv_attr_name;
366: -- avalue(1) := lv_attr_value;
367:
368: hr_utility.trace('aname = '|| lv_attr_name);
369: hr_utility.trace('avalue = '|| lv_attr_value);
370: if aname is not null then
371: --WF_Engine.AddItemAttr(wf_item_type, wf_item_key, aname, avalue);
372: WF_Engine.AddItemAttr(wf_item_type, wf_item_key, lv_attr_name, lv_attr_value);
373: --return aname;

Line 379: hr_utility.trace('In Exception of set_value');

375: else
376: return null;
377: end if;
378: Exception When others then
379: hr_utility.trace('In Exception of set_value');
380:
381: End set_value;
382: */
383:

Line 407: hr_utility.trace(' In GetRetroInformation ');

403:
404: lv_result := 'SKIP';
405: ignore_notfound := FALSE;
406:
407: hr_utility.trace(' In GetRetroInformation ');
408: if ( funcmode = 'RUN' ) then
409: hr_utility.trace('Function Mode = '||funcmode);
410: -- get attr value
411: --

Line 409: hr_utility.trace('Function Mode = '||funcmode);

405: ignore_notfound := FALSE;
406:
407: hr_utility.trace(' In GetRetroInformation ');
408: if ( funcmode = 'RUN' ) then
409: hr_utility.trace('Function Mode = '||funcmode);
410: -- get attr value
411: --
412: hr_utility.trace('itemtype = '||itemtype);
413: hr_utility.trace('itemkey = '||itemkey);

Line 412: hr_utility.trace('itemtype = '||itemtype);

408: if ( funcmode = 'RUN' ) then
409: hr_utility.trace('Function Mode = '||funcmode);
410: -- get attr value
411: --
412: hr_utility.trace('itemtype = '||itemtype);
413: hr_utility.trace('itemkey = '||itemkey);
414: hr_utility.trace('actid = '||to_char(actid));
415:
416: aname := 'RETRO_ASSIGNMENT_SET_NAME';

Line 413: hr_utility.trace('itemkey = '||itemkey);

409: hr_utility.trace('Function Mode = '||funcmode);
410: -- get attr value
411: --
412: hr_utility.trace('itemtype = '||itemtype);
413: hr_utility.trace('itemkey = '||itemkey);
414: hr_utility.trace('actid = '||to_char(actid));
415:
416: aname := 'RETRO_ASSIGNMENT_SET_NAME';
417: lv_retro_asg_set := Wf_Engine.GetItemAttrText(

Line 414: hr_utility.trace('actid = '||to_char(actid));

410: -- get attr value
411: --
412: hr_utility.trace('itemtype = '||itemtype);
413: hr_utility.trace('itemkey = '||itemkey);
414: hr_utility.trace('actid = '||to_char(actid));
415:
416: aname := 'RETRO_ASSIGNMENT_SET_NAME';
417: lv_retro_asg_set := Wf_Engine.GetItemAttrText(
418: itemtype ,

Line 432: hr_utility.trace(' BG Id = '|| to_char(X_bg_id));

428: aname,
429: ignore_notfound);
430:
431:
432: hr_utility.trace(' BG Id = '|| to_char(X_bg_id));
433: hr_utility.trace(' Retro Asg Set = '|| lv_retro_asg_set);
434:
435: begin
436: select assignment_set_id

Line 433: hr_utility.trace(' Retro Asg Set = '|| lv_retro_asg_set);

429: ignore_notfound);
430:
431:
432: hr_utility.trace(' BG Id = '|| to_char(X_bg_id));
433: hr_utility.trace(' Retro Asg Set = '|| lv_retro_asg_set);
434:
435: begin
436: select assignment_set_id
437: into ln_retro_asg_set_id

Line 442: hr_utility.trace(' Retro Asg Set ID = '|| to_char(ln_retro_asg_set_id));

438: from hr_assignment_sets
439: where business_group_id = X_bg_id
440: and assignment_set_name like lv_retro_asg_set||'%';
441:
442: hr_utility.trace(' Retro Asg Set ID = '|| to_char(ln_retro_asg_set_id));
443: exception when others then
444: result := 'SKIP';
445: hr_utility.trace('Skiping Retro Pay By Element as Assignment Set Not Found');
446: end;

Line 445: hr_utility.trace('Skiping Retro Pay By Element as Assignment Set Not Found');

441:
442: hr_utility.trace(' Retro Asg Set ID = '|| to_char(ln_retro_asg_set_id));
443: exception when others then
444: result := 'SKIP';
445: hr_utility.trace('Skiping Retro Pay By Element as Assignment Set Not Found');
446: end;
447:
448: if ln_retro_asg_set_id is not null then
449:

Line 456: hr_utility.trace('result = '||result);

452: itemkey,
453: 'RETRO_ASSIGNMENT_SET_ID',
454: ln_retro_asg_set_id);
455: result := 'RUN';
456: hr_utility.trace('result = '||result);
457: else
458: result := 'SKIP';
459:
460: hr_utility.trace('result = '||result);

Line 460: hr_utility.trace('result = '||result);

456: hr_utility.trace('result = '||result);
457: else
458: result := 'SKIP';
459:
460: hr_utility.trace('result = '||result);
461: end if;
462:
463: resultout := 'COMPLETE:'||result;
464: hr_utility.trace(' Resultout = '|| resultout);

Line 464: hr_utility.trace(' Resultout = '|| resultout);

460: hr_utility.trace('result = '||result);
461: end if;
462:
463: resultout := 'COMPLETE:'||result;
464: hr_utility.trace(' Resultout = '|| resultout);
465: return;
466: elsif ( funcmode = 'CANCEL' ) then
467: --
468: null;

Line 471: hr_utility.trace('In Skip Resultout = '|| resultout);

467: --
468: null;
469: result := 'SKIP';
470: resultout := 'COMPLETE:'||result;
471: hr_utility.trace('In Skip Resultout = '|| resultout);
472: return;
473:
474: end if;
475:

Line 502: hr_utility.trace(' In GetRetroEnhancedInfo ');

498: begin
499:
500: lv_result := 'SKIP';
501: ignore_notfound := FALSE;
502: hr_utility.trace(' In GetRetroEnhancedInfo ');
503: if ( funcmode = 'RUN' ) then
504: hr_utility.trace('Function Mode = '||funcmode);
505: -- get attr value
506: --

Line 504: hr_utility.trace('Function Mode = '||funcmode);

500: lv_result := 'SKIP';
501: ignore_notfound := FALSE;
502: hr_utility.trace(' In GetRetroEnhancedInfo ');
503: if ( funcmode = 'RUN' ) then
504: hr_utility.trace('Function Mode = '||funcmode);
505: -- get attr value
506: --
507: hr_utility.trace('itemtype = '||itemtype);
508: hr_utility.trace('itemkey = '||itemkey);

Line 507: hr_utility.trace('itemtype = '||itemtype);

503: if ( funcmode = 'RUN' ) then
504: hr_utility.trace('Function Mode = '||funcmode);
505: -- get attr value
506: --
507: hr_utility.trace('itemtype = '||itemtype);
508: hr_utility.trace('itemkey = '||itemkey);
509: hr_utility.trace('actid = '||to_char(actid));
510:
511:

Line 508: hr_utility.trace('itemkey = '||itemkey);

504: hr_utility.trace('Function Mode = '||funcmode);
505: -- get attr value
506: --
507: hr_utility.trace('itemtype = '||itemtype);
508: hr_utility.trace('itemkey = '||itemkey);
509: hr_utility.trace('actid = '||to_char(actid));
510:
511:
512: aname := 'PAYROLL_ID';

Line 509: hr_utility.trace('actid = '||to_char(actid));

505: -- get attr value
506: --
507: hr_utility.trace('itemtype = '||itemtype);
508: hr_utility.trace('itemkey = '||itemkey);
509: hr_utility.trace('actid = '||to_char(actid));
510:
511:
512: aname := 'PAYROLL_ID';
513:

Line 521: hr_utility.trace(' Business Id = '|| to_char(X_bg_id));

517: aname,
518: ignore_notfound));
519:
520:
521: hr_utility.trace(' Business Id = '|| to_char(X_bg_id));
522:
523: begin
524: select distinct('Y') into l_is_retro from
525: pay_assignment_actions paa,

Line 536: hr_utility.trace('Skiping Retro Pay Enhanced: '||sqlerrm);

532: and pra.retro_assignment_action_id is null;
533:
534: exception when others then
535: result := 'SKIP';
536: hr_utility.trace('Skiping Retro Pay Enhanced: '||sqlerrm);
537: end;
538:
539: if l_is_retro = 'Y' then
540: result := 'RUN';

Line 544: hr_utility.trace(' Resultout = '|| resultout);

540: result := 'RUN';
541: else result := 'SKIP';
542: end if;
543: resultout := 'COMPLETE:'||result;
544: hr_utility.trace(' Resultout = '|| resultout);
545: return;
546: elsif ( funcmode = 'CANCEL' ) then
547: --
548: null;

Line 551: hr_utility.trace('In Skip Resultout = '|| resultout);

547: --
548: null;
549: result := 'SKIP';
550: resultout := 'COMPLETE:'||result;
551: hr_utility.trace('In Skip Resultout = '|| resultout);
552: return;
553:
554: end if;
555:

Line 584: hr_utility.trace('1. Function Mode = '||funcmode);

580:
581: lv_result := 'SKIP';
582: ignore_notfound := FALSE;
583:
584: hr_utility.trace('1. Function Mode = '||funcmode);
585: if ( funcmode = 'RUN' ) then
586: ln_get_retro_asgset_id := Wf_Engine.GetItemAttrNumber(
587: itemtype,
588: itemkey,

Line 591: hr_utility.trace('Function Mode = '||funcmode);

587: itemtype,
588: itemkey,
589: 'RETRO_ASSIGNMENT_SET_ID');
590:
591: hr_utility.trace('Function Mode = '||funcmode);
592: hr_utility.trace('1. ln_get_retro_asgset_id = '||to_char(ln_get_retro_asgset_id));
593:
594: if ln_get_retro_asgset_id is not null then
595: resultout := 'COMPLETE:RUN';

Line 592: hr_utility.trace('1. ln_get_retro_asgset_id = '||to_char(ln_get_retro_asgset_id));

588: itemkey,
589: 'RETRO_ASSIGNMENT_SET_ID');
590:
591: hr_utility.trace('Function Mode = '||funcmode);
592: hr_utility.trace('1. ln_get_retro_asgset_id = '||to_char(ln_get_retro_asgset_id));
593:
594: if ln_get_retro_asgset_id is not null then
595: resultout := 'COMPLETE:RUN';
596: hr_utility.trace(' Resultout = '|| resultout);

Line 596: hr_utility.trace(' Resultout = '|| resultout);

592: hr_utility.trace('1. ln_get_retro_asgset_id = '||to_char(ln_get_retro_asgset_id));
593:
594: if ln_get_retro_asgset_id is not null then
595: resultout := 'COMPLETE:RUN';
596: hr_utility.trace(' Resultout = '|| resultout);
597: else
598: resultout := 'COMPLETE:SKIP';
599: hr_utility.trace(' Resultout = '|| resultout);
600: end if;

Line 599: hr_utility.trace(' Resultout = '|| resultout);

595: resultout := 'COMPLETE:RUN';
596: hr_utility.trace(' Resultout = '|| resultout);
597: else
598: resultout := 'COMPLETE:SKIP';
599: hr_utility.trace(' Resultout = '|| resultout);
600: end if;
601:
602: return;
603: end if;

Line 607: hr_utility.trace('Function Mode = '||funcmode);

603: end if;
604:
605:
606: if ( funcmode = 'RESPOND' ) then
607: hr_utility.trace('Function Mode = '||funcmode);
608: -- get attr value
609: --
610: hr_utility.trace('itemtype = '||itemtype);
611: hr_utility.trace('itemkey = '||itemkey);

Line 610: hr_utility.trace('itemtype = '||itemtype);

606: if ( funcmode = 'RESPOND' ) then
607: hr_utility.trace('Function Mode = '||funcmode);
608: -- get attr value
609: --
610: hr_utility.trace('itemtype = '||itemtype);
611: hr_utility.trace('itemkey = '||itemkey);
612: hr_utility.trace('actid = '||to_char(actid));
613: l_notification_id2:= wf_engine.context_nid;
614: hr_utility.trace('2. l_notification_id = '||to_char(l_notification_id2));

Line 611: hr_utility.trace('itemkey = '||itemkey);

607: hr_utility.trace('Function Mode = '||funcmode);
608: -- get attr value
609: --
610: hr_utility.trace('itemtype = '||itemtype);
611: hr_utility.trace('itemkey = '||itemkey);
612: hr_utility.trace('actid = '||to_char(actid));
613: l_notification_id2:= wf_engine.context_nid;
614: hr_utility.trace('2. l_notification_id = '||to_char(l_notification_id2));
615:

Line 612: hr_utility.trace('actid = '||to_char(actid));

608: -- get attr value
609: --
610: hr_utility.trace('itemtype = '||itemtype);
611: hr_utility.trace('itemkey = '||itemkey);
612: hr_utility.trace('actid = '||to_char(actid));
613: l_notification_id2:= wf_engine.context_nid;
614: hr_utility.trace('2. l_notification_id = '||to_char(l_notification_id2));
615:
616: if (l_notification_id is not null ) then

Line 614: hr_utility.trace('2. l_notification_id = '||to_char(l_notification_id2));

610: hr_utility.trace('itemtype = '||itemtype);
611: hr_utility.trace('itemkey = '||itemkey);
612: hr_utility.trace('actid = '||to_char(actid));
613: l_notification_id2:= wf_engine.context_nid;
614: hr_utility.trace('2. l_notification_id = '||to_char(l_notification_id2));
615:
616: if (l_notification_id is not null ) then
617: lv_result := WF_NOTIFICATION.GetAttrText( l_notification_id, 'RESULT');
618: hr_utility.trace('1. lv_result = '||lv_result);

Line 618: hr_utility.trace('1. lv_result = '||lv_result);

614: hr_utility.trace('2. l_notification_id = '||to_char(l_notification_id2));
615:
616: if (l_notification_id is not null ) then
617: lv_result := WF_NOTIFICATION.GetAttrText( l_notification_id, 'RESULT');
618: hr_utility.trace('1. lv_result = '||lv_result);
619: elsif ( l_notification_id2 is not null) then
620: lv_result := WF_NOTIFICATION.GetAttrText( l_notification_id2, 'RESULT');
621: hr_utility.trace('2.lv_result = '||lv_result);
622: end if;

Line 621: hr_utility.trace('2.lv_result = '||lv_result);

617: lv_result := WF_NOTIFICATION.GetAttrText( l_notification_id, 'RESULT');
618: hr_utility.trace('1. lv_result = '||lv_result);
619: elsif ( l_notification_id2 is not null) then
620: lv_result := WF_NOTIFICATION.GetAttrText( l_notification_id2, 'RESULT');
621: hr_utility.trace('2.lv_result = '||lv_result);
622: end if;
623:
624: if (lv_result <> 'SKIP') then
625: aname := 'RETRO_ASSIGNMENT_SET_NAME';

Line 641: hr_utility.trace(' BG Id = '|| to_char(X_bg_id));

637: aname,
638: ignore_notfound);
639:
640:
641: hr_utility.trace(' BG Id = '|| to_char(X_bg_id));
642: hr_utility.trace(' Retro Asg Set = '|| lv_retro_asg_set);
643:
644: begin
645: select assignment_set_id

Line 642: hr_utility.trace(' Retro Asg Set = '|| lv_retro_asg_set);

638: ignore_notfound);
639:
640:
641: hr_utility.trace(' BG Id = '|| to_char(X_bg_id));
642: hr_utility.trace(' Retro Asg Set = '|| lv_retro_asg_set);
643:
644: begin
645: select assignment_set_id
646: into ln_retro_asg_set_id

Line 651: hr_utility.trace(' Retro Asg Set ID = '|| to_char(ln_retro_asg_set_id));

647: from hr_assignment_sets
648: where business_group_id = X_bg_id
649: and assignment_set_name like lv_retro_asg_set||'%';
650:
651: hr_utility.trace(' Retro Asg Set ID = '|| to_char(ln_retro_asg_set_id));
652: exception when others then
653: result := 'SKIP';
654: hr_utility.trace('Skiping Retro Pay By Element as Assignment Set Not Found');
655: end;

Line 654: hr_utility.trace('Skiping Retro Pay By Element as Assignment Set Not Found');

650:
651: hr_utility.trace(' Retro Asg Set ID = '|| to_char(ln_retro_asg_set_id));
652: exception when others then
653: result := 'SKIP';
654: hr_utility.trace('Skiping Retro Pay By Element as Assignment Set Not Found');
655: end;
656:
657: if ln_retro_asg_set_id is not null then
658:

Line 665: hr_utility.trace('result = '||result);

661: itemkey,
662: 'RETRO_ASSIGNMENT_SET_ID',
663: ln_retro_asg_set_id);
664: result := 'RUN';
665: hr_utility.trace('result = '||result);
666: else
667: result := 'SKIP';
668:
669: hr_utility.trace('result = '||result);

Line 669: hr_utility.trace('result = '||result);

665: hr_utility.trace('result = '||result);
666: else
667: result := 'SKIP';
668:
669: hr_utility.trace('result = '||result);
670: end if;
671:
672: resultout := 'COMPLETE:'||result;
673: hr_utility.trace(' Resultout = '|| resultout);

Line 673: hr_utility.trace(' Resultout = '|| resultout);

669: hr_utility.trace('result = '||result);
670: end if;
671:
672: resultout := 'COMPLETE:'||result;
673: hr_utility.trace(' Resultout = '|| resultout);
674: return;
675: else
676: result := 'SKIP';
677: resultout := 'COMPLETE:'||result;

Line 678: hr_utility.trace('In Skip Resultout = '|| resultout);

674: return;
675: else
676: result := 'SKIP';
677: resultout := 'COMPLETE:'||result;
678: hr_utility.trace('In Skip Resultout = '|| resultout);
679: return;
680:
681: end if;
682: -- result := 'SKIP';

Line 684: -- hr_utility.trace('In Skip Resultout = '|| resultout);

680:
681: end if;
682: -- result := 'SKIP';
683: -- resultout := 'COMPLETE:'||result;
684: -- hr_utility.trace('In Skip Resultout = '|| resultout);
685: -- return;
686:
687: end if;
688:

Line 750: hr_utility.trace('In set context of ExecuteConcProgram');

746: -- get Item Attributes for user_id, responsibility_id and application_id
747: -- this assumes that they were set as item attribute, probably through
748: -- definition.
749:
750: hr_utility.trace('In set context of ExecuteConcProgram');
751: l_user_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'USER_ID');
752: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');
753: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
754: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');

Line 764: hr_utility.trace('l_user_id = '|| l_user_id);

760: l_resp_appl_id:= crec.responsibility_application_id;
761: l_resp_id:= crec.responsibility_id;
762:
763: */
764: hr_utility.trace('l_user_id = '|| l_user_id);
765: hr_utility.trace('l_resp_appl_id: = '|| l_resp_appl_id);
766: hr_utility.trace('l_resp_id = '|| l_resp_id);
767: hr_utility.trace('l_org_id = '|| l_org_id);
768: hr_utility.trace('l_security_group_id = '|| l_security_group_id);

Line 765: hr_utility.trace('l_resp_appl_id: = '|| l_resp_appl_id);

761: l_resp_id:= crec.responsibility_id;
762:
763: */
764: hr_utility.trace('l_user_id = '|| l_user_id);
765: hr_utility.trace('l_resp_appl_id: = '|| l_resp_appl_id);
766: hr_utility.trace('l_resp_id = '|| l_resp_id);
767: hr_utility.trace('l_org_id = '|| l_org_id);
768: hr_utility.trace('l_security_group_id = '|| l_security_group_id);
769: hr_utility.trace('l_per_security_id = '|| l_per_security_id);

Line 766: hr_utility.trace('l_resp_id = '|| l_resp_id);

762:
763: */
764: hr_utility.trace('l_user_id = '|| l_user_id);
765: hr_utility.trace('l_resp_appl_id: = '|| l_resp_appl_id);
766: hr_utility.trace('l_resp_id = '|| l_resp_id);
767: hr_utility.trace('l_org_id = '|| l_org_id);
768: hr_utility.trace('l_security_group_id = '|| l_security_group_id);
769: hr_utility.trace('l_per_security_id = '|| l_per_security_id);
770:

Line 767: hr_utility.trace('l_org_id = '|| l_org_id);

763: */
764: hr_utility.trace('l_user_id = '|| l_user_id);
765: hr_utility.trace('l_resp_appl_id: = '|| l_resp_appl_id);
766: hr_utility.trace('l_resp_id = '|| l_resp_id);
767: hr_utility.trace('l_org_id = '|| l_org_id);
768: hr_utility.trace('l_security_group_id = '|| l_security_group_id);
769: hr_utility.trace('l_per_security_id = '|| l_per_security_id);
770:
771: -- Set the database session context which also sets the org

Line 768: hr_utility.trace('l_security_group_id = '|| l_security_group_id);

764: hr_utility.trace('l_user_id = '|| l_user_id);
765: hr_utility.trace('l_resp_appl_id: = '|| l_resp_appl_id);
766: hr_utility.trace('l_resp_id = '|| l_resp_id);
767: hr_utility.trace('l_org_id = '|| l_org_id);
768: hr_utility.trace('l_security_group_id = '|| l_security_group_id);
769: hr_utility.trace('l_per_security_id = '|| l_per_security_id);
770:
771: -- Set the database session context which also sets the org
772: --Bug 9211154 - Pass l_security_group_id instead of l_per_security_id

Line 769: hr_utility.trace('l_per_security_id = '|| l_per_security_id);

765: hr_utility.trace('l_resp_appl_id: = '|| l_resp_appl_id);
766: hr_utility.trace('l_resp_id = '|| l_resp_id);
767: hr_utility.trace('l_org_id = '|| l_org_id);
768: hr_utility.trace('l_security_group_id = '|| l_security_group_id);
769: hr_utility.trace('l_per_security_id = '|| l_per_security_id);
770:
771: -- Set the database session context which also sets the org
772: --Bug 9211154 - Pass l_security_group_id instead of l_per_security_id
773: FND_GLOBAL.Apps_Initialize(l_user_id, l_resp_id, l_resp_appl_id,l_security_group_id);

Line 776: hr_utility.trace('In funcmode RUN of ExecuteConcProgram');

772: --Bug 9211154 - Pass l_security_group_id instead of l_per_security_id
773: FND_GLOBAL.Apps_Initialize(l_user_id, l_resp_id, l_resp_appl_id,l_security_group_id);
774: --FND_GLOBAL.Apps_Initialize(l_user_id, l_resp_id, l_resp_appl_id,l_per_security_id);
775:
776: hr_utility.trace('In funcmode RUN of ExecuteConcProgram');
777: -- HR_SIGNON.Initialize_HR_Security;
778: hr_utility.trace('A4 HR_SIGNON.Initialize_HR_Security of ExecuteConcProgram');
779: fnd_wf_standard.ExecuteConcProgram(p_itemtype ,
780: p_itemkey ,

Line 778: hr_utility.trace('A4 HR_SIGNON.Initialize_HR_Security of ExecuteConcProgram');

774: --FND_GLOBAL.Apps_Initialize(l_user_id, l_resp_id, l_resp_appl_id,l_per_security_id);
775:
776: hr_utility.trace('In funcmode RUN of ExecuteConcProgram');
777: -- HR_SIGNON.Initialize_HR_Security;
778: hr_utility.trace('A4 HR_SIGNON.Initialize_HR_Security of ExecuteConcProgram');
779: fnd_wf_standard.ExecuteConcProgram(p_itemtype ,
780: p_itemkey ,
781: p_actid ,
782: p_funcmode ,

Line 789: hr_utility.trace('In Test context of ExecuteConcProgram');

785: p_result := l_resultout;
786: return;
787:
788: ELSIF (p_funcmode = 'TEST_CTX') THEN
789: hr_utility.trace('In Test context of ExecuteConcProgram');
790: -- Code that compares current session context
791: -- with the work item context required to execute
792: -- the workflow safely
793:

Line 823: hr_utility.trace('In set context of ExecuteConcProgram');

819: -- get Item Attributes for user_id, responsibility_id and application_id
820: -- this assumes that they were set as item attribute, probably through
821: -- definition.
822:
823: hr_utility.trace('In set context of ExecuteConcProgram');
824: l_user_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'USER_ID');
825: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');
826: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
827: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');

Line 882: hr_utility.trace('In CheckProcessInputs');

878: l_per_security_id NUMBER;
879:
880: BEGIN
881:
882: hr_utility.trace('In CheckProcessInputs');
883:
884: IF (p_funcmode = 'RUN') THEN
885:
886: -- Code that determines Start Process

Line 891: hr_utility.trace('In set context of ExecuteConcProgram');

887: -- p_result := 'COMPLETE:RUN';
888: -- get Item Attributes for user_id, responsibility_id and application_id
889: -- this assumes that they were set as item attribute, probably through
890: -- definition.
891: hr_utility.trace('In set context of ExecuteConcProgram');
892: l_user_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'USER_ID');
893: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');
894: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
895: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');

Line 900: hr_utility.trace('l_user_id = '|| l_user_id);

896:
897: l_security_group_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'SECURITY_GROUP_ID');
898: l_per_security_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'PER_SECURITY_PROFILE_ID');
899:
900: hr_utility.trace('l_user_id = '|| l_user_id);
901: hr_utility.trace('l_resp_appl_id: = '|| l_resp_appl_id);
902: hr_utility.trace('l_resp_id = '|| l_resp_id);
903: hr_utility.trace('l_org_id = '|| l_org_id);
904: hr_utility.trace('l_security_group_id = '|| l_security_group_id);

Line 901: hr_utility.trace('l_resp_appl_id: = '|| l_resp_appl_id);

897: l_security_group_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'SECURITY_GROUP_ID');
898: l_per_security_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'PER_SECURITY_PROFILE_ID');
899:
900: hr_utility.trace('l_user_id = '|| l_user_id);
901: hr_utility.trace('l_resp_appl_id: = '|| l_resp_appl_id);
902: hr_utility.trace('l_resp_id = '|| l_resp_id);
903: hr_utility.trace('l_org_id = '|| l_org_id);
904: hr_utility.trace('l_security_group_id = '|| l_security_group_id);
905: hr_utility.trace('l_per_security_id = '|| l_per_security_id);

Line 902: hr_utility.trace('l_resp_id = '|| l_resp_id);

898: l_per_security_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'PER_SECURITY_PROFILE_ID');
899:
900: hr_utility.trace('l_user_id = '|| l_user_id);
901: hr_utility.trace('l_resp_appl_id: = '|| l_resp_appl_id);
902: hr_utility.trace('l_resp_id = '|| l_resp_id);
903: hr_utility.trace('l_org_id = '|| l_org_id);
904: hr_utility.trace('l_security_group_id = '|| l_security_group_id);
905: hr_utility.trace('l_per_security_id = '|| l_per_security_id);
906:

Line 903: hr_utility.trace('l_org_id = '|| l_org_id);

899:
900: hr_utility.trace('l_user_id = '|| l_user_id);
901: hr_utility.trace('l_resp_appl_id: = '|| l_resp_appl_id);
902: hr_utility.trace('l_resp_id = '|| l_resp_id);
903: hr_utility.trace('l_org_id = '|| l_org_id);
904: hr_utility.trace('l_security_group_id = '|| l_security_group_id);
905: hr_utility.trace('l_per_security_id = '|| l_per_security_id);
906:
907: -- Set the database session context which also sets the org

Line 904: hr_utility.trace('l_security_group_id = '|| l_security_group_id);

900: hr_utility.trace('l_user_id = '|| l_user_id);
901: hr_utility.trace('l_resp_appl_id: = '|| l_resp_appl_id);
902: hr_utility.trace('l_resp_id = '|| l_resp_id);
903: hr_utility.trace('l_org_id = '|| l_org_id);
904: hr_utility.trace('l_security_group_id = '|| l_security_group_id);
905: hr_utility.trace('l_per_security_id = '|| l_per_security_id);
906:
907: -- Set the database session context which also sets the org
908: --Bug 9211154 - Pass l_security_group_id instead of l_per_security_id

Line 905: hr_utility.trace('l_per_security_id = '|| l_per_security_id);

901: hr_utility.trace('l_resp_appl_id: = '|| l_resp_appl_id);
902: hr_utility.trace('l_resp_id = '|| l_resp_id);
903: hr_utility.trace('l_org_id = '|| l_org_id);
904: hr_utility.trace('l_security_group_id = '|| l_security_group_id);
905: hr_utility.trace('l_per_security_id = '|| l_per_security_id);
906:
907: -- Set the database session context which also sets the org
908: --Bug 9211154 - Pass l_security_group_id instead of l_per_security_id
909: FND_GLOBAL.Apps_Initialize(l_user_id, l_resp_id, l_resp_appl_id,l_security_group_id);

Line 963: hr_utility.trace('In IsResponseRequired');

959: l_per_security_id NUMBER;
960:
961: BEGIN
962:
963: hr_utility.trace('In IsResponseRequired');
964:
965: IF (p_funcmode = 'RUN') THEN
966:
967: -- Code that determines Start Process

Line 972: hr_utility.trace('In set context of ExecuteConcProgram');

968: -- p_result := 'COMPLETE:RUN';
969: -- get Item Attributes for user_id, responsibility_id and application_id
970: -- this assumes that they were set as item attribute, probably through
971: -- definition.
972: hr_utility.trace('In set context of ExecuteConcProgram');
973: l_user_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'USER_ID');
974: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');
975: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
976: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');

Line 981: hr_utility.trace('l_user_id = '|| l_user_id);

977:
978: l_security_group_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'SECURITY_GROUP_ID');
979: l_per_security_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'PER_SECURITY_PROFILE_ID');
980:
981: hr_utility.trace('l_user_id = '|| l_user_id);
982: hr_utility.trace('l_resp_appl_id: = '|| l_resp_appl_id);
983: hr_utility.trace('l_resp_id = '|| l_resp_id);
984: hr_utility.trace('l_org_id = '|| l_org_id);
985: hr_utility.trace('l_security_group_id = '|| l_security_group_id);

Line 982: hr_utility.trace('l_resp_appl_id: = '|| l_resp_appl_id);

978: l_security_group_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'SECURITY_GROUP_ID');
979: l_per_security_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'PER_SECURITY_PROFILE_ID');
980:
981: hr_utility.trace('l_user_id = '|| l_user_id);
982: hr_utility.trace('l_resp_appl_id: = '|| l_resp_appl_id);
983: hr_utility.trace('l_resp_id = '|| l_resp_id);
984: hr_utility.trace('l_org_id = '|| l_org_id);
985: hr_utility.trace('l_security_group_id = '|| l_security_group_id);
986: hr_utility.trace('l_per_security_id = '|| l_per_security_id);

Line 983: hr_utility.trace('l_resp_id = '|| l_resp_id);

979: l_per_security_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'PER_SECURITY_PROFILE_ID');
980:
981: hr_utility.trace('l_user_id = '|| l_user_id);
982: hr_utility.trace('l_resp_appl_id: = '|| l_resp_appl_id);
983: hr_utility.trace('l_resp_id = '|| l_resp_id);
984: hr_utility.trace('l_org_id = '|| l_org_id);
985: hr_utility.trace('l_security_group_id = '|| l_security_group_id);
986: hr_utility.trace('l_per_security_id = '|| l_per_security_id);
987:

Line 984: hr_utility.trace('l_org_id = '|| l_org_id);

980:
981: hr_utility.trace('l_user_id = '|| l_user_id);
982: hr_utility.trace('l_resp_appl_id: = '|| l_resp_appl_id);
983: hr_utility.trace('l_resp_id = '|| l_resp_id);
984: hr_utility.trace('l_org_id = '|| l_org_id);
985: hr_utility.trace('l_security_group_id = '|| l_security_group_id);
986: hr_utility.trace('l_per_security_id = '|| l_per_security_id);
987:
988: -- Set the database session context which also sets the org

Line 985: hr_utility.trace('l_security_group_id = '|| l_security_group_id);

981: hr_utility.trace('l_user_id = '|| l_user_id);
982: hr_utility.trace('l_resp_appl_id: = '|| l_resp_appl_id);
983: hr_utility.trace('l_resp_id = '|| l_resp_id);
984: hr_utility.trace('l_org_id = '|| l_org_id);
985: hr_utility.trace('l_security_group_id = '|| l_security_group_id);
986: hr_utility.trace('l_per_security_id = '|| l_per_security_id);
987:
988: -- Set the database session context which also sets the org
989: --Bug 9211154 - Pass l_security_group_id instead of l_per_security_id

Line 986: hr_utility.trace('l_per_security_id = '|| l_per_security_id);

982: hr_utility.trace('l_resp_appl_id: = '|| l_resp_appl_id);
983: hr_utility.trace('l_resp_id = '|| l_resp_id);
984: hr_utility.trace('l_org_id = '|| l_org_id);
985: hr_utility.trace('l_security_group_id = '|| l_security_group_id);
986: hr_utility.trace('l_per_security_id = '|| l_per_security_id);
987:
988: -- Set the database session context which also sets the org
989: --Bug 9211154 - Pass l_security_group_id instead of l_per_security_id
990: FND_GLOBAL.Apps_Initialize(l_user_id, l_resp_id, l_resp_appl_id,l_security_group_id);

Line 1026: -- hr_utility.trace_on(null,'PYWF');

1022:
1023: END IsResponseRequired;
1024:
1025: --begin
1026: -- hr_utility.trace_on(null,'PYWF');
1027:
1028: END PAY_US_WORKFLOW_API_PKG;