72: l_api_version NUMBER := 1.0;
73: l_return_status VARCHAR2(1);
74: l_msg_count NUMBER;
75: l_msg_data VARCHAR2(2000); --Bug 7125729:Increasing message buffer size
76: l_validation_level NUMBER default FND_API.G_VALID_LEVEL_FULL;
77:
78: l_old_status VARCHAR2(30);
79: l_new_status VARCHAR2(30);
80: l_default_status VARCHAR2(1);
182: l_exception_name := G_FAIL_EXP_COMPL_EXCEPTION;
183:
184: WSH_XC_UTIL.log_exception(
185: p_api_version => l_api_version,
186: p_init_msg_list => FND_API.G_FALSE,
187: p_commit => FND_API.G_FALSE,
188: p_validation_level => l_validation_level,
189: x_return_status => l_return_status,
190: x_msg_count => l_msg_count,
183:
184: WSH_XC_UTIL.log_exception(
185: p_api_version => l_api_version,
186: p_init_msg_list => FND_API.G_FALSE,
187: p_commit => FND_API.G_FALSE,
188: p_validation_level => l_validation_level,
189: x_return_status => l_return_status,
190: x_msg_count => l_msg_count,
191: x_msg_data => l_msg_data,
252: l_exception_name := G_FAIL_EXP_COMPL_EXCEPTION;
253:
254: WSH_XC_UTIL.log_exception(
255: p_api_version => l_api_version,
256: p_init_msg_list => FND_API.G_FALSE,
257: p_commit => FND_API.G_FALSE,
258: p_validation_level => l_validation_level,
259: x_return_status => l_return_status,
260: x_msg_count => l_msg_count,
253:
254: WSH_XC_UTIL.log_exception(
255: p_api_version => l_api_version,
256: p_init_msg_list => FND_API.G_FALSE,
257: p_commit => FND_API.G_FALSE,
258: p_validation_level => l_validation_level,
259: x_return_status => l_return_status,
260: x_msg_count => l_msg_count,
261: x_msg_data => l_msg_data,
318: END IF;
319:
320: WSH_XC_UTIL.change_status (
321: p_api_version => l_api_version,
322: p_init_msg_list => FND_API.G_FALSE,
323: p_commit => FND_API.G_FALSE,
324: p_validation_level => l_validation_level,
325: x_return_status => l_return_status,
326: x_msg_count => l_msg_count,
319:
320: WSH_XC_UTIL.change_status (
321: p_api_version => l_api_version,
322: p_init_msg_list => FND_API.G_FALSE,
323: p_commit => FND_API.G_FALSE,
324: p_validation_level => l_validation_level,
325: x_return_status => l_return_status,
326: x_msg_count => l_msg_count,
327: x_msg_data => l_msg_data,