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

Line 20: x_return_status := Fnd_Api.G_Ret_Sts_Error;

16: and version_id = p_version_id
17: and budget_period_id = p_budget_period_id;
18:
19: if l_exists = '1' then
20: x_return_status := Fnd_Api.G_Ret_Sts_Error;
21: Fnd_Message.Set_Name('IGW','IGW_DUPLICATE_PERIOD');
22: Fnd_Message.set_token('PERIOD_ID', p_budget_period_id);
23: Fnd_Msg_Pub.Add;
24: end if;

Line 29: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

25: exception
26: when no_data_found then
27: null;
28: when others then
29: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
30: Fnd_Msg_Pub.Add_Exc_Msg(
31: p_pkg_name => G_package_name,
32: p_procedure_name => l_api_name);
33: RAISE Fnd_Api.G_Exc_Unexpected_Error;

Line 33: RAISE Fnd_Api.G_Exc_Unexpected_Error;

29: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
30: Fnd_Msg_Pub.Add_Exc_Msg(
31: p_pkg_name => G_package_name,
32: p_procedure_name => l_api_name);
33: RAISE Fnd_Api.G_Exc_Unexpected_Error;
34: end;
35:
36: ------------------------------------------------------------------------------------------
37: procedure validate_period_date (p_proposal_id NUMBER

Line 71: x_return_status := Fnd_Api.G_Ret_Sts_Error;

67: fetch c_version into l_version_start_date, l_version_end_date;
68: close c_version;
69:
70: if p_start_date < l_version_start_date OR p_end_date > l_version_end_date then
71: x_return_status := Fnd_Api.G_Ret_Sts_Error;
72: Fnd_Message.Set_Name('IGW','IGW_PERIOD_OUTSIDE_VERSION');
73: Fnd_Msg_Pub.Add;
74: end if;
75:

Line 81: x_return_status := Fnd_Api.G_Ret_Sts_Error;

77: fetch c_budget_line into l_personnel_start_date, l_personnel_end_date;
78: close c_budget_line;
79:
80: if p_start_date > l_personnel_start_date OR p_end_date < l_personnel_end_date then
81: x_return_status := Fnd_Api.G_Ret_Sts_Error;
82: Fnd_Message.Set_Name('IGW','IGW_PERIOD_OUTSIDE_PERSONNEL');
83: Fnd_Msg_Pub.Add;
84: end if;
85: exception

Line 87: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

83: Fnd_Msg_Pub.Add;
84: end if;
85: exception
86: when others then
87: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
88: Fnd_Msg_Pub.Add_Exc_Msg(
89: p_pkg_name => G_package_name,
90: p_procedure_name => l_api_name);
91: RAISE Fnd_Api.G_Exc_Unexpected_Error;

Line 91: RAISE Fnd_Api.G_Exc_Unexpected_Error;

87: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
88: Fnd_Msg_Pub.Add_Exc_Msg(
89: p_pkg_name => G_package_name,
90: p_procedure_name => l_api_name);
91: RAISE Fnd_Api.G_Exc_Unexpected_Error;
92: end;
93:
94: --------------------------------------------------------------------------------
95:

Line 119: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

115:
116: exception
117: when no_data_found then null;
118: when others then
119: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
120: Fnd_Msg_Pub.Add_Exc_Msg(
121: p_pkg_name => G_package_name,
122: p_procedure_name => l_api_name);
123: RAISE Fnd_Api.G_Exc_Unexpected_Error;

Line 123: RAISE Fnd_Api.G_Exc_Unexpected_Error;

119: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
120: Fnd_Msg_Pub.Add_Exc_Msg(
121: p_pkg_name => G_package_name,
122: p_procedure_name => l_api_name);
123: RAISE Fnd_Api.G_Exc_Unexpected_Error;
124: end validate_date_overlap;
125: -------------------------------------------------------------------------------
126: procedure create_budget_period
127: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

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

123: RAISE Fnd_Api.G_Exc_Unexpected_Error;
124: end validate_date_overlap;
125: -------------------------------------------------------------------------------
126: procedure create_budget_period
127: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
128: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
129: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
130: ,p_proposal_id NUMBER
131: ,p_version_id NUMBER

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

124: end validate_date_overlap;
125: -------------------------------------------------------------------------------
126: procedure create_budget_period
127: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
128: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
129: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
130: ,p_proposal_id NUMBER
131: ,p_version_id NUMBER
132: ,p_budget_period_id NUMBER

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

125: -------------------------------------------------------------------------------
126: procedure create_budget_period
127: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
128: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
129: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
130: ,p_proposal_id NUMBER
131: ,p_version_id NUMBER
132: ,p_budget_period_id NUMBER
133: ,p_start_date DATE

Line 161: IF p_commit = FND_API.G_TRUE THEN

157: l_data VARCHAR2(250);
158: l_msg_index_out NUMBER;
159:
160: BEGIN
161: IF p_commit = FND_API.G_TRUE THEN
162: SAVEPOINT create_budget_version;
163: END IF;
164:
165: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then

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

161: IF p_commit = FND_API.G_TRUE THEN
162: SAVEPOINT create_budget_version;
163: END IF;
164:
165: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
166: fnd_msg_pub.initialize;
167: end if;
168:
169: x_return_status := 'S';

Line 175: if l_return_status = FND_API.G_RET_STS_ERROR THEN

171: check_duplicate_period(p_proposal_id
172: ,p_version_id
173: ,p_budget_period_id
174: ,x_return_status );
175: if l_return_status = FND_API.G_RET_STS_ERROR THEN
176: x_return_status := 'E';
177: end if;
178:
179: IGW_UTILS.Check_Date_Validity(

Line 185: if l_return_status = FND_API.G_RET_STS_ERROR THEN

181: ,p_start_date => nvl(p_start_date, sysdate-1)
182: ,p_end_date => nvl(p_end_date, sysdate+1)
183: ,x_return_status => l_return_status);
184:
185: if l_return_status = FND_API.G_RET_STS_ERROR THEN
186: x_return_status := 'E';
187: end if;
188:
189: validate_period_date(p_proposal_id

Line 196: if l_return_status = FND_API.G_RET_STS_ERROR THEN

192: ,p_start_date
193: ,p_end_date
194: ,l_return_status);
195:
196: if l_return_status = FND_API.G_RET_STS_ERROR THEN
197: x_return_status := 'E';
198: end if;
199:
200: validate_date_overlap(p_proposal_id

Line 206: if l_return_status = FND_API.G_RET_STS_ERROR THEN

202: ,p_budget_period_id
203: ,p_start_date
204: ,l_return_status);
205:
206: if l_return_status = FND_API.G_RET_STS_ERROR THEN
207: x_return_status := 'E';
208: end if;
209:
210:

Line 216: (p_encoded => FND_API.G_TRUE ,

212: If l_msg_count > 0 THEN
213: x_msg_count := l_msg_count;
214: If l_msg_count = 1 THEN
215: fnd_msg_pub.get
216: (p_encoded => FND_API.G_TRUE ,
217: p_msg_index => 1,
218: p_data => l_data,
219: p_msg_index_out => l_msg_index_out );
220:

Line 223: RAISE FND_API.G_EXC_ERROR;

219: p_msg_index_out => l_msg_index_out );
220:
221: x_msg_data := l_data;
222: End if;
223: RAISE FND_API.G_EXC_ERROR;
224: End if;
225:
226: x_return_status := 'S';
227:

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

224: End if;
225:
226: x_return_status := 'S';
227:
228: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then
229:
230: l_total_cost := nvl(p_total_indirect_cost,0) + nvl(p_total_direct_Cost,0);
231: igw_budget_periods_tbh.insert_row(
232: p_proposal_id => p_proposal_id

Line 266: (p_encoded => FND_API.G_TRUE ,

262: If l_msg_count > 0 THEN
263: x_msg_count := l_msg_count;
264: If l_msg_count = 1 THEN
265: fnd_msg_pub.get
266: (p_encoded => FND_API.G_TRUE ,
267: p_msg_index => 1,
268: p_data => l_data,
269: p_msg_index_out => l_msg_index_out );
270:

Line 273: RAISE FND_API.G_EXC_ERROR;

269: p_msg_index_out => l_msg_index_out );
270:
271: x_msg_data := l_data;
272: End if;
273: RAISE FND_API.G_EXC_ERROR;
274: End if;
275:
276: x_return_status := FND_API.G_RET_STS_SUCCESS;
277:

Line 276: x_return_status := FND_API.G_RET_STS_SUCCESS;

272: End if;
273: RAISE FND_API.G_EXC_ERROR;
274: End if;
275:
276: x_return_status := FND_API.G_RET_STS_SUCCESS;
277:
278: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
279: IF p_commit = FND_API.G_TRUE THEN
280: ROLLBACK TO create_budget_version;

Line 278: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

274: End if;
275:
276: x_return_status := FND_API.G_RET_STS_SUCCESS;
277:
278: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
279: IF p_commit = FND_API.G_TRUE THEN
280: ROLLBACK TO create_budget_version;
281: END IF;
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 279: IF p_commit = FND_API.G_TRUE THEN

275:
276: x_return_status := FND_API.G_RET_STS_SUCCESS;
277:
278: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
279: IF p_commit = FND_API.G_TRUE THEN
280: ROLLBACK TO create_budget_version;
281: END IF;
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
283: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,

Line 282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

278: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
279: IF p_commit = FND_API.G_TRUE THEN
280: ROLLBACK TO create_budget_version;
281: END IF;
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
283: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,
284: p_procedure_name => l_api_name,
285: p_error_text => SUBSTRB(SQLERRM,1,240));
286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
283: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,
284: p_procedure_name => l_api_name,
285: p_error_text => SUBSTRB(SQLERRM,1,240));
286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
287: fnd_msg_pub.count_and_get(p_count => x_msg_count
288: ,p_data => x_msg_data);
289:
290: WHEN FND_API.G_EXC_ERROR THEN

Line 290: WHEN FND_API.G_EXC_ERROR THEN

286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
287: fnd_msg_pub.count_and_get(p_count => x_msg_count
288: ,p_data => x_msg_data);
289:
290: WHEN FND_API.G_EXC_ERROR THEN
291: IF p_commit = FND_API.G_TRUE THEN
292: ROLLBACK TO create_budget_version;
293: END IF;
294: x_return_status := 'E';

Line 291: IF p_commit = FND_API.G_TRUE THEN

287: fnd_msg_pub.count_and_get(p_count => x_msg_count
288: ,p_data => x_msg_data);
289:
290: WHEN FND_API.G_EXC_ERROR THEN
291: IF p_commit = FND_API.G_TRUE THEN
292: ROLLBACK TO create_budget_version;
293: END IF;
294: x_return_status := 'E';
295:

Line 297: IF p_commit = FND_API.G_TRUE THEN

293: END IF;
294: x_return_status := 'E';
295:
296: WHEN OTHERS THEN
297: IF p_commit = FND_API.G_TRUE THEN
298: ROLLBACK TO create_budget_version;
299: END IF;
300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
301: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,

Line 300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

296: WHEN OTHERS THEN
297: IF p_commit = FND_API.G_TRUE THEN
298: ROLLBACK TO create_budget_version;
299: END IF;
300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
301: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,
302: p_procedure_name => l_api_name,
303: p_error_text => SUBSTRB(SQLERRM,1,240));
304: fnd_msg_pub.count_and_get(p_count => x_msg_count

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

310:
311:
312: ------------------------------------------------------------------------------------------
313: procedure update_budget_period
314: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
315: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
316: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
317: ,p_proposal_id NUMBER
318: ,p_version_id NUMBER

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

311:
312: ------------------------------------------------------------------------------------------
313: procedure update_budget_period
314: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
315: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
316: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
317: ,p_proposal_id NUMBER
318: ,p_version_id NUMBER
319: ,p_budget_period_id NUMBER

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

312: ------------------------------------------------------------------------------------------
313: procedure update_budget_period
314: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
315: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
316: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
317: ,p_proposal_id NUMBER
318: ,p_version_id NUMBER
319: ,p_budget_period_id NUMBER
320: ,p_start_date DATE

Line 351: IF p_commit = FND_API.G_TRUE THEN

347: l_msg_index_out NUMBER;
348: l_dummy VARCHAR2(1);
349:
350: BEGIN
351: IF p_commit = FND_API.G_TRUE THEN
352: SAVEPOINT update_budget_version;
353: END IF;
354:
355: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then

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

351: IF p_commit = FND_API.G_TRUE THEN
352: SAVEPOINT update_budget_version;
353: END IF;
354:
355: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
356: fnd_msg_pub.initialize;
357: end if;
358:
359: x_return_status := 'S';

Line 376: if l_return_status = FND_API.G_RET_STS_ERROR THEN

372: check_duplicate_period(p_proposal_id
373: ,p_version_id
374: ,p_budget_period_id
375: ,x_return_status );
376: if l_return_status = FND_API.G_RET_STS_ERROR THEN
377: x_return_status := 'E';
378: end if;
379: end if;
380:

Line 387: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

383: ,p_start_date => nvl(p_start_date, sysdate-1)
384: ,p_end_date => nvl(p_end_date, sysdate+1)
385: ,x_return_status => l_return_status);
386:
387: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
388: x_return_status := 'E';
389: END IF;
390:
391: validate_period_date(p_proposal_id

Line 398: if l_return_status = FND_API.G_RET_STS_ERROR THEN

394: ,p_start_date
395: ,p_end_date
396: ,l_return_status);
397:
398: if l_return_status = FND_API.G_RET_STS_ERROR THEN
399: x_return_status := 'E';
400: end if;
401:
402: validate_date_overlap(p_proposal_id

Line 408: if l_return_status = FND_API.G_RET_STS_ERROR THEN

404: ,l_orig_budget_period_id
405: ,p_start_date
406: ,l_return_status);
407:
408: if l_return_status = FND_API.G_RET_STS_ERROR THEN
409: x_return_status := 'E';
410: end if;
411:
412:

Line 420: (p_encoded => FND_API.G_TRUE ,

416: If l_msg_count > 0 THEN
417: x_msg_count := l_msg_count;
418: If l_msg_count = 1 THEN
419: fnd_msg_pub.get
420: (p_encoded => FND_API.G_TRUE ,
421: p_msg_index => 1,
422: p_data => l_data,
423: p_msg_index_out => l_msg_index_out );
424:

Line 427: RAISE FND_API.G_EXC_ERROR;

423: p_msg_index_out => l_msg_index_out );
424:
425: x_msg_data := l_data;
426: End if;
427: RAISE FND_API.G_EXC_ERROR;
428: End if;
429:
430: BEGIN
431: SELECT 'x' INTO l_dummy

Line 452: (p_encoded => FND_API.G_TRUE ,

448: x_msg_count := l_msg_count;
449: x_return_status := 'E';
450: If l_msg_count = 1 THEN
451: fnd_msg_pub.get
452: (p_encoded => FND_API.G_TRUE ,
453: p_msg_index => 1,
454: p_data => l_data,
455: p_msg_index_out => l_msg_index_out );
456:

Line 459: RAISE FND_API.G_EXC_ERROR;

455: p_msg_index_out => l_msg_index_out );
456:
457: x_msg_data := l_data;
458: End if;
459: RAISE FND_API.G_EXC_ERROR;
460: END IF;
461:
462: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then
463:

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

