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_DEVELOPER_UTILS_PVT dependencies on CZ_SECURITY_PVT

Line 2491: l_locked_entities_tbl cz_security_pvt.number_type_tbl;

2487: x_msg_data OUT NOCOPY VARCHAR2) IS
2488:
2489: l_rule_id NUMBER;
2490: l_rule_folder_id NUMBER;
2491: l_locked_entities_tbl cz_security_pvt.number_type_tbl;
2492: l_has_priveleges VARCHAR2(255);
2493: l_msg_data VARCHAR2(32000);
2494: l_lock_status VARCHAR2(255);
2495: l_return_status VARCHAR2(255);

Line 2512: cz_security_pvt.has_privileges (p_model_id => p_new_parent_folder_id,

2508: -- by calling sequirity package
2509: --
2510: IF gDB_SETTING_USE_SECURITY THEN
2511:
2512: cz_security_pvt.has_privileges (p_model_id => p_new_parent_folder_id,
2513: p_function_name => cz_security_pvt.LOCK_RULEFOLDER_FUNC,
2514: x_return_status => l_return_status,
2515: x_msg_data => l_msg_data,
2516: x_msg_count => l_msg_count);

Line 2513: p_function_name => cz_security_pvt.LOCK_RULEFOLDER_FUNC,

2509: --
2510: IF gDB_SETTING_USE_SECURITY THEN
2511:
2512: cz_security_pvt.has_privileges (p_model_id => p_new_parent_folder_id,
2513: p_function_name => cz_security_pvt.LOCK_RULEFOLDER_FUNC,
2514: x_return_status => l_return_status,
2515: x_msg_data => l_msg_data,
2516: x_msg_count => l_msg_count);
2517:

Line 2518: IF (l_return_status IN(cz_security_pvt.UNEXPECTED_ERROR,cz_security_pvt.HAS_NO_PRIVILEGE)) THEN

2514: x_return_status => l_return_status,
2515: x_msg_data => l_msg_data,
2516: x_msg_count => l_msg_count);
2517:
2518: IF (l_return_status IN(cz_security_pvt.UNEXPECTED_ERROR,cz_security_pvt.HAS_NO_PRIVILEGE)) THEN
2519: x_run_id := GetRunID;
2520: LOG_REPORT(x_run_id,l_msg_count);
2521: RETURN;
2522: END IF;

