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_SAVE_PVT dependencies on IBE_QUOTE_MISC_PVT

Line 620: IBE_Quote_Misc_pvt.Get_Active_Quote_ID(

616: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
617: IBE_Util.Debug(' need to get active cart');
618: END IF;
619: x_qte_header_rec.quote_header_id :=
620: IBE_Quote_Misc_pvt.Get_Active_Quote_ID(
621: p_party_id => p_qte_header_rec.party_id,
622: p_cust_account_id => p_qte_header_rec.cust_account_id);
623: -- create quote
624: IF x_qte_header_rec.quote_header_id = 0 THEN

Line 1401: IBE_Quote_Misc_pvt.Validate_User_Update

1397: -- User Authentication
1398: --DBMS_OUTPUT.PUT_line('validate_user_update start ');
1399: -- if there is no qte access tbl, then we're in the owner only flow
1400: IF (nvl(p_Quote_access_tbl.count,0) = 0) THEN
1401: IBE_Quote_Misc_pvt.Validate_User_Update
1402: (
1403: p_init_msg_list => FND_API.G_TRUE
1404: ,p_quote_header_id => p_quote_header_id
1405: ,p_validate_user => FND_API.G_TRUE

Line 1428: l_quote_status := IBE_Quote_Misc_pvt.get_Quote_status(p_quote_header_id);

1424: -- get quote stutus
1425: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1426: IBE_UTIL.DEBUG('get quote stutus');
1427: END IF;
1428: l_quote_status := IBE_Quote_Misc_pvt.get_Quote_status(p_quote_header_id);
1429:
1430: IF (l_quote_status = 'NOT_EXIST') THEN
1431: --DBMS_OUTPUT.PUT_line('Quote not exists ');
1432: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 1458: IBE_Quote_Misc_pvt.validateQuoteLastUpdateDate

1454: and p_last_update_date <> FND_API.G_MISS_DATE) THEN
1455: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1456: IBE_UTIL.DEBUG('validate last_update_date ');
1457: END IF;
1458: IBE_Quote_Misc_pvt.validateQuoteLastUpdateDate
1459: ( p_api_version_number => p_api_version_number
1460: ,p_quote_header_id => p_quote_header_id
1461: ,p_last_update_date => p_last_update_date
1462: ,X_Return_Status => x_return_status

Line 1711: IBE_Quote_Misc_pvt.Validate_User_Update

1707:
1708: -- API body
1709:
1710: -- User Authentication
1711: IBE_Quote_Misc_pvt.Validate_User_Update
1712: ( p_init_msg_list => p_init_msg_list
1713: ,p_quote_header_id => p_quote_header_id
1714: ,p_quote_retrieval_number => p_sharee_number
1715: ,p_validate_user => FND_API.G_TRUE

Line 1825: px_last_update_date := IBE_Quote_Misc_pvt.getQuoteLastUpdateDate(p_qte_header_id);

1821: px_last_update_date OUT NOCOPY DATE)
1822: IS
1823: BEGIN
1824: IF p_qte_header_id <> FND_API.G_MISS_NUM THEN
1825: px_last_update_date := IBE_Quote_Misc_pvt.getQuoteLastUpdateDate(p_qte_header_id);
1826: END IF;
1827: END Set_Last_Update_Date;
1828:
1829: -- formerly AddItemsToCart; the original addItemsToCart

Line 2365: IBE_Util.Debug('IBE_QUOTE_MISC_PVT.get_multi_svc_profile: '||IBE_QUOTE_MISC_PVT.get_multi_svc_profile);

2361: IBE_Util.Debug('Entering the logic for line level support');
2362: END IF;
2363:
2364: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2365: IBE_Util.Debug('IBE_QUOTE_MISC_PVT.get_multi_svc_profile: '||IBE_QUOTE_MISC_PVT.get_multi_svc_profile);
2366: END IF;
2367:
2368: --CHANGES FOR LINE LEVEL SERVICES
2369: IF(IBE_QUOTE_MISC_PVT.get_multi_svc_profile <> 'T') THEN

Line 2369: IF(IBE_QUOTE_MISC_PVT.get_multi_svc_profile <> 'T') THEN

2365: IBE_Util.Debug('IBE_QUOTE_MISC_PVT.get_multi_svc_profile: '||IBE_QUOTE_MISC_PVT.get_multi_svc_profile);
2366: END IF;
2367:
2368: --CHANGES FOR LINE LEVEL SERVICES
2369: IF(IBE_QUOTE_MISC_PVT.get_multi_svc_profile <> 'T') THEN
2370:
2371: FOR i in 1..p_Qte_Line_Dtl_Tbl.count LOOP
2372: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2373: IBE_Util.Debug('p_Qte_Line_Dtl_Tbl(i).service_ref_type_code: '||p_Qte_Line_Dtl_Tbl(i).service_ref_type_code);

Line 2463: IBE_Quote_Misc_pvt.Get_Active_Quote_ID(

2459: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2460: IBE_Util.Debug(' need to get active cart');
2461: END IF;
2462: l_checkActiveCartId :=
2463: IBE_Quote_Misc_pvt.Get_Active_Quote_ID(
2464: p_party_id => p_qte_header_rec.party_id,
2465: p_cust_account_id => p_qte_header_rec.cust_account_id);
2466: -- create quote
2467: IF (l_checkActiveCartId = 0) THEN

Line 2987: IBE_Quote_Misc_pvt.Validate_User_Update

2983: x_return_status := FND_API.G_RET_STS_SUCCESS;
2984: -- API body
2985:
2986: -- User Authentication
2987: IBE_Quote_Misc_pvt.Validate_User_Update
2988: ( p_init_msg_list => p_init_msg_list
2989: ,p_quote_header_id => p_Qte_Header_Rec.quote_header_id
2990: ,p_party_id => p_Qte_Header_Rec.party_id
2991: ,p_cust_account_id => p_Qte_Header_Rec.cust_account_id

Line 3697: IBE_Quote_Misc_pvt.log_environment_info();

3693: --API Body
3694: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3695: IBE_UTIL.DEBUG('REQUEST_FOR_SALES_ASSISTANCE: Before Calling log_environment_info');
3696: END IF;
3697: IBE_Quote_Misc_pvt.log_environment_info();
3698: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3699: IBE_UTIL.DEBUG('REQUEST_FOR_SALES_ASSISTANCE: After Calling log_environment_info');
3700: IBE_UTIL.DEBUG('REQUEST_FOR_SALES_ASSISTANCE: p_retrieval_number = '||p_retrieval_number);
3701: END IF;

Line 3703: IBE_Quote_Misc_pvt.Validate_User_Update

3699: IBE_UTIL.DEBUG('REQUEST_FOR_SALES_ASSISTANCE: After Calling log_environment_info');
3700: IBE_UTIL.DEBUG('REQUEST_FOR_SALES_ASSISTANCE: p_retrieval_number = '||p_retrieval_number);
3701: END IF;
3702: -- User Authentication
3703: IBE_Quote_Misc_pvt.Validate_User_Update
3704: ( p_init_msg_list => p_Init_Msg_List
3705: ,p_quote_header_id => p_quote_header_id
3706: ,p_party_id => p_party_id
3707: ,p_cust_account_id => p_cust_account_id

Line 3894: IBE_UTIL.debug('calling IBE_QUOTE_MISC_PVT.get_aso_quote_status');

3890: IBE_UTIL.debug('l_trans_Contract_templ_id = '||l_trans_Contract_template_id);
3891: END IF;
3892:
3893: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3894: IBE_UTIL.debug('calling IBE_QUOTE_MISC_PVT.get_aso_quote_status');
3895: END IF;
3896: l_quote_status := IBE_QUOTE_MISC_PVT.get_aso_quote_status(p_quote_header_id);
3897: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3898: IBE_UTIL.debug('returned from IBE_QUOTE_MISC_PVT.get_aso_quote_status, l_quote_status = '||l_quote_status);

Line 3896: l_quote_status := IBE_QUOTE_MISC_PVT.get_aso_quote_status(p_quote_header_id);

3892:
3893: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3894: IBE_UTIL.debug('calling IBE_QUOTE_MISC_PVT.get_aso_quote_status');
3895: END IF;
3896: l_quote_status := IBE_QUOTE_MISC_PVT.get_aso_quote_status(p_quote_header_id);
3897: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3898: IBE_UTIL.debug('returned from IBE_QUOTE_MISC_PVT.get_aso_quote_status, l_quote_status = '||l_quote_status);
3899: END IF;
3900: IF(upper(l_quote_status) <> 'APPROVED') THEN

Line 3898: IBE_UTIL.debug('returned from IBE_QUOTE_MISC_PVT.get_aso_quote_status, l_quote_status = '||l_quote_status);

3894: IBE_UTIL.debug('calling IBE_QUOTE_MISC_PVT.get_aso_quote_status');
3895: END IF;
3896: l_quote_status := IBE_QUOTE_MISC_PVT.get_aso_quote_status(p_quote_header_id);
3897: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3898: IBE_UTIL.debug('returned from IBE_QUOTE_MISC_PVT.get_aso_quote_status, l_quote_status = '||l_quote_status);
3899: END IF;
3900: IF(upper(l_quote_status) <> 'APPROVED') THEN
3901: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3902: IBE_UTIL.debug('calling OKC_XPRT_INT_GRP.get_contract_terms...');

Line 4443: IBE_Quote_Misc_pvt.log_environment_info();

4439:
4440: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4441: IBE_UTIL.DEBUG('SAVE: Before Calling log_environment_info');
4442: END IF;
4443: IBE_Quote_Misc_pvt.log_environment_info();
4444:
4445: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4446: IBE_UTIL.DEBUG('SAVE: After Calling log_environment_info');
4447: END IF;

Line 4460: IBE_Quote_Misc_pvt.Validate_User_Update

4456: IF(p_save_type <> OP_DELETE_CART) THEN
4457: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4458: IBE_UTIL.DEBUG('SAVE: Calling Validate User');
4459: END IF;
4460: IBE_Quote_Misc_pvt.Validate_User_Update
4461: ( p_init_msg_list => p_Init_Msg_List
4462: ,p_quote_header_id => p_Qte_Header_Rec.quote_header_id
4463: ,p_party_id => p_Qte_Header_Rec.party_id
4464: ,p_cust_account_id => p_Qte_Header_Rec.cust_account_id

Line 4494: l_is_quote_usable := IBE_QUOTE_MISC_PVT.is_quote_usable(p_qte_header_rec.quote_header_id,

4490: --DBMS_OUTPUT.PUT_line('p_qte_header_rec.quote_header_id '||p_qte_header_rec.quote_header_id);
4491: --Verify if the incoming quote is usable or not
4492: /*In this case we perticularly ensure that quote identified by p_qte_header_rec.quote_header_id
4493: has not expired because we do not want to allow updates on expired carts*/
4494: l_is_quote_usable := IBE_QUOTE_MISC_PVT.is_quote_usable(p_qte_header_rec.quote_header_id,
4495: p_Qte_Header_Rec.party_id,
4496: p_Qte_Header_Rec.cust_account_id);
4497: --Raise an error f the above validation failed
4498: IF(l_is_quote_usable = FND_API.G_FALSE) THEN

Line 4574: l_privilege_type_code := IBE_Quote_Misc_pvt.GetShareeprivilege(l_qte_header_rec.quote_header_id

4570:
4571: IF ( ( p_sharee_Number is not null)
4572: and ( p_sharee_Number <> FND_API.G_MISS_NUM)) THEN
4573:
4574: l_privilege_type_code := IBE_Quote_Misc_pvt.GetShareeprivilege(l_qte_header_rec.quote_header_id
4575: ,p_sharee_Number);
4576: IF ((l_privilege_type_code <> 'A')
4577: and (l_privilege_type_code <> 'F' )) THEN
4578: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN

Line 4790: IBE_Quote_Misc_pvt.Get_Active_Quote_ID

4786: /*IF ((p_qte_header_rec.quote_source_code = 'IStore Account')
4787: AND ( p_qte_header_rec.quote_name = 'IBEACTIVECART'
4788: OR p_qte_header_rec.quote_name = FND_API.G_MISS_CHAR )) then
4789: IF x_qte_header_rec.quote_header_id <>
4790: IBE_Quote_Misc_pvt.Get_Active_Quote_ID
4791: (p_party_id => x_qte_header_rec.party_id
4792: ,p_cust_account_id => x_qte_header_rec.cust_account_id
4793: ,p_only_max => FALSE) then
4794: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN

Line 4849: l_tmp_hd_payment_tbl := IBE_Quote_Misc_pvt.getHeaderPaymentTbl(l_qte_header_rec.quote_header_id);

4845: exit when c_quote_sts_id%notfound;
4846: end loop;
4847: END IF;
4848: l_count := 0;
4849: l_tmp_hd_payment_tbl := IBE_Quote_Misc_pvt.getHeaderPaymentTbl(l_qte_header_rec.quote_header_id);
4850: IF l_tmp_hd_payment_tbl.COUNT > 0 THEN
4851: FOR I IN 1..p_hd_payment_tbl.COUNT LOOP
4852: IF l_hd_payment_tbl(I).operation_code = 'CREATE' THEN
4853: l_count := l_count + 1;

Line 4859: IBE_Quote_Misc_pvt.getQuoteLastUpdateDate(l_qte_header_rec.quote_header_id); -- Bug# 1955991

4855: l_hd_payment_tbl(I).operation_code := 'UPDATE'; -- Bug# 1955991
4856: l_hd_payment_tbl(I).payment_id := l_tmp_hd_payment_tbl(I).payment_id;
4857: /*
4858: l_hd_payment_tbl(I).last_update_date :=
4859: IBE_Quote_Misc_pvt.getQuoteLastUpdateDate(l_qte_header_rec.quote_header_id); -- Bug# 1955991
4860: */
4861: /* Bug#1955991
4862: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4863: FND_Message.Set_Name('IBE', 'IBE_QUOTE_HDR_PMT_RCRD_EXISTS');

Line 4882: IBE_Quote_Misc_pvt.getQuoteLastUpdateDate(l_qte_header_rec.quote_header_id); -- Bug# 1955991

4878: END IF;
4879: */
4880: /* Added by Sri 09/06 since the header last update date should be the value in the db */
4881: l_qte_header_rec.last_update_date :=
4882: IBE_Quote_Misc_pvt.getQuoteLastUpdateDate(l_qte_header_rec.quote_header_id); -- Bug# 1955991
4883: END IF;
4884: l_hd_shipment_tbl := p_hd_shipment_tbl;
4885: -- More Bug# 1955991
4886: l_tmp_hd_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(

Line 4897: IBE_Quote_Misc_pvt.getQuoteLastUpdateDate(l_qte_header_rec.quote_header_id); -- Bug# 1955991

4893: l_hd_shipment_tbl(I).operation_code := 'UPDATE';
4894: l_hd_shipment_tbl(I).shipment_id := l_tmp_hd_shipment_tbl(I).shipment_id;
4895: /*
4896: l_hd_shipment_tbl(I).last_update_date :=
4897: IBE_Quote_Misc_pvt.getQuoteLastUpdateDate(l_qte_header_rec.quote_header_id); -- Bug# 1955991
4898: */
4899: END IF;
4900: END LOOP;
4901: /* Added by Sri 09/06 since the header last update date should be the value in the db */

Line 4903: IBE_Quote_Misc_pvt.getQuoteLastUpdateDate(l_qte_header_rec.quote_header_id); -- Bug# 1955991

4899: END IF;
4900: END LOOP;
4901: /* Added by Sri 09/06 since the header last update date should be the value in the db */
4902: l_qte_header_rec.last_update_date :=
4903: IBE_Quote_Misc_pvt.getQuoteLastUpdateDate(l_qte_header_rec.quote_header_id); -- Bug# 1955991
4904:
4905: END IF;
4906: -- End Bug# 1955991
4907:

Line 5284: IBE_Quote_Misc_pvt.getQuoteOwner(

5280: x_return_status := FND_API.G_RET_STS_SUCCESS;
5281:
5282: -- API body
5283:
5284: IBE_Quote_Misc_pvt.getQuoteOwner(
5285: p_api_version_number => p_api_version_number
5286: ,p_quote_header_id => p_qte_header_rec.quote_header_id
5287: ,x_party_id => l_quote_Party_id
5288: ,x_cust_account_id => l_quote_Cust_account_id

Line 5853: l_userType := IBE_Quote_Misc_pvt.getUserType(lx_qte_header_rec.party_id);

5849: --dbms_output.put_line('*******************************');
5850: end if; -- if there is billTo address
5851:
5852: -- #3 End Customer Info (added 1/24/05>
5853: l_userType := IBE_Quote_Misc_pvt.getUserType(lx_qte_header_rec.party_id);
5854: if (l_userType = 'B2B') then
5855: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5856: IBE_Util.Debug('getHdrDefaultEndCustomer() starts');
5857: END IF;

Line 6184: l_userType := IBE_Quote_Misc_pvt.getUserType(px_qte_header_rec.party_id);

6180: --DBMS_OUTPUT.PUT_line('lx_party_site_id ='||lx_party_site_id);
6181:
6182: -- 2.1 populate the shipment/quote hdr record:
6183: if ((lx_party_site_id <> -1) and (lx_party_site_id <> fnd_api.g_miss_num) and (lx_party_site_id is not null) ) then
6184: l_userType := IBE_Quote_Misc_pvt.getUserType(px_qte_header_rec.party_id);
6185: if (p_party_site_use = 'S') then
6186: px_hd_Shipment_TBL(1).shipment_id := l_shipment_id;
6187: px_hd_Shipment_TBL(1).quote_header_id := px_qte_header_rec.quote_header_id;
6188: px_hd_Shipment_TBL(1).operation_code := l_opCode;

Line 7134: IBE_Quote_Misc_pvt.validate_user_update(

7130:
7131: -- API body
7132:
7133: -- User Authentication
7134: IBE_Quote_Misc_pvt.validate_user_update(
7135: p_init_msg_list => p_Init_Msg_List
7136: ,p_quote_header_id => p_quote_id
7137: ,p_party_id => p_party_id
7138: ,p_cust_account_id => p_cust_account_id

Line 7409: IBE_Quote_Misc_pvt.log_environment_info();

7405: --API Body
7406: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
7407: IBE_UTIL.DEBUG('DUPLICATE_CART: Before Calling log_environment_info');
7408: END IF;
7409: IBE_Quote_Misc_pvt.log_environment_info();
7410: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
7411: IBE_UTIL.DEBUG('DUPLICATE_CART: After Calling log_environment_info');
7412: IBE_UTIL.DEBUG('DUPLICATE_CART: p_retrieval_number = '||p_retrieval_number);
7413: IBE_UTIL.DEBUG('DUPLICATE_CART: p_new_quote_name = '||p_new_quote_name);

Line 7417: IBE_Quote_Misc_pvt.Validate_User_Update

7413: IBE_UTIL.DEBUG('DUPLICATE_CART: p_new_quote_name = '||p_new_quote_name);
7414: END IF;
7415:
7416: -- User Authentication
7417: IBE_Quote_Misc_pvt.Validate_User_Update
7418: ( p_init_msg_list => p_Init_Msg_List
7419: ,p_quote_header_id => p_quote_header_id
7420: ,p_party_id => p_party_id
7421: ,p_cust_account_id => p_cust_account_id