97:
98: BEGIN
99:
100: l_api_name := g_path_name || '.Budgetary_Control';
101: psa_utils.debug_other_string(g_state_level,l_api_name,'Begin of Procedure Budgetary_Control');
102: psa_utils.debug_other_string(g_state_level,l_api_name,'In parameters.. ');
103: psa_utils.debug_other_string(g_state_level,l_api_name,'API Version = ' || p_api_version);
104: psa_utils.debug_other_string(g_state_level,l_api_name,'Application Id = '|| p_application_id);
105: psa_utils.debug_other_string(g_state_level,l_api_name,'Budgetary Control Mode = '|| p_bc_mode);
98: BEGIN
99:
100: l_api_name := g_path_name || '.Budgetary_Control';
101: psa_utils.debug_other_string(g_state_level,l_api_name,'Begin of Procedure Budgetary_Control');
102: psa_utils.debug_other_string(g_state_level,l_api_name,'In parameters.. ');
103: psa_utils.debug_other_string(g_state_level,l_api_name,'API Version = ' || p_api_version);
104: psa_utils.debug_other_string(g_state_level,l_api_name,'Application Id = '|| p_application_id);
105: psa_utils.debug_other_string(g_state_level,l_api_name,'Budgetary Control Mode = '|| p_bc_mode);
106: psa_utils.debug_other_string(g_state_level,l_api_name,'Override flag = '|| p_override_flag);
99:
100: l_api_name := g_path_name || '.Budgetary_Control';
101: psa_utils.debug_other_string(g_state_level,l_api_name,'Begin of Procedure Budgetary_Control');
102: psa_utils.debug_other_string(g_state_level,l_api_name,'In parameters.. ');
103: psa_utils.debug_other_string(g_state_level,l_api_name,'API Version = ' || p_api_version);
104: psa_utils.debug_other_string(g_state_level,l_api_name,'Application Id = '|| p_application_id);
105: psa_utils.debug_other_string(g_state_level,l_api_name,'Budgetary Control Mode = '|| p_bc_mode);
106: psa_utils.debug_other_string(g_state_level,l_api_name,'Override flag = '|| p_override_flag);
107: psa_utils.debug_other_string(g_state_level,l_api_name,'User Id = '|| P_user_id);
100: l_api_name := g_path_name || '.Budgetary_Control';
101: psa_utils.debug_other_string(g_state_level,l_api_name,'Begin of Procedure Budgetary_Control');
102: psa_utils.debug_other_string(g_state_level,l_api_name,'In parameters.. ');
103: psa_utils.debug_other_string(g_state_level,l_api_name,'API Version = ' || p_api_version);
104: psa_utils.debug_other_string(g_state_level,l_api_name,'Application Id = '|| p_application_id);
105: psa_utils.debug_other_string(g_state_level,l_api_name,'Budgetary Control Mode = '|| p_bc_mode);
106: psa_utils.debug_other_string(g_state_level,l_api_name,'Override flag = '|| p_override_flag);
107: psa_utils.debug_other_string(g_state_level,l_api_name,'User Id = '|| P_user_id);
108: psa_utils.debug_other_string(g_state_level,l_api_name,'User Responsibility Id = '|| P_user_resp_id);
101: psa_utils.debug_other_string(g_state_level,l_api_name,'Begin of Procedure Budgetary_Control');
102: psa_utils.debug_other_string(g_state_level,l_api_name,'In parameters.. ');
103: psa_utils.debug_other_string(g_state_level,l_api_name,'API Version = ' || p_api_version);
104: psa_utils.debug_other_string(g_state_level,l_api_name,'Application Id = '|| p_application_id);
105: psa_utils.debug_other_string(g_state_level,l_api_name,'Budgetary Control Mode = '|| p_bc_mode);
106: psa_utils.debug_other_string(g_state_level,l_api_name,'Override flag = '|| p_override_flag);
107: psa_utils.debug_other_string(g_state_level,l_api_name,'User Id = '|| P_user_id);
108: psa_utils.debug_other_string(g_state_level,l_api_name,'User Responsibility Id = '|| P_user_resp_id);
109:
102: psa_utils.debug_other_string(g_state_level,l_api_name,'In parameters.. ');
103: psa_utils.debug_other_string(g_state_level,l_api_name,'API Version = ' || p_api_version);
104: psa_utils.debug_other_string(g_state_level,l_api_name,'Application Id = '|| p_application_id);
105: psa_utils.debug_other_string(g_state_level,l_api_name,'Budgetary Control Mode = '|| p_bc_mode);
106: psa_utils.debug_other_string(g_state_level,l_api_name,'Override flag = '|| p_override_flag);
107: psa_utils.debug_other_string(g_state_level,l_api_name,'User Id = '|| P_user_id);
108: psa_utils.debug_other_string(g_state_level,l_api_name,'User Responsibility Id = '|| P_user_resp_id);
109:
110: IF (FND_API.to_boolean(NVl(p_init_msg_list,FND_API.G_FALSE))) THEN
103: psa_utils.debug_other_string(g_state_level,l_api_name,'API Version = ' || p_api_version);
104: psa_utils.debug_other_string(g_state_level,l_api_name,'Application Id = '|| p_application_id);
105: psa_utils.debug_other_string(g_state_level,l_api_name,'Budgetary Control Mode = '|| p_bc_mode);
106: psa_utils.debug_other_string(g_state_level,l_api_name,'Override flag = '|| p_override_flag);
107: psa_utils.debug_other_string(g_state_level,l_api_name,'User Id = '|| P_user_id);
108: psa_utils.debug_other_string(g_state_level,l_api_name,'User Responsibility Id = '|| P_user_resp_id);
109:
110: IF (FND_API.to_boolean(NVl(p_init_msg_list,FND_API.G_FALSE))) THEN
111: FND_MSG_PUB.initialize;
104: psa_utils.debug_other_string(g_state_level,l_api_name,'Application Id = '|| p_application_id);
105: psa_utils.debug_other_string(g_state_level,l_api_name,'Budgetary Control Mode = '|| p_bc_mode);
106: psa_utils.debug_other_string(g_state_level,l_api_name,'Override flag = '|| p_override_flag);
107: psa_utils.debug_other_string(g_state_level,l_api_name,'User Id = '|| P_user_id);
108: psa_utils.debug_other_string(g_state_level,l_api_name,'User Responsibility Id = '|| P_user_resp_id);
109:
110: IF (FND_API.to_boolean(NVl(p_init_msg_list,FND_API.G_FALSE))) THEN
111: FND_MSG_PUB.initialize;
112: END IF;
110: IF (FND_API.to_boolean(NVl(p_init_msg_list,FND_API.G_FALSE))) THEN
111: FND_MSG_PUB.initialize;
112: END IF;
113:
114: psa_utils.debug_other_string(g_state_level,l_api_name,'Checking for API compatibility..');
115: --
116: --Standard call to check for call compatibility.
117: --
118: IF (NOT FND_API.compatible_api_call
132:
133: --
134: -- call the private function
135: --
136: psa_utils.debug_other_string(g_state_level,l_api_name,'Calling the Private API psa_bc_xla_pvt.Budgetary_control..');
137:
138: PSA_BC_XLA_PVT.Budgetary_control(p_init_msg_list => NVl(p_init_msg_list,FND_API.G_FALSE)
139: ,x_return_status => x_return_status
140: ,x_msg_count => x_msg_count
147: ,x_status_code => x_status_code
148: ,x_Packet_ID => x_Packet_ID );
149:
150:
151: psa_utils.debug_other_string(g_state_level,l_api_name,'Call to Private API PSA_BC_XLA_PVT.Budgetary_control successful') ;
152:
153: EXCEPTION
154:
155: WHEN FND_API.G_EXC_ERROR THEN
152:
153: EXCEPTION
154:
155: WHEN FND_API.G_EXC_ERROR THEN
156: psa_utils.debug_other_string(g_error_level,l_api_name,'EXCEPTION: '|| SQLERRM(sqlcode));
157: psa_utils.debug_other_string(g_error_level,l_api_name,'Error in Budgetary_control Procedure' );
158: x_return_status := FND_API.G_RET_STS_ERROR ;
159: FND_MSG_PUB.count_and_get(p_encoded => FND_API.G_FALSE
160: ,p_count => x_msg_count
153: EXCEPTION
154:
155: WHEN FND_API.G_EXC_ERROR THEN
156: psa_utils.debug_other_string(g_error_level,l_api_name,'EXCEPTION: '|| SQLERRM(sqlcode));
157: psa_utils.debug_other_string(g_error_level,l_api_name,'Error in Budgetary_control Procedure' );
158: x_return_status := FND_API.G_RET_STS_ERROR ;
159: FND_MSG_PUB.count_and_get(p_encoded => FND_API.G_FALSE
160: ,p_count => x_msg_count
161: ,p_data => x_msg_data);
160: ,p_count => x_msg_count
161: ,p_data => x_msg_data);
162:
163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
164: psa_utils.debug_other_string(g_unexp_level,l_api_name,'ERROR: Unexpected Error in budgetary_control Procedure' );
165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
166: FND_MSG_PUB.count_and_get(p_encoded => FND_API.G_FALSE
167: ,p_count => x_msg_count
168: ,p_data => x_msg_data);
172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
173: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
174: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
175: END IF;
176: psa_utils.debug_other_string(g_unexp_level,l_api_name,'EXCEPTION: '|| SQLERRM(sqlcode));
177: psa_utils.debug_other_string(g_unexp_level,l_api_name,'Error in budgetary_control Procedure' );
178: FND_MSG_PUB.count_and_get(p_encoded => FND_API.G_FALSE
179: ,p_count => x_msg_count
180: ,p_data => x_msg_data);
173: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
174: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
175: END IF;
176: psa_utils.debug_other_string(g_unexp_level,l_api_name,'EXCEPTION: '|| SQLERRM(sqlcode));
177: psa_utils.debug_other_string(g_unexp_level,l_api_name,'Error in budgetary_control Procedure' );
178: FND_MSG_PUB.count_and_get(p_encoded => FND_API.G_FALSE
179: ,p_count => x_msg_count
180: ,p_data => x_msg_data);
181:
230:
231: BEGIN
232:
233: l_path_name := g_path_name || '.get_sla_notupgraded_flag';
234: psa_utils.debug_other_string(g_state_level,l_path_name,'BEGIN of ' || l_path_name);
235:
236: l_return_val := PSA_BC_XLA_PVT.get_sla_notupgraded_flag (p_application_id ,
237: p_entity_code,
238: p_source_id_int_1,
238: p_source_id_int_1,
239: p_dist_link_type,
240: p_distribution_id);
241:
242: psa_utils.debug_other_string(g_state_level,l_path_name,'END of ' || l_path_name);
243:
244: RETURN l_return_val;
245: EXCEPTION
246: WHEN others THEN
243:
244: RETURN l_return_val;
245: EXCEPTION
246: WHEN others THEN
247: psa_utils.debug_other_string(g_error_level,l_path_name,'EXCEPTION: '|| SQLERRM(sqlcode));
248: psa_utils.debug_other_string(g_error_level,l_path_name,'Error in get_sla_notupgraded_flag function' );
249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
250: END get_sla_notupgraded_flag;
251:
244: RETURN l_return_val;
245: EXCEPTION
246: WHEN others THEN
247: psa_utils.debug_other_string(g_error_level,l_path_name,'EXCEPTION: '|| SQLERRM(sqlcode));
248: psa_utils.debug_other_string(g_error_level,l_path_name,'Error in get_sla_notupgraded_flag function' );
249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
250: END get_sla_notupgraded_flag;
251:
252: BEGIN