Line 2526: cz_security_pvt.lock_entity(p_rule_folder_id,

2522: END IF;
2523:
2524: l_locked_entities_tbl.DELETE;
2525:
2526: cz_security_pvt.lock_entity(p_rule_folder_id,
2527: cz_security_pvt.LOCK_RULEFOLDER_FUNC,
2528: l_locked_entities_tbl,
2529: l_lock_status,
2530: l_msg_count,

Line 2527: cz_security_pvt.LOCK_RULEFOLDER_FUNC,

2523:
2524: l_locked_entities_tbl.DELETE;
2525:
2526: cz_security_pvt.lock_entity(p_rule_folder_id,
2527: cz_security_pvt.LOCK_RULEFOLDER_FUNC,
2528: l_locked_entities_tbl,
2529: l_lock_status,
2530: l_msg_count,
2531: l_msg_data);

Line 2625: cz_security_pvt.unlock_entity(p_rule_folder_id,

2621: LOG_REPORT(x_run_id,x_msg_data);
2622: END;
2623:
2624: IF l_locked_entities_tbl.COUNT>0 AND gDB_SETTING_USE_SECURITY THEN
2625: cz_security_pvt.unlock_entity(p_rule_folder_id,
2626: cz_security_pvt.LOCK_RULEFOLDER_FUNC,
2627: l_locked_entities_tbl,
2628: x_return_status,
2629: x_msg_count,

Line 2626: cz_security_pvt.LOCK_RULEFOLDER_FUNC,

2622: END;
2623:
2624: IF l_locked_entities_tbl.COUNT>0 AND gDB_SETTING_USE_SECURITY THEN
2625: cz_security_pvt.unlock_entity(p_rule_folder_id,
2626: cz_security_pvt.LOCK_RULEFOLDER_FUNC,
2627: l_locked_entities_tbl,
2628: x_return_status,
2629: x_msg_count,
2630: x_msg_data);

Line 3266: l_lock_profile := cz_security_pvt.get_locking_profile_value;

3262:
3263: ----check if locking is enabled
3264: ----if the site level profile for locking is not enabled then
3265: ----there is no need to check for locked objects in the folder
3266: l_lock_profile := cz_security_pvt.get_locking_profile_value;
3267: IF (UPPER(NVL(l_lock_profile,'Y')) IN ('Y','YES')) THEN
3268: FOR i IN 1..p_folder_ids.COUNT LOOP
3269: l_folder_id := p_folder_ids(i);
3270:

Line 3699: l_priv := cz_security_pvt.has_privileges (1.0,

3695: IF (l_user_name IS NULL) THEN
3696: RAISE USER_IS_NULL_EXCP;
3697: END IF;
3698:
3699: l_priv := cz_security_pvt.has_privileges (1.0,
3700: l_user_name ,cz_security_pvt.LOCK_MODEL_FUNC,cz_security_pvt.MODEL,l_devl_project_id);
3701: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN
3702: RAISE NO_PRIV_EXCP;
3703: END IF;

Line 3700: l_user_name ,cz_security_pvt.LOCK_MODEL_FUNC,cz_security_pvt.MODEL,l_devl_project_id);

3696: RAISE USER_IS_NULL_EXCP;
3697: END IF;
3698:
3699: l_priv := cz_security_pvt.has_privileges (1.0,
3700: l_user_name ,cz_security_pvt.LOCK_MODEL_FUNC,cz_security_pvt.MODEL,l_devl_project_id);
3701: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN
3702: RAISE NO_PRIV_EXCP;
3703: END IF;
3704: */

Line 3701: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN

3697: END IF;
3698:
3699: l_priv := cz_security_pvt.has_privileges (1.0,
3700: l_user_name ,cz_security_pvt.LOCK_MODEL_FUNC,cz_security_pvt.MODEL,l_devl_project_id);
3701: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN
3702: RAISE NO_PRIV_EXCP;
3703: END IF;
3704: */
3705:

Line 3708: cz_security_pvt.lock_model (l_devl_project_id,x_return_status,x_msg_count,x_msg_data);

3704: */
3705:
3706: /*
3707: ----attempt to get a lock
3708: cz_security_pvt.lock_model (l_devl_project_id,x_return_status,x_msg_count,x_msg_data);
3709: IF (x_return_status <> 'T') THEN
3710: RAISE MODEL_LOCKED_EXCP;
3711: END IF;
3712: */

Line 3757: cz_security_pvt.unlock_model (l_devl_project_id,x_return_status,x_msg_count,x_msg_data);

3753: -------------------
3754: -- Unlock the model
3755: -------------------
3756:
3757: cz_security_pvt.unlock_model (l_devl_project_id,x_return_status,x_msg_count,x_msg_data);
3758: IF (x_return_status <> 'T') THEN
3759: RAISE MODEL_UNLOCKED_EXCP;
3760: END IF;
3761: */

Line 3920: l_priv := cz_security_pvt.has_privileges (1.0,

3916: END IF;
3917: */
3918:
3919: /*
3920: l_priv := cz_security_pvt.has_privileges (1.0,
3921: l_user_name ,cz_security_pvt.LOCK_MODEL_FUNC,cz_security_pvt.MODEL,l_devl_project_id);
3922: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN
3923: RAISE NO_PRIV_EXCP;
3924: END IF;

Line 3921: l_user_name ,cz_security_pvt.LOCK_MODEL_FUNC,cz_security_pvt.MODEL,l_devl_project_id);

3917: */
3918:
3919: /*
3920: l_priv := cz_security_pvt.has_privileges (1.0,
3921: l_user_name ,cz_security_pvt.LOCK_MODEL_FUNC,cz_security_pvt.MODEL,l_devl_project_id);
3922: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN
3923: RAISE NO_PRIV_EXCP;
3924: END IF;
3925:

Line 3922: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN

3918:
3919: /*
3920: l_priv := cz_security_pvt.has_privileges (1.0,
3921: l_user_name ,cz_security_pvt.LOCK_MODEL_FUNC,cz_security_pvt.MODEL,l_devl_project_id);
3922: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN
3923: RAISE NO_PRIV_EXCP;
3924: END IF;
3925:
3926: ---------------------------------

Line 3930: IF (cz_security_pvt.lock_ui_def(p_ui_def_id) <> 'T') THEN

3926: ---------------------------------
3927: -- attempt to get a lock
3928: ---------------------------------
3929:
3930: IF (cz_security_pvt.lock_ui_def(p_ui_def_id) <> 'T') THEN
3931: RAISE UIDEF_LOCKED_EXCP;
3932: END IF;
3933: */
3934:

Line 4198: l_priv := cz_security_pvt.has_privileges (1.0,

4194: RAISE USER_IS_NULL_EXCP;
4195: END IF;
4196: */
4197: /*
4198: l_priv := cz_security_pvt.has_privileges (1.0,
4199: l_user_name ,cz_security_pvt.LOCK_MODEL_FUNC,cz_security_pvt.MODEL,l_devl_project_id);
4200: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN
4201: RAISE NO_PRIV_EXCP;
4202: END IF;

Line 4199: l_user_name ,cz_security_pvt.LOCK_MODEL_FUNC,cz_security_pvt.MODEL,l_devl_project_id);

4195: END IF;
4196: */
4197: /*
4198: l_priv := cz_security_pvt.has_privileges (1.0,
4199: l_user_name ,cz_security_pvt.LOCK_MODEL_FUNC,cz_security_pvt.MODEL,l_devl_project_id);
4200: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN
4201: RAISE NO_PRIV_EXCP;
4202: END IF;
4203:

Line 4200: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN

4196: */
4197: /*
4198: l_priv := cz_security_pvt.has_privileges (1.0,
4199: l_user_name ,cz_security_pvt.LOCK_MODEL_FUNC,cz_security_pvt.MODEL,l_devl_project_id);
4200: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN
4201: RAISE NO_PRIV_EXCP;
4202: END IF;
4203:
4204: ----------------------------------

Line 4208: IF (cz_security_pvt.lock_rulefolder(p_rule_folder_id) <> 'T') THEN

4204: ----------------------------------
4205: -- attempt to get a lock
4206: ----------------------------------
4207:
4208: IF (cz_security_pvt.lock_rulefolder(p_rule_folder_id) <> 'T') THEN
4209: RAISE RFL_LOCKED_EXCP;
4210: END IF;
4211: */
4212: ------------------------------------------------------------------------------------

Line 4364: l_priv := cz_security_pvt.has_privileges (1.0,

4360: RAISE USER_IS_NULL_EXCP;
4361: END IF;
4362: */
4363: /*
4364: l_priv := cz_security_pvt.has_privileges (1.0,
4365: l_user_name ,cz_security_pvt.LOCK_MODEL_FUNC,cz_security_pvt.MODEL,l_devl_project_id);
4366: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN
4367: RAISE NO_PRIV_EXCP;
4368: END IF;

Line 4365: l_user_name ,cz_security_pvt.LOCK_MODEL_FUNC,cz_security_pvt.MODEL,l_devl_project_id);

4361: END IF;
4362: */
4363: /*
4364: l_priv := cz_security_pvt.has_privileges (1.0,
4365: l_user_name ,cz_security_pvt.LOCK_MODEL_FUNC,cz_security_pvt.MODEL,l_devl_project_id);
4366: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN
4367: RAISE NO_PRIV_EXCP;
4368: END IF;
4369:

Line 4366: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN

4362: */
4363: /*
4364: l_priv := cz_security_pvt.has_privileges (1.0,
4365: l_user_name ,cz_security_pvt.LOCK_MODEL_FUNC,cz_security_pvt.MODEL,l_devl_project_id);
4366: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN
4367: RAISE NO_PRIV_EXCP;
4368: END IF;
4369:
4370: ----------------------------------

Line 4374: IF (cz_security_pvt.lock_rulefolder(p_rule_sequence_id) <> 'T') THEN

4370: ----------------------------------
4371: -- attempt to get a lock
4372: ----------------------------------
4373:
4374: IF (cz_security_pvt.lock_rulefolder(p_rule_sequence_id) <> 'T') THEN
4375: RAISE RSQ_LOCKED_EXCP;
4376: END IF;
4377: */
4378: ----------------------------------

Line 4501: l_priv := cz_security_pvt.has_privileges (1.0,

4497: RAISE USER_IS_NULL_EXCP;
4498: END IF;
4499: */
4500: /*
4501: l_priv := cz_security_pvt.has_privileges (1.0,
4502: l_user_name ,cz_security_pvt.LOCK_MODEL_FUNC,cz_security_pvt.MODEL,l_devl_project_id);
4503: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN
4504: RAISE NO_PRIV_EXCP;
4505: END IF;

Line 4502: l_user_name ,cz_security_pvt.LOCK_MODEL_FUNC,cz_security_pvt.MODEL,l_devl_project_id);

4498: END IF;
4499: */
4500: /*
4501: l_priv := cz_security_pvt.has_privileges (1.0,
4502: l_user_name ,cz_security_pvt.LOCK_MODEL_FUNC,cz_security_pvt.MODEL,l_devl_project_id);
4503: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN
4504: RAISE NO_PRIV_EXCP;
4505: END IF;
4506: */

Line 4503: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN

4499: */
4500: /*
4501: l_priv := cz_security_pvt.has_privileges (1.0,
4502: l_user_name ,cz_security_pvt.LOCK_MODEL_FUNC,cz_security_pvt.MODEL,l_devl_project_id);
4503: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN
4504: RAISE NO_PRIV_EXCP;
4505: END IF;
4506: */
4507:

Line 4665: l_priv := cz_security_pvt.has_model_privileges(p_model_id,'PRJ');

4661:
4662: -------------------------------------
4663: -- check for user privs on this model
4664: -------------------------------------
4665: l_priv := cz_security_pvt.has_model_privileges(p_model_id,'PRJ');
4666: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN
4667: RAISE NO_PRIV;
4668: ELSIF (l_priv = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4669: RAISE UNEXPECTED_ERROR;

Line 4666: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN

4662: -------------------------------------
4663: -- check for user privs on this model
4664: -------------------------------------
4665: l_priv := cz_security_pvt.has_model_privileges(p_model_id,'PRJ');
4666: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN
4667: RAISE NO_PRIV;
4668: ELSIF (l_priv = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4669: RAISE UNEXPECTED_ERROR;
4670: END IF;

Line 4770: p_error_message => ' unexpected error in cz_security_pvt.has_model_privileges()',

4766: x_msg_count => x_msg_count,
4767: x_msg_data => x_msg_data);
4768: WHEN UNEXPECTED_ERROR THEN
4769: handle_Error(p_procedure_name => 'is_model_deleteable',
4770: p_error_message => ' unexpected error in cz_security_pvt.has_model_privileges()',
4771: x_return_status => x_return_status,
4772: x_msg_count => x_msg_count,
4773: x_msg_data => x_msg_data);
4774: WHEN OTHERS THEN

Line 4788: l_locked_model_tbl cz_security_pvt.number_type_tbl;

4784: ,x_msg_count OUT NOCOPY NUMBER
4785: ,x_msg_data OUT NOCOPY VARCHAR2)
4786: IS
4787: LOCK_MODEL_EXCP EXCEPTION;
4788: l_locked_model_tbl cz_security_pvt.number_type_tbl;
4789: BEGIN
4790:
4791: FND_MSG_PUB.initialize;
4792:

Line 4797: cz_security_pvt.lock_model(

4793: is_model_deleteable(p_model_id, x_return_status, x_msg_count, x_msg_data);
4794:
4795: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4796:
4797: cz_security_pvt.lock_model(
4798: p_api_version => 1.0,
4799: p_model_id => p_model_id,
4800: p_lock_child_models => FND_API.G_FALSE,
4801: p_commit_flag => FND_API.G_FALSE,

Line 5947: l_templates cz_security_pvt.number_type_tbl;

5943: l_old_main_message_id NUMBER;
5944: l_index NUMBER;
5945: l_template_type NUMBER;
5946: l_template_name cz_ui_templates.template_name%TYPE;
5947: l_templates cz_security_pvt.number_type_tbl;
5948: l_locked_templates cz_security_pvt.number_type_tbl;
5949: l_return_status VARCHAR2(1);
5950: l_msg_count NUMBER;
5951: l_msg_data VARCHAR2(2000);

Line 5948: l_locked_templates cz_security_pvt.number_type_tbl;

5944: l_index NUMBER;
5945: l_template_type NUMBER;
5946: l_template_name cz_ui_templates.template_name%TYPE;
5947: l_templates cz_security_pvt.number_type_tbl;
5948: l_locked_templates cz_security_pvt.number_type_tbl;
5949: l_return_status VARCHAR2(1);
5950: l_msg_count NUMBER;
5951: l_msg_data VARCHAR2(2000);
5952: FAILED_TO_LOCK_UCT EXCEPTION;

Line 5961: cz_security_pvt.lock_template(

5957: FROM CZ_UI_TEMPLATES
5958: WHERE ui_def_id=0 AND template_id=p_template_id;
5959:
5960: l_templates(1) := p_template_id;
5961: cz_security_pvt.lock_template(
5962: p_api_version => 1.0,
5963: p_templates_to_lock => l_templates,
5964: p_commit_flag => FND_API.G_FALSE,
5965: p_init_msg_list => FND_API.G_FALSE,

Line 6123: cz_security_pvt.unlock_template(

6119: IF SQL%ROWCOUNT = 0 THEN
6120: RAISE INVALID_TEMPLATE_ID_EXCP;
6121: END IF;
6122: IF ( l_locked_templates.COUNT > 0 ) THEN
6123: cz_security_pvt.unlock_template(
6124: p_api_version => 1.0,
6125: p_templates_to_unlock => l_locked_templates,
6126: p_commit_flag => FND_API.G_FALSE,
6127: p_init_msg_list => FND_API.G_FALSE,

Line 6155: cz_security_pvt.unlock_template(p_api_version => 1.0,

6151: x_return_status => x_return_status,
6152: x_msg_count => x_msg_count,
6153: x_msg_data => x_msg_data);
6154: IF ( l_locked_templates.COUNT > 0 ) THEN
6155: cz_security_pvt.unlock_template(p_api_version => 1.0,
6156: p_templates_to_unlock => l_locked_templates,
6157: p_commit_flag => FND_API.G_FALSE,
6158: p_init_msg_list => FND_API.G_FALSE,
6159: x_return_status => l_return_status,

Line 7125: cz_security_pvt.lock_template(

7121:
7122: is_uct_deleteable(p_uct_id,l_return_status,l_msg_count,l_msg_data);
7123: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7124: --Added: smanna: Check if template is lockable before delete like any other entity
7125: cz_security_pvt.lock_template(
7126: p_api_version => 1.0,
7127: p_template_id => p_uct_id,
7128: p_commit_flag => FND_API.G_FALSE,
7129: p_init_msg_list => FND_API.G_FALSE,

Line 8417: l_locked_models_tbl cz_security_pvt.number_type_tbl;

8413: TYPE object_type_tbl IS TABLE OF VARCHAR2(3) INDEX BY BINARY_INTEGER;
8414: l_rp_fld_tbl number_type_tbl;
8415: l_object_id_tbl number_type_tbl;
8416: l_object_typ_tbl object_type_tbl;
8417: l_locked_models_tbl cz_security_pvt.number_type_tbl;
8418: l_model_name cz_devl_projects.name%TYPE;
8419: l_template_name cz_ui_templates.template_name%TYPE;
8420: l_count NUMBER := 0;
8421: