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

Line 36: x_return_status := FND_API.G_RET_STS_SUCCESS;

32:
33: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
34:
35: x_party_id := p_party_id;
36: x_return_status := FND_API.G_RET_STS_SUCCESS;
37: IF (p_party_id IS NOT NULL
38: AND p_party_id <> FND_API.G_MISS_NUM) THEN
39: ASO_UTILITY_PVT.Set_Message(
40: p_msg_level => FND_MSG_PUB.G_MSG_LVL_SUCCESS,

Line 38: AND p_party_id <> FND_API.G_MISS_NUM) THEN

34:
35: x_party_id := p_party_id;
36: x_return_status := FND_API.G_RET_STS_SUCCESS;
37: IF (p_party_id IS NOT NULL
38: AND p_party_id <> FND_API.G_MISS_NUM) THEN
39: ASO_UTILITY_PVT.Set_Message(
40: p_msg_level => FND_MSG_PUB.G_MSG_LVL_SUCCESS,
41: p_msg_name => 'ASO_API_ATTRIBUTE_IGNORED',
42: p_token1 => 'COLUMN',

Line 44: ELSIF (p_person_first_name <> FND_API.G_MISS_CHAR

40: p_msg_level => FND_MSG_PUB.G_MSG_LVL_SUCCESS,
41: p_msg_name => 'ASO_API_ATTRIBUTE_IGNORED',
42: p_token1 => 'COLUMN',
43: p_token1_value => p_column_name);
44: ELSIF (p_person_first_name <> FND_API.G_MISS_CHAR
45: AND p_person_first_name IS NOT NULL)
46: OR (p_party_name <> FND_API.G_MISS_CHAR
47: AND p_party_name IS NOT NULL) THEN
48: l_party_rec.party_id := p_party_id;

Line 46: OR (p_party_name <> FND_API.G_MISS_CHAR

42: p_token1 => 'COLUMN',
43: p_token1_value => p_column_name);
44: ELSIF (p_person_first_name <> FND_API.G_MISS_CHAR
45: AND p_person_first_name IS NOT NULL)
46: OR (p_party_name <> FND_API.G_MISS_CHAR
47: AND p_party_name IS NOT NULL) THEN
48: l_party_rec.party_id := p_party_id;
49: l_party_rec.party_type := p_party_type;
50: l_party_rec.party_name := p_party_name;

Line 90: x_return_status := FND_API.G_RET_STS_SUCCESS;

86:
87: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
88:
89: x_party_site_id := p_party_site_id;
90: x_return_status := FND_API.G_RET_STS_SUCCESS;
91: IF (p_party_site_id IS NOT NULL
92: AND p_party_site_id <> FND_API.G_MISS_NUM) THEN
93: ASO_UTILITY_PVT.Set_Message(
94: p_msg_level => FND_MSG_PUB.G_MSG_LVL_SUCCESS,

Line 92: AND p_party_site_id <> FND_API.G_MISS_NUM) THEN

88:
89: x_party_site_id := p_party_site_id;
90: x_return_status := FND_API.G_RET_STS_SUCCESS;
91: IF (p_party_site_id IS NOT NULL
92: AND p_party_site_id <> FND_API.G_MISS_NUM) THEN
93: ASO_UTILITY_PVT.Set_Message(
94: p_msg_level => FND_MSG_PUB.G_MSG_LVL_SUCCESS,
95: p_msg_name => 'ASO_API_ATTRIBUTE_IGNORED',
96: p_token1 => 'COLUMN',

Line 98: ELSIF (p_address1 <> FND_API.G_MISS_CHAR AND

94: p_msg_level => FND_MSG_PUB.G_MSG_LVL_SUCCESS,
95: p_msg_name => 'ASO_API_ATTRIBUTE_IGNORED',
96: p_token1 => 'COLUMN',
97: p_token1_value => p_column_name);
98: ELSIF (p_address1 <> FND_API.G_MISS_CHAR AND
99: p_address1 IS NOT NULL AND
100: p_country <> FND_API.G_MISS_CHAR AND
101: p_country IS NOT NULL AND
102: p_party_id <> FND_API.G_MISS_NUM AND -- bug 4046692 changed from G_MISS_CHAR to G_MISS_NUM

Line 100: p_country <> FND_API.G_MISS_CHAR AND

96: p_token1 => 'COLUMN',
97: p_token1_value => p_column_name);
98: ELSIF (p_address1 <> FND_API.G_MISS_CHAR AND
99: p_address1 IS NOT NULL AND
100: p_country <> FND_API.G_MISS_CHAR AND
101: p_country IS NOT NULL AND
102: p_party_id <> FND_API.G_MISS_NUM AND -- bug 4046692 changed from G_MISS_CHAR to G_MISS_NUM
103: p_party_id IS NULL) THEN
104: l_party_site_rec.party_id := p_party_id;

Line 102: p_party_id <> FND_API.G_MISS_NUM AND -- bug 4046692 changed from G_MISS_CHAR to G_MISS_NUM

98: ELSIF (p_address1 <> FND_API.G_MISS_CHAR AND
99: p_address1 IS NOT NULL AND
100: p_country <> FND_API.G_MISS_CHAR AND
101: p_country IS NOT NULL AND
102: p_party_id <> FND_API.G_MISS_NUM AND -- bug 4046692 changed from G_MISS_CHAR to G_MISS_NUM
103: p_party_id IS NULL) THEN
104: l_party_site_rec.party_id := p_party_id;
105: l_party_site_rec.party_site_use_type := p_site_use_type;
106: l_party_site_rec.location.address1 := p_address1;

Line 148: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

144: p_person_middle_name => p_qte_header_rec.person_middle_name,
145: p_person_last_name => p_qte_header_rec.person_last_name,
146: x_party_id => x_qte_header_rec.party_id,
147: x_return_status => l_return_status);
148: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
149: l_any_errors := TRUE;
150: END IF;
151: -- invoice_to_party_id
152: Convert_Party_To_Id (

Line 162: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

158: p_person_middle_name => p_qte_header_rec.invoice_to_contact_middle_name,
159: p_person_last_name => p_qte_header_rec.invoice_to_contact_last_name,
160: x_party_id => x_qte_header_rec.invoice_to_party_id,
161: x_return_status => l_return_status);
162: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
163: l_any_errors := TRUE;
164: END IF;
165: -- invoice_to_site_id
166: Convert_Site_To_Id (

Line 183: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

179: p_province => p_qte_header_rec.invoice_to_province,
180: p_county => p_qte_header_rec.invoice_to_county,
181: x_party_site_id => x_qte_header_rec.invoice_to_party_site_id,
182: x_return_status => l_return_status);
183: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
184: l_any_errors := TRUE;
185: END IF;
186: -- no value-to-id conversion for the following fields. If the user wants
187: -- to input any related data, the ID must be passed in.

Line 196: raise FND_API.G_EXC_ERROR;

192: -- order_type_id
193: -- employee_person_id
194: -- price_list_id
195: IF l_any_errors THEN
196: raise FND_API.G_EXC_ERROR;
197: END IF;
198: END;
199:
200: PROCEDURE Convert_Shipment_Values_To_Ids(

Line 223: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

219: p_person_middle_name => p_shipment_rec.ship_to_contact_middle_name,
220: p_person_last_name => p_shipment_rec.ship_to_contact_last_name,
221: x_party_id => x_shipment_rec.ship_to_party_id,
222: x_return_status => l_return_status);
223: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
224: l_any_errors := TRUE;
225: END IF;
226: -- ship_to_site_id
227: Convert_Site_To_Id (

Line 244: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

240: p_province => p_shipment_rec.ship_to_province,
241: p_county => p_shipment_rec.ship_to_county,
242: x_party_site_id => x_shipment_rec.ship_to_party_site_id,
243: x_return_status => l_return_status);
244: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
245: l_any_errors := TRUE;
246: END IF;
247: -- no value-to-id conversion for the following fields. If the user wants
248: -- to input any related data, the CODE must be passed in.

Line 254: raise FND_API.G_EXC_ERROR;

250: -- FREIGHT_TERMS_CODE
251: -- FREIGHT_CARRIER_CODE
252: -- FOB_CODE
253: IF l_any_errors THEN
254: raise FND_API.G_EXC_ERROR;
255: END IF;
256: END;
257:
258: PROCEDURE Convert_Line_Values_To_Ids(

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

267: END;
268:
269: PROCEDURE Create_quote(
270: P_Api_Version_Number IN NUMBER,
271: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
272: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
273: P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
274: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
275: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,

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

268:
269: PROCEDURE Create_quote(
270: P_Api_Version_Number IN NUMBER,
271: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
272: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
273: P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
274: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
275: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
276: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,

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

376:
377:
378: PROCEDURE Update_quote(
379: P_Api_Version_Number IN NUMBER,
380: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
381: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
382: P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
383: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
384: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,

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

377:
378: PROCEDURE Update_quote(
379: P_Api_Version_Number IN NUMBER,
380: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
381: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
382: P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
383: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
384: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
385: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,

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

488: -- The Master delete procedure may not be needed depends on different business requirements.
489:
490: PROCEDURE Delete_quote(
491: P_Api_Version_Number IN NUMBER,
492: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
493: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
494: P_Qte_Header_Id IN NUMBER,
495: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
496: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

489:
490: PROCEDURE Delete_quote(
491: P_Api_Version_Number IN NUMBER,
492: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
493: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
494: P_Qte_Header_Id IN NUMBER,
495: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
496: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
497: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 511: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

507:
508: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
509:
510: -- Standard call to check for call compatibility.
511: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
512: p_api_version_number,
513: l_api_name,
514: G_PKG_NAME) THEN
515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

511: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
512: p_api_version_number,
513: l_api_name,
514: G_PKG_NAME) THEN
515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
516: END IF;
517:
518: -- Initialize message list if p_init_msg_list is set to TRUE.
519: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 519: IF FND_API.to_Boolean( p_init_msg_list ) THEN

515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
516: END IF;
517:
518: -- Initialize message list if p_init_msg_list is set to TRUE.
519: IF FND_API.to_Boolean( p_init_msg_list ) THEN
520: FND_MSG_PUB.initialize;
521: END IF;
522:
523: -- Initialize API return status to SUCCESS

Line 524: x_return_status := FND_API.G_RET_STS_SUCCESS;

520: FND_MSG_PUB.initialize;
521: END IF;
522:
523: -- Initialize API return status to SUCCESS
524: x_return_status := FND_API.G_RET_STS_SUCCESS;
525: l_qte_header_id := P_qte_header_id;
526:
527: --
528: -- API body

Line 540: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

536: X_Return_Status => x_return_status,
537: X_Msg_Count => x_msg_count ,
538: X_Msg_Data => x_msg_data );
539:
540: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
541:
542: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
543: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
544: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Delete_Quote_PRE', FALSE);

Line 548: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

544: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Delete_Quote_PRE', FALSE);
545: FND_MSG_PUB.ADD;
546: END IF;
547:
548: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
550: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
551: RAISE FND_API.G_EXC_ERROR;
552: END IF;

Line 549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

545: FND_MSG_PUB.ADD;
546: END IF;
547:
548: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
550: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
551: RAISE FND_API.G_EXC_ERROR;
552: END IF;
553:

Line 550: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

546: END IF;
547:
548: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
550: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
551: RAISE FND_API.G_EXC_ERROR;
552: END IF;
553:
554: END IF;

Line 551: RAISE FND_API.G_EXC_ERROR;

547:
548: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
550: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
551: RAISE FND_API.G_EXC_ERROR;
552: END IF;
553:
554: END IF;
555:

Line 566: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

562: X_Return_Status => x_return_status,
563: X_Msg_Count => x_msg_count,
564: x_Msg_Data => x_msg_data );
565:
566: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
567:
568: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
569: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
570: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Delete_Quote_PRE', FALSE);

Line 574: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

570: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Delete_Quote_PRE', FALSE);
571: FND_MSG_PUB.ADD;
572: END IF;
573:
574: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
576: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
577: RAISE FND_API.G_EXC_ERROR;
578: END IF;

Line 575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

571: FND_MSG_PUB.ADD;
572: END IF;
573:
574: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
576: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
577: RAISE FND_API.G_EXC_ERROR;
578: END IF;
579:

Line 576: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

572: END IF;
573:
574: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
576: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
577: RAISE FND_API.G_EXC_ERROR;
578: END IF;
579:
580: END IF;

Line 577: RAISE FND_API.G_EXC_ERROR;

573:
574: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
576: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
577: RAISE FND_API.G_EXC_ERROR;
578: END IF;
579:
580: END IF;
581:

Line 585: P_Init_Msg_List => FND_API.G_FALSE,

581:
582: END IF; -- vertical hook
583:
584: ASO_QUOTE_HEADERS_PVT.Delete_quote( P_Api_Version_Number => 1.0,
585: P_Init_Msg_List => FND_API.G_FALSE,
586: P_Commit => p_commit,
587: P_Qte_Header_ID => l_Qte_Header_Id,
588: X_Return_Status => x_return_status,
589: X_Msg_Count => x_msg_count,

Line 593: IF x_return_status = FND_API.G_RET_STS_ERROR then

589: X_Msg_Count => x_msg_count,
590: X_Msg_Data => x_msg_data);
591:
592: -- Check return status from the above procedure call
593: IF x_return_status = FND_API.G_RET_STS_ERROR then
594: raise FND_API.G_EXC_ERROR;
595: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
596: raise FND_API.G_EXC_UNEXPECTED_ERROR;
597: END IF;

Line 594: raise FND_API.G_EXC_ERROR;

590: X_Msg_Data => x_msg_data);
591:
592: -- Check return status from the above procedure call
593: IF x_return_status = FND_API.G_RET_STS_ERROR then
594: raise FND_API.G_EXC_ERROR;
595: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
596: raise FND_API.G_EXC_UNEXPECTED_ERROR;
597: END IF;
598:

Line 595: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

591:
592: -- Check return status from the above procedure call
593: IF x_return_status = FND_API.G_RET_STS_ERROR then
594: raise FND_API.G_EXC_ERROR;
595: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
596: raise FND_API.G_EXC_UNEXPECTED_ERROR;
597: END IF;
598:
599: IF (JTF_USR_HKS.ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'C')) THEN

Line 596: raise FND_API.G_EXC_UNEXPECTED_ERROR;

592: -- Check return status from the above procedure call
593: IF x_return_status = FND_API.G_RET_STS_ERROR then
594: raise FND_API.G_EXC_ERROR;
595: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
596: raise FND_API.G_EXC_UNEXPECTED_ERROR;
597: END IF;
598:
599: IF (JTF_USR_HKS.ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'C')) THEN
600:

Line 606: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

602: X_Return_Status => x_return_status,
603: X_Msg_Count => x_msg_count,
604: X_Msg_Data => x_msg_data );
605:
606: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
607:
608: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
609: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
610: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Delete_Quote_POST', FALSE);

Line 614: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

610: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Delete_Quote_POST', FALSE);
611: FND_MSG_PUB.ADD;
612: END IF;
613:
614: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
615: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
616: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
617: RAISE FND_API.G_EXC_ERROR;
618: END IF;

Line 615: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

611: FND_MSG_PUB.ADD;
612: END IF;
613:
614: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
615: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
616: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
617: RAISE FND_API.G_EXC_ERROR;
618: END IF;
619:

Line 616: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

612: END IF;
613:
614: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
615: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
616: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
617: RAISE FND_API.G_EXC_ERROR;
618: END IF;
619:
620: END IF;

Line 617: RAISE FND_API.G_EXC_ERROR;

613:
614: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
615: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
616: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
617: RAISE FND_API.G_EXC_ERROR;
618: END IF;
619:
620: END IF;
621:

Line 632: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

628: X_Return_Status => x_return_status,
629: X_Msg_Count => x_msg_count,
630: X_Msg_Data => x_msg_data );
631:
632: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
633:
634: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
635: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
636: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Delete_Quote_POST', FALSE);

Line 640: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

636: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Delete_Quote_POST', FALSE);
637: FND_MSG_PUB.ADD;
638: END IF;
639:
640: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
642: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
643: RAISE FND_API.G_EXC_ERROR;
644: END IF;

Line 641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

637: FND_MSG_PUB.ADD;
638: END IF;
639:
640: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
642: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
643: RAISE FND_API.G_EXC_ERROR;
644: END IF;
645:

Line 642: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

638: END IF;
639:
640: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
642: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
643: RAISE FND_API.G_EXC_ERROR;
644: END IF;
645:
646: END IF;

Line 643: RAISE FND_API.G_EXC_ERROR;

639:
640: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
642: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
643: RAISE FND_API.G_EXC_ERROR;
644: END IF;
645:
646: END IF;
647:

Line 655: IF FND_API.to_Boolean( p_commit ) THEN

651: -- End of API body
652: --
653:
654: -- Standard check for p_commit
655: IF FND_API.to_Boolean( p_commit ) THEN
656: COMMIT WORK;
657: END IF;
658:
659: -- Standard call to get message count and if count is 1, get message info.

Line 665: WHEN FND_API.G_EXC_ERROR THEN

661: p_data => x_msg_data );
662:
663: EXCEPTION
664:
665: WHEN FND_API.G_EXC_ERROR THEN
666:
667: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
668: P_API_NAME => L_API_NAME
669: ,P_PKG_NAME => G_PKG_NAME

Line 676: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

672: ,X_MSG_COUNT => X_MSG_COUNT
673: ,X_MSG_DATA => X_MSG_DATA
674: ,X_RETURN_STATUS => X_RETURN_STATUS);
675:
676: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
677:
678: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
679: P_API_NAME => L_API_NAME
680: ,P_PKG_NAME => G_PKG_NAME

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

698:
699:
700: PROCEDURE Get_quote(
701: P_Api_Version_Number IN NUMBER,
702: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
703: P_Qte_Header_Rec IN Qte_Header_Rec_Type,
704: -- Hint: Add list of bind variables here
705: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
706: p_start_rec_prt IN NUMBER := 1,

Line 707: p_return_tot_count IN NUMBER := FND_API.G_FALSE,

703: P_Qte_Header_Rec IN Qte_Header_Rec_Type,
704: -- Hint: Add list of bind variables here
705: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
706: p_start_rec_prt IN NUMBER := 1,
707: p_return_tot_count IN NUMBER := FND_API.G_FALSE,
708: -- Hint: user defined record type
709: p_order_by_rec IN QTE_sort_rec_type,
710: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
711: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 731: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

727:
728: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
729:
730: -- Standard call to check for call compatibility.
731: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
732: p_api_version_number,
733: l_api_name,
734: G_PKG_NAME)
735: THEN

Line 736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

732: p_api_version_number,
733: l_api_name,
734: G_PKG_NAME)
735: THEN
736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
737: END IF;
738:
739:
740: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 741: IF FND_API.to_Boolean( p_init_msg_list )

737: END IF;
738:
739:
740: -- Initialize message list if p_init_msg_list is set to TRUE.
741: IF FND_API.to_Boolean( p_init_msg_list )
742: THEN
743: FND_MSG_PUB.initialize;
744: END IF;
745:

Line 750: x_return_status := FND_API.G_RET_STS_SUCCESS;

746:
747:
748:
749: -- Initialize API return status to SUCCESS
750: x_return_status := FND_API.G_RET_STS_SUCCESS;
751:
752: --
753: -- API body
754: --

Line 757: P_Init_Msg_List => FND_API.G_FALSE,

753: -- API body
754: --
755: ASO_QUOTE_HEADERS_PVT.Get_quote(
756: P_Api_Version_Number => 1.0,
757: P_Init_Msg_List => FND_API.G_FALSE,
758: P_Qte_Header_Rec => P_Qte_Header_Rec,
759: p_rec_requested => p_rec_requested,
760: p_start_rec_prt => p_start_rec_prt,
761: p_return_tot_count => p_return_tot_count,

Line 776: IF x_return_status = FND_API.G_RET_STS_ERROR then

772:
773:
774:
775: -- Check return status from the above procedure call
776: IF x_return_status = FND_API.G_RET_STS_ERROR then
777: raise FND_API.G_EXC_ERROR;
778: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
779: raise FND_API.G_EXC_UNEXPECTED_ERROR;
780: END IF;

Line 777: raise FND_API.G_EXC_ERROR;

773:
774:
775: -- Check return status from the above procedure call
776: IF x_return_status = FND_API.G_RET_STS_ERROR then
777: raise FND_API.G_EXC_ERROR;
778: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
779: raise FND_API.G_EXC_UNEXPECTED_ERROR;
780: END IF;
781:

Line 778: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

774:
775: -- Check return status from the above procedure call
776: IF x_return_status = FND_API.G_RET_STS_ERROR then
777: raise FND_API.G_EXC_ERROR;
778: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
779: raise FND_API.G_EXC_UNEXPECTED_ERROR;
780: END IF;
781:
782: --

Line 779: raise FND_API.G_EXC_UNEXPECTED_ERROR;

775: -- Check return status from the above procedure call
776: IF x_return_status = FND_API.G_RET_STS_ERROR then
777: raise FND_API.G_EXC_ERROR;
778: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
779: raise FND_API.G_EXC_UNEXPECTED_ERROR;
780: END IF;
781:
782: --
783: -- End of API body

Line 795: WHEN FND_API.G_EXC_ERROR THEN

791: p_data => x_msg_data
792: );
793:
794: EXCEPTION
795: WHEN FND_API.G_EXC_ERROR THEN
796: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
797: P_API_NAME => L_API_NAME
798: ,P_PKG_NAME => G_PKG_NAME
799: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 805: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

801: ,X_MSG_COUNT => X_MSG_COUNT
802: ,X_MSG_DATA => X_MSG_DATA
803: ,X_RETURN_STATUS => X_RETURN_STATUS);
804:
805: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
806: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
807: P_API_NAME => L_API_NAME
808: ,P_PKG_NAME => G_PKG_NAME
809: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

824: End Get_quote;
825:
826: PROCEDURE Validate_quote(
827: P_Api_Version_Number IN NUMBER,
828: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
829: P_Qte_Header_Id IN NUMBER,
830: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
831: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
832: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 844: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

840:
841: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
842:
843: -- Standard call to check for call compatibility.
844: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
845: p_api_version_number,
846: l_api_name,
847: G_PKG_NAME)
848: THEN

Line 849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

845: p_api_version_number,
846: l_api_name,
847: G_PKG_NAME)
848: THEN
849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
850: END IF;
851:
852:
853: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 854: IF FND_API.to_Boolean( p_init_msg_list )

850: END IF;
851:
852:
853: -- Initialize message list if p_init_msg_list is set to TRUE.
854: IF FND_API.to_Boolean( p_init_msg_list )
855: THEN
856: FND_MSG_PUB.initialize;
857: END IF;
858:

Line 863: x_return_status := FND_API.G_RET_STS_SUCCESS;

859:
860:
861:
862: -- Initialize API return status to SUCCESS
863: x_return_status := FND_API.G_RET_STS_SUCCESS;
864:
865: --
866: -- API body
867: --

Line 872: P_Init_Msg_List => FND_API.G_FALSE,

868:
869:
870: ASO_QUOTE_HEADERS_PVT.Validate_Quote(
871: P_Api_Version_Number => 1.0,
872: P_Init_Msg_List => FND_API.G_FALSE,
873: P_Qte_Header_Id => p_qte_header_id,
874: X_Return_Status => x_return_status,
875: X_Msg_Count => x_msg_count,
876: X_Msg_Data => x_msg_data);

Line 879: IF x_return_status = FND_API.G_RET_STS_ERROR then

875: X_Msg_Count => x_msg_count,
876: X_Msg_Data => x_msg_data);
877:
878: -- Check return status from the above procedure call
879: IF x_return_status = FND_API.G_RET_STS_ERROR then
880: raise FND_API.G_EXC_ERROR;
881: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
882: raise FND_API.G_EXC_UNEXPECTED_ERROR;
883: END IF;

Line 880: raise FND_API.G_EXC_ERROR;

876: X_Msg_Data => x_msg_data);
877:
878: -- Check return status from the above procedure call
879: IF x_return_status = FND_API.G_RET_STS_ERROR then
880: raise FND_API.G_EXC_ERROR;
881: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
882: raise FND_API.G_EXC_UNEXPECTED_ERROR;
883: END IF;
884:

Line 881: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

877:
878: -- Check return status from the above procedure call
879: IF x_return_status = FND_API.G_RET_STS_ERROR then
880: raise FND_API.G_EXC_ERROR;
881: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
882: raise FND_API.G_EXC_UNEXPECTED_ERROR;
883: END IF;
884:
885: --

Line 882: raise FND_API.G_EXC_UNEXPECTED_ERROR;

878: -- Check return status from the above procedure call
879: IF x_return_status = FND_API.G_RET_STS_ERROR then
880: raise FND_API.G_EXC_ERROR;
881: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
882: raise FND_API.G_EXC_UNEXPECTED_ERROR;
883: END IF;
884:
885: --
886: -- End of API body

Line 898: WHEN FND_API.G_EXC_ERROR THEN

894: p_data => x_msg_data
895: );
896:
897: EXCEPTION
898: WHEN FND_API.G_EXC_ERROR THEN
899: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
900: P_API_NAME => L_API_NAME
901: ,P_PKG_NAME => G_PKG_NAME
902: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

904: ,X_MSG_COUNT => X_MSG_COUNT
905: ,X_MSG_DATA => X_MSG_DATA
906: ,X_RETURN_STATUS => X_RETURN_STATUS);
907:
908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
909: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
910: P_API_NAME => L_API_NAME
911: ,P_PKG_NAME => G_PKG_NAME
912: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

927: END Validate_Quote;
928:
929: PROCEDURE Submit_quote(
930: P_Api_Version_Number IN NUMBER,
931: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
932: P_control_rec IN Submit_Control_Rec_Type
933: := g_miss_Submit_Control_Rec,
934: P_Qte_Header_Id IN NUMBER,
935: x_order_header_rec OUT NOCOPY /* file.sql.39 change */ Order_Header_Rec_Type,

Line 953: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

949:
950: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
951:
952: -- Standard call to check for call compatibility.
953: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
954: p_api_version_number,
955: l_api_name,
956: G_PKG_NAME)
957: THEN

Line 958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

954: p_api_version_number,
955: l_api_name,
956: G_PKG_NAME)
957: THEN
958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
959: END IF;
960:
961:
962: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 963: IF FND_API.to_Boolean( p_init_msg_list )

959: END IF;
960:
961:
962: -- Initialize message list if p_init_msg_list is set to TRUE.
963: IF FND_API.to_Boolean( p_init_msg_list )
964: THEN
965: FND_MSG_PUB.initialize;
966: END IF;
967:

Line 972: x_return_status := FND_API.G_RET_STS_SUCCESS;

968:
969:
970:
971: -- Initialize API return status to SUCCESS
972: x_return_status := FND_API.G_RET_STS_SUCCESS;
973: l_Qte_Header_Id := P_Qte_Header_Id;
974:
975: --
976: -- API body

Line 986: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

982: P_Qte_Header_Id => l_Qte_Header_Id,
983: X_Return_Status => X_Return_Status,
984: X_Msg_Count => X_Msg_Count,
985: X_Msg_Data => X_Msg_Data );
986: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
987: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
988: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
989: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Submit_Quote_PRE', FALSE);
990: FND_MSG_PUB.ADD;

Line 992: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

988: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
989: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Submit_Quote_PRE', FALSE);
990: FND_MSG_PUB.ADD;
991: END IF;
992: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
994: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
995: RAISE FND_API.G_EXC_ERROR;
996: END IF;

Line 993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

989: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Submit_Quote_PRE', FALSE);
990: FND_MSG_PUB.ADD;
991: END IF;
992: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
994: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
995: RAISE FND_API.G_EXC_ERROR;
996: END IF;
997: END IF;

Line 994: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

990: FND_MSG_PUB.ADD;
991: END IF;
992: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
994: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
995: RAISE FND_API.G_EXC_ERROR;
996: END IF;
997: END IF;
998: END IF; -- customer hook

Line 995: RAISE FND_API.G_EXC_ERROR;

991: END IF;
992: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
994: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
995: RAISE FND_API.G_EXC_ERROR;
996: END IF;
997: END IF;
998: END IF; -- customer hook
999: -- vertical hook

Line 1007: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1003: P_Qte_Header_Id => l_Qte_Header_Id,
1004: X_Return_Status => X_Return_Status,
1005: X_Msg_Count => X_Msg_Count,
1006: X_Msg_Data => X_Msg_Data );
1007: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1008: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1009: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1010: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Submit_Quote_PRE', FALSE);
1011: FND_MSG_PUB.ADD;

Line 1013: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1009: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1010: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Submit_Quote_PRE', FALSE);
1011: FND_MSG_PUB.ADD;
1012: END IF;
1013: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1015: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1016: RAISE FND_API.G_EXC_ERROR;
1017: END IF;

Line 1014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1010: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Submit_Quote_PRE', FALSE);
1011: FND_MSG_PUB.ADD;
1012: END IF;
1013: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1015: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1016: RAISE FND_API.G_EXC_ERROR;
1017: END IF;
1018: END IF;

Line 1015: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

1011: FND_MSG_PUB.ADD;
1012: END IF;
1013: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1015: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1016: RAISE FND_API.G_EXC_ERROR;
1017: END IF;
1018: END IF;
1019: END IF;

Line 1016: RAISE FND_API.G_EXC_ERROR;

1012: END IF;
1013: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1015: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1016: RAISE FND_API.G_EXC_ERROR;
1017: END IF;
1018: END IF;
1019: END IF;
1020:

Line 1022: l_qte_header_rec.last_update_date := FND_API.G_MISS_DATE;

1018: END IF;
1019: END IF;
1020:
1021: l_qte_header_rec.quote_header_id := l_Qte_Header_Id;
1022: l_qte_header_rec.last_update_date := FND_API.G_MISS_DATE;
1023:
1024: ASO_SUBMIT_QUOTE_PVT.Submit_Quote(
1025: P_Api_Version_Number => 1.0,
1026: P_Init_Msg_List => p_init_msg_list,

Line 1035: IF x_return_status = FND_API.G_RET_STS_ERROR then

1031: X_Msg_Count => x_msg_count,
1032: X_Msg_Data => x_msg_data);
1033:
1034: -- Check return status from the above procedure call
1035: IF x_return_status = FND_API.G_RET_STS_ERROR then
1036: raise FND_API.G_EXC_ERROR;
1037: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1038: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1039: END IF;

Line 1036: raise FND_API.G_EXC_ERROR;

1032: X_Msg_Data => x_msg_data);
1033:
1034: -- Check return status from the above procedure call
1035: IF x_return_status = FND_API.G_RET_STS_ERROR then
1036: raise FND_API.G_EXC_ERROR;
1037: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1038: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1039: END IF;
1040:

Line 1037: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

1033:
1034: -- Check return status from the above procedure call
1035: IF x_return_status = FND_API.G_RET_STS_ERROR then
1036: raise FND_API.G_EXC_ERROR;
1037: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1038: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1039: END IF;
1040:
1041: -- call user hooks

Line 1038: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1034: -- Check return status from the above procedure call
1035: IF x_return_status = FND_API.G_RET_STS_ERROR then
1036: raise FND_API.G_EXC_ERROR;
1037: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1038: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1039: END IF;
1040:
1041: -- call user hooks
1042: -- customer post processing

Line 1053: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1049: X_Return_Status => X_Return_Status,
1050: X_Msg_Count => X_Msg_Count,
1051: X_Msg_Data => X_Msg_Data );
1052:
1053: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1054: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1055: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1056: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Submit_Quote_POST', FALSE);
1057: FND_MSG_PUB.ADD;

Line 1059: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1055: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1056: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Submit_Quote_POST', FALSE);
1057: FND_MSG_PUB.ADD;
1058: END IF;
1059: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1061: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1062: RAISE FND_API.G_EXC_ERROR;
1063: END IF;

Line 1060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1056: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Submit_Quote_POST', FALSE);
1057: FND_MSG_PUB.ADD;
1058: END IF;
1059: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1061: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1062: RAISE FND_API.G_EXC_ERROR;
1063: END IF;
1064: END IF;

Line 1061: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

1057: FND_MSG_PUB.ADD;
1058: END IF;
1059: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1061: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1062: RAISE FND_API.G_EXC_ERROR;
1063: END IF;
1064: END IF;
1065: END IF; -- customer hook

Line 1062: RAISE FND_API.G_EXC_ERROR;

1058: END IF;
1059: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1061: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1062: RAISE FND_API.G_EXC_ERROR;
1063: END IF;
1064: END IF;
1065: END IF; -- customer hook
1066:

Line 1075: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1071: p_order_header_rec => x_order_header_rec,
1072: X_Return_Status => X_Return_Status,
1073: X_Msg_Count => X_Msg_Count,
1074: X_Msg_Data => X_Msg_Data );
1075: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1076: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1077: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1078: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Submit_Quote_POST', FALSE);
1079: FND_MSG_PUB.ADD;

Line 1081: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1077: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1078: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Submit_Quote_POST', FALSE);
1079: FND_MSG_PUB.ADD;
1080: END IF;
1081: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1083: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1084: RAISE FND_API.G_EXC_ERROR;
1085: END IF;

Line 1082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1078: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Submit_Quote_POST', FALSE);
1079: FND_MSG_PUB.ADD;
1080: END IF;
1081: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1083: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1084: RAISE FND_API.G_EXC_ERROR;
1085: END IF;
1086: END IF;

Line 1083: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

1079: FND_MSG_PUB.ADD;
1080: END IF;
1081: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1083: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1084: RAISE FND_API.G_EXC_ERROR;
1085: END IF;
1086: END IF;
1087: END IF; -- vertical hook

Line 1084: RAISE FND_API.G_EXC_ERROR;

1080: END IF;
1081: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1083: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1084: RAISE FND_API.G_EXC_ERROR;
1085: END IF;
1086: END IF;
1087: END IF; -- vertical hook
1088: --

Line 1102: WHEN FND_API.G_EXC_ERROR THEN

1098: p_data => x_msg_data
1099: );
1100:
1101: EXCEPTION
1102: WHEN FND_API.G_EXC_ERROR THEN
1103: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1104: P_API_NAME => L_API_NAME
1105: ,P_PKG_NAME => G_PKG_NAME
1106: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1112: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1108: ,X_MSG_COUNT => X_MSG_COUNT
1109: ,X_MSG_DATA => X_MSG_DATA
1110: ,X_RETURN_STATUS => X_RETURN_STATUS);
1111:
1112: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1113: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1114: P_API_NAME => L_API_NAME
1115: ,P_PKG_NAME => G_PKG_NAME
1116: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

1132:
1133:
1134: PROCEDURE Copy_quote(
1135: P_Api_Version_Number IN NUMBER,
1136: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1137: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1138: P_Qte_Header_Id IN NUMBER,
1139: P_Last_Update_Date IN DATE,
1140: P_Copy_Only_Header IN VARCHAR2 := FND_API.G_FALSE,

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

1133:
1134: PROCEDURE Copy_quote(
1135: P_Api_Version_Number IN NUMBER,
1136: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1137: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1138: P_Qte_Header_Id IN NUMBER,
1139: P_Last_Update_Date IN DATE,
1140: P_Copy_Only_Header IN VARCHAR2 := FND_API.G_FALSE,
1141: P_New_Version IN VARCHAR2 := FND_API.G_FALSE,

Line 1140: P_Copy_Only_Header IN VARCHAR2 := FND_API.G_FALSE,

1136: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1137: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1138: P_Qte_Header_Id IN NUMBER,
1139: P_Last_Update_Date IN DATE,
1140: P_Copy_Only_Header IN VARCHAR2 := FND_API.G_FALSE,
1141: P_New_Version IN VARCHAR2 := FND_API.G_FALSE,
1142: P_Qte_Status_Id IN NUMBER := NULL,
1143: P_Qte_Number IN NUMBER := NULL,
1144: X_Qte_Header_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 1141: P_New_Version IN VARCHAR2 := FND_API.G_FALSE,

1137: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1138: P_Qte_Header_Id IN NUMBER,
1139: P_Last_Update_Date IN DATE,
1140: P_Copy_Only_Header IN VARCHAR2 := FND_API.G_FALSE,
1141: P_New_Version IN VARCHAR2 := FND_API.G_FALSE,
1142: P_Qte_Status_Id IN NUMBER := NULL,
1143: P_Qte_Number IN NUMBER := NULL,
1144: X_Qte_Header_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
1145: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 1167: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1163:
1164: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1165:
1166: -- Standard call to check for call compatibility.
1167: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1168: p_api_version_number,
1169: l_api_name,
1170: G_PKG_NAME)
1171: THEN

Line 1172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1168: p_api_version_number,
1169: l_api_name,
1170: G_PKG_NAME)
1171: THEN
1172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1173: END IF;
1174:
1175:
1176: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1177: IF FND_API.to_Boolean( p_init_msg_list )

1173: END IF;
1174:
1175:
1176: -- Initialize message list if p_init_msg_list is set to TRUE.
1177: IF FND_API.to_Boolean( p_init_msg_list )
1178: THEN
1179: FND_MSG_PUB.initialize;
1180: END IF;
1181:

Line 1186: x_return_status := FND_API.G_RET_STS_SUCCESS;

1182:
1183:
1184:
1185: -- Initialize API return status to SUCCESS
1186: x_return_status := FND_API.G_RET_STS_SUCCESS;
1187:
1188: --
1189: -- API body
1190: --

Line 1212: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1208: X_Return_Status => X_Return_Status ,
1209: X_Msg_Count => X_Msg_Count,
1210: X_Msg_Data => X_Msg_Data
1211: );
1212: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1213: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1214: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1215: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Copy_Quote_PRE', FALSE);
1216: FND_MSG_PUB.ADD;

Line 1218: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1214: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1215: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Copy_Quote_PRE', FALSE);
1216: FND_MSG_PUB.ADD;
1217: END IF;
1218: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1220: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1221: RAISE FND_API.G_EXC_ERROR;
1222: END IF;

Line 1219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1215: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Copy_Quote_PRE', FALSE);
1216: FND_MSG_PUB.ADD;
1217: END IF;
1218: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1220: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1221: RAISE FND_API.G_EXC_ERROR;
1222: END IF;
1223: END IF;

Line 1220: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

1216: FND_MSG_PUB.ADD;
1217: END IF;
1218: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1220: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1221: RAISE FND_API.G_EXC_ERROR;
1222: END IF;
1223: END IF;
1224: END IF; -- customer hook

Line 1221: RAISE FND_API.G_EXC_ERROR;

1217: END IF;
1218: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1220: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1221: RAISE FND_API.G_EXC_ERROR;
1222: END IF;
1223: END IF;
1224: END IF; -- customer hook
1225: -- vertical hook

Line 1238: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1234: X_Return_Status => X_Return_Status ,
1235: X_Msg_Count => X_Msg_Count,
1236: X_Msg_Data => X_Msg_Data
1237: );
1238: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1239: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1240: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1241: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Copy_Quote_PRE', FALSE);
1242: FND_MSG_PUB.ADD;

Line 1244: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1240: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1241: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Copy_Quote_PRE', FALSE);
1242: FND_MSG_PUB.ADD;
1243: END IF;
1244: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1246: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1247: RAISE FND_API.G_EXC_ERROR;
1248: END IF;

Line 1245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1241: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Copy_Quote_PRE', FALSE);
1242: FND_MSG_PUB.ADD;
1243: END IF;
1244: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1246: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1247: RAISE FND_API.G_EXC_ERROR;
1248: END IF;
1249: END IF;

Line 1246: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

1242: FND_MSG_PUB.ADD;
1243: END IF;
1244: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1246: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1247: RAISE FND_API.G_EXC_ERROR;
1248: END IF;
1249: END IF;
1250: END IF;

Line 1247: RAISE FND_API.G_EXC_ERROR;

1243: END IF;
1244: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1246: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1247: RAISE FND_API.G_EXC_ERROR;
1248: END IF;
1249: END IF;
1250: END IF;
1251:

Line 1255: P_Init_Msg_List => FND_API.G_FALSE,

1251:
1252:
1253: ASO_QUOTE_HEADERS_PVT.Copy_Quote(
1254: P_Api_Version_Number => 1.0,
1255: P_Init_Msg_List => FND_API.G_FALSE,
1256: P_Commit => p_commit,
1257: P_Qte_Header_Id => p_qte_header_id,
1258: P_control_rec => l_control_rec,
1259: P_Last_Update_Date => p_last_update_date,

Line 1272: IF x_return_status = FND_API.G_RET_STS_ERROR then

1268:
1269:
1270:
1271: -- Check return status from the above procedure call
1272: IF x_return_status = FND_API.G_RET_STS_ERROR then
1273: raise FND_API.G_EXC_ERROR;
1274: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1275: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1276: END IF;

Line 1273: raise FND_API.G_EXC_ERROR;

1269:
1270:
1271: -- Check return status from the above procedure call
1272: IF x_return_status = FND_API.G_RET_STS_ERROR then
1273: raise FND_API.G_EXC_ERROR;
1274: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1275: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1276: END IF;
1277:

Line 1274: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

1270:
1271: -- Check return status from the above procedure call
1272: IF x_return_status = FND_API.G_RET_STS_ERROR then
1273: raise FND_API.G_EXC_ERROR;
1274: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1275: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1276: END IF;
1277:
1278: l_NEW_Qte_Header_Id := x_qte_header_id;

Line 1275: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1271: -- Check return status from the above procedure call
1272: IF x_return_status = FND_API.G_RET_STS_ERROR then
1273: raise FND_API.G_EXC_ERROR;
1274: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1275: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1276: END IF;
1277:
1278: l_NEW_Qte_Header_Id := x_qte_header_id;
1279:

Line 1293: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1289: X_Return_Status => X_Return_Status ,
1290: X_Msg_Count => X_Msg_Count,
1291: X_Msg_Data => X_Msg_Data
1292: );
1293: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1294: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1295: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1296: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Copy_Quote_POST', FALSE);
1297: FND_MSG_PUB.ADD;

Line 1299: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1295: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1296: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Copy_Quote_POST', FALSE);
1297: FND_MSG_PUB.ADD;
1298: END IF;
1299: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1301: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1302: RAISE FND_API.G_EXC_ERROR;
1303: END IF;

Line 1300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1296: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Copy_Quote_POST', FALSE);
1297: FND_MSG_PUB.ADD;
1298: END IF;
1299: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1301: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1302: RAISE FND_API.G_EXC_ERROR;
1303: END IF;
1304: END IF;

Line 1301: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

1297: FND_MSG_PUB.ADD;
1298: END IF;
1299: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1301: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1302: RAISE FND_API.G_EXC_ERROR;
1303: END IF;
1304: END IF;
1305: END IF; -- customer hook

Line 1302: RAISE FND_API.G_EXC_ERROR;

1298: END IF;
1299: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1301: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1302: RAISE FND_API.G_EXC_ERROR;
1303: END IF;
1304: END IF;
1305: END IF; -- customer hook
1306: IF (JTF_USR_HKS.ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'V')) THEN

Line 1319: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1315: X_Return_Status => X_Return_Status ,
1316: X_Msg_Count => X_Msg_Count,
1317: X_Msg_Data => X_Msg_Data
1318: );
1319: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1320: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1321: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1322: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Copy_Quote_POST', FALSE);
1323: FND_MSG_PUB.ADD;

Line 1325: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1321: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1322: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Copy_Quote_POST', FALSE);
1323: FND_MSG_PUB.ADD;
1324: END IF;
1325: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1327: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1328: RAISE FND_API.G_EXC_ERROR;
1329: END IF;

Line 1326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1322: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Copy_Quote_POST', FALSE);
1323: FND_MSG_PUB.ADD;
1324: END IF;
1325: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1327: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1328: RAISE FND_API.G_EXC_ERROR;
1329: END IF;
1330: END IF;

Line 1327: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

1323: FND_MSG_PUB.ADD;
1324: END IF;
1325: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1327: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1328: RAISE FND_API.G_EXC_ERROR;
1329: END IF;
1330: END IF;
1331: END IF;

Line 1328: RAISE FND_API.G_EXC_ERROR;

1324: END IF;
1325: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1327: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1328: RAISE FND_API.G_EXC_ERROR;
1329: END IF;
1330: END IF;
1331: END IF;
1332: --

Line 1337: IF FND_API.to_Boolean( p_commit )

1333: -- End of API body
1334: --
1335:
1336: -- Standard check for p_commit
1337: IF FND_API.to_Boolean( p_commit )
1338: THEN
1339: COMMIT WORK;
1340: END IF;
1341:

Line 1352: WHEN FND_API.G_EXC_ERROR THEN

1348: p_data => x_msg_data
1349: );
1350:
1351: EXCEPTION
1352: WHEN FND_API.G_EXC_ERROR THEN
1353: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1354: P_API_NAME => L_API_NAME
1355: ,P_PKG_NAME => G_PKG_NAME
1356: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1358: ,X_MSG_COUNT => X_MSG_COUNT
1359: ,X_MSG_DATA => X_MSG_DATA
1360: ,X_RETURN_STATUS => X_RETURN_STATUS);
1361:
1362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1363: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1364: P_API_NAME => L_API_NAME
1365: ,P_PKG_NAME => G_PKG_NAME
1366: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

1384: -- Overloaded Copy_quote
1385:
1386: PROCEDURE Copy_quote(
1387: P_Api_Version_Number IN NUMBER,
1388: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1389: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1390: P_control_rec IN Control_Rec_Type,
1391: P_Qte_Header_Id IN NUMBER,
1392: P_Last_Update_Date IN DATE,

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

1385:
1386: PROCEDURE Copy_quote(
1387: P_Api_Version_Number IN NUMBER,
1388: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1389: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1390: P_control_rec IN Control_Rec_Type,
1391: P_Qte_Header_Id IN NUMBER,
1392: P_Last_Update_Date IN DATE,
1393: P_Copy_Only_Header IN VARCHAR2 := FND_API.G_FALSE,

Line 1393: P_Copy_Only_Header IN VARCHAR2 := FND_API.G_FALSE,

1389: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1390: P_control_rec IN Control_Rec_Type,
1391: P_Qte_Header_Id IN NUMBER,
1392: P_Last_Update_Date IN DATE,
1393: P_Copy_Only_Header IN VARCHAR2 := FND_API.G_FALSE,
1394: P_New_Version IN VARCHAR2 := FND_API.G_FALSE,
1395: P_Qte_Status_Id IN NUMBER := NULL,
1396: P_Qte_Number IN NUMBER := NULL,
1397: X_Qte_Header_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 1394: P_New_Version IN VARCHAR2 := FND_API.G_FALSE,

1390: P_control_rec IN Control_Rec_Type,
1391: P_Qte_Header_Id IN NUMBER,
1392: P_Last_Update_Date IN DATE,
1393: P_Copy_Only_Header IN VARCHAR2 := FND_API.G_FALSE,
1394: P_New_Version IN VARCHAR2 := FND_API.G_FALSE,
1395: P_Qte_Status_Id IN NUMBER := NULL,
1396: P_Qte_Number IN NUMBER := NULL,
1397: X_Qte_Header_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
1398: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 1419: P_Init_Msg_List => FND_API.G_FALSE,

1415: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1416:
1417: ASO_QUOTE_HEADERS_PVT.Copy_Quote(
1418: P_Api_Version_Number => 1.0,
1419: P_Init_Msg_List => FND_API.G_FALSE,
1420: P_Commit => p_commit,
1421: P_control_rec => P_control_rec,
1422: P_Qte_Header_Id => p_qte_header_id,
1423: P_Last_Update_Date => p_last_update_date,

Line 1445: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

1441: -- Pre-Req :
1442: -- Parameters:
1443: -- IN
1444: -- p_api_version_number IN NUMBER Required
1445: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
1446: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
1447: -- P_qte_lines_Rec IN qte_line_Rec_Type Required
1448: -- P_quote_header_id IN NUMBER Required
1449: -- P_header_last_update_date IN DATE Required

Line 1446: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

1442: -- Parameters:
1443: -- IN
1444: -- p_api_version_number IN NUMBER Required
1445: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
1446: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
1447: -- P_qte_lines_Rec IN qte_line_Rec_Type Required
1448: -- P_quote_header_id IN NUMBER Required
1449: -- P_header_last_update_date IN DATE Required
1450: -- P_Payment_Tbl IN Payment_Tbl_Type

Line 1459: -- P_Update_Header_Flag IN VARCHAR2 Optional Default = FND_API.G_TRUE

1455: -- P_Freight_Charge_Tbl IN Freight_Charge_Tbl_Type
1456: -- P_Line_Rltship_Tbl IN Line_Rltship_Tbl_Type
1457: -- P_Price_Attributes_Tbl IN Price_Attributes_Tbl_Type
1458: -- P_Price_Adj_Rltship_Tbl IN Price_Adj_Rltship_Tbl_Type
1459: -- P_Update_Header_Flag IN VARCHAR2 Optional Default = FND_API.G_TRUE
1460:
1461: -- OUT:
1462: -- X_quote_line_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
1463: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

1472:
1473:
1474: PROCEDURE Create_Quote_Line(
1475: P_Api_Version_Number IN NUMBER,
1476: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1477: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1478: P_Qte_Line_Rec IN Qte_Line_Rec_Type := G_MISS_qte_line_REC,
1479: P_Control_Rec IN Control_rec_Type := G_MISS_control_REC,
1480: P_Qte_Line_Dtl_TBL IN Qte_Line_Dtl_Tbl_Type := G_MISS_qte_line_dtl_TBL,

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

1473:
1474: PROCEDURE Create_Quote_Line(
1475: P_Api_Version_Number IN NUMBER,
1476: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1477: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1478: P_Qte_Line_Rec IN Qte_Line_Rec_Type := G_MISS_qte_line_REC,
1479: P_Control_Rec IN Control_rec_Type := G_MISS_control_REC,
1480: P_Qte_Line_Dtl_TBL IN Qte_Line_Dtl_Tbl_Type := G_MISS_qte_line_dtl_TBL,
1481: P_Line_Attribs_Ext_Tbl IN Line_Attribs_Ext_Tbl_type

Line 1491: P_Update_Header_Flag IN VARCHAR2 := FND_API.G_TRUE,

1487: := G_Miss_PRICE_ADJ_ATTR_Tbl,
1488: P_Shipment_Tbl IN Shipment_Tbl_Type := G_MISS_shipment_TBL,
1489: P_Tax_Detail_Tbl IN Tax_Detail_Tbl_Type:= G_MISS_tax_detail_TBL,
1490: P_Freight_Charge_Tbl IN Freight_Charge_Tbl_Type := G_MISS_freight_charge_TBL,
1491: P_Update_Header_Flag IN VARCHAR2 := FND_API.G_TRUE,
1492: X_Qte_Line_Rec OUT NOCOPY /* file.sql.39 change */ Qte_Line_Rec_Type,
1493: X_Qte_Line_Dtl_TBL OUT NOCOPY /* file.sql.39 change */ Qte_Line_Dtl_TBL_Type,
1494: X_Line_Attribs_Ext_Tbl OUT NOCOPY /* file.sql.39 change */ Line_Attribs_Ext_Tbl_type,
1495: X_Payment_Tbl OUT NOCOPY /* file.sql.39 change */ Payment_Tbl_Type,

Line 1559: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

1555: -- Pre-Req :
1556: -- Parameters:
1557: -- IN
1558: -- p_api_version_number IN NUMBER Required
1559: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
1560: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
1561: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
1562: -- P_qte_lines_Rec IN qte_line_Rec_Type Required
1563: -- P_quote_header_id IN NUMBER Required

Line 1560: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

1556: -- Parameters:
1557: -- IN
1558: -- p_api_version_number IN NUMBER Required
1559: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
1560: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
1561: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
1562: -- P_qte_lines_Rec IN qte_line_Rec_Type Required
1563: -- P_quote_header_id IN NUMBER Required
1564: -- P_header_last_update_date IN DATE Required

Line 1574: -- P_Update_Header_Flag IN VARCHAR2 Optional Default = FND_API.G_TRUE

1570: -- P_Freight_Charge_Tbl IN Freight_Charge_Tbl_Type
1571: -- P_Line_Rltship_Tbl IN Line_Rltship_Tbl_Type
1572: -- P_Price_Attributes_Tbl IN Price_Attributes_Tbl_Type
1573: -- P_Price_Adj_Rltship_Tbl IN Price_Adj_Rltship_Tbl_Type
1574: -- P_Update_Header_Flag IN VARCHAR2 Optional Default = FND_API.G_TRUE
1575: -- OUT:
1576: -- X_quote_line_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
1577: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1578: -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

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

1586: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
1587:
1588: PROCEDURE Update_Quote_Line(
1589: P_Api_Version_Number IN NUMBER,
1590: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1591: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1592: P_Qte_Line_Rec IN Qte_Line_Rec_Type := G_MISS_qte_line_REC,
1593: P_Control_Rec IN Control_rec_Type := G_MISS_control_REC,
1594: P_Qte_Line_Dtl_Tbl IN Qte_Line_Dtl_Tbl_Type := G_MISS_qte_line_dtl_TBL,

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

1587:
1588: PROCEDURE Update_Quote_Line(
1589: P_Api_Version_Number IN NUMBER,
1590: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1591: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1592: P_Qte_Line_Rec IN Qte_Line_Rec_Type := G_MISS_qte_line_REC,
1593: P_Control_Rec IN Control_rec_Type := G_MISS_control_REC,
1594: P_Qte_Line_Dtl_Tbl IN Qte_Line_Dtl_Tbl_Type := G_MISS_qte_line_dtl_TBL,
1595: P_Line_Attribs_Ext_Tbl IN Line_Attribs_Ext_Tbl_type

Line 1605: P_Update_Header_Flag IN VARCHAR2 := FND_API.G_TRUE,

1601: := G_Miss_PRICE_ADJ_ATTR_Tbl,
1602: P_Shipment_Tbl IN Shipment_Tbl_Type := G_MISS_shipment_TBL,
1603: P_Tax_Detail_Tbl IN Tax_Detail_Tbl_Type:= G_MISS_tax_detail_TBL,
1604: P_Freight_Charge_Tbl IN Freight_Charge_Tbl_Type := G_MISS_freight_charge_TBL,
1605: P_Update_Header_Flag IN VARCHAR2 := FND_API.G_TRUE,
1606: X_Qte_Line_Rec OUT NOCOPY /* file.sql.39 change */ Qte_Line_Rec_Type,
1607: X_Qte_Line_Dtl_Tbl OUT NOCOPY /* file.sql.39 change */ Qte_Line_Dtl_Tbl_Type,
1608: X_Line_Attribs_Ext_Tbl OUT NOCOPY /* file.sql.39 change */ Line_Attribs_Ext_Tbl_type,
1609: X_Payment_Tbl OUT NOCOPY /* file.sql.39 change */ Payment_Tbl_Type,

Line 1673: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

1669: -- Pre-Req :
1670: -- Parameters:
1671: -- IN
1672: -- p_api_version_number IN NUMBER Required
1673: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
1674: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
1675: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
1676: -- P_qte_line_Rec IN qte_line_Rec_Type Required
1677: -- P_quote_header_id IN NUMBER Required

Line 1674: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

1670: -- Parameters:
1671: -- IN
1672: -- p_api_version_number IN NUMBER Required
1673: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
1674: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
1675: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
1676: -- P_qte_line_Rec IN qte_line_Rec_Type Required
1677: -- P_quote_header_id IN NUMBER Required
1678: -- P_header_last_update_date IN DATE Required

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

1691: -- The Master delete procedure may not be needed depends on different business requirements.
1692:
1693: PROCEDURE Delete_Quote_Line(
1694: P_Api_Version_Number IN NUMBER,
1695: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1696: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1697: P_qte_line_Rec IN qte_line_Rec_Type,
1698: P_Control_Rec IN Control_rec_Type := G_MISS_control_REC,
1699: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

1692:
1693: PROCEDURE Delete_Quote_Line(
1694: P_Api_Version_Number IN NUMBER,
1695: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1696: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1697: P_qte_line_Rec IN qte_line_Rec_Type,
1698: P_Control_Rec IN Control_rec_Type := G_MISS_control_REC,
1699: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1700: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

1738: --
1739:
1740: PROCEDURE Create_quote(
1741: P_Api_Version_Number IN NUMBER,
1742: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1743: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1744: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1745: P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
1746: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,

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

1739:
1740: PROCEDURE Create_quote(
1741: P_Api_Version_Number IN NUMBER,
1742: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1743: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1744: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1745: P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
1746: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
1747: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,

Line 1744: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1740: PROCEDURE Create_quote(
1741: P_Api_Version_Number IN NUMBER,
1742: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1743: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1744: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1745: P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
1746: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
1747: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
1748: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,

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

1877:
1878:
1879: PROCEDURE Update_quote(
1880: P_Api_Version_Number IN NUMBER,
1881: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1882: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1883: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1884: P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
1885: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,

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

1878:
1879: PROCEDURE Update_quote(
1880: P_Api_Version_Number IN NUMBER,
1881: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1882: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1883: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1884: P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
1885: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
1886: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,

Line 1883: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1879: PROCEDURE Update_quote(
1880: P_Api_Version_Number IN NUMBER,
1881: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1882: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1883: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1884: P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
1885: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
1886: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
1887: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,

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

2020: -- End of Comments
2021: --
2022: PROCEDURE Submit_quote(
2023: P_Api_Version_Number IN NUMBER,
2024: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2025: P_commit IN VARCHAR2 ,
2026: p_control_rec IN Submit_Control_Rec_Type
2027: := G_MISS_Submit_Control_Rec,
2028: P_Qte_Header_Id IN NUMBER,

Line 2047: IF FND_API.to_Boolean( p_commit )

2043: X_Return_Status => X_Return_Status,
2044: X_Msg_Count => X_Msg_Count,
2045: X_Msg_Data => X_Msg_Data
2046: );
2047: IF FND_API.to_Boolean( p_commit )
2048: THEN
2049: COMMIT WORK;
2050: END IF;
2051: END;

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

2065: --
2066: PROCEDURE Create_Quote_Line(
2067:
2068: P_Api_Version_Number IN NUMBER,
2069: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2070: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
2071: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2072: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
2073: P_Qte_Line_Rec IN Qte_Line_Rec_Type := G_MISS_qte_line_REC,

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

2066: PROCEDURE Create_Quote_Line(
2067:
2068: P_Api_Version_Number IN NUMBER,
2069: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2070: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
2071: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2072: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
2073: P_Qte_Line_Rec IN Qte_Line_Rec_Type := G_MISS_qte_line_REC,
2074: P_Control_Rec IN Control_rec_Type := G_MISS_control_REC,

Line 2071: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2067:
2068: P_Api_Version_Number IN NUMBER,
2069: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2070: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
2071: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2072: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
2073: P_Qte_Line_Rec IN Qte_Line_Rec_Type := G_MISS_qte_line_REC,
2074: P_Control_Rec IN Control_rec_Type := G_MISS_control_REC,
2075: P_Qte_Line_Dtl_Tbl IN Qte_Line_Dtl_Tbl_Type:= G_MISS_qte_line_dtl_TBL,

Line 2090: P_Update_Header_Flag IN VARCHAR2 := FND_API.G_TRUE,

2086: P_Sales_Credit_Tbl IN Sales_Credit_Tbl_Type
2087: := G_MISS_Sales_Credit_Tbl,
2088: P_Quote_Party_Tbl IN Quote_Party_Tbl_Type
2089: := G_MISS_Quote_Party_Tbl,
2090: P_Update_Header_Flag IN VARCHAR2 := FND_API.G_TRUE,
2091: X_Qte_Line_Rec OUT NOCOPY /* file.sql.39 change */ Qte_Line_Rec_Type,
2092: X_Qte_Line_Dtl_TBL OUT NOCOPY /* file.sql.39 change */ Qte_Line_Dtl_TBL_Type,
2093: X_Line_Attribs_Ext_Tbl OUT NOCOPY /* file.sql.39 change */ Line_Attribs_Ext_Tbl_type,
2094: X_Payment_Tbl OUT NOCOPY /* file.sql.39 change */ Payment_Tbl_Type,

Line 2141: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

2137:
2138: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
2139:
2140: -- Standard call to check for call compatibility.
2141: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2142: p_api_version_number,
2143: l_api_name,
2144: G_PKG_NAME)
2145: THEN

Line 2146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2142: p_api_version_number,
2143: l_api_name,
2144: G_PKG_NAME)
2145: THEN
2146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2147: END IF;
2148:
2149:
2150: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2151: IF FND_API.to_Boolean( p_init_msg_list )

2147: END IF;
2148:
2149:
2150: -- Initialize message list if p_init_msg_list is set to TRUE.
2151: IF FND_API.to_Boolean( p_init_msg_list )
2152: THEN
2153: FND_MSG_PUB.initialize;
2154: END IF;
2155:

Line 2160: x_return_status := FND_API.G_RET_STS_SUCCESS;

2156:
2157:
2158:
2159: -- Initialize API return status to SUCCESS
2160: x_return_status := FND_API.G_RET_STS_SUCCESS;
2161:
2162: --
2163: -- API body
2164: --

Line 2210: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2206: X_Msg_Count => x_msg_count ,
2207: X_Msg_Data => x_msg_data
2208: );
2209:
2210: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2211: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2212: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
2213: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Create_Quote_Line_PRE', FALSE);
2214: FND_MSG_PUB.ADD;

Line 2216: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2212: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
2213: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Create_Quote_Line_PRE', FALSE);
2214: FND_MSG_PUB.ADD;
2215: END IF;
2216: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2218: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2219: RAISE FND_API.G_EXC_ERROR;
2220: END IF;

Line 2217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2213: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Create_Quote_Line_PRE', FALSE);
2214: FND_MSG_PUB.ADD;
2215: END IF;
2216: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2218: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2219: RAISE FND_API.G_EXC_ERROR;
2220: END IF;
2221: END IF;

Line 2218: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

2214: FND_MSG_PUB.ADD;
2215: END IF;
2216: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2218: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2219: RAISE FND_API.G_EXC_ERROR;
2220: END IF;
2221: END IF;
2222: END IF; -- customer hook

Line 2219: RAISE FND_API.G_EXC_ERROR;

2215: END IF;
2216: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2218: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2219: RAISE FND_API.G_EXC_ERROR;
2220: END IF;
2221: END IF;
2222: END IF; -- customer hook
2223:

Line 2247: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2243: X_Msg_Count => x_msg_count ,
2244: X_Msg_Data => x_msg_data
2245: );
2246:
2247: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2248: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2249: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
2250: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Create_Quote_Line_PRE', FALSE);
2251: FND_MSG_PUB.ADD;

Line 2253: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2249: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
2250: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Create_Quote_Line_PRE', FALSE);
2251: FND_MSG_PUB.ADD;
2252: END IF;
2253: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2255: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2256: RAISE FND_API.G_EXC_ERROR;
2257: END IF;

Line 2254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2250: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Create_Quote_Line_PRE', FALSE);
2251: FND_MSG_PUB.ADD;
2252: END IF;
2253: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2255: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2256: RAISE FND_API.G_EXC_ERROR;
2257: END IF;
2258: END IF;

Line 2255: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

2251: FND_MSG_PUB.ADD;
2252: END IF;
2253: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2255: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2256: RAISE FND_API.G_EXC_ERROR;
2257: END IF;
2258: END IF;
2259: END IF; -- vertical hook

Line 2256: RAISE FND_API.G_EXC_ERROR;

2252: END IF;
2253: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2255: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2256: RAISE FND_API.G_EXC_ERROR;
2257: END IF;
2258: END IF;
2259: END IF; -- vertical hook
2260:

Line 2285: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

2281: P_Api_Version_Number => 1.0,
2282: P_Init_Msg_List => p_init_msg_list,
2283: P_Commit => p_commit,
2284: -- P_Validation_Level => ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM,
2285: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
2286: p_qte_header_rec => p_qte_header_rec,
2287: P_Qte_Line_Rec => l_qte_line_rec,
2288: P_Control_REC => l_control_rec ,
2289: P_Payment_Tbl => l_payment_tbl ,

Line 2320: IF x_return_status = FND_API.G_RET_STS_ERROR then

2316: );
2317:
2318:
2319: -- Check return status from the above procedure call
2320: IF x_return_status = FND_API.G_RET_STS_ERROR then
2321: raise FND_API.G_EXC_ERROR;
2322: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
2323: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2324: END IF;

Line 2321: raise FND_API.G_EXC_ERROR;

2317:
2318:
2319: -- Check return status from the above procedure call
2320: IF x_return_status = FND_API.G_RET_STS_ERROR then
2321: raise FND_API.G_EXC_ERROR;
2322: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
2323: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2324: END IF;
2325: my_message := fnd_msg_pub.get(p_encoded => FND_API.g_false);

Line 2322: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

2318:
2319: -- Check return status from the above procedure call
2320: IF x_return_status = FND_API.G_RET_STS_ERROR then
2321: raise FND_API.G_EXC_ERROR;
2322: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
2323: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2324: END IF;
2325: my_message := fnd_msg_pub.get(p_encoded => FND_API.g_false);
2326: while (my_message is not null) loop

Line 2323: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2319: -- Check return status from the above procedure call
2320: IF x_return_status = FND_API.G_RET_STS_ERROR then
2321: raise FND_API.G_EXC_ERROR;
2322: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
2323: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2324: END IF;
2325: my_message := fnd_msg_pub.get(p_encoded => FND_API.g_false);
2326: while (my_message is not null) loop
2327: my_message := fnd_msg_pub.get(p_encoded => FND_API.g_false);

Line 2325: my_message := fnd_msg_pub.get(p_encoded => FND_API.g_false);

2321: raise FND_API.G_EXC_ERROR;
2322: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
2323: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2324: END IF;
2325: my_message := fnd_msg_pub.get(p_encoded => FND_API.g_false);
2326: while (my_message is not null) loop
2327: my_message := fnd_msg_pub.get(p_encoded => FND_API.g_false);
2328: end loop;
2329:

Line 2327: my_message := fnd_msg_pub.get(p_encoded => FND_API.g_false);

2323: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2324: END IF;
2325: my_message := fnd_msg_pub.get(p_encoded => FND_API.g_false);
2326: while (my_message is not null) loop
2327: my_message := fnd_msg_pub.get(p_encoded => FND_API.g_false);
2328: end loop;
2329:
2330: --
2331: -- End of API body.

Line 2360: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2356: X_Msg_Count => x_msg_count ,
2357: X_Msg_Data => x_msg_data
2358: );
2359:
2360: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2361: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2362: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
2363: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Create_Quote_Line_POST', FALSE);
2364: FND_MSG_PUB.ADD;

Line 2366: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2362: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
2363: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Create_Quote_Line_POST', FALSE);
2364: FND_MSG_PUB.ADD;
2365: END IF;
2366: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2368: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2369: RAISE FND_API.G_EXC_ERROR;
2370: END IF;

Line 2367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2363: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Create_Quote_Line_POST', FALSE);
2364: FND_MSG_PUB.ADD;
2365: END IF;
2366: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2368: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2369: RAISE FND_API.G_EXC_ERROR;
2370: END IF;
2371: END IF;

Line 2368: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

2364: FND_MSG_PUB.ADD;
2365: END IF;
2366: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2368: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2369: RAISE FND_API.G_EXC_ERROR;
2370: END IF;
2371: END IF;
2372: END IF; -- customer hook

Line 2369: RAISE FND_API.G_EXC_ERROR;

2365: END IF;
2366: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2368: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2369: RAISE FND_API.G_EXC_ERROR;
2370: END IF;
2371: END IF;
2372: END IF; -- customer hook
2373:

Line 2408: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2404: aso_debug_pub.add('aso_quote_vuhk: after if create quote line post (1)'||x_return_status,1, 'N');
2405: END IF;
2406:
2407:
2408: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2409: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2410: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
2411: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Create_Quote_Line_POST', FALSE);
2412: FND_MSG_PUB.ADD;

Line 2414: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2410: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
2411: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Create_Quote_Line_POST', FALSE);
2412: FND_MSG_PUB.ADD;
2413: END IF;
2414: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2416: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2417: RAISE FND_API.G_EXC_ERROR;
2418: END IF;

Line 2415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2411: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Create_Quote_Line_POST', FALSE);
2412: FND_MSG_PUB.ADD;
2413: END IF;
2414: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2416: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2417: RAISE FND_API.G_EXC_ERROR;
2418: END IF;
2419: END IF;

Line 2416: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

2412: FND_MSG_PUB.ADD;
2413: END IF;
2414: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2416: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2417: RAISE FND_API.G_EXC_ERROR;
2418: END IF;
2419: END IF;
2420: END IF; -- vertical hook

Line 2417: RAISE FND_API.G_EXC_ERROR;

2413: END IF;
2414: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2416: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2417: RAISE FND_API.G_EXC_ERROR;
2418: END IF;
2419: END IF;
2420: END IF; -- vertical hook
2421:

Line 2426: IF FND_API.to_Boolean( p_commit )

2422:
2423:
2424:
2425: -- Standard check for p_commit
2426: IF FND_API.to_Boolean( p_commit )
2427: THEN
2428: COMMIT WORK;
2429: END IF;
2430:

Line 2441: WHEN FND_API.G_EXC_ERROR THEN

2437: p_data => x_msg_data
2438: );
2439:
2440: EXCEPTION
2441: WHEN FND_API.G_EXC_ERROR THEN
2442: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2443: P_API_NAME => L_API_NAME
2444: ,P_PKG_NAME => G_PKG_NAME
2445: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 2453: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2449: ,X_MSG_COUNT => X_MSG_COUNT
2450: ,X_MSG_DATA => X_MSG_DATA
2451: ,X_RETURN_STATUS => X_RETURN_STATUS);
2452:
2453: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2454: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2455: P_API_NAME => L_API_NAME
2456: ,P_PKG_NAME => G_PKG_NAME
2457: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

2486: -- IN
2487:
2488: PROCEDURE Update_Quote_Line(
2489: P_Api_Version_Number IN NUMBER,
2490: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2491: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
2492: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2493: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
2494: P_Qte_Line_Rec IN Qte_Line_Rec_Type := G_MISS_qte_line_REC,

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

2487:
2488: PROCEDURE Update_Quote_Line(
2489: P_Api_Version_Number IN NUMBER,
2490: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2491: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
2492: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2493: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
2494: P_Qte_Line_Rec IN Qte_Line_Rec_Type := G_MISS_qte_line_REC,
2495: P_Control_Rec IN Control_rec_Type := G_MISS_control_REC,

Line 2492: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2488: PROCEDURE Update_Quote_Line(
2489: P_Api_Version_Number IN NUMBER,
2490: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2491: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
2492: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2493: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
2494: P_Qte_Line_Rec IN Qte_Line_Rec_Type := G_MISS_qte_line_REC,
2495: P_Control_Rec IN Control_rec_Type := G_MISS_control_REC,
2496: P_Qte_Line_Dtl_TBL IN Qte_Line_Dtl_tbl_Type:= G_MISS_qte_line_dtl_TBL,

Line 2511: P_Update_Header_Flag IN VARCHAR2 := FND_API.G_TRUE,

2507: P_Sales_Credit_Tbl IN Sales_Credit_Tbl_Type
2508: := G_MISS_Sales_Credit_Tbl,
2509: P_Quote_Party_Tbl IN Quote_Party_Tbl_Type
2510: := G_MISS_Quote_Party_Tbl,
2511: P_Update_Header_Flag IN VARCHAR2 := FND_API.G_TRUE,
2512: X_Qte_Line_Rec OUT NOCOPY /* file.sql.39 change */ Qte_Line_Rec_Type,
2513: X_Qte_Line_Dtl_TBL OUT NOCOPY /* file.sql.39 change */ Qte_Line_Dtl_TBL_Type,
2514: X_Line_Attribs_Ext_Tbl OUT NOCOPY /* file.sql.39 change */ Line_Attribs_Ext_Tbl_type,
2515: X_Payment_Tbl OUT NOCOPY /* file.sql.39 change */ Payment_Tbl_Type,

Line 2561: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

2557:
2558: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
2559:
2560: -- Standard call to check for call compatibility.
2561: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2562: p_api_version_number,
2563: l_api_name,
2564: G_PKG_NAME)
2565: THEN

Line 2566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2562: p_api_version_number,
2563: l_api_name,
2564: G_PKG_NAME)
2565: THEN
2566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2567: END IF;
2568:
2569:
2570: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2571: IF FND_API.to_Boolean( p_init_msg_list )

2567: END IF;
2568:
2569:
2570: -- Initialize message list if p_init_msg_list is set to TRUE.
2571: IF FND_API.to_Boolean( p_init_msg_list )
2572: THEN
2573: FND_MSG_PUB.initialize;
2574: END IF;
2575:

Line 2580: x_return_status := FND_API.G_RET_STS_SUCCESS;

2576:
2577:
2578:
2579: -- Initialize API return status to SUCCESS
2580: x_return_status := FND_API.G_RET_STS_SUCCESS;
2581:
2582: --
2583: -- API body
2584: --

Line 2633: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2629: X_Msg_Count => x_msg_count ,
2630: X_Msg_Data => x_msg_data
2631: );
2632:
2633: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2634: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2635: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
2636: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Update_Quote_Line_PRE', FALSE);
2637: FND_MSG_PUB.ADD;

Line 2639: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2635: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
2636: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Update_Quote_Line_PRE', FALSE);
2637: FND_MSG_PUB.ADD;
2638: END IF;
2639: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2641: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2642: RAISE FND_API.G_EXC_ERROR;
2643: END IF;

Line 2640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2636: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Update_Quote_Line_PRE', FALSE);
2637: FND_MSG_PUB.ADD;
2638: END IF;
2639: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2641: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2642: RAISE FND_API.G_EXC_ERROR;
2643: END IF;
2644: END IF;

Line 2641: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

2637: FND_MSG_PUB.ADD;
2638: END IF;
2639: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2641: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2642: RAISE FND_API.G_EXC_ERROR;
2643: END IF;
2644: END IF;
2645: END IF; -- customer hook

Line 2642: RAISE FND_API.G_EXC_ERROR;

2638: END IF;
2639: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2641: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2642: RAISE FND_API.G_EXC_ERROR;
2643: END IF;
2644: END IF;
2645: END IF; -- customer hook
2646:

Line 2670: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2666: X_Msg_Count => x_msg_count ,
2667: X_Msg_Data => x_msg_data
2668: );
2669:
2670: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2671: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2672: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
2673: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Update_Quote_Line_PRE', FALSE);
2674: FND_MSG_PUB.ADD;

Line 2676: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2672: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
2673: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Update_Quote_Line_PRE', FALSE);
2674: FND_MSG_PUB.ADD;
2675: END IF;
2676: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2678: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2679: RAISE FND_API.G_EXC_ERROR;
2680: END IF;

Line 2677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2673: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Update_Quote_Line_PRE', FALSE);
2674: FND_MSG_PUB.ADD;
2675: END IF;
2676: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2678: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2679: RAISE FND_API.G_EXC_ERROR;
2680: END IF;
2681: END IF;

Line 2678: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

2674: FND_MSG_PUB.ADD;
2675: END IF;
2676: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2678: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2679: RAISE FND_API.G_EXC_ERROR;
2680: END IF;
2681: END IF;
2682: END IF; -- vertical hook

Line 2679: RAISE FND_API.G_EXC_ERROR;

2675: END IF;
2676: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2678: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2679: RAISE FND_API.G_EXC_ERROR;
2680: END IF;
2681: END IF;
2682: END IF; -- vertical hook
2683:

Line 2746: IF x_return_status = FND_API.G_RET_STS_ERROR then

2742:
2743:
2744:
2745: -- Check return status from the above procedure call
2746: IF x_return_status = FND_API.G_RET_STS_ERROR then
2747: raise FND_API.G_EXC_ERROR;
2748: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
2749: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2750: END IF;

Line 2747: raise FND_API.G_EXC_ERROR;

2743:
2744:
2745: -- Check return status from the above procedure call
2746: IF x_return_status = FND_API.G_RET_STS_ERROR then
2747: raise FND_API.G_EXC_ERROR;
2748: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
2749: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2750: END IF;
2751:

Line 2748: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

2744:
2745: -- Check return status from the above procedure call
2746: IF x_return_status = FND_API.G_RET_STS_ERROR then
2747: raise FND_API.G_EXC_ERROR;
2748: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
2749: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2750: END IF;
2751:
2752: --

Line 2749: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2745: -- Check return status from the above procedure call
2746: IF x_return_status = FND_API.G_RET_STS_ERROR then
2747: raise FND_API.G_EXC_ERROR;
2748: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
2749: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2750: END IF;
2751:
2752: --
2753: -- End of API body.

Line 2782: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2778: X_Msg_Count => x_msg_count ,
2779: X_Msg_Data => x_msg_data
2780: );
2781:
2782: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2783: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2784: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
2785: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Update_Quote_Line_POST', FALSE);
2786: FND_MSG_PUB.ADD;

Line 2788: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2784: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
2785: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Update_Quote_Line_POST', FALSE);
2786: FND_MSG_PUB.ADD;
2787: END IF;
2788: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2790: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2791: RAISE FND_API.G_EXC_ERROR;
2792: END IF;

Line 2789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2785: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Update_Quote_Line_POST', FALSE);
2786: FND_MSG_PUB.ADD;
2787: END IF;
2788: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2790: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2791: RAISE FND_API.G_EXC_ERROR;
2792: END IF;
2793: END IF;

Line 2790: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

2786: FND_MSG_PUB.ADD;
2787: END IF;
2788: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2790: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2791: RAISE FND_API.G_EXC_ERROR;
2792: END IF;
2793: END IF;
2794: END IF; -- customer hook

Line 2791: RAISE FND_API.G_EXC_ERROR;

2787: END IF;
2788: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2790: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2791: RAISE FND_API.G_EXC_ERROR;
2792: END IF;
2793: END IF;
2794: END IF; -- customer hook
2795:

Line 2829: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2825: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2826: aso_debug_pub.add('aso_quote_vuhk: after if update quote line post (1)'||x_return_status,1, 'N');
2827: END IF;
2828:
2829: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2830: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2831: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
2832: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Update_Quote_Line_POST', FALSE);
2833: FND_MSG_PUB.ADD;

Line 2835: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2831: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
2832: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Update_Quote_Line_POST', FALSE);
2833: FND_MSG_PUB.ADD;
2834: END IF;
2835: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2836: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2837: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2838: RAISE FND_API.G_EXC_ERROR;
2839: END IF;

Line 2836: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2832: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Update_Quote_Line_POST', FALSE);
2833: FND_MSG_PUB.ADD;
2834: END IF;
2835: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2836: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2837: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2838: RAISE FND_API.G_EXC_ERROR;
2839: END IF;
2840: END IF;

Line 2837: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

2833: FND_MSG_PUB.ADD;
2834: END IF;
2835: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2836: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2837: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2838: RAISE FND_API.G_EXC_ERROR;
2839: END IF;
2840: END IF;
2841: END IF; -- vertical hook

Line 2838: RAISE FND_API.G_EXC_ERROR;

2834: END IF;
2835: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2836: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2837: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2838: RAISE FND_API.G_EXC_ERROR;
2839: END IF;
2840: END IF;
2841: END IF; -- vertical hook
2842:

Line 2848: IF FND_API.to_Boolean( p_commit )

2844:
2845:
2846:
2847: -- Standard check for p_commit
2848: IF FND_API.to_Boolean( p_commit )
2849: THEN
2850: COMMIT WORK;
2851: END IF;
2852:

Line 2863: WHEN FND_API.G_EXC_ERROR THEN

2859: p_data => x_msg_data
2860: );
2861:
2862: EXCEPTION
2863: WHEN FND_API.G_EXC_ERROR THEN
2864: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2865: P_API_NAME => L_API_NAME
2866: ,P_PKG_NAME => G_PKG_NAME
2867: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 2875: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2871: ,X_MSG_COUNT => X_MSG_COUNT
2872: ,X_MSG_DATA => X_MSG_DATA
2873: ,X_RETURN_STATUS => X_RETURN_STATUS);
2874:
2875: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2876: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2877: P_API_NAME => L_API_NAME
2878: ,P_PKG_NAME => G_PKG_NAME
2879: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

2899:
2900:
2901: PROCEDURE Delete_Quote_Line(
2902: P_Api_Version_Number IN NUMBER,
2903: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2904: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
2905: P_qte_line_Rec IN qte_line_Rec_Type,
2906: P_Control_REC IN Control_Rec_Type := G_MISS_Control_Rec,
2907: P_Update_Header_Flag IN VARCHAR2,

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

2900:
2901: PROCEDURE Delete_Quote_Line(
2902: P_Api_Version_Number IN NUMBER,
2903: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2904: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
2905: P_qte_line_Rec IN qte_line_Rec_Type,
2906: P_Control_REC IN Control_Rec_Type := G_MISS_Control_Rec,
2907: P_Update_Header_Flag IN VARCHAR2,
2908: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 2926: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

2922:
2923: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
2924:
2925: -- Standard call to check for call compatibility.
2926: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2927: p_api_version_number,
2928: l_api_name,
2929: G_PKG_NAME)
2930: THEN

Line 2931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2927: p_api_version_number,
2928: l_api_name,
2929: G_PKG_NAME)
2930: THEN
2931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2932: END IF;
2933:
2934:
2935: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2936: IF FND_API.to_Boolean( p_init_msg_list )

2932: END IF;
2933:
2934:
2935: -- Initialize message list if p_init_msg_list is set to TRUE.
2936: IF FND_API.to_Boolean( p_init_msg_list )
2937: THEN
2938: FND_MSG_PUB.initialize;
2939: END IF;
2940:

Line 2945: x_return_status := FND_API.G_RET_STS_SUCCESS;

2941:
2942:
2943:
2944: -- Initialize API return status to SUCCESS
2945: x_return_status := FND_API.G_RET_STS_SUCCESS;
2946:
2947: l_Qte_Line_Rec := p_qte_line_rec;
2948: l_control_rec := p_control_rec ;
2949:

Line 2967: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2963: X_Msg_Count => x_msg_count ,
2964: X_Msg_Data => x_msg_data
2965: );
2966:
2967: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2968: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2969: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
2970: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Delete_Quote_Line_PRE', FALSE);
2971: FND_MSG_PUB.ADD;

Line 2973: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2969: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
2970: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Delete_Quote_Line_PRE', FALSE);
2971: FND_MSG_PUB.ADD;
2972: END IF;
2973: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2975: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2976: RAISE FND_API.G_EXC_ERROR;
2977: END IF;

Line 2974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2970: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Delete_Quote_Line_PRE', FALSE);
2971: FND_MSG_PUB.ADD;
2972: END IF;
2973: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2975: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2976: RAISE FND_API.G_EXC_ERROR;
2977: END IF;
2978: END IF;

Line 2975: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

2971: FND_MSG_PUB.ADD;
2972: END IF;
2973: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2975: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2976: RAISE FND_API.G_EXC_ERROR;
2977: END IF;
2978: END IF;
2979: END IF; -- customer hook

Line 2976: RAISE FND_API.G_EXC_ERROR;

2972: END IF;
2973: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2975: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2976: RAISE FND_API.G_EXC_ERROR;
2977: END IF;
2978: END IF;
2979: END IF; -- customer hook
2980:

Line 2991: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2987: X_Return_Status => x_return_status,
2988: X_Msg_Count => x_msg_count ,
2989: X_Msg_Data => x_msg_data
2990: );
2991: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2992: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2993: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
2994: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Delete_Quote_Line_PRE', FALSE);
2995: FND_MSG_PUB.ADD;

Line 2997: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2993: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
2994: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Delete_Quote_Line_PRE', FALSE);
2995: FND_MSG_PUB.ADD;
2996: END IF;
2997: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2999: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3000: RAISE FND_API.G_EXC_ERROR;
3001: END IF;

Line 2998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2994: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Delete_Quote_Line_PRE', FALSE);
2995: FND_MSG_PUB.ADD;
2996: END IF;
2997: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2999: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3000: RAISE FND_API.G_EXC_ERROR;
3001: END IF;
3002: END IF;

Line 2999: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

2995: FND_MSG_PUB.ADD;
2996: END IF;
2997: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2999: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3000: RAISE FND_API.G_EXC_ERROR;
3001: END IF;
3002: END IF;
3003: END IF; -- vertical hook

Line 3000: RAISE FND_API.G_EXC_ERROR;

2996: END IF;
2997: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2999: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3000: RAISE FND_API.G_EXC_ERROR;
3001: END IF;
3002: END IF;
3003: END IF; -- vertical hook
3004:

Line 3010: P_Init_Msg_List => FND_API.G_FALSE,

3006:
3007:
3008: ASO_QUOTE_LINES_PVT.Delete_quote_line(
3009: P_Api_Version_Number => 1.0,
3010: P_Init_Msg_List => FND_API.G_FALSE,
3011: P_Commit => p_commit,
3012: P_qte_line_Rec => l_qte_line_Rec,
3013: P_Control_Rec => l_Control_Rec ,
3014: P_Update_Header_Flag => P_Update_Header_Flag ,

Line 3022: IF x_return_status = FND_API.G_RET_STS_ERROR then

3018:
3019:
3020:
3021: -- Check return status from the above procedure call
3022: IF x_return_status = FND_API.G_RET_STS_ERROR then
3023: raise FND_API.G_EXC_ERROR;
3024: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
3025: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3026: END IF;

Line 3023: raise FND_API.G_EXC_ERROR;

3019:
3020:
3021: -- Check return status from the above procedure call
3022: IF x_return_status = FND_API.G_RET_STS_ERROR then
3023: raise FND_API.G_EXC_ERROR;
3024: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
3025: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3026: END IF;
3027:

Line 3024: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

3020:
3021: -- Check return status from the above procedure call
3022: IF x_return_status = FND_API.G_RET_STS_ERROR then
3023: raise FND_API.G_EXC_ERROR;
3024: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
3025: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3026: END IF;
3027:
3028: --

Line 3025: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3021: -- Check return status from the above procedure call
3022: IF x_return_status = FND_API.G_RET_STS_ERROR then
3023: raise FND_API.G_EXC_ERROR;
3024: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
3025: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3026: END IF;
3027:
3028: --
3029: -- End of API body

Line 3046: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3042: X_Msg_Count => x_msg_count ,
3043: X_Msg_Data => x_msg_data
3044: );
3045:
3046: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3047: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3048: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3049: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Delete_Quote_Line_POST', FALSE);
3050: FND_MSG_PUB.ADD;

Line 3052: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

3048: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3049: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Delete_Quote_Line_POST', FALSE);
3050: FND_MSG_PUB.ADD;
3051: END IF;
3052: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3054: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3055: RAISE FND_API.G_EXC_ERROR;
3056: END IF;

Line 3053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3049: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Delete_Quote_Line_POST', FALSE);
3050: FND_MSG_PUB.ADD;
3051: END IF;
3052: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3054: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3055: RAISE FND_API.G_EXC_ERROR;
3056: END IF;
3057: END IF;

Line 3054: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

3050: FND_MSG_PUB.ADD;
3051: END IF;
3052: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3054: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3055: RAISE FND_API.G_EXC_ERROR;
3056: END IF;
3057: END IF;
3058: END IF; -- customer hook

Line 3055: RAISE FND_API.G_EXC_ERROR;

3051: END IF;
3052: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3054: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3055: RAISE FND_API.G_EXC_ERROR;
3056: END IF;
3057: END IF;
3058: END IF; -- customer hook
3059:

Line 3081: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3077: aso_debug_pub.add('aso_quote_vuhk: after if delete quote line post (1)'||x_return_status,1, 'N');
3078: END IF;
3079:
3080:
3081: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3082: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3083: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3084: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Delete_Quote_Line_POST', FALSE);
3085: FND_MSG_PUB.ADD;

Line 3087: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

3083: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3084: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Delete_Quote_Line_POST', FALSE);
3085: FND_MSG_PUB.ADD;
3086: END IF;
3087: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3089: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3090: RAISE FND_API.G_EXC_ERROR;
3091: END IF;

Line 3088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3084: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Delete_Quote_Line_POST', FALSE);
3085: FND_MSG_PUB.ADD;
3086: END IF;
3087: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3089: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3090: RAISE FND_API.G_EXC_ERROR;
3091: END IF;
3092: END IF;

Line 3089: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

3085: FND_MSG_PUB.ADD;
3086: END IF;
3087: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3089: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3090: RAISE FND_API.G_EXC_ERROR;
3091: END IF;
3092: END IF;
3093: END IF; -- vertical hook

Line 3090: RAISE FND_API.G_EXC_ERROR;

3086: END IF;
3087: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3089: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3090: RAISE FND_API.G_EXC_ERROR;
3091: END IF;
3092: END IF;
3093: END IF; -- vertical hook
3094:

Line 3101: IF FND_API.to_Boolean( p_commit )

3097:
3098:
3099:
3100: -- Standard check for p_commit
3101: IF FND_API.to_Boolean( p_commit )
3102: THEN
3103: COMMIT WORK;
3104: END IF;
3105:

Line 3116: WHEN FND_API.G_EXC_ERROR THEN

3112: p_data => x_msg_data
3113: );
3114:
3115: EXCEPTION
3116: WHEN FND_API.G_EXC_ERROR THEN
3117: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3118: P_API_NAME => L_API_NAME
3119: ,P_PKG_NAME => G_PKG_NAME
3120: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 3128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3124: ,X_MSG_COUNT => X_MSG_COUNT
3125: ,X_MSG_DATA => X_MSG_DATA
3126: ,X_RETURN_STATUS => X_RETURN_STATUS);
3127:
3128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3129: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3130: P_API_NAME => L_API_NAME
3131: ,P_PKG_NAME => G_PKG_NAME
3132: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

3152: End Delete_quote_line;
3153:
3154: PROCEDURE Quote_Security_Check(
3155: P_Api_Version_Number IN NUMBER,
3156: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3157: P_User_Id IN NUMBER,
3158: X_Resource_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
3159: X_Security_Flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
3160: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

3197: -- End of Comments
3198: --
3199: PROCEDURE Submit_quote(
3200: P_Api_Version_Number IN NUMBER,
3201: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3202: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3203: p_control_rec IN ASO_QUOTE_PUB.Submit_Control_Rec_Type
3204: := ASO_QUOTE_PUB.G_MISS_Submit_Control_Rec,
3205: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

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

3198: --
3199: PROCEDURE Submit_quote(
3200: P_Api_Version_Number IN NUMBER,
3201: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3202: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3203: p_control_rec IN ASO_QUOTE_PUB.Submit_Control_Rec_Type
3204: := ASO_QUOTE_PUB.G_MISS_Submit_Control_Rec,
3205: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
3206: x_order_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Order_Header_Rec_Type,

Line 3224: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

3220:
3221: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
3222:
3223: -- Standard call to check for call compatibility.
3224: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3225: p_api_version_number,
3226: l_api_name,
3227: G_PKG_NAME)
3228: THEN

Line 3229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3225: p_api_version_number,
3226: l_api_name,
3227: G_PKG_NAME)
3228: THEN
3229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3230: END IF;
3231:
3232: -- Initialize message list if p_init_msg_list is set to TRUE.
3233: IF FND_API.to_Boolean( p_init_msg_list )

Line 3233: IF FND_API.to_Boolean( p_init_msg_list )

3229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3230: END IF;
3231:
3232: -- Initialize message list if p_init_msg_list is set to TRUE.
3233: IF FND_API.to_Boolean( p_init_msg_list )
3234: THEN
3235: FND_MSG_PUB.initialize;
3236: END IF;
3237:

Line 3240: x_return_status := FND_API.G_RET_STS_SUCCESS;

3236: END IF;
3237:
3238:
3239: -- Initialize API return status to SUCCESS
3240: x_return_status := FND_API.G_RET_STS_SUCCESS;
3241: l_Qte_Header_Id := P_Qte_Header_Rec.Quote_Header_Id;
3242:
3243: --
3244: -- API body

Line 3256: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3252: X_Return_Status => X_Return_Status,
3253: X_Msg_Count => X_Msg_Count,
3254: X_Msg_Data => X_Msg_Data );
3255:
3256: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3257: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3258: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3259: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Submit_Quote_PRE', FALSE);
3260: FND_MSG_PUB.ADD;

Line 3263: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

3259: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Submit_Quote_PRE', FALSE);
3260: FND_MSG_PUB.ADD;
3261: END IF;
3262:
3263: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3265: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3266: RAISE FND_API.G_EXC_ERROR;
3267: END IF;

Line 3264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3260: FND_MSG_PUB.ADD;
3261: END IF;
3262:
3263: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3265: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3266: RAISE FND_API.G_EXC_ERROR;
3267: END IF;
3268: END IF;

Line 3265: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

3261: END IF;
3262:
3263: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3265: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3266: RAISE FND_API.G_EXC_ERROR;
3267: END IF;
3268: END IF;
3269:

Line 3266: RAISE FND_API.G_EXC_ERROR;

3262:
3263: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3265: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3266: RAISE FND_API.G_EXC_ERROR;
3267: END IF;
3268: END IF;
3269:
3270: END IF; -- customer hook

Line 3281: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3277: X_Return_Status => X_Return_Status,
3278: X_Msg_Count => X_Msg_Count,
3279: X_Msg_Data => X_Msg_Data );
3280:
3281: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3282: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3283: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3284: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Submit_Quote_PRE', FALSE);
3285: FND_MSG_PUB.ADD;

Line 3287: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

3283: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3284: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Submit_Quote_PRE', FALSE);
3285: FND_MSG_PUB.ADD;
3286: END IF;
3287: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3289: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3290: RAISE FND_API.G_EXC_ERROR;
3291: END IF;

Line 3288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3284: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Submit_Quote_PRE', FALSE);
3285: FND_MSG_PUB.ADD;
3286: END IF;
3287: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3289: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3290: RAISE FND_API.G_EXC_ERROR;
3291: END IF;
3292: END IF;

Line 3289: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

3285: FND_MSG_PUB.ADD;
3286: END IF;
3287: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3289: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3290: RAISE FND_API.G_EXC_ERROR;
3291: END IF;
3292: END IF;
3293:

Line 3290: RAISE FND_API.G_EXC_ERROR;

3286: END IF;
3287: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3289: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3290: RAISE FND_API.G_EXC_ERROR;
3291: END IF;
3292: END IF;
3293:
3294: END IF;

Line 3308: IF x_return_status = FND_API.G_RET_STS_ERROR then

3304: X_Msg_Data => X_Msg_Data
3305: );
3306:
3307: -- Check return status from the above procedure call
3308: IF x_return_status = FND_API.G_RET_STS_ERROR then
3309: raise FND_API.G_EXC_ERROR;
3310: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
3311: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3312: END IF;

Line 3309: raise FND_API.G_EXC_ERROR;

3305: );
3306:
3307: -- Check return status from the above procedure call
3308: IF x_return_status = FND_API.G_RET_STS_ERROR then
3309: raise FND_API.G_EXC_ERROR;
3310: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
3311: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3312: END IF;
3313:

Line 3310: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

3306:
3307: -- Check return status from the above procedure call
3308: IF x_return_status = FND_API.G_RET_STS_ERROR then
3309: raise FND_API.G_EXC_ERROR;
3310: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
3311: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3312: END IF;
3313:
3314: -- call user hooks

Line 3311: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3307: -- Check return status from the above procedure call
3308: IF x_return_status = FND_API.G_RET_STS_ERROR then
3309: raise FND_API.G_EXC_ERROR;
3310: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
3311: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3312: END IF;
3313:
3314: -- call user hooks
3315: -- customer post processing

Line 3326: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3322: X_Return_Status => X_Return_Status,
3323: X_Msg_Count => X_Msg_Count,
3324: X_Msg_Data => X_Msg_Data );
3325:
3326: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3327: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3328: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3329: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Submit_Quote_POST', FALSE);
3330: FND_MSG_PUB.ADD;

Line 3332: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

3328: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3329: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Submit_Quote_POST', FALSE);
3330: FND_MSG_PUB.ADD;
3331: END IF;
3332: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3334: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3335: RAISE FND_API.G_EXC_ERROR;
3336: END IF;

Line 3333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3329: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Submit_Quote_POST', FALSE);
3330: FND_MSG_PUB.ADD;
3331: END IF;
3332: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3334: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3335: RAISE FND_API.G_EXC_ERROR;
3336: END IF;
3337: END IF;

Line 3334: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

3330: FND_MSG_PUB.ADD;
3331: END IF;
3332: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3334: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3335: RAISE FND_API.G_EXC_ERROR;
3336: END IF;
3337: END IF;
3338:

Line 3335: RAISE FND_API.G_EXC_ERROR;

3331: END IF;
3332: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3334: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3335: RAISE FND_API.G_EXC_ERROR;
3336: END IF;
3337: END IF;
3338:
3339: END IF; -- customer hook

Line 3350: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3346: X_Return_Status => X_Return_Status,
3347: X_Msg_Count => X_Msg_Count,
3348: X_Msg_Data => X_Msg_Data );
3349:
3350: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3351: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3352: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3353: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Submit_Quote_POST', FALSE);
3354: FND_MSG_PUB.ADD;

Line 3356: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

3352: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3353: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Submit_Quote_POST', FALSE);
3354: FND_MSG_PUB.ADD;
3355: END IF;
3356: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3358: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3359: RAISE FND_API.G_EXC_ERROR;
3360: END IF;

Line 3357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3353: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Submit_Quote_POST', FALSE);
3354: FND_MSG_PUB.ADD;
3355: END IF;
3356: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3358: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3359: RAISE FND_API.G_EXC_ERROR;
3360: END IF;
3361: END IF;

Line 3358: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

3354: FND_MSG_PUB.ADD;
3355: END IF;
3356: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3358: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3359: RAISE FND_API.G_EXC_ERROR;
3360: END IF;
3361: END IF;
3362:

Line 3359: RAISE FND_API.G_EXC_ERROR;

3355: END IF;
3356: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3358: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3359: RAISE FND_API.G_EXC_ERROR;
3360: END IF;
3361: END IF;
3362:
3363: END IF; -- vertical hook

Line 3377: WHEN FND_API.G_EXC_ERROR THEN

3373: p_data => x_msg_data
3374: );
3375:
3376: EXCEPTION
3377: WHEN FND_API.G_EXC_ERROR THEN
3378: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3379: P_API_NAME => L_API_NAME
3380: ,P_PKG_NAME => G_PKG_NAME
3381: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 3387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3383: ,X_MSG_COUNT => X_MSG_COUNT
3384: ,X_MSG_DATA => X_MSG_DATA
3385: ,X_RETURN_STATUS => X_RETURN_STATUS);
3386:
3387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3388: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3389: P_API_NAME => L_API_NAME
3390: ,P_PKG_NAME => G_PKG_NAME
3391: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

3410: -- vtariker: Sales Credit Allocation Public API
3411: PROCEDURE Allocate_Sales_Credits
3412: (
3413: P_Api_Version_Number IN NUMBER,
3414: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3415: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3416: p_control_rec IN ASO_QUOTE_PUB.SALES_ALLOC_CONTROL_REC_TYPE
3417: := ASO_QUOTE_PUB.G_MISS_SALES_ALLOC_CONTROL_REC,
3418: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

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

3411: PROCEDURE Allocate_Sales_Credits
3412: (
3413: P_Api_Version_Number IN NUMBER,
3414: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3415: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3416: p_control_rec IN ASO_QUOTE_PUB.SALES_ALLOC_CONTROL_REC_TYPE
3417: := ASO_QUOTE_PUB.G_MISS_SALES_ALLOC_CONTROL_REC,
3418: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
3419: X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,

Line 3436: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

3432: -- Standard Start of API savepoint
3433: SAVEPOINT ALLOCATE_SALES_CREDITS_PUB;
3434:
3435: -- Standard call to check for call compatibility.
3436: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3437: 1.0,
3438: l_api_name,
3439: G_PKG_NAME)
3440: THEN

Line 3441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3437: 1.0,
3438: l_api_name,
3439: G_PKG_NAME)
3440: THEN
3441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3443: END IF;
3444:
3445: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3438: l_api_name,
3439: G_PKG_NAME)
3440: THEN
3441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3443: END IF;
3444:
3445: -- Initialize message list if p_init_msg_list is set to TRUE.
3446: IF FND_API.to_Boolean( p_init_msg_list )

Line 3446: IF FND_API.to_Boolean( p_init_msg_list )

3442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3443: END IF;
3444:
3445: -- Initialize message list if p_init_msg_list is set to TRUE.
3446: IF FND_API.to_Boolean( p_init_msg_list )
3447: THEN
3448: FND_MSG_PUB.initialize;
3449: END IF;
3450:

Line 3452: x_return_status := FND_API.G_RET_STS_SUCCESS;

3448: FND_MSG_PUB.initialize;
3449: END IF;
3450:
3451: -- Initialize API return status to SUCCESS
3452: x_return_status := FND_API.G_RET_STS_SUCCESS;
3453:
3454: --
3455: -- API body
3456: --

Line 3468: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3464: X_Return_Status => X_Return_Status,
3465: X_Msg_Count => X_Msg_Count,
3466: X_Msg_Data => X_Msg_Data );
3467:
3468: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3469: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3470: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3471: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Allocate_Sales_Credits_PRE', FALSE);
3472: FND_MSG_PUB.ADD;

Line 3475: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

3471: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Allocate_Sales_Credits_PRE', FALSE);
3472: FND_MSG_PUB.ADD;
3473: END IF;
3474:
3475: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3477: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3478: RAISE FND_API.G_EXC_ERROR;
3479: END IF;

Line 3476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3472: FND_MSG_PUB.ADD;
3473: END IF;
3474:
3475: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3477: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3478: RAISE FND_API.G_EXC_ERROR;
3479: END IF;
3480: END IF;

Line 3477: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

3473: END IF;
3474:
3475: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3477: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3478: RAISE FND_API.G_EXC_ERROR;
3479: END IF;
3480: END IF;
3481:

Line 3478: RAISE FND_API.G_EXC_ERROR;

3474:
3475: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3477: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3478: RAISE FND_API.G_EXC_ERROR;
3479: END IF;
3480: END IF;
3481:
3482: END IF; -- customer hook

Line 3493: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3489: X_Return_Status => X_Return_Status,
3490: X_Msg_Count => X_Msg_Count,
3491: X_Msg_Data => X_Msg_Data );
3492:
3493: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3494: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3495: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3496: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Allocate_Sales_Credits_PRE', FALSE);
3497: FND_MSG_PUB.ADD;

Line 3499: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

3495: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3496: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Allocate_Sales_Credits_PRE', FALSE);
3497: FND_MSG_PUB.ADD;
3498: END IF;
3499: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3501: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3502: RAISE FND_API.G_EXC_ERROR;
3503: END IF;

Line 3500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3496: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Allocate_Sales_Credits_PRE', FALSE);
3497: FND_MSG_PUB.ADD;
3498: END IF;
3499: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3501: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3502: RAISE FND_API.G_EXC_ERROR;
3503: END IF;
3504: END IF;

Line 3501: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

3497: FND_MSG_PUB.ADD;
3498: END IF;
3499: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3501: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3502: RAISE FND_API.G_EXC_ERROR;
3503: END IF;
3504: END IF;
3505:

Line 3502: RAISE FND_API.G_EXC_ERROR;

3498: END IF;
3499: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3501: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3502: RAISE FND_API.G_EXC_ERROR;
3503: END IF;
3504: END IF;
3505:
3506: END IF;

Line 3512: P_Init_Msg_List => FND_API.G_FALSE,

3508:
3509: -- Allocate Sales Credits
3510: ASO_SALES_CREDIT_PVT.Allocate_Sales_Credits (
3511: P_Api_Version_Number => 1.0,
3512: P_Init_Msg_List => FND_API.G_FALSE,
3513: P_Commit => FND_API.G_FALSE,
3514: P_control_rec => p_control_rec,
3515: P_Qte_Header_Rec => p_qte_header_rec,
3516: X_Qte_Header_Rec => x_qte_header_rec,

Line 3513: P_Commit => FND_API.G_FALSE,

3509: -- Allocate Sales Credits
3510: ASO_SALES_CREDIT_PVT.Allocate_Sales_Credits (
3511: P_Api_Version_Number => 1.0,
3512: P_Init_Msg_List => FND_API.G_FALSE,
3513: P_Commit => FND_API.G_FALSE,
3514: P_control_rec => p_control_rec,
3515: P_Qte_Header_Rec => p_qte_header_rec,
3516: X_Qte_Header_Rec => x_qte_header_rec,
3517: X_Return_Status => x_return_status,

Line 3526: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

3522: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3523: aso_debug_pub.add('After ASO_SALES_TEAM_PVT.Assign_Sales_Team: '||x_return_status,1,'Y');
3524: END IF;
3525:
3526: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3527: RAISE FND_API.G_EXC_ERROR;
3528: END IF;
3529: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3530: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3527: RAISE FND_API.G_EXC_ERROR;

3523: aso_debug_pub.add('After ASO_SALES_TEAM_PVT.Assign_Sales_Team: '||x_return_status,1,'Y');
3524: END IF;
3525:
3526: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3527: RAISE FND_API.G_EXC_ERROR;
3528: END IF;
3529: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3530: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3531: END IF;

Line 3529: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3525:
3526: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3527: RAISE FND_API.G_EXC_ERROR;
3528: END IF;
3529: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3530: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3531: END IF;
3532:
3533: -- Added new post Customer and Verical POST hooks

Line 3530: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3526: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3527: RAISE FND_API.G_EXC_ERROR;
3528: END IF;
3529: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3530: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3531: END IF;
3532:
3533: -- Added new post Customer and Verical POST hooks
3534:

Line 3545: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3541: X_Return_Status => X_Return_Status,
3542: X_Msg_Count => X_Msg_Count,
3543: X_Msg_Data => X_Msg_Data );
3544:
3545: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3546: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3547: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3548: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Allocate_Sales_Credits_POST', FALSE);
3549: FND_MSG_PUB.ADD;

Line 3551: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

3547: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3548: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Allocate_Sales_Credits_POST', FALSE);
3549: FND_MSG_PUB.ADD;
3550: END IF;
3551: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3553: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3554: RAISE FND_API.G_EXC_ERROR;
3555: END IF;

Line 3552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3548: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Allocate_Sales_Credits_POST', FALSE);
3549: FND_MSG_PUB.ADD;
3550: END IF;
3551: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3553: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3554: RAISE FND_API.G_EXC_ERROR;
3555: END IF;
3556: END IF;

Line 3553: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

3549: FND_MSG_PUB.ADD;
3550: END IF;
3551: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3553: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3554: RAISE FND_API.G_EXC_ERROR;
3555: END IF;
3556: END IF;
3557:

Line 3554: RAISE FND_API.G_EXC_ERROR;

3550: END IF;
3551: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3553: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3554: RAISE FND_API.G_EXC_ERROR;
3555: END IF;
3556: END IF;
3557:
3558: END IF; -- customer hook

Line 3570: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3566: X_Return_Status => X_Return_Status,
3567: X_Msg_Count => X_Msg_Count,
3568: X_Msg_Data => X_Msg_Data );
3569:
3570: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3571: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3572: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3573: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Allocate_Sales_Credits_POST', FALSE);
3574: FND_MSG_PUB.ADD;

Line 3576: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

3572: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3573: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Allocate_Sales_Credits_POST', FALSE);
3574: FND_MSG_PUB.ADD;
3575: END IF;
3576: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3578: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3579: RAISE FND_API.G_EXC_ERROR;
3580: END IF;

Line 3577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3573: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Allocate_Sales_Credits_POST', FALSE);
3574: FND_MSG_PUB.ADD;
3575: END IF;
3576: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3578: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3579: RAISE FND_API.G_EXC_ERROR;
3580: END IF;
3581: END IF;

Line 3578: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

3574: FND_MSG_PUB.ADD;
3575: END IF;
3576: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3578: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3579: RAISE FND_API.G_EXC_ERROR;
3580: END IF;
3581: END IF;
3582:

Line 3579: RAISE FND_API.G_EXC_ERROR;

3575: END IF;
3576: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3578: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3579: RAISE FND_API.G_EXC_ERROR;
3580: END IF;
3581: END IF;
3582:
3583: END IF; -- vertical hook

Line 3586: IF FND_API.to_Boolean( p_commit )

3582:
3583: END IF; -- vertical hook
3584:
3585: -- Standard check for p_commit
3586: IF FND_API.to_Boolean( p_commit )
3587: THEN
3588: COMMIT WORK;
3589: END IF;
3590:

Line 3600: WHEN FND_API.G_EXC_ERROR THEN

3596: );
3597:
3598: EXCEPTION
3599:
3600: WHEN FND_API.G_EXC_ERROR THEN
3601: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3602: P_API_NAME => L_API_NAME,
3603: P_PKG_NAME => G_PKG_NAME,
3604: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 3613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3609: X_MSG_DATA => X_MSG_DATA,
3610: X_RETURN_STATUS => X_RETURN_STATUS
3611: );
3612:
3613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3614: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3615: P_API_NAME => L_API_NAME,
3616: P_PKG_NAME => G_PKG_NAME,
3617: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

Line 3653: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

3649: l_event_key VARCHAR2(255);
3650:
3651: BEGIN
3652:
3653: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
3654:
3655: l_event_key := to_char(sysdate,'MMDDYYYY HH24MISS');
3656:
3657: wf_event.AddParameterToList (

Line 3693: x_return_Status :=FND_API.G_RET_STS_ERROR;

3689: EXCEPTION
3690:
3691: WHEN OTHERS THEN
3692:
3693: x_return_Status :=FND_API.G_RET_STS_ERROR;
3694:
3695: END Sales_Credit_Event_Pre;
3696:
3697:

Line 3709: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

3705: l_event_key VARCHAR2(255);
3706:
3707: BEGIN
3708:
3709: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
3710:
3711: l_event_key := to_char(sysdate,'MMDDYYYY HH24MISS');
3712:
3713: wf_event.AddParameterToList (

Line 3750: x_return_Status :=FND_API.G_RET_STS_ERROR;

3746: EXCEPTION
3747:
3748: WHEN OTHERS THEN
3749:
3750: x_return_Status :=FND_API.G_RET_STS_ERROR;
3751:
3752: END Sales_Credit_Event_Post;
3753:
3754:

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

3771:
3772:
3773: PROCEDURE Create_quote(
3774: P_Api_Version_Number IN NUMBER,
3775: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3776: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3777: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3778: P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
3779: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,

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

3772:
3773: PROCEDURE Create_quote(
3774: P_Api_Version_Number IN NUMBER,
3775: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3776: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3777: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3778: P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
3779: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
3780: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,

Line 3777: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

3773: PROCEDURE Create_quote(
3774: P_Api_Version_Number IN NUMBER,
3775: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3776: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3777: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3778: P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
3779: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
3780: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
3781: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,

Line 3879: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

3875:
3876: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
3877:
3878: -- Standard call to check for call compatibility.
3879: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3880: p_api_version_number,
3881: l_api_name,
3882: G_PKG_NAME) THEN
3883: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3883: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3879: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3880: p_api_version_number,
3881: l_api_name,
3882: G_PKG_NAME) THEN
3883: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3884: END IF;
3885:
3886: -- Initialize message list if p_init_msg_list is set to TRUE.
3887: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 3887: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3883: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3884: END IF;
3885:
3886: -- Initialize message list if p_init_msg_list is set to TRUE.
3887: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3888: FND_MSG_PUB.initialize;
3889: END IF;
3890:
3891: -- Initialize API return status to SUCCESS

Line 3892: x_return_status := FND_API.G_RET_STS_SUCCESS;

3888: FND_MSG_PUB.initialize;
3889: END IF;
3890:
3891: -- Initialize API return status to SUCCESS
3892: x_return_status := FND_API.G_RET_STS_SUCCESS;
3893:
3894: --
3895: -- API body
3896: --

Line 3970: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3966: X_Return_Status => X_Return_Status,
3967: X_Msg_Count => X_Msg_Count,
3968: X_Msg_Data => X_Msg_Data);
3969:
3970: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3971:
3972: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3973: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
3974: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Create_Quote_PRE', FALSE);

Line 3978: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

3974: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Create_Quote_PRE', FALSE);
3975: FND_MSG_PUB.ADD;
3976: END IF;
3977:
3978: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3980: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3981: RAISE FND_API.G_EXC_ERROR;
3982: END IF;

Line 3979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3975: FND_MSG_PUB.ADD;
3976: END IF;
3977:
3978: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3980: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3981: RAISE FND_API.G_EXC_ERROR;
3982: END IF;
3983:

Line 3980: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

3976: END IF;
3977:
3978: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3980: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3981: RAISE FND_API.G_EXC_ERROR;
3982: END IF;
3983:
3984: END IF;

Line 3981: RAISE FND_API.G_EXC_ERROR;

3977:
3978: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3980: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3981: RAISE FND_API.G_EXC_ERROR;
3982: END IF;
3983:
3984: END IF;
3985:

Line 4026: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4022: X_Return_Status => X_Return_Status,
4023: X_Msg_Count => X_Msg_Count,
4024: X_Msg_Data => X_Msg_Data );
4025:
4026: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4027:
4028: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4029: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
4030: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Create_Quote_PRE', FALSE);

Line 4034: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

4030: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Create_Quote_PRE', FALSE);
4031: FND_MSG_PUB.ADD;
4032: END IF;
4033:
4034: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4036: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4037: RAISE FND_API.G_EXC_ERROR;
4038: END IF;

Line 4035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4031: FND_MSG_PUB.ADD;
4032: END IF;
4033:
4034: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4036: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4037: RAISE FND_API.G_EXC_ERROR;
4038: END IF;
4039:

Line 4036: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

4032: END IF;
4033:
4034: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4036: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4037: RAISE FND_API.G_EXC_ERROR;
4038: END IF;
4039:
4040: END IF;

Line 4037: RAISE FND_API.G_EXC_ERROR;

4033:
4034: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4036: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4037: RAISE FND_API.G_EXC_ERROR;
4038: END IF;
4039:
4040: END IF;
4041:

Line 4077: P_Init_Msg_List => FND_API.G_FALSE,

4073: END LOOP;
4074:
4075: ASO_QUOTE_HEADERS_PVT.Create_quote(
4076: P_Api_Version_Number => 1.0,
4077: P_Init_Msg_List => FND_API.G_FALSE,
4078: P_Commit => FND_API.G_FALSE,
4079: p_validation_level => p_validation_level,
4080: P_Control_Rec => l_control_rec,
4081: P_qte_header_rec => l_qte_header_rec,

Line 4078: P_Commit => FND_API.G_FALSE,

4074:
4075: ASO_QUOTE_HEADERS_PVT.Create_quote(
4076: P_Api_Version_Number => 1.0,
4077: P_Init_Msg_List => FND_API.G_FALSE,
4078: P_Commit => FND_API.G_FALSE,
4079: p_validation_level => p_validation_level,
4080: P_Control_Rec => l_control_rec,
4081: P_qte_header_rec => l_qte_header_rec,
4082: P_Hd_Price_Attributes_Tbl => l_hd_Price_Attributes_Tbl,

Line 4142: IF x_return_status = FND_API.G_RET_STS_ERROR then

4138: aso_debug_pub.add('create_quote_pub: after create quote, starting user hooks (1)'||x_return_status,1, 'N');
4139: END IF;
4140:
4141: -- Check return status from the above procedure call
4142: IF x_return_status = FND_API.G_RET_STS_ERROR then
4143: raise FND_API.G_EXC_ERROR;
4144: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
4145: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4146: END IF;

Line 4143: raise FND_API.G_EXC_ERROR;

4139: END IF;
4140:
4141: -- Check return status from the above procedure call
4142: IF x_return_status = FND_API.G_RET_STS_ERROR then
4143: raise FND_API.G_EXC_ERROR;
4144: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
4145: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4146: END IF;
4147:

Line 4144: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

4140:
4141: -- Check return status from the above procedure call
4142: IF x_return_status = FND_API.G_RET_STS_ERROR then
4143: raise FND_API.G_EXC_ERROR;
4144: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
4145: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4146: END IF;
4147:
4148: --

Line 4145: raise FND_API.G_EXC_UNEXPECTED_ERROR;

4141: -- Check return status from the above procedure call
4142: IF x_return_status = FND_API.G_RET_STS_ERROR then
4143: raise FND_API.G_EXC_ERROR;
4144: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
4145: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4146: END IF;
4147:
4148: --
4149: -- End of API body.

Line 4192: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4188: X_Msg_Count => X_Msg_Count,
4189: X_Msg_Data => X_Msg_Data
4190: );
4191:
4192: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4193:
4194: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4195: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
4196: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Create_Quote_POST', FALSE);

Line 4200: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

4196: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Create_Quote_POST', FALSE);
4197: FND_MSG_PUB.ADD;
4198: END IF;
4199:
4200: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4202: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4203: RAISE FND_API.G_EXC_ERROR;
4204: END IF;

Line 4201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4197: FND_MSG_PUB.ADD;
4198: END IF;
4199:
4200: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4202: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4203: RAISE FND_API.G_EXC_ERROR;
4204: END IF;
4205:

Line 4202: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

4198: END IF;
4199:
4200: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4202: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4203: RAISE FND_API.G_EXC_ERROR;
4204: END IF;
4205:
4206: END IF;

Line 4203: RAISE FND_API.G_EXC_ERROR;

4199:
4200: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4202: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4203: RAISE FND_API.G_EXC_ERROR;
4204: END IF;
4205:
4206: END IF;
4207:

Line 4261: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4257: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4258: aso_debug_pub.add('create_quote_pub: after hooks (2)'||x_return_status,1, 'N');
4259: END IF;
4260:
4261: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4262:
4263: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4264: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
4265: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Create_Quote_POST', FALSE);

Line 4269: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

4265: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Create_Quote_POST', FALSE);
4266: FND_MSG_PUB.ADD;
4267: END IF;
4268:
4269: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4271: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4272: RAISE FND_API.G_EXC_ERROR;
4273: END IF;

Line 4270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4266: FND_MSG_PUB.ADD;
4267: END IF;
4268:
4269: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4271: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4272: RAISE FND_API.G_EXC_ERROR;
4273: END IF;
4274:

Line 4271: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

4267: END IF;
4268:
4269: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4271: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4272: RAISE FND_API.G_EXC_ERROR;
4273: END IF;
4274:
4275: END IF;

Line 4272: RAISE FND_API.G_EXC_ERROR;

4268:
4269: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4271: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4272: RAISE FND_API.G_EXC_ERROR;
4273: END IF;
4274:
4275: END IF;
4276:

Line 4280: IF FND_API.to_Boolean( p_commit ) THEN

4276:
4277: END IF; -- vertical hook
4278:
4279: -- Standard check for p_commit
4280: IF FND_API.to_Boolean( p_commit ) THEN
4281: COMMIT WORK;
4282: END IF;
4283:
4284: -- Standard call to get message count and if count is 1, get message info.

Line 4292: WHEN FND_API.G_EXC_ERROR THEN

4288: );
4289:
4290: EXCEPTION
4291:
4292: WHEN FND_API.G_EXC_ERROR THEN
4293: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4294: P_API_NAME => L_API_NAME
4295: ,P_PKG_NAME => G_PKG_NAME
4296: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 4304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4300: ,X_MSG_COUNT => X_MSG_COUNT
4301: ,X_MSG_DATA => X_MSG_DATA
4302: ,X_RETURN_STATUS => X_RETURN_STATUS);
4303:
4304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4305: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4306: P_API_NAME => L_API_NAME
4307: ,P_PKG_NAME => G_PKG_NAME
4308: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

4345:
4346:
4347: PROCEDURE Create_Quote_Service(
4348: P_Api_Version_Number IN NUMBER,
4349: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
4350: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
4351: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4352: P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
4353: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,

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

4346:
4347: PROCEDURE Create_Quote_Service(
4348: P_Api_Version_Number IN NUMBER,
4349: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
4350: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
4351: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4352: P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
4353: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
4354: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,

Line 4351: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

4347: PROCEDURE Create_Quote_Service(
4348: P_Api_Version_Number IN NUMBER,
4349: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
4350: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
4351: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4352: P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
4353: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
4354: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
4355: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,

Line 4493: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

4489:
4490: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
4491:
4492: -- Standard call to check for call compatibility.
4493: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4494: p_api_version_number,
4495: l_api_name,
4496: G_PKG_NAME) THEN
4497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4493: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4494: p_api_version_number,
4495: l_api_name,
4496: G_PKG_NAME) THEN
4497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4498: END IF;
4499:
4500: -- Initialize message list if p_init_msg_list is set to TRUE.
4501: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 4501: IF FND_API.to_Boolean( p_init_msg_list ) THEN

4497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4498: END IF;
4499:
4500: -- Initialize message list if p_init_msg_list is set to TRUE.
4501: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4502: FND_MSG_PUB.initialize;
4503: END IF;
4504:
4505: -- Initialize API return status to SUCCESS

Line 4506: x_return_status := FND_API.G_RET_STS_SUCCESS;

4502: FND_MSG_PUB.initialize;
4503: END IF;
4504:
4505: -- Initialize API return status to SUCCESS
4506: x_return_status := FND_API.G_RET_STS_SUCCESS;
4507:
4508: --
4509: -- API body
4510: --

Line 4531: IF P_Qte_Header_Rec.org_id IS NULL OR P_Qte_Header_Rec.org_id=FND_API.G_MISS_NUM THEN

4527: --AND P_Qte_Header_Rec <> G_MISS_Qte_Header_Rec THEN
4528: -- Prepare to call ASO_DEFAULTING_INT.default_entity to default the header record
4529: -- Prepare p_trigger_attribute_table
4530: i:=1;
4531: IF P_Qte_Header_Rec.org_id IS NULL OR P_Qte_Header_Rec.org_id=FND_API.G_MISS_NUM THEN
4532: l_Qte_Header_Rec.org_id := TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'),1,10));
4533: END IF;
4534: l_trigger_attribute_tbl(i):='Q_ORG_ID';
4535: i := i+1;

Line 4538: AND P_Qte_Header_Rec.original_system_reference <> FND_API.G_MISS_CHAR THEN

4534: l_trigger_attribute_tbl(i):='Q_ORG_ID';
4535: i := i+1;
4536:
4537: IF P_Qte_Header_Rec.original_system_reference IS NOT NULL
4538: AND P_Qte_Header_Rec.original_system_reference <> FND_API.G_MISS_CHAR THEN
4539: l_Qte_Header_Rec.original_system_reference := 'AIA_'||P_Qte_Header_Rec.original_system_reference;
4540: ELSE
4541: l_Qte_Header_Rec.original_system_reference := 'AIA';
4542: END IF;

Line 4544: IF P_Qte_Header_Rec.order_type_id IS NOT NULL AND P_Qte_Header_Rec.order_type_id<>FND_API.G_MISS_NUM THEN

4540: ELSE
4541: l_Qte_Header_Rec.original_system_reference := 'AIA';
4542: END IF;
4543:
4544: IF P_Qte_Header_Rec.order_type_id IS NOT NULL AND P_Qte_Header_Rec.order_type_id<>FND_API.G_MISS_NUM THEN
4545: l_trigger_attribute_tbl(i):='Q_ORDER_TYPE_ID';
4546: i := i+1;
4547: END IF;
4548:

Line 4549: IF P_Qte_Header_Rec.contract_id IS NOT NULL AND P_Qte_Header_Rec.contract_id <>FND_API.G_MISS_NUM THEN

4545: l_trigger_attribute_tbl(i):='Q_ORDER_TYPE_ID';
4546: i := i+1;
4547: END IF;
4548:
4549: IF P_Qte_Header_Rec.contract_id IS NOT NULL AND P_Qte_Header_Rec.contract_id <>FND_API.G_MISS_NUM THEN
4550: l_trigger_attribute_tbl(i):='Q_CONTRACT_ID';
4551: i := i+1;
4552: END IF;
4553:

Line 4554: IF P_Qte_Header_Rec.price_list_id IS NOT NULL AND P_Qte_Header_Rec.price_list_id<>FND_API.G_MISS_NUM THEN

4550: l_trigger_attribute_tbl(i):='Q_CONTRACT_ID';
4551: i := i+1;
4552: END IF;
4553:
4554: IF P_Qte_Header_Rec.price_list_id IS NOT NULL AND P_Qte_Header_Rec.price_list_id<>FND_API.G_MISS_NUM THEN
4555: l_trigger_attribute_tbl(i):='Q_PRICE_LIST_ID';
4556: i := i+1;
4557: END IF;
4558:

Line 4559: IF P_Qte_Header_Rec.resource_id IS NOT NULL AND P_Qte_Header_Rec.resource_id<>FND_API.G_MISS_NUM THEN

4555: l_trigger_attribute_tbl(i):='Q_PRICE_LIST_ID';
4556: i := i+1;
4557: END IF;
4558:
4559: IF P_Qte_Header_Rec.resource_id IS NOT NULL AND P_Qte_Header_Rec.resource_id<>FND_API.G_MISS_NUM THEN
4560: l_trigger_attribute_tbl(i):='Q_RESOURCE_ID';
4561: i := i+1;
4562: END IF;
4563:

Line 4565: AND P_Qte_Header_Rec.CUST_PARTY_ID <>FND_API.G_MISS_NUM THEN

4561: i := i+1;
4562: END IF;
4563:
4564: IF P_Qte_Header_Rec.CUST_PARTY_ID IS NOT NULL
4565: AND P_Qte_Header_Rec.CUST_PARTY_ID <>FND_API.G_MISS_NUM THEN
4566: l_trigger_attribute_tbl(i):='Q_CUST_PARTY_ID';
4567: i := i+1;
4568: END IF;
4569:

Line 4571: AND P_Qte_Header_Rec.CUST_ACCOUNT_ID <> FND_API.G_MISS_NUM THEN

4567: i := i+1;
4568: END IF;
4569:
4570: IF P_Qte_Header_Rec.CUST_ACCOUNT_ID IS NOT NULL
4571: AND P_Qte_Header_Rec.CUST_ACCOUNT_ID <> FND_API.G_MISS_NUM THEN
4572: l_trigger_attribute_tbl(i):='Q_CUST_ACCOUNT_ID';
4573: i := i+1;
4574: END IF;
4575:

Line 4577: AND P_Qte_Header_Rec.INVOICE_TO_CUST_ACCOUNT_ID<>FND_API.G_MISS_NUM THEN

4573: i := i+1;
4574: END IF;
4575:
4576: IF P_Qte_Header_Rec.INVOICE_TO_CUST_ACCOUNT_ID IS NOT NULL
4577: AND P_Qte_Header_Rec.INVOICE_TO_CUST_ACCOUNT_ID<>FND_API.G_MISS_NUM THEN
4578: l_trigger_attribute_tbl(i):='Q_INV_TO_CUST_ACCT_ID';
4579: i := i+1;
4580: END IF;
4581:

Line 4583: AND P_Qte_Header_Rec.INVOICE_TO_PARTY_SITE_ID <>FND_API.G_MISS_NUM THEN

4579: i := i+1;
4580: END IF;
4581:
4582: IF P_Qte_Header_Rec.INVOICE_TO_PARTY_SITE_ID IS NOT NULL
4583: AND P_Qte_Header_Rec.INVOICE_TO_PARTY_SITE_ID <>FND_API.G_MISS_NUM THEN
4584: l_trigger_attribute_tbl(i):='Q_INV_TO_PTY_SITE_ID';
4585: i := i+1;
4586: END IF;
4587: --END IF; -- quote header record attributes

Line 4591: AND P_hd_Shipment_Rec.SHIP_TO_CUST_ACCOUNT_ID<>FND_API.G_MISS_NUM THEN

4587: --END IF; -- quote header record attributes
4588: --IF P_hd_Shipment_Rec IS NOT NULL
4589: -- AND P_hd_Shipment_Rec <> G_MISS_SHIPMENT_REC THEN
4590: IF P_hd_shipment_Rec.SHIP_TO_CUST_ACCOUNT_ID IS NOT NULL
4591: AND P_hd_Shipment_Rec.SHIP_TO_CUST_ACCOUNT_ID<>FND_API.G_MISS_NUM THEN
4592: l_trigger_attribute_tbl(i):='Q_SHIP_TO_CUST_ACCT_ID';
4593: i := i+1;
4594: END IF;
4595: IF P_hd_shipment_Rec.SHIP_TO_PARTY_SITE_ID IS NOT NULL

Line 4596: AND P_hd_Shipment_Rec.SHIP_TO_PARTY_SITE_ID<>FND_API.G_MISS_NUM THEN

4592: l_trigger_attribute_tbl(i):='Q_SHIP_TO_CUST_ACCT_ID';
4593: i := i+1;
4594: END IF;
4595: IF P_hd_shipment_Rec.SHIP_TO_PARTY_SITE_ID IS NOT NULL
4596: AND P_hd_Shipment_Rec.SHIP_TO_PARTY_SITE_ID<>FND_API.G_MISS_NUM THEN
4597: l_trigger_attribute_tbl(i):='Q_SHIP_TO_PARTY_SITE_ID';
4598: END IF;
4599: --END IF;
4600:

Line 4603: l_def_control_rec.override_Trigger_Flag := FND_API.G_FALSE;

4599: --END IF;
4600:
4601: -- set header defaulting control record
4602: -- set control record
4603: l_def_control_rec.override_Trigger_Flag := FND_API.G_FALSE;
4604: l_def_control_rec.dependency_Flag := FND_API.G_FALSE;
4605: l_def_control_rec.defaulting_Flag := FND_API.G_TRUE;
4606: l_def_control_rec.application_type_code := 'QUOTING HTML';
4607: l_def_control_rec.defaulting_flow_code := 'CREATE';

Line 4604: l_def_control_rec.dependency_Flag := FND_API.G_FALSE;

4600:
4601: -- set header defaulting control record
4602: -- set control record
4603: l_def_control_rec.override_Trigger_Flag := FND_API.G_FALSE;
4604: l_def_control_rec.dependency_Flag := FND_API.G_FALSE;
4605: l_def_control_rec.defaulting_Flag := FND_API.G_TRUE;
4606: l_def_control_rec.application_type_code := 'QUOTING HTML';
4607: l_def_control_rec.defaulting_flow_code := 'CREATE';
4608:

Line 4605: l_def_control_rec.defaulting_Flag := FND_API.G_TRUE;

4601: -- set header defaulting control record
4602: -- set control record
4603: l_def_control_rec.override_Trigger_Flag := FND_API.G_FALSE;
4604: l_def_control_rec.dependency_Flag := FND_API.G_FALSE;
4605: l_def_control_rec.defaulting_Flag := FND_API.G_TRUE;
4606: l_def_control_rec.application_type_code := 'QUOTING HTML';
4607: l_def_control_rec.defaulting_flow_code := 'CREATE';
4608:
4609: l_db_object_name := 'ASO_AK_QUOTE_HEADER_V';

Line 4613: P_INIT_MSG_LIST => FND_API.G_TRUE,

4609: l_db_object_name := 'ASO_AK_QUOTE_HEADER_V';
4610:
4611: Aso_Defaulting_Int.Default_Entity (
4612: P_API_VERSION => 1.0,
4613: P_INIT_MSG_LIST => FND_API.G_TRUE,
4614: P_COMMIT => FND_API.G_TRUE,
4615: P_CONTROL_REC => l_def_control_rec,
4616: P_DATABASE_OBJECT_NAME => l_db_object_name,
4617: P_TRIGGER_ATTRIBUTES_TBL => l_trigger_attribute_tbl,

Line 4614: P_COMMIT => FND_API.G_TRUE,

4610:
4611: Aso_Defaulting_Int.Default_Entity (
4612: P_API_VERSION => 1.0,
4613: P_INIT_MSG_LIST => FND_API.G_TRUE,
4614: P_COMMIT => FND_API.G_TRUE,
4615: P_CONTROL_REC => l_def_control_rec,
4616: P_DATABASE_OBJECT_NAME => l_db_object_name,
4617: P_TRIGGER_ATTRIBUTES_TBL => l_trigger_attribute_tbl,
4618: P_QUOTE_HEADER_REC => l_qte_header_rec,

Line 4665: IF x_return_status = FND_API.G_RET_STS_ERROR then

4661: DBMS_OUTPUT.PUT_LINE('ship_to_party_site_id = ' || lx_hd_shipment_rec.ship_to_party_site_id);
4662: DBMS_OUTPUT.PUT_LINE('ship_to_cust_accuont_id = ' || lx_hd_shipment_rec.ship_to_cust_account_id);
4663: */
4664: -- Check return status from the above procedure call
4665: IF x_return_status = FND_API.G_RET_STS_ERROR then
4666: raise FND_API.G_EXC_ERROR;
4667: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
4668: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4669: END IF;

Line 4666: raise FND_API.G_EXC_ERROR;

4662: DBMS_OUTPUT.PUT_LINE('ship_to_cust_accuont_id = ' || lx_hd_shipment_rec.ship_to_cust_account_id);
4663: */
4664: -- Check return status from the above procedure call
4665: IF x_return_status = FND_API.G_RET_STS_ERROR then
4666: raise FND_API.G_EXC_ERROR;
4667: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
4668: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4669: END IF;
4670: -- validate defaulting data

Line 4667: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

4663: */
4664: -- Check return status from the above procedure call
4665: IF x_return_status = FND_API.G_RET_STS_ERROR then
4666: raise FND_API.G_EXC_ERROR;
4667: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
4668: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4669: END IF;
4670: -- validate defaulting data
4671: /*

Line 4668: raise FND_API.G_EXC_UNEXPECTED_ERROR;

4664: -- Check return status from the above procedure call
4665: IF x_return_status = FND_API.G_RET_STS_ERROR then
4666: raise FND_API.G_EXC_ERROR;
4667: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
4668: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4669: END IF;
4670: -- validate defaulting data
4671: /*
4672: ASO_VALIDATE_PVT.VALIDATE_DEFAULTING_DATA(

Line 4698: IF lx_return_status = FND_API.G_RET_STS_ERROR then

4694: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4695: aso_debug_pub.add('create_quote_service: after call default header entity validation)'||lx_return_status,1, 'N');
4696: END IF;
4697: DBMS_OUTPUT.PUT_LINE('header default validaton return=' || x_return_status);
4698: IF lx_return_status = FND_API.G_RET_STS_ERROR then
4699: raise FND_API.G_EXC_ERROR;
4700: elsif lx_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
4701: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4702: END IF;

Line 4699: raise FND_API.G_EXC_ERROR;

4695: aso_debug_pub.add('create_quote_service: after call default header entity validation)'||lx_return_status,1, 'N');
4696: END IF;
4697: DBMS_OUTPUT.PUT_LINE('header default validaton return=' || x_return_status);
4698: IF lx_return_status = FND_API.G_RET_STS_ERROR then
4699: raise FND_API.G_EXC_ERROR;
4700: elsif lx_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
4701: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4702: END IF;
4703: */

Line 4700: elsif lx_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

4696: END IF;
4697: DBMS_OUTPUT.PUT_LINE('header default validaton return=' || x_return_status);
4698: IF lx_return_status = FND_API.G_RET_STS_ERROR then
4699: raise FND_API.G_EXC_ERROR;
4700: elsif lx_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
4701: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4702: END IF;
4703: */
4704: l_qte_header_rec := lx_qte_header_rec;

Line 4701: raise FND_API.G_EXC_UNEXPECTED_ERROR;

4697: DBMS_OUTPUT.PUT_LINE('header default validaton return=' || x_return_status);
4698: IF lx_return_status = FND_API.G_RET_STS_ERROR then
4699: raise FND_API.G_EXC_ERROR;
4700: elsif lx_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
4701: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4702: END IF;
4703: */
4704: l_qte_header_rec := lx_qte_header_rec;
4705: l_hd_shipment_rec := lx_hd_shipment_rec;

Line 4711: OR l_qte_header_rec.quote_source_code <> FND_API.G_MISS_CHAR) THEN

4707: l_hd_payment_tbl(1) := l_hd_payment_rec;
4708:
4709: -- check additional columns
4710: IF(l_qte_header_rec.quote_source_code IS NULL
4711: OR l_qte_header_rec.quote_source_code <> FND_API.G_MISS_CHAR) THEN
4712: l_qte_header_rec.quote_source_code := 'Order Capture Quotes';
4713: END IF;
4714:
4715: -- Loop over lines and prepare lines Recored

Line 4718: l_def_control_rec.override_Trigger_Flag := FND_API.G_FALSE;

4714:
4715: -- Loop over lines and prepare lines Recored
4716: l_db_object_name := 'ASO_AK_QUOTE_LINE_V';
4717: -- control record for lines defaulting
4718: l_def_control_rec.override_Trigger_Flag := FND_API.G_FALSE;
4719: l_def_control_rec.dependency_Flag := FND_API.G_FALSE;
4720: l_def_control_rec.defaulting_Flag := FND_API.G_TRUE;
4721: l_def_control_rec.application_type_code := 'QUOTING HTML';
4722: l_def_control_rec.defaulting_flow_code := 'CREATE';

Line 4719: l_def_control_rec.dependency_Flag := FND_API.G_FALSE;

4715: -- Loop over lines and prepare lines Recored
4716: l_db_object_name := 'ASO_AK_QUOTE_LINE_V';
4717: -- control record for lines defaulting
4718: l_def_control_rec.override_Trigger_Flag := FND_API.G_FALSE;
4719: l_def_control_rec.dependency_Flag := FND_API.G_FALSE;
4720: l_def_control_rec.defaulting_Flag := FND_API.G_TRUE;
4721: l_def_control_rec.application_type_code := 'QUOTING HTML';
4722: l_def_control_rec.defaulting_flow_code := 'CREATE';
4723:

Line 4720: l_def_control_rec.defaulting_Flag := FND_API.G_TRUE;

4716: l_db_object_name := 'ASO_AK_QUOTE_LINE_V';
4717: -- control record for lines defaulting
4718: l_def_control_rec.override_Trigger_Flag := FND_API.G_FALSE;
4719: l_def_control_rec.dependency_Flag := FND_API.G_FALSE;
4720: l_def_control_rec.defaulting_Flag := FND_API.G_TRUE;
4721: l_def_control_rec.application_type_code := 'QUOTING HTML';
4722: l_def_control_rec.defaulting_flow_code := 'CREATE';
4723:
4724: OPEN C_Get_Master_Org_Id (l_qte_header_rec.org_id);

Line 4739: OR l_qte_line_tbl(i).uom_code = FND_API.G_MISS_CHAR) THEN

4735: FETCH C_Get_Item_Info INTO l_primary_uom_code, l_serviceable_product_flag, l_bom_item_type;
4736: CLOSE C_Get_Item_Info;
4737:
4738: IF (l_qte_line_tbl(i).uom_code IS NULL
4739: OR l_qte_line_tbl(i).uom_code = FND_API.G_MISS_CHAR) THEN
4740: l_qte_line_tbl(i).uom_code := l_primary_uom_code;
4741: END IF;
4742:
4743: IF l_bom_item_type = 1 THEN -- model item

Line 4780: AND p_qte_line_tbl(i).order_line_type_id <> FND_API.G_MISS_NUM) THEN

4776: l_trigger_attribute_tbl := ASO_Defaulting_Int.G_MISS_ATTRIBUTE_CODES_TBL;
4777:
4778: k :=1;
4779: IF (p_qte_line_tbl(i).order_line_type_id IS NOT NULL
4780: AND p_qte_line_tbl(i).order_line_type_id <> FND_API.G_MISS_NUM) THEN
4781: l_trigger_attribute_tbl(k) :='L_ORDER_LINE_TYPE_ID';
4782: k := k+1;
4783: END IF;
4784:

Line 4786: AND p_qte_line_tbl(i).agreement_id <> FND_API.G_MISS_NUM) THEN

4782: k := k+1;
4783: END IF;
4784:
4785: IF (p_qte_line_tbl(i).agreement_id IS NOT NULL
4786: AND p_qte_line_tbl(i).agreement_id <> FND_API.G_MISS_NUM) THEN
4787: l_trigger_attribute_tbl(k) :='L_AGREEMENT_ID';
4788: k := k+1;
4789: END IF;
4790:

Line 4792: AND p_qte_line_tbl(i).invoice_to_cust_account_id <> FND_API.G_MISS_NUM) THEN

4788: k := k+1;
4789: END IF;
4790:
4791: IF (p_qte_line_tbl(i).invoice_to_cust_account_id IS NOT NULL
4792: AND p_qte_line_tbl(i).invoice_to_cust_account_id <> FND_API.G_MISS_NUM) THEN
4793: l_trigger_attribute_tbl(k) :='L_INV_TO_CUST_ACCT_ID';
4794: k := k+1;
4795: END IF;
4796:

Line 4798: AND p_qte_line_tbl(i).invoice_to_party_site_id <> FND_API.G_MISS_NUM) THEN

4794: k := k+1;
4795: END IF;
4796:
4797: IF (p_qte_line_tbl(i).invoice_to_party_site_id IS NOT NULL
4798: AND p_qte_line_tbl(i).invoice_to_party_site_id <> FND_API.G_MISS_NUM) THEN
4799: l_trigger_attribute_tbl(k) :='L_INV_TO_PTY_SITE_ID';
4800: k := k+1;
4801: END IF;
4802: /*

Line 4804: AND p_qte_line_tbl(i).line_ship_to_cust_acct_number <> FND_API.G_MISS_NUM) THEN

4800: k := k+1;
4801: END IF;
4802: /*
4803: IF (p_qte_line_tbl(i).line_ship_to_cust_acct_number IS NOT NULL
4804: AND p_qte_line_tbl(i).line_ship_to_cust_acct_number <> FND_API.G_MISS_NUM) THEN
4805: l_trigger_attribute_tbl(k) := 'L_SHIP_TO_CUST_ACCT_ID';
4806: k := k+1;
4807: END IF;
4808:

Line 4810: AND p_qte_line_tbl(i).ship_to_address1 <> FND_API.G_MISS_CHAR) THEN

4806: k := k+1;
4807: END IF;
4808:
4809: IF (p_qte_line_tbl(i).ship_to_address1 IS NOT NULL
4810: AND p_qte_line_tbl(i).ship_to_address1 <> FND_API.G_MISS_CHAR) THEN
4811: l_trigger_attribute_tbl(k) := 'L_SHIP_TO_PARTY_SITE_ID';
4812: k := k+1;
4813: END IF;
4814: */

Line 4816: AND p_qte_line_tbl(i).price_list_id <> FND_API.G_MISS_NUM) THEN

4812: k := k+1;
4813: END IF;
4814: */
4815: IF (p_qte_line_tbl(i).price_list_id IS NOT NULL
4816: AND p_qte_line_tbl(i).price_list_id <> FND_API.G_MISS_NUM) THEN
4817: l_trigger_attribute_tbl(k) := 'L_PRICE_LIST_ID';
4818: END IF;
4819:
4820: l_qte_line_rec := p_qte_line_tbl(i);

Line 4824: P_INIT_MSG_LIST => FND_API.G_TRUE,

4820: l_qte_line_rec := p_qte_line_tbl(i);
4821:
4822: Aso_Defaulting_Int.Default_Entity (
4823: P_API_VERSION => 1.0,
4824: P_INIT_MSG_LIST => FND_API.G_TRUE,
4825: P_COMMIT => FND_API.G_TRUE,
4826: P_CONTROL_REC => l_def_control_rec,
4827: P_DATABASE_OBJECT_NAME => l_db_object_name,
4828: P_TRIGGER_ATTRIBUTES_TBL => l_trigger_attribute_tbl,

Line 4825: P_COMMIT => FND_API.G_TRUE,

4821:
4822: Aso_Defaulting_Int.Default_Entity (
4823: P_API_VERSION => 1.0,
4824: P_INIT_MSG_LIST => FND_API.G_TRUE,
4825: P_COMMIT => FND_API.G_TRUE,
4826: P_CONTROL_REC => l_def_control_rec,
4827: P_DATABASE_OBJECT_NAME => l_db_object_name,
4828: P_TRIGGER_ATTRIBUTES_TBL => l_trigger_attribute_tbl,
4829: P_QUOTE_HEADER_REC => l_qte_header_rec,

Line 4860: IF x_return_status = FND_API.G_RET_STS_ERROR then

4856: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4857: aso_debug_pub.add('create_quote_service: after call default line entity '||k||lx_return_status,1, 'N');
4858: END IF;
4859: -- Check return status from the above procedure call
4860: IF x_return_status = FND_API.G_RET_STS_ERROR then
4861: raise FND_API.G_EXC_ERROR;
4862: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
4863: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4864: END IF;

Line 4861: raise FND_API.G_EXC_ERROR;

4857: aso_debug_pub.add('create_quote_service: after call default line entity '||k||lx_return_status,1, 'N');
4858: END IF;
4859: -- Check return status from the above procedure call
4860: IF x_return_status = FND_API.G_RET_STS_ERROR then
4861: raise FND_API.G_EXC_ERROR;
4862: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
4863: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4864: END IF;
4865:

Line 4862: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

4858: END IF;
4859: -- Check return status from the above procedure call
4860: IF x_return_status = FND_API.G_RET_STS_ERROR then
4861: raise FND_API.G_EXC_ERROR;
4862: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
4863: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4864: END IF;
4865:
4866: l_qte_line_tbl (i) := lx_qte_line_rec;

Line 4863: raise FND_API.G_EXC_UNEXPECTED_ERROR;

4859: -- Check return status from the above procedure call
4860: IF x_return_status = FND_API.G_RET_STS_ERROR then
4861: raise FND_API.G_EXC_ERROR;
4862: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
4863: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4864: END IF;
4865:
4866: l_qte_line_tbl (i) := lx_qte_line_rec;
4867:

Line 4870: OR l_qte_line_tbl(i).line_category_code <> FND_API.G_MISS_CHAR THEN

4866: l_qte_line_tbl (i) := lx_qte_line_rec;
4867:
4868: -- additional check
4869: IF l_qte_line_tbl(i).line_category_code IS NULL
4870: OR l_qte_line_tbl(i).line_category_code <> FND_API.G_MISS_CHAR THEN
4871: l_qte_line_tbl(i).line_category_code := 'ORDER';
4872: END IF;
4873:
4874: END LOOP;

Line 4966: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4962: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4963: aso_debug_pub.add('create_quote_service_pub: after create_quote'||x_return_status,1, 'N');
4964: END IF;
4965:
4966: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4967:
4968: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4969: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
4970: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_PUB.Create_Quote', FALSE);

Line 4974: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

4970: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_PUB.Create_Quote', FALSE);
4971: FND_MSG_PUB.ADD;
4972: END IF;
4973:
4974: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4976: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4977: RAISE FND_API.G_EXC_ERROR;
4978: END IF;

Line 4975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4971: FND_MSG_PUB.ADD;
4972: END IF;
4973:
4974: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4976: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4977: RAISE FND_API.G_EXC_ERROR;
4978: END IF;
4979:

Line 4976: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

4972: END IF;
4973:
4974: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4976: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4977: RAISE FND_API.G_EXC_ERROR;
4978: END IF;
4979:
4980: END IF;

Line 4977: RAISE FND_API.G_EXC_ERROR;

4973:
4974: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4976: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4977: RAISE FND_API.G_EXC_ERROR;
4978: END IF;
4979:
4980: END IF;
4981:

Line 4984: IF FND_API.to_Boolean( p_commit ) THEN

4980: END IF;
4981:
4982:
4983: -- Standard check for p_commit
4984: IF FND_API.to_Boolean( p_commit ) THEN
4985: COMMIT WORK;
4986: END IF;
4987:
4988: -- Standard call to get message count and if count is 1, get message info.

Line 4996: WHEN FND_API.G_EXC_ERROR THEN

4992: );
4993:
4994: EXCEPTION
4995:
4996: WHEN FND_API.G_EXC_ERROR THEN
4997: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4998: P_API_NAME => L_API_NAME
4999: ,P_PKG_NAME => G_PKG_NAME
5000: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 5008: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5004: ,X_MSG_COUNT => X_MSG_COUNT
5005: ,X_MSG_DATA => X_MSG_DATA
5006: ,X_RETURN_STATUS => X_RETURN_STATUS);
5007:
5008: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5009: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
5010: P_API_NAME => L_API_NAME
5011: ,P_PKG_NAME => G_PKG_NAME
5012: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

5045:
5046:
5047: PROCEDURE Update_quote(
5048: P_Api_Version_Number IN NUMBER,
5049: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
5050: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
5051: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
5052: P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
5053: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,

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

5046:
5047: PROCEDURE Update_quote(
5048: P_Api_Version_Number IN NUMBER,
5049: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
5050: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
5051: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
5052: P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
5053: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
5054: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,

Line 5051: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

5047: PROCEDURE Update_quote(
5048: P_Api_Version_Number IN NUMBER,
5049: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
5050: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
5051: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
5052: P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
5053: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
5054: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
5055: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,

Line 5155: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

5151:
5152: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
5153:
5154: -- Standard call to check for call compatibility.
5155: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
5156: p_api_version_number,
5157: l_api_name,
5158: G_PKG_NAME) THEN
5159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5155: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
5156: p_api_version_number,
5157: l_api_name,
5158: G_PKG_NAME) THEN
5159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5160: END IF;
5161:
5162: -- Initialize message list if p_init_msg_list is set to TRUE.
5163: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 5163: IF FND_API.to_Boolean( p_init_msg_list ) THEN

5159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5160: END IF;
5161:
5162: -- Initialize message list if p_init_msg_list is set to TRUE.
5163: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5164: FND_MSG_PUB.initialize;
5165: END IF;
5166:
5167: -- Initialize API return status to SUCCESS

Line 5168: x_return_status := FND_API.G_RET_STS_SUCCESS;

5164: FND_MSG_PUB.initialize;
5165: END IF;
5166:
5167: -- Initialize API return status to SUCCESS
5168: x_return_status := FND_API.G_RET_STS_SUCCESS;
5169:
5170: --
5171: -- API body
5172: --

Line 5256: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5252: X_Msg_Count => X_Msg_Count,
5253: X_Msg_Data => X_Msg_Data
5254: );
5255:
5256: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5257:
5258: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5259: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
5260: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.update_Quote_PRE', FALSE);

Line 5264: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

5260: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.update_Quote_PRE', FALSE);
5261: FND_MSG_PUB.ADD;
5262: END IF;
5263:
5264: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5266: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
5267: RAISE FND_API.G_EXC_ERROR;
5268: END IF;

Line 5265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5261: FND_MSG_PUB.ADD;
5262: END IF;
5263:
5264: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5266: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
5267: RAISE FND_API.G_EXC_ERROR;
5268: END IF;
5269:

Line 5266: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

5262: END IF;
5263:
5264: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5266: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
5267: RAISE FND_API.G_EXC_ERROR;
5268: END IF;
5269:
5270: END IF;

Line 5267: RAISE FND_API.G_EXC_ERROR;

5263:
5264: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5266: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
5267: RAISE FND_API.G_EXC_ERROR;
5268: END IF;
5269:
5270: END IF;
5271:

Line 5313: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5309: X_Msg_Count => X_Msg_Count,
5310: X_Msg_Data => X_Msg_Data
5311: );
5312:
5313: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5314:
5315: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5316: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
5317: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Update_Quote_PRE', FALSE);

Line 5321: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

5317: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Update_Quote_PRE', FALSE);
5318: FND_MSG_PUB.ADD;
5319: END IF;
5320:
5321: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5323: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
5324: RAISE FND_API.G_EXC_ERROR;
5325: END IF;

Line 5322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5318: FND_MSG_PUB.ADD;
5319: END IF;
5320:
5321: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5323: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
5324: RAISE FND_API.G_EXC_ERROR;
5325: END IF;
5326:

Line 5323: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

5319: END IF;
5320:
5321: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5323: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
5324: RAISE FND_API.G_EXC_ERROR;
5325: END IF;
5326:
5327: END IF;

Line 5324: RAISE FND_API.G_EXC_ERROR;

5320:
5321: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5323: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
5324: RAISE FND_API.G_EXC_ERROR;
5325: END IF;
5326:
5327: END IF;
5328:

Line 5367: P_Init_Msg_List => FND_API.G_FALSE,

5363: END LOOP;
5364:
5365: ASO_QUOTE_HEADERS_PVT.update_quote(
5366: P_Api_Version_Number => 1.0,
5367: P_Init_Msg_List => FND_API.G_FALSE,
5368: P_Commit => FND_API.G_FALSE,
5369: p_validation_level => p_validation_level,
5370: P_Control_Rec => l_control_rec,
5371: P_qte_header_rec => l_qte_header_rec,

Line 5368: P_Commit => FND_API.G_FALSE,

5364:
5365: ASO_QUOTE_HEADERS_PVT.update_quote(
5366: P_Api_Version_Number => 1.0,
5367: P_Init_Msg_List => FND_API.G_FALSE,
5368: P_Commit => FND_API.G_FALSE,
5369: p_validation_level => p_validation_level,
5370: P_Control_Rec => l_control_rec,
5371: P_qte_header_rec => l_qte_header_rec,
5372: P_Hd_Price_Attributes_Tbl => l_hd_Price_Attributes_Tbl,

Line 5432: IF x_return_status = FND_API.G_RET_STS_ERROR then

5428: aso_debug_pub.add('update_quote_pub: after update quote, starting user hooks (1)'||x_return_status,1, 'N');
5429: END IF;
5430:
5431: -- Check return status from the above procedure call
5432: IF x_return_status = FND_API.G_RET_STS_ERROR then
5433: raise FND_API.G_EXC_ERROR;
5434: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
5435: raise FND_API.G_EXC_UNEXPECTED_ERROR;
5436: END IF;

Line 5433: raise FND_API.G_EXC_ERROR;

5429: END IF;
5430:
5431: -- Check return status from the above procedure call
5432: IF x_return_status = FND_API.G_RET_STS_ERROR then
5433: raise FND_API.G_EXC_ERROR;
5434: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
5435: raise FND_API.G_EXC_UNEXPECTED_ERROR;
5436: END IF;
5437:

Line 5434: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

5430:
5431: -- Check return status from the above procedure call
5432: IF x_return_status = FND_API.G_RET_STS_ERROR then
5433: raise FND_API.G_EXC_ERROR;
5434: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
5435: raise FND_API.G_EXC_UNEXPECTED_ERROR;
5436: END IF;
5437:
5438: IF (JTF_USR_HKS.ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'C')) THEN

Line 5435: raise FND_API.G_EXC_UNEXPECTED_ERROR;

5431: -- Check return status from the above procedure call
5432: IF x_return_status = FND_API.G_RET_STS_ERROR then
5433: raise FND_API.G_EXC_ERROR;
5434: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
5435: raise FND_API.G_EXC_UNEXPECTED_ERROR;
5436: END IF;
5437:
5438: IF (JTF_USR_HKS.ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'C')) THEN
5439:

Line 5476: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5472: X_Msg_Count => X_Msg_Count,
5473: X_Msg_Data => X_Msg_Data
5474: );
5475:
5476: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5477:
5478: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5479: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
5480: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Update_Quote_POST', FALSE);

Line 5484: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

5480: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Update_Quote_POST', FALSE);
5481: FND_MSG_PUB.ADD;
5482: END IF;
5483:
5484: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5486: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
5487: RAISE FND_API.G_EXC_ERROR;
5488: END IF;

Line 5485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5481: FND_MSG_PUB.ADD;
5482: END IF;
5483:
5484: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5486: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
5487: RAISE FND_API.G_EXC_ERROR;
5488: END IF;
5489:

Line 5486: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

5482: END IF;
5483:
5484: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5486: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
5487: RAISE FND_API.G_EXC_ERROR;
5488: END IF;
5489:
5490: END IF;

Line 5487: RAISE FND_API.G_EXC_ERROR;

5483:
5484: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5486: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
5487: RAISE FND_API.G_EXC_ERROR;
5488: END IF;
5489:
5490: END IF;
5491:

Line 5544: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5540: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5541: aso_debug_pub.add('update_quote_pub: after vertical hooks'||x_return_status,1, 'N');
5542: END IF;
5543:
5544: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5545:
5546: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5547: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
5548: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Update_Quote_POST', FALSE);

Line 5552: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

5548: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Update_Quote_POST', FALSE);
5549: FND_MSG_PUB.ADD;
5550: END IF;
5551:
5552: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5554: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
5555: RAISE FND_API.G_EXC_ERROR;
5556: END IF;

Line 5553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5549: FND_MSG_PUB.ADD;
5550: END IF;
5551:
5552: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5554: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
5555: RAISE FND_API.G_EXC_ERROR;
5556: END IF;
5557:

Line 5554: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

5550: END IF;
5551:
5552: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5554: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
5555: RAISE FND_API.G_EXC_ERROR;
5556: END IF;
5557:
5558: END IF;

Line 5555: RAISE FND_API.G_EXC_ERROR;

5551:
5552: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5554: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
5555: RAISE FND_API.G_EXC_ERROR;
5556: END IF;
5557:
5558: END IF;
5559:

Line 5567: IF FND_API.to_Boolean( p_commit ) THEN

5563: -- End of API body
5564: --
5565:
5566: -- Standard check for p_commit
5567: IF FND_API.to_Boolean( p_commit ) THEN
5568: COMMIT WORK;
5569: END IF;
5570:
5571: -- Standard call to get message count and if count is 1, get message info.

Line 5578: WHEN FND_API.G_EXC_ERROR THEN

5574:
5575:
5576: EXCEPTION
5577:
5578: WHEN FND_API.G_EXC_ERROR THEN
5579: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
5580: P_API_NAME => L_API_NAME
5581: ,P_PKG_NAME => G_PKG_NAME
5582: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 5590: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5586: ,X_MSG_COUNT => X_MSG_COUNT
5587: ,X_MSG_DATA => X_MSG_DATA
5588: ,X_RETURN_STATUS => X_RETURN_STATUS);
5589:
5590: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5591: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
5592: P_API_NAME => L_API_NAME
5593: ,P_PKG_NAME => G_PKG_NAME
5594: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 5619: P_Init_Msg_List IN VARCHAR2 := FND_API.G_TRUE, -- rassharm

5615: -- ER 3177722
5616: Procedure validate_model_configuration
5617: (
5618: P_Api_Version_Number IN NUMBER,
5619: P_Init_Msg_List IN VARCHAR2 := FND_API.G_TRUE, -- rassharm
5620: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
5621: P_Quote_header_id IN NUMBER,
5622: p_Quote_line_id IN NUMBER := FND_API.G_MISS_NUM,
5623: P_UPDATE_QUOTE IN VARCHAR2 := FND_API.G_FALSE,

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

5616: Procedure validate_model_configuration
5617: (
5618: P_Api_Version_Number IN NUMBER,
5619: P_Init_Msg_List IN VARCHAR2 := FND_API.G_TRUE, -- rassharm
5620: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
5621: P_Quote_header_id IN NUMBER,
5622: p_Quote_line_id IN NUMBER := FND_API.G_MISS_NUM,
5623: P_UPDATE_QUOTE IN VARCHAR2 := FND_API.G_FALSE,
5624: P_Config_EFFECTIVE_DATE IN Date := FND_API.G_MISS_DATE,

Line 5622: p_Quote_line_id IN NUMBER := FND_API.G_MISS_NUM,

5618: P_Api_Version_Number IN NUMBER,
5619: P_Init_Msg_List IN VARCHAR2 := FND_API.G_TRUE, -- rassharm
5620: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
5621: P_Quote_header_id IN NUMBER,
5622: p_Quote_line_id IN NUMBER := FND_API.G_MISS_NUM,
5623: P_UPDATE_QUOTE IN VARCHAR2 := FND_API.G_FALSE,
5624: P_Config_EFFECTIVE_DATE IN Date := FND_API.G_MISS_DATE,
5625: P_Config_model_lookup_DATE IN Date := FND_API.G_MISS_DATE,
5626: X_Config_tbl OUT NOCOPY /* file.sql.39 change */ Config_Vaild_Tbl_Type,

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

5619: P_Init_Msg_List IN VARCHAR2 := FND_API.G_TRUE, -- rassharm
5620: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
5621: P_Quote_header_id IN NUMBER,
5622: p_Quote_line_id IN NUMBER := FND_API.G_MISS_NUM,
5623: P_UPDATE_QUOTE IN VARCHAR2 := FND_API.G_FALSE,
5624: P_Config_EFFECTIVE_DATE IN Date := FND_API.G_MISS_DATE,
5625: P_Config_model_lookup_DATE IN Date := FND_API.G_MISS_DATE,
5626: X_Config_tbl OUT NOCOPY /* file.sql.39 change */ Config_Vaild_Tbl_Type,
5627: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 5624: P_Config_EFFECTIVE_DATE IN Date := FND_API.G_MISS_DATE,

5620: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
5621: P_Quote_header_id IN NUMBER,
5622: p_Quote_line_id IN NUMBER := FND_API.G_MISS_NUM,
5623: P_UPDATE_QUOTE IN VARCHAR2 := FND_API.G_FALSE,
5624: P_Config_EFFECTIVE_DATE IN Date := FND_API.G_MISS_DATE,
5625: P_Config_model_lookup_DATE IN Date := FND_API.G_MISS_DATE,
5626: X_Config_tbl OUT NOCOPY /* file.sql.39 change */ Config_Vaild_Tbl_Type,
5627: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
5628: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 5625: P_Config_model_lookup_DATE IN Date := FND_API.G_MISS_DATE,

5621: P_Quote_header_id IN NUMBER,
5622: p_Quote_line_id IN NUMBER := FND_API.G_MISS_NUM,
5623: P_UPDATE_QUOTE IN VARCHAR2 := FND_API.G_FALSE,
5624: P_Config_EFFECTIVE_DATE IN Date := FND_API.G_MISS_DATE,
5625: P_Config_model_lookup_DATE IN Date := FND_API.G_MISS_DATE,
5626: X_Config_tbl OUT NOCOPY /* file.sql.39 change */ Config_Vaild_Tbl_Type,
5627: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
5628: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
5629: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

5638:
5639: l_config_index number:=0;
5640: l_control_rec_bv ASO_QUOTE_PUB.Control_Rec_Type;
5641:
5642: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
5643: l_api_name VARCHAR2(30) := 'VALIDATE_MODEL_CONFIGURATION'; -- removed CONSTANT as part of fix for Bug 12679929
5644: l_api_version_number CONSTANT NUMBER := 1.0;
5645: l_complete_configuration_flag VARCHAR2(1);
5646: l_valid_configuration_flag VARCHAR2(1);

Line 5680: x_return_status := FND_API.G_RET_STS_SUCCESS;

5676:
5677: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
5678:
5679: --dbms_output.put_line('Testing in Progress');
5680: x_return_status := FND_API.G_RET_STS_SUCCESS;
5681:
5682:
5683: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5684: aso_debug_pub.add('ASO_QUOTE_PUB: Validate_Model_Configuration Begins', 1, 'Y');

Line 5688: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

5684: aso_debug_pub.add('ASO_QUOTE_PUB: Validate_Model_Configuration Begins', 1, 'Y');
5685: aso_debug_pub.add('ASO_QUOTE_PUB: Validate_Model_Configuration Begins'||p_init_msg_list,1,'Y');
5686: END IF;
5687:
5688: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
5689: p_api_version_number,
5690: l_api_name,
5691: G_PKG_NAME) THEN
5692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5688: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
5689: p_api_version_number,
5690: l_api_name,
5691: G_PKG_NAME) THEN
5692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5693: END IF;
5694:
5695: l_api_name := 'VALIDATE_MODEL_CFG'; -- Added for Bug 12679929
5696:

Line 5697: IF FND_API.to_Boolean( p_init_msg_list ) THEN

5693: END IF;
5694:
5695: l_api_name := 'VALIDATE_MODEL_CFG'; -- Added for Bug 12679929
5696:
5697: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5698: aso_debug_pub.add('ASO_QUOTE_PUB: p_init_msg_list true', 1, 'Y');
5699: FND_MSG_PUB.initialize;
5700: END IF;
5701:

Line 5712: if (p_Quote_line_id <> FND_API.G_MISS_NUM) then -- Model line id is being sent

5708: end if;
5709:
5710: -- dbms_output.put_line('Entered quote line id in Progress'||p_Quote_line_id);
5711:
5712: if (p_Quote_line_id <> FND_API.G_MISS_NUM) then -- Model line id is being sent
5713: -- dbms_output.put_line('Entered quote line id in Progress');
5714: l_qte_line_rec:=ASO_UTILITY_PVT.Query_Qte_Line_Row(p_Quote_line_id);
5715: l_model_qte_line_tbl(1) :=l_qte_line_rec;
5716: l_qte_line_dtl_tbl:= ASO_UTILITY_PVT.Query_Line_Dtl_Rows(p_Quote_line_id);

Line 5745: End if; --End quote line id null or FND_API.G_MISS_NUM

5741: l_model_qte_line_dtl_tbl(l_model_index).config_revision_num:= l_qte_line_dtl_tbl(1).config_revision_num;
5742:
5743: end if; -- Item type code MDL
5744: end loop;
5745: End if; --End quote line id null or FND_API.G_MISS_NUM
5746:
5747: -- dbms_output.put_line('After populating the mdl table'||l_model_qte_line_tbl.count);
5748: /*
5749: Added by Arul to check no model lines in the Quote.

Line 5807: P_Init_Msg_List => FND_API.G_FALSE,

5803: if (l_model_qte_line_dtl_tbl(i).config_header_id is not null) and ( l_model_qte_line_dtl_tbl(i).config_revision_num is not null) then
5804:
5805: ASO_VALIDATE_CFG_PVT.Validate_Configuration
5806: ( P_Api_Version_Number => 1.0,
5807: P_Init_Msg_List => FND_API.G_FALSE,
5808: P_Commit => FND_API.G_FALSE,
5809: p_control_rec => l_control_rec_bv,
5810: P_model_line_id => l_model_qte_line_tbl(i).quote_line_id,
5811: P_Qte_Line_Tbl => ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,

Line 5808: P_Commit => FND_API.G_FALSE,

5804:
5805: ASO_VALIDATE_CFG_PVT.Validate_Configuration
5806: ( P_Api_Version_Number => 1.0,
5807: P_Init_Msg_List => FND_API.G_FALSE,
5808: P_Commit => FND_API.G_FALSE,
5809: p_control_rec => l_control_rec_bv,
5810: P_model_line_id => l_model_qte_line_tbl(i).quote_line_id,
5811: P_Qte_Line_Tbl => ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,
5812: P_Qte_Line_Dtl_Tbl => ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,

Line 5834: l_return_status := FND_API.G_RET_STS_SUCCESS;

5830: l_config_revision_num:=NULL;
5831: l_valid_configuration_flag:=NULL;
5832: l_complete_configuration_flag:='N';
5833: l_config_changed:=NULL;
5834: l_return_status := FND_API.G_RET_STS_SUCCESS;
5835: end if;
5836:
5837: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5838: aso_debug_pub.add('ASO_QUOTE_PUB: After call to Batch Validate_Configuration: l_return_status: '||l_return_status,1,'Y');

Line 5852: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

5848: --dbms_output.put_line('ASO_QUOTE_PUB: l_valid_configuration_flag: '|| l_valid_configuration_flag);
5849: --dbms_output.put_line('ASO_QUOTE_PUB: l_complete_configuration_flag: '|| l_complete_configuration_flag);
5850: --dbms_output.put_line('ASO_QUOTE_PUB: l_config_changed: '|| l_config_changed);
5851:
5852: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5853: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5854: aso_debug_pub.add('ASO Quote Pub : Batch Validate configuration success');
5855: END IF;
5856: -- code populate the cz rec type and set the changed flag

Line 5864: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

5860: X_Config_tbl(l_config_index).IS_CFG_VALID:=l_valid_configuration_flag;
5861: X_Config_tbl(l_config_index).IS_CFG_COMPLETE:=l_complete_configuration_flag;
5862: end if;
5863:
5864: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5865:
5866: open c_config_exist_in_cz(l_config_header_id, l_config_revision_num);
5867: fetch c_config_exist_in_cz into l_new_config_hdr_id;
5868:

Line 5878: P_INIT_MSG_LIST => FND_API.G_FALSE,

5874: aso_debug_pub.add('Update Quote: A higher version exist for this configuration so deleting it from CZ');
5875: END IF;
5876:
5877: ASO_CFG_INT.DELETE_CONFIGURATION_AUTO( P_API_VERSION_NUMBER => 1.0,
5878: P_INIT_MSG_LIST => FND_API.G_FALSE,
5879: P_CONFIG_HDR_ID => l_config_header_id,
5880: P_CONFIG_REV_NBR => l_config_revision_num,
5881: X_RETURN_STATUS => x_return_status,
5882: X_MSG_COUNT => x_msg_count,

Line 5889: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5885: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5886: aso_debug_pub.add('After call to ASO_CFG_INT.DELETE_CONFIGURATION_AUTO: x_Return_Status: ' || x_Return_Status);
5887: END IF;
5888:
5889: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5890:
5891: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5892: FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');
5893: FND_MESSAGE.Set_Token('OBJECT', 'CONFIGURATION', FALSE);

Line 5897: RAISE FND_API.G_EXC_ERROR;

5893: FND_MESSAGE.Set_Token('OBJECT', 'CONFIGURATION', FALSE);
5894: FND_MSG_PUB.ADD;
5895: END IF;
5896:
5897: RAISE FND_API.G_EXC_ERROR;
5898:
5899: END IF;
5900:
5901: else

Line 5907: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5903: end if;
5904:
5905: END IF;
5906:
5907: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5909: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5910: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5911: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5904:
5905: END IF;
5906:
5907: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5909: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5910: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5911: x_return_status := FND_API.G_RET_STS_ERROR;
5912: RAISE FND_API.G_EXC_ERROR;

Line 5909: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5905: END IF;
5906:
5907: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5909: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5910: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5911: x_return_status := FND_API.G_RET_STS_ERROR;
5912: RAISE FND_API.G_EXC_ERROR;
5913: END IF;

Line 5910: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

5906:
5907: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5909: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5910: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5911: x_return_status := FND_API.G_RET_STS_ERROR;
5912: RAISE FND_API.G_EXC_ERROR;
5913: END IF;
5914: --END IF; -- end condition for unconfigured items

Line 5911: x_return_status := FND_API.G_RET_STS_ERROR;

5907: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5909: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5910: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5911: x_return_status := FND_API.G_RET_STS_ERROR;
5912: RAISE FND_API.G_EXC_ERROR;
5913: END IF;
5914: --END IF; -- end condition for unconfigured items
5915:

Line 5912: RAISE FND_API.G_EXC_ERROR;

5908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5909: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5910: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5911: x_return_status := FND_API.G_RET_STS_ERROR;
5912: RAISE FND_API.G_EXC_ERROR;
5913: END IF;
5914: --END IF; -- end condition for unconfigured items
5915:
5916: END LOOP; --l_model_qte_line_tbl.count

Line 5920: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

5916: END LOOP; --l_model_qte_line_tbl.count
5917:
5918: --End if;
5919:
5920: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5921: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5922: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success'||X_Config_tbl.count);
5923: END IF;
5924:

Line 6037: IF FND_API.to_Boolean( p_commit ) THEN

6033: aso_debug_pub.add('ASO Quote Pub : End Batch Validate configuration X_Config_tbl.count '|| X_Config_tbl.count);
6034: End if;
6035:
6036: -- Standard check for p_commit
6037: IF FND_API.to_Boolean( p_commit ) THEN
6038: COMMIT WORK;
6039: END IF;
6040:
6041: /* Added this Function to return the x_msg_data */

Line 6064: x_return_status := FND_API.G_RET_STS_ERROR;

6060:
6061:
6062: EXCEPTION
6063: WHEN EXCP_USER_DEFINED THEN
6064: x_return_status := FND_API.G_RET_STS_ERROR;
6065:
6066: fnd_msg_pub.count_and_get
6067: ( p_count => x_msg_count
6068: , p_data => x_msg_data);

Line 6070: WHEN FND_API.G_EXC_ERROR THEN

6066: fnd_msg_pub.count_and_get
6067: ( p_count => x_msg_count
6068: , p_data => x_msg_data);
6069:
6070: WHEN FND_API.G_EXC_ERROR THEN
6071: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
6072: P_API_NAME => L_API_NAME
6073: ,P_PKG_NAME => G_PKG_NAME
6074: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 6080: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6076: ,X_MSG_COUNT => X_MSG_COUNT
6077: ,X_MSG_DATA => X_MSG_DATA
6078: ,X_RETURN_STATUS => X_RETURN_STATUS);
6079:
6080: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6081: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
6082: P_API_NAME => L_API_NAME
6083: ,P_PKG_NAME => G_PKG_NAME
6084: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR