DBA Data[Home] [Help]

APPS.PAY_ETP_INS_ND dependencies on HR_UTILITY

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

20: --
21: l_proc varchar2(72) := g_package||'set_base_key_value';
22: --
23: Begin
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: pay_etp_ins_nd.g_element_type_id_i := p_element_type_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: pay_etp_ins_nd.g_element_type_id_i := p_element_type_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --
31: --
32: -- ----------------------------------------------------------------------------

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

101: l_last_updated_by pay_element_types_f.last_updated_by%TYPE;
102: l_last_update_login pay_element_types_f.last_update_login%TYPE;
103: --
104: Begin
105: hr_utility.set_location('Entering:'||l_proc, 5);
106: --
107: -- Get the object version number for the insert
108: --
109: p_rec.object_version_number :=

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

122: -- If the datetrack_mode is not INSERT then we must populate the WHO
123: -- columns with the 'old' creation values and 'new' updated values.
124: --
125: If (p_datetrack_mode <> hr_api.g_insert) then
126: hr_utility.set_location(l_proc, 10);
127: --
128: -- Select the 'old' created values
129: --
130: Open C_Sel1;

Line 352: hr_utility.set_location(' Leaving:'||l_proc, 15);

348: ,l_last_update_login
349: );
350: --
351: pay_etp_shd_nd.g_api_dml := false; -- Unset the api dml status
352: hr_utility.set_location(' Leaving:'||l_proc, 15);
353: --
354: Exception
355: When hr_api.check_integrity_violated Then
356: -- A check constraint has been violated

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

428: --
429: l_proc varchar2(72) := g_package||'insert_dml';
430: --
431: Begin
432: hr_utility.set_location('Entering:'||l_proc, 5);
433: --
434: pay_etp_ins_nd.dt_insert_dml
435: (p_rec => p_rec
436: ,p_effective_date => p_effective_date

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

438: ,p_validation_start_date => p_validation_start_date
439: ,p_validation_end_date => p_validation_end_date
440: );
441: --
442: hr_utility.set_location(' Leaving:'||l_proc, 10);
443: End insert_dml;
444: --
445: -- ----------------------------------------------------------------------------
446: -- |------------------------------< pre_insert >------------------------------|

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

500: l_proc varchar2(72) := g_package||'pre_insert';
501: l_exists varchar2(1);
502: --
503: Begin
504: hr_utility.set_location('Entering:'||l_proc, 5);
505: --
506: If (pay_etp_ins_nd.g_element_type_id_i is not null) Then
507: --
508: -- Verify registered primary key values not already in use

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

546: ,p_source_table_name => 'PAY_ELEMENT_TYPES_F'
547: ,p_comment_text => p_rec.comments
548: );
549: End If;
550: hr_utility.set_location(' Leaving:'||l_proc, 10);
551: End pre_insert;
552: --
553: -- ----------------------------------------------------------------------------
554: -- |----------------------------< post_insert >-------------------------------|

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

592: --
593: l_proc varchar2(72) := g_package||'post_insert';
594: --
595: Begin
596: hr_utility.set_location('Entering:'||l_proc, 5);
597: begin
598: --
599: -- insert ownerships if applicable
600: create_app_ownerships

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

806: ,p_hook_type => 'AI');
807: --
808: end;
809: --
810: hr_utility.set_location(' Leaving:'||l_proc, 10);
811: End post_insert;
812: --
813: -- ----------------------------------------------------------------------------
814: -- |-------------------------------< ins_lck >--------------------------------|

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

858: l_validation_start_date date;
859: l_validation_end_date date;
860: --
861: Begin
862: hr_utility.set_location('Entering:'||l_proc, 5);
863: --
864: -- Validate the datetrack mode mode getting the validation start
865: -- and end dates for the specified datetrack operation.
866: --

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

879: --
880: p_validation_start_date := l_validation_start_date;
881: p_validation_end_date := l_validation_end_date;
882: --
883: hr_utility.set_location(' Leaving:'||l_proc, 10);
884: --
885: End ins_lck;
886: --
887: -- ----------------------------------------------------------------------------

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

899: l_validation_end_date date;
900: l_processing_priority_warning boolean;
901: --
902: Begin
903: hr_utility.set_location('Entering:'||l_proc, 5);
904: --
905: -- Call the lock operation
906: --
907: pay_etp_ins_nd.ins_lck

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

960: --
961: -- Call to raise any errors on multi-message list
962: hr_multi_message.end_validation_set;
963: --
964: hr_utility.set_location('Leaving:'||l_proc,10);
965: end ins;
966: --
967: -- ----------------------------------------------------------------------------
968: -- |---------------------------------< ins >----------------------------------|

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

1067: l_proc varchar2(72) := g_package||'ins';
1068: l_processing_priority_warning boolean;
1069: --
1070: Begin
1071: hr_utility.set_location('Entering:'||l_proc, 5);
1072: --
1073: -- Call conversion function to turn arguments into the
1074: -- p_rec structure.
1075: --

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

1186: p_object_version_number := l_rec.object_version_number;
1187: p_comment_id := l_rec.comment_id;
1188: p_processing_priority_warning := l_processing_priority_warning;
1189: --
1190: hr_utility.set_location(' Leaving:'||l_proc, 10);
1191: End ins;
1192: --
1193: end pay_etp_ins_nd;