[Home] [Help]
48: --
49: -- OUT
50: -- x_contract_id OUT NUMBER
51: -- Version : Current version 1.0
52: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
53: -- and basic operation, developer must manually add parameters and business logic as necessary.
54: --
55: -- End of Comments
56: -- ==============================================================================
146: l_partner_party_id NUMBER;
147: l_template_id NUMBER;
148:
149: BEGIN
150: -- Standard Start of API savepoint
151: SAVEPOINT Is_Contract_Exist_Then_Create;
152:
153: -- Standard call to check for call compatibility.
154: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
149: BEGIN
150: -- Standard Start of API savepoint
151: SAVEPOINT Is_Contract_Exist_Then_Create;
152:
153: -- Standard call to check for call compatibility.
154: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
155: p_api_version_number,
156: l_api_name,
157: G_PKG_NAME)
307: IF (PV_DEBUG_HIGH_ON) THEN
308: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - end');
309: END IF;
310:
311: -- Standard call to get message count and if count is 1, get message info.
312: FND_MSG_PUB.Count_And_Get
313: ( p_encoded => FND_API.G_FALSE,
314: p_count => x_msg_count,
315: p_data => x_msg_data
320: WHEN Fnd_Api.G_EXC_ERROR THEN
321: ROLLBACK TO Is_Contract_Exist_Then_Create;
322: x_return_status := Fnd_Api.G_RET_STS_ERROR;
323:
324: -- Standard call to get message count and if count=1, get the message
325: Fnd_Msg_Pub.Count_And_Get (
326: p_encoded => Fnd_Api.G_FALSE
327: ,p_count => x_msg_count
328: ,p_data => x_msg_data
330:
331: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
332: ROLLBACK TO Is_Contract_Exist_Then_Create;
333: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
334: -- Standard call to get message count and if count=1, get the message
335: Fnd_Msg_Pub.Count_And_Get (
336: p_encoded => Fnd_Api.G_FALSE
337: ,p_count => x_msg_count
338: ,p_data => x_msg_data
344: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
345: THEN
346: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
347: END IF;
348: -- Standard call to get message count and if count=1, get the message
349: Fnd_Msg_Pub.Count_And_Get (
350: p_encoded => Fnd_Api.G_FALSE
351: ,p_count => x_msg_count
352: ,p_data => x_msg_data