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.PSB_WRHR_EXTRACT_PROCESS dependencies on PSB_CONCURRENCY_CONTROL_PVT

Line 662: PSB_CONCURRENCY_CONTROL_PVT.Enforce_Concurrency_Control

658:
659: FND_FILE.Put_Line( FND_FILE.OUTPUT,
660: 'Processing the given Data Extract : ' ||l_data_extract_name);
661:
662: PSB_CONCURRENCY_CONTROL_PVT.Enforce_Concurrency_Control
663: (p_api_version => 1.0 ,
664: p_return_status => l_return_status,
665: p_concurrency_class => 'DATAEXTRACT_CREATION',
666: p_concurrency_entity_name => 'DATA_EXTRACT',

Line 690: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control

686: raise FND_API.G_EXC_ERROR;
687: END IF;
688: --
689:
690: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control
691: (p_api_version => 1.0,
692: p_return_status => l_return_status,
693: p_concurrency_class => 'DATAEXTRACT_CREATION',
694: p_concurrency_entity_name => 'DATA_EXTRACT',

Line 713: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control

709:
710: WHEN FND_API.G_EXC_ERROR THEN
711: --
712:
713: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control
714: (p_api_version => 1.0 ,
715: p_return_status => l_return_status,
716: p_concurrency_class => 'DATAEXTRACT_CREATION',
717: p_concurrency_entity_name => 'DATA_EXTRACT',

Line 729: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control

725: --
726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
727: --
728:
729: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control
730: (p_api_version => 1.0 ,
731: p_return_status => l_return_status,
732: p_concurrency_class => 'DATAEXTRACT_CREATION',
733: p_concurrency_entity_name => 'DATA_EXTRACT',

Line 743: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control

739: COMMIT WORK ;
740: --
741: WHEN OTHERS THEN
742:
743: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control
744: (p_api_version => 1.0 ,
745: p_return_status => l_return_status,
746: p_concurrency_class => 'DATAEXTRACT_CREATION',
747: p_concurrency_entity_name => 'DATA_EXTRACT',

Line 846: PSB_CONCURRENCY_CONTROL_PVT.Enforce_Concurrency_Control

842: if ( (p_request_set_flag = 'Y') and (l_default_data_flag = 'Y') ) then -- for Pre MPA DE
843:
844: if (l_default_data_status <> 'C') then
845:
846: PSB_CONCURRENCY_CONTROL_PVT.Enforce_Concurrency_Control
847: (p_api_version => 1.0 ,
848: p_return_status => l_return_status,
849: p_concurrency_class => 'DATAEXTRACT_CREATION',
850: p_concurrency_entity_name => 'DATA_EXTRACT',

Line 874: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control

870: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
871: raise FND_API.G_EXC_ERROR;
872: END IF;
873:
874: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control
875: (p_api_version => 1.0 ,
876: p_return_status => l_return_status,
877: p_concurrency_class => 'DATAEXTRACT_CREATION',
878: p_concurrency_entity_name => 'DATA_EXTRACT',

Line 920: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control

916: EXCEPTION
917:
918: WHEN OTHERS THEN
919:
920: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control
921: (p_api_version => 1.0 ,
922: p_return_status => l_return_status,
923: p_concurrency_class => 'DATAEXTRACT_CREATION',
924: p_concurrency_entity_name => 'DATA_EXTRACT',

Line 1256: PSB_CONCURRENCY_CONTROL_PVT.Enforce_Concurrency_Control

1252: if (p_copy_defaults_flag = 'Y') then
1253:
1254: if ((p_copy_defaults_status is null) or (p_copy_defaults_status <> 'C')) then
1255:
1256: PSB_CONCURRENCY_CONTROL_PVT.Enforce_Concurrency_Control
1257: (p_api_version => 1.0 ,
1258: p_return_status => l_return_status,
1259: p_concurrency_class => 'DATAEXTRACT_CREATION',
1260: p_concurrency_entity_name => 'DATA_EXTRACT',

Line 1285: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control

1281: FND_FILE.put_line(FND_FILE.LOG,'Copy Attribute Values Failed');
1282: end if;
1283:
1284:
1285: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control
1286: (p_api_version => 1.0 ,
1287: p_return_status => l_return_status,
1288: p_concurrency_class => 'DATAEXTRACT_CREATION',
1289: p_concurrency_entity_name => 'DATA_EXTRACT',

Line 1382: PSB_CONCURRENCY_CONTROL_PVT.Enforce_Concurrency_Control

1378: BEGIN
1379:
1380: if (p_copy_defaults_flag = 'Y') then
1381: if ((p_copy_defaults_status is null) or (p_copy_defaults_status <> 'C')) then
1382: PSB_CONCURRENCY_CONTROL_PVT.Enforce_Concurrency_Control
1383: (p_api_version => 1.0 ,
1384: p_return_status => l_return_status,
1385: p_concurrency_class => 'DATAEXTRACT_CREATION',
1386: p_concurrency_entity_name => 'DATA_EXTRACT',

Line 1412: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control

1408: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1409: FND_FILE.put_line(FND_FILE.LOG,'Copy Elements Failed');
1410: end if;
1411:
1412: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control
1413: (p_api_version => 1.0 ,
1414: p_return_status => l_return_status,
1415: p_concurrency_class => 'DATAEXTRACT_CREATION',
1416: p_concurrency_entity_name => 'DATA_EXTRACT',

Line 1506: PSB_CONCURRENCY_CONTROL_PVT.Enforce_Concurrency_Control

1502:
1503: if (p_copy_defaults_flag = 'Y') then
1504: if ((p_copy_defaults_status is null) or (p_copy_defaults_status <> 'C')) then
1505:
1506: PSB_CONCURRENCY_CONTROL_PVT.Enforce_Concurrency_Control
1507: (p_api_version => 1.0 ,
1508: p_return_status => l_return_status,
1509: p_concurrency_class => 'DATAEXTRACT_CREATION',
1510: p_concurrency_entity_name => 'DATA_EXTRACT',

Line 1534: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control

1530: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1531: FND_FILE.put_line(FND_FILE.LOG,'Copy Position Sets Failed');
1532: end if;
1533:
1534: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control
1535: (p_api_version => 1.0 ,
1536: p_return_status => l_return_status,
1537: p_concurrency_class => 'DATAEXTRACT_CREATION',
1538: p_concurrency_entity_name => 'DATA_EXTRACT',

Line 1629: PSB_CONCURRENCY_CONTROL_PVT.Enforce_Concurrency_Control

1625:
1626: if (p_copy_defaults_flag = 'Y') then
1627: if ((p_copy_defaults_status is null) or (p_copy_defaults_status <> 'C')) then
1628:
1629: PSB_CONCURRENCY_CONTROL_PVT.Enforce_Concurrency_Control
1630: (p_api_version => 1.0 ,
1631: p_return_status => l_return_status,
1632: p_concurrency_class => 'DATAEXTRACT_CREATION',
1633: p_concurrency_entity_name => 'DATA_EXTRACT',

Line 1657: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control

1653: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1654: FND_FILE.put_line(FND_FILE.LOG,'Copy Default Rules Failed');
1655: end if;
1656:
1657: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control
1658: (p_api_version => 1.0 ,
1659: p_return_status => l_return_status,
1660: p_concurrency_class => 'DATAEXTRACT_CREATION',
1661: p_concurrency_entity_name => 'DATA_EXTRACT',

Line 1804: PSB_CONCURRENCY_CONTROL_PVT.Enforce_Concurrency_Control

1800: end if;
1801:
1802: if (p_populate_data_flag = 'Y') then
1803: if ((p_populate_data_status is null) or (p_populate_data_status <> 'C')) then
1804: PSB_CONCURRENCY_CONTROL_PVT.Enforce_Concurrency_Control
1805: (p_api_version => 1.0 ,
1806: p_return_status => l_return_status,
1807: p_concurrency_class => 'DATAEXTRACT_CREATION',
1808: p_concurrency_entity_name => 'DATA_EXTRACT',

Line 1836: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control

1832: FND_FILE.put_line(FND_FILE.LOG,'Populate Position Failed');
1833:
1834: end if;
1835:
1836: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control
1837: (p_api_version => 1.0 ,
1838: p_return_status => l_return_status,
1839: p_concurrency_class => 'DATAEXTRACT_CREATION',
1840: p_concurrency_entity_name => 'DATA_EXTRACT',

Line 1989: PSB_CONCURRENCY_CONTROL_PVT.Enforce_Concurrency_Control

1985:
1986: if (p_populate_data_flag = 'Y') then
1987: if ((p_populate_data_status is null) or (p_populate_data_status <> 'C')) then
1988:
1989: PSB_CONCURRENCY_CONTROL_PVT.Enforce_Concurrency_Control
1990: (p_api_version => 1.0 ,
1991: p_return_status => l_return_status,
1992: p_concurrency_class => 'DATAEXTRACT_CREATION',
1993: p_concurrency_entity_name => 'DATA_EXTRACT',

Line 2019: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control

2015: FND_FILE.put_line(FND_FILE.LOG,'Populate Elements Failed');
2016: raise FND_API.G_EXC_ERROR;
2017: end if;
2018:
2019: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control
2020: (p_api_version => 1.0 ,
2021: p_return_status => l_return_status,
2022: p_concurrency_class => 'DATAEXTRACT_CREATION',
2023: p_concurrency_entity_name => 'DATA_EXTRACT',

Line 2190: PSB_CONCURRENCY_CONTROL_PVT.Enforce_Concurrency_Control

2186:
2187: if (p_populate_data_flag = 'Y') then
2188: if ((p_populate_data_status is null) or (p_populate_data_status <> 'C')) then
2189:
2190: PSB_CONCURRENCY_CONTROL_PVT.Enforce_Concurrency_Control
2191: (p_api_version => 1.0 ,
2192: p_return_status => l_return_status,
2193: p_concurrency_class => 'DATAEXTRACT_CREATION',
2194: p_concurrency_entity_name => 'DATA_EXTRACT',

Line 2218: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control

2214: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2215: FND_FILE.put_line(FND_FILE.LOG,'Populate Attribute Values Failed');
2216: end if;
2217:
2218: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control
2219: (p_api_version => 1.0 ,
2220: p_return_status => l_return_status,
2221: p_concurrency_class => 'DATAEXTRACT_CREATION',
2222: p_concurrency_entity_name => 'DATA_EXTRACT',

Line 2370: PSB_CONCURRENCY_CONTROL_PVT.Enforce_Concurrency_Control

2366:
2367: if (p_populate_data_flag = 'Y') then
2368: if ((p_populate_data_status is null) or (p_populate_data_status <> 'C')) then
2369:
2370: PSB_CONCURRENCY_CONTROL_PVT.Enforce_Concurrency_Control
2371: (p_api_version => 1.0 ,
2372: p_return_status => l_return_status,
2373: p_concurrency_class => 'DATAEXTRACT_CREATION',
2374: p_concurrency_entity_name => 'DATA_EXTRACT',

Line 2402: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control

2398: FND_FILE.put_line(FND_FILE.LOG,'Populate Employees Failed');
2399: raise FND_API.G_EXC_ERROR;
2400: end if;
2401:
2402: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control
2403: (p_api_version => 1.0 ,
2404: p_return_status => l_return_status,
2405: p_concurrency_class => 'DATAEXTRACT_CREATION',
2406: p_concurrency_entity_name => 'DATA_EXTRACT',

Line 2570: PSB_CONCURRENCY_CONTROL_PVT.Enforce_Concurrency_Control

2566: end if;
2567:
2568: if (p_populate_data_flag = 'Y') then
2569: if ((p_populate_data_status is null) or (p_populate_data_status <> 'C')) then
2570: PSB_CONCURRENCY_CONTROL_PVT.Enforce_Concurrency_Control
2571: (p_api_version => 1.0 ,
2572: p_return_status => l_return_status,
2573: p_concurrency_class => 'DATAEXTRACT_CREATION',
2574: p_concurrency_entity_name => 'DATA_EXTRACT',

Line 2600: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control

2596: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2597: FND_FILE.put_line(FND_FILE.LOG,'Populate Costing Failed');
2598: end if;
2599:
2600: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control
2601: (p_api_version => 1.0 ,
2602: p_return_status => l_return_status,
2603: p_concurrency_class => 'DATAEXTRACT_CREATION',
2604: p_concurrency_entity_name => 'DATA_EXTRACT',

Line 2746: PSB_CONCURRENCY_CONTROL_PVT.Enforce_Concurrency_Control

2742: end if;
2743:
2744: if (p_populate_data_flag = 'Y') then
2745: if ((p_populate_data_status is null) or (p_populate_data_status <> 'C')) then
2746: PSB_CONCURRENCY_CONTROL_PVT.Enforce_Concurrency_Control
2747: (p_api_version => 1.0 ,
2748: p_return_status => l_return_status,
2749: p_concurrency_class => 'DATAEXTRACT_CREATION',
2750: p_concurrency_entity_name => 'DATA_EXTRACT',

Line 2777: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control

2773: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2774: FND_FILE.put_line(FND_FILE.LOG,'Populate Position Assign Failed');
2775: end if;
2776:
2777: PSB_CONCURRENCY_CONTROL_PVT.Release_Concurrency_Control
2778: (p_api_version => 1.0 ,
2779: p_return_status => l_return_status,
2780: p_concurrency_class => 'DATAEXTRACT_CREATION',
2781: p_concurrency_entity_name => 'DATA_EXTRACT',