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.PAY_CN_REPORT_PKG dependencies on HR_UTILITY

Line 64: hr_utility.set_location( 'Entering:'|| l_procedure_name, 10);

60: l_balance_name VARCHAR2(255);
61: BEGIN
62:
63: l_procedure_name := g_package_name||'get_balance_value';
64: hr_utility.set_location( 'Entering:'|| l_procedure_name, 10);
65:
66: OPEN csr_bal_name;
67: FETCH csr_bal_name
68: INTO l_balance_name;

Line 76: hr_utility.trace (' Balance Value : '||l_value);

72: FETCH csr_bal
73: INTO l_value;
74: CLOSE csr_bal;
75:
76: hr_utility.trace (' Balance Value : '||l_value);
77: hr_utility.set_location( 'Leaving:'|| l_procedure_name, 20);
78: RETURN fnd_number.canonical_to_number(NVL(l_value,'0'));
79:
80: EXCEPTION

Line 77: hr_utility.set_location( 'Leaving:'|| l_procedure_name, 20);

73: INTO l_value;
74: CLOSE csr_bal;
75:
76: hr_utility.trace (' Balance Value : '||l_value);
77: hr_utility.set_location( 'Leaving:'|| l_procedure_name, 20);
78: RETURN fnd_number.canonical_to_number(NVL(l_value,'0'));
79:
80: EXCEPTION
81: WHEN OTHERS THEN

Line 82: hr_utility.set_location( 'Leaving:'|| l_procedure_name, 30);

78: RETURN fnd_number.canonical_to_number(NVL(l_value,'0'));
79:
80: EXCEPTION
81: WHEN OTHERS THEN
82: hr_utility.set_location( 'Leaving:'|| l_procedure_name, 30);
83: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure_name, 'SQLERRMC:'||sqlerrm);
84: hr_utility.trace (l_message);
85: RAISE;
86: END get_balance_value;

Line 84: hr_utility.trace (l_message);

80: EXCEPTION
81: WHEN OTHERS THEN
82: hr_utility.set_location( 'Leaving:'|| l_procedure_name, 30);
83: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure_name, 'SQLERRMC:'||sqlerrm);
84: hr_utility.trace (l_message);
85: RAISE;
86: END get_balance_value;
87:
88: --------------------------------------------------------------------------

Line 145: hr_utility.set_location( 'Entering:'|| l_procedure_name, 10);

141: l_element_name VARCHAR2(255);
142: BEGIN
143:
144: l_procedure_name := g_package_name||'get_element_value_1';
145: hr_utility.set_location( 'Entering:'|| l_procedure_name, 10);
146:
147: OPEN csr_elem_name;
148: FETCH csr_elem_name
149: INTO l_element_name;

Line 157: hr_utility.trace (' Element Value : '||l_value);

153: FETCH csr_elem
154: INTO l_value;
155: CLOSE csr_elem;
156:
157: hr_utility.trace (' Element Value : '||l_value);
158: hr_utility.set_location( 'Leaving:'|| l_procedure_name, 20);
159:
160: RETURN fnd_number.canonical_to_number(NVL(l_value,'0'));
161:

Line 158: hr_utility.set_location( 'Leaving:'|| l_procedure_name, 20);

154: INTO l_value;
155: CLOSE csr_elem;
156:
157: hr_utility.trace (' Element Value : '||l_value);
158: hr_utility.set_location( 'Leaving:'|| l_procedure_name, 20);
159:
160: RETURN fnd_number.canonical_to_number(NVL(l_value,'0'));
161:
162: EXCEPTION

Line 164: hr_utility.set_location( 'Leaving:'|| l_procedure_name, 30);

160: RETURN fnd_number.canonical_to_number(NVL(l_value,'0'));
161:
162: EXCEPTION
163: WHEN OTHERS THEN
164: hr_utility.set_location( 'Leaving:'|| l_procedure_name, 30);
165: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure_name, 'SQLERRMC:'||sqlerrm);
166: hr_utility.trace (l_message);
167: RAISE;
168: END get_element_value;

Line 166: hr_utility.trace (l_message);

162: EXCEPTION
163: WHEN OTHERS THEN
164: hr_utility.set_location( 'Leaving:'|| l_procedure_name, 30);
165: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure_name, 'SQLERRMC:'||sqlerrm);
166: hr_utility.trace (l_message);
167: RAISE;
168: END get_element_value;
169:
170: --------------------------------------------------------------------------

Line 227: hr_utility.set_location( 'Entering:'|| l_procedure_name, 10);

223: l_element_name VARCHAR2(255);
224: BEGIN
225:
226: l_procedure_name := g_package_name||'get_element_value_2';
227: hr_utility.set_location( 'Entering:'|| l_procedure_name, 10);
228:
229: OPEN csr_elem_name;
230: FETCH csr_elem_name
231: INTO l_element_name;

Line 239: hr_utility.trace (' Element Value : '||l_value);

235: FETCH csr_elem
236: INTO l_value;
237: CLOSE csr_elem;
238:
239: hr_utility.trace (' Element Value : '||l_value);
240: hr_utility.set_location( 'Leaving:'|| l_procedure_name, 20);
241:
242: RETURN fnd_number.canonical_to_number(NVL(l_value,'0'));
243:

Line 240: hr_utility.set_location( 'Leaving:'|| l_procedure_name, 20);

236: INTO l_value;
237: CLOSE csr_elem;
238:
239: hr_utility.trace (' Element Value : '||l_value);
240: hr_utility.set_location( 'Leaving:'|| l_procedure_name, 20);
241:
242: RETURN fnd_number.canonical_to_number(NVL(l_value,'0'));
243:
244: EXCEPTION

Line 246: hr_utility.set_location( 'Leaving:'|| l_procedure_name, 30);

242: RETURN fnd_number.canonical_to_number(NVL(l_value,'0'));
243:
244: EXCEPTION
245: WHEN OTHERS THEN
246: hr_utility.set_location( 'Leaving:'|| l_procedure_name, 30);
247: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure_name, 'SQLERRMC:'||sqlerrm);
248: hr_utility.trace (l_message);
249: RAISE;
250: END get_element_value;

Line 248: hr_utility.trace (l_message);

244: EXCEPTION
245: WHEN OTHERS THEN
246: hr_utility.set_location( 'Leaving:'|| l_procedure_name, 30);
247: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure_name, 'SQLERRMC:'||sqlerrm);
248: hr_utility.trace (l_message);
249: RAISE;
250: END get_element_value;
251:
252: END pay_cn_report_pkg;