DBA Data[Home] [Help]

APPS.PSA_BC_XLA_PUB dependencies on PSA_UTILS

Line 101: psa_utils.debug_other_string(g_state_level,l_api_name,'Begin of Procedure Budgetary_Control');

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);

Line 102: psa_utils.debug_other_string(g_state_level,l_api_name,'In parameters.. ');

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);

Line 103: psa_utils.debug_other_string(g_state_level,l_api_name,'API Version = ' || p_api_version);

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);

Line 104: psa_utils.debug_other_string(g_state_level,l_api_name,'Application Id = '|| p_application_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);

Line 105: psa_utils.debug_other_string(g_state_level,l_api_name,'Budgetary Control Mode = '|| p_bc_mode);

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:

Line 106: psa_utils.debug_other_string(g_state_level,l_api_name,'Override flag = '|| p_override_flag);

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

Line 107: psa_utils.debug_other_string(g_state_level,l_api_name,'User Id = '|| P_user_id);

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;

Line 108: psa_utils.debug_other_string(g_state_level,l_api_name,'User Responsibility Id = '|| P_user_resp_id);

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;

Line 114: psa_utils.debug_other_string(g_state_level,l_api_name,'Checking for API compatibility..');

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

Line 136: psa_utils.debug_other_string(g_state_level,l_api_name,'Calling the Private API psa_bc_xla_pvt.Budgetary_control..');

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

Line 151: psa_utils.debug_other_string(g_state_level,l_api_name,'Call to Private API PSA_BC_XLA_PVT.Budgetary_control successful') ;

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

Line 156: psa_utils.debug_other_string(g_error_level,l_api_name,'EXCEPTION: '|| SQLERRM(sqlcode));

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

Line 157: psa_utils.debug_other_string(g_error_level,l_api_name,'Error in Budgetary_control Procedure' );

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);

Line 164: psa_utils.debug_other_string(g_unexp_level,l_api_name,'ERROR: Unexpected Error in budgetary_control Procedure' );

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);

Line 176: psa_utils.debug_other_string(g_unexp_level,l_api_name,'EXCEPTION: '|| SQLERRM(sqlcode));

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);

Line 177: psa_utils.debug_other_string(g_unexp_level,l_api_name,'Error in budgetary_control Procedure' );

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:

Line 234: psa_utils.debug_other_string(g_state_level,l_path_name,'BEGIN of ' || l_path_name);

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,

Line 242: psa_utils.debug_other_string(g_state_level,l_path_name,'END of ' || l_path_name);

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

Line 247: psa_utils.debug_other_string(g_error_level,l_path_name,'EXCEPTION: '|| SQLERRM(sqlcode));

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:

Line 248: psa_utils.debug_other_string(g_error_level,l_path_name,'Error in get_sla_notupgraded_flag function' );

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