[Home] [Help]
35: into l_auction_header_id
36: from pon_auc_price_elements_int pape
37: where pape.batch_id = p_batch_id;
38:
39: select pon_auction_pkg.get_message_suffix(doc.internal_name)
40: into l_message_suffix
41: from pon_auction_headers_all pah,
42: pon_auc_doctypes doc
43: where pah.auction_header_id = l_auction_header_id
499: into l_hdr_attr_enable_weights
500: from pon_auction_headers_all pah
501: where pah.auction_header_id = l_auction_header_id;
502:
503: select pon_auction_pkg.get_message_suffix(doc.internal_name)
504: into l_message_suffix
505: from pon_auction_headers_all pah,
506: pon_auc_doctypes doc
507: where pah.auction_header_id = l_auction_header_id
655: into l_auction_header_id
656: from pon_auc_attributes_interface pai
657: where pai.batch_id = p_batch_id;
658:
659: select pon_auction_pkg.get_message_suffix(doc.internal_name)
660: into l_message_suffix
661: from pon_auction_headers_all pah,
662: pon_auc_doctypes doc
663: where pah.auction_header_id = l_auction_header_id
819: (
820: selected_batch_id,
821: selected_interface_line_id,
822: 'PON_AUC_ATTRIBUTES_INTERFACE',
823: decode(l_group_pref_name,'LINE_ATTR_DEFAULT_GROUP',pon_auction_pkg.getMessage('PON_AUCTS_BID_RESPONSE',l_message_suffix),pon_auction_pkg.getMessage('PON_AUCTS_TYPE')),
824: 'PON_CAT_INVALID_VALUE',
825: selected_response_type_name
826: )
827:
950: (
951: selected_batch_id,
952: selected_interface_line_id,
953: 'PON_AUC_ATTRIBUTES_INTERFACE',
954: pon_auction_pkg.getMessage('PON_AUCTS_ATTR_TARGET',l_message_suffix),
955: decode(l_group_pref_name, 'LINE_ATTR_DEFAULT_GROUP',
956: 'PON_AUCTS_ATTR_DISPLAY_TARGET', 'PON_AUCTS_REQ_DISPLAY_TARGET'),
957: selected_value
958: )
1358: INTO l_auction_header_id
1359: FROM pon_auc_price_differ_int papd
1360: WHERE papd.batch_id = p_batch_id;
1361:
1362: SELECT pon_auction_pkg.get_message_suffix(doc.internal_name)
1363: INTO l_message_suffix
1364: FROM pon_auction_headers_all pah,pon_auc_doctypes doc
1365: WHERE pah.auction_header_id = l_auction_header_id
1366: AND pah.doctype_id = doc.doctype_id;
1848: into l_hdr_attr_enable_weights
1849: from pon_auction_headers_all pah
1850: where pah.auction_header_id = l_auction_header_id;
1851:
1852: select pon_auction_pkg.get_message_suffix(doc.internal_name)
1853: into l_message_suffix
1854: from pon_auction_headers_all pah,
1855: pon_auc_doctypes doc
1856: where pah.auction_header_id = l_auction_header_id
2000: into l_auction_header_id
2001: from pon_auc_attributes_interface pai
2002: where pai.batch_id = p_batch_id;
2003:
2004: select pon_auction_pkg.get_message_suffix(doc.internal_name)
2005: into l_message_suffix
2006: from pon_auction_headers_all pah,
2007: pon_auc_doctypes doc
2008: where pah.auction_header_id = l_auction_header_id
2166: (
2167: selected_batch_id,
2168: selected_interface_line_id,
2169: 'PON_AUC_ATTRIBUTES_INTERFACE',
2170: decode(l_group_pref_name,'LINE_ATTR_DEFAULT_GROUP',pon_auction_pkg.getMessage('PON_AUCTS_BID_RESPONSE',l_message_suffix),pon_auction_pkg.getMessage('PON_AUCTS_TYPE')),
2171: 'PON_CAT_INVALID_VALUE',
2172: selected_response_type_name
2173: )
2174:
2302: (
2303: selected_batch_id,
2304: selected_interface_line_id,
2305: 'PON_AUC_ATTRIBUTES_INTERFACE',
2306: pon_auction_pkg.getMessage('PON_AUCTS_ATTR_TARGET',l_message_suffix),
2307: decode(l_group_pref_name, 'LINE_ATTR_DEFAULT_GROUP',
2308: 'PON_AUCTS_ATTR_DISPLAY_TARGET', 'PON_AUCTS_REQ_DISPLAY_TARGET'),
2309: selected_value
2310: )
2634: IF(p_in_rec.l_RESPONSE_TYPE = 'OPTIONAL')THEN
2635: IF(p_in_rec.l_SCORING_METHOD ='AUTOMATIC')THEN
2636: insert_error_interface
2637: (
2638: p_in_rec.l_BATCH_ID,p_in_rec.l_INTERFACE_LINE_ID,l_TABLE_NAME,pon_auction_pkg.getMessage('PON_AUCTS_TYPE'),'PON_REQUIREMENT_ERR_15',p_in_rec.l_RESPONSE_TYPE
2639: );
2640: x_return_status := 'N';
2641: END IF;
2642: END IF;
2644: IF(p_in_rec.l_SCORING_METHOD IS NULL)THEN
2645: IF(p_in_rec.l_WEIGHT IS NOT NULL) THEN
2646: insert_error_interface
2647: (
2648: p_in_rec.l_BATCH_ID,p_in_rec.l_INTERFACE_LINE_ID,l_TABLE_NAME,pon_auction_pkg.getMessage('PON_AUCTS_TYPE'),'PON_REQUIREMENT_ERR_2',p_in_rec.l_SCORING_METHOD
2649: );
2650: x_return_status := 'N';
2651: END IF;
2652: IF(p_in_rec.l_KNOCKOUT_SCORE IS NOT NULL) THEN
2651: END IF;
2652: IF(p_in_rec.l_KNOCKOUT_SCORE IS NOT NULL) THEN
2653: insert_error_interface
2654: (
2655: p_in_rec.l_BATCH_ID,p_in_rec.l_INTERFACE_LINE_ID,l_TABLE_NAME,pon_auction_pkg.getMessage('PON_AUCTS_TYPE'),'PON_REQUIREMENT_ERR_3',p_in_rec.l_SCORING_METHOD
2656: );
2657: x_return_status := 'N';
2658: END IF;
2659: IF(p_in_rec.l_ATTR_MAX_SCORE IS NOT NULL) THEN
2658: END IF;
2659: IF(p_in_rec.l_ATTR_MAX_SCORE IS NOT NULL) THEN
2660: insert_error_interface
2661: (
2662: p_in_rec.l_BATCH_ID,p_in_rec.l_INTERFACE_LINE_ID,l_TABLE_NAME,pon_auction_pkg.getMessage('PON_AUCTS_TYPE'),'PON_REQUIREMENT_ERR_4',p_in_rec.l_SCORING_METHOD
2663: );
2664: x_return_status := 'N';
2665: END IF;
2666: END IF;
2668: IF(p_in_rec.l_RESPONSE_TYPE = 'INTERNAL') THEN
2669: IF(p_in_rec.l_SCORING_METHOD ='AUTOMATIC') THEN
2670: insert_error_interface
2671: (
2672: p_in_rec.l_BATCH_ID,p_in_rec.l_INTERFACE_LINE_ID,l_TABLE_NAME,pon_auction_pkg.getMessage('PON_AUCTS_TYPE'),'PON_REQUIREMENT_ERR_5',p_in_rec.l_RESPONSE_TYPE
2673: );
2674: x_return_status := 'N';
2675: END IF;
2676: END IF;
2678: IF(p_in_rec.l_RESPONSE_TYPE = 'DISPLAY_ONLY' OR p_in_rec.l_RESPONSE_TYPE = 'INTERNAL') THEN
2679: IF(p_in_rec.l_SCORING_TYPE='LOV' OR p_in_rec.l_SCORING_TYPE='RANGE') THEN
2680: insert_error_interface
2681: (
2682: p_in_rec.l_BATCH_ID,p_in_rec.l_INTERFACE_LINE_ID,l_TABLE_NAME,pon_auction_pkg.getMessage('PON_AUCTS_TYPE'),'PON_REQUIREMENT_ERR_6',p_in_rec.l_RESPONSE_TYPE
2683: );
2684: x_return_status := 'N';
2685: END IF;
2686: END IF;
2704: /* Automatic scoring will only have for Required type */
2705: IF(p_in_rec.l_RESPONSE_TYPE <> 'REQUIRED' AND p_in_rec.l_SCORING_METHOD='AUTOMATIC') THEN
2706: insert_error_interface
2707: (
2708: p_in_rec.l_BATCH_ID,p_in_rec.l_INTERFACE_LINE_ID,l_TABLE_NAME,pon_auction_pkg.getMessage('PON_AUCTS_TYPE'),'PON_REQUIREMENT_ERR_9',p_in_rec.l_RESPONSE_TYPE
2709: );
2710: x_return_status := 'N';
2711: END IF;
2712: /* Manual scoring method cannot have scoring type LOV/RANGE and ATTR_MAX_SCORE is must*/
2713: IF(p_in_rec.l_SCORING_METHOD ='MANUAL') THEN
2714: IF(p_in_rec.l_SCORING_TYPE='LOV' OR p_in_rec.l_SCORING_TYPE='RANGE') THEN
2715: insert_error_interface
2716: (
2717: p_in_rec.l_BATCH_ID,p_in_rec.l_INTERFACE_LINE_ID,l_TABLE_NAME,pon_auction_pkg.getMessage('PON_AUCTS_TYPE'),'PON_REQUIREMENT_ERR_10',p_in_rec.l_SCORING_METHOD
2718: );
2719: x_return_status := 'N';
2720: END IF;
2721: IF(p_in_rec.l_ATTR_MAX_SCORE = NULL OR p_in_rec.l_ATTR_MAX_SCORE = 0) THEN