eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_FEDHR_USPAY_INTG_PKG dependencies on HR_UTILITY

Line 207: hr_utility.trace('Starts');

203:
204: l_ff_percent_non :='PERCENTAGE_OF_REG_EARNINGS_NONRECUR_V2';
205:
206: --
207: hr_utility.trace('Starts');
208: l_bg_id :=p_bg_id;
209: l_prefix :=p_prefix;
210: l_ssn_start_date :=
211: nvl(p_eff_start_date,to_Date('01-01-1951','DD-MM-YYYY'));

Line 223: hr_utility.trace('bg name is '||l_bg_name);

219: l_bg_name:=c_bg_rec.name;
220: ELSE
221: l_bg_name:=NULL;
222: END IF;
223: hr_utility.trace('bg name is '||l_bg_name);
224: END LOOP;
225: --
226: hr_utility.trace('Starts');
227:

Line 226: hr_utility.trace('Starts');

222: END IF;
223: hr_utility.trace('bg name is '||l_bg_name);
224: END LOOP;
225: --
226: hr_utility.trace('Starts');
227:
228: -- #################################################################--
229: -- EARNINGS Elements ASSIGNMENT
230: -- #################################################################--

Line 265: hr_utility.trace('Starts');

261:
262: --=============================================================================
263: -- No. of additional input values = 1
264: --=============================================================================
265: hr_utility.trace('Starts');
266: l_input_value_counter := l_input_value_counter + 1;
267: p_earn(l_earn_ele_tab_counter).inp_val_low_range := l_input_value_counter;
268:
269: earn_input_vals(l_input_value_counter).element_name := 'Basic Salary Rate';

Line 977: hr_utility.trace('Total Elements'||to_char(p_ele_cnt));

973: -- End Of Earnings Assignments
974: -- **************************************************************** --
975:
976: --p_ele_cnt := l_earn_ele_tab_counter + l_dedn_ele_tab_counter;
977: hr_utility.trace('Total Elements'||to_char(p_ele_cnt));
978: hr_utility.trace('Assign vals completed');
979:
980: p_ele_cnt := l_earn_ele_tab_counter;
981:

Line 978: hr_utility.trace('Assign vals completed');

974: -- **************************************************************** --
975:
976: --p_ele_cnt := l_earn_ele_tab_counter + l_dedn_ele_tab_counter;
977: hr_utility.trace('Total Elements'||to_char(p_ele_cnt));
978: hr_utility.trace('Assign vals completed');
979:
980: p_ele_cnt := l_earn_ele_tab_counter;
981:
982: END populate_dc_ele_inp_tabs;

Line 1041: hr_utility.trace('entering input vals');

1037:
1038: l_prefix := null;
1039: l_cntr :=p_cnt;
1040:
1041: hr_utility.trace('entering input vals');
1042:
1043: FOR l IN input_value_low_range..input_value_high_range
1044: LOOP
1045:

Line 1046: hr_utility.trace(input_value_tab(l).name);

1042:
1043: FOR l IN input_value_low_range..input_value_high_range
1044: LOOP
1045:
1046: hr_utility.trace(input_value_tab(l).name);
1047: hr_utility.trace(input_value_tab(l).element_name);
1048:
1049: l_input_value_id:= pay_db_pay_setup.create_input_value (
1050: p_element_name => input_value_tab(l).element_name,

Line 1047: hr_utility.trace(input_value_tab(l).element_name);

1043: FOR l IN input_value_low_range..input_value_high_range
1044: LOOP
1045:
1046: hr_utility.trace(input_value_tab(l).name);
1047: hr_utility.trace(input_value_tab(l).element_name);
1048:
1049: l_input_value_id:= pay_db_pay_setup.create_input_value (
1050: p_element_name => input_value_tab(l).element_name,
1051: p_name => input_value_tab(l).name,

Line 1068: hr_utility.trace('out of inp vals');

1064: --- Using this counter for incrementing the Display Sequence
1065:
1066: END LOOP;
1067:
1068: hr_utility.trace('out of inp vals');
1069:
1070: END input_values;
1071: --###====================================================================###
1072:

Line 1251: hr_utility.trace('EARNINGS');

1247:
1248: FOR l_index IN 1..p_earn.COUNT
1249: LOOP
1250:
1251: hr_utility.trace('EARNINGS');
1252: hr_utility.trace(l_prefix || ' ' || p_earn(l_index).ele_name);
1253: --
1254: -----------------------------------------------------------------
1255: -- check to see if Element already exists with this prefix

Line 1252: hr_utility.trace(l_prefix || ' ' || p_earn(l_index).ele_name);

1248: FOR l_index IN 1..p_earn.COUNT
1249: LOOP
1250:
1251: hr_utility.trace('EARNINGS');
1252: hr_utility.trace(l_prefix || ' ' || p_earn(l_index).ele_name);
1253: --
1254: -----------------------------------------------------------------
1255: -- check to see if Element already exists with this prefix
1256: -----------------------------------------------------------------

Line 1369: hr_utility.set_message(8303,'HR_374605_MAPPING_OLD_TO_NEW');

1365: -- Mapping of Old Element to New Name
1366: -- Example Federal Awards to AM Federal Awards etc/
1367: --****************************************************************
1368:
1369: hr_utility.set_message(8303,'HR_374605_MAPPING_OLD_TO_NEW');
1370: hr_utility.set_message_token('OLD_NAME',
1371: rpad(p_earn(l_index).org_ele_name,30));
1372: hr_utility.set_message_token('NEW_NAME',rpad(l_ele_name,30));
1373: l_mesg:=hr_utility.get_message;

Line 1370: hr_utility.set_message_token('OLD_NAME',

1366: -- Example Federal Awards to AM Federal Awards etc/
1367: --****************************************************************
1368:
1369: hr_utility.set_message(8303,'HR_374605_MAPPING_OLD_TO_NEW');
1370: hr_utility.set_message_token('OLD_NAME',
1371: rpad(p_earn(l_index).org_ele_name,30));
1372: hr_utility.set_message_token('NEW_NAME',rpad(l_ele_name,30));
1373: l_mesg:=hr_utility.get_message;
1374: fnd_file.put(fnd_file.log,l_mesg);

Line 1372: hr_utility.set_message_token('NEW_NAME',rpad(l_ele_name,30));

1368:
1369: hr_utility.set_message(8303,'HR_374605_MAPPING_OLD_TO_NEW');
1370: hr_utility.set_message_token('OLD_NAME',
1371: rpad(p_earn(l_index).org_ele_name,30));
1372: hr_utility.set_message_token('NEW_NAME',rpad(l_ele_name,30));
1373: l_mesg:=hr_utility.get_message;
1374: fnd_file.put(fnd_file.log,l_mesg);
1375: fnd_file.new_line(fnd_file.log);
1376:

Line 1373: l_mesg:=hr_utility.get_message;

1369: hr_utility.set_message(8303,'HR_374605_MAPPING_OLD_TO_NEW');
1370: hr_utility.set_message_token('OLD_NAME',
1371: rpad(p_earn(l_index).org_ele_name,30));
1372: hr_utility.set_message_token('NEW_NAME',rpad(l_ele_name,30));
1373: l_mesg:=hr_utility.get_message;
1374: fnd_file.put(fnd_file.log,l_mesg);
1375: fnd_file.new_line(fnd_file.log);
1376:
1377: --****************************************************************

Line 1379: hr_utility.trace(

1375: fnd_file.new_line(fnd_file.log);
1376:
1377: --****************************************************************
1378:
1379: hr_utility.trace(
1380: 'Created EARNINGS Element'||p_earn(l_index).ele_name||TO_CHAR(l_index));
1381:
1382: --######## Count number of Earnings Elements created
1383: p_earn_cnt := p_earn_cnt + 1;

Line 1447: --hr_utility.trace('ded count is ' || to_char(p_dedn.COUNT));

1443: -- Initialization
1444: --l_prefix:=p_prefix;
1445: --p_dedn_cnt :=0;
1446: --
1447: --hr_utility.trace('ded count is ' || to_char(p_dedn.COUNT));
1448: --
1449: --FOR l_index in 1..p_dedn.COUNT
1450: --Loop
1451: --hr_utility.trace('DEDUCTIONS');

Line 1451: --hr_utility.trace('DEDUCTIONS');

1447: --hr_utility.trace('ded count is ' || to_char(p_dedn.COUNT));
1448: --
1449: --FOR l_index in 1..p_dedn.COUNT
1450: --Loop
1451: --hr_utility.trace('DEDUCTIONS');
1452: ----
1453: -------------------------------------------------------------------
1454: ---- Truncating Element name to 13 chars
1455: -------------------------------------------------------------------

Line 1522: --hr_utility.trace('not null ----');

1518: --
1519: --
1520: -- IF (p_dedn(l_index).inp_val_low_range IS NOT NULL)
1521: -- THEN
1522: --hr_utility.trace('not null ----');
1523: -- FOR cnt_rec in c_no_of_input_vals(l_element_type_id)
1524: -- LOOP
1525: -- l_cnt:=cnt_rec.count;
1526: -- END LOOP;

Line 1528: --hr_utility.trace('inp count is ' || to_char(l_cnt));

1524: -- LOOP
1525: -- l_cnt:=cnt_rec.count;
1526: -- END LOOP;
1527: -- l_cnt:=l_cnt+1;
1528: --hr_utility.trace('inp count is ' || to_char(l_cnt));
1529: --hr_utility.trace('low inp ' || to_char(p_dedn(l_index).inp_val_low_range));
1530: --hr_utility.trace('high ' || to_char(p_dedn(l_index).inp_val_high_range));
1531: --
1532: --

Line 1529: --hr_utility.trace('low inp ' || to_char(p_dedn(l_index).inp_val_low_range));

1525: -- l_cnt:=cnt_rec.count;
1526: -- END LOOP;
1527: -- l_cnt:=l_cnt+1;
1528: --hr_utility.trace('inp count is ' || to_char(l_cnt));
1529: --hr_utility.trace('low inp ' || to_char(p_dedn(l_index).inp_val_low_range));
1530: --hr_utility.trace('high ' || to_char(p_dedn(l_index).inp_val_high_range));
1531: --
1532: --
1533: ----****************************************************************

Line 1530: --hr_utility.trace('high ' || to_char(p_dedn(l_index).inp_val_high_range));

1526: -- END LOOP;
1527: -- l_cnt:=l_cnt+1;
1528: --hr_utility.trace('inp count is ' || to_char(l_cnt));
1529: --hr_utility.trace('low inp ' || to_char(p_dedn(l_index).inp_val_low_range));
1530: --hr_utility.trace('high ' || to_char(p_dedn(l_index).inp_val_high_range));
1531: --
1532: --
1533: ----****************************************************************
1534: ---- whether element is new or old pick the ele name from l_ele_name

Line 1554: --hr_utility.set_message(8303,'HR_374605_MAPPING_OLD_TO_NEW');

1550: ------****************************************************************
1551: ---- Mapping of Old Element to New Name
1552: ---- Example Health Benefits to AM Health Ben1
1553: ----******************************************************************
1554: --hr_utility.set_message(8303,'HR_374605_MAPPING_OLD_TO_NEW');
1555: --hr_utility.set_message_token('OLD_NAME',p_dedn(l_index).org_ele_name);
1556: --hr_utility.set_message_token('NEW_NAME',l_ele_name);
1557: --l_mesg:=hr_utility.get_message;
1558: --fnd_file.put(fnd_file.log,l_mesg);

Line 1555: --hr_utility.set_message_token('OLD_NAME',p_dedn(l_index).org_ele_name);

1551: ---- Mapping of Old Element to New Name
1552: ---- Example Health Benefits to AM Health Ben1
1553: ----******************************************************************
1554: --hr_utility.set_message(8303,'HR_374605_MAPPING_OLD_TO_NEW');
1555: --hr_utility.set_message_token('OLD_NAME',p_dedn(l_index).org_ele_name);
1556: --hr_utility.set_message_token('NEW_NAME',l_ele_name);
1557: --l_mesg:=hr_utility.get_message;
1558: --fnd_file.put(fnd_file.log,l_mesg);
1559: --fnd_file.new_line(fnd_file.log);

Line 1556: --hr_utility.set_message_token('NEW_NAME',l_ele_name);

1552: ---- Example Health Benefits to AM Health Ben1
1553: ----******************************************************************
1554: --hr_utility.set_message(8303,'HR_374605_MAPPING_OLD_TO_NEW');
1555: --hr_utility.set_message_token('OLD_NAME',p_dedn(l_index).org_ele_name);
1556: --hr_utility.set_message_token('NEW_NAME',l_ele_name);
1557: --l_mesg:=hr_utility.get_message;
1558: --fnd_file.put(fnd_file.log,l_mesg);
1559: --fnd_file.new_line(fnd_file.log);
1560: --

Line 1557: --l_mesg:=hr_utility.get_message;

1553: ----******************************************************************
1554: --hr_utility.set_message(8303,'HR_374605_MAPPING_OLD_TO_NEW');
1555: --hr_utility.set_message_token('OLD_NAME',p_dedn(l_index).org_ele_name);
1556: --hr_utility.set_message_token('NEW_NAME',l_ele_name);
1557: --l_mesg:=hr_utility.get_message;
1558: --fnd_file.put(fnd_file.log,l_mesg);
1559: --fnd_file.new_line(fnd_file.log);
1560: --
1561: ----******************************************************************

Line 1563: --hr_utility.trace

1559: --fnd_file.new_line(fnd_file.log);
1560: --
1561: ----******************************************************************
1562: --
1563: --hr_utility.trace
1564: --('Dedn Low range for all'|| to_Char(p_dedn(l_index).inp_val_low_range));
1565: --
1566: -- END IF;
1567: --

Line 1568: --hr_utility.trace(

1564: --('Dedn Low range for all'|| to_Char(p_dedn(l_index).inp_val_low_range));
1565: --
1566: -- END IF;
1567: --
1568: --hr_utility.trace(
1569: --'Created DEDUCTIONS Element'||p_dedn(l_index).ele_name);
1570: --
1571: ----######### Count of Deduction Elements created
1572: --p_dedn_cnt := p_dedn_cnt + 1;

Line 1645: hr_utility.set_message(8303,'HR_374608_GREATR_DEF_DATE');

1641: ----**********************************************************************
1642:
1643: IF ( l_dt < l_def_date)
1644: THEN
1645: hr_utility.set_message(8303,'HR_374608_GREATR_DEF_DATE');
1646: l_mesg := l_mesg || hr_utility.get_message;
1647: fnd_file.put(fnd_file.log, l_mesg);
1648: hr_utility.raise_error;
1649: END IF;

Line 1646: l_mesg := l_mesg || hr_utility.get_message;

1642:
1643: IF ( l_dt < l_def_date)
1644: THEN
1645: hr_utility.set_message(8303,'HR_374608_GREATR_DEF_DATE');
1646: l_mesg := l_mesg || hr_utility.get_message;
1647: fnd_file.put(fnd_file.log, l_mesg);
1648: hr_utility.raise_error;
1649: END IF;
1650: ----**********************************************************************

Line 1648: hr_utility.raise_error;

1644: THEN
1645: hr_utility.set_message(8303,'HR_374608_GREATR_DEF_DATE');
1646: l_mesg := l_mesg || hr_utility.get_message;
1647: fnd_file.put(fnd_file.log, l_mesg);
1648: hr_utility.raise_error;
1649: END IF;
1650: ----**********************************************************************
1651: -- CHECK# : Date must be < 31-DEC-4712
1652: ----**********************************************************************

Line 1656: hr_utility.set_message(8303,'HR_374609_LESSTHN_MAX_DATE');

1652: ----**********************************************************************
1653:
1654: IF ( l_dt > l_max_date)
1655: THEN
1656: hr_utility.set_message(8303,'HR_374609_LESSTHN_MAX_DATE');
1657: l_mesg := l_mesg || hr_utility.get_message;
1658: fnd_file.put(fnd_file.log, l_mesg);
1659: hr_utility.raise_error;
1660: END IF;

Line 1657: l_mesg := l_mesg || hr_utility.get_message;

1653:
1654: IF ( l_dt > l_max_date)
1655: THEN
1656: hr_utility.set_message(8303,'HR_374609_LESSTHN_MAX_DATE');
1657: l_mesg := l_mesg || hr_utility.get_message;
1658: fnd_file.put(fnd_file.log, l_mesg);
1659: hr_utility.raise_error;
1660: END IF;
1661: ----**********************************************************************

Line 1659: hr_utility.raise_error;

1655: THEN
1656: hr_utility.set_message(8303,'HR_374609_LESSTHN_MAX_DATE');
1657: l_mesg := l_mesg || hr_utility.get_message;
1658: fnd_file.put(fnd_file.log, l_mesg);
1659: hr_utility.raise_error;
1660: END IF;
1661: ----**********************************************************************
1662: -- CHECK# :- Does prefix start with a
1663: -- number or any special character?

Line 1668: hr_utility.set_message(8303,'HR_374610_STRTS_WTH_NUM_SPCL');

1664: ----**********************************************************************
1665: IF (ascii(substr(p_prefix,1,1)) NOT BETWEEN ascii('a') AND ascii('z')
1666: AND ascii(substr(p_prefix,1,1)) NOT between ascii('A') AND ascii('Z') )
1667: THEN
1668: hr_utility.set_message(8303,'HR_374610_STRTS_WTH_NUM_SPCL');
1669: l_mesg := l_mesg || hr_utility.get_message;
1670: fnd_file.put(fnd_file.log, l_mesg);
1671: hr_utility.raise_error;
1672: END IF;

Line 1669: l_mesg := l_mesg || hr_utility.get_message;

1665: IF (ascii(substr(p_prefix,1,1)) NOT BETWEEN ascii('a') AND ascii('z')
1666: AND ascii(substr(p_prefix,1,1)) NOT between ascii('A') AND ascii('Z') )
1667: THEN
1668: hr_utility.set_message(8303,'HR_374610_STRTS_WTH_NUM_SPCL');
1669: l_mesg := l_mesg || hr_utility.get_message;
1670: fnd_file.put(fnd_file.log, l_mesg);
1671: hr_utility.raise_error;
1672: END IF;
1673:

Line 1671: hr_utility.raise_error;

1667: THEN
1668: hr_utility.set_message(8303,'HR_374610_STRTS_WTH_NUM_SPCL');
1669: l_mesg := l_mesg || hr_utility.get_message;
1670: fnd_file.put(fnd_file.log, l_mesg);
1671: hr_utility.raise_error;
1672: END IF;
1673:
1674: ----**********************************************************************
1675: -- CHECK # :- Existence of GHR Product

Line 1678: IF (hr_utility.chk_product_install('GHR','US') <> TRUE )

1674: ----**********************************************************************
1675: -- CHECK # :- Existence of GHR Product
1676: ----**********************************************************************
1677:
1678: IF (hr_utility.chk_product_install('GHR','US') <> TRUE )
1679: THEN
1680: hr_utility.set_message(8303,'HR_374601_PROD_NOT_INSTALLED');
1681: FOR c_gpn IN get_prod_name('GHR','US')
1682: LOOP

Line 1680: hr_utility.set_message(8303,'HR_374601_PROD_NOT_INSTALLED');

1676: ----**********************************************************************
1677:
1678: IF (hr_utility.chk_product_install('GHR','US') <> TRUE )
1679: THEN
1680: hr_utility.set_message(8303,'HR_374601_PROD_NOT_INSTALLED');
1681: FOR c_gpn IN get_prod_name('GHR','US')
1682: LOOP
1683: l_app_name := c_gpn.application_name;
1684: END LOOP;

Line 1685: hr_utility.set_message_token('PROD',l_app_name);

1681: FOR c_gpn IN get_prod_name('GHR','US')
1682: LOOP
1683: l_app_name := c_gpn.application_name;
1684: END LOOP;
1685: hr_utility.set_message_token('PROD',l_app_name);
1686: --hr_utility.raise_error;
1687: l_mesg := hr_utility.get_message;
1688: fnd_file.put(fnd_file.log, l_mesg);
1689: hr_multi_message.add(p_associated_column1 => 'Y');

Line 1686: --hr_utility.raise_error;

1682: LOOP
1683: l_app_name := c_gpn.application_name;
1684: END LOOP;
1685: hr_utility.set_message_token('PROD',l_app_name);
1686: --hr_utility.raise_error;
1687: l_mesg := hr_utility.get_message;
1688: fnd_file.put(fnd_file.log, l_mesg);
1689: hr_multi_message.add(p_associated_column1 => 'Y');
1690: END IF;

Line 1687: l_mesg := hr_utility.get_message;

1683: l_app_name := c_gpn.application_name;
1684: END LOOP;
1685: hr_utility.set_message_token('PROD',l_app_name);
1686: --hr_utility.raise_error;
1687: l_mesg := hr_utility.get_message;
1688: fnd_file.put(fnd_file.log, l_mesg);
1689: hr_multi_message.add(p_associated_column1 => 'Y');
1690: END IF;
1691:

Line 1696: IF ( hr_utility.chk_product_install('PAY', 'US') <> TRUE )

1692: ----**********************************************************************
1693: -- CHECK # :- Existence of PAYROLL Product
1694: ----**********************************************************************
1695:
1696: IF ( hr_utility.chk_product_install('PAY', 'US') <> TRUE )
1697: THEN
1698: hr_utility.set_message(8303,'HR_374601_PROD_NOT_INSTALLED');
1699: FOR c_gpn IN get_prod_name('PAY','US')
1700: LOOP

Line 1698: hr_utility.set_message(8303,'HR_374601_PROD_NOT_INSTALLED');

1694: ----**********************************************************************
1695:
1696: IF ( hr_utility.chk_product_install('PAY', 'US') <> TRUE )
1697: THEN
1698: hr_utility.set_message(8303,'HR_374601_PROD_NOT_INSTALLED');
1699: FOR c_gpn IN get_prod_name('PAY','US')
1700: LOOP
1701: l_app_name := c_gpn.application_name;
1702: END LOOP;

Line 1703: hr_utility.set_message_token('PROD',l_app_name);

1699: FOR c_gpn IN get_prod_name('PAY','US')
1700: LOOP
1701: l_app_name := c_gpn.application_name;
1702: END LOOP;
1703: hr_utility.set_message_token('PROD',l_app_name);
1704: l_mesg := l_mesg || hr_utility.get_message;
1705: --hr_utility.raise_error;
1706: fnd_file.put(fnd_file.log, l_mesg);
1707: hr_multi_message.add(p_associated_column1 => 'Y');

Line 1704: l_mesg := l_mesg || hr_utility.get_message;

1700: LOOP
1701: l_app_name := c_gpn.application_name;
1702: END LOOP;
1703: hr_utility.set_message_token('PROD',l_app_name);
1704: l_mesg := l_mesg || hr_utility.get_message;
1705: --hr_utility.raise_error;
1706: fnd_file.put(fnd_file.log, l_mesg);
1707: hr_multi_message.add(p_associated_column1 => 'Y');
1708: END IF;

Line 1705: --hr_utility.raise_error;

1701: l_app_name := c_gpn.application_name;
1702: END LOOP;
1703: hr_utility.set_message_token('PROD',l_app_name);
1704: l_mesg := l_mesg || hr_utility.get_message;
1705: --hr_utility.raise_error;
1706: fnd_file.put(fnd_file.log, l_mesg);
1707: hr_multi_message.add(p_associated_column1 => 'Y');
1708: END IF;
1709: ----**********************************************************************

Line 1717: hr_utility.set_message(8303,'HR_374602_SCRIPT_ALREADY_RUN');

1713: IF (pqp_fedhr_uspay_int_utils.is_script_run(
1714: p_business_group_id => p_business_group_id,
1715: p_fedhr_element_name => 'Federal Awards') = TRUE)
1716: THEN
1717: hr_utility.set_message(8303,'HR_374602_SCRIPT_ALREADY_RUN');
1718: l_mesg := l_mesg || hr_utility.get_message;
1719: fnd_file.put(fnd_file.log, l_mesg);
1720: --hr_utility.raise_error;
1721: hr_multi_message.add(p_associated_column1 => 'Y');

Line 1718: l_mesg := l_mesg || hr_utility.get_message;

1714: p_business_group_id => p_business_group_id,
1715: p_fedhr_element_name => 'Federal Awards') = TRUE)
1716: THEN
1717: hr_utility.set_message(8303,'HR_374602_SCRIPT_ALREADY_RUN');
1718: l_mesg := l_mesg || hr_utility.get_message;
1719: fnd_file.put(fnd_file.log, l_mesg);
1720: --hr_utility.raise_error;
1721: hr_multi_message.add(p_associated_column1 => 'Y');
1722: END IF;

Line 1720: --hr_utility.raise_error;

1716: THEN
1717: hr_utility.set_message(8303,'HR_374602_SCRIPT_ALREADY_RUN');
1718: l_mesg := l_mesg || hr_utility.get_message;
1719: fnd_file.put(fnd_file.log, l_mesg);
1720: --hr_utility.raise_error;
1721: hr_multi_message.add(p_associated_column1 => 'Y');
1722: END IF;
1723:
1724: populate_dc_ele_inp_tabs(p_bg_id => p_business_group_id ,

Line 1742: hr_utility.set_message(8303,'HR_374604_ELE_LINK_EXISTS');

1738: p_ele_name => l_ele_name,
1739: p_bg_id => p_earn(l_index).bg_id);
1740: IF l_ele_lnk_flg
1741: THEN
1742: hr_utility.set_message(8303,'HR_374604_ELE_LINK_EXISTS');
1743:
1744: l_mesg := l_mesg || hr_utility.get_message;
1745: fnd_file.put(fnd_file.log, l_mesg);
1746: hr_utility.raise_error;

Line 1744: l_mesg := l_mesg || hr_utility.get_message;

1740: IF l_ele_lnk_flg
1741: THEN
1742: hr_utility.set_message(8303,'HR_374604_ELE_LINK_EXISTS');
1743:
1744: l_mesg := l_mesg || hr_utility.get_message;
1745: fnd_file.put(fnd_file.log, l_mesg);
1746: hr_utility.raise_error;
1747: END IF;
1748: END LOOP; -- for earn

Line 1746: hr_utility.raise_error;

1742: hr_utility.set_message(8303,'HR_374604_ELE_LINK_EXISTS');
1743:
1744: l_mesg := l_mesg || hr_utility.get_message;
1745: fnd_file.put(fnd_file.log, l_mesg);
1746: hr_utility.raise_error;
1747: END IF;
1748: END LOOP; -- for earn
1749:
1750:

Line 1759: -- hr_utility.set_message(8303,'HR_374604_ELE_LINK_EXISTS');

1755: -- p_ele_name => l_ele_name,
1756: -- p_bg_id => p_dedn(l_index).bg_id);
1757: --
1758: -- If l_ele_lnk_flg then
1759: -- hr_utility.set_message(8303,'HR_374604_ELE_LINK_EXISTS');
1760: -- l_mesg := l_mesg || hr_utility.get_message;
1761: -- fnd_file.put(fnd_file.log, l_mesg);
1762: -- -- hr_utility.raise_error;
1763: -- End if;

Line 1760: -- l_mesg := l_mesg || hr_utility.get_message;

1756: -- p_bg_id => p_dedn(l_index).bg_id);
1757: --
1758: -- If l_ele_lnk_flg then
1759: -- hr_utility.set_message(8303,'HR_374604_ELE_LINK_EXISTS');
1760: -- l_mesg := l_mesg || hr_utility.get_message;
1761: -- fnd_file.put(fnd_file.log, l_mesg);
1762: -- -- hr_utility.raise_error;
1763: -- End if;
1764: -- END LOOP; -- for dedn

Line 1762: -- -- hr_utility.raise_error;

1758: -- If l_ele_lnk_flg then
1759: -- hr_utility.set_message(8303,'HR_374604_ELE_LINK_EXISTS');
1760: -- l_mesg := l_mesg || hr_utility.get_message;
1761: -- fnd_file.put(fnd_file.log, l_mesg);
1762: -- -- hr_utility.raise_error;
1763: -- End if;
1764: -- END LOOP; -- for dedn
1765:
1766: ----**********************************************************************

Line 1770: hr_utility.set_message(8303,'HR_374606_REPORT_HEADER');

1766: ----**********************************************************************
1767: -- Report Header for Specifying Mapping Old element to New
1768: ----**********************************************************************
1769:
1770: hr_utility.set_message(8303,'HR_374606_REPORT_HEADER');
1771: l_mesg:=l_mesg||hr_utility.get_message;
1772: fnd_file.put(fnd_file.log,l_mesg);
1773: fnd_file.new_line(fnd_file.log);
1774:

Line 1771: l_mesg:=l_mesg||hr_utility.get_message;

1767: -- Report Header for Specifying Mapping Old element to New
1768: ----**********************************************************************
1769:
1770: hr_utility.set_message(8303,'HR_374606_REPORT_HEADER');
1771: l_mesg:=l_mesg||hr_utility.get_message;
1772: fnd_file.put(fnd_file.log,l_mesg);
1773: fnd_file.new_line(fnd_file.log);
1774:
1775: ----**********************************************************************

Line 1789: hr_utility.set_message(8303,'HR_374603_ALL_ELES_NOT_CREATED');

1785: l_tot_cnt := l_earn_cnt;
1786:
1787: IF ( l_ele_cnt <> l_tot_cnt)
1788: THEN
1789: hr_utility.set_message(8303,'HR_374603_ALL_ELES_NOT_CREATED');
1790: hr_utility.set_message_token('TOTAL',l_ele_cnt);
1791: hr_utility.set_message_token('EDCOUNT',l_tot_cnt);
1792: l_mesg := l_mesg || hr_utility.get_message;
1793: hr_utility.raise_error;

Line 1790: hr_utility.set_message_token('TOTAL',l_ele_cnt);

1786:
1787: IF ( l_ele_cnt <> l_tot_cnt)
1788: THEN
1789: hr_utility.set_message(8303,'HR_374603_ALL_ELES_NOT_CREATED');
1790: hr_utility.set_message_token('TOTAL',l_ele_cnt);
1791: hr_utility.set_message_token('EDCOUNT',l_tot_cnt);
1792: l_mesg := l_mesg || hr_utility.get_message;
1793: hr_utility.raise_error;
1794: END IF;

Line 1791: hr_utility.set_message_token('EDCOUNT',l_tot_cnt);

1787: IF ( l_ele_cnt <> l_tot_cnt)
1788: THEN
1789: hr_utility.set_message(8303,'HR_374603_ALL_ELES_NOT_CREATED');
1790: hr_utility.set_message_token('TOTAL',l_ele_cnt);
1791: hr_utility.set_message_token('EDCOUNT',l_tot_cnt);
1792: l_mesg := l_mesg || hr_utility.get_message;
1793: hr_utility.raise_error;
1794: END IF;
1795: ----**********************************************************************

Line 1792: l_mesg := l_mesg || hr_utility.get_message;

1788: THEN
1789: hr_utility.set_message(8303,'HR_374603_ALL_ELES_NOT_CREATED');
1790: hr_utility.set_message_token('TOTAL',l_ele_cnt);
1791: hr_utility.set_message_token('EDCOUNT',l_tot_cnt);
1792: l_mesg := l_mesg || hr_utility.get_message;
1793: hr_utility.raise_error;
1794: END IF;
1795: ----**********************************************************************
1796: -- If all these checks are passed then conc program is successful and

Line 1793: hr_utility.raise_error;

1789: hr_utility.set_message(8303,'HR_374603_ALL_ELES_NOT_CREATED');
1790: hr_utility.set_message_token('TOTAL',l_ele_cnt);
1791: hr_utility.set_message_token('EDCOUNT',l_tot_cnt);
1792: l_mesg := l_mesg || hr_utility.get_message;
1793: hr_utility.raise_error;
1794: END IF;
1795: ----**********************************************************************
1796: -- If all these checks are passed then conc program is successful and
1797: -- also successfully compiles Formulas

Line 1975: hr_utility.trace('Entering :'||l_proc);

1971:
1972: --
1973: BEGIN
1974: --
1975: hr_utility.trace('Entering :'||l_proc);
1976: --
1977: ----**********************************************************************
1978: -- CHECK 1 :- Existence of GHR Product
1979: ----**********************************************************************

Line 1980: IF (hr_utility.chk_product_install('GHR','US') <> TRUE )

1976: --
1977: ----**********************************************************************
1978: -- CHECK 1 :- Existence of GHR Product
1979: ----**********************************************************************
1980: IF (hr_utility.chk_product_install('GHR','US') <> TRUE )
1981: THEN
1982: hr_utility.set_message(8303,'PQP_230993_FED_PROD_NOT_INSTAL');
1983:
1984: FOR c_gpn IN get_prod_name('GHR','US')

Line 1982: hr_utility.set_message(8303,'PQP_230993_FED_PROD_NOT_INSTAL');

1978: -- CHECK 1 :- Existence of GHR Product
1979: ----**********************************************************************
1980: IF (hr_utility.chk_product_install('GHR','US') <> TRUE )
1981: THEN
1982: hr_utility.set_message(8303,'PQP_230993_FED_PROD_NOT_INSTAL');
1983:
1984: FOR c_gpn IN get_prod_name('GHR','US')
1985: LOOP
1986: l_app_name := c_gpn.application_name;

Line 1989: hr_utility.set_message_token('PROD',l_app_name);

1985: LOOP
1986: l_app_name := c_gpn.application_name;
1987: END LOOP;
1988:
1989: hr_utility.set_message_token('PROD',l_app_name);
1990: l_mesg := hr_utility.get_message;
1991: fnd_file.put(fnd_file.log, l_mesg);
1992: hr_multi_message.add(p_associated_column1 => 'Y');
1993: END IF;

Line 1990: l_mesg := hr_utility.get_message;

1986: l_app_name := c_gpn.application_name;
1987: END LOOP;
1988:
1989: hr_utility.set_message_token('PROD',l_app_name);
1990: l_mesg := hr_utility.get_message;
1991: fnd_file.put(fnd_file.log, l_mesg);
1992: hr_multi_message.add(p_associated_column1 => 'Y');
1993: END IF;
1994: ----**********************************************************************

Line 1997: IF ( hr_utility.chk_product_install('PAY', 'US') <> TRUE )

1993: END IF;
1994: ----**********************************************************************
1995: -- CHECK 2 :- Existence of PAYROLL Product
1996: ----**********************************************************************
1997: IF ( hr_utility.chk_product_install('PAY', 'US') <> TRUE )
1998: THEN
1999: hr_utility.set_message(8303,'PQP_230993_FED_PROD_NOT_INSTAL');
2000:
2001: FOR c_gpn IN get_prod_name('PAY','US')

Line 1999: hr_utility.set_message(8303,'PQP_230993_FED_PROD_NOT_INSTAL');

1995: -- CHECK 2 :- Existence of PAYROLL Product
1996: ----**********************************************************************
1997: IF ( hr_utility.chk_product_install('PAY', 'US') <> TRUE )
1998: THEN
1999: hr_utility.set_message(8303,'PQP_230993_FED_PROD_NOT_INSTAL');
2000:
2001: FOR c_gpn IN get_prod_name('PAY','US')
2002: LOOP
2003: l_app_name := c_gpn.application_name;

Line 2006: hr_utility.set_message_token('PROD',l_app_name);

2002: LOOP
2003: l_app_name := c_gpn.application_name;
2004: END LOOP;
2005:
2006: hr_utility.set_message_token('PROD',l_app_name);
2007: l_mesg := l_mesg || hr_utility.get_message;
2008: fnd_file.put(fnd_file.log, l_mesg);
2009: hr_multi_message.add(p_associated_column1 => 'Y');
2010: END IF;

Line 2007: l_mesg := l_mesg || hr_utility.get_message;

2003: l_app_name := c_gpn.application_name;
2004: END LOOP;
2005:
2006: hr_utility.set_message_token('PROD',l_app_name);
2007: l_mesg := l_mesg || hr_utility.get_message;
2008: fnd_file.put(fnd_file.log, l_mesg);
2009: hr_multi_message.add(p_associated_column1 => 'Y');
2010: END IF;
2011: --**********************************************************************

Line 2014: IF (ghr_utility.is_ghr='FALSE')

2010: END IF;
2011: --**********************************************************************
2012: -- CHECK 3 :- Ensure Biz Group is Fed HR biz group.
2013: --**********************************************************************
2014: IF (ghr_utility.is_ghr='FALSE')
2015: THEN
2016: hr_utility.set_message(8303,'PQP_230995_FED_BIZ_GROUP_FALSE');
2017: l_mesg := l_mesg || hr_utility.get_message;
2018: fnd_file.put(fnd_file.log, l_mesg);

Line 2016: hr_utility.set_message(8303,'PQP_230995_FED_BIZ_GROUP_FALSE');

2012: -- CHECK 3 :- Ensure Biz Group is Fed HR biz group.
2013: --**********************************************************************
2014: IF (ghr_utility.is_ghr='FALSE')
2015: THEN
2016: hr_utility.set_message(8303,'PQP_230995_FED_BIZ_GROUP_FALSE');
2017: l_mesg := l_mesg || hr_utility.get_message;
2018: fnd_file.put(fnd_file.log, l_mesg);
2019: hr_multi_message.add(p_associated_column1 => 'Y');
2020: END IF;

Line 2017: l_mesg := l_mesg || hr_utility.get_message;

2013: --**********************************************************************
2014: IF (ghr_utility.is_ghr='FALSE')
2015: THEN
2016: hr_utility.set_message(8303,'PQP_230995_FED_BIZ_GROUP_FALSE');
2017: l_mesg := l_mesg || hr_utility.get_message;
2018: fnd_file.put(fnd_file.log, l_mesg);
2019: hr_multi_message.add(p_associated_column1 => 'Y');
2020: END IF;
2021:

Line 2032: hr_utility.set_message(8303,'PQP_230994_FED_ELE_LINK_EXISTS');

2028: p_legislation_code => 'US' ,
2029: p_bg_id => p_business_group_id);
2030: IF (l_federal_ele_lnk_flg = TRUE)
2031: THEN
2032: hr_utility.set_message(8303,'PQP_230994_FED_ELE_LINK_EXISTS');
2033: hr_utility.set_message_token('FEDERAL_ELEMENT', p_old_ele_name);
2034: l_mesg := l_mesg || hr_utility.get_message;
2035: fnd_file.put(fnd_file.log, l_mesg);
2036: hr_multi_message.add(p_associated_column1 => 'Y');

Line 2033: hr_utility.set_message_token('FEDERAL_ELEMENT', p_old_ele_name);

2029: p_bg_id => p_business_group_id);
2030: IF (l_federal_ele_lnk_flg = TRUE)
2031: THEN
2032: hr_utility.set_message(8303,'PQP_230994_FED_ELE_LINK_EXISTS');
2033: hr_utility.set_message_token('FEDERAL_ELEMENT', p_old_ele_name);
2034: l_mesg := l_mesg || hr_utility.get_message;
2035: fnd_file.put(fnd_file.log, l_mesg);
2036: hr_multi_message.add(p_associated_column1 => 'Y');
2037: END IF;

Line 2034: l_mesg := l_mesg || hr_utility.get_message;

2030: IF (l_federal_ele_lnk_flg = TRUE)
2031: THEN
2032: hr_utility.set_message(8303,'PQP_230994_FED_ELE_LINK_EXISTS');
2033: hr_utility.set_message_token('FEDERAL_ELEMENT', p_old_ele_name);
2034: l_mesg := l_mesg || hr_utility.get_message;
2035: fnd_file.put(fnd_file.log, l_mesg);
2036: hr_multi_message.add(p_associated_column1 => 'Y');
2037: END IF;
2038: --**********************************************************************

Line 2048: hr_utility.set_message(8303,'PQP_230994_FED_ELE_LINK_EXISTS');

2044: p_bg_id => p_business_group_id);
2045:
2046: IF (l_agency_ele_lnk_flg = TRUE)
2047: THEN
2048: hr_utility.set_message(8303,'PQP_230994_FED_ELE_LINK_EXISTS');
2049: hr_utility.set_message_token('FEDERAL_ELEMENT', p_new_ele_name);
2050: l_mesg := l_mesg || hr_utility.get_message;
2051: fnd_file.put(fnd_file.log, l_mesg);
2052: hr_multi_message.add(p_associated_column1 => 'Y');

Line 2049: hr_utility.set_message_token('FEDERAL_ELEMENT', p_new_ele_name);

2045:
2046: IF (l_agency_ele_lnk_flg = TRUE)
2047: THEN
2048: hr_utility.set_message(8303,'PQP_230994_FED_ELE_LINK_EXISTS');
2049: hr_utility.set_message_token('FEDERAL_ELEMENT', p_new_ele_name);
2050: l_mesg := l_mesg || hr_utility.get_message;
2051: fnd_file.put(fnd_file.log, l_mesg);
2052: hr_multi_message.add(p_associated_column1 => 'Y');
2053: END IF;

Line 2050: l_mesg := l_mesg || hr_utility.get_message;

2046: IF (l_agency_ele_lnk_flg = TRUE)
2047: THEN
2048: hr_utility.set_message(8303,'PQP_230994_FED_ELE_LINK_EXISTS');
2049: hr_utility.set_message_token('FEDERAL_ELEMENT', p_new_ele_name);
2050: l_mesg := l_mesg || hr_utility.get_message;
2051: fnd_file.put(fnd_file.log, l_mesg);
2052: hr_multi_message.add(p_associated_column1 => 'Y');
2053: END IF;
2054:

Line 2086: hr_utility.trace('Inside Federal Element type id exists');

2082: -- if old element and new element both exist then error out.
2083: -- moved the error message to here
2084: IF l_old_ele_type_id is not NULL
2085: THEN
2086: hr_utility.trace('Inside Federal Element type id exists');
2087: IF l_new_ele_type_id is not NULL
2088: THEN
2089: IF (l_agn_conf_val_id is not NULL )
2090: THEN

Line 2091: hr_utility.set_message(8303,'PQP_230008_FED_AGN_ALR_MPPD');

2087: IF l_new_ele_type_id is not NULL
2088: THEN
2089: IF (l_agn_conf_val_id is not NULL )
2090: THEN
2091: hr_utility.set_message(8303,'PQP_230008_FED_AGN_ALR_MPPD');
2092: hr_utility.set_message_token('AGENCY_ELE_NAME',p_new_ele_name);
2093:
2094: IF (l_agn_fed_ele_name = 'Basic Salary Rate') THEN
2095: -- append the pay basis to Basic Salary Rate element

Line 2092: hr_utility.set_message_token('AGENCY_ELE_NAME',p_new_ele_name);

2088: THEN
2089: IF (l_agn_conf_val_id is not NULL )
2090: THEN
2091: hr_utility.set_message(8303,'PQP_230008_FED_AGN_ALR_MPPD');
2092: hr_utility.set_message_token('AGENCY_ELE_NAME',p_new_ele_name);
2093:
2094: IF (l_agn_fed_ele_name = 'Basic Salary Rate') THEN
2095: -- append the pay basis to Basic Salary Rate element
2096: IF ( l_agn_pay_basis is not null) THEN

Line 2109: hr_utility.set_message_token('FEDERAL_ELE_NAME',l_agn_fed_ele_name);

2105: l_agn_fed_ele_name := l_agn_fed_ele_name||'('||l_pay_basis_meang||')';
2106: ELSE
2107: l_agn_fed_ele_name := l_agn_fed_ele_name;
2108: END IF;
2109: hr_utility.set_message_token('FEDERAL_ELE_NAME',l_agn_fed_ele_name);
2110: l_mesg := l_mesg||hr_utility.get_message;
2111: fnd_file.put(fnd_file.log,l_mesg);
2112: hr_multi_message.add(p_associated_column1 => 'Y');
2113: END IF;

Line 2110: l_mesg := l_mesg||hr_utility.get_message;

2106: ELSE
2107: l_agn_fed_ele_name := l_agn_fed_ele_name;
2108: END IF;
2109: hr_utility.set_message_token('FEDERAL_ELE_NAME',l_agn_fed_ele_name);
2110: l_mesg := l_mesg||hr_utility.get_message;
2111: fnd_file.put(fnd_file.log,l_mesg);
2112: hr_multi_message.add(p_associated_column1 => 'Y');
2113: END IF;
2114: END IF;

Line 2120: hr_utility.raise_error;

2116:
2117: --**********************************************************************
2118: IF (l_mesg IS NOT NULL)
2119: THEN
2120: hr_utility.raise_error;
2121: END IF;
2122: l_mesg := NULL;
2123: --****************************************************************
2124: -- Elements already Mapped

Line 2141: hr_utility.set_message(8303,'PQP_230997_FED_EXISTING_MAP');

2137: IF ((p_old_ele_name <> l_map_old_ele
2138: OR NVL(p_pay_basis,'NO')<>NVL(pcv_ele_rec.pay_basis,'NO'))
2139: AND l_new_ele_type_id <> pcv_ele_rec.ele_type_id) THEN
2140:
2141: hr_utility.set_message(8303,'PQP_230997_FED_EXISTING_MAP');
2142: l_mesgbuff1 := hr_utility.get_message;
2143: fnd_file.put(fnd_file.log,l_mesgbuff1);
2144: fnd_file.new_line(fnd_file.log);
2145:

Line 2142: l_mesgbuff1 := hr_utility.get_message;

2138: OR NVL(p_pay_basis,'NO')<>NVL(pcv_ele_rec.pay_basis,'NO'))
2139: AND l_new_ele_type_id <> pcv_ele_rec.ele_type_id) THEN
2140:
2141: hr_utility.set_message(8303,'PQP_230997_FED_EXISTING_MAP');
2142: l_mesgbuff1 := hr_utility.get_message;
2143: fnd_file.put(fnd_file.log,l_mesgbuff1);
2144: fnd_file.new_line(fnd_file.log);
2145:
2146: l_length := length(l_mesgbuff1);

Line 2154: hr_utility.set_message(8303,'PQP_230998_FED_FEDERAL_ELEMENT');

2150: fnd_file.put(fnd_file.log,'-');
2151: END LOOP;
2152:
2153: fnd_file.new_line(fnd_file.log);
2154: hr_utility.set_message(8303,'PQP_230998_FED_FEDERAL_ELEMENT');
2155: l_mesgbuff := hr_utility.get_message;
2156: fnd_file.put(fnd_file.log,rpad(l_mesgbuff,35));
2157:
2158: l_length1 := length(l_mesgbuff);

Line 2155: l_mesgbuff := hr_utility.get_message;

2151: END LOOP;
2152:
2153: fnd_file.new_line(fnd_file.log);
2154: hr_utility.set_message(8303,'PQP_230998_FED_FEDERAL_ELEMENT');
2155: l_mesgbuff := hr_utility.get_message;
2156: fnd_file.put(fnd_file.log,rpad(l_mesgbuff,35));
2157:
2158: l_length1 := length(l_mesgbuff);
2159:

Line 2160: hr_utility.set_message(8303,'PQP_230991_FED_AGENCY_ELEMENT');

2156: fnd_file.put(fnd_file.log,rpad(l_mesgbuff,35));
2157:
2158: l_length1 := length(l_mesgbuff);
2159:
2160: hr_utility.set_message(8303,'PQP_230991_FED_AGENCY_ELEMENT');
2161: l_mesgbuff := hr_utility.get_message;
2162: fnd_file.put(fnd_file.log,rpad(l_mesgbuff,35));
2163:
2164: l_length2 := length(l_mesgbuff);

Line 2161: l_mesgbuff := hr_utility.get_message;

2157:
2158: l_length1 := length(l_mesgbuff);
2159:
2160: hr_utility.set_message(8303,'PQP_230991_FED_AGENCY_ELEMENT');
2161: l_mesgbuff := hr_utility.get_message;
2162: fnd_file.put(fnd_file.log,rpad(l_mesgbuff,35));
2163:
2164: l_length2 := length(l_mesgbuff);
2165:

Line 2166: hr_utility.set_message(8303,'PQP_230999_FED_PAY_BASIS');

2162: fnd_file.put(fnd_file.log,rpad(l_mesgbuff,35));
2163:
2164: l_length2 := length(l_mesgbuff);
2165:
2166: hr_utility.set_message(8303,'PQP_230999_FED_PAY_BASIS');
2167: l_mesgbuff := hr_utility.get_message;
2168: fnd_file.put(fnd_file.log,l_mesgbuff);
2169: fnd_file.new_line(fnd_file.log);
2170:

Line 2167: l_mesgbuff := hr_utility.get_message;

2163:
2164: l_length2 := length(l_mesgbuff);
2165:
2166: hr_utility.set_message(8303,'PQP_230999_FED_PAY_BASIS');
2167: l_mesgbuff := hr_utility.get_message;
2168: fnd_file.put(fnd_file.log,l_mesgbuff);
2169: fnd_file.new_line(fnd_file.log);
2170:
2171: l_length3 := length(l_mesgbuff);

Line 2227: hr_utility.set_message(8303,'PQP_230992_FED_ELE_TOKEN');

2223: l_map_ele_type_id)
2224: LOOP
2225: l_map_new_ele := pet_ele_rec.ele_name;
2226:
2227: hr_utility.set_message(8303,'PQP_230992_FED_ELE_TOKEN');
2228: hr_utility.set_message_token('ELEMENT_NAME',rpad(l_map_old_ele,35));
2229: l_mesgbuff := hr_utility.get_message;
2230: fnd_file.put(fnd_file.log,l_mesgbuff);
2231:

Line 2228: hr_utility.set_message_token('ELEMENT_NAME',rpad(l_map_old_ele,35));

2224: LOOP
2225: l_map_new_ele := pet_ele_rec.ele_name;
2226:
2227: hr_utility.set_message(8303,'PQP_230992_FED_ELE_TOKEN');
2228: hr_utility.set_message_token('ELEMENT_NAME',rpad(l_map_old_ele,35));
2229: l_mesgbuff := hr_utility.get_message;
2230: fnd_file.put(fnd_file.log,l_mesgbuff);
2231:
2232:

Line 2229: l_mesgbuff := hr_utility.get_message;

2225: l_map_new_ele := pet_ele_rec.ele_name;
2226:
2227: hr_utility.set_message(8303,'PQP_230992_FED_ELE_TOKEN');
2228: hr_utility.set_message_token('ELEMENT_NAME',rpad(l_map_old_ele,35));
2229: l_mesgbuff := hr_utility.get_message;
2230: fnd_file.put(fnd_file.log,l_mesgbuff);
2231:
2232:
2233: hr_utility.set_message(8303,'PQP_230992_FED_ELE_TOKEN');

Line 2233: hr_utility.set_message(8303,'PQP_230992_FED_ELE_TOKEN');

2229: l_mesgbuff := hr_utility.get_message;
2230: fnd_file.put(fnd_file.log,l_mesgbuff);
2231:
2232:
2233: hr_utility.set_message(8303,'PQP_230992_FED_ELE_TOKEN');
2234: hr_utility.set_message_token('ELEMENT_NAME',rpad(l_map_new_ele,35));
2235: l_mesgbuff := hr_utility.get_message;
2236: fnd_file.put(fnd_file.log,l_mesgbuff);
2237:

Line 2234: hr_utility.set_message_token('ELEMENT_NAME',rpad(l_map_new_ele,35));

2230: fnd_file.put(fnd_file.log,l_mesgbuff);
2231:
2232:
2233: hr_utility.set_message(8303,'PQP_230992_FED_ELE_TOKEN');
2234: hr_utility.set_message_token('ELEMENT_NAME',rpad(l_map_new_ele,35));
2235: l_mesgbuff := hr_utility.get_message;
2236: fnd_file.put(fnd_file.log,l_mesgbuff);
2237:
2238: IF ( l_pay_basis is not null) THEN

Line 2235: l_mesgbuff := hr_utility.get_message;

2231:
2232:
2233: hr_utility.set_message(8303,'PQP_230992_FED_ELE_TOKEN');
2234: hr_utility.set_message_token('ELEMENT_NAME',rpad(l_map_new_ele,35));
2235: l_mesgbuff := hr_utility.get_message;
2236: fnd_file.put(fnd_file.log,l_mesgbuff);
2237:
2238: IF ( l_pay_basis is not null) THEN
2239: FOR pay_basis_meang IN c_pay_basis(l_pay_basis)

Line 2247: hr_utility.set_message(8303,'PQP_230992_FED_ELE_TOKEN');

2243: ELSE
2244: l_pay_basis_meang := NULL;
2245: END IF;
2246:
2247: hr_utility.set_message(8303,'PQP_230992_FED_ELE_TOKEN');
2248: hr_utility.set_message_token('ELEMENT_NAME',l_pay_basis_meang);
2249: l_mesgbuff := hr_utility.get_message;
2250: fnd_file.put(fnd_file.log,l_mesgbuff);
2251:

Line 2248: hr_utility.set_message_token('ELEMENT_NAME',l_pay_basis_meang);

2244: l_pay_basis_meang := NULL;
2245: END IF;
2246:
2247: hr_utility.set_message(8303,'PQP_230992_FED_ELE_TOKEN');
2248: hr_utility.set_message_token('ELEMENT_NAME',l_pay_basis_meang);
2249: l_mesgbuff := hr_utility.get_message;
2250: fnd_file.put(fnd_file.log,l_mesgbuff);
2251:
2252: fnd_file.new_line(fnd_file.log);

Line 2249: l_mesgbuff := hr_utility.get_message;

2245: END IF;
2246:
2247: hr_utility.set_message(8303,'PQP_230992_FED_ELE_TOKEN');
2248: hr_utility.set_message_token('ELEMENT_NAME',l_pay_basis_meang);
2249: l_mesgbuff := hr_utility.get_message;
2250: fnd_file.put(fnd_file.log,l_mesgbuff);
2251:
2252: fnd_file.new_line(fnd_file.log);
2253: l_mesgbuff:='';

Line 2267: hr_utility.trace('Inside Federal Element type id exists');

2263: -- *****************************************************************
2264:
2265: IF l_old_ele_type_id is not NULL
2266: THEN
2267: hr_utility.trace('Inside Federal Element type id exists');
2268: IF l_new_ele_type_id is not NULL
2269: THEN
2270: -- Commenting the code as this has been taken care of above
2271: /* IF (l_agn_conf_val_id is not NULL ) THEN

Line 2272: hr_utility.set_message(8303,'PQP_230008_FED_AGN_ALR_MPPD');

2268: IF l_new_ele_type_id is not NULL
2269: THEN
2270: -- Commenting the code as this has been taken care of above
2271: /* IF (l_agn_conf_val_id is not NULL ) THEN
2272: hr_utility.set_message(8303,'PQP_230008_FED_AGN_ALR_MPPD');
2273: hr_utility.set_message_token('AGENCY_ELE_NAME',p_new_ele_name);
2274:
2275: IF (l_agn_fed_ele_name = 'Basic Salary Rate') THEN
2276: -- append the pay basis to Basic Salary Rate element

Line 2273: hr_utility.set_message_token('AGENCY_ELE_NAME',p_new_ele_name);

2269: THEN
2270: -- Commenting the code as this has been taken care of above
2271: /* IF (l_agn_conf_val_id is not NULL ) THEN
2272: hr_utility.set_message(8303,'PQP_230008_FED_AGN_ALR_MPPD');
2273: hr_utility.set_message_token('AGENCY_ELE_NAME',p_new_ele_name);
2274:
2275: IF (l_agn_fed_ele_name = 'Basic Salary Rate') THEN
2276: -- append the pay basis to Basic Salary Rate element
2277: IF ( l_old_ele_pay_basis is not null) THEN

Line 2291: hr_utility.set_message_token('FEDERAL_ELE_NAME',l_agn_fed_ele_name);

2287: ELSE
2288: l_agn_fed_ele_name := l_agn_fed_ele_name;
2289: END IF;
2290:
2291: hr_utility.set_message_token('FEDERAL_ELE_NAME',l_agn_fed_ele_name);
2292: l_mesg := l_mesg||hr_utility.get_message;
2293: fnd_file.put(fnd_file.log,l_mesg);
2294: hr_multi_message.add(p_associated_column1 => 'Y');
2295: END IF; */

Line 2292: l_mesg := l_mesg||hr_utility.get_message;

2288: l_agn_fed_ele_name := l_agn_fed_ele_name;
2289: END IF;
2290:
2291: hr_utility.set_message_token('FEDERAL_ELE_NAME',l_agn_fed_ele_name);
2292: l_mesg := l_mesg||hr_utility.get_message;
2293: fnd_file.put(fnd_file.log,l_mesg);
2294: hr_multi_message.add(p_associated_column1 => 'Y');
2295: END IF; */
2296:

Line 2297: hr_utility.trace('Inside Agency Element type id exists');

2293: fnd_file.put(fnd_file.log,l_mesg);
2294: hr_multi_message.add(p_associated_column1 => 'Y');
2295: END IF; */
2296:
2297: hr_utility.trace('Inside Agency Element type id exists');
2298: --******************************************************************
2299: -- If the new Element picked already exists under pay_element_types_f
2300: -- under current Biz Grp and as on the passed effective date
2301: --******************************************************************

Line 2303: hr_utility.set_location('Element being updated',40);

2299: -- If the new Element picked already exists under pay_element_types_f
2300: -- under current Biz Grp and as on the passed effective date
2301: --******************************************************************
2302: l_DML := 'Updated';
2303: hr_utility.set_location('Element being updated',40);
2304: l_rec.object_version_number := l_ovn;
2305: l_rec.configuration_value_id := l_confg_val_id;
2306: l_rec.business_group_id := p_business_group_id;
2307: l_rec.pcv_information_category := 'PQP_FEDHR_ELEMENT';

Line 2337: hr_utility.set_location('Element being updated',40);

2333: -- If the Agency element already is mapped and
2334: -- the federal element does not have a row in the pcv table
2335: -- update the row with new federal element.
2336: l_DML := 'Updated';
2337: hr_utility.set_location('Element being updated',40);
2338: l_rec.object_version_number := l_agn_ovn;
2339: l_rec.configuration_value_id := l_agn_conf_val_id;
2340: l_rec.business_group_id := p_business_group_id;
2341: l_rec.pcv_information_category := 'PQP_FEDHR_ELEMENT';

Line 2366: hr_utility.set_location('Inside Federal Element type id NULL',20);

2362: -- If old element does not exist in PCV then insert a new row in PCV
2363: -- Pick the ele_type_id,effective_start_date from pay_element_types_f
2364: -- *****************************************************************
2365: l_DML := 'Inserted';
2366: hr_utility.set_location('Inside Federal Element type id NULL',20);
2367: hr_utility.set_location('Element being Inserted',30);
2368:
2369: l_rec.business_group_id := p_business_group_id;
2370: l_rec.pcv_information_category := 'PQP_FEDHR_ELEMENT';

Line 2367: hr_utility.set_location('Element being Inserted',30);

2363: -- Pick the ele_type_id,effective_start_date from pay_element_types_f
2364: -- *****************************************************************
2365: l_DML := 'Inserted';
2366: hr_utility.set_location('Inside Federal Element type id NULL',20);
2367: hr_utility.set_location('Element being Inserted',30);
2368:
2369: l_rec.business_group_id := p_business_group_id;
2370: l_rec.pcv_information_category := 'PQP_FEDHR_ELEMENT';
2371: l_rec.pcv_information1 := p_old_ele_name;

Line 2401: hr_utility.set_message(8303,'PQP_230996_FED_NEW_MAP');

2397: l_hypen := NULL;
2398: l_mesgbuff:=NULL;
2399:
2400: fnd_file.new_line(fnd_file.log);
2401: hr_utility.set_message(8303,'PQP_230996_FED_NEW_MAP');
2402: l_mesgbuff1 := hr_utility.get_message;
2403: fnd_file.put(fnd_file.log,l_mesgbuff1);
2404: fnd_file.new_line(fnd_file.log);
2405:

Line 2402: l_mesgbuff1 := hr_utility.get_message;

2398: l_mesgbuff:=NULL;
2399:
2400: fnd_file.new_line(fnd_file.log);
2401: hr_utility.set_message(8303,'PQP_230996_FED_NEW_MAP');
2402: l_mesgbuff1 := hr_utility.get_message;
2403: fnd_file.put(fnd_file.log,l_mesgbuff1);
2404: fnd_file.new_line(fnd_file.log);
2405:
2406: l_length := length(l_mesgbuff1);

Line 2414: hr_utility.set_message(8303,'PQP_230998_FED_FEDERAL_ELEMENT');

2410: fnd_file.put(fnd_file.log,'-');
2411: END LOOP;
2412: fnd_file.new_line(fnd_file.log);
2413:
2414: hr_utility.set_message(8303,'PQP_230998_FED_FEDERAL_ELEMENT');
2415: l_mesgbuff := hr_utility.get_message;
2416: fnd_file.put(fnd_file.log,rpad(l_mesgbuff,35));
2417:
2418: l_length1 := length(l_mesgbuff);

Line 2415: l_mesgbuff := hr_utility.get_message;

2411: END LOOP;
2412: fnd_file.new_line(fnd_file.log);
2413:
2414: hr_utility.set_message(8303,'PQP_230998_FED_FEDERAL_ELEMENT');
2415: l_mesgbuff := hr_utility.get_message;
2416: fnd_file.put(fnd_file.log,rpad(l_mesgbuff,35));
2417:
2418: l_length1 := length(l_mesgbuff);
2419:

Line 2420: hr_utility.set_message(8303,'PQP_230991_FED_AGENCY_ELEMENT');

2416: fnd_file.put(fnd_file.log,rpad(l_mesgbuff,35));
2417:
2418: l_length1 := length(l_mesgbuff);
2419:
2420: hr_utility.set_message(8303,'PQP_230991_FED_AGENCY_ELEMENT');
2421: l_mesgbuff := hr_utility.get_message;
2422: fnd_file.put(fnd_file.log,rpad(l_mesgbuff,35));
2423:
2424: l_length2 := length(l_mesgbuff);

Line 2421: l_mesgbuff := hr_utility.get_message;

2417:
2418: l_length1 := length(l_mesgbuff);
2419:
2420: hr_utility.set_message(8303,'PQP_230991_FED_AGENCY_ELEMENT');
2421: l_mesgbuff := hr_utility.get_message;
2422: fnd_file.put(fnd_file.log,rpad(l_mesgbuff,35));
2423:
2424: l_length2 := length(l_mesgbuff);
2425:

Line 2426: hr_utility.set_message(8303,'PQP_230999_FED_PAY_BASIS');

2422: fnd_file.put(fnd_file.log,rpad(l_mesgbuff,35));
2423:
2424: l_length2 := length(l_mesgbuff);
2425:
2426: hr_utility.set_message(8303,'PQP_230999_FED_PAY_BASIS');
2427: l_mesgbuff := hr_utility.get_message;
2428: fnd_file.put(fnd_file.log,l_mesgbuff);
2429: fnd_file.new_line(fnd_file.log);
2430:

Line 2427: l_mesgbuff := hr_utility.get_message;

2423:
2424: l_length2 := length(l_mesgbuff);
2425:
2426: hr_utility.set_message(8303,'PQP_230999_FED_PAY_BASIS');
2427: l_mesgbuff := hr_utility.get_message;
2428: fnd_file.put(fnd_file.log,l_mesgbuff);
2429: fnd_file.new_line(fnd_file.log);
2430:
2431: l_length3 := length(l_mesgbuff);

Line 2463: hr_utility.set_message(8303,'PQP_230992_FED_ELE_TOKEN');

2459: --*------------------------*
2460: --* Prints current mapping *
2461: --*------------------------*
2462:
2463: hr_utility.set_message(8303,'PQP_230992_FED_ELE_TOKEN');
2464: hr_utility.set_message_token('ELEMENT_NAME', rpad(p_old_ele_name,35));
2465: l_mesgbuff := hr_utility.get_message;
2466: fnd_file.put(fnd_file.log,l_mesgbuff);
2467:

Line 2464: hr_utility.set_message_token('ELEMENT_NAME', rpad(p_old_ele_name,35));

2460: --* Prints current mapping *
2461: --*------------------------*
2462:
2463: hr_utility.set_message(8303,'PQP_230992_FED_ELE_TOKEN');
2464: hr_utility.set_message_token('ELEMENT_NAME', rpad(p_old_ele_name,35));
2465: l_mesgbuff := hr_utility.get_message;
2466: fnd_file.put(fnd_file.log,l_mesgbuff);
2467:
2468: hr_utility.set_message(8303,'PQP_230992_FED_ELE_TOKEN');

Line 2465: l_mesgbuff := hr_utility.get_message;

2461: --*------------------------*
2462:
2463: hr_utility.set_message(8303,'PQP_230992_FED_ELE_TOKEN');
2464: hr_utility.set_message_token('ELEMENT_NAME', rpad(p_old_ele_name,35));
2465: l_mesgbuff := hr_utility.get_message;
2466: fnd_file.put(fnd_file.log,l_mesgbuff);
2467:
2468: hr_utility.set_message(8303,'PQP_230992_FED_ELE_TOKEN');
2469: hr_utility.set_message_token('ELEMENT_NAME', rpad(p_new_ele_name,35));

Line 2468: hr_utility.set_message(8303,'PQP_230992_FED_ELE_TOKEN');

2464: hr_utility.set_message_token('ELEMENT_NAME', rpad(p_old_ele_name,35));
2465: l_mesgbuff := hr_utility.get_message;
2466: fnd_file.put(fnd_file.log,l_mesgbuff);
2467:
2468: hr_utility.set_message(8303,'PQP_230992_FED_ELE_TOKEN');
2469: hr_utility.set_message_token('ELEMENT_NAME', rpad(p_new_ele_name,35));
2470: l_mesgbuff := hr_utility.get_message;
2471: fnd_file.put(fnd_file.log,l_mesgbuff);
2472:

Line 2469: hr_utility.set_message_token('ELEMENT_NAME', rpad(p_new_ele_name,35));

2465: l_mesgbuff := hr_utility.get_message;
2466: fnd_file.put(fnd_file.log,l_mesgbuff);
2467:
2468: hr_utility.set_message(8303,'PQP_230992_FED_ELE_TOKEN');
2469: hr_utility.set_message_token('ELEMENT_NAME', rpad(p_new_ele_name,35));
2470: l_mesgbuff := hr_utility.get_message;
2471: fnd_file.put(fnd_file.log,l_mesgbuff);
2472:
2473: IF ( p_pay_basis is not null) THEN

Line 2470: l_mesgbuff := hr_utility.get_message;

2466: fnd_file.put(fnd_file.log,l_mesgbuff);
2467:
2468: hr_utility.set_message(8303,'PQP_230992_FED_ELE_TOKEN');
2469: hr_utility.set_message_token('ELEMENT_NAME', rpad(p_new_ele_name,35));
2470: l_mesgbuff := hr_utility.get_message;
2471: fnd_file.put(fnd_file.log,l_mesgbuff);
2472:
2473: IF ( p_pay_basis is not null) THEN
2474: FOR pay_basis_meang IN c_pay_basis(p_pay_basis)

Line 2482: hr_utility.set_message(8303,'PQP_230992_FED_ELE_TOKEN');

2478: ELSE
2479: l_pay_basis_meang := NULL;
2480: END IF;
2481:
2482: hr_utility.set_message(8303,'PQP_230992_FED_ELE_TOKEN');
2483: hr_utility.set_message_token('ELEMENT_NAME', l_pay_basis_meang);
2484: l_mesgbuff := hr_utility.get_message;
2485: fnd_file.put(fnd_file.log,l_mesgbuff);
2486:

Line 2483: hr_utility.set_message_token('ELEMENT_NAME', l_pay_basis_meang);

2479: l_pay_basis_meang := NULL;
2480: END IF;
2481:
2482: hr_utility.set_message(8303,'PQP_230992_FED_ELE_TOKEN');
2483: hr_utility.set_message_token('ELEMENT_NAME', l_pay_basis_meang);
2484: l_mesgbuff := hr_utility.get_message;
2485: fnd_file.put(fnd_file.log,l_mesgbuff);
2486:
2487: fnd_file.new_line(fnd_file.log);

Line 2484: l_mesgbuff := hr_utility.get_message;

2480: END IF;
2481:
2482: hr_utility.set_message(8303,'PQP_230992_FED_ELE_TOKEN');
2483: hr_utility.set_message_token('ELEMENT_NAME', l_pay_basis_meang);
2484: l_mesgbuff := hr_utility.get_message;
2485: fnd_file.put(fnd_file.log,l_mesgbuff);
2486:
2487: fnd_file.new_line(fnd_file.log);
2488: --****************************************************************

Line 2489: hr_utility.trace('Leaving :'||l_proc);

2485: fnd_file.put(fnd_file.log,l_mesgbuff);
2486:
2487: fnd_file.new_line(fnd_file.log);
2488: --****************************************************************
2489: hr_utility.trace('Leaving :'||l_proc);
2490: END update_or_ins_pqp_config_vals;
2491:
2492: END pqp_fedhr_uspay_intg_pkg;