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_BIS_LOCKS_PVT dependencies on FND_API

Line 150: WHEN FND_API.G_EXC_ERROR THEN

146: ,x_msg_data => x_msg_data
147: );
148:
149: EXCEPTION
150: WHEN FND_API.G_EXC_ERROR THEN
151: ROLLBACK TO BSCSetTimeDataSetPVT;
152: x_return_status := FND_API.G_RET_STS_ERROR;
153: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
154: ,p_data => x_msg_data);

Line 152: x_return_status := FND_API.G_RET_STS_ERROR;

148:
149: EXCEPTION
150: WHEN FND_API.G_EXC_ERROR THEN
151: ROLLBACK TO BSCSetTimeDataSetPVT;
152: x_return_status := FND_API.G_RET_STS_ERROR;
153: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
154: ,p_data => x_msg_data);
155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
156: ROLLBACK TO BSCSetTimeDataSetPVT;

Line 155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

151: ROLLBACK TO BSCSetTimeDataSetPVT;
152: x_return_status := FND_API.G_RET_STS_ERROR;
153: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
154: ,p_data => x_msg_data);
155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
156: ROLLBACK TO BSCSetTimeDataSetPVT;
157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
158: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
159: ,p_data => x_msg_data);

Line 157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

153: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
154: ,p_data => x_msg_data);
155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
156: ROLLBACK TO BSCSetTimeDataSetPVT;
157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
158: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
159: ,p_data => x_msg_data);
160: WHEN OTHERS THEN
161: ROLLBACK TO BSCSetTimeDataSetPVT;

Line 162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

158: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
159: ,p_data => x_msg_data);
160: WHEN OTHERS THEN
161: ROLLBACK TO BSCSetTimeDataSetPVT;
162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
163: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
164: ,p_data => x_msg_data);
165:
166: end SET_TIME_STAMP_DATASET;

Line 189: WHEN FND_API.G_EXC_ERROR THEN

185: WHERE DATASET_ID =:2';
186: execute immediate l_sql USING p_lud, p_dim_set_id;
187:
188: EXCEPTION
189: WHEN FND_API.G_EXC_ERROR THEN
190: ROLLBACK TO BSCSetTimeDataSetPVT;
191: x_return_status := FND_API.G_RET_STS_ERROR;
192: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
193: ,p_data => x_msg_data);

Line 191: x_return_status := FND_API.G_RET_STS_ERROR;

187:
188: EXCEPTION
189: WHEN FND_API.G_EXC_ERROR THEN
190: ROLLBACK TO BSCSetTimeDataSetPVT;
191: x_return_status := FND_API.G_RET_STS_ERROR;
192: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
193: ,p_data => x_msg_data);
194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
195: ROLLBACK TO BSCSetTimeDataSetPVT;

Line 194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

190: ROLLBACK TO BSCSetTimeDataSetPVT;
191: x_return_status := FND_API.G_RET_STS_ERROR;
192: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
193: ,p_data => x_msg_data);
194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
195: ROLLBACK TO BSCSetTimeDataSetPVT;
196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
197: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
198: ,p_data => x_msg_data);

Line 196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

192: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
193: ,p_data => x_msg_data);
194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
195: ROLLBACK TO BSCSetTimeDataSetPVT;
196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
197: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
198: ,p_data => x_msg_data);
199: WHEN OTHERS THEN
200: ROLLBACK TO BSCSetTimeDataSetPVT;

Line 201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

197: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
198: ,p_data => x_msg_data);
199: WHEN OTHERS THEN
200: ROLLBACK TO BSCSetTimeDataSetPVT;
201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
202: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
203: ,p_data => x_msg_data);
204:
205: end SET_TIME_STAMP_DATASET;

Line 229: WHEN FND_API.G_EXC_ERROR THEN

225: ,x_msg_data => x_msg_data
226: );
227:
228: EXCEPTION
229: WHEN FND_API.G_EXC_ERROR THEN
230: ROLLBACK TO BSCSetTimeDataSrcPVT;
231: x_return_status := FND_API.G_RET_STS_ERROR;
232: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
233: ,p_data => x_msg_data);

Line 231: x_return_status := FND_API.G_RET_STS_ERROR;

227:
228: EXCEPTION
229: WHEN FND_API.G_EXC_ERROR THEN
230: ROLLBACK TO BSCSetTimeDataSrcPVT;
231: x_return_status := FND_API.G_RET_STS_ERROR;
232: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
233: ,p_data => x_msg_data);
234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
235: ROLLBACK TO BSCSetTimeDataSrcPVT;

Line 234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

230: ROLLBACK TO BSCSetTimeDataSrcPVT;
231: x_return_status := FND_API.G_RET_STS_ERROR;
232: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
233: ,p_data => x_msg_data);
234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
235: ROLLBACK TO BSCSetTimeDataSrcPVT;
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
237: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
238: ,p_data => x_msg_data);

Line 236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

232: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
233: ,p_data => x_msg_data);
234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
235: ROLLBACK TO BSCSetTimeDataSrcPVT;
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
237: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
238: ,p_data => x_msg_data);
239: WHEN OTHERS THEN
240: ROLLBACK TO BSCSetTimeDataSrcPVT;

Line 241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

237: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
238: ,p_data => x_msg_data);
239: WHEN OTHERS THEN
240: ROLLBACK TO BSCSetTimeDataSrcPVT;
241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
242: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
243: ,p_data => x_msg_data);
244:
245: end SET_TIME_STAMP_DATASOURCE;

Line 268: WHEN FND_API.G_EXC_ERROR THEN

264: WHERE MEASURE_ID =:2';
265: execute immediate l_sql USING p_lud, p_measure_id;
266:
267: EXCEPTION
268: WHEN FND_API.G_EXC_ERROR THEN
269: ROLLBACK TO BSCSetTimeDataSrcPVT;
270: x_return_status := FND_API.G_RET_STS_ERROR;
271: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
272: ,p_data => x_msg_data);

Line 270: x_return_status := FND_API.G_RET_STS_ERROR;

266:
267: EXCEPTION
268: WHEN FND_API.G_EXC_ERROR THEN
269: ROLLBACK TO BSCSetTimeDataSrcPVT;
270: x_return_status := FND_API.G_RET_STS_ERROR;
271: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
272: ,p_data => x_msg_data);
273: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
274: ROLLBACK TO BSCSetTimeDataSrcPVT;

Line 273: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

269: ROLLBACK TO BSCSetTimeDataSrcPVT;
270: x_return_status := FND_API.G_RET_STS_ERROR;
271: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
272: ,p_data => x_msg_data);
273: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
274: ROLLBACK TO BSCSetTimeDataSrcPVT;
275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
276: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
277: ,p_data => x_msg_data);

Line 275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

271: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
272: ,p_data => x_msg_data);
273: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
274: ROLLBACK TO BSCSetTimeDataSrcPVT;
275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
276: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
277: ,p_data => x_msg_data);
278: WHEN OTHERS THEN
279: ROLLBACK TO BSCSetTimeDataSrcPVT;

Line 280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

276: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
277: ,p_data => x_msg_data);
278: WHEN OTHERS THEN
279: ROLLBACK TO BSCSetTimeDataSrcPVT;
280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
281: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
282: ,p_data => x_msg_data);
283:
284: end SET_TIME_STAMP_DATASOURCE;

Line 334: x_return_status := FND_API.G_RET_STS_ERROR;

330: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE'); -- ADRAO changed Measage
331: l_meaning := bsc_apps.get_lookup_value('BSC_UI_COMMON', 'EDW_MEASURE'); -- added by ADRAO
332: FND_MESSAGE.SET_TOKEN('TYPE', l_meaning, TRUE);
333: FND_MSG_PUB.ADD;
334: x_return_status := FND_API.G_RET_STS_ERROR;
335: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
336: ,p_data => x_msg_data);
337: RAISE FND_API.G_EXC_ERROR;
338: end if;

Line 337: RAISE FND_API.G_EXC_ERROR;

333: FND_MSG_PUB.ADD;
334: x_return_status := FND_API.G_RET_STS_ERROR;
335: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
336: ,p_data => x_msg_data);
337: RAISE FND_API.G_EXC_ERROR;
338: end if;
339: if not p_time_stamp is null then
340: if p_time_stamp <> TO_CHAR(l_last_update_date, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT) then
341: --dbms_output.put_line(' p_dataset_id = ' || p_dataset_id || ' updated by other user ');

Line 346: x_return_status := FND_API.G_RET_STS_ERROR;

342: FND_MSG_PUB.Initialize;
343: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_MEASURE');
344: FND_MESSAGE.SET_TOKEN('MEASURE', get_Dataset_Name(p_dataset_id));
345: FND_MSG_PUB.ADD;
346: x_return_status := FND_API.G_RET_STS_ERROR;
347: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
348: ,p_data => x_msg_data);
349: RAISE FND_API.G_EXC_ERROR;
350: l_last_update_date := l_last_update_date;

Line 349: RAISE FND_API.G_EXC_ERROR;

345: FND_MSG_PUB.ADD;
346: x_return_status := FND_API.G_RET_STS_ERROR;
347: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
348: ,p_data => x_msg_data);
349: RAISE FND_API.G_EXC_ERROR;
350: l_last_update_date := l_last_update_date;
351: end if;
352: end if;
353:

Line 395: WHEN FND_API.G_EXC_ERROR THEN

391: --dbms_output.put_line(' p_dataset_id = ' || p_dataset_id || ' successfuly locked ');
392:
393:
394: EXCEPTION
395: WHEN FND_API.G_EXC_ERROR THEN
396: ROLLBACK TO BSCLockDataSetPVT;
397: x_return_status := FND_API.G_RET_STS_ERROR;
398: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
399: ,p_data => x_msg_data);

Line 397: x_return_status := FND_API.G_RET_STS_ERROR;

393:
394: EXCEPTION
395: WHEN FND_API.G_EXC_ERROR THEN
396: ROLLBACK TO BSCLockDataSetPVT;
397: x_return_status := FND_API.G_RET_STS_ERROR;
398: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
399: ,p_data => x_msg_data);
400: raise;
401: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 401: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

397: x_return_status := FND_API.G_RET_STS_ERROR;
398: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
399: ,p_data => x_msg_data);
400: raise;
401: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
402: ROLLBACK TO BSCLockDataSetPVT;
403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
404: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
405: ,p_data => x_msg_data);

Line 403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

399: ,p_data => x_msg_data);
400: raise;
401: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
402: ROLLBACK TO BSCLockDataSetPVT;
403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
404: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
405: ,p_data => x_msg_data);
406: raise;
407: WHEN OTHERS THEN

Line 415: x_return_status := FND_API.G_RET_STS_ERROR;

411: FND_MSG_PUB.Initialize;
412: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_LOCKED_MEASURE');
413: FND_MESSAGE.SET_TOKEN('MEASURE', get_Dataset_Name(p_dataset_id));
414: FND_MSG_PUB.ADD;
415: x_return_status := FND_API.G_RET_STS_ERROR;
416: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
417: ,p_data => x_msg_data);
418: RAISE FND_API.G_EXC_ERROR;
419: end if;

Line 418: RAISE FND_API.G_EXC_ERROR;

414: FND_MSG_PUB.ADD;
415: x_return_status := FND_API.G_RET_STS_ERROR;
416: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
417: ,p_data => x_msg_data);
418: RAISE FND_API.G_EXC_ERROR;
419: end if;
420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
421: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
422: ,p_data => x_msg_data);

Line 420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

416: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
417: ,p_data => x_msg_data);
418: RAISE FND_API.G_EXC_ERROR;
419: end if;
420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
421: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
422: ,p_data => x_msg_data);
423: raise;
424: end LOCK_DATASET;

Line 462: x_return_status := FND_API.G_RET_STS_ERROR;

458: FND_MSG_PUB.Initialize;
459: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETED_MEASURE');
460: FND_MESSAGE.SET_TOKEN('MEASURE', nvl(p_dataset_name, nvl(get_Datasource_Name(p_measure_id),p_measure_id)));
461: FND_MSG_PUB.ADD;
462: x_return_status := FND_API.G_RET_STS_ERROR;
463: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
464: ,p_data => x_msg_data);
465: RAISE FND_API.G_EXC_ERROR;
466: end if;

Line 465: RAISE FND_API.G_EXC_ERROR;

461: FND_MSG_PUB.ADD;
462: x_return_status := FND_API.G_RET_STS_ERROR;
463: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
464: ,p_data => x_msg_data);
465: RAISE FND_API.G_EXC_ERROR;
466: end if;
467:
468: if not p_time_stamp is null then
469: if p_time_stamp <> TO_CHAR(l_last_update_date, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT) then

Line 475: x_return_status := FND_API.G_RET_STS_ERROR;

471: FND_MSG_PUB.Initialize;
472: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_MEASURE');
473: FND_MESSAGE.SET_TOKEN('MEASURE', nvl(p_dataset_name,get_Datasource_Name(p_measure_id)));
474: FND_MSG_PUB.ADD;
475: x_return_status := FND_API.G_RET_STS_ERROR;
476: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
477: ,p_data => x_msg_data);
478: RAISE FND_API.G_EXC_ERROR;
479: l_last_update_date := l_last_update_date;

Line 478: RAISE FND_API.G_EXC_ERROR;

474: FND_MSG_PUB.ADD;
475: x_return_status := FND_API.G_RET_STS_ERROR;
476: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
477: ,p_data => x_msg_data);
478: RAISE FND_API.G_EXC_ERROR;
479: l_last_update_date := l_last_update_date;
480: end if;
481: end if;
482: --dbms_output.put_line(' p_measure_id = ' || p_measure_id || ' successfuly locked ');

Line 485: WHEN FND_API.G_EXC_ERROR THEN

481: end if;
482: --dbms_output.put_line(' p_measure_id = ' || p_measure_id || ' successfuly locked ');
483:
484: EXCEPTION
485: WHEN FND_API.G_EXC_ERROR THEN
486: ROLLBACK TO BSCLockDataSrcPVT;
487: x_return_status := FND_API.G_RET_STS_ERROR;
488: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
489: ,p_data => x_msg_data);

Line 487: x_return_status := FND_API.G_RET_STS_ERROR;

483:
484: EXCEPTION
485: WHEN FND_API.G_EXC_ERROR THEN
486: ROLLBACK TO BSCLockDataSrcPVT;
487: x_return_status := FND_API.G_RET_STS_ERROR;
488: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
489: ,p_data => x_msg_data);
490: raise;
491: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 491: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

487: x_return_status := FND_API.G_RET_STS_ERROR;
488: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
489: ,p_data => x_msg_data);
490: raise;
491: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
492: ROLLBACK TO BSCLockDataSrcPVT;
493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
494: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
495: ,p_data => x_msg_data);

Line 493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

489: ,p_data => x_msg_data);
490: raise;
491: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
492: ROLLBACK TO BSCLockDataSrcPVT;
493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
494: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
495: ,p_data => x_msg_data);
496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
497: WHEN OTHERS THEN

Line 496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

492: ROLLBACK TO BSCLockDataSrcPVT;
493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
494: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
495: ,p_data => x_msg_data);
496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
497: WHEN OTHERS THEN
498: ROLLBACK TO BSCLockDataSrcPVT;
499: if (SQLCODE = -00054) then
500: --dbms_output.put_line(' p_measure_id = ' || p_measure_id || ' locked by other user ');

Line 505: x_return_status := FND_API.G_RET_STS_ERROR;

501: FND_MSG_PUB.Initialize;
502: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_LOCKED_MEASURE');
503: FND_MESSAGE.SET_TOKEN('MEASURE', nvl(p_dataset_name, get_Datasource_Name(p_measure_id)));
504: FND_MSG_PUB.ADD;
505: x_return_status := FND_API.G_RET_STS_ERROR;
506: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
507: ,p_data => x_msg_data);
508: RAISE FND_API.G_EXC_ERROR;
509: end if;

Line 508: RAISE FND_API.G_EXC_ERROR;

504: FND_MSG_PUB.ADD;
505: x_return_status := FND_API.G_RET_STS_ERROR;
506: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
507: ,p_data => x_msg_data);
508: RAISE FND_API.G_EXC_ERROR;
509: end if;
510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
511: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
512: ,p_data => x_msg_data);

Line 510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

506: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
507: ,p_data => x_msg_data);
508: RAISE FND_API.G_EXC_ERROR;
509: end if;
510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
511: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
512: ,p_data => x_msg_data);
513: raise;
514: end LOCK_DATASOURCE;

Line 651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

647: close l_cursor;
648:
649: EXCEPTION
650: WHEN OTHERS THEN
651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
652: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
653: ,p_data => x_msg_data);
654: raise;
655: END get_selected_dim_objs;

Line 689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

685: close l_cursor;
686:
687: EXCEPTION
688: WHEN OTHERS THEN
689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
690: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
691: ,p_data => x_msg_data);
692: raise;
693: END get_selected_dimensions;

Line 749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

745: end if;
746:
747: EXCEPTION
748: WHEN OTHERS THEN
749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
750: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
751: ,p_data => x_msg_data);
752: raise;
753: END get_impacted_objects;

Line 788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

784:
785: EXCEPTION
786: WHEN OTHERS THEN
787: -- rollback;
788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
789: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
790: ,p_data => x_msg_data);
791: raise;
792: END convert_table;

Line 852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

848:
849: EXCEPTION
850: WHEN OTHERS THEN
851: -- rollback;
852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
853: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
854: ,p_data => x_msg_data);
855:
856: --dbms_output.put_line(SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1, 255));

Line 914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

910:
911: EXCEPTION
912: WHEN OTHERS THEN
913: -- rollback;
914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
915: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
916: ,p_data => x_msg_data);
917:
918: --dbms_output.put_line(SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1, 255));

Line 958: x_return_status := FND_API.G_RET_STS_ERROR;

954: FND_MSG_PUB.Initialize;
955: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETED_DIM_LEVEL');
956: FND_MESSAGE.SET_TOKEN('DIM_LEVEL', nvl(get_Dim_Level_Name(p_dim_level_id),p_dim_level_id));
957: FND_MSG_PUB.ADD;
958: x_return_status := FND_API.G_RET_STS_ERROR;
959: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
960: ,p_data => x_msg_data);
961: RAISE FND_API.G_EXC_ERROR;
962: end if;

Line 961: RAISE FND_API.G_EXC_ERROR;

957: FND_MSG_PUB.ADD;
958: x_return_status := FND_API.G_RET_STS_ERROR;
959: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
960: ,p_data => x_msg_data);
961: RAISE FND_API.G_EXC_ERROR;
962: end if;
963:
964: if not p_time_stamp is null then
965: if p_time_stamp <> TO_CHAR(l_last_update_date, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT) then

Line 971: x_return_status := FND_API.G_RET_STS_ERROR;

967: FND_MSG_PUB.Initialize;
968: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_DIM_LEVEL');
969: FND_MESSAGE.SET_TOKEN('DIM_LEVEL', get_Dim_Level_Name(p_dim_level_id));
970: FND_MSG_PUB.ADD;
971: x_return_status := FND_API.G_RET_STS_ERROR;
972: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
973: ,p_data => x_msg_data);
974: RAISE FND_API.G_EXC_ERROR;
975: l_last_update_date := l_last_update_date;

Line 974: RAISE FND_API.G_EXC_ERROR;

970: FND_MSG_PUB.ADD;
971: x_return_status := FND_API.G_RET_STS_ERROR;
972: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
973: ,p_data => x_msg_data);
974: RAISE FND_API.G_EXC_ERROR;
975: l_last_update_date := l_last_update_date;
976: end if;
977: end if;
978: --dbms_output.put_line('Dimension Level Id = ' || p_dim_level_id || ' successfuly locked ');

Line 981: WHEN FND_API.G_EXC_ERROR THEN

977: end if;
978: --dbms_output.put_line('Dimension Level Id = ' || p_dim_level_id || ' successfuly locked ');
979:
980: EXCEPTION
981: WHEN FND_API.G_EXC_ERROR THEN
982: ROLLBACK TO BSCLockDimObjPVT;
983: x_return_status := FND_API.G_RET_STS_ERROR;
984: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
985: ,p_data => x_msg_data);

Line 983: x_return_status := FND_API.G_RET_STS_ERROR;

979:
980: EXCEPTION
981: WHEN FND_API.G_EXC_ERROR THEN
982: ROLLBACK TO BSCLockDimObjPVT;
983: x_return_status := FND_API.G_RET_STS_ERROR;
984: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
985: ,p_data => x_msg_data);
986: raise;
987: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 987: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

983: x_return_status := FND_API.G_RET_STS_ERROR;
984: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
985: ,p_data => x_msg_data);
986: raise;
987: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
988: ROLLBACK TO BSCLockDimObjPVT;
989: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
990: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
991: ,p_data => x_msg_data);

Line 989: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

985: ,p_data => x_msg_data);
986: raise;
987: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
988: ROLLBACK TO BSCLockDimObjPVT;
989: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
990: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
991: ,p_data => x_msg_data);
992: raise;
993: WHEN OTHERS THEN

Line 1001: x_return_status := FND_API.G_RET_STS_ERROR;

997: FND_MSG_PUB.Initialize;
998: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_LOCKED_DIM_LEVEL');
999: FND_MESSAGE.SET_TOKEN('DIM_LEVEL', get_Dim_Level_Name(p_dim_level_id));
1000: FND_MSG_PUB.ADD;
1001: x_return_status := FND_API.G_RET_STS_ERROR;
1002: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1003: ,p_data => x_msg_data);
1004: RAISE FND_API.G_EXC_ERROR;
1005: end if;

Line 1004: RAISE FND_API.G_EXC_ERROR;

1000: FND_MSG_PUB.ADD;
1001: x_return_status := FND_API.G_RET_STS_ERROR;
1002: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1003: ,p_data => x_msg_data);
1004: RAISE FND_API.G_EXC_ERROR;
1005: end if;
1006: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1007: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1008: ,p_data => x_msg_data);

Line 1006: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1002: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1003: ,p_data => x_msg_data);
1004: RAISE FND_API.G_EXC_ERROR;
1005: end if;
1006: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1007: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1008: ,p_data => x_msg_data);
1009: raise;
1010:

Line 1056: RAISE FND_API.G_EXC_ERROR;

1052: FND_MESSAGE.SET_TOKEN('DIM_GROUP', nvl(get_Dim_Group_Name(p_dim_group_id),p_dim_group_id));
1053: FND_MSG_PUB.ADD;
1054: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1055: ,p_data => x_msg_data);
1056: RAISE FND_API.G_EXC_ERROR;
1057: end if;
1058: if not p_time_stamp is null then
1059: if p_time_stamp <> TO_CHAR(l_last_update_date, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT) then
1060: --dbms_output.put_line('Dimension Group Id = ' || p_dim_group_id || ' updated by other user ');

Line 1067: RAISE FND_API.G_EXC_ERROR;

1063: FND_MESSAGE.SET_TOKEN('DIM_GROUP', get_Dim_Group_Name(p_dim_group_id));
1064: FND_MSG_PUB.ADD;
1065: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1066: ,p_data => x_msg_data);
1067: RAISE FND_API.G_EXC_ERROR;
1068: end if;
1069: end if;
1070: --dbms_output.put_line('Dimension Group Id = ' || p_dim_group_id || ' successfuly locked ');
1071:

Line 1073: WHEN FND_API.G_EXC_ERROR THEN

1069: end if;
1070: --dbms_output.put_line('Dimension Group Id = ' || p_dim_group_id || ' successfuly locked ');
1071:
1072: EXCEPTION
1073: WHEN FND_API.G_EXC_ERROR THEN
1074: ROLLBACK TO BSCLockDimPVT;
1075: x_return_status := FND_API.G_RET_STS_ERROR;
1076: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1077: ,p_data => x_msg_data);

Line 1075: x_return_status := FND_API.G_RET_STS_ERROR;

1071:
1072: EXCEPTION
1073: WHEN FND_API.G_EXC_ERROR THEN
1074: ROLLBACK TO BSCLockDimPVT;
1075: x_return_status := FND_API.G_RET_STS_ERROR;
1076: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1077: ,p_data => x_msg_data);
1078: raise;
1079: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1079: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1075: x_return_status := FND_API.G_RET_STS_ERROR;
1076: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1077: ,p_data => x_msg_data);
1078: raise;
1079: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1080: ROLLBACK TO BSCLockDimPVT;
1081: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1082: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1083: ,p_data => x_msg_data);

Line 1081: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1077: ,p_data => x_msg_data);
1078: raise;
1079: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1080: ROLLBACK TO BSCLockDimPVT;
1081: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1082: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1083: ,p_data => x_msg_data);
1084: raise;
1085: WHEN OTHERS THEN

Line 1093: x_return_status := FND_API.G_RET_STS_ERROR;

1089: FND_MSG_PUB.Initialize;
1090: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_LOCKED_DIM_GROUP');
1091: FND_MESSAGE.SET_TOKEN('DIM_GROUP', get_Dim_Group_Name(p_dim_group_id));
1092: FND_MSG_PUB.ADD;
1093: x_return_status := FND_API.G_RET_STS_ERROR;
1094: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1095: ,p_data => x_msg_data);
1096: RAISE FND_API.G_EXC_ERROR;
1097:

Line 1096: RAISE FND_API.G_EXC_ERROR;

1092: FND_MSG_PUB.ADD;
1093: x_return_status := FND_API.G_RET_STS_ERROR;
1094: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1095: ,p_data => x_msg_data);
1096: RAISE FND_API.G_EXC_ERROR;
1097:
1098: end if;
1099:
1100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1096: RAISE FND_API.G_EXC_ERROR;
1097:
1098: end if;
1099:
1100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1101: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1102: ,p_data => x_msg_data);
1103: raise;
1104:

Line 1151: RAISE FND_API.G_EXC_ERROR;

1147: FND_MESSAGE.SET_TOKEN('KPI', nvl(get_KPI_Name(p_kpi_Id),p_kpi_Id)); -- Fixed Bug#3047483
1148: FND_MSG_PUB.ADD;
1149: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1150: ,p_data => x_msg_data);
1151: RAISE FND_API.G_EXC_ERROR;
1152: end if;
1153: if not p_time_stamp is null then
1154: if p_time_stamp <> TO_CHAR(l_last_update_date, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT) then
1155: --dbms_output.put_line('Kpi = ' || p_kpi_id || ' Dimension Set Id = ' || p_dim_set_id || ' updated by other user ');

Line 1163: RAISE FND_API.G_EXC_ERROR;

1159: FND_MESSAGE.SET_TOKEN('KPI', get_KPI_Name(p_kpi_Id)); -- Fixed Bug#3047483
1160: FND_MSG_PUB.ADD;
1161: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1162: ,p_data => x_msg_data);
1163: RAISE FND_API.G_EXC_ERROR;
1164: end if;
1165: end if;
1166: --dbms_output.put_line('Kpi = ' || p_kpi_id || ' Dimension Set Id = ' || p_dim_set_id || ' successfuly locked ');
1167:

Line 1169: WHEN FND_API.G_EXC_ERROR THEN

1165: end if;
1166: --dbms_output.put_line('Kpi = ' || p_kpi_id || ' Dimension Set Id = ' || p_dim_set_id || ' successfuly locked ');
1167:
1168: EXCEPTION
1169: WHEN FND_API.G_EXC_ERROR THEN
1170: ROLLBACK TO BSCLockDimSetPVT;
1171: x_return_status := FND_API.G_RET_STS_ERROR;
1172: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1173: ,p_data => x_msg_data);

