eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_CONFIG_OPERATIONS_INT dependencies on FND_API

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

5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASO_CONFIG_OPERATIONS_INT';
6:
7: PROCEDURE config_operations(
8: P_Api_Version_Number IN NUMBER,
9: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
10: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
11: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
12: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec,
13: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,

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

6:
7: PROCEDURE config_operations(
8: P_Api_Version_Number IN NUMBER,
9: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
10: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
11: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
12: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec,
13: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
14: P_qte_line_tbl IN ASO_QUOTE_PUB.Qte_line_tbl_type := ASO_QUOTE_PUB.G_MISS_Qte_line_tbl ,

Line 11: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

7: PROCEDURE config_operations(
8: P_Api_Version_Number IN NUMBER,
9: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
10: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
11: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
12: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec,
13: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
14: P_qte_line_tbl IN ASO_QUOTE_PUB.Qte_line_tbl_type := ASO_QUOTE_PUB.G_MISS_Qte_line_tbl ,
15: P_instance_tbl IN ASO_QUOTE_HEADERS_PVT.Instance_Tbl_Type,

Line 17: p_delete_flag IN VARCHAR2 := FND_API.G_TRUE,

13: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
14: P_qte_line_tbl IN ASO_QUOTE_PUB.Qte_line_tbl_type := ASO_QUOTE_PUB.G_MISS_Qte_line_tbl ,
15: P_instance_tbl IN ASO_QUOTE_HEADERS_PVT.Instance_Tbl_Type,
16: p_operation_code IN VARCHAR2,
17: p_delete_flag IN VARCHAR2 := FND_API.G_TRUE,
18: x_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
19: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
20: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
21: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 63: IF NOT FND_API.Compatible_API_Call (

59:
60: SAVEPOINT config_operations_int;
61:
62: -- Standard call to check for call compatibility.
63: IF NOT FND_API.Compatible_API_Call (
64: l_api_version,
65: p_api_version_Number,
66: l_api_name,
67: G_PKG_NAME )

Line 69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

65: p_api_version_Number,
66: l_api_name,
67: G_PKG_NAME )
68: THEN
69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
70: END IF;
71:
72: -- Initialize message list if p_init_msg_list is set to TRUE.
73: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 73: IF FND_API.to_Boolean( p_init_msg_list ) THEN

69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
70: END IF;
71:
72: -- Initialize message list if p_init_msg_list is set to TRUE.
73: IF FND_API.to_Boolean( p_init_msg_list ) THEN
74: FND_MSG_PUB.initialize;
75: END IF;
76:
77:

Line 79: x_return_status := FND_API.G_RET_STS_SUCCESS;

75: END IF;
76:
77:
78: -- Initialize API return status to success
79: x_return_status := FND_API.G_RET_STS_SUCCESS;
80: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
81: If (p_operation_code = ASO_QUOTE_PUB.G_ADD_TO_CONTAINER) THEN
82:
83: ASO_CONFIG_OPERATIONS_PVT.Add_to_Container_from_IB(

Line 85: P_Init_Msg_List => FND_API.G_FALSE,

81: If (p_operation_code = ASO_QUOTE_PUB.G_ADD_TO_CONTAINER) THEN
82:
83: ASO_CONFIG_OPERATIONS_PVT.Add_to_Container_from_IB(
84: P_Api_Version_Number => 1.0,
85: P_Init_Msg_List => FND_API.G_FALSE,
86: P_Commit => FND_API.G_FALSE,
87: p_validation_level => p_validation_level,
88: P_Control_Rec => l_control_rec,
89: P_Qte_Header_Rec => p_qte_header_rec,

Line 86: P_Commit => FND_API.G_FALSE,

82:
83: ASO_CONFIG_OPERATIONS_PVT.Add_to_Container_from_IB(
84: P_Api_Version_Number => 1.0,
85: P_Init_Msg_List => FND_API.G_FALSE,
86: P_Commit => FND_API.G_FALSE,
87: p_validation_level => p_validation_level,
88: P_Control_Rec => l_control_rec,
89: P_Qte_Header_Rec => p_qte_header_rec,
90: P_Quote_line_Id => p_qte_line_tbl(1).quote_line_id,

Line 102: P_Init_Msg_List => FND_API.G_FALSE,

98: ELSIF (p_operation_code = ASO_QUOTE_PUB.G_RECONFIGURE) THEN
99:
100: ASO_CONFIG_OPERATIONS_PVT.Reconfigure_from_IB(
101: P_Api_Version_Number => 1.0,
102: P_Init_Msg_List => FND_API.G_FALSE,
103: P_Commit => FND_API.G_FALSE,
104: p_validation_level => p_validation_level,
105: P_Control_Rec => l_control_rec,
106: P_Qte_Header_Rec => p_qte_header_rec,

Line 103: P_Commit => FND_API.G_FALSE,

99:
100: ASO_CONFIG_OPERATIONS_PVT.Reconfigure_from_IB(
101: P_Api_Version_Number => 1.0,
102: P_Init_Msg_List => FND_API.G_FALSE,
103: P_Commit => FND_API.G_FALSE,
104: p_validation_level => p_validation_level,
105: P_Control_Rec => l_control_rec,
106: P_Qte_Header_Rec => p_qte_header_rec,
107: P_instance_tbl => p_instance_tbl,

Line 116: IF (P_Control_Rec.deactivate_all = FND_API.G_TRUE)THEN

112: );
113:
114: ELSIF (p_operation_code = ASO_QUOTE_PUB.G_DEACTIVATE) THEN
115:
116: IF (P_Control_Rec.deactivate_all = FND_API.G_TRUE)THEN
117:
118: l_Control_Rec.deactivate_all := FND_API.G_TRUE;
119: END IF;
120:

Line 118: l_Control_Rec.deactivate_all := FND_API.G_TRUE;

114: ELSIF (p_operation_code = ASO_QUOTE_PUB.G_DEACTIVATE) THEN
115:
116: IF (P_Control_Rec.deactivate_all = FND_API.G_TRUE)THEN
117:
118: l_Control_Rec.deactivate_all := FND_API.G_TRUE;
119: END IF;
120:
121: ASO_CONFIG_OPERATIONS_PVT.Deactivate_from_quote(
122: P_Api_Version_Number => 1.0,

Line 123: P_Init_Msg_List => FND_API.G_FALSE,

119: END IF;
120:
121: ASO_CONFIG_OPERATIONS_PVT.Deactivate_from_quote(
122: P_Api_Version_Number => 1.0,
123: P_Init_Msg_List => FND_API.G_FALSE,
124: P_Commit => FND_API.G_FALSE,
125: p_validation_level => p_validation_level,
126: P_Control_Rec => l_control_rec,
127: P_Qte_Header_Rec => p_qte_header_rec,

Line 124: P_Commit => FND_API.G_FALSE,

120:
121: ASO_CONFIG_OPERATIONS_PVT.Deactivate_from_quote(
122: P_Api_Version_Number => 1.0,
123: P_Init_Msg_List => FND_API.G_FALSE,
124: P_Commit => FND_API.G_FALSE,
125: p_validation_level => p_validation_level,
126: P_Control_Rec => l_control_rec,
127: P_Qte_Header_Rec => p_qte_header_rec,
128: P_Qte_line_tbl => p_qte_line_tbl,

Line 143: IF x_return_status = FND_API.G_RET_STS_ERROR then

139: aso_debug_pub.add('Config_Operations:X_Return_Status:'||X_Return_Status,1,'N');
140: aso_debug_pub.add('Config_Operations:X_Msg_Count:'||X_Msg_Count,1,'N');
141: END IF;
142:
143: IF x_return_status = FND_API.G_RET_STS_ERROR then
144: raise FND_API.G_EXC_ERROR;
145: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
146: raise FND_API.G_EXC_UNEXPECTED_ERROR;
147: END IF;

Line 144: raise FND_API.G_EXC_ERROR;

140: aso_debug_pub.add('Config_Operations:X_Msg_Count:'||X_Msg_Count,1,'N');
141: END IF;
142:
143: IF x_return_status = FND_API.G_RET_STS_ERROR then
144: raise FND_API.G_EXC_ERROR;
145: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
146: raise FND_API.G_EXC_UNEXPECTED_ERROR;
147: END IF;
148:

Line 145: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

141: END IF;
142:
143: IF x_return_status = FND_API.G_RET_STS_ERROR then
144: raise FND_API.G_EXC_ERROR;
145: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
146: raise FND_API.G_EXC_UNEXPECTED_ERROR;
147: END IF;
148:
149: l_qte_header_rec := p_qte_header_rec;

Line 146: raise FND_API.G_EXC_UNEXPECTED_ERROR;

142:
143: IF x_return_status = FND_API.G_RET_STS_ERROR then
144: raise FND_API.G_EXC_ERROR;
145: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
146: raise FND_API.G_EXC_UNEXPECTED_ERROR;
147: END IF;
148:
149: l_qte_header_rec := p_qte_header_rec;
150:

Line 160: x_return_status := FND_API.G_RET_STS_ERROR;

156: -- l_QTE_HEADER_REC.last_update_date := l_last_update_date;
157:
158: exception when no_data_found then
159:
160: x_return_status := FND_API.G_RET_STS_ERROR;
161: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
162: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
163: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
164: FND_MSG_PUB.ADD;

Line 167: raise FND_API.G_EXC_ERROR;

163: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
164: FND_MSG_PUB.ADD;
165: END IF;
166:
167: raise FND_API.G_EXC_ERROR;
168:
169: end;
170:
171: ASO_QUOTE_PUB.Update_Quote(

Line 209: IF x_return_status = FND_API.G_RET_STS_ERROR then

205: aso_debug_pub.add('Config_Operations:update_quote:X_Return_Status:'||X_Return_Status,1,'N');
206: aso_debug_pub.add('Config_Operations:update_quote:X_Msg_Count:'||X_Msg_Count,1,'N');
207: END IF;
208:
209: IF x_return_status = FND_API.G_RET_STS_ERROR then
210: raise FND_API.G_EXC_ERROR;
211: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
212: raise FND_API.G_EXC_UNEXPECTED_ERROR;
213: END IF;

Line 210: raise FND_API.G_EXC_ERROR;

206: aso_debug_pub.add('Config_Operations:update_quote:X_Msg_Count:'||X_Msg_Count,1,'N');
207: END IF;
208:
209: IF x_return_status = FND_API.G_RET_STS_ERROR then
210: raise FND_API.G_EXC_ERROR;
211: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
212: raise FND_API.G_EXC_UNEXPECTED_ERROR;
213: END IF;
214:

Line 211: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

207: END IF;
208:
209: IF x_return_status = FND_API.G_RET_STS_ERROR then
210: raise FND_API.G_EXC_ERROR;
211: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
212: raise FND_API.G_EXC_UNEXPECTED_ERROR;
213: END IF;
214:
215:

Line 212: raise FND_API.G_EXC_UNEXPECTED_ERROR;

208:
209: IF x_return_status = FND_API.G_RET_STS_ERROR then
210: raise FND_API.G_EXC_ERROR;
211: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
212: raise FND_API.G_EXC_UNEXPECTED_ERROR;
213: END IF;
214:
215:
216: -- End of API body

Line 222: IF FND_API.To_Boolean(p_commit) THEN

218: aso_debug_pub.add('****** End of confog operations API ******', 1, 'Y');
219: END IF;
220:
221: -- Standard check of p_commit
222: IF FND_API.To_Boolean(p_commit) THEN
223: COMMIT WORK;
224: END IF;
225:
226: -- Standard call to get message count and if count is 1, get message info

Line 228: p_encoded => FND_API.G_FALSE,

224: END IF;
225:
226: -- Standard call to get message count and if count is 1, get message info
227: FND_Msg_Pub.Count_And_Get(
228: p_encoded => FND_API.G_FALSE,
229: p_count => x_msg_count ,
230: p_data => x_msg_data
231: );
232:

Line 235: WHEN FND_API.G_EXC_ERROR THEN

231: );
232:
233:
234: EXCEPTION
235: WHEN FND_API.G_EXC_ERROR THEN
236: x_return_status := FND_API.G_RET_STS_ERROR;
237: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
238: P_API_NAME => L_API_NAME
239: ,P_PKG_NAME => G_PKG_NAME

Line 236: x_return_status := FND_API.G_RET_STS_ERROR;

232:
233:
234: EXCEPTION
235: WHEN FND_API.G_EXC_ERROR THEN
236: x_return_status := FND_API.G_RET_STS_ERROR;
237: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
238: P_API_NAME => L_API_NAME
239: ,P_PKG_NAME => G_PKG_NAME
240: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 246: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

242: ,X_MSG_COUNT => X_MSG_COUNT
243: ,X_MSG_DATA => X_MSG_DATA
244: ,X_RETURN_STATUS => X_RETURN_STATUS);
245:
246: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
248: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
249: P_API_NAME => L_API_NAME
250: ,P_PKG_NAME => G_PKG_NAME

Line 247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

243: ,X_MSG_DATA => X_MSG_DATA
244: ,X_RETURN_STATUS => X_RETURN_STATUS);
245:
246: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
248: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
249: P_API_NAME => L_API_NAME
250: ,P_PKG_NAME => G_PKG_NAME
251: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

254: ,X_MSG_DATA => X_MSG_DATA
255: ,X_RETURN_STATUS => X_RETURN_STATUS);
256:
257: WHEN OTHERS THEN
258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
259: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
260: P_API_NAME => L_API_NAME
261: ,P_PKG_NAME => G_PKG_NAME
262: ,P_SQLERRM => sqlerrm