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_LOGIC_GEN dependencies on FND_API

Line 202: l_lock_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

198: --Set of data for implementing the locking mechanism
199: l_msg_data VARCHAR2(4000);
200: l_msg_count NUMBER := 0;
201: l_return_status VARCHAR2(1);
202: l_lock_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
203: l_locked_models cz_security_pvt.number_type_tbl;
204: FAILED_TO_LOCK_MODEL EXCEPTION;
205:
206: logicSQL VARCHAR2(4000) := 'SELECT proj.devl_project_id, proj.last_logic_update, head.creation_date' ||

Line 11110: cz_security_pvt.unlock_model(1.0, FND_API.G_TRUE, l_locked_models, l_lock_status, l_msg_count, l_msg_data);

11106: FORALL i IN 1..NewHeaders.COUNT
11107: UPDATE cz_lce_load_specs SET deleted_flag = FLAG_NOT_DELETED
11108: WHERE lce_header_id = NewHeaders(i);
11109:
11110: cz_security_pvt.unlock_model(1.0, FND_API.G_TRUE, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
11111:
11112: IF(l_lock_status <> FND_API.G_RET_STS_SUCCESS)THEN
11113: FOR jmessage IN 1..l_msg_count LOOP
11114: REPORT(fnd_msg_pub.get(jmessage, FND_API.G_FALSE), 0);

Line 11112: IF(l_lock_status <> FND_API.G_RET_STS_SUCCESS)THEN

11108: WHERE lce_header_id = NewHeaders(i);
11109:
11110: cz_security_pvt.unlock_model(1.0, FND_API.G_TRUE, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
11111:
11112: IF(l_lock_status <> FND_API.G_RET_STS_SUCCESS)THEN
11113: FOR jmessage IN 1..l_msg_count LOOP
11114: REPORT(fnd_msg_pub.get(jmessage, FND_API.G_FALSE), 0);
11115: END LOOP;
11116: END IF;

Line 11114: REPORT(fnd_msg_pub.get(jmessage, FND_API.G_FALSE), 0);

11110: cz_security_pvt.unlock_model(1.0, FND_API.G_TRUE, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
11111:
11112: IF(l_lock_status <> FND_API.G_RET_STS_SUCCESS)THEN
11113: FOR jmessage IN 1..l_msg_count LOOP
11114: REPORT(fnd_msg_pub.get(jmessage, FND_API.G_FALSE), 0);
11115: END LOOP;
11116: END IF;
11117:
11118: IF(TwoPhaseCommit = 0)THEN COMMIT; END IF;

Line 11143: cz_security_pvt.unlock_model(1.0, FND_API.G_TRUE, l_locked_models, l_lock_status, l_msg_count, l_msg_data);

11139: UPDATE cz_lce_load_specs SET deleted_flag = FLAG_NOT_DELETED
11140: WHERE lce_header_id = OldHeaders(i);
11141: END IF;
11142:
11143: cz_security_pvt.unlock_model(1.0, FND_API.G_TRUE, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
11144:
11145: IF(l_lock_status <> FND_API.G_RET_STS_SUCCESS)THEN
11146: FOR jmessage IN 1..l_msg_count LOOP
11147: REPORT(fnd_msg_pub.get(jmessage, FND_API.G_FALSE), 0);

Line 11145: IF(l_lock_status <> FND_API.G_RET_STS_SUCCESS)THEN

11141: END IF;
11142:
11143: cz_security_pvt.unlock_model(1.0, FND_API.G_TRUE, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
11144:
11145: IF(l_lock_status <> FND_API.G_RET_STS_SUCCESS)THEN
11146: FOR jmessage IN 1..l_msg_count LOOP
11147: REPORT(fnd_msg_pub.get(jmessage, FND_API.G_FALSE), 0);
11148: END LOOP;
11149: END IF;

Line 11147: REPORT(fnd_msg_pub.get(jmessage, FND_API.G_FALSE), 0);

11143: cz_security_pvt.unlock_model(1.0, FND_API.G_TRUE, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
11144:
11145: IF(l_lock_status <> FND_API.G_RET_STS_SUCCESS)THEN
11146: FOR jmessage IN 1..l_msg_count LOOP
11147: REPORT(fnd_msg_pub.get(jmessage, FND_API.G_FALSE), 0);
11148: END LOOP;
11149: END IF;
11150:
11151: IF(TwoPhaseCommit = 0)THEN COMMIT; END IF;

Line 11370: cz_security_pvt.lock_model(1.0, inDevlProjectId, FND_API.G_TRUE, FND_API.G_TRUE, l_locked_models, l_lock_status, l_msg_count, l_msg_data);

11366:
11367: BEGIN
11368:
11369: l_locked_models.DELETE;
11370: cz_security_pvt.lock_model(1.0, inDevlProjectId, FND_API.G_TRUE, FND_API.G_TRUE, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
11371:
11372: IF(l_lock_status <> FND_API.G_RET_STS_SUCCESS)THEN
11373: RAISE FAILED_TO_LOCK_MODEL;
11374: END IF;

Line 11372: IF(l_lock_status <> FND_API.G_RET_STS_SUCCESS)THEN

11368:
11369: l_locked_models.DELETE;
11370: cz_security_pvt.lock_model(1.0, inDevlProjectId, FND_API.G_TRUE, FND_API.G_TRUE, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
11371:
11372: IF(l_lock_status <> FND_API.G_RET_STS_SUCCESS)THEN
11373: RAISE FAILED_TO_LOCK_MODEL;
11374: END IF;
11375:
11376: --To disable this functionality, comment out the following IF block. Previously, we

Line 11413: REPORT(fnd_msg_pub.get(jmessage, FND_API.G_FALSE), 0);

11409: EXCEPTION
11410: WHEN FAILED_TO_LOCK_MODEL THEN
11411:
11412: FOR jmessage IN 1..l_msg_count LOOP
11413: REPORT(fnd_msg_pub.get(jmessage, FND_API.G_FALSE), 0);
11414: END LOOP;
11415:
11416: ROLLBACK_HEADERS;
11417: WHEN OTHERS THEN