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_SALARY_HISTORY dependencies on PQP_GB_PSI_FUNCTIONS

Line 127: pqp_gb_psi_functions.get_rate_usr_func_name

123: debug_enter(l_proc);
124: --reset salary rate name
125: g_basic_sal_rate_name := NULL;
126:
127: pqp_gb_psi_functions.get_rate_usr_func_name
128: (
129: p_business_group_id => g_business_group_id
130: ,p_legislation_code => g_legislation_code
131: ,p_interface_name => 'SALARY'

Line 183: PQP_GB_PSI_FUNCTIONS.store_extract_exceptions

179: debug('override to uniformed grade flag can be in People Group Flexfield',30);
180:
181: IF g_people_group_column IS NULL THEN
182: debug('Error: People Group Column is null in the Unigrade Config Value');
183: PQP_GB_PSI_FUNCTIONS.store_extract_exceptions
184: (p_extract_type => 'SALARY'
185: ,p_error_number => 94444
186: ,p_error_text => 'BEN_94444_NO_PEOPLE_GRP_COLUMN'
187: ,p_error_warning_flag => 'E'

Line 198: PQP_GB_PSI_FUNCTIONS.store_extract_exceptions

194: debug('override to uniformed grade flag can be in Assignment Flexfield',20);
195: IF g_assignment_context IS NULL THEN
196:
197: debug('Error: Assignment Column is null in the Unigrade Config Value',30);
198: PQP_GB_PSI_FUNCTIONS.store_extract_exceptions
199: (p_extract_type => 'SALARY'
200: ,p_error_number => 94446
201: ,p_error_text => 'BEN_94446_NO_ASSG_CONTEXT'
202: ,p_error_warning_flag => 'E'

Line 208: PQP_GB_PSI_FUNCTIONS.store_extract_exceptions

204: END IF; --IF g_assignment_column IS NOT NULL
205: IF g_assignment_column IS NULL THEN
206:
207: debug('Error: Assignment Column is null in the Unigrade Config Value',30);
208: PQP_GB_PSI_FUNCTIONS.store_extract_exceptions
209: (p_extract_type => 'SALARY'
210: ,p_error_number => 94445
211: ,p_error_text => 'BEN_94445_NO_ASSIGNMENT_COLUMN'
212: ,p_error_warning_flag => 'E'

Line 218: PQP_GB_PSI_FUNCTIONS.store_extract_exceptions

214: END IF; --IF g_assignment_column IS NOT NULL
215: END IF; --IF l_source = 'PEOPLE_GROUP'
216: ELSE
217: debug('No Configuration for Uniformed Grade Override',20);
218: PQP_GB_PSI_FUNCTIONS.store_extract_exceptions
219: (p_extract_type => 'SALARY'
220: ,p_error_number => 94440
221: ,p_error_text => 'BEN_94440_NO_UNIGRD_CONFIG'
222: ,p_error_warning_flag => 'E'

Line 283: PQP_GB_PSI_FUNCTIONS.init_st_end_date_glob();

279: debug('Inputs are: ',10);
280: debug('p_assignment_id: '||p_assignment_id,10);
281: debug('p_effective_date: '||to_char(p_effective_date,'dd/mm/yyyy'),10);
282:
283: PQP_GB_PSI_FUNCTIONS.init_st_end_date_glob();
284: -- reset assignment level globals
285: g_salary_start_date := NULL;
286: g_salary_end_date := NULL;
287:

Line 295: g_person_id := PQP_GB_PSI_FUNCTIONS.get_current_extract_person

291:
292: -- set the global events table
293: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;
294: -- set global person id
295: g_person_id := PQP_GB_PSI_FUNCTIONS.get_current_extract_person
296: (
297: p_assignment_id => p_assignment_id
298: );
299: debug('g_person_id: '||g_person_id,10);

Line 349: g_debug := pqp_gb_psi_functions.check_debug(g_business_group_id);

345: OR p_business_group_id <> nvl(g_business_group_id,0) THEN
346:
347: g_business_group_id := p_business_group_id;
348: -- set the global debug value
349: g_debug := pqp_gb_psi_functions.check_debug(g_business_group_id);
350:
351: debug_enter(l_proc);
352: debug('Inputs are: ');
353: debug('p_business_group_id: '||p_business_group_id);

Line 357: PQP_GB_PSI_FUNCTIONS.set_shared_globals

353: debug('p_business_group_id: '||p_business_group_id);
354: debug('p_assignment_id: '||p_assignment_id);
355: debug('p_effective_date: '||to_char(p_effective_date,'dd/mm/yyyy'));
356:
357: PQP_GB_PSI_FUNCTIONS.set_shared_globals
358: (p_business_group_id => p_business_group_id
359: ,p_paypoint => g_paypoint
360: ,p_cutover_date => g_cutover_date
361: ,p_ext_dfn_id => g_ext_dfn_id

Line 373: PQP_GB_PSI_FUNCTIONS.raise_extract_exceptions('S');

369: ,p_effective_date => p_effective_date
370: );
371: --Raise extract exceptions which are stored while checking for the setup
372: debug('Raising the set-up errors, with input parameter as S');
373: PQP_GB_PSI_FUNCTIONS.raise_extract_exceptions('S');
374: END IF;
375: l_include := PQP_GB_PSI_FUNCTIONS.chk_penserver_basic_criteria
376: (p_business_group_id => p_business_group_id
377: ,p_effective_date => p_effective_date

Line 375: l_include := PQP_GB_PSI_FUNCTIONS.chk_penserver_basic_criteria

371: --Raise extract exceptions which are stored while checking for the setup
372: debug('Raising the set-up errors, with input parameter as S');
373: PQP_GB_PSI_FUNCTIONS.raise_extract_exceptions('S');
374: END IF;
375: l_include := PQP_GB_PSI_FUNCTIONS.chk_penserver_basic_criteria
376: (p_business_group_id => p_business_group_id
377: ,p_effective_date => p_effective_date
378: ,p_assignment_id => p_assignment_id
379: ,p_person_dtl => g_curr_person_dtls

Line 485: g_debug := pqp_gb_psi_functions.check_debug(to_char(g_business_group_id));

481: OR p_business_group_id <> nvl(g_business_group_id,0) THEN
482:
483: g_business_group_id := p_business_group_id;
484: -- set the global debug value
485: g_debug := pqp_gb_psi_functions.check_debug(to_char(g_business_group_id));
486: debug_enter(l_proc);
487: debug('Inputs are: ');
488: debug('p_business_group_id: '||p_business_group_id);
489: debug('p_assignment_id: '||p_assignment_id);

Line 492: PQP_GB_PSI_FUNCTIONS.set_shared_globals

488: debug('p_business_group_id: '||p_business_group_id);
489: debug('p_assignment_id: '||p_assignment_id);
490: debug('p_effective_date: '||to_char(p_effective_date,'dd/mm/yyyy'));
491:
492: PQP_GB_PSI_FUNCTIONS.set_shared_globals
493: (p_business_group_id => p_business_group_id
494: ,p_paypoint => g_paypoint
495: ,p_cutover_date => g_cutover_date
496: ,p_ext_dfn_id => g_ext_dfn_id

Line 507: PQP_GB_PSI_FUNCTIONS.raise_extract_exceptions('S');

503: ,p_effective_date => p_effective_date
504: );
505: --Raise extract exceptions which are stored while checking for the setup
506: debug('Raising the set-up errors, with input parameter as S');
507: PQP_GB_PSI_FUNCTIONS.raise_extract_exceptions('S');
508: END IF; --IF g_business_group_id IS NULL
509:
510: l_include := PQP_GB_PSI_FUNCTIONS.chk_penserver_basic_criteria
511: (p_business_group_id => p_business_group_id

Line 510: l_include := PQP_GB_PSI_FUNCTIONS.chk_penserver_basic_criteria

506: debug('Raising the set-up errors, with input parameter as S');
507: PQP_GB_PSI_FUNCTIONS.raise_extract_exceptions('S');
508: END IF; --IF g_business_group_id IS NULL
509:
510: l_include := PQP_GB_PSI_FUNCTIONS.chk_penserver_basic_criteria
511: (p_business_group_id => p_business_group_id
512: ,p_effective_date => p_effective_date
513: ,p_assignment_id => p_assignment_id
514: ,p_person_dtl => g_curr_person_dtls

Line 552: l_include := pqp_gb_psi_functions.include_event

548: debug('change_mode :'||g_pay_proc_evt_tab(l_curr_evt_index).change_mode ,20);
549:
550: IF l_include <> 'N' THEN
551: debug('Calling the common include event proc');
552: l_include := pqp_gb_psi_functions.include_event
553: (p_actual_date => g_pay_proc_evt_tab(l_curr_evt_index).actual_date
554: ,p_effective_date => g_pay_proc_evt_tab(l_curr_evt_index).effective_date
555: );
556:

Line 564: l_error := PQP_GB_PSI_FUNCTIONS.get_start_end_date

560:
561: IF l_include <> 'N' THEN
562: -- set start and end dates.
563: --l_error := set_salary_start_end_date();
564: l_error := PQP_GB_PSI_FUNCTIONS.get_start_end_date
565: (
566: p_assignment_id => g_assignment_id
567: ,p_business_group_id => g_business_group_id
568: ,p_effective_date => g_effective_date

Line 590: pqp_gb_psi_functions.process_retro_event(l_include);

586: END IF;-- IF g_salary_start_date IS NULL
587:
588: END IF; --IF l_include <> 'N'
589: END IF; --IF l_include <> 'N'
590: pqp_gb_psi_functions.process_retro_event(l_include);
591: debug('Returning : '||l_include,10);
592: debug_exit(l_proc);
593: return l_include;
594: EXCEPTION

Line 645: l_error := PQP_GB_PSI_FUNCTIONS.raise_extract_error

641:
642: IF l_hire_date IS NULL THEN
643: -- Raise error
644: debug('This person does not have joining date. Please check and correct person details.');
645: l_error := PQP_GB_PSI_FUNCTIONS.raise_extract_error
646: (p_error_number => 94450
647: ,p_error_text => 'BEN_94450_NO_JOINING_DATE'
648: ,p_token1 => to_char(g_effective_date,'dd-MON-yyyy')
649: );

Line 739: l_error := PQP_GB_PSI_FUNCTIONS.get_contract_type

735: l_error NUMBER;
736: BEGIN
737: debug_enter(l_proc);
738:
739: l_error := PQP_GB_PSI_FUNCTIONS.get_contract_type
740: (
741: p_assignment_id => g_assignment_id
742: ,p_business_group_id => g_business_group_id
743: ,p_effective_date => p_effective_date

Line 783: l_error := PQP_GB_PSI_FUNCTIONS.get_notional_pay

779: BEGIN
780: debug_enter(l_proc);
781:
782: ----------------------------------------------
783: l_error := PQP_GB_PSI_FUNCTIONS.get_notional_pay
784: (
785: p_assignment_id => g_assignment_id
786: ,p_business_group_id => g_business_group_id
787: ,p_effective_date => g_salary_start_date

Line 797: l_fte_value := PQP_GB_PSI_FUNCTIONS.get_fte_value

793:
794: l_notional_pay := fnd_number.canonical_to_number(p_output);
795:
796: IF nvl(g_sal_ele_fte_attr,'NONE') = 'ALL' THEN
797: l_fte_value := PQP_GB_PSI_FUNCTIONS.get_fte_value
798: (
799: p_assignment_id => g_assignment_id
800: ,p_effective_date => g_effective_date
801: );

Line 814: l_error := PQP_GB_PSI_FUNCTIONS.raise_extract_error

810: IF NOT ( l_notional_pay >= -99999999.99 AND l_notional_pay <= 999999999.99 ) THEN
811: -- raise error that the bonus amount is out of range
812: -- bug fix 4998232
813: debug('ERROR: Bonus Amount out of range: '||l_notional_pay,20);
814: l_error := PQP_GB_PSI_FUNCTIONS.raise_extract_error
815: (p_error_number => 94569
816: ,p_error_text => 'BEN_94569_INV_SALARY_AMOUNT'
817: ,p_token1 => to_char(g_effective_date,'dd/mm/yyyy')
818: ,p_token2 => p_output

Line 940: l_error := PQP_GB_PSI_FUNCTIONS.raise_extract_error

936: IF l_flag = 'Y' THEN
937: IF l_uniform_grade_flag NOT IN ('Y','N','y','n') THEN
938: -- DATA ERROR
939: debug('ERROR: The Overridden Uniformed Grade Flag is neither Y nor N',20);
940: l_error := PQP_GB_PSI_FUNCTIONS.raise_extract_error
941: (p_error_number => 94443
942: ,p_error_text => 'BEN_94443_INVALID_UNIGRD_FLAG'
943: ,p_token1 => to_char(g_effective_date,'dd-MON-yyyy')
944: ,p_token2 => p_output

Line 1071: l_chg_table := PQP_GB_PSI_FUNCTIONS.get_dated_table_name(l_chg_table_id);

1067: l_index := ben_ext_person.g_chg_pay_evt_index;
1068: LOOP
1069: l_chg_type := g_pay_proc_evt_tab(l_index).update_type;
1070: l_chg_table_id := g_pay_proc_evt_tab(l_index).dated_table_id;
1071: l_chg_table := PQP_GB_PSI_FUNCTIONS.get_dated_table_name(l_chg_table_id);
1072: l_chg_date := g_pay_proc_evt_tab(l_index).effective_date;
1073: l_chg_column_name := g_pay_proc_evt_tab(l_index).column_name;
1074:
1075: debug('l_chg_date: '||l_chg_date);

Line 1241: l_error := PQP_GB_PSI_FUNCTIONS.raise_extract_warning

1237: IF l_grade_id IS NOT NULL THEN
1238: IF ltrim(l_grade_code) IS NULL THEN
1239: -- Raise warning when a grade is attahced which has no grade code
1240: debug('Warning: Grade attached to the person has no extra information: '||l_grade_id,30);
1241: l_error := PQP_GB_PSI_FUNCTIONS.raise_extract_warning
1242: (p_error_number => 94448
1243: ,p_error_text => 'BEN_94448_NO_GRADE_EIT'
1244: ,p_token1 => to_char(g_effective_date,'dd-MON-yyyy')
1245: );

Line 1246: ELSIF NOT pqp_gb_psi_functions.is_alphanumeric(l_grade_code) THEN

1242: (p_error_number => 94448
1243: ,p_error_text => 'BEN_94448_NO_GRADE_EIT'
1244: ,p_token1 => to_char(g_effective_date,'dd-MON-yyyy')
1245: );
1246: ELSIF NOT pqp_gb_psi_functions.is_alphanumeric(l_grade_code) THEN
1247: -- Raise error when the grade code is not alphanumeric
1248: debug('ERROR: Grade code is invalid: '||p_output,30);
1249: l_error := PQP_GB_PSI_FUNCTIONS.raise_extract_error
1250: (p_error_number => 94447

Line 1249: l_error := PQP_GB_PSI_FUNCTIONS.raise_extract_error

1245: );
1246: ELSIF NOT pqp_gb_psi_functions.is_alphanumeric(l_grade_code) THEN
1247: -- Raise error when the grade code is not alphanumeric
1248: debug('ERROR: Grade code is invalid: '||p_output,30);
1249: l_error := PQP_GB_PSI_FUNCTIONS.raise_extract_error
1250: (p_error_number => 94447
1251: ,p_error_text => 'BEN_94447_INV_GRD_CODE'
1252: ,p_token1 => to_char(g_effective_date,'dd-MON-yyyy')
1253: ,p_token2 => l_grade_code

Line 1294: l_error := PQP_GB_PSI_FUNCTIONS.get_actual_pay

1290: l_error NUMBER;
1291: --
1292: BEGIN
1293: debug_enter(l_proc);
1294: l_error := PQP_GB_PSI_FUNCTIONS.get_actual_pay
1295: (
1296: p_assignment_id => g_assignment_id
1297: ,p_notional_pay => g_notional_pay
1298: ,p_effective_date => g_salary_start_date

Line 1420: --PQP_GB_PSI_FUNCTIONS.raise_extract_exceptions();

1416: BEGIN
1417: debug_enter(l_proc);
1418:
1419: --Raise extract exceptions which are stored while processing the data elements
1420: --PQP_GB_PSI_FUNCTIONS.raise_extract_exceptions();
1421:
1422: --call the common post processing function
1423: PQP_GB_PSI_FUNCTIONS.common_post_process(g_business_group_id);
1424:

Line 1423: PQP_GB_PSI_FUNCTIONS.common_post_process(g_business_group_id);

1419: --Raise extract exceptions which are stored while processing the data elements
1420: --PQP_GB_PSI_FUNCTIONS.raise_extract_exceptions();
1421:
1422: --call the common post processing function
1423: PQP_GB_PSI_FUNCTIONS.common_post_process(g_business_group_id);
1424:
1425: debug_exit(l_proc);
1426: return 'Y';
1427: EXCEPTION