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

Line 64: x_return_status := FND_API.G_RET_STS_SUCCESS;

60: BEGIN
61: --DBMS_OUTPUT.PUT_LINE('CHECK_SYSTEM_LOCK: '||p_object_key||' '||p_object_type);
62: SAVEPOINT BSCLocksPubCheckSystemLock;
63: FND_MSG_PUB.Initialize;
64: x_return_status := FND_API.G_RET_STS_SUCCESS;
65: BSC_LOCKS_PVT.Initialize;
66:
67: -- Get the machine and terminal information
68: BSC_LOCKS_PVT.GET_SESSION

Line 178: WHEN FND_API.G_EXC_ERROR THEN

174: END LOOP;
175: ROLLBACK TO BSCLocksPubCheckSystemLock;
176:
177: EXCEPTION
178: WHEN FND_API.G_EXC_ERROR THEN
179: ROLLBACK TO BSCLocksPubCheckSystemLock;
180: x_return_status := FND_API.G_RET_STS_ERROR;
181: FND_MSG_PUB.Count_And_Get(
182: p_encoded => 'F'

Line 180: x_return_status := FND_API.G_RET_STS_ERROR;

176:
177: EXCEPTION
178: WHEN FND_API.G_EXC_ERROR THEN
179: ROLLBACK TO BSCLocksPubCheckSystemLock;
180: x_return_status := FND_API.G_RET_STS_ERROR;
181: FND_MSG_PUB.Count_And_Get(
182: p_encoded => 'F'
183: ,p_count => x_msg_count
184: ,p_data => x_msg_data

Line 186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

182: p_encoded => 'F'
183: ,p_count => x_msg_count
184: ,p_data => x_msg_data
185: );
186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
187: ROLLBACK TO BSCLocksPubCheckSystemLock;
188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
189: FND_MSG_PUB.Count_And_Get(
190: p_encoded => 'F'

Line 188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

184: ,p_data => x_msg_data
185: );
186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
187: ROLLBACK TO BSCLocksPubCheckSystemLock;
188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
189: FND_MSG_PUB.Count_And_Get(
190: p_encoded => 'F'
191: ,p_count => x_msg_count
192: ,p_data => x_msg_data

Line 201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

197: G_PKG_NAME,
198: l_api_name,
199: SQLERRM
200: );
201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
202: FND_MSG_PUB.Count_And_Get(
203: p_encoded => 'F'
204: ,p_count => x_msg_count
205: ,p_data => x_msg_data

Line 261: x_return_status := FND_API.G_RET_STS_SUCCESS;

257: BEGIN
258: --DBMS_OUTPUT.PUT_LINE('CHECK_SYSTEM_LOCKS');
259: SAVEPOINT BSCLocksPubCheckSystemLocks;
260: FND_MSG_PUB.Initialize;
261: x_return_status := FND_API.G_RET_STS_SUCCESS;
262: BSC_LOCKS_PVT.Initialize;
263:
264: IF (p_object_keys.COUNT <> 0 AND p_object_keys.COUNT = p_object_types.COUNT) THEN
265: FOR i IN p_object_keys.FIRST..p_object_keys.LAST LOOP

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

273: ,x_return_status => x_return_status
274: ,x_msg_count => x_msg_count
275: ,x_msg_data => x_msg_data
276: );
277: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
278: EXIT;
279: END IF;
280: END LOOP;
281: END IF;

Line 285: WHEN FND_API.G_EXC_ERROR THEN

281: END IF;
282: ROLLBACK TO BSCLocksPubCheckSystemLocks;
283:
284: EXCEPTION
285: WHEN FND_API.G_EXC_ERROR THEN
286: ROLLBACK TO BSCLocksPubCheckSystemLocks;
287: x_return_status := FND_API.G_RET_STS_ERROR;
288: FND_MSG_PUB.Count_And_Get(
289: p_encoded => 'F'

Line 287: x_return_status := FND_API.G_RET_STS_ERROR;

283:
284: EXCEPTION
285: WHEN FND_API.G_EXC_ERROR THEN
286: ROLLBACK TO BSCLocksPubCheckSystemLocks;
287: x_return_status := FND_API.G_RET_STS_ERROR;
288: FND_MSG_PUB.Count_And_Get(
289: p_encoded => 'F'
290: ,p_count => x_msg_count
291: ,p_data => x_msg_data

Line 293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

289: p_encoded => 'F'
290: ,p_count => x_msg_count
291: ,p_data => x_msg_data
292: );
293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
294: ROLLBACK TO BSCLocksPubCheckSystemLocks;
295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
296: FND_MSG_PUB.Count_And_Get(
297: p_encoded => 'F'

Line 295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

291: ,p_data => x_msg_data
292: );
293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
294: ROLLBACK TO BSCLocksPubCheckSystemLocks;
295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
296: FND_MSG_PUB.Count_And_Get(
297: p_encoded => 'F'
298: ,p_count => x_msg_count
299: ,p_data => x_msg_data

Line 308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

304: G_PKG_NAME,
305: l_api_name,
306: SQLERRM
307: );
308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
309: FND_MSG_PUB.Count_And_Get(
310: p_encoded => 'F'
311: ,p_count => x_msg_count
312: ,p_data => x_msg_data

Line 444: x_return_status := FND_API.G_RET_STS_SUCCESS;

440: BEGIN
441: --DBMS_OUTPUT.PUT_LINE('SYNCHRONIZE');
442: SAVEPOINT BSCLocksPubSynchronize;
443: FND_MSG_PUB.Initialize;
444: x_return_status := FND_API.G_RET_STS_SUCCESS;
445: BSC_LOCKS_PVT.Initialize;
446: l_bsc_schema := BSC_LOCKS_PVT.GET_BSC_SCHEMA;
447:
448: -- Get the machine and terminal information

Line 662: WHEN FND_API.G_EXC_ERROR THEN

658: DBMS_STATS.GATHER_TABLE_STATS(NVL(l_bsc_schema, 'BSC'), 'BSC_OBJECT_LOCKS');
659: DBMS_STATS.GATHER_TABLE_STATS(NVL(l_bsc_schema, 'BSC'), 'BSC_OBJECT_LOCK_USERS');
660:
661: EXCEPTION
662: WHEN FND_API.G_EXC_ERROR THEN
663: ROLLBACK TO BSCLocksPubSynchronize;
664: x_return_status := FND_API.G_RET_STS_ERROR;
665: FND_MSG_PUB.Count_And_Get(
666: p_encoded => 'F'

Line 664: x_return_status := FND_API.G_RET_STS_ERROR;

660:
661: EXCEPTION
662: WHEN FND_API.G_EXC_ERROR THEN
663: ROLLBACK TO BSCLocksPubSynchronize;
664: x_return_status := FND_API.G_RET_STS_ERROR;
665: FND_MSG_PUB.Count_And_Get(
666: p_encoded => 'F'
667: ,p_count => x_msg_count
668: ,p_data => x_msg_data

Line 670: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

666: p_encoded => 'F'
667: ,p_count => x_msg_count
668: ,p_data => x_msg_data
669: );
670: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
671: ROLLBACK TO BSCLocksPubSynchronize;
672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
673: FND_MSG_PUB.Count_And_Get(
674: p_encoded => 'F'

Line 672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

668: ,p_data => x_msg_data
669: );
670: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
671: ROLLBACK TO BSCLocksPubSynchronize;
672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
673: FND_MSG_PUB.Count_And_Get(
674: p_encoded => 'F'
675: ,p_count => x_msg_count
676: ,p_data => x_msg_data

Line 685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

681: G_PKG_NAME,
682: l_api_name,
683: SQLERRM
684: );
685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
686: FND_MSG_PUB.Count_And_Get(
687: p_encoded => 'F'
688: ,p_count => x_msg_count
689: ,p_data => x_msg_data

Line 762: x_return_status := FND_API.G_RET_STS_SUCCESS;

758: BEGIN
759: --DBMS_OUTPUT.PUT_LINE('GET_SYSTEM_LOCK: '||p_object_key||' '||p_object_type||' '||p_lock_type);
760: SAVEPOINT BSCLocksPubGetSystemLock;
761: FND_MSG_PUB.Initialize;
762: x_return_status := FND_API.G_RET_STS_SUCCESS;
763: BSC_LOCKS_PVT.Initialize;
764:
765: -- Validate the top level object
766: --BSC_LOCKS_PVT.VALIDATE_OBJECT

Line 888: WHEN FND_API.G_EXC_ERROR THEN

884: );
885: END IF;
886:
887: EXCEPTION
888: WHEN FND_API.G_EXC_ERROR THEN
889: ROLLBACK TO BSCLocksPubGetSystemLock;
890: x_return_status := FND_API.G_RET_STS_ERROR;
891: FND_MSG_PUB.Count_And_Get(
892: p_encoded => 'F'

Line 890: x_return_status := FND_API.G_RET_STS_ERROR;

886:
887: EXCEPTION
888: WHEN FND_API.G_EXC_ERROR THEN
889: ROLLBACK TO BSCLocksPubGetSystemLock;
890: x_return_status := FND_API.G_RET_STS_ERROR;
891: FND_MSG_PUB.Count_And_Get(
892: p_encoded => 'F'
893: ,p_count => x_msg_count
894: ,p_data => x_msg_data

Line 896: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

892: p_encoded => 'F'
893: ,p_count => x_msg_count
894: ,p_data => x_msg_data
895: );
896: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
897: ROLLBACK TO BSCLocksPubGetSystemLock;
898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
899: FND_MSG_PUB.Count_And_Get(
900: p_encoded => 'F'

Line 898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

894: ,p_data => x_msg_data
895: );
896: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
897: ROLLBACK TO BSCLocksPubGetSystemLock;
898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
899: FND_MSG_PUB.Count_And_Get(
900: p_encoded => 'F'
901: ,p_count => x_msg_count
902: ,p_data => x_msg_data

Line 911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

907: G_PKG_NAME,
908: l_api_name,
909: SQLERRM
910: );
911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
912: FND_MSG_PUB.Count_And_Get(
913: p_encoded => 'F'
914: ,p_count => x_msg_count
915: ,p_data => x_msg_data

Line 980: x_return_status := FND_API.G_RET_STS_SUCCESS;

976: BEGIN
977: --DBMS_OUTPUT.PUT_LINE('GET_SYSTEM_LOCKS');
978: SAVEPOINT BSCLocksPubGetSystemLocks;
979: FND_MSG_PUB.Initialize;
980: x_return_status := FND_API.G_RET_STS_SUCCESS;
981: BSC_LOCKS_PVT.Initialize;
982:
983: IF (p_object_keys.COUNT <> 0 AND
984: p_object_keys.COUNT = p_object_types.COUNT) THEN

Line 1001: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

997: ,x_return_status => x_return_status
998: ,x_msg_count => x_msg_count
999: ,x_msg_data => x_msg_data
1000: );
1001: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1002: RAISE FND_API.G_EXC_ERROR;
1003: ELSIF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1005: END IF;

Line 1002: RAISE FND_API.G_EXC_ERROR;

998: ,x_msg_count => x_msg_count
999: ,x_msg_data => x_msg_data
1000: );
1001: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1002: RAISE FND_API.G_EXC_ERROR;
1003: ELSIF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1005: END IF;
1006: ELSIF (p_object_keys(i) = p_object_keys(j) AND

Line 1003: ELSIF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

999: ,x_msg_data => x_msg_data
1000: );
1001: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1002: RAISE FND_API.G_EXC_ERROR;
1003: ELSIF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1005: END IF;
1006: ELSIF (p_object_keys(i) = p_object_keys(j) AND
1007: p_object_types(i) = p_object_types(j)) THEN

Line 1004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1000: );
1001: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1002: RAISE FND_API.G_EXC_ERROR;
1003: ELSIF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1005: END IF;
1006: ELSIF (p_object_keys(i) = p_object_keys(j) AND
1007: p_object_types(i) = p_object_types(j)) THEN
1008: EXIT;

Line 1015: WHEN FND_API.G_EXC_ERROR THEN

1011: END LOOP;
1012: END IF;
1013:
1014: EXCEPTION
1015: WHEN FND_API.G_EXC_ERROR THEN
1016: ROLLBACK TO BSCLocksPubGetSystemLocks;
1017: x_return_status := FND_API.G_RET_STS_ERROR;
1018: FND_MSG_PUB.Count_And_Get(
1019: p_encoded => 'F'

Line 1017: x_return_status := FND_API.G_RET_STS_ERROR;

1013:
1014: EXCEPTION
1015: WHEN FND_API.G_EXC_ERROR THEN
1016: ROLLBACK TO BSCLocksPubGetSystemLocks;
1017: x_return_status := FND_API.G_RET_STS_ERROR;
1018: FND_MSG_PUB.Count_And_Get(
1019: p_encoded => 'F'
1020: ,p_count => x_msg_count
1021: ,p_data => x_msg_data

Line 1023: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1019: p_encoded => 'F'
1020: ,p_count => x_msg_count
1021: ,p_data => x_msg_data
1022: );
1023: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1024: ROLLBACK TO BSCLocksPubGetSystemLocks;
1025: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1026: FND_MSG_PUB.Count_And_Get(
1027: p_encoded => 'F'

Line 1025: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1021: ,p_data => x_msg_data
1022: );
1023: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1024: ROLLBACK TO BSCLocksPubGetSystemLocks;
1025: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1026: FND_MSG_PUB.Count_And_Get(
1027: p_encoded => 'F'
1028: ,p_count => x_msg_count
1029: ,p_data => x_msg_data

Line 1038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1034: G_PKG_NAME,
1035: l_api_name,
1036: SQLERRM
1037: );
1038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1039: FND_MSG_PUB.Count_And_Get(
1040: p_encoded => 'F'
1041: ,p_count => x_msg_count
1042: ,p_data => x_msg_data

Line 1107: x_return_status := FND_API.G_RET_STS_SUCCESS;

1103: BEGIN
1104: --DBMS_OUTPUT.PUT_LINE('GET_SYSTEM_LOCKS');
1105: SAVEPOINT BSCLocksPubGetSystemLocks;
1106: FND_MSG_PUB.Initialize;
1107: x_return_status := FND_API.G_RET_STS_SUCCESS;
1108: BSC_LOCKS_PVT.Initialize;
1109:
1110: IF (p_object_keys.COUNT <> 0 AND
1111: p_object_keys.COUNT = p_object_types.COUNT AND

Line 1130: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

1126: ,x_return_status => x_return_status
1127: ,x_msg_count => x_msg_count
1128: ,x_msg_data => x_msg_data
1129: );
1130: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1131: RAISE FND_API.G_EXC_ERROR;
1132: ELSIF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1134: END IF;

Line 1131: RAISE FND_API.G_EXC_ERROR;

1127: ,x_msg_count => x_msg_count
1128: ,x_msg_data => x_msg_data
1129: );
1130: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1131: RAISE FND_API.G_EXC_ERROR;
1132: ELSIF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1134: END IF;
1135: ELSIF (p_lock_types(j) = 'W' AND

Line 1132: ELSIF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1128: ,x_msg_data => x_msg_data
1129: );
1130: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1131: RAISE FND_API.G_EXC_ERROR;
1132: ELSIF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1134: END IF;
1135: ELSIF (p_lock_types(j) = 'W' AND
1136: p_object_keys(i) = p_object_keys(j) AND

Line 1133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1129: );
1130: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1131: RAISE FND_API.G_EXC_ERROR;
1132: ELSIF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1134: END IF;
1135: ELSIF (p_lock_types(j) = 'W' AND
1136: p_object_keys(i) = p_object_keys(j) AND
1137: p_object_types(i) = p_object_types(j)) THEN

Line 1160: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

1156: ,x_return_status => x_return_status
1157: ,x_msg_count => x_msg_count
1158: ,x_msg_data => x_msg_data
1159: );
1160: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1161: RAISE FND_API.G_EXC_ERROR;
1162: ELSIF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1164: END IF;

Line 1161: RAISE FND_API.G_EXC_ERROR;

1157: ,x_msg_count => x_msg_count
1158: ,x_msg_data => x_msg_data
1159: );
1160: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1161: RAISE FND_API.G_EXC_ERROR;
1162: ELSIF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1164: END IF;
1165: ELSIF (p_object_keys(i) = p_object_keys(j) AND

Line 1162: ELSIF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1158: ,x_msg_data => x_msg_data
1159: );
1160: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1161: RAISE FND_API.G_EXC_ERROR;
1162: ELSIF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1164: END IF;
1165: ELSIF (p_object_keys(i) = p_object_keys(j) AND
1166: p_object_types(i) = p_object_types(j)) THEN

Line 1163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1159: );
1160: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1161: RAISE FND_API.G_EXC_ERROR;
1162: ELSIF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1164: END IF;
1165: ELSIF (p_object_keys(i) = p_object_keys(j) AND
1166: p_object_types(i) = p_object_types(j)) THEN
1167: EXIT;

Line 1175: WHEN FND_API.G_EXC_ERROR THEN

1171: END LOOP;
1172: END IF;
1173:
1174: EXCEPTION
1175: WHEN FND_API.G_EXC_ERROR THEN
1176: ROLLBACK TO BSCLocksPubGetSystemLocks;
1177: x_return_status := FND_API.G_RET_STS_ERROR;
1178: FND_MSG_PUB.Count_And_Get(
1179: p_encoded => 'F'

Line 1177: x_return_status := FND_API.G_RET_STS_ERROR;

1173:
1174: EXCEPTION
1175: WHEN FND_API.G_EXC_ERROR THEN
1176: ROLLBACK TO BSCLocksPubGetSystemLocks;
1177: x_return_status := FND_API.G_RET_STS_ERROR;
1178: FND_MSG_PUB.Count_And_Get(
1179: p_encoded => 'F'
1180: ,p_count => x_msg_count
1181: ,p_data => x_msg_data

Line 1183: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1179: p_encoded => 'F'
1180: ,p_count => x_msg_count
1181: ,p_data => x_msg_data
1182: );
1183: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1184: ROLLBACK TO BSCLocksPubGetSystemLocks;
1185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1186: FND_MSG_PUB.Count_And_Get(
1187: p_encoded => 'F'

Line 1185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1181: ,p_data => x_msg_data
1182: );
1183: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1184: ROLLBACK TO BSCLocksPubGetSystemLocks;
1185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1186: FND_MSG_PUB.Count_And_Get(
1187: p_encoded => 'F'
1188: ,p_count => x_msg_count
1189: ,p_data => x_msg_data

Line 1198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1194: G_PKG_NAME,
1195: l_api_name,
1196: SQLERRM
1197: );
1198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1199: FND_MSG_PUB.Count_And_Get(
1200: p_encoded => 'F'
1201: ,p_count => x_msg_count
1202: ,p_data => x_msg_data

Line 1262: x_return_status := FND_API.G_RET_STS_SUCCESS;

1258: BEGIN
1259: --DBMS_OUTPUT.PUT_LINE('GET_SYSTEM_LOCK: '||p_object_type);
1260: SAVEPOINT BSCLocksPubGetSystemLock;
1261: FND_MSG_PUB.Initialize;
1262: x_return_status := FND_API.G_RET_STS_SUCCESS;
1263: BSC_LOCKS_PVT.Initialize;
1264:
1265: -- Get the machine and terminal information
1266: BSC_LOCKS_PVT.GET_SESSION

Line 1342: WHEN FND_API.G_EXC_ERROR THEN

1338: END IF;
1339:
1340:
1341: EXCEPTION
1342: WHEN FND_API.G_EXC_ERROR THEN
1343: ROLLBACK TO BSCLocksPubGetSystemLock;
1344: x_return_status := FND_API.G_RET_STS_ERROR;
1345: FND_MSG_PUB.Count_And_Get(
1346: p_encoded => 'F'

Line 1344: x_return_status := FND_API.G_RET_STS_ERROR;

1340:
1341: EXCEPTION
1342: WHEN FND_API.G_EXC_ERROR THEN
1343: ROLLBACK TO BSCLocksPubGetSystemLock;
1344: x_return_status := FND_API.G_RET_STS_ERROR;
1345: FND_MSG_PUB.Count_And_Get(
1346: p_encoded => 'F'
1347: ,p_count => x_msg_count
1348: ,p_data => x_msg_data

Line 1350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1346: p_encoded => 'F'
1347: ,p_count => x_msg_count
1348: ,p_data => x_msg_data
1349: );
1350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1351: ROLLBACK TO BSCLocksPubGetSystemLock;
1352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1353: FND_MSG_PUB.Count_And_Get(
1354: p_encoded => 'F'

Line 1352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1348: ,p_data => x_msg_data
1349: );
1350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1351: ROLLBACK TO BSCLocksPubGetSystemLock;
1352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1353: FND_MSG_PUB.Count_And_Get(
1354: p_encoded => 'F'
1355: ,p_count => x_msg_count
1356: ,p_data => x_msg_data

Line 1365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1361: G_PKG_NAME,
1362: l_api_name,
1363: SQLERRM
1364: );
1365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1366: FND_MSG_PUB.Count_And_Get(
1367: p_encoded => 'F'
1368: ,p_count => x_msg_count
1369: ,p_data => x_msg_data

Line 1422: x_return_status := FND_API.G_RET_STS_SUCCESS;

1418: BEGIN
1419: --DBMS_OUTPUT.PUT_LINE('GET_SYSTEM_LOCK');
1420: SAVEPOINT BSCLocksPubGetSystemLock;
1421: FND_MSG_PUB.Initialize;
1422: x_return_status := FND_API.G_RET_STS_SUCCESS;
1423: BSC_LOCKS_PVT.Initialize;
1424: l_insert_flag := FALSE;
1425:
1426: -- Get the machine and terminal information

Line 1533: WHEN FND_API.G_EXC_ERROR THEN

1529: ,x_msg_data => x_msg_data
1530: );
1531:
1532: EXCEPTION
1533: WHEN FND_API.G_EXC_ERROR THEN
1534: ROLLBACK TO BSCLocksPubGetSystemLock;
1535: x_return_status := FND_API.G_RET_STS_ERROR;
1536: FND_MSG_PUB.Count_And_Get(
1537: p_encoded => 'F'

Line 1535: x_return_status := FND_API.G_RET_STS_ERROR;

1531:
1532: EXCEPTION
1533: WHEN FND_API.G_EXC_ERROR THEN
1534: ROLLBACK TO BSCLocksPubGetSystemLock;
1535: x_return_status := FND_API.G_RET_STS_ERROR;
1536: FND_MSG_PUB.Count_And_Get(
1537: p_encoded => 'F'
1538: ,p_count => x_msg_count
1539: ,p_data => x_msg_data

Line 1541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1537: p_encoded => 'F'
1538: ,p_count => x_msg_count
1539: ,p_data => x_msg_data
1540: );
1541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1542: ROLLBACK TO BSCLocksPubGetSystemLock;
1543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1544: FND_MSG_PUB.Count_And_Get(
1545: p_encoded => 'F'

Line 1543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1539: ,p_data => x_msg_data
1540: );
1541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1542: ROLLBACK TO BSCLocksPubGetSystemLock;
1543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1544: FND_MSG_PUB.Count_And_Get(
1545: p_encoded => 'F'
1546: ,p_count => x_msg_count
1547: ,p_data => x_msg_data

Line 1556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1552: G_PKG_NAME,
1553: l_api_name,
1554: SQLERRM
1555: );
1556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1557: FND_MSG_PUB.Count_And_Get(
1558: p_encoded => 'F'
1559: ,p_count => x_msg_count
1560: ,p_data => x_msg_data

Line 1635: x_return_status := FND_API.G_RET_STS_SUCCESS;

1631:
1632: BEGIN
1633: --DBMS_OUTPUT.PUT_LINE('GET_SYSTEM_LOCK');
1634: FND_MSG_PUB.Initialize;
1635: x_return_status := FND_API.G_RET_STS_SUCCESS;
1636: BSC_LOCKS_PVT.Initialize;
1637:
1638: BSC_SECURITY.Refresh_System_Lock(p_program_id);
1639: --Delete all orphan the sessions

Line 1687: RAISE FND_API.G_EXC_ERROR;

1683: FND_MESSAGE.SET_TOKEN('USERNAME' ,cd.user_name, TRUE);
1684: FND_MESSAGE.SET_TOKEN('MACHINE' ,cd.machine, TRUE);
1685: FND_MESSAGE.SET_TOKEN('TERMINAL' ,cd.terminal, TRUE);
1686: FND_MSG_PUB.ADD;
1687: RAISE FND_API.G_EXC_ERROR;
1688: END LOOP;
1689:
1690: OPEN c_existing_session(p_program_id, p_icx_session_id);
1691: FETCH c_existing_session INTO l_session_id;

Line 1719: WHEN FND_API.G_EXC_ERROR THEN

1715: END IF;
1716: CLOSE c_existing_session;
1717:
1718: EXCEPTION
1719: WHEN FND_API.G_EXC_ERROR THEN
1720: x_return_status := FND_API.G_RET_STS_ERROR;
1721: FND_MSG_PUB.Count_And_Get(
1722: p_encoded => 'F'
1723: ,p_count => x_msg_count

Line 1720: x_return_status := FND_API.G_RET_STS_ERROR;

1716: CLOSE c_existing_session;
1717:
1718: EXCEPTION
1719: WHEN FND_API.G_EXC_ERROR THEN
1720: x_return_status := FND_API.G_RET_STS_ERROR;
1721: FND_MSG_PUB.Count_And_Get(
1722: p_encoded => 'F'
1723: ,p_count => x_msg_count
1724: ,p_data => x_msg_data

Line 1726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1722: p_encoded => 'F'
1723: ,p_count => x_msg_count
1724: ,p_data => x_msg_data
1725: );
1726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1728: FND_MSG_PUB.Count_And_Get(
1729: p_encoded => 'F'
1730: ,p_count => x_msg_count

Line 1727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1723: ,p_count => x_msg_count
1724: ,p_data => x_msg_data
1725: );
1726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1728: FND_MSG_PUB.Count_And_Get(
1729: p_encoded => 'F'
1730: ,p_count => x_msg_count
1731: ,p_data => x_msg_data

Line 1739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1735: G_PKG_NAME,
1736: l_api_name,
1737: SQLERRM
1738: );
1739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1740: FND_MSG_PUB.Count_And_Get(
1741: p_encoded => 'F'
1742: ,p_count => x_msg_count
1743: ,p_data => x_msg_data