eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_DEFAULT_KEY_ITEM_PUB dependencies on FND_API

Line 54: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
58: (

Line 111: RAISE FND_API.G_EXC_ERROR;

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;
115: END IF;

Line 117: WHEN FND_API.G_EXC_ERROR THEN

113: END IF;
114: END LOOP;
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

Line 120: ( p_encoded => FND_API.G_FALSE

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: );
124: END IF;

Line 125: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

121: , p_count => x_msg_count
122: , p_data => x_msg_data
123: );
124: END IF;
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

Line 126: x_return_status := FND_API.G_RET_STS_ERROR;

122: , p_data => x_msg_data
123: );
124: END IF;
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

Line 127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

123: );
124: END IF;
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

Line 130: ( p_encoded => FND_API.G_FALSE

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: );
134: END IF;

Line 135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

131: , p_count => x_msg_count
132: , p_data => x_msg_data
133: );
134: END IF;
135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
136: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
137:
138: WHEN NO_DATA_FOUND THEN
139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 136: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);

132: , p_data => x_msg_data
133: );
134: END IF;
135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
136: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
137:
138: WHEN NO_DATA_FOUND THEN
139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
140: IF (x_msg_data IS NOT NULL) THEN

Line 139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
136: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
137:
138: WHEN NO_DATA_FOUND THEN
139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
140: IF (x_msg_data IS NOT NULL) THEN
141: x_msg_data := x_msg_data||' -> BSC_DEFAULT_KEY_ITEM_PUB.Validate_key_shared_obj ';
142: ELSE
143: x_msg_data := SQLERRM||' at BSC_DEFAULT_KEY_ITEM_PUB.Validate_key_shared_obj ';

Line 148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

144: END IF;
145: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
146: WHEN OTHERS THEN
147:
148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
149: IF (x_msg_data IS NOT NULL) THEN
150: x_msg_data := x_msg_data||' -> BSC_DEFAULT_KEY_ITEM_PUB.Validate_key_shared_obj ';
151: ELSE
152: x_msg_data := SQLERRM||' at BSC_DEFAULT_KEY_ITEM_PUB.Validate_key_shared_obj ';

Line 164: , p_commit IN VARCHAR2 := FND_API.G_FALSE

160:
161: PROCEDURE Update_Default_Key_Items(
162: p_kpi_id IN VARCHAR2
163: , p_params IN VARCHAR2
164: , p_commit IN VARCHAR2 := FND_API.G_FALSE
165: , x_return_status OUT NOCOPY VARCHAR2
166: , x_msg_count OUT NOCOPY NUMBER
167: , x_msg_data OUT NOCOPY VARCHAR2
168: ) IS

Line 174: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
178: SAVEPOINT bsc_key_item_pub_upd_key_item;

Line 199: IF(x_return_status IS NOT NULL AND x_return_status<>FND_API.G_RET_STS_SUCCESS)THEN

195: , x_msg_count => x_msg_count
196: , x_msg_data => x_msg_data
197: );
198:
199: IF(x_return_status IS NOT NULL AND x_return_status<>FND_API.G_RET_STS_SUCCESS)THEN
200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
201: END IF;
202:
203: Cascade_Key_Item_Changes --CASCADE the changes to the shared objective also

Line 200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

196: , x_msg_data => x_msg_data
197: );
198:
199: IF(x_return_status IS NOT NULL AND x_return_status<>FND_API.G_RET_STS_SUCCESS)THEN
200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
201: END IF;
202:
203: Cascade_Key_Item_Changes --CASCADE the changes to the shared objective also
204: (

Line 212: IF(x_return_status IS NOT NULL AND x_return_status<>FND_API.G_RET_STS_SUCCESS)THEN

208: , x_return_status => x_return_status
209: , x_msg_count => x_msg_count
210: , x_msg_data => x_msg_data
211: );
212: IF(x_return_status IS NOT NULL AND x_return_status<>FND_API.G_RET_STS_SUCCESS)THEN
213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
214: END IF;
215: END IF;
216:

Line 213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

209: , x_msg_count => x_msg_count
210: , x_msg_data => x_msg_data
211: );
212: IF(x_return_status IS NOT NULL AND x_return_status<>FND_API.G_RET_STS_SUCCESS)THEN
213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
214: END IF;
215: END IF;
216:
217: END IF;

Line 219: IF (p_commit = FND_API.G_TRUE) THEN

215: END IF;
216:
217: END IF;
218:
219: IF (p_commit = FND_API.G_TRUE) THEN
220: COMMIT;
221: END IF;
222:
223: EXCEPTION

Line 224: WHEN FND_API.G_EXC_ERROR THEN

220: COMMIT;
221: END IF;
222:
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

Line 228: ( p_encoded => FND_API.G_FALSE

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: );
232: END IF;

Line 233: x_return_status := FND_API.G_RET_STS_ERROR;

229: , p_count => x_msg_count
230: , p_data => x_msg_data
231: );
232: END IF;
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

Line 234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

230: , p_data => x_msg_data
231: );
232: END IF;
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

Line 238: ( p_encoded => FND_API.G_FALSE

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: );
242: END IF;

Line 243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

239: , p_count => x_msg_count
240: , p_data => x_msg_data
241: );
242: END IF;
243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
244: WHEN OTHERS THEN
245: ROLLBACK TO bsc_key_item_pub_upd_key_item;
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
247: IF (x_msg_data IS NOT NULL) THEN

Line 246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

242: END IF;
243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
244: WHEN OTHERS THEN
245: ROLLBACK TO bsc_key_item_pub_upd_key_item;
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
247: IF (x_msg_data IS NOT NULL) THEN
248: x_msg_data := x_msg_data||' -> BSC_DEFAULT_KEY_ITEM_PUB.Update_Default_Key_Items ';
249: ELSE
250: x_msg_data := SQLERRM||' at BSC_DEFAULT_KEY_ITEM_PUB.Update_Default_Key_Items ';

Line 314: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
318:

Line 334: , p_commit => FND_API.G_FALSE

330: BSC_DEFAULT_KEY_ITEM_PUB.Update_Key_Item
331: (
332: p_kpi_id => l_indicator
333: , p_params => l_params
334: , p_commit => FND_API.G_FALSE
335: , x_return_status => x_return_status
336: , x_msg_count => x_msg_count
337: , x_msg_data => x_msg_data
338: );

Line 339: IF(x_return_status IS NOT NULL AND x_return_status<>FND_API.G_RET_STS_SUCCESS)THEN

335: , x_return_status => x_return_status
336: , x_msg_count => x_msg_count
337: , x_msg_data => x_msg_data
338: );
339: IF(x_return_status IS NOT NULL AND x_return_status<>FND_API.G_RET_STS_SUCCESS)THEN
340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
341: END IF;
342: END IF;
343: END IF;

Line 340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

336: , x_msg_count => x_msg_count
337: , x_msg_data => x_msg_data
338: );
339: IF(x_return_status IS NOT NULL AND x_return_status<>FND_API.G_RET_STS_SUCCESS)THEN
340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
341: END IF;
342: END IF;
343: END IF;
344:

Line 346: WHEN FND_API.G_EXC_ERROR THEN

342: END IF;
343: END IF;
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

Line 349: ( p_encoded => FND_API.G_FALSE

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: );
353: END IF;

Line 354: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

350: , p_count => x_msg_count
351: , p_data => x_msg_data
352: );
353: END IF;
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

Line 355: x_return_status := FND_API.G_RET_STS_ERROR;

351: , p_data => x_msg_data
352: );
353: END IF;
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

Line 356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

352: );
353: END IF;
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

Line 359: ( p_encoded => FND_API.G_FALSE

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: );
363: END IF;

Line 364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

360: , p_count => x_msg_count
361: , p_data => x_msg_data
362: );
363: END IF;
364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
365: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
366: WHEN NO_DATA_FOUND THEN
367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
368: IF (x_msg_data IS NOT NULL) THEN

Line 365: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);

361: , p_data => x_msg_data
362: );
363: END IF;
364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
365: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
366: WHEN NO_DATA_FOUND THEN
367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
368: IF (x_msg_data IS NOT NULL) THEN
369: x_msg_data := x_msg_data||' -> BSC_DEFAULT_KEY_ITEM_PUB.Set_Key_Item_Value ';

Line 367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

363: END IF;
364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
365: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
366: WHEN NO_DATA_FOUND THEN
367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
368: IF (x_msg_data IS NOT NULL) THEN
369: x_msg_data := x_msg_data||' -> BSC_DEFAULT_KEY_ITEM_PUB.Set_Key_Item_Value ';
370: ELSE
371: x_msg_data := SQLERRM||' at BSC_DEFAULT_KEY_ITEM_PUB.Set_Key_Item_Value ';

Line 375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

371: x_msg_data := SQLERRM||' at BSC_DEFAULT_KEY_ITEM_PUB.Set_Key_Item_Value ';
372: END IF;
373: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
374: WHEN OTHERS THEN
375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
376: IF (x_msg_data IS NOT NULL) THEN
377: x_msg_data := x_msg_data||' -> BSC_DEFAULT_KEY_ITEM_PUB.Set_Key_Item_Value ';
378: ELSE
379: x_msg_data := SQLERRM||' at BSC_DEFAULT_KEY_ITEM_PUB.Set_Key_Item_Value ';

Line 389: , p_commit IN VARCHAR2 := FND_API.G_FALSE

385:
386: PROCEDURE Update_Key_Item(
387: p_kpi_id IN VARCHAR2
388: , p_params IN VARCHAR2
389: , p_commit IN VARCHAR2 := FND_API.G_FALSE
390: , x_return_status OUT NOCOPY VARCHAR2
391: , x_msg_count OUT NOCOPY NUMBER
392: , x_msg_data OUT NOCOPY VARCHAR2
393: ) IS

Line 421: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
425: BSC_DEFAULT_KEY_ITEM_PUB.Validate_key_shared_obj

Line 434: IF(x_return_status IS NOT NULL AND x_return_status<>FND_API.G_RET_STS_SUCCESS)THEN

