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

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

39: +==========================================================================*/
40:
41: PROCEDURE Create_Commitment_Line_Items
42: ( p_api_version IN NUMBER,
43: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
44: p_commit IN VARCHAR2 := FND_API.G_FALSE,
45: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
46: p_return_status OUT NOCOPY VARCHAR2,
47: p_msg_count OUT NOCOPY NUMBER,

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

40:
41: PROCEDURE Create_Commitment_Line_Items
42: ( p_api_version IN NUMBER,
43: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
44: p_commit IN VARCHAR2 := FND_API.G_FALSE,
45: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
46: p_return_status OUT NOCOPY VARCHAR2,
47: p_msg_count OUT NOCOPY NUMBER,
48: p_msg_data OUT NOCOPY VARCHAR2,

Line 45: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

41: PROCEDURE Create_Commitment_Line_Items
42: ( p_api_version IN NUMBER,
43: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
44: p_commit IN VARCHAR2 := FND_API.G_FALSE,
45: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
46: p_return_status OUT NOCOPY VARCHAR2,
47: p_msg_count OUT NOCOPY NUMBER,
48: p_msg_data OUT NOCOPY VARCHAR2,
49: p_worksheet_id IN NUMBER

Line 55: l_init_msg_list VARCHAR2(30) := FND_API.G_FALSE;

51:
52: l_api_name CONSTANT VARCHAR2(30) := 'Create_Commitment_Line_Items';
53: l_api_version CONSTANT NUMBER := 1.0;
54: l_plsql_block VARCHAR2(200);
55: l_init_msg_list VARCHAR2(30) := FND_API.G_FALSE;
56: l_commit VARCHAR2(30) := FND_API.G_FALSE;
57: l_validation_level VARCHAR2(30) := FND_API.G_VALID_LEVEL_FULL;
58: l_return_status VARCHAR2(1);
59: l_msg_count NUMBER;

Line 56: l_commit VARCHAR2(30) := FND_API.G_FALSE;

52: l_api_name CONSTANT VARCHAR2(30) := 'Create_Commitment_Line_Items';
53: l_api_version CONSTANT NUMBER := 1.0;
54: l_plsql_block VARCHAR2(200);
55: l_init_msg_list VARCHAR2(30) := FND_API.G_FALSE;
56: l_commit VARCHAR2(30) := FND_API.G_FALSE;
57: l_validation_level VARCHAR2(30) := FND_API.G_VALID_LEVEL_FULL;
58: l_return_status VARCHAR2(1);
59: l_msg_count NUMBER;
60: l_msg_data VARCHAR2(2000);

Line 57: l_validation_level VARCHAR2(30) := FND_API.G_VALID_LEVEL_FULL;

53: l_api_version CONSTANT NUMBER := 1.0;
54: l_plsql_block VARCHAR2(200);
55: l_init_msg_list VARCHAR2(30) := FND_API.G_FALSE;
56: l_commit VARCHAR2(30) := FND_API.G_FALSE;
57: l_validation_level VARCHAR2(30) := FND_API.G_VALID_LEVEL_FULL;
58: l_return_status VARCHAR2(1);
59: l_msg_count NUMBER;
60: l_msg_data VARCHAR2(2000);
61: l_set_of_books_id NUMBER;

Line 79: IF NOT FND_API.Compatible_API_Call (l_api_version,

75: SAVEPOINT Create_Commit_Line_Items_Pvt;
76:
77: -- Standard call to check for call compatibility.
78:
79: IF NOT FND_API.Compatible_API_Call (l_api_version,
80: p_api_version,
81: l_api_name,
82: G_PKG_NAME)
83: THEN

Line 84: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

80: p_api_version,
81: l_api_name,
82: G_PKG_NAME)
83: THEN
84: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
85: END IF;
86:
87: -- Initialize message list if p_init_msg_list is set to TRUE.
88:

Line 89: IF FND_API.to_Boolean (p_init_msg_list) THEN

85: END IF;
86:
87: -- Initialize message list if p_init_msg_list is set to TRUE.
88:
89: IF FND_API.to_Boolean (p_init_msg_list) THEN
90: FND_MSG_PUB.initialize;
91: END IF;
92:
93: OPEN C_Root_Set_Of_Books;

Line 113: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

109: IN l_commit, IN l_validation_level,
110: OUT l_return_status, OUT l_msg_count,
111: OUT l_msg_data, IN p_worksheet_id;
112:
113: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
114: RAISE FND_API.G_EXC_ERROR;
115: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
117: END IF;

Line 114: RAISE FND_API.G_EXC_ERROR;

110: OUT l_return_status, OUT l_msg_count,
111: OUT l_msg_data, IN p_worksheet_id;
112:
113: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
114: RAISE FND_API.G_EXC_ERROR;
115: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
117: END IF;
118:

Line 115: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

111: OUT l_msg_data, IN p_worksheet_id;
112:
113: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
114: RAISE FND_API.G_EXC_ERROR;
115: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
117: END IF;
118:
119: END;

Line 116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

112:
113: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
114: RAISE FND_API.G_EXC_ERROR;
115: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
117: END IF;
118:
119: END;
120: END IF;

Line 124: p_return_status := FND_API.G_RET_STS_SUCCESS;

120: END IF;
121:
122: -- Initialize API return status to success
123:
124: p_return_status := FND_API.G_RET_STS_SUCCESS;
125:
126: -- Standard check of p_commit.
127:
128: IF FND_API.to_Boolean (p_commit) THEN

Line 128: IF FND_API.to_Boolean (p_commit) THEN

124: p_return_status := FND_API.G_RET_STS_SUCCESS;
125:
126: -- Standard check of p_commit.
127:
128: IF FND_API.to_Boolean (p_commit) THEN
129: COMMIT WORK;
130: END IF;
131:
132: -- Standard call to get message count and if count is 1, get message info.

Line 139: WHEN FND_API.G_EXC_ERROR THEN

135: p_data => p_msg_data);
136:
137: EXCEPTION
138:
139: WHEN FND_API.G_EXC_ERROR THEN
140: ROLLBACK to Create_Commit_Line_Items_Pvt;
141: p_return_status := FND_API.G_RET_STS_ERROR;
142:
143: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 141: p_return_status := FND_API.G_RET_STS_ERROR;

137: EXCEPTION
138:
139: WHEN FND_API.G_EXC_ERROR THEN
140: ROLLBACK to Create_Commit_Line_Items_Pvt;
141: p_return_status := FND_API.G_RET_STS_ERROR;
142:
143: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
144: p_data => p_msg_data);
145:

Line 146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

142:
143: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
144: p_data => p_msg_data);
145:
146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
147: ROLLBACK to Create_Commit_Line_Items_Pvt;
148: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
149:
150: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 148: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

144: p_data => p_msg_data);
145:
146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
147: ROLLBACK to Create_Commit_Line_Items_Pvt;
148: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
149:
150: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
151: p_data => p_msg_data);
152:

Line 155: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

151: p_data => p_msg_data);
152:
153: WHEN OTHERS THEN
154: ROLLBACK to Create_Commit_Line_Items_Pvt;
155: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
156:
157: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
158: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
159: l_api_name);

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

169: +==========================================================================*/
170:
171: PROCEDURE Post_Commitment_Worksheet
172: ( p_api_version IN NUMBER,
173: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
174: p_commit IN VARCHAR2 := FND_API.G_FALSE,
175: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
176: p_return_status OUT NOCOPY VARCHAR2,
177: p_msg_count OUT NOCOPY NUMBER,

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

170:
171: PROCEDURE Post_Commitment_Worksheet
172: ( p_api_version IN NUMBER,
173: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
174: p_commit IN VARCHAR2 := FND_API.G_FALSE,
175: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
176: p_return_status OUT NOCOPY VARCHAR2,
177: p_msg_count OUT NOCOPY NUMBER,
178: p_msg_data OUT NOCOPY VARCHAR2,

Line 175: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

171: PROCEDURE Post_Commitment_Worksheet
172: ( p_api_version IN NUMBER,
173: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
174: p_commit IN VARCHAR2 := FND_API.G_FALSE,
175: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
176: p_return_status OUT NOCOPY VARCHAR2,
177: p_msg_count OUT NOCOPY NUMBER,
178: p_msg_data OUT NOCOPY VARCHAR2,
179: p_worksheet_id IN NUMBER

Line 185: l_init_msg_list VARCHAR2(30) := FND_API.G_FALSE;

181:
182: l_api_name CONSTANT VARCHAR2(30) := 'Post_Commitment_Worksheet';
183: l_api_version CONSTANT NUMBER := 1.0;
184: l_plsql_block VARCHAR2(200);
185: l_init_msg_list VARCHAR2(30) := FND_API.G_FALSE;
186: l_commit VARCHAR2(30) := FND_API.G_FALSE;
187: l_validation_level VARCHAR2(30) := FND_API.G_VALID_LEVEL_FULL;
188: l_return_status VARCHAR2(1);
189: l_msg_count NUMBER;

Line 186: l_commit VARCHAR2(30) := FND_API.G_FALSE;

182: l_api_name CONSTANT VARCHAR2(30) := 'Post_Commitment_Worksheet';
183: l_api_version CONSTANT NUMBER := 1.0;
184: l_plsql_block VARCHAR2(200);
185: l_init_msg_list VARCHAR2(30) := FND_API.G_FALSE;
186: l_commit VARCHAR2(30) := FND_API.G_FALSE;
187: l_validation_level VARCHAR2(30) := FND_API.G_VALID_LEVEL_FULL;
188: l_return_status VARCHAR2(1);
189: l_msg_count NUMBER;
190: l_msg_data VARCHAR2(2000);

Line 187: l_validation_level VARCHAR2(30) := FND_API.G_VALID_LEVEL_FULL;

183: l_api_version CONSTANT NUMBER := 1.0;
184: l_plsql_block VARCHAR2(200);
185: l_init_msg_list VARCHAR2(30) := FND_API.G_FALSE;
186: l_commit VARCHAR2(30) := FND_API.G_FALSE;
187: l_validation_level VARCHAR2(30) := FND_API.G_VALID_LEVEL_FULL;
188: l_return_status VARCHAR2(1);
189: l_msg_count NUMBER;
190: l_msg_data VARCHAR2(2000);
191: l_set_of_books_id NUMBER;

Line 210: IF NOT FND_API.Compatible_API_Call (l_api_version,

206:
207:
208: -- Standard call to check for call compatibility.
209:
210: IF NOT FND_API.Compatible_API_Call (l_api_version,
211: p_api_version,
212: l_api_name,
213: G_PKG_NAME)
214: THEN

Line 215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

211: p_api_version,
212: l_api_name,
213: G_PKG_NAME)
214: THEN
215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
216: END IF;
217:
218: -- Initialize message list if p_init_msg_list is set to TRUE.
219:

Line 220: IF FND_API.to_Boolean (p_init_msg_list) THEN

216: END IF;
217:
218: -- Initialize message list if p_init_msg_list is set to TRUE.
219:
220: IF FND_API.to_Boolean (p_init_msg_list) THEN
221: FND_MSG_PUB.initialize;
222: END IF;
223:
224: OPEN C_Root_Set_Of_Books;

Line 244: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

240: IN l_commit, IN l_validation_level,
241: OUT l_return_status, OUT l_msg_count,
242: OUT l_msg_data, IN p_worksheet_id;
243:
244: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
245: RAISE FND_API.G_EXC_ERROR;
246: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
248: END IF;

Line 245: RAISE FND_API.G_EXC_ERROR;

241: OUT l_return_status, OUT l_msg_count,
242: OUT l_msg_data, IN p_worksheet_id;
243:
244: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
245: RAISE FND_API.G_EXC_ERROR;
246: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
248: END IF;
249: --

Line 246: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

242: OUT l_msg_data, IN p_worksheet_id;
243:
244: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
245: RAISE FND_API.G_EXC_ERROR;
246: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
248: END IF;
249: --
250:

Line 247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

243:
244: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
245: RAISE FND_API.G_EXC_ERROR;
246: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
248: END IF;
249: --
250:
251: END;

Line 256: p_return_status := FND_API.G_RET_STS_SUCCESS;

252: END IF;
253:
254: -- Initialize API return status to success
255:
256: p_return_status := FND_API.G_RET_STS_SUCCESS;
257:
258: -- Standard check of p_commit.
259:
260: IF FND_API.to_Boolean (p_commit) THEN

Line 260: IF FND_API.to_Boolean (p_commit) THEN

256: p_return_status := FND_API.G_RET_STS_SUCCESS;
257:
258: -- Standard check of p_commit.
259:
260: IF FND_API.to_Boolean (p_commit) THEN
261: COMMIT WORK;
262: END IF;
263:
264: -- Standard call to get message count and if count is 1, get message info.

Line 271: WHEN FND_API.G_EXC_ERROR THEN

267: p_data => p_msg_data);
268:
269: EXCEPTION
270:
271: WHEN FND_API.G_EXC_ERROR THEN
272: ROLLBACK to Post_Commitment_Worksheet_Pvt;
273: p_return_status := FND_API.G_RET_STS_ERROR;
274:
275: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 273: p_return_status := FND_API.G_RET_STS_ERROR;

269: EXCEPTION
270:
271: WHEN FND_API.G_EXC_ERROR THEN
272: ROLLBACK to Post_Commitment_Worksheet_Pvt;
273: p_return_status := FND_API.G_RET_STS_ERROR;
274:
275: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
276: p_data => p_msg_data);
277:

Line 278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

274:
275: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
276: p_data => p_msg_data);
277:
278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
279: ROLLBACK to Post_Commitment_Worksheet_Pvt;
280: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
281:
282: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 280: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

276: p_data => p_msg_data);
277:
278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
279: ROLLBACK to Post_Commitment_Worksheet_Pvt;
280: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
281:
282: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
283: p_data => p_msg_data);
284:

Line 287: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

283: p_data => p_msg_data);
284:
285: WHEN OTHERS THEN
286: ROLLBACK to Post_Commitment_Worksheet_Pvt;
287: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
288:
289: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
290: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
291: l_api_name);

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

301: +==========================================================================*/
302:
303: PROCEDURE Create_Commitment_Revisions
304: ( p_api_version IN NUMBER,
305: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
306: p_commit IN VARCHAR2 := FND_API.G_FALSE,
307: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
308: p_return_status OUT NOCOPY VARCHAR2,
309: p_msg_count OUT NOCOPY NUMBER,

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

302:
303: PROCEDURE Create_Commitment_Revisions
304: ( p_api_version IN NUMBER,
305: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
306: p_commit IN VARCHAR2 := FND_API.G_FALSE,
307: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
308: p_return_status OUT NOCOPY VARCHAR2,
309: p_msg_count OUT NOCOPY NUMBER,
310: p_msg_data OUT NOCOPY VARCHAR2,

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

303: PROCEDURE Create_Commitment_Revisions
304: ( p_api_version IN NUMBER,
305: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
306: p_commit IN VARCHAR2 := FND_API.G_FALSE,
307: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
308: p_return_status OUT NOCOPY VARCHAR2,
309: p_msg_count OUT NOCOPY NUMBER,
310: p_msg_data OUT NOCOPY VARCHAR2,
311: p_budget_revision_id IN NUMBER

Line 317: l_init_msg_list VARCHAR2(30) := FND_API.G_FALSE;

313:
314: l_api_name CONSTANT VARCHAR2(30) := 'Create_Commitment_Revisions';
315: l_api_version CONSTANT NUMBER := 1.0;
316: l_plsql_block VARCHAR2(200);
317: l_init_msg_list VARCHAR2(30) := FND_API.G_FALSE;
318: l_commit VARCHAR2(30) := FND_API.G_FALSE;
319: l_validation_level VARCHAR2(30) := FND_API.G_VALID_LEVEL_FULL;
320: l_return_status VARCHAR2(1);
321: l_msg_count NUMBER;

Line 318: l_commit VARCHAR2(30) := FND_API.G_FALSE;

314: l_api_name CONSTANT VARCHAR2(30) := 'Create_Commitment_Revisions';
315: l_api_version CONSTANT NUMBER := 1.0;
316: l_plsql_block VARCHAR2(200);
317: l_init_msg_list VARCHAR2(30) := FND_API.G_FALSE;
318: l_commit VARCHAR2(30) := FND_API.G_FALSE;
319: l_validation_level VARCHAR2(30) := FND_API.G_VALID_LEVEL_FULL;
320: l_return_status VARCHAR2(1);
321: l_msg_count NUMBER;
322: l_msg_data VARCHAR2(2000);

Line 319: l_validation_level VARCHAR2(30) := FND_API.G_VALID_LEVEL_FULL;

315: l_api_version CONSTANT NUMBER := 1.0;
316: l_plsql_block VARCHAR2(200);
317: l_init_msg_list VARCHAR2(30) := FND_API.G_FALSE;
318: l_commit VARCHAR2(30) := FND_API.G_FALSE;
319: l_validation_level VARCHAR2(30) := FND_API.G_VALID_LEVEL_FULL;
320: l_return_status VARCHAR2(1);
321: l_msg_count NUMBER;
322: l_msg_data VARCHAR2(2000);
323: l_set_of_books_id NUMBER;

Line 342: IF not FND_API.Compatible_API_Call (l_api_version,

338:
339:
340: -- Standard call to check for call compatibility.
341:
342: IF not FND_API.Compatible_API_Call (l_api_version,
343: p_api_version,
344: l_api_name,
345: G_PKG_NAME)
346: THEN

Line 347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

343: p_api_version,
344: l_api_name,
345: G_PKG_NAME)
346: THEN
347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
348: END IF;
349:
350: -- Initialize message list if p_init_msg_list is set to TRUE.
351:

Line 352: IF FND_API.to_Boolean (p_init_msg_list) THEN

348: END IF;
349:
350: -- Initialize message list if p_init_msg_list is set to TRUE.
351:
352: IF FND_API.to_Boolean (p_init_msg_list) THEN
353: FND_MSG_PUB.initialize;
354: END IF;
355:
356: OPEN C_Root_Set_Of_Books;

Line 375: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

371: IN l_commit, IN l_validation_level,
372: OUT l_return_status, OUT l_msg_count,
373: OUT l_msg_data, IN p_budget_revision_id;
374:
375: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
376: RAISE FND_API.G_EXC_ERROR;
377: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
379: END IF;

Line 376: RAISE FND_API.G_EXC_ERROR;

372: OUT l_return_status, OUT l_msg_count,
373: OUT l_msg_data, IN p_budget_revision_id;
374:
375: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
376: RAISE FND_API.G_EXC_ERROR;
377: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
379: END IF;
380: --

Line 377: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

373: OUT l_msg_data, IN p_budget_revision_id;
374:
375: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
376: RAISE FND_API.G_EXC_ERROR;
377: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
379: END IF;
380: --
381: END;

Line 378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

374:
375: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
376: RAISE FND_API.G_EXC_ERROR;
377: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
379: END IF;
380: --
381: END;
382: END IF;

Line 386: p_return_status := FND_API.G_RET_STS_SUCCESS;

382: END IF;
383:
384: -- Initialize API return status to success
385:
386: p_return_status := FND_API.G_RET_STS_SUCCESS;
387:
388: -- Standard check of p_commit.
389:
390: IF FND_API.to_Boolean (p_commit) THEN

Line 390: IF FND_API.to_Boolean (p_commit) THEN

386: p_return_status := FND_API.G_RET_STS_SUCCESS;
387:
388: -- Standard check of p_commit.
389:
390: IF FND_API.to_Boolean (p_commit) THEN
391: COMMIT WORK;
392: END IF;
393:
394: -- Standard call to get message count and if count is 1, get message info.

Line 402: WHEN FND_API.G_EXC_ERROR THEN

398:
399:
400: EXCEPTION
401:
402: WHEN FND_API.G_EXC_ERROR THEN
403: ROLLBACK to Create_Revisions_Pvt;
404: p_return_status := FND_API.G_RET_STS_ERROR;
405:
406: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 404: p_return_status := FND_API.G_RET_STS_ERROR;

400: EXCEPTION
401:
402: WHEN FND_API.G_EXC_ERROR THEN
403: ROLLBACK to Create_Revisions_Pvt;
404: p_return_status := FND_API.G_RET_STS_ERROR;
405:
406: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
407: p_data => p_msg_data);
408:

Line 409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

405:
406: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
407: p_data => p_msg_data);
408:
409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
410: ROLLBACK to Create_Revisions_Pvt;
411: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
412:
413: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 411: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

407: p_data => p_msg_data);
408:
409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
410: ROLLBACK to Create_Revisions_Pvt;
411: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
412:
413: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
414: p_data => p_msg_data);
415:

Line 418: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

414: p_data => p_msg_data);
415:
416: WHEN OTHERS THEN
417: ROLLBACK to Create_Revisions_Pvt;
418: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
419:
420: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
421:
422: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

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

432: +==========================================================================*/
433:
434: PROCEDURE Post_Commitment_Revisions
435: ( p_api_version IN NUMBER,
436: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
437: p_commit IN VARCHAR2 := FND_API.G_FALSE,
438: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
439: p_return_status OUT NOCOPY VARCHAR2,
440: p_msg_count OUT NOCOPY NUMBER,

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

433:
434: PROCEDURE Post_Commitment_Revisions
435: ( p_api_version IN NUMBER,
436: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
437: p_commit IN VARCHAR2 := FND_API.G_FALSE,
438: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
439: p_return_status OUT NOCOPY VARCHAR2,
440: p_msg_count OUT NOCOPY NUMBER,
441: p_msg_data OUT NOCOPY VARCHAR2,

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

434: PROCEDURE Post_Commitment_Revisions
435: ( p_api_version IN NUMBER,
436: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
437: p_commit IN VARCHAR2 := FND_API.G_FALSE,
438: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
439: p_return_status OUT NOCOPY VARCHAR2,
440: p_msg_count OUT NOCOPY NUMBER,
441: p_msg_data OUT NOCOPY VARCHAR2,
442: p_budget_revision_id IN NUMBER

Line 448: l_init_msg_list VARCHAR2(30) := FND_API.G_FALSE;

444:
445: l_api_name CONSTANT VARCHAR2(30) := 'Post_Commitment_Revisions';
446: l_api_version CONSTANT NUMBER := 1.0;
447: l_plsql_block VARCHAR2(200);
448: l_init_msg_list VARCHAR2(30) := FND_API.G_FALSE;
449: l_commit VARCHAR2(30) := FND_API.G_FALSE;
450: l_validation_level VARCHAR2(30) := FND_API.G_VALID_LEVEL_FULL;
451: l_return_status VARCHAR2(1);
452: l_msg_count NUMBER;

Line 449: l_commit VARCHAR2(30) := FND_API.G_FALSE;

445: l_api_name CONSTANT VARCHAR2(30) := 'Post_Commitment_Revisions';
446: l_api_version CONSTANT NUMBER := 1.0;
447: l_plsql_block VARCHAR2(200);
448: l_init_msg_list VARCHAR2(30) := FND_API.G_FALSE;
449: l_commit VARCHAR2(30) := FND_API.G_FALSE;
450: l_validation_level VARCHAR2(30) := FND_API.G_VALID_LEVEL_FULL;
451: l_return_status VARCHAR2(1);
452: l_msg_count NUMBER;
453: l_msg_data VARCHAR2(2000);

Line 450: l_validation_level VARCHAR2(30) := FND_API.G_VALID_LEVEL_FULL;

446: l_api_version CONSTANT NUMBER := 1.0;
447: l_plsql_block VARCHAR2(200);
448: l_init_msg_list VARCHAR2(30) := FND_API.G_FALSE;
449: l_commit VARCHAR2(30) := FND_API.G_FALSE;
450: l_validation_level VARCHAR2(30) := FND_API.G_VALID_LEVEL_FULL;
451: l_return_status VARCHAR2(1);
452: l_msg_count NUMBER;
453: l_msg_data VARCHAR2(2000);
454: l_set_of_books_id NUMBER;

Line 473: IF not FND_API.Compatible_API_Call (l_api_version,

469:
470:
471: -- Standard call to check for call compatibility.
472:
473: IF not FND_API.Compatible_API_Call (l_api_version,
474: p_api_version,
475: l_api_name,
476: G_PKG_NAME)
477: THEN

Line 478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

474: p_api_version,
475: l_api_name,
476: G_PKG_NAME)
477: THEN
478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
479: END IF;
480:
481: -- Initialize message list if p_init_msg_list is set to TRUE.
482:

Line 483: IF FND_API.to_Boolean (p_init_msg_list) THEN

479: END IF;
480:
481: -- Initialize message list if p_init_msg_list is set to TRUE.
482:
483: IF FND_API.to_Boolean (p_init_msg_list) THEN
484: FND_MSG_PUB.initialize;
485: END IF;
486:
487: OPEN C_Root_Set_Of_Books;

Line 506: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

502: IN l_commit, IN l_validation_level,
503: OUT l_return_status, OUT l_msg_count,
504: OUT l_msg_data, IN p_budget_revision_id;
505:
506: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
507: RAISE FND_API.G_EXC_ERROR;
508: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
510: END IF;

Line 507: RAISE FND_API.G_EXC_ERROR;

503: OUT l_return_status, OUT l_msg_count,
504: OUT l_msg_data, IN p_budget_revision_id;
505:
506: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
507: RAISE FND_API.G_EXC_ERROR;
508: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
510: END IF;
511:

Line 508: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

504: OUT l_msg_data, IN p_budget_revision_id;
505:
506: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
507: RAISE FND_API.G_EXC_ERROR;
508: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
510: END IF;
511:
512: END;

Line 509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

505:
506: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
507: RAISE FND_API.G_EXC_ERROR;
508: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
510: END IF;
511:
512: END;
513: END IF;

Line 517: p_return_status := FND_API.G_RET_STS_SUCCESS;

513: END IF;
514:
515: -- Initialize API return status to success
516:
517: p_return_status := FND_API.G_RET_STS_SUCCESS;
518:
519: -- Standard check of p_commit.
520:
521: IF FND_API.to_Boolean (p_commit) THEN

Line 521: IF FND_API.to_Boolean (p_commit) THEN

517: p_return_status := FND_API.G_RET_STS_SUCCESS;
518:
519: -- Standard check of p_commit.
520:
521: IF FND_API.to_Boolean (p_commit) THEN
522: COMMIT WORK;
523: END IF;
524:
525: -- Standard call to get message count and if count is 1, get message info.

Line 533: WHEN FND_API.G_EXC_ERROR THEN

529:
530:
531: EXCEPTION
532:
533: WHEN FND_API.G_EXC_ERROR THEN
534: ROLLBACK to Post_Commitment_Revisions_Pvt;
535: p_return_status := FND_API.G_RET_STS_ERROR;
536:
537: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 535: p_return_status := FND_API.G_RET_STS_ERROR;

531: EXCEPTION
532:
533: WHEN FND_API.G_EXC_ERROR THEN
534: ROLLBACK to Post_Commitment_Revisions_Pvt;
535: p_return_status := FND_API.G_RET_STS_ERROR;
536:
537: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
538: p_data => p_msg_data);
539:

Line 540: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

536:
537: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
538: p_data => p_msg_data);
539:
540: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
541: ROLLBACK to Post_Commitment_Revisions_Pvt;
542: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
543:
544: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 542: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

538: p_data => p_msg_data);
539:
540: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
541: ROLLBACK to Post_Commitment_Revisions_Pvt;
542: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
543:
544: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
545: p_data => p_msg_data);
546:

