eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_NL_ABSENCE_TRACK_PKG dependencies on HR_UTILITY

Line 59: hr_utility.set_location('Entering ' || l_proc, 100);

55:
56: l_setup_exists:= 'E';
57: l_actions_exists :='N';
58:
59: hr_utility.set_location('Entering ' || l_proc, 100);
60:
61:
62: --Fetch the Business Group Id and User Table Name
63: chk_Abs_Action_Setup_Exists

Line 70: hr_utility.set_location(' l_business_group_id : ' || l_business_group_id, 110);

66: l_date_start,l_setup_exists);
67:
68: p_return_status := l_setup_exists;
69:
70: hr_utility.set_location(' l_business_group_id : ' || l_business_group_id, 110);
71: hr_utility.set_location(' l_user_table_name ' || l_user_table_name, 120);
72: hr_utility.set_location(' l_date_start ' || l_date_start, 130);
73: hr_utility.set_location(' p_return_status ' || p_return_status, 140);
74:

Line 71: hr_utility.set_location(' l_user_table_name ' || l_user_table_name, 120);

67:
68: p_return_status := l_setup_exists;
69:
70: hr_utility.set_location(' l_business_group_id : ' || l_business_group_id, 110);
71: hr_utility.set_location(' l_user_table_name ' || l_user_table_name, 120);
72: hr_utility.set_location(' l_date_start ' || l_date_start, 130);
73: hr_utility.set_location(' p_return_status ' || p_return_status, 140);
74:
75:

Line 72: hr_utility.set_location(' l_date_start ' || l_date_start, 130);

68: p_return_status := l_setup_exists;
69:
70: hr_utility.set_location(' l_business_group_id : ' || l_business_group_id, 110);
71: hr_utility.set_location(' l_user_table_name ' || l_user_table_name, 120);
72: hr_utility.set_location(' l_date_start ' || l_date_start, 130);
73: hr_utility.set_location(' p_return_status ' || p_return_status, 140);
74:
75:
76: OPEN c_abs_actions;

Line 73: hr_utility.set_location(' p_return_status ' || p_return_status, 140);

69:
70: hr_utility.set_location(' l_business_group_id : ' || l_business_group_id, 110);
71: hr_utility.set_location(' l_user_table_name ' || l_user_table_name, 120);
72: hr_utility.set_location(' l_date_start ' || l_date_start, 130);
73: hr_utility.set_location(' p_return_status ' || p_return_status, 140);
74:
75:
76: OPEN c_abs_actions;
77: FETCH c_abs_actions INTO l_actions_exists;

Line 98: hr_utility.set_location('Abs Action Setup exists ' || l_setup_exists, 200);

94: --In Case User do not completely define the User Table
95: SAVEPOINT InvalidUDTSetup;
96:
97: IF l_setup_exists='S' AND l_actions_exists='N' THEN
98: hr_utility.set_location('Abs Action Setup exists ' || l_setup_exists, 200);
99:
100: --Fetch the Rows from the User Table
101: OPEN c_user_rows(l_business_group_id,l_user_table_name,l_date_start);
102: LOOP

Line 105: hr_utility.set_location('Fetching Action Rows ' || l_row_number, 210);

101: OPEN c_user_rows(l_business_group_id,l_user_table_name,l_date_start);
102: LOOP
103: FETCH c_user_rows INTO l_row_number;
104: EXIT WHEN c_user_rows%NOTFOUND;
105: hr_utility.set_location('Fetching Action Rows ' || l_row_number, 210);
106:
107: l_expected_date := null;
108: l_action := null;
109: l_time_period := null;

Line 140: hr_utility.set_location('Row Number ' || l_row_number, 220);

136: exit;
137: end if;
138:
139:
140: hr_utility.set_location('Row Number ' || l_row_number, 220);
141: hr_utility.set_location('Action ' || l_action, 230);
142: hr_utility.set_location('Time Period ' || l_time_period, 240);
143: hr_utility.set_location('Unit ' || l_units, 250);
144: hr_utility.set_location('Expected Date ' || l_expected_date, 260);

Line 141: hr_utility.set_location('Action ' || l_action, 230);

137: end if;
138:
139:
140: hr_utility.set_location('Row Number ' || l_row_number, 220);
141: hr_utility.set_location('Action ' || l_action, 230);
142: hr_utility.set_location('Time Period ' || l_time_period, 240);
143: hr_utility.set_location('Unit ' || l_units, 250);
144: hr_utility.set_location('Expected Date ' || l_expected_date, 260);
145:

Line 142: hr_utility.set_location('Time Period ' || l_time_period, 240);

138:
139:
140: hr_utility.set_location('Row Number ' || l_row_number, 220);
141: hr_utility.set_location('Action ' || l_action, 230);
142: hr_utility.set_location('Time Period ' || l_time_period, 240);
143: hr_utility.set_location('Unit ' || l_units, 250);
144: hr_utility.set_location('Expected Date ' || l_expected_date, 260);
145:
146: exception

Line 143: hr_utility.set_location('Unit ' || l_units, 250);

139:
140: hr_utility.set_location('Row Number ' || l_row_number, 220);
141: hr_utility.set_location('Action ' || l_action, 230);
142: hr_utility.set_location('Time Period ' || l_time_period, 240);
143: hr_utility.set_location('Unit ' || l_units, 250);
144: hr_utility.set_location('Expected Date ' || l_expected_date, 260);
145:
146: exception
147: when Others then

Line 144: hr_utility.set_location('Expected Date ' || l_expected_date, 260);

140: hr_utility.set_location('Row Number ' || l_row_number, 220);
141: hr_utility.set_location('Action ' || l_action, 230);
142: hr_utility.set_location('Time Period ' || l_time_period, 240);
143: hr_utility.set_location('Unit ' || l_units, 250);
144: hr_utility.set_location('Expected Date ' || l_expected_date, 260);
145:
146: exception
147: when Others then
148: p_return_status := 'E';

Line 149: hr_utility.set_location(' Others :' || SQLERRM(SQLCODE),900);

145:
146: exception
147: when Others then
148: p_return_status := 'E';
149: hr_utility.set_location(' Others :' || SQLERRM(SQLCODE),900);
150: exit;
151: end;
152: --Call the SWI Wrapper for Creating the Action
153: hr_nl_absence_action_swi.create_absence_action

Line 162: hr_utility.set_location('p_absence_action_id ' || l_absence_action_id, 910);

158: p_absence_action_id =>l_absence_action_id,
159: p_object_version_number =>l_object_version_number,
160: p_return_status =>p_return_status
161: ) ;
162: hr_utility.set_location('p_absence_action_id ' || l_absence_action_id, 910);
163: hr_utility.set_location('p_object_version_number ' || l_object_version_number, 920);
164: hr_utility.set_location('p_return_status ' || p_return_status, 930);
165:
166: if p_return_status<>'S' then

Line 163: hr_utility.set_location('p_object_version_number ' || l_object_version_number, 920);

159: p_object_version_number =>l_object_version_number,
160: p_return_status =>p_return_status
161: ) ;
162: hr_utility.set_location('p_absence_action_id ' || l_absence_action_id, 910);
163: hr_utility.set_location('p_object_version_number ' || l_object_version_number, 920);
164: hr_utility.set_location('p_return_status ' || p_return_status, 930);
165:
166: if p_return_status<>'S' then
167: exit;

Line 164: hr_utility.set_location('p_return_status ' || p_return_status, 930);

160: p_return_status =>p_return_status
161: ) ;
162: hr_utility.set_location('p_absence_action_id ' || l_absence_action_id, 910);
163: hr_utility.set_location('p_object_version_number ' || l_object_version_number, 920);
164: hr_utility.set_location('p_return_status ' || p_return_status, 930);
165:
166: if p_return_status<>'S' then
167: exit;
168: end if;

Line 178: hr_utility.set_location('p_return_status ' || p_return_status, 400);

174: IF p_return_status = 'E' THEN
175: ROLLBACK to InvalidUDTSetup;
176: END IF;
177:
178: hr_utility.set_location('p_return_status ' || p_return_status, 400);
179: hr_utility.set_location('Leaving' || l_proc, 500);
180: EXCEPTION
181: WHEN OTHERS THEN
182: p_return_status := 'E';

Line 179: hr_utility.set_location('Leaving' || l_proc, 500);

175: ROLLBACK to InvalidUDTSetup;
176: END IF;
177:
178: hr_utility.set_location('p_return_status ' || p_return_status, 400);
179: hr_utility.set_location('Leaving' || l_proc, 500);
180: EXCEPTION
181: WHEN OTHERS THEN
182: p_return_status := 'E';
183: ROLLBACK to InvalidUDTSetup;

Line 184: hr_utility.set_location(' Others :' || SQLERRM(SQLCODE),900);

180: EXCEPTION
181: WHEN OTHERS THEN
182: p_return_status := 'E';
183: ROLLBACK to InvalidUDTSetup;
184: hr_utility.set_location(' Others :' || SQLERRM(SQLCODE),900);
185: END create_Default_Absence_Actions;
186:
187: PROCEDURE chk_Abs_Action_Setup_Exists
188: (p_absence_attendance_id IN number ,

Line 216: hr_utility.set_location('Entering ' || l_proc, 100);

212:
213: l_proc varchar2(72) := g_package || '.chk_Abs_Action_Setup_Exists';
214: BEGIN
215:
216: hr_utility.set_location('Entering ' || l_proc, 100);
217: p_setup_exists := 'E';
218:
219: --Fetch the Absence Category
220: OPEN c_abs_cat;

Line 224: hr_utility.set_location('Absence Category ' || vc_abs_cat.Absence_Category, 110);

220: OPEN c_abs_cat;
221: FETCH c_abs_cat INTO vc_abs_cat;
222: CLOSE c_abs_cat;
223:
224: hr_utility.set_location('Absence Category ' || vc_abs_cat.Absence_Category, 110);
225: --If Absence Category is Not Null,
226: --Check if User Table is Set up
227: IF vc_abs_cat.Absence_Category IS NOT NULL THEN
228:

Line 238: hr_utility.set_location('p_setup_exists ' || p_setup_exists, 120);

234: p_business_group_id := vc_abs_cat.Business_Group_Id;
235: p_user_table_name := 'NL_ABS_ACTION_'||vc_abs_cat.absence_category;
236: p_setup_exists := 'S';
237: p_start_date := vc_abs_cat.start_date;
238: hr_utility.set_location('p_setup_exists ' || p_setup_exists, 120);
239: END IF;
240: CLOSE c_abs_utab;
241: END IF;
242:

Line 243: hr_utility.set_location('p_setup_exists ' || p_setup_exists, 120);

239: END IF;
240: CLOSE c_abs_utab;
241: END IF;
242:
243: hr_utility.set_location('p_setup_exists ' || p_setup_exists, 120);
244: hr_utility.set_location('Leaving ' || l_proc, 500);
245:
246: END chk_Abs_Action_Setup_Exists;
247:

Line 244: hr_utility.set_location('Leaving ' || l_proc, 500);

240: CLOSE c_abs_utab;
241: END IF;
242:
243: hr_utility.set_location('p_setup_exists ' || p_setup_exists, 120);
244: hr_utility.set_location('Leaving ' || l_proc, 500);
245:
246: END chk_Abs_Action_Setup_Exists;
247:
248: END PER_NL_ABSENCE_TRACK_PKG;