4806: , p_source_id => NULL
4807: , p_source_text => NULL
4808: , p_tax_unit_id => l_tax_unit_id
4809: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
4810: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_SENDER_ID')
4811: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
4812: , p_action_information6 => 'Sender ID is null'
4813: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
4814: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
4826: , p_source_id => NULL
4827: , p_source_text => NULL
4828: , p_tax_unit_id => l_tax_unit_id
4829: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
4830: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_PERSON_NM')
4831: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
4832: , p_action_information6 => 'Contact Person is null'
4833: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
4834: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
4846: , p_source_id => NULL
4847: , p_source_text => NULL
4848: , p_tax_unit_id => l_tax_unit_id
4849: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
4850: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_CONTACT_NO')
4851: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
4852: , p_action_information6 => 'Contact Number is null'
4853: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
4854: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
4866: , p_source_id => NULL
4867: , p_source_text => NULL
4868: , p_tax_unit_id => l_tax_unit_id
4869: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
4870: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_TAX_NO')
4871: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
4872: , p_action_information6 => 'Tax Registration Number is null'
4873: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
4874: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
4887: , p_source_id => NULL
4888: , p_source_text => NULL
4889: , p_tax_unit_id => l_tax_unit_id
4890: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
4891: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_TAX_FORMAT')
4892: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
4893: , p_action_information6 => 'Tax Registration Number is not in the format 111111111L11'
4894: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
4895: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
4907: , p_source_id => NULL
4908: , p_source_text => NULL
4909: , p_tax_unit_id => l_tax_unit_id
4910: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
4911: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_TAX_NAME')
4912: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
4913: , p_action_information6 => 'Tax Reporting Name is null'
4914: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
4915: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
5182: , p_source_id => NULL
5183: , p_source_text => NULL
5184: , p_tax_unit_id => l_tax_unit_id
5185: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
5186: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_SECTOR')
5187: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
5188: , p_action_information6 => 'Mandatory check on Sector'
5189: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
5190: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
5200: , p_source_id => NULL
5201: , p_source_text => NULL
5202: , p_tax_unit_id => l_tax_unit_id
5203: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
5204: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_RISK_GROUP')
5205: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
5206: , p_action_information6 => 'No Risk Group'
5207: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
5208: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
5220: , p_source_id => NULL
5221: , p_source_text => NULL
5222: , p_tax_unit_id => l_tax_unit_id
5223: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
5224: , p_action_information4 => fnd_message.get_string('PER','HR_NL_ZERO_BASE_WEWE') -- Message Code should have been '%_WEWA'
5225: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
5226: , p_action_information6 => 'Waiting Money Fund contribution base is zero'
5227: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
5228: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
5240: , p_source_id => NULL
5241: , p_source_text => NULL
5242: , p_tax_unit_id => l_tax_unit_id
5243: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
5244: , p_action_information4 => fnd_message.get_string('PER','HR_NL_ZERO_AWF')
5245: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
5246: , p_action_information6 => 'AWF contribution base is zero'
5247: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
5248: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
5508: , p_source_id => NULL
5509: , p_source_text => NULL
5510: , p_tax_unit_id => l_tax_unit_id
5511: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
5512: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_SECTOR')
5513: , p_action_information5 => l_period_dates_rec.End_date
5514: , p_action_information6 => 'Mandatory check on Sector'
5515: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
5516: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
5526: , p_source_id => NULL
5527: , p_source_text => NULL
5528: , p_tax_unit_id => l_tax_unit_id
5529: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
5530: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_RISK_GROUP')
5531: , p_action_information5 => l_period_dates_rec.End_date
5532: , p_action_information6 => 'No Risk Group'
5533: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
5534: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
5546: , p_source_id => NULL
5547: , p_source_text => NULL
5548: , p_tax_unit_id => l_tax_unit_id
5549: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
5550: , p_action_information4 => fnd_message.get_string('PER','HR_NL_ZERO_BASE_WEWE') -- Message Code should have been '%_WEWA'
5551: , p_action_information5 => l_period_dates_rec.End_date
5552: , p_action_information6 => 'Waiting Money Fund contribution base is zero'
5553: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
5554: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
5566: , p_source_id => NULL
5567: , p_source_text => NULL
5568: , p_tax_unit_id => l_tax_unit_id
5569: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
5570: , p_action_information4 => fnd_message.get_string('PER','HR_NL_ZERO_AWF')
5571: , p_action_information5 => l_period_dates_rec.End_date
5572: , p_action_information6 => 'AWF contribution base is zero'
5573: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
5574: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
6558: --abraghun--7668628-- PA Level Validations--
6559:
6560: --abraghun--7668628--Check0001
6561: IF l_CR_TotLnLbPh <> l_NR_LnLbPh THEN
6562: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6563: fnd_message.set_token('TAG1','TotLnLbPh');
6564: fnd_message.set_token('TAGVAL1',l_CR_TotLnLbPh);
6565: fnd_message.set_token('TAG2','LnLbPh');
6566: fnd_message.set_token('TAGVAL2',l_NR_LnLbPh);
6559:
6560: --abraghun--7668628--Check0001
6561: IF l_CR_TotLnLbPh <> l_NR_LnLbPh THEN
6562: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6563: fnd_message.set_token('TAG1','TotLnLbPh');
6564: fnd_message.set_token('TAGVAL1',l_CR_TotLnLbPh);
6565: fnd_message.set_token('TAG2','LnLbPh');
6566: fnd_message.set_token('TAGVAL2',l_NR_LnLbPh);
6567:
6560: --abraghun--7668628--Check0001
6561: IF l_CR_TotLnLbPh <> l_NR_LnLbPh THEN
6562: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6563: fnd_message.set_token('TAG1','TotLnLbPh');
6564: fnd_message.set_token('TAGVAL1',l_CR_TotLnLbPh);
6565: fnd_message.set_token('TAG2','LnLbPh');
6566: fnd_message.set_token('TAGVAL2',l_NR_LnLbPh);
6567:
6568: pay_action_information_api.create_action_information
6561: IF l_CR_TotLnLbPh <> l_NR_LnLbPh THEN
6562: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6563: fnd_message.set_token('TAG1','TotLnLbPh');
6564: fnd_message.set_token('TAGVAL1',l_CR_TotLnLbPh);
6565: fnd_message.set_token('TAG2','LnLbPh');
6566: fnd_message.set_token('TAGVAL2',l_NR_LnLbPh);
6567:
6568: pay_action_information_api.create_action_information
6569: (
6562: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6563: fnd_message.set_token('TAG1','TotLnLbPh');
6564: fnd_message.set_token('TAGVAL1',l_CR_TotLnLbPh);
6565: fnd_message.set_token('TAG2','LnLbPh');
6566: fnd_message.set_token('TAGVAL2',l_NR_LnLbPh);
6567:
6568: pay_action_information_api.create_action_information
6569: (
6570: p_action_information_id => l_action_info_id
6576: , p_source_id => NULL
6577: , p_source_text => NULL
6578: , p_tax_unit_id => l_tax_unit_id
6579: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
6580: , p_action_information4 => '0001 - '||fnd_message.get
6581: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
6582: , p_action_information6 => '0001 - '||'Tag TotLnLbPh, (Total wage for taxes). The total amount of wages should be the same as the sum of the individual amounts of wage for taxes.'
6583: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
6584: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
6585: END IF;
6586: --
6587: --abraghun--7668628--Check0002
6588: IF l_CR_TotLnSV <> l_NR_LnSV THEN
6589: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6590: fnd_message.set_token('TAG1','TotLnSV');
6591: fnd_message.set_token('TAGVAL1',l_CR_TotLnSV);
6592: fnd_message.set_token('TAG2','LnSV');
6593: fnd_message.set_token('TAGVAL2',l_NR_LnSV);
6586: --
6587: --abraghun--7668628--Check0002
6588: IF l_CR_TotLnSV <> l_NR_LnSV THEN
6589: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6590: fnd_message.set_token('TAG1','TotLnSV');
6591: fnd_message.set_token('TAGVAL1',l_CR_TotLnSV);
6592: fnd_message.set_token('TAG2','LnSV');
6593: fnd_message.set_token('TAGVAL2',l_NR_LnSV);
6594:
6587: --abraghun--7668628--Check0002
6588: IF l_CR_TotLnSV <> l_NR_LnSV THEN
6589: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6590: fnd_message.set_token('TAG1','TotLnSV');
6591: fnd_message.set_token('TAGVAL1',l_CR_TotLnSV);
6592: fnd_message.set_token('TAG2','LnSV');
6593: fnd_message.set_token('TAGVAL2',l_NR_LnSV);
6594:
6595: pay_action_information_api.create_action_information
6588: IF l_CR_TotLnSV <> l_NR_LnSV THEN
6589: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6590: fnd_message.set_token('TAG1','TotLnSV');
6591: fnd_message.set_token('TAGVAL1',l_CR_TotLnSV);
6592: fnd_message.set_token('TAG2','LnSV');
6593: fnd_message.set_token('TAGVAL2',l_NR_LnSV);
6594:
6595: pay_action_information_api.create_action_information
6596: (
6589: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6590: fnd_message.set_token('TAG1','TotLnSV');
6591: fnd_message.set_token('TAGVAL1',l_CR_TotLnSV);
6592: fnd_message.set_token('TAG2','LnSV');
6593: fnd_message.set_token('TAGVAL2',l_NR_LnSV);
6594:
6595: pay_action_information_api.create_action_information
6596: (
6597: p_action_information_id => l_action_info_id
6603: , p_source_id => NULL
6604: , p_source_text => NULL
6605: , p_tax_unit_id => l_tax_unit_id
6606: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
6607: , p_action_information4 => '0002 - '||fnd_message.get
6608: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
6609: , p_action_information6 => '0002 - '||'Tag TotLnSV, (Total SI wage). The total amount of SI wages should be the same as the sum of the individual amounts of SI wages.'
6610: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
6611: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
6612: END IF;
6613: --
6614: --abraghun--7668628--Check0003
6615: IF l_CR_IngLbPh <> l_NR_IngLbPh THEN
6616: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6617: fnd_message.set_token('TAG1','IngLbPh');
6618: fnd_message.set_token('TAGVAL1',l_CR_IngLbPh);
6619: fnd_message.set_token('TAG2','IngLbPh');
6620: fnd_message.set_token('TAGVAL2',l_NR_IngLbPh);
6613: --
6614: --abraghun--7668628--Check0003
6615: IF l_CR_IngLbPh <> l_NR_IngLbPh THEN
6616: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6617: fnd_message.set_token('TAG1','IngLbPh');
6618: fnd_message.set_token('TAGVAL1',l_CR_IngLbPh);
6619: fnd_message.set_token('TAG2','IngLbPh');
6620: fnd_message.set_token('TAGVAL2',l_NR_IngLbPh);
6621: pay_action_information_api.create_action_information
6614: --abraghun--7668628--Check0003
6615: IF l_CR_IngLbPh <> l_NR_IngLbPh THEN
6616: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6617: fnd_message.set_token('TAG1','IngLbPh');
6618: fnd_message.set_token('TAGVAL1',l_CR_IngLbPh);
6619: fnd_message.set_token('TAG2','IngLbPh');
6620: fnd_message.set_token('TAGVAL2',l_NR_IngLbPh);
6621: pay_action_information_api.create_action_information
6622: (
6615: IF l_CR_IngLbPh <> l_NR_IngLbPh THEN
6616: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6617: fnd_message.set_token('TAG1','IngLbPh');
6618: fnd_message.set_token('TAGVAL1',l_CR_IngLbPh);
6619: fnd_message.set_token('TAG2','IngLbPh');
6620: fnd_message.set_token('TAGVAL2',l_NR_IngLbPh);
6621: pay_action_information_api.create_action_information
6622: (
6623: p_action_information_id => l_action_info_id
6616: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6617: fnd_message.set_token('TAG1','IngLbPh');
6618: fnd_message.set_token('TAGVAL1',l_CR_IngLbPh);
6619: fnd_message.set_token('TAG2','IngLbPh');
6620: fnd_message.set_token('TAGVAL2',l_NR_IngLbPh);
6621: pay_action_information_api.create_action_information
6622: (
6623: p_action_information_id => l_action_info_id
6624: , p_action_context_id => p_actid
6629: , p_source_id => NULL
6630: , p_source_text => NULL
6631: , p_tax_unit_id => l_tax_unit_id
6632: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
6633: , p_action_information4 => '0003 - '||fnd_message.get
6634: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
6635: , p_action_information6 => '0003 - '||'Tag IngLbPh, (Deducted Tax). The total amount of deducted tax should be the same as the sum of the individual amounts of deducted Tax.'
6636: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
6637: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
6638: END IF;
6639: --
6640: --abraghun--7668628--Check0006
6641: IF l_CR_PrAWF <> l_NR_PrAWF THEN
6642: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6643: fnd_message.set_token('TAG1','PrAWF');
6644: fnd_message.set_token('TAGVAL1',l_CR_PrAWF);
6645: fnd_message.set_token('TAG2','PrAWF');
6646: fnd_message.set_token('TAGVAL2',l_NR_PrAWF);
6639: --
6640: --abraghun--7668628--Check0006
6641: IF l_CR_PrAWF <> l_NR_PrAWF THEN
6642: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6643: fnd_message.set_token('TAG1','PrAWF');
6644: fnd_message.set_token('TAGVAL1',l_CR_PrAWF);
6645: fnd_message.set_token('TAG2','PrAWF');
6646: fnd_message.set_token('TAGVAL2',l_NR_PrAWF);
6647: pay_action_information_api.create_action_information
6640: --abraghun--7668628--Check0006
6641: IF l_CR_PrAWF <> l_NR_PrAWF THEN
6642: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6643: fnd_message.set_token('TAG1','PrAWF');
6644: fnd_message.set_token('TAGVAL1',l_CR_PrAWF);
6645: fnd_message.set_token('TAG2','PrAWF');
6646: fnd_message.set_token('TAGVAL2',l_NR_PrAWF);
6647: pay_action_information_api.create_action_information
6648: (
6641: IF l_CR_PrAWF <> l_NR_PrAWF THEN
6642: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6643: fnd_message.set_token('TAG1','PrAWF');
6644: fnd_message.set_token('TAGVAL1',l_CR_PrAWF);
6645: fnd_message.set_token('TAG2','PrAWF');
6646: fnd_message.set_token('TAGVAL2',l_NR_PrAWF);
6647: pay_action_information_api.create_action_information
6648: (
6649: p_action_information_id => l_action_info_id
6642: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6643: fnd_message.set_token('TAG1','PrAWF');
6644: fnd_message.set_token('TAGVAL1',l_CR_PrAWF);
6645: fnd_message.set_token('TAG2','PrAWF');
6646: fnd_message.set_token('TAGVAL2',l_NR_PrAWF);
6647: pay_action_information_api.create_action_information
6648: (
6649: p_action_information_id => l_action_info_id
6650: , p_action_context_id => p_actid
6655: , p_source_id => NULL
6656: , p_source_text => NULL
6657: , p_tax_unit_id => l_tax_unit_id
6658: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
6659: , p_action_information4 => '0006 - '||fnd_message.get
6660: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
6661: , p_action_information6 => '0006 - '||'Tag PrAWF, (Total Contribution WeWe (EE+ER)). The total amount of contribution should be the same as the sum of the individual amounts of WeWe contribution employer + employee.'
6662: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
6663: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
6664: END IF;
6665: --
6666: --abraghun--7668628--Check0008
6667: IF l_CR_PrUFO <> l_NR_PrUFO THEN
6668: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6669: fnd_message.set_token('TAG1','PrUFO');
6670: fnd_message.set_token('TAGVAL1',l_CR_PrUFO);
6671: fnd_message.set_token('TAG2','PrUFO');
6672: fnd_message.set_token('TAGVAL2',l_NR_PrUFO);
6665: --
6666: --abraghun--7668628--Check0008
6667: IF l_CR_PrUFO <> l_NR_PrUFO THEN
6668: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6669: fnd_message.set_token('TAG1','PrUFO');
6670: fnd_message.set_token('TAGVAL1',l_CR_PrUFO);
6671: fnd_message.set_token('TAG2','PrUFO');
6672: fnd_message.set_token('TAGVAL2',l_NR_PrUFO);
6673: pay_action_information_api.create_action_information
6666: --abraghun--7668628--Check0008
6667: IF l_CR_PrUFO <> l_NR_PrUFO THEN
6668: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6669: fnd_message.set_token('TAG1','PrUFO');
6670: fnd_message.set_token('TAGVAL1',l_CR_PrUFO);
6671: fnd_message.set_token('TAG2','PrUFO');
6672: fnd_message.set_token('TAGVAL2',l_NR_PrUFO);
6673: pay_action_information_api.create_action_information
6674: (
6667: IF l_CR_PrUFO <> l_NR_PrUFO THEN
6668: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6669: fnd_message.set_token('TAG1','PrUFO');
6670: fnd_message.set_token('TAGVAL1',l_CR_PrUFO);
6671: fnd_message.set_token('TAG2','PrUFO');
6672: fnd_message.set_token('TAGVAL2',l_NR_PrUFO);
6673: pay_action_information_api.create_action_information
6674: (
6675: p_action_information_id => l_action_info_id
6668: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6669: fnd_message.set_token('TAG1','PrUFO');
6670: fnd_message.set_token('TAGVAL1',l_CR_PrUFO);
6671: fnd_message.set_token('TAG2','PrUFO');
6672: fnd_message.set_token('TAGVAL2',l_NR_PrUFO);
6673: pay_action_information_api.create_action_information
6674: (
6675: p_action_information_id => l_action_info_id
6676: , p_action_context_id => p_actid
6681: , p_source_id => NULL
6682: , p_source_text => NULL
6683: , p_tax_unit_id => l_tax_unit_id
6684: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
6685: , p_action_information4 => '0008 - '||fnd_message.get
6686: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
6687: , p_action_information6 => '0008 - '||'Tag PrUFO, (Contribution UFO). The total amount of contribution should be the same as the sum of the individual amounts of contribution UFO.'
6688: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
6689: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
6690: END IF;
6691: --
6692: --abraghun--7668628--Check0009
6693: IF l_CR_TotVergZvw <> l_NR_VergZvw THEN
6694: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6695: --16506014
6696: IF TO_CHAR(l_end_date,'YYYY')>=2013 THEN
6697: fnd_message.set_token('TAG1','TotWghZvw');
6698: fnd_message.set_token('TAG2','WghZvw');
6693: IF l_CR_TotVergZvw <> l_NR_VergZvw THEN
6694: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6695: --16506014
6696: IF TO_CHAR(l_end_date,'YYYY')>=2013 THEN
6697: fnd_message.set_token('TAG1','TotWghZvw');
6698: fnd_message.set_token('TAG2','WghZvw');
6699: ELSE
6700: fnd_message.set_token('TAG1','TotVergZvw');
6701: fnd_message.set_token('TAG2','VergZvw');
6694: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6695: --16506014
6696: IF TO_CHAR(l_end_date,'YYYY')>=2013 THEN
6697: fnd_message.set_token('TAG1','TotWghZvw');
6698: fnd_message.set_token('TAG2','WghZvw');
6699: ELSE
6700: fnd_message.set_token('TAG1','TotVergZvw');
6701: fnd_message.set_token('TAG2','VergZvw');
6702: END IF;
6696: IF TO_CHAR(l_end_date,'YYYY')>=2013 THEN
6697: fnd_message.set_token('TAG1','TotWghZvw');
6698: fnd_message.set_token('TAG2','WghZvw');
6699: ELSE
6700: fnd_message.set_token('TAG1','TotVergZvw');
6701: fnd_message.set_token('TAG2','VergZvw');
6702: END IF;
6703: --16506014
6704: fnd_message.set_token('TAGVAL1',l_CR_TotVergZvw);
6697: fnd_message.set_token('TAG1','TotWghZvw');
6698: fnd_message.set_token('TAG2','WghZvw');
6699: ELSE
6700: fnd_message.set_token('TAG1','TotVergZvw');
6701: fnd_message.set_token('TAG2','VergZvw');
6702: END IF;
6703: --16506014
6704: fnd_message.set_token('TAGVAL1',l_CR_TotVergZvw);
6705: fnd_message.set_token('TAGVAL2',l_NR_VergZvw);
6700: fnd_message.set_token('TAG1','TotVergZvw');
6701: fnd_message.set_token('TAG2','VergZvw');
6702: END IF;
6703: --16506014
6704: fnd_message.set_token('TAGVAL1',l_CR_TotVergZvw);
6705: fnd_message.set_token('TAGVAL2',l_NR_VergZvw);
6706: pay_action_information_api.create_action_information
6707: (
6708: p_action_information_id => l_action_info_id
6701: fnd_message.set_token('TAG2','VergZvw');
6702: END IF;
6703: --16506014
6704: fnd_message.set_token('TAGVAL1',l_CR_TotVergZvw);
6705: fnd_message.set_token('TAGVAL2',l_NR_VergZvw);
6706: pay_action_information_api.create_action_information
6707: (
6708: p_action_information_id => l_action_info_id
6709: , p_action_context_id => p_actid
6714: , p_source_id => NULL
6715: , p_source_text => NULL
6716: , p_tax_unit_id => l_tax_unit_id
6717: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
6718: , p_action_information4 => '0009 - '||fnd_message.get
6719: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
6720: , p_action_information6 => '0009 - '||'Tag TotVergZvw/TotWghZvw, (Total amount Zvw allowance). The total amount of Zvw allowance should be the same as the sum of the individual amounts of Zvw allowance.'
6721: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
6722: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
6725: /*
6726: --abraghun--7668628--Check0010
6727: IF l_CR_TotTeBet <> l_CR_TotTeBet_Sum THEN
6728:
6729: fnd_message.set_name('PER','HR_373541_NL_TOTTEBET_CHECK');
6730: fnd_message.set_token('TAGVAL1',l_CR_TotTeBet);
6731: fnd_message.set_token('TAGVAL2',l_CR_TotTeBet_Sum);
6732: pay_action_information_api.create_action_information
6733: (
6726: --abraghun--7668628--Check0010
6727: IF l_CR_TotTeBet <> l_CR_TotTeBet_Sum THEN
6728:
6729: fnd_message.set_name('PER','HR_373541_NL_TOTTEBET_CHECK');
6730: fnd_message.set_token('TAGVAL1',l_CR_TotTeBet);
6731: fnd_message.set_token('TAGVAL2',l_CR_TotTeBet_Sum);
6732: pay_action_information_api.create_action_information
6733: (
6734: p_action_information_id => l_action_info_id
6727: IF l_CR_TotTeBet <> l_CR_TotTeBet_Sum THEN
6728:
6729: fnd_message.set_name('PER','HR_373541_NL_TOTTEBET_CHECK');
6730: fnd_message.set_token('TAGVAL1',l_CR_TotTeBet);
6731: fnd_message.set_token('TAGVAL2',l_CR_TotTeBet_Sum);
6732: pay_action_information_api.create_action_information
6733: (
6734: p_action_information_id => l_action_info_id
6735: , p_action_context_id => p_actid
6740: , p_source_id => NULL
6741: , p_source_text => NULL
6742: , p_tax_unit_id => l_tax_unit_id
6743: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
6744: , p_action_information4 => '0010 - '||fnd_message.get
6745: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
6746: , p_action_information6 => '0010 - '||'Tag TotTeBet, (Total amount to be paid payroll period). The total amount should be the correct sum of the individual total amounts.'
6747: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
6748: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
6754: IF l_CR_TotGen <>fnd_number.number_to_canonical(
6755: fnd_number.canonical_to_number(l_CR_TotTeBet)+
6756: fnd_number.canonical_to_number(l_CR_Saldo_Sum)) THEN
6757:
6758: fnd_message.set_name('PER','HR_373542_NL_TOTGEN_CHECK');
6759: fnd_message.set_token('TAGVAL1',l_CR_TotGen);
6760: fnd_message.set_token('TAGVAL2',l_CR_TotTeBet);
6761: fnd_message.set_token('TAGVAL3',l_CR_Saldo_Sum);
6762:
6755: fnd_number.canonical_to_number(l_CR_TotTeBet)+
6756: fnd_number.canonical_to_number(l_CR_Saldo_Sum)) THEN
6757:
6758: fnd_message.set_name('PER','HR_373542_NL_TOTGEN_CHECK');
6759: fnd_message.set_token('TAGVAL1',l_CR_TotGen);
6760: fnd_message.set_token('TAGVAL2',l_CR_TotTeBet);
6761: fnd_message.set_token('TAGVAL3',l_CR_Saldo_Sum);
6762:
6763: pay_action_information_api.create_action_information
6756: fnd_number.canonical_to_number(l_CR_Saldo_Sum)) THEN
6757:
6758: fnd_message.set_name('PER','HR_373542_NL_TOTGEN_CHECK');
6759: fnd_message.set_token('TAGVAL1',l_CR_TotGen);
6760: fnd_message.set_token('TAGVAL2',l_CR_TotTeBet);
6761: fnd_message.set_token('TAGVAL3',l_CR_Saldo_Sum);
6762:
6763: pay_action_information_api.create_action_information
6764: (
6757:
6758: fnd_message.set_name('PER','HR_373542_NL_TOTGEN_CHECK');
6759: fnd_message.set_token('TAGVAL1',l_CR_TotGen);
6760: fnd_message.set_token('TAGVAL2',l_CR_TotTeBet);
6761: fnd_message.set_token('TAGVAL3',l_CR_Saldo_Sum);
6762:
6763: pay_action_information_api.create_action_information
6764: (
6765: p_action_information_id => l_action_info_id
6771: , p_source_id => NULL
6772: , p_source_text => NULL
6773: , p_tax_unit_id => l_tax_unit_id
6774: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
6775: , p_action_information4 => '0011 - '||fnd_message.get
6776: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
6777: , p_action_information6 => '0011 - '||'Tag TotGen, (General Total). The total amount should be the correct sum of the total amounts of the normal period and the correction periods.'
6778: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
6779: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
6781: */
6782: --
6783: --abraghun--7668628--Check0012
6784: IF l_CR_IngBijdrZvw <> l_NR_BijdrZvw THEN
6785: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6786: fnd_message.set_token('TAG1','IngBijdrZvw');
6787: fnd_message.set_token('TAGVAL1',l_CR_IngBijdrZvw);
6788: fnd_message.set_token('TAG2','BijdrZvw');
6789: fnd_message.set_token('TAGVAL2',l_NR_BijdrZvw);
6782: --
6783: --abraghun--7668628--Check0012
6784: IF l_CR_IngBijdrZvw <> l_NR_BijdrZvw THEN
6785: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6786: fnd_message.set_token('TAG1','IngBijdrZvw');
6787: fnd_message.set_token('TAGVAL1',l_CR_IngBijdrZvw);
6788: fnd_message.set_token('TAG2','BijdrZvw');
6789: fnd_message.set_token('TAGVAL2',l_NR_BijdrZvw);
6790: pay_action_information_api.create_action_information
6783: --abraghun--7668628--Check0012
6784: IF l_CR_IngBijdrZvw <> l_NR_BijdrZvw THEN
6785: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6786: fnd_message.set_token('TAG1','IngBijdrZvw');
6787: fnd_message.set_token('TAGVAL1',l_CR_IngBijdrZvw);
6788: fnd_message.set_token('TAG2','BijdrZvw');
6789: fnd_message.set_token('TAGVAL2',l_NR_BijdrZvw);
6790: pay_action_information_api.create_action_information
6791: (
6784: IF l_CR_IngBijdrZvw <> l_NR_BijdrZvw THEN
6785: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6786: fnd_message.set_token('TAG1','IngBijdrZvw');
6787: fnd_message.set_token('TAGVAL1',l_CR_IngBijdrZvw);
6788: fnd_message.set_token('TAG2','BijdrZvw');
6789: fnd_message.set_token('TAGVAL2',l_NR_BijdrZvw);
6790: pay_action_information_api.create_action_information
6791: (
6792: p_action_information_id => l_action_info_id
6785: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6786: fnd_message.set_token('TAG1','IngBijdrZvw');
6787: fnd_message.set_token('TAGVAL1',l_CR_IngBijdrZvw);
6788: fnd_message.set_token('TAG2','BijdrZvw');
6789: fnd_message.set_token('TAGVAL2',l_NR_BijdrZvw);
6790: pay_action_information_api.create_action_information
6791: (
6792: p_action_information_id => l_action_info_id
6793: , p_action_context_id => p_actid
6798: , p_source_id => NULL
6799: , p_source_text => NULL
6800: , p_tax_unit_id => l_tax_unit_id
6801: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
6802: , p_action_information4 => '0012 - '||fnd_message.get
6803: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
6804: , p_action_information6 => '0012 - '||'Tag IngBijdrZvw, (Total of deducted contribution Zvw). The total amount of contribution Zvw should be the same as the sum of the individual amounts of contribution Zvw.'
6805: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
6806: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
6807: END IF;
6808: --
6809: --abraghun--7668628--Check0016
6810: IF l_CR_PrWAOAof <> l_NR_PrWAOAof THEN
6811: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6812: fnd_message.set_token('TAG1','PrWAOAof');
6813: fnd_message.set_token('TAGVAL1',l_CR_PrWAOAof);
6814: fnd_message.set_token('TAG2','PrWAOAof');
6815: fnd_message.set_token('TAGVAL2',l_NR_PrWAOAof);
6808: --
6809: --abraghun--7668628--Check0016
6810: IF l_CR_PrWAOAof <> l_NR_PrWAOAof THEN
6811: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6812: fnd_message.set_token('TAG1','PrWAOAof');
6813: fnd_message.set_token('TAGVAL1',l_CR_PrWAOAof);
6814: fnd_message.set_token('TAG2','PrWAOAof');
6815: fnd_message.set_token('TAGVAL2',l_NR_PrWAOAof);
6816: pay_action_information_api.create_action_information
6809: --abraghun--7668628--Check0016
6810: IF l_CR_PrWAOAof <> l_NR_PrWAOAof THEN
6811: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6812: fnd_message.set_token('TAG1','PrWAOAof');
6813: fnd_message.set_token('TAGVAL1',l_CR_PrWAOAof);
6814: fnd_message.set_token('TAG2','PrWAOAof');
6815: fnd_message.set_token('TAGVAL2',l_NR_PrWAOAof);
6816: pay_action_information_api.create_action_information
6817: (
6810: IF l_CR_PrWAOAof <> l_NR_PrWAOAof THEN
6811: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6812: fnd_message.set_token('TAG1','PrWAOAof');
6813: fnd_message.set_token('TAGVAL1',l_CR_PrWAOAof);
6814: fnd_message.set_token('TAG2','PrWAOAof');
6815: fnd_message.set_token('TAGVAL2',l_NR_PrWAOAof);
6816: pay_action_information_api.create_action_information
6817: (
6818: p_action_information_id => l_action_info_id
6811: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6812: fnd_message.set_token('TAG1','PrWAOAof');
6813: fnd_message.set_token('TAGVAL1',l_CR_PrWAOAof);
6814: fnd_message.set_token('TAG2','PrWAOAof');
6815: fnd_message.set_token('TAGVAL2',l_NR_PrWAOAof);
6816: pay_action_information_api.create_action_information
6817: (
6818: p_action_information_id => l_action_info_id
6819: , p_action_context_id => p_actid
6824: , p_source_id => NULL
6825: , p_source_text => NULL
6826: , p_tax_unit_id => l_tax_unit_id
6827: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
6828: , p_action_information4 => '0016 - '||fnd_message.get
6829: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
6830: , p_action_information6 => '0016 - '||'Tag PrWAOAof, (Total contribution WAO/WGA/IVA). The total amount of contributions should be the same as the sum of the individual amounts of contribution WAO/WGA/IVA.'
6831: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
6832: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
6833: END IF;
6834: --
6835: --abraghun--7668628--Check0021
6836: IF l_CR_PrWAOAok <> l_NR_PrWAOAok THEN
6837: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6838: IF l_end_date >= to_date('01012012' ,'DDMMYYYY') THEN
6839: fnd_message.set_token('TAG1','TotPrLnWgaWhk'); --LC 2012, local variables retained
6840: ELSE
6841: fnd_message.set_token('TAG1','PrWAOAok');
6835: --abraghun--7668628--Check0021
6836: IF l_CR_PrWAOAok <> l_NR_PrWAOAok THEN
6837: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6838: IF l_end_date >= to_date('01012012' ,'DDMMYYYY') THEN
6839: fnd_message.set_token('TAG1','TotPrLnWgaWhk'); --LC 2012, local variables retained
6840: ELSE
6841: fnd_message.set_token('TAG1','PrWAOAok');
6842: END IF;
6843: fnd_message.set_token('TAGVAL1',l_CR_PrWAOAok);
6837: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6838: IF l_end_date >= to_date('01012012' ,'DDMMYYYY') THEN
6839: fnd_message.set_token('TAG1','TotPrLnWgaWhk'); --LC 2012, local variables retained
6840: ELSE
6841: fnd_message.set_token('TAG1','PrWAOAok');
6842: END IF;
6843: fnd_message.set_token('TAGVAL1',l_CR_PrWAOAok);
6844: IF l_end_date >= to_date('01012012' ,'DDMMYYYY') THEN
6845: fnd_message.set_token('TAG2','PrWgaWhk'); --LC 2012, local variables retained
6839: fnd_message.set_token('TAG1','TotPrLnWgaWhk'); --LC 2012, local variables retained
6840: ELSE
6841: fnd_message.set_token('TAG1','PrWAOAok');
6842: END IF;
6843: fnd_message.set_token('TAGVAL1',l_CR_PrWAOAok);
6844: IF l_end_date >= to_date('01012012' ,'DDMMYYYY') THEN
6845: fnd_message.set_token('TAG2','PrWgaWhk'); --LC 2012, local variables retained
6846: ELSE
6847: fnd_message.set_token('TAG2','PrWAOAok');
6841: fnd_message.set_token('TAG1','PrWAOAok');
6842: END IF;
6843: fnd_message.set_token('TAGVAL1',l_CR_PrWAOAok);
6844: IF l_end_date >= to_date('01012012' ,'DDMMYYYY') THEN
6845: fnd_message.set_token('TAG2','PrWgaWhk'); --LC 2012, local variables retained
6846: ELSE
6847: fnd_message.set_token('TAG2','PrWAOAok');
6848: END IF;
6849: fnd_message.set_token('TAGVAL2',l_NR_PrWAOAok);
6843: fnd_message.set_token('TAGVAL1',l_CR_PrWAOAok);
6844: IF l_end_date >= to_date('01012012' ,'DDMMYYYY') THEN
6845: fnd_message.set_token('TAG2','PrWgaWhk'); --LC 2012, local variables retained
6846: ELSE
6847: fnd_message.set_token('TAG2','PrWAOAok');
6848: END IF;
6849: fnd_message.set_token('TAGVAL2',l_NR_PrWAOAok);
6850: pay_action_information_api.create_action_information
6851: (
6845: fnd_message.set_token('TAG2','PrWgaWhk'); --LC 2012, local variables retained
6846: ELSE
6847: fnd_message.set_token('TAG2','PrWAOAok');
6848: END IF;
6849: fnd_message.set_token('TAGVAL2',l_NR_PrWAOAok);
6850: pay_action_information_api.create_action_information
6851: (
6852: p_action_information_id => l_action_info_id
6853: , p_action_context_id => p_actid
6858: , p_source_id => NULL
6859: , p_source_text => NULL
6860: , p_tax_unit_id => l_tax_unit_id
6861: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
6862: , p_action_information4 => '0021 - '||fnd_message.get
6863: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
6864: , p_action_information6 => '0021 - '||'Tag PrWAOAok, (Total contribution general WAO/WGA Differentiated). The total amount of contributions should be the same as the sum of the individual amounts of WAO/WGA Differentiated.'
6865: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
6866: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
6867: END IF;
6868: --
6869: --abraghun--7668628--Check0018
6870: IF l_CR_PrWgf <> l_NR_PrWgf THEN
6871: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6872: fnd_message.set_token('TAG1','PrWgf');
6873: fnd_message.set_token('TAGVAL1',l_CR_PrWgf);
6874: fnd_message.set_token('TAG2','PrWgf');
6875: fnd_message.set_token('TAGVAL2',l_NR_PrWgf);
6868: --
6869: --abraghun--7668628--Check0018
6870: IF l_CR_PrWgf <> l_NR_PrWgf THEN
6871: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6872: fnd_message.set_token('TAG1','PrWgf');
6873: fnd_message.set_token('TAGVAL1',l_CR_PrWgf);
6874: fnd_message.set_token('TAG2','PrWgf');
6875: fnd_message.set_token('TAGVAL2',l_NR_PrWgf);
6876: pay_action_information_api.create_action_information
6869: --abraghun--7668628--Check0018
6870: IF l_CR_PrWgf <> l_NR_PrWgf THEN
6871: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6872: fnd_message.set_token('TAG1','PrWgf');
6873: fnd_message.set_token('TAGVAL1',l_CR_PrWgf);
6874: fnd_message.set_token('TAG2','PrWgf');
6875: fnd_message.set_token('TAGVAL2',l_NR_PrWgf);
6876: pay_action_information_api.create_action_information
6877: (
6870: IF l_CR_PrWgf <> l_NR_PrWgf THEN
6871: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6872: fnd_message.set_token('TAG1','PrWgf');
6873: fnd_message.set_token('TAGVAL1',l_CR_PrWgf);
6874: fnd_message.set_token('TAG2','PrWgf');
6875: fnd_message.set_token('TAGVAL2',l_NR_PrWgf);
6876: pay_action_information_api.create_action_information
6877: (
6878: p_action_information_id => l_action_info_id
6871: fnd_message.set_name('PER','HR_373533_NL_TOTAL_EQUAL');
6872: fnd_message.set_token('TAG1','PrWgf');
6873: fnd_message.set_token('TAGVAL1',l_CR_PrWgf);
6874: fnd_message.set_token('TAG2','PrWgf');
6875: fnd_message.set_token('TAGVAL2',l_NR_PrWgf);
6876: pay_action_information_api.create_action_information
6877: (
6878: p_action_information_id => l_action_info_id
6879: , p_action_context_id => p_actid
6884: , p_source_id => NULL
6885: , p_source_text => NULL
6886: , p_tax_unit_id => l_tax_unit_id
6887: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
6888: , p_action_information4 => '0018 - '||fnd_message.get
6889: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
6890: , p_action_information6 => '0018 - '||'Tag PrWgf, (Total contribution waiting money fund). The total amount of contribution should be the same as the sum of the individual amounts of contribution waiting money fund.'
6891: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
6892: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
6894: --
6895: --
6896: --abraghun--7668628--Check0022
6897: FOR overlap IN csr_period_overlap(p_actid) LOOP
6898: fnd_message.set_name('PER','HR_373540_NL_PERIOD_OVERLAP');
6899: fnd_message.set_token('TAGVAL1',overlap.start_date);
6900: fnd_message.set_token('TAGVAL2',overlap.end_date);
6901: pay_action_information_api.create_action_information
6902: (
6895: --
6896: --abraghun--7668628--Check0022
6897: FOR overlap IN csr_period_overlap(p_actid) LOOP
6898: fnd_message.set_name('PER','HR_373540_NL_PERIOD_OVERLAP');
6899: fnd_message.set_token('TAGVAL1',overlap.start_date);
6900: fnd_message.set_token('TAGVAL2',overlap.end_date);
6901: pay_action_information_api.create_action_information
6902: (
6903: p_action_information_id => l_action_info_id
6896: --abraghun--7668628--Check0022
6897: FOR overlap IN csr_period_overlap(p_actid) LOOP
6898: fnd_message.set_name('PER','HR_373540_NL_PERIOD_OVERLAP');
6899: fnd_message.set_token('TAGVAL1',overlap.start_date);
6900: fnd_message.set_token('TAGVAL2',overlap.end_date);
6901: pay_action_information_api.create_action_information
6902: (
6903: p_action_information_id => l_action_info_id
6904: , p_action_context_id => p_actid
6909: , p_source_id => NULL
6910: , p_source_text => NULL
6911: , p_tax_unit_id => l_tax_unit_id
6912: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
6913: , p_action_information4 => '0022 - '||fnd_message.get
6914: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
6915: , p_action_information6 => '0022 - '||'The start and end dates of the correction period cannot be the same as the start and end dates of the normal period.'
6916: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
6917: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
6918: END LOOP;
6919: --
6920: --abraghun--7668628--Check0025
6921: IF l_CR_PrLnWAOAof > l_CR_PrLnWAOAok THEN
6922: fnd_message.set_name('PER','HR_373536_NL_TOTAL_LTEQ');
6923: fnd_message.set_token('TAG1','PrLnWAOAof');
6924: fnd_message.set_token('TAGVAL1',l_CR_PrLnWAOAof);
6925: IF l_end_date >= to_date('01012012' ,'DDMMYYYY') THEN
6926: fnd_message.set_token('TAG2','TotPrLnWgaWhk'); --LC 2012, local variables retained
6919: --
6920: --abraghun--7668628--Check0025
6921: IF l_CR_PrLnWAOAof > l_CR_PrLnWAOAok THEN
6922: fnd_message.set_name('PER','HR_373536_NL_TOTAL_LTEQ');
6923: fnd_message.set_token('TAG1','PrLnWAOAof');
6924: fnd_message.set_token('TAGVAL1',l_CR_PrLnWAOAof);
6925: IF l_end_date >= to_date('01012012' ,'DDMMYYYY') THEN
6926: fnd_message.set_token('TAG2','TotPrLnWgaWhk'); --LC 2012, local variables retained
6927: ELSE
6920: --abraghun--7668628--Check0025
6921: IF l_CR_PrLnWAOAof > l_CR_PrLnWAOAok THEN
6922: fnd_message.set_name('PER','HR_373536_NL_TOTAL_LTEQ');
6923: fnd_message.set_token('TAG1','PrLnWAOAof');
6924: fnd_message.set_token('TAGVAL1',l_CR_PrLnWAOAof);
6925: IF l_end_date >= to_date('01012012' ,'DDMMYYYY') THEN
6926: fnd_message.set_token('TAG2','TotPrLnWgaWhk'); --LC 2012, local variables retained
6927: ELSE
6928: fnd_message.set_token('TAG2','PrLnWAOAok');
6922: fnd_message.set_name('PER','HR_373536_NL_TOTAL_LTEQ');
6923: fnd_message.set_token('TAG1','PrLnWAOAof');
6924: fnd_message.set_token('TAGVAL1',l_CR_PrLnWAOAof);
6925: IF l_end_date >= to_date('01012012' ,'DDMMYYYY') THEN
6926: fnd_message.set_token('TAG2','TotPrLnWgaWhk'); --LC 2012, local variables retained
6927: ELSE
6928: fnd_message.set_token('TAG2','PrLnWAOAok');
6929: END IF;
6930: fnd_message.set_token('TAGVAL2',l_CR_PrLnWAOAok);
6924: fnd_message.set_token('TAGVAL1',l_CR_PrLnWAOAof);
6925: IF l_end_date >= to_date('01012012' ,'DDMMYYYY') THEN
6926: fnd_message.set_token('TAG2','TotPrLnWgaWhk'); --LC 2012, local variables retained
6927: ELSE
6928: fnd_message.set_token('TAG2','PrLnWAOAok');
6929: END IF;
6930: fnd_message.set_token('TAGVAL2',l_CR_PrLnWAOAok);
6931: pay_action_information_api.create_action_information
6932: (
6926: fnd_message.set_token('TAG2','TotPrLnWgaWhk'); --LC 2012, local variables retained
6927: ELSE
6928: fnd_message.set_token('TAG2','PrLnWAOAok');
6929: END IF;
6930: fnd_message.set_token('TAGVAL2',l_CR_PrLnWAOAok);
6931: pay_action_information_api.create_action_information
6932: (
6933: p_action_information_id => l_action_info_id
6934: , p_action_context_id => p_actid
6939: , p_source_id => NULL
6940: , p_source_text => NULL
6941: , p_tax_unit_id => l_tax_unit_id
6942: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
6943: , p_action_information4 => '0025 - '||fnd_message.get
6944: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
6945: , p_action_information6 => '0025 - '||'The total amount of "Contribution base WAO/IVA/WGA" (Tag PrLnWAOAof) has to be equal to or less than the total amount of "Contribution base general WAO/WGA Differentiated" (Tag PrLnWAOAok).'
6946: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
6947: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
6949: --
6950:
6951: --abraghun--7668628--Check0029
6952: IF l_CR_PrLnAWF > l_SWMF_PrLnWgf THEN
6953: fnd_message.set_name('PER','HR_373536_NL_TOTAL_LTEQ');
6954: fnd_message.set_token('TAG1','PrLnAWF');
6955: fnd_message.set_token('TAGVAL1',l_CR_PrLnAWF );
6956: fnd_message.set_token('TAG2','PrLnWgf');
6957: fnd_message.set_token('TAGVAL2',l_SWMF_PrLnWgf);
6950:
6951: --abraghun--7668628--Check0029
6952: IF l_CR_PrLnAWF > l_SWMF_PrLnWgf THEN
6953: fnd_message.set_name('PER','HR_373536_NL_TOTAL_LTEQ');
6954: fnd_message.set_token('TAG1','PrLnAWF');
6955: fnd_message.set_token('TAGVAL1',l_CR_PrLnAWF );
6956: fnd_message.set_token('TAG2','PrLnWgf');
6957: fnd_message.set_token('TAGVAL2',l_SWMF_PrLnWgf);
6958: pay_action_information_api.create_action_information
6951: --abraghun--7668628--Check0029
6952: IF l_CR_PrLnAWF > l_SWMF_PrLnWgf THEN
6953: fnd_message.set_name('PER','HR_373536_NL_TOTAL_LTEQ');
6954: fnd_message.set_token('TAG1','PrLnAWF');
6955: fnd_message.set_token('TAGVAL1',l_CR_PrLnAWF );
6956: fnd_message.set_token('TAG2','PrLnWgf');
6957: fnd_message.set_token('TAGVAL2',l_SWMF_PrLnWgf);
6958: pay_action_information_api.create_action_information
6959: (
6952: IF l_CR_PrLnAWF > l_SWMF_PrLnWgf THEN
6953: fnd_message.set_name('PER','HR_373536_NL_TOTAL_LTEQ');
6954: fnd_message.set_token('TAG1','PrLnAWF');
6955: fnd_message.set_token('TAGVAL1',l_CR_PrLnAWF );
6956: fnd_message.set_token('TAG2','PrLnWgf');
6957: fnd_message.set_token('TAGVAL2',l_SWMF_PrLnWgf);
6958: pay_action_information_api.create_action_information
6959: (
6960: p_action_information_id => l_action_info_id
6953: fnd_message.set_name('PER','HR_373536_NL_TOTAL_LTEQ');
6954: fnd_message.set_token('TAG1','PrLnAWF');
6955: fnd_message.set_token('TAGVAL1',l_CR_PrLnAWF );
6956: fnd_message.set_token('TAG2','PrLnWgf');
6957: fnd_message.set_token('TAGVAL2',l_SWMF_PrLnWgf);
6958: pay_action_information_api.create_action_information
6959: (
6960: p_action_information_id => l_action_info_id
6961: , p_action_context_id => p_actid
6966: , p_source_id => NULL
6967: , p_source_text => NULL
6968: , p_tax_unit_id => l_tax_unit_id
6969: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
6970: , p_action_information4 => '0029 - '||fnd_message.get
6971: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
6972: , p_action_information6 => '0029 - '||'The total amount of "Contribution base WeWe (AWF)" (Tag PrLnAWF) has to be equal to or less than the sum of the total amounts of "Contribution base Waiting money fund" (Tag PrLnWgf).'
6973: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
6974: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
6976: --
6977:
6978: --abraghun--7668628--Check0026
6979: IF l_CR_PrWAOAof> 0 AND l_CR_PrLnWAOAof= 0 THEN
6980: fnd_message.set_name('PER','HR_373534_NL_TOTAL_GT_ZERO');
6981: fnd_message.set_token('TAG1','PrWAOAof');
6982: fnd_message.set_token('TAGVAL1',l_CR_PrWAOAof);
6983: fnd_message.set_token('TAG2','PrLnWAOAof');
6984:
6977:
6978: --abraghun--7668628--Check0026
6979: IF l_CR_PrWAOAof> 0 AND l_CR_PrLnWAOAof= 0 THEN
6980: fnd_message.set_name('PER','HR_373534_NL_TOTAL_GT_ZERO');
6981: fnd_message.set_token('TAG1','PrWAOAof');
6982: fnd_message.set_token('TAGVAL1',l_CR_PrWAOAof);
6983: fnd_message.set_token('TAG2','PrLnWAOAof');
6984:
6985: pay_action_information_api.create_action_information
6978: --abraghun--7668628--Check0026
6979: IF l_CR_PrWAOAof> 0 AND l_CR_PrLnWAOAof= 0 THEN
6980: fnd_message.set_name('PER','HR_373534_NL_TOTAL_GT_ZERO');
6981: fnd_message.set_token('TAG1','PrWAOAof');
6982: fnd_message.set_token('TAGVAL1',l_CR_PrWAOAof);
6983: fnd_message.set_token('TAG2','PrLnWAOAof');
6984:
6985: pay_action_information_api.create_action_information
6986: (
6979: IF l_CR_PrWAOAof> 0 AND l_CR_PrLnWAOAof= 0 THEN
6980: fnd_message.set_name('PER','HR_373534_NL_TOTAL_GT_ZERO');
6981: fnd_message.set_token('TAG1','PrWAOAof');
6982: fnd_message.set_token('TAGVAL1',l_CR_PrWAOAof);
6983: fnd_message.set_token('TAG2','PrLnWAOAof');
6984:
6985: pay_action_information_api.create_action_information
6986: (
6987: p_action_information_id => l_action_info_id
6993: , p_source_id => NULL
6994: , p_source_text => NULL
6995: , p_tax_unit_id => l_tax_unit_id
6996: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
6997: , p_action_information4 => '0026 - '||fnd_message.get
6998: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
6999: , p_action_information6 => '0026 - '||'When the amount of "Total contribution WAO/WGA/IVA" (Tag PrWAOAof) is greater than zero, the amount of "Contribution base WAO/IVA/WGA" (Tag PrLnWAOAof) cannot be equal to zero.'
7000: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
7001: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
7002: END IF;
7003: --
7004: --abraghun--7668628--Check0028
7005: IF l_CR_PrWAOAok > 0 AND l_CR_PrLnWAOAok = 0 THEN
7006: fnd_message.set_name('PER','HR_373534_NL_TOTAL_GT_ZERO');
7007: IF l_end_date >= to_date('01012012' ,'DDMMYYYY') THEN
7008: fnd_message.set_token('TAG1','TotPrWgaWhk'); --LC 2012, local variables retained
7009: ELSE
7010: fnd_message.set_token('TAG1','PrWAOAok');
7004: --abraghun--7668628--Check0028
7005: IF l_CR_PrWAOAok > 0 AND l_CR_PrLnWAOAok = 0 THEN
7006: fnd_message.set_name('PER','HR_373534_NL_TOTAL_GT_ZERO');
7007: IF l_end_date >= to_date('01012012' ,'DDMMYYYY') THEN
7008: fnd_message.set_token('TAG1','TotPrWgaWhk'); --LC 2012, local variables retained
7009: ELSE
7010: fnd_message.set_token('TAG1','PrWAOAok');
7011: END IF;
7012: fnd_message.set_token('TAGVAL1',l_CR_PrWAOAok);
7006: fnd_message.set_name('PER','HR_373534_NL_TOTAL_GT_ZERO');
7007: IF l_end_date >= to_date('01012012' ,'DDMMYYYY') THEN
7008: fnd_message.set_token('TAG1','TotPrWgaWhk'); --LC 2012, local variables retained
7009: ELSE
7010: fnd_message.set_token('TAG1','PrWAOAok');
7011: END IF;
7012: fnd_message.set_token('TAGVAL1',l_CR_PrWAOAok);
7013: IF l_end_date >= to_date('01012012' ,'DDMMYYYY') THEN
7014: fnd_message.set_token('TAG2','TotPrLnWgaWhk'); --LC 2012, local variables retained
7008: fnd_message.set_token('TAG1','TotPrWgaWhk'); --LC 2012, local variables retained
7009: ELSE
7010: fnd_message.set_token('TAG1','PrWAOAok');
7011: END IF;
7012: fnd_message.set_token('TAGVAL1',l_CR_PrWAOAok);
7013: IF l_end_date >= to_date('01012012' ,'DDMMYYYY') THEN
7014: fnd_message.set_token('TAG2','TotPrLnWgaWhk'); --LC 2012, local variables retained
7015: ELSE
7016: fnd_message.set_token('TAG2','PrLnWAOAok');
7010: fnd_message.set_token('TAG1','PrWAOAok');
7011: END IF;
7012: fnd_message.set_token('TAGVAL1',l_CR_PrWAOAok);
7013: IF l_end_date >= to_date('01012012' ,'DDMMYYYY') THEN
7014: fnd_message.set_token('TAG2','TotPrLnWgaWhk'); --LC 2012, local variables retained
7015: ELSE
7016: fnd_message.set_token('TAG2','PrLnWAOAok');
7017: END IF;
7018: pay_action_information_api.create_action_information
7012: fnd_message.set_token('TAGVAL1',l_CR_PrWAOAok);
7013: IF l_end_date >= to_date('01012012' ,'DDMMYYYY') THEN
7014: fnd_message.set_token('TAG2','TotPrLnWgaWhk'); --LC 2012, local variables retained
7015: ELSE
7016: fnd_message.set_token('TAG2','PrLnWAOAok');
7017: END IF;
7018: pay_action_information_api.create_action_information
7019: (
7020: p_action_information_id => l_action_info_id
7026: , p_source_id => NULL
7027: , p_source_text => NULL
7028: , p_tax_unit_id => l_tax_unit_id
7029: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
7030: , p_action_information4 => '0028 - '||fnd_message.get
7031: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
7032: , p_action_information6 => '0028 - '||'When the amount of "Total contribution general WAO/WGA Differentiated" (Tag PrWAOAok) is greater than zero,'||
7033: ' the amount of "Contribution base general WAO/WGA Differentiated" (Tag PrLnWAOAok) cannot be equal to zero.'
7034: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
7036: END IF;
7037: --
7038: --abraghun--7668628--Check0030
7039: IF l_CR_PrAWF > 0 AND l_CR_PrLnAWF = 0 THEN
7040: fnd_message.set_name('PER','HR_373534_NL_TOTAL_GT_ZERO');
7041: fnd_message.set_token('TAG1','PrAWF');
7042: fnd_message.set_token('TAGVAL1',l_CR_PrAWF);
7043: fnd_message.set_token('TAG2','PrLnAWF');
7044: pay_action_information_api.create_action_information
7037: --
7038: --abraghun--7668628--Check0030
7039: IF l_CR_PrAWF > 0 AND l_CR_PrLnAWF = 0 THEN
7040: fnd_message.set_name('PER','HR_373534_NL_TOTAL_GT_ZERO');
7041: fnd_message.set_token('TAG1','PrAWF');
7042: fnd_message.set_token('TAGVAL1',l_CR_PrAWF);
7043: fnd_message.set_token('TAG2','PrLnAWF');
7044: pay_action_information_api.create_action_information
7045: (
7038: --abraghun--7668628--Check0030
7039: IF l_CR_PrAWF > 0 AND l_CR_PrLnAWF = 0 THEN
7040: fnd_message.set_name('PER','HR_373534_NL_TOTAL_GT_ZERO');
7041: fnd_message.set_token('TAG1','PrAWF');
7042: fnd_message.set_token('TAGVAL1',l_CR_PrAWF);
7043: fnd_message.set_token('TAG2','PrLnAWF');
7044: pay_action_information_api.create_action_information
7045: (
7046: p_action_information_id => l_action_info_id
7039: IF l_CR_PrAWF > 0 AND l_CR_PrLnAWF = 0 THEN
7040: fnd_message.set_name('PER','HR_373534_NL_TOTAL_GT_ZERO');
7041: fnd_message.set_token('TAG1','PrAWF');
7042: fnd_message.set_token('TAGVAL1',l_CR_PrAWF);
7043: fnd_message.set_token('TAG2','PrLnAWF');
7044: pay_action_information_api.create_action_information
7045: (
7046: p_action_information_id => l_action_info_id
7047: , p_action_context_id => p_actid
7052: , p_source_id => NULL
7053: , p_source_text => NULL
7054: , p_tax_unit_id => l_tax_unit_id
7055: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
7056: , p_action_information4 => '0030 - '||fnd_message.get
7057: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
7058: , p_action_information6 => '0030 - '||'When the amount of "Total Contribution WeWe (AWF)" (Tag PrAWF) is greater than zero, the amount of "Contribution base WeWe (AWF)" (Tag PrLnAWF) cannot be equal to zero.'
7059: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
7060: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
7061: END IF;
7062: --
7063: --abraghun--7668628--Check0031
7064: IF l_CR_PrUFO > 0 AND l_CR_PrLnUFO = 0 THEN
7065: fnd_message.set_name('PER','HR_373534_NL_TOTAL_GT_ZERO');
7066: fnd_message.set_token('TAG1','PrUFO');
7067: fnd_message.set_token('TAGVAL1',l_CR_PrUFO);
7068: fnd_message.set_token('TAG2','PrLnUFO');
7069: pay_action_information_api.create_action_information
7062: --
7063: --abraghun--7668628--Check0031
7064: IF l_CR_PrUFO > 0 AND l_CR_PrLnUFO = 0 THEN
7065: fnd_message.set_name('PER','HR_373534_NL_TOTAL_GT_ZERO');
7066: fnd_message.set_token('TAG1','PrUFO');
7067: fnd_message.set_token('TAGVAL1',l_CR_PrUFO);
7068: fnd_message.set_token('TAG2','PrLnUFO');
7069: pay_action_information_api.create_action_information
7070: (
7063: --abraghun--7668628--Check0031
7064: IF l_CR_PrUFO > 0 AND l_CR_PrLnUFO = 0 THEN
7065: fnd_message.set_name('PER','HR_373534_NL_TOTAL_GT_ZERO');
7066: fnd_message.set_token('TAG1','PrUFO');
7067: fnd_message.set_token('TAGVAL1',l_CR_PrUFO);
7068: fnd_message.set_token('TAG2','PrLnUFO');
7069: pay_action_information_api.create_action_information
7070: (
7071: p_action_information_id => l_action_info_id
7064: IF l_CR_PrUFO > 0 AND l_CR_PrLnUFO = 0 THEN
7065: fnd_message.set_name('PER','HR_373534_NL_TOTAL_GT_ZERO');
7066: fnd_message.set_token('TAG1','PrUFO');
7067: fnd_message.set_token('TAGVAL1',l_CR_PrUFO);
7068: fnd_message.set_token('TAG2','PrLnUFO');
7069: pay_action_information_api.create_action_information
7070: (
7071: p_action_information_id => l_action_info_id
7072: , p_action_context_id => p_actid
7077: , p_source_id => NULL
7078: , p_source_text => NULL
7079: , p_tax_unit_id => l_tax_unit_id
7080: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
7081: , p_action_information4 => '0031 - '||fnd_message.get
7082: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
7083: , p_action_information6 => '0031 - '||'When the amount of "Total contribution UFO" (Tag PrUFO) is greater than zero, the amount of "Contribution base UFO" (Tag PrLnUFO) cannot be equal to zero.'
7084: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
7085: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
7086: END IF;
7087: --
7088: --abraghun--7668628--Check0035
7089: IF l_CR_PrWgf >0 AND l_SWMF_PrLnWgf=0 THEN
7090: fnd_message.set_name('PER','HR_373534_NL_TOTAL_GT_ZERO');
7091: fnd_message.set_token('TAG1','PrWgf');
7092: fnd_message.set_token('TAGVAL1',l_CR_PrWgf);
7093: fnd_message.set_token('TAG2','PrLnWgf');
7094: pay_action_information_api.create_action_information
7087: --
7088: --abraghun--7668628--Check0035
7089: IF l_CR_PrWgf >0 AND l_SWMF_PrLnWgf=0 THEN
7090: fnd_message.set_name('PER','HR_373534_NL_TOTAL_GT_ZERO');
7091: fnd_message.set_token('TAG1','PrWgf');
7092: fnd_message.set_token('TAGVAL1',l_CR_PrWgf);
7093: fnd_message.set_token('TAG2','PrLnWgf');
7094: pay_action_information_api.create_action_information
7095: (
7088: --abraghun--7668628--Check0035
7089: IF l_CR_PrWgf >0 AND l_SWMF_PrLnWgf=0 THEN
7090: fnd_message.set_name('PER','HR_373534_NL_TOTAL_GT_ZERO');
7091: fnd_message.set_token('TAG1','PrWgf');
7092: fnd_message.set_token('TAGVAL1',l_CR_PrWgf);
7093: fnd_message.set_token('TAG2','PrLnWgf');
7094: pay_action_information_api.create_action_information
7095: (
7096: p_action_information_id => l_action_info_id
7089: IF l_CR_PrWgf >0 AND l_SWMF_PrLnWgf=0 THEN
7090: fnd_message.set_name('PER','HR_373534_NL_TOTAL_GT_ZERO');
7091: fnd_message.set_token('TAG1','PrWgf');
7092: fnd_message.set_token('TAGVAL1',l_CR_PrWgf);
7093: fnd_message.set_token('TAG2','PrLnWgf');
7094: pay_action_information_api.create_action_information
7095: (
7096: p_action_information_id => l_action_info_id
7097: , p_action_context_id => p_actid
7102: , p_source_id => NULL
7103: , p_source_text => NULL
7104: , p_tax_unit_id => l_tax_unit_id
7105: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
7106: , p_action_information4 => '0035 - '||fnd_message.get
7107: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
7108: , p_action_information6 => '0035 - '||'When the amount of "Total contribution waiting money fund" (Tag PrWgf) is greater than zero, the amount of "Contribution base Waiting money fund" (Tag PrLnWgf) cannot be equal to zero.'
7109: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
7110: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
7829: , p_source_id => NULL
7830: , p_source_text => NULL
7831: , p_tax_unit_id => p_tax_unit_id
7832: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
7833: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_STREET')
7834: , p_action_information5 => fnd_date.date_to_canonical(p_eff_date)
7835: , p_action_information6 => 'Street name missing in the address'
7836: , p_action_information7 => p_name
7837: , p_action_information8 => p_assignment_number);
7849: , p_source_id => NULL
7850: , p_source_text => NULL
7851: , p_tax_unit_id => p_tax_unit_id
7852: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
7853: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_CITY')
7854: , p_action_information5 => fnd_date.date_to_canonical(p_eff_date)
7855: , p_action_information6 => 'City name missing in the address'
7856: , p_action_information7 => p_name
7857: , p_action_information8 => p_assignment_number);
7869: , p_source_id => NULL
7870: , p_source_text => NULL
7871: , p_tax_unit_id => p_tax_unit_id
7872: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
7873: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_PO_CODE')
7874: , p_action_information5 => fnd_date.date_to_canonical(p_eff_date)
7875: , p_action_information6 => 'Postal Code missing in address'
7876: , p_action_information7 => p_name
7877: , p_action_information8 => p_assignment_number);
7889: , p_source_id => NULL
7890: , p_source_text => NULL
7891: , p_tax_unit_id => p_tax_unit_id
7892: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
7893: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_COUNTRY')
7894: , p_action_information5 => fnd_date.date_to_canonical(p_eff_date)
7895: , p_action_information6 => 'Country is missing in address'
7896: , p_action_information7 => p_name
7897: , p_action_information8 => p_assignment_number);
7918: , p_source_id => NULL
7919: , p_source_text => NULL
7920: , p_tax_unit_id => p_tax_unit_id
7921: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
7922: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_PO_FORMAT')
7923: , p_action_information5 => fnd_date.date_to_canonical(p_eff_date)
7924: , p_action_information6 => 'Postal Code is not in the format 9999XX'
7925: , p_action_information7 => p_name
7926: , p_action_information8 => p_assignment_number);
8107: , p_source_id => NULL
8108: , p_source_text => NULL
8109: , p_tax_unit_id => p_tax_unit_id
8110: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
8111: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_ADDRESS')
8112: , p_action_information5 => fnd_date.date_to_canonical(p_eff_date)
8113: , p_action_information6 => 'Address details are null'
8114: , p_action_information7 => p_name
8115: , p_action_information8 => p_assignment_number);
8589: , p_source_id => NULL
8590: , p_source_text => NULL
8591: , p_tax_unit_id => p_tax_unit_id
8592: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
8593: , p_action_information4 => fnd_message.get_string('PER','HR_NL_UFO_AND_AWF')
8594: , p_action_information5 => fnd_date.date_to_canonical(p_date)
8595: , p_action_information6 => 'UFO Contributions and AWF Contributions exist'
8596: , p_action_information7 => p_name
8597: , p_action_information8 => p_assignment_id);
8609: , p_source_id => NULL
8610: , p_source_text => NULL
8611: , p_tax_unit_id => p_tax_unit_id
8612: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
8613: , p_action_information4 => fnd_message.get_string('PER','HR_NL_ZERO_WEWA')
8614: , p_action_information5 => fnd_date.date_to_canonical(p_date)
8615: , p_action_information6 => 'Waiting Money Fund contribution is zero'
8616: , p_action_information7 => p_name
8617: , p_action_information8 => p_assignment_id);
8629: , p_source_id => NULL
8630: , p_source_text => NULL
8631: , p_tax_unit_id => p_tax_unit_id
8632: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
8633: , p_action_information4 => fnd_message.get_string('PER','HR_NL_ZERO_WEWE')
8634: , p_action_information5 => fnd_date.date_to_canonical(p_date)
8635: , p_action_information6 => 'AWF contribution is zero'
8636: , p_action_information7 => p_name
8637: , p_action_information8 => p_assignment_id);
10711: , p_source_id => NULL
10712: , p_source_text => NULL
10713: , p_tax_unit_id => l_tax_unit_id
10714: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
10715: , p_action_information4 => fnd_message.get_string('PER','HR_373547_NUMIV_OVERRIDE')
10716: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
10717: , p_action_information6 => 'Num IV override Already Used'
10718: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
10719: , p_action_information8 => l_emp_rec.assignment_number);
10836: , p_source_id => NULL
10837: , p_source_text => NULL
10838: , p_tax_unit_id => l_tax_unit_id
10839: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
10840: , p_action_information4 => fnd_message.get_string('PER','HR_373547_NUMIV_OVERRIDE')
10841: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
10842: , p_action_information6 => 'Num IV override Already Used'
10843: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
10844: , p_action_information8 => l_emp_rec.assignment_number);
11598: , p_source_id => NULL
11599: , p_source_text => NULL
11600: , p_tax_unit_id => l_tax_unit_id
11601: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
11602: , p_action_information4 => fnd_message.get_string('PER','HR_373547_NUMIV_OVERRIDE')
11603: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
11604: , p_action_information6 => 'Num IV override Already Used'
11605: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
11606: , p_action_information8 => l_emp_rec.assignment_number);
11620: , p_source_id => NULL
11621: , p_source_text => NULL
11622: , p_tax_unit_id => l_tax_unit_id
11623: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
11624: , p_action_information4 => '0044/1044 - '||fnd_message.get_string('PER','HR_373537_NL_EMPNO_MANDATORY')
11625: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
11626: , p_action_information6 => '0044/1044 - '||'When the "BSN/Sofi-number" (Tag SofiNr) is not reported the record "Employee number" (Tag PersNr) is mandatory.'
11627: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
11628: , p_action_information8 => l_emp_rec.assignment_number);
11631:
11632:
11633: --abraghun--7668628--Check0046 Check0047 Check0048 Check0049
11634: IF l_emp_rec.sofi_number is not null AND l_wage_tax_table <> 940 THEN
11635: fnd_message.set_name('PER','HR_373535_NL_NON940_MANDATORY');
11636:
11637: --abraghun--7668628--Check0046
11638: IF l_emp_rec.last_name is null THEN
11639: --
11636:
11637: --abraghun--7668628--Check0046
11638: IF l_emp_rec.last_name is null THEN
11639: --
11640: fnd_message.set_token('TAGVAL1',l_wage_tax_table);
11641: fnd_message.set_token('TAG2','SignNm');
11642:
11643: pay_action_information_api.create_action_information
11644: (
11637: --abraghun--7668628--Check0046
11638: IF l_emp_rec.last_name is null THEN
11639: --
11640: fnd_message.set_token('TAGVAL1',l_wage_tax_table);
11641: fnd_message.set_token('TAG2','SignNm');
11642:
11643: pay_action_information_api.create_action_information
11644: (
11645: p_action_information_id => l_action_info_id
11651: , p_source_id => NULL
11652: , p_source_text => NULL
11653: , p_tax_unit_id => l_tax_unit_id
11654: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
11655: , p_action_information4 => '0046 - '||fnd_message.get
11656: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
11657: , p_action_information6 => '0046 - '||'When "BSN/Sofi-number" (Tag SofiNr) is reported and "Code wage tax table" (Tag LbTab) is not equal to 940 the "Last Name" (Tag SignNm) cannot be empty / is mandatory.'
11658: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
11659: , p_action_information8 => l_emp_rec.assignment_number);
11662:
11663: --abraghun--7668628--Check0047
11664: IF l_emp_rec.dob is null THEN
11665: --
11666: fnd_message.set_token('TAGVAL1',l_wage_tax_table);
11667: fnd_message.set_token('TAG2','Gebdat');
11668:
11669: pay_action_information_api.create_action_information
11670: (
11663: --abraghun--7668628--Check0047
11664: IF l_emp_rec.dob is null THEN
11665: --
11666: fnd_message.set_token('TAGVAL1',l_wage_tax_table);
11667: fnd_message.set_token('TAG2','Gebdat');
11668:
11669: pay_action_information_api.create_action_information
11670: (
11671: p_action_information_id => l_action_info_id
11677: , p_source_id => NULL
11678: , p_source_text => NULL
11679: , p_tax_unit_id => l_tax_unit_id
11680: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
11681: , p_action_information4 => '0047 - '||fnd_message.get
11682: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
11683: , p_action_information6 => '0047 - '||'When "BSN/Sofi-number" (Tag SofiNr) is reported and "Code wage tax table" (Tag LbTab) is not equal to 940 the "Date of birth" (Tag Gebdat) cannot be empty / is mandatory.'
11684: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
11685: , p_action_information8 => l_emp_rec.assignment_number);
11688:
11689: --abraghun--7668628--Check0048
11690: IF l_nationality is null THEN
11691: --
11692: fnd_message.set_token('TAGVAL1',l_wage_tax_table);
11693: fnd_message.set_token('TAG2','Nat');
11694:
11695: pay_action_information_api.create_action_information
11696: (
11689: --abraghun--7668628--Check0048
11690: IF l_nationality is null THEN
11691: --
11692: fnd_message.set_token('TAGVAL1',l_wage_tax_table);
11693: fnd_message.set_token('TAG2','Nat');
11694:
11695: pay_action_information_api.create_action_information
11696: (
11697: p_action_information_id => l_action_info_id
11703: , p_source_id => NULL
11704: , p_source_text => NULL
11705: , p_tax_unit_id => l_tax_unit_id
11706: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
11707: , p_action_information4 => '0048 - '||fnd_message.get
11708: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
11709: , p_action_information6 => '0048 - '||'When "BSN/Sofi-number" (Tag SofiNr) is reported and "Code wage tax table" (Tag LbTab) is not equal to 940 the "Nationality" (Tag Nat) cannot be empty / is mandatory.'
11710: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
11711: , p_action_information8 => l_emp_rec.assignment_number);
11714:
11715: --abraghun--7668628--Check0049
11716: IF l_emp_rec.gender is null THEN
11717: --
11718: fnd_message.set_token('TAGVAL1',l_wage_tax_table);
11719: fnd_message.set_token('TAG2','Gesl');
11720:
11721: pay_action_information_api.create_action_information
11722: (
11715: --abraghun--7668628--Check0049
11716: IF l_emp_rec.gender is null THEN
11717: --
11718: fnd_message.set_token('TAGVAL1',l_wage_tax_table);
11719: fnd_message.set_token('TAG2','Gesl');
11720:
11721: pay_action_information_api.create_action_information
11722: (
11723: p_action_information_id => l_action_info_id
11729: , p_source_id => NULL
11730: , p_source_text => NULL
11731: , p_tax_unit_id => l_tax_unit_id
11732: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
11733: , p_action_information4 => '0049 - '||fnd_message.get
11734: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
11735: , p_action_information6 => '0049 - '||'When "BSN/Sofi-number" (Tag SofiNr) is reported and "Code wage tax table" (Tag LbTab) is not equal to 940 the "Gender" (Tag Gesl) cannot be empty / is mandatory.'
11736: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
11737: , p_action_information8 => l_emp_rec.assignment_number);
11740: END IF;
11741: --
11742: --abraghun--7668628--Check0039
11743: IF l_ass_start_date > l_period_end_date THEN
11744: fnd_message.set_name('PER','HR_373543_NL_DATE_LTEQ');
11745: fnd_message.set_token('TAG1','DatAanv');
11746: fnd_message.set_token('TAGVAL1',fnd_date.date_to_canonical(l_ass_start_date));
11747: fnd_message.set_token('TAG2','DatEindTv');
11748: fnd_message.set_token('TAGVAL2',fnd_date.date_to_canonical(l_period_end_date));
11741: --
11742: --abraghun--7668628--Check0039
11743: IF l_ass_start_date > l_period_end_date THEN
11744: fnd_message.set_name('PER','HR_373543_NL_DATE_LTEQ');
11745: fnd_message.set_token('TAG1','DatAanv');
11746: fnd_message.set_token('TAGVAL1',fnd_date.date_to_canonical(l_ass_start_date));
11747: fnd_message.set_token('TAG2','DatEindTv');
11748: fnd_message.set_token('TAGVAL2',fnd_date.date_to_canonical(l_period_end_date));
11749: --
11742: --abraghun--7668628--Check0039
11743: IF l_ass_start_date > l_period_end_date THEN
11744: fnd_message.set_name('PER','HR_373543_NL_DATE_LTEQ');
11745: fnd_message.set_token('TAG1','DatAanv');
11746: fnd_message.set_token('TAGVAL1',fnd_date.date_to_canonical(l_ass_start_date));
11747: fnd_message.set_token('TAG2','DatEindTv');
11748: fnd_message.set_token('TAGVAL2',fnd_date.date_to_canonical(l_period_end_date));
11749: --
11750: pay_action_information_api.create_action_information
11743: IF l_ass_start_date > l_period_end_date THEN
11744: fnd_message.set_name('PER','HR_373543_NL_DATE_LTEQ');
11745: fnd_message.set_token('TAG1','DatAanv');
11746: fnd_message.set_token('TAGVAL1',fnd_date.date_to_canonical(l_ass_start_date));
11747: fnd_message.set_token('TAG2','DatEindTv');
11748: fnd_message.set_token('TAGVAL2',fnd_date.date_to_canonical(l_period_end_date));
11749: --
11750: pay_action_information_api.create_action_information
11751: (
11744: fnd_message.set_name('PER','HR_373543_NL_DATE_LTEQ');
11745: fnd_message.set_token('TAG1','DatAanv');
11746: fnd_message.set_token('TAGVAL1',fnd_date.date_to_canonical(l_ass_start_date));
11747: fnd_message.set_token('TAG2','DatEindTv');
11748: fnd_message.set_token('TAGVAL2',fnd_date.date_to_canonical(l_period_end_date));
11749: --
11750: pay_action_information_api.create_action_information
11751: (
11752: p_action_information_id => l_action_info_id
11758: , p_source_id => NULL
11759: , p_source_text => NULL
11760: , p_tax_unit_id => l_tax_unit_id
11761: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
11762: , p_action_information4 => '0039 - '||fnd_message.get
11763: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
11764: , p_action_information6 => '0039 - '||'The "Start date income relation" (Tag DatAanv) has to be lower than or equal to the "End date period" (Tag DatEindTv) within one report or one correction report.'
11765: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
11766: , p_action_information8 => l_emp_rec.assignment_number);
11778: IF l_emp_end_date is not null
11779: --and l_emp_end_date < GREATEST(l_period_start_date,trunc(l_period_end_date,'Y')) THEN
11780: and l_emp_end_date > l_period_end_date THEN
11781:
11782: --fnd_message.set_name('PER','HR_373544_NL_DATE_GTEQ');
11783: fnd_message.set_name('PER','HR_373543_NL_DATE_LTEQ');
11784: fnd_message.set_token('TAG1','DatEind');
11785: fnd_message.set_token('TAGVAL1',fnd_date.date_to_canonical(l_emp_end_date));
11786: --fnd_message.set_token('TAG2','DatAanvTv');
11779: --and l_emp_end_date < GREATEST(l_period_start_date,trunc(l_period_end_date,'Y')) THEN
11780: and l_emp_end_date > l_period_end_date THEN
11781:
11782: --fnd_message.set_name('PER','HR_373544_NL_DATE_GTEQ');
11783: fnd_message.set_name('PER','HR_373543_NL_DATE_LTEQ');
11784: fnd_message.set_token('TAG1','DatEind');
11785: fnd_message.set_token('TAGVAL1',fnd_date.date_to_canonical(l_emp_end_date));
11786: --fnd_message.set_token('TAG2','DatAanvTv');
11787: --fnd_message.set_token('TAGVAL2',fnd_date.date_to_canonical(GREATEST(l_period_start_date,trunc(l_period_end_date,'Y'))));
11780: and l_emp_end_date > l_period_end_date THEN
11781:
11782: --fnd_message.set_name('PER','HR_373544_NL_DATE_GTEQ');
11783: fnd_message.set_name('PER','HR_373543_NL_DATE_LTEQ');
11784: fnd_message.set_token('TAG1','DatEind');
11785: fnd_message.set_token('TAGVAL1',fnd_date.date_to_canonical(l_emp_end_date));
11786: --fnd_message.set_token('TAG2','DatAanvTv');
11787: --fnd_message.set_token('TAGVAL2',fnd_date.date_to_canonical(GREATEST(l_period_start_date,trunc(l_period_end_date,'Y'))));
11788: fnd_message.set_token('TAG2','DatEindTv');
11781:
11782: --fnd_message.set_name('PER','HR_373544_NL_DATE_GTEQ');
11783: fnd_message.set_name('PER','HR_373543_NL_DATE_LTEQ');
11784: fnd_message.set_token('TAG1','DatEind');
11785: fnd_message.set_token('TAGVAL1',fnd_date.date_to_canonical(l_emp_end_date));
11786: --fnd_message.set_token('TAG2','DatAanvTv');
11787: --fnd_message.set_token('TAGVAL2',fnd_date.date_to_canonical(GREATEST(l_period_start_date,trunc(l_period_end_date,'Y'))));
11788: fnd_message.set_token('TAG2','DatEindTv');
11789: fnd_message.set_token('TAGVAL2',fnd_date.date_to_canonical(l_period_end_date));
11782: --fnd_message.set_name('PER','HR_373544_NL_DATE_GTEQ');
11783: fnd_message.set_name('PER','HR_373543_NL_DATE_LTEQ');
11784: fnd_message.set_token('TAG1','DatEind');
11785: fnd_message.set_token('TAGVAL1',fnd_date.date_to_canonical(l_emp_end_date));
11786: --fnd_message.set_token('TAG2','DatAanvTv');
11787: --fnd_message.set_token('TAGVAL2',fnd_date.date_to_canonical(GREATEST(l_period_start_date,trunc(l_period_end_date,'Y'))));
11788: fnd_message.set_token('TAG2','DatEindTv');
11789: fnd_message.set_token('TAGVAL2',fnd_date.date_to_canonical(l_period_end_date));
11790:
11783: fnd_message.set_name('PER','HR_373543_NL_DATE_LTEQ');
11784: fnd_message.set_token('TAG1','DatEind');
11785: fnd_message.set_token('TAGVAL1',fnd_date.date_to_canonical(l_emp_end_date));
11786: --fnd_message.set_token('TAG2','DatAanvTv');
11787: --fnd_message.set_token('TAGVAL2',fnd_date.date_to_canonical(GREATEST(l_period_start_date,trunc(l_period_end_date,'Y'))));
11788: fnd_message.set_token('TAG2','DatEindTv');
11789: fnd_message.set_token('TAGVAL2',fnd_date.date_to_canonical(l_period_end_date));
11790:
11791:
11784: fnd_message.set_token('TAG1','DatEind');
11785: fnd_message.set_token('TAGVAL1',fnd_date.date_to_canonical(l_emp_end_date));
11786: --fnd_message.set_token('TAG2','DatAanvTv');
11787: --fnd_message.set_token('TAGVAL2',fnd_date.date_to_canonical(GREATEST(l_period_start_date,trunc(l_period_end_date,'Y'))));
11788: fnd_message.set_token('TAG2','DatEindTv');
11789: fnd_message.set_token('TAGVAL2',fnd_date.date_to_canonical(l_period_end_date));
11790:
11791:
11792: pay_action_information_api.create_action_information
11785: fnd_message.set_token('TAGVAL1',fnd_date.date_to_canonical(l_emp_end_date));
11786: --fnd_message.set_token('TAG2','DatAanvTv');
11787: --fnd_message.set_token('TAGVAL2',fnd_date.date_to_canonical(GREATEST(l_period_start_date,trunc(l_period_end_date,'Y'))));
11788: fnd_message.set_token('TAG2','DatEindTv');
11789: fnd_message.set_token('TAGVAL2',fnd_date.date_to_canonical(l_period_end_date));
11790:
11791:
11792: pay_action_information_api.create_action_information
11793: (
11800: , p_source_id => NULL
11801: , p_source_text => NULL
11802: , p_tax_unit_id => l_tax_unit_id
11803: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
11804: , p_action_information4 => '0040 - '||fnd_message.get
11805: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
11806: --, p_action_information6 => '0040 - '||'The "End date income relation" (Tag DatEind) has to be higher than or equal to the "Start date period" (Tag DatAanvTv) within one report or one correction report.'
11807: , p_action_information6 => '0040 - '||'The "End date income relation" (Tag DatEind) has to be lower than or equal to the "End date period" (Tag DatEindTv) within one report or one correction report.'
11808: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
11812: --
11813: --abraghun--7668628--Check0041
11814: IF l_emp_end_date is not null and l_emp_end_date < l_ass_start_date THEN
11815: --
11816: fnd_message.set_name('PER','HR_373544_NL_DATE_GTEQ');
11817: fnd_message.set_token('TAG1','DatEind');
11818: fnd_message.set_token('TAGVAL1',fnd_date.date_to_canonical(l_emp_end_date));
11819: fnd_message.set_token('TAG2','DatAanv');
11820: fnd_message.set_token('TAGVAL2',fnd_date.date_to_canonical(l_ass_start_date));
11813: --abraghun--7668628--Check0041
11814: IF l_emp_end_date is not null and l_emp_end_date < l_ass_start_date THEN
11815: --
11816: fnd_message.set_name('PER','HR_373544_NL_DATE_GTEQ');
11817: fnd_message.set_token('TAG1','DatEind');
11818: fnd_message.set_token('TAGVAL1',fnd_date.date_to_canonical(l_emp_end_date));
11819: fnd_message.set_token('TAG2','DatAanv');
11820: fnd_message.set_token('TAGVAL2',fnd_date.date_to_canonical(l_ass_start_date));
11821:
11814: IF l_emp_end_date is not null and l_emp_end_date < l_ass_start_date THEN
11815: --
11816: fnd_message.set_name('PER','HR_373544_NL_DATE_GTEQ');
11817: fnd_message.set_token('TAG1','DatEind');
11818: fnd_message.set_token('TAGVAL1',fnd_date.date_to_canonical(l_emp_end_date));
11819: fnd_message.set_token('TAG2','DatAanv');
11820: fnd_message.set_token('TAGVAL2',fnd_date.date_to_canonical(l_ass_start_date));
11821:
11822: pay_action_information_api.create_action_information
11815: --
11816: fnd_message.set_name('PER','HR_373544_NL_DATE_GTEQ');
11817: fnd_message.set_token('TAG1','DatEind');
11818: fnd_message.set_token('TAGVAL1',fnd_date.date_to_canonical(l_emp_end_date));
11819: fnd_message.set_token('TAG2','DatAanv');
11820: fnd_message.set_token('TAGVAL2',fnd_date.date_to_canonical(l_ass_start_date));
11821:
11822: pay_action_information_api.create_action_information
11823: (
11816: fnd_message.set_name('PER','HR_373544_NL_DATE_GTEQ');
11817: fnd_message.set_token('TAG1','DatEind');
11818: fnd_message.set_token('TAGVAL1',fnd_date.date_to_canonical(l_emp_end_date));
11819: fnd_message.set_token('TAG2','DatAanv');
11820: fnd_message.set_token('TAGVAL2',fnd_date.date_to_canonical(l_ass_start_date));
11821:
11822: pay_action_information_api.create_action_information
11823: (
11824: p_action_information_id => l_action_info_id
11830: , p_source_id => NULL
11831: , p_source_text => NULL
11832: , p_tax_unit_id => l_tax_unit_id
11833: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
11834: , p_action_information4 => '0041 - '||fnd_message.get
11835: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
11836: , p_action_information6 => '0041 - '||'The "End date income relation" (Tag DatEind) has to be higher than or equal to the "Start date income relation" (Tag DatAanv).'
11837: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
11838: , p_action_information8 => l_emp_rec.assignment_number);
11853: , p_source_id => NULL
11854: , p_source_text => NULL
11855: , p_tax_unit_id => l_tax_unit_id
11856: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
11857: , p_action_information4 => '0042 - '||fnd_message.get_string('PER','HR_373545_NL_RDNEINDFLX_CHECK1')
11858: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
11859: , p_action_information6 => '0042 - '||'The "Code reason end of Income relation Flex worker" is only allowed when the "Code kind of labour relation" (Tag CdAard) is equal to 11.'
11860: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
11861: , p_action_information8 => l_emp_rec.assignment_number);
11876: , p_source_id => NULL
11877: , p_source_text => NULL
11878: , p_tax_unit_id => l_tax_unit_id
11879: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
11880: , p_action_information4 => '0043 - '||fnd_message.get_string('PER','HR_373546_NL_RDNEINDFLX_CHECK2')
11881: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
11882: , p_action_information6 => '0043 - '||'The "Code reason end of Income relation Flex worker" is only allowed when the "End date income relation" (Tag DatEind) is reported.'
11883: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
11884: , p_action_information8 => l_emp_rec.assignment_number);
11944: , p_source_id => NULL
11945: , p_source_text => NULL
11946: , p_tax_unit_id => l_tax_unit_id
11947: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
11948: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_ASG_RISK_GRP')
11949: , p_action_information5 => fnd_date.date_to_canonical(l_rec_changes(i).effective_date)
11950: , p_action_information6 => 'Assignment has no Sector or Risk Group'
11951: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
11952: , p_action_information8 => l_emp_rec.assignment_number);
12010: , p_source_id => NULL
12011: , p_source_text => NULL
12012: , p_tax_unit_id => l_tax_unit_id
12013: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
12014: , p_action_information4 => fnd_message.get_string('PER','HR_373549_NL_ZVW_J_DEFAULT')
12015: , p_action_information5 => fnd_date.date_to_canonical(l_rec_changes(i).effective_date)
12016: , p_action_information6 => 'Contribution Exempt Small Job is applicable. Therefore, the ZVW code is set to J.'
12017: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
12018: , p_action_information8 => l_emp_rec.assignment_number);
12029: , p_source_id => NULL
12030: , p_source_text => NULL
12031: , p_tax_unit_id => l_tax_unit_id
12032: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
12033: , p_action_information4 => fnd_message.get_string('PER','HR_373550_NL_ZVW_J_WARNING')
12034: , p_action_information5 => fnd_date.date_to_canonical(l_rec_changes(i).effective_date)
12035: , p_action_information6 => 'The ZVW code is set to J when Contribution Exempt Small Job is not applicable.'
12036: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
12037: , p_action_information8 => l_emp_rec.assignment_number);
12053: , p_source_id => NULL
12054: , p_source_text => NULL
12055: , p_tax_unit_id => l_tax_unit_id
12056: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
12057: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_ZVW_CODE_INSURED')
12058: , p_action_information5 => fnd_date.date_to_canonical(l_rec_changes(i).effective_date)
12059: , p_action_information6 => 'Code ZVW is defaulted to - A'
12060: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
12061: , p_action_information8 => l_emp_rec.assignment_number);
12075: , p_source_id => NULL
12076: , p_source_text => NULL
12077: , p_tax_unit_id => l_tax_unit_id
12078: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
12079: , p_action_information4 => '0053 - '||fnd_message.get_string('PER','HR_NL_INVALID_LABOR_CODE')
12080: , p_action_information5 => fnd_date.date_to_canonical(l_rec_changes(i).effective_date)
12081: , p_action_information6 => '0053 - '||'Labor Relation code is null'
12082: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
12083: , p_action_information8 => l_emp_rec.assignment_number);
12097: , p_source_id => NULL
12098: , p_source_text => NULL
12099: , p_tax_unit_id => l_tax_unit_id
12100: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
12101: , p_action_information4 => '0055 - '||fnd_message.get_string('PER','HR_NL_INVALID_CONTRACT_CODE')
12102: , p_action_information5 => fnd_date.date_to_canonical(l_rec_changes(i).effective_date)
12103: , p_action_information6 => '0055 - '||'Code contract for limited or unlimited time is null'
12104: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
12105: , p_action_information8 => l_emp_rec.assignment_number);
12117: , p_source_id => NULL
12118: , p_source_text => NULL
12119: , p_tax_unit_id => l_tax_unit_id
12120: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
12121: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_WORK_PATTERN')
12122: , p_action_information5 => fnd_date.date_to_canonical(l_rec_changes(i).effective_date)
12123: , p_action_information6 => 'Indication regular work pattern is null'
12124: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
12125: , p_action_information8 => l_emp_rec.assignment_number);
12137: , p_source_id => NULL
12138: , p_source_text => NULL
12139: , p_tax_unit_id => l_tax_unit_id
12140: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
12141: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_TEMP_LABOR_CODE')
12142: , p_action_information5 => fnd_date.date_to_canonical(l_rec_changes(i).effective_date)
12143: , p_action_information6 => 'Temp Labor Code is null'
12144: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
12145: , p_action_information8 => l_emp_rec.assignment_number);
12157: , p_source_id => NULL
12158: , p_source_text => NULL
12159: , p_tax_unit_id => l_tax_unit_id
12160: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
12161: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_COMPANY_CAR_USE')
12162: , p_action_information5 => fnd_date.date_to_canonical(l_rec_changes(i).effective_date)
12163: , p_action_information6 => 'Company Car Usage code invalid'
12164: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
12165: , p_action_information8 => l_emp_rec.assignment_number);
12304: , p_source_id => NULL
12305: , p_source_text => NULL
12306: , p_tax_unit_id => l_tax_unit_id
12307: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
12308: , p_action_information4 => '0054 - '||fnd_message.get_string('PER','HR_373539_NL_CDAARD_CHECK')
12309: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
12310: , p_action_information6 => '0054 - '||'The "Code kind of labour relation" (Tag CdAard) has to be 18 when "Income Code" (Tag SrtIV) is equal to 18.'
12311: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
12312: , p_action_information8 => l_emp_rec.assignment_number);
12316: --
12317: IF l_income_code IN (11,12,13,14,15,17,18) AND l_cao_code IS NULL THEN
12318:
12319: --HR_373531_NL_SRTIV_MANDATORY When SrtIV is equal to SRTIV, TAG is mandatory.
12320: fnd_message.set_name('PER','HR_373531_NL_SRTIV_MANDATORY');
12321: fnd_message.set_token('SRTIV',l_income_code);
12322: fnd_message.set_token('TAG','CAO');
12323:
12324:
12317: IF l_income_code IN (11,12,13,14,15,17,18) AND l_cao_code IS NULL THEN
12318:
12319: --HR_373531_NL_SRTIV_MANDATORY When SrtIV is equal to SRTIV, TAG is mandatory.
12320: fnd_message.set_name('PER','HR_373531_NL_SRTIV_MANDATORY');
12321: fnd_message.set_token('SRTIV',l_income_code);
12322: fnd_message.set_token('TAG','CAO');
12323:
12324:
12325: pay_action_information_api.create_action_information
12318:
12319: --HR_373531_NL_SRTIV_MANDATORY When SrtIV is equal to SRTIV, TAG is mandatory.
12320: fnd_message.set_name('PER','HR_373531_NL_SRTIV_MANDATORY');
12321: fnd_message.set_token('SRTIV',l_income_code);
12322: fnd_message.set_token('TAG','CAO');
12323:
12324:
12325: pay_action_information_api.create_action_information
12326: (
12333: , p_source_id => NULL
12334: , p_source_text => NULL
12335: , p_tax_unit_id => l_tax_unit_id
12336: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
12337: , p_action_information4 => '0056 - '||fnd_message.get
12338: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
12339: , p_action_information6 => '0056 - '||'When the "Income Code" (Tag SrtIV) is equal to 11, 12, 13, 14, 15, 17 or 18, the "Code CAO" (Tag CAO) is mandatory.'
12340: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
12341: , p_action_information8 => l_emp_rec.assignment_number);
12347: --
12348: IF (months_between(l_period_end_date,l_emp_rec.dob)/12)>=65 THEN
12349: --abraghun--7668628--Check0057
12350: IF l_wao_insured = 'J' THEN
12351: fnd_message.set_name('PER','HR_373532_NL_AGE65_CHECKS');
12352: fnd_message.set_token('AGE',ROUND(months_between(l_period_end_date,l_emp_rec.dob)/12));
12353: fnd_message.set_token('TAG','IndWAO');
12354: pay_action_information_api.create_action_information
12355: (
12348: IF (months_between(l_period_end_date,l_emp_rec.dob)/12)>=65 THEN
12349: --abraghun--7668628--Check0057
12350: IF l_wao_insured = 'J' THEN
12351: fnd_message.set_name('PER','HR_373532_NL_AGE65_CHECKS');
12352: fnd_message.set_token('AGE',ROUND(months_between(l_period_end_date,l_emp_rec.dob)/12));
12353: fnd_message.set_token('TAG','IndWAO');
12354: pay_action_information_api.create_action_information
12355: (
12356: p_action_information_id => l_action_info_id
12349: --abraghun--7668628--Check0057
12350: IF l_wao_insured = 'J' THEN
12351: fnd_message.set_name('PER','HR_373532_NL_AGE65_CHECKS');
12352: fnd_message.set_token('AGE',ROUND(months_between(l_period_end_date,l_emp_rec.dob)/12));
12353: fnd_message.set_token('TAG','IndWAO');
12354: pay_action_information_api.create_action_information
12355: (
12356: p_action_information_id => l_action_info_id
12357: , p_action_context_id => p_assactid
12362: , p_source_id => NULL
12363: , p_source_text => NULL
12364: , p_tax_unit_id => l_tax_unit_id
12365: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
12366: , p_action_information4 => '0057 - '||fnd_message.get
12367: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
12368: , p_action_information6 => '0057 - '||'When the employee reaches the age of 65 in the current period (the age is 65 on the last day of the period), the "Indication WAO/IVA/WGA insured" (Tag IndWAO) cannot be equal to "J".'
12369: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
12370: , p_action_information8 => l_emp_rec.assignment_number);
12370: , p_action_information8 => l_emp_rec.assignment_number);
12371: END IF;
12372: --abraghun--7668628--Check0058
12373: IF l_ww_insured = 'J' THEN
12374: fnd_message.set_name('PER','HR_373532_NL_AGE65_CHECKS');
12375: fnd_message.set_token('AGE',ROUND(months_between(l_period_end_date,l_emp_rec.dob)/12));
12376: fnd_message.set_token('TAG','IndWW');
12377: pay_action_information_api.create_action_information
12378: (
12371: END IF;
12372: --abraghun--7668628--Check0058
12373: IF l_ww_insured = 'J' THEN
12374: fnd_message.set_name('PER','HR_373532_NL_AGE65_CHECKS');
12375: fnd_message.set_token('AGE',ROUND(months_between(l_period_end_date,l_emp_rec.dob)/12));
12376: fnd_message.set_token('TAG','IndWW');
12377: pay_action_information_api.create_action_information
12378: (
12379: p_action_information_id => l_action_info_id
12372: --abraghun--7668628--Check0058
12373: IF l_ww_insured = 'J' THEN
12374: fnd_message.set_name('PER','HR_373532_NL_AGE65_CHECKS');
12375: fnd_message.set_token('AGE',ROUND(months_between(l_period_end_date,l_emp_rec.dob)/12));
12376: fnd_message.set_token('TAG','IndWW');
12377: pay_action_information_api.create_action_information
12378: (
12379: p_action_information_id => l_action_info_id
12380: , p_action_context_id => p_assactid
12385: , p_source_id => NULL
12386: , p_source_text => NULL
12387: , p_tax_unit_id => l_tax_unit_id
12388: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
12389: , p_action_information4 => '0058 - '||fnd_message.get
12390: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
12391: , p_action_information6 => '0058 - '||'When the employee reaches the age of 65 in the current period (the age is 65 on the last day of the period), the "Indication WW insured" (Tag IndWW) cannot be equal to "J".'
12392: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
12393: , p_action_information8 => l_emp_rec.assignment_number);
12393: , p_action_information8 => l_emp_rec.assignment_number);
12394: END IF;
12395: --abraghun--7668628--Check0059
12396: IF l_zw_insured = 'J' THEN
12397: fnd_message.set_name('PER','HR_373532_NL_AGE65_CHECKS');
12398: fnd_message.set_token('AGE',ROUND(months_between(l_period_end_date,l_emp_rec.dob)/12));
12399: fnd_message.set_token('TAG','IndZW');
12400: pay_action_information_api.create_action_information
12401: (
12394: END IF;
12395: --abraghun--7668628--Check0059
12396: IF l_zw_insured = 'J' THEN
12397: fnd_message.set_name('PER','HR_373532_NL_AGE65_CHECKS');
12398: fnd_message.set_token('AGE',ROUND(months_between(l_period_end_date,l_emp_rec.dob)/12));
12399: fnd_message.set_token('TAG','IndZW');
12400: pay_action_information_api.create_action_information
12401: (
12402: p_action_information_id => l_action_info_id
12395: --abraghun--7668628--Check0059
12396: IF l_zw_insured = 'J' THEN
12397: fnd_message.set_name('PER','HR_373532_NL_AGE65_CHECKS');
12398: fnd_message.set_token('AGE',ROUND(months_between(l_period_end_date,l_emp_rec.dob)/12));
12399: fnd_message.set_token('TAG','IndZW');
12400: pay_action_information_api.create_action_information
12401: (
12402: p_action_information_id => l_action_info_id
12403: , p_action_context_id => p_assactid
12408: , p_source_id => NULL
12409: , p_source_text => NULL
12410: , p_tax_unit_id => l_tax_unit_id
12411: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
12412: , p_action_information4 => '0059 - '||fnd_message.get
12413: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
12414: , p_action_information6 => '0059 - '||'When the employee reaches the age of 65 in the current period (the age is 65 on the last day of the period), the "Indication ZW insured" (Tag IndZW) cannot be equal to "J".'
12415: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
12416: , p_action_information8 => l_emp_rec.assignment_number);
12424: /*
12425: --abraghun--7668628--Check0060
12426: IF l_wage_tax_table in (221,224,225) AND NVL(l_zvw_situation,'A')<>'G' THEN
12427:
12428: fnd_message.set_name('PER','HR_373538_NL_CDZVW_CHECKS');
12429: fnd_message.set_token('TAGVAL1','G');
12430: fnd_message.set_token('TAGVAL2',l_wage_tax_table);
12431:
12432: pay_action_information_api.create_action_information
12425: --abraghun--7668628--Check0060
12426: IF l_wage_tax_table in (221,224,225) AND NVL(l_zvw_situation,'A')<>'G' THEN
12427:
12428: fnd_message.set_name('PER','HR_373538_NL_CDZVW_CHECKS');
12429: fnd_message.set_token('TAGVAL1','G');
12430: fnd_message.set_token('TAGVAL2',l_wage_tax_table);
12431:
12432: pay_action_information_api.create_action_information
12433: (
12426: IF l_wage_tax_table in (221,224,225) AND NVL(l_zvw_situation,'A')<>'G' THEN
12427:
12428: fnd_message.set_name('PER','HR_373538_NL_CDZVW_CHECKS');
12429: fnd_message.set_token('TAGVAL1','G');
12430: fnd_message.set_token('TAGVAL2',l_wage_tax_table);
12431:
12432: pay_action_information_api.create_action_information
12433: (
12434: p_action_information_id => l_action_info_id
12440: , p_source_id => NULL
12441: , p_source_text => NULL
12442: , p_tax_unit_id => l_tax_unit_id
12443: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
12444: , p_action_information4 => '0060 - '||fnd_message.get
12445: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
12446: , p_action_information6 => '0060 - '||'The "Indication insurance situation Zvw" (Tag CdZvw) can only be equal to "G" when "Code wage tax table" (Tag LbTab) is equal to 221, 224 or 225.'
12447: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
12448: , p_action_information8 => l_emp_rec.assignment_number);
12448: , p_action_information8 => l_emp_rec.assignment_number);
12449: --abraghun--7668628--Check0061
12450: ELSIF l_wage_tax_table =220 AND NVL(l_zvw_situation,'A')<>'H' THEN
12451:
12452: fnd_message.set_name('PER','HR_373538_NL_CDZVW_CHECKS');
12453: fnd_message.set_token('TAGVAL1','H');
12454: fnd_message.set_token('TAGVAL2',l_wage_tax_table);
12455:
12456: pay_action_information_api.create_action_information
12449: --abraghun--7668628--Check0061
12450: ELSIF l_wage_tax_table =220 AND NVL(l_zvw_situation,'A')<>'H' THEN
12451:
12452: fnd_message.set_name('PER','HR_373538_NL_CDZVW_CHECKS');
12453: fnd_message.set_token('TAGVAL1','H');
12454: fnd_message.set_token('TAGVAL2',l_wage_tax_table);
12455:
12456: pay_action_information_api.create_action_information
12457: (
12450: ELSIF l_wage_tax_table =220 AND NVL(l_zvw_situation,'A')<>'H' THEN
12451:
12452: fnd_message.set_name('PER','HR_373538_NL_CDZVW_CHECKS');
12453: fnd_message.set_token('TAGVAL1','H');
12454: fnd_message.set_token('TAGVAL2',l_wage_tax_table);
12455:
12456: pay_action_information_api.create_action_information
12457: (
12458: p_action_information_id => l_action_info_id
12464: , p_source_id => NULL
12465: , p_source_text => NULL
12466: , p_tax_unit_id => l_tax_unit_id
12467: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
12468: , p_action_information4 => '0061 - '||fnd_message.get
12469: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
12470: , p_action_information6 => '0061 - '||'The "Indication insurance situation Zvw" (Tag CdZvw) can only be equal to "H" when "Code wage tax table" (Tag LbTab) is equal to 220.'
12471: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
12472: , p_action_information8 => l_emp_rec.assignment_number);
12622: , p_source_id => NULL
12623: , p_source_text => NULL
12624: , p_tax_unit_id => l_tax_unit_id
12625: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
12626: , p_action_information4 => fnd_message.get_string('PER','HR_373547_NUMIV_OVERRIDE')
12627: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
12628: , p_action_information6 => 'Num IV override Already Used'
12629: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
12630: , p_action_information8 => l_emp_rec.assignment_number);
12647: , p_source_id => NULL
12648: , p_source_text => NULL
12649: , p_tax_unit_id => l_tax_unit_id
12650: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
12651: , p_action_information4 => '0044/1044 - '||fnd_message.get_string('PER','HR_373537_NL_EMPNO_MANDATORY')
12652: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
12653: , p_action_information6 => '0044/1044 - '||'When the "BSN/Sofi-number" (Tag SofiNr) is not reported the record "Employee number" (Tag PersNr) is mandatory.'
12654: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
12655: , p_action_information8 => l_emp_rec.assignment_number);
12657: END IF;
12658:
12659: --abraghun--7668628--Check0046 Check0047 Check0048 Check0049
12660: IF l_emp_rec.sofi_number is not null AND l_wage_tax_table <> 940 THEN
12661: fnd_message.set_name('PER','HR_373535_NL_NON940_MANDATORY');
12662:
12663: --abraghun--7668628--Check0046
12664: IF l_emp_rec.last_name is null THEN
12665: --
12662:
12663: --abraghun--7668628--Check0046
12664: IF l_emp_rec.last_name is null THEN
12665: --
12666: fnd_message.set_token('TAGVAL1',l_wage_tax_table);
12667: fnd_message.set_token('TAG2','SignNm');
12668:
12669: pay_action_information_api.create_action_information
12670: (
12663: --abraghun--7668628--Check0046
12664: IF l_emp_rec.last_name is null THEN
12665: --
12666: fnd_message.set_token('TAGVAL1',l_wage_tax_table);
12667: fnd_message.set_token('TAG2','SignNm');
12668:
12669: pay_action_information_api.create_action_information
12670: (
12671: p_action_information_id => l_action_info_id
12677: , p_source_id => NULL
12678: , p_source_text => NULL
12679: , p_tax_unit_id => l_tax_unit_id
12680: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
12681: , p_action_information4 => '0046 - '||fnd_message.get
12682: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
12683: , p_action_information6 => '0046 - '||'When "BSN/Sofi-number" (Tag SofiNr) is reported and "Code wage tax table" (Tag LbTab) is not equal to 940 the "Last Name" (Tag SignNm) cannot be empty / is mandatory.'
12684: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
12685: , p_action_information8 => l_emp_rec.assignment_number);
12688:
12689: --abraghun--7668628--Check0047
12690: IF l_emp_rec.dob is null THEN
12691: --
12692: fnd_message.set_token('TAGVAL1',l_wage_tax_table);
12693: fnd_message.set_token('TAG2','Gebdat');
12694:
12695: pay_action_information_api.create_action_information
12696: (
12689: --abraghun--7668628--Check0047
12690: IF l_emp_rec.dob is null THEN
12691: --
12692: fnd_message.set_token('TAGVAL1',l_wage_tax_table);
12693: fnd_message.set_token('TAG2','Gebdat');
12694:
12695: pay_action_information_api.create_action_information
12696: (
12697: p_action_information_id => l_action_info_id
12703: , p_source_id => NULL
12704: , p_source_text => NULL
12705: , p_tax_unit_id => l_tax_unit_id
12706: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
12707: , p_action_information4 => '0047 - '||fnd_message.get
12708: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
12709: , p_action_information6 => '0047 - '||'When "BSN/Sofi-number" (Tag SofiNr) is reported and "Code wage tax table" (Tag LbTab) is not equal to 940 the "Date of birth" (Tag Gebdat) cannot be empty / is mandatory.'
12710: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
12711: , p_action_information8 => l_emp_rec.assignment_number);
12714:
12715: --abraghun--7668628--Check0048
12716: IF l_nationality is null THEN
12717: --
12718: fnd_message.set_token('TAGVAL1',l_wage_tax_table);
12719: fnd_message.set_token('TAG2','Nat');
12720:
12721: pay_action_information_api.create_action_information
12722: (
12715: --abraghun--7668628--Check0048
12716: IF l_nationality is null THEN
12717: --
12718: fnd_message.set_token('TAGVAL1',l_wage_tax_table);
12719: fnd_message.set_token('TAG2','Nat');
12720:
12721: pay_action_information_api.create_action_information
12722: (
12723: p_action_information_id => l_action_info_id
12729: , p_source_id => NULL
12730: , p_source_text => NULL
12731: , p_tax_unit_id => l_tax_unit_id
12732: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
12733: , p_action_information4 => '0048 - '||fnd_message.get
12734: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
12735: , p_action_information6 => '0048 - '||'When "BSN/Sofi-number" (Tag SofiNr) is reported and "Code wage tax table" (Tag LbTab) is not equal to 940 the "Nationality" (Tag Nat) cannot be empty / is mandatory.'
12736: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
12737: , p_action_information8 => l_emp_rec.assignment_number);
12740:
12741: --abraghun--7668628--Check0049
12742: IF l_emp_rec.gender is null THEN
12743: --
12744: fnd_message.set_token('TAGVAL1',l_wage_tax_table);
12745: fnd_message.set_token('TAG2','Gesl');
12746:
12747: pay_action_information_api.create_action_information
12748: (
12741: --abraghun--7668628--Check0049
12742: IF l_emp_rec.gender is null THEN
12743: --
12744: fnd_message.set_token('TAGVAL1',l_wage_tax_table);
12745: fnd_message.set_token('TAG2','Gesl');
12746:
12747: pay_action_information_api.create_action_information
12748: (
12749: p_action_information_id => l_action_info_id
12755: , p_source_id => NULL
12756: , p_source_text => NULL
12757: , p_tax_unit_id => l_tax_unit_id
12758: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
12759: , p_action_information4 => '0049 - '||fnd_message.get
12760: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
12761: , p_action_information6 => '0049 - '||'When "BSN/Sofi-number" (Tag SofiNr) is reported and "Code wage tax table" (Tag LbTab) is not equal to 940 the "Gender" (Tag Gesl) cannot be empty / is mandatory.'
12762: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
12763: , p_action_information8 => l_emp_rec.assignment_number);
12767: --
12768: --abraghun--7668628--Check0039
12769: IF l_ass_start_date > p_chk_end_date THEN
12770: --
12771: fnd_message.set_name('PER','HR_373543_NL_DATE_LTEQ');
12772: fnd_message.set_token('TAG1','DatAanv');
12773: fnd_message.set_token('TAGVAL1',fnd_date.date_to_canonical(l_ass_start_date));
12774: fnd_message.set_token('TAG2','DatEindTv');
12775: fnd_message.set_token('TAGVAL2',fnd_date.date_to_canonical(p_chk_end_date));
12768: --abraghun--7668628--Check0039
12769: IF l_ass_start_date > p_chk_end_date THEN
12770: --
12771: fnd_message.set_name('PER','HR_373543_NL_DATE_LTEQ');
12772: fnd_message.set_token('TAG1','DatAanv');
12773: fnd_message.set_token('TAGVAL1',fnd_date.date_to_canonical(l_ass_start_date));
12774: fnd_message.set_token('TAG2','DatEindTv');
12775: fnd_message.set_token('TAGVAL2',fnd_date.date_to_canonical(p_chk_end_date));
12776:
12769: IF l_ass_start_date > p_chk_end_date THEN
12770: --
12771: fnd_message.set_name('PER','HR_373543_NL_DATE_LTEQ');
12772: fnd_message.set_token('TAG1','DatAanv');
12773: fnd_message.set_token('TAGVAL1',fnd_date.date_to_canonical(l_ass_start_date));
12774: fnd_message.set_token('TAG2','DatEindTv');
12775: fnd_message.set_token('TAGVAL2',fnd_date.date_to_canonical(p_chk_end_date));
12776:
12777: pay_action_information_api.create_action_information
12770: --
12771: fnd_message.set_name('PER','HR_373543_NL_DATE_LTEQ');
12772: fnd_message.set_token('TAG1','DatAanv');
12773: fnd_message.set_token('TAGVAL1',fnd_date.date_to_canonical(l_ass_start_date));
12774: fnd_message.set_token('TAG2','DatEindTv');
12775: fnd_message.set_token('TAGVAL2',fnd_date.date_to_canonical(p_chk_end_date));
12776:
12777: pay_action_information_api.create_action_information
12778: (
12771: fnd_message.set_name('PER','HR_373543_NL_DATE_LTEQ');
12772: fnd_message.set_token('TAG1','DatAanv');
12773: fnd_message.set_token('TAGVAL1',fnd_date.date_to_canonical(l_ass_start_date));
12774: fnd_message.set_token('TAG2','DatEindTv');
12775: fnd_message.set_token('TAGVAL2',fnd_date.date_to_canonical(p_chk_end_date));
12776:
12777: pay_action_information_api.create_action_information
12778: (
12779: p_action_information_id => l_action_info_id
12785: , p_source_id => NULL
12786: , p_source_text => NULL
12787: , p_tax_unit_id => l_tax_unit_id
12788: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
12789: , p_action_information4 => '0039 - '||fnd_message.get
12790: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
12791: , p_action_information6 => '0039 - '||'The "Start date income relation" (Tag DatAanv) has to be lower than or equal to the "End date period" (Tag DatEindTv) within one report or one correction report.'
12792: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
12793: , p_action_information8 => l_emp_rec.assignment_number);
12804: IF l_emp_end_date is not null
12805: --and l_emp_end_date < GREATEST(p_chk_start_date,trunc(p_chk_end_date,'Y')) THEN
12806: and l_emp_end_date > p_chk_end_date THEN
12807:
12808: --fnd_message.set_name('PER','HR_373544_NL_DATE_GTEQ');
12809: fnd_message.set_name('PER','HR_373543_NL_DATE_LTEQ');
12810: fnd_message.set_token('TAG1','DatEind');
12811: fnd_message.set_token('TAGVAL1',fnd_date.date_to_canonical(l_emp_end_date));
12812: --fnd_message.set_token('TAG2','DatAanvTv');
12805: --and l_emp_end_date < GREATEST(p_chk_start_date,trunc(p_chk_end_date,'Y')) THEN
12806: and l_emp_end_date > p_chk_end_date THEN
12807:
12808: --fnd_message.set_name('PER','HR_373544_NL_DATE_GTEQ');
12809: fnd_message.set_name('PER','HR_373543_NL_DATE_LTEQ');
12810: fnd_message.set_token('TAG1','DatEind');
12811: fnd_message.set_token('TAGVAL1',fnd_date.date_to_canonical(l_emp_end_date));
12812: --fnd_message.set_token('TAG2','DatAanvTv');
12813: --fnd_message.set_token('TAGVAL2',fnd_date.date_to_canonical(GREATEST(p_chk_start_date,trunc(p_chk_end_date,'Y'))));
12806: and l_emp_end_date > p_chk_end_date THEN
12807:
12808: --fnd_message.set_name('PER','HR_373544_NL_DATE_GTEQ');
12809: fnd_message.set_name('PER','HR_373543_NL_DATE_LTEQ');
12810: fnd_message.set_token('TAG1','DatEind');
12811: fnd_message.set_token('TAGVAL1',fnd_date.date_to_canonical(l_emp_end_date));
12812: --fnd_message.set_token('TAG2','DatAanvTv');
12813: --fnd_message.set_token('TAGVAL2',fnd_date.date_to_canonical(GREATEST(p_chk_start_date,trunc(p_chk_end_date,'Y'))));
12814: fnd_message.set_token('TAG2','DatEindTv');
12807:
12808: --fnd_message.set_name('PER','HR_373544_NL_DATE_GTEQ');
12809: fnd_message.set_name('PER','HR_373543_NL_DATE_LTEQ');
12810: fnd_message.set_token('TAG1','DatEind');
12811: fnd_message.set_token('TAGVAL1',fnd_date.date_to_canonical(l_emp_end_date));
12812: --fnd_message.set_token('TAG2','DatAanvTv');
12813: --fnd_message.set_token('TAGVAL2',fnd_date.date_to_canonical(GREATEST(p_chk_start_date,trunc(p_chk_end_date,'Y'))));
12814: fnd_message.set_token('TAG2','DatEindTv');
12815: fnd_message.set_token('TAGVAL2',fnd_date.date_to_canonical(p_chk_end_date));
12808: --fnd_message.set_name('PER','HR_373544_NL_DATE_GTEQ');
12809: fnd_message.set_name('PER','HR_373543_NL_DATE_LTEQ');
12810: fnd_message.set_token('TAG1','DatEind');
12811: fnd_message.set_token('TAGVAL1',fnd_date.date_to_canonical(l_emp_end_date));
12812: --fnd_message.set_token('TAG2','DatAanvTv');
12813: --fnd_message.set_token('TAGVAL2',fnd_date.date_to_canonical(GREATEST(p_chk_start_date,trunc(p_chk_end_date,'Y'))));
12814: fnd_message.set_token('TAG2','DatEindTv');
12815: fnd_message.set_token('TAGVAL2',fnd_date.date_to_canonical(p_chk_end_date));
12816:
12809: fnd_message.set_name('PER','HR_373543_NL_DATE_LTEQ');
12810: fnd_message.set_token('TAG1','DatEind');
12811: fnd_message.set_token('TAGVAL1',fnd_date.date_to_canonical(l_emp_end_date));
12812: --fnd_message.set_token('TAG2','DatAanvTv');
12813: --fnd_message.set_token('TAGVAL2',fnd_date.date_to_canonical(GREATEST(p_chk_start_date,trunc(p_chk_end_date,'Y'))));
12814: fnd_message.set_token('TAG2','DatEindTv');
12815: fnd_message.set_token('TAGVAL2',fnd_date.date_to_canonical(p_chk_end_date));
12816:
12817: --
12810: fnd_message.set_token('TAG1','DatEind');
12811: fnd_message.set_token('TAGVAL1',fnd_date.date_to_canonical(l_emp_end_date));
12812: --fnd_message.set_token('TAG2','DatAanvTv');
12813: --fnd_message.set_token('TAGVAL2',fnd_date.date_to_canonical(GREATEST(p_chk_start_date,trunc(p_chk_end_date,'Y'))));
12814: fnd_message.set_token('TAG2','DatEindTv');
12815: fnd_message.set_token('TAGVAL2',fnd_date.date_to_canonical(p_chk_end_date));
12816:
12817: --
12818: pay_action_information_api.create_action_information
12811: fnd_message.set_token('TAGVAL1',fnd_date.date_to_canonical(l_emp_end_date));
12812: --fnd_message.set_token('TAG2','DatAanvTv');
12813: --fnd_message.set_token('TAGVAL2',fnd_date.date_to_canonical(GREATEST(p_chk_start_date,trunc(p_chk_end_date,'Y'))));
12814: fnd_message.set_token('TAG2','DatEindTv');
12815: fnd_message.set_token('TAGVAL2',fnd_date.date_to_canonical(p_chk_end_date));
12816:
12817: --
12818: pay_action_information_api.create_action_information
12819: (
12826: , p_source_id => NULL
12827: , p_source_text => NULL
12828: , p_tax_unit_id => l_tax_unit_id
12829: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
12830: , p_action_information4 => '0040 - '||fnd_message.get
12831: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
12832: --, p_action_information6 => '0040 - '||'The "End date income relation" (Tag DatEind) has to be higher than or equal to the "Start date period" (Tag DatAanvTv) within one report or one correction report.'
12833: , p_action_information6 => '0040 - '||'The "End date income relation" (Tag DatEind) has to be lower than or equal to the "End date period" (Tag DatEindTv) within one report or one correction report.'
12834: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
12838: --
12839: --abraghun--7668628--Check0041
12840: IF l_emp_end_date is not null and l_emp_end_date < l_ass_start_date THEN
12841: --
12842: fnd_message.set_name('PER','HR_373544_NL_DATE_GTEQ');
12843: fnd_message.set_token('TAG1','DatEind');
12844: fnd_message.set_token('TAGVAL1',fnd_date.date_to_canonical(l_emp_end_date));
12845: fnd_message.set_token('TAG2','DatAanv');
12846: fnd_message.set_token('TAGVAL2',fnd_date.date_to_canonical(l_ass_start_date));
12839: --abraghun--7668628--Check0041
12840: IF l_emp_end_date is not null and l_emp_end_date < l_ass_start_date THEN
12841: --
12842: fnd_message.set_name('PER','HR_373544_NL_DATE_GTEQ');
12843: fnd_message.set_token('TAG1','DatEind');
12844: fnd_message.set_token('TAGVAL1',fnd_date.date_to_canonical(l_emp_end_date));
12845: fnd_message.set_token('TAG2','DatAanv');
12846: fnd_message.set_token('TAGVAL2',fnd_date.date_to_canonical(l_ass_start_date));
12847:
12840: IF l_emp_end_date is not null and l_emp_end_date < l_ass_start_date THEN
12841: --
12842: fnd_message.set_name('PER','HR_373544_NL_DATE_GTEQ');
12843: fnd_message.set_token('TAG1','DatEind');
12844: fnd_message.set_token('TAGVAL1',fnd_date.date_to_canonical(l_emp_end_date));
12845: fnd_message.set_token('TAG2','DatAanv');
12846: fnd_message.set_token('TAGVAL2',fnd_date.date_to_canonical(l_ass_start_date));
12847:
12848: pay_action_information_api.create_action_information
12841: --
12842: fnd_message.set_name('PER','HR_373544_NL_DATE_GTEQ');
12843: fnd_message.set_token('TAG1','DatEind');
12844: fnd_message.set_token('TAGVAL1',fnd_date.date_to_canonical(l_emp_end_date));
12845: fnd_message.set_token('TAG2','DatAanv');
12846: fnd_message.set_token('TAGVAL2',fnd_date.date_to_canonical(l_ass_start_date));
12847:
12848: pay_action_information_api.create_action_information
12849: (
12842: fnd_message.set_name('PER','HR_373544_NL_DATE_GTEQ');
12843: fnd_message.set_token('TAG1','DatEind');
12844: fnd_message.set_token('TAGVAL1',fnd_date.date_to_canonical(l_emp_end_date));
12845: fnd_message.set_token('TAG2','DatAanv');
12846: fnd_message.set_token('TAGVAL2',fnd_date.date_to_canonical(l_ass_start_date));
12847:
12848: pay_action_information_api.create_action_information
12849: (
12850: p_action_information_id => l_action_info_id
12856: , p_source_id => NULL
12857: , p_source_text => NULL
12858: , p_tax_unit_id => l_tax_unit_id
12859: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
12860: , p_action_information4 => '0041 - '||fnd_message.get
12861: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
12862: , p_action_information6 => '0041 - '||'The "End date income relation" (Tag DatEind) has to be higher than or equal to the "Start date income relation" (Tag DatAanv).'
12863: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
12864: , p_action_information8 => l_emp_rec.assignment_number);
12879: , p_source_id => NULL
12880: , p_source_text => NULL
12881: , p_tax_unit_id => l_tax_unit_id
12882: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
12883: , p_action_information4 => '0042 - '||fnd_message.get_string('PER','HR_373545_NL_RDNEINDFLX_CHECK1')
12884: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
12885: , p_action_information6 => '0042 - '||'The "Code reason end of Income relation Flex worker" is only allowed when the "Code kind of labour relation" (Tag CdAard) is equal to 11.'
12886: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
12887: , p_action_information8 => l_emp_rec.assignment_number);
12902: , p_source_id => NULL
12903: , p_source_text => NULL
12904: , p_tax_unit_id => l_tax_unit_id
12905: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
12906: , p_action_information4 => '0043 - '||fnd_message.get_string('PER','HR_373546_NL_RDNEINDFLX_CHECK2')
12907: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
12908: , p_action_information6 => '0043 - '||'The "Code reason end of Income relation Flex worker" is only allowed when the "End date income relation" (Tag DatEind) is reported.'
12909: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
12910: , p_action_information8 => l_emp_rec.assignment_number);
12953: , p_source_id => NULL
12954: , p_source_text => NULL
12955: , p_tax_unit_id => l_tax_unit_id
12956: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
12957: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_ASG_RISK_GRP')
12958: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
12959: , p_action_information6 => 'Assignment has no Sector or Risk Group'
12960: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
12961: , p_action_information8 => l_emp_rec.assignment_number);
12977: , p_source_id => NULL
12978: , p_source_text => NULL
12979: , p_tax_unit_id => l_tax_unit_id
12980: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
12981: , p_action_information4 => fnd_message.get_string('PER','HR_373549_NL_ZVW_J_DEFAULT')
12982: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
12983: , p_action_information6 => 'Contribution Exempt Small Job is applicable. Therefore, the ZVW code is set to J.'
12984: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
12985: , p_action_information8 => l_emp_rec.assignment_number);
12996: , p_source_id => NULL
12997: , p_source_text => NULL
12998: , p_tax_unit_id => l_tax_unit_id
12999: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
13000: , p_action_information4 => fnd_message.get_string('PER','HR_373550_NL_ZVW_J_WARNING')
13001: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
13002: , p_action_information6 => 'The ZVW code is set to J when Contribution Exempt Small Job is not applicable.'
13003: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
13004: , p_action_information8 => l_emp_rec.assignment_number);
13019: , p_source_id => NULL
13020: , p_source_text => NULL
13021: , p_tax_unit_id => l_tax_unit_id
13022: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
13023: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_ZVW_CODE_INSURED')
13024: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
13025: , p_action_information6 => 'Code ZVW is defaulted to - A'
13026: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
13027: , p_action_information8 => l_emp_rec.assignment_number);
13040: , p_source_id => NULL
13041: , p_source_text => NULL
13042: , p_tax_unit_id => l_tax_unit_id
13043: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
13044: , p_action_information4 => '0053 - '||fnd_message.get_string('PER','HR_NL_INVALID_LABOR_CODE')
13045: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
13046: , p_action_information6 => '0053 - '||'Labor Relation code is null'
13047: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
13048: , p_action_information8 => l_emp_rec.assignment_number);
13061: , p_source_id => NULL
13062: , p_source_text => NULL
13063: , p_tax_unit_id => l_tax_unit_id
13064: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
13065: , p_action_information4 => '0055 - '||fnd_message.get_string('PER','HR_NL_INVALID_CONTRACT_CODE')
13066: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
13067: , p_action_information6 => '0055 - '||'Code contract for limited or unlimited time is null'
13068: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
13069: , p_action_information8 => l_emp_rec.assignment_number);
13081: , p_source_id => NULL
13082: , p_source_text => NULL
13083: , p_tax_unit_id => l_tax_unit_id
13084: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
13085: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_WORK_PATTERN')
13086: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
13087: , p_action_information6 => 'Indication regular work pattern is null'
13088: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
13089: , p_action_information8 => l_emp_rec.assignment_number);
13101: , p_source_id => NULL
13102: , p_source_text => NULL
13103: , p_tax_unit_id => l_tax_unit_id
13104: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
13105: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_TEMP_LABOR_CODE')
13106: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
13107: , p_action_information6 => 'Temp Labor Code is null'
13108: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
13109: , p_action_information8 => l_emp_rec.assignment_number);
13121: , p_source_id => NULL
13122: , p_source_text => NULL
13123: , p_tax_unit_id => l_tax_unit_id
13124: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
13125: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_COMPANY_CAR_USE')
13126: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
13127: , p_action_information6 => 'Company Car Usage code invalid'
13128: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
13129: , p_action_information8 => l_emp_rec.assignment_number);
13269: , p_source_id => NULL
13270: , p_source_text => NULL
13271: , p_tax_unit_id => l_tax_unit_id
13272: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
13273: , p_action_information4 => '0054 - '||fnd_message.get_string('PER','HR_373539_NL_CDAARD_CHECK')
13274: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
13275: , p_action_information6 => '0054 - '||'The "Code kind of labour relation" (Tag CdAard) has to be 18 when "Income Code" (Tag SrtIV) is equal to 18.'
13276: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
13277: , p_action_information8 => l_emp_rec.assignment_number);
13279: --
13280: --abraghun--7668628--Check0056
13281: --
13282: IF l_income_code IN (11,12,13,14,15,17,18) AND l_cao_code IS NULL THEN
13283: fnd_message.set_name('PER','HR_373531_NL_SRTIV_MANDATORY');
13284: fnd_message.set_token('SRTIV',l_income_code);
13285: fnd_message.set_token('TAG','CAO');
13286: pay_action_information_api.create_action_information
13287: (
13280: --abraghun--7668628--Check0056
13281: --
13282: IF l_income_code IN (11,12,13,14,15,17,18) AND l_cao_code IS NULL THEN
13283: fnd_message.set_name('PER','HR_373531_NL_SRTIV_MANDATORY');
13284: fnd_message.set_token('SRTIV',l_income_code);
13285: fnd_message.set_token('TAG','CAO');
13286: pay_action_information_api.create_action_information
13287: (
13288: p_action_information_id => l_action_info_id
13281: --
13282: IF l_income_code IN (11,12,13,14,15,17,18) AND l_cao_code IS NULL THEN
13283: fnd_message.set_name('PER','HR_373531_NL_SRTIV_MANDATORY');
13284: fnd_message.set_token('SRTIV',l_income_code);
13285: fnd_message.set_token('TAG','CAO');
13286: pay_action_information_api.create_action_information
13287: (
13288: p_action_information_id => l_action_info_id
13289: , p_action_context_id => p_assactid
13294: , p_source_id => NULL
13295: , p_source_text => NULL
13296: , p_tax_unit_id => l_tax_unit_id
13297: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
13298: , p_action_information4 => '0056 - '||fnd_message.get
13299: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
13300: , p_action_information6 => '0056 - '||'When the "Income Code" (Tag SrtIV) is equal to 11, 12, 13, 14, 15, 17 or 18, the "Code CAO" (Tag CAO) is mandatory.'
13301: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
13302: , p_action_information8 => l_emp_rec.assignment_number);
13310: IF (months_between(p_effective_date,l_emp_rec.dob)/12)>=65 THEN
13311:
13312: --abraghun--7668628--Check0057
13313: IF l_wao_insured = 'J' THEN
13314: fnd_message.set_name('PER','HR_373532_NL_AGE65_CHECKS');
13315: fnd_message.set_token('AGE',ROUND(months_between(p_effective_date,l_emp_rec.dob)/12));
13316: fnd_message.set_token('TAG','IndWAO');
13317: pay_action_information_api.create_action_information
13318: (
13311:
13312: --abraghun--7668628--Check0057
13313: IF l_wao_insured = 'J' THEN
13314: fnd_message.set_name('PER','HR_373532_NL_AGE65_CHECKS');
13315: fnd_message.set_token('AGE',ROUND(months_between(p_effective_date,l_emp_rec.dob)/12));
13316: fnd_message.set_token('TAG','IndWAO');
13317: pay_action_information_api.create_action_information
13318: (
13319: p_action_information_id => l_action_info_id
13312: --abraghun--7668628--Check0057
13313: IF l_wao_insured = 'J' THEN
13314: fnd_message.set_name('PER','HR_373532_NL_AGE65_CHECKS');
13315: fnd_message.set_token('AGE',ROUND(months_between(p_effective_date,l_emp_rec.dob)/12));
13316: fnd_message.set_token('TAG','IndWAO');
13317: pay_action_information_api.create_action_information
13318: (
13319: p_action_information_id => l_action_info_id
13320: , p_action_context_id => p_assactid
13325: , p_source_id => NULL
13326: , p_source_text => NULL
13327: , p_tax_unit_id => l_tax_unit_id
13328: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
13329: , p_action_information4 => '0057 - '||fnd_message.get
13330: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
13331: , p_action_information6 => '0057 - '||'When the employee reaches the age of 65 in the current period (the age is 65 on the last day of the period), the "Indication WAO/IVA/WGA insured" (Tag IndWAO) cannot be equal to "J".'
13332: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
13333: , p_action_information8 => l_emp_rec.assignment_number);
13333: , p_action_information8 => l_emp_rec.assignment_number);
13334: END IF;
13335: --abraghun--7668628--Check0058
13336: IF l_ww_insured = 'J' THEN
13337: fnd_message.set_name('PER','HR_373532_NL_AGE65_CHECKS');
13338: fnd_message.set_token('AGE',ROUND(months_between(p_effective_date,l_emp_rec.dob)/12));
13339: fnd_message.set_token('TAG','IndWW');
13340: pay_action_information_api.create_action_information
13341: (
13334: END IF;
13335: --abraghun--7668628--Check0058
13336: IF l_ww_insured = 'J' THEN
13337: fnd_message.set_name('PER','HR_373532_NL_AGE65_CHECKS');
13338: fnd_message.set_token('AGE',ROUND(months_between(p_effective_date,l_emp_rec.dob)/12));
13339: fnd_message.set_token('TAG','IndWW');
13340: pay_action_information_api.create_action_information
13341: (
13342: p_action_information_id => l_action_info_id
13335: --abraghun--7668628--Check0058
13336: IF l_ww_insured = 'J' THEN
13337: fnd_message.set_name('PER','HR_373532_NL_AGE65_CHECKS');
13338: fnd_message.set_token('AGE',ROUND(months_between(p_effective_date,l_emp_rec.dob)/12));
13339: fnd_message.set_token('TAG','IndWW');
13340: pay_action_information_api.create_action_information
13341: (
13342: p_action_information_id => l_action_info_id
13343: , p_action_context_id => p_assactid
13348: , p_source_id => NULL
13349: , p_source_text => NULL
13350: , p_tax_unit_id => l_tax_unit_id
13351: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
13352: , p_action_information4 => '0058 - '||fnd_message.get
13353: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
13354: , p_action_information6 => '0058 - '||'When the employee reaches the age of 65 in the current period (the age is 65 on the last day of the period), the "Indication WW insured" (Tag IndWW) cannot be equal to "J".'
13355: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
13356: , p_action_information8 => l_emp_rec.assignment_number);
13356: , p_action_information8 => l_emp_rec.assignment_number);
13357: END IF;
13358: --abraghun--7668628--Check0059
13359: IF l_zw_insured = 'J' THEN
13360: fnd_message.set_name('PER','HR_373532_NL_AGE65_CHECKS');
13361: fnd_message.set_token('AGE',ROUND(months_between(p_effective_date,l_emp_rec.dob)/12));
13362: fnd_message.set_token('TAG','IndZW');
13363: pay_action_information_api.create_action_information
13364: (
13357: END IF;
13358: --abraghun--7668628--Check0059
13359: IF l_zw_insured = 'J' THEN
13360: fnd_message.set_name('PER','HR_373532_NL_AGE65_CHECKS');
13361: fnd_message.set_token('AGE',ROUND(months_between(p_effective_date,l_emp_rec.dob)/12));
13362: fnd_message.set_token('TAG','IndZW');
13363: pay_action_information_api.create_action_information
13364: (
13365: p_action_information_id => l_action_info_id
13358: --abraghun--7668628--Check0059
13359: IF l_zw_insured = 'J' THEN
13360: fnd_message.set_name('PER','HR_373532_NL_AGE65_CHECKS');
13361: fnd_message.set_token('AGE',ROUND(months_between(p_effective_date,l_emp_rec.dob)/12));
13362: fnd_message.set_token('TAG','IndZW');
13363: pay_action_information_api.create_action_information
13364: (
13365: p_action_information_id => l_action_info_id
13366: , p_action_context_id => p_assactid
13371: , p_source_id => NULL
13372: , p_source_text => NULL
13373: , p_tax_unit_id => l_tax_unit_id
13374: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
13375: , p_action_information4 => '0059 - '||fnd_message.get
13376: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
13377: , p_action_information6 => '0059 - '||'When the employee reaches the age of 65 in the current period (the age is 65 on the last day of the period), the "Indication ZW insured" (Tag IndZW) cannot be equal to "J".'
13378: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
13379: , p_action_information8 => l_emp_rec.assignment_number);
13385: --
13386: /*
13387: --abraghun--7668628--Check0060
13388: IF l_wage_tax_table in (221,224,225) AND NVL(l_zvw_situation,'A')<>'G' THEN
13389: fnd_message.set_name('PER','HR_373538_NL_CDZVW_CHECKS');
13390: fnd_message.set_token('TAGVAL1','G');
13391: fnd_message.set_token('TAGVAL2',l_wage_tax_table);
13392:
13393: pay_action_information_api.create_action_information
13386: /*
13387: --abraghun--7668628--Check0060
13388: IF l_wage_tax_table in (221,224,225) AND NVL(l_zvw_situation,'A')<>'G' THEN
13389: fnd_message.set_name('PER','HR_373538_NL_CDZVW_CHECKS');
13390: fnd_message.set_token('TAGVAL1','G');
13391: fnd_message.set_token('TAGVAL2',l_wage_tax_table);
13392:
13393: pay_action_information_api.create_action_information
13394: (
13387: --abraghun--7668628--Check0060
13388: IF l_wage_tax_table in (221,224,225) AND NVL(l_zvw_situation,'A')<>'G' THEN
13389: fnd_message.set_name('PER','HR_373538_NL_CDZVW_CHECKS');
13390: fnd_message.set_token('TAGVAL1','G');
13391: fnd_message.set_token('TAGVAL2',l_wage_tax_table);
13392:
13393: pay_action_information_api.create_action_information
13394: (
13395: p_action_information_id => l_action_info_id
13401: , p_source_id => NULL
13402: , p_source_text => NULL
13403: , p_tax_unit_id => l_tax_unit_id
13404: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
13405: , p_action_information4 => '0060 - '||fnd_message.get
13406: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
13407: , p_action_information6 => '0060 - '||'The "Indication insurance situation Zvw" (Tag CdZvw) can only be equal to "G" when "Code wage tax table" (Tag LbTab) is equal to 221, 224 or 225.'
13408: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
13409: , p_action_information8 => l_emp_rec.assignment_number);
13409: , p_action_information8 => l_emp_rec.assignment_number);
13410: --abraghun--7668628--Check0061
13411: ELSIF l_wage_tax_table =220 AND NVL(l_zvw_situation,'A')<>'H' THEN
13412:
13413: fnd_message.set_name('PER','HR_373538_NL_CDZVW_CHECKS');
13414: fnd_message.set_token('TAGVAL1','H');
13415: fnd_message.set_token('TAGVAL2',l_wage_tax_table);
13416:
13417: pay_action_information_api.create_action_information
13410: --abraghun--7668628--Check0061
13411: ELSIF l_wage_tax_table =220 AND NVL(l_zvw_situation,'A')<>'H' THEN
13412:
13413: fnd_message.set_name('PER','HR_373538_NL_CDZVW_CHECKS');
13414: fnd_message.set_token('TAGVAL1','H');
13415: fnd_message.set_token('TAGVAL2',l_wage_tax_table);
13416:
13417: pay_action_information_api.create_action_information
13418: (
13411: ELSIF l_wage_tax_table =220 AND NVL(l_zvw_situation,'A')<>'H' THEN
13412:
13413: fnd_message.set_name('PER','HR_373538_NL_CDZVW_CHECKS');
13414: fnd_message.set_token('TAGVAL1','H');
13415: fnd_message.set_token('TAGVAL2',l_wage_tax_table);
13416:
13417: pay_action_information_api.create_action_information
13418: (
13419: p_action_information_id => l_action_info_id
13425: , p_source_id => NULL
13426: , p_source_text => NULL
13427: , p_tax_unit_id => l_tax_unit_id
13428: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
13429: , p_action_information4 => '0061 - '||fnd_message.get
13430: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
13431: , p_action_information6 => '0061 - '||'The "Indication insurance situation Zvw" (Tag CdZvw) can only be equal to "H" when "Code wage tax table" (Tag LbTab) is equal to 220.'
13432: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
13433: , p_action_information8 => l_emp_rec.assignment_number);
14404: , p_source_id => NULL
14405: , p_source_text => NULL
14406: , p_tax_unit_id => p_tax_unit_id
14407: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
14408: , p_action_information4 => fnd_message.get_string('PER','HR_373547_NUMIV_OVERRIDE')
14409: , p_action_information5 => fnd_date.date_to_canonical(p_effective_date)
14410: , p_action_information6 => 'Num IV override Already Used'
14411: , p_action_information7 => l_emp_rec.prefix || l_emp_rec.last_name || l_emp_rec.Initials
14412: , p_action_information8 => l_emp_rec.assignment_number);