APPS.PQH_PTX_INS dependencies on HR_UTILITY

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

48: --
49: l_proc varchar2(72) := g_package||'insert_dml';
50: --
51: Begin
52: hr_utility.set_location('Entering:'||l_proc, 5);
53: p_rec.object_version_number := 1; -- Initialise the object version
54: --
55: --
56: -- Insert the row into: pqh_position_transactions

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

344: p_rec.wf_transaction_category_id
345: );
346: --
347: --
348: hr_utility.set_location(' Leaving:'||l_proc, 10);
349: Exception
350: When hr_api.check_integrity_violated Then
351: -- A check constraint has been violated
352: pqh_ptx_shd.constraint_error

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

406: --
407: Cursor C_Sel1 is select pqh_position_transactions_s.nextval from sys.dual;
408: --
409: Begin
410: hr_utility.set_location('Entering:'||l_proc, 5);
411: --
412: --
413: -- Select the next sequence number
414: --

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

415: Open C_Sel1;
416: Fetch C_Sel1 Into p_rec.position_transaction_id;
417: Close C_Sel1;
418: --
419: hr_utility.set_location(' Leaving:'||l_proc, 10);
420: End pre_insert;
421: --
422: -- ----------------------------------------------------------------------------
423: -- |-----------------------------< post_insert >------------------------------|

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

476: where position_id = p_position_id
477: and p_effective_date between effective_start_date and effective_end_date;
478: --
479: Begin
480: hr_utility.set_location('Entering:'||l_proc, 5);
481: --
482: if p_rec.position_id is not null then
483: open c_review_flag(p_rec.position_id);
484: fetch c_review_flag into l_review_flag;

Line 491: hr_utility.set_message(8302, 'PQH_POSITION_UNDER_REVIEW');

487: -- if (nvl(p_rec.review_flag,'N') = 'Y' and nvl(l_review_flag,'N') = 'Y'
488: -- and nvl(pqh_ptx_shd.g_old_rec.review_flag,'N') = 'N')then
489:
490: if ( nvl(l_review_flag,'N') = 'Y')then
491: hr_utility.set_message(8302, 'PQH_POSITION_UNDER_REVIEW');
492: hr_utility.raise_error;
493: /* Bug 6524175 Changes
494: elsif ((nvl(p_rec.review_flag,'N') = 'Y' and nvl(l_review_flag,'N') = 'N'))then */
495: --

Line 492: hr_utility.raise_error;

488: -- and nvl(pqh_ptx_shd.g_old_rec.review_flag,'N') = 'N')then
489:
490: if ( nvl(l_review_flag,'N') = 'Y')then
491: hr_utility.set_message(8302, 'PQH_POSITION_UNDER_REVIEW');
492: hr_utility.raise_error;
493: /* Bug 6524175 Changes
494: elsif ((nvl(p_rec.review_flag,'N') = 'Y' and nvl(l_review_flag,'N') = 'N'))then */
495: --
496: else

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

678: --
679: -- End of API User Hook for post_insert.
680: --
681: --
682: hr_utility.set_location(' Leaving:'||l_proc, 10);
683: End post_insert;
684: --
685: -- ----------------------------------------------------------------------------
686: -- |---------------------------------< ins >----------------------------------|

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

693: --
694: l_proc varchar2(72) := g_package||'ins';
695: --
696: Begin
697: hr_utility.set_location('Entering:'||l_proc, 5);
698: --
699: -- Call the supporting insert validate operations
700: --
701: pqh_ptx_bus.insert_validate(p_rec

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

868: l_rec pqh_ptx_shd.g_rec_type;
869: l_proc varchar2(72) := g_package||'ins';
870: --
871: Begin
872: hr_utility.set_location('Entering:'||l_proc, 5);
873: --
874: -- Call conversion function to turn arguments into the
875: -- p_rec structure.
876: --

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

1032: --
1033: p_position_transaction_id := l_rec.position_transaction_id;
1034: p_object_version_number := l_rec.object_version_number;
1035: --
1036: hr_utility.set_location(' Leaving:'||l_proc, 10);
1037: End ins;
1038: --
1039: end pqh_ptx_ins;