DBA Data[Home] [Help]

APPS.BSC_DIM_LEVEL_FILTERS_PUB dependencies on FND_MSG_PUB

Line 61: FND_MSG_PUB.Initialize;

57: l_dim_val VARCHAR2(1000);
58:
59:
60: BEGIN
61: FND_MSG_PUB.Initialize;
62: x_return_status := FND_API.G_RET_STS_SUCCESS;
63:
64:
65: IF(p_level_vals_list IS NOT NULL AND p_tab_id IS NOT NULL

Line 86: FND_MSG_PUB.ADD;

82: IF(l_found=FND_API.G_FALSE)THEN
83: l_dim_val := BSC_DEFAULT_KEY_ITEM_PUB.get_table_column_value(cd.level_view_name, 'NAME', 'CODE=' || cd.dim_level_value);
84: FND_MESSAGE.SET_NAME('BSC','BSC_LIST_SECURITY_ERROR');
85: FND_MESSAGE.SET_TOKEN('FIELD_NAME',l_dim_val, TRUE);
86: FND_MSG_PUB.ADD;
87: RAISE FND_API.G_EXC_ERROR;
88: END IF;
89: END IF;
90: END LOOP;

Line 96: FND_MSG_PUB.Count_And_Get

92:
93: EXCEPTION
94: WHEN FND_API.G_EXC_ERROR THEN
95: IF (x_msg_data IS NULL) THEN
96: FND_MSG_PUB.Count_And_Get
97: ( p_encoded => FND_API.G_FALSE
98: , p_count => x_msg_count
99: , p_data => x_msg_data
100: );

Line 108: FND_MSG_PUB.Count_And_Get

104:
105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
106:
107: IF (x_msg_data IS NULL) THEN
108: FND_MSG_PUB.Count_And_Get
109: ( p_encoded => FND_API.G_FALSE
110: , p_count => x_msg_count
111: , p_data => x_msg_data
112: );

Line 172: FND_MSG_PUB.Initialize;

168: l_key_item NUMBER;
169:
170: BEGIN
171: SAVEPOINT bscpfdlb_savepoint_save_filter;
172: FND_MSG_PUB.Initialize;
173: x_return_status := FND_API.G_RET_STS_SUCCESS;
174:
175:
176: IF (p_dim_level_id is null OR p_tab_id IS NULL) THEN

Line 280: FND_MSG_PUB.Count_And_Get

276: -- BSC_DIM_FILTERS_PUB.validate_key_item_filter
277: EXCEPTION
278: WHEN FND_API.G_EXC_ERROR THEN
279: ROLLBACK TO bscpfdlb_savepoint_save_filter;
280: FND_MSG_PUB.Count_And_Get
281: ( p_encoded => FND_API.G_FALSE
282: , p_count => x_msg_count
283: , p_data => x_msg_data
284: );

Line 290: FND_MSG_PUB.Count_And_Get

286: RAISE;
287:
288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
289: ROLLBACK TO bscpfdlb_savepoint_save_filter;
290: FND_MSG_PUB.Count_And_Get
291: ( p_encoded => FND_API.G_FALSE
292: , p_count => x_msg_count
293: , p_data => x_msg_data
294: );

Line 498: FND_MSG_PUB.Count_And_Get

494: EXCEPTION
495:
496: WHEN FND_API.G_EXC_ERROR THEN
497:
498: FND_MSG_PUB.Count_And_Get
499: ( p_encoded => FND_API.G_FALSE
500: , p_count => x_msg_count
501: , p_data => x_msg_data
502: );

Line 508: FND_MSG_PUB.Count_And_Get

504: RAISE;
505:
506: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
507:
508: FND_MSG_PUB.Count_And_Get
509: ( p_encoded => FND_API.G_FALSE
510: , p_count => x_msg_count
511: , p_data => x_msg_data
512: );

Line 679: FND_MSG_PUB.Count_And_Get

675: EXCEPTION
676: WHEN FND_API.G_EXC_ERROR THEN
677:
678:
679: FND_MSG_PUB.Count_And_Get
680: ( p_encoded => FND_API.G_FALSE
681: , p_count => x_msg_count
682: , p_data => x_msg_data
683: );

Line 688: FND_MSG_PUB.Count_And_Get

684: x_return_status := FND_API.G_RET_STS_ERROR;
685: RAISE;
686:
687: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
688: FND_MSG_PUB.Count_And_Get
689: ( p_encoded => FND_API.G_FALSE
690: , p_count => x_msg_count
691: , p_data => x_msg_data
692: );

Line 769: FND_MSG_PUB.Count_And_Get

765:
766: EXCEPTION
767: WHEN FND_API.G_EXC_ERROR THEN
768:
769: FND_MSG_PUB.Count_And_Get
770: ( p_encoded => FND_API.G_FALSE
771: , p_count => x_msg_count
772: , p_data => x_msg_data
773: );

Line 779: FND_MSG_PUB.Count_And_Get

775: RAISE;
776:
777: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
778:
779: FND_MSG_PUB.Count_And_Get
780: ( p_encoded => FND_API.G_FALSE
781: , p_count => x_msg_count
782: , p_data => x_msg_data
783: );

Line 848: FND_MSG_PUB.Initialize;

844: l_view_count NUMBER;
845:
846: BEGIN
847:
848: FND_MSG_PUB.Initialize;
849:
850:
851: IF (p_tab_id is NOT NULL AND p_dim_level_id IS NOT NULL) THEN
852:

Line 893: FND_MSG_PUB.Count_And_Get

889: EXCEPTION
890:
891: WHEN FND_API.G_EXC_ERROR THEN
892:
893: FND_MSG_PUB.Count_And_Get
894: ( p_encoded => FND_API.G_FALSE
895: , p_count => x_msg_count
896: , p_data => x_msg_data
897: );

Line 904: FND_MSG_PUB.Count_And_Get

900: RAISE;
901:
902: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
903:
904: FND_MSG_PUB.Count_And_Get
905: ( p_encoded => FND_API.G_FALSE
906: , p_count => x_msg_count
907: , p_data => x_msg_data
908: );

Line 968: FND_MSG_PUB.Initialize;

964: l_dummy_sql VARCHAR2(100);
965:
966: BEGIN
967:
968: FND_MSG_PUB.Initialize;
969: x_return_status := FND_API.G_RET_STS_SUCCESS;
970:
971:
972: -- The following is a dummy SQL that returns no rows.

Line 1013: FND_MSG_PUB.Count_And_Get

1009:
1010: EXCEPTION
1011: WHEN FND_API.G_EXC_ERROR THEN
1012:
1013: FND_MSG_PUB.Count_And_Get
1014: ( p_encoded => FND_API.G_FALSE
1015: , p_count => x_msg_count
1016: , p_data => x_msg_data
1017: );

Line 1024: FND_MSG_PUB.Count_And_Get

1020: RAISE;
1021:
1022: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1023:
1024: FND_MSG_PUB.Count_And_Get
1025: ( p_encoded => FND_API.G_FALSE
1026: , p_count => x_msg_count
1027: , p_data => x_msg_data
1028: );

Line 1213: FND_MSG_PUB.Count_And_Get

1209:
1210: EXCEPTION
1211: WHEN FND_API.G_EXC_ERROR THEN
1212:
1213: FND_MSG_PUB.Count_And_Get
1214: ( p_encoded => FND_API.G_FALSE
1215: , p_count => x_msg_count
1216: , p_data => x_msg_data
1217: );

Line 1228: FND_MSG_PUB.Count_And_Get

1224: RAISE;
1225:
1226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1227:
1228: FND_MSG_PUB.Count_And_Get
1229: ( p_encoded => FND_API.G_FALSE
1230: , p_count => x_msg_count
1231: , p_data => x_msg_data
1232: );

Line 1317: FND_MSG_PUB.Count_And_Get

1313: EXCEPTION
1314:
1315: WHEN FND_API.G_EXC_ERROR THEN
1316:
1317: FND_MSG_PUB.Count_And_Get
1318: ( p_encoded => FND_API.G_FALSE
1319: , p_count => x_msg_count
1320: , p_data => x_msg_data
1321: );

Line 1327: FND_MSG_PUB.Count_And_Get

1323: RAISE;
1324:
1325: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1326:
1327: FND_MSG_PUB.Count_And_Get
1328: ( p_encoded => FND_API.G_FALSE
1329: , p_count => x_msg_count
1330: , p_data => x_msg_data
1331: );

Line 1499: FND_MSG_PUB.Count_And_Get

1495: EXCEPTION
1496:
1497: WHEN FND_API.G_EXC_ERROR THEN
1498:
1499: FND_MSG_PUB.Count_And_Get
1500: ( p_encoded => FND_API.G_FALSE
1501: , p_count => x_msg_count
1502: , p_data => x_msg_data
1503: );

Line 1509: FND_MSG_PUB.Count_And_Get

1505: RAISE;
1506:
1507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1508:
1509: FND_MSG_PUB.Count_And_Get
1510: ( p_encoded => FND_API.G_FALSE
1511: , p_count => x_msg_count
1512: , p_data => x_msg_data
1513: );

Line 1703: FND_MSG_PUB.Count_And_Get

1699: WHEN FND_API.G_EXC_ERROR THEN
1700: IF (ref_cur%ISOPEN) THEN
1701: CLOSE ref_cur;
1702: END IF;
1703: FND_MSG_PUB.Count_And_Get
1704: ( p_encoded => FND_API.G_FALSE
1705: , p_count => x_msg_count
1706: , p_data => x_msg_data
1707: );

Line 1716: FND_MSG_PUB.Count_And_Get

1712: IF (ref_cur%ISOPEN) THEN
1713: CLOSE ref_cur;
1714: END IF;
1715:
1716: FND_MSG_PUB.Count_And_Get
1717: ( p_encoded => FND_API.G_FALSE
1718: , p_count => x_msg_count
1719: , p_data => x_msg_data
1720: );

Line 1933: FND_MSG_PUB.Count_And_Get

1929: WHEN FND_API.G_EXC_ERROR THEN
1930: IF (ref_cur%ISOPEN) THEN
1931: CLOSE ref_cur;
1932: END IF;
1933: FND_MSG_PUB.Count_And_Get
1934: ( p_encoded => FND_API.G_FALSE
1935: , p_count => x_msg_count
1936: , p_data => x_msg_data
1937: );

Line 1946: FND_MSG_PUB.Count_And_Get

1942: IF (ref_cur%ISOPEN) THEN
1943: CLOSE ref_cur;
1944: END IF;
1945:
1946: FND_MSG_PUB.Count_And_Get
1947: ( p_encoded => FND_API.G_FALSE
1948: , p_count => x_msg_count
1949: , p_data => x_msg_data
1950: );