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.2 2006/09/12 14:12:28 amourya noship $ */
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 206: EAM_ActivityUtilities_PVT.Write_Debug('---------- Entering EAM_Activity_PUB.Create_Activity_Routing ----------');

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

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

455: x_rtg_msg_list := l_x_rtg_msg_list;
456:
457: END IF;
458:
459: EAM_ActivityUtilities_PVT.Write_Debug('---------- Exiting EAM_Activity_PUB.Create_Activity_Routing ----------');
460: END;
461:
462: -- ----------------------------------------------------------------------
463: PROCEDURE Create_Activity_BOM(

Line 465: p_work_order_rec IN EAM_Activity_PUB.Work_Order_Rec_Type,

461:
462: -- ----------------------------------------------------------------------
463: PROCEDURE Create_Activity_BOM(
464: p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,
465: p_work_order_rec IN EAM_Activity_PUB.Work_Order_Rec_Type,
466: p_material_copy_option IN NUMBER,
467:
468: x_bom_header_rec OUT NOCOPY BOM_BO_PUB.BOM_Head_Rec_Type,
469: x_bom_revision_tbl OUT NOCOPY BOM_BO_PUB.BOM_Revision_Tbl_Type,

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

718: RAISE FND_API.G_EXC_ERROR;
719: END IF;
720:
721: -- ============================================================
722: EAM_ActivityUtilities_PVT.Write_Debug('-------- Beginning EAM_Activity_PUB.Create_Item --------');
723:
724: -- Save current org id
725: l_curr_organization_id := l_item_rec.organization_id;
726: EAM_ActivityUtilities_PVT.Write_Debug('l_curr_organization_id=' || l_curr_organization_id);

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

846: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
847: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_curr_item_rec);
848:
849: -- ============================================================
850: EAM_ActivityUtilities_PVT.Write_Debug('-------- Finished EAM_Activity_PUB.Create_Item --------');
851: END;
852:
853: -- ======================================================================
854: PROCEDURE Create_Activity

Line 872: p_work_order_rec IN EAM_Activity_PUB.Work_Order_Rec_Type,

868: p_activity_cause_code IN VARCHAR2 := NULL,
869: p_shutdown_type_code IN VARCHAR2 := NULL,
870: p_notification_req_flag IN VARCHAR2 := NULL,
871: p_activity_source_code IN VARCHAR2 := NULL,
872: p_work_order_rec IN EAM_Activity_PUB.Work_Order_Rec_Type,
873: p_operation_copy_option IN NUMBER := 2, -- 1 (NONE) or 2 (ALL)
874: p_material_copy_option IN NUMBER := 2, -- 1 (NONE), 2 (ISSUED), OR 3 (ALL)
875: p_resource_copy_option IN NUMBER := 2, -- 1 (NONE), 2 (ISSUED), OR 3 (ALL)
876: p_association_copy_option IN NUMBER := 2, -- 1 (NONE), 2 (CURRENT), OR 3 (ALL)

Line 879: x_work_order_rec OUT NOCOPY EAM_Activity_PUB.Work_Order_Rec_Type,

875: p_resource_copy_option IN NUMBER := 2, -- 1 (NONE), 2 (ISSUED), OR 3 (ALL)
876: p_association_copy_option IN NUMBER := 2, -- 1 (NONE), 2 (CURRENT), OR 3 (ALL)
877:
878: -- x_inventory_item_id OUT NUMBER, -- the inventory_item_it the system has created
879: x_work_order_rec OUT NOCOPY EAM_Activity_PUB.Work_Order_Rec_Type,
880:
881: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
882: x_curr_item_return_status OUT NOCOPY VARCHAR2,
883: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,

Line 910: x_act_num_association_tbl OUT NOCOPY EAM_Activity_PUB.Activity_Association_Tbl_Type,

906:
907: x_assoc_return_status OUT NOCOPY VARCHAR2,
908: x_assoc_msg_count OUT NOCOPY NUMBER,
909: x_assoc_msg_data OUT NOCOPY VARCHAR2,
910: x_act_num_association_tbl OUT NOCOPY EAM_Activity_PUB.Activity_Association_Tbl_Type,
911: x_activity_association_tbl OUT NOCOPY EAM_Activity_PUB.Activity_Association_Tbl_Type
912: )
913:
914: IS

Line 911: x_activity_association_tbl OUT NOCOPY EAM_Activity_PUB.Activity_Association_Tbl_Type

907: x_assoc_return_status OUT NOCOPY VARCHAR2,
908: x_assoc_msg_count OUT NOCOPY NUMBER,
909: x_assoc_msg_data OUT NOCOPY VARCHAR2,
910: x_act_num_association_tbl OUT NOCOPY EAM_Activity_PUB.Activity_Association_Tbl_Type,
911: x_activity_association_tbl OUT NOCOPY EAM_Activity_PUB.Activity_Association_Tbl_Type
912: )
913:
914: IS
915: l_api_name CONSTANT VARCHAR2(30) := 'Create_Activity';

Line 919: l_x_work_order_rec EAM_Activity_PUB.Work_Order_Rec_Type;

915: l_api_name CONSTANT VARCHAR2(30) := 'Create_Activity';
916: l_api_version CONSTANT NUMBER := 1.0;
917:
918: -- local variables for validating source Work Order
919: l_x_work_order_rec EAM_Activity_PUB.Work_Order_Rec_Type;
920: l_x_work_order_ret_sts VARCHAR2(1);
921:
922: -- local variables for calling INV_Item_GRP package
923: l_asset_activity INV_Item_GRP.Item_rec_type;

Line 956: l_x_act_num_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;

952: -- local variables for call Association Creation package
953: l_x_assoc_return_status VARCHAR2(1);
954: l_x_assoc_msg_count NUMBER;
955: l_x_assoc_msg_data VARCHAR2(20000);
956: l_x_act_num_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;
957: l_x_activity_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;
958:
959:
960: -- ======================================================================

Line 957: l_x_activity_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;

953: l_x_assoc_return_status VARCHAR2(1);
954: l_x_assoc_msg_count NUMBER;
955: l_x_assoc_msg_data VARCHAR2(20000);
956: l_x_act_num_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;
957: l_x_activity_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;
958:
959:
960: -- ======================================================================
961: BEGIN

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

977: x_return_status := FND_API.G_RET_STS_SUCCESS;
978: -- API body
979:
980: -- ============================================================
981: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Create_Activity ==========');
982: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Id=' || p_asset_activity.Organization_Id);
983: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Code=' || p_asset_activity.Organization_Code);
984: EAM_ActivityUtilities_PVT.Write_Debug('Inventory_Item_Id=' || p_asset_activity.Inventory_Item_Id);
985: EAM_ActivityUtilities_PVT.Write_Debug('Item Number=' || p_asset_activity.Item_Number);

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

1248: p_data => x_msg_data
1249: );
1250:
1251:
1252: EAM_ActivityUtilities_PVT.Write_Debug('========== Exiting EAM_Activity_PUB.Create_Activity ==========');
1253:
1254: -- ======================================================================
1255:
1256: EXCEPTION

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

1255:
1256: EXCEPTION
1257: WHEN FND_API.G_EXC_ERROR THEN
1258: ROLLBACK TO Create_Activity_PUB;
1259: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Create_Activity: EXPECTED_ERROR ==========');
1260: x_return_status := FND_API.G_RET_STS_ERROR ;
1261: FND_MSG_PUB.Count_And_Get
1262: ( p_count => x_msg_count ,
1263: p_data => x_msg_data

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

1263: p_data => x_msg_data
1264: );
1265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1266: ROLLBACK TO Create_Activity_PUB;
1267: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Create_Activity: UNEXPECTED_ERROR ==========');
1268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1269: FND_MSG_PUB.Count_And_Get
1270: ( p_count => x_msg_count ,
1271: p_data => x_msg_data

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

1282: );
1283: -- log error message also
1284: EAM_ActivityUtilities_PVT.Write_Debug(FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST, FND_API.G_FALSE));
1285: END IF;
1286: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Create_Activity: OTHER ERROR ==========');
1287: FND_MSG_PUB.Count_And_Get
1288: ( p_count => x_msg_count ,
1289: p_data => x_msg_data
1290: );

Line 1341: x_act_num_association_tbl OUT NOCOPY EAM_Activity_PUB.Activity_Association_Tbl_Type,

1337:
1338: x_assoc_return_status OUT NOCOPY VARCHAR2,
1339: x_assoc_msg_count OUT NOCOPY NUMBER,
1340: x_assoc_msg_data OUT NOCOPY VARCHAR2,
1341: x_act_num_association_tbl OUT NOCOPY EAM_Activity_PUB.Activity_Association_Tbl_Type,
1342: x_activity_association_tbl OUT NOCOPY EAM_Activity_PUB.Activity_Association_Tbl_Type
1343: )
1344: IS
1345: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Activity';

Line 1342: x_activity_association_tbl OUT NOCOPY EAM_Activity_PUB.Activity_Association_Tbl_Type

1338: x_assoc_return_status OUT NOCOPY VARCHAR2,
1339: x_assoc_msg_count OUT NOCOPY NUMBER,
1340: x_assoc_msg_data OUT NOCOPY VARCHAR2,
1341: x_act_num_association_tbl OUT NOCOPY EAM_Activity_PUB.Activity_Association_Tbl_Type,
1342: x_activity_association_tbl OUT NOCOPY EAM_Activity_PUB.Activity_Association_Tbl_Type
1343: )
1344: IS
1345: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Activity';
1346: l_api_version CONSTANT NUMBER := 1.0;

Line 1352: l_x_work_order_rec EAM_Activity_PUB.Work_Order_Rec_Type;

1348: -- local variables
1349: l_create_txn_type CONSTANT VARCHAR(10) := 'CREATE';
1350:
1351: -- local variables for validating source Work Order
1352: l_x_work_order_rec EAM_Activity_PUB.Work_Order_Rec_Type;
1353: l_x_work_order_ret_sts VARCHAR2(1);
1354:
1355: -- local variables for calling INV_Item_GRP package
1356: l_asset_activity INV_Item_GRP.Item_rec_type;

Line 1400: l_x_act_num_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;

1396: -- local variables for call Association Creation package
1397: l_x_assoc_return_status VARCHAR2(1);
1398: l_x_assoc_msg_count NUMBER;
1399: l_x_assoc_msg_data VARCHAR2(20000);
1400: l_x_act_num_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;
1401: l_x_activity_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;
1402:
1403: BEGIN
1404: -- Standard Start of API savepoint

Line 1401: l_x_activity_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;

1397: l_x_assoc_return_status VARCHAR2(1);
1398: l_x_assoc_msg_count NUMBER;
1399: l_x_assoc_msg_data VARCHAR2(20000);
1400: l_x_act_num_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;
1401: l_x_activity_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;
1402:
1403: BEGIN
1404: -- Standard Start of API savepoint
1405: SAVEPOINT Copy_Activity_PUB;

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

1419: x_return_status := FND_API.G_RET_STS_SUCCESS;
1420: -- API body
1421:
1422: -- ============================================================
1423: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Copy_Activity ==========');
1424: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Id=' || p_asset_activity.Organization_Id);
1425: EAM_ActivityUtilities_PVT.Write_Debug('Organization_Code=' || p_asset_activity.Organization_Code);
1426: EAM_ActivityUtilities_PVT.Write_Debug('Inventory_Item_Id=' || p_asset_activity.Inventory_Item_Id);
1427: EAM_ActivityUtilities_PVT.Write_Debug('Item Number=' || p_asset_activity.Item_Number);

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

1813: ( p_count => x_msg_count ,
1814: p_data => x_msg_data
1815: );
1816:
1817: EAM_ActivityUtilities_PVT.Write_Debug('========== Exiting EAM_Activity_PUB.Copy_Activity ==========');
1818:
1819:
1820: -- ======================================================================
1821: EXCEPTION

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

1820: -- ======================================================================
1821: EXCEPTION
1822: WHEN FND_API.G_EXC_ERROR THEN
1823: ROLLBACK TO Copy_Activity_PUB;
1824: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Copy_Activity: EXPECTED_ERROR ==========');
1825: x_return_status := FND_API.G_RET_STS_ERROR ;
1826: FND_MSG_PUB.Count_And_Get
1827: ( p_count => x_msg_count ,
1828: p_data => x_msg_data

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

1828: p_data => x_msg_data
1829: );
1830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1831: ROLLBACK TO Copy_Activity_PUB;
1832: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Copy_Activity: UNEXPECTED_ERROR ==========');
1833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1834: FND_MSG_PUB.Count_And_Get
1835: ( p_count => x_msg_count ,
1836: p_data => x_msg_data

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

1848: );
1849: -- log error message also
1850: EAM_ActivityUtilities_PVT.Write_Debug(FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST, FND_API.G_FALSE));
1851: END IF;
1852: EAM_ActivityUtilities_PVT.Write_Debug('========== EAM_Activity_PUB.Copy_Activity: OTHER ERROR ==========');
1853: FND_MSG_PUB.Count_And_Get
1854: ( p_count => x_msg_count ,
1855: p_data => x_msg_data
1856: );

Line 1907: l_work_order_rec EAM_Activity_PUB.Work_Order_Rec_Type;

1903: l_x_msg_count NUMBER;
1904: l_x_msg_data VARCHAR2(20000);
1905:
1906: l_asset_activity INV_Item_GRP.Item_Rec_Type;
1907: l_work_order_rec EAM_Activity_PUB.Work_Order_Rec_Type;
1908: l_x_inventory_item_id NUMBER;
1909: l_x_work_order_rec EAM_Activity_PUB.Work_Order_Rec_Type;
1910:
1911: -- output variables of inv package

Line 1909: l_x_work_order_rec EAM_Activity_PUB.Work_Order_Rec_Type;

1905:
1906: l_asset_activity INV_Item_GRP.Item_Rec_Type;
1907: l_work_order_rec EAM_Activity_PUB.Work_Order_Rec_Type;
1908: l_x_inventory_item_id NUMBER;
1909: l_x_work_order_rec EAM_Activity_PUB.Work_Order_Rec_Type;
1910:
1911: -- output variables of inv package
1912: l_x_curr_item_rec INV_Item_GRP.Item_Rec_Type;
1913: l_x_curr_item_return_status VARCHAR2(1);

Line 1946: l_x_act_num_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;

1942: -- Activity Association
1943: l_x_assoc_return_status VARCHAR2(1);
1944: l_x_assoc_msg_count NUMBER;
1945: l_x_assoc_msg_data VARCHAR2(20000);
1946: l_x_act_num_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;
1947: l_x_activity_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;
1948:
1949: BEGIN
1950:

Line 1947: l_x_activity_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;

1943: l_x_assoc_return_status VARCHAR2(1);
1944: l_x_assoc_msg_count NUMBER;
1945: l_x_assoc_msg_data VARCHAR2(20000);
1946: l_x_act_num_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;
1947: l_x_activity_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;
1948:
1949: BEGIN
1950:
1951: EAM_ActivityUtilities_PVT.Open_Debug_Session;

Line 2006: EAM_Activity_PUB.Create_Activity(

2002:
2003: -- Set EAM attributes
2004: l_asset_activity.EAM_ITEM_TYPE := 2; -- EAM Asset Activity
2005:
2006: EAM_Activity_PUB.Create_Activity(
2007: p_api_version => l_create_activity_ver,
2008:
2009: x_return_status => l_x_return_status,
2010: x_msg_count => l_x_msg_count,

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

2164: x_return_status := FND_API.G_RET_STS_SUCCESS;
2165: -- API body
2166:
2167: -- ============================================================
2168: EAM_ActivityUtilities_PVT.Write_Debug('========== Entering EAM_Activity_PUB.Create_Activity_With_Template ==========');
2169: EAM_ActivityUtilities_PVT.Write_Debug('p_organization_id=' || p_organization_id);
2170: EAM_ActivityUtilities_PVT.Write_Debug('p_organization_code=' || p_organization_code);
2171: EAM_ActivityUtilities_PVT.Write_Debug('p_asset_activity=' || p_asset_activity);
2172: EAM_ActivityUtilities_PVT.Write_Debug('p_segment1=' || p_segment1);

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

2299: p_data => x_msg_data
2300: );
2301:
2302:
2303: EAM_ActivityUtilities_PVT.Write_Debug('========== Exiting EAM_Activity_PUB.Create_Activity_With_Template ==========');
2304:
2305: -- ======================================================================
2306:
2307: EXCEPTION

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

2307: EXCEPTION
2308: WHEN FND_API.G_EXC_ERROR THEN
2309: ROLLBACK TO Create_Act_With_Templ_PUB;
2310: EAM_ActivityUtilities_PVT.Write_Debug(
2311: '========== EAM_Activity_PUB.Create_Activity_With_Template: EXPECTED ERROR ==========');
2312: x_return_status := FND_API.G_RET_STS_ERROR ;
2313: FND_MSG_PUB.Count_And_Get
2314: ( p_count => x_msg_count ,
2315: p_data => x_msg_data

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

2316: );
2317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2318: ROLLBACK TO Create_Act_With_Templ_PUB;
2319: EAM_ActivityUtilities_PVT.Write_Debug(
2320: '========== EAM_Activity_PUB.Create_Activity_With_Template: UNEXPECTED ERROR ==========');
2321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2322: FND_MSG_PUB.Count_And_Get
2323: ( p_count => x_msg_count ,
2324: p_data => x_msg_data

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

2325: );
2326: WHEN OTHERS THEN
2327: ROLLBACK TO Create_Act_With_Templ_PUB;
2328: EAM_ActivityUtilities_PVT.Write_Debug(
2329: '========== EAM_Activity_PUB.Create_Activity_With_Template: OTHER ERROR ==========');
2330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2331: IF FND_MSG_PUB.Check_Msg_Level
2332: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2333: THEN

Line 2458: EAM_ACTIVITY_PUB.create_bom_header(

2454: begin
2455: l_target_item_rec.item_number := p_inventory_item_name;
2456: l_target_item_rec.organization_code := p_organization_code;
2457:
2458: EAM_ACTIVITY_PUB.create_bom_header(
2459: p_target_item_rec => l_target_item_rec,
2460: --p_source_org_id IN NUMBER,
2461: --p_source_activity_id IN NUMBER, -- inventory_item_id
2462:

Line 2724: EAM_ACTIVITY_PUB.create_routing_header(

2720: begin
2721: l_target_item_rec.item_number := p_inventory_item_name;
2722: l_target_item_rec.organization_code := p_organization_code;
2723:
2724: EAM_ACTIVITY_PUB.create_routing_header(
2725: p_target_item_rec => l_target_item_rec,
2726:
2727:
2728: x_rtg_header_rec => l_x_rtg_header_rec,

Line 2810: l_x_act_num_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;

2806:
2807: l_x_assoc_return_status VARCHAR2(1);
2808: l_x_assoc_msg_count NUMBER;
2809: l_x_assoc_msg_data VARCHAR2(20000);
2810: l_x_act_num_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;
2811: l_x_activity_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;
2812: begin
2813:
2814: EAM_ActivityUtilities_PVT.Open_Debug_Session;

Line 2811: l_x_activity_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;

2807: l_x_assoc_return_status VARCHAR2(1);
2808: l_x_assoc_msg_count NUMBER;
2809: l_x_assoc_msg_data VARCHAR2(20000);
2810: l_x_act_num_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;
2811: l_x_activity_association_tbl EAM_Activity_PUB.Activity_Association_Tbl_Type;
2812: begin
2813:
2814: EAM_ActivityUtilities_PVT.Open_Debug_Session;
2815:

Line 2865: EAM_ACTIVITY_PUB.Copy_Activity(

2861:
2862: l_asset_activity.organization_id := p_activity_org_id;
2863: l_asset_activity.description := p_activity_description;
2864:
2865: EAM_ACTIVITY_PUB.Copy_Activity(
2866: p_api_version => p_api_version,
2867: p_init_msg_list => p_init_msg_list,
2868: p_commit => p_commit,
2869: p_validation_level => p_validation_level,

Line 2951: SAVEPOINT EAM_Activity_PUB;

2947: l_msg_string VARCHAR2(200);
2948:
2949:
2950: BEGIN
2951: SAVEPOINT EAM_Activity_PUB;
2952: -- Standard call to check for call compatibility.
2953: --EAM_ActivityUtilities_PVT.Open_Debug_Session;
2954: IF NOT fnd_api.compatible_api_call(
2955: l_api_version

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

3002: RAISE FND_API.G_EXC_ERROR;
3003: END IF;
3004:
3005: -- ============================================================
3006: EAM_ActivityUtilities_PVT.Write_Debug('-------- Beginning EAM_Activity_PUB.Activity_org_assign --------');
3007:
3008:
3009: IF l_item_rec.inventory_item_flag IS NULL OR
3010: l_item_rec.inventory_item_flag = fnd_api.g_MISS_CHAR THEN

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

3130: --fnd_msg_pub.count_and_get(p_count => x_msg_count
3131: -- ,p_data => x_msg_data);
3132: -- commented for BUG# 5484686
3133:
3134: EAM_ActivityUtilities_PVT.Write_Debug('-------- Finished EAM_Activity_PUB.Activity_org_assign --------');
3135:
3136: EXCEPTION
3137: WHEN fnd_api.g_exc_error THEN
3138: ROLLBACK TO EAM_Activity_PUB;

Line 3138: ROLLBACK TO EAM_Activity_PUB;

3134: EAM_ActivityUtilities_PVT.Write_Debug('-------- Finished EAM_Activity_PUB.Activity_org_assign --------');
3135:
3136: EXCEPTION
3137: WHEN fnd_api.g_exc_error THEN
3138: ROLLBACK TO EAM_Activity_PUB;
3139: x_return_status := fnd_api.g_ret_sts_error;
3140:
3141: -- fnd_msg_pub.count_and_get(p_count => x_msg_count
3142: -- ,p_data => x_msg_data);

Line 3145: ROLLBACK TO EAM_Activity_PUB;

3141: -- fnd_msg_pub.count_and_get(p_count => x_msg_count
3142: -- ,p_data => x_msg_data);
3143: -- commented for BUG# 5484686
3144: WHEN fnd_api.g_exc_unexpected_error THEN
3145: ROLLBACK TO EAM_Activity_PUB;
3146: x_return_status := fnd_api.g_ret_sts_unexp_error;
3147:
3148: --fnd_msg_pub.count_and_get(p_count => x_msg_count
3149: -- ,p_data => x_msg_data);

Line 3152: ROLLBACK TO EAM_Activity_PUB;

3148: --fnd_msg_pub.count_and_get(p_count => x_msg_count
3149: -- ,p_data => x_msg_data);
3150: -- commented for BUG# 5484686
3151: WHEN OTHERS THEN
3152: ROLLBACK TO EAM_Activity_PUB;
3153: x_return_status := fnd_api.g_ret_sts_unexp_error;
3154: /* IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3155: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3156: END IF;*/

Line 3165: END EAM_Activity_PUB;

3161: x_msg_data:=l_msg_string||l_error_string;
3162:
3163: END Activity_org_assign;
3164:
3165: END EAM_Activity_PUB;