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_VALIDATE_CFG_PVT dependencies on FND_API

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

20: -----------------------------------------------------------------------*/
21:
22: PROCEDURE Validate_Configuration
23: (P_Api_Version_Number IN NUMBER ,
24: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
25: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
26: p_control_rec IN aso_quote_pub.control_rec_type
27: := aso_quote_pub.G_MISS_control_rec,
28: P_model_line_id IN NUMBER,

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

21:
22: PROCEDURE Validate_Configuration
23: (P_Api_Version_Number IN NUMBER ,
24: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
25: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
26: p_control_rec IN aso_quote_pub.control_rec_type
27: := aso_quote_pub.G_MISS_control_rec,
28: P_model_line_id IN NUMBER,
29: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type

Line 33: P_UPDATE_QUOTE IN VARCHAR2 := FND_API.G_FALSE,

29: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
30: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,
31: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
32: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,
33: P_UPDATE_QUOTE IN VARCHAR2 := FND_API.G_FALSE,
34: P_EFFECTIVE_DATE IN Date := FND_API.G_MISS_DATE,
35: P_model_lookup_DATE IN Date := FND_API.G_MISS_DATE,
36: X_config_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
37: X_config_revision_num OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 34: P_EFFECTIVE_DATE IN Date := FND_API.G_MISS_DATE,

30: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,
31: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
32: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,
33: P_UPDATE_QUOTE IN VARCHAR2 := FND_API.G_FALSE,
34: P_EFFECTIVE_DATE IN Date := FND_API.G_MISS_DATE,
35: P_model_lookup_DATE IN Date := FND_API.G_MISS_DATE,
36: X_config_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
37: X_config_revision_num OUT NOCOPY /* file.sql.39 change */ NUMBER,
38: X_valid_configuration_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 35: P_model_lookup_DATE IN Date := FND_API.G_MISS_DATE,

31: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
32: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,
33: P_UPDATE_QUOTE IN VARCHAR2 := FND_API.G_FALSE,
34: P_EFFECTIVE_DATE IN Date := FND_API.G_MISS_DATE,
35: P_model_lookup_DATE IN Date := FND_API.G_MISS_DATE,
36: X_config_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
37: X_config_revision_num OUT NOCOPY /* file.sql.39 change */ NUMBER,
38: X_valid_configuration_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
39: X_complete_configuration_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 73: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

69: -- upgrade stuff
70: l_upgraded_flag VARCHAR2(1);
71:
72: -- cz's delete return value
73: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
74: l_delete_config VARCHAR2(1) := fnd_api.g_false;
75: l_old_config_hdr_id NUMBER;
76: l_new_config_hdr_id number;
77:

Line 74: l_delete_config VARCHAR2(1) := fnd_api.g_false;

70: l_upgraded_flag VARCHAR2(1);
71:
72: -- cz's delete return value
73: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
74: l_delete_config VARCHAR2(1) := fnd_api.g_false;
75: l_old_config_hdr_id NUMBER;
76: l_new_config_hdr_id number;
77:
78: CURSOR c_config_exist_in_cz (p_config_hdr_id number, p_config_rev_nbr number) IS

Line 86: l_return_status := FND_API.G_RET_STS_SUCCESS;

82: and config_rev_nbr = p_config_rev_nbr;
83:
84: BEGIN
85:
86: l_return_status := FND_API.G_RET_STS_SUCCESS;
87:
88: IF aso_debug_pub.g_debug_flag = 'Y' THEN
89: aso_debug_pub.add('ASO_VALIDATE_CFG_PVT: Validate_Configuration Begins', 1, 'Y');
90: END IF;

Line 92: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

88: IF aso_debug_pub.g_debug_flag = 'Y' THEN
89: aso_debug_pub.add('ASO_VALIDATE_CFG_PVT: Validate_Configuration Begins', 1, 'Y');
90: END IF;
91:
92: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
93: p_api_version_number,
94: l_api_name,
95: G_PKG_NAME) THEN
96: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 96: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

92: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
93: p_api_version_number,
94: l_api_name,
95: G_PKG_NAME) THEN
96: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
97: END IF;
98:
99: IF FND_API.to_Boolean( p_init_msg_list ) THEN
100: FND_MSG_PUB.initialize;

Line 99: IF FND_API.to_Boolean( p_init_msg_list ) THEN

95: G_PKG_NAME) THEN
96: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
97: END IF;
98:
99: IF FND_API.to_Boolean( p_init_msg_list ) THEN
100: FND_MSG_PUB.initialize;
101: END IF;
102:
103: -- Get model line info

Line 134: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

130:
131: -- dbms_output.put_line('Entered ASO_VALIDATE_CFG_PVT before send input xml'||l_return_status);
132: -- dbms_output.put_line('Entered ASO_VALIDATE_CFG_PVT before send input xml'||l_xml_hdr);
133:
134: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
135:
136: -- Call Send_Input_Xml to call CZ batch validate procedure and get the output XML message
137:
138: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 162: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

158: --dbms_output.put_line('Entered ASO_VALIDATE_CFG_PVT after send input xml'||l_config_changed_flag);
159:
160: -- extract data from xml message.
161:
162: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
163: l_delete_config := fnd_api.g_true;
164: END IF;
165:
166: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 163: l_delete_config := fnd_api.g_true;

159:
160: -- extract data from xml message.
161:
162: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
163: l_delete_config := fnd_api.g_true;
164: END IF;
165:
166: IF aso_debug_pub.g_debug_flag = 'Y' THEN
167: aso_debug_pub.add('Validate_Configuration: Before Call to Parse_Output_xml',1,'N');

Line 192: IF ((l_return_status =FND_API.G_RET_STS_SUCCESS) and (p_update_quote=fnd_api.g_false) and (l_delete_config=fnd_api.g_false))THEN

188:
189: END IF;
190: --dbms_output.put_line('Entered ASO_VALIDATE_CFG_PVT after parse header xml'||l_return_status);
191:
192: IF ((l_return_status =FND_API.G_RET_STS_SUCCESS) and (p_update_quote=fnd_api.g_false) and (l_delete_config=fnd_api.g_false))THEN
193:
194: --dbms_output.put_line('Entered ASO_VALIDATE_CFG_PVT p_update_quote is false');
195: open c_config_exist_in_cz(l_config_header_id, l_config_revision_num);
196: fetch c_config_exist_in_cz into l_new_config_hdr_id;

Line 207: P_INIT_MSG_LIST => FND_API.G_FALSE,

203: aso_debug_pub.add('Update Quote: A higher version exist for this configuration so deleting it from CZ');
204: END IF;
205:
206: ASO_CFG_INT.DELETE_CONFIGURATION_AUTO( P_API_VERSION_NUMBER => 1.0,
207: P_INIT_MSG_LIST => FND_API.G_FALSE,
208: P_CONFIG_HDR_ID => l_config_header_id,
209: P_CONFIG_REV_NBR => l_config_revision_num,
210: X_RETURN_STATUS => x_return_status,
211: X_MSG_COUNT => x_msg_count,

Line 218: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

214: IF aso_debug_pub.g_debug_flag = 'Y' THEN
215: aso_debug_pub.add('After call to ASO_CFG_INT.DELETE_CONFIGURATION_AUTO: x_Return_Status: ' || x_Return_Status);
216: END IF;
217:
218: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
219:
220: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
221: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');
222: FND_MESSAGE.Set_Token('OBJECT', 'CONFIGURATION', FALSE);

Line 226: RAISE FND_API.G_EXC_ERROR;

222: FND_MESSAGE.Set_Token('OBJECT', 'CONFIGURATION', FALSE);
223: FND_MSG_PUB.ADD;
224: END IF;
225:
226: RAISE FND_API.G_EXC_ERROR;
227:
228: END IF;
229:
230: else

Line 236: elsif (l_return_status = FND_API.G_RET_STS_SUCCESS) and (l_delete_config = fnd_api.g_false) and (p_update_quote = fnd_api.g_true)THEN

232: end if;
233:
234: -- END IF;
235:
236: elsif (l_return_status = FND_API.G_RET_STS_SUCCESS) and (l_delete_config = fnd_api.g_false) and (p_update_quote = fnd_api.g_true)THEN
237:
238: -- Call GET_CONFIG_DETAILS to update the existing configuration
239: -- Set the Call_batch_validation_flag to FND_API.G_FALSE to avoid recursive call to update_quote
240: --dbms_output.put_line('Entered ASO_VALIDATE_CFG_PVT p_update_quote is true');

Line 239: -- Set the Call_batch_validation_flag to FND_API.G_FALSE to avoid recursive call to update_quote

235:
236: elsif (l_return_status = FND_API.G_RET_STS_SUCCESS) and (l_delete_config = fnd_api.g_false) and (p_update_quote = fnd_api.g_true)THEN
237:
238: -- Call GET_CONFIG_DETAILS to update the existing configuration
239: -- Set the Call_batch_validation_flag to FND_API.G_FALSE to avoid recursive call to update_quote
240: --dbms_output.put_line('Entered ASO_VALIDATE_CFG_PVT p_update_quote is true');
241: l_model_line_dtl_tbl(1).valid_configuration_flag := l_valid_configuration_flag;
242: l_model_line_dtl_tbl(1).complete_configuration_flag := l_complete_configuration_flag;
243:

Line 253: p_init_msg_list => FND_API.G_FALSE,

249: END IF;
250:
251: ASO_CFG_INT.Get_config_details(
252: p_api_version_number => 1.0,
253: p_init_msg_list => FND_API.G_FALSE,
254: p_commit => FND_API.G_FALSE,
255: p_control_rec => p_control_rec,
256: p_qte_header_rec => l_qte_header_rec,
257: p_model_line_rec => l_model_line_rec,

Line 254: p_commit => FND_API.G_FALSE,

250:
251: ASO_CFG_INT.Get_config_details(
252: p_api_version_number => 1.0,
253: p_init_msg_list => FND_API.G_FALSE,
254: p_commit => FND_API.G_FALSE,
255: p_control_rec => p_control_rec,
256: p_qte_header_rec => l_qte_header_rec,
257: p_model_line_rec => l_model_line_rec,
258: p_config_rec => l_model_line_dtl_tbl(1),

Line 272: l_delete_config := fnd_api.g_true;

268: END IF;
269:
270: ELSE
271: --dbms_output.put_line('Entered ASO_VALIDATE_CFG_PVT l_delete_config is true');
272: l_delete_config := fnd_api.g_true;
273: IF aso_debug_pub.g_debug_flag = 'Y' THEN
274: aso_debug_pub.add('Validate_Configuration: l_delete_config: '||l_delete_config);
275: END IF;
276:

Line 297: if l_delete_config = fnd_api.g_true then

293: x_return_status := l_return_status;
294: x_msg_count := l_msg_count;
295: x_msg_data := l_msg_data;
296:
297: if l_delete_config = fnd_api.g_true then
298:
299: x_return_status := FND_API.G_RET_STS_ERROR;
300:
301: end if;

Line 299: x_return_status := FND_API.G_RET_STS_ERROR;

295: x_msg_data := l_msg_data;
296:
297: if l_delete_config = fnd_api.g_true then
298:
299: x_return_status := FND_API.G_RET_STS_ERROR;
300:
301: end if;
302:
303: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

311: IF aso_debug_pub.g_debug_flag = 'Y' THEN
312: aso_debug_pub.add('Validate_Configuration: Inside WHEN OTHERS EXCEPTION', 1, 'Y');
313: END IF;
314:
315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
316:
317: END Validate_Configuration;
318:
319: /*-------------------------------------------------------------------------

Line 326: P_EFFECTIVE_DATE IN Date := FND_API.G_MISS_DATE,

322: --------------------------------------------------------------------------*/
323:
324: PROCEDURE Create_header_xml
325: ( p_model_line_id IN NUMBER,
326: P_EFFECTIVE_DATE IN Date := FND_API.G_MISS_DATE,
327: P_model_lookup_DATE IN Date := FND_API.G_MISS_DATE,
328: x_xml_hdr OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
329: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )
330: IS

Line 327: P_model_lookup_DATE IN Date := FND_API.G_MISS_DATE,

323:
324: PROCEDURE Create_header_xml
325: ( p_model_line_id IN NUMBER,
326: P_EFFECTIVE_DATE IN Date := FND_API.G_MISS_DATE,
327: P_model_lookup_DATE IN Date := FND_API.G_MISS_DATE,
328: x_xml_hdr OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
329: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )
330: IS
331:

Line 393: x_return_status := FND_API.G_RET_STS_SUCCESS;

389: END IF;
390:
391: --dbms_output.put_line('Entered ASO_VALIDATE_CFG_PVT rassharm create header xml');
392: --Initialize API return status to SUCCESS
393: x_return_status := FND_API.G_RET_STS_SUCCESS;
394:
395: l_model_line_rec := aso_utility_pvt.Query_Qte_Line_Row( P_Qte_Line_Id => p_model_line_id );
396:
397: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 529: if (p_effective_date<>fnd_API.G_MISS_DATE) then

525: param_value(11) := l_msg_behavior;
526: param_value(12) := l_model_quantity;
527: param_value(13) := l_icx_session_ticket;
528:
529: if (p_effective_date<>fnd_API.G_MISS_DATE) then
530: aso_debug_pub.add('Create_header_xml: Effective date provided ');
531: param_value(14) := to_char(p_effective_date,'MM-DD-YYYY-HH24-MI-SS');
532: param_value(15) :=to_char(P_model_lookup_DATE,'MM-DD-YYYY-HH24-MI-SS');
533: else

Line 613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

609: EXCEPTION
610:
611: when others then
612:
613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
614:
615: IF aso_debug_pub.g_debug_flag = 'Y' THEN
616: aso_debug_pub.add('Create_header_xml: Inside When Others Exception: x_return_status: '||x_return_status, 1, 'N');
617: END IF;