DBA Data[Home] [Help]

APPS.PQP_GENERIC_EIT_SS dependencies on HR_UTILITY

Line 457: WHEN hr_utility.hr_error THEN

453: END IF;
454:
455: END IF;
456: EXCEPTION
457: WHEN hr_utility.hr_error THEN
458: hr_utility.raise_error;
459: WHEN OTHERS THEN
460: RAISE; -- Raise error here relevant to the new tech stack.
461: END;

Line 458: hr_utility.raise_error;

454:
455: END IF;
456: EXCEPTION
457: WHEN hr_utility.hr_error THEN
458: hr_utility.raise_error;
459: WHEN OTHERS THEN
460: RAISE; -- Raise error here relevant to the new tech stack.
461: END;
462:

Line 506: hr_utility.set_location(' l_transaction_id: '||l_transaction_id,5 );

502: -- First, check if transaction id exists or not
503: l_transaction_id := hr_transaction_ss.get_transaction_id
504: (p_item_type => p_item_type
505: ,p_item_key => p_item_key);
506: hr_utility.set_location(' l_transaction_id: '||l_transaction_id,5 );
507: --
508:
509:
510: --

Line 559: hr_utility.set_location('..p_login_person_id'||p_login_person_id, 6);

555: l_transaction_table(l_count).param_name := 'P_KEY_ID';
556: l_transaction_table(l_count).param_value := p_key_id;
557: l_transaction_table(l_count).param_data_type := 'VARCHAR2';
558:
559: hr_utility.set_location('..p_login_person_id'||p_login_person_id, 6);
560: hr_utility.set_location('..p_assignment_id'||p_assignment_id, 6);
561: hr_utility.set_location('..p_eit_type'||p_eit_type, 6);
562: hr_utility.set_location('..p_eit_number'||p_eit_number, 6);
563: hr_utility.set_location('..p_business_group_id'||p_business_group_id, 6);

Line 560: hr_utility.set_location('..p_assignment_id'||p_assignment_id, 6);

556: l_transaction_table(l_count).param_value := p_key_id;
557: l_transaction_table(l_count).param_data_type := 'VARCHAR2';
558:
559: hr_utility.set_location('..p_login_person_id'||p_login_person_id, 6);
560: hr_utility.set_location('..p_assignment_id'||p_assignment_id, 6);
561: hr_utility.set_location('..p_eit_type'||p_eit_type, 6);
562: hr_utility.set_location('..p_eit_number'||p_eit_number, 6);
563: hr_utility.set_location('..p_business_group_id'||p_business_group_id, 6);
564: hr_utility.set_location('..p_eit_type_id'||p_eit_type_id, 6);

Line 561: hr_utility.set_location('..p_eit_type'||p_eit_type, 6);

557: l_transaction_table(l_count).param_data_type := 'VARCHAR2';
558:
559: hr_utility.set_location('..p_login_person_id'||p_login_person_id, 6);
560: hr_utility.set_location('..p_assignment_id'||p_assignment_id, 6);
561: hr_utility.set_location('..p_eit_type'||p_eit_type, 6);
562: hr_utility.set_location('..p_eit_number'||p_eit_number, 6);
563: hr_utility.set_location('..p_business_group_id'||p_business_group_id, 6);
564: hr_utility.set_location('..p_eit_type_id'||p_eit_type_id, 6);
565: hr_utility.set_location('..p_item_type'||p_item_type, 6);

Line 562: hr_utility.set_location('..p_eit_number'||p_eit_number, 6);

558:
559: hr_utility.set_location('..p_login_person_id'||p_login_person_id, 6);
560: hr_utility.set_location('..p_assignment_id'||p_assignment_id, 6);
561: hr_utility.set_location('..p_eit_type'||p_eit_type, 6);
562: hr_utility.set_location('..p_eit_number'||p_eit_number, 6);
563: hr_utility.set_location('..p_business_group_id'||p_business_group_id, 6);
564: hr_utility.set_location('..p_eit_type_id'||p_eit_type_id, 6);
565: hr_utility.set_location('..p_item_type'||p_item_type, 6);
566: hr_utility.set_location('..p_item_key'||p_item_key, 6);

Line 563: hr_utility.set_location('..p_business_group_id'||p_business_group_id, 6);

559: hr_utility.set_location('..p_login_person_id'||p_login_person_id, 6);
560: hr_utility.set_location('..p_assignment_id'||p_assignment_id, 6);
561: hr_utility.set_location('..p_eit_type'||p_eit_type, 6);
562: hr_utility.set_location('..p_eit_number'||p_eit_number, 6);
563: hr_utility.set_location('..p_business_group_id'||p_business_group_id, 6);
564: hr_utility.set_location('..p_eit_type_id'||p_eit_type_id, 6);
565: hr_utility.set_location('..p_item_type'||p_item_type, 6);
566: hr_utility.set_location('..p_item_key'||p_item_key, 6);
567: hr_utility.set_location('..p_activity_id'||p_activity_id, 6);

Line 564: hr_utility.set_location('..p_eit_type_id'||p_eit_type_id, 6);

560: hr_utility.set_location('..p_assignment_id'||p_assignment_id, 6);
561: hr_utility.set_location('..p_eit_type'||p_eit_type, 6);
562: hr_utility.set_location('..p_eit_number'||p_eit_number, 6);
563: hr_utility.set_location('..p_business_group_id'||p_business_group_id, 6);
564: hr_utility.set_location('..p_eit_type_id'||p_eit_type_id, 6);
565: hr_utility.set_location('..p_item_type'||p_item_type, 6);
566: hr_utility.set_location('..p_item_key'||p_item_key, 6);
567: hr_utility.set_location('..p_activity_id'||p_activity_id, 6);
568:

Line 565: hr_utility.set_location('..p_item_type'||p_item_type, 6);

561: hr_utility.set_location('..p_eit_type'||p_eit_type, 6);
562: hr_utility.set_location('..p_eit_number'||p_eit_number, 6);
563: hr_utility.set_location('..p_business_group_id'||p_business_group_id, 6);
564: hr_utility.set_location('..p_eit_type_id'||p_eit_type_id, 6);
565: hr_utility.set_location('..p_item_type'||p_item_type, 6);
566: hr_utility.set_location('..p_item_key'||p_item_key, 6);
567: hr_utility.set_location('..p_activity_id'||p_activity_id, 6);
568:
569:

Line 566: hr_utility.set_location('..p_item_key'||p_item_key, 6);

562: hr_utility.set_location('..p_eit_number'||p_eit_number, 6);
563: hr_utility.set_location('..p_business_group_id'||p_business_group_id, 6);
564: hr_utility.set_location('..p_eit_type_id'||p_eit_type_id, 6);
565: hr_utility.set_location('..p_item_type'||p_item_type, 6);
566: hr_utility.set_location('..p_item_key'||p_item_key, 6);
567: hr_utility.set_location('..p_activity_id'||p_activity_id, 6);
568:
569:
570: l_review_item_name :=

Line 567: hr_utility.set_location('..p_activity_id'||p_activity_id, 6);

563: hr_utility.set_location('..p_business_group_id'||p_business_group_id, 6);
564: hr_utility.set_location('..p_eit_type_id'||p_eit_type_id, 6);
565: hr_utility.set_location('..p_item_type'||p_item_type, 6);
566: hr_utility.set_location('..p_item_key'||p_item_key, 6);
567: hr_utility.set_location('..p_activity_id'||p_activity_id, 6);
568:
569:
570: l_review_item_name :=
571: wf_engine.GetActivityAttrText(itemtype => p_item_type,

Line 582: hr_utility.set_location('..l_review_item_name'||l_review_item_name, 6);

578: l_transaction_table(l_count).param_name := 'P_REVIEW_PROC_CALL';
579: l_transaction_table(l_count).param_value := l_review_proc_call;
580: l_transaction_table(l_count).param_data_type := 'VARCHAR2';
581:
582: hr_utility.set_location('..l_review_item_name'||l_review_item_name, 6);
583: hr_utility.set_location('..p_active_view'||p_active_view, 6);
584: hr_utility.set_location('..p_active_row_id'||p_active_row_id, 6);
585:
586:

Line 583: hr_utility.set_location('..p_active_view'||p_active_view, 6);

579: l_transaction_table(l_count).param_value := l_review_proc_call;
580: l_transaction_table(l_count).param_data_type := 'VARCHAR2';
581:
582: hr_utility.set_location('..l_review_item_name'||l_review_item_name, 6);
583: hr_utility.set_location('..p_active_view'||p_active_view, 6);
584: hr_utility.set_location('..p_active_row_id'||p_active_row_id, 6);
585:
586:
587: l_count := l_count + 1;

Line 584: hr_utility.set_location('..p_active_row_id'||p_active_row_id, 6);

580: l_transaction_table(l_count).param_data_type := 'VARCHAR2';
581:
582: hr_utility.set_location('..l_review_item_name'||l_review_item_name, 6);
583: hr_utility.set_location('..p_active_view'||p_active_view, 6);
584: hr_utility.set_location('..p_active_row_id'||p_active_row_id, 6);
585:
586:
587: l_count := l_count + 1;
588: l_transaction_table(l_count).param_name := 'P_REVIEW_ACTID';

Line 611: hr_utility.set_location('..p_eit_table(i).action'||p_eit_table(i).action, 6);

607:
608: FOR i in 1..l_eit_number
609: LOOP
610:
611: hr_utility.set_location('..p_eit_table(i).action'||p_eit_table(i).action, 6);
612: hr_utility.set_location('..p_eit_table(i).action'||p_eit_table(i).extra_info_id, 6);
613: hr_utility.set_location('..p_eit_table(i).object_version_number'||p_eit_table(i).object_version_number, 6);
614: hr_utility.set_location('..p_eit_table(i).information_type'||p_eit_table(i).information_type, 6);
615:

Line 612: hr_utility.set_location('..p_eit_table(i).action'||p_eit_table(i).extra_info_id, 6);

608: FOR i in 1..l_eit_number
609: LOOP
610:
611: hr_utility.set_location('..p_eit_table(i).action'||p_eit_table(i).action, 6);
612: hr_utility.set_location('..p_eit_table(i).action'||p_eit_table(i).extra_info_id, 6);
613: hr_utility.set_location('..p_eit_table(i).object_version_number'||p_eit_table(i).object_version_number, 6);
614: hr_utility.set_location('..p_eit_table(i).information_type'||p_eit_table(i).information_type, 6);
615:
616: l_count := l_count + 1;

Line 613: hr_utility.set_location('..p_eit_table(i).object_version_number'||p_eit_table(i).object_version_number, 6);

609: LOOP
610:
611: hr_utility.set_location('..p_eit_table(i).action'||p_eit_table(i).action, 6);
612: hr_utility.set_location('..p_eit_table(i).action'||p_eit_table(i).extra_info_id, 6);
613: hr_utility.set_location('..p_eit_table(i).object_version_number'||p_eit_table(i).object_version_number, 6);
614: hr_utility.set_location('..p_eit_table(i).information_type'||p_eit_table(i).information_type, 6);
615:
616: l_count := l_count + 1;
617: l_transaction_table(l_count).param_name := 'P_ACTION_'||i;

Line 614: hr_utility.set_location('..p_eit_table(i).information_type'||p_eit_table(i).information_type, 6);

610:
611: hr_utility.set_location('..p_eit_table(i).action'||p_eit_table(i).action, 6);
612: hr_utility.set_location('..p_eit_table(i).action'||p_eit_table(i).extra_info_id, 6);
613: hr_utility.set_location('..p_eit_table(i).object_version_number'||p_eit_table(i).object_version_number, 6);
614: hr_utility.set_location('..p_eit_table(i).information_type'||p_eit_table(i).information_type, 6);
615:
616: l_count := l_count + 1;
617: l_transaction_table(l_count).param_name := 'P_ACTION_'||i;
618: l_transaction_table(l_count).param_value := p_eit_table(i).action;

Line 744: hr_utility.set_location('.inside loop '||p_eit_table(i).information_category, 6);

740: l_transaction_table(l_count).param_value := p_eit_table(i).attribute20;
741: l_transaction_table(l_count).param_data_type := 'VARCHAR2';
742:
743: ---Information Category Context
744: hr_utility.set_location('.inside loop '||p_eit_table(i).information_category, 6);
745: hr_utility.set_location('.inside loop information1'||p_eit_table(i).information1, 6);
746: hr_utility.set_location('.inside loop information1'||p_eit_table(i).information2, 6);
747:
748: l_count := l_count + 1;

Line 745: hr_utility.set_location('.inside loop information1'||p_eit_table(i).information1, 6);

741: l_transaction_table(l_count).param_data_type := 'VARCHAR2';
742:
743: ---Information Category Context
744: hr_utility.set_location('.inside loop '||p_eit_table(i).information_category, 6);
745: hr_utility.set_location('.inside loop information1'||p_eit_table(i).information1, 6);
746: hr_utility.set_location('.inside loop information1'||p_eit_table(i).information2, 6);
747:
748: l_count := l_count + 1;
749: l_transaction_table(l_count).param_name := 'P_INFORMATION_CATEGORY_'||i;

Line 746: hr_utility.set_location('.inside loop information1'||p_eit_table(i).information2, 6);

742:
743: ---Information Category Context
744: hr_utility.set_location('.inside loop '||p_eit_table(i).information_category, 6);
745: hr_utility.set_location('.inside loop information1'||p_eit_table(i).information1, 6);
746: hr_utility.set_location('.inside loop information1'||p_eit_table(i).information2, 6);
747:
748: l_count := l_count + 1;
749: l_transaction_table(l_count).param_name := 'P_INFORMATION_CATEGORY_'||i;
750: l_transaction_table(l_count).param_value := p_eit_table(i).information_category;

Line 1016: --hr_utility.trace_off;

1012:
1013: Commit;
1014:
1015:
1016: --hr_utility.trace_off;
1017: EXCEPTION
1018: -- Catch any exception thrown while storing transaction data
1019: WHEN OTHERS THEN
1020: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(

Line 1713: hr_utility.raise_error;

1709: --remove session
1710: hr_util_misc_web.remove_session_row();
1711:
1712: IF l_error_message is not null then
1713: hr_utility.raise_error;
1714: END IF;
1715:
1716: EXCEPTION
1717: WHEN OTHERS THEN