DBA Data[Home] [Help]

APPS.IGW_BUDGET_PERSONNEL_OH_PVT dependencies on FND_MSG_PUB

Line 38: fnd_msg_pub.initialize;

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

Line 57: l_msg_count := FND_MSG_PUB.count_msg;

53: ,p_calculated_cost_sharing => p_calculated_cost_sharing);
54:
55: end if; -- p_validate_only = 'Y'
56:
57: l_msg_count := FND_MSG_PUB.count_msg;
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

Line 61: fnd_msg_pub.get

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

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

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

Line 82: fnd_msg_pub.count_and_get(p_count => x_msg_count

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

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

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

Line 100: fnd_msg_pub.count_and_get(p_count => x_msg_count

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
101: ,p_data => x_msg_data);
102: RAISE;
103:
104:

Line 145: fnd_msg_pub.initialize;

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

Line 162: FND_MSG_PUB.Add;

158: AND record_version_number = p_record_version_number;
159: EXCEPTION
160: WHEN NO_DATA_FOUND THEN
161: FND_MESSAGE.SET_NAME('IGW','IGW_SS_RECORD_CHANGED');
162: FND_MSG_PUB.Add;
163: x_msg_data := 'IGW_SS_RECORD_CHANGED';
164: x_return_status := 'E' ;
165: END;
166:

Line 167: l_msg_count := FND_MSG_PUB.count_msg;

163: x_msg_data := 'IGW_SS_RECORD_CHANGED';
164: x_return_status := 'E' ;
165: END;
166:
167: l_msg_count := FND_MSG_PUB.count_msg;
168:
169: IF l_msg_count > 0 THEN
170: x_msg_count := l_msg_count;
171: x_return_status := 'E';

Line 173: fnd_msg_pub.get

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

Line 229: l_msg_count := FND_MSG_PUB.count_msg;

225:
226: end if; -- p_validate_only = 'Y'
227:
228:
229: l_msg_count := FND_MSG_PUB.count_msg;
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

Line 233: fnd_msg_pub.get

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

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

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

Line 254: fnd_msg_pub.count_and_get(p_count => x_msg_count

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

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

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

Line 272: fnd_msg_pub.count_and_get(p_count => x_msg_count

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
273: ,p_data => x_msg_data);
274: RAISE;
275:
276: END; --UPDATE BUDGET PERSONNEL OH

Line 312: fnd_msg_pub.initialize;

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

Line 326: FND_MSG_PUB.Add;

322: AND record_version_number = p_record_version_number;
323: EXCEPTION
324: WHEN NO_DATA_FOUND THEN
325: FND_MESSAGE.SET_NAME('IGW','IGW_SS_RECORD_CHANGED');
326: FND_MSG_PUB.Add;
327: x_msg_data := 'IGW_SS_RECORD_CHANGED';
328: x_return_status := 'E' ;
329: END;
330:

Line 331: l_msg_count := FND_MSG_PUB.count_msg;

327: x_msg_data := 'IGW_SS_RECORD_CHANGED';
328: x_return_status := 'E' ;
329: END;
330:
331: l_msg_count := FND_MSG_PUB.count_msg;
332:
333: IF l_msg_count > 0 THEN
334: x_msg_count := l_msg_count;
335: x_return_status := 'E';

Line 337: fnd_msg_pub.get

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

Line 357: l_msg_count := FND_MSG_PUB.count_msg;

353:
354: end if; -- p_validate_only = 'Y'
355:
356:
357: l_msg_count := FND_MSG_PUB.count_msg;
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

Line 361: fnd_msg_pub.get

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

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

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

Line 382: fnd_msg_pub.count_and_get(p_count => x_msg_count

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

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

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

Line 400: fnd_msg_pub.count_and_get(p_count => x_msg_count

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
401: ,p_data => x_msg_data);
402: RAISE;
403:
404: