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.PQH_GSP_HR_TO_STAGE dependencies on FND_MESSAGE

Line 133: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm)||l_message_text,

129: P_TXN_ID => g_txn_id,
130: p_context => 'get_elp_for_vpf_other',
131: P_MODULE_CD => 'PQH_GSP_BENSTG',
132: P_MESSAGE_TYPE_CD => 'E',
133: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm)||l_message_text,
134: p_effective_date => p_effective_date);
135: raise;
136: end get_elp_for_vpf;
137: procedure validate_crset(p_name in varchar2,

Line 262: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

258: P_TXN_ID => g_txn_id,
259: p_context => 'get_abr_detl',
260: P_MODULE_CD => 'PQH_GSP_BENSTG',
261: P_MESSAGE_TYPE_CD => 'E',
262: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
263: p_effective_date => trunc(sysdate));
264: raise;
265: end get_abr_detl;
266: function get_abr_cer(p_copy_entity_txn_id in number,

Line 296: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

292: P_TXN_ID => g_txn_id,
293: p_context => 'get_abr_cer',
294: P_MODULE_CD => 'PQH_GSP_BENSTG',
295: P_MESSAGE_TYPE_CD => 'E',
296: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
297: p_effective_date => p_effective_date);
298: raise;
299: end;
300: elsif p_opt_cer_id is not null then

Line 324: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

320: P_TXN_ID => g_txn_id,
321: p_context => 'get_abr_cer',
322: P_MODULE_CD => 'PQH_GSP_BENSTG',
323: P_MESSAGE_TYPE_CD => 'E',
324: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
325: p_effective_date => p_effective_date);
326: raise;
327: end;
328: else

Line 360: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

356: P_TXN_ID => g_txn_id,
357: p_context => 'is_hrr_exists',
358: P_MODULE_CD => 'PQH_GSP_BENSTG',
359: P_MESSAGE_TYPE_CD => 'E',
360: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
361: p_effective_date => trunc(sysdate));
362: raise;
363: end is_hrr_exists;
364: function is_crr_exists(p_copy_entity_txn_id in number,

Line 1414: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

1410: P_TXN_ID => g_txn_id,
1411: p_context => 'vpf_to_stage_vpf_pull',
1412: P_MODULE_CD => 'PQH_GSP_BENSTG',
1413: P_MESSAGE_TYPE_CD => 'E',
1414: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
1415: p_effective_date => p_effective_date);
1416: raise;
1417: end;
1418: hr_utility.set_location('abr cer id is '||l_abr_cer_id,10);

Line 1482: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

1478: P_TXN_ID => g_txn_id,
1479: p_context => 'vpf_to_stage',
1480: P_MODULE_CD => 'PQH_GSP_BENSTG',
1481: P_MESSAGE_TYPE_CD => 'E',
1482: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
1483: p_effective_date => p_effective_date);
1484: raise;
1485: end vpf_to_stage;
1486: procedure scl_writeback(p_copy_entity_txn_id in number,

Line 1506: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

1502: P_TXN_ID => g_txn_id,
1503: p_context => 'scl_writeback',
1504: P_MODULE_CD => 'PQH_GSP_BENSTG',
1505: P_MESSAGE_TYPE_CD => 'E',
1506: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
1507: p_effective_date => trunc(sysdate));
1508: raise;
1509: end scl_writeback;
1510: -- this routine is not needed as of now, because elig-prof can be attached to

Line 1534: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

1530: P_TXN_ID => g_txn_id,
1531: p_context => 'change_parent_oipl',
1532: P_MODULE_CD => 'PQH_GSP_BENSTG',
1533: P_MESSAGE_TYPE_CD => 'E',
1534: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
1535: p_effective_date => trunc(sysdate));
1536: raise;
1537: end;
1538: end change_parent_oipl;

Line 1565: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

1561: P_TXN_ID => g_txn_id,
1562: p_context => 'change_parent_plip',
1563: P_MODULE_CD => 'PQH_GSP_BENSTG',
1564: P_MESSAGE_TYPE_CD => 'E',
1565: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
1566: p_effective_date => trunc(sysdate));
1567: raise;
1568: end;
1569: begin

Line 1586: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

1582: P_TXN_ID => g_txn_id,
1583: p_context => 'change_parent_plip-2',
1584: P_MODULE_CD => 'PQH_GSP_BENSTG',
1585: P_MESSAGE_TYPE_CD => 'E',
1586: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
1587: p_effective_date => trunc(sysdate));
1588: raise;
1589: end;
1590: end change_parent_plip;

Line 1658: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

1654: P_TXN_ID => g_txn_id,
1655: p_context => 'create_plip_row',
1656: P_MODULE_CD => 'PQH_GSP_BENSTG',
1657: P_MESSAGE_TYPE_CD => 'E',
1658: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
1659: p_effective_date => p_effective_date);
1660: raise;
1661: end;
1662: exception

Line 1671: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

1667: P_TXN_ID => g_txn_id,
1668: p_context => 'create_plip_row2',
1669: P_MODULE_CD => 'PQH_GSP_BENSTG',
1670: P_MESSAGE_TYPE_CD => 'E',
1671: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
1672: p_effective_date => p_effective_date);
1673: raise;
1674: end create_plip_row;
1675: function get_grd_start_date(p_grade_cer_id in number) return date is

Line 1715: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

1711: P_TXN_ID => g_txn_id,
1712: p_context => 'post_pull_process',
1713: P_MODULE_CD => 'PQH_GSP_BENSTG',
1714: P_MESSAGE_TYPE_CD => 'E',
1715: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
1716: p_effective_date => p_effective_date);
1717: raise;
1718: end;
1719: for scl_rec in csr_scl loop

Line 1747: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

1743: P_TXN_ID => g_txn_id,
1744: p_context => 'cep_to_stage',
1745: P_MODULE_CD => 'PQH_GSP_BENSTG',
1746: P_MESSAGE_TYPE_CD => 'E',
1747: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
1748: p_effective_date => trunc(sysdate));
1749: raise;
1750: end cep_to_stage;
1751: procedure epa_to_stage(p_epa_cer_id in number,

Line 1771: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

1767: P_TXN_ID => g_txn_id,
1768: p_context => 'epa_to_stage',
1769: P_MODULE_CD => 'PQH_GSP_BENSTG',
1770: P_MESSAGE_TYPE_CD => 'E',
1771: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
1772: p_effective_date => trunc(sysdate));
1773: raise;
1774: end epa_to_stage;
1775: procedure elp_to_stage(p_elp_cer_id in number,

Line 1816: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

1812: P_TXN_ID => g_txn_id,
1813: p_context => 'elp_to_stage',
1814: P_MODULE_CD => 'PQH_GSP_BENSTG',
1815: P_MESSAGE_TYPE_CD => 'E',
1816: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
1817: p_effective_date => trunc(sysdate));
1818: raise;
1819: end;
1820: begin

Line 1849: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

1845: P_TXN_ID => g_txn_id,
1846: p_context => 'elp_to_stage2',
1847: P_MODULE_CD => 'PQH_GSP_BENSTG',
1848: P_MESSAGE_TYPE_CD => 'E',
1849: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
1850: p_effective_date => trunc(sysdate));
1851: raise;
1852: end;
1853:

Line 1907: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

1903: P_TXN_ID => g_txn_id,
1904: p_context => 'get_co_for_abr_other',
1905: P_MODULE_CD => 'PQH_GSP_BENSTG',
1906: P_MESSAGE_TYPE_CD => 'E',
1907: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
1908: p_effective_date => trunc(sysdate));
1909: raise;
1910: end;
1911: hr_utility.set_location('rate id is '||l_abr_id,50);

Line 1932: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

1928: P_TXN_ID => g_txn_id,
1929: p_context => 'get_co_for_abr_other2',
1930: P_MODULE_CD => 'PQH_GSP_BENSTG',
1931: P_MESSAGE_TYPE_CD => 'E',
1932: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
1933: p_effective_date => trunc(sysdate));
1934: raise;
1935: end;
1936: hr_utility.set_location('rate id is '||l_abr_id,50);

Line 1966: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

1962: P_TXN_ID => g_txn_id,
1963: p_context => 'get_scl_pay_rate_other',
1964: P_MODULE_CD => 'PQH_GSP_BENSTG',
1965: P_MESSAGE_TYPE_CD => 'E',
1966: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
1967: p_effective_date => trunc(sysdate));
1968: raise;
1969: end get_scl_pay_rate;
1970: procedure get_step_details(p_grade_spine_id in number,

Line 1995: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

1991: P_TXN_ID => g_txn_id,
1992: p_context => 'get_step_details_no_data',
1993: P_MODULE_CD => 'PQH_GSP_BENSTG',
1994: P_MESSAGE_TYPE_CD => 'E',
1995: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
1996: p_effective_date => trunc(sysdate));
1997: raise;
1998: when others then
1999: hr_utility.set_location('issues in selected step',40);

Line 2006: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

2002: P_TXN_ID => g_txn_id,
2003: p_context => 'get_step_details_other',
2004: P_MODULE_CD => 'PQH_GSP_BENSTG',
2005: P_MESSAGE_TYPE_CD => 'E',
2006: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
2007: p_effective_date => trunc(sysdate));
2008: raise;
2009: end get_step_details;
2010: procedure get_grade_scale_details(p_grade_id in number,

Line 2035: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

2031: P_TXN_ID => g_txn_id,
2032: p_context => 'get_scale_details_no_data',
2033: P_MODULE_CD => 'PQH_GSP_BENSTG',
2034: P_MESSAGE_TYPE_CD => 'E',
2035: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
2036: p_effective_date => trunc(sysdate));
2037: raise;
2038: when others then
2039: hr_utility.set_location('issues in selected grade_spine',30);

Line 2046: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

2042: P_TXN_ID => g_txn_id,
2043: p_context => 'get_scale_details_other',
2044: P_MODULE_CD => 'PQH_GSP_BENSTG',
2045: P_MESSAGE_TYPE_CD => 'E',
2046: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
2047: p_effective_date => trunc(sysdate));
2048: raise;
2049: end;
2050: procedure get_point_details(p_point_id in number,

Line 2071: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

2067: P_TXN_ID => g_txn_id,
2068: p_context => 'get_point_details_no_data',
2069: P_MODULE_CD => 'PQH_GSP_BENSTG',
2070: P_MESSAGE_TYPE_CD => 'E',
2071: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
2072: p_effective_date => trunc(sysdate));
2073: raise;
2074: when others then
2075: hr_utility.set_location('issue in pulling point ',30);

Line 2082: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

2078: P_TXN_ID => g_txn_id,
2079: p_context => 'get_point_details_other',
2080: P_MODULE_CD => 'PQH_GSP_BENSTG',
2081: P_MESSAGE_TYPE_CD => 'E',
2082: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
2083: p_effective_date => trunc(sysdate));
2084: raise;
2085: end get_point_details;
2086: function get_point_for_step(p_step_id in number,

Line 2106: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

2102: P_TXN_ID => g_txn_id,
2103: p_context => 'get_point_for_step_no_data',
2104: P_MODULE_CD => 'PQH_GSP_BENSTG',
2105: P_MESSAGE_TYPE_CD => 'E',
2106: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
2107: p_effective_date => trunc(sysdate));
2108: raise;
2109: when others then
2110: hr_utility.set_location('issues in selecting step',20);

Line 2117: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

2113: P_TXN_ID => g_txn_id,
2114: p_context => 'get_point_for_step_other',
2115: P_MODULE_CD => 'PQH_GSP_BENSTG',
2116: P_MESSAGE_TYPE_CD => 'E',
2117: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
2118: p_effective_date => trunc(sysdate));
2119: raise;
2120: end get_point_for_step;
2121: function get_point_for_opt(p_option_id in number,

Line 2603: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

2599: P_TXN_ID => g_txn_id,
2600: p_context => 'get_grade_details_no_data',
2601: P_MODULE_CD => 'PQH_GSP_BENSTG',
2602: P_MESSAGE_TYPE_CD => 'E',
2603: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
2604: p_effective_date => trunc(sysdate));
2605: raise;
2606: when others then
2607: hr_utility.set_location('issue in pulling grade details ',120);

Line 2614: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

2610: P_TXN_ID => g_txn_id,
2611: p_context => 'get_grade_details_others',
2612: P_MODULE_CD => 'PQH_GSP_BENSTG',
2613: P_MESSAGE_TYPE_CD => 'E',
2614: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
2615: p_effective_date => trunc(sysdate));
2616: raise;
2617: end get_grade_details;
2618: procedure get_grd_rate_values(p_grade_id in number,

Line 2671: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

2667: P_TXN_ID => g_txn_id,
2668: p_context => 'get_grd_rate_values',
2669: P_MODULE_CD => 'PQH_GSP_BENSTG',
2670: P_MESSAGE_TYPE_CD => 'E',
2671: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
2672: p_effective_date => trunc(sysdate));
2673: raise;
2674: end get_grd_rate_values;
2675: procedure get_grd_rate_values(p_grade_id in number,

Line 2718: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

2714: P_TXN_ID => g_txn_id,
2715: p_context => 'get_grd_rate_values',
2716: P_MODULE_CD => 'PQH_GSP_BENSTG',
2717: P_MESSAGE_TYPE_CD => 'E',
2718: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
2719: p_effective_date => trunc(sysdate));
2720: raise;
2721: end get_grd_rate_values;
2722: procedure get_point_rate_values(p_effective_date in date,

Line 2767: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

2763: P_TXN_ID => g_txn_id,
2764: p_context => 'get_point_rate_values',
2765: P_MODULE_CD => 'PQH_GSP_BENSTG',
2766: P_MESSAGE_TYPE_CD => 'E',
2767: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
2768: p_effective_date => trunc(sysdate));
2769: raise;
2770: end get_point_rate_values;
2771: procedure get_point_rate_values(p_effective_date in date,

Line 2829: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

2825: P_TXN_ID => g_txn_id,
2826: p_context => 'get_point_rate_values',
2827: P_MODULE_CD => 'PQH_GSP_BENSTG',
2828: P_MESSAGE_TYPE_CD => 'E',
2829: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
2830: p_effective_date => trunc(sysdate));
2831: raise;
2832: end get_point_rate_values;
2833: procedure get_step_all_details(p_point_id in number,

Line 2896: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

2892: P_TXN_ID => g_txn_id,
2893: p_context => 'get_step_all_details',
2894: P_MODULE_CD => 'PQH_GSP_BENSTG',
2895: P_MESSAGE_TYPE_CD => 'E',
2896: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
2897: p_effective_date => trunc(sysdate));
2898: raise;
2899: end get_step_all_details;
2900: procedure get_step_details_for_oipl(p_oipl_id in number,

Line 3200: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

3196: P_TXN_ID => g_txn_id,
3197: p_context => 'hrate_to_stage',
3198: P_MODULE_CD => 'PQH_GSP_BENSTG',
3199: P_MESSAGE_TYPE_CD => 'E',
3200: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
3201: p_effective_date => p_effective_date);
3202: raise;
3203: end;
3204: end if;

Line 3632: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

3628: P_TXN_ID => g_txn_id,
3629: p_context => 'get_grade_scl_details_others',
3630: P_MODULE_CD => 'PQH_GSP_BENSTG',
3631: P_MESSAGE_TYPE_CD => 'E',
3632: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
3633: p_effective_date => trunc(sysdate));
3634: raise;
3635: end get_grd_scale_details;
3636: Procedure grade_to_plip_stage(p_grade_id in number,

Line 3779: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

3775: P_TXN_ID => g_txn_id,
3776: p_context => 'grade_to_plip_stage',
3777: P_MODULE_CD => 'PQH_GSP_BENSTG',
3778: P_MESSAGE_TYPE_CD => 'E',
3779: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
3780: p_effective_date => trunc(sysdate));
3781: raise;
3782: end grade_to_plip_stage;
3783: procedure step_to_oipl_stage(p_copy_entity_txn_id in number,

Line 3870: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

3866: P_TXN_ID => g_txn_id,
3867: p_context => 'step_to_oipl_stage',
3868: P_MODULE_CD => 'PQH_GSP_BENSTG',
3869: P_MESSAGE_TYPE_CD => 'E',
3870: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
3871: p_effective_date => trunc(sysdate));
3872: raise;
3873: end step_to_oipl_stage;
3874: function is_hrrate_for_abr_exists(p_copy_entity_txn_id in number,

Line 3906: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

3902: P_TXN_ID => g_txn_id,
3903: p_context => 'is_hrrate_for_abr_exists',
3904: P_MODULE_CD => 'PQH_GSP_BENSTG',
3905: P_MESSAGE_TYPE_CD => 'E',
3906: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
3907: p_effective_date => trunc(sysdate));
3908: raise;
3909: end is_hrrate_for_abr_exists;
3910: procedure create_hrrate_row(p_copy_entity_txn_id in number,

Line 3993: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

3989: P_TXN_ID => g_txn_id,
3990: p_context => 'create_hrrate_row_grd',
3991: P_MODULE_CD => 'PQH_GSP_BENSTG',
3992: P_MESSAGE_TYPE_CD => 'E',
3993: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
3994: p_effective_date => p_effective_date);
3995: raise;
3996: end;
3997: end if;

Line 4074: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

4070: P_TXN_ID => g_txn_id,
4071: p_context => 'create_hrrate_row_pnt',
4072: P_MODULE_CD => 'PQH_GSP_BENSTG',
4073: P_MESSAGE_TYPE_CD => 'E',
4074: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
4075: p_effective_date => p_effective_date);
4076: raise;
4077: end;
4078: end if;

Line 4567: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

4563: P_TXN_ID => g_txn_id,
4564: p_context => 'populate_pgm_hierarchy',
4565: P_MODULE_CD => 'PQH_GSP_BENSTG',
4566: P_MESSAGE_TYPE_CD => 'E',
4567: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
4568: p_effective_date => p_effective_date);
4569: raise;
4570: end;
4571: post_pull_process(p_copy_entity_txn_id => p_copy_entity_txn_id,

Line 4600: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

4596: P_TXN_ID => g_txn_id,
4597: p_context => 'is_scale_exists_in_txn',
4598: P_MODULE_CD => 'PQH_GSP_BENSTG',
4599: P_MESSAGE_TYPE_CD => 'E',
4600: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
4601: p_effective_date => trunc(sysdate));
4602: raise;
4603: end is_scale_exists_in_txn;
4604: function is_grd_exists_in_txn(p_copy_entity_txn_id in number,

Line 4628: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

4624: P_TXN_ID => g_txn_id,
4625: p_context => 'is_grd_exists_in_txn',
4626: P_MODULE_CD => 'PQH_GSP_BENSTG',
4627: P_MESSAGE_TYPE_CD => 'E',
4628: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
4629: p_effective_date => trunc(sysdate));
4630: raise;
4631: end is_grd_exists_in_txn;
4632: function is_plip_exists_in_txn(p_copy_entity_txn_id in number,

Line 4668: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

4664: P_TXN_ID => g_txn_id,
4665: p_context => 'is_plip_exists_in_txn',
4666: P_MODULE_CD => 'PQH_GSP_BENSTG',
4667: P_MESSAGE_TYPE_CD => 'E',
4668: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
4669: p_effective_date => trunc(sysdate));
4670: raise;
4671: end is_plip_exists_in_txn;
4672: function is_pl_exists_in_txn(p_copy_entity_txn_id in number,

Line 4696: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

4692: P_TXN_ID => g_txn_id,
4693: p_context => 'is_pl_exists_in_txn',
4694: P_MODULE_CD => 'PQH_GSP_BENSTG',
4695: P_MESSAGE_TYPE_CD => 'E',
4696: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
4697: p_effective_date => trunc(sysdate));
4698: raise;
4699: end is_pl_exists_in_txn;
4700: function is_ep_exists_in_txn(p_copy_entity_txn_id in number,

Line 4726: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

4722: P_TXN_ID => g_txn_id,
4723: p_context => 'is_ep_exists_in_txn',
4724: P_MODULE_CD => 'PQH_GSP_BENSTG',
4725: P_MESSAGE_TYPE_CD => 'E',
4726: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
4727: p_effective_date => trunc(sysdate));
4728: raise;
4729: end is_ep_exists_in_txn;
4730: function is_option_exists_in_txn(p_copy_entity_txn_id in number,

Line 4753: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

4749: P_TXN_ID => g_txn_id,
4750: p_context => 'is_opt_exists_in_txn',
4751: P_MODULE_CD => 'PQH_GSP_BENSTG',
4752: P_MESSAGE_TYPE_CD => 'E',
4753: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
4754: p_effective_date => trunc(sysdate));
4755: raise;
4756: end is_option_exists_in_txn;
4757: function is_point_exists_in_txn(p_copy_entity_txn_id in number,

Line 4780: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

4776: P_TXN_ID => g_txn_id,
4777: p_context => 'is_pnt_exists_in_txn',
4778: P_MODULE_CD => 'PQH_GSP_BENSTG',
4779: P_MESSAGE_TYPE_CD => 'E',
4780: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
4781: p_effective_date => trunc(sysdate));
4782: raise;
4783: end is_point_exists_in_txn;
4784: function is_step_exists_in_txn(p_copy_entity_txn_id in number,

Line 4819: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

4815: P_TXN_ID => g_txn_id,
4816: p_context => 'is_step_exists_in_txn',
4817: P_MODULE_CD => 'PQH_GSP_BENSTG',
4818: P_MESSAGE_TYPE_CD => 'E',
4819: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
4820: p_effective_date => trunc(sysdate));
4821: raise;
4822: end;
4823: else

