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

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

Line 2215: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

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

Line 2768: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

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

Line 2793: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

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

Line 2907: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

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

Line 2924: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

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

Line 3004: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

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

Line 3124: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

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

Line 3141: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

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

Line 3263: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

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

Line 3280: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

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

Line 3540: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

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

Line 3568: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

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

Line 3632: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

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

Line 3652: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

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