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.PSP_XMLGEN dependencies on HR_UTILITY

Line 1342: hr_utility.trace('LD Debug p_item_type_key = '||p_item_type_key);

1338: OPEN get_request_id_cur;
1339: FETCH get_request_id_cur INTO l_request_id;
1340: CLOSE get_request_id_cur;
1341:
1342: hr_utility.trace('LD Debug p_item_type_key = '||p_item_type_key);
1343:
1344: g_request_id := fnd_global.conc_request_id;
1345: l_item_type := SUBSTR(p_item_type_key, 1, INSTR(p_item_type_key, ':') - 1);
1346: l_item_key := SUBSTR(p_item_type_key, INSTR(p_item_type_key, ':') + 1, length(p_item_type_key) - 2);

Line 1348: hr_utility.trace('LD Debug l_item_type = '||l_item_type);

1344: g_request_id := fnd_global.conc_request_id;
1345: l_item_type := SUBSTR(p_item_type_key, 1, INSTR(p_item_type_key, ':') - 1);
1346: l_item_key := SUBSTR(p_item_type_key, INSTR(p_item_type_key, ':') + 1, length(p_item_type_key) - 2);
1347:
1348: hr_utility.trace('LD Debug l_item_type = '||l_item_type);
1349: hr_utility.trace('LD Debug l_item_key = '||l_item_key);
1350:
1351: l_rname := NVL(
1352: wf_engine.GetItemAttrText(itemtype => l_item_type,

Line 1349: hr_utility.trace('LD Debug l_item_key = '||l_item_key);

1345: l_item_type := SUBSTR(p_item_type_key, 1, INSTR(p_item_type_key, ':') - 1);
1346: l_item_key := SUBSTR(p_item_type_key, INSTR(p_item_type_key, ':') + 1, length(p_item_type_key) - 2);
1347:
1348: hr_utility.trace('LD Debug l_item_type = '||l_item_type);
1349: hr_utility.trace('LD Debug l_item_key = '||l_item_key);
1350:
1351: l_rname := NVL(
1352: wf_engine.GetItemAttrText(itemtype => l_item_type,
1353: itemkey => l_item_key,

Line 1356: hr_utility.trace('LD Debug l_rname = '||l_rname);

1352: wf_engine.GetItemAttrText(itemtype => l_item_type,
1353: itemkey => l_item_key,
1354: aname => 'APPROVER_ROLE_NAME'), null); -- Bug 7135471
1355:
1356: hr_utility.trace('LD Debug l_rname = '||l_rname);
1357:
1358: SELECT file_data,
1359: file_id -- Bug 7135471
1360: INTO l_document,

Line 1379: hr_utility.trace('LD Debug l_pdf_file_id = '||l_pdf_file_id);

1375: AND fad.entity_name = 'ERDETAILS');
1376:
1377: l_file_name := 'PSP_ER_' || l_item_key || '.pdf' ; -- Bug 7229792
1378:
1379: hr_utility.trace('LD Debug l_pdf_file_id = '||l_pdf_file_id);
1380: l_document_length := DBMS_LOB.getlength(l_document);
1381: DBMS_LOB.copy(p_document, l_document, l_document_length, 1, 1);
1382: p_document_type:='application/pdf; name='|| l_file_name; -- Bug 7229792
1383: