DBA Data[Home] [Help]

APPS.INL_CHARGE_PVT dependencies on FND_API

Line 11: -- L_FND_TRUE CONSTANT VARCHAR2(1) := fnd_api.g_true; --Bug#9660056

7: -- L_FND_CONC_REQUEST_ID CONSTANT NUMBER := fnd_global.conc_request_id; --Bug#9660056
8: -- L_FND_LOCAL_CHR CONSTANT VARCHAR2(100) := fnd_global.local_chr (10); --Bug#9660056
9: L_FND_LOGIN_ID CONSTANT NUMBER := fnd_global.login_id; --Bug#9660056
10:
11: -- L_FND_TRUE CONSTANT VARCHAR2(1) := fnd_api.g_true; --Bug#9660056
12: -- L_FND_VALID_LEVEL_FULL CONSTANT NUMBER := fnd_api.g_valid_level_full; --Bug#9660056
13: -- L_FND_MISS_NUM CONSTANT NUMBER := fnd_api.g_miss_num; --Bug#9660056
14: -- L_FND_MISS_CHAR CONSTANT VARCHAR2(1) := fnd_api.g_miss_char; --Bug#9660056
15:

Line 12: -- L_FND_VALID_LEVEL_FULL CONSTANT NUMBER := fnd_api.g_valid_level_full; --Bug#9660056

8: -- L_FND_LOCAL_CHR CONSTANT VARCHAR2(100) := fnd_global.local_chr (10); --Bug#9660056
9: L_FND_LOGIN_ID CONSTANT NUMBER := fnd_global.login_id; --Bug#9660056
10:
11: -- L_FND_TRUE CONSTANT VARCHAR2(1) := fnd_api.g_true; --Bug#9660056
12: -- L_FND_VALID_LEVEL_FULL CONSTANT NUMBER := fnd_api.g_valid_level_full; --Bug#9660056
13: -- L_FND_MISS_NUM CONSTANT NUMBER := fnd_api.g_miss_num; --Bug#9660056
14: -- L_FND_MISS_CHAR CONSTANT VARCHAR2(1) := fnd_api.g_miss_char; --Bug#9660056
15:
16: L_FND_EXC_ERROR EXCEPTION; --Bug#9660056

Line 13: -- L_FND_MISS_NUM CONSTANT NUMBER := fnd_api.g_miss_num; --Bug#9660056

9: L_FND_LOGIN_ID CONSTANT NUMBER := fnd_global.login_id; --Bug#9660056
10:
11: -- L_FND_TRUE CONSTANT VARCHAR2(1) := fnd_api.g_true; --Bug#9660056
12: -- L_FND_VALID_LEVEL_FULL CONSTANT NUMBER := fnd_api.g_valid_level_full; --Bug#9660056
13: -- L_FND_MISS_NUM CONSTANT NUMBER := fnd_api.g_miss_num; --Bug#9660056
14: -- L_FND_MISS_CHAR CONSTANT VARCHAR2(1) := fnd_api.g_miss_char; --Bug#9660056
15:
16: L_FND_EXC_ERROR EXCEPTION; --Bug#9660056
17: L_FND_EXC_UNEXPECTED_ERROR EXCEPTION; --Bug#9660056

Line 14: -- L_FND_MISS_CHAR CONSTANT VARCHAR2(1) := fnd_api.g_miss_char; --Bug#9660056

10:
11: -- L_FND_TRUE CONSTANT VARCHAR2(1) := fnd_api.g_true; --Bug#9660056
12: -- L_FND_VALID_LEVEL_FULL CONSTANT NUMBER := fnd_api.g_valid_level_full; --Bug#9660056
13: -- L_FND_MISS_NUM CONSTANT NUMBER := fnd_api.g_miss_num; --Bug#9660056
14: -- L_FND_MISS_CHAR CONSTANT VARCHAR2(1) := fnd_api.g_miss_char; --Bug#9660056
15:
16: L_FND_EXC_ERROR EXCEPTION; --Bug#9660056
17: L_FND_EXC_UNEXPECTED_ERROR EXCEPTION; --Bug#9660056
18:

Line 19: L_FND_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_success; --Bug#9660056

15:
16: L_FND_EXC_ERROR EXCEPTION; --Bug#9660056
17: L_FND_EXC_UNEXPECTED_ERROR EXCEPTION; --Bug#9660056
18:
19: L_FND_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_success; --Bug#9660056
20: L_FND_RET_STS_ERROR CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_error; --Bug#9660056
21: L_FND_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;--Bug#9660056
22:
23:

Line 20: L_FND_RET_STS_ERROR CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_error; --Bug#9660056

16: L_FND_EXC_ERROR EXCEPTION; --Bug#9660056
17: L_FND_EXC_UNEXPECTED_ERROR EXCEPTION; --Bug#9660056
18:
19: L_FND_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_success; --Bug#9660056
20: L_FND_RET_STS_ERROR CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_error; --Bug#9660056
21: L_FND_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;--Bug#9660056
22:
23:
24: -- Utility name : Insert_Association

Line 21: L_FND_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;--Bug#9660056

17: L_FND_EXC_UNEXPECTED_ERROR EXCEPTION; --Bug#9660056
18:
19: L_FND_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_success; --Bug#9660056
20: L_FND_RET_STS_ERROR CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_error; --Bug#9660056
21: L_FND_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;--Bug#9660056
22:
23:
24: -- Utility name : Insert_Association
25: -- Type : Private

Line 2089: l_result VARCHAR2(1) := FND_API.G_TRUE;

2085: x_return_status OUT NOCOPY VARCHAR2) RETURN NUMBER IS
2086:
2087: l_func_name CONSTANT VARCHAR2(30) := 'Get_SimulShipLine';
2088: l_debug_info VARCHAR2(400);
2089: l_result VARCHAR2(1) := FND_API.G_TRUE;
2090: l_return_status VARCHAR2(1) := FND_API.G_TRUE;
2091: l_ship_line_source_id NUMBER;
2092: l_ship_line_src_type_code VARCHAR2(30);
2093: l_simul_ship_line_id NUMBER;

Line 2090: l_return_status VARCHAR2(1) := FND_API.G_TRUE;

2086:
2087: l_func_name CONSTANT VARCHAR2(30) := 'Get_SimulShipLine';
2088: l_debug_info VARCHAR2(400);
2089: l_result VARCHAR2(1) := FND_API.G_TRUE;
2090: l_return_status VARCHAR2(1) := FND_API.G_TRUE;
2091: l_ship_line_source_id NUMBER;
2092: l_ship_line_src_type_code VARCHAR2(30);
2093: l_simul_ship_line_id NUMBER;
2094: BEGIN

Line 2467: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE

2463: -- can be the QP or any other logic defined inside the Charges Hook.
2464: -- Pre-reqs : None
2465: -- Parameters :
2466: -- IN : p_api_version IN NUMBER Required
2467: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
2468: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
2469: -- p_ship_header_id IN NUMBER Required
2470: --
2471: -- OUT x_return_status OUT NOCOPY VARCHAR2

Line 2468: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

2464: -- Pre-reqs : None
2465: -- Parameters :
2466: -- IN : p_api_version IN NUMBER Required
2467: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
2468: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
2469: -- p_ship_header_id IN NUMBER Required
2470: --
2471: -- OUT x_return_status OUT NOCOPY VARCHAR2
2472: -- x_msg_count OUT NOCOPY NUMBER

Line 2527: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2523: -- Standard Start of API savepoint
2524: SAVEPOINT Generate_Charges_PVT;
2525:
2526: -- Initialize message list if p_init_msg_list is set to TRUE.
2527: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2528: FND_MSG_PUB.initialize;
2529: END IF;
2530:
2531: -- Check for call compatibility.

Line 2532: IF NOT FND_API.Compatible_API_Call (

2528: FND_MSG_PUB.initialize;
2529: END IF;
2530:
2531: -- Check for call compatibility.
2532: IF NOT FND_API.Compatible_API_Call (
2533: p_current_version_number => l_api_version,
2534: p_caller_version_number => p_api_version,
2535: p_api_name => l_api_name,
2536: p_pkg_name => g_pkg_name)

Line 2943: IF FND_API.To_Boolean( p_commit ) THEN

2939: END LOOP;
2940: END IF;
2941: END IF;
2942: -- Standard check of p_commit.
2943: IF FND_API.To_Boolean( p_commit ) THEN
2944: COMMIT WORK;
2945: END IF;
2946:
2947: -- Standard call to get message count and if count is 1, get message info.

Line 2949: p_encoded => FND_API.g_false,

2945: END IF;
2946:
2947: -- Standard call to get message count and if count is 1, get message info.
2948: FND_MSG_PUB.Count_And_Get(
2949: p_encoded => FND_API.g_false,
2950: p_count => x_msg_count,
2951: p_data => x_msg_data);
2952:
2953: -- Standard End of Procedure/Function Logging

Line 2964: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

2960: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
2961: p_procedure_name => l_api_name);
2962: ROLLBACK TO Generate_Charges_PVT;
2963: x_return_status := L_FND_RET_STS_ERROR;
2964: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2965: p_count => x_msg_count,
2966: p_data => x_msg_data);
2967: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
2968: -- Standard Unexpected Error Logging

Line 2973: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

2969: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
2970: p_procedure_name => l_api_name);
2971: ROLLBACK TO Generate_Charges_PVT;
2972: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
2973: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2974: p_count => x_msg_count,
2975: p_data => x_msg_data);
2976: WHEN OTHERS THEN
2977: -- Standard Unexpected Error Logging

Line 2987: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

2983: THEN
2984: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
2985: p_procedure_name => l_api_name);
2986: END IF;
2987: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2988: p_count => x_msg_count,
2989: p_data => x_msg_data);
2990: END Generate_Charges;
2991: