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.AS_SALES_LEAD_OPP_PVT dependencies on FND_MSG_PUB

Line 276: l_debug := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

272: G_PKG_NAME)
273: THEN
274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
275: END IF;
276: l_debug := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
277: -- Initialize message list IF p_init_msg_list is set to TRUE.
278: IF FND_API.to_Boolean( p_init_msg_list )
279: THEN
280: FND_MSG_PUB.initialize;

Line 280: FND_MSG_PUB.initialize;

276: l_debug := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
277: -- Initialize message list IF p_init_msg_list is set to TRUE.
278: IF FND_API.to_Boolean( p_init_msg_list )
279: THEN
280: FND_MSG_PUB.initialize;
281: END IF;
282:
283: -- Debug Message
284:

Line 300: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

296: -- Validate Environment
297: -- ******************************************************************
298: IF FND_GLOBAL.User_Id IS NULL
299: THEN
300: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
301: THEN
302: AS_UTILITY_PVT.Set_Message(
303: p_module => l_module,
304: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 304: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

300: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
301: THEN
302: AS_UTILITY_PVT.Set_Message(
303: p_module => l_module,
304: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
305: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
306: p_token1 => 'PROFILE',
307: p_token1_value => 'USER_ID');
308: END IF;

Line 504: FND_MSG_PUB.Count_And_Get

500: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'PVT: ' || l_api_name || ' End');
501: END IF;
502:
503: -- Standard call to get message count and IF count is 1, get message info.
504: FND_MSG_PUB.Count_And_Get
505: ( p_count => x_msg_count,
506: p_data => x_msg_data );
507:
508: EXCEPTION

Line 514: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

510: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
511: P_MODULE => l_module
512: ,P_API_NAME => L_API_NAME
513: ,P_PKG_NAME => G_PKG_NAME
514: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
515: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
516: ,X_MSG_COUNT => X_MSG_COUNT
517: ,X_MSG_DATA => X_MSG_DATA
518: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 525: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

521: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
522: P_MODULE => l_module
523: ,P_API_NAME => L_API_NAME
524: ,P_PKG_NAME => G_PKG_NAME
525: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
526: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
527: ,X_MSG_COUNT => X_MSG_COUNT
528: ,X_MSG_DATA => X_MSG_DATA
529: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 844: l_debug := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

840: G_PKG_NAME)
841: THEN
842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
843: END IF;
844: l_debug := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
845:
846: -- Initialize message list IF p_init_msg_list is set to TRUE.
847: IF FND_API.to_Boolean( p_init_msg_list )
848: THEN

Line 849: FND_MSG_PUB.initialize;

845:
846: -- Initialize message list IF p_init_msg_list is set to TRUE.
847: IF FND_API.to_Boolean( p_init_msg_list )
848: THEN
849: FND_MSG_PUB.initialize;
850: END IF;
851:
852: -- Debug Message
853: IF l_debug THEN

Line 869: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

865: -- Validate Environment
866: -- ******************************************************************
867: IF FND_GLOBAL.User_Id IS NULL
868: THEN
869: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
870: THEN
871: AS_UTILITY_PVT.Set_Message(
872: p_module => l_module,
873: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 873: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

869: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
870: THEN
871: AS_UTILITY_PVT.Set_Message(
872: p_module => l_module,
873: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
874: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
875: p_token1 => 'PROFILE',
876: p_token1_value => 'USER_ID');
877: END IF;

Line 970: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

966: END IF;
967:
968: AS_UTILITY_PVT.Set_Message(
969: p_module => l_module,
970: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
971: p_msg_name => 'API_INVALID_ID',
972: p_token1 => 'COLUMN',
973: p_token1_value => 'SALES_LEAD_ID',
974: p_token2 => 'VALUE',

Line 1044: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1040: ,l_header_rec.parent_project;
1041: -- ,l_opp_security_group_id;
1042:
1043: IF ( C_Get_Opportunity%NOTFOUND) THEN
1044: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1045: THEN
1046: FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');
1047: FND_MESSAGE.Set_Token ('INFO', 'Opportunity', FALSE);
1048: FND_MSG_PUB.Add;

Line 1048: FND_MSG_PUB.Add;

1044: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1045: THEN
1046: FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');
1047: FND_MESSAGE.Set_Token ('INFO', 'Opportunity', FALSE);
1048: FND_MSG_PUB.Add;
1049: END IF;
1050: --commented for bug 2013040 raise FND_API.G_EXC_ERROR;
1051: x_return_status := FND_API.G_RET_STS_ERROR;
1052:

Line 1098: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1094: IF l_val IS NOT NULL
1095: THEN
1096: -- ffang 020301, we want the error message in every case, don't need
1097: -- to check message level.
1098: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1099: -- THEN
1100: -- ffang 100900: For bug 1448995
1101: -- Use error message #45661 instead of API_INVALID_ID
1102: FND_MESSAGE.Set_Name('AS', 'API_DUPLICATE_LINK');

Line 1105: FND_MSG_PUB.ADD;

1101: -- Use error message #45661 instead of API_INVALID_ID
1102: FND_MESSAGE.Set_Name('AS', 'API_DUPLICATE_LINK');
1103: FND_MESSAGE.Set_Token('SLD_ID', p_sales_lead_id, FALSE);
1104: -- end ffang 100900
1105: FND_MSG_PUB.ADD;
1106: -- END IF;
1107: x_return_status := FND_API.G_RET_STS_ERROR;
1108: END IF;
1109:

Line 1141: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1137: FETCH C_Get_Sales_Owner INTO l_val_id;
1138:
1139: IF C_Get_Sales_Owner%NOTFOUND
1140: THEN
1141: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1142: THEN
1143: -- ffang 100900: For bug 1448995
1144: -- Use error message #45662 instead of API_INVALID_ID
1145: FND_MESSAGE.Set_Name('AS', 'API_INVALID_OPP');

Line 1148: FND_MSG_PUB.ADD;

1144: -- Use error message #45662 instead of API_INVALID_ID
1145: FND_MESSAGE.Set_Name('AS', 'API_INVALID_OPP');
1146: FND_MESSAGE.Set_Token('OPP_ID', P_Opportunity_Id, FALSE);
1147: -- end ffang 100900
1148: FND_MSG_PUB.ADD;
1149: END IF;
1150:
1151: x_return_status := FND_API.G_RET_STS_ERROR;
1152: END IF;

Line 1538: FND_MSG_PUB.Count_And_Get

1534: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'PVT: ' || l_api_name || ' End');
1535: END IF;
1536:
1537: -- Standard call to get message count and IF count is 1, get message info.
1538: FND_MSG_PUB.Count_And_Get
1539: ( p_count => x_msg_count,
1540: p_data => x_msg_data );
1541:
1542: EXCEPTION

Line 1548: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1544: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1545: P_MODULE => l_module
1546: ,P_API_NAME => L_API_NAME
1547: ,P_PKG_NAME => G_PKG_NAME
1548: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1549: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1550: ,X_MSG_COUNT => X_MSG_COUNT
1551: ,X_MSG_DATA => X_MSG_DATA
1552: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1559: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1555: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1556: P_MODULE => l_module
1557: ,P_API_NAME => L_API_NAME
1558: ,P_PKG_NAME => G_PKG_NAME
1559: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1560: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1561: ,X_MSG_COUNT => X_MSG_COUNT
1562: ,X_MSG_DATA => X_MSG_DATA
1563: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1782: l_debug := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

1778: G_PKG_NAME)
1779: THEN
1780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1781: END IF;
1782: l_debug := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1783:
1784: -- Initialize message list IF p_init_msg_list is set to TRUE.
1785: IF FND_API.to_Boolean( p_init_msg_list )
1786: THEN

Line 1787: FND_MSG_PUB.initialize;

1783:
1784: -- Initialize message list IF p_init_msg_list is set to TRUE.
1785: IF FND_API.to_Boolean( p_init_msg_list )
1786: THEN
1787: FND_MSG_PUB.initialize;
1788: END IF;
1789:
1790: -- Debug Message
1791: IF l_debug THEN

Line 1808: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1804:
1805:
1806: IF FND_GLOBAL.User_Id IS NULL
1807: THEN
1808: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1809: THEN
1810: AS_UTILITY_PVT.Set_Message(
1811: p_module => l_module,
1812: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 1812: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1808: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1809: THEN
1810: AS_UTILITY_PVT.Set_Message(
1811: p_module => l_module,
1812: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1813: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
1814: p_token1 => 'PROFILE',
1815: p_token1_value => 'USER_ID');
1816: END IF;

Line 1909: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1905: END IF;
1906:
1907: AS_UTILITY_PVT.Set_Message(
1908: p_module => l_module,
1909: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1910: p_msg_name => 'API_INVALID_ID',
1911: p_token1 => 'COLUMN',
1912: p_token1_value => 'SALES_LEAD_ID',
1913: p_token2 => 'VALUE',

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

1979: ,l_header_rec.parent_project;
1980: -- ,l_opp_security_group_id;
1981:
1982: IF ( C_Get_Opportunity%NOTFOUND) THEN
1983: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1984: FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');
1985: FND_MESSAGE.Set_Token ('INFO', 'Opportunity', FALSE);
1986: FND_MSG_PUB.Add;
1987: END IF;

Line 1986: FND_MSG_PUB.Add;

1982: IF ( C_Get_Opportunity%NOTFOUND) THEN
1983: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1984: FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');
1985: FND_MESSAGE.Set_Token ('INFO', 'Opportunity', FALSE);
1986: FND_MSG_PUB.Add;
1987: END IF;
1988: -- commented by axavier for bug 2013040 raise FND_API.G_EXC_ERROR;
1989: x_return_status := FND_API.G_RET_STS_ERROR;
1990:

Line 2035: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

2031: IF l_val IS NOT NULL
2032: THEN
2033: -- ffang 020301, we want the error message in every case, don't need
2034: -- to check message level.
2035: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2036: -- THEN
2037: -- ffang 100900: For bug 1448995
2038: -- Use error message #45661 instead of API_INVALID_ID
2039: FND_MESSAGE.Set_Name('AS', 'API_DUPLICATE_LINK');

Line 2043: FND_MSG_PUB.ADD;

2039: FND_MESSAGE.Set_Name('AS', 'API_DUPLICATE_LINK');
2040: FND_MESSAGE.Set_Token('SLD_ID', p_sales_lead_id, FALSE);
2041: FND_MESSAGE.Set_Token('OPP_ID', p_opportunity_id, FALSE);
2042: -- end ffang 100900
2043: FND_MSG_PUB.ADD;
2044: -- END IF;
2045: x_return_status := FND_API.G_RET_STS_ERROR;
2046: END IF;
2047:

Line 2077: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

2073: FETCH C_Get_Sales_Owner INTO l_val_id;
2074:
2075: IF C_Get_Sales_Owner%NOTFOUND
2076: THEN
2077: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2078: THEN
2079: -- ffang 100900: For bug 1448995
2080: -- Use error message #45662 instead of API_INVALID_ID
2081: FND_MESSAGE.Set_Name('AS', 'API_INVALID_OPP');

Line 2084: FND_MSG_PUB.ADD;

2080: -- Use error message #45662 instead of API_INVALID_ID
2081: FND_MESSAGE.Set_Name('AS', 'API_INVALID_OPP');
2082: FND_MESSAGE.Set_Token('OPP_ID', P_Opportunity_Id, FALSE);
2083: -- end ffang 100900
2084: FND_MSG_PUB.ADD;
2085: END IF;
2086:
2087: x_return_status := FND_API.G_RET_STS_ERROR;
2088: END IF;

Line 2193: FND_MSG_PUB.Count_And_Get

2189: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'PVT: ' || l_api_name || ' End');
2190: END IF;
2191:
2192: -- Standard call to get message count and IF count is 1, get message info.
2193: FND_MSG_PUB.Count_And_Get
2194: ( p_count => x_msg_count,
2195: p_data => x_msg_data );
2196:
2197: EXCEPTION

Line 2203: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2199: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2200: P_MODULE => l_module
2201: ,P_API_NAME => L_API_NAME
2202: ,P_PKG_NAME => G_PKG_NAME
2203: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2204: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
2205: ,X_MSG_COUNT => X_MSG_COUNT
2206: ,X_MSG_DATA => X_MSG_DATA
2207: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2214: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2210: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2211: P_MODULE => l_module
2212: ,P_API_NAME => L_API_NAME
2213: ,P_PKG_NAME => G_PKG_NAME
2214: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2215: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
2216: ,X_MSG_COUNT => X_MSG_COUNT
2217: ,X_MSG_DATA => X_MSG_DATA
2218: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2531: l_debug := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

2527: G_PKG_NAME)
2528: THEN
2529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2530: END IF;
2531: l_debug := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
2532: l_debug_high := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
2533: l_debug_err := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR);
2534:
2535: -- Initialize message list IF p_init_msg_list is set to TRUE.

Line 2532: l_debug_high := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

2528: THEN
2529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2530: END IF;
2531: l_debug := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
2532: l_debug_high := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
2533: l_debug_err := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR);
2534:
2535: -- Initialize message list IF p_init_msg_list is set to TRUE.
2536: IF FND_API.to_Boolean( p_init_msg_list )

Line 2533: l_debug_err := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR);

2529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2530: END IF;
2531: l_debug := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
2532: l_debug_high := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
2533: l_debug_err := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR);
2534:
2535: -- Initialize message list IF p_init_msg_list is set to TRUE.
2536: IF FND_API.to_Boolean( p_init_msg_list )
2537: THEN

Line 2538: FND_MSG_PUB.initialize;

2534:
2535: -- Initialize message list IF p_init_msg_list is set to TRUE.
2536: IF FND_API.to_Boolean( p_init_msg_list )
2537: THEN
2538: FND_MSG_PUB.initialize;
2539: END IF;
2540:
2541: -- Debug Message
2542: IF l_debug THEN

Line 2559: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

2555: -- Validate Environment
2556: -- ******************************************************************
2557: IF FND_GLOBAL.User_Id IS NULL
2558: THEN
2559: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2560: THEN
2561: AS_UTILITY_PVT.Set_Message(
2562: p_module => l_module,
2563: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 2563: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

2559: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2560: THEN
2561: AS_UTILITY_PVT.Set_Message(
2562: p_module => l_module,
2563: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
2564: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
2565: p_token1 => 'PROFILE',
2566: p_token1_value => 'USER_ID');
2567: END IF;

Line 2646: FND_MSG_PUB.ADD;

2642: IF l_val IS NOT NULL
2643: THEN
2644: FND_MESSAGE.Set_Name('AS', 'API_DUPLICATE_LINK');
2645: FND_MESSAGE.Set_Token('SLD_ID', p_sales_lead_id, FALSE);
2646: FND_MSG_PUB.ADD;
2647: x_return_status := FND_API.G_RET_STS_ERROR;
2648: END IF;
2649:
2650: CLOSE C_Lead_Link_Exists;

Line 2735: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

2731: END IF;
2732:
2733: AS_UTILITY_PVT.Set_Message(
2734: p_module => l_module,
2735: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
2736: p_msg_name => 'API_INVALID_ID',
2737: p_token1 => 'COLUMN',
2738: p_token1_value => 'SALES_LEAD_ID',
2739: p_token2 => 'VALUE',

Line 3434: FND_MSG_PUB.Count_And_Get

3430: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'PVT: ' || l_api_name || ' End');
3431: END IF;
3432:
3433: -- Standard call to get message count and IF count is 1, get message info.
3434: FND_MSG_PUB.Count_And_Get
3435: ( p_count => x_msg_count,
3436: p_data => x_msg_data );
3437:
3438: EXCEPTION

Line 3444: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

3440: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3441: P_MODULE => l_module
3442: ,P_API_NAME => L_API_NAME
3443: ,P_PKG_NAME => G_PKG_NAME
3444: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3445: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
3446: ,X_MSG_COUNT => X_MSG_COUNT
3447: ,X_MSG_DATA => X_MSG_DATA
3448: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3455: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

3451: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3452: P_MODULE => l_module
3453: ,P_API_NAME => L_API_NAME
3454: ,P_PKG_NAME => G_PKG_NAME
3455: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3456: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
3457: ,X_MSG_COUNT => X_MSG_COUNT
3458: ,X_MSG_DATA => X_MSG_DATA
3459: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3588: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

3584: l_sales_methodology_id NUMBER := P_sales_lead_methodology_id;
3585: l_sales_stage_id NUMBER := P_sales_lead_stage_id;
3586: l_applicability VARCHAR2(100);
3587: l_api_name CONSTANT VARCHAR2(40) := 'CHECK_SALES_STAGE';
3588: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
3589: l_last_update_date date;
3590: l_module CONSTANT VARCHAR2(255) := 'as.plsql.slopv.CHECK_SALES_STAGE';
3591: BEGIN
3592: -- Standard Start of API savepoint

Line 3599: FND_MSG_PUB.initialize;

3595: x_return_status := FND_API.G_RET_STS_SUCCESS;
3596: -- Initialize message list if p_init_msg_list is set to TRUE.
3597: IF FND_API.to_Boolean( p_init_msg_list )
3598: THEN
3599: FND_MSG_PUB.initialize;
3600: END IF;
3601:
3602: l_sales_methodology_id := P_sales_lead_methodology_id;
3603: l_sales_stage_id := P_sales_lead_stage_id;

Line 3625: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

3621: FETCH c_first_sales_stage INTO l_sales_stage_id;
3622: IF c_first_sales_stage%NOTFOUND THEN
3623: AS_UTILITY_PVT.Set_Message(
3624: p_module => l_module,
3625: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
3626: p_msg_name => 'AS_STAGE_NOT_SETUP_FOR_METH');
3627: x_return_status :=FND_API.G_RET_STS_ERROR;
3628: END IF;
3629: CLOSE c_first_sales_stage;

Line 3640: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

3636: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3637: P_MODULE => l_module
3638: ,P_API_NAME => L_API_NAME
3639: ,P_PKG_NAME => G_PKG_NAME
3640: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3641: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
3642: ,X_MSG_COUNT => X_MSG_COUNT
3643: ,X_MSG_DATA => X_MSG_DATA
3644: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3651: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

3647: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3648: P_MODULE => l_module
3649: ,P_API_NAME => L_API_NAME
3650: ,P_PKG_NAME => G_PKG_NAME
3651: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3652: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
3653: ,X_MSG_COUNT => X_MSG_COUNT
3654: ,X_MSG_DATA => X_MSG_DATA
3655: ,X_RETURN_STATUS => X_RETURN_STATUS);