DBA Data[Home] [Help]

APPS.OKL_SYSTEM_PARAMS_ALL_PUB dependencies on FND_MSG_PUB

Line 43: FND_MSG_PUB.count_and_get(

39: EXCEPTION
40: WHEN G_EXCEPTION_ERROR THEN
41: ROLLBACK TO insert_row_trx;
42: x_return_status := G_RET_STS_ERROR;
43: FND_MSG_PUB.count_and_get(
44: p_count => x_msg_count
45: ,p_data => x_msg_data);
46: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
47: ROLLBACK TO insert_row_trx;

Line 49: FND_MSG_PUB.count_and_get(

45: ,p_data => x_msg_data);
46: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
47: ROLLBACK TO insert_row_trx;
48: x_return_status := G_RET_STS_UNEXP_ERROR;
49: FND_MSG_PUB.count_and_get(
50: p_count => x_msg_count
51: ,p_data => x_msg_data);
52: WHEN OTHERS THEN
53: ROLLBACK TO insert_row_trx;

Line 55: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','insert_system_parameters');

51: ,p_data => x_msg_data);
52: WHEN OTHERS THEN
53: ROLLBACK TO insert_row_trx;
54: x_return_status := G_RET_STS_UNEXP_ERROR;
55: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','insert_system_parameters');
56: FND_MSG_PUB.count_and_get(
57: p_count => x_msg_count
58: ,p_data => x_msg_data);
59: END insert_system_parameters;

Line 56: FND_MSG_PUB.count_and_get(

52: WHEN OTHERS THEN
53: ROLLBACK TO insert_row_trx;
54: x_return_status := G_RET_STS_UNEXP_ERROR;
55: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','insert_system_parameters');
56: FND_MSG_PUB.count_and_get(
57: p_count => x_msg_count
58: ,p_data => x_msg_data);
59: END insert_system_parameters;
60: -- Start of comments

Line 100: FND_MSG_PUB.count_and_get(

96: EXCEPTION
97: WHEN G_EXCEPTION_ERROR THEN
98: ROLLBACK TO insert_row_trx;
99: x_return_status := G_RET_STS_ERROR;
100: FND_MSG_PUB.count_and_get(
101: p_count => x_msg_count
102: ,p_data => x_msg_data);
103: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
104: ROLLBACK TO insert_row_trx;

Line 106: FND_MSG_PUB.count_and_get(

102: ,p_data => x_msg_data);
103: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
104: ROLLBACK TO insert_row_trx;
105: x_return_status := G_RET_STS_UNEXP_ERROR;
106: FND_MSG_PUB.count_and_get(
107: p_count => x_msg_count
108: ,p_data => x_msg_data);
109: WHEN OTHERS THEN
110: ROLLBACK TO insert_row_trx;

Line 112: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','insert_system_parameters');

108: ,p_data => x_msg_data);
109: WHEN OTHERS THEN
110: ROLLBACK TO insert_row_trx;
111: x_return_status := G_RET_STS_UNEXP_ERROR;
112: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','insert_system_parameters');
113: FND_MSG_PUB.count_and_get(
114: p_count => x_msg_count
115: ,p_data => x_msg_data);
116: END insert_system_parameters;

Line 113: FND_MSG_PUB.count_and_get(

109: WHEN OTHERS THEN
110: ROLLBACK TO insert_row_trx;
111: x_return_status := G_RET_STS_UNEXP_ERROR;
112: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','insert_system_parameters');
113: FND_MSG_PUB.count_and_get(
114: p_count => x_msg_count
115: ,p_data => x_msg_data);
116: END insert_system_parameters;
117: -- Start of comments

Line 155: FND_MSG_PUB.count_and_get(

151: EXCEPTION
152: WHEN G_EXCEPTION_ERROR THEN
153: ROLLBACK TO lock_row_trx;
154: x_return_status := G_RET_STS_ERROR;
155: FND_MSG_PUB.count_and_get(
156: p_count => x_msg_count
157: ,p_data => x_msg_data);
158: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
159: ROLLBACK TO lock_row_trx;

Line 161: FND_MSG_PUB.count_and_get(

157: ,p_data => x_msg_data);
158: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
159: ROLLBACK TO lock_row_trx;
160: x_return_status := G_RET_STS_UNEXP_ERROR;
161: FND_MSG_PUB.count_and_get(
162: p_count => x_msg_count
163: ,p_data => x_msg_data);
164: WHEN OTHERS THEN
165: ROLLBACK TO lock_row_trx;

Line 167: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','lock_system_parameters');

163: ,p_data => x_msg_data);
164: WHEN OTHERS THEN
165: ROLLBACK TO lock_row_trx;
166: x_return_status := G_RET_STS_UNEXP_ERROR;
167: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','lock_system_parameters');
168: FND_MSG_PUB.count_and_get(
169: p_count => x_msg_count
170: ,p_data => x_msg_data);
171: END lock_system_parameters;

Line 168: FND_MSG_PUB.count_and_get(

164: WHEN OTHERS THEN
165: ROLLBACK TO lock_row_trx;
166: x_return_status := G_RET_STS_UNEXP_ERROR;
167: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','lock_system_parameters');
168: FND_MSG_PUB.count_and_get(
169: p_count => x_msg_count
170: ,p_data => x_msg_data);
171: END lock_system_parameters;
172: -- Start of comments

Line 210: FND_MSG_PUB.count_and_get(

206: EXCEPTION
207: WHEN G_EXCEPTION_ERROR THEN
208: ROLLBACK TO lock_row_trx;
209: x_return_status := G_RET_STS_ERROR;
210: FND_MSG_PUB.count_and_get(
211: p_count => x_msg_count
212: ,p_data => x_msg_data);
213: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
214: ROLLBACK TO lock_row_trx;

Line 216: FND_MSG_PUB.count_and_get(

212: ,p_data => x_msg_data);
213: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
214: ROLLBACK TO lock_row_trx;
215: x_return_status := G_RET_STS_UNEXP_ERROR;
216: FND_MSG_PUB.count_and_get(
217: p_count => x_msg_count
218: ,p_data => x_msg_data);
219: WHEN OTHERS THEN
220: ROLLBACK TO lock_row_trx;

Line 222: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','lock_system_parameters');

218: ,p_data => x_msg_data);
219: WHEN OTHERS THEN
220: ROLLBACK TO lock_row_trx;
221: x_return_status := G_RET_STS_UNEXP_ERROR;
222: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','lock_system_parameters');
223: FND_MSG_PUB.count_and_get(
224: p_count => x_msg_count
225: ,p_data => x_msg_data);
226: END lock_system_parameters;

Line 223: FND_MSG_PUB.count_and_get(

219: WHEN OTHERS THEN
220: ROLLBACK TO lock_row_trx;
221: x_return_status := G_RET_STS_UNEXP_ERROR;
222: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','lock_system_parameters');
223: FND_MSG_PUB.count_and_get(
224: p_count => x_msg_count
225: ,p_data => x_msg_data);
226: END lock_system_parameters;
227: -- Start of comments

Line 267: FND_MSG_PUB.count_and_get(

263: EXCEPTION
264: WHEN G_EXCEPTION_ERROR THEN
265: ROLLBACK TO update_row_trx;
266: x_return_status := G_RET_STS_ERROR;
267: FND_MSG_PUB.count_and_get(
268: p_count => x_msg_count
269: ,p_data => x_msg_data);
270: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
271: ROLLBACK TO update_row_trx;

Line 273: FND_MSG_PUB.count_and_get(

269: ,p_data => x_msg_data);
270: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
271: ROLLBACK TO update_row_trx;
272: x_return_status := G_RET_STS_UNEXP_ERROR;
273: FND_MSG_PUB.count_and_get(
274: p_count => x_msg_count
275: ,p_data => x_msg_data);
276: WHEN OTHERS THEN
277: ROLLBACK TO update_row_trx;

Line 279: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','update_system_parameters');

275: ,p_data => x_msg_data);
276: WHEN OTHERS THEN
277: ROLLBACK TO update_row_trx;
278: x_return_status := G_RET_STS_UNEXP_ERROR;
279: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','update_system_parameters');
280: FND_MSG_PUB.count_and_get(
281: p_count => x_msg_count
282: ,p_data => x_msg_data);
283: END update_system_parameters;

Line 280: FND_MSG_PUB.count_and_get(

276: WHEN OTHERS THEN
277: ROLLBACK TO update_row_trx;
278: x_return_status := G_RET_STS_UNEXP_ERROR;
279: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','update_system_parameters');
280: FND_MSG_PUB.count_and_get(
281: p_count => x_msg_count
282: ,p_data => x_msg_data);
283: END update_system_parameters;
284: -- Start of comments

Line 324: FND_MSG_PUB.count_and_get(

320: EXCEPTION
321: WHEN G_EXCEPTION_ERROR THEN
322: ROLLBACK TO update_row_trx;
323: x_return_status := G_RET_STS_ERROR;
324: FND_MSG_PUB.count_and_get(
325: p_count => x_msg_count
326: ,p_data => x_msg_data);
327: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
328: ROLLBACK TO update_row_trx;

Line 330: FND_MSG_PUB.count_and_get(

326: ,p_data => x_msg_data);
327: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
328: ROLLBACK TO update_row_trx;
329: x_return_status := G_RET_STS_UNEXP_ERROR;
330: FND_MSG_PUB.count_and_get(
331: p_count => x_msg_count
332: ,p_data => x_msg_data);
333: WHEN OTHERS THEN
334: ROLLBACK TO update_row_trx;

Line 336: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','update_system_parameters');

332: ,p_data => x_msg_data);
333: WHEN OTHERS THEN
334: ROLLBACK TO update_row_trx;
335: x_return_status := G_RET_STS_UNEXP_ERROR;
336: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','update_system_parameters');
337: FND_MSG_PUB.count_and_get(
338: p_count => x_msg_count
339: ,p_data => x_msg_data);
340: END update_system_parameters;

Line 337: FND_MSG_PUB.count_and_get(

333: WHEN OTHERS THEN
334: ROLLBACK TO update_row_trx;
335: x_return_status := G_RET_STS_UNEXP_ERROR;
336: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','update_system_parameters');
337: FND_MSG_PUB.count_and_get(
338: p_count => x_msg_count
339: ,p_data => x_msg_data);
340: END update_system_parameters;
341: -- Start of comments

Line 379: FND_MSG_PUB.count_and_get(

375: EXCEPTION
376: WHEN G_EXCEPTION_ERROR THEN
377: ROLLBACK TO delete_row_trx;
378: x_return_status := G_RET_STS_ERROR;
379: FND_MSG_PUB.count_and_get(
380: p_count => x_msg_count
381: ,p_data => x_msg_data);
382: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
383: ROLLBACK TO delete_row_trx;

Line 385: FND_MSG_PUB.count_and_get(

381: ,p_data => x_msg_data);
382: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
383: ROLLBACK TO delete_row_trx;
384: x_return_status := G_RET_STS_UNEXP_ERROR;
385: FND_MSG_PUB.count_and_get(
386: p_count => x_msg_count
387: ,p_data => x_msg_data);
388: WHEN OTHERS THEN
389: ROLLBACK TO delete_row_trx;

Line 391: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','delete_system_parameters');

387: ,p_data => x_msg_data);
388: WHEN OTHERS THEN
389: ROLLBACK TO delete_row_trx;
390: x_return_status := G_RET_STS_UNEXP_ERROR;
391: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','delete_system_parameters');
392: FND_MSG_PUB.count_and_get(
393: p_count => x_msg_count
394: ,p_data => x_msg_data);
395: END delete_system_parameters;

Line 392: FND_MSG_PUB.count_and_get(

388: WHEN OTHERS THEN
389: ROLLBACK TO delete_row_trx;
390: x_return_status := G_RET_STS_UNEXP_ERROR;
391: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','delete_system_parameters');
392: FND_MSG_PUB.count_and_get(
393: p_count => x_msg_count
394: ,p_data => x_msg_data);
395: END delete_system_parameters;
396: -- Start of comments

Line 434: FND_MSG_PUB.count_and_get(

430: EXCEPTION
431: WHEN G_EXCEPTION_ERROR THEN
432: ROLLBACK TO delete_row_trx;
433: x_return_status := G_RET_STS_ERROR;
434: FND_MSG_PUB.count_and_get(
435: p_count => x_msg_count
436: ,p_data => x_msg_data);
437: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
438: ROLLBACK TO delete_row_trx;

Line 440: FND_MSG_PUB.count_and_get(

436: ,p_data => x_msg_data);
437: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
438: ROLLBACK TO delete_row_trx;
439: x_return_status := G_RET_STS_UNEXP_ERROR;
440: FND_MSG_PUB.count_and_get(
441: p_count => x_msg_count
442: ,p_data => x_msg_data);
443: WHEN OTHERS THEN
444: ROLLBACK TO delete_row_trx;

Line 446: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','delete_system_parameters');

442: ,p_data => x_msg_data);
443: WHEN OTHERS THEN
444: ROLLBACK TO delete_row_trx;
445: x_return_status := G_RET_STS_UNEXP_ERROR;
446: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','delete_system_parameters');
447: FND_MSG_PUB.count_and_get(
448: p_count => x_msg_count
449: ,p_data => x_msg_data);
450: END delete_system_parameters;

Line 447: FND_MSG_PUB.count_and_get(

443: WHEN OTHERS THEN
444: ROLLBACK TO delete_row_trx;
445: x_return_status := G_RET_STS_UNEXP_ERROR;
446: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','delete_system_parameters');
447: FND_MSG_PUB.count_and_get(
448: p_count => x_msg_count
449: ,p_data => x_msg_data);
450: END delete_system_parameters;
451: -- Start of comments

Line 489: FND_MSG_PUB.count_and_get(

485: EXCEPTION
486: WHEN G_EXCEPTION_ERROR THEN
487: ROLLBACK TO validate_row_trx;
488: x_return_status := G_RET_STS_ERROR;
489: FND_MSG_PUB.count_and_get(
490: p_count => x_msg_count
491: ,p_data => x_msg_data);
492: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
493: ROLLBACK TO validate_row_trx;

Line 495: FND_MSG_PUB.count_and_get(

491: ,p_data => x_msg_data);
492: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
493: ROLLBACK TO validate_row_trx;
494: x_return_status := G_RET_STS_UNEXP_ERROR;
495: FND_MSG_PUB.count_and_get(
496: p_count => x_msg_count
497: ,p_data => x_msg_data);
498: WHEN OTHERS THEN
499: ROLLBACK TO validate_row_trx;

Line 501: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','validate_system_parameters');

497: ,p_data => x_msg_data);
498: WHEN OTHERS THEN
499: ROLLBACK TO validate_row_trx;
500: x_return_status := G_RET_STS_UNEXP_ERROR;
501: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','validate_system_parameters');
502: FND_MSG_PUB.count_and_get(
503: p_count => x_msg_count
504: ,p_data => x_msg_data);
505: END validate_system_parameters;

Line 502: FND_MSG_PUB.count_and_get(

498: WHEN OTHERS THEN
499: ROLLBACK TO validate_row_trx;
500: x_return_status := G_RET_STS_UNEXP_ERROR;
501: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','validate_system_parameters');
502: FND_MSG_PUB.count_and_get(
503: p_count => x_msg_count
504: ,p_data => x_msg_data);
505: END validate_system_parameters;
506: -- Start of comments

Line 544: FND_MSG_PUB.count_and_get(

540: EXCEPTION
541: WHEN G_EXCEPTION_ERROR THEN
542: ROLLBACK TO validate_row_trx;
543: x_return_status := G_RET_STS_ERROR;
544: FND_MSG_PUB.count_and_get(
545: p_count => x_msg_count
546: ,p_data => x_msg_data);
547: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
548: ROLLBACK TO validate_row_trx;

Line 550: FND_MSG_PUB.count_and_get(

546: ,p_data => x_msg_data);
547: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
548: ROLLBACK TO validate_row_trx;
549: x_return_status := G_RET_STS_UNEXP_ERROR;
550: FND_MSG_PUB.count_and_get(
551: p_count => x_msg_count
552: ,p_data => x_msg_data);
553: WHEN OTHERS THEN
554: ROLLBACK TO validate_row_trx;

Line 556: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','validate_system_parameters');

552: ,p_data => x_msg_data);
553: WHEN OTHERS THEN
554: ROLLBACK TO validate_row_trx;
555: x_return_status := G_RET_STS_UNEXP_ERROR;
556: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','validate_system_parameters');
557: FND_MSG_PUB.count_and_get(
558: p_count => x_msg_count
559: ,p_data => x_msg_data);
560: END validate_system_parameters;

Line 557: FND_MSG_PUB.count_and_get(

553: WHEN OTHERS THEN
554: ROLLBACK TO validate_row_trx;
555: x_return_status := G_RET_STS_UNEXP_ERROR;
556: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','validate_system_parameters');
557: FND_MSG_PUB.count_and_get(
558: p_count => x_msg_count
559: ,p_data => x_msg_data);
560: END validate_system_parameters;
561: -- Start of comments