DBA Data[Home] [Help]

APPS.POA_REPORT_UTIL dependencies on FND_MESSAGE

Line 9: FND_MESSAGE.get_string('PO', 'POA_ORDER_DATES');

5: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
6: p_index IN NUMBER) IS
7: BEGIN
8: p_param(p_index).Label :=
9: FND_MESSAGE.get_string('PO', 'POA_ORDER_DATES');
10: p_param(p_index).Value := htf.formText('P_FDATE', NULL, NULL,
11: to_char(add_months(trunc(sysdate), -12) + 1, icx_sec.g_date_format));
12: p_param(p_index).Value := p_param(p_index).Value || ' - ' ||
13: htf.formText('P_TDATE', NULL, NULL, to_char(trunc(sysdate),

Line 22: FND_MESSAGE.get_string('PO', 'POA_REPORTING_DATES');

18: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
19: p_index IN NUMBER) IS
20: BEGIN
21: p_param(p_index).Label :=
22: FND_MESSAGE.get_string('PO', 'POA_REPORTING_DATES');
23: p_param(p_index).Value := htf.formText('P_FDATE', NULL, NULL,
24: to_char(add_months(trunc(sysdate), -12) + 1, icx_sec.g_date_format));
25: p_param(p_index).Value := p_param(p_index).Value || ' - ' ||
26: htf.formText('P_TDATE', NULL, NULL, to_char(trunc(sysdate),

Line 35: FND_MESSAGE.get_string('PO', 'POA_ITEM');

31: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
32: p_index IN NUMBER) IS
33: BEGIN
34: p_param(p_index).Label :=
35: FND_MESSAGE.get_string('PO', 'POA_ITEM');
36: p_param(p_index).Value := htf.formText('POA_BIS_ITEM_NAME');
37: p_param(p_index).Action :=
38: '

Line 51: FND_MESSAGE.get_string('PO', 'POA_PREF_SUPPLIER');

47: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
48: p_index IN NUMBER) IS
49: BEGIN
50: p_param(p_index).Label :=
51: FND_MESSAGE.get_string('PO', 'POA_PREF_SUPPLIER');
52: p_param(p_index).Value := htf.formText('POA_BIS_PREF_SUPP_NAME');
53: p_param(p_index).Action :=
54: '

Line 67: FND_MESSAGE.get_string('PO', 'POA_CONS_SUPPLIER');

63: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
64: p_index IN NUMBER) IS
65: BEGIN
66: p_param(p_index).Label :=
67: FND_MESSAGE.get_string('PO', 'POA_CONS_SUPPLIER');
68: p_param(p_index).Value := htf.formText('POA_BIS_CONS_SUPP_NAME');
69: p_param(p_index).Action :=
70: '

Line 119: FND_MESSAGE.get_string('PO', 'POA_SUPPLIER_NUM');

115: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
116: p_index IN NUMBER) IS
117: BEGIN
118: p_param(p_index).Label :=
119: FND_MESSAGE.get_string('PO', 'POA_SUPPLIER_NUM');
120: p_param(p_index).Value := htf.formText('POA_BIS_SUPPLIER_NUM', NULL, NULL,
121: to_char(3));
122: END Build_SupplierNum;
123:

Line 129: FND_MESSAGE.get_string('PO', 'POA_QUALITY_COST');

125: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
126: p_index IN NUMBER) IS
127: BEGIN
128: p_param(p_index).Label :=
129: FND_MESSAGE.get_string('PO', 'POA_QUALITY_COST');
130: p_param(p_index).Value := htf.formText('POA_BIS_QUALITY_COST', NULL, NULL,
131: to_char(25));
132: END Build_QualityCost;
133:

Line 139: FND_MESSAGE.get_string('PO', 'POA_DELIVERY_COST');

135: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
136: p_index IN NUMBER) IS
137: BEGIN
138: p_param(p_index).Label :=
139: FND_MESSAGE.get_string('PO', 'POA_DELIVERY_COST');
140: p_param(p_index).Value := htf.formText('POA_BIS_DELIVERY_COST', NULL, NULL,
141: to_char(25));
142: END Build_DeliveryCost;
143:

Line 149: FND_MESSAGE.get_string('PO', 'POA_ORDER_BY');

145: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
146: p_index IN NUMBER) IS
147: BEGIN
148: p_param(p_index).Label :=
149: FND_MESSAGE.get_string('PO', 'POA_ORDER_BY');
150: Build_Selection('POA_BIS_MEASURE',
151: 'SELECT poc.lookup_code, poc.displayed_field
152: FROM po_lookup_codes poc
153: WHERE poc.lookup_type = ''POA BIS REPORT OPTION''

Line 194: FND_MESSAGE.get_string('PO', 'POA_OPERATING_UNIT');

190: l_where_clause := NULL;
191: END IF;
192:
193: p_param(p_index).Label :=
194: FND_MESSAGE.get_string('PO', 'POA_OPERATING_UNIT');
195: p_param(p_index).Value := htf.formText('POA_BIS_OPER_UNIT_NAME');
196: p_param(p_index).Action :=
197: '

Line 230: FND_MESSAGE.get_string('PO', 'POA_OPERATING_UNIT');

226: l_where_clause := NULL;
227: END IF;
228:
229: p_param(p_index).Label :=
230: FND_MESSAGE.get_string('PO', 'POA_OPERATING_UNIT');
231: p_param(p_index).Value := htf.formText('POA_BIS_PPS_OPER_UNIT_NAME');
232: p_param(p_index).Action :=
233: ' 251: ''POA_BIS_SAVINGS_RPT'',''RPTPFORM'','''','''','''')">

Line 263: FND_MESSAGE.get_string('PO', 'POA_COMMODITY');

259: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
260: p_index IN NUMBER) IS
261: BEGIN
262: p_param(p_index).Label :=
263: FND_MESSAGE.get_string('PO', 'POA_COMMODITY');
264: p_param(p_index).Value := htf.formText('POA_BIS_COMMODITY_NAME');
265: p_param(p_index).Action :=
266: '

Line 279: FND_MESSAGE.get_string('PO', 'POA_ITEM');

275: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
276: p_index IN NUMBER) IS
277: BEGIN
278: p_param(p_index).Label :=
279: FND_MESSAGE.get_string('PO', 'POA_ITEM');
280: p_param(p_index).Value := htf.formText('POA_BIS_ITEM_NAME');
281: p_param(p_index).Action :=
282: '

Line 295: FND_MESSAGE.get_string('PO', 'POA_SUPPLIER');

291: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
292: p_index IN NUMBER) IS
293: BEGIN
294: p_param(p_index).Label :=
295: FND_MESSAGE.get_string('PO', 'POA_SUPPLIER');
296: p_param(p_index).Value := htf.formText('POA_BIS_SUPPLIER_NAME');
297: p_param(p_index).Action :=
298: '

Line 311: FND_MESSAGE.get_string('PO', 'POA_PERIOD_TYPE');

307: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
308: p_index IN NUMBER) IS
309: BEGIN
310: p_param(p_index).Label :=
311: FND_MESSAGE.get_string('PO', 'POA_PERIOD_TYPE');
312: Build_Selection('POA_BIS_PERIOD_TYPE',
313: 'SELECT distinct gpt.period_type, gpt.user_period_type
314: FROM gl_period_types gpt, gl_periods glp
315: WHERE glp.period_set_name = (SELECT sob.period_set_name

Line 328: p_param(p_index).Label := FND_MESSAGE.get_string('POA', 'POA_VIEW_BY');

324: PROCEDURE Build_KPI_2PeriodType(
325: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
326: p_index IN NUMBER) IS
327: BEGIN
328: p_param(p_index).Label := FND_MESSAGE.get_string('POA', 'POA_VIEW_BY');
329: Build_Selection('POA_BIS_PERIOD_TYPE2',
330: 'SELECT FND_MESSAGE.get_string(''PO'',''POA_OPERATING_UNIT''),
331: FND_MESSAGE.get_string(''PO'',''POA_OPERATING_UNIT'')
332: FROM dual UNION ALL

Line 330: 'SELECT FND_MESSAGE.get_string(''PO'',''POA_OPERATING_UNIT''),

326: p_index IN NUMBER) IS
327: BEGIN
328: p_param(p_index).Label := FND_MESSAGE.get_string('POA', 'POA_VIEW_BY');
329: Build_Selection('POA_BIS_PERIOD_TYPE2',
330: 'SELECT FND_MESSAGE.get_string(''PO'',''POA_OPERATING_UNIT''),
331: FND_MESSAGE.get_string(''PO'',''POA_OPERATING_UNIT'')
332: FROM dual UNION ALL
333: SELECT FND_MESSAGE.get_string(''PO'',''POA_TIME''),
334: FND_MESSAGE.get_string(''PO'',''POA_TIME'') FROM dual',

Line 331: FND_MESSAGE.get_string(''PO'',''POA_OPERATING_UNIT'')

327: BEGIN
328: p_param(p_index).Label := FND_MESSAGE.get_string('POA', 'POA_VIEW_BY');
329: Build_Selection('POA_BIS_PERIOD_TYPE2',
330: 'SELECT FND_MESSAGE.get_string(''PO'',''POA_OPERATING_UNIT''),
331: FND_MESSAGE.get_string(''PO'',''POA_OPERATING_UNIT'')
332: FROM dual UNION ALL
333: SELECT FND_MESSAGE.get_string(''PO'',''POA_TIME''),
334: FND_MESSAGE.get_string(''PO'',''POA_TIME'') FROM dual',
335: p_param(p_index).Value);

Line 333: SELECT FND_MESSAGE.get_string(''PO'',''POA_TIME''),

329: Build_Selection('POA_BIS_PERIOD_TYPE2',
330: 'SELECT FND_MESSAGE.get_string(''PO'',''POA_OPERATING_UNIT''),
331: FND_MESSAGE.get_string(''PO'',''POA_OPERATING_UNIT'')
332: FROM dual UNION ALL
333: SELECT FND_MESSAGE.get_string(''PO'',''POA_TIME''),
334: FND_MESSAGE.get_string(''PO'',''POA_TIME'') FROM dual',
335: p_param(p_index).Value);
336: END Build_KPI_2PeriodType;
337:

Line 334: FND_MESSAGE.get_string(''PO'',''POA_TIME'') FROM dual',

330: 'SELECT FND_MESSAGE.get_string(''PO'',''POA_OPERATING_UNIT''),
331: FND_MESSAGE.get_string(''PO'',''POA_OPERATING_UNIT'')
332: FROM dual UNION ALL
333: SELECT FND_MESSAGE.get_string(''PO'',''POA_TIME''),
334: FND_MESSAGE.get_string(''PO'',''POA_TIME'') FROM dual',
335: p_param(p_index).Value);
336: END Build_KPI_2PeriodType;
337:
338: PROCEDURE Build_CTL_ViewBy(

Line 342: p_param(p_index).Label := FND_MESSAGE.get_string('POA', 'POA_VIEW_BY');

338: PROCEDURE Build_CTL_ViewBy(
339: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
340: p_index IN NUMBER) IS
341: BEGIN
342: p_param(p_index).Label := FND_MESSAGE.get_string('POA', 'POA_VIEW_BY');
343: Build_Selection('POA_BIS_VIEW_BY',
344: 'select FND_MESSAGE.get_string(''PO'', ''POA_LEAKAGE_TREND''),
345: FND_MESSAGE.get_string(''PO'', ''POA_LEAKAGE_TREND'')from sys.dual
346: union select FND_MESSAGE.get_string(''PO'', ''POA_EPS''),

Line 344: 'select FND_MESSAGE.get_string(''PO'', ''POA_LEAKAGE_TREND''),

340: p_index IN NUMBER) IS
341: BEGIN
342: p_param(p_index).Label := FND_MESSAGE.get_string('POA', 'POA_VIEW_BY');
343: Build_Selection('POA_BIS_VIEW_BY',
344: 'select FND_MESSAGE.get_string(''PO'', ''POA_LEAKAGE_TREND''),
345: FND_MESSAGE.get_string(''PO'', ''POA_LEAKAGE_TREND'')from sys.dual
346: union select FND_MESSAGE.get_string(''PO'', ''POA_EPS''),
347: FND_MESSAGE.get_string(''PO'', ''POA_EPS'')from sys.dual',
348: p_param(p_index).Value);

Line 345: FND_MESSAGE.get_string(''PO'', ''POA_LEAKAGE_TREND'')from sys.dual

341: BEGIN
342: p_param(p_index).Label := FND_MESSAGE.get_string('POA', 'POA_VIEW_BY');
343: Build_Selection('POA_BIS_VIEW_BY',
344: 'select FND_MESSAGE.get_string(''PO'', ''POA_LEAKAGE_TREND''),
345: FND_MESSAGE.get_string(''PO'', ''POA_LEAKAGE_TREND'')from sys.dual
346: union select FND_MESSAGE.get_string(''PO'', ''POA_EPS''),
347: FND_MESSAGE.get_string(''PO'', ''POA_EPS'')from sys.dual',
348: p_param(p_index).Value);
349: END Build_CTL_ViewBy;

Line 346: union select FND_MESSAGE.get_string(''PO'', ''POA_EPS''),

342: p_param(p_index).Label := FND_MESSAGE.get_string('POA', 'POA_VIEW_BY');
343: Build_Selection('POA_BIS_VIEW_BY',
344: 'select FND_MESSAGE.get_string(''PO'', ''POA_LEAKAGE_TREND''),
345: FND_MESSAGE.get_string(''PO'', ''POA_LEAKAGE_TREND'')from sys.dual
346: union select FND_MESSAGE.get_string(''PO'', ''POA_EPS''),
347: FND_MESSAGE.get_string(''PO'', ''POA_EPS'')from sys.dual',
348: p_param(p_index).Value);
349: END Build_CTL_ViewBy;
350:

Line 347: FND_MESSAGE.get_string(''PO'', ''POA_EPS'')from sys.dual',

343: Build_Selection('POA_BIS_VIEW_BY',
344: 'select FND_MESSAGE.get_string(''PO'', ''POA_LEAKAGE_TREND''),
345: FND_MESSAGE.get_string(''PO'', ''POA_LEAKAGE_TREND'')from sys.dual
346: union select FND_MESSAGE.get_string(''PO'', ''POA_EPS''),
347: FND_MESSAGE.get_string(''PO'', ''POA_EPS'')from sys.dual',
348: p_param(p_index).Value);
349: END Build_CTL_ViewBy;
350:
351: PROCEDURE Build_LSS_ViewBy(

Line 355: p_param(p_index).Label := FND_MESSAGE.get_string('POA', 'POA_VIEW_BY');

351: PROCEDURE Build_LSS_ViewBy(
352: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
353: p_index IN NUMBER) IS
354: BEGIN
355: p_param(p_index).Label := FND_MESSAGE.get_string('POA', 'POA_VIEW_BY');
356: Build_Selection('POA_BIS_VIEW_BY',
357: 'select FND_MESSAGE.get_string(''PO'', ''POA_SUPPLIER''),
358: FND_MESSAGE.get_string(''PO'', ''POA_SUPPLIER'')from sys.dual
359: union select FND_MESSAGE.get_string(''PO'', ''POA_ORGANIZATION''),

Line 357: 'select FND_MESSAGE.get_string(''PO'', ''POA_SUPPLIER''),

353: p_index IN NUMBER) IS
354: BEGIN
355: p_param(p_index).Label := FND_MESSAGE.get_string('POA', 'POA_VIEW_BY');
356: Build_Selection('POA_BIS_VIEW_BY',
357: 'select FND_MESSAGE.get_string(''PO'', ''POA_SUPPLIER''),
358: FND_MESSAGE.get_string(''PO'', ''POA_SUPPLIER'')from sys.dual
359: union select FND_MESSAGE.get_string(''PO'', ''POA_ORGANIZATION''),
360: FND_MESSAGE.get_string(''PO'', ''POA_ORGANIZATION'')from sys.dual
361: union select FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY''),

Line 358: FND_MESSAGE.get_string(''PO'', ''POA_SUPPLIER'')from sys.dual

354: BEGIN
355: p_param(p_index).Label := FND_MESSAGE.get_string('POA', 'POA_VIEW_BY');
356: Build_Selection('POA_BIS_VIEW_BY',
357: 'select FND_MESSAGE.get_string(''PO'', ''POA_SUPPLIER''),
358: FND_MESSAGE.get_string(''PO'', ''POA_SUPPLIER'')from sys.dual
359: union select FND_MESSAGE.get_string(''PO'', ''POA_ORGANIZATION''),
360: FND_MESSAGE.get_string(''PO'', ''POA_ORGANIZATION'')from sys.dual
361: union select FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY''),
362: FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY'')from sys.dual',

Line 359: union select FND_MESSAGE.get_string(''PO'', ''POA_ORGANIZATION''),

355: p_param(p_index).Label := FND_MESSAGE.get_string('POA', 'POA_VIEW_BY');
356: Build_Selection('POA_BIS_VIEW_BY',
357: 'select FND_MESSAGE.get_string(''PO'', ''POA_SUPPLIER''),
358: FND_MESSAGE.get_string(''PO'', ''POA_SUPPLIER'')from sys.dual
359: union select FND_MESSAGE.get_string(''PO'', ''POA_ORGANIZATION''),
360: FND_MESSAGE.get_string(''PO'', ''POA_ORGANIZATION'')from sys.dual
361: union select FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY''),
362: FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY'')from sys.dual',
363: p_param(p_index).Value);

Line 360: FND_MESSAGE.get_string(''PO'', ''POA_ORGANIZATION'')from sys.dual

356: Build_Selection('POA_BIS_VIEW_BY',
357: 'select FND_MESSAGE.get_string(''PO'', ''POA_SUPPLIER''),
358: FND_MESSAGE.get_string(''PO'', ''POA_SUPPLIER'')from sys.dual
359: union select FND_MESSAGE.get_string(''PO'', ''POA_ORGANIZATION''),
360: FND_MESSAGE.get_string(''PO'', ''POA_ORGANIZATION'')from sys.dual
361: union select FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY''),
362: FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY'')from sys.dual',
363: p_param(p_index).Value);
364: END Build_LSS_ViewBy;

Line 361: union select FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY''),

357: 'select FND_MESSAGE.get_string(''PO'', ''POA_SUPPLIER''),
358: FND_MESSAGE.get_string(''PO'', ''POA_SUPPLIER'')from sys.dual
359: union select FND_MESSAGE.get_string(''PO'', ''POA_ORGANIZATION''),
360: FND_MESSAGE.get_string(''PO'', ''POA_ORGANIZATION'')from sys.dual
361: union select FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY''),
362: FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY'')from sys.dual',
363: p_param(p_index).Value);
364: END Build_LSS_ViewBy;
365:

Line 362: FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY'')from sys.dual',

358: FND_MESSAGE.get_string(''PO'', ''POA_SUPPLIER'')from sys.dual
359: union select FND_MESSAGE.get_string(''PO'', ''POA_ORGANIZATION''),
360: FND_MESSAGE.get_string(''PO'', ''POA_ORGANIZATION'')from sys.dual
361: union select FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY''),
362: FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY'')from sys.dual',
363: p_param(p_index).Value);
364: END Build_LSS_ViewBy;
365:
366: PROCEDURE Build_SPA_ViewBy(

Line 370: p_param(p_index).Label := FND_MESSAGE.get_string('POA', 'POA_VIEW_BY');

366: PROCEDURE Build_SPA_ViewBy(
367: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
368: p_index IN NUMBER) IS
369: BEGIN
370: p_param(p_index).Label := FND_MESSAGE.get_string('POA', 'POA_VIEW_BY');
371: Build_Selection('POA_BIS_VIEW_BY',
372: 'select FND_MESSAGE.get_string(''PO'', ''POA_SUPPLIER''),
373: FND_MESSAGE.get_string(''PO'', ''POA_SUPPLIER'')from sys.dual
374: union select FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY''),

Line 372: 'select FND_MESSAGE.get_string(''PO'', ''POA_SUPPLIER''),

368: p_index IN NUMBER) IS
369: BEGIN
370: p_param(p_index).Label := FND_MESSAGE.get_string('POA', 'POA_VIEW_BY');
371: Build_Selection('POA_BIS_VIEW_BY',
372: 'select FND_MESSAGE.get_string(''PO'', ''POA_SUPPLIER''),
373: FND_MESSAGE.get_string(''PO'', ''POA_SUPPLIER'')from sys.dual
374: union select FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY''),
375: FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY'')from sys.dual
376: union select FND_MESSAGE.get_string(''PO'', ''POA_BUYER''),

Line 373: FND_MESSAGE.get_string(''PO'', ''POA_SUPPLIER'')from sys.dual

369: BEGIN
370: p_param(p_index).Label := FND_MESSAGE.get_string('POA', 'POA_VIEW_BY');
371: Build_Selection('POA_BIS_VIEW_BY',
372: 'select FND_MESSAGE.get_string(''PO'', ''POA_SUPPLIER''),
373: FND_MESSAGE.get_string(''PO'', ''POA_SUPPLIER'')from sys.dual
374: union select FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY''),
375: FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY'')from sys.dual
376: union select FND_MESSAGE.get_string(''PO'', ''POA_BUYER''),
377: FND_MESSAGE.get_string(''PO'', ''POA_BUYER'')from sys.dual

Line 374: union select FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY''),

370: p_param(p_index).Label := FND_MESSAGE.get_string('POA', 'POA_VIEW_BY');
371: Build_Selection('POA_BIS_VIEW_BY',
372: 'select FND_MESSAGE.get_string(''PO'', ''POA_SUPPLIER''),
373: FND_MESSAGE.get_string(''PO'', ''POA_SUPPLIER'')from sys.dual
374: union select FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY''),
375: FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY'')from sys.dual
376: union select FND_MESSAGE.get_string(''PO'', ''POA_BUYER''),
377: FND_MESSAGE.get_string(''PO'', ''POA_BUYER'')from sys.dual
378: union select FND_MESSAGE.get_string(''PO'', ''POA_OPERATING_UNIT''),

Line 375: FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY'')from sys.dual

371: Build_Selection('POA_BIS_VIEW_BY',
372: 'select FND_MESSAGE.get_string(''PO'', ''POA_SUPPLIER''),
373: FND_MESSAGE.get_string(''PO'', ''POA_SUPPLIER'')from sys.dual
374: union select FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY''),
375: FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY'')from sys.dual
376: union select FND_MESSAGE.get_string(''PO'', ''POA_BUYER''),
377: FND_MESSAGE.get_string(''PO'', ''POA_BUYER'')from sys.dual
378: union select FND_MESSAGE.get_string(''PO'', ''POA_OPERATING_UNIT''),
379: FND_MESSAGE.get_string(''PO'', ''POA_OPERATING_UNIT'')from sys.dual

Line 376: union select FND_MESSAGE.get_string(''PO'', ''POA_BUYER''),

372: 'select FND_MESSAGE.get_string(''PO'', ''POA_SUPPLIER''),
373: FND_MESSAGE.get_string(''PO'', ''POA_SUPPLIER'')from sys.dual
374: union select FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY''),
375: FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY'')from sys.dual
376: union select FND_MESSAGE.get_string(''PO'', ''POA_BUYER''),
377: FND_MESSAGE.get_string(''PO'', ''POA_BUYER'')from sys.dual
378: union select FND_MESSAGE.get_string(''PO'', ''POA_OPERATING_UNIT''),
379: FND_MESSAGE.get_string(''PO'', ''POA_OPERATING_UNIT'')from sys.dual
380: union select FND_MESSAGE.get_string(''PO'', ''POA_ITEM''),

Line 377: FND_MESSAGE.get_string(''PO'', ''POA_BUYER'')from sys.dual

373: FND_MESSAGE.get_string(''PO'', ''POA_SUPPLIER'')from sys.dual
374: union select FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY''),
375: FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY'')from sys.dual
376: union select FND_MESSAGE.get_string(''PO'', ''POA_BUYER''),
377: FND_MESSAGE.get_string(''PO'', ''POA_BUYER'')from sys.dual
378: union select FND_MESSAGE.get_string(''PO'', ''POA_OPERATING_UNIT''),
379: FND_MESSAGE.get_string(''PO'', ''POA_OPERATING_UNIT'')from sys.dual
380: union select FND_MESSAGE.get_string(''PO'', ''POA_ITEM''),
381: FND_MESSAGE.get_string(''PO'', ''POA_ITEM'')from sys.dual',

Line 378: union select FND_MESSAGE.get_string(''PO'', ''POA_OPERATING_UNIT''),

374: union select FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY''),
375: FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY'')from sys.dual
376: union select FND_MESSAGE.get_string(''PO'', ''POA_BUYER''),
377: FND_MESSAGE.get_string(''PO'', ''POA_BUYER'')from sys.dual
378: union select FND_MESSAGE.get_string(''PO'', ''POA_OPERATING_UNIT''),
379: FND_MESSAGE.get_string(''PO'', ''POA_OPERATING_UNIT'')from sys.dual
380: union select FND_MESSAGE.get_string(''PO'', ''POA_ITEM''),
381: FND_MESSAGE.get_string(''PO'', ''POA_ITEM'')from sys.dual',
382: p_param(p_index).Value);

Line 379: FND_MESSAGE.get_string(''PO'', ''POA_OPERATING_UNIT'')from sys.dual

375: FND_MESSAGE.get_string(''PO'', ''POA_COMMODITY'')from sys.dual
376: union select FND_MESSAGE.get_string(''PO'', ''POA_BUYER''),
377: FND_MESSAGE.get_string(''PO'', ''POA_BUYER'')from sys.dual
378: union select FND_MESSAGE.get_string(''PO'', ''POA_OPERATING_UNIT''),
379: FND_MESSAGE.get_string(''PO'', ''POA_OPERATING_UNIT'')from sys.dual
380: union select FND_MESSAGE.get_string(''PO'', ''POA_ITEM''),
381: FND_MESSAGE.get_string(''PO'', ''POA_ITEM'')from sys.dual',
382: p_param(p_index).Value);
383: END Build_SPA_ViewBy;

Line 380: union select FND_MESSAGE.get_string(''PO'', ''POA_ITEM''),

376: union select FND_MESSAGE.get_string(''PO'', ''POA_BUYER''),
377: FND_MESSAGE.get_string(''PO'', ''POA_BUYER'')from sys.dual
378: union select FND_MESSAGE.get_string(''PO'', ''POA_OPERATING_UNIT''),
379: FND_MESSAGE.get_string(''PO'', ''POA_OPERATING_UNIT'')from sys.dual
380: union select FND_MESSAGE.get_string(''PO'', ''POA_ITEM''),
381: FND_MESSAGE.get_string(''PO'', ''POA_ITEM'')from sys.dual',
382: p_param(p_index).Value);
383: END Build_SPA_ViewBy;
384:

Line 381: FND_MESSAGE.get_string(''PO'', ''POA_ITEM'')from sys.dual',

377: FND_MESSAGE.get_string(''PO'', ''POA_BUYER'')from sys.dual
378: union select FND_MESSAGE.get_string(''PO'', ''POA_OPERATING_UNIT''),
379: FND_MESSAGE.get_string(''PO'', ''POA_OPERATING_UNIT'')from sys.dual
380: union select FND_MESSAGE.get_string(''PO'', ''POA_ITEM''),
381: FND_MESSAGE.get_string(''PO'', ''POA_ITEM'')from sys.dual',
382: p_param(p_index).Value);
383: END Build_SPA_ViewBy;
384:
385: PROCEDURE Build_SavingsShipToOrg(

Line 408: FND_MESSAGE.get_string('PO', 'POA_SHIP_TO_ORG');

404: l_where_clause := NULL;
405: END IF;
406:
407: p_param(p_index).Label :=
408: FND_MESSAGE.get_string('PO', 'POA_SHIP_TO_ORG');
409: p_param(p_index).Value := htf.formText('POA_BIS_ORG_NAME');
410: p_param(p_index).Action :=
411: '

Line 474: nvl(FND_MESSAGE.get_string('PO', 'POA_REPORT_PARAM'), 'Report Parameters?')

470: IF p_param.count > 0 THEN
471: htp.p(' 472: width=672>
476:


473: ' ||
474: nvl(FND_MESSAGE.get_string('PO', 'POA_REPORT_PARAM'), 'Report Parameters?')
475: || '

' ||
477: nvl(FND_MESSAGE.get_string('PO', 'POA_INVALID_PARAM'), 'The following parameters are invalid?')
478: || '

');

Line 477: nvl(FND_MESSAGE.get_string('PO', 'POA_INVALID_PARAM'), 'The following parameters are invalid?')

473: ' ||
474: nvl(FND_MESSAGE.get_string('PO', 'POA_REPORT_PARAM'), 'Report Parameters?')
475: || '

476: ' ||
477: nvl(FND_MESSAGE.get_string('PO', 'POA_INVALID_PARAM'), 'The following parameters are invalid?')
478: || '
');
479: htp.tableOpen (calign => 'CENTER', cattributes => ' BORDER=0 WIDTH=96%');
480:
481: FOR l_count in 1..p_param.count LOOP