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.CZ_SECURITY_PVT dependencies on CZ_UTILS

Line 426: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_API_VERSION_ERR','CODEVERSION',l_api_version,'VERSION',p_api_version);

422: sysdate,FND_GLOBAL.USER_ID,sysdate,FND_GLOBAL.USER_ID,-1,l_resp_id,-1,-1);
423: END IF;
424: EXCEPTION
425: WHEN G_INCOMPATIBLE_API THEN
426: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_API_VERSION_ERR','CODEVERSION',l_api_version,'VERSION',p_api_version);
427: x_return_status := FND_API.G_RET_STS_ERROR;
428: x_msg_count := 1;
429: WHEN NULL_USER_NAME THEN
430: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_USER_IS_NULL');

Line 430: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_USER_IS_NULL');

426: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_API_VERSION_ERR','CODEVERSION',l_api_version,'VERSION',p_api_version);
427: x_return_status := FND_API.G_RET_STS_ERROR;
428: x_msg_count := 1;
429: WHEN NULL_USER_NAME THEN
430: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_USER_IS_NULL');
431: x_return_status := FND_API.G_RET_STS_ERROR;
432: x_msg_count := 1;
433: WHEN RESP_IS_NULL THEN
434: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_RESP_IS_NULL');

Line 434: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_RESP_IS_NULL');

430: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_USER_IS_NULL');
431: x_return_status := FND_API.G_RET_STS_ERROR;
432: x_msg_count := 1;
433: WHEN RESP_IS_NULL THEN
434: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_RESP_IS_NULL');
435: x_return_status := FND_API.G_RET_STS_ERROR;
436: x_msg_count := 1;
437: WHEN INVALID_ROLE THEN
438: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_INVALID_ROLE');

Line 438: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_INVALID_ROLE');

434: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_RESP_IS_NULL');
435: x_return_status := FND_API.G_RET_STS_ERROR;
436: x_msg_count := 1;
437: WHEN INVALID_ROLE THEN
438: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_INVALID_ROLE');
439: x_return_status := FND_API.G_RET_STS_ERROR;
440: x_msg_count := 1;
441: WHEN FUNCTION_NAME_NULL THEN
442: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_FUNC_NAME_IS_NULL');

Line 442: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_FUNC_NAME_IS_NULL');

438: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_INVALID_ROLE');
439: x_return_status := FND_API.G_RET_STS_ERROR;
440: x_msg_count := 1;
441: WHEN FUNCTION_NAME_NULL THEN
442: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_FUNC_NAME_IS_NULL');
443: x_return_status := FND_API.G_RET_STS_ERROR;
444: x_msg_count := 1;
445: WHEN ENTITY_ROLE_IS_NULL THEN
446: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_ENTITY_ROLE_IS_NULL');

Line 446: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_ENTITY_ROLE_IS_NULL');

442: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_FUNC_NAME_IS_NULL');
443: x_return_status := FND_API.G_RET_STS_ERROR;
444: x_msg_count := 1;
445: WHEN ENTITY_ROLE_IS_NULL THEN
446: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_ENTITY_ROLE_IS_NULL');
447: x_return_status := FND_API.G_RET_STS_ERROR;
448: x_msg_count := 1;
449: WHEN MENU_ID_NOT_FOUND THEN
450: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_INVALID_ROLE', 'Privilege', p_entity_role );

Line 450: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_INVALID_ROLE', 'Privilege', p_entity_role );

446: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_ENTITY_ROLE_IS_NULL');
447: x_return_status := FND_API.G_RET_STS_ERROR;
448: x_msg_count := 1;
449: WHEN MENU_ID_NOT_FOUND THEN
450: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_INVALID_ROLE', 'Privilege', p_entity_role );
451: x_return_status := FND_API.G_RET_STS_ERROR;
452: x_msg_count := 1;
453: WHEN OBJECT_ID_NOT_FOUND THEN
454: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_OBJECT_ID_ERR', 'object_id',l_entity_type);

Line 454: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_OBJECT_ID_ERR', 'object_id',l_entity_type);

