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 476: FND_MSG_PUB.initialize;

472:
473: -- Initialize message list if p_init_msg_list is set to TRUE.
474: IF FND_API.to_Boolean( p_init_msg_list )
475: THEN
476: FND_MSG_PUB.initialize;
477: END IF;
478:
479: -- Initialize API return status to SUCCESS
480: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

503: FETCH C_Quote_Exists INTO l_Exists_Flag;
504: IF (C_Quote_Exists%NOTFOUND) OR l_Exists_Flag <> 'Y' THEN
505: CLOSE C_Quote_Exists;
506: x_return_status := FND_API.G_RET_STS_ERROR;
507: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
508: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
509: FND_MESSAGE.Set_Token('COLUMN', 'ORIGINAL_QUOTE_ID', FALSE);
510: FND_MESSAGE.Set_Token('VALUE', TO_CHAR(p_qte_header_rec.quote_header_id), FALSE);
511: FND_MSG_PUB.ADD;

Line 511: FND_MSG_PUB.ADD;

507: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
508: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
509: FND_MESSAGE.Set_Token('COLUMN', 'ORIGINAL_QUOTE_ID', FALSE);
510: FND_MESSAGE.Set_Token('VALUE', TO_CHAR(p_qte_header_rec.quote_header_id), FALSE);
511: FND_MSG_PUB.ADD;
512: END IF;
513: RAISE FND_API.G_EXC_ERROR;
514: END IF;
515: CLOSE C_Quote_Exists;

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

521:
522: IF (C_Get_Update_Date%NOTFOUND) OR
523: (l_last_upd_date IS NULL OR l_last_upd_date = FND_API.G_MISS_DATE) THEN
524: x_return_status := FND_API.G_RET_STS_ERROR;
525: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
526: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
527: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
528: FND_MSG_PUB.ADD;
529: END IF;

Line 528: FND_MSG_PUB.ADD;

524: x_return_status := FND_API.G_RET_STS_ERROR;
525: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
526: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
527: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
528: FND_MSG_PUB.ADD;
529: END IF;
530: CLOSE C_Get_Update_Date;
531: RAISE FND_API.G_EXC_ERROR;
532: END IF;

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

536: IF (p_qte_header_rec.last_update_date IS NOT NULL AND
537: p_qte_header_rec.last_update_date <> FND_API.G_MISS_DATE) AND
538: (l_last_upd_date <> p_qte_header_rec.last_update_date) THEN
539: x_return_status := FND_API.G_RET_STS_ERROR;
540: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
541: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');
542: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
543: FND_MSG_PUB.ADD;
544: END IF;

Line 543: FND_MSG_PUB.ADD;

539: x_return_status := FND_API.G_RET_STS_ERROR;
540: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
541: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');
542: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
543: FND_MSG_PUB.ADD;
544: END IF;
545: RAISE FND_API.G_EXC_ERROR;
546: END IF;
547: -- End: Check Whether record has been changed

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

552: x_status => lx_return_status);
553:
554: IF (lx_return_status = FND_API.G_TRUE) THEN
555: x_return_status := FND_API.G_RET_STS_ERROR;
556: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
557: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
558: FND_MSG_PUB.ADD;
559: END IF;
560: RAISE FND_API.G_EXC_ERROR;

Line 558: FND_MSG_PUB.ADD;

554: IF (lx_return_status = FND_API.G_TRUE) THEN
555: x_return_status := FND_API.G_RET_STS_ERROR;
556: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
557: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
558: FND_MSG_PUB.ADD;
559: END IF;
560: RAISE FND_API.G_EXC_ERROR;
561: END IF;
562: -- End: Check if a concurrent lock exists

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

626: END IF;
627:
628: IF nvl(lx_gen_return_Rec.resource_id.count,0) = 0 THEN
629: IF P_Operation <> 'CREATE' AND P_Operation <> 'UPDATE' AND P_Operation <> 'SUBMIT' THEN
630: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
631: FND_MESSAGE.Set_Name('ASO', 'ASO_NO_SALES_TEAM');
632: FND_MSG_PUB.ADD;
633: END IF;
634: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 632: FND_MSG_PUB.ADD;

628: IF nvl(lx_gen_return_Rec.resource_id.count,0) = 0 THEN
629: IF P_Operation <> 'CREATE' AND P_Operation <> 'UPDATE' AND P_Operation <> 'SUBMIT' THEN
630: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
631: FND_MESSAGE.Set_Name('ASO', 'ASO_NO_SALES_TEAM');
632: FND_MSG_PUB.ADD;
633: END IF;
634: IF aso_debug_pub.g_debug_flag = 'Y' THEN
635: aso_debug_pub.add('After ASO_SALES_TEAM_PVT Added MSG: ',1,'Y');
636: END IF;

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

