APPS.BIS_PMV_REGION_ITEMS_PVT dependencies on FND_MSG_PUB

Line 34: FND_MSG_PUB.Initialize;

30: ) IS
31: l_Region_Item_Rec BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type;
32: l_commit VARCHAR2(1) := 'N';
33: BEGIN
34: FND_MSG_PUB.Initialize;
35: x_return_status := FND_API.G_RET_STS_SUCCESS;
36: IF (p_Region_Item_Tbl IS NOT NULL AND p_Region_Item_Tbl.COUNT > 0) THEN
37: FOR i IN p_Region_Item_Tbl.FIRST..p_Region_Item_Tbl.LAST LOOP
38: l_Region_Item_Rec := p_Region_Item_Tbl(i);

Line 95: FND_MSG_PUB.Count_And_Get

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

Line 105: FND_MSG_PUB.Count_And_Get

101: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
102: x_return_status := FND_API.G_RET_STS_ERROR;
103: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
104: IF (x_msg_data IS NULL) THEN
105: FND_MSG_PUB.Count_And_Get
106: ( p_encoded => FND_API.G_FALSE
107: , p_count => x_msg_count
108: , p_data => x_msg_data
109: );

Line 135: FND_MSG_PUB.Initialize;

131: ) IS
132: l_Region_Item_Rec BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type;
133: l_commit VARCHAR2(1) := 'N';
134: BEGIN
135: FND_MSG_PUB.Initialize;
136: x_return_status := FND_API.G_RET_STS_SUCCESS;
137: IF (p_Region_Item_Tbl IS NOT NULL AND p_Region_Item_Tbl.COUNT > 0) THEN
138: FOR i IN p_Region_Item_Tbl.FIRST..p_Region_Item_Tbl.LAST LOOP
139: l_Region_Item_Rec := p_Region_Item_Tbl(i);

Line 196: FND_MSG_PUB.Count_And_Get

192: x_return_status := FND_API.G_RET_STS_SUCCESS;
193: EXCEPTION
194: WHEN FND_API.G_EXC_ERROR THEN
195: IF (x_msg_data IS NULL) THEN
196: FND_MSG_PUB.Count_And_Get
197: ( p_encoded => FND_API.G_FALSE
198: , p_count => x_msg_count
199: , p_data => x_msg_data
200: );

Line 206: FND_MSG_PUB.Count_And_Get

202: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
203: x_return_status := FND_API.G_RET_STS_ERROR;
204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
205: IF (x_msg_data IS NULL) THEN
206: FND_MSG_PUB.Count_And_Get
207: ( p_encoded => FND_API.G_FALSE
208: , p_count => x_msg_count
209: , p_data => x_msg_data
210: );

Line 235: FND_MSG_PUB.Initialize;

231: , x_msg_count OUT NOCOPY NUMBER
232: , x_msg_data OUT NOCOPY VARCHAR2
233: ) IS
234: BEGIN
235: FND_MSG_PUB.Initialize;
236: x_return_status := FND_API.G_RET_STS_SUCCESS;
237: IF (p_Attribute_Code_Tbl IS NOT NULL AND p_Attribute_Code_Tbl.COUNT > 0) THEN
238: FOR i IN p_Attribute_Code_Tbl.FIRST..p_Attribute_Code_Tbl.LAST LOOP
239: BIS_AK_REGION_PUB.DELETE_REGION_ITEM_ROW

Line 267: FND_MSG_PUB.Count_And_Get

263: x_return_status := FND_API.G_RET_STS_SUCCESS;
264: EXCEPTION
265: WHEN FND_API.G_EXC_ERROR THEN
266: IF (x_msg_data IS NULL) THEN
267: FND_MSG_PUB.Count_And_Get
268: ( p_encoded => FND_API.G_FALSE
269: , p_count => x_msg_count
270: , p_data => x_msg_data
271: );

Line 277: FND_MSG_PUB.Count_And_Get

273: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
274: x_return_status := FND_API.G_RET_STS_ERROR;
275: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
276: IF (x_msg_data IS NULL) THEN
277: FND_MSG_PUB.Count_And_Get
278: ( p_encoded => FND_API.G_FALSE
279: , p_count => x_msg_count
280: , p_data => x_msg_data
281: );