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.PQP_GB_PSI_WPS_HISTORY dependencies on PQP_GB_PSI_FUNCTIONS

Line 272: debug('now calling PQP_GB_PSI_FUNCTIONS.init_st_end_date_glob ',30);

268: g_assignment_id := p_assignment_id;
269: debug('g_assignment_id: '||g_assignment_id,20);
270:
271:
272: debug('now calling PQP_GB_PSI_FUNCTIONS.init_st_end_date_glob ',30);
273: PQP_GB_PSI_FUNCTIONS.init_st_end_date_glob();
274:
275: g_is_terminated := 'N';
276: debug_exit(l_proc_name);

Line 273: PQP_GB_PSI_FUNCTIONS.init_st_end_date_glob();

269: debug('g_assignment_id: '||g_assignment_id,20);
270:
271:
272: debug('now calling PQP_GB_PSI_FUNCTIONS.init_st_end_date_glob ',30);
273: PQP_GB_PSI_FUNCTIONS.init_st_end_date_glob();
274:
275: g_is_terminated := 'N';
276: debug_exit(l_proc_name);
277: EXCEPTION

Line 386: g_debug := PQP_GB_PSI_FUNCTIONS.check_debug(p_business_group_id);

382: clear_cache;
383:
384:
385: -- for trace switching ON/OFF
386: g_debug := PQP_GB_PSI_FUNCTIONS.check_debug(p_business_group_id);
387: -- setting shared globals
388: -- 1) paypoint
389: -- 2) cutover date
390: -- 3) extract def id

Line 391: PQP_GB_PSI_FUNCTIONS.set_shared_globals

387: -- setting shared globals
388: -- 1) paypoint
389: -- 2) cutover date
390: -- 3) extract def id
391: PQP_GB_PSI_FUNCTIONS.set_shared_globals
392: (p_business_group_id => p_business_group_id
393: ,p_paypoint => g_paypoint -- OUT
394: ,p_cutover_date => g_cutover_date -- OUT
395: ,p_ext_dfn_id => g_ext_dfn_id -- OUT

Line 409: PQP_GB_PSI_FUNCTIONS.raise_extract_exceptions(p_extract_type => 'S');

405: g_business_group_id := p_business_group_id;
406:
407: debug('now raise setup exceptions ...',15);
408: -- raise setup errors and warnings
409: PQP_GB_PSI_FUNCTIONS.raise_extract_exceptions(p_extract_type => 'S');
410:
411: END IF; -- shared and basic_data globals have been set
412: g_current_run := 'CUTOVER';
413: debug('g_current_run :'||g_current_run);

Line 418: PQP_GB_PSI_FUNCTIONS.chk_penserver_basic_criteria

414:
415:
416: -- calling the basic criteria for this person assignment
417: l_return :=
418: PQP_GB_PSI_FUNCTIONS.chk_penserver_basic_criteria
419: (p_business_group_id => p_business_group_id
420: ,p_effective_date => p_effective_date
421: ,p_assignment_id => p_assignment_id
422: ,p_person_dtl => g_person_dtl

Line 432: l_return :=PQP_GB_PSI_FUNCTIONS.check_employee_pension_scheme

428: IF l_return = 'Y'
429: THEN
430: debug('calling function to check the pension scheme of the person',20);
431: --calling function to check the pension scheme of the person
432: l_return :=PQP_GB_PSI_FUNCTIONS.check_employee_pension_scheme
433: (p_business_group_id => p_business_group_id
434: ,p_effective_date => p_effective_date
435: ,p_assignment_id => p_assignment_id
436: ,p_psi_pension_scheme => 'CLASSIC'

Line 443: l_return :=PQP_GB_PSI_FUNCTIONS.check_employee_pension_scheme

439: debug('l_return: '||l_return,25);
440:
441: --****This commented loop is for 'Classic Plus' type of element.****--
442: /* IF l_return = 'N' THEN
443: l_return :=PQP_GB_PSI_FUNCTIONS.check_employee_pension_scheme
444: (p_business_group_id => p_business_group_id
445: ,p_effective_date => p_effective_date
446: ,p_assignment_id => p_assignment_id
447: ,p_psi_pension_scheme => 'CLASSPLUS'

Line 559: g_debug := PQP_GB_PSI_FUNCTIONS.check_debug(p_business_group_id);

555: -- clear the cached globals
556: clear_cache;
557:
558: -- for trace switching ON/OFF
559: g_debug := PQP_GB_PSI_FUNCTIONS.check_debug(p_business_group_id);
560:
561: -- setting shared globals
562: -- 1) paypoint
563: -- 2) cutover date

Line 565: PQP_GB_PSI_FUNCTIONS.set_shared_globals

561: -- setting shared globals
562: -- 1) paypoint
563: -- 2) cutover date
564: -- 3) extract def id
565: PQP_GB_PSI_FUNCTIONS.set_shared_globals
566: (p_business_group_id => p_business_group_id
567: ,p_paypoint => g_paypoint -- OUT
568: ,p_cutover_date => g_cutover_date -- OUT
569: ,p_ext_dfn_id => g_ext_dfn_id -- OUT

Line 584: PQP_GB_PSI_FUNCTIONS.raise_extract_exceptions(p_extract_type => 'S');

580: g_business_group_id := p_business_group_id;
581:
582: debug('now raise setup exceptions ...',15);
583: -- raise setup errors and warnings
584: PQP_GB_PSI_FUNCTIONS.raise_extract_exceptions(p_extract_type => 'S');
585:
586: -- now clearing cache of assign_cat in basic criteria
587: --PQP_GB_PSI_FUNCTIONS.g_assign_category_mapping.DELETE;
588: END IF; -- shared and basic_data globals have been set

Line 587: --PQP_GB_PSI_FUNCTIONS.g_assign_category_mapping.DELETE;

583: -- raise setup errors and warnings
584: PQP_GB_PSI_FUNCTIONS.raise_extract_exceptions(p_extract_type => 'S');
585:
586: -- now clearing cache of assign_cat in basic criteria
587: --PQP_GB_PSI_FUNCTIONS.g_assign_category_mapping.DELETE;
588: END IF; -- shared and basic_data globals have been set
589:
590: g_current_run := 'PERIODIC';
591: debug('g_current_run :'||g_current_run);

Line 596: PQP_GB_PSI_FUNCTIONS.chk_penserver_basic_criteria

592:
593: debug('calling the basic criteria for this person assignment');
594: -- calling the basic criteria for this person assignment
595: l_return :=
596: PQP_GB_PSI_FUNCTIONS.chk_penserver_basic_criteria
597: (p_business_group_id => p_business_group_id
598: ,p_effective_date => p_effective_date
599: ,p_assignment_id => p_assignment_id
600: ,p_person_dtl => g_person_dtl

Line 616: l_chg_table := pqp_gb_psi_functions.get_dated_table_name(l_dated_table_id);

612: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
613: l_update_type := g_pay_proc_evt_tab(l_curr_evt_index).update_type;
614: l_dated_table_id := g_pay_proc_evt_tab(l_curr_evt_index).dated_table_id;
615: l_chg_column_name := g_pay_proc_evt_tab(l_curr_evt_index).column_name;
616: l_chg_table := pqp_gb_psi_functions.get_dated_table_name(l_dated_table_id);
617:
618: debug('----------');
619: debug('Record :'||l_curr_evt_index);
620: debug('----------');

Line 642: l_return := pqp_gb_psi_functions.include_event

638: debug_exit(l_proc_name);
639: return l_return;
640: END IF;
641:
642: l_return := pqp_gb_psi_functions.include_event
643: (p_actual_date => g_pay_proc_evt_tab(l_curr_evt_index).actual_date
644: ,p_effective_date => g_pay_proc_evt_tab(l_curr_evt_index).effective_date
645: );
646:

Line 665: pqp_gb_psi_functions.g_effective_date := p_effective_date;

661: ,p_effective_date => p_effective_date
662: );
663: END IF;
664:
665: pqp_gb_psi_functions.g_effective_date := p_effective_date;
666: debug('g_effective_date: '||g_effective_date);
667: debug('p_effective_date: '||p_effective_date);
668: IF pqp_gb_psi_functions.is_today_sal_start() = 'Y' THEN -- salary start
669: g_is_terminated := 'N'; -- change termination status to N

Line 668: IF pqp_gb_psi_functions.is_today_sal_start() = 'Y' THEN -- salary start

664:
665: pqp_gb_psi_functions.g_effective_date := p_effective_date;
666: debug('g_effective_date: '||g_effective_date);
667: debug('p_effective_date: '||p_effective_date);
668: IF pqp_gb_psi_functions.is_today_sal_start() = 'Y' THEN -- salary start
669: g_is_terminated := 'N'; -- change termination status to N
670: IF l_chg_table = 'PER_ALL_ASSIGNMENTS_F' AND l_update_type = 'I'
671: THEN
672: l_return := 'N'; -- this event is because of PQP_GB_PSI_NEW_HIRE event group.

Line 685: l_return := PQP_GB_PSI_FUNCTIONS.check_employee_pension_scheme

681: IF l_return = 'Y'
682: THEN
683: debug('calling function to check the pension scheme of the person');
684: --calling function to check the pension scheme of the person
685: l_return := PQP_GB_PSI_FUNCTIONS.check_employee_pension_scheme
686: (p_business_group_id => p_business_group_id
687: ,p_effective_date => p_effective_date
688: ,p_assignment_id => p_assignment_id
689: ,p_psi_pension_scheme => 'CLASSIC'

Line 696: l_return := PQP_GB_PSI_FUNCTIONS.check_employee_pension_scheme

692: debug('l_return: '||l_return,25);
693:
694: --****This commented loop is for 'Classic Plus' type of element.****--
695: /* IF l_return = 'N' THEN
696: l_return := PQP_GB_PSI_FUNCTIONS.check_employee_pension_scheme
697: (p_business_group_id => p_business_group_id
698: ,p_effective_date => p_effective_date
699: ,p_assignment_id => p_assignment_id
700: ,p_psi_pension_scheme => 'CLASSPLUS'

Line 885: l_error := PQP_GB_PSI_FUNCTIONS.raise_extract_warning

881: THEN
882: IF p_effective_date > TO_DATE(SUBSTR(l_opt_out_date,1,10),'yyyy/mm/dd')
883: THEN
884: l_return := 'N';
885: l_error := PQP_GB_PSI_FUNCTIONS.raise_extract_warning
886: (p_error_number => 94594
887: ,p_error_text => 'BEN_94594_OPTED_OUT_OF_SCHEME'
888: ,p_token1 => to_char(p_effective_date,'DD/MM/YYYY')
889: ,p_token2 => to_char(TO_DATE(SUBSTR(l_opt_out_date,1,10),'YYYY/MM/DD'),'DD/MM/YYYY')

Line 898: pqp_gb_psi_functions.process_retro_event(p_include => l_return);

894: CLOSE get_wps_percent_cont_cut;
895: END IF;
896:
897: IF l_return = 'Y' THEN
898: pqp_gb_psi_functions.process_retro_event(p_include => l_return);
899:
900: IF pqp_gb_psi_functions.is_today_sal_end() = 'Y' THEN -- salary end
901: g_is_terminated := 'Y'; -- change termination status to 'Y'
902: debug('Salary Ended Today');

Line 900: IF pqp_gb_psi_functions.is_today_sal_end() = 'Y' THEN -- salary end

896:
897: IF l_return = 'Y' THEN
898: pqp_gb_psi_functions.process_retro_event(p_include => l_return);
899:
900: IF pqp_gb_psi_functions.is_today_sal_end() = 'Y' THEN -- salary end
901: g_is_terminated := 'Y'; -- change termination status to 'Y'
902: debug('Salary Ended Today');
903:
904: -- For Bug 6033545

Line 935: PQP_GB_PSI_FUNCTIONS.altkey;

931: g_assignment_id IS NOT NULL and g_assignment_id <> p_assignment_id
932: ) THEN
933: -- put a fucntion here which is to be called only once per person
934: g_altkey :=
935: PQP_GB_PSI_FUNCTIONS.altkey;
936: --(p_assignment_number => g_assignment_dtl.assignment_number
937: --,p_paypoint => g_paypoint
938: --);
939: g_assignment_id := p_assignment_id;

Line 1008: l_chg_table := pqp_gb_psi_functions.get_dated_table_name(l_dated_table_id);

1004: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
1005: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
1006: l_update_type := g_pay_proc_evt_tab(l_curr_evt_index).update_type;
1007: l_dated_table_id := g_pay_proc_evt_tab(l_curr_evt_index).dated_table_id;
1008: l_chg_table := pqp_gb_psi_functions.get_dated_table_name(l_dated_table_id);
1009:
1010: --For Bug 6071527
1011: l_chg_column_name := g_pay_proc_evt_tab(l_curr_evt_index).column_name;
1012:

Line 1188: l_chg_table := pqp_gb_psi_functions.get_dated_table_name(l_dated_table_id);

1184:
1185: -- For Bug 5998123
1186: l_dated_table_id := g_pay_proc_evt_tab(l_curr_evt_index).dated_table_id;
1187: l_chg_column_name := g_pay_proc_evt_tab(l_curr_evt_index).column_name;
1188: l_chg_table := pqp_gb_psi_functions.get_dated_table_name(l_dated_table_id);
1189:
1190:
1191: --debug('g_pay_proc_evt_tab: '||g_pay_proc_evt_tab);
1192: debug('l_update_type:-'||l_update_type);

Line 1349: l_error := PQP_GB_PSI_FUNCTIONS.raise_extract_error

1345: );
1346: FETCH get_wps_element_name INTO l_element_name;
1347: IF get_wps_element_name%FOUND
1348: THEN
1349: l_error := PQP_GB_PSI_FUNCTIONS.raise_extract_error
1350: (p_error_number => 94532
1351: ,p_error_text => 'BEN_94532_NO_ENTRY_VALUE'
1352: ,p_token1 => l_element_name
1353: ,p_token2 => 'CONTRIBUTION PERCENT'

Line 1363: l_error := PQP_GB_PSI_FUNCTIONS.raise_extract_warning

1359: CLOSE get_wps_element_name;
1360: wps_percent := '0000000';
1361: ELSIF (fnd_number.canonical_to_number(wps_percent) > 100)
1362: THEN
1363: l_error := PQP_GB_PSI_FUNCTIONS.raise_extract_warning
1364: (p_error_number => 94533
1365: ,p_error_text => 'BEN_94533_IMPRACTICABLE_VALUE'
1366: ,p_token1 => wps_percent
1367: );

Line 1371: l_error := PQP_GB_PSI_FUNCTIONS.raise_extract_warning

1367: );
1368: wps_percent := rtrim(ltrim(to_char(fnd_number.canonical_to_number(wps_percent),'0999D99')));
1369: ELSIF (fnd_number.canonical_to_number(wps_percent) < 0)
1370: THEN
1371: l_error := PQP_GB_PSI_FUNCTIONS.raise_extract_warning
1372: (p_error_number => 94533
1373: ,p_error_text => 'BEN_94533_IMPRACTICABLE_VALUE'
1374: ,p_token1 => wps_percent
1375: );

Line 1440: --PQP_GB_PSI_FUNCTIONS.raise_extract_exceptions();

1436: BEGIN
1437: debug_enter(l_proc_name);
1438:
1439: --Raise extract exceptions which are stored while processing the data elements
1440: --PQP_GB_PSI_FUNCTIONS.raise_extract_exceptions();
1441:
1442: PQP_GB_PSI_FUNCTIONS.common_post_process(p_business_group_id => g_business_group_id);
1443: debug_exit(l_proc_name);
1444: return 'Y';

Line 1442: PQP_GB_PSI_FUNCTIONS.common_post_process(p_business_group_id => g_business_group_id);

1438:
1439: --Raise extract exceptions which are stored while processing the data elements
1440: --PQP_GB_PSI_FUNCTIONS.raise_extract_exceptions();
1441:
1442: PQP_GB_PSI_FUNCTIONS.common_post_process(p_business_group_id => g_business_group_id);
1443: debug_exit(l_proc_name);
1444: return 'Y';
1445: EXCEPTION
1446: WHEN others THEN