DBA Data[Home] [Help]

APPS.CSI_INV_TXNSTUB_PKG dependencies on FND_API

Line 23: l_commit VARCHAR2(1) := FND_API.G_FALSE;

19:
20: IS
21: l_api_name VARCHAR2(100) := 'CSI_INV_TXNSTUB_PUB.EXECUTE_TRX_DPL';
22: l_api_version NUMBER := 1.0;
23: l_commit VARCHAR2(1) := FND_API.G_FALSE;
24: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
25: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
26: l_error_message VARCHAR2(4000);
27: l_error_code VARCHAR2(4000);

Line 24: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;

20: IS
21: l_api_name VARCHAR2(100) := 'CSI_INV_TXNSTUB_PUB.EXECUTE_TRX_DPL';
22: l_api_version NUMBER := 1.0;
23: l_commit VARCHAR2(1) := FND_API.G_FALSE;
24: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
25: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
26: l_error_message VARCHAR2(4000);
27: l_error_code VARCHAR2(4000);
28: l_return_status VARCHAR2(1);

Line 25: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

21: l_api_name VARCHAR2(100) := 'CSI_INV_TXNSTUB_PUB.EXECUTE_TRX_DPL';
22: l_api_version NUMBER := 1.0;
23: l_commit VARCHAR2(1) := FND_API.G_FALSE;
24: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
25: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
26: l_error_message VARCHAR2(4000);
27: l_error_code VARCHAR2(4000);
28: l_return_status VARCHAR2(1);
29: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 29: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

25: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
26: l_error_message VARCHAR2(4000);
27: l_error_code VARCHAR2(4000);
28: l_return_status VARCHAR2(1);
29: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
30: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
31: l_mtl_trx_rec CSI_INV_TRXS_PKG.MTL_TRX_TYPE;
32: l_trx_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
33: l_msg_count NUMBER;

Line 30: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

26: l_error_message VARCHAR2(4000);
27: l_error_code VARCHAR2(4000);
28: l_return_status VARCHAR2(1);
29: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
30: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
31: l_mtl_trx_rec CSI_INV_TRXS_PKG.MTL_TRX_TYPE;
32: l_trx_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
33: l_msg_count NUMBER;
34: l_msg_data VARCHAR2(4000);

Line 39: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

35: l_txn_error_id NUMBER;
36: l_file VARCHAR2(500);
37: l_xml_string VARCHAR2(2000);
38: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
39: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
40: e_dpl_error EXCEPTION;
41: csi_txn_exists EXCEPTION;
42: l_txn_type_id NUMBER := NULL;
43: l_use_parallel_mode VARCHAR2(1) := 'N'; --Code added for MACD enhancement

Line 763: l_trx_error_rec.error_text := FND_API.G_MISS_CHAR;

759: END IF;
760:
761: ELSE -- Not a valid type so retain existing CSI Error
762: debug('No Transaction Type was found so retain error that exists');
763: l_trx_error_rec.error_text := FND_API.G_MISS_CHAR;
764: l_return_status := l_fnd_error;
765: RAISE e_dpl_error;
766: END IF;
767: