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_MSG_PUB

Line 63: FND_MSG_PUB.Initialize;

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

Line 181: FND_MSG_PUB.Count_And_Get(

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

Line 189: FND_MSG_PUB.Count_And_Get(

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

Line 196: FND_MSG_PUB.Add_Exc_Msg(

192: ,p_data => x_msg_data
193: );
194: WHEN OTHERS THEN
195: ROLLBACK TO BSCLocksPubCheckSystemLock;
196: FND_MSG_PUB.Add_Exc_Msg(
197: G_PKG_NAME,
198: l_api_name,
199: SQLERRM
200: );

Line 202: FND_MSG_PUB.Count_And_Get(

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

Line 260: FND_MSG_PUB.Initialize;

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

Line 288: FND_MSG_PUB.Count_And_Get(

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

Line 296: FND_MSG_PUB.Count_And_Get(

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

Line 303: FND_MSG_PUB.Add_Exc_Msg(

299: ,p_data => x_msg_data
300: );
301: WHEN OTHERS THEN
302: ROLLBACK TO BSCLocksPubCheckSystemLocks;
303: FND_MSG_PUB.Add_Exc_Msg(
304: G_PKG_NAME,
305: l_api_name,
306: SQLERRM
307: );

Line 309: FND_MSG_PUB.Count_And_Get(

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

Line 443: FND_MSG_PUB.Initialize;

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

Line 665: FND_MSG_PUB.Count_And_Get(

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

Line 673: FND_MSG_PUB.Count_And_Get(

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

Line 680: FND_MSG_PUB.Add_Exc_Msg(

676: ,p_data => x_msg_data
677: );
678: WHEN OTHERS THEN
679: ROLLBACK TO BSCLocksPubSynchronize;
680: FND_MSG_PUB.Add_Exc_Msg(
681: G_PKG_NAME,
682: l_api_name,
683: SQLERRM
684: );

Line 686: FND_MSG_PUB.Count_And_Get(

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

Line 761: FND_MSG_PUB.Initialize;

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

Line 891: FND_MSG_PUB.Count_And_Get(

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

Line 899: FND_MSG_PUB.Count_And_Get(

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

Line 906: FND_MSG_PUB.Add_Exc_Msg(

902: ,p_data => x_msg_data
903: );
904: WHEN OTHERS THEN
905: ROLLBACK TO BSCLocksPubGetSystemLock;
906: FND_MSG_PUB.Add_Exc_Msg(
907: G_PKG_NAME,
908: l_api_name,
909: SQLERRM
910: );

Line 912: FND_MSG_PUB.Count_And_Get(

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

Line 979: FND_MSG_PUB.Initialize;

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

Line 1018: FND_MSG_PUB.Count_And_Get(

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

Line 1026: FND_MSG_PUB.Count_And_Get(

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

Line 1033: FND_MSG_PUB.Add_Exc_Msg(

1029: ,p_data => x_msg_data
1030: );
1031: WHEN OTHERS THEN
1032: ROLLBACK TO BSCLocksPubGetSystemLocks;
1033: FND_MSG_PUB.Add_Exc_Msg(
1034: G_PKG_NAME,
1035: l_api_name,
1036: SQLERRM
1037: );

Line 1039: FND_MSG_PUB.Count_And_Get(

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

Line 1106: FND_MSG_PUB.Initialize;

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

Line 1178: FND_MSG_PUB.Count_And_Get(

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

Line 1186: FND_MSG_PUB.Count_And_Get(

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

Line 1193: FND_MSG_PUB.Add_Exc_Msg(

1189: ,p_data => x_msg_data
1190: );
1191: WHEN OTHERS THEN
1192: ROLLBACK TO BSCLocksPubGetSystemLocks;
1193: FND_MSG_PUB.Add_Exc_Msg(
1194: G_PKG_NAME,
1195: l_api_name,
1196: SQLERRM
1197: );

Line 1199: FND_MSG_PUB.Count_And_Get(

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

Line 1261: FND_MSG_PUB.Initialize;

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

Line 1345: FND_MSG_PUB.Count_And_Get(

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

Line 1353: FND_MSG_PUB.Count_And_Get(

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

Line 1360: FND_MSG_PUB.Add_Exc_Msg(

1356: ,p_data => x_msg_data
1357: );
1358: WHEN OTHERS THEN
1359: ROLLBACK TO BSCLocksPubGetSystemLock;
1360: FND_MSG_PUB.Add_Exc_Msg(
1361: G_PKG_NAME,
1362: l_api_name,
1363: SQLERRM
1364: );

Line 1366: FND_MSG_PUB.Count_And_Get(

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

Line 1421: FND_MSG_PUB.Initialize;

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

Line 1536: FND_MSG_PUB.Count_And_Get(

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

Line 1544: FND_MSG_PUB.Count_And_Get(

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

Line 1551: FND_MSG_PUB.Add_Exc_Msg(

1547: ,p_data => x_msg_data
1548: );
1549: WHEN OTHERS THEN
1550: ROLLBACK TO BSCLocksPubGetSystemLock;
1551: FND_MSG_PUB.Add_Exc_Msg(
1552: G_PKG_NAME,
1553: l_api_name,
1554: SQLERRM
1555: );

Line 1557: FND_MSG_PUB.Count_And_Get(

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

Line 1634: FND_MSG_PUB.Initialize;

1630: AND PROGRAM_ID = c_program_id;
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);

Line 1686: FND_MSG_PUB.ADD;

1682: FND_MESSAGE.SET_TOKEN('COMPONENT',BSC_LOCKS_PVT.g_modules(cd.program_id) , TRUE);
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);

Line 1721: FND_MSG_PUB.Count_And_Get(

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

Line 1728: FND_MSG_PUB.Count_And_Get(

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

Line 1734: FND_MSG_PUB.Add_Exc_Msg(

1730: ,p_count => x_msg_count
1731: ,p_data => x_msg_data
1732: );
1733: WHEN OTHERS THEN
1734: FND_MSG_PUB.Add_Exc_Msg(
1735: G_PKG_NAME,
1736: l_api_name,
1737: SQLERRM
1738: );

Line 1740: FND_MSG_PUB.Count_And_Get(

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