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

Line 5513: l_locked_templates cz_security_pvt.number_type_tbl;

5509: rec_count NUMBER := 0;
5510: plsql_table_list cz_pb_mgr.col_plsql_table_list;
5511: failed_to_lock_template EXCEPTION;
5512: failed_to_unlock_template EXCEPTION;
5513: l_locked_templates cz_security_pvt.number_type_tbl;
5514: l_templates_to_lock cz_security_pvt.number_type_tbl;
5515: l_return_status VARCHAR2(1);
5516: l_msg_count NUMBER;
5517: l_msg_data VARCHAR2(2000);

Line 5514: l_templates_to_lock cz_security_pvt.number_type_tbl;

5510: plsql_table_list cz_pb_mgr.col_plsql_table_list;
5511: failed_to_lock_template EXCEPTION;
5512: failed_to_unlock_template EXCEPTION;
5513: l_locked_templates cz_security_pvt.number_type_tbl;
5514: l_templates_to_lock cz_security_pvt.number_type_tbl;
5515: l_return_status VARCHAR2(1);
5516: l_msg_count NUMBER;
5517: l_msg_data VARCHAR2(2000);
5518: l_msg_index NUMBER;

Line 5532: cz_security_pvt.lock_pub_template(1.0

5528: -- bug #10417318: Calling the locking procedure as per the multiserver flag.
5529: -- If this flag is true then we need to extend locking for common entity
5530: --If the there is no multi-server flag then will continue with regular locking.
5531: IF (cz_pb_mgr.v_session_parameter = pub_model AND vMultiServerPub = 'YES') THEN
5532: cz_security_pvt.lock_pub_template(1.0
5533: ,l_templates_to_lock
5534: ,fnd_api.g_true
5535: ,fnd_api.g_true
5536: ,cz_pb_mgr.v_server_id

Line 5544: cz_security_pvt.lock_template(1.0

5540: ,l_msg_count
5541: ,l_msg_data
5542: );
5543: ELSE
5544: cz_security_pvt.lock_template(1.0
5545: ,l_templates_to_lock
5546: ,fnd_api.g_true
5547: ,fnd_api.g_true
5548: ,l_locked_templates

Line 5660: cz_security_pvt.unlock_pub_template(1.0, l_locked_templates, fnd_api.g_true, fnd_api.g_true, cz_pb_mgr.v_publication_id, l_return_status, l_msg_count, l_msg_data);

5656: -- END IF;
5657:
5658: -- bug #10417318
5659: IF (cz_pb_mgr.v_session_parameter = pub_model AND vMultiServerPub = 'YES') THEN
5660: cz_security_pvt.unlock_pub_template(1.0, l_locked_templates, fnd_api.g_true, fnd_api.g_true, cz_pb_mgr.v_publication_id, l_return_status, l_msg_count, l_msg_data);
5661: ELSE
5662: cz_security_pvt.unlock_template(1.0, l_locked_templates, fnd_api.g_true, fnd_api.g_true, l_return_status, l_msg_count, l_msg_data);
5663: END IF;
5664:

Line 5662: cz_security_pvt.unlock_template(1.0, l_locked_templates, fnd_api.g_true, fnd_api.g_true, l_return_status, l_msg_count, l_msg_data);

5658: -- bug #10417318
5659: IF (cz_pb_mgr.v_session_parameter = pub_model AND vMultiServerPub = 'YES') THEN
5660: cz_security_pvt.unlock_pub_template(1.0, l_locked_templates, fnd_api.g_true, fnd_api.g_true, cz_pb_mgr.v_publication_id, l_return_status, l_msg_count, l_msg_data);
5661: ELSE
5662: cz_security_pvt.unlock_template(1.0, l_locked_templates, fnd_api.g_true, fnd_api.g_true, l_return_status, l_msg_count, l_msg_data);
5663: END IF;
5664:
5665: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
5666: THEN

Line 5685: cz_security_pvt.unlock_pub_template(1.0, l_locked_templates, fnd_api.g_true, fnd_api.g_true, cz_pb_mgr.v_publication_id, l_return_status, l_msg_count, l_msg_data);

5681: END LOOP;
5682:
5683: -- bug #10417318
5684: IF (cz_pb_mgr.v_session_parameter = pub_model AND vMultiServerPub = 'YES') THEN
5685: cz_security_pvt.unlock_pub_template(1.0, l_locked_templates, fnd_api.g_true, fnd_api.g_true, cz_pb_mgr.v_publication_id, l_return_status, l_msg_count, l_msg_data);
5686: ELSE
5687: cz_security_pvt.unlock_template(1.0, l_locked_templates, fnd_api.g_true, fnd_api.g_true, l_return_status, l_msg_count, l_msg_data);
5688: END IF;
5689:

Line 5687: cz_security_pvt.unlock_template(1.0, l_locked_templates, fnd_api.g_true, fnd_api.g_true, l_return_status, l_msg_count, l_msg_data);

5683: -- bug #10417318
5684: IF (cz_pb_mgr.v_session_parameter = pub_model AND vMultiServerPub = 'YES') THEN
5685: cz_security_pvt.unlock_pub_template(1.0, l_locked_templates, fnd_api.g_true, fnd_api.g_true, cz_pb_mgr.v_publication_id, l_return_status, l_msg_count, l_msg_data);
5686: ELSE
5687: cz_security_pvt.unlock_template(1.0, l_locked_templates, fnd_api.g_true, fnd_api.g_true, l_return_status, l_msg_count, l_msg_data);
5688: END IF;
5689:
5690: raise_application_error('-20020', 'FAILED_TO_LOCK_TEMPLATE');
5691: WHEN failed_to_unlock_template

Line 5709: cz_security_pvt.unlock_pub_template(1.0, l_locked_templates, fnd_api.g_true, fnd_api.g_true, cz_pb_mgr.v_publication_id, l_return_status, l_msg_count, l_msg_data);

5705: WHEN OTHERS
5706: THEN
5707: -- bug #10417318
5708: IF (cz_pb_mgr.v_session_parameter = pub_model AND vMultiServerPub = 'YES') THEN
5709: cz_security_pvt.unlock_pub_template(1.0, l_locked_templates, fnd_api.g_true, fnd_api.g_true, cz_pb_mgr.v_publication_id, l_return_status, l_msg_count, l_msg_data);
5710: ELSE
5711: cz_security_pvt.unlock_template(1.0, l_locked_templates, fnd_api.g_true, fnd_api.g_true, l_return_status, l_msg_count, l_msg_data);
5712: END IF;
5713:

Line 5711: cz_security_pvt.unlock_template(1.0, l_locked_templates, fnd_api.g_true, fnd_api.g_true, l_return_status, l_msg_count, l_msg_data);

5707: -- bug #10417318
5708: IF (cz_pb_mgr.v_session_parameter = pub_model AND vMultiServerPub = 'YES') THEN
5709: cz_security_pvt.unlock_pub_template(1.0, l_locked_templates, fnd_api.g_true, fnd_api.g_true, cz_pb_mgr.v_publication_id, l_return_status, l_msg_count, l_msg_data);
5710: ELSE
5711: cz_security_pvt.unlock_template(1.0, l_locked_templates, fnd_api.g_true, fnd_api.g_true, l_return_status, l_msg_count, l_msg_data);
5712: END IF;
5713:
5714: RAISE;
5715: END insert_ui_templates;

Line 18632: l_locked_models cz_security_pvt.number_type_tbl;

18628: l_msg_data VARCHAR2(2000);
18629: l_msg_count NUMBER := 0;
18630: l_return_status VARCHAR2(1);
18631: l_lock_status VARCHAR2(1);
18632: l_locked_models cz_security_pvt.number_type_tbl;
18633: l_checkout_user cz_security_pvt.varchar_type_tbl;
18634: l_model_upto_date_status NUMBER;
18635: l_ui_upto_date_status NUMBER;
18636: l_model_upto_date_msg VARCHAR2(2000);

Line 18633: l_checkout_user cz_security_pvt.varchar_type_tbl;

18629: l_msg_count NUMBER := 0;
18630: l_return_status VARCHAR2(1);
18631: l_lock_status VARCHAR2(1);
18632: l_locked_models cz_security_pvt.number_type_tbl;
18633: l_checkout_user cz_security_pvt.varchar_type_tbl;
18634: l_model_upto_date_status NUMBER;
18635: l_ui_upto_date_status NUMBER;
18636: l_model_upto_date_msg VARCHAR2(2000);
18637: logic_gen_required CONSTANT NUMBER := 1;

Line 18673: cz_security_pvt.lock_model(1.0, p_model_id, fnd_api.g_true, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);

18669: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_SEQ_XFR');
18670: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.XFRINFO', SQLCODE);
18671: END;
18672:
18673: cz_security_pvt.lock_model(1.0, p_model_id, fnd_api.g_true, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
18674:
18675: IF (l_lock_status <> FND_API.G_RET_STS_SUCCESS)
18676: THEN
18677: l_msg_index := 1;

Line 19267: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);

19263: DELETE FROM cz_pb_model_exports
19264: WHERE publication_id = v_pub_id;
19265: END IF;
19266:
19267: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
19268:
19269: IF (l_lock_status <> FND_API.G_RET_STS_SUCCESS)
19270: THEN
19271: l_msg_index := 1;

Line 19287: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);

19283: WHEN failed_to_lock_model
19284: THEN
19285: x_run_id := cz_pb_mgr.v_pb_run_id;
19286: x_status := PUBLICATION_ERROR;
19287: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
19288: log_pb_trace;
19289: WHEN ui_not_uptodate THEN
19290: x_run_id := cz_pb_mgr.v_pb_run_id;
19291: x_status := PUBLICATION_ERROR;

Line 19292: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);

19288: log_pb_trace;
19289: WHEN ui_not_uptodate THEN
19290: x_run_id := cz_pb_mgr.v_pb_run_id;
19291: x_status := PUBLICATION_ERROR;
19292: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
19293: log_pb_trace;
19294: WHEN OTHERS
19295: THEN
19296: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);

Line 19296: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);

19292: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
19293: log_pb_trace;
19294: WHEN OTHERS
19295: THEN
19296: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
19297: cz_pb_mgr.v_err_message := 'Fatal error during deep model copy of model: ' || cz_pb_mgr.v_root_model_id;
19298: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODELCOPY', SQLCODE);
19299: END;
19300:

Line 20002: l_locked_models cz_security_pvt.number_type_tbl;

19998: v_rp_entries_desc cz_rp_entries.description%TYPE;
19999: v_object_id cz_rp_entries.object_id%TYPE;
20000: v_rp_orig_sys_ref VARCHAR2(255);
20001: v_imp_ps_node_count PLS_INTEGER;
20002: l_locked_models cz_security_pvt.number_type_tbl;
20003: l_upto_date_status VARCHAR2(2000);
20004: l_msg_index NUMBER;
20005: v_max_rec_id NUMBER;
20006: l_message VARCHAR2(32000);

Line 20215: cz_security_pvt.lock_pub_model(1.0

20211: END IF;
20212:
20213: -- bug #10417318
20214: IF (cz_pb_mgr.v_session_parameter = pub_model AND vMultiServerPub = 'YES') THEN
20215: cz_security_pvt.lock_pub_model(1.0
20216: ,cz_pb_mgr.v_root_model_id
20217: ,fnd_api.g_true
20218: ,fnd_api.g_true
20219: ,fnd_api.g_false

Line 20228: cz_security_pvt.lock_model(1.0

20224: ,l_msg_count
20225: ,l_msg_data
20226: );
20227: ELSE
20228: cz_security_pvt.lock_model(1.0
20229: ,cz_pb_mgr.v_root_model_id
20230: ,fnd_api.g_true
20231: ,fnd_api.g_true
20232: ,l_locked_models

Line 20762: cz_security_pvt.unlock_pub_model(1.0, fnd_api.g_true, l_locked_models, fnd_api.g_false, cz_pb_mgr.v_publication_id, l_lock_status, l_msg_count, l_msg_data );

20758: l_msg_index := 0;
20759:
20760: -- bug #10417318
20761: IF (cz_pb_mgr.v_session_parameter = pub_model AND vMultiServerPub = 'YES') THEN
20762: cz_security_pvt.unlock_pub_model(1.0, fnd_api.g_true, l_locked_models, fnd_api.g_false, cz_pb_mgr.v_publication_id, l_lock_status, l_msg_count, l_msg_data );
20763: ELSE
20764: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
20765: END IF;
20766:

Line 20764: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);

20760: -- bug #10417318
20761: IF (cz_pb_mgr.v_session_parameter = pub_model AND vMultiServerPub = 'YES') THEN
20762: cz_security_pvt.unlock_pub_model(1.0, fnd_api.g_true, l_locked_models, fnd_api.g_false, cz_pb_mgr.v_publication_id, l_lock_status, l_msg_count, l_msg_data );
20763: ELSE
20764: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
20765: END IF;
20766:
20767: IF (l_lock_status <> 'S') THEN
20768: l_msg_index := 1;

Line 20786: /* cz_security_pvt.unlock_entity (cz_pb_mgr.v_root_model_id,

20782: END IF;
20783:
20784: x_run_id := cz_pb_mgr.v_pb_run_id;
20785: x_pb_status := cz_pb_mgr.v_status_code;
20786: /* cz_security_pvt.unlock_entity (cz_pb_mgr.v_root_model_id,
20787: cz_security_pvt.PUBLISH_MODEL_FUNCTION,
20788: l_locked_models,
20789: l_lock_status,
20790: l_msg_count,

Line 20787: cz_security_pvt.PUBLISH_MODEL_FUNCTION,

20783:
20784: x_run_id := cz_pb_mgr.v_pb_run_id;
20785: x_pb_status := cz_pb_mgr.v_status_code;
20786: /* cz_security_pvt.unlock_entity (cz_pb_mgr.v_root_model_id,
20787: cz_security_pvt.PUBLISH_MODEL_FUNCTION,
20788: l_locked_models,
20789: l_lock_status,
20790: l_msg_count,
20791: l_msg_data); */

Line 20833: cz_security_pvt.unlock_pub_model(1.0, fnd_api.g_true, l_locked_models, fnd_api.g_false, publicationid, l_lock_status, l_msg_count, l_msg_data );

20829: update_publication_status(publicationid, PUBLICATION_ERROR, empty_string);
20830: update_pup_status(publicationid);
20831: -- bug #10417318
20832: IF (cz_pb_mgr.v_session_parameter = pub_model AND vMultiServerPub = 'YES') THEN
20833: cz_security_pvt.unlock_pub_model(1.0, fnd_api.g_true, l_locked_models, fnd_api.g_false, publicationid, l_lock_status, l_msg_count, l_msg_data );
20834: ELSE
20835: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
20836: END IF;
20837: log_pb_trace;

Line 20835: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);

20831: -- bug #10417318
20832: IF (cz_pb_mgr.v_session_parameter = pub_model AND vMultiServerPub = 'YES') THEN
20833: cz_security_pvt.unlock_pub_model(1.0, fnd_api.g_true, l_locked_models, fnd_api.g_false, publicationid, l_lock_status, l_msg_count, l_msg_data );
20834: ELSE
20835: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
20836: END IF;
20837: log_pb_trace;
20838: delete_session_parameters;
20839: WHEN not_global_template THEN