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