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 2576: FND_Msg_Pub.initialize;

2572: END IF;
2573:
2574: -- Initialize message list if p_init_msg_list is set to TRUE.
2575: IF FND_API.To_Boolean(p_init_msg_list) THEN
2576: FND_Msg_Pub.initialize;
2577: END IF;
2578:
2579: -- Initialize API return status to success
2580: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2892: COMMIT WORK;
2893: END IF;
2894:
2895: -- Standard call to get message count and if count is 1, get message info.
2896: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2897: p_count => x_msg_count ,
2898: p_data => x_msg_data);
2899: EXCEPTION
2900: WHEN FND_API.G_EXC_ERROR THEN

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

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

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

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

Line 2924: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) 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
2925: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
2926: L_API_NAME);
2927: END IF;
2928:

Line 2925: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

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
2925: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
2926: L_API_NAME);
2927: END IF;
2928:
2929: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

2925: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
2926: L_API_NAME);
2927: END IF;
2928:
2929: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2930: p_count => x_msg_count ,
2931: p_data => x_msg_data);
2932:
2933: End get_load_errors;

Line 2985: FND_MSG_PUB.initialize;

2981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2982: END IF;
2983: -- Initialize message list if p_init_msg_list is set to TRUE.
2984: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2985: FND_MSG_PUB.initialize;
2986: END IF;
2987: -- Initialize API return status to success
2988: x_return_status := FND_API.G_RET_STS_SUCCESS;
2989: -- API body

Line 3007: FND_MSG_PUB.Count_And_Get

3003: x_cartHeaderId := l_cartHeaderId;
3004: end if;
3005:
3006: -- Standard call to get message count and if count is 1, get message info.
3007: FND_MSG_PUB.Count_And_Get
3008: (p_count => x_msg_count,
3009: p_data => x_msg_data
3010: );
3011:

Line 3019: FND_MSG_PUB.add;

3015: --ibe_util.debug('TOO_MANY_ROWS');
3016: ROLLBACK TO GETACTIVECARTID_pvt;
3017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3018: FND_MESSAGE.set_name('IBE','IBE_SC_GETACTIVEC_MANY');
3019: FND_MSG_PUB.add;
3020: FND_MSG_PUB.Count_And_Get
3021: ( p_count => x_msg_count,
3022: p_data => x_msg_data
3023: );

Line 3020: FND_MSG_PUB.Count_And_Get

3016: ROLLBACK TO GETACTIVECARTID_pvt;
3017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3018: FND_MESSAGE.set_name('IBE','IBE_SC_GETACTIVEC_MANY');
3019: FND_MSG_PUB.add;
3020: FND_MSG_PUB.Count_And_Get
3021: ( p_count => x_msg_count,
3022: p_data => x_msg_data
3023: );
3024: WHEN NO_DATA_FOUND then

Line 3031: FND_MSG_PUB.Count_And_Get

3027:
3028: WHEN FND_API.G_EXC_ERROR THEN
3029: ROLLBACK TO GETACTIVECARTID_pvt;
3030: x_return_status := FND_API.G_RET_STS_ERROR;
3031: FND_MSG_PUB.Count_And_Get
3032: ( p_count => x_msg_count,
3033: p_data => x_msg_data
3034: );
3035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3038: FND_MSG_PUB.Count_And_Get

3034: );
3035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3036: ROLLBACK TO GETACTIVECARTID_pvt;
3037: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3038: FND_MSG_PUB.Count_And_Get
3039: ( p_count => x_msg_count,
3040: p_data => x_msg_data
3041: );
3042: WHEN OTHERS THEN

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

3041: );
3042: WHEN OTHERS THEN
3043: ROLLBACK TO GETACTIVECARTID_pvt;
3044: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3045: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3046: FND_MSG_PUB.Add_Exc_Msg
3047: ( G_PKG_NAME,
3048: l_api_name);
3049: END IF;

Line 3046: FND_MSG_PUB.Add_Exc_Msg

3042: WHEN OTHERS THEN
3043: ROLLBACK TO GETACTIVECARTID_pvt;
3044: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3045: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3046: FND_MSG_PUB.Add_Exc_Msg
3047: ( G_PKG_NAME,
3048: l_api_name);
3049: END IF;
3050: FND_MSG_PUB.Count_And_Get

Line 3050: FND_MSG_PUB.Count_And_Get

3046: FND_MSG_PUB.Add_Exc_Msg
3047: ( G_PKG_NAME,
3048: l_api_name);
3049: END IF;
3050: FND_MSG_PUB.Count_And_Get
3051: ( p_count => x_msg_count,
3052: p_data => x_msg_data
3053: );
3054:

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

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,
3144: p_count => x_msg_count ,
3145: p_data => x_msg_data );
3146: EXCEPTION
3147: WHEN FND_API.G_EXC_ERROR THEN

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

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

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

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

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

3168: END IF;
3169: ROLLBACK to Update_config_item_lines;
3170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3171:
3172: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3173: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
3174: l_api_name);
3175: END IF;
3176:

Line 3173: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

3169: ROLLBACK to Update_config_item_lines;
3170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3171:
3172: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3173: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
3174: l_api_name);
3175: END IF;
3176:
3177: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

3173: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
3174: l_api_name);
3175: END IF;
3176:
3177: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
3178: p_count => x_msg_count,
3179: p_data => x_msg_data);
3180: END Update_Config_Item_Lines;
3181:

Line 3408: FND_MSG_PUB.initialize;

3404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3405: END IF;
3406: -- Initialize message list IF p_init_msg_list is set to TRUE.
3407: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3408: FND_MSG_PUB.initialize;
3409: END IF;
3410:
3411: -- Initialize API return status to success
3412: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3603: COMMIT WORK;
3604: END IF;
3605:
3606: -- Standard call to get message count and IF count is 1, get message info.
3607: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
3608: p_count => x_msg_count,
3609: p_data => x_msg_data);
3610: EXCEPTION
3611: WHEN FND_API.G_EXC_ERROR THEN

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

3614: END IF;
3615:
3616: ROLLBACK TO DUPLICATE_LINE_PVT;
3617: x_return_status := FND_API.G_RET_STS_ERROR;
3618: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
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

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

3624: END IF;
3625:
3626: ROLLBACK TO DUPLICATE_LINE_PVT;
3627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3628: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
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

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

3635:
3636: ROLLBACK TO DUPLICATE_LINE_PVT;
3637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3638:
3639: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3640: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
3641: l_api_name);
3642: END IF;
3643:

Line 3640: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

3636: ROLLBACK TO DUPLICATE_LINE_PVT;
3637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3638:
3639: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3640: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
3641: l_api_name);
3642: END IF;
3643:
3644: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

3640: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
3641: l_api_name);
3642: END IF;
3643:
3644: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
3645: p_count => x_msg_count,
3646: p_data => x_msg_data);
3647: END Duplicate_Line;
3648:

Line 3903: FND_MSG_PUB.initialize;

3899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3900: END IF;
3901: -- Initialize message list IF p_init_msg_list is set to TRUE.
3902: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3903: FND_MSG_PUB.initialize;
3904: END IF;
3905: -- Initialize API return status to success
3906: x_return_status := FND_API.G_RET_STS_SUCCESS;
3907:

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

3921: END IF;
3922: p_last_update_date := l_last_update_date;
3923: -- raise error
3924:
3925: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3926: FND_MESSAGE.Set_Name('IBE', 'IBE_SC_QUOTE_NEED_REFRESH');
3927: FND_MSG_PUB.ADD;
3928: END IF;
3929: RAISE FND_API.G_EXC_ERROR; -- need error message

Line 3927: FND_MSG_PUB.ADD;

3923: -- raise error
3924:
3925: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3926: FND_MESSAGE.Set_Name('IBE', 'IBE_SC_QUOTE_NEED_REFRESH');
3927: FND_MSG_PUB.ADD;
3928: END IF;
3929: RAISE FND_API.G_EXC_ERROR; -- need error message
3930: END IF;
3931: -- 4587019

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

4007: IF FND_API.To_Boolean( p_commit ) THEN
4008: COMMIT WORK;
4009: END IF;
4010: -- Standard call to get message count and IF count is 1, get message info.
4011: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
4012: p_count => lx_msg_count,
4013: p_data => lx_msg_data);
4014: EXCEPTION
4015: WHEN FND_API.G_EXC_ERROR THEN

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

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

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

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

Line 4039: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) 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
4040: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
4041: l_api_name);
4042: END IF;
4043: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 4040: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

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
4040: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
4041: l_api_name);
4042: END IF;
4043: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
4044: p_count => lx_msg_count,

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

4039: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4040: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
4041: l_api_name);
4042: END IF;
4043: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
4044: p_count => lx_msg_count,
4045: p_data => lx_msg_data);
4046: END Split_Line;
4047:

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

4114: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4115: IBE_UTIL.DEBUG('Validate_quote, quote is unpublished' || to_char(sysdate, 'mm/dd/yyyy:hh24:MI:SS'));
4116: END IF;
4117:
4118: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4119: FND_Message.Set_Name('IBE', 'IBE_SC_QUOTE_NOT_PUBL');
4120: FND_Msg_Pub.Add;
4121: END IF;
4122: l_error := FND_API.G_TRUE;

Line 4120: FND_Msg_Pub.Add;

4116: END IF;
4117:
4118: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4119: FND_Message.Set_Name('IBE', 'IBE_SC_QUOTE_NOT_PUBL');
4120: FND_Msg_Pub.Add;
4121: END IF;
4122: l_error := FND_API.G_TRUE;
4123: END IF;
4124:

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

4131: IF (l_validate_quote_sts = FND_API.G_TRUE) THEN
4132: IF (l_resource_id is not null) THEN
4133: IF (FND_Profile.Value('IBE_UPDATE_DRAFT_QUOTES') = 'Y' ) THEN -- Update on Draft profile enabled, only allow updates on DRAFT.
4134: IF (l_status_code <> 'DRAFT') THEN
4135: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4136: FND_Message.Set_Name('IBE', 'IBE_SC_INVALID_QUOTE_STS');
4137: FND_Msg_Pub.Add;
4138: END IF;
4139: l_error := FND_API.G_TRUE;

Line 4137: FND_Msg_Pub.Add;

4133: IF (FND_Profile.Value('IBE_UPDATE_DRAFT_QUOTES') = 'Y' ) THEN -- Update on Draft profile enabled, only allow updates on DRAFT.
4134: IF (l_status_code <> 'DRAFT') THEN
4135: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4136: FND_Message.Set_Name('IBE', 'IBE_SC_INVALID_QUOTE_STS');
4137: FND_Msg_Pub.Add;
4138: END IF;
4139: l_error := FND_API.G_TRUE;
4140: END IF;
4141: ELSE -- update profile is not enabled, but update call for quote is coming down.

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

4138: END IF;
4139: l_error := FND_API.G_TRUE;
4140: END IF;
4141: ELSE -- update profile is not enabled, but update call for quote is coming down.
4142: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4143: FND_Message.Set_Name('IBE', 'IBE_SC_INVALID_OPERATION'); -- Invalid Operation
4144: FND_Msg_Pub.Add;
4145: END IF;
4146: l_error := FND_API.G_TRUE;

Line 4144: FND_Msg_Pub.Add;

4140: END IF;
4141: ELSE -- update profile is not enabled, but update call for quote is coming down.
4142: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4143: FND_Message.Set_Name('IBE', 'IBE_SC_INVALID_OPERATION'); -- Invalid Operation
4144: FND_Msg_Pub.Add;
4145: END IF;
4146: l_error := FND_API.G_TRUE;
4147: END IF;
4148: ELSE -- for a cart, check for 'STORE DRAFT'

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

4146: l_error := FND_API.G_TRUE;
4147: END IF;
4148: ELSE -- for a cart, check for 'STORE DRAFT'
4149: IF (l_status_code <> 'STORE DRAFT') THEN
4150: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4151: FND_Message.Set_Name('IBE', 'IBE_SC_INVALID_CART_STS');
4152: FND_Msg_Pub.Add;
4153: END IF;
4154: l_error := FND_API.G_TRUE;

Line 4152: FND_Msg_Pub.Add;

4148: ELSE -- for a cart, check for 'STORE DRAFT'
4149: IF (l_status_code <> 'STORE DRAFT') THEN
4150: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4151: FND_Message.Set_Name('IBE', 'IBE_SC_INVALID_CART_STS');
4152: FND_Msg_Pub.Add;
4153: END IF;
4154: l_error := FND_API.G_TRUE;
4155: END IF;
4156: END IF;

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

4163: AND (l_source_code <> 'IStore Oneclick')) THEN
4164: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4165: IBE_UTIL.DEBUG('Validate_quote: Oneclick operation on a non-oneclick cart');
4166: END IF;
4167: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4168: FND_Message.Set_Name('IBE', 'IBE_SC_INVALID_OPERATION'); -- Invalid Operation
4169: FND_Msg_Pub.Add;
4170: END IF;
4171: l_error := FND_API.G_TRUE;

Line 4169: FND_Msg_Pub.Add;

4165: IBE_UTIL.DEBUG('Validate_quote: Oneclick operation on a non-oneclick cart');
4166: END IF;
4167: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4168: FND_Message.Set_Name('IBE', 'IBE_SC_INVALID_OPERATION'); -- Invalid Operation
4169: FND_Msg_Pub.Add;
4170: END IF;
4171: l_error := FND_API.G_TRUE;
4172: ELSE
4173: IF ((p_save_type <> UPDATE_EXPRESSORDER AND p_save_type <> SAVE_EXPRESSORDER)

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

4176: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4177: IBE_UTIL.DEBUG('Validate_quote: Non-Oneclick operation on a oneclick cart');
4178: END IF;
4179:
4180: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4181: FND_Message.Set_Name('IBE', 'IBE_SC_CART_ORDERED');
4182: FND_Msg_Pub.Add;
4183: END IF;
4184: l_error := FND_API.G_TRUE;

Line 4182: FND_Msg_Pub.Add;

4178: END IF;
4179:
4180: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4181: FND_Message.Set_Name('IBE', 'IBE_SC_CART_ORDERED');
4182: FND_Msg_Pub.Add;
4183: END IF;
4184: l_error := FND_API.G_TRUE;
4185: END IF;
4186: END IF;

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

4229: EXCEPTION
4230: WHEN FND_API.G_EXC_ERROR THEN
4231: ROLLBACK TO validate_quote;
4232: x_return_status := FND_API.G_RET_STS_ERROR;
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');

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

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

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

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,
4251: l_api_name);
4252: END IF;
4253: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 4250: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

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,
4251: l_api_name);
4252: END IF;
4253: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
4254: p_count => x_msg_count ,

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

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

Line 4377: FND_Msg_Pub.initialize;

4373:
4374: -- Initialize message list if p_init_msg_list is set to TRUE.
4375:
4376: IF FND_API.To_Boolean( p_init_msg_list ) THEN
4377: FND_Msg_Pub.initialize;
4378: END IF;
4379:
4380: -- Initialize API return status to success
4381: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

4410: END IF;
4411:
4412: IF ((rec_sharee_info.quote_header_id is null) OR
4413: (nvl(rec_sharee_info.end_date_active,sysdate+1) <= sysdate)) then
4414: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4415: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_USERACCESS');
4416: FND_Msg_Pub.Add;
4417: END IF;
4418: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 4416: FND_Msg_Pub.Add;

4412: IF ((rec_sharee_info.quote_header_id is null) OR
4413: (nvl(rec_sharee_info.end_date_active,sysdate+1) <= sysdate)) then
4414: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4415: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_USERACCESS');
4416: FND_Msg_Pub.Add;
4417: END IF;
4418: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4419: IBE_UTIL.DEBUG('quote_retrieval_number::quotehdrId'||'('||p_quote_retrieval_number||','||p_quote_header_id||')');
4420: END IF;

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

4433: (rec_sharee_info.cust_account_id is not null) and
4434: (p_party_id <> FND_API.G_MISS_NUM) and
4435: (p_cust_account_id <> FND_API.G_MISS_NUM)) then
4436: if ((rec_sharee_info.party_id <> p_party_id) or (rec_sharee_info.cust_account_id <> p_cust_account_id)) then
4437: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4438: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_USERACCESS');
4439: FND_Msg_Pub.Add;
4440: END IF;
4441: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 4439: FND_Msg_Pub.Add;

4435: (p_cust_account_id <> FND_API.G_MISS_NUM)) then
4436: if ((rec_sharee_info.party_id <> p_party_id) or (rec_sharee_info.cust_account_id <> p_cust_account_id)) then
4437: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4438: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_USERACCESS');
4439: FND_Msg_Pub.Add;
4440: END IF;
4441: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4442: IBE_UTIL.DEBUG('passed in partyid and account id does not match those of the retrieval number');
4443: IBE_UTIL.DEBUG('passed in partyid: ' || p_party_id || ' and account id : ' || p_cust_account_id);

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

4460: p_retrieval_number => p_quote_retrieval_number,
4461: p_quote_header_id => p_quote_header_id,
4462: x_valid_flag => l_upgrade_flag);
4463: if (l_upgrade_flag <> FND_API.G_TRUE) then
4464: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4465: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_USERACCESS');
4466: FND_Msg_Pub.Add;
4467: END IF;
4468: end if;

Line 4466: FND_Msg_Pub.Add;

4462: x_valid_flag => l_upgrade_flag);
4463: if (l_upgrade_flag <> FND_API.G_TRUE) then
4464: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4465: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_USERACCESS');
4466: FND_Msg_Pub.Add;
4467: END IF;
4468: end if;
4469: end if;
4470:

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

4477: l_privilege_type_code := rec_sharee_info.update_privilege_type_code;
4478: IF l_privilege_type_code <> 'A' THEN
4479: IF l_privilege_type_code = 'F' THEN
4480: IF p_privilege_type_code <> 'F' AND p_privilege_type_code <> 'R' THEN
4481: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4482: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_PRIVILEGE');
4483: FND_Msg_Pub.Add;
4484: END IF;
4485: RAISE FND_API.G_EXC_ERROR;

Line 4483: FND_Msg_Pub.Add;

4479: IF l_privilege_type_code = 'F' THEN
4480: IF p_privilege_type_code <> 'F' AND p_privilege_type_code <> 'R' THEN
4481: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4482: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_PRIVILEGE');
4483: FND_Msg_Pub.Add;
4484: END IF;
4485: RAISE FND_API.G_EXC_ERROR;
4486: END IF;
4487: ELSE

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

4485: RAISE FND_API.G_EXC_ERROR;
4486: END IF;
4487: ELSE
4488: IF p_privilege_type_code <> 'R' THEN
4489: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4490: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_PRIVILEGE');
4491: FND_Msg_Pub.Add;
4492: END IF;
4493: RAISE FND_API.G_EXC_ERROR; -- need error message

Line 4491: FND_Msg_Pub.Add;

4487: ELSE
4488: IF p_privilege_type_code <> 'R' THEN
4489: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4490: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_PRIVILEGE');
4491: FND_Msg_Pub.Add;
4492: END IF;
4493: RAISE FND_API.G_EXC_ERROR; -- need error message
4494: END IF;
4495: END IF;

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

4520: OPEN c_getQuoteInfo;
4521: FETCH c_getQuoteInfo INTO l_db_quote_header_id;
4522: CLOSE c_getQuoteInfo;
4523: IF l_db_quote_header_id is null then
4524: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4525: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_USERACCESS');
4526: FND_Msg_Pub.Add;
4527: END IF;
4528: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 4526: FND_Msg_Pub.Add;

4522: CLOSE c_getQuoteInfo;
4523: IF l_db_quote_header_id is null then
4524: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4525: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_USERACCESS');
4526: FND_Msg_Pub.Add;
4527: END IF;
4528: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4529: IBE_UTIL.DEBUG('partyId::custAcctId::quotehdrId'||'('||p_party_id||','||p_cust_account_id||','||p_quote_header_id||')');
4530: END IF;

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

4548: FETCH c_getQuoteInfo INTO l_db_quote_header_id;
4549: CLOSE c_getQuoteInfo;
4550:
4551: IF l_db_quote_header_id is null then
4552: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4553: FND_Message.Set_Name('IBE', 'IBE_SC_USERACCESS_ERR');
4554: FND_Msg_Pub.Add;
4555: END IF;
4556: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 4554: FND_Msg_Pub.Add;

4550:
4551: IF l_db_quote_header_id is null then
4552: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4553: FND_Message.Set_Name('IBE', 'IBE_SC_USERACCESS_ERR');
4554: FND_Msg_Pub.Add;
4555: END IF;
4556: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4557: IBE_UTIL.DEBUG('partyId::quotehdrId'||'('||p_party_id||','||p_quote_header_id||')');
4558: END IF;

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

4587: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4588: IBE_UTIL.DEBUG('Validate_user_update: raising Quote_already_ordered error');
4589: END IF;
4590:
4591: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4592: FND_Message.Set_Name('IBE', 'IBE_SC_CART_ORDERED');
4593: FND_Msg_Pub.Add;
4594: END IF;
4595: RAISE FND_API.G_EXC_ERROR;

Line 4593: FND_Msg_Pub.Add;

4589: END IF;
4590:
4591: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4592: FND_Message.Set_Name('IBE', 'IBE_SC_CART_ORDERED');
4593: FND_Msg_Pub.Add;
4594: END IF;
4595: RAISE FND_API.G_EXC_ERROR;
4596: ELSE
4597: IF ((l_last_updated_by <> l_user_id) OR (p_save_type = PLACE_ORDER)) THEN

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

4634: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4635: IBE_UTIL.DEBUG('Validate_user_update: raising Quote_needs_refresh error : ' || l_err_code);
4636: END IF;
4637:
4638: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4639: FND_Message.Set_Name('IBE', l_err_code);
4640: FND_Msg_Pub.Add;
4641: END IF;
4642: RAISE FND_API.G_EXC_ERROR;

Line 4640: FND_Msg_Pub.Add;

4636: END IF;
4637:
4638: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4639: FND_Message.Set_Name('IBE', l_err_code);
4640: FND_Msg_Pub.Add;
4641: END IF;
4642: RAISE FND_API.G_EXC_ERROR;
4643: END IF;
4644: END IF;

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

4666: END IF; -- end if quote header id is not null
4667: EXCEPTION
4668: WHEN FND_API.G_EXC_ERROR THEN
4669: x_return_status := FND_API.G_RET_STS_ERROR;
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');

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

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

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

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,
4687: l_api_name);
4688: END IF;
4689: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 4686: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

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,
4687: l_api_name);
4688: END IF;
4689: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
4690: p_count => x_msg_count ,

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

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

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

4749: if (p_cust_account_id <> l_sold_to_cust) THEN
4750: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4751: IBE_UTIL.DEBUG('Not upgrading as the b2b cart account id does not match the account id passed in');
4752: END IF;
4753: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4754: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_USERACCESS');
4755: FND_Msg_Pub.Add;
4756: END IF;
4757: x_valid_flag := FND_API.G_FALSE;

Line 4755: FND_Msg_Pub.Add;

4751: IBE_UTIL.DEBUG('Not upgrading as the b2b cart account id does not match the account id passed in');
4752: END IF;
4753: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4754: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_USERACCESS');
4755: FND_Msg_Pub.Add;
4756: END IF;
4757: x_valid_flag := FND_API.G_FALSE;
4758: RAISE FND_API.G_EXC_ERROR;
4759: end if;

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

4766: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4767: IBE_UTIL.DEBUG('Not saving party and cust_account_id because the recipient is not a b2c user');
4768: IBE_UTIL.DEBUG('Recipient user type: ' || l_party_type_recipient);
4769: END IF;
4770: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4771: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_USERACCESS');
4772: FND_Msg_Pub.Add;
4773: END IF;
4774: x_valid_flag := FND_API.G_FALSE;

Line 4772: FND_Msg_Pub.Add;

4768: IBE_UTIL.DEBUG('Recipient user type: ' || l_party_type_recipient);
4769: END IF;
4770: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4771: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_USERACCESS');
4772: FND_Msg_Pub.Add;
4773: END IF;
4774: x_valid_flag := FND_API.G_FALSE;
4775: RAISE FND_API.G_EXC_ERROR;
4776: end if;

Line 5074: FND_Msg_Pub.initialize;

5070: END IF;
5071:
5072: -- Initialize message list if p_init_msg_list is set to TRUE.
5073: IF FND_API.To_Boolean( p_init_msg_list ) THEN
5074: FND_Msg_Pub.initialize;
5075: END IF;
5076:
5077: -- Initialize API return status to success
5078: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

5141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5142: END IF;
5143:
5144: -- Standard call to get message count and if count is 1, get message info.
5145: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5146: p_count => x_msg_count ,
5147: p_data => x_msg_data);
5148:
5149: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

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

5154: WHEN FND_API.G_EXC_ERROR THEN
5155: ROLLBACK TO Add_Attachment;
5156: x_return_status := FND_API.G_RET_STS_ERROR;
5157: x_last_update_date := getQuoteLastUpdateDate(p_quote_header_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()');

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

5165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5166: ROLLBACK TO Add_Attachment;
5167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5168: x_last_update_date := getQuoteLastUpdateDate(p_quote_header_id);
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()');

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

5176: WHEN OTHERS THEN
5177: ROLLBACK TO Add_Attachment;
5178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5179:
5180: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
5181: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
5182: l_api_name);
5183: END IF;
5184:

Line 5181: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

5177: ROLLBACK TO Add_Attachment;
5178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5179:
5180: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
5181: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
5182: l_api_name);
5183: END IF;
5184:
5185: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

5181: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
5182: l_api_name);
5183: END IF;
5184:
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()');

Line 5233: FND_Msg_Pub.initialize;

5229: END IF;
5230:
5231: -- Initialize message list if p_init_msg_list is set to TRUE.
5232: IF FND_API.To_Boolean( p_init_msg_list ) THEN
5233: FND_Msg_Pub.initialize;
5234: END IF;
5235:
5236: -- Initialize API return status to success
5237: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

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

5299: WHEN FND_API.G_EXC_ERROR THEN
5300: ROLLBACK TO Add_Attachment;
5301: x_return_status := FND_API.G_RET_STS_ERROR;
5302: x_last_update_date := getQuoteLastUpdateDate(p_quote_header_id);
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()');

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

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

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

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

Line 5326: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

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

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

5326: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
5327: l_api_name);
5328: END IF;
5329:
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()');