APPS.PAAPIMP_PKG dependencies on DBMS_LOCK

Line 324: result := dbms_lock.release(G_LOCKHNDL);

320:
321: END IF; /* process discounts */
322:
323: G_err_stage := 'RELEASING LOCK HANDLE';
324: result := dbms_lock.release(G_LOCKHNDL);
325:
326: G_err_stage := 'PRINT STAT AND SUBMIT REPORT';
327: print_stat_and_submit_report();
328:

Line 343: result := dbms_lock.release(G_LOCKHNDL);

339: write_log(LOG,'Error occured in stage: ' || G_err_stage || ', PAAPIMP aborted!');
340: write_log(LOG, substr(SQLERRM, 1, 200));
341:
342: IF (G_err_stage <> 'RELEASING LOCK HANDLE') THEN
343: result := dbms_lock.release(G_LOCKHNDL);
344: END IF;
345: print_stat_and_submit_report();
346:
347: /* Here the return value (TRUE/FALSE) is not being

Line 856: dbms_lock.allocate_unique(G_LOCK_NAME,G_LOCKHNDL,timeout);

852: write_log(LOG, G_err_stack);
853: write_log(LOG, '......Trying to allocate for a lock');
854: end if;
855: /* get lock handle for PAAPIMP user lock */
856: dbms_lock.allocate_unique(G_LOCK_NAME,G_LOCKHNDL,timeout);
857:
858: IF (G_LOCKHNDL IS NOT NULL) THEN
859: If g_body_debug_mode = 'Y' Then
860: write_log(LOG, '......Lock created, trying to request for lock.');

Line 866: lstatus := dbms_lock.request(G_LOCKHNDL, lockmode, timeout, lrelease);

862:
863: G_err_stage := 'REQUESTING LOCK';
864:
865: /* Get the lock, do not release the lock on commit */
866: lstatus := dbms_lock.request(G_LOCKHNDL, lockmode, timeout, lrelease);
867:
868: IF ( lstatus = 0 ) then /* Got the lock */
869: G_err_stage := 'CHECKING IF PAAPIMP IS RUNNING';
870: If g_body_debug_mode = 'Y' Then