eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_ASSETATTR_GRP_PUB dependencies on FND_API

Line 15: -- DEFAULT = FND_API.G_FALSE

11: /* This procedure inserts a record in the mtl_eam_asset_attr_groups table
12: -- Parameters :
13: -- IN : P_API_VERSION IN NUMBER REQUIRED
14: -- P_INIT_MSG_LIST IN VARCHAR2 OPTIONAL
15: -- DEFAULT = FND_API.G_FALSE
16: -- P_COMMIT IN VARCHAR2 OPTIONAL
17: -- DEFAULT = FND_API.G_FALSE
18: -- P_VALIDATION_LEVEL IN NUMBER OPTIONAL
19: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL

Line 17: -- DEFAULT = FND_API.G_FALSE

13: -- IN : P_API_VERSION IN NUMBER REQUIRED
14: -- P_INIT_MSG_LIST IN VARCHAR2 OPTIONAL
15: -- DEFAULT = FND_API.G_FALSE
16: -- P_COMMIT IN VARCHAR2 OPTIONAL
17: -- DEFAULT = FND_API.G_FALSE
18: -- P_VALIDATION_LEVEL IN NUMBER OPTIONAL
19: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL
20: -- P_APPLICATION_ID IN NUMBER
21: -- P_DESCRIPTIVE_FLEXFIELD_NAME IN VARCHAR2

Line 19: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL

15: -- DEFAULT = FND_API.G_FALSE
16: -- P_COMMIT IN VARCHAR2 OPTIONAL
17: -- DEFAULT = FND_API.G_FALSE
18: -- P_VALIDATION_LEVEL IN NUMBER OPTIONAL
19: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL
20: -- P_APPLICATION_ID IN NUMBER
21: -- P_DESCRIPTIVE_FLEXFIELD_NAME IN VARCHAR2
22: -- DEFAULT NULL
23: -- P_DESC_FLEX_CONTEXT_CODE IN VARCHAR2

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

43: /*g_sr_no number ;*/
44:
45: PROCEDURE INSERT_ASSETATTR_GRP
46: ( P_API_VERSION IN NUMBER ,
47: P_INIT_MSG_LIST IN VARCHAR2:= FND_API.G_FALSE ,
48: P_COMMIT IN VARCHAR2:= FND_API.G_FALSE ,
49: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
50: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
51: X_MSG_COUNT OUT NOCOPY NUMBER ,

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

44:
45: PROCEDURE INSERT_ASSETATTR_GRP
46: ( P_API_VERSION IN NUMBER ,
47: P_INIT_MSG_LIST IN VARCHAR2:= FND_API.G_FALSE ,
48: P_COMMIT IN VARCHAR2:= FND_API.G_FALSE ,
49: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
50: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
51: X_MSG_COUNT OUT NOCOPY NUMBER ,
52: X_MSG_DATA OUT NOCOPY VARCHAR2 ,

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

45: PROCEDURE INSERT_ASSETATTR_GRP
46: ( P_API_VERSION IN NUMBER ,
47: P_INIT_MSG_LIST IN VARCHAR2:= FND_API.G_FALSE ,
48: P_COMMIT IN VARCHAR2:= FND_API.G_FALSE ,
49: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
50: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
51: X_MSG_COUNT OUT NOCOPY NUMBER ,
52: X_MSG_DATA OUT NOCOPY VARCHAR2 ,
53: P_APPLICATION_ID IN NUMBER DEFAULT 401 ,

Line 82: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

78: /* Standard Start of API savepoint */
79: SAVEPOINT INSERT_ASSETATTR_GRP_PUB;
80:
81: /* Standard call to check for call compatibility. */
82: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
83: p_api_version ,
84: l_api_name ,
85: G_PKG_NAME
86: )

Line 88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

84: l_api_name ,
85: G_PKG_NAME
86: )
87: THEN
88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
89: END IF;
90:
91: /* Initialize message list if p_init_msg_list is set to TRUE. */
92: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 92: IF FND_API.to_Boolean( p_init_msg_list ) THEN

88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
89: END IF;
90:
91: /* Initialize message list if p_init_msg_list is set to TRUE. */
92: IF FND_API.to_Boolean( p_init_msg_list ) THEN
93: FND_MSG_PUB.initialize;
94: END IF;
95:
96: /* Initialize API return status to success */

Line 97: x_return_status := FND_API.G_RET_STS_SUCCESS;

93: FND_MSG_PUB.initialize;
94: END IF;
95:
96: /* Initialize API return status to success */
97: x_return_status := FND_API.G_RET_STS_SUCCESS;
98:
99: /* API body */
100: /* Start validation calls */
101:

Line 109: RAISE fnd_api.g_exc_error;

105: if (P_CREATION_ORGANIZATION_ID IS NOT NULL) then
106: if P_CREATION_ORGANIZATION_ID <> P_ORGANIZATION_ID then
107: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_CR_ORG_ID');
108: fnd_msg_pub.add;
109: RAISE fnd_api.g_exc_error;
110: else
111: l_creation_organization_id := P_ORGANIZATION_ID;
112: end if;
113: else

Line 130: RAISE fnd_api.g_exc_error;

126: if l_boolean = 0
127: then
128: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_ORG_ID');
129: fnd_msg_pub.add;
130: RAISE fnd_api.g_exc_error;
131: end if;
132: end if;
133:
134: /* validate item id; get item type */

Line 244: IF FND_API.TO_BOOLEAN( P_COMMIT ) THEN

240: p_creation_organization_id
241: );
242:
243: /* Standard check of p_commit. */
244: IF FND_API.TO_BOOLEAN( P_COMMIT ) THEN
245: COMMIT WORK;
246: END IF;
247: -- Standard call to get message count and if count is 1, get message info.
248: FND_MSG_PUB.GET

Line 254: WHEN FND_API.G_EXC_ERROR THEN

250: p_data => x_msg_data
251: );
252:
253: EXCEPTION
254: WHEN FND_API.G_EXC_ERROR THEN
255: ROLLBACK TO INSERT_ASSETATTR_GRP_PUB;
256: x_return_status := FND_API.G_RET_STS_ERROR ;
257: FND_MSG_PUB.Get
258: ( p_msg_index_out => x_msg_count ,

Line 256: x_return_status := FND_API.G_RET_STS_ERROR ;

252:
253: EXCEPTION
254: WHEN FND_API.G_EXC_ERROR THEN
255: ROLLBACK TO INSERT_ASSETATTR_GRP_PUB;
256: x_return_status := FND_API.G_RET_STS_ERROR ;
257: FND_MSG_PUB.Get
258: ( p_msg_index_out => x_msg_count ,
259: p_data => x_msg_data
260: );

Line 262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

258: ( p_msg_index_out => x_msg_count ,
259: p_data => x_msg_data
260: );
261:
262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
263: ROLLBACK TO INSERT_ASSETATTR_GRP_PUB;
264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
265: FND_MSG_PUB.get
266: ( p_msg_index_out => x_msg_count ,

Line 264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

260: );
261:
262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
263: ROLLBACK TO INSERT_ASSETATTR_GRP_PUB;
264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
265: FND_MSG_PUB.get
266: ( p_msg_index_out => x_msg_count ,
267: p_data => x_msg_data
268: );

Line 272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

268: );
269:
270: WHEN OTHERS THEN
271: ROLLBACK TO INSERT_ASSETATTR_GRP_PUB;
272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
273:
274: IF FND_MSG_PUB.Check_Msg_Level
275: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
276: THEN

Line 295: -- DEFAULT = FND_API.G_FALSE

291: This procedure updates a record in the mtl_eam_asset_attr_groups table
292: -- Parameters :
293: -- IN : P_API_VERSION IN NUMBER REQUIRED
294: -- P_INIT_MSG_LIST IN VARCHAR2 OPTIONAL
295: -- DEFAULT = FND_API.G_FALSE
296: -- P_COMMIT IN VARCHAR2 OPTIONAL
297: -- DEFAULT = FND_API.G_FALSE
298: -- P_VALIDATION_LEVEL IN NUMBER OPTIONAL
299: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL

Line 297: -- DEFAULT = FND_API.G_FALSE

293: -- IN : P_API_VERSION IN NUMBER REQUIRED
294: -- P_INIT_MSG_LIST IN VARCHAR2 OPTIONAL
295: -- DEFAULT = FND_API.G_FALSE
296: -- P_COMMIT IN VARCHAR2 OPTIONAL
297: -- DEFAULT = FND_API.G_FALSE
298: -- P_VALIDATION_LEVEL IN NUMBER OPTIONAL
299: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL
300: -- P_APPLICATION_ID IN NUMBER
301: -- P_DESCRIPTIVE_FLEXFIELD_NAME IN VARCHAR2

Line 299: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL

295: -- DEFAULT = FND_API.G_FALSE
296: -- P_COMMIT IN VARCHAR2 OPTIONAL
297: -- DEFAULT = FND_API.G_FALSE
298: -- P_VALIDATION_LEVEL IN NUMBER OPTIONAL
299: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL
300: -- P_APPLICATION_ID IN NUMBER
301: -- P_DESCRIPTIVE_FLEXFIELD_NAME IN VARCHAR2
302: -- DEFAULT NULL
303: -- P_DESC_FLEX_CONTEXT_CODE IN VARCHAR2

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

318: */
319:
320: PROCEDURE UPDATE_ASSETATTR_GRP
321: ( P_API_VERSION IN NUMBER ,
322: P_INIT_MSG_LIST IN VARCHAR2:= FND_API.G_FALSE ,
323: P_COMMIT IN VARCHAR2:= FND_API.G_FALSE ,
324: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
325: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
326: X_MSG_COUNT OUT NOCOPY NUMBER ,

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

319:
320: PROCEDURE UPDATE_ASSETATTR_GRP
321: ( P_API_VERSION IN NUMBER ,
322: P_INIT_MSG_LIST IN VARCHAR2:= FND_API.G_FALSE ,
323: P_COMMIT IN VARCHAR2:= FND_API.G_FALSE ,
324: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
325: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
326: X_MSG_COUNT OUT NOCOPY NUMBER ,
327: X_MSG_DATA OUT NOCOPY VARCHAR2 ,

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

320: PROCEDURE UPDATE_ASSETATTR_GRP
321: ( P_API_VERSION IN NUMBER ,
322: P_INIT_MSG_LIST IN VARCHAR2:= FND_API.G_FALSE ,
323: P_COMMIT IN VARCHAR2:= FND_API.G_FALSE ,
324: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
325: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
326: X_MSG_COUNT OUT NOCOPY NUMBER ,
327: X_MSG_DATA OUT NOCOPY VARCHAR2 ,
328: P_ASSOCIATION_ID IN NUMBER ,

Line 350: x_return_status := FND_API.G_RET_STS_SUCCESS;

346:
347: BEGIN
348:
349: SAVEPOINT UPDATE_ASSETATTR_GRP_PUB;
350: x_return_status := FND_API.G_RET_STS_SUCCESS;
351: --x_return_status := 'success';
352:
353: /* API body */
354: /* Start validation calls */

Line 362: RAISE fnd_api.g_exc_error;

358: if (P_CREATION_ORGANIZATION_ID IS NOT NULL) then
359: if P_CREATION_ORGANIZATION_ID <> P_ORGANIZATION_ID then
360: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_CR_ORG_ID');
361: fnd_msg_pub.add;
362: RAISE fnd_api.g_exc_error;
363: else
364: l_creation_organization_id := P_ORGANIZATION_ID;
365: end if;
366: else

Line 383: RAISE fnd_api.g_exc_error;

379: if l_boolean = 0
380: then
381: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_ORG_ID');
382: fnd_msg_pub.add;
383: RAISE fnd_api.g_exc_error;
384: end if;
385: end if;
386:
387: /* validate inventory item id; get item type */

Line 473: IF FND_API.TO_BOOLEAN( P_COMMIT ) THEN

469: and descriptive_flex_context_code=p_desc_flex_context_code;
470:
471:
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_ASSETATTR_GRP_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_ASSETATTR_GRP_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_ASSETATTR_GRP_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_ASSETATTR_GRP_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_ASSETATTR_GRP_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 706: RAISE FND_API.G_EXC_ERROR;

702: IS
703: BEGIN
704: FND_MESSAGE.SET_NAME ('EAM', ERROR);
705: FND_MSG_PUB.ADD;
706: RAISE FND_API.G_EXC_ERROR;
707:
708: END;
709:
710: PROCEDURE print_log(info varchar2) is