DBA Data[Home] [Help]

APPS.PER_SUCCESSION_PLAN_UTILITY dependencies on HR_UTILITY

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

37: p_effective_date in date default hr_api.g_date
38: ) IS
39: l_proc VARCHAR2(80) := g_package||'import_succession_plan';
40: BEGIN
41: hr_utility.set_location('Entering '||l_proc,10);
42: hr_utility.trace('p_succession_plan_id:'||p_succession_plan_id);
43: hr_utility.trace('p_person_id:'||p_person_id);
44: hr_utility.trace('p_position_id:'||p_position_id);
45: hr_utility.trace('p_business_group_id:'||p_business_group_id);

Line 42: hr_utility.trace('p_succession_plan_id:'||p_succession_plan_id);

38: ) IS
39: l_proc VARCHAR2(80) := g_package||'import_succession_plan';
40: BEGIN
41: hr_utility.set_location('Entering '||l_proc,10);
42: hr_utility.trace('p_succession_plan_id:'||p_succession_plan_id);
43: hr_utility.trace('p_person_id:'||p_person_id);
44: hr_utility.trace('p_position_id:'||p_position_id);
45: hr_utility.trace('p_business_group_id:'||p_business_group_id);
46: hr_utility.trace('p_object_versoin_number:'||p_object_version_number);

Line 43: hr_utility.trace('p_person_id:'||p_person_id);

39: l_proc VARCHAR2(80) := g_package||'import_succession_plan';
40: BEGIN
41: hr_utility.set_location('Entering '||l_proc,10);
42: hr_utility.trace('p_succession_plan_id:'||p_succession_plan_id);
43: hr_utility.trace('p_person_id:'||p_person_id);
44: hr_utility.trace('p_position_id:'||p_position_id);
45: hr_utility.trace('p_business_group_id:'||p_business_group_id);
46: hr_utility.trace('p_object_versoin_number:'||p_object_version_number);
47: hr_utility.trace('p_effective_date:'||to_char(p_effective_date,'dd-mm-yyyy'));

Line 44: hr_utility.trace('p_position_id:'||p_position_id);

40: BEGIN
41: hr_utility.set_location('Entering '||l_proc,10);
42: hr_utility.trace('p_succession_plan_id:'||p_succession_plan_id);
43: hr_utility.trace('p_person_id:'||p_person_id);
44: hr_utility.trace('p_position_id:'||p_position_id);
45: hr_utility.trace('p_business_group_id:'||p_business_group_id);
46: hr_utility.trace('p_object_versoin_number:'||p_object_version_number);
47: hr_utility.trace('p_effective_date:'||to_char(p_effective_date,'dd-mm-yyyy'));
48:

Line 45: hr_utility.trace('p_business_group_id:'||p_business_group_id);

41: hr_utility.set_location('Entering '||l_proc,10);
42: hr_utility.trace('p_succession_plan_id:'||p_succession_plan_id);
43: hr_utility.trace('p_person_id:'||p_person_id);
44: hr_utility.trace('p_position_id:'||p_position_id);
45: hr_utility.trace('p_business_group_id:'||p_business_group_id);
46: hr_utility.trace('p_object_versoin_number:'||p_object_version_number);
47: hr_utility.trace('p_effective_date:'||to_char(p_effective_date,'dd-mm-yyyy'));
48:
49: IF p_succession_plan_id IS NULL THEN

Line 46: hr_utility.trace('p_object_versoin_number:'||p_object_version_number);

42: hr_utility.trace('p_succession_plan_id:'||p_succession_plan_id);
43: hr_utility.trace('p_person_id:'||p_person_id);
44: hr_utility.trace('p_position_id:'||p_position_id);
45: hr_utility.trace('p_business_group_id:'||p_business_group_id);
46: hr_utility.trace('p_object_versoin_number:'||p_object_version_number);
47: hr_utility.trace('p_effective_date:'||to_char(p_effective_date,'dd-mm-yyyy'));
48:
49: IF p_succession_plan_id IS NULL THEN
50: hr_utility.set_location('INSERT Block '||l_proc,20);

Line 47: hr_utility.trace('p_effective_date:'||to_char(p_effective_date,'dd-mm-yyyy'));

43: hr_utility.trace('p_person_id:'||p_person_id);
44: hr_utility.trace('p_position_id:'||p_position_id);
45: hr_utility.trace('p_business_group_id:'||p_business_group_id);
46: hr_utility.trace('p_object_versoin_number:'||p_object_version_number);
47: hr_utility.trace('p_effective_date:'||to_char(p_effective_date,'dd-mm-yyyy'));
48:
49: IF p_succession_plan_id IS NULL THEN
50: hr_utility.set_location('INSERT Block '||l_proc,20);
51: per_suc_ins.ins(

Line 50: hr_utility.set_location('INSERT Block '||l_proc,20);

46: hr_utility.trace('p_object_versoin_number:'||p_object_version_number);
47: hr_utility.trace('p_effective_date:'||to_char(p_effective_date,'dd-mm-yyyy'));
48:
49: IF p_succession_plan_id IS NULL THEN
50: hr_utility.set_location('INSERT Block '||l_proc,20);
51: per_suc_ins.ins(
52: p_succession_plan_id => p_succession_plan_id
53: ,p_person_id => p_person_id
54: ,p_position_id => p_position_id

Line 84: hr_utility.set_location('INSERT Complete '||l_proc,30);

80: ,p_attribute18 => NULL
81: ,p_attribute19 => NULL
82: ,p_attribute20 => NULL
83: ,p_effective_date => TRUNC(SYSDATE));
84: hr_utility.set_location('INSERT Complete '||l_proc,30);
85: ELSE
86: hr_utility.set_location('UPDATE Block '||l_proc,40);
87: per_suc_upd.upd(
88: p_succession_plan_id => p_succession_plan_id

Line 86: hr_utility.set_location('UPDATE Block '||l_proc,40);

82: ,p_attribute20 => NULL
83: ,p_effective_date => TRUNC(SYSDATE));
84: hr_utility.set_location('INSERT Complete '||l_proc,30);
85: ELSE
86: hr_utility.set_location('UPDATE Block '||l_proc,40);
87: per_suc_upd.upd(
88: p_succession_plan_id => p_succession_plan_id
89: ,p_person_id => p_person_id
90: ,p_position_id => p_position_id

Line 120: hr_utility.set_location('UPDATE Complete '||l_proc,50);

116: ,p_attribute18 => NULL
117: ,p_attribute19 => NULL
118: ,p_attribute20 => NULL
119: ,p_effective_date => TRUNC(SYSDATE));
120: hr_utility.set_location('UPDATE Complete '||l_proc,50);
121: END IF;
122: hr_utility.set_location('Leaving '||l_proc,60);
123: EXCEPTION
124: WHEN OTHERS THEN

Line 122: hr_utility.set_location('Leaving '||l_proc,60);

118: ,p_attribute20 => NULL
119: ,p_effective_date => TRUNC(SYSDATE));
120: hr_utility.set_location('UPDATE Complete '||l_proc,50);
121: END IF;
122: hr_utility.set_location('Leaving '||l_proc,60);
123: EXCEPTION
124: WHEN OTHERS THEN
125: hr_utility.set_location('Error: '||l_proc,70);
126: RAISE;

Line 125: hr_utility.set_location('Error: '||l_proc,70);

121: END IF;
122: hr_utility.set_location('Leaving '||l_proc,60);
123: EXCEPTION
124: WHEN OTHERS THEN
125: hr_utility.set_location('Error: '||l_proc,70);
126: RAISE;
127: END import_succession_plan;
128: END per_succession_plan_utility;