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 3969: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

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

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

Line 3978: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 3980: RAISE FND_API.G_EXC_ERROR;

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

Line 4025: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

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

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

Line 4034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 4036: RAISE FND_API.G_EXC_ERROR;

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

Line 4076: P_Init_Msg_List => FND_API.G_FALSE,

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

Line 4077: P_Commit => FND_API.G_FALSE,

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

Line 4141: IF x_return_status = FND_API.G_RET_STS_ERROR then

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

Line 4142: raise FND_API.G_EXC_ERROR;

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

Line 4143: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

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

Line 4144: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4191: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

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

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

Line 4200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 4202: RAISE FND_API.G_EXC_ERROR;

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

Line 4260: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

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

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

Line 4269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 4271: RAISE FND_API.G_EXC_ERROR;

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

Line 4279: IF FND_API.to_Boolean( p_commit ) THEN

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

Line 4291: WHEN FND_API.G_EXC_ERROR THEN

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

Line 4303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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

4339:
4340:
4341: PROCEDURE Update_quote(
4342: P_Api_Version_Number IN NUMBER,
4343: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
4344: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
4345: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4346: P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
4347: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,

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

4340:
4341: PROCEDURE Update_quote(
4342: P_Api_Version_Number IN NUMBER,
4343: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
4344: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
4345: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4346: P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
4347: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
4348: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,

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

4341: PROCEDURE Update_quote(
4342: P_Api_Version_Number IN NUMBER,
4343: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
4344: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
4345: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4346: P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
4347: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
4348: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
4349: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,

Line 4447: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

4443:
4444: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
4445:
4446: -- Standard call to check for call compatibility.
4447: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4448: p_api_version_number,
4449: l_api_name,
4450: G_PKG_NAME) THEN
4451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4447: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4448: p_api_version_number,
4449: l_api_name,
4450: G_PKG_NAME) THEN
4451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4452: END IF;
4453:
4454: -- Initialize message list if p_init_msg_list is set to TRUE.
4455: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 4455: IF FND_API.to_Boolean( p_init_msg_list ) THEN

4451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4452: END IF;
4453:
4454: -- Initialize message list if p_init_msg_list is set to TRUE.
4455: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4456: FND_MSG_PUB.initialize;
4457: END IF;
4458:
4459: -- Initialize API return status to SUCCESS

Line 4460: x_return_status := FND_API.G_RET_STS_SUCCESS;

4456: FND_MSG_PUB.initialize;
4457: END IF;
4458:
4459: -- Initialize API return status to SUCCESS
4460: x_return_status := FND_API.G_RET_STS_SUCCESS;
4461:
4462: --
4463: -- API body
4464: --

Line 4537: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4533: X_Msg_Count => X_Msg_Count,
4534: X_Msg_Data => X_Msg_Data
4535: );
4536:
4537: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4538:
4539: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4540: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
4541: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.update_Quote_PRE', FALSE);

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

4541: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.update_Quote_PRE', FALSE);
4542: FND_MSG_PUB.ADD;
4543: END IF;
4544:
4545: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4547: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4548: RAISE FND_API.G_EXC_ERROR;
4549: END IF;

Line 4546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4542: FND_MSG_PUB.ADD;
4543: END IF;
4544:
4545: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4547: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4548: RAISE FND_API.G_EXC_ERROR;
4549: END IF;
4550:

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

4543: END IF;
4544:
4545: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4547: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4548: RAISE FND_API.G_EXC_ERROR;
4549: END IF;
4550:
4551: END IF;

Line 4548: RAISE FND_API.G_EXC_ERROR;

4544:
4545: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4547: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4548: RAISE FND_API.G_EXC_ERROR;
4549: END IF;
4550:
4551: END IF;
4552:

Line 4594: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4590: X_Msg_Count => X_Msg_Count,
4591: X_Msg_Data => X_Msg_Data
4592: );
4593:
4594: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4595:
4596: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4597: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
4598: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Update_Quote_PRE', FALSE);

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

4598: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Update_Quote_PRE', FALSE);
4599: FND_MSG_PUB.ADD;
4600: END IF;
4601:
4602: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4604: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4605: RAISE FND_API.G_EXC_ERROR;
4606: END IF;

Line 4603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4599: FND_MSG_PUB.ADD;
4600: END IF;
4601:
4602: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4604: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4605: RAISE FND_API.G_EXC_ERROR;
4606: END IF;
4607:

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

4600: END IF;
4601:
4602: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4604: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4605: RAISE FND_API.G_EXC_ERROR;
4606: END IF;
4607:
4608: END IF;

Line 4605: RAISE FND_API.G_EXC_ERROR;

4601:
4602: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4604: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4605: RAISE FND_API.G_EXC_ERROR;
4606: END IF;
4607:
4608: END IF;
4609:

Line 4648: P_Init_Msg_List => FND_API.G_FALSE,

