DBA Data[Home] [Help]

APPS.PON_AUCTION_INTERFACE_PKG dependencies on PON_AUCTION_INTERFACE_PKG

Line 1: PACKAGE BODY pon_auction_interface_pkg AS

1: PACKAGE BODY pon_auction_interface_pkg AS
2: /* $Header: PONAUCIB.pls 120.55.12020000.5 2013/02/09 06:02:15 hvutukur ship $ */
3: g_pkg_name CONSTANT VARCHAR2(30) := 'PON_AUCTION_INTERFACE_PKG';
4: g_progress_payment_type pon_auction_headers_all.progress_payment_type%TYPE := 'NONE';
5: -- global variables added for header price break default project

Line 3: g_pkg_name CONSTANT VARCHAR2(30) := 'PON_AUCTION_INTERFACE_PKG';

1: PACKAGE BODY pon_auction_interface_pkg AS
2: /* $Header: PONAUCIB.pls 120.55.12020000.5 2013/02/09 06:02:15 hvutukur ship $ */
3: g_pkg_name CONSTANT VARCHAR2(30) := 'PON_AUCTION_INTERFACE_PKG';
4: g_progress_payment_type pon_auction_headers_all.progress_payment_type%TYPE := 'NONE';
5: -- global variables added for header price break default project
6: g_price_break_type pon_auction_item_prices_all.price_break_type%type;
7: g_price_break_neg_flag pon_auction_item_prices_all.price_break_neg_flag%type;

Line 20: fnd_log.string(fnd_log.level_statement,'pon.plsql.pon_auction_interface_pkg.'||p_base, p_message);

16: p_message VARCHAR2)
17: IS
18: BEGIN
19: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
20: fnd_log.string(fnd_log.level_statement,'pon.plsql.pon_auction_interface_pkg.'||p_base, p_message);
21: END IF;
22: END;
23: /*
24: ========================================================================

Line 168: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');

164: WHEN no_data_found THEN
165: P_RESULT := error;
166: P_ERROR_CODE := 'CREATE_DRAFT:MULTI_ORG_QUERY';
167: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
168: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
169: fnd_message.set_token('PROCEDURE','Create_Draft_Negotiation');
170: fnd_message.set_token('ERROR','Multi-Org Query Failed [' || SQLERRM || ']');
171: fnd_message.retrieve(P_ERROR_MESSAGE);
172: logme(l_log_module, p_error_code ||' - '||p_error_message);

Line 190: --fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');

186: WHEN no_data_found THEN
187: P_RESULT := error;
188: P_ERROR_CODE := 'ADD_TO_DRAFT:DOC_QUERY';
189: --fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
190: --fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
191: --fnd_message.retrieve(P_ERROR_MESSAGE);
192: logme(l_log_module, p_error_code ||' - '||p_error_message);
193: RETURN;
194: END;

Line 411: logme('pon.plsql.pon_auction_interface_pkg.Create_Draft_Negotiation',

407: END;
408: END IF;
409: -- R12.1 Price tiers Project
410: -- Get Default price tiers indicator
411: logme('pon.plsql.pon_auction_interface_pkg.Create_Draft_Negotiation',
412: 'Calling the PON_AUCTION_PKG.GET_DEFAULT_TIERS_INDICATOR API to get the' ||
413: ' default price tiers indicator value.');
414: v_debug_status := 'PRICE_TIERS_INDICATOR';
415: PON_AUCTION_PKG.GET_DEFAULT_TIERS_INDICATOR( p_contract_type => P_CONTRACT_TYPE,

Line 426: logme('pon.plsql.pon_auction_interface_pkg.Create_Draft_Negotiation',

422: l_uda_template_id := NULL;
423: l_uda_template_date := NULL;
424: l_sol_type := NULL;
425: IF PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(p_doc_type_id => v_doctype_id) = 1 THEN
426: logme('pon.plsql.pon_auction_interface_pkg.Create_Draft_Negotiation',
427: 'Retrieve Uda Template Id for Header');
428: l_uda_template_id := po_uda_data_util.get_template_id ( 'SOURCING',
429: 'SOLICITATION', NULL, 'HEADER', sysdate, l_return_status, l_err_msg);
430: logme('pon.plsql.pon_auction_interface_pkg.Create_Draft_Negotiation',

Line 430: logme('pon.plsql.pon_auction_interface_pkg.Create_Draft_Negotiation',

426: logme('pon.plsql.pon_auction_interface_pkg.Create_Draft_Negotiation',
427: 'Retrieve Uda Template Id for Header');
428: l_uda_template_id := po_uda_data_util.get_template_id ( 'SOURCING',
429: 'SOLICITATION', NULL, 'HEADER', sysdate, l_return_status, l_err_msg);
430: logme('pon.plsql.pon_auction_interface_pkg.Create_Draft_Negotiation',
431: 'Return from po_uda_data_util.get_template_id '||l_return_status);
432: IF ( l_return_status = 'E' ) THEN
433: P_ERROR_CODE := 'CREATE_DRAFT:GET_HEADER_UDA_TEMPLATE_ID';
434: P_RESULT := l_return_status;

Line 439: logme('pon.plsql.pon_auction_interface_pkg.Create_Draft_Negotiation',

435: P_ERROR_MESSAGE := l_err_msg;
436: logme(l_log_module, p_error_code ||' - '||p_error_message);
437: RETURN;
438: END IF;
439: logme('pon.plsql.pon_auction_interface_pkg.Create_Draft_Negotiation',
440: 'Got uda_template_id for Header'||l_uda_template_id);
441: l_uda_template_date := sysdate;
442: l_sol_type := 'RFQ';
443: END IF;

Line 463: logme('pon.plsql.PON_auction_interface_pkg.Create_Draft_Negotiation',

459: WHEN No_Data_Found THEN
460: l_standard_form :=NULL;
461: l_document_format:=NULL;
462: END;
463: logme('pon.plsql.PON_auction_interface_pkg.Create_Draft_Negotiation',
464: 'Inserting into pon_auction_headers_all');
465: v_debug_status := 'INSERT-PAH';
466: INSERT
467: INTO PON_AUCTION_HEADERS_ALL

Line 640: 'pon.plsql.PON_auction_interface_pkg.Create_Draft_Negotiation',

636: INTO P_DOCUMENT_NUMBER;
637:
638: logme
639: (
640: 'pon.plsql.PON_auction_interface_pkg.Create_Draft_Negotiation',
641: 'Inserted in PAH : auction_header_id : '||P_DOCUMENT_NUMBER
642: )
643: ;
644: IF PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL ( p_doc_type_id => v_doctype_id)

Line 646: logme('pon.plsql.pon_auction_interface_pkg.Create_Draft_Negotiation',

642: )
643: ;
644: IF PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL ( p_doc_type_id => v_doctype_id)
645: = 1 THEN
646: logme('pon.plsql.pon_auction_interface_pkg.Create_Draft_Negotiation',
647: 'Default Document Number') ;
648: PO_DOC_NUMBERING_PKG.DEFAULT_DOC_NUMBER_UDA
649: (
650: p_doc_header_id => p_document_number,

Line 662: 'pon.plsql.pon_auction_interface_pkg.Create_Draft_Negotiation', 'Defaulted Document Number '||

658: )
659: ;
660: logme
661: (
662: 'pon.plsql.pon_auction_interface_pkg.Create_Draft_Negotiation', 'Defaulted Document Number '||
663: clm_doc_number||' status '||l_return_status
664: )
665: ;
666: IF

Line 693: logme('pon.plsql.pon_auction_interface_pkg.Create_Draft_Negotiation', 'Return from Create_Draft_Negotiation');

689: P_DOCUMENT_URL := '&' || 'auctionID=' || P_DOCUMENT_NUMBER;
690: P_RESULT := success;
691: P_ERROR_CODE := NULL;
692: P_ERROR_MESSAGE := NULL;
693: logme('pon.plsql.pon_auction_interface_pkg.Create_Draft_Negotiation', 'Return from Create_Draft_Negotiation');
694: EXCEPTION
695: WHEN OTHERS THEN
696: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
697: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');

Line 697: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');

693: logme('pon.plsql.pon_auction_interface_pkg.Create_Draft_Negotiation', 'Return from Create_Draft_Negotiation');
694: EXCEPTION
695: WHEN OTHERS THEN
696: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
697: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
698: fnd_message.set_token('PROCEDURE','Create_Draft_Negotiation');
699: fnd_message.set_token('ERROR',v_debug_status || ' [' || SQLERRM || ']');
700: APP_EXCEPTION.RAISE_EXCEPTION;
701: END;

Line 1095: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');

1091: WHEN no_data_found THEN
1092: P_RESULT := error;
1093: P_ERROR_CODE := 'ADD_NEG_LINE:MULTI_ORG_QUERY';
1094: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1095: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1096: fnd_message.set_token('PROCEDURE','Add_Negotiation_Line');
1097: fnd_message.set_token('ERROR','Multi-Org Query Failed [' || SQLERRM || ']');
1098: fnd_message.retrieve(P_ERROR_MESSAGE);
1099: logme(l_log_module, p_error_code ||' - '||p_error_message);

Line 1111: logme( 'pon.plsql.pon_auction_interface_pkg.add_negotiation_line',

1107: RETURN;
1108: END IF;
1109: -- Does P_ORG_ID match that of the auction header?
1110: v_debug_status := 'ORG_ID_MATCH';
1111: logme( 'pon.plsql.pon_auction_interface_pkg.add_negotiation_line',
1112: 'Get Org_Id ');
1113: BEGIN
1114: SELECT org_id,
1115: doctype_id, -- Added doctype_id

Line 1132: logme('pon.plsql.pon_auction_interface_pkg.add_negotiation_line', 'Got Org_Id ');

1128: logme(l_log_module, p_error_code ||' - '||p_error_message);
1129: RETURN;
1130: END;
1131: l_is_federal := PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(p_doc_type_id => v_doctype_id);
1132: logme('pon.plsql.pon_auction_interface_pkg.add_negotiation_line', 'Got Org_Id ');
1133: -- get category id for VENDOR attachments
1134: logme(l_log_module, 'v_CONTRACT_TYPE '||V_CONTRACT_TYPE);
1135: logme(l_log_module, 'l_is_federal '||l_is_federal);
1136: v_debug_status := 'ATTACHMENT_CATEGORY_ID';

Line 1238: logme('pon.plsql.pon_auction_interface_pkg.add_negotiation_line',

1234: so need to place a nvl for info flag
1235: 3. Skip Options from Grouping
1236: 4. Skip Slins from grouping. Only Clins are to be merged
1237: ****/
1238: logme('pon.plsql.pon_auction_interface_pkg.add_negotiation_line',
1239: ' P_GROUPING_TYPE '|| p_grouping_type|| ' service based line '|| v_service_based_line ||
1240: ' p_group_line_id '||p_group_line_id|| ' option indicator '||p_clm_option_indicator);
1241:
1242:

Line 1248: logme('pon.plsql.pon_auction_interface_pkg.add_negotiation_line', v_debug_status);

1244: AND NVL(P_GROUP_LINE_ID, -1) = -1) AND (NVL(p_clm_option_indicator, 'B') <> 'O') THEN
1245:
1246:
1247: v_debug_status := 'GROUPING_QUERY';
1248: logme('pon.plsql.pon_auction_interface_pkg.add_negotiation_line', v_debug_status);
1249:
1250: IF (P_LINE_NUMBER IS NOT NULL AND P_LINE_NUMBER >0 ) THEN
1251: logme(l_log_module, 'Line exist check ');
1252: BEGIN

Line 1262: logme('pon.plsql.pon_auction_interface_pkg.add_negotiation_line', 'l_line_exist '||l_line_exist);

1258: EXCEPTION
1259: WHEN OTHERS THEN
1260: P_LINE_NUMBER := NULL;
1261: END;
1262: logme('pon.plsql.pon_auction_interface_pkg.add_negotiation_line', 'l_line_exist '||l_line_exist);
1263: END IF;
1264:
1265: IF l_line_exist = 'Y' THEN
1266: logme(l_log_module, 'Line valid test ');

Line 1338: logme('pon.plsql.pon_auction_interface_pkg.add_negotiation_line', 'l_line_valid '||l_line_valid);

1334: NULL;
1335: END;
1336: END IF; --V_CONTRACT_TYPE =
1337: END IF; -- l_line_exist =
1338: logme('pon.plsql.pon_auction_interface_pkg.add_negotiation_line', 'l_line_valid '||l_line_valid);
1339:
1340: IF l_line_valid = 'N' THEN
1341: p_line_number := NULL;
1342: END IF;

Line 1343: logme('pon.plsql.pon_auction_interface_pkg.add_negotiation_line', 'p_line_number '||p_line_number);

1339:
1340: IF l_line_valid = 'N' THEN
1341: p_line_number := NULL;
1342: END IF;
1343: logme('pon.plsql.pon_auction_interface_pkg.add_negotiation_line', 'p_line_number '||p_line_number);
1344:
1345: IF (P_LINE_NUMBER IS NULL OR P_LINE_NUMBER = 0) THEN
1346: logme(l_log_module, 'Grouping Line search select ');
1347: IF (V_CONTRACT_TYPE = 'STANDARD') THEN

Line 1403: logme('pon.plsql.pon_auction_interface_pkg.add_negotiation_line',

1399: -- Added the below condition so that only Autocreated Requisition Lines can be grouped
1400: AND paip.line_origination_code = 'REQUISITION';
1401: END IF; --V_CONTRACT_TYPE =
1402: END IF; -- P_LINE_NUMBER IS NULL THEN
1403: logme('pon.plsql.pon_auction_interface_pkg.add_negotiation_line',
1404: 'Grouping query result: p_line_number = '||p_line_number);
1405: ELSE
1406: P_LINE_NUMBER := NULL;
1407: END IF; -- (P_GROUPING_TYPE = 'DEFAULT' AND v_service_based_line <> 'Y' AND

Line 1806: 'pon.plsql.pon_auction_interface_pkg.Add_Negotiation_Line', 'Copy Line UDAs '||

1802: THEN
1803: v_debug_status := 'COPY_LINE_UDAS';
1804: logme
1805: (
1806: 'pon.plsql.pon_auction_interface_pkg.Add_Negotiation_Line', 'Copy Line UDAs '||
1807: p_document_number||' '||p_line_number||' '||p_requisition_line_id||' '||
1808: p_uda_template_id||' '||p_req_line_temp_id
1809: )
1810: ;

Line 1829: logme('pon.plsql.pon_auction_interface_pkg.Add_Negotiation_Line',

1825: X_MSG_COUNT=>v_msg_count,
1826: X_MSG_DATA=>P_ERROR_MESSAGE
1827: )
1828: ;
1829: logme('pon.plsql.pon_auction_interface_pkg.Add_Negotiation_Line',
1830: 'Copy Line UDAs Return '||v_return_status||' '||p_error_message) ;
1831: IF
1832: (
1833: v_return_status <> FND_API.G_RET_STS_SUCCESS

Line 1852: logme('pon.plsql.pon_auction_interface_pkg.Add_Negotiation_Line',

1848: v_order_type_lookup_code <> 'QUANTITY'
1849: )
1850: THEN
1851: BEGIN
1852: logme('pon.plsql.pon_auction_interface_pkg.Add_Negotiation_Line',
1853: 'For Order type lookup code '||v_order_type_lookup_code);
1854: IF v_was_grouped = 'Y' THEN
1855: --When the lines are grouped delete
1856: -- the complex pricing attributes and

Line 1858: logme('pon.plsql.pon_auction_interface_pkg.Add_Negotiation_Line',

1854: IF v_was_grouped = 'Y' THEN
1855: --When the lines are grouped delete
1856: -- the complex pricing attributes and
1857: -- add amount of grouped lines.
1858: logme('pon.plsql.pon_auction_interface_pkg.Add_Negotiation_Line',
1859: 'When items were grouped');
1860: SELECT ATTRIBUTE_GROUP_ID INTO l_comp_pricing_grp_id
1861: FROM po_uda_ag_template_usages
1862: WHERE template_id = P_REQ_LINE_TEMP_ID

Line 1875: logme('pon.plsql.pon_auction_interface_pkg.Add_Negotiation_Line',

1871: p_attr_grp_id => l_comp_pricing_grp_id,
1872: p_attr_int_name => 'TOTAL_AMOUNT') -- bug 13571062
1873: WHERE auction_header_id = P_DOCUMENT_NUMBER
1874: AND line_number = P_LINE_NUMBER;
1875: logme('pon.plsql.pon_auction_interface_pkg.Add_Negotiation_Line',
1876: 'add total amount');
1877:
1878: delete pon_auction_item_prices_ext_b
1879: where auction_header_id = p_document_number

Line 1886: logme('pon.plsql.pon_auction_interface_pkg.Add_Negotiation_Line',

1882: (select attribute_group_id from po_uda_ag_template_usages
1883: where template_id=p_uda_template_id
1884: and nvl(attribute1,'X')=nvl(p_clm_idc_type,'X')
1885: and nvl(attribute2,'X')=nvl(p_clm_contract_type,'X'));
1886: logme('pon.plsql.pon_auction_interface_pkg.Add_Negotiation_Line',
1887: 'Delete complex pricing UDA ');
1888:
1889: ELSE
1890: SELECT ATTRIBUTE_GROUP_ID INTO l_comp_pricing_grp_id

Line 1906: logme('pon.plsql.pon_auction_interface_pkg.Add_Negotiation_Line',

1902: p_attr_grp_id => l_comp_pricing_grp_id,
1903: p_attr_int_name => 'TOTAL_AMOUNT') -- bug 13571062
1904: WHERE auction_header_id = P_DOCUMENT_NUMBER
1905: AND line_number = P_LINE_NUMBER;
1906: logme('pon.plsql.pon_auction_interface_pkg.Add_Negotiation_Line',
1907: 'set amount from complex pricing UDA ');
1908: END IF;
1909: EXCEPTION
1910: WHEN OTHERS THEN

Line 1911: logme('pon.plsql.pon_auction_interface_pkg.Add_Negotiation_Line',

1907: 'set amount from complex pricing UDA ');
1908: END IF;
1909: EXCEPTION
1910: WHEN OTHERS THEN
1911: logme('pon.plsql.pon_auction_interface_pkg.Add_Negotiation_Line',
1912: 'Exception in updating complex pricing extended price ');
1913: END;
1914: ELSE -- quantity based lines
1915: UPDATE pon_auction_item_prices_all

Line 1929: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');

1925: P_ERROR_MESSAGE := NULL;
1926: EXCEPTION
1927: WHEN OTHERS THEN
1928: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1929: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1930: fnd_message.set_token('PROCEDURE','Add_Negotiation_Line');
1931: fnd_message.set_token('ERROR',v_debug_status || ' [' || SQLERRM || ']');
1932: APP_EXCEPTION.RAISE_EXCEPTION;
1933: END;

Line 2210: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');

2206: WHEN OTHERS THEN
2207: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR ;
2208: X_MSG_COUNT := 1;
2209: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
2210: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
2211: fnd_message.set_token('PROCEDURE','Add_Catalog_Descriptors');
2212: fnd_message.set_token('ERROR',v_debug_status || ' [' || SQLERRM || ']');
2213: fnd_message.retrieve(X_MSG_DATA);
2214: RETURN;

Line 2314: 'PACKAGE','pon_auction_interface_pkg'

2310: )
2311: ;
2312: fnd_message.set_token
2313: (
2314: 'PACKAGE','pon_auction_interface_pkg'
2315: )
2316: ;
2317: fnd_message.set_token
2318: (

Line 2377: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');

2373: WHEN OTHERS THEN
2374: P_RESULT := error;
2375: P_ERROR_CODE := 'GET_NEG_OWNER';
2376: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
2377: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
2378: fnd_message.set_token('PROCEDURE','Get_Negotiation_Owner');
2379: fnd_message.set_token('ERROR','Document ' || P_DOCUMENT_NUMBER || ' [' || SQLERRM || ']');
2380: fnd_message.retrieve(P_ERROR_MESSAGE);
2381: END;

Line 2444: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');

2440: WHEN OTHERS THEN
2441: P_RESULT := error;
2442: P_ERROR_CODE := 'GET_NEG_OWNER';
2443: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
2444: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
2445: fnd_message.set_token('PROCEDURE','Get_PO_Negotiation_Link');
2446: fnd_message.set_token('ERROR','PO Header ' || P_PO_HEADER_ID || ' [' || SQLERRM || ']');
2447: fnd_message.retrieve(P_ERROR_MESSAGE);
2448: END;

Line 2590: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');

2586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2588: x_msg_count := 1;
2589: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
2590: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
2591: fnd_message.set_token('PROCEDURE','add_negotiation_invitees');
2592: fnd_message.set_token('ERROR', ' [' || SQLERRM || ']');
2593: fnd_message.retrieve(x_msg_data);
2594: RETURN;

Line 2599: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');

2595: WHEN OTHERS THEN
2596: x_return_status := FND_API.G_RET_STS_ERROR ;
2597: x_msg_count := 1;
2598: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
2599: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
2600: fnd_message.set_token('PROCEDURE','add_negotiation_invitees');
2601: fnd_message.set_token('ERROR', ' [' || SQLERRM || ']');
2602: --APP_EXCEPTION.RAISE_EXCEPTION;
2603: fnd_message.retrieve(x_msg_data);

Line 2676: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');

2672: WHEN OTHERS THEN
2673: x_return_status := FND_API.G_RET_STS_ERROR ;
2674: x_msg_count := 1;
2675: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
2676: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
2677: fnd_message.set_token('PROCEDURE','maintain_clm_relations');
2678: fnd_message.set_token('ERROR', ' [' || SQLERRM || ']');
2679: --APP_EXCEPTION.RAISE_EXCEPTION;
2680: fnd_message.retrieve(x_msg_data);

Line 2741: END PON_AUCTION_INTERFACE_PKG;

2737: x_msg_data := NULL;
2738: RETURN;
2739: END maintain_clm_relations;
2740: --
2741: END PON_AUCTION_INTERFACE_PKG;