18: */
19: PROCEDURE error( P_FIELD IN VARCHAR2 ) IS
20: BEGIN
21: -- BIS_UTILITIES_PUB.Build_Report_Title( FORM_FUNCTION, RDF_FILENAME, NULL );
22: htp.p( '
' ||
23: fnd_message.get_string( 'WIP', 'INVALID_PARAM' ) || ': ' ||
24: P_FIELD || '');
25: htp.p( '
' ||
26: fnd_message.get_string( 'WIP', 'INVALID_PARAM_INSTRUCTION' ) ||
21: -- BIS_UTILITIES_PUB.Build_Report_Title( FORM_FUNCTION, RDF_FILENAME, NULL );
22: htp.p( '
' ||
23: fnd_message.get_string( 'WIP', 'INVALID_PARAM' ) || ': ' ||
24: P_FIELD || '');
25: htp.p( '
' ||
26: fnd_message.get_string( 'WIP', 'INVALID_PARAM_INSTRUCTION' ) ||
27: '');
28: END error;
29:
197:
198: Before_Parameter_MRPEPPS;
199:
200:
201: htp.htmlOpen;
202:
203: -- BIS_UTILITIES_PUB.Build_Report_Title( FORM_FUNCTION, RDF_FILENAME, '' );
204:
205: htp.headOpen;
201: htp.htmlOpen;
202:
203: -- BIS_UTILITIES_PUB.Build_Report_Title( FORM_FUNCTION, RDF_FILENAME, '' );
204:
205: htp.headOpen;
206: js.scriptOpen;
207: icx_util.LOVScript;
208:
209: js.scriptClose;
206: js.scriptOpen;
207: icx_util.LOVScript;
208:
209: js.scriptClose;
210: htp.headClose;
211:
212: htp.bodyOpen;
213:
214: htp.centerOpen;
208:
209: js.scriptClose;
210: htp.headClose;
211:
212: htp.bodyOpen;
213:
214: htp.centerOpen;
215:
216:
210: htp.headClose;
211:
212: htp.bodyOpen;
213:
214: htp.centerOpen;
215:
216:
217: /* ORGANIZATION */
218: /*
284: l_organization_id out NOCOPY varchar2) RETURN BOOLEAN IS
285: l_count INTEGER;
286: BEGIN
287: if (P_ORG_NAME is NULL) then
288: -- htp.p( 'Please select an organization' );
289: error( FND_MESSAGE.get_string( 'BOM', 'CST_ORGANIZATION_LABEL' ) );
290: return FALSE;
291: end if;
292:
299:
300: EXCEPTION
301: WHEN TOO_MANY_ROWS THEN
302: if P_ORG_ID is null then
303: -- htp.p( 'Too many matching organizations found' );
304: error( FND_MESSAGE.get_string( 'BOM', 'CST_ORGANIZATION_LABEL' ) );
305: return FALSE;
306: end if;
307:
313:
314: if l_count = 1 then
315: RETURN TRUE;
316: else
317: -- htp.p( 'Too many matching organizations found' );
318: error( FND_MESSAGE.get_string( 'BOM', 'CST_ORGANIZATION_LABEL' ) );
319: RETURN FALSE;
320: end if;
321:
319: RETURN FALSE;
320: end if;
321:
322: WHEN NO_DATA_FOUND THEN
323: -- htp.p( 'No matching organization found' );
324: error( FND_MESSAGE.get_string( 'BOM', 'CST_ORGANIZATION_LABEL' ) );
325: return FALSE;
326:
327: WHEN OTHERS THEN
324: error( FND_MESSAGE.get_string( 'BOM', 'CST_ORGANIZATION_LABEL' ) );
325: return FALSE;
326:
327: WHEN OTHERS THEN
328: -- htp.p( 'Uncaught exception' );
329: error( FND_MESSAGE.get_string( 'BOM', 'CST_ORGANIZATION_LABEL' ) );
330: return FALSE;
331:
332: END Validate_Org;
346:
347: EXCEPTION
348: WHEN TOO_MANY_ROWS THEN
349: if P_PLAN_NAME is null then
350: -- htp.p( 'Too many matching areas found' );
351: error( FND_MESSAGE.get_string( 'BOM', 'CST_AREA_LABEL' ) );
352: return FALSE;
353: end if;
354:
359:
360: if l_count = 1 then
361: RETURN TRUE;
362: else
363: -- htp.p( 'Too many matching areas found' );
364: error( FND_MESSAGE.get_string( 'BOM', 'CST_AREA_LABEL' ) );
365: RETURN FALSE;
366: end if;
367:
365: RETURN FALSE;
366: end if;
367:
368: WHEN NO_DATA_FOUND THEN
369: -- htp.p( 'No matching area found' );
370: error( FND_MESSAGE.get_string( 'BOM', 'CST_AREA_LABEL' ) );
371: return FALSE;
372:
373: WHEN OTHERS THEN
370: error( FND_MESSAGE.get_string( 'BOM', 'CST_AREA_LABEL' ) );
371: return FALSE;
372:
373: WHEN OTHERS THEN
374: -- htp.p( 'Uncaught exception' );
375: error( FND_MESSAGE.get_string( 'BOM', 'CST_AREA_LABEL' ) );
376: return FALSE;
377:
378: END Validate_Plan;