1: PACKAGE BODY EAM_ActivityAssociation_PVT AS
2: /* $Header: EAMVAAAB.pls 120.6.12020000.2 2013/03/29 02:44:54 shengywa ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='EAM_ActivityAssociation_PVT';
5: G_ACT_SOURCE VARCHAR2(30) := EAM_CONSTANTS.G_ACT_SOURCE;
1: PACKAGE BODY EAM_ActivityAssociation_PVT AS
2: /* $Header: EAMVAAAB.pls 120.6.12020000.2 2013/03/29 02:44:54 shengywa ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='EAM_ActivityAssociation_PVT';
5: G_ACT_SOURCE VARCHAR2(30) := EAM_CONSTANTS.G_ACT_SOURCE;
6: G_ACT_CAUSE VARCHAR2(30) := EAM_CONSTANTS.G_ACT_CAUSE;
7: G_ACT_TYPE VARCHAR2(30) := EAM_CONSTANTS.G_ACT_TYPE;
8: G_SHUTDOWN_TYPE VARCHAR2(30) := EAM_CONSTANTS.G_SHUTDOWN_TYPE;
153: -- API body
154:
155: -- ============================================================
156: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
157: '========== Entering EAM_ActivityAssociation_PVT.Create_Association =========='
158: || 'p_target_org_id=' || p_target_org_id
159: || 'p_target_activity_id=' || p_target_activity_id
160: || 'p_wip_entity_id=' || p_wip_entity_id
161: || 'p_source_org_id=' || p_source_org_id
531:
532: EXCEPTION
533: WHEN NO_DATA_FOUND THEN
534: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
535: 'EAM_ActivityAssociation_PVT.Create_Association: unexpected error.'
536: || 'p_wip_entity_id=' || p_wip_entity_id);
537: end if;
538:
539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
541:
542: END IF;
543:
544: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
545: '========== Exiting EAM_ActivityAssociation_PVT.Create_Association ==========');
546: end if;
547:
548: -- ============================================================
549:
659:
660: -- API body
661: -- ============================================================
662: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
663: '========== Entering EAM_ActivityAssociation_PVT.Create_AssetNumberAssoc =========='
664: || 'p_activity_association_tbl.COUNT=' || p_activity_association_tbl.COUNT);
665: end if;
666:
667: -- Copy input table to local working variable
1472: END IF;
1473:
1474: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1475: 'l_x_return_status=' || l_x_return_status ||
1476: '========== Exiting EAM_ActivityAssociation_PVT.Create_AssetNumberAssoc ==========');
1477: end if;
1478:
1479: x_return_status := l_x_return_status;
1480:
1607: end if;
1608: l_date_insert := l_current_date;
1609:
1610: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1611: '==================== Entered EAM_ActivityAssociation_PVT.Inst_Activity_Template ===================='
1612: || 'p_maintenance_object_id=' || p_maintenance_object_id
1613: || 'p_maintenance_object_type=' || p_maintenance_object_type);
1614: end if;
1615:
1856:
1857: x_msg_data := substr(x_msg_data,1,4000);
1858:
1859: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1860: '==================== Exiting EAM_ActivityAssociation_PVT.Inst_Activity_Template ====================');
1861: end if;
1862:
1863:
1864:
1898: x_msg_data := substr(x_msg_data,1,4000);
1899: END Inst_Activity_Template;
1900:
1901:
1902: END EAM_ActivityAssociation_PVT;