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

Line 9: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'igs_ps_generic_pvt';
6:
7: PROCEDURE psp_import (
8: p_api_version IN NUMBER,
9: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
10: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
11: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
12: x_return_status OUT NOCOPY VARCHAR2,
13: x_msg_count OUT NOCOPY NUMBER,

Line 10: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

6:
7: PROCEDURE psp_import (
8: p_api_version IN NUMBER,
9: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
10: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
11: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
12: x_return_status OUT NOCOPY VARCHAR2,
13: x_msg_count OUT NOCOPY NUMBER,
14: x_msg_data OUT NOCOPY VARCHAR2,

Line 11: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

7: PROCEDURE psp_import (
8: p_api_version IN NUMBER,
9: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
10: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
11: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
12: x_return_status OUT NOCOPY VARCHAR2,
13: x_msg_count OUT NOCOPY NUMBER,
14: x_msg_data OUT NOCOPY VARCHAR2,
15: p_calling_context IN VARCHAR2,

Line 89: IF NOT FND_API.Compatible_API_Call(l_api_version ,

85: --Standard start of API savepoint
86: SAVEPOINT psp_import_PVT;
87:
88: --Standard call to check for call compatibility
89: IF NOT FND_API.Compatible_API_Call(l_api_version ,
90: p_api_version ,
91: l_api_name ,
92: G_PKG_NAME) THEN
93: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 93: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

89: IF NOT FND_API.Compatible_API_Call(l_api_version ,
90: p_api_version ,
91: l_api_name ,
92: G_PKG_NAME) THEN
93: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
94: END IF;
95:
96: --Initialize message list if p_init_msg_list is set to TRUE
97: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 97: IF FND_API.to_Boolean(p_init_msg_list) THEN

93: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
94: END IF;
95:
96: --Initialize message list if p_init_msg_list is set to TRUE
97: IF FND_API.to_Boolean(p_init_msg_list) THEN
98: FND_MSG_PUB.initialize;
99: END IF;
100:
101:

Line 106: RAISE FND_API.G_EXC_ERROR;

102: --API body
103: IF p_calling_context NOT IN ('S','G') THEN
104: FND_MESSAGE.SET_NAME('IGS','IGS_PS_INVALID_VALUE_CONTEXT');
105: FND_MSG_PUB.ADD;
106: RAISE FND_API.G_EXC_ERROR;
107: END IF;
108:
109: --Initialize API return status to success
110: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 110: x_return_status := FND_API.G_RET_STS_SUCCESS;

106: RAISE FND_API.G_EXC_ERROR;
107: END IF;
108:
109: --Initialize API return status to success
110: x_return_status := FND_API.G_RET_STS_SUCCESS;
111:
112:
113: --API body
114: p_usec_status := 'S';

Line 648: RAISE FND_API.G_EXC_ERROR;

644: --If none of the PL/SQL data has been passed then raise error
645: IF NOT l_record_exists THEN
646: FND_MESSAGE.SET_NAME ('IGS','IGS_PS_LGCY_DATA_NOT_PASSED');
647: FND_MSG_PUB.ADD;
648: RAISE FND_API.G_EXC_ERROR;
649: END IF;
650:
651: --End of API body
652:

Line 654: IF FND_API.TO_Boolean( p_commit) THEN

650:
651: --End of API body
652:
653: --Standard check of p_commit
654: IF FND_API.TO_Boolean( p_commit) THEN
655: COMMIT WORK;
656: END IF;
657:
658: --Standard call to get message count and if count is 1, get message info.

Line 664: WHEN FND_API.G_EXC_ERROR THEN

660: p_data => x_msg_data);
661:
662:
663: EXCEPTION
664: WHEN FND_API.G_EXC_ERROR THEN
665: ROLLBACK TO psp_import_PVT;
666: x_return_status := FND_API.G_RET_STS_ERROR;
667: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,
668: p_data => x_msg_data );

Line 666: x_return_status := FND_API.G_RET_STS_ERROR;

662:
663: EXCEPTION
664: WHEN FND_API.G_EXC_ERROR THEN
665: ROLLBACK TO psp_import_PVT;
666: x_return_status := FND_API.G_RET_STS_ERROR;
667: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,
668: p_data => x_msg_data );
669:
670: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 670: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

666: x_return_status := FND_API.G_RET_STS_ERROR;
667: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,
668: p_data => x_msg_data );
669:
670: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
671: ROLLBACK TO psp_import_PVT;
672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
673: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,
674: p_data => x_msg_data );

Line 672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

668: p_data => x_msg_data );
669:
670: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
671: ROLLBACK TO psp_import_PVT;
672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
673: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,
674: p_data => x_msg_data );
675:
676: WHEN OTHERS THEN

Line 678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

674: p_data => x_msg_data );
675:
676: WHEN OTHERS THEN
677: ROLLBACK TO psp_import_PVT;
678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
679: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
680: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
681: l_api_name);
682: END IF;