DBA Data[Home] [Help]

APPS.PAY_OPM_BUS dependencies on FND_MESSAGE

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

55: close csr_sec_grp;
56: --
57: -- The primary key is invalid therefore we must error
58: --
59: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
60: fnd_message.raise_error;
61: --
62: end if;
63: close csr_sec_grp;

Line 60: fnd_message.raise_error;

56: --
57: -- The primary key is invalid therefore we must error
58: --
59: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
60: fnd_message.raise_error;
61: --
62: end if;
63: close csr_sec_grp;
64: --

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

128: --
129: -- The primary key is invalid therefore we must error
130: --
131: close csr_leg_code;
132: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --

Line 133: fnd_message.raise_error;

129: -- The primary key is invalid therefore we must error
130: --
131: close csr_leg_code;
132: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --
137: -- Set the global variables so the values are

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

466: (p_org_payment_method_id => p_rec.org_payment_method_id
467: ,p_effective_date => p_effective_date
468: ,p_object_version_number => p_rec.object_version_number
469: ) THEN
470: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
471: fnd_message.set_token('PROCEDURE ', l_proc);
472: fnd_message.set_token('STEP ', '5');
473: fnd_message.raise_error;
474: END IF;

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

467: ,p_effective_date => p_effective_date
468: ,p_object_version_number => p_rec.object_version_number
469: ) THEN
470: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
471: fnd_message.set_token('PROCEDURE ', l_proc);
472: fnd_message.set_token('STEP ', '5');
473: fnd_message.raise_error;
474: END IF;
475: --

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

468: ,p_object_version_number => p_rec.object_version_number
469: ) THEN
470: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
471: fnd_message.set_token('PROCEDURE ', l_proc);
472: fnd_message.set_token('STEP ', '5');
473: fnd_message.raise_error;
474: END IF;
475: --
476: hr_utility.set_location(l_proc, 10);

Line 473: fnd_message.raise_error;

469: ) THEN
470: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
471: fnd_message.set_token('PROCEDURE ', l_proc);
472: fnd_message.set_token('STEP ', '5');
473: fnd_message.raise_error;
474: END IF;
475: --
476: hr_utility.set_location(l_proc, 10);
477: --

Line 592: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');

588: --
589: -- A referential integrity check was violated therefore
590: -- we must error
591: --
592: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
593: fnd_message.set_token('TABLE_NAME', l_table_name);
594: fnd_message.raise_error;
595: When Others Then
596: --

Line 593: fnd_message.set_token('TABLE_NAME', l_table_name);

589: -- A referential integrity check was violated therefore
590: -- we must error
591: --
592: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
593: fnd_message.set_token('TABLE_NAME', l_table_name);
594: fnd_message.raise_error;
595: When Others Then
596: --
597: -- An unhandled or unexpected error has occurred which

Line 594: fnd_message.raise_error;

590: -- we must error
591: --
592: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
593: fnd_message.set_token('TABLE_NAME', l_table_name);
594: fnd_message.raise_error;
595: When Others Then
596: --
597: -- An unhandled or unexpected error has occurred which
598: -- we must report

Line 600: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

596: --
597: -- An unhandled or unexpected error has occurred which
598: -- we must report
599: --
600: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
601: fnd_message.set_token('PROCEDURE', l_proc);
602: fnd_message.set_token('STEP','15');
603: fnd_message.raise_error;
604: End dt_update_validate;

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

597: -- An unhandled or unexpected error has occurred which
598: -- we must report
599: --
600: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
601: fnd_message.set_token('PROCEDURE', l_proc);
602: fnd_message.set_token('STEP','15');
603: fnd_message.raise_error;
604: End dt_update_validate;
605: --

Line 602: fnd_message.set_token('STEP','15');

598: -- we must report
599: --
600: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
601: fnd_message.set_token('PROCEDURE', l_proc);
602: fnd_message.set_token('STEP','15');
603: fnd_message.raise_error;
604: End dt_update_validate;
605: --
606: -- ----------------------------------------------------------------------------

Line 603: fnd_message.raise_error;

599: --
600: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
601: fnd_message.set_token('PROCEDURE', l_proc);
602: fnd_message.set_token('STEP','15');
603: fnd_message.raise_error;
604: End dt_update_validate;
605: --
606: -- ----------------------------------------------------------------------------
607: -- |--------------------------< dt_delete_validate >--------------------------|

Line 738: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');

734: --
735: -- A referential integrity check was violated therefore
736: -- we must error
737: --
738: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
739: fnd_message.set_token('TABLE_NAME', l_table_name);
740: fnd_message.raise_error;
741: When Others Then
742: --

Line 739: fnd_message.set_token('TABLE_NAME', l_table_name);

735: -- A referential integrity check was violated therefore
736: -- we must error
737: --
738: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
739: fnd_message.set_token('TABLE_NAME', l_table_name);
740: fnd_message.raise_error;
741: When Others Then
742: --
743: -- An unhandled or unexpected error has occurred which

Line 740: fnd_message.raise_error;

736: -- we must error
737: --
738: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
739: fnd_message.set_token('TABLE_NAME', l_table_name);
740: fnd_message.raise_error;
741: When Others Then
742: --
743: -- An unhandled or unexpected error has occurred which
744: -- we must report

Line 746: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

742: --
743: -- An unhandled or unexpected error has occurred which
744: -- we must report
745: --
746: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
747: fnd_message.set_token('PROCEDURE', l_proc);
748: fnd_message.set_token('STEP','15');
749: fnd_message.raise_error;
750: --

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

743: -- An unhandled or unexpected error has occurred which
744: -- we must report
745: --
746: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
747: fnd_message.set_token('PROCEDURE', l_proc);
748: fnd_message.set_token('STEP','15');
749: fnd_message.raise_error;
750: --
751: End dt_delete_validate;

Line 748: fnd_message.set_token('STEP','15');

744: -- we must report
745: --
746: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
747: fnd_message.set_token('PROCEDURE', l_proc);
748: fnd_message.set_token('STEP','15');
749: fnd_message.raise_error;
750: --
751: End dt_delete_validate;
752: --

Line 749: fnd_message.raise_error;

745: --
746: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
747: fnd_message.set_token('PROCEDURE', l_proc);
748: fnd_message.set_token('STEP','15');
749: fnd_message.raise_error;
750: --
751: End dt_delete_validate;
752: --
753: -- ----------------------------------------------------------------------------

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

1006: fetch csr_currency_code_exists into l_dummy;
1007: if csr_currency_code_exists%notfound then
1008: close csr_currency_code_exists;
1009: -- RAISE ERROR MESSAGE
1010: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
1011: fnd_message.set_token('COLUMN_NAME', 'CURRENCY_CODE');
1012: fnd_message.raise_error;
1013: end if;
1014: close csr_currency_code_exists;

Line 1011: fnd_message.set_token('COLUMN_NAME', 'CURRENCY_CODE');

1007: if csr_currency_code_exists%notfound then
1008: close csr_currency_code_exists;
1009: -- RAISE ERROR MESSAGE
1010: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
1011: fnd_message.set_token('COLUMN_NAME', 'CURRENCY_CODE');
1012: fnd_message.raise_error;
1013: end if;
1014: close csr_currency_code_exists;
1015: --

Line 1012: fnd_message.raise_error;

1008: close csr_currency_code_exists;
1009: -- RAISE ERROR MESSAGE
1010: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
1011: fnd_message.set_token('COLUMN_NAME', 'CURRENCY_CODE');
1012: fnd_message.raise_error;
1013: end if;
1014: close csr_currency_code_exists;
1015: --
1016: hr_utility.set_location(l_proc,30);

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

1111: fetch csr_pay_type_id_exists into l_dummy;
1112: if csr_pay_type_id_exists%notfound then
1113: close csr_pay_type_id_exists;
1114: -- RAISE ERROR MESSAGE
1115: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
1116: fnd_message.set_token('COLUMN_NAME', 'PAYMENT_TYPE_ID');
1117: fnd_message.raise_error;
1118: end if;
1119: close csr_pay_type_id_exists;

Line 1116: fnd_message.set_token('COLUMN_NAME', 'PAYMENT_TYPE_ID');

1112: if csr_pay_type_id_exists%notfound then
1113: close csr_pay_type_id_exists;
1114: -- RAISE ERROR MESSAGE
1115: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
1116: fnd_message.set_token('COLUMN_NAME', 'PAYMENT_TYPE_ID');
1117: fnd_message.raise_error;
1118: end if;
1119: close csr_pay_type_id_exists;
1120: --

Line 1117: fnd_message.raise_error;

1113: close csr_pay_type_id_exists;
1114: -- RAISE ERROR MESSAGE
1115: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
1116: fnd_message.set_token('COLUMN_NAME', 'PAYMENT_TYPE_ID');
1117: fnd_message.raise_error;
1118: end if;
1119: close csr_pay_type_id_exists;
1120: --
1121: hr_utility.set_location(l_proc,30);

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

1212: fetch csr_def_bal_id_exists into l_dummy;
1213: if ((csr_def_bal_id_exists%notfound) or (l_dummy<>p_defined_balance_id)) then
1214: close csr_def_bal_id_exists;
1215: -- RAISE ERROR MESSAGE
1216: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
1217: fnd_message.set_token('COLUMN_NAME', 'DEFINED_BALANCE_ID');
1218: fnd_message.raise_error;
1219: end if;
1220: close csr_def_bal_id_exists;

Line 1217: fnd_message.set_token('COLUMN_NAME', 'DEFINED_BALANCE_ID');

1213: if ((csr_def_bal_id_exists%notfound) or (l_dummy<>p_defined_balance_id)) then
1214: close csr_def_bal_id_exists;
1215: -- RAISE ERROR MESSAGE
1216: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
1217: fnd_message.set_token('COLUMN_NAME', 'DEFINED_BALANCE_ID');
1218: fnd_message.raise_error;
1219: end if;
1220: close csr_def_bal_id_exists;
1221: --

Line 1218: fnd_message.raise_error;

1214: close csr_def_bal_id_exists;
1215: -- RAISE ERROR MESSAGE
1216: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
1217: fnd_message.set_token('COLUMN_NAME', 'DEFINED_BALANCE_ID');
1218: fnd_message.raise_error;
1219: end if;
1220: close csr_def_bal_id_exists;
1221: --
1222: hr_utility.set_location(l_proc,30);

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

1301: fetch csr_org_pay_meth_name_exists into l_dummy;
1302: if csr_org_pay_meth_name_exists%found then
1303: close csr_org_pay_meth_name_exists;
1304: -- RAISE ERROR MESSAGE
1305: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
1306: fnd_message.set_token('COLUMN_NAME', 'ORG_PAYMENT_METHOD_NAME');
1307: fnd_message.raise_error;
1308: end if;
1309: close csr_org_pay_meth_name_exists;

Line 1306: fnd_message.set_token('COLUMN_NAME', 'ORG_PAYMENT_METHOD_NAME');

1302: if csr_org_pay_meth_name_exists%found then
1303: close csr_org_pay_meth_name_exists;
1304: -- RAISE ERROR MESSAGE
1305: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
1306: fnd_message.set_token('COLUMN_NAME', 'ORG_PAYMENT_METHOD_NAME');
1307: fnd_message.raise_error;
1308: end if;
1309: close csr_org_pay_meth_name_exists;
1310: --

Line 1307: fnd_message.raise_error;

1303: close csr_org_pay_meth_name_exists;
1304: -- RAISE ERROR MESSAGE
1305: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
1306: fnd_message.set_token('COLUMN_NAME', 'ORG_PAYMENT_METHOD_NAME');
1307: fnd_message.raise_error;
1308: end if;
1309: close csr_org_pay_meth_name_exists;
1310: --
1311: hr_utility.set_location(l_proc,30);

Line 1385: fnd_message.set_name('PAY', 'HR_6226_PAYM_PPS_EXIST');

1381: fetch csr_pre_payment_exists into l_dummy;
1382: if csr_pre_payment_exists%found then
1383: close csr_pre_payment_exists;
1384: -- RAISE ERROR MESSAGE
1385: fnd_message.set_name('PAY', 'HR_6226_PAYM_PPS_EXIST');
1386: fnd_message.raise_error;
1387: end if;
1388: close csr_pre_payment_exists;
1389: --

Line 1386: fnd_message.raise_error;

1382: if csr_pre_payment_exists%found then
1383: close csr_pre_payment_exists;
1384: -- RAISE ERROR MESSAGE
1385: fnd_message.set_name('PAY', 'HR_6226_PAYM_PPS_EXIST');
1386: fnd_message.raise_error;
1387: end if;
1388: close csr_pre_payment_exists;
1389: --
1390: --

Line 1455: fnd_message.set_name('PAY', 'PAY_34525_CST_FLAG_NT_ALLWD');

1451: elsif NVL(p_exclude_manual_payment, 'N') = 'Y' then
1452: l_flag_name := 'P_EXCLUDE_MANUAL_PAYMENT';
1453: end if;
1454:
1455: fnd_message.set_name('PAY', 'PAY_34525_CST_FLAG_NT_ALLWD');
1456: fnd_message.set_token('CST_FLAG',l_flag_name);
1457: fnd_message.raise_error;
1458: --
1459: end if;

Line 1456: fnd_message.set_token('CST_FLAG',l_flag_name);

1452: l_flag_name := 'P_EXCLUDE_MANUAL_PAYMENT';
1453: end if;
1454:
1455: fnd_message.set_name('PAY', 'PAY_34525_CST_FLAG_NT_ALLWD');
1456: fnd_message.set_token('CST_FLAG',l_flag_name);
1457: fnd_message.raise_error;
1458: --
1459: end if;
1460: --

Line 1457: fnd_message.raise_error;

1453: end if;
1454:
1455: fnd_message.set_name('PAY', 'PAY_34525_CST_FLAG_NT_ALLWD');
1456: fnd_message.set_token('CST_FLAG',l_flag_name);
1457: fnd_message.raise_error;
1458: --
1459: end if;
1460: --
1461: end if;

Line 1483: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');

1479: (p_effective_date
1480: ,'YES_NO'
1481: ,p_cost_payment) then
1482: --
1483: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1484: fnd_message.set_token('COLUMN','COST_PAYMENT');
1485: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1486: fnd_message.raise_error;
1487: --

Line 1484: fnd_message.set_token('COLUMN','COST_PAYMENT');

1480: ,'YES_NO'
1481: ,p_cost_payment) then
1482: --
1483: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1484: fnd_message.set_token('COLUMN','COST_PAYMENT');
1485: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1486: fnd_message.raise_error;
1487: --
1488: end If;

Line 1485: fnd_message.set_token('LOOKUP_TYPE','YES_NO');

1481: ,p_cost_payment) then
1482: --
1483: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1484: fnd_message.set_token('COLUMN','COST_PAYMENT');
1485: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1486: fnd_message.raise_error;
1487: --
1488: end If;
1489: --

Line 1486: fnd_message.raise_error;

1482: --
1483: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1484: fnd_message.set_token('COLUMN','COST_PAYMENT');
1485: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1486: fnd_message.raise_error;
1487: --
1488: end If;
1489: --
1490: --

Line 1518: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');

1514: (p_effective_date
1515: ,'YES_NO'
1516: ,p_cost_cleared_payment) then
1517: --
1518: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1519: fnd_message.set_token('COLUMN','COST_CLEARED_PAYMENT');
1520: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1521: fnd_message.raise_error;
1522: --

Line 1519: fnd_message.set_token('COLUMN','COST_CLEARED_PAYMENT');

1515: ,'YES_NO'
1516: ,p_cost_cleared_payment) then
1517: --
1518: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1519: fnd_message.set_token('COLUMN','COST_CLEARED_PAYMENT');
1520: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1521: fnd_message.raise_error;
1522: --
1523: end If;

Line 1520: fnd_message.set_token('LOOKUP_TYPE','YES_NO');

1516: ,p_cost_cleared_payment) then
1517: --
1518: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1519: fnd_message.set_token('COLUMN','COST_CLEARED_PAYMENT');
1520: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1521: fnd_message.raise_error;
1522: --
1523: end If;
1524: --

Line 1521: fnd_message.raise_error;

1517: --
1518: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1519: fnd_message.set_token('COLUMN','COST_CLEARED_PAYMENT');
1520: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1521: fnd_message.raise_error;
1522: --
1523: end If;
1524: --
1525: if (p_cost_cleared_payment = 'Y') and (p_cost_payment <> 'Y') then

Line 1527: fnd_message.set_name('PAY', 'PAY_33415_CST_CLRCST_SYNC');

1523: end If;
1524: --
1525: if (p_cost_cleared_payment = 'Y') and (p_cost_payment <> 'Y') then
1526: --
1527: fnd_message.set_name('PAY', 'PAY_33415_CST_CLRCST_SYNC');
1528: fnd_message.set_token('PARAMETER1','COST_PAYMENT');
1529: fnd_message.set_token('PARAMETER2','COST_CLEARED_PAYMENT');
1530: fnd_message.raise_error;
1531: --

Line 1528: fnd_message.set_token('PARAMETER1','COST_PAYMENT');

1524: --
1525: if (p_cost_cleared_payment = 'Y') and (p_cost_payment <> 'Y') then
1526: --
1527: fnd_message.set_name('PAY', 'PAY_33415_CST_CLRCST_SYNC');
1528: fnd_message.set_token('PARAMETER1','COST_PAYMENT');
1529: fnd_message.set_token('PARAMETER2','COST_CLEARED_PAYMENT');
1530: fnd_message.raise_error;
1531: --
1532: end If;

Line 1529: fnd_message.set_token('PARAMETER2','COST_CLEARED_PAYMENT');

1525: if (p_cost_cleared_payment = 'Y') and (p_cost_payment <> 'Y') then
1526: --
1527: fnd_message.set_name('PAY', 'PAY_33415_CST_CLRCST_SYNC');
1528: fnd_message.set_token('PARAMETER1','COST_PAYMENT');
1529: fnd_message.set_token('PARAMETER2','COST_CLEARED_PAYMENT');
1530: fnd_message.raise_error;
1531: --
1532: end If;
1533: --

Line 1530: fnd_message.raise_error;

1526: --
1527: fnd_message.set_name('PAY', 'PAY_33415_CST_CLRCST_SYNC');
1528: fnd_message.set_token('PARAMETER1','COST_PAYMENT');
1529: fnd_message.set_token('PARAMETER2','COST_CLEARED_PAYMENT');
1530: fnd_message.raise_error;
1531: --
1532: end If;
1533: --
1534: end if;

Line 1561: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');

1557: (p_effective_date
1558: ,'YES_NO'
1559: ,p_cost_cleared_void_payment) then
1560: --
1561: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1562: fnd_message.set_token('COLUMN','COST_CLEARED_VOID_PAYMENT');
1563: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1564: fnd_message.raise_error;
1565: --

Line 1562: fnd_message.set_token('COLUMN','COST_CLEARED_VOID_PAYMENT');

1558: ,'YES_NO'
1559: ,p_cost_cleared_void_payment) then
1560: --
1561: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1562: fnd_message.set_token('COLUMN','COST_CLEARED_VOID_PAYMENT');
1563: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1564: fnd_message.raise_error;
1565: --
1566: end If;

Line 1563: fnd_message.set_token('LOOKUP_TYPE','YES_NO');

1559: ,p_cost_cleared_void_payment) then
1560: --
1561: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1562: fnd_message.set_token('COLUMN','COST_CLEARED_VOID_PAYMENT');
1563: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1564: fnd_message.raise_error;
1565: --
1566: end If;
1567: --

Line 1564: fnd_message.raise_error;

1560: --
1561: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1562: fnd_message.set_token('COLUMN','COST_CLEARED_VOID_PAYMENT');
1563: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1564: fnd_message.raise_error;
1565: --
1566: end If;
1567: --
1568: If ((p_cost_cleared_void_payment = 'Y') and (p_cost_cleared_payment <> 'Y')) then

Line 1570: fnd_message.set_name('PAY', 'PAY_33415_CST_CSTCLR_SYNC');

1566: end If;
1567: --
1568: If ((p_cost_cleared_void_payment = 'Y') and (p_cost_cleared_payment <> 'Y')) then
1569: --
1570: fnd_message.set_name('PAY', 'PAY_33415_CST_CSTCLR_SYNC');
1571: fnd_message.set_token('PARAMETER1','COST_CLEARED_PAYMENT');
1572: fnd_message.set_token('PARAMETER2','COST_CLEARED_VOID_PAYMENT');
1573: fnd_message.raise_error;
1574: --

Line 1571: fnd_message.set_token('PARAMETER1','COST_CLEARED_PAYMENT');

1567: --
1568: If ((p_cost_cleared_void_payment = 'Y') and (p_cost_cleared_payment <> 'Y')) then
1569: --
1570: fnd_message.set_name('PAY', 'PAY_33415_CST_CSTCLR_SYNC');
1571: fnd_message.set_token('PARAMETER1','COST_CLEARED_PAYMENT');
1572: fnd_message.set_token('PARAMETER2','COST_CLEARED_VOID_PAYMENT');
1573: fnd_message.raise_error;
1574: --
1575: end If;

Line 1572: fnd_message.set_token('PARAMETER2','COST_CLEARED_VOID_PAYMENT');

1568: If ((p_cost_cleared_void_payment = 'Y') and (p_cost_cleared_payment <> 'Y')) then
1569: --
1570: fnd_message.set_name('PAY', 'PAY_33415_CST_CSTCLR_SYNC');
1571: fnd_message.set_token('PARAMETER1','COST_CLEARED_PAYMENT');
1572: fnd_message.set_token('PARAMETER2','COST_CLEARED_VOID_PAYMENT');
1573: fnd_message.raise_error;
1574: --
1575: end If;
1576: --

Line 1573: fnd_message.raise_error;

1569: --
1570: fnd_message.set_name('PAY', 'PAY_33415_CST_CSTCLR_SYNC');
1571: fnd_message.set_token('PARAMETER1','COST_CLEARED_PAYMENT');
1572: fnd_message.set_token('PARAMETER2','COST_CLEARED_VOID_PAYMENT');
1573: fnd_message.raise_error;
1574: --
1575: end If;
1576: --
1577: end if;

Line 1604: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');

1600: (p_effective_date
1601: ,'YES_NO'
1602: ,p_exclude_manual_payment) then
1603: --
1604: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1605: fnd_message.set_token('COLUMN','EXCLUDE_MANUAL_PAYMENT');
1606: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1607: fnd_message.raise_error;
1608: --

Line 1605: fnd_message.set_token('COLUMN','EXCLUDE_MANUAL_PAYMENT');

1601: ,'YES_NO'
1602: ,p_exclude_manual_payment) then
1603: --
1604: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1605: fnd_message.set_token('COLUMN','EXCLUDE_MANUAL_PAYMENT');
1606: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1607: fnd_message.raise_error;
1608: --
1609: end if;

Line 1606: fnd_message.set_token('LOOKUP_TYPE','YES_NO');

1602: ,p_exclude_manual_payment) then
1603: --
1604: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1605: fnd_message.set_token('COLUMN','EXCLUDE_MANUAL_PAYMENT');
1606: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1607: fnd_message.raise_error;
1608: --
1609: end if;
1610: --

Line 1607: fnd_message.raise_error;

1603: --
1604: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1605: fnd_message.set_token('COLUMN','EXCLUDE_MANUAL_PAYMENT');
1606: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1607: fnd_message.raise_error;
1608: --
1609: end if;
1610: --
1611: If ((p_exclude_manual_payment = 'Y') and (p_cost_payment <> 'Y')) then

Line 1613: fnd_message.set_name('PAY', 'PAY_33415_CST_CSTCLR_SYNC');

1609: end if;
1610: --
1611: If ((p_exclude_manual_payment = 'Y') and (p_cost_payment <> 'Y')) then
1612: --
1613: fnd_message.set_name('PAY', 'PAY_33415_CST_CSTCLR_SYNC');
1614: fnd_message.set_token('PARAMETER1','COST_PAYMENT');
1615: fnd_message.set_token('PARAMETER2','EXCLUDE_MANUAL_PAYMENT');
1616: fnd_message.raise_error;
1617: --

Line 1614: fnd_message.set_token('PARAMETER1','COST_PAYMENT');

1610: --
1611: If ((p_exclude_manual_payment = 'Y') and (p_cost_payment <> 'Y')) then
1612: --
1613: fnd_message.set_name('PAY', 'PAY_33415_CST_CSTCLR_SYNC');
1614: fnd_message.set_token('PARAMETER1','COST_PAYMENT');
1615: fnd_message.set_token('PARAMETER2','EXCLUDE_MANUAL_PAYMENT');
1616: fnd_message.raise_error;
1617: --
1618: end If;

Line 1615: fnd_message.set_token('PARAMETER2','EXCLUDE_MANUAL_PAYMENT');

1611: If ((p_exclude_manual_payment = 'Y') and (p_cost_payment <> 'Y')) then
1612: --
1613: fnd_message.set_name('PAY', 'PAY_33415_CST_CSTCLR_SYNC');
1614: fnd_message.set_token('PARAMETER1','COST_PAYMENT');
1615: fnd_message.set_token('PARAMETER2','EXCLUDE_MANUAL_PAYMENT');
1616: fnd_message.raise_error;
1617: --
1618: end If;
1619: --

Line 1616: fnd_message.raise_error;

1612: --
1613: fnd_message.set_name('PAY', 'PAY_33415_CST_CSTCLR_SYNC');
1614: fnd_message.set_token('PARAMETER1','COST_PAYMENT');
1615: fnd_message.set_token('PARAMETER2','EXCLUDE_MANUAL_PAYMENT');
1616: fnd_message.raise_error;
1617: --
1618: end If;
1619: --
1620: end If;

Line 1647: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');

1643: (p_effective_date
1644: ,'YES_NO'
1645: ,p_transfer_to_gl_flag) then
1646: --
1647: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1648: fnd_message.set_token('COLUMN','TRANSFER_TO_GL_FLAG');
1649: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1650: fnd_message.raise_error;
1651: --

Line 1648: fnd_message.set_token('COLUMN','TRANSFER_TO_GL_FLAG');

1644: ,'YES_NO'
1645: ,p_transfer_to_gl_flag) then
1646: --
1647: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1648: fnd_message.set_token('COLUMN','TRANSFER_TO_GL_FLAG');
1649: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1650: fnd_message.raise_error;
1651: --
1652: end If;

Line 1649: fnd_message.set_token('LOOKUP_TYPE','YES_NO');

1645: ,p_transfer_to_gl_flag) then
1646: --
1647: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1648: fnd_message.set_token('COLUMN','TRANSFER_TO_GL_FLAG');
1649: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1650: fnd_message.raise_error;
1651: --
1652: end If;
1653: --

Line 1650: fnd_message.raise_error;

1646: --
1647: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1648: fnd_message.set_token('COLUMN','TRANSFER_TO_GL_FLAG');
1649: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1650: fnd_message.raise_error;
1651: --
1652: end If;
1653: --
1654: If ((p_transfer_to_gl_flag = 'Y') and (p_cost_payment <> 'Y')) then

Line 1656: fnd_message.set_name('PAY', 'PAY_33415_CST_CSTCLR_SYNC');

1652: end If;
1653: --
1654: If ((p_transfer_to_gl_flag = 'Y') and (p_cost_payment <> 'Y')) then
1655: --
1656: fnd_message.set_name('PAY', 'PAY_33415_CST_CSTCLR_SYNC');
1657: fnd_message.set_token('PARAMETER1','COST_PAYMENT');
1658: fnd_message.set_token('PARAMETER2','TRANSFER_TO_GL_FLAG');
1659: fnd_message.raise_error;
1660: --

Line 1657: fnd_message.set_token('PARAMETER1','COST_PAYMENT');

1653: --
1654: If ((p_transfer_to_gl_flag = 'Y') and (p_cost_payment <> 'Y')) then
1655: --
1656: fnd_message.set_name('PAY', 'PAY_33415_CST_CSTCLR_SYNC');
1657: fnd_message.set_token('PARAMETER1','COST_PAYMENT');
1658: fnd_message.set_token('PARAMETER2','TRANSFER_TO_GL_FLAG');
1659: fnd_message.raise_error;
1660: --
1661: end If;

Line 1658: fnd_message.set_token('PARAMETER2','TRANSFER_TO_GL_FLAG');

1654: If ((p_transfer_to_gl_flag = 'Y') and (p_cost_payment <> 'Y')) then
1655: --
1656: fnd_message.set_name('PAY', 'PAY_33415_CST_CSTCLR_SYNC');
1657: fnd_message.set_token('PARAMETER1','COST_PAYMENT');
1658: fnd_message.set_token('PARAMETER2','TRANSFER_TO_GL_FLAG');
1659: fnd_message.raise_error;
1660: --
1661: end If;
1662: --

Line 1659: fnd_message.raise_error;

1655: --
1656: fnd_message.set_name('PAY', 'PAY_33415_CST_CSTCLR_SYNC');
1657: fnd_message.set_token('PARAMETER1','COST_PAYMENT');
1658: fnd_message.set_token('PARAMETER2','TRANSFER_TO_GL_FLAG');
1659: fnd_message.raise_error;
1660: --
1661: end If;
1662: --
1663: end if;

Line 1792: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');

1788: If csr_pre_payment_exists%found Then
1789: --
1790: close csr_pre_payment_exists;
1791: --
1792: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1793: fnd_message.set_token('TABLE_NAME', 'PAY_PRE_PAYMENTS');
1794: fnd_message.raise_error;
1795: --
1796: End If;

Line 1793: fnd_message.set_token('TABLE_NAME', 'PAY_PRE_PAYMENTS');

1789: --
1790: close csr_pre_payment_exists;
1791: --
1792: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1793: fnd_message.set_token('TABLE_NAME', 'PAY_PRE_PAYMENTS');
1794: fnd_message.raise_error;
1795: --
1796: End If;
1797: --

Line 1794: fnd_message.raise_error;

1790: close csr_pre_payment_exists;
1791: --
1792: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1793: fnd_message.set_token('TABLE_NAME', 'PAY_PRE_PAYMENTS');
1794: fnd_message.raise_error;
1795: --
1796: End If;
1797: --
1798: close csr_pre_payment_exists;

Line 1811: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');

1807: If csr_org_pay_methods_tl_exists%found Then
1808: --
1809: close csr_org_pay_methods_tl_exists;
1810: --
1811: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1812: fnd_message.set_token('TABLE_NAME', 'PAY_ORG_PAYMENT_METHODS_F_TL');
1813: fnd_message.raise_error;
1814: --
1815: End If;

Line 1812: fnd_message.set_token('TABLE_NAME', 'PAY_ORG_PAYMENT_METHODS_F_TL');

1808: --
1809: close csr_org_pay_methods_tl_exists;
1810: --
1811: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1812: fnd_message.set_token('TABLE_NAME', 'PAY_ORG_PAYMENT_METHODS_F_TL');
1813: fnd_message.raise_error;
1814: --
1815: End If;
1816: --

Line 1813: fnd_message.raise_error;

1809: close csr_org_pay_methods_tl_exists;
1810: --
1811: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1812: fnd_message.set_token('TABLE_NAME', 'PAY_ORG_PAYMENT_METHODS_F_TL');
1813: fnd_message.raise_error;
1814: --
1815: End If;
1816: --
1817: close csr_org_pay_methods_tl_exists;

Line 1830: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');

1826: If csr_payroll_actions_exists%found Then
1827: --
1828: close csr_payroll_actions_exists;
1829: --
1830: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1831: fnd_message.set_token('TABLE_NAME', 'PAY_PAYROLL_ACTIONS');
1832: fnd_message.raise_error;
1833: --
1834: End If;

Line 1831: fnd_message.set_token('TABLE_NAME', 'PAY_PAYROLL_ACTIONS');

1827: --
1828: close csr_payroll_actions_exists;
1829: --
1830: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1831: fnd_message.set_token('TABLE_NAME', 'PAY_PAYROLL_ACTIONS');
1832: fnd_message.raise_error;
1833: --
1834: End If;
1835: --

Line 1832: fnd_message.raise_error;

1828: close csr_payroll_actions_exists;
1829: --
1830: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1831: fnd_message.set_token('TABLE_NAME', 'PAY_PAYROLL_ACTIONS');
1832: fnd_message.raise_error;
1833: --
1834: End If;
1835: --
1836: close csr_payroll_actions_exists;

Line 1852: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');

1848: --
1849: close csr_payrolls_exists;
1850: --
1851: if (p_datetrack_mode = hr_api.g_zap) then
1852: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1853: fnd_message.set_token('TABLE_NAME', 'PAY_ALL_PAYROLLS_F');
1854: fnd_message.raise_error;
1855: else
1856: fnd_message.set_name('PAY','HR_6739_PAYM_NO_METH');

Line 1853: fnd_message.set_token('TABLE_NAME', 'PAY_ALL_PAYROLLS_F');

1849: close csr_payrolls_exists;
1850: --
1851: if (p_datetrack_mode = hr_api.g_zap) then
1852: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1853: fnd_message.set_token('TABLE_NAME', 'PAY_ALL_PAYROLLS_F');
1854: fnd_message.raise_error;
1855: else
1856: fnd_message.set_name('PAY','HR_6739_PAYM_NO_METH');
1857: fnd_message.raise_error;

Line 1854: fnd_message.raise_error;

1850: --
1851: if (p_datetrack_mode = hr_api.g_zap) then
1852: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1853: fnd_message.set_token('TABLE_NAME', 'PAY_ALL_PAYROLLS_F');
1854: fnd_message.raise_error;
1855: else
1856: fnd_message.set_name('PAY','HR_6739_PAYM_NO_METH');
1857: fnd_message.raise_error;
1858: end if;

Line 1856: fnd_message.set_name('PAY','HR_6739_PAYM_NO_METH');

1852: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1853: fnd_message.set_token('TABLE_NAME', 'PAY_ALL_PAYROLLS_F');
1854: fnd_message.raise_error;
1855: else
1856: fnd_message.set_name('PAY','HR_6739_PAYM_NO_METH');
1857: fnd_message.raise_error;
1858: end if;
1859: --
1860: End If;

Line 1857: fnd_message.raise_error;

1853: fnd_message.set_token('TABLE_NAME', 'PAY_ALL_PAYROLLS_F');
1854: fnd_message.raise_error;
1855: else
1856: fnd_message.set_name('PAY','HR_6739_PAYM_NO_METH');
1857: fnd_message.raise_error;
1858: end if;
1859: --
1860: End If;
1861: --

Line 1873: fnd_message.set_name('PAY', 'PAY_52999_METHOD_USED_FOR_CE');

1869: p_validation_start_date =>p_validation_start_date,
1870: p_validation_end_date =>p_validation_end_date
1871: ))Then
1872: --
1873: fnd_message.set_name('PAY', 'PAY_52999_METHOD_USED_FOR_CE');
1874: fnd_message.raise_error;
1875: --
1876: End If;
1877: --

Line 1874: fnd_message.raise_error;

1870: p_validation_end_date =>p_validation_end_date
1871: ))Then
1872: --
1873: fnd_message.set_name('PAY', 'PAY_52999_METHOD_USED_FOR_CE');
1874: fnd_message.raise_error;
1875: --
1876: End If;
1877: --
1878: hr_utility.set_location(' Leaving:'||l_proc, 40);