4644: END LOOP;
4645:
4646: ASO_QUOTE_HEADERS_PVT.update_quote(
4647: P_Api_Version_Number => 1.0,
4648: P_Init_Msg_List => FND_API.G_FALSE,
4649: P_Commit => FND_API.G_FALSE,
4650: p_validation_level => p_validation_level,
4651: P_Control_Rec => l_control_rec,
4652: P_qte_header_rec => l_qte_header_rec,

Line 4649: P_Commit => FND_API.G_FALSE,

4645:
4646: ASO_QUOTE_HEADERS_PVT.update_quote(
4647: P_Api_Version_Number => 1.0,
4648: P_Init_Msg_List => FND_API.G_FALSE,
4649: P_Commit => FND_API.G_FALSE,
4650: p_validation_level => p_validation_level,
4651: P_Control_Rec => l_control_rec,
4652: P_qte_header_rec => l_qte_header_rec,
4653: P_Hd_Price_Attributes_Tbl => l_hd_Price_Attributes_Tbl,

Line 4713: IF x_return_status = FND_API.G_RET_STS_ERROR then

4709: aso_debug_pub.add('update_quote_pub: after update quote, starting user hooks (1)'||x_return_status,1, 'N');
4710: END IF;
4711:
4712: -- Check return status from the above procedure call
4713: IF x_return_status = FND_API.G_RET_STS_ERROR then
4714: raise FND_API.G_EXC_ERROR;
4715: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
4716: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4717: END IF;

Line 4714: raise FND_API.G_EXC_ERROR;

4710: END IF;
4711:
4712: -- Check return status from the above procedure call
4713: IF x_return_status = FND_API.G_RET_STS_ERROR then
4714: raise FND_API.G_EXC_ERROR;
4715: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
4716: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4717: END IF;
4718:

Line 4715: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

4711:
4712: -- Check return status from the above procedure call
4713: IF x_return_status = FND_API.G_RET_STS_ERROR then
4714: raise FND_API.G_EXC_ERROR;
4715: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
4716: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4717: END IF;
4718:
4719: IF (JTF_USR_HKS.ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'C')) THEN

Line 4716: raise FND_API.G_EXC_UNEXPECTED_ERROR;

4712: -- Check return status from the above procedure call
4713: IF x_return_status = FND_API.G_RET_STS_ERROR then
4714: raise FND_API.G_EXC_ERROR;
4715: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
4716: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4717: END IF;
4718:
4719: IF (JTF_USR_HKS.ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'C')) THEN
4720:

Line 4757: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4753: X_Msg_Count => X_Msg_Count,
4754: X_Msg_Data => X_Msg_Data
4755: );
4756:
4757: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4758:
4759: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4760: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
4761: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Update_Quote_POST', FALSE);

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

4761: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_CUHK.Update_Quote_POST', FALSE);
4762: FND_MSG_PUB.ADD;
4763: END IF;
4764:
4765: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4767: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4768: RAISE FND_API.G_EXC_ERROR;
4769: END IF;

Line 4766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4762: FND_MSG_PUB.ADD;
4763: END IF;
4764:
4765: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4767: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4768: RAISE FND_API.G_EXC_ERROR;
4769: END IF;
4770:

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

4763: END IF;
4764:
4765: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4767: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4768: RAISE FND_API.G_EXC_ERROR;
4769: END IF;
4770:
4771: END IF;

Line 4768: RAISE FND_API.G_EXC_ERROR;

4764:
4765: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4767: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4768: RAISE FND_API.G_EXC_ERROR;
4769: END IF;
4770:
4771: END IF;
4772:

Line 4825: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4821: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4822: aso_debug_pub.add('update_quote_pub: after vertical hooks'||x_return_status,1, 'N');
4823: END IF;
4824:
4825: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4826:
4827: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4828: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
4829: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Update_Quote_POST', FALSE);

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

4829: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_VUHK.Update_Quote_POST', FALSE);
4830: FND_MSG_PUB.ADD;
4831: END IF;
4832:
4833: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4835: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4836: RAISE FND_API.G_EXC_ERROR;
4837: END IF;

Line 4834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4830: FND_MSG_PUB.ADD;
4831: END IF;
4832:
4833: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4835: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4836: RAISE FND_API.G_EXC_ERROR;
4837: END IF;
4838:

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

4831: END IF;
4832:
4833: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4835: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4836: RAISE FND_API.G_EXC_ERROR;
4837: END IF;
4838:
4839: END IF;

Line 4836: RAISE FND_API.G_EXC_ERROR;

4832:
4833: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4835: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4836: RAISE FND_API.G_EXC_ERROR;
4837: END IF;
4838:
4839: END IF;
4840:

Line 4848: IF FND_API.to_Boolean( p_commit ) THEN

4844: -- End of API body
4845: --
4846:
4847: -- Standard check for p_commit
4848: IF FND_API.to_Boolean( p_commit ) THEN
4849: COMMIT WORK;
4850: END IF;
4851:
4852: -- Standard call to get message count and if count is 1, get message info.

Line 4859: WHEN FND_API.G_EXC_ERROR THEN

4855:
4856:
4857: EXCEPTION
4858:
4859: WHEN FND_API.G_EXC_ERROR THEN
4860: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4861: P_API_NAME => L_API_NAME
4862: ,P_PKG_NAME => G_PKG_NAME
4863: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 4871: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4867: ,X_MSG_COUNT => X_MSG_COUNT
4868: ,X_MSG_DATA => X_MSG_DATA
4869: ,X_RETURN_STATUS => X_RETURN_STATUS);
4870:
4871: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4872: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4873: P_API_NAME => L_API_NAME
4874: ,P_PKG_NAME => G_PKG_NAME
4875: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR