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

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

68: l_exists varchar2(30);
69: l_proc varchar2(72) := g_package||'update_cak_concat_segs_auto';
70: --
71: begin
72: hr_utility.set_location('Entering:'|| l_proc, 10);
73: --
74: -- The outer procedure has already establish that an update is
75: -- required. This sub-procedure uses an autonomous transaction
76: -- to ensure that any commits do not impact the main transaction.

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

89: open csr_cak_lock;
90: fetch csr_cak_lock into l_exists;
91: if csr_cak_lock%found then
92: close csr_cak_lock;
93: hr_utility.set_location(l_proc, 20);
94: --
95: -- Lock obtained by this transaction, updating the concatenated
96: -- segment string should be performed.
97: --

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

112: else
113: close csr_cak_lock;
114: end if;
115: --
116: hr_utility.set_location('Leaving:'|| l_proc, 30);
117: Exception
118: When HR_Api.Object_Locked then
119: --
120: -- This autonomous transaction was unable to lock the row.

Line 125: hr_utility.set_location('Leaving:'|| l_proc, 40);

121: -- It can be assumed that another transaction has locked the
122: -- row and is performing the update. Hence the error can
123: -- be suppressed without raising it to the end user.
124: --
125: hr_utility.set_location('Leaving:'|| l_proc, 40);
126: end update_cak_concat_segs_auto;
127: begin
128: hr_utility.set_location('Entering:'|| l_proc, 10);
129: --

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

124: --
125: hr_utility.set_location('Leaving:'|| l_proc, 40);
126: end update_cak_concat_segs_auto;
127: begin
128: hr_utility.set_location('Entering:'|| l_proc, 10);
129: --
130: -- First find out if it is necessary to update the concatenated
131: -- segment string column. This select is being done to avoid the
132: -- performance unnecessary overhead of set-up an autonomous

Line 148: hr_utility.set_location('Leaving:'|| l_proc, 40);

144: else
145: close csr_chk_cak;
146: end if;
147: --
148: hr_utility.set_location('Leaving:'|| l_proc, 40);
149: --
150: end update_cak_concat_segs;
151: --
152: --

Line 259: hr_utility.raise_error;

255: if (l_value_passed = 'N'
256: and (p_cost_allocation_keyflex_id is null
257: or p_cost_allocation_keyflex_id = -1)) then
258: fnd_message.set_name('PER','HR_51342_COST_COST_CODE_REQ');
259: hr_utility.raise_error;
260: end if;
261: --
262:
263: OPEN csr_segment;

Line 297: hr_utility.raise_error;

293: If (l_required_flag(i) = 'Y' and p_segment(l_segment_no(i)) is null) then
294: fnd_message.set_name('PER','HR_FLEX_VALUE_MISSING');
295: fnd_message.set_token('COLUMN',l_application_column(i));
296: fnd_message.set_token('PROMPT',l_application_segment(i));
297: hr_utility.raise_error;
298: end if;
299: END LOOP;
300:
301: end if;

Line 309: -- hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

305: -- for i in 1..30 loop
306: -- if l_required_segment(i) = 'N' then
307: -- if (p_segment(i) is not null or p_segment(i) = hr_api.g_varchar2) then
308: -- --
309: -- hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
310: -- hr_utility.set_message_token('PROCEDURE', l_proc);
311: -- hr_utility.set_message_token('STEP','20');
312: -- hr_utility.raise_error;
313: -- --

Line 310: -- hr_utility.set_message_token('PROCEDURE', l_proc);

306: -- if l_required_segment(i) = 'N' then
307: -- if (p_segment(i) is not null or p_segment(i) = hr_api.g_varchar2) then
308: -- --
309: -- hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
310: -- hr_utility.set_message_token('PROCEDURE', l_proc);
311: -- hr_utility.set_message_token('STEP','20');
312: -- hr_utility.raise_error;
313: -- --
314: -- end if;

Line 311: -- hr_utility.set_message_token('STEP','20');

307: -- if (p_segment(i) is not null or p_segment(i) = hr_api.g_varchar2) then
308: -- --
309: -- hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
310: -- hr_utility.set_message_token('PROCEDURE', l_proc);
311: -- hr_utility.set_message_token('STEP','20');
312: -- hr_utility.raise_error;
313: -- --
314: -- end if;
315: -- end if;

Line 312: -- hr_utility.raise_error;

308: -- --
309: -- hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
310: -- hr_utility.set_message_token('PROCEDURE', l_proc);
311: -- hr_utility.set_message_token('STEP','20');
312: -- hr_utility.raise_error;
313: -- --
314: -- end if;
315: -- end if;
316: -- end loop;

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

401: from per_business_groups pbg
402: where pbg.business_group_id = p_business_group_id;
403: --
404: begin
405: hr_utility.set_location('Entering:'|| l_proc, 10);
406: --
407: -- Issue a savepoint
408: --
409: savepoint CREATE_COST_ALLOCATION;

Line 685: hr_utility.set_location(' Leaving:'||l_proc, 70);

681: p_effective_end_date := l_effective_end_date;
682: p_cost_allocation_keyflex_id := l_cost_allocation_keyflex_id;
683: p_object_version_number := l_object_version_number;
684: --
685: hr_utility.set_location(' Leaving:'||l_proc, 70);
686: exception
687: when hr_api.validate_enabled then
688: --
689: -- As the Validate_Enabled exception has been raised

Line 704: hr_utility.set_location(' Leaving:'||l_proc, 80);

700: p_effective_start_date := null;
701: p_effective_end_date := null;
702: p_cost_allocation_keyflex_id := null;
703: p_object_version_number := null;
704: hr_utility.set_location(' Leaving:'||l_proc, 80);
705: when others then
706: --
707: -- A validation or unexpected error has occured
708: --

Line 720: hr_utility.set_location(' Leaving:'||l_proc, 90);

716: p_effective_end_date := null;
717: p_cost_allocation_keyflex_id := null;
718: p_object_version_number := null;
719: --
720: hr_utility.set_location(' Leaving:'||l_proc, 90);
721: raise;
722: end CREATE_COST_ALLOCATION;
723: --
724: -- ----------------------------------------------------------------------------

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

857: and pac.effective_end_date
858: and pac.cost_allocation_keyflex_id = pca.cost_allocation_keyflex_id;
859: --
860: begin
861: hr_utility.set_location('Entering:'|| l_proc, 10);
862: --
863: -- Issue a savepoint
864: --
865: savepoint UPDATE_COST_ALLOCATION;

Line 1075: hr_utility.set_location('Entering Update API', 10);

1071: end if;
1072: --
1073:
1074: l_cost_allocation_keyflex_id := -1;
1075: hr_utility.set_location('Entering Update API', 10);
1076: hr_utility.set_location('p_cost_allocation_keyflex_id:'|| p_cost_allocation_keyflex_id, 10);
1077: hr_utility.set_location('l_cost_allocation_keyflex_id:'|| l_cost_allocation_keyflex_id, 10);
1078: hr_utility.set_location('l_flex_num:'|| l_flex_num, 10);
1079: hr_utility.set_location('l_concat_segments:'|| l_concat_segments, 10);

Line 1076: hr_utility.set_location('p_cost_allocation_keyflex_id:'|| p_cost_allocation_keyflex_id, 10);

1072: --
1073:
1074: l_cost_allocation_keyflex_id := -1;
1075: hr_utility.set_location('Entering Update API', 10);
1076: hr_utility.set_location('p_cost_allocation_keyflex_id:'|| p_cost_allocation_keyflex_id, 10);
1077: hr_utility.set_location('l_cost_allocation_keyflex_id:'|| l_cost_allocation_keyflex_id, 10);
1078: hr_utility.set_location('l_flex_num:'|| l_flex_num, 10);
1079: hr_utility.set_location('l_concat_segments:'|| l_concat_segments, 10);
1080:

Line 1077: hr_utility.set_location('l_cost_allocation_keyflex_id:'|| l_cost_allocation_keyflex_id, 10);

1073:
1074: l_cost_allocation_keyflex_id := -1;
1075: hr_utility.set_location('Entering Update API', 10);
1076: hr_utility.set_location('p_cost_allocation_keyflex_id:'|| p_cost_allocation_keyflex_id, 10);
1077: hr_utility.set_location('l_cost_allocation_keyflex_id:'|| l_cost_allocation_keyflex_id, 10);
1078: hr_utility.set_location('l_flex_num:'|| l_flex_num, 10);
1079: hr_utility.set_location('l_concat_segments:'|| l_concat_segments, 10);
1080:
1081:

Line 1078: hr_utility.set_location('l_flex_num:'|| l_flex_num, 10);

1074: l_cost_allocation_keyflex_id := -1;
1075: hr_utility.set_location('Entering Update API', 10);
1076: hr_utility.set_location('p_cost_allocation_keyflex_id:'|| p_cost_allocation_keyflex_id, 10);
1077: hr_utility.set_location('l_cost_allocation_keyflex_id:'|| l_cost_allocation_keyflex_id, 10);
1078: hr_utility.set_location('l_flex_num:'|| l_flex_num, 10);
1079: hr_utility.set_location('l_concat_segments:'|| l_concat_segments, 10);
1080:
1081:
1082: l_cost_allocation_keyflex_id :=

Line 1079: hr_utility.set_location('l_concat_segments:'|| l_concat_segments, 10);

1075: hr_utility.set_location('Entering Update API', 10);
1076: hr_utility.set_location('p_cost_allocation_keyflex_id:'|| p_cost_allocation_keyflex_id, 10);
1077: hr_utility.set_location('l_cost_allocation_keyflex_id:'|| l_cost_allocation_keyflex_id, 10);
1078: hr_utility.set_location('l_flex_num:'|| l_flex_num, 10);
1079: hr_utility.set_location('l_concat_segments:'|| l_concat_segments, 10);
1080:
1081:
1082: l_cost_allocation_keyflex_id :=
1083: hr_entry.maintain_cost_keyflex(

Line 1125: hr_utility.set_location('Entering Update API', 20);

1121: --
1122: -- end of bug no. 3829293
1123: --
1124: --
1125: hr_utility.set_location('Entering Update API', 20);
1126: hr_utility.set_location('l_cost_allocation_keyflex_id:'|| l_cost_allocation_keyflex_id, 20);
1127: -- Process Logic
1128: --
1129: pay_cal_upd.upd

Line 1126: hr_utility.set_location('l_cost_allocation_keyflex_id:'|| l_cost_allocation_keyflex_id, 20);

1122: -- end of bug no. 3829293
1123: --
1124: --
1125: hr_utility.set_location('Entering Update API', 20);
1126: hr_utility.set_location('l_cost_allocation_keyflex_id:'|| l_cost_allocation_keyflex_id, 20);
1127: -- Process Logic
1128: --
1129: pay_cal_upd.upd
1130: (p_effective_date => l_effective_date

Line 1215: hr_utility.set_location(' Leaving:'||l_proc, 70);

1211: p_effective_end_date := l_effective_end_date;
1212: p_cost_allocation_keyflex_id := l_cost_allocation_keyflex_id;
1213: p_object_version_number := l_object_version_number;
1214: --
1215: hr_utility.set_location(' Leaving:'||l_proc, 70);
1216: exception
1217: when hr_api.validate_enabled then
1218: --
1219: -- As the Validate_Enabled exception has been raised

Line 1233: hr_utility.set_location(' Leaving:'||l_proc, 80);

1229: p_effective_start_date := null;
1230: p_effective_end_date := null;
1231: p_cost_allocation_keyflex_id := null;
1232: p_object_version_number := p_object_version_number;
1233: hr_utility.set_location(' Leaving:'||l_proc, 80);
1234: when others then
1235: --
1236: -- A validation or unexpected error has occured
1237: --

Line 1248: hr_utility.set_location(' Leaving:'||l_proc, 90);

1244: p_effective_end_date := null;
1245: p_cost_allocation_keyflex_id := null;
1246: p_object_version_number := l_object_version_number;
1247: --
1248: hr_utility.set_location(' Leaving:'||l_proc, 90);
1249: raise;
1250: end UPDATE_COST_ALLOCATION;
1251: --
1252: -- ----------------------------------------------------------------------------

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

1271: l_effective_start_date pay_cost_allocations_f.effective_start_date%TYPE;
1272: l_effective_end_date pay_cost_allocations_f.effective_end_date%TYPE;
1273: --
1274: begin
1275: hr_utility.set_location('Entering:'|| l_proc, 10);
1276: --
1277: -- Issue a savepoint
1278: --
1279: savepoint DELETE_COST_ALLOCATION;

Line 1348: hr_utility.set_location(' Leaving:'||l_proc, 70);

1344: p_effective_start_date := l_effective_start_date;
1345: p_effective_end_date := l_effective_end_date;
1346: p_object_version_number := l_object_version_number;
1347: --
1348: hr_utility.set_location(' Leaving:'||l_proc, 70);
1349: exception
1350: when hr_api.validate_enabled then
1351: --
1352: -- As the Validate_Enabled exception has been raised

Line 1364: hr_utility.set_location(' Leaving:'||l_proc, 80);

1360: --
1361: p_effective_start_date := null;
1362: p_effective_end_date := null;
1363: p_object_version_number := p_object_version_number;
1364: hr_utility.set_location(' Leaving:'||l_proc, 80);
1365: when others then
1366: --
1367: -- A validation or unexpected error has occured
1368: --

Line 1377: hr_utility.set_location(' Leaving:'||l_proc, 90);

1373: p_effective_start_date := null;
1374: p_effective_end_date := null;
1375: p_object_version_number := l_object_version_number;
1376: --
1377: hr_utility.set_location(' Leaving:'||l_proc, 90);
1378: raise;
1379: end DELETE_COST_ALLOCATION;
1380: --
1381: end PAY_COST_ALLOCATION_API;