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_MSG_PUB

Line 23: Fnd_Msg_Pub.Add;

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;
25: exception
26: when no_data_found then
27: null;

Line 30: Fnd_Msg_Pub.Add_Exc_Msg(

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;
34: end;

Line 73: Fnd_Msg_Pub.Add;

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:
76: open c_budget_line;
77: fetch c_budget_line into l_personnel_start_date, l_personnel_end_date;

Line 83: Fnd_Msg_Pub.Add;

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
86: when others then
87: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

Line 88: Fnd_Msg_Pub.Add_Exc_Msg(

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;
92: end;

Line 114: Fnd_Msg_Pub.Add;

110: and budget_period_id <> p_budget_period_id
111: and rownum < 2;
112:
113: fnd_message.set_name('IGW', 'IGW_BUDGET_DATE_OVERLAP');
114: Fnd_Msg_Pub.Add;
115:
116: exception
117: when no_data_found then null;
118: when others then

Line 120: Fnd_Msg_Pub.Add_Exc_Msg(

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;
124: end validate_date_overlap;

Line 166: fnd_msg_pub.initialize;

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';
170:

Line 211: l_msg_count := FND_MSG_PUB.count_msg;

207: x_return_status := 'E';
208: end if;
209:
210:
211: l_msg_count := FND_MSG_PUB.count_msg;
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

Line 215: fnd_msg_pub.get

211: l_msg_count := FND_MSG_PUB.count_msg;
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 );

Line 261: l_msg_count := FND_MSG_PUB.count_msg;

257:
258:
259: end if; -- p_validate_only = 'Y'
260:
261: l_msg_count := FND_MSG_PUB.count_msg;
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

Line 265: fnd_msg_pub.get

261: l_msg_count := FND_MSG_PUB.count_msg;
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 );

Line 283: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,

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;
287: fnd_msg_pub.count_and_get(p_count => x_msg_count

Line 287: fnd_msg_pub.count_and_get(p_count => x_msg_count

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
291: IF p_commit = FND_API.G_TRUE THEN

Line 301: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,

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
305: ,p_data => x_msg_data);

Line 304: fnd_msg_pub.count_and_get(p_count => x_msg_count

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
305: ,p_data => x_msg_data);
306: RAISE;
307:
308:

Line 356: fnd_msg_pub.initialize;

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';
360:

Line 415: l_msg_count := FND_MSG_PUB.count_msg;

411:
412:
413:
414:
415: l_msg_count := FND_MSG_PUB.count_msg;
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

Line 419: fnd_msg_pub.get

415: l_msg_count := FND_MSG_PUB.count_msg;
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 );

Line 440: FND_MSG_PUB.Add;

436: AND record_version_number = p_record_version_number;
437: EXCEPTION
438: WHEN NO_DATA_FOUND THEN
439: FND_MESSAGE.SET_NAME('IGW','IGW_SS_RECORD_CHANGED');
440: FND_MSG_PUB.Add;
441: x_msg_data := 'IGW_SS_RECORD_CHANGED';
442: x_return_status := 'E' ;
443: END;
444:

Line 445: l_msg_count := FND_MSG_PUB.count_msg;

441: x_msg_data := 'IGW_SS_RECORD_CHANGED';
442: x_return_status := 'E' ;
443: END;
444:
445: l_msg_count := FND_MSG_PUB.count_msg;
446:
447: IF l_msg_count > 0 THEN
448: x_msg_count := l_msg_count;
449: x_return_status := 'E';

Line 451: fnd_msg_pub.get

447: IF l_msg_count > 0 THEN
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 );

Line 521: l_msg_count := FND_MSG_PUB.count_msg;

517:
518:
519: end if; -- p_validate_only = 'Y'
520:
521: l_msg_count := FND_MSG_PUB.count_msg;
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

Line 525: fnd_msg_pub.get

521: l_msg_count := FND_MSG_PUB.count_msg;
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 );

Line 543: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,

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;
547: fnd_msg_pub.count_and_get(p_count => x_msg_count

Line 547: fnd_msg_pub.count_and_get(p_count => x_msg_count

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
551: IF p_commit = FND_API.G_TRUE THEN

Line 561: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,

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
565: ,p_data => x_msg_data);

Line 564: fnd_msg_pub.count_and_get(p_count => x_msg_count

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
565: ,p_data => x_msg_data);
566: RAISE;
567:
568: END; --UPDATE BUDGET VERSIONS

Line 600: fnd_msg_pub.initialize;

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';
604:

Line 615: FND_MSG_PUB.Add;

611: AND record_version_number = p_record_version_number;
612: EXCEPTION
613: WHEN NO_DATA_FOUND THEN
614: FND_MESSAGE.SET_NAME('IGW','IGW_SS_RECORD_CHANGED');
615: FND_MSG_PUB.Add;
616: x_msg_data := 'IGW_SS_RECORD_CHANGED';
617: x_return_status := 'E' ;
618: END;
619:

Line 620: l_msg_count := FND_MSG_PUB.count_msg;

616: x_msg_data := 'IGW_SS_RECORD_CHANGED';
617: x_return_status := 'E' ;
618: END;
619:
620: l_msg_count := FND_MSG_PUB.count_msg;
621:
622: IF l_msg_count > 0 THEN
623: x_msg_count := l_msg_count;
624: x_return_status := 'E';

Line 626: fnd_msg_pub.get

622: IF l_msg_count > 0 THEN
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 );

Line 667: l_msg_count := FND_MSG_PUB.count_msg;

663:
664: end if; -- p_validate_only = 'Y'
665:
666:
667: l_msg_count := FND_MSG_PUB.count_msg;
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

Line 671: fnd_msg_pub.get

667: l_msg_count := FND_MSG_PUB.count_msg;
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 );

Line 689: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,

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
693: ,p_data => x_msg_data);

Line 692: fnd_msg_pub.count_and_get(p_count => x_msg_count

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
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

Line 707: fnd_msg_pub.add_exc_msg(p_pkg_name => G_package_name,

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
711: ,p_data => x_msg_data);

Line 710: fnd_msg_pub.count_and_get(p_count => x_msg_count

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
711: ,p_data => x_msg_data);
712: RAISE;
713:
714: