APPS.PAY_FR_ATTESTATION_ASSEDIC dependencies on HR_UTILITY

Line 190: -- hr_utility.set_location('Inside IF: Y', 30);

186: Begin
187: --Get the pension provider from 'FR_PENSION' Element Entry.
188: --G_STAT_CADRE is set in pension_category Function.
189: IF ((G_STAT_CADRE = 'Yes') OR (G_STAT_CADRE IS NULL)) THEN
190: -- hr_utility.set_location('Inside IF: Y', 30);
191: Open csr_pension_provider_id(p_assignment_id,p_establishment_id,p_type);
192: Fetch csr_pension_provider_id Into l_flag,l_pension_provider_id;
193: Close csr_pension_provider_id;
194: ELSIF ((G_STAT_CADRE = 'No') AND (p_type='ARRCO')) THEN

Line 195: -- hr_utility.set_location('Inside IF: N', 40);

191: Open csr_pension_provider_id(p_assignment_id,p_establishment_id,p_type);
192: Fetch csr_pension_provider_id Into l_flag,l_pension_provider_id;
193: Close csr_pension_provider_id;
194: ELSIF ((G_STAT_CADRE = 'No') AND (p_type='ARRCO')) THEN
195: -- hr_utility.set_location('Inside IF: N', 40);
196: Open csr_pension_provider_id(p_assignment_id,p_establishment_id,p_type);
197: Fetch csr_pension_provider_id Into l_flag,l_pension_provider_id;
198: Close csr_pension_provider_id;
199: -- hr_utility.set_location('Inside Leaving IF: N', 40);

Line 199: -- hr_utility.set_location('Inside Leaving IF: N', 40);

195: -- hr_utility.set_location('Inside IF: N', 40);
196: Open csr_pension_provider_id(p_assignment_id,p_establishment_id,p_type);
197: Fetch csr_pension_provider_id Into l_flag,l_pension_provider_id;
198: Close csr_pension_provider_id;
199: -- hr_utility.set_location('Inside Leaving IF: N', 40);
200: END IF;
201:
202:
203: --Get the Location

Line 259: --hr_utility.trace_on(Null,'ASSEDIC');

255: Into l_ovn
256: From per_periods_of_service pps
257: where period_of_service_id = g_service_id(i) ;
258: --
259: --hr_utility.trace_on(Null,'ASSEDIC');
260: hr_utility.set_location('p_effective_date='||p_effective_date,10);
261: hr_utility.set_location('period_of_service_id='||g_service_id(i),20);
262: hr_utility.set_location('ovn='||l_ovn,30);
263:

Line 260: hr_utility.set_location('p_effective_date='||p_effective_date,10);

256: From per_periods_of_service pps
257: where period_of_service_id = g_service_id(i) ;
258: --
259: --hr_utility.trace_on(Null,'ASSEDIC');
260: hr_utility.set_location('p_effective_date='||p_effective_date,10);
261: hr_utility.set_location('period_of_service_id='||g_service_id(i),20);
262: hr_utility.set_location('ovn='||l_ovn,30);
263:
264: hr_periods_of_service_api.update_pds_details(P_EFFECTIVE_DATE =>fnd_date.canonical_to_date(p_effective_date)

Line 261: hr_utility.set_location('period_of_service_id='||g_service_id(i),20);

257: where period_of_service_id = g_service_id(i) ;
258: --
259: --hr_utility.trace_on(Null,'ASSEDIC');
260: hr_utility.set_location('p_effective_date='||p_effective_date,10);
261: hr_utility.set_location('period_of_service_id='||g_service_id(i),20);
262: hr_utility.set_location('ovn='||l_ovn,30);
263:
264: hr_periods_of_service_api.update_pds_details(P_EFFECTIVE_DATE =>fnd_date.canonical_to_date(p_effective_date)
265: ,P_PERIOD_OF_SERVICE_ID =>g_service_id(i)

Line 262: hr_utility.set_location('ovn='||l_ovn,30);

258: --
259: --hr_utility.trace_on(Null,'ASSEDIC');
260: hr_utility.set_location('p_effective_date='||p_effective_date,10);
261: hr_utility.set_location('period_of_service_id='||g_service_id(i),20);
262: hr_utility.set_location('ovn='||l_ovn,30);
263:
264: hr_periods_of_service_api.update_pds_details(P_EFFECTIVE_DATE =>fnd_date.canonical_to_date(p_effective_date)
265: ,P_PERIOD_OF_SERVICE_ID =>g_service_id(i)
266: ,P_OBJECT_VERSION_NUMBER =>l_ovn