DBA Data[Home] [Help]

APPS.MSD_APPLY_TEMPLATE_DEMAND_PLAN dependencies on FND_MESSAGE

Line 959: fnd_message.set_name('MSD',c1_cur.scenario_name);

955: for c1_cur in c1 loop
956:
957:
958:
959: fnd_message.set_name('MSD',c1_cur.scenario_name);
960:
961:
962:
963: update msd_dp_scenarios

Line 965: set scenario_name = fnd_message.get

961:
962:
963: update msd_dp_scenarios
964:
965: set scenario_name = fnd_message.get
966:
967: where demand_plan_id = p_new_dp_id
968:
969: and scenario_id = c1_cur.scenario_id;

Line 973: fnd_message.set_name('MSD',c1_cur.description);

969: and scenario_id = c1_cur.scenario_id;
970:
971:
972:
973: fnd_message.set_name('MSD',c1_cur.description);
974:
975:
976:
977: update msd_dp_scenarios

Line 979: set description = fnd_message.get

975:
976:
977: update msd_dp_scenarios
978:
979: set description = fnd_message.get
980:
981: where demand_plan_id = p_new_dp_id
982:
983: and scenario_id = c1_cur.scenario_id;

Line 987: fnd_message.set_name('MSD',c1_cur.description);

983: and scenario_id = c1_cur.scenario_id;
984:
985:
986:
987: fnd_message.set_name('MSD',c1_cur.description);
988:
989:
990:
991: update msd_dp_scenarios_tl

Line 993: set description = fnd_message.get

989:
990:
991: update msd_dp_scenarios_tl
992:
993: set description = fnd_message.get
994:
995: where demand_plan_id = p_new_dp_id
996:
997: and scenario_id = c1_cur.scenario_id;

Line 1198: fnd_message.set_name('MSD','MSD_SIM_DEMAND_DEP_DEM_DESC');

1194: and parameter_type='MSD_FORECAST_BASIS_LIAB')
1195: where demand_plan_id=p_new_dp_id
1196: and parameter_type='MSD_SIM_END_ITEM_DEMAND'; */
1197:
1198: fnd_message.set_name('MSD','MSD_SIM_DEMAND_DEP_DEM_DESC');
1199: update msd_dp_parameters
1200: set dependent_demand_desc = fnd_message.get
1201: where demand_plan_id=p_new_dp_id
1202: and parameter_type='MSD_SIM_END_ITEM_DEMAND';

Line 1200: set dependent_demand_desc = fnd_message.get

1196: and parameter_type='MSD_SIM_END_ITEM_DEMAND'; */
1197:
1198: fnd_message.set_name('MSD','MSD_SIM_DEMAND_DEP_DEM_DESC');
1199: update msd_dp_parameters
1200: set dependent_demand_desc = fnd_message.get
1201: where demand_plan_id=p_new_dp_id
1202: and parameter_type='MSD_SIM_END_ITEM_DEMAND';
1203:
1204: end if;

Line 1586: set price_list_name = fnd_message.get_string('MSD',c2_cur.price_list_name)

1582: -- replace message with text
1583:
1584: update msd_dp_parameters
1585:
1586: set price_list_name = fnd_message.get_string('MSD',c2_cur.price_list_name)
1587:
1588: where demand_plan_id = p_new_dp_id
1589:
1590: and parameter_id = c2_cur.parameter_id;

Line 1608: set price_list_name = fnd_message.get_string('MSD',c3_cur.price_list_name)

1604: -- replace message with text
1605:
1606: update msd_dp_scenarios
1607:
1608: set price_list_name = fnd_message.get_string('MSD',c3_cur.price_list_name)
1609:
1610: where demand_plan_id = p_new_dp_id
1611:
1612: and scenario_id = c3_cur.scenario_id;

Line 1630: set price_list_name = fnd_message.get_string('MSD',c4_cur.price_list_name)

1626: -- replace message with text
1627:
1628: update msd_dp_price_lists
1629:
1630: set price_list_name = fnd_message.get_string('MSD',c4_cur.price_list_name)
1631:
1632: where demand_plan_id = p_new_dp_id
1633:
1634: and dp_price_list_id = c4_cur.dp_price_list_id;

Line 1704: --fnd_message.set_name('MSD',c1_cur.formula_desc);

1700: for c1_cur in c1 loop
1701:
1702:
1703:
1704: --fnd_message.set_name('MSD',c1_cur.formula_desc);
1705:
1706:
1707:
1708: -- update the description seeded as message with message text

Line 1712: --set formula_desc = fnd_message.get

1708: -- update the description seeded as message with message text
1709:
1710: update msd_dp_formulas
1711:
1712: --set formula_desc = fnd_message.get
1713:
1714: set formula_desc = fnd_message.get_string('MSD',c1_cur.formula_desc)
1715:
1716: where formula_id = c1_cur.formula_id

Line 1714: set formula_desc = fnd_message.get_string('MSD',c1_cur.formula_desc)

1710: update msd_dp_formulas
1711:
1712: --set formula_desc = fnd_message.get
1713:
1714: set formula_desc = fnd_message.get_string('MSD',c1_cur.formula_desc)
1715:
1716: where formula_id = c1_cur.formula_id
1717:
1718: and demand_plan_id = p_new_dp_id;

Line 1730: --fnd_message.set_name('MSD',c2_cur.description);

1726: for c2_cur in c2 loop
1727:
1728:
1729:
1730: --fnd_message.set_name('MSD',c2_cur.description);
1731:
1732:
1733:
1734: -- update the description seeded as message with message text

Line 1738: --set description = fnd_message.get

1734: -- update the description seeded as message with message text
1735:
1736: update msd_dp_seeded_documents
1737:
1738: --set description = fnd_message.get
1739:
1740: set description = fnd_message.get_string('MSD',c2_cur.description)
1741:
1742: where document_id = c2_cur.document_id

Line 1740: set description = fnd_message.get_string('MSD',c2_cur.description)

1736: update msd_dp_seeded_documents
1737:
1738: --set description = fnd_message.get
1739:
1740: set description = fnd_message.get_string('MSD',c2_cur.description)
1741:
1742: where document_id = c2_cur.document_id
1743:
1744: and demand_plan_id = p_new_dp_id;

Line 5187: fnd_message.set_name('MSD',c2_cur.description);

5183:
5184:
5185:
5186:
5187: fnd_message.set_name('MSD',c2_cur.description);
5188:
5189:
5190:
5191: l_description := fnd_message.get;

Line 5191: l_description := fnd_message.get;

5187: fnd_message.set_name('MSD',c2_cur.description);
5188:
5189:
5190:
5191: l_description := fnd_message.get;
5192:
5193:
5194:
5195:

Line 5197: fnd_message.set_name('MSD',c2_cur.scenario_name);

5193:
5194:
5195:
5196:
5197: fnd_message.set_name('MSD',c2_cur.scenario_name);
5198:
5199:
5200:
5201: -- if there exist scenarios with ascp plan attached then name the new scenario properly replacing 2 with appropriate number

Line 5205: l_name := replace(fnd_message.get,'2',l_count+2);

5201: -- if there exist scenarios with ascp plan attached then name the new scenario properly replacing 2 with appropriate number
5202:
5203: if l_count > 0 then
5204:
5205: l_name := replace(fnd_message.get,'2',l_count+2);
5206:
5207: else
5208:
5209: l_name := fnd_message.get;

Line 5209: l_name := fnd_message.get;

5205: l_name := replace(fnd_message.get,'2',l_count+2);
5206:
5207: else
5208:
5209: l_name := fnd_message.get;
5210:
5211: end if;
5212:
5213:

Line 7821: fnd_message.set_name('MSD',c2_rec.scenario_name);

7817: else
7818: for c2_rec in c2
7819: loop
7820: select msd_dp_scenarios_s.nextval into l_scenario_id from dual;
7821: fnd_message.set_name('MSD',c2_rec.scenario_name);
7822: l_name := fnd_message.get;
7823: fnd_message.set_name('MSD',c2_rec.description);
7824: l_description := fnd_message.get;
7825:

Line 7822: l_name := fnd_message.get;

7818: for c2_rec in c2
7819: loop
7820: select msd_dp_scenarios_s.nextval into l_scenario_id from dual;
7821: fnd_message.set_name('MSD',c2_rec.scenario_name);
7822: l_name := fnd_message.get;
7823: fnd_message.set_name('MSD',c2_rec.description);
7824: l_description := fnd_message.get;
7825:
7826: insert into msd_dp_scenarios

Line 7823: fnd_message.set_name('MSD',c2_rec.description);

7819: loop
7820: select msd_dp_scenarios_s.nextval into l_scenario_id from dual;
7821: fnd_message.set_name('MSD',c2_rec.scenario_name);
7822: l_name := fnd_message.get;
7823: fnd_message.set_name('MSD',c2_rec.description);
7824: l_description := fnd_message.get;
7825:
7826: insert into msd_dp_scenarios
7827: ( demand_plan_id

Line 7824: l_description := fnd_message.get;

7820: select msd_dp_scenarios_s.nextval into l_scenario_id from dual;
7821: fnd_message.set_name('MSD',c2_rec.scenario_name);
7822: l_name := fnd_message.get;
7823: fnd_message.set_name('MSD',c2_rec.description);
7824: l_description := fnd_message.get;
7825:
7826: insert into msd_dp_scenarios
7827: ( demand_plan_id
7828: ,scenario_id