APPS.FII_FDHM_PKG dependencies on DBMS_LOCK

Line 414: dbms_lock.allocate_unique( lkname, lkhandle, expiration_secs );

410: -- generate the name for the user-defined lock
411: lkname := 'FND_FLEX_AHE_VS_' || to_char(fdvsid);
412:
413: -- get Oracle-assigned lock handle
414: dbms_lock.allocate_unique( lkname, lkhandle, expiration_secs );
415:
416: -- request a lock, NOT release on commit
417: lkresult := dbms_lock.request( lkhandle, rs_mode, timout, false );
418:

Line 417: lkresult := dbms_lock.request( lkhandle, rs_mode, timout, false );

413: -- get Oracle-assigned lock handle
414: dbms_lock.allocate_unique( lkname, lkhandle, expiration_secs );
415:
416: -- request a lock, NOT release on commit
417: lkresult := dbms_lock.request( lkhandle, rs_mode, timout, false );
418:
419: if ( lkresult = 1 ) then
420: -- Account Hierarchy Editor is locking out value set
421: -- print out appropriate warning message

Line 431: -- fnd_message.set_name('FND', 'FLEX-AHE DBMS_LOCK ERROR');

427: elsif (lkresult <> 0 and lkresult <> 4) then
428: -- lkresult = 0, locking successfully
429: -- lkresult = 4, already own lock
430: release_value_set_lock(dim_short_name, source_lgr_group_id, fdvsid);
431: -- fnd_message.set_name('FND', 'FLEX-AHE DBMS_LOCK ERROR');
432: CLOSE find_dim_value_sets_cur;
433: -- app_exception.raise_exception;
434: RETURN ('FALSE');
435: end if;

Line 483: dbms_lock.allocate_unique( lkname, lkhandle, expiration_secs);

479: CLOSE find_dim_value_sets_cur;
480: RETURN ;
481: ELSE
482: lkname := 'FND_FLEX_AHE_VS_' || to_char(fdvsid);
483: dbms_lock.allocate_unique( lkname, lkhandle, expiration_secs);
484: lkresult := dbms_lock.release(lkhandle);
485:
486: END IF;
487: END LOOP;

Line 484: lkresult := dbms_lock.release(lkhandle);

480: RETURN ;
481: ELSE
482: lkname := 'FND_FLEX_AHE_VS_' || to_char(fdvsid);
483: dbms_lock.allocate_unique( lkname, lkhandle, expiration_secs);
484: lkresult := dbms_lock.release(lkhandle);
485:
486: END IF;
487: END LOOP;
488: CLOSE find_dim_value_sets_cur;

Line 537: dbms_lock.allocate_unique( lkname, lkhandle, expiration_secs );

533: end if;
534: ELSE
535: lkname := 'FND_FLEX_AHE_VS_' || to_char(fdvsid);
536:
537: dbms_lock.allocate_unique( lkname, lkhandle, expiration_secs );
538:
539: lkresult := dbms_lock.release(lkhandle);
540:
541: if (lkresult <> 0 ) then

Line 539: lkresult := dbms_lock.release(lkhandle);

535: lkname := 'FND_FLEX_AHE_VS_' || to_char(fdvsid);
536:
537: dbms_lock.allocate_unique( lkname, lkhandle, expiration_secs );
538:
539: lkresult := dbms_lock.release(lkhandle);
540:
541: if (lkresult <> 0 ) then
542: success := false;
543: end if;