Line 4839: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

4835: P_TXN_ID => g_txn_id,
4836: p_context => 'is_step_exists_in_txn2',
4837: P_MODULE_CD => 'PQH_GSP_BENSTG',
4838: P_MESSAGE_TYPE_CD => 'E',
4839: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
4840: p_effective_date => trunc(sysdate));
4841: raise;
4842: end is_step_exists_in_txn;
4843: procedure populate_opt_hierarchy(p_copy_entity_txn_id in number,

Line 4881: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

4877: P_TXN_ID => g_txn_id,
4878: p_context => 'populate_opt_hierarchy',
4879: P_MODULE_CD => 'PQH_GSP_BENSTG',
4880: P_MESSAGE_TYPE_CD => 'E',
4881: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
4882: p_effective_date => p_effective_date);
4883: raise;
4884: end;
4885: post_pull_process(p_copy_entity_txn_id => p_copy_entity_txn_id,

Line 5166: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

5162: P_TXN_ID => g_txn_id,
5163: p_context => 'create_oipl_row',
5164: P_MODULE_CD => 'PQH_GSP_BENSTG',
5165: P_MESSAGE_TYPE_CD => 'E',
5166: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
5167: p_effective_date => p_effective_date);
5168: raise;
5169: end create_oipl_row;
5170: procedure copy_pl_hierarchy(p_copy_entity_txn_id in number,

Line 5200: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

5196: P_TXN_ID => g_txn_id,
5197: p_context => 'copy_pl_hierarchy',
5198: P_MODULE_CD => 'PQH_GSP_BENSTG',
5199: P_MESSAGE_TYPE_CD => 'E',
5200: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
5201: p_effective_date => p_effective_date);
5202: raise;
5203: end copy_pl_hierarchy;
5204: procedure populate_pl_hierarchy(p_copy_entity_txn_id in number,

Line 5316: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

5312: P_TXN_ID => g_txn_id,
5313: p_context => 'copy_ep_hierarchy',
5314: P_MODULE_CD => 'PQH_GSP_BENSTG',
5315: P_MESSAGE_TYPE_CD => 'E',
5316: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
5317: p_effective_date => p_effective_date);
5318: raise;
5319: */
5320: end;

Line 5426: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

5422: P_TXN_ID => g_txn_id,
5423: p_context => 'create_plan_row',
5424: P_MODULE_CD => 'PQH_GSP_BENSTG',
5425: P_MESSAGE_TYPE_CD => 'E',
5426: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
5427: p_effective_date => p_effective_date);
5428: raise;
5429: end create_plan_row;
5430: procedure create_option_row(p_copy_entity_txn_id in number,

Line 5522: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

5518: P_TXN_ID => g_txn_id,
5519: p_context => 'create_opt_row',
5520: P_MODULE_CD => 'PQH_GSP_BENSTG',
5521: P_MESSAGE_TYPE_CD => 'E',
5522: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
5523: p_effective_date => p_effective_date);
5524: raise;
5525: end create_option_row;
5526: procedure populate_scale_hierarchy(p_copy_entity_txn_id in number,

Line 5608: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

5604: P_TXN_ID => g_txn_id,
5605: p_context => 'populate_scale_hierarchy',
5606: P_MODULE_CD => 'PQH_GSP_BENSTG',
5607: P_MESSAGE_TYPE_CD => 'E',
5608: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
5609: p_effective_date => p_effective_date);
5610: raise;
5611: end;
5612: elsif l_option_id is null and l_opt_cer_id is null then

Line 5637: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),

5633: P_TXN_ID => g_txn_id,
5634: p_context => 'populate_scale_hierarchy',
5635: P_MODULE_CD => 'PQH_GSP_BENSTG',
5636: P_MESSAGE_TYPE_CD => 'E',
5637: P_MESSAGE_TEXT => Nvl(fnd_Message.Get,sqlerrm),
5638: p_effective_date => p_effective_date);
5639: raise;
5640: end;
5641: end loop;