DBA Data[Home] [Help]

APPS.PAY_BLT_BUS dependencies on FND_MESSAGE

Line 63: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

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: );

Line 144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

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: --

Line 145: fnd_message.raise_error;

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

Line 372: fnd_message.set_name('PAY','PAY_34193_UOM_NOT_MONEY');

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

Line 373: fnd_message.raise_error;

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;

Line 382: fnd_message.set_name('PAY','HR_51855_QUA_CCY_INV');

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;

Line 383: fnd_message.raise_error;

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: --

Line 395: fnd_message.set_name('PAY','HR_51855_QUA_CCY_INV');

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;

Line 396: fnd_message.raise_error;

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:

Line 474: -- fnd_message.set_name ('PAY', 'PAY_34172_BAL_DBI_UPD');

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;

Line 477: -- fnd_message.set_name('PAY','PAY_34173_BASE_TBL_UPD');

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;

Line 531: fnd_message.set_name('PAY','PAY_34194_UOM_MUST_BE_MONEY');

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

Line 532: fnd_message.raise_error;

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) <>

Line 546: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');

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;

Line 547: fnd_message.set_token('COLUMN_NAME', 'BALANCE_UOM');

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;

Line 548: fnd_message.raise_error;

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: --

Line 562: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');

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;

Line 563: fnd_message.set_token('COLUMN_NAME', 'BALANCE_UOM');

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;

Line 564: fnd_message.raise_error;

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;

Line 646: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');

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;

Line 647: fnd_message.set_token('COLUMN_NAME', 'BALANCE_CATEGORY_ID');

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;

Line 648: fnd_message.raise_error;

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: --

Line 696: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');

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;

Line 697: fnd_message.set_token('COLUMN_NAME', 'BASE_BALANCE_TYPE_ID'||p_base_balance_type_id||'value unknown');

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;

Line 698: fnd_message.raise_error;

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: --

Line 737: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');

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;

Line 738: fnd_message.set_token('COLUMN_NAME', 'INPUT_VALUE_ID');

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;

Line 739: fnd_message.raise_error;

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: --

Line 760: fnd_message.set_name('PAY','PAY_34195_FEED_OR_CLASS_EXIST');

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;

Line 761: fnd_message.raise_error;

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:

Line 892: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');

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: --

Line 893: fnd_message.set_token('COLUMN','LEGISLATION_CODE');

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;

Line 894: fnd_message.set_token('TABLE','FND_TERRITORIES');

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;

Line 895: fnd_message.raise_error;

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:

Line 951: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

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;

Line 952: fnd_message.set_token('PROCEDURE ', l_proc);

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: --

Line 953: fnd_message.set_token('STEP ', '5');

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);

Line 954: fnd_message.raise_error;

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: --