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

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

2: /* $Header: pykrpnav.pkb 120.0 2005/05/29 06:27:58 appldev noship $ */
3: g_item_type constant varchar2(10) := 'KRPAYNAV' ;
4: g_item_key varchar2(20) ;
5: g_process_name varchar2(20) ;
6: g_debug constant boolean := hr_utility.debug_enabled;
7: procedure submit_workflow (
8: -- The usual, first two parameters
9: p_errbuf out nocopy varchar2,
10: p_retcode out nocopy number,

Line 260: hr_utility.trace('Getting into submit_workflow') ;

256: --
257: begin
258: --
259: if g_debug then
260: hr_utility.trace('Getting into submit_workflow') ;
261: end if ;
262: --
263: -- initialise current time
264: l_cur_time := to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS') ;

Line 268: hr_utility.trace('Current date and time is ' || l_cur_time ) ;

264: l_cur_time := to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS') ;
265: --
266: --
267: if g_debug then
268: hr_utility.trace('Current date and time is ' || l_cur_time ) ;
269: end if ;
270: --
271: l_performer_name := '' ;
272: --

Line 280: hr_utility.trace('Initialized item type and item key') ;

276: into g_item_key
277: from dual ;
278: --
279: if g_debug then
280: hr_utility.trace('Initialized item type and item key') ;
281: end if ;
282: --
283: -- Initialize process name
284: --

Line 321: hr_utility.trace('Initialised concurrent program list. Now creating workflow...') ;

317: l_conc_prog_name_tbl(10) := cur.user_concurrent_program_name;
318: end loop ;
319: --
320: if g_debug then
321: hr_utility.trace('Initialised concurrent program list. Now creating workflow...') ;
322: end if ;
323: --
324: -- Create the workflow process
325: --

Line 333: hr_utility.trace('Created workflow, itemtype '|| g_item_type || ', itemkey ' || g_item_key || ', process ' || g_process_name) ;

329: PROCESS => g_process_name
330: ) ;
331: --
332: if g_debug then
333: hr_utility.trace('Created workflow, itemtype '|| g_item_type || ', itemkey ' || g_item_key || ', process ' || g_process_name) ;
334: end if ;
335: --
336: -- initialize the security
337: --

Line 348: hr_utility.trace('Got performer ' || l_performer_name || ' from Org Developer DF flex') ;

344: fetch csr_gre_performer into l_performer_name ;
345: close csr_gre_performer ;
346: --
347: if g_debug then
348: hr_utility.trace('Got performer ' || l_performer_name || ' from Org Developer DF flex') ;
349: end if ;
350: --
351: else -- look into Further Payroll Information DFF for the performer
352: open csr_payroll_performer ;

Line 357: hr_utility.trace('Got performer ' || l_performer_name || ' from Further Payroll Information flex') ;

353: fetch csr_payroll_performer into l_performer_name ;
354: close csr_payroll_performer ;
355: --
356: if g_debug then
357: hr_utility.trace('Got performer ' || l_performer_name || ' from Further Payroll Information flex') ;
358: end if ;
359: --
360: end if ;
361:

Line 368: hr_utility.trace('Got performer ' || l_performer_name || ' as default') ;

364: if l_performer_name is null then
365: l_performer_name := 'SYSADMIN' ;
366: --
367: if g_debug then
368: hr_utility.trace('Got performer ' || l_performer_name || ' as default') ;
369: end if ;
370: --
371: end if ;
372:

Line 399: hr_utility.trace('Will run BEE') ;

395: wf_engine.setItemAttrText(g_item_type, g_item_key, 'TO_RUN_BEE', 'N') ;
396: else
397: --
398: if g_debug then
399: hr_utility.trace('Will run BEE') ;
400: end if ;
401: --
402: l_prc_list := l_prc_list||l_conc_prog_name_tbl(1)||wf_core.newline;
403: l_cur_process_tbl(n) := l_conc_prog_name_tbl(1);

Line 415: hr_utility.trace('Will run Retro-Notifications') ;

411: wf_engine.setItemAttrText(g_item_type, g_item_key, 'TO_RUN_RETRO_NOTF', 'N') ;
412: else
413: --
414: if g_debug then
415: hr_utility.trace('Will run Retro-Notifications') ;
416: end if ;
417: --
418: for rec in csr_event_group_name loop
419: l_retro_notf_event_group_name := rec.event_group_name ;

Line 435: hr_utility.trace('Will run RetroPay') ;

431: wf_engine.setItemAttrText(g_item_type, g_item_key, 'TO_RUN_RETRO', 'N') ;
432: else
433: --
434: if g_debug then
435: hr_utility.trace('Will run RetroPay') ;
436: end if ;
437: --
438: for rec in csr_assignment_set_name(p_retro_assignment_set_id) loop
439: l_retro_assignment_set_name := rec.assignment_set_name ;

Line 476: hr_utility.trace('Will run Bonus') ;

472: --
473: if l_run_type_name like 'BON%' then
474: --
475: if g_debug then
476: hr_utility.trace('Will run Bonus') ;
477: end if ;
478: --
479: for rec in csr_bonus_start_date loop
480: l_bonus_start_date_hd := rec.a_bonus_start_date_hd ;

Line 492: hr_utility.trace('Will run Monthly Payroll') ;

488:
489: elsif l_run_type_name = 'MTH' then
490: --
491: if g_debug then
492: hr_utility.trace('Will run Monthly Payroll') ;
493: end if ;
494: --
495: wf_engine.setItemAttrText(g_item_type, g_item_key, 'TO_RUN_BONUS', 'N') ;
496: --

Line 518: hr_utility.trace('Will run PrePayments') ;

514: wf_engine.setItemAttrText(g_item_type, g_item_key, 'TO_RUN_PREPAYMENTS', 'N') ;
515: else
516: --
517: if g_debug then
518: hr_utility.trace('Will run PrePayments') ;
519: end if ;
520: --
521: for rec in csr_payment_method(p_payment_method_override) loop
522: l_payment_method_override_name := rec.org_payment_method_name ;

Line 538: hr_utility.trace('Will run Bank Transfer') ;

534: wf_engine.setItemAttrText(g_item_type, g_item_key, 'TO_RUN_BANK_TRANSFER', 'N') ;
535: else
536: --
537: if g_debug then
538: hr_utility.trace('Will run Bank Transfer') ;
539: end if ;
540: --
541: for rec in csr_payment_method(p_payment_method) loop
542: l_payment_method_name := rec.org_payment_method_name ;

Line 559: hr_utility.trace('Will run Payslip Archive') ;

555: wf_engine.setItemAttrText(g_item_type, g_item_key, 'TO_RUN_PAYSLIP_ARCHIVE', 'N') ;
556: else
557: --
558: if g_debug then
559: hr_utility.trace('Will run Payslip Archive') ;
560: end if ;
561: --
562: l_prc_list := l_prc_list||l_conc_prog_name_tbl(8)||wf_core.newline;
563: l_cur_process_tbl(n) := l_conc_prog_name_tbl(8);

Line 579: hr_utility.trace('Will run Payslip Report') ;

575: --
576: else
577: --
578: if g_debug then
579: hr_utility.trace('Will run Payslip Report') ;
580: end if ;
581: --
582: if trim(p_run_type_period) is not NULL then
583: --

Line 585: hr_utility.trace('Got Payslip Runtype Payroll Action Id = '||p_run_type_period || ' from parameter Run Type/Period');

581: --
582: if trim(p_run_type_period) is not NULL then
583: --
584: if g_debug then
585: hr_utility.trace('Got Payslip Runtype Payroll Action Id = '||p_run_type_period || ' from parameter Run Type/Period');
586: end if ;
587: --
588: for rec in csr_run_type_period_name loop
589: l_run_type_period_name_disp := rec.run_type_period_name ;

Line 593: hr_utility.trace('Run Type/Period : '||l_run_type_period_name_disp);

589: l_run_type_period_name_disp := rec.run_type_period_name ;
590: end loop ;
591: --
592: if g_debug then
593: hr_utility.trace('Run Type/Period : '||l_run_type_period_name_disp);
594: end if;
595: --
596: end if ;
597: --

Line 623: hr_utility.trace('Will run Costing') ;

619: wf_engine.setItemAttrText(g_item_type, g_item_key, 'TO_RUN_COSTING', 'N') ;
620: else
621: --
622: if g_debug then
623: hr_utility.trace('Will run Costing') ;
624: end if ;
625: --
626: l_prc_list := l_prc_list||l_conc_prog_name_tbl(10)||wf_core.newline;
627: l_cur_process_tbl(n) := l_conc_prog_name_tbl(10);

Line 677: hr_utility.trace('Starting initalization of number attributes array') ;

673: -- initialize the item attributes in workflow
674: -- first initialize the variable name and value tables
675: --
676: if g_debug then
677: hr_utility.trace('Starting initalization of number attributes array') ;
678: end if ;
679: --
680: l_num_var_name_tbl(i) := 'BATCH_ID' ;
681: l_num_var_value_tbl(i) := p_batch_id ;

Line 731: hr_utility.trace('Starting initalization of text attributes array') ;

727: --
728: -- text values
729: --
730: if g_debug then
731: hr_utility.trace('Starting initalization of text attributes array') ;
732: end if ;
733: --
734: i := 1 ;
735: l_text_var_name_tbl(i) := 'DATE_TIME' ;

Line 959: hr_utility.trace('Finished initialising attributes array') ;

955: l_text_var_value_tbl(i) := l_sort_order2_disp ;
956: i := i + 1 ;
957: --
958: if g_debug then
959: hr_utility.trace('Finished initialising attributes array') ;
960: end if ;
961: --
962: -- now initialize, using the wf_engine API
963: --

Line 967: hr_utility.trace('Actually initalized number attributes by calling wf_engine.setItemAttrNumberArray') ;

963: --
964: wf_engine.setItemAttrNumberArray(g_item_type, g_item_key, l_num_var_name_tbl, l_num_var_value_tbl);
965: --
966: if g_debug then
967: hr_utility.trace('Actually initalized number attributes by calling wf_engine.setItemAttrNumberArray') ;
968: end if ;
969: --
970: wf_engine.setItemAttrTextArray(g_item_type, g_item_key, l_text_var_name_tbl, l_text_var_value_tbl);
971: --

Line 973: hr_utility.trace('Actually initalized of text attributes by calling wf_engine.setItemAttrTextArray') ;

969: --
970: wf_engine.setItemAttrTextArray(g_item_type, g_item_key, l_text_var_name_tbl, l_text_var_value_tbl);
971: --
972: if g_debug then
973: hr_utility.trace('Actually initalized of text attributes by calling wf_engine.setItemAttrTextArray') ;
974: end if ;
975: --
976: if g_debug then
977: hr_utility.trace('Starting workflow') ;

Line 977: hr_utility.trace('Starting workflow') ;

973: hr_utility.trace('Actually initalized of text attributes by calling wf_engine.setItemAttrTextArray') ;
974: end if ;
975: --
976: if g_debug then
977: hr_utility.trace('Starting workflow') ;
978: end if ;
979: --
980: -- Start the workflow
981: --

Line 988: hr_utility.trace('Workflow started. Quiting submit_workflow') ;

984: ITEMKEY => g_item_key
985: ) ;
986: --
987: if g_debug then
988: hr_utility.trace('Workflow started. Quiting submit_workflow') ;
989: end if ;
990: --
991: p_retcode := 0;
992: --

Line 996: hr_utility.trace(sqlerrm);

992: --
993: exception
994: when others then
995: if g_debug then
996: hr_utility.trace(sqlerrm);
997: p_retcode := 2;
998: end if ;
999: end submit_workflow ;
1000: ----------------------------------------------------------------------------------------------------------------------------