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 PQH_GSP_PROCESS_LOG

Line 17: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

13: and information1 = p_vpf_id;
14: return l_vpf_cer_id;
15: exception
16: when others then
17: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
18: (P_MASTER_TXN_ID => g_master_txn_id,
19: P_TXN_ID => g_txn_id,
20: p_context => 'get_display_vpf_cer',
21: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 116: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

112: when no_data_found then
113: l_message_text := 'no_data_found for vpf_cer is :'||p_vpf_cer_id
114: ||' cet id is '||p_copy_entity_txn_id
115: ||' effdt is '||to_char(p_effective_date,'DD-MM-RRRR');
116: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
117: (P_MASTER_TXN_ID => g_master_txn_id,
118: P_TXN_ID => g_txn_id,
119: p_context => 'get_elp_for_vpf_no_data',
120: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 127: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

123: p_effective_date => p_effective_date);
124: raise;
125: when others then
126: hr_utility.set_location('elp pull had issues',10);
127: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
128: (P_MASTER_TXN_ID => g_master_txn_id,
129: P_TXN_ID => g_txn_id,
130: p_context => 'get_elp_for_vpf_other',
131: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 256: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

252: end if;
253: exception
254: when others then
255: hr_utility.set_location('abr fetch issues '||p_abr_cer_id,11);
256: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
257: (P_MASTER_TXN_ID => g_master_txn_id,
258: P_TXN_ID => g_txn_id,
259: p_context => 'get_abr_detl',
260: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 290: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

286: hr_utility.set_location('abr cer doesnot exist',30);
287: return l_abr_cer_id;
288: when others then
289: hr_utility.set_location('issues in getting abr cer ',40);
290: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
291: (P_MASTER_TXN_ID => g_master_txn_id,
292: P_TXN_ID => g_txn_id,
293: p_context => 'get_abr_cer',
294: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 318: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

314: hr_utility.set_location('abr cer doesnot exist',30);
315: return l_abr_cer_id;
316: when others then
317: hr_utility.set_location('issues in getting abr cer ',40);
318: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
319: (P_MASTER_TXN_ID => g_master_txn_id,
320: P_TXN_ID => g_txn_id,
321: p_context => 'get_abr_cer',
322: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 354: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

350: hr_utility.set_location('hrr cer doesnot exist',30);
351: return l_hrr_cer_id;
352: when others then
353: hr_utility.set_location('issues in getting hrr cer ',40);
354: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
355: (P_MASTER_TXN_ID => g_master_txn_id,
356: P_TXN_ID => g_txn_id,
357: p_context => 'is_hrr_exists',
358: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 1408: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

1404: hr_utility.set_location('vpf is not for GSP ',10);
1405: l_continue := 'N';
1406: when others then
1407: hr_utility.set_location('issues in getting vpf ',20);
1408: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
1409: (P_MASTER_TXN_ID => g_master_txn_id,
1410: P_TXN_ID => g_txn_id,
1411: p_context => 'vpf_to_stage_vpf_pull',
1412: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 1476: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

1472: hr_utility.set_location('vpf_to_stage done',50);
1473: exception
1474: when others then
1475: hr_utility.set_location('issues in vpf_to_stage ',20);
1476: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
1477: (P_MASTER_TXN_ID => g_master_txn_id,
1478: P_TXN_ID => g_txn_id,
1479: p_context => 'vpf_to_stage',
1480: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 1500: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

1496: and (information258 = p_scale_cer_id or information255 = p_scale_id);
1497: exception
1498: when others then
1499: hr_utility.set_location('issue in updating parent ',420);
1500: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
1501: (P_MASTER_TXN_ID => g_master_txn_id,
1502: P_TXN_ID => g_txn_id,
1503: p_context => 'scl_writeback',
1504: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 1528: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

1524: hr_utility.set_location('ELP rows changed '||p_oipl_cer_id,20);
1525: exception
1526: when others then
1527: hr_utility.set_location('issue in updating parent ',420);
1528: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
1529: (P_MASTER_TXN_ID => g_master_txn_id,
1530: P_TXN_ID => g_txn_id,
1531: p_context => 'change_parent_oipl',
1532: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 1559: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

1555: hr_utility.set_location('oipl rows changed '||p_plip_cer_id,420);
1556: exception
1557: when others then
1558: hr_utility.set_location('issue in updating parent ',420);
1559: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
1560: (P_MASTER_TXN_ID => g_master_txn_id,
1561: P_TXN_ID => g_txn_id,
1562: p_context => 'change_parent_plip',
1563: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 1580: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

1576: hr_utility.set_location('ELP rows changed '||p_plip_cer_id,420);
1577: exception
1578: when others then
1579: hr_utility.set_location('issue in updating parent ',420);
1580: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
1581: (P_MASTER_TXN_ID => g_master_txn_id,
1582: P_TXN_ID => g_txn_id,
1583: p_context => 'change_parent_plip-2',
1584: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 1652: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

1648: ,p_object_version_number => p_plip_cer_ovn);
1649: exception
1650: when others then
1651: hr_utility.set_location('issue in creation cpp cer '||p_grade_id,400);
1652: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
1653: (P_MASTER_TXN_ID => g_master_txn_id,
1654: P_TXN_ID => g_txn_id,
1655: p_context => 'create_plip_row',
1656: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 1665: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

1661: end;
1662: exception
1663: when others then
1664: hr_utility.set_location('issue in cpp cer '||p_grade_id,420);
1665: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
1666: (P_MASTER_TXN_ID => g_master_txn_id,
1667: P_TXN_ID => g_txn_id,
1668: p_context => 'create_plip_row2',
1669: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 1709: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

1705: p_business_area => p_business_area);
1706: exception
1707: when others then
1708: hr_utility.set_location('issues in copying hr data on hier',30);
1709: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
1710: (P_MASTER_TXN_ID => g_master_txn_id,
1711: P_TXN_ID => g_txn_id,
1712: p_context => 'post_pull_process',
1713: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 1741: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

1737: hr_utility.set_location('cep_to_stage done',50);
1738: exception
1739: when others then
1740: hr_utility.set_location('issues in updating cep row',20);
1741: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
1742: (P_MASTER_TXN_ID => g_master_txn_id,
1743: P_TXN_ID => g_txn_id,
1744: p_context => 'cep_to_stage',
1745: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 1765: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

1761: hr_utility.set_location('epa_to_stage done',50);
1762: exception
1763: when others then
1764: hr_utility.set_location('issues in updating epa row',20);
1765: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
1766: (P_MASTER_TXN_ID => g_master_txn_id,
1767: P_TXN_ID => g_txn_id,
1768: p_context => 'epa_to_stage',
1769: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 1810: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

1806: and parent_entity_result_id = p_elp_cer_id;
1807: exception
1808: when others then
1809: hr_utility.set_location('issues in updating criteria rows ',20);
1810: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
1811: (P_MASTER_TXN_ID => g_master_txn_id,
1812: P_TXN_ID => g_txn_id,
1813: p_context => 'elp_to_stage',
1814: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 1843: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

1839: );
1840: exception
1841: when others then
1842: hr_utility.set_location('issues in updating criteria rows ',20);
1843: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
1844: (P_MASTER_TXN_ID => g_master_txn_id,
1845: P_TXN_ID => g_txn_id,
1846: p_context => 'elp_to_stage2',
1847: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 1901: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

1897: when no_data_found then
1898: hr_utility.set_location('no pl rate defined '||p_plan_id,30);
1899: when others then
1900: hr_utility.set_location('issues in getting rate ',40);
1901: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
1902: (P_MASTER_TXN_ID => g_master_txn_id,
1903: P_TXN_ID => g_txn_id,
1904: p_context => 'get_co_for_abr_other',
1905: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 1926: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

1922: when no_data_found then
1923: hr_utility.set_location('no opt rate defined '||p_opt_id,30);
1924: when others then
1925: hr_utility.set_location('issues in getting rate ',40);
1926: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
1927: (P_MASTER_TXN_ID => g_master_txn_id,
1928: P_TXN_ID => g_txn_id,
1929: p_context => 'get_co_for_abr_other2',
1930: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 1960: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

1956: hr_utility.set_location('no rate is defined '||p_scale_id,30);
1957: null;
1958: when others then
1959: hr_utility.set_location('issues in pulling scl pay rate'||p_scale_id,40);
1960: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
1961: (P_MASTER_TXN_ID => g_master_txn_id,
1962: P_TXN_ID => g_txn_id,
1963: p_context => 'get_scl_pay_rate_other',
1964: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 1989: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

1985: exception
1986: when no_data_found then
1987: hr_utility.set_location('grade scale does not have point '||p_grade_spine_id,20);
1988: hr_utility.set_location('point '||p_point_id,30);
1989: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
1990: (P_MASTER_TXN_ID => g_master_txn_id,
1991: P_TXN_ID => g_txn_id,
1992: p_context => 'get_step_details_no_data',
1993: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 2000: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

1996: p_effective_date => trunc(sysdate));
1997: raise;
1998: when others then
1999: hr_utility.set_location('issues in selected step',40);
2000: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
2001: (P_MASTER_TXN_ID => g_master_txn_id,
2002: P_TXN_ID => g_txn_id,
2003: p_context => 'get_step_details_other',
2004: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 2029: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

2025: hr_utility.set_location('grade scale id is '||p_grade_spine_id,10);
2026: exception
2027: when no_data_found then
2028: hr_utility.set_location('grade scale combination does not exist '||p_grade_id,20);
2029: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
2030: (P_MASTER_TXN_ID => g_master_txn_id,
2031: P_TXN_ID => g_txn_id,
2032: p_context => 'get_scale_details_no_data',
2033: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 2040: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

2036: p_effective_date => trunc(sysdate));
2037: raise;
2038: when others then
2039: hr_utility.set_location('issues in selected grade_spine',30);
2040: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
2041: (P_MASTER_TXN_ID => g_master_txn_id,
2042: P_TXN_ID => g_txn_id,
2043: p_context => 'get_scale_details_other',
2044: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 2065: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

2061: hr_utility.set_location('scale id is '||p_scale_id,2);
2062: exception
2063: when no_data_found then
2064: hr_utility.set_location('point does not exist',20);
2065: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
2066: (P_MASTER_TXN_ID => g_master_txn_id,
2067: P_TXN_ID => g_txn_id,
2068: p_context => 'get_point_details_no_data',
2069: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 2076: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

2072: p_effective_date => trunc(sysdate));
2073: raise;
2074: when others then
2075: hr_utility.set_location('issue in pulling point ',30);
2076: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
2077: (P_MASTER_TXN_ID => g_master_txn_id,
2078: P_TXN_ID => g_txn_id,
2079: p_context => 'get_point_details_other',
2080: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 2100: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

2096: return l_spinal_point_id;
2097: exception
2098: when no_data_found then
2099: hr_utility.set_location('invalid step '||p_step_id,15);
2100: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
2101: (P_MASTER_TXN_ID => g_master_txn_id,
2102: P_TXN_ID => g_txn_id,
2103: p_context => 'get_point_for_step_no_data',
2104: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 2111: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

2107: p_effective_date => trunc(sysdate));
2108: raise;
2109: when others then
2110: hr_utility.set_location('issues in selecting step',20);
2111: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
2112: (P_MASTER_TXN_ID => g_master_txn_id,
2113: P_TXN_ID => g_txn_id,
2114: p_context => 'get_point_for_step_other',
2115: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 2597: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

2593: hr_utility.set_location('grade name'||p_grade_name,20);
2594: exception
2595: when no_data_found then
2596: hr_utility.set_location('grade doesnot exist '||p_grade_id,35);
2597: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
2598: (P_MASTER_TXN_ID => g_master_txn_id,
2599: P_TXN_ID => g_txn_id,
2600: p_context => 'get_grade_details_no_data',
2601: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 2608: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

2604: p_effective_date => trunc(sysdate));
2605: raise;
2606: when others then
2607: hr_utility.set_location('issue in pulling grade details ',120);
2608: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
2609: (P_MASTER_TXN_ID => g_master_txn_id,
2610: P_TXN_ID => g_txn_id,
2611: p_context => 'get_grade_details_others',
2612: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 2665: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

2661: hr_utility.set_location('no rate defined or issues in getting pay rule ',140);
2662: end if;
2663: exception
2664: when others then
2665: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
2666: (P_MASTER_TXN_ID => g_master_txn_id,
2667: P_TXN_ID => g_txn_id,
2668: p_context => 'get_grd_rate_values',
2669: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 2712: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

2708: hr_utility.set_location('issue in getting bg grd pay rate ',120);
2709: end if;
2710: exception
2711: when others then
2712: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
2713: (P_MASTER_TXN_ID => g_master_txn_id,
2714: P_TXN_ID => g_txn_id,
2715: p_context => 'get_grd_rate_values',
2716: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 2761: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

2757: hr_utility.set_location('issue in getting pay rate ',130);
2758: end if;
2759: exception
2760: when others then
2761: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
2762: (P_MASTER_TXN_ID => g_master_txn_id,
2763: P_TXN_ID => g_txn_id,
2764: p_context => 'get_point_rate_values',
2765: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 2823: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

2819: hr_utility.set_location('issue in getting scl pay rate ',130);
2820: end if;
2821: exception
2822: when others then
2823: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
2824: (P_MASTER_TXN_ID => g_master_txn_id,
2825: P_TXN_ID => g_txn_id,
2826: p_context => 'get_point_rate_values',
2827: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 2890: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

2886: end if;
2887: end if;
2888: exception
2889: when others then
2890: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
2891: (P_MASTER_TXN_ID => g_master_txn_id,
2892: P_TXN_ID => g_txn_id,
2893: p_context => 'get_step_all_details',
2894: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 3194: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

3190: where copy_entity_result_id = p_abr_cer_id;
3191: exception
3192: when others then
3193: hr_utility.set_location('issue in update abr with co cer',120);
3194: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
3195: (P_MASTER_TXN_ID => g_master_txn_id,
3196: P_TXN_ID => g_txn_id,
3197: p_context => 'hrate_to_stage',
3198: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 3626: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

3622: hr_utility.set_location('no scale is linked to grade'||p_grade_id,40);
3623: null;
3624: when others then
3625: hr_utility.set_location('issues in getting scale '||p_grade_id,40);
3626: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
3627: (P_MASTER_TXN_ID => g_master_txn_id,
3628: P_TXN_ID => g_txn_id,
3629: p_context => 'get_grade_scl_details_others',
3630: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 3773: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

3769: hr_utility.set_location('leaving '||l_proc,420);
3770: exception
3771: when others then
3772: hr_utility.set_location('some issues in geting grd dtl '||l_proc,120);
3773: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
3774: (P_MASTER_TXN_ID => g_master_txn_id,
3775: P_TXN_ID => g_txn_id,
3776: p_context => 'grade_to_plip_stage',
3777: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 3864: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

3860: end if;
3861: exception
3862: when others then
3863: hr_utility.set_location('some issues in geting grd dtl '||l_proc,120);
3864: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
3865: (P_MASTER_TXN_ID => g_master_txn_id,
3866: P_TXN_ID => g_txn_id,
3867: p_context => 'step_to_oipl_stage',
3868: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 3900: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

3896: hr_utility.set_location('rows for hrrate for abr',20);
3897: return true;
3898: when others then
3899: hr_utility.set_location('issues is checking hrrate for abr',30);
3900: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
3901: (P_MASTER_TXN_ID => g_master_txn_id,
3902: P_TXN_ID => g_txn_id,
3903: p_context => 'is_hrrate_for_abr_exists',
3904: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 3987: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

3983: ,p_object_version_number => l_hrr_cer_ovn);
3984: exception
3985: when others then
3986: hr_utility.set_location('some issue in creating hrrate row ',120);
3987: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
3988: (P_MASTER_TXN_ID => g_master_txn_id,
3989: P_TXN_ID => g_txn_id,
3990: p_context => 'create_hrrate_row_grd',
3991: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 4068: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

4064: ,p_object_version_number => l_hrr_cer_ovn);
4065: exception
4066: when others then
4067: hr_utility.set_location('some issue in creating hrrate row ',120);
4068: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
4069: (P_MASTER_TXN_ID => g_master_txn_id,
4070: P_TXN_ID => g_txn_id,
4071: p_context => 'create_hrrate_row_pnt',
4072: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 4143: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

4139: ,p_object_version_number => l_abr_cer_ovn);
4140: exception
4141: when others then
4142: hr_utility.set_location('some issue in creating abr row ',120);
4143: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
4144: (P_MASTER_TXN_ID => g_master_txn_id,
4145: P_TXN_ID => g_txn_id,
4146: p_context => 'create_abr_row',
4147: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 4217: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

4213: hr_utility.set_location('scale name'||l_scale_name,20);
4214: exception
4215: when others then
4216: hr_utility.set_location('scale doesnot exist '||p_scale_id,35);
4217: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
4218: (P_MASTER_TXN_ID => g_master_txn_id,
4219: P_TXN_ID => g_txn_id,
4220: p_context => 'scale_to_stage',
4221: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 4386: PQH_GSP_PROCESS_LOG.START_LOG

4382: ,p_status => 'VIEW'
4383: ,p_object_version_number => l_cet_ovn);
4384: -- end if;
4385: hr_utility.set_location('populating pgm hier for cet '||l_cet_id,40);
4386: PQH_GSP_PROCESS_LOG.START_LOG
4387: (P_TXN_ID => p_pgm_id,
4388: P_TXN_NAME => p_pgm_name,
4389: P_MODULE_CD => 'PQH_GSP_BENSTG');
4390: g_master_txn_id := p_pgm_id;

Line 4473: PQH_GSP_PROCESS_LOG.START_LOG

4469: ,p_status => 'SFL'
4470: ,p_business_area => p_business_area
4471: ,p_object_version_number => l_cet_ovn);
4472: p_copy_entity_txn_id := l_copy_entity_txn_id;
4473: PQH_GSP_PROCESS_LOG.START_LOG
4474: (P_TXN_ID => p_copy_entity_txn_id,
4475: P_TXN_NAME => p_pgm_name,
4476: P_MODULE_CD => 'PQH_GSP_BENSTG');
4477: g_master_txn_id := p_copy_entity_txn_id;

Line 4561: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

4557: ) ;
4558: exception
4559: when others then
4560: hr_utility.set_location('issues in copying pgm hier',20);
4561: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
4562: (P_MASTER_TXN_ID => g_master_txn_id,
4563: P_TXN_ID => g_txn_id,
4564: p_context => 'populate_pgm_hierarchy',
4565: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 4594: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

4590: return l_scl_cer_id;
4591: exception
4592: when others then
4593: hr_utility.set_location('issues in checking scale ',20);
4594: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
4595: (P_MASTER_TXN_ID => g_master_txn_id,
4596: P_TXN_ID => g_txn_id,
4597: p_context => 'is_scale_exists_in_txn',
4598: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 4622: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

4618: return l_grd_cer_id;
4619: exception
4620: when others then
4621: hr_utility.set_location('issues in finding grade ',20);
4622: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
4623: (P_MASTER_TXN_ID => g_master_txn_id,
4624: P_TXN_ID => g_txn_id,
4625: p_context => 'is_grd_exists_in_txn',
4626: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 4662: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

4658: hr_utility.set_location('issues in finding plip ',30);
4659: return l_plip_cer_id;
4660: when others then
4661: hr_utility.set_location('issues in finding plip ',30);
4662: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
4663: (P_MASTER_TXN_ID => g_master_txn_id,
4664: P_TXN_ID => g_txn_id,
4665: p_context => 'is_plip_exists_in_txn',
4666: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 4690: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

4686: return l_pl_cer_id;
4687: exception
4688: when others then
4689: hr_utility.set_location('issues in finding plan ',20);
4690: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
4691: (P_MASTER_TXN_ID => g_master_txn_id,
4692: P_TXN_ID => g_txn_id,
4693: p_context => 'is_pl_exists_in_txn',
4694: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 4720: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

4716: return l_ep_cer_id;
4717: exception
4718: when others then
4719: hr_utility.set_location('issues in finding EP ',20);
4720: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
4721: (P_MASTER_TXN_ID => g_master_txn_id,
4722: P_TXN_ID => g_txn_id,
4723: p_context => 'is_ep_exists_in_txn',
4724: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 4747: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

4743: return l_opt_cer_id;
4744: exception
4745: when others then
4746: hr_utility.set_location('issues in copying opt hier',20);
4747: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
4748: (P_MASTER_TXN_ID => g_master_txn_id,
4749: P_TXN_ID => g_txn_id,
4750: p_context => 'is_opt_exists_in_txn',
4751: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 4774: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

4770: return l_pt_cer_id;
4771: exception
4772: when others then
4773: hr_utility.set_location('issues in finding point ',20);
4774: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
4775: (P_MASTER_TXN_ID => g_master_txn_id,
4776: P_TXN_ID => g_txn_id,
4777: p_context => 'is_pnt_exists_in_txn',
4778: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 4813: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

4809: hr_utility.set_location('oipl doesnot exist',20);
4810: return l_oipl_cer_id;
4811: when others then
4812: hr_utility.set_location('issues in finding point ',20);
4813: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
4814: (P_MASTER_TXN_ID => g_master_txn_id,
4815: P_TXN_ID => g_txn_id,
4816: p_context => 'is_step_exists_in_txn',
4817: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 4833: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

4829: return l_oipl_cer_id;
4830: exception
4831: when others then
4832: hr_utility.set_location('issues in finding oipl ',40);
4833: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
4834: (P_MASTER_TXN_ID => g_master_txn_id,
4835: P_TXN_ID => g_txn_id,
4836: p_context => 'is_step_exists_in_txn2',
4837: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 4875: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

4871: hr_utility.set_location('copied opt hier',20);
4872: exception
4873: when others then
4874: hr_utility.set_location('issues in copying opt hier',25);
4875: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
4876: (P_MASTER_TXN_ID => g_master_txn_id,
4877: P_TXN_ID => g_txn_id,
4878: p_context => 'populate_opt_hierarchy',
4879: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 4936: PQH_GSP_PROCESS_LOG.START_LOG

4932: begin
4933: hr_utility.set_location('populating grade'||p_grade_id,10);
4934: -- initialize message pub before trying to add grade into the ladder
4935: fnd_msg_pub.initialize; --- Bug 8365941
4936: PQH_GSP_PROCESS_LOG.START_LOG
4937: (P_TXN_ID => Nvl(p_grade_id,p_in_pl_cer_id) ,
4938: P_TXN_NAME => p_grade_name,
4939: P_MODULE_CD => 'PQH_GSP_BENSTG');
4940: g_master_txn_id := Nvl(p_grade_id, P_in_Pl_Cer_id);

Line 5160: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

5156: end;
5157: exception
5158: when others then
5159: hr_utility.set_location('issue in oipl cer '||p_point_id,420);
5160: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
5161: (P_MASTER_TXN_ID => g_master_txn_id,
5162: P_TXN_ID => g_txn_id,
5163: p_context => 'create_oipl_row',
5164: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 5194: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

5190: p_pl_cer_id := l_pl_cer_id;
5191: exception
5192: when others then
5193: hr_utility.set_location('issues in copying pl hier',25);
5194: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
5195: (P_MASTER_TXN_ID => g_master_txn_id,
5196: P_TXN_ID => g_txn_id,
5197: p_context => 'copy_pl_hierarchy',
5198: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 5278: PQH_GSP_PROCESS_LOG.START_LOG

5274: l_start_cer number;
5275: l_parent_cer_id number;
5276: begin
5277: -- a elig-prof can be in system more than once, hence not having the check of existence
5278: PQH_GSP_PROCESS_LOG.START_LOG
5279: (P_TXN_ID => p_ep_id,
5280: P_TXN_NAME => 'ELP_id : '||p_ep_id,
5281: P_MODULE_CD => 'PQH_GSP_BENSTG');
5282: g_master_txn_id := p_ep_id;

Line 5310: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

5306: /*
5307: exception
5308: when others then
5309: hr_utility.set_location('issues in copying ep hier',25);
5310: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
5311: (P_MASTER_TXN_ID => g_master_txn_id,
5312: P_TXN_ID => g_txn_id,
5313: p_context => 'copy_ep_hierarchy',
5314: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 5420: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

5416: end;
5417: exception
5418: when others then
5419: hr_utility.set_location('issue in pln cer '||p_grade_id,420);
5420: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
5421: (P_MASTER_TXN_ID => g_master_txn_id,
5422: P_TXN_ID => g_txn_id,
5423: p_context => 'create_plan_row',
5424: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 5516: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

5512: end if;
5513: exception
5514: when others then
5515: hr_utility.set_location('issue in opt cer '||p_point_id,420);
5516: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
5517: (P_MASTER_TXN_ID => g_master_txn_id,
5518: P_TXN_ID => g_txn_id,
5519: p_context => 'create_opt_row',
5520: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 5557: PQH_GSP_PROCESS_LOG.START_LOG

5553: -- create scale if it doesnot exist in staging area.
5554: p_scale_cer_id := is_scale_exists_in_txn(p_copy_entity_txn_id => p_copy_entity_txn_id,
5555: p_scale_id => p_scale_id);
5556: If g_txn_id is NULL Then
5557: PQH_GSP_PROCESS_LOG.START_LOG
5558: (P_TXN_ID => P_Scale_id,
5559: P_TXN_NAME => 'SCALE',
5560: P_MODULE_CD => 'PQH_GSP_BENSTG');
5561: g_master_txn_id := P_Scale_id;

Line 5602: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

5598: hr_utility.set_location('opt hier copy done',39);
5599: exception
5600: when others then
5601: hr_utility.set_location('issues in copying opt hier',40);
5602: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
5603: (P_MASTER_TXN_ID => g_master_txn_id,
5604: P_TXN_ID => g_txn_id,
5605: p_context => 'populate_scale_hierarchy',
5606: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 5631: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

5627: end if;
5628: exception
5629: when others then
5630: hr_utility.set_location('issues in getting opt ',25);
5631: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
5632: (P_MASTER_TXN_ID => g_master_txn_id,
5633: P_TXN_ID => g_txn_id,
5634: p_context => 'populate_scale_hierarchy',
5635: P_MODULE_CD => 'PQH_GSP_BENSTG',

Line 5671: PQH_GSP_PROCESS_LOG.START_LOG

5667: l_grd_st_dt date;
5668: begin
5669: -- start the process_log for rate pull
5670: If g_txn_id is NULL Then
5671: PQH_GSP_PROCESS_LOG.START_LOG
5672: (P_TXN_ID => p_payrate_id,
5673: P_TXN_NAME => 'pull_pay_rate',
5674: P_MODULE_CD => 'PQH_GSP_BENSTG');
5675: g_master_txn_id := P_payrate_id;