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_SALES_TEAM_PVT dependencies on FND_MSG_PUB

Line 199: FND_MSG_PUB.initialize;

195:
196: -- Initialize message list if p_init_msg_list is set to TRUE.
197: IF FND_API.to_Boolean( p_init_msg_list )
198: THEN
199: FND_MSG_PUB.initialize;
200: END IF;
201:
202: -- Initialize API return status to SUCCESS
203: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

226: FETCH C_Quote_Exists INTO l_Exists_Flag;
227: IF (C_Quote_Exists%NOTFOUND) OR l_Exists_Flag <> 'Y' THEN
228: CLOSE C_Quote_Exists;
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_INVALID_ID');
232: FND_MESSAGE.Set_Token('COLUMN', 'ORIGINAL_QUOTE_ID', FALSE);
233: FND_MESSAGE.Set_Token('VALUE', TO_CHAR(p_qte_header_rec.quote_header_id), FALSE);
234: FND_MSG_PUB.ADD;

Line 234: FND_MSG_PUB.ADD;

230: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
231: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
232: FND_MESSAGE.Set_Token('COLUMN', 'ORIGINAL_QUOTE_ID', FALSE);
233: FND_MESSAGE.Set_Token('VALUE', TO_CHAR(p_qte_header_rec.quote_header_id), FALSE);
234: FND_MSG_PUB.ADD;
235: END IF;
236: RAISE FND_API.G_EXC_ERROR;
237: END IF;
238: CLOSE C_Quote_Exists;

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

244:
245: IF (C_Get_Update_Date%NOTFOUND) OR
246: (l_last_upd_date IS NULL OR l_last_upd_date = FND_API.G_MISS_DATE) THEN
247: x_return_status := FND_API.G_RET_STS_ERROR;
248: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
249: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
250: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
251: FND_MSG_PUB.ADD;
252: END IF;

Line 251: FND_MSG_PUB.ADD;

247: x_return_status := FND_API.G_RET_STS_ERROR;
248: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
249: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
250: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
251: FND_MSG_PUB.ADD;
252: END IF;
253: CLOSE C_Get_Update_Date;
254: RAISE FND_API.G_EXC_ERROR;
255: END IF;

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

259: IF (p_qte_header_rec.last_update_date IS NOT NULL AND
260: p_qte_header_rec.last_update_date <> FND_API.G_MISS_DATE) AND
261: (l_last_upd_date <> p_qte_header_rec.last_update_date) THEN
262: x_return_status := FND_API.G_RET_STS_ERROR;
263: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
264: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');
265: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
266: FND_MSG_PUB.ADD;
267: END IF;

Line 266: FND_MSG_PUB.ADD;

262: x_return_status := FND_API.G_RET_STS_ERROR;
263: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
264: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');
265: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
266: FND_MSG_PUB.ADD;
267: END IF;
268: RAISE FND_API.G_EXC_ERROR;
269: END IF;
270: -- End: Check Whether record has been changed

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

275: x_status => lx_return_status);
276:
277: IF (lx_return_status = FND_API.G_TRUE) THEN
278: x_return_status := FND_API.G_RET_STS_ERROR;
279: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
280: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
281: FND_MSG_PUB.ADD;
282: END IF;
283: RAISE FND_API.G_EXC_ERROR;

Line 281: FND_MSG_PUB.ADD;

277: IF (lx_return_status = FND_API.G_TRUE) THEN
278: x_return_status := FND_API.G_RET_STS_ERROR;
279: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
280: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
281: FND_MSG_PUB.ADD;
282: END IF;
283: RAISE FND_API.G_EXC_ERROR;
284: END IF;
285: -- End: Check if a concurrent lock exists

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

335: END IF;
336:
337: IF nvl(lx_gen_return_Rec.resource_id.count,0) = 0 THEN
338: IF P_Operation <> 'CREATE' AND P_Operation <> 'UPDATE' AND P_Operation <> 'SUBMIT' THEN
339: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
340: FND_MESSAGE.Set_Name('ASO', 'ASO_NO_SALES_TEAM');
341: FND_MSG_PUB.ADD;
342: END IF;
343: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 341: FND_MSG_PUB.ADD;

337: IF nvl(lx_gen_return_Rec.resource_id.count,0) = 0 THEN
338: IF P_Operation <> 'CREATE' AND P_Operation <> 'UPDATE' AND P_Operation <> 'SUBMIT' THEN
339: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
340: FND_MESSAGE.Set_Name('ASO', 'ASO_NO_SALES_TEAM');
341: FND_MSG_PUB.ADD;
342: END IF;
343: IF aso_debug_pub.g_debug_flag = 'Y' THEN
344: aso_debug_pub.add('After ASO_SALES_TEAM_PVT Added MSG: ',1,'Y');
345: END IF;

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

571: aso_debug_pub.add('nores:create:Assign_Sales_Team: Default SalesGrp: '||l_primary_res_grp,1,'N');
572: END IF;
573: ELSE
574: x_return_status := FND_API.G_RET_STS_ERROR;
575: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
576:
577: -- Created new message to display the error message more appropriately - Girish Bug 4654938
578: -- FND_MESSAGE.Set_Name('ASO', 'ASO_API_NO_PROFILE_VALUE');
579: -- FND_MESSAGE.Set_Token('PROFILE', 'ASO_DEFAULT_PERSON_ID', FALSE);

Line 583: FND_MSG_PUB.Add;

579: -- FND_MESSAGE.Set_Token('PROFILE', 'ASO_DEFAULT_PERSON_ID', FALSE);
580: FND_MESSAGE.Set_Name('ASO', 'ASO_NO_DEFAULT_VALUE');
581: FND_MESSAGE.Set_Token('PROFILE', 'ASO_DEFAULT_SALESREP', TRUE);
582:
583: FND_MSG_PUB.Add;
584: END IF;
585: RAISE FND_API.G_EXC_ERROR;
586: END IF; -- salesrep_prof
587:

Line 1165: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

1161: WHEN FND_API.G_EXC_ERROR THEN
1162: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1163: P_API_NAME => L_API_NAME,
1164: P_PKG_NAME => G_PKG_NAME,
1165: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
1166: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1167: P_SQLCODE => SQLCODE,
1168: P_SQLERRM => SQLERRM,
1169: X_MSG_COUNT => X_MSG_COUNT,

Line 1178: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

1174: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1175: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1176: P_API_NAME => L_API_NAME,
1177: P_PKG_NAME => G_PKG_NAME,
1178: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1179: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1180: P_SQLCODE => SQLCODE,
1181: P_SQLERRM => SQLERRM,
1182: X_MSG_COUNT => X_MSG_COUNT,

Line 1392: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

1388: WHEN FND_API.G_EXC_ERROR THEN
1389: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1390: P_API_NAME => L_API_NAME,
1391: P_PKG_NAME => G_PKG_NAME,
1392: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
1393: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1394: P_SQLCODE => SQLCODE,
1395: P_SQLERRM => SQLERRM,
1396: X_MSG_COUNT => X_MSG_COUNT,

Line 1405: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

1401: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1402: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1403: P_API_NAME => L_API_NAME,
1404: P_PKG_NAME => G_PKG_NAME,
1405: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1406: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1407: P_SQLCODE => SQLCODE,
1408: P_SQLERRM => SQLERRM,
1409: X_MSG_COUNT => X_MSG_COUNT,

Line 1513: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

1509: WHEN FND_API.G_EXC_ERROR THEN
1510: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1511: P_API_NAME => L_API_NAME,
1512: P_PKG_NAME => G_PKG_NAME,
1513: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
1514: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1515: P_SQLCODE => SQLCODE,
1516: P_SQLERRM => SQLERRM,
1517: X_MSG_COUNT => X_MSG_COUNT,

Line 1526: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

1522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1523: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1524: P_API_NAME => L_API_NAME,
1525: P_PKG_NAME => G_PKG_NAME,
1526: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1527: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1528: P_SQLCODE => SQLCODE,
1529: P_SQLERRM => SQLERRM,
1530: X_MSG_COUNT => X_MSG_COUNT,

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

1710: aso_debug_pub.add('Assign_Sales_Team: Default SalesRep: '||l_primary_salesagent,1,'N');
1711: END IF;
1712: ELSE
1713: x_return_status := FND_API.G_RET_STS_ERROR;
1714: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1715: -- Created new message to display the error message more appropriately - Girish Bug 4654938
1716: -- FND_MESSAGE.Set_Name('ASO', 'ASO_API_NO_PROFILE_VALUE');
1717: -- FND_MESSAGE.Set_Token('PROFILE', 'ASO_DEFAULT_PERSON_ID', FALSE);
1718: FND_MESSAGE.Set_Name('ASO', 'ASO_NO_DEFAULT_VALUE');

Line 1721: FND_MSG_PUB.Add;

1717: -- FND_MESSAGE.Set_Token('PROFILE', 'ASO_DEFAULT_PERSON_ID', FALSE);
1718: FND_MESSAGE.Set_Name('ASO', 'ASO_NO_DEFAULT_VALUE');
1719: FND_MESSAGE.Set_Token('PROFILE', 'ASO_DEFAULT_SALESREP', TRUE);
1720:
1721: FND_MSG_PUB.Add;
1722: END IF;
1723: RAISE FND_API.G_EXC_ERROR;
1724: END IF; -- salesrep_prof
1725:

Line 1893: FND_MSG_PUB.Count_And_Get

1889: INTO x_qte_header_rec.Quote_Header_Id, x_qte_header_rec.Last_Update_Date,
1890: x_qte_header_rec.resource_id, x_qte_header_rec.resource_grp_id, x_qte_header_rec.object_version_number;
1891:
1892: -- Standard call to get message count and if count is 1, get message info.
1893: FND_MSG_PUB.Count_And_Get
1894: ( p_count => x_msg_count,
1895: p_data => x_msg_data
1896: );
1897:

Line 1904: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

1900: WHEN FND_API.G_EXC_ERROR THEN
1901: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1902: P_API_NAME => L_API_NAME,
1903: P_PKG_NAME => G_PKG_NAME,
1904: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
1905: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1906: P_SQLCODE => SQLCODE,
1907: P_SQLERRM => SQLERRM,
1908: X_MSG_COUNT => X_MSG_COUNT,

Line 1917: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

1913: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1914: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1915: P_API_NAME => L_API_NAME,
1916: P_PKG_NAME => G_PKG_NAME,
1917: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1918: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1919: P_SQLCODE => SQLCODE,
1920: P_SQLERRM => SQLERRM,
1921: X_MSG_COUNT => X_MSG_COUNT,

Line 2080: FND_MSG_PUB.initialize;

2076:
2077: -- Initialize message list if p_init_msg_list is set to TRUE.
2078: IF FND_API.to_Boolean( p_init_msg_list )
2079: THEN
2080: FND_MSG_PUB.initialize;
2081: END IF;
2082:
2083: -- Initialize API return status to SUCCESS
2084: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2297: aso_debug_pub.add('Opp_Qte_PS: Default SalesRep: '||l_primary_salesagent,1,'N');
2298: END IF;
2299: ELSE
2300: x_return_status := FND_API.G_RET_STS_ERROR;
2301: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2302:
2303: -- Created new message to display the error message more appropriately - Girish Bug 4654938
2304: -- FND_MESSAGE.Set_Name('ASO', 'ASO_API_NO_PROFILE_VALUE');
2305: -- FND_MESSAGE.Set_Token('PROFILE', 'ASO_DEFAULT_PERSON_ID', FALSE);

Line 2309: FND_MSG_PUB.Add;

2305: -- FND_MESSAGE.Set_Token('PROFILE', 'ASO_DEFAULT_PERSON_ID', FALSE);
2306: FND_MESSAGE.Set_Name('ASO', 'ASO_NO_DEFAULT_VALUE');
2307: FND_MESSAGE.Set_Token('PROFILE', 'ASO_DEFAULT_SALESREP', TRUE);
2308:
2309: FND_MSG_PUB.Add;
2310: END IF;
2311: RAISE FND_API.G_EXC_ERROR;
2312: END IF; -- salesrep_prof
2313:

Line 2471: FND_MSG_PUB.Count_And_Get

2467: INTO x_qte_header_rec.Quote_Header_Id, x_qte_header_rec.Last_Update_Date,
2468: x_qte_header_rec.resource_id, x_qte_header_rec.resource_grp_id, x_qte_header_rec.object_version_number;
2469:
2470: -- Standard call to get message count and if count is 1, get message info.
2471: FND_MSG_PUB.Count_And_Get
2472: ( p_count => x_msg_count,
2473: p_data => x_msg_data
2474: );
2475:

Line 2482: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

2478: WHEN FND_API.G_EXC_ERROR THEN
2479: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2480: P_API_NAME => L_API_NAME,
2481: P_PKG_NAME => G_PKG_NAME,
2482: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
2483: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
2484: P_SQLCODE => SQLCODE,
2485: P_SQLERRM => SQLERRM,
2486: X_MSG_COUNT => X_MSG_COUNT,

Line 2495: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

2491: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2492: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2493: P_API_NAME => L_API_NAME,
2494: P_PKG_NAME => G_PKG_NAME,
2495: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
2496: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
2497: P_SQLCODE => SQLCODE,
2498: P_SQLERRM => SQLERRM,
2499: X_MSG_COUNT => X_MSG_COUNT,