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.PON_AUCTION_PO_PKG dependencies on PON_AUCTION_PKG

Line 176: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);

172: FROM pon_auction_headers_all auh, pon_auc_doctypes dt
173: WHERE auh.auction_header_id = p_auction_header_id and
174: auh.doctype_id = dt.doctype_id;
175:
176: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);
177:
178: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_AUC_ATTR_ATTACH_DESC', x_msg_suffix);
179:
180: SELECT item_description, has_attributes_flag

Line 178: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_AUC_ATTR_ATTACH_DESC', x_msg_suffix);

174: auh.doctype_id = dt.doctype_id;
175:
176: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);
177:
178: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_AUC_ATTR_ATTACH_DESC', x_msg_suffix);
179:
180: SELECT item_description, has_attributes_flag
181: INTO x_item_description, x_has_attributes_flag
182: FROM pon_auction_item_prices_all

Line 300: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);

296: FROM pon_auction_headers_all auh, pon_auc_doctypes dt
297: WHERE auh.auction_header_id = p_auction_header_id and
298: auh.doctype_id = dt.doctype_id;
299:
300: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);
301:
302: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_HDR_ATTR_ATTACH_DESC', x_msg_suffix);
303:
304: SELECT auction_title, document_number, has_hdr_attr_flag

Line 302: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_HDR_ATTR_ATTACH_DESC', x_msg_suffix);

298: auh.doctype_id = dt.doctype_id;
299:
300: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);
301:
302: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_HDR_ATTR_ATTACH_DESC', x_msg_suffix);
303:
304: SELECT auction_title, document_number, has_hdr_attr_flag
305: INTO x_auction_title, x_document_number, x_has_attributes_flag
306: FROM pon_auction_headers_all

Line 324: x_attachment_title := PON_AUCTION_PKG.getMessage('PON_ATTR_ATTACH_TITLE',

320: p_attachment := p_attachment || x_attribute_name || ' = ' || x_bidValue
321: || newline || newline;
322: END LOOP;
323: CLOSE attribute_info;
324: x_attachment_title := PON_AUCTION_PKG.getMessage('PON_ATTR_ATTACH_TITLE',
325: x_msg_suffix,
326: 'NUMBER', x_document_number,
327: 'TITLE', PON_AUCTION_PKG.replaceHtmlChars(x_auction_title));
328: IF (x_has_real_attr = 'Y') THEN

Line 327: 'TITLE', PON_AUCTION_PKG.replaceHtmlChars(x_auction_title));

323: CLOSE attribute_info;
324: x_attachment_title := PON_AUCTION_PKG.getMessage('PON_ATTR_ATTACH_TITLE',
325: x_msg_suffix,
326: 'NUMBER', x_document_number,
327: 'TITLE', PON_AUCTION_PKG.replaceHtmlChars(x_auction_title));
328: IF (x_has_real_attr = 'Y') THEN
329: p_attachment := x_attachment_title || newline || newline || p_attachment;
330: ELSE
331: p_attachment := null;

Line 400: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);

396: FROM pon_auction_headers_all auh, pon_auc_doctypes dt
397: WHERE auh.auction_header_id = p_auction_header_id and
398: auh.doctype_id = dt.doctype_id;
399:
400: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);
401:
402: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_HDR_ATTR_ATTACH_DESC', x_msg_suffix);
403:
404: SELECT auction_title, document_number, has_hdr_attr_flag

Line 402: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_HDR_ATTR_ATTACH_DESC', x_msg_suffix);

398: auh.doctype_id = dt.doctype_id;
399:
400: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);
401:
402: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_HDR_ATTR_ATTACH_DESC', x_msg_suffix);
403:
404: SELECT auction_title, document_number, has_hdr_attr_flag
405: INTO x_auction_title, x_document_number, x_has_attributes_flag
406: FROM pon_auction_headers_all

Line 424: x_attachment_title := PON_AUCTION_PKG.getMessage('PON_ATTR_ATTACH_TITLE',

420: p_attachment := p_attachment || x_attribute_name || ' = ' || x_bidValue
421: || newline || newline;
422: END LOOP;
423: CLOSE attribute_info;
424: x_attachment_title := PON_AUCTION_PKG.getMessage('PON_ATTR_ATTACH_TITLE',
425: x_msg_suffix,
426: 'NUMBER', x_document_number,
427: 'TITLE', PON_AUCTION_PKG.replaceHtmlChars(x_auction_title));
428: IF (x_has_real_attr = 'Y') THEN

Line 427: 'TITLE', PON_AUCTION_PKG.replaceHtmlChars(x_auction_title));

423: CLOSE attribute_info;
424: x_attachment_title := PON_AUCTION_PKG.getMessage('PON_ATTR_ATTACH_TITLE',
425: x_msg_suffix,
426: 'NUMBER', x_document_number,
427: 'TITLE', PON_AUCTION_PKG.replaceHtmlChars(x_auction_title));
428: IF (x_has_real_attr = 'Y') THEN
429: p_attachment := x_attachment_title || newline || newline || p_attachment;
430: --p_attachment := dbms_xmlgen.Convert(p_attachment);
431: ELSE

Line 471: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);

467: FROM pon_auction_headers_all auh, pon_auc_doctypes dt
468: WHERE auh.auction_header_id = p_auction_header_id and
469: auh.doctype_id = dt.doctype_id;
470:
471: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);
472:
473: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_AUC_NOTE_BUYER_DESC', x_msg_suffix);
474:
475: msgBidHeaderNote := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BID_HEADER_NOTE', x_msg_suffix);

Line 473: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_AUC_NOTE_BUYER_DESC', x_msg_suffix);

469: auh.doctype_id = dt.doctype_id;
470:
471: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);
472:
473: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_AUC_NOTE_BUYER_DESC', x_msg_suffix);
474:
475: msgBidHeaderNote := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BID_HEADER_NOTE', x_msg_suffix);
476: msgBidLineNote := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BID_LINE_NOTE', x_msg_suffix);
477: p_error_code := 'SUCCESS';

Line 475: msgBidHeaderNote := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BID_HEADER_NOTE', x_msg_suffix);

471: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);
472:
473: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_AUC_NOTE_BUYER_DESC', x_msg_suffix);
474:
475: msgBidHeaderNote := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BID_HEADER_NOTE', x_msg_suffix);
476: msgBidLineNote := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BID_LINE_NOTE', x_msg_suffix);
477: p_error_code := 'SUCCESS';
478: p_error_msg := '';
479:

Line 476: msgBidLineNote := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BID_LINE_NOTE', x_msg_suffix);

472:
473: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_AUC_NOTE_BUYER_DESC', x_msg_suffix);
474:
475: msgBidHeaderNote := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BID_HEADER_NOTE', x_msg_suffix);
476: msgBidLineNote := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BID_LINE_NOTE', x_msg_suffix);
477: p_error_code := 'SUCCESS';
478: p_error_msg := '';
479:
480: IF l_contract_type <> 'CONTRACT' THEN

Line 535: msgNegHeaderNote := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NEG_HEADER_NOTE');

531: BEGIN
532: p_attachment := null;
533: newline := fnd_global.newline;
534: tab := fnd_global.tab;
535: msgNegHeaderNote := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NEG_HEADER_NOTE');
536: msgNegLineNote := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NEG_LINE_NOTE');
537: p_error_code := 'SUCCESS';
538: p_error_msg := '';
539:

Line 536: msgNegLineNote := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NEG_LINE_NOTE');

532: p_attachment := null;
533: newline := fnd_global.newline;
534: tab := fnd_global.tab;
535: msgNegHeaderNote := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NEG_HEADER_NOTE');
536: msgNegLineNote := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NEG_LINE_NOTE');
537: p_error_code := 'SUCCESS';
538: p_error_msg := '';
539:
540: SELECT dt.doctype_group_name, nvl(auh.contract_type,'NO_DATA_FOUND')

Line 546: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);

542: FROM pon_auction_headers_all auh, pon_auc_doctypes dt
543: WHERE auh.auction_header_id = p_auction_header_id and
544: auh.doctype_id = dt.doctype_id;
545:
546: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);
547:
548: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_AUC_NOTE_SUPP_DESC', x_msg_suffix);
549:
550: IF l_contract_type <> 'CONTRACT' THEN

Line 548: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_AUC_NOTE_SUPP_DESC', x_msg_suffix);

544: auh.doctype_id = dt.doctype_id;
545:
546: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);
547:
548: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_AUC_NOTE_SUPP_DESC', x_msg_suffix);
549:
550: IF l_contract_type <> 'CONTRACT' THEN
551: SELECT replace(pah.note_to_bidders, fnd_global.local_chr(13)), replace(paip.note_to_bidders, fnd_global.local_chr(13))
552: INTO header_note, line_note

Line 632: ppet.language = PON_AUCTION_PKG.SessionLanguage and

628: pbpe.line_number = p_line_number and
629: pbpe.price_element_type_id <> -10 and
630: pbpe.pf_type = 'SUPPLIER' and
631: pbpe.price_element_type_id = ppet.price_element_type_id and
632: ppet.language = PON_AUCTION_PKG.SessionLanguage and
633: flv.lookup_type = 'PON_PRICING_BASIS' and
634: flv.language = PON_AUCTION_PKG.SessionLanguage and
635: flv.view_application_id = 0 and
636: flv.security_group_id = 0 and

Line 634: flv.language = PON_AUCTION_PKG.SessionLanguage and

630: pbpe.pf_type = 'SUPPLIER' and
631: pbpe.price_element_type_id = ppet.price_element_type_id and
632: ppet.language = PON_AUCTION_PKG.SessionLanguage and
633: flv.lookup_type = 'PON_PRICING_BASIS' and
634: flv.language = PON_AUCTION_PKG.SessionLanguage and
635: flv.view_application_id = 0 and
636: flv.security_group_id = 0 and
637: pbpe.pricing_basis = flv.lookup_code
638: ORDER BY sequence_number;

Line 654: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);

650: FROM pon_auction_headers_all auh, pon_auc_doctypes dt
651: WHERE auh.auction_header_id = p_auction_header_id and
652: auh.doctype_id = dt.doctype_id;
653:
654: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);
655:
656: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_AUC_TOTAL_COST_DESC', x_msg_suffix);
657:
658: SELECT item_description, has_price_elements_flag

Line 656: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_AUC_TOTAL_COST_DESC', x_msg_suffix);

652: auh.doctype_id = dt.doctype_id;
653:
654: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);
655:
656: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_AUC_TOTAL_COST_DESC', x_msg_suffix);
657:
658: SELECT item_description, has_price_elements_flag
659: INTO x_item_description, x_has_price_elements_flag
660: FROM pon_auction_item_prices_all

Line 734: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);

730: FROM pon_auction_headers_all auh, pon_auc_doctypes dt
731: WHERE auh.auction_header_id = p_auction_header_id and
732: auh.doctype_id = dt.doctype_id;
733:
734: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);
735:
736: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_AUC_JOB_DETAILS_DESC',
737: x_msg_suffix);
738:

Line 736: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_AUC_JOB_DETAILS_DESC',

732: auh.doctype_id = dt.doctype_id;
733:
734: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);
735:
736: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_AUC_JOB_DETAILS_DESC',
737: x_msg_suffix);
738:
739: p_error_code := 'SUCCESS';
740: p_error_msg := '';

Line 782: msgNegPymntNote := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NEG_PYMNT_NOTE');

778: BEGIN
779: p_attachment := null;
780: newline := fnd_global.newline;
781: tab := fnd_global.tab;
782: msgNegPymntNote := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NEG_PYMNT_NOTE');
783: p_error_code := 'SUCCESS';
784: p_error_msg := '';
785:
786: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_AUC_PYMNT_NOTE_SUPP_DESC');

Line 786: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_AUC_PYMNT_NOTE_SUPP_DESC');

782: msgNegPymntNote := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NEG_PYMNT_NOTE');
783: p_error_code := 'SUCCESS';
784: p_error_msg := '';
785:
786: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_AUC_PYMNT_NOTE_SUPP_DESC');
787:
788: SELECT replace(pys.note_to_bidders, fnd_global.local_chr(13))
789: INTO pymt_note
790: FROM pon_auc_payments_shipments pys