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.XLE_ASSOCIATIONS_PUB dependencies on FND_API

Line 68: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

64:
65: PROCEDURE Create_Association(
66:
67: -- ***** Standard API parameters *****
68: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
69: p_commit IN VARCHAR2 := FND_API.G_FALSE,
70: x_return_status OUT NOCOPY VARCHAR2,
71: x_msg_count OUT NOCOPY NUMBER,
72: x_msg_data OUT NOCOPY VARCHAR2,

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

65: PROCEDURE Create_Association(
66:
67: -- ***** Standard API parameters *****
68: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
69: p_commit IN VARCHAR2 := FND_API.G_FALSE,
70: x_return_status OUT NOCOPY VARCHAR2,
71: x_msg_count OUT NOCOPY NUMBER,
72: x_msg_data OUT NOCOPY VARCHAR2,
73:

Line 123: IF FND_API.to_Boolean( p_init_msg_list ) THEN

119: SAVEPOINT Create_Association_SP;
120:
121:
122: -- **** Initialize message list if p_init_msg_list is set to TRUE. ****
123: IF FND_API.to_Boolean( p_init_msg_list ) THEN
124: FND_MSG_PUB.initialize;
125: END IF;
126:
127:

Line 129: x_return_status := FND_API.G_RET_STS_SUCCESS;

125: END IF;
126:
127:
128: -- **** Initialize return status to SUCCESS *****
129: x_return_status := FND_API.G_RET_STS_SUCCESS;
130:
131:
132: /*-----------------------------------------------+
133: | ======== START OF API BODY ============ |

Line 207: IF FND_API.To_Boolean( p_commit ) THEN

203: | ======== END OF API BODY ============ |
204: +-----------------------------------------------*/
205:
206: -- Standard check of p_commit.
207: IF FND_API.To_Boolean( p_commit ) THEN
208: COMMIT WORK;
209: END IF;
210:
211: -- Standard call to get message count and if count is 1,

Line 219: WHEN FND_API.G_EXC_ERROR THEN

215: p_data => x_msg_data );
216:
217: EXCEPTION
218:
219: WHEN FND_API.G_EXC_ERROR THEN
220: ROLLBACK TO Create_Association_SP;
221: x_return_status := FND_API.G_RET_STS_ERROR;
222: FND_MSG_PUB.Count_And_Get (
223: p_count => x_msg_count,

Line 221: x_return_status := FND_API.G_RET_STS_ERROR;

217: EXCEPTION
218:
219: WHEN FND_API.G_EXC_ERROR THEN
220: ROLLBACK TO Create_Association_SP;
221: x_return_status := FND_API.G_RET_STS_ERROR;
222: FND_MSG_PUB.Count_And_Get (
223: p_count => x_msg_count,
224: p_data => x_msg_data );
225:

Line 226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

222: FND_MSG_PUB.Count_And_Get (
223: p_count => x_msg_count,
224: p_data => x_msg_data );
225:
226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
227: ROLLBACK TO Create_Association_SP;
228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
229: FND_MSG_PUB.Count_And_Get (
230: p_count => x_msg_count,

Line 228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

224: p_data => x_msg_data );
225:
226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
227: ROLLBACK TO Create_Association_SP;
228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
229: FND_MSG_PUB.Count_And_Get (
230: p_count => x_msg_count,
231: p_data => x_msg_data );
232:

Line 235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

231: p_data => x_msg_data );
232:
233: WHEN OTHERS THEN
234: ROLLBACK TO Create_Association_SP;
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
236: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
237: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name);
238: END IF;
239: FND_MSG_PUB.Count_And_Get (

Line 305: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

301:
302: PROCEDURE Update_Association(
303:
304: -- ***** Standard API parameters *****
305: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
306: p_commit IN VARCHAR2 := FND_API.G_FALSE,
307: x_return_status OUT NOCOPY VARCHAR2,
308: x_msg_count OUT NOCOPY NUMBER,
309: x_msg_data OUT NOCOPY VARCHAR2,

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

302: PROCEDURE Update_Association(
303:
304: -- ***** Standard API parameters *****
305: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
306: p_commit IN VARCHAR2 := FND_API.G_FALSE,
307: x_return_status OUT NOCOPY VARCHAR2,
308: x_msg_count OUT NOCOPY NUMBER,
309: x_msg_data OUT NOCOPY VARCHAR2,
310:

Line 358: IF FND_API.to_Boolean( p_init_msg_list ) THEN

354: -- **** Standard start of API savepoint ****
355: SAVEPOINT Update_Association_SP;
356:
357: -- **** Initialize message list if p_init_msg_list is set to TRUE. ****
358: IF FND_API.to_Boolean( p_init_msg_list ) THEN
359: FND_MSG_PUB.initialize;
360: END IF;
361:
362: -- **** Initialize return status to SUCCESS *****

Line 363: x_return_status := FND_API.G_RET_STS_SUCCESS;

359: FND_MSG_PUB.initialize;
360: END IF;
361:
362: -- **** Initialize return status to SUCCESS *****
363: x_return_status := FND_API.G_RET_STS_SUCCESS;
364:
365:
366: /*-----------------------------------------------+
367: | ======== START OF API BODY ============ |

Line 454: IF FND_API.To_Boolean( p_commit ) THEN

450: | ======== END OF API BODY ============ |
451: +-----------------------------------------------*/
452:
453: -- Standard check of p_commit.
454: IF FND_API.To_Boolean( p_commit ) THEN
455: COMMIT WORK;
456: END IF;
457:
458: -- Standard call to get message count and if count is 1,

Line 466: WHEN FND_API.G_EXC_ERROR THEN

462: p_data => x_msg_data );
463:
464: EXCEPTION
465:
466: WHEN FND_API.G_EXC_ERROR THEN
467: ROLLBACK TO Update_Association_SP;
468: x_return_status := FND_API.G_RET_STS_ERROR;
469: FND_MSG_PUB.Count_And_Get (
470: p_count => x_msg_count,

Line 468: x_return_status := FND_API.G_RET_STS_ERROR;

464: EXCEPTION
465:
466: WHEN FND_API.G_EXC_ERROR THEN
467: ROLLBACK TO Update_Association_SP;
468: x_return_status := FND_API.G_RET_STS_ERROR;
469: FND_MSG_PUB.Count_And_Get (
470: p_count => x_msg_count,
471: p_data => x_msg_data );
472:

Line 473: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

469: FND_MSG_PUB.Count_And_Get (
470: p_count => x_msg_count,
471: p_data => x_msg_data );
472:
473: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
474: ROLLBACK TO Update_Association_SP;
475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
476: FND_MSG_PUB.Count_And_Get (
477: p_count => x_msg_count,

Line 475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

471: p_data => x_msg_data );
472:
473: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
474: ROLLBACK TO Update_Association_SP;
475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
476: FND_MSG_PUB.Count_And_Get (
477: p_count => x_msg_count,
478: p_data => x_msg_data );
479:

Line 482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

478: p_data => x_msg_data );
479:
480: WHEN OTHERS THEN
481: ROLLBACK TO Update_Association_SP;
482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
483: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
484: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name);
485: END IF;
486: FND_MSG_PUB.Count_And_Get (