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_AUC_INTERFACE_TABLE_PKG dependencies on PON_INTERFACE_ERRORS

Line 96: THEN INTO pon_interface_errors

92: (
93: selected_price_element_type_id = -10
94: )
95:
96: THEN INTO pon_interface_errors
97: (
98: BATCH_ID,
99: INTERFACE_LINE_ID,
100: TABLE_NAME,

Line 122: THEN into pon_interface_errors

118: WHEN
119: (
120: selected_price_element_type_id is null
121: )
122: THEN into pon_interface_errors
123: (
124: BATCH_ID,
125: INTERFACE_LINE_ID,
126: TABLE_NAME,

Line 147: THEN into pon_interface_errors

143: WHEN
144: (
145: selected_pricing_basis is null
146: )
147: THEN into pon_interface_errors
148: (
149: BATCH_ID,
150: INTERFACE_LINE_ID,
151: TABLE_NAME,

Line 191: THEN into pon_interface_errors

187: WHEN
188: (
189: selected_sequence_number is null
190: )
191: THEN into pon_interface_errors
192: (
193: BATCH_ID,
194: INTERFACE_LINE_ID,
195: TABLE_NAME,

Line 218: THEN into pon_interface_errors

214: (
215: selected_pricing_basis = 'FIXED_AMOUNT'
216: and selected_precision > p_fnd_currency_precision
217: )
218: THEN into pon_interface_errors
219: (
220: BATCH_ID,
221: INTERFACE_LINE_ID,
222: TABLE_NAME,

Line 244: THEN into pon_interface_errors

240: (
241: selected_pricing_basis = 'PER_UNIT'
242: and selected_precision > p_num_price_decimals
243: )
244: THEN into pon_interface_errors
245: (
246: BATCH_ID,
247: INTERFACE_LINE_ID,
248: TABLE_NAME,

Line 269: THEN into pon_interface_errors

265: WHEN
266: (
267: selected_value < 0
268: )
269: THEN into pon_interface_errors
270: (
271: BATCH_ID,
272: INTERFACE_LINE_ID,
273: TABLE_NAME,

Line 294: THEN into pon_interface_errors

290: WHEN
291: (
292: nvl(selected_display_target_flag,'N') not in ('Y','N')
293: )
294: THEN into pon_interface_errors
295: (
296: BATCH_ID,
297: INTERFACE_LINE_ID,
298: TABLE_NAME,

Line 321: THEN into pon_interface_errors

317: selected_value is null and
318: selected_display_target_flag = 'Y'
319: )
320:
321: THEN into pon_interface_errors
322: (
323: BATCH_ID,
324: INTERFACE_LINE_ID,
325: TABLE_NAME,

Line 349: THEN into pon_interface_errors

345: selected_pricing_basis <> 'FIXED_AMOUNT'
346: and selected_pricing_basis <> 'PERCENTAGE'
347: and sel_order_type_lookup_code = 'FIXED PRICE'
348: )
349: THEN into pon_interface_errors
350: (
351: BATCH_ID,
352: INTERFACE_LINE_ID,
353: TABLE_NAME,

Line 374: THEN into pon_interface_errors

370: WHEN
371: (
372: selected_enabled_flag = 'N'
373: )
374: THEN into pon_interface_errors
375: (
376: BATCH_ID,
377: INTERFACE_LINE_ID,
378: TABLE_NAME,

Line 420: insert into pon_interface_errors (

416: AND pape.auction_header_id = ip.auction_header_id
417: AND pape.interface_line_id = ip.interface_line_id;
418:
419: -- perform duplicate checks (using price element type id)
420: insert into pon_interface_errors (
421: BATCH_ID,
422: INTERFACE_LINE_ID,
423: TABLE_NAME,
424: COLUMN_NAME,

Line 446: insert into pon_interface_errors (

442:
443: -- validate that in the amendment creation flow or new negotiation round creation flow
444: -- an uploaded supplier price factor cannot replace an existing buyer price factor with the same name
445: -- if the buyer price factor already has supplier values defined
446: insert into pon_interface_errors (
447: BATCH_ID,
448: INTERFACE_LINE_ID,
449: TABLE_NAME,
450: COLUMN_NAME,

Line 530: then into pon_interface_errors

526: and selected_weight is not null
527: and (selected_weight > 100
528: or selected_weight < 0 )
529: )
530: then into pon_interface_errors
531: (
532: BATCH_ID,
533: INTERFACE_LINE_ID,
534: TABLE_NAME,

Line 557: then into pon_interface_errors

553: selected_auction_line_number = -1
554: and (selected_aTTR_MAX_SCORE is not null and selected_ATTR_MAX_SCORE <> 0)
555: and selected_DISPLAY_ONLY_FLAG = 'Y'
556: )
557: then into pon_interface_errors
558: (
559: BATCH_ID,
560: INTERFACE_LINE_ID,
561: TABLE_NAME,

Line 583: then into pon_interface_errors

579: selected_auction_line_number = -1
580: and selected_ATTR_MAX_SCORE is not null
581: and selected_ATTR_MAX_SCORE < 0
582: )
583: then into pon_interface_errors
584: (
585: BATCH_ID,
586: INTERFACE_LINE_ID,
587: TABLE_NAME,

Line 780: THEN into pon_interface_errors

776: WHEN
777: (
778: selected_datatype is null
779: )
780: THEN into pon_interface_errors
781: (
782: BATCH_ID,
783: INTERFACE_LINE_ID,
784: TABLE_NAME,

Line 806: THEN into pon_interface_errors

802: WHEN
803: (
804: selected_response_type is null
805: )
806: THEN into pon_interface_errors
807: (
808: BATCH_ID,
809: INTERFACE_LINE_ID,
810: TABLE_NAME,

Line 832: THEN into pon_interface_errors

828: (
829: nvl(selected_display_target_flag,'N') not in ('Y','N')
830: )
831:
832: THEN into pon_interface_errors
833: (
834: BATCH_ID,
835: INTERFACE_LINE_ID,
836: TABLE_NAME,

Line 861: then into pon_interface_errors

857: from fnd_lookups
858: where lookup_type = 'PON_AUCTION_ATTRIBUTE_TYPE'
859: )
860: )
861: then into pon_interface_errors
862: (
863: BATCH_ID,
864: INTERFACE_LINE_ID,
865: TABLE_NAME,

Line 886: then into pon_interface_errors

882: when
883: (
884: nvl(selected_display_target_flag,'N') not in ('Y','N')
885: )
886: then into pon_interface_errors
887: (
888: BATCH_ID,
889: INTERFACE_LINE_ID,
890: TABLE_NAME,

Line 910: then into pon_interface_errors

906: (
907: selected_display_target_flag = 'Y'
908: and selected_value is null
909: )
910: then into pon_interface_errors
911: (
912: BATCH_ID,
913: INTERFACE_LINE_ID,
914: TABLE_NAME,

Line 937: then into pon_interface_errors

933: and selected_value is null
934: -- Bug 6957765
935: and nvl(selected_display_target_flag,'N') = 'Y'
936: )
937: then into pon_interface_errors
938: (
939: BATCH_ID,
940: INTERFACE_LINE_ID,
941: TABLE_NAME,

Line 963: then into pon_interface_errors

959: when
960: (
961: selected_attribute_name is null
962: )
963: then into pon_interface_errors
964: (
965: BATCH_ID,
966: INTERFACE_LINE_ID,
967: TABLE_NAME,

Line 991: then into pon_interface_errors

987: (
988: l_attr_type_header = 'N' AND
989: selected_sequence_number is null
990: )
991: then into pon_interface_errors
992: (
993: BATCH_ID,
994: INTERFACE_LINE_ID,
995: TABLE_NAME,

Line 1016: then into pon_interface_errors

1012: (
1013: selected_group_code is null
1014: AND l_attr_type_header = 'N'
1015: )
1016: then into pon_interface_errors
1017: (
1018: BATCH_ID,
1019: INTERFACE_LINE_ID,
1020: TABLE_NAME,

Line 1042: then into pon_interface_errors

1038: nvl(selected_display_target_flag,'N') = 'Y'
1039: and selected_internal_attr_flag = 'Y'
1040: and l_attr_type_header = 'Y'
1041: )
1042: then into pon_interface_errors
1043: (
1044: BATCH_ID,
1045: INTERFACE_LINE_ID,
1046: TABLE_NAME,

Line 1083: insert into pon_interface_errors (

1079: pai.batch_id = p_batch_id;
1080:
1081: -- perform duplicate checks
1082: IF ( p_attr_type_header ) THEN
1083: insert into pon_interface_errors (
1084: BATCH_ID,
1085: INTERFACE_LINE_ID,
1086: TABLE_NAME,
1087: COLUMN_NAME,

Line 1106: insert into pon_interface_errors (

1102: and pai1.auction_line_number = pai2.auction_line_number
1103: and upper(pai1.attribute_name) = upper(pai2.attribute_name)
1104: and pai1.interface_line_id <> pai2.interface_line_id;
1105: ELSE
1106: insert into pon_interface_errors (
1107: BATCH_ID,
1108: INTERFACE_LINE_ID,
1109: TABLE_NAME,
1110: COLUMN_NAME,

Line 1132: insert into pon_interface_errors (

1128: END IF;
1129:
1130: -- duplicate check against the allready saved header attributes.
1131: IF ( p_attr_type_header ) THEN
1132: insert into pon_interface_errors (
1133: BATCH_ID,
1134: INTERFACE_LINE_ID,
1135: TABLE_NAME,
1136: COLUMN_NAME,

Line 1407: THEN INTO pon_interface_errors

1403: (
1404: selected_multiplier <> -9999
1405: AND selected_price_type_name = 'EMPTY_PRICE_TYPE_NAME'
1406: )
1407: THEN INTO pon_interface_errors
1408: (
1409: BATCH_ID,
1410: INTERFACE_LINE_ID,
1411: TABLE_NAME,

Line 1434: THEN INTO pon_interface_errors

1430: (
1431: selected_price_type_name = 'PRICE_TYPE_INVALID'
1432: AND selected_price_type_name <> 'EMPTY_PRICE_TYPE_NAME'
1433: )
1434: THEN INTO pon_interface_errors
1435: (
1436: BATCH_ID,
1437: INTERFACE_LINE_ID,
1438: TABLE_NAME,

Line 1466: pon_interface_errors (

1462:
1463: -- Price Type errors will go into the interface table
1464: -- Check if there are any duplicate values
1465: INSERT INTO
1466: pon_interface_errors (
1467: BATCH_ID,
1468: INTERFACE_LINE_ID,
1469: TABLE_NAME,
1470: COLUMN_NAME,