eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_X_HZ_PLAN dependencies on FND_MESSAGE

Line 2832: l_statement := l_statement || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL''))|| ';

2828: elsif tpco_agg = ALL_AGG THEN
2829:
2830: if myco_agg = ORG_AGG THEN
2831: l_statement := l_statement || 'decode(third_party_flag,0,least(viewer_company||viewer_site, ';
2832: l_statement := l_statement || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL''))|| ';
2833: l_statement := l_statement || 'greatest(viewer_company||viewer_site,';
2834: l_statement := l_statement || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')),';
2835: l_statement := l_statement || 'decode(viewer_company, customer_name, viewer_company||viewer_site||FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')';
2836: l_statement := l_statement || ', FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')||viewer_company||viewer_site))';

Line 2834: l_statement := l_statement || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')),';

2830: if myco_agg = ORG_AGG THEN
2831: l_statement := l_statement || 'decode(third_party_flag,0,least(viewer_company||viewer_site, ';
2832: l_statement := l_statement || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL''))|| ';
2833: l_statement := l_statement || 'greatest(viewer_company||viewer_site,';
2834: l_statement := l_statement || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')),';
2835: l_statement := l_statement || 'decode(viewer_company, customer_name, viewer_company||viewer_site||FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')';
2836: l_statement := l_statement || ', FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')||viewer_company||viewer_site))';
2837:
2838: l_order_group := l_order_group || 'decode(third_party_flag,0,least(viewer_company||viewer_site, ';

Line 2835: l_statement := l_statement || 'decode(viewer_company, customer_name, viewer_company||viewer_site||FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')';

2831: l_statement := l_statement || 'decode(third_party_flag,0,least(viewer_company||viewer_site, ';
2832: l_statement := l_statement || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL''))|| ';
2833: l_statement := l_statement || 'greatest(viewer_company||viewer_site,';
2834: l_statement := l_statement || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')),';
2835: l_statement := l_statement || 'decode(viewer_company, customer_name, viewer_company||viewer_site||FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')';
2836: l_statement := l_statement || ', FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')||viewer_company||viewer_site))';
2837:
2838: l_order_group := l_order_group || 'decode(third_party_flag,0,least(viewer_company||viewer_site, ';
2839: l_order_group := l_order_group || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL''))|| ';

Line 2836: l_statement := l_statement || ', FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')||viewer_company||viewer_site))';

2832: l_statement := l_statement || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL''))|| ';
2833: l_statement := l_statement || 'greatest(viewer_company||viewer_site,';
2834: l_statement := l_statement || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')),';
2835: l_statement := l_statement || 'decode(viewer_company, customer_name, viewer_company||viewer_site||FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')';
2836: l_statement := l_statement || ', FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')||viewer_company||viewer_site))';
2837:
2838: l_order_group := l_order_group || 'decode(third_party_flag,0,least(viewer_company||viewer_site, ';
2839: l_order_group := l_order_group || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL''))|| ';
2840: l_order_group := l_order_group || 'greatest(viewer_company||viewer_site,';

Line 2839: l_order_group := l_order_group || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL''))|| ';

2835: l_statement := l_statement || 'decode(viewer_company, customer_name, viewer_company||viewer_site||FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')';
2836: l_statement := l_statement || ', FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')||viewer_company||viewer_site))';
2837:
2838: l_order_group := l_order_group || 'decode(third_party_flag,0,least(viewer_company||viewer_site, ';
2839: l_order_group := l_order_group || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL''))|| ';
2840: l_order_group := l_order_group || 'greatest(viewer_company||viewer_site,';
2841: l_order_group := l_order_group || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')),';
2842: l_order_group := l_order_group || 'decode(viewer_company, customer_name, viewer_company||viewer_site||FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')';
2843: l_order_group := l_order_group || ', FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')||viewer_company||viewer_site))';

Line 2841: l_order_group := l_order_group || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')),';

2837:
2838: l_order_group := l_order_group || 'decode(third_party_flag,0,least(viewer_company||viewer_site, ';
2839: l_order_group := l_order_group || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL''))|| ';
2840: l_order_group := l_order_group || 'greatest(viewer_company||viewer_site,';
2841: l_order_group := l_order_group || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')),';
2842: l_order_group := l_order_group || 'decode(viewer_company, customer_name, viewer_company||viewer_site||FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')';
2843: l_order_group := l_order_group || ', FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')||viewer_company||viewer_site))';
2844:
2845: elsif myco_agg = COMPANY_AGG THEN

Line 2842: l_order_group := l_order_group || 'decode(viewer_company, customer_name, viewer_company||viewer_site||FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')';

2838: l_order_group := l_order_group || 'decode(third_party_flag,0,least(viewer_company||viewer_site, ';
2839: l_order_group := l_order_group || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL''))|| ';
2840: l_order_group := l_order_group || 'greatest(viewer_company||viewer_site,';
2841: l_order_group := l_order_group || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')),';
2842: l_order_group := l_order_group || 'decode(viewer_company, customer_name, viewer_company||viewer_site||FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')';
2843: l_order_group := l_order_group || ', FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')||viewer_company||viewer_site))';
2844:
2845: elsif myco_agg = COMPANY_AGG THEN
2846: l_statement := l_statement || 'decode(third_party_flag,0,least(viewer_company,';

Line 2843: l_order_group := l_order_group || ', FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')||viewer_company||viewer_site))';

2839: l_order_group := l_order_group || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL''))|| ';
2840: l_order_group := l_order_group || 'greatest(viewer_company||viewer_site,';
2841: l_order_group := l_order_group || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')),';
2842: l_order_group := l_order_group || 'decode(viewer_company, customer_name, viewer_company||viewer_site||FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')';
2843: l_order_group := l_order_group || ', FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')||viewer_company||viewer_site))';
2844:
2845: elsif myco_agg = COMPANY_AGG THEN
2846: l_statement := l_statement || 'decode(third_party_flag,0,least(viewer_company,';
2847: l_statement := l_statement || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL''))|| ';

Line 2847: l_statement := l_statement || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL''))|| ';

2843: l_order_group := l_order_group || ', FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')||viewer_company||viewer_site))';
2844:
2845: elsif myco_agg = COMPANY_AGG THEN
2846: l_statement := l_statement || 'decode(third_party_flag,0,least(viewer_company,';
2847: l_statement := l_statement || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL''))|| ';
2848: l_statement := l_statement || 'greatest(viewer_company,';
2849: l_statement := l_statement || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')),';
2850: l_statement := l_statement || 'decode(viewer_company, customer_name, viewer_company||FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')';
2851: l_statement := l_statement || ', FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')||viewer_company))';

Line 2849: l_statement := l_statement || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')),';

2845: elsif myco_agg = COMPANY_AGG THEN
2846: l_statement := l_statement || 'decode(third_party_flag,0,least(viewer_company,';
2847: l_statement := l_statement || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL''))|| ';
2848: l_statement := l_statement || 'greatest(viewer_company,';
2849: l_statement := l_statement || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')),';
2850: l_statement := l_statement || 'decode(viewer_company, customer_name, viewer_company||FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')';
2851: l_statement := l_statement || ', FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')||viewer_company))';
2852:
2853: l_order_group := l_order_group || 'decode(third_party_flag,0,least(viewer_company,';

Line 2850: l_statement := l_statement || 'decode(viewer_company, customer_name, viewer_company||FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')';

2846: l_statement := l_statement || 'decode(third_party_flag,0,least(viewer_company,';
2847: l_statement := l_statement || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL''))|| ';
2848: l_statement := l_statement || 'greatest(viewer_company,';
2849: l_statement := l_statement || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')),';
2850: l_statement := l_statement || 'decode(viewer_company, customer_name, viewer_company||FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')';
2851: l_statement := l_statement || ', FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')||viewer_company))';
2852:
2853: l_order_group := l_order_group || 'decode(third_party_flag,0,least(viewer_company,';
2854: l_order_group := l_order_group || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL''))|| ';

Line 2851: l_statement := l_statement || ', FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')||viewer_company))';

2847: l_statement := l_statement || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL''))|| ';
2848: l_statement := l_statement || 'greatest(viewer_company,';
2849: l_statement := l_statement || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')),';
2850: l_statement := l_statement || 'decode(viewer_company, customer_name, viewer_company||FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')';
2851: l_statement := l_statement || ', FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')||viewer_company))';
2852:
2853: l_order_group := l_order_group || 'decode(third_party_flag,0,least(viewer_company,';
2854: l_order_group := l_order_group || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL''))|| ';
2855: l_order_group := l_order_group || 'greatest(viewer_company,';

Line 2854: l_order_group := l_order_group || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL''))|| ';

2850: l_statement := l_statement || 'decode(viewer_company, customer_name, viewer_company||FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')';
2851: l_statement := l_statement || ', FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')||viewer_company))';
2852:
2853: l_order_group := l_order_group || 'decode(third_party_flag,0,least(viewer_company,';
2854: l_order_group := l_order_group || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL''))|| ';
2855: l_order_group := l_order_group || 'greatest(viewer_company,';
2856: l_order_group := l_order_group || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')),';
2857: l_order_group := l_order_group || 'decode(viewer_company, customer_name, viewer_company||FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')';
2858: l_order_group := l_order_group || ', FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')||viewer_company))';

Line 2856: l_order_group := l_order_group || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')),';

2852:
2853: l_order_group := l_order_group || 'decode(third_party_flag,0,least(viewer_company,';
2854: l_order_group := l_order_group || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL''))|| ';
2855: l_order_group := l_order_group || 'greatest(viewer_company,';
2856: l_order_group := l_order_group || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')),';
2857: l_order_group := l_order_group || 'decode(viewer_company, customer_name, viewer_company||FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')';
2858: l_order_group := l_order_group || ', FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')||viewer_company))';
2859: end if;
2860:

Line 2857: l_order_group := l_order_group || 'decode(viewer_company, customer_name, viewer_company||FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')';

2853: l_order_group := l_order_group || 'decode(third_party_flag,0,least(viewer_company,';
2854: l_order_group := l_order_group || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL''))|| ';
2855: l_order_group := l_order_group || 'greatest(viewer_company,';
2856: l_order_group := l_order_group || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')),';
2857: l_order_group := l_order_group || 'decode(viewer_company, customer_name, viewer_company||FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')';
2858: l_order_group := l_order_group || ', FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')||viewer_company))';
2859: end if;
2860:
2861: end if;

Line 2858: l_order_group := l_order_group || ', FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')||viewer_company))';

2854: l_order_group := l_order_group || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL''))|| ';
2855: l_order_group := l_order_group || 'greatest(viewer_company,';
2856: l_order_group := l_order_group || 'FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')),';
2857: l_order_group := l_order_group || 'decode(viewer_company, customer_name, viewer_company||FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')';
2858: l_order_group := l_order_group || ', FND_MESSAGE.GET_STRING(''MSC'',''MSC_X_HZ_TP_ALL'')||viewer_company))';
2859: end if;
2860:
2861: end if;
2862:

Line 3416: v_calculation_name VARCHAR2(255) := fnd_message.get_string('MSC','MSC_X_HZ_NET_FORECAST') ;

3412: SUPPLIER_NAME,CUSTOMER_NAME,SUPPLIER_ORG_CODE,CUSTOMER_ORG_CODE,UOM,
3413: SUPPLIER_ID,CUSTOMER_ID,INVENTORY_ITEM_ID
3414: HAVING sum(decode(order_type, ORDER_FORECAST_CST, 1, 0)) > 0;
3415:
3416: v_calculation_name VARCHAR2(255) := fnd_message.get_string('MSC','MSC_X_HZ_NET_FORECAST') ;
3417:
3418: BEGIN
3419: invert_quantities(arg_query_id, REQUISITION);
3420: invert_quantities(arg_query_id, PURCHASE_ORDER);

Line 3794: v_calculation_name VARCHAR2(255) := fnd_message.get_string('MSC','MSC_X_HZ_TOTAL_SUPPLY') ;

3790: GROUP BY ORDER_RELATION_GROUP, FROM_COMPANY_NAME,FROM_ORG_CODE,ITEM_NAME,ITEM_DESCRIPTION,
3791: SUPPLIER_NAME,CUSTOMER_NAME,SUPPLIER_ORG_CODE,CUSTOMER_ORG_CODE,UOM,
3792: SUPPLIER_ID,CUSTOMER_ID,INVENTORY_ITEM_ID;
3793:
3794: v_calculation_name VARCHAR2(255) := fnd_message.get_string('MSC','MSC_X_HZ_TOTAL_SUPPLY') ;
3795:
3796: BEGIN
3797: OPEN c_total_supply;
3798: FETCH c_total_supply BULK COLLECT INTO

Line 3876: v_name := fnd_message.get_string('MSC','MSC_X_HZ_RUN_DEMAND') ;

3872: PROCEDURE insert_running_total(v_order_type IN NUMBER) IS
3873: v_name VARCHAR2(250);
3874: BEGIN
3875: if v_order_type = ORDER_FORECAST_CST then
3876: v_name := fnd_message.get_string('MSC','MSC_X_HZ_RUN_DEMAND') ;
3877: elsif v_order_type = SUPPLY_COMMIT then
3878: v_name := fnd_message.get_string('MSC','MSC_X_HZ_RUN_SUPPLY') ;
3879: end if;
3880:

Line 3878: v_name := fnd_message.get_string('MSC','MSC_X_HZ_RUN_SUPPLY') ;

3874: BEGIN
3875: if v_order_type = ORDER_FORECAST_CST then
3876: v_name := fnd_message.get_string('MSC','MSC_X_HZ_RUN_DEMAND') ;
3877: elsif v_order_type = SUPPLY_COMMIT then
3878: v_name := fnd_message.get_string('MSC','MSC_X_HZ_RUN_SUPPLY') ;
3879: end if;
3880:
3881: OPEN c_runTotal(v_order_type) ;
3882: FETCH c_runTotal BULK COLLECT INTO

Line 4034: v_past_due_hdr := FND_MESSAGE.GET_STRING('MSC','MSC_X_HZ_PAST_DUE');

4030: END IF;
4031: END IF;
4032:
4033: --get the past due column header
4034: v_past_due_hdr := FND_MESSAGE.GET_STRING('MSC','MSC_X_HZ_PAST_DUE');
4035:
4036: --massage ss and pab data
4037: --fill_ss_pab_empty_buckets;
4038: -- get the query id first

Line 4397: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_DEMAND')

4393: SELECT count(*)
4394: INTO arg_num_rowset
4395: FROM msc_hz_ui_lines
4396: WHERE query_id = arg_query_id
4397: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_DEMAND')
4398: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_SUPPLY')
4399: ;
4400:
4401: /**

Line 4398: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_SUPPLY')

4394: INTO arg_num_rowset
4395: FROM msc_hz_ui_lines
4396: WHERE query_id = arg_query_id
4397: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_DEMAND')
4398: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_SUPPLY')
4399: ;
4400:
4401: /**
4402: * Update other reqd fields.

Line 4490: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_DEMAND')

4486: SELECT count(*)
4487: INTO arg_num_rowset
4488: FROM msc_hz_ui_lines
4489: WHERE query_id = arg_query_id
4490: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_DEMAND')
4491: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_SUPPLY')
4492: ;
4493:
4494: /**

Line 4491: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_SUPPLY')

4487: INTO arg_num_rowset
4488: FROM msc_hz_ui_lines
4489: WHERE query_id = arg_query_id
4490: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_DEMAND')
4491: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_SUPPLY')
4492: ;
4493:
4494: /**
4495: * Companion row

Line 4520: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_DEMAND')

4516: SELECT count(*)
4517: INTO arg_num_rowset
4518: FROM msc_hz_ui_lines
4519: WHERE query_id = arg_query_id
4520: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_DEMAND')
4521: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_SUPPLY')
4522: ;
4523:
4524: /**

Line 4521: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_SUPPLY')

4517: INTO arg_num_rowset
4518: FROM msc_hz_ui_lines
4519: WHERE query_id = arg_query_id
4520: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_DEMAND')
4521: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_SUPPLY')
4522: ;
4523:
4524: /**
4525: * Clean-Up

Line 4605: SET customer_name = FND_MESSAGE.GET_STRING('MSC','MSC_X_HZ_TP_ALL'),

4601: AND (SUPPLIER_NAME = v_user_company OR CUSTOMER_NAME = v_user_company )
4602: AND query_id = arg_query_id ;
4603:
4604: UPDATE msc_hz_ui_lines
4605: SET customer_name = FND_MESSAGE.GET_STRING('MSC','MSC_X_HZ_TP_ALL'),
4606: customer_org_code = NULL
4607: --,customer_site_id = NULL
4608: WHERE SUPPLIER_NAME = v_user_company -- user is supplier
4609: AND query_id = arg_query_id ;

Line 4612: SET SUPPLIER_NAME = FND_MESSAGE.GET_STRING('MSC','MSC_X_HZ_TP_ALL'),

4608: WHERE SUPPLIER_NAME = v_user_company -- user is supplier
4609: AND query_id = arg_query_id ;
4610:
4611: UPDATE msc_hz_ui_lines
4612: SET SUPPLIER_NAME = FND_MESSAGE.GET_STRING('MSC','MSC_X_HZ_TP_ALL'),
4613: SUPPLIER_ORG_CODE = NULL
4614: WHERE CUSTOMER_NAME = v_user_company -- user is customer
4615: AND query_id = arg_query_id ;
4616:

Line 4698: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_DEMAND')

4694: SELECT count(*)
4695: INTO arg_num_rowset
4696: FROM msc_hz_ui_lines
4697: WHERE query_id = arg_query_id
4698: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_DEMAND')
4699: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_SUPPLY')
4700: ;
4701:
4702:

Line 4699: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_SUPPLY')

4695: INTO arg_num_rowset
4696: FROM msc_hz_ui_lines
4697: WHERE query_id = arg_query_id
4698: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_DEMAND')
4699: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_SUPPLY')
4700: ;
4701:
4702:
4703: -- NOW HANDLE NET FORECAST

Line 4734: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_DEMAND')

4730: SELECT count(*)
4731: INTO arg_num_rowset
4732: FROM msc_hz_ui_lines
4733: WHERE query_id = arg_query_id
4734: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_DEMAND')
4735: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_SUPPLY')
4736: ;
4737:
4738: -- NOW HANDLE TOTAL SUPPLY

Line 4735: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_SUPPLY')

4731: INTO arg_num_rowset
4732: FROM msc_hz_ui_lines
4733: WHERE query_id = arg_query_id
4734: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_DEMAND')
4735: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_SUPPLY')
4736: ;
4737:
4738: -- NOW HANDLE TOTAL SUPPLY
4739: BEGIN

Line 4757: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_DEMAND')

4753: SELECT count(*)
4754: INTO arg_num_rowset
4755: FROM msc_hz_ui_lines
4756: WHERE query_id = arg_query_id
4757: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_DEMAND')
4758: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_SUPPLY')
4759: ;
4760:
4761: BEGIN

Line 4758: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_SUPPLY')

4754: INTO arg_num_rowset
4755: FROM msc_hz_ui_lines
4756: WHERE query_id = arg_query_id
4757: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_DEMAND')
4758: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_SUPPLY')
4759: ;
4760:
4761: BEGIN
4762: -- now update the undated_buckets value int the header

Line 4781: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_DEMAND')

4777: SELECT count(*)
4778: INTO arg_num_rowset
4779: FROM msc_hz_ui_lines
4780: WHERE query_id = arg_query_id
4781: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_DEMAND')
4782: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_SUPPLY')
4783: ;
4784:
4785: if arg_num_rowset = 0 then

Line 4782: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_SUPPLY')

4778: INTO arg_num_rowset
4779: FROM msc_hz_ui_lines
4780: WHERE query_id = arg_query_id
4781: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_DEMAND')
4782: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_SUPPLY')
4783: ;
4784:
4785: if arg_num_rowset = 0 then
4786: arg_query_id := -1;

Line 4804: arg_err_msg := arg_err_msg || fnd_message.get_string('MSC','MSC_X_HZ_NODATA');

4800:
4801: end if;
4802:
4803: if arg_query_id = -1 then
4804: arg_err_msg := arg_err_msg || fnd_message.get_string('MSC','MSC_X_HZ_NODATA');
4805: arg_num_rowset := 0 ;
4806: end if;
4807:
4808: EXCEPTION

Line 4815: arg_err_msg := arg_err_msg || fnd_message.get_string('MSC','MSC_X_HZ_NODATA');

4811: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'populate_bucketed_quantity', SQLERRM);
4812: end if;
4813: arg_query_id :=-1;
4814: arg_num_rowset := 0 ;
4815: arg_err_msg := arg_err_msg || fnd_message.get_string('MSC','MSC_X_HZ_NODATA');
4816:
4817: if (osce_bucketed_plan%ISOPEN) then
4818: close osce_bucketed_plan;
4819: end if;

Line 4826: arg_err_msg := arg_err_msg || fnd_message.get_string('MSC','MSC_X_HZ_NODATA');

4822: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4823: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'populate_bucketed_quantity', SQLERRM);
4824: end if;
4825: arg_query_id :=-1;
4826: arg_err_msg := arg_err_msg || fnd_message.get_string('MSC','MSC_X_HZ_NODATA');
4827: arg_num_rowset := 0 ;
4828:
4829: if (osce_bucketed_plan%ISOPEN) then
4830: close osce_bucketed_plan;