APPS.BSC_DEFAULT_KEY_ITEM_PUB dependencies on FND_MSG_PUB

Line 53: FND_MSG_PUB.Initialize;

49: FROM bsc_kpis_vl
50: WHERE source_indicator =p_kpi_id
51: AND prototype_flag<>2);
52: BEGIN
53: FND_MSG_PUB.Initialize;
54: x_return_status := FND_API.G_RET_STS_SUCCESS;
55: IF(p_kpi_id IS NOT NULL AND p_params IS NOT NULL) THEN
56:
57: BSC_UTILITY.Parse_String

Line 110: FND_MSG_PUB.ADD;

106: );
107: FND_MESSAGE.SET_NAME('BSC','BSC_SHARED_OBJ_KEY_ERROR');
108: FND_MESSAGE.SET_TOKEN('KEY_NAME',l_key_name, TRUE);
109: FND_MESSAGE.SET_TOKEN('LIST',l_score_list, TRUE);
110: FND_MSG_PUB.ADD;
111: RAISE FND_API.G_EXC_ERROR;
112: END IF;
113: END IF;
114: END LOOP;

Line 119: FND_MSG_PUB.Count_And_Get

115: END IF;
116: EXCEPTION
117: WHEN FND_API.G_EXC_ERROR THEN
118: IF (x_msg_data IS NULL) THEN
119: FND_MSG_PUB.Count_And_Get
120: ( p_encoded => FND_API.G_FALSE
121: , p_count => x_msg_count
122: , p_data => x_msg_data
123: );

Line 129: FND_MSG_PUB.Count_And_Get

125: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
126: x_return_status := FND_API.G_RET_STS_ERROR;
127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
128: IF (x_msg_data IS NULL) THEN
129: FND_MSG_PUB.Count_And_Get
130: ( p_encoded => FND_API.G_FALSE
131: , p_count => x_msg_count
132: , p_data => x_msg_data
133: );

Line 173: FND_MSG_PUB.Initialize;

169:
170: l_count NUMBER;
171:
172: BEGIN
173: FND_MSG_PUB.Initialize;
174: x_return_status := FND_API.G_RET_STS_SUCCESS;
175:
176: IF (p_kpi_id IS NOT NULL AND p_params IS NOT NULL) THEN
177:

Line 227: FND_MSG_PUB.Count_And_Get

223: EXCEPTION
224: WHEN FND_API.G_EXC_ERROR THEN
225: ROLLBACK TO bsc_key_item_pub_upd_key_item;
226: IF (x_msg_data IS NULL) THEN
227: FND_MSG_PUB.Count_And_Get
228: ( p_encoded => FND_API.G_FALSE
229: , p_count => x_msg_count
230: , p_data => x_msg_data
231: );

Line 237: FND_MSG_PUB.Count_And_Get

233: x_return_status := FND_API.G_RET_STS_ERROR;
234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
235: ROLLBACK TO bsc_key_item_pub_upd_key_item;
236: IF (x_msg_data IS NULL) THEN
237: FND_MSG_PUB.Count_And_Get
238: ( p_encoded => FND_API.G_FALSE
239: , p_count => x_msg_count
240: , p_data => x_msg_data
241: );

Line 313: FND_MSG_PUB.INITIALIZE;

309:
310: l_params VARCHAR2(32000);
311:
312: BEGIN
313: FND_MSG_PUB.INITIALIZE;
314: x_return_status := FND_API.G_RET_STS_SUCCESS;
315:
316: IF(p_indicator IS NOT NULL) THEN
317: l_indicator:=p_indicator;

Line 348: FND_MSG_PUB.Count_And_Get

344:
345: EXCEPTION
346: WHEN FND_API.G_EXC_ERROR THEN
347: IF (x_msg_data IS NULL) THEN
348: FND_MSG_PUB.Count_And_Get
349: ( p_encoded => FND_API.G_FALSE
350: , p_count => x_msg_count
351: , p_data => x_msg_data
352: );

Line 358: FND_MSG_PUB.Count_And_Get

354: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
355: x_return_status := FND_API.G_RET_STS_ERROR;
356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
357: IF (x_msg_data IS NULL) THEN
358: FND_MSG_PUB.Count_And_Get
359: ( p_encoded => FND_API.G_FALSE
360: , p_count => x_msg_count
361: , p_data => x_msg_data
362: );

Line 420: FND_MSG_PUB.Initialize;

416: ref_cur ref_cursor;
417:
418:
419: BEGIN
420: FND_MSG_PUB.Initialize;
421: x_return_status := FND_API.G_RET_STS_SUCCESS;
422:
423: IF (p_kpi_id IS NOT NULL AND p_params IS NOT NULL) THEN
424:

Line 627: FND_MSG_PUB.Count_And_Get

623:
624: EXCEPTION
625: WHEN FND_API.G_EXC_ERROR THEN
626: IF (x_msg_data IS NULL) THEN
627: FND_MSG_PUB.Count_And_Get
628: ( p_encoded => FND_API.G_FALSE
629: , p_count => x_msg_count
630: , p_data => x_msg_data
631: );

Line 640: FND_MSG_PUB.Count_And_Get

636: END IF;
637:
638: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
639: IF (x_msg_data IS NULL) THEN
640: FND_MSG_PUB.Count_And_Get
641: ( p_encoded => FND_API.G_FALSE
642: , p_count => x_msg_count
643: , p_data => x_msg_data
644: );

Line 710: FND_MSG_PUB.Count_And_Get

706:
707: EXCEPTION
708: WHEN FND_API.G_EXC_ERROR THEN
709:
710: FND_MSG_PUB.Count_And_Get
711: ( p_encoded => FND_API.G_FALSE
712: , p_count => x_msg_count
713: , p_data => x_msg_data
714: );

Line 720: FND_MSG_PUB.Count_And_Get

716: RAISE;
717:
718: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
719:
720: FND_MSG_PUB.Count_And_Get
721: ( p_encoded => FND_API.G_FALSE
722: , p_count => x_msg_count
723: , p_data => x_msg_data
724: );