DBA Data[Home] [Help]

APPS.QA_SS_OM dependencies on HTP

Line 119: htp.p('Exception in procedure om_headers_to_quality');

115: List_OM_Plans(plan_tab, pk1, null);
116: end if; -- end icx validate session
117: EXCEPTION
118: WHEN OTHERS THEN
119: htp.p('Exception in procedure om_headers_to_quality');
120: htp.p(SQLERRM);
121:
122: END om_header_to_quality;
123:

Line 120: htp.p(SQLERRM);

116: end if; -- end icx validate session
117: EXCEPTION
118: WHEN OTHERS THEN
119: htp.p('Exception in procedure om_headers_to_quality');
120: htp.p(SQLERRM);
121:
122: END om_header_to_quality;
123:
124: ------------------------------------------------------------------------------------------

Line 186: htp.p('Exception in procedure om_lines_to_quality');

182:
183: end if; -- end icx validate session
184: EXCEPTION
185: WHEN OTHERS THEN
186: htp.p('Exception in procedure om_lines_to_quality');
187: htp.p(SQLERRM);
188:
189: END om_lines_to_quality;
190:

Line 187: htp.p(SQLERRM);

183: end if; -- end icx validate session
184: EXCEPTION
185: WHEN OTHERS THEN
186: htp.p('Exception in procedure om_lines_to_quality');
187: htp.p(SQLERRM);
188:
189: END om_lines_to_quality;
190:
191: ------------------------------------------------------------------------------------------

Line 212: htp.htmlOpen;

208: BEGIN
209: if (icx_sec.validatesession) then
210: l_language_code := icx_sec.getid(icx_sec.pv_language_code);
211:
212: htp.htmlOpen;
213: htp.p('');
214: htp.formOpen('');
215: htp.br;
216: htp.tableOpen(cborder=>'BORDER=2', cattributes=>'CELLPADDING=2');

Line 213: htp.p('');

209: if (icx_sec.validatesession) then
210: l_language_code := icx_sec.getid(icx_sec.pv_language_code);
211:
212: htp.htmlOpen;
213: htp.p('');
214: htp.formOpen('');
215: htp.br;
216: htp.tableOpen(cborder=>'BORDER=2', cattributes=>'CELLPADDING=2');
217: htp.tableCaption(fnd_message.get_string('QA','QA_SS_COLL_PLANS'));

Line 214: htp.formOpen('');

210: l_language_code := icx_sec.getid(icx_sec.pv_language_code);
211:
212: htp.htmlOpen;
213: htp.p('');
214: htp.formOpen('');
215: htp.br;
216: htp.tableOpen(cborder=>'BORDER=2', cattributes=>'CELLPADDING=2');
217: htp.tableCaption(fnd_message.get_string('QA','QA_SS_COLL_PLANS'));
218: htp.tableRowOpen (cattributes=>'BGCOLOR="#336699"');

Line 215: htp.br;

211:
212: htp.htmlOpen;
213: htp.p('');
214: htp.formOpen('');
215: htp.br;
216: htp.tableOpen(cborder=>'BORDER=2', cattributes=>'CELLPADDING=2');
217: htp.tableCaption(fnd_message.get_string('QA','QA_SS_COLL_PLANS'));
218: htp.tableRowOpen (cattributes=>'BGCOLOR="#336699"');
219: htp.tableHeader(cvalue=>''||

Line 216: htp.tableOpen(cborder=>'BORDER=2', cattributes=>'CELLPADDING=2');

212: htp.htmlOpen;
213: htp.p('');
214: htp.formOpen('');
215: htp.br;
216: htp.tableOpen(cborder=>'BORDER=2', cattributes=>'CELLPADDING=2');
217: htp.tableCaption(fnd_message.get_string('QA','QA_SS_COLL_PLANS'));
218: htp.tableRowOpen (cattributes=>'BGCOLOR="#336699"');
219: htp.tableHeader(cvalue=>''||
220: fnd_message.get_string('QA', 'QA_SS_CP_HEADING')

Line 217: htp.tableCaption(fnd_message.get_string('QA','QA_SS_COLL_PLANS'));

213: htp.p('');
214: htp.formOpen('');
215: htp.br;
216: htp.tableOpen(cborder=>'BORDER=2', cattributes=>'CELLPADDING=2');
217: htp.tableCaption(fnd_message.get_string('QA','QA_SS_COLL_PLANS'));
218: htp.tableRowOpen (cattributes=>'BGCOLOR="#336699"');
219: htp.tableHeader(cvalue=>''||
220: fnd_message.get_string('QA', 'QA_SS_CP_HEADING')
221: || '
', calign=>'CENTER');

Line 218: htp.tableRowOpen (cattributes=>'BGCOLOR="#336699"');

214: htp.formOpen('');
215: htp.br;
216: htp.tableOpen(cborder=>'BORDER=2', cattributes=>'CELLPADDING=2');
217: htp.tableCaption(fnd_message.get_string('QA','QA_SS_COLL_PLANS'));
218: htp.tableRowOpen (cattributes=>'BGCOLOR="#336699"');
219: htp.tableHeader(cvalue=>''||
220: fnd_message.get_string('QA', 'QA_SS_CP_HEADING')
221: || '
', calign=>'CENTER');
222: htp.tableHeader(cvalue=>''||

Line 219: htp.tableHeader(cvalue=>''||

215: htp.br;
216: htp.tableOpen(cborder=>'BORDER=2', cattributes=>'CELLPADDING=2');
217: htp.tableCaption(fnd_message.get_string('QA','QA_SS_COLL_PLANS'));
218: htp.tableRowOpen (cattributes=>'BGCOLOR="#336699"');
219: htp.tableHeader(cvalue=>''||
220: fnd_message.get_string('QA', 'QA_SS_CP_HEADING')
221: || '
', calign=>'CENTER');
222: htp.tableHeader(cvalue=>''||
223: fnd_message.get_string('QA', 'QA_SS_DESC'), calign=>'CENTER');

Line 222: htp.tableHeader(cvalue=>''||

218: htp.tableRowOpen (cattributes=>'BGCOLOR="#336699"');
219: htp.tableHeader(cvalue=>''||
220: fnd_message.get_string('QA', 'QA_SS_CP_HEADING')
221: || '
', calign=>'CENTER');
222: htp.tableHeader(cvalue=>''||
223: fnd_message.get_string('QA', 'QA_SS_DESC'), calign=>'CENTER');
224: htp.tableHeader(cvalue=>''||
225: 'Type'|| '
', calign=>'CENTER');
226: htp.tableHeader(cvalue=>''||

Line 224: htp.tableHeader(cvalue=>''||

220: fnd_message.get_string('QA', 'QA_SS_CP_HEADING')
221: || '
', calign=>'CENTER');
222: htp.tableHeader(cvalue=>''||
223: fnd_message.get_string('QA', 'QA_SS_DESC'), calign=>'CENTER');
224: htp.tableHeader(cvalue=>''||
225: 'Type'|| '', calign=>'CENTER');
226: htp.tableHeader(cvalue=>''||
227: fnd_message.get_string('QA', 'QA_SS_VIEW_BUTTON')|| '
', calign=>'CENTER');
228: htp.tableRowClose;

Line 226: htp.tableHeader(cvalue=>''||

222: htp.tableHeader(cvalue=>''||
223: fnd_message.get_string('QA', 'QA_SS_DESC'), calign=>'CENTER');
224: htp.tableHeader(cvalue=>''||
225: 'Type'|| '
', calign=>'CENTER');
226: htp.tableHeader(cvalue=>''||
227: fnd_message.get_string('QA', 'QA_SS_VIEW_BUTTON')|| '', calign=>'CENTER');
228: htp.tableRowClose;
229: htp.p('');
230:

Line 228: htp.tableRowClose;

224: htp.tableHeader(cvalue=>''||
225: 'Type'|| '
', calign=>'CENTER');
226: htp.tableHeader(cvalue=>''||
227: fnd_message.get_string('QA', 'QA_SS_VIEW_BUTTON')|| '
', calign=>'CENTER');
228: htp.tableRowClose;
229: htp.p('');
230:
231: -- Construct the where clause here
232: om_where_cl := 'so_header_id='||p_so_header_id;

Line 229: htp.p('');

225: 'Type'|| '', calign=>'CENTER');
226: htp.tableHeader(cvalue=>''||
227: fnd_message.get_string('QA', 'QA_SS_VIEW_BUTTON')|| '
', calign=>'CENTER');
228: htp.tableRowClose;
229: htp.p('');
230:
231: -- Construct the where clause here
232: om_where_cl := 'so_header_id='||p_so_header_id;
233:

Line 260: htp.tableRowOpen(cattributes=>'BGCOLOR="#99CCFF"');

256: pdesc := NVL(substr(plan_tab(i).description,1,20), ' ');
257: ptype := NVL(substr(plan_tab(i).meaning,1,20), ' ');
258:
259: IF (row_color = 'BLUE') THEN
260: htp.tableRowOpen(cattributes=>'BGCOLOR="#99CCFF"');
261: row_color := 'WHITE';
262: ELSE
263: htp.tableRowOpen(cattributes=>'BGCOLOR="#FFFFFF"');
264: row_color := 'BLUE';

Line 263: htp.tableRowOpen(cattributes=>'BGCOLOR="#FFFFFF"');

259: IF (row_color = 'BLUE') THEN
260: htp.tableRowOpen(cattributes=>'BGCOLOR="#99CCFF"');
261: row_color := 'WHITE';
262: ELSE
263: htp.tableRowOpen(cattributes=>'BGCOLOR="#FFFFFF"');
264: row_color := 'BLUE';
265: END IF; -- end if for row color
266:
267: htp.tableData(pname);

Line 267: htp.tableData(pname);

263: htp.tableRowOpen(cattributes=>'BGCOLOR="#FFFFFF"');
264: row_color := 'BLUE';
265: END IF; -- end if for row color
266:
267: htp.tableData(pname);
268: htp.tableData(pdesc);
269: htp.tableData(ptype);
270:
271: htp.tableData(htf.anchor(viewurl, fnd_message.get_string('QA','QA_SS_VIEW_BUTTON'), cattributes=>'TARGET="viewwin"'));

Line 268: htp.tableData(pdesc);

264: row_color := 'BLUE';
265: END IF; -- end if for row color
266:
267: htp.tableData(pname);
268: htp.tableData(pdesc);
269: htp.tableData(ptype);
270:
271: htp.tableData(htf.anchor(viewurl, fnd_message.get_string('QA','QA_SS_VIEW_BUTTON'), cattributes=>'TARGET="viewwin"'));
272:

Line 269: htp.tableData(ptype);

265: END IF; -- end if for row color
266:
267: htp.tableData(pname);
268: htp.tableData(pdesc);
269: htp.tableData(ptype);
270:
271: htp.tableData(htf.anchor(viewurl, fnd_message.get_string('QA','QA_SS_VIEW_BUTTON'), cattributes=>'TARGET="viewwin"'));
272:
273:

Line 271: htp.tableData(htf.anchor(viewurl, fnd_message.get_string('QA','QA_SS_VIEW_BUTTON'), cattributes=>'TARGET="viewwin"'));

267: htp.tableData(pname);
268: htp.tableData(pdesc);
269: htp.tableData(ptype);
270:
271: htp.tableData(htf.anchor(viewurl, fnd_message.get_string('QA','QA_SS_VIEW_BUTTON'), cattributes=>'TARGET="viewwin"'));
272:
273:
274: End Loop; -- end of forloop for all rows in list of plans
275: htp.tableClose;

Line 275: htp.tableClose;

271: htp.tableData(htf.anchor(viewurl, fnd_message.get_string('QA','QA_SS_VIEW_BUTTON'), cattributes=>'TARGET="viewwin"'));
272:
273:
274: End Loop; -- end of forloop for all rows in list of plans
275: htp.tableClose;
276: htp.formClose;
277: htp.bodyClose;
278: htp.htmlClose;
279:

Line 276: htp.formClose;

272:
273:
274: End Loop; -- end of forloop for all rows in list of plans
275: htp.tableClose;
276: htp.formClose;
277: htp.bodyClose;
278: htp.htmlClose;
279:
280: end if; -- end icx validate session

Line 277: htp.bodyClose;

273:
274: End Loop; -- end of forloop for all rows in list of plans
275: htp.tableClose;
276: htp.formClose;
277: htp.bodyClose;
278: htp.htmlClose;
279:
280: end if; -- end icx validate session
281:

Line 278: htp.htmlClose;

274: End Loop; -- end of forloop for all rows in list of plans
275: htp.tableClose;
276: htp.formClose;
277: htp.bodyClose;
278: htp.htmlClose;
279:
280: end if; -- end icx validate session
281:
282: EXCEPTION

Line 284: htp.p('Exception in procedure qa_ss_om.list_om_plans');

280: end if; -- end icx validate session
281:
282: EXCEPTION
283: WHEN OTHERS THEN
284: htp.p('Exception in procedure qa_ss_om.list_om_plans');
285: htp.p(SQLERRM);
286:
287: END List_OM_Plans;
288:

Line 285: htp.p(SQLERRM);

281:
282: EXCEPTION
283: WHEN OTHERS THEN
284: htp.p('Exception in procedure qa_ss_om.list_om_plans');
285: htp.p(SQLERRM);
286:
287: END List_OM_Plans;
288:
289: