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:
196:
197: Before_Parameter_MRPEPPS;
198:
199:
200: htp.htmlOpen;
201:
202: BIS_UTILITIES_PUB.Build_Report_Title( FORM_FUNCTION, RDF_FILENAME, '' );
203:
204: htp.headOpen;
200: htp.htmlOpen;
201:
202: BIS_UTILITIES_PUB.Build_Report_Title( FORM_FUNCTION, RDF_FILENAME, '' );
203:
204: htp.headOpen;
205: js.scriptOpen;
206: icx_util.LOVScript;
207:
208: js.scriptClose;
205: js.scriptOpen;
206: icx_util.LOVScript;
207:
208: js.scriptClose;
209: htp.headClose;
210:
211: htp.bodyOpen;
212:
213: htp.centerOpen;
207:
208: js.scriptClose;
209: htp.headClose;
210:
211: htp.bodyOpen;
212:
213: htp.centerOpen;
214:
215:
209: htp.headClose;
210:
211: htp.bodyOpen;
212:
213: htp.centerOpen;
214:
215:
216: /* ORGANIZATION */
217:
282: l_organization_id out NOCOPY varchar2) RETURN BOOLEAN IS
283: l_count INTEGER;
284: BEGIN
285: if (P_ORG_NAME is NULL) then
286: -- htp.p( 'Please select an organization' );
287: error( FND_MESSAGE.get_string( 'BOM', 'CST_ORGANIZATION_LABEL' ) );
288: return FALSE;
289: end if;
290:
297:
298: EXCEPTION
299: WHEN TOO_MANY_ROWS THEN
300: if P_ORG_ID is null then
301: -- htp.p( 'Too many matching organizations found' );
302: error( FND_MESSAGE.get_string( 'BOM', 'CST_ORGANIZATION_LABEL' ) );
303: return FALSE;
304: end if;
305:
311:
312: if l_count = 1 then
313: RETURN TRUE;
314: else
315: -- htp.p( 'Too many matching organizations found' );
316: error( FND_MESSAGE.get_string( 'BOM', 'CST_ORGANIZATION_LABEL' ) );
317: RETURN FALSE;
318: end if;
319:
317: RETURN FALSE;
318: end if;
319:
320: WHEN NO_DATA_FOUND THEN
321: -- htp.p( 'No matching organization found' );
322: error( FND_MESSAGE.get_string( 'BOM', 'CST_ORGANIZATION_LABEL' ) );
323: return FALSE;
324:
325: WHEN OTHERS THEN
322: error( FND_MESSAGE.get_string( 'BOM', 'CST_ORGANIZATION_LABEL' ) );
323: return FALSE;
324:
325: WHEN OTHERS THEN
326: -- htp.p( 'Uncaught exception' );
327: error( FND_MESSAGE.get_string( 'BOM', 'CST_ORGANIZATION_LABEL' ) );
328: return FALSE;
329:
330: END Validate_Org;
344:
345: EXCEPTION
346: WHEN TOO_MANY_ROWS THEN
347: if P_PLAN_NAME is null then
348: -- htp.p( 'Too many matching areas found' );
349: error( FND_MESSAGE.get_string( 'BOM', 'CST_AREA_LABEL' ) );
350: return FALSE;
351: end if;
352:
357:
358: if l_count = 1 then
359: RETURN TRUE;
360: else
361: -- htp.p( 'Too many matching areas found' );
362: error( FND_MESSAGE.get_string( 'BOM', 'CST_AREA_LABEL' ) );
363: RETURN FALSE;
364: end if;
365:
363: RETURN FALSE;
364: end if;
365:
366: WHEN NO_DATA_FOUND THEN
367: -- htp.p( 'No matching area found' );
368: error( FND_MESSAGE.get_string( 'BOM', 'CST_AREA_LABEL' ) );
369: return FALSE;
370:
371: WHEN OTHERS THEN
368: error( FND_MESSAGE.get_string( 'BOM', 'CST_AREA_LABEL' ) );
369: return FALSE;
370:
371: WHEN OTHERS THEN
372: -- htp.p( 'Uncaught exception' );
373: error( FND_MESSAGE.get_string( 'BOM', 'CST_AREA_LABEL' ) );
374: return FALSE;
375:
376: END Validate_Plan;