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

Line 130: --FND_MSG_PUB.G_MSG_LEVEL_THRESHOLD := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;

126:
127: l_is_partner_user VARCHAR2(1) := 'N';
128:
129: BEGIN
130: --FND_MSG_PUB.G_MSG_LEVEL_THRESHOLD := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
131:
132: -- Standard call to check for call compatibility.
133: IF NOT FND_API.Compatible_API_Call(l_api_version_number,
134: p_api_version_number,

Line 143: fnd_msg_pub.initialize;

139: END IF;
140:
141: -- Initialize message list if p_init_msg_list is set to TRUE.
142: IF FND_API.to_Boolean( p_init_msg_list ) THEN
143: fnd_msg_pub.initialize;
144: END IF;
145:
146: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
147: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

Line 146: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

142: IF FND_API.to_Boolean( p_init_msg_list ) THEN
143: fnd_msg_pub.initialize;
144: END IF;
145:
146: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
147: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
148: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' , access > ' || p_access_id || ', lead_id > ' || p_lead_id || ', salesforce > ' || l_salesforce_id || ', api version > ' || p_api_version_number);
149: fnd_msg_pub.Add;
150: END IF;

Line 149: fnd_msg_pub.Add;

145:
146: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
147: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
148: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' , access > ' || p_access_id || ', lead_id > ' || p_lead_id || ', salesforce > ' || l_salesforce_id || ', api version > ' || p_api_version_number);
149: fnd_msg_pub.Add;
150: END IF;
151:
152: -- Initialize API return status to success
153: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 155: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

151:
152: -- Initialize API return status to success
153: x_return_status := FND_API.G_RET_STS_SUCCESS;
154:
155: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
156: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
157: fnd_message.Set_Token('TEXT', 'before pv_assignment_pvt.GetWorkflowID');
158: fnd_msg_pub.Add;
159: END IF;

Line 158: fnd_msg_pub.Add;

154:
155: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
156: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
157: fnd_message.Set_Token('TEXT', 'before pv_assignment_pvt.GetWorkflowID');
158: fnd_msg_pub.Add;
159: END IF;
160:
161: -- if its a customer, lead_id will be null
162: if p_lead_id is null then

Line 186: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

182: RAISE FND_API.G_EXC_ERROR;
183: END IF;
184:
185: -- Debug Message
186: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
187: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
188: fnd_message.Set_Token('TEXT', 'After pv_assignment_pvt.GetWorkflowID : wf status : ' || l_wf_status);
189: fnd_msg_pub.Add;
190: END IF;

Line 189: fnd_msg_pub.Add;

185: -- Debug Message
186: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
187: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
188: fnd_message.Set_Token('TEXT', 'After pv_assignment_pvt.GetWorkflowID : wf status : ' || l_wf_status);
189: fnd_msg_pub.Add;
190: END IF;
191:
192: OPEN lc_get_rel_type (pc_salesforce_id => l_salesforce_id);
193: FETCH lc_get_rel_type

Line 197: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

193: FETCH lc_get_rel_type
194: INTO l_relationship_type;
195: CLOSE lc_get_rel_type;
196:
197: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
198: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
199: fnd_message.Set_Token('TEXT', 'Relationship Type : ' || l_relationship_type);
200: fnd_msg_pub.Add;
201: END IF;

Line 200: fnd_msg_pub.Add;

196:
197: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
198: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
199: fnd_message.Set_Token('TEXT', 'Relationship Type : ' || l_relationship_type);
200: fnd_msg_pub.Add;
201: END IF;
202:
203: -- wf_status could be OPEN and routing_status ACTIVE in case of Joint
204: IF l_wf_status = g_wf_status_open and l_routing_status <> 'ACTIVE' THEN

Line 213: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

209: FETCH lc_get_rel_type
210: INTO l_relationship_type;
211: CLOSE lc_get_rel_type;
212:
213: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
214: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
215: fnd_message.Set_Token('TEXT', 'Relationship Type : ' || l_relationship_type);
216: fnd_msg_pub.Add;
217: END IF;

Line 216: fnd_msg_pub.Add;

212:
213: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
214: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
215: fnd_message.Set_Token('TEXT', 'Relationship Type : ' || l_relationship_type);
216: fnd_msg_pub.Add;
217: END IF;
218: */
219: IF (l_relationship_type IS NULL) THEN
220: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

Line 220: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

216: fnd_msg_pub.Add;
217: END IF;
218: */
219: IF (l_relationship_type IS NULL) THEN
220: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
221: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
222: fnd_message.Set_Token('TEXT', 'Resource id: ' || l_salesforce_id || ' is not a partner user. Returning');
223: fnd_msg_pub.Add;
224: END IF;

Line 223: fnd_msg_pub.Add;

219: IF (l_relationship_type IS NULL) THEN
220: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
221: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
222: fnd_message.Set_Token('TEXT', 'Resource id: ' || l_salesforce_id || ' is not a partner user. Returning');
223: fnd_msg_pub.Add;
224: END IF;
225: return;
226: ELSIF l_relationship_type = 'PARTNER_OF' THEN
227: fnd_message.SET_NAME('PV', 'PV_ADDSLSTEAM_NOT_ALLOWED'); -- Change message 1 ********************

Line 228: fnd_msg_pub.ADD;

224: END IF;
225: return;
226: ELSIF l_relationship_type = 'PARTNER_OF' THEN
227: fnd_message.SET_NAME('PV', 'PV_ADDSLSTEAM_NOT_ALLOWED'); -- Change message 1 ********************
228: fnd_msg_pub.ADD;
229: RAISE FND_API.G_EXC_ERROR;
230: END IF;
231:
232: ELSIF p_mode = 'DELETE' or p_mode = 'UPDATE' then

Line 234: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

230: END IF;
231:
232: ELSIF p_mode = 'DELETE' or p_mode = 'UPDATE' then
233:
234: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
235: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
236: fnd_message.Set_Token('TEXT', 'In Delete / Update block ');
237: fnd_msg_pub.Add;
238: END IF;

Line 237: fnd_msg_pub.Add;

233:
234: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
235: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
236: fnd_message.Set_Token('TEXT', 'In Delete / Update block ');
237: fnd_msg_pub.Add;
238: END IF;
239:
240: OPEN lc_get_prm_flag(pc_access_id => p_access_id);
241: FETCH lc_get_prm_flag

Line 245: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

241: FETCH lc_get_prm_flag
242: INTO l_prm_keep_flag;
243: CLOSE lc_get_prm_flag;
244:
245: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
246: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
247: fnd_message.Set_Token('TEXT', 'After PRM KEEP FLAG check : ' || l_prm_keep_flag);
248: fnd_msg_pub.Add;
249: END IF;

Line 248: fnd_msg_pub.Add;

244:
245: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
246: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
247: fnd_message.Set_Token('TEXT', 'After PRM KEEP FLAG check : ' || l_prm_keep_flag);
248: fnd_msg_pub.Add;
249: END IF;
250:
251: IF (l_prm_keep_flag = 'Y') THEN
252: fnd_message.SET_NAME('PV', 'PV_UPDSLSTEAM_NOT_ALLOWED'); -- Change message 1 ********************

Line 253: fnd_msg_pub.ADD;

249: END IF;
250:
251: IF (l_prm_keep_flag = 'Y') THEN
252: fnd_message.SET_NAME('PV', 'PV_UPDSLSTEAM_NOT_ALLOWED'); -- Change message 1 ********************
253: fnd_msg_pub.ADD;
254: RAISE FND_API.G_EXC_ERROR;
255: END IF;
256:
257: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

Line 257: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

253: fnd_msg_pub.ADD;
254: RAISE FND_API.G_EXC_ERROR;
255: END IF;
256:
257: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
258: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
259: fnd_message.Set_Token('TEXT', 'Success ..... ');
260: fnd_msg_pub.Add;
261: END IF;

Line 260: fnd_msg_pub.Add;

256:
257: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
258: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
259: fnd_message.Set_Token('TEXT', 'Success ..... ');
260: fnd_msg_pub.Add;
261: END IF;
262:
263: END IF;
264:

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

296: l_is_partner_user = 'Y' )
297:
298: then
299:
300: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
301: FND_MESSAGE.Set_Name('PV', 'PV_USER_NOT_UPD_DEL_EXT_SLSTM');
302: --FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',p_attribute_rec.name );
303: --FND_MESSAGE.Set_Token('RESPONSIBILITY_LIST',substr(l_being_used_list,2) );
304: FND_MSG_PUB.Add;

Line 304: FND_MSG_PUB.Add;

300: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
301: FND_MESSAGE.Set_Name('PV', 'PV_USER_NOT_UPD_DEL_EXT_SLSTM');
302: --FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',p_attribute_rec.name );
303: --FND_MESSAGE.Set_Token('RESPONSIBILITY_LIST',substr(l_being_used_list,2) );
304: FND_MSG_PUB.Add;
305: END IF;
306: RAISE FND_API.G_EXC_ERROR;
307: end if;
308: end if;

Line 313: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

309:
310:
311:
312: -- Standard call to get message count and if count is 1, get message info.
313: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
314: p_count => x_msg_count,
315: p_data => x_msg_data);
316:
317: EXCEPTION

Line 320: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

316:
317: EXCEPTION
318:
319: WHEN NO_DATA_FOUND THEN
320: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
321: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
322: fnd_message.Set_Token('TEXT', 'NO Data found ..');
323: fnd_msg_pub.Add;
324: END IF;

Line 323: fnd_msg_pub.Add;

319: WHEN NO_DATA_FOUND THEN
320: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
321: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
322: fnd_message.Set_Token('TEXT', 'NO Data found ..');
323: fnd_msg_pub.Add;
324: END IF;
325:
326: WHEN FND_API.G_EXC_ERROR THEN
327:

Line 329: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

325:
326: WHEN FND_API.G_EXC_ERROR THEN
327:
328: x_return_status := FND_API.G_RET_STS_ERROR ;
329: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
330: p_count => x_msg_count,
331: p_data => x_msg_data);
332:
333: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 336: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

332:
333: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
334:
335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
336: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
337: p_count => x_msg_count,
338: p_data => x_msg_data);
339:
340: WHEN OTHERS THEN

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

339:
340: WHEN OTHERS THEN
341:
342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
343: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
344: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
345: p_count => x_msg_count,
346: p_data => x_msg_data);
347:

Line 344: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

340: WHEN OTHERS THEN
341:
342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
343: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
344: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
345: p_count => x_msg_count,
346: p_data => x_msg_data);
347:
348: END Validate_Salesteam;

Line 368: --FND_MSG_PUB.G_MSG_LEVEL_THRESHOLD := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;

364:
365: l_mode CONSTANT VARCHAR2(20) := 'CREATE';
366:
367: BEGIN
368: --FND_MSG_PUB.G_MSG_LEVEL_THRESHOLD := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
369: -- Standard call to check for call compatibility.
370: IF NOT FND_API.Compatible_API_Call(l_api_version_number,
371: p_api_version_number,
372: l_api_name,

Line 380: fnd_msg_pub.initialize;

376: END IF;
377:
378: -- Initialize message list if p_init_msg_list is set to TRUE.
379: IF FND_API.to_Boolean( p_init_msg_list ) THEN
380: fnd_msg_pub.initialize;
381: END IF;
382:
383: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
384: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

Line 383: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

379: IF FND_API.to_Boolean( p_init_msg_list ) THEN
380: fnd_msg_pub.initialize;
381: END IF;
382:
383: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
384: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
385: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' ' || p_lead_id || ' ' || p_salesforce_id || ' ' || p_api_version_number);
386: fnd_msg_pub.Add;
387: END IF;

Line 386: fnd_msg_pub.Add;

382:
383: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
384: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
385: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' ' || p_lead_id || ' ' || p_salesforce_id || ' ' || p_api_version_number);
386: fnd_msg_pub.Add;
387: END IF;
388:
389: -- Initialize API return status to success
390: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 415: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

411: RAISE FND_API.G_EXC_ERROR;
412: END IF;
413:
414: -- Standard call to get message count and if count is 1, get message info.
415: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
416: p_count => x_msg_count,
417: p_data => x_msg_data);
418:
419: EXCEPTION

Line 424: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

420:
421: WHEN FND_API.G_EXC_ERROR THEN
422:
423: x_return_status := FND_API.G_RET_STS_ERROR ;
424: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
425: p_count => x_msg_count,
426: p_data => x_msg_data);
427:
428: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 431: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

427:
428: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
429:
430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
431: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
432: p_count => x_msg_count,
433: p_data => x_msg_data);
434:
435: WHEN OTHERS THEN

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

434:
435: WHEN OTHERS THEN
436:
437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
438: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
439: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
440: p_count => x_msg_count,
441: p_data => x_msg_data);
442:

Line 439: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

435: WHEN OTHERS THEN
436:
437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
438: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
439: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
440: p_count => x_msg_count,
441: p_data => x_msg_data);
442:
443: END Create_Salesteam_Pre;

Line 472: fnd_msg_pub.initialize;

468: END IF;
469:
470: -- Initialize message list if p_init_msg_list is set to TRUE.
471: IF FND_API.to_Boolean( p_init_msg_list ) THEN
472: fnd_msg_pub.initialize;
473: END IF;
474:
475: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
476: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

Line 475: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

471: IF FND_API.to_Boolean( p_init_msg_list ) THEN
472: fnd_msg_pub.initialize;
473: END IF;
474:
475: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
476: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
477: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' , access id : ' || p_access_id );
478: fnd_msg_pub.Add;
479: END IF;

Line 478: fnd_msg_pub.Add;

474:
475: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
476: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
477: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' , access id : ' || p_access_id );
478: fnd_msg_pub.Add;
479: END IF;
480:
481: -- Initialize API return status to success
482: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 503: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

499: RAISE FND_API.G_EXC_ERROR;
500: END IF;
501:
502: -- Standard call to get message count and if count is 1, get message info.
503: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
504: p_count => x_msg_count,
505: p_data => x_msg_data);
506:
507: EXCEPTION

Line 512: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

508:
509: WHEN FND_API.G_EXC_ERROR THEN
510:
511: x_return_status := FND_API.G_RET_STS_ERROR ;
512: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
513: p_count => x_msg_count,
514: p_data => x_msg_data);
515:
516: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 519: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

515:
516: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
517:
518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
519: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
520: p_count => x_msg_count,
521: p_data => x_msg_data);
522:
523: WHEN OTHERS THEN

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

522:
523: WHEN OTHERS THEN
524:
525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
526: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
527: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
528: p_count => x_msg_count,
529: p_data => x_msg_data);
530:

Line 527: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

523: WHEN OTHERS THEN
524:
525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
526: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
527: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
528: p_count => x_msg_count,
529: p_data => x_msg_data);
530:
531: END Update_Salesteam_Pre;

Line 550: --FND_MSG_PUB.g_msg_level_threshold := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;

546: l_mode CONSTANT VARCHAR2(20) := 'DELETE';
547:
548: BEGIN
549:
550: --FND_MSG_PUB.g_msg_level_threshold := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
551:
552: -- Standard call to check for call compatibility.
553: IF NOT FND_API.Compatible_API_Call(l_api_version_number,
554: p_api_version_number,

Line 563: fnd_msg_pub.initialize;

559: END IF;
560:
561: -- Initialize message list if p_init_msg_list is set to TRUE.
562: IF FND_API.to_Boolean( p_init_msg_list ) THEN
563: fnd_msg_pub.initialize;
564: END IF;
565:
566:
567: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

Line 567: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

563: fnd_msg_pub.initialize;
564: END IF;
565:
566:
567: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
568: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
569: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' , access id : ' || p_access_id );
570: fnd_msg_pub.Add;
571: END IF;

Line 570: fnd_msg_pub.Add;

566:
567: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
568: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
569: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' , access id : ' || p_access_id );
570: fnd_msg_pub.Add;
571: END IF;
572:
573: -- Initialize API return status to success
574: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 594: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

590: RAISE FND_API.G_EXC_ERROR;
591: END IF;
592:
593: -- Standard call to get message count and if count is 1, get message info.
594: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
595: p_count => x_msg_count,
596: p_data => x_msg_data);
597:
598: EXCEPTION

Line 603: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

599:
600: WHEN FND_API.G_EXC_ERROR THEN
601:
602: x_return_status := FND_API.G_RET_STS_ERROR ;
603: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
604: p_count => x_msg_count,
605: p_data => x_msg_data);
606:
607: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 610: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

606:
607: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
608:
609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
610: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
611: p_count => x_msg_count,
612: p_data => x_msg_data);
613:
614: WHEN OTHERS THEN

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

613:
614: WHEN OTHERS THEN
615:
616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
617: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
618: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
619: p_count => x_msg_count,
620: p_data => x_msg_data);
621:

Line 618: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

614: WHEN OTHERS THEN
615:
616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
617: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
618: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
619: p_count => x_msg_count,
620: p_data => x_msg_data);
621:
622: END Delete_Salesteam_Pre;