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.IBE_QUOTE_SAVESHARE_V2_PVT dependencies on IBE_QUOTE_SAVESHARE_V2_PVT

Line 1: package body IBE_QUOTE_SAVESHARE_V2_PVT as

1: package body IBE_QUOTE_SAVESHARE_V2_PVT as
2: /*$Header: IBEVSS2B.pls 120.2.12020000.2 2012/09/10 06:46:57 nsatyava ship $ */
3: l_true VARCHAR2(1) := FND_API.G_TRUE;
4:
5: cursor c_check_active_cart(c_party_id number,

Line 146: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.save_share_v2: START');

142: -------------------------------------------------------------------------------------------------------------
143: --API Body start
144: -------------------------------------------------------------------------------------------------------------
145: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
146: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.save_share_v2: START');
147: IBE_UTIL.DEBUG('saveshare_control_rec.operation_code is '||p_saveshare_control_rec.operation_code);
148: END IF;
149:
150: Validate_share_Update(

Line 210: IBE_QUOTE_SAVESHARE_V2_PVT.save_recipients(

206: END IF;
207: --DBMS_OUTPUT.PUT_LINE('Calling save_recipients to save recipient information ');
208: --dbms_output.put_line('Comments passed : '||p_notes);
209: IF(nvl(p_quote_access_tbl.count,0) > 0) THEN
210: IBE_QUOTE_SAVESHARE_V2_PVT.save_recipients(
211: p_quote_access_tbl => p_quote_access_tbl ,
212: p_quote_header_id => p_quote_header_rec.quote_header_id,
213: p_party_id => p_party_id ,
214: p_cust_account_id => p_cust_account_id ,

Line 240: IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE(

236: IF(p_saveshare_control_rec.operation_code = OP_APPEND) THEN
237: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
238: IBE_UTIL.DEBUG('cALLING APPEND_QUOTE');
239: END IF;
240: IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE(
241: P_source_quote_header_id => P_source_quote_header_id,
242: P_source_last_update_date => P_source_last_update_date,
243: P_target_header_rec => P_Quote_header_rec,
244: P_control_rec => P_saveshare_control_rec.control_rec,

Line 268: IBE_QUOTE_SAVESHARE_V2_PVT.ACTIVATE_QUOTE(

264: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
265: IBE_UTIL.DEBUG('OPERATION_CODE IS: '||p_saveshare_control_rec.operation_code||'CALLING ACTIVATE_QUOTE');
266: END IF;
267: --DBMS_OUTPUT.PUT_LINE_LINE('OPERATION_CODE IS: '||p_saveshare_control_rec.operation_code||'CALLING ACTIVATE_QUOTE');
268: IBE_QUOTE_SAVESHARE_V2_PVT.ACTIVATE_QUOTE(
269: P_Quote_header_rec => P_Quote_header_rec ,
270: P_Party_id => P_party_id ,
271: P_Cust_account_id => P_cust_account_id ,
272: P_control_rec => P_saveshare_control_rec.control_rec,

Line 297: IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING(

293: ELSIF(p_saveshare_control_rec.operation_code = OP_END_WORKING) THEN
294: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
295: IBE_UTIL.DEBUG(' Calling IBE_QUOTE_SAVE_SHARE_V2_PVT.END_WORKING');
296: END IF;
297: IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING(
298: P_Quote_access_tbl => p_quote_access_tbl ,
299: p_quote_header_id => p_quote_header_rec.quote_header_id,
300: p_party_id => p_party_id ,
301: p_cust_account_id => p_cust_account_id ,

Line 325: IBE_QUOTE_SAVESHARE_V2_PVT.STOP_SHARING (

321: IBE_UTIL.DEBUG('Done calling IBE_QUOTE_SAVE_SHARE_V2_PVT.END_WORKING');
322: END IF;
323:
324: ELSIF(p_saveshare_control_rec.operation_code = OP_STOP_SHARING) THEN
325: IBE_QUOTE_SAVESHARE_V2_PVT.STOP_SHARING (
326: p_quote_header_id => P_Quote_header_rec.quote_header_id ,
327: P_minisite_id => p_minisite_id ,
328: p_notes => p_notes ,
329: p_quote_access_tbl => p_quote_access_tbl ,

Line 355: IBE_QUOTE_SAVESHARE_V2_PVT.DEACTIVATE_QUOTE (

351: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
352: IBE_UTIL.DEBUG('Calling deactivate API');
353: END IF;
354: --DBMS_OUTPUT.PUT_LINE_LINE('Calling deactivate API');
355: IBE_QUOTE_SAVESHARE_V2_PVT.DEACTIVATE_QUOTE (
356: P_Quote_header_id => P_Quote_header_rec.quote_header_id ,
357: P_Party_id => p_party_id ,
358: P_Cust_account_id => p_cust_account_id ,
359: P_minisite_id => p_minisite_id ,

Line 416: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.save_share_v2: END');

412: END IF;
413: END IF; --op_code = OP_DELETE_CART
414:
415: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
416: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.save_share_v2: END');
417: END IF;
418: EXCEPTION
419: WHEN FND_API.G_EXC_ERROR THEN
420: ROLLBACK TO SAVESHARE_V2;

Line 426: IBE_Util.Debug('Expected Error in IBE_QUOTE_SAVESHARE_V2_PVT.save_share_v2()');

422: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
423: p_count => x_msg_count ,
424: p_data => x_msg_data);
425: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
426: IBE_Util.Debug('Expected Error in IBE_QUOTE_SAVESHARE_V2_PVT.save_share_v2()');
427: END IF;
428:
429: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
430: ROLLBACK TO SAVESHARE_V2;

Line 436: IBE_Util.Debug('Unexpected Error in IBE_QUOTE_SAVESHARE_V2_PVT.save_share_v2()');

432: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
433: p_count => x_msg_count ,
434: p_data => x_msg_data);
435: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
436: IBE_Util.Debug('Unexpected Error in IBE_QUOTE_SAVESHARE_V2_PVT.save_share_v2()');
437: END IF;
438:
439: WHEN OTHERS THEN
440: ROLLBACK TO SAVESHARE_V2;

Line 450: IBE_Util.Debug('Unknown error IBE_QUOTE_SAVESHARE_V2_PVT.save_share_v2()');

446: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
447: p_count => x_msg_count ,
448: p_data => x_msg_data);
449: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
450: IBE_Util.Debug('Unknown error IBE_QUOTE_SAVESHARE_V2_PVT.save_share_v2()');
451: END IF;
452:
453:
454: END;

Line 574: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.save_recipients: START');

570: -------------------------------------------------------------------------------------------------------------
571:
572:
573: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
574: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.save_recipients: START');
575: END IF;
576: /*Obtain the party id of the user performing the action on the UI from the env*/
577: FOR rec_userenv_partyid in c_userenv_partyid LOOP
578: l_sharing_partyid := rec_userenv_partyid.customer_id;

Line 958: IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT(

954: IBE_UTIL.DEBUG('Calling delete_recipient');
955: IBE_UTIL.DEBUG('l_quote_access_rec.quote_sharee_id: '||l_quote_access_rec.quote_sharee_id);
956: END IF;
957:
958: IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT(
959: P_Quote_access_rec => l_quote_access_rec ,
960: p_minisite_id => p_minisite_id ,
961: p_url => p_url ,
962: p_notes => p_notes ,

Line 1015: --DBMS_OUTPUT.PUT_LINE('IBE_QUOTE_SAVESHARE_V2_PVT.save_recipients: END ');

1011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1012: END IF;
1013: END IF;
1014:
1015: --DBMS_OUTPUT.PUT_LINE('IBE_QUOTE_SAVESHARE_V2_PVT.save_recipients: END ');
1016:
1017: -- Standard check of p_commit.
1018: IF FND_API.To_Boolean( p_commit ) THEN
1019: COMMIT WORK;

Line 1027: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.save_recipients: END');

1023: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1024: p_count => x_msg_count ,
1025: p_data => x_msg_data);
1026: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1027: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.save_recipients: END');
1028: END IF;
1029:
1030: EXCEPTION
1031: WHEN FND_API.G_EXC_ERROR THEN

Line 1038: IBE_Util.Debug('Expected error in IBE_QUOTE_SAVESHARE_V2_PVT.SAVE_RECIPIENTS()');

1034: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1035: p_count => x_msg_count ,
1036: p_data => x_msg_data);
1037: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1038: IBE_Util.Debug('Expected error in IBE_QUOTE_SAVESHARE_V2_PVT.SAVE_RECIPIENTS()');
1039: END IF;
1040:
1041: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1042: ROLLBACK TO SAVERECIPIENTS_V2;

Line 1048: IBE_Util.Debug('Unxpected error in IBE_QUOTE_SAVESHARE_V2_PVT.SAVE_RECIPIENTS()');

1044: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1045: p_count => x_msg_count ,
1046: p_data => x_msg_data);
1047: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1048: IBE_Util.Debug('Unxpected error in IBE_QUOTE_SAVESHARE_V2_PVT.SAVE_RECIPIENTS()');
1049: END IF;
1050:
1051: WHEN OTHERS THEN
1052: ROLLBACK TO SAVERECIPIENTS_V2;

Line 1062: IBE_Util.Debug('Unknown exception IBE_QUOTE_SAVESHARE_V2_PVT.SAVE_RECIPIENTS()');

1058: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1059: p_count => x_msg_count ,
1060: p_data => x_msg_data);
1061: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1062: IBE_Util.Debug('Unknown exception IBE_QUOTE_SAVESHARE_V2_PVT.SAVE_RECIPIENTS()');
1063: END IF;
1064:
1065: END;
1066:

Line 1152: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.activate_quote: START');

1148: x_return_status := FND_API.G_RET_STS_SUCCESS;
1149:
1150:
1151: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1152: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.activate_quote: START');
1153: IBE_UTIL.DEBUG('p_party_id : '||p_party_id);
1154: IBE_UTIL.DEBUG('p_cust_account_id: '||p_cust_account_id);
1155: IBE_UTIL.DEBUG('p_retrieval_number: '||p_retrieval_number);
1156: IBE_UTIL.DEBUG('p_quote_header_id: '||p_quote_header_rec.quote_header_id);

Line 1158: --DBMS_OUTPUT.PUT_LINE('IBE_QUOTE_SAVESHARE_V2_PVT.activate_quote: START');

1154: IBE_UTIL.DEBUG('p_cust_account_id: '||p_cust_account_id);
1155: IBE_UTIL.DEBUG('p_retrieval_number: '||p_retrieval_number);
1156: IBE_UTIL.DEBUG('p_quote_header_id: '||p_quote_header_rec.quote_header_id);
1157: END IF;
1158: --DBMS_OUTPUT.PUT_LINE('IBE_QUOTE_SAVESHARE_V2_PVT.activate_quote: START');
1159: FOR rec_check_guest_oneclk in c_check_guest_oneclk(p_quote_header_rec.quote_header_id) LOOP
1160: l_cart_type := rec_check_guest_oneclk.quote_source_code;
1161: EXIT WHEN c_check_guest_oneclk%notfound;
1162: END LOOP;

Line 1277: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.activate_quote:User already has a row in active_quotes table');

1273: END IF; --l_ac_present
1274:
1275: IF (l_ac_party_id is not null) THEN
1276: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1277: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.activate_quote:User already has a row in active_quotes table');
1278: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.activate_quote:Calling update row hdlr');
1279: END IF;
1280: --DBMS_OUTPUT.PUT_LINE('Calling update row handler for active carts');
1281:

Line 1278: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.activate_quote:Calling update row hdlr');

1274:
1275: IF (l_ac_party_id is not null) THEN
1276: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1277: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.activate_quote:User already has a row in active_quotes table');
1278: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.activate_quote:Calling update row hdlr');
1279: END IF;
1280: --DBMS_OUTPUT.PUT_LINE('Calling update row handler for active carts');
1281:
1282: IBE_ACTIVE_QUOTES_ALL_PKG.update_row(

Line 1370: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.activate_quote: END');

1366: --DBMS_OUTPUT.PUT_LINE('Cannot activate a '||nvl(l_cart_type,'Invalid ')||' Cart');
1367:
1368: END IF; --qute source code check
1369: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1370: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.activate_quote: END');
1371: END IF;
1372:
1373: EXCEPTION
1374: WHEN FND_API.G_EXC_ERROR THEN

Line 1381: IBE_Util.Debug('Expected error in IBE_QUOTE_SAVESHARE_V2_PVT.activate_quote()');

1377: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1378: p_count => x_msg_count ,
1379: p_data => x_msg_data);
1380: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1381: IBE_Util.Debug('Expected error in IBE_QUOTE_SAVESHARE_V2_PVT.activate_quote()');
1382: END IF;
1383:
1384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1385: ROLLBACK TO ACTIVATEQUOTE_V2;

Line 1391: IBE_Util.Debug('Unexpected error in IBE_QUOTE_SAVESHARE_V2_PVT.activate_quote()');

1387: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1388: p_count => x_msg_count ,
1389: p_data => x_msg_data);
1390: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1391: IBE_Util.Debug('Unexpected error in IBE_QUOTE_SAVESHARE_V2_PVT.activate_quote()');
1392: END IF;
1393:
1394: WHEN OTHERS THEN
1395: ROLLBACK TO ACTIVATEQUOTE_V2;

Line 1405: IBE_Util.Debug('Unknown error IBE_QUOTE_SAVESHARE_V2_PVT.activate_quote()');

1401: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1402: p_count => x_msg_count ,
1403: p_data => x_msg_data);
1404: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1405: IBE_Util.Debug('Unknown error IBE_QUOTE_SAVESHARE_V2_PVT.activate_quote()');
1406: END IF;
1407:
1408: END;
1409:

Line 1581: IBE_UTIL.DEBUG('Expected exception in Ibe_quote_saveshare_v2_pvt.SaveContactPoint');

1577: EXCEPTION
1578: WHEN FND_API.G_EXC_ERROR THEN
1579: ROLLBACK TO SAVECONTACTPOINT_PVT;
1580: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1581: IBE_UTIL.DEBUG('Expected exception in Ibe_quote_saveshare_v2_pvt.SaveContactPoint');
1582: end if;
1583: x_return_status := FND_API.G_RET_STS_ERROR;
1584: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1585: p_count => x_msg_count,

Line 1589: IBE_UTIL.DEBUG('Unexpected exception in Ibe_quote_saveshare_v2_pvt.SaveContactPoint');

1585: p_count => x_msg_count,
1586: p_data => x_msg_data);
1587: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1588: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1589: IBE_UTIL.DEBUG('Unexpected exception in Ibe_quote_saveshare_v2_pvt.SaveContactPoint');
1590: end if;
1591:
1592: ROLLBACK TO SAVECONTACTPOINT_PVT;
1593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1599: IBE_UTIL.DEBUG('Unknown exception in Ibe_quote_saveshare_v2_pvt.SaveContactPoint');

1595: p_count => x_msg_count,
1596: p_data => x_msg_data);
1597: WHEN OTHERS THEN
1598: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1599: IBE_UTIL.DEBUG('Unknown exception in Ibe_quote_saveshare_v2_pvt.SaveContactPoint');
1600: end if;
1601:
1602: ROLLBACK TO SAVECONTACTPOINT_PVT;
1603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1711: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.deactivate_quote: END');

1707: COMMIT WORK;
1708: END IF;
1709:
1710: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1711: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.deactivate_quote: END');
1712: END IF;
1713:
1714: EXCEPTION
1715: WHEN FND_API.G_EXC_ERROR THEN

Line 1718: IBE_UTIL.DEBUG('Expected exception in Ibe_quote_saveshare_v2_pvt.Deactivate_quote');

1714: EXCEPTION
1715: WHEN FND_API.G_EXC_ERROR THEN
1716: ROLLBACK TO DEACTIVATEQUOTE_V2;
1717: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1718: IBE_UTIL.DEBUG('Expected exception in Ibe_quote_saveshare_v2_pvt.Deactivate_quote');
1719: end if;
1720:
1721: x_return_status := FND_API.G_RET_STS_ERROR;
1722: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 1726: IBE_Util.Debug('Unexpected error in IBE_QUOTE_SAVESHARE_V2_PVT.deactivate_quote');

1722: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1723: p_count => x_msg_count ,
1724: p_data => x_msg_data);
1725: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1726: IBE_Util.Debug('Unexpected error in IBE_QUOTE_SAVESHARE_V2_PVT.deactivate_quote');
1727: END IF;
1728:
1729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1730: ROLLBACK TO DEACTIVATEQUOTE_V2;

Line 1736: IBE_Util.Debug('Unknown error in IBE_QUOTE_SAVESHARE_V2_PVT.deactivate_quote');

1732: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1733: p_count => x_msg_count ,
1734: p_data => x_msg_data);
1735: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1736: IBE_Util.Debug('Unknown error in IBE_QUOTE_SAVESHARE_V2_PVT.deactivate_quote');
1737: END IF;
1738:
1739: WHEN OTHERS THEN
1740: ROLLBACK TO DEACTIVATEQUOTE_V2;

Line 1750: IBE_Util.Debug('Abnormal end IBE_QUOTE_SAVESHARE_V2_PVT.deactivate_quote');

1746: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1747: p_count => x_msg_count ,
1748: p_data => x_msg_data);
1749: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1750: IBE_Util.Debug('Abnormal end IBE_QUOTE_SAVESHARE_V2_PVT.deactivate_quote');
1751: END IF;
1752:
1753: END;
1754:

Line 1816: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE: START');

1812: -------------------------------------------------------------------------------------------------------------
1813: --API Body start
1814: -------------------------------------------------------------------------------------------------------------
1815: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1816: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE: START');
1817: END IF;
1818:
1819: IBE_Quote_Misc_pvt.validate_user_update
1820: (p_quote_header_id => P_source_quote_header_id,

Line 1835: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE:Calling IBE_QUOTE_SAVESHARE_pvt.Copy_lines');

1831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1832: END IF;
1833:
1834: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1835: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE:Calling IBE_QUOTE_SAVESHARE_pvt.Copy_lines');
1836: END IF;
1837: --DBMS_OUTPUT.PUT_LINE('IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE:Calling IBE_QUOTE_SAVESHARE_pvt.Copy_lines ');
1838:
1839: IBE_QUOTE_SAVESHARE_pvt.COPY_LINES(

Line 1837: --DBMS_OUTPUT.PUT_LINE('IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE:Calling IBE_QUOTE_SAVESHARE_pvt.Copy_lines ');

1833:
1834: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1835: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE:Calling IBE_QUOTE_SAVESHARE_pvt.Copy_lines');
1836: END IF;
1837: --DBMS_OUTPUT.PUT_LINE('IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE:Calling IBE_QUOTE_SAVESHARE_pvt.Copy_lines ');
1838:
1839: IBE_QUOTE_SAVESHARE_pvt.COPY_LINES(
1840: p_api_version_number => p_api_version ,
1841: p_init_msg_list => FND_API.G_FALSE ,

Line 1872: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE:IBE_QUOTE_SAVESHARE_pvt.Copy_lines End');

1868: --p_to_hd_shipment_rec?? $$
1869: -- l_hd_shipment_tbl(1).quote_header_id := P_target_header_rec.quote_header_id;
1870:
1871: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1872: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE:IBE_QUOTE_SAVESHARE_pvt.Copy_lines End');
1873: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE: Calling IBE_Quote_Save_pvt.Save to save target cart');
1874: END IF;
1875: --DBMS_OUTPUT.PUT_LINE('IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE: Calling IBE_Quote_Save_pvt.Save to save target cart ');
1876: --DBMS_OUTPUT.PUT_LINE('before save p_target_header_rec.quote_header_id '||p_target_header_rec.quote_header_id);

Line 1873: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE: Calling IBE_Quote_Save_pvt.Save to save target cart');

1869: -- l_hd_shipment_tbl(1).quote_header_id := P_target_header_rec.quote_header_id;
1870:
1871: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1872: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE:IBE_QUOTE_SAVESHARE_pvt.Copy_lines End');
1873: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE: Calling IBE_Quote_Save_pvt.Save to save target cart');
1874: END IF;
1875: --DBMS_OUTPUT.PUT_LINE('IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE: Calling IBE_Quote_Save_pvt.Save to save target cart ');
1876: --DBMS_OUTPUT.PUT_LINE('before save p_target_header_rec.quote_header_id '||p_target_header_rec.quote_header_id);
1877: IBE_Quote_Save_pvt.SAVE

Line 1875: --DBMS_OUTPUT.PUT_LINE('IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE: Calling IBE_Quote_Save_pvt.Save to save target cart ');

1871: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1872: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE:IBE_QUOTE_SAVESHARE_pvt.Copy_lines End');
1873: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE: Calling IBE_Quote_Save_pvt.Save to save target cart');
1874: END IF;
1875: --DBMS_OUTPUT.PUT_LINE('IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE: Calling IBE_Quote_Save_pvt.Save to save target cart ');
1876: --DBMS_OUTPUT.PUT_LINE('before save p_target_header_rec.quote_header_id '||p_target_header_rec.quote_header_id);
1877: IBE_Quote_Save_pvt.SAVE
1878: ( p_api_version_number => p_api_version
1879: ,p_init_msg_list => FND_API.G_FALSE

Line 1895: --DBMS_OUTPUT.PUT_LINE('IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE: Done save ');

1891: ,x_last_update_date => l_last_update_date
1892: ,x_return_status => x_return_status
1893: ,x_msg_count => x_msg_count
1894: ,x_msg_data => x_msg_data) ;
1895: --DBMS_OUTPUT.PUT_LINE('IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE: Done save ');
1896: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1897: RAISE FND_API.G_EXC_ERROR;
1898: END IF;
1899: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1903: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE: P_delete_source_cart: '||P_delete_source_cart);

1899: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1901: END IF;
1902: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1903: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE: P_delete_source_cart: '||P_delete_source_cart);
1904: END IF;
1905: IF (P_delete_source_cart = FND_API.G_TRUE ) THEN
1906: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1907: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE: P_delete_source_cart is true');

Line 1907: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE: P_delete_source_cart is true');

1903: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE: P_delete_source_cart: '||P_delete_source_cart);
1904: END IF;
1905: IF (P_delete_source_cart = FND_API.G_TRUE ) THEN
1906: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1907: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE: P_delete_source_cart is true');
1908: END IF;
1909: IBE_Quote_Save_pvt.Delete(
1910: p_api_version_number => p_api_version
1911: ,p_init_msg_list => FND_API.G_FALSE

Line 1928: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE:Delete on source cart done');

1924: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1926: END IF;
1927: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1928: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE:Delete on source cart done');
1929: END IF;
1930: END IF;
1931:
1932: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 1933: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE: END');

1929: END IF;
1930: END IF;
1931:
1932: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1933: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.APPEND_QUOTE: END');
1934: END IF;
1935:
1936: EXCEPTION
1937: WHEN FND_API.G_EXC_ERROR THEN

Line 1944: IBE_Util.Debug('Expected error in IBE_QUOTE_SAVESHARE_V2_PVT.append_quote()');

1940: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1941: p_count => x_msg_count ,
1942: p_data => x_msg_data);
1943: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1944: IBE_Util.Debug('Expected error in IBE_QUOTE_SAVESHARE_V2_PVT.append_quote()');
1945: END IF;
1946:
1947: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1948: ROLLBACK TO APPENDQUOTE_V2;

Line 1954: IBE_Util.Debug('Unexpected error in IBE_QUOTE_SAVESHARE_V2_PVT.append_quote()');

1950: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1951: p_count => x_msg_count ,
1952: p_data => x_msg_data);
1953: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1954: IBE_Util.Debug('Unexpected error in IBE_QUOTE_SAVESHARE_V2_PVT.append_quote()');
1955: END IF;
1956:
1957: WHEN OTHERS THEN
1958: ROLLBACK TO APPENDQUOTE_V2;

Line 1968: IBE_Util.Debug('Abnormal end IBE_QUOTE_SAVESHARE_V2_PVT.append_quote()');

1964: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1965: p_count => x_msg_count ,
1966: p_data => x_msg_data);
1967: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1968: IBE_Util.Debug('Abnormal end IBE_QUOTE_SAVESHARE_V2_PVT.append_quote()');
1969: END IF;
1970:
1971: END;
1972:

Line 2068: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.STOP_SHARING: START');

2064: -------------------------------------------------------------------------------------------------------------
2065: --API Body start
2066: -------------------------------------------------------------------------------------------------------------
2067: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2068: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.STOP_SHARING: START');
2069: END IF;
2070: -- Stop sharing should deactivate owner's active cart if any.
2071: --dbms_output.put_line('p_quote_header_id: '||p_quote_header_id);
2072: FOR rec_get_owner in c_get_owner(p_quote_header_id) LOOP

Line 2085: IBE_QUOTE_SAVESHARE_V2_PVT.DEACTIVATE_QUOTE (

2081: --DBMS_OUTPUT.PUT_LINE('Calling deactivate API to deactivate owner''s cart');
2082: --dbms_output.put_line('PARTY_ID: '||l_owner_party_id);
2083: --dbms_output.put_line('CUST_ACCOUNT_ID: '||l_owner_cust_account_id );
2084:
2085: IBE_QUOTE_SAVESHARE_V2_PVT.DEACTIVATE_QUOTE (
2086: P_Quote_header_id => p_quote_header_id ,
2087: P_Party_id => l_owner_party_id ,
2088: P_Cust_account_id => l_owner_cust_account_id ,
2089: P_minisite_id => p_minisite_id ,

Line 2187: IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT(

2183: IBE_UTIL.DEBUG('STOP_SHARING:l_quote_access_tbl:'||i||':cust_account_id: '||l_quote_access_tbl(i).cust_account_id);
2184: END IF;
2185: --dbms_output.put_line('STOP_SHARING:l_quote_access_tbl:'||i||':quote_sharee_id: '||l_quote_access_tbl(i).quote_sharee_id);
2186: --dbms_output.put_line('Calling delete recipient for the recipient record ');
2187: IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT(
2188: P_Quote_access_rec => l_quote_access_tbl(i) ,
2189: p_minisite_id => p_minisite_id ,
2190: p_delete_code => p_delete_context ,
2191: p_notes => p_notes ,

Line 2233: IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT(

2229: IBE_UTIL.DEBUG('STOP_SHARING:l_quote_access_tbl:'||i||':cust_account_id: '||l_quote_access_tbl_tmp(i).cust_account_id);
2230: END IF;
2231: --dbms_output.put_line('STOP_SHARING:l_quote_access_tbl:'||i||':quote_sharee_id: '||l_quote_access_tbl_tmp(i).quote_sharee_id);
2232: --dbms_output.put_line('Calling delete recipient for the recipient record ');
2233: IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT(
2234: P_Quote_access_rec => l_quote_access_tbl_tmp(i) ,
2235: p_minisite_id => p_minisite_id ,
2236: p_delete_code => p_delete_context ,
2237: p_notes => FND_API.G_MISS_CHAR ,

Line 2254: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.STOP_SHARING: END');

2250: IBE_UTIL.DEBUG('STOP_SHARING: Concurrency part ends');
2251: END IF;
2252:
2253: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2254: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.STOP_SHARING: END');
2255: END IF;
2256:
2257: EXCEPTION
2258:

Line 2266: IBE_Util.Debug('Expected error in IBE_QUOTE_SAVESHARE_V2_PVT.STOPSHARING_V2');

2262: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2263: p_count => x_msg_count ,
2264: p_data => x_msg_data);
2265: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2266: IBE_Util.Debug('Expected error in IBE_QUOTE_SAVESHARE_V2_PVT.STOPSHARING_V2');
2267: END IF;
2268:
2269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2270: ROLLBACK TO STOPSHARING_V2;

Line 2276: IBE_Util.Debug('Unexpected error in IBE_QUOTE_SAVESHARE_V2_PVT.STOPSHARING_V2');

2272: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2273: p_count => x_msg_count ,
2274: p_data => x_msg_data);
2275: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2276: IBE_Util.Debug('Unexpected error in IBE_QUOTE_SAVESHARE_V2_PVT.STOPSHARING_V2');
2277: END IF;
2278:
2279: WHEN OTHERS THEN
2280: ROLLBACK TO STOPSHARING_V2;

Line 2290: IBE_Util.Debug('Unknown error in IBE_QUOTE_SAVESHARE_V2_PVT.STOPSHARING_V2');

2286: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2287: p_count => x_msg_count ,
2288: p_data => x_msg_data);
2289: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2290: IBE_Util.Debug('Unknown error in IBE_QUOTE_SAVESHARE_V2_PVT.STOPSHARING_V2');
2291: END IF;
2292:
2293: END;
2294:

Line 2379: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING: START');

2375: EXIT when c_userenv_partyid%notfound;
2376: END LOOP;
2377:
2378: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2379: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING: START');
2380: END IF;
2381: --DBMS_OUTPUT.PUT_LINE('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING: START');
2382: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2383: IBE_UTIL.DEBUG('Opening cursor to retrieve the recipient_id');

Line 2381: --DBMS_OUTPUT.PUT_LINE('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING: START');

2377:
2378: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2379: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING: START');
2380: END IF;
2381: --DBMS_OUTPUT.PUT_LINE('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING: START');
2382: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2383: IBE_UTIL.DEBUG('Opening cursor to retrieve the recipient_id');
2384: END IF;
2385: --DBMS_OUTPUT.PUT_LINE('Opening cursor to retrieve the recipient_id');

Line 2408: IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT(

2404: IBE_UTIL.DEBUG('Recipient id obtained is: '||l_quote_access_rec.quote_sharee_id);
2405: END IF;
2406:
2407: --DBMS_OUTPUT.PUT_LINE('Recipient id obtained is: '||l_quote_access_rec.quote_sharee_id);
2408: IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT(
2409: P_Quote_access_rec => l_quote_access_rec ,
2410: p_minisite_id => p_minisite_id ,
2411: p_delete_code => 'END_WORKING' ,
2412: p_url => p_url ,

Line 2443: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING: Ready to call view shared cart');

2439: -- Assign the quote_sharee_id to l_quote_access_rec (value needed in the notification api,3349991)
2440: l_quote_access_rec_recip.quote_sharee_id := p_quote_access_tbl(counter).quote_sharee_id;
2441:
2442: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2443: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING: Ready to call view shared cart');
2444: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:initiator_party_id: '||l_initiator_id);
2445: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:recipient party_id: '||l_quote_access_rec_recip.party_id);
2446: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:recipient number: '||l_quote_access_rec_recip.quote_sharee_number);
2447: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:recipient id: '||l_quote_access_rec_recip.quote_sharee_id);

Line 2444: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:initiator_party_id: '||l_initiator_id);

2440: l_quote_access_rec_recip.quote_sharee_id := p_quote_access_tbl(counter).quote_sharee_id;
2441:
2442: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2443: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING: Ready to call view shared cart');
2444: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:initiator_party_id: '||l_initiator_id);
2445: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:recipient party_id: '||l_quote_access_rec_recip.party_id);
2446: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:recipient number: '||l_quote_access_rec_recip.quote_sharee_number);
2447: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:recipient id: '||l_quote_access_rec_recip.quote_sharee_id);
2448: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:contact_point_id: '||l_quote_access_rec_recip.contact_point_id);

Line 2445: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:recipient party_id: '||l_quote_access_rec_recip.party_id);

2441:
2442: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2443: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING: Ready to call view shared cart');
2444: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:initiator_party_id: '||l_initiator_id);
2445: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:recipient party_id: '||l_quote_access_rec_recip.party_id);
2446: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:recipient number: '||l_quote_access_rec_recip.quote_sharee_number);
2447: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:recipient id: '||l_quote_access_rec_recip.quote_sharee_id);
2448: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:contact_point_id: '||l_quote_access_rec_recip.contact_point_id);
2449: END IF;

Line 2446: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:recipient number: '||l_quote_access_rec_recip.quote_sharee_number);

2442: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2443: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING: Ready to call view shared cart');
2444: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:initiator_party_id: '||l_initiator_id);
2445: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:recipient party_id: '||l_quote_access_rec_recip.party_id);
2446: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:recipient number: '||l_quote_access_rec_recip.quote_sharee_number);
2447: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:recipient id: '||l_quote_access_rec_recip.quote_sharee_id);
2448: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:contact_point_id: '||l_quote_access_rec_recip.contact_point_id);
2449: END IF;
2450:

Line 2447: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:recipient id: '||l_quote_access_rec_recip.quote_sharee_id);

2443: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING: Ready to call view shared cart');
2444: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:initiator_party_id: '||l_initiator_id);
2445: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:recipient party_id: '||l_quote_access_rec_recip.party_id);
2446: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:recipient number: '||l_quote_access_rec_recip.quote_sharee_number);
2447: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:recipient id: '||l_quote_access_rec_recip.quote_sharee_id);
2448: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:contact_point_id: '||l_quote_access_rec_recip.contact_point_id);
2449: END IF;
2450:
2451: IBE_WORKFLOW_PVT.Notify_view_shared_cart(

Line 2448: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:contact_point_id: '||l_quote_access_rec_recip.contact_point_id);

2444: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:initiator_party_id: '||l_initiator_id);
2445: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:recipient party_id: '||l_quote_access_rec_recip.party_id);
2446: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:recipient number: '||l_quote_access_rec_recip.quote_sharee_number);
2447: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:recipient id: '||l_quote_access_rec_recip.quote_sharee_id);
2448: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:contact_point_id: '||l_quote_access_rec_recip.contact_point_id);
2449: END IF;
2450:
2451: IBE_WORKFLOW_PVT.Notify_view_shared_cart(
2452: p_api_version => p_api_version

Line 2472: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING: END');

2468: END IF;
2469: END LOOP;
2470:
2471: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2472: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING: END');
2473: END IF;
2474: --DBMS_OUTPUT.PUT_LINE('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING: END ');
2475: EXCEPTION
2476: WHEN FND_API.G_EXC_ERROR THEN

Line 2474: --DBMS_OUTPUT.PUT_LINE('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING: END ');

2470:
2471: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2472: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING: END');
2473: END IF;
2474: --DBMS_OUTPUT.PUT_LINE('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING: END ');
2475: EXCEPTION
2476: WHEN FND_API.G_EXC_ERROR THEN
2477: ROLLBACK TO ENDWORKING_V2;
2478: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2483: IBE_Util.Debug('Expected error in IBE_QUOTE_SAVESHARE_V2_PVT.ENDWORKING');

2479: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2480: p_count => x_msg_count ,
2481: p_data => x_msg_data);
2482: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2483: IBE_Util.Debug('Expected error in IBE_QUOTE_SAVESHARE_V2_PVT.ENDWORKING');
2484: END IF;
2485:
2486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2487: ROLLBACK TO ENDWORKING_V2;

Line 2493: IBE_Util.Debug('Unexpected error in IBE_QUOTE_SAVESHARE_V2_PVT.ENDWORKING)');

2489: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2490: p_count => x_msg_count ,
2491: p_data => x_msg_data);
2492: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2493: IBE_Util.Debug('Unexpected error in IBE_QUOTE_SAVESHARE_V2_PVT.ENDWORKING)');
2494: END IF;
2495:
2496: WHEN OTHERS THEN
2497: ROLLBACK TO ENDWORKING_V2;

Line 2507: IBE_Util.Debug('Unknown error in IBE_QUOTE_SAVESHARE_V2_PVT.ENDWORKING');

2503: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2504: p_count => x_msg_count ,
2505: p_data => x_msg_data);
2506: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2507: IBE_Util.Debug('Unknown error in IBE_QUOTE_SAVESHARE_V2_PVT.ENDWORKING');
2508: END IF;
2509:
2510:
2511: END;

Line 2569: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.SHARE_READONLY: START');

2565: --API Body start
2566: -------------------------------------------------------------------------------------------------------------
2567:
2568: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2569: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.SHARE_READONLY: START');
2570: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.SHARE_READONLY:quote_header_id: '||p_quote_header_id);
2571: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.SHARE_READONLY: Querying initiator party id');
2572: END IF;
2573:

Line 2570: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.SHARE_READONLY:quote_header_id: '||p_quote_header_id);

2566: -------------------------------------------------------------------------------------------------------------
2567:
2568: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2569: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.SHARE_READONLY: START');
2570: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.SHARE_READONLY:quote_header_id: '||p_quote_header_id);
2571: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.SHARE_READONLY: Querying initiator party id');
2572: END IF;
2573:
2574: FOR rec_userenv_partyid in c_userenv_partyid LOOP

Line 2571: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.SHARE_READONLY: Querying initiator party id');

2567:
2568: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2569: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.SHARE_READONLY: START');
2570: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.SHARE_READONLY:quote_header_id: '||p_quote_header_id);
2571: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.SHARE_READONLY: Querying initiator party id');
2572: END IF;
2573:
2574: FOR rec_userenv_partyid in c_userenv_partyid LOOP
2575: l_initiator_id := rec_userenv_partyid.customer_id;

Line 2609: IBE_QUOTE_SAVESHARE_V2_PVT.save_recipients(

2605:
2606: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2607: IBE_UTIL.DEBUG('Calling save_recipients to update recipient access level');
2608: END IF;
2609: IBE_QUOTE_SAVESHARE_V2_PVT.save_recipients(
2610: P_Quote_access_tbl => l_quote_access_tbl ,
2611: P_Quote_header_id => P_Quote_header_id ,
2612: P_minisite_id => p_minisite_id ,
2613: p_url => p_url ,

Line 2623: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.SHARE_READONLY: END');

2619: x_msg_data => x_msg_data );
2620:
2621: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2622: IBE_UTIL.DEBUG('Done calling save_recipients to update recipient access level');
2623: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.SHARE_READONLY: END');
2624: END IF;
2625:
2626: EXCEPTION
2627:

Line 2635: IBE_Util.Debug('Expected error in IBE_QUOTE_SAVESHARE_V2_PVT.SHAREREADONLY_V2');

2631: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2632: p_count => x_msg_count ,
2633: p_data => x_msg_data);
2634: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2635: IBE_Util.Debug('Expected error in IBE_QUOTE_SAVESHARE_V2_PVT.SHAREREADONLY_V2');
2636: END IF;
2637:
2638: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2639: ROLLBACK TO STOPSHARING_V2;

Line 2645: IBE_Util.Debug('Unexpected error in IBE_QUOTE_SAVESHARE_V2_PVT.SHAREREADONLY_V2');

2641: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2642: p_count => x_msg_count ,
2643: p_data => x_msg_data);
2644: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2645: IBE_Util.Debug('Unexpected error in IBE_QUOTE_SAVESHARE_V2_PVT.SHAREREADONLY_V2');
2646: END IF;
2647:
2648: WHEN OTHERS THEN
2649: ROLLBACK TO STOPSHARING_V2;

Line 2659: IBE_Util.Debug('Unknown error in IBE_QUOTE_SAVESHARE_V2_PVT.SHAREREADONLY_V2');

2655: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2656: p_count => x_msg_count ,
2657: p_data => x_msg_data);
2658: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2659: IBE_Util.Debug('Unknown error in IBE_QUOTE_SAVESHARE_V2_PVT.SHAREREADONLY_V2');
2660: END IF;
2661: END;
2662:
2663: /*To delete a recipient (a sort of wrapper around the "raw" delete table hander)

Line 2745: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT: START');

2741: --API Body start
2742: -------------------------------------------------------------------------------------------------------------
2743:
2744: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2745: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT: START');
2746: END IF;
2747: FOR rec_find_active_cart in c_find_active_cart loop
2748: IF(rec_find_active_cart.quote_header_id is not null) THEN
2749: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 2750: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT:user has an active cart');

2746: END IF;
2747: FOR rec_find_active_cart in c_find_active_cart loop
2748: IF(rec_find_active_cart.quote_header_id is not null) THEN
2749: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2750: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT:user has an active cart');
2751: IBE_UTIL.DEBUG('Calling update row handler to deactivate the cart');
2752: END IF;
2753: --DBMS_OUTPUT.PUT_LINE('IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT:user has an active cart');
2754:

Line 2753: --DBMS_OUTPUT.PUT_LINE('IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT:user has an active cart');

2749: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2750: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT:user has an active cart');
2751: IBE_UTIL.DEBUG('Calling update row handler to deactivate the cart');
2752: END IF;
2753: --DBMS_OUTPUT.PUT_LINE('IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT:user has an active cart');
2754:
2755: IBE_ACTIVE_QUOTES_ALL_PKG.UPDATE_ROW(
2756: X_OBJECT_VERSION_NUMBER => 1 ,
2757: X_QUOTE_HEADER_ID => null ,

Line 2803: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT: END');

2799: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2800: IBE_UTIL.DEBUG('Done calling Update row handler on sh_quote_access table to end-date recipient row');
2801: END IF;
2802: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2803: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT: END');
2804: IBE_UTIL.DEBUG('delete_code is: '||p_delete_code);
2805: END IF;
2806:
2807: IF (p_quote_access_rec.notify_flag = FND_API.G_TRUE) THEN

Line 2889: IBE_Util.Debug('Expected error in IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT()');

2885: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2886: p_count => x_msg_count ,
2887: p_data => x_msg_data);
2888: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2889: IBE_Util.Debug('Expected error in IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT()');
2890: END IF;
2891:
2892: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2893: ROLLBACK TO DELETERECIPIENT_V2;

Line 2899: IBE_Util.Debug('Unexpected error in IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT()');

2895: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2896: p_count => x_msg_count ,
2897: p_data => x_msg_data);
2898: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2899: IBE_Util.Debug('Unexpected error in IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT()');
2900: END IF;
2901:
2902: WHEN OTHERS THEN
2903: ROLLBACK TO DELETERECIPIENT_V2;

Line 2913: IBE_Util.Debug('Unknown error in IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT()');

2909: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2910: p_count => x_msg_count ,
2911: p_data => x_msg_data);
2912: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2913: IBE_Util.Debug('Unknown error in IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT()');
2914: END IF;
2915:
2916: END;
2917:

Line 3223: END IBE_QUOTE_SAVESHARE_V2_PVT;

3219: IBE_Util.Debug('End IBE_Quote_Misc_pvt.validate_share_update: other exception');
3220: END IF;
3221: END validate_share_update;
3222:
3223: END IBE_QUOTE_SAVESHARE_V2_PVT;