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

Line 102: hr_utility.trace('media_id:'||gt_doc(i).media_id);

98: IF gt_doc(i).post_state = 0 THEN --- Post state is Insert
99: l_document_id := NULL;
100: l_rowid := NULL;
101: BEGIN
102: hr_utility.trace('media_id:'||gt_doc(i).media_id);
103: hr_utility.trace('file name:'||gt_doc(i).file_name);
104: l_media_id := gt_doc(i).media_id;
105: fnd_documents_pkg.Insert_Row(X_Rowid => l_rowid,
106: X_document_id => l_document_id,

Line 103: hr_utility.trace('file name:'||gt_doc(i).file_name);

99: l_document_id := NULL;
100: l_rowid := NULL;
101: BEGIN
102: hr_utility.trace('media_id:'||gt_doc(i).media_id);
103: hr_utility.trace('file name:'||gt_doc(i).file_name);
104: l_media_id := gt_doc(i).media_id;
105: fnd_documents_pkg.Insert_Row(X_Rowid => l_rowid,
106: X_document_id => l_document_id,
107: X_creation_date => gt_doc(i).creation_date,

Line 123: hr_utility.trace('doc_id created :'||l_document_id);

119: X_file_name => gt_doc(i).file_name,
120: X_media_id => l_media_id,
121: X_create_doc => 'N',
122: X_title => gt_doc(i).title);
123: hr_utility.trace('doc_id created :'||l_document_id);
124: IF gt_doc(i).datatype_id = 1 THEN --- short description
125: IF gt_shorttext.COUNT > 0 THEN --- count check
126: FOR j IN gt_shorttext.FIRST..gt_shorttext.LAST
127: LOOP

Line 128: HR_UTILITY.TRACE('mEDIA ID FROM SHORT TEXT: '||gt_shorttext(j).media_id ||'-'||gt_doc(i).media_id);

124: IF gt_doc(i).datatype_id = 1 THEN --- short description
125: IF gt_shorttext.COUNT > 0 THEN --- count check
126: FOR j IN gt_shorttext.FIRST..gt_shorttext.LAST
127: LOOP
128: HR_UTILITY.TRACE('mEDIA ID FROM SHORT TEXT: '||gt_shorttext(j).media_id ||'-'||gt_doc(i).media_id);
129: IF gt_doc(i).media_id = gt_shorttext(j).media_id THEN -- insert only if the media id matches
130: HR_UTILITY.TRACE('INSERTING MEDIA ID: '||GT_SHORTTEXT(J).MEDIA_ID);
131: INSERT INTO FND_DOCUMENTS_SHORT_TEXT
132: (

Line 130: HR_UTILITY.TRACE('INSERTING MEDIA ID: '||GT_SHORTTEXT(J).MEDIA_ID);

126: FOR j IN gt_shorttext.FIRST..gt_shorttext.LAST
127: LOOP
128: HR_UTILITY.TRACE('mEDIA ID FROM SHORT TEXT: '||gt_shorttext(j).media_id ||'-'||gt_doc(i).media_id);
129: IF gt_doc(i).media_id = gt_shorttext(j).media_id THEN -- insert only if the media id matches
130: HR_UTILITY.TRACE('INSERTING MEDIA ID: '||GT_SHORTTEXT(J).MEDIA_ID);
131: INSERT INTO FND_DOCUMENTS_SHORT_TEXT
132: (
133: media_id
134: ,short_text

Line 221: hr_utility.trace('Error in Commit_attachments');

217: --
218: END IF;
219: ---
220: EXCEPTION WHEN OTHERS THEN
221: hr_utility.trace('Error in Commit_attachments');
222: hr_utility.trace(sqlerrm);
223: END commit_attachments;
224: --
225: PROCEDURE process_attachments(p_transaction_id IN NUMBER) IS

Line 222: hr_utility.trace(sqlerrm);

218: END IF;
219: ---
220: EXCEPTION WHEN OTHERS THEN
221: hr_utility.trace('Error in Commit_attachments');
222: hr_utility.trace(sqlerrm);
223: END commit_attachments;
224: --
225: PROCEDURE process_attachments(p_transaction_id IN NUMBER) IS
226: CURSOR csr_clob(p_transaction_id IN NUMBER) IS

Line 250: -- hr_utility.trace_on(NULL,'ATTACH_TEST');

246: lb_filedata blob;
247: l_filestart NUMBER;
248: l_fileend NUMBER;
249: BEGIN
250: -- hr_utility.trace_on(NULL,'ATTACH_TEST');
251: hr_utility.set_location('Entering process_attachments',1);
252: -- delete the pl/sql tables
253: gt_doc.DELETE;
254: gt_attachdoc.DELETE;

Line 251: hr_utility.set_location('Entering process_attachments',1);

247: l_filestart NUMBER;
248: l_fileend NUMBER;
249: BEGIN
250: -- hr_utility.trace_on(NULL,'ATTACH_TEST');
251: hr_utility.set_location('Entering process_attachments',1);
252: -- delete the pl/sql tables
253: gt_doc.DELETE;
254: gt_attachdoc.DELETE;
255: gt_lob.DELETE;

Line 291: hr_utility.trace('Number of documents:'||gt_doc.count);

287:
288: --dbms_output.put_line('DocumentId'||gt_doc(j+1).Document_id);
289: --dbms_output.put_line('PostState: '||gt_doc(j+1).post_State);
290: END LOOP;
291: hr_utility.trace('Number of documents:'||gt_doc.count);
292: -- Process the FndAttachedDocuments rows and populate the pl/sql table
293: nl := xmldom.getElementsByTagName(txnXml, 'FndAttachedDocumentsEORow');
294: len1 := xmldom.getLength(nl);
295: -- loop through elements

Line 386: hr_utility.trace('before commit_attachments');

382: --dbms_output.put_line('Insert file with id: '||gt_lob(j+1).file_ID);
383: END IF;
384: */
385: END LOOP;
386: hr_utility.trace('before commit_attachments');
387: commit_attachments;
388: hr_utility.trace('after commit_attachments');
389: END IF;
390: EXCEPTION WHEN OTHERS THEN

Line 388: hr_utility.trace('after commit_attachments');

384: */
385: END LOOP;
386: hr_utility.trace('before commit_attachments');
387: commit_attachments;
388: hr_utility.trace('after commit_attachments');
389: END IF;
390: EXCEPTION WHEN OTHERS THEN
391: hr_utility.trace('Error in process_attachments');
392: hr_utility.trace(sqlerrm);

Line 391: hr_utility.trace('Error in process_attachments');

387: commit_attachments;
388: hr_utility.trace('after commit_attachments');
389: END IF;
390: EXCEPTION WHEN OTHERS THEN
391: hr_utility.trace('Error in process_attachments');
392: hr_utility.trace(sqlerrm);
393: END process_attachments;
394:
395: --------- END changes for attachments

Line 392: hr_utility.trace(sqlerrm);

388: hr_utility.trace('after commit_attachments');
389: END IF;
390: EXCEPTION WHEN OTHERS THEN
391: hr_utility.trace('Error in process_attachments');
392: hr_utility.trace(sqlerrm);
393: END process_attachments;
394:
395: --------- END changes for attachments
396:

Line 846: hr_utility.set_location(' Error Log Truncated ' || l_proc,50);

842: --dbms_output.put_line(' *** TXN LOG *** ' || l_error_log);
843:
844: -- as error_log column has 4000 length we need to truncate
845: if(length(l_error_log) > 3800) then
846: hr_utility.set_location(' Error Log Truncated ' || l_proc,50);
847: l_error_log := substr(l_error_log,1,3800);
848: end if;
849:
850: if(api_return_status = 'E') then

Line 931: hr_utility.trace('Commiting attachments for scorecard:'||to_number(next_score_card));

927: ,p_status_code => 'WKR'
928: ,p_return_status => api_return_status
929: );
930: begin
931: hr_utility.trace('Commiting attachments for scorecard:'||to_number(next_score_card));
932: process_attachments(p_transaction_id => score_card_txn_id);
933: hr_utility.trace('Completed Commiting attachments for scorecard:'||to_number(next_score_card));
934: exception when others then
935: hr_utility.trace('ERROR Commiting attachments for scorecard:'||to_number(next_score_card));

Line 933: hr_utility.trace('Completed Commiting attachments for scorecard:'||to_number(next_score_card));

929: );
930: begin
931: hr_utility.trace('Commiting attachments for scorecard:'||to_number(next_score_card));
932: process_attachments(p_transaction_id => score_card_txn_id);
933: hr_utility.trace('Completed Commiting attachments for scorecard:'||to_number(next_score_card));
934: exception when others then
935: hr_utility.trace('ERROR Commiting attachments for scorecard:'||to_number(next_score_card));
936: RAISE;
937: end;

Line 935: hr_utility.trace('ERROR Commiting attachments for scorecard:'||to_number(next_score_card));

931: hr_utility.trace('Commiting attachments for scorecard:'||to_number(next_score_card));
932: process_attachments(p_transaction_id => score_card_txn_id);
933: hr_utility.trace('Completed Commiting attachments for scorecard:'||to_number(next_score_card));
934: exception when others then
935: hr_utility.trace('ERROR Commiting attachments for scorecard:'||to_number(next_score_card));
936: RAISE;
937: end;
938: hr_utility.trace('success with commit_attachments');
939:

Line 938: hr_utility.trace('success with commit_attachments');

934: exception when others then
935: hr_utility.trace('ERROR Commiting attachments for scorecard:'||to_number(next_score_card));
936: RAISE;
937: end;
938: hr_utility.trace('success with commit_attachments');
939:
940: per_pms_upd.upd(p_effective_date => trunc(sysdate),
941: p_scorecard_id => to_number(next_score_card),
942: p_object_version_number => next_sc_ovn,