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 2005/12/09 01:57:19 makulkar 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 2166: IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT(

2162: IBE_UTIL.DEBUG('STOP_SHARING:l_quote_access_tbl:'||i||':cust_account_id: '||l_quote_access_tbl(i).cust_account_id);
2163: END IF;
2164: --dbms_output.put_line('STOP_SHARING:l_quote_access_tbl:'||i||':quote_sharee_id: '||l_quote_access_tbl(i).quote_sharee_id);
2165: --dbms_output.put_line('Calling delete recipient for the recipient record ');
2166: IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT(
2167: P_Quote_access_rec => l_quote_access_tbl(i) ,
2168: p_minisite_id => p_minisite_id ,
2169: p_delete_code => p_delete_context ,
2170: p_notes => p_notes ,

Line 2212: IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT(

2208: IBE_UTIL.DEBUG('STOP_SHARING:l_quote_access_tbl:'||i||':cust_account_id: '||l_quote_access_tbl_tmp(i).cust_account_id);
2209: END IF;
2210: --dbms_output.put_line('STOP_SHARING:l_quote_access_tbl:'||i||':quote_sharee_id: '||l_quote_access_tbl_tmp(i).quote_sharee_id);
2211: --dbms_output.put_line('Calling delete recipient for the recipient record ');
2212: IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT(
2213: P_Quote_access_rec => l_quote_access_tbl_tmp(i) ,
2214: p_minisite_id => p_minisite_id ,
2215: p_delete_code => p_delete_context ,
2216: p_notes => FND_API.G_MISS_CHAR ,

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

2229: IBE_UTIL.DEBUG('STOP_SHARING: Concurrency part ends');
2230: END IF;
2231:
2232: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2233: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.STOP_SHARING: END');
2234: END IF;
2235:
2236: EXCEPTION
2237:

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

2241: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2242: p_count => x_msg_count ,
2243: p_data => x_msg_data);
2244: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2245: IBE_Util.Debug('Expected error in IBE_QUOTE_SAVESHARE_V2_PVT.STOPSHARING_V2');
2246: END IF;
2247:
2248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2249: ROLLBACK TO STOPSHARING_V2;

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

2251: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2252: p_count => x_msg_count ,
2253: p_data => x_msg_data);
2254: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2255: IBE_Util.Debug('Unexpected error in IBE_QUOTE_SAVESHARE_V2_PVT.STOPSHARING_V2');
2256: END IF;
2257:
2258: WHEN OTHERS THEN
2259: ROLLBACK TO STOPSHARING_V2;

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

2265: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2266: p_count => x_msg_count ,
2267: p_data => x_msg_data);
2268: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2269: IBE_Util.Debug('Unknown error in IBE_QUOTE_SAVESHARE_V2_PVT.STOPSHARING_V2');
2270: END IF;
2271:
2272: END;
2273:

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

2354: EXIT when c_userenv_partyid%notfound;
2355: END LOOP;
2356:
2357: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2358: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING: START');
2359: END IF;
2360: --DBMS_OUTPUT.PUT_LINE('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING: START');
2361: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2362: IBE_UTIL.DEBUG('Opening cursor to retrieve the recipient_id');

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

2356:
2357: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2358: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING: START');
2359: END IF;
2360: --DBMS_OUTPUT.PUT_LINE('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING: START');
2361: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2362: IBE_UTIL.DEBUG('Opening cursor to retrieve the recipient_id');
2363: END IF;
2364: --DBMS_OUTPUT.PUT_LINE('Opening cursor to retrieve the recipient_id');

Line 2387: IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT(

2383: IBE_UTIL.DEBUG('Recipient id obtained is: '||l_quote_access_rec.quote_sharee_id);
2384: END IF;
2385:
2386: --DBMS_OUTPUT.PUT_LINE('Recipient id obtained is: '||l_quote_access_rec.quote_sharee_id);
2387: IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT(
2388: P_Quote_access_rec => l_quote_access_rec ,
2389: p_minisite_id => p_minisite_id ,
2390: p_delete_code => 'END_WORKING' ,
2391: p_url => p_url ,

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

2418: -- Assign the quote_sharee_id to l_quote_access_rec (value needed in the notification api,3349991)
2419: l_quote_access_rec_recip.quote_sharee_id := p_quote_access_tbl(counter).quote_sharee_id;
2420:
2421: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2422: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING: Ready to call view shared cart');
2423: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:initiator_party_id: '||l_initiator_id);
2424: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:recipient party_id: '||l_quote_access_rec_recip.party_id);
2425: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:recipient number: '||l_quote_access_rec_recip.quote_sharee_number);
2426: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:recipient id: '||l_quote_access_rec_recip.quote_sharee_id);

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

2419: l_quote_access_rec_recip.quote_sharee_id := p_quote_access_tbl(counter).quote_sharee_id;
2420:
2421: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2422: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING: Ready to call view shared cart');
2423: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:initiator_party_id: '||l_initiator_id);
2424: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:recipient party_id: '||l_quote_access_rec_recip.party_id);
2425: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:recipient number: '||l_quote_access_rec_recip.quote_sharee_number);
2426: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:recipient id: '||l_quote_access_rec_recip.quote_sharee_id);
2427: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:contact_point_id: '||l_quote_access_rec_recip.contact_point_id);

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

2420:
2421: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2422: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING: Ready to call view shared cart');
2423: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:initiator_party_id: '||l_initiator_id);
2424: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:recipient party_id: '||l_quote_access_rec_recip.party_id);
2425: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:recipient number: '||l_quote_access_rec_recip.quote_sharee_number);
2426: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:recipient id: '||l_quote_access_rec_recip.quote_sharee_id);
2427: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:contact_point_id: '||l_quote_access_rec_recip.contact_point_id);
2428: END IF;

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

2421: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2422: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING: Ready to call view shared cart');
2423: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:initiator_party_id: '||l_initiator_id);
2424: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:recipient party_id: '||l_quote_access_rec_recip.party_id);
2425: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:recipient number: '||l_quote_access_rec_recip.quote_sharee_number);
2426: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:recipient id: '||l_quote_access_rec_recip.quote_sharee_id);
2427: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:contact_point_id: '||l_quote_access_rec_recip.contact_point_id);
2428: END IF;
2429:

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

2422: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING: Ready to call view shared cart');
2423: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:initiator_party_id: '||l_initiator_id);
2424: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:recipient party_id: '||l_quote_access_rec_recip.party_id);
2425: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:recipient number: '||l_quote_access_rec_recip.quote_sharee_number);
2426: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:recipient id: '||l_quote_access_rec_recip.quote_sharee_id);
2427: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:contact_point_id: '||l_quote_access_rec_recip.contact_point_id);
2428: END IF;
2429:
2430: IBE_WORKFLOW_PVT.Notify_view_shared_cart(

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

2423: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:initiator_party_id: '||l_initiator_id);
2424: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:recipient party_id: '||l_quote_access_rec_recip.party_id);
2425: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:recipient number: '||l_quote_access_rec_recip.quote_sharee_number);
2426: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:recipient id: '||l_quote_access_rec_recip.quote_sharee_id);
2427: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING:contact_point_id: '||l_quote_access_rec_recip.contact_point_id);
2428: END IF;
2429:
2430: IBE_WORKFLOW_PVT.Notify_view_shared_cart(
2431: p_api_version => p_api_version

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

2447: END IF;
2448: END LOOP;
2449:
2450: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2451: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING: END');
2452: END IF;
2453: --DBMS_OUTPUT.PUT_LINE('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING: END ');
2454: EXCEPTION
2455: WHEN FND_API.G_EXC_ERROR THEN

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

2449:
2450: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2451: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING: END');
2452: END IF;
2453: --DBMS_OUTPUT.PUT_LINE('IBE_QUOTE_SAVESHARE_V2_PVT.END_WORKING: END ');
2454: EXCEPTION
2455: WHEN FND_API.G_EXC_ERROR THEN
2456: ROLLBACK TO ENDWORKING_V2;
2457: x_return_status := FND_API.G_RET_STS_ERROR;

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

2458: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2459: p_count => x_msg_count ,
2460: p_data => x_msg_data);
2461: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2462: IBE_Util.Debug('Expected error in IBE_QUOTE_SAVESHARE_V2_PVT.ENDWORKING');
2463: END IF;
2464:
2465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2466: ROLLBACK TO ENDWORKING_V2;

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

2468: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2469: p_count => x_msg_count ,
2470: p_data => x_msg_data);
2471: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2472: IBE_Util.Debug('Unexpected error in IBE_QUOTE_SAVESHARE_V2_PVT.ENDWORKING)');
2473: END IF;
2474:
2475: WHEN OTHERS THEN
2476: ROLLBACK TO ENDWORKING_V2;

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

2482: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2483: p_count => x_msg_count ,
2484: p_data => x_msg_data);
2485: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2486: IBE_Util.Debug('Unknown error in IBE_QUOTE_SAVESHARE_V2_PVT.ENDWORKING');
2487: END IF;
2488:
2489:
2490: END;

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

2544: --API Body start
2545: -------------------------------------------------------------------------------------------------------------
2546:
2547: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2548: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.SHARE_READONLY: START');
2549: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.SHARE_READONLY:quote_header_id: '||p_quote_header_id);
2550: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.SHARE_READONLY: Querying initiator party id');
2551: END IF;
2552:

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

2545: -------------------------------------------------------------------------------------------------------------
2546:
2547: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2548: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.SHARE_READONLY: START');
2549: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.SHARE_READONLY:quote_header_id: '||p_quote_header_id);
2550: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.SHARE_READONLY: Querying initiator party id');
2551: END IF;
2552:
2553: FOR rec_userenv_partyid in c_userenv_partyid LOOP

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

2546:
2547: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2548: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.SHARE_READONLY: START');
2549: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.SHARE_READONLY:quote_header_id: '||p_quote_header_id);
2550: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.SHARE_READONLY: Querying initiator party id');
2551: END IF;
2552:
2553: FOR rec_userenv_partyid in c_userenv_partyid LOOP
2554: l_initiator_id := rec_userenv_partyid.customer_id;

Line 2588: IBE_QUOTE_SAVESHARE_V2_PVT.save_recipients(

2584:
2585: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2586: IBE_UTIL.DEBUG('Calling save_recipients to update recipient access level');
2587: END IF;
2588: IBE_QUOTE_SAVESHARE_V2_PVT.save_recipients(
2589: P_Quote_access_tbl => l_quote_access_tbl ,
2590: P_Quote_header_id => P_Quote_header_id ,
2591: P_minisite_id => p_minisite_id ,
2592: p_url => p_url ,

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

2598: x_msg_data => x_msg_data );
2599:
2600: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2601: IBE_UTIL.DEBUG('Done calling save_recipients to update recipient access level');
2602: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.SHARE_READONLY: END');
2603: END IF;
2604:
2605: EXCEPTION
2606:

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

2610: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2611: p_count => x_msg_count ,
2612: p_data => x_msg_data);
2613: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2614: IBE_Util.Debug('Expected error in IBE_QUOTE_SAVESHARE_V2_PVT.SHAREREADONLY_V2');
2615: END IF;
2616:
2617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2618: ROLLBACK TO STOPSHARING_V2;

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

2620: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2621: p_count => x_msg_count ,
2622: p_data => x_msg_data);
2623: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2624: IBE_Util.Debug('Unexpected error in IBE_QUOTE_SAVESHARE_V2_PVT.SHAREREADONLY_V2');
2625: END IF;
2626:
2627: WHEN OTHERS THEN
2628: ROLLBACK TO STOPSHARING_V2;

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

2634: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2635: p_count => x_msg_count ,
2636: p_data => x_msg_data);
2637: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2638: IBE_Util.Debug('Unknown error in IBE_QUOTE_SAVESHARE_V2_PVT.SHAREREADONLY_V2');
2639: END IF;
2640: END;
2641:
2642: /*To delete a recipient (a sort of wrapper around the "raw" delete table hander)

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

2720: --API Body start
2721: -------------------------------------------------------------------------------------------------------------
2722:
2723: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2724: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT: START');
2725: END IF;
2726: FOR rec_find_active_cart in c_find_active_cart loop
2727: IF(rec_find_active_cart.quote_header_id is not null) THEN
2728: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

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

2725: END IF;
2726: FOR rec_find_active_cart in c_find_active_cart loop
2727: IF(rec_find_active_cart.quote_header_id is not null) THEN
2728: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2729: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT:user has an active cart');
2730: IBE_UTIL.DEBUG('Calling update row handler to deactivate the cart');
2731: END IF;
2732: --DBMS_OUTPUT.PUT_LINE('IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT:user has an active cart');
2733:

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

2728: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2729: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT:user has an active cart');
2730: IBE_UTIL.DEBUG('Calling update row handler to deactivate the cart');
2731: END IF;
2732: --DBMS_OUTPUT.PUT_LINE('IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT:user has an active cart');
2733:
2734: IBE_ACTIVE_QUOTES_ALL_PKG.UPDATE_ROW(
2735: X_OBJECT_VERSION_NUMBER => 1 ,
2736: X_QUOTE_HEADER_ID => null ,

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

2778: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2779: IBE_UTIL.DEBUG('Done calling Update row handler on sh_quote_access table to end-date recipient row');
2780: END IF;
2781: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2782: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT: END');
2783: IBE_UTIL.DEBUG('delete_code is: '||p_delete_code);
2784: END IF;
2785:
2786: IF (p_quote_access_rec.notify_flag = FND_API.G_TRUE) THEN

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

2864: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2865: p_count => x_msg_count ,
2866: p_data => x_msg_data);
2867: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2868: IBE_Util.Debug('Expected error in IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT()');
2869: END IF;
2870:
2871: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2872: ROLLBACK TO DELETERECIPIENT_V2;

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

2874: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2875: p_count => x_msg_count ,
2876: p_data => x_msg_data);
2877: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2878: IBE_Util.Debug('Unexpected error in IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT()');
2879: END IF;
2880:
2881: WHEN OTHERS THEN
2882: ROLLBACK TO DELETERECIPIENT_V2;

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

2888: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2889: p_count => x_msg_count ,
2890: p_data => x_msg_data);
2891: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2892: IBE_Util.Debug('Unknown error in IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT()');
2893: END IF;
2894:
2895: END;
2896:

Line 3202: END IBE_QUOTE_SAVESHARE_V2_PVT;

3198: IBE_Util.Debug('End IBE_Quote_Misc_pvt.validate_share_update: other exception');
3199: END IF;
3200: END validate_share_update;
3201:
3202: END IBE_QUOTE_SAVESHARE_V2_PVT;