495:
496: IF p_constr_label THEN
497: -- Constructing the label for demand nodes
498:
499: fnd_message.set_name('MSC','MSC_PEGGING_LABEL2');
500: fnd_message.set_token('ITEM_ORG',Item_org);
501: fnd_message.set_token('QTY',nvl(Qty,0));
502: fnd_message.set_token('PEGGED_QTY',nvl(Pegged_qty,0));
503: fnd_message.set_token('DATE',fnd_date.date_to_chardt(Peg_date));
496: IF p_constr_label THEN
497: -- Constructing the label for demand nodes
498:
499: fnd_message.set_name('MSC','MSC_PEGGING_LABEL2');
500: fnd_message.set_token('ITEM_ORG',Item_org);
501: fnd_message.set_token('QTY',nvl(Qty,0));
502: fnd_message.set_token('PEGGED_QTY',nvl(Pegged_qty,0));
503: fnd_message.set_token('DATE',fnd_date.date_to_chardt(Peg_date));
504:
497: -- Constructing the label for demand nodes
498:
499: fnd_message.set_name('MSC','MSC_PEGGING_LABEL2');
500: fnd_message.set_token('ITEM_ORG',Item_org);
501: fnd_message.set_token('QTY',nvl(Qty,0));
502: fnd_message.set_token('PEGGED_QTY',nvl(Pegged_qty,0));
503: fnd_message.set_token('DATE',fnd_date.date_to_chardt(Peg_date));
504:
505: null;
498:
499: fnd_message.set_name('MSC','MSC_PEGGING_LABEL2');
500: fnd_message.set_token('ITEM_ORG',Item_org);
501: fnd_message.set_token('QTY',nvl(Qty,0));
502: fnd_message.set_token('PEGGED_QTY',nvl(Pegged_qty,0));
503: fnd_message.set_token('DATE',fnd_date.date_to_chardt(Peg_date));
504:
505: null;
506: if p_node_type = 1 then -- Demand
499: fnd_message.set_name('MSC','MSC_PEGGING_LABEL2');
500: fnd_message.set_token('ITEM_ORG',Item_org);
501: fnd_message.set_token('QTY',nvl(Qty,0));
502: fnd_message.set_token('PEGGED_QTY',nvl(Pegged_qty,0));
503: fnd_message.set_token('DATE',fnd_date.date_to_chardt(Peg_date));
504:
505: null;
506: if p_node_type = 1 then -- Demand
507: if ( p_tmp in (6,30) ) then
507: if ( p_tmp in (6,30) ) then
508: -- 6 sales orders mds
509: -- 30 sales order
510: if p_calling_module = 1 then
511: fnd_message.set_token('ORDER_TYPE',Order_name||' '||
512: pvt_so_number);
513: else
514: null;
515: fnd_message.set_token('ORDER_TYPE',Order_name||' '||
511: fnd_message.set_token('ORDER_TYPE',Order_name||' '||
512: pvt_so_number);
513: else
514: null;
515: fnd_message.set_token('ORDER_TYPE',Order_name||' '||
516: pvt_so_number||end_demand_class);
517: end if;
518: elsif ( p_tmp in (8,29) ) then
519: -- 8 manual mds
519: -- 8 manual mds
520: -- 29 forecast
521: if p_calling_module = 1 then
522:
523: fnd_message.set_token('ORDER_TYPE',Order_name||' '||
524: pvt_so_number);
525: else
526:
527: fnd_message.set_token('ORDER_TYPE',Order_name||' '||
523: fnd_message.set_token('ORDER_TYPE',Order_name||' '||
524: pvt_so_number);
525: else
526:
527: fnd_message.set_token('ORDER_TYPE',Order_name||' '||
528: pvt_so_number||end_demand_class);
529: end if;
530:
531: else
528: pvt_so_number||end_demand_class);
529: end if;
530:
531: else
532: fnd_message.set_token('ORDER_TYPE',Order_name);
533: end if;
534: else -- Supply
535: if order_type in ( 1,2,3) THEN
536: fnd_message.set_token('ORDER_TYPE',Order_name||' '||
532: fnd_message.set_token('ORDER_TYPE',Order_name);
533: end if;
534: else -- Supply
535: if order_type in ( 1,2,3) THEN
536: fnd_message.set_token('ORDER_TYPE',Order_name||' '||
537: pvt_so_number);
538: else
539: fnd_message.set_token('ORDER_TYPE',Order_name);
540: end if;
535: if order_type in ( 1,2,3) THEN
536: fnd_message.set_token('ORDER_TYPE',Order_name||' '||
537: pvt_so_number);
538: else
539: fnd_message.set_token('ORDER_TYPE',Order_name);
540: end if;
541: end if;
542: x_node_label := fnd_message.get;
543: ELSE
538: else
539: fnd_message.set_token('ORDER_TYPE',Order_name);
540: end if;
541: end if;
542: x_node_label := fnd_message.get;
543: ELSE
544: x_node_label := NULL;
545: END IF;
546: IF p_calling_module = 1 then