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_BUDGET_REVISION_POS_PVT dependencies on FND_API

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

10:
11: PROCEDURE Insert_Row
12: (
13: p_api_version IN NUMBER,
14: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
15: p_commit IN VARCHAR2 := FND_API.G_FALSE,
16: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
17: p_return_status OUT NOCOPY VARCHAR2,
18: p_msg_count OUT NOCOPY NUMBER,

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

11: PROCEDURE Insert_Row
12: (
13: p_api_version IN NUMBER,
14: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
15: p_commit IN VARCHAR2 := FND_API.G_FALSE,
16: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
17: p_return_status OUT NOCOPY VARCHAR2,
18: p_msg_count OUT NOCOPY NUMBER,
19: p_msg_data OUT NOCOPY VARCHAR2,

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

12: (
13: p_api_version IN NUMBER,
14: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
15: p_commit IN VARCHAR2 := FND_API.G_FALSE,
16: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
17: p_return_status OUT NOCOPY VARCHAR2,
18: p_msg_count OUT NOCOPY NUMBER,
19: p_msg_data OUT NOCOPY VARCHAR2,
20: --

Line 21: p_budget_revision_id IN NUMBER := FND_API.G_MISS_NUM,

17: p_return_status OUT NOCOPY VARCHAR2,
18: p_msg_count OUT NOCOPY NUMBER,
19: p_msg_data OUT NOCOPY VARCHAR2,
20: --
21: p_budget_revision_id IN NUMBER := FND_API.G_MISS_NUM,
22: p_budget_revision_pos_line_id IN OUT NOCOPY NUMBER,
23: p_position_id IN NUMBER,
24: p_budget_group_id IN NUMBER,
25: p_effective_start_date IN DATE,

Line 53: IF NOT FND_API.Compatible_API_Call ( l_api_version,

49: BEGIN
50: --
51: SAVEPOINT Insert_Row_Pvt ;
52: --
53: IF NOT FND_API.Compatible_API_Call ( l_api_version,
54: p_api_version,
55: l_api_name,
56: G_PKG_NAME )
57: THEN

Line 58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

54: p_api_version,
55: l_api_name,
56: G_PKG_NAME )
57: THEN
58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
59: END IF;
60:
61: --
62:

Line 63: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

59: END IF;
60:
61: --
62:
63: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
64: FND_MSG_PUB.initialize ;
65: END IF;
66: --
67: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 67: p_return_status := FND_API.G_RET_STS_SUCCESS ;

63: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
64: FND_MSG_PUB.initialize ;
65: END IF;
66: --
67: p_return_status := FND_API.G_RET_STS_SUCCESS ;
68:
69: PSB_BUDGET_REVISIONS_PVT.Create_Revision_Positions
70: (
71: p_api_version => 1.0,

Line 72: p_init_msg_list => FND_API.G_FALSE,

68:
69: PSB_BUDGET_REVISIONS_PVT.Create_Revision_Positions
70: (
71: p_api_version => 1.0,
72: p_init_msg_list => FND_API.G_FALSE,
73: p_commit => FND_API.G_FALSE,
74: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
75: p_return_status => p_return_status,
76: p_msg_count => p_msg_count,

Line 73: p_commit => FND_API.G_FALSE,

69: PSB_BUDGET_REVISIONS_PVT.Create_Revision_Positions
70: (
71: p_api_version => 1.0,
72: p_init_msg_list => FND_API.G_FALSE,
73: p_commit => FND_API.G_FALSE,
74: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
75: p_return_status => p_return_status,
76: p_msg_count => p_msg_count,
77: p_msg_data => p_msg_data,

Line 74: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

70: (
71: p_api_version => 1.0,
72: p_init_msg_list => FND_API.G_FALSE,
73: p_commit => FND_API.G_FALSE,
74: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
75: p_return_status => p_return_status,
76: p_msg_count => p_msg_count,
77: p_msg_data => p_msg_data,
78: --

Line 97: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

93:
94:
95:
96: --
97: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
98: fnd_message.set_name('PSB', 'BR_CREATE_ACCT_FAILED_EXC');
99: RAISE FND_API.G_EXC_ERROR ;
100: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
101: fnd_message.set_name('PSB', 'BR_CREATE_ACCT_FAILED_UNEXC');

Line 99: RAISE FND_API.G_EXC_ERROR ;

95:
96: --
97: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
98: fnd_message.set_name('PSB', 'BR_CREATE_ACCT_FAILED_EXC');
99: RAISE FND_API.G_EXC_ERROR ;
100: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
101: fnd_message.set_name('PSB', 'BR_CREATE_ACCT_FAILED_UNEXC');
102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
103: END IF;

Line 100: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

96: --
97: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
98: fnd_message.set_name('PSB', 'BR_CREATE_ACCT_FAILED_EXC');
99: RAISE FND_API.G_EXC_ERROR ;
100: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
101: fnd_message.set_name('PSB', 'BR_CREATE_ACCT_FAILED_UNEXC');
102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
103: END IF;
104:

Line 102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

98: fnd_message.set_name('PSB', 'BR_CREATE_ACCT_FAILED_EXC');
99: RAISE FND_API.G_EXC_ERROR ;
100: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
101: fnd_message.set_name('PSB', 'BR_CREATE_ACCT_FAILED_UNEXC');
102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
103: END IF;
104:
105: --
106: IF FND_API.To_Boolean ( p_commit ) THEN

Line 106: IF FND_API.To_Boolean ( p_commit ) THEN

102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
103: END IF;
104:
105: --
106: IF FND_API.To_Boolean ( p_commit ) THEN
107: COMMIT WORK;
108: END iF;
109: --
110: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 115: WHEN FND_API.G_EXC_ERROR THEN

111: p_data => p_msg_data );
112: --
113: EXCEPTION
114: --
115: WHEN FND_API.G_EXC_ERROR THEN
116: --
117: ROLLBACK TO Insert_Row_Pvt ;
118: p_return_status := FND_API.G_RET_STS_ERROR;
119: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 118: p_return_status := FND_API.G_RET_STS_ERROR;

114: --
115: WHEN FND_API.G_EXC_ERROR THEN
116: --
117: ROLLBACK TO Insert_Row_Pvt ;
118: p_return_status := FND_API.G_RET_STS_ERROR;
119: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
120: p_data => p_msg_data );
121: --
122: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 122: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

118: p_return_status := FND_API.G_RET_STS_ERROR;
119: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
120: p_data => p_msg_data );
121: --
122: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
123: --
124: ROLLBACK TO Insert_Row_Pvt ;
125: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
126: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 125: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

121: --
122: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
123: --
124: ROLLBACK TO Insert_Row_Pvt ;
125: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
126: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
127: p_data => p_msg_data );
128: --
129: WHEN OTHERS THEN

Line 132: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

128: --
129: WHEN OTHERS THEN
130: --
131: ROLLBACK TO Insert_Row_Pvt ;
132: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
133: --
134: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
135: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
136: l_api_name);

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

144:
145: PROCEDURE Update_Row
146: (
147: p_api_version IN NUMBER,
148: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
149: p_commit IN VARCHAR2 := FND_API.G_FALSE,
150: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
151: p_return_status OUT NOCOPY VARCHAR2,
152: p_msg_count OUT NOCOPY NUMBER,

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

145: PROCEDURE Update_Row
146: (
147: p_api_version IN NUMBER,
148: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
149: p_commit IN VARCHAR2 := FND_API.G_FALSE,
150: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
151: p_return_status OUT NOCOPY VARCHAR2,
152: p_msg_count OUT NOCOPY NUMBER,
153: p_msg_data OUT NOCOPY VARCHAR2,

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

146: (
147: p_api_version IN NUMBER,
148: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
149: p_commit IN VARCHAR2 := FND_API.G_FALSE,
150: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
151: p_return_status OUT NOCOPY VARCHAR2,
152: p_msg_count OUT NOCOPY NUMBER,
153: p_msg_data OUT NOCOPY VARCHAR2,
154: --

Line 155: p_budget_revision_id IN NUMBER := FND_API.G_MISS_NUM,

151: p_return_status OUT NOCOPY VARCHAR2,
152: p_msg_count OUT NOCOPY NUMBER,
153: p_msg_data OUT NOCOPY VARCHAR2,
154: --
155: p_budget_revision_id IN NUMBER := FND_API.G_MISS_NUM,
156: p_budget_revision_pos_line_id IN OUT NOCOPY NUMBER,
157: p_position_id IN NUMBER,
158: p_budget_group_id IN NUMBER,
159: p_effective_start_date IN DATE,

Line 184: IF NOT FND_API.Compatible_API_Call ( l_api_version,

180: BEGIN
181: --
182: SAVEPOINT Update_Row_Pvt ;
183: --
184: IF NOT FND_API.Compatible_API_Call ( l_api_version,
185: p_api_version,
186: l_api_name,
187: G_PKG_NAME )
188: THEN

Line 189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

185: p_api_version,
186: l_api_name,
187: G_PKG_NAME )
188: THEN
189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
190: END IF;
191: --
192:
193: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 193: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
190: END IF;
191: --
192:
193: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
194: FND_MSG_PUB.initialize ;
195: END IF;
196: --
197: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 197: p_return_status := FND_API.G_RET_STS_SUCCESS ;

193: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
194: FND_MSG_PUB.initialize ;
195: END IF;
196: --
197: p_return_status := FND_API.G_RET_STS_SUCCESS ;
198: --
199:
200: PSB_BUDGET_REVISIONS_PVT.Create_Revision_Positions
201: (

Line 203: p_init_msg_list => FND_API.G_FALSE,

199:
200: PSB_BUDGET_REVISIONS_PVT.Create_Revision_Positions
201: (
202: p_api_version => 1.0,
203: p_init_msg_list => FND_API.G_FALSE,
204: p_commit => FND_API.G_FALSE,
205: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
206: p_return_status => p_return_status,
207: p_msg_count => p_msg_count,

Line 204: p_commit => FND_API.G_FALSE,

200: PSB_BUDGET_REVISIONS_PVT.Create_Revision_Positions
201: (
202: p_api_version => 1.0,
203: p_init_msg_list => FND_API.G_FALSE,
204: p_commit => FND_API.G_FALSE,
205: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
206: p_return_status => p_return_status,
207: p_msg_count => p_msg_count,
208: p_msg_data => p_msg_data,

Line 205: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

201: (
202: p_api_version => 1.0,
203: p_init_msg_list => FND_API.G_FALSE,
204: p_commit => FND_API.G_FALSE,
205: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
206: p_return_status => p_return_status,
207: p_msg_count => p_msg_count,
208: p_msg_data => p_msg_data,
209: --

Line 224: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

220: p_freeze_flag =>p_freeze_flag,
221: p_view_line_flag =>p_view_line_flag
222: );
223:
224: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
225: RAISE FND_API.G_EXC_ERROR ;
226: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
228: END IF;

Line 225: RAISE FND_API.G_EXC_ERROR ;

221: p_view_line_flag =>p_view_line_flag
222: );
223:
224: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
225: RAISE FND_API.G_EXC_ERROR ;
226: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
228: END IF;
229:

Line 226: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

222: );
223:
224: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
225: RAISE FND_API.G_EXC_ERROR ;
226: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
228: END IF;
229:
230: --

Line 227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

223:
224: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
225: RAISE FND_API.G_EXC_ERROR ;
226: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
228: END IF;
229:
230: --
231: IF FND_API.To_Boolean ( p_commit ) THEN

Line 231: IF FND_API.To_Boolean ( p_commit ) THEN

227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
228: END IF;
229:
230: --
231: IF FND_API.To_Boolean ( p_commit ) THEN
232: COMMIT WORK;
233: END iF;
234: --
235: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 240: WHEN FND_API.G_EXC_ERROR THEN

236: p_data => p_msg_data );
237: --
238: EXCEPTION
239: --
240: WHEN FND_API.G_EXC_ERROR THEN
241: --
242: ROLLBACK TO Update_Row_Pvt ;
243: p_return_status := FND_API.G_RET_STS_ERROR;
244: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 243: p_return_status := FND_API.G_RET_STS_ERROR;

239: --
240: WHEN FND_API.G_EXC_ERROR THEN
241: --
242: ROLLBACK TO Update_Row_Pvt ;
243: p_return_status := FND_API.G_RET_STS_ERROR;
244: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
245: p_data => p_msg_data );
246: --
247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

243: p_return_status := FND_API.G_RET_STS_ERROR;
244: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
245: p_data => p_msg_data );
246: --
247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
248: --
249: ROLLBACK TO Update_Row_Pvt ;
250: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
251: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 250: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

246: --
247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
248: --
249: ROLLBACK TO Update_Row_Pvt ;
250: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
251: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
252: p_data => p_msg_data );
253: --
254: WHEN OTHERS THEN

Line 257: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

253: --
254: WHEN OTHERS THEN
255: --
256: ROLLBACK TO Update_Row_Pvt ;
257: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
258: --
259: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
260: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
261: l_api_name);