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_SCORECARD_PVT dependencies on BSC_SCORECARD_PVT

Line 1: package body BSC_SCORECARD_PVT as

1: package body BSC_SCORECARD_PVT as
2: /* $Header: BSCVTABB.pls 120.0.12000000.2 2007/05/31 07:42:53 ashankar ship $ */
3: /*
4: +======================================================================================+
5: | Copyright (c) 2001 Oracle Corporation, Redwood Shores, CA, USA |

Line 36: G_PKG_NAME CONSTANT varchar2(30) := 'BSC_SCORECARD_PVT';

32: | 29-Mar-2005 kyadamak bug#4268439
33: | 30-May-2007 ashankar ER#TGSS 5844382 |
34: +======================================================================================+
35: */
36: G_PKG_NAME CONSTANT varchar2(30) := 'BSC_SCORECARD_PVT';
37: g_db_object varchar2(30) := null;
38:
39: procedure Create_Tab(
40: p_commit IN varchar2 := FND_API.G_FALSE

Line 223: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Create_Tab ';

219: WHEN NO_DATA_FOUND THEN
220: ROLLBACK TO CreateBSCTabPVT;
221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
222: IF (x_msg_data IS NOT NULL) THEN
223: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Create_Tab ';
224: ELSE
225: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Create_Tab ';
226: END IF;
227: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 225: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Create_Tab ';

221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
222: IF (x_msg_data IS NOT NULL) THEN
223: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Create_Tab ';
224: ELSE
225: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Create_Tab ';
226: END IF;
227: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
228: RAISE;
229: WHEN OTHERS THEN

Line 233: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Create_Tab ';

229: WHEN OTHERS THEN
230: ROLLBACK TO CreateBSCTabPVT;
231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
232: IF (x_msg_data IS NOT NULL) THEN
233: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Create_Tab ';
234: ELSE
235: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Create_Tab ';
236: END IF;
237: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 235: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Create_Tab ';

231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
232: IF (x_msg_data IS NOT NULL) THEN
233: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Create_Tab ';
234: ELSE
235: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Create_Tab ';
236: END IF;
237: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
238: RAISE;
239: end Create_Tab;

Line 331: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Retrieve_Tab ';

327: RAISE;
328: WHEN NO_DATA_FOUND THEN
329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
330: IF (x_msg_data IS NOT NULL) THEN
331: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Retrieve_Tab ';
332: ELSE
333: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Retrieve_Tab ';
334: END IF;
335: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 333: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Retrieve_Tab ';

329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
330: IF (x_msg_data IS NOT NULL) THEN
331: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Retrieve_Tab ';
332: ELSE
333: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Retrieve_Tab ';
334: END IF;
335: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
336: RAISE;
337: WHEN OTHERS THEN

Line 340: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Retrieve_Tab ';

336: RAISE;
337: WHEN OTHERS THEN
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
339: IF (x_msg_data IS NOT NULL) THEN
340: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Retrieve_Tab ';
341: ELSE
342: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Retrieve_Tab ';
343: END IF;
344: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 342: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Retrieve_Tab ';

338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
339: IF (x_msg_data IS NOT NULL) THEN
340: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Retrieve_Tab ';
341: ELSE
342: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Retrieve_Tab ';
343: END IF;
344: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
345: RAISE;
346:

Line 555: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Update_Tab ';

551: WHEN NO_DATA_FOUND THEN
552: ROLLBACK TO UpdateBSCTabPVT;
553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
554: IF (x_msg_data IS NOT NULL) THEN
555: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Update_Tab ';
556: ELSE
557: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Update_Tab ';
558: END IF;
559: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 557: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Update_Tab ';

553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
554: IF (x_msg_data IS NOT NULL) THEN
555: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Update_Tab ';
556: ELSE
557: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Update_Tab ';
558: END IF;
559: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
560: RAISE;
561: WHEN OTHERS THEN

Line 565: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Update_Tab ';

561: WHEN OTHERS THEN
562: ROLLBACK TO UpdateBSCTabPVT;
563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
564: IF (x_msg_data IS NOT NULL) THEN
565: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Update_Tab ';
566: ELSE
567: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Update_Tab ';
568: END IF;
569: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 567: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Update_Tab ';

563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
564: IF (x_msg_data IS NOT NULL) THEN
565: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Update_Tab ';
566: ELSE
567: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Update_Tab ';
568: END IF;
569: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
570: RAISE;
571:

Line 799: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Delete_Tab ';

795: END IF;
796:
797: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
798: IF (x_msg_data IS NOT NULL) THEN
799: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Delete_Tab ';
800: ELSE
801: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Delete_Tab ';
802: END IF;
803: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 801: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Delete_Tab ';

797: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
798: IF (x_msg_data IS NOT NULL) THEN
799: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Delete_Tab ';
800: ELSE
801: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Delete_Tab ';
802: END IF;
803: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
804: RAISE;
805: WHEN OTHERS THEN

Line 813: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Delete_Tab ';

809: END IF;
810:
811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
812: IF (x_msg_data IS NOT NULL) THEN
813: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Delete_Tab ';
814: ELSE
815: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Delete_Tab ';
816: END IF;
817: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 815: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Delete_Tab ';

811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
812: IF (x_msg_data IS NOT NULL) THEN
813: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Delete_Tab ';
814: ELSE
815: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Delete_Tab ';
816: END IF;
817: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
818: RAISE;
819:

Line 907: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Create_Tab_Access ';

903: WHEN NO_DATA_FOUND THEN
904: ROLLBACK TO CreateBSCTabAccessPVT;
905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
906: IF (x_msg_data IS NOT NULL) THEN
907: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Create_Tab_Access ';
908: ELSE
909: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Create_Tab_Access ';
910: END IF;
911: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 909: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Create_Tab_Access ';

905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
906: IF (x_msg_data IS NOT NULL) THEN
907: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Create_Tab_Access ';
908: ELSE
909: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Create_Tab_Access ';
910: END IF;
911: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
912: RAISE;
913: WHEN OTHERS THEN

Line 917: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Create_Tab_Access ';

913: WHEN OTHERS THEN
914: ROLLBACK TO CreateBSCTabAccessPVT;
915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
916: IF (x_msg_data IS NOT NULL) THEN
917: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Create_Tab_Access ';
918: ELSE
919: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Create_Tab_Access ';
920: END IF;
921: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 919: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Create_Tab_Access ';

915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
916: IF (x_msg_data IS NOT NULL) THEN
917: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Create_Tab_Access ';
918: ELSE
919: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Create_Tab_Access ';
920: END IF;
921: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
922: RAISE;
923:

Line 979: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Create_Tab_Grants ';

975: WHEN NO_DATA_FOUND THEN
976: ROLLBACK TO CreateBSCTabGrantsPVT;
977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
978: IF (x_msg_data IS NOT NULL) THEN
979: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Create_Tab_Grants ';
980: ELSE
981: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Create_Tab_Grants ';
982: END IF;
983: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 981: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Create_Tab_Grants ';

977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
978: IF (x_msg_data IS NOT NULL) THEN
979: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Create_Tab_Grants ';
980: ELSE
981: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Create_Tab_Grants ';
982: END IF;
983: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
984: RAISE;
985: WHEN OTHERS THEN

Line 989: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Create_Tab_Grants ';

985: WHEN OTHERS THEN
986: ROLLBACK TO CreateBSCTabGrantsPVT;
987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
988: IF (x_msg_data IS NOT NULL) THEN
989: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Create_Tab_Grants ';
990: ELSE
991: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Create_Tab_Grants ';
992: END IF;
993: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 991: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Create_Tab_Grants ';

987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
988: IF (x_msg_data IS NOT NULL) THEN
989: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Create_Tab_Grants ';
990: ELSE
991: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Create_Tab_Grants ';
992: END IF;
993: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
994: RAISE;
995:

Line 1074: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Move_Tab ';

1070: WHEN NO_DATA_FOUND THEN
1071: ROLLBACK TO MoveBSCTabPVT;
1072: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1073: IF (x_msg_data IS NOT NULL) THEN
1074: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Move_Tab ';
1075: ELSE
1076: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Move_Tab ';
1077: END IF;
1078: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1076: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Move_Tab ';

1072: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1073: IF (x_msg_data IS NOT NULL) THEN
1074: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Move_Tab ';
1075: ELSE
1076: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Move_Tab ';
1077: END IF;
1078: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1079: RAISE;
1080: WHEN OTHERS THEN

Line 1084: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Move_Tab ';

1080: WHEN OTHERS THEN
1081: ROLLBACK TO MoveBSCTabPVT;
1082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1083: IF (x_msg_data IS NOT NULL) THEN
1084: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Move_Tab ';
1085: ELSE
1086: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Move_Tab ';
1087: END IF;
1088: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1086: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Move_Tab ';

1082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1083: IF (x_msg_data IS NOT NULL) THEN
1084: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Move_Tab ';
1085: ELSE
1086: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Move_Tab ';
1087: END IF;
1088: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1089: RAISE;
1090:

Line 1141: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Update_Tab_Time_Stamp ';

1137: WHEN NO_DATA_FOUND THEN
1138: ROLLBACK TO UpdateBSCTabTimStmPVT;
1139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1140: IF (x_msg_data IS NOT NULL) THEN
1141: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Update_Tab_Time_Stamp ';
1142: ELSE
1143: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Update_Tab_Time_Stamp ';
1144: END IF;
1145: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1143: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Update_Tab_Time_Stamp ';

1139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1140: IF (x_msg_data IS NOT NULL) THEN
1141: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Update_Tab_Time_Stamp ';
1142: ELSE
1143: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Update_Tab_Time_Stamp ';
1144: END IF;
1145: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1146: RAISE;
1147: WHEN OTHERS THEN

Line 1151: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Update_Tab_Time_Stamp ';

1147: WHEN OTHERS THEN
1148: ROLLBACK TO UpdateBSCTabTimStmPVT;
1149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1150: IF (x_msg_data IS NOT NULL) THEN
1151: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Update_Tab_Time_Stamp ';
1152: ELSE
1153: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Update_Tab_Time_Stamp ';
1154: END IF;
1155: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1153: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Update_Tab_Time_Stamp ';

1149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1150: IF (x_msg_data IS NOT NULL) THEN
1151: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Update_Tab_Time_Stamp ';
1152: ELSE
1153: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Update_Tab_Time_Stamp ';
1154: END IF;
1155: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1156: RAISE;
1157:

Line 1208: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Update_System_Time_Stamp ';

1204: WHEN NO_DATA_FOUND THEN
1205: ROLLBACK TO UpdateBSCTabSysTimStmPVT;
1206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1207: IF (x_msg_data IS NOT NULL) THEN
1208: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Update_System_Time_Stamp ';
1209: ELSE
1210: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Update_System_Time_Stamp ';
1211: END IF;
1212: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1210: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Update_System_Time_Stamp ';

1206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1207: IF (x_msg_data IS NOT NULL) THEN
1208: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Update_System_Time_Stamp ';
1209: ELSE
1210: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Update_System_Time_Stamp ';
1211: END IF;
1212: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1213: RAISE;
1214: WHEN OTHERS THEN

Line 1218: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Update_System_Time_Stamp ';

1214: WHEN OTHERS THEN
1215: ROLLBACK TO UpdateBSCTabSysTimStmPVT;
1216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1217: IF (x_msg_data IS NOT NULL) THEN
1218: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Update_System_Time_Stamp ';
1219: ELSE
1220: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Update_System_Time_Stamp ';
1221: END IF;
1222: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1220: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Update_System_Time_Stamp ';

1216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1217: IF (x_msg_data IS NOT NULL) THEN
1218: x_msg_data := x_msg_data||' -> BSC_SCORECARD_PVT.Update_System_Time_Stamp ';
1219: ELSE
1220: x_msg_data := SQLERRM||' at BSC_SCORECARD_PVT.Update_System_Time_Stamp ';
1221: END IF;
1222: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1223: RAISE;
1224:

Line 1382: --DBMS_OUTPUT.PUT_LINE('BSC_SCORECARD_PVT.Grant_Scorecard_Access Failed: at FND_GRANTS_DELETE_PKG.GRANT_FUNCTION );

1378: ,x_success => l_success
1379: ,x_errorcode => l_errorcode
1380: );
1381: IF (l_success <> FND_API.G_TRUE) THEN
1382: --DBMS_OUTPUT.PUT_LINE('BSC_SCORECARD_PVT.Grant_Scorecard_Access Failed: at FND_GRANTS_DELETE_PKG.GRANT_FUNCTION );
1383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1384: END IF;
1385:
1386: /****************************************************

Line 1412: --DBMS_OUTPUT.PUT_LINE('BSC_SCORECARD_PVT.Grant_Scorecard_Access Failed: at FND_GRANTS_DELETE_PKG.GRANT_FUNCTION );

1408: ,x_success => l_success
1409: ,x_errorcode => l_errorcode
1410: );
1411: IF (l_success <> FND_API.G_TRUE) THEN
1412: --DBMS_OUTPUT.PUT_LINE('BSC_SCORECARD_PVT.Grant_Scorecard_Access Failed: at FND_GRANTS_DELETE_PKG.GRANT_FUNCTION );
1413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1414: END IF;
1415: END IF;
1416: END LOOP;

Line 1423: , x_source => 'BSC_SCORECARD_PVT.Insert_Scorecard_Grants'

1419: EXCEPTION
1420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1421: BSC_MESSAGE.Add
1422: ( x_message => SQLERRM
1423: , x_source => 'BSC_SCORECARD_PVT.Insert_Scorecard_Grants'
1424: , x_mode => 'I'
1425: );
1426:
1427:

Line 1431: , x_source => 'BSC_SCORECARD_PVT.Insert_Scorecard_Grants'

1427:
1428: WHEN FND_API.G_EXC_ERROR THEN
1429: BSC_MESSAGE.Add
1430: ( x_message => SQLERRM
1431: , x_source => 'BSC_SCORECARD_PVT.Insert_Scorecard_Grants'
1432: , x_mode => 'I'
1433: );
1434:
1435: WHEN OTHERS THEN

Line 1438: , x_source => 'BSC_SCORECARD_PVT.Insert_Scorecard_Grants'

1434:
1435: WHEN OTHERS THEN
1436: BSC_MESSAGE.Add
1437: ( x_message => SQLERRM
1438: , x_source => 'BSC_SCORECARD_PVT.Insert_Scorecard_Grants'
1439: , x_mode => 'I'
1440: );
1441:
1442: END Insert_Scorecard_Grants;

Line 1498: --DBMS_OUTPUT.PUT_LINE('BSC_SCORECARD_PVT.Remove_Scorecard_Grants Failed: at FND_GRANTS_DELETE_PKG.delete_grant );

1494: , x_errcode => l_errorcode
1495: );
1496:
1497: IF (l_success <> FND_API.G_TRUE) THEN
1498: --DBMS_OUTPUT.PUT_LINE('BSC_SCORECARD_PVT.Remove_Scorecard_Grants Failed: at FND_GRANTS_DELETE_PKG.delete_grant );
1499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1500: END IF;
1501: END LOOP; */
1502:

Line 1519: , x_source => 'BSC_SCORECARD_PVT.Remove_Scorecard_Grants'

1515: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1516: BSC_MESSAGE.Add
1517: (
1518: x_message => SQLERRM
1519: , x_source => 'BSC_SCORECARD_PVT.Remove_Scorecard_Grants'
1520: , x_mode => 'I'
1521: );
1522:
1523: WHEN OTHERS THEN

Line 1527: , x_source => 'BSC_SCORECARD_PVT.Remove_Scorecard_Grants'

1523: WHEN OTHERS THEN
1524: BSC_MESSAGE.Add
1525: (
1526: x_message => SQLERRM
1527: , x_source => 'BSC_SCORECARD_PVT.Remove_Scorecard_Grants'
1528: , x_mode => 'I'
1529:
1530: );
1531: END Remove_Scorecard_Grants;

Line 1593: end BSC_SCORECARD_PVT;

1589: ELSE
1590: RETURN FALSE;
1591: END IF;
1592: END Is_More;
1593: end BSC_SCORECARD_PVT;