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 601: IBE_Quote_Misc_pvt.Get_Active_Quote_ID(

597: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
598: IBE_Util.Debug(' need to get active cart');
599: END IF;
600: x_qte_header_rec.quote_header_id :=
601: IBE_Quote_Misc_pvt.Get_Active_Quote_ID(
602: p_party_id => p_qte_header_rec.party_id,
603: p_cust_account_id => p_qte_header_rec.cust_account_id);
604: -- create quote
605: IF x_qte_header_rec.quote_header_id = 0 THEN

Line 1382: IBE_Quote_Misc_pvt.Validate_User_Update

1378: -- User Authentication
1379: --DBMS_OUTPUT.PUT_line('validate_user_update start ');
1380: -- if there is no qte access tbl, then we're in the owner only flow
1381: IF (nvl(p_Quote_access_tbl.count,0) = 0) THEN
1382: IBE_Quote_Misc_pvt.Validate_User_Update
1383: (
1384: p_init_msg_list => FND_API.G_TRUE
1385: ,p_quote_header_id => p_quote_header_id
1386: ,p_validate_user => FND_API.G_TRUE

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

1405: -- get quote stutus
1406: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1407: IBE_UTIL.DEBUG('get quote stutus');
1408: END IF;
1409: l_quote_status := IBE_Quote_Misc_pvt.get_Quote_status(p_quote_header_id);
1410:
1411: IF (l_quote_status = 'NOT_EXIST') THEN
1412: --DBMS_OUTPUT.PUT_line('Quote not exists ');
1413: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 1439: IBE_Quote_Misc_pvt.validateQuoteLastUpdateDate

1435: and p_last_update_date <> FND_API.G_MISS_DATE) THEN
1436: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1437: IBE_UTIL.DEBUG('validate last_update_date ');
1438: END IF;
1439: IBE_Quote_Misc_pvt.validateQuoteLastUpdateDate
1440: ( p_api_version_number => p_api_version_number
1441: ,p_quote_header_id => p_quote_header_id
1442: ,p_last_update_date => p_last_update_date
1443: ,X_Return_Status => x_return_status

Line 1692: IBE_Quote_Misc_pvt.Validate_User_Update

1688:
1689: -- API body
1690:
1691: -- User Authentication
1692: IBE_Quote_Misc_pvt.Validate_User_Update
1693: ( p_init_msg_list => p_init_msg_list
1694: ,p_quote_header_id => p_quote_header_id
1695: ,p_quote_retrieval_number => p_sharee_number
1696: ,p_validate_user => FND_API.G_TRUE

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

1802: px_last_update_date OUT NOCOPY DATE)
1803: IS
1804: BEGIN
1805: IF p_qte_header_id <> FND_API.G_MISS_NUM THEN
1806: px_last_update_date := IBE_Quote_Misc_pvt.getQuoteLastUpdateDate(p_qte_header_id);
1807: END IF;
1808: END Set_Last_Update_Date;
1809:
1810: -- formerly AddItemsToCart; the original addItemsToCart

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

2342: IBE_Util.Debug('Entering the logic for line level support');
2343: END IF;
2344:
2345: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2346: IBE_Util.Debug('IBE_QUOTE_MISC_PVT.get_multi_svc_profile: '||IBE_QUOTE_MISC_PVT.get_multi_svc_profile);
2347: END IF;
2348:
2349: --CHANGES FOR LINE LEVEL SERVICES
2350: IF(IBE_QUOTE_MISC_PVT.get_multi_svc_profile <> 'T') THEN

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

2346: IBE_Util.Debug('IBE_QUOTE_MISC_PVT.get_multi_svc_profile: '||IBE_QUOTE_MISC_PVT.get_multi_svc_profile);
2347: END IF;
2348:
2349: --CHANGES FOR LINE LEVEL SERVICES
2350: IF(IBE_QUOTE_MISC_PVT.get_multi_svc_profile <> 'T') THEN
2351:
2352: FOR i in 1..p_Qte_Line_Dtl_Tbl.count LOOP
2353: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2354: IBE_Util.Debug('p_Qte_Line_Dtl_Tbl(i).service_ref_type_code: '||p_Qte_Line_Dtl_Tbl(i).service_ref_type_code);

Line 2444: IBE_Quote_Misc_pvt.Get_Active_Quote_ID(

2440: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2441: IBE_Util.Debug(' need to get active cart');
2442: END IF;
2443: l_checkActiveCartId :=
2444: IBE_Quote_Misc_pvt.Get_Active_Quote_ID(
2445: p_party_id => p_qte_header_rec.party_id,
2446: p_cust_account_id => p_qte_header_rec.cust_account_id);
2447: -- create quote
2448: IF (l_checkActiveCartId = 0) THEN

Line 2968: IBE_Quote_Misc_pvt.Validate_User_Update

2964: x_return_status := FND_API.G_RET_STS_SUCCESS;
2965: -- API body
2966:
2967: -- User Authentication
2968: IBE_Quote_Misc_pvt.Validate_User_Update
2969: ( p_init_msg_list => p_init_msg_list
2970: ,p_quote_header_id => p_Qte_Header_Rec.quote_header_id
2971: ,p_party_id => p_Qte_Header_Rec.party_id
2972: ,p_cust_account_id => p_Qte_Header_Rec.cust_account_id

Line 3678: IBE_Quote_Misc_pvt.log_environment_info();

3674: --API Body
3675: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3676: IBE_UTIL.DEBUG('REQUEST_FOR_SALES_ASSISTANCE: Before Calling log_environment_info');
3677: END IF;
3678: IBE_Quote_Misc_pvt.log_environment_info();
3679: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3680: IBE_UTIL.DEBUG('REQUEST_FOR_SALES_ASSISTANCE: After Calling log_environment_info');
3681: IBE_UTIL.DEBUG('REQUEST_FOR_SALES_ASSISTANCE: p_retrieval_number = '||p_retrieval_number);
3682: END IF;

Line 3684: IBE_Quote_Misc_pvt.Validate_User_Update

3680: IBE_UTIL.DEBUG('REQUEST_FOR_SALES_ASSISTANCE: After Calling log_environment_info');
3681: IBE_UTIL.DEBUG('REQUEST_FOR_SALES_ASSISTANCE: p_retrieval_number = '||p_retrieval_number);
3682: END IF;
3683: -- User Authentication
3684: IBE_Quote_Misc_pvt.Validate_User_Update
3685: ( p_init_msg_list => p_Init_Msg_List
3686: ,p_quote_header_id => p_quote_header_id
3687: ,p_party_id => p_party_id
3688: ,p_cust_account_id => p_cust_account_id

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

3871: IBE_UTIL.debug('l_trans_Contract_templ_id = '||l_trans_Contract_template_id);
3872: END IF;
3873:
3874: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3875: IBE_UTIL.debug('calling IBE_QUOTE_MISC_PVT.get_aso_quote_status');
3876: END IF;
3877: l_quote_status := IBE_QUOTE_MISC_PVT.get_aso_quote_status(p_quote_header_id);
3878: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3879: IBE_UTIL.debug('returned from IBE_QUOTE_MISC_PVT.get_aso_quote_status, l_quote_status = '||l_quote_status);

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

3873:
3874: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3875: IBE_UTIL.debug('calling IBE_QUOTE_MISC_PVT.get_aso_quote_status');
3876: END IF;
3877: l_quote_status := IBE_QUOTE_MISC_PVT.get_aso_quote_status(p_quote_header_id);
3878: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3879: IBE_UTIL.debug('returned from IBE_QUOTE_MISC_PVT.get_aso_quote_status, l_quote_status = '||l_quote_status);
3880: END IF;
3881: IF(upper(l_quote_status) <> 'APPROVED') THEN

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

3875: IBE_UTIL.debug('calling IBE_QUOTE_MISC_PVT.get_aso_quote_status');
3876: END IF;
3877: l_quote_status := IBE_QUOTE_MISC_PVT.get_aso_quote_status(p_quote_header_id);
3878: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3879: IBE_UTIL.debug('returned from IBE_QUOTE_MISC_PVT.get_aso_quote_status, l_quote_status = '||l_quote_status);
3880: END IF;
3881: IF(upper(l_quote_status) <> 'APPROVED') THEN
3882: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3883: IBE_UTIL.debug('calling OKC_XPRT_INT_GRP.get_contract_terms...');

Line 4399: IBE_Quote_Misc_pvt.log_environment_info();

4395:
4396: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4397: IBE_UTIL.DEBUG('SAVE: Before Calling log_environment_info');
4398: END IF;
4399: IBE_Quote_Misc_pvt.log_environment_info();
4400:
4401: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4402: IBE_UTIL.DEBUG('SAVE: After Calling log_environment_info');
4403: END IF;

Line 4416: IBE_Quote_Misc_pvt.Validate_User_Update

4412: IF(p_save_type <> OP_DELETE_CART) THEN
4413: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4414: IBE_UTIL.DEBUG('SAVE: Calling Validate User');
4415: END IF;
4416: IBE_Quote_Misc_pvt.Validate_User_Update
4417: ( p_init_msg_list => p_Init_Msg_List
4418: ,p_quote_header_id => p_Qte_Header_Rec.quote_header_id
4419: ,p_party_id => p_Qte_Header_Rec.party_id
4420: ,p_cust_account_id => p_Qte_Header_Rec.cust_account_id

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

4446: --DBMS_OUTPUT.PUT_line('p_qte_header_rec.quote_header_id '||p_qte_header_rec.quote_header_id);
4447: --Verify if the incoming quote is usable or not
4448: /*In this case we perticularly ensure that quote identified by p_qte_header_rec.quote_header_id
4449: has not expired because we do not want to allow updates on expired carts*/
4450: l_is_quote_usable := IBE_QUOTE_MISC_PVT.is_quote_usable(p_qte_header_rec.quote_header_id,
4451: p_Qte_Header_Rec.party_id,
4452: p_Qte_Header_Rec.cust_account_id);
4453: --Raise an error f the above validation failed
4454: IF(l_is_quote_usable = FND_API.G_FALSE) THEN

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

4526:
4527: IF ( ( p_sharee_Number is not null)
4528: and ( p_sharee_Number <> FND_API.G_MISS_NUM)) THEN
4529:
4530: l_privilege_type_code := IBE_Quote_Misc_pvt.GetShareeprivilege(l_qte_header_rec.quote_header_id
4531: ,p_sharee_Number);
4532: IF ((l_privilege_type_code <> 'A')
4533: and (l_privilege_type_code <> 'F' )) THEN
4534: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN

Line 4703: IBE_Quote_Misc_pvt.Get_Active_Quote_ID

4699: /*IF ((p_qte_header_rec.quote_source_code = 'IStore Account')
4700: AND ( p_qte_header_rec.quote_name = 'IBEACTIVECART'
4701: OR p_qte_header_rec.quote_name = FND_API.G_MISS_CHAR )) then
4702: IF x_qte_header_rec.quote_header_id <>
4703: IBE_Quote_Misc_pvt.Get_Active_Quote_ID
4704: (p_party_id => x_qte_header_rec.party_id
4705: ,p_cust_account_id => x_qte_header_rec.cust_account_id
4706: ,p_only_max => FALSE) then
4707: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN

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

4758: exit when c_quote_sts_id%notfound;
4759: end loop;
4760: END IF;
4761: l_count := 0;
4762: l_tmp_hd_payment_tbl := IBE_Quote_Misc_pvt.getHeaderPaymentTbl(l_qte_header_rec.quote_header_id);
4763: IF l_tmp_hd_payment_tbl.COUNT > 0 THEN
4764: FOR I IN 1..p_hd_payment_tbl.COUNT LOOP
4765: IF l_hd_payment_tbl(I).operation_code = 'CREATE' THEN
4766: l_count := l_count + 1;

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

4768: l_hd_payment_tbl(I).operation_code := 'UPDATE'; -- Bug# 1955991
4769: l_hd_payment_tbl(I).payment_id := l_tmp_hd_payment_tbl(I).payment_id;
4770: /*
4771: l_hd_payment_tbl(I).last_update_date :=
4772: IBE_Quote_Misc_pvt.getQuoteLastUpdateDate(l_qte_header_rec.quote_header_id); -- Bug# 1955991
4773: */
4774: /* Bug#1955991
4775: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4776: FND_Message.Set_Name('IBE', 'IBE_QUOTE_HDR_PMT_RCRD_EXISTS');

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

4791: END IF;
4792: */
4793: /* Added by Sri 09/06 since the header last update date should be the value in the db */
4794: l_qte_header_rec.last_update_date :=
4795: IBE_Quote_Misc_pvt.getQuoteLastUpdateDate(l_qte_header_rec.quote_header_id); -- Bug# 1955991
4796: END IF;
4797: l_hd_shipment_tbl := p_hd_shipment_tbl;
4798: -- More Bug# 1955991
4799: l_tmp_hd_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(

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

4806: l_hd_shipment_tbl(I).operation_code := 'UPDATE';
4807: l_hd_shipment_tbl(I).shipment_id := l_tmp_hd_shipment_tbl(I).shipment_id;
4808: /*
4809: l_hd_shipment_tbl(I).last_update_date :=
4810: IBE_Quote_Misc_pvt.getQuoteLastUpdateDate(l_qte_header_rec.quote_header_id); -- Bug# 1955991
4811: */
4812: END IF;
4813: END LOOP;
4814: /* Added by Sri 09/06 since the header last update date should be the value in the db */

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

4812: END IF;
4813: END LOOP;
4814: /* Added by Sri 09/06 since the header last update date should be the value in the db */
4815: l_qte_header_rec.last_update_date :=
4816: IBE_Quote_Misc_pvt.getQuoteLastUpdateDate(l_qte_header_rec.quote_header_id); -- Bug# 1955991
4817:
4818: END IF;
4819: -- End Bug# 1955991
4820:

Line 5180: IBE_Quote_Misc_pvt.getQuoteOwner(

5176: x_return_status := FND_API.G_RET_STS_SUCCESS;
5177:
5178: -- API body
5179:
5180: IBE_Quote_Misc_pvt.getQuoteOwner(
5181: p_api_version_number => p_api_version_number
5182: ,p_quote_header_id => p_qte_header_rec.quote_header_id
5183: ,x_party_id => l_quote_Party_id
5184: ,x_cust_account_id => l_quote_Cust_account_id

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

5745: --dbms_output.put_line('*******************************');
5746: end if; -- if there is billTo address
5747:
5748: -- #3 End Customer Info (added 1/24/05>
5749: l_userType := IBE_Quote_Misc_pvt.getUserType(lx_qte_header_rec.party_id);
5750: if (l_userType = 'B2B') then
5751: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5752: IBE_Util.Debug('getHdrDefaultEndCustomer() starts');
5753: END IF;

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

6076: --DBMS_OUTPUT.PUT_line('lx_party_site_id ='||lx_party_site_id);
6077:
6078: -- 2.1 populate the shipment/quote hdr record:
6079: 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
6080: l_userType := IBE_Quote_Misc_pvt.getUserType(px_qte_header_rec.party_id);
6081: if (p_party_site_use = 'S') then
6082: px_hd_Shipment_TBL(1).shipment_id := l_shipment_id;
6083: px_hd_Shipment_TBL(1).quote_header_id := px_qte_header_rec.quote_header_id;
6084: px_hd_Shipment_TBL(1).operation_code := l_opCode;

Line 6998: IBE_Quote_Misc_pvt.validate_user_update(

6994:
6995: -- API body
6996:
6997: -- User Authentication
6998: IBE_Quote_Misc_pvt.validate_user_update(
6999: p_init_msg_list => p_Init_Msg_List
7000: ,p_quote_header_id => p_quote_id
7001: ,p_party_id => p_party_id
7002: ,p_cust_account_id => p_cust_account_id

Line 7272: IBE_Quote_Misc_pvt.log_environment_info();

7268: --API Body
7269: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
7270: IBE_UTIL.DEBUG('DUPLICATE_CART: Before Calling log_environment_info');
7271: END IF;
7272: IBE_Quote_Misc_pvt.log_environment_info();
7273: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
7274: IBE_UTIL.DEBUG('DUPLICATE_CART: After Calling log_environment_info');
7275: IBE_UTIL.DEBUG('DUPLICATE_CART: p_retrieval_number = '||p_retrieval_number);
7276: IBE_UTIL.DEBUG('DUPLICATE_CART: p_new_quote_name = '||p_new_quote_name);

Line 7280: IBE_Quote_Misc_pvt.Validate_User_Update

7276: IBE_UTIL.DEBUG('DUPLICATE_CART: p_new_quote_name = '||p_new_quote_name);
7277: END IF;
7278:
7279: -- User Authentication
7280: IBE_Quote_Misc_pvt.Validate_User_Update
7281: ( p_init_msg_list => p_Init_Msg_List
7282: ,p_quote_header_id => p_quote_header_id
7283: ,p_party_id => p_party_id
7284: ,p_cust_account_id => p_cust_account_id