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