DBA Data[Home] [Help]

APPS.PAY_PGL_PKG dependencies on HR_UTILITY

Line 12: hr_utility.set_location('pay_pgl_pkg.get_cost_allocation',1);

8: select cost_allocation_structure
9: from per_business_groups
10: where business_group_id + 0 = p_business_group_id;
11: begin
12: hr_utility.set_location('pay_pgl_pkg.get_cost_allocation',1);
13: open c;
14: fetch c into p_cost_allocation_id_flex_num;
15: close c;
16: end get_cost_allocation;

Line 40: hr_utility.set_location('pay_pgl_pkg.get_pay_post_query',1);

36: sob_rec c%rowtype;
37: --
38: begin
39: /* Get the Set of Books Name and Chart of Accounts ID*/
40: hr_utility.set_location('pay_pgl_pkg.get_pay_post_query',1);
41: open c;
42: fetch c into sob_rec;
43: close c;
44: p_displayed_set_of_books := sob_rec.name;

Line 77: hr_utility.set_location('pay_pgl_pkg.get_prf_post_query',1);

73: and id_flex_num = l_flex_num
74: and enabled_flag = 'Y'
75: and application_column_name = l_column_name;
76: begin
77: hr_utility.set_location('pay_pgl_pkg.get_prf_post_query',1);
78: open c('GL#',p_gl_flex_num,p_gl_account_segment);
79: fetch c into p_displayed_gl_segment;
80: close c;
81: --

Line 82: hr_utility.set_location('pay_pgl_pkg.get_prf_post_query',2);

78: open c('GL#',p_gl_flex_num,p_gl_account_segment);
79: fetch c into p_displayed_gl_segment;
80: close c;
81: --
82: hr_utility.set_location('pay_pgl_pkg.get_prf_post_query',2);
83: open c('COST',p_cost_flex_num,p_payroll_cost_segment);
84: fetch c into p_displayed_cost_segment;
85: close c;
86: end;

Line 106: hr_utility.set_location('pay_pgl_pkg.prf_checks',1);

102: (p_rowid is not null
103: and chartorowid(p_rowid) <> rowid));
104: --
105: begin
106: hr_utility.set_location('pay_pgl_pkg.prf_checks',1);
107: open c1;
108: fetch c1 into l_exists;
109: if c1%found then
110: close c1;

Line 111: hr_utility.set_message(801,'PAY_6962_DEF_GLMAP_DUP_GLSEG');

107: open c1;
108: fetch c1 into l_exists;
109: if c1%found then
110: close c1;
111: hr_utility.set_message(801,'PAY_6962_DEF_GLMAP_DUP_GLSEG');
112: hr_utility.raise_error;
113: end if;
114: close c1;
115: end prf_checks;

Line 112: hr_utility.raise_error;

108: fetch c1 into l_exists;
109: if c1%found then
110: close c1;
111: hr_utility.set_message(801,'PAY_6962_DEF_GLMAP_DUP_GLSEG');
112: hr_utility.raise_error;
113: end if;
114: close c1;
115: end prf_checks;
116: --

Line 127: hr_utility.set_location('pay_pgl_pkg.future_payroll_rows',1);

123: and effective_start_date > p_session_date;
124: pay_rec c%rowtype;
125: --
126: begin
127: hr_utility.set_location('pay_pgl_pkg.future_payroll_rows',1);
128: open c;
129: fetch c into pay_rec;
130: if c%found then
131: close c;