DBA Data[Home] [Help]

APPS.ASO_SALES_CREDIT_PVT dependencies on FND_MSG_PUB

Line 97: FND_MSG_PUB.initialize;

93:
94: -- Initialize message list if p_init_msg_list is set to TRUE.
95: IF FND_API.to_Boolean( p_init_msg_list )
96: THEN
97: FND_MSG_PUB.initialize;
98: END IF;
99:
100: -- Initialize API return status to SUCCESS
101: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

139: -- Check Whether record has been changed
140: IF (l_qte_header_rec.last_update_date IS NULL OR
141: l_qte_header_rec.last_update_date = FND_API.G_MISS_DATE) THEN
142: x_return_status := FND_API.G_RET_STS_ERROR;
143: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
144: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
145: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
146: FND_MSG_PUB.ADD;
147: END IF;

Line 146: FND_MSG_PUB.ADD;

142: x_return_status := FND_API.G_RET_STS_ERROR;
143: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
144: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
145: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
146: FND_MSG_PUB.ADD;
147: END IF;
148: RAISE FND_API.G_EXC_ERROR;
149: END IF;
150:

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

152: IF (p_qte_header_rec.last_update_date IS NOT NULL AND
153: p_qte_header_rec.last_update_date <> FND_API.G_MISS_DATE) AND
154: (l_qte_header_rec.last_update_date <> p_qte_header_rec.last_update_date) THEN
155: x_return_status := FND_API.G_RET_STS_ERROR;
156: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
157: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');
158: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
159: FND_MSG_PUB.ADD;
160: END IF;

Line 159: FND_MSG_PUB.ADD;

155: x_return_status := FND_API.G_RET_STS_ERROR;
156: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
157: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');
158: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
159: FND_MSG_PUB.ADD;
160: END IF;
161: RAISE FND_API.G_EXC_ERROR;
162: END IF;
163:

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

167: x_status => lx_return_status);
168:
169: IF (lx_return_status = FND_API.G_TRUE) THEN
170: x_return_status := FND_API.G_RET_STS_ERROR;
171: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
172: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
173: FND_MSG_PUB.ADD;
174: END IF;
175: RAISE FND_API.G_EXC_ERROR;

Line 173: FND_MSG_PUB.ADD;

169: IF (lx_return_status = FND_API.G_TRUE) THEN
170: x_return_status := FND_API.G_RET_STS_ERROR;
171: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
172: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
173: FND_MSG_PUB.ADD;
174: END IF;
175: RAISE FND_API.G_EXC_ERROR;
176: END IF;
177:

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

194: aso_debug_pub.add('Allocate_Sales_Credits: l_ordered: '||l_ordered,1,'N');
195: END IF;
196: IF l_ordered IS NOT NULL AND l_ordered = 'Y' THEN
197: x_return_status := FND_API.G_RET_STS_ERROR;
198: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
199: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ORDERED_STATUS_TRANS');
200: FND_MSG_PUB.ADD;
201: END IF;
202: RAISE FND_API.G_EXC_ERROR;

Line 200: FND_MSG_PUB.ADD;

196: IF l_ordered IS NOT NULL AND l_ordered = 'Y' THEN
197: x_return_status := FND_API.G_RET_STS_ERROR;
198: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
199: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ORDERED_STATUS_TRANS');
200: FND_MSG_PUB.ADD;
201: END IF;
202: RAISE FND_API.G_EXC_ERROR;
203: END IF;
204:

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

205: -- Check if pricing status is Complete
206: IF l_qte_header_rec.Pricing_Status_Indicator IS NOT NULL AND
207: l_qte_header_rec.Pricing_Status_Indicator <> 'C' THEN
208: x_return_status := FND_API.G_RET_STS_ERROR;
209: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
210: FND_MESSAGE.Set_Name('ASO', 'ASO_PRC_INCOMPLETE');
211: FND_MSG_PUB.ADD;
212: END IF;
213: RAISE FND_API.G_EXC_ERROR;

Line 211: FND_MSG_PUB.ADD;

207: l_qte_header_rec.Pricing_Status_Indicator <> 'C' THEN
208: x_return_status := FND_API.G_RET_STS_ERROR;
209: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
210: FND_MESSAGE.Set_Name('ASO', 'ASO_PRC_INCOMPLETE');
211: FND_MSG_PUB.ADD;
212: END IF;
213: RAISE FND_API.G_EXC_ERROR;
214: END IF;
215:

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

222: aso_debug_pub.add('Allocate_Sales_Credits: l_line_exists: '||l_line_exists,1,'N');
223: END IF;
224: IF l_line_exists IS NULL OR l_line_exists <> 'Y' THEN
225: x_return_status := FND_API.G_RET_STS_ERROR;
226: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
227: FND_MESSAGE.Set_Name('ASO', 'ASO_NO_QUOTE_LINES');
228: FND_MSG_PUB.ADD;
229: END IF;
230: RAISE FND_API.G_EXC_ERROR;

Line 228: FND_MSG_PUB.ADD;

224: IF l_line_exists IS NULL OR l_line_exists <> 'Y' THEN
225: x_return_status := FND_API.G_RET_STS_ERROR;
226: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
227: FND_MESSAGE.Set_Name('ASO', 'ASO_NO_QUOTE_LINES');
228: FND_MSG_PUB.ADD;
229: END IF;
230: RAISE FND_API.G_EXC_ERROR;
231: END IF;
232:

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

232:
233: -- Call Sales Team Assign if required
234: IF l_auto_sales_team_prof <> 'FULL' AND l_auto_sales_team_prof <> 'PARTIAL' THEN
235: x_return_status := FND_API.G_RET_STS_ERROR;
236: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
237: FND_MESSAGE.Set_Name('ASO', 'ASO_S_TEAM_PROF_NOT_SET');
238: FND_MSG_PUB.ADD;
239: END IF;
240: RAISE FND_API.G_EXC_ERROR;

Line 238: FND_MSG_PUB.ADD;

234: IF l_auto_sales_team_prof <> 'FULL' AND l_auto_sales_team_prof <> 'PARTIAL' THEN
235: x_return_status := FND_API.G_RET_STS_ERROR;
236: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
237: FND_MESSAGE.Set_Name('ASO', 'ASO_S_TEAM_PROF_NOT_SET');
238: FND_MSG_PUB.ADD;
239: END IF;
240: RAISE FND_API.G_EXC_ERROR;
241: END IF;
242:

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

273: aso_debug_pub.add('Allocate_Sales_Credits: l_sreps_count: '||l_sreps_count,1,'N');
274: END IF;
275: IF C_Get_Sreps_Count%NOTFOUND OR l_sreps_count = 0 THEN
276: x_return_status := FND_API.G_RET_STS_ERROR;
277: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
278: FND_MESSAGE.Set_Name('ASO', 'ASO_NO_SALES_CREDIT_RECEIVERS');
279: FND_MSG_PUB.ADD;
280: END IF;
281: CLOSE C_Get_Sreps_Count;

Line 279: FND_MSG_PUB.ADD;

275: IF C_Get_Sreps_Count%NOTFOUND OR l_sreps_count = 0 THEN
276: x_return_status := FND_API.G_RET_STS_ERROR;
277: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
278: FND_MESSAGE.Set_Name('ASO', 'ASO_NO_SALES_CREDIT_RECEIVERS');
279: FND_MSG_PUB.ADD;
280: END IF;
281: CLOSE C_Get_Sreps_Count;
282: RAISE FND_API.G_EXC_ERROR;
283: END IF;

Line 350: FND_MSG_PUB.Count_And_Get

346: -- Change END
347:
348:
349: -- Standard call to get message count and if count is 1, get message info.
350: FND_MSG_PUB.Count_And_Get
351: ( p_count => x_msg_count,
352: p_data => x_msg_data
353: );
354:

Line 364: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

360: WHEN FND_API.G_EXC_ERROR THEN
361: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
362: P_API_NAME => L_API_NAME,
363: P_PKG_NAME => G_PKG_NAME,
364: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
365: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
366: P_SQLCODE => SQLCODE,
367: P_SQLERRM => SQLERRM,
368: X_MSG_COUNT => X_MSG_COUNT,

Line 377: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

373: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
374: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
375: P_API_NAME => L_API_NAME,
376: P_PKG_NAME => G_PKG_NAME,
377: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
378: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
379: P_SQLCODE => SQLCODE,
380: P_SQLERRM => SQLERRM,
381: X_MSG_COUNT => X_MSG_COUNT,

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

819: -- Check if atleast some credit has been allocated
820: IF (l_hdr_total IS NULL OR l_hdr_total < 1) AND
821: (l_line_total IS NULL OR l_line_total < 1) THEN
822: -- x_return_status := FND_API.G_RET_STS_ERROR;
823: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
824: FND_MESSAGE.Set_Name('ASO', 'ASO_NO_CREDIT_ALLOCATED');
825: FND_MSG_PUB.ADD;
826: END IF;
827: -- RAISE FND_API.G_EXC_ERROR;

Line 825: FND_MSG_PUB.ADD;

821: (l_line_total IS NULL OR l_line_total < 1) THEN
822: -- x_return_status := FND_API.G_RET_STS_ERROR;
823: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
824: FND_MESSAGE.Set_Name('ASO', 'ASO_NO_CREDIT_ALLOCATED');
825: FND_MSG_PUB.ADD;
826: END IF;
827: -- RAISE FND_API.G_EXC_ERROR;
828: END IF;
829:

Line 1080: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

1076: WHEN FND_API.G_EXC_ERROR THEN
1077: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1078: P_API_NAME => L_API_NAME,
1079: P_PKG_NAME => G_PKG_NAME,
1080: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
1081: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1082: P_SQLCODE => SQLCODE,
1083: P_SQLERRM => SQLERRM,
1084: X_MSG_COUNT => X_MSG_COUNT,

Line 1093: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

1089: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1090: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1091: P_API_NAME => L_API_NAME,
1092: P_PKG_NAME => G_PKG_NAME,
1093: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1094: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1095: P_SQLCODE => SQLCODE,
1096: P_SQLERRM => SQLERRM,
1097: X_MSG_COUNT => X_MSG_COUNT,