76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
77: END IF;
78: -- Initialize message list if p_init_msg_list is set to TRUE.
79: IF FND_API.to_Boolean( p_init_msg_list ) THEN
80: FND_MSG_PUB.initialize;
81: END IF;
82: -- Initialize API return status to success
83: x_return_status := FND_API.G_RET_STS_SUCCESS;
84: --
145: x_org_rec => P_um_organization_Rec,
146: p_search_value => l_search_value,
147: p_use_name => false ) ) then
148: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_ORGANIZATION_NOT_FOUND');
149: FND_MSG_PUB.ADD;
150: RAISE FND_API.G_EXC_ERROR;
151: end if;
152: END IF;
153: --l_party_rel_rec.party_rec.total_num_of_orders := 0;
295: THEN
296: COMMIT WORK;
297: END IF;
298: -- Standard call to get message count and if count is 1, get message info.
299: FND_MSG_PUB.Count_And_Get(
300: p_count => x_msg_count,
301: p_data => x_msg_data);
302: JTF_DEBUG_PUB.LOG_EXITING_METHOD(
303: p_module => G_MODULE,
306: WHEN FND_API.G_EXC_ERROR THEN
307: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS(
308: P_API_NAME => L_API_NAME
309: ,P_PKG_NAME => G_PKG_NAME
310: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
311: ,P_SQLCODE => SQLCODE
312: ,P_SQLERRM => SQLERRM
313: ,X_MSG_COUNT => X_MSG_COUNT
314: ,X_MSG_DATA => X_MSG_DATA
316: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
317: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS(
318: P_API_NAME => L_API_NAME
319: ,P_PKG_NAME => G_PKG_NAME
320: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
321: ,P_SQLCODE => SQLCODE
322: ,P_SQLERRM => SQLERRM
323: ,X_MSG_COUNT => X_MSG_COUNT
324: ,X_MSG_DATA => X_MSG_DATA
389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
390: END IF;
391: -- Initialize message list if p_init_msg_list is set to TRUE.
392: IF FND_API.to_Boolean( p_init_msg_list ) THEN
393: FND_MSG_PUB.initialize;
394: END IF;
395: -- Initialize API return status to success
396: x_return_status := FND_API.G_RET_STS_SUCCESS;
397: --
497: THEN
498: COMMIT WORK;
499: END IF;
500: -- Standard call to get message count and if count is 1, get message info.
501: FND_MSG_PUB.Count_And_Get(
502: p_count => x_msg_count,
503: p_data => x_msg_data);
504: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => G_MODULE,
505: p_message => l_api_name);