862: aso_debug_pub.add('nores:create:Assign_Sales_Team: Default SalesGrp: '||l_primary_res_grp,1,'N');
863: END IF;
864: ELSE
865: x_return_status := FND_API.G_RET_STS_ERROR;
866: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
867:
868: -- Created new message to display the error message more appropriately - Girish Bug 4654938
869: -- FND_MESSAGE.Set_Name('ASO', 'ASO_API_NO_PROFILE_VALUE');
870: -- FND_MESSAGE.Set_Token('PROFILE', 'ASO_DEFAULT_PERSON_ID', FALSE);

Line 874: FND_MSG_PUB.Add;

870: -- FND_MESSAGE.Set_Token('PROFILE', 'ASO_DEFAULT_PERSON_ID', FALSE);
871: FND_MESSAGE.Set_Name('ASO', 'ASO_NO_DEFAULT_VALUE');
872: FND_MESSAGE.Set_Token('PROFILE', 'ASO_DEFAULT_SALESREP', TRUE);
873:
874: FND_MSG_PUB.Add;
875: END IF;
876: RAISE FND_API.G_EXC_ERROR;
877: END IF; -- salesrep_prof
878:

Line 1459: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

1455: WHEN FND_API.G_EXC_ERROR THEN
1456: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1457: P_API_NAME => L_API_NAME,
1458: P_PKG_NAME => G_PKG_NAME,
1459: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
1460: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1461: P_SQLCODE => SQLCODE,
1462: P_SQLERRM => SQLERRM,
1463: X_MSG_COUNT => X_MSG_COUNT,

Line 1472: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

1468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1469: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1470: P_API_NAME => L_API_NAME,
1471: P_PKG_NAME => G_PKG_NAME,
1472: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1473: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1474: P_SQLCODE => SQLCODE,
1475: P_SQLERRM => SQLERRM,
1476: X_MSG_COUNT => X_MSG_COUNT,

Line 1686: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

1682: WHEN FND_API.G_EXC_ERROR THEN
1683: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1684: P_API_NAME => L_API_NAME,
1685: P_PKG_NAME => G_PKG_NAME,
1686: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
1687: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1688: P_SQLCODE => SQLCODE,
1689: P_SQLERRM => SQLERRM,
1690: X_MSG_COUNT => X_MSG_COUNT,

Line 1699: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

1695: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1696: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1697: P_API_NAME => L_API_NAME,
1698: P_PKG_NAME => G_PKG_NAME,
1699: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1700: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1701: P_SQLCODE => SQLCODE,
1702: P_SQLERRM => SQLERRM,
1703: X_MSG_COUNT => X_MSG_COUNT,

Line 1952: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

1948: WHEN FND_API.G_EXC_ERROR THEN
1949: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1950: P_API_NAME => L_API_NAME,
1951: P_PKG_NAME => G_PKG_NAME,
1952: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
1953: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1954: P_SQLCODE => SQLCODE,
1955: P_SQLERRM => SQLERRM,
1956: X_MSG_COUNT => X_MSG_COUNT,

Line 1965: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

1961: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1962: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1963: P_API_NAME => L_API_NAME,
1964: P_PKG_NAME => G_PKG_NAME,
1965: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1966: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1967: P_SQLCODE => SQLCODE,
1968: P_SQLERRM => SQLERRM,
1969: X_MSG_COUNT => X_MSG_COUNT,

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

2149: aso_debug_pub.add('Assign_Sales_Team: Default SalesRep: '||l_primary_salesagent,1,'N');
2150: END IF;
2151: ELSE
2152: x_return_status := FND_API.G_RET_STS_ERROR;
2153: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2154: -- Created new message to display the error message more appropriately - Girish Bug 4654938
2155: -- FND_MESSAGE.Set_Name('ASO', 'ASO_API_NO_PROFILE_VALUE');
2156: -- FND_MESSAGE.Set_Token('PROFILE', 'ASO_DEFAULT_PERSON_ID', FALSE);
2157: FND_MESSAGE.Set_Name('ASO', 'ASO_NO_DEFAULT_VALUE');

Line 2160: FND_MSG_PUB.Add;

2156: -- FND_MESSAGE.Set_Token('PROFILE', 'ASO_DEFAULT_PERSON_ID', FALSE);
2157: FND_MESSAGE.Set_Name('ASO', 'ASO_NO_DEFAULT_VALUE');
2158: FND_MESSAGE.Set_Token('PROFILE', 'ASO_DEFAULT_SALESREP', TRUE);
2159:
2160: FND_MSG_PUB.Add;
2161: END IF;
2162: RAISE FND_API.G_EXC_ERROR;
2163: END IF; -- salesrep_prof
2164:

Line 2332: FND_MSG_PUB.Count_And_Get

2328: INTO x_qte_header_rec.Quote_Header_Id, x_qte_header_rec.Last_Update_Date,
2329: x_qte_header_rec.resource_id, x_qte_header_rec.resource_grp_id, x_qte_header_rec.object_version_number;
2330:
2331: -- Standard call to get message count and if count is 1, get message info.
2332: FND_MSG_PUB.Count_And_Get
2333: ( p_count => x_msg_count,
2334: p_data => x_msg_data
2335: );
2336:

Line 2343: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

2339: WHEN FND_API.G_EXC_ERROR THEN
2340: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2341: P_API_NAME => L_API_NAME,
2342: P_PKG_NAME => G_PKG_NAME,
2343: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
2344: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
2345: P_SQLCODE => SQLCODE,
2346: P_SQLERRM => SQLERRM,
2347: X_MSG_COUNT => X_MSG_COUNT,

Line 2356: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

2352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2353: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2354: P_API_NAME => L_API_NAME,
2355: P_PKG_NAME => G_PKG_NAME,
2356: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
2357: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
2358: P_SQLCODE => SQLCODE,
2359: P_SQLERRM => SQLERRM,
2360: X_MSG_COUNT => X_MSG_COUNT,

Line 2519: FND_MSG_PUB.initialize;

2515:
2516: -- Initialize message list if p_init_msg_list is set to TRUE.
2517: IF FND_API.to_Boolean( p_init_msg_list )
2518: THEN
2519: FND_MSG_PUB.initialize;
2520: END IF;
2521:
2522: -- Initialize API return status to SUCCESS
2523: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2736: aso_debug_pub.add('Opp_Qte_PS: Default SalesRep: '||l_primary_salesagent,1,'N');
2737: END IF;
2738: ELSE
2739: x_return_status := FND_API.G_RET_STS_ERROR;
2740: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2741:
2742: -- Created new message to display the error message more appropriately - Girish Bug 4654938
2743: -- FND_MESSAGE.Set_Name('ASO', 'ASO_API_NO_PROFILE_VALUE');
2744: -- FND_MESSAGE.Set_Token('PROFILE', 'ASO_DEFAULT_PERSON_ID', FALSE);

Line 2748: FND_MSG_PUB.Add;

2744: -- FND_MESSAGE.Set_Token('PROFILE', 'ASO_DEFAULT_PERSON_ID', FALSE);
2745: FND_MESSAGE.Set_Name('ASO', 'ASO_NO_DEFAULT_VALUE');
2746: FND_MESSAGE.Set_Token('PROFILE', 'ASO_DEFAULT_SALESREP', TRUE);
2747:
2748: FND_MSG_PUB.Add;
2749: END IF;
2750: RAISE FND_API.G_EXC_ERROR;
2751: END IF; -- salesrep_prof
2752:

Line 2910: FND_MSG_PUB.Count_And_Get

2906: INTO x_qte_header_rec.Quote_Header_Id, x_qte_header_rec.Last_Update_Date,
2907: x_qte_header_rec.resource_id, x_qte_header_rec.resource_grp_id, x_qte_header_rec.object_version_number;
2908:
2909: -- Standard call to get message count and if count is 1, get message info.
2910: FND_MSG_PUB.Count_And_Get
2911: ( p_count => x_msg_count,
2912: p_data => x_msg_data
2913: );
2914:

Line 2921: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

2917: WHEN FND_API.G_EXC_ERROR THEN
2918: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2919: P_API_NAME => L_API_NAME,
2920: P_PKG_NAME => G_PKG_NAME,
2921: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
2922: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
2923: P_SQLCODE => SQLCODE,
2924: P_SQLERRM => SQLERRM,
2925: X_MSG_COUNT => X_MSG_COUNT,

Line 2934: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

2930: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2931: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2932: P_API_NAME => L_API_NAME,
2933: P_PKG_NAME => G_PKG_NAME,
2934: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
2935: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
2936: P_SQLCODE => SQLCODE,
2937: P_SQLERRM => SQLERRM,
2938: X_MSG_COUNT => X_MSG_COUNT,