APPS.MSC_CL_PRE_PROCESS dependencies on DBMS_LOCK

Line 22227: dbms_lock.sleep(5);

22223: EXCEPTION
22224: WHEN busy THEN
22225: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_ITEM'||'(' ||v_sql_stmt||')'|| SQLERRM, 1, 240);
22226: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
22227: dbms_lock.sleep(5);
22228: WHEN OTHERS THEN
22229: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_ITEM'||'(' ||v_sql_stmt||')'|| SQLERRM, 1, 240);
22230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
22231:

Line 22260: dbms_lock.sleep(5);

22256: EXCEPTION
22257: WHEN busy THEN
22258: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_ITEM'||'(' ||v_sql_stmt||')'|| SQLERRM, 1, 240);
22259: msc_st_util.log_message(lv_error_text);
22260: dbms_lock.sleep(5);
22261: WHEN OTHERS THEN
22262: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_ITEM'||'(' ||v_sql_stmt||')'|| SQLERRM, 1, 240);
22263: msc_st_util.log_message(lv_error_text);
22264:

Line 34059: dbms_lock.sleep(5);

34055: EXCEPTION
34056: WHEN busy THEN
34057: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_SUPPLY'||'(' ||v_sql_stmt||')'|| SQLERRM, 1, 240);
34058: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
34059: dbms_lock.sleep(5);
34060: WHEN OTHERS THEN
34061: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_SUPPLY'||'(' ||v_sql_stmt||')'|| SQLERRM, 1, 240);
34062: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
34063: v_sql_stmt := 2.0;

Line 35913: dbms_lock.sleep(5);

35909: EXCEPTION
35910: WHEN busy THEN
35911: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_SALES_ORDER'||'('||v_sql_stmt||')'||'p_batch_id :'||p_batch_id|| SQLERRM, 1, 240);
35912: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
35913: dbms_lock.sleep(5);
35914: WHEN OTHERS THEN
35915: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_SALES_ORDER'||'('||v_sql_stmt||')'||'p_batch_id :'||p_batch_id|| SQLERRM, 1, 240);
35916: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
35917:

Line 57875: dbms_lock.sleep(2); -- sleep for 2 seconds and then check again

57871: ELSE
57872:
57873: IF DBMS_PIPE.next_item_type = 0 then
57874:
57875: dbms_lock.sleep(2); -- sleep for 2 seconds and then check again
57876:
57877: ELSE
57878:
57879: DBMS_PIPE.UNPACK_MESSAGE(lv_message);

Line 57904: DBMS_LOCK.SLEEP( 2);

57900: RAISE EX_PIPE_SND;
57901: END IF;
57902:
57903: IF lv_task_status <> OK THEN
57904: DBMS_LOCK.SLEEP( 2);
57905: END IF;
57906:
57907: END IF; -- lv_task_number
57908:

Line 58778: DBMS_LOCK.SLEEP( 5); -- initial estimated sleep time

58774: lv_total_item_batches := lv_total_item_batches + 1;
58775: lv_task_not_completed := lv_task_not_completed + 1;
58776: END IF;
58777:
58778: DBMS_LOCK.SLEEP( 5); -- initial estimated sleep time
58779:
58780: LOOP
58781:
58782: EXIT WHEN is_request_status_running <> SYS_YES;