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

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

90: l_exists varchar2(30);
91: l_proc varchar2(72) :=g_package||'update_cost_concat_segs_auto';
92: --
93: begin
94: hr_utility.set_location('Entering:'|| l_proc, 10);
95: --
96: -- The outer procedure has already establish that an update is
97: -- required. This sub-procedure uses an autonomous transaction
98: -- to ensure that any commits do not impact the main transaction.

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

111: open csr_cost_lock;
112: fetch csr_cost_lock into l_exists;
113: if csr_cost_lock%found then
114: close csr_cost_lock;
115: hr_utility.set_location(l_proc, 20);
116: --
117: -- Lock obtained by this transaction, updating the concatenated
118: -- segment string should be performed.
119: --

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

134: else
135: close csr_cost_lock;
136: end if;
137: --
138: hr_utility.set_location('Leaving:'|| l_proc, 30);
139: Exception
140: When HR_Api.Object_Locked then
141: --
142: -- This autonomous transaction was unable to lock the row.

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

143: -- It can be assumed that another transaction has locked the
144: -- row and is performing the update. Hence the error can
145: -- be suppressed without raising it to the end user.
146: --
147: hr_utility.set_location('Leaving:'|| l_proc, 40);
148: end update_cost_concat_segs_auto;
149: begin
150: hr_utility.set_location('Entering:'|| l_proc, 10);
151: --

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

146: --
147: hr_utility.set_location('Leaving:'|| l_proc, 40);
148: end update_cost_concat_segs_auto;
149: begin
150: hr_utility.set_location('Entering:'|| l_proc, 10);
151: --
152: -- First find out if it is necessary to update the concatenated
153: -- segment string column. This select is being done to avoid the
154: -- performance unnecessary overhead of set-up an autonomous

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

167: else
168: close csr_chk_cost;
169: end if;
170: --
171: hr_utility.set_location('Leaving:'|| l_proc, 40);
172: --
173: end update_cost_concat_segs;
174:
175:

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

235: l_exists varchar2(30);
236: l_proc varchar2(72) :=g_package||'update_soft_concat_segs_auto';
237: --
238: begin
239: hr_utility.set_location('Entering:'|| l_proc, 10);
240: --
241: -- The outer procedure has already establish that an update is
242: -- required. This sub-procedure uses an autonomous transaction
243: -- to ensure that any commits do not impact the main transaction.

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

256: open csr_soft_lock;
257: fetch csr_soft_lock into l_exists;
258: if csr_soft_lock%found then
259: close csr_soft_lock;
260: hr_utility.set_location(l_proc, 20);
261: --
262: -- Lock obtained by this transaction, updating the concatenated
263: -- segment string should be performed.
264: --

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

279: else
280: close csr_soft_lock;
281: end if;
282: --
283: hr_utility.set_location('Leaving:'|| l_proc, 30);
284: Exception
285: When HR_Api.Object_Locked then
286: --
287: -- This autonomous transaction was unable to lock the row.

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

288: -- It can be assumed that another transaction has locked the
289: -- row and is performing the update. Hence the error can
290: -- be suppressed without raising it to the end user.
291: --
292: hr_utility.set_location('Leaving:'|| l_proc, 40);
293: end update_soft_concat_segs_auto;
294: begin
295: hr_utility.set_location('Entering:'|| l_proc, 10);
296: --

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

291: --
292: hr_utility.set_location('Leaving:'|| l_proc, 40);
293: end update_soft_concat_segs_auto;
294: begin
295: hr_utility.set_location('Entering:'|| l_proc, 10);
296: --
297: -- First find out if it is necessary to update the concatenated
298: -- segment string column. This select is being done to avoid the
299: -- performance unnecessary overhead of set-up an autonomous

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

312: else
313: close csr_chk_soft;
314: end if;
315: --
316: hr_utility.set_location('Leaving:'|| l_proc, 40);
317: --
318: end update_soft_concat_segs;
319:
320: procedure create_payroll

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

580: where scl.soft_coding_keyflex_id = c_soft_coding_keyflex_id;
581:
582: begin
583:
584: hr_utility.set_location(' Entering:'||l_proc, 10);
585:
586: --Truncate the time component from the date field.
587:
588: l_effective_date := trunc(p_effective_date);

Line 1202: hr_utility.set_location(l_proc, 90);

1198: --pay_org_payment_methods_f table.
1199:
1200: if(p_default_payment_method_id is not null) then
1201: --
1202: hr_utility.set_location(l_proc, 90);
1203: l_org_pay_method_usage_id := hr_ppvol.ins_pmu(
1204: l_effective_start_date,
1205: l_effective_end_date,
1206: l_payroll_id,

Line 1213: hr_utility.trace('The value of p_cost_alloc_keyflex_id_in Before user-hook : '||p_cost_alloc_keyflex_id_in);

1209: end if;
1210:
1211: begin
1212: --
1213: hr_utility.trace('The value of p_cost_alloc_keyflex_id_in Before user-hook : '||p_cost_alloc_keyflex_id_in);
1214: pay_payroll_bk1.create_payroll_a
1215: (p_effective_date => l_effective_date
1216: ,p_payroll_name => p_payroll_name
1217: ,p_payroll_type => p_payroll_type

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

1422: end if;
1423: --
1424: -- Create time periods for the created payroll.
1425: --
1426: hr_utility.set_location(l_proc, 20);
1427: hr_payrolls.create_payroll_proc_periods(l_payroll_id,
1428: l_last_update_date,
1429: l_last_updated_by,
1430: l_last_update_login,

Line 1440: hr_utility.set_location(l_proc, 100);

1436: -- Note that we are returning dummy object version id values
1437: -- because we don't currently have these columns on these
1438: -- tables.
1439: --
1440: hr_utility.set_location(l_proc, 100);
1441:
1442: p_payroll_id := l_payroll_id;
1443: p_comment_id := l_comment_id;
1444: p_org_pay_method_usage_id := l_org_pay_method_usage_id;

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

1481: p_scl_concat_segments_out := l_scl_concat_segments;
1482: --
1483: end if;
1484: --
1485: hr_utility.set_location(' Leaving:'||l_proc, 70);
1486: --
1487: exception
1488: when hr_api.validate_enabled then
1489: --

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

1836: between prl.effective_start_date and prl.effective_end_date;
1837:
1838: begin
1839: --
1840: hr_utility.set_location(' Entering:'||l_proc, 10);
1841: --
1842: -- Truncate the date parameters.
1843: --
1844: l_effective_date := trunc(p_effective_date);

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

2739: close csr_get_softKFF;
2740: --
2741: end if;
2742: --
2743: hr_utility.set_location(' Leaving:'||l_proc, 70);
2744: exception
2745: when hr_api.validate_enabled then
2746: --
2747: -- Must remove all work done by this procedure.

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

2806:
2807: begin
2808: --
2809:
2810: hr_utility.set_location(' Entering:'||l_proc, 10);
2811:
2812: l_effective_date := trunc(p_effective_date);
2813: l_object_version_number := p_object_version_number;
2814:

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

2868: p_object_version_number := l_object_version_number;
2869: p_effective_start_date := l_effective_start_date;
2870: p_effective_end_date := l_effective_end_date;
2871:
2872: hr_utility.set_location(' Leaving:'||l_proc, 70);
2873:
2874: exception
2875: when hr_api.validate_enabled then
2876: --

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

3241: from PAY_ALL_PAYROLLS_F
3242: where payroll_id = p_payroll_id;
3243: begin
3244: --
3245: hr_utility.set_location('Entering:'||l_proc, 5);
3246: hr_utility.trace('p_effective_date : '||to_char(p_effective_date));
3247: --Get the business group id from the payroll id.
3248: if (p_consolidation_set_id = hr_api.g_number) then
3249: open csr_get_BG;

Line 3246: hr_utility.trace('p_effective_date : '||to_char(p_effective_date));

3242: where payroll_id = p_payroll_id;
3243: begin
3244: --
3245: hr_utility.set_location('Entering:'||l_proc, 5);
3246: hr_utility.trace('p_effective_date : '||to_char(p_effective_date));
3247: --Get the business group id from the payroll id.
3248: if (p_consolidation_set_id = hr_api.g_number) then
3249: open csr_get_BG;
3250: fetch csr_get_BG into l_business_group_id;

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

3354: p_prl_effective_start_date := l_prl_effective_start_date;
3355: p_prl_effective_end_date := l_prl_effective_end_date;
3356: p_comment_id := l_comment_id;
3357:
3358: hr_utility.set_location('Leaving:'||l_proc, 5);
3359: --
3360: end update_payroll;
3361: -- ----------------------------------------------------------------------------
3362: -- |---------------------------< lock_payroll >-------------------------------|

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

3380: l_validation_start_date date;
3381: l_validation_end_date date;
3382: --
3383: Begin
3384: hr_utility.set_location('Entering:'||l_proc, 5);
3385: pay_pay_shd.lck(
3386: p_effective_date
3387: ,p_datetrack_mode
3388: ,p_payroll_id

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

3403: --
3404: l_proc varchar2(72) := g_package||'set_base_key_value';
3405: --
3406: Begin
3407: hr_utility.set_location('Entering:'||l_proc, 10);
3408: --
3409: --g_payroll_id_i := p_payroll_id;
3410: pay_pay_ins.set_base_key_value(p_payroll_id);
3411: --

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

3408: --
3409: --g_payroll_id_i := p_payroll_id;
3410: pay_pay_ins.set_base_key_value(p_payroll_id);
3411: --
3412: hr_utility.set_location(' Leaving:'||l_proc, 20);
3413: End set_base_key_value;
3414: --
3415: -- ----------------------------------------------------------------------------
3416: -- |------------------------< return_api_dml_status >-------------------------|

Line 3435: hr_utility.trace('entered return_api_dml_status');

3431: Function return_api_dml_status Return Boolean Is
3432: --
3433: Begin
3434: --
3435: hr_utility.trace('entered return_api_dml_status');
3436: return pay_pay_shd.return_api_dml_status;
3437: --
3438: End return_api_dml_status;
3439: --