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 227: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

Line 232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 241: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 245: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 284: l_autonomous_flag:=fnd_api.g_true;

280: END IF;
281: -- ER 3177722
282: l_autonomous_flag := p_autonomous_flag;
283: if l_copy_config_profile='N' then
284: l_autonomous_flag:=fnd_api.g_true;
285: end if;
286: IF l_autonomous_flag = fnd_api.g_true THEN
287:
288: cz_config_api_pub.copy_configuration_auto( p_api_version => 1.0,

Line 286: IF l_autonomous_flag = fnd_api.g_true THEN

282: l_autonomous_flag := p_autonomous_flag;
283: if l_copy_config_profile='N' then
284: l_autonomous_flag:=fnd_api.g_true;
285: end if;
286: IF l_autonomous_flag = fnd_api.g_true THEN
287:
288: cz_config_api_pub.copy_configuration_auto( p_api_version => 1.0,
289: p_config_hdr_id => p_config_header_id,
290: p_config_rev_nbr => l_config_rev_nbr,

Line 332: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

328: END IF;
329:
330: END IF;
331:
332: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
333:
334:
335: RAISE FND_API.G_EXC_ERROR;
336:

Line 335: RAISE FND_API.G_EXC_ERROR;

331:
332: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
333:
334:
335: RAISE FND_API.G_EXC_ERROR;
336:
337: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
338:
339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 337: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

333:
334:
335: RAISE FND_API.G_EXC_ERROR;
336:
337: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
338:
339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
340:
341: END IF;

Line 339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

335: RAISE FND_API.G_EXC_ERROR;
336:
337: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
338:
339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
340:
341: END IF;
342:
343: IF FND_API.to_Boolean( p_commit ) THEN

Line 343: IF FND_API.to_Boolean( p_commit ) THEN

339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
340:
341: END IF;
342:
343: IF FND_API.to_Boolean( p_commit ) THEN
344: COMMIT WORK;
345: END IF;
346:
347:

Line 354: WHEN FND_API.G_EXC_ERROR THEN

350:
351:
352: EXCEPTION
353:
354: WHEN FND_API.G_EXC_ERROR THEN
355:
356: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
357: P_PKG_NAME => G_PKG_NAME,
358: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

360: X_MSG_COUNT => X_MSG_COUNT,
361: X_MSG_DATA => X_MSG_DATA,
362: X_RETURN_STATUS => X_RETURN_STATUS);
363:
364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
365:
366: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
367: P_PKG_NAME => G_PKG_NAME,
368: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

Line 445: P_Init_Msg_List => FND_API.G_FALSE,

441: l_qte_line_dtl_tbl(1).config_revision_num := p_to_config_rev_nbr ;
442:
443: ASO_QUOTE_LINES_PVT.Update_Quote_Line(
444: P_Api_Version_Number => l_api_version_number ,
445: P_Init_Msg_List => FND_API.G_FALSE,
446: P_Commit => FND_API.G_FALSE,
447: P_Validation_Level => FND_API.G_VALID_LEVEL_NONE ,
448: P_Qte_Line_Rec => l_qte_line_REC,
449: P_Qte_Line_Dtl_Tbl => l_qte_line_dtl_TBL,

Line 446: P_Commit => FND_API.G_FALSE,

442:
443: ASO_QUOTE_LINES_PVT.Update_Quote_Line(
444: P_Api_Version_Number => l_api_version_number ,
445: P_Init_Msg_List => FND_API.G_FALSE,
446: P_Commit => FND_API.G_FALSE,
447: P_Validation_Level => FND_API.G_VALID_LEVEL_NONE ,
448: P_Qte_Line_Rec => l_qte_line_REC,
449: P_Qte_Line_Dtl_Tbl => l_qte_line_dtl_TBL,
450: P_Update_Header_Flag => FND_API.G_FALSE ,

Line 447: P_Validation_Level => FND_API.G_VALID_LEVEL_NONE ,

443: ASO_QUOTE_LINES_PVT.Update_Quote_Line(
444: P_Api_Version_Number => l_api_version_number ,
445: P_Init_Msg_List => FND_API.G_FALSE,
446: P_Commit => FND_API.G_FALSE,
447: P_Validation_Level => FND_API.G_VALID_LEVEL_NONE ,
448: P_Qte_Line_Rec => l_qte_line_REC,
449: P_Qte_Line_Dtl_Tbl => l_qte_line_dtl_TBL,
450: P_Update_Header_Flag => FND_API.G_FALSE ,
451: X_Qte_Line_Rec => x_Qte_Line_Rec,

Line 450: P_Update_Header_Flag => FND_API.G_FALSE ,

446: P_Commit => FND_API.G_FALSE,
447: P_Validation_Level => FND_API.G_VALID_LEVEL_NONE ,
448: P_Qte_Line_Rec => l_qte_line_REC,
449: P_Qte_Line_Dtl_Tbl => l_qte_line_dtl_TBL,
450: P_Update_Header_Flag => FND_API.G_FALSE ,
451: X_Qte_Line_Rec => x_Qte_Line_Rec,
452: X_payment_tbl => x_payment_tbl,
453: X_price_adj_tbl => x_price_adj_tbl ,
454: X_Qte_Line_Dtl_Tbl => x_Qte_Line_Dtl_Tbl ,

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

464: X_Msg_Count => x_msg_count,
465: X_Msg_Data => x_msg_data );
466:
467: --check for success
468: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
470: END IF;
471: End Loop;
472:

Line 469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

465: X_Msg_Data => x_msg_data );
466:
467: --check for success
468: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
470: END IF;
471: End Loop;
472:
473: End Update_Revision_Num ;

Line 496: l_return_status := FND_API.G_RET_STS_SUCCESS;

492: where related_quote_line_id = p_quote_line_id;
493:
494:
495: BEGIN
496: l_return_status := FND_API.G_RET_STS_SUCCESS;
497: If G_rtln_tbl.First IS NULL Then
498: return;
499: end if;
500:

Line 518: P_Init_Msg_List => FND_API.G_FALSE,

514:
515: If G_rtln_tbl(i).created_flag = 'N' Then
516: ASO_LINE_RLTSHIP_PVT.Create_line_rltship(
517: P_Api_Version_Number => l_api_version_number ,
518: P_Init_Msg_List => FND_API.G_FALSE,
519: P_Commit => FND_API.G_FALSE,
520: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
521: P_LINE_RLTSHIP_Rec => l_line_rltship_rec ,
522: X_LINE_RELATIONSHIP_ID => l_line_relationship_id ,

Line 519: P_Commit => FND_API.G_FALSE,

515: If G_rtln_tbl(i).created_flag = 'N' Then
516: ASO_LINE_RLTSHIP_PVT.Create_line_rltship(
517: P_Api_Version_Number => l_api_version_number ,
518: P_Init_Msg_List => FND_API.G_FALSE,
519: P_Commit => FND_API.G_FALSE,
520: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
521: P_LINE_RLTSHIP_Rec => l_line_rltship_rec ,
522: X_LINE_RELATIONSHIP_ID => l_line_relationship_id ,
523: X_Return_Status => x_return_status ,

Line 520: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

516: ASO_LINE_RLTSHIP_PVT.Create_line_rltship(
517: P_Api_Version_Number => l_api_version_number ,
518: P_Init_Msg_List => FND_API.G_FALSE,
519: P_Commit => FND_API.G_FALSE,
520: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
521: P_LINE_RLTSHIP_Rec => l_line_rltship_rec ,
522: X_LINE_RELATIONSHIP_ID => l_line_relationship_id ,
523: X_Return_Status => x_return_status ,
524: X_Msg_Count => x_msg_count,

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

525: X_Msg_Data => x_msg_data );
526:
527: l_return_status := x_return_status;
528:
529: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
530: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
531: END IF;
532: End If;
533:

Line 530: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

526:
527: l_return_status := x_return_status;
528:
529: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
530: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
531: END IF;
532: End If;
533:
534: G_rtln_tbl(i).included_flag := 'Y';

Line 632: x_output_quantity:=FND_API.G_MISS_NUM;

628: p_item_id:=l_rec_model.inventory_item_id;
629: p_organization_id:=l_rec_model.organization_id;
630: p_uom_code:=l_rec_model.uom_code;
631: p_input_quantity:=l_rec_model.quantity;
632: x_output_quantity:=FND_API.G_MISS_NUM;
633:
634: -- inv quantity validation 6661597
635: IF (p_input_quantity is not null AND p_input_quantity <> FND_API.G_MISS_NUM) THEN
636: inv_decimals_pub.validate_quantity(

Line 635: IF (p_input_quantity is not null AND p_input_quantity <> FND_API.G_MISS_NUM) THEN

631: p_input_quantity:=l_rec_model.quantity;
632: x_output_quantity:=FND_API.G_MISS_NUM;
633:
634: -- inv quantity validation 6661597
635: IF (p_input_quantity is not null AND p_input_quantity <> FND_API.G_MISS_NUM) THEN
636: inv_decimals_pub.validate_quantity(
637: p_item_id => p_item_id ,
638: p_organization_id => p_organization_id ,
639: p_input_quantity => p_input_quantity,

Line 650: RAISE FND_API.G_EXC_ERROR;

646: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
647: FND_MESSAGE.Set_Name('ASO', 'ASO_ERR_FRACTIONAL_QUANTITY');
648: FND_MSG_PUB.ADD;
649: END IF;
650: RAISE FND_API.G_EXC_ERROR;
651: elsif x_ret_Stat = 'W' then
652: x_output_quantity:= l_validated_quantity;
653: else
654: x_output_quantity:=p_input_quantity;

Line 684: x_output_quantity:=FND_API.G_MISS_NUM;

680: p_item_id:=l_rec_options.inventory_item_id;
681: p_organization_id:=l_rec_options.organization_id;
682: p_uom_code:=l_rec_options.uom_code;
683: p_input_quantity:=l_rec_options.quantity;
684: x_output_quantity:=FND_API.G_MISS_NUM;
685:
686: -- inv quantity validation 6661597
687: IF (p_input_quantity is not null AND p_input_quantity <> FND_API.G_MISS_NUM) THEN
688: inv_decimals_pub.validate_quantity(

Line 687: IF (p_input_quantity is not null AND p_input_quantity <> FND_API.G_MISS_NUM) THEN

683: p_input_quantity:=l_rec_options.quantity;
684: x_output_quantity:=FND_API.G_MISS_NUM;
685:
686: -- inv quantity validation 6661597
687: IF (p_input_quantity is not null AND p_input_quantity <> FND_API.G_MISS_NUM) THEN
688: inv_decimals_pub.validate_quantity(
689: p_item_id => p_item_id ,
690: p_organization_id => p_organization_id ,
691: p_input_quantity => p_input_quantity,

Line 702: RAISE FND_API.G_EXC_ERROR;

698: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
699: FND_MESSAGE.Set_Name('ASO', 'ASO_ERR_FRACTIONAL_QUANTITY');
700: FND_MSG_PUB.ADD;
701: END IF;
702: RAISE FND_API.G_EXC_ERROR;
703: elsif x_ret_Stat = 'W' then
704: x_output_quantity:= l_validated_quantity;
705: else
706: x_output_quantity:=p_input_quantity;

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

721:
722:
723: PROCEDURE Get_config_details(
724: p_api_version_number IN NUMBER,
725: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
726: p_commit IN VARCHAR2 := FND_API.G_FALSE,
727: p_control_rec IN aso_quote_pub.control_rec_type
728: := aso_quote_pub.G_MISS_control_rec,
729: p_qte_header_rec IN aso_quote_pub.qte_header_rec_type,

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

722:
723: PROCEDURE Get_config_details(
724: p_api_version_number IN NUMBER,
725: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
726: p_commit IN VARCHAR2 := FND_API.G_FALSE,
727: p_control_rec IN aso_quote_pub.control_rec_type
728: := aso_quote_pub.G_MISS_control_rec,
729: p_qte_header_rec IN aso_quote_pub.qte_header_rec_type,
730: p_model_line_rec IN aso_quote_pub.qte_line_rec_type,

Line 963: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

959: aso_debug_pub.add('p_config_rec.complete_configuration_flag: '|| p_config_rec.complete_configuration_flag);
960: END IF;
961:
962: -- Standard call to check for call compatibility.
963: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
964: p_api_version_number,
965: l_api_name,
966: G_PKG_NAME) THEN
967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

963: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
964: p_api_version_number,
965: l_api_name,
966: G_PKG_NAME) THEN
967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
968: END IF;
969:
970: -- Initialize message list if p_init_msg_list is set to TRUE.
971: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 971: IF FND_API.to_Boolean( p_init_msg_list ) THEN

967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
968: END IF;
969:
970: -- Initialize message list if p_init_msg_list is set to TRUE.
971: IF FND_API.to_Boolean( p_init_msg_list ) THEN
972: FND_MSG_PUB.initialize;
973: END IF;
974:
975: -- Set return status to success

Line 976: x_return_status := FND_API.G_RET_STS_SUCCESS;

972: FND_MSG_PUB.initialize;
973: END IF;
974:
975: -- Set return status to success
976: x_return_status := FND_API.G_RET_STS_SUCCESS;
977:
978:
979: --Procedure added by Anoop Rajan on 30/09/2005 to print login details
980: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 1016: RAISE FND_API.G_EXC_ERROR;

1012: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1013: FND_MESSAGE.Set_Name('ASO', 'ASO_DIFFERENT_CONFIG_EXISTS');
1014: FND_MSG_PUB.ADD;
1015: END IF;
1016: RAISE FND_API.G_EXC_ERROR;
1017:
1018: END IF;
1019:
1020: -- check whether the config_header_id+config_revision_num is already

Line 1042: RAISE FND_API.G_EXC_ERROR;

1038: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1039: FND_MESSAGE.Set_Name('ASO', 'ASO_API_CONFIG_EXISTS');
1040: FND_MSG_PUB.ADD;
1041: END IF;
1042: RAISE FND_API.G_EXC_ERROR;
1043:
1044: END IF;
1045:
1046: --check if the quote has been modified by someone else

Line 1058: 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

1054: aso_debug_pub.add('Get_config_details: l_last_update_date: ' || to_char(l_last_update_date, 'DD-MON-YYYY HH24:MI:SS'));
1055: aso_debug_pub.add('ASO_CFG_INT: Get_config_details: l_quote_type: ' || l_quote_type);
1056: END IF;
1057:
1058: 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
1059:
1060: If (l_last_update_date <> p_qte_header_rec.last_update_date) Then
1061:
1062: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 1067: raise FND_API.G_EXC_ERROR;

1063: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');
1064: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
1065: FND_MSG_PUB.ADD;
1066: END IF;
1067: raise FND_API.G_EXC_ERROR;
1068:
1069: End if;
1070:
1071: end if;

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

1078: --if yes update all the previous selected options to the current
1079: --revision number.This is necessary as the current revision number
1080: --will not be the same as in aso_quote_line_details.
1081:
1082: IF ((p_config_rec.config_header_id <> FND_API.G_Miss_num AND
1083: p_config_rec.config_revision_num <> FND_API.G_Miss_Num) AND
1084: (p_config_rec.config_header_id IS NOT NULL AND
1085: p_config_rec.config_revision_num IS NOT NULL)) AND
1086: (p_config_rec.config_header_id <> p_config_hdr_id OR

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

1079: --revision number.This is necessary as the current revision number
1080: --will not be the same as in aso_quote_line_details.
1081:
1082: IF ((p_config_rec.config_header_id <> FND_API.G_Miss_num AND
1083: p_config_rec.config_revision_num <> FND_API.G_Miss_Num) AND
1084: (p_config_rec.config_header_id IS NOT NULL AND
1085: p_config_rec.config_revision_num IS NOT NULL)) AND
1086: (p_config_rec.config_header_id <> p_config_hdr_id OR
1087: p_config_rec.config_revision_num <> p_config_rev_nbr) THEN

Line 1177: x_output_quantity:=FND_API.G_MISS_NUM;

1173: p_item_id:=row.inventory_item_id;
1174: p_organization_id:=row.organization_id;
1175: p_uom_code:=row.uom_code;
1176: p_input_quantity:=row.quantity;
1177: x_output_quantity:=FND_API.G_MISS_NUM;
1178: -- inv quantity validation 6661597
1179: IF (p_input_quantity is not null AND p_input_quantity <> FND_API.G_MISS_NUM) THEN
1180: inv_decimals_pub.validate_quantity(
1181: p_item_id => p_item_id ,

Line 1179: IF (p_input_quantity is not null AND p_input_quantity <> FND_API.G_MISS_NUM) THEN

1175: p_uom_code:=row.uom_code;
1176: p_input_quantity:=row.quantity;
1177: x_output_quantity:=FND_API.G_MISS_NUM;
1178: -- inv quantity validation 6661597
1179: IF (p_input_quantity is not null AND p_input_quantity <> FND_API.G_MISS_NUM) THEN
1180: inv_decimals_pub.validate_quantity(
1181: p_item_id => p_item_id ,
1182: p_organization_id => p_organization_id ,
1183: p_input_quantity => p_input_quantity,

Line 1188: x_return_status:= FND_API.G_RET_STS_SUCCESS;

1184: p_uom_code => p_uom_code,
1185: x_output_quantity => l_validated_quantity,
1186: x_primary_quantity => l_primary_quantity,
1187: x_return_status => x_ret_Stat);
1188: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1189: if x_ret_Stat = 'E' THEN
1190: x_return_status:= FND_API.G_RET_STS_ERROR;
1191: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1192: FND_MESSAGE.Set_Name('ASO', 'ASO_ERR_FRACTIONAL_QUANTITY');

Line 1190: x_return_status:= FND_API.G_RET_STS_ERROR;

1186: x_primary_quantity => l_primary_quantity,
1187: x_return_status => x_ret_Stat);
1188: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1189: if x_ret_Stat = 'E' THEN
1190: x_return_status:= FND_API.G_RET_STS_ERROR;
1191: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1192: FND_MESSAGE.Set_Name('ASO', 'ASO_ERR_FRACTIONAL_QUANTITY');
1193: FND_MSG_PUB.ADD;
1194: END IF;

Line 1195: RAISE FND_API.G_EXC_ERROR;

1191: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1192: FND_MESSAGE.Set_Name('ASO', 'ASO_ERR_FRACTIONAL_QUANTITY');
1193: FND_MSG_PUB.ADD;
1194: END IF;
1195: RAISE FND_API.G_EXC_ERROR;
1196: elsif x_ret_Stat = 'W' then
1197: x_output_quantity:= l_validated_quantity;
1198: else
1199: x_output_quantity:=p_input_quantity;

Line 1392: x_output_quantity:=FND_API.G_MISS_NUM;

1388: p_item_id:=row.inventory_item_id;
1389: p_organization_id:=row.organization_id;
1390: p_uom_code:=row.uom_code;
1391: p_input_quantity:=row.quantity;
1392: x_output_quantity:=FND_API.G_MISS_NUM;
1393: -- inv quantity validation 6661597
1394: IF (p_input_quantity is not null AND p_input_quantity <> FND_API.G_MISS_NUM) THEN
1395: inv_decimals_pub.validate_quantity(
1396: p_item_id => p_item_id ,

Line 1394: IF (p_input_quantity is not null AND p_input_quantity <> FND_API.G_MISS_NUM) THEN

1390: p_uom_code:=row.uom_code;
1391: p_input_quantity:=row.quantity;
1392: x_output_quantity:=FND_API.G_MISS_NUM;
1393: -- inv quantity validation 6661597
1394: IF (p_input_quantity is not null AND p_input_quantity <> FND_API.G_MISS_NUM) THEN
1395: inv_decimals_pub.validate_quantity(
1396: p_item_id => p_item_id ,
1397: p_organization_id => p_organization_id ,
1398: p_input_quantity => p_input_quantity,

Line 1403: x_return_status:= FND_API.G_RET_STS_SUCCESS;

1399: p_uom_code => p_uom_code,
1400: x_output_quantity => l_validated_quantity,
1401: x_primary_quantity => l_primary_quantity,
1402: x_return_status => x_ret_Stat);
1403: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1404: if x_ret_Stat = 'E' THEN
1405: x_return_status:= FND_API.G_RET_STS_ERROR;
1406: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1407: FND_MESSAGE.Set_Name('ASO', 'ASO_ERR_FRACTIONAL_QUANTITY');

Line 1405: x_return_status:= FND_API.G_RET_STS_ERROR;

1401: x_primary_quantity => l_primary_quantity,
1402: x_return_status => x_ret_Stat);
1403: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1404: if x_ret_Stat = 'E' THEN
1405: x_return_status:= FND_API.G_RET_STS_ERROR;
1406: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1407: FND_MESSAGE.Set_Name('ASO', 'ASO_ERR_FRACTIONAL_QUANTITY');
1408: FND_MSG_PUB.ADD;
1409: END IF;

Line 1410: RAISE FND_API.G_EXC_ERROR;

1406: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1407: FND_MESSAGE.Set_Name('ASO', 'ASO_ERR_FRACTIONAL_QUANTITY');
1408: FND_MSG_PUB.ADD;
1409: END IF;
1410: RAISE FND_API.G_EXC_ERROR;
1411: elsif x_ret_Stat = 'W' then
1412: x_output_quantity:= l_validated_quantity;
1413: else
1414: x_output_quantity:=p_input_quantity;

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

1494: --Populate quote header record
1495:
1496: l_qte_header_rec := p_qte_header_rec;
1497: l_qte_header_rec.last_update_date := l_last_update_date;
1498: l_qte_header_rec.CALL_BATCH_VALIDATION_FLAG := FND_API.G_FALSE;
1499:
1500: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1501:
1502: aso_debug_pub.add( 'Get_Config_details: Before call to Update Quote table count');

Line 1510: p_init_msg_list => FND_API.G_FALSE,

1506: END IF;
1507:
1508: ASO_QUOTE_PUB.Update_Quote(
1509: p_api_version_number => 1.0,
1510: p_init_msg_list => FND_API.G_FALSE,
1511: p_commit => FND_API.G_FALSE,
1512: p_control_rec => p_control_rec,
1513: p_qte_header_rec => l_qte_header_rec,
1514: p_hd_tax_detail_tbl => l_hd_tax_detail_tbl,

Line 1511: p_commit => FND_API.G_FALSE,

1507:
1508: ASO_QUOTE_PUB.Update_Quote(
1509: p_api_version_number => 1.0,
1510: p_init_msg_list => FND_API.G_FALSE,
1511: p_commit => FND_API.G_FALSE,
1512: p_control_rec => p_control_rec,
1513: p_qte_header_rec => l_qte_header_rec,
1514: p_hd_tax_detail_tbl => l_hd_tax_detail_tbl,
1515: --P_hd_Shipment_Tbl => l_Shipment_tbl,

Line 1546: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1542: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1543: aso_debug_pub.add('Get_config_details: After call to Update_quote x_Return_Status: ' || x_Return_Status);
1544: END IF;
1545:
1546: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1547:
1548: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1549: aso_debug_pub.add('Get_config_details: Before deleting the previous version from CZ schema.');
1550: END IF;

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

1548: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1549: aso_debug_pub.add('Get_config_details: Before deleting the previous version from CZ schema.');
1550: END IF;
1551:
1552: IF ((p_config_rec.config_header_id <> FND_API.G_Miss_num AND
1553: p_config_rec.config_revision_num <> FND_API.G_Miss_Num) AND
1554: (p_config_rec.config_header_id IS NOT NULL AND
1555: p_config_rec.config_revision_num IS NOT NULL)) AND
1556: (p_config_rec.config_header_id <> p_config_hdr_id OR

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

1549: aso_debug_pub.add('Get_config_details: Before deleting the previous version from CZ schema.');
1550: END IF;
1551:
1552: IF ((p_config_rec.config_header_id <> FND_API.G_Miss_num AND
1553: p_config_rec.config_revision_num <> FND_API.G_Miss_Num) AND
1554: (p_config_rec.config_header_id IS NOT NULL AND
1555: p_config_rec.config_revision_num IS NOT NULL)) AND
1556: (p_config_rec.config_header_id <> p_config_hdr_id OR
1557: p_config_rec.config_revision_num <> p_config_rev_nbr) THEN

Line 1564: P_INIT_MSG_LIST => FND_API.G_FALSE,

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

Line 1575: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1584: RAISE FND_API.G_EXC_ERROR;

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

Line 1590: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

1586: END IF;
1587:
1588: END IF;
1589:
1590: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1591: RAISE FND_API.G_EXC_ERROR;
1592:
1593: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1591: RAISE FND_API.G_EXC_ERROR;

1587:
1588: END IF;
1589:
1590: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1591: RAISE FND_API.G_EXC_ERROR;
1592:
1593: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1595:

Line 1593: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1589:
1590: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1591: RAISE FND_API.G_EXC_ERROR;
1592:
1593: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1595:
1596: END IF;
1597:

Line 1594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1590: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1591: RAISE FND_API.G_EXC_ERROR;
1592:
1593: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1595:
1596: END IF;
1597:
1598: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 1661: IF x_return_status = FND_API.G_RET_STS_ERROR then

1657: END IF;
1658:
1659: -- Check return status from the above procedure call
1660:
1661: IF x_return_status = FND_API.G_RET_STS_ERROR then
1662: raise FND_API.G_EXC_ERROR;
1663: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1664: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1665: END IF;

Line 1662: raise FND_API.G_EXC_ERROR;

1658:
1659: -- Check return status from the above procedure call
1660:
1661: IF x_return_status = FND_API.G_RET_STS_ERROR then
1662: raise FND_API.G_EXC_ERROR;
1663: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1664: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1665: END IF;
1666:

Line 1663: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

1659: -- Check return status from the above procedure call
1660:
1661: IF x_return_status = FND_API.G_RET_STS_ERROR then
1662: raise FND_API.G_EXC_ERROR;
1663: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1664: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1665: END IF;
1666:
1667: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 1664: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1660:
1661: IF x_return_status = FND_API.G_RET_STS_ERROR then
1662: raise FND_API.G_EXC_ERROR;
1663: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1664: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1665: END IF;
1666:
1667: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1668: aso_debug_pub.add('Get_config_details: Before deleting the previous version from CZ schema.');

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

1667: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1668: aso_debug_pub.add('Get_config_details: Before deleting the previous version from CZ schema.');
1669: END IF;
1670:
1671: IF ((p_config_rec.config_header_id <> FND_API.G_Miss_num AND
1672: p_config_rec.config_revision_num <> FND_API.G_Miss_Num) AND
1673: (p_config_rec.config_header_id IS NOT NULL AND
1674: p_config_rec.config_revision_num IS NOT NULL)) AND
1675: (p_config_rec.config_header_id <> p_config_hdr_id OR

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

1668: aso_debug_pub.add('Get_config_details: Before deleting the previous version from CZ schema.');
1669: END IF;
1670:
1671: IF ((p_config_rec.config_header_id <> FND_API.G_Miss_num AND
1672: p_config_rec.config_revision_num <> FND_API.G_Miss_Num) AND
1673: (p_config_rec.config_header_id IS NOT NULL AND
1674: p_config_rec.config_revision_num IS NOT NULL)) AND
1675: (p_config_rec.config_header_id <> p_config_hdr_id OR
1676: p_config_rec.config_revision_num <> p_config_rev_nbr) THEN

Line 1689: P_INIT_MSG_LIST => FND_API.G_FALSE,

1685: aso_debug_pub.add('Get_config_details: A previous version exist for this configuration so deleting it from CZ');
1686: END IF;
1687:
1688: ASO_CFG_INT.DELETE_CONFIGURATION( P_API_VERSION_NUMBER => 1.0,
1689: P_INIT_MSG_LIST => FND_API.G_FALSE,
1690: P_CONFIG_HDR_ID => p_config_rec.config_header_id,
1691: P_CONFIG_REV_NBR => p_config_rec.config_revision_num,
1692: X_RETURN_STATUS => lx_return_status,
1693: X_MSG_COUNT => x_msg_count,

Line 1700: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1696: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1697: aso_debug_pub.add('After call to ASO_CFG_INT.DELETE_CONFIGURATION: x_Return_Status: ' || lx_Return_Status);
1698: END IF;
1699:
1700: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1701:
1702: x_return_status := lx_return_status;
1703: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1704: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');

Line 1709: RAISE FND_API.G_EXC_ERROR;

1705: FND_MESSAGE.Set_Token('OBJECT', 'CONFIGURATION', FALSE);
1706: FND_MSG_PUB.ADD;
1707: END IF;
1708:
1709: RAISE FND_API.G_EXC_ERROR;
1710:
1711: END IF;
1712:
1713: else

Line 1725: WHEN FND_API.G_EXC_ERROR THEN

1721: END IF;
1722:
1723: EXCEPTION
1724:
1725: WHEN FND_API.G_EXC_ERROR THEN
1726:
1727: open c_config_exist_in_cz(p_config_hdr_id, p_config_rev_nbr);
1728: fetch c_config_exist_in_cz into l_old_config_hdr_id;
1729:

Line 1739: P_INIT_MSG_LIST => FND_API.G_FALSE,

1735: aso_debug_pub.add('Get_config_details: A previous version exist for this configuration so deleting it from CZ');
1736: END IF;
1737:
1738: ASO_CFG_INT.DELETE_CONFIGURATION_AUTO( P_API_VERSION_NUMBER => 1.0,
1739: P_INIT_MSG_LIST => FND_API.G_FALSE,
1740: P_CONFIG_HDR_ID => p_config_hdr_id,
1741: P_CONFIG_REV_NBR => p_config_rev_nbr,
1742: X_RETURN_STATUS => lx_return_status,
1743: X_MSG_COUNT => x_msg_count,

Line 1750: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1746: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1747: aso_debug_pub.add('After call to ASO_CFG_INT.DELETE_CONFIGURATION: x_Return_Status: ' || lx_Return_Status);
1748: END IF;
1749:
1750: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1751:
1752: x_return_status := lx_return_status;
1753: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1754: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');

Line 1759: RAISE FND_API.G_EXC_ERROR;

1755: FND_MESSAGE.Set_Token('OBJECT', 'CONFIGURATION', FALSE);
1756: FND_MSG_PUB.ADD;
1757: END IF;
1758:
1759: RAISE FND_API.G_EXC_ERROR;
1760:
1761: END IF;
1762:
1763: else

Line 1776: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1772: ,X_MSG_COUNT => X_MSG_COUNT
1773: ,X_MSG_DATA => X_MSG_DATA
1774: ,X_RETURN_STATUS => X_RETURN_STATUS);
1775:
1776: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1777:
1778: open c_config_exist_in_cz(p_config_hdr_id, p_config_rev_nbr);
1779: fetch c_config_exist_in_cz into l_old_config_hdr_id;
1780:

Line 1790: P_INIT_MSG_LIST => FND_API.G_FALSE,

1786: aso_debug_pub.add('Get_config_details: A previous version exist for this configuration so deleting it from CZ');
1787: END IF;
1788:
1789: ASO_CFG_INT.DELETE_CONFIGURATION_AUTO( P_API_VERSION_NUMBER => 1.0,
1790: P_INIT_MSG_LIST => FND_API.G_FALSE,
1791: P_CONFIG_HDR_ID => p_config_hdr_id,
1792: P_CONFIG_REV_NBR => p_config_rev_nbr,
1793: X_RETURN_STATUS => lx_return_status,
1794: X_MSG_COUNT => x_msg_count,

Line 1801: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1797: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1798: aso_debug_pub.add('After call to ASO_CFG_INT.DELETE_CONFIGURATION: x_Return_Status: ' || lx_Return_Status);
1799: END IF;
1800:
1801: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1802:
1803: x_return_status := lx_return_status;
1804: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1805: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');

Line 1810: RAISE FND_API.G_EXC_ERROR;

1806: FND_MESSAGE.Set_Token('OBJECT', 'CONFIGURATION', FALSE);
1807: FND_MSG_PUB.ADD;
1808: END IF;
1809:
1810: RAISE FND_API.G_EXC_ERROR;
1811:
1812: END IF;
1813:
1814: else

Line 1841: P_INIT_MSG_LIST => FND_API.G_FALSE,

1837: aso_debug_pub.add('Get_config_details: A previous version exist for this configuration so deleting it from CZ');
1838: END IF;
1839:
1840: ASO_CFG_INT.DELETE_CONFIGURATION_AUTO( P_API_VERSION_NUMBER => 1.0,
1841: P_INIT_MSG_LIST => FND_API.G_FALSE,
1842: P_CONFIG_HDR_ID => p_config_hdr_id,
1843: P_CONFIG_REV_NBR => p_config_rev_nbr,
1844: X_RETURN_STATUS => lx_return_status,
1845: X_MSG_COUNT => x_msg_count,

Line 1852: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1848: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1849: aso_debug_pub.add('After call to ASO_CFG_INT.DELETE_CONFIGURATION: x_Return_Status: ' || lx_Return_Status);
1850: END IF;
1851:
1852: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1853:
1854: x_return_status := lx_return_status;
1855: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1856: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');

Line 1861: RAISE FND_API.G_EXC_ERROR;

1857: FND_MESSAGE.Set_Token('OBJECT', 'CONFIGURATION', FALSE);
1858: FND_MSG_PUB.ADD;
1859: END IF;
1860:
1861: RAISE FND_API.G_EXC_ERROR;
1862:
1863: END IF;
1864:
1865: else

Line 2095: x_output_quantity:=FND_API.G_MISS_NUM;

2091: p_item_id:=row.item_id;
2092: p_organization_id:=l_master_organization_id;
2093: p_uom_code:=row.uom_code;
2094: p_input_quantity:=row.quantity;
2095: x_output_quantity:=FND_API.G_MISS_NUM;
2096:
2097: -- inv quantity validation 6661597
2098: IF (p_input_quantity is not null AND p_input_quantity <> FND_API.G_MISS_NUM) THEN
2099: inv_decimals_pub.validate_quantity(

Line 2098: IF (p_input_quantity is not null AND p_input_quantity <> FND_API.G_MISS_NUM) THEN

2094: p_input_quantity:=row.quantity;
2095: x_output_quantity:=FND_API.G_MISS_NUM;
2096:
2097: -- inv quantity validation 6661597
2098: IF (p_input_quantity is not null AND p_input_quantity <> FND_API.G_MISS_NUM) THEN
2099: inv_decimals_pub.validate_quantity(
2100: p_item_id => p_item_id ,
2101: p_organization_id => p_organization_id ,
2102: p_input_quantity => p_input_quantity,

Line 2114: RAISE FND_API.G_EXC_ERROR;

2110: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2111: FND_MESSAGE.Set_Name('ASO', 'ASO_ERR_FRACTIONAL_QUANTITY');
2112: FND_MSG_PUB.ADD;
2113: END IF;
2114: RAISE FND_API.G_EXC_ERROR;
2115: elsif x_ret_Stat = 'W' then
2116: x_output_quantity:= l_validated_quantity;
2117: else
2118: x_output_quantity:=p_input_quantity;

Line 2225: x_output_quantity:=FND_API.G_MISS_NUM;

2221: p_item_id:=row.item_id;
2222: p_organization_id:=l_master_organization_id;
2223: p_uom_code:=row.uom_code;
2224: p_input_quantity:=row.quantity;
2225: x_output_quantity:=FND_API.G_MISS_NUM;
2226:
2227: -- inv quantity validation 6661597
2228: IF (p_input_quantity is not null AND p_input_quantity <> FND_API.G_MISS_NUM) THEN
2229: inv_decimals_pub.validate_quantity(

Line 2228: IF (p_input_quantity is not null AND p_input_quantity <> FND_API.G_MISS_NUM) THEN

2224: p_input_quantity:=row.quantity;
2225: x_output_quantity:=FND_API.G_MISS_NUM;
2226:
2227: -- inv quantity validation 6661597
2228: IF (p_input_quantity is not null AND p_input_quantity <> FND_API.G_MISS_NUM) THEN
2229: inv_decimals_pub.validate_quantity(
2230: p_item_id => p_item_id ,
2231: p_organization_id => p_organization_id ,
2232: p_input_quantity => p_input_quantity,

Line 2244: RAISE FND_API.G_EXC_ERROR;

2240: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2241: FND_MESSAGE.Set_Name('ASO', 'ASO_ERR_FRACTIONAL_QUANTITY');
2242: FND_MSG_PUB.ADD;
2243: END IF;
2244: RAISE FND_API.G_EXC_ERROR;
2245: elsif x_ret_Stat = 'W' then
2246: x_output_quantity:= l_validated_quantity;
2247: else
2248: x_output_quantity:=p_input_quantity;

Line 2402: P_Init_Msg_List => FND_API.G_TRUE,

2398: END IF;
2399:
2400: ASO_PRICING_INT.Pricing_Order(
2401: P_Api_Version_Number => 1.0,
2402: P_Init_Msg_List => FND_API.G_TRUE,
2403: P_Commit => FND_API.G_FALSE,
2404: p_control_rec => l_pricing_control_rec,
2405: p_qte_header_rec => l_qte_header_rec,
2406: p_hd_shipment_rec => l_hd_shipment_rec,

Line 2403: P_Commit => FND_API.G_FALSE,

2399:
2400: ASO_PRICING_INT.Pricing_Order(
2401: P_Api_Version_Number => 1.0,
2402: P_Init_Msg_List => FND_API.G_TRUE,
2403: P_Commit => FND_API.G_FALSE,
2404: p_control_rec => l_pricing_control_rec,
2405: p_qte_header_rec => l_qte_header_rec,
2406: p_hd_shipment_rec => l_hd_shipment_rec,
2407: p_hd_price_attr_tbl => l_hd_price_attr_tbl,

Line 2435: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2431: aso_debug_pub.add('PRICING CALLBACK: lx_qte_line_tbl.count: '|| lx_qte_line_tbl.count);
2432:
2433: END IF;
2434:
2435: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2436:
2437: fnd_msg_pub.count_and_get( p_encoded => 'F',
2438: p_count => lx_msg_count,
2439: p_data => lx_msg_data);

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

2466: END IF;
2467:
2468: -- set the error message in the model line msg_data field of cz_pricing_structure
2469:
2470: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS AND p_price_type <> 'LIST' THEN
2471:
2472: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2473: aso_debug_pub.add('PRICING CALLBACK: Inside IF condition lx_return_status <> FND_API.G_RET_STS_SUCCESS');
2474: END IF;

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

2469:
2470: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS AND p_price_type <> 'LIST' THEN
2471:
2472: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2473: aso_debug_pub.add('PRICING CALLBACK: Inside IF condition lx_return_status <> FND_API.G_RET_STS_SUCCESS');
2474: END IF;
2475:
2476: UPDATE CZ_PRICING_STRUCTURES
2477: SET MSG_DATA = l_mymsg

Line 2529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2525: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2526: aso_debug_pub.add('ASO_CFG_INT: PRICING CALLBACK: Inside When Others Exception for select sum(selling_price)');
2527: END IF;
2528:
2529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2530:
2531: END;
2532:
2533:

Line 2717: x_return_status := FND_API.G_RET_STS_SUCCESS;

2713: aso_debug_pub.add('Create_hdr_xml Begins.', 1, 'Y');
2714: END IF;
2715:
2716: --Initialize API return status to SUCCESS
2717: x_return_status := FND_API.G_RET_STS_SUCCESS;
2718:
2719: l_model_line_rec := aso_utility_pvt.Query_Qte_Line_Row( P_Qte_Line_Id => p_model_line_id );
2720:
2721: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 2917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2913: EXCEPTION
2914:
2915: when others then
2916:
2917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2918:
2919: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2920: aso_debug_pub.add('Create_hdr_xml: Inside When Others Exception: x_return_status: '||x_return_status, 1, 'N');
2921: END IF;

Line 2995: l_return_status := FND_API.G_RET_STS_SUCCESS;

2991: aso_debug_pub.add('ASO_CFG_INT: Send_input_xml Begin.', 1, 'Y');
2992: END IF;
2993:
2994: --Initialize API return status to SUCCESS
2995: l_return_status := FND_API.G_RET_STS_SUCCESS;
2996:
2997: l_xml_hdr := p_xml_hdr;
2998:
2999: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 3063: l_return_status := FND_API.G_RET_STS_ERROR;

3059:
3060: FND_MESSAGE.Set_Name('ASO', 'ASO_BATCH_VALIDATE');
3061: FND_MESSAGE.Set_token('ERR_TEXT' , 'Error returned from CZ_CF_API.Validate, validation_status <> 0' );
3062: FND_MSG_PUB.ADD;
3063: l_return_status := FND_API.G_RET_STS_ERROR;
3064: END IF;
3065:
3066: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3067: aso_debug_pub.add('Send_input_xml: After call to CZ_CF_API.Validate: l_html_pieces.COUNT: '||l_html_pieces.COUNT);

Line 3079: l_return_status := FND_API.G_RET_STS_ERROR;

3075:
3076: FND_MESSAGE.Set_Name('ASO', 'ASO_BATCH_VALIDATE');
3077: FND_MESSAGE.Set_token('ERR_TEXT' , 'Error returned from CZ_CF_API.Validate, config_messages: l_html_pieces.COUNT <= 0' );
3078: FND_MSG_PUB.ADD;
3079: l_return_status := FND_API.G_RET_STS_ERROR;
3080:
3081: END IF;
3082:
3083: l_index := l_html_pieces.FIRST;

Line 3120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3116: EXCEPTION
3117:
3118: WHEN OTHERS THEN
3119:
3120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3121:
3122: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3123: aso_debug_pub.add('Send_input_xml: Inside When Others Exception:', 1, 'N');
3124: END IF;

Line 3179: l_return_status := FND_API.G_RET_STS_SUCCESS;

3175: aso_debug_pub.add('ASO_CFG_INT: Parse_output_xml Begin.', 1, 'Y');
3176: END IF;
3177:
3178: --Initialize API return status to SUCCESS
3179: l_return_status := FND_API.G_RET_STS_SUCCESS;
3180:
3181: l_config_header_id := to_number(substr(p_xml_msg,(instr(p_xml_msg, '',1,1)+18),
3182: (instr(p_xml_msg,'',1,1) -
3183: (instr(p_xml_msg, '',1,1)+18))));

Line 3231: l_return_status := FND_API.G_RET_STS_ERROR;

3227: i := i + 240;
3228:
3229: End Loop;
3230:
3231: l_return_status := FND_API.G_RET_STS_ERROR;
3232:
3233: END IF;
3234:
3235:

Line 3291: l_return_status := FND_API.G_RET_STS_ERROR;

3287: END IF;
3288:
3289: END LOOP;
3290:
3291: l_return_status := FND_API.G_RET_STS_ERROR;
3292:
3293: END IF;
3294:
3295: -- if everything ok, set return values

Line 3313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3309: EXCEPTION
3310:
3311: WHEN OTHERS THEN
3312:
3313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3314:
3315: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3316: aso_Debug_Pub.Add( 'Parse_Output_xml: In WHEN OTHERS exception ', 1, 'N');
3317: END IF;

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

3334: , ASO_QUOTE_LINE_DETAILS and ASO_LINE_RELATIONSHIPS
3335: -----------------------------------------------------------------------*/
3336:
3337: PROCEDURE Validate_Configuration
3338: (P_Api_Version_Number IN NUMBER := FND_API.G_MISS_NUM,
3339: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3340: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3341: p_control_rec IN aso_quote_pub.control_rec_type
3342: := aso_quote_pub.G_MISS_control_rec,

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

3335: -----------------------------------------------------------------------*/
3336:
3337: PROCEDURE Validate_Configuration
3338: (P_Api_Version_Number IN NUMBER := FND_API.G_MISS_NUM,
3339: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3340: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3341: p_control_rec IN aso_quote_pub.control_rec_type
3342: := aso_quote_pub.G_MISS_control_rec,
3343: P_model_line_id IN NUMBER,

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

3336:
3337: PROCEDURE Validate_Configuration
3338: (P_Api_Version_Number IN NUMBER := FND_API.G_MISS_NUM,
3339: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3340: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3341: p_control_rec IN aso_quote_pub.control_rec_type
3342: := aso_quote_pub.G_MISS_control_rec,
3343: P_model_line_id IN NUMBER,
3344: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type

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

3379: -- upgrade stuff
3380: l_upgraded_flag VARCHAR2(1);
3381:
3382: -- cz's delete return value
3383: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3384: l_delete_config VARCHAR2(1) := fnd_api.g_false;
3385: l_old_config_hdr_id NUMBER;
3386: l_config_changed VARCHAR2(1);
3387: BEGIN

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

3380: l_upgraded_flag VARCHAR2(1);
3381:
3382: -- cz's delete return value
3383: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3384: l_delete_config VARCHAR2(1) := fnd_api.g_false;
3385: l_old_config_hdr_id NUMBER;
3386: l_config_changed VARCHAR2(1);
3387: BEGIN
3388: -- Standard Start of API savepoint

Line 3391: l_return_status := FND_API.G_RET_STS_SUCCESS;

3387: BEGIN
3388: -- Standard Start of API savepoint
3389: -- SAVEPOINT VALIDATE_CONFIGURATION_INT;
3390:
3391: l_return_status := FND_API.G_RET_STS_SUCCESS;
3392:
3393: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3394: aso_debug_pub.add('ASO_CFG_INT: Validate_Configuration Begins', 1, 'Y');
3395: END IF;

Line 3397: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

3393: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3394: aso_debug_pub.add('ASO_CFG_INT: Validate_Configuration Begins', 1, 'Y');
3395: END IF;
3396:
3397: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3398: p_api_version_number,
3399: l_api_name,
3400: G_PKG_NAME) THEN
3401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3397: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3398: p_api_version_number,
3399: l_api_name,
3400: G_PKG_NAME) THEN
3401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3402: END IF;
3403:
3404: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3405: FND_MSG_PUB.initialize;

Line 3404: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3400: G_PKG_NAME) THEN
3401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3402: END IF;
3403:
3404: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3405: FND_MSG_PUB.initialize;
3406: END IF;
3407:
3408: -- Get model line info

Line 3428: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

3424: aso_debug_pub.add('Validate_Configuration: After call to Create_hdr_xml Length of l_xml_hdr : '||length(l_xml_hdr));
3425:
3426: END IF;
3427:
3428: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3429:
3430: -- Call Send_Input_Xml to call CZ batch validate procedure and get the output XML message
3431:
3432: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 3456: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3452:
3453:
3454: -- extract data from xml message.
3455:
3456: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3457: l_delete_config := fnd_api.g_true;
3458: END IF;
3459:
3460: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 3457: l_delete_config := fnd_api.g_true;

3453:
3454: -- extract data from xml message.
3455:
3456: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3457: l_delete_config := fnd_api.g_true;
3458: END IF;
3459:
3460: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3461: aso_debug_pub.add('Validate_Configuration: Before Call to Parse_Output_xml',1,'N');

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

3479: END IF;
3480:
3481: END IF;
3482:
3483: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) and (l_delete_config = fnd_api.g_false) THEN
3484:
3485: -- Call GET_CONFIG_DETAILS to update the existing configuration
3486: -- Set the Call_batch_validation_flag to FND_API.G_FALSE to avoid recursive call to update_quote
3487:

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

3482:
3483: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) and (l_delete_config = fnd_api.g_false) THEN
3484:
3485: -- Call GET_CONFIG_DETAILS to update the existing configuration
3486: -- Set the Call_batch_validation_flag to FND_API.G_FALSE to avoid recursive call to update_quote
3487:
3488: l_model_line_dtl_tbl(1).valid_configuration_flag := l_valid_configuration_flag;
3489: l_model_line_dtl_tbl(1).complete_configuration_flag := l_complete_configuration_flag;
3490:

Line 3500: p_init_msg_list => FND_API.G_FALSE,

3496: END IF;
3497:
3498: ASO_CFG_INT.Get_config_details(
3499: p_api_version_number => 1.0,
3500: p_init_msg_list => FND_API.G_FALSE,
3501: p_commit => FND_API.G_FALSE,
3502: p_control_rec => p_control_rec,
3503: p_qte_header_rec => l_qte_header_rec,
3504: p_model_line_rec => l_model_line_rec,

Line 3501: p_commit => FND_API.G_FALSE,

3497:
3498: ASO_CFG_INT.Get_config_details(
3499: p_api_version_number => 1.0,
3500: p_init_msg_list => FND_API.G_FALSE,
3501: p_commit => FND_API.G_FALSE,
3502: p_control_rec => p_control_rec,
3503: p_qte_header_rec => l_qte_header_rec,
3504: p_model_line_rec => l_model_line_rec,
3505: p_config_rec => l_model_line_dtl_tbl(1),

Line 3518: l_delete_config := fnd_api.g_true;

3514: aso_debug_pub.add('Validate_Configuration: l_return_status: '||l_return_status);
3515: END IF;
3516:
3517: ELSE
3518: l_delete_config := fnd_api.g_true;
3519: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3520: aso_debug_pub.add('Validate_Configuration: l_delete_config: '||l_delete_config);
3521: END IF;
3522:

Line 3543: if l_delete_config = fnd_api.g_true then

3539: x_return_status := l_return_status;
3540: x_msg_count := l_msg_count;
3541: x_msg_data := l_msg_data;
3542:
3543: if l_delete_config = fnd_api.g_true then
3544:
3545: x_return_status := FND_API.G_RET_STS_ERROR;
3546:
3547: end if;

Line 3545: x_return_status := FND_API.G_RET_STS_ERROR;

3541: x_msg_data := l_msg_data;
3542:
3543: if l_delete_config = fnd_api.g_true then
3544:
3545: x_return_status := FND_API.G_RET_STS_ERROR;
3546:
3547: end if;
3548:
3549: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 3561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3557: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3558: aso_debug_pub.add('Validate_Configuration: Inside WHEN OTHERS EXCEPTION', 1, 'Y');
3559: END IF;
3560:
3561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3562:
3563: END Validate_Configuration;
3564:
3565: