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_STAGE_TO_HR dependencies on PQH_GSP_PROCESS_LOG

Line 990: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

986: l_oipl_id := pqh_gsp_hr_to_stage.get_oipl_for_step(p_step_id => p_step_id,
987: p_effective_date => p_effective_date);
988: exception
989: when others then
990: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
991: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
992: P_TXN_ID => p_copy_entity_txn_id,
993: p_context => 'pqh_gsp_hr_to_stage.get_oipl_for_step',
994: P_MODULE_CD => 'PQH_GSP_STGBEN',

Line 1326: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

1322: /* l_message_text := 'cet id'||p_copy_entity_txn_id
1323: ||'business_group_id is '||p_business_group_id
1324: ||'effdt is '||to_char(p_effective_date,'dd-mm-RRRR')
1325: ||'bus area is '||p_business_area;
1326: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
1327: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
1328: P_TXN_ID => p_copy_entity_txn_id,
1329: p_context => 'inside_post_DATA_PUSH',
1330: P_MODULE_CD => 'PQH_GSP_STGBEN',

Line 1378: PQH_GSP_PROCESS_LOG.START_LOG

1374: raise;
1375: end;
1376: end if;
1377: if l_continue = 'Y' then
1378: PQH_GSP_PROCESS_LOG.START_LOG
1379: (P_TXN_ID => p_copy_entity_txn_id,
1380: P_TXN_NAME => l_gl_name||p_business_area,
1381: P_MODULE_CD => 'PQH_GSP_STGBEN');
1382: begin

Line 1447: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

1443: PQH_PROCESS_BATCH_LOG.END_LOG;
1444: exception
1445: when others then
1446: hr_utility.set_location('issues in writing data ',10);
1447: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
1448: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
1449: P_TXN_ID => p_copy_entity_txn_id,
1450: p_context => 'GSP_DATA_PUSH',
1451: P_MODULE_CD => 'PQH_GSP_STGBEN',

Line 1778: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

1774: ||' ceil_upd_flg is'||grd_spine.information103
1775: ||' dml_oper is'||grd_spine.dml_operation
1776: ||' ceiling step id is'||l_ceiling_step_id
1777: ||' scale is'||l_scale_id;
1778: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
1779: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
1780: P_TXN_ID => nvl(l_grade_spine_id,p_copy_entity_txn_id),
1781: P_MODULE_CD => 'PQH_GSP_STGBEN',
1782: p_context => 'GRADE_SPINE',

Line 1798: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

1794: end loop;
1795: hr_utility.set_location('out of gs loop'||l_proc,200);
1796: exception
1797: when others then
1798: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
1799: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
1800: P_TXN_ID => p_copy_entity_txn_id,
1801: P_MODULE_CD => 'PQH_GSP_STGBEN',
1802: p_context => 'GRADE-STEP',

Line 1930: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

1926: ||' point seq is '||point_rec.information253
1927: ||' point name is '||point_rec.information98
1928: ||' business_area is '||p_business_area
1929: ||' scale id is '||l_scale_id;
1930: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
1931: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
1932: P_TXN_ID => nvl(l_point_id,p_copy_entity_txn_id),
1933: P_MODULE_CD => 'PQH_GSP_STGBEN',
1934: p_context => 'POINT',

Line 1943: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

1939: end loop;
1940: hr_utility.set_location('leaving '||l_proc,100);
1941: exception
1942: when others then
1943: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
1944: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
1945: P_TXN_ID => p_copy_entity_txn_id,
1946: P_MODULE_CD => 'PQH_GSP_STGBEN',
1947: p_context => 'POINT',

Line 2058: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

2054: ||' grd_id'||l_grade_id
2055: ||' grd_ovn'||l_ovn
2056: ||' grd_def_id'||grd_rec.information221
2057: ||' grd_name'||grd_rec.information5;
2058: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
2059: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
2060: P_TXN_ID => nvl(l_grade_id,p_copy_entity_txn_id),
2061: P_MODULE_CD => 'PQH_GSP_STGBEN',
2062: p_context => 'GRADE',

Line 2071: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

2067: end loop;
2068: hr_utility.set_location('leaving '||l_proc,100);
2069: exception
2070: when others then
2071: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
2072: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
2073: P_TXN_ID => p_copy_entity_txn_id,
2074: P_MODULE_CD => 'PQH_GSP_STGBEN',
2075: p_context => 'GRADE',

Line 2185: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

2181: ||' step id is '||step_rec.information253
2182: ||' point id is '||l_point_id
2183: ||' grade_spine id is '||l_grd_sp_id
2184: ||' link flag is '||step_rec.information104;
2185: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
2186: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
2187: P_TXN_ID => nvl(l_step_id,p_copy_entity_txn_id),
2188: P_MODULE_CD => 'PQH_GSP_STGBEN',
2189: p_context => 'STEP',

Line 2199: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

2195: hr_utility.set_location('leaving '||l_proc,100);
2196: exception
2197: when others then
2198: hr_utility.set_location('issues with steps '||l_proc,420);
2199: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
2200: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
2201: P_TXN_ID => p_copy_entity_txn_id,
2202: P_MODULE_CD => 'PQH_GSP_STGBEN',
2203: p_context => 'STEP',

Line 2322: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

2318: l_message_text := 'invalid operation '||scl_rec.dml_operation
2319: ||' scale id is '||l_scale_id
2320: ||' scale ovn is '||l_scale_ovn
2321: ||' scale name'||scl_rec.information98;
2322: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
2323: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
2324: P_TXN_ID => nvl(l_scale_id,p_copy_entity_txn_id),
2325: P_MODULE_CD => 'PQH_GSP_STGBEN',
2326: p_context => 'SCALE',

Line 2336: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

2332: hr_utility.set_location('leaving '||l_proc,420);
2333: exception
2334: when others then
2335: hr_utility.set_location('issue in scale writing'||l_proc,520);
2336: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
2337: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
2338: P_TXN_ID => p_copy_entity_txn_id,
2339: P_MODULE_CD => 'PQH_GSP_STGBEN',
2340: p_context => 'SCALE',

Line 2548: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

2544: ||' payrate'||l_payrate_id
2545: ||' hrr_ovn'||l_hrr_ovn
2546: ||' rate type'||l_rate_type
2547: ||' dt mode'||hrr_rec.datetrack_mode;
2548: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
2549: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
2550: P_TXN_ID => nvl(l_hrrate_id,p_copy_entity_txn_id),
2551: P_MODULE_CD => 'PQH_GSP_STGBEN',
2552: p_context => 'GRADE_RATE',

Line 2565: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

2561: end loop;
2562: hr_utility.set_location('leaving hr rate ',420);
2563: exception
2564: when others then
2565: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
2566: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
2567: P_TXN_ID => p_copy_entity_txn_id,
2568: P_MODULE_CD => 'PQH_GSP_STGBEN',
2569: p_context => 'GRADE_RATE',