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

Line 1: PACKAGE BODY CSM_UTIL_PKG AS

1: PACKAGE BODY CSM_UTIL_PKG AS
2: /* $Header: csmeutlb.pls 120.22.12020000.3 2013/04/18 07:59:54 avitiwar ship $ */
3: error EXCEPTION;
4: g_invalid_argument_exception exception;
5: g_null_primary_key_exception exception;

Line 9: g_object_name VARCHAR(255):= 'CSM_UTIL_PKG';

5: g_null_primary_key_exception exception;
6: g_element_not_found_exception exception;
7:
8: g_debug_level NUMBER; -- variable containing debug level
9: g_object_name VARCHAR(255):= 'CSM_UTIL_PKG';
10:
11: g_initialize_log BOOLEAN := FALSE;
12:
13: --Table to contain information regarding the master tables to be updated

Line 1320: csm_util_pkg.log('Error in refresh_app_level_acc:' || l_sqlerrno || ':' || l_sqlerrmsg);

1316: EXCEPTION
1317: WHEN others THEN
1318: l_sqlerrno := to_char(SQLCODE);
1319: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1320: csm_util_pkg.log('Error in refresh_app_level_acc:' || l_sqlerrno || ':' || l_sqlerrmsg);
1321: END refresh_app_level_acc;
1322:
1323: /**
1324: Refreshes all the application level ACC tables

Line 1342: AND package_name = 'CSM_UTIL_PKG'

1338: IS
1339: SELECT 1
1340: FROM jtm_con_request_data
1341: WHERE product_code = 'CSM'
1342: AND package_name = 'CSM_UTIL_PKG'
1343: AND procedure_name = 'REFRESH_ALL_APP_LEVEL_ACC'
1344: FOR UPDATE OF last_run_date NOWAIT
1345: ;
1346:

Line 1379: p_message := 'CSM_UTIL_PKG.refresh_all_app_level_acc Executed successfully';

1375:
1376: COMMIT;
1377:
1378: p_status := 'FINE';
1379: p_message := 'CSM_UTIL_PKG.refresh_all_app_level_acc Executed successfully';
1380:
1381: EXCEPTION
1382: WHEN others THEN
1383: l_sqlerrno := to_char(SQLCODE);

Line 1386: p_message := 'Error in CSM_UTIL_PKG.refresh_all_app_level_acc :' || l_sqlerrno || ':' || l_sqlerrmsg;

1382: WHEN others THEN
1383: l_sqlerrno := to_char(SQLCODE);
1384: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1385: p_status := 'ERROR';
1386: p_message := 'Error in CSM_UTIL_PKG.refresh_all_app_level_acc :' || l_sqlerrno || ':' || l_sqlerrmsg;
1387: ROLLBACK;
1388: csm_util_pkg.log('CSM_UTIL_PKG.REFRESH_ALL_APP_LEVEL_ACC ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
1389: END refresh_all_app_level_acc;
1390:

Line 1388: csm_util_pkg.log('CSM_UTIL_PKG.REFRESH_ALL_APP_LEVEL_ACC ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);

1384: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1385: p_status := 'ERROR';
1386: p_message := 'Error in CSM_UTIL_PKG.refresh_all_app_level_acc :' || l_sqlerrno || ':' || l_sqlerrmsg;
1387: ROLLBACK;
1388: csm_util_pkg.log('CSM_UTIL_PKG.REFRESH_ALL_APP_LEVEL_ACC ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
1389: END refresh_all_app_level_acc;
1390:
1391: /***
1392: This function returns a translated error message string. If p_api_error is FALSE, it gets

Line 1414: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1410: l_counter NUMBER;
1411: l_msg_data VARCHAR2(2000);
1412: l_msg_dummy NUMBER;
1413: BEGIN
1414: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1415: log ( 'CSM_UTIL_PKG.Get_error_message_text' );
1416: END IF;
1417:
1418: /*** Is this an API error? ***/

