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 854: dbms_lock.allocate_unique(G_LOCK_NAME,G_LOCKHNDL,timeout);

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

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

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