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

Line 75: FND_MSG_PUB.initialize;

71:
72:
73: -- Initialize message list if p_init_msg_list is set to TRUE.
74: IF FND_API.to_Boolean( p_init_msg_list ) THEN
75: FND_MSG_PUB.initialize;
76: END IF;
77:
78: -- Debug Message
79: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 79: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

75: FND_MSG_PUB.initialize;
76: END IF;
77:
78: -- Debug Message
79: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
80: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_MEMBER_PUB.Convert_Partner_To_Id Begin');
81: END IF;
82:
83: Open Get_Ptr_Salesforce_id(p_partner_customer_id, p_partner_address_id);

Line 80: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_MEMBER_PUB.Convert_Partner_To_Id Begin');

76: END IF;
77:
78: -- Debug Message
79: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
80: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_MEMBER_PUB.Convert_Partner_To_Id Begin');
81: END IF;
82:
83: Open Get_Ptr_Salesforce_id(p_partner_customer_id, p_partner_address_id);
84: IF (Get_Ptr_Salesforce_id%ROWCOUNT > 1) Then

Line 86: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN

82:
83: Open Get_Ptr_Salesforce_id(p_partner_customer_id, p_partner_address_id);
84: IF (Get_Ptr_Salesforce_id%ROWCOUNT > 1) Then
85:
86: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
87: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_MEMBER_PUB - Found duplicated partner');
88: END IF;
89: End if;
90:

Line 87: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_MEMBER_PUB - Found duplicated partner');

83: Open Get_Ptr_Salesforce_id(p_partner_customer_id, p_partner_address_id);
84: IF (Get_Ptr_Salesforce_id%ROWCOUNT > 1) Then
85:
86: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
87: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_MEMBER_PUB - Found duplicated partner');
88: END IF;
89: End if;
90:
91: Fetch Get_Ptr_Salesforce_id INTO x_sales_member_rec.salesforce_id

Line 106: FND_MSG_PUB.Count_And_Get

102: x_return_status := FND_API.G_RET_STS_SUCCESS;
103:
104:
105: -- Standard call to get message count and if count is 1, get message info.
106: FND_MSG_PUB.Count_And_Get
107: ( p_count => x_msg_count,
108: p_data => x_msg_data );
109:
110: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

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

106: FND_MSG_PUB.Count_And_Get
107: ( p_count => x_msg_count,
108: p_data => x_msg_data );
109:
110: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
111: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_MEMBER_PUB.Convert_Partner_To_Id End');
112: END IF;
113:
114:

Line 111: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_MEMBER_PUB.Convert_Partner_To_Id End');

107: ( p_count => x_msg_count,
108: p_data => x_msg_data );
109:
110: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
111: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_MEMBER_PUB.Convert_Partner_To_Id End');
112: END IF;
113:
114:
115: EXCEPTION

Line 119: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN

115: EXCEPTION
116:
117: WHEN NO_DATA_FOUND THEN
118:
119: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
120: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_MEMBER_PUB - Cannot Find Sales Partner');
121: END IF;
122:
123: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 120: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_MEMBER_PUB - Cannot Find Sales Partner');

116:
117: WHEN NO_DATA_FOUND THEN
118:
119: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
120: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_MEMBER_PUB - Cannot Find Sales Partner');
121: END IF;
122:
123: x_return_status := FND_API.G_RET_STS_ERROR ;
124: x_sales_member_rec := G_MISS_SALES_MEMBER_REC;

Line 130: FND_MSG_PUB.Count_And_Get

126: WHEN FND_API.G_EXC_ERROR THEN
127:
128: x_return_status := FND_API.G_RET_STS_ERROR ;
129:
130: FND_MSG_PUB.Count_And_Get
131: ( p_count => x_msg_count,
132: p_data => x_msg_data
133: );
134:

Line 140: FND_MSG_PUB.Count_And_Get