458: End if;
459: RAISE FND_API.G_EXC_ERROR;
460: END IF;
461:
462: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then
463:
464: l_total_cost := nvl(p_total_indirect_cost,0) + nvl(p_total_direct_Cost,0);
465:
466: igw_budget_periods_tbh.update_row(

Line 526: (p_encoded => FND_API.G_TRUE ,

522: If l_msg_count > 0 THEN
523: x_msg_count := l_msg_count;
524: If l_msg_count = 1 THEN
525: fnd_msg_pub.get
526: (p_encoded => FND_API.G_TRUE ,
527: p_msg_index => 1,
528: p_data => l_data,
529: p_msg_index_out => l_msg_index_out );
530:

Line 533: RAISE FND_API.G_EXC_ERROR;

529: p_msg_index_out => l_msg_index_out );
530:
531: x_msg_data := l_data;
532: End if;
533: RAISE FND_API.G_EXC_ERROR;
534: End if;
535:
536: x_return_status := FND_API.G_RET_STS_SUCCESS;
537:

Line 536: x_return_status := FND_API.G_RET_STS_SUCCESS;

532: End if;
533: RAISE FND_API.G_EXC_ERROR;
534: End if;
535:
536: x_return_status := FND_API.G_RET_STS_SUCCESS;
537:
538: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
539: IF p_commit = FND_API.G_TRUE THEN
540: ROLLBACK TO update_budget_version;

Line 538: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

534: End if;
535:
536: x_return_status := FND_API.G_RET_STS_SUCCESS;
537:
538: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
539: IF p_commit = FND_API.G_TRUE THEN
540: ROLLBACK TO update_budget_version;
541: END IF;
542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 539: IF p_commit = FND_API.G_TRUE THEN

535:
536: x_return_status := FND_API.G_RET_STS_SUCCESS;
537:
538: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
539: IF p_commit = FND_API.G_TRUE THEN
540: ROLLBACK TO update_budget_version;
541: END IF;
542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
543: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,

Line 542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

538: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
539: IF p_commit = FND_API.G_TRUE THEN
540: ROLLBACK TO update_budget_version;
541: END IF;
542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
543: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,
544: p_procedure_name => l_api_name,
545: p_error_text => SUBSTRB(SQLERRM,1,240));
546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
543: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,
544: p_procedure_name => l_api_name,
545: p_error_text => SUBSTRB(SQLERRM,1,240));
546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
547: fnd_msg_pub.count_and_get(p_count => x_msg_count
548: ,p_data => x_msg_data);
549:
550: WHEN FND_API.G_EXC_ERROR THEN

Line 550: WHEN FND_API.G_EXC_ERROR THEN

546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
547: fnd_msg_pub.count_and_get(p_count => x_msg_count
548: ,p_data => x_msg_data);
549:
550: WHEN FND_API.G_EXC_ERROR THEN
551: IF p_commit = FND_API.G_TRUE THEN
552: ROLLBACK TO update_budget_version;
553: END IF;
554: x_return_status := 'E';

Line 551: IF p_commit = FND_API.G_TRUE THEN

547: fnd_msg_pub.count_and_get(p_count => x_msg_count
548: ,p_data => x_msg_data);
549:
550: WHEN FND_API.G_EXC_ERROR THEN
551: IF p_commit = FND_API.G_TRUE THEN
552: ROLLBACK TO update_budget_version;
553: END IF;
554: x_return_status := 'E';
555:

Line 557: IF p_commit = FND_API.G_TRUE THEN

553: END IF;
554: x_return_status := 'E';
555:
556: WHEN OTHERS THEN
557: IF p_commit = FND_API.G_TRUE THEN
558: ROLLBACK TO update_budget_version;
559: END IF;
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
561: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,

Line 560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

556: WHEN OTHERS THEN
557: IF p_commit = FND_API.G_TRUE THEN
558: ROLLBACK TO update_budget_version;
559: END IF;
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
561: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,
562: p_procedure_name => l_api_name,
563: p_error_text => SUBSTRB(SQLERRM,1,240));
564: fnd_msg_pub.count_and_get(p_count => x_msg_count

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

569:
570: -------------------------------------------------------------------------------------------
571:
572: procedure delete_budget_period
573: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
574: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
575: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
576: ,p_proposal_id NUMBER
577: ,p_version_id NUMBER

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

570: -------------------------------------------------------------------------------------------
571:
572: procedure delete_budget_period
573: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
574: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
575: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
576: ,p_proposal_id NUMBER
577: ,p_version_id NUMBER
578: ,p_budget_period_id NUMBER

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

571:
572: procedure delete_budget_period
573: (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
574: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
575: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
576: ,p_proposal_id NUMBER
577: ,p_version_id NUMBER
578: ,p_budget_period_id NUMBER
579: ,p_record_version_number IN NUMBER

Line 595: IF p_commit = FND_API.G_TRUE THEN

591:
592:
593:
594: BEGIN
595: IF p_commit = FND_API.G_TRUE THEN
596: SAVEPOINT delete_budget_version;
597: END IF;
598:
599: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then

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

595: IF p_commit = FND_API.G_TRUE THEN
596: SAVEPOINT delete_budget_version;
597: END IF;
598:
599: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
600: fnd_msg_pub.initialize;
601: end if;
602:
603: x_return_status := 'S';

Line 627: (p_encoded => FND_API.G_TRUE ,

623: x_msg_count := l_msg_count;
624: x_return_status := 'E';
625: If l_msg_count = 1 THEN
626: fnd_msg_pub.get
627: (p_encoded => FND_API.G_TRUE ,
628: p_msg_index => 1,
629: p_data => l_data,
630: p_msg_index_out => l_msg_index_out );
631:

Line 634: RAISE FND_API.G_EXC_ERROR;

630: p_msg_index_out => l_msg_index_out );
631:
632: x_msg_data := l_data;
633: End if;
634: RAISE FND_API.G_EXC_ERROR;
635: END IF;
636:
637: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then
638:

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

633: End if;
634: RAISE FND_API.G_EXC_ERROR;
635: END IF;
636:
637: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then
638:
639: igw_budget_periods_tbh.delete_row (
640: p_rowid => p_rowid,
641: p_proposal_id => p_proposal_id,

Line 672: (p_encoded => FND_API.G_TRUE ,

668: If l_msg_count > 0 THEN
669: x_msg_count := l_msg_count;
670: If l_msg_count = 1 THEN
671: fnd_msg_pub.get
672: (p_encoded => FND_API.G_TRUE ,
673: p_msg_index => 1,
674: p_data => l_data,
675: p_msg_index_out => l_msg_index_out );
676:

Line 679: RAISE FND_API.G_EXC_ERROR;

675: p_msg_index_out => l_msg_index_out );
676:
677: x_msg_data := l_data;
678: End if;
679: RAISE FND_API.G_EXC_ERROR;
680: End if;
681:
682: x_return_status := FND_API.G_RET_STS_SUCCESS;
683:

Line 682: x_return_status := FND_API.G_RET_STS_SUCCESS;

678: End if;
679: RAISE FND_API.G_EXC_ERROR;
680: End if;
681:
682: x_return_status := FND_API.G_RET_STS_SUCCESS;
683:
684: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
685: IF p_commit = FND_API.G_TRUE THEN
686: ROLLBACK TO delete_budget_version;

Line 684: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

680: End if;
681:
682: x_return_status := FND_API.G_RET_STS_SUCCESS;
683:
684: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
685: IF p_commit = FND_API.G_TRUE THEN
686: ROLLBACK TO delete_budget_version;
687: END IF;
688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 685: IF p_commit = FND_API.G_TRUE THEN

681:
682: x_return_status := FND_API.G_RET_STS_SUCCESS;
683:
684: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
685: IF p_commit = FND_API.G_TRUE THEN
686: ROLLBACK TO delete_budget_version;
687: END IF;
688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
689: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,

Line 688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

684: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
685: IF p_commit = FND_API.G_TRUE THEN
686: ROLLBACK TO delete_budget_version;
687: END IF;
688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
689: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,
690: p_procedure_name => l_api_name,
691: p_error_text => SUBSTRB(SQLERRM,1,240));
692: fnd_msg_pub.count_and_get(p_count => x_msg_count

Line 694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

690: p_procedure_name => l_api_name,
691: p_error_text => SUBSTRB(SQLERRM,1,240));
692: fnd_msg_pub.count_and_get(p_count => x_msg_count
693: ,p_data => x_msg_data);
694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
695:
696: WHEN FND_API.G_EXC_ERROR THEN
697: IF p_commit = FND_API.G_TRUE THEN
698: ROLLBACK TO delete_budget_version;

Line 696: WHEN FND_API.G_EXC_ERROR THEN

692: fnd_msg_pub.count_and_get(p_count => x_msg_count
693: ,p_data => x_msg_data);
694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
695:
696: WHEN FND_API.G_EXC_ERROR THEN
697: IF p_commit = FND_API.G_TRUE THEN
698: ROLLBACK TO delete_budget_version;
699: END IF;
700: x_return_status := 'E';

Line 697: IF p_commit = FND_API.G_TRUE THEN

693: ,p_data => x_msg_data);
694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
695:
696: WHEN FND_API.G_EXC_ERROR THEN
697: IF p_commit = FND_API.G_TRUE THEN
698: ROLLBACK TO delete_budget_version;
699: END IF;
700: x_return_status := 'E';
701:

Line 703: IF p_commit = FND_API.G_TRUE THEN

699: END IF;
700: x_return_status := 'E';
701:
702: WHEN OTHERS THEN
703: IF p_commit = FND_API.G_TRUE THEN
704: ROLLBACK TO delete_budget_version;
705: END IF;
706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
707: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,

Line 706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

702: WHEN OTHERS THEN
703: IF p_commit = FND_API.G_TRUE THEN
704: ROLLBACK TO delete_budget_version;
705: END IF;
706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
707: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,
708: p_procedure_name => l_api_name,
709: p_error_text => SUBSTRB(SQLERRM,1,240));
710: fnd_msg_pub.count_and_get(p_count => x_msg_count