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.EAM_ACTIVITY_PUB dependencies on EAM_ACTIVITY_PUB

Line 1: PACKAGE BODY EAM_Activity_PUB AS

1: PACKAGE BODY EAM_Activity_PUB AS
2: /* $Header: EAMPACTB.pls 120.3.12020000.2 2012/07/05 10:34:47 vpasupur ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='EAM_AssetActivity_PUB';
5:

Line 42: p_work_order_rec IN EAM_Activity_PUB.Work_Order_Rec_Type,

38:
39: END;
40:
41: PROCEDURE Validate_Copy_Options(
42: p_work_order_rec IN EAM_Activity_PUB.Work_Order_Rec_Type,
43: p_operation_copy_option IN NUMBER,
44: p_material_copy_option IN NUMBER,
45: p_resource_copy_option IN NUMBER,
46: p_association_copy_option IN NUMBER

Line 132: p_work_order_rec IN EAM_Activity_PUB.Work_Order_Rec_Type,

128:
129: -- ----------------------------------------------------------------------
130: PROCEDURE Create_Activity_Routing(
131: p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,
132: p_work_order_rec IN EAM_Activity_PUB.Work_Order_Rec_Type,
133: p_operation_copy_option IN NUMBER,
134: p_resource_copy_option IN NUMBER,
135:
136: x_rtg_header_rec OUT NOCOPY BOM_Rtg_Pub.Rtg_Header_Rec_Type,

Line 208: EAM_ActivityUtilities_PVT.Write_Debug('---------- Entering EAM_Activity_PUB.Create_Activity_Routing ----------');

204: WHERE organization_id = p_organization_id
205: AND wip_entity_id = p_wip_entity_id;
206:
207: BEGIN
208: EAM_ActivityUtilities_PVT.Write_Debug('---------- Entering EAM_Activity_PUB.Create_Activity_Routing ----------');
209: EAM_ActivityUtilities_PVT.Write_Debug('p_operation_copy_option=' || p_operation_copy_option);
210: EAM_ActivityUtilities_PVT.Write_Debug('p_resource_copy_option=' || p_resource_copy_option);
211: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.organization_id=' || p_target_item_rec.organization_id);
212: EAM_ActivityUtilities_PVT.Write_Debug('p_target_item_rec.organization_code=' || p_target_item_rec.organization_code);

Line 485: EAM_ActivityUtilities_PVT.Write_Debug('---------- Exiting EAM_Activity_PUB.Create_Activity_Routing ----------');

481: x_rtg_msg_list := l_x_rtg_msg_list;
482:
483: END IF;
484:
485: EAM_ActivityUtilities_PVT.Write_Debug('---------- Exiting EAM_Activity_PUB.Create_Activity_Routing ----------');
486: END;
487:
488: -- ----------------------------------------------------------------------
489: PROCEDURE Create_Activity_BOM(

Line 491: p_work_order_rec IN EAM_Activity_PUB.Work_Order_Rec_Type,

487:
488: -- ----------------------------------------------------------------------
489: PROCEDURE Create_Activity_BOM(
490: p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,
491: p_work_order_rec IN EAM_Activity_PUB.Work_Order_Rec_Type,
492: p_material_copy_option IN NUMBER,
493:
494: x_bom_header_rec OUT NOCOPY BOM_BO_PUB.BOM_Head_Rec_Type,
495: x_bom_revision_tbl OUT NOCOPY BOM_BO_PUB.BOM_Revision_Tbl_Type,

Line 748: EAM_ActivityUtilities_PVT.Write_Debug('-------- Beginning EAM_Activity_PUB.Create_Item --------');

744: RAISE FND_API.G_EXC_ERROR;
745: END IF;
746:
747: -- ============================================================
748: EAM_ActivityUtilities_PVT.Write_Debug('-------- Beginning EAM_Activity_PUB.Create_Item --------');
749:
750: -- Save current org id
751: l_curr_organization_id := l_item_rec.organization_id;
752: EAM_ActivityUtilities_PVT.Write_Debug('l_curr_organization_id=' || l_curr_organization_id);

Line 881: EAM_ActivityUtilities_PVT.Write_Debug('-------- Finished EAM_Activity_PUB.Create_Item --------');

877: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
878: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_curr_item_rec);
879:
880: -- ============================================================
881: EAM_ActivityUtilities_PVT.Write_Debug('-------- Finished EAM_Activity_PUB.Create_Item --------');
882: END;
883:
884: -- ======================================================================
885: PROCEDURE Create_Activity

Line 903: p_work_order_rec IN EAM_Activity_PUB.Work_Order_Rec_Type,

899: p_activity_cause_code IN VARCHAR2 := NULL,
900: p_shutdown_type_code IN VARCHAR2 := NULL,
901: p_notification_req_flag IN VARCHAR2 := NULL,
902: p_activity_source_code IN VARCHAR2 := NULL,
903: p_work_order_rec IN EAM_Activity_PUB.Work_Order_Rec_Type,
904: p_operation_copy_option IN NUMBER := 2, -- 1 (NONE) or 2 (ALL)
905: p_material_copy_option IN NUMBER := 2, -- 1 (NONE), 2 (ISSUED), OR 3 (ALL)
906: p_resource_copy_option IN NUMBER := 2, -- 1 (NONE), 2 (ISSUED), OR 3 (ALL)
907: p_association_copy_option IN NUMBER := 2, -- 1 (NONE), 2 (CURRENT), OR 3 (ALL)

Line 910: x_work_order_rec OUT NOCOPY EAM_Activity_PUB.Work_Order_Rec_Type,

906: p_resource_copy_option IN NUMBER := 2, -- 1 (NONE), 2 (ISSUED), OR 3 (ALL)
907: p_association_copy_option IN NUMBER := 2, -- 1 (NONE), 2 (CURRENT), OR 3 (ALL)
908:
909: -- x_inventory_item_id OUT NUMBER, -- the inventory_item_it the system has created
910: x_work_order_rec OUT NOCOPY EAM_Activity_PUB.Work_Order_Rec_Type,
911:
912: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
913: x_curr_item_return_status OUT NOCOPY VARCHAR2,
914: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,

Line 941: x_act_num_association_tbl OUT NOCOPY EAM_Activity_PUB.Activity_Association_Tbl_Type,

937:
938: x_assoc_return_status OUT NOCOPY VARCHAR2,
939: x_assoc_msg_count OUT NOCOPY NUMBER,
940: x_assoc_msg_data OUT NOCOPY VARCHAR2,
941: x_act_num_association_tbl OUT NOCOPY EAM_Activity_PUB.Activity_Association_Tbl_Type,
942: x_activity_association_tbl OUT NOCOPY EAM_Activity_PUB.Activity_Association_Tbl_Type
943: )
944:
945: IS

Line 942: x_activity_association_tbl OUT NOCOPY EAM_Activity_PUB.Activity_Association_Tbl_Type

938: x_assoc_return_status OUT NOCOPY VARCHAR2,
939: x_assoc_msg_count OUT NOCOPY NUMBER,
940: x_assoc_msg_data OUT NOCOPY VARCHAR2,
941: x_act_num_association_tbl OUT NOCOPY EAM_Activity_PUB.Activity_Association_Tbl_Type,
942: x_activity_association_tbl OUT NOCOPY EAM_Activity_PUB.Activity_Association_Tbl_Type
943: )
944:
945: IS
946: l_api_name CONSTANT VARCHAR2(30) := 'Create_Activity';

Line 950: l_x_work_order_rec EAM_Activity_PUB.Work_Order_Rec_Type;

946: l_api_name CONSTANT VARCHAR2(30) := 'Create_Activity';
947: l_api_version CONSTANT NUMBER := 1.0;
948:
949: -- local variables for validating source Work Order
950: l_x_work_order_rec EAM_Activity_PUB.Work_Order_Rec_Type;
951: l_x_work_order_ret_sts VARCHAR2(1);
952:
953: -- local variables for calling INV_Item_GRP package
954: l_asset_activity INV_Item_GRP.Item_rec_type;

Line 987: l_x_act_num_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;

983: -- local variables for call Association Creation package
984: l_x_assoc_return_status VARCHAR2(1);
985: l_x_assoc_msg_count NUMBER;
986: l_x_assoc_msg_data VARCHAR2(20000);
987: l_x_act_num_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;
988: l_x_activity_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;
989:
990:
991: -- ======================================================================

Line 988: l_x_activity_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;

984: l_x_assoc_return_status VARCHAR2(1);
985: l_x_assoc_msg_count NUMBER;
986: l_x_assoc_msg_data VARCHAR2(20000);
987: l_x_act_num_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;
988: l_x_activity_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;
989:
990:
991: -- ======================================================================
992: BEGIN

Line 1012: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Create_Activity ==========');

1008: x_return_status := FND_API.G_RET_STS_SUCCESS;
1009: -- API body
1010:
1011: -- ============================================================
1012: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Create_Activity ==========');
1013: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Id=' || p_asset_activity.Organization_Id);
1014: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Code=' || p_asset_activity.Organization_Code);
1015: EAM_ActivityUtilities_PVT.Write_Debug('Inventory_Item_Id=' || p_asset_activity.Inventory_Item_Id);
1016: EAM_ActivityUtilities_PVT.Write_Debug('Item Number=' || p_asset_activity.Item_Number);

Line 1283: EAM_ActivityUtilities_PVT.Write_Debug('========== Exiting EAM_Activity_PUB.Create_Activity ==========');

1279: p_data => x_msg_data
1280: );
1281:
1282:
1283: EAM_ActivityUtilities_PVT.Write_Debug('========== Exiting EAM_Activity_PUB.Create_Activity ==========');
1284:
1285: -- ======================================================================
1286:
1287: EXCEPTION

Line 1290: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Create_Activity: EXPECTED_ERROR ==========');

1286:
1287: EXCEPTION
1288: WHEN FND_API.G_EXC_ERROR THEN
1289: ROLLBACK TO Create_Activity_PUB;
1290: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Create_Activity: EXPECTED_ERROR ==========');
1291: x_return_status := FND_API.G_RET_STS_ERROR ;
1292: FND_MSG_PUB.Count_And_Get
1293: ( p_count => x_msg_count ,
1294: p_data => x_msg_data

Line 1298: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Create_Activity: UNEXPECTED_ERROR ==========');

1294: p_data => x_msg_data
1295: );
1296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1297: ROLLBACK TO Create_Activity_PUB;
1298: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Create_Activity: UNEXPECTED_ERROR ==========');
1299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1300: FND_MSG_PUB.Count_And_Get
1301: ( p_count => x_msg_count ,
1302: p_data => x_msg_data

Line 1317: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Create_Activity: OTHER ERROR ==========');

1313: );
1314: -- log error message also
1315: EAM_ActivityUtilities_PVT.Write_Debug(FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST, FND_API.G_FALSE));
1316: END IF;
1317: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Create_Activity: OTHER ERROR ==========');
1318: FND_MSG_PUB.Count_And_Get
1319: ( p_count => x_msg_count ,
1320: p_data => x_msg_data
1321: );

Line 1372: x_act_num_association_tbl OUT NOCOPY EAM_Activity_PUB.Activity_Association_Tbl_Type,

1368:
1369: x_assoc_return_status OUT NOCOPY VARCHAR2,
1370: x_assoc_msg_count OUT NOCOPY NUMBER,
1371: x_assoc_msg_data OUT NOCOPY VARCHAR2,
1372: x_act_num_association_tbl OUT NOCOPY EAM_Activity_PUB.Activity_Association_Tbl_Type,
1373: x_activity_association_tbl OUT NOCOPY EAM_Activity_PUB.Activity_Association_Tbl_Type
1374: )
1375: IS
1376: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Activity';

Line 1373: x_activity_association_tbl OUT NOCOPY EAM_Activity_PUB.Activity_Association_Tbl_Type

1369: x_assoc_return_status OUT NOCOPY VARCHAR2,
1370: x_assoc_msg_count OUT NOCOPY NUMBER,
1371: x_assoc_msg_data OUT NOCOPY VARCHAR2,
1372: x_act_num_association_tbl OUT NOCOPY EAM_Activity_PUB.Activity_Association_Tbl_Type,
1373: x_activity_association_tbl OUT NOCOPY EAM_Activity_PUB.Activity_Association_Tbl_Type
1374: )
1375: IS
1376: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Activity';
1377: l_api_version CONSTANT NUMBER := 1.0;

Line 1383: l_x_work_order_rec EAM_Activity_PUB.Work_Order_Rec_Type;

1379: -- local variables
1380: l_create_txn_type CONSTANT VARCHAR(10) := 'CREATE';
1381:
1382: -- local variables for validating source Work Order
1383: l_x_work_order_rec EAM_Activity_PUB.Work_Order_Rec_Type;
1384: l_x_work_order_ret_sts VARCHAR2(1);
1385:
1386: -- local variables for calling INV_Item_GRP package
1387: l_asset_activity INV_Item_GRP.Item_rec_type;

Line 1431: l_x_act_num_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;

1427: -- local variables for call Association Creation package
1428: l_x_assoc_return_status VARCHAR2(1);
1429: l_x_assoc_msg_count NUMBER;
1430: l_x_assoc_msg_data VARCHAR2(20000);
1431: l_x_act_num_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;
1432: l_x_activity_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;
1433:
1434: BEGIN
1435: -- Standard Start of API savepoint

Line 1432: l_x_activity_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;

1428: l_x_assoc_return_status VARCHAR2(1);
1429: l_x_assoc_msg_count NUMBER;
1430: l_x_assoc_msg_data VARCHAR2(20000);
1431: l_x_act_num_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;
1432: l_x_activity_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;
1433:
1434: BEGIN
1435: -- Standard Start of API savepoint
1436: SAVEPOINT Copy_Activity_PUB;

Line 1454: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Copy_Activity ==========');

1450: x_return_status := FND_API.G_RET_STS_SUCCESS;
1451: -- API body
1452:
1453: -- ============================================================
1454: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Copy_Activity ==========');
1455: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Id=' || p_asset_activity.Organization_Id);
1456: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Code=' || p_asset_activity.Organization_Code);
1457: EAM_ActivityUtilities_PVT.Write_Debug('Inventory_Item_Id=' || p_asset_activity.Inventory_Item_Id);
1458: EAM_ActivityUtilities_PVT.Write_Debug('Item Number=' || p_asset_activity.Item_Number);

Line 1848: EAM_ActivityUtilities_PVT.Write_Debug('========== Exiting EAM_Activity_PUB.Copy_Activity ==========');

1844: ( p_count => x_msg_count ,
1845: p_data => x_msg_data
1846: );
1847:
1848: EAM_ActivityUtilities_PVT.Write_Debug('========== Exiting EAM_Activity_PUB.Copy_Activity ==========');
1849:
1850:
1851: -- ======================================================================
1852: EXCEPTION

Line 1855: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Copy_Activity: EXPECTED_ERROR ==========');

1851: -- ======================================================================
1852: EXCEPTION
1853: WHEN FND_API.G_EXC_ERROR THEN
1854: ROLLBACK TO Copy_Activity_PUB;
1855: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Copy_Activity: EXPECTED_ERROR ==========');
1856: x_return_status := FND_API.G_RET_STS_ERROR ;
1857: FND_MSG_PUB.Count_And_Get
1858: ( p_count => x_msg_count ,
1859: p_data => x_msg_data

Line 1863: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Copy_Activity: UNEXPECTED_ERROR ==========');

1859: p_data => x_msg_data
1860: );
1861: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1862: ROLLBACK TO Copy_Activity_PUB;
1863: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Copy_Activity: UNEXPECTED_ERROR ==========');
1864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1865: FND_MSG_PUB.Count_And_Get
1866: ( p_count => x_msg_count ,
1867: p_data => x_msg_data

Line 1883: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Copy_Activity: OTHER ERROR ==========');

1879: );
1880: -- log error message also
1881: EAM_ActivityUtilities_PVT.Write_Debug(FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST, FND_API.G_FALSE));
1882: END IF;
1883: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Copy_Activity: OTHER ERROR ==========');
1884: FND_MSG_PUB.Count_And_Get
1885: ( p_count => x_msg_count ,
1886: p_data => x_msg_data
1887: );

Line 1938: l_work_order_rec EAM_Activity_PUB.Work_Order_Rec_Type;

1934: l_x_msg_count NUMBER;
1935: l_x_msg_data VARCHAR2(20000);
1936:
1937: l_asset_activity INV_Item_GRP.Item_Rec_Type;
1938: l_work_order_rec EAM_Activity_PUB.Work_Order_Rec_Type;
1939: l_x_inventory_item_id NUMBER;
1940: l_x_work_order_rec EAM_Activity_PUB.Work_Order_Rec_Type;
1941:
1942: -- output variables of inv package

Line 1940: l_x_work_order_rec EAM_Activity_PUB.Work_Order_Rec_Type;

1936:
1937: l_asset_activity INV_Item_GRP.Item_Rec_Type;
1938: l_work_order_rec EAM_Activity_PUB.Work_Order_Rec_Type;
1939: l_x_inventory_item_id NUMBER;
1940: l_x_work_order_rec EAM_Activity_PUB.Work_Order_Rec_Type;
1941:
1942: -- output variables of inv package
1943: l_x_curr_item_rec INV_Item_GRP.Item_Rec_Type;
1944: l_x_curr_item_return_status VARCHAR2(1);

Line 1977: l_x_act_num_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;

1973: -- Activity Association
1974: l_x_assoc_return_status VARCHAR2(1);
1975: l_x_assoc_msg_count NUMBER;
1976: l_x_assoc_msg_data VARCHAR2(20000);
1977: l_x_act_num_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;
1978: l_x_activity_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;
1979:
1980: BEGIN
1981:

Line 1978: l_x_activity_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;

1974: l_x_assoc_return_status VARCHAR2(1);
1975: l_x_assoc_msg_count NUMBER;
1976: l_x_assoc_msg_data VARCHAR2(20000);
1977: l_x_act_num_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;
1978: l_x_activity_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;
1979:
1980: BEGIN
1981:
1982: EAM_ActivityUtilities_PVT.Open_Debug_Session;

Line 2037: EAM_Activity_PUB.Create_Activity(

2033:
2034: -- Set EAM attributes
2035: l_asset_activity.EAM_ITEM_TYPE := 2; -- EAM Asset Activity
2036:
2037: EAM_Activity_PUB.Create_Activity(
2038: p_api_version => l_create_activity_ver,
2039:
2040: x_return_status => l_x_return_status,
2041: x_msg_count => l_x_msg_count,

Line 2199: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Create_Activity_With_Template ==========');

2195: x_return_status := FND_API.G_RET_STS_SUCCESS;
2196: -- API body
2197:
2198: -- ============================================================
2199: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Create_Activity_With_Template ==========');
2200: EAM_ActivityUtilities_PVT.Write_Debug('p_organization_id=' || p_organization_id);
2201: EAM_ActivityUtilities_PVT.Write_Debug('p_organization_code=' || p_organization_code);
2202: EAM_ActivityUtilities_PVT.Write_Debug('p_asset_activity=' || p_asset_activity);
2203: EAM_ActivityUtilities_PVT.Write_Debug('p_segment1=' || p_segment1);

Line 2334: EAM_ActivityUtilities_PVT.Write_Debug('========== Exiting EAM_Activity_PUB.Create_Activity_With_Template ==========');

2330: p_data => x_msg_data
2331: );
2332:
2333:
2334: EAM_ActivityUtilities_PVT.Write_Debug('========== Exiting EAM_Activity_PUB.Create_Activity_With_Template ==========');
2335:
2336: -- ======================================================================
2337:
2338: EXCEPTION

Line 2342: '========== EAM_Activity_PUB.Create_Activity_With_Template: EXPECTED ERROR ==========');

2338: EXCEPTION
2339: WHEN FND_API.G_EXC_ERROR THEN
2340: ROLLBACK TO Create_Act_With_Templ_PUB;
2341: EAM_ActivityUtilities_PVT.Write_Debug(
2342: '========== EAM_Activity_PUB.Create_Activity_With_Template: EXPECTED ERROR ==========');
2343: x_return_status := FND_API.G_RET_STS_ERROR ;
2344: FND_MSG_PUB.Count_And_Get
2345: ( p_count => x_msg_count ,
2346: p_data => x_msg_data

Line 2351: '========== EAM_Activity_PUB.Create_Activity_With_Template: UNEXPECTED ERROR ==========');

2347: );
2348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2349: ROLLBACK TO Create_Act_With_Templ_PUB;
2350: EAM_ActivityUtilities_PVT.Write_Debug(
2351: '========== EAM_Activity_PUB.Create_Activity_With_Template: UNEXPECTED ERROR ==========');
2352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2353: FND_MSG_PUB.Count_And_Get
2354: ( p_count => x_msg_count ,
2355: p_data => x_msg_data

Line 2360: '========== EAM_Activity_PUB.Create_Activity_With_Template: OTHER ERROR ==========');

2356: );
2357: WHEN OTHERS THEN
2358: ROLLBACK TO Create_Act_With_Templ_PUB;
2359: EAM_ActivityUtilities_PVT.Write_Debug(
2360: '========== EAM_Activity_PUB.Create_Activity_With_Template: OTHER ERROR ==========');
2361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2362: IF FND_MSG_PUB.Check_Msg_Level
2363: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2364: THEN

Line 2489: EAM_ACTIVITY_PUB.create_bom_header(

2485: begin
2486: l_target_item_rec.item_number := p_inventory_item_name;
2487: l_target_item_rec.organization_code := p_organization_code;
2488:
2489: EAM_ACTIVITY_PUB.create_bom_header(
2490: p_target_item_rec => l_target_item_rec,
2491: --p_source_org_id IN NUMBER,
2492: --p_source_activity_id IN NUMBER, -- inventory_item_id
2493:

Line 2755: EAM_ACTIVITY_PUB.create_routing_header(

2751: begin
2752: l_target_item_rec.item_number := p_inventory_item_name;
2753: l_target_item_rec.organization_code := p_organization_code;
2754:
2755: EAM_ACTIVITY_PUB.create_routing_header(
2756: p_target_item_rec => l_target_item_rec,
2757:
2758:
2759: x_rtg_header_rec => l_x_rtg_header_rec,

Line 2841: l_x_act_num_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;

2837:
2838: l_x_assoc_return_status VARCHAR2(1);
2839: l_x_assoc_msg_count NUMBER;
2840: l_x_assoc_msg_data VARCHAR2(20000);
2841: l_x_act_num_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;
2842: l_x_activity_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;
2843: begin
2844:
2845: EAM_ActivityUtilities_PVT.Open_Debug_Session;

Line 2842: l_x_activity_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;

2838: l_x_assoc_return_status VARCHAR2(1);
2839: l_x_assoc_msg_count NUMBER;
2840: l_x_assoc_msg_data VARCHAR2(20000);
2841: l_x_act_num_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;
2842: l_x_activity_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;
2843: begin
2844:
2845: EAM_ActivityUtilities_PVT.Open_Debug_Session;
2846:

Line 2896: EAM_ACTIVITY_PUB.Copy_Activity(

2892:
2893: l_asset_activity.organization_id := p_activity_org_id;
2894: l_asset_activity.description := p_activity_description;
2895:
2896: EAM_ACTIVITY_PUB.Copy_Activity(
2897: p_api_version => p_api_version,
2898: p_init_msg_list => p_init_msg_list,
2899: p_commit => p_commit,
2900: p_validation_level => p_validation_level,

Line 2982: SAVEPOINT EAM_Activity_PUB;

2978: l_msg_string VARCHAR2(200);
2979:
2980:
2981: BEGIN
2982: SAVEPOINT EAM_Activity_PUB;
2983: -- Standard call to check for call compatibility.
2984: --EAM_ActivityUtilities_PVT.Open_Debug_Session;
2985: IF NOT fnd_api.compatible_api_call(
2986: l_api_version

Line 3037: EAM_ActivityUtilities_PVT.Write_Debug('-------- Beginning EAM_Activity_PUB.Activity_org_assign --------');

3033: RAISE FND_API.G_EXC_ERROR;
3034: END IF;
3035:
3036: -- ============================================================
3037: EAM_ActivityUtilities_PVT.Write_Debug('-------- Beginning EAM_Activity_PUB.Activity_org_assign --------');
3038:
3039:
3040: IF l_item_rec.inventory_item_flag IS NULL OR
3041: l_item_rec.inventory_item_flag = fnd_api.g_MISS_CHAR THEN

Line 3165: EAM_ActivityUtilities_PVT.Write_Debug('-------- Finished EAM_Activity_PUB.Activity_org_assign --------');

3161: --fnd_msg_pub.count_and_get(p_count => x_msg_count
3162: -- ,p_data => x_msg_data);
3163: -- commented for BUG# 5484686
3164:
3165: EAM_ActivityUtilities_PVT.Write_Debug('-------- Finished EAM_Activity_PUB.Activity_org_assign --------');
3166:
3167: EXCEPTION
3168: WHEN fnd_api.g_exc_error THEN
3169: ROLLBACK TO EAM_Activity_PUB;

Line 3169: ROLLBACK TO EAM_Activity_PUB;

3165: EAM_ActivityUtilities_PVT.Write_Debug('-------- Finished EAM_Activity_PUB.Activity_org_assign --------');
3166:
3167: EXCEPTION
3168: WHEN fnd_api.g_exc_error THEN
3169: ROLLBACK TO EAM_Activity_PUB;
3170: x_return_status := fnd_api.g_ret_sts_error;
3171:
3172: -- fnd_msg_pub.count_and_get(p_count => x_msg_count
3173: -- ,p_data => x_msg_data);

Line 3176: ROLLBACK TO EAM_Activity_PUB;

3172: -- fnd_msg_pub.count_and_get(p_count => x_msg_count
3173: -- ,p_data => x_msg_data);
3174: -- commented for BUG# 5484686
3175: WHEN fnd_api.g_exc_unexpected_error THEN
3176: ROLLBACK TO EAM_Activity_PUB;
3177: x_return_status := fnd_api.g_ret_sts_unexp_error;
3178:
3179: --fnd_msg_pub.count_and_get(p_count => x_msg_count
3180: -- ,p_data => x_msg_data);

Line 3183: ROLLBACK TO EAM_Activity_PUB;

3179: --fnd_msg_pub.count_and_get(p_count => x_msg_count
3180: -- ,p_data => x_msg_data);
3181: -- commented for BUG# 5484686
3182: WHEN OTHERS THEN
3183: ROLLBACK TO EAM_Activity_PUB;
3184: x_return_status := fnd_api.g_ret_sts_unexp_error;
3185: /* IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3186: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3187: END IF;*/

Line 3196: END EAM_Activity_PUB;

3192: x_msg_data:=l_msg_string||l_error_string;
3193:
3194: END Activity_org_assign;
3195:
3196: END EAM_Activity_PUB;