299: terminate_emp OUT NOCOPY VARCHAR2,
300: town_city OUT NOCOPY VARCHAR2) as
301: begin
302: -- File header record messages
303: c_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_CREATOR');
304: c_ref_no:=fnd_message.get_string('PAY','PY_ZA_ENTER_CREATOR_REF_NO');
305: c_ref_no_invalid:=fnd_message.get_string('PAY','PY_ZA_INVALID_CREATOR_REF_NO');
306: c_person_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_CONTACT_NAME');
307: c_telephone:=fnd_message.get_string('PAY','PY_ZA_ENTER_CONTACT_PHONE_NO');
300: town_city OUT NOCOPY VARCHAR2) as
301: begin
302: -- File header record messages
303: c_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_CREATOR');
304: c_ref_no:=fnd_message.get_string('PAY','PY_ZA_ENTER_CREATOR_REF_NO');
305: c_ref_no_invalid:=fnd_message.get_string('PAY','PY_ZA_INVALID_CREATOR_REF_NO');
306: c_person_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_CONTACT_NAME');
307: c_telephone:=fnd_message.get_string('PAY','PY_ZA_ENTER_CONTACT_PHONE_NO');
308: c_add_line1:=fnd_message.get_string('PAY','PY_ZA_ENTER_ADDRESS_LINE1');
301: begin
302: -- File header record messages
303: c_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_CREATOR');
304: c_ref_no:=fnd_message.get_string('PAY','PY_ZA_ENTER_CREATOR_REF_NO');
305: c_ref_no_invalid:=fnd_message.get_string('PAY','PY_ZA_INVALID_CREATOR_REF_NO');
306: c_person_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_CONTACT_NAME');
307: c_telephone:=fnd_message.get_string('PAY','PY_ZA_ENTER_CONTACT_PHONE_NO');
308: c_add_line1:=fnd_message.get_string('PAY','PY_ZA_ENTER_ADDRESS_LINE1');
309: c_pcode:=fnd_message.get_string('PAY','PY_ZA_ENTER_POSTAL_CODE');
302: -- File header record messages
303: c_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_CREATOR');
304: c_ref_no:=fnd_message.get_string('PAY','PY_ZA_ENTER_CREATOR_REF_NO');
305: c_ref_no_invalid:=fnd_message.get_string('PAY','PY_ZA_INVALID_CREATOR_REF_NO');
306: c_person_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_CONTACT_NAME');
307: c_telephone:=fnd_message.get_string('PAY','PY_ZA_ENTER_CONTACT_PHONE_NO');
308: c_add_line1:=fnd_message.get_string('PAY','PY_ZA_ENTER_ADDRESS_LINE1');
309: c_pcode:=fnd_message.get_string('PAY','PY_ZA_ENTER_POSTAL_CODE');
310: c_pcode1:=fnd_message.get_string('PAY','PY_ZA_INVALID_POSTAL_CODE');
303: c_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_CREATOR');
304: c_ref_no:=fnd_message.get_string('PAY','PY_ZA_ENTER_CREATOR_REF_NO');
305: c_ref_no_invalid:=fnd_message.get_string('PAY','PY_ZA_INVALID_CREATOR_REF_NO');
306: c_person_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_CONTACT_NAME');
307: c_telephone:=fnd_message.get_string('PAY','PY_ZA_ENTER_CONTACT_PHONE_NO');
308: c_add_line1:=fnd_message.get_string('PAY','PY_ZA_ENTER_ADDRESS_LINE1');
309: c_pcode:=fnd_message.get_string('PAY','PY_ZA_ENTER_POSTAL_CODE');
310: c_pcode1:=fnd_message.get_string('PAY','PY_ZA_INVALID_POSTAL_CODE');
311:
304: c_ref_no:=fnd_message.get_string('PAY','PY_ZA_ENTER_CREATOR_REF_NO');
305: c_ref_no_invalid:=fnd_message.get_string('PAY','PY_ZA_INVALID_CREATOR_REF_NO');
306: c_person_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_CONTACT_NAME');
307: c_telephone:=fnd_message.get_string('PAY','PY_ZA_ENTER_CONTACT_PHONE_NO');
308: c_add_line1:=fnd_message.get_string('PAY','PY_ZA_ENTER_ADDRESS_LINE1');
309: c_pcode:=fnd_message.get_string('PAY','PY_ZA_ENTER_POSTAL_CODE');
310: c_pcode1:=fnd_message.get_string('PAY','PY_ZA_INVALID_POSTAL_CODE');
311:
312: -- Employer validation messages
305: c_ref_no_invalid:=fnd_message.get_string('PAY','PY_ZA_INVALID_CREATOR_REF_NO');
306: c_person_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_CONTACT_NAME');
307: c_telephone:=fnd_message.get_string('PAY','PY_ZA_ENTER_CONTACT_PHONE_NO');
308: c_add_line1:=fnd_message.get_string('PAY','PY_ZA_ENTER_ADDRESS_LINE1');
309: c_pcode:=fnd_message.get_string('PAY','PY_ZA_ENTER_POSTAL_CODE');
310: c_pcode1:=fnd_message.get_string('PAY','PY_ZA_INVALID_POSTAL_CODE');
311:
312: -- Employer validation messages
313: trade_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_TRADING_NAME');
306: c_person_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_CONTACT_NAME');
307: c_telephone:=fnd_message.get_string('PAY','PY_ZA_ENTER_CONTACT_PHONE_NO');
308: c_add_line1:=fnd_message.get_string('PAY','PY_ZA_ENTER_ADDRESS_LINE1');
309: c_pcode:=fnd_message.get_string('PAY','PY_ZA_ENTER_POSTAL_CODE');
310: c_pcode1:=fnd_message.get_string('PAY','PY_ZA_INVALID_POSTAL_CODE');
311:
312: -- Employer validation messages
313: trade_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_TRADING_NAME');
314: paye_no:=fnd_message.get_string('PAY','PY_ZA_ENTER_TAX_REF_NO');
309: c_pcode:=fnd_message.get_string('PAY','PY_ZA_ENTER_POSTAL_CODE');
310: c_pcode1:=fnd_message.get_string('PAY','PY_ZA_INVALID_POSTAL_CODE');
311:
312: -- Employer validation messages
313: trade_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_TRADING_NAME');
314: paye_no:=fnd_message.get_string('PAY','PY_ZA_ENTER_TAX_REF_NO');
315: paye_no1:=fnd_message.get_string('PAY','PY_ZA_INVALID_TAX_REF_NO');
316: address:=c_add_line1;
317: pcode:= c_pcode;
310: c_pcode1:=fnd_message.get_string('PAY','PY_ZA_INVALID_POSTAL_CODE');
311:
312: -- Employer validation messages
313: trade_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_TRADING_NAME');
314: paye_no:=fnd_message.get_string('PAY','PY_ZA_ENTER_TAX_REF_NO');
315: paye_no1:=fnd_message.get_string('PAY','PY_ZA_INVALID_TAX_REF_NO');
316: address:=c_add_line1;
317: pcode:= c_pcode;
318: pcode1:=c_pcode1;
311:
312: -- Employer validation messages
313: trade_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_TRADING_NAME');
314: paye_no:=fnd_message.get_string('PAY','PY_ZA_ENTER_TAX_REF_NO');
315: paye_no1:=fnd_message.get_string('PAY','PY_ZA_INVALID_TAX_REF_NO');
316: address:=c_add_line1;
317: pcode:= c_pcode;
318: pcode1:=c_pcode1;
319:
317: pcode:= c_pcode;
318: pcode1:=c_pcode1;
319:
320: -- Payroll validation message
321: payroll_number:=fnd_message.get_string('PAY','PY_ZA_INVALID_IRP5_NO');
322:
323: --Employee validation messages
324: nature_entered:=fnd_message.get_string('PAY','PY_ZA_ENTER_NATURE_PERSON');
325: id_passport:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_AC_ID_PASSNO');
320: -- Payroll validation message
321: payroll_number:=fnd_message.get_string('PAY','PY_ZA_INVALID_IRP5_NO');
322:
323: --Employee validation messages
324: nature_entered:=fnd_message.get_string('PAY','PY_ZA_ENTER_NATURE_PERSON');
325: id_passport:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_AC_ID_PASSNO');
326: no_id_passport:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_B_ID_PASSNO');
327: sur_trade_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_DEFGHK_TRADE');
328: cc_no:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_DEHK_CC_NO');
321: payroll_number:=fnd_message.get_string('PAY','PY_ZA_INVALID_IRP5_NO');
322:
323: --Employee validation messages
324: nature_entered:=fnd_message.get_string('PAY','PY_ZA_ENTER_NATURE_PERSON');
325: id_passport:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_AC_ID_PASSNO');
326: no_id_passport:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_B_ID_PASSNO');
327: sur_trade_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_DEFGHK_TRADE');
328: cc_no:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_DEHK_CC_NO');
329:
322:
323: --Employee validation messages
324: nature_entered:=fnd_message.get_string('PAY','PY_ZA_ENTER_NATURE_PERSON');
325: id_passport:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_AC_ID_PASSNO');
326: no_id_passport:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_B_ID_PASSNO');
327: sur_trade_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_DEFGHK_TRADE');
328: cc_no:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_DEHK_CC_NO');
329:
330: sur_first_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_ABC_S_F_NAME');
323: --Employee validation messages
324: nature_entered:=fnd_message.get_string('PAY','PY_ZA_ENTER_NATURE_PERSON');
325: id_passport:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_AC_ID_PASSNO');
326: no_id_passport:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_B_ID_PASSNO');
327: sur_trade_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_DEFGHK_TRADE');
328: cc_no:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_DEHK_CC_NO');
329:
330: sur_first_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_ABC_S_F_NAME');
331: M_sur_fname:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_S_F_NAME');
324: nature_entered:=fnd_message.get_string('PAY','PY_ZA_ENTER_NATURE_PERSON');
325: id_passport:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_AC_ID_PASSNO');
326: no_id_passport:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_B_ID_PASSNO');
327: sur_trade_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_DEFGHK_TRADE');
328: cc_no:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_DEHK_CC_NO');
329:
330: sur_first_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_ABC_S_F_NAME');
331: M_sur_fname:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_S_F_NAME');
332: M_id_pno_fname:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_IDPNO_SF_NAM');
326: no_id_passport:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_B_ID_PASSNO');
327: sur_trade_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_DEFGHK_TRADE');
328: cc_no:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_DEHK_CC_NO');
329:
330: sur_first_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_ABC_S_F_NAME');
331: M_sur_fname:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_S_F_NAME');
332: M_id_pno_fname:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_IDPNO_SF_NAM');
333: M_cc_trade_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_CC_NO');
334:
327: sur_trade_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_DEFGHK_TRADE');
328: cc_no:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_DEHK_CC_NO');
329:
330: sur_first_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_ABC_S_F_NAME');
331: M_sur_fname:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_S_F_NAME');
332: M_id_pno_fname:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_IDPNO_SF_NAM');
333: M_cc_trade_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_CC_NO');
334:
335: M_lname_fname_cc:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_FM_NAME_CCNO');
328: cc_no:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_DEHK_CC_NO');
329:
330: sur_first_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_ABC_S_F_NAME');
331: M_sur_fname:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_S_F_NAME');
332: M_id_pno_fname:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_IDPNO_SF_NAM');
333: M_cc_trade_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_CC_NO');
334:
335: M_lname_fname_cc:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_FM_NAME_CCNO');
336:
329:
330: sur_first_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_ABC_S_F_NAME');
331: M_sur_fname:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_S_F_NAME');
332: M_id_pno_fname:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_IDPNO_SF_NAM');
333: M_cc_trade_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_CC_NO');
334:
335: M_lname_fname_cc:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_FM_NAME_CCNO');
336:
337: invalid_it_no:=fnd_message.get_string('PAY','PY_ZA_INVALID_IT_TAX_NO');
331: M_sur_fname:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_S_F_NAME');
332: M_id_pno_fname:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_IDPNO_SF_NAM');
333: M_cc_trade_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_CC_NO');
334:
335: M_lname_fname_cc:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_FM_NAME_CCNO');
336:
337: invalid_it_no:=fnd_message.get_string('PAY','PY_ZA_INVALID_IT_TAX_NO');
338: birth_id:=fnd_message.get_string('PER','HR_ZA_INVALID_NI_DOB');
339: legal_entity:=fnd_message.get_string('PAY','PY_ZA_ENTER_LEGAL_ENTITY');
333: M_cc_trade_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_CC_NO');
334:
335: M_lname_fname_cc:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_FM_NAME_CCNO');
336:
337: invalid_it_no:=fnd_message.get_string('PAY','PY_ZA_INVALID_IT_TAX_NO');
338: birth_id:=fnd_message.get_string('PER','HR_ZA_INVALID_NI_DOB');
339: legal_entity:=fnd_message.get_string('PAY','PY_ZA_ENTER_LEGAL_ENTITY');
340:
341: no_site_paye_split:=fnd_message.get_string('PAY','PY_ZA_NO_SITE_PAYE_SPLIT');
334:
335: M_lname_fname_cc:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_FM_NAME_CCNO');
336:
337: invalid_it_no:=fnd_message.get_string('PAY','PY_ZA_INVALID_IT_TAX_NO');
338: birth_id:=fnd_message.get_string('PER','HR_ZA_INVALID_NI_DOB');
339: legal_entity:=fnd_message.get_string('PAY','PY_ZA_ENTER_LEGAL_ENTITY');
340:
341: no_site_paye_split:=fnd_message.get_string('PAY','PY_ZA_NO_SITE_PAYE_SPLIT');
342: neg_bal_not_alwd :=fnd_message.get_string('PAY','PY_ZA_NEG_BAL_NOT_ALWD');
335: M_lname_fname_cc:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_FM_NAME_CCNO');
336:
337: invalid_it_no:=fnd_message.get_string('PAY','PY_ZA_INVALID_IT_TAX_NO');
338: birth_id:=fnd_message.get_string('PER','HR_ZA_INVALID_NI_DOB');
339: legal_entity:=fnd_message.get_string('PAY','PY_ZA_ENTER_LEGAL_ENTITY');
340:
341: no_site_paye_split:=fnd_message.get_string('PAY','PY_ZA_NO_SITE_PAYE_SPLIT');
342: neg_bal_not_alwd :=fnd_message.get_string('PAY','PY_ZA_NEG_BAL_NOT_ALWD');
343: clearance_num:=fnd_message.get_string('PAY','PA_ZA_ENTER_CLEARANCE_NUM');
337: invalid_it_no:=fnd_message.get_string('PAY','PY_ZA_INVALID_IT_TAX_NO');
338: birth_id:=fnd_message.get_string('PER','HR_ZA_INVALID_NI_DOB');
339: legal_entity:=fnd_message.get_string('PAY','PY_ZA_ENTER_LEGAL_ENTITY');
340:
341: no_site_paye_split:=fnd_message.get_string('PAY','PY_ZA_NO_SITE_PAYE_SPLIT');
342: neg_bal_not_alwd :=fnd_message.get_string('PAY','PY_ZA_NEG_BAL_NOT_ALWD');
343: clearance_num:=fnd_message.get_string('PAY','PA_ZA_ENTER_CLEARANCE_NUM');
344: terminate_emp:=fnd_message.get_string('PAY','PA_ZA_TERMINATE_EMP');
345: town_city := fnd_message.get_string('PAY','PAY_ZA_ENTER_TOWN_CITY');
338: birth_id:=fnd_message.get_string('PER','HR_ZA_INVALID_NI_DOB');
339: legal_entity:=fnd_message.get_string('PAY','PY_ZA_ENTER_LEGAL_ENTITY');
340:
341: no_site_paye_split:=fnd_message.get_string('PAY','PY_ZA_NO_SITE_PAYE_SPLIT');
342: neg_bal_not_alwd :=fnd_message.get_string('PAY','PY_ZA_NEG_BAL_NOT_ALWD');
343: clearance_num:=fnd_message.get_string('PAY','PA_ZA_ENTER_CLEARANCE_NUM');
344: terminate_emp:=fnd_message.get_string('PAY','PA_ZA_TERMINATE_EMP');
345: town_city := fnd_message.get_string('PAY','PAY_ZA_ENTER_TOWN_CITY');
346:
339: legal_entity:=fnd_message.get_string('PAY','PY_ZA_ENTER_LEGAL_ENTITY');
340:
341: no_site_paye_split:=fnd_message.get_string('PAY','PY_ZA_NO_SITE_PAYE_SPLIT');
342: neg_bal_not_alwd :=fnd_message.get_string('PAY','PY_ZA_NEG_BAL_NOT_ALWD');
343: clearance_num:=fnd_message.get_string('PAY','PA_ZA_ENTER_CLEARANCE_NUM');
344: terminate_emp:=fnd_message.get_string('PAY','PA_ZA_TERMINATE_EMP');
345: town_city := fnd_message.get_string('PAY','PAY_ZA_ENTER_TOWN_CITY');
346:
347: exception
340:
341: no_site_paye_split:=fnd_message.get_string('PAY','PY_ZA_NO_SITE_PAYE_SPLIT');
342: neg_bal_not_alwd :=fnd_message.get_string('PAY','PY_ZA_NEG_BAL_NOT_ALWD');
343: clearance_num:=fnd_message.get_string('PAY','PA_ZA_ENTER_CLEARANCE_NUM');
344: terminate_emp:=fnd_message.get_string('PAY','PA_ZA_TERMINATE_EMP');
345: town_city := fnd_message.get_string('PAY','PAY_ZA_ENTER_TOWN_CITY');
346:
347: exception
348:
341: no_site_paye_split:=fnd_message.get_string('PAY','PY_ZA_NO_SITE_PAYE_SPLIT');
342: neg_bal_not_alwd :=fnd_message.get_string('PAY','PY_ZA_NEG_BAL_NOT_ALWD');
343: clearance_num:=fnd_message.get_string('PAY','PA_ZA_ENTER_CLEARANCE_NUM');
344: terminate_emp:=fnd_message.get_string('PAY','PA_ZA_TERMINATE_EMP');
345: town_city := fnd_message.get_string('PAY','PAY_ZA_ENTER_TOWN_CITY');
346:
347: exception
348:
349: when others then
797: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
798: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
799: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
800: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
801: fnd_message.set_name('PAY', 'PY_ZA_NO_SITE_PAYE_SPLIT');
802: fnd_message.set_token('EMPNO',l_empno);
803: l_msgtext := fnd_message.get('Y');
804: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Tax Amount : '||l_tax_ytd) ;
805: FND_FILE.PUT_LINE(FND_FILE.LOG, ' SITE balance : '||l_site) ;
798: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
799: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
800: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
801: fnd_message.set_name('PAY', 'PY_ZA_NO_SITE_PAYE_SPLIT');
802: fnd_message.set_token('EMPNO',l_empno);
803: l_msgtext := fnd_message.get('Y');
804: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Tax Amount : '||l_tax_ytd) ;
805: FND_FILE.PUT_LINE(FND_FILE.LOG, ' SITE balance : '||l_site) ;
806: FND_FILE.PUT_LINE(FND_FILE.LOG, ' PAYE balance : '||l_paye) ;
799: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
800: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
801: fnd_message.set_name('PAY', 'PY_ZA_NO_SITE_PAYE_SPLIT');
802: fnd_message.set_token('EMPNO',l_empno);
803: l_msgtext := fnd_message.get('Y');
804: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Tax Amount : '||l_tax_ytd) ;
805: FND_FILE.PUT_LINE(FND_FILE.LOG, ' SITE balance : '||l_site) ;
806: FND_FILE.PUT_LINE(FND_FILE.LOG, ' PAYE balance : '||l_paye) ;
807: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
818: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
819: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
820: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
821: end if;
822: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
823: fnd_message.set_token('EMPno',l_empno);
824: fnd_message.set_token('SARScode',neg_amt_check.code);
825: l_msgtext := fnd_message.get('Y');
826: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
819: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
820: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
821: end if;
822: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
823: fnd_message.set_token('EMPno',l_empno);
824: fnd_message.set_token('SARScode',neg_amt_check.code);
825: l_msgtext := fnd_message.get('Y');
826: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
827: END LOOP ;
820: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
821: end if;
822: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
823: fnd_message.set_token('EMPno',l_empno);
824: fnd_message.set_token('SARScode',neg_amt_check.code);
825: l_msgtext := fnd_message.get('Y');
826: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
827: END LOOP ;
828:
821: end if;
822: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
823: fnd_message.set_token('EMPno',l_empno);
824: fnd_message.set_token('SARScode',neg_amt_check.code);
825: l_msgtext := fnd_message.get('Y');
826: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
827: END LOOP ;
828:
829: -- Rule 3) Check Lumpsum balances which may not contain negative amounts
837: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
838: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
839: end if;
840: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || g_default_dirno);
841: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
842: fnd_message.set_token('EMPno',l_empno);
843: fnd_message.set_token('SARScode',lmpsum_bal.code);
844: l_msgtext := fnd_message.get('Y');
845: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
838: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
839: end if;
840: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || g_default_dirno);
841: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
842: fnd_message.set_token('EMPno',l_empno);
843: fnd_message.set_token('SARScode',lmpsum_bal.code);
844: l_msgtext := fnd_message.get('Y');
845: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
846: END LOOP ;
839: end if;
840: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || g_default_dirno);
841: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
842: fnd_message.set_token('EMPno',l_empno);
843: fnd_message.set_token('SARScode',lmpsum_bal.code);
844: l_msgtext := fnd_message.get('Y');
845: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
846: END LOOP ;
847: ---- Check for the Lump Sum Balances with Directive Number Other than the Defoult directive number
840: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || g_default_dirno);
841: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
842: fnd_message.set_token('EMPno',l_empno);
843: fnd_message.set_token('SARScode',lmpsum_bal.code);
844: l_msgtext := fnd_message.get('Y');
845: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
846: END LOOP ;
847: ---- Check for the Lump Sum Balances with Directive Number Other than the Defoult directive number
848:
855: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
856: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
857: end if;
858: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_lmpsm_crt_bal.Tax_Directive_Number);
859: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
860: fnd_message.set_token('EMPno',l_empno);
861: fnd_message.set_token('SARScode',rec_lmpsm_crt_bal.code);
862: l_msgtext := fnd_message.get('Y');
863: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
856: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
857: end if;
858: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_lmpsm_crt_bal.Tax_Directive_Number);
859: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
860: fnd_message.set_token('EMPno',l_empno);
861: fnd_message.set_token('SARScode',rec_lmpsm_crt_bal.code);
862: l_msgtext := fnd_message.get('Y');
863: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
864:
857: end if;
858: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_lmpsm_crt_bal.Tax_Directive_Number);
859: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
860: fnd_message.set_token('EMPno',l_empno);
861: fnd_message.set_token('SARScode',rec_lmpsm_crt_bal.code);
862: l_msgtext := fnd_message.get('Y');
863: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
864:
865:
858: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_lmpsm_crt_bal.Tax_Directive_Number);
859: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
860: fnd_message.set_token('EMPno',l_empno);
861: fnd_message.set_token('SARScode',rec_lmpsm_crt_bal.code);
862: l_msgtext := fnd_message.get('Y');
863: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
864:
865:
866: END loop;
879: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
880: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
881: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
882: end if;
883: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
884: fnd_message.set_token('EMPno',l_empno);
885: fnd_message.set_token('SARScode',ded_bal.code);
886: l_msgtext := fnd_message.get('Y');
887: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
880: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
881: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
882: end if;
883: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
884: fnd_message.set_token('EMPno',l_empno);
885: fnd_message.set_token('SARScode',ded_bal.code);
886: l_msgtext := fnd_message.get('Y');
887: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
888: END IF ;
881: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
882: end if;
883: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
884: fnd_message.set_token('EMPno',l_empno);
885: fnd_message.set_token('SARScode',ded_bal.code);
886: l_msgtext := fnd_message.get('Y');
887: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
888: END IF ;
889: IF ded_bal.clearance_num = g_default_clrno THEN
882: end if;
883: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
884: fnd_message.set_token('EMPno',l_empno);
885: fnd_message.set_token('SARScode',ded_bal.code);
886: l_msgtext := fnd_message.get('Y');
887: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
888: END IF ;
889: IF ded_bal.clearance_num = g_default_clrno THEN
890: l_missing_clrno_flag := 'Y' ;
908: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
909: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
910: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
911: end if;
912: fnd_message.set_name('PAY', 'PA_ZA_ENTER_CLEARANCE_NUM');
913: fnd_message.set_token('EMPno',l_empno);
914: fnd_message.set_token('ELEMENTname',elem_names.element_name);
915: l_msgtext := fnd_message.get('Y');
916: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
909: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
910: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
911: end if;
912: fnd_message.set_name('PAY', 'PA_ZA_ENTER_CLEARANCE_NUM');
913: fnd_message.set_token('EMPno',l_empno);
914: fnd_message.set_token('ELEMENTname',elem_names.element_name);
915: l_msgtext := fnd_message.get('Y');
916: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
917: END LOOP ;
910: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
911: end if;
912: fnd_message.set_name('PAY', 'PA_ZA_ENTER_CLEARANCE_NUM');
913: fnd_message.set_token('EMPno',l_empno);
914: fnd_message.set_token('ELEMENTname',elem_names.element_name);
915: l_msgtext := fnd_message.get('Y');
916: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
917: END LOOP ;
918: END LOOP ;
911: end if;
912: fnd_message.set_name('PAY', 'PA_ZA_ENTER_CLEARANCE_NUM');
913: fnd_message.set_token('EMPno',l_empno);
914: fnd_message.set_token('ELEMENTname',elem_names.element_name);
915: l_msgtext := fnd_message.get('Y');
916: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
917: END LOOP ;
918: END LOOP ;
919: END IF;
930: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
931: end if;
932:
933: IF l_count1 <>1 then
934: fnd_message.set_name('PAY', 'PY_ZA_PKG_BAL_NT_ALLOW');
935: fnd_message.set_token('EMPno',l_empno);
936: l_msgtext := fnd_message.get('Y');
937: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
938: l_count1:=1;
931: end if;
932:
933: IF l_count1 <>1 then
934: fnd_message.set_name('PAY', 'PY_ZA_PKG_BAL_NT_ALLOW');
935: fnd_message.set_token('EMPno',l_empno);
936: l_msgtext := fnd_message.get('Y');
937: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
938: l_count1:=1;
939: END IF;
932:
933: IF l_count1 <>1 then
934: fnd_message.set_name('PAY', 'PY_ZA_PKG_BAL_NT_ALLOW');
935: fnd_message.set_token('EMPno',l_empno);
936: l_msgtext := fnd_message.get('Y');
937: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
938: l_count1:=1;
939: END IF;
940:
939: END IF;
940:
941: FOR pkg_ele IN fetch_pkg_ele(asgn.assignment_action_id, pkg_bal.bal_type_id)
942: LOOP
943: fnd_message.set_name('PAY', 'PY_ZA_ELE_FEED_PKG_BAL');
944: fnd_message.set_token('ELEMENTname',pkg_ele.element_name);
945: fnd_message.set_token('BALANCEname',pkg_bal.bal_name);
946: l_msgtext := fnd_message.get('Y');
947: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
940:
941: FOR pkg_ele IN fetch_pkg_ele(asgn.assignment_action_id, pkg_bal.bal_type_id)
942: LOOP
943: fnd_message.set_name('PAY', 'PY_ZA_ELE_FEED_PKG_BAL');
944: fnd_message.set_token('ELEMENTname',pkg_ele.element_name);
945: fnd_message.set_token('BALANCEname',pkg_bal.bal_name);
946: l_msgtext := fnd_message.get('Y');
947: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
948: END LOOP;
941: FOR pkg_ele IN fetch_pkg_ele(asgn.assignment_action_id, pkg_bal.bal_type_id)
942: LOOP
943: fnd_message.set_name('PAY', 'PY_ZA_ELE_FEED_PKG_BAL');
944: fnd_message.set_token('ELEMENTname',pkg_ele.element_name);
945: fnd_message.set_token('BALANCEname',pkg_bal.bal_name);
946: l_msgtext := fnd_message.get('Y');
947: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
948: END LOOP;
949:
942: LOOP
943: fnd_message.set_name('PAY', 'PY_ZA_ELE_FEED_PKG_BAL');
944: fnd_message.set_token('ELEMENTname',pkg_ele.element_name);
945: fnd_message.set_token('BALANCEname',pkg_bal.bal_name);
946: l_msgtext := fnd_message.get('Y');
947: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
948: END LOOP;
949:
950: END LOOP;