[Home] [Help]
166: FND_MSG_PUB.Add;
167: RAISE FND_API.G_EXC_ERROR;
168: end;
169:
170: select eam_pm_schedulings_s.nextval into l_pm_schedule_id from dual;
171:
172: -- If the source pm is not a template, raise error
173: if (not (pm_header_row.tmpl_flag = 'Y')) then
174: FND_MESSAGE.SET_NAME('EAM', 'EAM_PM_INST_NOT_TMPL');
849: FND_MSG_PUB.Add;
850: RAISE FND_API.G_EXC_ERROR;
851: END IF;
852:
853: select eam_pm_schedulings_s.nextval into l_pm_schedule_id from dual;
854:
855:
856: insert into eam_pm_schedulings (
857: PM_SCHEDULE_ID,
1409: end if;
1410: n:=1;
1411: while (l_current_rules_tbl.exists(n)) loop
1412:
1413: select eam_pm_scheduling_rules_s.nextval into l_rule_id from dual; --Bug#5453536
1414:
1415: insert into eam_pm_scheduling_rules
1416: ( rule_id,
1417: PM_SCHEDULE_ID,
1806:
1807:
1808: -- validate that the meter id is valid
1809: --added for perofrmance issues
1810: select 1 into l_count from dual where exists
1811: (select COUNTER_ID from CSI_COUNTERS_B where counter_id = p_pm_rule_rec.meter_id
1812: union
1813: select COUNTER_ID from CSI_COUNTER_TEMPLATE_B where counter_id = p_pm_rule_rec.meter_id) ;
1814:
1910: begin
1911: -- validate each day interval rule
1912:
1913: -- Go through the table one by one,
1914: -- validate each rule individually
1915: -- pick out the one(s) without effective_from or effective_date_to
1916: -- make sure that there can be at most one w/o effective_from_date and at most one w/o effective_date_to,
1917: --and copy the rest to another table.
1918: