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_BID_VALIDATIONS_PKG dependencies on PON_BID_SHIPMENTS

Line 270: FROM pon_bid_shipments bpb

266: -- Check shipments
267: -- If auction_shipment_number is null then it is user defined
268: -- so we must check all possible values that can be changed
269: (SELECT bpb.line_number
270: FROM pon_bid_shipments bpb
271: WHERE bpb.bid_number = bl.bid_number
272: AND bpb.line_number = bl.line_number
273: AND (bpb.auction_shipment_number IS null
274: AND (NVL(bpb.ship_to_organization_id, g_null_int) <> NVL(bpb.old_ship_to_org_id, g_null_int)

Line 344: FROM pon_bid_shipments bpb, pon_bid_shipments old_bpb

340: AND (EXISTS
341:
342: -- Check if a shipment was deleted
343: (SELECT old_bpb.line_number
344: FROM pon_bid_shipments bpb, pon_bid_shipments old_bpb
345: WHERE old_bpb.bid_number = p_source_bid
346: AND old_bpb.line_number = bl.line_number
347: AND bpb.bid_number (+) = p_bid_number
348: AND bpb.line_number (+) = old_bpb.line_number

Line 357: FROM pon_bid_shipments bpb, pon_bid_shipments old_bpb

353: OR EXISTS
354:
355: -- Check if a shipment was added
356: (SELECT bpb.line_number
357: FROM pon_bid_shipments bpb, pon_bid_shipments old_bpb
358: WHERE bpb.bid_number = p_bid_number
359: AND bpb.line_number = bl.line_number
360: AND old_bpb.bid_number (+) = p_source_bid
361: AND old_bpb.line_number (+) = bpb.line_number

Line 3032: FROM pon_bid_shipments bpb

3028: p_two_part_tech_surrogate_flag = 'N' AND
3029: ---------------------------------------------------
3030: s_price_break_type = 'NONE' AND
3031: EXISTS (SELECT bpb.shipment_number
3032: FROM pon_bid_shipments bpb
3033: WHERE bpb.bid_number = p_bid_number
3034: AND bpb.line_number = s_line_number
3035: AND bpb.shipment_type = 'PRICE BREAK')
3036: THEN

Line 4566: 'PON_BID_SHIPMENTS',

4562: WORKSHEET_SEQUENCE_NUMBER,
4563: ENTITY_MESSAGE_CODE)
4564: VALUES
4565: (p_interface_type,
4566: 'PON_BID_SHIPMENTS',
4567: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_QUANTITY'), null ),
4568: p_batch_id,
4569: s_interface_line_id,
4570: 'PON_AUCTS_PB_QUANTITY_POSITIVE',

Line 4623: 'PON_BID_SHIPMENTS',

4619: WORKSHEET_SEQUENCE_NUMBER,
4620: ENTITY_MESSAGE_CODE)
4621: VALUES
4622: (p_interface_type,
4623: 'PON_BID_SHIPMENTS',
4624: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_PRICE'), null ),
4625: p_batch_id,
4626: s_interface_line_id,
4627: 'PON_AUC_PB_POS_OR_ZERO',

Line 4681: 'PON_BID_SHIPMENTS',

4677: WORKSHEET_SEQUENCE_NUMBER,
4678: ENTITY_MESSAGE_CODE)
4679: VALUES
4680: (p_interface_type,
4681: 'PON_BID_SHIPMENTS',
4682: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_PRICE'), null ),
4683: p_batch_id,
4684: s_interface_line_id,
4685: 'PON_AUC_PB_INVALID_BID_PREC' || p_suffix,

Line 4740: 'PON_BID_SHIPMENTS',

4736: WORKSHEET_SEQUENCE_NUMBER,
4737: ENTITY_MESSAGE_CODE)
4738: VALUES
4739: (p_interface_type,
4740: 'PON_BID_SHIPMENTS',
4741: p_batch_id,
4742: s_interface_line_id,
4743: 'PON_PB_BIDPRICE_INVALID_1',
4744: p_userid,

Line 4794: 'PON_BID_SHIPMENTS',

4790: WORKSHEET_SEQUENCE_NUMBER,
4791: ENTITY_MESSAGE_CODE)
4792: VALUES
4793: (p_interface_type,
4794: 'PON_BID_SHIPMENTS',
4795: p_batch_id,
4796: s_interface_line_id,
4797: decode(p_header_disp_pf, 'Y',
4798: 'PON_PB_BIDPRICE_INVALID_2' || p_suffix,

Line 4851: 'PON_BID_SHIPMENTS',

4847: WORKSHEET_SEQUENCE_NUMBER,
4848: ENTITY_MESSAGE_CODE)
4849: VALUES
4850: (p_interface_type,
4851: 'PON_BID_SHIPMENTS',
4852: p_batch_id,
4853: s_interface_line_id,
4854: 'PON_AUC_PB_INVALID_BID_PREC' || p_suffix,
4855: p_userid,

Line 4908: 'PON_BID_SHIPMENTS',

4904: WORKSHEET_SEQUENCE_NUMBER,
4905: ENTITY_MESSAGE_CODE)
4906: VALUES
4907: (p_interface_type,
4908: 'PON_BID_SHIPMENTS',
4909: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_PRICE'), null ),
4910: p_batch_id,
4911: s_interface_line_id,
4912: 'PON_INVALID_PRICE_DISCOUNT',

Line 4964: 'PON_BID_SHIPMENTS',

4960: WORKSHEET_SEQUENCE_NUMBER,
4961: ENTITY_MESSAGE_CODE)
4962: VALUES
4963: (p_interface_type,
4964: 'PON_BID_SHIPMENTS',
4965: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_FROM'), null ),
4966: p_batch_id,
4967: s_interface_line_id,
4968: 'PON_AUC_FROMDATE_AFTER_CURDATE',

Line 5019: 'PON_BID_SHIPMENTS',

5015: WORKSHEET_SEQUENCE_NUMBER,
5016: ENTITY_MESSAGE_CODE)
5017: VALUES
5018: (p_interface_type,
5019: 'PON_BID_SHIPMENTS',
5020: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_FROM'), null ),
5021: p_batch_id,
5022: s_interface_line_id,
5023: 'PON_AUC_BAD_PB_EFF_FDATE_2',

Line 5075: 'PON_BID_SHIPMENTS',

5071: WORKSHEET_SEQUENCE_NUMBER,
5072: ENTITY_MESSAGE_CODE)
5073: VALUES
5074: (p_interface_type,
5075: 'PON_BID_SHIPMENTS',
5076: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_FROM'), null ),
5077: p_batch_id,
5078: s_interface_line_id,
5079: 'PON_AUC_BAD_PB_EFF_FDATE_3',

Line 5131: 'PON_BID_SHIPMENTS',

5127: WORKSHEET_SEQUENCE_NUMBER,
5128: ENTITY_MESSAGE_CODE)
5129: VALUES
5130: (p_interface_type,
5131: 'PON_BID_SHIPMENTS',
5132: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_FROM'), null ),
5133: p_batch_id,
5134: s_interface_line_id,
5135: 'PON_AUC_BAD_PB_EFF_FDATE_1',

Line 5186: 'PON_BID_SHIPMENTS',

5182: WORKSHEET_SEQUENCE_NUMBER,
5183: ENTITY_MESSAGE_CODE)
5184: VALUES
5185: (p_interface_type,
5186: 'PON_BID_SHIPMENTS',
5187: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_TO'), null ),
5188: p_batch_id,
5189: s_interface_line_id,
5190: 'PON_AUC_TODATE_AFTER_CURDATE',

Line 5242: 'PON_BID_SHIPMENTS',

5238: WORKSHEET_SEQUENCE_NUMBER,
5239: ENTITY_MESSAGE_CODE)
5240: VALUES
5241: (p_interface_type,
5242: 'PON_BID_SHIPMENTS',
5243: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_TO'), null ),
5244: p_batch_id,
5245: s_interface_line_id,
5246: 'PON_AUC_BAD_PB_EFF_TDATE_2',

Line 5298: 'PON_BID_SHIPMENTS',

5294: WORKSHEET_SEQUENCE_NUMBER,
5295: ENTITY_MESSAGE_CODE)
5296: VALUES
5297: (p_interface_type,
5298: 'PON_BID_SHIPMENTS',
5299: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_TO'), null ),
5300: p_batch_id,
5301: s_interface_line_id,
5302: 'PON_AUC_BAD_PB_EFF_TDATE_3',

Line 5354: 'PON_BID_SHIPMENTS',

5350: WORKSHEET_SEQUENCE_NUMBER,
5351: ENTITY_MESSAGE_CODE)
5352: VALUES
5353: (p_interface_type,
5354: 'PON_BID_SHIPMENTS',
5355: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_TO'), null ),
5356: p_batch_id,
5357: s_interface_line_id ,
5358: 'PON_AUC_BAD_PB_EFF_TDATE_1',

Line 5412: 'PON_BID_SHIPMENTS',

5408: WORKSHEET_SEQUENCE_NUMBER,
5409: ENTITY_MESSAGE_CODE)
5410: VALUES
5411: (p_interface_type,
5412: 'PON_BID_SHIPMENTS',
5413: p_batch_id,
5414: s_interface_line_id,
5415: 'PON_AUCTS_PB_MUST_BE_ENTERED',
5416: p_userid,

Line 5464: 'PON_BID_SHIPMENTS',

5460: WORKSHEET_SEQUENCE_NUMBER,
5461: ENTITY_MESSAGE_CODE)
5462: VALUES
5463: (p_interface_type,
5464: 'PON_BID_SHIPMENTS',
5465: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_TO'), null ),
5466: p_batch_id,
5467: s_interface_line_id,
5468: 'PON_AUC_INVALID_EFF_DATES',

Line 5518: 'PON_BID_SHIPMENTS',

5514: WORKSHEET_SEQUENCE_NUMBER,
5515: ENTITY_MESSAGE_CODE)
5516: VALUES
5517: (p_interface_type,
5518: 'PON_BID_SHIPMENTS',
5519: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_PRICE'), null ),
5520: p_batch_id,
5521: s_interface_line_id,
5522: 'PON_AUC_PB_PRICE_REQ',

Line 5573: 'PON_BID_SHIPMENTS',

5569: WORKSHEET_SEQUENCE_NUMBER,
5570: ENTITY_MESSAGE_CODE)
5571: VALUES
5572: (p_interface_type,
5573: 'PON_BID_SHIPMENTS',
5574: p_batch_id,
5575: s_interface_line_id,
5576: 'PON_AUCTS_PB_CUMM_EFF_DATES',
5577: p_userid,

Line 5626: FROM pon_bid_shipments bpb

5622: 'PON_AUCTS_PRICE_BREAKS',
5623: null
5624: ) s_entity_name,
5625: al.line_num_display s_clm_line_num_display
5626: FROM pon_bid_shipments bpb
5627: , pon_bid_item_prices bl
5628: , pon_auction_item_prices_all al
5629: , pon_bid_headers pbh
5630: WHERE bpb.bid_number = p_bid_number

Line 5722: 'PON_BID_SHIPMENTS',

5718: WORKSHEET_SEQUENCE_NUMBER,
5719: ENTITY_MESSAGE_CODE)
5720: VALUES
5721: (p_interface_type,
5722: 'PON_BID_SHIPMENTS',
5723: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_MIN_QUANTITY'), null ),
5724: p_batch_id,
5725: s_interface_line_id,
5726: 'PON_AUCTS_PT_MIN_QUANTITY_REQ',

Line 5788: 'PON_BID_SHIPMENTS',

5784: ENTITY_MESSAGE_CODE
5785: )
5786: VALUES
5787: (p_interface_type,
5788: 'PON_BID_SHIPMENTS',
5789: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_MAX_QUANTITY'), null ),
5790: p_batch_id,
5791: s_interface_line_id,
5792: 'PON_AUCTS_PT_MAX_QUANTITY_REQ',

Line 5853: 'PON_BID_SHIPMENTS',

5849: ENTITY_MESSAGE_CODE
5850: )
5851: VALUES
5852: (p_interface_type,
5853: 'PON_BID_SHIPMENTS',
5854: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_MIN_QUANTITY'), null ),
5855: p_batch_id,
5856: s_interface_line_id,
5857: 'PON_AUCTS_PT_QUANTITY_POSITIVE',

Line 5918: 'PON_BID_SHIPMENTS',

5914: ENTITY_MESSAGE_CODE
5915: )
5916: VALUES
5917: (p_interface_type,
5918: 'PON_BID_SHIPMENTS',
5919: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_MAX_QUANTITY'), null ),
5920: p_batch_id,
5921: s_interface_line_id,
5922: 'PON_AUCTS_PT_QUANTITY_POSITIVE',

Line 5982: 'PON_BID_SHIPMENTS',

5978: ENTITY_MESSAGE_CODE
5979: )
5980: VALUES
5981: (p_interface_type,
5982: 'PON_BID_SHIPMENTS',
5983: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_MAX_QUANTITY'), null ),
5984: p_batch_id,
5985: s_interface_line_id,
5986: 'PON_QT_MAX_MIN_QTY_ERR',

Line 6012: SELECT 'Y' FROM pon_bid_shipments bpb1 WHERE

6008:
6009: WHEN (
6010: p_spreadsheet = g_xml_upload_mode AND
6011: EXISTS (
6012: SELECT 'Y' FROM pon_bid_shipments bpb1 WHERE
6013: bpb1.auction_header_id = p_auc_header_id AND
6014: bpb1.bid_number = p_bid_number AND
6015: bpb1.line_number = s_line_number AND
6016: bpb1.SHIPMENT_NUMBER <> s_shipment_number AND

Line 6051: 'PON_BID_SHIPMENTS',

6047: WORKSHEET_SEQUENCE_NUMBER,
6048: ENTITY_MESSAGE_CODE)
6049: VALUES
6050: (p_interface_type,
6051: 'PON_BID_SHIPMENTS',
6052: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_MIN_QUANTITY'), null ),
6053: p_batch_id,
6054: s_interface_line_id,
6055: 'PON_AUC_OVERLAP_RANGES_QT',

Line 6084: SELECT 'Y' FROM pon_bid_shipments bpb1 WHERE

6080: --The error message only show up once.
6081: WHEN (
6082: p_spreadsheet = g_xml_upload_mode AND
6083: EXISTS (
6084: SELECT 'Y' FROM pon_bid_shipments bpb1 WHERE
6085: bpb1.auction_header_id = p_auc_header_id AND
6086: bpb1.bid_number = p_bid_number AND
6087: bpb1.line_number = s_line_number AND
6088: bpb1.SHIPMENT_NUMBER <> s_shipment_number AND

Line 6126: 'PON_BID_SHIPMENTS',

6122: WORKSHEET_SEQUENCE_NUMBER,
6123: ENTITY_MESSAGE_CODE)
6124: VALUES
6125: (p_interface_type,
6126: 'PON_BID_SHIPMENTS',
6127: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_MAX_QUANTITY'), null ),
6128: p_batch_id,
6129: s_interface_line_id,
6130: 'PON_AUC_OVERLAP_RANGES_QT',

Line 6186: 'PON_BID_SHIPMENTS',

6182: ENTITY_MESSAGE_CODE
6183: )
6184: VALUES
6185: (p_interface_type,
6186: 'PON_BID_SHIPMENTS',
6187: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_PRICE'), null ),
6188: p_batch_id,
6189: s_interface_line_id,
6190: 'PON_AUC_PT_PRICE_REQ',

Line 6249: 'PON_BID_SHIPMENTS',

6245: ENTITY_MESSAGE_CODE
6246: )
6247: VALUES
6248: (p_interface_type,
6249: 'PON_BID_SHIPMENTS',
6250: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_PRICE'), null ),
6251: p_batch_id,
6252: s_interface_line_id,
6253: 'PON_AUCTS_QT_PRICE_POSITIVE',

Line 6308: 'PON_BID_SHIPMENTS',

6304: ENTITY_MESSAGE_CODE
6305: )
6306: VALUES
6307: (p_interface_type,
6308: 'PON_BID_SHIPMENTS',
6309: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_PRICE'), null ),
6310: p_batch_id,
6311: s_interface_line_id,
6312: 'PON_AUC_QT_INVALID_BID_PREC',

Line 6482: FROM pon_bid_shipments bpb,

6478: 'PON_AUCTS_PRICE_TIERS',
6479: null
6480: ) s_entity_name,
6481: al.line_num_display s_clm_line_num_display
6482: FROM pon_bid_shipments bpb,
6483: pon_bid_item_prices bl,
6484: pon_auction_item_prices_all al,
6485: (SELECT MAX(shipments.max_quantity) max_quantity,
6486: shipments.bid_number,

Line 6488: FROM pon_bid_shipments shipments

6484: pon_auction_item_prices_all al,
6485: (SELECT MAX(shipments.max_quantity) max_quantity,
6486: shipments.bid_number,
6487: shipments.line_number
6488: FROM pon_bid_shipments shipments
6489: WHERE shipments.bid_number = p_bid_number
6490: GROUP BY shipments.bid_number,
6491: shipments.line_number) max_bid_shipments
6492: , pon_bid_headers pbh

Line 6535: 'PON_BID_SHIPMENTS',

6531: TOKEN1_NAME,
6532: TOKEN1_VALUE)
6533: SELECT
6534: p_interface_type,
6535: 'PON_BID_SHIPMENTS',
6536: p_batch_id,
6537: bl.interface_line_id,
6538: 'PON_AUC_OVERLAP_RANGES_QT',
6539: p_userid,

Line 6563: FROM pon_bid_shipments pbs,

6559: AND bl.is_changed_line_flag = 'Y'
6560: AND p_spreadsheet = g_online_mode
6561: and bl.line_number in
6562: ( Select distinct pbs.line_number
6563: FROM pon_bid_shipments pbs,
6564: pon_bid_shipments pbs1
6565: WHERE pbs.bid_number = p_bid_number
6566: and pbs1.bid_number = p_bid_number
6567: AND pbs.line_number = pbs1.line_number

Line 6564: pon_bid_shipments pbs1

6560: AND p_spreadsheet = g_online_mode
6561: and bl.line_number in
6562: ( Select distinct pbs.line_number
6563: FROM pon_bid_shipments pbs,
6564: pon_bid_shipments pbs1
6565: WHERE pbs.bid_number = p_bid_number
6566: and pbs1.bid_number = p_bid_number
6567: AND pbs.line_number = pbs1.line_number
6568: AND pbs.shipment_number <> pbs1.shipment_number