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

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

43: End Populate_output_table;
44:
45: PROCEDURE Get_configuration_lines(
46: P_Api_Version_Number IN NUMBER,
47: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
48: p_top_model_line_id IN NUMBER,
49: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.qte_line_tbl_type,
50: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.qte_line_dtl_tbl_type,
51: x_shipment_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.shipment_tbl_type ,

Line 65: p_init_msg_list => FND_API.G_FALSE ,

61: SAVEPOINT GET_CONFIGURATION_LINES_PUB;
62:
63: OE_ORDER_GRP.Get_Option_Lines(
64: p_api_version_number => l_api_version_number ,
65: p_init_msg_list => FND_API.G_FALSE ,
66: p_top_model_line_id => p_top_model_line_id ,
67: x_line_tbl => l_oe_line_tbl ,
68: x_return_status => x_return_status ,
69: x_msg_count => x_msg_count ,

Line 72: If x_return_status <> FND_API.G_RET_STS_SUCCESS Then

68: x_return_status => x_return_status ,
69: x_msg_count => x_msg_count ,
70: x_msg_data => x_msg_data ) ;
71:
72: If x_return_status <> FND_API.G_RET_STS_SUCCESS Then
73: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
74: End if;
75:
76: Populate_output_table(p_oe_line_tbl => l_oe_line_tbl ,

Line 73: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

69: x_msg_count => x_msg_count ,
70: x_msg_data => x_msg_data ) ;
71:
72: If x_return_status <> FND_API.G_RET_STS_SUCCESS Then
73: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
74: End if;
75:
76: Populate_output_table(p_oe_line_tbl => l_oe_line_tbl ,
77: x_qte_line_tbl => x_qte_line_tbl,

Line 82: WHEN FND_API.G_EXC_ERROR THEN

78: x_qte_line_dtl_tbl => x_qte_line_dtl_tbl ,
79: x_shipment_tbl => x_shipment_tbl );
80:
81: EXCEPTION
82: WHEN FND_API.G_EXC_ERROR THEN
83: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
84: P_API_NAME => L_API_NAME
85: ,P_PKG_NAME => G_PKG_NAME
86: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 92: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

88: ,X_MSG_COUNT => X_MSG_COUNT
89: ,X_MSG_DATA => X_MSG_DATA
90: ,X_RETURN_STATUS => X_RETURN_STATUS);
91:
92: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
93: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
94: P_API_NAME => L_API_NAME
95: ,P_PKG_NAME => G_PKG_NAME
96: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 117: P_Init_msg_List IN VARCHAR2 := FND_API.G_FALSE,

