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_DOCUMENT_EXTRA_INFO_API dependencies on HR_UTILITY

Line 143: hr_utility.set_location('Entering:'|| l_proc, 5);

139: where document_type_id = p_document_type_id
140: and person_id = p_person_id;
141: --
142: begin
143: hr_utility.set_location('Entering:'|| l_proc, 5);
144: --
145: -- Issue a savepoint
146: --
147: savepoint create_doc_extra_info;

Line 245: hr_utility.set_location(l_proc, 7);

241: end;
242: --
243: -- End of Before Process User Hook call
244: --
245: hr_utility.set_location(l_proc, 7);
246: open csr_get_document_type(p_document_type_id =>p_document_type_id);
247: fetch csr_get_document_type into l_document_type,l_authorization_required;
248: close csr_get_document_type;
249:

Line 259: hr_utility.set_message(800, 'HR_449709_DOR_MUL_NOT_ALW');

255: fetch csr_chk_doc_allowed into l_num;
256: if (l_num > 0) then
257: close csr_chk_doc_allowed;
258:
259: hr_utility.set_message(800, 'HR_449709_DOR_MUL_NOT_ALW');
260: hr_utility.set_message_token('TYPE', l_document_type);
261: hr_utility.raise_error;
262: else
263: close csr_chk_doc_allowed;

Line 260: hr_utility.set_message_token('TYPE', l_document_type);

256: if (l_num > 0) then
257: close csr_chk_doc_allowed;
258:
259: hr_utility.set_message(800, 'HR_449709_DOR_MUL_NOT_ALW');
260: hr_utility.set_message_token('TYPE', l_document_type);
261: hr_utility.raise_error;
262: else
263: close csr_chk_doc_allowed;
264: hr_utility.set_location(l_proc, 8);

Line 261: hr_utility.raise_error;

257: close csr_chk_doc_allowed;
258:
259: hr_utility.set_message(800, 'HR_449709_DOR_MUL_NOT_ALW');
260: hr_utility.set_message_token('TYPE', l_document_type);
261: hr_utility.raise_error;
262: else
263: close csr_chk_doc_allowed;
264: hr_utility.set_location(l_proc, 8);
265: end if;

Line 264: hr_utility.set_location(l_proc, 8);

260: hr_utility.set_message_token('TYPE', l_document_type);
261: hr_utility.raise_error;
262: else
263: close csr_chk_doc_allowed;
264: hr_utility.set_location(l_proc, 8);
265: end if;
266: close csr_chk_multiple;
267: else
268: close csr_chk_multiple;

Line 281: hr_utility.set_message(800, 'HR_449708_DOR_UNQ_PER_DOC');

277: fetch csr_chk_combination into dummy;
278: if csr_chk_combination%found then
279: close csr_chk_combination;
280:
281: hr_utility.set_message(800, 'HR_449708_DOR_UNQ_PER_DOC');
282: hr_utility.set_message_token('TYPE', l_document_type);
283: hr_utility.set_message_token('DATE_FROM', p_date_from);
284: hr_utility.set_message_token('DATE_TO', p_date_to);
285: hr_utility.raise_error;

Line 282: hr_utility.set_message_token('TYPE', l_document_type);

278: if csr_chk_combination%found then
279: close csr_chk_combination;
280:
281: hr_utility.set_message(800, 'HR_449708_DOR_UNQ_PER_DOC');
282: hr_utility.set_message_token('TYPE', l_document_type);
283: hr_utility.set_message_token('DATE_FROM', p_date_from);
284: hr_utility.set_message_token('DATE_TO', p_date_to);
285: hr_utility.raise_error;
286: --

Line 283: hr_utility.set_message_token('DATE_FROM', p_date_from);

279: close csr_chk_combination;
280:
281: hr_utility.set_message(800, 'HR_449708_DOR_UNQ_PER_DOC');
282: hr_utility.set_message_token('TYPE', l_document_type);
283: hr_utility.set_message_token('DATE_FROM', p_date_from);
284: hr_utility.set_message_token('DATE_TO', p_date_to);
285: hr_utility.raise_error;
286: --
287: else

Line 284: hr_utility.set_message_token('DATE_TO', p_date_to);

280:
281: hr_utility.set_message(800, 'HR_449708_DOR_UNQ_PER_DOC');
282: hr_utility.set_message_token('TYPE', l_document_type);
283: hr_utility.set_message_token('DATE_FROM', p_date_from);
284: hr_utility.set_message_token('DATE_TO', p_date_to);
285: hr_utility.raise_error;
286: --
287: else
288: close csr_chk_combination;

Line 285: hr_utility.raise_error;

281: hr_utility.set_message(800, 'HR_449708_DOR_UNQ_PER_DOC');
282: hr_utility.set_message_token('TYPE', l_document_type);
283: hr_utility.set_message_token('DATE_FROM', p_date_from);
284: hr_utility.set_message_token('DATE_TO', p_date_to);
285: hr_utility.raise_error;
286: --
287: else
288: close csr_chk_combination;
289: hr_utility.set_location(l_proc, 9);

Line 289: hr_utility.set_location(l_proc, 9);

285: hr_utility.raise_error;
286: --
287: else
288: close csr_chk_combination;
289: hr_utility.set_location(l_proc, 9);
290: end if;
291:
292: -- Added for checking Authorization Required, If value = 'N'
293: -- pass Default Values of verified by and verified date to 'ins'

Line 392: hr_utility.set_location(l_proc, 8);

388:
389: p_object_version_number := l_object_version_number;
390: p_document_extra_info_id := l_document_extra_info_id;
391: --
392: hr_utility.set_location(l_proc, 8);
393: --
394: -- Call After Process User Hook
395: --
396: begin

Line 498: hr_utility.set_location(' Leaving:'||l_proc, 11);

494: if p_validate then
495: raise hr_api.validate_enabled;
496: end if;
497: --
498: hr_utility.set_location(' Leaving:'||l_proc, 11);
499: exception
500: when hr_api.validate_enabled then
501: --
502: -- As the Validate_Enabled exception has been raised

Line 514: hr_utility.set_location(' Leaving:'||l_proc, 12);

510: --
511: p_document_extra_info_id := null;
512: p_object_version_number := null;
513: --
514: hr_utility.set_location(' Leaving:'||l_proc, 12);
515: --
516: when others then
517: --
518: -- A validation or unexpected error has occurred

Line 666: hr_utility.set_location('Entering:'|| l_proc, 5);

662: and person_id = p_person_id
663: and document_extra_info_id <> p_document_extra_info_id;
664: --
665: begin
666: hr_utility.set_location('Entering:'|| l_proc, 5);
667: --
668: -- Issue a savepoint
669: --
670: savepoint update_doc_extra_info;

Line 767: hr_utility.set_location(l_proc, 7);

763: (p_module_name => 'UPDATE_DOC_EXTRA_INFO',
764: p_hook_type => 'BP'
765: );
766: end;
767: hr_utility.set_location(l_proc, 7);
768: --
769: open csr_get_document_type(p_document_type_id =>p_document_type_id);
770: fetch csr_get_document_type into l_document_type,l_authorization_required;
771: close csr_get_document_type;

Line 782: hr_utility.set_message(800, 'HR_449709_DOR_MUL_NOT_ALW');

778: fetch csr_chk_doc_allowed into l_num;
779: if (l_num > 0) then
780: close csr_chk_doc_allowed;
781:
782: hr_utility.set_message(800, 'HR_449709_DOR_MUL_NOT_ALW');
783: hr_utility.set_message_token('TYPE', l_document_type);
784: hr_utility.raise_error;
785: else
786: close csr_chk_doc_allowed;

Line 783: hr_utility.set_message_token('TYPE', l_document_type);

779: if (l_num > 0) then
780: close csr_chk_doc_allowed;
781:
782: hr_utility.set_message(800, 'HR_449709_DOR_MUL_NOT_ALW');
783: hr_utility.set_message_token('TYPE', l_document_type);
784: hr_utility.raise_error;
785: else
786: close csr_chk_doc_allowed;
787: hr_utility.set_location(l_proc, 8);

Line 784: hr_utility.raise_error;

780: close csr_chk_doc_allowed;
781:
782: hr_utility.set_message(800, 'HR_449709_DOR_MUL_NOT_ALW');
783: hr_utility.set_message_token('TYPE', l_document_type);
784: hr_utility.raise_error;
785: else
786: close csr_chk_doc_allowed;
787: hr_utility.set_location(l_proc, 8);
788: end if;

Line 787: hr_utility.set_location(l_proc, 8);

783: hr_utility.set_message_token('TYPE', l_document_type);
784: hr_utility.raise_error;
785: else
786: close csr_chk_doc_allowed;
787: hr_utility.set_location(l_proc, 8);
788: end if;
789: close csr_chk_multiple;
790: else
791: close csr_chk_multiple;

Line 805: hr_utility.set_message(800, 'HR_449708_DOR_UNQ_PER_DOC');

801: fetch csr_chk_combination into dummy;
802: if csr_chk_combination%found then
803: close csr_chk_combination;
804:
805: hr_utility.set_message(800, 'HR_449708_DOR_UNQ_PER_DOC');
806: hr_utility.set_message_token('TYPE', l_document_type);
807: hr_utility.set_message_token('DATE_FROM', p_date_from);
808: hr_utility.set_message_token('DATE_TO', p_date_to);
809: hr_utility.raise_error;

Line 806: hr_utility.set_message_token('TYPE', l_document_type);

