156: open c1;
157: fetch c1 into sugg_rec;
158: if (c1%NOTFOUND) then
159: close c1;
160: fnd_message.set_name('EAM', 'EAM_FORECAST_DELETED');
161: raise NO_DATA_FOUND;
162: end if;
163:
164: select decode(eps.RESCHEDULING_POINT,6,epr.meter_id ,null) into l_base_meter_id
257: l_eam_wo_tbl(i).rebuild_item_id := sugg_rec.inventory_item_id;
258: end if;
259:
260: else
261: fnd_message.set_name('EAM', 'EAM_FORECAST_DELETED');
262: raise NO_DATA_FOUND;
263: end if;
264:
265: -- common fields for all operations
691: open c1;
692: fetch c1 into l_old_flag;
693: if (c1%NOTFOUND) then
694: close c1;
695: fnd_message.set_name('EAM', 'EAM_FORECAST_DELETED');
696: raise NO_DATA_FOUND;
697: end if;
698: close c1;
699:
1006: IF (l_err_occured='Y' OR l_msg_count>0) THEN
1007: IF (l_msg_count>0) THEN
1008: eam_workorder_pkg.get_all_mesg(mesg=>l_message_text);
1009: END IF;
1010: fnd_message.set_name('EAM','EAM_WO_NOT_COMPLETED');
1011: fnd_message.set_token(token => 'MESG',
1012: value => l_message_text,
1013: translate => FALSE);
1014: APP_EXCEPTION.RAISE_EXCEPTION;
1007: IF (l_msg_count>0) THEN
1008: eam_workorder_pkg.get_all_mesg(mesg=>l_message_text);
1009: END IF;
1010: fnd_message.set_name('EAM','EAM_WO_NOT_COMPLETED');
1011: fnd_message.set_token(token => 'MESG',
1012: value => l_message_text,
1013: translate => FALSE);
1014: APP_EXCEPTION.RAISE_EXCEPTION;
1015: END IF ;
1245: IF (l_err_occured='Y' OR l_msg_count>0) THEN
1246: IF (l_msg_count>0) THEN
1247: eam_workorder_pkg.get_all_mesg(mesg=>l_message_text);
1248: END IF;
1249: fnd_message.set_name('EAM','EAM_WO_NOT_RELEASED');
1250: fnd_message.set_token(token => 'MESG',
1251: value => l_message_text,
1252: translate => FALSE);
1253: APP_EXCEPTION.RAISE_EXCEPTION;
1246: IF (l_msg_count>0) THEN
1247: eam_workorder_pkg.get_all_mesg(mesg=>l_message_text);
1248: END IF;
1249: fnd_message.set_name('EAM','EAM_WO_NOT_RELEASED');
1250: fnd_message.set_token(token => 'MESG',
1251: value => l_message_text,
1252: translate => FALSE);
1253: APP_EXCEPTION.RAISE_EXCEPTION;
1254: END IF ;