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

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

61:
62:
63: BEGIN
64:
65: hr_utility.set_location('Entering:'||l_proc, 5);
66: if p_flow_mode is not null and
67: p_flow_mode = hr_process_assignment_ss.g_new_hire_registration
68: then
69: hr_utility.set_location('flow mode!=NULL AND is NewHire Registration:'||l_proc,10);

Line 69: hr_utility.set_location('flow mode!=NULL AND is NewHire Registration:'||l_proc,10);

65: hr_utility.set_location('Entering:'||l_proc, 5);
66: if p_flow_mode is not null and
67: p_flow_mode = hr_process_assignment_ss.g_new_hire_registration
68: then
69: hr_utility.set_location('flow mode!=NULL AND is NewHire Registration:'||l_proc,10);
70: l_new_hire := TRUE;
71: end if;
72:
73: if l_new_hire then

Line 74: hr_utility.set_location('if l_new_hire then:'||l_proc,15);

70: l_new_hire := TRUE;
71: end if;
72:
73: if l_new_hire then
74: hr_utility.set_location('if l_new_hire then:'||l_proc,15);
75: rollback;
76: end if;
77: --
78: -- First, check if transaction id exists or not

Line 85: hr_utility.set_location('l_transaction_id is null THEN:'||l_proc,15);

81: ,p_item_key => p_item_key);
82: --
83: IF l_transaction_id is null THEN
84: -- Start a Transaction
85: hr_utility.set_location('l_transaction_id is null THEN:'||l_proc,15);
86: hr_transaction_ss.start_transaction
87: (itemtype => p_item_type
88: ,itemkey => p_item_key
89: ,actid => p_activity_id

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

313: ,p_transaction_step_id => p_transaction_step_id
314: ,p_api_name => g_package || '.PROCESS_API'
315: ,p_transaction_data => l_transaction_table);
316:
317: hr_utility.set_location('Exiting:'||l_proc, 25);
318: EXCEPTION
319: -- Catch any exception thrown while storing transaction data
320: WHEN OTHERS THEN
321: hr_utility.set_location('Exception:Others'||l_proc,555);

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

317: hr_utility.set_location('Exiting:'||l_proc, 25);
318: EXCEPTION
319: -- Catch any exception thrown while storing transaction data
320: WHEN OTHERS THEN
321: hr_utility.set_location('Exception:Others'||l_proc,555);
322: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
323: p_error_message => p_error_message);
324: END save_transaction_data;
325:

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

375: l_proc varchar2(72) := g_package||'get_transaction_data';
376:
377: BEGIN
378: --
379: hr_utility.set_location('Entering:'||l_proc, 5);
380: p_person_id := hr_transaction_api.get_number_value
381: (p_transaction_step_id => p_transaction_step_id
382: ,p_name => 'P_PERSON_ID');
383:

Line 396: hr_utility.set_location('If it is ICX_SEC.G_SESSION_ID:'||l_proc,10);

392: -- adding the session id check to avoid connection pooling problems.
393: if (( hr_process_person_ss.g_person_id is not null) and
394: (hr_process_person_ss.g_session_id= ICX_SEC.G_SESSION_ID))
395: then
396: hr_utility.set_location('If it is ICX_SEC.G_SESSION_ID:'||l_proc,10);
397: p_person_id := hr_process_person_ss.g_person_id;
398: end if;
399:
400: -- end registration

Line 562: hr_utility.set_location('Exiting:'||l_proc, 15);

558: (p_transaction_step_id => p_transaction_step_id
559: ,p_name => 'P_ATTRIBUTE20');
560:
561:
562: hr_utility.set_location('Exiting:'||l_proc, 15);
563: EXCEPTION
564: -- Catch any exception thrown while storing transaction data
565: WHEN OTHERS THEN
566: hr_utility.set_location('Exception:Others'||l_proc,555);

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

562: hr_utility.set_location('Exiting:'||l_proc, 15);
563: EXCEPTION
564: -- Catch any exception thrown while storing transaction data
565: WHEN OTHERS THEN
566: hr_utility.set_location('Exception:Others'||l_proc,555);
567: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
568: p_error_message => p_error_message);
569: END get_transaction_data;
570: --

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

620: l_analysis_criteria_rec hr_process_sit_ss.per_analysis_criteria_rec;
621: l_error_message long default null;
622: --
623: begin
624: hr_utility.set_location('Entering:'|| l_proc, 10);
625:
626:
627: -- Get the segments from the ccid
628: l_analysis_criteria_rec := get_segments_from_ccid(p_analysis_criteria_id);

Line 701: hr_utility.set_location('Exiting:'||l_proc, 15);

697: );
698:
699: --
700:
701: hr_utility.set_location('Exiting:'||l_proc, 15);
702: EXCEPTION
703: WHEN OTHERS THEN
704: hr_utility.set_location('Exception:Others'||l_proc,555);
705: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(

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

700:
701: hr_utility.set_location('Exiting:'||l_proc, 15);
702: EXCEPTION
703: WHEN OTHERS THEN
704: hr_utility.set_location('Exception:Others'||l_proc,555);
705: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
706: p_error_message => p_error_message);
707: --
708: -- A validation or unexpected error has occurred

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

759: l_analysis_criteria_rec hr_process_sit_ss.per_analysis_criteria_rec;
760: l_error_message long default null;
761: --
762: begin
763: hr_utility.set_location('Entering:'|| l_proc, 10);
764:
765:
766: -- Get the segments from the ccid
767: l_analysis_criteria_rec := get_segments_from_ccid(p_analysis_criteria_id);

Line 834: hr_utility.set_location('Exiting:'||l_proc, 15);

830: ,p_analysis_criteria_id => l_analysis_criteria_id
831: );
832: --
833:
834: hr_utility.set_location('Exiting:'||l_proc, 15);
835: EXCEPTION
836: WHEN OTHERS THEN
837: hr_utility.set_location('Exception:Others'||l_proc,555);
838: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(

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

833:
834: hr_utility.set_location('Exiting:'||l_proc, 15);
835: EXCEPTION
836: WHEN OTHERS THEN
837: hr_utility.set_location('Exception:Others'||l_proc,555);
838: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
839: p_error_message => p_error_message);
840: --
841: -- A validation or unexpected error has occurred

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

867: l_proc varchar2(72) := g_package||'delete_sit';
868: --
869: BEGIN
870: --
871: hr_utility.set_location('Entering:'|| l_proc,10);
872: --
873: -- Call API Update SIT
874: --
875: hr_sit_api.delete_sit(

Line 885: hr_utility.set_location('Exiting:'||l_proc, 15);

881: );
882:
883: --
884:
885: hr_utility.set_location('Exiting:'||l_proc, 15);
886: EXCEPTION
887: WHEN OTHERS THEN
888: hr_utility.set_location('Exception:Others'||l_proc,555);
889: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(

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

884:
885: hr_utility.set_location('Exiting:'||l_proc, 15);
886: EXCEPTION
887: WHEN OTHERS THEN
888: hr_utility.set_location('Exception:Others'||l_proc,555);
889: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
890: p_error_message => p_error_message);
891: --
892: -- A validation or unexpected error has occurred

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

958:
959: --2287707
960: --process all the steps at once.
961: --get all the steps in order
962: hr_utility.set_location('Entering:'||l_proc, 5);
963: OPEN csr_get_steps;
964: FETCH csr_get_steps INTO l_transaction_step_id;
965: CLOSE csr_get_steps;
966:

Line 969: hr_utility.set_location('Exiting bcos:l_transaction_step_id!=p_transaction_step_id'||l_proc, 15);

965: CLOSE csr_get_steps;
966:
967: --return if the p_transaction_step_id <> the first one
968: IF l_transaction_step_id <> p_transaction_step_id THEN
969: hr_utility.set_location('Exiting bcos:l_transaction_step_id!=p_transaction_step_id'||l_proc, 15);
970: return;
971: END IF;
972:
973: -- Do 3 times. The first time, we only process the deleted records.

Line 976: hr_utility.set_location('Entering For Loop:i IN 1..3'||l_proc,20);

972:
973: -- Do 3 times. The first time, we only process the deleted records.
974: -- The second time, we process the updated records.
975: -- The third time, we process the inserted records.
976: hr_utility.set_location('Entering For Loop:i IN 1..3'||l_proc,20);
977: FOR i IN 1..3 LOOP
978: FOR v_steps IN csr_get_steps LOOP
979:
980: l_transaction_step_id := v_steps.transaction_step_id;

Line 1167: hr_utility.set_location('Exiting For Loop:'||l_proc,20);

1163: END IF; --end of l_action if
1164: END IF; --end of i if
1165: END LOOP; --end of v_steps loop
1166: END LOOP; --end of i loop
1167: hr_utility.set_location('Exiting For Loop:'||l_proc,20);
1168:
1169: if l_error_message is not null then
1170: hr_utility.set_location('l_error_message is not null:'||l_proc,25);
1171: hr_utility.raise_error;

Line 1170: hr_utility.set_location('l_error_message is not null:'||l_proc,25);

1166: END LOOP; --end of i loop
1167: hr_utility.set_location('Exiting For Loop:'||l_proc,20);
1168:
1169: if l_error_message is not null then
1170: hr_utility.set_location('l_error_message is not null:'||l_proc,25);
1171: hr_utility.raise_error;
1172: end if;
1173:
1174:

Line 1171: hr_utility.raise_error;

1167: hr_utility.set_location('Exiting For Loop:'||l_proc,20);
1168:
1169: if l_error_message is not null then
1170: hr_utility.set_location('l_error_message is not null:'||l_proc,25);
1171: hr_utility.raise_error;
1172: end if;
1173:
1174:
1175: hr_utility.set_location('Exiting:'||l_proc, 30);

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

1171: hr_utility.raise_error;
1172: end if;
1173:
1174:
1175: hr_utility.set_location('Exiting:'||l_proc, 30);
1176: EXCEPTION
1177: WHEN OTHERS THEN
1178: hr_utility.set_location('Exception:Others'||l_proc,555);
1179: raise;

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

1174:
1175: hr_utility.set_location('Exiting:'||l_proc, 30);
1176: EXCEPTION
1177: WHEN OTHERS THEN
1178: hr_utility.set_location('Exception:Others'||l_proc,555);
1179: raise;
1180:
1181: END process_api;
1182:

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

1201: l_proc varchar2(72) := g_package||'get_segments_from_ccid';
1202:
1203: BEGIN
1204:
1205: hr_utility.set_location('Entering:'||l_proc, 5);
1206: open csr_criteria_segments;
1207: fetch csr_criteria_segments into l_criteria_segments;
1208: close csr_criteria_segments;
1209:

Line 1243: hr_utility.set_location('Exiting:'||l_proc, 10);

1239: l_analysis_criteria_rec.segment29 := l_criteria_segments.segment29;
1240: l_analysis_criteria_rec.segment30 := l_criteria_segments.segment30;
1241:
1242:
1243: hr_utility.set_location('Exiting:'||l_proc, 10);
1244: RETURN l_analysis_criteria_rec;
1245:
1246: END get_segments_from_ccid;
1247:

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

1263: ) IS
1264: l_proc varchar2(72) := g_package||'del_transaction_data';
1265:
1266: BEGIN
1267: hr_utility.set_location('Entering:'||l_proc, 5);
1268: if p_flow_mode is not null and
1269: p_flow_mode = hr_process_assignment_ss.g_new_hire_registration
1270: then
1271: hr_utility.set_location('Flow mode is NewHire Reg:'||l_proc,10);

Line 1271: hr_utility.set_location('Flow mode is NewHire Reg:'||l_proc,10);

1267: hr_utility.set_location('Entering:'||l_proc, 5);
1268: if p_flow_mode is not null and
1269: p_flow_mode = hr_process_assignment_ss.g_new_hire_registration
1270: then
1271: hr_utility.set_location('Flow mode is NewHire Reg:'||l_proc,10);
1272: rollback;
1273: end if;
1274: hr_transaction_ss.delete_transaction_steps(
1275: p_item_type => p_item_type

Line 1281: hr_utility.set_location('Exiting:'||l_proc, 15);

1277: ,p_actid => p_activity_id
1278: ,p_login_person_id => p_login_person_id
1279: );
1280:
1281: hr_utility.set_location('Exiting:'||l_proc, 15);
1282: END del_transaction_data;
1283:
1284: end hr_process_sit_ss;