Line 1415: log ( 'CSM_UTIL_PKG.Get_error_message_text' );

1411: l_msg_data VARCHAR2(2000);
1412: l_msg_dummy NUMBER;
1413: BEGIN
1414: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1415: log ( 'CSM_UTIL_PKG.Get_error_message_text' );
1416: END IF;
1417:
1418: /*** Is this an API error? ***/
1419: IF NOT p_api_error THEN

Line 1472: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1468: END LOOP;
1469: END IF;
1470: END IF;
1471:
1472: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1473: log
1474: ( 'Leaving CSM_UTIL_PKG.Get_error_message_text'
1475: );
1476: END IF;

Line 1474: ( 'Leaving CSM_UTIL_PKG.Get_error_message_text'

1470: END IF;
1471:
1472: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1473: log
1474: ( 'Leaving CSM_UTIL_PKG.Get_error_message_text'
1475: );
1476: END IF;
1477: RETURN l_fnd_message;
1478: EXCEPTION WHEN OTHERS THEN

Line 1480: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

1476: END IF;
1477: RETURN l_fnd_message;
1478: EXCEPTION WHEN OTHERS THEN
1479:
1480: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
1481: log
1482: ( 'Exception occurred in CSM_UTIL_PKG.Get_error_message_text:' || ' ' || sqlerrm);
1483: END IF;
1484:

Line 1482: ( 'Exception occurred in CSM_UTIL_PKG.Get_error_message_text:' || ' ' || sqlerrm);

1478: EXCEPTION WHEN OTHERS THEN
1479:
1480: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
1481: log
1482: ( 'Exception occurred in CSM_UTIL_PKG.Get_error_message_text:' || ' ' || sqlerrm);
1483: END IF;
1484:
1485: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1486: log

Line 1485: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1481: log
1482: ( 'Exception occurred in CSM_UTIL_PKG.Get_error_message_text:' || ' ' || sqlerrm);
1483: END IF;
1484:
1485: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1486: log
1487: ( 'Leaving CSM_UTIL_PKG.Get_error_message_text');
1488: END IF;
1489:

Line 1487: ( 'Leaving CSM_UTIL_PKG.Get_error_message_text');

1483: END IF;
1484:
1485: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1486: log
1487: ( 'Leaving CSM_UTIL_PKG.Get_error_message_text');
1488: END IF;
1489:
1490: RETURN l_fnd_message;
1491: END GET_ERROR_MESSAGE_TEXT;

Line 1512: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1508: l_tracking_id NUMBER;
1509: BEGIN
1510: x_return_status := FND_API.G_RET_STS_SUCCESS;
1511:
1512: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1513: log
1514: ( 'Entering DELETE_RECORD');
1515: log
1516: ( 'Check and clear TRACKING deferred record');

Line 1566: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1562: ELSE
1563: DELETE FROM CSM_HTML5_PARSED_DATA WHERE SESSION_ID= p_tranid AND SEQUENCE=p_seqno;
1564: END IF;
1565:
1566: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1567: log
1568: ( 'Leaving DELETE_RECORD');
1569: END IF;
1570:

Line 1572: IF g_debug_level >= CSM_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

1568: ( 'Leaving DELETE_RECORD');
1569: END IF;
1570:
1571: EXCEPTION WHEN OTHERS THEN
1572: IF g_debug_level >= CSM_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
1573: log
1574: ( 'Exception occurred in DELETE_RECORD:' || ' ' || sqlerrm);
1575: END IF;
1576:

Line 1583: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1579: (
1580: p_api_error => TRUE
1581: );
1582:
1583: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1584: log
1585: ( 'Leaving DELETE_RECORD');
1586: END IF;
1587: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1621: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1617:
1618: BEGIN
1619: x_return_status := FND_API.G_RET_STS_SUCCESS;
1620:
1621: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1622: log
1623: ( 'Entering DEFER_RECORD');
1624: END IF;
1625:

Line 1640: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1636: /*** no -> log and return error ***/
1637:
1638: log( 'asg_defer.defer_row failed:' || ' ' || p_error_msg);
1639:
1640: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1641: log
1642: ( 'Leaving DEFER_RECORD');
1643: END IF;
1644: RETURN;

Line 1661: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1657: csm_notification_event_pkg.notify_deferred(p_user_name,p_tranid,
1658: p_pub_name,p_seqno, p_dml_type,p_pk,l_error_msg);
1659:
1660:
1661: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1662: log
1663: ( 'Leaving DEFER_RECORD');
1664: END IF;
1665: EXCEPTION WHEN OTHERS THEN

Line 1670: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1666:
1667: log( 'Exception occurred in DEFER_RECORD:' || ' ' || sqlerrm);
1668:
1669:
1670: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1671: log
1672: ( 'Leaving DEFER_RECORD');
1673: END IF;
1674:

Line 1707: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1703:
1704: BEGIN
1705: x_return_status := FND_API.G_RET_STS_SUCCESS;
1706:
1707: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1708: log( 'Entering REJECT_RECORD');
1709: END IF;
1710:
1711: asg_defer.reject_row(p_user_name,

Line 1742: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1738: END IF;
1739: END IF;
1740: END IF;
1741:
1742: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1743: log( 'Leaving REJECT_RECORD');
1744: END IF;
1745: EXCEPTION WHEN OTHERS THEN
1746: log( 'Exception occurred in REJECT_RECORD:' || ' ' || sqlerrm);

Line 1776: -- CSM_UTIL_PKG.LOG('YL: IS_FIELD_SERVICE_PALM_ENABLED = ' || l_option_value);

1772:
1773: l_option_value := fnd_profile.value_specific('JTM_MOB_APPS_ENABLED', null,
1774: l_responsibility_id, l_application_id);
1775:
1776: -- CSM_UTIL_PKG.LOG('YL: IS_FIELD_SERVICE_PALM_ENABLED = ' || l_option_value);
1777:
1778: IF ( l_option_value = 'Y' ) THEN
1779: RETURN TRUE;
1780: END IF;

Line 1785: -- CSM_UTIL_PKG.LOG('YL: IS_FIELD_SERVICE_PALM_ENABLED EXCEPTION ');

1781:
1782: RETURN FALSE;
1783: EXCEPTION
1784: WHEN NO_DATA_FOUND THEN
1785: -- CSM_UTIL_PKG.LOG('YL: IS_FIELD_SERVICE_PALM_ENABLED EXCEPTION ');
1786: RETURN FALSE;
1787: WHEN OTHERS THEN
1788: -- CSM_UTIL_PKG.LOG('YL: IS_FIELD_SERVICE_PALM_ENABLED EXCEPTION ');
1789: RAISE;

Line 1788: -- CSM_UTIL_PKG.LOG('YL: IS_FIELD_SERVICE_PALM_ENABLED EXCEPTION ');

1784: WHEN NO_DATA_FOUND THEN
1785: -- CSM_UTIL_PKG.LOG('YL: IS_FIELD_SERVICE_PALM_ENABLED EXCEPTION ');
1786: RETURN FALSE;
1787: WHEN OTHERS THEN
1788: -- CSM_UTIL_PKG.LOG('YL: IS_FIELD_SERVICE_PALM_ENABLED EXCEPTION ');
1789: RAISE;
1790: END IS_FIELD_SERVICE_PALM_ENABLED;
1791:
1792: /* GET_TASK_ESC_LEVEL

Line 1843: l_err_msg := 'Failed csm_util_pkg.is_flow_history : ' || p_flowtype;

1839: END IF ;
1840:
1841: EXCEPTION
1842: WHEN OTHERS THEN
1843: l_err_msg := 'Failed csm_util_pkg.is_flow_history : ' || p_flowtype;
1844: CSM_UTIL_PKG.LOG(l_err_msg, 'CSM_UTIL_PKG.IS_FLOW_HISTORY', FND_LOG.LEVEL_ERROR);
1845: RETURN FALSE;
1846: END is_flow_history;
1847:

Line 1844: CSM_UTIL_PKG.LOG(l_err_msg, 'CSM_UTIL_PKG.IS_FLOW_HISTORY', FND_LOG.LEVEL_ERROR);

1840:
1841: EXCEPTION
1842: WHEN OTHERS THEN
1843: l_err_msg := 'Failed csm_util_pkg.is_flow_history : ' || p_flowtype;
1844: CSM_UTIL_PKG.LOG(l_err_msg, 'CSM_UTIL_PKG.IS_FLOW_HISTORY', FND_LOG.LEVEL_ERROR);
1845: RETURN FALSE;
1846: END is_flow_history;
1847:
1848: FUNCTION get_debrief_header_id(p_debrief_header_id in CSF_DEBRIEF_HEADERS.DEBRIEF_HEADER_ID%TYPE)

Line 1994: IF g_debug_level >= CSM_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

1990: RETURN(ROUND(l_actual_value,2));
1991:
1992: EXCEPTION
1993: WHEN OTHERS THEN
1994: IF g_debug_level >= CSM_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
1995: log ( 'Exception occurred in Get_Datediff_For_Req_UOM :' || ' ' || sqlerrm);
1996: END IF;
1997:
1998: RAISE;

Line 2214: log('Turning Off Audit as Current Audit Profile Value:'||l_cur_val,'CSM_UTIL_PKG.set_task_audit');

2210: IF p_new_val='N' THEN
2211: l_cur_val:=upper(fnd_profile.value('JTF_TASK_ENABLE_AUDIT'));
2212: IF NVL(l_cur_val,'Y')='Y' THEN
2213: x:=fnd_profile.save('JTF_TASK_ENABLE_AUDIT','N','SITE');
2214: log('Turning Off Audit as Current Audit Profile Value:'||l_cur_val,'CSM_UTIL_PKG.set_task_audit');
2215: END IF;
2216: RETURN l_cur_val;
2217: ELSE
2218: IF p_old_val IS NULL THEN

Line 2220: log('Deleting Audit profile as it did not exist before','CSM_UTIL_PKG.set_task_audit');

2216: RETURN l_cur_val;
2217: ELSE
2218: IF p_old_val IS NULL THEN
2219: x:=fnd_profile.delete('JTF_TASK_ENABLE_AUDIT','SITE');
2220: log('Deleting Audit profile as it did not exist before','CSM_UTIL_PKG.set_task_audit');
2221: ELSIF p_old_val='Y' THEN
2222: x:=fnd_profile.save('JTF_TASK_ENABLE_AUDIT','Y','SITE');
2223: log('Re-enabling Audit profile','CSM_UTIL_PKG.set_task_audit');
2224: END IF;

Line 2223: log('Re-enabling Audit profile','CSM_UTIL_PKG.set_task_audit');

2219: x:=fnd_profile.delete('JTF_TASK_ENABLE_AUDIT','SITE');
2220: log('Deleting Audit profile as it did not exist before','CSM_UTIL_PKG.set_task_audit');
2221: ELSIF p_old_val='Y' THEN
2222: x:=fnd_profile.save('JTF_TASK_ENABLE_AUDIT','Y','SITE');
2223: log('Re-enabling Audit profile','CSM_UTIL_PKG.set_task_audit');
2224: END IF;
2225: RETURN p_old_val;
2226: END IF;
2227: END set_task_audit;

Line 2284: END CSM_UTIL_PKG;

2280: WHEN OTHERS THEN
2281: RETURN NULL;
2282: END get_fnd_user_language;
2283:
2284: END CSM_UTIL_PKG;