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;
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:
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: --
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);
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);
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);
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);
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);
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:
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:
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 :=
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,
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:
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;
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';
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:
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;
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;
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;
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;
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;
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;
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(
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