DBA Data[Home] [Help]

APPS.EAM_ACTIVITYSUPN_PUB dependencies on FND_API

Line 19: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE ,

15: /*
16: This procedure inserts a record in the eam_suppression_relations table
17: Parameters :
18: IN : P_API_VERSION IN NUMBER ,
19: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE ,
20: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE ,
21: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
22: P_PARENT_ASSOCIATION_ID IN NUMBER ,
23: P_CHILD_ASSOCIATION_ID IN NUMBER ,

Line 20: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE ,

16: This procedure inserts a record in the eam_suppression_relations table
17: Parameters :
18: IN : P_API_VERSION IN NUMBER ,
19: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE ,
20: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE ,
21: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
22: P_PARENT_ASSOCIATION_ID IN NUMBER ,
23: P_CHILD_ASSOCIATION_ID IN NUMBER ,
24: P_TMPL_FLAG IN VARCHAR2 DEFAULT NULL,

Line 21: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

17: Parameters :
18: IN : P_API_VERSION IN NUMBER ,
19: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE ,
20: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE ,
21: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
22: P_PARENT_ASSOCIATION_ID IN NUMBER ,
23: P_CHILD_ASSOCIATION_ID IN NUMBER ,
24: P_TMPL_FLAG IN VARCHAR2 DEFAULT NULL,
25: P_DESCRIPTION IN VARCHAR2 DEFAULT NULL,

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

49:
50: PROCEDURE Insert_ActivitySupn
51: (
52: p_api_version IN NUMBER ,
53: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
54: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
55: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
56: x_return_status OUT NOCOPY VARCHAR2 ,
57: x_msg_count OUT NOCOPY NUMBER ,

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

50: PROCEDURE Insert_ActivitySupn
51: (
52: p_api_version IN NUMBER ,
53: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
54: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
55: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
56: x_return_status OUT NOCOPY VARCHAR2 ,
57: x_msg_count OUT NOCOPY NUMBER ,
58: x_msg_data OUT NOCOPY VARCHAR2 ,

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

51: (
52: p_api_version IN NUMBER ,
53: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
54: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
55: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
56: x_return_status OUT NOCOPY VARCHAR2 ,
57: x_msg_count OUT NOCOPY NUMBER ,
58: x_msg_data OUT NOCOPY VARCHAR2 ,
59: p_parent_association_id IN NUMBER ,

Line 92: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

88: /* Standard Start of API savepoint */
89: SAVEPOINT Insert_ActivitySupn_PUB;
90:
91: /* Standard call to check for call compatibility. */
92: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
93: p_api_version ,
94: l_api_name ,
95: G_PKG_NAME
96: )

Line 98: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

94: l_api_name ,
95: G_PKG_NAME
96: )
97: THEN
98: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
99: END IF;
100:
101: /* Initialize message list if p_init_msg_list is set to TRUE. */
102: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 102: IF FND_API.to_Boolean( p_init_msg_list ) THEN

98: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
99: END IF;
100:
101: /* Initialize message list if p_init_msg_list is set to TRUE. */
102: IF FND_API.to_Boolean( p_init_msg_list ) THEN
103: FND_MSG_PUB.initialize;
104: END IF;
105: /* Initialize API return status to success */
106: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 106: x_return_status := FND_API.G_RET_STS_SUCCESS;

102: IF FND_API.to_Boolean( p_init_msg_list ) THEN
103: FND_MSG_PUB.initialize;
104: END IF;
105: /* Initialize API return status to success */
106: x_return_status := FND_API.G_RET_STS_SUCCESS;
107:
108: /* API body */
109:
110: /* Start validation calls */

Line 178: RAISE FND_API.G_EXC_ERROR;

174:
175: FND_MESSAGE.SET_NAME('EAM', 'EAM_INVALID_DESC_FLEX');
176: FND_MESSAGE.SET_TOKEN('ERROR_MSG', x_error_message);
177: FND_MSG_PUB.Add;
178: RAISE FND_API.G_EXC_ERROR;
179:
180: END IF;
181:
182: /* Validate the parent and childs asset-activity combination does not exists */

Line 255: IF FND_API.TO_BOOLEAN( P_COMMIT ) THEN

251: p_attribute15
252: );
253:
254: /* Standard check of p_commit. */
255: IF FND_API.TO_BOOLEAN( P_COMMIT ) THEN
256: COMMIT WORK;
257: END IF;
258: -- Standard call to get message count and if count is 1, get message info.
259: FND_MSG_PUB.get

Line 265: WHEN FND_API.G_EXC_ERROR THEN

261: p_data => x_msg_data
262: );
263:
264: EXCEPTION
265: WHEN FND_API.G_EXC_ERROR THEN
266: ROLLBACK TO Insert_ActivitySupn_PUB;
267: x_return_status := FND_API.G_RET_STS_ERROR ;
268: FND_MSG_PUB.get
269: ( p_msg_index_out => x_msg_count ,

Line 267: x_return_status := FND_API.G_RET_STS_ERROR ;

263:
264: EXCEPTION
265: WHEN FND_API.G_EXC_ERROR THEN
266: ROLLBACK TO Insert_ActivitySupn_PUB;
267: x_return_status := FND_API.G_RET_STS_ERROR ;
268: FND_MSG_PUB.get
269: ( p_msg_index_out => x_msg_count ,
270: p_data => x_msg_data
271: );

Line 273: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

269: ( p_msg_index_out => x_msg_count ,
270: p_data => x_msg_data
271: );
272:
273: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
274: ROLLBACK TO Insert_ActivitySupn_PUB;
275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
276: FND_MSG_PUB.get
277: ( p_msg_index_out => x_msg_count ,

Line 275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

271: );
272:
273: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
274: ROLLBACK TO Insert_ActivitySupn_PUB;
275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
276: FND_MSG_PUB.get
277: ( p_msg_index_out => x_msg_count ,
278: p_data => x_msg_data
279: );

Line 283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

279: );
280:
281: WHEN OTHERS THEN
282: ROLLBACK TO Insert_ActivitySupn_PUB;
283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
284:
285: IF FND_MSG_PUB.Check_Msg_Level
286: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
287: THEN

Line 306: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE ,

302: /*
303: This procedure updates a record in the eam_asset_meters table
304: Parameters :
305: IN : P_API_VERSION IN NUMBER ,
306: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE ,
307: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE ,
308: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
309: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
310: X_MSG_COUNT OUT NOCOPY NUMBER ,

Line 307: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE ,

303: This procedure updates a record in the eam_asset_meters table
304: Parameters :
305: IN : P_API_VERSION IN NUMBER ,
306: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE ,
307: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE ,
308: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
309: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
310: X_MSG_COUNT OUT NOCOPY NUMBER ,
311: X_MSG_DATA OUT NOCOPY VARCHAR2 ,

Line 308: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

304: Parameters :
305: IN : P_API_VERSION IN NUMBER ,
306: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE ,
307: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE ,
308: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
309: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
310: X_MSG_COUNT OUT NOCOPY NUMBER ,
311: X_MSG_DATA OUT NOCOPY VARCHAR2 ,
312: P_PARENT_ASSOCIATION_ID IN NUMBER ,

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

339: */
340: PROCEDURE Update_ActivitySupn
341: (
342: p_api_version IN NUMBER ,
343: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
344: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
345: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
346: x_return_status OUT NOCOPY VARCHAR2 ,
347: x_msg_count OUT NOCOPY NUMBER ,

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

340: PROCEDURE Update_ActivitySupn
341: (
342: p_api_version IN NUMBER ,
343: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
344: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
345: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
346: x_return_status OUT NOCOPY VARCHAR2 ,
347: x_msg_count OUT NOCOPY NUMBER ,
348: x_msg_data OUT NOCOPY VARCHAR2 ,

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

341: (
342: p_api_version IN NUMBER ,
343: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
344: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
345: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
346: x_return_status OUT NOCOPY VARCHAR2 ,
347: x_msg_count OUT NOCOPY NUMBER ,
348: x_msg_data OUT NOCOPY VARCHAR2 ,
349: p_parent_association_id IN NUMBER ,

Line 381: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

377:
378: /* Standard Start of API savepoint */
379: SAVEPOINT Update_ActivitySupn_PUB;
380: /* Standard call to check for call compatibility. */
381: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
382: p_api_version ,
383: l_api_name ,
384: G_PKG_NAME
385: )

Line 387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

383: l_api_name ,
384: G_PKG_NAME
385: )
386: THEN
387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
388: END IF;
389:
390: /* Initialize message list if p_init_msg_list is set to TRUE. */
391: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 391: IF FND_API.to_Boolean( p_init_msg_list ) THEN

387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
388: END IF;
389:
390: /* Initialize message list if p_init_msg_list is set to TRUE. */
391: IF FND_API.to_Boolean( p_init_msg_list ) THEN
392: FND_MSG_PUB.initialize;
393: END IF;
394: /* Initialize API return status to success */
395: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 395: x_return_status := FND_API.G_RET_STS_SUCCESS;

391: IF FND_API.to_Boolean( p_init_msg_list ) THEN
392: FND_MSG_PUB.initialize;
393: END IF;
394: /* Initialize API return status to success */
395: x_return_status := FND_API.G_RET_STS_SUCCESS;
396:
397: /* API body */
398: /* validation calls */
399: l_validated := Validate_SuppressionRecord (p_parent_association_id,

Line 434: RAISE FND_API.G_EXC_ERROR;

430: IF (not l_validated) THEN
431: FND_MESSAGE.SET_NAME('EAM', 'EAM_INVALID_DESC_FLEX');
432: FND_MESSAGE.SET_TOKEN('ERROR_MSG', x_error_message);
433: FND_MSG_PUB.Add;
434: RAISE FND_API.G_EXC_ERROR;
435: END IF;
436: END IF;
437:
438: l_validated := eam_pm_suppressions.check_no_loop (p_parent_association_id,

Line 473: IF FND_API.TO_BOOLEAN( P_COMMIT ) THEN

469: parent_association_id = p_parent_association_id
470: AND
471: child_association_id = p_child_association_id ;
472: /* Standard check of p_commit. */
473: IF FND_API.TO_BOOLEAN( P_COMMIT ) THEN
474: COMMIT WORK;
475: END IF;
476: -- Standard call to get message count and if count is 1, get message info.
477: FND_MSG_PUB.get

Line 483: WHEN FND_API.G_EXC_ERROR THEN

479: p_data => x_msg_data
480: );
481:
482: EXCEPTION
483: WHEN FND_API.G_EXC_ERROR THEN
484: ROLLBACK TO Update_ActivitySupn_PUB;
485: x_return_status := FND_API.G_RET_STS_ERROR ;
486: FND_MSG_PUB.get
487: ( p_msg_index_out => x_msg_count ,

Line 485: x_return_status := FND_API.G_RET_STS_ERROR ;

481:
482: EXCEPTION
483: WHEN FND_API.G_EXC_ERROR THEN
484: ROLLBACK TO Update_ActivitySupn_PUB;
485: x_return_status := FND_API.G_RET_STS_ERROR ;
486: FND_MSG_PUB.get
487: ( p_msg_index_out => x_msg_count ,
488: p_data => x_msg_data
489: );

Line 491: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

487: ( p_msg_index_out => x_msg_count ,
488: p_data => x_msg_data
489: );
490:
491: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
492: ROLLBACK TO Update_ActivitySupn_PUB;
493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
494: FND_MSG_PUB.get
495: ( p_msg_index_out => x_msg_count ,

Line 493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

489: );
490:
491: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
492: ROLLBACK TO Update_ActivitySupn_PUB;
493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
494: FND_MSG_PUB.get
495: ( p_msg_index_out => x_msg_count ,
496: p_data => x_msg_data
497: );

Line 501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

497: );
498:
499: WHEN OTHERS THEN
500: ROLLBACK TO Update_ActivitySupn_PUB;
501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
502:
503: IF FND_MSG_PUB.Check_Msg_Level
504: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
505: THEN

Line 547: p_init_msg_list => FND_API.G_FALSE,

543: eam_common_utilities_pvt.verify_org (
544: p_resp_id => NULL,
545: p_resp_app_id => 401,
546: p_org_id => p_organization_id,
547: p_init_msg_list => FND_API.G_FALSE,
548: x_boolean => l_boolean,
549: x_return_status => l_return_status,
550: x_msg_count => l_msg_count,
551: x_msg_data => l_msg_data);

Line 552: /* x_return_status := fnd_api.g_ret_sts_success; */

548: x_boolean => l_boolean,
549: x_return_status => l_return_status,
550: x_msg_count => l_msg_count,
551: x_msg_data => l_msg_data);
552: /* x_return_status := fnd_api.g_ret_sts_success; */
553: IF (l_return_status = fnd_api.g_ret_sts_success) THEN
554: RETURN true;
555: ELSE
556: RETURN false;

Line 553: IF (l_return_status = fnd_api.g_ret_sts_success) THEN

549: x_return_status => l_return_status,
550: x_msg_count => l_msg_count,
551: x_msg_data => l_msg_data);
552: /* x_return_status := fnd_api.g_ret_sts_success; */
553: IF (l_return_status = fnd_api.g_ret_sts_success) THEN
554: RETURN true;
555: ELSE
556: RETURN false;
557: END IF;

Line 750: RAISE FND_API.G_EXC_ERROR;

746: IS
747: BEGIN
748: FND_MESSAGE.SET_NAME ('EAM', ERROR);
749: FND_MSG_PUB.ADD;
750: RAISE FND_API.G_EXC_ERROR;
751: END;
752:
753: PROCEDURE print_log(info varchar2) is
754: PRAGMA AUTONOMOUS_TRANSACTION;