DBA Data[Home] [Help]

APPS.PAY_MX_SS_ARCH_TRAN_DATE_UPG dependencies on HR_UTILITY

Line 42: Name : HR_UTILITY_TRACE

38: g_debug boolean;
39:
40:
41: /****************************************************************************
42: Name : HR_UTILITY_TRACE
43: Description : This procedure prints debug messages.
44: *****************************************************************************/
45: PROCEDURE HR_UTILITY_TRACE
46: (

Line 45: PROCEDURE HR_UTILITY_TRACE

41: /****************************************************************************
42: Name : HR_UTILITY_TRACE
43: Description : This procedure prints debug messages.
44: *****************************************************************************/
45: PROCEDURE HR_UTILITY_TRACE
46: (
47: P_TRC_DATA varchar2
48: ) AS
49: BEGIN

Line 51: hr_utility.trace(p_trc_data);

47: P_TRC_DATA varchar2
48: ) AS
49: BEGIN
50: IF g_debug THEN
51: hr_utility.trace(p_trc_data);
52: END IF;
53: END HR_UTILITY_TRACE;
54:
55:

Line 53: END HR_UTILITY_TRACE;

49: BEGIN
50: IF g_debug THEN
51: hr_utility.trace(p_trc_data);
52: END IF;
53: END HR_UTILITY_TRACE;
54:
55:
56: /****************************************************************************
57: Name : QUAL_PROC

Line 83: hr_utility_trace ('Entering '||l_proc_name);

79: l_proc_name varchar2(100);
80:
81: BEGIN
82: l_proc_name := g_proc_name || 'QUAL_PROC';
83: hr_utility_trace ('Entering '||l_proc_name);
84:
85: p_qual := 'N';
86: OPEN csr_qualified;
87: FETCH csr_qualified INTO p_qual;

Line 91: hr_utility_trace('Assignment ' || p_object_id || ' qualified.');

87: FETCH csr_qualified INTO p_qual;
88: CLOSE csr_qualified;
89:
90: IF p_qual = 'Y' THEN
91: hr_utility_trace('Assignment ' || p_object_id || ' qualified.');
92: ELSE
93: hr_utility_trace('Assignment ' || p_object_id || ' did not qualify.');
94: END IF;
95:

Line 93: hr_utility_trace('Assignment ' || p_object_id || ' did not qualify.');

89:
90: IF p_qual = 'Y' THEN
91: hr_utility_trace('Assignment ' || p_object_id || ' qualified.');
92: ELSE
93: hr_utility_trace('Assignment ' || p_object_id || ' did not qualify.');
94: END IF;
95:
96: hr_utility_trace ('Leaving '||l_proc_name);
97: END QUAL_PROC;

Line 96: hr_utility_trace ('Leaving '||l_proc_name);

92: ELSE
93: hr_utility_trace('Assignment ' || p_object_id || ' did not qualify.');
94: END IF;
95:
96: hr_utility_trace ('Leaving '||l_proc_name);
97: END QUAL_PROC;
98:
99: /****************************************************************************
100: Name : UPG_PROC

Line 134: hr_utility_trace ('Entering '||l_proc_name);

130: ln_count number;
131:
132: BEGIN
133: l_proc_name := g_proc_name || 'UPG_PROC';
134: hr_utility_trace ('Entering '||l_proc_name);
135:
136: ln_count := 0;
137: OPEN csr_upgrade;
138: LOOP

Line 153: hr_utility_trace(ln_count ||

149: p_action_information5 => lv_er_ss_id);
150:
151: ln_count := ln_count + 1;
152: END LOOP;
153: hr_utility_trace(ln_count ||
154: ' transaction(s) upgraded for assignment '||
155: p_object_id);
156: CLOSE csr_upgrade;
157: hr_utility_trace ('Leaving '||l_proc_name);

Line 157: hr_utility_trace ('Leaving '||l_proc_name);

153: hr_utility_trace(ln_count ||
154: ' transaction(s) upgraded for assignment '||
155: p_object_id);
156: CLOSE csr_upgrade;
157: hr_utility_trace ('Leaving '||l_proc_name);
158: END UPG_PROC;
159:
160: BEGIN
161: --hr_utility.trace_on(null, 'MX_IDC');

Line 161: --hr_utility.trace_on(null, 'MX_IDC');

157: hr_utility_trace ('Leaving '||l_proc_name);
158: END UPG_PROC;
159:
160: BEGIN
161: --hr_utility.trace_on(null, 'MX_IDC');
162: g_proc_name := 'PAY_MX_SS_ARCH_TRAN_DATE_UPG.';
163: g_debug := hr_utility.debug_enabled;
164: END PAY_MX_SS_ARCH_TRAN_DATE_UPG;

Line 163: g_debug := hr_utility.debug_enabled;

159:
160: BEGIN
161: --hr_utility.trace_on(null, 'MX_IDC');
162: g_proc_name := 'PAY_MX_SS_ARCH_TRAN_DATE_UPG.';
163: g_debug := hr_utility.debug_enabled;
164: END PAY_MX_SS_ARCH_TRAN_DATE_UPG;