eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QPR_WKFL_UTIL dependencies on FND_MESSAGE

Line 374: l_document := l_document || print_heading(fnd_message.get_String('QPR', 'QPR_DEAL_SUMMARY'));

370:
371: l_document := l_document || '' || NL;
373:
374: l_document := l_document || print_heading(fnd_message.get_String('QPR', 'QPR_DEAL_SUMMARY'));
375: l_document := l_document || '';
376: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_REQUEST_NO')) || NL;
377: l_document := l_document || get_table_cell(l_request_hdr_id) || '' || NL;
378: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_CUSTOMER')) || NL;

Line 376: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_REQUEST_NO')) || NL;

372: '/OA_HTML/PORSTYL2.css" TYPE=text/css>' || NL;
373:
374: l_document := l_document || print_heading(fnd_message.get_String('QPR', 'QPR_DEAL_SUMMARY'));
375: l_document := l_document || '';
376: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_REQUEST_NO')) || NL;
377: l_document := l_document || get_table_cell(l_request_hdr_id) || '' || NL;
378: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_CUSTOMER')) || NL;
379: l_document := l_document || get_table_cell(l_cus_name) || '' || NL;
380: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR', 'QPR_REFERENCE')) || NL;

Line 378: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_CUSTOMER')) || NL;

374: l_document := l_document || print_heading(fnd_message.get_String('QPR', 'QPR_DEAL_SUMMARY'));
375: l_document := l_document || '';
376: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_REQUEST_NO')) || NL;
377: l_document := l_document || get_table_cell(l_request_hdr_id) || '' || NL;
378: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_CUSTOMER')) || NL;
379: l_document := l_document || get_table_cell(l_cus_name) || '' || NL;
380: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR', 'QPR_REFERENCE')) || NL;
381: l_document := l_document || get_table_cell(l_ref_name) || '' || NL;
382: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_STATUS')) || NL;

Line 380: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR', 'QPR_REFERENCE')) || NL;

376: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_REQUEST_NO')) || NL;
377: l_document := l_document || get_table_cell(l_request_hdr_id) || '' || NL;
378: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_CUSTOMER')) || NL;
379: l_document := l_document || get_table_cell(l_cus_name) || '' || NL;
380: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR', 'QPR_REFERENCE')) || NL;
381: l_document := l_document || get_table_cell(l_ref_name) || '' || NL;
382: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_STATUS')) || NL;
383: l_document := l_document || get_table_cell(l_hdr_status) || '' || NL;
384: l_document := l_document || '' || get_table_label(fnd_message.get_string('QPR', 'QPR_SCORE')) || NL;

Line 382: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_STATUS')) || NL;

378: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_CUSTOMER')) || NL;
379: l_document := l_document || get_table_cell(l_cus_name) || '' || NL;
380: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR', 'QPR_REFERENCE')) || NL;
381: l_document := l_document || get_table_cell(l_ref_name) || '' || NL;
382: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_STATUS')) || NL;
383: l_document := l_document || get_table_cell(l_hdr_status) || '' || NL;
384: l_document := l_document || '' || get_table_label(fnd_message.get_string('QPR', 'QPR_SCORE')) || NL;
385: l_document := l_document || get_table_cell(l_hdr_score) || '' || NL;
386: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_SCENARIO')) || NL;

Line 384: l_document := l_document || '' || get_table_label(fnd_message.get_string('QPR', 'QPR_SCORE')) || NL;

380: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR', 'QPR_REFERENCE')) || NL;
381: l_document := l_document || get_table_cell(l_ref_name) || '' || NL;
382: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_STATUS')) || NL;
383: l_document := l_document || get_table_cell(l_hdr_status) || '' || NL;
384: l_document := l_document || '' || get_table_label(fnd_message.get_string('QPR', 'QPR_SCORE')) || NL;
385: l_document := l_document || get_table_cell(l_hdr_score) || '' || NL;
386: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_SCENARIO')) || NL;
387: l_document := l_document || get_table_cell(l_version_no) || '' || NL;
388: l_document := l_document || '' || get_table_label(fnd_message.get_string('QPR', 'QPR_REQUESTOR')) || NL;

Line 386: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_SCENARIO')) || NL;

382: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_STATUS')) || NL;
383: l_document := l_document || get_table_cell(l_hdr_status) || '' || NL;
384: l_document := l_document || '' || get_table_label(fnd_message.get_string('QPR', 'QPR_SCORE')) || NL;
385: l_document := l_document || get_table_cell(l_hdr_score) || '' || NL;
386: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_SCENARIO')) || NL;
387: l_document := l_document || get_table_cell(l_version_no) || '' || NL;
388: l_document := l_document || '' || get_table_label(fnd_message.get_string('QPR', 'QPR_REQUESTOR')) || NL;
389: l_document := l_document || get_table_cell(l_rep_name) || '' || NL;
390: l_document := l_document || '' || get_table_label(fnd_message.get_string('QPR', 'QPR_REQ_DATE')) || NL;

Line 388: l_document := l_document || '' || get_table_label(fnd_message.get_string('QPR', 'QPR_REQUESTOR')) || NL;

384: l_document := l_document || '' || get_table_label(fnd_message.get_string('QPR', 'QPR_SCORE')) || NL;
385: l_document := l_document || get_table_cell(l_hdr_score) || '' || NL;
386: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_SCENARIO')) || NL;
387: l_document := l_document || get_table_cell(l_version_no) || '' || NL;
388: l_document := l_document || '' || get_table_label(fnd_message.get_string('QPR', 'QPR_REQUESTOR')) || NL;
389: l_document := l_document || get_table_cell(l_rep_name) || '' || NL;
390: l_document := l_document || '' || get_table_label(fnd_message.get_string('QPR', 'QPR_REQ_DATE')) || NL;
391: l_document := l_document || get_table_cell(l_req_date) || '' || NL;
392: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR', 'QPR_CURRENCY')) || NL;

Line 390: l_document := l_document || '' || get_table_label(fnd_message.get_string('QPR', 'QPR_REQ_DATE')) || NL;

386: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_SCENARIO')) || NL;
387: l_document := l_document || get_table_cell(l_version_no) || '' || NL;
388: l_document := l_document || '' || get_table_label(fnd_message.get_string('QPR', 'QPR_REQUESTOR')) || NL;
389: l_document := l_document || get_table_cell(l_rep_name) || '' || NL;
390: l_document := l_document || '' || get_table_label(fnd_message.get_string('QPR', 'QPR_REQ_DATE')) || NL;
391: l_document := l_document || get_table_cell(l_req_date) || '' || NL;
392: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR', 'QPR_CURRENCY')) || NL;
393: l_document := l_document || get_table_cell(l_hdr_curr) || '' || NL;
394: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR', 'QPR_DEAL_DESC'))|| NL;

Line 392: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR', 'QPR_CURRENCY')) || NL;

388: l_document := l_document || '' || get_table_label(fnd_message.get_string('QPR', 'QPR_REQUESTOR')) || NL;
389: l_document := l_document || get_table_cell(l_rep_name) || '' || NL;
390: l_document := l_document || '' || get_table_label(fnd_message.get_string('QPR', 'QPR_REQ_DATE')) || NL;
391: l_document := l_document || get_table_cell(l_req_date) || '' || NL;
392: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR', 'QPR_CURRENCY')) || NL;
393: l_document := l_document || get_table_cell(l_hdr_curr) || '' || NL;
394: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR', 'QPR_DEAL_DESC'))|| NL;
395: l_document := l_document || get_table_cell(l_description) || '' || NL;
396: l_document := l_document ||'';

Line 394: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR', 'QPR_DEAL_DESC'))|| NL;

390: l_document := l_document || '' || get_table_label(fnd_message.get_string('QPR', 'QPR_REQ_DATE')) || NL;
391: l_document := l_document || get_table_cell(l_req_date) || '' || NL;
392: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR', 'QPR_CURRENCY')) || NL;
393: l_document := l_document || get_table_cell(l_hdr_curr) || '' || NL;
394: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR', 'QPR_DEAL_DESC'))|| NL;
395: l_document := l_document || get_table_cell(l_description) || '' || NL;
396: l_document := l_document ||'';
397: l_document := l_document ||'

';
398:

Line 419: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_LINE_NO'))|| NL;

415: exit when t_line_det.LINE_NUM.count = 0;
416: if b_first then
417: l_document := l_document || '';
418: l_document := l_document || '';
419: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_LINE_NO'))|| NL;
420: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_SEGMENT'))|| NL;
421: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_PRODUCT'))|| NL;
422: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_UOM'))|| NL;
423: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_PROPOSED_VOL'))|| NL;

Line 420: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_SEGMENT'))|| NL;

416: if b_first then
417: l_document := l_document || '';
418: l_document := l_document || '';
419: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_LINE_NO'))|| NL;
420: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_SEGMENT'))|| NL;
421: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_PRODUCT'))|| NL;
422: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_UOM'))|| NL;
423: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_PROPOSED_VOL'))|| NL;
424: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_LIST_PRICE'))|| NL;

Line 421: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_PRODUCT'))|| NL;

417: l_document := l_document || '';
418: l_document := l_document || '';
419: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_LINE_NO'))|| NL;
420: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_SEGMENT'))|| NL;
421: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_PRODUCT'))|| NL;
422: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_UOM'))|| NL;
423: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_PROPOSED_VOL'))|| NL;
424: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_LIST_PRICE'))|| NL;
425: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_PROPOSED_PRICE'))|| NL;

Line 422: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_UOM'))|| NL;

418: l_document := l_document || '';
419: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_LINE_NO'))|| NL;
420: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_SEGMENT'))|| NL;
421: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_PRODUCT'))|| NL;
422: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_UOM'))|| NL;
423: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_PROPOSED_VOL'))|| NL;
424: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_LIST_PRICE'))|| NL;
425: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_PROPOSED_PRICE'))|| NL;
426: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_REVISED_VOLUME'))|| NL;

Line 423: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_PROPOSED_VOL'))|| NL;

419: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_LINE_NO'))|| NL;
420: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_SEGMENT'))|| NL;
421: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_PRODUCT'))|| NL;
422: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_UOM'))|| NL;
423: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_PROPOSED_VOL'))|| NL;
424: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_LIST_PRICE'))|| NL;
425: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_PROPOSED_PRICE'))|| NL;
426: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_REVISED_VOLUME'))|| NL;
427: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_ONADJ_PERC'))|| NL;

Line 424: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_LIST_PRICE'))|| NL;

420: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_SEGMENT'))|| NL;
421: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_PRODUCT'))|| NL;
422: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_UOM'))|| NL;
423: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_PROPOSED_VOL'))|| NL;
424: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_LIST_PRICE'))|| NL;
425: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_PROPOSED_PRICE'))|| NL;
426: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_REVISED_VOLUME'))|| NL;
427: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_ONADJ_PERC'))|| NL;
428: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_REVISED_PRICE'))|| NL;

Line 425: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_PROPOSED_PRICE'))|| NL;

421: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_PRODUCT'))|| NL;
422: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_UOM'))|| NL;
423: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_PROPOSED_VOL'))|| NL;
424: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_LIST_PRICE'))|| NL;
425: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_PROPOSED_PRICE'))|| NL;
426: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_REVISED_VOLUME'))|| NL;
427: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_ONADJ_PERC'))|| NL;
428: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_REVISED_PRICE'))|| NL;
429: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_RECOMMEND_PRICE'))|| NL;

Line 426: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_REVISED_VOLUME'))|| NL;

422: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_UOM'))|| NL;
423: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_PROPOSED_VOL'))|| NL;
424: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_LIST_PRICE'))|| NL;
425: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_PROPOSED_PRICE'))|| NL;
426: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_REVISED_VOLUME'))|| NL;
427: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_ONADJ_PERC'))|| NL;
428: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_REVISED_PRICE'))|| NL;
429: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_RECOMMEND_PRICE'))|| NL;
430: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_INV_REV'))|| NL;

Line 427: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_ONADJ_PERC'))|| NL;

423: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_PROPOSED_VOL'))|| NL;
424: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_LIST_PRICE'))|| NL;
425: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_PROPOSED_PRICE'))|| NL;
426: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_REVISED_VOLUME'))|| NL;
427: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_ONADJ_PERC'))|| NL;
428: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_REVISED_PRICE'))|| NL;
429: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_RECOMMEND_PRICE'))|| NL;
430: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_INV_REV'))|| NL;
431: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_OFFADJ_AMT'))|| NL;

Line 428: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_REVISED_PRICE'))|| NL;

424: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_LIST_PRICE'))|| NL;
425: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_PROPOSED_PRICE'))|| NL;
426: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_REVISED_VOLUME'))|| NL;
427: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_ONADJ_PERC'))|| NL;
428: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_REVISED_PRICE'))|| NL;
429: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_RECOMMEND_PRICE'))|| NL;
430: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_INV_REV'))|| NL;
431: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_OFFADJ_AMT'))|| NL;
432: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_POC_REV'))|| NL;

Line 429: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_RECOMMEND_PRICE'))|| NL;

425: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_PROPOSED_PRICE'))|| NL;
426: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_REVISED_VOLUME'))|| NL;
427: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_ONADJ_PERC'))|| NL;
428: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_REVISED_PRICE'))|| NL;
429: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_RECOMMEND_PRICE'))|| NL;
430: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_INV_REV'))|| NL;
431: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_OFFADJ_AMT'))|| NL;
432: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_POC_REV'))|| NL;
433: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_UNIT_COST'))|| NL;

Line 430: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_INV_REV'))|| NL;

426: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_REVISED_VOLUME'))|| NL;
427: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_ONADJ_PERC'))|| NL;
428: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_REVISED_PRICE'))|| NL;
429: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_RECOMMEND_PRICE'))|| NL;
430: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_INV_REV'))|| NL;
431: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_OFFADJ_AMT'))|| NL;
432: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_POC_REV'))|| NL;
433: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_UNIT_COST'))|| NL;
434: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_MAR_AMT'))|| NL;

Line 431: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_OFFADJ_AMT'))|| NL;

427: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_ONADJ_PERC'))|| NL;
428: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_REVISED_PRICE'))|| NL;
429: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_RECOMMEND_PRICE'))|| NL;
430: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_INV_REV'))|| NL;
431: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_OFFADJ_AMT'))|| NL;
432: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_POC_REV'))|| NL;
433: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_UNIT_COST'))|| NL;
434: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_MAR_AMT'))|| NL;
435: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_MAR_PERC'))|| NL;

Line 432: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_POC_REV'))|| NL;

428: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_REVISED_PRICE'))|| NL;
429: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_RECOMMEND_PRICE'))|| NL;
430: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_INV_REV'))|| NL;
431: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_OFFADJ_AMT'))|| NL;
432: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_POC_REV'))|| NL;
433: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_UNIT_COST'))|| NL;
434: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_MAR_AMT'))|| NL;
435: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_MAR_PERC'))|| NL;
436: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_LINE_SCORE'))|| NL;

Line 433: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_UNIT_COST'))|| NL;

429: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_RECOMMEND_PRICE'))|| NL;
430: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_INV_REV'))|| NL;
431: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_OFFADJ_AMT'))|| NL;
432: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_POC_REV'))|| NL;
433: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_UNIT_COST'))|| NL;
434: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_MAR_AMT'))|| NL;
435: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_MAR_PERC'))|| NL;
436: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_LINE_SCORE'))|| NL;
437: l_document := l_document || '';

Line 434: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_MAR_AMT'))|| NL;

430: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_INV_REV'))|| NL;
431: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_OFFADJ_AMT'))|| NL;
432: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_POC_REV'))|| NL;
433: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_UNIT_COST'))|| NL;
434: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_MAR_AMT'))|| NL;
435: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_MAR_PERC'))|| NL;
436: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_LINE_SCORE'))|| NL;
437: l_document := l_document || '';
438:

Line 435: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_MAR_PERC'))|| NL;

431: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_OFFADJ_AMT'))|| NL;
432: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_POC_REV'))|| NL;
433: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_UNIT_COST'))|| NL;
434: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_MAR_AMT'))|| NL;
435: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_MAR_PERC'))|| NL;
436: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_LINE_SCORE'))|| NL;
437: l_document := l_document || '';
438:
439: Wf_notification.WriteToClob(p_blob, l_document);

Line 436: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_LINE_SCORE'))|| NL;

432: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_POC_REV'))|| NL;
433: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_UNIT_COST'))|| NL;
434: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_MAR_AMT'))|| NL;
435: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_MAR_PERC'))|| NL;
436: l_document := l_document || get_table_header(fnd_message.get_String('QPR','QPR_LINE_SCORE'))|| NL;
437: l_document := l_document || '';
438:
439: Wf_notification.WriteToClob(p_blob, l_document);
440: b_first := false;

Line 548: fnd_message.set_name('QPR', 'QPR_DEAL_APP');

544: l_url := l_base_href ||
545: '/OA_HTML/OA.jsp?OAFunc=QPR_DEAL_WORKBENCH&RESPONSE_HEADER_ID=' || l_resp_hdr_id || '&READ_ONLY=True&RESET=True';
546:
547: /*
548: fnd_message.set_name('QPR', 'QPR_DEAL_APP');
549: fnd_message.set_token('DEAL_ID', l_resp_hdr_id);
550: l_hdr_msg := fnd_message.get;*/
551:
552: if display_type = 'text/html' then

Line 549: fnd_message.set_token('DEAL_ID', l_resp_hdr_id);

545: '/OA_HTML/OA.jsp?OAFunc=QPR_DEAL_WORKBENCH&RESPONSE_HEADER_ID=' || l_resp_hdr_id || '&READ_ONLY=True&RESET=True';
546:
547: /*
548: fnd_message.set_name('QPR', 'QPR_DEAL_APP');
549: fnd_message.set_token('DEAL_ID', l_resp_hdr_id);
550: l_hdr_msg := fnd_message.get;*/
551:
552: if display_type = 'text/html' then
553: -- l_document := l_document || '
' || l_hdr_msg || NL;

Line 550: l_hdr_msg := fnd_message.get;*/

546:
547: /*
548: fnd_message.set_name('QPR', 'QPR_DEAL_APP');
549: fnd_message.set_token('DEAL_ID', l_resp_hdr_id);
550: l_hdr_msg := fnd_message.get;*/
551:
552: if display_type = 'text/html' then
553: -- l_document := l_document || '
' || l_hdr_msg || NL;
554: l_document := l_document || '
';

Line 556: l_document := l_document || print_heading(fnd_message.get_String('QPR', 'QPR_DEAL_SUMMARY'));

552: if display_type = 'text/html' then
553: -- l_document := l_document || '
' || l_hdr_msg || NL;
554: l_document := l_document || '
';
555: l_document := l_document || NL || ''|| NL || NL || '

';
556: l_document := l_document || print_heading(fnd_message.get_String('QPR', 'QPR_DEAL_SUMMARY'));
557: l_document := l_document || '';
558: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_REQUEST_NO')) || NL;
559: l_document := l_document || get_table_cell(l_request_hdr_id) || '' || NL;
560: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_CUSTOMER')) || NL;

Line 558: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_REQUEST_NO')) || NL;

554: l_document := l_document || '
';
555: l_document := l_document || NL || ''|| NL || NL || '

';
556: l_document := l_document || print_heading(fnd_message.get_String('QPR', 'QPR_DEAL_SUMMARY'));
557: l_document := l_document || '';
558: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_REQUEST_NO')) || NL;
559: l_document := l_document || get_table_cell(l_request_hdr_id) || '' || NL;
560: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_CUSTOMER')) || NL;
561: l_document := l_document || get_table_cell(l_cus_name) || '' || NL;
562: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR', 'QPR_REFERENCE')) || NL;

Line 560: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_CUSTOMER')) || NL;

556: l_document := l_document || print_heading(fnd_message.get_String('QPR', 'QPR_DEAL_SUMMARY'));
557: l_document := l_document || '';
558: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_REQUEST_NO')) || NL;
559: l_document := l_document || get_table_cell(l_request_hdr_id) || '' || NL;
560: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_CUSTOMER')) || NL;
561: l_document := l_document || get_table_cell(l_cus_name) || '' || NL;
562: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR', 'QPR_REFERENCE')) || NL;
563: l_document := l_document || get_table_cell(l_ref_name) || '' || NL;
564: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_STATUS')) || NL;

Line 562: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR', 'QPR_REFERENCE')) || NL;

558: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_REQUEST_NO')) || NL;
559: l_document := l_document || get_table_cell(l_request_hdr_id) || '' || NL;
560: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_CUSTOMER')) || NL;
561: l_document := l_document || get_table_cell(l_cus_name) || '' || NL;
562: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR', 'QPR_REFERENCE')) || NL;
563: l_document := l_document || get_table_cell(l_ref_name) || '' || NL;
564: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_STATUS')) || NL;
565: l_document := l_document || get_table_cell(l_hdr_status) || '' || NL;
566: l_document := l_document || '' || get_table_label(fnd_message.get_string('QPR', 'QPR_SCORE')) || NL;

Line 564: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_STATUS')) || NL;

560: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_CUSTOMER')) || NL;
561: l_document := l_document || get_table_cell(l_cus_name) || '' || NL;
562: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR', 'QPR_REFERENCE')) || NL;
563: l_document := l_document || get_table_cell(l_ref_name) || '' || NL;
564: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_STATUS')) || NL;
565: l_document := l_document || get_table_cell(l_hdr_status) || '' || NL;
566: l_document := l_document || '' || get_table_label(fnd_message.get_string('QPR', 'QPR_SCORE')) || NL;
567: l_document := l_document || get_table_cell(l_hdr_score) || '' || NL;
568: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_SCENARIO')) || NL;

Line 566: l_document := l_document || '' || get_table_label(fnd_message.get_string('QPR', 'QPR_SCORE')) || NL;

562: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR', 'QPR_REFERENCE')) || NL;
563: l_document := l_document || get_table_cell(l_ref_name) || '' || NL;
564: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_STATUS')) || NL;
565: l_document := l_document || get_table_cell(l_hdr_status) || '' || NL;
566: l_document := l_document || '' || get_table_label(fnd_message.get_string('QPR', 'QPR_SCORE')) || NL;
567: l_document := l_document || get_table_cell(l_hdr_score) || '' || NL;
568: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_SCENARIO')) || NL;
569: l_document := l_document || get_table_cell(l_version_no) || '' || NL;
570: l_document := l_document || '' || get_table_label(fnd_message.get_string('QPR', 'QPR_REQUESTOR')) || NL;

Line 568: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_SCENARIO')) || NL;

564: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_STATUS')) || NL;
565: l_document := l_document || get_table_cell(l_hdr_status) || '' || NL;
566: l_document := l_document || '' || get_table_label(fnd_message.get_string('QPR', 'QPR_SCORE')) || NL;
567: l_document := l_document || get_table_cell(l_hdr_score) || '' || NL;
568: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_SCENARIO')) || NL;
569: l_document := l_document || get_table_cell(l_version_no) || '' || NL;
570: l_document := l_document || '' || get_table_label(fnd_message.get_string('QPR', 'QPR_REQUESTOR')) || NL;
571: l_document := l_document || get_table_cell(l_rep_name) || '' || NL;
572: l_document := l_document || '' || get_table_label(fnd_message.get_string('QPR', 'QPR_REQ_DATE')) || NL;

Line 570: l_document := l_document || '' || get_table_label(fnd_message.get_string('QPR', 'QPR_REQUESTOR')) || NL;

566: l_document := l_document || '' || get_table_label(fnd_message.get_string('QPR', 'QPR_SCORE')) || NL;
567: l_document := l_document || get_table_cell(l_hdr_score) || '' || NL;
568: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_SCENARIO')) || NL;
569: l_document := l_document || get_table_cell(l_version_no) || '' || NL;
570: l_document := l_document || '' || get_table_label(fnd_message.get_string('QPR', 'QPR_REQUESTOR')) || NL;
571: l_document := l_document || get_table_cell(l_rep_name) || '' || NL;
572: l_document := l_document || '' || get_table_label(fnd_message.get_string('QPR', 'QPR_REQ_DATE')) || NL;
573: l_document := l_document || get_table_cell(l_req_date) || '' || NL;
574: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR', 'QPR_CURRENCY')) || NL;

Line 572: l_document := l_document || '' || get_table_label(fnd_message.get_string('QPR', 'QPR_REQ_DATE')) || NL;

568: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR','QPR_SCENARIO')) || NL;
569: l_document := l_document || get_table_cell(l_version_no) || '' || NL;
570: l_document := l_document || '' || get_table_label(fnd_message.get_string('QPR', 'QPR_REQUESTOR')) || NL;
571: l_document := l_document || get_table_cell(l_rep_name) || '' || NL;
572: l_document := l_document || '' || get_table_label(fnd_message.get_string('QPR', 'QPR_REQ_DATE')) || NL;
573: l_document := l_document || get_table_cell(l_req_date) || '' || NL;
574: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR', 'QPR_CURRENCY')) || NL;
575: l_document := l_document || get_table_cell(l_hdr_curr) || '' || NL;
576: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR', 'QPR_DEAL_DESC'))|| NL;

Line 574: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR', 'QPR_CURRENCY')) || NL;

570: l_document := l_document || '' || get_table_label(fnd_message.get_string('QPR', 'QPR_REQUESTOR')) || NL;
571: l_document := l_document || get_table_cell(l_rep_name) || '' || NL;
572: l_document := l_document || '' || get_table_label(fnd_message.get_string('QPR', 'QPR_REQ_DATE')) || NL;
573: l_document := l_document || get_table_cell(l_req_date) || '' || NL;
574: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR', 'QPR_CURRENCY')) || NL;
575: l_document := l_document || get_table_cell(l_hdr_curr) || '' || NL;
576: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR', 'QPR_DEAL_DESC'))|| NL;
577: l_document := l_document || get_table_cell(l_description) || '' || NL;
578: l_document := l_document ||'';

Line 576: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR', 'QPR_DEAL_DESC'))|| NL;

572: l_document := l_document || '' || get_table_label(fnd_message.get_string('QPR', 'QPR_REQ_DATE')) || NL;
573: l_document := l_document || get_table_cell(l_req_date) || '' || NL;
574: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR', 'QPR_CURRENCY')) || NL;
575: l_document := l_document || get_table_cell(l_hdr_curr) || '' || NL;
576: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR', 'QPR_DEAL_DESC'))|| NL;
577: l_document := l_document || get_table_cell(l_description) || '' || NL;
578: l_document := l_document ||'';
579: l_document := l_document ||'

';
580: l_document := l_document || '

' || '' || fnd_message.get_String('QPR', 'QPR_DEAL_URL')||'';

Line 580: l_document := l_document || '
' || '' || fnd_message.get_String('QPR', 'QPR_DEAL_URL')||'';

576: l_document := l_document || '' || get_table_label(fnd_message.get_String('QPR', 'QPR_DEAL_DESC'))|| NL;
577: l_document := l_document || get_table_cell(l_description) || '' || NL;
578: l_document := l_document ||'';
579: l_document := l_document ||'

';
580: l_document := l_document || '

' || '' || fnd_message.get_String('QPR', 'QPR_DEAL_URL')||'';
581: l_document := l_document || '
';
582: document := l_document;
583: else
584: l_document := l_document || NL;

Line 586: l_document := l_document || fnd_message.get_String('QPR', 'QPR_DEAL_SUMMARY') || NL;

582: document := l_document;
583: else
584: l_document := l_document || NL;
585: -- l_document := l_document || l_hdr_msg || NL || NL;
586: l_document := l_document || fnd_message.get_String('QPR', 'QPR_DEAL_SUMMARY') || NL;
587: l_document := l_document || fnd_message.get_String('QPR','QPR_REQUEST_NO') || ': ' || l_request_hdr_id || NL;
588: l_document := l_document || fnd_message.get_String('QPR','QPR_CUSTOMER') || ': ' || l_cus_name || NL;
589: l_document := l_document || fnd_message.get_String('QPR', 'QPR_REFERENCE') || ': ' || l_ref_name || NL;
590: l_document := l_document || fnd_message.get_String('QPR','QPR_STATUS') || ': ' || l_hdr_status || NL;

Line 587: l_document := l_document || fnd_message.get_String('QPR','QPR_REQUEST_NO') || ': ' || l_request_hdr_id || NL;

583: else
584: l_document := l_document || NL;
585: -- l_document := l_document || l_hdr_msg || NL || NL;
586: l_document := l_document || fnd_message.get_String('QPR', 'QPR_DEAL_SUMMARY') || NL;
587: l_document := l_document || fnd_message.get_String('QPR','QPR_REQUEST_NO') || ': ' || l_request_hdr_id || NL;
588: l_document := l_document || fnd_message.get_String('QPR','QPR_CUSTOMER') || ': ' || l_cus_name || NL;
589: l_document := l_document || fnd_message.get_String('QPR', 'QPR_REFERENCE') || ': ' || l_ref_name || NL;
590: l_document := l_document || fnd_message.get_String('QPR','QPR_STATUS') || ': ' || l_hdr_status || NL;
591: l_document := l_document || fnd_message.get_string('QPR', 'QPR_SCORE') || ': ' || l_hdr_score || NL;

Line 588: l_document := l_document || fnd_message.get_String('QPR','QPR_CUSTOMER') || ': ' || l_cus_name || NL;

584: l_document := l_document || NL;
585: -- l_document := l_document || l_hdr_msg || NL || NL;
586: l_document := l_document || fnd_message.get_String('QPR', 'QPR_DEAL_SUMMARY') || NL;
587: l_document := l_document || fnd_message.get_String('QPR','QPR_REQUEST_NO') || ': ' || l_request_hdr_id || NL;
588: l_document := l_document || fnd_message.get_String('QPR','QPR_CUSTOMER') || ': ' || l_cus_name || NL;
589: l_document := l_document || fnd_message.get_String('QPR', 'QPR_REFERENCE') || ': ' || l_ref_name || NL;
590: l_document := l_document || fnd_message.get_String('QPR','QPR_STATUS') || ': ' || l_hdr_status || NL;
591: l_document := l_document || fnd_message.get_string('QPR', 'QPR_SCORE') || ': ' || l_hdr_score || NL;
592: l_document := l_document || fnd_message.get_String('QPR','QPR_SCENARIO') || ': ' || l_version_no|| NL;

Line 589: l_document := l_document || fnd_message.get_String('QPR', 'QPR_REFERENCE') || ': ' || l_ref_name || NL;

585: -- l_document := l_document || l_hdr_msg || NL || NL;
586: l_document := l_document || fnd_message.get_String('QPR', 'QPR_DEAL_SUMMARY') || NL;
587: l_document := l_document || fnd_message.get_String('QPR','QPR_REQUEST_NO') || ': ' || l_request_hdr_id || NL;
588: l_document := l_document || fnd_message.get_String('QPR','QPR_CUSTOMER') || ': ' || l_cus_name || NL;
589: l_document := l_document || fnd_message.get_String('QPR', 'QPR_REFERENCE') || ': ' || l_ref_name || NL;
590: l_document := l_document || fnd_message.get_String('QPR','QPR_STATUS') || ': ' || l_hdr_status || NL;
591: l_document := l_document || fnd_message.get_string('QPR', 'QPR_SCORE') || ': ' || l_hdr_score || NL;
592: l_document := l_document || fnd_message.get_String('QPR','QPR_SCENARIO') || ': ' || l_version_no|| NL;
593: l_document := l_document || fnd_message.get_string('QPR', 'QPR_REQUESTOR') || ': ' || l_rep_name|| NL;

Line 590: l_document := l_document || fnd_message.get_String('QPR','QPR_STATUS') || ': ' || l_hdr_status || NL;

586: l_document := l_document || fnd_message.get_String('QPR', 'QPR_DEAL_SUMMARY') || NL;
587: l_document := l_document || fnd_message.get_String('QPR','QPR_REQUEST_NO') || ': ' || l_request_hdr_id || NL;
588: l_document := l_document || fnd_message.get_String('QPR','QPR_CUSTOMER') || ': ' || l_cus_name || NL;
589: l_document := l_document || fnd_message.get_String('QPR', 'QPR_REFERENCE') || ': ' || l_ref_name || NL;
590: l_document := l_document || fnd_message.get_String('QPR','QPR_STATUS') || ': ' || l_hdr_status || NL;
591: l_document := l_document || fnd_message.get_string('QPR', 'QPR_SCORE') || ': ' || l_hdr_score || NL;
592: l_document := l_document || fnd_message.get_String('QPR','QPR_SCENARIO') || ': ' || l_version_no|| NL;
593: l_document := l_document || fnd_message.get_string('QPR', 'QPR_REQUESTOR') || ': ' || l_rep_name|| NL;
594: l_document := l_document || fnd_message.get_string('QPR', 'QPR_REQ_DATE') || ': ' || l_req_date || NL;

Line 591: l_document := l_document || fnd_message.get_string('QPR', 'QPR_SCORE') || ': ' || l_hdr_score || NL;

587: l_document := l_document || fnd_message.get_String('QPR','QPR_REQUEST_NO') || ': ' || l_request_hdr_id || NL;
588: l_document := l_document || fnd_message.get_String('QPR','QPR_CUSTOMER') || ': ' || l_cus_name || NL;
589: l_document := l_document || fnd_message.get_String('QPR', 'QPR_REFERENCE') || ': ' || l_ref_name || NL;
590: l_document := l_document || fnd_message.get_String('QPR','QPR_STATUS') || ': ' || l_hdr_status || NL;
591: l_document := l_document || fnd_message.get_string('QPR', 'QPR_SCORE') || ': ' || l_hdr_score || NL;
592: l_document := l_document || fnd_message.get_String('QPR','QPR_SCENARIO') || ': ' || l_version_no|| NL;
593: l_document := l_document || fnd_message.get_string('QPR', 'QPR_REQUESTOR') || ': ' || l_rep_name|| NL;
594: l_document := l_document || fnd_message.get_string('QPR', 'QPR_REQ_DATE') || ': ' || l_req_date || NL;
595: l_document := l_document || fnd_message.get_String('QPR', 'QPR_CURRENCY') || ': ' || l_hdr_curr || NL;

Line 592: l_document := l_document || fnd_message.get_String('QPR','QPR_SCENARIO') || ': ' || l_version_no|| NL;

588: l_document := l_document || fnd_message.get_String('QPR','QPR_CUSTOMER') || ': ' || l_cus_name || NL;
589: l_document := l_document || fnd_message.get_String('QPR', 'QPR_REFERENCE') || ': ' || l_ref_name || NL;
590: l_document := l_document || fnd_message.get_String('QPR','QPR_STATUS') || ': ' || l_hdr_status || NL;
591: l_document := l_document || fnd_message.get_string('QPR', 'QPR_SCORE') || ': ' || l_hdr_score || NL;
592: l_document := l_document || fnd_message.get_String('QPR','QPR_SCENARIO') || ': ' || l_version_no|| NL;
593: l_document := l_document || fnd_message.get_string('QPR', 'QPR_REQUESTOR') || ': ' || l_rep_name|| NL;
594: l_document := l_document || fnd_message.get_string('QPR', 'QPR_REQ_DATE') || ': ' || l_req_date || NL;
595: l_document := l_document || fnd_message.get_String('QPR', 'QPR_CURRENCY') || ': ' || l_hdr_curr || NL;
596: l_document := l_document || fnd_message.get_String('QPR', 'QPR_DEAL_DESC')|| ': ' || l_description || NL;

Line 593: l_document := l_document || fnd_message.get_string('QPR', 'QPR_REQUESTOR') || ': ' || l_rep_name|| NL;

589: l_document := l_document || fnd_message.get_String('QPR', 'QPR_REFERENCE') || ': ' || l_ref_name || NL;
590: l_document := l_document || fnd_message.get_String('QPR','QPR_STATUS') || ': ' || l_hdr_status || NL;
591: l_document := l_document || fnd_message.get_string('QPR', 'QPR_SCORE') || ': ' || l_hdr_score || NL;
592: l_document := l_document || fnd_message.get_String('QPR','QPR_SCENARIO') || ': ' || l_version_no|| NL;
593: l_document := l_document || fnd_message.get_string('QPR', 'QPR_REQUESTOR') || ': ' || l_rep_name|| NL;
594: l_document := l_document || fnd_message.get_string('QPR', 'QPR_REQ_DATE') || ': ' || l_req_date || NL;
595: l_document := l_document || fnd_message.get_String('QPR', 'QPR_CURRENCY') || ': ' || l_hdr_curr || NL;
596: l_document := l_document || fnd_message.get_String('QPR', 'QPR_DEAL_DESC')|| ': ' || l_description || NL;
597: l_document := l_document || fnd_message.get_String('QPR', 'QPR_DEAL_URL')|| ':' || l_url || NL;

Line 594: l_document := l_document || fnd_message.get_string('QPR', 'QPR_REQ_DATE') || ': ' || l_req_date || NL;

590: l_document := l_document || fnd_message.get_String('QPR','QPR_STATUS') || ': ' || l_hdr_status || NL;
591: l_document := l_document || fnd_message.get_string('QPR', 'QPR_SCORE') || ': ' || l_hdr_score || NL;
592: l_document := l_document || fnd_message.get_String('QPR','QPR_SCENARIO') || ': ' || l_version_no|| NL;
593: l_document := l_document || fnd_message.get_string('QPR', 'QPR_REQUESTOR') || ': ' || l_rep_name|| NL;
594: l_document := l_document || fnd_message.get_string('QPR', 'QPR_REQ_DATE') || ': ' || l_req_date || NL;
595: l_document := l_document || fnd_message.get_String('QPR', 'QPR_CURRENCY') || ': ' || l_hdr_curr || NL;
596: l_document := l_document || fnd_message.get_String('QPR', 'QPR_DEAL_DESC')|| ': ' || l_description || NL;
597: l_document := l_document || fnd_message.get_String('QPR', 'QPR_DEAL_URL')|| ':' || l_url || NL;
598: document := l_document;

Line 595: l_document := l_document || fnd_message.get_String('QPR', 'QPR_CURRENCY') || ': ' || l_hdr_curr || NL;

591: l_document := l_document || fnd_message.get_string('QPR', 'QPR_SCORE') || ': ' || l_hdr_score || NL;
592: l_document := l_document || fnd_message.get_String('QPR','QPR_SCENARIO') || ': ' || l_version_no|| NL;
593: l_document := l_document || fnd_message.get_string('QPR', 'QPR_REQUESTOR') || ': ' || l_rep_name|| NL;
594: l_document := l_document || fnd_message.get_string('QPR', 'QPR_REQ_DATE') || ': ' || l_req_date || NL;
595: l_document := l_document || fnd_message.get_String('QPR', 'QPR_CURRENCY') || ': ' || l_hdr_curr || NL;
596: l_document := l_document || fnd_message.get_String('QPR', 'QPR_DEAL_DESC')|| ': ' || l_description || NL;
597: l_document := l_document || fnd_message.get_String('QPR', 'QPR_DEAL_URL')|| ':' || l_url || NL;
598: document := l_document;
599: end if;

Line 596: l_document := l_document || fnd_message.get_String('QPR', 'QPR_DEAL_DESC')|| ': ' || l_description || NL;

592: l_document := l_document || fnd_message.get_String('QPR','QPR_SCENARIO') || ': ' || l_version_no|| NL;
593: l_document := l_document || fnd_message.get_string('QPR', 'QPR_REQUESTOR') || ': ' || l_rep_name|| NL;
594: l_document := l_document || fnd_message.get_string('QPR', 'QPR_REQ_DATE') || ': ' || l_req_date || NL;
595: l_document := l_document || fnd_message.get_String('QPR', 'QPR_CURRENCY') || ': ' || l_hdr_curr || NL;
596: l_document := l_document || fnd_message.get_String('QPR', 'QPR_DEAL_DESC')|| ': ' || l_description || NL;
597: l_document := l_document || fnd_message.get_String('QPR', 'QPR_DEAL_URL')|| ':' || l_url || NL;
598: document := l_document;
599: end if;
600:

Line 597: l_document := l_document || fnd_message.get_String('QPR', 'QPR_DEAL_URL')|| ':' || l_url || NL;

593: l_document := l_document || fnd_message.get_string('QPR', 'QPR_REQUESTOR') || ': ' || l_rep_name|| NL;
594: l_document := l_document || fnd_message.get_string('QPR', 'QPR_REQ_DATE') || ': ' || l_req_date || NL;
595: l_document := l_document || fnd_message.get_String('QPR', 'QPR_CURRENCY') || ': ' || l_hdr_curr || NL;
596: l_document := l_document || fnd_message.get_String('QPR', 'QPR_DEAL_DESC')|| ': ' || l_description || NL;
597: l_document := l_document || fnd_message.get_String('QPR', 'QPR_DEAL_URL')|| ':' || l_url || NL;
598: document := l_document;
599: end if;
600:
601: exception