327: --
328: -- Check for mandatoy segment
329: --
330: If (l_required_flag(i) = 'Y' and p_segment(l_segment_no(i)) is null) then
331: fnd_message.set_name('PER','PAY_33284_FLEX_VALUE_MISSING');
332: fnd_message.set_token('COLUMN',l_application_column(i));
333: fnd_message.set_token('PROMPT',l_application_segment(i));
334: hr_utility.raise_error;
335: end if;
328: -- Check for mandatoy segment
329: --
330: If (l_required_flag(i) = 'Y' and p_segment(l_segment_no(i)) is null) then
331: fnd_message.set_name('PER','PAY_33284_FLEX_VALUE_MISSING');
332: fnd_message.set_token('COLUMN',l_application_column(i));
333: fnd_message.set_token('PROMPT',l_application_segment(i));
334: hr_utility.raise_error;
335: end if;
336: END LOOP;
329: --
330: If (l_required_flag(i) = 'Y' and p_segment(l_segment_no(i)) is null) then
331: fnd_message.set_name('PER','PAY_33284_FLEX_VALUE_MISSING');
332: fnd_message.set_token('COLUMN',l_application_column(i));
333: fnd_message.set_token('PROMPT',l_application_segment(i));
334: hr_utility.raise_error;
335: end if;
336: END LOOP;
337: end if;
401: close csr_sec_grp;
402: --
403: -- The primary key is invalid therefore we must error
404: --
405: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
406: fnd_message.raise_error;
407: --
408: end if;
409: close csr_sec_grp;
402: --
403: -- The primary key is invalid therefore we must error
404: --
405: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
406: fnd_message.raise_error;
407: --
408: end if;
409: close csr_sec_grp;
410: --
481: --
482: -- The primary key is invalid therefore we must error
483: --
484: close csr_leg_code;
485: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
486: fnd_message.raise_error;
487: end if;
488: hr_utility.set_location(l_proc,30);
489: --
482: -- The primary key is invalid therefore we must error
483: --
484: close csr_leg_code;
485: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
486: fnd_message.raise_error;
487: end if;
488: hr_utility.set_location(l_proc,30);
489: --
490: -- Set the global variables so the values are
541: IF NOT pay_btl_shd.api_updating
542: (p_batch_line_id => p_rec.batch_line_id
543: ,p_object_version_number => p_rec.object_version_number
544: ) THEN
545: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
546: fnd_message.set_token('PROCEDURE ', l_proc);
547: fnd_message.set_token('STEP ', '5');
548: fnd_message.raise_error;
549: END IF;
542: (p_batch_line_id => p_rec.batch_line_id
543: ,p_object_version_number => p_rec.object_version_number
544: ) THEN
545: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
546: fnd_message.set_token('PROCEDURE ', l_proc);
547: fnd_message.set_token('STEP ', '5');
548: fnd_message.raise_error;
549: END IF;
550: --
543: ,p_object_version_number => p_rec.object_version_number
544: ) THEN
545: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
546: fnd_message.set_token('PROCEDURE ', l_proc);
547: fnd_message.set_token('STEP ', '5');
548: fnd_message.raise_error;
549: END IF;
550: --
551: hr_utility.set_location(l_proc, 10);
544: ) THEN
545: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
546: fnd_message.set_token('PROCEDURE ', l_proc);
547: fnd_message.set_token('STEP ', '5');
548: fnd_message.raise_error;
549: END IF;
550: --
551: hr_utility.set_location(l_proc, 10);
552: --
611: open csr_status;
612: fetch csr_status into l_transferred;
613: if csr_status%found then
614: close csr_status;
615: Fnd_Message.Set_Name('PER', 'HR_289754_BEE_REC_TRANSFERRED');
616: fnd_message.raise_error;
617: end if;
618: --
619: close csr_status;
612: fetch csr_status into l_transferred;
613: if csr_status%found then
614: close csr_status;
615: Fnd_Message.Set_Name('PER', 'HR_289754_BEE_REC_TRANSFERRED');
616: fnd_message.raise_error;
617: end if;
618: --
619: close csr_status;
620: --
813: nvl(p_batch_line_status,hr_api.g_varchar2)) then
814: --
815: IF pay_btl_shd.g_old_rec.batch_line_status in ('U') then
816: if p_batch_line_status not in ('U') then
817: Fnd_Message.Set_Name('PER', 'HR_289267_STATUS_INVALID');
818: fnd_message.raise_error;
819: end if;
820: ELSIF pay_btl_shd.g_old_rec.batch_line_status in ('V') then
821: if p_batch_line_status not in ('V','U') then
814: --
815: IF pay_btl_shd.g_old_rec.batch_line_status in ('U') then
816: if p_batch_line_status not in ('U') then
817: Fnd_Message.Set_Name('PER', 'HR_289267_STATUS_INVALID');
818: fnd_message.raise_error;
819: end if;
820: ELSIF pay_btl_shd.g_old_rec.batch_line_status in ('V') then
821: if p_batch_line_status not in ('V','U') then
822: Fnd_Message.Set_Name('PER', 'HR_289267_STATUS_INVALID');
818: fnd_message.raise_error;
819: end if;
820: ELSIF pay_btl_shd.g_old_rec.batch_line_status in ('V') then
821: if p_batch_line_status not in ('V','U') then
822: Fnd_Message.Set_Name('PER', 'HR_289267_STATUS_INVALID');
823: fnd_message.raise_error;
824: end if;
825: ELSIF pay_btl_shd.g_old_rec.batch_line_status in ('T') then
826: if p_batch_line_status not in ('T') then
819: end if;
820: ELSIF pay_btl_shd.g_old_rec.batch_line_status in ('V') then
821: if p_batch_line_status not in ('V','U') then
822: Fnd_Message.Set_Name('PER', 'HR_289267_STATUS_INVALID');
823: fnd_message.raise_error;
824: end if;
825: ELSIF pay_btl_shd.g_old_rec.batch_line_status in ('T') then
826: if p_batch_line_status not in ('T') then
827: Fnd_Message.Set_Name('PER', 'HR_289267_STATUS_INVALID');
823: fnd_message.raise_error;
824: end if;
825: ELSIF pay_btl_shd.g_old_rec.batch_line_status in ('T') then
826: if p_batch_line_status not in ('T') then
827: Fnd_Message.Set_Name('PER', 'HR_289267_STATUS_INVALID');
828: fnd_message.raise_error;
829: end if;
830: ELSIF pay_btl_shd.g_old_rec.batch_line_status in ('E') then
831: if p_batch_line_status not in ('E','U') then
824: end if;
825: ELSIF pay_btl_shd.g_old_rec.batch_line_status in ('T') then
826: if p_batch_line_status not in ('T') then
827: Fnd_Message.Set_Name('PER', 'HR_289267_STATUS_INVALID');
828: fnd_message.raise_error;
829: end if;
830: ELSIF pay_btl_shd.g_old_rec.batch_line_status in ('E') then
831: if p_batch_line_status not in ('E','U') then
832: Fnd_Message.Set_Name('PER', 'HR_289267_STATUS_INVALID');
828: fnd_message.raise_error;
829: end if;
830: ELSIF pay_btl_shd.g_old_rec.batch_line_status in ('E') then
831: if p_batch_line_status not in ('E','U') then
832: Fnd_Message.Set_Name('PER', 'HR_289267_STATUS_INVALID');
833: fnd_message.raise_error;
834: end if;
835: END IF;
836: --
829: end if;
830: ELSIF pay_btl_shd.g_old_rec.batch_line_status in ('E') then
831: if p_batch_line_status not in ('E','U') then
832: Fnd_Message.Set_Name('PER', 'HR_289267_STATUS_INVALID');
833: fnd_message.raise_error;
834: end if;
835: END IF;
836: --
837: end if;
843: fetch csr_batch_header_status into l_batch_header_status;
844: close csr_batch_header_status;
845: --
846: if l_batch_header_status = 'P' then
847: fnd_message.set_name('PAY', 'PAY_33240_BTH_STATUS_CHANGED');
848: fnd_message.raise_error;
849: end if;
850: --
851: if l_batch_header_status = 'T' then
844: close csr_batch_header_status;
845: --
846: if l_batch_header_status = 'P' then
847: fnd_message.set_name('PAY', 'PAY_33240_BTH_STATUS_CHANGED');
848: fnd_message.raise_error;
849: end if;
850: --
851: if l_batch_header_status = 'T' then
852: if l_api_updating then
854: fetch csr_batch_line_asg into l_dummy;
855: --
856: if (csr_batch_line_asg%notfound) then
857: close csr_batch_line_asg;
858: fnd_message.set_name('PER', 'HR_289304_BEE_ASG_UPD_RESTRICT');
859: fnd_message.raise_error;
860: end if;
861: --
862: close csr_batch_line_asg;
855: --
856: if (csr_batch_line_asg%notfound) then
857: close csr_batch_line_asg;
858: fnd_message.set_name('PER', 'HR_289304_BEE_ASG_UPD_RESTRICT');
859: fnd_message.raise_error;
860: end if;
861: --
862: close csr_batch_line_asg;
863: else
860: end if;
861: --
862: close csr_batch_line_asg;
863: else
864: fnd_message.set_name('PAY', 'PAY_33240_BTH_STATUS_CHANGED');
865: fnd_message.raise_error;
866: end if;
867: end if;
868: --
861: --
862: close csr_batch_line_asg;
863: else
864: fnd_message.set_name('PAY', 'PAY_33240_BTH_STATUS_CHANGED');
865: fnd_message.raise_error;
866: end if;
867: end if;
868: --
869: --
1026: If csr_message_lines%found Then
1027: --
1028: close csr_message_lines;
1029: --
1030: fnd_message.set_name('PAY','PAY_52681_BHT_CHILD_EXISTS');
1031: fnd_message.raise_error;
1032: --
1033: End If;
1034: --
1027: --
1028: close csr_message_lines;
1029: --
1030: fnd_message.set_name('PAY','PAY_52681_BHT_CHILD_EXISTS');
1031: fnd_message.raise_error;
1032: --
1033: End If;
1034: --
1035: close csr_message_lines;