APPS.PA_PERF_THRESHOLDS_PKG dependencies on PA_DEBUG

Line 87: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

83: l_debug_level4 CONSTANT NUMBER := 4;
84: l_debug_level5 CONSTANT NUMBER := 5;
85: BEGIN
86:
87: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
88:
89: IF l_debug_mode = 'Y' THEN
90: pa_debug.set_curr_function( p_function => 'PERF_THRESHOLDS',
91: p_debug_mode => l_debug_mode );

Line 90: pa_debug.set_curr_function( p_function => 'PERF_THRESHOLDS',

86:
87: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
88:
89: IF l_debug_mode = 'Y' THEN
90: pa_debug.set_curr_function( p_function => 'PERF_THRESHOLDS',
91: p_debug_mode => l_debug_mode );
92: END IF;
93:
94:

Line 96: pa_debug.g_err_stage:= 'Validating input parameters';

92: END IF;
93:
94:
95: IF l_debug_mode = 'Y' THEN
96: pa_debug.g_err_stage:= 'Validating input parameters';
97: pa_debug.write(g_module_name,pa_debug.g_err_stage,
98: l_debug_level3);
99: END IF;
100:

Line 97: pa_debug.write(g_module_name,pa_debug.g_err_stage,

93:
94:
95: IF l_debug_mode = 'Y' THEN
96: pa_debug.g_err_stage:= 'Validating input parameters';
97: pa_debug.write(g_module_name,pa_debug.g_err_stage,
98: l_debug_level3);
99: END IF;
100:
101: IF l_debug_mode = 'Y' THEN

Line 102: pa_debug.g_err_stage:= 'X_THRESHOLD_ID = '|| X_THRESHOLD_ID;

98: l_debug_level3);
99: END IF;
100:
101: IF l_debug_mode = 'Y' THEN
102: pa_debug.g_err_stage:= 'X_THRESHOLD_ID = '|| X_THRESHOLD_ID;
103: pa_debug.write(g_module_name,pa_debug.g_err_stage,
104: l_debug_level5);
105: pa_debug.g_err_stage:= 'X_RECORD_VERSION_NUMBER = '|| X_RECORD_VERSION_NUMBER;
106: pa_debug.write(g_module_name,pa_debug.g_err_stage,

Line 103: pa_debug.write(g_module_name,pa_debug.g_err_stage,

99: END IF;
100:
101: IF l_debug_mode = 'Y' THEN
102: pa_debug.g_err_stage:= 'X_THRESHOLD_ID = '|| X_THRESHOLD_ID;
103: pa_debug.write(g_module_name,pa_debug.g_err_stage,
104: l_debug_level5);
105: pa_debug.g_err_stage:= 'X_RECORD_VERSION_NUMBER = '|| X_RECORD_VERSION_NUMBER;
106: pa_debug.write(g_module_name,pa_debug.g_err_stage,
107: l_debug_level5);

Line 105: pa_debug.g_err_stage:= 'X_RECORD_VERSION_NUMBER = '|| X_RECORD_VERSION_NUMBER;

101: IF l_debug_mode = 'Y' THEN
102: pa_debug.g_err_stage:= 'X_THRESHOLD_ID = '|| X_THRESHOLD_ID;
103: pa_debug.write(g_module_name,pa_debug.g_err_stage,
104: l_debug_level5);
105: pa_debug.g_err_stage:= 'X_RECORD_VERSION_NUMBER = '|| X_RECORD_VERSION_NUMBER;
106: pa_debug.write(g_module_name,pa_debug.g_err_stage,
107: l_debug_level5);
108:
109: END IF;

Line 106: pa_debug.write(g_module_name,pa_debug.g_err_stage,

102: pa_debug.g_err_stage:= 'X_THRESHOLD_ID = '|| X_THRESHOLD_ID;
103: pa_debug.write(g_module_name,pa_debug.g_err_stage,
104: l_debug_level5);
105: pa_debug.g_err_stage:= 'X_RECORD_VERSION_NUMBER = '|| X_RECORD_VERSION_NUMBER;
106: pa_debug.write(g_module_name,pa_debug.g_err_stage,
107: l_debug_level5);
108:
109: END IF;
110:

Line 112: pa_debug.g_err_stage:= 'in lock row method,ABOUT TO EXECUTE QUERY';

108:
109: END IF;
110:
111: IF l_debug_mode = 'Y' THEN
112: pa_debug.g_err_stage:= 'in lock row method,ABOUT TO EXECUTE QUERY';
113: pa_debug.write(g_module_name,pa_debug.g_err_stage,l_debug_level3);
114: pa_debug.reset_curr_function;
115: END IF;
116:

Line 113: pa_debug.write(g_module_name,pa_debug.g_err_stage,l_debug_level3);

109: END IF;
110:
111: IF l_debug_mode = 'Y' THEN
112: pa_debug.g_err_stage:= 'in lock row method,ABOUT TO EXECUTE QUERY';
113: pa_debug.write(g_module_name,pa_debug.g_err_stage,l_debug_level3);
114: pa_debug.reset_curr_function;
115: END IF;
116:
117: select record_version_number into l_rec_ver_no

Line 114: pa_debug.reset_curr_function;

110:
111: IF l_debug_mode = 'Y' THEN
112: pa_debug.g_err_stage:= 'in lock row method,ABOUT TO EXECUTE QUERY';
113: pa_debug.write(g_module_name,pa_debug.g_err_stage,l_debug_level3);
114: pa_debug.reset_curr_function;
115: END IF;
116:
117: select record_version_number into l_rec_ver_no
118: from pa_perf_thresholds

Line 127: pa_debug.g_err_stage:= 'in lock row method,query executed';

123: raise Invalid_Rec_Change;
124: end if;
125:
126: IF l_debug_mode = 'Y' THEN
127: pa_debug.g_err_stage:= 'in lock row method,query executed';
128: pa_debug.write(g_module_name,pa_debug.g_err_stage,l_debug_level3);
129: pa_debug.reset_curr_function;
130: END IF;
131: EXCEPTION

Line 128: pa_debug.write(g_module_name,pa_debug.g_err_stage,l_debug_level3);

124: end if;
125:
126: IF l_debug_mode = 'Y' THEN
127: pa_debug.g_err_stage:= 'in lock row method,query executed';
128: pa_debug.write(g_module_name,pa_debug.g_err_stage,l_debug_level3);
129: pa_debug.reset_curr_function;
130: END IF;
131: EXCEPTION
132: when NO_DATA_FOUND then

Line 129: pa_debug.reset_curr_function;

125:
126: IF l_debug_mode = 'Y' THEN
127: pa_debug.g_err_stage:= 'in lock row method,query executed';
128: pa_debug.write(g_module_name,pa_debug.g_err_stage,l_debug_level3);
129: pa_debug.reset_curr_function;
130: END IF;
131: EXCEPTION
132: when NO_DATA_FOUND then
133: PA_UTILS.ADD_MESSAGE