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 360: fnd_message.set_name('PAY','PAY_34193_UOM_NOT_MONEY');

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;

Line 361: fnd_message.raise_error;

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;

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

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;

Line 370: fnd_message.raise_error;

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

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

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;

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

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;

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

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

Line 504: fnd_message.raise_error;

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

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

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;

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

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;

Line 520: fnd_message.raise_error;

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

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

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;

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

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;

Line 536: fnd_message.raise_error;

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;

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

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;

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

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;

Line 620: fnd_message.raise_error;

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

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

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;

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

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;

Line 670: fnd_message.raise_error;

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

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

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;

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

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;

Line 711: fnd_message.raise_error;

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

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

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;

Line 733: fnd_message.raise_error;

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:

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

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

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

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;

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

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;

Line 867: fnd_message.raise_error;

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:

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

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;

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

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

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

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

Line 926: fnd_message.raise_error;

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