136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
137:
138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
139:
140: FND_MSG_PUB.Count_And_Get
141: ( p_count => x_msg_count,
142: p_data => x_msg_data
143: );
144:

Line 151: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

147:
148:
149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
150:
151: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
152: THEN
153: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
154: END IF;
155:

Line 153: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
150:
151: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
152: THEN
153: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
154: END IF;
155:
156: FND_MSG_PUB.Count_And_Get
157: ( p_count => x_msg_count,

Line 156: FND_MSG_PUB.Count_And_Get

152: THEN
153: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
154: END IF;
155:
156: FND_MSG_PUB.Count_And_Get
157: ( p_count => x_msg_count,
158: p_data => x_msg_data
159: );
160:

Line 219: FND_MSG_PUB.initialize;

215:
216:
217: -- Initialize message list if p_init_msg_list is set to TRUE.
218: IF FND_API.to_Boolean( p_init_msg_list ) THEN
219: FND_MSG_PUB.initialize;
220: END IF;
221:
222: -- Debug Message
223: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

Line 223: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

219: FND_MSG_PUB.initialize;
220: END IF;
221:
222: -- Debug Message
223: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
224: THEN
225: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_MEMBER_PUB.Convert_SFID_to_Values - BEGIN');
226: END IF;
227:

Line 225: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_MEMBER_PUB.Convert_SFID_to_Values - BEGIN');

221:
222: -- Debug Message
223: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
224: THEN
225: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_MEMBER_PUB.Convert_SFID_to_Values - BEGIN');
226: END IF;
227:
228: -- Initialize API return status to success
229: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 244: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

240: -- This simple conversion rountine does not check environment
241:
242:
243:
244: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
245: THEN
246: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_MEMBER_PUB - Searching Sales Member');
247: END IF;
248:

Line 246: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_MEMBER_PUB - Searching Sales Member');

242:
243:
244: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
245: THEN
246: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_MEMBER_PUB - Searching Sales Member');
247: END IF;
248:
249:
250:

Line 269: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

265:
266:
267: -- If salesmember is a person, lookup person info.
268: If (x_sales_member_rec.type = 'EMPLOYEE') Then
269: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
270: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_MEMBER_PUB - Searching Sales Person Info');
271: END IF;
272:
273: Open C_GetPersonInfo(x_sales_member_rec.employee_person_id);

Line 270: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_MEMBER_PUB - Searching Sales Person Info');

266:
267: -- If salesmember is a person, lookup person info.
268: If (x_sales_member_rec.type = 'EMPLOYEE') Then
269: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
270: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_MEMBER_PUB - Searching Sales Person Info');
271: END IF;
272:
273: Open C_GetPersonInfo(x_sales_member_rec.employee_person_id);
274: Fetch C_GetPersonInfo into

Line 283: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

279: Close C_GetPersonInfo;
280:
281: -- Else if salesmember is a sales partner, call Accounts API's for info
282: Elsif (x_sales_member_rec.type = 'PARTNER') Then
283: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
284: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_MEMBER_PUB - Searching Sales Partner Info');
285: END IF;
286: -- CODE TO BE INSERTED
287: -- Need to invoke Accounts API here for the info

Line 284: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_MEMBER_PUB - Searching Sales Partner Info');

280:
281: -- Else if salesmember is a sales partner, call Accounts API's for info
282: Elsif (x_sales_member_rec.type = 'PARTNER') Then
283: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
284: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_MEMBER_PUB - Searching Sales Partner Info');
285: END IF;
286: -- CODE TO BE INSERTED
287: -- Need to invoke Accounts API here for the info
288: End if;

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

291: EXCEPTION
292:
293: WHEN NO_DATA_FOUND THEN
294:
295: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
296: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_MEMBER_PUB Cannot find Salesmember Info');
297: END IF;
298:
299: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 296: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_MEMBER_PUB Cannot find Salesmember Info');

292:
293: WHEN NO_DATA_FOUND THEN
294:
295: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
296: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_MEMBER_PUB Cannot find Salesmember Info');
297: END IF;
298:
299: x_return_status := FND_API.G_RET_STS_ERROR ;
300:

Line 301: FND_MSG_PUB.Count_And_Get

297: END IF;
298:
299: x_return_status := FND_API.G_RET_STS_ERROR ;
300:
301: FND_MSG_PUB.Count_And_Get
302: ( p_count => x_msg_count,
303: p_data => x_msg_data
304: );
305: return;

Line 317: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

313:
314: -- Success Message
315: -- MMSG
316: /*
317: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
318: THEN
319: FND_MESSAGE.Set_Name('AS', 'API_SUCCESS');
320: FND_MESSAGE.Set_Token('ROW', 'AS_OPPORTUNITY', TRUE);
321: FND_MSG_PUB.Add;

Line 321: FND_MSG_PUB.Add;

317: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
318: THEN
319: FND_MESSAGE.Set_Name('AS', 'API_SUCCESS');
320: FND_MESSAGE.Set_Token('ROW', 'AS_OPPORTUNITY', TRUE);
321: FND_MSG_PUB.Add;
322: END IF;
323: */
324:
325: -- Debug Message

Line 326: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

322: END IF;
323: */
324:
325: -- Debug Message
326: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
327: THEN
328: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_MEMBER_PUB.Convert_SFID_to_Values End');
329: --FND_MESSAGE.Set_Name('AS_SALES_MEMBER_PUB.Convert_SFID_to_Values End');
330: --FND_MSG_PUB.Add;

Line 328: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_MEMBER_PUB.Convert_SFID_to_Values End');

324:
325: -- Debug Message
326: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
327: THEN
328: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_MEMBER_PUB.Convert_SFID_to_Values End');
329: --FND_MESSAGE.Set_Name('AS_SALES_MEMBER_PUB.Convert_SFID_to_Values End');
330: --FND_MSG_PUB.Add;
331: END IF;
332:

Line 330: --FND_MSG_PUB.Add;

326: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
327: THEN
328: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_MEMBER_PUB.Convert_SFID_to_Values End');
329: --FND_MESSAGE.Set_Name('AS_SALES_MEMBER_PUB.Convert_SFID_to_Values End');
330: --FND_MSG_PUB.Add;
331: END IF;
332:
333: -- Standard call to get message count and if count is 1, get message info.
334: FND_MSG_PUB.Count_And_Get

Line 334: FND_MSG_PUB.Count_And_Get

330: --FND_MSG_PUB.Add;
331: END IF;
332:
333: -- Standard call to get message count and if count is 1, get message info.
334: FND_MSG_PUB.Count_And_Get
335: ( p_count => x_msg_count,
336: p_data => x_msg_data
337: );
338:

Line 346: FND_MSG_PUB.Count_And_Get

342: WHEN FND_API.G_EXC_ERROR THEN
343:
344: x_return_status := FND_API.G_RET_STS_ERROR ;
345:
346: FND_MSG_PUB.Count_And_Get
347: ( p_count => x_msg_count,
348: p_data => x_msg_data
349: );
350:

Line 356: FND_MSG_PUB.Count_And_Get

352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
353:
354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
355:
356: FND_MSG_PUB.Count_And_Get
357: ( p_count => x_msg_count,
358: p_data => x_msg_data
359: );
360:

Line 367: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

363:
364:
365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
366:
367: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
368: THEN
369: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
370: END IF;
371:

Line 369: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
366:
367: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
368: THEN
369: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
370: END IF;
371:
372: FND_MSG_PUB.Count_And_Get
373: ( p_count => x_msg_count,

Line 372: FND_MSG_PUB.Count_And_Get

368: THEN
369: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
370: END IF;
371:
372: FND_MSG_PUB.Count_And_Get
373: ( p_count => x_msg_count,
374: p_data => x_msg_data
375: );
376: