DBA Data[Home] [Help]

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: --bug fix 8689041 Modified the criteria to retrieve last_logic_update and logic creation_date

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

11181: FORALL i IN 1..NewHeaders.COUNT
11182: UPDATE cz_lce_load_specs SET deleted_flag = FLAG_NOT_DELETED
11183: WHERE lce_header_id = NewHeaders(i);
11184:
11185: cz_security_pvt.unlock_model(1.0, FND_API.G_TRUE, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
11186:
11187: IF(l_lock_status <> FND_API.G_RET_STS_SUCCESS)THEN
11188: FOR jmessage IN 1..l_msg_count LOOP
11189: REPORT(fnd_msg_pub.get(jmessage, FND_API.G_FALSE), 0);

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

11183: WHERE lce_header_id = NewHeaders(i);
11184:
11185: cz_security_pvt.unlock_model(1.0, FND_API.G_TRUE, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
11186:
11187: IF(l_lock_status <> FND_API.G_RET_STS_SUCCESS)THEN
11188: FOR jmessage IN 1..l_msg_count LOOP
11189: REPORT(fnd_msg_pub.get(jmessage, FND_API.G_FALSE), 0);
11190: END LOOP;
11191: END IF;

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

11185: cz_security_pvt.unlock_model(1.0, FND_API.G_TRUE, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
11186:
11187: IF(l_lock_status <> FND_API.G_RET_STS_SUCCESS)THEN
11188: FOR jmessage IN 1..l_msg_count LOOP
11189: REPORT(fnd_msg_pub.get(jmessage, FND_API.G_FALSE), 0);
11190: END LOOP;
11191: END IF;
11192:
11193: IF(TwoPhaseCommit = 0)THEN COMMIT; END IF;

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

11214: UPDATE cz_lce_load_specs SET deleted_flag = FLAG_NOT_DELETED
11215: WHERE lce_header_id = OldHeaders(i);
11216: END IF;
11217:
11218: cz_security_pvt.unlock_model(1.0, FND_API.G_TRUE, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
11219:
11220: IF(l_lock_status <> FND_API.G_RET_STS_SUCCESS)THEN
11221: FOR jmessage IN 1..l_msg_count LOOP
11222: REPORT(fnd_msg_pub.get(jmessage, FND_API.G_FALSE), 0);

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

11216: END IF;
11217:
11218: cz_security_pvt.unlock_model(1.0, FND_API.G_TRUE, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
11219:
11220: IF(l_lock_status <> FND_API.G_RET_STS_SUCCESS)THEN
11221: FOR jmessage IN 1..l_msg_count LOOP
11222: REPORT(fnd_msg_pub.get(jmessage, FND_API.G_FALSE), 0);
11223: END LOOP;
11224: END IF;

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

11218: cz_security_pvt.unlock_model(1.0, FND_API.G_TRUE, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
11219:
11220: IF(l_lock_status <> FND_API.G_RET_STS_SUCCESS)THEN
11221: FOR jmessage IN 1..l_msg_count LOOP
11222: REPORT(fnd_msg_pub.get(jmessage, FND_API.G_FALSE), 0);
11223: END LOOP;
11224: END IF;
11225:
11226: IF(TwoPhaseCommit = 0)THEN COMMIT; END IF;

Line 11451: 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);

11447:
11448: BEGIN
11449:
11450: l_locked_models.DELETE;
11451: 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);
11452:
11453: IF(l_lock_status <> FND_API.G_RET_STS_SUCCESS)THEN
11454: RAISE FAILED_TO_LOCK_MODEL;
11455: END IF;

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

11449:
11450: l_locked_models.DELETE;
11451: 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);
11452:
11453: IF(l_lock_status <> FND_API.G_RET_STS_SUCCESS)THEN
11454: RAISE FAILED_TO_LOCK_MODEL;
11455: END IF;
11456:
11457: --To disable this functionality, comment out the following IF block. Previously, we

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

11490: EXCEPTION
11491: WHEN FAILED_TO_LOCK_MODEL THEN
11492:
11493: FOR jmessage IN 1..l_msg_count LOOP
11494: REPORT(fnd_msg_pub.get(jmessage, FND_API.G_FALSE), 0);
11495: END LOOP;
11496:
11497: ROLLBACK_HEADERS;
11498: WHEN OTHERS THEN