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_MSG_PUB

Line 153: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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

Line 158: 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;
162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 163: 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;
167:

Line 192: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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

Line 197: 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;
201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 202: 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;
206: /*------------------------------------------------------------------------------------------

Line 232: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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

Line 237: 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;
241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 242: 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;
246: /*------------------------------------------------------------------------------------------

Line 271: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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

Line 276: 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;
280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 281: 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;
285: /*------------------------------------------------------------------------------------------

Line 329: FND_MSG_PUB.Initialize;

325: fetch l_cursor into l_object_id, l_last_update_date;
326: if (l_cursor%notfound) then
327: --dbms_output.put_line(' p_dataset_id = ' || p_dataset_id || ' Deleted by other user ');
328: close l_cursor;
329: FND_MSG_PUB.Initialize;
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;

Line 333: FND_MSG_PUB.ADD;

329: FND_MSG_PUB.Initialize;
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;

Line 335: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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;
339: if not p_time_stamp is null then

Line 342: FND_MSG_PUB.Initialize;

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 ');
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;

Line 345: FND_MSG_PUB.ADD;

341: --dbms_output.put_line(' p_dataset_id = ' || p_dataset_id || ' updated by other user ');
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;

Line 347: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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;
351: end if;

Line 398: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
402: ROLLBACK TO BSCLockDataSetPVT;

Line 404: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
408: ROLLBACK TO BSCLockDataSetPVT;

Line 411: FND_MSG_PUB.Initialize;

407: WHEN OTHERS THEN
408: ROLLBACK TO BSCLockDataSetPVT;
409: if (SQLCODE = -00054) then
410: --dbms_output.put_line(' p_dataset_id = ' || p_dataset_id || ' locked by other user ');
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;

Line 414: FND_MSG_PUB.ADD;

410: --dbms_output.put_line(' p_dataset_id = ' || p_dataset_id || ' locked by other user ');
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;

Line 416: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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

Line 421: 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;
425:

Line 458: FND_MSG_PUB.Initialize;

454: fetch l_cursor into l_object_id, l_last_update_date;
455: if (l_cursor%notfound) then
456: close l_cursor;
457: --dbms_output.put_line(' p_measure_id = ' || p_measure_id || ' deleted by other user ');
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;

Line 461: FND_MSG_PUB.ADD;

457: --dbms_output.put_line(' p_measure_id = ' || p_measure_id || ' deleted by other user ');
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;

Line 463: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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

Line 471: FND_MSG_PUB.Initialize;

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
470: --dbms_output.put_line(' p_measure_id = ' || p_measure_id || ' updated by other user ');
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;

Line 474: FND_MSG_PUB.ADD;

470: --dbms_output.put_line(' p_measure_id = ' || p_measure_id || ' updated by other user ');
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;

Line 476: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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;
480: end if;

Line 488: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
492: ROLLBACK TO BSCLockDataSrcPVT;

Line 494: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
498: ROLLBACK TO BSCLockDataSrcPVT;

Line 501: FND_MSG_PUB.Initialize;

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 ');
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;

Line 504: FND_MSG_PUB.ADD;

500: --dbms_output.put_line(' p_measure_id = ' || p_measure_id || ' locked by other user ');
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;

Line 506: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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

Line 511: 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;
515: /*-------------------------------------------------------------------------------------------------------------------

Line 652: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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

Line 690: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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

Line 750: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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;
754: /*----------------------------------------------------------------------------

Line 789: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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

Line 853: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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));
857:

Line 915: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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));
919:

Line 954: FND_MSG_PUB.Initialize;

950: fetch l_cursor into l_object_id, l_last_update_date;
951: if (l_cursor%notfound) then
952: close l_cursor;
953: --dbms_output.put_line('Dimension Level Id = ' || p_dim_level_id || ' Deleted by other user ');
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;

Line 957: FND_MSG_PUB.ADD;

953: --dbms_output.put_line('Dimension Level Id = ' || p_dim_level_id || ' Deleted by other user ');
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;

Line 959: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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

Line 967: FND_MSG_PUB.Initialize;

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
966: --dbms_output.put_line('Dimension Level Id = ' || p_dim_level_id || ' updated by other user ');
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;

Line 970: FND_MSG_PUB.ADD;

966: --dbms_output.put_line('Dimension Level Id = ' || p_dim_level_id || ' updated by other user ');
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;

Line 972: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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;
976: end if;

Line 984: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
988: ROLLBACK TO BSCLockDimObjPVT;

Line 990: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
994: ROLLBACK TO BSCLockDimObjPVT;

Line 997: FND_MSG_PUB.Initialize;

993: WHEN OTHERS THEN
994: ROLLBACK TO BSCLockDimObjPVT;
995: if (SQLCODE = -00054) then
996: --dbms_output.put_line('Dimension Level Id = ' || p_dim_level_id || ' locked by other user ');
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;

Line 1000: FND_MSG_PUB.ADD;

996: --dbms_output.put_line('Dimension Level Id = ' || p_dim_level_id || ' locked by other user ');
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;

Line 1002: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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

Line 1007: 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:
1011: end LOCK_DIM_LEVEL;

Line 1050: FND_MSG_PUB.Initialize;

1046:
1047: if (l_cursor%notfound) then
1048: close l_cursor;
1049: --dbms_output.put_line('Dimension Group Id = ' || p_dim_group_id || ' Deleted by other user ');
1050: FND_MSG_PUB.Initialize;
1051: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETED_DIM_GROUP');
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

Line 1053: FND_MSG_PUB.ADD;

1049: --dbms_output.put_line('Dimension Group Id = ' || p_dim_group_id || ' Deleted by other user ');
1050: FND_MSG_PUB.Initialize;
1051: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETED_DIM_GROUP');
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;

Line 1054: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

1050: FND_MSG_PUB.Initialize;
1051: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETED_DIM_GROUP');
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

Line 1061: FND_MSG_PUB.Initialize;

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 ');
1061: FND_MSG_PUB.Initialize;
1062: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_DIM_GROUP');
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

Line 1064: FND_MSG_PUB.ADD;

1060: --dbms_output.put_line('Dimension Group Id = ' || p_dim_group_id || ' updated by other user ');
1061: FND_MSG_PUB.Initialize;
1062: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_DIM_GROUP');
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;

Line 1065: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

1061: FND_MSG_PUB.Initialize;
1062: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_DIM_GROUP');
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;

Line 1076: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
1080: ROLLBACK TO BSCLockDimPVT;

Line 1082: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
1086: ROLLBACK TO BSCLockDimPVT;

Line 1089: FND_MSG_PUB.Initialize;

1085: WHEN OTHERS THEN
1086: ROLLBACK TO BSCLockDimPVT;
1087: if (SQLCODE = -00054) then
1088: --dbms_output.put_line('Dimension Group Id = ' || p_dim_group_id || ' locked by other user ');
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;

Line 1092: FND_MSG_PUB.ADD;

1088: --dbms_output.put_line('Dimension Group Id = ' || p_dim_group_id || ' locked by other user ');
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;

Line 1094: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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:
1098: end if;

Line 1101: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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:
1105: end LOCK_DIM_GROUP;

Line 1144: FND_MSG_PUB.Initialize;

1140: fetch l_cursor into l_kpi_id, l_dim_set_id, l_last_update_date;
1141: if (l_cursor%notfound) then
1142: close l_cursor;
1143: --dbms_output.put_line('Kpi = ' || p_kpi_id || ' Dimension Set Id = ' || p_dim_set_id || ' Deleted by other user ');
1144: FND_MSG_PUB.Initialize;
1145: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETED_DIM_SET');
1146: FND_MESSAGE.SET_TOKEN('DIM_SET', nvl(get_Dim_Set_Name(p_kpi_Id, p_dim_set_id), p_dim_set_id )); -- Fixed Bug#3047483
1147: FND_MESSAGE.SET_TOKEN('KPI', nvl(get_KPI_Name(p_kpi_Id),p_kpi_Id)); -- Fixed Bug#3047483
1148: FND_MSG_PUB.ADD;

Line 1148: FND_MSG_PUB.ADD;

1144: FND_MSG_PUB.Initialize;
1145: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETED_DIM_SET');
1146: FND_MESSAGE.SET_TOKEN('DIM_SET', nvl(get_Dim_Set_Name(p_kpi_Id, p_dim_set_id), p_dim_set_id )); -- Fixed Bug#3047483
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;

Line 1149: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

1145: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETED_DIM_SET');
1146: FND_MESSAGE.SET_TOKEN('DIM_SET', nvl(get_Dim_Set_Name(p_kpi_Id, p_dim_set_id), p_dim_set_id )); -- Fixed Bug#3047483
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

Line 1156: FND_MSG_PUB.Initialize;

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 ');
1156: FND_MSG_PUB.Initialize;
1157: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_DIM_SET');
1158: FND_MESSAGE.SET_TOKEN('DIM_SET', get_Dim_Set_Name(p_kpi_Id, p_dim_set_id)); -- Fixed Bug#3047483
1159: FND_MESSAGE.SET_TOKEN('KPI', get_KPI_Name(p_kpi_Id)); -- Fixed Bug#3047483
1160: FND_MSG_PUB.ADD;

Line 1160: FND_MSG_PUB.ADD;

1156: FND_MSG_PUB.Initialize;
1157: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_DIM_SET');
1158: FND_MESSAGE.SET_TOKEN('DIM_SET', get_Dim_Set_Name(p_kpi_Id, p_dim_set_id)); -- Fixed Bug#3047483
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;

Line 1161: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

1157: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_DIM_SET');
1158: FND_MESSAGE.SET_TOKEN('DIM_SET', get_Dim_Set_Name(p_kpi_Id, p_dim_set_id)); -- Fixed Bug#3047483
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;

Line 1172: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
1176: ROLLBACK TO BSCLockDimSetPVT;

Line 1178: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
1182: ROLLBACK TO BSCLockDimSetPVT;

Line 1185: FND_MSG_PUB.Initialize;

1181: WHEN OTHERS THEN
1182: ROLLBACK TO BSCLockDimSetPVT;
1183: if (SQLCODE = -00054) then
1184: --dbms_output.put_line('Kpi = ' || p_kpi_id || ' Dimension Set Id = ' || p_dim_set_id || ' locked by other user ');
1185: FND_MSG_PUB.Initialize;
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;

Line 1189: FND_MSG_PUB.ADD;

1185: FND_MSG_PUB.Initialize;
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;

Line 1191: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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

Line 1196: 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:
1200: end LOCK_DIM_SET;

Line 1239: FND_MSG_PUB.Initialize;

1235:
1236: if (l_cursor%notfound) then
1237: close l_cursor;
1238: --dbms_output.put_line('Kpi = ' || p_kpi_id || ' Deleted by other user ');
1239: FND_MSG_PUB.Initialize;
1240: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETED_KPI_1');
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

Line 1242: FND_MSG_PUB.ADD;

1238: --dbms_output.put_line('Kpi = ' || p_kpi_id || ' Deleted by other user ');
1239: FND_MSG_PUB.Initialize;
1240: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETED_KPI_1');
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;

Line 1243: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

1239: FND_MSG_PUB.Initialize;
1240: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETED_KPI_1');
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;

Line 1253: FND_MSG_PUB.Initialize;

1249: if not p_time_stamp is null then
1250: l_last_update_date := get_time_stamp_kpi( p_kpi_Id);
1251: if p_time_stamp <> l_last_update_date then
1252: --dbms_output.put_line('Kpi = ' || p_kpi_id || ' updated by other user ');
1253: FND_MSG_PUB.Initialize;
1254: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_KPI_1');
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

Line 1256: FND_MSG_PUB.ADD;

1252: --dbms_output.put_line('Kpi = ' || p_kpi_id || ' updated by other user ');
1253: FND_MSG_PUB.Initialize;
1254: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_KPI_1');
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;

Line 1257: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

1253: FND_MSG_PUB.Initialize;
1254: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_KPI_1');
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;

Line 1281: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
1285: ROLLBACK TO BSCLockKpiPVT;

Line 1287: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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:
1291: raise;

Line 1296: FND_MSG_PUB.Initialize;

1292: WHEN OTHERS THEN
1293: ROLLBACK TO BSCLockKpiPVT;
1294: if (SQLCODE = -00054) then
1295: --dbms_output.put_line('Kpi = ' || p_kpi_id || ' locked by other user ');
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;

Line 1299: FND_MSG_PUB.ADD;

1295: --dbms_output.put_line('Kpi = ' || p_kpi_id || ' locked by other user ');
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;

Line 1301: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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

Line 1306: 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:
1310: raise;

Line 1516: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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

Line 1521: 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
1525: ROLLBACK TO BSCSetTimeDimObjPVT;

Line 1527: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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;
1531: /*------------------------------------------------------------------------------------------

Line 1557: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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

Line 1562: 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;
1566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1567: 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;
1571: /*------------------------------------------------------------------------------------------

Line 1602: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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

Line 1607: 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;
1611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1612: 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;
1616: /*------------------------------------------------------------------------------------------

Line 1642: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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

Line 1647: 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;
1651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1652: 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;
1656:

Line 1701: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
1705: ROLLBACK TO BSCLockCreDimPVT;

Line 1707: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
1711: ROLLBACK TO BSCLockCreDimPVT;

Line 1713: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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;
1717: /*------------------------------------------------------------------------------------------

Line 1877: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
1881: ROLLBACK TO BSCLockUpdDimPVT;

Line 1883: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
1887: ROLLBACK TO BSCLockUpdDimPVT;

Line 1889: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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:
1893: end LOCK_UPDATE_DIMENSION;

Line 1965: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
1969: ROLLBACK TO BSCLockUpdDimInObjPVT;

Line 1971: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
1975: ROLLBACK TO BSCLockUpdDimInObjPVT;

Line 1977: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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:
1981: End LOCK_UPDATE_DIM_OBJ_IN_DIM;

Line 2057: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
2061: ROLLBACK TO BSCLockCreDimObjPVT;

Line 2063: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
2067: ROLLBACK TO BSCLockCreDimObjPVT;

Line 2069: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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

Line 2255: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
2259: ROLLBACK TO BSCLockUpdDimObjPVT;

Line 2261: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
2265: ROLLBACK TO BSCLockUpdDimObjPVT;

Line 2267: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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;
2271: /*------------------------------------------------------------------------------------------

Line 2473: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
2477: ROLLBACK TO BSCLockUpdDimRelsPVT;

Line 2479: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
2483: ROLLBACK TO BSCLockUpdDimRelsPVT;

Line 2485: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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;
2489: /*------------------------------------------------------------------------------------------

Line 2549: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
2553: ROLLBACK TO BSCLockAsgnDimSetPVT;

Line 2555: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
2559: ROLLBACK TO BSCLockAsgnDimSetPVT;

Line 2561: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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:
2565: end LOCK_ASSIGN_DIM_SET;

Line 2592: FND_MSG_PUB.Initialize;

2588:
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

Line 2606: FND_MSG_PUB.Initialize;

2602: FETCH l_cursor INTO l_temp;
2603:
2604: IF(l_cursor%NOTFOUND) THEN
2605: CLOSE l_cursor;
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;

Line 2609: FND_MSG_PUB.ADD;

2605: CLOSE l_cursor;
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

Line 2619: FND_MSG_PUB.Initialize;

2615: ( p_tab_id => p_tab_id
2616: );
2617:
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;

Line 2621: FND_MSG_PUB.ADD;

2617:
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:

Line 2639: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'

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;
2643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2651: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'

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;
2655: WHEN OTHERS THEN

Line 2662: FND_MSG_PUB.ADD;

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

Line 2667: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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

Line 2672: FND_MSG_PUB.Count_And_Get(p_encoded => 'F'

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;
2676: END LOCK_TAB;

Line 2720: FND_MSG_PUB.Initialize;

2716:
2717: IF (l_cursor%notfound) THEN
2718: CLOSE l_cursor;
2719: --DBMS_OUTPUT.PUT_LINE('Kpi = ' || p_kpi_id || ' Deleted by other user ');
2720: FND_MSG_PUB.Initialize;
2721: --FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETED_KPI_1');
2722: FND_MESSAGE.SET_NAME('BSC','The current tab view has been deleted by another user');
2723: FND_MSG_PUB.ADD;
2724: FND_MSG_PUB.Count_And_Get(p_encoded => 'F'

Line 2723: FND_MSG_PUB.ADD;

2719: --DBMS_OUTPUT.PUT_LINE('Kpi = ' || p_kpi_id || ' Deleted by other user ');
2720: FND_MSG_PUB.Initialize;
2721: --FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETED_KPI_1');
2722: FND_MESSAGE.SET_NAME('BSC','The current tab view has been deleted by another user');
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;

Line 2724: FND_MSG_PUB.Count_And_Get(p_encoded => 'F'

2720: FND_MSG_PUB.Initialize;
2721: --FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETED_KPI_1');
2722: FND_MESSAGE.SET_NAME('BSC','The current tab view has been deleted by another user');
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;

Line 2738: FND_MSG_PUB.Initialize;

2734: ,p_tab_view_id=> p_tab_view_id
2735: );
2736: IF p_time_stamp <> l_last_update_date THEN
2737: --dbms_output.put_line('Kpi = ' || p_kpi_id || ' updated by other user ');
2738: FND_MSG_PUB.Initialize;
2739: FND_MESSAGE.SET_NAME('BSC','The Current view has been modified by another user');
2740: --FND_MESSAGE.SET_TOKEN('KPI', get_TabView_Name(p_tab_id,p_tab_view_id);
2741: FND_MSG_PUB.ADD;
2742: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'

Line 2741: FND_MSG_PUB.ADD;

2737: --dbms_output.put_line('Kpi = ' || p_kpi_id || ' updated by other user ');
2738: FND_MSG_PUB.Initialize;
2739: FND_MESSAGE.SET_NAME('BSC','The Current view has been modified by another user');
2740: --FND_MESSAGE.SET_TOKEN('KPI', get_TabView_Name(p_tab_id,p_tab_view_id);
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;

Line 2742: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'

2738: FND_MSG_PUB.Initialize;
2739: FND_MESSAGE.SET_NAME('BSC','The Current view has been modified by another user');
2740: --FND_MESSAGE.SET_TOKEN('KPI', get_TabView_Name(p_tab_id,p_tab_view_id);
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;

Line 2753: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'

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;
2757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2760: FND_MSG_PUB.Count_And_Get(p_encoded => 'F'

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;
2764: WHEN OTHERS THEN

Line 2767: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'

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

Line 2791: FND_MSG_PUB.Initialize;

2787: l_Meaning BSC_LOOKUPS.MEANING%TYPE;
2788:
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 '

Line 2808: FND_MSG_PUB.ADD;

2804: CLOSE l_Cursor;
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

Line 2816: FND_MSG_PUB.ADD;

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

Line 2834: FND_MSG_PUB.Count_And_Get

2830: CLOSE l_Cursor;
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: );

Line 2848: FND_MSG_PUB.Count_And_Get

2844: IF (l_Cursor%ISOPEN) THEN
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: );

Line 2875: FND_MSG_PUB.Initialize;

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));
2878: FND_MSG_PUB.ADD;
2879: x_Return_Status := FND_API.G_RET_STS_ERROR;

Line 2878: FND_MSG_PUB.ADD;

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));
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

Line 2881: FND_MSG_PUB.Count_And_Get

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
2884: , p_data => x_msg_data
2885: );

Line 2912: FND_MSG_PUB.Initialize;

2908: l_Meaning BSC_LOOKUPS.MEANING%TYPE;
2909:
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 '

Line 2929: FND_MSG_PUB.ADD;

2925: CLOSE l_Cursor;
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

Line 2937: FND_MSG_PUB.ADD;

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

Line 2954: FND_MSG_PUB.Count_And_Get

2950: CLOSE l_Cursor;
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: );

Line 2968: FND_MSG_PUB.Count_And_Get

2964: IF (l_Cursor%ISOPEN) THEN
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: );

Line 2998: FND_MSG_PUB.Initialize;

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));
3001: FND_MSG_PUB.ADD;
3002: x_Return_Status := FND_API.G_RET_STS_ERROR;

Line 3001: FND_MSG_PUB.ADD;

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));
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

Line 3004: FND_MSG_PUB.Count_And_Get

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
3007: , p_data => x_msg_data
3008: );