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.

[Home] [Help]

APPS.HR_PROCESS_EIT_SS dependencies on HR_UTILITY

Line 49: hr_utility.set_location('Entering:'||l_proc, 5);

45: l_eit_number number := 0;
46: l_proc varchar2(72) := g_package||'save_transaction_data';
47:
48: BEGIN
49: hr_utility.set_location('Entering:'||l_proc, 5);
50: if p_flow_mode is not null and
51: p_flow_mode = hr_process_assignment_ss.g_new_hire_registration
52: then
53: hr_utility.trace('Calling RollBack:'||l_proc);

Line 53: hr_utility.trace('Calling RollBack:'||l_proc);

49: hr_utility.set_location('Entering:'||l_proc, 5);
50: if p_flow_mode is not null and
51: p_flow_mode = hr_process_assignment_ss.g_new_hire_registration
52: then
53: hr_utility.trace('Calling RollBack:'||l_proc);
54: rollback;
55: end if;
56: --
57: -- First, check if transaction id exists or not

Line 62: hr_utility.trace( 'hr_process_eit_ss.save_transaction_data' ||

58: l_transaction_id := hr_transaction_ss.get_transaction_id
59: (p_item_type => p_item_type
60: ,p_item_key => p_item_key);
61:
62: hr_utility.trace( 'hr_process_eit_ss.save_transaction_data' ||
63: ' l_transaction_id: '|| l_transaction_id);
64:
65: --
66: IF l_transaction_id is null THEN

Line 69: hr_utility.trace('IF l_transaction_id is null THEN:'||l_proc);

65: --
66: IF l_transaction_id is null THEN
67:
68: -- Start a Transaction
69: hr_utility.trace('IF l_transaction_id is null THEN:'||l_proc);
70: hr_transaction_ss.start_transaction
71: (itemtype => p_item_type
72: ,itemkey => p_item_key
73: ,actid => p_activity_id

Line 85: hr_utility.trace('hr_process_eit_ss.save_transaction_data' ||

81: END IF;
82: --
83: -- Create a transaction step
84: --
85: hr_utility.trace('hr_process_eit_ss.save_transaction_data' ||
86: ' l_transaction_id: '||l_transaction_id);
87:
88:
89: hr_transaction_api.get_transaction_step_info

Line 96: if(hr_utility.debug_enabled) then

92: ,p_activity_id => p_activity_id
93: ,p_transaction_step_id => l_transaction_step_id
94: ,p_object_version_number => l_trs_object_version_number);
95:
96: if(hr_utility.debug_enabled) then
97:
98: hr_utility.trace('hr_process_eit_ss.save_transaction_data' ||
99: ' l_transaction_id: '||l_transaction_id||
100: ' p_Item_Type: '||p_Item_Type||

Line 98: hr_utility.trace('hr_process_eit_ss.save_transaction_data' ||

94: ,p_object_version_number => l_trs_object_version_number);
95:
96: if(hr_utility.debug_enabled) then
97:
98: hr_utility.trace('hr_process_eit_ss.save_transaction_data' ||
99: ' l_transaction_id: '||l_transaction_id||
100: ' p_Item_Type: '||p_Item_Type||
101: ' p_Item_Key: '||p_Item_Key||
102: ' p_activity_id: '||p_activity_id||

Line 109: hr_utility.trace('l_transaction_step_id < 1:'||l_proc);

105: );
106: end if;
107:
108: IF l_transaction_step_id < 1 THEN
109: hr_utility.trace('l_transaction_step_id < 1:'||l_proc);
110:
111: --There is no transaction step for this transaction.
112: --Create a step within this new transaction
113: hr_transaction_api.create_transaction_step

Line 125: hr_utility.trace('hr_process_eit_ss.save_transaction_data' ||

121: ,p_transaction_step_id => l_transaction_step_id
122: ,p_object_version_number => l_trs_object_version_number);
123: END IF;
124:
125: hr_utility.trace('hr_process_eit_ss.save_transaction_data' ||
126: ' l_transaction_step_id: '||l_transaction_step_id
127: );
128:
129:

Line 184: if(hr_utility.debug_enabled) then

180: l_transaction_table(l_count).param_name := 'P_ACTIVE_ROW_ID';
181: l_transaction_table(l_count).param_value := p_active_row_id;
182: l_transaction_table(l_count).param_data_type := 'NUMBER';
183:
184: if(hr_utility.debug_enabled) then
185:
186: hr_utility.trace('hr_process_eit_ss.save_transaction_data' ||
187: ' p_person_id: '||p_person_id||
188: ' p_login_person_id: '||p_login_person_id||

Line 186: hr_utility.trace('hr_process_eit_ss.save_transaction_data' ||

182: l_transaction_table(l_count).param_data_type := 'NUMBER';
183:
184: if(hr_utility.debug_enabled) then
185:
186: hr_utility.trace('hr_process_eit_ss.save_transaction_data' ||
187: ' p_person_id: '||p_person_id||
188: ' p_login_person_id: '||p_login_person_id||
189: ' p_eit_type: '||p_eit_type||
190: ' p_eit_number: '||p_eit_number);

Line 195: hr_utility.trace('Entering For 1..l_eit_number:'||l_proc);

191: end if;
192:
193: l_eit_number := p_eit_number;
194:
195: hr_utility.trace('Entering For 1..l_eit_number:'||l_proc);
196: FOR i in 1..l_eit_number LOOP
197:
198:
199:

Line 487: hr_utility.trace('Exiting For Loop:'||l_proc);

483: --
484: -- This is a marker for the contact person to be used to identify the Address
485: -- to be retrieved for the contact person in context in review page.
486: END LOOP;
487: hr_utility.trace('Exiting For Loop:'||l_proc);
488:
489: dump_eit_table(p_eit_table);
490:
491: hr_transaction_ss.save_transaction_step

Line 501: hr_utility.set_location('Exiting:'||l_proc, 35);

497: ,p_transaction_step_id => l_transaction_step_id
498: ,p_api_name => g_package || '.PROCESS_API'
499: ,p_transaction_data => l_transaction_table);
500:
501: hr_utility.set_location('Exiting:'||l_proc, 35);
502:
503:
504:
505:

Line 509: hr_utility.set_location('Exception:Others'||l_proc,555);

505:
506: EXCEPTION
507: -- Catch any exception thrown while storing transaction data
508: WHEN OTHERS THEN
509: hr_utility.set_location('Exception:Others'||l_proc,555);
510: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
511: p_error_message => p_error_message);
512:
513: hr_utility.trace('hr_process_eit_ss.get_eit_data_from_tt' ||

Line 513: hr_utility.trace('hr_process_eit_ss.get_eit_data_from_tt' ||

509: hr_utility.set_location('Exception:Others'||l_proc,555);
510: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
511: p_error_message => p_error_message);
512:
513: hr_utility.trace('hr_process_eit_ss.get_eit_data_from_tt' ||
514: ' p_error_message: '||p_error_message);
515:
516:
517:

Line 559: hr_utility.set_location('Entering:'||l_proc, 5);

555: -- transaction. This is used for re-display the Update page when a user
556: -- clicks the Back button on the Review page to go back to the Update page
557: -- to make further changes or to correct errors.
558: -----------------------------------------------------------------------------
559: hr_utility.set_location('Entering:'||l_proc, 5);
560: hr_utility.trace(
561: 'hr_process_eit_ss.get_eit_data_from_tt' ||
562: ' p_item_type: '||p_item_type||
563: ' p_item_key: '||p_item_key||

Line 560: hr_utility.trace(

556: -- clicks the Back button on the Review page to go back to the Update page
557: -- to make further changes or to correct errors.
558: -----------------------------------------------------------------------------
559: hr_utility.set_location('Entering:'||l_proc, 5);
560: hr_utility.trace(
561: 'hr_process_eit_ss.get_eit_data_from_tt' ||
562: ' p_item_type: '||p_item_type||
563: ' p_item_key: '||p_item_key||
564: ' p_activity_id: '||p_activity_id);

Line 573: hr_utility.trace(

569: ,p_activity_id => p_activity_id
570: ,p_transaction_step_id => l_trans_step_id
571: ,p_object_version_number => l_trans_obj_vers_num);
572:
573: hr_utility.trace(
574: 'hr_process_eit_ss.get_eit_data_from_tt' ||
575: ' l_trans_step_id: '||l_trans_step_id||
576: ' l_trans_obj_vers_num: '||l_trans_obj_vers_num);
577:

Line 582: hr_utility.trace('l_trans_step_id IS NOT NULL stepid>0:'||l_proc);

578:
579: IF l_trans_step_id IS NOT NULL OR
580: l_trans_step_id > 0
581: THEN
582: hr_utility.trace('l_trans_step_id IS NOT NULL stepid>0:'||l_proc);
583: l_trans_rec_count := 1;
584: ELSE
585: hr_utility.trace('l_trans_step_id IS NULL & l_trans_step_id <= 0'||l_proc);
586: l_trans_rec_count := 0;

Line 585: hr_utility.trace('l_trans_step_id IS NULL & l_trans_step_id <= 0'||l_proc);

581: THEN
582: hr_utility.trace('l_trans_step_id IS NOT NULL stepid>0:'||l_proc);
583: l_trans_rec_count := 1;
584: ELSE
585: hr_utility.trace('l_trans_step_id IS NULL & l_trans_step_id <= 0'||l_proc);
586: l_trans_rec_count := 0;
587: hr_utility.trace('Exiting:From Else part'||l_proc);
588: return;
589: END IF;

Line 587: hr_utility.trace('Exiting:From Else part'||l_proc);

583: l_trans_rec_count := 1;
584: ELSE
585: hr_utility.trace('l_trans_step_id IS NULL & l_trans_step_id <= 0'||l_proc);
586: l_trans_rec_count := 0;
587: hr_utility.trace('Exiting:From Else part'||l_proc);
588: return;
589: END IF;
590:
591: --

Line 611: hr_utility.trace(

607: ,p_active_view => p_active_view
608: ,p_active_row_id => p_active_row_id
609: );
610:
611: hr_utility.trace(
612: 'hr_process_eit_ss.get_eit_data_from_tt' ||
613: ' p_error_message: '||p_error_message);
614:
615: p_trans_rec_count := l_trans_rec_count;

Line 616: hr_utility.set_location('Exiting:Funtion'||l_proc, 25);

612: 'hr_process_eit_ss.get_eit_data_from_tt' ||
613: ' p_error_message: '||p_error_message);
614:
615: p_trans_rec_count := l_trans_rec_count;
616: hr_utility.set_location('Exiting:Funtion'||l_proc, 25);
617:
618: EXCEPTION
619: -- Catch any exception thrown while storing transaction data
620: WHEN OTHERS THEN

Line 621: hr_utility.set_location('Exception:Others'||l_proc,555);

617:
618: EXCEPTION
619: -- Catch any exception thrown while storing transaction data
620: WHEN OTHERS THEN
621: hr_utility.set_location('Exception:Others'||l_proc,555);
622: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
623: p_error_message => p_error_message);
624: hr_utility.trace(
625: 'hr_process_eit_ss.get_eit_data_from_tt' ||

Line 624: hr_utility.trace(

620: WHEN OTHERS THEN
621: hr_utility.set_location('Exception:Others'||l_proc,555);
622: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
623: p_error_message => p_error_message);
624: hr_utility.trace(
625: 'hr_process_eit_ss.get_eit_data_from_tt' ||
626: ' p_error_message: '||p_error_message);
627:
628:

Line 656: hr_utility.set_location('Entering:'||l_proc, 5);

652: l_proc varchar2(72) := g_package||'get_eit_data_from_tt';
653:
654: begin
655:
656: hr_utility.set_location('Entering:'||l_proc, 5);
657: hr_utility.trace(
658: 'hr_process_eit_ss.get_eit_data_from_tt' ||
659: ' p_transaction_step_id: '||p_transaction_step_id);
660:

Line 657: hr_utility.trace(

653:
654: begin
655:
656: hr_utility.set_location('Entering:'||l_proc, 5);
657: hr_utility.trace(
658: 'hr_process_eit_ss.get_eit_data_from_tt' ||
659: ' p_transaction_step_id: '||p_transaction_step_id);
660:
661:

Line 691: hr_utility.trace('AsgId<>NULL or PID<>NULL AND SESSIONID=ICX_SEC.G_SESSION_ID:'||l_proc);

687: if (( hr_process_person_ss.g_assignment_id is not null
688: or hr_process_person_ss.g_person_id is not null) and
689: (hr_process_person_ss.g_session_id= ICX_SEC.G_SESSION_ID))
690: then
691: hr_utility.trace('AsgId<>NULL or PID<>NULL AND SESSIONID=ICX_SEC.G_SESSION_ID:'||l_proc);
692: if p_eit_type = 'PERSON' then
693: p_eit_type_id := hr_process_person_ss.g_person_id;
694: else
695: p_eit_type_id := hr_process_person_ss.g_assignment_id;

Line 715: if(hr_utility.debug_enabled) then

711: p_active_row_id := hr_transaction_api.get_number_value
712: (p_transaction_step_id => p_transaction_step_id
713: ,p_name => 'P_ACTIVE_ROW_ID');
714:
715: if(hr_utility.debug_enabled) then
716:
717: hr_utility.trace(
718: 'hr_process_eit_ss.get_eit_data_from_tt' ||
719: ' p_person_id: '||p_person_id||

Line 717: hr_utility.trace(

713: ,p_name => 'P_ACTIVE_ROW_ID');
714:
715: if(hr_utility.debug_enabled) then
716:
717: hr_utility.trace(
718: 'hr_process_eit_ss.get_eit_data_from_tt' ||
719: ' p_person_id: '||p_person_id||
720: ' p_login_person_id: '||p_login_person_id||
721: ' p_eit_type: '||p_eit_type||

Line 733: hr_utility.trace('For :1 ..l_number_eit'||l_proc);

729:
730: l_eit_table := HR_EIT_STRUCTURE_TABLE();
731:
732:
733: hr_utility.trace('For :1 ..l_number_eit'||l_proc);
734: FOR i in 1 ..l_number_eit LOOP
735: --
736: l_eit_table.extend;
737:

Line 738: -- hr_utility.trace(

734: FOR i in 1 ..l_number_eit LOOP
735: --
736: l_eit_table.extend;
737:
738: -- hr_utility.trace(
739: -- 'hr_process_eit_ss.get_eit_data_from_tt' ||
740: -- ' i : '||i);
741: --
742: l_eit_table(i) := HR_EIT_STRUCTURE_TYPE

Line 1025: hr_utility.trace('End of FOR:'||l_proc);

1021: (p_transaction_step_id => p_transaction_step_id
1022: ,p_name => 'P_INFORMATION30_'||i));
1023:
1024: END LOOP;
1025: hr_utility.trace('End of FOR:'||l_proc);
1026: p_eit_table := l_eit_table;
1027: dump_eit_table(p_eit_table);
1028: hr_utility.set_location('Exiting:'||l_proc, 30);
1029:

Line 1028: hr_utility.set_location('Exiting:'||l_proc, 30);

1024: END LOOP;
1025: hr_utility.trace('End of FOR:'||l_proc);
1026: p_eit_table := l_eit_table;
1027: dump_eit_table(p_eit_table);
1028: hr_utility.set_location('Exiting:'||l_proc, 30);
1029:
1030: EXCEPTION
1031: -- Catch any exception thrown while storing transaction data
1032: WHEN OTHERS THEN

Line 1033: hr_utility.set_location('Exception:Others'||l_proc,555);

1029:
1030: EXCEPTION
1031: -- Catch any exception thrown while storing transaction data
1032: WHEN OTHERS THEN
1033: hr_utility.set_location('Exception:Others'||l_proc,555);
1034: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
1035: p_error_message => p_error_message);
1036:
1037: END get_eit_data_from_tt;

Line 1060: hr_utility.set_location('Entering:'||l_proc, 5);

1056: l_proc varchar2(72) := g_package||'del_transaction_data';
1057:
1058: BEGIN
1059:
1060: hr_utility.set_location('Entering:'||l_proc, 5);
1061: if p_flow_mode is not null and
1062: p_flow_mode = hr_process_assignment_ss.g_new_hire_registration
1063:
1064: then

Line 1065: hr_utility.trace('p_flow_mode is not null but is NewHireReg:'||l_proc);

1061: if p_flow_mode is not null and
1062: p_flow_mode = hr_process_assignment_ss.g_new_hire_registration
1063:
1064: then
1065: hr_utility.trace('p_flow_mode is not null but is NewHireReg:'||l_proc);
1066: hr_utility.trace('Rolling back:'||l_proc);
1067: rollback;
1068: end if;
1069: if(hr_utility.debug_enabled) then

Line 1066: hr_utility.trace('Rolling back:'||l_proc);

1062: p_flow_mode = hr_process_assignment_ss.g_new_hire_registration
1063:
1064: then
1065: hr_utility.trace('p_flow_mode is not null but is NewHireReg:'||l_proc);
1066: hr_utility.trace('Rolling back:'||l_proc);
1067: rollback;
1068: end if;
1069: if(hr_utility.debug_enabled) then
1070:

Line 1069: if(hr_utility.debug_enabled) then

1065: hr_utility.trace('p_flow_mode is not null but is NewHireReg:'||l_proc);
1066: hr_utility.trace('Rolling back:'||l_proc);
1067: rollback;
1068: end if;
1069: if(hr_utility.debug_enabled) then
1070:
1071: hr_utility.trace(
1072: 'hr_process_eit_ss.del_transaction_data' ||
1073: ' p_item_type: '||p_item_type||

Line 1071: hr_utility.trace(

1067: rollback;
1068: end if;
1069: if(hr_utility.debug_enabled) then
1070:
1071: hr_utility.trace(
1072: 'hr_process_eit_ss.del_transaction_data' ||
1073: ' p_item_type: '||p_item_type||
1074: ' p_item_key: '||p_item_key||
1075: ' p_activity_id: '||p_activity_id||

Line 1086: hr_utility.set_location('Exiting:'||l_proc, 20);

1082: ,p_actid => p_activity_id
1083: ,p_login_person_id => p_login_person_id
1084: );
1085:
1086: hr_utility.set_location('Exiting:'||l_proc, 20);
1087: END del_transaction_data;
1088:
1089: -- ----------------------------------------------------------------------------
1090: -- |----------------------------< process_api >-------------------------------|

Line 1114: hr_utility.set_location('Entering:'||l_proc, 5);

1110: l_proc varchar2(72) := g_package||'PROCESS_API';
1111:
1112: BEGIN
1113:
1114: hr_utility.set_location('Entering:'||l_proc, 5);
1115: hr_utility.trace(
1116: 'hr_process_eit_ss.process_api' ||
1117: ' p_transaction_step_id: ');--||p_transaction_step_id);
1118:

Line 1115: hr_utility.trace(

1111:
1112: BEGIN
1113:
1114: hr_utility.set_location('Entering:'||l_proc, 5);
1115: hr_utility.trace(
1116: 'hr_process_eit_ss.process_api' ||
1117: ' p_transaction_step_id: ');--||p_transaction_step_id);
1118:
1119: --insert session because some flex uses the session effective date.

Line 1121: hr_utility.trace('EffDate!=Null:'||l_proc);

1117: ' p_transaction_step_id: ');--||p_transaction_step_id);
1118:
1119: --insert session because some flex uses the session effective date.
1120: if p_effective_date is not null then
1121: hr_utility.trace('EffDate!=Null:'||l_proc);
1122: hr_util_misc_web.insert_session_row(to_date(p_effective_date, 'RRRR-MM-DD'));
1123: else
1124: hr_utility.trace('EffDate==Null:'||l_proc);
1125: hr_util_misc_web.insert_session_row(SYSDATE);

Line 1124: hr_utility.trace('EffDate==Null:'||l_proc);

1120: if p_effective_date is not null then
1121: hr_utility.trace('EffDate!=Null:'||l_proc);
1122: hr_util_misc_web.insert_session_row(to_date(p_effective_date, 'RRRR-MM-DD'));
1123: else
1124: hr_utility.trace('EffDate==Null:'||l_proc);
1125: hr_util_misc_web.insert_session_row(SYSDATE);
1126: end if;
1127:
1128: get_eit_data_from_tt

Line 1142: if(hr_utility.debug_enabled)then

1138: ,p_active_row_id => l_active_row_id
1139: );
1140:
1141: --debug
1142: if(hr_utility.debug_enabled)then
1143:
1144: hr_utility.trace(
1145: 'hr_process_eit_ss.process_api' ||
1146: ' p_person_id: '||l_person_id||

Line 1144: hr_utility.trace(

1140:
1141: --debug
1142: if(hr_utility.debug_enabled)then
1143:
1144: hr_utility.trace(
1145: 'hr_process_eit_ss.process_api' ||
1146: ' p_person_id: '||l_person_id||
1147: ' p_login_person_id: '||l_login_person_id||
1148: ' p_eit_type: '||l_eit_type||

Line 1154: hr_utility.trace('Before DumpingEIT table:'||l_proc);

1150: ' p_eit_number: '||l_eit_number);
1151: end if;
1152:
1153:
1154: hr_utility.trace('Before DumpingEIT table:'||l_proc);
1155: dump_eit_table(l_eit_table);
1156:
1157: hr_utility.trace('FOR j IN 1..2'||l_proc);
1158: FOR j IN 1..2 LOOP

Line 1157: hr_utility.trace('FOR j IN 1..2'||l_proc);

1153:
1154: hr_utility.trace('Before DumpingEIT table:'||l_proc);
1155: dump_eit_table(l_eit_table);
1156:
1157: hr_utility.trace('FOR j IN 1..2'||l_proc);
1158: FOR j IN 1..2 LOOP
1159: l_index := l_eit_table.first;
1160: LOOP
1161: EXIT WHEN

Line 1164: hr_utility.trace('End of FOR '||l_proc);

1160: LOOP
1161: EXIT WHEN
1162: (NOT l_eit_table.exists(l_index));
1163:
1164: hr_utility.trace('End of FOR '||l_proc);
1165:
1166: hr_utility.trace(
1167: 'hr_process_eit_ss.process_api' ||
1168: ' l_index: '||l_index);

Line 1166: hr_utility.trace(

1162: (NOT l_eit_table.exists(l_index));
1163:
1164: hr_utility.trace('End of FOR '||l_proc);
1165:
1166: hr_utility.trace(
1167: 'hr_process_eit_ss.process_api' ||
1168: ' l_index: '||l_index);
1169:
1170: IF j = 1 AND l_eit_table(l_index).action = 'DELETE_ROW'

Line 1175: -- hr_utility.trace('l_eit_table(l_index).action=NEW ROW'||l_proc);

1171: OR j = 2 and l_eit_table(l_index).action <> 'DELETE_ROW' THEN
1172:
1173:
1174: IF l_eit_table(l_index).action = 'NEW_ROW' THEN
1175: -- hr_utility.trace('l_eit_table(l_index).action=NEW ROW'||l_proc);
1176:
1177: -- hr_utility.trace(
1178: -- 'hr_process_eit_ss.process_api' ||
1179: -- ' create a row: ');

Line 1177: -- hr_utility.trace(

1173:
1174: IF l_eit_table(l_index).action = 'NEW_ROW' THEN
1175: -- hr_utility.trace('l_eit_table(l_index).action=NEW ROW'||l_proc);
1176:
1177: -- hr_utility.trace(
1178: -- 'hr_process_eit_ss.process_api' ||
1179: -- ' create a row: ');
1180:
1181: create_eit

Line 1253: -- hr_utility.trace(

1249: ,p_save_mode => null
1250: ,p_error_message => l_error_message
1251: );
1252:
1253: -- hr_utility.trace(
1254: -- 'hr_process_eit_ss.process_api' ||
1255: -- ' create a row with extra info type id'||l_extra_info_id);
1256:
1257:

Line 1259: -- hr_utility.trace('l_eit_table(l_index).action=UPDATE_ROW'||l_proc);

1255: -- ' create a row with extra info type id'||l_extra_info_id);
1256:
1257:
1258: ELSIF l_eit_table(l_index).action = 'UPDATE_ROW' THEN
1259: -- hr_utility.trace('l_eit_table(l_index).action=UPDATE_ROW'||l_proc);
1260:
1261: -- hr_utility.trace(
1262: -- 'hr_process_eit_ss.process_api' ||
1263: -- ' update a row with extra info type id'||l_eit_table(l_index).extra_info_id);

Line 1261: -- hr_utility.trace(

1257:
1258: ELSIF l_eit_table(l_index).action = 'UPDATE_ROW' THEN
1259: -- hr_utility.trace('l_eit_table(l_index).action=UPDATE_ROW'||l_proc);
1260:
1261: -- hr_utility.trace(
1262: -- 'hr_process_eit_ss.process_api' ||
1263: -- ' update a row with extra info type id'||l_eit_table(l_index).extra_info_id);
1264:
1265: update_eit

Line 1339: -- hr_utility.trace('l_eit_table(l_index).action=DELETE_ROW:'||l_proc);

1335: );
1336:
1337: ELSIF l_eit_table(l_index).action = 'DELETE_ROW' THEN
1338:
1339: -- hr_utility.trace('l_eit_table(l_index).action=DELETE_ROW:'||l_proc);
1340: -- hr_utility.trace(
1341: -- 'hr_process_eit_ss.process_api' ||
1342: -- ' delete a row with extra info type id'||l_eit_table(l_index).extra_info_id);
1343:

Line 1340: -- hr_utility.trace(

1336:
1337: ELSIF l_eit_table(l_index).action = 'DELETE_ROW' THEN
1338:
1339: -- hr_utility.trace('l_eit_table(l_index).action=DELETE_ROW:'||l_proc);
1340: -- hr_utility.trace(
1341: -- 'hr_process_eit_ss.process_api' ||
1342: -- ' delete a row with extra info type id'||l_eit_table(l_index).extra_info_id);
1343:
1344: delete_eit

Line 1367: -- hr_utility.trace(

1363:
1364: END IF;
1365: END IF;
1366:
1367: -- hr_utility.trace(
1368: -- 'hr_process_eit_ss.process_api' ||
1369: -- ' l_error_message: '||l_error_message);
1370:
1371: l_index := l_eit_table.next(l_index);

Line 1380: hr_utility.raise_error;

1376: --remove session
1377: hr_util_misc_web.remove_session_row();
1378:
1379: if l_error_message is not null then
1380: hr_utility.raise_error;
1381: end if;
1382: hr_utility.set_location('Exiting:'||l_proc, 40);
1383:
1384: EXCEPTION

Line 1382: hr_utility.set_location('Exiting:'||l_proc, 40);

1378:
1379: if l_error_message is not null then
1380: hr_utility.raise_error;
1381: end if;
1382: hr_utility.set_location('Exiting:'||l_proc, 40);
1383:
1384: EXCEPTION
1385: WHEN OTHERS THEN
1386: hr_utility.set_location('Exception:Others'||l_proc,555);

Line 1386: hr_utility.set_location('Exception:Others'||l_proc,555);

1382: hr_utility.set_location('Exiting:'||l_proc, 40);
1383:
1384: EXCEPTION
1385: WHEN OTHERS THEN
1386: hr_utility.set_location('Exception:Others'||l_proc,555);
1387: raise;
1388:
1389: END process_api;
1390:

Line 1501: hr_utility.set_location('Entering:'||l_proc, 5);

1497:
1498: --
1499: -- if the extra info type is a PERSON
1500: --
1501: hr_utility.set_location('Entering:'||l_proc, 5);
1502: if(hr_utility.debug_enabled) then
1503:
1504: hr_utility.trace(
1505: 'hr_process_eit_ss.create_eit' ||

Line 1502: if(hr_utility.debug_enabled) then

1498: --
1499: -- if the extra info type is a PERSON
1500: --
1501: hr_utility.set_location('Entering:'||l_proc, 5);
1502: if(hr_utility.debug_enabled) then
1503:
1504: hr_utility.trace(
1505: 'hr_process_eit_ss.create_eit' ||
1506: ' arrive '||

Line 1504: hr_utility.trace(

1500: --
1501: hr_utility.set_location('Entering:'||l_proc, 5);
1502: if(hr_utility.debug_enabled) then
1503:
1504: hr_utility.trace(
1505: 'hr_process_eit_ss.create_eit' ||
1506: ' arrive '||
1507: 'p_validate '||p_validate||
1508: ' p_login_person_id '||p_login_person_id||

Line 1578: hr_utility.trace('p_flow_mode!=null but NewHireReg:'||l_proc);

1574:
1575: if p_flow_mode is not null and
1576: p_flow_mode = hr_process_assignment_ss.g_new_hire_registration
1577: then
1578: hr_utility.trace('p_flow_mode!=null but NewHireReg:'||l_proc);
1579: l_new_hire := TRUE;
1580: end if;
1581:
1582: l_eit_type_id := p_eit_type_id;

Line 1585: hr_utility.trace('if l_new_hire:'||l_proc);

1581:
1582: l_eit_type_id := p_eit_type_id;
1583:
1584: if l_new_hire then
1585: hr_utility.trace('if l_new_hire:'||l_proc);
1586: hr_new_user_reg_ss.processNewUserTransaction
1587: (WfItemType => p_item_type
1588: ,WfItemKey => p_item_key
1589: ,PersonId => l_person_id

Line 1600: hr_utility.trace('if p_eit_type=PERSON:'||l_proc);

1596: end if;
1597:
1598:
1599: if p_eit_type = 'PERSON' then
1600: hr_utility.trace('if p_eit_type=PERSON:'||l_proc);
1601: hr_utility.trace(
1602: 'hr_process_eit_ss.create_eit' ||
1603: ' p_eit_type '||p_eit_type);
1604:

Line 1601: hr_utility.trace(

1597:
1598:
1599: if p_eit_type = 'PERSON' then
1600: hr_utility.trace('if p_eit_type=PERSON:'||l_proc);
1601: hr_utility.trace(
1602: 'hr_process_eit_ss.create_eit' ||
1603: ' p_eit_type '||p_eit_type);
1604:
1605: hr_person_extra_info_api.create_person_extra_info

Line 1670: hr_utility.trace(

1666:
1667: p_object_version_number := l_object_version_number;
1668: p_extra_info_id := l_extra_info_id;
1669:
1670: hr_utility.trace(
1671: 'hr_process_eit_ss.create_eit' ||
1672: ' out nocopy create params '||
1673: ' p_person_extra_info_id '||l_extra_info_id||
1674: ' p_object_version_number '||l_object_version_number);

Line 1677: hr_utility.trace('p_eit_type=ASSIGNMENT:'||l_proc);

1673: ' p_person_extra_info_id '||l_extra_info_id||
1674: ' p_object_version_number '||l_object_version_number);
1675:
1676: elsif p_eit_type = 'ASSIGNMENT' then
1677: hr_utility.trace('p_eit_type=ASSIGNMENT:'||l_proc);
1678: hr_utility.trace(
1679: 'hr_process_eit_ss.create_eit' ||
1680: ' p_eit_type '||p_eit_type);
1681:

Line 1678: hr_utility.trace(

1674: ' p_object_version_number '||l_object_version_number);
1675:
1676: elsif p_eit_type = 'ASSIGNMENT' then
1677: hr_utility.trace('p_eit_type=ASSIGNMENT:'||l_proc);
1678: hr_utility.trace(
1679: 'hr_process_eit_ss.create_eit' ||
1680: ' p_eit_type '||p_eit_type);
1681:
1682: hr_assignment_extra_info_api.create_assignment_extra_info

Line 1747: if(hr_utility.debug_enabled) then

1743:
1744: p_object_version_number := l_object_version_number;
1745: p_extra_info_id := l_extra_info_id;
1746:
1747: if(hr_utility.debug_enabled) then
1748: hr_utility.trace(
1749: 'hr_process_eit_ss.create_eit' ||
1750: ' out nocopy create params '||
1751: ' p_person_extra_info_id '||l_extra_info_id||

Line 1748: hr_utility.trace(

1744: p_object_version_number := l_object_version_number;
1745: p_extra_info_id := l_extra_info_id;
1746:
1747: if(hr_utility.debug_enabled) then
1748: hr_utility.trace(
1749: 'hr_process_eit_ss.create_eit' ||
1750: ' out nocopy create params '||
1751: ' p_person_extra_info_id '||l_extra_info_id||
1752: ' p_object_version_number '||l_object_version_number);

Line 1759: hr_utility.trace(l_proc);

1755:
1756: --
1757: -- PB : Now rollback all the changes which are performed.
1758: --
1759: hr_utility.trace(l_proc);
1760:
1761: -- first check if this is being called for registration.
1762: if l_new_hire then
1763: hr_utility.trace('if l_new_hire: then rollback'||l_proc);

Line 1763: hr_utility.trace('if l_new_hire: then rollback'||l_proc);

1759: hr_utility.trace(l_proc);
1760:
1761: -- first check if this is being called for registration.
1762: if l_new_hire then
1763: hr_utility.trace('if l_new_hire: then rollback'||l_proc);
1764: rollback;
1765: end if;
1766:
1767: hr_utility.set_location('Exiting:'||l_proc, 35);

Line 1767: hr_utility.set_location('Exiting:'||l_proc, 35);

1763: hr_utility.trace('if l_new_hire: then rollback'||l_proc);
1764: rollback;
1765: end if;
1766:
1767: hr_utility.set_location('Exiting:'||l_proc, 35);
1768:
1769: EXCEPTION
1770:
1771: WHEN OTHERS THEN

Line 1772: hr_utility.set_location('Exception:Others'||l_proc,555);

1768:
1769: EXCEPTION
1770:
1771: WHEN OTHERS THEN
1772: hr_utility.set_location('Exception:Others'||l_proc,555);
1773: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
1774: p_error_message => p_error_message);
1775: hr_utility.trace(
1776: 'hr_process_eit_ss.create_eit' ||

Line 1775: hr_utility.trace(

1771: WHEN OTHERS THEN
1772: hr_utility.set_location('Exception:Others'||l_proc,555);
1773: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
1774: p_error_message => p_error_message);
1775: hr_utility.trace(
1776: 'hr_process_eit_ss.create_eit' ||
1777: ' l_error_message: '||p_error_message ||' '|| sqlerrm );
1778: --
1779: -- A validation or unexpected error has occurred

Line 1886: hr_utility.set_location('Entering:'||l_proc, 5);

1882: --
1883: -- Call the actual API.
1884: --
1885:
1886: hr_utility.set_location('Entering:'||l_proc, 5);
1887:
1888: if(hr_utility.debug_enabled) then
1889:
1890: hr_utility.trace(

Line 1888: if(hr_utility.debug_enabled) then

1884: --
1885:
1886: hr_utility.set_location('Entering:'||l_proc, 5);
1887:
1888: if(hr_utility.debug_enabled) then
1889:
1890: hr_utility.trace(
1891: 'hr_process_eit_ss.create_eit' ||
1892: ' arrive '||

Line 1890: hr_utility.trace(

1886: hr_utility.set_location('Entering:'||l_proc, 5);
1887:
1888: if(hr_utility.debug_enabled) then
1889:
1890: hr_utility.trace(
1891: 'hr_process_eit_ss.create_eit' ||
1892: ' arrive '||
1893: 'p_validate '||p_validate||
1894: ' p_login_person_id '||p_login_person_id||

Line 1965: hr_utility.trace('p_eit_type = PERSON:'||l_proc);

1961: -- if the extra info type is a PERSON
1962: --
1963: if p_eit_type = 'PERSON' then
1964:
1965: hr_utility.trace('p_eit_type = PERSON:'||l_proc);
1966:
1967: hr_person_extra_info_api.update_person_extra_info
1968: (p_validate => hr_java_conv_util_ss.get_boolean (
1969: p_number => p_validate)

Line 2030: hr_utility.trace('p_eit_type=ASSIGNMENT:'||l_proc);

2026: --
2027: -- if the extra info type is a PERSON
2028: --
2029: elsif p_eit_type = 'ASSIGNMENT' then
2030: hr_utility.trace('p_eit_type=ASSIGNMENT:'||l_proc);
2031:
2032: hr_assignment_extra_info_api.update_assignment_extra_info
2033: (p_validate => hr_java_conv_util_ss.get_boolean (
2034: p_number => p_validate)

Line 2095: hr_utility.set_location('Exiting:'||l_proc, 30);

2091: end if;
2092: --
2093: -- PB : Now rollback all the changes which are performed.
2094: --
2095: hr_utility.set_location('Exiting:'||l_proc, 30);
2096:
2097: EXCEPTION
2098: WHEN OTHERS THEN
2099: hr_utility.set_location('Exception:Others'||l_proc,555);

Line 2099: hr_utility.set_location('Exception:Others'||l_proc,555);

2095: hr_utility.set_location('Exiting:'||l_proc, 30);
2096:
2097: EXCEPTION
2098: WHEN OTHERS THEN
2099: hr_utility.set_location('Exception:Others'||l_proc,555);
2100: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
2101: p_error_message => p_error_message);
2102:
2103: hr_utility.trace(

Line 2103: hr_utility.trace(

2099: hr_utility.set_location('Exception:Others'||l_proc,555);
2100: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
2101: p_error_message => p_error_message);
2102:
2103: hr_utility.trace(
2104: 'hr_process_eit_ss.create_eit' ||
2105: ' l_error_message: '||p_error_message ||' '|| sqlerrm );
2106:
2107: --

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

2138: l_proc varchar2(72) := g_package||'delete_sit';
2139: --
2140: BEGIN
2141: --
2142: hr_utility.set_location('Entering:'|| l_proc,10);
2143: --
2144: -- Call the actual API.
2145: --
2146: --

Line 2150: hr_utility.trace('p_eit_type = PERSON'||l_proc);

2146: --
2147: -- if the extra info type is a PERSON
2148: --
2149: IF p_eit_type = 'PERSON' THEN
2150: hr_utility.trace('p_eit_type = PERSON'||l_proc);
2151: hr_person_extra_info_api.delete_person_extra_info
2152: (p_validate => hr_java_conv_util_ss.get_boolean (
2153: p_number => p_validate)
2154: ,p_person_extra_info_id => p_extra_info_id

Line 2159: hr_utility.trace('p_eit_type=ASSIGNMENT:'||l_proc);

2155: ,p_object_version_number => p_object_version_number
2156: );
2157: ELSIF p_eit_type = 'ASSIGNMENT' THEN
2158:
2159: hr_utility.trace('p_eit_type=ASSIGNMENT:'||l_proc);
2160: hr_assignment_extra_info_api.DELETE_ASSIGNMENT_EXTRA_INFO
2161: (p_validate => hr_java_conv_util_ss.get_boolean (
2162: p_number => p_validate)
2163: ,p_assignment_extra_info_id => p_extra_info_id

Line 2169: hr_utility.set_location('Exiting:'||l_proc, 25);

2165: );
2166:
2167: END IF;
2168:
2169: hr_utility.set_location('Exiting:'||l_proc, 25);
2170:
2171: EXCEPTION
2172: WHEN OTHERS THEN
2173: hr_utility.set_location('Exception:Others'||l_proc,555);

Line 2173: hr_utility.set_location('Exception:Others'||l_proc,555);

2169: hr_utility.set_location('Exiting:'||l_proc, 25);
2170:
2171: EXCEPTION
2172: WHEN OTHERS THEN
2173: hr_utility.set_location('Exception:Others'||l_proc,555);
2174: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
2175: p_error_message => p_error_message);
2176: --
2177: -- A validation or unexpected error has occurred

Line 2196: hr_utility.set_location('Entering:'||l_proc, 5);

2192:
2193: BEGIN
2194:
2195:
2196: hr_utility.set_location('Entering:'||l_proc, 5);
2197: l_index := p_eit_table.first;
2198: hr_utility.trace('Entering LOOP:'||l_proc);
2199: LOOP
2200: EXIT WHEN

Line 2198: hr_utility.trace('Entering LOOP:'||l_proc);

2194:
2195:
2196: hr_utility.set_location('Entering:'||l_proc, 5);
2197: l_index := p_eit_table.first;
2198: hr_utility.trace('Entering LOOP:'||l_proc);
2199: LOOP
2200: EXIT WHEN
2201: (NOT p_eit_table.exists(l_index));
2202:

Line 2203: if(hr_utility.debug_enabled) then

2199: LOOP
2200: EXIT WHEN
2201: (NOT p_eit_table.exists(l_index));
2202:
2203: if(hr_utility.debug_enabled) then
2204:
2205: hr_utility.trace(
2206: 'hr_process_eit_ss.dump_eit_table' ||
2207: ' l_index :'||l_index||

Line 2205: hr_utility.trace(

2201: (NOT p_eit_table.exists(l_index));
2202:
2203: if(hr_utility.debug_enabled) then
2204:
2205: hr_utility.trace(
2206: 'hr_process_eit_ss.dump_eit_table' ||
2207: ' l_index :'||l_index||
2208: ' Action :'||p_eit_table(l_index).action||
2209: ' extra_info_id: '||p_eit_table(l_index).extra_info_id||

Line 2269: hr_utility.trace('End of LOOP:'||l_proc );

2265: end if;
2266:
2267: l_index := p_eit_table.next(l_index);
2268: END LOOP;
2269: hr_utility.trace('End of LOOP:'||l_proc );
2270: hr_utility.set_location('Exiting:'||l_proc, 20);
2271:
2272: END dump_eit_table;
2273:

Line 2270: hr_utility.set_location('Exiting:'||l_proc, 20);

2266:
2267: l_index := p_eit_table.next(l_index);
2268: END LOOP;
2269: hr_utility.trace('End of LOOP:'||l_proc );
2270: hr_utility.set_location('Exiting:'||l_proc, 20);
2271:
2272: END dump_eit_table;
2273:
2274: