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:
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
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
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:
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:
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
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
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;
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
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
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
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.
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)
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.
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
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
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
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: