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

Line 9: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

5:
6: ----------------------------------------------------------------------------------
7: /*
8: procedure create_budget_line_oh
9: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
10: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
11: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
12: ,p_proposal_id NUMBER
13: ,p_version_id NUMBER

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

6: ----------------------------------------------------------------------------------
7: /*
8: procedure create_budget_line_oh
9: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
10: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
11: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
12: ,p_proposal_id NUMBER
13: ,p_version_id NUMBER
14: ,p_budget_period_id NUMBER

Line 11: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

7: /*
8: procedure create_budget_line_oh
9: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
10: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
11: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
12: ,p_proposal_id NUMBER
13: ,p_version_id NUMBER
14: ,p_budget_period_id NUMBER
15: ,p_line_item_id NUMBER

Line 33: IF p_commit = FND_API.G_TRUE THEN

29: l_data VARCHAR2(250);
30: l_msg_index_out NUMBER;
31:
32: BEGIN
33: IF p_commit = FND_API.G_TRUE THEN
34: SAVEPOINT create_budget_line_oh;
35: END IF;
36:
37: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then

Line 37: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then

33: IF p_commit = FND_API.G_TRUE THEN
34: SAVEPOINT create_budget_line_oh;
35: END IF;
36:
37: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
38: fnd_msg_pub.initialize;
39: end if;
40:
41: x_return_status := 'S';

Line 43: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then

39: end if;
40:
41: x_return_status := 'S';
42:
43: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then
44: igw_generate_periods.create_budget_detail_amts(
45: p_proposal_id => p_proposal_id
46: ,p_version_id => p_version_id
47: ,p_budget_period_id => p_budget_period_id

Line 62: (p_encoded => FND_API.G_TRUE ,

58: If l_msg_count > 0 THEN
59: x_msg_count := l_msg_count;
60: If l_msg_count = 1 THEN
61: fnd_msg_pub.get
62: (p_encoded => FND_API.G_TRUE ,
63: p_msg_index => 1,
64: p_data => l_data,
65: p_msg_index_out => l_msg_index_out );
66:

Line 69: RAISE FND_API.G_EXC_ERROR;

65: p_msg_index_out => l_msg_index_out );
66:
67: x_msg_data := l_data;
68: End if;
69: RAISE FND_API.G_EXC_ERROR;
70: End if;
71:
72: x_return_status := FND_API.G_RET_STS_SUCCESS;
73:

Line 72: x_return_status := FND_API.G_RET_STS_SUCCESS;

68: End if;
69: RAISE FND_API.G_EXC_ERROR;
70: End if;
71:
72: x_return_status := FND_API.G_RET_STS_SUCCESS;
73:
74: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
75: IF p_commit = FND_API.G_TRUE THEN
76: ROLLBACK TO create_budget_line_oh;

Line 74: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

70: End if;
71:
72: x_return_status := FND_API.G_RET_STS_SUCCESS;
73:
74: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
75: IF p_commit = FND_API.G_TRUE THEN
76: ROLLBACK TO create_budget_line_oh;
77: END IF;
78: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 75: IF p_commit = FND_API.G_TRUE THEN

71:
72: x_return_status := FND_API.G_RET_STS_SUCCESS;
73:
74: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
75: IF p_commit = FND_API.G_TRUE THEN
76: ROLLBACK TO create_budget_line_oh;
77: END IF;
78: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
79: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,

Line 78: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

74: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
75: IF p_commit = FND_API.G_TRUE THEN
76: ROLLBACK TO create_budget_line_oh;
77: END IF;
78: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
79: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,
80: p_procedure_name => l_api_name,
81: p_error_text => SUBSTRB(SQLERRM,1,240));
82: fnd_msg_pub.count_and_get(p_count => x_msg_count

Line 84: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

80: p_procedure_name => l_api_name,
81: p_error_text => SUBSTRB(SQLERRM,1,240));
82: fnd_msg_pub.count_and_get(p_count => x_msg_count
83: ,p_data => x_msg_data);
84: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
85:
86: WHEN FND_API.G_EXC_ERROR THEN
87: IF p_commit = FND_API.G_TRUE THEN
88: ROLLBACK TO create_budget_line_oh;

Line 86: WHEN FND_API.G_EXC_ERROR THEN

82: fnd_msg_pub.count_and_get(p_count => x_msg_count
83: ,p_data => x_msg_data);
84: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
85:
86: WHEN FND_API.G_EXC_ERROR THEN
87: IF p_commit = FND_API.G_TRUE THEN
88: ROLLBACK TO create_budget_line_oh;
89: END IF;
90: x_return_status := 'E';

Line 87: IF p_commit = FND_API.G_TRUE THEN

83: ,p_data => x_msg_data);
84: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
85:
86: WHEN FND_API.G_EXC_ERROR THEN
87: IF p_commit = FND_API.G_TRUE THEN
88: ROLLBACK TO create_budget_line_oh;
89: END IF;
90: x_return_status := 'E';
91:

Line 93: IF p_commit = FND_API.G_TRUE THEN

89: END IF;
90: x_return_status := 'E';
91:
92: WHEN OTHERS THEN
93: IF p_commit = FND_API.G_TRUE THEN
94: ROLLBACK TO create_budget_line_oh;
95: END IF;
96: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
97: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,

Line 96: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

92: WHEN OTHERS THEN
93: IF p_commit = FND_API.G_TRUE THEN
94: ROLLBACK TO create_budget_line_oh;
95: END IF;
96: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
97: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,
98: p_procedure_name => l_api_name,
99: p_error_text => SUBSTRB(SQLERRM,1,240));
100: fnd_msg_pub.count_and_get(p_count => x_msg_count

Line 110: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

106:
107: */
108: ------------------------------------------------------------------------------------------
109: procedure update_budget_personnel_oh
110: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
111: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
112: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
113: ,p_budget_personnel_detail_id NUMBER
114: ,p_rate_class_id NUMBER

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

107: */
108: ------------------------------------------------------------------------------------------
109: procedure update_budget_personnel_oh
110: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
111: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
112: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
113: ,p_budget_personnel_detail_id NUMBER
114: ,p_rate_class_id NUMBER
115: ,p_rate_type_id NUMBER

Line 112: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

108: ------------------------------------------------------------------------------------------
109: procedure update_budget_personnel_oh
110: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
111: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
112: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
113: ,p_budget_personnel_detail_id NUMBER
114: ,p_rate_class_id NUMBER
115: ,p_rate_type_id NUMBER
116: ,p_apply_rate_flag_oh VARCHAR2

Line 140: IF p_commit = FND_API.G_TRUE THEN

136: l_msg_index_out NUMBER;
137: l_dummy VARCHAR2(1);
138:
139: BEGIN
140: IF p_commit = FND_API.G_TRUE THEN
141: SAVEPOINT update_budget_personnel_oh;
142: END IF;
143:
144: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then

Line 144: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then

140: IF p_commit = FND_API.G_TRUE THEN
141: SAVEPOINT update_budget_personnel_oh;
142: END IF;
143:
144: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
145: fnd_msg_pub.initialize;
146: end if;
147:
148: x_return_status := 'S';

Line 174: (p_encoded => FND_API.G_TRUE ,

170: x_msg_count := l_msg_count;
171: x_return_status := 'E';
172: If l_msg_count = 1 THEN
173: fnd_msg_pub.get
174: (p_encoded => FND_API.G_TRUE ,
175: p_msg_index => 1,
176: p_data => l_data,
177: p_msg_index_out => l_msg_index_out );
178:

Line 181: RAISE FND_API.G_EXC_ERROR;

177: p_msg_index_out => l_msg_index_out );
178:
179: x_msg_data := l_data;
180: End if;
181: RAISE FND_API.G_EXC_ERROR;
182: END IF;
183:
184: /* need to this because following ids may not be passed and only row id may be passed */
185:

Line 197: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then

193: l_calculated_cost := 0;
194: l_calculated_cost_sharing := 0;
195: end if;
196:
197: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then
198:
199: update igw_budget_personnel_cal_amts
200: set apply_rate_flag = nvl(p_apply_rate_flag_oh, apply_rate_flag)
201: , calculated_cost = l_calculated_cost

Line 234: (p_encoded => FND_API.G_TRUE ,

230: If l_msg_count > 0 THEN
231: x_msg_count := l_msg_count;
232: If l_msg_count = 1 THEN
233: fnd_msg_pub.get
234: (p_encoded => FND_API.G_TRUE ,
235: p_msg_index => 1,
236: p_data => l_data,
237: p_msg_index_out => l_msg_index_out );
238:

Line 241: RAISE FND_API.G_EXC_ERROR;

237: p_msg_index_out => l_msg_index_out );
238:
239: x_msg_data := l_data;
240: End if;
241: RAISE FND_API.G_EXC_ERROR;
242: End if;
243:
244: x_return_status := FND_API.G_RET_STS_SUCCESS;
245:

Line 244: x_return_status := FND_API.G_RET_STS_SUCCESS;

240: End if;
241: RAISE FND_API.G_EXC_ERROR;
242: End if;
243:
244: x_return_status := FND_API.G_RET_STS_SUCCESS;
245:
246: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
247: IF p_commit = FND_API.G_TRUE THEN
248: ROLLBACK TO update_budget_personnel_oh;

Line 246: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

242: End if;
243:
244: x_return_status := FND_API.G_RET_STS_SUCCESS;
245:
246: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
247: IF p_commit = FND_API.G_TRUE THEN
248: ROLLBACK TO update_budget_personnel_oh;
249: END IF;
250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 247: IF p_commit = FND_API.G_TRUE THEN

243:
244: x_return_status := FND_API.G_RET_STS_SUCCESS;
245:
246: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
247: IF p_commit = FND_API.G_TRUE THEN
248: ROLLBACK TO update_budget_personnel_oh;
249: END IF;
250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
251: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,

Line 250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

246: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
247: IF p_commit = FND_API.G_TRUE THEN
248: ROLLBACK TO update_budget_personnel_oh;
249: END IF;
250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
251: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,
252: p_procedure_name => l_api_name,
253: p_error_text => SUBSTRB(SQLERRM,1,240));
254: fnd_msg_pub.count_and_get(p_count => x_msg_count

Line 256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

252: p_procedure_name => l_api_name,
253: p_error_text => SUBSTRB(SQLERRM,1,240));
254: fnd_msg_pub.count_and_get(p_count => x_msg_count
255: ,p_data => x_msg_data);
256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
257:
258: WHEN FND_API.G_EXC_ERROR THEN
259: IF p_commit = FND_API.G_TRUE THEN
260: ROLLBACK TO update_budget_personnel_oh;

Line 258: WHEN FND_API.G_EXC_ERROR THEN

254: fnd_msg_pub.count_and_get(p_count => x_msg_count
255: ,p_data => x_msg_data);
256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
257:
258: WHEN FND_API.G_EXC_ERROR THEN
259: IF p_commit = FND_API.G_TRUE THEN
260: ROLLBACK TO update_budget_personnel_oh;
261: END IF;
262: x_return_status := 'E';

Line 259: IF p_commit = FND_API.G_TRUE THEN

255: ,p_data => x_msg_data);
256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
257:
258: WHEN FND_API.G_EXC_ERROR THEN
259: IF p_commit = FND_API.G_TRUE THEN
260: ROLLBACK TO update_budget_personnel_oh;
261: END IF;
262: x_return_status := 'E';
263:

Line 265: IF p_commit = FND_API.G_TRUE THEN

261: END IF;
262: x_return_status := 'E';
263:
264: WHEN OTHERS THEN
265: IF p_commit = FND_API.G_TRUE THEN
266: ROLLBACK TO update_budget_line_oh;
267: END IF;
268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
269: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,

Line 268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

