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

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

49: --
50: l_proc varchar2(72) := g_package||'update_dml';
51: --
52: Begin
53: hr_utility.set_location('Entering:'||l_proc, 5);
54: --
55: -- Increment the object version
56: --
57: p_rec.object_version_number := p_rec.object_version_number + 1;

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

205: wf_transaction_category_id = p_rec.wf_transaction_category_id
206: where position_transaction_id = p_rec.position_transaction_id;
207: --
208: --
209: hr_utility.set_location(' Leaving:'||l_proc, 10);
210: --
211: Exception
212: When hr_api.check_integrity_violated Then
213: -- A check constraint has been violated

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

261: --
262: l_proc varchar2(72) := g_package||'pre_update';
263: --
264: Begin
265: hr_utility.set_location('Entering:'||l_proc, 5);
266: --
267: hr_utility.set_location(' Leaving:'||l_proc, 10);
268: End pre_update;
269: --

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

263: --
264: Begin
265: hr_utility.set_location('Entering:'||l_proc, 5);
266: --
267: hr_utility.set_location(' Leaving:'||l_proc, 10);
268: End pre_update;
269: --
270: -- ----------------------------------------------------------------------------
271: -- |-----------------------------< post_update >------------------------------|

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

326: where position_id = p_position_id
327: and p_effective_date between effective_start_date and effective_end_date;
328: --
329: Begin
330: hr_utility.set_location('Entering:'||l_proc, 5);
331: --
332: if p_rec.position_id is not null then
333: open c_review_flag(p_rec.position_id);
334: fetch c_review_flag into l_review_flag;

Line 339: hr_utility.set_message(1802, 'PQH_POSITION_UNDER_REVIEW');

335: close c_review_flag;
336: --
337: if (nvl(p_rec.review_flag,'N') = 'Y' and nvl(l_review_flag,'N') = 'Y'
338: and nvl(pqh_ptx_shd.g_old_rec.review_flag,'N') = 'N')then
339: hr_utility.set_message(1802, 'PQH_POSITION_UNDER_REVIEW');
340: hr_utility.raise_error;
341: /* Bug 6524175 changes
342: elsif ((nvl(p_rec.review_flag,'N') = 'Y' and nvl(l_review_flag,'N') = 'N')
343: or (nvl(p_rec.review_flag,'N') = 'N' and nvl(l_review_flag,'N') = 'Y'))then */

Line 340: hr_utility.raise_error;

336: --
337: if (nvl(p_rec.review_flag,'N') = 'Y' and nvl(l_review_flag,'N') = 'Y'
338: and nvl(pqh_ptx_shd.g_old_rec.review_flag,'N') = 'N')then
339: hr_utility.set_message(1802, 'PQH_POSITION_UNDER_REVIEW');
340: hr_utility.raise_error;
341: /* Bug 6524175 changes
342: elsif ((nvl(p_rec.review_flag,'N') = 'Y' and nvl(l_review_flag,'N') = 'N')
343: or (nvl(p_rec.review_flag,'N') = 'N' and nvl(l_review_flag,'N') = 'Y'))then */
344: --

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

665: --
666: -- End of API User Hook for post_update.
667: --
668: --
669: hr_utility.set_location(' Leaving:'||l_proc, 10);
670: End post_update;
671: --
672: -- ----------------------------------------------------------------------------
673: -- |-----------------------------< convert_defs >-----------------------------|

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

717: l_proc varchar2(72) := g_package||'convert_defs';
718: --
719: Begin
720: --
721: hr_utility.set_location('Entering:'||l_proc, 5);
722: --
723: -- We must now examine each argument value in the
724: -- p_rec plsql record structure
725: -- to see if a system default is being used. If a system default

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

1286: pqh_ptx_shd.g_old_rec.wf_transaction_category_id;
1287: End If;
1288:
1289: --
1290: hr_utility.set_location(' Leaving:'||l_proc, 10);
1291: --
1292: End convert_defs;
1293: --
1294: -- ----------------------------------------------------------------------------

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

1302: --
1303: l_proc varchar2(72) := g_package||'upd';
1304: --
1305: Begin
1306: hr_utility.set_location('Entering:'||l_proc, 5);
1307: --
1308: -- We must lock the row which we need to update.
1309: --
1310: pqh_ptx_shd.lck

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

1490: l_rec pqh_ptx_shd.g_rec_type;
1491: l_proc varchar2(72) := g_package||'upd';
1492: --
1493: Begin
1494: hr_utility.set_location('Entering:'||l_proc, 5);
1495: --
1496: -- Call conversion function to turn arguments into the
1497: -- l_rec structure.
1498: --

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

1650: upd(
1651: p_effective_date,l_rec);
1652: p_object_version_number := l_rec.object_version_number;
1653: --
1654: hr_utility.set_location(' Leaving:'||l_proc, 10);
1655: End upd;
1656: --
1657: end pqh_ptx_upd;