[Home] [Help]
1: PACKAGE BODY IBE_Quote_Misc_pvt AS
2: /* $Header: IBEVQMIB.pls 120.16.12020000.2 2012/08/14 06:44:52 amaheshw ship $ */
3:
4:
5: l_true VARCHAR2(1) := FND_API.G_TRUE;
87:
88: EXCEPTION
89: WHEN FND_API.G_EXC_ERROR THEN
90: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
91: IBE_Util.Debug('Expected exception in IBE_QUOTE_MISC_PVT.Is_quote_usable');
92: END IF;
93:
94: ROLLBACK TO is_quote_usable;
95: l_return_status := FND_API.G_RET_STS_ERROR;
97: p_count => l_msg_count,
98: p_data => l_msg_data);
99: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
100: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
101: IBE_Util.Debug('Unexpected exception in IBE_QUOTE_MISC_PVT.Is_quote_usable');
102: END IF;
103: ROLLBACK TO is_quote_usable;
104: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
105: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
106: p_count => l_msg_count,
107: p_data => l_msg_data);
108: WHEN OTHERS THEN
109: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
110: IBE_Util.Debug('Unknown exception in IBE_QUOTE_MISC_PVT.Is_quote_usable');
111: END IF;
112: ROLLBACK TO is_quote_usable;
113: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
114: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2056: END IF;
2057:
2058: x_return_status := FND_API.G_RET_STS_SUCCESS;
2059:
2060: l_last_update_date :=IBE_Quote_Misc_pvt.getQuoteLastUpdatedate(p_quote_header_id);
2061: if (l_last_update_date <> p_last_update_date) then
2062: -- raise error
2063: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2064: FND_MESSAGE.Set_Name('IBE', 'IBE_SC_QUOTE_NEED_REFRESH');
2074: p_data => x_msg_data);
2075: EXCEPTION
2076: WHEN FND_API.G_EXC_ERROR THEN
2077: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2078: IBE_Util.Debug('Expected exception in IBE_QUOTE_MISC_PVT.ValidateQuotelastUpdateDate');
2079: END IF;
2080: ROLLBACK TO validateLastUpdate_pvt;
2081: x_return_status := FND_API.G_RET_STS_ERROR;
2082: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2084: p_data => x_msg_data);
2085:
2086: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2087: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2088: IBE_Util.Debug('Unexpected exception in IBE_QUOTE_MISC_PVT.ValidateQuotelastUpdateDate');
2089: END IF;
2090: ROLLBACK TO validateLastUpdate_pvt;
2091: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2092: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2095:
2096: WHEN OTHERS THEN
2097:
2098: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2099: IBE_Util.Debug('Unknown exception in IBE_QUOTE_MISC_PVT.ValidateQuotelastUpdateDate');
2100: END IF;
2101: ROLLBACK TO validateLastUpdate_pvt;
2102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2103: IF FND_MSG_PUB.Check_Msg_Level
2179: EXCEPTION
2180:
2181: WHEN FND_API.G_EXC_ERROR THEN
2182: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2183: IBE_Util.Debug('Expected exception in IBE_QUOTE_MISC_PVT.getQuoteOwner');
2184: END IF;
2185:
2186: ROLLBACK to getQuoteOwner_pvt;
2187: x_return_status := FND_API.G_RET_STS_ERROR;
2189: p_count => x_msg_count,
2190: p_data => x_msg_data);
2191: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2192: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2193: IBE_Util.Debug('uNExpected exception in IBE_QUOTE_MISC_PVT.getQuoteOwner');
2194: END IF;
2195: ROLLBACK to getQuoteOwner_pvt;
2196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2197: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2199: p_data => x_msg_data);
2200:
2201: WHEN OTHERS THEN
2202: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2203: IBE_Util.Debug('Unknown exception in IBE_QUOTE_MISC_PVT.getQuoteOwner');
2204: END IF;
2205: ROLLBACK to getQuoteOwner_pvt;
2206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2207: IF FND_MSG_PUB.Check_Msg_Level
2292: x_last_update_date := l_last_update_date;
2293: EXCEPTION
2294: WHEN FND_API.G_EXC_ERROR THEN
2295: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2296: IBE_Util.Debug('Expected exception in IBE_QUOTE_MISC_PVT.get_shared_quote');
2297: END IF;
2298: ROLLBACK to get_shared_quote;
2299: x_return_status := FND_API.G_RET_STS_ERROR;
2300: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2301: p_count => x_msg_count,
2302: p_data => x_msg_data);
2303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2304: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2305: IBE_Util.Debug('Unexpected exception in IBE_QUOTE_MISC_PVT.get_shared_quote');
2306: END IF;
2307: ROLLBACK to get_shared_quote;
2308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2309: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2310: p_count => x_msg_count,
2311: p_data => x_msg_data);
2312: WHEN OTHERS THEN
2313: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2314: IBE_Util.Debug('Unknown exception in IBE_QUOTE_MISC_PVT.get_shared_quote');
2315: END IF;
2316: ROLLBACK to get_shared_quote;
2317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2318: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2375: x_return_status := FND_API.G_RET_STS_SUCCESS;
2376:
2377: -- API body
2378: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2379: IBE_Util.Debug('IBE_Quote_Misc_pvt.Load_Item_IDs(+)...');
2380: END IF;
2381:
2382: l_count := p_cust_item_number_tbl.COUNT;
2383:
2515: x_return_status := FND_API.G_RET_STS_SUCCESS;
2516:
2517: -- API body
2518: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2519: IBE_Util.Debug('IBE_Quote_Misc_pvt.Check_Item_IDs(+)...');
2520: END IF;
2521:
2522: l_count := x_inventory_item_id_tbl.COUNT;
2523:
2633: and cust_account_id = c_account_id;
2634:
2635:
2636:
2637: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_Quote_Misc_pvt';
2638: l_api_name CONSTANT VARCHAR2(50) := 'Get_load_errors_pvt';
2639: l_api_version NUMBER := 1.0;
2640: -- these constants need to be kept in sync w/ Quote.java's static defines
2641: L_CART_LOAD_TYPE CONSTANT number := 0;
3016: p_data => x_msg_data);
3017: EXCEPTION
3018: WHEN FND_API.G_EXC_ERROR THEN
3019: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3020: IBE_UTIL.debug('Expected exception in IBE_QUOTE_MISC_PVT.get_load_errors');
3021: end if;
3022: ROLLBACK TO Get_load_errors_pvt;
3023: x_return_status := FND_API.G_RET_STS_ERROR;
3024: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
3025: p_count => x_msg_count ,
3026: p_data => x_msg_data);
3027: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3028: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3029: IBE_UTIL.debug('Unexpected exception in IBE_QUOTE_MISC_PVT.get_load_errors');
3030: end if;
3031: ROLLBACK TO Get_load_errors_pvt;
3032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3033: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
3034: p_count => x_msg_count ,
3035: p_data => x_msg_data);
3036: WHEN OTHERS THEN
3037: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3038: IBE_UTIL.debug('Unknown exception in IBE_QUOTE_MISC_PVT.get_load_errors');
3039: end if;
3040: ROLLBACK TO Get_load_errors_pvt;
3041: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3042: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
3197: -- Initialize API return status to success
3198: x_return_status := FND_API.G_RET_STS_SUCCESS;
3199:
3200: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3201: IBE_Util.Debug('IBE_Quote_Misc_pvt.Update_Config_Item_Lines(+)');
3202: END IF;
3203:
3204: -- API body
3205: FOR i IN 1..px_qte_line_dtl_tbl.COUNT LOOP
3253: END LOOP;
3254: -- End of API body.
3255:
3256: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3257: IBE_Util.Debug('IBE_Quote_Misc_pvt.Update_Config_Item_Lines(-)');
3258: END IF;
3259:
3260: -- Standard call to get message count and IF count is 1, get message info.
3261: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
3263: p_data => x_msg_data );
3264: EXCEPTION
3265: WHEN FND_API.G_EXC_ERROR THEN
3266: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3267: IBE_Util.Debug('Expected error IBE_Quote_Misc_pvt.Update_Config_Item_Lines');
3268: END IF;
3269: ROLLBACK to Update_config_item_lines;
3270: x_return_status := FND_API.G_RET_STS_ERROR;
3271: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
3272: p_count => x_msg_count,
3273: p_data => x_msg_data);
3274: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3275: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3276: IBE_Util.Debug('Unexpected error IBE_Quote_Misc_pvt.Update_Config_Item_Lines');
3277: END IF;
3278: ROLLBACK to Update_config_item_lines;
3279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3280: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
3281: p_count => x_msg_count,
3282: p_data => x_msg_data);
3283: WHEN OTHERS THEN
3284: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3285: IBE_Util.Debug('Unknown error IBE_Quote_Misc_pvt.Update_Config_Item_Lines');
3286: END IF;
3287: ROLLBACK to Update_config_item_lines;
3288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3289:
3346: l_count NUMBER;
3347: BEGIN
3348:
3349: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3350: IBE_UTIL.Debug('Start IBE_Quote_Misc_pvt.Get_Available_Services');
3351: IBE_UTIL.Debug(' Parms: [' || p_organization_id || ', ' ||
3352: p_product_item_id || ']');
3353: END IF;
3354:
3383: END IF;
3384: END IF;
3385:
3386: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3387: IBE_UTIL.Debug('End IBE_Quote_Misc_pvt.Get_Available_Services');
3388: END IF;
3389:
3390: END Get_Included_Warranties;
3391:
3407: l_count NUMBER;
3408: BEGIN
3409:
3410: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3411: IBE_UTIL.Debug('Start IBE_Quote_Misc_pvt.Get_Available_Services');
3412: IBE_UTIL.Debug(' Parms: [p_product_item_id=' || p_product_item_id || ', ' ||
3413: p_customer_id || ', ' || p_product_revision || ', ' ||
3414: p_request_date || ']');
3415: END IF;
3455: END LOOP;
3456: END IF;
3457:
3458: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3459: IBE_UTIL.Debug('End IBE_Quote_Misc_pvt.Get_Available_Services');
3460: END IF;
3461:
3462: END Get_Available_Services;
3463:
3531:
3532: l_initial_dtl_count := x_qte_line_dtl_tbl.COUNT + 1;
3533:
3534: l_initial_count := x_qte_line_tbl.COUNT + 1;
3535: x_qte_line_tbl(l_initial_count) := IBE_Quote_Misc_pvt.getLineRec(p_qte_line_id);
3536:
3537: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3538: IBE_UTIL.Debug(' Adding Lines From c_related_lines');
3539: END IF;
3540: FOR l_related_lines_rec IN c_related_lines(p_qte_line_id) LOOP
3541: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3542: IBE_UTIL.Debug(' Adding related_quote_line_id=' || l_related_lines_rec.related_quote_line_id);
3543: END IF;
3544: x_qte_line_tbl(x_qte_line_tbl.COUNT + 1) := IBE_Quote_Misc_pvt.getLineRec(l_related_lines_rec.related_quote_line_id);
3545: END LOOP;
3546:
3547:
3548: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3549: ibe_util.debug('line number is='|| x_qte_line_tbl.count);
3550: END IF;
3551: FOR i IN l_initial_count..x_qte_line_tbl.COUNT LOOP
3552:
3553: l_qte_line_dtl_tbl := IBE_Quote_Misc_pvt.getlineDetailTbl
3554: (x_qte_line_tbl(i).quote_line_id);
3555: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3556: IBE_UTIL.Debug(' Processing LineDetailTbl Count=' || l_qte_line_dtl_tbl.COUNT);
3557: END IF;
3569: := l_qte_line_dtl_tbl(j);
3570: END LOOP;
3571:
3572:
3573: l_line_rltship_tbl := IBE_Quote_Misc_pvt.getlineRelationshipTbl(x_qte_line_tbl(i).quote_line_id);
3574: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3575: IBE_UTIL.Debug(' Processing LineRelationshipTbl Count=' || l_line_rltship_tbl.COUNT);
3576: END IF;
3577:
3581: l_line_rltship_tbl(j).operation_code := 'CREATE';
3582:
3583: l_line_rltship_tbl(j).qte_line_index := i;
3584: l_line_rltship_tbl(j).related_qte_line_index
3585: := IBE_Quote_Misc_pvt.getLineIndexFromLineId
3586: ( l_line_rltship_tbl(j).related_quote_line_id
3587: ,x_qte_line_tbl
3588: );
3589: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3598:
3599: END LOOP;
3600:
3601:
3602: l_line_attr_ext_tbl := IBE_Quote_Misc_pvt.getLineAttrExtTbl
3603: (x_qte_line_tbl(i).quote_line_id);
3604: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3605: IBE_UTIL.Debug(' Processing LineAttrExtTbl Count=' || l_line_attr_ext_tbl.COUNT);
3606: END IF;
3614: x_line_attr_ext_tbl(x_line_attr_ext_tbl.count+1)
3615: := l_line_attr_ext_tbl(j);
3616: END LOOP;
3617:
3618: l_ln_price_attributes_tbl := IBE_Quote_Misc_pvt.getlinePrcAttrTbl
3619: (x_qte_line_tbl(i).quote_line_id);
3620: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3621: IBE_UTIL.Debug(' Processing linePrcAttrTbl Count=' || l_ln_price_attributes_tbl.COUNT);
3622: END IF;
3727: p_data => x_msg_data);
3728: EXCEPTION
3729: WHEN FND_API.G_EXC_ERROR THEN
3730: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3731: IBE_Util.Debug('Expected error IBE_Quote_Misc_pvt.Duplicate_line');
3732: END IF;
3733:
3734: ROLLBACK TO DUPLICATE_LINE_PVT;
3735: x_return_status := FND_API.G_RET_STS_ERROR;
3737: p_count => x_msg_count,
3738: p_data => x_msg_data);
3739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3740: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3741: IBE_Util.Debug('Expected error IBE_Quote_Misc_pvt.Duplicate_line');
3742: END IF;
3743:
3744: ROLLBACK TO DUPLICATE_LINE_PVT;
3745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3747: p_count => x_msg_count,
3748: p_data => x_msg_data);
3749: WHEN OTHERS THEN
3750: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3751: IBE_Util.Debug('unknown error IBE_Quote_Misc_pvt.Duplicate_line');
3752: END IF;
3753:
3754: ROLLBACK TO DUPLICATE_LINE_PVT;
3755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4030: IBE_UTIL.Debug('Validating User Starts: Also Pquantities is not null');
4031: END IF;
4032:
4033: /* -- 4587019
4034: l_last_update_date := IBE_Quote_Misc_pvt.getQuoteLastUpdatedate(p_quote_header_id);
4035:
4036: IF (l_last_update_date <> p_last_update_date) then
4037: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4038: IBE_UTIL.Debug('comparing dates');
4049: -- 4587019
4050: */
4051:
4052: -- User Authentication
4053: IBE_Quote_Misc_pvt.Validate_User_Update
4054: ( p_init_msg_list => p_init_msg_list
4055: ,p_quote_header_id => p_quote_header_id
4056: ,p_party_id => p_party_id
4057: ,p_cust_account_id => p_cust_account_id
4073: IBE_UTIL.Debug('Validating User Finishes');
4074: END IF;
4075:
4076: l_qte_header_rec.quote_header_id := p_quote_header_id;
4077: l_qte_header_rec.last_update_date := IBE_Quote_Misc_pvt.getQuoteLastUpdatedate(p_quote_header_id);
4078: l_qte_line_rec.quote_line_id := p_qte_line_id;
4079: l_qte_line_count := l_qte_line_tbl.COUNT;
4080:
4081: For counter in 1.. p_quantities.count loop
4118: IBE_UTIL.Debug('Split_quote_line: aso_split_line_int.split_quote_line:end');
4119: END IF;
4120: END IF;
4121: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4122: IBE_UTIL.Debug('IBE_Quote_Misc_pvt.Split_Line Ends');
4123: END IF;
4124: -- Standard check of p_commit.
4125: IF FND_API.To_Boolean( p_commit ) THEN
4126: COMMIT WORK;
4131: p_data => lx_msg_data);
4132: EXCEPTION
4133: WHEN FND_API.G_EXC_ERROR THEN
4134: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4135: IBE_Util.Debug('Unexpected error IBE_Quote_Misc_pvt.Split_line');
4136: END IF;
4137: ROLLBACK TO SPLIT_LINE_PVT;
4138: x_return_status := FND_API.G_RET_STS_ERROR;
4139: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
4140: p_count => lx_msg_count,
4141: p_data => lx_msg_data);
4142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4143: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4144: IBE_Util.Debug('Expected error IBE_Quote_Misc_pvt.Split_line');
4145: END IF;
4146: ROLLBACK TO SPLIT_LINE_PVT;
4147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4148: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
4149: p_count => lx_msg_count,
4150: p_data => lx_msg_data);
4151: WHEN OTHERS THEN
4152: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4153: IBE_Util.Debug('Unknown error IBE_Quote_Misc_pvt.Split_line');
4154: END IF;
4155: ROLLBACK TO SPLIT_LINE_PVT;
4156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4157: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4351: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
4352: p_count => x_msg_count ,
4353: p_data => x_msg_data);
4354: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4355: IBE_Util.Debug('End With Exp Exception IBE_Quote_Misc_pvt.validate_quote');
4356: END IF;
4357: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4358: ROLLBACK TO validate_quote;
4359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4360: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
4361: p_count => x_msg_count ,
4362: p_data => x_msg_data);
4363: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4364: IBE_Util.Debug('End with UnExp Exception IBE_Quote_Misc_pvt.validate_quote');
4365: END IF;
4366: WHEN OTHERS THEN
4367: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
4368: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
4371: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
4372: p_count => x_msg_count ,
4373: p_data => x_msg_data);
4374: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4375: IBE_Util.Debug('End with Others Exception IBE_Quote_Misc_pvt.validate_quote');
4376: END IF;
4377: END validate_quote;
4378:
4379: PROCEDURE Validate_User_Update(
4812: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
4813: p_count => x_msg_count ,
4814: p_data => x_msg_data);
4815: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4816: IBE_Util.Debug('End:Expected exception:IBE_Quote_Misc_pvt.validate_user_update');
4817: END IF;
4818: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4820: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
4820: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
4821: p_count => x_msg_count ,
4822: p_data => x_msg_data);
4823: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4824: IBE_Util.Debug('End:Unexpected exception:IBE_Quote_Misc_pvt.validate_user_update');
4825: END IF;
4826: WHEN OTHERS THEN
4827: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
4828: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
4831: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
4832: p_count => x_msg_count ,
4833: p_data => x_msg_data);
4834: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4835: IBE_Util.Debug('End:Others exception:IBE_Quote_Misc_pvt.validate_user_update');
4836: END IF;
4837: END validate_user_update;
4838:
4839: /*This procedure is used to save the missing party_id and cust_account_id
5195: l_seq_num VARCHAR2(30) := NULL;
5196:
5197: BEGIN
5198: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5199: IBE_Util.Debug('Begin IBE_Quote_Misc_pvt.Add_Attachment()');
5200: END IF;
5201:
5202: -- Standard Start of API savepoint
5203: SAVEPOINT Add_Attachment;
5223: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5224: IBE_Util.Debug('Call to Validate_User_Update');
5225: END IF;
5226:
5227: IBE_Quote_Misc_pvt.Validate_User_Update
5228: ( p_init_msg_list => p_Init_Msg_List
5229: ,p_quote_header_id => p_quote_header_id
5230: ,p_party_id => p_party_id
5231: ,p_cust_account_id => p_cust_account_id
5300: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5301: p_count => x_msg_count ,
5302: p_data => x_msg_data);
5303: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5304: IBE_Util.Debug('End IBE_Quote_Misc_pvt.Add_Attachment()');
5305: END IF;
5306:
5307: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5308: ROLLBACK TO Add_Attachment;
5311: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5312: p_count => x_msg_count ,
5313: p_data => x_msg_data);
5314: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5315: IBE_Util.Debug('End IBE_Quote_Misc_pvt.Add_Attachment()');
5316: END IF;
5317:
5318: WHEN OTHERS THEN
5319: ROLLBACK TO Add_Attachment;
5327: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5328: p_count => x_msg_count ,
5329: p_data => x_msg_data);
5330: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5331: IBE_Util.Debug('End IBE_Quote_Misc_pvt.Add_Attachment()');
5332: END IF;
5333:
5334: END Add_Attachment;
5335:
5354: l_api_version CONSTANT NUMBER := 1.0;
5355:
5356: BEGIN
5357: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5358: IBE_Util.Debug('Begin IBE_Quote_Misc_pvt.Delete_Attachment()');
5359: END IF;
5360:
5361: -- Standard Start of API savepoint
5362: SAVEPOINT Add_Attachment;
5382: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5383: IBE_Util.Debug('Call to Validate_User_Update');
5384: END IF;
5385:
5386: IBE_Quote_Misc_pvt.Validate_User_Update(
5387: p_quote_header_id => p_quote_header_id
5388: ,p_party_id => p_party_id
5389: ,p_cust_account_id => p_cust_account_id
5390: ,p_validate_user => FND_API.G_TRUE
5445: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5446: p_count => x_msg_count ,
5447: p_data => x_msg_data);
5448: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5449: IBE_Util.Debug('End IBE_Quote_Misc_pvt.Delete_Attachment()');
5450: END IF;
5451:
5452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5453: ROLLBACK TO Add_Attachment;
5456: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5457: p_count => x_msg_count ,
5458: p_data => x_msg_data);
5459: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5460: IBE_Util.Debug('End IBE_Quote_Misc_pvt.Delete_Attachment()');
5461: END IF;
5462:
5463: WHEN OTHERS THEN
5464: ROLLBACK TO Add_Attachment;
5472: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5473: p_count => x_msg_count ,
5474: p_data => x_msg_data);
5475: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5476: IBE_Util.Debug('End IBE_Quote_Misc_pvt.Delete_Attachment()');
5477: END IF;
5478:
5479: END Delete_Attachment;
5480:
5516: END IF;
5517:
5518: END get_primary_file_id;
5519:
5520: END IBE_Quote_Misc_pvt;