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

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

9:
10: PROCEDURE Redistribute_Follow_Salary
11: (
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: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
16: p_return_status OUT NOCOPY VARCHAR2,
17: p_msg_count OUT NOCOPY NUMBER,

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

10: PROCEDURE Redistribute_Follow_Salary
11: (
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: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
16: p_return_status OUT NOCOPY VARCHAR2,
17: p_msg_count OUT NOCOPY NUMBER,
18: p_msg_data OUT NOCOPY VARCHAR2,

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

11: (
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: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
16: p_return_status OUT NOCOPY VARCHAR2,
17: p_msg_count OUT NOCOPY NUMBER,
18: p_msg_data OUT NOCOPY VARCHAR2,
19: --

Line 34: p_init_msg_list => FND_API.G_FALSE,

30:
31: PSB_WS_POS_PVT.Redistribute_Follow_Salary
32: (
33: p_api_version => 1.0,
34: p_init_msg_list => FND_API.G_FALSE,
35: p_commit => FND_API.G_FALSE,
36: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
37: p_return_status => l_return_status,
38: p_msg_count => p_msg_count,

Line 35: p_commit => FND_API.G_FALSE,

31: PSB_WS_POS_PVT.Redistribute_Follow_Salary
32: (
33: p_api_version => 1.0,
34: p_init_msg_list => FND_API.G_FALSE,
35: p_commit => FND_API.G_FALSE,
36: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
37: p_return_status => l_return_status,
38: p_msg_count => p_msg_count,
39: p_msg_data => p_msg_data,

Line 36: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

32: (
33: p_api_version => 1.0,
34: p_init_msg_list => FND_API.G_FALSE,
35: p_commit => FND_API.G_FALSE,
36: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
37: p_return_status => l_return_status,
38: p_msg_count => p_msg_count,
39: p_msg_data => p_msg_data,
40: --

Line 49: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

45: );
46: --
47: p_return_status := l_return_status;
48:
49: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
50: RAISE FND_API.G_EXC_ERROR ;
51: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
52: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
53: END IF;

Line 50: RAISE FND_API.G_EXC_ERROR ;

46: --
47: p_return_status := l_return_status;
48:
49: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
50: RAISE FND_API.G_EXC_ERROR ;
51: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
52: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
53: END IF;
54:

Line 51: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

47: p_return_status := l_return_status;
48:
49: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
50: RAISE FND_API.G_EXC_ERROR ;
51: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
52: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
53: END IF;
54:
55: EXCEPTION

Line 52: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

48:
49: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
50: RAISE FND_API.G_EXC_ERROR ;
51: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
52: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
53: END IF;
54:
55: EXCEPTION
56: --

Line 57: WHEN FND_API.G_EXC_ERROR THEN

53: END IF;
54:
55: EXCEPTION
56: --
57: WHEN FND_API.G_EXC_ERROR THEN
58: --
59: p_return_status := FND_API.G_RET_STS_ERROR;
60: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
61: p_data => p_msg_data );

Line 59: p_return_status := FND_API.G_RET_STS_ERROR;

55: EXCEPTION
56: --
57: WHEN FND_API.G_EXC_ERROR THEN
58: --
59: p_return_status := FND_API.G_RET_STS_ERROR;
60: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
61: p_data => p_msg_data );
62: --
63: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 63: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

59: p_return_status := FND_API.G_RET_STS_ERROR;
60: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
61: p_data => p_msg_data );
62: --
63: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
64: --
65: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
66: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
67: p_data => p_msg_data );

Line 65: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

61: p_data => p_msg_data );
62: --
63: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
64: --
65: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
66: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
67: p_data => p_msg_data );
68: --
69: WHEN OTHERS THEN

Line 71: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

67: p_data => p_msg_data );
68: --
69: WHEN OTHERS THEN
70: --
71: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
72: --
73: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
74: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
75: l_api_name);

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

88: --
89: PROCEDURE Delete_Pos_Service_Package
90: (
91: p_api_version IN NUMBER ,
92: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
93: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
94: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
95: p_return_status OUT NOCOPY VARCHAR2 ,
96: p_msg_count OUT NOCOPY NUMBER ,

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

89: PROCEDURE Delete_Pos_Service_Package
90: (
91: p_api_version IN NUMBER ,
92: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
93: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
94: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
95: p_return_status OUT NOCOPY VARCHAR2 ,
96: p_msg_count OUT NOCOPY NUMBER ,
97: p_msg_data OUT NOCOPY VARCHAR2 ,

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

90: (
91: p_api_version IN NUMBER ,
92: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
93: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
94: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
95: p_return_status OUT NOCOPY VARCHAR2 ,
96: p_msg_count OUT NOCOPY NUMBER ,
97: p_msg_data OUT NOCOPY VARCHAR2 ,
98: --

Line 115: IF NOT FND_API.Compatible_API_Call ( l_api_version,

111: BEGIN
112: --
113: SAVEPOINT Delete_Pos_Service_Package_Pvt ;
114: --
115: IF NOT FND_API.Compatible_API_Call ( l_api_version,
116: p_api_version,
117: l_api_name,
118: G_PKG_NAME )
119: THEN

Line 120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

116: p_api_version,
117: l_api_name,
118: G_PKG_NAME )
119: THEN
120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
121: END IF;
122: --
123: IF FND_API.To_Boolean ( p_init_msg_list ) THEN
124: FND_MSG_PUB.initialize ;

Line 123: IF FND_API.To_Boolean ( p_init_msg_list ) THEN

119: THEN
120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
121: END IF;
122: --
123: IF FND_API.To_Boolean ( p_init_msg_list ) THEN
124: FND_MSG_PUB.initialize ;
125: END IF;
126: --
127: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 127: p_return_status := FND_API.G_RET_STS_SUCCESS ;

123: IF FND_API.To_Boolean ( p_init_msg_list ) THEN
124: FND_MSG_PUB.initialize ;
125: END IF;
126: --
127: p_return_status := FND_API.G_RET_STS_SUCCESS ;
128: --
129:
130:
131: --

Line 157: IF FND_API.To_Boolean ( p_commit ) THEN

153: DELETE psb_ws_account_lines
154: WHERE service_package_id = p_service_package_id ;
155:
156: --
157: IF FND_API.To_Boolean ( p_commit ) THEN
158: COMMIT WORK;
159: END IF;
160: --
161: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 166: WHEN FND_API.G_EXC_ERROR THEN

162: p_data => p_msg_data );
163: --
164: EXCEPTION
165: --
166: WHEN FND_API.G_EXC_ERROR THEN
167: --
168: ROLLBACK TO Delete_Pos_Service_Package_Pvt ;
169: p_return_status := FND_API.G_RET_STS_ERROR;
170: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 169: p_return_status := FND_API.G_RET_STS_ERROR;

165: --
166: WHEN FND_API.G_EXC_ERROR THEN
167: --
168: ROLLBACK TO Delete_Pos_Service_Package_Pvt ;
169: p_return_status := FND_API.G_RET_STS_ERROR;
170: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
171: p_data => p_msg_data );
172: --
173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

169: p_return_status := FND_API.G_RET_STS_ERROR;
170: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
171: p_data => p_msg_data );
172: --
173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
174: --
175: ROLLBACK TO Delete_Pos_Service_Package_Pvt ;
176: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
177: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 176: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

172: --
173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
174: --
175: ROLLBACK TO Delete_Pos_Service_Package_Pvt ;
176: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
177: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
178: p_data => p_msg_data );
179: --
180: WHEN OTHERS THEN

Line 183: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

179: --
180: WHEN OTHERS THEN
181: --
182: ROLLBACK TO Delete_Pos_Service_Package_Pvt ;
183: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
184: --
185: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
186: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
187: l_api_name );