DBA Data[Home] [Help]

APPS.IEU_WORKPANEL_PVT dependencies on FND_MSG_PUB

Line 69: fnd_msg_pub.delete_msg();

65:
66:
67: BEGIN
68:
69: fnd_msg_pub.delete_msg();
70: x_return_status := fnd_api.g_ret_sts_success;
71: FND_MSG_PUB.initialize;
72:
73: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

Line 71: FND_MSG_PUB.initialize;

67: BEGIN
68:
69: fnd_msg_pub.delete_msg();
70: x_return_status := fnd_api.g_ret_sts_success;
71: FND_MSG_PUB.initialize;
72:
73: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
74: l_act_usr_lbl_count := 0;
75: l_act_def_key_count := 0;

Line 192: FND_MSG_PUB.Add;

188:
189: if (l_temp_act_label <> rec_obj.action_user_label) then
190: if (l_set_id_count <> 0) then
191: FND_MESSAGE.set_name('IEU', 'IEU_PROV_WP_LABLE_UNIQUE');
192: FND_MSG_PUB.Add;
193: x_return_status := FND_API.G_RET_STS_ERROR;
194: end if;
195: end if;
196: else

Line 199: FND_MSG_PUB.Add;

195: end if;
196: else
197: if (l_act_usr_lbl_count <> 0 or l_set_id_count <> 0) then
198: FND_MESSAGE.set_name('IEU', 'IEU_PROV_WP_LABLE_UNIQUE');
199: FND_MSG_PUB.Add;
200: x_return_status := FND_API.G_RET_STS_ERROR;
201: end if;
202: end if;
203:

Line 219: FND_MSG_PUB.Add;

215: mtl.language = l_language;
216:
217: if (l_set_id_count >= 1) then
218: FND_MESSAGE.set_name('IEU', 'IEU_PROV_WP_LABLE_UNIQUE');
219: FND_MSG_PUB.Add;
220: x_return_status := FND_API.G_RET_STS_ERROR;
221: end if;
222: end if;
223:

Line 235: FND_MSG_PUB.Add;

231:
232:
233: if (l_act_def_key_count <> 0) then
234: FND_MESSAGE.set_name('IEU', 'IEU_PROV_WP_NAME_UNIQUE');
235: FND_MSG_PUB.Add;
236: x_return_status := FND_API.G_RET_STS_ERROR;
237: end if;
238:
239: end if;

Line 255: -- FND_MSG_PUB.Add;

251:
252:
253: -- if (l_temp_count <= 0) then
254: -- FND_MESSAGE.set_name('IEU', 'IEU_PROV_PKG_INVALID');
255: -- FND_MSG_PUB.Add;
256: -- x_return_status := FND_API.G_RET_STS_ERROR;
257: -- end if;
258:
259:

Line 261: x_msg_count := fnd_msg_pub.COUNT_MSG();

257: -- end if;
258:
259:
260:
261: x_msg_count := fnd_msg_pub.COUNT_MSG();
262:
263: FOR i in 1..x_msg_count LOOP
264: l_msg_data := '';
265: l_msg_count := 0;

Line 266: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);

262:
263: FOR i in 1..x_msg_count LOOP
264: l_msg_data := '';
265: l_msg_count := 0;
266: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
267: x_msg_data := x_msg_data || ',' || l_msg_data;
268:
269: END LOOP;
270:

Line 276: x_msg_count := fnd_msg_pub.COUNT_MSG();

272:
273: WHEN FND_API.G_EXC_ERROR THEN
274:
275: x_return_status := FND_API.G_RET_STS_ERROR;
276: x_msg_count := fnd_msg_pub.COUNT_MSG();
277: -- DBMS_OUTPUT.PUT_LINE(' Error : '||sqlerrm);
278:
279: FOR i in 1..x_msg_count LOOP
280: l_msg_data := '';

Line 282: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);

278:
279: FOR i in 1..x_msg_count LOOP
280: l_msg_data := '';
281: l_msg_count := 0;
282: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
283: x_msg_data := x_msg_data || ',' || l_msg_data;
284: END LOOP;
285:
286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 289: x_msg_count := fnd_msg_pub.COUNT_MSG();

285:
286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
287: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
289: x_msg_count := fnd_msg_pub.COUNT_MSG();
290:
291: FOR i in 1..x_msg_count LOOP
292: l_msg_data := '';
293: l_msg_count := 0;

Line 294: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);

290:
291: FOR i in 1..x_msg_count LOOP
292: l_msg_data := '';
293: l_msg_count := 0;
294: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
295: x_msg_data := x_msg_data || ',' || l_msg_data;
296: END LOOP;
297: WHEN OTHERS THEN
298: --Rollback to IEU_UWQ_MEDIA_TYPES_PVT;

Line 303: x_msg_count := fnd_msg_pub.COUNT_MSG();

299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
300: --DBMS_OUTPUT.PUT_LINE('other Error : '||sqlerrm);
301:
302:
303: x_msg_count := fnd_msg_pub.COUNT_MSG();
304:
305: FOR i in 1..x_msg_count LOOP
306: l_msg_data := '';
307: l_msg_count := 0;

Line 308: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);

304:
305: FOR i in 1..x_msg_count LOOP
306: l_msg_data := '';
307: l_msg_count := 0;
308: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
309: x_msg_data := x_msg_data || ',' || l_msg_data;
310: END LOOP;
311: -- DBMS_OUTPUT.PUT_LINE('x_return_status : '||x_return_status);
312:

Line 355: fnd_msg_pub.delete_msg();

351:
352: BEGIN
353:
354:
355: fnd_msg_pub.delete_msg();
356: x_return_status := fnd_api.g_ret_sts_success;
357: FND_MSG_PUB.initialize;
358:
359: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

Line 357: FND_MSG_PUB.initialize;

353:
354:
355: fnd_msg_pub.delete_msg();
356: x_return_status := fnd_api.g_ret_sts_success;
357: FND_MSG_PUB.initialize;
358:
359: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
360: l_set_id_count :=0;
361:

Line 461: FND_MSG_PUB.Add;

457: --DBMS_OUTPUT.PUT_LINE(' set lable count : '|| l_set_id_count);
458:
459: if (l_act_usr_lbl_count <> 0 or l_set_id_count <> 0) then
460: FND_MESSAGE.set_name('IEU', 'IEU_PROV_WP_LABLE_UNIQUE');
461: FND_MSG_PUB.Add;
462: x_return_status := FND_API.G_RET_STS_ERROR;
463: end if;
464:
465: -- x_return_status := fnd_api.g_ret_sts_success;

Line 467: x_msg_count := fnd_msg_pub.COUNT_MSG();

463: end if;
464:
465: -- x_return_status := fnd_api.g_ret_sts_success;
466:
467: x_msg_count := fnd_msg_pub.COUNT_MSG();
468:
469: FOR i in 1..x_msg_count LOOP
470: l_msg_data := '';
471: l_msg_count := 0;

Line 472: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);

468:
469: FOR i in 1..x_msg_count LOOP
470: l_msg_data := '';
471: l_msg_count := 0;
472: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
473: x_msg_data := x_msg_data || ',' || l_msg_data;
474: END LOOP;
475:
476: EXCEPTION

Line 481: x_msg_count := fnd_msg_pub.COUNT_MSG();

477:
478: WHEN FND_API.G_EXC_ERROR THEN
479:
480: x_return_status := FND_API.G_RET_STS_ERROR;
481: x_msg_count := fnd_msg_pub.COUNT_MSG();
482: -- DBMS_OUTPUT.PUT_LINE(' Error : '||sqlerrm);
483:
484: FOR i in 1..x_msg_count LOOP
485: l_msg_data := '';

Line 487: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);

483:
484: FOR i in 1..x_msg_count LOOP
485: l_msg_data := '';
486: l_msg_count := 0;
487: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
488: x_msg_data := x_msg_data || ',' || l_msg_data;
489: END LOOP;
490:
491: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 496: x_msg_count := fnd_msg_pub.COUNT_MSG();

492: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
493:
494:
495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
496: x_msg_count := fnd_msg_pub.COUNT_MSG();
497:
498: FOR i in 1..x_msg_count LOOP
499: l_msg_data := '';
500: l_msg_count := 0;

Line 501: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);

497:
498: FOR i in 1..x_msg_count LOOP
499: l_msg_data := '';
500: l_msg_count := 0;
501: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
502: x_msg_data := x_msg_data || ',' || l_msg_data;
503: END LOOP;
504: WHEN OTHERS THEN
505: --Rollback to IEU_UWQ_MEDIA_TYPES_PVT;

Line 510: x_msg_count := fnd_msg_pub.COUNT_MSG();

506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
507: -- DBMS_OUTPUT.PUT_LINE('other Error : '||sqlerrm);
508:
509:
510: x_msg_count := fnd_msg_pub.COUNT_MSG();
511:
512: FOR i in 1..x_msg_count LOOP
513: l_msg_data := '';
514: l_msg_count := 0;

Line 515: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);

511:
512: FOR i in 1..x_msg_count LOOP
513: l_msg_data := '';
514: l_msg_count := 0;
515: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
516: x_msg_data := x_msg_data || ',' || l_msg_data;
517: END LOOP;
518: -- DBMS_OUTPUT.PUT_LINE('x_return_status : '||x_return_status);
519:

Line 555: fnd_msg_pub.delete_msg();

551:
552: BEGIN
553:
554:
555: fnd_msg_pub.delete_msg();
556: x_return_status := fnd_api.g_ret_sts_success;
557: FND_MSG_PUB.initialize;
558: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
559: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

Line 557: FND_MSG_PUB.initialize;

553:
554:
555: fnd_msg_pub.delete_msg();
556: x_return_status := fnd_api.g_ret_sts_success;
557: FND_MSG_PUB.initialize;
558: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
559: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
560: x_msg_data := '';
561:

Line 659: fnd_msg_pub.delete_msg();

655:
656:
657:
658: BEGIN
659: fnd_msg_pub.delete_msg();
660: x_return_status := fnd_api.g_ret_sts_success;
661: FND_MSG_PUB.initialize;
662: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
663: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

Line 661: FND_MSG_PUB.initialize;

657:
658: BEGIN
659: fnd_msg_pub.delete_msg();
660: x_return_status := fnd_api.g_ret_sts_success;
661: FND_MSG_PUB.initialize;
662: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
663: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
664: x_msg_data := '';
665: l_count := 0;

Line 1019: fnd_msg_pub.delete_msg();

1015:
1016: BEGIN
1017:
1018:
1019: fnd_msg_pub.delete_msg();
1020: x_return_status := fnd_api.g_ret_sts_success;
1021: FND_MSG_PUB.initialize;
1022: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1023: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

Line 1021: FND_MSG_PUB.initialize;

1017:
1018:
1019: fnd_msg_pub.delete_msg();
1020: x_return_status := fnd_api.g_ret_sts_success;
1021: FND_MSG_PUB.initialize;
1022: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1023: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1024: x_msg_data := '';
1025:

Line 1428: fnd_msg_pub.delete_msg();

1424:
1425:
1426: BEGIN
1427:
1428: fnd_msg_pub.delete_msg();
1429: x_return_status := fnd_api.g_ret_sts_success;
1430: FND_MSG_PUB.initialize;
1431:
1432: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

Line 1430: FND_MSG_PUB.initialize;

1426: BEGIN
1427:
1428: fnd_msg_pub.delete_msg();
1429: x_return_status := fnd_api.g_ret_sts_success;
1430: FND_MSG_PUB.initialize;
1431:
1432: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1433: l_param_usr_lbl_count := 0;
1434: l_param_name_count := 0;

Line 1463: FND_MSG_PUB.Add;

1459: if (is_create = 'Y') then
1460:
1461: if (l_param_name_count <> 0) then
1462: FND_MESSAGE.set_name('IEU', 'Parameter name must be unique');
1463: FND_MSG_PUB.Add;
1464: x_return_status := FND_API.G_RET_STS_ERROR;
1465: end if;
1466:
1467: if (l_param_usr_lbl_count <> 0) then

Line 1469: FND_MSG_PUB.Add;

1465: end if;
1466:
1467: if (l_param_usr_lbl_count <> 0) then
1468: FND_MESSAGE.set_name('IEU', 'Parameter label must be unique');
1469: FND_MSG_PUB.Add;
1470: x_return_status := FND_API.G_RET_STS_ERROR;
1471: end if;
1472:
1473: end if;

Line 1476: x_msg_count := fnd_msg_pub.COUNT_MSG();

1472:
1473: end if;
1474:
1475:
1476: x_msg_count := fnd_msg_pub.COUNT_MSG();
1477:
1478: FOR i in 1..x_msg_count LOOP
1479: l_msg_data := '';
1480: l_msg_count := 0;

Line 1481: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);

1477:
1478: FOR i in 1..x_msg_count LOOP
1479: l_msg_data := '';
1480: l_msg_count := 0;
1481: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1482: x_msg_data := x_msg_data || ',' || l_msg_data;
1483: END LOOP;
1484:
1485: EXCEPTION

Line 1490: x_msg_count := fnd_msg_pub.COUNT_MSG();

1486:
1487: WHEN FND_API.G_EXC_ERROR THEN
1488:
1489: x_return_status := FND_API.G_RET_STS_ERROR;
1490: x_msg_count := fnd_msg_pub.COUNT_MSG();
1491: -- DBMS_OUTPUT.PUT_LINE(' Error : '||sqlerrm);
1492:
1493: FOR i in 1..x_msg_count LOOP
1494: l_msg_data := '';

Line 1496: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);

1492:
1493: FOR i in 1..x_msg_count LOOP
1494: l_msg_data := '';
1495: l_msg_count := 0;
1496: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1497: x_msg_data := x_msg_data || ',' || l_msg_data;
1498: END LOOP;
1499:
1500: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1503: x_msg_count := fnd_msg_pub.COUNT_MSG();

1499:
1500: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1501: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
1502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1503: x_msg_count := fnd_msg_pub.COUNT_MSG();
1504:
1505: FOR i in 1..x_msg_count LOOP
1506: l_msg_data := '';
1507: l_msg_count := 0;

Line 1508: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);

1504:
1505: FOR i in 1..x_msg_count LOOP
1506: l_msg_data := '';
1507: l_msg_count := 0;
1508: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1509: x_msg_data := x_msg_data || ',' || l_msg_data;
1510: END LOOP;
1511: WHEN OTHERS THEN
1512: --Rollback to IEU_UWQ_MEDIA_TYPES_PVT;

Line 1517: x_msg_count := fnd_msg_pub.COUNT_MSG();

1513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1514: -- DBMS_OUTPUT.PUT_LINE('other Error : '||sqlerrm);
1515:
1516:
1517: x_msg_count := fnd_msg_pub.COUNT_MSG();
1518:
1519: FOR i in 1..x_msg_count LOOP
1520: l_msg_data := '';
1521: l_msg_count := 0;

Line 1522: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);

1518:
1519: FOR i in 1..x_msg_count LOOP
1520: l_msg_data := '';
1521: l_msg_count := 0;
1522: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1523: x_msg_data := x_msg_data || ',' || l_msg_data;
1524: END LOOP;
1525: -- DBMS_OUTPUT.PUT_LINE('x_return_status : '||x_return_status);
1526:

Line 1578: fnd_msg_pub.delete_msg();

1574:
1575: BEGIN
1576:
1577:
1578: fnd_msg_pub.delete_msg();
1579: x_return_status := fnd_api.g_ret_sts_success;
1580: FND_MSG_PUB.initialize;
1581: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1582: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

Line 1580: FND_MSG_PUB.initialize;

1576:
1577:
1578: fnd_msg_pub.delete_msg();
1579: x_return_status := fnd_api.g_ret_sts_success;
1580: FND_MSG_PUB.initialize;
1581: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1582: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1583: x_msg_data := '';
1584:

Line 1752: fnd_msg_pub.delete_msg();

1748:
1749: BEGIN
1750:
1751:
1752: fnd_msg_pub.delete_msg();
1753: x_return_status := fnd_api.g_ret_sts_success;
1754: FND_MSG_PUB.initialize;
1755: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1756: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

Line 1754: FND_MSG_PUB.initialize;

1750:
1751:
1752: fnd_msg_pub.delete_msg();
1753: x_return_status := fnd_api.g_ret_sts_success;
1754: FND_MSG_PUB.initialize;
1755: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1756: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1757: x_msg_data := '';
1758:

Line 1843: fnd_msg_pub.delete_msg();

1839: BEGIN
1840:
1841:
1842:
1843: fnd_msg_pub.delete_msg();
1844: x_return_status := fnd_api.g_ret_sts_success;
1845: FND_MSG_PUB.initialize;
1846: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1847: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

Line 1845: FND_MSG_PUB.initialize;

1841:
1842:
1843: fnd_msg_pub.delete_msg();
1844: x_return_status := fnd_api.g_ret_sts_success;
1845: FND_MSG_PUB.initialize;
1846: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1847: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1848: x_msg_data := '';
1849:

Line 1988: fnd_msg_pub.delete_msg();

1984:
1985:
1986: BEGIN
1987:
1988: fnd_msg_pub.delete_msg();
1989: x_return_status := fnd_api.g_ret_sts_success;
1990: FND_MSG_PUB.initialize;
1991: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1992: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

Line 1990: FND_MSG_PUB.initialize;

1986: BEGIN
1987:
1988: fnd_msg_pub.delete_msg();
1989: x_return_status := fnd_api.g_ret_sts_success;
1990: FND_MSG_PUB.initialize;
1991: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1992: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1993: x_msg_data := '';
1994:

Line 2216: fnd_msg_pub.delete_msg();

2212:
2213:
2214: BEGIN
2215:
2216: fnd_msg_pub.delete_msg();
2217: x_return_status := fnd_api.g_ret_sts_success;
2218: FND_MSG_PUB.initialize;
2219: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
2220: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

Line 2218: FND_MSG_PUB.initialize;

2214: BEGIN
2215:
2216: fnd_msg_pub.delete_msg();
2217: x_return_status := fnd_api.g_ret_sts_success;
2218: FND_MSG_PUB.initialize;
2219: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
2220: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
2221: x_msg_data := '';
2222:

Line 2579: fnd_msg_pub.delete_msg();

2575:
2576:
2577: BEGIN
2578:
2579: fnd_msg_pub.delete_msg();
2580: x_return_status := fnd_api.g_ret_sts_success;
2581: FND_MSG_PUB.initialize;
2582: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
2583: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

Line 2581: FND_MSG_PUB.initialize;

2577: BEGIN
2578:
2579: fnd_msg_pub.delete_msg();
2580: x_return_status := fnd_api.g_ret_sts_success;
2581: FND_MSG_PUB.initialize;
2582: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
2583: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
2584: x_msg_data := '';
2585:

Line 2644: fnd_msg_pub.delete_msg();

2640:
2641:
2642: BEGIN
2643:
2644: fnd_msg_pub.delete_msg();
2645: x_return_status := fnd_api.g_ret_sts_success;
2646: FND_MSG_PUB.initialize;
2647: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
2648: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

Line 2646: FND_MSG_PUB.initialize;

2642: BEGIN
2643:
2644: fnd_msg_pub.delete_msg();
2645: x_return_status := fnd_api.g_ret_sts_success;
2646: FND_MSG_PUB.initialize;
2647: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
2648: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
2649: x_msg_data := '';
2650:

Line 2735: fnd_msg_pub.delete_msg();

2731:
2732:
2733: BEGIN
2734:
2735: fnd_msg_pub.delete_msg();
2736: x_return_status := fnd_api.g_ret_sts_success;
2737: FND_MSG_PUB.initialize;
2738: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
2739: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

Line 2737: FND_MSG_PUB.initialize;

2733: BEGIN
2734:
2735: fnd_msg_pub.delete_msg();
2736: x_return_status := fnd_api.g_ret_sts_success;
2737: FND_MSG_PUB.initialize;
2738: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
2739: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
2740: x_msg_data := '';
2741:

Line 2937: fnd_msg_pub.delete_msg();

2933:
2934: BEGIN
2935:
2936:
2937: fnd_msg_pub.delete_msg();
2938: x_return_status := fnd_api.g_ret_sts_success;
2939: FND_MSG_PUB.initialize;
2940: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
2941: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

Line 2939: FND_MSG_PUB.initialize;

2935:
2936:
2937: fnd_msg_pub.delete_msg();
2938: x_return_status := fnd_api.g_ret_sts_success;
2939: FND_MSG_PUB.initialize;
2940: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
2941: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
2942: x_msg_data := '';
2943:

Line 3000: fnd_msg_pub.delete_msg();

2996: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;
2997:
2998:
2999: BEGIN
3000: fnd_msg_pub.delete_msg();
3001: x_return_status := fnd_api.g_ret_sts_success;
3002: FND_MSG_PUB.initialize;
3003: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
3004: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

Line 3002: FND_MSG_PUB.initialize;

2998:
2999: BEGIN
3000: fnd_msg_pub.delete_msg();
3001: x_return_status := fnd_api.g_ret_sts_success;
3002: FND_MSG_PUB.initialize;
3003: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
3004: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
3005: x_msg_data := '';
3006:

Line 3062: fnd_msg_pub.delete_msg();

3058:
3059:
3060:
3061: BEGIN
3062: fnd_msg_pub.delete_msg();
3063: x_return_status := fnd_api.g_ret_sts_success;
3064: FND_MSG_PUB.initialize;
3065:
3066: x_msg_data := '';

Line 3064: FND_MSG_PUB.initialize;

3060:
3061: BEGIN
3062: fnd_msg_pub.delete_msg();
3063: x_return_status := fnd_api.g_ret_sts_success;
3064: FND_MSG_PUB.initialize;
3065:
3066: x_msg_data := '';
3067: for c_rec in c_cur LOOP
3068: if l_count <> c_rec.PROPERTY_VALUE then