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_INTERFACE_ERRORS

Line 10: p_interface_type IN pon_interface_errors.interface_type%TYPE,

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,
14: p_spreadsheet IN VARCHAR2,

Line 11: p_userid IN pon_interface_errors.created_by%TYPE,

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,
14: p_spreadsheet IN VARCHAR2,
15: p_blanket IN VARCHAR2,

Line 31: p_batch_id IN pon_interface_errors.batch_id%TYPE,

27: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,
28: p_amt_precision IN fnd_currencies.precision%TYPE,
29: p_bid_curr_code IN pon_bid_headers.bid_currency_code%TYPE,
30: p_suffix IN VARCHAR2,
31: p_batch_id IN pon_interface_errors.batch_id%TYPE,
32: p_request_id IN pon_interface_errors.request_id%TYPE,
33: p_two_part_tech_surrogate_flag IN VARCHAR2) IS
34:
35: l_price_mask VARCHAR2(80);

Line 32: p_request_id IN pon_interface_errors.request_id%TYPE,

28: p_amt_precision IN fnd_currencies.precision%TYPE,
29: p_bid_curr_code IN pon_bid_headers.bid_currency_code%TYPE,
30: p_suffix IN VARCHAR2,
31: p_batch_id IN pon_interface_errors.batch_id%TYPE,
32: p_request_id IN pon_interface_errors.request_id%TYPE,
33: p_two_part_tech_surrogate_flag IN VARCHAR2) IS
34:
35: l_price_mask VARCHAR2(80);
36: BEGIN

Line 45: INTO pon_interface_errors

41: -- Price and quantity are required fields if they are editable
42: WHEN p_blanket = 'N' AND s_price_editable = 'Y' AND s_price IS null
43: AND s_qty_editable = 'Y' AND s_bid_quantity IS null
44: THEN
45: INTO pon_interface_errors
46: (INTERFACE_TYPE,
47: TABLE_NAME,
48: BATCH_ID,
49: INTERFACE_LINE_ID,

Line 96: INTO pon_interface_errors

92:
93: -- Price is a required field if it is editable
94: WHEN s_price_editable = 'Y' AND s_price IS null
95: THEN
96: INTO pon_interface_errors
97: (INTERFACE_TYPE,
98: TABLE_NAME,
99: COLUMN_NAME,
100: BATCH_ID,

Line 148: INTO pon_interface_errors

144: s_entity_message_code)
145:
146: -- Quantity is a required field if it is editable
147: WHEN p_blanket = 'N' AND s_qty_editable = 'Y' AND s_bid_quantity IS null THEN
148: INTO pon_interface_errors
149: (INTERFACE_TYPE,
150: TABLE_NAME,
151: COLUMN_NAME,
152: BATCH_ID,

Line 201: INTO pon_interface_errors

197:
198: -- Bug 7460446 Bid cannot be zero or negative
199: -- Doesn't apply for blanket agreements
200: WHEN p_blanket = 'N' AND s_bid_quantity <= 0 THEN
201: INTO pon_interface_errors
202: (INTERFACE_TYPE,
203: COLUMN_NAME,
204: TABLE_NAME,
205: BATCH_ID,

Line 257: INTO pon_interface_errors

253: -- The promised date cannot be earlier than the current date
254: -- Does not apply to blanket agreements
255: WHEN p_blanket = 'N' AND s_promised_date < s_current_date
256: THEN
257: INTO pon_interface_errors
258: (INTERFACE_TYPE,
259: COLUMN_NAME,
260: TABLE_NAME,
261: BATCH_ID,

Line 313: INTO pon_interface_errors

309: --CLM Bug : 10212430 : Enter either promise date or POP dates
310: WHEN p_blanket = 'N'
311: AND (s_promised_date is not null and (s_clm_pop_start_date is not null OR s_clm_pop_end_date is not null))
312: THEN
313: INTO pon_interface_errors
314: (INTERFACE_TYPE,
315: COLUMN_NAME,
316: TABLE_NAME,
317: BATCH_ID,

Line 370: INTO pon_interface_errors

366: WHEN p_blanket = 'N'
367: AND (s_promised_date is null and (s_clm_pop_start_date is not null AND s_clm_pop_end_date is null))
368: -- AND p_two_part_tech_surrogate_flag = 'N'
369: THEN
370: INTO pon_interface_errors
371: (INTERFACE_TYPE,
372: COLUMN_NAME,
373: TABLE_NAME,
374: BATCH_ID,

Line 425: INTO pon_interface_errors

421: WHEN p_blanket = 'N'
422: AND (s_promised_date is null and (s_clm_pop_start_date is null AND s_clm_pop_end_date is not null))
423: --AND p_two_part_tech_surrogate_flag = 'N'
424: THEN
425: INTO pon_interface_errors
426: (INTERFACE_TYPE,
427: COLUMN_NAME,
428: TABLE_NAME,
429: BATCH_ID,

Line 481: INTO pon_interface_errors

477: (s_clm_pop_start_date is not null AND s_clm_pop_end_date is not null AND (s_clm_pop_end_date <= s_clm_pop_start_date))
478: )
479: --AND p_two_part_tech_surrogate_flag = 'N'
480: THEN
481: INTO pon_interface_errors
482: (INTERFACE_TYPE,
483: COLUMN_NAME,
484: TABLE_NAME,
485: BATCH_ID,

Line 538: INTO pon_interface_errors

534: (s_clm_pop_start_date is not null AND s_clm_pop_start_date < s_current_date)
535: )
536: --AND p_two_part_tech_surrogate_flag = 'N'
537: THEN
538: INTO pon_interface_errors
539: (INTERFACE_TYPE,
540: COLUMN_NAME,
541: TABLE_NAME,
542: BATCH_ID,

Line 595: INTO pon_interface_errors

591: (s_clm_pop_end_date is not null AND s_clm_pop_end_date < s_current_date)
592: )
593: --AND p_two_part_tech_surrogate_flag = 'N'
594: THEN
595: INTO pon_interface_errors
596: (INTERFACE_TYPE,
597: COLUMN_NAME,
598: TABLE_NAME,
599: BATCH_ID,

Line 651: INTO pon_interface_errors

647: WHEN p_blanket = 'N'
648: AND (s_clm_del_event IS NOT NULL AND
649: (s_clm_promise_period IS NULL OR s_clm_promise_period_uom IS NULL OR s_clm_promise_period_uom = '') )
650: THEN
651: INTO pon_interface_errors
652: (INTERFACE_TYPE,
653: COLUMN_NAME,
654: TABLE_NAME,
655: BATCH_ID,

Line 707: INTO pon_interface_errors

703: AND (s_clm_del_event IS NOT NULL AND
704: s_clm_promise_period IS NOT NULL AND
705: s_clm_promise_period <= 0 )
706: THEN
707: INTO pon_interface_errors
708: (INTERFACE_TYPE,
709: COLUMN_NAME,
710: TABLE_NAME,
711: BATCH_ID,

Line 763: INTO pon_interface_errors

759: AND (s_clm_del_event IS NOT NULL AND
760: s_clm_pop_duration IS NOT NULL AND
761: s_clm_pop_duration <= 0 )
762: THEN
763: INTO pon_interface_errors
764: (INTERFACE_TYPE,
765: COLUMN_NAME,
766: TABLE_NAME,
767: BATCH_ID,

Line 816: INTO pon_interface_errors

812: s_entity_message_code)
813:
814: -- po_bid_min_rel_amount should not be negative
815: WHEN p_blanket = 'Y' AND s_po_bid_min_rel_amount < 0 THEN
816: INTO pon_interface_errors
817: (INTERFACE_TYPE,
818: COLUMN_NAME,
819: TABLE_NAME,
820: BATCH_ID,

Line 870: INTO pon_interface_errors

866:
867: -- po_bid_min_rel_amount should not exceed currency precision
868: WHEN p_blanket = 'Y' AND
869: PON_BID_VALIDATIONS_PKG.validate_currency_precision(s_po_bid_min_rel_amount, p_amt_precision) = 'F' THEN
870: INTO pon_interface_errors
871: (INTERFACE_TYPE,
872: COLUMN_NAME,
873: TABLE_NAME,
874: BATCH_ID,

Line 929: INTO pon_interface_errors

925: AND (p_spreadsheet = g_online_mode OR s_display_price_factors_flag = 'Y')
926: --AND p_two_part_tech_surrogate_flag = 'N'
927:
928: THEN
929: INTO pon_interface_errors
930: (INTERFACE_TYPE,
931: COLUMN_NAME,
932: TABLE_NAME,
933: BATCH_ID,

Line 988: INTO pon_interface_errors

984: PON_BID_VALIDATIONS_PKG.validate_price_precision(s_bid_currency_unit_price, p_price_precision) = 'F'
985: AND (p_spreadsheet = g_online_mode OR s_display_price_factors_flag = 'Y')
986: --AND p_two_part_tech_surrogate_flag = 'N'
987: THEN
988: INTO pon_interface_errors
989: (INTERFACE_TYPE,
990: COLUMN_NAME,
991: TABLE_NAME,
992: BATCH_ID,

Line 1083: INTO pon_interface_errors

1079:
1080: -- bid_currency_price should be positive
1081: WHEN (s_bid_currency_price <= 0 AND s_clm_cost_constraint NOT IN ('NSP', 'NC'))
1082: THEN
1083: INTO pon_interface_errors
1084: (INTERFACE_TYPE,
1085: COLUMN_NAME,
1086: TABLE_NAME,
1087: BATCH_ID,

Line 1143: INTO pon_interface_errors

1139: WHEN
1140: ( (s_order_type_lookup_code = 'QUANTITY') AND
1141: PON_BID_VALIDATIONS_PKG.validate_price_precision(s_bid_currency_price, p_price_precision) = 'F')
1142: THEN
1143: INTO pon_interface_errors
1144: (INTERFACE_TYPE,
1145: COLUMN_NAME,
1146: TABLE_NAME,
1147: BATCH_ID,

Line 1200: INTO pon_interface_errors

1196: WHEN
1197: ( s_order_type_lookup_code <> 'QUANTITY' AND
1198: PON_BID_VALIDATIONS_PKG.validate_price_precision(s_bid_currency_price, p_amt_precision) = 'F')
1199: THEN
1200: INTO pon_interface_errors
1201: (INTERFACE_TYPE,
1202: COLUMN_NAME,
1203: TABLE_NAME,
1204: BATCH_ID,

Line 1266: INTO pon_interface_errors

1262: ---------------------------------------------------
1263: AND p_two_part_tech_surrogate_flag = 'N'
1264: ---------------------------------------------------
1265: THEN
1266: INTO pon_interface_errors
1267: (INTERFACE_TYPE,
1268: COLUMN_NAME,
1269: TABLE_NAME,
1270: BATCH_ID,

Line 1324: INTO pon_interface_errors

1320: -- There was a previous bid on this line which was deleted
1321: -- Not allowed to unbid when rebidding.
1322: /*WHEN p_rebid = 'Y' AND s_is_changed_line_flag = 'Y'
1323: AND s_has_bid_flag = 'N' THEN
1324: INTO pon_interface_errors
1325: (INTERFACE_TYPE,
1326: TABLE_NAME,
1327: BATCH_ID,
1328: INTERFACE_LINE_ID,