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 156: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);

152: FROM pon_auction_headers_all auh, pon_auc_doctypes dt
153: WHERE auh.auction_header_id = p_auction_header_id and
154: auh.doctype_id = dt.doctype_id;
155:
156: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);
157:
158: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_AUC_ATTR_ATTACH_DESC', x_msg_suffix);
159:
160: SELECT item_description, has_attributes_flag

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

154: auh.doctype_id = dt.doctype_id;
155:
156: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);
157:
158: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_AUC_ATTR_ATTACH_DESC', x_msg_suffix);
159:
160: SELECT item_description, has_attributes_flag
161: INTO x_item_description, x_has_attributes_flag
162: FROM pon_auction_item_prices_all

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

258: FROM pon_auction_headers_all auh, pon_auc_doctypes dt
259: WHERE auh.auction_header_id = p_auction_header_id and
260: auh.doctype_id = dt.doctype_id;
261:
262: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);
263:
264: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_HDR_ATTR_ATTACH_DESC', x_msg_suffix);
265:
266: SELECT auction_title, document_number, has_hdr_attr_flag

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

260: auh.doctype_id = dt.doctype_id;
261:
262: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);
263:
264: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_HDR_ATTR_ATTACH_DESC', x_msg_suffix);
265:
266: SELECT auction_title, document_number, has_hdr_attr_flag
267: INTO x_auction_title, x_document_number, x_has_attributes_flag
268: FROM pon_auction_headers_all

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

283: || newline || newline;
284: END LOOP;
285: CLOSE attribute_info;
286:
287: x_attachment_title := PON_AUCTION_PKG.getMessage('PON_ATTR_ATTACH_TITLE',
288: x_msg_suffix,
289: 'NUMBER', x_document_number,
290: 'TITLE', PON_AUCTION_PKG.replaceHtmlChars(x_auction_title));
291:

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

286:
287: x_attachment_title := PON_AUCTION_PKG.getMessage('PON_ATTR_ATTACH_TITLE',
288: x_msg_suffix,
289: 'NUMBER', x_document_number,
290: 'TITLE', PON_AUCTION_PKG.replaceHtmlChars(x_auction_title));
291:
292: IF (x_has_real_attr = 'Y') THEN
293: p_attachment := x_attachment_title || newline || newline || p_attachment;
294: ELSE

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

335: FROM pon_auction_headers_all auh, pon_auc_doctypes dt
336: WHERE auh.auction_header_id = p_auction_header_id and
337: auh.doctype_id = dt.doctype_id;
338:
339: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);
340:
341: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_AUC_NOTE_BUYER_DESC', x_msg_suffix);
342:
343: msgBidHeaderNote := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BID_HEADER_NOTE', x_msg_suffix);

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

337: auh.doctype_id = dt.doctype_id;
338:
339: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);
340:
341: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_AUC_NOTE_BUYER_DESC', x_msg_suffix);
342:
343: msgBidHeaderNote := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BID_HEADER_NOTE', x_msg_suffix);
344: msgBidLineNote := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BID_LINE_NOTE', x_msg_suffix);
345: p_error_code := 'SUCCESS';

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

339: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);
340:
341: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_AUC_NOTE_BUYER_DESC', x_msg_suffix);
342:
343: msgBidHeaderNote := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BID_HEADER_NOTE', x_msg_suffix);
344: msgBidLineNote := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BID_LINE_NOTE', x_msg_suffix);
345: p_error_code := 'SUCCESS';
346: p_error_msg := '';
347:

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

340:
341: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_AUC_NOTE_BUYER_DESC', x_msg_suffix);
342:
343: msgBidHeaderNote := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BID_HEADER_NOTE', x_msg_suffix);
344: msgBidLineNote := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BID_LINE_NOTE', x_msg_suffix);
345: p_error_code := 'SUCCESS';
346: p_error_msg := '';
347:
348: IF l_contract_type <> 'CONTRACT' THEN

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

399: BEGIN
400: p_attachment := null;
401: newline := fnd_global.newline;
402: tab := fnd_global.tab;
403: msgNegHeaderNote := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NEG_HEADER_NOTE');
404: msgNegLineNote := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NEG_LINE_NOTE');
405: p_error_code := 'SUCCESS';
406: p_error_msg := '';
407:

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

400: p_attachment := null;
401: newline := fnd_global.newline;
402: tab := fnd_global.tab;
403: msgNegHeaderNote := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NEG_HEADER_NOTE');
404: msgNegLineNote := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NEG_LINE_NOTE');
405: p_error_code := 'SUCCESS';
406: p_error_msg := '';
407:
408: SELECT dt.doctype_group_name, nvl(auh.contract_type,'NO_DATA_FOUND')

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

410: FROM pon_auction_headers_all auh, pon_auc_doctypes dt
411: WHERE auh.auction_header_id = p_auction_header_id and
412: auh.doctype_id = dt.doctype_id;
413:
414: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);
415:
416: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_AUC_NOTE_SUPP_DESC', x_msg_suffix);
417:
418: IF l_contract_type <> 'CONTRACT' THEN

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

412: auh.doctype_id = dt.doctype_id;
413:
414: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);
415:
416: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_AUC_NOTE_SUPP_DESC', x_msg_suffix);
417:
418: IF l_contract_type <> 'CONTRACT' THEN
419: SELECT replace(pah.note_to_bidders, fnd_global.local_chr(13)), replace(paip.note_to_bidders, fnd_global.local_chr(13))
420: INTO header_note, line_note

Line 492: ppet.language = PON_AUCTION_PKG.SessionLanguage and

488: pbpe.line_number = p_line_number and
489: pbpe.price_element_type_id <> -10 and
490: pbpe.pf_type = 'SUPPLIER' and
491: pbpe.price_element_type_id = ppet.price_element_type_id and
492: ppet.language = PON_AUCTION_PKG.SessionLanguage and
493: flv.lookup_type = 'PON_PRICING_BASIS' and
494: flv.language = PON_AUCTION_PKG.SessionLanguage and
495: flv.view_application_id = 0 and
496: flv.security_group_id = 0 and

Line 494: flv.language = PON_AUCTION_PKG.SessionLanguage and

490: pbpe.pf_type = 'SUPPLIER' and
491: pbpe.price_element_type_id = ppet.price_element_type_id and
492: ppet.language = PON_AUCTION_PKG.SessionLanguage and
493: flv.lookup_type = 'PON_PRICING_BASIS' and
494: flv.language = PON_AUCTION_PKG.SessionLanguage and
495: flv.view_application_id = 0 and
496: flv.security_group_id = 0 and
497: pbpe.pricing_basis = flv.lookup_code
498: ORDER BY sequence_number;

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

510: FROM pon_auction_headers_all auh, pon_auc_doctypes dt
511: WHERE auh.auction_header_id = p_auction_header_id and
512: auh.doctype_id = dt.doctype_id;
513:
514: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);
515:
516: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_AUC_TOTAL_COST_DESC', x_msg_suffix);
517:
518: SELECT item_description, has_price_elements_flag

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

512: auh.doctype_id = dt.doctype_id;
513:
514: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);
515:
516: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_AUC_TOTAL_COST_DESC', x_msg_suffix);
517:
518: SELECT item_description, has_price_elements_flag
519: INTO x_item_description, x_has_price_elements_flag
520: FROM pon_auction_item_prices_all

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

574: FROM pon_auction_headers_all auh, pon_auc_doctypes dt
575: WHERE auh.auction_header_id = p_auction_header_id and
576: auh.doctype_id = dt.doctype_id;
577:
578: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);
579:
580: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_AUC_JOB_DETAILS_DESC',
581: x_msg_suffix);
582:

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

576: auh.doctype_id = dt.doctype_id;
577:
578: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);
579:
580: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_AUC_JOB_DETAILS_DESC',
581: x_msg_suffix);
582:
583: p_error_code := 'SUCCESS';
584: p_error_msg := '';

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

616: BEGIN
617: p_attachment := null;
618: newline := fnd_global.newline;
619: tab := fnd_global.tab;
620: msgNegPymntNote := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NEG_PYMNT_NOTE');
621: p_error_code := 'SUCCESS';
622: p_error_msg := '';
623:
624: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_AUC_PYMNT_NOTE_SUPP_DESC');

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

620: msgNegPymntNote := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NEG_PYMNT_NOTE');
621: p_error_code := 'SUCCESS';
622: p_error_msg := '';
623:
624: p_attachmentDesc := PON_AUCTION_PKG.getMessage('PON_AUC_PYMNT_NOTE_SUPP_DESC');
625:
626: SELECT replace(pys.note_to_bidders, fnd_global.local_chr(13))
627: INTO pymt_note
628: FROM pon_auc_payments_shipments pys