450: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_INVALID_ROLE', 'Privilege', p_entity_role );
451: x_return_status := FND_API.G_RET_STS_ERROR;
452: x_msg_count := 1;
453: WHEN OBJECT_ID_NOT_FOUND THEN
454: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_OBJECT_ID_ERR', 'object_id',l_entity_type);
455: x_return_status := FND_API.G_RET_STS_ERROR;
456: x_msg_count := 1;
457: WHEN INSTANCE_SET_ERR THEN
458: x_msg_data := CZ_UTILS.GET_TEXT('CZ_INVALID_INSTANCE_SET', 'SET',l_inst_name,

Line 458: x_msg_data := CZ_UTILS.GET_TEXT('CZ_INVALID_INSTANCE_SET', 'SET',l_inst_name,

454: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_OBJECT_ID_ERR', 'object_id',l_entity_type);
455: x_return_status := FND_API.G_RET_STS_ERROR;
456: x_msg_count := 1;
457: WHEN INSTANCE_SET_ERR THEN
458: x_msg_data := CZ_UTILS.GET_TEXT('CZ_INVALID_INSTANCE_SET', 'SET',l_inst_name,
459: 'ENTITY_TYPE',l_entity_type, 'ERROR', SQLERRM);
460: x_msg_count := 1;
461: x_return_status := FND_API.G_RET_STS_ERROR;
462: WHEN PRIV_ALREADY_EXISTS THEN

Line 552: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_API_VERSION_ERR','CODEVERSION',l_api_version,'VERSION',p_api_version);

548: AND instance_pk1_value = to_char(p_instance_pk1_value);
549: END IF;
550: EXCEPTION
551: WHEN G_INCOMPATIBLE_API THEN
552: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_API_VERSION_ERR','CODEVERSION',l_api_version,'VERSION',p_api_version);
553: x_return_status := FND_API.G_RET_STS_ERROR;
554: WHEN OBJECT_ID_NOT_FOUND THEN
555: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_OBJECT_ID_ERR', 'object_id', l_entity_type);
556: x_return_status := FND_API.G_RET_STS_ERROR;

Line 555: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_OBJECT_ID_ERR', 'object_id', l_entity_type);

551: WHEN G_INCOMPATIBLE_API THEN
552: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_API_VERSION_ERR','CODEVERSION',l_api_version,'VERSION',p_api_version);
553: x_return_status := FND_API.G_RET_STS_ERROR;
554: WHEN OBJECT_ID_NOT_FOUND THEN
555: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_OBJECT_ID_ERR', 'object_id', l_entity_type);
556: x_return_status := FND_API.G_RET_STS_ERROR;
557: WHEN INVALID_ENTITY_TYPE THEN
558: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_INVALID_ENTITY_TYP', 'OBJECTTYPE', l_entity_type);
559: x_return_status := FND_API.G_RET_STS_ERROR;

Line 558: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_INVALID_ENTITY_TYP', 'OBJECTTYPE', l_entity_type);

554: WHEN OBJECT_ID_NOT_FOUND THEN
555: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_OBJECT_ID_ERR', 'object_id', l_entity_type);
556: x_return_status := FND_API.G_RET_STS_ERROR;
557: WHEN INVALID_ENTITY_TYPE THEN
558: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_INVALID_ENTITY_TYP', 'OBJECTTYPE', l_entity_type);
559: x_return_status := FND_API.G_RET_STS_ERROR;
560: WHEN ENTITY_ROLE_IS_NULL THEN
561: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_ENTITY_ROLE_IS_NULL');
562: x_return_status := FND_API.G_RET_STS_ERROR;

Line 561: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_ENTITY_ROLE_IS_NULL');

557: WHEN INVALID_ENTITY_TYPE THEN
558: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_INVALID_ENTITY_TYP', 'OBJECTTYPE', l_entity_type);
559: x_return_status := FND_API.G_RET_STS_ERROR;
560: WHEN ENTITY_ROLE_IS_NULL THEN
561: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_ENTITY_ROLE_IS_NULL');
562: x_return_status := FND_API.G_RET_STS_ERROR;
563: x_msg_count := 1;
564: WHEN MENU_ID_NOT_FOUND THEN
565: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_INVALID_ROLE', 'Privilege', p_entity_role );

Line 565: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_INVALID_ROLE', 'Privilege', p_entity_role );

561: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_ENTITY_ROLE_IS_NULL');
562: x_return_status := FND_API.G_RET_STS_ERROR;
563: x_msg_count := 1;
564: WHEN MENU_ID_NOT_FOUND THEN
565: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_INVALID_ROLE', 'Privilege', p_entity_role );
566: x_return_status := FND_API.G_RET_STS_ERROR;
567: x_msg_count := 1;
568: WHEN NO_PRIV_EXISTS THEN
569: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_NO_PRIV_EXISTS');

Line 569: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_NO_PRIV_EXISTS');

565: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_INVALID_ROLE', 'Privilege', p_entity_role );
566: x_return_status := FND_API.G_RET_STS_ERROR;
567: x_msg_count := 1;
568: WHEN NO_PRIV_EXISTS THEN
569: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_NO_PRIV_EXISTS');
570: -----x_return_status := FND_API.G_RET_STS_ERROR;
571: WHEN OTHERS THEN
572: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_FATAL_ERR', 'SQLERRM', SQLERRM);
573: x_return_status := FND_API.G_RET_STS_ERROR;

Line 572: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_FATAL_ERR', 'SQLERRM', SQLERRM);

568: WHEN NO_PRIV_EXISTS THEN
569: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_NO_PRIV_EXISTS');
570: -----x_return_status := FND_API.G_RET_STS_ERROR;
571: WHEN OTHERS THEN
572: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_FATAL_ERR', 'SQLERRM', SQLERRM);
573: x_return_status := FND_API.G_RET_STS_ERROR;
574: END revoke_privilege;
575:
576: -------------------------------------------------------------

Line 1058: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_PROFILE_NULL');

1054: x_return_status := 'N';
1055: END IF;
1056: EXCEPTION
1057: WHEN PROFILE_VALUE_NULL THEN
1058: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_PROFILE_NULL');
1059: x_msg_count := 1;
1060: x_return_status := 'U';
1061: WHEN OTHERS THEN
1062: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_PRIV_FATAL_ERR', 'ERR', SQLERRM);

Line 1062: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_PRIV_FATAL_ERR', 'ERR', SQLERRM);

1058: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_PROFILE_NULL');
1059: x_msg_count := 1;
1060: x_return_status := 'U';
1061: WHEN OTHERS THEN
1062: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_PRIV_FATAL_ERR', 'ERR', SQLERRM);
1063: x_msg_count := 1;
1064: x_return_status := 'U';
1065: END is_lock_required ;
1066:

Line 1364: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_LOCK_ENTITY_ERR');

1360: x_msg_count,
1361: x_msg_data);
1362:
1363: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1364: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_LOCK_ENTITY_ERR');
1365: x_msg_count := 1;
1366: x_return_status := FND_API.G_RET_STS_ERROR;
1367: END IF;
1368:

Line 1371: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_API_VERSION_ERR','CODEVERSION',l_api_version,'VERSION',p_api_version);

1367: END IF;
1368:
1369: EXCEPTION
1370: WHEN G_INCOMPATIBLE_API THEN
1371: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_API_VERSION_ERR','CODEVERSION',l_api_version,'VERSION',p_api_version);
1372: x_msg_count := 1;
1373: x_return_status := FND_API.G_RET_STS_ERROR;
1374: WHEN NO_LOCK_CONTROL_REQUIRED THEN
1375: NULL; ----do nothing

Line 1377: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_USER_NAME_NULL');

1373: x_return_status := FND_API.G_RET_STS_ERROR;
1374: WHEN NO_LOCK_CONTROL_REQUIRED THEN
1375: NULL; ----do nothing
1376: WHEN USER_NAME_NULL THEN
1377: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_USER_NAME_NULL');
1378: x_msg_count := 1;
1379: x_return_status := FND_API.G_RET_STS_ERROR;
1380: WHEN INVALID_USER_NAME THEN
1381: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_INVALID_USER_NAME','USERNAME',p_user_name);

Line 1381: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_INVALID_USER_NAME','USERNAME',p_user_name);

1377: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_USER_NAME_NULL');
1378: x_msg_count := 1;
1379: x_return_status := FND_API.G_RET_STS_ERROR;
1380: WHEN INVALID_USER_NAME THEN
1381: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_INVALID_USER_NAME','USERNAME',p_user_name);
1382: x_msg_count := 1;
1383: x_return_status := FND_API.G_RET_STS_ERROR;
1384: WHEN APPL_NAME_NULL THEN
1385: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_APPL_NAME_NULL');

Line 1385: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_APPL_NAME_NULL');

1381: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_INVALID_USER_NAME','USERNAME',p_user_name);
1382: x_msg_count := 1;
1383: x_return_status := FND_API.G_RET_STS_ERROR;
1384: WHEN APPL_NAME_NULL THEN
1385: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_APPL_NAME_NULL');
1386: x_msg_count := 1;
1387: x_return_status := FND_API.G_RET_STS_ERROR;
1388: WHEN RESP_NAME_NULL THEN
1389: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_RESP_NAME_NULL');

Line 1389: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_RESP_NAME_NULL');

1385: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_APPL_NAME_NULL');
1386: x_msg_count := 1;
1387: x_return_status := FND_API.G_RET_STS_ERROR;
1388: WHEN RESP_NAME_NULL THEN
1389: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_RESP_NAME_NULL');
1390: x_msg_count := 1;
1391: x_return_status := FND_API.G_RET_STS_ERROR;
1392: WHEN INVALID_APPLICATION THEN
1393: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_INVALID_APPLICATION','APPLICATION',p_application);

Line 1393: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_INVALID_APPLICATION','APPLICATION',p_application);

1389: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_RESP_NAME_NULL');
1390: x_msg_count := 1;
1391: x_return_status := FND_API.G_RET_STS_ERROR;
1392: WHEN INVALID_APPLICATION THEN
1393: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_INVALID_APPLICATION','APPLICATION',p_application);
1394: x_msg_count := 1;
1395: x_return_status := FND_API.G_RET_STS_ERROR;
1396: WHEN INVALID_RESPONSIBILITY THEN
1397: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_INVALID_RESPONSIBILITY','RESPONSIBILITY',p_responsibility);

Line 1397: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_INVALID_RESPONSIBILITY','RESPONSIBILITY',p_responsibility);

1393: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_INVALID_APPLICATION','APPLICATION',p_application);
1394: x_msg_count := 1;
1395: x_return_status := FND_API.G_RET_STS_ERROR;
1396: WHEN INVALID_RESPONSIBILITY THEN
1397: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_INVALID_RESPONSIBILITY','RESPONSIBILITY',p_responsibility);
1398: x_msg_count := 1;
1399: x_return_status := FND_API.G_RET_STS_ERROR;
1400: WHEN OTHERS THEN
1401: x_msg_data := SQLERRM;

Line 1458: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_MODEL_ID_NULL');

1454: END IF;
1455: RETURN l_status;
1456: EXCEPTION
1457: WHEN MODEL_ID_IS_NULL THEN
1458: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_MODEL_ID_NULL');
1459: RETURN l_status;
1460: WHEN OTHERS THEN
1461: l_status := SQLERRM;
1462: RETURN l_status;

Line 1599: l_event_note := CZ_UTILS.GET_TEXT('CZ_SEC_LOCK_MODEL_STRUCTURE',

1595: UPDATE cz_ps_nodes
1596: SET checkout_user = FND_GLOBAL.user_name
1597: WHERE ps_node_id = p_model_id;
1598:
1599: l_event_note := CZ_UTILS.GET_TEXT('CZ_SEC_LOCK_MODEL_STRUCTURE',
1600: 'LOCKEDBY',FND_GLOBAL.user_name,'LOCKDATE',
1601: to_char(sysdate,'mm-dd-yyyy hh24:mi:ss'));
1602: log_lock_history (2,p_model_id,'LOCK_STRUCTURE',l_event_note);
1603: ELSIF (l_checkout_user <> FND_GLOBAL.user_name) THEN

Line 1647: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_NO_MODEL_FOUND', 'MODELID', p_model_id);

1643: END IF;
1644: RETURN l_status;
1645: EXCEPTION
1646: WHEN NO_DATA_FOUND THEN
1647: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_NO_MODEL_FOUND', 'MODELID', p_model_id);
1648: RETURN l_status;
1649: WHEN MODEL_LOCKED THEN
1650: RETURN l_status;
1651: WHEN MODEL_ID_IS_NULL THEN

Line 1652: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_MODEL_ID_NULL');

1648: RETURN l_status;
1649: WHEN MODEL_LOCKED THEN
1650: RETURN l_status;
1651: WHEN MODEL_ID_IS_NULL THEN
1652: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_MODEL_ID_NULL');
1653: RETURN l_status;
1654: WHEN OTHERS THEN
1655: l_status := SQLERRM;
1656: RETURN l_status;

Line 1689: l_event_note := CZ_UTILS.GET_TEXT('CZ_SEC_UNLOCK_MODEL_STRUCTURE',

1685: UPDATE cz_ps_nodes
1686: SET checkout_user = NULL
1687: WHERE ps_node_id = p_model_id;
1688:
1689: l_event_note := CZ_UTILS.GET_TEXT('CZ_SEC_UNLOCK_MODEL_STRUCTURE',
1690: 'UNLOCKEDBY',FND_GLOBAL.user_name,'UNLOCKDATE',to_char(sysdate,'mm-dd-yyyy hh24:mi:ss'));
1691: log_lock_history (2,p_model_id,'UNLOCK_STRUCTURE',l_event_note);
1692: ELSIF ( (l_checkout_user IS NOT NULL) AND (l_checkout_user <> FND_GLOBAL.user_name) )THEN
1693: l_ret_status := 'F';

Line 1728: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_ENTITY_IS_LOCKED','ObjectId', cz_security_pvt.UI,

1724: IF (l_checkout_user_tbl.COUNT > 0) THEN
1725: FOR uiId IN l_checkout_user_tbl.FIRST..l_checkout_user_tbl.LAST
1726: LOOP
1727: IF ( (l_checkout_user IS NOT NULL) AND (l_checkout_user_tbl(uiId) <> FND_GLOBAL.user_name)) THEN
1728: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_ENTITY_IS_LOCKED','ObjectId', cz_security_pvt.UI,
1729: 'Id',l_ui_bl(uiId),'User', l_checkout_user_tbl(uiId) );
1730: EXIT;
1731: END IF;
1732: END LOOP;

Line 1737: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_UI_DEF_ID_NULL');

1733: END IF;
1734: RETURN l_status;
1735: EXCEPTION
1736: WHEN UI_DEF_ID_IS_NULL THEN
1737: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_UI_DEF_ID_NULL');
1738: RETURN l_status;
1739: WHEN MODEL_LOCKED THEN
1740: RETURN l_status;
1741: WHEN OTHERS THEN

Line 1782: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_NO_MODEL_FOUND', 'UIDEFID', p_ui_def_id);

1778: END IF;
1779: RETURN l_status;
1780: EXCEPTION
1781: WHEN NO_DATA_FOUND THEN
1782: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_NO_MODEL_FOUND', 'UIDEFID', p_ui_def_id);
1783: RETURN l_status;
1784: WHEN MODEL_LOCKED THEN
1785: RETURN l_status;
1786: WHEN UI_DEF_ID_IS_NULL THEN

Line 1787: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_UI_DEF_ID_NULL');

1783: RETURN l_status;
1784: WHEN MODEL_LOCKED THEN
1785: RETURN l_status;
1786: WHEN UI_DEF_ID_IS_NULL THEN
1787: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_UI_DEF_ID_NULL');
1788: RETURN l_status;
1789: WHEN OTHERS THEN
1790: l_status := SQLERRM;
1791: RETURN l_status;

Line 1840: l_event_note := CZ_UTILS.GET_TEXT('CZ_SEC_LOCK_UI_EVENT',

1836: IF (l_checkout_user IS NULL) THEN
1837: UPDATE cz_ui_defs
1838: SET checkout_user = FND_GLOBAL.user_name
1839: WHERE ui_def_id = p_ui_def_id ;
1840: l_event_note := CZ_UTILS.GET_TEXT('CZ_SEC_LOCK_UI_EVENT',
1841: 'LOCKEDBY',FND_GLOBAL.user_name,'LOCKDATE',to_char(sysdate,'mm-dd-yyyy hh24:mi:ss'));
1842: log_lock_history (3,p_ui_def_id,'LOCK_UI',l_event_note);
1843: ELSIF (l_checkout_user <> FND_GLOBAL.user_name) THEN
1844: l_ret_status := 'F';

Line 1881: l_event_note := CZ_UTILS.GET_TEXT('CZ_SEC_UNLOCK_UI_EVENT',

1877: IF ( (l_checkout_user IS NOT NULL) AND (l_checkout_user = FND_GLOBAL.user_name) ) THEN
1878: UPDATE cz_ui_defs
1879: SET checkout_user = NULL
1880: WHERE ui_def_id = p_ui_def_id ;
1881: l_event_note := CZ_UTILS.GET_TEXT('CZ_SEC_UNLOCK_UI_EVENT',
1882: 'UNLOCKEDBY',FND_GLOBAL.user_name,'UNLOCKDATE',to_char(sysdate,'mm-dd-yyyy hh24:mi:ss'));
1883: log_lock_history (3,p_ui_def_id,'UNLOCK_UI',l_event_note);
1884: ELSIF ( (l_checkout_user IS NOT NULL) AND (l_checkout_user <> FND_GLOBAL.user_name) )THEN
1885: l_ret_status := 'F';

Line 1934: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_MODELID_IS_NULL');

1930: END IF;
1931: RETURN l_status;
1932: EXCEPTION
1933: WHEN MODELID_IS_NULL THEN
1934: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_MODELID_IS_NULL');
1935: RETURN l_status;
1936: WHEN MODEL_LOCKED THEN
1937: RETURN l_status;
1938: WHEN OTHERS THEN

Line 2074: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_NO_MODEL_FOUND','RULEFOLDERID',p_rule_folder_id );

2070: END IF;
2071: RETURN l_status;
2072: EXCEPTION
2073: WHEN NO_DATA_FOUND THEN
2074: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_NO_MODEL_FOUND','RULEFOLDERID',p_rule_folder_id );
2075: RETURN l_status;
2076: WHEN MODEL_LOCKED THEN
2077: RETURN l_status;
2078: WHEN RULE_FOLDER_ID_IS_NULL THEN

Line 2079: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_RULE_FOLDER_ID_NULL');

2075: RETURN l_status;
2076: WHEN MODEL_LOCKED THEN
2077: RETURN l_status;
2078: WHEN RULE_FOLDER_ID_IS_NULL THEN
2079: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_RULE_FOLDER_ID_NULL');
2080: RETURN l_status;
2081: WHEN OTHERS THEN
2082: l_status := SQLERRM;
2083: RETURN l_status;

Line 2136: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_NO_MODEL_FOUND','RULEFOLDERID',p_rule_folder_id );

2132: END IF;
2133: RETURN l_status;
2134: EXCEPTION
2135: WHEN NO_DATA_FOUND THEN
2136: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_NO_MODEL_FOUND','RULEFOLDERID',p_rule_folder_id );
2137: RETURN l_status;
2138: WHEN MODEL_LOCKED THEN
2139: RETURN l_status;
2140: WHEN RULE_FOLDER_ID_IS_NULL THEN

Line 2141: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_RULE_FOLDER_ID_NULL');

2137: RETURN l_status;
2138: WHEN MODEL_LOCKED THEN
2139: RETURN l_status;
2140: WHEN RULE_FOLDER_ID_IS_NULL THEN
2141: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_RULE_FOLDER_ID_NULL');
2142: RETURN l_status;
2143: WHEN OTHERS THEN
2144: l_status := SQLERRM;
2145: RETURN l_status;

Line 2205: l_event_note := CZ_UTILS.GET_TEXT('CZ_SEC_LOCK_RFL_EVENT',

2201: UPDATE cz_rule_folders
2202: SET checkout_user = FND_GLOBAL.user_name
2203: WHERE rule_folder_id = l_rule_fld_tbl(i)
2204: AND object_type = 'RFL';
2205: l_event_note := CZ_UTILS.GET_TEXT('CZ_SEC_LOCK_RFL_EVENT',
2206: 'LOCKEDBY',FND_GLOBAL.user_name,'LOCKDATE',to_char(sysdate,'mm-dd-yyyy hh24:mi:ss'));
2207: log_lock_history (4,p_rule_folder_id,'LOCK_RULEFOLDER',l_event_note);
2208: END LOOP;
2209: END IF;

Line 2269: l_event_note := CZ_UTILS.GET_TEXT('CZ_SEC_UNLOCK_RFL_EVENT',

2265: UPDATE cz_rule_folders
2266: SET checkout_user = NULL
2267: WHERE rule_folder_id = l_rule_fld_tbl(i)
2268: AND object_type = 'RFL';
2269: l_event_note := CZ_UTILS.GET_TEXT('CZ_SEC_UNLOCK_RFL_EVENT',
2270: 'UNLOCKEDBY',FND_GLOBAL.user_name,'UNLOCKDATE',to_char(sysdate,'mm-dd-yyyy hh24:mi:ss'));
2271: log_lock_history (4,p_rule_folder_id,'UNLOCK_RULEFOLDER',l_event_note);
2272: END LOOP;
2273: END IF;

Line 2443: x_msg_data := CZ_UTILS.GET_TEXT('CZ_MODEL_DOES_NOT_EXIST', 'PROJID', p_devl_project_id);

2439: EXCEPTION
2440: WHEN MODEL_DELETED THEN
2441: x_return_status := 'T';
2442: x_msg_count := 1;
2443: x_msg_data := CZ_UTILS.GET_TEXT('CZ_MODEL_DOES_NOT_EXIST', 'PROJID', p_devl_project_id);
2444: WHEN MODEL_IS_LOCKED THEN
2445: x_return_status := 'T';
2446: x_msg_count := 1;
2447: x_msg_data := CZ_UTILS.GET_TEXT('CZ_MODEL_IS_LOCKED', 'USER', l_checkout_user);

Line 2447: x_msg_data := CZ_UTILS.GET_TEXT('CZ_MODEL_IS_LOCKED', 'USER', l_checkout_user);

2443: x_msg_data := CZ_UTILS.GET_TEXT('CZ_MODEL_DOES_NOT_EXIST', 'PROJID', p_devl_project_id);
2444: WHEN MODEL_IS_LOCKED THEN
2445: x_return_status := 'T';
2446: x_msg_count := 1;
2447: x_msg_data := CZ_UTILS.GET_TEXT('CZ_MODEL_IS_LOCKED', 'USER', l_checkout_user);
2448: WHEN OTHERS THEN
2449: x_return_status := 'T';
2450: x_msg_count := 1;
2451: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_FATAL_ERR', 'ERROR', SQLERRM);

Line 2451: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_FATAL_ERR', 'ERROR', SQLERRM);

2447: x_msg_data := CZ_UTILS.GET_TEXT('CZ_MODEL_IS_LOCKED', 'USER', l_checkout_user);
2448: WHEN OTHERS THEN
2449: x_return_status := 'T';
2450: x_msg_count := 1;
2451: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_FATAL_ERR', 'ERROR', SQLERRM);
2452: END is_model_locked ;
2453:
2454: ------------>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
2455: FUNCTION is_model_lockable (p_model_id IN NUMBER)

Line 2744: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_ENTITY_IS_LOCKED','ObjectId', cz_security_pvt.RULEFOLDER,

2740: AND cz_rule_folders.object_type = 'RFL'
2741: AND cz_rule_folders.deleted_flag = '0';
2742:
2743: IF ( (l_checkout_user IS NOT NULL) AND (l_checkout_user <> FND_GLOBAL.user_name)) THEN
2744: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_ENTITY_IS_LOCKED','ObjectId', cz_security_pvt.RULEFOLDER,
2745: 'Id',p_rule_folder_id,'User', l_checkout_user);
2746: END IF;
2747: RETURN l_status;
2748: EXCEPTION

Line 2750: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_NO_MODEL_FOUND','RULEFOLDERID',p_rule_folder_id );

2746: END IF;
2747: RETURN l_status;
2748: EXCEPTION
2749: WHEN NO_DATA_FOUND THEN
2750: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_NO_MODEL_FOUND','RULEFOLDERID',p_rule_folder_id );
2751: RETURN l_status;
2752: WHEN RULE_FOLDER_ID_IS_NULL THEN
2753: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_RULE_FOLDER_ID_NULL');
2754: RETURN l_status;

Line 2753: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_RULE_FOLDER_ID_NULL');

2749: WHEN NO_DATA_FOUND THEN
2750: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_NO_MODEL_FOUND','RULEFOLDERID',p_rule_folder_id );
2751: RETURN l_status;
2752: WHEN RULE_FOLDER_ID_IS_NULL THEN
2753: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_RULE_FOLDER_ID_NULL');
2754: RETURN l_status;
2755: WHEN OTHERS THEN
2756: l_status := SQLERRM;
2757: RETURN l_status;

Line 2782: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_ENTITY_IS_LOCKED','ObjectId', cz_security_pvt.UI,

2778: WHERE cz_ui_defs.ui_def_id = p_ui_def_id
2779: AND cz_ui_defs.deleted_flag = '0';
2780:
2781: IF ( (l_checkout_user IS NOT NULL) AND (l_checkout_user <> FND_GLOBAL.user_name)) THEN
2782: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_ENTITY_IS_LOCKED','ObjectId', cz_security_pvt.UI,
2783: 'Id',p_ui_def_id,'User', l_checkout_user);
2784: END IF;
2785: RETURN l_status;
2786: EXCEPTION

Line 2788: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_NO_MODEL_FOUND', 'UIDEFID', p_ui_def_id);

2784: END IF;
2785: RETURN l_status;
2786: EXCEPTION
2787: WHEN NO_DATA_FOUND THEN
2788: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_NO_MODEL_FOUND', 'UIDEFID', p_ui_def_id);
2789: RETURN l_status;
2790: WHEN UI_DEF_ID_IS_NULL THEN
2791: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_UI_DEF_ID_NULL');
2792: RETURN l_status;

Line 2791: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_UI_DEF_ID_NULL');

2787: WHEN NO_DATA_FOUND THEN
2788: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_NO_MODEL_FOUND', 'UIDEFID', p_ui_def_id);
2789: RETURN l_status;
2790: WHEN UI_DEF_ID_IS_NULL THEN
2791: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_UI_DEF_ID_NULL');
2792: RETURN l_status;
2793: WHEN OTHERS THEN
2794: l_status := SQLERRM;
2795: RETURN l_status;

Line 2820: ------l_status := CZ_UTILS.GET_TEXT('CZ_SEC_ENTITY_IS_LOCKED','ObjectId', cz_security_pvt.MODEL,

2816: WHERE cz_devl_projects.devl_project_id = p_model_id
2817: AND cz_devl_projects.deleted_flag = '0';
2818:
2819: IF (l_checkout_user IS NOT NULL) THEN
2820: ------l_status := CZ_UTILS.GET_TEXT('CZ_SEC_ENTITY_IS_LOCKED','ObjectId', cz_security_pvt.MODEL,
2821: ----- 'Id',p_model_id,'User', l_checkout_user); */
2822: l_status := 'Y';
2823: ELSE
2824: l_status := 'N';

Line 2829: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_NO_MODEL_FOUND', 'MODELID', p_model_id);

2825: END IF;
2826: RETURN l_status;
2827: EXCEPTION
2828: WHEN NO_DATA_FOUND THEN
2829: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_NO_MODEL_FOUND', 'MODELID', p_model_id);
2830: RETURN l_status;
2831: WHEN MODEL_ID_IS_NULL THEN
2832: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_MODEL_ID_NULL');
2833: RETURN l_status;

Line 2832: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_MODEL_ID_NULL');

2828: WHEN NO_DATA_FOUND THEN
2829: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_NO_MODEL_FOUND', 'MODELID', p_model_id);
2830: RETURN l_status;
2831: WHEN MODEL_ID_IS_NULL THEN
2832: l_status := CZ_UTILS.GET_TEXT('CZ_SEC_MODEL_ID_NULL');
2833: RETURN l_status;
2834: WHEN OTHERS THEN
2835: l_status := SQLERRM;
2836: RETURN l_status;

Line 3234: x_msg_data := CZ_UTILS.GET_TEXT('CZ_UNLOCK_FATAL_ERR', 'OBJECTNAME', l_model_name, 'SQLERRM', SQLERRM);

3230: WHEN OTHERS THEN
3231: x_return_status := FND_API.G_RET_STS_ERROR;
3232: x_msg_count := 1;
3233: get_checkout_user(p_model_id, 'PRJ', l_checkout_user, l_model_name);
3234: x_msg_data := CZ_UTILS.GET_TEXT('CZ_UNLOCK_FATAL_ERR', 'OBJECTNAME', l_model_name, 'SQLERRM', SQLERRM);
3235: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3236: END force_unlock_model;
3237:
3238: --------------------

Line 3331: x_msg_data := CZ_UTILS.GET_TEXT('CZ_UNLOCK_FATAL_ERR', 'OBJECTNAME', l_template_name, 'SQLERRM', SQLERRM);

3327: WHEN OTHERS THEN
3328: x_return_status := FND_API.G_RET_STS_ERROR;
3329: x_msg_count := 1;
3330: get_checkout_user(p_template_id, 'UIT', l_checkout_user, l_template_name);
3331: x_msg_data := CZ_UTILS.GET_TEXT('CZ_UNLOCK_FATAL_ERR', 'OBJECTNAME', l_template_name, 'SQLERRM', SQLERRM);
3332: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3333: END force_unlock_template;
3334:
3335: --------------------

Line 3614: x_msg_data := CZ_UTILS.GET_TEXT('CZ_UNLOCK_FATAL_ERR', 'OBJECTNAME', l_template_name, 'SQLERRM', SQLERRM);

3610: WHEN OTHERS THEN
3611: x_return_status := FND_API.G_RET_STS_ERROR;
3612: x_msg_count := 1;
3613: get_checkout_user(p_template_id, 'UIT', l_checkout_user, l_template_name);
3614: x_msg_data := CZ_UTILS.GET_TEXT('CZ_UNLOCK_FATAL_ERR', 'OBJECTNAME', l_template_name, 'SQLERRM', SQLERRM);
3615: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3616: END unlock_template;
3617:
3618: ----------------------

Line 4083: x_msg_data := CZ_UTILS.GET_TEXT('CZ_UNLOCK_FATAL_ERR', 'OBJECTNAME', l_model_name, 'SQLERRM', SQLERRM);

4079: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
4080: WHEN OTHERS THEN
4081: x_return_status := FND_API.G_RET_STS_ERROR;
4082: get_checkout_user(p_model_id, 'PRJ', l_checkout_user, l_model_name);
4083: x_msg_data := CZ_UTILS.GET_TEXT('CZ_UNLOCK_FATAL_ERR', 'OBJECTNAME', l_model_name, 'SQLERRM', SQLERRM);
4084: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4085: END unlock_model;
4086: ---------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
4087: ------wrappers