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

Line 68: x_return_status := FND_API.G_RET_STS_SUCCESS;

64: WHERE TABLE_NAME = c_table_name;
65:
66: BEGIN
67: --DBMS_OUTPUT.PUT_LINE('VALIDATE_OBJECT: '||p_object_key||' '||p_object_type);
68: x_return_status := FND_API.G_RET_STS_SUCCESS;
69:
70: l_valid := 0;
71: IF (UPPER(p_object_type) = 'SCORECARD') THEN
72: l_object_key1 := TO_NUMBER(p_object_key);

Line 149: RAISE FND_API.G_EXC_ERROR;

145: IF (l_valid <> 1) THEN
146: --DBMS_OUTPUT.PUT_LINE('OBJECT NOT VALID');
147: FND_MESSAGE.SET_NAME('BSC','BSC_LOCK_ERR_INVALID');
148: FND_MSG_PUB.ADD;
149: RAISE FND_API.G_EXC_ERROR;
150: END IF;
151: --DBMS_OUTPUT.PUT_LINE('OBJECT VALID');
152:
153: EXCEPTION

Line 154: WHEN FND_API.G_EXC_ERROR THEN

150: END IF;
151: --DBMS_OUTPUT.PUT_LINE('OBJECT VALID');
152:
153: EXCEPTION
154: WHEN FND_API.G_EXC_ERROR THEN
155: x_return_status := FND_API.G_RET_STS_ERROR;
156: FND_MSG_PUB.Count_And_Get(
157: p_encoded => 'F'
158: ,p_count => x_msg_count

Line 155: x_return_status := FND_API.G_RET_STS_ERROR;

151: --DBMS_OUTPUT.PUT_LINE('OBJECT VALID');
152:
153: EXCEPTION
154: WHEN FND_API.G_EXC_ERROR THEN
155: x_return_status := FND_API.G_RET_STS_ERROR;
156: FND_MSG_PUB.Count_And_Get(
157: p_encoded => 'F'
158: ,p_count => x_msg_count
159: ,p_data => x_msg_data

Line 162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

158: ,p_count => x_msg_count
159: ,p_data => x_msg_data
160: );
161: RAISE;
162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
164: FND_MSG_PUB.Count_And_Get(
165: p_encoded => 'F'
166: ,p_count => x_msg_count

Line 163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

159: ,p_data => x_msg_data
160: );
161: RAISE;
162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
164: FND_MSG_PUB.Count_And_Get(
165: p_encoded => 'F'
166: ,p_count => x_msg_count
167: ,p_data => x_msg_data

Line 176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

172: G_PKG_NAME,
173: l_api_name,
174: SQLERRM
175: );
176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
177: FND_MSG_PUB.Count_And_Get(
178: p_encoded => 'F'
179: ,p_count => x_msg_count
180: ,p_data => x_msg_data

Line 182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

178: p_encoded => 'F'
179: ,p_count => x_msg_count
180: ,p_data => x_msg_data
181: );
182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
183: END VALIDATE_OBJECT;
184:
185:
186: /*------------------------------------------------------------------------------------------

Line 251: x_return_status := FND_API.G_RET_STS_SUCCESS;

247: AND LOCK_TYPE = 'W';
248:
249: BEGIN
250: --DBMS_OUTPUT.PUT_LINE('LOCK_OBJECT: '||p_object_key||' '||p_object_type);
251: x_return_status := FND_API.G_RET_STS_SUCCESS;
252: l_last_save_time := NULL;
253:
254: IF (p_lock_type = 'R') THEN
255: l_last_save_time :=

Line 304: WHEN FND_API.G_EXC_ERROR THEN

300: END IF;
301: RETURN l_last_save_time;
302:
303: EXCEPTION
304: WHEN FND_API.G_EXC_ERROR THEN
305: x_return_status := FND_API.G_RET_STS_ERROR;
306: FND_MSG_PUB.Count_And_Get(
307: p_encoded => 'F'
308: ,p_count => x_msg_count

Line 305: x_return_status := FND_API.G_RET_STS_ERROR;

301: RETURN l_last_save_time;
302:
303: EXCEPTION
304: WHEN FND_API.G_EXC_ERROR THEN
305: x_return_status := FND_API.G_RET_STS_ERROR;
306: FND_MSG_PUB.Count_And_Get(
307: p_encoded => 'F'
308: ,p_count => x_msg_count
309: ,p_data => x_msg_data

Line 312: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

308: ,p_count => x_msg_count
309: ,p_data => x_msg_data
310: );
311: RAISE;
312: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
314: FND_MSG_PUB.Count_And_Get(
315: p_encoded => 'F'
316: ,p_count => x_msg_count

Line 313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

309: ,p_data => x_msg_data
310: );
311: RAISE;
312: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
314: FND_MSG_PUB.Count_And_Get(
315: p_encoded => 'F'
316: ,p_count => x_msg_count
317: ,p_data => x_msg_data

Line 326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

322: G_PKG_NAME,
323: l_api_name,
324: SQLERRM
325: );
326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
327: FND_MSG_PUB.Count_And_Get(
328: p_encoded => 'F'
329: ,p_count => x_msg_count
330: ,p_data => x_msg_data

Line 332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

328: p_encoded => 'F'
329: ,p_count => x_msg_count
330: ,p_data => x_msg_data
331: );
332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
333: END LOCK_OBJECT;
334:
335:
336: /*------------------------------------------------------------------------------------------

Line 391: x_return_status := FND_API.G_RET_STS_SUCCESS;

387: WHERE OBJECT_TYPE = c_object_type;
388:
389: BEGIN
390: --DBMS_OUTPUT.PUT_LINE('LOCK_OBJECT: '||p_object_type);
391: x_return_status := FND_API.G_RET_STS_SUCCESS;
392: l_last_save_time := NULL;
393:
394: -- Lock the top level object
395: FOR cobj IN c_get_object(p_object_type) LOOP

Line 589: WHEN FND_API.G_EXC_ERROR THEN

585: END IF;
586: END IF;
587:
588: EXCEPTION
589: WHEN FND_API.G_EXC_ERROR THEN
590: x_return_status := FND_API.G_RET_STS_ERROR;
591: FND_MSG_PUB.Count_And_Get(
592: p_encoded => 'F'
593: ,p_count => x_msg_count

Line 590: x_return_status := FND_API.G_RET_STS_ERROR;

586: END IF;
587:
588: EXCEPTION
589: WHEN FND_API.G_EXC_ERROR THEN
590: x_return_status := FND_API.G_RET_STS_ERROR;
591: FND_MSG_PUB.Count_And_Get(
592: p_encoded => 'F'
593: ,p_count => x_msg_count
594: ,p_data => x_msg_data

Line 597: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

593: ,p_count => x_msg_count
594: ,p_data => x_msg_data
595: );
596: RAISE;
597: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
599: FND_MSG_PUB.Count_And_Get(
600: p_encoded => 'F'
601: ,p_count => x_msg_count

Line 598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

594: ,p_data => x_msg_data
595: );
596: RAISE;
597: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
599: FND_MSG_PUB.Count_And_Get(
600: p_encoded => 'F'
601: ,p_count => x_msg_count
602: ,p_data => x_msg_data

Line 611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

607: G_PKG_NAME,
608: l_api_name,
609: SQLERRM
610: );
611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
612: FND_MSG_PUB.Count_And_Get(
613: p_encoded => 'F'
614: ,p_count => x_msg_count
615: ,p_data => x_msg_data

Line 617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

613: p_encoded => 'F'
614: ,p_count => x_msg_count
615: ,p_data => x_msg_data
616: );
617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
618: END LOCK_OBJECT;
619:
620:
621: /*------------------------------------------------------------------------------------------

Line 683: x_return_status := FND_API.G_RET_STS_SUCCESS;

679: FOR UPDATE NOWAIT;
680:
681: BEGIN
682: --DBMS_OUTPUT.PUT_LINE('LOCK_OBJECT_WRITE: '||p_object_key||' '||p_object_type);
683: x_return_status := FND_API.G_RET_STS_SUCCESS;
684: l_last_save_time := NULL;
685: l_insert_flag := TRUE;
686:
687: -- Lock the object

Line 775: WHEN FND_API.G_EXC_ERROR THEN

771: END IF;
772: RETURN l_last_save_time;
773:
774: EXCEPTION
775: WHEN FND_API.G_EXC_ERROR THEN
776: x_return_status := FND_API.G_RET_STS_ERROR;
777: FND_MSG_PUB.Count_And_Get(
778: p_encoded => 'F'
779: ,p_count => x_msg_count

Line 776: x_return_status := FND_API.G_RET_STS_ERROR;

772: RETURN l_last_save_time;
773:
774: EXCEPTION
775: WHEN FND_API.G_EXC_ERROR THEN
776: x_return_status := FND_API.G_RET_STS_ERROR;
777: FND_MSG_PUB.Count_And_Get(
778: p_encoded => 'F'
779: ,p_count => x_msg_count
780: ,p_data => x_msg_data

Line 783: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

779: ,p_count => x_msg_count
780: ,p_data => x_msg_data
781: );
782: RAISE;
783: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
785: FND_MSG_PUB.Count_And_Get(
786: p_encoded => 'F'
787: ,p_count => x_msg_count

Line 784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

780: ,p_data => x_msg_data
781: );
782: RAISE;
783: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
785: FND_MSG_PUB.Count_And_Get(
786: p_encoded => 'F'
787: ,p_count => x_msg_count
788: ,p_data => x_msg_data

Line 797: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

793: G_PKG_NAME,
794: l_api_name,
795: SQLERRM
796: );
797: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
798: FND_MSG_PUB.Count_And_Get(
799: p_encoded => 'F'
800: ,p_count => x_msg_count
801: ,p_data => x_msg_data

Line 803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

799: p_encoded => 'F'
800: ,p_count => x_msg_count
801: ,p_data => x_msg_data
802: );
803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
804: END LOCK_OBJECT_WRITE;
805:
806:
807: /*------------------------------------------------------------------------------------------

Line 871: x_return_status := FND_API.G_RET_STS_SUCCESS;

867: FOR UPDATE NOWAIT;
868:
869: BEGIN
870: --DBMS_OUTPUT.PUT_LINE('LOCK_OBJECT_WRITE: '||p_object_key||' '||p_object_type);
871: x_return_status := FND_API.G_RET_STS_SUCCESS;
872:
873: l_last_save_time := NULL;
874: x_insert_flag := TRUE;
875: BEGIN

Line 907: WHEN FND_API.G_EXC_ERROR THEN

903: END;
904: RETURN l_last_save_time;
905:
906: EXCEPTION
907: WHEN FND_API.G_EXC_ERROR THEN
908: x_return_status := FND_API.G_RET_STS_ERROR;
909: FND_MSG_PUB.Count_And_Get(
910: p_encoded => 'F'
911: ,p_count => x_msg_count

Line 908: x_return_status := FND_API.G_RET_STS_ERROR;

904: RETURN l_last_save_time;
905:
906: EXCEPTION
907: WHEN FND_API.G_EXC_ERROR THEN
908: x_return_status := FND_API.G_RET_STS_ERROR;
909: FND_MSG_PUB.Count_And_Get(
910: p_encoded => 'F'
911: ,p_count => x_msg_count
912: ,p_data => x_msg_data

Line 915: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

911: ,p_count => x_msg_count
912: ,p_data => x_msg_data
913: );
914: RAISE;
915: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
916: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
917: FND_MSG_PUB.Count_And_Get(
918: p_encoded => 'F'
919: ,p_count => x_msg_count

Line 916: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

912: ,p_data => x_msg_data
913: );
914: RAISE;
915: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
916: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
917: FND_MSG_PUB.Count_And_Get(
918: p_encoded => 'F'
919: ,p_count => x_msg_count
920: ,p_data => x_msg_data

Line 929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

925: G_PKG_NAME,
926: l_api_name,
927: SQLERRM
928: );
929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
930: FND_MSG_PUB.Count_And_Get(
931: p_encoded => 'F'
932: ,p_count => x_msg_count
933: ,p_data => x_msg_data

Line 935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

931: p_encoded => 'F'
932: ,p_count => x_msg_count
933: ,p_data => x_msg_data
934: );
935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
936: END LOCK_OBJECT_WRITE;
937:
938:
939: /*------------------------------------------------------------------------------------------

Line 1025: x_return_status := FND_API.G_RET_STS_SUCCESS;

1021: AND LOCK_TYPE = 'W';
1022:
1023: BEGIN
1024: --DBMS_OUTPUT.PUT_LINE('LOCK_OBJECT_READ: '||p_object_key||' '||p_object_type);
1025: x_return_status := FND_API.G_RET_STS_SUCCESS;
1026: l_last_save_time := NULL;
1027: l_insert_flag := TRUE;
1028: l_count := 0;
1029:

Line 1152: WHEN FND_API.G_EXC_ERROR THEN

1148: CLOSE c_get_last_save_time;
1149: RETURN l_last_save_time;
1150:
1151: EXCEPTION
1152: WHEN FND_API.G_EXC_ERROR THEN
1153: x_return_status := FND_API.G_RET_STS_ERROR;
1154: FND_MSG_PUB.Count_And_Get(
1155: p_encoded => 'F'
1156: ,p_count => x_msg_count

Line 1153: x_return_status := FND_API.G_RET_STS_ERROR;

1149: RETURN l_last_save_time;
1150:
1151: EXCEPTION
1152: WHEN FND_API.G_EXC_ERROR THEN
1153: x_return_status := FND_API.G_RET_STS_ERROR;
1154: FND_MSG_PUB.Count_And_Get(
1155: p_encoded => 'F'
1156: ,p_count => x_msg_count
1157: ,p_data => x_msg_data

Line 1160: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1156: ,p_count => x_msg_count
1157: ,p_data => x_msg_data
1158: );
1159: RAISE;
1160: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1162: FND_MSG_PUB.Count_And_Get(
1163: p_encoded => 'F'
1164: ,p_count => x_msg_count

Line 1161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1157: ,p_data => x_msg_data
1158: );
1159: RAISE;
1160: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1162: FND_MSG_PUB.Count_And_Get(
1163: p_encoded => 'F'
1164: ,p_count => x_msg_count
1165: ,p_data => x_msg_data

Line 1174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1170: G_PKG_NAME,
1171: l_api_name,
1172: SQLERRM
1173: );
1174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1175: FND_MSG_PUB.Count_And_Get(
1176: p_encoded => 'F'
1177: ,p_count => x_msg_count
1178: ,p_data => x_msg_data

Line 1180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1176: p_encoded => 'F'
1177: ,p_count => x_msg_count
1178: ,p_data => x_msg_data
1179: );
1180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1181: END LOCK_OBJECT_READ;
1182:
1183:
1184: /*------------------------------------------------------------------------------------------

Line 1225: x_return_status := FND_API.G_RET_STS_SUCCESS;

1221: FOR UPDATE NOWAIT;
1222:
1223: BEGIN
1224: --DBMS_OUTPUT.PUT_LINE('LOCK_OBJECT_ALL');
1225: x_return_status := FND_API.G_RET_STS_SUCCESS;
1226: l_exception_flag := FALSE;
1227:
1228: -- Lock the user entry for the top level object
1229: BEGIN

Line 1274: WHEN FND_API.G_EXC_ERROR THEN

1270: );
1271: END IF;
1272:
1273: EXCEPTION
1274: WHEN FND_API.G_EXC_ERROR THEN
1275: x_return_status := FND_API.G_RET_STS_ERROR;
1276: FND_MSG_PUB.Count_And_Get(
1277: p_encoded => 'F'
1278: ,p_count => x_msg_count

Line 1275: x_return_status := FND_API.G_RET_STS_ERROR;

1271: END IF;
1272:
1273: EXCEPTION
1274: WHEN FND_API.G_EXC_ERROR THEN
1275: x_return_status := FND_API.G_RET_STS_ERROR;
1276: FND_MSG_PUB.Count_And_Get(
1277: p_encoded => 'F'
1278: ,p_count => x_msg_count
1279: ,p_data => x_msg_data

Line 1282: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1278: ,p_count => x_msg_count
1279: ,p_data => x_msg_data
1280: );
1281: RAISE;
1282: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1284: FND_MSG_PUB.Count_And_Get(
1285: p_encoded => 'F'
1286: ,p_count => x_msg_count

Line 1283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1279: ,p_data => x_msg_data
1280: );
1281: RAISE;
1282: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1284: FND_MSG_PUB.Count_And_Get(
1285: p_encoded => 'F'
1286: ,p_count => x_msg_count
1287: ,p_data => x_msg_data

Line 1296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1292: G_PKG_NAME,
1293: l_api_name,
1294: SQLERRM
1295: );
1296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1297: FND_MSG_PUB.Count_And_Get(
1298: p_encoded => 'F'
1299: ,p_count => x_msg_count
1300: ,p_data => x_msg_data

Line 1302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1298: p_encoded => 'F'
1299: ,p_count => x_msg_count
1300: ,p_data => x_msg_data
1301: );
1302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1303: END LOCK_OBJECT_ALL;
1304:
1305:
1306: /*------------------------------------------------------------------------------------------

Line 1364: x_return_status := FND_API.G_RET_STS_SUCCESS;

1360: FOR UPDATE NOWAIT;
1361:
1362: BEGIN
1363: --DBMS_OUTPUT.PUT_LINE('LOCK_USER: '||p_object_key||' '||p_object_type||' '||p_user_type);
1364: x_return_status := FND_API.G_RET_STS_SUCCESS;
1365:
1366: l_user_id := NULL;
1367: BEGIN
1368: OPEN c_lock_user(p_object_key, p_object_type, p_user_type);

Line 1432: WHEN FND_API.G_EXC_ERROR THEN

1428: -- );
1429: --END IF;
1430:
1431: EXCEPTION
1432: WHEN FND_API.G_EXC_ERROR THEN
1433: x_return_status := FND_API.G_RET_STS_ERROR;
1434: FND_MSG_PUB.Count_And_Get(
1435: p_encoded => 'F'
1436: ,p_count => x_msg_count

Line 1433: x_return_status := FND_API.G_RET_STS_ERROR;

1429: --END IF;
1430:
1431: EXCEPTION
1432: WHEN FND_API.G_EXC_ERROR THEN
1433: x_return_status := FND_API.G_RET_STS_ERROR;
1434: FND_MSG_PUB.Count_And_Get(
1435: p_encoded => 'F'
1436: ,p_count => x_msg_count
1437: ,p_data => x_msg_data

Line 1440: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1436: ,p_count => x_msg_count
1437: ,p_data => x_msg_data
1438: );
1439: RAISE;
1440: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1442: FND_MSG_PUB.Count_And_Get(
1443: p_encoded => 'F'
1444: ,p_count => x_msg_count

Line 1441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1437: ,p_data => x_msg_data
1438: );
1439: RAISE;
1440: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1442: FND_MSG_PUB.Count_And_Get(
1443: p_encoded => 'F'
1444: ,p_count => x_msg_count
1445: ,p_data => x_msg_data

Line 1454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1450: G_PKG_NAME,
1451: l_api_name,
1452: SQLERRM
1453: );
1454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1455: FND_MSG_PUB.Count_And_Get(
1456: p_encoded => 'F'
1457: ,p_count => x_msg_count
1458: ,p_data => x_msg_data

Line 1460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1456: p_encoded => 'F'
1457: ,p_count => x_msg_count
1458: ,p_data => x_msg_data
1459: );
1460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1461: END LOCK_USER;
1462:
1463:
1464: /*------------------------------------------------------------------------------------------

Line 1572: x_return_status := FND_API.G_RET_STS_SUCCESS;

1568: BEGIN
1569: --DBMS_OUTPUT.PUT_LINE('GET_CHILD_OBJECTS: '||p_object_key||' '||p_object_type);
1570: --DBMS_OUTPUT.PUT_LINE('p_cascade_lock_level='||TO_CHAR(p_cascade_lock_level));
1571: --DBMS_OUTPUT.PUT_LINE('p_lowest_level_type='||p_lowest_level_type);
1572: x_return_status := FND_API.G_RET_STS_SUCCESS;
1573: l_initial_count := x_child_object_count;
1574: l_cascade_lock_level := p_cascade_lock_level;
1575:
1576: IF ((p_lowest_level_type IS NULL OR p_object_type <> p_lowest_level_type) AND l_cascade_lock_level <> 0) THEN

Line 1669: WHEN FND_API.G_EXC_ERROR THEN

1665: END LOOP;
1666: END IF;
1667:
1668: EXCEPTION
1669: WHEN FND_API.G_EXC_ERROR THEN
1670: x_return_status := FND_API.G_RET_STS_ERROR;
1671: FND_MSG_PUB.Count_And_Get(
1672: p_encoded => 'F'
1673: ,p_count => x_msg_count

Line 1670: x_return_status := FND_API.G_RET_STS_ERROR;

1666: END IF;
1667:
1668: EXCEPTION
1669: WHEN FND_API.G_EXC_ERROR THEN
1670: x_return_status := FND_API.G_RET_STS_ERROR;
1671: FND_MSG_PUB.Count_And_Get(
1672: p_encoded => 'F'
1673: ,p_count => x_msg_count
1674: ,p_data => x_msg_data

Line 1677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1673: ,p_count => x_msg_count
1674: ,p_data => x_msg_data
1675: );
1676: RAISE;
1677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1679: FND_MSG_PUB.Count_And_Get(
1680: p_encoded => 'F'
1681: ,p_count => x_msg_count

Line 1678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1674: ,p_data => x_msg_data
1675: );
1676: RAISE;
1677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1679: FND_MSG_PUB.Count_And_Get(
1680: p_encoded => 'F'
1681: ,p_count => x_msg_count
1682: ,p_data => x_msg_data

Line 1691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1687: G_PKG_NAME,
1688: l_api_name,
1689: SQLERRM
1690: );
1691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1692: FND_MSG_PUB.Count_And_Get(
1693: p_encoded => 'F'
1694: ,p_count => x_msg_count
1695: ,p_data => x_msg_data

Line 1697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1693: p_encoded => 'F'
1694: ,p_count => x_msg_count
1695: ,p_data => x_msg_data
1696: );
1697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1698: END GET_CHILD_OBJECTS;
1699:
1700:
1701: /*------------------------------------------------------------------------------------------

Line 1742: x_return_status := FND_API.G_RET_STS_SUCCESS;

1738: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_LOCK_ALL';
1739:
1740: BEGIN
1741: --DBMS_OUTPUT.PUT_LINE('INSERT_LOCK_ALL: '||p_object_type);
1742: x_return_status := FND_API.G_RET_STS_SUCCESS;
1743:
1744: BSC_LOCKS_PVT.INSERT_LOCK_INFO
1745: (
1746: p_object_key => 'ALL'

Line 1783: WHEN FND_API.G_EXC_ERROR THEN

1779: ,x_msg_data => x_msg_data
1780: );
1781:
1782: EXCEPTION
1783: WHEN FND_API.G_EXC_ERROR THEN
1784: x_return_status := FND_API.G_RET_STS_ERROR;
1785: FND_MSG_PUB.Count_And_Get(
1786: p_encoded => 'F'
1787: ,p_count => x_msg_count

Line 1784: x_return_status := FND_API.G_RET_STS_ERROR;

1780: );
1781:
1782: EXCEPTION
1783: WHEN FND_API.G_EXC_ERROR THEN
1784: x_return_status := FND_API.G_RET_STS_ERROR;
1785: FND_MSG_PUB.Count_And_Get(
1786: p_encoded => 'F'
1787: ,p_count => x_msg_count
1788: ,p_data => x_msg_data

Line 1791: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1787: ,p_count => x_msg_count
1788: ,p_data => x_msg_data
1789: );
1790: RAISE;
1791: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1792: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1793: FND_MSG_PUB.Count_And_Get(
1794: p_encoded => 'F'
1795: ,p_count => x_msg_count

Line 1792: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1788: ,p_data => x_msg_data
1789: );
1790: RAISE;
1791: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1792: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1793: FND_MSG_PUB.Count_And_Get(
1794: p_encoded => 'F'
1795: ,p_count => x_msg_count
1796: ,p_data => x_msg_data

Line 1805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1801: G_PKG_NAME,
1802: l_api_name,
1803: SQLERRM
1804: );
1805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1806: FND_MSG_PUB.Count_And_Get(
1807: p_encoded => 'F'
1808: ,p_count => x_msg_count
1809: ,p_data => x_msg_data

Line 1811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1807: p_encoded => 'F'
1808: ,p_count => x_msg_count
1809: ,p_data => x_msg_data
1810: );
1811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1812: END INSERT_LOCK_ALL;
1813:
1814:
1815: /*------------------------------------------------------------------------------------------

Line 1857: x_return_status := FND_API.G_RET_STS_SUCCESS;

1853: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_LOCK_ALL_AUTONOMOUS';
1854:
1855: BEGIN
1856: --DBMS_OUTPUT.PUT_LINE('INSERT_LOCK_ALL_AUTONOMOUS: '||p_object_type);
1857: x_return_status := FND_API.G_RET_STS_SUCCESS;
1858:
1859: BSC_LOCKS_PVT.INSERT_LOCK_ALL
1860: (
1861: p_object_type => p_object_type

Line 1874: WHEN FND_API.G_EXC_ERROR THEN

1870: );
1871: COMMIT;
1872:
1873: EXCEPTION
1874: WHEN FND_API.G_EXC_ERROR THEN
1875: ROLLBACK;
1876: x_return_status := FND_API.G_RET_STS_ERROR;
1877: FND_MSG_PUB.Count_And_Get(
1878: p_encoded => 'F'

Line 1876: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1883: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1881: );
1882: RAISE;
1883: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1884: ROLLBACK;
1885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1886: FND_MSG_PUB.Count_And_Get(
1887: p_encoded => 'F'
1888: ,p_count => x_msg_count
1889: ,p_data => x_msg_data

Line 1899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1895: G_PKG_NAME,
1896: l_api_name,
1897: SQLERRM
1898: );
1899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1900: FND_MSG_PUB.Count_And_Get(
1901: p_encoded => 'F'
1902: ,p_count => x_msg_count
1903: ,p_data => x_msg_data

Line 1905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1901: p_encoded => 'F'
1902: ,p_count => x_msg_count
1903: ,p_data => x_msg_data
1904: );
1905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1906: END INSERT_LOCK_ALL_AUTONOMOUS;
1907:
1908:
1909: /*------------------------------------------------------------------------------------------

Line 1945: x_return_status := FND_API.G_RET_STS_SUCCESS;

1941: l_session_id NUMBER := USERENV('SESSIONID');
1942:
1943: BEGIN
1944: --DBMS_OUTPUT.PUT_LINE('INSERT_LOCK_SCORECARD');
1945: x_return_status := FND_API.G_RET_STS_SUCCESS;
1946: l_object_type := 'SCORECARD';
1947:
1948: -- Insert the ALL entries
1949: BSC_LOCKS_PVT.INSERT_LOCK_ALL

Line 2041: WHEN FND_API.G_EXC_ERROR THEN

2037: FND_GLOBAL.USER_ID
2038: FROM BSC_TABS_B;
2039:
2040: EXCEPTION
2041: WHEN FND_API.G_EXC_ERROR THEN
2042: x_return_status := FND_API.G_RET_STS_ERROR;
2043: FND_MSG_PUB.Count_And_Get(
2044: p_encoded => 'F'
2045: ,p_count => x_msg_count

Line 2042: x_return_status := FND_API.G_RET_STS_ERROR;

2038: FROM BSC_TABS_B;
2039:
2040: EXCEPTION
2041: WHEN FND_API.G_EXC_ERROR THEN
2042: x_return_status := FND_API.G_RET_STS_ERROR;
2043: FND_MSG_PUB.Count_And_Get(
2044: p_encoded => 'F'
2045: ,p_count => x_msg_count
2046: ,p_data => x_msg_data

Line 2049: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2045: ,p_count => x_msg_count
2046: ,p_data => x_msg_data
2047: );
2048: RAISE;
2049: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2051: FND_MSG_PUB.Count_And_Get(
2052: p_encoded => 'F'
2053: ,p_count => x_msg_count

Line 2050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2046: ,p_data => x_msg_data
2047: );
2048: RAISE;
2049: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2051: FND_MSG_PUB.Count_And_Get(
2052: p_encoded => 'F'
2053: ,p_count => x_msg_count
2054: ,p_data => x_msg_data

Line 2063: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2059: G_PKG_NAME,
2060: l_api_name,
2061: SQLERRM
2062: );
2063: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2064: FND_MSG_PUB.Count_And_Get(
2065: p_encoded => 'F'
2066: ,p_count => x_msg_count
2067: ,p_data => x_msg_data

Line 2069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2065: p_encoded => 'F'
2066: ,p_count => x_msg_count
2067: ,p_data => x_msg_data
2068: );
2069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2070: END INSERT_LOCK_SCORECARD;
2071:
2072:
2073: /*------------------------------------------------------------------------------------------

Line 2109: x_return_status := FND_API.G_RET_STS_SUCCESS;

2105: l_session_id NUMBER := USERENV('SESSIONID');
2106:
2107: BEGIN
2108: --DBMS_OUTPUT.PUT_LINE('INSERT_LOCK_OBJECTIVE');
2109: x_return_status := FND_API.G_RET_STS_SUCCESS;
2110: l_object_type := 'OBJECTIVE';
2111:
2112: -- Insert the ALL entries
2113: BSC_LOCKS_PVT.INSERT_LOCK_ALL

Line 2205: WHEN FND_API.G_EXC_ERROR THEN

2201: FND_GLOBAL.USER_ID
2202: FROM BSC_KPIS_B;
2203:
2204: EXCEPTION
2205: WHEN FND_API.G_EXC_ERROR THEN
2206: x_return_status := FND_API.G_RET_STS_ERROR;
2207: FND_MSG_PUB.Count_And_Get(
2208: p_encoded => 'F'
2209: ,p_count => x_msg_count

Line 2206: x_return_status := FND_API.G_RET_STS_ERROR;

2202: FROM BSC_KPIS_B;
2203:
2204: EXCEPTION
2205: WHEN FND_API.G_EXC_ERROR THEN
2206: x_return_status := FND_API.G_RET_STS_ERROR;
2207: FND_MSG_PUB.Count_And_Get(
2208: p_encoded => 'F'
2209: ,p_count => x_msg_count
2210: ,p_data => x_msg_data

Line 2213: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2209: ,p_count => x_msg_count
2210: ,p_data => x_msg_data
2211: );
2212: RAISE;
2213: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2215: FND_MSG_PUB.Count_And_Get(
2216: p_encoded => 'F'
2217: ,p_count => x_msg_count

Line 2214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2210: ,p_data => x_msg_data
2211: );
2212: RAISE;
2213: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2215: FND_MSG_PUB.Count_And_Get(
2216: p_encoded => 'F'
2217: ,p_count => x_msg_count
2218: ,p_data => x_msg_data

Line 2227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2223: G_PKG_NAME,
2224: l_api_name,
2225: SQLERRM
2226: );
2227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2228: FND_MSG_PUB.Count_And_Get(
2229: p_encoded => 'F'
2230: ,p_count => x_msg_count
2231: ,p_data => x_msg_data

Line 2233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2229: p_encoded => 'F'
2230: ,p_count => x_msg_count
2231: ,p_data => x_msg_data
2232: );
2233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2234: END INSERT_LOCK_OBJECTIVE;
2235:
2236:
2237: /*------------------------------------------------------------------------------------------

Line 2273: x_return_status := FND_API.G_RET_STS_SUCCESS;

2269: l_session_id NUMBER := USERENV('SESSIONID');
2270:
2271: BEGIN
2272: --DBMS_OUTPUT.PUT_LINE('INSERT_LOCK_DIMENSION');
2273: x_return_status := FND_API.G_RET_STS_SUCCESS;
2274: l_object_type := 'DIMENSION';
2275:
2276: -- Insert the ALL entries
2277: BSC_LOCKS_PVT.INSERT_LOCK_ALL

Line 2369: WHEN FND_API.G_EXC_ERROR THEN

2365: FND_GLOBAL.USER_ID
2366: FROM BSC_SYS_DIM_GROUPS_TL;
2367:
2368: EXCEPTION
2369: WHEN FND_API.G_EXC_ERROR THEN
2370: x_return_status := FND_API.G_RET_STS_ERROR;
2371: FND_MSG_PUB.Count_And_Get(
2372: p_encoded => 'F'
2373: ,p_count => x_msg_count

Line 2370: x_return_status := FND_API.G_RET_STS_ERROR;

2366: FROM BSC_SYS_DIM_GROUPS_TL;
2367:
2368: EXCEPTION
2369: WHEN FND_API.G_EXC_ERROR THEN
2370: x_return_status := FND_API.G_RET_STS_ERROR;
2371: FND_MSG_PUB.Count_And_Get(
2372: p_encoded => 'F'
2373: ,p_count => x_msg_count
2374: ,p_data => x_msg_data

Line 2377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2373: ,p_count => x_msg_count
2374: ,p_data => x_msg_data
2375: );
2376: RAISE;
2377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2379: FND_MSG_PUB.Count_And_Get(
2380: p_encoded => 'F'
2381: ,p_count => x_msg_count

Line 2378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2374: ,p_data => x_msg_data
2375: );
2376: RAISE;
2377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2379: FND_MSG_PUB.Count_And_Get(
2380: p_encoded => 'F'
2381: ,p_count => x_msg_count
2382: ,p_data => x_msg_data

Line 2391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2387: G_PKG_NAME,
2388: l_api_name,
2389: SQLERRM
2390: );
2391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2392: FND_MSG_PUB.Count_And_Get(
2393: p_encoded => 'F'
2394: ,p_count => x_msg_count
2395: ,p_data => x_msg_data

Line 2397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2393: p_encoded => 'F'
2394: ,p_count => x_msg_count
2395: ,p_data => x_msg_data
2396: );
2397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2398: END INSERT_LOCK_DIMENSION;
2399:
2400:
2401: /*------------------------------------------------------------------------------------------

Line 2437: x_return_status := FND_API.G_RET_STS_SUCCESS;

2433: l_session_id NUMBER := USERENV('SESSIONID');
2434:
2435: BEGIN
2436: --DBMS_OUTPUT.PUT_LINE('INSERT_LOCK_DIMENSION_OBJECT');
2437: x_return_status := FND_API.G_RET_STS_SUCCESS;
2438: l_object_type := 'DIMENSION_OBJECT';
2439:
2440: -- Insert the ALL entries
2441: BSC_LOCKS_PVT.INSERT_LOCK_ALL

Line 2533: WHEN FND_API.G_EXC_ERROR THEN

2529: FND_GLOBAL.USER_ID
2530: FROM BSC_SYS_DIM_LEVELS_B;
2531:
2532: EXCEPTION
2533: WHEN FND_API.G_EXC_ERROR THEN
2534: x_return_status := FND_API.G_RET_STS_ERROR;
2535: FND_MSG_PUB.Count_And_Get(
2536: p_encoded => 'F'
2537: ,p_count => x_msg_count

Line 2534: x_return_status := FND_API.G_RET_STS_ERROR;

2530: FROM BSC_SYS_DIM_LEVELS_B;
2531:
2532: EXCEPTION
2533: WHEN FND_API.G_EXC_ERROR THEN
2534: x_return_status := FND_API.G_RET_STS_ERROR;
2535: FND_MSG_PUB.Count_And_Get(
2536: p_encoded => 'F'
2537: ,p_count => x_msg_count
2538: ,p_data => x_msg_data

Line 2541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2537: ,p_count => x_msg_count
2538: ,p_data => x_msg_data
2539: );
2540: RAISE;
2541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2543: FND_MSG_PUB.Count_And_Get(
2544: p_encoded => 'F'
2545: ,p_count => x_msg_count

Line 2542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2538: ,p_data => x_msg_data
2539: );
2540: RAISE;
2541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2543: FND_MSG_PUB.Count_And_Get(
2544: p_encoded => 'F'
2545: ,p_count => x_msg_count
2546: ,p_data => x_msg_data

Line 2555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2551: G_PKG_NAME,
2552: l_api_name,
2553: SQLERRM
2554: );
2555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2556: FND_MSG_PUB.Count_And_Get(
2557: p_encoded => 'F'
2558: ,p_count => x_msg_count
2559: ,p_data => x_msg_data

Line 2561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2557: p_encoded => 'F'
2558: ,p_count => x_msg_count
2559: ,p_data => x_msg_data
2560: );
2561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2562: END INSERT_LOCK_DIMENSION_OBJECT;
2563:
2564:
2565: /*------------------------------------------------------------------------------------------

Line 2601: x_return_status := FND_API.G_RET_STS_SUCCESS;

2597: l_session_id NUMBER := USERENV('SESSIONID');
2598:
2599: BEGIN
2600: --DBMS_OUTPUT.PUT_LINE('INSERT_LOCK_MEASURE');
2601: x_return_status := FND_API.G_RET_STS_SUCCESS;
2602: l_object_type := 'MEASURE';
2603:
2604: -- Insert the ALL entries
2605: BSC_LOCKS_PVT.INSERT_LOCK_ALL

Line 2697: WHEN FND_API.G_EXC_ERROR THEN

2693: FND_GLOBAL.USER_ID
2694: FROM BSC_SYS_DATASETS_B;
2695:
2696: EXCEPTION
2697: WHEN FND_API.G_EXC_ERROR THEN
2698: x_return_status := FND_API.G_RET_STS_ERROR;
2699: FND_MSG_PUB.Count_And_Get(
2700: p_encoded => 'F'
2701: ,p_count => x_msg_count

Line 2698: x_return_status := FND_API.G_RET_STS_ERROR;

2694: FROM BSC_SYS_DATASETS_B;
2695:
2696: EXCEPTION
2697: WHEN FND_API.G_EXC_ERROR THEN
2698: x_return_status := FND_API.G_RET_STS_ERROR;
2699: FND_MSG_PUB.Count_And_Get(
2700: p_encoded => 'F'
2701: ,p_count => x_msg_count
2702: ,p_data => x_msg_data

Line 2705: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2701: ,p_count => x_msg_count
2702: ,p_data => x_msg_data
2703: );
2704: RAISE;
2705: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2707: FND_MSG_PUB.Count_And_Get(
2708: p_encoded => 'F'
2709: ,p_count => x_msg_count

Line 2706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2702: ,p_data => x_msg_data
2703: );
2704: RAISE;
2705: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2707: FND_MSG_PUB.Count_And_Get(
2708: p_encoded => 'F'
2709: ,p_count => x_msg_count
2710: ,p_data => x_msg_data

Line 2719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2715: G_PKG_NAME,
2716: l_api_name,
2717: SQLERRM
2718: );
2719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2720: FND_MSG_PUB.Count_And_Get(
2721: p_encoded => 'F'
2722: ,p_count => x_msg_count
2723: ,p_data => x_msg_data

Line 2725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2721: p_encoded => 'F'
2722: ,p_count => x_msg_count
2723: ,p_data => x_msg_data
2724: );
2725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2726: END INSERT_LOCK_MEASURE;
2727:
2728:
2729: /*------------------------------------------------------------------------------------------

Line 2765: x_return_status := FND_API.G_RET_STS_SUCCESS;

2761: l_session_id NUMBER := USERENV('SESSIONID');
2762:
2763: BEGIN
2764: --DBMS_OUTPUT.PUT_LINE('INSERT_LOCK_DATA_COLUMN');
2765: x_return_status := FND_API.G_RET_STS_SUCCESS;
2766: l_object_type := 'DATA_COLUMN';
2767:
2768: -- Insert the ALL entries
2769: BSC_LOCKS_PVT.INSERT_LOCK_ALL

Line 2861: WHEN FND_API.G_EXC_ERROR THEN

2857: FND_GLOBAL.USER_ID
2858: FROM BSC_SYS_MEASURES;
2859:
2860: EXCEPTION
2861: WHEN FND_API.G_EXC_ERROR THEN
2862: x_return_status := FND_API.G_RET_STS_ERROR;
2863: FND_MSG_PUB.Count_And_Get(
2864: p_encoded => 'F'
2865: ,p_count => x_msg_count

Line 2862: x_return_status := FND_API.G_RET_STS_ERROR;

2858: FROM BSC_SYS_MEASURES;
2859:
2860: EXCEPTION
2861: WHEN FND_API.G_EXC_ERROR THEN
2862: x_return_status := FND_API.G_RET_STS_ERROR;
2863: FND_MSG_PUB.Count_And_Get(
2864: p_encoded => 'F'
2865: ,p_count => x_msg_count
2866: ,p_data => x_msg_data

Line 2869: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2865: ,p_count => x_msg_count
2866: ,p_data => x_msg_data
2867: );
2868: RAISE;
2869: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2871: FND_MSG_PUB.Count_And_Get(
2872: p_encoded => 'F'
2873: ,p_count => x_msg_count

Line 2870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2866: ,p_data => x_msg_data
2867: );
2868: RAISE;
2869: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2871: FND_MSG_PUB.Count_And_Get(
2872: p_encoded => 'F'
2873: ,p_count => x_msg_count
2874: ,p_data => x_msg_data

Line 2883: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2879: G_PKG_NAME,
2880: l_api_name,
2881: SQLERRM
2882: );
2883: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2884: FND_MSG_PUB.Count_And_Get(
2885: p_encoded => 'F'
2886: ,p_count => x_msg_count
2887: ,p_data => x_msg_data

Line 2889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2885: p_encoded => 'F'
2886: ,p_count => x_msg_count
2887: ,p_data => x_msg_data
2888: );
2889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2890: END INSERT_LOCK_DATA_COLUMN;
2891:
2892:
2893: /*------------------------------------------------------------------------------------------

Line 2929: x_return_status := FND_API.G_RET_STS_SUCCESS;

2925: l_session_id NUMBER := USERENV('SESSIONID');
2926:
2927: BEGIN
2928: --DBMS_OUTPUT.PUT_LINE('INSERT_LOCK_CUSTOM_VIEW');
2929: x_return_status := FND_API.G_RET_STS_SUCCESS;
2930: l_object_type := 'CUSTOM_VIEW';
2931:
2932: -- Insert the ALL entries
2933: BSC_LOCKS_PVT.INSERT_LOCK_ALL

Line 3025: WHEN FND_API.G_EXC_ERROR THEN

3021: FND_GLOBAL.USER_ID
3022: FROM BSC_TAB_VIEWS_B;
3023:
3024: EXCEPTION
3025: WHEN FND_API.G_EXC_ERROR THEN
3026: x_return_status := FND_API.G_RET_STS_ERROR;
3027: FND_MSG_PUB.Count_And_Get(
3028: p_encoded => 'F'
3029: ,p_count => x_msg_count

Line 3026: x_return_status := FND_API.G_RET_STS_ERROR;

3022: FROM BSC_TAB_VIEWS_B;
3023:
3024: EXCEPTION
3025: WHEN FND_API.G_EXC_ERROR THEN
3026: x_return_status := FND_API.G_RET_STS_ERROR;
3027: FND_MSG_PUB.Count_And_Get(
3028: p_encoded => 'F'
3029: ,p_count => x_msg_count
3030: ,p_data => x_msg_data

Line 3033: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3029: ,p_count => x_msg_count
3030: ,p_data => x_msg_data
3031: );
3032: RAISE;
3033: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3035: FND_MSG_PUB.Count_And_Get(
3036: p_encoded => 'F'
3037: ,p_count => x_msg_count

Line 3034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3030: ,p_data => x_msg_data
3031: );
3032: RAISE;
3033: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3035: FND_MSG_PUB.Count_And_Get(
3036: p_encoded => 'F'
3037: ,p_count => x_msg_count
3038: ,p_data => x_msg_data

Line 3047: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3043: G_PKG_NAME,
3044: l_api_name,
3045: SQLERRM
3046: );
3047: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3048: FND_MSG_PUB.Count_And_Get(
3049: p_encoded => 'F'
3050: ,p_count => x_msg_count
3051: ,p_data => x_msg_data

Line 3053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3049: p_encoded => 'F'
3050: ,p_count => x_msg_count
3051: ,p_data => x_msg_data
3052: );
3053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3054: END INSERT_LOCK_CUSTOM_VIEW;
3055:
3056:
3057: /*------------------------------------------------------------------------------------------

Line 3093: x_return_status := FND_API.G_RET_STS_SUCCESS;

3089: l_session_id NUMBER := USERENV('SESSIONID');
3090:
3091: BEGIN
3092: --DBMS_OUTPUT.PUT_LINE('INSERT_LOCK_LAUNCHPAD');
3093: x_return_status := FND_API.G_RET_STS_SUCCESS;
3094: l_object_type := 'LAUNCHPAD';
3095:
3096: -- Insert the ALL entries
3097: BSC_LOCKS_PVT.INSERT_LOCK_ALL

Line 3192: WHEN FND_API.G_EXC_ERROR THEN

3188: FROM BSC_TAB_VIEW_LABELS_B
3189: WHERE LABEL_TYPE = 2;
3190:
3191: EXCEPTION
3192: WHEN FND_API.G_EXC_ERROR THEN
3193: x_return_status := FND_API.G_RET_STS_ERROR;
3194: FND_MSG_PUB.Count_And_Get(
3195: p_encoded => 'F'
3196: ,p_count => x_msg_count

Line 3193: x_return_status := FND_API.G_RET_STS_ERROR;

3189: WHERE LABEL_TYPE = 2;
3190:
3191: EXCEPTION
3192: WHEN FND_API.G_EXC_ERROR THEN
3193: x_return_status := FND_API.G_RET_STS_ERROR;
3194: FND_MSG_PUB.Count_And_Get(
3195: p_encoded => 'F'
3196: ,p_count => x_msg_count
3197: ,p_data => x_msg_data

Line 3200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3196: ,p_count => x_msg_count
3197: ,p_data => x_msg_data
3198: );
3199: RAISE;
3200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3202: FND_MSG_PUB.Count_And_Get(
3203: p_encoded => 'F'
3204: ,p_count => x_msg_count

Line 3201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3197: ,p_data => x_msg_data
3198: );
3199: RAISE;
3200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3202: FND_MSG_PUB.Count_And_Get(
3203: p_encoded => 'F'
3204: ,p_count => x_msg_count
3205: ,p_data => x_msg_data

Line 3214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3210: G_PKG_NAME,
3211: l_api_name,
3212: SQLERRM
3213: );
3214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3215: FND_MSG_PUB.Count_And_Get(
3216: p_encoded => 'F'
3217: ,p_count => x_msg_count
3218: ,p_data => x_msg_data

Line 3220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3216: p_encoded => 'F'
3217: ,p_count => x_msg_count
3218: ,p_data => x_msg_data
3219: );
3220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3221: END INSERT_LOCK_LAUNCHPAD;
3222:
3223:
3224: /*------------------------------------------------------------------------------------------

Line 3260: x_return_status := FND_API.G_RET_STS_SUCCESS;

3256: l_session_id NUMBER := USERENV('SESSIONID');
3257:
3258: BEGIN
3259: --DBMS_OUTPUT.PUT_LINE('INSERT_LOCK_PERIODICITY');
3260: x_return_status := FND_API.G_RET_STS_SUCCESS;
3261: l_object_type := 'PERIODICITY';
3262:
3263: -- Insert the ALL entries
3264: BSC_LOCKS_PVT.INSERT_LOCK_ALL

Line 3356: WHEN FND_API.G_EXC_ERROR THEN

3352: FND_GLOBAL.USER_ID
3353: FROM BSC_SYS_PERIODICITIES;
3354:
3355: EXCEPTION
3356: WHEN FND_API.G_EXC_ERROR THEN
3357: x_return_status := FND_API.G_RET_STS_ERROR;
3358: FND_MSG_PUB.Count_And_Get(
3359: p_encoded => 'F'
3360: ,p_count => x_msg_count

Line 3357: x_return_status := FND_API.G_RET_STS_ERROR;

3353: FROM BSC_SYS_PERIODICITIES;
3354:
3355: EXCEPTION
3356: WHEN FND_API.G_EXC_ERROR THEN
3357: x_return_status := FND_API.G_RET_STS_ERROR;
3358: FND_MSG_PUB.Count_And_Get(
3359: p_encoded => 'F'
3360: ,p_count => x_msg_count
3361: ,p_data => x_msg_data

Line 3364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3360: ,p_count => x_msg_count
3361: ,p_data => x_msg_data
3362: );
3363: RAISE;
3364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3366: FND_MSG_PUB.Count_And_Get(
3367: p_encoded => 'F'
3368: ,p_count => x_msg_count

Line 3365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3361: ,p_data => x_msg_data
3362: );
3363: RAISE;
3364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3366: FND_MSG_PUB.Count_And_Get(
3367: p_encoded => 'F'
3368: ,p_count => x_msg_count
3369: ,p_data => x_msg_data

Line 3378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3374: G_PKG_NAME,
3375: l_api_name,
3376: SQLERRM
3377: );
3378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3379: FND_MSG_PUB.Count_And_Get(
3380: p_encoded => 'F'
3381: ,p_count => x_msg_count
3382: ,p_data => x_msg_data

Line 3384: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3380: p_encoded => 'F'
3381: ,p_count => x_msg_count
3382: ,p_data => x_msg_data
3383: );
3384: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3385: END INSERT_LOCK_PERIODICITY;
3386:
3387:
3388: /*------------------------------------------------------------------------------------------

Line 3424: x_return_status := FND_API.G_RET_STS_SUCCESS;

3420: l_session_id NUMBER := USERENV('SESSIONID');
3421:
3422: BEGIN
3423: --DBMS_OUTPUT.PUT_LINE('INSERT_LOCK_CALENDAR');
3424: x_return_status := FND_API.G_RET_STS_SUCCESS;
3425: l_object_type := 'CALENDAR';
3426:
3427: -- Insert the ALL entries
3428: BSC_LOCKS_PVT.INSERT_LOCK_ALL

Line 3520: WHEN FND_API.G_EXC_ERROR THEN

3516: FND_GLOBAL.USER_ID
3517: FROM BSC_SYS_CALENDARS_B;
3518:
3519: EXCEPTION
3520: WHEN FND_API.G_EXC_ERROR THEN
3521: x_return_status := FND_API.G_RET_STS_ERROR;
3522: FND_MSG_PUB.Count_And_Get(
3523: p_encoded => 'F'
3524: ,p_count => x_msg_count

Line 3521: x_return_status := FND_API.G_RET_STS_ERROR;

3517: FROM BSC_SYS_CALENDARS_B;
3518:
3519: EXCEPTION
3520: WHEN FND_API.G_EXC_ERROR THEN
3521: x_return_status := FND_API.G_RET_STS_ERROR;
3522: FND_MSG_PUB.Count_And_Get(
3523: p_encoded => 'F'
3524: ,p_count => x_msg_count
3525: ,p_data => x_msg_data

Line 3528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3524: ,p_count => x_msg_count
3525: ,p_data => x_msg_data
3526: );
3527: RAISE;
3528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3530: FND_MSG_PUB.Count_And_Get(
3531: p_encoded => 'F'
3532: ,p_count => x_msg_count

Line 3529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3525: ,p_data => x_msg_data
3526: );
3527: RAISE;
3528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3530: FND_MSG_PUB.Count_And_Get(
3531: p_encoded => 'F'
3532: ,p_count => x_msg_count
3533: ,p_data => x_msg_data

Line 3542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3538: G_PKG_NAME,
3539: l_api_name,
3540: SQLERRM
3541: );
3542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3543: FND_MSG_PUB.Count_And_Get(
3544: p_encoded => 'F'
3545: ,p_count => x_msg_count
3546: ,p_data => x_msg_data

Line 3548: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3544: p_encoded => 'F'
3545: ,p_count => x_msg_count
3546: ,p_data => x_msg_data
3547: );
3548: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3549: END INSERT_LOCK_CALENDAR;
3550:
3551:
3552: /*------------------------------------------------------------------------------------------

Line 3588: x_return_status := FND_API.G_RET_STS_SUCCESS;

3584: l_session_id NUMBER := USERENV('SESSIONID');
3585:
3586: BEGIN
3587: --DBMS_OUTPUT.PUT_LINE('INSERT_LOCK_TABLE');
3588: x_return_status := FND_API.G_RET_STS_SUCCESS;
3589: l_object_type := 'TABLE';
3590:
3591: -- Insert the ALL entries
3592: BSC_LOCKS_PVT.INSERT_LOCK_ALL

Line 3684: WHEN FND_API.G_EXC_ERROR THEN

3680: FND_GLOBAL.USER_ID
3681: FROM BSC_DB_TABLES;
3682:
3683: EXCEPTION
3684: WHEN FND_API.G_EXC_ERROR THEN
3685: x_return_status := FND_API.G_RET_STS_ERROR;
3686: FND_MSG_PUB.Count_And_Get(
3687: p_encoded => 'F'
3688: ,p_count => x_msg_count

Line 3685: x_return_status := FND_API.G_RET_STS_ERROR;

3681: FROM BSC_DB_TABLES;
3682:
3683: EXCEPTION
3684: WHEN FND_API.G_EXC_ERROR THEN
3685: x_return_status := FND_API.G_RET_STS_ERROR;
3686: FND_MSG_PUB.Count_And_Get(
3687: p_encoded => 'F'
3688: ,p_count => x_msg_count
3689: ,p_data => x_msg_data

Line 3692: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3688: ,p_count => x_msg_count
3689: ,p_data => x_msg_data
3690: );
3691: RAISE;
3692: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3694: FND_MSG_PUB.Count_And_Get(
3695: p_encoded => 'F'
3696: ,p_count => x_msg_count

Line 3693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3689: ,p_data => x_msg_data
3690: );
3691: RAISE;
3692: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3694: FND_MSG_PUB.Count_And_Get(
3695: p_encoded => 'F'
3696: ,p_count => x_msg_count
3697: ,p_data => x_msg_data

Line 3706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3702: G_PKG_NAME,
3703: l_api_name,
3704: SQLERRM
3705: );
3706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3707: FND_MSG_PUB.Count_And_Get(
3708: p_encoded => 'F'
3709: ,p_count => x_msg_count
3710: ,p_data => x_msg_data

Line 3712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3708: p_encoded => 'F'
3709: ,p_count => x_msg_count
3710: ,p_data => x_msg_data
3711: );
3712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3713: END INSERT_LOCK_TABLE;
3714:
3715:
3716: /*------------------------------------------------------------------------------------------

Line 3747: x_return_status := FND_API.G_RET_STS_SUCCESS;

3743: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_LOCK_INFO';
3744:
3745: BEGIN
3746: --DBMS_OUTPUT.PUT_LINE('INSERT_LOCK_INFO');
3747: x_return_status := FND_API.G_RET_STS_SUCCESS;
3748:
3749: INSERT INTO BSC_OBJECT_LOCKS (
3750: OBJECT_KEY,
3751: OBJECT_TYPE,

Line 3774: WHEN FND_API.G_EXC_ERROR THEN

3770: p_session_id
3771: );
3772:
3773: EXCEPTION
3774: WHEN FND_API.G_EXC_ERROR THEN
3775: x_return_status := FND_API.G_RET_STS_ERROR;
3776: FND_MSG_PUB.Count_And_Get(
3777: p_encoded => 'F'
3778: ,p_count => x_msg_count

Line 3775: x_return_status := FND_API.G_RET_STS_ERROR;

3771: );
3772:
3773: EXCEPTION
3774: WHEN FND_API.G_EXC_ERROR THEN
3775: x_return_status := FND_API.G_RET_STS_ERROR;
3776: FND_MSG_PUB.Count_And_Get(
3777: p_encoded => 'F'
3778: ,p_count => x_msg_count
3779: ,p_data => x_msg_data

Line 3782: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3778: ,p_count => x_msg_count
3779: ,p_data => x_msg_data
3780: );
3781: RAISE;
3782: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3784: FND_MSG_PUB.Count_And_Get(
3785: p_encoded => 'F'
3786: ,p_count => x_msg_count

Line 3783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3779: ,p_data => x_msg_data
3780: );
3781: RAISE;
3782: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3784: FND_MSG_PUB.Count_And_Get(
3785: p_encoded => 'F'
3786: ,p_count => x_msg_count
3787: ,p_data => x_msg_data

Line 3796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3792: G_PKG_NAME,
3793: l_api_name,
3794: SQLERRM
3795: );
3796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3797: FND_MSG_PUB.Count_And_Get(
3798: p_encoded => 'F'
3799: ,p_count => x_msg_count
3800: ,p_data => x_msg_data

Line 3802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3798: p_encoded => 'F'
3799: ,p_count => x_msg_count
3800: ,p_data => x_msg_data
3801: );
3802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3803: END INSERT_LOCK_INFO;
3804:
3805:
3806: /*------------------------------------------------------------------------------------------

Line 3838: x_return_status := FND_API.G_RET_STS_SUCCESS;

3834: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_LOCK_INFO_AUTONOMOUS';
3835:
3836: BEGIN
3837: --DBMS_OUTPUT.PUT_LINE('INSERT_LOCK_INFO_AUTONOMOUS');
3838: x_return_status := FND_API.G_RET_STS_SUCCESS;
3839:
3840: BSC_LOCKS_PVT.INSERT_LOCK_INFO
3841: (
3842: p_object_key => p_object_key

Line 3854: WHEN FND_API.G_EXC_ERROR THEN

3850: );
3851: COMMIT;
3852:
3853: EXCEPTION
3854: WHEN FND_API.G_EXC_ERROR THEN
3855: ROLLBACK;
3856: x_return_status := FND_API.G_RET_STS_ERROR;
3857: FND_MSG_PUB.Count_And_Get(
3858: p_encoded => 'F'

Line 3856: x_return_status := FND_API.G_RET_STS_ERROR;

3852:
3853: EXCEPTION
3854: WHEN FND_API.G_EXC_ERROR THEN
3855: ROLLBACK;
3856: x_return_status := FND_API.G_RET_STS_ERROR;
3857: FND_MSG_PUB.Count_And_Get(
3858: p_encoded => 'F'
3859: ,p_count => x_msg_count
3860: ,p_data => x_msg_data

Line 3863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3859: ,p_count => x_msg_count
3860: ,p_data => x_msg_data
3861: );
3862: RAISE;
3863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3864: ROLLBACK;
3865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3866: FND_MSG_PUB.Count_And_Get(
3867: p_encoded => 'F'

Line 3865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3861: );
3862: RAISE;
3863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3864: ROLLBACK;
3865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3866: FND_MSG_PUB.Count_And_Get(
3867: p_encoded => 'F'
3868: ,p_count => x_msg_count
3869: ,p_data => x_msg_data

Line 3879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3875: G_PKG_NAME,
3876: l_api_name,
3877: SQLERRM
3878: );
3879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3880: FND_MSG_PUB.Count_And_Get(
3881: p_encoded => 'F'
3882: ,p_count => x_msg_count
3883: ,p_data => x_msg_data

Line 3885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3881: p_encoded => 'F'
3882: ,p_count => x_msg_count
3883: ,p_data => x_msg_data
3884: );
3885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3886: END INSERT_LOCK_INFO_AUTONOMOUS;
3887:
3888:
3889: /*------------------------------------------------------------------------------------------

Line 3920: x_return_status := FND_API.G_RET_STS_SUCCESS;

3916: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_LOCK_INFO';
3917:
3918: BEGIN
3919: --DBMS_OUTPUT.PUT_LINE('UPDATE_LOCK_INFO');
3920: x_return_status := FND_API.G_RET_STS_SUCCESS;
3921:
3922: IF (p_object_key = 'ALL' AND p_object_type = 'ALL') THEN
3923: UPDATE BSC_OBJECT_LOCKS
3924: SET LAST_SAVE_TIME = p_last_save_time,

Line 3959: WHEN FND_API.G_EXC_ERROR THEN

3955: END IF;
3956: END IF;
3957:
3958: EXCEPTION
3959: WHEN FND_API.G_EXC_ERROR THEN
3960: x_return_status := FND_API.G_RET_STS_ERROR;
3961: FND_MSG_PUB.Count_And_Get(
3962: p_encoded => 'F'
3963: ,p_count => x_msg_count

Line 3960: x_return_status := FND_API.G_RET_STS_ERROR;

3956: END IF;
3957:
3958: EXCEPTION
3959: WHEN FND_API.G_EXC_ERROR THEN
3960: x_return_status := FND_API.G_RET_STS_ERROR;
3961: FND_MSG_PUB.Count_And_Get(
3962: p_encoded => 'F'
3963: ,p_count => x_msg_count
3964: ,p_data => x_msg_data

Line 3967: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3963: ,p_count => x_msg_count
3964: ,p_data => x_msg_data
3965: );
3966: RAISE;
3967: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3969: FND_MSG_PUB.Count_And_Get(
3970: p_encoded => 'F'
3971: ,p_count => x_msg_count

Line 3968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3964: ,p_data => x_msg_data
3965: );
3966: RAISE;
3967: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3969: FND_MSG_PUB.Count_And_Get(
3970: p_encoded => 'F'
3971: ,p_count => x_msg_count
3972: ,p_data => x_msg_data

Line 3981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3977: G_PKG_NAME,
3978: l_api_name,
3979: SQLERRM
3980: );
3981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3982: FND_MSG_PUB.Count_And_Get(
3983: p_encoded => 'F'
3984: ,p_count => x_msg_count
3985: ,p_data => x_msg_data

Line 3987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3983: p_encoded => 'F'
3984: ,p_count => x_msg_count
3985: ,p_data => x_msg_data
3986: );
3987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3988: END UPDATE_LOCK_INFO;
3989:
3990:
3991: /*------------------------------------------------------------------------------------------

Line 4023: x_return_status := FND_API.G_RET_STS_SUCCESS;

4019: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_LOCK_INFO_AUTONOMOUS';
4020:
4021: BEGIN
4022: --DBMS_OUTPUT.PUT_LINE('UPDATE_LOCK_INFO_AUTONOMOUS');
4023: x_return_status := FND_API.G_RET_STS_SUCCESS;
4024:
4025: BSC_LOCKS_PVT.UPDATE_LOCK_INFO
4026: (
4027: p_object_key => p_object_key

Line 4039: WHEN FND_API.G_EXC_ERROR THEN

4035: );
4036: COMMIT;
4037:
4038: EXCEPTION
4039: WHEN FND_API.G_EXC_ERROR THEN
4040: ROLLBACK;
4041: x_return_status := FND_API.G_RET_STS_ERROR;
4042: FND_MSG_PUB.Count_And_Get(
4043: p_encoded => 'F'

Line 4041: x_return_status := FND_API.G_RET_STS_ERROR;

4037:
4038: EXCEPTION
4039: WHEN FND_API.G_EXC_ERROR THEN
4040: ROLLBACK;
4041: x_return_status := FND_API.G_RET_STS_ERROR;
4042: FND_MSG_PUB.Count_And_Get(
4043: p_encoded => 'F'
4044: ,p_count => x_msg_count
4045: ,p_data => x_msg_data

Line 4048: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4044: ,p_count => x_msg_count
4045: ,p_data => x_msg_data
4046: );
4047: RAISE;
4048: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4049: ROLLBACK;
4050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4051: FND_MSG_PUB.Count_And_Get(
4052: p_encoded => 'F'

Line 4050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4046: );
4047: RAISE;
4048: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4049: ROLLBACK;
4050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4051: FND_MSG_PUB.Count_And_Get(
4052: p_encoded => 'F'
4053: ,p_count => x_msg_count
4054: ,p_data => x_msg_data

Line 4064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4060: G_PKG_NAME,
4061: l_api_name,
4062: SQLERRM
4063: );
4064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4065: FND_MSG_PUB.Count_And_Get(
4066: p_encoded => 'F'
4067: ,p_count => x_msg_count
4068: ,p_data => x_msg_data

Line 4070: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4066: p_encoded => 'F'
4067: ,p_count => x_msg_count
4068: ,p_data => x_msg_data
4069: );
4070: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4071: END UPDATE_LOCK_INFO_AUTONOMOUS;
4072:
4073:
4074: /*------------------------------------------------------------------------------------------

Line 4120: x_return_status := FND_API.G_RET_STS_SUCCESS;

4116: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_USER_INFO';
4117:
4118: BEGIN
4119: --DBMS_OUTPUT.PUT_LINE('INSERT_USER_INFO');
4120: x_return_status := FND_API.G_RET_STS_SUCCESS;
4121:
4122: INSERT INTO BSC_OBJECT_LOCK_USERS (
4123: OBJECT_KEY,
4124: OBJECT_TYPE,

Line 4151: WHEN FND_API.G_EXC_ERROR THEN

4147: FND_GLOBAL.USER_ID
4148: );
4149:
4150: EXCEPTION
4151: WHEN FND_API.G_EXC_ERROR THEN
4152: x_return_status := FND_API.G_RET_STS_ERROR;
4153: FND_MSG_PUB.Count_And_Get(
4154: p_encoded => 'F'
4155: ,p_count => x_msg_count

Line 4152: x_return_status := FND_API.G_RET_STS_ERROR;

4148: );
4149:
4150: EXCEPTION
4151: WHEN FND_API.G_EXC_ERROR THEN
4152: x_return_status := FND_API.G_RET_STS_ERROR;
4153: FND_MSG_PUB.Count_And_Get(
4154: p_encoded => 'F'
4155: ,p_count => x_msg_count
4156: ,p_data => x_msg_data

Line 4159: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4155: ,p_count => x_msg_count
4156: ,p_data => x_msg_data
4157: );
4158: RAISE;
4159: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4161: FND_MSG_PUB.Count_And_Get(
4162: p_encoded => 'F'
4163: ,p_count => x_msg_count

Line 4160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4156: ,p_data => x_msg_data
4157: );
4158: RAISE;
4159: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4161: FND_MSG_PUB.Count_And_Get(
4162: p_encoded => 'F'
4163: ,p_count => x_msg_count
4164: ,p_data => x_msg_data

Line 4173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4169: G_PKG_NAME,
4170: l_api_name,
4171: SQLERRM
4172: );
4173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4174: FND_MSG_PUB.Count_And_Get(
4175: p_encoded => 'F'
4176: ,p_count => x_msg_count
4177: ,p_data => x_msg_data

Line 4179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4175: p_encoded => 'F'
4176: ,p_count => x_msg_count
4177: ,p_data => x_msg_data
4178: );
4179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4180: END INSERT_USER_INFO;
4181:
4182:
4183: /*------------------------------------------------------------------------------------------

Line 4230: x_return_status := FND_API.G_RET_STS_SUCCESS;

4226: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_USER_INFO_AUTONOMOUS';
4227:
4228: BEGIN
4229: --DBMS_OUTPUT.PUT_LINE('INSERT_USER_INFO_AUTONOMOUS');
4230: x_return_status := FND_API.G_RET_STS_SUCCESS;
4231:
4232: BSC_LOCKS_PVT.INSERT_USER_INFO
4233: (
4234: p_object_key => p_object_key

Line 4248: WHEN FND_API.G_EXC_ERROR THEN

4244: );
4245: COMMIT;
4246:
4247: EXCEPTION
4248: WHEN FND_API.G_EXC_ERROR THEN
4249: ROLLBACK;
4250: x_return_status := FND_API.G_RET_STS_ERROR;
4251: FND_MSG_PUB.Count_And_Get(
4252: p_encoded => 'F'

Line 4250: x_return_status := FND_API.G_RET_STS_ERROR;

4246:
4247: EXCEPTION
4248: WHEN FND_API.G_EXC_ERROR THEN
4249: ROLLBACK;
4250: x_return_status := FND_API.G_RET_STS_ERROR;
4251: FND_MSG_PUB.Count_And_Get(
4252: p_encoded => 'F'
4253: ,p_count => x_msg_count
4254: ,p_data => x_msg_data

Line 4257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4253: ,p_count => x_msg_count
4254: ,p_data => x_msg_data
4255: );
4256: RAISE;
4257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4258: ROLLBACK;
4259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4260: FND_MSG_PUB.Count_And_Get(
4261: p_encoded => 'F'

Line 4259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4255: );
4256: RAISE;
4257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4258: ROLLBACK;
4259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4260: FND_MSG_PUB.Count_And_Get(
4261: p_encoded => 'F'
4262: ,p_count => x_msg_count
4263: ,p_data => x_msg_data

Line 4273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4269: G_PKG_NAME,
4270: l_api_name,
4271: SQLERRM
4272: );
4273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4274: FND_MSG_PUB.Count_And_Get(
4275: p_encoded => 'F'
4276: ,p_count => x_msg_count
4277: ,p_data => x_msg_data

Line 4279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4275: p_encoded => 'F'
4276: ,p_count => x_msg_count
4277: ,p_data => x_msg_data
4278: );
4279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4280: END INSERT_USER_INFO_AUTONOMOUS;
4281:
4282:
4283: /*------------------------------------------------------------------------------------------

Line 4329: x_return_status := FND_API.G_RET_STS_SUCCESS;

4325: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_USER_INFO';
4326:
4327: BEGIN
4328: --DBMS_OUTPUT.PUT_LINE('UPDATE_USER_INFO');
4329: x_return_status := FND_API.G_RET_STS_SUCCESS;
4330:
4331: IF (p_object_key = 'ALL' AND p_object_type = 'ALL') THEN
4332: UPDATE BSC_OBJECT_LOCK_USERS
4333: SET PROGRAM_ID = p_program_id,

Line 4401: WHEN FND_API.G_EXC_ERROR THEN

4397: END IF;
4398: END IF;
4399:
4400: EXCEPTION
4401: WHEN FND_API.G_EXC_ERROR THEN
4402: x_return_status := FND_API.G_RET_STS_ERROR;
4403: FND_MSG_PUB.Count_And_Get(
4404: p_encoded => 'F'
4405: ,p_count => x_msg_count

Line 4402: x_return_status := FND_API.G_RET_STS_ERROR;

4398: END IF;
4399:
4400: EXCEPTION
4401: WHEN FND_API.G_EXC_ERROR THEN
4402: x_return_status := FND_API.G_RET_STS_ERROR;
4403: FND_MSG_PUB.Count_And_Get(
4404: p_encoded => 'F'
4405: ,p_count => x_msg_count
4406: ,p_data => x_msg_data

Line 4409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4405: ,p_count => x_msg_count
4406: ,p_data => x_msg_data
4407: );
4408: RAISE;
4409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4411: FND_MSG_PUB.Count_And_Get(
4412: p_encoded => 'F'
4413: ,p_count => x_msg_count

Line 4410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4406: ,p_data => x_msg_data
4407: );
4408: RAISE;
4409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4411: FND_MSG_PUB.Count_And_Get(
4412: p_encoded => 'F'
4413: ,p_count => x_msg_count
4414: ,p_data => x_msg_data

Line 4423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4419: G_PKG_NAME,
4420: l_api_name,
4421: SQLERRM
4422: );
4423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4424: FND_MSG_PUB.Count_And_Get(
4425: p_encoded => 'F'
4426: ,p_count => x_msg_count
4427: ,p_data => x_msg_data

Line 4429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4425: p_encoded => 'F'
4426: ,p_count => x_msg_count
4427: ,p_data => x_msg_data
4428: );
4429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4430: END UPDATE_USER_INFO;
4431:
4432:
4433: /*------------------------------------------------------------------------------------------

Line 4480: x_return_status := FND_API.G_RET_STS_SUCCESS;

4476: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_USER_INFO_AUTONOMOUS';
4477:
4478: BEGIN
4479: --DBMS_OUTPUT.PUT_LINE('UPDATE_USER_INFO_AUTONOMOUS');
4480: x_return_status := FND_API.G_RET_STS_SUCCESS;
4481:
4482: BSC_LOCKS_PVT.UPDATE_USER_INFO
4483: (
4484: p_object_key => p_object_key

Line 4498: WHEN FND_API.G_EXC_ERROR THEN

4494: );
4495: COMMIT;
4496:
4497: EXCEPTION
4498: WHEN FND_API.G_EXC_ERROR THEN
4499: ROLLBACK;
4500: x_return_status := FND_API.G_RET_STS_ERROR;
4501: FND_MSG_PUB.Count_And_Get(
4502: p_encoded => 'F'

Line 4500: x_return_status := FND_API.G_RET_STS_ERROR;

4496:
4497: EXCEPTION
4498: WHEN FND_API.G_EXC_ERROR THEN
4499: ROLLBACK;
4500: x_return_status := FND_API.G_RET_STS_ERROR;
4501: FND_MSG_PUB.Count_And_Get(
4502: p_encoded => 'F'
4503: ,p_count => x_msg_count
4504: ,p_data => x_msg_data

Line 4507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4503: ,p_count => x_msg_count
4504: ,p_data => x_msg_data
4505: );
4506: RAISE;
4507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4508: ROLLBACK;
4509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4510: FND_MSG_PUB.Count_And_Get(
4511: p_encoded => 'F'

Line 4509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4505: );
4506: RAISE;
4507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4508: ROLLBACK;
4509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4510: FND_MSG_PUB.Count_And_Get(
4511: p_encoded => 'F'
4512: ,p_count => x_msg_count
4513: ,p_data => x_msg_data

Line 4523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4519: G_PKG_NAME,
4520: l_api_name,
4521: SQLERRM
4522: );
4523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4524: FND_MSG_PUB.Count_And_Get(
4525: p_encoded => 'F'
4526: ,p_count => x_msg_count
4527: ,p_data => x_msg_data

Line 4529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4525: p_encoded => 'F'
4526: ,p_count => x_msg_count
4527: ,p_data => x_msg_data
4528: );
4529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4530: END UPDATE_USER_INFO_AUTONOMOUS;
4531:
4532:
4533: /*------------------------------------------------------------------------------------------

Line 4578: x_return_status := FND_API.G_RET_STS_SUCCESS;

4574: l_last_save_time DATE;
4575:
4576: BEGIN
4577: --DBMS_OUTPUT.PUT_LINE('DELETE_LOCK_INFO');
4578: x_return_status := FND_API.G_RET_STS_SUCCESS;
4579:
4580: -- Lock the user entry of the object
4581: BSC_LOCKS_PVT.LOCK_USER
4582: (

Line 4621: WHEN FND_API.G_EXC_ERROR THEN

4617: WHERE OBJECT_TYPE = p_object_type
4618: AND OBJECT_KEY = p_object_key;
4619:
4620: EXCEPTION
4621: WHEN FND_API.G_EXC_ERROR THEN
4622: x_return_status := FND_API.G_RET_STS_ERROR;
4623: FND_MSG_PUB.Count_And_Get(
4624: p_encoded => 'F'
4625: ,p_count => x_msg_count

Line 4622: x_return_status := FND_API.G_RET_STS_ERROR;

4618: AND OBJECT_KEY = p_object_key;
4619:
4620: EXCEPTION
4621: WHEN FND_API.G_EXC_ERROR THEN
4622: x_return_status := FND_API.G_RET_STS_ERROR;
4623: FND_MSG_PUB.Count_And_Get(
4624: p_encoded => 'F'
4625: ,p_count => x_msg_count
4626: ,p_data => x_msg_data

Line 4629: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4625: ,p_count => x_msg_count
4626: ,p_data => x_msg_data
4627: );
4628: RAISE;
4629: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4631: FND_MSG_PUB.Count_And_Get(
4632: p_encoded => 'F'
4633: ,p_count => x_msg_count

Line 4630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4626: ,p_data => x_msg_data
4627: );
4628: RAISE;
4629: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4631: FND_MSG_PUB.Count_And_Get(
4632: p_encoded => 'F'
4633: ,p_count => x_msg_count
4634: ,p_data => x_msg_data

Line 4643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4639: G_PKG_NAME,
4640: l_api_name,
4641: SQLERRM
4642: );
4643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4644: FND_MSG_PUB.Count_And_Get(
4645: p_encoded => 'F'
4646: ,p_count => x_msg_count
4647: ,p_data => x_msg_data

Line 4649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4645: p_encoded => 'F'
4646: ,p_count => x_msg_count
4647: ,p_data => x_msg_data
4648: );
4649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4650: END DELETE_LOCK_INFO;
4651:
4652:
4653: /*------------------------------------------------------------------------------------------

Line 4698: x_return_status := FND_API.G_RET_STS_SUCCESS;

4694: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_LOCK_INFO_AUTONOMOUS';
4695:
4696: BEGIN
4697: --DBMS_OUTPUT.PUT_LINE('DELETE_LOCK_INFO_AUTONOMOUS');
4698: x_return_status := FND_API.G_RET_STS_SUCCESS;
4699:
4700: BSC_LOCKS_PVT.DELETE_LOCK_INFO
4701: (
4702: p_object_key => p_object_key

Line 4715: WHEN FND_API.G_EXC_ERROR THEN

4711: );
4712: COMMIT;
4713:
4714: EXCEPTION
4715: WHEN FND_API.G_EXC_ERROR THEN
4716: ROLLBACK;
4717: x_return_status := FND_API.G_RET_STS_ERROR;
4718: FND_MSG_PUB.Count_And_Get(
4719: p_encoded => 'F'

Line 4717: x_return_status := FND_API.G_RET_STS_ERROR;

4713:
4714: EXCEPTION
4715: WHEN FND_API.G_EXC_ERROR THEN
4716: ROLLBACK;
4717: x_return_status := FND_API.G_RET_STS_ERROR;
4718: FND_MSG_PUB.Count_And_Get(
4719: p_encoded => 'F'
4720: ,p_count => x_msg_count
4721: ,p_data => x_msg_data

Line 4724: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4720: ,p_count => x_msg_count
4721: ,p_data => x_msg_data
4722: );
4723: RAISE;
4724: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4725: ROLLBACK;
4726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4727: FND_MSG_PUB.Count_And_Get(
4728: p_encoded => 'F'

Line 4726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4722: );
4723: RAISE;
4724: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4725: ROLLBACK;
4726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4727: FND_MSG_PUB.Count_And_Get(
4728: p_encoded => 'F'
4729: ,p_count => x_msg_count
4730: ,p_data => x_msg_data

Line 4740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4736: G_PKG_NAME,
4737: l_api_name,
4738: SQLERRM
4739: );
4740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4741: FND_MSG_PUB.Count_And_Get(
4742: p_encoded => 'F'
4743: ,p_count => x_msg_count
4744: ,p_data => x_msg_data

Line 4746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4742: p_encoded => 'F'
4743: ,p_count => x_msg_count
4744: ,p_data => x_msg_data
4745: );
4746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4747: END DELETE_LOCK_INFO_AUTONOMOUS;
4748:
4749:
4750: /*------------------------------------------------------------------------------------------

Line 4793: x_return_status := FND_API.G_RET_STS_SUCCESS;

4789: AND L.USER_ID = U.USER_ID (+);
4790:
4791: BEGIN
4792: --DBMS_OUTPUT.PUT_LINE('RAISE_EXCEPTION: '||p_object_key||' '||p_object_type||' '||p_exception_type);
4793: x_return_status := FND_API.G_RET_STS_SUCCESS;
4794:
4795: l_component := NULL;
4796: l_user_name := NULL;
4797: l_machine := NULL;

Line 4826: RAISE FND_API.G_EXC_ERROR;

4822: FND_MESSAGE.SET_TOKEN('USERNAME' , NVL(l_user_name, ''), TRUE);
4823: FND_MESSAGE.SET_TOKEN('MACHINE' , NVL(l_machine, ''), TRUE);
4824: FND_MESSAGE.SET_TOKEN('TERMINAL' , NVL(l_terminal, ''), TRUE);
4825: FND_MSG_PUB.ADD;
4826: RAISE FND_API.G_EXC_ERROR;
4827:
4828: EXCEPTION
4829: WHEN FND_API.G_EXC_ERROR THEN
4830: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4829: WHEN FND_API.G_EXC_ERROR THEN

4825: FND_MSG_PUB.ADD;
4826: RAISE FND_API.G_EXC_ERROR;
4827:
4828: EXCEPTION
4829: WHEN FND_API.G_EXC_ERROR THEN
4830: x_return_status := FND_API.G_RET_STS_ERROR;
4831: FND_MSG_PUB.Count_And_Get(
4832: p_encoded => 'F'
4833: ,p_count => x_msg_count

Line 4830: x_return_status := FND_API.G_RET_STS_ERROR;

4826: RAISE FND_API.G_EXC_ERROR;
4827:
4828: EXCEPTION
4829: WHEN FND_API.G_EXC_ERROR THEN
4830: x_return_status := FND_API.G_RET_STS_ERROR;
4831: FND_MSG_PUB.Count_And_Get(
4832: p_encoded => 'F'
4833: ,p_count => x_msg_count
4834: ,p_data => x_msg_data

Line 4837: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4833: ,p_count => x_msg_count
4834: ,p_data => x_msg_data
4835: );
4836: RAISE;
4837: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4839: FND_MSG_PUB.Count_And_Get(
4840: p_encoded => 'F'
4841: ,p_count => x_msg_count

Line 4838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4834: ,p_data => x_msg_data
4835: );
4836: RAISE;
4837: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4839: FND_MSG_PUB.Count_And_Get(
4840: p_encoded => 'F'
4841: ,p_count => x_msg_count
4842: ,p_data => x_msg_data

Line 4851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4847: G_PKG_NAME,
4848: l_api_name,
4849: SQLERRM
4850: );
4851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4852: FND_MSG_PUB.Count_And_Get(
4853: p_encoded => 'F'
4854: ,p_count => x_msg_count
4855: ,p_data => x_msg_data

Line 4857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4853: p_encoded => 'F'
4854: ,p_count => x_msg_count
4855: ,p_data => x_msg_data
4856: );
4857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4858: END RAISE_EXCEPTION;
4859:
4860:
4861: /*------------------------------------------------------------------------------------------

Line 4885: x_return_status := FND_API.G_RET_STS_SUCCESS;

4881: WHERE S.AUDSID = c_session_id;
4882:
4883: BEGIN
4884: --DBMS_OUTPUT.PUT_LINE('GET_SESSION');
4885: x_return_status := FND_API.G_RET_STS_SUCCESS;
4886:
4887: FOR csession IN c_get_session(USERENV('SESSIONID')) LOOP
4888: x_machine := csession.MACHINE;
4889: x_terminal := csession.TERMINAL;

Line 4893: WHEN FND_API.G_EXC_ERROR THEN

4889: x_terminal := csession.TERMINAL;
4890: END LOOP;
4891:
4892: EXCEPTION
4893: WHEN FND_API.G_EXC_ERROR THEN
4894: x_return_status := FND_API.G_RET_STS_ERROR;
4895: FND_MSG_PUB.Count_And_Get(
4896: p_encoded => 'F'
4897: ,p_count => x_msg_count

Line 4894: x_return_status := FND_API.G_RET_STS_ERROR;

4890: END LOOP;
4891:
4892: EXCEPTION
4893: WHEN FND_API.G_EXC_ERROR THEN
4894: x_return_status := FND_API.G_RET_STS_ERROR;
4895: FND_MSG_PUB.Count_And_Get(
4896: p_encoded => 'F'
4897: ,p_count => x_msg_count
4898: ,p_data => x_msg_data

Line 4901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4897: ,p_count => x_msg_count
4898: ,p_data => x_msg_data
4899: );
4900: RAISE;
4901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4903: FND_MSG_PUB.Count_And_Get(
4904: p_encoded => 'F'
4905: ,p_count => x_msg_count

Line 4902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4898: ,p_data => x_msg_data
4899: );
4900: RAISE;
4901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4903: FND_MSG_PUB.Count_And_Get(
4904: p_encoded => 'F'
4905: ,p_count => x_msg_count
4906: ,p_data => x_msg_data

Line 4915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4911: G_PKG_NAME,
4912: l_api_name,
4913: SQLERRM
4914: );
4915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4916: FND_MSG_PUB.Count_And_Get(
4917: p_encoded => 'F'
4918: ,p_count => x_msg_count
4919: ,p_data => x_msg_data

Line 4921: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4917: p_encoded => 'F'
4918: ,p_count => x_msg_count
4919: ,p_data => x_msg_data
4920: );
4921: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4922: END GET_SESSION;
4923:
4924: /*------------------------------------------------------------------------------------------
4925: Procedure INITIALIZE