1: PACKAGE BODY IBE_QUOTE_SAVESHARE_pvt as
2: /* $Header: IBEVQSSB.pls 120.3 2006/07/18 11:00:01 aannamal ship $ */
3: -- Start of Comments
4: -- Package name : IBE_QUOTE_SAVESHARE_pvt
5: -- Purpose :
1: PACKAGE BODY IBE_QUOTE_SAVESHARE_pvt as
2: /* $Header: IBEVQSSB.pls 120.3 2006/07/18 11:00:01 aannamal ship $ */
3: -- Start of Comments
4: -- Package name : IBE_QUOTE_SAVESHARE_pvt
5: -- Purpose :
6: -- NOTE :
7:
8: -- End of Comments
7:
8: -- End of Comments
9:
10: -- Default number of records fetch per call
11: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_QUOTE_SAVESHARE_pvt';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'IBEVQSSB.pls';
13: l_true VARCHAR2(1) := FND_API.G_TRUE;
14:
15: cursor c_is_shared_cart(c_qte_hdr_id NUMBER) is
514: ,p_emailAddress IN varchar2
515: ,p_privilegeType IN varchar2
516: ,p_recip_party_id IN NUMBER := FND_API.G_MISS_NUM
517: ,p_recip_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
518: ,x_qte_access_rec OUT NOCOPY IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Rec_Type
519: ,X_Return_Status OUT NOCOPY VARCHAR2
520: ,X_Msg_Count OUT NOCOPY NUMBER
521: ,X_Msg_Data OUT NOCOPY VARCHAR2
522: )
525: l_api_version CONSTANT NUMBER := 1.0;
526: l_quote_sharee_id NUMBER;
527: l_quote_sharee_number NUMBER;
528: l_contact_point_id NUMBER;
529: l_quote_access_rec IBE_QUOTE_SAVESHARE_pvt.quote_access_rec_type
530: := IBE_QUOTE_SAVESHARE_pvt.g_miss_quote_access_rec;
531: l_qte_access_table IBE_QUOTE_SAVESHARE_pvt.quote_access_tbl_type
532: := IBE_QUOTE_SAVESHARE_pvt.g_miss_quote_access_tbl;
533:
526: l_quote_sharee_id NUMBER;
527: l_quote_sharee_number NUMBER;
528: l_contact_point_id NUMBER;
529: l_quote_access_rec IBE_QUOTE_SAVESHARE_pvt.quote_access_rec_type
530: := IBE_QUOTE_SAVESHARE_pvt.g_miss_quote_access_rec;
531: l_qte_access_table IBE_QUOTE_SAVESHARE_pvt.quote_access_tbl_type
532: := IBE_QUOTE_SAVESHARE_pvt.g_miss_quote_access_tbl;
533:
534: cursor c_get_sharee_id is
527: l_quote_sharee_number NUMBER;
528: l_contact_point_id NUMBER;
529: l_quote_access_rec IBE_QUOTE_SAVESHARE_pvt.quote_access_rec_type
530: := IBE_QUOTE_SAVESHARE_pvt.g_miss_quote_access_rec;
531: l_qte_access_table IBE_QUOTE_SAVESHARE_pvt.quote_access_tbl_type
532: := IBE_QUOTE_SAVESHARE_pvt.g_miss_quote_access_tbl;
533:
534: cursor c_get_sharee_id is
535: select quote_sharee_number
528: l_contact_point_id NUMBER;
529: l_quote_access_rec IBE_QUOTE_SAVESHARE_pvt.quote_access_rec_type
530: := IBE_QUOTE_SAVESHARE_pvt.g_miss_quote_access_rec;
531: l_qte_access_table IBE_QUOTE_SAVESHARE_pvt.quote_access_tbl_type
532: := IBE_QUOTE_SAVESHARE_pvt.g_miss_quote_access_tbl;
533:
534: cursor c_get_sharee_id is
535: select quote_sharee_number
536: from ibe_sh_quote_access
632:
633: EXCEPTION
634: WHEN FND_API.G_EXC_ERROR THEN
635: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
636: ibe_util.debug('Expected exception in IBE_QUOTE_SAVESHARE_PVT.SaveSharee');
637: END IF;
638: ROLLBACK TO SAVESHAREE_pvt;
639: x_return_status := FND_API.G_RET_STS_ERROR;
640: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
641: p_count => x_msg_count,
642: p_data => x_msg_data);
643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
644: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
645: ibe_util.debug('Unexpected exception in IBE_QUOTE_SAVESHARE_PVT.SaveSharee');
646: END IF;
647: ROLLBACK TO SAVESHAREE_pvt;
648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
649: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
650: p_count => x_msg_count,
651: p_data => x_msg_data);
652: WHEN OTHERS THEN
653: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
654: ibe_util.debug('Unknown exception in IBE_QUOTE_SAVESHARE_PVT.SaveSharee');
655: END IF;
656: ROLLBACK TO SAVESHAREE_pvt;
657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
658:
723:
724: BEGIN
725: -- --IBE_UTIL.ENABLE_DEBUG;
726: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
727: IBE_Util.Debug('Begin IBE_QUOTE_SAVESHARE_pvt.SaveAsAndShare() at ' || TO_CHAR(SYSDATE, 'MM/DD/YYYY:HH24:MI:SS'));
728: END IF;
729: -- Standard Start of API savepoint
730: SAVEPOINT SAVEASANDSHARE_pvt;
731: -- Standard call to check for call compatibility.
906: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
908: END IF;
909:
910: IBE_QUOTE_SAVESHARE_pvt.sharequote
911: ( p_api_version_number => 1.0
912: ,p_init_msg_list => FND_API.G_FALSE
913: ,p_commit => FND_API.G_FALSE
914: ,p_quote_header_id => x_to_quote_header_id
936: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
937: p_count => x_msg_count,
938: p_data => x_msg_data);
939: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
940: IBE_Util.Debug('End IBE_QUOTE_SAVESHARE_pvt.SaveAsAndShare() at ' || TO_CHAR(SYSDATE, 'MM/DD/YYYY:HH24:MI:SS'));
941: END IF;
942: --IBE_UTIL.DISABLE_DEBUG;
943: EXCEPTION
944: WHEN FND_API.G_EXC_ERROR THEN
942: --IBE_UTIL.DISABLE_DEBUG;
943: EXCEPTION
944: WHEN FND_API.G_EXC_ERROR THEN
945: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
946: ibe_util.debug('Expected exception in IBE_QUOTE_SAVESHARE_PVT.SaveAsAndShare');
947: END IF;
948: ROLLBACK TO SAVEASANDSHARE_pvt;
949: x_return_status := FND_API.G_RET_STS_ERROR;
950: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
951: p_count => x_msg_count,
952: p_data => x_msg_data);
953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
954: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
955: ibe_util.debug('Unexpected exception in IBE_QUOTE_SAVESHARE_PVT.SaveAsAndShare');
956: END IF;
957: ROLLBACK TO SAVEASANDSHARE_pvt;
958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
959: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
960: p_count => x_msg_count,
961: p_data => x_msg_data);
962: WHEN OTHERS THEN
963: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
964: ibe_util.debug('Unknown exception in IBE_QUOTE_SAVESHARE_PVT.SaveAsAndShare');
965: END IF;
966: ROLLBACK TO SAVEASANDSHARE_pvt;
967: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
968:
974: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
975: p_count => x_msg_count,
976: p_data => x_msg_data);
977: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
978: IBE_Util.Debug('End IBE_QUOTE_SAVESHARE_pvt.SaveAsAndShare() at ' || TO_CHAR(SYSDATE, 'MM/DD/YYYY:HH24:MI:SS'));
979: END IF;
980: --IBE_UTIL.DISABLE_DEBUG;
981: END SaveAsAndShare;
982:
1073:
1074: BEGIN
1075: --IBE_UTIL.ENABLE_DEBUG;
1076: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1077: IBE_Util.Debug('Begin **new** IBE_QUOTE_SAVESHARE_pvt.AppendToReplaceShare() at ' || TO_CHAR(SYSDATE, 'MM/DD/YYYY:HH24:MI:SS'));
1078: IBE_Util.Debug('Parameters pased to IBE_QUOTE_SAVESHARE_pvt.AppendToReplaceShare() are');
1079: IBE_Util.Debug('P_ORIGINAL_QUOTE_HEADER_ID: '||P_ORIGINAL_QUOTE_HEADER_ID);
1080: IBE_Util.Debug('P_REP_APP_QUOTE_HEADER_ID: '||P_REP_APP_QUOTE_HEADER_ID);
1081: IBE_Util.Debug('P_INCREASEVERSION: '||P_INCREASEVERSION);
1074: BEGIN
1075: --IBE_UTIL.ENABLE_DEBUG;
1076: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1077: IBE_Util.Debug('Begin **new** IBE_QUOTE_SAVESHARE_pvt.AppendToReplaceShare() at ' || TO_CHAR(SYSDATE, 'MM/DD/YYYY:HH24:MI:SS'));
1078: IBE_Util.Debug('Parameters pased to IBE_QUOTE_SAVESHARE_pvt.AppendToReplaceShare() are');
1079: IBE_Util.Debug('P_ORIGINAL_QUOTE_HEADER_ID: '||P_ORIGINAL_QUOTE_HEADER_ID);
1080: IBE_Util.Debug('P_REP_APP_QUOTE_HEADER_ID: '||P_REP_APP_QUOTE_HEADER_ID);
1081: IBE_Util.Debug('P_INCREASEVERSION: '||P_INCREASEVERSION);
1082: END IF;
1378: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1380: END IF;
1381:
1382: IBE_QUOTE_SAVESHARE_pvt.sharequote(
1383: p_api_version_number => 1.0
1384: ,p_init_msg_list => FND_API.G_false
1385: ,p_commit => FND_API.G_false
1386: ,p_quote_header_id => x_quote_header_id
1409: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1410: p_count => x_msg_count,
1411: p_data => x_msg_data);
1412: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1413: IBE_Util.Debug('End IBE_QUOTE_SAVESHARE_pvt.AppendToReplaceShare() at ' || TO_CHAR(SYSDATE, 'MM/DD/YYYY:HH24:MI:SS'));
1414: END IF;
1415:
1416: EXCEPTION
1417: WHEN FND_API.G_EXC_ERROR THEN
1415:
1416: EXCEPTION
1417: WHEN FND_API.G_EXC_ERROR THEN
1418: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1419: ibe_util.debug('Expected exception in IBE_QUOTE_SAVESHARE_PVT.AppendToReplaceShare');
1420: END IF;
1421: ROLLBACK TO APPENDTOREPLACESHARE_pvt;
1422: x_return_status := FND_API.G_RET_STS_ERROR;
1423: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1425: p_data => x_msg_data);
1426: --IBE_UTIL.DISABLE_DEBUG;
1427: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1428: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1429: ibe_util.debug('Unexpected exception in IBE_QUOTE_SAVESHARE_PVT.AppendToReplaceShare');
1430: END IF;
1431: ROLLBACK TO APPENDTOREPLACESHARE_pvt;
1432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1433: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1434: p_count => x_msg_count,
1435: p_data => x_msg_data);
1436: WHEN OTHERS THEN
1437: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1438: ibe_util.debug('Unknown exception in IBE_QUOTE_SAVESHARE_PVT.AppendToReplaceShare');
1439: END IF;
1440: ROLLBACK TO APPENDTOREPLACESHARE_pvt;
1441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1442:
1470: l_api_version CONSTANT NUMBER := 1.0;
1471:
1472: l_contact_point_id NUMBER := fnd_api.g_miss_num;
1473: l_contact_lastupdatedate DATE := fnd_api.g_miss_date;
1474: l_qte_access_rec IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Rec_Type
1475: :=IBE_QUOTE_SAVESHARE_pvt.g_miss_quote_access_rec;
1476:
1477: BEGIN
1478: -- Standard Start of API savepoint
1471:
1472: l_contact_point_id NUMBER := fnd_api.g_miss_num;
1473: l_contact_lastupdatedate DATE := fnd_api.g_miss_date;
1474: l_qte_access_rec IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Rec_Type
1475: :=IBE_QUOTE_SAVESHARE_pvt.g_miss_quote_access_rec;
1476:
1477: BEGIN
1478: -- Standard Start of API savepoint
1479: SAVEPOINT SAVEASANDSHARE_pvt;
1503: END IF;
1504:
1505: /*IF (P_URL is not null and P_URL <> FND_API.G_MISS_CHAR) THEN
1506: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1507: ibe_util.debug('call IBE_QUOTE_SAVESHARE_pvt.savecontactpoint at '
1508: || to_char(sysdate, 'mm/dd/yyyy:hh24:MI:SS'));
1509: END IF;
1510:
1511: saveContactPoint
1526: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1528: END IF;
1529: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1530: ibe_util.debug('done IBE_QUOTE_SAVESHARE_pvt.savecontactpoint at '
1531: || to_char(sysdate, 'mm/dd/yyyy:hh24:MI:SS'));
1532: END IF;
1533:
1534: END IF; -- end of url*/
1535:
1536: IF (P_sharee_email_Address is not null) THEN
1537: FOR i IN 1..P_sharee_email_Address.count LOOP
1538: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1539: ibe_util.debug('call IBE_QUOTE_SAVESHARE_pvt.savesharee '|| i || ' at '
1540: || to_char(sysdate, 'mm/dd/yyyy:hh24:MI:SS'));
1541: END IF;
1542:
1543: IBE_QUOTE_SAVESHARE_pvt.SaveSharee
1539: ibe_util.debug('call IBE_QUOTE_SAVESHARE_pvt.savesharee '|| i || ' at '
1540: || to_char(sysdate, 'mm/dd/yyyy:hh24:MI:SS'));
1541: END IF;
1542:
1543: IBE_QUOTE_SAVESHARE_pvt.SaveSharee
1544: ( p_api_version_number => P_Api_Version_Number
1545: ,p_init_msg_list => FND_API.G_FALSE
1546: ,p_commit => FND_API.G_FALSE
1547: ,P_Quote_Header_id => p_quote_header_id
1558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1559: END IF;
1560:
1561: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1562: IBE_UTIL.DEBUG('call IBE_QUOTE_SAVESHARE_pvt.emailsharee at'
1563: || to_char(sysdate, 'mm/dd/yyyy:hh24:MI:SS'));
1564: END IF;
1565:
1566: IBE_QUOTE_SAVESHARE_pvt.EmailSharee
1562: IBE_UTIL.DEBUG('call IBE_QUOTE_SAVESHARE_pvt.emailsharee at'
1563: || to_char(sysdate, 'mm/dd/yyyy:hh24:MI:SS'));
1564: END IF;
1565:
1566: IBE_QUOTE_SAVESHARE_pvt.EmailSharee
1567: ( p_api_version_number => P_Api_Version_Number
1568: ,p_init_msg_list => FND_API.G_FALSE
1569: ,p_commit => FND_API.G_FALSE
1570: ,P_Quote_Header_id => p_quote_header_id
1583: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1585: END IF;
1586: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1587: IBE_UTIL.DEBUG('done IBE_QUOTE_SAVESHARE_pvt.emailsharee at'
1588: || to_char(sysdate, 'mm/dd/yyyy:hh24:MI:SS'));
1589: END IF;
1590:
1591: END LOOP;
1675: END IF;
1676:
1677: --IBE_UTIL.ENABLE_DEBUG;
1678: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1679: IBE_Util.Debug('Begin IBE_QUOTE_SAVESHARE_pvt.ActivateQuote() at ' || TO_CHAR(SYSDATE, 'MM/DD/YYYY:HH24:MI:SS'));
1680: END IF;
1681:
1682: l_qte_header_rec.quote_header_id := p_quote_header_id;
1683: l_qte_header_rec.last_update_date := p_last_update_date;
1801: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1802: p_count => x_msg_count,
1803: p_data => x_msg_data);
1804: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1805: IBE_Util.Debug('End IBE_QUOTE_SAVESHARE_pvt.ActivateQuote() at ' || TO_CHAR(SYSDATE, 'MM/DD/YYYY:HH24:MI:SS'));
1806: END IF;
1807: --IBE_UTIL.DISABLE_DEBUG;
1808: EXCEPTION
1809: WHEN FND_API.G_EXC_ERROR THEN
1807: --IBE_UTIL.DISABLE_DEBUG;
1808: EXCEPTION
1809: WHEN FND_API.G_EXC_ERROR THEN
1810: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1811: ibe_util.debug('Expected exception in IBE_QUOTE_SAVESHARE_PVT.ActivateQuote');
1812: END IF;
1813: ROLLBACK TO ActivateQuote_pvt;
1814: x_return_status := FND_API.G_RET_STS_ERROR;
1815: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1816: p_count => x_msg_count,
1817: p_data => x_msg_data);
1818: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1819: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1820: ibe_util.debug('Unexpected exception in IBE_QUOTE_SAVESHARE_PVT.ActivateQuote');
1821: END IF;
1822: ROLLBACK TO ActivateQuote_pvt;
1823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1824: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1825: p_count => x_msg_count,
1826: p_data => x_msg_data);
1827: WHEN OTHERS THEN
1828: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1829: ibe_util.debug('unknown exception in IBE_QUOTE_SAVESHARE_PVT.ActivateQuote');
1830: END IF;
1831: ROLLBACK TO ActivateQuote_pvt;
1832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1833:
2016: p_data => x_msg_data);
2017: EXCEPTION
2018: WHEN FND_API.G_EXC_ERROR THEN
2019: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2020: ibe_util.debug('Expected exception in IBE_QUOTE_SAVESHARE_PVT.RetrieveShareQuote');
2021: END IF;
2022: ROLLBACK TO RETRIEVESHAREQUOTE_pvt;
2023: x_return_status := FND_API.G_RET_STS_ERROR;
2024: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2025: p_count => x_msg_count,
2026: p_data => x_msg_data);
2027: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2028: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2029: ibe_util.debug('Unexpected exception in IBE_QUOTE_SAVESHARE_PVT.RetrieveShareQuote');
2030: END IF;
2031: ROLLBACK TO RETRIEVESHAREQUOTE_pvt;
2032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2033: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2034: p_count => x_msg_count,
2035: p_data => x_msg_data);
2036: WHEN OTHERS THEN
2037: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2038: ibe_util.debug('Unknown exception in IBE_QUOTE_SAVESHARE_PVT.RetrieveShareQuote');
2039: END IF;
2040: ROLLBACK TO RETRIEVESHAREQUOTE_pvt;
2041: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2042:
2330: IBE_UTIL.DEBUG('input quote_header_id <> quote_header_id in db');
2331: END IF;
2332: IF (p_mode = 'MERGE') THEN -- combine two cart
2333: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2334: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_pvt.MERGE_QUOTE:Mode is merge');
2335: END IF;
2336: -- added 8/11/02: for Default Feature: we have to see if we need to default by calling getHdrDefaultValues:
2337: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2338: IBE_Util.Debug('MergeActiveQutoe: check to see if we can call getHdrDefaultValues');
2418: End if;
2419: --DBMS_OUTPUT.PUT_LINE('MergeActiveQutoe: Back from calling getHdrDefaultValues');
2420: end if; -- if we can find the minisiteId
2421:
2422: IBE_QUOTE_SAVESHARE_pvt.AppendToReplaceShare
2423: ( P_Api_Version_Number => p_api_version_number
2424: ,p_Init_Msg_List => fnd_api.g_false
2425: ,P_Commit => fnd_api.g_false
2426: ,p_Original_Quote_Header_Id => l_in_qte_header_rec.quote_header_id
2459: l_db_qte_header_rec.quote_header_id := l_quote_header_id_tmp;
2460: l_db_qte_header_rec.last_update_date := l_last_update_date_tmp;
2461:
2462: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2463: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_pvt.MERGE_QUOTE: done merge');
2464: END IF;
2465:
2466:
2467: IBE_Quote_Save_pvt.Delete
2481: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2483: END IF;
2484: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2485: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_pvt.MERGE_QUOTE: done merge: +delete');
2486: END IF;
2487:
2488: x_quote_header_id := l_db_qte_header_rec.quote_header_id;
2489: x_last_update_date := l_db_qte_header_rec.last_update_date;
2491:
2492: elsif (p_mode ='KEEP') THEN
2493:
2494: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2495: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_pvt.MERGE_QUOTE: mode is keep');
2496: --IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_pvt.MERGE_QUOTE: Calling delete on account active cart');
2497: END IF;
2498: if (l_db_qte_header_rec.quote_name = 'IBE_PRMT_SC_UNNAMED') then
2499: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2492: elsif (p_mode ='KEEP') THEN
2493:
2494: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2495: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_pvt.MERGE_QUOTE: mode is keep');
2496: --IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_pvt.MERGE_QUOTE: Calling delete on account active cart');
2497: END IF;
2498: if (l_db_qte_header_rec.quote_name = 'IBE_PRMT_SC_UNNAMED') then
2499: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2500: IBE_UTIL.DEBUG('Active cart was unnamed, calling IBE_Quote_Save_pvt.SAVE to default save the active cart');
2525: l_db_qte_header_rec.quote_header_id := l_quote_header_id_tmp;
2526: l_db_qte_header_rec.last_update_date := l_last_update_date_tmp;
2527:
2528: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2529: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_pvt.MERGE_QUOTE: Done keep: updating cart name to defaultnamed');
2530: END IF;
2531: end if; -- end if quote name was unnamed
2532: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2533: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_pvt.MERGE_QUOTE: Deactivating account active cart (since mode = KEEP)');
2529: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_pvt.MERGE_QUOTE: Done keep: updating cart name to defaultnamed');
2530: END IF;
2531: end if; -- end if quote name was unnamed
2532: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2533: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_pvt.MERGE_QUOTE: Deactivating account active cart (since mode = KEEP)');
2534: END IF;
2535: IBE_QUOTE_SAVESHARE_V2_PVT.DEACTIVATE_QUOTE (
2536: P_Quote_header_id => l_db_qte_header_rec.quote_header_id ,
2537: P_Party_id => l_db_qte_header_rec.party_id ,
2559:
2560: elsif (p_mode ='REMOVE') THEN
2561:
2562: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2563: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_pvt.MERGE_QUOTE:start remove');
2564: END IF;
2565: IBE_Quote_Save_pvt.Delete
2566: ( p_api_version_number => p_api_version_number
2567: ,p_init_msg_list => FND_API.G_false
2582: x_quote_header_id := l_db_qte_header_rec.quote_header_id;
2583: x_last_update_date := l_db_qte_header_rec.last_update_date;
2584:
2585: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2586: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_pvt.MERGE_QUOTE: remove: after delete');
2587: END IF;
2588: END IF;
2589: else -- pass in quote is same as quote in db
2590:
2932: p_data => x_msg_data);
2933: EXCEPTION
2934: WHEN FND_API.G_EXC_ERROR THEN
2935: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2936: ibe_util.debug('Expected exception in IBE_QUOTE_SAVESHARE_PVT.mergeActiveQuote');
2937: END IF;
2938: ROLLBACK TO MergeActiveQuote_pvt;
2939: -- Handle saving the carts...
2940: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2967: l_db_qte_header_rec.quote_header_id := l_quote_header_id_tmp;
2968: l_db_qte_header_rec.last_update_date := l_last_update_date_tmp;
2969:
2970: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2971: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_pvt.MERGE_QUOTE Exception: Done keep: updating cart name to defaultnamed');
2972: END IF;
2973: end if; -- end if quote name was unnamed
2974: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2975: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_pvt.MERGE_QUOTE Exception: Deactivating account active cart (since mode = KEEP)');
2971: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_pvt.MERGE_QUOTE Exception: Done keep: updating cart name to defaultnamed');
2972: END IF;
2973: end if; -- end if quote name was unnamed
2974: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2975: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_pvt.MERGE_QUOTE Exception: Deactivating account active cart (since mode = KEEP)');
2976: END IF;
2977: IBE_QUOTE_SAVESHARE_V2_PVT.DEACTIVATE_QUOTE (
2978: P_Quote_header_id => l_db_qte_header_rec.quote_header_id ,
2979: P_Party_id => l_db_qte_header_rec.party_id ,
3104: p_count => x_msg_count,
3105: p_data => x_msg_data);
3106: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3107: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3108: ibe_util.debug('Expected exception in IBE_QUOTE_SAVESHARE_PVT.mergeActiveQuote');
3109: END IF;
3110: ROLLBACK TO MergeActiveQuote_pvt;
3111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3112: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
3113: p_count => x_msg_count,
3114: p_data => x_msg_data);
3115: WHEN OTHERS THEN
3116: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3117: ibe_util.debug('Unknown exception in IBE_QUOTE_SAVESHARE_PVT.mergeActiveQuote');
3118: END IF;
3119: ROLLBACK TO MergeActiveQuote_pvt;
3120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3121:
3138: ,p_emailAddress IN varchar2
3139: ,p_privilegeType IN varchar2
3140:
3141: ,p_url IN varchar2
3142: ,p_qte_access_rec IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_Rec_Type
3143: ,p_comments IN VARCHAR2 := FND_API.G_MISS_CHAR
3144: ,X_Return_Status OUT NOCOPY VARCHAR2
3145: ,X_Msg_Count OUT NOCOPY NUMBER
3146: ,X_Msg_Data OUT NOCOPY VARCHAR2
3249: p_data => x_msg_data);
3250: EXCEPTION
3251: WHEN FND_API.G_EXC_ERROR THEN
3252: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3253: ibe_util.debug('Expected exception in IBE_QUOTE_SAVESHARE_PVT.EmailSharee');
3254: END IF;
3255: ROLLBACK TO EMAILSHAREE_pvt;
3256: x_return_status := FND_API.G_RET_STS_ERROR;
3257: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
3258: p_count => x_msg_count,
3259: p_data => x_msg_data);
3260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3261: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3262: ibe_util.debug('Unexpected exception in IBE_QUOTE_SAVESHARE_PVT.EmailSharee');
3263: END IF;
3264: ROLLBACK TO EMAILSHAREE_pvt;
3265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3266: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
3267: p_count => x_msg_count,
3268: p_data => x_msg_data);
3269: WHEN OTHERS THEN
3270: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3271: ibe_util.debug('Unknown exception in IBE_QUOTE_SAVESHARE_PVT.EmailSharee');
3272: END IF;
3273: ROLLBACK TO EMAILSHAREE_pvt;
3274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3275:
3303: END IF;
3304: x_sharee_number := to_number(substr((to_char(p_recip_id)||to_char(l_rand)),1,15));
3305: END GenerateShareeNumber;
3306:
3307: END IBE_QUOTE_SAVESHARE_pvt;