802: if csr_chk_combination%found then
803: close csr_chk_combination;
804:
805: hr_utility.set_message(800, 'HR_449708_DOR_UNQ_PER_DOC');
806: hr_utility.set_message_token('TYPE', l_document_type);
807: hr_utility.set_message_token('DATE_FROM', p_date_from);
808: hr_utility.set_message_token('DATE_TO', p_date_to);
809: hr_utility.raise_error;
810: --

Line 807: hr_utility.set_message_token('DATE_FROM', p_date_from);

803: close csr_chk_combination;
804:
805: hr_utility.set_message(800, 'HR_449708_DOR_UNQ_PER_DOC');
806: hr_utility.set_message_token('TYPE', l_document_type);
807: hr_utility.set_message_token('DATE_FROM', p_date_from);
808: hr_utility.set_message_token('DATE_TO', p_date_to);
809: hr_utility.raise_error;
810: --
811: else

Line 808: hr_utility.set_message_token('DATE_TO', p_date_to);

804:
805: hr_utility.set_message(800, 'HR_449708_DOR_UNQ_PER_DOC');
806: hr_utility.set_message_token('TYPE', l_document_type);
807: hr_utility.set_message_token('DATE_FROM', p_date_from);
808: hr_utility.set_message_token('DATE_TO', p_date_to);
809: hr_utility.raise_error;
810: --
811: else
812: close csr_chk_combination;

Line 809: hr_utility.raise_error;

805: hr_utility.set_message(800, 'HR_449708_DOR_UNQ_PER_DOC');
806: hr_utility.set_message_token('TYPE', l_document_type);
807: hr_utility.set_message_token('DATE_FROM', p_date_from);
808: hr_utility.set_message_token('DATE_TO', p_date_to);
809: hr_utility.raise_error;
810: --
811: else
812: close csr_chk_combination;
813: hr_utility.set_location(l_proc, 9);

Line 813: hr_utility.set_location(l_proc, 9);

809: hr_utility.raise_error;
810: --
811: else
812: close csr_chk_combination;
813: hr_utility.set_location(l_proc, 9);
814: end if;
815:
816: -- Added for checking Authorization Required, If value = 'N'
817: -- pass Default Values of verified by and verified date to 'ins'

Line 919: hr_utility.set_location(l_proc, 8);

915: );
916:
917:
918: --
919: hr_utility.set_location(l_proc, 8);
920: --
921: -- Call After Process User Hook
922: --
923: begin

Line 1025: hr_utility.set_location(' Leaving:'||l_proc, 11);

1021: if p_validate then
1022: raise hr_api.validate_enabled;
1023: end if;
1024: --
1025: hr_utility.set_location(' Leaving:'||l_proc, 11);
1026: exception
1027: when hr_api.validate_enabled then
1028: --
1029: -- As the Validate_Enabled exception has been raised

Line 1040: hr_utility.set_location(' Leaving:'||l_proc, 12);

1036: -- when validation only mode is being used.)
1037: --
1038: p_object_version_number := l_object_version_number;
1039: --
1040: hr_utility.set_location(' Leaving:'||l_proc, 12);
1041: --
1042: when others then
1043: --
1044: -- A validation or unexpected error has occurred

Line 1073: hr_utility.set_location('Entering:'|| l_proc, 5);

1069: --
1070: l_proc varchar2(72) := g_package||'delete_doc_extra_info';
1071: --
1072: begin
1073: hr_utility.set_location('Entering:'|| l_proc, 5);
1074: --
1075: -- Issue a savepoint
1076: --
1077: savepoint delete_doc_extra_info;

Line 1096: hr_utility.set_location(l_proc, 7);

1092: end;
1093: --
1094: -- End of Before Process User Hook call
1095: --
1096: hr_utility.set_location(l_proc, 7);
1097: --
1098: -- Process Logic - Delete Document Extra Info details
1099: --
1100: hr_dei_del.del

Line 1105: hr_utility.set_location(l_proc, 8);

1101: (p_document_extra_info_id => p_document_extra_info_id
1102: ,p_object_version_number => p_object_version_number
1103: );
1104: --
1105: hr_utility.set_location(l_proc, 8);
1106: --
1107: -- Call Before Process User Hook
1108: --
1109: begin

Line 1130: hr_utility.set_location(' Leaving:'||l_proc, 11);

1126: if p_validate then
1127: raise hr_api.validate_enabled;
1128: end if;
1129: --
1130: hr_utility.set_location(' Leaving:'||l_proc, 11);
1131: exception
1132: when hr_api.validate_enabled then
1133: --
1134: -- As the Validate_Enabled exception has been raised

Line 1139: hr_utility.set_location(' Leaving:'||l_proc, 12);

1135: -- we must rollback to the savepoint
1136: --
1137: ROLLBACK TO delete_doc_extra_info;
1138: --
1139: hr_utility.set_location(' Leaving:'||l_proc, 12);
1140: --
1141: when others then
1142: --
1143: -- A validation or unexpected error has occurred