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

Line 667: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

663: and p_effective_date between effective_start_date and effective_end_date;
664: hr_utility.set_location('pet is'||l_pet_id,2);
665: exception
666: when others then
667: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
668: (P_MASTER_TXN_ID => p_cet_id,
669: P_TXN_ID => p_cet_id,
670: P_MODULE_CD => 'PQH_GSP_STGBEN',
671: p_context => 'UPD_LE_sel_pet',

Line 692: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

688: and p_effective_date between effective_start_date and effective_end_date;
689: hr_utility.set_location('prog le enrl updated ',4);
690: exception
691: when others then
692: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
693: (P_MASTER_TXN_ID => p_cet_id,
694: P_TXN_ID => p_cet_id,
695: P_MODULE_CD => 'PQH_GSP_STGBEN',
696: p_context => 'UPD_LE',

Line 717: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

713: and ler_id = l_ler_id
714: and p_effective_date between effective_start_date and effective_end_date;
715: exception
716: when others then
717: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
718: (P_MASTER_TXN_ID => p_cet_id,
719: P_TXN_ID => p_cet_id,
720: P_MODULE_CD => 'PQH_GSP_STGBEN',
721: p_context => 'UPD_LE',

Line 1189: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

1185: ||' opt id is '||l_opt_id
1186: ||' opt name is '||l_opt_name
1187: ||' opt ovn is '||l_ovn
1188: ||' point id is '||r_opt.information257;
1189: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
1190: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
1191: P_TXN_ID => nvl(l_opt_id,p_copy_entity_txn_id),
1192: P_MODULE_CD => 'PQH_GSP_STGBEN',
1193: p_context => 'OPT',

Line 1206: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

1202: end loop;
1203: hr_utility.set_location('leaving '||l_proc,100);
1204: exception
1205: when others then
1206: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
1207: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
1208: P_TXN_ID => nvl(l_opt_id,p_copy_entity_txn_id),
1209: P_MODULE_CD => 'PQH_GSP_STGBEN',
1210: p_context => 'OPT',

Line 1455: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

1451: l_message_text := 'invalid dml_oper is'||r_pln.dml_operation
1452: ||' pl_id is'||l_pl_id
1453: ||' pl_ovn is'||l_ovn
1454: ||' grd_id is'||r_pln.information294;
1455: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
1456: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
1457: P_TXN_ID => nvl(l_pl_id,p_copy_entity_txn_id),
1458: P_MODULE_CD => 'PQH_GSP_STGBEN',
1459: p_context => 'PLN',

Line 1472: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

1468: end loop;
1469: hr_utility.set_location('leaving '||l_proc,100);
1470: exception
1471: when others then
1472: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
1473: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
1474: P_TXN_ID => p_copy_entity_txn_id,
1475: P_MODULE_CD => 'PQH_GSP_STGBEN',
1476: p_context => 'PLN',

Line 1757: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

1753: l_message_text := 'invalid dml_oper'||r_pgm.dml_operation
1754: ||' pgm_ovn:'||l_ovn
1755: ||' pgm_dt_mode:'||l_dt_mode
1756: ||' for pgm_id:'||l_pgm_id;
1757: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
1758: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
1759: P_TXN_ID => nvl(l_pgm_id,p_copy_entity_txn_id),
1760: P_MODULE_CD => 'PQH_GSP_STGBEN',
1761: p_context => 'PGM',

Line 1770: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

1766: end loop;
1767: hr_utility.set_location('leaving '||l_proc,100);
1768: exception
1769: when others then
1770: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
1771: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
1772: P_TXN_ID => p_copy_entity_txn_id,
1773: P_MODULE_CD => 'PQH_GSP_STGBEN',
1774: p_context => 'PGM',

Line 1953: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

1949: ||' oipl_id is'||l_oipl_id
1950: ||' pl_id is'||l_pl_id
1951: ||' opt_id is'||l_opt_id
1952: ||' ovn is'||l_ovn;
1953: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
1954: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
1955: P_TXN_ID => nvl(l_oipl_id,p_copy_entity_txn_id),
1956: P_MODULE_CD => 'PQH_GSP_STGBEN',
1957: p_context => 'OIPL',

Line 1966: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

1962: end loop;
1963: hr_utility.set_location('leaving '||l_proc,100);
1964: exception
1965: when others then
1966: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
1967: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
1968: P_TXN_ID => p_copy_entity_txn_id,
1969: P_MODULE_CD => 'PQH_GSP_STGBEN',
1970: p_context => 'OIPL',

Line 2199: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

2195: ||' plip_id: '||l_plip_id
2196: ||' ovn: '||l_ovn
2197: ||' pgm_id: '||l_pgm_id
2198: ||' pl_id: '||l_pl_id;
2199: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
2200: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
2201: P_TXN_ID => nvl(l_plip_id,p_copy_entity_txn_id),
2202: P_MODULE_CD => 'PQH_GSP_STGBEN',
2203: p_context => 'PLIP',

Line 2216: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

2212: end loop;
2213: hr_utility.set_location('leaving '||l_proc,100);
2214: exception
2215: when others then
2216: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
2217: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
2218: P_TXN_ID => p_copy_entity_txn_id,
2219: P_MODULE_CD => 'PQH_GSP_STGBEN',
2220: p_context => 'PLIP',

Line 2769: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

2765: else
2766: l_message_text := 'invalid dml_oper'||l_dml_operation
2767: ||' elp_ovn'||l_elp_ovn
2768: ||' elp_id'||l_elp_id;
2769: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
2770: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
2771: P_TXN_ID => nvl(l_elp_id,p_copy_entity_txn_id),
2772: P_MODULE_CD => 'PQH_GSP_STGBEN',
2773: p_context => 'ELP',

Line 2794: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

2790: end loop;
2791: hr_utility.set_location('leaving '||l_proc,100);
2792: exception
2793: when others then
2794: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
2795: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
2796: P_TXN_ID => p_copy_entity_txn_id,
2797: P_MODULE_CD => 'PQH_GSP_STGBEN',
2798: p_context => 'ELP',

Line 2908: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

2904: l_message_text := 'invalid dml_oper'||r_cep.dml_operation
2905: ||' cep_id '||l_cep_id
2906: ||' cep_ovn '||l_ovn
2907: ||' epa_id '||l_epa_id;
2908: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
2909: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
2910: P_TXN_ID => nvl(l_cep_id,p_copy_entity_txn_id),
2911: P_MODULE_CD => 'PQH_GSP_STGBEN',
2912: p_context => 'CEP',

Line 2925: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

2921: end loop;
2922: hr_utility.set_location('leaving '||l_proc,100);
2923: exception
2924: when others then
2925: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
2926: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
2927: P_TXN_ID => p_copy_entity_txn_id,
2928: P_MODULE_CD => 'PQH_GSP_STGBEN',
2929: p_context => 'CEP',

Line 3005: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

3001: ||' abr id is '||l_abr_id
3002: ||' hrr id is '||r_abr.information266
3003: ||' abr ovn is '||l_ovn
3004: ||' opt id is '||r_ABR.INFORMATION247;
3005: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
3006: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
3007: P_TXN_ID => nvl(l_abr_id,p_copy_entity_txn_id),
3008: P_MODULE_CD => 'PQH_GSP_STGBEN',
3009: p_context => 'ABR',

Line 3125: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

3121: ||' abr id is '||l_abr_id
3122: ||' hrr id is '||r_abr.information266
3123: ||' abr ovn is '||l_ovn
3124: ||' opt id is '||r_ABR.INFORMATION247;
3125: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
3126: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
3127: P_TXN_ID => nvl(l_abr_id,p_copy_entity_txn_id),
3128: P_MODULE_CD => 'PQH_GSP_STGBEN',
3129: p_context => 'ABR',

Line 3142: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

3138: end loop;
3139: hr_utility.set_location('leaving '||l_proc,100);
3140: exception
3141: when others then
3142: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
3143: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
3144: P_TXN_ID => p_copy_entity_txn_id,
3145: P_MODULE_CD => 'PQH_GSP_STGBEN',
3146: p_context => 'ABR',

Line 3264: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

3260: ||' epa_id is'||l_epa_id
3261: ||' epa_ovn is'||l_ovn
3262: ||' l_tab is'||l_tab
3263: ||' l_pk is'||l_pk;
3264: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
3265: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
3266: P_TXN_ID => nvl(l_epa_id,p_copy_entity_txn_id),
3267: P_MODULE_CD => 'PQH_GSP_STGBEN',
3268: p_context => 'EPA',

Line 3281: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

3277: end loop;
3278: hr_utility.set_location('leaving '||l_proc,100);
3279: exception
3280: when others then
3281: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
3282: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
3283: P_TXN_ID => p_copy_entity_txn_id,
3284: P_MODULE_CD => 'PQH_GSP_STGBEN',
3285: p_context => 'EPA',

Line 3541: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

3537: l_message_text := 'fks not there for creating vep row'
3538: ||' elp_id is '||l_elp_id
3539: ||' effdt is '||to_char(p_effective_date,'DD/MM/RRRR')
3540: ||' vpf id is '||l_crr_id;
3541: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
3542: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
3543: P_TXN_ID => nvl(l_crr_id,p_copy_entity_txn_id),
3544: P_MODULE_CD => 'PQH_GSP_STGBEN',
3545: p_context => 'VPF',

Line 3569: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

3565: ||' elp_id is '||l_elp_id
3566: ||' GL effdt is '||to_char(p_effective_date,'DD/MM/RRRR')
3567: ||' VR effdt is '||to_char(l_effective_date,'DD/MM/RRRR')
3568: ||' vpf id is '||l_crr_id;
3569: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
3570: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
3571: P_TXN_ID => nvl(l_crr_id,p_copy_entity_txn_id),
3572: P_MODULE_CD => 'PQH_GSP_STGBEN',
3573: p_context => 'VPF',

Line 3633: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

3629: ||' crr_ovn is '||l_crr_ovn
3630: ||' crr_name is '||l_crr_name
3631: ||' val is '||crr_rec.INFORMATION293
3632: ||' crr_id is '||l_crr_id;
3633: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
3634: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
3635: P_TXN_ID => nvl(l_crr_id,p_copy_entity_txn_id),
3636: P_MODULE_CD => 'PQH_GSP_STGBEN',
3637: p_context => 'VPF',

Line 3653: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

3649: end loop;
3650: hr_utility.set_location('leaving '||l_proc,100);
3651: exception
3652: when others then
3653: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
3654: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
3655: P_TXN_ID => p_copy_entity_txn_id,
3656: P_MODULE_CD => 'PQH_GSP_STGBEN',
3657: p_context => 'VPF',