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

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

39: l_legislation_code varchar2(150);
40: --
41: begin
42: --
43: hr_utility.set_location('Entering:'|| l_proc, 10);
44: --
45: -- Ensure that all the mandatory parameter are not null
46: --
47: hr_api.mandatory_arg_error

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

79: --
80: hr_api.set_legislation_context(l_legislation_code);
81: end if;
82: --
83: hr_utility.set_location(' Leaving:'|| l_proc, 20);
84: --
85: end set_security_group_id;
86: --
87: -- ---------------------------------------------------------------------------

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

108: l_proc varchar2(72) := g_package||'return_legislation_code';
109: --
110: Begin
111: --
112: hr_utility.set_location('Entering:'|| l_proc, 10);
113: --
114: -- Ensure that all the mandatory parameter are not null
115: --
116: hr_api.mandatory_arg_error

Line 130: hr_utility.set_location(l_proc, 20);

126: -- call to this function. Just return the value in the global
127: -- variable.
128: --
129: l_legislation_code := pqp_pcv_bus.g_legislation_code;
130: hr_utility.set_location(l_proc, 20);
131: else
132: --
133: -- The ID is different to the last call to this function
134: -- or this is the first call to this function.

Line 147: hr_utility.set_location(l_proc,30);

143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
149: -- Set the global variables so the values are
150: -- available for the next call to this function.
151: --

Line 156: hr_utility.set_location(' Leaving:'|| l_proc, 40);

152: close csr_leg_code;
153: pqp_pcv_bus.g_configuration_value_id := p_configuration_value_id;
154: pqp_pcv_bus.g_legislation_code := l_legislation_code;
155: end if;
156: hr_utility.set_location(' Leaving:'|| l_proc, 40);
157: return l_legislation_code;
158: end return_legislation_code;
159: --
160: -- ----------------------------------------------------------------------------

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

191: --
192: l_proc varchar2(72) := g_package || 'chk_ddf';
193: --
194: begin
195: hr_utility.set_location('Entering:'||l_proc,10);
196: --
197: if ((p_rec.configuration_value_id is not null) and (
198: nvl(pqp_pcv_shd.g_old_rec.pcv_information_category, hr_api.g_varchar2) <>
199: nvl(p_rec.pcv_information_category, hr_api.g_varchar2) or

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

290: ,p_attribute20_value => p_rec.pcv_information20
291: );
292: end if;
293: --
294: hr_utility.set_location(' Leaving:'||l_proc,20);
295: end chk_ddf;
296: --
297: -- ----------------------------------------------------------------------------
298: -- |------------------------------< chk_df >----------------------------------|

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

328: --
329: l_proc varchar2(72) := g_package || 'chk_df';
330: --
331: begin
332: hr_utility.set_location('Entering:'||l_proc,10);
333: --
334: if ((p_rec.configuration_value_id is not null) and (
335: nvl(pqp_pcv_shd.g_old_rec.pcv_attribute_category, hr_api.g_varchar2) <>
336: nvl(p_rec.pcv_attribute_category, hr_api.g_varchar2) or

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

427: ,p_attribute20_value => p_rec.pcv_attribute20
428: );
429: end if;
430: --
431: hr_utility.set_location(' Leaving:'||l_proc,20);
432: end chk_df;
433: --
434: -- ----------------------------------------------------------------------------
435: -- |-----------------------< chk_non_updateable_args >------------------------|

Line 585: hr_utility.set_location('Entering: chk_mandatory_fields', 5);

581: c_column_cursor ref_csr_typ;
582: l_legislation_code varchar2(150);
583:
584: BEGIN
585: hr_utility.set_location('Entering: chk_mandatory_fields', 5);
586: OPEN config_unique_col_cursor;
587: FETCH config_unique_col_cursor INTO l_count;
588: CLOSE config_unique_col_cursor;
589: hr_utility.set_location('l_count :'||l_count, 5);

Line 589: hr_utility.set_location('l_count :'||l_count, 5);

585: hr_utility.set_location('Entering: chk_mandatory_fields', 5);
586: OPEN config_unique_col_cursor;
587: FETCH config_unique_col_cursor INTO l_count;
588: CLOSE config_unique_col_cursor;
589: hr_utility.set_location('l_count :'||l_count, 5);
590: IF l_count = 1 THEN
591: l_where_clause := ' AND pcv_information1 = '||''''||nvl(p_rec.pcv_information1,'?') ||''''||'';
592: ELSIF l_count = 2 THEN
593: l_where_clause := ' AND pcv_information1 = '||''''||nvl(p_rec.pcv_information1,'?') ||''''||''||

Line 732: hr_utility.set_location('Inside If', 5);

728: --Getting the legislationId for business groupId
729: -- Get legislation code
730:
731: IF l_where_clause is not null then
732: hr_utility.set_location('Inside If', 5);
733: l_temp_str := 'SELECT count(CONFIGURATION_VALUE_ID)
734: FROM pqp_configuration_values
735: WHERE NVL(business_group_id,'||''''||hr_api.g_number||''''||') =
736: NVL('||''''||p_rec.business_group_id||''''||','||''''||hr_api.g_number||''''||')

Line 748: hr_utility.set_location('l_column_count :'||l_column_count, 5);

744:
745: OPEN c_column_cursor FOR l_temp_str;
746: FETCH c_column_cursor INTO l_column_count;
747: CLOSE c_column_cursor;
748: hr_utility.set_location('l_column_count :'||l_column_count, 5);
749: END IF;
750: hr_utility.set_location('Leaving: chk_mandatory_fields', 5);
751: IF l_column_count>0 THEN
752: -- IF p_flag = 'U' THEN

Line 750: hr_utility.set_location('Leaving: chk_mandatory_fields', 5);

746: FETCH c_column_cursor INTO l_column_count;
747: CLOSE c_column_cursor;
748: hr_utility.set_location('l_column_count :'||l_column_count, 5);
749: END IF;
750: hr_utility.set_location('Leaving: chk_mandatory_fields', 5);
751: IF l_column_count>0 THEN
752: -- IF p_flag = 'U' THEN
753: -- fnd_message.set_name('PQP','PQP_230751_NO_CHGS_TO_SAVE');
754: -- fnd_message.raise_error;

Line 823: hr_utility.set_location('Entering:'||l_proc, 5);

819: l_total_uniq_cols NUMBER;
820:
821: --
822: Begin
823: hr_utility.set_location('Entering:'||l_proc, 5);
824:
825: -- Get legislation code
826: IF p_rec.business_group_id IS NULL THEN
827: l_legislation_code := p_rec.legislation_code;

Line 832: hr_utility.set_location(l_proc, 10);

828: ELSE
829: l_legislation_code := get_legislation_code(p_rec.business_group_id);
830: END IF; -- End if of business_group_id is null check...
831:
832: hr_utility.set_location(l_proc, 10);
833:
834: l_mult_occurrence := NULL;
835:
836: OPEN csr_get_occurrence_type

Line 847: hr_utility.set_location(l_proc, 20);

843: CLOSE csr_get_occurrence_type;
844:
845: -- Check whether multiple occurrence allowed
846:
847: hr_utility.set_location(l_proc, 20);
848:
849: IF l_mult_occurrence = 'N' THEN
850:
851: hr_utility.set_location(l_proc, 30);

Line 851: hr_utility.set_location(l_proc, 30);

847: hr_utility.set_location(l_proc, 20);
848:
849: IF l_mult_occurrence = 'N' THEN
850:
851: hr_utility.set_location(l_proc, 30);
852:
853: -- Check for row existence in pqp_configuration_values
854: OPEN csr_chk_config_val
855: (p_rec.configuration_value_id

Line 876: hr_utility.set_location(l_proc, 40);

872:
873: ELSE -- multiple occurrence exist
874:
875: -- Added check for total_unique_columns
876: hr_utility.set_location(l_proc, 40);
877:
878: IF l_total_uniq_cols IS NULL THEN
879:
880: -- Raise an error

Line 888: hr_utility.set_location('Leaving '||l_proc, 50);

884: END IF; -- End if of total unique columns is null check ...
885:
886: END IF; -- End if of multiple occurrence flag check ...
887:
888: hr_utility.set_location('Leaving '||l_proc, 50);
889: --
890: End chk_mult_occurrence;
891: --
892: --

Line 904: hr_utility.set_location('Entering:'||l_proc, 5);

900: --
901: l_proc varchar2(72) := g_package||'insert_validate';
902: --
903: Begin
904: hr_utility.set_location('Entering:'||l_proc, 5);
905: --
906: -- Call all supporting business operations
907: --
908: --

Line 933: hr_utility.set_location(l_proc, 10);

929:
930: -- Checking multiple occurrences
931: -- Bug 4150124
932:
933: hr_utility.set_location(l_proc, 10);
934:
935: chk_mult_occurrence (p_rec => p_rec);
936:
937: --

Line 953: hr_utility.set_location(' Leaving:'||l_proc, 10);

949: --pqp_pcv_bus.chk_ddf(p_rec);
950: --
951: --pqp_pcv_bus.chk_df(p_rec);
952: --
953: hr_utility.set_location(' Leaving:'||l_proc, 10);
954: End insert_validate;
955: --
956: -- ----------------------------------------------------------------------------
957: -- |---------------------------< update_validate >----------------------------|

Line 967: hr_utility.set_location('Entering:'||l_proc, 5);

963: --
964: l_proc varchar2(72) := g_package||'update_validate';
965: --
966: Begin
967: hr_utility.set_location('Entering:'||l_proc, 5);
968: --
969: -- Call all supporting business operations
970: --
971: --

Line 995: hr_utility.set_location(l_proc, 10);

991:
992: -- Checking multiple occurrences
993: -- Bug 4150124
994:
995: hr_utility.set_location(l_proc, 10);
996:
997: chk_mult_occurrence (p_rec => p_rec);
998:
999: --

Line 1020: hr_utility.set_location(' Leaving:'||l_proc, 10);

1016: --pqp_pcv_bus.chk_ddf(p_rec);
1017: --
1018: --pqp_pcv_bus.chk_df(p_rec);
1019: --
1020: hr_utility.set_location(' Leaving:'||l_proc, 10);
1021: End update_validate;
1022: --
1023: -- ----------------------------------------------------------------------------
1024: -- |---------------------------< delete_validate >----------------------------|

Line 1033: hr_utility.set_location('Entering:'||l_proc, 5);

1029: --
1030: l_proc varchar2(72) := g_package||'delete_validate';
1031: --
1032: Begin
1033: hr_utility.set_location('Entering:'||l_proc, 5);
1034: --
1035: --
1036: chk_startup_action(false
1037: ,pqp_pcv_shd.g_old_rec.business_group_id

Line 1055: hr_utility.set_location(' Leaving:'||l_proc, 10);

1051: END IF;
1052: --
1053: -- Call all supporting business operations
1054: --
1055: hr_utility.set_location(' Leaving:'||l_proc, 10);
1056: End delete_validate;
1057: end pqp_pcv_bus;