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

Line 176: -- hr_utility.trace_on(null , 'Enroll_Trace');

172: and per.person_id =p_sponsor_person_id;
173:
174: Begin
175:
176: -- hr_utility.trace_on(null , 'Enroll_Trace');
177: hr_utility.set_location(' Entering:' || l_proc,10);
178: hr_utility.trace('delegate person id : ' || p_delegate_person_id);
179: hr_utility.trace('P_CRT_UPD : ' || P_CRT_UPD);
180:

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

173:
174: Begin
175:
176: -- hr_utility.trace_on(null , 'Enroll_Trace');
177: hr_utility.set_location(' Entering:' || l_proc,10);
178: hr_utility.trace('delegate person id : ' || p_delegate_person_id);
179: hr_utility.trace('P_CRT_UPD : ' || P_CRT_UPD);
180:
181: if (P_CRT_UPD is not null) then

Line 178: hr_utility.trace('delegate person id : ' || p_delegate_person_id);

174: Begin
175:
176: -- hr_utility.trace_on(null , 'Enroll_Trace');
177: hr_utility.set_location(' Entering:' || l_proc,10);
178: hr_utility.trace('delegate person id : ' || p_delegate_person_id);
179: hr_utility.trace('P_CRT_UPD : ' || P_CRT_UPD);
180:
181: if (P_CRT_UPD is not null) then
182: g_crt_upd := P_CRT_UPD;

Line 179: hr_utility.trace('P_CRT_UPD : ' || P_CRT_UPD);

175:
176: -- hr_utility.trace_on(null , 'Enroll_Trace');
177: hr_utility.set_location(' Entering:' || l_proc,10);
178: hr_utility.trace('delegate person id : ' || p_delegate_person_id);
179: hr_utility.trace('P_CRT_UPD : ' || P_CRT_UPD);
180:
181: if (P_CRT_UPD is not null) then
182: g_crt_upd := P_CRT_UPD;
183: end if;

Line 196: hr_utility.trace('c_delegate_assignment_id '|| c_delegate_assignment_id);

192: FETCH spon_ass_id INTO c_sponsor_assignment_id;
193: CLOSE spon_ass_id;
194: end if;
195:
196: hr_utility.trace('c_delegate_assignment_id '|| c_delegate_assignment_id);
197: hr_utility.trace('c_sponsor_assignment_id '|| c_sponsor_assignment_id);
198:
199: hr_utility.trace('g_crt_upd : ' || g_crt_upd);
200:

Line 197: hr_utility.trace('c_sponsor_assignment_id '|| c_sponsor_assignment_id);

193: CLOSE spon_ass_id;
194: end if;
195:
196: hr_utility.trace('c_delegate_assignment_id '|| c_delegate_assignment_id);
197: hr_utility.trace('c_sponsor_assignment_id '|| c_sponsor_assignment_id);
198:
199: hr_utility.trace('g_crt_upd : ' || g_crt_upd);
200:
201:

Line 199: hr_utility.trace('g_crt_upd : ' || g_crt_upd);

195:
196: hr_utility.trace('c_delegate_assignment_id '|| c_delegate_assignment_id);
197: hr_utility.trace('c_sponsor_assignment_id '|| c_sponsor_assignment_id);
198:
199: hr_utility.trace('g_crt_upd : ' || g_crt_upd);
200:
201:
202:
203: --

Line 216: hr_utility.set_location('The booking_id is : ', l_booking_id);

212: else
213: l_create_flag := 1; --create booking
214: end if;
215:
216: hr_utility.set_location('The booking_id is : ', l_booking_id);
217:
218:
219:
220: hr_utility.trace('l_create_flag'||l_create_flag);

Line 220: hr_utility.trace('l_create_flag'||l_create_flag);

216: hr_utility.set_location('The booking_id is : ', l_booking_id);
217:
218:
219:
220: hr_utility.trace('l_create_flag'||l_create_flag);
221:
222:
223: if (g_crt_upd = 'D') then
224: raise e_upl_not_allowed; -- View only flag is enabled but Trying to Upload

Line 334: hr_utility.trace('SRK in wrapper_proc booking p_booking_id '|| l_booking);

330:
331: if(l_create_flag = 2) then
332:
333:
334: hr_utility.trace('SRK in wrapper_proc booking p_booking_id '|| l_booking);
335:
336: --p_object_version_number := 1;
337: hr_utility.trace('SRK in wrapper_proc before update p_object_version_number '|| p_object_version_number);
338:

Line 337: hr_utility.trace('SRK in wrapper_proc before update p_object_version_number '|| p_object_version_number);

333:
334: hr_utility.trace('SRK in wrapper_proc booking p_booking_id '|| l_booking);
335:
336: --p_object_version_number := 1;
337: hr_utility.trace('SRK in wrapper_proc before update p_object_version_number '|| p_object_version_number);
338:
339: select object_version_number into l_object_version_number
340: from ota_delegate_bookings where
341: booking_id = l_booking_id;

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

450: --
451: -- p_object_version_number := null;
452: -- p_finance_line_id := l_finance_line_id;
453: -- p_return_status := hr_multi_message.get_return_status_disable;
454: -- hr_utility.set_location(' Leaving:' || l_proc, 30);
455: -- when others then
456: --
457: -- When Multiple Message Detection is enabled catch
458: -- any Application specific or other unexpected

Line 467: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

463: -- rollback to enrollment_proc;
464:
465:
466: when e_upl_not_allowed then
467: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
468: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
469: hr_utility.set_location('Leaving: ' || l_proc, 90);
470: hr_utility.raise_error;
471: when e_crt_not_allowed then

Line 468: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);

464:
465:
466: when e_upl_not_allowed then
467: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
468: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
469: hr_utility.set_location('Leaving: ' || l_proc, 90);
470: hr_utility.raise_error;
471: when e_crt_not_allowed then
472: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

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

465:
466: when e_upl_not_allowed then
467: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
468: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
469: hr_utility.set_location('Leaving: ' || l_proc, 90);
470: hr_utility.raise_error;
471: when e_crt_not_allowed then
472: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
473: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);

Line 470: hr_utility.raise_error;

466: when e_upl_not_allowed then
467: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
468: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
469: hr_utility.set_location('Leaving: ' || l_proc, 90);
470: hr_utility.raise_error;
471: when e_crt_not_allowed then
472: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
473: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
474: hr_utility.set_location('Leaving: ' || l_proc, 100);

Line 472: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

468: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
469: hr_utility.set_location('Leaving: ' || l_proc, 90);
470: hr_utility.raise_error;
471: when e_crt_not_allowed then
472: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
473: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
474: hr_utility.set_location('Leaving: ' || l_proc, 100);
475: hr_utility.raise_error;
476: when others then

Line 473: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);

469: hr_utility.set_location('Leaving: ' || l_proc, 90);
470: hr_utility.raise_error;
471: when e_crt_not_allowed then
472: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
473: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
474: hr_utility.set_location('Leaving: ' || l_proc, 100);
475: hr_utility.raise_error;
476: when others then
477: --l_error_msg := Substr(SQLERRM,1,2000);

Line 474: hr_utility.set_location('Leaving: ' || l_proc, 100);

470: hr_utility.raise_error;
471: when e_crt_not_allowed then
472: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
473: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
474: hr_utility.set_location('Leaving: ' || l_proc, 100);
475: hr_utility.raise_error;
476: when others then
477: --l_error_msg := Substr(SQLERRM,1,2000);
478: hr_utility.set_location('SQLCODE :' || SQLCODE,90);

Line 475: hr_utility.raise_error;

471: when e_crt_not_allowed then
472: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
473: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
474: hr_utility.set_location('Leaving: ' || l_proc, 100);
475: hr_utility.raise_error;
476: when others then
477: --l_error_msg := Substr(SQLERRM,1,2000);
478: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
479: hr_utility.set_location('SQLERRM :' || SQLERRM,90);

Line 478: hr_utility.set_location('SQLCODE :' || SQLCODE,90);

474: hr_utility.set_location('Leaving: ' || l_proc, 100);
475: hr_utility.raise_error;
476: when others then
477: --l_error_msg := Substr(SQLERRM,1,2000);
478: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
479: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
480: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
481: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
482: hr_utility.set_location('Leaving: ' || l_proc, 110);

Line 479: hr_utility.set_location('SQLERRM :' || SQLERRM,90);

475: hr_utility.raise_error;
476: when others then
477: --l_error_msg := Substr(SQLERRM,1,2000);
478: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
479: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
480: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
481: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
482: hr_utility.set_location('Leaving: ' || l_proc, 110);
483: hr_utility.raise_error;

Line 480: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

476: when others then
477: --l_error_msg := Substr(SQLERRM,1,2000);
478: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
479: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
480: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
481: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
482: hr_utility.set_location('Leaving: ' || l_proc, 110);
483: hr_utility.raise_error;
484: --if hr_multi_message.unexpected_error_add(l_proc) then

Line 481: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );

477: --l_error_msg := Substr(SQLERRM,1,2000);
478: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
479: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
480: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
481: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
482: hr_utility.set_location('Leaving: ' || l_proc, 110);
483: hr_utility.raise_error;
484: --if hr_multi_message.unexpected_error_add(l_proc) then
485: -- hr_utility.set_location(' Leaving:' || l_proc,40);

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

478: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
479: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
480: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
481: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
482: hr_utility.set_location('Leaving: ' || l_proc, 110);
483: hr_utility.raise_error;
484: --if hr_multi_message.unexpected_error_add(l_proc) then
485: -- hr_utility.set_location(' Leaving:' || l_proc,40);
486: --raise;

Line 483: hr_utility.raise_error;

479: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
480: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
481: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
482: hr_utility.set_location('Leaving: ' || l_proc, 110);
483: hr_utility.raise_error;
484: --if hr_multi_message.unexpected_error_add(l_proc) then
485: -- hr_utility.set_location(' Leaving:' || l_proc,40);
486: --raise;
487: --end if;

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

481: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
482: hr_utility.set_location('Leaving: ' || l_proc, 110);
483: hr_utility.raise_error;
484: --if hr_multi_message.unexpected_error_add(l_proc) then
485: -- hr_utility.set_location(' Leaving:' || l_proc,40);
486: --raise;
487: --end if;
488: --
489: -- Reset IN OUT and set OUT parameters

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

490: --
491: -- p_object_version_number := null;
492: -- p_finance_line_id := l_finance_line_id;
493: --p_return_status := hr_multi_message.get_return_status_disable;
494: -- hr_utility.set_location(' Leaving:' || l_proc,50);
495:
496: end InsUpd_Enroll;
497:
498:

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

598: -- Other variables
599: l_booking_id number;
600: l_proc varchar2(72) := g_package ||'create_delegate_booking';
601: Begin
602: hr_utility.set_location(' Entering:' || l_proc,10);
603: --
604: -- Issue a savepoint
605: --
606: savepoint create_delegate_booking;

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

730: -- messages of any type exist in the Multiple Message List.
731: -- Also disable Multiple Message Detection.
732: --
733: p_return_status := hr_multi_message.get_return_status_disable;
734: hr_utility.set_location(' Leaving:' || l_proc,20);
735: --
736: exception
737: when hr_multi_message.error_message_exist then
738: --

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

746: --
747: p_object_version_number := null;
748: p_finance_line_id := l_finance_line_id;
749: p_return_status := hr_multi_message.get_return_status_disable;
750: hr_utility.set_location(' Leaving:' || l_proc, 30);
751: when others then
752: --
753: -- When Multiple Message Detection is enabled catch
754: -- any Application specific or other unexpected

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

757: -- error.
758: --
759: rollback to create_delegate_booking;
760: -- if hr_multi_message.unexpected_error_add(l_proc) then
761: hr_utility.set_location(' Leaving:' || l_proc,40);
762: raise;
763: -- end if;
764: --
765: -- Reset IN OUT and set OUT parameters

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

766: --
767: p_object_version_number := null;
768: p_finance_line_id := l_finance_line_id;
769: p_return_status := hr_multi_message.get_return_status_disable;
770: hr_utility.set_location(' Leaving:' || l_proc,50);
771: end create_delegate_booking;
772:
773:
774: PROCEDURE update_delegate_booking

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

888:
889: -- Other variables
890: l_proc varchar2(72) := g_package ||'update_delegate_booking';
891: Begin
892: hr_utility.set_location(' Entering:' || l_proc,10);
893: --
894: -- Issue a savepoint
895: --
896: savepoint update_delegate_booking;

Line 909: hr_utility.trace('SRK in update_deleg_booki booking p_booking_id '|| p_booking_id);

905: l_tfl_object_version_number := p_tfl_object_version_number;
906: l_finance_line_id := p_finance_line_id;
907: --
908: --
909: hr_utility.trace('SRK in update_deleg_booki booking p_booking_id '|| p_booking_id);
910: OPEN booking_csr;
911: FETCH booking_csr INTO l_date_booking_placed;
912: CLOSE booking_csr;
913: l_date_status_changed := trunc(sysdate);

Line 926: hr_utility.trace('SRK in update_deleg_booki before the api call p_booking_id '|| p_booking_id);

922: --
923: --
924: -- Call API
925: --
926: hr_utility.trace('SRK in update_deleg_booki before the api call p_booking_id '|| p_booking_id);
927: ota_delegate_booking_api.update_delegate_booking
928: (p_effective_date => p_effective_date
929: ,p_booking_id => p_booking_id
930: ,p_booking_status_type_id => p_booking_status_type_id

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

1029: -- messages of any type exist in the Multiple Message List.
1030: -- Also disable Multiple Message Detection.
1031: --
1032: p_return_status := hr_multi_message.get_return_status_disable;
1033: hr_utility.set_location(' Leaving:' || l_proc,20);
1034: --
1035: end update_delegate_booking;
1036:
1037: