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 257: FROM pon_bid_shipments bpb

253: -- Check shipments
254: -- If auction_shipment_number is null then it is user defined
255: -- so we must check all possible values that can be changed
256: (SELECT bpb.line_number
257: FROM pon_bid_shipments bpb
258: WHERE bpb.bid_number = bl.bid_number
259: AND bpb.line_number = bl.line_number
260: AND (bpb.auction_shipment_number IS null
261: AND (NVL(bpb.ship_to_organization_id, g_null_int) <> NVL(bpb.old_ship_to_org_id, g_null_int)

Line 331: FROM pon_bid_shipments bpb, pon_bid_shipments old_bpb

327: AND (EXISTS
328:
329: -- Check if a shipment was deleted
330: (SELECT old_bpb.line_number
331: FROM pon_bid_shipments bpb, pon_bid_shipments old_bpb
332: WHERE old_bpb.bid_number = p_source_bid
333: AND old_bpb.line_number = bl.line_number
334: AND bpb.bid_number (+) = p_bid_number
335: AND bpb.line_number (+) = old_bpb.line_number

Line 344: FROM pon_bid_shipments bpb, pon_bid_shipments old_bpb

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

Line 2386: FROM pon_bid_shipments bpb

2382: p_two_part_tech_surrogate_flag = 'N' AND
2383: ---------------------------------------------------
2384: s_price_break_type = 'NONE' AND
2385: EXISTS (SELECT bpb.shipment_number
2386: FROM pon_bid_shipments bpb
2387: WHERE bpb.bid_number = p_bid_number
2388: AND bpb.line_number = s_line_number
2389: AND bpb.shipment_type = 'PRICE BREAK')
2390: THEN

Line 3858: 'PON_BID_SHIPMENTS',

3854: WORKSHEET_SEQUENCE_NUMBER,
3855: ENTITY_MESSAGE_CODE)
3856: VALUES
3857: (p_interface_type,
3858: 'PON_BID_SHIPMENTS',
3859: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_QUANTITY'), null ),
3860: p_batch_id,
3861: s_interface_line_id,
3862: 'PON_AUCTS_PB_QUANTITY_POSITIVE',

Line 3914: 'PON_BID_SHIPMENTS',

3910: WORKSHEET_SEQUENCE_NUMBER,
3911: ENTITY_MESSAGE_CODE)
3912: VALUES
3913: (p_interface_type,
3914: 'PON_BID_SHIPMENTS',
3915: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_PRICE'), null ),
3916: p_batch_id,
3917: s_interface_line_id,
3918: 'PON_AUC_PB_POS_OR_ZERO',

Line 3971: 'PON_BID_SHIPMENTS',

3967: WORKSHEET_SEQUENCE_NUMBER,
3968: ENTITY_MESSAGE_CODE)
3969: VALUES
3970: (p_interface_type,
3971: 'PON_BID_SHIPMENTS',
3972: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_PRICE'), null ),
3973: p_batch_id,
3974: s_interface_line_id,
3975: 'PON_AUC_PB_INVALID_BID_PREC' || p_suffix,

Line 4029: 'PON_BID_SHIPMENTS',

4025: WORKSHEET_SEQUENCE_NUMBER,
4026: ENTITY_MESSAGE_CODE)
4027: VALUES
4028: (p_interface_type,
4029: 'PON_BID_SHIPMENTS',
4030: p_batch_id,
4031: s_interface_line_id,
4032: 'PON_PB_BIDPRICE_INVALID_1',
4033: p_userid,

Line 4082: 'PON_BID_SHIPMENTS',

4078: WORKSHEET_SEQUENCE_NUMBER,
4079: ENTITY_MESSAGE_CODE)
4080: VALUES
4081: (p_interface_type,
4082: 'PON_BID_SHIPMENTS',
4083: p_batch_id,
4084: s_interface_line_id,
4085: decode(p_header_disp_pf, 'Y',
4086: 'PON_PB_BIDPRICE_INVALID_2' || p_suffix,

Line 4138: 'PON_BID_SHIPMENTS',

4134: WORKSHEET_SEQUENCE_NUMBER,
4135: ENTITY_MESSAGE_CODE)
4136: VALUES
4137: (p_interface_type,
4138: 'PON_BID_SHIPMENTS',
4139: p_batch_id,
4140: s_interface_line_id,
4141: 'PON_AUC_PB_INVALID_BID_PREC' || p_suffix,
4142: p_userid,

Line 4194: 'PON_BID_SHIPMENTS',

4190: WORKSHEET_SEQUENCE_NUMBER,
4191: ENTITY_MESSAGE_CODE)
4192: VALUES
4193: (p_interface_type,
4194: 'PON_BID_SHIPMENTS',
4195: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_PRICE'), null ),
4196: p_batch_id,
4197: s_interface_line_id,
4198: 'PON_INVALID_PRICE_DISCOUNT',

Line 4249: 'PON_BID_SHIPMENTS',

4245: WORKSHEET_SEQUENCE_NUMBER,
4246: ENTITY_MESSAGE_CODE)
4247: VALUES
4248: (p_interface_type,
4249: 'PON_BID_SHIPMENTS',
4250: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_FROM'), null ),
4251: p_batch_id,
4252: s_interface_line_id,
4253: 'PON_AUC_FROMDATE_AFTER_CURDATE',

Line 4303: 'PON_BID_SHIPMENTS',

4299: WORKSHEET_SEQUENCE_NUMBER,
4300: ENTITY_MESSAGE_CODE)
4301: VALUES
4302: (p_interface_type,
4303: 'PON_BID_SHIPMENTS',
4304: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_FROM'), null ),
4305: p_batch_id,
4306: s_interface_line_id,
4307: 'PON_AUC_BAD_PB_EFF_FDATE_2',

Line 4358: 'PON_BID_SHIPMENTS',

4354: WORKSHEET_SEQUENCE_NUMBER,
4355: ENTITY_MESSAGE_CODE)
4356: VALUES
4357: (p_interface_type,
4358: 'PON_BID_SHIPMENTS',
4359: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_FROM'), null ),
4360: p_batch_id,
4361: s_interface_line_id,
4362: 'PON_AUC_BAD_PB_EFF_FDATE_3',

Line 4413: 'PON_BID_SHIPMENTS',

4409: WORKSHEET_SEQUENCE_NUMBER,
4410: ENTITY_MESSAGE_CODE)
4411: VALUES
4412: (p_interface_type,
4413: 'PON_BID_SHIPMENTS',
4414: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_FROM'), null ),
4415: p_batch_id,
4416: s_interface_line_id,
4417: 'PON_AUC_BAD_PB_EFF_FDATE_1',

Line 4467: 'PON_BID_SHIPMENTS',

4463: WORKSHEET_SEQUENCE_NUMBER,
4464: ENTITY_MESSAGE_CODE)
4465: VALUES
4466: (p_interface_type,
4467: 'PON_BID_SHIPMENTS',
4468: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_TO'), null ),
4469: p_batch_id,
4470: s_interface_line_id,
4471: 'PON_AUC_TODATE_AFTER_CURDATE',

Line 4522: 'PON_BID_SHIPMENTS',

4518: WORKSHEET_SEQUENCE_NUMBER,
4519: ENTITY_MESSAGE_CODE)
4520: VALUES
4521: (p_interface_type,
4522: 'PON_BID_SHIPMENTS',
4523: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_TO'), null ),
4524: p_batch_id,
4525: s_interface_line_id,
4526: 'PON_AUC_BAD_PB_EFF_TDATE_2',

Line 4577: 'PON_BID_SHIPMENTS',

4573: WORKSHEET_SEQUENCE_NUMBER,
4574: ENTITY_MESSAGE_CODE)
4575: VALUES
4576: (p_interface_type,
4577: 'PON_BID_SHIPMENTS',
4578: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_TO'), null ),
4579: p_batch_id,
4580: s_interface_line_id,
4581: 'PON_AUC_BAD_PB_EFF_TDATE_3',

Line 4632: 'PON_BID_SHIPMENTS',

4628: WORKSHEET_SEQUENCE_NUMBER,
4629: ENTITY_MESSAGE_CODE)
4630: VALUES
4631: (p_interface_type,
4632: 'PON_BID_SHIPMENTS',
4633: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_TO'), null ),
4634: p_batch_id,
4635: s_interface_line_id ,
4636: 'PON_AUC_BAD_PB_EFF_TDATE_1',

Line 4689: 'PON_BID_SHIPMENTS',

4685: WORKSHEET_SEQUENCE_NUMBER,
4686: ENTITY_MESSAGE_CODE)
4687: VALUES
4688: (p_interface_type,
4689: 'PON_BID_SHIPMENTS',
4690: p_batch_id,
4691: s_interface_line_id,
4692: 'PON_AUCTS_PB_MUST_BE_ENTERED',
4693: p_userid,

Line 4740: 'PON_BID_SHIPMENTS',

4736: WORKSHEET_SEQUENCE_NUMBER,
4737: ENTITY_MESSAGE_CODE)
4738: VALUES
4739: (p_interface_type,
4740: 'PON_BID_SHIPMENTS',
4741: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_AUCTS_EFFECTIVE_TO'), null ),
4742: p_batch_id,
4743: s_interface_line_id,
4744: 'PON_AUC_INVALID_EFF_DATES',

Line 4793: 'PON_BID_SHIPMENTS',

4789: WORKSHEET_SEQUENCE_NUMBER,
4790: ENTITY_MESSAGE_CODE)
4791: VALUES
4792: (p_interface_type,
4793: 'PON_BID_SHIPMENTS',
4794: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_PRICE'), null ),
4795: p_batch_id,
4796: s_interface_line_id,
4797: 'PON_AUC_PB_PRICE_REQ',

Line 4847: 'PON_BID_SHIPMENTS',

4843: WORKSHEET_SEQUENCE_NUMBER,
4844: ENTITY_MESSAGE_CODE)
4845: VALUES
4846: (p_interface_type,
4847: 'PON_BID_SHIPMENTS',
4848: p_batch_id,
4849: s_interface_line_id,
4850: 'PON_AUCTS_PB_CUMM_EFF_DATES',
4851: p_userid,

Line 4898: FROM pon_bid_shipments bpb

4894: decode(p_spreadsheet, g_xml_upload_mode,
4895: 'PON_AUCTS_PRICE_BREAKS',
4896: null
4897: ) s_entity_name
4898: FROM pon_bid_shipments bpb
4899: , pon_bid_item_prices bl
4900: , pon_auction_item_prices_all al
4901: , pon_bid_headers pbh
4902: WHERE bpb.bid_number = p_bid_number

Line 4994: 'PON_BID_SHIPMENTS',

4990: WORKSHEET_SEQUENCE_NUMBER,
4991: ENTITY_MESSAGE_CODE)
4992: VALUES
4993: (p_interface_type,
4994: 'PON_BID_SHIPMENTS',
4995: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_MIN_QUANTITY'), null ),
4996: p_batch_id,
4997: s_interface_line_id,
4998: 'PON_AUCTS_PT_MIN_QUANTITY_REQ',

Line 5059: 'PON_BID_SHIPMENTS',

5055: ENTITY_MESSAGE_CODE
5056: )
5057: VALUES
5058: (p_interface_type,
5059: 'PON_BID_SHIPMENTS',
5060: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_MAX_QUANTITY'), null ),
5061: p_batch_id,
5062: s_interface_line_id,
5063: 'PON_AUCTS_PT_MAX_QUANTITY_REQ',

Line 5123: 'PON_BID_SHIPMENTS',

5119: ENTITY_MESSAGE_CODE
5120: )
5121: VALUES
5122: (p_interface_type,
5123: 'PON_BID_SHIPMENTS',
5124: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_MIN_QUANTITY'), null ),
5125: p_batch_id,
5126: s_interface_line_id,
5127: 'PON_AUCTS_PT_QUANTITY_POSITIVE',

Line 5187: 'PON_BID_SHIPMENTS',

5183: ENTITY_MESSAGE_CODE
5184: )
5185: VALUES
5186: (p_interface_type,
5187: 'PON_BID_SHIPMENTS',
5188: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_MAX_QUANTITY'), null ),
5189: p_batch_id,
5190: s_interface_line_id,
5191: 'PON_AUCTS_PT_QUANTITY_POSITIVE',

Line 5250: 'PON_BID_SHIPMENTS',

5246: ENTITY_MESSAGE_CODE
5247: )
5248: VALUES
5249: (p_interface_type,
5250: 'PON_BID_SHIPMENTS',
5251: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_MAX_QUANTITY'), null ),
5252: p_batch_id,
5253: s_interface_line_id,
5254: 'PON_QT_MAX_MIN_QTY_ERR',

Line 5279: SELECT 'Y' FROM pon_bid_shipments bpb1 WHERE

5275:
5276: WHEN (
5277: p_spreadsheet = g_xml_upload_mode AND
5278: EXISTS (
5279: SELECT 'Y' FROM pon_bid_shipments bpb1 WHERE
5280: bpb1.auction_header_id = p_auc_header_id AND
5281: bpb1.bid_number = p_bid_number AND
5282: bpb1.line_number = s_line_number AND
5283: bpb1.SHIPMENT_NUMBER <> s_shipment_number AND

Line 5318: 'PON_BID_SHIPMENTS',

5314: WORKSHEET_SEQUENCE_NUMBER,
5315: ENTITY_MESSAGE_CODE)
5316: VALUES
5317: (p_interface_type,
5318: 'PON_BID_SHIPMENTS',
5319: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_MIN_QUANTITY'), null ),
5320: p_batch_id,
5321: s_interface_line_id,
5322: 'PON_AUC_OVERLAP_RANGES_QT',

Line 5350: SELECT 'Y' FROM pon_bid_shipments bpb1 WHERE

5346: --The error message only show up once.
5347: WHEN (
5348: p_spreadsheet = g_xml_upload_mode AND
5349: EXISTS (
5350: SELECT 'Y' FROM pon_bid_shipments bpb1 WHERE
5351: bpb1.auction_header_id = p_auc_header_id AND
5352: bpb1.bid_number = p_bid_number AND
5353: bpb1.line_number = s_line_number AND
5354: bpb1.SHIPMENT_NUMBER <> s_shipment_number AND

Line 5392: 'PON_BID_SHIPMENTS',

5388: WORKSHEET_SEQUENCE_NUMBER,
5389: ENTITY_MESSAGE_CODE)
5390: VALUES
5391: (p_interface_type,
5392: 'PON_BID_SHIPMENTS',
5393: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_MAX_QUANTITY'), null ),
5394: p_batch_id,
5395: s_interface_line_id,
5396: 'PON_AUC_OVERLAP_RANGES_QT',

Line 5451: 'PON_BID_SHIPMENTS',

5447: ENTITY_MESSAGE_CODE
5448: )
5449: VALUES
5450: (p_interface_type,
5451: 'PON_BID_SHIPMENTS',
5452: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_PRICE'), null ),
5453: p_batch_id,
5454: s_interface_line_id,
5455: 'PON_AUC_PT_PRICE_REQ',

Line 5513: 'PON_BID_SHIPMENTS',

5509: ENTITY_MESSAGE_CODE
5510: )
5511: VALUES
5512: (p_interface_type,
5513: 'PON_BID_SHIPMENTS',
5514: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_PRICE'), null ),
5515: p_batch_id,
5516: s_interface_line_id,
5517: 'PON_AUCTS_QT_PRICE_POSITIVE',

Line 5571: 'PON_BID_SHIPMENTS',

5567: ENTITY_MESSAGE_CODE
5568: )
5569: VALUES
5570: (p_interface_type,
5571: 'PON_BID_SHIPMENTS',
5572: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_PRICE'), null ),
5573: p_batch_id,
5574: s_interface_line_id,
5575: 'PON_AUC_QT_INVALID_BID_PREC',

Line 5741: FROM pon_bid_shipments bpb,

5737: decode(p_spreadsheet, g_xml_upload_mode,
5738: 'PON_AUCTS_PRICE_TIERS',
5739: null
5740: ) s_entity_name
5741: FROM pon_bid_shipments bpb,
5742: pon_bid_item_prices bl,
5743: pon_auction_item_prices_all al,
5744: (SELECT MAX(shipments.max_quantity) max_quantity,
5745: shipments.bid_number,

Line 5747: FROM pon_bid_shipments shipments

5743: pon_auction_item_prices_all al,
5744: (SELECT MAX(shipments.max_quantity) max_quantity,
5745: shipments.bid_number,
5746: shipments.line_number
5747: FROM pon_bid_shipments shipments
5748: WHERE shipments.bid_number = p_bid_number
5749: GROUP BY shipments.bid_number,
5750: shipments.line_number) max_bid_shipments
5751: , pon_bid_headers pbh

Line 5794: 'PON_BID_SHIPMENTS',

5790: TOKEN1_NAME,
5791: TOKEN1_VALUE)
5792: SELECT
5793: p_interface_type,
5794: 'PON_BID_SHIPMENTS',
5795: p_batch_id,
5796: bl.interface_line_id,
5797: 'PON_AUC_OVERLAP_RANGES_QT',
5798: p_userid,

Line 5822: FROM pon_bid_shipments pbs,

5818: AND bl.is_changed_line_flag = 'Y'
5819: AND p_spreadsheet = g_online_mode
5820: and bl.line_number in
5821: ( Select distinct pbs.line_number
5822: FROM pon_bid_shipments pbs,
5823: pon_bid_shipments pbs1
5824: WHERE pbs.bid_number = p_bid_number
5825: and pbs1.bid_number = p_bid_number
5826: AND pbs.line_number = pbs1.line_number

Line 5823: pon_bid_shipments pbs1

5819: AND p_spreadsheet = g_online_mode
5820: and bl.line_number in
5821: ( Select distinct pbs.line_number
5822: FROM pon_bid_shipments pbs,
5823: pon_bid_shipments pbs1
5824: WHERE pbs.bid_number = p_bid_number
5825: and pbs1.bid_number = p_bid_number
5826: AND pbs.line_number = pbs1.line_number
5827: AND pbs.shipment_number <> pbs1.shipment_number