Line 1171: x_return_status := FND_API.G_RET_STS_ERROR;

1167:
1168: EXCEPTION
1169: WHEN FND_API.G_EXC_ERROR THEN
1170: ROLLBACK TO BSCLockDimSetPVT;
1171: x_return_status := FND_API.G_RET_STS_ERROR;
1172: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1173: ,p_data => x_msg_data);
1174: raise;
1175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1171: x_return_status := FND_API.G_RET_STS_ERROR;
1172: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1173: ,p_data => x_msg_data);
1174: raise;
1175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1176: ROLLBACK TO BSCLockDimSetPVT;
1177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1178: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1179: ,p_data => x_msg_data);

Line 1177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1173: ,p_data => x_msg_data);
1174: raise;
1175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1176: ROLLBACK TO BSCLockDimSetPVT;
1177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1178: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1179: ,p_data => x_msg_data);
1180: raise;
1181: WHEN OTHERS THEN

Line 1190: x_return_status := FND_API.G_RET_STS_ERROR;

1186: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_LOCKED_DIM_SET');
1187: FND_MESSAGE.SET_TOKEN('DIM_SET', get_Dim_Set_Name(p_dim_set_id, p_kpi_Id));
1188: FND_MESSAGE.SET_TOKEN('KPI', get_KPI_Name(p_kpi_Id));
1189: FND_MSG_PUB.ADD;
1190: x_return_status := FND_API.G_RET_STS_ERROR;
1191: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1192: ,p_data => x_msg_data);
1193: RAISE FND_API.G_EXC_ERROR;
1194: end if;

Line 1193: RAISE FND_API.G_EXC_ERROR;

1189: FND_MSG_PUB.ADD;
1190: x_return_status := FND_API.G_RET_STS_ERROR;
1191: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1192: ,p_data => x_msg_data);
1193: RAISE FND_API.G_EXC_ERROR;
1194: end if;
1195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1196: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1197: ,p_data => x_msg_data);

Line 1195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1191: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1192: ,p_data => x_msg_data);
1193: RAISE FND_API.G_EXC_ERROR;
1194: end if;
1195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1196: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1197: ,p_data => x_msg_data);
1198: raise;
1199:

Line 1209: ,p_full_lock_flag IN varchar2 /:= FND_API.G_FALSE /

1205:
1206: Procedure LOCK_KPI(
1207: p_kpi_Id IN number
1208: ,p_time_stamp IN varchar2 /* := null */
1209: ,p_full_lock_flag IN varchar2 /*:= FND_API.G_FALSE */
1210: ,x_return_status OUT NOCOPY varchar2
1211: ,x_msg_count OUT NOCOPY number
1212: ,x_msg_data OUT NOCOPY varchar2
1213: ) is

Line 1245: RAISE FND_API.G_EXC_ERROR;

1241: FND_MESSAGE.SET_TOKEN('KPI', nvl(get_KPI_Name(p_kpi_Id),p_kpi_Id ));
1242: FND_MSG_PUB.ADD;
1243: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1244: ,p_data => x_msg_data);
1245: RAISE FND_API.G_EXC_ERROR;
1246: end if;
1247: close l_cursor;
1248:
1249: if not p_time_stamp is null then

Line 1259: RAISE FND_API.G_EXC_ERROR;

1255: FND_MESSAGE.SET_TOKEN('KPI', get_KPI_Name(p_kpi_Id));
1256: FND_MSG_PUB.ADD;
1257: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1258: ,p_data => x_msg_data);
1259: RAISE FND_API.G_EXC_ERROR;
1260: end if;
1261: end if;
1262:
1263: If p_full_lock_flag = FND_API.G_TRUE then

Line 1263: If p_full_lock_flag = FND_API.G_TRUE then

1259: RAISE FND_API.G_EXC_ERROR;
1260: end if;
1261: end if;
1262:
1263: If p_full_lock_flag = FND_API.G_TRUE then
1264: --SQL statement used to lock ALL the Dimension Sets:
1265: l_sql := '
1266: SELECT INDICATOR, DIM_SET_ID
1267: FROM bsc_kpi_dim_sets_tl

Line 1278: WHEN FND_API.G_EXC_ERROR THEN

1274: --dbms_output.put_line('Kpi = ' || p_kpi_id || ' successfuly locked ');
1275:
1276:
1277: EXCEPTION
1278: WHEN FND_API.G_EXC_ERROR THEN
1279: ROLLBACK TO BSCLockKpiPVT;
1280: x_return_status := FND_API.G_RET_STS_ERROR;
1281: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1282: ,p_data => x_msg_data);

Line 1280: x_return_status := FND_API.G_RET_STS_ERROR;

1276:
1277: EXCEPTION
1278: WHEN FND_API.G_EXC_ERROR THEN
1279: ROLLBACK TO BSCLockKpiPVT;
1280: x_return_status := FND_API.G_RET_STS_ERROR;
1281: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1282: ,p_data => x_msg_data);
1283: raise;
1284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1280: x_return_status := FND_API.G_RET_STS_ERROR;
1281: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1282: ,p_data => x_msg_data);
1283: raise;
1284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1285: ROLLBACK TO BSCLockKpiPVT;
1286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1287: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1288: ,p_data => x_msg_data);

Line 1286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1282: ,p_data => x_msg_data);
1283: raise;
1284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1285: ROLLBACK TO BSCLockKpiPVT;
1286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1287: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1288: ,p_data => x_msg_data);
1289: --dbms_output.put_line('Procedure = LOCK_KPI G_EXC_UNEXPECTED_ERROR ');
1290:

Line 1300: x_return_status := FND_API.G_RET_STS_ERROR;

1296: FND_MSG_PUB.Initialize;
1297: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_LOCKED_KPI_1');
1298: FND_MESSAGE.SET_TOKEN('KPI', get_KPI_Name(p_kpi_Id));
1299: FND_MSG_PUB.ADD;
1300: x_return_status := FND_API.G_RET_STS_ERROR;
1301: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1302: ,p_data => x_msg_data);
1303: RAISE FND_API.G_EXC_ERROR;
1304: end if;

Line 1303: RAISE FND_API.G_EXC_ERROR;

1299: FND_MSG_PUB.ADD;
1300: x_return_status := FND_API.G_RET_STS_ERROR;
1301: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1302: ,p_data => x_msg_data);
1303: RAISE FND_API.G_EXC_ERROR;
1304: end if;
1305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1306: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1307: ,p_data => x_msg_data);

Line 1305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1301: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1302: ,p_data => x_msg_data);
1303: RAISE FND_API.G_EXC_ERROR;
1304: end if;
1305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1306: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1307: ,p_data => x_msg_data);
1308: --dbms_output.put_line('Procedure = LOCK_KPI OTHERS ');
1309:

Line 1513: WHEN FND_API.G_EXC_ERROR THEN

1509:
1510: execute immediate l_sql USING p_dim_level_id;
1511:
1512: EXCEPTION
1513: WHEN FND_API.G_EXC_ERROR THEN
1514: ROLLBACK TO BSCSetTimeDimObjPVT;
1515: x_return_status := FND_API.G_RET_STS_ERROR;
1516: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1517: ,p_data => x_msg_data);

Line 1515: x_return_status := FND_API.G_RET_STS_ERROR;

1511:
1512: EXCEPTION
1513: WHEN FND_API.G_EXC_ERROR THEN
1514: ROLLBACK TO BSCSetTimeDimObjPVT;
1515: x_return_status := FND_API.G_RET_STS_ERROR;
1516: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1517: ,p_data => x_msg_data);
1518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1519: ROLLBACK TO BSCSetTimeDimObjPVT;

Line 1518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1514: ROLLBACK TO BSCSetTimeDimObjPVT;
1515: x_return_status := FND_API.G_RET_STS_ERROR;
1516: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1517: ,p_data => x_msg_data);
1518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1519: ROLLBACK TO BSCSetTimeDimObjPVT;
1520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1521: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1522: ,p_data => x_msg_data);

Line 1520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1516: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1517: ,p_data => x_msg_data);
1518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1519: ROLLBACK TO BSCSetTimeDimObjPVT;
1520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1521: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1522: ,p_data => x_msg_data);
1523:
1524: WHEN OTHERS THEN

Line 1526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1522: ,p_data => x_msg_data);
1523:
1524: WHEN OTHERS THEN
1525: ROLLBACK TO BSCSetTimeDimObjPVT;
1526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1527: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1528: ,p_data => x_msg_data);
1529:
1530: end SET_TIME_STAMP_DIM_LEVEL;

Line 1554: WHEN FND_API.G_EXC_ERROR THEN

1550:
1551: execute immediate l_sql USING p_dim_group_id;
1552:
1553: EXCEPTION
1554: WHEN FND_API.G_EXC_ERROR THEN
1555: ROLLBACK TO BSCSetTimeDimPVT;
1556: x_return_status := FND_API.G_RET_STS_ERROR;
1557: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1558: ,p_data => x_msg_data);

Line 1556: x_return_status := FND_API.G_RET_STS_ERROR;

1552:
1553: EXCEPTION
1554: WHEN FND_API.G_EXC_ERROR THEN
1555: ROLLBACK TO BSCSetTimeDimPVT;
1556: x_return_status := FND_API.G_RET_STS_ERROR;
1557: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1558: ,p_data => x_msg_data);
1559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1560: ROLLBACK TO BSCSetTimeDimPVT;

Line 1559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1555: ROLLBACK TO BSCSetTimeDimPVT;
1556: x_return_status := FND_API.G_RET_STS_ERROR;
1557: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1558: ,p_data => x_msg_data);
1559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1560: ROLLBACK TO BSCSetTimeDimPVT;
1561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1562: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1563: ,p_data => x_msg_data);

Line 1561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1557: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1558: ,p_data => x_msg_data);
1559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1560: ROLLBACK TO BSCSetTimeDimPVT;
1561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1562: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1563: ,p_data => x_msg_data);
1564: WHEN OTHERS THEN
1565: ROLLBACK TO BSCSetTimeDimPVT;

Line 1566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1562: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1563: ,p_data => x_msg_data);
1564: WHEN OTHERS THEN
1565: ROLLBACK TO BSCSetTimeDimPVT;
1566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1567: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1568: ,p_data => x_msg_data);
1569:
1570: end SET_TIME_STAMP_DIM_GROUP;

Line 1599: WHEN FND_API.G_EXC_ERROR THEN

1595: ,x_msg_count
1596: ,x_msg_data );
1597:
1598: EXCEPTION
1599: WHEN FND_API.G_EXC_ERROR THEN
1600: ROLLBACK TO BSCSetTimeDimSetPVT;
1601: x_return_status := FND_API.G_RET_STS_ERROR;
1602: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1603: ,p_data => x_msg_data);

Line 1601: x_return_status := FND_API.G_RET_STS_ERROR;

1597:
1598: EXCEPTION
1599: WHEN FND_API.G_EXC_ERROR THEN
1600: ROLLBACK TO BSCSetTimeDimSetPVT;
1601: x_return_status := FND_API.G_RET_STS_ERROR;
1602: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1603: ,p_data => x_msg_data);
1604: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1605: ROLLBACK TO BSCSetTimeDimSetPVT;

Line 1604: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1600: ROLLBACK TO BSCSetTimeDimSetPVT;
1601: x_return_status := FND_API.G_RET_STS_ERROR;
1602: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1603: ,p_data => x_msg_data);
1604: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1605: ROLLBACK TO BSCSetTimeDimSetPVT;
1606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1607: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1608: ,p_data => x_msg_data);

Line 1606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1602: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1603: ,p_data => x_msg_data);
1604: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1605: ROLLBACK TO BSCSetTimeDimSetPVT;
1606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1607: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1608: ,p_data => x_msg_data);
1609: WHEN OTHERS THEN
1610: ROLLBACK TO BSCSetTimeDimSetPVT;

Line 1611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1607: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1608: ,p_data => x_msg_data);
1609: WHEN OTHERS THEN
1610: ROLLBACK TO BSCSetTimeDimSetPVT;
1611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1612: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1613: ,p_data => x_msg_data);
1614:
1615: end SET_TIME_STAMP_DIM_SET;

Line 1639: WHEN FND_API.G_EXC_ERROR THEN

1635:
1636: -- Added Exception block
1637:
1638: EXCEPTION
1639: WHEN FND_API.G_EXC_ERROR THEN
1640: ROLLBACK TO BSCSetTimeKpiPVT;
1641: x_return_status := FND_API.G_RET_STS_ERROR;
1642: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1643: ,p_data => x_msg_data);

Line 1641: x_return_status := FND_API.G_RET_STS_ERROR;

1637:
1638: EXCEPTION
1639: WHEN FND_API.G_EXC_ERROR THEN
1640: ROLLBACK TO BSCSetTimeKpiPVT;
1641: x_return_status := FND_API.G_RET_STS_ERROR;
1642: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1643: ,p_data => x_msg_data);
1644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1645: ROLLBACK TO BSCSetTimeKpiPVT;

Line 1644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1640: ROLLBACK TO BSCSetTimeKpiPVT;
1641: x_return_status := FND_API.G_RET_STS_ERROR;
1642: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1643: ,p_data => x_msg_data);
1644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1645: ROLLBACK TO BSCSetTimeKpiPVT;
1646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1647: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1648: ,p_data => x_msg_data);

Line 1646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1642: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1643: ,p_data => x_msg_data);
1644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1645: ROLLBACK TO BSCSetTimeKpiPVT;
1646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1647: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1648: ,p_data => x_msg_data);
1649: WHEN OTHERS THEN
1650: ROLLBACK TO BSCSetTimeKpiPVT;

Line 1651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1647: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1648: ,p_data => x_msg_data);
1649: WHEN OTHERS THEN
1650: ROLLBACK TO BSCSetTimeKpiPVT;
1651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1652: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1653: ,p_data => x_msg_data);
1654:
1655: end SET_TIME_STAMP_KPI;

Line 1698: WHEN FND_API.G_EXC_ERROR THEN

1694: END LOOP;
1695: end if;
1696:
1697: EXCEPTION
1698: WHEN FND_API.G_EXC_ERROR THEN
1699: ROLLBACK TO BSCLockCreDimPVT;
1700: x_return_status := FND_API.G_RET_STS_ERROR;
1701: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1702: ,p_data => x_msg_data);

Line 1700: x_return_status := FND_API.G_RET_STS_ERROR;

1696:
1697: EXCEPTION
1698: WHEN FND_API.G_EXC_ERROR THEN
1699: ROLLBACK TO BSCLockCreDimPVT;
1700: x_return_status := FND_API.G_RET_STS_ERROR;
1701: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1702: ,p_data => x_msg_data);
1703: raise;
1704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1700: x_return_status := FND_API.G_RET_STS_ERROR;
1701: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1702: ,p_data => x_msg_data);
1703: raise;
1704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1705: ROLLBACK TO BSCLockCreDimPVT;
1706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1707: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1708: ,p_data => x_msg_data);

Line 1706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1702: ,p_data => x_msg_data);
1703: raise;
1704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1705: ROLLBACK TO BSCLockCreDimPVT;
1706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1707: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1708: ,p_data => x_msg_data);
1709: raise;
1710: WHEN OTHERS THEN

Line 1712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1708: ,p_data => x_msg_data);
1709: raise;
1710: WHEN OTHERS THEN
1711: ROLLBACK TO BSCLockCreDimPVT;
1712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1713: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1714: ,p_data => x_msg_data);
1715: raise;
1716: end LOCK_CREATE_DIMENSION;

Line 1874: WHEN FND_API.G_EXC_ERROR THEN

1870: end if;
1871: end if;
1872:
1873: EXCEPTION
1874: WHEN FND_API.G_EXC_ERROR THEN
1875: ROLLBACK TO BSCLockUpdDimPVT;
1876: x_return_status := FND_API.G_RET_STS_ERROR;
1877: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1878: ,p_data => x_msg_data);

Line 1876: x_return_status := FND_API.G_RET_STS_ERROR;

1872:
1873: EXCEPTION
1874: WHEN FND_API.G_EXC_ERROR THEN
1875: ROLLBACK TO BSCLockUpdDimPVT;
1876: x_return_status := FND_API.G_RET_STS_ERROR;
1877: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1878: ,p_data => x_msg_data);
1879: raise;
1880: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1880: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1876: x_return_status := FND_API.G_RET_STS_ERROR;
1877: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1878: ,p_data => x_msg_data);
1879: raise;
1880: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1881: ROLLBACK TO BSCLockUpdDimPVT;
1882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1883: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1884: ,p_data => x_msg_data);

Line 1882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1878: ,p_data => x_msg_data);
1879: raise;
1880: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1881: ROLLBACK TO BSCLockUpdDimPVT;
1882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1883: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1884: ,p_data => x_msg_data);
1885: raise;
1886: WHEN OTHERS THEN

Line 1888: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1884: ,p_data => x_msg_data);
1885: raise;
1886: WHEN OTHERS THEN
1887: ROLLBACK TO BSCLockUpdDimPVT;
1888: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1889: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1890: ,p_data => x_msg_data);
1891: raise;
1892:

Line 1962: WHEN FND_API.G_EXC_ERROR THEN

1958:
1959:
1960:
1961: EXCEPTION
1962: WHEN FND_API.G_EXC_ERROR THEN
1963: ROLLBACK TO BSCLockUpdDimInObjPVT;
1964: x_return_status := FND_API.G_RET_STS_ERROR;
1965: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1966: ,p_data => x_msg_data);

Line 1964: x_return_status := FND_API.G_RET_STS_ERROR;

1960:
1961: EXCEPTION
1962: WHEN FND_API.G_EXC_ERROR THEN
1963: ROLLBACK TO BSCLockUpdDimInObjPVT;
1964: x_return_status := FND_API.G_RET_STS_ERROR;
1965: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1966: ,p_data => x_msg_data);
1967: raise;
1968: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1968: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1964: x_return_status := FND_API.G_RET_STS_ERROR;
1965: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1966: ,p_data => x_msg_data);
1967: raise;
1968: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1969: ROLLBACK TO BSCLockUpdDimInObjPVT;
1970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1971: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1972: ,p_data => x_msg_data);

Line 1970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1966: ,p_data => x_msg_data);
1967: raise;
1968: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1969: ROLLBACK TO BSCLockUpdDimInObjPVT;
1970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1971: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1972: ,p_data => x_msg_data);
1973: raise;
1974: WHEN OTHERS THEN

Line 1976: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1972: ,p_data => x_msg_data);
1973: raise;
1974: WHEN OTHERS THEN
1975: ROLLBACK TO BSCLockUpdDimInObjPVT;
1976: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1977: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1978: ,p_data => x_msg_data);
1979: raise;
1980:

Line 2054: WHEN FND_API.G_EXC_ERROR THEN

2050: end loop;
2051: end if;
2052:
2053: EXCEPTION
2054: WHEN FND_API.G_EXC_ERROR THEN
2055: ROLLBACK TO BSCLockCreDimObjPVT;
2056: x_return_status := FND_API.G_RET_STS_ERROR;
2057: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
2058: ,p_data => x_msg_data);

Line 2056: x_return_status := FND_API.G_RET_STS_ERROR;

2052:
2053: EXCEPTION
2054: WHEN FND_API.G_EXC_ERROR THEN
2055: ROLLBACK TO BSCLockCreDimObjPVT;
2056: x_return_status := FND_API.G_RET_STS_ERROR;
2057: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
2058: ,p_data => x_msg_data);
2059: raise;
2060: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2060: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2056: x_return_status := FND_API.G_RET_STS_ERROR;
2057: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
2058: ,p_data => x_msg_data);
2059: raise;
2060: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2061: ROLLBACK TO BSCLockCreDimObjPVT;
2062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2063: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
2064: ,p_data => x_msg_data);

Line 2062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2058: ,p_data => x_msg_data);
2059: raise;
2060: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2061: ROLLBACK TO BSCLockCreDimObjPVT;
2062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2063: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
2064: ,p_data => x_msg_data);
2065: raise;
2066: WHEN OTHERS THEN

Line 2068: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2064: ,p_data => x_msg_data);
2065: raise;
2066: WHEN OTHERS THEN
2067: ROLLBACK TO BSCLockCreDimObjPVT;
2068: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2069: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
2070: ,p_data => x_msg_data);
2071: raise;
2072: End LOCK_CREATE_DIMENSION_OBJECT;

Line 2252: WHEN FND_API.G_EXC_ERROR THEN

2248: end if;
2249:
2250:
2251: EXCEPTION
2252: WHEN FND_API.G_EXC_ERROR THEN
2253: ROLLBACK TO BSCLockUpdDimObjPVT;
2254: x_return_status := FND_API.G_RET_STS_ERROR;
2255: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
2256: ,p_data => x_msg_data);

Line 2254: x_return_status := FND_API.G_RET_STS_ERROR;

2250:
2251: EXCEPTION
2252: WHEN FND_API.G_EXC_ERROR THEN
2253: ROLLBACK TO BSCLockUpdDimObjPVT;
2254: x_return_status := FND_API.G_RET_STS_ERROR;
2255: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
2256: ,p_data => x_msg_data);
2257: raise;
2258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2254: x_return_status := FND_API.G_RET_STS_ERROR;
2255: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
2256: ,p_data => x_msg_data);
2257: raise;
2258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2259: ROLLBACK TO BSCLockUpdDimObjPVT;
2260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2261: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
2262: ,p_data => x_msg_data);

Line 2260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2256: ,p_data => x_msg_data);
2257: raise;
2258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2259: ROLLBACK TO BSCLockUpdDimObjPVT;
2260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2261: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
2262: ,p_data => x_msg_data);
2263: raise;
2264: WHEN OTHERS THEN

Line 2266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2262: ,p_data => x_msg_data);
2263: raise;
2264: WHEN OTHERS THEN
2265: ROLLBACK TO BSCLockUpdDimObjPVT;
2266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2267: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
2268: ,p_data => x_msg_data);
2269: raise;
2270: end LOCK_UPDATE_DIMENSION_OBJECT;

Line 2470: WHEN FND_API.G_EXC_ERROR THEN

2466: END LOOP;
2467: end if;
2468:
2469: EXCEPTION
2470: WHEN FND_API.G_EXC_ERROR THEN
2471: ROLLBACK TO BSCLockUpdDimRelsPVT;
2472: x_return_status := FND_API.G_RET_STS_ERROR;
2473: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
2474: ,p_data => x_msg_data);

Line 2472: x_return_status := FND_API.G_RET_STS_ERROR;

2468:
2469: EXCEPTION
2470: WHEN FND_API.G_EXC_ERROR THEN
2471: ROLLBACK TO BSCLockUpdDimRelsPVT;
2472: x_return_status := FND_API.G_RET_STS_ERROR;
2473: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
2474: ,p_data => x_msg_data);
2475: raise;
2476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2472: x_return_status := FND_API.G_RET_STS_ERROR;
2473: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
2474: ,p_data => x_msg_data);
2475: raise;
2476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2477: ROLLBACK TO BSCLockUpdDimRelsPVT;
2478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2479: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
2480: ,p_data => x_msg_data);

Line 2478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2474: ,p_data => x_msg_data);
2475: raise;
2476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2477: ROLLBACK TO BSCLockUpdDimRelsPVT;
2478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2479: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
2480: ,p_data => x_msg_data);
2481: raise;
2482: WHEN OTHERS THEN

Line 2484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2480: ,p_data => x_msg_data);
2481: raise;
2482: WHEN OTHERS THEN
2483: ROLLBACK TO BSCLockUpdDimRelsPVT;
2484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2485: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
2486: ,p_data => x_msg_data);
2487: raise;
2488: end LOCK_UPDATE_RELATIONSHIPS;

Line 2546: WHEN FND_API.G_EXC_ERROR THEN

2542: ,x_msg_data => x_msg_data
2543: );
2544:
2545: EXCEPTION
2546: WHEN FND_API.G_EXC_ERROR THEN
2547: ROLLBACK TO BSCLockAsgnDimSetPVT;
2548: x_return_status := FND_API.G_RET_STS_ERROR;
2549: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
2550: ,p_data => x_msg_data);

Line 2548: x_return_status := FND_API.G_RET_STS_ERROR;

2544:
2545: EXCEPTION
2546: WHEN FND_API.G_EXC_ERROR THEN
2547: ROLLBACK TO BSCLockAsgnDimSetPVT;
2548: x_return_status := FND_API.G_RET_STS_ERROR;
2549: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
2550: ,p_data => x_msg_data);
2551: raise;
2552: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2552: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2548: x_return_status := FND_API.G_RET_STS_ERROR;
2549: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
2550: ,p_data => x_msg_data);
2551: raise;
2552: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2553: ROLLBACK TO BSCLockAsgnDimSetPVT;
2554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2555: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
2556: ,p_data => x_msg_data);

Line 2554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2550: ,p_data => x_msg_data);
2551: raise;
2552: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2553: ROLLBACK TO BSCLockAsgnDimSetPVT;
2554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2555: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
2556: ,p_data => x_msg_data);
2557: raise;
2558: WHEN OTHERS THEN

Line 2560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2556: ,p_data => x_msg_data);
2557: raise;
2558: WHEN OTHERS THEN
2559: ROLLBACK TO BSCLockAsgnDimSetPVT;
2560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2561: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
2562: ,p_data => x_msg_data);
2563: raise;
2564:

Line 2593: x_return_status := FND_API.G_RET_STS_SUCCESS;

2589: BEGIN
2590:
2591: SAVEPOINT bsclocktabpvt;
2592: FND_MSG_PUB.Initialize;
2593: x_return_status := FND_API.G_RET_STS_SUCCESS;
2594:
2595: l_sql := ' SELECT TAB_ID
2596: FROM BSC_TABS_B
2597: WHERE TAB_ID = :1

Line 2610: RAISE FND_API.G_EXC_ERROR;

2606: FND_MSG_PUB.Initialize;
2607: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
2608: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.GET_LOOKUP_VALUE('BSC_UI_IVIEWER', 'SCORECARD'), TRUE);
2609: FND_MSG_PUB.ADD;
2610: RAISE FND_API.G_EXC_ERROR;
2611: END IF;
2612:
2613: IF ( p_time_stamp IS NOT NULL) THEN
2614: l_last_update_date := get_tab_time_stamp

Line 2622: RAISE FND_API.G_EXC_ERROR;

2618: IF (p_time_stamp <> l_last_update_date) THEN
2619: FND_MSG_PUB.Initialize;
2620: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_SCORECARD');
2621: FND_MSG_PUB.ADD;
2622: RAISE FND_API.G_EXC_ERROR;
2623: END IF;
2624: END IF;
2625:
2626: IF (l_cursor%ISOPEN) THEN

Line 2631: WHEN FND_API.G_EXC_ERROR THEN

2627: CLOSE l_cursor;
2628: END IF;
2629:
2630: EXCEPTION
2631: WHEN FND_API.G_EXC_ERROR THEN
2632:
2633: IF (l_cursor%ISOPEN) THEN
2634: CLOSE l_cursor;
2635: END IF;

Line 2638: x_return_status := FND_API.G_RET_STS_ERROR;

