DBA Data[Home] [Help]

APPS.MSC_LAUNCH_PLAN_PK dependencies on APP_EXCEPTION

Line 1645: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN

1641: SET VALUE=p_temp_plan_id
1642: WHERE ROWID=l_rowlist(I);
1643: EXIT;
1644: EXCEPTION
1645: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
1646: IF c_pref%ISOPEN THEN
1647: CLOSE c_pref;
1648: END IF;
1649: IF l_Counter > l_max_tries THEN

Line 1683: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN

1679: SET input_schedule_id = v_temp_desig_cur.designator_id
1680: WHERE ROWID=l_rowlist(I);
1681: EXIT;
1682: EXCEPTION
1683: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
1684: IF c_pref%ISOPEN THEN
1685: CLOSE c_pref;
1686: END IF;
1687: IF l_Counter > l_max_tries THEN

Line 2255: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN

2251: MSC_UTIL.msc_Debug('Debug Only: Updated child plans...'||l_rowlist.count);
2252: EXIT;
2253:
2254: EXCEPTION
2255: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
2256: IF c_lock_child_plans%ISOPEN THEN
2257: CLOSE c_lock_child_plans;
2258: END IF;
2259: IF l_Counter > l_max_tries THEN

Line 2368: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN

2364: CLOSE c_get_designator;
2365:
2366: EXIT;
2367: EXCEPTION
2368: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
2369: IF c_lock_plan_row%ISOPEN THEN
2370: CLOSE c_lock_plan_row;
2371: END IF;
2372: IF l_Counter > l_max_tries THEN