59: close csr_sec_grp;
60: --
61: -- The primary key is invalid therefore we must error
62: --
63: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
64: hr_multi_message.add
65: (p_associated_column1
66: => nvl(p_associated_column1,'BALANCE_TYPE_ID')
67: );
140: --
141: -- The primary key is invalid therefore we must error
142: --
143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
141: -- The primary key is invalid therefore we must error
142: --
143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
149: -- Set the global variables so the values are
356: Begin
357: hr_utility.set_location('Entering:'||l_proc, 5);
358: --
359: If (p_balance_uom <> 'M' and p_currency_code is not null) then
360: fnd_message.set_name('PAY','PAY_34193_UOM_NOT_MONEY');
361: fnd_message.raise_error;
362: elsIf p_currency_code is not null then
363: --
364: Open c_chk_currency;
357: hr_utility.set_location('Entering:'||l_proc, 5);
358: --
359: If (p_balance_uom <> 'M' and p_currency_code is not null) then
360: fnd_message.set_name('PAY','PAY_34193_UOM_NOT_MONEY');
361: fnd_message.raise_error;
362: elsIf p_currency_code is not null then
363: --
364: Open c_chk_currency;
365: Fetch c_chk_currency into l_exists;
365: Fetch c_chk_currency into l_exists;
366: If c_chk_currency%notfound Then
367: --
368: Close c_chk_currency;
369: fnd_message.set_name('PAY','HR_51855_QUA_CCY_INV');
370: fnd_message.raise_error;
371: End if;
372: --
373: Close c_chk_currency;
366: If c_chk_currency%notfound Then
367: --
368: Close c_chk_currency;
369: fnd_message.set_name('PAY','HR_51855_QUA_CCY_INV');
370: fnd_message.raise_error;
371: End if;
372: --
373: Close c_chk_currency;
374: --
442: fetch chk_source_lang into l_exists;
443: close chk_source_lang;
444: --
445: if l_exists is null then
446: -- fnd_message.set_name ('PAY', 'PAY_34172_BAL_DBI_UPD');
447: p_balance_name_warning := 2;
448: else
449: -- fnd_message.set_name('PAY','PAY_34173_BASE_TBL_UPD');
450: p_balance_name_warning := 3;
445: if l_exists is null then
446: -- fnd_message.set_name ('PAY', 'PAY_34172_BAL_DBI_UPD');
447: p_balance_name_warning := 2;
448: else
449: -- fnd_message.set_name('PAY','PAY_34173_BASE_TBL_UPD');
450: p_balance_name_warning := 3;
451: end if;
452: --
453: end if;
499: Begin
500: hr_utility.set_location('Entering:'||l_proc, 5);
501: --
502: If (p_assignment_remuneration_flag = 'Y' and p_balance_uom <> 'M') then
503: fnd_message.set_name('PAY','PAY_34194_UOM_MUST_BE_MONEY');
504: fnd_message.raise_error;
505: elsif((pay_blt_shd.api_updating
506: (p_balance_type_id => p_balance_type_id
507: ,p_object_version_number => p_object_version_number)) and
500: hr_utility.set_location('Entering:'||l_proc, 5);
501: --
502: If (p_assignment_remuneration_flag = 'Y' and p_balance_uom <> 'M') then
503: fnd_message.set_name('PAY','PAY_34194_UOM_MUST_BE_MONEY');
504: fnd_message.raise_error;
505: elsif((pay_blt_shd.api_updating
506: (p_balance_type_id => p_balance_type_id
507: ,p_object_version_number => p_object_version_number)) and
508: nvl(p_balance_uom,hr_api.g_varchar2) <>
514: Fetch c_chk_balance_uom_class into l_class_exists;
515: If c_chk_balance_uom_class%notfound Then
516: --
517: Close c_chk_balance_uom_class;
518: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
519: fnd_message.set_token('COLUMN_NAME', 'BALANCE_UOM');
520: fnd_message.raise_error;
521: --
522: End If;
515: If c_chk_balance_uom_class%notfound Then
516: --
517: Close c_chk_balance_uom_class;
518: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
519: fnd_message.set_token('COLUMN_NAME', 'BALANCE_UOM');
520: fnd_message.raise_error;
521: --
522: End If;
523: Close c_chk_balance_uom_class;
516: --
517: Close c_chk_balance_uom_class;
518: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
519: fnd_message.set_token('COLUMN_NAME', 'BALANCE_UOM');
520: fnd_message.raise_error;
521: --
522: End If;
523: Close c_chk_balance_uom_class;
524: --
530: Fetch c_chk_balance_uom into l_exists;
531: If c_chk_balance_uom%notfound Then
532: --
533: Close c_chk_balance_uom;
534: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
535: fnd_message.set_token('COLUMN_NAME', 'BALANCE_UOM');
536: fnd_message.raise_error;
537: --
538: End If;
531: If c_chk_balance_uom%notfound Then
532: --
533: Close c_chk_balance_uom;
534: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
535: fnd_message.set_token('COLUMN_NAME', 'BALANCE_UOM');
536: fnd_message.raise_error;
537: --
538: End If;
539: Close c_chk_balance_uom;
532: --
533: Close c_chk_balance_uom;
534: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
535: fnd_message.set_token('COLUMN_NAME', 'BALANCE_UOM');
536: fnd_message.raise_error;
537: --
538: End If;
539: Close c_chk_balance_uom;
540: End If;
614: Fetch c_chk_balance_category into l_exists;
615: If c_chk_balance_category%notfound Then
616: --
617: Close c_chk_balance_category;
618: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
619: fnd_message.set_token('COLUMN_NAME', 'BALANCE_CATEGORY_ID');
620: fnd_message.raise_error;
621: --
622: End If;
615: If c_chk_balance_category%notfound Then
616: --
617: Close c_chk_balance_category;
618: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
619: fnd_message.set_token('COLUMN_NAME', 'BALANCE_CATEGORY_ID');
620: fnd_message.raise_error;
621: --
622: End If;
623: Close c_chk_balance_category;
616: --
617: Close c_chk_balance_category;
618: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
619: fnd_message.set_token('COLUMN_NAME', 'BALANCE_CATEGORY_ID');
620: fnd_message.raise_error;
621: --
622: End If;
623: Close c_chk_balance_category;
624: --
664: Fetch c_chk_base_balance into l_exists;
665: If c_chk_base_balance%notfound Then
666: --
667: Close c_chk_base_balance;
668: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
669: fnd_message.set_token('COLUMN_NAME', 'BASE_BALANCE_TYPE_ID'||p_base_balance_type_id||'value unknown');
670: fnd_message.raise_error;
671: --
672: End If;
665: If c_chk_base_balance%notfound Then
666: --
667: Close c_chk_base_balance;
668: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
669: fnd_message.set_token('COLUMN_NAME', 'BASE_BALANCE_TYPE_ID'||p_base_balance_type_id||'value unknown');
670: fnd_message.raise_error;
671: --
672: End If;
673: Close c_chk_base_balance;
666: --
667: Close c_chk_base_balance;
668: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
669: fnd_message.set_token('COLUMN_NAME', 'BASE_BALANCE_TYPE_ID'||p_base_balance_type_id||'value unknown');
670: fnd_message.raise_error;
671: --
672: End If;
673: Close c_chk_base_balance;
674: --
705: Fetch c_chk_input_value into l_exists;
706: If c_chk_input_value%notfound Then
707: --
708: Close c_chk_input_value;
709: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
710: fnd_message.set_token('COLUMN_NAME', 'INPUT_VALUE_ID');
711: fnd_message.raise_error;
712: --
713: End If;
706: If c_chk_input_value%notfound Then
707: --
708: Close c_chk_input_value;
709: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
710: fnd_message.set_token('COLUMN_NAME', 'INPUT_VALUE_ID');
711: fnd_message.raise_error;
712: --
713: End If;
714: Close c_chk_input_value;
707: --
708: Close c_chk_input_value;
709: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
710: fnd_message.set_token('COLUMN_NAME', 'INPUT_VALUE_ID');
711: fnd_message.raise_error;
712: --
713: End If;
714: Close c_chk_input_value;
715: --
728:
729: if (hr_balance_feeds.manual_bal_feeds_exist(p_balance_type_id) or
730: hr_balance_feeds.bal_classifications_exist(p_balance_type_id)) then
731: --
732: fnd_message.set_name('PAY','PAY_34195_FEED_OR_CLASS_EXIST');
733: fnd_message.raise_error;
734: end if;
735: --
736: End if;
729: if (hr_balance_feeds.manual_bal_feeds_exist(p_balance_type_id) or
730: hr_balance_feeds.bal_classifications_exist(p_balance_type_id)) then
731: --
732: fnd_message.set_name('PAY','PAY_34195_FEED_OR_CLASS_EXIST');
733: fnd_message.raise_error;
734: end if;
735: --
736: End if;
737:
860: Fetch c_chk_leg_code into l_exists;
861: If c_chk_leg_code%notfound Then
862: --
863: Close c_chk_leg_code;
864: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
865: fnd_message.set_token('COLUMN','LEGISLATION_CODE');
866: fnd_message.set_token('TABLE','FND_TERRITORIES');
867: fnd_message.raise_error;
868: --
861: If c_chk_leg_code%notfound Then
862: --
863: Close c_chk_leg_code;
864: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
865: fnd_message.set_token('COLUMN','LEGISLATION_CODE');
866: fnd_message.set_token('TABLE','FND_TERRITORIES');
867: fnd_message.raise_error;
868: --
869: End If;
862: --
863: Close c_chk_leg_code;
864: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
865: fnd_message.set_token('COLUMN','LEGISLATION_CODE');
866: fnd_message.set_token('TABLE','FND_TERRITORIES');
867: fnd_message.raise_error;
868: --
869: End If;
870: Close c_chk_leg_code;
863: Close c_chk_leg_code;
864: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
865: fnd_message.set_token('COLUMN','LEGISLATION_CODE');
866: fnd_message.set_token('TABLE','FND_TERRITORIES');
867: fnd_message.raise_error;
868: --
869: End If;
870: Close c_chk_leg_code;
871:
919: IF NOT pay_blt_shd.api_updating
920: (p_balance_type_id => p_rec.balance_type_id
921: ,p_object_version_number => p_rec.object_version_number
922: ) THEN
923: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
924: fnd_message.set_token('PROCEDURE ', l_proc);
925: fnd_message.set_token('STEP ', '5');
926: fnd_message.raise_error;
927: END IF;
920: (p_balance_type_id => p_rec.balance_type_id
921: ,p_object_version_number => p_rec.object_version_number
922: ) THEN
923: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
924: fnd_message.set_token('PROCEDURE ', l_proc);
925: fnd_message.set_token('STEP ', '5');
926: fnd_message.raise_error;
927: END IF;
928: --
921: ,p_object_version_number => p_rec.object_version_number
922: ) THEN
923: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
924: fnd_message.set_token('PROCEDURE ', l_proc);
925: fnd_message.set_token('STEP ', '5');
926: fnd_message.raise_error;
927: END IF;
928: --
929: hr_utility.set_location('Entering:'||l_proc, 10);
922: ) THEN
923: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
924: fnd_message.set_token('PROCEDURE ', l_proc);
925: fnd_message.set_token('STEP ', '5');
926: fnd_message.raise_error;
927: END IF;
928: --
929: hr_utility.set_location('Entering:'||l_proc, 10);
930: --