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 951: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

947: l_oipl_id := pqh_gsp_hr_to_stage.get_oipl_for_step(p_step_id => p_step_id,
948: p_effective_date => p_effective_date);
949: exception
950: when others then
951: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
952: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
953: P_TXN_ID => p_copy_entity_txn_id,
954: p_context => 'pqh_gsp_hr_to_stage.get_oipl_for_step',
955: P_MODULE_CD => 'PQH_GSP_STGBEN',

Line 1287: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

1283: /* l_message_text := 'cet id'||p_copy_entity_txn_id
1284: ||'business_group_id is '||p_business_group_id
1285: ||'effdt is '||to_char(p_effective_date,'dd-mm-RRRR')
1286: ||'bus area is '||p_business_area;
1287: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
1288: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
1289: P_TXN_ID => p_copy_entity_txn_id,
1290: p_context => 'inside_post_DATA_PUSH',
1291: P_MODULE_CD => 'PQH_GSP_STGBEN',

Line 1339: PQH_GSP_PROCESS_LOG.START_LOG

1335: raise;
1336: end;
1337: end if;
1338: if l_continue = 'Y' then
1339: PQH_GSP_PROCESS_LOG.START_LOG
1340: (P_TXN_ID => p_copy_entity_txn_id,
1341: P_TXN_NAME => l_gl_name||p_business_area,
1342: P_MODULE_CD => 'PQH_GSP_STGBEN');
1343: begin

Line 1408: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

1404: PQH_PROCESS_BATCH_LOG.END_LOG;
1405: exception
1406: when others then
1407: hr_utility.set_location('issues in writing data ',10);
1408: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
1409: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
1410: P_TXN_ID => p_copy_entity_txn_id,
1411: p_context => 'GSP_DATA_PUSH',
1412: P_MODULE_CD => 'PQH_GSP_STGBEN',

Line 1739: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

1735: ||' ceil_upd_flg is'||grd_spine.information103
1736: ||' dml_oper is'||grd_spine.dml_operation
1737: ||' ceiling step id is'||l_ceiling_step_id
1738: ||' scale is'||l_scale_id;
1739: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
1740: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
1741: P_TXN_ID => nvl(l_grade_spine_id,p_copy_entity_txn_id),
1742: P_MODULE_CD => 'PQH_GSP_STGBEN',
1743: p_context => 'GRADE_SPINE',

Line 1759: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

1755: end loop;
1756: hr_utility.set_location('out of gs loop'||l_proc,200);
1757: exception
1758: when others then
1759: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
1760: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
1761: P_TXN_ID => p_copy_entity_txn_id,
1762: P_MODULE_CD => 'PQH_GSP_STGBEN',
1763: p_context => 'GRADE-STEP',

Line 1890: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

1886: ||' point seq is '||point_rec.information253
1887: ||' point name is '||point_rec.information98
1888: ||' business_area is '||p_business_area
1889: ||' scale id is '||l_scale_id;
1890: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
1891: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
1892: P_TXN_ID => nvl(l_point_id,p_copy_entity_txn_id),
1893: P_MODULE_CD => 'PQH_GSP_STGBEN',
1894: p_context => 'POINT',

Line 1903: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

1899: end loop;
1900: hr_utility.set_location('leaving '||l_proc,100);
1901: exception
1902: when others then
1903: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
1904: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
1905: P_TXN_ID => p_copy_entity_txn_id,
1906: P_MODULE_CD => 'PQH_GSP_STGBEN',
1907: p_context => 'POINT',

Line 2018: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

2014: ||' grd_id'||l_grade_id
2015: ||' grd_ovn'||l_ovn
2016: ||' grd_def_id'||grd_rec.information221
2017: ||' grd_name'||grd_rec.information5;
2018: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
2019: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
2020: P_TXN_ID => nvl(l_grade_id,p_copy_entity_txn_id),
2021: P_MODULE_CD => 'PQH_GSP_STGBEN',
2022: p_context => 'GRADE',

Line 2031: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

2027: end loop;
2028: hr_utility.set_location('leaving '||l_proc,100);
2029: exception
2030: when others then
2031: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
2032: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
2033: P_TXN_ID => p_copy_entity_txn_id,
2034: P_MODULE_CD => 'PQH_GSP_STGBEN',
2035: p_context => 'GRADE',

Line 2145: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

2141: ||' step id is '||step_rec.information253
2142: ||' point id is '||l_point_id
2143: ||' grade_spine id is '||l_grd_sp_id
2144: ||' link flag is '||step_rec.information104;
2145: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
2146: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
2147: P_TXN_ID => nvl(l_step_id,p_copy_entity_txn_id),
2148: P_MODULE_CD => 'PQH_GSP_STGBEN',
2149: p_context => 'STEP',

Line 2159: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

2155: hr_utility.set_location('leaving '||l_proc,100);
2156: exception
2157: when others then
2158: hr_utility.set_location('issues with steps '||l_proc,420);
2159: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
2160: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
2161: P_TXN_ID => p_copy_entity_txn_id,
2162: P_MODULE_CD => 'PQH_GSP_STGBEN',
2163: p_context => 'STEP',

Line 2281: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

2277: l_message_text := 'invalid operation '||scl_rec.dml_operation
2278: ||' scale id is '||l_scale_id
2279: ||' scale ovn is '||l_scale_ovn
2280: ||' scale name'||scl_rec.information98;
2281: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
2282: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
2283: P_TXN_ID => nvl(l_scale_id,p_copy_entity_txn_id),
2284: P_MODULE_CD => 'PQH_GSP_STGBEN',
2285: p_context => 'SCALE',

Line 2295: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

2291: hr_utility.set_location('leaving '||l_proc,420);
2292: exception
2293: when others then
2294: hr_utility.set_location('issue in scale writing'||l_proc,520);
2295: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
2296: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
2297: P_TXN_ID => p_copy_entity_txn_id,
2298: P_MODULE_CD => 'PQH_GSP_STGBEN',
2299: p_context => 'SCALE',

Line 2507: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

2503: ||' payrate'||l_payrate_id
2504: ||' hrr_ovn'||l_hrr_ovn
2505: ||' rate type'||l_rate_type
2506: ||' dt mode'||hrr_rec.datetrack_mode;
2507: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
2508: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
2509: P_TXN_ID => nvl(l_hrrate_id,p_copy_entity_txn_id),
2510: P_MODULE_CD => 'PQH_GSP_STGBEN',
2511: p_context => 'GRADE_RATE',

Line 2524: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

2520: end loop;
2521: hr_utility.set_location('leaving hr rate ',420);
2522: exception
2523: when others then
2524: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
2525: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
2526: P_TXN_ID => p_copy_entity_txn_id,
2527: P_MODULE_CD => 'PQH_GSP_STGBEN',
2528: p_context => 'GRADE_RATE',