DBA Data[Home] [Help]

APPS.PER_QP_INVOCATIONS dependencies on HR_UTILITY

Line 43: hr_utility.set_location('per_qp_invocations.pre_insert_checks',1);

39: l_exists varchar2(1);
40: --
41: begin
42: --
43: hr_utility.set_location('per_qp_invocations.pre_insert_checks',1);
44: --
45: open c;
46: fetch c into l_exists;
47: if c%found then

Line 52: hr_utility.set_message(801,'HR_6737_QP_NO_SET_TWICE');

48: --
49: close c;
50: if p_invocation_type = 'S' then
51: --
52: hr_utility.set_message(801,'HR_6737_QP_NO_SET_TWICE');
53: --
54: else
55: --
56: hr_utility.set_message(801,'HR_6694_QP_NO_RUN_TWICE');

Line 56: hr_utility.set_message(801,'HR_6694_QP_NO_RUN_TWICE');

52: hr_utility.set_message(801,'HR_6737_QP_NO_SET_TWICE');
53: --
54: else
55: --
56: hr_utility.set_message(801,'HR_6694_QP_NO_RUN_TWICE');
57: --
58: end if;
59: --
60: hr_utility.raise_error;

Line 60: hr_utility.raise_error;

56: hr_utility.set_message(801,'HR_6694_QP_NO_RUN_TWICE');
57: --
58: end if;
59: --
60: hr_utility.raise_error;
61: --
62: end if;
63: close c;
64: --

Line 104: hr_utility.set_location('per_qp_invocations.populate_fields',1);

100: and a.effective_end_date;
101: --
102: begin
103: --
104: hr_utility.set_location('per_qp_invocations.populate_fields',1);
105: --
106: open c1;
107: fetch c1 into p_qp_report_name;
108: close c1;

Line 202: hr_utility.set_location('per_qp_invocations.load_result',1);

198: l_eol VARCHAR2(1) := '';
199: --
200: Begin
201: --
202: hr_utility.set_location('per_qp_invocations.load_result',1);
203: --
204: open c;
205: loop
206: --

Line 245: hr_utility.set_location('per_qp_invocations.get_assignment',1);

241: and t.qp_invocation_id = p_qp_invocation_id);
242: --
243: begin
244: --
245: hr_utility.set_location('per_qp_invocations.get_assignment',1);
246: --
247: open c;
248: fetch c into p_full_name,p_user_person_type,p_assignment_number;
249: close c;

Line 271: hr_utility.set_location('per_qp_invocations.init_cust',1);

267: l_exists varchar2(30);
268: --
269: begin
270: --
271: hr_utility.set_location('per_qp_invocations.init_cust',1);
272: --
273: p_restrict_empapl := 'N';
274: open restriction('EMP_APL');
275: fetch restriction into l_exists;

Line 332: hr_utility.set_location('per_qp_invocations.validate_assignment',1);

328: l_invocation_context NUMBER;
329: --
330: begin
331: --
332: hr_utility.set_location('per_qp_invocations.validate_assignment',1);
333: --
334: open c;
335: fetch c into l_invocation_context;
336: if c%notfound then

Line 339: hr_utility.set_message(801,'HR_7097_ASS_SET_INVALID');

335: fetch c into l_invocation_context;
336: if c%notfound then
337: --
338: close c;
339: hr_utility.set_message(801,'HR_7097_ASS_SET_INVALID');
340: hr_utility.set_message_token('ASS_SET','assignment');
341: hr_utility.raise_error;
342: --
343: end if;

Line 340: hr_utility.set_message_token('ASS_SET','assignment');

336: if c%notfound then
337: --
338: close c;
339: hr_utility.set_message(801,'HR_7097_ASS_SET_INVALID');
340: hr_utility.set_message_token('ASS_SET','assignment');
341: hr_utility.raise_error;
342: --
343: end if;
344: close c;

Line 341: hr_utility.raise_error;

337: --
338: close c;
339: hr_utility.set_message(801,'HR_7097_ASS_SET_INVALID');
340: hr_utility.set_message_token('ASS_SET','assignment');
341: hr_utility.raise_error;
342: --
343: end if;
344: close c;
345: --

Line 354: hr_utility.set_location('per_qp_invocations.delete_quickpaints',1);

350: procedure delete_quickpaints(p_qp_session_id NUMBER) is
351: --
352: begin
353: --
354: hr_utility.set_location('per_qp_invocations.delete_quickpaints',1);
355: --
356: delete from per_quickpaint_invocations
357: where qp_session_id = p_qp_session_id;
358: --