DBA Data[Home] [Help]

APPS.PA_FORECAST_ITEMS_GEN_WF_PKG dependencies on PA_FORECAST_ITEMS_UTILS

Line 49: IF (PA_FORECAST_ITEMS_UTILS.Set_User_Lock (p_assignment_id,l_lock_for) <> 0) THEN

45:
46: -- User lock for the given assignment id
47: /* l_lock_for := 'ASGMT'; Fixed bug#1612856
48: IF ( NVL(p_assignment_id,0) <> 0 ) THEN
49: IF (PA_FORECAST_ITEMS_UTILS.Set_User_Lock (p_assignment_id,l_lock_for) <> 0) THEN
50: RAISE l_cannot_acquire_lock;
51: END IF;
52: END IF; */
53:

Line 272: PA_FORECAST_ITEMS_UTILS.log_message('Unable to set lock for ' || to_char(p_assignment_id));

268: --Setting the original value
269: wf_engine.threshold := l_save_thresh;
270: EXCEPTION
271: WHEN l_cannot_acquire_lock THEN
272: PA_FORECAST_ITEMS_UTILS.log_message('Unable to set lock for ' || to_char(p_assignment_id));
273: x_return_status := FND_API.G_RET_STS_ERROR;
274:
275: -- COMMIT;
276: END Launch_WorkFlow_Fi_Gen;

Line 347: IF (PA_FORECAST_ITEMS_UTILS.Set_User_Lock (l_assignment_id,l_lock_for) <> 0) THEN

343:
344: -- DBMS_OUTPUT.PUT_LINE('4');
345:
346: IF ( NVL(l_assignment_id,0) <> 0 ) THEN
347: IF (PA_FORECAST_ITEMS_UTILS.Set_User_Lock (l_assignment_id,l_lock_for) <> 0) THEN
348: RAISE l_cannot_acquire_lock;
349: END IF;
350:
351: SAVEPOINT l_forecast_item_gen;

Line 410: PA_FORECAST_ITEMS_UTILS.log_message('Unable to set lock for ' || to_char(l_assignment_id));

406: -- p_result := 'COMPLETE:S';
407:
408: EXCEPTION
409: WHEN l_cannot_acquire_lock THEN
410: PA_FORECAST_ITEMS_UTILS.log_message('Unable to set lock for ' || to_char(l_assignment_id));
411: END;
412:
413: ELSIF ( p_funcmode = 'CANCEL' ) THEN
414: