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 571: g_debug := PQP_GB_PSI_FUNCTIONS.check_debug(p_business_group_id);

567: -- clear the cached globals
568: clear_cache;
569:
570: -- for trace switching ON/OFF
571: g_debug := PQP_GB_PSI_FUNCTIONS.check_debug(p_business_group_id);
572:
573: -- setting shared globals
574: -- 1) paypoint
575: -- 2) cutover date

Line 577: PQP_GB_PSI_FUNCTIONS.set_shared_globals

573: -- setting shared globals
574: -- 1) paypoint
575: -- 2) cutover date
576: -- 3) extract def id
577: PQP_GB_PSI_FUNCTIONS.set_shared_globals
578: (p_business_group_id => p_business_group_id
579: ,p_paypoint => g_paypoint -- OUT
580: ,p_cutover_date => g_cutover_date -- OUT
581: ,p_ext_dfn_id => g_ext_dfn_id -- OUT

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

592: g_business_group_id := p_business_group_id;
593:
594: debug('now raise setup exceptions ...',15);
595: -- raise setup errors and warnings
596: PQP_GB_PSI_FUNCTIONS.raise_extract_exceptions(p_extract_type => 'S');
597:
598: -- now clearing cache of assign_cat in basic criteria
599: --PQP_GB_PSI_FUNCTIONS.g_assign_category_mapping.DELETE;
600: END IF; -- shared and basic_data globals have been set

Line 599: --PQP_GB_PSI_FUNCTIONS.g_assign_category_mapping.DELETE;

595: -- raise setup errors and warnings
596: PQP_GB_PSI_FUNCTIONS.raise_extract_exceptions(p_extract_type => 'S');
597:
598: -- now clearing cache of assign_cat in basic criteria
599: --PQP_GB_PSI_FUNCTIONS.g_assign_category_mapping.DELETE;
600: END IF; -- shared and basic_data globals have been set
601:
602: g_current_run := 'PERIODIC';
603: debug('g_current_run :'||g_current_run);

Line 608: PQP_GB_PSI_FUNCTIONS.chk_penserver_basic_criteria

604:
605: debug('calling the basic criteria for this person assignment');
606: -- calling the basic criteria for this person assignment
607: l_return :=
608: PQP_GB_PSI_FUNCTIONS.chk_penserver_basic_criteria
609: (p_business_group_id => p_business_group_id
610: ,p_effective_date => p_effective_date
611: ,p_assignment_id => p_assignment_id
612: ,p_person_dtl => g_person_dtl

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

624: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
625: l_update_type := g_pay_proc_evt_tab(l_curr_evt_index).update_type;
626: l_dated_table_id := g_pay_proc_evt_tab(l_curr_evt_index).dated_table_id;
627: l_chg_column_name := g_pay_proc_evt_tab(l_curr_evt_index).column_name;
628: l_chg_table := pqp_gb_psi_functions.get_dated_table_name(l_dated_table_id);
629:
630: debug('----------');
631: debug('Record :'||l_curr_evt_index);
632: debug('----------');

Line 654: l_return := pqp_gb_psi_functions.include_event

650: debug_exit(l_proc_name);
651: return l_return;
652: END IF;
653:
654: l_return := pqp_gb_psi_functions.include_event
655: (p_actual_date => g_pay_proc_evt_tab(l_curr_evt_index).actual_date
656: ,p_effective_date => g_pay_proc_evt_tab(l_curr_evt_index).effective_date
657: );
658:

Line 677: pqp_gb_psi_functions.g_effective_date := p_effective_date;

673: ,p_effective_date => p_effective_date
674: );
675: END IF;
676:
677: pqp_gb_psi_functions.g_effective_date := p_effective_date;
678: debug('g_effective_date: '||g_effective_date);
679: debug('p_effective_date: '||p_effective_date);
680: IF pqp_gb_psi_functions.is_today_sal_start() = 'Y' THEN -- salary start
681: g_is_terminated := 'N'; -- change termination status to N

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

676:
677: pqp_gb_psi_functions.g_effective_date := p_effective_date;
678: debug('g_effective_date: '||g_effective_date);
679: debug('p_effective_date: '||p_effective_date);
680: IF pqp_gb_psi_functions.is_today_sal_start() = 'Y' THEN -- salary start
681: g_is_terminated := 'N'; -- change termination status to N
682: IF l_chg_table = 'PER_ALL_ASSIGNMENTS_F' AND l_update_type = 'I'
683: THEN
684: l_return := 'N'; -- this event is because of PQP_GB_PSI_NEW_HIRE event group.

Line 697: l_return := PQP_GB_PSI_FUNCTIONS.check_employee_pension_scheme

693: IF l_return = 'Y'
694: THEN
695: debug('calling function to check the pension scheme of the person');
696: --calling function to check the pension scheme of the person
697: l_return := PQP_GB_PSI_FUNCTIONS.check_employee_pension_scheme
698: (p_business_group_id => p_business_group_id
699: ,p_effective_date => p_effective_date
700: ,p_assignment_id => p_assignment_id
701: ,p_psi_pension_scheme => 'CLASSIC'

Line 708: l_return := PQP_GB_PSI_FUNCTIONS.check_employee_pension_scheme

704: debug('l_return: '||l_return,25);
705:
706: --****This commented loop is for 'Classic Plus' type of element.****--
707: /* IF l_return = 'N' THEN
708: l_return := PQP_GB_PSI_FUNCTIONS.check_employee_pension_scheme
709: (p_business_group_id => p_business_group_id
710: ,p_effective_date => p_effective_date
711: ,p_assignment_id => p_assignment_id
712: ,p_psi_pension_scheme => 'CLASSPLUS'

Line 921: l_error := PQP_GB_PSI_FUNCTIONS.raise_extract_warning

917: THEN
918: IF p_effective_date > TO_DATE(SUBSTR(l_opt_out_date,1,10),'yyyy/mm/dd')
919: THEN
920: l_return := 'N';
921: l_error := PQP_GB_PSI_FUNCTIONS.raise_extract_warning
922: (p_error_number => 94594
923: ,p_error_text => 'BEN_94594_OPTED_OUT_OF_SCHEME'
924: ,p_token1 => to_char(p_effective_date,'DD/MM/YYYY')
925: ,p_token2 => to_char(TO_DATE(SUBSTR(l_opt_out_date,1,10),'YYYY/MM/DD'),'DD/MM/YYYY')

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

930: CLOSE get_wps_percent_cont_cut;
931: END IF;
932:
933: IF l_return = 'Y' THEN
934: pqp_gb_psi_functions.process_retro_event(p_include => l_return);
935:
936: IF pqp_gb_psi_functions.is_today_sal_end() = 'Y' THEN -- salary end
937: g_is_terminated := 'Y'; -- change termination status to 'Y'
938: debug('Salary Ended Today');

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

932:
933: IF l_return = 'Y' THEN
934: pqp_gb_psi_functions.process_retro_event(p_include => l_return);
935:
936: IF pqp_gb_psi_functions.is_today_sal_end() = 'Y' THEN -- salary end
937: g_is_terminated := 'Y'; -- change termination status to 'Y'
938: debug('Salary Ended Today');
939:
940: -- For Bug 6033545

Line 971: PQP_GB_PSI_FUNCTIONS.altkey;

967: g_assignment_id IS NOT NULL and g_assignment_id <> p_assignment_id
968: ) THEN
969: -- put a fucntion here which is to be called only once per person
970: g_altkey :=
971: PQP_GB_PSI_FUNCTIONS.altkey;
972: --(p_assignment_number => g_assignment_dtl.assignment_number
973: --,p_paypoint => g_paypoint
974: --);
975: g_assignment_id := p_assignment_id;

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

1040: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
1041: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
1042: l_update_type := g_pay_proc_evt_tab(l_curr_evt_index).update_type;
1043: l_dated_table_id := g_pay_proc_evt_tab(l_curr_evt_index).dated_table_id;
1044: l_chg_table := pqp_gb_psi_functions.get_dated_table_name(l_dated_table_id);
1045:
1046: --For Bug 6071527
1047: l_chg_column_name := g_pay_proc_evt_tab(l_curr_evt_index).column_name;
1048:

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

1220:
1221: -- For Bug 5998123
1222: l_dated_table_id := g_pay_proc_evt_tab(l_curr_evt_index).dated_table_id;
1223: l_chg_column_name := g_pay_proc_evt_tab(l_curr_evt_index).column_name;
1224: l_chg_table := pqp_gb_psi_functions.get_dated_table_name(l_dated_table_id);
1225:
1226:
1227: --debug('g_pay_proc_evt_tab: '||g_pay_proc_evt_tab);
1228: debug('l_update_type:-'||l_update_type);

Line 1385: l_error := PQP_GB_PSI_FUNCTIONS.raise_extract_error

1381: );
1382: FETCH get_wps_element_name INTO l_element_name;
1383: IF get_wps_element_name%FOUND
1384: THEN
1385: l_error := PQP_GB_PSI_FUNCTIONS.raise_extract_error
1386: (p_error_number => 94532
1387: ,p_error_text => 'BEN_94532_NO_ENTRY_VALUE'
1388: ,p_token1 => l_element_name
1389: ,p_token2 => 'CONTRIBUTION PERCENT'

Line 1399: l_error := PQP_GB_PSI_FUNCTIONS.raise_extract_warning

1395: CLOSE get_wps_element_name;
1396: wps_percent := '0000000';
1397: ELSIF (fnd_number.canonical_to_number(wps_percent) > 100)
1398: THEN
1399: l_error := PQP_GB_PSI_FUNCTIONS.raise_extract_warning
1400: (p_error_number => 94533
1401: ,p_error_text => 'BEN_94533_IMPRACTICABLE_VALUE'
1402: ,p_token1 => wps_percent
1403: );

Line 1407: l_error := PQP_GB_PSI_FUNCTIONS.raise_extract_warning

1403: );
1404: wps_percent := rtrim(ltrim(to_char(fnd_number.canonical_to_number(wps_percent),'0999D99')));
1405: ELSIF (fnd_number.canonical_to_number(wps_percent) < 0)
1406: THEN
1407: l_error := PQP_GB_PSI_FUNCTIONS.raise_extract_warning
1408: (p_error_number => 94533
1409: ,p_error_text => 'BEN_94533_IMPRACTICABLE_VALUE'
1410: ,p_token1 => wps_percent
1411: );

Line 1476: --PQP_GB_PSI_FUNCTIONS.raise_extract_exceptions();

1472: BEGIN
1473: debug_enter(l_proc_name);
1474:
1475: --Raise extract exceptions which are stored while processing the data elements
1476: --PQP_GB_PSI_FUNCTIONS.raise_extract_exceptions();
1477:
1478: PQP_GB_PSI_FUNCTIONS.common_post_process(p_business_group_id => g_business_group_id);
1479: debug_exit(l_proc_name);
1480: return 'Y';

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

1474:
1475: --Raise extract exceptions which are stored while processing the data elements
1476: --PQP_GB_PSI_FUNCTIONS.raise_extract_exceptions();
1477:
1478: PQP_GB_PSI_FUNCTIONS.common_post_process(p_business_group_id => g_business_group_id);
1479: debug_exit(l_proc_name);
1480: return 'Y';
1481: EXCEPTION
1482: WHEN others THEN