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
368: Begin
369: hr_utility.set_location('Entering:'||l_proc, 5);
370: --
371: If (p_balance_uom <> 'M' and p_currency_code is not null) then
372: fnd_message.set_name('PAY','PAY_34193_UOM_NOT_MONEY');
373: fnd_message.raise_error;
374: elsIf p_currency_code is not null then
375: --
376: IF hr_startup_data_api_support.g_startup_mode IN ('STARTUP') THEN -- bug 11901831
369: hr_utility.set_location('Entering:'||l_proc, 5);
370: --
371: If (p_balance_uom <> 'M' and p_currency_code is not null) then
372: fnd_message.set_name('PAY','PAY_34193_UOM_NOT_MONEY');
373: fnd_message.raise_error;
374: elsIf p_currency_code is not null then
375: --
376: IF hr_startup_data_api_support.g_startup_mode IN ('STARTUP') THEN -- bug 11901831
377: Open c_chk_currency_1;
378: Fetch c_chk_currency_1 into l_exists;
379: If c_chk_currency_1%notfound Then
380: --
381: Close c_chk_currency_1;
382: fnd_message.set_name('PAY','HR_51855_QUA_CCY_INV');
383: fnd_message.raise_error;
384: End if;
385: --
386: Close c_chk_currency_1;
379: If c_chk_currency_1%notfound Then
380: --
381: Close c_chk_currency_1;
382: fnd_message.set_name('PAY','HR_51855_QUA_CCY_INV');
383: fnd_message.raise_error;
384: End if;
385: --
386: Close c_chk_currency_1;
387: --
391: Fetch c_chk_currency into l_exists;
392: If c_chk_currency%notfound Then
393: --
394: Close c_chk_currency;
395: fnd_message.set_name('PAY','HR_51855_QUA_CCY_INV');
396: fnd_message.raise_error;
397: End if;
398: --
399: Close c_chk_currency;
392: If c_chk_currency%notfound Then
393: --
394: Close c_chk_currency;
395: fnd_message.set_name('PAY','HR_51855_QUA_CCY_INV');
396: fnd_message.raise_error;
397: End if;
398: --
399: Close c_chk_currency;
400:
470: fetch chk_source_lang into l_exists;
471: close chk_source_lang;
472: --
473: if l_exists is null then
474: -- fnd_message.set_name ('PAY', 'PAY_34172_BAL_DBI_UPD');
475: p_balance_name_warning := 2;
476: else
477: -- fnd_message.set_name('PAY','PAY_34173_BASE_TBL_UPD');
478: p_balance_name_warning := 3;
473: if l_exists is null then
474: -- fnd_message.set_name ('PAY', 'PAY_34172_BAL_DBI_UPD');
475: p_balance_name_warning := 2;
476: else
477: -- fnd_message.set_name('PAY','PAY_34173_BASE_TBL_UPD');
478: p_balance_name_warning := 3;
479: end if;
480: --
481: end if;
527: Begin
528: hr_utility.set_location('Entering:'||l_proc, 5);
529: --
530: If (p_assignment_remuneration_flag = 'Y' and p_balance_uom <> 'M') then
531: fnd_message.set_name('PAY','PAY_34194_UOM_MUST_BE_MONEY');
532: fnd_message.raise_error;
533: elsif((pay_blt_shd.api_updating
534: (p_balance_type_id => p_balance_type_id
535: ,p_object_version_number => p_object_version_number)) and
528: hr_utility.set_location('Entering:'||l_proc, 5);
529: --
530: If (p_assignment_remuneration_flag = 'Y' and p_balance_uom <> 'M') then
531: fnd_message.set_name('PAY','PAY_34194_UOM_MUST_BE_MONEY');
532: fnd_message.raise_error;
533: elsif((pay_blt_shd.api_updating
534: (p_balance_type_id => p_balance_type_id
535: ,p_object_version_number => p_object_version_number)) and
536: nvl(p_balance_uom,hr_api.g_varchar2) <>
542: Fetch c_chk_balance_uom_class into l_class_exists;
543: If c_chk_balance_uom_class%notfound Then
544: --
545: Close c_chk_balance_uom_class;
546: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
547: fnd_message.set_token('COLUMN_NAME', 'BALANCE_UOM');
548: fnd_message.raise_error;
549: --
550: End If;
543: If c_chk_balance_uom_class%notfound Then
544: --
545: Close c_chk_balance_uom_class;
546: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
547: fnd_message.set_token('COLUMN_NAME', 'BALANCE_UOM');
548: fnd_message.raise_error;
549: --
550: End If;
551: Close c_chk_balance_uom_class;
544: --
545: Close c_chk_balance_uom_class;
546: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
547: fnd_message.set_token('COLUMN_NAME', 'BALANCE_UOM');
548: fnd_message.raise_error;
549: --
550: End If;
551: Close c_chk_balance_uom_class;
552: --
558: Fetch c_chk_balance_uom into l_exists;
559: If c_chk_balance_uom%notfound Then
560: --
561: Close c_chk_balance_uom;
562: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
563: fnd_message.set_token('COLUMN_NAME', 'BALANCE_UOM');
564: fnd_message.raise_error;
565: --
566: End If;
559: If c_chk_balance_uom%notfound Then
560: --
561: Close c_chk_balance_uom;
562: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
563: fnd_message.set_token('COLUMN_NAME', 'BALANCE_UOM');
564: fnd_message.raise_error;
565: --
566: End If;
567: Close c_chk_balance_uom;
560: --
561: Close c_chk_balance_uom;
562: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
563: fnd_message.set_token('COLUMN_NAME', 'BALANCE_UOM');
564: fnd_message.raise_error;
565: --
566: End If;
567: Close c_chk_balance_uom;
568: End If;
642: Fetch c_chk_balance_category into l_exists;
643: If c_chk_balance_category%notfound Then
644: --
645: Close c_chk_balance_category;
646: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
647: fnd_message.set_token('COLUMN_NAME', 'BALANCE_CATEGORY_ID');
648: fnd_message.raise_error;
649: --
650: End If;
643: If c_chk_balance_category%notfound Then
644: --
645: Close c_chk_balance_category;
646: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
647: fnd_message.set_token('COLUMN_NAME', 'BALANCE_CATEGORY_ID');
648: fnd_message.raise_error;
649: --
650: End If;
651: Close c_chk_balance_category;
644: --
645: Close c_chk_balance_category;
646: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
647: fnd_message.set_token('COLUMN_NAME', 'BALANCE_CATEGORY_ID');
648: fnd_message.raise_error;
649: --
650: End If;
651: Close c_chk_balance_category;
652: --
692: Fetch c_chk_base_balance into l_exists;
693: If c_chk_base_balance%notfound Then
694: --
695: Close c_chk_base_balance;
696: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
697: fnd_message.set_token('COLUMN_NAME', 'BASE_BALANCE_TYPE_ID'||p_base_balance_type_id||'value unknown');
698: fnd_message.raise_error;
699: --
700: End If;
693: If c_chk_base_balance%notfound Then
694: --
695: Close c_chk_base_balance;
696: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
697: fnd_message.set_token('COLUMN_NAME', 'BASE_BALANCE_TYPE_ID'||p_base_balance_type_id||'value unknown');
698: fnd_message.raise_error;
699: --
700: End If;
701: Close c_chk_base_balance;
694: --
695: Close c_chk_base_balance;
696: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
697: fnd_message.set_token('COLUMN_NAME', 'BASE_BALANCE_TYPE_ID'||p_base_balance_type_id||'value unknown');
698: fnd_message.raise_error;
699: --
700: End If;
701: Close c_chk_base_balance;
702: --
733: Fetch c_chk_input_value into l_exists;
734: If c_chk_input_value%notfound Then
735: --
736: Close c_chk_input_value;
737: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
738: fnd_message.set_token('COLUMN_NAME', 'INPUT_VALUE_ID');
739: fnd_message.raise_error;
740: --
741: End If;
734: If c_chk_input_value%notfound Then
735: --
736: Close c_chk_input_value;
737: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
738: fnd_message.set_token('COLUMN_NAME', 'INPUT_VALUE_ID');
739: fnd_message.raise_error;
740: --
741: End If;
742: Close c_chk_input_value;
735: --
736: Close c_chk_input_value;
737: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
738: fnd_message.set_token('COLUMN_NAME', 'INPUT_VALUE_ID');
739: fnd_message.raise_error;
740: --
741: End If;
742: Close c_chk_input_value;
743: --
756:
757: if (hr_balance_feeds.manual_bal_feeds_exist(p_balance_type_id) or
758: hr_balance_feeds.bal_classifications_exist(p_balance_type_id)) then
759: --
760: fnd_message.set_name('PAY','PAY_34195_FEED_OR_CLASS_EXIST');
761: fnd_message.raise_error;
762: end if;
763: --
764: End if;
757: if (hr_balance_feeds.manual_bal_feeds_exist(p_balance_type_id) or
758: hr_balance_feeds.bal_classifications_exist(p_balance_type_id)) then
759: --
760: fnd_message.set_name('PAY','PAY_34195_FEED_OR_CLASS_EXIST');
761: fnd_message.raise_error;
762: end if;
763: --
764: End if;
765:
888: Fetch c_chk_leg_code into l_exists;
889: If c_chk_leg_code%notfound Then
890: --
891: Close c_chk_leg_code;
892: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
893: fnd_message.set_token('COLUMN','LEGISLATION_CODE');
894: fnd_message.set_token('TABLE','FND_TERRITORIES');
895: fnd_message.raise_error;
896: --
889: If c_chk_leg_code%notfound Then
890: --
891: Close c_chk_leg_code;
892: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
893: fnd_message.set_token('COLUMN','LEGISLATION_CODE');
894: fnd_message.set_token('TABLE','FND_TERRITORIES');
895: fnd_message.raise_error;
896: --
897: End If;
890: --
891: Close c_chk_leg_code;
892: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
893: fnd_message.set_token('COLUMN','LEGISLATION_CODE');
894: fnd_message.set_token('TABLE','FND_TERRITORIES');
895: fnd_message.raise_error;
896: --
897: End If;
898: Close c_chk_leg_code;
891: Close c_chk_leg_code;
892: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
893: fnd_message.set_token('COLUMN','LEGISLATION_CODE');
894: fnd_message.set_token('TABLE','FND_TERRITORIES');
895: fnd_message.raise_error;
896: --
897: End If;
898: Close c_chk_leg_code;
899:
947: IF NOT pay_blt_shd.api_updating
948: (p_balance_type_id => p_rec.balance_type_id
949: ,p_object_version_number => p_rec.object_version_number
950: ) THEN
951: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
952: fnd_message.set_token('PROCEDURE ', l_proc);
953: fnd_message.set_token('STEP ', '5');
954: fnd_message.raise_error;
955: END IF;
948: (p_balance_type_id => p_rec.balance_type_id
949: ,p_object_version_number => p_rec.object_version_number
950: ) THEN
951: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
952: fnd_message.set_token('PROCEDURE ', l_proc);
953: fnd_message.set_token('STEP ', '5');
954: fnd_message.raise_error;
955: END IF;
956: --
949: ,p_object_version_number => p_rec.object_version_number
950: ) THEN
951: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
952: fnd_message.set_token('PROCEDURE ', l_proc);
953: fnd_message.set_token('STEP ', '5');
954: fnd_message.raise_error;
955: END IF;
956: --
957: hr_utility.set_location('Entering:'||l_proc, 10);
950: ) THEN
951: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
952: fnd_message.set_token('PROCEDURE ', l_proc);
953: fnd_message.set_token('STEP ', '5');
954: fnd_message.raise_error;
955: END IF;
956: --
957: hr_utility.set_location('Entering:'||l_proc, 10);
958: --