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.16 2008/02/21 09:02:34 trajasek 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 1511: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1507: ) IS
1508: BEGIN
1509: x_return_status := FND_API.G_RET_STS_SUCCESS;
1510:
1511: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1512: log
1513: ( 'Entering DELETE_RECORD');
1514: END IF;
1515:

Line 1531: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1527: p_api_error => TRUE
1528: );
1529: END IF;
1530:
1531: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1532: log
1533: ( 'Leaving DELETE_RECORD');
1534: END IF;
1535:

Line 1537: IF g_debug_level >= CSM_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

1533: ( 'Leaving DELETE_RECORD');
1534: END IF;
1535:
1536: EXCEPTION WHEN OTHERS THEN
1537: IF g_debug_level >= CSM_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
1538: log
1539: ( 'Exception occurred in DELETE_RECORD:' || ' ' || sqlerrm);
1540: END IF;
1541:

Line 1548: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1544: (
1545: p_api_error => TRUE
1546: );
1547:
1548: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1549: log
1550: ( 'Leaving DELETE_RECORD');
1551: END IF;
1552: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1574: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1570: ) IS
1571: BEGIN
1572: x_return_status := FND_API.G_RET_STS_SUCCESS;
1573:
1574: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1575: log
1576: ( 'Entering DEFER_RECORD');
1577: END IF;
1578:

Line 1588: IF g_debug_level >= CSM_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

1584: x_return_status);
1585: /*** check if defer was successfull ***/
1586: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1587: /*** no -> log and return error ***/
1588: IF g_debug_level >= CSM_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
1589: log
1590: ( 'asg_defer.defer_row failed:' || ' ' || p_error_msg
1591: );
1592: END IF;

Line 1594: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1590: ( 'asg_defer.defer_row failed:' || ' ' || p_error_msg
1591: );
1592: END IF;
1593:
1594: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1595: log
1596: ( 'Leaving DEFER_RECORD');
1597: END IF;
1598: RETURN;

Line 1604: IF g_debug_level >= CSM_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1600:
1601: -- ANURAG
1602: /*** defer successful -> reject record only for inserts ***/
1603: IF p_dml_type = 'I' THEN
1604: IF g_debug_level >= CSM_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1605: log
1606: ( 'Rejecting record');
1607: END IF;
1608:

Line 1618: IF g_debug_level >= CSM_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

1614: x_return_status);
1615: /*** check if reject was successfull ***/
1616: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1617: /*** no -> log error ***/
1618: IF g_debug_level >= CSM_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
1619: log
1620: ( 'asg_defer.reject_row failed:' || ' ' || p_error_msg);
1621: END IF;
1622: END IF;

Line 1625: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1621: END IF;
1622: END IF;
1623: END IF; --end DML = 'I'
1624:
1625: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1626: log
1627: ( 'Leaving DEFER_RECORD');
1628: END IF;
1629: EXCEPTION WHEN OTHERS THEN

Line 1630: IF g_debug_level >= CSM_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

1626: log
1627: ( 'Leaving DEFER_RECORD');
1628: END IF;
1629: EXCEPTION WHEN OTHERS THEN
1630: IF g_debug_level >= CSM_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
1631: log
1632: ( 'Exception occurred in DEFER_RECORD:' || ' ' || sqlerrm);
1633: END IF;
1634:

Line 1635: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1631: log
1632: ( 'Exception occurred in DEFER_RECORD:' || ' ' || sqlerrm);
1633: END IF;
1634:
1635: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1636: log
1637: ( 'Leaving DEFER_RECORD');
1638: END IF;
1639:

Line 1662: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1658: ) IS
1659: BEGIN
1660: x_return_status := FND_API.G_RET_STS_SUCCESS;
1661:
1662: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1663: log
1664: ( 'Entering REJECT_RECORD');
1665: END IF;
1666:

Line 1676: IF g_debug_level >= CSM_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

1672: x_return_status);
1673: /*** check if reject was successfull ***/
1674: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1675: /*** no -> log error ***/
1676: IF g_debug_level >= CSM_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
1677: log
1678: ( 'asg_defer.reject_row failed:' || ' ' || p_error_msg);
1679: END IF;
1680: END IF;

Line 1682: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1678: ( 'asg_defer.reject_row failed:' || ' ' || p_error_msg);
1679: END IF;
1680: END IF;
1681:
1682: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1683: log
1684: ( 'Leaving REJECT_RECORD');
1685: END IF;
1686: EXCEPTION WHEN OTHERS THEN

Line 1687: IF g_debug_level >= CSM_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

1683: log
1684: ( 'Leaving REJECT_RECORD');
1685: END IF;
1686: EXCEPTION WHEN OTHERS THEN
1687: IF g_debug_level >= CSM_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
1688: log
1689: ( 'Exception occurred in REJECT_RECORD:' || ' ' || sqlerrm);
1690: END IF;
1691:

Line 1692: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1688: log
1689: ( 'Exception occurred in REJECT_RECORD:' || ' ' || sqlerrm);
1690: END IF;
1691:
1692: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1693: log
1694: ( 'Leaving REJECT_RECORD');
1695: END IF;
1696:

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

1721:
1722: l_option_value := fnd_profile.value_specific('JTM_MOB_APPS_ENABLED', null,
1723: l_responsibility_id, l_application_id);
1724:
1725: -- CSM_UTIL_PKG.LOG('YL: IS_FIELD_SERVICE_PALM_ENABLED = ' || l_option_value);
1726:
1727: IF ( l_option_value = 'Y' ) THEN
1728: RETURN TRUE;
1729: END IF;

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

1730:
1731: RETURN FALSE;
1732: EXCEPTION
1733: WHEN NO_DATA_FOUND THEN
1734: -- CSM_UTIL_PKG.LOG('YL: IS_FIELD_SERVICE_PALM_ENABLED EXCEPTION ');
1735: RETURN FALSE;
1736: WHEN OTHERS THEN
1737: -- CSM_UTIL_PKG.LOG('YL: IS_FIELD_SERVICE_PALM_ENABLED EXCEPTION ');
1738: RAISE;

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

1733: WHEN NO_DATA_FOUND THEN
1734: -- CSM_UTIL_PKG.LOG('YL: IS_FIELD_SERVICE_PALM_ENABLED EXCEPTION ');
1735: RETURN FALSE;
1736: WHEN OTHERS THEN
1737: -- CSM_UTIL_PKG.LOG('YL: IS_FIELD_SERVICE_PALM_ENABLED EXCEPTION ');
1738: RAISE;
1739: END IS_FIELD_SERVICE_PALM_ENABLED;
1740:
1741: /* GET_TASK_ESC_LEVEL

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

1788: END IF ;
1789:
1790: EXCEPTION
1791: WHEN OTHERS THEN
1792: l_err_msg := 'Failed csm_util_pkg.is_flow_history : ' || p_flowtype;
1793: CSM_UTIL_PKG.LOG(l_err_msg, 'CSM_UTIL_PKG.IS_FLOW_HISTORY', FND_LOG.LEVEL_ERROR);
1794: RETURN FALSE;
1795: END is_flow_history;
1796:

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

1789:
1790: EXCEPTION
1791: WHEN OTHERS THEN
1792: l_err_msg := 'Failed csm_util_pkg.is_flow_history : ' || p_flowtype;
1793: CSM_UTIL_PKG.LOG(l_err_msg, 'CSM_UTIL_PKG.IS_FLOW_HISTORY', FND_LOG.LEVEL_ERROR);
1794: RETURN FALSE;
1795: END is_flow_history;
1796:
1797: FUNCTION get_debrief_header_id(p_debrief_header_id in CSF_DEBRIEF_HEADERS.DEBRIEF_HEADER_ID%TYPE)

Line 1943: IF g_debug_level >= CSM_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

1939: RETURN(ROUND(l_actual_value,2));
1940:
1941: EXCEPTION
1942: WHEN OTHERS THEN
1943: IF g_debug_level >= CSM_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
1944: log ( 'Exception occurred in Get_Datediff_For_Req_UOM :' || ' ' || sqlerrm);
1945: END IF;
1946:
1947: RAISE;

Line 2069: END CSM_UTIL_PKG;

2065: RETURN l_group_name;
2066:
2067: END get_group_name;
2068:
2069: END CSM_UTIL_PKG;