430: , x_msg_count => x_msg_count
431: , x_msg_data => x_msg_data
432: );
433:
434: IF(x_return_status IS NOT NULL AND x_return_status<>FND_API.G_RET_STS_SUCCESS)THEN
435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
436: END IF;
437:
438: BSC_UTILITY.Parse_String (

Line 435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

431: , x_msg_data => x_msg_data
432: );
433:
434: IF(x_return_status IS NOT NULL AND x_return_status<>FND_API.G_RET_STS_SUCCESS)THEN
435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
436: END IF;
437:
438: BSC_UTILITY.Parse_String (
439: p_List => p_params,

Line 613: IF(x_return_status IS NOT NULL AND x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN

609: x_msg_data => x_msg_data
610: );
611:
612:
613: IF(x_return_status IS NOT NULL AND x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN
614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
615: END IF;
616: END IF;
617: END IF;

Line 614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

610: );
611:
612:
613: IF(x_return_status IS NOT NULL AND x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN
614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
615: END IF;
616: END IF;
617: END IF;
618: END IF;

Line 620: IF (p_commit = FND_API.G_TRUE) THEN

616: END IF;
617: END IF;
618: END IF;
619:
620: IF (p_commit = FND_API.G_TRUE) THEN
621: COMMIT;
622: END IF;
623:
624: EXCEPTION

Line 625: WHEN FND_API.G_EXC_ERROR THEN

621: COMMIT;
622: END IF;
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

Line 628: ( p_encoded => FND_API.G_FALSE

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: );
632: END IF;

Line 633: x_return_status := FND_API.G_RET_STS_ERROR;

629: , p_count => x_msg_count
630: , p_data => x_msg_data
631: );
632: END IF;
633: x_return_status := FND_API.G_RET_STS_ERROR;
634: IF(ref_cur%ISOPEN) THEN
635: CLOSE ref_cur;
636: END IF;
637:

Line 638: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

634: IF(ref_cur%ISOPEN) THEN
635: CLOSE ref_cur;
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

Line 641: ( p_encoded => FND_API.G_FALSE

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: );
645: END IF;

Line 646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

642: , p_count => x_msg_count
643: , p_data => x_msg_data
644: );
645: END IF;
646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
647: IF(ref_cur%ISOPEN) THEN
648: CLOSE ref_cur;
649: END IF;
650:

Line 653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

649: END IF;
650:
651:
652: WHEN OTHERS THEN
653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
654: IF (x_msg_data IS NOT NULL) THEN
655: x_msg_data := x_msg_data||' -> BSC_DEFAULT_KEY_ITEM_PUB.Update_Key_Item ';
656: ELSE
657: x_msg_data := SQLERRM||' at BSC_DEFAULT_KEY_ITEM_PUB.Update_Key_Item ';

Line 670: , p_commit IN VARCHAR2 := FND_API.G_FALSE

666:
667: PROCEDURE Cascade_Key_Item_Changes(
668: p_kpi_id IN VARCHAR2
669: , p_params IN VARCHAR2
670: , p_commit IN VARCHAR2 := FND_API.G_FALSE
671: , x_return_status OUT NOCOPY VARCHAR2
672: , x_msg_count OUT NOCOPY NUMBER
673: , x_msg_data OUT NOCOPY VARCHAR2
674: ) IS

Line 703: IF (p_commit = FND_API.G_TRUE) THEN

699: END LOOP;
700:
701: END IF;
702:
703: IF (p_commit = FND_API.G_TRUE) THEN
704: COMMIT;
705: END IF;
706:
707: EXCEPTION

Line 708: WHEN FND_API.G_EXC_ERROR THEN

704: COMMIT;
705: END IF;
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

Line 711: ( p_encoded => FND_API.G_FALSE

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: );
715: x_return_status := FND_API.G_RET_STS_ERROR;

Line 715: x_return_status := FND_API.G_RET_STS_ERROR;

711: ( p_encoded => FND_API.G_FALSE
712: , p_count => x_msg_count
713: , p_data => x_msg_data
714: );
715: x_return_status := FND_API.G_RET_STS_ERROR;
716: RAISE;
717:
718: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
719:

Line 718: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

714: );
715: x_return_status := FND_API.G_RET_STS_ERROR;
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

Line 721: ( p_encoded => FND_API.G_FALSE

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: );
725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

721: ( p_encoded => FND_API.G_FALSE
722: , p_count => x_msg_count
723: , p_data => x_msg_data
724: );
725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
726: RAISE;
727:
728: WHEN OTHERS THEN
729:

Line 730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

726: RAISE;
727:
728: WHEN OTHERS THEN
729:
730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
731: IF (x_msg_data IS NOT NULL) THEN
732: x_msg_data := x_msg_data||' -> BSC_DEFAULT_KEY_ITEM_PUB.Cascade_Key_Item_Changes ';
733: ELSE
734: x_msg_data := SQLERRM||' at BSC_DEFAULT_KEY_ITEM_PUB.Cascade_Key_Item_Changes ';