2634: CLOSE l_cursor;
2635: END IF;
2636:
2637: ROLLBACK TO bsclocktabpvt;
2638: x_return_status := FND_API.G_RET_STS_ERROR;
2639: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
2640: ,p_count => x_msg_count
2641: ,p_data => x_msg_data);
2642: RAISE;

Line 2643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2639: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
2640: ,p_count => x_msg_count
2641: ,p_data => x_msg_data);
2642: RAISE;
2643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2644:
2645: IF (l_cursor%ISOPEN) THEN
2646: CLOSE l_cursor;
2647: END IF;

Line 2650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2646: CLOSE l_cursor;
2647: END IF;
2648:
2649: ROLLBACK TO bsclocktabpvt;
2650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2651: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
2652: ,p_count => x_msg_count
2653: ,p_data => x_msg_data);
2654: RAISE;

Line 2663: x_return_status := FND_API.G_RET_STS_ERROR;

2659: ROLLBACK TO bsclocktabpvt;
2660: IF (SQLCODE = -00054) THEN
2661: FND_MESSAGE.SET_NAME('BSC','BSC_MUSERS_LOCKED_TAB');
2662: FND_MSG_PUB.ADD;
2663: x_return_status := FND_API.G_RET_STS_ERROR;
2664: RAISE FND_API.G_EXC_ERROR;
2665: END IF;
2666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2667: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

Line 2664: RAISE FND_API.G_EXC_ERROR;

2660: IF (SQLCODE = -00054) THEN
2661: FND_MESSAGE.SET_NAME('BSC','BSC_MUSERS_LOCKED_TAB');
2662: FND_MSG_PUB.ADD;
2663: x_return_status := FND_API.G_RET_STS_ERROR;
2664: RAISE FND_API.G_EXC_ERROR;
2665: END IF;
2666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2667: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
2668: ,p_data => x_msg_data);

Line 2666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2662: FND_MSG_PUB.ADD;
2663: x_return_status := FND_API.G_RET_STS_ERROR;
2664: RAISE FND_API.G_EXC_ERROR;
2665: END IF;
2666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2667: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
2668: ,p_data => x_msg_data);
2669: RAISE;
2670: ROLLBACK TO bsclocktabpvt;

Line 2671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2667: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
2668: ,p_data => x_msg_data);
2669: RAISE;
2670: ROLLBACK TO bsclocktabpvt;
2671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2672: FND_MSG_PUB.Count_And_Get(p_encoded => 'F'
2673: ,p_count => x_msg_count
2674: ,p_data => x_msg_data);
2675: RAISE;

Line 2727: RAISE FND_API.G_EXC_ERROR;

2723: FND_MSG_PUB.ADD;
2724: FND_MSG_PUB.Count_And_Get(p_encoded => 'F'
2725: ,p_count => x_msg_count
2726: ,p_data => x_msg_data);
2727: RAISE FND_API.G_EXC_ERROR;
2728: END IF;
2729: CLOSE l_cursor;
2730:
2731: IF NOT p_time_stamp IS NULL THEN

Line 2745: RAISE FND_API.G_EXC_ERROR;

2741: FND_MSG_PUB.ADD;
2742: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
2743: ,p_count => x_msg_count
2744: ,p_data => x_msg_data);
2745: RAISE FND_API.G_EXC_ERROR;
2746: END IF;
2747: END IF;
2748:
2749: EXCEPTION

Line 2750: WHEN FND_API.G_EXC_ERROR THEN

2746: END IF;
2747: END IF;
2748:
2749: EXCEPTION
2750: WHEN FND_API.G_EXC_ERROR THEN
2751: ROLLBACK TO bsclocktabviewpvt;
2752: x_return_status := FND_API.G_RET_STS_ERROR;
2753: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
2754: ,p_count => x_msg_count

Line 2752: x_return_status := FND_API.G_RET_STS_ERROR;

2748:
2749: EXCEPTION
2750: WHEN FND_API.G_EXC_ERROR THEN
2751: ROLLBACK TO bsclocktabviewpvt;
2752: x_return_status := FND_API.G_RET_STS_ERROR;
2753: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
2754: ,p_count => x_msg_count
2755: ,p_data => x_msg_data);
2756: RAISE;

Line 2757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2753: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
2754: ,p_count => x_msg_count
2755: ,p_data => x_msg_data);
2756: RAISE;
2757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2758: ROLLBACK TO bsclocktabviewpvt;
2759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2760: FND_MSG_PUB.Count_And_Get(p_encoded => 'F'
2761: ,p_count => x_msg_count

Line 2759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2755: ,p_data => x_msg_data);
2756: RAISE;
2757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2758: ROLLBACK TO bsclocktabviewpvt;
2759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2760: FND_MSG_PUB.Count_And_Get(p_encoded => 'F'
2761: ,p_count => x_msg_count
2762: ,p_data => x_msg_data);
2763: RAISE;

Line 2766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2762: ,p_data => x_msg_data);
2763: RAISE;
2764: WHEN OTHERS THEN
2765: ROLLBACK TO bsclocktabviewpvt;
2766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2767: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
2768: ,p_count => x_msg_count
2769: ,p_data => x_msg_data);
2770: RAISE;

Line 2793: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

2789: BEGIN
2790: SAVEPOINT LockCalendarPVT;
2791: FND_MSG_PUB.Initialize;
2792:
2793: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
2794:
2795: l_Sql := ' SELECT CALENDAR_ID, LAST_UPDATE_DATE '
2796: ||' FROM BSC_SYS_CALENDARS_B '
2797: ||' WHERE CALENDAR_ID = :1 '

Line 2809: RAISE FND_API.G_EXC_ERROR;

2805: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
2806: l_Meaning := Bsc_Apps.Get_Lookup_Value('BSC_UI_COMMON', 'CALENDAR');
2807: FND_MESSAGE.SET_TOKEN('TYPE', l_Meaning, TRUE);
2808: FND_MSG_PUB.ADD;
2809: RAISE FND_API.G_EXC_ERROR;
2810: END IF;
2811:
2812: IF NOT p_Time_Stamp IS NULL THEN
2813: IF p_Time_Stamp <> TO_CHAR(l_Last_Update_Date, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT) THEN

Line 2817: x_Return_Status := FND_API.G_RET_STS_ERROR;

2813: IF p_Time_Stamp <> TO_CHAR(l_Last_Update_Date, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT) THEN
2814: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_CALENDAR');
2815: FND_MESSAGE.SET_TOKEN('CALENDAR', Get_Calendar_Name(p_Calendar_Id));
2816: FND_MSG_PUB.ADD;
2817: x_Return_Status := FND_API.G_RET_STS_ERROR;
2818: RAISE FND_API.G_EXC_ERROR;
2819: END IF;
2820: END IF;
2821:

Line 2818: RAISE FND_API.G_EXC_ERROR;

2814: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_CALENDAR');
2815: FND_MESSAGE.SET_TOKEN('CALENDAR', Get_Calendar_Name(p_Calendar_Id));
2816: FND_MSG_PUB.ADD;
2817: x_Return_Status := FND_API.G_RET_STS_ERROR;
2818: RAISE FND_API.G_EXC_ERROR;
2819: END IF;
2820: END IF;
2821:
2822: IF (l_Cursor%ISOPEN) THEN

Line 2827: WHEN FND_API.G_EXC_ERROR THEN

2823: CLOSE l_Cursor;
2824: END IF;
2825:
2826: EXCEPTION
2827: WHEN FND_API.G_EXC_ERROR THEN
2828: ROLLBACK TO LockCalendarPVT;
2829: IF (l_Cursor%ISOPEN) THEN
2830: CLOSE l_Cursor;
2831: END IF;

Line 2835: ( p_encoded => FND_API.G_FALSE

2831: END IF;
2832:
2833: IF (x_msg_data IS NULL) THEN
2834: FND_MSG_PUB.Count_And_Get
2835: ( p_encoded => FND_API.G_FALSE
2836: , p_count => x_msg_count
2837: , p_data => x_msg_data
2838: );
2839: END IF;

Line 2840: x_Return_Status := FND_API.G_RET_STS_ERROR;

2836: , p_count => x_msg_count
2837: , p_data => x_msg_data
2838: );
2839: END IF;
2840: x_Return_Status := FND_API.G_RET_STS_ERROR;
2841: RAISE;
2842: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2843: ROLLBACK TO LockCalendarPVT;
2844: IF (l_Cursor%ISOPEN) THEN

Line 2842: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2838: );
2839: END IF;
2840: x_Return_Status := FND_API.G_RET_STS_ERROR;
2841: RAISE;
2842: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2843: ROLLBACK TO LockCalendarPVT;
2844: IF (l_Cursor%ISOPEN) THEN
2845: CLOSE l_Cursor;
2846: END IF;

Line 2849: ( p_encoded => FND_API.G_FALSE

2845: CLOSE l_Cursor;
2846: END IF;
2847: IF (x_msg_data IS NULL) THEN
2848: FND_MSG_PUB.Count_And_Get
2849: ( p_encoded => FND_API.G_FALSE
2850: , p_count => x_msg_count
2851: , p_data => x_msg_data
2852: );
2853: END IF;

Line 2854: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

2850: , p_count => x_msg_count
2851: , p_data => x_msg_data
2852: );
2853: END IF;
2854: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
2855: RAISE;
2856: WHEN NO_DATA_FOUND THEN
2857: ROLLBACK TO LockCalendarPVT;
2858: IF (l_Cursor%ISOPEN) THEN

Line 2861: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

2857: ROLLBACK TO LockCalendarPVT;
2858: IF (l_Cursor%ISOPEN) THEN
2859: CLOSE l_Cursor;
2860: END IF;
2861: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
2862: IF (x_msg_data IS NOT NULL) THEN
2863: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PVT.Lock_Calendar ';
2864: ELSE
2865: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PVT.Lock_Calendar ';

Line 2873: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

2869: ROLLBACK TO LockCalendarPVT;
2870: IF (l_Cursor%ISOPEN) THEN
2871: CLOSE l_Cursor;
2872: END IF;
2873: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
2874: IF (SQLCODE = -00054) THEN
2875: FND_MSG_PUB.Initialize;
2876: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_LOCKED_CALENDAR');
2877: FND_MESSAGE.SET_TOKEN('CALENDAR', Get_Calendar_Name(p_Calendar_Id));

Line 2879: x_Return_Status := FND_API.G_RET_STS_ERROR;

2875: FND_MSG_PUB.Initialize;
2876: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_LOCKED_CALENDAR');
2877: FND_MESSAGE.SET_TOKEN('CALENDAR', Get_Calendar_Name(p_Calendar_Id));
2878: FND_MSG_PUB.ADD;
2879: x_Return_Status := FND_API.G_RET_STS_ERROR;
2880:
2881: FND_MSG_PUB.Count_And_Get
2882: ( p_encoded => FND_API.G_FALSE
2883: , p_count => x_msg_count

Line 2882: ( p_encoded => FND_API.G_FALSE

2878: FND_MSG_PUB.ADD;
2879: x_Return_Status := FND_API.G_RET_STS_ERROR;
2880:
2881: FND_MSG_PUB.Count_And_Get
2882: ( p_encoded => FND_API.G_FALSE
2883: , p_count => x_msg_count
2884: , p_data => x_msg_data
2885: );
2886: RAISE FND_API.G_EXC_ERROR;

Line 2886: RAISE FND_API.G_EXC_ERROR;

2882: ( p_encoded => FND_API.G_FALSE
2883: , p_count => x_msg_count
2884: , p_data => x_msg_data
2885: );
2886: RAISE FND_API.G_EXC_ERROR;
2887: ELSE
2888: IF (x_msg_data IS NOT NULL) THEN
2889: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PVT.Lock_Calendar ';
2890: ELSE

Line 2914: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

2910: BEGIN
2911: SAVEPOINT LockPeriodicityPVT;
2912: FND_MSG_PUB.Initialize;
2913:
2914: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
2915:
2916: l_Sql := ' SELECT PERIODICITY_ID, LAST_UPDATE_DATE '
2917: ||' FROM BSC_SYS_PERIODICITIES_TL '
2918: ||' WHERE PERIODICITY_ID = :1 '

Line 2930: RAISE FND_API.G_EXC_ERROR;

2926: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
2927: l_Meaning := Bsc_Apps.Get_Lookup_Value('BSC_UI_COMMON', 'PERIODICITY');
2928: FND_MESSAGE.SET_TOKEN('TYPE', l_Meaning, TRUE);
2929: FND_MSG_PUB.ADD;
2930: RAISE FND_API.G_EXC_ERROR;
2931: END IF;
2932:
2933: IF NOT p_Time_Stamp IS NULL THEN
2934: IF p_Time_Stamp <> TO_CHAR(l_Last_Update_Date, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT) THEN

Line 2938: x_Return_Status := FND_API.G_RET_STS_ERROR;

2934: IF p_Time_Stamp <> TO_CHAR(l_Last_Update_Date, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT) THEN
2935: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_PERIODICITY');
2936: FND_MESSAGE.SET_TOKEN('PERIODICITY', Get_Periodicity_Name(p_Periodicity_Id));
2937: FND_MSG_PUB.ADD;
2938: x_Return_Status := FND_API.G_RET_STS_ERROR;
2939: RAISE FND_API.G_EXC_ERROR;
2940: END IF;
2941: END IF;
2942:

Line 2939: RAISE FND_API.G_EXC_ERROR;

2935: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_PERIODICITY');
2936: FND_MESSAGE.SET_TOKEN('PERIODICITY', Get_Periodicity_Name(p_Periodicity_Id));
2937: FND_MSG_PUB.ADD;
2938: x_Return_Status := FND_API.G_RET_STS_ERROR;
2939: RAISE FND_API.G_EXC_ERROR;
2940: END IF;
2941: END IF;
2942:
2943: IF (l_Cursor%ISOPEN) THEN

Line 2947: WHEN FND_API.G_EXC_ERROR THEN

2943: IF (l_Cursor%ISOPEN) THEN
2944: CLOSE l_Cursor;
2945: END IF;
2946: EXCEPTION
2947: WHEN FND_API.G_EXC_ERROR THEN
2948: ROLLBACK TO LockPeriodicityPVT;
2949: IF (l_Cursor%ISOPEN) THEN
2950: CLOSE l_Cursor;
2951: END IF;

Line 2955: ( p_encoded => FND_API.G_FALSE

2951: END IF;
2952:
2953: IF (x_msg_data IS NULL) THEN
2954: FND_MSG_PUB.Count_And_Get
2955: ( p_encoded => FND_API.G_FALSE
2956: , p_count => x_msg_count
2957: , p_data => x_msg_data
2958: );
2959: END IF;

Line 2960: x_Return_Status := FND_API.G_RET_STS_ERROR;

2956: , p_count => x_msg_count
2957: , p_data => x_msg_data
2958: );
2959: END IF;
2960: x_Return_Status := FND_API.G_RET_STS_ERROR;
2961: RAISE;
2962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2963: ROLLBACK TO LockPeriodicityPVT;
2964: IF (l_Cursor%ISOPEN) THEN

Line 2962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2958: );
2959: END IF;
2960: x_Return_Status := FND_API.G_RET_STS_ERROR;
2961: RAISE;
2962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2963: ROLLBACK TO LockPeriodicityPVT;
2964: IF (l_Cursor%ISOPEN) THEN
2965: CLOSE l_Cursor;
2966: END IF;

Line 2969: ( p_encoded => FND_API.G_FALSE

2965: CLOSE l_Cursor;
2966: END IF;
2967: IF (x_msg_data IS NULL) THEN
2968: FND_MSG_PUB.Count_And_Get
2969: ( p_encoded => FND_API.G_FALSE
2970: , p_count => x_msg_count
2971: , p_data => x_msg_data
2972: );
2973: END IF;

Line 2974: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

2970: , p_count => x_msg_count
2971: , p_data => x_msg_data
2972: );
2973: END IF;
2974: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
2975: RAISE;
2976: WHEN NO_DATA_FOUND THEN
2977: ROLLBACK TO LockPeriodicityPVT;
2978: IF (l_Cursor%ISOPEN) THEN

Line 2981: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

2977: ROLLBACK TO LockPeriodicityPVT;
2978: IF (l_Cursor%ISOPEN) THEN
2979: CLOSE l_Cursor;
2980: END IF;
2981: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
2982: IF (x_msg_data IS NOT NULL) THEN
2983: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PVT.Lock_Periodicity ';
2984: ELSE
2985: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PVT.Lock_Periodicity ';

Line 2996: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

2992: END IF;
2993: IF (l_Cursor%ISOPEN) THEN
2994: CLOSE l_Cursor;
2995: END IF;
2996: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
2997: IF (SQLCODE = -00054) THEN
2998: FND_MSG_PUB.Initialize;
2999: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_LOCKED_PERIODICITY');
3000: FND_MESSAGE.SET_TOKEN('PERIODICITY', Get_Periodicity_Name(p_Periodicity_Id));

Line 3002: x_Return_Status := FND_API.G_RET_STS_ERROR;

2998: FND_MSG_PUB.Initialize;
2999: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_LOCKED_PERIODICITY');
3000: FND_MESSAGE.SET_TOKEN('PERIODICITY', Get_Periodicity_Name(p_Periodicity_Id));
3001: FND_MSG_PUB.ADD;
3002: x_Return_Status := FND_API.G_RET_STS_ERROR;
3003:
3004: FND_MSG_PUB.Count_And_Get
3005: ( p_encoded => FND_API.G_FALSE
3006: , p_count => x_msg_count

Line 3005: ( p_encoded => FND_API.G_FALSE

3001: FND_MSG_PUB.ADD;
3002: x_Return_Status := FND_API.G_RET_STS_ERROR;
3003:
3004: FND_MSG_PUB.Count_And_Get
3005: ( p_encoded => FND_API.G_FALSE
3006: , p_count => x_msg_count
3007: , p_data => x_msg_data
3008: );
3009: RAISE FND_API.G_EXC_ERROR;

Line 3009: RAISE FND_API.G_EXC_ERROR;

3005: ( p_encoded => FND_API.G_FALSE
3006: , p_count => x_msg_count
3007: , p_data => x_msg_data
3008: );
3009: RAISE FND_API.G_EXC_ERROR;
3010: ELSE
3011: IF (x_msg_data IS NOT NULL) THEN
3012: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PVT.Lock_Periodicity ';
3013: ELSE