DBA Data[Home] [Help]

APPS.PV_EXT_ENTY_ATTR_VALUE_PVT dependencies on FND_API

Line 28: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

24:
25: -- Hint: Primary key needs to be returned.
26: PROCEDURE Update_Customer_Anual_Revenue(
27: p_api_version_number IN NUMBER
28: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
29: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
30: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
31:
32: ,x_return_status OUT NOCOPY VARCHAR2

Line 29: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

25: -- Hint: Primary key needs to be returned.
26: PROCEDURE Update_Customer_Anual_Revenue(
27: p_api_version_number IN NUMBER
28: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
29: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
30: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
31:
32: ,x_return_status OUT NOCOPY VARCHAR2
33: ,x_msg_count OUT NOCOPY NUMBER

Line 30: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

26: PROCEDURE Update_Customer_Anual_Revenue(
27: p_api_version_number IN NUMBER
28: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
29: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
30: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
31:
32: ,x_return_status OUT NOCOPY VARCHAR2
33: ,x_msg_count OUT NOCOPY NUMBER
34: ,x_msg_data OUT NOCOPY VARCHAR2

Line 78: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

74: -- Standard Start of API savepoint
75: SAVEPOINT Update_Customer_Anual_Revenue;
76:
77: -- Standard call to check for call compatibility.
78: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
79: p_api_version_number,
80: l_api_name,
81: G_PKG_NAME)
82: THEN

Line 83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

79: p_api_version_number,
80: l_api_name,
81: G_PKG_NAME)
82: THEN
83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
84: END IF;
85:
86: -- Initialize message list if p_init_msg_list is set to TRUE.
87: IF FND_API.to_Boolean( p_init_msg_list )

Line 87: IF FND_API.to_Boolean( p_init_msg_list )

83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
84: END IF;
85:
86: -- Initialize message list if p_init_msg_list is set to TRUE.
87: IF FND_API.to_Boolean( p_init_msg_list )
88: THEN
89: FND_MSG_PUB.initialize;
90: END IF;
91:

Line 98: x_return_status := FND_API.G_RET_STS_SUCCESS;

94: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
95: END IF;
96:
97: -- Initialize API return status to SUCCESS
98: x_return_status := FND_API.G_RET_STS_SUCCESS;
99:
100:
101:
102:

Line 114: l_org_rec.curr_fy_potential_revenue := fnd_api.g_miss_num;

110:
111: l_org_rec.curr_fy_potential_revenue := TO_NUMBER(PV_CHECK_MATCH_PUB.Retrieve_Token(':::',p_attr_value,'IN TOKEN',1));
112:
113: if (l_org_rec.curr_fy_potential_revenue is null) then
114: l_org_rec.curr_fy_potential_revenue := fnd_api.g_miss_num;
115: end if;
116:
117: --l_org_rec.curr_fy_potential_revenue := TO_NUMBER(p_attr_value);
118: l_org_rec.pref_functional_currency :=PV_CHECK_MATCH_PUB.Retrieve_Token(':::',p_attr_value,'IN TOKEN',2);

Line 122: l_org_rec.pref_functional_currency := fnd_api.g_miss_char;

118: l_org_rec.pref_functional_currency :=PV_CHECK_MATCH_PUB.Retrieve_Token(':::',p_attr_value,'IN TOKEN',2);
119: l_org_rec.party_rec.party_id :=l_party_id;
120:
121: if (l_org_rec.pref_functional_currency is null) then
122: l_org_rec.pref_functional_currency := fnd_api.g_miss_char;
123: end if;
124:
125:
126: for x in c_get_obj_ver_num (pc_party_id =>l_party_id)

Line 133: p_init_msg_list => FND_API.G_FALSE

129:
130: end loop;
131:
132: HZ_PARTY_V2PUB.update_organization (
133: p_init_msg_list => FND_API.G_FALSE
134: ,p_organization_rec => l_org_rec
135: ,p_party_object_version_number => l_object_version_number
136: ,x_profile_id => x_profile_id
137: ,x_return_status => x_return_status

Line 144: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

140: );
141:
142:
143:
144: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
145: RAISE FND_API.G_EXC_ERROR;
146: END IF;
147: end loop;
148: END IF; -- en of IF(p_entity = 'PARTNER') THEN

Line 145: RAISE FND_API.G_EXC_ERROR;

141:
142:
143:
144: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
145: RAISE FND_API.G_EXC_ERROR;
146: END IF;
147: end loop;
148: END IF; -- en of IF(p_entity = 'PARTNER') THEN
149:

Line 157: IF FND_API.to_Boolean( p_commit )

153: -- End of API body
154: --
155:
156: -- Standard check for p_commit
157: IF FND_API.to_Boolean( p_commit )
158: THEN
159: COMMIT WORK;
160: END IF;
161:

Line 177: x_return_status := FND_API.g_ret_sts_error;

173:
174: EXCEPTION
175: /*
176: WHEN PVX_Utility_PVT.resource_locked THEN
177: x_return_status := FND_API.g_ret_sts_error;
178: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
179: */
180: WHEN FND_API.G_EXC_ERROR THEN
181: ROLLBACK TO Update_Customer_Anual_Revenue;

Line 180: WHEN FND_API.G_EXC_ERROR THEN

176: WHEN PVX_Utility_PVT.resource_locked THEN
177: x_return_status := FND_API.g_ret_sts_error;
178: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
179: */
180: WHEN FND_API.G_EXC_ERROR THEN
181: ROLLBACK TO Update_Customer_Anual_Revenue;
182: x_return_status := FND_API.G_RET_STS_ERROR;
183: -- Standard call to get message count and if count=1, get the message
184: FND_MSG_PUB.Count_And_Get (

Line 182: x_return_status := FND_API.G_RET_STS_ERROR;

178: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
179: */
180: WHEN FND_API.G_EXC_ERROR THEN
181: ROLLBACK TO Update_Customer_Anual_Revenue;
182: x_return_status := FND_API.G_RET_STS_ERROR;
183: -- Standard call to get message count and if count=1, get the message
184: FND_MSG_PUB.Count_And_Get (
185: p_encoded => FND_API.G_FALSE
186: ,p_count => x_msg_count

Line 185: p_encoded => FND_API.G_FALSE

181: ROLLBACK TO Update_Customer_Anual_Revenue;
182: x_return_status := FND_API.G_RET_STS_ERROR;
183: -- Standard call to get message count and if count=1, get the message
184: FND_MSG_PUB.Count_And_Get (
185: p_encoded => FND_API.G_FALSE
186: ,p_count => x_msg_count
187: ,p_data => x_msg_data
188: );
189:

Line 190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

186: ,p_count => x_msg_count
187: ,p_data => x_msg_data
188: );
189:
190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
191: ROLLBACK TO Update_Customer_Anual_Revenue;
192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
193: -- Standard call to get message count and if count=1, get the message
194: FND_MSG_PUB.Count_And_Get (

Line 192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

188: );
189:
190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
191: ROLLBACK TO Update_Customer_Anual_Revenue;
192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
193: -- Standard call to get message count and if count=1, get the message
194: FND_MSG_PUB.Count_And_Get (
195: p_encoded => FND_API.G_FALSE
196: ,p_count => x_msg_count

Line 195: p_encoded => FND_API.G_FALSE

191: ROLLBACK TO Update_Customer_Anual_Revenue;
192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
193: -- Standard call to get message count and if count=1, get the message
194: FND_MSG_PUB.Count_And_Get (
195: p_encoded => FND_API.G_FALSE
196: ,p_count => x_msg_count
197: ,p_data => x_msg_data
198: );
199:

Line 202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

198: );
199:
200: WHEN OTHERS THEN
201: ROLLBACK TO Update_Customer_Anual_Revenue;
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
203: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
204: THEN
205: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
206: END IF;

Line 209: p_encoded => FND_API.G_FALSE

205: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
206: END IF;
207: -- Standard call to get message count and if count=1, get the message
208: FND_MSG_PUB.Count_And_Get (
209: p_encoded => FND_API.G_FALSE
210: ,p_count => x_msg_count
211: ,p_data => x_msg_data
212: );
213: End Update_Customer_Anual_Revenue;