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

Line 90: p_commit IN varchar2 := FND_API.G_FALSE

86: --: Data Set API.
87: --: This procedure is part of the Data Set API.
88:
89: procedure Create_Measures(
90: p_commit IN varchar2 := FND_API.G_FALSE
91: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
92: ,x_return_status OUT NOCOPY varchar2
93: ,x_msg_count OUT NOCOPY number
94: ,x_msg_data OUT NOCOPY varchar2

Line 142: RAISE FND_API.G_EXC_ERROR;

138: if (l_count_mescol > 0) then
139: FND_MESSAGE.SET_NAME('BSC','BSC_MEASURE_SOURCE_NAME');
140: FND_MESSAGE.SET_TOKEN('MEASURE', p_Dataset_Rec.Bsc_Dataset_Name);
141: FND_MSG_PUB.ADD;
142: RAISE FND_API.G_EXC_ERROR;
143: end if;
144:
145:
146: -- Insert pertaining values into table bsc_sys_measures.

Line 207: if (p_commit = FND_API.G_TRUE) then

203: ,p_Dataset_Rec.Bsc_Measure_Projection_Id
204: ,p_Dataset_Rec.Bsc_Measure_Type);
205: */
206:
207: if (p_commit = FND_API.G_TRUE) then
208: commit;
209: end if;
210:
211: else

Line 215: RAISE FND_API.G_EXC_ERROR;

211: else
212: FND_MESSAGE.SET_NAME('BSC','BSC_MEAS_ID_EXISTS');
213: FND_MESSAGE.SET_TOKEN('BSC_MEAS', l_Dataset_Rec.Bsc_Measure_Id);
214: FND_MSG_PUB.ADD;
215: RAISE FND_API.G_EXC_ERROR;
216: end if;
217:
218:
219: EXCEPTION

Line 220: WHEN FND_API.G_EXC_ERROR THEN

216: end if;
217:
218:
219: EXCEPTION
220: WHEN FND_API.G_EXC_ERROR THEN
221: x_return_status := FND_API.G_RET_STS_ERROR;
222: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
223: ,p_data => x_msg_data);
224: raise;

Line 221: x_return_status := FND_API.G_RET_STS_ERROR;

217:
218:
219: EXCEPTION
220: WHEN FND_API.G_EXC_ERROR THEN
221: x_return_status := FND_API.G_RET_STS_ERROR;
222: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
223: ,p_data => x_msg_data);
224: raise;
225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

221: x_return_status := FND_API.G_RET_STS_ERROR;
222: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
223: ,p_data => x_msg_data);
224: raise;
225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
227: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
228: ,p_data => x_msg_data);
229: raise;

Line 226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

222: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
223: ,p_data => x_msg_data);
224: raise;
225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
227: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
228: ,p_data => x_msg_data);
229: raise;
230: WHEN NO_DATA_FOUND THEN

Line 231: x_return_status := FND_API.G_RET_STS_ERROR;

227: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
228: ,p_data => x_msg_data);
229: raise;
230: WHEN NO_DATA_FOUND THEN
231: x_return_status := FND_API.G_RET_STS_ERROR;
232: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
233: ,p_data => x_msg_data);
234: raise;
235: WHEN OTHERS THEN

Line 241: RAISE FND_API.G_EXC_ERROR;

237: if (SQLCODE = -01400) then
238: FND_MESSAGE.SET_NAME('BSC','BSC_TABLE_NULL_VALUE');
239: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', g_db_object);
240: FND_MSG_PUB.ADD;
241: RAISE FND_API.G_EXC_ERROR;
242: end if;
243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
244: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
245: ,p_data => x_msg_data);

Line 243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

239: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', g_db_object);
240: FND_MSG_PUB.ADD;
241: RAISE FND_API.G_EXC_ERROR;
242: end if;
243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
244: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
245: ,p_data => x_msg_data);
246:
247: raise;

Line 254: p_commit IN varchar2 := FND_API.G_FALSE

250: /************************************************************************************
251: ************************************************************************************/
252:
253: procedure Retrieve_Measures(
254: p_commit IN varchar2 := FND_API.G_FALSE
255: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
256: ,x_Dataset_Rec IN OUT NOCOPY BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
257: ,x_return_status OUT NOCOPY varchar2
258: ,x_msg_count OUT NOCOPY number

Line 309: if (p_commit = FND_API.G_TRUE) then

305: ,bsc_db_measure_cols_vl b
306: where a.measure_id = p_Dataset_Rec.Bsc_Measure_Id
307: and a.measure_col = b.Measure_Col(+);
308:
309: if (p_commit = FND_API.G_TRUE) then
310: commit;
311: end if;
312:
313: EXCEPTION

Line 314: WHEN FND_API.G_EXC_ERROR THEN

310: commit;
311: end if;
312:
313: EXCEPTION
314: WHEN FND_API.G_EXC_ERROR THEN
315: x_return_status := FND_API.G_RET_STS_ERROR;
316: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
317: ,p_data => x_msg_data);
318: raise;

Line 315: x_return_status := FND_API.G_RET_STS_ERROR;

311: end if;
312:
313: EXCEPTION
314: WHEN FND_API.G_EXC_ERROR THEN
315: x_return_status := FND_API.G_RET_STS_ERROR;
316: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
317: ,p_data => x_msg_data);
318: raise;
319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

315: x_return_status := FND_API.G_RET_STS_ERROR;
316: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
317: ,p_data => x_msg_data);
318: raise;
319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
321: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
322: ,p_data => x_msg_data);
323: raise;

Line 320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

316: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
317: ,p_data => x_msg_data);
318: raise;
319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
321: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
322: ,p_data => x_msg_data);
323: raise;
324: WHEN NO_DATA_FOUND THEN

Line 329: RAISE FND_API.G_EXC_ERROR;

325: FND_MSG_PUB.Initialize;
326: FND_MESSAGE.SET_NAME('BSC','BSC_NO_VALUE_FOUND');
327: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', g_db_object);
328: FND_MSG_PUB.ADD;
329: RAISE FND_API.G_EXC_ERROR;
330: WHEN OTHERS THEN
331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
332: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
333: ,p_data => x_msg_data);

Line 331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

327: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', g_db_object);
328: FND_MSG_PUB.ADD;
329: RAISE FND_API.G_EXC_ERROR;
330: WHEN OTHERS THEN
331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
332: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
333: ,p_data => x_msg_data);
334: raise;
335:

Line 416: /*IF (BSC_BIS_MEASURE_PUB.Is_Formula_Type(p_old_formula)=FND_API.G_TRUE AND BSC_BIS_MEASURE_PUB.Is_Formula_Type(p_new_formula)=FND_API.G_TRUE) THEN

412: l_Structure_Change := TRUE;
413: END IF;
414:
415: -- Actual fix for Bug #Bug #4860106 (Pending for Bug #4941403)- Don't remove it.- ppandey
416: /*IF (BSC_BIS_MEASURE_PUB.Is_Formula_Type(p_old_formula)=FND_API.G_TRUE AND BSC_BIS_MEASURE_PUB.Is_Formula_Type(p_new_formula)=FND_API.G_TRUE) THEN
417: l_Old_Formula_Table := get_Formula_Table(p_old_formula, l_Old_Measure_Count);
418: l_New_Formula_Table := get_Formula_Table(p_new_formula, l_New_Measure_Count);
419: IF (l_Old_Measure_Count <> l_New_Measure_Count) THEN
420: l_Structure_Change := TRUE;

Line 447: p_commit IN varchar2 := FND_API.G_FALSE

443: /************************************************************************************
444: ************************************************************************************/
445:
446: procedure Update_Measures(
447: p_commit IN varchar2 := FND_API.G_FALSE
448: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
449: ,x_return_status OUT NOCOPY varchar2
450: ,x_msg_count OUT NOCOPY number
451: ,x_msg_data OUT NOCOPY varchar2

Line 487: RAISE FND_API.G_EXC_ERROR;

483: if l_count = 0 then
484: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_MEAS_ID');
485: FND_MESSAGE.SET_TOKEN('BSC_MEAS', p_Dataset_Rec.Bsc_Measure_Id);
486: FND_MSG_PUB.ADD;
487: RAISE FND_API.G_EXC_ERROR;
488: end if;
489: else
490: FND_MESSAGE.SET_NAME('BSC','BSC_NO_MEAS_ID_ENTERED');
491: FND_MSG_PUB.ADD;

Line 492: RAISE FND_API.G_EXC_ERROR;

488: end if;
489: else
490: FND_MESSAGE.SET_NAME('BSC','BSC_NO_MEAS_ID_ENTERED');
491: FND_MSG_PUB.ADD;
492: RAISE FND_API.G_EXC_ERROR;
493: end if;
494:
495: SELECT MEASURE_COL
496: INTO l_current_formula

Line 508: RAISE FND_API.G_EXC_ERROR;

504: if (l_count_mescol > 0) then
505: FND_MESSAGE.SET_NAME('BSC','BSC_MEASURE_SOURCE_NAME');
506: FND_MESSAGE.SET_TOKEN('MEASURE', p_Dataset_Rec.Bsc_Dataset_Name);
507: FND_MSG_PUB.ADD;
508: RAISE FND_API.G_EXC_ERROR;
509: end if;
510: END IF;
511:
512:

Line 669: if (p_commit = FND_API.G_TRUE) then

665: ,last_update_date = l_Dataset_Rec.Bsc_Measure_Last_Update_Date -- PMD
666: ,last_update_login = l_Dataset_Rec.Bsc_Measure_Last_Update_Login -- PMD
667: WHERE measure_id = l_Dataset_Rec.Bsc_Measure_Id;
668:
669: if (p_commit = FND_API.G_TRUE) then
670: commit;
671: end if;
672:
673: EXCEPTION

Line 674: WHEN FND_API.G_EXC_ERROR THEN

670: commit;
671: end if;
672:
673: EXCEPTION
674: WHEN FND_API.G_EXC_ERROR THEN
675: IF(c_measures_col%ISOPEN) THEN
676: CLOSE c_measures_col;
677: END IF;
678: IF indicators_cursor%ISOPEN THEN

Line 681: x_return_status := FND_API.G_RET_STS_ERROR;

677: END IF;
678: IF indicators_cursor%ISOPEN THEN
679: CLOSE indicators_cursor;
680: END IF;
681: x_return_status := FND_API.G_RET_STS_ERROR;
682: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
683: ,p_data => x_msg_data);
684: RAISE;
685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

681: x_return_status := FND_API.G_RET_STS_ERROR;
682: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
683: ,p_data => x_msg_data);
684: RAISE;
685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
686: IF(c_measures_col%ISOPEN) THEN
687: CLOSE c_measures_col;
688: END IF;
689: IF indicators_cursor%ISOPEN THEN

Line 692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

688: END IF;
689: IF indicators_cursor%ISOPEN THEN
690: CLOSE indicators_cursor;
691: END IF;
692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
693: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
694: ,p_data => x_msg_data);
695: RAISE;
696: WHEN NO_DATA_FOUND THEN

Line 703: x_return_status := FND_API.G_RET_STS_ERROR;

699: END IF;
700: IF indicators_cursor%ISOPEN THEN
701: CLOSE indicators_cursor;
702: END IF;
703: x_return_status := FND_API.G_RET_STS_ERROR;
704: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
705: ,p_data => x_msg_data);
706: RAISE;
707: WHEN OTHERS THEN

Line 714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

710: END IF;
711: IF indicators_cursor%ISOPEN THEN
712: CLOSE indicators_cursor;
713: END IF;
714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
715: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
716: ,p_data => x_msg_data);
717: RAISE;
718:

Line 725: p_commit IN VARCHAR2 := FND_API.G_FALSE

721: /************************************************************************************
722: ************************************************************************************/
723:
724: PROCEDURE Delete_Measures(
725: p_commit IN VARCHAR2 := FND_API.G_FALSE
726: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
727: ,x_return_status OUT NOCOPY VARCHAR2
728: ,x_msg_count OUT NOCOPY NUMBER
729: ,x_msg_data OUT NOCOPY VARCHAR2

Line 748: RAISE FND_API.G_EXC_ERROR;

744: IF l_count = 0 THEN
745: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_MEAS_ID');
746: FND_MESSAGE.SET_TOKEN('BSC_MEAS', p_Dataset_Rec.Bsc_Measure_Id);
747: FND_MSG_PUB.ADD;
748: RAISE FND_API.G_EXC_ERROR;
749: END IF;
750:
751: -- If the Meeasure_Id1 is not null (A+B Formula)
752: IF p_Dataset_Rec.Bsc_Measure_Id2 IS NOT NULL THEN

Line 761: RAISE FND_API.G_EXC_ERROR;

757: IF l_count = 0 THEN
758: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_MEAS_ID');
759: FND_MESSAGE.SET_TOKEN('BSC_MEAS', p_Dataset_Rec.Bsc_Measure_Id2);
760: FND_MSG_PUB.ADD;
761: RAISE FND_API.G_EXC_ERROR;
762: END IF;
763: END IF;
764:
765: -- Only delete base measure if there are no datasets referencing it.

Line 798: IF (p_Commit = FND_API.G_TRUE) THEN

794: BSC_DB_MEASURE_COLS_PKG.delete_row(l_Measure_Col);
795: END IF;
796: END IF;
797:
798: IF (p_Commit = FND_API.G_TRUE) THEN
799: COMMIT;
800: END IF;
801:
802: -- mdamle 04/23/2003 - PMD - Measure Definer - No need to raise error, just don't delete the from bsc_sys_measures

Line 841: IF (p_Commit = FND_API.G_TRUE) THEN

837: BSC_DB_MEASURE_COLS_PKG.delete_row(l_Measure_Col);
838: END IF;
839: END IF;
840:
841: IF (p_Commit = FND_API.G_TRUE) THEN
842: COMMIT;
843: END IF;
844: END IF;
845: END IF;

Line 850: RAISE FND_API.G_EXC_ERROR;

846:
847: ELSE
848: FND_MESSAGE.SET_NAME('BSC','BSC_NO_MEAS_ID_ENTERED');
849: FND_MSG_PUB.ADD;
850: RAISE FND_API.G_EXC_ERROR;
851: END IF;
852:
853: EXCEPTION
854: WHEN FND_API.G_EXC_ERROR THEN

Line 854: WHEN FND_API.G_EXC_ERROR THEN

850: RAISE FND_API.G_EXC_ERROR;
851: END IF;
852:
853: EXCEPTION
854: WHEN FND_API.G_EXC_ERROR THEN
855: x_return_status := FND_API.G_RET_STS_ERROR;
856: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
857: ,p_data => x_msg_data);
858: RAISE;

Line 855: x_return_status := FND_API.G_RET_STS_ERROR;

851: END IF;
852:
853: EXCEPTION
854: WHEN FND_API.G_EXC_ERROR THEN
855: x_return_status := FND_API.G_RET_STS_ERROR;
856: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
857: ,p_data => x_msg_data);
858: RAISE;
859: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 859: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

855: x_return_status := FND_API.G_RET_STS_ERROR;
856: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
857: ,p_data => x_msg_data);
858: RAISE;
859: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
860: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
861: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
862: ,p_data => x_msg_data);
863: RAISE;

Line 860: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

856: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
857: ,p_data => x_msg_data);
858: RAISE;
859: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
860: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
861: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
862: ,p_data => x_msg_data);
863: RAISE;
864: WHEN NO_DATA_FOUND THEN

Line 865: x_return_status := FND_API.G_RET_STS_ERROR;

861: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
862: ,p_data => x_msg_data);
863: RAISE;
864: WHEN NO_DATA_FOUND THEN
865: x_return_status := FND_API.G_RET_STS_ERROR;
866: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
867: ,p_data => x_msg_data);
868: RAISE;
869: WHEN OTHERS THEN

Line 870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

866: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
867: ,p_data => x_msg_data);
868: RAISE;
869: WHEN OTHERS THEN
870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
871: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
872: ,p_data => x_msg_data);
873: RAISE;
874:

Line 883: p_commit IN varchar2 := FND_API.G_FALSE

879: ************************************************************************************/
880: /*
881:
882: procedure Create_Formats(
883: p_commit IN varchar2 := FND_API.G_FALSE
884: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
885: ,x_return_status OUT NOCOPY varchar2
886: ,x_msg_count OUT NOCOPY number
887: ,x_msg_data OUT NOCOPY varchar2

Line 892: if (p_commit = FND_API.G_TRUE) then

888: ) is
889:
890: begin
891:
892: if (p_commit = FND_API.G_TRUE) then
893: commit;
894: end if;
895:
896: EXCEPTION

Line 897: WHEN FND_API.G_EXC_ERROR THEN

893: commit;
894: end if;
895:
896: EXCEPTION
897: WHEN FND_API.G_EXC_ERROR THEN
898: x_return_status := FND_API.G_RET_STS_ERROR;
899: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
900: ,p_data => x_msg_data);
901: raise;

Line 898: x_return_status := FND_API.G_RET_STS_ERROR;

894: end if;
895:
896: EXCEPTION
897: WHEN FND_API.G_EXC_ERROR THEN
898: x_return_status := FND_API.G_RET_STS_ERROR;
899: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
900: ,p_data => x_msg_data);
901: raise;
902: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 902: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

898: x_return_status := FND_API.G_RET_STS_ERROR;
899: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
900: ,p_data => x_msg_data);
901: raise;
902: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
904: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
905: ,p_data => x_msg_data);
906: raise;

Line 903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

899: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
900: ,p_data => x_msg_data);
901: raise;
902: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
904: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
905: ,p_data => x_msg_data);
906: raise;
907: WHEN NO_DATA_FOUND THEN

Line 908: x_return_status := FND_API.G_RET_STS_ERROR;

904: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
905: ,p_data => x_msg_data);
906: raise;
907: WHEN NO_DATA_FOUND THEN
908: x_return_status := FND_API.G_RET_STS_ERROR;
909: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
910: ,p_data => x_msg_data);
911: raise;
912: WHEN OTHERS THEN

Line 913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

909: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
910: ,p_data => x_msg_data);
911: raise;
912: WHEN OTHERS THEN
913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
914: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
915: ,p_data => x_msg_data);
916: raise;
917:

Line 926: p_commit IN varchar2 := FND_API.G_FALSE

922: ************************************************************************************/
923: /*
924:
925: procedure Delete_Formats(
926: p_commit IN varchar2 := FND_API.G_FALSE
927: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
928: ,x_return_status OUT NOCOPY varchar2
929: ,x_msg_count OUT NOCOPY number
930: ,x_msg_data OUT NOCOPY varchar2

Line 935: if (p_commit = FND_API.G_TRUE) then

931: ) is
932:
933: begin
934:
935: if (p_commit = FND_API.G_TRUE) then
936: commit;
937: end if;
938:
939: EXCEPTION

Line 940: WHEN FND_API.G_EXC_ERROR THEN

936: commit;
937: end if;
938:
939: EXCEPTION
940: WHEN FND_API.G_EXC_ERROR THEN
941: x_return_status := FND_API.G_RET_STS_ERROR;
942: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
943: ,p_data => x_msg_data);
944: raise;

Line 941: x_return_status := FND_API.G_RET_STS_ERROR;

937: end if;
938:
939: EXCEPTION
940: WHEN FND_API.G_EXC_ERROR THEN
941: x_return_status := FND_API.G_RET_STS_ERROR;
942: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
943: ,p_data => x_msg_data);
944: raise;
945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

941: x_return_status := FND_API.G_RET_STS_ERROR;
942: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
943: ,p_data => x_msg_data);
944: raise;
945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
947: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
948: ,p_data => x_msg_data);
949: raise;

Line 946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

942: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
943: ,p_data => x_msg_data);
944: raise;
945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
947: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
948: ,p_data => x_msg_data);
949: raise;
950: WHEN NO_DATA_FOUND THEN

Line 951: x_return_status := FND_API.G_RET_STS_ERROR;

947: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
948: ,p_data => x_msg_data);
949: raise;
950: WHEN NO_DATA_FOUND THEN
951: x_return_status := FND_API.G_RET_STS_ERROR;
952: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
953: ,p_data => x_msg_data);
954: raise;
955: WHEN OTHERS THEN

Line 956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

952: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
953: ,p_data => x_msg_data);
954: raise;
955: WHEN OTHERS THEN
956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
957: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
958: ,p_data => x_msg_data);
959: raise;
960:

Line 971: p_commit IN varchar2 := FND_API.G_FALSE

967: --: This procedure creates a dataset for the given measure.
968: --: This procedure is part of the Data Set API.
969:
970: procedure Create_Dataset(
971: p_commit IN varchar2 := FND_API.G_FALSE
972: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
973: ,x_return_status OUT NOCOPY varchar2
974: ,x_msg_count OUT NOCOPY number
975: ,x_msg_data OUT NOCOPY varchar2

Line 1067: if (p_commit = FND_API.G_TRUE) then

1063: from BSC_SYS_DATASETS_TL T
1064: where T.dataset_id = l_Dataset_Rec.Bsc_Dataset_Id
1065: and T.LANGUAGE = L.LANGUAGE_CODE);
1066:
1067: if (p_commit = FND_API.G_TRUE) then
1068: commit;
1069: end if;
1070:
1071: else

Line 1075: RAISE FND_API.G_EXC_ERROR;

1071: else
1072: FND_MESSAGE.SET_NAME('BSC','BSC_DSET_ID_EXISTS');
1073: FND_MESSAGE.SET_TOKEN('BSC_DATASET', l_Dataset_Rec.Bsc_Dataset_Id);
1074: FND_MSG_PUB.ADD;
1075: RAISE FND_API.G_EXC_ERROR;
1076: end if;
1077:
1078:
1079: EXCEPTION

Line 1080: WHEN FND_API.G_EXC_ERROR THEN

1076: end if;
1077:
1078:
1079: EXCEPTION
1080: WHEN FND_API.G_EXC_ERROR THEN
1081: x_return_status := FND_API.G_RET_STS_ERROR;
1082: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1083: ,p_data => x_msg_data);
1084: raise;

Line 1081: x_return_status := FND_API.G_RET_STS_ERROR;

1077:
1078:
1079: EXCEPTION
1080: WHEN FND_API.G_EXC_ERROR THEN
1081: x_return_status := FND_API.G_RET_STS_ERROR;
1082: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1083: ,p_data => x_msg_data);
1084: raise;
1085: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1085: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1081: x_return_status := FND_API.G_RET_STS_ERROR;
1082: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1083: ,p_data => x_msg_data);
1084: raise;
1085: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1086: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1087: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1088: ,p_data => x_msg_data);
1089: raise;

Line 1086: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1082: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1083: ,p_data => x_msg_data);
1084: raise;
1085: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1086: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1087: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1088: ,p_data => x_msg_data);
1089: raise;
1090: WHEN NO_DATA_FOUND THEN

Line 1091: x_return_status := FND_API.G_RET_STS_ERROR;

1087: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1088: ,p_data => x_msg_data);
1089: raise;
1090: WHEN NO_DATA_FOUND THEN
1091: x_return_status := FND_API.G_RET_STS_ERROR;
1092: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1093: ,p_data => x_msg_data);
1094: raise;
1095: WHEN OTHERS THEN

Line 1096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1092: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1093: ,p_data => x_msg_data);
1094: raise;
1095: WHEN OTHERS THEN
1096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1097: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1098: ,p_data => x_msg_data);
1099: raise;
1100:

Line 1107: p_commit IN varchar2 := FND_API.G_FALSE

1103: /************************************************************************************
1104: ************************************************************************************/
1105:
1106: procedure Retrieve_Dataset(
1107: p_commit IN varchar2 := FND_API.G_FALSE
1108: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
1109: ,x_Dataset_Rec IN OUT NOCOPY BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
1110: ,x_return_status OUT NOCOPY varchar2
1111: ,x_msg_count OUT NOCOPY number

Line 1155: if (p_commit = FND_API.G_TRUE) then

1151:
1152: from BSC_SYS_DATASETS_VL
1153: where dataset_id = p_Dataset_Rec.Bsc_Dataset_Id;
1154:
1155: if (p_commit = FND_API.G_TRUE) then
1156: commit;
1157: end if;
1158:
1159: EXCEPTION

Line 1160: WHEN FND_API.G_EXC_ERROR THEN

1156: commit;
1157: end if;
1158:
1159: EXCEPTION
1160: WHEN FND_API.G_EXC_ERROR THEN
1161: x_return_status := FND_API.G_RET_STS_ERROR;
1162: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1163: ,p_data => x_msg_data);
1164: raise;

Line 1161: x_return_status := FND_API.G_RET_STS_ERROR;

1157: end if;
1158:
1159: EXCEPTION
1160: WHEN FND_API.G_EXC_ERROR THEN
1161: x_return_status := FND_API.G_RET_STS_ERROR;
1162: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1163: ,p_data => x_msg_data);
1164: raise;
1165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1161: x_return_status := FND_API.G_RET_STS_ERROR;
1162: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1163: ,p_data => x_msg_data);
1164: raise;
1165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1167: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1168: ,p_data => x_msg_data);
1169: raise;

Line 1166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1162: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1163: ,p_data => x_msg_data);
1164: raise;
1165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1167: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1168: ,p_data => x_msg_data);
1169: raise;
1170: WHEN NO_DATA_FOUND THEN

Line 1171: x_return_status := FND_API.G_RET_STS_ERROR;

1167: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1168: ,p_data => x_msg_data);
1169: raise;
1170: WHEN NO_DATA_FOUND THEN
1171: x_return_status := FND_API.G_RET_STS_ERROR;
1172: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1173: ,p_data => x_msg_data);
1174: raise;
1175: WHEN OTHERS THEN

Line 1176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1172: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1173: ,p_data => x_msg_data);
1174: raise;
1175: WHEN OTHERS THEN
1176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1177: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1178: ,p_data => x_msg_data);
1179: raise;
1180:

Line 1187: p_commit IN varchar2 := FND_API.G_FALSE

1183: /************************************************************************************
1184: ************************************************************************************/
1185:
1186: procedure Update_Dataset(
1187: p_commit IN varchar2 := FND_API.G_FALSE
1188: , p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
1189: ,x_return_status OUT NOCOPY varchar2
1190: ,x_msg_count OUT NOCOPY number
1191: ,x_msg_data OUT NOCOPY varchar2

Line 1232: RAISE FND_API.G_EXC_ERROR;

1228: if l_count = 0 then
1229: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_DTSET_ID');
1230: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Dataset_Id);
1231: FND_MSG_PUB.ADD;
1232: RAISE FND_API.G_EXC_ERROR;
1233: end if;
1234: else
1235: FND_MESSAGE.SET_NAME('BSC','BSC_NO_DTSET_ID_ENTERED');
1236: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Dataset_Id);

Line 1238: RAISE FND_API.G_EXC_ERROR;

1234: else
1235: FND_MESSAGE.SET_NAME('BSC','BSC_NO_DTSET_ID_ENTERED');
1236: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Dataset_Id);
1237: FND_MSG_PUB.ADD;
1238: RAISE FND_API.G_EXC_ERROR;
1239: end if;
1240:
1241:
1242: /* commented, apparently not needed.

Line 1252: RAISE FND_API.G_EXC_ERROR;

1248: if l_count = 0 then
1249: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_MEAS_ID');
1250: FND_MESSAGE.SET_TOKEN('BSC_MEAS', p_Dataset_Rec.Bsc_Measure_Id);
1251: FND_MSG_PUB.ADD;
1252: RAISE FND_API.G_EXC_ERROR;
1253: end if;
1254: else
1255: FND_MESSAGE.SET_NAME('BSC','BSC_NO_MEAS_ID_ENTERED');
1256: FND_MESSAGE.SET_TOKEN('BSC_MEAS', p_Dataset_Rec.Bsc_Measure_Id);

Line 1258: RAISE FND_API.G_EXC_ERROR;

1254: else
1255: FND_MESSAGE.SET_NAME('BSC','BSC_NO_MEAS_ID_ENTERED');
1256: FND_MESSAGE.SET_TOKEN('BSC_MEAS', p_Dataset_Rec.Bsc_Measure_Id);
1257: FND_MSG_PUB.ADD;
1258: RAISE FND_API.G_EXC_ERROR;
1259: end if;
1260:
1261: -- Check that valid 2nd measure id was entered.
1262: if p_Dataset_Rec.Bsc_Measure_Id2 is not null and

Line 1271: RAISE FND_API.G_EXC_ERROR;

1267: if l_count = 0 then
1268: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_MEAS_ID');
1269: FND_MESSAGE.SET_TOKEN('BSC_MEAS', p_Dataset_Rec.Bsc_Measure_Id);
1270: FND_MSG_PUB.ADD;
1271: RAISE FND_API.G_EXC_ERROR;
1272: end if;
1273:
1274: end if;
1275: */

Line 1429: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1425: ,x_return_status => x_return_status
1426: ,x_msg_count => x_msg_count
1427: ,x_msg_data => x_msg_data);
1428:
1429: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1430: RAISE FND_API.G_EXC_ERROR;
1431: END IF;
1432:
1433: BSC_COLOR_RANGES_PUB.Create_Def_Color_Prop_Ranges(p_objective_id => l_indicator_table(i)

Line 1430: RAISE FND_API.G_EXC_ERROR;

1426: ,x_msg_count => x_msg_count
1427: ,x_msg_data => x_msg_data);
1428:
1429: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1430: RAISE FND_API.G_EXC_ERROR;
1431: END IF;
1432:
1433: BSC_COLOR_RANGES_PUB.Create_Def_Color_Prop_Ranges(p_objective_id => l_indicator_table(i)
1434: ,p_kpi_measure_id => l_kpi_measure_id

Line 1440: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1436: ,x_return_status => x_return_status
1437: ,x_msg_count => x_msg_count
1438: ,x_msg_data => x_msg_data);
1439:
1440: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1441: RAISE FND_API.G_EXC_ERROR;
1442: END IF;
1443: END IF;
1444: END LOOP;

Line 1441: RAISE FND_API.G_EXC_ERROR;

1437: ,x_msg_count => x_msg_count
1438: ,x_msg_data => x_msg_data);
1439:
1440: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1441: RAISE FND_API.G_EXC_ERROR;
1442: END IF;
1443: END IF;
1444: END LOOP;
1445: END IF;

Line 1447: if (p_commit = FND_API.G_TRUE) then

1443: END IF;
1444: END LOOP;
1445: END IF;
1446:
1447: if (p_commit = FND_API.G_TRUE) then
1448: commit;
1449: end if;
1450:
1451:

Line 1467: WHEN FND_API.G_EXC_ERROR THEN

1463: end if;
1464:
1465:
1466: EXCEPTION
1467: WHEN FND_API.G_EXC_ERROR THEN
1468: x_return_status := FND_API.G_RET_STS_ERROR;
1469: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1470: ,p_data => x_msg_data);
1471: raise;

Line 1468: x_return_status := FND_API.G_RET_STS_ERROR;

1464:
1465:
1466: EXCEPTION
1467: WHEN FND_API.G_EXC_ERROR THEN
1468: x_return_status := FND_API.G_RET_STS_ERROR;
1469: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1470: ,p_data => x_msg_data);
1471: raise;
1472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1468: x_return_status := FND_API.G_RET_STS_ERROR;
1469: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1470: ,p_data => x_msg_data);
1471: raise;
1472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1474: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1475: ,p_data => x_msg_data);
1476: raise;

Line 1473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1469: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1470: ,p_data => x_msg_data);
1471: raise;
1472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1474: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1475: ,p_data => x_msg_data);
1476: raise;
1477: WHEN NO_DATA_FOUND THEN

Line 1478: x_return_status := FND_API.G_RET_STS_ERROR;

1474: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1475: ,p_data => x_msg_data);
1476: raise;
1477: WHEN NO_DATA_FOUND THEN
1478: x_return_status := FND_API.G_RET_STS_ERROR;
1479: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1480: ,p_data => x_msg_data);
1481: raise;
1482: WHEN OTHERS THEN

Line 1483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1479: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1480: ,p_data => x_msg_data);
1481: raise;
1482: WHEN OTHERS THEN
1483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1484: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1485: ,p_data => x_msg_data);
1486: raise;
1487:

Line 1494: p_commit IN varchar2 := FND_API.G_FALSE

1490: /************************************************************************************
1491: ************************************************************************************/
1492:
1493: procedure Delete_Dataset(
1494: p_commit IN varchar2 := FND_API.G_FALSE
1495: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
1496: ,x_return_status OUT NOCOPY varchar2
1497: ,x_msg_count OUT NOCOPY number
1498: ,x_msg_data OUT NOCOPY varchar2

Line 1521: x_return_status := FND_API.G_RET_STS_SUCCESS;

1517:
1518: l_count number;
1519:
1520: begin
1521: x_return_status := FND_API.G_RET_STS_SUCCESS;
1522: -- Check that a valid dataset id was entered.
1523: if p_Dataset_Rec.Bsc_Dataset_Id is not null then
1524: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_DATASETS_B'
1525: ,'dataset_id'

Line 1531: RAISE FND_API.G_EXC_ERROR;

1527: if l_count = 0 then
1528: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_DTSET_ID');
1529: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Dataset_Id);
1530: FND_MSG_PUB.ADD;
1531: RAISE FND_API.G_EXC_ERROR;
1532: end if;
1533:
1534: -- mdamle 04/23/2003 - PMD - Measure Definer - Check if assigned to indicator
1535: for cr in indicators_cursor loop

Line 1551: RAISE FND_API.G_EXC_ERROR;

1547: if l_indicators is not null then
1548: FND_MESSAGE.SET_NAME('BSC','BSC_DELETE_MEASURE_IND_ERR_TXT');
1549: FND_MESSAGE.SET_TOKEN('BSC_INDICATORS', l_indicators);
1550: FND_MSG_PUB.ADD;
1551: RAISE FND_API.G_EXC_ERROR;
1552: end if;
1553: else
1554: FND_MESSAGE.SET_NAME('BSC','BSC_NO_DTSET_ID_ENTERED');
1555: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Dataset_Id);

Line 1557: RAISE FND_API.G_EXC_ERROR;

1553: else
1554: FND_MESSAGE.SET_NAME('BSC','BSC_NO_DTSET_ID_ENTERED');
1555: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Dataset_Id);
1556: FND_MSG_PUB.ADD;
1557: RAISE FND_API.G_EXC_ERROR;
1558: end if;
1559:
1560: OPEN c_short_name(p_Dataset_Rec.Bsc_Dataset_Id);
1561: FETCH c_short_name INTO l_short_name;

Line 1582: if (p_commit = FND_API.G_TRUE) then

1578:
1579: delete from BSC_SYS_DATASETS_TL
1580: where dataset_id = p_Dataset_Rec.Bsc_Dataset_Id;
1581:
1582: if (p_commit = FND_API.G_TRUE) then
1583: commit;
1584: end if;
1585:
1586: EXCEPTION

Line 1587: WHEN FND_API.G_EXC_ERROR THEN

1583: commit;
1584: end if;
1585:
1586: EXCEPTION
1587: WHEN FND_API.G_EXC_ERROR THEN
1588: x_return_status := FND_API.G_RET_STS_ERROR;
1589: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE
1590: ,p_count => x_msg_count
1591: ,p_data => x_msg_data);

Line 1588: x_return_status := FND_API.G_RET_STS_ERROR;

1584: end if;
1585:
1586: EXCEPTION
1587: WHEN FND_API.G_EXC_ERROR THEN
1588: x_return_status := FND_API.G_RET_STS_ERROR;
1589: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE
1590: ,p_count => x_msg_count
1591: ,p_data => x_msg_data);
1592: raise;

Line 1589: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE

1585:
1586: EXCEPTION
1587: WHEN FND_API.G_EXC_ERROR THEN
1588: x_return_status := FND_API.G_RET_STS_ERROR;
1589: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE
1590: ,p_count => x_msg_count
1591: ,p_data => x_msg_data);
1592: raise;
1593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1589: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE
1590: ,p_count => x_msg_count
1591: ,p_data => x_msg_data);
1592: raise;
1593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1595: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE
1596: ,p_count => x_msg_count
1597: ,p_data => x_msg_data);

Line 1594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1590: ,p_count => x_msg_count
1591: ,p_data => x_msg_data);
1592: raise;
1593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1595: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE
1596: ,p_count => x_msg_count
1597: ,p_data => x_msg_data);
1598: raise;

Line 1595: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE

1591: ,p_data => x_msg_data);
1592: raise;
1593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1595: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE
1596: ,p_count => x_msg_count
1597: ,p_data => x_msg_data);
1598: raise;
1599: WHEN NO_DATA_FOUND THEN

Line 1600: x_return_status := FND_API.G_RET_STS_ERROR;

1596: ,p_count => x_msg_count
1597: ,p_data => x_msg_data);
1598: raise;
1599: WHEN NO_DATA_FOUND THEN
1600: x_return_status := FND_API.G_RET_STS_ERROR;
1601: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE
1602: ,p_count => x_msg_count
1603: ,p_data => x_msg_data);
1604: raise;

Line 1601: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE

1597: ,p_data => x_msg_data);
1598: raise;
1599: WHEN NO_DATA_FOUND THEN
1600: x_return_status := FND_API.G_RET_STS_ERROR;
1601: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE
1602: ,p_count => x_msg_count
1603: ,p_data => x_msg_data);
1604: raise;
1605: WHEN OTHERS THEN

Line 1606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1602: ,p_count => x_msg_count
1603: ,p_data => x_msg_data);
1604: raise;
1605: WHEN OTHERS THEN
1606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1607: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE
1608: ,p_count => x_msg_count
1609: ,p_data => x_msg_data);
1610: raise;

Line 1607: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE

1603: ,p_data => x_msg_data);
1604: raise;
1605: WHEN OTHERS THEN
1606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1607: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE
1608: ,p_count => x_msg_count
1609: ,p_data => x_msg_data);
1610: raise;
1611:

Line 1622: p_commit IN varchar2 := FND_API.G_FALSE

1618: --: for the given dimension.
1619: --: This procedure is part of the Data Set API.
1620:
1621: procedure Create_Dataset_Calc(
1622: p_commit IN varchar2 := FND_API.G_FALSE
1623: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
1624: ,x_return_status OUT NOCOPY varchar2
1625: ,x_msg_count OUT NOCOPY number
1626: ,x_msg_data OUT NOCOPY varchar2

Line 1643: RAISE FND_API.G_EXC_ERROR;

1639: if l_count = 0 then
1640: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_DTSET_ID');
1641: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Dataset_Id);
1642: FND_MSG_PUB.ADD;
1643: RAISE FND_API.G_EXC_ERROR;
1644: else -- Check that combination dataset id and calc id does not exist.
1645: select count(1)
1646: into l_count
1647: from BSC_SYS_DATASET_CALC

Line 1654: RAISE FND_API.G_EXC_ERROR;

1650: if l_count <> 0 then
1651: FND_MESSAGE.SET_NAME('BSC','BSC_DTSET_CALC_EXISTSD');
1652: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Disabled_Calc_Id);
1653: FND_MSG_PUB.ADD;
1654: RAISE FND_API.G_EXC_ERROR;
1655: end if;
1656:
1657: end if;
1658:

Line 1663: RAISE FND_API.G_EXC_ERROR;

1659: else
1660: FND_MESSAGE.SET_NAME('BSC','BSC_NO_DTSET_ID_ENTERED');
1661: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Dataset_Id);
1662: FND_MSG_PUB.ADD;
1663: RAISE FND_API.G_EXC_ERROR;
1664: end if;
1665:
1666: -- Insert pertaining values into table bsc_sys_dataset_calc.
1667: insert into BSC_SYS_DATASET_CALC( dataset_id

Line 1672: if (p_commit = FND_API.G_TRUE) then

1668: ,disabled_calc_id)
1669: values( p_Dataset_Rec.Bsc_Dataset_Id
1670: ,p_Dataset_Rec.Bsc_Disabled_Calc_Id);
1671:
1672: if (p_commit = FND_API.G_TRUE) then
1673: commit;
1674: end if;
1675:
1676: EXCEPTION

Line 1677: WHEN FND_API.G_EXC_ERROR THEN

1673: commit;
1674: end if;
1675:
1676: EXCEPTION
1677: WHEN FND_API.G_EXC_ERROR THEN
1678: x_return_status := FND_API.G_RET_STS_ERROR;
1679: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1680: ,p_data => x_msg_data);
1681: raise;

Line 1678: x_return_status := FND_API.G_RET_STS_ERROR;

1674: end if;
1675:
1676: EXCEPTION
1677: WHEN FND_API.G_EXC_ERROR THEN
1678: x_return_status := FND_API.G_RET_STS_ERROR;
1679: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1680: ,p_data => x_msg_data);
1681: raise;
1682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1678: x_return_status := FND_API.G_RET_STS_ERROR;
1679: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1680: ,p_data => x_msg_data);
1681: raise;
1682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1684: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1685: ,p_data => x_msg_data);
1686: raise;

Line 1683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1679: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1680: ,p_data => x_msg_data);
1681: raise;
1682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1684: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1685: ,p_data => x_msg_data);
1686: raise;
1687: WHEN NO_DATA_FOUND THEN

Line 1688: x_return_status := FND_API.G_RET_STS_ERROR;

1684: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1685: ,p_data => x_msg_data);
1686: raise;
1687: WHEN NO_DATA_FOUND THEN
1688: x_return_status := FND_API.G_RET_STS_ERROR;
1689: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1690: ,p_data => x_msg_data);
1691: raise;
1692: WHEN OTHERS THEN

Line 1693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1689: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1690: ,p_data => x_msg_data);
1691: raise;
1692: WHEN OTHERS THEN
1693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1694: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1695: ,p_data => x_msg_data);
1696: raise;
1697:

Line 1704: p_commit IN varchar2 := FND_API.G_FALSE

1700: /************************************************************************************
1701: ************************************************************************************/
1702:
1703: procedure Retrieve_Dataset_Calc(
1704: p_commit IN varchar2 := FND_API.G_FALSE
1705: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
1706: ,x_Dataset_Rec IN OUT NOCOPY BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
1707: ,x_return_status OUT NOCOPY varchar2
1708: ,x_msg_count OUT NOCOPY number

Line 1719: if (p_commit = FND_API.G_TRUE) then

1715: into x_Dataset_Rec.Bsc_Disabled_Calc_Id
1716: from BSC_SYS_DATASET_CALC
1717: where dataset_id = x_Dataset_Rec.Bsc_Dataset_Id;
1718:
1719: if (p_commit = FND_API.G_TRUE) then
1720: commit;
1721: end if;
1722:
1723: EXCEPTION

Line 1724: WHEN FND_API.G_EXC_ERROR THEN

1720: commit;
1721: end if;
1722:
1723: EXCEPTION
1724: WHEN FND_API.G_EXC_ERROR THEN
1725: x_return_status := FND_API.G_RET_STS_ERROR;
1726: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1727: ,p_data => x_msg_data);
1728: raise;

Line 1725: x_return_status := FND_API.G_RET_STS_ERROR;

1721: end if;
1722:
1723: EXCEPTION
1724: WHEN FND_API.G_EXC_ERROR THEN
1725: x_return_status := FND_API.G_RET_STS_ERROR;
1726: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1727: ,p_data => x_msg_data);
1728: raise;
1729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1725: x_return_status := FND_API.G_RET_STS_ERROR;
1726: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1727: ,p_data => x_msg_data);
1728: raise;
1729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1731: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1732: ,p_data => x_msg_data);
1733: raise;

Line 1730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1726: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1727: ,p_data => x_msg_data);
1728: raise;
1729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1731: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1732: ,p_data => x_msg_data);
1733: raise;
1734: WHEN NO_DATA_FOUND THEN

Line 1735: x_return_status := FND_API.G_RET_STS_ERROR;

1731: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1732: ,p_data => x_msg_data);
1733: raise;
1734: WHEN NO_DATA_FOUND THEN
1735: x_return_status := FND_API.G_RET_STS_ERROR;
1736: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1737: ,p_data => x_msg_data);
1738: raise;
1739: WHEN OTHERS THEN

Line 1740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1736: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1737: ,p_data => x_msg_data);
1738: raise;
1739: WHEN OTHERS THEN
1740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1741: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1742: ,p_data => x_msg_data);
1743: raise;
1744:

Line 1751: p_commit IN varchar2 := FND_API.G_FALSE

1747: /************************************************************************************
1748: ************************************************************************************/
1749:
1750: procedure Update_Dataset_Calc(
1751: p_commit IN varchar2 := FND_API.G_FALSE
1752: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
1753: ,x_return_status OUT NOCOPY varchar2
1754: ,x_msg_count OUT NOCOPY number
1755: ,x_msg_data OUT NOCOPY varchar2

Line 1771: RAISE FND_API.G_EXC_ERROR;

1767: if l_count = 0 then
1768: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_DTSET_ID');
1769: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Dataset_Id);
1770: FND_MSG_PUB.ADD;
1771: RAISE FND_API.G_EXC_ERROR;
1772: end if;
1773: else
1774: FND_MESSAGE.SET_NAME('BSC','BSC_NO_DTSET_ID_ENTERED');
1775: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Dataset_Id);

Line 1777: RAISE FND_API.G_EXC_ERROR;

1773: else
1774: FND_MESSAGE.SET_NAME('BSC','BSC_NO_DTSET_ID_ENTERED');
1775: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Dataset_Id);
1776: FND_MSG_PUB.ADD;
1777: RAISE FND_API.G_EXC_ERROR;
1778: end if;
1779:
1780: update BSC_SYS_DATASET_CALC
1781: set disabled_calc_id = p_Dataset_Rec.Bsc_Disabled_Calc_Id

Line 1784: if (p_commit = FND_API.G_TRUE) then

1780: update BSC_SYS_DATASET_CALC
1781: set disabled_calc_id = p_Dataset_Rec.Bsc_Disabled_Calc_Id
1782: where dataset_id = p_Dataset_Rec.Bsc_Dataset_Id;
1783:
1784: if (p_commit = FND_API.G_TRUE) then
1785: commit;
1786: end if;
1787:
1788: EXCEPTION

Line 1789: WHEN FND_API.G_EXC_ERROR THEN

1785: commit;
1786: end if;
1787:
1788: EXCEPTION
1789: WHEN FND_API.G_EXC_ERROR THEN
1790: x_return_status := FND_API.G_RET_STS_ERROR;
1791: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1792: ,p_data => x_msg_data);
1793: raise;

Line 1790: x_return_status := FND_API.G_RET_STS_ERROR;

1786: end if;
1787:
1788: EXCEPTION
1789: WHEN FND_API.G_EXC_ERROR THEN
1790: x_return_status := FND_API.G_RET_STS_ERROR;
1791: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1792: ,p_data => x_msg_data);
1793: raise;
1794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1790: x_return_status := FND_API.G_RET_STS_ERROR;
1791: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1792: ,p_data => x_msg_data);
1793: raise;
1794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1796: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1797: ,p_data => x_msg_data);
1798: raise;

Line 1795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1791: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1792: ,p_data => x_msg_data);
1793: raise;
1794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1796: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1797: ,p_data => x_msg_data);
1798: raise;
1799: WHEN NO_DATA_FOUND THEN

Line 1800: x_return_status := FND_API.G_RET_STS_ERROR;

1796: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1797: ,p_data => x_msg_data);
1798: raise;
1799: WHEN NO_DATA_FOUND THEN
1800: x_return_status := FND_API.G_RET_STS_ERROR;
1801: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1802: ,p_data => x_msg_data);
1803: raise;
1804: WHEN OTHERS THEN

Line 1805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1801: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1802: ,p_data => x_msg_data);
1803: raise;
1804: WHEN OTHERS THEN
1805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1806: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1807: ,p_data => x_msg_data);
1808: raise;
1809:

Line 1816: p_commit IN varchar2 := FND_API.G_FALSE

1812: /************************************************************************************
1813: ************************************************************************************/
1814:
1815: procedure Delete_Dataset_Calc(
1816: p_commit IN varchar2 := FND_API.G_FALSE
1817: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
1818: ,x_return_status OUT NOCOPY varchar2
1819: ,x_msg_count OUT NOCOPY number
1820: ,x_msg_data OUT NOCOPY varchar2

Line 1838: RAISE FND_API.G_EXC_ERROR;

1834: if l_count = 0 then
1835: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_DTSET_ID');
1836: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Dataset_Id);
1837: FND_MSG_PUB.ADD;
1838: RAISE FND_API.G_EXC_ERROR;
1839: end if;
1840: else
1841: FND_MESSAGE.SET_NAME('BSC','BSC_NO_DTSET_ID_ENTERED');
1842: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Dataset_Id);

Line 1844: RAISE FND_API.G_EXC_ERROR;

1840: else
1841: FND_MESSAGE.SET_NAME('BSC','BSC_NO_DTSET_ID_ENTERED');
1842: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Dataset_Id);
1843: FND_MSG_PUB.ADD;
1844: RAISE FND_API.G_EXC_ERROR;
1845: end if;
1846:
1847: delete from BSC_SYS_DATASET_CALC
1848: where dataset_id = p_Dataset_Rec.Bsc_Dataset_Id;

Line 1850: if (p_commit = FND_API.G_TRUE) then

1846:
1847: delete from BSC_SYS_DATASET_CALC
1848: where dataset_id = p_Dataset_Rec.Bsc_Dataset_Id;
1849:
1850: if (p_commit = FND_API.G_TRUE) then
1851: commit;
1852: end if;
1853:
1854: EXCEPTION

Line 1855: WHEN FND_API.G_EXC_ERROR THEN

1851: commit;
1852: end if;
1853:
1854: EXCEPTION
1855: WHEN FND_API.G_EXC_ERROR THEN
1856: x_return_status := FND_API.G_RET_STS_ERROR;
1857: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1858: ,p_data => x_msg_data);
1859: raise;

Line 1856: x_return_status := FND_API.G_RET_STS_ERROR;

1852: end if;
1853:
1854: EXCEPTION
1855: WHEN FND_API.G_EXC_ERROR THEN
1856: x_return_status := FND_API.G_RET_STS_ERROR;
1857: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1858: ,p_data => x_msg_data);
1859: raise;
1860: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1860: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1856: x_return_status := FND_API.G_RET_STS_ERROR;
1857: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1858: ,p_data => x_msg_data);
1859: raise;
1860: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1861: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1862: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1863: ,p_data => x_msg_data);
1864: raise;

Line 1861: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1857: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1858: ,p_data => x_msg_data);
1859: raise;
1860: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1861: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1862: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1863: ,p_data => x_msg_data);
1864: raise;
1865: WHEN NO_DATA_FOUND THEN null;

Line 1867: x_return_status := FND_API.G_RET_STS_ERROR;

1863: ,p_data => x_msg_data);
1864: raise;
1865: WHEN NO_DATA_FOUND THEN null;
1866: /*
1867: x_return_status := FND_API.G_RET_STS_ERROR;
1868: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1869: ,p_data => x_msg_data);
1870: raise;
1871: */

Line 1873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1869: ,p_data => x_msg_data);
1870: raise;
1871: */
1872: WHEN OTHERS THEN
1873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1874: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1875: ,p_data => x_msg_data);
1876: raise;
1877:

Line 1923: x_return_status := FND_API.G_RET_STS_SUCCESS;

1919: )
1920: IS
1921:
1922: BEGIN
1923: x_return_status := FND_API.G_RET_STS_SUCCESS;
1924:
1925: FND_MSG_PUB.Initialize;
1926:
1927: UPDATE bsc_sys_datasets_tl

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

1931: ,source_lang = userenv('LANG')
1932: WHERE dataset_id = p_Dataset_Rec.Bsc_Dataset_Id
1933: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
1934:
1935: IF (p_commit = FND_API.G_TRUE) THEN
1936: COMMIT;
1937: END IF;
1938:
1939: EXCEPTION

Line 1940: WHEN FND_API.G_EXC_ERROR THEN

1936: COMMIT;
1937: END IF;
1938:
1939: EXCEPTION
1940: WHEN FND_API.G_EXC_ERROR THEN
1941: x_return_status := FND_API.G_RET_STS_ERROR;
1942: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1943: ,p_data => x_msg_data);
1944: RAISE;

Line 1941: x_return_status := FND_API.G_RET_STS_ERROR;

1937: END IF;
1938:
1939: EXCEPTION
1940: WHEN FND_API.G_EXC_ERROR THEN
1941: x_return_status := FND_API.G_RET_STS_ERROR;
1942: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1943: ,p_data => x_msg_data);
1944: RAISE;
1945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1941: x_return_status := FND_API.G_RET_STS_ERROR;
1942: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1943: ,p_data => x_msg_data);
1944: RAISE;
1945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1947: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1948: ,p_data => x_msg_data);
1949: RAISE;

Line 1946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1942: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1943: ,p_data => x_msg_data);
1944: RAISE;
1945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1947: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1948: ,p_data => x_msg_data);
1949: RAISE;
1950: WHEN NO_DATA_FOUND THEN

Line 1951: x_return_status := FND_API.G_RET_STS_ERROR;

1947: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1948: ,p_data => x_msg_data);
1949: RAISE;
1950: WHEN NO_DATA_FOUND THEN
1951: x_return_status := FND_API.G_RET_STS_ERROR;
1952: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1953: ,p_data => x_msg_data);
1954: RAISE;
1955: WHEN OTHERS THEN

Line 1956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1952: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1953: ,p_data => x_msg_data);
1954: RAISE;
1955: WHEN OTHERS THEN
1956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1957: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1958: ,p_data => x_msg_data);
1959: RAISE;
1960:

Line 1979: x_return_status := FND_API.G_RET_STS_SUCCESS;

1975:
1976: BEGIN
1977: SAVEPOINT TransMeasByLangBsc;
1978:
1979: x_return_status := FND_API.G_RET_STS_SUCCESS;
1980:
1981: FND_MSG_PUB.Initialize;
1982:
1983: UPDATE BSC_SYS_DATASETS_TL

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

1987: ,source_lang = p_source_lang
1988: WHERE dataset_id = p_Dataset_Rec.Bsc_Dataset_Id
1989: and LANGUAGE = p_lang;
1990:
1991: IF (p_commit = FND_API.G_TRUE) THEN
1992: COMMIT;
1993: END IF;
1994:
1995: EXCEPTION

Line 1996: WHEN FND_API.G_EXC_ERROR THEN

1992: COMMIT;
1993: END IF;
1994:
1995: EXCEPTION
1996: WHEN FND_API.G_EXC_ERROR THEN
1997: ROLLBACK TO TransMeasByLangBsc;
1998: x_return_status := FND_API.G_RET_STS_ERROR;
1999: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2000: ,p_data => x_msg_data);

Line 1998: x_return_status := FND_API.G_RET_STS_ERROR;

1994:
1995: EXCEPTION
1996: WHEN FND_API.G_EXC_ERROR THEN
1997: ROLLBACK TO TransMeasByLangBsc;
1998: x_return_status := FND_API.G_RET_STS_ERROR;
1999: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2000: ,p_data => x_msg_data);
2001: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2002: ROLLBACK TO TransMeasByLangBsc;

Line 2001: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1997: ROLLBACK TO TransMeasByLangBsc;
1998: x_return_status := FND_API.G_RET_STS_ERROR;
1999: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2000: ,p_data => x_msg_data);
2001: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2002: ROLLBACK TO TransMeasByLangBsc;
2003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2004: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2005: ,p_data => x_msg_data);

Line 2003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1999: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2000: ,p_data => x_msg_data);
2001: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2002: ROLLBACK TO TransMeasByLangBsc;
2003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2004: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2005: ,p_data => x_msg_data);
2006: WHEN NO_DATA_FOUND THEN
2007: ROLLBACK TO TransMeasByLangBsc;

Line 2008: x_return_status := FND_API.G_RET_STS_ERROR;

2004: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2005: ,p_data => x_msg_data);
2006: WHEN NO_DATA_FOUND THEN
2007: ROLLBACK TO TransMeasByLangBsc;
2008: x_return_status := FND_API.G_RET_STS_ERROR;
2009: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2010: ,p_data => x_msg_data);
2011: WHEN OTHERS THEN
2012: ROLLBACK TO TransMeasByLangBsc;

Line 2013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2009: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2010: ,p_data => x_msg_data);
2011: WHEN OTHERS THEN
2012: ROLLBACK TO TransMeasByLangBsc;
2013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2014: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2015: ,p_data => x_msg_data);
2016:
2017: END Translate_Measure_By_Lang;