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

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

9: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
10:
11: PROCEDURE INSERT_DEP_OBJECT(
12: p_api_version IN NUMBER,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15:
16: p_object_id OUT NOCOPY fnd_imp_depobjects.object_id%TYPE,
17: p_snapshot_id IN fnd_imp_depobjects.snapshot_id%TYPE,

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

10:
11: PROCEDURE INSERT_DEP_OBJECT(
12: p_api_version IN NUMBER,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15:
16: p_object_id OUT NOCOPY fnd_imp_depobjects.object_id%TYPE,
17: p_snapshot_id IN fnd_imp_depobjects.snapshot_id%TYPE,
18: p_object_name IN fnd_imp_depobjects.object_name%TYPE,

Line 56: IF NOT FND_API.Compatible_API_Call (

52: -- Standard Start of API savepoint
53: SAVEPOINT INSERT_DEP_OBJECT;
54:
55: -- Standard call to check for call compatibility.
56: IF NOT FND_API.Compatible_API_Call (
57: l_api_version,
58: p_api_version,
59: l_api_name,
60: G_PKG_NAME)

Line 62: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

58: p_api_version,
59: l_api_name,
60: G_PKG_NAME)
61: THEN
62: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
63: END IF;
64:
65: -- Initialize message list if p_init_msg_list is set to TRUE.
66: IF FND_API.To_Boolean( p_init_msg_list ) THEN

Line 66: IF FND_API.To_Boolean( p_init_msg_list ) THEN

62: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
63: END IF;
64:
65: -- Initialize message list if p_init_msg_list is set to TRUE.
66: IF FND_API.To_Boolean( p_init_msg_list ) THEN
67: FND_MSG_PUB.initialize;
68: END IF;
69:
70: -- Initialize API return status to success

Line 71: x_return_status := FND_API.G_RET_STS_SUCCESS;

67: FND_MSG_PUB.initialize;
68: END IF;
69:
70: -- Initialize API return status to success
71: x_return_status := FND_API.G_RET_STS_SUCCESS;
72:
73: -- real logic --
74: ----------------
75:

Line 87: IF (FND_API.To_Boolean(p_commit)) THEN

83: -----------------------
84: -- end of real logic --
85:
86: -- Standard check of p_commit.
87: IF (FND_API.To_Boolean(p_commit)) THEN
88: COMMIT WORK;
89: END IF;
90:
91: -- Standard call to get message count and if count is 1, get message info.

Line 97: WHEN FND_API.G_EXC_ERROR THEN

93: p_count => x_msg_count,
94: p_data => x_msg_data );
95:
96: EXCEPTION
97: WHEN FND_API.G_EXC_ERROR THEN
98: ROLLBACK TO INSERT_DEP_OBJECT;
99: x_return_status := FND_API.G_RET_STS_ERROR ;
100:
101: OPEN sequence_cursor;

Line 99: x_return_status := FND_API.G_RET_STS_ERROR ;

95:
96: EXCEPTION
97: WHEN FND_API.G_EXC_ERROR THEN
98: ROLLBACK TO INSERT_DEP_OBJECT;
99: x_return_status := FND_API.G_RET_STS_ERROR ;
100:
101: OPEN sequence_cursor;
102: FETCH sequence_cursor INTO p_object_id;
103: CLOSE sequence_cursor;

Line 167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

163: FND_MSG_PUB.Count_And_Get(
164: p_count => x_msg_count,
165: p_data => x_msg_data );
166:
167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
168: ROLLBACK TO INSERT_DEP_OBJECT;
169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
170:
171: OPEN sequence_cursor;

Line 169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

165: p_data => x_msg_data );
166:
167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
168: ROLLBACK TO INSERT_DEP_OBJECT;
169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
170:
171: OPEN sequence_cursor;
172: FETCH sequence_cursor INTO p_object_id;
173: CLOSE sequence_cursor;

Line 239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

235: p_data => x_msg_data );
236:
237: WHEN OTHERS THEN
238: ROLLBACK TO INSERT_DEP_OBJECT;
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
240:
241: OPEN sequence_cursor;
242: FETCH sequence_cursor INTO p_object_id;
243: CLOSE sequence_cursor;

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

311: END INSERT_DEP_OBJECT;
312:
313: PROCEDURE INSERT_DEP_RELATION(
314: p_api_version IN NUMBER,
315: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
316: p_commit IN VARCHAR2 := FND_API.G_FALSE,
317:
318: p_parent_object_id OUT NOCOPY fnd_imp_depobjects.object_id%TYPE,
319: p_child_object_id OUT NOCOPY fnd_imp_depobjects.object_id%TYPE,

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

312:
313: PROCEDURE INSERT_DEP_RELATION(
314: p_api_version IN NUMBER,
315: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
316: p_commit IN VARCHAR2 := FND_API.G_FALSE,
317:
318: p_parent_object_id OUT NOCOPY fnd_imp_depobjects.object_id%TYPE,
319: p_child_object_id OUT NOCOPY fnd_imp_depobjects.object_id%TYPE,
320:

Line 383: IF NOT FND_API.Compatible_API_Call (

379: -- Standard Start of API savepoint
380: SAVEPOINT INSERT_DEP_RELATION;
381:
382: -- Standard call to check for call compatibility.
383: IF NOT FND_API.Compatible_API_Call (
384: l_api_version,
385: p_api_version,
386: l_api_name,
387: G_PKG_NAME)

Line 389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

385: p_api_version,
386: l_api_name,
387: G_PKG_NAME)
388: THEN
389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
390: END IF;
391:
392: -- Initialize message list if p_init_msg_list is set to TRUE.
393: IF FND_API.To_Boolean( p_init_msg_list ) THEN

Line 393: IF FND_API.To_Boolean( p_init_msg_list ) THEN

389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
390: END IF;
391:
392: -- Initialize message list if p_init_msg_list is set to TRUE.
393: IF FND_API.To_Boolean( p_init_msg_list ) THEN
394: FND_MSG_PUB.initialize;
395: END IF;
396:
397: -- Initialize API return status to success

Line 398: x_return_status := FND_API.G_RET_STS_SUCCESS;

394: FND_MSG_PUB.initialize;
395: END IF;
396:
397: -- Initialize API return status to success
398: x_return_status := FND_API.G_RET_STS_SUCCESS;
399:
400: -- real logic --
401: ----------------
402:

Line 406: FND_API.G_TRUE,

402:
403: CLEAN_TABLES(p_snapshot_id);
404:
405: INSERT_DEP_OBJECT( 1.0,
406: FND_API.G_TRUE,
407: FND_API.G_FALSE,
408: l_child_object_id,
409: p_snapshot_id,
410: p_child_object_name,

Line 407: FND_API.G_FALSE,

403: CLEAN_TABLES(p_snapshot_id);
404:
405: INSERT_DEP_OBJECT( 1.0,
406: FND_API.G_TRUE,
407: FND_API.G_FALSE,
408: l_child_object_id,
409: p_snapshot_id,
410: p_child_object_name,
411: p_child_object_type,

Line 437: FND_API.G_TRUE,

433:
434: p_child_object_id := l_child_object_id;
435:
436: INSERT_DEP_OBJECT( 1.0,
437: FND_API.G_TRUE,
438: FND_API.G_FALSE,
439: l_parent_object_id,
440: p_snapshot_id,
441: p_parent_object_name,

Line 438: FND_API.G_FALSE,

434: p_child_object_id := l_child_object_id;
435:
436: INSERT_DEP_OBJECT( 1.0,
437: FND_API.G_TRUE,
438: FND_API.G_FALSE,
439: l_parent_object_id,
440: p_snapshot_id,
441: p_parent_object_name,
442: p_parent_object_type,

Line 511: IF (FND_API.To_Boolean(p_commit)) THEN

507: -----------------------
508: -- end of real logic --
509:
510: -- Standard check of p_commit.
511: IF (FND_API.To_Boolean(p_commit)) THEN
512: COMMIT WORK;
513: END IF;
514:
515: -- Standard call to get message count and if count is 1, get message info.

Line 521: WHEN FND_API.G_EXC_ERROR THEN

517: p_count => x_msg_count,
518: p_data => x_msg_data );
519:
520: EXCEPTION
521: WHEN FND_API.G_EXC_ERROR THEN
522: ROLLBACK TO INSERT_DEP_RELATION;
523: x_return_status := FND_API.G_RET_STS_ERROR ;
524:
525: FND_MSG_PUB.Count_And_Get(

Line 523: x_return_status := FND_API.G_RET_STS_ERROR ;

519:
520: EXCEPTION
521: WHEN FND_API.G_EXC_ERROR THEN
522: ROLLBACK TO INSERT_DEP_RELATION;
523: x_return_status := FND_API.G_RET_STS_ERROR ;
524:
525: FND_MSG_PUB.Count_And_Get(
526: p_count => x_msg_count,
527: p_data => x_msg_data );

Line 529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

525: FND_MSG_PUB.Count_And_Get(
526: p_count => x_msg_count,
527: p_data => x_msg_data );
528:
529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
530: ROLLBACK TO INSERT_DEP_RELATION;
531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
532:
533: FND_MSG_PUB.Count_And_Get(

Line 531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

527: p_data => x_msg_data );
528:
529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
530: ROLLBACK TO INSERT_DEP_RELATION;
531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
532:
533: FND_MSG_PUB.Count_And_Get(
534: p_count => x_msg_count,
535: p_data => x_msg_data );

Line 539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

535: p_data => x_msg_data );
536:
537: WHEN OTHERS THEN
538: ROLLBACK TO INSERT_DEP_RELATION;
539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
540:
541: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
542: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
543: END IF;