4:
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' ) ||
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: '');
14: END error;
15:
49:
50: return TRUE;
51:
52: << no_org_found >>
53: htp.p('no org found at all');
54: return FALSE;
55:
56: EXCEPTION
57: WHEN OTHERS then
54: return FALSE;
55:
56: EXCEPTION
57: WHEN OTHERS then
58: htp.p('no org id for duplicate data');
59: return FALSE;
60:
61: END Validate_Org;
62:
82: return TRUE;
83:
84: EXCEPTION
85: WHEN NO_DATA_FOUND then
86: htp.p('no period type');
87: return FALSE;
88:
89: END Validate_Per;
90:
117: return TRUE;
118:
119: EXCEPTION
120: WHEN NO_DATA_FOUND then
121: htp.p('no forecast');
122: return FALSE;
123:
124: END Validate_Fcst;
125:
172: SELECT organization_id org_id, organization_name name
173: FROM org_organization_definitions
174: ORDER BY organization_name;
175: BEGIN
176: -- htp.formHidden('p_org_id');
177: param(i).Label := FND_MESSAGE.get_string( 'MRP', 'MRP_ORGANIZATION_LABEL');
178: param(i).Value := htf.formSelectOpen( 'P_ORG' );
179: -- param(i).Value := htf.formSelectOpen( 'P_ORG', cattributes=>'onChange="setPoplists()"' );
180: FOR c1 in c_organizations LOOP
375:
376: Before_Parameter_MRPFSETA;
377:
378:
379: htp.htmlOpen;
380:
381: BIS_UTILITIES_PUB.Build_Report_Title( 'BIS_MRPFSETA', 'MRPFSETA', '' );
382:
383: htp.headOpen;
379: htp.htmlOpen;
380:
381: BIS_UTILITIES_PUB.Build_Report_Title( 'BIS_MRPFSETA', 'MRPFSETA', '' );
382:
383: htp.headOpen;
384: js.scriptOpen;
385: icx_util.LOVScript;
386:
387: js.scriptClose;
384: js.scriptOpen;
385: icx_util.LOVScript;
386:
387: js.scriptClose;
388: htp.headClose;
389:
390: htp.bodyOpen;
391:
392: htp.centerOpen;
386:
387: js.scriptClose;
388: htp.headClose;
389:
390: htp.bodyOpen;
391:
392: htp.centerOpen;
393:
394:
388: htp.headClose;
389:
390: htp.bodyOpen;
391:
392: htp.centerOpen;
393:
394:
395: /* ORGANIZATION */
396: