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

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

77: AND db.balance_type_id = b.balance_type_id
78: AND db.balance_dimension_id = d.balance_dimension_id;
79: --
80: BEGIN
81: HR_UTILITY.TRACE(' Entered Fetch Globals ');
82: OPEN c_org_details;
83: FETCH c_org_details
84: INTO g_employers_name,
85: g_econ_number,

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

90: G_APPROVER_ID;
91: CLOSE c_org_details;
92:
93:
94: HR_UTILITY.TRACE(' Employer Name '||G_EMPLOYERS_NAME);
95: HR_UTILITY.TRACE(' Econ Number '||G_ECON_NUMBER);
96: HR_UTILITY.TRACE(' Account Office Number '||G_ACC_REF_NO);
97: HR_UTILITY.TRACE(' Service provider '||G_SERVICE_PROVIDER);
98: HR_UTILITY.TRACE(' SMP Recovery '||G_SMP_RECOVERY);

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

91: CLOSE c_org_details;
92:
93:
94: HR_UTILITY.TRACE(' Employer Name '||G_EMPLOYERS_NAME);
95: HR_UTILITY.TRACE(' Econ Number '||G_ECON_NUMBER);
96: HR_UTILITY.TRACE(' Account Office Number '||G_ACC_REF_NO);
97: HR_UTILITY.TRACE(' Service provider '||G_SERVICE_PROVIDER);
98: HR_UTILITY.TRACE(' SMP Recovery '||G_SMP_RECOVERY);
99: HR_UTILITY.TRACE(' SSP RECOVERY '||G_SSP_RECOVERY);

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

92:
93:
94: HR_UTILITY.TRACE(' Employer Name '||G_EMPLOYERS_NAME);
95: HR_UTILITY.TRACE(' Econ Number '||G_ECON_NUMBER);
96: HR_UTILITY.TRACE(' Account Office Number '||G_ACC_REF_NO);
97: HR_UTILITY.TRACE(' Service provider '||G_SERVICE_PROVIDER);
98: HR_UTILITY.TRACE(' SMP Recovery '||G_SMP_RECOVERY);
99: HR_UTILITY.TRACE(' SSP RECOVERY '||G_SSP_RECOVERY);
100: HR_UTILITY.TRACE(' APPROVER ID '||G_APPROVER_ID);

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

93:
94: HR_UTILITY.TRACE(' Employer Name '||G_EMPLOYERS_NAME);
95: HR_UTILITY.TRACE(' Econ Number '||G_ECON_NUMBER);
96: HR_UTILITY.TRACE(' Account Office Number '||G_ACC_REF_NO);
97: HR_UTILITY.TRACE(' Service provider '||G_SERVICE_PROVIDER);
98: HR_UTILITY.TRACE(' SMP Recovery '||G_SMP_RECOVERY);
99: HR_UTILITY.TRACE(' SSP RECOVERY '||G_SSP_RECOVERY);
100: HR_UTILITY.TRACE(' APPROVER ID '||G_APPROVER_ID);
101: --13955276 Commented to handle validation in the create method

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

94: HR_UTILITY.TRACE(' Employer Name '||G_EMPLOYERS_NAME);
95: HR_UTILITY.TRACE(' Econ Number '||G_ECON_NUMBER);
96: HR_UTILITY.TRACE(' Account Office Number '||G_ACC_REF_NO);
97: HR_UTILITY.TRACE(' Service provider '||G_SERVICE_PROVIDER);
98: HR_UTILITY.TRACE(' SMP Recovery '||G_SMP_RECOVERY);
99: HR_UTILITY.TRACE(' SSP RECOVERY '||G_SSP_RECOVERY);
100: HR_UTILITY.TRACE(' APPROVER ID '||G_APPROVER_ID);
101: --13955276 Commented to handle validation in the create method
102: --13741983 begin

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

95: HR_UTILITY.TRACE(' Econ Number '||G_ECON_NUMBER);
96: HR_UTILITY.TRACE(' Account Office Number '||G_ACC_REF_NO);
97: HR_UTILITY.TRACE(' Service provider '||G_SERVICE_PROVIDER);
98: HR_UTILITY.TRACE(' SMP Recovery '||G_SMP_RECOVERY);
99: HR_UTILITY.TRACE(' SSP RECOVERY '||G_SSP_RECOVERY);
100: HR_UTILITY.TRACE(' APPROVER ID '||G_APPROVER_ID);
101: --13955276 Commented to handle validation in the create method
102: --13741983 begin
103: /*

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

96: HR_UTILITY.TRACE(' Account Office Number '||G_ACC_REF_NO);
97: HR_UTILITY.TRACE(' Service provider '||G_SERVICE_PROVIDER);
98: HR_UTILITY.TRACE(' SMP Recovery '||G_SMP_RECOVERY);
99: HR_UTILITY.TRACE(' SSP RECOVERY '||G_SSP_RECOVERY);
100: HR_UTILITY.TRACE(' APPROVER ID '||G_APPROVER_ID);
101: --13955276 Commented to handle validation in the create method
102: --13741983 begin
103: /*
104: if g_employers_name = ' ' or g_employers_name is null then

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

101: --13955276 Commented to handle validation in the create method
102: --13741983 begin
103: /*
104: if g_employers_name = ' ' or g_employers_name is null then
105: HR_UTILITY.TRACE('Error: The Employer name is missing.');
106: fnd_file.put_line(fnd_file.LOG,'Error: The Employer name is missing.');
107: RAISE MANDATORY_VALUES_MISSING;
108: elsif PAY_GB_RTI.validate_input(g_employers_name,'EMP_NAME') > 0 then
109: HR_UTILITY.TRACE('Error: The Employer name has invalid characters.');

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

105: HR_UTILITY.TRACE('Error: The Employer name is missing.');
106: fnd_file.put_line(fnd_file.LOG,'Error: The Employer name is missing.');
107: RAISE MANDATORY_VALUES_MISSING;
108: elsif PAY_GB_RTI.validate_input(g_employers_name,'EMP_NAME') > 0 then
109: HR_UTILITY.TRACE('Error: The Employer name has invalid characters.');
110: fnd_file.put_line(fnd_file.LOG,'Error: The Employer name has invalid characters.');
111: RAISE MANDATORY_VALUES_MISSING;
112: end if;
113:

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

111: RAISE MANDATORY_VALUES_MISSING;
112: end if;
113:
114: if g_acc_ref_no = ' ' or g_acc_ref_no is null then
115: HR_UTILITY.TRACE('Error: The Account Office Reference Number is missing.');
116: fnd_file.put_line(fnd_file.LOG,'Error: The Account Office Reference Number is missing.');
117: RAISE MANDATORY_VALUES_MISSING;
118: elsif (length(g_acc_ref_no) > 13
119: OR REGEXP_INSTR(g_acc_ref_no,'^([[:digit:]]{1,3})P([[:alpha:]]{1})([[:digit:]]{1,7})([[:digit:]]|X)$') = 0 ) THEN

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

116: fnd_file.put_line(fnd_file.LOG,'Error: The Account Office Reference Number is missing.');
117: RAISE MANDATORY_VALUES_MISSING;
118: elsif (length(g_acc_ref_no) > 13
119: OR REGEXP_INSTR(g_acc_ref_no,'^([[:digit:]]{1,3})P([[:alpha:]]{1})([[:digit:]]{1,7})([[:digit:]]|X)$') = 0 ) THEN
120: HR_UTILITY.TRACE('Error: Incorrect format entered for Accounts Office Ref Num field. Valid format is NNNPANNNNNNNX.');
121: fnd_file.put_line(fnd_file.LOG,'Error: Incorrect format entered for Accounts Office Ref Num field. Valid format is NNNPANNNNNNNX.');
122: RAISE MANDATORY_VALUES_MISSING;
123: end if;
124: --13741983 End

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

141: IF G_SSP_RECOVERY = 'None' THEN
142: G_SSP_RATE := 0;
143: END IF;
144:
145: HR_UTILITY.TRACE(' SMP_RECOVERY_PERCENTAGE '||G_SMP_SAP_RATE);
146: HR_UTILITY.TRACE(' SSP_RECOVERY_PERCENTAGE '||G_SSP_RATE);
147: HR_UTILITY.TRACE(' NIC_COMPENSATION_RATE_ON_SMP '||G_NIC_RATE);
148:
149: /*

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

142: G_SSP_RATE := 0;
143: END IF;
144:
145: HR_UTILITY.TRACE(' SMP_RECOVERY_PERCENTAGE '||G_SMP_SAP_RATE);
146: HR_UTILITY.TRACE(' SSP_RECOVERY_PERCENTAGE '||G_SSP_RATE);
147: HR_UTILITY.TRACE(' NIC_COMPENSATION_RATE_ON_SMP '||G_NIC_RATE);
148:
149: /*
150: --

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

143: END IF;
144:
145: HR_UTILITY.TRACE(' SMP_RECOVERY_PERCENTAGE '||G_SMP_SAP_RATE);
146: HR_UTILITY.TRACE(' SSP_RECOVERY_PERCENTAGE '||G_SSP_RATE);
147: HR_UTILITY.TRACE(' NIC_COMPENSATION_RATE_ON_SMP '||G_NIC_RATE);
148:
149: /*
150: --
151: OPEN get_defined_balance_id('SSP Total','_ASG_TD_YTD');

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

322:
323: l_request_rec csr_get_request_details%rowtype;
324:
325: BEGIN
326: -- HR_UTILITY.TRACE_ON(NULL,'gag');
327: HR_UTILITY.TRACE('Create_EPS_RECORD Started '||to_char(sysdate,'dd-mon-yyyy hh24:mm:ss'));
328: G_PAYE_REFERENCE := P_PAYE_REFERENCE;
329: g_business_group_id := p_business_group_id;
330: HR_UTILITY.TRACE(' Eff Date: '||P_EFFECTIVE_DT);

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

323: l_request_rec csr_get_request_details%rowtype;
324:
325: BEGIN
326: -- HR_UTILITY.TRACE_ON(NULL,'gag');
327: HR_UTILITY.TRACE('Create_EPS_RECORD Started '||to_char(sysdate,'dd-mon-yyyy hh24:mm:ss'));
328: G_PAYE_REFERENCE := P_PAYE_REFERENCE;
329: g_business_group_id := p_business_group_id;
330: HR_UTILITY.TRACE(' Eff Date: '||P_EFFECTIVE_DT);
331: HR_UTILITY.TRACE(' PAYE ref :'||P_PAYE_REFERENCE);

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

326: -- HR_UTILITY.TRACE_ON(NULL,'gag');
327: HR_UTILITY.TRACE('Create_EPS_RECORD Started '||to_char(sysdate,'dd-mon-yyyy hh24:mm:ss'));
328: G_PAYE_REFERENCE := P_PAYE_REFERENCE;
329: g_business_group_id := p_business_group_id;
330: HR_UTILITY.TRACE(' Eff Date: '||P_EFFECTIVE_DT);
331: HR_UTILITY.TRACE(' PAYE ref :'||P_PAYE_REFERENCE);
332: HR_UTILITY.TRACE(' Business group id '||p_business_group_id);
333: L_EFF_START_DATE := FND_DATE.CANONICAL_TO_DATE(P_EFFECTIVE_DT);
334: HR_UTILITY.TRACE(' Eff Date: '||L_EFF_START_DATE);

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

327: HR_UTILITY.TRACE('Create_EPS_RECORD Started '||to_char(sysdate,'dd-mon-yyyy hh24:mm:ss'));
328: G_PAYE_REFERENCE := P_PAYE_REFERENCE;
329: g_business_group_id := p_business_group_id;
330: HR_UTILITY.TRACE(' Eff Date: '||P_EFFECTIVE_DT);
331: HR_UTILITY.TRACE(' PAYE ref :'||P_PAYE_REFERENCE);
332: HR_UTILITY.TRACE(' Business group id '||p_business_group_id);
333: L_EFF_START_DATE := FND_DATE.CANONICAL_TO_DATE(P_EFFECTIVE_DT);
334: HR_UTILITY.TRACE(' Eff Date: '||L_EFF_START_DATE);
335: 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 332: HR_UTILITY.TRACE(' Business group id '||p_business_group_id);

328: G_PAYE_REFERENCE := P_PAYE_REFERENCE;
329: g_business_group_id := p_business_group_id;
330: HR_UTILITY.TRACE(' Eff Date: '||P_EFFECTIVE_DT);
331: HR_UTILITY.TRACE(' PAYE ref :'||P_PAYE_REFERENCE);
332: HR_UTILITY.TRACE(' Business group id '||p_business_group_id);
333: L_EFF_START_DATE := FND_DATE.CANONICAL_TO_DATE(P_EFFECTIVE_DT);
334: HR_UTILITY.TRACE(' Eff Date: '||L_EFF_START_DATE);
335: 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
336: l_date_soy := to_date('06-04-'||SUBSTR(TO_CHAR(l_eff_start_date,'YYYY/MON/DD'),1,4),'DD-MM-YYYY' ) ;

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

330: HR_UTILITY.TRACE(' Eff Date: '||P_EFFECTIVE_DT);
331: HR_UTILITY.TRACE(' PAYE ref :'||P_PAYE_REFERENCE);
332: HR_UTILITY.TRACE(' Business group id '||p_business_group_id);
333: L_EFF_START_DATE := FND_DATE.CANONICAL_TO_DATE(P_EFFECTIVE_DT);
334: HR_UTILITY.TRACE(' Eff Date: '||L_EFF_START_DATE);
335: 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
336: l_date_soy := to_date('06-04-'||SUBSTR(TO_CHAR(l_eff_start_date,'YYYY/MON/DD'),1,4),'DD-MM-YYYY' ) ;
337: 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') ;
338: ELSE

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

360: G_RELATED_TAX_YEAR := TO_CHAR(L_DATE_EOY,'YYYY');
361: -- L_CREATER_ID := FND_GLOBAL.USER_ID;
362: select EMPLOYEE_ID INTO L_CREATER_ID FRom FND_USER
363: WHERE USER_ID = FND_GLOBAL.USER_ID;
364: HR_UTILITY.TRACE(' CREATER_ID '||L_CREATER_ID);
365: l_nic_ssp_rate := G_NIC_RATE;
366: L_NIC_SMP_RATE := G_NIC_RATE;
367: IF g_ssp_recovery = 'None' THEN
368: --No need to calculate SSP balances

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

417: l_spp_birth := l_spp_birth * g_smp_sap_rate;
418: l_aspp_adopt := l_aspp_adopt * g_smp_sap_rate;
419: l_aspp_birth := l_aspp_birth * g_smp_sap_rate;
420: END IF;*/
421: hr_utility.trace(' Total SSP '||l_ssp);
422: hr_utility.trace(' Total SMP '||l_smp);
423: hr_utility.trace(' Total SAP '||l_sap);
424: hr_utility.trace(' Total OSPPA '||l_spp_adopt);
425: hr_utility.trace(' Total OSPPB '||l_spp_birth);

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

418: l_aspp_adopt := l_aspp_adopt * g_smp_sap_rate;
419: l_aspp_birth := l_aspp_birth * g_smp_sap_rate;
420: END IF;*/
421: hr_utility.trace(' Total SSP '||l_ssp);
422: hr_utility.trace(' Total SMP '||l_smp);
423: hr_utility.trace(' Total SAP '||l_sap);
424: hr_utility.trace(' Total OSPPA '||l_spp_adopt);
425: hr_utility.trace(' Total OSPPB '||l_spp_birth);
426: hr_utility.trace(' Total ASPPA '||l_aspp_adopt);

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

419: l_aspp_birth := l_aspp_birth * g_smp_sap_rate;
420: END IF;*/
421: hr_utility.trace(' Total SSP '||l_ssp);
422: hr_utility.trace(' Total SMP '||l_smp);
423: hr_utility.trace(' Total SAP '||l_sap);
424: hr_utility.trace(' Total OSPPA '||l_spp_adopt);
425: hr_utility.trace(' Total OSPPB '||l_spp_birth);
426: hr_utility.trace(' Total ASPPA '||l_aspp_adopt);
427: hr_utility.trace(' Total ASPPB '||l_aspp_birth);

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

420: END IF;*/
421: hr_utility.trace(' Total SSP '||l_ssp);
422: hr_utility.trace(' Total SMP '||l_smp);
423: hr_utility.trace(' Total SAP '||l_sap);
424: hr_utility.trace(' Total OSPPA '||l_spp_adopt);
425: hr_utility.trace(' Total OSPPB '||l_spp_birth);
426: hr_utility.trace(' Total ASPPA '||l_aspp_adopt);
427: hr_utility.trace(' Total ASPPB '||l_aspp_birth);
428: l_spp := l_spp_adopt + l_spp_birth;

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

421: hr_utility.trace(' Total SSP '||l_ssp);
422: hr_utility.trace(' Total SMP '||l_smp);
423: hr_utility.trace(' Total SAP '||l_sap);
424: hr_utility.trace(' Total OSPPA '||l_spp_adopt);
425: hr_utility.trace(' Total OSPPB '||l_spp_birth);
426: hr_utility.trace(' Total ASPPA '||l_aspp_adopt);
427: hr_utility.trace(' Total ASPPB '||l_aspp_birth);
428: l_spp := l_spp_adopt + l_spp_birth;
429: l_aspp := l_aspp_adopt + l_aspp_birth;

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

422: hr_utility.trace(' Total SMP '||l_smp);
423: hr_utility.trace(' Total SAP '||l_sap);
424: hr_utility.trace(' Total OSPPA '||l_spp_adopt);
425: hr_utility.trace(' Total OSPPB '||l_spp_birth);
426: hr_utility.trace(' Total ASPPA '||l_aspp_adopt);
427: hr_utility.trace(' Total ASPPB '||l_aspp_birth);
428: l_spp := l_spp_adopt + l_spp_birth;
429: l_aspp := l_aspp_adopt + l_aspp_birth;
430: hr_utility.trace(' Total OSPP '||l_spp);

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

423: hr_utility.trace(' Total SAP '||l_sap);
424: hr_utility.trace(' Total OSPPA '||l_spp_adopt);
425: hr_utility.trace(' Total OSPPB '||l_spp_birth);
426: hr_utility.trace(' Total ASPPA '||l_aspp_adopt);
427: hr_utility.trace(' Total ASPPB '||l_aspp_birth);
428: l_spp := l_spp_adopt + l_spp_birth;
429: l_aspp := l_aspp_adopt + l_aspp_birth;
430: hr_utility.trace(' Total OSPP '||l_spp);
431: hr_utility.trace(' Total ASPP '||l_aspp);

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

426: hr_utility.trace(' Total ASPPA '||l_aspp_adopt);
427: hr_utility.trace(' Total ASPPB '||l_aspp_birth);
428: l_spp := l_spp_adopt + l_spp_birth;
429: l_aspp := l_aspp_adopt + l_aspp_birth;
430: hr_utility.trace(' Total OSPP '||l_spp);
431: hr_utility.trace(' Total ASPP '||l_aspp);
432: hr_utility.trace(' NIC SSP Rate '||l_nic_ssp_rate);
433: hr_utility.trace(' NIC SMP Rate '||l_nic_smp_rate);
434: --NIC calculations

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

427: hr_utility.trace(' Total ASPPB '||l_aspp_birth);
428: l_spp := l_spp_adopt + l_spp_birth;
429: l_aspp := l_aspp_adopt + l_aspp_birth;
430: hr_utility.trace(' Total OSPP '||l_spp);
431: hr_utility.trace(' Total ASPP '||l_aspp);
432: hr_utility.trace(' NIC SSP Rate '||l_nic_ssp_rate);
433: hr_utility.trace(' NIC SMP Rate '||l_nic_smp_rate);
434: --NIC calculations
435: /* l_nic_ssp := l_ssp * l_nic_ssp_rate;

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

428: l_spp := l_spp_adopt + l_spp_birth;
429: l_aspp := l_aspp_adopt + l_aspp_birth;
430: hr_utility.trace(' Total OSPP '||l_spp);
431: hr_utility.trace(' Total ASPP '||l_aspp);
432: hr_utility.trace(' NIC SSP Rate '||l_nic_ssp_rate);
433: hr_utility.trace(' NIC SMP Rate '||l_nic_smp_rate);
434: --NIC calculations
435: /* l_nic_ssp := l_ssp * l_nic_ssp_rate;
436: l_nic_smp := l_smp * l_nic_smp_rate;

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

429: l_aspp := l_aspp_adopt + l_aspp_birth;
430: hr_utility.trace(' Total OSPP '||l_spp);
431: hr_utility.trace(' Total ASPP '||l_aspp);
432: hr_utility.trace(' NIC SSP Rate '||l_nic_ssp_rate);
433: hr_utility.trace(' NIC SMP Rate '||l_nic_smp_rate);
434: --NIC calculations
435: /* l_nic_ssp := l_ssp * l_nic_ssp_rate;
436: l_nic_smp := l_smp * l_nic_smp_rate;
437: l_nic_sap := l_sap * l_nic_smp_rate;

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

437: l_nic_sap := l_sap * l_nic_smp_rate;
438: l_nic_spp := l_spp * l_nic_smp_rate;
439: l_nic_aspp := l_aspp * l_nic_smp_rate;
440: */
441: hr_utility.trace(' NIC SSP '||l_nic_ssp);
442: hr_utility.trace(' NIC SMP '||l_nic_smp);
443: hr_utility.trace(' NIC SAP '||l_nic_sap);
444: hr_utility.trace(' NIC OSPP '||l_nic_spp);
445: HR_UTILITY.TRACE(' NIC ASPP '||L_NIC_ASPP);

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

438: l_nic_spp := l_spp * l_nic_smp_rate;
439: l_nic_aspp := l_aspp * l_nic_smp_rate;
440: */
441: hr_utility.trace(' NIC SSP '||l_nic_ssp);
442: hr_utility.trace(' NIC SMP '||l_nic_smp);
443: hr_utility.trace(' NIC SAP '||l_nic_sap);
444: hr_utility.trace(' NIC OSPP '||l_nic_spp);
445: HR_UTILITY.TRACE(' NIC ASPP '||L_NIC_ASPP);
446:

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

439: l_nic_aspp := l_aspp * l_nic_smp_rate;
440: */
441: hr_utility.trace(' NIC SSP '||l_nic_ssp);
442: hr_utility.trace(' NIC SMP '||l_nic_smp);
443: hr_utility.trace(' NIC SAP '||l_nic_sap);
444: hr_utility.trace(' NIC OSPP '||l_nic_spp);
445: HR_UTILITY.TRACE(' NIC ASPP '||L_NIC_ASPP);
446:
447: l_nic_spp := l_nic_spp_adopt + l_nic_spp_birth;

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

440: */
441: hr_utility.trace(' NIC SSP '||l_nic_ssp);
442: hr_utility.trace(' NIC SMP '||l_nic_smp);
443: hr_utility.trace(' NIC SAP '||l_nic_sap);
444: hr_utility.trace(' NIC OSPP '||l_nic_spp);
445: HR_UTILITY.TRACE(' NIC ASPP '||L_NIC_ASPP);
446:
447: l_nic_spp := l_nic_spp_adopt + l_nic_spp_birth;
448: l_nic_aspp := l_nic_aspp_adopt + l_nic_aspp_birth;

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

441: hr_utility.trace(' NIC SSP '||l_nic_ssp);
442: hr_utility.trace(' NIC SMP '||l_nic_smp);
443: hr_utility.trace(' NIC SAP '||l_nic_sap);
444: hr_utility.trace(' NIC OSPP '||l_nic_spp);
445: HR_UTILITY.TRACE(' NIC ASPP '||L_NIC_ASPP);
446:
447: l_nic_spp := l_nic_spp_adopt + l_nic_spp_birth;
448: l_nic_aspp := l_nic_aspp_adopt + l_nic_aspp_birth;
449:

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

457: 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',
458: L_CREATER_ID, G_APPROVER_ID , FND_GLOBAL.CONC_REQUEST_ID,l_request_rec.PROGRAM_APPLICATION_ID,l_request_rec.CONCURRENT_PROGRAM_ID,l_request_rec.LAST_UPDATE_DATE);
459:
460:
461: HR_UTILITY.TRACE(' EPS record insert complete ');
462: --Write Output Information
463: l_msg_output:= ' RTI - Employer Payment Summary - Created ';
464: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
465: L_MSG_OUTPUT:= ' ';

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

498: 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');
499: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
500: 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');
501: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
502: HR_UTILITY.TRACE('Create_EPS_RECORD completed '||to_char(sysdate,'dd-mon-yyyy hh24:mm:ss'));
503: END IF;
504: EXCEPTION
505: --13741983 begin
506: WHEN MANDATORY_VALUES_MISSING THEN

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

503: END IF;
504: EXCEPTION
505: --13741983 begin
506: WHEN MANDATORY_VALUES_MISSING THEN
507: hr_utility.trace('Error: Mandatory values required for processing EPS are not present. Please check ');
508: raise_application_error(-20001,' Mandatory Values missing');
509: --13741983 end
510: WHEN Global_missing THEN
511: hr_utility.trace('Error: The globals required for processing EPS are not present. Please check ');

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

507: hr_utility.trace('Error: Mandatory values required for processing EPS are not present. Please check ');
508: raise_application_error(-20001,' Mandatory Values missing');
509: --13741983 end
510: WHEN Global_missing THEN
511: hr_utility.trace('Error: The globals required for processing EPS are not present. Please check ');
512: l_msg_output := 'Error: The globals required for processing EPS are not present. Please check ';
513: fnd_file.put_line(fnd_file.log,l_msg_output);
514: raise_application_error(-20001,' Globals missing');
515: WHEN EPS_ALREADY_PRESENT THEN

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

513: fnd_file.put_line(fnd_file.log,l_msg_output);
514: raise_application_error(-20001,' Globals missing');
515: WHEN EPS_ALREADY_PRESENT THEN
516: l_msg_output:= 'EPS record already created for the given parameters. Please check ';
517: hr_utility.trace('EPS record already created for the given parameters. Please check ');
518: fnd_file.put_line(fnd_file.log,l_msg_output);
519: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,L_MSG_OUTPUT);
520: raise_application_error(-20001,' EPS record already created for the given parameters. Please check');
521: WHEN OTHERS THEN