APPS.PON_LARGE_AUCTION_UTIL_PKG dependencies on FND_API

Line 518: -- COMMENT: Cancels concurrent request p_request_id using FND API:

514: -- p_request_id IN Request id to cancel
515: --
516: -- RETURN: VARCHAR2 null/error msg if successful/unsuccessful
517: --
518: -- COMMENT: Cancels concurrent request p_request_id using FND API:
519: -- FND_CONCURRENT.CANCEL_REQUEST
520: -- ======================================================================
521: FUNCTION cancel_concurrent_request
522: (

Line 613: x_result := FND_API.g_ret_sts_success;

609: l_last_update_date DATE;
610:
611: BEGIN
612:
613: x_result := FND_API.g_ret_sts_success;
614:
615: IF (g_debug_mode = 'Y'
616: AND FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
617: FND_LOG.string(log_level => FND_LOG.level_statement,

Line 640: X_RESULT := FND_API.G_RET_STS_ERROR;

636: AUCTION_HEADER_ID= p_auction_id;
637:
638: ELSE
639:
640: X_RESULT := FND_API.G_RET_STS_ERROR;
641: X_ERROR_CODE := 'PON_AUCTION_UPDATED_ALREADY';
642: X_ERROR_MESG := 'Auction ' ||p_auction_id ||' has been updated in another session ' ;
643:
644: RETURN;

Line 674: X_RESULT := FND_API.G_RET_STS_ERROR;

670: || ':::' || p_request_date || ':::' || p_import_file || ':::'
671: || p_last_update_date);
672: END IF;
673:
674: X_RESULT := FND_API.G_RET_STS_ERROR;
675: X_ERROR_CODE := 'UPDATE_AUCTION_IMPORT_COLS_FAILED_COMPLETELY - ' || SQLCODE;
676: X_ERROR_MESG := 'Unable to do anything with this auction '
677: || p_auction_id || ' '
678: || SUBSTR(SQLERRM, 1, 100);

Line 984: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;

980: x_return_status OUT NOCOPY VARCHAR2,
981: x_msg_data OUT NOCOPY VARCHAR2
982: ) IS
983: l_conterms_exist_flag varchar2(1) := 'N';
984: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
985:
986: PON_FAIL_CALL_DEL_DOC EXCEPTION;
987: BEGIN
988: -- Initialize API return status to SUCCESS

Line 989: x_return_status := FND_API.G_RET_STS_SUCCESS;

985:
986: PON_FAIL_CALL_DEL_DOC EXCEPTION;
987: BEGIN
988: -- Initialize API return status to SUCCESS
989: x_return_status := FND_API.G_RET_STS_SUCCESS;
990:
991: -- Delete related records from tables for this bid
992: pon_large_auction_util_pkg.delete_bid( p_auc_header_id, p_bid_number);
993:

Line 1000: if ( ( PON_CONTERMS_UTL_GRP.is_contracts_installed()= FND_API.G_TRUE ) and

996: select conterms_exist_flag into l_conterms_exist_flag
997: from pon_auction_headers_all
998: where auction_header_id = p_auc_header_id;
999:
1000: if ( ( PON_CONTERMS_UTL_GRP.is_contracts_installed()= FND_API.G_TRUE ) and
1001: l_conterms_exist_flag = 'Y' ) then
1002:
1003: OKC_TERMS_UTIL_GRP.delete_doc (
1004: p_api_version => 1.0,

Line 1005: p_init_msg_list => FND_API.G_FALSE,

1001: l_conterms_exist_flag = 'Y' ) then
1002:
1003: OKC_TERMS_UTIL_GRP.delete_doc (
1004: p_api_version => 1.0,
1005: p_init_msg_list => FND_API.G_FALSE,
1006: p_commit => FND_API.G_FALSE,
1007: x_return_status => l_return_status,
1008: x_msg_count => x_msg_count,
1009: x_msg_data => x_msg_data,

Line 1006: p_commit => FND_API.G_FALSE,

1002:
1003: OKC_TERMS_UTIL_GRP.delete_doc (
1004: p_api_version => 1.0,
1005: p_init_msg_list => FND_API.G_FALSE,
1006: p_commit => FND_API.G_FALSE,
1007: x_return_status => l_return_status,
1008: x_msg_count => x_msg_count,
1009: x_msg_data => x_msg_data,
1010: p_validate_commit => null,

Line 1015: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

1011: p_validation_string => null,
1012: p_doc_type => P_doc_type,
1013: p_doc_id => p_bid_number );
1014:
1015: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1016: raise PON_FAIL_CALL_DEL_DOC;
1017: end if;
1018: end if;
1019:

Line 1032: x_return_status := FND_API.G_RET_STS_ERROR ;

1028: delete from pon_bid_headers where bid_number = p_bid_number;
1029:
1030: EXCEPTION
1031: WHEN PON_FAIL_CALL_DEL_DOC THEN
1032: x_return_status := FND_API.G_RET_STS_ERROR ;
1033:
1034: if FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL then
1035: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'PON.PLSQL.PON_LARGE_AUCTION_UTIL_PKG.delete_bid_from_header', 'PON_FAIL_CALL_DEL_DOC');
1036: end if;

Line 1039: x_return_status := FND_API.G_RET_STS_ERROR;

1035: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'PON.PLSQL.PON_LARGE_AUCTION_UTIL_PKG.delete_bid_from_header', 'PON_FAIL_CALL_DEL_DOC');
1036: end if;
1037: WHEN OTHERS THEN
1038:
1039: x_return_status := FND_API.G_RET_STS_ERROR;
1040:
1041: if FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL then
1042: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'PON.PLSQL.PON_LARGE_AUCTION_UTIL_PKG.delete_bid_from_header', 'Others:' || substr(1, 255, sqlerrm) );
1043: end if;