DBA Data[Home] [Help]

APPS.EAM_OBJECTINSTANTIATION_PUB dependencies on FND_API

Line 75: x_return_status := FND_API.G_RET_STS_ERROR;

71: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
72: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_GEN_ID');
73: FND_MSG_PUB.ADD;
74: END IF;
75: x_return_status := FND_API.G_RET_STS_ERROR;
76: FND_MSG_PUB.Count_And_Get
77: ( p_count => x_msg_count ,
78: p_data => x_msg_data
79: );

Line 103: x_return_status := FND_API.G_RET_STS_SUCCESS;

99: p_maintenance_object_type => 3
100: );
101: */
102: -- Assign outputs
103: x_return_status := FND_API.G_RET_STS_SUCCESS;
104: x_msg_count := l_x_msg_count;
105: x_msg_data := l_x_msg_data;
106: x_msg_data := substr(x_msg_data,1,4000);
107:

Line 184: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

180: -- Standard Start of API savepoint
181: SAVEPOINT Instantiate_Object_PUB;
182:
183: -- Standard call to check for call compatibility.
184: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
185: p_api_version ,
186: l_api_name ,
187: G_PKG_NAME )
188: THEN

Line 189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

185: p_api_version ,
186: l_api_name ,
187: G_PKG_NAME )
188: THEN
189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
190: END IF;
191:
192: -- Initialize message list if p_init_msg_list is set to TRUE.
193: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 193: IF FND_API.to_Boolean( p_init_msg_list ) THEN

189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
190: END IF;
191:
192: -- Initialize message list if p_init_msg_list is set to TRUE.
193: IF FND_API.to_Boolean( p_init_msg_list ) THEN
194: FND_MSG_PUB.initialize;
195: END IF;
196:
197: -- Initialize API return status to success

Line 198: x_return_status := FND_API.G_RET_STS_SUCCESS;

194: FND_MSG_PUB.initialize;
195: END IF;
196:
197: -- Initialize API return status to success
198: x_return_status := FND_API.G_RET_STS_SUCCESS;
199:
200: -- API body
201:
202:

Line 209: RAISE FND_API.G_EXC_ERROR;

205: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
206: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_MAINT_OBJ_TYPE');
207: FND_MSG_PUB.ADD;
208: END IF;
209: RAISE FND_API.G_EXC_ERROR;
210: END IF;
211:
212: -- 2: add code when the column is added to MSN
213: -- Check PM_INSTANTIATED flag in MSN, if flag is checked, do nothing and return SUCCESS

Line 305: IF l_x_act_return_status <> FND_API.G_RET_STS_SUCCESS OR

301: || 'l_x_supp_msg_data = ' || l_x_supp_msg_data);
302: end if;
303:
304: -- 5: Procedure call only successful if all sub-procedures returned status success
305: IF l_x_act_return_status <> FND_API.G_RET_STS_SUCCESS OR
306: l_x_pm_return_status <> FND_API.G_RET_STS_SUCCESS OR
307: l_x_supp_return_status <> FND_API.G_RET_STS_SUCCESS
308: THEN
309: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 306: l_x_pm_return_status <> FND_API.G_RET_STS_SUCCESS OR

302: end if;
303:
304: -- 5: Procedure call only successful if all sub-procedures returned status success
305: IF l_x_act_return_status <> FND_API.G_RET_STS_SUCCESS OR
306: l_x_pm_return_status <> FND_API.G_RET_STS_SUCCESS OR
307: l_x_supp_return_status <> FND_API.G_RET_STS_SUCCESS
308: THEN
309: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
310: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INST_API_FAILED');

Line 307: l_x_supp_return_status <> FND_API.G_RET_STS_SUCCESS

303:
304: -- 5: Procedure call only successful if all sub-procedures returned status success
305: IF l_x_act_return_status <> FND_API.G_RET_STS_SUCCESS OR
306: l_x_pm_return_status <> FND_API.G_RET_STS_SUCCESS OR
307: l_x_supp_return_status <> FND_API.G_RET_STS_SUCCESS
308: THEN
309: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
310: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INST_API_FAILED');
311: FND_MSG_PUB.ADD;

Line 313: RAISE FND_API.G_EXC_ERROR;

309: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
310: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INST_API_FAILED');
311: FND_MSG_PUB.ADD;
312: END IF;
313: RAISE FND_API.G_EXC_ERROR;
314: END IF;
315:
316: -- 6:Set PM_INSTANTIATED flag in MSN
317: UPDATE csi_item_instances

Line 364: IF FND_API.To_Boolean( p_commit ) THEN

360: );
361:
362: -- End of API body.
363: -- Standard check of p_commit.
364: IF FND_API.To_Boolean( p_commit ) THEN
365: COMMIT WORK;
366: END IF;
367: -- Standard call to get message count and if count is 1, get message info.
368: FND_MSG_PUB.Count_And_Get

Line 379: WHEN FND_API.G_EXC_ERROR THEN

375: '==================== Exiting EAM_ObjectInstantiation_PUB.Instantiate_Object ====================');
376: end if;
377:
378: EXCEPTION
379: WHEN FND_API.G_EXC_ERROR THEN
380: ROLLBACK TO Instantiate_Object_PUB;
381:
382: if (l_exlog) then FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,
383: '==================== EAM_ObjectInstantiation_PUB.Instantiate_Object: EXPECTED ERROR ====================');

Line 386: x_return_status := FND_API.G_RET_STS_ERROR ;

382: if (l_exlog) then FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,
383: '==================== EAM_ObjectInstantiation_PUB.Instantiate_Object: EXPECTED ERROR ====================');
384: end if;
385:
386: x_return_status := FND_API.G_RET_STS_ERROR ;
387:
388: FND_MSG_PUB.Count_And_Get
389: ( p_count => x_msg_count ,
390: p_data => x_msg_data

Line 395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

391: );
392:
393: x_msg_data := substr(x_msg_data,1,4000);
394:
395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
396: ROLLBACK TO Instantiate_Object_PUB;
397:
398: if (l_exlog) then FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,
399: '==================== EAM_ObjectInstantiation_PUB.Instantiate_Object: UNEXPECTED ERROR ====================');

Line 402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

398: if (l_exlog) then FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,
399: '==================== EAM_ObjectInstantiation_PUB.Instantiate_Object: UNEXPECTED ERROR ====================');
400: end if;
401:
402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
403:
404: FND_MSG_PUB.Count_And_Get
405: ( p_count => x_msg_count ,
406: p_data => x_msg_data

Line 418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

414: if (l_exlog) then FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,
415: '==================== EAM_ObjectInstantiation_PUB.Instantiate_Object: OTHER ERROR ====================');
416: end if;
417:
418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
419:
420: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
421: THEN
422: FND_MSG_PUB.Add_Exc_Msg