6750: if p_start_date < ll_thedate then -- {
6751: p_return_status := 'ERROR';
6752: --p_out := to_char(ll_theDate,format_mask)|| field_seperator ||null_space||field_seperator||null_space ;
6753: --5728088, send translated message to pld
6754: fnd_message.set_name('MSC', 'MSC_GC_START_DT_LT_SYSDATE');
6755: fnd_message.set_token('START_DATE', to_char(p_start_date,format_mask));
6756: p_out := fnd_message.get;
6757: return;
6758: end if; -- }
6751: p_return_status := 'ERROR';
6752: --p_out := to_char(ll_theDate,format_mask)|| field_seperator ||null_space||field_seperator||null_space ;
6753: --5728088, send translated message to pld
6754: fnd_message.set_name('MSC', 'MSC_GC_START_DT_LT_SYSDATE');
6755: fnd_message.set_token('START_DATE', to_char(p_start_date,format_mask));
6756: p_out := fnd_message.get;
6757: return;
6758: end if; -- }
6759:
6752: --p_out := to_char(ll_theDate,format_mask)|| field_seperator ||null_space||field_seperator||null_space ;
6753: --5728088, send translated message to pld
6754: fnd_message.set_name('MSC', 'MSC_GC_START_DT_LT_SYSDATE');
6755: fnd_message.set_token('START_DATE', to_char(p_start_date,format_mask));
6756: p_out := fnd_message.get;
6757: return;
6758: end if; -- }
6759:
6760: if ( p_node_type = RES_NODE ) then
6865:
6866: if v_lower_start is not null and p_start_date < v_lower_start then -- {
6867: --p_out := to_char(v_lower_start,format_mask) || field_seperator|| to_char(v_lower_start_id);
6868: --5728088, send translated message to pld
6869: fnd_message.set_name('MSC', 'MSC_GC_START_DT_LT_CONS_DATE');
6870: fnd_message.set_token('DATE1', to_char(v_lower_start,format_mask));
6871: fnd_message.set_token('TRX_ID', to_char(v_lower_start_id));
6872: p_out := fnd_message.get;
6873: p_return_status := 'ERROR';
6866: if v_lower_start is not null and p_start_date < v_lower_start then -- {
6867: --p_out := to_char(v_lower_start,format_mask) || field_seperator|| to_char(v_lower_start_id);
6868: --5728088, send translated message to pld
6869: fnd_message.set_name('MSC', 'MSC_GC_START_DT_LT_CONS_DATE');
6870: fnd_message.set_token('DATE1', to_char(v_lower_start,format_mask));
6871: fnd_message.set_token('TRX_ID', to_char(v_lower_start_id));
6872: p_out := fnd_message.get;
6873: p_return_status := 'ERROR';
6874: else
6867: --p_out := to_char(v_lower_start,format_mask) || field_seperator|| to_char(v_lower_start_id);
6868: --5728088, send translated message to pld
6869: fnd_message.set_name('MSC', 'MSC_GC_START_DT_LT_CONS_DATE');
6870: fnd_message.set_token('DATE1', to_char(v_lower_start,format_mask));
6871: fnd_message.set_token('TRX_ID', to_char(v_lower_start_id));
6872: p_out := fnd_message.get;
6873: p_return_status := 'ERROR';
6874: else
6875: p_out := null_space || field_seperator || null_space;
6868: --5728088, send translated message to pld
6869: fnd_message.set_name('MSC', 'MSC_GC_START_DT_LT_CONS_DATE');
6870: fnd_message.set_token('DATE1', to_char(v_lower_start,format_mask));
6871: fnd_message.set_token('TRX_ID', to_char(v_lower_start_id));
6872: p_out := fnd_message.get;
6873: p_return_status := 'ERROR';
6874: else
6875: p_out := null_space || field_seperator || null_space;
6876: end if; -- }
6890:
6891: if v_lower_end is not null and p_end_date < v_lower_end then -- {
6892: --p_out := p_out || field_seperator|| to_char(v_lower_end,format_mask)|| field_seperator || to_char(v_lower_end_id);
6893: --5728088, send translated message to pld
6894: fnd_message.set_name('MSC', 'MSC_GC_END_DT_LT_CONS_DATE');
6895: fnd_message.set_token('DATE1', to_char(v_lower_end,format_mask));
6896: fnd_message.set_token('TRX_ID', to_char(v_lower_end_id));
6897: p_out := fnd_message.get;
6898: p_return_status := 'ERROR';
6891: if v_lower_end is not null and p_end_date < v_lower_end then -- {
6892: --p_out := p_out || field_seperator|| to_char(v_lower_end,format_mask)|| field_seperator || to_char(v_lower_end_id);
6893: --5728088, send translated message to pld
6894: fnd_message.set_name('MSC', 'MSC_GC_END_DT_LT_CONS_DATE');
6895: fnd_message.set_token('DATE1', to_char(v_lower_end,format_mask));
6896: fnd_message.set_token('TRX_ID', to_char(v_lower_end_id));
6897: p_out := fnd_message.get;
6898: p_return_status := 'ERROR';
6899: end if; -- }
6892: --p_out := p_out || field_seperator|| to_char(v_lower_end,format_mask)|| field_seperator || to_char(v_lower_end_id);
6893: --5728088, send translated message to pld
6894: fnd_message.set_name('MSC', 'MSC_GC_END_DT_LT_CONS_DATE');
6895: fnd_message.set_token('DATE1', to_char(v_lower_end,format_mask));
6896: fnd_message.set_token('TRX_ID', to_char(v_lower_end_id));
6897: p_out := fnd_message.get;
6898: p_return_status := 'ERROR';
6899: end if; -- }
6900:
6893: --5728088, send translated message to pld
6894: fnd_message.set_name('MSC', 'MSC_GC_END_DT_LT_CONS_DATE');
6895: fnd_message.set_token('DATE1', to_char(v_lower_end,format_mask));
6896: fnd_message.set_token('TRX_ID', to_char(v_lower_end_id));
6897: p_out := fnd_message.get;
6898: p_return_status := 'ERROR';
6899: end if; -- }
6900:
6901: if v_upper_end is not null and p_end_date > v_upper_end then -- {
6900:
6901: if v_upper_end is not null and p_end_date > v_upper_end then -- {
6902: --p_out := p_out || field_seperator || to_char(v_upper_end,format_mask)|| field_seperator || to_char(v_upper_end_id);
6903: --5728088, send translated message to pld
6904: fnd_message.set_name('MSC', 'MSC_GC_END_DT_LT_CONS_DATE');
6905: fnd_message.set_token('DATE1', to_char(v_upper_end,format_mask));
6906: fnd_message.set_token('TRX_ID', to_char(v_lower_end_id));
6907: p_out := fnd_message.get;
6908: p_return_status := 'ERROR';
6901: if v_upper_end is not null and p_end_date > v_upper_end then -- {
6902: --p_out := p_out || field_seperator || to_char(v_upper_end,format_mask)|| field_seperator || to_char(v_upper_end_id);
6903: --5728088, send translated message to pld
6904: fnd_message.set_name('MSC', 'MSC_GC_END_DT_LT_CONS_DATE');
6905: fnd_message.set_token('DATE1', to_char(v_upper_end,format_mask));
6906: fnd_message.set_token('TRX_ID', to_char(v_lower_end_id));
6907: p_out := fnd_message.get;
6908: p_return_status := 'ERROR';
6909: end if; -- }
6902: --p_out := p_out || field_seperator || to_char(v_upper_end,format_mask)|| field_seperator || to_char(v_upper_end_id);
6903: --5728088, send translated message to pld
6904: fnd_message.set_name('MSC', 'MSC_GC_END_DT_LT_CONS_DATE');
6905: fnd_message.set_token('DATE1', to_char(v_upper_end,format_mask));
6906: fnd_message.set_token('TRX_ID', to_char(v_lower_end_id));
6907: p_out := fnd_message.get;
6908: p_return_status := 'ERROR';
6909: end if; -- }
6910:
6903: --5728088, send translated message to pld
6904: fnd_message.set_name('MSC', 'MSC_GC_END_DT_LT_CONS_DATE');
6905: fnd_message.set_token('DATE1', to_char(v_upper_end,format_mask));
6906: fnd_message.set_token('TRX_ID', to_char(v_lower_end_id));
6907: p_out := fnd_message.get;
6908: p_return_status := 'ERROR';
6909: end if; -- }
6910:
6911: if p_return_status = 'ERROR' then -- {
8140: procedure getProperty(p_plan_id number, p_instance_id number,
8141: p_transaction_id number, p_type number, p_view_type number, p_end_demand_id number,
8142: v_pro out NOCOPY varchar2, v_demand out NOCOPY varchar2) is
8143:
8144: l_buy_text varchar2(2000) := fnd_message.get_string('MSC','BUY_TEXT');
8145: l_make_text varchar2(2000) := fnd_message.get_string('MSC','MAKE_TEXT');
8146: l_transfer_text varchar2(2000) := fnd_message.get_string('MSC','TRANSFER_TEXT');
8147:
8148: cursor job_cur is
8141: p_transaction_id number, p_type number, p_view_type number, p_end_demand_id number,
8142: v_pro out NOCOPY varchar2, v_demand out NOCOPY varchar2) is
8143:
8144: l_buy_text varchar2(2000) := fnd_message.get_string('MSC','BUY_TEXT');
8145: l_make_text varchar2(2000) := fnd_message.get_string('MSC','MAKE_TEXT');
8146: l_transfer_text varchar2(2000) := fnd_message.get_string('MSC','TRANSFER_TEXT');
8147:
8148: cursor job_cur is
8149: select msi.item_name item,
8142: v_pro out NOCOPY varchar2, v_demand out NOCOPY varchar2) is
8143:
8144: l_buy_text varchar2(2000) := fnd_message.get_string('MSC','BUY_TEXT');
8145: l_make_text varchar2(2000) := fnd_message.get_string('MSC','MAKE_TEXT');
8146: l_transfer_text varchar2(2000) := fnd_message.get_string('MSC','TRANSFER_TEXT');
8147:
8148: cursor job_cur is
8149: select msi.item_name item,
8150: ms.new_order_quantity qty,