eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_PROJ_COMM_PVT dependencies on FND_MSG_PUB

Line 87: FND_MSG_PUB.initialize;

83:
84: -- Initialize message list if p_init_msg_list is set to TRUE.
85: IF FND_API.to_Boolean( p_init_msg_list )
86: THEN
87: FND_MSG_PUB.initialize;
88: END IF;
89:
90: -- Initialize API return status to SUCCESS
91: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

106: -- Basic Validations
107: -- Check If ASO:Calculate Projected Commmission is set
108: IF l_proj_comm_prof <> 'Y' THEN
109: x_return_status := FND_API.G_RET_STS_ERROR;
110: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
111: FND_MESSAGE.Set_Name('ASO', 'ASO_PROJ_COMM_NOT_SET');
112: FND_MSG_PUB.ADD;
113: END IF;
114: RAISE FND_API.G_EXC_ERROR;

Line 112: FND_MSG_PUB.ADD;

108: IF l_proj_comm_prof <> 'Y' THEN
109: x_return_status := FND_API.G_RET_STS_ERROR;
110: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
111: FND_MESSAGE.Set_Name('ASO', 'ASO_PROJ_COMM_NOT_SET');
112: FND_MSG_PUB.ADD;
113: END IF;
114: RAISE FND_API.G_EXC_ERROR;
115: END IF;
116:

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

121: IF (C_Get_Header_Info%NOTFOUND) OR
122: (C_Header_Info.last_update_date IS NULL OR
123: C_Header_Info.last_update_date = FND_API.G_MISS_DATE) THEN
124: x_return_status := FND_API.G_RET_STS_ERROR;
125: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
126: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
127: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
128: FND_MSG_PUB.ADD;
129: END IF;

Line 128: FND_MSG_PUB.ADD;

124: x_return_status := FND_API.G_RET_STS_ERROR;
125: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
126: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
127: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
128: FND_MSG_PUB.ADD;
129: END IF;
130: CLOSE C_Get_Header_Info;
131: RAISE FND_API.G_EXC_ERROR;
132: END IF;

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

136: IF (p_qte_header_rec.last_update_date IS NOT NULL AND
137: p_qte_header_rec.last_update_date <> FND_API.G_MISS_DATE) AND
138: (C_Header_Info.last_update_date <> p_qte_header_rec.last_update_date) THEN
139: x_return_status := FND_API.G_RET_STS_ERROR;
140: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
141: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');
142: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
143: FND_MSG_PUB.ADD;
144: END IF;

Line 143: FND_MSG_PUB.ADD;

139: x_return_status := FND_API.G_RET_STS_ERROR;
140: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
141: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');
142: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
143: FND_MSG_PUB.ADD;
144: END IF;
145: RAISE FND_API.G_EXC_ERROR;
146: END IF;
147:

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

151: x_status => lx_return_status);
152:
153: IF (lx_return_status = FND_API.G_TRUE) THEN
154: x_return_status := FND_API.G_RET_STS_ERROR;
155: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
156: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
157: FND_MSG_PUB.ADD;
158: END IF;
159: RAISE FND_API.G_EXC_ERROR;

Line 157: FND_MSG_PUB.ADD;

153: IF (lx_return_status = FND_API.G_TRUE) THEN
154: x_return_status := FND_API.G_RET_STS_ERROR;
155: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
156: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
157: FND_MSG_PUB.ADD;
158: END IF;
159: RAISE FND_API.G_EXC_ERROR;
160: END IF;
161:

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

162: -- Check if ASO:Automatic Sales Assign and ASO:Auto Sales Credit Alloc are set
163: IF (l_auto_sales_team_prof <> 'FULL' AND l_auto_sales_team_prof <> 'PARTIAL') OR
164: (l_auto_sales_cred_prof <> 'FULL' AND l_auto_sales_cred_prof <> 'PARTIAL') THEN
165: x_return_status := FND_API.G_RET_STS_ERROR;
166: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
167: FND_MESSAGE.Set_Name('ASO', 'ASO_TEAM_CRED_PROF_NOT_SET');
168: FND_MSG_PUB.ADD;
169: END IF;
170: RAISE FND_API.G_EXC_ERROR;

Line 168: FND_MSG_PUB.ADD;

164: (l_auto_sales_cred_prof <> 'FULL' AND l_auto_sales_cred_prof <> 'PARTIAL') THEN
165: x_return_status := FND_API.G_RET_STS_ERROR;
166: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
167: FND_MESSAGE.Set_Name('ASO', 'ASO_TEAM_CRED_PROF_NOT_SET');
168: FND_MSG_PUB.ADD;
169: END IF;
170: RAISE FND_API.G_EXC_ERROR;
171: END IF;
172:

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

172:
173: -- Check if Resource_Id is passed
174: IF P_Resource_Id IS NULL OR P_Resource_Id = FND_API.G_MISS_NUM THEN
175: x_return_status := FND_API.G_RET_STS_ERROR;
176: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
177: FND_MESSAGE.Set_Name('ASO', 'ASO_NULL_RESOURCE');
178: FND_MSG_PUB.ADD;
179: END IF;
180: RAISE FND_API.G_EXC_ERROR;

Line 178: FND_MSG_PUB.ADD;

174: IF P_Resource_Id IS NULL OR P_Resource_Id = FND_API.G_MISS_NUM THEN
175: x_return_status := FND_API.G_RET_STS_ERROR;
176: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
177: FND_MESSAGE.Set_Name('ASO', 'ASO_NULL_RESOURCE');
178: FND_MSG_PUB.ADD;
179: END IF;
180: RAISE FND_API.G_EXC_ERROR;
181: END IF;
182:

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

192: END IF;
193:
194: IF l_found IS NULL OR l_found <> 'Y' THEN
195: x_return_status := FND_API.G_RET_STS_ERROR;
196: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
197: FND_MESSAGE.Set_Name('ASO', 'ASO_INV_RESOURCE');
198: FND_MSG_PUB.ADD;
199: END IF;
200: RAISE FND_API.G_EXC_ERROR;

Line 198: FND_MSG_PUB.ADD;

194: IF l_found IS NULL OR l_found <> 'Y' THEN
195: x_return_status := FND_API.G_RET_STS_ERROR;
196: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
197: FND_MESSAGE.Set_Name('ASO', 'ASO_INV_RESOURCE');
198: FND_MSG_PUB.ADD;
199: END IF;
200: RAISE FND_API.G_EXC_ERROR;
201: END IF;
202:

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

204: /* Removing the validation for fixing bug 5734955 - PKOKA
205: IF C_Header_Info.Quote_Expiration_Date IS NOT NULL AND
206: (trunc(SYSDATE) > trunc(C_Header_Info.Quote_Expiration_Date)) THEN
207: x_return_status := FND_API.G_RET_STS_ERROR;
208: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
209: FND_MESSAGE.Set_Name('ASO', 'ASO_QUOTE_EXPIRED');
210: FND_MSG_PUB.ADD;
211: END IF;
212: RAISE FND_API.G_EXC_ERROR;

Line 210: FND_MSG_PUB.ADD;

206: (trunc(SYSDATE) > trunc(C_Header_Info.Quote_Expiration_Date)) THEN
207: x_return_status := FND_API.G_RET_STS_ERROR;
208: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
209: FND_MESSAGE.Set_Name('ASO', 'ASO_QUOTE_EXPIRED');
210: FND_MSG_PUB.ADD;
211: END IF;
212: RAISE FND_API.G_EXC_ERROR;
213: END IF;
214: */

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

226: aso_debug_pub.add('Calc_Proj_Comm: l_ordered: '||l_ordered,1,'N');
227: END IF;
228: IF l_ordered IS NOT NULL AND l_ordered = 'Y' THEN
229: x_return_status := FND_API.G_RET_STS_ERROR;
230: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
231: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ORDERED_STATUS_TRANS');
232: FND_MSG_PUB.ADD;
233: END IF;
234: RAISE FND_API.G_EXC_ERROR;

Line 232: FND_MSG_PUB.ADD;

228: IF l_ordered IS NOT NULL AND l_ordered = 'Y' THEN
229: x_return_status := FND_API.G_RET_STS_ERROR;
230: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
231: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ORDERED_STATUS_TRANS');
232: FND_MSG_PUB.ADD;
233: END IF;
234: RAISE FND_API.G_EXC_ERROR;
235: END IF;
236:

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

237: -- Check if pricing status is Complete
238: IF C_Header_Info.Pricing_Status_Indicator IS NULL OR
239: C_Header_Info.Pricing_Status_Indicator <> 'C' THEN
240: x_return_status := FND_API.G_RET_STS_ERROR;
241: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
242: FND_MESSAGE.Set_Name('ASO', 'ASO_PRICING_INCOMPLETE');
243: FND_MSG_PUB.ADD;
244: END IF;
245: RAISE FND_API.G_EXC_ERROR;

Line 243: FND_MSG_PUB.ADD;

239: C_Header_Info.Pricing_Status_Indicator <> 'C' THEN
240: x_return_status := FND_API.G_RET_STS_ERROR;
241: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
242: FND_MESSAGE.Set_Name('ASO', 'ASO_PRICING_INCOMPLETE');
243: FND_MSG_PUB.ADD;
244: END IF;
245: RAISE FND_API.G_EXC_ERROR;
246: END IF;
247:

Line 387: FND_MSG_PUB.Count_And_Get

383: X_Out_Line_Number_Tbl => l_Out_Line_Number_Tbl );
384:
385:
386: -- Standard call to get message count and if count is 1, get message info.
387: FND_MSG_PUB.Count_And_Get
388: ( p_count => x_msg_count,
389: p_data => x_msg_data
390: );
391:

Line 401: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

397: WHEN FND_API.G_EXC_ERROR THEN
398: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
399: P_API_NAME => L_API_NAME,
400: P_PKG_NAME => G_PKG_NAME,
401: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
402: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
403: P_SQLCODE => SQLCODE,
404: P_SQLERRM => SQLERRM,
405: X_MSG_COUNT => X_MSG_COUNT,

Line 414: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

410: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
411: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
412: P_API_NAME => L_API_NAME,
413: P_PKG_NAME => G_PKG_NAME,
414: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
415: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
416: P_SQLCODE => SQLCODE,
417: P_SQLERRM => SQLERRM,
418: X_MSG_COUNT => X_MSG_COUNT,