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 1334: hr_utility.trace('LD Debug p_item_type_key = '||p_item_type_key);

1330: OPEN get_request_id_cur;
1331: FETCH get_request_id_cur INTO l_request_id;
1332: CLOSE get_request_id_cur;
1333:
1334: hr_utility.trace('LD Debug p_item_type_key = '||p_item_type_key);
1335:
1336: g_request_id := fnd_global.conc_request_id;
1337: l_item_type := SUBSTR(p_item_type_key, 1, INSTR(p_item_type_key, ':') - 1);
1338: l_item_key := SUBSTR(p_item_type_key, INSTR(p_item_type_key, ':') + 1, length(p_item_type_key) - 2);

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

1336: g_request_id := fnd_global.conc_request_id;
1337: l_item_type := SUBSTR(p_item_type_key, 1, INSTR(p_item_type_key, ':') - 1);
1338: l_item_key := SUBSTR(p_item_type_key, INSTR(p_item_type_key, ':') + 1, length(p_item_type_key) - 2);
1339:
1340: hr_utility.trace('LD Debug l_item_type = '||l_item_type);
1341: hr_utility.trace('LD Debug l_item_key = '||l_item_key);
1342:
1343: l_rname := NVL(
1344: wf_engine.GetItemAttrText(itemtype => l_item_type,

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

1337: l_item_type := SUBSTR(p_item_type_key, 1, INSTR(p_item_type_key, ':') - 1);
1338: l_item_key := SUBSTR(p_item_type_key, INSTR(p_item_type_key, ':') + 1, length(p_item_type_key) - 2);
1339:
1340: hr_utility.trace('LD Debug l_item_type = '||l_item_type);
1341: hr_utility.trace('LD Debug l_item_key = '||l_item_key);
1342:
1343: l_rname := NVL(
1344: wf_engine.GetItemAttrText(itemtype => l_item_type,
1345: itemkey => l_item_key,

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

1344: wf_engine.GetItemAttrText(itemtype => l_item_type,
1345: itemkey => l_item_key,
1346: aname => 'APPROVER_ROLE_NAME'), null); -- Bug 7135471
1347:
1348: hr_utility.trace('LD Debug l_rname = '||l_rname);
1349:
1350: SELECT file_data,
1351: file_id -- Bug 7135471
1352: INTO l_document,

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

1367: AND fad.entity_name = 'ERDETAILS');
1368:
1369: l_file_name := 'PSP_ER_' || l_item_key || '.pdf' ; -- Bug 7229792
1370:
1371: hr_utility.trace('LD Debug l_pdf_file_id = '||l_pdf_file_id);
1372: l_document_length := DBMS_LOB.getlength(l_document);
1373: DBMS_LOB.copy(p_document, l_document, l_document_length, 1, 1);
1374: p_document_type:='application/pdf; name='|| l_file_name; -- Bug 7229792
1375: