DBA Data[Home] [Help]

APPS.PER_PER_INS 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: per_per_ins.g_person_id_i := p_person_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: per_per_ins.g_person_id_i := p_person_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --
31: --
32:

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

112: --
113: l_person per_all_people_f%rowtype;
114: --
115: Begin
116: hr_utility.set_location('Entering:'||l_proc, 5);
117: --
118: -- Get the object version number for the insert
119: --
120: p_rec.object_version_number :=

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

132: -- If the datetrack_mode is not INSERT then we must populate the WHO
133: -- columns with the 'old' creation values and 'new' updated values.
134: --
135: If (p_datetrack_mode <> 'INSERT') then
136: hr_utility.set_location(l_proc, 10);
137: --
138: -- Select the 'old' created values
139: --
140: Open C_Sel1;

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

144: -- The previous 'old' created row has not been found. We need
145: -- to error as an internal datetrack problem exists.
146: --
147: Close C_Sel1;
148: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
149: hr_utility.set_message_token('PROCEDURE', l_proc);
150: hr_utility.set_message_token('STEP','10');
151: hr_utility.raise_error;
152: End If;

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

145: -- to error as an internal datetrack problem exists.
146: --
147: Close C_Sel1;
148: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
149: hr_utility.set_message_token('PROCEDURE', l_proc);
150: hr_utility.set_message_token('STEP','10');
151: hr_utility.raise_error;
152: End If;
153: Close C_Sel1;

Line 150: hr_utility.set_message_token('STEP','10');

146: --
147: Close C_Sel1;
148: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
149: hr_utility.set_message_token('PROCEDURE', l_proc);
150: hr_utility.set_message_token('STEP','10');
151: hr_utility.raise_error;
152: End If;
153: Close C_Sel1;
154: --

Line 151: hr_utility.raise_error;

147: Close C_Sel1;
148: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
149: hr_utility.set_message_token('PROCEDURE', l_proc);
150: hr_utility.set_message_token('STEP','10');
151: hr_utility.raise_error;
152: End If;
153: Close C_Sel1;
154: --
155: -- Set the AOL updated WHO values

Line 475: hr_utility.set_location('Select last created record',10);

471: l_last_updated_by,
472: l_last_update_login
473: );
474: --
475: hr_utility.set_location('Select last created record',10);
476: --
477: -- Now we need to get the personwho was created or updated and pass that
478: -- info to TCA for synchronization across business groups or possible
479: -- creation through TCA.

Line 495: hr_utility.set_location('Updating party id',10);

491: this is handled in per_person_type_usage_internal.maintain_person_type_usag
492: --
493: per_hrtca_merge.create_tca_person(p_rec => l_person);
494: --
495: hr_utility.set_location('Updating party id',10);
496: --
497: -- Now assign the resulting party id back to the record.
498: --
499: -- WWBUG 2450297.

Line 511: hr_utility.set_location('Updating party id',10);

507: else
508: --
509: per_hrtca_merge.update_tca_person(p_rec => l_person);
510: --
511: hr_utility.set_location('Updating party id',10);
512: --
513: end if;
514: --
515: per_per_shd.g_api_dml := false; -- Unset the api dml status

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

512: --
513: end if;
514: --
515: per_per_shd.g_api_dml := false; -- Unset the api dml status
516: hr_utility.set_location(' Leaving:'||l_proc, 15);
517: --
518: Exception
519: When hr_api.check_integrity_violated Then
520: -- A check constraint has been violated

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

543: --
544: l_proc varchar2(72) := g_package||'insert_dml';
545: --
546: Begin
547: hr_utility.set_location('Entering:'||l_proc, 5);
548: --
549: dt_insert_dml(p_rec => p_rec,
550: p_effective_date => p_effective_date,
551: p_datetrack_mode => p_datetrack_mode,

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

551: p_datetrack_mode => p_datetrack_mode,
552: p_validation_start_date => p_validation_start_date,
553: p_validation_end_date => p_validation_end_date);
554: --
555: hr_utility.set_location(' Leaving:'||l_proc, 10);
556: End insert_dml;
557: --
558: -- ----------------------------------------------------------------------------
559: -- |------------------------------< pre_insert >------------------------------|

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

612: where person_id =
613: per_per_ins.g_person_id_i;
614: --
615: Begin
616: hr_utility.set_location('Entering:'||l_proc, 5);
617: --
618: --
619: -- Select the next sequence number
620: --

Line 654: hr_utility.set_location(l_proc,7);

650: --
651: -- Insert the comment text if comments exist
652: --
653: If (p_rec.comments is not null) then
654: hr_utility.set_location(l_proc,7);
655: hr_comm_api.ins(p_comment_id => p_rec.comment_id,
656: p_source_table_name => 'per_all_people_f',
657: p_comment_text => p_rec.comments);
658: End If;

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

655: hr_comm_api.ins(p_comment_id => p_rec.comment_id,
656: p_source_table_name => 'per_all_people_f',
657: p_comment_text => p_rec.comments);
658: End If;
659: hr_utility.set_location(' Leaving:'||l_proc, 10);
660: --
661: End pre_insert;
662: --
663: -- ----------------------------------------------------------------------------

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

712: and effective_end_date = p_rec.effective_end_date;
713: l_per_rec per_all_people_f%rowtype;
714: --
715: Begin
716: hr_utility.set_location('Entering:'||l_proc, 5);
717: --
718: ben_dt_trgr_handle.person
719: (p_rowid => null
720: ,p_business_group_id => p_rec.business_group_id

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

945: p_action => 'INSERT');
946: --
947: -- End HR/WF Synchronization
948: --
949: hr_utility.set_location(' Leaving:'||l_proc, 10);
950: End post_insert;
951: --
952: -- ----------------------------------------------------------------------------
953: -- |-------------------------------< ins_lck >--------------------------------|

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

997: l_validation_start_date date;
998: l_validation_end_date date;
999: --
1000: Begin
1001: hr_utility.set_location('Entering:'||l_proc, 5);
1002: --
1003: -- Validate the datetrack mode mode getting the validation start
1004: -- and end dates for the specified datetrack operation.
1005: --

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

1017: --
1018: p_validation_start_date := l_validation_start_date;
1019: p_validation_end_date := l_validation_end_date;
1020: --
1021: hr_utility.set_location(' Leaving:'||l_proc, 10);
1022: --
1023: End ins_lck;
1024: --
1025: -- ----------------------------------------------------------------------------

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

1054: l_c1 c1%rowtype;
1055: --
1056: --
1057: Begin
1058: hr_utility.set_location('Entering:'||l_proc, 5);
1059: --
1060: -- Determine if the business process is to be validated.
1061: --
1062: -- For HR/TCA Merge we have to deafult certain parameters for cases where

Line 1238: hr_utility.set_location(l_proc,997);

1234: p_dob_null_warning := l_dob_null_warning;
1235: p_orig_hire_warning := l_orig_hire_warning;
1236: --
1237: if l_orig_hire_warning = FALSE then
1238: hr_utility.set_location(l_proc,997);
1239: elsif l_orig_hire_warning = TRUE then
1240: hr_utility.set_location(l_proc,998);
1241: else
1242: hr_utility.set_location(l_proc,999);

Line 1240: hr_utility.set_location(l_proc,998);

1236: --
1237: if l_orig_hire_warning = FALSE then
1238: hr_utility.set_location(l_proc,997);
1239: elsif l_orig_hire_warning = TRUE then
1240: hr_utility.set_location(l_proc,998);
1241: else
1242: hr_utility.set_location(l_proc,999);
1243: end if;
1244: --

Line 1242: hr_utility.set_location(l_proc,999);

1238: hr_utility.set_location(l_proc,997);
1239: elsif l_orig_hire_warning = TRUE then
1240: hr_utility.set_location(l_proc,998);
1241: else
1242: hr_utility.set_location(l_proc,999);
1243: end if;
1244: --
1245: hr_utility.set_location(' Leaving:'||l_proc, 10);
1246: Exception

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

1241: else
1242: hr_utility.set_location(l_proc,999);
1243: end if;
1244: --
1245: hr_utility.set_location(' Leaving:'||l_proc, 10);
1246: Exception
1247: When HR_Api.Validate_Enabled Then
1248: --
1249: -- As the Validate_Enabled exception has been raised

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

1414: l_rec per_per_shd.g_rec_type;
1415: l_proc varchar2(72) := g_package||'ins';
1416: --
1417: Begin
1418: hr_utility.set_location('Entering:'||l_proc, 5);
1419: --
1420: -- Call conversion function to turn arguments into the
1421: -- p_rec structure.
1422: --

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

1595: p_current_employee_flag := l_rec.current_employee_flag;
1596: p_full_name := l_rec.full_name;
1597: p_npw_number := l_rec.npw_number;
1598: --
1599: hr_utility.set_location(' Leaving:'||l_proc, 10);
1600: End ins;
1601: --
1602: end per_per_ins;