APPS.MRP_CL_FUNCTION dependencies on MRP_CL_REFRESH_SNAPSHOT

Line 1542: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG(SQLERRM);

1538: BEGIN
1539: DELETE FROM MRP_REGION_SITES
1540: where vendor_site_id =l_vendor_site_tab1(j);
1541: EXCEPTION WHEN OTHERS THEN
1542: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG(SQLERRM);
1543: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('There was an error in DELETEING Region to Sites');
1544: NULL;
1545: END;
1546: END LOOP;

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

1539: DELETE FROM MRP_REGION_SITES
1540: where vendor_site_id =l_vendor_site_tab1(j);
1541: EXCEPTION WHEN OTHERS THEN
1542: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG(SQLERRM);
1543: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('There was an error in DELETEING Region to Sites');
1544: NULL;
1545: END;
1546: END LOOP;
1547: --

Line 1579: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG(SQLERRM);

1575: x_status => l_status,
1576: x_regions => l_regions);
1577:
1578: EXCEPTION WHEN OTHERS THEN
1579: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG(SQLERRM);
1580: 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) );
1581:
1582: NULL;
1583: END;

Line 1580: 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) );

1576: x_regions => l_regions);
1577:
1578: EXCEPTION WHEN OTHERS THEN
1579: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG(SQLERRM);
1580: 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) );
1581:
1582: NULL;
1583: END;
1584:

Line 1610: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG(SQLERRM);

1606: Return(1);
1607:
1608:
1609: EXCEPTION WHEN OTHERS THEN
1610: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG(SQLERRM);
1611: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('There was an error in Mapping Region to Sites');
1612: Return(0);
1613: END MAP_REGION_TO_SITE ;
1614:

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

1607:
1608:
1609: EXCEPTION WHEN OTHERS THEN
1610: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG(SQLERRM);
1611: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('There was an error in Mapping Region to Sites');
1612: Return(0);
1613: END MAP_REGION_TO_SITE ;
1614:
1615: FUNCTION get_ship_set_name(p_SHIP_SET_ID in number)

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

1855: WHERE USER_NAME = p_user_name;
1856:
1857: EXCEPTION
1858: WHEN NO_DATA_FOUND THEN
1859: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('Error in launching the concurrent request : NO_USER_DEFINED');
1860: raise_application_error (-20001, 'NO_USER_DEFINED');
1861: END;
1862:
1863: IF MRP_CL_FUNCTION.validateUser(l_user_id,MSC_UTIL.TASK_RELEASE,lv_log_msg) THEN

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

1893: FALSE);
1894: END IF ;
1895:
1896: IF nvl( l_request,0) = 0 THEN
1897: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('Error in launching the concurrent request ');
1898: ELSE
1899: p_request_id := l_request;
1900: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('Concurrent Request ID ' || p_request_id || ' has been submitted ');
1901: END IF;

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

1896: IF nvl( l_request,0) = 0 THEN
1897: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('Error in launching the concurrent request ');
1898: ELSE
1899: p_request_id := l_request;
1900: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('Concurrent Request ID ' || p_request_id || ' has been submitted ');
1901: END IF;
1902: EXCEPTION
1903: WHEN OTHERS THEN
1904: RAISE;