DBA Data[Home] [Help]

APPS.PQP_GB_CONFIGURATION_VALUE dependencies on HR_UTILITY

Line 17: hr_utility.set_location('Entering:'||l_proc,10);

13: Begin
14: l_proc:='PQP_GB_CONFIGURATION_VALUE.chk_pension_scheme_mapping';
15:
16: if g_debug then
17: hr_utility.set_location('Entering:'||l_proc,10);
18: hr_utility.trace('p_pcv_information2 '||p_pcv_information2);
19: hr_utility.trace('p_pcv_information3 '||p_pcv_information3);
20: end if;
21:

Line 18: hr_utility.trace('p_pcv_information2 '||p_pcv_information2);

14: l_proc:='PQP_GB_CONFIGURATION_VALUE.chk_pension_scheme_mapping';
15:
16: if g_debug then
17: hr_utility.set_location('Entering:'||l_proc,10);
18: hr_utility.trace('p_pcv_information2 '||p_pcv_information2);
19: hr_utility.trace('p_pcv_information3 '||p_pcv_information3);
20: end if;
21:
22: -- pcv_information3(Partnership scheme) must have value if

Line 19: hr_utility.trace('p_pcv_information3 '||p_pcv_information3);

15:
16: if g_debug then
17: hr_utility.set_location('Entering:'||l_proc,10);
18: hr_utility.trace('p_pcv_information2 '||p_pcv_information2);
19: hr_utility.trace('p_pcv_information3 '||p_pcv_information3);
20: end if;
21:
22: -- pcv_information3(Partnership scheme) must have value if
23: -- pcv_information2 is PARTNER

Line 28: hr_utility.set_message(8303,'PQP_230236_ENTER_PARTNER_SCH');

24: if (
25: p_pcv_information2 ='PARTNER' and p_pcv_information3 is null
26: ) then
27:
28: hr_utility.set_message(8303,'PQP_230236_ENTER_PARTNER_SCH');
29: hr_utility.raise_error;
30:
31: --else
32: -- pcv_information2 is not PARTNER then ignore.

Line 29: hr_utility.raise_error;

25: p_pcv_information2 ='PARTNER' and p_pcv_information3 is null
26: ) then
27:
28: hr_utility.set_message(8303,'PQP_230236_ENTER_PARTNER_SCH');
29: hr_utility.raise_error;
30:
31: --else
32: -- pcv_information2 is not PARTNER then ignore.
33: end if;

Line 37: hr_utility.set_location('Leaving:'||l_proc,20);

33: end if;
34:
35:
36: if g_debug then
37: hr_utility.set_location('Leaving:'||l_proc,20);
38: end if;
39:
40: End chk_pension_scheme_mapping;
41:

Line 556: -- hr_utility.trace_on(null,'SWFTRC');

552: p_return boolean;
553: l_mapping_info_category varchar2(100);
554: l_mapping_lookup varchar2(100) ;
555: begin
556: -- hr_utility.trace_on(null,'SWFTRC');
557: hr_utility.trace('Inside Post source');
558: hr_utility.trace('p_pcv_information_category='||p_pcv_information_category);
559: hr_utility.trace('p_pcv_information1='||p_pcv_information1);
560: hr_utility.trace('p_pcv_information3='||p_pcv_information3);

Line 557: hr_utility.trace('Inside Post source');

553: l_mapping_info_category varchar2(100);
554: l_mapping_lookup varchar2(100) ;
555: begin
556: -- hr_utility.trace_on(null,'SWFTRC');
557: hr_utility.trace('Inside Post source');
558: hr_utility.trace('p_pcv_information_category='||p_pcv_information_category);
559: hr_utility.trace('p_pcv_information1='||p_pcv_information1);
560: hr_utility.trace('p_pcv_information3='||p_pcv_information3);
561:

Line 558: hr_utility.trace('p_pcv_information_category='||p_pcv_information_category);

554: l_mapping_lookup varchar2(100) ;
555: begin
556: -- hr_utility.trace_on(null,'SWFTRC');
557: hr_utility.trace('Inside Post source');
558: hr_utility.trace('p_pcv_information_category='||p_pcv_information_category);
559: hr_utility.trace('p_pcv_information1='||p_pcv_information1);
560: hr_utility.trace('p_pcv_information3='||p_pcv_information3);
561:
562: -- Get role/post mapping

Line 559: hr_utility.trace('p_pcv_information1='||p_pcv_information1);

555: begin
556: -- hr_utility.trace_on(null,'SWFTRC');
557: hr_utility.trace('Inside Post source');
558: hr_utility.trace('p_pcv_information_category='||p_pcv_information_category);
559: hr_utility.trace('p_pcv_information1='||p_pcv_information1);
560: hr_utility.trace('p_pcv_information3='||p_pcv_information3);
561:
562: -- Get role/post mapping
563: if p_pcv_information_category = 'PQP_GB_SWF_ROLE_SOURCE' then

Line 560: hr_utility.trace('p_pcv_information3='||p_pcv_information3);

556: -- hr_utility.trace_on(null,'SWFTRC');
557: hr_utility.trace('Inside Post source');
558: hr_utility.trace('p_pcv_information_category='||p_pcv_information_category);
559: hr_utility.trace('p_pcv_information1='||p_pcv_information1);
560: hr_utility.trace('p_pcv_information3='||p_pcv_information3);
561:
562: -- Get role/post mapping
563: if p_pcv_information_category = 'PQP_GB_SWF_ROLE_SOURCE' then
564: l_mapping_info_category := 'PQP_GB_SWF_ROLE_MAPPING';

Line 581: hr_utility.trace('l_mapping_lookup='||l_mapping_lookup);

577: when no_data_found then
578: null ;
579: end ;
580:
581: hr_utility.trace('l_mapping_lookup='||l_mapping_lookup);
582: hr_utility.trace('p_pcv_information1='||p_pcv_information1);
583:
584: if p_pcv_information1 = 'EMP_CAT' and l_mapping_lookup <> 'EMP_CAT' then
585: hr_utility.trace('Raising error for EMP_CAT');

Line 582: hr_utility.trace('p_pcv_information1='||p_pcv_information1);

578: null ;
579: end ;
580:
581: hr_utility.trace('l_mapping_lookup='||l_mapping_lookup);
582: hr_utility.trace('p_pcv_information1='||p_pcv_information1);
583:
584: if p_pcv_information1 = 'EMP_CAT' and l_mapping_lookup <> 'EMP_CAT' then
585: hr_utility.trace('Raising error for EMP_CAT');
586: fnd_message.set_name('PQP', 'PQP_230246_INCORRECT_LOOKUP');

Line 585: hr_utility.trace('Raising error for EMP_CAT');

581: hr_utility.trace('l_mapping_lookup='||l_mapping_lookup);
582: hr_utility.trace('p_pcv_information1='||p_pcv_information1);
583:
584: if p_pcv_information1 = 'EMP_CAT' and l_mapping_lookup <> 'EMP_CAT' then
585: hr_utility.trace('Raising error for EMP_CAT');
586: fnd_message.set_name('PQP', 'PQP_230246_INCORRECT_LOOKUP');
587: fnd_message.set_token('LOOKUP_NAME', 'EMP_CAT');
588: fnd_message.set_token('SOURCE', 'Assignment Category');
589: fnd_message.raise_error;

Line 591: hr_utility.trace('Raising error for EMPLOYEE_CATG');

587: fnd_message.set_token('LOOKUP_NAME', 'EMP_CAT');
588: fnd_message.set_token('SOURCE', 'Assignment Category');
589: fnd_message.raise_error;
590: elsif p_pcv_information1 = 'EMPLOYEE_CATG' and l_mapping_lookup <> 'EMPLOYEE_CATG' then
591: hr_utility.trace('Raising error for EMPLOYEE_CATG');
592: fnd_message.set_name('PQP', 'PQP_230246_INCORRECT_LOOKUP');
593: fnd_message.set_token('LOOKUP_NAME', 'EMPLOYEE_CATG');
594: fnd_message.set_token('SOURCE', 'Employee Category');
595: fnd_message.raise_error;

Line 598: hr_utility.trace('Outside error raising section');

594: fnd_message.set_token('SOURCE', 'Employee Category');
595: fnd_message.raise_error;
596: end if;
597:
598: hr_utility.trace('Outside error raising section');
599: --
600: -- 1) Segment Name must be provided if Job/Position/Grade KFF
601: -- is selected as source
602: if p_pcv_information1 = 'JOB' and p_pcv_information3 is null then

Line 618: hr_utility.trace('Leaving Post source checks');

614: fnd_message.set_token('FIELD', 'Segment Column');
615: fnd_message.set_token('SOURCE', 'Grade Key Flexfield');
616: fnd_message.raise_error;
617: end if ;
618: hr_utility.trace('Leaving Post source checks');
619: --
620: end chk_role_post_source;
621:
622: --

Line 1358: g_debug := Hr_utility.debug_enabled;

1354: BEGIN
1355: l_proc:='PQP_GB_CONFIGURATION_VALUE.CREATE_CONFIGURATION_VALUE_BP';
1356:
1357: if g_debug is null then
1358: g_debug := Hr_utility.debug_enabled;
1359: end if;
1360:
1361: if g_debug then
1362: hr_utility.set_location('Entering:'||l_proc,10);

Line 1362: hr_utility.set_location('Entering:'||l_proc,10);

1358: g_debug := Hr_utility.debug_enabled;
1359: end if;
1360:
1361: if g_debug then
1362: hr_utility.set_location('Entering:'||l_proc,10);
1363: end if;
1364:
1365: /* Create private procedures to validate
1366: pcv_information_category you are interested in */

Line 1368: -- hr_utility.trace_on(null,'CNFTRC');

1364:
1365: /* Create private procedures to validate
1366: pcv_information_category you are interested in */
1367:
1368: -- hr_utility.trace_on(null,'CNFTRC');
1369: case (p_pcv_information_category)
1370: when 'PQP_GB_PENSERV_SCHEME_MAP_INFO'then
1371: chk_pension_scheme_mapping(p_pcv_information2 =>p_pcv_information2 --Penserv Scheme
1372: ,p_pcv_information3 =>p_pcv_information3 --Partner Scheme

Line 1577: hr_utility.set_location('Leaving:'||l_proc,20);

1573: end case;
1574:
1575:
1576: if g_debug then
1577: hr_utility.set_location('Leaving:'||l_proc,20);
1578: end if;
1579:
1580: END;
1581:

Line 1617: g_debug := Hr_utility.debug_enabled;

1613: l_count number;
1614: l_role_source varchar2(100);
1615: BEGIN
1616: if g_debug is null then
1617: g_debug := Hr_utility.debug_enabled;
1618: end if;
1619: l_proc:='PQP_GB_CONFIGURATION_VALUE.UPDATE_CONFIGURATION_VALUE_BP';
1620:
1621: if g_debug then

Line 1622: hr_utility.set_location('Entering:'||l_proc,10);

1618: end if;
1619: l_proc:='PQP_GB_CONFIGURATION_VALUE.UPDATE_CONFIGURATION_VALUE_BP';
1620:
1621: if g_debug then
1622: hr_utility.set_location('Entering:'||l_proc,10);
1623: end if;
1624:
1625:
1626: /* Create private procedures to validate

Line 1837: hr_utility.set_location('Leaving:'||l_proc,20);

1833: end case;
1834:
1835:
1836: if g_debug then
1837: hr_utility.set_location('Leaving:'||l_proc,20);
1838: end if;
1839:
1840: END;
1841: END PQP_GB_CONFIGURATION_VALUE;