DBA Data[Home] [Help]

APPS.PAY_NL_WAGE_REPORT_PKG dependencies on PAY_ACTION_INFORMATION_API

Line 2571: pay_action_information_api.create_action_information

2567: END IF;
2568: END IF;
2569: hr_utility.set_location('Archiving LCA details',800);
2570: /* Archive the LCA variables for audit */
2571: pay_action_information_api.create_action_information
2572: (
2573: p_action_information_id => l_action_info_id
2574: , p_action_context_id => p_actid
2575: , p_action_context_type => 'PA'

Line 3912: pay_action_information_api.create_action_information

3908: l_tax_details.tax_reg_num := NVL(l_tax_ref_no,l_tax_details.tax_reg_num);
3909: --
3910: --Archiving Employee Data NL_WR_EMPLOYER_INFO
3911: --Fnd_file.put_line(FND_FILE.LOG,' Archiving NL_WR_EMPLOYER_INFO deinit code ');
3912: pay_action_information_api.create_action_information
3913: (
3914: p_action_information_id => l_action_info_id
3915: , p_action_context_id => p_actid
3916: , p_action_context_type => 'PA'

Line 4085: pay_action_information_api.create_action_information

4081: l_tax_details.tax_reg_num := NVL(l_tax_ref_no,l_tax_details.tax_reg_num);
4082: --
4083: --Archiving Employee Data NL_WR_EMPLOYER_INFO
4084: --Fnd_file.put_line(FND_FILE.LOG,' Archiving NL_WR_EMPLOYER_INFO deinit code ');
4085: pay_action_information_api.create_action_information
4086: (
4087: p_action_information_id => l_action_info_id
4088: , p_action_context_id => p_actid
4089: , p_action_context_type => 'PA'

Line 4798: pay_action_information_api.create_action_information

4794: --
4795: --
4796: --
4797: IF l_empr_contact.sender_id IS NULL THEN
4798: pay_action_information_api.create_action_information
4799: (
4800: p_action_information_id => l_action_info_id
4801: , p_action_context_id => p_actid
4802: , p_action_context_type => 'PA'

Line 4818: pay_action_information_api.create_action_information

4814: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
4815: END IF;
4816: --
4817: IF l_empr_contact.contact_name IS NULL THEN
4818: pay_action_information_api.create_action_information
4819: (
4820: p_action_information_id => l_action_info_id
4821: , p_action_context_id => p_actid
4822: , p_action_context_type => 'PA'

Line 4838: pay_action_information_api.create_action_information

4834: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
4835: END IF;
4836: --
4837: IF l_empr_contact.contact_num IS NULL THEN
4838: pay_action_information_api.create_action_information
4839: (
4840: p_action_information_id => l_action_info_id
4841: , p_action_context_id => p_actid
4842: , p_action_context_type => 'PA'

Line 4858: pay_action_information_api.create_action_information

4854: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
4855: END IF;
4856: --
4857: IF l_tax_details.tax_reg_num IS NULL THEN
4858: pay_action_information_api.create_action_information
4859: (
4860: p_action_information_id => l_action_info_id
4861: , p_action_context_id => p_actid
4862: , p_action_context_type => 'PA'

Line 4879: pay_action_information_api.create_action_information

4875: END IF;
4876: --
4877: IF hr_ni_chk_pkg.chk_nat_id_format(l_tax_details.tax_reg_num,'DDDDDDDDDADD') <> upper(l_tax_details.tax_reg_num) OR
4878: substr(l_tax_details.tax_reg_num,10,1) <> 'L' THEN
4879: pay_action_information_api.create_action_information
4880: (
4881: p_action_information_id => l_action_info_id
4882: , p_action_context_id => p_actid
4883: , p_action_context_type => 'PA'

Line 4899: pay_action_information_api.create_action_information

4895: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
4896: END IF;
4897: --
4898: IF l_tax_details.tax_rep_name IS NULL THEN
4899: pay_action_information_api.create_action_information
4900: (
4901: p_action_information_id => l_action_info_id
4902: , p_action_context_id => p_actid
4903: , p_action_context_type => 'PA'

Line 4920: pay_action_information_api.create_action_information

4916: END IF;
4917: --
4918: --Archiving Employee Data NL_WR_EMPLOYER_INFO
4919: --Fnd_file.put_line(FND_FILE.LOG,' Archiving NL_WR_EMPLOYER_INFO deinit code ');
4920: pay_action_information_api.create_action_information
4921: (
4922: p_action_information_id => l_action_info_id
4923: , p_action_context_id => p_actid
4924: , p_action_context_type => 'PA'

Line 4981: pay_action_information_api.create_action_information

4977: l_sip_sector := NVL(l_sip_sector,l_get_sect_risk_grp.sector);
4978: l_risk_grp := NVL(l_risk_grp,l_get_sect_risk_grp.risk_group);
4979: IF l_sip_sector <> l_get_sect_risk_grp.sector OR l_risk_grp <> l_get_sect_risk_grp.risk_group THEN
4980: --Fnd_file.put_line(FND_FILE.LOG,' Archiving Sector Risk Group Information');
4981: pay_action_information_api.create_action_information
4982: ( p_action_information_id => l_action_info_id
4983: , p_action_context_id => p_actid
4984: , p_action_context_type => 'PA'
4985: , p_object_version_number => l_ovn

Line 5024: pay_action_information_api.create_action_information

5020: --
5021: END LOOP;
5022: IF l_sip_sector IS NOT NULL OR l_risk_grp IS NOT NULL THEN
5023: --Fnd_file.put_line(FND_FILE.LOG,' Archiving Sector Risk Group Information');
5024: pay_action_information_api.create_action_information
5025: ( p_action_information_id => l_action_info_id
5026: , p_action_context_id => p_actid
5027: , p_action_context_type => 'PA'
5028: , p_object_version_number => l_ovn

Line 5065: pay_action_information_api.create_action_information

5061: IF collXMLTable(i).Mandatory = 'Y' or collXMLTable(i).TagValue <> 0 THEN
5062: IF collXMLTable(i).TagName = 'TotTeBet' THEN
5063: l_val := l_emp_total;
5064: END IF;
5065: pay_action_information_api.create_action_information
5066: ( p_action_information_id => l_action_info_id
5067: , p_action_context_id => p_actid
5068: , p_action_context_type => 'PA'
5069: , p_object_version_number => l_ovn

Line 5174: pay_action_information_api.create_action_information

5170:
5171: --
5172: IF g_public_org_flag = 'N' THEN
5173: IF l_sector_flag = 'N' THEN
5174: pay_action_information_api.create_action_information
5175: (
5176: p_action_information_id => l_action_info_id
5177: , p_action_context_id => p_actid
5178: , p_action_context_type => 'PA'

Line 5192: pay_action_information_api.create_action_information

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));
5191: --
5192: pay_action_information_api.create_action_information
5193: (
5194: p_action_information_id => l_action_info_id
5195: , p_action_context_id => p_actid
5196: , p_action_context_type => 'PA'

Line 5212: pay_action_information_api.create_action_information

5208: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
5209: END IF;
5210: --
5211: IF l_awf <> 'N' AND l_c_base_mon_fd_z = 'Y' THEN
5212: pay_action_information_api.create_action_information
5213: (
5214: p_action_information_id => l_action_info_id
5215: , p_action_context_id => p_actid
5216: , p_action_context_type => 'PA'

Line 5232: pay_action_information_api.create_action_information

5228: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
5229: END IF;
5230: --
5231: IF l_awf = 'N' AND l_c_base_mon_fd_z <> 'Y' THEN
5232: pay_action_information_api.create_action_information
5233: (
5234: p_action_information_id => l_action_info_id
5235: , p_action_context_id => p_actid
5236: , p_action_context_type => 'PA'

Line 5309: pay_action_information_api.create_action_information

5305: --
5306: END IF;
5307: l_emp_total := l_emp_total + ROUND(l_corr_bal); --12804323
5308: --Fnd_file.put_line(FND_FILE.LOG,'Archiving NL_WR_COLLECTIVE_REPORT - CORR_BALANCE ');
5309: pay_action_information_api.create_action_information
5310: ( p_action_information_id => l_action_info_id
5311: , p_action_context_id => p_actid
5312: , p_action_context_type => 'PA'
5313: , p_object_version_number => l_ovn

Line 5336: pay_action_information_api.create_action_information

5332: */
5333: END LOOP;
5334: -- Employer general total
5335: --Fnd_file.put_line(FND_FILE.LOG,'Archiving NL_WR_COLLECTIVE_REPORT - TOTAL ');
5336: pay_action_information_api.create_action_information
5337: (p_action_information_id => l_action_info_id
5338: ,p_action_context_id => p_actid
5339: ,p_action_context_type => 'PA'
5340: ,p_object_version_number => l_ovn

Line 5390: pay_action_information_api.create_action_information

5386: l_sip_sector := NVL(l_sip_sector,l_get_sect_risk_grp.sector);
5387: l_risk_grp := NVL(l_risk_grp,l_get_sect_risk_grp.risk_group);
5388: IF l_sip_sector <> l_get_sect_risk_grp.sector OR l_risk_grp <> l_get_sect_risk_grp.risk_group THEN
5389: --Fnd_file.put_line(FND_FILE.LOG,'Archiving NL_WR_SWMF_SECTOR_RISK_GROUP -- CORRECTION');
5390: pay_action_information_api.create_action_information
5391: (
5392: p_action_information_id => l_action_info_id
5393: , p_action_context_id => p_actid
5394: , p_action_context_type => 'PA'

Line 5436: pay_action_information_api.create_action_information

5432: --l_emp_total := l_emp_total + l_con_mon_fd;
5433: --
5434: END LOOP;
5435: IF l_sip_sector IS NOT NULL OR l_risk_grp IS NOT NULL THEN
5436: pay_action_information_api.create_action_information
5437: (
5438: p_action_information_id => l_action_info_id
5439: , p_action_context_id => p_actid
5440: , p_action_context_type => 'PA'

Line 5474: pay_action_information_api.create_action_information

5470: --##--Fnd_file.put_line(FND_FILE.LOG,'#########'||'CORRECTION '||collXMLTable(i).TagName||' '||collXMLTable(i).TagValue||' '||collXMLTable(i).Mandatory);
5471: IF collXMLTable(i).TagName = 'TotTeBet' THEN
5472: l_val := l_emp_total;
5473: END IF;
5474: pay_action_information_api.create_action_information
5475: (
5476: p_action_information_id => l_action_info_id
5477: , p_action_context_id => p_actid
5478: , p_action_context_type => 'PA'

Line 5500: pay_action_information_api.create_action_information

5496: END LOOP;
5497: --
5498: IF g_public_org_flag = 'N' THEN
5499: IF l_sector_flag = 'N' THEN
5500: pay_action_information_api.create_action_information
5501: (
5502: p_action_information_id => l_action_info_id
5503: , p_action_context_id => p_actid
5504: , p_action_context_type => 'PA'

Line 5518: pay_action_information_api.create_action_information

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));
5517: --
5518: pay_action_information_api.create_action_information
5519: (
5520: p_action_information_id => l_action_info_id
5521: , p_action_context_id => p_actid
5522: , p_action_context_type => 'PA'

Line 5538: pay_action_information_api.create_action_information

5534: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
5535: END IF;
5536: --
5537: IF l_awf <> 'N' AND l_c_base_mon_fd_z = 'Y' THEN
5538: pay_action_information_api.create_action_information
5539: (
5540: p_action_information_id => l_action_info_id
5541: , p_action_context_id => p_actid
5542: , p_action_context_type => 'PA'

Line 5558: pay_action_information_api.create_action_information

5554: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
5555: END IF;
5556: --
5557: IF l_awf = 'N' AND l_c_base_mon_fd_z <> 'Y' THEN
5558: pay_action_information_api.create_action_information
5559: (
5560: p_action_information_id => l_action_info_id
5561: , p_action_context_id => p_actid
5562: , p_action_context_type => 'PA'

Line 5641: pay_action_information_api.create_action_information

5637: IF l_sip_sector <> l_get_sect_risk_grp.sector OR l_risk_grp <> l_get_sect_risk_grp.risk_group THEN
5638:
5639:
5640: --Fnd_file.put_line(FND_FILE.LOG,'Archiving NL_WR_SWMF_SECTOR_RISK_GROUP -- CORRECTION');
5641: pay_action_information_api.create_action_information
5642: (
5643: p_action_information_id => l_action_info_id
5644: , p_action_context_id => p_actid
5645: , p_action_context_type => 'PA'

Line 5698: pay_action_information_api.create_action_information

5694: --
5695: END LOOP;
5696:
5697: IF l_sip_sector IS NOT NULL OR l_risk_grp IS NOT NULL THEN
5698: pay_action_information_api.create_action_information
5699: (
5700: p_action_information_id => l_action_info_id
5701: , p_action_context_id => p_actid
5702: , p_action_context_type => 'PA'

Line 5739: pay_action_information_api.create_action_information

5735: --##--Fnd_file.put_line(FND_FILE.LOG,'#########'||'CORRECTION '||collXMLTable(i).TagName||' '||collXMLTable(i).TagValue||' '||collXMLTable(i).Mandatory);
5736: IF collXMLTable(i).TagName = 'TotTeBet' THEN
5737: l_val := l_emp_total;
5738: END IF;
5739: pay_action_information_api.create_action_information
5740: (
5741: p_action_information_id => l_action_info_id
5742: , p_action_context_id => p_actid
5743: , p_action_context_type => 'PA'

Line 5797: pay_action_information_api.create_action_information (

5793: FETCH C_PREV_CORR_YR_WTFUND INTO l_co_col_PrWgf, l_co_col_PrLnPrSectFnds;
5794: CLOSE C_PREV_CORR_YR_WTFUND;
5795: --10100628
5796:
5797: pay_action_information_api.create_action_information (
5798: p_action_information_id => l_action_info_id
5799: ,p_action_context_id => p_actid
5800: ,p_action_context_type => 'PA'
5801: ,p_object_version_number => l_ovn

Line 5846: pay_action_information_api.create_action_information

5842: IF l_sip_sector <> l_get_sect_risk_grp.sector OR l_risk_grp <> l_get_sect_risk_grp.risk_group THEN
5843:
5844:
5845: --Fnd_file.put_line(FND_FILE.LOG,'Archiving NL_WR_SWMF_SECTOR_RISK_GROUP -- CORRECTION');
5846: pay_action_information_api.create_action_information
5847: (
5848: p_action_information_id => l_action_info_id
5849: , p_action_context_id => p_actid
5850: , p_action_context_type => 'PA'

Line 5900: pay_action_information_api.create_action_information

5896: --
5897: END LOOP;
5898:
5899: IF l_sip_sector IS NOT NULL OR l_risk_grp IS NOT NULL THEN
5900: pay_action_information_api.create_action_information
5901: (
5902: p_action_information_id => l_action_info_id
5903: , p_action_context_id => p_actid
5904: , p_action_context_type => 'PA'

Line 5941: pay_action_information_api.create_action_information

5937: --##--Fnd_file.put_line(FND_FILE.LOG,'#########'||'CORRECTION '||collXMLTable(i).TagName||' '||collXMLTable(i).TagValue||' '||collXMLTable(i).Mandatory);
5938: IF collXMLTable(i).TagName = 'TotTeBet' THEN
5939: l_val := l_emp_total;
5940: END IF;
5941: pay_action_information_api.create_action_information
5942: (
5943: p_action_information_id => l_action_info_id
5944: , p_action_context_id => p_actid
5945: , p_action_context_type => 'PA'

Line 5993: pay_action_information_api.create_action_information

5989: --
5990: OPEN csr_employer_info('NL_WR_EMPLOYER_INFO',csr_get_pactid_rec.payroll_action_id);
5991: FETCH csr_employer_info INTO csr_employer_info_rec;
5992: --
5993: pay_action_information_api.create_action_information
5994: (
5995: p_action_information_id => l_action_info_id
5996: , p_action_context_id => p_actid
5997: , p_action_context_type => 'PA'

Line 6021: pay_action_information_api.create_action_information

6017: --
6018: CLOSE csr_employer_info;
6019: --
6020: FOR csr_exception_info_rec IN csr_employer_info('NL_WR_EXCEPTION_REPORT',csr_get_pactid_rec.payroll_action_id) LOOP
6021: pay_action_information_api.create_action_information
6022: (
6023: p_action_information_id => l_action_info_id
6024: , p_action_context_id => p_actid
6025: , p_action_context_type => 'PA'

Line 6375: pay_action_information_api.create_action_information

6371: l_risk_group := csr_swmf_info_rec.action_information8;
6372: l_c_base_mon_fd := csr_swmf_info_rec.action_information9;
6373: l_con_mon_fd := csr_swmf_info_rec.action_information10;
6374: --
6375: pay_action_information_api.create_action_information
6376: (p_action_information_id => l_action_info_id
6377: ,p_action_context_id => p_actid
6378: ,p_action_context_type => 'PA'
6379: ,p_object_version_number => l_ovn

Line 6398: pay_action_information_api.create_action_information

6394: END LOOP;
6395: --
6396: FOR i IN collXMLTable.FIRST..collXMLTable.LAST LOOP
6397: IF collXMLTable(i).Mandatory = 'Y' or collXMLTable(i).TagValue <> 0 THEN
6398: pay_action_information_api.create_action_information
6399: ( p_action_information_id => l_action_info_id
6400: , p_action_context_id => p_actid
6401: , p_action_context_type => 'PA'
6402: , p_object_version_number => l_ovn

Line 6418: pay_action_information_api.create_action_information

6414: , p_action_information6 => fnd_number.number_to_canonical(ROUND(collXMLTable(i).TagValue)));
6415: END IF;
6416: END LOOP;
6417: --
6418: pay_action_information_api.create_action_information
6419: (p_action_information_id => l_action_info_id
6420: ,p_action_context_id => p_actid
6421: ,p_action_context_type => 'PA'
6422: ,p_object_version_number => l_ovn

Line 6475: pay_action_information_api.create_action_information

6471:
6472: FOR er_mismatch IN csr_er_mismatch(p_actid,'INITIAL') LOOP
6473: --abraghun--7668628--Check0036
6474: IF(er_mismatch.NumIVSofi>1) THEN
6475: pay_action_information_api.create_action_information
6476: (
6477: p_action_information_id => l_action_info_id
6478: , p_action_context_id => er_mismatch.ER_assactid
6479: , p_action_context_type => 'AAP'

Line 6495: pay_action_information_api.create_action_information

6491: , p_action_information8 => er_mismatch.ER_assignment_number);
6492: END IF;
6493: --abraghun--7668628--Check0037
6494: IF(er_mismatch.NumIVPersNr>1) THEN
6495: pay_action_information_api.create_action_information
6496: (
6497: p_action_information_id => l_action_info_id
6498: , p_action_context_id => er_mismatch.ER_assactid
6499: , p_action_context_type => 'AAP'

Line 6518: pay_action_information_api.create_action_information

6514:
6515: FOR er_mismatch IN csr_er_mismatch(p_actid,'WITHDRAWAL') LOOP
6516: --abraghun--7668628--Check1036
6517: IF(er_mismatch.NumIVSofi>1) THEN
6518: pay_action_information_api.create_action_information
6519: (
6520: p_action_information_id => l_action_info_id
6521: , p_action_context_id => er_mismatch.ER_assactid
6522: , p_action_context_type => 'AAP'

Line 6538: pay_action_information_api.create_action_information

6534: , p_action_information8 => er_mismatch.ER_assignment_number);
6535: END IF;
6536: --abraghun--7668628--Check1037
6537: IF(er_mismatch.NumIVPersNr>1) THEN
6538: pay_action_information_api.create_action_information
6539: (
6540: p_action_information_id => l_action_info_id
6541: , p_action_context_id => er_mismatch.ER_assactid
6542: , p_action_context_type => 'AAP'

Line 6568: pay_action_information_api.create_action_information

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
6571: , p_action_context_id => p_actid
6572: , p_action_context_type => 'PA'

Line 6595: pay_action_information_api.create_action_information

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
6598: , p_action_context_id => p_actid
6599: , p_action_context_type => 'PA'

Line 6621: pay_action_information_api.create_action_information

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
6625: , p_action_context_type => 'PA'

Line 6647: pay_action_information_api.create_action_information

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
6651: , p_action_context_type => 'PA'

Line 6673: pay_action_information_api.create_action_information

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
6677: , p_action_context_type => 'PA'

Line 6706: pay_action_information_api.create_action_information

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
6710: , p_action_context_type => 'PA'

Line 6732: pay_action_information_api.create_action_information

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
6736: , p_action_context_type => 'PA'

Line 6763: pay_action_information_api.create_action_information

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
6766: , p_action_context_id => p_actid
6767: , p_action_context_type => 'PA'

Line 6790: pay_action_information_api.create_action_information

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
6794: , p_action_context_type => 'PA'

Line 6816: pay_action_information_api.create_action_information

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
6820: , p_action_context_type => 'PA'

Line 6850: pay_action_information_api.create_action_information

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
6854: , p_action_context_type => 'PA'

Line 6876: pay_action_information_api.create_action_information

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
6880: , p_action_context_type => 'PA'

Line 6901: pay_action_information_api.create_action_information

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
6905: , p_action_context_type => 'PA'

Line 6931: pay_action_information_api.create_action_information

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
6935: , p_action_context_type => 'PA'

Line 6958: pay_action_information_api.create_action_information

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
6962: , p_action_context_type => 'PA'

Line 6985: pay_action_information_api.create_action_information

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
6988: , p_action_context_id => p_actid
6989: , p_action_context_type => 'PA'

Line 7018: pay_action_information_api.create_action_information

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
7021: , p_action_context_id => p_actid
7022: , p_action_context_type => 'PA'

Line 7044: pay_action_information_api.create_action_information

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
7048: , p_action_context_type => 'PA'

Line 7069: pay_action_information_api.create_action_information

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
7073: , p_action_context_type => 'PA'

Line 7094: pay_action_information_api.create_action_information

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
7098: , p_action_context_type => 'PA'

Line 7821: pay_action_information_api.create_action_information

7817: IF p_type IN ('INITIAL','CORRECTION') THEN
7818: --
7819: IF (l_addr.style = 'NL' AND l_addr.street_name IS NULL) OR
7820: (l_addr.style <> 'NL' AND l_addr.address_line1 IS NULL)THEN
7821: pay_action_information_api.create_action_information
7822: (
7823: p_action_information_id => l_action_info_id
7824: , p_action_context_id => p_assactid
7825: , p_action_context_type => 'AAP'

Line 7841: pay_action_information_api.create_action_information

7837: , p_action_information8 => p_assignment_number);
7838: END IF;
7839: --
7840: IF l_addr.town_or_city IS NULL THEN
7841: pay_action_information_api.create_action_information
7842: (
7843: p_action_information_id => l_action_info_id
7844: , p_action_context_id => p_assactid
7845: , p_action_context_type => 'AAP'

Line 7861: pay_action_information_api.create_action_information

7857: , p_action_information8 => p_assignment_number);
7858: END IF;
7859: --
7860: IF l_addr.postal_code IS NULL AND l_addr.style = 'NL' THEN
7861: pay_action_information_api.create_action_information
7862: (
7863: p_action_information_id => l_action_info_id
7864: , p_action_context_id => p_assactid
7865: , p_action_context_type => 'AAP'

Line 7881: pay_action_information_api.create_action_information

7877: , p_action_information8 => p_assignment_number);
7878: END IF;
7879: --
7880: IF l_addr.country IS NULL THEN
7881: pay_action_information_api.create_action_information
7882: (
7883: p_action_information_id => l_action_info_id
7884: , p_action_context_id => p_assactid
7885: , p_action_context_type => 'AAP'

Line 7910: pay_action_information_api.create_action_information

7906: IF hr_ni_chk_pkg.chk_nat_id_format(l_addr.postal_code,'DDDD AA') = upper(l_addr.postal_code) OR
7907: hr_ni_chk_pkg.chk_nat_id_format(l_addr.postal_code,'DDDDAA') = upper(l_addr.postal_code) THEN
7908: NULL;
7909: ELSE
7910: pay_action_information_api.create_action_information
7911: (
7912: p_action_information_id => l_action_info_id
7913: , p_action_context_id => p_assactid
7914: , p_action_context_type => 'AAP'

Line 7936: pay_action_information_api.create_action_information (

7932: IF p_prev_corr_year <> '-9999' THEN
7933: l_arc_y_n := IS_ARCHIVED(p_assactid, 'ADDRESS DETAILS', 'INITIAL');
7934: IF p_type = 'INITIAL' THEN
7935: IF l_arc_y_n = 'N' THEN
7936: pay_action_information_api.create_action_information (
7937: p_action_information_id => l_action_info_id
7938: ,p_action_context_id => p_assactid
7939: ,p_action_context_type => 'AAP'
7940: ,p_object_version_number => l_ovn

Line 7960: pay_action_information_api.create_action_information (

7956: ,p_action_information26 => p_type
7957: ,p_action_information27 => p_m_act_info_id); -- add ADD_INFORMATION13 and ADD_INFORMATION14
7958: END IF;
7959: ELSE
7960: pay_action_information_api.create_action_information (
7961: p_action_information_id => l_action_info_id
7962: ,p_action_context_id => p_assactid
7963: ,p_action_context_type => 'AAP'
7964: ,p_object_version_number => l_ovn

Line 7986: pay_action_information_api.create_action_information (

7982: END IF;
7983: ELSE
7984: --10100628
7985:
7986: pay_action_information_api.create_action_information (
7987: p_action_information_id => l_action_info_id
7988: ,p_action_context_id => p_assactid
7989: ,p_action_context_type => 'AAP'
7990: ,p_object_version_number => l_ovn

Line 8017: pay_action_information_api.create_action_information (

8013: IF p_prev_corr_year <> '-9999' THEN
8014: l_arc_y_n := IS_ARCHIVED(p_assactid, 'ADDRESS DETAILS', 'INITIAL');
8015: IF p_type = 'INITIAL' THEN
8016: IF l_arc_y_n = 'N' THEN
8017: pay_action_information_api.create_action_information (
8018: p_action_information_id => l_action_info_id
8019: ,p_action_context_id => p_assactid
8020: ,p_action_context_type => 'AAP'
8021: ,p_object_version_number => l_ovn

Line 8041: pay_action_information_api.create_action_information (

8037: ,p_action_information26 => p_type
8038: ,p_action_information27 => p_m_act_info_id); -- add tel numbers also
8039: END IF;
8040: ELSE
8041: pay_action_information_api.create_action_information (
8042: p_action_information_id => l_action_info_id
8043: ,p_action_context_id => p_assactid
8044: ,p_action_context_type => 'AAP'
8045: ,p_object_version_number => l_ovn

Line 8067: pay_action_information_api.create_action_information (

8063: END IF;
8064: ELSE
8065: --10100628
8066:
8067: pay_action_information_api.create_action_information (
8068: p_action_information_id => l_action_info_id
8069: ,p_action_context_id => p_assactid
8070: ,p_action_context_type => 'AAP'
8071: ,p_object_version_number => l_ovn

Line 8099: pay_action_information_api.create_action_information

8095: --#
8096: --abraghun--7668628--Check0050 already exists.
8097: --
8098: IF l_address_flag = 'N' AND p_type IN ('INITIAL','CORRECTION') THEN
8099: pay_action_information_api.create_action_information
8100: (
8101: p_action_information_id => l_action_info_id
8102: , p_action_context_id => p_assactid
8103: , p_action_context_type => 'AAP'

Line 8205: pay_action_information_api.create_action_information (

8201: l_rec.start_date >= NVL(l_end_date,l_rec.start_date)THEN
8202: l_end_date := l_rec.end_date;
8203: END IF;*/
8204: --
8205: pay_action_information_api.create_action_information (
8206: p_action_information_id => l_action_info_id
8207: , p_action_context_id => p_actid
8208: , p_action_context_type => 'AAP'
8209: , p_object_version_number => l_ovn

Line 8239: pay_action_information_api.create_action_information (

8235: END LOOP;
8236: /*OPEN csr_get_emp_risk_grp(p_assignment_id);
8237: FETCH csr_get_emp_risk_grp INTO l_sector_rec;
8238: IF csr_get_emp_risk_grp%found THEN
8239: pay_action_information_api.create_action_information (
8240: p_action_information_id => l_action_info_id
8241: , p_action_context_id => p_actid
8242: , p_action_context_type => 'AAP'
8243: , p_object_version_number => l_ovn

Line 8581: pay_action_information_api.create_action_information

8577:
8578: BEGIN
8579:
8580: IF p_nom_bal_value(14).balance_value <> 0 AND p_nom_bal_value(16).balance_value <> 0 THEN
8581: pay_action_information_api.create_action_information
8582: (
8583: p_action_information_id => l_action_info_id
8584: , p_action_context_id => p_assactid
8585: , p_action_context_type => 'AAP'

Line 8601: pay_action_information_api.create_action_information

8597: , p_action_information8 => p_assignment_id);
8598: END IF;
8599: --
8600: IF p_nom_bal_value(14).balance_value <> 0 AND p_nom_bal_value(15).balance_value = 0 THEN
8601: pay_action_information_api.create_action_information
8602: (
8603: p_action_information_id => l_action_info_id
8604: , p_action_context_id => p_assactid
8605: , p_action_context_type => 'AAP'

Line 8621: pay_action_information_api.create_action_information

8617: , p_action_information8 => p_assignment_id);
8618: END IF;
8619: --
8620: IF p_nom_bal_value(14).balance_value = 0 AND p_nom_bal_value(15).balance_value <> 0 THEN
8621: pay_action_information_api.create_action_information
8622: (
8623: p_action_information_id => l_action_info_id
8624: , p_action_context_id => p_assactid
8625: , p_action_context_type => 'AAP'

Line 8761: pay_action_information_api.create_action_information (

8757: IF p_prev_corr_year <> '-9999' THEN
8758: l_arc_y_n := IS_ARCHIVED(p_assactid, 'NL_WR_NOMINATIVE_REPORT', 'INITIAL');
8759: IF p_type = 'INITIAL' THEN
8760: IF l_arc_y_n = 'N' THEN
8761: pay_action_information_api.create_action_information (
8762: p_action_information_id => l_action_info_id
8763: , p_action_context_id => p_assactid
8764: , p_action_context_type => 'AAP'
8765: , p_object_version_number => l_ovn

Line 8800: pay_action_information_api.create_action_information (

8796: , p_action_information29 => fnd_number.number_to_canonical(p_nom_bal_value(25).balance_value)); -- 'DIRECTLY_PAID_ALIMONY');
8797: --
8798: END IF;
8799: ELSE
8800: pay_action_information_api.create_action_information (
8801: p_action_information_id => l_action_info_id
8802: , p_action_context_id => p_assactid
8803: , p_action_context_type => 'AAP'
8804: , p_object_version_number => l_ovn

Line 8842: pay_action_information_api.create_action_information (

8838:
8839: l_arc_y_n := IS_ARCHIVED(p_assactid, 'NL_WR_NOMINATIVE_REPORT_ADD', 'INITIAL');
8840: IF p_type = 'INITIAL' THEN
8841: IF l_arc_y_n = 'N' THEN
8842: pay_action_information_api.create_action_information (
8843: p_action_information_id => l_action_info_id
8844: , p_action_context_id => p_assactid
8845: , p_action_context_type => 'AAP'
8846: , p_object_version_number => l_ovn

Line 8871: pay_action_information_api.create_action_information (

8867: --LC 2010--end
8868: --
8869: END IF;
8870: ELSE
8871: pay_action_information_api.create_action_information (
8872: p_action_information_id => l_action_info_id
8873: , p_action_context_id => p_assactid
8874: , p_action_context_type => 'AAP'
8875: , p_object_version_number => l_ovn

Line 8903: pay_action_information_api.create_action_information (

8899:
8900: ELSE
8901: --10100628
8902:
8903: pay_action_information_api.create_action_information (
8904: p_action_information_id => l_action_info_id
8905: , p_action_context_id => p_assactid
8906: , p_action_context_type => 'AAP'
8907: , p_object_version_number => l_ovn

Line 8940: pay_action_information_api.create_action_information (

8936: , p_action_information27 => fnd_number.number_to_canonical(p_nom_bal_value(23).balance_value) -- 'AMOUNT_SEE_DISCONT_DAYS'
8937: , p_action_information28 => fnd_number.number_to_canonical(p_nom_bal_value(24).balance_value) -- 'WWB-ALL_ALIMONY'
8938: , p_action_information29 => fnd_number.number_to_canonical(p_nom_bal_value(25).balance_value)); -- 'DIRECTLY_PAID_ALIMONY');
8939: --
8940: pay_action_information_api.create_action_information (
8941: p_action_information_id => l_action_info_id
8942: , p_action_context_id => p_assactid
8943: , p_action_context_type => 'AAP'
8944: , p_object_version_number => l_ovn

Line 10663: pay_action_information_api.create_action_information (

10659: OPEN csr_numiv_override(p_assignment_id);
10660: FETCH csr_numiv_override INTO l_numiv_override;
10661: CLOSE csr_numiv_override;
10662:
10663: pay_action_information_api.create_action_information (
10664: p_action_information_id => l_master_action_info_id
10665: ,p_action_context_id => p_assactid
10666: ,p_action_context_type => 'AAP'
10667: ,p_object_version_number => l_ovn

Line 10703: pay_action_information_api.create_action_information

10699: l_num_over_clash:=HR_NL_ASG_EXTRA_INFO_CHECKS.ASG_CHECK_NUMIV_OVERRIDE(l_emp_rec.assignment_id,nvl(l_numiv_override,l_emp_seq));
10700: -- Fnd_file.put_line(FND_FILE.LOG,' NUMIV: After l_num_over_clash: '|| to_char(l_num_over_clash));
10701: --
10702: IF l_num_over_clash=1 THEN
10703: pay_action_information_api.create_action_information
10704: (
10705: p_action_information_id => l_action_info_id
10706: , p_action_context_id => p_assactid
10707: , p_action_context_type => 'AAP'

Line 10754: pay_action_information_api.create_action_information (

10750:
10751: IF p_prev_corr_year <> '-9999' THEN
10752: l_arc_y_n := IS_ARCHIVED(p_assactid, 'NL_WR_EMPLOYMENT_INFO', 'INITIAL');
10753: IF l_arc_y_n = 'N' THEN
10754: pay_action_information_api.create_action_information (
10755: p_action_information_id => l_master_action_info_id
10756: ,p_action_context_id => p_assactid
10757: ,p_action_context_type => 'AAP'
10758: ,p_object_version_number => l_ovn

Line 10787: pay_action_information_api.create_action_information (

10783:
10784: END IF;
10785: ELSE
10786: --10100628
10787: pay_action_information_api.create_action_information (
10788: p_action_information_id => l_master_action_info_id
10789: ,p_action_context_id => p_assactid
10790: ,p_action_context_type => 'AAP'
10791: ,p_object_version_number => l_ovn

Line 10828: pay_action_information_api.create_action_information

10824: l_num_over_clash:=HR_NL_ASG_EXTRA_INFO_CHECKS.ASG_CHECK_NUMIV_OVERRIDE(l_emp_rec.assignment_id,nvl(l_numiv_override,l_emp_seq));
10825: -- Fnd_file.put_line(FND_FILE.LOG,' NUMIV: After l_num_over_clash: '|| to_char(l_num_over_clash));
10826: --
10827: IF l_num_over_clash=1 THEN
10828: pay_action_information_api.create_action_information
10829: (
10830: p_action_information_id => l_action_info_id
10831: , p_action_context_id => p_assactid
10832: , p_action_context_type => 'AAP'

Line 10979: pay_action_information_api.create_action_information (

10975: IF p_prev_corr_year <> '-9999' THEN
10976: l_arc_y_n := IS_ARCHIVED(p_assactid, 'NL_WR_INCOME_PERIOD', 'INITIAL');
10977: IF l_arc_y_n = 'N' THEN
10978:
10979: pay_action_information_api.create_action_information (
10980: p_action_information_id => l_action_info_id
10981: , p_action_context_id => p_assactid
10982: , p_action_context_type => 'AAP'
10983: , p_object_version_number => l_ovn

Line 11020: pay_action_information_api.create_action_information (

11016: END IF;
11017: ELSE
11018: --10100628
11019:
11020: pay_action_information_api.create_action_information (
11021: p_action_information_id => l_action_info_id
11022: , p_action_context_id => p_assactid
11023: , p_action_context_type => 'AAP'
11024: , p_object_version_number => l_ovn

Line 11484: pay_action_information_api.create_action_information (

11480: IF p_prev_corr_year <> '-9999' THEN
11481: l_arc_y_n := IS_ARCHIVED(p_assactid, 'NL_WR_EMPLOYMENT_INFO', 'INITIAL');
11482: IF l_type = 'INITIAL' THEN
11483: IF l_arc_y_n = 'N' THEN
11484: pay_action_information_api.create_action_information (
11485: p_action_information_id => l_master_action_info_id
11486: ,p_action_context_id => p_assactid
11487: ,p_action_context_type => 'AAP'
11488: ,p_object_version_number => l_ovn

Line 11515: pay_action_information_api.create_action_information (

11511: ,p_action_information17 => l_rec_changes(i).retro
11512: ,p_action_information18 => nvl(l_numiv_override,l_emp_seq)); -- 8328995
11513: END IF;
11514: ELSE
11515: pay_action_information_api.create_action_information (
11516: p_action_information_id => l_master_action_info_id
11517: ,p_action_context_id => p_assactid
11518: ,p_action_context_type => 'AAP'
11519: ,p_object_version_number => l_ovn

Line 11547: pay_action_information_api.create_action_information (

11543: ,p_action_information18 => nvl(l_numiv_override,l_emp_seq)); -- 8328995
11544: END IF;
11545: ELSE
11546: --10100628
11547: pay_action_information_api.create_action_information (
11548: p_action_information_id => l_master_action_info_id
11549: ,p_action_context_id => p_assactid
11550: ,p_action_context_type => 'AAP'
11551: ,p_object_version_number => l_ovn

Line 11590: pay_action_information_api.create_action_information

11586: l_num_over_clash:=HR_NL_ASG_EXTRA_INFO_CHECKS.ASG_CHECK_NUMIV_OVERRIDE(l_emp_rec.assignment_id,nvl(l_numiv_override,l_emp_seq));
11587: -- Fnd_file.put_line(FND_FILE.LOG,' NUMIV: After l_num_over_clash: '|| to_char(l_num_over_clash));
11588: --
11589: IF l_num_over_clash=1 THEN
11590: pay_action_information_api.create_action_information
11591: (
11592: p_action_information_id => l_action_info_id
11593: , p_action_context_id => p_assactid
11594: , p_action_context_type => 'AAP'

Line 11612: pay_action_information_api.create_action_information

11608: --
11609: --Check0044 Check1044
11610: IF l_emp_rec.sofi_number is null AND l_emp_rec.employee_number is null THEN
11611: --
11612: pay_action_information_api.create_action_information
11613: (
11614: p_action_information_id => l_action_info_id
11615: , p_action_context_id => p_assactid
11616: , p_action_context_type => 'AAP'

Line 11643: pay_action_information_api.create_action_information

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
11646: , p_action_context_id => p_assactid
11647: , p_action_context_type => 'AAP'

Line 11669: pay_action_information_api.create_action_information

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
11672: , p_action_context_id => p_assactid
11673: , p_action_context_type => 'AAP'

Line 11695: pay_action_information_api.create_action_information

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
11698: , p_action_context_id => p_assactid
11699: , p_action_context_type => 'AAP'

Line 11721: pay_action_information_api.create_action_information

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
11724: , p_action_context_id => p_assactid
11725: , p_action_context_type => 'AAP'

Line 11750: pay_action_information_api.create_action_information

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
11753: , p_action_context_id => p_assactid
11754: , p_action_context_type => 'AAP'

Line 11792: pay_action_information_api.create_action_information

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: (
11794: p_action_information_id => l_action_info_id
11795: , p_action_context_id => p_assactid
11796: , p_action_context_type => 'AAP'

Line 11822: pay_action_information_api.create_action_information

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
11825: , p_action_context_id => p_assactid
11826: , p_action_context_type => 'AAP'

Line 11845: pay_action_information_api.create_action_information

11841: --
11842: --abraghun--7668628--Check0042
11843: IF l_emp_rec.change_reason is not null AND l_labour_rel_code <> 11 THEN
11844: --
11845: pay_action_information_api.create_action_information
11846: (
11847: p_action_information_id => l_action_info_id
11848: , p_action_context_id => p_assactid
11849: , p_action_context_type => 'AAP'

Line 11868: pay_action_information_api.create_action_information

11864: --
11865: --abraghun--7668628--Check0043
11866: IF l_emp_rec.change_reason is not null AND l_emp_end_date is null THEN
11867: --
11868: pay_action_information_api.create_action_information
11869: (
11870: p_action_information_id => l_action_info_id
11871: , p_action_context_id => p_assactid
11872: , p_action_context_type => 'AAP'

Line 11936: pay_action_information_api.create_action_information

11932: ,p_payroll_type);
11933: --#
11934: IF l_srg_flag = 'N' AND (l_wao_insured = 'Y' OR l_ww_insured = 'Y' OR l_zw_insured = 'Y') THEN
11935: --
11936: pay_action_information_api.create_action_information
11937: (
11938: p_action_information_id => l_action_info_id
11939: , p_action_context_id => p_assactid
11940: , p_action_context_type => 'AAP'

Line 12002: pay_action_information_api.create_action_information

11998: --LC 2012 begin
11999: IF p_effective_date < TO_DATE('01012012','DDMMYYYY') THEN
12000: --LC 2010--begins
12001: IF l_zvw_small_jobs = 'D' THEN
12002: pay_action_information_api.create_action_information
12003: (
12004: p_action_information_id => l_action_info_id
12005: , p_action_context_id => p_assactid
12006: , p_action_context_type => 'AAP'

Line 12021: pay_action_information_api.create_action_information

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);
12019: END IF;
12020: IF l_zvw_small_jobs = 'W' THEN
12021: pay_action_information_api.create_action_information
12022: (
12023: p_action_information_id => l_action_info_id
12024: , p_action_context_id => p_assactid
12025: , p_action_context_type => 'AAP'

Line 12045: pay_action_information_api.create_action_information

12041: --LC 2012 end
12042:
12043: --#
12044: IF l_zvw_defaulted = 'Y' THEN
12045: pay_action_information_api.create_action_information
12046: (
12047: p_action_information_id => l_action_info_id
12048: , p_action_context_id => p_assactid
12049: , p_action_context_type => 'AAP'

Line 12067: pay_action_information_api.create_action_information

12063: --
12064: --abraghun--7668628--Check0053 -- already exists.
12065: --
12066: IF l_income_code IN (11,12,13,14,15,18) AND l_labour_rel_code IS NULL THEN
12067: pay_action_information_api.create_action_information
12068: (
12069: p_action_information_id => l_action_info_id
12070: , p_action_context_id => p_assactid
12071: , p_action_context_type => 'AAP'

Line 12089: pay_action_information_api.create_action_information

12085: --
12086: --abraghun--7668628--Check0055 - already exists.
12087: --
12088: IF l_income_code IN (11,12,13,14,15,18) AND l_assignment_catg IS NULL THEN
12089: pay_action_information_api.create_action_information
12090: (
12091: p_action_information_id => l_action_info_id
12092: , p_action_context_id => p_assactid
12093: , p_action_context_type => 'AAP'

Line 12109: pay_action_information_api.create_action_information

12105: , p_action_information8 => l_emp_rec.assignment_number);
12106: END IF;
12107: --
12108: IF l_income_code IN (11,12,13,14,15,18) AND l_work_pattern IS NULL AND g_effective_date < TO_DATE('01012007','DDMMYYYY') THEN
12109: pay_action_information_api.create_action_information
12110: (
12111: p_action_information_id => l_action_info_id
12112: , p_action_context_id => p_assactid
12113: , p_action_context_type => 'AAP'

Line 12129: pay_action_information_api.create_action_information

12125: , p_action_information8 => l_emp_rec.assignment_number);
12126: END IF;
12127: --
12128: IF l_srg_flag = 'Z' AND l_FZ_Code IS NULL THEN
12129: pay_action_information_api.create_action_information
12130: (
12131: p_action_information_id => l_action_info_id
12132: , p_action_context_id => p_assactid
12133: , p_action_context_type => 'AAP'

Line 12149: pay_action_information_api.create_action_information

12145: , p_action_information8 => l_emp_rec.assignment_number);
12146: END IF;
12147: --
12148: IF l_company_car_use = 4 AND g_effective_date > to_date('01012007','ddmmyyyy') THEN
12149: pay_action_information_api.create_action_information
12150: (
12151: p_action_information_id => l_action_info_id
12152: , p_action_context_id => p_assactid
12153: , p_action_context_type => 'AAP'

Line 12175: pay_action_information_api.create_action_information (

12171: IF p_prev_corr_year <> '-9999' THEN
12172: l_arc_y_n := IS_ARCHIVED(p_assactid, 'NL_WR_INCOME_PERIOD', 'INITIAL');
12173: IF l_type = 'INITIAL' THEN
12174: IF l_arc_y_n = 'N' THEN
12175: pay_action_information_api.create_action_information (
12176: p_action_information_id => l_action_info_id
12177: , p_action_context_id => p_assactid
12178: , p_action_context_type => 'AAP'
12179: , p_object_version_number => l_ovn

Line 12214: pay_action_information_api.create_action_information (

12210: , p_action_information29 => l_wm_old_rule/*LC 2010*/
12211: , p_action_information30 => l_temp_tax_discount);/* LC 2013*/
12212: END IF;
12213: ELSE
12214: pay_action_information_api.create_action_information (
12215: p_action_information_id => l_action_info_id
12216: , p_action_context_id => p_assactid
12217: , p_action_context_type => 'AAP'
12218: , p_object_version_number => l_ovn

Line 12254: pay_action_information_api.create_action_information (

12250: , p_action_information30 => l_temp_tax_discount);/* LC 2013*/
12251: END IF;
12252: ELSE
12253: --10100628
12254: pay_action_information_api.create_action_information (
12255: p_action_information_id => l_action_info_id
12256: , p_action_context_id => p_assactid
12257: , p_action_context_type => 'AAP'
12258: , p_object_version_number => l_ovn

Line 12296: pay_action_information_api.create_action_information

12292:
12293: --abraghun--7668628--Validation Code
12294: --abraghun--7668628--Check0054
12295: IF l_income_code=18 AND l_labour_rel_code <> 18 THEN
12296: pay_action_information_api.create_action_information
12297: (
12298: p_action_information_id => l_action_info_id
12299: , p_action_context_id => p_assactid
12300: , p_action_context_type => 'AAP'

Line 12325: pay_action_information_api.create_action_information

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: (
12327: p_action_information_id => l_action_info_id
12328: , p_action_context_id => p_assactid
12329: , p_action_context_type => 'AAP'

Line 12354: pay_action_information_api.create_action_information

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
12358: , p_action_context_type => 'AAP'

Line 12377: pay_action_information_api.create_action_information

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
12381: , p_action_context_type => 'AAP'

Line 12400: pay_action_information_api.create_action_information

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
12404: , p_action_context_type => 'AAP'

Line 12432: pay_action_information_api.create_action_information

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
12435: , p_action_context_id => p_assactid
12436: , p_action_context_type => 'AAP'

Line 12456: pay_action_information_api.create_action_information

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
12459: , p_action_context_id => p_assactid
12460: , p_action_context_type => 'AAP'

Line 12508: pay_action_information_api.create_action_information (

12504: IF p_prev_corr_year <> '-9999' THEN
12505: l_arc_y_n := IS_ARCHIVED(p_assactid, 'NL_WR_EMPLOYMENT_INFO', 'INITIAL');
12506: IF l_type = 'INITIAL' THEN
12507: IF l_arc_y_n = 'N' THEN
12508: pay_action_information_api.create_action_information (
12509: p_action_information_id => l_master_action_info_id
12510: ,p_action_context_id => p_assactid
12511: ,p_action_context_type => 'AAP'
12512: ,p_object_version_number => l_ovn

Line 12539: pay_action_information_api.create_action_information (

12535: ,p_action_information17 => NULL
12536: ,p_action_information18 => nvl(l_numiv_override,l_emp_seq)); -- 8328995
12537: END IF;
12538: ELSE
12539: pay_action_information_api.create_action_information (
12540: p_action_information_id => l_master_action_info_id
12541: ,p_action_context_id => p_assactid
12542: ,p_action_context_type => 'AAP'
12543: ,p_object_version_number => l_ovn

Line 12571: pay_action_information_api.create_action_information (

12567: ,p_action_information18 => nvl(l_numiv_override,l_emp_seq)); -- 8328995
12568: END IF;
12569: ELSE
12570: --10100628
12571: pay_action_information_api.create_action_information (
12572: p_action_information_id => l_master_action_info_id
12573: ,p_action_context_id => p_assactid
12574: ,p_action_context_type => 'AAP'
12575: ,p_object_version_number => l_ovn

Line 12614: pay_action_information_api.create_action_information

12610: l_num_over_clash:=HR_NL_ASG_EXTRA_INFO_CHECKS.ASG_CHECK_NUMIV_OVERRIDE(l_emp_rec.assignment_id,nvl(l_numiv_override,l_emp_seq));
12611: -- Fnd_file.put_line(FND_FILE.LOG,' NUMIV: After l_num_over_clash: '|| to_char(l_num_over_clash));
12612: --
12613: IF l_num_over_clash=1 THEN
12614: pay_action_information_api.create_action_information
12615: (
12616: p_action_information_id => l_action_info_id
12617: , p_action_context_id => p_assactid
12618: , p_action_context_type => 'AAP'

Line 12639: pay_action_information_api.create_action_information

12635: --
12636: --abraghun--7668628--Check0044 Check1044
12637: IF l_emp_rec.sofi_number is null AND l_emp_rec.employee_number is null THEN
12638: --
12639: pay_action_information_api.create_action_information
12640: (
12641: p_action_information_id => l_action_info_id
12642: , p_action_context_id => p_assactid
12643: , p_action_context_type => 'AAP'

Line 12669: pay_action_information_api.create_action_information

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
12672: , p_action_context_id => p_assactid
12673: , p_action_context_type => 'AAP'

Line 12695: pay_action_information_api.create_action_information

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
12698: , p_action_context_id => p_assactid
12699: , p_action_context_type => 'AAP'

Line 12721: pay_action_information_api.create_action_information

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
12724: , p_action_context_id => p_assactid
12725: , p_action_context_type => 'AAP'

Line 12747: pay_action_information_api.create_action_information

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
12750: , p_action_context_id => p_assactid
12751: , p_action_context_type => 'AAP'

Line 12777: pay_action_information_api.create_action_information

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
12780: , p_action_context_id => p_assactid
12781: , p_action_context_type => 'AAP'

Line 12818: pay_action_information_api.create_action_information

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: (
12820: p_action_information_id => l_action_info_id
12821: , p_action_context_id => p_assactid
12822: , p_action_context_type => 'AAP'

Line 12848: pay_action_information_api.create_action_information

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
12851: , p_action_context_id => p_assactid
12852: , p_action_context_type => 'AAP'

Line 12871: pay_action_information_api.create_action_information

12867: --
12868: --abraghun--7668628--Check0042
12869: IF l_emp_rec.change_reason is not null AND l_labour_rel_code <> 11 THEN
12870: --
12871: pay_action_information_api.create_action_information
12872: (
12873: p_action_information_id => l_action_info_id
12874: , p_action_context_id => p_assactid
12875: , p_action_context_type => 'AAP'

Line 12894: pay_action_information_api.create_action_information

12890: --
12891: --abraghun--7668628--Check0043
12892: IF l_emp_rec.change_reason is not null AND l_emp_end_date is null THEN
12893: --
12894: pay_action_information_api.create_action_information
12895: (
12896: p_action_information_id => l_action_info_id
12897: , p_action_context_id => p_assactid
12898: , p_action_context_type => 'AAP'

Line 12945: pay_action_information_api.create_action_information

12941: ,p_payroll_type);
12942: --#
12943: IF l_srg_flag = 'N' AND (l_wao_insured = 'Y' OR l_ww_insured = 'Y' OR l_zw_insured = 'Y') THEN
12944: --
12945: pay_action_information_api.create_action_information
12946: (
12947: p_action_information_id => l_action_info_id
12948: , p_action_context_id => p_assactid
12949: , p_action_context_type => 'AAP'

Line 12969: pay_action_information_api.create_action_information

12965: --LC 2012 begin
12966: IF p_effective_date < TO_DATE('01012012','DDMMYYYY') THEN
12967: --LC 2010--begins
12968: IF l_zvw_small_jobs = 'D' THEN
12969: pay_action_information_api.create_action_information
12970: (
12971: p_action_information_id => l_action_info_id
12972: , p_action_context_id => p_assactid
12973: , p_action_context_type => 'AAP'

Line 12988: pay_action_information_api.create_action_information

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);
12986: END IF;
12987: IF l_zvw_small_jobs = 'W' THEN
12988: pay_action_information_api.create_action_information
12989: (
12990: p_action_information_id => l_action_info_id
12991: , p_action_context_id => p_assactid
12992: , p_action_context_type => 'AAP'

Line 13011: pay_action_information_api.create_action_information

13007: END IF;
13008: --LC 2012 end
13009: --#
13010: IF l_zvw_defaulted = 'Y' THEN
13011: pay_action_information_api.create_action_information
13012: (
13013: p_action_information_id => l_action_info_id
13014: , p_action_context_id => p_assactid
13015: , p_action_context_type => 'AAP'

Line 13032: pay_action_information_api.create_action_information

13028: END IF;
13029: --
13030: --abraghun--8552196--Check0053 - Prefixed Errorcode to existing Error message.
13031: IF l_income_code IN (11,12,13,14,15,18) AND l_labour_rel_code IS NULL THEN
13032: pay_action_information_api.create_action_information
13033: (
13034: p_action_information_id => l_action_info_id
13035: , p_action_context_id => p_assactid
13036: , p_action_context_type => 'AAP'

Line 13053: pay_action_information_api.create_action_information

13049: END IF;
13050: --
13051: --abraghun--8552196--Check0055 - Prefixed Errorcode to existing Error message.
13052: IF l_income_code IN (11,12,13,14,15,18) AND l_assignment_catg IS NULL THEN
13053: pay_action_information_api.create_action_information
13054: (
13055: p_action_information_id => l_action_info_id
13056: , p_action_context_id => p_assactid
13057: , p_action_context_type => 'AAP'

Line 13073: pay_action_information_api.create_action_information

13069: , p_action_information8 => l_emp_rec.assignment_number);
13070: END IF;
13071: --
13072: IF l_income_code IN (11,12,13,14,15,18) AND l_work_pattern IS NULL AND g_effective_date < TO_DATE('01012007','DDMMYYYY') THEN
13073: pay_action_information_api.create_action_information
13074: (
13075: p_action_information_id => l_action_info_id
13076: , p_action_context_id => p_assactid
13077: , p_action_context_type => 'AAP'

Line 13093: pay_action_information_api.create_action_information

13089: , p_action_information8 => l_emp_rec.assignment_number);
13090: END IF;
13091: --
13092: IF l_srg_flag = 'Z' AND l_FZ_Code IS NULL THEN
13093: pay_action_information_api.create_action_information
13094: (
13095: p_action_information_id => l_action_info_id
13096: , p_action_context_id => p_assactid
13097: , p_action_context_type => 'AAP'

Line 13113: pay_action_information_api.create_action_information

13109: , p_action_information8 => l_emp_rec.assignment_number);
13110: END IF;
13111: --
13112: IF l_company_car_use = 4 AND g_effective_date > to_date('01012007','ddmmyyyy') THEN
13113: pay_action_information_api.create_action_information
13114: (
13115: p_action_information_id => l_action_info_id
13116: , p_action_context_id => p_assactid
13117: , p_action_context_type => 'AAP'

Line 13140: pay_action_information_api.create_action_information (

13136: IF p_prev_corr_year <> '-9999' THEN
13137: l_arc_y_n := IS_ARCHIVED(p_assactid, 'NL_WR_INCOME_PERIOD', 'INITIAL');
13138: IF l_type = 'INITIAL' THEN
13139: IF l_arc_y_n = 'N' THEN
13140: pay_action_information_api.create_action_information (
13141: p_action_information_id => l_action_info_id
13142: , p_action_context_id => p_assactid
13143: , p_action_context_type => 'AAP'
13144: , p_object_version_number => l_ovn

Line 13179: pay_action_information_api.create_action_information (

13175: , p_action_information29 => l_wm_old_rule/*LC 2010*/ --WgldOudRegl
13176: , p_action_information30 => l_temp_tax_discount);/* LC 2013*/ --IndTijdHk
13177: END IF;
13178: ELSE
13179: pay_action_information_api.create_action_information (
13180: p_action_information_id => l_action_info_id
13181: , p_action_context_id => p_assactid
13182: , p_action_context_type => 'AAP'
13183: , p_object_version_number => l_ovn

Line 13220: pay_action_information_api.create_action_information (

13216: END IF;
13217:
13218: ELSE
13219: --10100628
13220: pay_action_information_api.create_action_information (
13221: p_action_information_id => l_action_info_id
13222: , p_action_context_id => p_assactid
13223: , p_action_context_type => 'AAP'
13224: , p_object_version_number => l_ovn

Line 13261: pay_action_information_api.create_action_information

13257: END IF; --10100628
13258: --abraghun--7668628--Validation Code
13259: --abraghun--7668628--Check0054
13260: IF l_income_code=18 AND l_labour_rel_code <> 18 THEN
13261: pay_action_information_api.create_action_information
13262: (
13263: p_action_information_id => l_action_info_id
13264: , p_action_context_id => p_assactid
13265: , p_action_context_type => 'AAP'

Line 13286: pay_action_information_api.create_action_information

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
13290: , p_action_context_type => 'AAP'

Line 13317: pay_action_information_api.create_action_information

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
13321: , p_action_context_type => 'AAP'

Line 13340: pay_action_information_api.create_action_information

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
13344: , p_action_context_type => 'AAP'

Line 13363: pay_action_information_api.create_action_information

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
13367: , p_action_context_type => 'AAP'

Line 13393: pay_action_information_api.create_action_information

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
13396: , p_action_context_id => p_assactid
13397: , p_action_context_type => 'AAP'

Line 13417: pay_action_information_api.create_action_information

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
13420: , p_action_context_id => p_assactid
13421: , p_action_context_type => 'AAP'

Line 13615: pay_action_information_api.create_action_information (

13611: --
13612: l_empt_action_info_id := csr_action_info_rec.action_information_id;
13613: l_action_context_id := csr_action_info_rec.action_context_id;
13614: --
13615: pay_action_information_api.create_action_information (
13616: p_action_information_id => l_master_action_info_id
13617: ,p_action_context_id => p_assactid
13618: ,p_action_context_type => 'AAP'
13619: ,p_object_version_number => l_ovn

Line 13646: pay_action_information_api.create_action_information

13642: ,p_action_information17 => csr_action_info_rec.action_information17
13643: ,p_action_information18 => csr_action_info_rec.action_information18);
13644: --
13645: FOR csr_exception_info_rec IN csr_exception_info('NL_WR_EXCEPTION_REPORT',csr_action_info_rec.action_context_id) LOOP
13646: pay_action_information_api.create_action_information
13647: (
13648: p_action_information_id => l_action_info_id
13649: , p_action_context_id => p_assactid
13650: , p_action_context_type => 'AAP'

Line 13676: pay_action_information_api.create_action_information (

13672: FETCH csr_get_income_start_date INTO l_date;
13673: CLOSE csr_get_income_start_date;
13674: --Fnd_file.put_line(FND_FILE.LOG,'~~## IN NL_WR_INCOME_PERIOD');
13675: --Fnd_file.put_line(FND_FILE.LOG,'~~## l_empt_action_info_id '||l_empt_action_info_id);
13676: pay_action_information_api.create_action_information (
13677: p_action_information_id => l_action_info_id
13678: ,p_action_context_id => p_assactid
13679: ,p_action_context_type => 'AAP'
13680: ,p_object_version_number => l_ovn

Line 13723: pay_action_information_api.create_action_information (

13719: OPEN csr_get_sector_start_date(p_assactid,p_assignment_id,csr_srg_info_rec.action_information7,csr_srg_info_rec.action_information8);
13720: FETCH csr_get_sector_start_date INTO l_date;
13721: CLOSE csr_get_sector_start_date;
13722: --Fnd_file.put_line(FND_FILE.LOG,'~~## IN NL_WR_SWMF_SECTOR_RISK_GROUP');
13723: pay_action_information_api.create_action_information (
13724: p_action_information_id => l_action_info_id
13725: ,p_action_context_id => p_assactid
13726: ,p_action_context_type => 'AAP'
13727: ,p_object_version_number => l_ovn

Line 13748: pay_action_information_api.create_action_information (

13744: --
13745: FOR csr_address_info_rec IN csr_address_info('ADDRESS DETAILS','INITIAL',l_empt_action_info_id,l_action_context_id) LOOP
13746: --
13747: --Fnd_file.put_line(FND_FILE.LOG,'~~## IN ADD Det');
13748: pay_action_information_api.create_action_information (
13749: p_action_information_id => l_action_info_id
13750: ,p_action_context_id => p_assactid
13751: ,p_action_context_type => 'AAP'
13752: ,p_object_version_number => l_ovn

Line 13778: pay_action_information_api.create_action_information (

13774: --
13775: FOR csr_nominative_info_rec IN csr_nominative_info('NL_WR_NOMINATIVE_REPORT','INITIAL',p_assactid) LOOP
13776: --
13777: --Fnd_file.put_line(FND_FILE.LOG,'~~## IN NL_WR_NOMINATIVE_REPORT');
13778: pay_action_information_api.create_action_information (
13779: p_action_information_id => l_action_info_id
13780: ,p_action_context_id => p_assactid
13781: ,p_action_context_type => 'AAP'
13782: ,p_object_version_number => l_ovn

Line 13825: pay_action_information_api.create_action_information (

13821: --
13822: FOR csr_nominative_info_rec IN csr_nominative_info('NL_WR_NOMINATIVE_REPORT_ADD','INITIAL',p_assactid) LOOP
13823: --
13824: --Fnd_file.put_line(FND_FILE.LOG,'~~## IN NL_WR_NOMINATIVE_REPORT');
13825: pay_action_information_api.create_action_information (
13826: p_action_information_id => l_action_info_id
13827: ,p_action_context_id => p_assactid
13828: ,p_action_context_type => 'AAP'
13829: ,p_object_version_number => l_ovn

Line 14356: pay_action_information_api.create_action_information (

14352: OPEN csr_numiv_override(p_assignment_id);
14353: FETCH csr_numiv_override INTO l_numiv_override;
14354: CLOSE csr_numiv_override;
14355:
14356: pay_action_information_api.create_action_information (
14357: p_action_information_id => l_master_action_info_id
14358: ,p_action_context_id => p_assactid
14359: ,p_action_context_type => 'AAP'
14360: ,p_object_version_number => l_ovn

Line 14396: pay_action_information_api.create_action_information

14392: l_num_over_clash:=HR_NL_ASG_EXTRA_INFO_CHECKS.ASG_CHECK_NUMIV_OVERRIDE(l_emp_rec.assignment_id,nvl(l_numiv_override,l_emp_seq));
14393: -- Fnd_file.put_line(FND_FILE.LOG,' NUMIV: After l_num_over_clash: '|| to_char(l_num_over_clash));
14394: --
14395: IF l_num_over_clash=1 THEN
14396: pay_action_information_api.create_action_information
14397: (
14398: p_action_information_id => l_action_info_id
14399: , p_action_context_id => p_assactid
14400: , p_action_context_type => 'AAP'

Line 14557: pay_action_information_api.create_action_information (

14553: CLOSE csr_get_cao_code;
14554: --Fnd_file.put_line(FND_FILE.LOG,' Collective Agreement id not null get from collective agreement table. :'||l_cao_code);
14555: END IF;*/
14556:
14557: pay_action_information_api.create_action_information (
14558: p_action_information_id => l_action_info_id
14559: , p_action_context_id => p_assactid
14560: , p_action_context_type => 'AAP'
14561: , p_object_version_number => l_ovn