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

Line 23: hr_utility.set_location('Entering:'|| l_proc, 10);

19: select oracle_username
20: from fnd_oracle_userid
21: where oracle_id = 800;
22: begin
23: hr_utility.set_location('Entering:'|| l_proc, 10);
24: open csr_user;
25: fetch csr_user into l_hr_username;
26: close csr_user;
27: If l_hr_username is not null

Line 31: hr_utility.set_location(l_proc, 20);

27: If l_hr_username is not null
28: then
29: if p_mode = g_full_mode
30: then
31: hr_utility.set_location(l_proc, 20);
32: ad_ctx_ddl.optimize_index
33: (idx_name=>l_hr_username||'.IRC_DOCUMENTS_CTX1'
34: ,optlevel=>'FULL'
35: ,maxtime=>null

Line 39: hr_utility.set_location(l_proc, 30);

35: ,maxtime=>null
36: ,token=>null);
37: elsif p_mode = g_online_mode
38: then
39: hr_utility.set_location(l_proc, 30);
40: ad_ctx_ddl.sync_index
41: (idx_name=>l_hr_username||'.IRC_DOCUMENTS_CTX1');
42: elsif p_mode = g_none_mode
43: then

Line 44: hr_utility.set_location(l_proc, 35);

40: ad_ctx_ddl.sync_index
41: (idx_name=>l_hr_username||'.IRC_DOCUMENTS_CTX1');
42: elsif p_mode = g_none_mode
43: then
44: hr_utility.set_location(l_proc, 35);
45: end if;
46: end if;
47: hr_utility.set_location('Leaving:'|| l_proc, 40);
48: exception

Line 47: hr_utility.set_location('Leaving:'|| l_proc, 40);

43: then
44: hr_utility.set_location(l_proc, 35);
45: end if;
46: end if;
47: hr_utility.set_location('Leaving:'|| l_proc, 40);
48: exception
49: when others then
50: If csr_user%isopen
51: then

Line 81: hr_utility.set_location('Entering:'|| l_proc, 10);

77: l_effective_date date;
78: l_document_id number(15);
79: l_object_version_number number(9);
80: begin
81: hr_utility.set_location('Entering:'|| l_proc, 10);
82: --
83: -- Issue a savepoint
84: --
85: savepoint CREATE_DOCUMENT;

Line 165: hr_utility.set_location(' Leaving:'||l_proc, 70);

161: -- Set all output arguments
162: --
163: p_document_id := l_document_id;
164: p_object_version_number := l_object_version_number;
165: hr_utility.set_location(' Leaving:'||l_proc, 70);
166: exception
167: when hr_api.validate_enabled then
168: --
169: -- As the Validate_Enabled exception has been raised

Line 180: hr_utility.set_location(' Leaving:'||l_proc, 80);

176: -- when validation only mode is being used.)
177: --
178: p_document_id := null;
179: p_object_version_number := null;
180: hr_utility.set_location(' Leaving:'||l_proc, 80);
181: when others then
182: --
183: -- A validation or unexpected error has occured
184: --

Line 191: hr_utility.set_location(' Leaving:'||l_proc, 90);

187: --
188: p_document_id := null;
189: p_object_version_number := null;
190: --
191: hr_utility.set_location(' Leaving:'||l_proc, 90);
192: raise;
193: end CREATE_DOCUMENT;
194: --
195: --

Line 237: hr_utility.set_location('Entering:'|| l_proc, 10);

233:
234: l_doc_record csr_document_record%ROWTYPE;
235:
236: begin
237: hr_utility.set_location('Entering:'|| l_proc, 10);
238: --
239: -- Issue a savepoint
240: --
241: savepoint UPDATE_DOCUMENT;

Line 330: hr_utility.set_location(' Leaving:'||l_proc, 70);

326: --
327: -- Set all output arguments
328: --
329: p_object_version_number := l_object_version_number;
330: hr_utility.set_location(' Leaving:'||l_proc, 70);
331: exception
332: when hr_api.validate_enabled then
333: --
334: -- As the Validate_Enabled exception has been raised

Line 344: hr_utility.set_location(' Leaving:'||l_proc, 80);

340: -- (Any key or derived arguments must be set to null
341: -- when validation only mode is being used.)
342: --
343: p_object_version_number := l_object_version_number;
344: hr_utility.set_location(' Leaving:'||l_proc, 80);
345: when others then
346: --
347: -- A validation or unexpected error has occured
348: --

Line 352: hr_utility.set_location(' Leaving:'||l_proc, 90);

348: --
349: rollback to UPDATE_DOCUMENT;
350: --
351: p_object_version_number := l_object_version_number;
352: hr_utility.set_location(' Leaving:'||l_proc, 90);
353: raise;
354: end UPDATE_DOCUMENT;
355: --
356: --

Line 397: hr_utility.set_location('Entering:'|| l_proc, 10);

393: l_obj_version_number number(9);
394:
395:
396: begin
397: hr_utility.set_location('Entering:'|| l_proc, 10);
398: --
399: hr_utility.set_location('call function is_internet_applicant: '|| p_party_id || ' '|| l_proc, 115);
400: --
401: is_internet_applicant( p_document_id => p_document_id,

Line 399: hr_utility.set_location('call function is_internet_applicant: '|| p_party_id || ' '|| l_proc, 115);

395:
396: begin
397: hr_utility.set_location('Entering:'|| l_proc, 10);
398: --
399: hr_utility.set_location('call function is_internet_applicant: '|| p_party_id || ' '|| l_proc, 115);
400: --
401: is_internet_applicant( p_document_id => p_document_id,
402: p_person_id => p_person_id ,
403: p_party_id => p_party_id ,

Line 407: hr_utility.set_location('leave function is_internet_applicant: job applications: '|| to_char(l_job_appln), 116);

403: p_party_id => p_party_id ,
404: p_num_job_applications => l_job_appln);
405:
406: --
407: hr_utility.set_location('leave function is_internet_applicant: job applications: '|| to_char(l_job_appln), 116);
408: --
409: If ((l_job_appln > 0) and (p_type In ('RESUME','AUTO_RESUME')) ) Then
410: begin --begin For update when it Is an Internet Applicant
411:

Line 508: hr_utility.set_location('call create_document to create new record'||l_proc,117);

504: (p_document_id => l_new_doc_id
505: );
506: --
507:
508: hr_utility.set_location('call create_document to create new record'||l_proc,117);
509: --
510: create_document
511: (p_validate => p_validate
512: ,p_effective_date => p_effective_date

Line 523: hr_utility.set_location('end call create_document to create new record'||l_proc,118);

519: ,p_end_date => p_end_date
520: ,p_document_id => l_doc_id
521: ,p_object_version_number => l_obj_version_number );
522: --
523: hr_utility.set_location('end call create_document to create new record'||l_proc,118);
524: --
525: -- When in validation only mode raise the Validate_Enabled exception
526: --
527: if p_validate then

Line 535: hr_utility.set_location(' Leaving:'||l_proc, 70);

531: -- Set all output arguments
532: --
533: p_object_version_number := l_obj_version_number;
534: p_new_doc_id := l_new_doc_id;
535: hr_utility.set_location(' Leaving:'||l_proc, 70);
536: --
537: exception
538: when hr_api.validate_enabled then
539: --

Line 551: hr_utility.set_location(' Leaving:'||l_proc, 80);

547: -- when validation only mode is being used.)
548: --
549: p_object_version_number := l_obj_version_number;
550: p_new_doc_id := l_new_doc_id;
551: hr_utility.set_location(' Leaving:'||l_proc, 80);
552: when others then
553: --
554: -- A validation or unexpected error has occured
555: --

Line 560: hr_utility.set_location(' Leaving:'||l_proc, 90);

556: rollback to UPDATE_DOCUMENT_TRACK;
557: --
558: p_object_version_number := l_obj_version_number;
559: p_new_doc_id := l_new_doc_id;
560: hr_utility.set_location(' Leaving:'||l_proc, 90);
561: raise;
562: end; --End For updating End Date And creating new Document record
563: --
564:

Line 654: hr_utility.set_location(' Leaving:'||l_proc, 70);

650: -- Set all output arguments
651: --
652: p_object_version_number := l_object_version_number;
653: p_new_doc_id := p_document_id;
654: hr_utility.set_location(' Leaving:'||l_proc, 70);
655: exception
656: when hr_api.validate_enabled then
657: --
658: -- As the Validate_Enabled exception has been raised

Line 669: hr_utility.set_location(' Leaving:'||l_proc, 80);

665: -- when validation only mode is being used.)
666: --
667: p_object_version_number := l_object_version_number;
668: p_new_doc_id := p_document_id;
669: hr_utility.set_location(' Leaving:'||l_proc, 80);
670: when others then
671: --
672: -- A validation or unexpected error has occured
673: --

Line 678: hr_utility.set_location(' Leaving:'||l_proc, 90);

674: rollback to UPDATE_DOCUMENT_TRACK;
675: --
676: p_object_version_number := l_object_version_number;
677: p_new_doc_id := p_document_id;
678: hr_utility.set_location(' Leaving:'||l_proc, 90);
679: raise;
680: end; --End 1
681: --
682:

Line 750: hr_utility.set_location('Entering:'|| l_proc, 10);

746: --
747: l_doc_id number;
748: --
749: begin
750: hr_utility.set_location('Entering:'|| l_proc, 10);
751: --
752: --
753: -- Issue a savepoint
754: --

Line 767: hr_utility.set_location('call function is_internet_applicant: '|| p_party_id || ' '|| l_proc, 111);

763: l_end_date := TRUNC(sysdate);
764: --
765: l_object_version_number := p_object_version_number;
766: --
767: hr_utility.set_location('call function is_internet_applicant: '|| p_party_id || ' '|| l_proc, 111);
768: --
769: application_count ( p_party_id =>p_party_id ,
770: p_num_job_applications=> l_job_applications );
771: --

Line 772: hr_utility.set_location('leave function is_internet_applicant: job applications: '|| to_char(l_job_applications), 112);

768: --
769: application_count ( p_party_id =>p_party_id ,
770: p_num_job_applications=> l_job_applications );
771: --
772: hr_utility.set_location('leave function is_internet_applicant: job applications: '|| to_char(l_job_applications), 112);
773: --
774:
775: --
776: --

Line 804: hr_utility.set_location('call update document: '||l_proc,113);

800: -- then documents will not be deleted. They will only be end-dated.
801: -- This is required for application-time documents functionality.
802: If ((p_purge = 'N') and (l_job_applications > 0)) Then
803: begin
804: hr_utility.set_location('call update document: '||l_proc,113);
805: --call the update document rowhandler to update the end_date for the document
806: irc_ido_upd.upd
807: (p_effective_date => l_effective_date
808: ,p_type => p_type

Line 855: hr_utility.set_location(' Leaving:'||l_proc, 70);

851: if p_validate then
852: raise hr_api.validate_enabled;
853: end if;
854:
855: hr_utility.set_location(' Leaving:'||l_proc, 70);
856:
857: exception
858: when hr_api.validate_enabled then
859: --

Line 864: hr_utility.set_location(' Leaving:'||l_proc, 80);

860: -- As the Validate_Enabled exception has been raised
861: -- we must rollback to the savepoint
862: --
863: rollback to DELETE_DOCUMENT;
864: hr_utility.set_location(' Leaving:'||l_proc, 80);
865: when others then
866: --
867: -- A validation or unexpected error has occured
868: --

Line 870: hr_utility.set_location(' Leaving:'||l_proc, 90);

866: --
867: -- A validation or unexpected error has occured
868: --
869: rollback to DELETE_DOCUMENT;
870: hr_utility.set_location(' Leaving:'||l_proc, 90);
871: raise;
872:
873:
874: end DELETE_DOCUMENT;

Line 906: hr_utility.set_location(' Entering:'||l_proc, 10);

902: --
903: l_ret varchar2(30);
904: begin
905: --
906: hr_utility.set_location(' Entering:'||l_proc, 10);
907: --
908: open csr_user;
909: fetch csr_user into l_hr_username;
910: close csr_user;

Line 934: hr_utility.set_location(l_proc||' - BLOB Conversion Complete', 20);

930: where document_id = p_document_id;
931: --
932: irc_ido_shd.g_api_dml := false; -- Unset the api dml status
933: --
934: hr_utility.set_location(l_proc||' - BLOB Conversion Complete', 20);
935: --
936: -- Synchronize interMedia index
937: hr_utility.set_location(l_proc||' - Synchronization Complete', 30);
938: --

Line 937: hr_utility.set_location(l_proc||' - Synchronization Complete', 30);

933: --
934: hr_utility.set_location(l_proc||' - BLOB Conversion Complete', 20);
935: --
936: -- Synchronize interMedia index
937: hr_utility.set_location(l_proc||' - Synchronization Complete', 30);
938: --
939: else
940: close csr_doc_exists;
941: hr_utility.set_message(800, 'IRC_412046_IDO_INV_DOC_ID');

Line 941: hr_utility.set_message(800, 'IRC_412046_IDO_INV_DOC_ID');

937: hr_utility.set_location(l_proc||' - Synchronization Complete', 30);
938: --
939: else
940: close csr_doc_exists;
941: hr_utility.set_message(800, 'IRC_412046_IDO_INV_DOC_ID');
942: hr_utility.raise_error;
943: end if;
944: end if; -- End if for l_hr_username is not null
945: hr_utility.set_location(' Leaving:'||l_proc, 40);

Line 942: hr_utility.raise_error;

938: --
939: else
940: close csr_doc_exists;
941: hr_utility.set_message(800, 'IRC_412046_IDO_INV_DOC_ID');
942: hr_utility.raise_error;
943: end if;
944: end if; -- End if for l_hr_username is not null
945: hr_utility.set_location(' Leaving:'||l_proc, 40);
946: --

Line 945: hr_utility.set_location(' Leaving:'||l_proc, 40);

941: hr_utility.set_message(800, 'IRC_412046_IDO_INV_DOC_ID');
942: hr_utility.raise_error;
943: end if;
944: end if; -- End if for l_hr_username is not null
945: hr_utility.set_location(' Leaving:'||l_proc, 40);
946: --
947: exception
948: when others then
949: If csr_user%isopen

Line 958: hr_utility.log_at_error_level('per'

954: then
955: close csr_doc_exists;
956: End if;
957: if(fnd_log.test(fnd_log.level_error,'per.irc_document_api.process_document')) then
958: hr_utility.log_at_error_level('per'
959: ,'irc_document_api.process_document'
960: ,'unable to process'
961: ,dbms_utility.format_error_stack);
962: end if;

Line 1082: hr_utility.set_message(800, 'IRC_412046_IDO_INV_DOC_ID');

1078: close get_schema_name;
1079: end if;
1080: else
1081: close csr_doc_exists;
1082: hr_utility.set_message(800, 'IRC_412046_IDO_INV_DOC_ID');
1083: hr_utility.raise_error;
1084: end if;
1085:
1086: return l_output_clob;

Line 1083: hr_utility.raise_error;

1079: end if;
1080: else
1081: close csr_doc_exists;
1082: hr_utility.set_message(800, 'IRC_412046_IDO_INV_DOC_ID');
1083: hr_utility.raise_error;
1084: end if;
1085:
1086: return l_output_clob;
1087: exception

Line 1090: hr_utility.log_at_error_level('per'

1086: return l_output_clob;
1087: exception
1088: when others then
1089: if(fnd_log.test(fnd_log.level_error,'per.irc_document_api.get_html_preview')) then
1090: hr_utility.log_at_error_level('per'
1091: ,'irc_document_api.get_html_preview'
1092: ,'unable to preview'
1093: ,dbms_utility.format_error_stack);
1094: end if;

Line 1095: hr_utility.log_at_error_level('per','get_html_preview','unable to preview'

1091: ,'irc_document_api.get_html_preview'
1092: ,'unable to preview'
1093: ,dbms_utility.format_error_stack);
1094: end if;
1095: hr_utility.log_at_error_level('per','get_html_preview','unable to preview'
1096: ,dbms_utility.format_error_stack);
1097: fnd_message.set_name('PER', 'IRC_UNABLE_TO_PREVIEW_DOC');
1098: fnd_msg_pub.add_detail
1099: (p_message_type => 'W'