264: WHEN OTHERS THEN
265: IF p_commit = FND_API.G_TRUE THEN
266: ROLLBACK TO update_budget_line_oh;
267: END IF;
268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
269: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,
270: p_procedure_name => l_api_name,
271: p_error_text => SUBSTRB(SQLERRM,1,240));
272: fnd_msg_pub.count_and_get(p_count => x_msg_count

Line 282: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

278: -------------------------------------------------------------------------------------------
279: /*
280:
281: procedure delete_budget_line_oh
282: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
283: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
284: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
285: ,p_proposal_id IN NUMBER := NULL
286: ,p_version_id IN NUMBER := NULL

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

279: /*
280:
281: procedure delete_budget_line_oh
282: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
283: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
284: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
285: ,p_proposal_id IN NUMBER := NULL
286: ,p_version_id IN NUMBER := NULL
287: ,p_budget_period_id NUMBER := NULL

Line 284: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

280:
281: procedure delete_budget_line_oh
282: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
283: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
284: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
285: ,p_proposal_id IN NUMBER := NULL
286: ,p_version_id IN NUMBER := NULL
287: ,p_budget_period_id NUMBER := NULL
288: ,p_line_item_id NUMBER

Line 307: IF p_commit = FND_API.G_TRUE THEN

303:
304:
305:
306: BEGIN
307: IF p_commit = FND_API.G_TRUE THEN
308: SAVEPOINT delete_budget_line_oh;
309: END IF;
310:
311: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then

Line 311: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then

307: IF p_commit = FND_API.G_TRUE THEN
308: SAVEPOINT delete_budget_line_oh;
309: END IF;
310:
311: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
312: fnd_msg_pub.initialize;
313: end if;
314:
315: x_return_status := 'S';

Line 338: (p_encoded => FND_API.G_TRUE ,

334: x_msg_count := l_msg_count;
335: x_return_status := 'E';
336: If l_msg_count = 1 THEN
337: fnd_msg_pub.get
338: (p_encoded => FND_API.G_TRUE ,
339: p_msg_index => 1,
340: p_data => l_data,
341: p_msg_index_out => l_msg_index_out );
342:

Line 345: RAISE FND_API.G_EXC_ERROR;

341: p_msg_index_out => l_msg_index_out );
342:
343: x_msg_data := l_data;
344: End if;
345: RAISE FND_API.G_EXC_ERROR;
346: END IF;
347:
348: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then
349: delete from igw_budget_details_cal_amts

Line 348: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then

344: End if;
345: RAISE FND_API.G_EXC_ERROR;
346: END IF;
347:
348: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then
349: delete from igw_budget_details_cal_amts
350: where line_item_id = p_line_item_id
351: and rate_class_id = p_rate_class_id
352: and rate_type_id = p_rate_type_id;

Line 362: (p_encoded => FND_API.G_TRUE ,

358: If l_msg_count > 0 THEN
359: x_msg_count := l_msg_count;
360: If l_msg_count = 1 THEN
361: fnd_msg_pub.get
362: (p_encoded => FND_API.G_TRUE ,
363: p_msg_index => 1,
364: p_data => l_data,
365: p_msg_index_out => l_msg_index_out );
366:

Line 369: RAISE FND_API.G_EXC_ERROR;

365: p_msg_index_out => l_msg_index_out );
366:
367: x_msg_data := l_data;
368: End if;
369: RAISE FND_API.G_EXC_ERROR;
370: End if;
371:
372: x_return_status := FND_API.G_RET_STS_SUCCESS;
373:

Line 372: x_return_status := FND_API.G_RET_STS_SUCCESS;

368: End if;
369: RAISE FND_API.G_EXC_ERROR;
370: End if;
371:
372: x_return_status := FND_API.G_RET_STS_SUCCESS;
373:
374: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
375: IF p_commit = FND_API.G_TRUE THEN
376: ROLLBACK TO delete_budget_line_oh;

Line 374: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

370: End if;
371:
372: x_return_status := FND_API.G_RET_STS_SUCCESS;
373:
374: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
375: IF p_commit = FND_API.G_TRUE THEN
376: ROLLBACK TO delete_budget_line_oh;
377: END IF;
378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 375: IF p_commit = FND_API.G_TRUE THEN

371:
372: x_return_status := FND_API.G_RET_STS_SUCCESS;
373:
374: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
375: IF p_commit = FND_API.G_TRUE THEN
376: ROLLBACK TO delete_budget_line_oh;
377: END IF;
378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
379: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,

Line 378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

374: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
375: IF p_commit = FND_API.G_TRUE THEN
376: ROLLBACK TO delete_budget_line_oh;
377: END IF;
378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
379: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,
380: p_procedure_name => l_api_name,
381: p_error_text => SUBSTRB(SQLERRM,1,240));
382: fnd_msg_pub.count_and_get(p_count => x_msg_count

Line 384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

380: p_procedure_name => l_api_name,
381: p_error_text => SUBSTRB(SQLERRM,1,240));
382: fnd_msg_pub.count_and_get(p_count => x_msg_count
383: ,p_data => x_msg_data);
384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
385:
386: WHEN FND_API.G_EXC_ERROR THEN
387: IF p_commit = FND_API.G_TRUE THEN
388: ROLLBACK TO delete_budget_line_oh;

Line 386: WHEN FND_API.G_EXC_ERROR THEN

382: fnd_msg_pub.count_and_get(p_count => x_msg_count
383: ,p_data => x_msg_data);
384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
385:
386: WHEN FND_API.G_EXC_ERROR THEN
387: IF p_commit = FND_API.G_TRUE THEN
388: ROLLBACK TO delete_budget_line_oh;
389: END IF;
390: x_return_status := 'E';

Line 387: IF p_commit = FND_API.G_TRUE THEN

383: ,p_data => x_msg_data);
384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
385:
386: WHEN FND_API.G_EXC_ERROR THEN
387: IF p_commit = FND_API.G_TRUE THEN
388: ROLLBACK TO delete_budget_line_oh;
389: END IF;
390: x_return_status := 'E';
391:

Line 393: IF p_commit = FND_API.G_TRUE THEN

389: END IF;
390: x_return_status := 'E';
391:
392: WHEN OTHERS THEN
393: IF p_commit = FND_API.G_TRUE THEN
394: ROLLBACK TO delete_budget_line_oh;
395: END IF;
396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
397: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,

Line 396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

392: WHEN OTHERS THEN
393: IF p_commit = FND_API.G_TRUE THEN
394: ROLLBACK TO delete_budget_line_oh;
395: END IF;
396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
397: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,
398: p_procedure_name => l_api_name,
399: p_error_text => SUBSTRB(SQLERRM,1,240));
400: fnd_msg_pub.count_and_get(p_count => x_msg_count