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

1118: l_item_key varchar2(50);
1119:
1120: BEGIN
1121:
1122: hr_utility.set_location('Entering:'||l_proc, 5);
1123: hr_utility.trace(
1124: 'hr_process_eit_ss.process_api' ||
1125: ' p_transaction_step_id: ');--||p_transaction_step_id);
1126:

Line 1123: hr_utility.trace(

1119:
1120: BEGIN
1121:
1122: hr_utility.set_location('Entering:'||l_proc, 5);
1123: hr_utility.trace(
1124: 'hr_process_eit_ss.process_api' ||
1125: ' p_transaction_step_id: ');--||p_transaction_step_id);
1126:
1127: --insert session because some flex uses the session effective date.

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

1125: ' p_transaction_step_id: ');--||p_transaction_step_id);
1126:
1127: --insert session because some flex uses the session effective date.
1128: if p_effective_date is not null then
1129: hr_utility.trace('EffDate!=Null:'||l_proc);
1130: hr_util_misc_web.insert_session_row(to_date(p_effective_date, 'RRRR-MM-DD'));
1131: else
1132: hr_utility.trace('EffDate==Null:'||l_proc);
1133: hr_util_misc_web.insert_session_row(SYSDATE);

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

1128: if p_effective_date is not null then
1129: hr_utility.trace('EffDate!=Null:'||l_proc);
1130: hr_util_misc_web.insert_session_row(to_date(p_effective_date, 'RRRR-MM-DD'));
1131: else
1132: hr_utility.trace('EffDate==Null:'||l_proc);
1133: hr_util_misc_web.insert_session_row(SYSDATE);
1134: end if;
1135:
1136: get_eit_data_from_tt

Line 1154: if(hr_utility.debug_enabled)then

1150: FETCH cur_txnStep INTO l_item_type,l_item_key;
1151: CLOSE cur_txnStep;
1152:
1153: --debug
1154: if(hr_utility.debug_enabled)then
1155:
1156: hr_utility.trace(
1157: 'hr_process_eit_ss.process_api' ||
1158: ' p_person_id: '||l_person_id||

Line 1156: hr_utility.trace(

1152:
1153: --debug
1154: if(hr_utility.debug_enabled)then
1155:
1156: hr_utility.trace(
1157: 'hr_process_eit_ss.process_api' ||
1158: ' p_person_id: '||l_person_id||
1159: ' p_login_person_id: '||l_login_person_id||
1160: ' p_eit_type: '||l_eit_type||

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

1162: ' p_eit_number: '||l_eit_number);
1163: end if;
1164:
1165:
1166: hr_utility.trace('Before DumpingEIT table:'||l_proc);
1167: dump_eit_table(l_eit_table);
1168:
1169: hr_utility.trace('FOR j IN 1..2'||l_proc);
1170: FOR j IN 1..2 LOOP

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

1165:
1166: hr_utility.trace('Before DumpingEIT table:'||l_proc);
1167: dump_eit_table(l_eit_table);
1168:
1169: hr_utility.trace('FOR j IN 1..2'||l_proc);
1170: FOR j IN 1..2 LOOP
1171: l_index := l_eit_table.first;
1172: LOOP
1173: EXIT WHEN

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

1172: LOOP
1173: EXIT WHEN
1174: (NOT l_eit_table.exists(l_index));
1175:
1176: hr_utility.trace('End of FOR '||l_proc);
1177:
1178: hr_utility.trace(
1179: 'hr_process_eit_ss.process_api' ||
1180: ' l_index: '||l_index);

Line 1178: hr_utility.trace(

1174: (NOT l_eit_table.exists(l_index));
1175:
1176: hr_utility.trace('End of FOR '||l_proc);
1177:
1178: hr_utility.trace(
1179: 'hr_process_eit_ss.process_api' ||
1180: ' l_index: '||l_index);
1181:
1182: IF j = 1 AND l_eit_table(l_index).action = 'DELETE_ROW'

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

1183: OR j = 2 and l_eit_table(l_index).action <> 'DELETE_ROW' THEN
1184:
1185:
1186: IF l_eit_table(l_index).action = 'NEW_ROW' THEN
1187: -- hr_utility.trace('l_eit_table(l_index).action=NEW ROW'||l_proc);
1188:
1189: -- hr_utility.trace(
1190: -- 'hr_process_eit_ss.process_api' ||
1191: -- ' create a row: ');

Line 1189: -- hr_utility.trace(

1185:
1186: IF l_eit_table(l_index).action = 'NEW_ROW' THEN
1187: -- hr_utility.trace('l_eit_table(l_index).action=NEW ROW'||l_proc);
1188:
1189: -- hr_utility.trace(
1190: -- 'hr_process_eit_ss.process_api' ||
1191: -- ' create a row: ');
1192:
1193: create_eit

Line 1265: -- hr_utility.trace(

1261: ,p_save_mode => null
1262: ,p_error_message => l_error_message
1263: );
1264:
1265: -- hr_utility.trace(
1266: -- 'hr_process_eit_ss.process_api' ||
1267: -- ' create a row with extra info type id'||l_extra_info_id);
1268:
1269:

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

1267: -- ' create a row with extra info type id'||l_extra_info_id);
1268:
1269:
1270: ELSIF l_eit_table(l_index).action = 'UPDATE_ROW' THEN
1271: -- hr_utility.trace('l_eit_table(l_index).action=UPDATE_ROW'||l_proc);
1272:
1273: -- hr_utility.trace(
1274: -- 'hr_process_eit_ss.process_api' ||
1275: -- ' update a row with extra info type id'||l_eit_table(l_index).extra_info_id);

Line 1273: -- hr_utility.trace(

1269:
1270: ELSIF l_eit_table(l_index).action = 'UPDATE_ROW' THEN
1271: -- hr_utility.trace('l_eit_table(l_index).action=UPDATE_ROW'||l_proc);
1272:
1273: -- hr_utility.trace(
1274: -- 'hr_process_eit_ss.process_api' ||
1275: -- ' update a row with extra info type id'||l_eit_table(l_index).extra_info_id);
1276:
1277: update_eit

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

1347: );
1348:
1349: ELSIF l_eit_table(l_index).action = 'DELETE_ROW' THEN
1350:
1351: -- hr_utility.trace('l_eit_table(l_index).action=DELETE_ROW:'||l_proc);
1352: -- hr_utility.trace(
1353: -- 'hr_process_eit_ss.process_api' ||
1354: -- ' delete a row with extra info type id'||l_eit_table(l_index).extra_info_id);
1355:

Line 1352: -- hr_utility.trace(

1348:
1349: ELSIF l_eit_table(l_index).action = 'DELETE_ROW' THEN
1350:
1351: -- hr_utility.trace('l_eit_table(l_index).action=DELETE_ROW:'||l_proc);
1352: -- hr_utility.trace(
1353: -- 'hr_process_eit_ss.process_api' ||
1354: -- ' delete a row with extra info type id'||l_eit_table(l_index).extra_info_id);
1355:
1356: delete_eit

Line 1379: -- hr_utility.trace(

1375:
1376: END IF;
1377: END IF;
1378:
1379: -- hr_utility.trace(
1380: -- 'hr_process_eit_ss.process_api' ||
1381: -- ' l_error_message: '||l_error_message);
1382:
1383: l_index := l_eit_table.next(l_index);

Line 1392: hr_utility.raise_error;

1388: --remove session
1389: hr_util_misc_web.remove_session_row();
1390:
1391: if l_error_message is not null then
1392: hr_utility.raise_error;
1393: end if;
1394: hr_utility.set_location('Exiting:'||l_proc, 40);
1395:
1396: EXCEPTION

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

1390:
1391: if l_error_message is not null then
1392: hr_utility.raise_error;
1393: end if;
1394: hr_utility.set_location('Exiting:'||l_proc, 40);
1395:
1396: EXCEPTION
1397: WHEN OTHERS THEN
1398: hr_utility.set_location('Exception:Others'||l_proc,555);

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

1394: hr_utility.set_location('Exiting:'||l_proc, 40);
1395:
1396: EXCEPTION
1397: WHEN OTHERS THEN
1398: hr_utility.set_location('Exception:Others'||l_proc,555);
1399: raise;
1400:
1401: END process_api;
1402:

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

1518:
1519: --
1520: -- if the extra info type is a PERSON
1521: --
1522: hr_utility.set_location('Entering:'||l_proc, 5);
1523: if(hr_utility.debug_enabled) then
1524:
1525: hr_utility.trace(
1526: 'hr_process_eit_ss.create_eit' ||

Line 1523: if(hr_utility.debug_enabled) then

1519: --
1520: -- if the extra info type is a PERSON
1521: --
1522: hr_utility.set_location('Entering:'||l_proc, 5);
1523: if(hr_utility.debug_enabled) then
1524:
1525: hr_utility.trace(
1526: 'hr_process_eit_ss.create_eit' ||
1527: ' arrive '||

Line 1525: hr_utility.trace(

1521: --
1522: hr_utility.set_location('Entering:'||l_proc, 5);
1523: if(hr_utility.debug_enabled) then
1524:
1525: hr_utility.trace(
1526: 'hr_process_eit_ss.create_eit' ||
1527: ' arrive '||
1528: 'p_validate '||p_validate||
1529: ' p_login_person_id '||p_login_person_id||

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

1595:
1596: if p_flow_mode is not null and
1597: p_flow_mode = hr_process_assignment_ss.g_new_hire_registration
1598: then
1599: hr_utility.trace('p_flow_mode!=null but NewHireReg:'||l_proc);
1600: l_new_hire := TRUE;
1601: end if;
1602:
1603: l_eit_type_id := p_eit_type_id;

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

1602:
1603: l_eit_type_id := p_eit_type_id;
1604:
1605: if l_new_hire then
1606: hr_utility.trace('if l_new_hire:'||l_proc);
1607: hr_new_user_reg_ss.processNewUserTransaction
1608: (WfItemType => p_item_type
1609: ,WfItemKey => p_item_key
1610: ,PersonId => l_person_id

Line 1628: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

1624: open csr_asg_id;
1625: fetch csr_asg_id into l_assignment_id;
1626:
1627: if csr_asg_id%notfound then
1628: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
1629: hr_utility.raise_error;
1630: else
1631: l_eit_type_id := l_assignment_id;
1632: end if;

Line 1629: hr_utility.raise_error;

1625: fetch csr_asg_id into l_assignment_id;
1626:
1627: if csr_asg_id%notfound then
1628: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
1629: hr_utility.raise_error;
1630: else
1631: l_eit_type_id := l_assignment_id;
1632: end if;
1633: --

Line 1637: hr_utility.trace('lv_flow_identifier := '||lv_flow_identifier);

1633: --
1634: close csr_asg_id;
1635: end if;
1636:
1637: hr_utility.trace('lv_flow_identifier := '||lv_flow_identifier);
1638: hr_utility.trace('l_person_id := '||l_person_id);
1639: hr_utility.trace('l_assignment_id := '||l_assignment_id);
1640: hr_utility.trace('p_eit_type := '||p_eit_type);
1641: hr_utility.trace('l_eit_type_id := '||l_eit_type_id);

Line 1638: hr_utility.trace('l_person_id := '||l_person_id);

1634: close csr_asg_id;
1635: end if;
1636:
1637: hr_utility.trace('lv_flow_identifier := '||lv_flow_identifier);
1638: hr_utility.trace('l_person_id := '||l_person_id);
1639: hr_utility.trace('l_assignment_id := '||l_assignment_id);
1640: hr_utility.trace('p_eit_type := '||p_eit_type);
1641: hr_utility.trace('l_eit_type_id := '||l_eit_type_id);
1642:

Line 1639: hr_utility.trace('l_assignment_id := '||l_assignment_id);

1635: end if;
1636:
1637: hr_utility.trace('lv_flow_identifier := '||lv_flow_identifier);
1638: hr_utility.trace('l_person_id := '||l_person_id);
1639: hr_utility.trace('l_assignment_id := '||l_assignment_id);
1640: hr_utility.trace('p_eit_type := '||p_eit_type);
1641: hr_utility.trace('l_eit_type_id := '||l_eit_type_id);
1642:
1643:

Line 1640: hr_utility.trace('p_eit_type := '||p_eit_type);

1636:
1637: hr_utility.trace('lv_flow_identifier := '||lv_flow_identifier);
1638: hr_utility.trace('l_person_id := '||l_person_id);
1639: hr_utility.trace('l_assignment_id := '||l_assignment_id);
1640: hr_utility.trace('p_eit_type := '||p_eit_type);
1641: hr_utility.trace('l_eit_type_id := '||l_eit_type_id);
1642:
1643:
1644: if p_eit_type = 'PERSON' then

Line 1641: hr_utility.trace('l_eit_type_id := '||l_eit_type_id);

1637: hr_utility.trace('lv_flow_identifier := '||lv_flow_identifier);
1638: hr_utility.trace('l_person_id := '||l_person_id);
1639: hr_utility.trace('l_assignment_id := '||l_assignment_id);
1640: hr_utility.trace('p_eit_type := '||p_eit_type);
1641: hr_utility.trace('l_eit_type_id := '||l_eit_type_id);
1642:
1643:
1644: if p_eit_type = 'PERSON' then
1645: hr_utility.trace('if p_eit_type=PERSON:'||l_proc);

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

1641: hr_utility.trace('l_eit_type_id := '||l_eit_type_id);
1642:
1643:
1644: if p_eit_type = 'PERSON' then
1645: hr_utility.trace('if p_eit_type=PERSON:'||l_proc);
1646: hr_utility.trace(
1647: 'hr_process_eit_ss.create_eit' ||
1648: ' p_eit_type '||p_eit_type);
1649:

Line 1646: hr_utility.trace(

1642:
1643:
1644: if p_eit_type = 'PERSON' then
1645: hr_utility.trace('if p_eit_type=PERSON:'||l_proc);
1646: hr_utility.trace(
1647: 'hr_process_eit_ss.create_eit' ||
1648: ' p_eit_type '||p_eit_type);
1649:
1650: hr_person_extra_info_api.create_person_extra_info

Line 1715: hr_utility.trace(

1711:
1712: p_object_version_number := l_object_version_number;
1713: p_extra_info_id := l_extra_info_id;
1714:
1715: hr_utility.trace(
1716: 'hr_process_eit_ss.create_eit' ||
1717: ' out nocopy create params '||
1718: ' p_person_extra_info_id '||l_extra_info_id||
1719: ' p_object_version_number '||l_object_version_number);

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

1718: ' p_person_extra_info_id '||l_extra_info_id||
1719: ' p_object_version_number '||l_object_version_number);
1720:
1721: elsif p_eit_type = 'ASSIGNMENT' then
1722: hr_utility.trace('p_eit_type=ASSIGNMENT:'||l_proc);
1723: hr_utility.trace(
1724: 'hr_process_eit_ss.create_eit' ||
1725: ' p_eit_type '||p_eit_type);
1726:

Line 1723: hr_utility.trace(

1719: ' p_object_version_number '||l_object_version_number);
1720:
1721: elsif p_eit_type = 'ASSIGNMENT' then
1722: hr_utility.trace('p_eit_type=ASSIGNMENT:'||l_proc);
1723: hr_utility.trace(
1724: 'hr_process_eit_ss.create_eit' ||
1725: ' p_eit_type '||p_eit_type);
1726:
1727: hr_assignment_extra_info_api.create_assignment_extra_info

Line 1792: if(hr_utility.debug_enabled) then

1788:
1789: p_object_version_number := l_object_version_number;
1790: p_extra_info_id := l_extra_info_id;
1791:
1792: if(hr_utility.debug_enabled) then
1793: hr_utility.trace(
1794: 'hr_process_eit_ss.create_eit' ||
1795: ' out nocopy create params '||
1796: ' p_person_extra_info_id '||l_extra_info_id||

Line 1793: hr_utility.trace(

1789: p_object_version_number := l_object_version_number;
1790: p_extra_info_id := l_extra_info_id;
1791:
1792: if(hr_utility.debug_enabled) then
1793: hr_utility.trace(
1794: 'hr_process_eit_ss.create_eit' ||
1795: ' out nocopy create params '||
1796: ' p_person_extra_info_id '||l_extra_info_id||
1797: ' p_object_version_number '||l_object_version_number);

Line 1804: hr_utility.trace(l_proc);

1800:
1801: --
1802: -- PB : Now rollback all the changes which are performed.
1803: --
1804: hr_utility.trace(l_proc);
1805:
1806: -- first check if this is being called for registration.
1807: if l_new_hire then
1808: hr_utility.trace('if l_new_hire: then rollback'||l_proc);

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

1804: hr_utility.trace(l_proc);
1805:
1806: -- first check if this is being called for registration.
1807: if l_new_hire then
1808: hr_utility.trace('if l_new_hire: then rollback'||l_proc);
1809: rollback;
1810: end if;
1811:
1812: hr_utility.set_location('Exiting:'||l_proc, 35);

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

1808: hr_utility.trace('if l_new_hire: then rollback'||l_proc);
1809: rollback;
1810: end if;
1811:
1812: hr_utility.set_location('Exiting:'||l_proc, 35);
1813:
1814: EXCEPTION
1815:
1816: WHEN OTHERS THEN

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

1813:
1814: EXCEPTION
1815:
1816: WHEN OTHERS THEN
1817: hr_utility.set_location('Exception:Others'||l_proc,555);
1818: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
1819: p_error_message => p_error_message);
1820: hr_utility.trace(
1821: 'hr_process_eit_ss.create_eit' ||

Line 1820: hr_utility.trace(

1816: WHEN OTHERS THEN
1817: hr_utility.set_location('Exception:Others'||l_proc,555);
1818: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
1819: p_error_message => p_error_message);
1820: hr_utility.trace(
1821: 'hr_process_eit_ss.create_eit' ||
1822: ' l_error_message: '||p_error_message ||' '|| sqlerrm );
1823: --
1824: -- A validation or unexpected error has occurred

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

1927: --
1928: -- Call the actual API.
1929: --
1930:
1931: hr_utility.set_location('Entering:'||l_proc, 5);
1932:
1933: if(hr_utility.debug_enabled) then
1934:
1935: hr_utility.trace(

Line 1933: if(hr_utility.debug_enabled) then

1929: --
1930:
1931: hr_utility.set_location('Entering:'||l_proc, 5);
1932:
1933: if(hr_utility.debug_enabled) then
1934:
1935: hr_utility.trace(
1936: 'hr_process_eit_ss.create_eit' ||
1937: ' arrive '||

Line 1935: hr_utility.trace(

1931: hr_utility.set_location('Entering:'||l_proc, 5);
1932:
1933: if(hr_utility.debug_enabled) then
1934:
1935: hr_utility.trace(
1936: 'hr_process_eit_ss.create_eit' ||
1937: ' arrive '||
1938: 'p_validate '||p_validate||
1939: ' p_login_person_id '||p_login_person_id||

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

2006: -- if the extra info type is a PERSON
2007: --
2008: if p_eit_type = 'PERSON' then
2009:
2010: hr_utility.trace('p_eit_type = PERSON:'||l_proc);
2011:
2012: hr_person_extra_info_api.update_person_extra_info
2013: (p_validate => hr_java_conv_util_ss.get_boolean (
2014: p_number => p_validate)

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

2071: --
2072: -- if the extra info type is a PERSON
2073: --
2074: elsif p_eit_type = 'ASSIGNMENT' then
2075: hr_utility.trace('p_eit_type=ASSIGNMENT:'||l_proc);
2076:
2077: hr_assignment_extra_info_api.update_assignment_extra_info
2078: (p_validate => hr_java_conv_util_ss.get_boolean (
2079: p_number => p_validate)

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

2136: end if;
2137: --
2138: -- PB : Now rollback all the changes which are performed.
2139: --
2140: hr_utility.set_location('Exiting:'||l_proc, 30);
2141:
2142: EXCEPTION
2143: WHEN OTHERS THEN
2144: hr_utility.set_location('Exception:Others'||l_proc,555);

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

2140: hr_utility.set_location('Exiting:'||l_proc, 30);
2141:
2142: EXCEPTION
2143: WHEN OTHERS THEN
2144: hr_utility.set_location('Exception:Others'||l_proc,555);
2145: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
2146: p_error_message => p_error_message);
2147:
2148: hr_utility.trace(

Line 2148: hr_utility.trace(

2144: hr_utility.set_location('Exception:Others'||l_proc,555);
2145: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
2146: p_error_message => p_error_message);
2147:
2148: hr_utility.trace(
2149: 'hr_process_eit_ss.create_eit' ||
2150: ' l_error_message: '||p_error_message ||' '|| sqlerrm );
2151:
2152: --

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

2183: l_proc varchar2(72) := g_package||'delete_sit';
2184: --
2185: BEGIN
2186: --
2187: hr_utility.set_location('Entering:'|| l_proc,10);
2188: --
2189: -- Call the actual API.
2190: --
2191: --

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

2191: --
2192: -- if the extra info type is a PERSON
2193: --
2194: IF p_eit_type = 'PERSON' THEN
2195: hr_utility.trace('p_eit_type = PERSON'||l_proc);
2196: hr_person_extra_info_api.delete_person_extra_info
2197: (p_validate => hr_java_conv_util_ss.get_boolean (
2198: p_number => p_validate)
2199: ,p_person_extra_info_id => p_extra_info_id

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

2200: ,p_object_version_number => p_object_version_number
2201: );
2202: ELSIF p_eit_type = 'ASSIGNMENT' THEN
2203:
2204: hr_utility.trace('p_eit_type=ASSIGNMENT:'||l_proc);
2205: hr_assignment_extra_info_api.DELETE_ASSIGNMENT_EXTRA_INFO
2206: (p_validate => hr_java_conv_util_ss.get_boolean (
2207: p_number => p_validate)
2208: ,p_assignment_extra_info_id => p_extra_info_id

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

2210: );
2211:
2212: END IF;
2213:
2214: hr_utility.set_location('Exiting:'||l_proc, 25);
2215:
2216: EXCEPTION
2217: WHEN OTHERS THEN
2218: hr_utility.set_location('Exception:Others'||l_proc,555);

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

2214: hr_utility.set_location('Exiting:'||l_proc, 25);
2215:
2216: EXCEPTION
2217: WHEN OTHERS THEN
2218: hr_utility.set_location('Exception:Others'||l_proc,555);
2219: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
2220: p_error_message => p_error_message);
2221: --
2222: -- A validation or unexpected error has occurred

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

2237:
2238: BEGIN
2239:
2240:
2241: hr_utility.set_location('Entering:'||l_proc, 5);
2242: l_index := p_eit_table.first;
2243: hr_utility.trace('Entering LOOP:'||l_proc);
2244: LOOP
2245: EXIT WHEN

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

2239:
2240:
2241: hr_utility.set_location('Entering:'||l_proc, 5);
2242: l_index := p_eit_table.first;
2243: hr_utility.trace('Entering LOOP:'||l_proc);
2244: LOOP
2245: EXIT WHEN
2246: (NOT p_eit_table.exists(l_index));
2247:

Line 2248: if(hr_utility.debug_enabled) then

2244: LOOP
2245: EXIT WHEN
2246: (NOT p_eit_table.exists(l_index));
2247:
2248: if(hr_utility.debug_enabled) then
2249:
2250: hr_utility.trace(
2251: 'hr_process_eit_ss.dump_eit_table' ||
2252: ' l_index :'||l_index||

Line 2250: hr_utility.trace(

2246: (NOT p_eit_table.exists(l_index));
2247:
2248: if(hr_utility.debug_enabled) then
2249:
2250: hr_utility.trace(
2251: 'hr_process_eit_ss.dump_eit_table' ||
2252: ' l_index :'||l_index||
2253: ' Action :'||p_eit_table(l_index).action||
2254: ' extra_info_id: '||p_eit_table(l_index).extra_info_id||

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

2310: end if;
2311:
2312: l_index := p_eit_table.next(l_index);
2313: END LOOP;
2314: hr_utility.trace('End of LOOP:'||l_proc );
2315: hr_utility.set_location('Exiting:'||l_proc, 20);
2316:
2317: END dump_eit_table;
2318:

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

2311:
2312: l_index := p_eit_table.next(l_index);
2313: END LOOP;
2314: hr_utility.trace('End of LOOP:'||l_proc );
2315: hr_utility.set_location('Exiting:'||l_proc, 20);
2316:
2317: END dump_eit_table;
2318:
2319: