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 397: hr_utility.set_location('Entering:'|| l_proc, 1);

393: l_state_code_dummy varchar2(50);
394: l_proc varchar2(72) := g_package||'submit_request_set';
395:
396: begin
397: hr_utility.set_location('Entering:'|| l_proc, 1);
398:
399: --PPA finder value
400: SELECT TO_CHAR(sysdate,'HHSSSSS') INTO l_ppa_finder
401: FROM DUAL;

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

498: ,argument35=>p_template_name
499: ,argument36=>p_output_format
500: );
501: if ( not success ) then
502: hr_utility.set_location('Exception Report Preprocessor Fail',50);
503: raise submit_failed;
504: ELSE
505: hr_utility.set_location('Exception Report Preprocessor Sucess',50);
506: end if;

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

501: if ( not success ) then
502: hr_utility.set_location('Exception Report Preprocessor Fail',50);
503: raise submit_failed;
504: ELSE
505: hr_utility.set_location('Exception Report Preprocessor Sucess',50);
506: end if;
507:
508: -- 'Exception Report'
509: /* submit program PQPRPEXR which is in stage STAGE2 */

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

524: ,argument14=>p_template_name
525: ,argument15=>p_output_format
526: );
527: if ( not success ) then
528: hr_utility.set_location('Stage2 first submit fail' ,50);
529: raise submit_failed;
530: ELSE
531: hr_utility.set_location('Stage2 first submit success' ,50);
532: end if;

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

527: if ( not success ) then
528: hr_utility.set_location('Stage2 first submit fail' ,50);
529: raise submit_failed;
530: ELSE
531: hr_utility.set_location('Stage2 first submit success' ,50);
532: end if;
533: /* Submit the Request set */
534: req_id := fnd_submit.submit_set(null,FALSE);
535: hr_utility.set_location('Request ID:'||req_id ,50);

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

531: hr_utility.set_location('Stage2 first submit success' ,50);
532: end if;
533: /* Submit the Request set */
534: req_id := fnd_submit.submit_set(null,FALSE);
535: hr_utility.set_location('Request ID:'||req_id ,50);
536: end if;
537: p_request_id := req_id;
538: p_return_status := 'S';
539: hr_utility.set_location(' Leaving:'||l_proc, 70);

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

535: hr_utility.set_location('Request ID:'||req_id ,50);
536: end if;
537: p_request_id := req_id;
538: p_return_status := 'S';
539: hr_utility.set_location(' Leaving:'||l_proc, 70);
540: exception
541: when submit_failed THEN
542: hr_utility.set_location('error Leaving:'||l_proc, 80);
543: p_return_status := 'E';

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

538: p_return_status := 'S';
539: hr_utility.set_location(' Leaving:'||l_proc, 70);
540: exception
541: when submit_failed THEN
542: hr_utility.set_location('error Leaving:'||l_proc, 80);
543: p_return_status := 'E';
544: raise;
545: when others then
546: hr_utility.set_location(' error Leaving:'||l_proc, 80);

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

542: hr_utility.set_location('error Leaving:'||l_proc, 80);
543: p_return_status := 'E';
544: raise;
545: when others then
546: hr_utility.set_location(' error Leaving:'||l_proc, 80);
547: p_return_status := 'E';
548: raise;
549: end submit_request_set;
550:

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

555: RETURN VARCHAR2
556: IS
557: l_legislation_code_l per_business_groups.legislation_code%TYPE;
558: BEGIN
559: hr_utility.trace('Enter Legislation code');
560: SELECT legislation_code
561: INTO l_legislation_code_l
562: FROM per_business_groups
563: WHERE business_group_id =p_business_group_id;

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

562: FROM per_business_groups
563: WHERE business_group_id =p_business_group_id;
564:
565: RETURN (l_legislation_code_l);
566: hr_utility.trace('Leaving Legislation code' );
567: EXCEPTION
568: ---------
569: WHEN OTHERS THEN
570: RETURN(NULL);

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

668: END IF;
669:
670: END IF;
671:
672: hr_utility.set_location('Entering:'|| l_proc, 1);
673:
674: open c_rtf_data(c_template_name => p_template_name);
675: fetch c_rtf_data into l_app_short_name,l_template_code,l_default_lang,l_default_territory;
676: close c_rtf_data;

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

686: success := FND_REQUEST.add_layout(l_app_short_name,l_template_code,l_default_lang,l_default_territory,'RTF');
687: END IF;
688:
689: if ( not success ) then
690: hr_utility.set_location('XML submit fail' ,50);
691: raise submit_failed;
692: ELSE
693: hr_utility.set_location('XML submit success' ,50);
694: end if;

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

689: if ( not success ) then
690: hr_utility.set_location('XML submit fail' ,50);
691: raise submit_failed;
692: ELSE
693: hr_utility.set_location('XML submit success' ,50);
694: end if;
695:
696: l_request_id := FND_REQUEST.submit_request(
697: 'PQP'

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

713: ,p_consolidation_set_id
714: ,p_effective_date--fnd_date.date_to_canonical(p_effective_date)
715: );
716:
717: hr_utility.set_location('Current l_request_id:'||l_request_id, 80);
718: hr_utility.set_location(' Leaving:'||l_proc, 70);
719: exception
720: when submit_failed THEN
721: hr_utility.set_location('error Leaving:'||l_proc, 80);

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

714: ,p_effective_date--fnd_date.date_to_canonical(p_effective_date)
715: );
716:
717: hr_utility.set_location('Current l_request_id:'||l_request_id, 80);
718: hr_utility.set_location(' Leaving:'||l_proc, 70);
719: exception
720: when submit_failed THEN
721: hr_utility.set_location('error Leaving:'||l_proc, 80);
722: raise;

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

717: hr_utility.set_location('Current l_request_id:'||l_request_id, 80);
718: hr_utility.set_location(' Leaving:'||l_proc, 70);
719: exception
720: when submit_failed THEN
721: hr_utility.set_location('error Leaving:'||l_proc, 80);
722: raise;
723: when others then
724: hr_utility.set_location(' error Leaving:'||l_proc, 80);
725: raise;

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

720: when submit_failed THEN
721: hr_utility.set_location('error Leaving:'||l_proc, 80);
722: raise;
723: when others then
724: hr_utility.set_location(' error Leaving:'||l_proc, 80);
725: raise;
726: end exception_report_xml_process;
727:
728: