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.CREATE_GB_RTI_EPS_RECORD dependencies on HR_UTILITY

Line 72: HR_UTILITY.TRACE(' Entered Fetch Globals ');

68: AND db.balance_type_id = b.balance_type_id
69: AND db.balance_dimension_id = d.balance_dimension_id;
70: --
71: BEGIN
72: HR_UTILITY.TRACE(' Entered Fetch Globals ');
73: OPEN c_org_details;
74: FETCH c_org_details
75: INTO g_employers_name,
76: g_econ_number,

Line 85: HR_UTILITY.TRACE(' Employer Name '||G_EMPLOYERS_NAME);

81: G_APPROVER_ID;
82: CLOSE c_org_details;
83:
84:
85: HR_UTILITY.TRACE(' Employer Name '||G_EMPLOYERS_NAME);
86: HR_UTILITY.TRACE(' Econ Number '||G_ECON_NUMBER);
87: HR_UTILITY.TRACE(' Account Office Number '||G_ACC_REF_NO);
88: HR_UTILITY.TRACE(' Service provider '||G_SERVICE_PROVIDER);
89: HR_UTILITY.TRACE(' SMP Recovery '||G_SMP_RECOVERY);

Line 86: HR_UTILITY.TRACE(' Econ Number '||G_ECON_NUMBER);

82: CLOSE c_org_details;
83:
84:
85: HR_UTILITY.TRACE(' Employer Name '||G_EMPLOYERS_NAME);
86: HR_UTILITY.TRACE(' Econ Number '||G_ECON_NUMBER);
87: HR_UTILITY.TRACE(' Account Office Number '||G_ACC_REF_NO);
88: HR_UTILITY.TRACE(' Service provider '||G_SERVICE_PROVIDER);
89: HR_UTILITY.TRACE(' SMP Recovery '||G_SMP_RECOVERY);
90: HR_UTILITY.TRACE(' SSP RECOVERY '||G_SSP_RECOVERY);

Line 87: HR_UTILITY.TRACE(' Account Office Number '||G_ACC_REF_NO);

83:
84:
85: HR_UTILITY.TRACE(' Employer Name '||G_EMPLOYERS_NAME);
86: HR_UTILITY.TRACE(' Econ Number '||G_ECON_NUMBER);
87: HR_UTILITY.TRACE(' Account Office Number '||G_ACC_REF_NO);
88: HR_UTILITY.TRACE(' Service provider '||G_SERVICE_PROVIDER);
89: HR_UTILITY.TRACE(' SMP Recovery '||G_SMP_RECOVERY);
90: HR_UTILITY.TRACE(' SSP RECOVERY '||G_SSP_RECOVERY);
91: HR_UTILITY.TRACE(' APPROVER ID '||G_APPROVER_ID);

Line 88: HR_UTILITY.TRACE(' Service provider '||G_SERVICE_PROVIDER);

84:
85: HR_UTILITY.TRACE(' Employer Name '||G_EMPLOYERS_NAME);
86: HR_UTILITY.TRACE(' Econ Number '||G_ECON_NUMBER);
87: HR_UTILITY.TRACE(' Account Office Number '||G_ACC_REF_NO);
88: HR_UTILITY.TRACE(' Service provider '||G_SERVICE_PROVIDER);
89: HR_UTILITY.TRACE(' SMP Recovery '||G_SMP_RECOVERY);
90: HR_UTILITY.TRACE(' SSP RECOVERY '||G_SSP_RECOVERY);
91: HR_UTILITY.TRACE(' APPROVER ID '||G_APPROVER_ID);
92: --13955276 Commented to handle validation in the create method

Line 89: HR_UTILITY.TRACE(' SMP Recovery '||G_SMP_RECOVERY);

85: HR_UTILITY.TRACE(' Employer Name '||G_EMPLOYERS_NAME);
86: HR_UTILITY.TRACE(' Econ Number '||G_ECON_NUMBER);
87: HR_UTILITY.TRACE(' Account Office Number '||G_ACC_REF_NO);
88: HR_UTILITY.TRACE(' Service provider '||G_SERVICE_PROVIDER);
89: HR_UTILITY.TRACE(' SMP Recovery '||G_SMP_RECOVERY);
90: HR_UTILITY.TRACE(' SSP RECOVERY '||G_SSP_RECOVERY);
91: HR_UTILITY.TRACE(' APPROVER ID '||G_APPROVER_ID);
92: --13955276 Commented to handle validation in the create method
93: --13741983 begin

Line 90: HR_UTILITY.TRACE(' SSP RECOVERY '||G_SSP_RECOVERY);

86: HR_UTILITY.TRACE(' Econ Number '||G_ECON_NUMBER);
87: HR_UTILITY.TRACE(' Account Office Number '||G_ACC_REF_NO);
88: HR_UTILITY.TRACE(' Service provider '||G_SERVICE_PROVIDER);
89: HR_UTILITY.TRACE(' SMP Recovery '||G_SMP_RECOVERY);
90: HR_UTILITY.TRACE(' SSP RECOVERY '||G_SSP_RECOVERY);
91: HR_UTILITY.TRACE(' APPROVER ID '||G_APPROVER_ID);
92: --13955276 Commented to handle validation in the create method
93: --13741983 begin
94: /*

Line 91: HR_UTILITY.TRACE(' APPROVER ID '||G_APPROVER_ID);

87: HR_UTILITY.TRACE(' Account Office Number '||G_ACC_REF_NO);
88: HR_UTILITY.TRACE(' Service provider '||G_SERVICE_PROVIDER);
89: HR_UTILITY.TRACE(' SMP Recovery '||G_SMP_RECOVERY);
90: HR_UTILITY.TRACE(' SSP RECOVERY '||G_SSP_RECOVERY);
91: HR_UTILITY.TRACE(' APPROVER ID '||G_APPROVER_ID);
92: --13955276 Commented to handle validation in the create method
93: --13741983 begin
94: /*
95: if g_employers_name = ' ' or g_employers_name is null then

Line 96: HR_UTILITY.TRACE('Error: The Employer name is missing.');

92: --13955276 Commented to handle validation in the create method
93: --13741983 begin
94: /*
95: if g_employers_name = ' ' or g_employers_name is null then
96: HR_UTILITY.TRACE('Error: The Employer name is missing.');
97: fnd_file.put_line(fnd_file.LOG,'Error: The Employer name is missing.');
98: RAISE MANDATORY_VALUES_MISSING;
99: elsif PAY_GB_RTI.validate_input(g_employers_name,'EMP_NAME') > 0 then
100: HR_UTILITY.TRACE('Error: The Employer name has invalid characters.');

Line 100: HR_UTILITY.TRACE('Error: The Employer name has invalid characters.');

96: HR_UTILITY.TRACE('Error: The Employer name is missing.');
97: fnd_file.put_line(fnd_file.LOG,'Error: The Employer name is missing.');
98: RAISE MANDATORY_VALUES_MISSING;
99: elsif PAY_GB_RTI.validate_input(g_employers_name,'EMP_NAME') > 0 then
100: HR_UTILITY.TRACE('Error: The Employer name has invalid characters.');
101: fnd_file.put_line(fnd_file.LOG,'Error: The Employer name has invalid characters.');
102: RAISE MANDATORY_VALUES_MISSING;
103: end if;
104:

Line 106: HR_UTILITY.TRACE('Error: The Account Office Reference Number is missing.');

102: RAISE MANDATORY_VALUES_MISSING;
103: end if;
104:
105: if g_acc_ref_no = ' ' or g_acc_ref_no is null then
106: HR_UTILITY.TRACE('Error: The Account Office Reference Number is missing.');
107: fnd_file.put_line(fnd_file.LOG,'Error: The Account Office Reference Number is missing.');
108: RAISE MANDATORY_VALUES_MISSING;
109: elsif (length(g_acc_ref_no) > 13
110: OR REGEXP_INSTR(g_acc_ref_no,'^([[:digit:]]{1,3})P([[:alpha:]]{1})([[:digit:]]{1,7})([[:digit:]]|X)$') = 0 ) THEN

Line 111: HR_UTILITY.TRACE('Error: Incorrect format entered for Accounts Office Ref Num field. Valid format is NNNPANNNNNNNX.');

107: fnd_file.put_line(fnd_file.LOG,'Error: The Account Office Reference Number is missing.');
108: RAISE MANDATORY_VALUES_MISSING;
109: elsif (length(g_acc_ref_no) > 13
110: OR REGEXP_INSTR(g_acc_ref_no,'^([[:digit:]]{1,3})P([[:alpha:]]{1})([[:digit:]]{1,7})([[:digit:]]|X)$') = 0 ) THEN
111: HR_UTILITY.TRACE('Error: Incorrect format entered for Accounts Office Ref Num field. Valid format is NNNPANNNNNNNX.');
112: fnd_file.put_line(fnd_file.LOG,'Error: Incorrect format entered for Accounts Office Ref Num field. Valid format is NNNPANNNNNNNX.');
113: RAISE MANDATORY_VALUES_MISSING;
114: end if;
115: --13741983 End

Line 126: HR_UTILITY.TRACE(' SMP_RECOVERY_PERCENTAGE '||G_SMP_SAP_RATE);

122: RAISE GLOBAL_MISSING;
123: END IF;
124: CLOSE C_GLOBALS;
125:
126: HR_UTILITY.TRACE(' SMP_RECOVERY_PERCENTAGE '||G_SMP_SAP_RATE);
127: HR_UTILITY.TRACE(' SSP_RECOVERY_PERCENTAGE '||G_SSP_RATE);
128: HR_UTILITY.TRACE(' NIC_COMPENSATION_RATE_ON_SMP '||G_NIC_RATE);
129:
130: --

Line 127: HR_UTILITY.TRACE(' SSP_RECOVERY_PERCENTAGE '||G_SSP_RATE);

123: END IF;
124: CLOSE C_GLOBALS;
125:
126: HR_UTILITY.TRACE(' SMP_RECOVERY_PERCENTAGE '||G_SMP_SAP_RATE);
127: HR_UTILITY.TRACE(' SSP_RECOVERY_PERCENTAGE '||G_SSP_RATE);
128: HR_UTILITY.TRACE(' NIC_COMPENSATION_RATE_ON_SMP '||G_NIC_RATE);
129:
130: --
131: OPEN get_defined_balance_id('SSP Total','_ASG_TD_YTD');

Line 128: HR_UTILITY.TRACE(' NIC_COMPENSATION_RATE_ON_SMP '||G_NIC_RATE);

124: CLOSE C_GLOBALS;
125:
126: HR_UTILITY.TRACE(' SMP_RECOVERY_PERCENTAGE '||G_SMP_SAP_RATE);
127: HR_UTILITY.TRACE(' SSP_RECOVERY_PERCENTAGE '||G_SSP_RATE);
128: HR_UTILITY.TRACE(' NIC_COMPENSATION_RATE_ON_SMP '||G_NIC_RATE);
129:
130: --
131: OPEN get_defined_balance_id('SSP Total','_ASG_TD_YTD');
132: FETCH get_defined_balance_id INTO g_ssp_id;

Line 241: -- HR_UTILITY.TRACE_ON(NULL,'gag');

237:
238: l_request_rec csr_get_request_details%rowtype;
239:
240: BEGIN
241: -- HR_UTILITY.TRACE_ON(NULL,'gag');
242: HR_UTILITY.TRACE('Create_EPS_RECORD Started '||to_char(sysdate,'dd-mon-yyyy hh24:mm:ss'));
243: G_PAYE_REFERENCE := P_PAYE_REFERENCE;
244: g_business_group_id := p_business_group_id;
245: HR_UTILITY.TRACE(' Eff Date: '||P_EFFECTIVE_DT);

Line 242: HR_UTILITY.TRACE('Create_EPS_RECORD Started '||to_char(sysdate,'dd-mon-yyyy hh24:mm:ss'));

238: l_request_rec csr_get_request_details%rowtype;
239:
240: BEGIN
241: -- HR_UTILITY.TRACE_ON(NULL,'gag');
242: HR_UTILITY.TRACE('Create_EPS_RECORD Started '||to_char(sysdate,'dd-mon-yyyy hh24:mm:ss'));
243: G_PAYE_REFERENCE := P_PAYE_REFERENCE;
244: g_business_group_id := p_business_group_id;
245: HR_UTILITY.TRACE(' Eff Date: '||P_EFFECTIVE_DT);
246: HR_UTILITY.TRACE(' PAYE ref :'||P_PAYE_REFERENCE);

Line 245: HR_UTILITY.TRACE(' Eff Date: '||P_EFFECTIVE_DT);

241: -- HR_UTILITY.TRACE_ON(NULL,'gag');
242: HR_UTILITY.TRACE('Create_EPS_RECORD Started '||to_char(sysdate,'dd-mon-yyyy hh24:mm:ss'));
243: G_PAYE_REFERENCE := P_PAYE_REFERENCE;
244: g_business_group_id := p_business_group_id;
245: HR_UTILITY.TRACE(' Eff Date: '||P_EFFECTIVE_DT);
246: HR_UTILITY.TRACE(' PAYE ref :'||P_PAYE_REFERENCE);
247: HR_UTILITY.TRACE(' Business group id '||p_business_group_id);
248: L_EFF_START_DATE := FND_DATE.CANONICAL_TO_DATE(P_EFFECTIVE_DT);
249: HR_UTILITY.TRACE(' Eff Date: '||L_EFF_START_DATE);

Line 246: HR_UTILITY.TRACE(' PAYE ref :'||P_PAYE_REFERENCE);

242: HR_UTILITY.TRACE('Create_EPS_RECORD Started '||to_char(sysdate,'dd-mon-yyyy hh24:mm:ss'));
243: G_PAYE_REFERENCE := P_PAYE_REFERENCE;
244: g_business_group_id := p_business_group_id;
245: HR_UTILITY.TRACE(' Eff Date: '||P_EFFECTIVE_DT);
246: HR_UTILITY.TRACE(' PAYE ref :'||P_PAYE_REFERENCE);
247: HR_UTILITY.TRACE(' Business group id '||p_business_group_id);
248: L_EFF_START_DATE := FND_DATE.CANONICAL_TO_DATE(P_EFFECTIVE_DT);
249: HR_UTILITY.TRACE(' Eff Date: '||L_EFF_START_DATE);
250: IF L_EFF_START_DATE >= to_date('06-04-'||SUBSTR(TO_CHAR(l_eff_start_date,'YYYY/MON/DD'),1,4),'DD-MM-YYYY' ) THEN

Line 247: HR_UTILITY.TRACE(' Business group id '||p_business_group_id);

243: G_PAYE_REFERENCE := P_PAYE_REFERENCE;
244: g_business_group_id := p_business_group_id;
245: HR_UTILITY.TRACE(' Eff Date: '||P_EFFECTIVE_DT);
246: HR_UTILITY.TRACE(' PAYE ref :'||P_PAYE_REFERENCE);
247: HR_UTILITY.TRACE(' Business group id '||p_business_group_id);
248: L_EFF_START_DATE := FND_DATE.CANONICAL_TO_DATE(P_EFFECTIVE_DT);
249: HR_UTILITY.TRACE(' Eff Date: '||L_EFF_START_DATE);
250: IF L_EFF_START_DATE >= to_date('06-04-'||SUBSTR(TO_CHAR(l_eff_start_date,'YYYY/MON/DD'),1,4),'DD-MM-YYYY' ) THEN
251: l_date_soy := to_date('06-04-'||SUBSTR(TO_CHAR(l_eff_start_date,'YYYY/MON/DD'),1,4),'DD-MM-YYYY' ) ;

Line 249: HR_UTILITY.TRACE(' Eff Date: '||L_EFF_START_DATE);

245: HR_UTILITY.TRACE(' Eff Date: '||P_EFFECTIVE_DT);
246: HR_UTILITY.TRACE(' PAYE ref :'||P_PAYE_REFERENCE);
247: HR_UTILITY.TRACE(' Business group id '||p_business_group_id);
248: L_EFF_START_DATE := FND_DATE.CANONICAL_TO_DATE(P_EFFECTIVE_DT);
249: HR_UTILITY.TRACE(' Eff Date: '||L_EFF_START_DATE);
250: IF L_EFF_START_DATE >= to_date('06-04-'||SUBSTR(TO_CHAR(l_eff_start_date,'YYYY/MON/DD'),1,4),'DD-MM-YYYY' ) THEN
251: l_date_soy := to_date('06-04-'||SUBSTR(TO_CHAR(l_eff_start_date,'YYYY/MON/DD'),1,4),'DD-MM-YYYY' ) ;
252: l_date_eoy := to_date('05-04-'||TO_CHAR(to_number(SUBSTR(TO_CHAR(l_eff_start_date,'YYYY/MON/DD'),1,4))+1 ),'DD-MM-YYYY') ;
253: ELSE

Line 272: HR_UTILITY.TRACE(' CREATER_ID '||L_CREATER_ID);

268: G_RELATED_TAX_YEAR := TO_CHAR(L_DATE_EOY,'YYYY');
269: -- L_CREATER_ID := FND_GLOBAL.USER_ID;
270: select EMPLOYEE_ID INTO L_CREATER_ID FRom FND_USER
271: WHERE USER_ID = FND_GLOBAL.USER_ID;
272: HR_UTILITY.TRACE(' CREATER_ID '||L_CREATER_ID);
273: l_nic_ssp_rate := G_NIC_RATE;
274: L_NIC_SMP_RATE := G_NIC_RATE;
275: IF g_ssp_recovery = 'None' THEN
276: --No need to calculate SSP balances

Line 318: hr_utility.trace(' Total SSP '||l_ssp);

314: l_spp_birth := l_spp_birth * g_smp_sap_rate;
315: l_aspp_adopt := l_aspp_adopt * g_smp_sap_rate;
316: l_aspp_birth := l_aspp_birth * g_smp_sap_rate;
317: END IF;
318: hr_utility.trace(' Total SSP '||l_ssp);
319: hr_utility.trace(' Total SMP '||l_smp);
320: hr_utility.trace(' Total SAP '||l_sap);
321: hr_utility.trace(' Total OSPPA '||l_spp_adopt);
322: hr_utility.trace(' Total OSPPB '||l_spp_birth);

Line 319: hr_utility.trace(' Total SMP '||l_smp);

315: l_aspp_adopt := l_aspp_adopt * g_smp_sap_rate;
316: l_aspp_birth := l_aspp_birth * g_smp_sap_rate;
317: END IF;
318: hr_utility.trace(' Total SSP '||l_ssp);
319: hr_utility.trace(' Total SMP '||l_smp);
320: hr_utility.trace(' Total SAP '||l_sap);
321: hr_utility.trace(' Total OSPPA '||l_spp_adopt);
322: hr_utility.trace(' Total OSPPB '||l_spp_birth);
323: hr_utility.trace(' Total ASPPA '||l_aspp_adopt);

Line 320: hr_utility.trace(' Total SAP '||l_sap);

316: l_aspp_birth := l_aspp_birth * g_smp_sap_rate;
317: END IF;
318: hr_utility.trace(' Total SSP '||l_ssp);
319: hr_utility.trace(' Total SMP '||l_smp);
320: hr_utility.trace(' Total SAP '||l_sap);
321: hr_utility.trace(' Total OSPPA '||l_spp_adopt);
322: hr_utility.trace(' Total OSPPB '||l_spp_birth);
323: hr_utility.trace(' Total ASPPA '||l_aspp_adopt);
324: hr_utility.trace(' Total ASPPB '||l_aspp_birth);

Line 321: hr_utility.trace(' Total OSPPA '||l_spp_adopt);

317: END IF;
318: hr_utility.trace(' Total SSP '||l_ssp);
319: hr_utility.trace(' Total SMP '||l_smp);
320: hr_utility.trace(' Total SAP '||l_sap);
321: hr_utility.trace(' Total OSPPA '||l_spp_adopt);
322: hr_utility.trace(' Total OSPPB '||l_spp_birth);
323: hr_utility.trace(' Total ASPPA '||l_aspp_adopt);
324: hr_utility.trace(' Total ASPPB '||l_aspp_birth);
325: l_spp := l_spp_adopt + l_spp_birth;

Line 322: hr_utility.trace(' Total OSPPB '||l_spp_birth);

318: hr_utility.trace(' Total SSP '||l_ssp);
319: hr_utility.trace(' Total SMP '||l_smp);
320: hr_utility.trace(' Total SAP '||l_sap);
321: hr_utility.trace(' Total OSPPA '||l_spp_adopt);
322: hr_utility.trace(' Total OSPPB '||l_spp_birth);
323: hr_utility.trace(' Total ASPPA '||l_aspp_adopt);
324: hr_utility.trace(' Total ASPPB '||l_aspp_birth);
325: l_spp := l_spp_adopt + l_spp_birth;
326: l_aspp := l_aspp_adopt + l_aspp_birth;

Line 323: hr_utility.trace(' Total ASPPA '||l_aspp_adopt);

319: hr_utility.trace(' Total SMP '||l_smp);
320: hr_utility.trace(' Total SAP '||l_sap);
321: hr_utility.trace(' Total OSPPA '||l_spp_adopt);
322: hr_utility.trace(' Total OSPPB '||l_spp_birth);
323: hr_utility.trace(' Total ASPPA '||l_aspp_adopt);
324: hr_utility.trace(' Total ASPPB '||l_aspp_birth);
325: l_spp := l_spp_adopt + l_spp_birth;
326: l_aspp := l_aspp_adopt + l_aspp_birth;
327: hr_utility.trace(' Total OSPP '||l_spp);

Line 324: hr_utility.trace(' Total ASPPB '||l_aspp_birth);

320: hr_utility.trace(' Total SAP '||l_sap);
321: hr_utility.trace(' Total OSPPA '||l_spp_adopt);
322: hr_utility.trace(' Total OSPPB '||l_spp_birth);
323: hr_utility.trace(' Total ASPPA '||l_aspp_adopt);
324: hr_utility.trace(' Total ASPPB '||l_aspp_birth);
325: l_spp := l_spp_adopt + l_spp_birth;
326: l_aspp := l_aspp_adopt + l_aspp_birth;
327: hr_utility.trace(' Total OSPP '||l_spp);
328: hr_utility.trace(' Total ASPP '||l_aspp);

Line 327: hr_utility.trace(' Total OSPP '||l_spp);

323: hr_utility.trace(' Total ASPPA '||l_aspp_adopt);
324: hr_utility.trace(' Total ASPPB '||l_aspp_birth);
325: l_spp := l_spp_adopt + l_spp_birth;
326: l_aspp := l_aspp_adopt + l_aspp_birth;
327: hr_utility.trace(' Total OSPP '||l_spp);
328: hr_utility.trace(' Total ASPP '||l_aspp);
329: hr_utility.trace(' NIC SSP Rate '||l_nic_ssp_rate);
330: hr_utility.trace(' NIC SMP Rate '||l_nic_smp_rate);
331: --NIC calculations

Line 328: hr_utility.trace(' Total ASPP '||l_aspp);

324: hr_utility.trace(' Total ASPPB '||l_aspp_birth);
325: l_spp := l_spp_adopt + l_spp_birth;
326: l_aspp := l_aspp_adopt + l_aspp_birth;
327: hr_utility.trace(' Total OSPP '||l_spp);
328: hr_utility.trace(' Total ASPP '||l_aspp);
329: hr_utility.trace(' NIC SSP Rate '||l_nic_ssp_rate);
330: hr_utility.trace(' NIC SMP Rate '||l_nic_smp_rate);
331: --NIC calculations
332: l_nic_ssp := l_ssp * l_nic_ssp_rate;

Line 329: hr_utility.trace(' NIC SSP Rate '||l_nic_ssp_rate);

325: l_spp := l_spp_adopt + l_spp_birth;
326: l_aspp := l_aspp_adopt + l_aspp_birth;
327: hr_utility.trace(' Total OSPP '||l_spp);
328: hr_utility.trace(' Total ASPP '||l_aspp);
329: hr_utility.trace(' NIC SSP Rate '||l_nic_ssp_rate);
330: hr_utility.trace(' NIC SMP Rate '||l_nic_smp_rate);
331: --NIC calculations
332: l_nic_ssp := l_ssp * l_nic_ssp_rate;
333: l_nic_smp := l_smp * l_nic_smp_rate;

Line 330: hr_utility.trace(' NIC SMP Rate '||l_nic_smp_rate);

326: l_aspp := l_aspp_adopt + l_aspp_birth;
327: hr_utility.trace(' Total OSPP '||l_spp);
328: hr_utility.trace(' Total ASPP '||l_aspp);
329: hr_utility.trace(' NIC SSP Rate '||l_nic_ssp_rate);
330: hr_utility.trace(' NIC SMP Rate '||l_nic_smp_rate);
331: --NIC calculations
332: l_nic_ssp := l_ssp * l_nic_ssp_rate;
333: l_nic_smp := l_smp * l_nic_smp_rate;
334: l_nic_sap := l_sap * l_nic_smp_rate;

Line 337: hr_utility.trace(' NIC SSP '||l_nic_ssp);

333: l_nic_smp := l_smp * l_nic_smp_rate;
334: l_nic_sap := l_sap * l_nic_smp_rate;
335: l_nic_spp := l_spp * l_nic_smp_rate;
336: l_nic_aspp := l_aspp * l_nic_smp_rate;
337: hr_utility.trace(' NIC SSP '||l_nic_ssp);
338: hr_utility.trace(' NIC SMP '||l_nic_smp);
339: hr_utility.trace(' NIC SAP '||l_nic_sap);
340: hr_utility.trace(' NIC OSPP '||l_nic_spp);
341: HR_UTILITY.TRACE(' NIC ASPP '||L_NIC_ASPP);

Line 338: hr_utility.trace(' NIC SMP '||l_nic_smp);

334: l_nic_sap := l_sap * l_nic_smp_rate;
335: l_nic_spp := l_spp * l_nic_smp_rate;
336: l_nic_aspp := l_aspp * l_nic_smp_rate;
337: hr_utility.trace(' NIC SSP '||l_nic_ssp);
338: hr_utility.trace(' NIC SMP '||l_nic_smp);
339: hr_utility.trace(' NIC SAP '||l_nic_sap);
340: hr_utility.trace(' NIC OSPP '||l_nic_spp);
341: HR_UTILITY.TRACE(' NIC ASPP '||L_NIC_ASPP);
342:

Line 339: hr_utility.trace(' NIC SAP '||l_nic_sap);

335: l_nic_spp := l_spp * l_nic_smp_rate;
336: l_nic_aspp := l_aspp * l_nic_smp_rate;
337: hr_utility.trace(' NIC SSP '||l_nic_ssp);
338: hr_utility.trace(' NIC SMP '||l_nic_smp);
339: hr_utility.trace(' NIC SAP '||l_nic_sap);
340: hr_utility.trace(' NIC OSPP '||l_nic_spp);
341: HR_UTILITY.TRACE(' NIC ASPP '||L_NIC_ASPP);
342:
343: open csr_get_request_details;

Line 340: hr_utility.trace(' NIC OSPP '||l_nic_spp);

336: l_nic_aspp := l_aspp * l_nic_smp_rate;
337: hr_utility.trace(' NIC SSP '||l_nic_ssp);
338: hr_utility.trace(' NIC SMP '||l_nic_smp);
339: hr_utility.trace(' NIC SAP '||l_nic_sap);
340: hr_utility.trace(' NIC OSPP '||l_nic_spp);
341: HR_UTILITY.TRACE(' NIC ASPP '||L_NIC_ASPP);
342:
343: open csr_get_request_details;
344: fetch csr_get_request_details into l_request_rec;

Line 341: HR_UTILITY.TRACE(' NIC ASPP '||L_NIC_ASPP);

337: hr_utility.trace(' NIC SSP '||l_nic_ssp);
338: hr_utility.trace(' NIC SMP '||l_nic_smp);
339: hr_utility.trace(' NIC SAP '||l_nic_sap);
340: hr_utility.trace(' NIC OSPP '||l_nic_spp);
341: HR_UTILITY.TRACE(' NIC ASPP '||L_NIC_ASPP);
342:
343: open csr_get_request_details;
344: fetch csr_get_request_details into l_request_rec;
345: close csr_get_request_details;

Line 353: HR_UTILITY.TRACE(' EPS record insert complete ');

349: l_smp/100, l_sap/100, l_spp/100, l_aspp/100, l_ssp/100, L_NIC_SMP/100, l_nic_sap/100, l_nic_spp/100, l_nic_aspp/100, L_NIC_SSP/100, 'Saved', L_CREATER_ID, G_APPROVER_ID ,
350: FND_GLOBAL.CONC_REQUEST_ID,l_request_rec.PROGRAM_APPLICATION_ID,l_request_rec.CONCURRENT_PROGRAM_ID,l_request_rec.LAST_UPDATE_DATE);
351:
352:
353: HR_UTILITY.TRACE(' EPS record insert complete ');
354: --Write Output Information
355: l_msg_output:= ' RTI - Employer Payment Summary - Created ';
356: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
357: L_MSG_OUTPUT:= ' ';

Line 394: HR_UTILITY.TRACE('Create_EPS_RECORD completed '||to_char(sysdate,'dd-mon-yyyy hh24:mm:ss'));

390: L_MSG_OUTPUT:= 'ASPP Amount Recovered : '||rpad(to_char(L_ASPP/100,'FM9999999990D00'),30,' ')||' NIC Compensation on ASPP : '||to_char(L_NIC_ASPP/100,'FM9999999990D00');
391: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
392: L_MSG_OUTPUT:= 'SSP Amount Recovered : '||rpad(to_char(L_SSP/100,'FM9999999990D00'),30,' ')||' NIC Compensation on SSP : '||to_char(L_NIC_SSP/100,'FM9999999990D00');
393: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
394: HR_UTILITY.TRACE('Create_EPS_RECORD completed '||to_char(sysdate,'dd-mon-yyyy hh24:mm:ss'));
395: END IF;
396: EXCEPTION
397: --13741983 begin
398: WHEN MANDATORY_VALUES_MISSING THEN

Line 399: hr_utility.trace('Error: Mandatory values required for processing EPS are not present. Please check ');

395: END IF;
396: EXCEPTION
397: --13741983 begin
398: WHEN MANDATORY_VALUES_MISSING THEN
399: hr_utility.trace('Error: Mandatory values required for processing EPS are not present. Please check ');
400: raise_application_error(-20001,' Mandatory Values missing');
401: --13741983 end
402: WHEN Global_missing THEN
403: hr_utility.trace('Error: The globals required for processing EPS are not present. Please check ');

Line 403: hr_utility.trace('Error: The globals required for processing EPS are not present. Please check ');

399: hr_utility.trace('Error: Mandatory values required for processing EPS are not present. Please check ');
400: raise_application_error(-20001,' Mandatory Values missing');
401: --13741983 end
402: WHEN Global_missing THEN
403: hr_utility.trace('Error: The globals required for processing EPS are not present. Please check ');
404: l_msg_output := 'Error: The globals required for processing EPS are not present. Please check ';
405: fnd_file.put_line(fnd_file.log,l_msg_output);
406: raise_application_error(-20001,' Globals missing');
407: WHEN EPS_ALREADY_PRESENT THEN

Line 409: hr_utility.trace('EPS record already created for the given parameters. Please check ');

405: fnd_file.put_line(fnd_file.log,l_msg_output);
406: raise_application_error(-20001,' Globals missing');
407: WHEN EPS_ALREADY_PRESENT THEN
408: l_msg_output:= 'EPS record already created for the given parameters. Please check ';
409: hr_utility.trace('EPS record already created for the given parameters. Please check ');
410: fnd_file.put_line(fnd_file.log,l_msg_output);
411: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,L_MSG_OUTPUT);
412: raise_application_error(-20001,' EPS record already created for the given parameters. Please check');
413: WHEN OTHERS THEN