DBA Data[Home] [Help]

APPS.BSC_CUSTOM_VIEW_UI_WRAPPER dependencies on FND_MSG_PUB

Line 69: fnd_msg_pub.initialize;

65: l_label_cur LABEL_CUR%ROWTYPE;
66:
67: BEGIN
68: SAVEPOINT RollBackPt;
69: fnd_msg_pub.initialize;
70: x_return_status := FND_API.G_RET_STS_SUCCESS;
71:
72: l_count := 0;
73:

Line 107: fnd_msg_pub.initialize;

103: ,x_msg_data OUT NOCOPY VARCHAR2
104: ) IS
105: BEGIN
106: SAVEPOINT RollBackPt;
107: fnd_msg_pub.initialize;
108: x_return_status := FND_API.G_RET_STS_SUCCESS;
109:
110: DELETE FROM BSC_TAB_VIEW_LABELS_TL
111: WHERE TAB_ID = p_tab_id

Line 163: fnd_msg_pub.initialize;

159: l_label_cur label_cur%ROWTYPE;
160:
161: BEGIN
162: SAVEPOINT RollBackPt;
163: fnd_msg_pub.initialize;
164: x_return_status := FND_API.G_RET_STS_SUCCESS;
165:
166: --convert string of IDs to table lookup
167: l_kpis := p_kpis;

Line 232: fnd_msg_pub.initialize;

228: ,x_msg_data OUT NOCOPY VARCHAR2
229: ) IS
230: BEGIN
231: SAVEPOINT RollBackPt;
232: fnd_msg_pub.initialize;
233: x_return_status := FND_API.G_RET_STS_SUCCESS;
234:
235: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(
236: p_tab_id => p_tab_id

Line 286: fnd_msg_pub.initialize;

282: ,x_msg_data OUT NOCOPY VARCHAR2
283: ) IS
284: BEGIN
285: SAVEPOINT RollBackPt;
286: fnd_msg_pub.initialize;
287: x_return_status := FND_API.G_RET_STS_SUCCESS;
288:
289: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(
290: p_tab_id => p_tab_id

Line 340: fnd_msg_pub.initialize;

336: ,x_msg_data OUT NOCOPY VARCHAR2
337: ) IS
338: BEGIN
339: SAVEPOINT RollBackPt;
340: fnd_msg_pub.initialize;
341: x_return_status := FND_API.G_RET_STS_SUCCESS;
342:
343: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(
344: p_tab_id => p_tab_id

Line 418: fnd_msg_pub.initialize;

414: ,x_msg_data OUT NOCOPY VARCHAR2
415: ) IS
416: BEGIN
417: SAVEPOINT RollBackPt;
418: fnd_msg_pub.initialize;
419: x_return_status := FND_API.G_RET_STS_SUCCESS;
420:
421: -- Add specified entry for objectives to BSC_TAB_VIEW_LABELS_PKG
422: -- position and color info is stored in BSC_TAB_VIEW_KPI_TL entries

Line 557: fnd_msg_pub.initialize;

553: ,x_msg_data OUT NOCOPY VARCHAR2
554: ) IS
555: BEGIN
556: SAVEPOINT RollBackPt;
557: fnd_msg_pub.initialize;
558: x_return_status := FND_API.G_RET_STS_SUCCESS;
559:
560: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(
561: p_tab_id => p_tab_id

Line 605: fnd_msg_pub.initialize;

601: ,x_msg_data OUT NOCOPY VARCHAR2
602: ) IS
603: BEGIN
604: SAVEPOINT RollBackPt;
605: fnd_msg_pub.initialize;
606: x_return_status := FND_API.G_RET_STS_SUCCESS;
607:
608: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(
609: p_tab_id => p_tab_id

Line 658: fnd_msg_pub.initialize;

654: ,x_msg_data OUT NOCOPY VARCHAR2
655: ) IS
656: BEGIN
657: SAVEPOINT RollBackPt;
658: fnd_msg_pub.initialize;
659: x_return_status := FND_API.G_RET_STS_SUCCESS;
660:
661: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(
662: p_tab_id => p_tab_id

Line 708: fnd_msg_pub.initialize;

704: ,x_msg_data OUT NOCOPY VARCHAR2
705: ) IS
706: BEGIN
707: SAVEPOINT RollBackPt;
708: fnd_msg_pub.initialize;
709: x_return_status := FND_API.G_RET_STS_SUCCESS;
710:
711: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(
712: p_tab_id => p_tab_id

Line 779: fnd_msg_pub.initialize;

775: ,x_msg_data OUT NOCOPY VARCHAR2
776: ) IS
777: BEGIN
778: SAVEPOINT RollBackPt;
779: fnd_msg_pub.initialize;
780: x_return_status := FND_API.G_RET_STS_SUCCESS;
781:
782: --add name/hotspot
783: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(

Line 908: fnd_msg_pub.initialize;

904: l_count NUMBER;
905: l_object_id BSC_TAB_VIEW_LABELS_B.LABEL_ID%TYPE;
906: BEGIN
907: SAVEPOINT RollBackPt;
908: fnd_msg_pub.initialize;
909: x_return_status := FND_API.G_RET_STS_SUCCESS;
910:
911: SELECT count(1) INTO l_count
912: FROM bsc_tab_view_labels_vl

Line 1015: fnd_msg_pub.initialize;

1011: l_count NUMBER;
1012: l_str VARCHAR2(100);
1013: BEGIN
1014: SAVEPOINT RollBackPt;
1015: fnd_msg_pub.initialize;
1016: x_return_status := FND_API.G_RET_STS_SUCCESS;
1017:
1018: SELECT count(1) INTO l_count
1019: FROM BSC_TAB_VIEW_KPI_VL

Line 1102: fnd_msg_pub.initialize;

1098: l_next_image_id NUMBER;
1099: l_str VARCHAR2(100);
1100: BEGIN
1101: SAVEPOINT RollBackPt;
1102: fnd_msg_pub.initialize;
1103: x_return_status := FND_API.G_RET_STS_SUCCESS;
1104:
1105: SELECT BSC_SYS_IMAGE_ID_S.NEXTVAL INTO l_next_image_id FROM dual;
1106: x_image_id := l_next_image_id;

Line 1170: fnd_msg_pub.initialize;

1166: l_str VARCHAR2(100);
1167: l_temp VARCHAR2(100);
1168: BEGIN
1169: SAVEPOINT RollBackPt;
1170: fnd_msg_pub.initialize;
1171: x_return_status := FND_API.G_RET_STS_SUCCESS;
1172:
1173: SELECT count(1) INTO l_count
1174: FROM BSC_SYS_IMAGES bsi, BSC_SYS_IMAGES_MAP_VL bsim

Line 1312: fnd_msg_pub.initialize;

1308: l_function_id NUMBER;
1309: l_enabled_flag BSC_TAB_VIEWS_B.enabled_flag%TYPE;
1310: BEGIN
1311: SAVEPOINT RollBackPt;
1312: fnd_msg_pub.initialize;
1313: x_return_status := FND_API.G_RET_STS_SUCCESS;
1314: l_flag := 0;
1315:
1316: IF (is_tab_view_exist(p_tab_id, p_tab_view_id) = 'Y')

Line 1683: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

1679:
1680: EXCEPTION
1681: WHEN FND_API.G_EXC_ERROR THEN
1682: x_return_status := FND_API.G_RET_STS_ERROR;
1683: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1684: ,p_data => x_msg_data);
1685: WHEN OTHERS THEN
1686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1687: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

Line 1687: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

1683: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1684: ,p_data => x_msg_data);
1685: WHEN OTHERS THEN
1686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1687: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1688: ,p_data => x_msg_data);
1689: if (x_msg_data is null) then
1690: x_msg_data := 'BSC_CUSTOM_VIEW_UI_WRAPPER.create_function' || SQLERRM;
1691: end if;

Line 1714: fnd_msg_pub.initialize;

1710: FROM FND_FORM_FUNCTIONS
1711: WHERE PARAMETERS LIKE l_param_search_string;
1712:
1713: BEGIN
1714: fnd_msg_pub.initialize;
1715: x_return_status := FND_API.G_RET_STS_SUCCESS;
1716: -- Constracts the PARAMETER to find out FUNCTION_NAME
1717: l_param_search_string := get_param_search_string(p_tab_id,p_tab_view_id);
1718:

Line 1750: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

1746:
1747: EXCEPTION
1748: WHEN NO_DATA_FOUND THEN
1749: x_return_status := FND_API.G_RET_STS_ERROR;
1750: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1751: ,p_data => x_msg_data);
1752: if (x_msg_data is null) then
1753: x_msg_data := 'BSC_CUSTOM_VIEW_UI_WRAPPER.delete_function: no Row Found: ' || SQLERRM;
1754: end if;

Line 1758: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

1754: end if;
1755:
1756: WHEN FND_API.G_EXC_ERROR THEN
1757: x_return_status := FND_API.G_RET_STS_ERROR;
1758: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1759: ,p_data => x_msg_data);
1760: WHEN OTHERS THEN
1761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1762: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

Line 1762: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

1758: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1759: ,p_data => x_msg_data);
1760: WHEN OTHERS THEN
1761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1762: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1763: ,p_data => x_msg_data);
1764: if (x_msg_data is null) then
1765: x_msg_data := 'BSC_CUSTOM_VIEW_UI_WRAPPER.delete_function' || SQLERRM;
1766: end if;

Line 1817: FND_MSG_PUB.INITIALIZE;

1813: l_last_update_date DATE;
1814: -- Date Format used in Report Designer.
1815: l_last_upd_format VARCHAR2(25):= 'YYYY/MM/DD-HH24:MI:SS';
1816: BEGIN
1817: FND_MSG_PUB.INITIALIZE;
1818: x_return_status := FND_API.G_RET_STS_SUCCESS;
1819:
1820: IF (p_time_stamp IS NOT NULL) THEN
1821: SELECT LAST_UPDATE_DATE

Line 1828: FND_MSG_PUB.Initialize;

1824: WHERE REGION_CODE = p_report_sht_name
1825: AND REGION_APPLICATION_ID = p_Application_Id;
1826:
1827: IF(p_time_stamp <> TO_CHAR(l_last_update_date, l_last_upd_format)) THEN
1828: FND_MSG_PUB.Initialize;
1829: FND_MESSAGE.SET_NAME('BSC', 'BSC_INVALID_RPT_TIMESTAMP');
1830: FND_MSG_PUB.ADD;
1831: x_return_status := FND_API.G_RET_STS_ERROR;
1832: x_msg_data := 'BSC_INVALID_RPT_TIMESTAMP';

Line 1830: FND_MSG_PUB.ADD;

1826:
1827: IF(p_time_stamp <> TO_CHAR(l_last_update_date, l_last_upd_format)) THEN
1828: FND_MSG_PUB.Initialize;
1829: FND_MESSAGE.SET_NAME('BSC', 'BSC_INVALID_RPT_TIMESTAMP');
1830: FND_MSG_PUB.ADD;
1831: x_return_status := FND_API.G_RET_STS_ERROR;
1832: x_msg_data := 'BSC_INVALID_RPT_TIMESTAMP';
1833: RAISE FND_API.G_EXC_ERROR;
1834: END IF;

Line 1889: FND_MSG_PUB.Count_And_Get

1885: x_time_stamp := TO_CHAR(l_Time_Stamp, l_last_upd_format);
1886:
1887: EXCEPTION
1888: WHEN FND_API.G_EXC_ERROR THEN
1889: FND_MSG_PUB.Count_And_Get
1890: ( p_encoded => FND_API.G_FALSE
1891: , p_count => x_msg_count
1892: , p_data => x_msg_data
1893: );

Line 1897: FND_MSG_PUB.Count_And_Get

1893: );
1894: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1895: x_return_status := FND_API.G_RET_STS_ERROR;
1896: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1897: FND_MSG_PUB.Count_And_Get
1898: ( p_encoded => FND_API.G_FALSE
1899: , p_count => x_msg_count
1900: , p_data => x_msg_data
1901: );

Line 2127: fnd_msg_pub.initialize;

2123: ,x_msg_data OUT NOCOPY VARCHAR2
2124: ) IS
2125: BEGIN
2126: SAVEPOINT addorupdatekpitrend;
2127: fnd_msg_pub.initialize;
2128: x_return_status := FND_API.G_RET_STS_SUCCESS;
2129:
2130: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(
2131: p_tab_id => p_tab_id