Line 549: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

545: p_data => p_msg_data);
546:
547: WHEN OTHERS THEN
548: ROLLBACK to Post_Commitment_Revisions_Pvt;
549: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
550:
551: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
552:
553: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

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

564: +==========================================================================*/
565:
566: PROCEDURE Commitment_Funds_Check
567: ( p_api_version IN NUMBER,
568: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
569: p_commit IN VARCHAR2 := FND_API.G_FALSE,
570: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
571: p_return_status OUT NOCOPY VARCHAR2,
572: p_msg_count OUT NOCOPY NUMBER,

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

565:
566: PROCEDURE Commitment_Funds_Check
567: ( p_api_version IN NUMBER,
568: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
569: p_commit IN VARCHAR2 := FND_API.G_FALSE,
570: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
571: p_return_status OUT NOCOPY VARCHAR2,
572: p_msg_count OUT NOCOPY NUMBER,
573: p_msg_data OUT NOCOPY VARCHAR2,

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

566: PROCEDURE Commitment_Funds_Check
567: ( p_api_version IN NUMBER,
568: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
569: p_commit IN VARCHAR2 := FND_API.G_FALSE,
570: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
571: p_return_status OUT NOCOPY VARCHAR2,
572: p_msg_count OUT NOCOPY NUMBER,
573: p_msg_data OUT NOCOPY VARCHAR2,
574: p_budget_revision_id IN NUMBER

Line 580: l_init_msg_list VARCHAR2(30) := FND_API.G_FALSE;

576:
577: l_api_name CONSTANT VARCHAR2(30) := 'Commitment_Funds_Check';
578: l_api_version CONSTANT NUMBER := 1.0;
579: l_plsql_block VARCHAR2(200);
580: l_init_msg_list VARCHAR2(30) := FND_API.G_FALSE;
581: l_commit VARCHAR2(30) := FND_API.G_FALSE;
582: l_validation_level VARCHAR2(30) := FND_API.G_VALID_LEVEL_FULL;
583: l_return_status VARCHAR2(1);
584: l_msg_count NUMBER;

Line 581: l_commit VARCHAR2(30) := FND_API.G_FALSE;

577: l_api_name CONSTANT VARCHAR2(30) := 'Commitment_Funds_Check';
578: l_api_version CONSTANT NUMBER := 1.0;
579: l_plsql_block VARCHAR2(200);
580: l_init_msg_list VARCHAR2(30) := FND_API.G_FALSE;
581: l_commit VARCHAR2(30) := FND_API.G_FALSE;
582: l_validation_level VARCHAR2(30) := FND_API.G_VALID_LEVEL_FULL;
583: l_return_status VARCHAR2(1);
584: l_msg_count NUMBER;
585: l_msg_data VARCHAR2(2000);

Line 582: l_validation_level VARCHAR2(30) := FND_API.G_VALID_LEVEL_FULL;

578: l_api_version CONSTANT NUMBER := 1.0;
579: l_plsql_block VARCHAR2(200);
580: l_init_msg_list VARCHAR2(30) := FND_API.G_FALSE;
581: l_commit VARCHAR2(30) := FND_API.G_FALSE;
582: l_validation_level VARCHAR2(30) := FND_API.G_VALID_LEVEL_FULL;
583: l_return_status VARCHAR2(1);
584: l_msg_count NUMBER;
585: l_msg_data VARCHAR2(2000);
586: l_set_of_books_id NUMBER;

Line 605: IF not FND_API.Compatible_API_Call (l_api_version,

601:
602:
603: -- Standard call to check for call compatibility.
604:
605: IF not FND_API.Compatible_API_Call (l_api_version,
606: p_api_version,
607: l_api_name,
608: G_PKG_NAME)
609: THEN

Line 610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

606: p_api_version,
607: l_api_name,
608: G_PKG_NAME)
609: THEN
610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
611: END IF;
612:
613: -- Initialize message list if p_init_msg_list is set to TRUE.
614:

Line 615: IF FND_API.to_Boolean (p_init_msg_list) THEN

611: END IF;
612:
613: -- Initialize message list if p_init_msg_list is set to TRUE.
614:
615: IF FND_API.to_Boolean (p_init_msg_list) THEN
616: FND_MSG_PUB.initialize;
617: END IF;
618:
619: OPEN C_Root_Set_Of_Books;

Line 638: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

634: IN l_commit, IN l_validation_level,
635: OUT l_return_status, OUT l_msg_count,
636: OUT l_msg_data, IN p_budget_revision_id;
637:
638: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
639: RAISE FND_API.G_EXC_ERROR;
640: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
642: END IF;

Line 639: RAISE FND_API.G_EXC_ERROR;

635: OUT l_return_status, OUT l_msg_count,
636: OUT l_msg_data, IN p_budget_revision_id;
637:
638: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
639: RAISE FND_API.G_EXC_ERROR;
640: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
642: END IF;
643: --

Line 640: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

636: OUT l_msg_data, IN p_budget_revision_id;
637:
638: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
639: RAISE FND_API.G_EXC_ERROR;
640: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
642: END IF;
643: --
644: END;

Line 641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

637:
638: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
639: RAISE FND_API.G_EXC_ERROR;
640: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
642: END IF;
643: --
644: END;
645: END IF;

Line 649: p_return_status := FND_API.G_RET_STS_SUCCESS;

645: END IF;
646:
647: -- Initialize API return status to success
648:
649: p_return_status := FND_API.G_RET_STS_SUCCESS;
650:
651: -- Standard check of p_commit.
652:
653: IF FND_API.to_Boolean (p_commit) THEN

Line 653: IF FND_API.to_Boolean (p_commit) THEN

649: p_return_status := FND_API.G_RET_STS_SUCCESS;
650:
651: -- Standard check of p_commit.
652:
653: IF FND_API.to_Boolean (p_commit) THEN
654: COMMIT WORK;
655: END IF;
656:
657: -- Standard call to get message count and if count is 1, get message info.

Line 665: WHEN FND_API.G_EXC_ERROR THEN

661:
662:
663: EXCEPTION
664:
665: WHEN FND_API.G_EXC_ERROR THEN
666: ROLLBACK to Commitment_Funds_Check_Pvt;
667: p_return_status := FND_API.G_RET_STS_ERROR;
668:
669: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 667: p_return_status := FND_API.G_RET_STS_ERROR;

663: EXCEPTION
664:
665: WHEN FND_API.G_EXC_ERROR THEN
666: ROLLBACK to Commitment_Funds_Check_Pvt;
667: p_return_status := FND_API.G_RET_STS_ERROR;
668:
669: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
670: p_data => p_msg_data);
671:

Line 673: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

669: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
670: p_data => p_msg_data);
671:
672:
673: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
674: ROLLBACK to Commitment_Funds_Check_Pvt;
675: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
676:
677: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 675: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

671:
672:
673: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
674: ROLLBACK to Commitment_Funds_Check_Pvt;
675: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
676:
677: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
678: p_data => p_msg_data);
679:

Line 682: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

678: p_data => p_msg_data);
679:
680: WHEN OTHERS THEN
681: ROLLBACK to Commitment_Funds_Check_Pvt;
682: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
683:
684: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
685:
686: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

Line 711: if FND_API.to_Boolean(l_cbc_enabled) then

707:
708: l_plsql_block := 'BEGIN :cbc_enabled := IGC_PSB_COMMITMENTS_PVT.IS_Cbc_Enabled(:sob); END;';
709: EXECUTE IMMEDIATE l_plsql_block USING OUT l_cbc_enabled, IN p_set_of_books_id;
710:
711: if FND_API.to_Boolean(l_cbc_enabled) then
712: return TRUE;
713: else
714: return FALSE;
715: end if;