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

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

35: --
36: -- Other variables
37: l_proc varchar2(72) := g_package ||'create_exception_report';
38: Begin
39: hr_utility.set_location(' Entering:' || l_proc,10);
40: --
41: -- Issue a savepoint
42: --
43: savepoint create_exception_report_swi;

Line 94: hr_utility.set_location(' Leaving:' || l_proc,20);

90: -- messages of any type exist in the Multiple Message List.
91: -- Also disable Multiple Message Detection.
92: --
93: p_return_status := hr_multi_message.get_return_status_disable;
94: hr_utility.set_location(' Leaving:' || l_proc,20);
95: --
96: exception
97: when hr_multi_message.error_message_exist then
98: --

Line 110: hr_utility.set_location(' Leaving:' || l_proc, 30);

106: --
107: p_exception_report_id := null;
108: p_object_version_number := null;
109: p_return_status := hr_multi_message.get_return_status_disable;
110: hr_utility.set_location(' Leaving:' || l_proc, 30);
111: when others then
112: --
113: -- When Multiple Message Detection is enabled catch
114: -- any Application specific or other unexpected

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

117: -- error.
118: --
119: rollback to create_exception_report_swi;
120: if hr_multi_message.unexpected_error_add(l_proc) then
121: hr_utility.set_location(' Leaving:' || l_proc,40);
122: raise;
123: end if;
124: --
125: -- Reset IN OUT and set OUT parameters

Line 130: hr_utility.set_location(' Leaving:' || l_proc,50);

126: --
127: p_exception_report_id := null;
128: p_object_version_number := null;
129: p_return_status := hr_multi_message.get_return_status_disable;
130: hr_utility.set_location(' Leaving:' || l_proc,50);
131: end create_exception_report;
132: -- ----------------------------------------------------------------------------
133: -- |------------------------< delete_exception_report >-----------------------|
134: -- ----------------------------------------------------------------------------

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

146: --
147: -- Other variables
148: l_proc varchar2(72) := g_package ||'delete_exception_report';
149: Begin
150: hr_utility.set_location(' Entering:' || l_proc,10);
151: --
152: -- Issue a savepoint
153: --
154: savepoint delete_exception_report_swi;

Line 192: hr_utility.set_location(' Leaving:' || l_proc,20);

188: -- messages of any type exist in the Multiple Message List.
189: -- Also disable Multiple Message Detection.
190: --
191: p_return_status := hr_multi_message.get_return_status_disable;
192: hr_utility.set_location(' Leaving:' || l_proc,20);
193: --
194: exception
195: when hr_multi_message.error_message_exist then
196: --

Line 206: hr_utility.set_location(' Leaving:' || l_proc, 30);

202: --
203: -- Reset IN OUT parameters and set OUT parameters
204: --
205: p_return_status := hr_multi_message.get_return_status_disable;
206: hr_utility.set_location(' Leaving:' || l_proc, 30);
207: when others then
208: --
209: -- When Multiple Message Detection is enabled catch
210: -- any Application specific or other unexpected

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

213: -- error.
214: --
215: rollback to delete_exception_report_swi;
216: if hr_multi_message.unexpected_error_add(l_proc) then
217: hr_utility.set_location(' Leaving:' || l_proc,40);
218: raise;
219: end if;
220: --
221: -- Reset IN OUT and set OUT parameters

Line 224: hr_utility.set_location(' Leaving:' || l_proc,50);

220: --
221: -- Reset IN OUT and set OUT parameters
222: --
223: p_return_status := hr_multi_message.get_return_status_disable;
224: hr_utility.set_location(' Leaving:' || l_proc,50);
225: end delete_exception_report;
226: -- ----------------------------------------------------------------------------
227: -- |------------------------< update_exception_report >-----------------------|
228: -- ----------------------------------------------------------------------------

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

254: --
255: -- Other variables
256: l_proc varchar2(72) := g_package ||'update_exception_report';
257: Begin
258: hr_utility.set_location(' Entering:' || l_proc,10);
259: --
260: -- Issue a savepoint
261: --
262: savepoint update_exception_report_swi;

Line 314: hr_utility.set_location(' Leaving:' || l_proc,20);

310: -- messages of any type exist in the Multiple Message List.
311: -- Also disable Multiple Message Detection.
312: --
313: p_return_status := hr_multi_message.get_return_status_disable;
314: hr_utility.set_location(' Leaving:' || l_proc,20);
315: --
316: exception
317: when hr_multi_message.error_message_exist then
318: --

Line 329: hr_utility.set_location(' Leaving:' || l_proc, 30);

325: -- Reset IN OUT parameters and set OUT parameters
326: --
327: p_object_version_number := l_object_version_number;
328: p_return_status := hr_multi_message.get_return_status_disable;
329: hr_utility.set_location(' Leaving:' || l_proc, 30);
330: when others then
331: --
332: -- When Multiple Message Detection is enabled catch
333: -- any Application specific or other unexpected

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

336: -- error.
337: --
338: rollback to update_exception_report_swi;
339: if hr_multi_message.unexpected_error_add(l_proc) then
340: hr_utility.set_location(' Leaving:' || l_proc,40);
341: raise;
342: end if;
343: --
344: -- Reset IN OUT and set OUT parameters

Line 348: hr_utility.set_location(' Leaving:' || l_proc,50);

344: -- Reset IN OUT and set OUT parameters
345: --
346: p_object_version_number := l_object_version_number;
347: p_return_status := hr_multi_message.get_return_status_disable;
348: hr_utility.set_location(' Leaving:' || l_proc,50);
349: end update_exception_report;
350:
351:
352: -- ----------------------------------------------------------------------------

Line 409: hr_utility.set_location('Entering:'|| l_proc, 1);

405: and xtv.data_source_code = 'PQPRPEXR'
406: and xtv.template_name = p_template_name;
407:
408: begin
409: hr_utility.set_location('Entering:'|| l_proc, 1);
410:
411: --PPA finder value
412: -- Bug 14260329: Modified the Code to use sequence instead of
413: -- To_char(sysdate,'HHSSSS')

Line 596: hr_utility.set_location('Exception Report Preprocessor Fail',50);

592: );
593: END IF;
594:
595: if ( not success ) then
596: hr_utility.set_location('Exception Report Preprocessor Fail',50);
597: raise submit_failed;
598: ELSE
599: hr_utility.set_location('Exception Report Preprocessor Sucess',50);
600: end if;

Line 599: hr_utility.set_location('Exception Report Preprocessor Sucess',50);

595: if ( not success ) then
596: hr_utility.set_location('Exception Report Preprocessor Fail',50);
597: raise submit_failed;
598: ELSE
599: hr_utility.set_location('Exception Report Preprocessor Sucess',50);
600: end if;
601:
602: -- 'Exception Report'
603: /* submit program PQPRPEXR which is in stage STAGE2 */

Line 622: hr_utility.set_location('Stage2 first submit fail' ,50);

618: ,argument14=>p_template_name
619: ,argument15=>p_output_format
620: );
621: if ( not success ) then
622: hr_utility.set_location('Stage2 first submit fail' ,50);
623: raise submit_failed;
624: ELSE
625: hr_utility.set_location('Stage2 first submit success' ,50);
626: end if;

Line 625: hr_utility.set_location('Stage2 first submit success' ,50);

621: if ( not success ) then
622: hr_utility.set_location('Stage2 first submit fail' ,50);
623: raise submit_failed;
624: ELSE
625: hr_utility.set_location('Stage2 first submit success' ,50);
626: end if;
627: /* Submit the Request set */
628: req_id := fnd_submit.submit_set(null,FALSE);
629: hr_utility.set_location('Request ID:'||req_id ,50);

Line 629: hr_utility.set_location('Request ID:'||req_id ,50);

625: hr_utility.set_location('Stage2 first submit success' ,50);
626: end if;
627: /* Submit the Request set */
628: req_id := fnd_submit.submit_set(null,FALSE);
629: hr_utility.set_location('Request ID:'||req_id ,50);
630: end if;
631: p_request_id := req_id;
632: p_return_status := 'S';
633: hr_utility.set_location(' Leaving:'||l_proc, 70);

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

629: hr_utility.set_location('Request ID:'||req_id ,50);
630: end if;
631: p_request_id := req_id;
632: p_return_status := 'S';
633: hr_utility.set_location(' Leaving:'||l_proc, 70);
634: exception
635: when submit_failed THEN
636: hr_utility.set_location('error Leaving:'||l_proc, 80);
637: p_return_status := 'E';

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

632: p_return_status := 'S';
633: hr_utility.set_location(' Leaving:'||l_proc, 70);
634: exception
635: when submit_failed THEN
636: hr_utility.set_location('error Leaving:'||l_proc, 80);
637: p_return_status := 'E';
638: raise;
639: when others then
640: hr_utility.set_location(' error Leaving:'||l_proc, 80);

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

636: hr_utility.set_location('error Leaving:'||l_proc, 80);
637: p_return_status := 'E';
638: raise;
639: when others then
640: hr_utility.set_location(' error Leaving:'||l_proc, 80);
641: p_return_status := 'E';
642: raise;
643: end submit_request_set;
644:

Line 653: hr_utility.trace('Enter Legislation code');

649: RETURN VARCHAR2
650: IS
651: l_legislation_code_l per_business_groups.legislation_code%TYPE;
652: BEGIN
653: hr_utility.trace('Enter Legislation code');
654: SELECT legislation_code
655: INTO l_legislation_code_l
656: FROM per_business_groups
657: WHERE business_group_id =p_business_group_id;

Line 660: hr_utility.trace('Leaving Legislation code' );

656: FROM per_business_groups
657: WHERE business_group_id =p_business_group_id;
658:
659: RETURN (l_legislation_code_l);
660: hr_utility.trace('Leaving Legislation code' );
661: EXCEPTION
662: ---------
663: WHEN OTHERS THEN
664: RETURN(NULL);

Line 766: hr_utility.set_location('Entering:'|| l_proc, 1);

762: END IF;
763:
764: END IF;
765:
766: hr_utility.set_location('Entering:'|| l_proc, 1);
767:
768: open c_rtf_data(c_template_name => p_template_name);
769: fetch c_rtf_data into l_app_short_name,l_template_code,l_default_lang,l_default_territory;
770: close c_rtf_data;

Line 784: hr_utility.set_location('XML submit fail' ,50);

780: success := FND_REQUEST.add_layout(l_app_short_name,l_template_code,l_default_lang,l_default_territory,'RTF');
781: END IF;
782:
783: if ( not success ) then
784: hr_utility.set_location('XML submit fail' ,50);
785: raise submit_failed;
786: ELSE
787: hr_utility.set_location('XML submit success' ,50);
788: end if;

Line 787: hr_utility.set_location('XML submit success' ,50);

783: if ( not success ) then
784: hr_utility.set_location('XML submit fail' ,50);
785: raise submit_failed;
786: ELSE
787: hr_utility.set_location('XML submit success' ,50);
788: end if;
789:
790: l_request_id := FND_REQUEST.submit_request(
791: 'PQP'

Line 811: hr_utility.set_location('Current l_request_id:'||l_request_id, 80);

807: ,p_consolidation_set_id
808: ,p_effective_date--fnd_date.date_to_canonical(p_effective_date)
809: );
810:
811: hr_utility.set_location('Current l_request_id:'||l_request_id, 80);
812: hr_utility.set_location(' Leaving:'||l_proc, 70);
813: exception
814: when submit_failed THEN
815: hr_utility.set_location('error Leaving:'||l_proc, 80);

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

808: ,p_effective_date--fnd_date.date_to_canonical(p_effective_date)
809: );
810:
811: hr_utility.set_location('Current l_request_id:'||l_request_id, 80);
812: hr_utility.set_location(' Leaving:'||l_proc, 70);
813: exception
814: when submit_failed THEN
815: hr_utility.set_location('error Leaving:'||l_proc, 80);
816: raise;

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

811: hr_utility.set_location('Current l_request_id:'||l_request_id, 80);
812: hr_utility.set_location(' Leaving:'||l_proc, 70);
813: exception
814: when submit_failed THEN
815: hr_utility.set_location('error Leaving:'||l_proc, 80);
816: raise;
817: when others then
818: hr_utility.set_location(' error Leaving:'||l_proc, 80);
819: raise;

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

814: when submit_failed THEN
815: hr_utility.set_location('error Leaving:'||l_proc, 80);
816: raise;
817: when others then
818: hr_utility.set_location(' error Leaving:'||l_proc, 80);
819: raise;
820: end exception_report_xml_process;
821:
822: