[Home] [Help]
67: exception
68: when app_exception.application_exception then
69: if hr_multi_message.exception_add
70: (p_associated_column1 => 'RULE_TYPE') then
71: hr_utility.set_location(' Leaving:'|| l_proc, 50);
72: raise;
73: end if;
74: hr_utility.set_location(' Leaving:'|| l_proc, 60);
75: return(null);
70: (p_associated_column1 => 'RULE_TYPE') then
71: hr_utility.set_location(' Leaving:'|| l_proc, 50);
72: raise;
73: end if;
74: hr_utility.set_location(' Leaving:'|| l_proc, 60);
75: return(null);
76: end getNextConditionKey;
77: --
78: -- ----------------------------------------------------------------------------
83: --
84: l_proc varchar2(72) := g_package||'set_base_key_value';
85: --
86: Begin
87: hr_utility.set_location('Entering:'||l_proc, 10);
88: --
89: ame_con_ins.g_condition_id_i := p_condition_id;
90: --
91: hr_utility.set_location(' Leaving:'||l_proc, 20);
87: hr_utility.set_location('Entering:'||l_proc, 10);
88: --
89: ame_con_ins.g_condition_id_i := p_condition_id;
90: --
91: hr_utility.set_location(' Leaving:'||l_proc, 20);
92: End set_base_key_value;
93: --
94: --
95: -- ----------------------------------------------------------------------------
172: l_current_user_id integer;
173: l_temp_count integer;
174: --
175: Begin
176: hr_utility.set_location('Entering:'||l_proc, 5);
177: --
178: -- Set the effective start and end dates to the corresponding
179: -- validation start and end dates
180: --
185: -- If the datetrack_mode is not INSERT then we must populate the WHO
186: -- columns with the 'old' creation values and 'new' updated values.
187: --
188: If (p_datetrack_mode <> hr_api.g_insert) then
189: hr_utility.set_location(l_proc, 10);
190: --
191: -- Get the object version number for the insert
192: --
193: p_rec.object_version_number :=
289: ,l_last_update_login
290: );
291: --
292: --
293: hr_utility.set_location(' Leaving:'||l_proc, 15);
294: --
295: Exception
296: When hr_api.check_integrity_violated Then
297: -- A check constraint has been violated
321: --
322: l_proc varchar2(72) := g_package||'insert_dml';
323: --
324: Begin
325: hr_utility.set_location('Entering:'||l_proc, 5);
326: --
327: ame_con_ins.dt_insert_dml
328: (p_rec => p_rec
329: ,p_effective_date => p_effective_date
331: ,p_validation_start_date => p_validation_start_date
332: ,p_validation_end_date => p_validation_end_date
333: );
334: --
335: hr_utility.set_location(' Leaving:'||l_proc, 10);
336: End insert_dml;
337: --
338: -- ----------------------------------------------------------------------------
339: -- |------------------------------< pre_insert >------------------------------|
395: l_proc varchar2(72) := g_package||'pre_insert';
396: l_exists varchar2(1);
397: --
398: Begin
399: hr_utility.set_location('Entering:'||l_proc, 5);
400: --
401: If (ame_con_ins.g_condition_id_i is not null) Then
402: --
403: -- Verify registered primary key values not already in use
435: --
436: p_rec.condition_key := getNextConditionKey(p_condition_key => p_rec.condition_key);
437: --
438: --
439: hr_utility.set_location(' Leaving:'||l_proc, 10);
440: End pre_insert;
441: --
442: -- ----------------------------------------------------------------------------
443: -- |----------------------------< post_insert >-------------------------------|
481: --
482: l_proc varchar2(72) := g_package||'post_insert';
483: --
484: Begin
485: hr_utility.set_location('Entering:'||l_proc, 5);
486: begin
487: --
488: ame_con_rki.after_insert
489: (p_effective_date
529: ,p_hook_type => 'AI');
530: --
531: end;
532: --
533: hr_utility.set_location(' Leaving:'||l_proc, 10);
534: End post_insert;
535: --
536: -- ----------------------------------------------------------------------------
537: -- |-------------------------------< ins_lck >--------------------------------|
581: l_validation_start_date date;
582: l_validation_end_date date;
583: --
584: Begin
585: hr_utility.set_location('Entering:'||l_proc, 5);
586: --
587: -- Validate the datetrack mode mode getting the validation start
588: -- and end dates for the specified datetrack operation.
589: --
595: -- MURTHY_CHANGES
596: p_validation_start_date := sysdate;
597: p_validation_end_date := ame_utility_pkg.endOfTime;
598: --
599: hr_utility.set_location(' Leaving:'||l_proc, 10);
600: --
601: End ins_lck;
602: --
603: -- ----------------------------------------------------------------------------
613: l_validation_start_date date;
614: l_validation_end_date date;
615: --
616: Begin
617: hr_utility.set_location('Entering:'||l_proc, 5);
618: --
619: -- Set the Attribute_id for LM Conditions
620: --
621: if(p_rec.condition_type = ame_util.listModConditionType) then
677: --
678: -- Call to raise any errors on multi-message list
679: hr_multi_message.end_validation_set;
680: --
681: hr_utility.set_location('Leaving:'||l_proc,10);
682: end ins;
683: --
684: -- ----------------------------------------------------------------------------
685: -- |---------------------------------< ins >----------------------------------|
704: l_rec ame_con_shd.g_rec_type;
705: l_proc varchar2(72) := g_package||'ins';
706: --
707: Begin
708: hr_utility.set_location('Entering:'||l_proc, 5);
709: --
710: -- Call conversion function to turn arguments into the
711: -- p_rec structure.
712: --
743: p_end_date := l_rec.end_date;
744: p_object_version_number := l_rec.object_version_number;
745: --
746: --
747: hr_utility.set_location(' Leaving:'||l_proc, 10);
748: End ins;
749: --
750: end ame_con_ins;