[Home] [Help]
22: -- to communicate any changes (inserts/updates/deletes) to the
23: -- Order Entities to Oracle Order Capture application.
24: -- Pre-reqs : None.
25: --
26: -- Standard IN Parameters:
27: -- p_api_version IN NUMBER Required
28: -- p_init_msg_list IN VARCHAR2 Optional
29: -- Default = FND_API.G_FALSE
30: -- p_commit IN VARCHAR2 Optional
29: -- Default = FND_API.G_FALSE
30: -- p_commit IN VARCHAR2 Optional
31: -- Default = FND_API.G_FALSE
32: --
33: -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:
34: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2(1)
35: -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
36: -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2(2000)
37: --
202: l_request_var_type SYSTEM.ASO_Request_Var_Type;
203: l_aso_order_feedback_type SYSTEM.ASO_ORDER_FEEDBACK_TYPE;
204: BEGIN
205:
206: -- Standard Start of API savepoint
207:
208: SAVEPOINT UPDATE_NOTICE_PVT;
209:
210: -- Standard call to check for call compatibility.
206: -- Standard Start of API savepoint
207:
208: SAVEPOINT UPDATE_NOTICE_PVT;
209:
210: -- Standard call to check for call compatibility.
211:
212: IF NOT FND_API.Compatible_API_Call (l_api_version ,
213: p_api_version ,
214: l_api_name ,
311: );
312:
313: -- End of API Body
314:
315: -- Standard check of p_commit.
316:
317: IF FND_API.To_Boolean( p_commit ) THEN
318: COMMIT WORK;
319: END IF;
317: IF FND_API.To_Boolean( p_commit ) THEN
318: COMMIT WORK;
319: END IF;
320:
321: -- Standard call to get message count and if count is 1, get message info.
322:
323: FND_MSG_PUB.Count_And_Get
324: (p_count => x_msg_count ,
325: p_data => x_msg_data