[Home] [Help]
1: PACKAGE BODY IBE_Quote_Misc_pvt AS
2: /* $Header: IBEVQMIB.pls 120.15 2007/10/10 07:25:29 scnagara 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:
2057: x_return_status := FND_API.G_RET_STS_SUCCESS;
2058:
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: and cust_account_id = c_account_id;
2516:
2517:
2518:
2519: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_Quote_Misc_pvt';
2520: l_api_name CONSTANT VARCHAR2(50) := 'Get_load_errors_pvt';
2521: l_api_version NUMBER := 1.0;
2522: -- these constants need to be kept in sync w/ Quote.java's static defines
2523: L_CART_LOAD_TYPE CONSTANT number := 0;
2898: p_data => x_msg_data);
2899: EXCEPTION
2900: WHEN FND_API.G_EXC_ERROR THEN
2901: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2902: IBE_UTIL.debug('Expected exception in IBE_QUOTE_MISC_PVT.get_load_errors');
2903: end if;
2904: ROLLBACK TO Get_load_errors_pvt;
2905: x_return_status := FND_API.G_RET_STS_ERROR;
2906: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2907: p_count => x_msg_count ,
2908: p_data => x_msg_data);
2909: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2910: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2911: IBE_UTIL.debug('Unexpected exception in IBE_QUOTE_MISC_PVT.get_load_errors');
2912: end if;
2913: ROLLBACK TO Get_load_errors_pvt;
2914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2915: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2916: p_count => x_msg_count ,
2917: p_data => x_msg_data);
2918: WHEN OTHERS THEN
2919: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2920: IBE_UTIL.debug('Unknown exception in IBE_QUOTE_MISC_PVT.get_load_errors');
2921: end if;
2922: ROLLBACK TO Get_load_errors_pvt;
2923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2924: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
3079: -- Initialize API return status to success
3080: x_return_status := FND_API.G_RET_STS_SUCCESS;
3081:
3082: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3083: IBE_Util.Debug('IBE_Quote_Misc_pvt.Update_Config_Item_Lines(+)');
3084: END IF;
3085:
3086: -- API body
3087: FOR i IN 1..px_qte_line_dtl_tbl.COUNT LOOP
3135: END LOOP;
3136: -- End of API body.
3137:
3138: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3139: IBE_Util.Debug('IBE_Quote_Misc_pvt.Update_Config_Item_Lines(-)');
3140: END IF;
3141:
3142: -- Standard call to get message count and IF count is 1, get message info.
3143: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
3145: p_data => x_msg_data );
3146: EXCEPTION
3147: WHEN FND_API.G_EXC_ERROR THEN
3148: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3149: IBE_Util.Debug('Expected error IBE_Quote_Misc_pvt.Update_Config_Item_Lines');
3150: END IF;
3151: ROLLBACK to Update_config_item_lines;
3152: x_return_status := FND_API.G_RET_STS_ERROR;
3153: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
3154: p_count => x_msg_count,
3155: p_data => x_msg_data);
3156: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3157: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3158: IBE_Util.Debug('Unexpected error IBE_Quote_Misc_pvt.Update_Config_Item_Lines');
3159: END IF;
3160: ROLLBACK to Update_config_item_lines;
3161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3162: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
3163: p_count => x_msg_count,
3164: p_data => x_msg_data);
3165: WHEN OTHERS THEN
3166: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3167: IBE_Util.Debug('Unknown error IBE_Quote_Misc_pvt.Update_Config_Item_Lines');
3168: END IF;
3169: ROLLBACK to Update_config_item_lines;
3170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3171:
3228: l_count NUMBER;
3229: BEGIN
3230:
3231: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3232: IBE_UTIL.Debug('Start IBE_Quote_Misc_pvt.Get_Available_Services');
3233: IBE_UTIL.Debug(' Parms: [' || p_organization_id || ', ' ||
3234: p_product_item_id || ']');
3235: END IF;
3236:
3265: END IF;
3266: END IF;
3267:
3268: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3269: IBE_UTIL.Debug('End IBE_Quote_Misc_pvt.Get_Available_Services');
3270: END IF;
3271:
3272: END Get_Included_Warranties;
3273:
3289: l_count NUMBER;
3290: BEGIN
3291:
3292: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3293: IBE_UTIL.Debug('Start IBE_Quote_Misc_pvt.Get_Available_Services');
3294: IBE_UTIL.Debug(' Parms: [p_product_item_id=' || p_product_item_id || ', ' ||
3295: p_customer_id || ', ' || p_product_revision || ', ' ||
3296: p_request_date || ']');
3297: END IF;
3337: END LOOP;
3338: END IF;
3339:
3340: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3341: IBE_UTIL.Debug('End IBE_Quote_Misc_pvt.Get_Available_Services');
3342: END IF;
3343:
3344: END Get_Available_Services;
3345:
3413:
3414: l_initial_dtl_count := x_qte_line_dtl_tbl.COUNT + 1;
3415:
3416: l_initial_count := x_qte_line_tbl.COUNT + 1;
3417: x_qte_line_tbl(l_initial_count) := IBE_Quote_Misc_pvt.getLineRec(p_qte_line_id);
3418:
3419: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3420: IBE_UTIL.Debug(' Adding Lines From c_related_lines');
3421: END IF;
3422: FOR l_related_lines_rec IN c_related_lines(p_qte_line_id) LOOP
3423: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3424: IBE_UTIL.Debug(' Adding related_quote_line_id=' || l_related_lines_rec.related_quote_line_id);
3425: END IF;
3426: x_qte_line_tbl(x_qte_line_tbl.COUNT + 1) := IBE_Quote_Misc_pvt.getLineRec(l_related_lines_rec.related_quote_line_id);
3427: END LOOP;
3428:
3429:
3430: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3431: ibe_util.debug('line number is='|| x_qte_line_tbl.count);
3432: END IF;
3433: FOR i IN l_initial_count..x_qte_line_tbl.COUNT LOOP
3434:
3435: l_qte_line_dtl_tbl := IBE_Quote_Misc_pvt.getlineDetailTbl
3436: (x_qte_line_tbl(i).quote_line_id);
3437: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3438: IBE_UTIL.Debug(' Processing LineDetailTbl Count=' || l_qte_line_dtl_tbl.COUNT);
3439: END IF;
3451: := l_qte_line_dtl_tbl(j);
3452: END LOOP;
3453:
3454:
3455: l_line_rltship_tbl := IBE_Quote_Misc_pvt.getlineRelationshipTbl(x_qte_line_tbl(i).quote_line_id);
3456: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3457: IBE_UTIL.Debug(' Processing LineRelationshipTbl Count=' || l_line_rltship_tbl.COUNT);
3458: END IF;
3459:
3463: l_line_rltship_tbl(j).operation_code := 'CREATE';
3464:
3465: l_line_rltship_tbl(j).qte_line_index := i;
3466: l_line_rltship_tbl(j).related_qte_line_index
3467: := IBE_Quote_Misc_pvt.getLineIndexFromLineId
3468: ( l_line_rltship_tbl(j).related_quote_line_id
3469: ,x_qte_line_tbl
3470: );
3471: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3480:
3481: END LOOP;
3482:
3483:
3484: l_line_attr_ext_tbl := IBE_Quote_Misc_pvt.getLineAttrExtTbl
3485: (x_qte_line_tbl(i).quote_line_id);
3486: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3487: IBE_UTIL.Debug(' Processing LineAttrExtTbl Count=' || l_line_attr_ext_tbl.COUNT);
3488: END IF;
3496: x_line_attr_ext_tbl(x_line_attr_ext_tbl.count+1)
3497: := l_line_attr_ext_tbl(j);
3498: END LOOP;
3499:
3500: l_ln_price_attributes_tbl := IBE_Quote_Misc_pvt.getlinePrcAttrTbl
3501: (x_qte_line_tbl(i).quote_line_id);
3502: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3503: IBE_UTIL.Debug(' Processing linePrcAttrTbl Count=' || l_ln_price_attributes_tbl.COUNT);
3504: END IF;
3609: p_data => x_msg_data);
3610: EXCEPTION
3611: WHEN FND_API.G_EXC_ERROR THEN
3612: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3613: IBE_Util.Debug('Expected error IBE_Quote_Misc_pvt.Duplicate_line');
3614: END IF;
3615:
3616: ROLLBACK TO DUPLICATE_LINE_PVT;
3617: x_return_status := FND_API.G_RET_STS_ERROR;
3619: p_count => x_msg_count,
3620: p_data => x_msg_data);
3621: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3622: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3623: IBE_Util.Debug('Expected error IBE_Quote_Misc_pvt.Duplicate_line');
3624: END IF;
3625:
3626: ROLLBACK TO DUPLICATE_LINE_PVT;
3627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3629: p_count => x_msg_count,
3630: p_data => x_msg_data);
3631: WHEN OTHERS THEN
3632: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3633: IBE_Util.Debug('unknown error IBE_Quote_Misc_pvt.Duplicate_line');
3634: END IF;
3635:
3636: ROLLBACK TO DUPLICATE_LINE_PVT;
3637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3912: IBE_UTIL.Debug('Validating User Starts: Also Pquantities is not null');
3913: END IF;
3914:
3915: /* -- 4587019
3916: l_last_update_date := IBE_Quote_Misc_pvt.getQuoteLastUpdatedate(p_quote_header_id);
3917:
3918: IF (l_last_update_date <> p_last_update_date) then
3919: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3920: IBE_UTIL.Debug('comparing dates');
3931: -- 4587019
3932: */
3933:
3934: -- User Authentication
3935: IBE_Quote_Misc_pvt.Validate_User_Update
3936: ( p_init_msg_list => p_init_msg_list
3937: ,p_quote_header_id => p_quote_header_id
3938: ,p_party_id => p_party_id
3939: ,p_cust_account_id => p_cust_account_id
3955: IBE_UTIL.Debug('Validating User Finishes');
3956: END IF;
3957:
3958: l_qte_header_rec.quote_header_id := p_quote_header_id;
3959: l_qte_header_rec.last_update_date := IBE_Quote_Misc_pvt.getQuoteLastUpdatedate(p_quote_header_id);
3960: l_qte_line_rec.quote_line_id := p_qte_line_id;
3961: l_qte_line_count := l_qte_line_tbl.COUNT;
3962:
3963: For counter in 1.. p_quantities.count loop
4000: IBE_UTIL.Debug('Split_quote_line: aso_split_line_int.split_quote_line:end');
4001: END IF;
4002: END IF;
4003: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4004: IBE_UTIL.Debug('IBE_Quote_Misc_pvt.Split_Line Ends');
4005: END IF;
4006: -- Standard check of p_commit.
4007: IF FND_API.To_Boolean( p_commit ) THEN
4008: COMMIT WORK;
4013: p_data => lx_msg_data);
4014: EXCEPTION
4015: WHEN FND_API.G_EXC_ERROR THEN
4016: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4017: IBE_Util.Debug('Unexpected error IBE_Quote_Misc_pvt.Split_line');
4018: END IF;
4019: ROLLBACK TO SPLIT_LINE_PVT;
4020: x_return_status := FND_API.G_RET_STS_ERROR;
4021: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
4022: p_count => lx_msg_count,
4023: p_data => lx_msg_data);
4024: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4025: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4026: IBE_Util.Debug('Expected error IBE_Quote_Misc_pvt.Split_line');
4027: END IF;
4028: ROLLBACK TO SPLIT_LINE_PVT;
4029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4030: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
4031: p_count => lx_msg_count,
4032: p_data => lx_msg_data);
4033: WHEN OTHERS THEN
4034: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4035: IBE_Util.Debug('Unknown error IBE_Quote_Misc_pvt.Split_line');
4036: END IF;
4037: ROLLBACK TO SPLIT_LINE_PVT;
4038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4039: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4233: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
4234: p_count => x_msg_count ,
4235: p_data => x_msg_data);
4236: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4237: IBE_Util.Debug('End With Exp Exception IBE_Quote_Misc_pvt.validate_quote');
4238: END IF;
4239: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4240: ROLLBACK TO validate_quote;
4241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4242: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
4243: p_count => x_msg_count ,
4244: p_data => x_msg_data);
4245: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4246: IBE_Util.Debug('End with UnExp Exception IBE_Quote_Misc_pvt.validate_quote');
4247: END IF;
4248: WHEN OTHERS THEN
4249: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
4250: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
4253: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
4254: p_count => x_msg_count ,
4255: p_data => x_msg_data);
4256: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4257: IBE_Util.Debug('End with Others Exception IBE_Quote_Misc_pvt.validate_quote');
4258: END IF;
4259: END validate_quote;
4260:
4261: PROCEDURE Validate_User_Update(
4670: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
4671: p_count => x_msg_count ,
4672: p_data => x_msg_data);
4673: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4674: IBE_Util.Debug('End:Expected exception:IBE_Quote_Misc_pvt.validate_user_update');
4675: END IF;
4676: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4677: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4678: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
4678: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
4679: p_count => x_msg_count ,
4680: p_data => x_msg_data);
4681: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4682: IBE_Util.Debug('End:Unexpected exception:IBE_Quote_Misc_pvt.validate_user_update');
4683: END IF;
4684: WHEN OTHERS THEN
4685: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
4686: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
4689: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
4690: p_count => x_msg_count ,
4691: p_data => x_msg_data);
4692: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4693: IBE_Util.Debug('End:Others exception:IBE_Quote_Misc_pvt.validate_user_update');
4694: END IF;
4695: END validate_user_update;
4696:
4697: /*This procedure is used to save the missing party_id and cust_account_id
5053: l_seq_num VARCHAR2(30) := NULL;
5054:
5055: BEGIN
5056: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5057: IBE_Util.Debug('Begin IBE_Quote_Misc_pvt.Add_Attachment()');
5058: END IF;
5059:
5060: -- Standard Start of API savepoint
5061: SAVEPOINT Add_Attachment;
5081: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5082: IBE_Util.Debug('Call to Validate_User_Update');
5083: END IF;
5084:
5085: IBE_Quote_Misc_pvt.Validate_User_Update
5086: ( p_init_msg_list => p_Init_Msg_List
5087: ,p_quote_header_id => p_quote_header_id
5088: ,p_party_id => p_party_id
5089: ,p_cust_account_id => p_cust_account_id
5158: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5159: p_count => x_msg_count ,
5160: p_data => x_msg_data);
5161: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5162: IBE_Util.Debug('End IBE_Quote_Misc_pvt.Add_Attachment()');
5163: END IF;
5164:
5165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5166: ROLLBACK TO Add_Attachment;
5169: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5170: p_count => x_msg_count ,
5171: p_data => x_msg_data);
5172: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5173: IBE_Util.Debug('End IBE_Quote_Misc_pvt.Add_Attachment()');
5174: END IF;
5175:
5176: WHEN OTHERS THEN
5177: ROLLBACK TO Add_Attachment;
5185: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5186: p_count => x_msg_count ,
5187: p_data => x_msg_data);
5188: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5189: IBE_Util.Debug('End IBE_Quote_Misc_pvt.Add_Attachment()');
5190: END IF;
5191:
5192: END Add_Attachment;
5193:
5212: l_api_version CONSTANT NUMBER := 1.0;
5213:
5214: BEGIN
5215: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5216: IBE_Util.Debug('Begin IBE_Quote_Misc_pvt.Delete_Attachment()');
5217: END IF;
5218:
5219: -- Standard Start of API savepoint
5220: SAVEPOINT Add_Attachment;
5240: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5241: IBE_Util.Debug('Call to Validate_User_Update');
5242: END IF;
5243:
5244: IBE_Quote_Misc_pvt.Validate_User_Update(
5245: p_quote_header_id => p_quote_header_id
5246: ,p_party_id => p_party_id
5247: ,p_cust_account_id => p_cust_account_id
5248: ,p_validate_user => FND_API.G_TRUE
5303: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5304: p_count => x_msg_count ,
5305: p_data => x_msg_data);
5306: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5307: IBE_Util.Debug('End IBE_Quote_Misc_pvt.Delete_Attachment()');
5308: END IF;
5309:
5310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5311: ROLLBACK TO Add_Attachment;
5314: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5315: p_count => x_msg_count ,
5316: p_data => x_msg_data);
5317: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5318: IBE_Util.Debug('End IBE_Quote_Misc_pvt.Delete_Attachment()');
5319: END IF;
5320:
5321: WHEN OTHERS THEN
5322: ROLLBACK TO Add_Attachment;
5330: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5331: p_count => x_msg_count ,
5332: p_data => x_msg_data);
5333: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5334: IBE_Util.Debug('End IBE_Quote_Misc_pvt.Delete_Attachment()');
5335: END IF;
5336:
5337: END Delete_Attachment;
5338:
5374: END IF;
5375:
5376: END get_primary_file_id;
5377:
5378: END IBE_Quote_Misc_pvt;