DBA Data[Home] [Help]

APPS.HR_SCH_ELIG_OBJ_PKG dependencies on HR_UTILITY

Line 30: hr_utility.trace('Entering '||g_module||l_routine);

26: --
27: BEGIN
28: --
29: l_routine := 'create_sch_elig_obj';
30: hr_utility.trace('Entering '||g_module||l_routine);
31: --
32: l_bg_id := hr_general.get_business_group_id();
33: l_sch_id := wf_event.getvalueforparameter ('SCHEDULE_ID',p_event.parameter_list);
34: l_sch_start_date := TO_DATE(wf_event.getvalueforparameter ('SCHEDULE_START_DATE',p_event.parameter_list),'MM/DD/RRRR');

Line 37: hr_utility.trace('BGId '||l_bg_id||' SchId '||l_sch_id);

33: l_sch_id := wf_event.getvalueforparameter ('SCHEDULE_ID',p_event.parameter_list);
34: l_sch_start_date := TO_DATE(wf_event.getvalueforparameter ('SCHEDULE_START_DATE',p_event.parameter_list),'MM/DD/RRRR');
35: l_obj_start_date := hr_api.g_sot;
36: --
37: hr_utility.trace('BGId '||l_bg_id||' SchId '||l_sch_id);
38: --
39: IF l_bg_id IS NOT NULL AND l_sch_id IS NOT NULL THEN
40: -- Create Eligibility Object
41: ben_elig_obj_api.create_elig_obj

Line 54: hr_utility.trace('EligObjId '||l_elig_obj_id);

50: ,p_object_version_number => l_ovn
51: );
52: l_ret_mode := 'SUCCESS';
53: --
54: hr_utility.trace('EligObjId '||l_elig_obj_id);
55: --
56: ELSE
57: wf_core.context (g_module,
58: l_routine,

Line 66: hr_utility.trace('Leaving '||g_module||l_routine);

62: wf_event.seterrorinfo (p_event, 'WARNING');
63: l_ret_mode := 'WARNING';
64: END IF;
65: --
66: hr_utility.trace('Leaving '||g_module||l_routine);
67: --
68: RETURN l_ret_mode;
69: --
70: EXCEPTION

Line 72: hr_utility.trace('Leaving in Error '||g_module||l_routine);

68: RETURN l_ret_mode;
69: --
70: EXCEPTION
71: WHEN OTHERS THEN
72: hr_utility.trace('Leaving in Error '||g_module||l_routine);
73: wf_core.context ('hr_sch_elig_obj_pkg',
74: 'create_sch_elig_obj',
75: p_event.event_name,
76: p_subscription_guid

Line 119: hr_utility.trace('Entering '||g_module||l_routine);

115: --
116: BEGIN
117: --
118: l_routine := 'delete_sch_elig_obj';
119: hr_utility.trace('Entering '||g_module||l_routine);
120: --
121: l_bg_id := hr_general.get_business_group_id();
122: l_sch_id := wf_event.getvalueforparameter ('SCHEDULE_ID',p_event.parameter_list);
123: l_sch_start_date := TO_DATE(wf_event.getvalueforparameter ('SCHEDULE_START_DATE',p_event.parameter_list),'MM/DD/RRRR');

Line 125: hr_utility.trace('BGId '||l_bg_id||' SchId '||l_sch_id);

121: l_bg_id := hr_general.get_business_group_id();
122: l_sch_id := wf_event.getvalueforparameter ('SCHEDULE_ID',p_event.parameter_list);
123: l_sch_start_date := TO_DATE(wf_event.getvalueforparameter ('SCHEDULE_START_DATE',p_event.parameter_list),'MM/DD/RRRR');
124: --
125: hr_utility.trace('BGId '||l_bg_id||' SchId '||l_sch_id);
126: --
127: l_mode := 'DELETE';
128: --
129: OPEN c_elig_obj (l_bg_id

Line 150: hr_utility.trace('EligObjId '||l_elig_obj_id);

146: );
147: --
148: l_ret_mode := 'SUCCESS';
149: --
150: hr_utility.trace('EligObjId '||l_elig_obj_id);
151: --
152: ELSE
153: wf_core.context (g_module,
154: l_routine,

Line 162: hr_utility.trace('Leaving '||g_module||l_routine);

158: wf_event.seterrorinfo (p_event, 'WARNING');
159: l_ret_mode := 'WARNING';
160: END IF;
161: --
162: hr_utility.trace('Leaving '||g_module||l_routine);
163: --
164: RETURN l_ret_mode;
165: --
166: EXCEPTION

Line 168: hr_utility.trace('Leaving in Error '||g_module||l_routine);

164: RETURN l_ret_mode;
165: --
166: EXCEPTION
167: WHEN OTHERS THEN
168: hr_utility.trace('Leaving in Error '||g_module||l_routine);
169: wf_core.context (g_module,
170: l_routine,
171: p_event.event_name,
172: p_subscription_guid