DBA Data[Home] [Help]

APPS.ASO_CFG_PUB dependencies on FND_API

Line 17: P_Api_Version_Number IN NUMBER := FND_API.G_MISS_NUM,

13: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asopcfgb.pls';
14:
15:
16: PROCEDURE Get_config_details(
17: P_Api_Version_Number IN NUMBER := FND_API.G_MISS_NUM,
18: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
19: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
20: p_control_rec IN aso_quote_pub.control_rec_type
21: := aso_quote_pub.G_MISS_control_rec,

Line 18: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

14:
15:
16: PROCEDURE Get_config_details(
17: P_Api_Version_Number IN NUMBER := FND_API.G_MISS_NUM,
18: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
19: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
20: p_control_rec IN aso_quote_pub.control_rec_type
21: := aso_quote_pub.G_MISS_control_rec,
22: p_config_rec IN aso_quote_pub.qte_line_dtl_rec_type,

Line 19: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

15:
16: PROCEDURE Get_config_details(
17: P_Api_Version_Number IN NUMBER := FND_API.G_MISS_NUM,
18: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
19: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
20: p_control_rec IN aso_quote_pub.control_rec_type
21: := aso_quote_pub.G_MISS_control_rec,
22: p_config_rec IN aso_quote_pub.qte_line_dtl_rec_type,
23: p_model_line_rec IN aso_quote_pub.qte_line_rec_type,

Line 40: p_init_msg_list => fnd_api.g_false,

36: l_qte_header_rec.quote_header_id := p_quote_header_id;
37:
38: get_config_details(
39: p_api_version_number => p_api_version_number,
40: p_init_msg_list => fnd_api.g_false,
41: p_commit => p_commit,
42: p_control_rec => p_control_rec,
43: p_qte_header_rec => l_qte_header_rec,
44: p_model_line_rec => p_model_line_rec,

Line 59: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

55: --Overloaded get_config_details procedure
56:
57: PROCEDURE get_config_details(
58: p_api_version_number IN NUMBER,
59: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
60: p_commit IN VARCHAR2 := FND_API.G_FALSE,
61: p_control_rec IN aso_quote_pub.control_rec_type
62: := aso_quote_pub.G_MISS_control_rec,
63: p_qte_header_rec IN aso_quote_pub.qte_header_rec_type,

Line 60: p_commit IN VARCHAR2 := FND_API.G_FALSE,

56:
57: PROCEDURE get_config_details(
58: p_api_version_number IN NUMBER,
59: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
60: p_commit IN VARCHAR2 := FND_API.G_FALSE,
61: p_control_rec IN aso_quote_pub.control_rec_type
62: := aso_quote_pub.G_MISS_control_rec,
63: p_qte_header_rec IN aso_quote_pub.qte_header_rec_type,
64: p_model_line_rec IN aso_quote_pub.qte_line_rec_type,

Line 85: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

81:
82: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
83:
84: -- Standard call to check for call compatibility.
85: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
86: p_api_version_number,
87: l_api_name,
88: G_PKG_NAME) THEN
89:

Line 90: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

86: p_api_version_number,
87: l_api_name,
88: G_PKG_NAME) THEN
89:
90: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
91:
92: END IF;
93:
94: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 99: IF FND_API.to_Boolean( p_init_msg_list ) THEN

95: aso_debug_pub.add( 'ASO_CFG_PUB: GET_CONFIG_DETAILS start %%%%%%%%%%%%%%%%%%%', 1, 'Y' );
96: END IF;
97:
98: -- Initialize message list if p_init_msg_list is set to TRUE.
99: IF FND_API.to_Boolean( p_init_msg_list ) THEN
100: FND_MSG_PUB.initialize;
101: END IF;
102:
103: -- Initialize API return status to SUCCESS

Line 104: x_return_status := FND_API.G_RET_STS_SUCCESS;

100: FND_MSG_PUB.initialize;
101: END IF;
102:
103: -- Initialize API return status to SUCCESS
104: x_return_status := FND_API.G_RET_STS_SUCCESS;
105:
106: ASO_CFG_INT.Get_config_details(
107: P_Api_Version_Number => P_Api_Version_Number,
108: P_Init_Msg_List => FND_API.G_FALSE,

Line 108: P_Init_Msg_List => FND_API.G_FALSE,

104: x_return_status := FND_API.G_RET_STS_SUCCESS;
105:
106: ASO_CFG_INT.Get_config_details(
107: P_Api_Version_Number => P_Api_Version_Number,
108: P_Init_Msg_List => FND_API.G_FALSE,
109: P_Commit => p_commit,
110: p_control_rec => p_control_rec,
111: p_qte_header_rec => p_qte_header_rec,
112: p_model_line_rec => p_model_line_rec,

Line 122: IF x_return_status = FND_API.G_RET_STS_ERROR then

118: x_msg_data => x_msg_data );
119:
120:
121: -- Check return status from the above procedure call
122: IF x_return_status = FND_API.G_RET_STS_ERROR then
123: raise FND_API.G_EXC_ERROR;
124: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
125: raise FND_API.G_EXC_UNEXPECTED_ERROR;
126: END IF;

Line 123: raise FND_API.G_EXC_ERROR;

119:
120:
121: -- Check return status from the above procedure call
122: IF x_return_status = FND_API.G_RET_STS_ERROR then
123: raise FND_API.G_EXC_ERROR;
124: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
125: raise FND_API.G_EXC_UNEXPECTED_ERROR;
126: END IF;
127:

Line 124: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

120:
121: -- Check return status from the above procedure call
122: IF x_return_status = FND_API.G_RET_STS_ERROR then
123: raise FND_API.G_EXC_ERROR;
124: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
125: raise FND_API.G_EXC_UNEXPECTED_ERROR;
126: END IF;
127:
128:

Line 125: raise FND_API.G_EXC_UNEXPECTED_ERROR;

121: -- Check return status from the above procedure call
122: IF x_return_status = FND_API.G_RET_STS_ERROR then
123: raise FND_API.G_EXC_ERROR;
124: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
125: raise FND_API.G_EXC_UNEXPECTED_ERROR;
126: END IF;
127:
128:
129:

Line 131: IF FND_API.to_Boolean( p_commit ) THEN

127:
128:
129:
130: -- Standard check for p_commit
131: IF FND_API.to_Boolean( p_commit ) THEN
132: COMMIT WORK;
133: END IF;
134:
135:

Line 145: WHEN FND_API.G_EXC_ERROR THEN

141: aso_debug_pub.add( 'ASO_CFG_PUB: GET_CONFIG_DETAILS End %%%%%%%%%%%%%%%%%%%', 1, 'Y' );
142: END IF;
143:
144: EXCEPTION
145: WHEN FND_API.G_EXC_ERROR THEN
146: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME
147: ,P_PKG_NAME => G_PKG_NAME
148: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
149: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

Line 154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

150: ,X_MSG_COUNT => X_MSG_COUNT
151: ,X_MSG_DATA => X_MSG_DATA
152: ,X_RETURN_STATUS => X_RETURN_STATUS);
153:
154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
155: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME
156: ,P_PKG_NAME => G_PKG_NAME
157: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
158: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB