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.MRP_CL_FUNCTION dependencies on MRP_CL_REFRESH_SNAPSHOT

Line 1547: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG(SQLERRM);

1543: BEGIN
1544: DELETE FROM MRP_REGION_SITES
1545: where vendor_site_id =l_vendor_site_tab1(j);
1546: EXCEPTION WHEN OTHERS THEN
1547: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG(SQLERRM);
1548: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('There was an error in DELETEING Region to Sites');
1549: NULL;
1550: END;
1551: END LOOP;

Line 1548: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('There was an error in DELETEING Region to Sites');

1544: DELETE FROM MRP_REGION_SITES
1545: where vendor_site_id =l_vendor_site_tab1(j);
1546: EXCEPTION WHEN OTHERS THEN
1547: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG(SQLERRM);
1548: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('There was an error in DELETEING Region to Sites');
1549: NULL;
1550: END;
1551: END LOOP;
1552: --

Line 1567: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('Vendor id passed to shippin API: '||l_vendor_site_tab(i) );

1563: END IF;
1564:
1565: FOR i IN 1..l_vendor_site_tab.COUNT LOOP
1566: BEGIN
1567: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('Vendor id passed to shippin API: '||l_vendor_site_tab(i) );
1568: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('State code passed to shippin API: '||l_state_tab(i) );
1569: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('Language code passed to shippin API: '||l_lang_tab(i) );
1570: WSH_REGIONS_SEARCH_PKG.Get_All_Region_Matches(
1571: p_country => null, -- p_country

Line 1568: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('State code passed to shippin API: '||l_state_tab(i) );

1564:
1565: FOR i IN 1..l_vendor_site_tab.COUNT LOOP
1566: BEGIN
1567: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('Vendor id passed to shippin API: '||l_vendor_site_tab(i) );
1568: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('State code passed to shippin API: '||l_state_tab(i) );
1569: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('Language code passed to shippin API: '||l_lang_tab(i) );
1570: WSH_REGIONS_SEARCH_PKG.Get_All_Region_Matches(
1571: p_country => null, -- p_country
1572: p_country_region => null, -- p_country_region

Line 1569: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('Language code passed to shippin API: '||l_lang_tab(i) );

1565: FOR i IN 1..l_vendor_site_tab.COUNT LOOP
1566: BEGIN
1567: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('Vendor id passed to shippin API: '||l_vendor_site_tab(i) );
1568: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('State code passed to shippin API: '||l_state_tab(i) );
1569: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('Language code passed to shippin API: '||l_lang_tab(i) );
1570: WSH_REGIONS_SEARCH_PKG.Get_All_Region_Matches(
1571: p_country => null, -- p_country
1572: p_country_region => null, -- p_country_region
1573: p_state => l_state_tab(i), -- p_state

Line 1588: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG(SQLERRM);

1584: x_status => l_status,
1585: x_regions => l_regions);
1586:
1587: EXCEPTION WHEN OTHERS THEN
1588: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG(SQLERRM);
1589: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('There was an error in Get All Region Matches for City '||l_city_tab(i)||' State ' ||l_state_tab(i)||' Country '||l_country_tab(i) );
1590:
1591: NULL;
1592: END;

Line 1589: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('There was an error in Get All Region Matches for City '||l_city_tab(i)||' State ' ||l_state_tab(i)||' Country '||l_country_tab(i) );

1585: x_regions => l_regions);
1586:
1587: EXCEPTION WHEN OTHERS THEN
1588: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG(SQLERRM);
1589: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('There was an error in Get All Region Matches for City '||l_city_tab(i)||' State ' ||l_state_tab(i)||' Country '||l_country_tab(i) );
1590:
1591: NULL;
1592: END;
1593:

Line 1611: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('Val inserted into MRP_REGION_SITES for vendor_site_id: '|| l_vendor_site_tab(i) );

1607: END LOOP;
1608: FORALL k IN 1..l_regions.count
1609: INSERT INTO MRP_REGION_SITES(region_id,vendor_site_id, region_type, zone_level, last_update_date, last_updated_by, creation_date, created_by)
1610: VALUES (l_region_id_tab(k), l_vendor_site_tab(i),l_region_type_tab(k),l_zone_level_tab(k), v_current_date, v_current_user, v_current_date, v_current_user);
1611: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('Val inserted into MRP_REGION_SITES for vendor_site_id: '|| l_vendor_site_tab(i) );
1612:
1613: END IF;
1614:
1615: END LOOP;

Line 1621: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG(SQLERRM);

1617: Return(1);
1618:
1619:
1620: EXCEPTION WHEN OTHERS THEN
1621: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG(SQLERRM);
1622: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('There was an error in Mapping Region to Sites');
1623: Return(0);
1624: END MAP_REGION_TO_SITE ;
1625:

Line 1622: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('There was an error in Mapping Region to Sites');

1618:
1619:
1620: EXCEPTION WHEN OTHERS THEN
1621: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG(SQLERRM);
1622: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('There was an error in Mapping Region to Sites');
1623: Return(0);
1624: END MAP_REGION_TO_SITE ;
1625:
1626: FUNCTION POPULATE_WO_SUB_COMP

Line 1655: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('In POPULATE_WO_SUB_COMP ');

1651:
1652:
1653: BEGIN
1654:
1655: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('In POPULATE_WO_SUB_COMP ');
1656:
1657: SELECT SYSDATE,
1658: FND_GLOBAL.USER_ID
1659: INTO v_current_date,

Line 1674: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('Cursor lv_sql_stmt : '|| lv_sql_stmt );

1670: 'select WIP_ENTITY_ID, ORGANIZATION_ID ' ||
1671: ' from AHL_WORKORDERS_SN ' ||
1672: ' where ITEM_ALTERNATES_EXIST = ''Y''';
1673:
1674: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('Cursor lv_sql_stmt : '|| lv_sql_stmt );
1675:
1676: -- Get all workorders for mapping.
1677:
1678: OPEN ahl_wo_all FOR lv_sql_stmt ;

Line 1689: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('Wip Entity ID Passed : '|| l_wip_entity_id_tab(i) );

1685: FOR i IN 1..l_wip_entity_id_tab.COUNT LOOP
1686: BEGIN
1687: L_ALT_ITEM_TBL.DELETE; -- need to delete the table L_ALT_ITEM_TBL
1688:
1689: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('Wip Entity ID Passed : '|| l_wip_entity_id_tab(i) );
1690: AHL_MATERIALS_GRP.GET_WO_ALTERNATES
1691: (P_API_VERSION => 1.0,
1692: p_init_msg_list => FND_API.G_FALSE,
1693: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 1701: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG(SQLERRM);

1697: P_WIP_ENTITY_ID => l_wip_entity_id_tab(i),
1698: X_ALT_ITEM_TBL => L_ALT_ITEM_TBL);
1699:
1700: EXCEPTION WHEN OTHERS THEN
1701: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG(SQLERRM);
1702: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('There was an error in Get WO for WIP
1703: entity id '||l_wip_entity_id_tab(i));
1704:
1705: NULL;

Line 1702: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('There was an error in Get WO for WIP

1698: X_ALT_ITEM_TBL => L_ALT_ITEM_TBL);
1699:
1700: EXCEPTION WHEN OTHERS THEN
1701: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG(SQLERRM);
1702: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('There was an error in Get WO for WIP
1703: entity id '||l_wip_entity_id_tab(i));
1704:
1705: NULL;
1706: END;

Line 1743: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG(SQLERRM);

1739: Return(1);
1740:
1741:
1742: EXCEPTION WHEN OTHERS THEN
1743: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG(SQLERRM);
1744: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('There was an error in Populating MRP_WO_SUB_COMP');
1745: Return(0);
1746: END POPULATE_WO_SUB_COMP ;
1747:

Line 1744: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('There was an error in Populating MRP_WO_SUB_COMP');

1740:
1741:
1742: EXCEPTION WHEN OTHERS THEN
1743: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG(SQLERRM);
1744: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('There was an error in Populating MRP_WO_SUB_COMP');
1745: Return(0);
1746: END POPULATE_WO_SUB_COMP ;
1747:
1748: FUNCTION get_ship_set_name(p_SHIP_SET_ID in number)

Line 1992: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('Error in launching the concurrent request : NO_USER_DEFINED');

1988: WHERE USER_NAME = p_user_name;
1989:
1990: EXCEPTION
1991: WHEN NO_DATA_FOUND THEN
1992: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('Error in launching the concurrent request : NO_USER_DEFINED');
1993: raise_application_error (-20001, 'NO_USER_DEFINED');
1994: END;
1995:
1996: IF MRP_CL_FUNCTION.validateUser(l_user_id,MSC_UTIL.TASK_RELEASE,lv_log_msg) THEN

Line 2030: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('Error in launching the concurrent request ');

2026: FALSE);
2027: END IF ;
2028:
2029: IF nvl( l_request,0) = 0 THEN
2030: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('Error in launching the concurrent request ');
2031: ELSE
2032: p_request_id := l_request;
2033: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('Concurrent Request ID ' || p_request_id || ' has been submitted ');
2034: END IF;

Line 2033: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('Concurrent Request ID ' || p_request_id || ' has been submitted ');

2029: IF nvl( l_request,0) = 0 THEN
2030: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('Error in launching the concurrent request ');
2031: ELSE
2032: p_request_id := l_request;
2033: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('Concurrent Request ID ' || p_request_id || ' has been submitted ');
2034: END IF;
2035: EXCEPTION
2036: WHEN OTHERS THEN
2037: RAISE;