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 3417: v_calculation_name VARCHAR2(255) := fnd_message.get_string('MSC','MSC_X_HZ_NET_FORECAST') ;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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