168: open c1;
169: fetch c1 into sugg_rec;
170: if (c1%NOTFOUND) then
171: close c1;
172: fnd_message.set_name('EAM', 'EAM_FORECAST_DELETED');
173: raise NO_DATA_FOUND;
174: end if;
175:
176: select decode(eps.RESCHEDULING_POINT,6,epr.meter_id ,null) into l_base_meter_id
294: l_eam_wo_tbl(i).FAILURE_CODE_REQUIRED := NULL;
295: END;
296:
297: else
298: fnd_message.set_name('EAM', 'EAM_FORECAST_DELETED');
299: raise NO_DATA_FOUND;
300: end if;
301:
302: -- common fields for all operations
743: open c1;
744: fetch c1 into l_old_flag;
745: if (c1%NOTFOUND) then
746: close c1;
747: fnd_message.set_name('EAM', 'EAM_FORECAST_DELETED');
748: raise NO_DATA_FOUND;
749: end if;
750: close c1;
751:
1095: IF (l_err_occured='Y' OR l_msg_count>0) THEN
1096: IF (l_msg_count>0) THEN
1097: eam_workorder_pkg.get_all_mesg(mesg=>l_message_text);
1098: END IF;
1099: fnd_message.set_name('EAM','EAM_WO_NOT_COMPLETED');
1100: fnd_message.set_token(token => 'MESG',
1101: value => l_message_text,
1102: translate => FALSE);
1103: APP_EXCEPTION.RAISE_EXCEPTION;
1096: IF (l_msg_count>0) THEN
1097: eam_workorder_pkg.get_all_mesg(mesg=>l_message_text);
1098: END IF;
1099: fnd_message.set_name('EAM','EAM_WO_NOT_COMPLETED');
1100: fnd_message.set_token(token => 'MESG',
1101: value => l_message_text,
1102: translate => FALSE);
1103: APP_EXCEPTION.RAISE_EXCEPTION;
1104: END IF ;
1336: IF (l_err_occured='Y' OR l_msg_count>0) THEN
1337: IF (l_msg_count>0) THEN
1338: eam_workorder_pkg.get_all_mesg(mesg=>l_message_text);
1339: END IF;
1340: fnd_message.set_name('EAM','EAM_WO_NOT_RELEASED');
1341: fnd_message.set_token(token => 'MESG',
1342: value => l_message_text,
1343: translate => FALSE);
1344: APP_EXCEPTION.RAISE_EXCEPTION;
1337: IF (l_msg_count>0) THEN
1338: eam_workorder_pkg.get_all_mesg(mesg=>l_message_text);
1339: END IF;
1340: fnd_message.set_name('EAM','EAM_WO_NOT_RELEASED');
1341: fnd_message.set_token(token => 'MESG',
1342: value => l_message_text,
1343: translate => FALSE);
1344: APP_EXCEPTION.RAISE_EXCEPTION;
1345: END IF ;