APPS.PON_LARGE_AUCTION_UTIL_PKG dependencies on FND_API

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

500: -- p_request_id IN Request id to cancel
501: --
502: -- RETURN: VARCHAR2 null/error msg if successful/unsuccessful
503: --
504: -- COMMENT: Cancels concurrent request p_request_id using FND API:
505: -- FND_CONCURRENT.CANCEL_REQUEST
506: -- ======================================================================
507: FUNCTION cancel_concurrent_request
508: (

Line 599: x_result := FND_API.g_ret_sts_success;

595: l_last_update_date DATE;
596:
597: BEGIN
598:
599: x_result := FND_API.g_ret_sts_success;
600:
601: IF (g_debug_mode = 'Y'
602: AND FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
603: FND_LOG.string(log_level => FND_LOG.level_statement,

Line 626: X_RESULT := FND_API.G_RET_STS_ERROR;

622: AUCTION_HEADER_ID= p_auction_id;
623:
624: ELSE
625:
626: X_RESULT := FND_API.G_RET_STS_ERROR;
627: X_ERROR_CODE := 'PON_AUCTION_UPDATED_ALREADY';
628: X_ERROR_MESG := 'Auction ' ||p_auction_id ||' has been updated in another session ' ;
629:
630: RETURN;

Line 660: X_RESULT := FND_API.G_RET_STS_ERROR;

656: || ':::' || p_request_date || ':::' || p_import_file || ':::'
657: || p_last_update_date);
658: END IF;
659:
660: X_RESULT := FND_API.G_RET_STS_ERROR;
661: X_ERROR_CODE := 'UPDATE_AUCTION_IMPORT_COLS_FAILED_COMPLETELY - ' || SQLCODE;
662: X_ERROR_MESG := 'Unable to do anything with this auction '
663: || p_auction_id || ' '
664: || SUBSTR(SQLERRM, 1, 100);

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

966: x_return_status OUT NOCOPY VARCHAR2,
967: x_msg_data OUT NOCOPY VARCHAR2
968: ) IS
969: l_conterms_exist_flag varchar2(1) := 'N';
970: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
971:
972: PON_FAIL_CALL_DEL_DOC EXCEPTION;
973: BEGIN
974: -- Initialize API return status to SUCCESS

Line 975: x_return_status := FND_API.G_RET_STS_SUCCESS;

971:
972: PON_FAIL_CALL_DEL_DOC EXCEPTION;
973: BEGIN
974: -- Initialize API return status to SUCCESS
975: x_return_status := FND_API.G_RET_STS_SUCCESS;
976:
977: -- Delete related records from tables for this bid
978: pon_large_auction_util_pkg.delete_bid( p_auc_header_id, p_bid_number);
979:

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

982: select conterms_exist_flag into l_conterms_exist_flag
983: from pon_auction_headers_all
984: where auction_header_id = p_auc_header_id;
985:
986: if ( ( PON_CONTERMS_UTL_GRP.is_contracts_installed()= FND_API.G_TRUE ) and
987: l_conterms_exist_flag = 'Y' ) then
988:
989: OKC_TERMS_UTIL_GRP.delete_doc (
990: p_api_version => 1.0,

Line 991: p_init_msg_list => FND_API.G_FALSE,

987: l_conterms_exist_flag = 'Y' ) then
988:
989: OKC_TERMS_UTIL_GRP.delete_doc (
990: p_api_version => 1.0,
991: p_init_msg_list => FND_API.G_FALSE,
992: p_commit => FND_API.G_FALSE,
993: x_return_status => l_return_status,
994: x_msg_count => x_msg_count,
995: x_msg_data => x_msg_data,

Line 992: p_commit => FND_API.G_FALSE,

988:
989: OKC_TERMS_UTIL_GRP.delete_doc (
990: p_api_version => 1.0,
991: p_init_msg_list => FND_API.G_FALSE,
992: p_commit => FND_API.G_FALSE,
993: x_return_status => l_return_status,
994: x_msg_count => x_msg_count,
995: x_msg_data => x_msg_data,
996: p_validate_commit => null,

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

997: p_validation_string => null,
998: p_doc_type => P_doc_type,
999: p_doc_id => p_bid_number );
1000:
1001: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1002: raise PON_FAIL_CALL_DEL_DOC;
1003: end if;
1004: end if;
1005:

Line 1018: x_return_status := FND_API.G_RET_STS_ERROR ;

1014: delete from pon_bid_headers where bid_number = p_bid_number;
1015:
1016: EXCEPTION
1017: WHEN PON_FAIL_CALL_DEL_DOC THEN
1018: x_return_status := FND_API.G_RET_STS_ERROR ;
1019:
1020: if FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL then
1021: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'PON.PLSQL.PON_LARGE_AUCTION_UTIL_PKG.delete_bid_from_header', 'PON_FAIL_CALL_DEL_DOC');
1022: end if;

Line 1025: x_return_status := FND_API.G_RET_STS_ERROR;

1021: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'PON.PLSQL.PON_LARGE_AUCTION_UTIL_PKG.delete_bid_from_header', 'PON_FAIL_CALL_DEL_DOC');
1022: end if;
1023: WHEN OTHERS THEN
1024:
1025: x_return_status := FND_API.G_RET_STS_ERROR;
1026:
1027: if FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL then
1028: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'PON.PLSQL.PON_LARGE_AUCTION_UTIL_PKG.delete_bid_from_header', 'Others:' || substr(1, 255, sqlerrm) );
1029: end if;