5: PROCEDURE error( P_FIELD IN VARCHAR2 ) IS
6: BEGIN
7: --BIS_UTILITIES_PUB.Build_Report_Title( 'BIS_MRPFSETA', 'MRPFSETA', NULL );
8: htp.p( '
' ||
9: fnd_message.get_string( 'WIP', 'INVALID_PARAM' ) || ': ' ||
10: P_FIELD || '');
11: htp.p( '
' ||
12: fnd_message.get_string( 'WIP', 'INVALID_PARAM_INSTRUCTION' ) ||
13: '');
8: htp.p( '
' ||
9: fnd_message.get_string( 'WIP', 'INVALID_PARAM' ) || ': ' ||
10: P_FIELD || '');
11: htp.p( '
' ||
12: fnd_message.get_string( 'WIP', 'INVALID_PARAM_INSTRUCTION' ) ||
13: '');
14: END error;
15:
16:
174: ORDER BY organization_name;
175: BEGIN
176: -- htp.formHidden('p_org_id');
177: /*
178: param(i).Label := FND_MESSAGE.get_string( 'MRP', 'MRP_ORGANIZATION_LABEL');
179: param(i).Value := htf.formSelectOpen( 'P_ORG' );
180: -- param(i).Value := htf.formSelectOpen( 'P_ORG', cattributes=>'onChange="setPoplists()"' );
181: FOR c1 in c_organizations LOOP
182: param(i).Value := param(i).Value || htf.formSelectOption( c1.name, NULL, 'value=' || c1.org_id );
194: SELECT plan_id, name FROM bisbv_business_plans;
195: */
196: BEGIN
197: /*
198: param(i).Label := FND_MESSAGE.get_string( 'BOM', 'CST_BUSINESS_PLAN_LABEL');
199: param(i).Value := htf.formSelectOpen( 'P_TARGET' );
200: FOR c1 in c_business_plans LOOP
201: param(i).Value := param(i).Value ||
202: htf.formSelectOption( c1.name, NULL, 'value=' || c1.plan_id );
212: CURSOR c_period IS SELECT distinct period_type name, period_type id
213: FROM gl_periods;
214: BEGIN
215: /*
216: param(i).Label := FND_MESSAGE.get_string( 'MRP', 'MRP_PERIOD_LABEL');
217: param(i).Value := htf.formSelectOpen( 'P_PERIOD' );
218: FOR c1 in c_period LOOP
219: param(i).Value := param(i).Value ||
220: htf.formSelectOption( c1.name, NULL, 'value=' || c1.id );
235: AND organization_id = 207
236: ORDER BY forecast_designator;
237: BEGIN
238: /*
239: param(i).Label := FND_MESSAGE.get_string( 'MRP', 'MRP_FORECAST_SET_LABEL');
240: param(i).Value := htf.formSelectOpen( 'P_FROM_FORECAST' );
241: FOR c1 in c_forecast LOOP
242: param(i).Value := param(i).Value ||
243: htf.formSelectOption( c1.name, NULL, 'value=' || c1.id );
404:
405:
406: /* ORGANIZATION */
407: /*
408: params(1).Label := fnd_message.get_string( 'MRP', 'MRP_ORGANIZATION_LABEL' );
409: params(1).Value := htf.formSelectOpen( 'P_ORGANIZATION_ID' );
410: FOR c1 in c_orgs LOOP
411: if( c1.organization_id = L_ORGANIZATION_ID ) then
412: params(1).Value := params(1).Value || htf.formSelectOption( c1.name, 'Y', 'value=' || c1.organization_id );
418: */
419:
420: /* BUSINESS PLAN */
421: /*
422: params(2).Label := fnd_message.get_string( 'BOM', 'CST_BUSINESS_PLAN_LABEL' );
423: params(2).Value := htf.formSelectOpen( 'P_BUSINESS_PLAN' );
424: FOR c1 in c_business_plans LOOP
425: if( c1.plan_id = L_BUSINESS_PLAN_ID ) then
426: params(2).Value := params(2).Value || htf.formSelectOption( c1.name, 'Y', 'value=' || c1.plan_id );
431: params(2).Value := params(2).Value || htf.formSelectClose;
432: */
433: /* MRP PLANS */
434: /*
435: params(3).Label := fnd_message.get_string( 'MRP', 'MRP_FORECAST_SET_LABEL' );
436: params(3).Value := htf.formSelectOpen('P_PLAN1');
437: FOR c1 in c_forecast LOOP
438: params(3).Value := params(3).Value || htf.formSelectOption( c1.name, NULL, 'value=' || c1.name );
439: END LOOP;
447:
448: /* PERIOD TYPE */
449:
450: /*
451: params(4).Label := fnd_message.get_string( 'MRP', 'MRP_PERIOD_TYPE_LABEL' );
452: params(4).Value := htf.formSelectOpen( 'P_PERIOD_TYPE' );
453: FOR c1 in c_period_types LOOP
454: params(4).Value := params(4).Value ||
455: htf.formSelectOption( c1.name, NULL, 'value=' || c1.name);