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.GHR_API dependencies on HR_UTILITY

Line 88: -- Calling hr_utility procedures are commented out to these procedures

84: -- Post Failure:
85: -- An application error will be raised and processing is terminated.
86: --
87: -- Developer Implementation Notes:
88: -- Calling hr_utility procedures are commented out to these procedures
89: -- update the database which violates the function requirement.
90: --
91: -- Access Status:
92: -- Internal Use Only.

Line 125: -- hr_utility.set_location('Entering:'||l_proc, 1);

121: and trunc(eff_date) between asg.effective_start_date
122: and asg.effective_end_date;
123: --
124: begin
125: -- hr_utility.set_location('Entering:'||l_proc, 1);
126: p_business_group_id := NULL;
127: --
128: if p_person_id is NULL and p_assignment_id is NULL then
129: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');

Line 129: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');

125: -- hr_utility.set_location('Entering:'||l_proc, 1);
126: p_business_group_id := NULL;
127: --
128: if p_person_id is NULL and p_assignment_id is NULL then
129: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');
130: -- hr_utility.raise_error;
131: null;
132: elsif p_assignment_id is NULL then
133: for per_type in c_per_type(p_person_id,p_effective_date) loop

Line 130: -- hr_utility.raise_error;

126: p_business_group_id := NULL;
127: --
128: if p_person_id is NULL and p_assignment_id is NULL then
129: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');
130: -- hr_utility.raise_error;
131: null;
132: elsif p_assignment_id is NULL then
133: for per_type in c_per_type(p_person_id,p_effective_date) loop
134: l_person_type := per_type.system_person_type;

Line 145: -- hr_utility.set_message(8301, 'GHR_38024_API_INV_PER');

141: p_business_group_id := c_person_rec.business_group_id;
142: exit;
143: end loop;
144: if not l_person_found then
145: -- hr_utility.set_message(8301, 'GHR_38024_API_INV_PER');
146: -- hr_utility.raise_error;
147: null;
148: end if;
149: End if;-- Roh

Line 146: -- hr_utility.raise_error;

142: exit;
143: end loop;
144: if not l_person_found then
145: -- hr_utility.set_message(8301, 'GHR_38024_API_INV_PER');
146: -- hr_utility.raise_error;
147: null;
148: end if;
149: End if;-- Roh
150: else -- p_assignment_id is not NULL

Line 157: -- hr_utility.set_message(8301, 'GHR_38023_API_INV_ASG');

153: p_business_group_id := c_assignment_rec.business_group_id;
154: exit;
155: end loop;
156: if not l_assignment_found then
157: -- hr_utility.set_message(8301, 'GHR_38023_API_INV_ASG');
158: -- hr_utility.raise_error;
159: null;
160: end if;
161: end if;

Line 158: -- hr_utility.raise_error;

154: exit;
155: end loop;
156: if not l_assignment_found then
157: -- hr_utility.set_message(8301, 'GHR_38023_API_INV_ASG');
158: -- hr_utility.raise_error;
159: null;
160: end if;
161: end if;
162: --

Line 163: -- hr_utility.set_location(' Leaving:'||l_proc, 2);

159: null;
160: end if;
161: end if;
162: --
163: -- hr_utility.set_location(' Leaving:'||l_proc, 2);
164: EXCEPTION when others then
165: -- NOCOPY changes
166: -- Reset IN OUT params and set OUT params
167: p_business_group_id := NULL;

Line 243: -- Calling hr_utility procedures are commented OUT NOCOPY due to these procedures

239: -- Post Failure:
240: -- An application error will be raised and processing is terminated.
241: --
242: -- Developer Implementation Notes:
243: -- Calling hr_utility procedures are commented OUT NOCOPY due to these procedures
244: -- update the database which violates the function requirement.
245: --
246: -- Access Status:
247: -- Internal Use Only.

Line 271: -- hr_utility.set_location('Entering:'||l_proc, 1);

267: where oi.organization_id = org_id
268: and oi.org_information_context = 'GHR_US_ORG_INFORMATION';
269: --
270: begin
271: -- hr_utility.set_location('Entering:'||l_proc, 1);
272: p_org_info_rec.information1 := NULL;
273: p_org_info_rec.information2 := NULL;
274: p_org_info_rec.information3 := NULL;
275: p_org_info_rec.information4 := NULL;

Line 289: -- hr_utility.set_message(8301, 'GHR_38025_API_INV_ORG');

285: p_org_info_rec.information5 := c_organization_information_rec.org_information5;
286: exit;
287: end loop;
288: if not l_org_info_found then
289: -- hr_utility.set_message(8301, 'GHR_38025_API_INV_ORG');
290: -- hr_utility.raise_error;
291: null;
292: end if;
293: -- hr_utility.set_location(l_proc, 2);

Line 290: -- hr_utility.raise_error;

286: exit;
287: end loop;
288: if not l_org_info_found then
289: -- hr_utility.set_message(8301, 'GHR_38025_API_INV_ORG');
290: -- hr_utility.raise_error;
291: null;
292: end if;
293: -- hr_utility.set_location(l_proc, 2);
294: --

Line 293: -- hr_utility.set_location(l_proc, 2);

289: -- hr_utility.set_message(8301, 'GHR_38025_API_INV_ORG');
290: -- hr_utility.raise_error;
291: null;
292: end if;
293: -- hr_utility.set_location(l_proc, 2);
294: --
295: if (p_org_info_rec.information1 is NULL
296: and p_org_info_rec.information2 is NULL
297: and p_org_info_rec.information3 is NULL

Line 300: -- hr_utility.set_message(8301, 'GHR_38033_API_ORG_DDF_NOT_EXST');

296: and p_org_info_rec.information2 is NULL
297: and p_org_info_rec.information3 is NULL
298: and p_org_info_rec.information4 is NULL
299: and p_org_info_rec.information5 is NULL) then
300: -- hr_utility.set_message(8301, 'GHR_38033_API_ORG_DDF_NOT_EXST');
301: -- hr_utility.raise_error;
302: null;
303: end if;
304: --

Line 301: -- hr_utility.raise_error;

297: and p_org_info_rec.information3 is NULL
298: and p_org_info_rec.information4 is NULL
299: and p_org_info_rec.information5 is NULL) then
300: -- hr_utility.set_message(8301, 'GHR_38033_API_ORG_DDF_NOT_EXST');
301: -- hr_utility.raise_error;
302: null;
303: end if;
304: --
305: -- hr_utility.set_location(' Leaving:'||l_proc, 3);

Line 305: -- hr_utility.set_location(' Leaving:'||l_proc, 3);

301: -- hr_utility.raise_error;
302: null;
303: end if;
304: --
305: -- hr_utility.set_location(' Leaving:'||l_proc, 3);
306: --
307: exception
308: when no_data_found then
309: -- hr_utility.set_message(8301, 'GHR_38033_API_ORG_DDF_NOT_EXST');

Line 309: -- hr_utility.set_message(8301, 'GHR_38033_API_ORG_DDF_NOT_EXST');

305: -- hr_utility.set_location(' Leaving:'||l_proc, 3);
306: --
307: exception
308: when no_data_found then
309: -- hr_utility.set_message(8301, 'GHR_38033_API_ORG_DDF_NOT_EXST');
310: -- hr_utility.raise_error;
311: null;
312: when others then
313: -- NOCOPY changes

Line 310: -- hr_utility.raise_error;

306: --
307: exception
308: when no_data_found then
309: -- hr_utility.set_message(8301, 'GHR_38033_API_ORG_DDF_NOT_EXST');
310: -- hr_utility.raise_error;
311: null;
312: when others then
313: -- NOCOPY changes
314: -- Reset IN OUT params and set OUT params

Line 345: -- Calling hr_utility procedures are commented OUT NOCOPY due to these procedures

341: -- Post Failure:
342: -- An application error will be raised and processing is terminated.
343: --
344: -- Developer Implementation Notes:
345: -- Calling hr_utility procedures are commented OUT NOCOPY due to these procedures
346: -- update the database which violates the function requirement.
347: --
348: -- Access Status:
349: -- Internal Use Only.

Line 825: -- hr_utility.set_location('Entering:'||l_proc, 1);

821: and job.job_id = p_job_id;
822:
823: --
824: begin
825: -- hr_utility.set_location('Entering:'||l_proc, 1);
826: /*
827: --
828: -- Open the cursor
829: --

Line 873: -- hr_utility.set_location(' Leaving:'||l_proc, 5);

869: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
870: end if;
871: --
872: p_segment := l_segment;
873: -- hr_utility.set_location(' Leaving:'||l_proc, 5);
874: --
875: --
876: exception
877: when others then

Line 882: -- hr_utility.set_message(8301,'GHR_9999_API_DYNAMIC_SQL_ERR');

878: --
879: -- Close cursor, then raise error
880: --
881: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
882: -- hr_utility.set_message(8301,'GHR_9999_API_DYNAMIC_SQL_ERR');
883: -- hr_utility.raise_error;
884: */
885: --
886: p_segment := NULL;

Line 883: -- hr_utility.raise_error;

879: -- Close cursor, then raise error
880: --
881: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
882: -- hr_utility.set_message(8301,'GHR_9999_API_DYNAMIC_SQL_ERR');
883: -- hr_utility.raise_error;
884: */
885: --
886: p_segment := NULL;
887: --

Line 896: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');

892: p_segment := c_pos_seg1_rec.segment1;
893: exit;
894: end loop;
895: if not l_pos_seg1_found then
896: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
897: -- hr_utility.raise_error;
898: null;
899: end if;
900: --

Line 897: -- hr_utility.raise_error;

893: exit;
894: end loop;
895: if not l_pos_seg1_found then
896: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
897: -- hr_utility.raise_error;
898: null;
899: end if;
900: --
901: elsif p_information = 'SEGMENT2' then

Line 908: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');

904: p_segment := c_pos_seg2_rec.segment2;
905: exit;
906: end loop;
907: if not l_pos_seg2_found then
908: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
909: -- hr_utility.raise_error;
910: null;
911: end if;
912: --

Line 909: -- hr_utility.raise_error;

905: exit;
906: end loop;
907: if not l_pos_seg2_found then
908: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
909: -- hr_utility.raise_error;
910: null;
911: end if;
912: --
913: elsif p_information = 'SEGMENT3' then

Line 920: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');

916: p_segment := c_pos_seg3_rec.segment3;
917: exit;
918: end loop;
919: if not l_pos_seg3_found then
920: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
921: -- hr_utility.raise_error;
922: null;
923: end if;
924: --

Line 921: -- hr_utility.raise_error;

917: exit;
918: end loop;
919: if not l_pos_seg3_found then
920: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
921: -- hr_utility.raise_error;
922: null;
923: end if;
924: --
925: elsif p_information = 'SEGMENT4' then

Line 932: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');

928: p_segment := c_pos_seg4_rec.segment4;
929: exit;
930: end loop;
931: if not l_pos_seg4_found then
932: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
933: -- hr_utility.raise_error;
934: null;
935: end if;
936: --

Line 933: -- hr_utility.raise_error;

929: exit;
930: end loop;
931: if not l_pos_seg4_found then
932: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
933: -- hr_utility.raise_error;
934: null;
935: end if;
936: --
937: elsif p_information = 'SEGMENT5' then

Line 944: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');

940: p_segment := c_pos_seg5_rec.segment5;
941: exit;
942: end loop;
943: if not l_pos_seg5_found then
944: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
945: -- hr_utility.raise_error;
946: null;
947: end if;
948: --

Line 945: -- hr_utility.raise_error;

941: exit;
942: end loop;
943: if not l_pos_seg5_found then
944: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
945: -- hr_utility.raise_error;
946: null;
947: end if;
948: --
949: elsif p_information = 'SEGMENT6' then

Line 956: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');

952: p_segment := c_pos_seg6_rec.segment6;
953: exit;
954: end loop;
955: if not l_pos_seg6_found then
956: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
957: -- hr_utility.raise_error;
958: null;
959: end if;
960: --

Line 957: -- hr_utility.raise_error;

953: exit;
954: end loop;
955: if not l_pos_seg6_found then
956: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
957: -- hr_utility.raise_error;
958: null;
959: end if;
960: --
961: elsif p_information = 'SEGMENT7' then

Line 968: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');

964: p_segment := c_pos_seg7_rec.segment7;
965: exit;
966: end loop;
967: if not l_pos_seg7_found then
968: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
969: -- hr_utility.raise_error;
970: null;
971: end if;
972: --

Line 969: -- hr_utility.raise_error;

965: exit;
966: end loop;
967: if not l_pos_seg7_found then
968: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
969: -- hr_utility.raise_error;
970: null;
971: end if;
972: --
973: elsif p_information = 'SEGMENT8' then

Line 980: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');

976: p_segment := c_pos_seg8_rec.segment8;
977: exit;
978: end loop;
979: if not l_pos_seg8_found then
980: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
981: -- hr_utility.raise_error;
982: null;
983: end if;
984: --

Line 981: -- hr_utility.raise_error;

977: exit;
978: end loop;
979: if not l_pos_seg8_found then
980: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
981: -- hr_utility.raise_error;
982: null;
983: end if;
984: --
985: elsif p_information = 'SEGMENT9' then

Line 992: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');

988: p_segment := c_pos_seg9_rec.segment9;
989: exit;
990: end loop;
991: if not l_pos_seg9_found then
992: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
993: -- hr_utility.raise_error;
994: null;
995: end if;
996: --

Line 993: -- hr_utility.raise_error;

989: exit;
990: end loop;
991: if not l_pos_seg9_found then
992: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
993: -- hr_utility.raise_error;
994: null;
995: end if;
996: --
997: elsif p_information = 'SEGMENT10' then

Line 1004: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');

1000: p_segment := c_pos_seg10_rec.segment10;
1001: exit;
1002: end loop;
1003: if not l_pos_seg10_found then
1004: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
1005: -- hr_utility.raise_error;
1006: null;
1007: end if;
1008: --

Line 1005: -- hr_utility.raise_error;

1001: exit;
1002: end loop;
1003: if not l_pos_seg10_found then
1004: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
1005: -- hr_utility.raise_error;
1006: null;
1007: end if;
1008: --
1009: elsif p_information = 'SEGMENT11' then

Line 1016: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');

1012: p_segment := c_pos_seg11_rec.segment11;
1013: exit;
1014: end loop;
1015: if not l_pos_seg11_found then
1016: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
1017: -- hr_utility.raise_error;
1018: null;
1019: end if;
1020: --

Line 1017: -- hr_utility.raise_error;

1013: exit;
1014: end loop;
1015: if not l_pos_seg11_found then
1016: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
1017: -- hr_utility.raise_error;
1018: null;
1019: end if;
1020: --
1021: elsif p_information = 'SEGMENT12' then

Line 1028: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');

1024: p_segment := c_pos_seg12_rec.segment12;
1025: exit;
1026: end loop;
1027: if not l_pos_seg12_found then
1028: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
1029: -- hr_utility.raise_error;
1030: null;
1031: end if;
1032: --

Line 1029: -- hr_utility.raise_error;

1025: exit;
1026: end loop;
1027: if not l_pos_seg12_found then
1028: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
1029: -- hr_utility.raise_error;
1030: null;
1031: end if;
1032: --
1033: elsif p_information = 'SEGMENT13' then

Line 1040: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');

1036: p_segment := c_pos_seg13_rec.segment13;
1037: exit;
1038: end loop;
1039: if not l_pos_seg13_found then
1040: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
1041: -- hr_utility.raise_error;
1042: null;
1043: end if;
1044: --

Line 1041: -- hr_utility.raise_error;

1037: exit;
1038: end loop;
1039: if not l_pos_seg13_found then
1040: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
1041: -- hr_utility.raise_error;
1042: null;
1043: end if;
1044: --
1045: elsif p_information = 'SEGMENT14' then

Line 1052: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');

1048: p_segment := c_pos_seg14_rec.segment14;
1049: exit;
1050: end loop;
1051: if not l_pos_seg14_found then
1052: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
1053: -- hr_utility.raise_error;
1054: null;
1055: end if;
1056: --

Line 1053: -- hr_utility.raise_error;

1049: exit;
1050: end loop;
1051: if not l_pos_seg14_found then
1052: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
1053: -- hr_utility.raise_error;
1054: null;
1055: end if;
1056: --
1057: elsif p_information = 'SEGMENT15' then

Line 1064: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');

1060: p_segment := c_pos_seg15_rec.segment15;
1061: exit;
1062: end loop;
1063: if not l_pos_seg15_found then
1064: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
1065: -- hr_utility.raise_error;
1066: null;
1067: end if;
1068: --

Line 1065: -- hr_utility.raise_error;

1061: exit;
1062: end loop;
1063: if not l_pos_seg15_found then
1064: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
1065: -- hr_utility.raise_error;
1066: null;
1067: end if;
1068: --
1069: elsif p_information = 'SEGMENT15' then

Line 1076: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');

1072: p_segment := c_pos_seg15_rec.segment15;
1073: exit;
1074: end loop;
1075: if not l_pos_seg15_found then
1076: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
1077: -- hr_utility.raise_error;
1078: null;
1079: end if;
1080: --

Line 1077: -- hr_utility.raise_error;

1073: exit;
1074: end loop;
1075: if not l_pos_seg15_found then
1076: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
1077: -- hr_utility.raise_error;
1078: null;
1079: end if;
1080: --
1081: elsif p_information = 'SEGMENT16' then

Line 1088: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');

1084: p_segment := c_pos_seg16_rec.segment16;
1085: exit;
1086: end loop;
1087: if not l_pos_seg16_found then
1088: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
1089: -- hr_utility.raise_error;
1090: null;
1091: end if;
1092: --

Line 1089: -- hr_utility.raise_error;

1085: exit;
1086: end loop;
1087: if not l_pos_seg16_found then
1088: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
1089: -- hr_utility.raise_error;
1090: null;
1091: end if;
1092: --
1093: elsif p_information = 'SEGMENT17' then

Line 1100: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');

1096: p_segment := c_pos_seg17_rec.segment17;
1097: exit;
1098: end loop;
1099: if not l_pos_seg17_found then
1100: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
1101: -- hr_utility.raise_error;
1102: null;
1103: end if;
1104: --

Line 1101: -- hr_utility.raise_error;

1097: exit;
1098: end loop;
1099: if not l_pos_seg17_found then
1100: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
1101: -- hr_utility.raise_error;
1102: null;
1103: end if;
1104: --
1105: elsif p_information = 'SEGMENT18' then

Line 1112: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');

1108: p_segment := c_pos_seg18_rec.segment18;
1109: exit;
1110: end loop;
1111: if not l_pos_seg18_found then
1112: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
1113: -- hr_utility.raise_error;
1114: null;
1115: end if;
1116: --

Line 1113: -- hr_utility.raise_error;

1109: exit;
1110: end loop;
1111: if not l_pos_seg18_found then
1112: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
1113: -- hr_utility.raise_error;
1114: null;
1115: end if;
1116: --
1117: elsif p_information = 'SEGMENT19' then

Line 1124: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');

1120: p_segment := c_pos_seg19_rec.segment19;
1121: exit;
1122: end loop;
1123: if not l_pos_seg19_found then
1124: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
1125: -- hr_utility.raise_error;
1126: null;
1127: end if;
1128: --

Line 1125: -- hr_utility.raise_error;

1121: exit;
1122: end loop;
1123: if not l_pos_seg19_found then
1124: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
1125: -- hr_utility.raise_error;
1126: null;
1127: end if;
1128: --
1129: elsif p_information = 'SEGMENT20' then

Line 1136: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');

1132: p_segment := c_pos_seg20_rec.segment20;
1133: exit;
1134: end loop;
1135: if not l_pos_seg20_found then
1136: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
1137: -- hr_utility.raise_error;
1138: null;
1139: end if;
1140: --

Line 1137: -- hr_utility.raise_error;

1133: exit;
1134: end loop;
1135: if not l_pos_seg20_found then
1136: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
1137: -- hr_utility.raise_error;
1138: null;
1139: end if;
1140: --
1141: elsif p_information = 'SEGMENT21' then

Line 1148: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');

1144: p_segment := c_pos_seg21_rec.segment21;
1145: exit;
1146: end loop;
1147: if not l_pos_seg21_found then
1148: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
1149: -- hr_utility.raise_error;
1150: null;
1151: end if;
1152: --

Line 1149: -- hr_utility.raise_error;

1145: exit;
1146: end loop;
1147: if not l_pos_seg21_found then
1148: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
1149: -- hr_utility.raise_error;
1150: null;
1151: end if;
1152: --
1153: elsif p_information = 'SEGMENT22' then

Line 1160: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');

1156: p_segment := c_pos_seg22_rec.segment22;
1157: exit;
1158: end loop;
1159: if not l_pos_seg22_found then
1160: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
1161: -- hr_utility.raise_error;
1162: null;
1163: end if;
1164: --

Line 1161: -- hr_utility.raise_error;

1157: exit;
1158: end loop;
1159: if not l_pos_seg22_found then
1160: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
1161: -- hr_utility.raise_error;
1162: null;
1163: end if;
1164: --
1165: elsif p_information = 'SEGMENT23' then

Line 1172: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');

1168: p_segment := c_pos_seg23_rec.segment23;
1169: exit;
1170: end loop;
1171: if not l_pos_seg23_found then
1172: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
1173: -- hr_utility.raise_error;
1174: null;
1175: end if;
1176: --

Line 1173: -- hr_utility.raise_error;

1169: exit;
1170: end loop;
1171: if not l_pos_seg23_found then
1172: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
1173: -- hr_utility.raise_error;
1174: null;
1175: end if;
1176: --
1177: elsif p_information = 'SEGMENT24' then

Line 1184: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');

1180: p_segment := c_pos_seg24_rec.segment24;
1181: exit;
1182: end loop;
1183: if not l_pos_seg24_found then
1184: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
1185: -- hr_utility.raise_error;
1186: null;
1187: end if;
1188: --

Line 1185: -- hr_utility.raise_error;

1181: exit;
1182: end loop;
1183: if not l_pos_seg24_found then
1184: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
1185: -- hr_utility.raise_error;
1186: null;
1187: end if;
1188: --
1189: elsif p_information = 'SEGMENT25' then

Line 1196: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');

1192: p_segment := c_pos_seg25_rec.segment25;
1193: exit;
1194: end loop;
1195: if not l_pos_seg25_found then
1196: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
1197: -- hr_utility.raise_error;
1198: null;
1199: end if;
1200: --

Line 1197: -- hr_utility.raise_error;

1193: exit;
1194: end loop;
1195: if not l_pos_seg25_found then
1196: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
1197: -- hr_utility.raise_error;
1198: null;
1199: end if;
1200: --
1201: elsif p_information = 'SEGMENT26' then

Line 1208: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');

1204: p_segment := c_pos_seg26_rec.segment26;
1205: exit;
1206: end loop;
1207: if not l_pos_seg26_found then
1208: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
1209: -- hr_utility.raise_error;
1210: null;
1211: end if;
1212: --

Line 1209: -- hr_utility.raise_error;

1205: exit;
1206: end loop;
1207: if not l_pos_seg26_found then
1208: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
1209: -- hr_utility.raise_error;
1210: null;
1211: end if;
1212: --
1213: elsif p_information = 'SEGMENT27' then

Line 1220: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');

1216: p_segment := c_pos_seg27_rec.segment27;
1217: exit;
1218: end loop;
1219: if not l_pos_seg27_found then
1220: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
1221: -- hr_utility.raise_error;
1222: null;
1223: end if;
1224: --

Line 1221: -- hr_utility.raise_error;

1217: exit;
1218: end loop;
1219: if not l_pos_seg27_found then
1220: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
1221: -- hr_utility.raise_error;
1222: null;
1223: end if;
1224: --
1225: elsif p_information = 'SEGMENT28' then

Line 1232: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');

1228: p_segment := c_pos_seg28_rec.segment28;
1229: exit;
1230: end loop;
1231: if not l_pos_seg28_found then
1232: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
1233: -- hr_utility.raise_error;
1234: null;
1235: end if;
1236: --

Line 1233: -- hr_utility.raise_error;

1229: exit;
1230: end loop;
1231: if not l_pos_seg28_found then
1232: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
1233: -- hr_utility.raise_error;
1234: null;
1235: end if;
1236: --
1237: elsif p_information = 'SEGMENT29' then

Line 1244: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');

1240: p_segment := c_pos_seg29_rec.segment29;
1241: exit;
1242: end loop;
1243: if not l_pos_seg29_found then
1244: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
1245: -- hr_utility.raise_error;
1246: null;
1247: end if;
1248: --

Line 1245: -- hr_utility.raise_error;

1241: exit;
1242: end loop;
1243: if not l_pos_seg29_found then
1244: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
1245: -- hr_utility.raise_error;
1246: null;
1247: end if;
1248: --
1249: elsif p_information = 'SEGMENT30' then

Line 1256: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');

1252: p_segment := c_pos_seg30_rec.segment30;
1253: exit;
1254: end loop;
1255: if not l_pos_seg30_found then
1256: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
1257: -- hr_utility.raise_error;
1258: null;
1259: end if;
1260: end if; /* p_information */

Line 1257: -- hr_utility.raise_error;

1253: exit;
1254: end loop;
1255: if not l_pos_seg30_found then
1256: -- hr_utility.set_message(8301, 'GHR_38028_API_INV_POS');
1257: -- hr_utility.raise_error;
1258: null;
1259: end if;
1260: end if; /* p_information */
1261: --

Line 1270: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');

1266: p_segment := c_job_seg1_rec.segment1;
1267: exit;
1268: end loop;
1269: if not l_job_seg1_found then
1270: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1271: -- hr_utility.raise_error;
1272: null;
1273: end if;
1274: --

Line 1271: -- hr_utility.raise_error;

1267: exit;
1268: end loop;
1269: if not l_job_seg1_found then
1270: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1271: -- hr_utility.raise_error;
1272: null;
1273: end if;
1274: --
1275: elsif p_information = 'SEGMENT2' then

Line 1282: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');

1278: p_segment := c_job_seg2_rec.segment2;
1279: exit;
1280: end loop;
1281: if not l_job_seg2_found then
1282: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1283: -- hr_utility.raise_error;
1284: null;
1285: end if;
1286: --

Line 1283: -- hr_utility.raise_error;

1279: exit;
1280: end loop;
1281: if not l_job_seg2_found then
1282: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1283: -- hr_utility.raise_error;
1284: null;
1285: end if;
1286: --
1287: elsif p_information = 'SEGMENT3' then

Line 1294: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');

1290: p_segment := c_job_seg3_rec.segment3;
1291: exit;
1292: end loop;
1293: if not l_job_seg3_found then
1294: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1295: -- hr_utility.raise_error;
1296: null;
1297: end if;
1298: --

Line 1295: -- hr_utility.raise_error;

1291: exit;
1292: end loop;
1293: if not l_job_seg3_found then
1294: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1295: -- hr_utility.raise_error;
1296: null;
1297: end if;
1298: --
1299: elsif p_information = 'SEGMENT4' then

Line 1306: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');

1302: p_segment := c_job_seg4_rec.segment4;
1303: exit;
1304: end loop;
1305: if not l_job_seg4_found then
1306: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1307: -- hr_utility.raise_error;
1308: null;
1309: end if;
1310: --

Line 1307: -- hr_utility.raise_error;

1303: exit;
1304: end loop;
1305: if not l_job_seg4_found then
1306: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1307: -- hr_utility.raise_error;
1308: null;
1309: end if;
1310: --
1311: elsif p_information = 'SEGMENT5' then

Line 1318: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');

1314: p_segment := c_job_seg5_rec.segment5;
1315: exit;
1316: end loop;
1317: if not l_job_seg5_found then
1318: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1319: -- hr_utility.raise_error;
1320: null;
1321: end if;
1322: --

Line 1319: -- hr_utility.raise_error;

1315: exit;
1316: end loop;
1317: if not l_job_seg5_found then
1318: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1319: -- hr_utility.raise_error;
1320: null;
1321: end if;
1322: --
1323: elsif p_information = 'SEGMENT6' then

Line 1330: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');

1326: p_segment := c_job_seg6_rec.segment6;
1327: exit;
1328: end loop;
1329: if not l_job_seg6_found then
1330: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1331: -- hr_utility.raise_error;
1332: null;
1333: end if;
1334: --

Line 1331: -- hr_utility.raise_error;

1327: exit;
1328: end loop;
1329: if not l_job_seg6_found then
1330: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1331: -- hr_utility.raise_error;
1332: null;
1333: end if;
1334: --
1335: elsif p_information = 'SEGMENT7' then

Line 1342: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');

1338: p_segment := c_job_seg7_rec.segment7;
1339: exit;
1340: end loop;
1341: if not l_job_seg7_found then
1342: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1343: -- hr_utility.raise_error;
1344: null;
1345: end if;
1346: --

Line 1343: -- hr_utility.raise_error;

1339: exit;
1340: end loop;
1341: if not l_job_seg7_found then
1342: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1343: -- hr_utility.raise_error;
1344: null;
1345: end if;
1346: --
1347: elsif p_information = 'SEGMENT8' then

Line 1354: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');

1350: p_segment := c_job_seg8_rec.segment8;
1351: exit;
1352: end loop;
1353: if not l_job_seg8_found then
1354: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1355: -- hr_utility.raise_error;
1356: null;
1357: end if;
1358: --

Line 1355: -- hr_utility.raise_error;

1351: exit;
1352: end loop;
1353: if not l_job_seg8_found then
1354: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1355: -- hr_utility.raise_error;
1356: null;
1357: end if;
1358: --
1359: elsif p_information = 'SEGMENT9' then

Line 1366: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');

1362: p_segment := c_job_seg9_rec.segment9;
1363: exit;
1364: end loop;
1365: if not l_job_seg9_found then
1366: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1367: -- hr_utility.raise_error;
1368: null;
1369: end if;
1370: --

Line 1367: -- hr_utility.raise_error;

1363: exit;
1364: end loop;
1365: if not l_job_seg9_found then
1366: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1367: -- hr_utility.raise_error;
1368: null;
1369: end if;
1370: --
1371: elsif p_information = 'SEGMENT10' then

Line 1378: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');

1374: p_segment := c_job_seg10_rec.segment10;
1375: exit;
1376: end loop;
1377: if not l_job_seg10_found then
1378: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1379: -- hr_utility.raise_error;
1380: null;
1381: end if;
1382: --

Line 1379: -- hr_utility.raise_error;

1375: exit;
1376: end loop;
1377: if not l_job_seg10_found then
1378: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1379: -- hr_utility.raise_error;
1380: null;
1381: end if;
1382: --
1383: elsif p_information = 'SEGMENT11' then

Line 1390: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');

1386: p_segment := c_job_seg11_rec.segment11;
1387: exit;
1388: end loop;
1389: if not l_job_seg11_found then
1390: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1391: -- hr_utility.raise_error;
1392: null;
1393: end if;
1394: --

Line 1391: -- hr_utility.raise_error;

1387: exit;
1388: end loop;
1389: if not l_job_seg11_found then
1390: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1391: -- hr_utility.raise_error;
1392: null;
1393: end if;
1394: --
1395: elsif p_information = 'SEGMENT12' then

Line 1402: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');

1398: p_segment := c_job_seg12_rec.segment12;
1399: exit;
1400: end loop;
1401: if not l_job_seg12_found then
1402: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1403: -- hr_utility.raise_error;
1404: null;
1405: end if;
1406: --

Line 1403: -- hr_utility.raise_error;

1399: exit;
1400: end loop;
1401: if not l_job_seg12_found then
1402: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1403: -- hr_utility.raise_error;
1404: null;
1405: end if;
1406: --
1407: elsif p_information = 'SEGMENT13' then

Line 1414: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');

1410: p_segment := c_job_seg13_rec.segment13;
1411: exit;
1412: end loop;
1413: if not l_job_seg13_found then
1414: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1415: -- hr_utility.raise_error;
1416: null;
1417: end if;
1418: --

Line 1415: -- hr_utility.raise_error;

1411: exit;
1412: end loop;
1413: if not l_job_seg13_found then
1414: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1415: -- hr_utility.raise_error;
1416: null;
1417: end if;
1418: --
1419: elsif p_information = 'SEGMENT14' then

Line 1426: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');

1422: p_segment := c_job_seg14_rec.segment14;
1423: exit;
1424: end loop;
1425: if not l_job_seg14_found then
1426: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1427: -- hr_utility.raise_error;
1428: null;
1429: end if;
1430: --

Line 1427: -- hr_utility.raise_error;

1423: exit;
1424: end loop;
1425: if not l_job_seg14_found then
1426: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1427: -- hr_utility.raise_error;
1428: null;
1429: end if;
1430: --
1431: elsif p_information = 'SEGMENT15' then

Line 1438: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');

1434: p_segment := c_job_seg15_rec.segment15;
1435: exit;
1436: end loop;
1437: if not l_job_seg15_found then
1438: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1439: -- hr_utility.raise_error;
1440: null;
1441: end if;
1442: --

Line 1439: -- hr_utility.raise_error;

1435: exit;
1436: end loop;
1437: if not l_job_seg15_found then
1438: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1439: -- hr_utility.raise_error;
1440: null;
1441: end if;
1442: --
1443: elsif p_information = 'SEGMENT15' then

Line 1450: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');

1446: p_segment := c_job_seg15_rec.segment15;
1447: exit;
1448: end loop;
1449: if not l_job_seg15_found then
1450: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1451: -- hr_utility.raise_error;
1452: null;
1453: end if;
1454: --

Line 1451: -- hr_utility.raise_error;

1447: exit;
1448: end loop;
1449: if not l_job_seg15_found then
1450: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1451: -- hr_utility.raise_error;
1452: null;
1453: end if;
1454: --
1455: elsif p_information = 'SEGMENT16' then

Line 1462: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');

1458: p_segment := c_job_seg16_rec.segment16;
1459: exit;
1460: end loop;
1461: if not l_job_seg16_found then
1462: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1463: -- hr_utility.raise_error;
1464: null;
1465: end if;
1466: --

Line 1463: -- hr_utility.raise_error;

1459: exit;
1460: end loop;
1461: if not l_job_seg16_found then
1462: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1463: -- hr_utility.raise_error;
1464: null;
1465: end if;
1466: --
1467: elsif p_information = 'SEGMENT17' then

Line 1474: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');

1470: p_segment := c_job_seg17_rec.segment17;
1471: exit;
1472: end loop;
1473: if not l_job_seg17_found then
1474: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1475: -- hr_utility.raise_error;
1476: null;
1477: end if;
1478: --

Line 1475: -- hr_utility.raise_error;

1471: exit;
1472: end loop;
1473: if not l_job_seg17_found then
1474: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1475: -- hr_utility.raise_error;
1476: null;
1477: end if;
1478: --
1479: elsif p_information = 'SEGMENT18' then

Line 1486: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');

1482: p_segment := c_job_seg18_rec.segment18;
1483: exit;
1484: end loop;
1485: if not l_job_seg18_found then
1486: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1487: -- hr_utility.raise_error;
1488: null;
1489: end if;
1490: --

Line 1487: -- hr_utility.raise_error;

1483: exit;
1484: end loop;
1485: if not l_job_seg18_found then
1486: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1487: -- hr_utility.raise_error;
1488: null;
1489: end if;
1490: --
1491: elsif p_information = 'SEGMENT19' then

Line 1498: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');

1494: p_segment := c_job_seg19_rec.segment19;
1495: exit;
1496: end loop;
1497: if not l_job_seg19_found then
1498: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1499: -- hr_utility.raise_error;
1500: null;
1501: end if;
1502: --

Line 1499: -- hr_utility.raise_error;

1495: exit;
1496: end loop;
1497: if not l_job_seg19_found then
1498: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1499: -- hr_utility.raise_error;
1500: null;
1501: end if;
1502: --
1503: elsif p_information = 'SEGMENT20' then

Line 1510: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');

1506: p_segment := c_job_seg20_rec.segment20;
1507: exit;
1508: end loop;
1509: if not l_job_seg20_found then
1510: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1511: -- hr_utility.raise_error;
1512: null;
1513: end if;
1514: --

Line 1511: -- hr_utility.raise_error;

1507: exit;
1508: end loop;
1509: if not l_job_seg20_found then
1510: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1511: -- hr_utility.raise_error;
1512: null;
1513: end if;
1514: --
1515: elsif p_information = 'SEGMENT21' then

Line 1522: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');

1518: p_segment := c_job_seg21_rec.segment21;
1519: exit;
1520: end loop;
1521: if not l_job_seg21_found then
1522: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1523: -- hr_utility.raise_error;
1524: null;
1525: end if;
1526: --

Line 1523: -- hr_utility.raise_error;

1519: exit;
1520: end loop;
1521: if not l_job_seg21_found then
1522: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1523: -- hr_utility.raise_error;
1524: null;
1525: end if;
1526: --
1527: elsif p_information = 'SEGMENT22' then

Line 1534: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');

1530: p_segment := c_job_seg22_rec.segment22;
1531: exit;
1532: end loop;
1533: if not l_job_seg22_found then
1534: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1535: -- hr_utility.raise_error;
1536: null;
1537: end if;
1538: --

Line 1535: -- hr_utility.raise_error;

1531: exit;
1532: end loop;
1533: if not l_job_seg22_found then
1534: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1535: -- hr_utility.raise_error;
1536: null;
1537: end if;
1538: --
1539: elsif p_information = 'SEGMENT23' then

Line 1546: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');

1542: p_segment := c_job_seg23_rec.segment23;
1543: exit;
1544: end loop;
1545: if not l_job_seg23_found then
1546: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1547: -- hr_utility.raise_error;
1548: null;
1549: end if;
1550: --

Line 1547: -- hr_utility.raise_error;

1543: exit;
1544: end loop;
1545: if not l_job_seg23_found then
1546: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1547: -- hr_utility.raise_error;
1548: null;
1549: end if;
1550: --
1551: elsif p_information = 'SEGMENT24' then

Line 1558: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');

1554: p_segment := c_job_seg24_rec.segment24;
1555: exit;
1556: end loop;
1557: if not l_job_seg24_found then
1558: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1559: -- hr_utility.raise_error;
1560: null;
1561: end if;
1562: --

Line 1559: -- hr_utility.raise_error;

1555: exit;
1556: end loop;
1557: if not l_job_seg24_found then
1558: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1559: -- hr_utility.raise_error;
1560: null;
1561: end if;
1562: --
1563: elsif p_information = 'SEGMENT25' then

Line 1570: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');

1566: p_segment := c_job_seg25_rec.segment25;
1567: exit;
1568: end loop;
1569: if not l_job_seg25_found then
1570: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1571: -- hr_utility.raise_error;
1572: null;
1573: end if;
1574: --

Line 1571: -- hr_utility.raise_error;

1567: exit;
1568: end loop;
1569: if not l_job_seg25_found then
1570: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1571: -- hr_utility.raise_error;
1572: null;
1573: end if;
1574: --
1575: elsif p_information = 'SEGMENT26' then

Line 1582: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');

1578: p_segment := c_job_seg26_rec.segment26;
1579: exit;
1580: end loop;
1581: if not l_job_seg26_found then
1582: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1583: -- hr_utility.raise_error;
1584: null;
1585: end if;
1586: --

Line 1583: -- hr_utility.raise_error;

1579: exit;
1580: end loop;
1581: if not l_job_seg26_found then
1582: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1583: -- hr_utility.raise_error;
1584: null;
1585: end if;
1586: --
1587: elsif p_information = 'SEGMENT27' then

Line 1594: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');

1590: p_segment := c_job_seg27_rec.segment27;
1591: exit;
1592: end loop;
1593: if not l_job_seg27_found then
1594: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1595: -- hr_utility.raise_error;
1596: null;
1597: end if;
1598: --

Line 1595: -- hr_utility.raise_error;

1591: exit;
1592: end loop;
1593: if not l_job_seg27_found then
1594: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1595: -- hr_utility.raise_error;
1596: null;
1597: end if;
1598: --
1599: elsif p_information = 'SEGMENT28' then

Line 1606: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');

1602: p_segment := c_job_seg28_rec.segment28;
1603: exit;
1604: end loop;
1605: if not l_job_seg28_found then
1606: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1607: -- hr_utility.raise_error;
1608: null;
1609: end if;
1610: --

Line 1607: -- hr_utility.raise_error;

1603: exit;
1604: end loop;
1605: if not l_job_seg28_found then
1606: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1607: -- hr_utility.raise_error;
1608: null;
1609: end if;
1610: --
1611: elsif p_information = 'SEGMENT29' then

Line 1618: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');

1614: p_segment := c_job_seg29_rec.segment29;
1615: exit;
1616: end loop;
1617: if not l_job_seg29_found then
1618: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1619: -- hr_utility.raise_error;
1620: null;
1621: end if;
1622: --

Line 1619: -- hr_utility.raise_error;

1615: exit;
1616: end loop;
1617: if not l_job_seg29_found then
1618: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1619: -- hr_utility.raise_error;
1620: null;
1621: end if;
1622: --
1623: elsif p_information = 'SEGMENT30' then

Line 1630: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');

1626: p_segment := c_job_seg30_rec.segment30;
1627: exit;
1628: end loop;
1629: if not l_job_seg30_found then
1630: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1631: -- hr_utility.raise_error;
1632: null;
1633: end if;
1634: end if; /* p_information */

Line 1631: -- hr_utility.raise_error;

1627: exit;
1628: end loop;
1629: if not l_job_seg30_found then
1630: -- hr_utility.set_message(8301, 'GHR_38029_API_INV_JOB');
1631: -- hr_utility.raise_error;
1632: null;
1633: end if;
1634: end if; /* p_information */
1635: --

Line 1637: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');

1633: end if;
1634: end if; /* p_information */
1635: --
1636: else -- Invalid p_code
1637: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');
1638: -- hr_utility.raise_error;
1639: null;
1640: end if;
1641: --

Line 1638: -- hr_utility.raise_error;

1634: end if; /* p_information */
1635: --
1636: else -- Invalid p_code
1637: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');
1638: -- hr_utility.raise_error;
1639: null;
1640: end if;
1641: --
1642: exception when others then

Line 1760: hr_utility.set_location('Entering:'||l_proc, 1);

1756:
1757: --
1758: begin
1759: --
1760: hr_utility.set_location('Entering:'||l_proc, 1);
1761: ghr_history_api.get_g_session_var(l_session);
1762: ll_effective_date := p_effective_date;
1763: --
1764: -- Initialization

Line 1766: hr_utility.set_location('Asg Id'||to_char(p_assignment_id), 20);

1762: ll_effective_date := p_effective_date;
1763: --
1764: -- Initialization
1765: -- Pick the business group id and also pay basis for later use
1766: hr_utility.set_location('Asg Id'||to_char(p_assignment_id), 20);
1767:
1768: For BG_rec in Cur_BG(p_assignment_id,p_effective_date)
1769: Loop
1770: ll_bg_id:=BG_rec.bg;

Line 1784: hr_utility.set_location('PAYROLL User -- BSR -- from asgid-- '||l_proc, 1);

1780: ----
1781:
1782: IF (p_element_name = 'Basic Salary Rate'
1783: and (fnd_profile.value('HR_USER_TYPE') = 'INT')) THEN
1784: hr_utility.set_location('PAYROLL User -- BSR -- from asgid-- '||l_proc, 1);
1785: l_new_element_name :=
1786: pqp_fedhr_uspay_int_utils.return_new_element_name(
1787: p_assignment_id => p_assignment_id,
1788: p_business_group_id => ll_bg_id,

Line 1792: hr_utility.set_location('HR USER or PAYROLL User without BSR element -- from elt name -- '||l_proc, 1);

1788: p_business_group_id => ll_bg_id,
1789: p_effective_date => ll_effective_date);
1790: ELSIF (fnd_profile.value('HR_USER_TYPE') <> 'INT'
1791: or (p_element_name <> 'Basic Salary Rate' and (fnd_profile.value('HR_USER_TYPE') = 'INT'))) THEN
1792: hr_utility.set_location('HR USER or PAYROLL User without BSR element -- from elt name -- '||l_proc, 1);
1793: l_new_element_name :=
1794: pqp_fedhr_uspay_int_utils.return_new_element_name(
1795: p_fedhr_element_name => p_element_name,
1796: p_business_group_id => ll_bg_id,

Line 1802: hr_utility.set_location('Element Name ' ||p_element_name,1000);

1798: p_pay_basis => NULL);
1799:
1800: END IF;
1801:
1802: hr_utility.set_location('Element Name ' ||p_element_name,1000);
1803: hr_utility.set_location('BG ID '|| nvl(to_char(ll_bg_id),'NULL'),2000);
1804: hr_utility.set_location('Eff date'|| p_effective_date ,3000);
1805: hr_utility.set_location('pay basis ' || ll_pay_basis,3500);
1806: --

Line 1803: hr_utility.set_location('BG ID '|| nvl(to_char(ll_bg_id),'NULL'),2000);

1799:
1800: END IF;
1801:
1802: hr_utility.set_location('Element Name ' ||p_element_name,1000);
1803: hr_utility.set_location('BG ID '|| nvl(to_char(ll_bg_id),'NULL'),2000);
1804: hr_utility.set_location('Eff date'|| p_effective_date ,3000);
1805: hr_utility.set_location('pay basis ' || ll_pay_basis,3500);
1806: --
1807: -- the p_element_name is replaced with l_new_element_name

Line 1804: hr_utility.set_location('Eff date'|| p_effective_date ,3000);

1800: END IF;
1801:
1802: hr_utility.set_location('Element Name ' ||p_element_name,1000);
1803: hr_utility.set_location('BG ID '|| nvl(to_char(ll_bg_id),'NULL'),2000);
1804: hr_utility.set_location('Eff date'|| p_effective_date ,3000);
1805: hr_utility.set_location('pay basis ' || ll_pay_basis,3500);
1806: --
1807: -- the p_element_name is replaced with l_new_element_name
1808: -- in further calls.

Line 1805: hr_utility.set_location('pay basis ' || ll_pay_basis,3500);

1801:
1802: hr_utility.set_location('Element Name ' ||p_element_name,1000);
1803: hr_utility.set_location('BG ID '|| nvl(to_char(ll_bg_id),'NULL'),2000);
1804: hr_utility.set_location('Eff date'|| p_effective_date ,3000);
1805: hr_utility.set_location('pay basis ' || ll_pay_basis,3500);
1806: --
1807: -- the p_element_name is replaced with l_new_element_name
1808: -- in further calls.
1809: --

Line 1810: hr_utility.set_location('New element Name ' ||l_new_element_name,100000);

1806: --
1807: -- the p_element_name is replaced with l_new_element_name
1808: -- in further calls.
1809: --
1810: hr_utility.set_location('New element Name ' ||l_new_element_name,100000);
1811:
1812: hr_utility.set_location(l_proc,2);
1813:
1814: If l_session.noa_id_correct is not null then

Line 1812: hr_utility.set_location(l_proc,2);

1808: -- in further calls.
1809: --
1810: hr_utility.set_location('New element Name ' ||l_new_element_name,100000);
1811:
1812: hr_utility.set_location(l_proc,2);
1813:
1814: If l_session.noa_id_correct is not null then
1815: hr_utility.set_location(l_proc,3);
1816:

Line 1815: hr_utility.set_location(l_proc,3);

1811:
1812: hr_utility.set_location(l_proc,2);
1813:
1814: If l_session.noa_id_correct is not null then
1815: hr_utility.set_location(l_proc,3);
1816:
1817: -- History package call fetch_element_entry_value picks new element name
1818: -- again in its call so sending old element name.
1819: ghr_history_fetch.fetch_element_entry_value

Line 1827: hr_utility.set_location(l_proc,4);

1823: p_date_effective => p_effective_date,
1824: p_screen_entry_value => p_value
1825: );
1826: Else
1827: hr_utility.set_location(l_proc,4);
1828: -- sending new element name for cursors to get proper element_type_id's,
1829: -- Processing_types, element_entry_id's
1830: for c_ele_processing_type_rec in
1831: c_ele_processing_type (l_new_element_name

Line 1839: hr_utility.set_message(8301, 'GHR_38034_API_EL_TYPE_NOT_EXST');

1835: l_processing_type := c_ele_processing_type_rec.processing_type;
1836: exit;
1837: end loop;
1838: if not l_ele_proc_type_found then
1839: hr_utility.set_message(8301, 'GHR_38034_API_EL_TYPE_NOT_EXST');
1840: hr_utility.raise_error;
1841: end if;
1842: hr_utility.set_location(l_proc, 5);
1843: --

Line 1840: hr_utility.raise_error;

1836: exit;
1837: end loop;
1838: if not l_ele_proc_type_found then
1839: hr_utility.set_message(8301, 'GHR_38034_API_EL_TYPE_NOT_EXST');
1840: hr_utility.raise_error;
1841: end if;
1842: hr_utility.set_location(l_proc, 5);
1843: --
1844: if l_processing_type = 'R' then -- Recurring element

Line 1842: hr_utility.set_location(l_proc, 5);

1838: if not l_ele_proc_type_found then
1839: hr_utility.set_message(8301, 'GHR_38034_API_EL_TYPE_NOT_EXST');
1840: hr_utility.raise_error;
1841: end if;
1842: hr_utility.set_location(l_proc, 5);
1843: --
1844: if l_processing_type = 'R' then -- Recurring element
1845: for c_rec_ele_entry_value_rec in
1846: c_rec_ele_entry_value (l_new_element_name

Line 1862: -- hr_utility.set_message(8301, 'GHR_38036_API_EL_ENT_NOT_EXIST');

1858: p_value := c_rec_ele_entry_value_rec.screen_entry_value;
1859: end if;
1860: end loop;
1861: if not l_rec_ele_ent_val_found then
1862: -- hr_utility.set_message(8301, 'GHR_38036_API_EL_ENT_NOT_EXIST');
1863: -- hr_utility.raise_error;
1864: p_value := NULL;
1865: end if;
1866: elsif l_processing_type = 'N' then -- Nonrecurring element

Line 1863: -- hr_utility.raise_error;

1859: end if;
1860: end loop;
1861: if not l_rec_ele_ent_val_found then
1862: -- hr_utility.set_message(8301, 'GHR_38036_API_EL_ENT_NOT_EXIST');
1863: -- hr_utility.raise_error;
1864: p_value := NULL;
1865: end if;
1866: elsif l_processing_type = 'N' then -- Nonrecurring element
1867: for c_nonrec_ele_entry_value_rec in

Line 1884: -- hr_utility.set_message(8301, 'GHR_38036_API_EL_ENT_NOT_EXIST');

1880: p_value := c_nonrec_ele_entry_value_rec.screen_entry_value;
1881: end if;
1882: end loop;
1883: if not l_nonrec_ele_ent_val_found then
1884: -- hr_utility.set_message(8301, 'GHR_38036_API_EL_ENT_NOT_EXIST');
1885: -- hr_utility.raise_error;
1886: p_value := NULL;
1887: end if;
1888: hr_utility.set_location(l_proc, 6);

Line 1885: -- hr_utility.raise_error;

1881: end if;
1882: end loop;
1883: if not l_nonrec_ele_ent_val_found then
1884: -- hr_utility.set_message(8301, 'GHR_38036_API_EL_ENT_NOT_EXIST');
1885: -- hr_utility.raise_error;
1886: p_value := NULL;
1887: end if;
1888: hr_utility.set_location(l_proc, 6);
1889: else -- Neither recurring nor nonrecurring element

Line 1888: hr_utility.set_location(l_proc, 6);

1884: -- hr_utility.set_message(8301, 'GHR_38036_API_EL_ENT_NOT_EXIST');
1885: -- hr_utility.raise_error;
1886: p_value := NULL;
1887: end if;
1888: hr_utility.set_location(l_proc, 6);
1889: else -- Neither recurring nor nonrecurring element
1890: hr_utility.set_message(8301, 'GHR_38035_API_INV_PROC_TYPE');
1891: hr_utility.raise_error;
1892: end if;

Line 1890: hr_utility.set_message(8301, 'GHR_38035_API_INV_PROC_TYPE');

1886: p_value := NULL;
1887: end if;
1888: hr_utility.set_location(l_proc, 6);
1889: else -- Neither recurring nor nonrecurring element
1890: hr_utility.set_message(8301, 'GHR_38035_API_INV_PROC_TYPE');
1891: hr_utility.raise_error;
1892: end if;
1893: hr_utility.set_location(l_proc, 7);
1894: --

Line 1891: hr_utility.raise_error;

1887: end if;
1888: hr_utility.set_location(l_proc, 6);
1889: else -- Neither recurring nor nonrecurring element
1890: hr_utility.set_message(8301, 'GHR_38035_API_INV_PROC_TYPE');
1891: hr_utility.raise_error;
1892: end if;
1893: hr_utility.set_location(l_proc, 7);
1894: --
1895: hr_utility.set_location(' Leaving:'||l_proc, 8);

Line 1893: hr_utility.set_location(l_proc, 7);

1889: else -- Neither recurring nor nonrecurring element
1890: hr_utility.set_message(8301, 'GHR_38035_API_INV_PROC_TYPE');
1891: hr_utility.raise_error;
1892: end if;
1893: hr_utility.set_location(l_proc, 7);
1894: --
1895: hr_utility.set_location(' Leaving:'||l_proc, 8);
1896: --
1897: End If;

Line 1895: hr_utility.set_location(' Leaving:'||l_proc, 8);

1891: hr_utility.raise_error;
1892: end if;
1893: hr_utility.set_location(l_proc, 7);
1894: --
1895: hr_utility.set_location(' Leaving:'||l_proc, 8);
1896: --
1897: End If;
1898: exception
1899: when others then

Line 1908: hr_utility.set_message(800, 'HR_7465_PLK_NOT_ELGBLE_ELE_NME');

1904: 'Health Benefits') then
1905: p_value := null;
1906: p_multiple_error_flag := null;
1907: else
1908: hr_utility.set_message(800, 'HR_7465_PLK_NOT_ELGBLE_ELE_NME');
1909: hr_utility.set_message_token('ELEMENT_NAME', p_element_name);
1910: hr_utility.raise_error;
1911:
1912: end if;

Line 1909: hr_utility.set_message_token('ELEMENT_NAME', p_element_name);

1905: p_value := null;
1906: p_multiple_error_flag := null;
1907: else
1908: hr_utility.set_message(800, 'HR_7465_PLK_NOT_ELGBLE_ELE_NME');
1909: hr_utility.set_message_token('ELEMENT_NAME', p_element_name);
1910: hr_utility.raise_error;
1911:
1912: end if;
1913: hr_utility.set_location(' Leaving:'||l_proc, 8);

Line 1910: hr_utility.raise_error;

1906: p_multiple_error_flag := null;
1907: else
1908: hr_utility.set_message(800, 'HR_7465_PLK_NOT_ELGBLE_ELE_NME');
1909: hr_utility.set_message_token('ELEMENT_NAME', p_element_name);
1910: hr_utility.raise_error;
1911:
1912: end if;
1913: hr_utility.set_location(' Leaving:'||l_proc, 8);
1914:

Line 1913: hr_utility.set_location(' Leaving:'||l_proc, 8);

1909: hr_utility.set_message_token('ELEMENT_NAME', p_element_name);
1910: hr_utility.raise_error;
1911:
1912: end if;
1913: hr_utility.set_location(' Leaving:'||l_proc, 8);
1914:
1915: end retrieve_element_entry_value;
1916: --
1917: -- ---------------------------------------------------------------------------

Line 1937: -- hr_utility.set_location('Entering:'||l_proc, 1);

1933: l_asg_pos_by_per_id_found boolean := FALSE;
1934: l_asg_pos_by_asg_id_found boolean := FALSE;
1935: --
1936: begin
1937: -- hr_utility.set_location('Entering:'||l_proc, 1);
1938: --
1939: if p_effective_date is NULL then
1940: l_effective_date := sysdate;
1941: else

Line 1950: -- hr_utility.set_message(8301, 'GHR_38038_API_INV_BG');

1946: ,p_assignment_id => p_assignment_id
1947: ,p_effective_date => l_effective_date
1948: ,p_business_group_id => l_business_group_id);
1949: if l_business_group_id is NULL then
1950: -- hr_utility.set_message(8301, 'GHR_38038_API_INV_BG');
1951: -- hr_utility.raise_error;
1952: null;
1953: end if;
1954: -- hr_utility.set_location(l_proc, 2);

Line 1951: -- hr_utility.raise_error;

1947: ,p_effective_date => l_effective_date
1948: ,p_business_group_id => l_business_group_id);
1949: if l_business_group_id is NULL then
1950: -- hr_utility.set_message(8301, 'GHR_38038_API_INV_BG');
1951: -- hr_utility.raise_error;
1952: null;
1953: end if;
1954: -- hr_utility.set_location(l_proc, 2);
1955: --

Line 1954: -- hr_utility.set_location(l_proc, 2);

1950: -- hr_utility.set_message(8301, 'GHR_38038_API_INV_BG');
1951: -- hr_utility.raise_error;
1952: null;
1953: end if;
1954: -- hr_utility.set_location(l_proc, 2);
1955: --
1956: retrieve_gov_kff_setup_info (p_business_group_id => l_business_group_id
1957: ,p_org_info_rec => l_segment_rec);
1958: if l_segment_rec.information2 is NULL then

Line 1959: -- hr_utility.set_message(8301, 'GHR_38022_API_GHR_ORG_INFO_ERR');

1955: --
1956: retrieve_gov_kff_setup_info (p_business_group_id => l_business_group_id
1957: ,p_org_info_rec => l_segment_rec);
1958: if l_segment_rec.information2 is NULL then
1959: -- hr_utility.set_message(8301, 'GHR_38022_API_GHR_ORG_INFO_ERR');
1960: -- hr_utility.raise_error;
1961: null;
1962: end if;
1963: -- hr_utility.set_location(l_proc, 3);

Line 1960: -- hr_utility.raise_error;

1956: retrieve_gov_kff_setup_info (p_business_group_id => l_business_group_id
1957: ,p_org_info_rec => l_segment_rec);
1958: if l_segment_rec.information2 is NULL then
1959: -- hr_utility.set_message(8301, 'GHR_38022_API_GHR_ORG_INFO_ERR');
1960: -- hr_utility.raise_error;
1961: null;
1962: end if;
1963: -- hr_utility.set_location(l_proc, 3);
1964: --

Line 1963: -- hr_utility.set_location(l_proc, 3);

1959: -- hr_utility.set_message(8301, 'GHR_38022_API_GHR_ORG_INFO_ERR');
1960: -- hr_utility.raise_error;
1961: null;
1962: end if;
1963: -- hr_utility.set_location(l_proc, 3);
1964: --
1965: IF p_person_id is NULL and p_assignment_id is NULL THEN
1966: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');
1967: -- hr_utility.raise_error;

Line 1966: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');

1962: end if;
1963: -- hr_utility.set_location(l_proc, 3);
1964: --
1965: IF p_person_id is NULL and p_assignment_id is NULL THEN
1966: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');
1967: -- hr_utility.raise_error;
1968: null;
1969: ELSIF p_assignment_id IS NULL THEN
1970: FOR c_asg_pos_by_per_id_rec IN c_asg_pos_by_per_id (p_person_id, l_effective_date) loop

Line 1967: -- hr_utility.raise_error;

1963: -- hr_utility.set_location(l_proc, 3);
1964: --
1965: IF p_person_id is NULL and p_assignment_id is NULL THEN
1966: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');
1967: -- hr_utility.raise_error;
1968: null;
1969: ELSIF p_assignment_id IS NULL THEN
1970: FOR c_asg_pos_by_per_id_rec IN c_asg_pos_by_per_id (p_person_id, l_effective_date) loop
1971: l_asg_pos_by_per_id_found := TRUE;

Line 1976: -- hr_utility.set_message(8301, 'GHR_38023_API_INV_ASG');

1972: l_position_id := c_asg_pos_by_per_id_rec.position_id;
1973: EXIT;
1974: END LOOP;
1975: IF NOT l_asg_pos_by_per_id_found THEN
1976: -- hr_utility.set_message(8301, 'GHR_38023_API_INV_ASG');
1977: -- hr_utility.raise_error;
1978: null;
1979: END IF;
1980: else -- p_assignment_id is not NULL

Line 1977: -- hr_utility.raise_error;

1973: EXIT;
1974: END LOOP;
1975: IF NOT l_asg_pos_by_per_id_found THEN
1976: -- hr_utility.set_message(8301, 'GHR_38023_API_INV_ASG');
1977: -- hr_utility.raise_error;
1978: null;
1979: END IF;
1980: else -- p_assignment_id is not NULL
1981: for c_asg_pos_by_asg_id_rec

Line 1988: -- hr_utility.set_message(8301, 'GHR_38023_API_INV_ASG');

1984: l_position_id := c_asg_pos_by_asg_id_rec.position_id;
1985: exit;
1986: end loop;
1987: if not l_asg_pos_by_asg_id_found then
1988: -- hr_utility.set_message(8301, 'GHR_38023_API_INV_ASG');
1989: -- hr_utility.raise_error;
1990: null;
1991: end if;
1992: end if;

Line 1989: -- hr_utility.raise_error;

1985: exit;
1986: end loop;
1987: if not l_asg_pos_by_asg_id_found then
1988: -- hr_utility.set_message(8301, 'GHR_38023_API_INV_ASG');
1989: -- hr_utility.raise_error;
1990: null;
1991: end if;
1992: end if;
1993: -- hr_utility.set_location(l_proc, 4);

Line 1993: -- hr_utility.set_location(l_proc, 4);

1989: -- hr_utility.raise_error;
1990: null;
1991: end if;
1992: end if;
1993: -- hr_utility.set_location(l_proc, 4);
1994: --
1995: retrieve_segment_information (p_information => l_segment_rec.information2
1996: ,p_id => l_position_id
1997: ,p_code => 'POS'

Line 2001: -- hr_utility.set_location(' Leaving:'||l_proc, 5);

1997: ,p_code => 'POS'
1998: ,p_segment => l_segment
1999: ,p_effective_date => p_effective_date);
2000: --
2001: -- hr_utility.set_location(' Leaving:'||l_proc, 5);
2002: return l_segment;
2003: --
2004: end get_position_title;
2005: --

Line 2021: -- hr_utility.set_location('Entering:'||l_proc, 1);

2017: l_segment_rec org_info_rec_type;
2018: l_segment per_position_definitions.segment1%type;
2019: --
2020: begin
2021: -- hr_utility.set_location('Entering:'||l_proc, 1);
2022: --
2023: if p_position_id IS NULL OR p_business_group_id IS NULL then
2024: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');
2025: -- hr_utility.raise_error;

Line 2024: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');

2020: begin
2021: -- hr_utility.set_location('Entering:'||l_proc, 1);
2022: --
2023: if p_position_id IS NULL OR p_business_group_id IS NULL then
2024: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');
2025: -- hr_utility.raise_error;
2026: null;
2027: end if;
2028: --

Line 2025: -- hr_utility.raise_error;

2021: -- hr_utility.set_location('Entering:'||l_proc, 1);
2022: --
2023: if p_position_id IS NULL OR p_business_group_id IS NULL then
2024: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');
2025: -- hr_utility.raise_error;
2026: null;
2027: end if;
2028: --
2029: -- hr_utility.set_location(l_proc, 2);

Line 2029: -- hr_utility.set_location(l_proc, 2);

2025: -- hr_utility.raise_error;
2026: null;
2027: end if;
2028: --
2029: -- hr_utility.set_location(l_proc, 2);
2030: --
2031: retrieve_gov_kff_setup_info (p_business_group_id => p_business_group_id
2032: ,p_org_info_rec => l_segment_rec);
2033: --

Line 2035: -- hr_utility.set_message(8301, 'GHR_38022_API_GHR_ORG_INFO_ERR');

2031: retrieve_gov_kff_setup_info (p_business_group_id => p_business_group_id
2032: ,p_org_info_rec => l_segment_rec);
2033: --
2034: if l_segment_rec.information2 is NULL then
2035: -- hr_utility.set_message(8301, 'GHR_38022_API_GHR_ORG_INFO_ERR');
2036: -- hr_utility.raise_error;
2037: null;
2038: end if;
2039: -- hr_utility.set_location(l_proc, 3);

Line 2036: -- hr_utility.raise_error;

2032: ,p_org_info_rec => l_segment_rec);
2033: --
2034: if l_segment_rec.information2 is NULL then
2035: -- hr_utility.set_message(8301, 'GHR_38022_API_GHR_ORG_INFO_ERR');
2036: -- hr_utility.raise_error;
2037: null;
2038: end if;
2039: -- hr_utility.set_location(l_proc, 3);
2040: --

Line 2039: -- hr_utility.set_location(l_proc, 3);

2035: -- hr_utility.set_message(8301, 'GHR_38022_API_GHR_ORG_INFO_ERR');
2036: -- hr_utility.raise_error;
2037: null;
2038: end if;
2039: -- hr_utility.set_location(l_proc, 3);
2040: --
2041: retrieve_segment_information (p_information => l_segment_rec.information2
2042: ,p_id => p_position_id
2043: ,p_code => 'POS'

Line 2047: -- hr_utility.set_location(' Leaving:'||l_proc, 5);

2043: ,p_code => 'POS'
2044: ,p_effective_date => p_effective_date
2045: ,p_segment => l_segment);
2046: --
2047: -- hr_utility.set_location(' Leaving:'||l_proc, 5);
2048: return l_segment;
2049: --
2050: end get_position_title_pos;
2051: --

Line 2072: -- hr_utility.set_location('Entering:'||l_proc, 1);

2068: l_asg_pos_by_per_id_found boolean := FALSE;
2069: l_asg_pos_by_asg_id_found boolean := FALSE;
2070: --
2071: begin
2072: -- hr_utility.set_location('Entering:'||l_proc, 1);
2073: --
2074: if p_effective_date is NULL then
2075: l_effective_date := sysdate;
2076: else

Line 2085: -- hr_utility.set_message(8301, 'GHR_38038_API_INV_BG');

2081: ,p_assignment_id => p_assignment_id
2082: ,p_effective_date => l_effective_date
2083: ,p_business_group_id => l_business_group_id);
2084: if l_business_group_id is NULL then
2085: -- hr_utility.set_message(8301, 'GHR_38038_API_INV_BG');
2086: -- hr_utility.raise_error;
2087: null;
2088: end if;
2089: -- hr_utility.set_location(l_proc, 2);

Line 2086: -- hr_utility.raise_error;

2082: ,p_effective_date => l_effective_date
2083: ,p_business_group_id => l_business_group_id);
2084: if l_business_group_id is NULL then
2085: -- hr_utility.set_message(8301, 'GHR_38038_API_INV_BG');
2086: -- hr_utility.raise_error;
2087: null;
2088: end if;
2089: -- hr_utility.set_location(l_proc, 2);
2090: --

Line 2089: -- hr_utility.set_location(l_proc, 2);

2085: -- hr_utility.set_message(8301, 'GHR_38038_API_INV_BG');
2086: -- hr_utility.raise_error;
2087: null;
2088: end if;
2089: -- hr_utility.set_location(l_proc, 2);
2090: --
2091: if p_person_id is NULL and p_assignment_id is NULL then
2092: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');
2093: -- hr_utility.raise_error;

Line 2092: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');

2088: end if;
2089: -- hr_utility.set_location(l_proc, 2);
2090: --
2091: if p_person_id is NULL and p_assignment_id is NULL then
2092: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');
2093: -- hr_utility.raise_error;
2094: null;
2095: elsif p_assignment_id is NULL then
2096: for c_asg_pos_by_per_id_rec

Line 2093: -- hr_utility.raise_error;

2089: -- hr_utility.set_location(l_proc, 2);
2090: --
2091: if p_person_id is NULL and p_assignment_id is NULL then
2092: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');
2093: -- hr_utility.raise_error;
2094: null;
2095: elsif p_assignment_id is NULL then
2096: for c_asg_pos_by_per_id_rec
2097: in c_asg_pos_by_per_id (p_person_id, l_effective_date) loop

Line 2103: -- hr_utility.set_message(8301, 'GHR_38023_API_INV_ASG');

2099: l_position_id := c_asg_pos_by_per_id_rec.position_id;
2100: exit;
2101: end loop;
2102: if not l_asg_pos_by_per_id_found then
2103: -- hr_utility.set_message(8301, 'GHR_38023_API_INV_ASG');
2104: -- hr_utility.raise_error;
2105: null;
2106: end if;
2107: else -- p_assignment_id is not NULL

Line 2104: -- hr_utility.raise_error;

2100: exit;
2101: end loop;
2102: if not l_asg_pos_by_per_id_found then
2103: -- hr_utility.set_message(8301, 'GHR_38023_API_INV_ASG');
2104: -- hr_utility.raise_error;
2105: null;
2106: end if;
2107: else -- p_assignment_id is not NULL
2108: for c_asg_pos_by_asg_id_rec

Line 2115: -- hr_utility.set_message(8301, 'GHR_38023_API_INV_ASG');

2111: l_position_id := c_asg_pos_by_asg_id_rec.position_id;
2112: exit;
2113: end loop;
2114: if not l_asg_pos_by_asg_id_found then
2115: -- hr_utility.set_message(8301, 'GHR_38023_API_INV_ASG');
2116: -- hr_utility.raise_error;
2117: null;
2118: end if;
2119: end if;

Line 2116: -- hr_utility.raise_error;

2112: exit;
2113: end loop;
2114: if not l_asg_pos_by_asg_id_found then
2115: -- hr_utility.set_message(8301, 'GHR_38023_API_INV_ASG');
2116: -- hr_utility.raise_error;
2117: null;
2118: end if;
2119: end if;
2120: -- hr_utility.set_location(l_proc, 3);

Line 2120: -- hr_utility.set_location(l_proc, 3);

2116: -- hr_utility.raise_error;
2117: null;
2118: end if;
2119: end if;
2120: -- hr_utility.set_location(l_proc, 3);
2121: --
2122: retrieve_gov_kff_setup_info (p_business_group_id => l_business_group_id
2123: ,p_org_info_rec => l_segment_rec);
2124: if l_segment_rec.information3 is NULL then

Line 2125: -- hr_utility.set_message(8301, 'GHR_38022_API_GHR_ORG_INFO_ERR');

2121: --
2122: retrieve_gov_kff_setup_info (p_business_group_id => l_business_group_id
2123: ,p_org_info_rec => l_segment_rec);
2124: if l_segment_rec.information3 is NULL then
2125: -- hr_utility.set_message(8301, 'GHR_38022_API_GHR_ORG_INFO_ERR');
2126: -- hr_utility.raise_error;
2127: null;
2128: end if;
2129: -- hr_utility.set_location(l_proc, 4);

Line 2126: -- hr_utility.raise_error;

2122: retrieve_gov_kff_setup_info (p_business_group_id => l_business_group_id
2123: ,p_org_info_rec => l_segment_rec);
2124: if l_segment_rec.information3 is NULL then
2125: -- hr_utility.set_message(8301, 'GHR_38022_API_GHR_ORG_INFO_ERR');
2126: -- hr_utility.raise_error;
2127: null;
2128: end if;
2129: -- hr_utility.set_location(l_proc, 4);
2130: --

Line 2129: -- hr_utility.set_location(l_proc, 4);

2125: -- hr_utility.set_message(8301, 'GHR_38022_API_GHR_ORG_INFO_ERR');
2126: -- hr_utility.raise_error;
2127: null;
2128: end if;
2129: -- hr_utility.set_location(l_proc, 4);
2130: --
2131: retrieve_segment_information (p_information => l_segment_rec.information3
2132: ,p_id => l_position_id
2133: ,p_code => 'POS'

Line 2137: -- hr_utility.set_location(' Leaving:'||l_proc, 5);

2133: ,p_code => 'POS'
2134: ,p_segment => l_segment
2135: ,p_effective_date => p_effective_date);
2136: --
2137: -- hr_utility.set_location(' Leaving:'||l_proc, 5);
2138: --
2139: return l_segment;
2140: --
2141: end get_position_description_no;

Line 2158: -- hr_utility.set_location('Entering:'||l_proc, 1);

2154: l_segment_rec org_info_rec_type;
2155: l_segment per_position_definitions.segment1%type;
2156: --
2157: begin
2158: -- hr_utility.set_location('Entering:'||l_proc, 1);
2159: --
2160: if p_position_id IS NULL OR p_business_group_id IS NULL then
2161: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');
2162: -- hr_utility.raise_error;

Line 2161: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');

2157: begin
2158: -- hr_utility.set_location('Entering:'||l_proc, 1);
2159: --
2160: if p_position_id IS NULL OR p_business_group_id IS NULL then
2161: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');
2162: -- hr_utility.raise_error;
2163: null;
2164: end if;
2165: --

Line 2162: -- hr_utility.raise_error;

2158: -- hr_utility.set_location('Entering:'||l_proc, 1);
2159: --
2160: if p_position_id IS NULL OR p_business_group_id IS NULL then
2161: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');
2162: -- hr_utility.raise_error;
2163: null;
2164: end if;
2165: --
2166: -- hr_utility.set_location(l_proc, 2);

Line 2166: -- hr_utility.set_location(l_proc, 2);

2162: -- hr_utility.raise_error;
2163: null;
2164: end if;
2165: --
2166: -- hr_utility.set_location(l_proc, 2);
2167: --
2168: retrieve_gov_kff_setup_info (p_business_group_id => p_business_group_id
2169: ,p_org_info_rec => l_segment_rec);
2170: --

Line 2172: -- hr_utility.set_message(8301, 'GHR_38022_API_GHR_ORG_INFO_ERR');

2168: retrieve_gov_kff_setup_info (p_business_group_id => p_business_group_id
2169: ,p_org_info_rec => l_segment_rec);
2170: --
2171: if l_segment_rec.information3 is NULL then
2172: -- hr_utility.set_message(8301, 'GHR_38022_API_GHR_ORG_INFO_ERR');
2173: -- hr_utility.raise_error;
2174: null;
2175: end if;
2176: -- hr_utility.set_location(l_proc, 3);

Line 2173: -- hr_utility.raise_error;

2169: ,p_org_info_rec => l_segment_rec);
2170: --
2171: if l_segment_rec.information3 is NULL then
2172: -- hr_utility.set_message(8301, 'GHR_38022_API_GHR_ORG_INFO_ERR');
2173: -- hr_utility.raise_error;
2174: null;
2175: end if;
2176: -- hr_utility.set_location(l_proc, 3);
2177: --

Line 2176: -- hr_utility.set_location(l_proc, 3);

2172: -- hr_utility.set_message(8301, 'GHR_38022_API_GHR_ORG_INFO_ERR');
2173: -- hr_utility.raise_error;
2174: null;
2175: end if;
2176: -- hr_utility.set_location(l_proc, 3);
2177: --
2178: retrieve_segment_information (p_information => l_segment_rec.information3
2179: ,p_id => p_position_id
2180: ,p_code => 'POS'

Line 2184: -- hr_utility.set_location(' Leaving:'||l_proc, 5);

2180: ,p_code => 'POS'
2181: ,p_segment => l_segment
2182: ,p_effective_date => p_effective_date);
2183: --
2184: -- hr_utility.set_location(' Leaving:'||l_proc, 5);
2185: return l_segment;
2186: --
2187: end get_position_desc_no_pos;
2188: --

Line 2209: -- hr_utility.set_location('Entering:'||l_proc, 1);

2205: l_asg_pos_by_per_id_found boolean := FALSE;
2206: l_asg_pos_by_asg_id_found boolean := FALSE;
2207: --
2208: begin
2209: -- hr_utility.set_location('Entering:'||l_proc, 1);
2210: --
2211: if p_effective_date is NULL then
2212: l_effective_date := sysdate;
2213: else

Line 2222: -- hr_utility.set_message(8301, 'GHR_38038_API_INV_BG');

2218: ,p_assignment_id => p_assignment_id
2219: ,p_effective_date => l_effective_date
2220: ,p_business_group_id => l_business_group_id);
2221: if l_business_group_id is NULL then
2222: -- hr_utility.set_message(8301, 'GHR_38038_API_INV_BG');
2223: -- hr_utility.raise_error;
2224: null;
2225: end if;
2226: -- hr_utility.set_location(l_proc, 2);

Line 2223: -- hr_utility.raise_error;

2219: ,p_effective_date => l_effective_date
2220: ,p_business_group_id => l_business_group_id);
2221: if l_business_group_id is NULL then
2222: -- hr_utility.set_message(8301, 'GHR_38038_API_INV_BG');
2223: -- hr_utility.raise_error;
2224: null;
2225: end if;
2226: -- hr_utility.set_location(l_proc, 2);
2227: --

Line 2226: -- hr_utility.set_location(l_proc, 2);

2222: -- hr_utility.set_message(8301, 'GHR_38038_API_INV_BG');
2223: -- hr_utility.raise_error;
2224: null;
2225: end if;
2226: -- hr_utility.set_location(l_proc, 2);
2227: --
2228: if p_person_id is NULL and p_assignment_id is NULL then
2229: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');
2230: -- hr_utility.raise_error;

Line 2229: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');

2225: end if;
2226: -- hr_utility.set_location(l_proc, 2);
2227: --
2228: if p_person_id is NULL and p_assignment_id is NULL then
2229: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');
2230: -- hr_utility.raise_error;
2231: null;
2232: elsif p_assignment_id is NULL then
2233: for c_asg_pos_by_per_id_rec

Line 2230: -- hr_utility.raise_error;

2226: -- hr_utility.set_location(l_proc, 2);
2227: --
2228: if p_person_id is NULL and p_assignment_id is NULL then
2229: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');
2230: -- hr_utility.raise_error;
2231: null;
2232: elsif p_assignment_id is NULL then
2233: for c_asg_pos_by_per_id_rec
2234: in c_asg_pos_by_per_id (p_person_id, l_effective_date) loop

Line 2240: -- hr_utility.set_message(8301, 'GHR_38023_API_INV_ASG');

2236: l_position_id := c_asg_pos_by_per_id_rec.position_id;
2237: exit;
2238: end loop;
2239: if not l_asg_pos_by_per_id_found then
2240: -- hr_utility.set_message(8301, 'GHR_38023_API_INV_ASG');
2241: -- hr_utility.raise_error;
2242: null;
2243: end if;
2244: else -- p_assignment_id is not NULL

Line 2241: -- hr_utility.raise_error;

2237: exit;
2238: end loop;
2239: if not l_asg_pos_by_per_id_found then
2240: -- hr_utility.set_message(8301, 'GHR_38023_API_INV_ASG');
2241: -- hr_utility.raise_error;
2242: null;
2243: end if;
2244: else -- p_assignment_id is not NULL
2245: for c_asg_pos_by_asg_id_rec

Line 2252: -- hr_utility.set_message(8301, 'GHR_38023_API_INV_ASG');

2248: l_position_id := c_asg_pos_by_asg_id_rec.position_id;
2249: exit;
2250: end loop;
2251: if not l_asg_pos_by_asg_id_found then
2252: -- hr_utility.set_message(8301, 'GHR_38023_API_INV_ASG');
2253: -- hr_utility.raise_error;
2254: null;
2255: end if;
2256: end if;

Line 2253: -- hr_utility.raise_error;

2249: exit;
2250: end loop;
2251: if not l_asg_pos_by_asg_id_found then
2252: -- hr_utility.set_message(8301, 'GHR_38023_API_INV_ASG');
2253: -- hr_utility.raise_error;
2254: null;
2255: end if;
2256: end if;
2257: -- hr_utility.set_location(l_proc, 3);

Line 2257: -- hr_utility.set_location(l_proc, 3);

2253: -- hr_utility.raise_error;
2254: null;
2255: end if;
2256: end if;
2257: -- hr_utility.set_location(l_proc, 3);
2258: --
2259: retrieve_gov_kff_setup_info (p_business_group_id => l_business_group_id
2260: ,p_org_info_rec => l_segment_rec);
2261: if l_segment_rec.information4 is NULL then

Line 2262: -- hr_utility.set_message(8301, 'GHR_38022_API_GHR_ORG_INFO_ERR');

2258: --
2259: retrieve_gov_kff_setup_info (p_business_group_id => l_business_group_id
2260: ,p_org_info_rec => l_segment_rec);
2261: if l_segment_rec.information4 is NULL then
2262: -- hr_utility.set_message(8301, 'GHR_38022_API_GHR_ORG_INFO_ERR');
2263: -- hr_utility.raise_error;
2264: null;
2265: end if;
2266: -- hr_utility.set_location(l_proc, 4);

Line 2263: -- hr_utility.raise_error;

2259: retrieve_gov_kff_setup_info (p_business_group_id => l_business_group_id
2260: ,p_org_info_rec => l_segment_rec);
2261: if l_segment_rec.information4 is NULL then
2262: -- hr_utility.set_message(8301, 'GHR_38022_API_GHR_ORG_INFO_ERR');
2263: -- hr_utility.raise_error;
2264: null;
2265: end if;
2266: -- hr_utility.set_location(l_proc, 4);
2267: --

Line 2266: -- hr_utility.set_location(l_proc, 4);

2262: -- hr_utility.set_message(8301, 'GHR_38022_API_GHR_ORG_INFO_ERR');
2263: -- hr_utility.raise_error;
2264: null;
2265: end if;
2266: -- hr_utility.set_location(l_proc, 4);
2267: --
2268: retrieve_segment_information (p_information => l_segment_rec.information4
2269: ,p_id => l_position_id
2270: ,p_code => 'POS'

Line 2274: -- hr_utility.set_location(' Leaving:'||l_proc, 5);

2270: ,p_code => 'POS'
2271: ,p_effective_date => p_effective_date
2272: ,p_segment => l_segment);
2273: --
2274: -- hr_utility.set_location(' Leaving:'||l_proc, 5);
2275: --
2276: return l_segment;
2277: --
2278: end get_position_sequence_no;

Line 2295: -- hr_utility.set_location('Entering:'||l_proc, 1);

2291: l_segment_rec org_info_rec_type;
2292: l_segment per_position_definitions.segment1%type;
2293: --
2294: begin
2295: -- hr_utility.set_location('Entering:'||l_proc, 1);
2296: --
2297: if p_position_id IS NULL OR p_business_group_id IS NULL then
2298: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');
2299: -- hr_utility.raise_error;

Line 2298: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');

2294: begin
2295: -- hr_utility.set_location('Entering:'||l_proc, 1);
2296: --
2297: if p_position_id IS NULL OR p_business_group_id IS NULL then
2298: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');
2299: -- hr_utility.raise_error;
2300: null;
2301: end if;
2302: --

Line 2299: -- hr_utility.raise_error;

2295: -- hr_utility.set_location('Entering:'||l_proc, 1);
2296: --
2297: if p_position_id IS NULL OR p_business_group_id IS NULL then
2298: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');
2299: -- hr_utility.raise_error;
2300: null;
2301: end if;
2302: --
2303: -- hr_utility.set_location(l_proc, 2);

Line 2303: -- hr_utility.set_location(l_proc, 2);

2299: -- hr_utility.raise_error;
2300: null;
2301: end if;
2302: --
2303: -- hr_utility.set_location(l_proc, 2);
2304: --
2305: retrieve_gov_kff_setup_info (p_business_group_id => p_business_group_id
2306: ,p_org_info_rec => l_segment_rec);
2307: --

Line 2309: -- hr_utility.set_message(8301, 'GHR_38022_API_GHR_ORG_INFO_ERR');

2305: retrieve_gov_kff_setup_info (p_business_group_id => p_business_group_id
2306: ,p_org_info_rec => l_segment_rec);
2307: --
2308: if l_segment_rec.information4 is NULL then
2309: -- hr_utility.set_message(8301, 'GHR_38022_API_GHR_ORG_INFO_ERR');
2310: -- hr_utility.raise_error;
2311: null;
2312: end if;
2313: -- hr_utility.set_location(l_proc, 3);

Line 2310: -- hr_utility.raise_error;

2306: ,p_org_info_rec => l_segment_rec);
2307: --
2308: if l_segment_rec.information4 is NULL then
2309: -- hr_utility.set_message(8301, 'GHR_38022_API_GHR_ORG_INFO_ERR');
2310: -- hr_utility.raise_error;
2311: null;
2312: end if;
2313: -- hr_utility.set_location(l_proc, 3);
2314: --

Line 2313: -- hr_utility.set_location(l_proc, 3);

2309: -- hr_utility.set_message(8301, 'GHR_38022_API_GHR_ORG_INFO_ERR');
2310: -- hr_utility.raise_error;
2311: null;
2312: end if;
2313: -- hr_utility.set_location(l_proc, 3);
2314: --
2315: retrieve_segment_information (p_information => l_segment_rec.information4
2316: ,p_id => p_position_id
2317: ,p_code => 'POS'

Line 2321: -- hr_utility.set_location(' Leaving:'||l_proc, 5);

2317: ,p_code => 'POS'
2318: ,p_effective_date => p_effective_date
2319: ,p_segment => l_segment);
2320: --
2321: -- hr_utility.set_location(' Leaving:'||l_proc, 5);
2322: return l_segment;
2323: --
2324: end get_position_sequence_no_pos;
2325: --

Line 2346: -- hr_utility.set_location('Entering:'||l_proc, 1);

2342: l_asg_pos_by_per_id_found boolean := FALSE;
2343: l_asg_pos_by_asg_id_found boolean := FALSE;
2344: --
2345: begin
2346: -- hr_utility.set_location('Entering:'||l_proc, 1);
2347: --
2348: if p_effective_date is NULL then
2349: l_effective_date := sysdate;
2350: else

Line 2359: -- hr_utility.set_message(8301, 'GHR_38038_API_INV_BG');

2355: ,p_assignment_id => p_assignment_id
2356: ,p_effective_date => l_effective_date
2357: ,p_business_group_id => l_business_group_id);
2358: if l_business_group_id is NULL then
2359: -- hr_utility.set_message(8301, 'GHR_38038_API_INV_BG');
2360: -- hr_utility.raise_error;
2361: null;
2362: end if;
2363: -- hr_utility.set_location(l_proc, 2);

Line 2360: -- hr_utility.raise_error;

2356: ,p_effective_date => l_effective_date
2357: ,p_business_group_id => l_business_group_id);
2358: if l_business_group_id is NULL then
2359: -- hr_utility.set_message(8301, 'GHR_38038_API_INV_BG');
2360: -- hr_utility.raise_error;
2361: null;
2362: end if;
2363: -- hr_utility.set_location(l_proc, 2);
2364: --

Line 2363: -- hr_utility.set_location(l_proc, 2);

2359: -- hr_utility.set_message(8301, 'GHR_38038_API_INV_BG');
2360: -- hr_utility.raise_error;
2361: null;
2362: end if;
2363: -- hr_utility.set_location(l_proc, 2);
2364: --
2365: if p_person_id is NULL and p_assignment_id is NULL then
2366: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');
2367: -- hr_utility.raise_error;

Line 2366: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');

2362: end if;
2363: -- hr_utility.set_location(l_proc, 2);
2364: --
2365: if p_person_id is NULL and p_assignment_id is NULL then
2366: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');
2367: -- hr_utility.raise_error;
2368: null;
2369: elsif p_assignment_id is NULL then
2370: for c_asg_pos_by_per_id_rec

Line 2367: -- hr_utility.raise_error;

2363: -- hr_utility.set_location(l_proc, 2);
2364: --
2365: if p_person_id is NULL and p_assignment_id is NULL then
2366: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');
2367: -- hr_utility.raise_error;
2368: null;
2369: elsif p_assignment_id is NULL then
2370: for c_asg_pos_by_per_id_rec
2371: in c_asg_pos_by_per_id (p_person_id, l_effective_date) loop

Line 2377: -- hr_utility.set_message(8301, 'GHR_38023_API_INV_ASG');

2373: l_position_id := c_asg_pos_by_per_id_rec.position_id;
2374: exit;
2375: end loop;
2376: if not l_asg_pos_by_per_id_found then
2377: -- hr_utility.set_message(8301, 'GHR_38023_API_INV_ASG');
2378: -- hr_utility.raise_error;
2379: null;
2380: end if;
2381: else -- p_assignment_id is not NULL

Line 2378: -- hr_utility.raise_error;

2374: exit;
2375: end loop;
2376: if not l_asg_pos_by_per_id_found then
2377: -- hr_utility.set_message(8301, 'GHR_38023_API_INV_ASG');
2378: -- hr_utility.raise_error;
2379: null;
2380: end if;
2381: else -- p_assignment_id is not NULL
2382: for c_asg_pos_by_asg_id_rec

Line 2389: -- hr_utility.set_message(8301, 'GHR_38023_API_INV_ASG');

2385: l_position_id := c_asg_pos_by_asg_id_rec.position_id;
2386: exit;
2387: end loop;
2388: if not l_asg_pos_by_asg_id_found then
2389: -- hr_utility.set_message(8301, 'GHR_38023_API_INV_ASG');
2390: -- hr_utility.raise_error;
2391: null;
2392: end if;
2393: end if;

Line 2390: -- hr_utility.raise_error;

2386: exit;
2387: end loop;
2388: if not l_asg_pos_by_asg_id_found then
2389: -- hr_utility.set_message(8301, 'GHR_38023_API_INV_ASG');
2390: -- hr_utility.raise_error;
2391: null;
2392: end if;
2393: end if;
2394: -- hr_utility.set_location(l_proc, 3);

Line 2394: -- hr_utility.set_location(l_proc, 3);

2390: -- hr_utility.raise_error;
2391: null;
2392: end if;
2393: end if;
2394: -- hr_utility.set_location(l_proc, 3);
2395: --
2396: retrieve_gov_kff_setup_info (p_business_group_id => l_business_group_id
2397: ,p_org_info_rec => l_segment_rec);
2398: if l_segment_rec.information5 is NULL then

Line 2399: -- hr_utility.set_message(8301, 'GHR_38022_API_GHR_ORG_INFO_ERR');

2395: --
2396: retrieve_gov_kff_setup_info (p_business_group_id => l_business_group_id
2397: ,p_org_info_rec => l_segment_rec);
2398: if l_segment_rec.information5 is NULL then
2399: -- hr_utility.set_message(8301, 'GHR_38022_API_GHR_ORG_INFO_ERR');
2400: -- hr_utility.raise_error;
2401: null;
2402: end if;
2403: -- hr_utility.set_location(l_proc, 4);

Line 2400: -- hr_utility.raise_error;

2396: retrieve_gov_kff_setup_info (p_business_group_id => l_business_group_id
2397: ,p_org_info_rec => l_segment_rec);
2398: if l_segment_rec.information5 is NULL then
2399: -- hr_utility.set_message(8301, 'GHR_38022_API_GHR_ORG_INFO_ERR');
2400: -- hr_utility.raise_error;
2401: null;
2402: end if;
2403: -- hr_utility.set_location(l_proc, 4);
2404: --

Line 2403: -- hr_utility.set_location(l_proc, 4);

2399: -- hr_utility.set_message(8301, 'GHR_38022_API_GHR_ORG_INFO_ERR');
2400: -- hr_utility.raise_error;
2401: null;
2402: end if;
2403: -- hr_utility.set_location(l_proc, 4);
2404: --
2405: retrieve_segment_information (p_information => l_segment_rec.information5
2406: ,p_id => l_position_id
2407: ,p_code => 'POS'

Line 2411: -- hr_utility.set_location(' Leaving:'||l_proc, 5);

2407: ,p_code => 'POS'
2408: ,p_effective_date => p_effective_date
2409: ,p_segment => l_segment);
2410: --
2411: -- hr_utility.set_location(' Leaving:'||l_proc, 5);
2412: --
2413: return l_segment;
2414: --
2415: end get_position_agency_code;

Line 2432: -- hr_utility.set_location('Entering:'||l_proc, 1);

2428: l_segment_rec org_info_rec_type;
2429: l_segment per_position_definitions.segment1%type;
2430: --
2431: begin
2432: -- hr_utility.set_location('Entering:'||l_proc, 1);
2433: --
2434: if p_position_id IS NULL OR p_business_group_id IS NULL then
2435: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');
2436: -- hr_utility.raise_error;

Line 2435: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');

2431: begin
2432: -- hr_utility.set_location('Entering:'||l_proc, 1);
2433: --
2434: if p_position_id IS NULL OR p_business_group_id IS NULL then
2435: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');
2436: -- hr_utility.raise_error;
2437: null;
2438: end if;
2439: --

Line 2436: -- hr_utility.raise_error;

2432: -- hr_utility.set_location('Entering:'||l_proc, 1);
2433: --
2434: if p_position_id IS NULL OR p_business_group_id IS NULL then
2435: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');
2436: -- hr_utility.raise_error;
2437: null;
2438: end if;
2439: --
2440: -- hr_utility.set_location(l_proc, 2);

Line 2440: -- hr_utility.set_location(l_proc, 2);

2436: -- hr_utility.raise_error;
2437: null;
2438: end if;
2439: --
2440: -- hr_utility.set_location(l_proc, 2);
2441: --
2442: retrieve_gov_kff_setup_info (p_business_group_id => p_business_group_id
2443: ,p_org_info_rec => l_segment_rec);
2444: --

Line 2446: -- hr_utility.set_message(8301, 'GHR_38022_API_GHR_ORG_INFO_ERR');

2442: retrieve_gov_kff_setup_info (p_business_group_id => p_business_group_id
2443: ,p_org_info_rec => l_segment_rec);
2444: --
2445: if l_segment_rec.information5 is NULL then
2446: -- hr_utility.set_message(8301, 'GHR_38022_API_GHR_ORG_INFO_ERR');
2447: -- hr_utility.raise_error;
2448: null;
2449: end if;
2450: -- hr_utility.set_location(l_proc, 3);

Line 2447: -- hr_utility.raise_error;

2443: ,p_org_info_rec => l_segment_rec);
2444: --
2445: if l_segment_rec.information5 is NULL then
2446: -- hr_utility.set_message(8301, 'GHR_38022_API_GHR_ORG_INFO_ERR');
2447: -- hr_utility.raise_error;
2448: null;
2449: end if;
2450: -- hr_utility.set_location(l_proc, 3);
2451: --

Line 2450: -- hr_utility.set_location(l_proc, 3);

2446: -- hr_utility.set_message(8301, 'GHR_38022_API_GHR_ORG_INFO_ERR');
2447: -- hr_utility.raise_error;
2448: null;
2449: end if;
2450: -- hr_utility.set_location(l_proc, 3);
2451: --
2452: retrieve_segment_information (p_information => l_segment_rec.information5
2453: ,p_id => p_position_id
2454: ,p_code => 'POS'

Line 2458: -- hr_utility.set_location(' Leaving:'||l_proc, 5);

2454: ,p_code => 'POS'
2455: ,p_segment => l_segment
2456: ,p_effective_date => p_effective_date);
2457: --
2458: -- hr_utility.set_location(' Leaving:'||l_proc, 5);
2459: return l_segment;
2460: --
2461: end get_position_agency_code_pos;
2462: --

Line 2483: -- hr_utility.set_location('Entering:'||l_proc, 1);

2479: l_asg_job_by_per_id_found boolean := FALSE;
2480: l_asg_job_by_asg_id_found boolean := FALSE;
2481: --
2482: begin
2483: -- hr_utility.set_location('Entering:'||l_proc, 1);
2484: --
2485: if p_effective_date is NULL then
2486: l_effective_date := sysdate;
2487: else

Line 2496: -- hr_utility.set_message(8301, 'GHR_38038_API_INV_BG');

2492: ,p_assignment_id => p_assignment_id
2493: ,p_effective_date => l_effective_date
2494: ,p_business_group_id => l_business_group_id);
2495: if l_business_group_id is NULL then
2496: -- hr_utility.set_message(8301, 'GHR_38038_API_INV_BG');
2497: -- hr_utility.raise_error;
2498: null;
2499: end if;
2500: -- hr_utility.set_location(l_proc, 2);

Line 2497: -- hr_utility.raise_error;

2493: ,p_effective_date => l_effective_date
2494: ,p_business_group_id => l_business_group_id);
2495: if l_business_group_id is NULL then
2496: -- hr_utility.set_message(8301, 'GHR_38038_API_INV_BG');
2497: -- hr_utility.raise_error;
2498: null;
2499: end if;
2500: -- hr_utility.set_location(l_proc, 2);
2501: --

Line 2500: -- hr_utility.set_location(l_proc, 2);

2496: -- hr_utility.set_message(8301, 'GHR_38038_API_INV_BG');
2497: -- hr_utility.raise_error;
2498: null;
2499: end if;
2500: -- hr_utility.set_location(l_proc, 2);
2501: --
2502: if p_person_id is NULL and p_assignment_id is NULL then
2503: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');
2504: -- hr_utility.raise_error;

Line 2503: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');

2499: end if;
2500: -- hr_utility.set_location(l_proc, 2);
2501: --
2502: if p_person_id is NULL and p_assignment_id is NULL then
2503: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');
2504: -- hr_utility.raise_error;
2505: null;
2506: elsif p_assignment_id is NULL then
2507:

Line 2504: -- hr_utility.raise_error;

2500: -- hr_utility.set_location(l_proc, 2);
2501: --
2502: if p_person_id is NULL and p_assignment_id is NULL then
2503: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');
2504: -- hr_utility.raise_error;
2505: null;
2506: elsif p_assignment_id is NULL then
2507:
2508: for c_asg_job_by_per_id_rec

Line 2515: -- hr_utility.set_message(8301, 'GHR_38023_API_INV_ASG');

2511: l_job_id := c_asg_job_by_per_id_rec.job_id;
2512: exit;
2513: end loop;
2514: if not l_asg_job_by_per_id_found then
2515: -- hr_utility.set_message(8301, 'GHR_38023_API_INV_ASG');
2516: -- hr_utility.raise_error;
2517: null;
2518: end if;
2519: else -- p_assignment_id is not NULL

Line 2516: -- hr_utility.raise_error;

2512: exit;
2513: end loop;
2514: if not l_asg_job_by_per_id_found then
2515: -- hr_utility.set_message(8301, 'GHR_38023_API_INV_ASG');
2516: -- hr_utility.raise_error;
2517: null;
2518: end if;
2519: else -- p_assignment_id is not NULL
2520: for c_asg_job_by_asg_id_rec

Line 2527: -- hr_utility.set_message(8301, 'GHR_38023_API_INV_ASG');

2523: l_job_id := c_asg_job_by_asg_id_rec.job_id;
2524: exit;
2525: end loop;
2526: if not l_asg_job_by_asg_id_found then
2527: -- hr_utility.set_message(8301, 'GHR_38023_API_INV_ASG');
2528: -- hr_utility.raise_error;
2529: null;
2530: end if;
2531: end if;

Line 2528: -- hr_utility.raise_error;

2524: exit;
2525: end loop;
2526: if not l_asg_job_by_asg_id_found then
2527: -- hr_utility.set_message(8301, 'GHR_38023_API_INV_ASG');
2528: -- hr_utility.raise_error;
2529: null;
2530: end if;
2531: end if;
2532: -- hr_utility.set_location(l_proc, 3);

Line 2532: -- hr_utility.set_location(l_proc, 3);

2528: -- hr_utility.raise_error;
2529: null;
2530: end if;
2531: end if;
2532: -- hr_utility.set_location(l_proc, 3);
2533: --
2534: retrieve_gov_kff_setup_info (p_business_group_id => l_business_group_id
2535: ,p_org_info_rec => l_segment_rec);
2536: if l_segment_rec.information1 is NULL then

Line 2537: -- hr_utility.set_message(8301, 'GHR_38022_API_GHR_ORG_INFO_ERR');

2533: --
2534: retrieve_gov_kff_setup_info (p_business_group_id => l_business_group_id
2535: ,p_org_info_rec => l_segment_rec);
2536: if l_segment_rec.information1 is NULL then
2537: -- hr_utility.set_message(8301, 'GHR_38022_API_GHR_ORG_INFO_ERR');
2538: -- hr_utility.raise_error;
2539: null;
2540: end if;
2541: -- hr_utility.set_location(l_proc, 4);

Line 2538: -- hr_utility.raise_error;

2534: retrieve_gov_kff_setup_info (p_business_group_id => l_business_group_id
2535: ,p_org_info_rec => l_segment_rec);
2536: if l_segment_rec.information1 is NULL then
2537: -- hr_utility.set_message(8301, 'GHR_38022_API_GHR_ORG_INFO_ERR');
2538: -- hr_utility.raise_error;
2539: null;
2540: end if;
2541: -- hr_utility.set_location(l_proc, 4);
2542: --

Line 2541: -- hr_utility.set_location(l_proc, 4);

2537: -- hr_utility.set_message(8301, 'GHR_38022_API_GHR_ORG_INFO_ERR');
2538: -- hr_utility.raise_error;
2539: null;
2540: end if;
2541: -- hr_utility.set_location(l_proc, 4);
2542: --
2543: retrieve_segment_information (p_information => l_segment_rec.information1
2544: ,p_id => l_job_id
2545: ,p_code => 'JOB'

Line 2548: -- hr_utility.set_location(' Leaving:'||l_proc, 5);

2544: ,p_id => l_job_id
2545: ,p_code => 'JOB'
2546: ,p_segment => l_segment);
2547: --
2548: -- hr_utility.set_location(' Leaving:'||l_proc, 5);
2549: --
2550: return l_segment;
2551: --
2552: end get_job_occupational_series;

Line 2568: -- hr_utility.set_location('Entering:'||l_proc, 1);

2564: l_segment_rec org_info_rec_type;
2565: l_segment per_position_definitions.segment1%type;
2566: --
2567: begin
2568: -- hr_utility.set_location('Entering:'||l_proc, 1);
2569: --
2570: if p_job_id IS NULL OR p_business_group_id IS NULL then
2571: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');
2572: -- hr_utility.raise_error;

Line 2571: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');

2567: begin
2568: -- hr_utility.set_location('Entering:'||l_proc, 1);
2569: --
2570: if p_job_id IS NULL OR p_business_group_id IS NULL then
2571: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');
2572: -- hr_utility.raise_error;
2573: null;
2574: end if;
2575: --

Line 2572: -- hr_utility.raise_error;

2568: -- hr_utility.set_location('Entering:'||l_proc, 1);
2569: --
2570: if p_job_id IS NULL OR p_business_group_id IS NULL then
2571: -- hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');
2572: -- hr_utility.raise_error;
2573: null;
2574: end if;
2575: --
2576: -- hr_utility.set_location(l_proc, 2);

Line 2576: -- hr_utility.set_location(l_proc, 2);

2572: -- hr_utility.raise_error;
2573: null;
2574: end if;
2575: --
2576: -- hr_utility.set_location(l_proc, 2);
2577: --
2578: retrieve_gov_kff_setup_info (p_business_group_id => p_business_group_id
2579: ,p_org_info_rec => l_segment_rec);
2580: if l_segment_rec.information1 is NULL then

Line 2581: -- hr_utility.set_message(8301, 'GHR_38022_API_GHR_ORG_INFO_ERR');

2577: --
2578: retrieve_gov_kff_setup_info (p_business_group_id => p_business_group_id
2579: ,p_org_info_rec => l_segment_rec);
2580: if l_segment_rec.information1 is NULL then
2581: -- hr_utility.set_message(8301, 'GHR_38022_API_GHR_ORG_INFO_ERR');
2582: -- hr_utility.raise_error;
2583: null;
2584: end if;
2585: -- hr_utility.set_location(l_proc, 3);

Line 2582: -- hr_utility.raise_error;

2578: retrieve_gov_kff_setup_info (p_business_group_id => p_business_group_id
2579: ,p_org_info_rec => l_segment_rec);
2580: if l_segment_rec.information1 is NULL then
2581: -- hr_utility.set_message(8301, 'GHR_38022_API_GHR_ORG_INFO_ERR');
2582: -- hr_utility.raise_error;
2583: null;
2584: end if;
2585: -- hr_utility.set_location(l_proc, 3);
2586: --

Line 2585: -- hr_utility.set_location(l_proc, 3);

2581: -- hr_utility.set_message(8301, 'GHR_38022_API_GHR_ORG_INFO_ERR');
2582: -- hr_utility.raise_error;
2583: null;
2584: end if;
2585: -- hr_utility.set_location(l_proc, 3);
2586: --
2587: retrieve_segment_information (p_information => l_segment_rec.information1
2588: ,p_id => p_job_id
2589: ,p_code => 'JOB'

Line 2593: -- hr_utility.set_location(' Leaving:'||l_proc, 4);

2589: ,p_code => 'JOB'
2590: ,p_segment => l_segment
2591: );
2592: --
2593: -- hr_utility.set_location(' Leaving:'||l_proc, 4);
2594: --
2595: return l_segment;
2596: --
2597: end get_job_occ_series_job;

Line 2867: hr_utility.set_location('Entering:'||l_proc, 1);

2863: where pa_request_id = l_pa_request_id;
2864: --
2865: --
2866: begin
2867: hr_utility.set_location('Entering:'||l_proc, 1);
2868: --
2869: l_effective_date := p_effective_date;
2870: l_assignment_id := p_assignment_id;
2871:

Line 2944: hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');

2940: -- VSM added following if stmt. and the TRUE result code to take care of refresh of correction SF52.
2941: if p_altered_pa_request_id is not NULL and
2942: p_noa_id_corrected is not NULL then
2943: if p_assignment_id is NULL then
2944: hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');
2945: hr_utility.raise_error;
2946: else
2947: ghr_history_fetch.fetch_assignment
2948: ( p_assignment_id => p_assignment_id

Line 2945: hr_utility.raise_error;

2941: if p_altered_pa_request_id is not NULL and
2942: p_noa_id_corrected is not NULL then
2943: if p_assignment_id is NULL then
2944: hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');
2945: hr_utility.raise_error;
2946: else
2947: ghr_history_fetch.fetch_assignment
2948: ( p_assignment_id => p_assignment_id
2949: ,p_date_effective => p_effective_date

Line 2968: hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');

2964: end if;
2965:
2966: else
2967: if p_person_id is NULL and p_assignment_id is NULL then
2968: hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');
2969: hr_utility.raise_error;
2970: elsif p_assignment_id is NULL then
2971: -- If we were not given an assignment id then we need to get the 'default'
2972: -- assignment. The definition of 'default' assignment is not yet clearly

Line 2969: hr_utility.raise_error;

2965:
2966: else
2967: if p_person_id is NULL and p_assignment_id is NULL then
2968: hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');
2969: hr_utility.raise_error;
2970: elsif p_assignment_id is NULL then
2971: -- If we were not given an assignment id then we need to get the 'default'
2972: -- assignment. The definition of 'default' assignment is not yet clearly
2973: -- defined!

Line 2988: hr_utility.set_location('Ex Employee in conversion action',1);

2984: for per_type in c_per_type(p_person_id,l_effective_date) loop
2985: l_person_type := per_type.system_person_type;
2986: end loop;
2987: If l_person_type = 'EX_EMP' then
2988: hr_utility.set_location('Ex Employee in conversion action',1);
2989: for c_assignment_ex_emp_rec in c_assignment_ex_emp loop
2990: l_asg_by_per_id_found := TRUE;
2991: l_effective_date := c_assignment_ex_emp_rec.effective_end_date;
2992: p_assignment_id := c_assignment_ex_emp_rec.assignment_id;

Line 3005: hr_utility.set_location('Ex Employee in conversion action with asg id',1);

3001:
3002: Else
3003: --RP
3004: if l_person_type = 'EX_EMP' then
3005: hr_utility.set_location('Ex Employee in conversion action with asg id',1);
3006: for c_assignment_ex_emp_rec in c_assignment_ex_emp loop
3007: l_asg_by_per_id_found := TRUE;
3008: l_effective_date := c_assignment_ex_emp_rec.effective_end_date;
3009: p_assignment_id := c_assignment_ex_emp_rec.assignment_id;

Line 3051: hr_utility.set_message(8301, 'GHR_38023_API_INV_ASG');

3047: END IF;
3048: End if;
3049: --
3050: IF NOT l_asg_by_per_id_found THEN
3051: hr_utility.set_message(8301, 'GHR_38023_API_INV_ASG');
3052: hr_utility.raise_error;
3053: END IF;
3054: End if;
3055: ELSE -- p_assignment_id is not NULL

Line 3052: hr_utility.raise_error;

3048: End if;
3049: --
3050: IF NOT l_asg_by_per_id_found THEN
3051: hr_utility.set_message(8301, 'GHR_38023_API_INV_ASG');
3052: hr_utility.raise_error;
3053: END IF;
3054: End if;
3055: ELSE -- p_assignment_id is not NULL
3056: hr_utility.set_location('asg id is not null : Asg Id : ' || p_assignment_id,1);

Line 3056: hr_utility.set_location('asg id is not null : Asg Id : ' || p_assignment_id,1);

3052: hr_utility.raise_error;
3053: END IF;
3054: End if;
3055: ELSE -- p_assignment_id is not NULL
3056: hr_utility.set_location('asg id is not null : Asg Id : ' || p_assignment_id,1);
3057: If l_person_type = 'EX_EMP' then
3058: hr_utility.set_location('Ex Employee in conversion action',1);
3059: for c_assignment_ex_emp_rec in c_assignment_ex_emp loop
3060: l_asg_by_asg_id_found := TRUE;

Line 3058: hr_utility.set_location('Ex Employee in conversion action',1);

3054: End if;
3055: ELSE -- p_assignment_id is not NULL
3056: hr_utility.set_location('asg id is not null : Asg Id : ' || p_assignment_id,1);
3057: If l_person_type = 'EX_EMP' then
3058: hr_utility.set_location('Ex Employee in conversion action',1);
3059: for c_assignment_ex_emp_rec in c_assignment_ex_emp loop
3060: l_asg_by_asg_id_found := TRUE;
3061: hr_utility.set_location('Ex Employee - with Asg , value found ',1);
3062: l_effective_date := c_assignment_ex_emp_rec.effective_end_date;

Line 3061: hr_utility.set_location('Ex Employee - with Asg , value found ',1);

3057: If l_person_type = 'EX_EMP' then
3058: hr_utility.set_location('Ex Employee in conversion action',1);
3059: for c_assignment_ex_emp_rec in c_assignment_ex_emp loop
3060: l_asg_by_asg_id_found := TRUE;
3061: hr_utility.set_location('Ex Employee - with Asg , value found ',1);
3062: l_effective_date := c_assignment_ex_emp_rec.effective_end_date;
3063: p_assignment_id := c_assignment_ex_emp_rec.assignment_id;
3064: l_organization_id := c_assignment_ex_emp_rec.organization_id;
3065: l_job_id := c_assignment_ex_emp_rec.job_id;

Line 3084: hr_utility.set_message(8301, 'GHR_38023_API_INV_ASG');

3080: exit;
3081: end loop;
3082: End if;
3083: if not l_asg_by_asg_id_found then
3084: hr_utility.set_message(8301, 'GHR_38023_API_INV_ASG');
3085: hr_utility.raise_error;
3086: end if;
3087: END IF;
3088: END IF;

Line 3085: hr_utility.raise_error;

3081: end loop;
3082: End if;
3083: if not l_asg_by_asg_id_found then
3084: hr_utility.set_message(8301, 'GHR_38023_API_INV_ASG');
3085: hr_utility.raise_error;
3086: end if;
3087: END IF;
3088: END IF;
3089:

Line 3095: hr_utility.set_location(l_proc, 2);

3091: p_organization_id := l_organization_id;
3092: p_job_id := l_job_id;
3093: p_grade_id := l_grade_id;
3094:
3095: hr_utility.set_location(l_proc, 2);
3096:
3097: if p_altered_pa_request_id is not NULL and
3098: p_noa_id_corrected is not NULL then
3099: hr_utility.set_location(l_proc, 104);

Line 3099: hr_utility.set_location(l_proc, 104);

3095: hr_utility.set_location(l_proc, 2);
3096:
3097: if p_altered_pa_request_id is not NULL and
3098: p_noa_id_corrected is not NULL then
3099: hr_utility.set_location(l_proc, 104);
3100:
3101: /* retrieve_business_group_id
3102: ( p_person_id => p_person_id,
3103: p_effective_date => l_effective_date,

Line 3130: hr_utility.set_location(l_proc, 3);

3126: --
3127: p_position_title := get_position_title (p_person_id => p_person_id
3128: ,p_assignment_id => p_assignment_id
3129: ,p_effective_date => l_effective_date);
3130: hr_utility.set_location(l_proc, 3);
3131: --
3132: -- Retrieve Position Number
3133: --
3134: p_position_number := get_position_description_no

Line 3145: hr_utility.set_location(l_proc, 4);

3141: ,p_assignment_id => p_assignment_id
3142: ,p_effective_date => l_effective_date);
3143: END IF;
3144:
3145: hr_utility.set_location(l_proc, 4);
3146: --
3147: -- Retrieve Grade Key Flexfield Information
3148: --
3149: for c_grade_kff_rec in c_grade_kff (l_grade_id) loop

Line 3156: -- hr_utility.set_message(8301, 'GHR_38026_API_INV_GRD');

3152: p_grade_or_level := c_grade_kff_rec.segment2;
3153: exit;
3154: end loop;
3155: if not l_grade_kff_found then
3156: -- hr_utility.set_message(8301, 'GHR_38026_API_INV_GRD');
3157: -- hr_utility.raise_error;
3158: null;
3159: end if;
3160: hr_utility.set_location(l_proc, 5);

Line 3157: -- hr_utility.raise_error;

3153: exit;
3154: end loop;
3155: if not l_grade_kff_found then
3156: -- hr_utility.set_message(8301, 'GHR_38026_API_INV_GRD');
3157: -- hr_utility.raise_error;
3158: null;
3159: end if;
3160: hr_utility.set_location(l_proc, 5);
3161: --

Line 3160: hr_utility.set_location(l_proc, 5);

3156: -- hr_utility.set_message(8301, 'GHR_38026_API_INV_GRD');
3157: -- hr_utility.raise_error;
3158: null;
3159: end if;
3160: hr_utility.set_location(l_proc, 5);
3161: --
3162: -- Retrieve Job Occupational Series
3163: --
3164: ghr_history_api.get_g_session_var(l_session);

Line 3165: hr_utility.set_location('p_assignment id before getting job is ' || p_assignment_id,1);

3161: --
3162: -- Retrieve Job Occupational Series
3163: --
3164: ghr_history_api.get_g_session_var(l_session);
3165: hr_utility.set_location('p_assignment id before getting job is ' || p_assignment_id,1);
3166: if l_session.noa_id_correct is null then --RP
3167: p_occ_code := get_job_occupational_series (p_person_id => p_person_id
3168: ,p_assignment_id => p_assignment_id
3169: ,p_effective_date => l_effective_date);

Line 3179: hr_utility.set_location(l_proc, 6);

3175: end loop;
3176: p_occ_code := get_job_occ_series_job (p_job_id => l_job_id
3177: ,p_business_group_id => l_business_group_id);
3178: end if; --RP
3179: hr_utility.set_location(l_proc, 6);
3180:
3181:
3182: -- VSM added following 2 parameters to all the calls to GHR_History_Fetch procedures
3183: -- ,p_altered_pa_request_id => p_altered_pa_request_id

Line 3200: hr_utility.set_location(l_proc, 7);

3196: );
3197:
3198: p_step_or_rate := l_asg_ei_data.aei_information3;
3199:
3200: hr_utility.set_location(l_proc, 7);
3201: --
3202: -- Retrieve Position Developer Descriptive Flexfield Information
3203: --
3204: -- This procedures uses session variables for p_altered)pa_request_id and p_noa_id_corrected

Line 3215: hr_utility.set_location(l_proc, 8);

3211: l_pay_basis := l_pos_ei_data.poei_information6;
3212: l_pay_table_identifier := l_pos_ei_data.poei_information5;
3213: -- FWFA Changes
3214:
3215: hr_utility.set_location(l_proc, 8);
3216: --
3217: -- Retrieve work_Schedule -- (Added for OGSD)
3218:
3219: If p_assignment_id is null then

Line 3227: hr_utility.set_location(l_proc,9);

3223: ,p_pos_ei_data => l_pos_ei_data
3224: );
3225:
3226: p_work_Schedule := l_pos_ei_data.poei_information10;
3227: hr_utility.set_location(l_proc,9);
3228: Else
3229:
3230: -- VSM Prior PRD and Work Schedule
3231: Ghr_History_Fetch.Fetch_ASGEI_prior_root_sf50(

Line 3246: hr_utility.set_location('PRD is ' ||p_pay_rate_determinant,9);

3242:
3243: End if;
3244:
3245: --Start New Retained Grade Processing
3246: hr_utility.set_location('PRD is ' ||p_pay_rate_determinant,9);
3247: IF p_pay_rate_determinant IN ('A','B','E','F','U','V') THEN
3248: -- use retained details...
3249: BEGIN
3250: l_retained_grade :=

Line 3263: hr_utility.set_message(8301,'GHR_38699_MISSING_RETAINED_DET');

3259: (p_person_id
3260: ,(l_effective_date - 1));
3261: EXCEPTION
3262: WHEN OTHERS THEN
3263: hr_utility.set_message(8301,'GHR_38699_MISSING_RETAINED_DET');
3264: hr_utility.raise_error;
3265: END;
3266: END;
3267: if l_retained_grade.temp_step is NULL THEN -- Temp. Promo RG Changes

Line 3264: hr_utility.raise_error;

3260: ,(l_effective_date - 1));
3261: EXCEPTION
3262: WHEN OTHERS THEN
3263: hr_utility.set_message(8301,'GHR_38699_MISSING_RETAINED_DET');
3264: hr_utility.raise_error;
3265: END;
3266: END;
3267: if l_retained_grade.temp_step is NULL THEN -- Temp. Promo RG Changes
3268: l_update34_date := ghr_pay_caps.update34_implemented_date(p_person_id);

Line 3269: hr_utility.set_location('Update 34 date is ' ||l_update34_date,10);

3265: END;
3266: END;
3267: if l_retained_grade.temp_step is NULL THEN -- Temp. Promo RG Changes
3268: l_update34_date := ghr_pay_caps.update34_implemented_date(p_person_id);
3269: hr_utility.set_location('Update 34 date is ' ||l_update34_date,10);
3270: hr_utility.set_location('Effective date is ' ||l_effective_date,11);
3271: if l_update34_date is not null AND l_effective_date >= l_update34_date then
3272: p_pay_basis := l_retained_grade.pay_basis;
3273: -- FWFA Changes Bug#4444609

Line 3270: hr_utility.set_location('Effective date is ' ||l_effective_date,11);

3266: END;
3267: if l_retained_grade.temp_step is NULL THEN -- Temp. Promo RG Changes
3268: l_update34_date := ghr_pay_caps.update34_implemented_date(p_person_id);
3269: hr_utility.set_location('Update 34 date is ' ||l_update34_date,10);
3270: hr_utility.set_location('Effective date is ' ||l_effective_date,11);
3271: if l_update34_date is not null AND l_effective_date >= l_update34_date then
3272: p_pay_basis := l_retained_grade.pay_basis;
3273: -- FWFA Changes Bug#4444609
3274: p_pay_table_identifier := l_retained_grade.user_table_id;

Line 3276: hr_utility.set_location('RET 1 pay basis is ' ||p_pay_basis,11);

3272: p_pay_basis := l_retained_grade.pay_basis;
3273: -- FWFA Changes Bug#4444609
3274: p_pay_table_identifier := l_retained_grade.user_table_id;
3275: -- FWFA Changes
3276: hr_utility.set_location('RET 1 pay basis is ' ||p_pay_basis,11);
3277: else
3278: -- FWFA Changes Bug#4444609
3279: -- Modified the p_pay_basis assignment to l_pay_basis as there may be a chance of
3280: -- l_pos_ei_data.poei_information6 could be of GHR_US_POS_GRP1

Line 3284: hr_utility.set_location('POS 1 pay basis is ' ||p_pay_basis,11);

3280: -- l_pos_ei_data.poei_information6 could be of GHR_US_POS_GRP1
3281: p_pay_table_identifier := l_pay_table_identifier;
3282: p_pay_basis := l_pay_basis;
3283: -- FWFA Changes
3284: hr_utility.set_location('POS 1 pay basis is ' ||p_pay_basis,11);
3285: end if;
3286: ELSE
3287: -- FWFA Changes Bug#4444609
3288: -- Modified the p_pay_basis assignment to l_pay_basis as there may be a chance of

Line 3301: hr_utility.set_location('POS 2 pay basis is ' ||p_pay_basis,11);

3297: -- l_pos_ei_data.poei_information6 could be of GHR_US_POS_GRP1
3298: p_pay_table_identifier := l_pay_table_identifier;
3299: p_pay_basis := l_pay_basis;
3300: -- FWFA Changes
3301: hr_utility.set_location('POS 2 pay basis is ' ||p_pay_basis,11);
3302: END IF;
3303: hr_utility.set_location('Final from pay basis is ' ||p_pay_basis,11);
3304: --End New Retained Grade Processing
3305:

Line 3303: hr_utility.set_location('Final from pay basis is ' ||p_pay_basis,11);

3299: p_pay_basis := l_pay_basis;
3300: -- FWFA Changes
3301: hr_utility.set_location('POS 2 pay basis is ' ||p_pay_basis,11);
3302: END IF;
3303: hr_utility.set_location('Final from pay basis is ' ||p_pay_basis,11);
3304: --End New Retained Grade Processing
3305:
3306: -- Changed for Basic Salary Rate
3307: --

Line 3319: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');

3315: l_basic_pay := 0;
3316: end if;
3317: */
3318: if l_multi_error_flag then
3319: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
3320: hr_utility.raise_error;
3321: end if;
3322: --
3323:

Line 3320: hr_utility.raise_error;

3316: end if;
3317: */
3318: if l_multi_error_flag then
3319: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
3320: hr_utility.raise_error;
3321: end if;
3322: --
3323:
3324: -- FWFA Changes Bug#4444609 Modified 'Locality Pay' to 'Locality Pay or SR Supplement'

Line 3338: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');

3334: l_locality_adj := 0;
3335: end if;
3336: */
3337: if l_multi_error_flag then
3338: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
3339: hr_utility.raise_error;
3340: end if;
3341: --
3342:

Line 3339: hr_utility.raise_error;

3335: end if;
3336: */
3337: if l_multi_error_flag then
3338: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
3339: hr_utility.raise_error;
3340: end if;
3341: --
3342:
3343: -- Processing Total Pay and Adjusted Basic Pay

Line 3361: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');

3357: l_adj_basic_pay := 0;
3358: end if;
3359: */
3360: if l_multi_error_flag then
3361: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
3362: hr_utility.raise_error;
3363: end if;
3364: --
3365: --

Line 3362: hr_utility.raise_error;

3358: end if;
3359: */
3360: if l_multi_error_flag then
3361: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
3362: hr_utility.raise_error;
3363: end if;
3364: --
3365: --
3366: -- 7/28/97 Added retrieval of Other pay and the 7 items that make it up!

Line 3378: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');

3374: l_other_pay := 0;
3375: end if;
3376: */
3377: if l_multi_error_flag then
3378: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
3379: hr_utility.raise_error;
3380: end if;
3381: --
3382:

Line 3379: hr_utility.raise_error;

3375: end if;
3376: */
3377: if l_multi_error_flag then
3378: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
3379: hr_utility.raise_error;
3380: end if;
3381: --
3382:
3383:

Line 3395: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');

3391: l_total_salary := 0;
3392: end if;
3393: */
3394: if l_multi_error_flag then
3395: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
3396: hr_utility.raise_error;
3397: end if;
3398: --
3399: --

Line 3396: hr_utility.raise_error;

3392: end if;
3393: */
3394: if l_multi_error_flag then
3395: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
3396: hr_utility.raise_error;
3397: end if;
3398: --
3399: --
3400: p_total_salary := round(l_total_salary,2);

Line 3408: hr_utility.set_location(l_proc, 9);

3404: p_other_pay := l_other_pay;
3405: --
3406: -- Retrieve Organzation Information
3407: --
3408: hr_utility.set_location(l_proc, 9);
3409: --
3410: -- Retrieve Position's Organization's address lines
3411:
3412:

Line 3443: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');

3439: l_au_overtime := 0;
3440: end if;
3441: */
3442: if l_multi_error_flag then
3443: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
3444: hr_utility.raise_error;
3445: end if;
3446: --
3447: retrieve_element_entry_value (p_element_name => 'AUO'

Line 3444: hr_utility.raise_error;

3440: end if;
3441: */
3442: if l_multi_error_flag then
3443: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
3444: hr_utility.raise_error;
3445: end if;
3446: --
3447: retrieve_element_entry_value (p_element_name => 'AUO'
3448: ,p_input_value_name => 'Premium Pay Ind'

Line 3458: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');

3454: l_auo_premium_pay_indicator := 0;
3455: end if;
3456: */
3457: if l_multi_error_flag then
3458: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
3459: hr_utility.raise_error;
3460: end if;
3461: --
3462: retrieve_element_entry_value (p_element_name => 'Availability Pay'

Line 3459: hr_utility.raise_error;

3455: end if;
3456: */
3457: if l_multi_error_flag then
3458: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
3459: hr_utility.raise_error;
3460: end if;
3461: --
3462: retrieve_element_entry_value (p_element_name => 'Availability Pay'
3463: ,p_input_value_name => 'Amount'

Line 3473: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');

3469: l_availability_pay := 0;
3470: end if;
3471: */
3472: if l_multi_error_flag then
3473: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
3474: hr_utility.raise_error;
3475: end if;
3476: --
3477:

Line 3474: hr_utility.raise_error;

3470: end if;
3471: */
3472: if l_multi_error_flag then
3473: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
3474: hr_utility.raise_error;
3475: end if;
3476: --
3477:
3478: retrieve_element_entry_value (p_element_name => 'Availability Pay'

Line 3489: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');

3485: l_ap_premium_pay_indicator := 0;
3486: end if;
3487: */
3488: if l_multi_error_flag then
3489: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
3490: hr_utility.raise_error;
3491: end if;
3492: --
3493: retrieve_element_entry_value (p_element_name => 'Retention Allowance'

Line 3490: hr_utility.raise_error;

3486: end if;
3487: */
3488: if l_multi_error_flag then
3489: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
3490: hr_utility.raise_error;
3491: end if;
3492: --
3493: retrieve_element_entry_value (p_element_name => 'Retention Allowance'
3494: ,p_input_value_name => 'Amount'

Line 3511: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');

3507: l_retention_allowance := 0;
3508: end if;
3509: */
3510: if l_multi_error_flag then
3511: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
3512: hr_utility.raise_error;
3513: end if;
3514: --
3515: retrieve_element_entry_value (p_element_name => 'Supervisory Differential'

Line 3512: hr_utility.raise_error;

3508: end if;
3509: */
3510: if l_multi_error_flag then
3511: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
3512: hr_utility.raise_error;
3513: end if;
3514: --
3515: retrieve_element_entry_value (p_element_name => 'Supervisory Differential'
3516: ,p_input_value_name => 'Amount'

Line 3533: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');

3529: l_supervisory_differential := 0;
3530: end if;
3531: */
3532: if l_multi_error_flag then
3533: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
3534: hr_utility.raise_error;
3535: end if;
3536: --
3537: retrieve_element_entry_value (p_element_name => 'Staffing Differential'

Line 3534: hr_utility.raise_error;

3530: end if;
3531: */
3532: if l_multi_error_flag then
3533: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
3534: hr_utility.raise_error;
3535: end if;
3536: --
3537: retrieve_element_entry_value (p_element_name => 'Staffing Differential'
3538: ,p_input_value_name => 'Amount'

Line 3555: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');

3551: l_staffing_differential := 0;
3552: end if;
3553: */
3554: if l_multi_error_flag then
3555: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
3556: hr_utility.raise_error;
3557: end if;
3558: --
3559: p_au_overtime := l_au_overtime;

Line 3556: hr_utility.raise_error;

3552: end if;
3553: */
3554: if l_multi_error_flag then
3555: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
3556: hr_utility.raise_error;
3557: end if;
3558: --
3559: p_au_overtime := l_au_overtime;
3560: p_auo_premium_pay_indicator := l_auo_premium_pay_indicator;

Line 3569: hr_utility.set_location(' Leaving:'||l_proc, 20);

3565: p_supervisory_differential := l_supervisory_differential;
3566: p_supervisory_diff_percentage := l_supervisory_diff_percentage;
3567: p_staffing_differential := l_staffing_differential;
3568: p_staffing_diff_percentage := l_staffing_diff_percentage;
3569: hr_utility.set_location(' Leaving:'||l_proc, 20);
3570: EXCEPTION
3571: when others then
3572: -- NOCOPY Changes
3573: -- Reset IN OUT params and Set OUT params to null

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

3620: -- --------------------------------------------------------------------------
3621: FUNCTION return_upd_hr_dml_status RETURN BOOLEAN IS
3622: l_proc varchar2(72) := g_package||'return_upd_hr_dml_status';
3623: begin
3624: hr_utility.set_location('Entering:'||l_proc,5);
3625: return (nvl(g_api_dml, false));
3626: hr_utility.set_location(' Leaving:'||l_proc,10);
3627: end return_upd_hr_dml_status;
3628:

Line 3626: hr_utility.set_location(' Leaving:'||l_proc,10);

3622: l_proc varchar2(72) := g_package||'return_upd_hr_dml_status';
3623: begin
3624: hr_utility.set_location('Entering:'||l_proc,5);
3625: return (nvl(g_api_dml, false));
3626: hr_utility.set_location(' Leaving:'||l_proc,10);
3627: end return_upd_hr_dml_status;
3628:
3629: -- ---------------------------------------------------------------------------
3630: -- |--------------------------< return_special_information >----------------|

Line 3708: hr_utility.set_message(8301,'GHR_38275_INV_SP_INFO_TYPE');

3704: l_id_flex_num := flex_num.id_flex_num;
3705: End loop;
3706:
3707: If l_id_flex_num is null then
3708: hr_utility.set_message(8301,'GHR_38275_INV_SP_INFO_TYPE');
3709: hr_utility.raise_error;
3710: End if;
3711:
3712: for special_info in c_sit loop

Line 3709: hr_utility.raise_error;

3705: End loop;
3706:
3707: If l_id_flex_num is null then
3708: hr_utility.set_message(8301,'GHR_38275_INV_SP_INFO_TYPE');
3709: hr_utility.raise_error;
3710: End if;
3711:
3712: for special_info in c_sit loop
3713: p_special_info.segment1 := special_info.segment1;

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

3818: order by 1 desc;
3819:
3820: begin
3821:
3822: hr_utility.set_location('Entering ' || l_proc,5);
3823:
3824: for flex_num in c_flex_num loop
3825: hr_utility.set_location(l_proc,10);
3826: l_id_flex_num := flex_num.id_flex_num;

Line 3825: hr_utility.set_location(l_proc,10);

3821:
3822: hr_utility.set_location('Entering ' || l_proc,5);
3823:
3824: for flex_num in c_flex_num loop
3825: hr_utility.set_location(l_proc,10);
3826: l_id_flex_num := flex_num.id_flex_num;
3827: end loop;
3828: hr_utility.set_location(l_proc,15);
3829: for sit in c_sit loop

Line 3828: hr_utility.set_location(l_proc,15);

3824: for flex_num in c_flex_num loop
3825: hr_utility.set_location(l_proc,10);
3826: l_id_flex_num := flex_num.id_flex_num;
3827: end loop;
3828: hr_utility.set_location(l_proc,15);
3829: for sit in c_sit loop
3830: hr_utility.set_location(l_proc,20);
3831: p_education_level := sit.segment1;
3832: p_academic_discipline := sit.segment2;

Line 3830: hr_utility.set_location(l_proc,20);

3826: l_id_flex_num := flex_num.id_flex_num;
3827: end loop;
3828: hr_utility.set_location(l_proc,15);
3829: for sit in c_sit loop
3830: hr_utility.set_location(l_proc,20);
3831: p_education_level := sit.segment1;
3832: p_academic_discipline := sit.segment2;
3833: p_year_degree_attained := sit.segment3;
3834: exit;

Line 3836: hr_utility.set_location(l_proc,25);

3832: p_academic_discipline := sit.segment2;
3833: p_year_degree_attained := sit.segment3;
3834: exit;
3835: end loop;
3836: hr_utility.set_location(l_proc,25);
3837:
3838: hr_utility.set_location('Leaving ' ||l_proc,30);
3839: EXCEPTION
3840: when others then

Line 3838: hr_utility.set_location('Leaving ' ||l_proc,30);

3834: exit;
3835: end loop;
3836: hr_utility.set_location(l_proc,25);
3837:
3838: hr_utility.set_location('Leaving ' ||l_proc,30);
3839: EXCEPTION
3840: when others then
3841: -- NOCOPY changes
3842: -- Reset IN OUT params and set OUT params

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

3919: where groupbox_id = l_pa_routing_history_rec.groupbox_id;
3920:
3921: begin
3922:
3923: hr_utility.set_location('Entering ' || l_proc,5);
3924:
3925: If p_action_taken not in ('NOT_ROUTED','UPDATE_HR','CONTINUE') then
3926: hr_utility.set_location(l_proc || p_action_taken,10);
3927: for routing_rec in c_routing_count loop

Line 3926: hr_utility.set_location(l_proc || p_action_taken,10);

3922:
3923: hr_utility.set_location('Entering ' || l_proc,5);
3924:
3925: If p_action_taken not in ('NOT_ROUTED','UPDATE_HR','CONTINUE') then
3926: hr_utility.set_location(l_proc || p_action_taken,10);
3927: for routing_rec in c_routing_count loop
3928: hr_utility.set_location(l_proc,15);
3929: l_cnt := routing_rec.cnt;
3930: -- Begin Bug# 5634964

Line 3928: hr_utility.set_location(l_proc,15);

3924:
3925: If p_action_taken not in ('NOT_ROUTED','UPDATE_HR','CONTINUE') then
3926: hr_utility.set_location(l_proc || p_action_taken,10);
3927: for routing_rec in c_routing_count loop
3928: hr_utility.set_location(l_proc,15);
3929: l_cnt := routing_rec.cnt;
3930: -- Begin Bug# 5634964
3931: IF p_action_taken not in('INITIATED') and p_old_action_taken = 'FUTURE_ACTION' THEN
3932: for routing_action in c_routing_action loop

Line 3942: hr_utility.set_location(l_proc ||p_action_taken,20);

3938: end loop;
3939: -- The very fact that it is a 2nd routing history and action taken is not 'UPDATE_HR_COMPLETE' means
3940: -- work flow needs to be initiated. In all other cases , the blockingofparequest needs to be called
3941: If l_cnt = 2 then
3942: hr_utility.set_location(l_proc ||p_action_taken,20);
3943: If p_action_taken not in ('FUTURE_ACTION','CANCELED') then
3944: hr_utility.set_location('not FA or CAncel',1);
3945: If (p_action_taken = 'UPDATE_HR_COMPLETE'or p_action_taken = 'ENDED') and
3946: p_old_action_taken = 'FUTURE_ACTION' then

Line 3944: hr_utility.set_location('not FA or CAncel',1);

3940: -- work flow needs to be initiated. In all other cases , the blockingofparequest needs to be called
3941: If l_cnt = 2 then
3942: hr_utility.set_location(l_proc ||p_action_taken,20);
3943: If p_action_taken not in ('FUTURE_ACTION','CANCELED') then
3944: hr_utility.set_location('not FA or CAncel',1);
3945: If (p_action_taken = 'UPDATE_HR_COMPLETE'or p_action_taken = 'ENDED') and
3946: p_old_action_taken = 'FUTURE_ACTION' then
3947: hr_utility.set_location('nothing',1);
3948: Null;

Line 3947: hr_utility.set_location('nothing',1);

3943: If p_action_taken not in ('FUTURE_ACTION','CANCELED') then
3944: hr_utility.set_location('not FA or CAncel',1);
3945: If (p_action_taken = 'UPDATE_HR_COMPLETE'or p_action_taken = 'ENDED') and
3946: p_old_action_taken = 'FUTURE_ACTION' then
3947: hr_utility.set_location('nothing',1);
3948: Null;
3949: Else --(p_action_taken = 'UPDATE_HR_COMPLETE'or p_action_taken = 'ENDED')
3950: hr_utility.set_location('else not Update Coplete',1);
3951: for forwarding_name in c_forwarding_name loop

Line 3950: hr_utility.set_location('else not Update Coplete',1);

3946: p_old_action_taken = 'FUTURE_ACTION' then
3947: hr_utility.set_location('nothing',1);
3948: Null;
3949: Else --(p_action_taken = 'UPDATE_HR_COMPLETE'or p_action_taken = 'ENDED')
3950: hr_utility.set_location('else not Update Coplete',1);
3951: for forwarding_name in c_forwarding_name loop
3952: hr_utility.set_location(l_proc,25);
3953: l_pa_routing_history_rec.groupbox_id := forwarding_name.groupbox_id;
3954: l_pa_routing_history_rec.user_name := forwarding_name.user_name;

Line 3952: hr_utility.set_location(l_proc,25);

3948: Null;
3949: Else --(p_action_taken = 'UPDATE_HR_COMPLETE'or p_action_taken = 'ENDED')
3950: hr_utility.set_location('else not Update Coplete',1);
3951: for forwarding_name in c_forwarding_name loop
3952: hr_utility.set_location(l_proc,25);
3953: l_pa_routing_history_rec.groupbox_id := forwarding_name.groupbox_id;
3954: l_pa_routing_history_rec.user_name := forwarding_name.user_name;
3955: hr_utility.set_location('groupbox ' || l_pa_routing_history_rec.groupbox_id,1);
3956: hr_utility.set_location('username ' || l_pa_routing_history_rec.user_name,1);

Line 3955: hr_utility.set_location('groupbox ' || l_pa_routing_history_rec.groupbox_id,1);

3951: for forwarding_name in c_forwarding_name loop
3952: hr_utility.set_location(l_proc,25);
3953: l_pa_routing_history_rec.groupbox_id := forwarding_name.groupbox_id;
3954: l_pa_routing_history_rec.user_name := forwarding_name.user_name;
3955: hr_utility.set_location('groupbox ' || l_pa_routing_history_rec.groupbox_id,1);
3956: hr_utility.set_location('username ' || l_pa_routing_history_rec.user_name,1);
3957: exit;
3958: end loop;
3959: If l_pa_routing_history_rec.user_name is null then

Line 3956: hr_utility.set_location('username ' || l_pa_routing_history_rec.user_name,1);

3952: hr_utility.set_location(l_proc,25);
3953: l_pa_routing_history_rec.groupbox_id := forwarding_name.groupbox_id;
3954: l_pa_routing_history_rec.user_name := forwarding_name.user_name;
3955: hr_utility.set_location('groupbox ' || l_pa_routing_history_rec.groupbox_id,1);
3956: hr_utility.set_location('username ' || l_pa_routing_history_rec.user_name,1);
3957: exit;
3958: end loop;
3959: If l_pa_routing_history_rec.user_name is null then
3960: hr_utility.set_location(l_proc || 'user not null',30);

Line 3960: hr_utility.set_location(l_proc || 'user not null',30);

3956: hr_utility.set_location('username ' || l_pa_routing_history_rec.user_name,1);
3957: exit;
3958: end loop;
3959: If l_pa_routing_history_rec.user_name is null then
3960: hr_utility.set_location(l_proc || 'user not null',30);
3961: for groupbox_name in c_groupbox_name loop
3962: hr_utility.set_location(l_proc,35);
3963: l_forward_to_name := groupbox_name.name;
3964: end loop;

Line 3962: hr_utility.set_location(l_proc,35);

3958: end loop;
3959: If l_pa_routing_history_rec.user_name is null then
3960: hr_utility.set_location(l_proc || 'user not null',30);
3961: for groupbox_name in c_groupbox_name loop
3962: hr_utility.set_location(l_proc,35);
3963: l_forward_to_name := groupbox_name.name;
3964: end loop;
3965: Else
3966: l_forward_to_name := l_pa_routing_history_rec.user_name;

Line 3969: hr_utility.set_message(8301,'GHR_38276_FORWARD_NAME_REQD');

3965: Else
3966: l_forward_to_name := l_pa_routing_history_rec.user_name;
3967: End if;
3968: If l_forward_to_name is null then
3969: hr_utility.set_message(8301,'GHR_38276_FORWARD_NAME_REQD');
3970: hr_utility.raise_error;
3971: End if;
3972: hr_utility.set_location(l_proc,40);
3973: ghr_wf_pkg.startsf52process

Line 3970: hr_utility.raise_error;

3966: l_forward_to_name := l_pa_routing_history_rec.user_name;
3967: End if;
3968: If l_forward_to_name is null then
3969: hr_utility.set_message(8301,'GHR_38276_FORWARD_NAME_REQD');
3970: hr_utility.raise_error;
3971: End if;
3972: hr_utility.set_location(l_proc,40);
3973: ghr_wf_pkg.startsf52process
3974: (p_pa_request_id => p_pa_request_id,

Line 3972: hr_utility.set_location(l_proc,40);

3968: If l_forward_to_name is null then
3969: hr_utility.set_message(8301,'GHR_38276_FORWARD_NAME_REQD');
3970: hr_utility.raise_error;
3971: End if;
3972: hr_utility.set_location(l_proc,40);
3973: ghr_wf_pkg.startsf52process
3974: (p_pa_request_id => p_pa_request_id,
3975: p_forward_to_name => l_forward_to_name,
3976: p_error_msg => p_error

Line 3979: hr_utility.set_location('after call to start sf52' || p_old_action_taken,11);

3975: p_forward_to_name => l_forward_to_name,
3976: p_error_msg => p_error
3977: );
3978: End if; --(p_action_taken = 'UPDATE_HR_COMPLETE'or p_action_taken = 'ENDED')
3979: hr_utility.set_location('after call to start sf52' || p_old_action_taken,11);
3980: Elsif p_action_taken in ('FUTURE_ACTION','CANCELED')then
3981: hr_utility.set_location(l_proc,43);
3982: ghr_wf_pkg.CompleteBlockingOfparequest
3983: (p_pa_request_id => p_pa_request_id,

Line 3981: hr_utility.set_location(l_proc,43);

3977: );
3978: End if; --(p_action_taken = 'UPDATE_HR_COMPLETE'or p_action_taken = 'ENDED')
3979: hr_utility.set_location('after call to start sf52' || p_old_action_taken,11);
3980: Elsif p_action_taken in ('FUTURE_ACTION','CANCELED')then
3981: hr_utility.set_location(l_proc,43);
3982: ghr_wf_pkg.CompleteBlockingOfparequest
3983: (p_pa_request_id => p_pa_request_id,
3984: p_error_msg => p_error
3985: );

Line 3991: hr_utility.set_location('Old Action Taken ' || p_old_action_taken,1);

3987:
3988: -- If there are more than 2 routing history records, then workflow has already started and
3989: -- now we need to know whether to transfer OUT to blockingoffutureactions of blockingofparequest
3990: Elsif l_cnt > 2 then
3991: hr_utility.set_location('Old Action Taken ' || p_old_action_taken,1);
3992: hr_utility.set_location(l_proc,45);
3993: If nvl(p_old_action_taken,hr_api.g_varchar2) = 'FUTURE_ACTION' and
3994: p_action_taken ='UPDATE_HR_COMPLETE' then
3995: ghr_wf_pkg.completeblockingoffutureaction

Line 3992: hr_utility.set_location(l_proc,45);

3988: -- If there are more than 2 routing history records, then workflow has already started and
3989: -- now we need to know whether to transfer OUT to blockingoffutureactions of blockingofparequest
3990: Elsif l_cnt > 2 then
3991: hr_utility.set_location('Old Action Taken ' || p_old_action_taken,1);
3992: hr_utility.set_location(l_proc,45);
3993: If nvl(p_old_action_taken,hr_api.g_varchar2) = 'FUTURE_ACTION' and
3994: p_action_taken ='UPDATE_HR_COMPLETE' then
3995: ghr_wf_pkg.completeblockingoffutureaction
3996: (p_pa_request_id => p_pa_request_id,

Line 4008: hr_utility.set_location('continue',1);

4004: End if; --l_cnt = 2
4005: End if; -- p_action_taken not in ('NOT_ROUTED','UPDATE_HR','CONTINUE')
4006:
4007: If p_action_taken = 'CONTINUE' then
4008: hr_utility.set_location('continue',1);
4009: -- Update the current status of the PA Request with the next in hierarchy (after update_hr,future_action), which is APPROVED.
4010: for par in c_par loop
4011: l_object_version_number := par.object_version_number;
4012: end loop;

Line 4023: hr_utility.set_location(l_proc,25);

4019: l_cnt := routing_rec.cnt;
4020: end loop;
4021:
4022: for forwarding_name in c_forwarding_name loop
4023: hr_utility.set_location(l_proc,25);
4024: hr_utility.set_location('inside rh loop',2);
4025: l_pa_routing_history_rec.pa_routing_history_id := forwarding_name.pa_routing_history_id;
4026: l_pa_routing_history_rec.pa_request_id := forwarding_name.pa_request_id;
4027: l_pa_routing_history_rec.initiator_flag := forwarding_name.initiator_flag;

Line 4024: hr_utility.set_location('inside rh loop',2);

4020: end loop;
4021:
4022: for forwarding_name in c_forwarding_name loop
4023: hr_utility.set_location(l_proc,25);
4024: hr_utility.set_location('inside rh loop',2);
4025: l_pa_routing_history_rec.pa_routing_history_id := forwarding_name.pa_routing_history_id;
4026: l_pa_routing_history_rec.pa_request_id := forwarding_name.pa_request_id;
4027: l_pa_routing_history_rec.initiator_flag := forwarding_name.initiator_flag;
4028: l_pa_routing_history_rec.requester_flag := forwarding_name.requester_flag;

Line 4051: hr_utility.set_location('user name is null',1);

4047: exit;
4048: end loop;
4049:
4050: If l_pa_routing_history_rec.user_name is null then
4051: hr_utility.set_location('user name is null',1);
4052: hr_utility.set_location(l_proc,30);
4053: for groupbox_name in c_groupbox_name loop
4054: hr_utility.set_location('inside groupbox cursor',2);
4055: hr_utility.set_location(l_proc,35);

Line 4052: hr_utility.set_location(l_proc,30);

4048: end loop;
4049:
4050: If l_pa_routing_history_rec.user_name is null then
4051: hr_utility.set_location('user name is null',1);
4052: hr_utility.set_location(l_proc,30);
4053: for groupbox_name in c_groupbox_name loop
4054: hr_utility.set_location('inside groupbox cursor',2);
4055: hr_utility.set_location(l_proc,35);
4056: l_forward_to_name := groupbox_name.name;

Line 4054: hr_utility.set_location('inside groupbox cursor',2);

4050: If l_pa_routing_history_rec.user_name is null then
4051: hr_utility.set_location('user name is null',1);
4052: hr_utility.set_location(l_proc,30);
4053: for groupbox_name in c_groupbox_name loop
4054: hr_utility.set_location('inside groupbox cursor',2);
4055: hr_utility.set_location(l_proc,35);
4056: l_forward_to_name := groupbox_name.name;
4057: end loop;
4058: Else

Line 4055: hr_utility.set_location(l_proc,35);

4051: hr_utility.set_location('user name is null',1);
4052: hr_utility.set_location(l_proc,30);
4053: for groupbox_name in c_groupbox_name loop
4054: hr_utility.set_location('inside groupbox cursor',2);
4055: hr_utility.set_location(l_proc,35);
4056: l_forward_to_name := groupbox_name.name;
4057: end loop;
4058: Else
4059: l_forward_to_name := l_pa_routing_history_rec.user_name;

Line 4061: hr_utility.set_location('Forward to name : ' || l_forward_to_name,3);

4057: end loop;
4058: Else
4059: l_forward_to_name := l_pa_routing_history_rec.user_name;
4060: End if;
4061: hr_utility.set_location('Forward to name : ' || l_forward_to_name,3);
4062: If l_forward_to_name is null then
4063: hr_utility.set_message(8301,'GHR_38276_FORWARD_NAME_REQD');
4064: hr_utility.raise_error;
4065: End if;

Line 4063: hr_utility.set_message(8301,'GHR_38276_FORWARD_NAME_REQD');

4059: l_forward_to_name := l_pa_routing_history_rec.user_name;
4060: End if;
4061: hr_utility.set_location('Forward to name : ' || l_forward_to_name,3);
4062: If l_forward_to_name is null then
4063: hr_utility.set_message(8301,'GHR_38276_FORWARD_NAME_REQD');
4064: hr_utility.raise_error;
4065: End if;
4066: hr_utility.set_location('Before call to prh' || l_proc,40);
4067:

Line 4064: hr_utility.raise_error;

4060: End if;
4061: hr_utility.set_location('Forward to name : ' || l_forward_to_name,3);
4062: If l_forward_to_name is null then
4063: hr_utility.set_message(8301,'GHR_38276_FORWARD_NAME_REQD');
4064: hr_utility.raise_error;
4065: End if;
4066: hr_utility.set_location('Before call to prh' || l_proc,40);
4067:
4068: ghr_prh_ins.ins

Line 4066: hr_utility.set_location('Before call to prh' || l_proc,40);

4062: If l_forward_to_name is null then
4063: hr_utility.set_message(8301,'GHR_38276_FORWARD_NAME_REQD');
4064: hr_utility.raise_error;
4065: End if;
4066: hr_utility.set_location('Before call to prh' || l_proc,40);
4067:
4068: ghr_prh_ins.ins
4069: (
4070: p_pa_routing_history_id => l_pa_routing_history_rec.pa_routing_history_id,