APPS.MSC_RP_PUB dependencies on APP_EXCEPTION

Line 336: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN

332: where criteria_id= l_criteria_id;
333: rp_Debug(l_counter || ' -- after attempt to update ');
334: exit;
335: EXCEPTION
336: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
337: rp_Debug(l_counter || ' -- failed attempt to update ');
338: IF l_Counter > l_max_tries THEN
339: rp_Debug('Unable to update criteria table for criteria '||l_criteria_id);
340: rollback to BF_UPD_CRITERIA;

Line 720: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN

716: compute_constraints=1 -- bug14750825
717: where plan_id = rp_id;
718: exit;
719: EXCEPTION
720: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
721: IF l_Counter > l_max_tries THEN
722: rp_Debug('Unable to lock rapid plan rows.');
723: --RAISE;
724: rollback to BF_CP_RP;

Line 752: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN

748: program_id= msc_plan_organization_s.nextval
749: where plan_id = rp_id;
750: exit;
751: EXCEPTION
752: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
753: IF l_Counter > l_max_tries THEN
754: rp_Debug('Unable to lock designator row.');
755: rollback to BF_CP_RP;
756: msc_copy_plan_options.init_plan_id('N',NULL,NULL); --reset copy package variables before exit;

Line 781: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN

777: program_id= msc_plan_organization_s.nextval
778: where plan_id = rp_id;
779: exit;
780: EXCEPTION
781: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
782: IF l_Counter > l_max_tries THEN
783: rp_Debug('Unable to lock plan schedules row.');
784: rollback to BF_CP_RP;
785: msc_copy_plan_options.init_plan_id('N',NULL,NULL); --reset copy package variables before exit;

Line 812: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN

808: copy_Designator_id=null
809: where designator_id = rp_designator_id;
810: exit;
811: EXCEPTION
812: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
813: IF l_Counter > l_max_tries THEN
814: rp_Debug('Unable to lock designator row.');
815: rollback to BF_CP_RP;
816: msc_copy_plan_options.init_plan_id('N',NULL,NULL); --reset copy package variables before exit;

Line 866: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN

862: request_id=request_id1
863: where plan_id = rp_id;
864: exit;
865: EXCEPTION
866: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
867: IF l_Counter > l_max_tries THEN
868: rp_Debug('Unable to update request_id for target rp plan_id'||rp_id);
869: rollback to BF_CALL_CP;
870: return CODE_ERROR;

Line 965: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN

961: where plan_id = rp_id;
962: exit;
963:
964: EXCEPTION
965: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
966: IF l_Counter > l_max_tries THEN
967: rp_Debug('Unable to update request_id for target rp plan_id'||rp_id);
968: rollback to BF_CALL_CP;
969: return CODE_ERROR;

Line 1076: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN

1072: rp_debug('Debug Only: Updated child plans...'||l_rowlist.count);
1073: EXIT;
1074:
1075: EXCEPTION
1076: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
1077: IF c_lock_child_plans%ISOPEN THEN
1078: CLOSE c_lock_child_plans;
1079: END IF;
1080: IF l_Counter > l_max_tries THEN