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 783: THEN into pon_interface_errors

779: WHEN
780: (
781: selected_datatype is null
782: )
783: THEN into pon_interface_errors
784: (
785: BATCH_ID,
786: INTERFACE_LINE_ID,
787: TABLE_NAME,

Line 809: THEN into pon_interface_errors

805: WHEN
806: (
807: selected_response_type is null
808: )
809: THEN into pon_interface_errors
810: (
811: BATCH_ID,
812: INTERFACE_LINE_ID,
813: TABLE_NAME,

Line 835: THEN into pon_interface_errors

831: (
832: nvl(selected_display_target_flag,'N') not in ('Y','N')
833: )
834:
835: THEN into pon_interface_errors
836: (
837: BATCH_ID,
838: INTERFACE_LINE_ID,
839: TABLE_NAME,

Line 864: then into pon_interface_errors

860: from fnd_lookups
861: where lookup_type = 'PON_AUCTION_ATTRIBUTE_TYPE'
862: )
863: )
864: then into pon_interface_errors
865: (
866: BATCH_ID,
867: INTERFACE_LINE_ID,
868: TABLE_NAME,

Line 889: then into pon_interface_errors

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

Line 913: then into pon_interface_errors

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

Line 940: then into pon_interface_errors

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

Line 966: then into pon_interface_errors

962: when
963: (
964: selected_attribute_name is null
965: )
966: then into pon_interface_errors
967: (
968: BATCH_ID,
969: INTERFACE_LINE_ID,
970: TABLE_NAME,

Line 994: then into pon_interface_errors

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

Line 1020: then into pon_interface_errors

1016: selected_group_code is null
1017: AND l_attr_type_header = 'N'
1018: AND selected_auction_line_num <> -1 -- bug 16801086
1019: )
1020: then into pon_interface_errors
1021: (
1022: BATCH_ID,
1023: INTERFACE_LINE_ID,
1024: TABLE_NAME,

Line 1046: then into pon_interface_errors

1042: nvl(selected_display_target_flag,'N') = 'Y'
1043: and selected_internal_attr_flag = 'Y'
1044: and l_attr_type_header = 'Y'
1045: )
1046: then into pon_interface_errors
1047: (
1048: BATCH_ID,
1049: INTERFACE_LINE_ID,
1050: TABLE_NAME,

Line 1088: insert into pon_interface_errors (

1084: pai.batch_id = p_batch_id;
1085:
1086: -- perform duplicate checks
1087: IF ( p_attr_type_header ) THEN
1088: insert into pon_interface_errors (
1089: BATCH_ID,
1090: INTERFACE_LINE_ID,
1091: TABLE_NAME,
1092: COLUMN_NAME,

Line 1111: insert into pon_interface_errors (

1107: and pai1.auction_line_number = pai2.auction_line_number
1108: and upper(pai1.attribute_name) = upper(pai2.attribute_name)
1109: and pai1.interface_line_id <> pai2.interface_line_id;
1110: ELSE
1111: insert into pon_interface_errors (
1112: BATCH_ID,
1113: INTERFACE_LINE_ID,
1114: TABLE_NAME,
1115: COLUMN_NAME,

Line 1137: insert into pon_interface_errors (

1133: END IF;
1134:
1135: -- duplicate check against the allready saved header attributes.
1136: IF ( p_attr_type_header ) THEN
1137: insert into pon_interface_errors (
1138: BATCH_ID,
1139: INTERFACE_LINE_ID,
1140: TABLE_NAME,
1141: COLUMN_NAME,

Line 1412: THEN INTO pon_interface_errors

1408: (
1409: selected_multiplier <> -9999
1410: AND selected_price_type_name = 'EMPTY_PRICE_TYPE_NAME'
1411: )
1412: THEN INTO pon_interface_errors
1413: (
1414: BATCH_ID,
1415: INTERFACE_LINE_ID,
1416: TABLE_NAME,

Line 1439: THEN INTO pon_interface_errors

1435: (
1436: selected_price_type_name = 'PRICE_TYPE_INVALID'
1437: AND selected_price_type_name <> 'EMPTY_PRICE_TYPE_NAME'
1438: )
1439: THEN INTO pon_interface_errors
1440: (
1441: BATCH_ID,
1442: INTERFACE_LINE_ID,
1443: TABLE_NAME,

Line 1471: pon_interface_errors (

1467:
1468: -- Price Type errors will go into the interface table
1469: -- Check if there are any duplicate values
1470: INSERT INTO
1471: pon_interface_errors (
1472: BATCH_ID,
1473: INTERFACE_LINE_ID,
1474: TABLE_NAME,
1475: COLUMN_NAME,

Line 1880: then into pon_interface_errors

1876: and (selected_weight > 100
1877: or selected_weight < 0 )
1878: AND Nvl(selected_action,'INSERT') = 'INSERT'
1879: )
1880: then into pon_interface_errors
1881: (
1882: BATCH_ID,
1883: INTERFACE_LINE_ID,
1884: TABLE_NAME,

Line 1908: then into pon_interface_errors

1904: and (selected_aTTR_MAX_SCORE is not null and selected_ATTR_MAX_SCORE <> 0)
1905: and selected_DISPLAY_ONLY_FLAG = 'Y'
1906: AND Nvl(selected_action,'INSERT') = 'INSERT'
1907: )
1908: then into pon_interface_errors
1909: (
1910: BATCH_ID,
1911: INTERFACE_LINE_ID,
1912: TABLE_NAME,

Line 1935: then into pon_interface_errors

1931: and selected_ATTR_MAX_SCORE is not null
1932: and selected_ATTR_MAX_SCORE < 0
1933: AND Nvl(selected_action,'INSERT') = 'INSERT'
1934: )
1935: then into pon_interface_errors
1936: (
1937: BATCH_ID,
1938: INTERFACE_LINE_ID,
1939: TABLE_NAME,

Line 2129: THEN into pon_interface_errors

2125: (
2126: selected_datatype is NULL
2127: AND Nvl(selected_action,'INSERT') = 'INSERT'
2128: )
2129: THEN into pon_interface_errors
2130: (
2131: BATCH_ID,
2132: INTERFACE_LINE_ID,
2133: TABLE_NAME,

Line 2156: THEN into pon_interface_errors

2152: (
2153: selected_response_type is NULL
2154: AND Nvl(selected_action,'INSERT')='INSERT'
2155: )
2156: THEN into pon_interface_errors
2157: (
2158: BATCH_ID,
2159: INTERFACE_LINE_ID,
2160: TABLE_NAME,

Line 2183: THEN into pon_interface_errors

2179: nvl(selected_display_target_flag,'N') not in ('Y','N')
2180: AND Nvl(selected_action,'INSERT') = 'INSERT'
2181: )
2182:
2183: THEN into pon_interface_errors
2184: (
2185: BATCH_ID,
2186: INTERFACE_LINE_ID,
2187: TABLE_NAME,

Line 2213: then into pon_interface_errors

2209: where lookup_type = 'PON_AUCTION_ATTRIBUTE_TYPE'
2210: )
2211: AND Nvl(selected_action,'INSERT') = 'INSERT'
2212: )
2213: then into pon_interface_errors
2214: (
2215: BATCH_ID,
2216: INTERFACE_LINE_ID,
2217: TABLE_NAME,

Line 2239: then into pon_interface_errors

2235: (
2236: nvl(selected_display_target_flag,'N') not in ('Y','N')
2237: AND Nvl(selected_action,'INSERT')='INSERT'
2238: )
2239: then into pon_interface_errors
2240: (
2241: BATCH_ID,
2242: INTERFACE_LINE_ID,
2243: TABLE_NAME,

Line 2264: then into pon_interface_errors

2260: selected_display_target_flag = 'Y'
2261: and selected_value is NULL
2262: AND Nvl(selected_action,'INSERT') = 'INSERT'
2263: )
2264: then into pon_interface_errors
2265: (
2266: BATCH_ID,
2267: INTERFACE_LINE_ID,
2268: TABLE_NAME,

Line 2292: then into pon_interface_errors

2288: -- Bug 6957765
2289: and nvl(selected_display_target_flag,'N') = 'Y'
2290: AND Nvl(selected_action,'INSERT') = 'INSERT'
2291: )
2292: then into pon_interface_errors
2293: (
2294: BATCH_ID,
2295: INTERFACE_LINE_ID,
2296: TABLE_NAME,

Line 2319: then into pon_interface_errors

2315: (
2316: selected_attribute_name is NULL
2317: AND Nvl(selected_action,'INSERT') = 'INSERT'
2318: )
2319: then into pon_interface_errors
2320: (
2321: BATCH_ID,
2322: INTERFACE_LINE_ID,
2323: TABLE_NAME,

Line 2348: then into pon_interface_errors

2344: l_attr_type_header = 'N' AND
2345: selected_sequence_number is NULL
2346: AND Nvl(selected_action,'INSERT') = 'INSERT'
2347: )
2348: then into pon_interface_errors
2349: (
2350: BATCH_ID,
2351: INTERFACE_LINE_ID,
2352: TABLE_NAME,

Line 2375: then into pon_interface_errors

2371: AND l_attr_type_header = 'N'
2372: AND Nvl(selected_action,'INSERT') = 'INSERT'
2373: AND selected_auction_line_num <> -1 -- bug 16801086
2374: )
2375: then into pon_interface_errors
2376: (
2377: BATCH_ID,
2378: INTERFACE_LINE_ID,
2379: TABLE_NAME,

Line 2402: then into pon_interface_errors

2398: and selected_internal_attr_flag = 'Y'
2399: and l_attr_type_header = 'Y'
2400: AND Nvl(selected_action,'INSERT') = 'INSERT'
2401: )
2402: then into pon_interface_errors
2403: (
2404: BATCH_ID,
2405: INTERFACE_LINE_ID,
2406: TABLE_NAME,

Line 2428: then into pon_interface_errors

2424: selected_scoring_type='NONE'
2425: AND ((selected_interface_line_id>0 AND Nvl(selected_weight,0)>0) OR (selected_interface_line_id=-1 AND selected_weight IS NOT null))
2426: AND Nvl(selected_action,'INSERT') = 'INSERT'
2427: )
2428: then into pon_interface_errors
2429: (
2430: BATCH_ID,
2431: INTERFACE_LINE_ID,
2432: TABLE_NAME,

Line 2473: insert into pon_interface_errors (

2469: pai.batch_id = p_batch_id;
2470:
2471: -- perform duplicate checks
2472: IF ( p_attr_type_header ) THEN
2473: insert into pon_interface_errors (
2474: BATCH_ID,
2475: INTERFACE_LINE_ID,
2476: TABLE_NAME,
2477: COLUMN_NAME,

Line 2497: insert into pon_interface_errors (

2493: and upper(pai1.attribute_name) = upper(pai2.attribute_name)
2494: and pai1.interface_line_id <> pai2.interface_line_id
2495: AND Nvl(pai1.action,'INSERT')='INSERT';
2496: ELSE
2497: insert into pon_interface_errors (
2498: BATCH_ID,
2499: INTERFACE_LINE_ID,
2500: TABLE_NAME,
2501: COLUMN_NAME,

Line 2524: insert into pon_interface_errors (

2520: END IF;
2521:
2522: -- duplicate check against the allready saved header attributes.
2523: IF ( p_attr_type_header ) THEN
2524: insert into pon_interface_errors (
2525: BATCH_ID,
2526: INTERFACE_LINE_ID,
2527: TABLE_NAME,
2528: COLUMN_NAME,

Line 2553: --Description : insert a record in pon_interface_errors table for validation failures

2549: END validate_attributes_api;
2550: -----------------------------------------------------------------------
2551: --Start of Comments
2552: --Name: insert_error_interface
2553: --Description : insert a record in pon_interface_errors table for validation failures
2554: --Parameters:
2555: --IN:
2556: -- l_BATCH_ID
2557: -- l_INTERFACE_LINE_ID

Line 2570: l_BATCH_ID IN PON_INTERFACE_ERRORS.BATCH_ID%TYPE,

2566: --End of Comments
2567: ------------------------------------------------------------------------
2568: PROCEDURE INSERT_ERROR_INTERFACE
2569: (
2570: l_BATCH_ID IN PON_INTERFACE_ERRORS.BATCH_ID%TYPE,
2571: l_INTERFACE_LINE_ID IN PON_INTERFACE_ERRORS.INTERFACE_LINE_ID%TYPE,
2572: l_TABLE_NAME IN PON_INTERFACE_ERRORS.TABLE_NAME%TYPE,
2573: l_COLUMN_NAME IN PON_INTERFACE_ERRORS.COLUMN_NAME%TYPE,
2574: l_ERROR_MESSAGE_NAME IN PON_INTERFACE_ERRORS.ERROR_MESSAGE_NAME%TYPE,

Line 2571: l_INTERFACE_LINE_ID IN PON_INTERFACE_ERRORS.INTERFACE_LINE_ID%TYPE,

2567: ------------------------------------------------------------------------
2568: PROCEDURE INSERT_ERROR_INTERFACE
2569: (
2570: l_BATCH_ID IN PON_INTERFACE_ERRORS.BATCH_ID%TYPE,
2571: l_INTERFACE_LINE_ID IN PON_INTERFACE_ERRORS.INTERFACE_LINE_ID%TYPE,
2572: l_TABLE_NAME IN PON_INTERFACE_ERRORS.TABLE_NAME%TYPE,
2573: l_COLUMN_NAME IN PON_INTERFACE_ERRORS.COLUMN_NAME%TYPE,
2574: l_ERROR_MESSAGE_NAME IN PON_INTERFACE_ERRORS.ERROR_MESSAGE_NAME%TYPE,
2575: l_ERROR_VALUE IN PON_INTERFACE_ERRORS.ERROR_VALUE%TYPE)

Line 2572: l_TABLE_NAME IN PON_INTERFACE_ERRORS.TABLE_NAME%TYPE,

2568: PROCEDURE INSERT_ERROR_INTERFACE
2569: (
2570: l_BATCH_ID IN PON_INTERFACE_ERRORS.BATCH_ID%TYPE,
2571: l_INTERFACE_LINE_ID IN PON_INTERFACE_ERRORS.INTERFACE_LINE_ID%TYPE,
2572: l_TABLE_NAME IN PON_INTERFACE_ERRORS.TABLE_NAME%TYPE,
2573: l_COLUMN_NAME IN PON_INTERFACE_ERRORS.COLUMN_NAME%TYPE,
2574: l_ERROR_MESSAGE_NAME IN PON_INTERFACE_ERRORS.ERROR_MESSAGE_NAME%TYPE,
2575: l_ERROR_VALUE IN PON_INTERFACE_ERRORS.ERROR_VALUE%TYPE)
2576: IS

Line 2573: l_COLUMN_NAME IN PON_INTERFACE_ERRORS.COLUMN_NAME%TYPE,

2569: (
2570: l_BATCH_ID IN PON_INTERFACE_ERRORS.BATCH_ID%TYPE,
2571: l_INTERFACE_LINE_ID IN PON_INTERFACE_ERRORS.INTERFACE_LINE_ID%TYPE,
2572: l_TABLE_NAME IN PON_INTERFACE_ERRORS.TABLE_NAME%TYPE,
2573: l_COLUMN_NAME IN PON_INTERFACE_ERRORS.COLUMN_NAME%TYPE,
2574: l_ERROR_MESSAGE_NAME IN PON_INTERFACE_ERRORS.ERROR_MESSAGE_NAME%TYPE,
2575: l_ERROR_VALUE IN PON_INTERFACE_ERRORS.ERROR_VALUE%TYPE)
2576: IS
2577: l_status NUMBER;

Line 2574: l_ERROR_MESSAGE_NAME IN PON_INTERFACE_ERRORS.ERROR_MESSAGE_NAME%TYPE,

2570: l_BATCH_ID IN PON_INTERFACE_ERRORS.BATCH_ID%TYPE,
2571: l_INTERFACE_LINE_ID IN PON_INTERFACE_ERRORS.INTERFACE_LINE_ID%TYPE,
2572: l_TABLE_NAME IN PON_INTERFACE_ERRORS.TABLE_NAME%TYPE,
2573: l_COLUMN_NAME IN PON_INTERFACE_ERRORS.COLUMN_NAME%TYPE,
2574: l_ERROR_MESSAGE_NAME IN PON_INTERFACE_ERRORS.ERROR_MESSAGE_NAME%TYPE,
2575: l_ERROR_VALUE IN PON_INTERFACE_ERRORS.ERROR_VALUE%TYPE)
2576: IS
2577: l_status NUMBER;
2578: BEGIN

Line 2575: l_ERROR_VALUE IN PON_INTERFACE_ERRORS.ERROR_VALUE%TYPE)

2571: l_INTERFACE_LINE_ID IN PON_INTERFACE_ERRORS.INTERFACE_LINE_ID%TYPE,
2572: l_TABLE_NAME IN PON_INTERFACE_ERRORS.TABLE_NAME%TYPE,
2573: l_COLUMN_NAME IN PON_INTERFACE_ERRORS.COLUMN_NAME%TYPE,
2574: l_ERROR_MESSAGE_NAME IN PON_INTERFACE_ERRORS.ERROR_MESSAGE_NAME%TYPE,
2575: l_ERROR_VALUE IN PON_INTERFACE_ERRORS.ERROR_VALUE%TYPE)
2576: IS
2577: l_status NUMBER;
2578: BEGIN
2579: INSERT

Line 2580: INTO pon_interface_errors

2576: IS
2577: l_status NUMBER;
2578: BEGIN
2579: INSERT
2580: INTO pon_interface_errors
2581: (
2582: BATCH_ID ,
2583: INTERFACE_LINE_ID ,
2584: TABLE_NAME ,

Line 2628: l_TABLE_NAME PON_INTERFACE_ERRORS.TABLE_NAME%TYPE :='PON_AUC_ATTRIBUTES_INTERFACE';

2624: --p_in_rec.l_SCORING_METHOD PON_AUCTION_ATTRIBUTES.SCORING_METHOD%TYPE,
2625: x_return_status OUT NOCOPY VARCHAR
2626: )
2627: IS
2628: l_TABLE_NAME PON_INTERFACE_ERRORS.TABLE_NAME%TYPE :='PON_AUC_ATTRIBUTES_INTERFACE';
2629: --p_in_rec.l_KNOCKOUT_SCORE PON_AUCTION_ATTRIBUTES.KNOCKOUT_SCORE%TYPE:=NULL;
2630: l_status NUMBER;
2631: BEGIN
2632: x_return_status := 'Y';