DBA Data[Home] [Help]

APPS.PAY_SID_BUS dependencies on HR_UTILITY

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

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

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

69: hr_api.set_security_group_id
70: (p_security_group_id => l_security_group_id
71: );
72: --
73: hr_utility.set_location(' Leaving:'|| l_proc, 20);
74: --
75: end set_security_group_id;
76: --
77: -- ---------------------------------------------------------------------------

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

100: l_proc varchar2(72) := g_package||'return_legislation_code';
101: --
102: Begin
103: --
104: hr_utility.set_location('Entering:'|| l_proc, 10);
105: --
106: -- Ensure that all the mandatory parameter are not null
107: --
108: hr_api.mandatory_arg_error

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

118: -- call to this function. Just return the value in the global
119: -- variable.
120: --
121: l_legislation_code := pay_sid_bus.g_legislation_code;
122: hr_utility.set_location(l_proc, 20);
123: else
124: --
125: -- The ID is different to the last call to this function
126: -- or this is the first call to this function.

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

135: close csr_leg_code;
136: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
137: fnd_message.raise_error;
138: end if;
139: hr_utility.set_location(l_proc,30);
140: --
141: -- Set the global variables so the values are
142: -- available for the next call to this function.
143: --

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

144: close csr_leg_code;
145: pay_sid_bus.g_prsi_details_id := p_prsi_details_id;
146: pay_sid_bus.g_legislation_code := l_legislation_code;
147: end if;
148: hr_utility.set_location(' Leaving:'|| l_proc, 40);
149: return l_legislation_code;
150: end return_legislation_code;
151: --
152: -- ----------------------------------------------------------------------------

Line 534: hr_utility.set_location('In Overlapping Record',103);

530:
531: --
532: prsi_details_rec csr_prsi_details%ROWTYPE;
533: BEGIN
534: hr_utility.set_location('In Overlapping Record',103);
535: OPEN csr_prsi_details;
536: FETCH csr_prsi_details INTO prsi_details_rec;
537: --
538: hr_utility.set_location('prsi_details_rec'||prsi_details_rec.min_start_date,104);

Line 538: hr_utility.set_location('prsi_details_rec'||prsi_details_rec.min_start_date,104);

534: hr_utility.set_location('In Overlapping Record',103);
535: OPEN csr_prsi_details;
536: FETCH csr_prsi_details INTO prsi_details_rec;
537: --
538: hr_utility.set_location('prsi_details_rec'||prsi_details_rec.min_start_date,104);
539: IF prsi_details_rec.min_start_date is not null THEN
540: CLOSE csr_prsi_details;
541: fnd_message.set_name('PAY', 'HR_IE_PRSI_DETAILS_EXIST');
542: fnd_message.set_token('START_DATE', to_char(prsi_details_rec.min_start_date, 'DD-MON-YYYY'));

Line 1030: -- hr_utility.trace_on(null,'VIKPRSI');

1026: --
1027: l_proc varchar2(72) := g_package||'insert_validate';
1028: --
1029: Begin
1030: -- hr_utility.trace_on(null,'VIKPRSI');
1031: hr_utility.set_location('Entering:'||l_proc, 5);
1032: --
1033: -- Call all supporting business operations
1034: --

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

1027: l_proc varchar2(72) := g_package||'insert_validate';
1028: --
1029: Begin
1030: -- hr_utility.trace_on(null,'VIKPRSI');
1031: hr_utility.set_location('Entering:'||l_proc, 5);
1032: --
1033: -- Call all supporting business operations
1034: --
1035: per_asg_bus1.set_security_group_id(p_rec.assignment_id);

Line 1066: hr_utility.set_location('p_assignment_id...'||p_rec.assignment_id,100);

1062: --
1063: pay_sid_bus.chk_community_flag(p_effective_date => p_effective_date
1064: , p_community_flag => p_rec.community_flag);
1065: --
1066: hr_utility.set_location('p_assignment_id...'||p_rec.assignment_id,100);
1067: hr_utility.set_location('p_validation_start_date...'||p_validation_start_date,101);
1068: hr_utility.set_location('p_validation_end_date...'||p_validation_end_date,102);
1069:
1070: pay_sid_bus.chk_overlapping_record(p_assignment_id => p_rec.assignment_id

Line 1067: hr_utility.set_location('p_validation_start_date...'||p_validation_start_date,101);

1063: pay_sid_bus.chk_community_flag(p_effective_date => p_effective_date
1064: , p_community_flag => p_rec.community_flag);
1065: --
1066: hr_utility.set_location('p_assignment_id...'||p_rec.assignment_id,100);
1067: hr_utility.set_location('p_validation_start_date...'||p_validation_start_date,101);
1068: hr_utility.set_location('p_validation_end_date...'||p_validation_end_date,102);
1069:
1070: pay_sid_bus.chk_overlapping_record(p_assignment_id => p_rec.assignment_id
1071: ,p_validation_start_date => p_validation_start_date

Line 1068: hr_utility.set_location('p_validation_end_date...'||p_validation_end_date,102);

1064: , p_community_flag => p_rec.community_flag);
1065: --
1066: hr_utility.set_location('p_assignment_id...'||p_rec.assignment_id,100);
1067: hr_utility.set_location('p_validation_start_date...'||p_validation_start_date,101);
1068: hr_utility.set_location('p_validation_end_date...'||p_validation_end_date,102);
1069:
1070: pay_sid_bus.chk_overlapping_record(p_assignment_id => p_rec.assignment_id
1071: ,p_validation_start_date => p_validation_start_date
1072: ,p_validation_end_date => p_validation_end_date);

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

1070: pay_sid_bus.chk_overlapping_record(p_assignment_id => p_rec.assignment_id
1071: ,p_validation_start_date => p_validation_start_date
1072: ,p_validation_end_date => p_validation_end_date);
1073:
1074: hr_utility.set_location(' Leaving:'||l_proc, 10);
1075: End insert_validate;
1076: --
1077: -- ----------------------------------------------------------------------------
1078: -- |---------------------------< update_validate >----------------------------|

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

1087: --
1088: l_proc varchar2(72) := g_package||'update_validate';
1089: --
1090: Begin
1091: hr_utility.set_location('Entering:'||l_proc, 5);
1092: --
1093: -- Call all supporting business operations
1094: --
1095: per_asg_bus1.set_security_group_id(p_rec.assignment_id);

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

1135: ,p_rec => p_rec
1136: );
1137: --
1138: --
1139: hr_utility.set_location(' Leaving:'||l_proc, 10);
1140: End update_validate;
1141: --
1142: -- ----------------------------------------------------------------------------
1143: -- |---------------------------< delete_validate >----------------------------|

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

1152: --
1153: l_proc varchar2(72) := g_package||'delete_validate';
1154: --
1155: Begin
1156: hr_utility.set_location('Entering:'||l_proc, 5);
1157: --
1158: -- Call all supporting business operations
1159: --
1160: dt_delete_validate

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

1163: ,p_validation_end_date => p_validation_end_date
1164: ,p_prsi_details_id => p_rec.prsi_details_id
1165: );
1166: --
1167: hr_utility.set_location(' Leaving:'||l_proc, 10);
1168: End delete_validate;
1169: --
1170: end pay_sid_bus;