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

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

28: l_salesforce_id NUMBER;
29: l_sales_group_id NUMBER;
30: l_person_id NUMBER;
31: l_api_name CONSTANT VARCHAR2(30) := 'RECONCILE_SALESCREDIT';
32: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
33: BEGIN
34: -- Standard Start of API savepoint
35: SAVEPOINT RECONCILE_SALESCREDIT_PVT;
36:

Line 49: FND_MSG_PUB.ADD;

45: AND OWNER_FLAG = 'Y';
46: EXCEPTION
47: WHEN NO_DATA_FOUND OR TOO_MANY_ROWS THEN
48: FND_MESSAGE.Set_Name('AST', 'AST_ASN_INTEROP_MUST_OWNER');
49: FND_MSG_PUB.ADD;
50: RAISE FND_API.G_EXC_ERROR;
51: END;
52:
53: IF nvl(x_return_status,'N') <> 'E' THEN

Line 56: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

52:
53: IF nvl(x_return_status,'N') <> 'E' THEN
54: -- Debug Message
55: IF l_debug THEN
56: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
57: 'Sales Force Id: ' || l_salesforce_id || ' Sales Group Id :' || l_sales_group_id ||' Person id :'||l_person_id );
58: END IF;
59: UPDATE AS_SALES_CREDITS
60: SET SALESFORCE_ID = l_salesforce_id,

Line 94: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

90: WHEN FND_API.G_EXC_ERROR THEN
91: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
92: P_API_NAME => L_API_NAME
93: ,P_PKG_NAME => G_PKG_NAME
94: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
95: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
96: ,X_MSG_COUNT => X_MSG_COUNT
97: ,X_MSG_DATA => X_MSG_DATA
98: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 104: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
101: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
102: P_API_NAME => L_API_NAME
103: ,P_PKG_NAME => G_PKG_NAME
104: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
105: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
106: ,X_MSG_COUNT => X_MSG_COUNT
107: ,X_MSG_DATA => X_MSG_DATA
108: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

153: l_sales_methodology_id NUMBER;
154: l_sales_stage_id NUMBER;
155: l_applicability VARCHAR2(100);
156: l_api_name CONSTANT VARCHAR2(40) := 'CHECK_SALES_STAGE';
157: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
158: l_last_update_date date;
159: BEGIN
160: -- Standard Start of API savepoint
161: SAVEPOINT CHECK_SALES_STAGE_PVT;

Line 167: FND_MSG_PUB.initialize;

163: x_return_status := FND_API.G_RET_STS_SUCCESS;
164: -- Initialize message list if p_init_msg_list is set to TRUE.
165: IF FND_API.to_Boolean( p_init_msg_list )
166: THEN
167: FND_MSG_PUB.initialize;
168: END IF;
169: OPEN c_lead(p_sales_lead_id);
170: FETCH c_lead INTO l_sales_methodology_id,l_sales_stage_id;
171: CLOSE c_lead;

Line 187: FND_MSG_PUB.ADD;

183: IF c_first_sales_stage%NOTFOUND THEN
184: x_return_status :='E';
185: CLOSE c_first_sales_stage;
186: FND_MESSAGE.Set_Name('AST', 'AST_STAGE_NOT_SETUP_FOR_METH');
187: FND_MSG_PUB.ADD;
188: RAISE FND_API.G_EXC_ERROR;
189: END IF;
190: CLOSE c_first_sales_stage;
191: END IF;

Line 200: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

196: WHEN FND_API.G_EXC_ERROR THEN
197: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
198: P_API_NAME => L_API_NAME
199: ,P_PKG_NAME => G_PKG_NAME
200: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
201: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
202: ,X_MSG_COUNT => X_MSG_COUNT
203: ,X_MSG_DATA => X_MSG_DATA
204: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 210: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
207: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
208: P_API_NAME => L_API_NAME
209: ,P_PKG_NAME => G_PKG_NAME
210: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
211: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
212: ,X_MSG_COUNT => X_MSG_COUNT
213: ,X_MSG_DATA => X_MSG_DATA
214: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

249: where lead_id = p_lead_id;
250:
251: l_api_name CONSTANT VARCHAR2(40) := 'RECONCILE_SALESMETHODOLOGY';
252: header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type;
253: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
254: l_lead_id NUMBER;
255: l_last_update_date date;
256: BEGIN
257: -- Standard Start of API savepoint

Line 274: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

270: header_rec.owner_salesforce_id := P_Identity_Salesforce_Id;
271: header_rec.owner_sales_group_id := P_identity_salesgroup_id;
272: header_rec.last_update_date := l_last_update_date;
273: IF l_debug THEN
274: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
275: 'Before calling Update opp Header Lead id : ' || p_lead_id ||' Sales Force id :'|| P_Identity_Salesforce_Id ||
276: ' Sales Group Id :' || P_identity_salesgroup_id ||
277: ' Sales Methodology id :'||p_sales_methodology_id );
278: END IF;

Line 305: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

301: WHEN FND_API.G_EXC_ERROR THEN
302: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
303: P_API_NAME => L_API_NAME
304: ,P_PKG_NAME => G_PKG_NAME
305: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
306: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
307: ,X_MSG_COUNT => X_MSG_COUNT
308: ,X_MSG_DATA => X_MSG_DATA
309: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 315: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
312: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
313: P_API_NAME => L_API_NAME
314: ,P_PKG_NAME => G_PKG_NAME
315: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
316: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
317: ,X_MSG_COUNT => X_MSG_COUNT
318: ,X_MSG_DATA => X_MSG_DATA
319: ,X_RETURN_STATUS => X_RETURN_STATUS);