113: END Get_Configuration_Lines;
114:
115: PROCEDURE Delete_configuration(
116: P_Api_version_NUmber IN NUMBER,
117: P_Init_msg_List IN VARCHAR2 := FND_API.G_FALSE,
118: P_config_hdr_id IN NUMBER,
119: p_config_rev_nbr IN NUMBER,
120: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
121: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 129: x_return_status := FND_API.G_RET_STS_SUCCESS;

125: l_Error_message VARCHAR2(2000);
126: l_Return_value NUMBER;
127: BEGIN
128:
129: x_return_status := FND_API.G_RET_STS_SUCCESS;
130:
131: cz_cf_api.delete_configuration(P_config_hdr_id,
132: p_config_rev_nbr,
133: l_usage_exists ,

Line 138: x_return_status := FND_API.G_RET_STS_ERROR;

134: l_Error_message ,
135: l_Return_value );
136:
137: IF l_Return_value = 0 Then
138: x_return_status := FND_API.G_RET_STS_ERROR;
139: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
140: FND_MESSAGE.Set_Name('ASO', 'ASO_CZ_DELETE_ERR');
141: FND_MESSAGE.Set_token('MSG_TXT' , l_error_message,FALSE);
142: FND_MSG_PUB.ADD;

Line 151: P_Init_msg_List IN VARCHAR2 := FND_API.G_FALSE,

147:
148:
149: PROCEDURE Delete_configuration_auto(
150: P_Api_version_NUmber IN NUMBER,
151: P_Init_msg_List IN VARCHAR2 := FND_API.G_FALSE,
152: P_config_hdr_id IN NUMBER,
153: p_config_rev_nbr IN NUMBER,
154: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
155: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 162: x_return_status := FND_API.G_RET_STS_SUCCESS;

158:
159: PRAGMA AUTONOMOUS_TRANSACTION;
160:
161: BEGIN
162: x_return_status := FND_API.G_RET_STS_SUCCESS;
163:
164: DELETE_CONFIGURATION(
165: P_API_VERSION_NUMBER => 1.0,
166: P_INIT_MSG_LIST => FND_API.G_FALSE,

Line 166: P_INIT_MSG_LIST => FND_API.G_FALSE,

162: x_return_status := FND_API.G_RET_STS_SUCCESS;
163:
164: DELETE_CONFIGURATION(
165: P_API_VERSION_NUMBER => 1.0,
166: P_INIT_MSG_LIST => FND_API.G_FALSE,
167: P_CONFIG_HDR_ID => P_config_hdr_id,
168: P_CONFIG_REV_NBR => p_config_rev_nbr,
169: X_RETURN_STATUS => x_return_status,
170: X_MSG_COUNT => x_msg_count,

Line 173: IF x_return_status = FND_API.G_RET_STS_SUCCESS Then

169: X_RETURN_STATUS => x_return_status,
170: X_MSG_COUNT => x_msg_count,
171: X_MSG_DATA => x_msg_data);
172:
173: IF x_return_status = FND_API.G_RET_STS_SUCCESS Then
174: commit;
175: ELSE
176: rollback;
177: END IF;

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

178:
179: END Delete_configuration_auto;
180:
181: Procedure Copy_Configuration( p_api_version_number IN NUMBER,
182: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
183: p_commit IN VARCHAR2 := FND_API.G_FALSE,
184: p_config_header_id IN NUMBER,
185: p_config_revision_num IN NUMBER,
186: p_copy_mode IN VARCHAR2,

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

179: END Delete_configuration_auto;
180:
181: Procedure Copy_Configuration( p_api_version_number IN NUMBER,
182: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
183: p_commit IN VARCHAR2 := FND_API.G_FALSE,
184: p_config_header_id IN NUMBER,
185: p_config_revision_num IN NUMBER,
186: p_copy_mode IN VARCHAR2,
187: p_handle_deleted_flag IN VARCHAR2 := NULL,

Line 189: p_autonomous_flag IN VARCHAR2 := FND_API.G_FALSE,

185: p_config_revision_num IN NUMBER,
186: p_copy_mode IN VARCHAR2,
187: p_handle_deleted_flag IN VARCHAR2 := NULL,
188: p_new_name IN VARCHAR2 := NULL,
189: p_autonomous_flag IN VARCHAR2 := FND_API.G_FALSE,
190: x_config_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
191: x_config_revision_num OUT NOCOPY /* file.sql.39 change */ NUMBER,
192: x_orig_item_id_tbl OUT NOCOPY CZ_API_PUB.number_tbl_type,
193: x_new_item_id_tbl OUT NOCOPY CZ_API_PUB.number_tbl_type,

Line 225: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

221: IF aso_debug_pub.g_debug_flag = 'Y' THEN
222: aso_debug_pub.add('ASO_CFG_INT: Begin Copy_Configuration');
223: END IF;
224:
225: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
226: p_api_version_number,
227: l_api_name,
228: G_PKG_NAME) THEN
229:

Line 230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

226: p_api_version_number,
227: l_api_name,
228: G_PKG_NAME) THEN
229:
230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
231:
232:
233: END IF;
234:

Line 239: IF FND_API.to_Boolean( p_init_msg_list ) THEN

235: IF aso_debug_pub.g_debug_flag = 'Y' THEN
236: aso_debug_pub.add('copy_configuration: p_init_msg_list: '|| p_init_msg_list);
237: END IF;
238:
239: IF FND_API.to_Boolean( p_init_msg_list ) THEN
240: FND_MSG_PUB.initialize;
241: END IF;
242:
243: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 243: x_return_status := FND_API.G_RET_STS_SUCCESS;

239: IF FND_API.to_Boolean( p_init_msg_list ) THEN
240: FND_MSG_PUB.initialize;
241: END IF;
242:
243: x_return_status := FND_API.G_RET_STS_SUCCESS;
244:
245: IF aso_debug_pub.g_debug_flag = 'Y' THEN
246:
247: aso_debug_pub.add('copy_configuration: p_config_header_id: '|| p_config_header_id);

Line 280: IF p_autonomous_flag = fnd_api.g_true THEN

276: IF aso_debug_pub.g_debug_flag = 'Y' THEN
277: aso_debug_pub.add('Before call to cz_config_api_pub.copy_configuration');
278: END IF;
279:
280: IF p_autonomous_flag = fnd_api.g_true THEN
281:
282: cz_config_api_pub.copy_configuration_auto( p_api_version => 1.0,
283: p_config_hdr_id => p_config_header_id,
284: p_config_rev_nbr => l_config_rev_nbr,

Line 326: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

322: END IF;
323:
324: END IF;
325:
326: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
327:
328:
329: RAISE FND_API.G_EXC_ERROR;
330:

Line 329: RAISE FND_API.G_EXC_ERROR;

325:
326: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
327:
328:
329: RAISE FND_API.G_EXC_ERROR;
330:
331: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
332:
333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 331: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

327:
328:
329: RAISE FND_API.G_EXC_ERROR;
330:
331: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
332:
333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
334:
335: END IF;

Line 333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

329: RAISE FND_API.G_EXC_ERROR;
330:
331: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
332:
333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
334:
335: END IF;
336:
337: IF FND_API.to_Boolean( p_commit ) THEN

Line 337: IF FND_API.to_Boolean( p_commit ) THEN

333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
334:
335: END IF;
336:
337: IF FND_API.to_Boolean( p_commit ) THEN
338: COMMIT WORK;
339: END IF;
340:
341:

Line 348: WHEN FND_API.G_EXC_ERROR THEN

344:
345:
346: EXCEPTION
347:
348: WHEN FND_API.G_EXC_ERROR THEN
349:
350: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
351: P_PKG_NAME => G_PKG_NAME,
352: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

354: X_MSG_COUNT => X_MSG_COUNT,
355: X_MSG_DATA => X_MSG_DATA,
356: X_RETURN_STATUS => X_RETURN_STATUS);
357:
358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
359:
360: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
361: P_PKG_NAME => G_PKG_NAME,
362: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

Line 439: P_Init_Msg_List => FND_API.G_FALSE,

435: l_qte_line_dtl_tbl(1).config_revision_num := p_to_config_rev_nbr ;
436:
437: ASO_QUOTE_LINES_PVT.Update_Quote_Line(
438: P_Api_Version_Number => l_api_version_number ,
439: P_Init_Msg_List => FND_API.G_FALSE,
440: P_Commit => FND_API.G_FALSE,
441: P_Validation_Level => FND_API.G_VALID_LEVEL_NONE ,
442: P_Qte_Line_Rec => l_qte_line_REC,
443: P_Qte_Line_Dtl_Tbl => l_qte_line_dtl_TBL,

Line 440: P_Commit => FND_API.G_FALSE,

436:
437: ASO_QUOTE_LINES_PVT.Update_Quote_Line(
438: P_Api_Version_Number => l_api_version_number ,
439: P_Init_Msg_List => FND_API.G_FALSE,
440: P_Commit => FND_API.G_FALSE,
441: P_Validation_Level => FND_API.G_VALID_LEVEL_NONE ,
442: P_Qte_Line_Rec => l_qte_line_REC,
443: P_Qte_Line_Dtl_Tbl => l_qte_line_dtl_TBL,
444: P_Update_Header_Flag => FND_API.G_FALSE ,

Line 441: P_Validation_Level => FND_API.G_VALID_LEVEL_NONE ,

437: ASO_QUOTE_LINES_PVT.Update_Quote_Line(
438: P_Api_Version_Number => l_api_version_number ,
439: P_Init_Msg_List => FND_API.G_FALSE,
440: P_Commit => FND_API.G_FALSE,
441: P_Validation_Level => FND_API.G_VALID_LEVEL_NONE ,
442: P_Qte_Line_Rec => l_qte_line_REC,
443: P_Qte_Line_Dtl_Tbl => l_qte_line_dtl_TBL,
444: P_Update_Header_Flag => FND_API.G_FALSE ,
445: X_Qte_Line_Rec => x_Qte_Line_Rec,

Line 444: P_Update_Header_Flag => FND_API.G_FALSE ,

440: P_Commit => FND_API.G_FALSE,
441: P_Validation_Level => FND_API.G_VALID_LEVEL_NONE ,
442: P_Qte_Line_Rec => l_qte_line_REC,
443: P_Qte_Line_Dtl_Tbl => l_qte_line_dtl_TBL,
444: P_Update_Header_Flag => FND_API.G_FALSE ,
445: X_Qte_Line_Rec => x_Qte_Line_Rec,
446: X_payment_tbl => x_payment_tbl,
447: X_price_adj_tbl => x_price_adj_tbl ,
448: X_Qte_Line_Dtl_Tbl => x_Qte_Line_Dtl_Tbl ,

Line 462: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

458: X_Msg_Count => x_msg_count,
459: X_Msg_Data => x_msg_data );
460:
461: --check for success
462: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
464: END IF;
465: End Loop;
466:

Line 463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

459: X_Msg_Data => x_msg_data );
460:
461: --check for success
462: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
464: END IF;
465: End Loop;
466:
467: End Update_Revision_Num ;

Line 490: l_return_status := FND_API.G_RET_STS_SUCCESS;

486: where related_quote_line_id = p_quote_line_id;
487:
488:
489: BEGIN
490: l_return_status := FND_API.G_RET_STS_SUCCESS;
491: If G_rtln_tbl.First IS NULL Then
492: return;
493: end if;
494:

Line 512: P_Init_Msg_List => FND_API.G_FALSE,

508:
509: If G_rtln_tbl(i).created_flag = 'N' Then
510: ASO_LINE_RLTSHIP_PVT.Create_line_rltship(
511: P_Api_Version_Number => l_api_version_number ,
512: P_Init_Msg_List => FND_API.G_FALSE,
513: P_Commit => FND_API.G_FALSE,
514: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
515: P_LINE_RLTSHIP_Rec => l_line_rltship_rec ,
516: X_LINE_RELATIONSHIP_ID => l_line_relationship_id ,

Line 513: P_Commit => FND_API.G_FALSE,

509: If G_rtln_tbl(i).created_flag = 'N' Then
510: ASO_LINE_RLTSHIP_PVT.Create_line_rltship(
511: P_Api_Version_Number => l_api_version_number ,
512: P_Init_Msg_List => FND_API.G_FALSE,
513: P_Commit => FND_API.G_FALSE,
514: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
515: P_LINE_RLTSHIP_Rec => l_line_rltship_rec ,
516: X_LINE_RELATIONSHIP_ID => l_line_relationship_id ,
517: X_Return_Status => x_return_status ,

Line 514: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

510: ASO_LINE_RLTSHIP_PVT.Create_line_rltship(
511: P_Api_Version_Number => l_api_version_number ,
512: P_Init_Msg_List => FND_API.G_FALSE,
513: P_Commit => FND_API.G_FALSE,
514: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
515: P_LINE_RLTSHIP_Rec => l_line_rltship_rec ,
516: X_LINE_RELATIONSHIP_ID => l_line_relationship_id ,
517: X_Return_Status => x_return_status ,
518: X_Msg_Count => x_msg_count,

Line 523: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

519: X_Msg_Data => x_msg_data );
520:
521: l_return_status := x_return_status;
522:
523: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
525: END IF;
526: End If;
527:

Line 524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

520:
521: l_return_status := x_return_status;
522:
523: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
525: END IF;
526: End If;
527:
528: G_rtln_tbl(i).included_flag := 'Y';

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

633:
634:
635: PROCEDURE Get_config_details(
636: p_api_version_number IN NUMBER,
637: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
638: p_commit IN VARCHAR2 := FND_API.G_FALSE,
639: p_control_rec IN aso_quote_pub.control_rec_type
640: := aso_quote_pub.G_MISS_control_rec,
641: p_qte_header_rec IN aso_quote_pub.qte_header_rec_type,

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

634:
635: PROCEDURE Get_config_details(
636: p_api_version_number IN NUMBER,
637: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
638: p_commit IN VARCHAR2 := FND_API.G_FALSE,
639: p_control_rec IN aso_quote_pub.control_rec_type
640: := aso_quote_pub.G_MISS_control_rec,
641: p_qte_header_rec IN aso_quote_pub.qte_header_rec_type,
642: p_model_line_rec IN aso_quote_pub.qte_line_rec_type,

Line 860: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

856: aso_debug_pub.add('p_config_rec.complete_configuration_flag: '|| p_config_rec.complete_configuration_flag);
857: END IF;
858:
859: -- Standard call to check for call compatibility.
860: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
861: p_api_version_number,
862: l_api_name,
863: G_PKG_NAME) THEN
864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

860: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
861: p_api_version_number,
862: l_api_name,
863: G_PKG_NAME) THEN
864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
865: END IF;
866:
867: -- Initialize message list if p_init_msg_list is set to TRUE.
868: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 868: IF FND_API.to_Boolean( p_init_msg_list ) THEN

864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
865: END IF;
866:
867: -- Initialize message list if p_init_msg_list is set to TRUE.
868: IF FND_API.to_Boolean( p_init_msg_list ) THEN
869: FND_MSG_PUB.initialize;
870: END IF;
871:
872: -- Set return status to success

Line 873: x_return_status := FND_API.G_RET_STS_SUCCESS;

869: FND_MSG_PUB.initialize;
870: END IF;
871:
872: -- Set return status to success
873: x_return_status := FND_API.G_RET_STS_SUCCESS;
874:
875:
876: --Procedure added by Anoop Rajan on 30/09/2005 to print login details
877: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 913: RAISE FND_API.G_EXC_ERROR;

909: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
910: FND_MESSAGE.Set_Name('ASO', 'ASO_DIFFERENT_CONFIG_EXISTS');
911: FND_MSG_PUB.ADD;
912: END IF;
913: RAISE FND_API.G_EXC_ERROR;
914:
915: END IF;
916:
917: -- check whether the config_header_id+config_revision_num is already

Line 939: RAISE FND_API.G_EXC_ERROR;

935: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
936: FND_MESSAGE.Set_Name('ASO', 'ASO_API_CONFIG_EXISTS');
937: FND_MSG_PUB.ADD;
938: END IF;
939: RAISE FND_API.G_EXC_ERROR;
940:
941: END IF;
942:
943: --check if the quote has been modified by someone else

Line 955: if (p_qte_header_rec.last_update_date is not null) and (p_qte_header_rec.last_update_date <> fnd_api.g_miss_date) then

951: aso_debug_pub.add('Get_config_details: l_last_update_date: ' || to_char(l_last_update_date, 'DD-MON-YYYY HH24:MI:SS'));
952: aso_debug_pub.add('ASO_CFG_INT: Get_config_details: l_quote_type: ' || l_quote_type);
953: END IF;
954:
955: if (p_qte_header_rec.last_update_date is not null) and (p_qte_header_rec.last_update_date <> fnd_api.g_miss_date) then
956:
957: If (l_last_update_date <> p_qte_header_rec.last_update_date) Then
958:
959: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 964: raise FND_API.G_EXC_ERROR;

960: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');
961: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
962: FND_MSG_PUB.ADD;
963: END IF;
964: raise FND_API.G_EXC_ERROR;
965:
966: End if;
967:
968: end if;

Line 979: IF ((p_config_rec.config_header_id <> FND_API.G_Miss_num AND

975: --if yes update all the previous selected options to the current
976: --revision number.This is necessary as the current revision number
977: --will not be the same as in aso_quote_line_details.
978:
979: IF ((p_config_rec.config_header_id <> FND_API.G_Miss_num AND
980: p_config_rec.config_revision_num <> FND_API.G_Miss_Num) AND
981: (p_config_rec.config_header_id IS NOT NULL AND
982: p_config_rec.config_revision_num IS NOT NULL)) AND
983: (p_config_rec.config_header_id <> p_config_hdr_id OR

Line 980: p_config_rec.config_revision_num <> FND_API.G_Miss_Num) AND

976: --revision number.This is necessary as the current revision number
977: --will not be the same as in aso_quote_line_details.
978:
979: IF ((p_config_rec.config_header_id <> FND_API.G_Miss_num AND
980: p_config_rec.config_revision_num <> FND_API.G_Miss_Num) AND
981: (p_config_rec.config_header_id IS NOT NULL AND
982: p_config_rec.config_revision_num IS NOT NULL)) AND
983: (p_config_rec.config_header_id <> p_config_hdr_id OR
984: p_config_rec.config_revision_num <> p_config_rev_nbr) THEN

Line 1325: l_qte_header_rec.CALL_BATCH_VALIDATION_FLAG := FND_API.G_FALSE;

1321: --Populate quote header record
1322:
1323: l_qte_header_rec := p_qte_header_rec;
1324: l_qte_header_rec.last_update_date := l_last_update_date;
1325: l_qte_header_rec.CALL_BATCH_VALIDATION_FLAG := FND_API.G_FALSE;
1326:
1327: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1328:
1329: aso_debug_pub.add( 'Get_Config_details: Before call to Update Quote table count');

Line 1337: p_init_msg_list => FND_API.G_FALSE,

1333: END IF;
1334:
1335: ASO_QUOTE_PUB.Update_Quote(
1336: p_api_version_number => 1.0,
1337: p_init_msg_list => FND_API.G_FALSE,
1338: p_commit => FND_API.G_FALSE,
1339: p_control_rec => p_control_rec,
1340: p_qte_header_rec => l_qte_header_rec,
1341: p_hd_tax_detail_tbl => l_hd_tax_detail_tbl,

Line 1338: p_commit => FND_API.G_FALSE,

1334:
1335: ASO_QUOTE_PUB.Update_Quote(
1336: p_api_version_number => 1.0,
1337: p_init_msg_list => FND_API.G_FALSE,
1338: p_commit => FND_API.G_FALSE,
1339: p_control_rec => p_control_rec,
1340: p_qte_header_rec => l_qte_header_rec,
1341: p_hd_tax_detail_tbl => l_hd_tax_detail_tbl,
1342: --P_hd_Shipment_Tbl => l_Shipment_tbl,

Line 1373: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1369: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1370: aso_debug_pub.add('Get_config_details: After call to Update_quote x_Return_Status: ' || x_Return_Status);
1371: END IF;
1372:
1373: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1374:
1375: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1376: aso_debug_pub.add('Get_config_details: Before deleting the previous version from CZ schema.');
1377: END IF;

Line 1379: IF ((p_config_rec.config_header_id <> FND_API.G_Miss_num AND

1375: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1376: aso_debug_pub.add('Get_config_details: Before deleting the previous version from CZ schema.');
1377: END IF;
1378:
1379: IF ((p_config_rec.config_header_id <> FND_API.G_Miss_num AND
1380: p_config_rec.config_revision_num <> FND_API.G_Miss_Num) AND
1381: (p_config_rec.config_header_id IS NOT NULL AND
1382: p_config_rec.config_revision_num IS NOT NULL)) AND
1383: (p_config_rec.config_header_id <> p_config_hdr_id OR

Line 1380: p_config_rec.config_revision_num <> FND_API.G_Miss_Num) AND

1376: aso_debug_pub.add('Get_config_details: Before deleting the previous version from CZ schema.');
1377: END IF;
1378:
1379: IF ((p_config_rec.config_header_id <> FND_API.G_Miss_num AND
1380: p_config_rec.config_revision_num <> FND_API.G_Miss_Num) AND
1381: (p_config_rec.config_header_id IS NOT NULL AND
1382: p_config_rec.config_revision_num IS NOT NULL)) AND
1383: (p_config_rec.config_header_id <> p_config_hdr_id OR
1384: p_config_rec.config_revision_num <> p_config_rev_nbr) THEN

Line 1391: P_INIT_MSG_LIST => FND_API.G_FALSE,

1387: aso_debug_pub.add('Get_config_details: A previous version exist for this configuration so deleting it from CZ');
1388: END IF;
1389:
1390: ASO_CFG_INT.DELETE_CONFIGURATION( P_API_VERSION_NUMBER => 1.0,
1391: P_INIT_MSG_LIST => FND_API.G_FALSE,
1392: P_CONFIG_HDR_ID => p_config_rec.config_header_id,
1393: P_CONFIG_REV_NBR => p_config_rec.config_revision_num,
1394: X_RETURN_STATUS => lx_return_status,
1395: X_MSG_COUNT => x_msg_count,

Line 1402: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1398: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1399: aso_debug_pub.add('After call to ASO_CFG_INT.DELETE_CONFIGURATION: x_Return_Status: ' || lx_Return_Status);
1400: END IF;
1401:
1402: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1403:
1404: x_return_status := lx_return_status;
1405: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1406: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');

Line 1411: RAISE FND_API.G_EXC_ERROR;

1407: FND_MESSAGE.Set_Token('OBJECT', 'CONFIGURATION', FALSE);
1408: FND_MSG_PUB.ADD;
1409: END IF;
1410:
1411: RAISE FND_API.G_EXC_ERROR;
1412:
1413: END IF;
1414:
1415: END IF;

Line 1417: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

1413: END IF;
1414:
1415: END IF;
1416:
1417: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1418: RAISE FND_API.G_EXC_ERROR;
1419:
1420: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1418: RAISE FND_API.G_EXC_ERROR;

1414:
1415: END IF;
1416:
1417: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1418: RAISE FND_API.G_EXC_ERROR;
1419:
1420: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1422:

Line 1420: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1416:
1417: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1418: RAISE FND_API.G_EXC_ERROR;
1419:
1420: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1422:
1423: END IF;
1424:

Line 1421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1417: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1418: RAISE FND_API.G_EXC_ERROR;
1419:
1420: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1422:
1423: END IF;
1424:
1425: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 1488: IF x_return_status = FND_API.G_RET_STS_ERROR then

1484: END IF;
1485:
1486: -- Check return status from the above procedure call
1487:
1488: IF x_return_status = FND_API.G_RET_STS_ERROR then
1489: raise FND_API.G_EXC_ERROR;
1490: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1491: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1492: END IF;

Line 1489: raise FND_API.G_EXC_ERROR;

1485:
1486: -- Check return status from the above procedure call
1487:
1488: IF x_return_status = FND_API.G_RET_STS_ERROR then
1489: raise FND_API.G_EXC_ERROR;
1490: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1491: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1492: END IF;
1493:

Line 1490: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

1486: -- Check return status from the above procedure call
1487:
1488: IF x_return_status = FND_API.G_RET_STS_ERROR then
1489: raise FND_API.G_EXC_ERROR;
1490: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1491: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1492: END IF;
1493:
1494: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 1491: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1487:
1488: IF x_return_status = FND_API.G_RET_STS_ERROR then
1489: raise FND_API.G_EXC_ERROR;
1490: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1491: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1492: END IF;
1493:
1494: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1495: aso_debug_pub.add('Get_config_details: Before deleting the previous version from CZ schema.');

Line 1498: IF ((p_config_rec.config_header_id <> FND_API.G_Miss_num AND

1494: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1495: aso_debug_pub.add('Get_config_details: Before deleting the previous version from CZ schema.');
1496: END IF;
1497:
1498: IF ((p_config_rec.config_header_id <> FND_API.G_Miss_num AND
1499: p_config_rec.config_revision_num <> FND_API.G_Miss_Num) AND
1500: (p_config_rec.config_header_id IS NOT NULL AND
1501: p_config_rec.config_revision_num IS NOT NULL)) AND
1502: (p_config_rec.config_header_id <> p_config_hdr_id OR

Line 1499: p_config_rec.config_revision_num <> FND_API.G_Miss_Num) AND

1495: aso_debug_pub.add('Get_config_details: Before deleting the previous version from CZ schema.');
1496: END IF;
1497:
1498: IF ((p_config_rec.config_header_id <> FND_API.G_Miss_num AND
1499: p_config_rec.config_revision_num <> FND_API.G_Miss_Num) AND
1500: (p_config_rec.config_header_id IS NOT NULL AND
1501: p_config_rec.config_revision_num IS NOT NULL)) AND
1502: (p_config_rec.config_header_id <> p_config_hdr_id OR
1503: p_config_rec.config_revision_num <> p_config_rev_nbr) THEN

Line 1516: P_INIT_MSG_LIST => FND_API.G_FALSE,

1512: aso_debug_pub.add('Get_config_details: A previous version exist for this configuration so deleting it from CZ');
1513: END IF;
1514:
1515: ASO_CFG_INT.DELETE_CONFIGURATION( P_API_VERSION_NUMBER => 1.0,
1516: P_INIT_MSG_LIST => FND_API.G_FALSE,
1517: P_CONFIG_HDR_ID => p_config_rec.config_header_id,
1518: P_CONFIG_REV_NBR => p_config_rec.config_revision_num,
1519: X_RETURN_STATUS => lx_return_status,
1520: X_MSG_COUNT => x_msg_count,

Line 1527: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1523: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1524: aso_debug_pub.add('After call to ASO_CFG_INT.DELETE_CONFIGURATION: x_Return_Status: ' || lx_Return_Status);
1525: END IF;
1526:
1527: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1528:
1529: x_return_status := lx_return_status;
1530: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1531: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');

Line 1536: RAISE FND_API.G_EXC_ERROR;

1532: FND_MESSAGE.Set_Token('OBJECT', 'CONFIGURATION', FALSE);
1533: FND_MSG_PUB.ADD;
1534: END IF;
1535:
1536: RAISE FND_API.G_EXC_ERROR;
1537:
1538: END IF;
1539:
1540: else

Line 1552: WHEN FND_API.G_EXC_ERROR THEN

1548: END IF;
1549:
1550: EXCEPTION
1551:
1552: WHEN FND_API.G_EXC_ERROR THEN
1553:
1554: open c_config_exist_in_cz(p_config_hdr_id, p_config_rev_nbr);
1555: fetch c_config_exist_in_cz into l_old_config_hdr_id;
1556:

Line 1566: P_INIT_MSG_LIST => FND_API.G_FALSE,

1562: aso_debug_pub.add('Get_config_details: A previous version exist for this configuration so deleting it from CZ');
1563: END IF;
1564:
1565: ASO_CFG_INT.DELETE_CONFIGURATION_AUTO( P_API_VERSION_NUMBER => 1.0,
1566: P_INIT_MSG_LIST => FND_API.G_FALSE,
1567: P_CONFIG_HDR_ID => p_config_hdr_id,
1568: P_CONFIG_REV_NBR => p_config_rev_nbr,
1569: X_RETURN_STATUS => lx_return_status,
1570: X_MSG_COUNT => x_msg_count,

Line 1577: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1573: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1574: aso_debug_pub.add('After call to ASO_CFG_INT.DELETE_CONFIGURATION: x_Return_Status: ' || lx_Return_Status);
1575: END IF;
1576:
1577: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1578:
1579: x_return_status := lx_return_status;
1580: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1581: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');

Line 1586: RAISE FND_API.G_EXC_ERROR;

1582: FND_MESSAGE.Set_Token('OBJECT', 'CONFIGURATION', FALSE);
1583: FND_MSG_PUB.ADD;
1584: END IF;
1585:
1586: RAISE FND_API.G_EXC_ERROR;
1587:
1588: END IF;
1589:
1590: else

Line 1603: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1599: ,X_MSG_COUNT => X_MSG_COUNT
1600: ,X_MSG_DATA => X_MSG_DATA
1601: ,X_RETURN_STATUS => X_RETURN_STATUS);
1602:
1603: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1604:
1605: open c_config_exist_in_cz(p_config_hdr_id, p_config_rev_nbr);
1606: fetch c_config_exist_in_cz into l_old_config_hdr_id;
1607:

Line 1617: P_INIT_MSG_LIST => FND_API.G_FALSE,

1613: aso_debug_pub.add('Get_config_details: A previous version exist for this configuration so deleting it from CZ');
1614: END IF;
1615:
1616: ASO_CFG_INT.DELETE_CONFIGURATION_AUTO( P_API_VERSION_NUMBER => 1.0,
1617: P_INIT_MSG_LIST => FND_API.G_FALSE,
1618: P_CONFIG_HDR_ID => p_config_hdr_id,
1619: P_CONFIG_REV_NBR => p_config_rev_nbr,
1620: X_RETURN_STATUS => lx_return_status,
1621: X_MSG_COUNT => x_msg_count,

Line 1628: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1624: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1625: aso_debug_pub.add('After call to ASO_CFG_INT.DELETE_CONFIGURATION: x_Return_Status: ' || lx_Return_Status);
1626: END IF;
1627:
1628: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1629:
1630: x_return_status := lx_return_status;
1631: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1632: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');

Line 1637: RAISE FND_API.G_EXC_ERROR;

1633: FND_MESSAGE.Set_Token('OBJECT', 'CONFIGURATION', FALSE);
1634: FND_MSG_PUB.ADD;
1635: END IF;
1636:
1637: RAISE FND_API.G_EXC_ERROR;
1638:
1639: END IF;
1640:
1641: else

Line 1668: P_INIT_MSG_LIST => FND_API.G_FALSE,

1664: aso_debug_pub.add('Get_config_details: A previous version exist for this configuration so deleting it from CZ');
1665: END IF;
1666:
1667: ASO_CFG_INT.DELETE_CONFIGURATION_AUTO( P_API_VERSION_NUMBER => 1.0,
1668: P_INIT_MSG_LIST => FND_API.G_FALSE,
1669: P_CONFIG_HDR_ID => p_config_hdr_id,
1670: P_CONFIG_REV_NBR => p_config_rev_nbr,
1671: X_RETURN_STATUS => lx_return_status,
1672: X_MSG_COUNT => x_msg_count,

Line 1679: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1675: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1676: aso_debug_pub.add('After call to ASO_CFG_INT.DELETE_CONFIGURATION: x_Return_Status: ' || lx_Return_Status);
1677: END IF;
1678:
1679: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1680:
1681: x_return_status := lx_return_status;
1682: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1683: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');

Line 1688: RAISE FND_API.G_EXC_ERROR;

1684: FND_MESSAGE.Set_Token('OBJECT', 'CONFIGURATION', FALSE);
1685: FND_MSG_PUB.ADD;
1686: END IF;
1687:
1688: RAISE FND_API.G_EXC_ERROR;
1689:
1690: END IF;
1691:
1692: else

Line 2147: P_Init_Msg_List => FND_API.G_TRUE,

2143: END IF;
2144:
2145: ASO_PRICING_INT.Pricing_Order(
2146: P_Api_Version_Number => 1.0,
2147: P_Init_Msg_List => FND_API.G_TRUE,
2148: P_Commit => FND_API.G_FALSE,
2149: p_control_rec => l_pricing_control_rec,
2150: p_qte_header_rec => l_qte_header_rec,
2151: p_hd_shipment_rec => l_hd_shipment_rec,

Line 2148: P_Commit => FND_API.G_FALSE,

2144:
2145: ASO_PRICING_INT.Pricing_Order(
2146: P_Api_Version_Number => 1.0,
2147: P_Init_Msg_List => FND_API.G_TRUE,
2148: P_Commit => FND_API.G_FALSE,
2149: p_control_rec => l_pricing_control_rec,
2150: p_qte_header_rec => l_qte_header_rec,
2151: p_hd_shipment_rec => l_hd_shipment_rec,
2152: p_hd_price_attr_tbl => l_hd_price_attr_tbl,

Line 2180: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2176: aso_debug_pub.add('PRICING CALLBACK: lx_qte_line_tbl.count: '|| lx_qte_line_tbl.count);
2177:
2178: END IF;
2179:
2180: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2181:
2182: fnd_msg_pub.count_and_get( p_encoded => 'F',
2183: p_count => lx_msg_count,
2184: p_data => lx_msg_data);

Line 2215: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS AND p_price_type <> 'LIST' THEN

2211: END IF;
2212:
2213: -- set the error message in the model line msg_data field of cz_pricing_structure
2214:
2215: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS AND p_price_type <> 'LIST' THEN
2216:
2217: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2218: aso_debug_pub.add('PRICING CALLBACK: Inside IF condition lx_return_status <> FND_API.G_RET_STS_SUCCESS');
2219: END IF;

Line 2218: aso_debug_pub.add('PRICING CALLBACK: Inside IF condition lx_return_status <> FND_API.G_RET_STS_SUCCESS');

2214:
2215: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS AND p_price_type <> 'LIST' THEN
2216:
2217: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2218: aso_debug_pub.add('PRICING CALLBACK: Inside IF condition lx_return_status <> FND_API.G_RET_STS_SUCCESS');
2219: END IF;
2220:
2221: UPDATE CZ_PRICING_STRUCTURES
2222: SET MSG_DATA = l_mymsg

Line 2274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2270: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2271: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: Inside When Others Exception for select sum(selling_price)');
2272: END IF;
2273:
2274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2275:
2276: END;
2277:
2278:

Line 2456: x_return_status := FND_API.G_RET_STS_SUCCESS;

2452: aso_debug_pub.add('Create_hdr_xml Begins.', 1, 'Y');
2453: END IF;
2454:
2455: --Initialize API return status to SUCCESS
2456: x_return_status := FND_API.G_RET_STS_SUCCESS;
2457:
2458: l_model_line_rec := aso_utility_pvt.Query_Qte_Line_Row( P_Qte_Line_Id => p_model_line_id );
2459:
2460: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 2626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2622: EXCEPTION
2623:
2624: when others then
2625:
2626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2627:
2628: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2629: aso_debug_pub.add('Create_hdr_xml: Inside When Others Exception: x_return_status: '||x_return_status, 1, 'N');
2630: END IF;

Line 2703: l_return_status := FND_API.G_RET_STS_SUCCESS;

2699: aso_debug_pub.add('ASO_CFG_INT: Send_input_xml Begin.', 1, 'Y');
2700: END IF;
2701:
2702: --Initialize API return status to SUCCESS
2703: l_return_status := FND_API.G_RET_STS_SUCCESS;
2704:
2705: l_xml_hdr := p_xml_hdr;
2706:
2707: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 2769: l_return_status := FND_API.G_RET_STS_ERROR;

2765:
2766: FND_MESSAGE.Set_Name('ASO', 'ASO_BATCH_VALIDATE');
2767: FND_MESSAGE.Set_token('ERR_TEXT' , 'Error returned from CZ_CF_API.Validate, validation_status <> 0' );
2768: FND_MSG_PUB.ADD;
2769: l_return_status := FND_API.G_RET_STS_ERROR;
2770: END IF;
2771:
2772: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2773: aso_debug_pub.add('Send_input_xml: After call to CZ_CF_API.Validate: l_html_pieces.COUNT: '||l_html_pieces.COUNT);

Line 2785: l_return_status := FND_API.G_RET_STS_ERROR;

2781:
2782: FND_MESSAGE.Set_Name('ASO', 'ASO_BATCH_VALIDATE');
2783: FND_MESSAGE.Set_token('ERR_TEXT' , 'Error returned from CZ_CF_API.Validate, config_messages: l_html_pieces.COUNT <= 0' );
2784: FND_MSG_PUB.ADD;
2785: l_return_status := FND_API.G_RET_STS_ERROR;
2786:
2787: END IF;
2788:
2789: l_index := l_html_pieces.FIRST;

Line 2825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2821: EXCEPTION
2822:
2823: WHEN OTHERS THEN
2824:
2825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2826:
2827: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2828: aso_debug_pub.add('Send_input_xml: Inside When Others Exception:', 1, 'N');
2829: END IF;

Line 2884: l_return_status := FND_API.G_RET_STS_SUCCESS;

2880: aso_debug_pub.add('ASO_CFG_INT: Parse_output_xml Begin.', 1, 'Y');
2881: END IF;
2882:
2883: --Initialize API return status to SUCCESS
2884: l_return_status := FND_API.G_RET_STS_SUCCESS;
2885:
2886: l_config_header_id := to_number(substr(p_xml_msg,(instr(p_xml_msg, '',1,1)+18),
2887: (instr(p_xml_msg,'',1,1) -
2888: (instr(p_xml_msg, '',1,1)+18))));

Line 2936: l_return_status := FND_API.G_RET_STS_ERROR;

2932: i := i + 240;
2933:
2934: End Loop;
2935:
2936: l_return_status := FND_API.G_RET_STS_ERROR;
2937:
2938: END IF;
2939:
2940:

Line 2996: l_return_status := FND_API.G_RET_STS_ERROR;

2992: END IF;
2993:
2994: END LOOP;
2995:
2996: l_return_status := FND_API.G_RET_STS_ERROR;
2997:
2998: END IF;
2999:
3000: -- if everything ok, set return values

Line 3018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3014: EXCEPTION
3015:
3016: WHEN OTHERS THEN
3017:
3018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3019:
3020: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3021: aso_Debug_Pub.Add( 'Parse_Output_xml: In WHEN OTHERS exception ', 1, 'N');
3022: END IF;

Line 3043: (P_Api_Version_Number IN NUMBER := FND_API.G_MISS_NUM,

3039: , ASO_QUOTE_LINE_DETAILS and ASO_LINE_RELATIONSHIPS
3040: -----------------------------------------------------------------------*/
3041:
3042: PROCEDURE Validate_Configuration
3043: (P_Api_Version_Number IN NUMBER := FND_API.G_MISS_NUM,
3044: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3045: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3046: p_control_rec IN aso_quote_pub.control_rec_type
3047: := aso_quote_pub.G_MISS_control_rec,

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

3040: -----------------------------------------------------------------------*/
3041:
3042: PROCEDURE Validate_Configuration
3043: (P_Api_Version_Number IN NUMBER := FND_API.G_MISS_NUM,
3044: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3045: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3046: p_control_rec IN aso_quote_pub.control_rec_type
3047: := aso_quote_pub.G_MISS_control_rec,
3048: P_model_line_id IN NUMBER,

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

3041:
3042: PROCEDURE Validate_Configuration
3043: (P_Api_Version_Number IN NUMBER := FND_API.G_MISS_NUM,
3044: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3045: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3046: p_control_rec IN aso_quote_pub.control_rec_type
3047: := aso_quote_pub.G_MISS_control_rec,
3048: P_model_line_id IN NUMBER,
3049: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type

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

3084: -- upgrade stuff
3085: l_upgraded_flag VARCHAR2(1);
3086:
3087: -- cz's delete return value
3088: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3089: l_delete_config VARCHAR2(1) := fnd_api.g_false;
3090: l_old_config_hdr_id NUMBER;
3091:
3092: BEGIN

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

3085: l_upgraded_flag VARCHAR2(1);
3086:
3087: -- cz's delete return value
3088: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3089: l_delete_config VARCHAR2(1) := fnd_api.g_false;
3090: l_old_config_hdr_id NUMBER;
3091:
3092: BEGIN
3093: -- Standard Start of API savepoint

Line 3096: l_return_status := FND_API.G_RET_STS_SUCCESS;

3092: BEGIN
3093: -- Standard Start of API savepoint
3094: -- SAVEPOINT VALIDATE_CONFIGURATION_INT;
3095:
3096: l_return_status := FND_API.G_RET_STS_SUCCESS;
3097:
3098: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3099: aso_debug_pub.add('ASO_CFG_INT: Validate_Configuration Begins', 1, 'Y');
3100: END IF;

Line 3102: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

3098: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3099: aso_debug_pub.add('ASO_CFG_INT: Validate_Configuration Begins', 1, 'Y');
3100: END IF;
3101:
3102: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3103: p_api_version_number,
3104: l_api_name,
3105: G_PKG_NAME) THEN
3106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3102: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3103: p_api_version_number,
3104: l_api_name,
3105: G_PKG_NAME) THEN
3106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3107: END IF;
3108:
3109: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3110: FND_MSG_PUB.initialize;

Line 3109: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3105: G_PKG_NAME) THEN
3106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3107: END IF;
3108:
3109: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3110: FND_MSG_PUB.initialize;
3111: END IF;
3112:
3113: -- Get model line info

Line 3133: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

3129: aso_debug_pub.add('Validate_Configuration: After call to Create_hdr_xml Length of l_xml_hdr : '||length(l_xml_hdr));
3130:
3131: END IF;
3132:
3133: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3134:
3135: -- Call Send_Input_Xml to call CZ batch validate procedure and get the output XML message
3136:
3137: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 3159: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3155:
3156:
3157: -- extract data from xml message.
3158:
3159: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3160: l_delete_config := fnd_api.g_true;
3161: END IF;
3162:
3163: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 3160: l_delete_config := fnd_api.g_true;

3156:
3157: -- extract data from xml message.
3158:
3159: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3160: l_delete_config := fnd_api.g_true;
3161: END IF;
3162:
3163: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3164: aso_debug_pub.add('Validate_Configuration: Before Call to Parse_Output_xml',1,'N');

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

3182: END IF;
3183:
3184: END IF;
3185:
3186: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) and (l_delete_config = fnd_api.g_false) THEN
3187:
3188: -- Call GET_CONFIG_DETAILS to update the existing configuration
3189: -- Set the Call_batch_validation_flag to FND_API.G_FALSE to avoid recursive call to update_quote
3190:

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

3185:
3186: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) and (l_delete_config = fnd_api.g_false) THEN
3187:
3188: -- Call GET_CONFIG_DETAILS to update the existing configuration
3189: -- Set the Call_batch_validation_flag to FND_API.G_FALSE to avoid recursive call to update_quote
3190:
3191: l_model_line_dtl_tbl(1).valid_configuration_flag := l_valid_configuration_flag;
3192: l_model_line_dtl_tbl(1).complete_configuration_flag := l_complete_configuration_flag;
3193:

Line 3203: p_init_msg_list => FND_API.G_FALSE,

3199: END IF;
3200:
3201: ASO_CFG_INT.Get_config_details(
3202: p_api_version_number => 1.0,
3203: p_init_msg_list => FND_API.G_FALSE,
3204: p_commit => FND_API.G_FALSE,
3205: p_control_rec => p_control_rec,
3206: p_qte_header_rec => l_qte_header_rec,
3207: p_model_line_rec => l_model_line_rec,

Line 3204: p_commit => FND_API.G_FALSE,

3200:
3201: ASO_CFG_INT.Get_config_details(
3202: p_api_version_number => 1.0,
3203: p_init_msg_list => FND_API.G_FALSE,
3204: p_commit => FND_API.G_FALSE,
3205: p_control_rec => p_control_rec,
3206: p_qte_header_rec => l_qte_header_rec,
3207: p_model_line_rec => l_model_line_rec,
3208: p_config_rec => l_model_line_dtl_tbl(1),

Line 3221: l_delete_config := fnd_api.g_true;

3217: aso_debug_pub.add('Validate_Configuration: l_return_status: '||l_return_status);
3218: END IF;
3219:
3220: ELSE
3221: l_delete_config := fnd_api.g_true;
3222: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3223: aso_debug_pub.add('Validate_Configuration: l_delete_config: '||l_delete_config);
3224: END IF;
3225:

Line 3245: if l_delete_config = fnd_api.g_true then

3241: x_return_status := l_return_status;
3242: x_msg_count := l_msg_count;
3243: x_msg_data := l_msg_data;
3244:
3245: if l_delete_config = fnd_api.g_true then
3246:
3247: x_return_status := FND_API.G_RET_STS_ERROR;
3248:
3249: end if;

Line 3247: x_return_status := FND_API.G_RET_STS_ERROR;

3243: x_msg_data := l_msg_data;
3244:
3245: if l_delete_config = fnd_api.g_true then
3246:
3247: x_return_status := FND_API.G_RET_STS_ERROR;
3248:
3249: end if;
3250:
3251: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 3263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3259: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3260: aso_debug_pub.add('Validate_Configuration: Inside WHEN OTHERS EXCEPTION', 1, 'Y');
3261: END IF;
3262:
3263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3264:
3265: END Validate_Configuration;
3266:
3267: