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_UNSOL_VALIDATIONS_PKG dependencies on PON_BID_ITEM_PRICES

Line 8: PROCEDURE VALIDATE_UNSOL_LINES( p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,

4: g_exp_date TIMESTAMP;
5: g_exp_days_offset CONSTANT NUMBER := 7;
6:
7:
8: PROCEDURE VALIDATE_UNSOL_LINES( p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
9: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
10: p_interface_type IN pon_interface_errors.interface_type%TYPE,
11: p_userid IN pon_interface_errors.created_by%TYPE,
12: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,

Line 9: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,

5: g_exp_days_offset CONSTANT NUMBER := 7;
6:
7:
8: PROCEDURE VALIDATE_UNSOL_LINES( p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
9: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
10: p_interface_type IN pon_interface_errors.interface_type%TYPE,
11: p_userid IN pon_interface_errors.created_by%TYPE,
12: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
13: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,

Line 70: 'PON_BID_ITEM_PRICES',

66: WORKSHEET_SEQUENCE_NUMBER,
67: ENTITY_MESSAGE_CODE)
68: VALUES
69: (p_interface_type,
70: 'PON_BID_ITEM_PRICES',
71: p_batch_id,
72: s_interface_line_id,
73: 'PON_BID_PRICE_QTY_REQD' || p_suffix,
74: p_userid,

Line 122: 'PON_BID_ITEM_PRICES',

118: WORKSHEET_SEQUENCE_NUMBER,
119: ENTITY_MESSAGE_CODE)
120: VALUES
121: (p_interface_type,
122: 'PON_BID_ITEM_PRICES',
123: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),
124: p_batch_id,
125: s_interface_line_id,
126: 'PON_BID_PRICE_REQUIRED' || p_suffix,

Line 174: 'PON_BID_ITEM_PRICES',

170: WORKSHEET_SEQUENCE_NUMBER,
171: ENTITY_MESSAGE_CODE)
172: VALUES
173: (p_interface_type,
174: 'PON_BID_ITEM_PRICES',
175: fnd_message.get_string('PON', 'PON_AUCTS_BID_QTY' || p_suffix),
176: p_batch_id,
177: s_interface_line_id,
178: 'PON_BID_QUANTITY_REQUIRED' || p_suffix,

Line 229: 'PON_BID_ITEM_PRICES',

225: ENTITY_MESSAGE_CODE)
226: VALUES
227: (p_interface_type,
228: fnd_message.get_string('PON', 'PON_AUCTS_BID_QTY' || p_suffix),
229: 'PON_BID_ITEM_PRICES',
230: p_batch_id,
231: s_interface_line_id,
232: 'PON_AUC_BIDQTY_NEG' || p_suffix,
233: p_userid,

Line 285: 'PON_BID_ITEM_PRICES',

281: ENTITY_MESSAGE_CODE)
282: VALUES
283: (p_interface_type,
284: fnd_message.get_string('PON', 'PON_AUCTS_PROMISED_DATE'),
285: 'PON_BID_ITEM_PRICES',
286: p_batch_id,
287: s_interface_line_id,
288: 'PON_AUC_PDATE_TOO_EARLY',
289: p_userid,

Line 341: 'PON_BID_ITEM_PRICES',

337: ENTITY_MESSAGE_CODE)
338: VALUES
339: (p_interface_type,
340: fnd_message.get_string('PON', 'PON_AUCTS_PROMISED_DATE'),
341: 'PON_BID_ITEM_PRICES',
342: p_batch_id,
343: s_interface_line_id,
344: 'PON_CLM_PROMISE_POPDT_LINE_VAL',
345: p_userid,

Line 397: 'PON_BID_ITEM_PRICES',

393: ENTITY_MESSAGE_CODE)
394: VALUES
395: (p_interface_type,
396: fnd_message.get_string('PON', 'PON_CLM_PROMISE_POP_END_DATE'),
397: 'PON_BID_ITEM_PRICES',
398: p_batch_id,
399: s_interface_line_id,
400: 'PON_CLM_PROMISE_POP_ENDDT_REQ',
401: p_userid,

Line 452: 'PON_BID_ITEM_PRICES',

448: ENTITY_MESSAGE_CODE)
449: VALUES
450: (p_interface_type,
451: fnd_message.get_string('PON', 'PON_CLM_PROMISE_POP_START_DATE'),
452: 'PON_BID_ITEM_PRICES',
453: p_batch_id,
454: s_interface_line_id,
455: 'PON_CLM_PROMISE_POP_STDT_REQ',
456: p_userid,

Line 509: 'PON_BID_ITEM_PRICES',

505: ENTITY_MESSAGE_CODE)
506: VALUES
507: (p_interface_type,
508: fnd_message.get_string('PON', 'PON_CLM_PROMISE_POP_START_DATE'),
509: 'PON_BID_ITEM_PRICES',
510: p_batch_id,
511: s_interface_line_id,
512: 'PON_CLM_PROMISE_POP_DATE_VALX',
513: p_userid,

Line 566: 'PON_BID_ITEM_PRICES',

562: ENTITY_MESSAGE_CODE)
563: VALUES
564: (p_interface_type,
565: fnd_message.get_string('PON', 'PON_CLM_PROMISE_POP_START_DATE'),
566: 'PON_BID_ITEM_PRICES',
567: p_batch_id,
568: s_interface_line_id,
569: 'PON_BID_POP_START_BEF_TODAY',
570: p_userid,

Line 623: 'PON_BID_ITEM_PRICES',

619: ENTITY_MESSAGE_CODE)
620: VALUES
621: (p_interface_type,
622: fnd_message.get_string('PON', 'PON_CLM_PROMISE_POP_END_DATE'),
623: 'PON_BID_ITEM_PRICES',
624: p_batch_id,
625: s_interface_line_id,
626: 'PON_BID_POP_END_BEF_TODAY',
627: p_userid,

Line 679: 'PON_BID_ITEM_PRICES',

675: ENTITY_MESSAGE_CODE)
676: VALUES
677: (p_interface_type,
678: fnd_message.get_string('PON', 'CLM_PROMISE_PERIOD'),
679: 'PON_BID_ITEM_PRICES',
680: p_batch_id,
681: s_interface_line_id,
682: 'PON_BID_PERIOD_REQUIRED',
683: p_userid,

Line 735: 'PON_BID_ITEM_PRICES',

731: ENTITY_MESSAGE_CODE)
732: VALUES
733: (p_interface_type,
734: fnd_message.get_string('PON', 'CLM_PROMISE_PERIOD'),
735: 'PON_BID_ITEM_PRICES',
736: p_batch_id,
737: s_interface_line_id,
738: 'PON_BID_INV_PERIOD',
739: p_userid,

Line 791: 'PON_BID_ITEM_PRICES',

787: ENTITY_MESSAGE_CODE)
788: VALUES
789: (p_interface_type,
790: fnd_message.get_string('PON', 'CLM_POP_DURATION'),
791: 'PON_BID_ITEM_PRICES',
792: p_batch_id,
793: s_interface_line_id,
794: 'PON_BID_INV_POP_DUR',
795: p_userid,

Line 844: 'PON_BID_ITEM_PRICES',

840: ENTITY_MESSAGE_CODE)
841: VALUES
842: (p_interface_type,
843: fnd_message.get_string('PON', 'PON_AUC_BID_MIN_REL_AMOUNT' || p_suffix),
844: 'PON_BID_ITEM_PRICES',
845: p_batch_id,
846: s_interface_line_id,
847: 'PON_AUC_MINREL_POS_ZERO' || p_suffix,
848: p_userid,

Line 898: 'PON_BID_ITEM_PRICES',

894: ENTITY_MESSAGE_CODE)
895: VALUES
896: (p_interface_type,
897: fnd_message.get_string('PON', 'PON_AUC_BID_MIN_REL_AMOUNT' || p_suffix),
898: 'PON_BID_ITEM_PRICES',
899: p_batch_id,
900: s_interface_line_id,
901: 'PON_AUC_MINREL_MIN_PREC' || p_suffix,
902: p_userid,

Line 957: 'PON_BID_ITEM_PRICES',

953: ENTITY_MESSAGE_CODE)
954: VALUES
955: (p_interface_type,
956: fnd_message.get_string('PON', 'PON_AUCTION_ITEM_PRICE' || p_suffix),
957: 'PON_BID_ITEM_PRICES',
958: p_batch_id,
959: s_interface_line_id,
960: 'PON_LINEPRICE_MUST_BE_POS',
961: p_userid,

Line 1016: 'PON_BID_ITEM_PRICES',

1012: ENTITY_MESSAGE_CODE)
1013: VALUES
1014: (p_interface_type,
1015: fnd_message.get_string('PON', 'PON_AUCTION_ITEM_PRICE' || p_suffix),
1016: 'PON_BID_ITEM_PRICES',
1017: p_batch_id,
1018: s_interface_line_id,
1019: 'PON_LINEPRICE_MIN_PREC' || p_suffix,
1020: p_userid,

Line 1067: FROM pon_bid_item_prices bl

1063: bl.CLM_DELIVERY_EVENT_CODE s_clm_del_event,
1064: bl.CLM_PROMISE_PERIOD s_clm_promise_period,
1065: bl.CLM_PROMISE_PERIOD_UOM s_clm_promise_period_uom,
1066: bl.CLM_PROMISE_POP_DURATION s_clm_pop_duration
1067: FROM pon_bid_item_prices bl
1068: , pon_bid_headers pbh
1069: WHERE pbh.auction_header_id = p_auc_header_id
1070: AND pbh.bid_number = p_bid_number
1071: AND bl.bid_number = pbh.bid_number

Line 1111: 'PON_BID_ITEM_PRICES',

1107: ENTITY_MESSAGE_CODE)
1108: VALUES
1109: (p_interface_type,
1110: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),
1111: 'PON_BID_ITEM_PRICES',
1112: p_batch_id,
1113: s_interface_line_id,
1114: decode(p_trans_view, 'N',
1115: 'PON_AUC_BIDPRICE_MUST_BE_POS' || p_suffix,

Line 1171: 'PON_BID_ITEM_PRICES',

1167: ENTITY_MESSAGE_CODE)
1168: VALUES
1169: (p_interface_type,
1170: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),
1171: 'PON_BID_ITEM_PRICES',
1172: p_batch_id,
1173: s_interface_line_id,
1174: 'PON_AUCTS_BIDPRICE_MIN_PREC' || p_suffix,
1175: p_userid,

Line 1228: 'PON_BID_ITEM_PRICES',

1224: ENTITY_MESSAGE_CODE)
1225: VALUES
1226: (p_interface_type,
1227: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),
1228: 'PON_BID_ITEM_PRICES',
1229: p_batch_id,
1230: s_interface_line_id,
1231: 'PON_AUCTS_BIDPRICE_MIN_PREC' || p_suffix,
1232: p_userid,

Line 1294: 'PON_BID_ITEM_PRICES',

1290: ENTITY_MESSAGE_CODE)
1291: VALUES
1292: (p_interface_type,
1293: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),
1294: 'PON_BID_ITEM_PRICES',
1295: p_batch_id,
1296: s_interface_line_id,
1297: decode(p_bid_decr_method,'BEST_PRICE','PON_BESTBID_PRICE_LOWER','PON_BID_PRICE_LOWER') || p_suffix,
1298: p_userid,

Line 1346: 'PON_BID_ITEM_PRICES',

1342: WORKSHEET_SEQUENCE_NUMBER,
1343: ENTITY_MESSAGE_CODE)
1344: VALUES
1345: (p_interface_type,
1346: 'PON_BID_ITEM_PRICES',
1347: p_batch_id,
1348: s_interface_line_id,
1349: 'PON_CANNOT_UNBID' || p_suffix,
1350: p_userid,

Line 1393: pon_bid_item_prices bl

1389: bl.line_num_display s_clm_line_num_display,
1390: nvl(bl.clm_cost_constraint,'X') s_clm_cost_constraint, -- CLM QA Bug : 9835426
1391: bl.order_type_lookup_code s_order_type_lookup_code --For clm bug : 10136754
1392: FROM pon_bid_headers bh,
1393: pon_bid_item_prices bl
1394: WHERE bh.auction_header_id = p_auc_header_id
1395: AND bh.bid_number = p_bid_number
1396: AND bl.bid_number = bh.bid_number
1397: AND bl.auction_line_number = -1