APPS.IBE_QUOTE_MISC_PVT dependencies on FND_MSG_PUB

Line 96: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

92: END IF;
93:
94: ROLLBACK TO is_quote_usable;
95: l_return_status := FND_API.G_RET_STS_ERROR;
96: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
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

Line 105: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

Line 114: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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)
115: THEN
116: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
117: l_api_name);
118: END IF;

Line 116: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

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)
115: THEN
116: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
117: l_api_name);
118: END IF;
119: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
120: p_count => l_msg_count,

Line 119: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

115: THEN
116: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
117: l_api_name);
118: END IF;
119: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
120: p_count => l_msg_count,
121: p_data => l_msg_data);
122:
123: END ;

Line 2063: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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');
2065: FND_MSG_PUB.ADD;
2066: END IF;
2067: RAISE FND_API.G_EXC_ERROR; -- need error message

Line 2065: FND_MSG_PUB.ADD;

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');
2065: FND_MSG_PUB.ADD;
2066: END IF;
2067: RAISE FND_API.G_EXC_ERROR; -- need error message
2068: end if;
2069:

Line 2072: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2068: end if;
2069:
2070: -- Standard call to get message count and if count is 1, get message info.
2071:
2072: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2073: p_count => x_msg_count,
2074: p_data => x_msg_data);
2075: EXCEPTION
2076: WHEN FND_API.G_EXC_ERROR THEN

Line 2082: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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,
2083: p_count => x_msg_count,
2084: p_data => x_msg_data);
2085:
2086: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2092: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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,
2093: p_count => x_msg_count,
2094: p_data => x_msg_data);
2095:
2096: WHEN OTHERS THEN

Line 2103: IF FND_MSG_PUB.Check_Msg_Level

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
2104: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2105: THEN
2106: FND_MSG_PUB.Add_Exc_Msg
2107: ( G_PKG_NAME,

Line 2104: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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
2104: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2105: THEN
2106: FND_MSG_PUB.Add_Exc_Msg
2107: ( G_PKG_NAME,
2108: l_api_name

Line 2106: FND_MSG_PUB.Add_Exc_Msg

2102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2103: IF FND_MSG_PUB.Check_Msg_Level
2104: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2105: THEN
2106: FND_MSG_PUB.Add_Exc_Msg
2107: ( G_PKG_NAME,
2108: l_api_name
2109: );
2110: END IF;

Line 2111: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2107: ( G_PKG_NAME,
2108: l_api_name
2109: );
2110: END IF;
2111: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2112: p_count => x_msg_count,
2113: p_data => x_msg_data);
2114: END validateQuoteLastUpdateDate;
2115:

Line 2161: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2157: close getuserinfo;
2158:
2159: IF (l_party_id = FND_API.G_MISS_NUM OR l_party_id IS NULL
2160: OR l_cust_account_id = FND_API.G_MISS_NUM OR l_cust_account_id IS NULL) THEN
2161: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2162: FND_MESSAGE.Set_Name('IBE', 'IBE_SC_NO_QUOTE_OWNER');
2163: FND_MSG_PUB.ADD;
2164: END IF;
2165: RAISE FND_API.G_EXC_ERROR;

Line 2163: FND_MSG_PUB.ADD;

2159: IF (l_party_id = FND_API.G_MISS_NUM OR l_party_id IS NULL
2160: OR l_cust_account_id = FND_API.G_MISS_NUM OR l_cust_account_id IS NULL) THEN
2161: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2162: FND_MESSAGE.Set_Name('IBE', 'IBE_SC_NO_QUOTE_OWNER');
2163: FND_MSG_PUB.ADD;
2164: END IF;
2165: RAISE FND_API.G_EXC_ERROR;
2166: END IF;
2167: -- End of API body.

Line 2171: FND_MSG_PUB.Count_And_Get

2167: -- End of API body.
2168: x_party_id := l_party_id;
2169: x_cust_account_id := l_cust_account_id;
2170: -- Standard call to get message count and if count is 1, get message info.
2171: FND_MSG_PUB.Count_And_Get
2172: ( p_encoded => FND_API.G_FALSE,
2173: p_count => x_msg_count,
2174: p_data => x_msg_data
2175: );

Line 2188: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2184: END IF;
2185:
2186: ROLLBACK to getQuoteOwner_pvt;
2187: x_return_status := FND_API.G_RET_STS_ERROR;
2188: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
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

Line 2197: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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,
2198: p_count => x_msg_count,
2199: p_data => x_msg_data);
2200:
2201: WHEN OTHERS THEN

Line 2207: IF FND_MSG_PUB.Check_Msg_Level

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
2208: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2209: THEN
2210: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2211: l_api_name);

Line 2208: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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
2208: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2209: THEN
2210: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2211: l_api_name);
2212: END IF;

Line 2210: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

2206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2207: IF FND_MSG_PUB.Check_Msg_Level
2208: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2209: THEN
2210: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2211: l_api_name);
2212: END IF;
2213: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2214: p_count => x_msg_count,

Line 2213: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2209: THEN
2210: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2211: l_api_name);
2212: END IF;
2213: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2214: p_count => x_msg_count,
2215: p_data => x_msg_data);
2216:
2217: END getQuoteOwner;

Line 2283: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2279: END IF;
2280:
2281: IF l_quote_header_id IS NULL
2282: OR l_quote_header_id = FND_API.G_MISS_NUM THEN
2283: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2284: FND_MESSAGE.Set_Name('IBE', 'IBE_SC_NO_SHARE_QUOTE');
2285: FND_MSG_PUB.ADD;
2286: END IF;
2287:

Line 2285: FND_MSG_PUB.ADD;

2281: IF l_quote_header_id IS NULL
2282: OR l_quote_header_id = FND_API.G_MISS_NUM THEN
2283: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2284: FND_MESSAGE.Set_Name('IBE', 'IBE_SC_NO_SHARE_QUOTE');
2285: FND_MSG_PUB.ADD;
2286: END IF;
2287:
2288: RAISE FND_API.G_EXC_ERROR;
2289: END IF;

Line 2300: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

Line 2309: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

Line 2318: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) 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
2319: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
2320: l_api_name);
2321: END IF;
2322:

Line 2319: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

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
2319: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
2320: l_api_name);
2321: END IF;
2322:
2323: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 2323: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2319: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
2320: l_api_name);
2321: END IF;
2322:
2323: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2324: p_count => x_msg_count,
2325: p_data => x_msg_data);
2326: END Get_Shared_Quote;
2327:

Line 2371: FND_MSG_PUB.initialize;

2367: END IF;
2368:
2369: -- Initialize message list if p_init_msg_list is set to TRUE
2370: IF FND_API.to_Boolean(p_init_msg_list) THEN
2371: FND_MSG_PUB.initialize;
2372: END IF;
2373:
2374: -- Initialize API return status to success
2375: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2406: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2402: );
2403:
2404: IF l_error_flag = 'Y' THEN
2405: --inv_debug.message('ssia', 'got error from inv_customer_item_grp');
2406: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2407: FND_Message.Set_Name('IBE', 'IBE_SC_INV_CUSTOM_ITEM_ERROR');
2408: FND_Message.Set_Token('INVMSG', l_error_message);
2409: FND_MSG_PUB.Add;
2410: END IF;

Line 2409: FND_MSG_PUB.Add;

2405: --inv_debug.message('ssia', 'got error from inv_customer_item_grp');
2406: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2407: FND_Message.Set_Name('IBE', 'IBE_SC_INV_CUSTOM_ITEM_ERROR');
2408: FND_Message.Set_Token('INVMSG', l_error_message);
2409: FND_MSG_PUB.Add;
2410: END IF;
2411: END IF;
2412:
2413:

Line 2439: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2435: END LOOP;
2436:
2437:
2438: -- Standard call to get message count and if count is 1, get message info.
2439: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2440: p_count => x_msg_count,
2441: p_data => x_msg_data);
2442: --inv_debug.message('ssia', 'x_msg_count is ' || x_msg_count);
2443: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 2449: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2445: END IF;
2446: EXCEPTION
2447: WHEN FND_API.G_EXC_ERROR THEN
2448: x_return_status := FND_API.G_RET_STS_ERROR;
2449: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2450: p_count => x_msg_count,
2451: p_data => x_msg_data);
2452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2454: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2450: p_count => x_msg_count,
2451: p_data => x_msg_data);
2452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2454: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2455: p_count => x_msg_count,
2456: p_data => x_msg_data);
2457: WHEN OTHERS THEN
2458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2459: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2455: p_count => x_msg_count,
2456: p_data => x_msg_data);
2457: WHEN OTHERS THEN
2458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2459: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2460: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
2461: l_api_name);
2462: END IF;
2463:

Line 2460: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

2456: p_data => x_msg_data);
2457: WHEN OTHERS THEN
2458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2459: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2460: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
2461: l_api_name);
2462: END IF;
2463:
2464: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 2464: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2460: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
2461: l_api_name);
2462: END IF;
2463:
2464: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2465: p_count => x_msg_count,
2466: p_data => x_msg_data);
2467:
2468: END Load_Item_IDs;

Line 2511: FND_MSG_PUB.initialize;

2507: END IF;
2508:
2509: -- Initialize message list if p_init_msg_list is set to TRUE
2510: IF FND_API.to_Boolean(p_init_msg_list) THEN
2511: FND_MSG_PUB.initialize;
2512: END IF;
2513:
2514: -- Initialize API return status to success
2515: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2559: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2555: END LOOP;
2556:
2557:
2558: -- Standard call to get message count and if count is 1, get message info.
2559: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2560: p_count => x_msg_count,
2561: p_data => x_msg_data);
2562: --inv_debug.message('ssia', 'x_msg_count is ' || x_msg_count);
2563: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 2569: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2565: END IF;
2566: EXCEPTION
2567: WHEN FND_API.G_EXC_ERROR THEN
2568: x_return_status := FND_API.G_RET_STS_ERROR;
2569: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2570: p_count => x_msg_count,
2571: p_data => x_msg_data);
2572: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2574: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2570: p_count => x_msg_count,
2571: p_data => x_msg_data);
2572: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2574: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2575: p_count => x_msg_count,
2576: p_data => x_msg_data);
2577: WHEN OTHERS THEN
2578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2579: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2575: p_count => x_msg_count,
2576: p_data => x_msg_data);
2577: WHEN OTHERS THEN
2578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2579: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2580: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
2581: l_api_name);
2582: END IF;
2583:

Line 2580: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

2576: p_data => x_msg_data);
2577: WHEN OTHERS THEN
2578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2579: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2580: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
2581: l_api_name);
2582: END IF;
2583:
2584: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 2584: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2580: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
2581: l_api_name);
2582: END IF;
2583:
2584: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2585: p_count => x_msg_count,
2586: p_data => x_msg_data);
2587:
2588: END Check_Item_IDs;

Line 2694: FND_Msg_Pub.initialize;

2690: END IF;
2691:
2692: -- Initialize message list if p_init_msg_list is set to TRUE.
2693: IF FND_API.To_Boolean(p_init_msg_list) THEN
2694: FND_Msg_Pub.initialize;
2695: END IF;
2696:
2697: -- Initialize API return status to success
2698: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3014: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

3010: COMMIT WORK;
3011: END IF;
3012:
3013: -- Standard call to get message count and if count is 1, get message info.
3014: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
3015: p_count => x_msg_count ,
3016: p_data => x_msg_data);
3017: EXCEPTION
3018: WHEN FND_API.G_EXC_ERROR THEN

Line 3024: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

Line 3033: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

Line 3042: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) 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
3043: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
3044: L_API_NAME);
3045: END IF;
3046:

Line 3043: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

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
3043: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
3044: L_API_NAME);
3045: END IF;
3046:
3047: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 3047: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

3043: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
3044: L_API_NAME);
3045: END IF;
3046:
3047: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
3048: p_count => x_msg_count ,
3049: p_data => x_msg_data);
3050:
3051: End get_load_errors;

Line 3103: FND_MSG_PUB.initialize;

3099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3100: END IF;
3101: -- Initialize message list if p_init_msg_list is set to TRUE.
3102: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3103: FND_MSG_PUB.initialize;
3104: END IF;
3105: -- Initialize API return status to success
3106: x_return_status := FND_API.G_RET_STS_SUCCESS;
3107: -- API body

Line 3125: FND_MSG_PUB.Count_And_Get

3121: x_cartHeaderId := l_cartHeaderId;
3122: end if;
3123:
3124: -- Standard call to get message count and if count is 1, get message info.
3125: FND_MSG_PUB.Count_And_Get
3126: (p_count => x_msg_count,
3127: p_data => x_msg_data
3128: );
3129:

Line 3137: FND_MSG_PUB.add;

3133: --ibe_util.debug('TOO_MANY_ROWS');
3134: ROLLBACK TO GETACTIVECARTID_pvt;
3135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3136: FND_MESSAGE.set_name('IBE','IBE_SC_GETACTIVEC_MANY');
3137: FND_MSG_PUB.add;
3138: FND_MSG_PUB.Count_And_Get
3139: ( p_count => x_msg_count,
3140: p_data => x_msg_data
3141: );

Line 3138: FND_MSG_PUB.Count_And_Get

3134: ROLLBACK TO GETACTIVECARTID_pvt;
3135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3136: FND_MESSAGE.set_name('IBE','IBE_SC_GETACTIVEC_MANY');
3137: FND_MSG_PUB.add;
3138: FND_MSG_PUB.Count_And_Get
3139: ( p_count => x_msg_count,
3140: p_data => x_msg_data
3141: );
3142: WHEN NO_DATA_FOUND then

Line 3149: FND_MSG_PUB.Count_And_Get

3145:
3146: WHEN FND_API.G_EXC_ERROR THEN
3147: ROLLBACK TO GETACTIVECARTID_pvt;
3148: x_return_status := FND_API.G_RET_STS_ERROR;
3149: FND_MSG_PUB.Count_And_Get
3150: ( p_count => x_msg_count,
3151: p_data => x_msg_data
3152: );
3153: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3156: FND_MSG_PUB.Count_And_Get

3152: );
3153: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3154: ROLLBACK TO GETACTIVECARTID_pvt;
3155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3156: FND_MSG_PUB.Count_And_Get
3157: ( p_count => x_msg_count,
3158: p_data => x_msg_data
3159: );
3160: WHEN OTHERS THEN

Line 3163: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3159: );
3160: WHEN OTHERS THEN
3161: ROLLBACK TO GETACTIVECARTID_pvt;
3162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3163: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3164: FND_MSG_PUB.Add_Exc_Msg
3165: ( G_PKG_NAME,
3166: l_api_name);
3167: END IF;

Line 3164: FND_MSG_PUB.Add_Exc_Msg

3160: WHEN OTHERS THEN
3161: ROLLBACK TO GETACTIVECARTID_pvt;
3162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3163: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3164: FND_MSG_PUB.Add_Exc_Msg
3165: ( G_PKG_NAME,
3166: l_api_name);
3167: END IF;
3168: FND_MSG_PUB.Count_And_Get

Line 3168: FND_MSG_PUB.Count_And_Get

3164: FND_MSG_PUB.Add_Exc_Msg
3165: ( G_PKG_NAME,
3166: l_api_name);
3167: END IF;
3168: FND_MSG_PUB.Count_And_Get
3169: ( p_count => x_msg_count,
3170: p_data => x_msg_data
3171: );
3172:

Line 3261: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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,
3262: p_count => x_msg_count ,
3263: p_data => x_msg_data );
3264: EXCEPTION
3265: WHEN FND_API.G_EXC_ERROR THEN

Line 3271: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

Line 3280: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

Line 3290: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3286: END IF;
3287: ROLLBACK to Update_config_item_lines;
3288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3289:
3290: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3291: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
3292: l_api_name);
3293: END IF;
3294:

Line 3291: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

3287: ROLLBACK to Update_config_item_lines;
3288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3289:
3290: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3291: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
3292: l_api_name);
3293: END IF;
3294:
3295: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 3295: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

3291: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
3292: l_api_name);
3293: END IF;
3294:
3295: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
3296: p_count => x_msg_count,
3297: p_data => x_msg_data);
3298: END Update_Config_Item_Lines;
3299:

Line 3526: FND_MSG_PUB.initialize;

3522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3523: END IF;
3524: -- Initialize message list IF p_init_msg_list is set to TRUE.
3525: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3526: FND_MSG_PUB.initialize;
3527: END IF;
3528:
3529: -- Initialize API return status to success
3530: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3725: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

3721: COMMIT WORK;
3722: END IF;
3723:
3724: -- Standard call to get message count and IF count is 1, get message info.
3725: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
3726: p_count => x_msg_count,
3727: p_data => x_msg_data);
3728: EXCEPTION
3729: WHEN FND_API.G_EXC_ERROR THEN

Line 3736: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

3732: END IF;
3733:
3734: ROLLBACK TO DUPLICATE_LINE_PVT;
3735: x_return_status := FND_API.G_RET_STS_ERROR;
3736: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
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

Line 3746: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

3742: END IF;
3743:
3744: ROLLBACK TO DUPLICATE_LINE_PVT;
3745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3746: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
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

Line 3757: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3753:
3754: ROLLBACK TO DUPLICATE_LINE_PVT;
3755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3756:
3757: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3758: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
3759: l_api_name);
3760: END IF;
3761:

Line 3758: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

3754: ROLLBACK TO DUPLICATE_LINE_PVT;
3755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3756:
3757: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3758: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
3759: l_api_name);
3760: END IF;
3761:
3762: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 3762: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

3758: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
3759: l_api_name);
3760: END IF;
3761:
3762: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
3763: p_count => x_msg_count,
3764: p_data => x_msg_data);
3765: END Duplicate_Line;
3766:

Line 4021: FND_MSG_PUB.initialize;

4017: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4018: END IF;
4019: -- Initialize message list IF p_init_msg_list is set to TRUE.
4020: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4021: FND_MSG_PUB.initialize;
4022: END IF;
4023: -- Initialize API return status to success
4024: x_return_status := FND_API.G_RET_STS_SUCCESS;
4025:

Line 4043: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

4039: END IF;
4040: p_last_update_date := l_last_update_date;
4041: -- raise error
4042:
4043: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4044: FND_MESSAGE.Set_Name('IBE', 'IBE_SC_QUOTE_NEED_REFRESH');
4045: FND_MSG_PUB.ADD;
4046: END IF;
4047: RAISE FND_API.G_EXC_ERROR; -- need error message

Line 4045: FND_MSG_PUB.ADD;

4041: -- raise error
4042:
4043: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4044: FND_MESSAGE.Set_Name('IBE', 'IBE_SC_QUOTE_NEED_REFRESH');
4045: FND_MSG_PUB.ADD;
4046: END IF;
4047: RAISE FND_API.G_EXC_ERROR; -- need error message
4048: END IF;
4049: -- 4587019

Line 4129: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

4125: IF FND_API.To_Boolean( p_commit ) THEN
4126: COMMIT WORK;
4127: END IF;
4128: -- Standard call to get message count and IF count is 1, get message info.
4129: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
4130: p_count => lx_msg_count,
4131: p_data => lx_msg_data);
4132: EXCEPTION
4133: WHEN FND_API.G_EXC_ERROR THEN

Line 4139: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

Line 4148: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

Line 4157: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) 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
4158: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
4159: l_api_name);
4160: END IF;
4161: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 4158: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

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
4158: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
4159: l_api_name);
4160: END IF;
4161: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
4162: p_count => lx_msg_count,

Line 4161: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

4157: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4158: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
4159: l_api_name);
4160: END IF;
4161: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
4162: p_count => lx_msg_count,
4163: p_data => lx_msg_data);
4164: END Split_Line;
4165:

Line 4236: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN

4232: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4233: IBE_UTIL.DEBUG('Validate_quote, quote is unpublished' || to_char(sysdate, 'mm/dd/yyyy:hh24:MI:SS'));
4234: END IF;
4235:
4236: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4237: FND_Message.Set_Name('IBE', 'IBE_SC_QUOTE_NOT_PUBL');
4238: FND_Msg_Pub.Add;
4239: END IF;
4240: l_error := FND_API.G_TRUE;

Line 4238: FND_Msg_Pub.Add;

4234: END IF;
4235:
4236: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4237: FND_Message.Set_Name('IBE', 'IBE_SC_QUOTE_NOT_PUBL');
4238: FND_Msg_Pub.Add;
4239: END IF;
4240: l_error := FND_API.G_TRUE;
4241: END IF;
4242:

Line 4253: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN

4249: IF (l_validate_quote_sts = FND_API.G_TRUE) THEN
4250: IF (l_resource_id is not null) THEN
4251: IF (FND_Profile.Value('IBE_UPDATE_DRAFT_QUOTES') = 'Y' ) THEN -- Update on Draft profile enabled, only allow updates on DRAFT.
4252: IF (l_status_code <> 'DRAFT') THEN
4253: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4254: FND_Message.Set_Name('IBE', 'IBE_SC_INVALID_QUOTE_STS');
4255: FND_Msg_Pub.Add;
4256: END IF;
4257: l_error := FND_API.G_TRUE;

Line 4255: FND_Msg_Pub.Add;

4251: IF (FND_Profile.Value('IBE_UPDATE_DRAFT_QUOTES') = 'Y' ) THEN -- Update on Draft profile enabled, only allow updates on DRAFT.
4252: IF (l_status_code <> 'DRAFT') THEN
4253: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4254: FND_Message.Set_Name('IBE', 'IBE_SC_INVALID_QUOTE_STS');
4255: FND_Msg_Pub.Add;
4256: END IF;
4257: l_error := FND_API.G_TRUE;
4258: END IF;
4259: ELSE -- update profile is not enabled, but update call for quote is coming down.

Line 4260: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN

4256: END IF;
4257: l_error := FND_API.G_TRUE;
4258: END IF;
4259: ELSE -- update profile is not enabled, but update call for quote is coming down.
4260: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4261: FND_Message.Set_Name('IBE', 'IBE_SC_INVALID_OPERATION'); -- Invalid Operation
4262: FND_Msg_Pub.Add;
4263: END IF;
4264: l_error := FND_API.G_TRUE;

Line 4262: FND_Msg_Pub.Add;

4258: END IF;
4259: ELSE -- update profile is not enabled, but update call for quote is coming down.
4260: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4261: FND_Message.Set_Name('IBE', 'IBE_SC_INVALID_OPERATION'); -- Invalid Operation
4262: FND_Msg_Pub.Add;
4263: END IF;
4264: l_error := FND_API.G_TRUE;
4265: END IF;
4266: ELSE -- for a cart, check for 'STORE DRAFT'

Line 4268: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN

4264: l_error := FND_API.G_TRUE;
4265: END IF;
4266: ELSE -- for a cart, check for 'STORE DRAFT'
4267: IF (l_status_code <> 'STORE DRAFT') THEN
4268: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4269: FND_Message.Set_Name('IBE', 'IBE_SC_INVALID_CART_STS');
4270: FND_Msg_Pub.Add;
4271: END IF;
4272: l_error := FND_API.G_TRUE;

Line 4270: FND_Msg_Pub.Add;

4266: ELSE -- for a cart, check for 'STORE DRAFT'
4267: IF (l_status_code <> 'STORE DRAFT') THEN
4268: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4269: FND_Message.Set_Name('IBE', 'IBE_SC_INVALID_CART_STS');
4270: FND_Msg_Pub.Add;
4271: END IF;
4272: l_error := FND_API.G_TRUE;
4273: END IF;
4274: END IF;

Line 4285: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN

4281: AND (l_source_code <> 'IStore Oneclick')) THEN
4282: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4283: IBE_UTIL.DEBUG('Validate_quote: Oneclick operation on a non-oneclick cart');
4284: END IF;
4285: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4286: FND_Message.Set_Name('IBE', 'IBE_SC_INVALID_OPERATION'); -- Invalid Operation
4287: FND_Msg_Pub.Add;
4288: END IF;
4289: l_error := FND_API.G_TRUE;

Line 4287: FND_Msg_Pub.Add;

4283: IBE_UTIL.DEBUG('Validate_quote: Oneclick operation on a non-oneclick cart');
4284: END IF;
4285: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4286: FND_Message.Set_Name('IBE', 'IBE_SC_INVALID_OPERATION'); -- Invalid Operation
4287: FND_Msg_Pub.Add;
4288: END IF;
4289: l_error := FND_API.G_TRUE;
4290: ELSE
4291: IF ((p_save_type <> UPDATE_EXPRESSORDER AND p_save_type <> SAVE_EXPRESSORDER)

Line 4298: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN

4294: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4295: IBE_UTIL.DEBUG('Validate_quote: Non-Oneclick operation on a oneclick cart');
4296: END IF;
4297:
4298: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4299: FND_Message.Set_Name('IBE', 'IBE_SC_CART_ORDERED');
4300: FND_Msg_Pub.Add;
4301: END IF;
4302: l_error := FND_API.G_TRUE;

Line 4300: FND_Msg_Pub.Add;

4296: END IF;
4297:
4298: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4299: FND_Message.Set_Name('IBE', 'IBE_SC_CART_ORDERED');
4300: FND_Msg_Pub.Add;
4301: END IF;
4302: l_error := FND_API.G_TRUE;
4303: END IF;
4304: END IF;

Line 4351: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

4347: EXCEPTION
4348: WHEN FND_API.G_EXC_ERROR THEN
4349: ROLLBACK TO validate_quote;
4350: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 4360: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

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');

Line 4367: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN

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,
4369: l_api_name);
4370: END IF;
4371: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 4368: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

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,
4369: l_api_name);
4370: END IF;
4371: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
4372: p_count => x_msg_count ,

Line 4371: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

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,
4369: l_api_name);
4370: END IF;
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');

Line 4509: FND_Msg_Pub.initialize;

4505:
4506: -- Initialize message list if p_init_msg_list is set to TRUE.
4507:
4508: IF FND_API.To_Boolean( p_init_msg_list ) THEN
4509: FND_Msg_Pub.initialize;
4510: END IF;
4511:
4512: -- Initialize API return status to success
4513: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4546: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN

4542: END IF;
4543:
4544: IF ((rec_sharee_info.quote_header_id is null) OR
4545: (nvl(rec_sharee_info.end_date_active,sysdate+1) <= sysdate)) then
4546: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4547: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_USERACCESS');
4548: FND_Msg_Pub.Add;
4549: END IF;
4550: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 4548: FND_Msg_Pub.Add;

4544: IF ((rec_sharee_info.quote_header_id is null) OR
4545: (nvl(rec_sharee_info.end_date_active,sysdate+1) <= sysdate)) then
4546: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4547: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_USERACCESS');
4548: FND_Msg_Pub.Add;
4549: END IF;
4550: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4551: IBE_UTIL.DEBUG('quote_retrieval_number::quotehdrId'||'('||p_quote_retrieval_number||','||p_quote_header_id||')');
4552: END IF;

Line 4569: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN

4565: (rec_sharee_info.cust_account_id is not null) and
4566: (p_party_id <> FND_API.G_MISS_NUM) and
4567: (p_cust_account_id <> FND_API.G_MISS_NUM)) then
4568: if ((rec_sharee_info.party_id <> p_party_id) or (rec_sharee_info.cust_account_id <> p_cust_account_id)) then
4569: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4570: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_USERACCESS');
4571: FND_Msg_Pub.Add;
4572: END IF;
4573: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 4571: FND_Msg_Pub.Add;

4567: (p_cust_account_id <> FND_API.G_MISS_NUM)) then
4568: if ((rec_sharee_info.party_id <> p_party_id) or (rec_sharee_info.cust_account_id <> p_cust_account_id)) then
4569: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4570: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_USERACCESS');
4571: FND_Msg_Pub.Add;
4572: END IF;
4573: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4574: IBE_UTIL.DEBUG('passed in partyid and account id does not match those of the retrieval number');
4575: IBE_UTIL.DEBUG('passed in partyid: ' || p_party_id || ' and account id : ' || p_cust_account_id);

Line 4596: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN

4592: p_retrieval_number => p_quote_retrieval_number,
4593: p_quote_header_id => p_quote_header_id,
4594: x_valid_flag => l_upgrade_flag);
4595: if (l_upgrade_flag <> FND_API.G_TRUE) then
4596: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4597: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_USERACCESS');
4598: FND_Msg_Pub.Add;
4599: END IF;
4600: end if;

Line 4598: FND_Msg_Pub.Add;

4594: x_valid_flag => l_upgrade_flag);
4595: if (l_upgrade_flag <> FND_API.G_TRUE) then
4596: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4597: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_USERACCESS');
4598: FND_Msg_Pub.Add;
4599: END IF;
4600: end if;
4601: end if;
4602:

Line 4613: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN

4609: l_privilege_type_code := rec_sharee_info.update_privilege_type_code;
4610: IF l_privilege_type_code <> 'A' THEN
4611: IF l_privilege_type_code = 'F' THEN
4612: IF p_privilege_type_code <> 'F' AND p_privilege_type_code <> 'R' THEN
4613: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4614: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_PRIVILEGE');
4615: FND_Msg_Pub.Add;
4616: END IF;
4617: RAISE FND_API.G_EXC_ERROR;

Line 4615: FND_Msg_Pub.Add;

4611: IF l_privilege_type_code = 'F' THEN
4612: IF p_privilege_type_code <> 'F' AND p_privilege_type_code <> 'R' THEN
4613: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4614: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_PRIVILEGE');
4615: FND_Msg_Pub.Add;
4616: END IF;
4617: RAISE FND_API.G_EXC_ERROR;
4618: END IF;
4619: ELSE

Line 4621: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN

4617: RAISE FND_API.G_EXC_ERROR;
4618: END IF;
4619: ELSE
4620: IF p_privilege_type_code <> 'R' THEN
4621: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4622: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_PRIVILEGE');
4623: FND_Msg_Pub.Add;
4624: END IF;
4625: RAISE FND_API.G_EXC_ERROR; -- need error message

Line 4623: FND_Msg_Pub.Add;

4619: ELSE
4620: IF p_privilege_type_code <> 'R' THEN
4621: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4622: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_PRIVILEGE');
4623: FND_Msg_Pub.Add;
4624: END IF;
4625: RAISE FND_API.G_EXC_ERROR; -- need error message
4626: END IF;
4627: END IF;

Line 4656: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN

4652: OPEN c_getQuoteInfo;
4653: FETCH c_getQuoteInfo INTO l_db_quote_header_id;
4654: CLOSE c_getQuoteInfo;
4655: IF l_db_quote_header_id is null then
4656: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4657: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_USERACCESS');
4658: FND_Msg_Pub.Add;
4659: END IF;
4660: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 4658: FND_Msg_Pub.Add;

4654: CLOSE c_getQuoteInfo;
4655: IF l_db_quote_header_id is null then
4656: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4657: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_USERACCESS');
4658: FND_Msg_Pub.Add;
4659: END IF;
4660: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4661: IBE_UTIL.DEBUG('partyId::custAcctId::quotehdrId'||'('||p_party_id||','||p_cust_account_id||','||p_quote_header_id||')');
4662: END IF;

Line 4694: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN

4690: CLOSE c_getQuoteInfo2;
4691: END IF;
4692:
4693: IF l_db_quote_header_id is null then
4694: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4695: FND_Message.Set_Name('IBE', 'IBE_SC_USERACCESS_ERR');
4696: FND_Msg_Pub.Add;
4697: END IF;
4698: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 4696: FND_Msg_Pub.Add;

4692:
4693: IF l_db_quote_header_id is null then
4694: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4695: FND_Message.Set_Name('IBE', 'IBE_SC_USERACCESS_ERR');
4696: FND_Msg_Pub.Add;
4697: END IF;
4698: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4699: IBE_UTIL.DEBUG('partyId::quotehdrId'||'('||p_party_id||','||p_quote_header_id||')');
4700: END IF;

Line 4733: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN

4729: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4730: IBE_UTIL.DEBUG('Validate_user_update: raising Quote_already_ordered error');
4731: END IF;
4732:
4733: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4734: FND_Message.Set_Name('IBE', 'IBE_SC_CART_ORDERED');
4735: FND_Msg_Pub.Add;
4736: END IF;
4737: RAISE FND_API.G_EXC_ERROR;

Line 4735: FND_Msg_Pub.Add;

4731: END IF;
4732:
4733: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4734: FND_Message.Set_Name('IBE', 'IBE_SC_CART_ORDERED');
4735: FND_Msg_Pub.Add;
4736: END IF;
4737: RAISE FND_API.G_EXC_ERROR;
4738: ELSE
4739: IF ((l_last_updated_by <> l_user_id) OR (p_save_type = PLACE_ORDER)) THEN

Line 4780: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN

4776: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4777: IBE_UTIL.DEBUG('Validate_user_update: raising Quote_needs_refresh error : ' || l_err_code);
4778: END IF;
4779:
4780: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4781: FND_Message.Set_Name('IBE', l_err_code);
4782: FND_Msg_Pub.Add;
4783: END IF;
4784: RAISE FND_API.G_EXC_ERROR;

Line 4782: FND_Msg_Pub.Add;

4778: END IF;
4779:
4780: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4781: FND_Message.Set_Name('IBE', l_err_code);
4782: FND_Msg_Pub.Add;
4783: END IF;
4784: RAISE FND_API.G_EXC_ERROR;
4785: END IF;
4786: END IF;

Line 4812: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

4808: END IF; -- end if quote header id is not null
4809: EXCEPTION
4810: WHEN FND_API.G_EXC_ERROR THEN
4811: x_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 4820: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

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,
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');

Line 4827: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN

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,
4829: l_api_name);
4830: END IF;
4831: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 4828: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

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,
4829: l_api_name);
4830: END IF;
4831: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
4832: p_count => x_msg_count ,

Line 4831: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

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,
4829: l_api_name);
4830: END IF;
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');

Line 4895: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN

4891: if (p_cust_account_id <> l_sold_to_cust) THEN
4892: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4893: IBE_UTIL.DEBUG('Not upgrading as the b2b cart account id does not match the account id passed in');
4894: END IF;
4895: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4896: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_USERACCESS');
4897: FND_Msg_Pub.Add;
4898: END IF;
4899: x_valid_flag := FND_API.G_FALSE;

Line 4897: FND_Msg_Pub.Add;

4893: IBE_UTIL.DEBUG('Not upgrading as the b2b cart account id does not match the account id passed in');
4894: END IF;
4895: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4896: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_USERACCESS');
4897: FND_Msg_Pub.Add;
4898: END IF;
4899: x_valid_flag := FND_API.G_FALSE;
4900: RAISE FND_API.G_EXC_ERROR;
4901: end if;

Line 4912: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN

4908: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4909: IBE_UTIL.DEBUG('Not saving party and cust_account_id because the recipient is not a b2c user');
4910: IBE_UTIL.DEBUG('Recipient user type: ' || l_party_type_recipient);
4911: END IF;
4912: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4913: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_USERACCESS');
4914: FND_Msg_Pub.Add;
4915: END IF;
4916: x_valid_flag := FND_API.G_FALSE;

Line 4914: FND_Msg_Pub.Add;

4910: IBE_UTIL.DEBUG('Recipient user type: ' || l_party_type_recipient);
4911: END IF;
4912: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4913: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_USERACCESS');
4914: FND_Msg_Pub.Add;
4915: END IF;
4916: x_valid_flag := FND_API.G_FALSE;
4917: RAISE FND_API.G_EXC_ERROR;
4918: end if;

Line 5216: FND_Msg_Pub.initialize;

5212: END IF;
5213:
5214: -- Initialize message list if p_init_msg_list is set to TRUE.
5215: IF FND_API.To_Boolean( p_init_msg_list ) THEN
5216: FND_Msg_Pub.initialize;
5217: END IF;
5218:
5219: -- Initialize API return status to success
5220: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5287: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

5283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5284: END IF;
5285:
5286: -- Standard call to get message count and if count is 1, get message info.
5287: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5288: p_count => x_msg_count ,
5289: p_data => x_msg_data);
5290:
5291: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 5300: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

5296: WHEN FND_API.G_EXC_ERROR THEN
5297: ROLLBACK TO Add_Attachment;
5298: x_return_status := FND_API.G_RET_STS_ERROR;
5299: x_last_update_date := getQuoteLastUpdateDate(p_quote_header_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()');

Line 5311: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

5307: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5308: ROLLBACK TO Add_Attachment;
5309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5310: x_last_update_date := getQuoteLastUpdateDate(p_quote_header_id);
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()');

Line 5322: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN

5318: WHEN OTHERS THEN
5319: ROLLBACK TO Add_Attachment;
5320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5321:
5322: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
5323: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
5324: l_api_name);
5325: END IF;
5326:

Line 5323: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

5319: ROLLBACK TO Add_Attachment;
5320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5321:
5322: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
5323: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
5324: l_api_name);
5325: END IF;
5326:
5327: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 5327: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

5323: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
5324: l_api_name);
5325: END IF;
5326:
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()');

Line 5375: FND_Msg_Pub.initialize;

5371: END IF;
5372:
5373: -- Initialize message list if p_init_msg_list is set to TRUE.
5374: IF FND_API.To_Boolean( p_init_msg_list ) THEN
5375: FND_Msg_Pub.initialize;
5376: END IF;
5377:
5378: -- Initialize API return status to success
5379: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5432: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

5428: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5429: END IF;
5430:
5431: -- Standard call to get message count and if count is 1, get message info.
5432: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5433: p_count => x_msg_count ,
5434: p_data => x_msg_data);
5435:
5436: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 5445: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

5441: WHEN FND_API.G_EXC_ERROR THEN
5442: ROLLBACK TO Add_Attachment;
5443: x_return_status := FND_API.G_RET_STS_ERROR;
5444: x_last_update_date := getQuoteLastUpdateDate(p_quote_header_id);
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()');

Line 5456: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

5452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5453: ROLLBACK TO Add_Attachment;
5454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5455: x_last_update_date := getQuoteLastUpdateDate(p_quote_header_id);
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()');

Line 5467: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN

5463: WHEN OTHERS THEN
5464: ROLLBACK TO Add_Attachment;
5465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5466:
5467: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
5468: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
5469: l_api_name);
5470: END IF;
5471:

Line 5468: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

5464: ROLLBACK TO Add_Attachment;
5465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5466:
5467: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
5468: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
5469: l_api_name);
5470: END IF;
5471:
5472: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 5472: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

5468: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
5469: l_api_name);
5470: END IF;
5471:
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()');