DBA Data[Home] [Help]

APPS.AS_SALES_MEMBER_PUB dependencies on FND_API

Line 34: := FND_API.G_FALSE

30: --
31: PROCEDURE Convert_Partner_to_ID
32: ( p_api_version_number IN NUMBER
33: ,p_init_msg_list IN VARCHAR2
34: := FND_API.G_FALSE
35: ,p_partner_customer_id IN Number
36: ,p_partner_address_id IN Number
37: ,x_return_status OUT NOCOPY /* file.sql.39 change */ Varchar2
38: ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 64: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

60:
61: Begin
62:
63: -- Standard call to check for call compatibility.
64: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
65: p_api_version_number,
66: l_api_name,
67: G_PKG_NAME)
68: THEN

Line 69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

65: p_api_version_number,
66: l_api_name,
67: G_PKG_NAME)
68: THEN
69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
70: END IF;
71:
72:
73: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 74: IF FND_API.to_Boolean( p_init_msg_list ) THEN

70: END IF;
71:
72:
73: -- Initialize message list if p_init_msg_list is set to TRUE.
74: IF FND_API.to_Boolean( p_init_msg_list ) THEN
75: FND_MSG_PUB.initialize;
76: END IF;
77:
78: -- Debug Message

Line 102: x_return_status := FND_API.G_RET_STS_SUCCESS;

98: ,x_sales_member_rec.partner_customer_id;
99: --,x_sales_member_rec.partner_contact_id ;
100: Close Get_Ptr_Salesforce_id;
101:
102: x_return_status := FND_API.G_RET_STS_SUCCESS;
103:
104:
105: -- Standard call to get message count and if count is 1, get message info.
106: FND_MSG_PUB.Count_And_Get

Line 123: x_return_status := FND_API.G_RET_STS_ERROR ;

119: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
120: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_MEMBER_PUB - Cannot Find Sales Partner');
121: END IF;
122:
123: x_return_status := FND_API.G_RET_STS_ERROR ;
124: x_sales_member_rec := G_MISS_SALES_MEMBER_REC;
125:
126: WHEN FND_API.G_EXC_ERROR THEN
127:

Line 126: WHEN FND_API.G_EXC_ERROR THEN

122:
123: x_return_status := FND_API.G_RET_STS_ERROR ;
124: x_sales_member_rec := G_MISS_SALES_MEMBER_REC;
125:
126: WHEN FND_API.G_EXC_ERROR THEN
127:
128: x_return_status := FND_API.G_RET_STS_ERROR ;
129:
130: FND_MSG_PUB.Count_And_Get

Line 128: x_return_status := FND_API.G_RET_STS_ERROR ;

124: x_sales_member_rec := G_MISS_SALES_MEMBER_REC;
125:
126: WHEN FND_API.G_EXC_ERROR THEN
127:
128: x_return_status := FND_API.G_RET_STS_ERROR ;
129:
130: FND_MSG_PUB.Count_And_Get
131: ( p_count => x_msg_count,
132: p_data => x_msg_data

Line 136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

132: p_data => x_msg_data
133: );
134:
135:
136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
137:
138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
139:
140: FND_MSG_PUB.Count_And_Get

Line 138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

134:
135:
136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
137:
138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
139:
140: FND_MSG_PUB.Count_And_Get
141: ( p_count => x_msg_count,
142: p_data => x_msg_data

Line 149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

145:
146: WHEN OTHERS THEN
147:
148:
149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
150:
151: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
152: THEN
153: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 179: := FND_API.G_FALSE,

175: --
176: PROCEDURE Convert_SFID_to_Values
177: ( p_api_version_number IN NUMBER,
178: p_init_msg_list IN VARCHAR2
179: := FND_API.G_FALSE,
180: p_salesforce_id IN NUMBER,
181:
182: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
183: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 208: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

204:
205: BEGIN
206:
207: -- Standard call to check for call compatibility.
208: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
209: p_api_version_number,
210: l_api_name,
211: G_PKG_NAME)
212: THEN

Line 213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

209: p_api_version_number,
210: l_api_name,
211: G_PKG_NAME)
212: THEN
213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
214: END IF;
215:
216:
217: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 218: IF FND_API.to_Boolean( p_init_msg_list ) THEN

214: END IF;
215:
216:
217: -- Initialize message list if p_init_msg_list is set to TRUE.
218: IF FND_API.to_Boolean( p_init_msg_list ) THEN
219: FND_MSG_PUB.initialize;
220: END IF;
221:
222: -- Debug Message

Line 229: x_return_status := FND_API.G_RET_STS_SUCCESS;

225: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_MEMBER_PUB.Convert_SFID_to_Values - BEGIN');
226: END IF;
227:
228: -- Initialize API return status to success
229: x_return_status := FND_API.G_RET_STS_SUCCESS;
230:
231: --
232: -- API body
233: --

Line 299: x_return_status := FND_API.G_RET_STS_ERROR ;

295: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
296: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_MEMBER_PUB Cannot find Salesmember Info');
297: END IF;
298:
299: x_return_status := FND_API.G_RET_STS_ERROR ;
300:
301: FND_MSG_PUB.Count_And_Get
302: ( p_count => x_msg_count,
303: p_data => x_msg_data

Line 312: x_return_status := FND_API.G_RET_STS_SUCCESS;

308:
309: -- End of API body.
310: --
311:
312: x_return_status := FND_API.G_RET_STS_SUCCESS;
313:
314: -- Success Message
315: -- MMSG
316: /*

Line 342: WHEN FND_API.G_EXC_ERROR THEN

338:
339:
340: EXCEPTION
341:
342: WHEN FND_API.G_EXC_ERROR THEN
343:
344: x_return_status := FND_API.G_RET_STS_ERROR ;
345:
346: FND_MSG_PUB.Count_And_Get

Line 344: x_return_status := FND_API.G_RET_STS_ERROR ;

340: EXCEPTION
341:
342: WHEN FND_API.G_EXC_ERROR THEN
343:
344: x_return_status := FND_API.G_RET_STS_ERROR ;
345:
346: FND_MSG_PUB.Count_And_Get
347: ( p_count => x_msg_count,
348: p_data => x_msg_data

Line 352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

348: p_data => x_msg_data
349: );
350:
351:
352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
353:
354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
355:
356: FND_MSG_PUB.Count_And_Get

Line 354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

350:
351:
352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
353:
354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
355:
356: FND_MSG_PUB.Count_And_Get
357: ( p_count => x_msg_count,
358: p_data => x_msg_data

Line 365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

361:
362: WHEN OTHERS THEN
363:
364:
365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
366:
367: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
368: THEN
369: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);